server/api/campaign/campaign.controller.js

   1 // *************************************************************************
   2 // *                                                                       *
   3 // * xCALLY Motion -  The Omnichannel Contact Center                       *
   4 // * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
   5 // *                                                                       *
   6 // *************************************************************************
   7 // *                                                                       *
   8 // * Email: info@xcally.com                                                *
   9 // * Website: https://www.xcally.com                                       *
  10 // *                                                                       *
  11 // *************************************************************************
  12 // *                                                                       *
  13 // * The SOFTWARE PRODUCT is protected by copyright laws and international *
  14 // * copyright treaties, as well as other intellectual property laws and   *
  15 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
  16 // *                                                                       *
  17 // *************************************************************************
  18 var _0x3eae=['Campaign','rawAttributes','type','key','map','name','query','keys','filters','intersection','model','fields','attributes','hasOwnProperty','nolimit','order','sort','pick','filter','merge','where','VIRTUAL','options','includeAll','rows','show','params','length','catch','body','user','role','UserProfileSection','find','userProfileId','autoAssociation','create','include','omit','updatedAt','createdAt','Unable\x20to\x20retrieve\x20the\x20current\x20user','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','getHoppers','CmHopper','CampaignId','getHopperHistories','findOne','CmHopperHistory','findAll','getHopperFinals','CmHopperFinal','CmHopperBlack','getLists','CmList','addLists','ids','spread','dialCheckDuplicateType','always','insert','into','cm_hopper','fromQuery','phone','scheduledAt','ContactId','field','NOW()','CmListId','toString','ListId','from','cm_contacts','deletedAt\x20IS\x20NULL','phone\x20NOT\x20IN\x20(?)','select','COALESCE(calleridnum,\x27\x27)','cm_hopper_final','CampaignId\x20=\x20?','onlyIfOpen','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','COALESCE(phone,\x27\x27)','h.id','ci.item','cm_contact_has_items','join','h.ContactId\x20=\x20ci.CmContactId','h.ListId\x20=\x20?','h.CampaignId=?','h.createdAt\x20=\x20?','push','sequelize','all','removeLists','getBlackLists','addBlackLists','format','YYYY-MM-DD\x20HH:mm:ss','cm_hopper_black','removeBlackLists','zip-dir','fast-json-patch','moment','bluebird','mustache','sox','to-csv','fs-extra','lodash','crypto','desk.js','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../mysqldb','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','reject','save','update','destroy','then','get','IvrCampaigns','UserProfileResource','error','stack','index'];(function(_0x4e9628,_0x250573){var _0x27bc8c=function(_0xb3b7ae){while(--_0xb3b7ae){_0x4e9628['push'](_0x4e9628['shift']());}};_0x27bc8c(++_0x250573);}(_0x3eae,0x66));var _0xe3ea=function(_0xf35bc1,_0x510803){_0xf35bc1=_0xf35bc1-0x0;var _0xa6b162=_0x3eae[_0xf35bc1];return _0xa6b162;};'use strict';var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require(_0xe3ea('0x0'));var jsonpatch=require(_0xe3ea('0x1'));var rp=require('request-promise');var moment=require(_0xe3ea('0x2'));var BPromise=require(_0xe3ea('0x3'));var Mustache=require(_0xe3ea('0x4'));var util=require('util');var path=require('path');var sox=require(_0xe3ea('0x5'));var csv=require(_0xe3ea('0x6'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0xe3ea('0x7'));var _=require(_0xe3ea('0x8'));var squel=require('squel');var crypto=require(_0xe3ea('0x9'));var jsforce=require('jsforce');var deskjs=require(_0xe3ea('0xa'));var toCsv=require(_0xe3ea('0x6'));var querystring=require(_0xe3ea('0xb'));var Papa=require('papaparse');var Redis=require(_0xe3ea('0xc'));var authService=require(_0xe3ea('0xd'));var qs=require(_0xe3ea('0xe'));var as=require(_0xe3ea('0xf'));var hardwareService=require(_0xe3ea('0x10'));var logger=require(_0xe3ea('0x11'))(_0xe3ea('0x12'));var utils=require(_0xe3ea('0x13'));var config=require('../../config/environment');var licenseUtil=require('../../config/license/util');var db=require(_0xe3ea('0x14'))['db'];function respondWithStatusCode(_0x6a9294,_0x36c2dd){_0x36c2dd=_0x36c2dd||0xcc;return function(_0x247139){if(_0x247139){return _0x6a9294[_0xe3ea('0x15')](_0x36c2dd);}return _0x6a9294[_0xe3ea('0x16')](_0x36c2dd)[_0xe3ea('0x17')]();};}function respondWithResult(_0x2b36ec,_0x31357a){_0x31357a=_0x31357a||0xc8;return function(_0x11f560){if(_0x11f560){return _0x2b36ec[_0xe3ea('0x16')](_0x31357a)[_0xe3ea('0x18')](_0x11f560);}};}function respondWithFilteredResult(_0x445775,_0x492c29){return function(_0x3c3700){if(_0x3c3700){var _0x2a086a=typeof _0x492c29[_0xe3ea('0x19')]===_0xe3ea('0x1a')&&typeof _0x492c29[_0xe3ea('0x1b')]===_0xe3ea('0x1a');var _0x466d2d=_0x3c3700[_0xe3ea('0x1c')];var _0x33f6f8=_0x2a086a?0x0:_0x492c29[_0xe3ea('0x19')];var _0x3575be=_0x2a086a?_0x3c3700[_0xe3ea('0x1c')]:_0x492c29[_0xe3ea('0x19')]+_0x492c29[_0xe3ea('0x1b')];var _0x2a397b;if(_0x3575be>=_0x466d2d){_0x3575be=_0x466d2d;_0x2a397b=0xc8;}else{_0x2a397b=0xce;}_0x445775[_0xe3ea('0x16')](_0x2a397b);return _0x445775[_0xe3ea('0x1d')](_0xe3ea('0x1e'),_0x33f6f8+'-'+_0x3575be+'/'+_0x466d2d)[_0xe3ea('0x18')](_0x3c3700);}return null;};}function patchUpdates(_0x29e32e){return function(_0xd61c1c){try{jsonpatch[_0xe3ea('0x1f')](_0xd61c1c,_0x29e32e,!![]);}catch(_0xca5a4f){return BPromise[_0xe3ea('0x20')](_0xca5a4f);}return _0xd61c1c[_0xe3ea('0x21')]();};}function saveUpdates(_0x4a537d,_0x5ed42a){return function(_0x4f0e9e){if(_0x4f0e9e){return _0x4f0e9e[_0xe3ea('0x22')](_0x4a537d)['then'](function(_0x5050eb){return _0x5050eb;});}return null;};}function removeEntity(_0x350d8e,_0x19dd53){return function(_0x4cda82){if(_0x4cda82){return _0x4cda82[_0xe3ea('0x23')]()[_0xe3ea('0x24')](function(){var _0x594ba1=_0x4cda82[_0xe3ea('0x25')]({'plain':!![]});var _0x4bb839=_0xe3ea('0x26');return db[_0xe3ea('0x27')][_0xe3ea('0x23')]({'where':{'type':_0x4bb839,'resourceId':_0x594ba1['id']}})['then'](function(){return _0x4cda82;});})[_0xe3ea('0x24')](function(){_0x350d8e[_0xe3ea('0x16')](0xcc)['end']();});}};}function handleEntityNotFound(_0x522a3f,_0x5518d3){return function(_0x5bd356){if(!_0x5bd356){_0x522a3f['sendStatus'](0x194);}return _0x5bd356;};}function handleError(_0x5f1eff,_0x3accb1){_0x3accb1=_0x3accb1||0x1f4;return function(_0x3e7c9f){logger[_0xe3ea('0x28')](_0x3e7c9f[_0xe3ea('0x29')]);if(_0x3e7c9f['name']){delete _0x3e7c9f['name'];}_0x5f1eff[_0xe3ea('0x16')](_0x3accb1)['send'](_0x3e7c9f);};}exports[_0xe3ea('0x2a')]=function(_0x2b1c07,_0x73a56e){var _0x51bdd4={},_0x5c8a68={},_0x7b9638={'count':0x0,'rows':[]};var _0x10f778=_['map'](db[_0xe3ea('0x2b')][_0xe3ea('0x2c')],function(_0x3ee500){return{'name':_0x3ee500['fieldName'],'type':_0x3ee500[_0xe3ea('0x2d')][_0xe3ea('0x2e')]};});_0x5c8a68['model']=_[_0xe3ea('0x2f')](_0x10f778,_0xe3ea('0x30'));_0x5c8a68[_0xe3ea('0x31')]=_[_0xe3ea('0x32')](_0x2b1c07[_0xe3ea('0x31')]);_0x5c8a68[_0xe3ea('0x33')]=_[_0xe3ea('0x34')](_0x5c8a68[_0xe3ea('0x35')],_0x5c8a68[_0xe3ea('0x31')]);_0x51bdd4['attributes']=_['intersection'](_0x5c8a68[_0xe3ea('0x35')],qs[_0xe3ea('0x36')](_0x2b1c07[_0xe3ea('0x31')][_0xe3ea('0x36')]));_0x51bdd4[_0xe3ea('0x37')]=_0x51bdd4[_0xe3ea('0x37')]['length']?_0x51bdd4['attributes']:_0x5c8a68[_0xe3ea('0x35')];if(!_0x2b1c07[_0xe3ea('0x31')][_0xe3ea('0x38')](_0xe3ea('0x39'))){_0x51bdd4[_0xe3ea('0x1b')]=qs[_0xe3ea('0x1b')](_0x2b1c07[_0xe3ea('0x31')][_0xe3ea('0x1b')]);_0x51bdd4[_0xe3ea('0x19')]=qs[_0xe3ea('0x19')](_0x2b1c07['query'][_0xe3ea('0x19')]);}_0x51bdd4[_0xe3ea('0x3a')]=qs[_0xe3ea('0x3b')](_0x2b1c07['query']['sort']);_0x51bdd4['where']=qs[_0xe3ea('0x33')](_[_0xe3ea('0x3c')](_0x2b1c07['query'],_0x5c8a68[_0xe3ea('0x33')]),_0x10f778);if(_0x2b1c07[_0xe3ea('0x31')][_0xe3ea('0x3d')]){_0x51bdd4['where']=_[_0xe3ea('0x3e')](_0x51bdd4[_0xe3ea('0x3f')],{'$or':_[_0xe3ea('0x2f')](_0x10f778,function(_0x3a3b6c){if(_0x3a3b6c['type']!==_0xe3ea('0x40')){var _0x320c24={};_0x320c24[_0x3a3b6c[_0xe3ea('0x30')]]={'$like':'%'+_0x2b1c07['query'][_0xe3ea('0x3d')]+'%'};return _0x320c24;}})});}_0x51bdd4=_[_0xe3ea('0x3e')]({},_0x51bdd4,_0x2b1c07[_0xe3ea('0x41')]);var _0x252d3f={'where':_0x51bdd4[_0xe3ea('0x3f')]};return db[_0xe3ea('0x2b')]['count'](_0x252d3f)[_0xe3ea('0x24')](function(_0x50bc87){_0x7b9638[_0xe3ea('0x1c')]=_0x50bc87;if(_0x2b1c07[_0xe3ea('0x31')][_0xe3ea('0x42')]){_0x51bdd4['include']=[{'all':!![]}];}return db[_0xe3ea('0x2b')]['findAll'](_0x51bdd4);})[_0xe3ea('0x24')](function(_0x142057){_0x7b9638[_0xe3ea('0x43')]=_0x142057;return _0x7b9638;})['then'](respondWithFilteredResult(_0x73a56e,_0x51bdd4))['catch'](handleError(_0x73a56e,null));};exports[_0xe3ea('0x44')]=function(_0x5ccd6d,_0x185cc7){var _0x50a9ca={'raw':![],'where':{'id':_0x5ccd6d[_0xe3ea('0x45')]['id']}},_0xea2469={};_0xea2469[_0xe3ea('0x35')]=_[_0xe3ea('0x32')](db[_0xe3ea('0x2b')][_0xe3ea('0x2c')]);_0xea2469['query']=_[_0xe3ea('0x32')](_0x5ccd6d[_0xe3ea('0x31')]);_0xea2469[_0xe3ea('0x33')]=_[_0xe3ea('0x34')](_0xea2469[_0xe3ea('0x35')],_0xea2469['query']);_0x50a9ca[_0xe3ea('0x37')]=_[_0xe3ea('0x34')](_0xea2469[_0xe3ea('0x35')],qs[_0xe3ea('0x36')](_0x5ccd6d[_0xe3ea('0x31')]['fields']));_0x50a9ca[_0xe3ea('0x37')]=_0x50a9ca['attributes'][_0xe3ea('0x46')]?_0x50a9ca['attributes']:_0xea2469[_0xe3ea('0x35')];if(_0x5ccd6d[_0xe3ea('0x31')]['includeAll']){_0x50a9ca['include']=[{'all':!![]}];}_0x50a9ca=_[_0xe3ea('0x3e')]({},_0x50a9ca,_0x5ccd6d['options']);return db['Campaign']['find'](_0x50a9ca)[_0xe3ea('0x24')](handleEntityNotFound(_0x185cc7,null))[_0xe3ea('0x24')](respondWithResult(_0x185cc7,null))[_0xe3ea('0x47')](handleError(_0x185cc7,null));};exports['create']=function(_0x7b894,_0x134f3f){return db[_0xe3ea('0x2b')]['create'](_0x7b894[_0xe3ea('0x48')],{})['then'](function(_0x358a60){var _0x39bfb9=_0x7b894[_0xe3ea('0x49')][_0xe3ea('0x25')]({'plain':!![]});if(!_0x39bfb9)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x39bfb9[_0xe3ea('0x4a')]===_0xe3ea('0x49')){var _0x38cbbe=_0x358a60[_0xe3ea('0x25')]({'plain':!![]});var _0x59fafd=_0xe3ea('0x26');return db[_0xe3ea('0x4b')][_0xe3ea('0x4c')]({'where':{'name':_0x59fafd,'userProfileId':_0x39bfb9[_0xe3ea('0x4d')]},'raw':!![]})[_0xe3ea('0x24')](function(_0x59b4af){if(_0x59b4af&&_0x59b4af[_0xe3ea('0x4e')]===0x0){return db[_0xe3ea('0x27')][_0xe3ea('0x4f')]({'name':_0x38cbbe['name'],'resourceId':_0x38cbbe['id'],'type':_0x59b4af['name'],'sectionId':_0x59b4af['id']},{})[_0xe3ea('0x24')](function(){return _0x358a60;});}else{return _0x358a60;}})['catch'](function(_0x237c74){logger['error']('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x237c74);throw _0x237c74;});}return _0x358a60;})[_0xe3ea('0x24')](respondWithResult(_0x134f3f,0xc9))[_0xe3ea('0x47')](handleError(_0x134f3f,null));};exports['clone']=function(_0x1372c2,_0x1bb758){var _0x36b256={'where':{'id':_0x1372c2[_0xe3ea('0x45')]['id']}},_0x2b706c={};_0x2b706c[_0xe3ea('0x35')]=_[_0xe3ea('0x32')](db[_0xe3ea('0x2b')][_0xe3ea('0x2c')]);_0x36b256[_0xe3ea('0x37')]=_[_0xe3ea('0x34')](_0x2b706c[_0xe3ea('0x35')],qs[_0xe3ea('0x36')](_0x1372c2[_0xe3ea('0x31')][_0xe3ea('0x36')]));_0x36b256[_0xe3ea('0x37')]=_0x36b256[_0xe3ea('0x37')][_0xe3ea('0x46')]?_0x36b256['attributes']:_0x2b706c[_0xe3ea('0x35')];if(_0x1372c2['query'][_0xe3ea('0x42')]){_0x36b256[_0xe3ea('0x50')]=[{'all':!![]}];}_0x36b256=_[_0xe3ea('0x3e')]({},_0x36b256,_0x1372c2[_0xe3ea('0x41')]);return db[_0xe3ea('0x2b')]['find'](_0x36b256)[_0xe3ea('0x24')](handleEntityNotFound(_0x1bb758,null))[_0xe3ea('0x24')](function(_0x271718){if(_0x271718){var _0xf366af=_0x271718['get']({'plain':!![]});_0xf366af=qs[_0xe3ea('0x51')](_0xf366af,['id','createdAt',_0xe3ea('0x52')]);_0x1372c2['body']=_['omit'](_0x1372c2[_0xe3ea('0x48')],['id',_0xe3ea('0x53'),_0xe3ea('0x52')]);return db['Campaign'][_0xe3ea('0x4f')](_[_0xe3ea('0x3e')](_0xf366af,_0x1372c2[_0xe3ea('0x48')]),{'include':_0x1372c2[_0xe3ea('0x31')]['includeAll']?[{'all':!![]}]:undefined})[_0xe3ea('0x24')](function(_0xb736ba){var _0x4cc0bf=_0x1372c2['user'][_0xe3ea('0x25')]({'plain':!![]});if(!_0x4cc0bf)throw new Error(_0xe3ea('0x54'));if(_0x4cc0bf[_0xe3ea('0x4a')]===_0xe3ea('0x49')){var _0xcc3a95=_0xb736ba[_0xe3ea('0x25')]({'plain':!![]});var _0x1a2936=_0xe3ea('0x26');return db[_0xe3ea('0x4b')][_0xe3ea('0x4c')]({'where':{'name':_0x1a2936,'userProfileId':_0x4cc0bf[_0xe3ea('0x4d')]},'raw':!![]})[_0xe3ea('0x24')](function(_0x3e262f){if(_0x3e262f&&_0x3e262f['autoAssociation']===0x0){return db[_0xe3ea('0x27')][_0xe3ea('0x4f')]({'name':_0xcc3a95[_0xe3ea('0x30')],'resourceId':_0xcc3a95['id'],'type':_0x3e262f['name'],'sectionId':_0x3e262f['id']},{})['then'](function(){return _0xb736ba;});}else{return _0xb736ba;}})['catch'](function(_0x3e0f3a){logger['error'](_0xe3ea('0x55'),_0x3e0f3a);throw _0x3e0f3a;});}return _0xb736ba;});}})[_0xe3ea('0x24')](respondWithResult(_0x1bb758,0xc9))['catch'](handleError(_0x1bb758,null));};exports[_0xe3ea('0x22')]=function(_0x4f52f8,_0x1a2b90){if(_0x4f52f8['body']['id']){delete _0x4f52f8[_0xe3ea('0x48')]['id'];}return db['Campaign']['find']({'where':{'id':_0x4f52f8[_0xe3ea('0x45')]['id']}})[_0xe3ea('0x24')](handleEntityNotFound(_0x1a2b90,null))[_0xe3ea('0x24')](saveUpdates(_0x4f52f8[_0xe3ea('0x48')],null))[_0xe3ea('0x24')](respondWithResult(_0x1a2b90,null))[_0xe3ea('0x47')](handleError(_0x1a2b90,null));};exports[_0xe3ea('0x23')]=function(_0x23d8a1,_0x2765db){return db[_0xe3ea('0x2b')][_0xe3ea('0x4c')]({'where':{'id':_0x23d8a1[_0xe3ea('0x45')]['id']}})[_0xe3ea('0x24')](handleEntityNotFound(_0x2765db,null))[_0xe3ea('0x24')](removeEntity(_0x2765db,null))[_0xe3ea('0x47')](handleError(_0x2765db,null));};exports[_0xe3ea('0x56')]=function(_0x8e36b7,_0x2612e8,_0x26ee66){var _0x4d6179={'raw':!![],'where':{}};var _0x3efc1f={};var _0xde7504={'count':0x0,'rows':[]};return db[_0xe3ea('0x2b')]['findOne']({'where':{'id':_0x8e36b7[_0xe3ea('0x45')]['id']}})[_0xe3ea('0x24')](handleEntityNotFound(_0x2612e8,null))[_0xe3ea('0x24')](function(_0x333d39){if(_0x333d39){_0x3efc1f[_0xe3ea('0x35')]=_[_0xe3ea('0x32')](db[_0xe3ea('0x57')]['rawAttributes']);_0x3efc1f[_0xe3ea('0x31')]=_[_0xe3ea('0x32')](_0x8e36b7['query']);_0x3efc1f[_0xe3ea('0x33')]=_['intersection'](_0x3efc1f[_0xe3ea('0x35')],_0x3efc1f[_0xe3ea('0x31')]);_0x4d6179[_0xe3ea('0x37')]=_[_0xe3ea('0x34')](_0x3efc1f[_0xe3ea('0x35')],qs[_0xe3ea('0x36')](_0x8e36b7['query']['fields']));_0x4d6179['attributes']=_0x4d6179[_0xe3ea('0x37')]['length']?_0x4d6179['attributes']:_0x3efc1f[_0xe3ea('0x35')];if(!_0x8e36b7['query']['hasOwnProperty'](_0xe3ea('0x39'))){_0x4d6179['limit']=qs[_0xe3ea('0x1b')](_0x8e36b7['query']['limit']);_0x4d6179[_0xe3ea('0x19')]=qs[_0xe3ea('0x19')](_0x8e36b7[_0xe3ea('0x31')][_0xe3ea('0x19')]);}_0x4d6179['order']=qs[_0xe3ea('0x3b')](_0x8e36b7[_0xe3ea('0x31')]['sort']);_0x4d6179[_0xe3ea('0x3f')]=qs[_0xe3ea('0x33')](_[_0xe3ea('0x3c')](_0x8e36b7['query'],_0x3efc1f[_0xe3ea('0x33')]));_0x4d6179[_0xe3ea('0x3f')][_0xe3ea('0x58')]=_0x333d39['id'];if(_0x8e36b7['query'][_0xe3ea('0x3d')]){_0x4d6179[_0xe3ea('0x3f')]=_[_0xe3ea('0x3e')](_0x4d6179[_0xe3ea('0x3f')],{'$or':_['map'](_0x4d6179[_0xe3ea('0x37')],function(_0x3c5c72){var _0x3af108={};_0x3af108[_0x3c5c72]={'$like':'%'+_0x8e36b7[_0xe3ea('0x31')]['filter']+'%'};return _0x3af108;})});}_0x4d6179=_['merge']({},_0x4d6179,_0x8e36b7[_0xe3ea('0x41')]);return db[_0xe3ea('0x57')][_0xe3ea('0x1c')]({'where':_0x4d6179[_0xe3ea('0x3f')]})[_0xe3ea('0x24')](function(_0x1d02b2){_0xde7504[_0xe3ea('0x1c')]=_0x1d02b2;if(_0x8e36b7[_0xe3ea('0x31')][_0xe3ea('0x42')]){_0x4d6179[_0xe3ea('0x50')]=[{'all':!![]}];}return db['CmHopper']['findAll'](_0x4d6179);})[_0xe3ea('0x24')](function(_0x4b84c2){_0xde7504[_0xe3ea('0x43')]=_0x4b84c2;return _0xde7504;});}})[_0xe3ea('0x24')](respondWithFilteredResult(_0x2612e8,_0x4d6179))[_0xe3ea('0x47')](handleError(_0x2612e8,null));};exports[_0xe3ea('0x59')]=function(_0x10ad9f,_0x44a258,_0x8a925b){var _0xf02e07={'raw':!![],'where':{}};var _0x43e0fa={};var _0x3b7ae1={'count':0x0,'rows':[]};return db[_0xe3ea('0x2b')][_0xe3ea('0x5a')]({'where':{'id':_0x10ad9f[_0xe3ea('0x45')]['id']}})[_0xe3ea('0x24')](handleEntityNotFound(_0x44a258,null))['then'](function(_0x10e01a){if(_0x10e01a){_0x43e0fa[_0xe3ea('0x35')]=_['keys'](db[_0xe3ea('0x5b')]['rawAttributes']);_0x43e0fa[_0xe3ea('0x31')]=_['keys'](_0x10ad9f['query']);_0x43e0fa[_0xe3ea('0x33')]=_[_0xe3ea('0x34')](_0x43e0fa['model'],_0x43e0fa['query']);_0xf02e07[_0xe3ea('0x37')]=_[_0xe3ea('0x34')](_0x43e0fa[_0xe3ea('0x35')],qs['fields'](_0x10ad9f[_0xe3ea('0x31')][_0xe3ea('0x36')]));_0xf02e07['attributes']=_0xf02e07['attributes'][_0xe3ea('0x46')]?_0xf02e07[_0xe3ea('0x37')]:_0x43e0fa[_0xe3ea('0x35')];if(!_0x10ad9f[_0xe3ea('0x31')][_0xe3ea('0x38')](_0xe3ea('0x39'))){_0xf02e07[_0xe3ea('0x1b')]=qs[_0xe3ea('0x1b')](_0x10ad9f['query'][_0xe3ea('0x1b')]);_0xf02e07[_0xe3ea('0x19')]=qs[_0xe3ea('0x19')](_0x10ad9f['query']['offset']);}_0xf02e07[_0xe3ea('0x3a')]=qs['sort'](_0x10ad9f['query'][_0xe3ea('0x3b')]);_0xf02e07[_0xe3ea('0x3f')]=qs[_0xe3ea('0x33')](_[_0xe3ea('0x3c')](_0x10ad9f['query'],_0x43e0fa[_0xe3ea('0x33')]));_0xf02e07[_0xe3ea('0x3f')][_0xe3ea('0x58')]=_0x10e01a['id'];if(_0x10ad9f['query']['filter']){_0xf02e07['where']=_[_0xe3ea('0x3e')](_0xf02e07[_0xe3ea('0x3f')],{'$or':_[_0xe3ea('0x2f')](_0xf02e07[_0xe3ea('0x37')],function(_0x2d7bf9){var _0x5befaa={};_0x5befaa[_0x2d7bf9]={'$like':'%'+_0x10ad9f[_0xe3ea('0x31')][_0xe3ea('0x3d')]+'%'};return _0x5befaa;})});}_0xf02e07=_[_0xe3ea('0x3e')]({},_0xf02e07,_0x10ad9f[_0xe3ea('0x41')]);return db[_0xe3ea('0x5b')][_0xe3ea('0x1c')]({'where':_0xf02e07['where']})[_0xe3ea('0x24')](function(_0x49b1b4){_0x3b7ae1[_0xe3ea('0x1c')]=_0x49b1b4;if(_0x10ad9f[_0xe3ea('0x31')][_0xe3ea('0x42')]){_0xf02e07[_0xe3ea('0x50')]=[{'all':!![]}];}return db[_0xe3ea('0x5b')][_0xe3ea('0x5c')](_0xf02e07);})['then'](function(_0x55744e){_0x3b7ae1[_0xe3ea('0x43')]=_0x55744e;return _0x3b7ae1;});}})['then'](respondWithFilteredResult(_0x44a258,_0xf02e07))[_0xe3ea('0x47')](handleError(_0x44a258,null));};exports[_0xe3ea('0x5d')]=function(_0xa87fee,_0x140209,_0x202ba3){var _0x5bb631={'raw':!![],'where':{}};var _0x98cfd5={};var _0x177452={'count':0x0,'rows':[]};return db[_0xe3ea('0x2b')][_0xe3ea('0x5a')]({'where':{'id':_0xa87fee[_0xe3ea('0x45')]['id']}})['then'](handleEntityNotFound(_0x140209,null))[_0xe3ea('0x24')](function(_0x15b989){if(_0x15b989){_0x98cfd5[_0xe3ea('0x35')]=_[_0xe3ea('0x32')](db[_0xe3ea('0x5e')][_0xe3ea('0x2c')]);_0x98cfd5[_0xe3ea('0x31')]=_[_0xe3ea('0x32')](_0xa87fee[_0xe3ea('0x31')]);_0x98cfd5[_0xe3ea('0x33')]=_[_0xe3ea('0x34')](_0x98cfd5[_0xe3ea('0x35')],_0x98cfd5[_0xe3ea('0x31')]);_0x5bb631[_0xe3ea('0x37')]=_[_0xe3ea('0x34')](_0x98cfd5[_0xe3ea('0x35')],qs[_0xe3ea('0x36')](_0xa87fee[_0xe3ea('0x31')]['fields']));_0x5bb631[_0xe3ea('0x37')]=_0x5bb631['attributes'][_0xe3ea('0x46')]?_0x5bb631['attributes']:_0x98cfd5[_0xe3ea('0x35')];if(!_0xa87fee[_0xe3ea('0x31')][_0xe3ea('0x38')](_0xe3ea('0x39'))){_0x5bb631[_0xe3ea('0x1b')]=qs[_0xe3ea('0x1b')](_0xa87fee[_0xe3ea('0x31')][_0xe3ea('0x1b')]);_0x5bb631[_0xe3ea('0x19')]=qs[_0xe3ea('0x19')](_0xa87fee['query'][_0xe3ea('0x19')]);}_0x5bb631[_0xe3ea('0x3a')]=qs['sort'](_0xa87fee[_0xe3ea('0x31')][_0xe3ea('0x3b')]);_0x5bb631[_0xe3ea('0x3f')]=qs[_0xe3ea('0x33')](_['pick'](_0xa87fee[_0xe3ea('0x31')],_0x98cfd5['filters']));_0x5bb631[_0xe3ea('0x3f')][_0xe3ea('0x58')]=_0x15b989['id'];if(_0xa87fee['query'][_0xe3ea('0x3d')]){_0x5bb631[_0xe3ea('0x3f')]=_[_0xe3ea('0x3e')](_0x5bb631[_0xe3ea('0x3f')],{'$or':_['map'](_0x5bb631[_0xe3ea('0x37')],function(_0x16a009){var _0x374d15={};_0x374d15[_0x16a009]={'$like':'%'+_0xa87fee[_0xe3ea('0x31')][_0xe3ea('0x3d')]+'%'};return _0x374d15;})});}_0x5bb631=_['merge']({},_0x5bb631,_0xa87fee[_0xe3ea('0x41')]);return db[_0xe3ea('0x5e')][_0xe3ea('0x1c')]({'where':_0x5bb631[_0xe3ea('0x3f')]})[_0xe3ea('0x24')](function(_0xc50af9){_0x177452[_0xe3ea('0x1c')]=_0xc50af9;if(_0xa87fee[_0xe3ea('0x31')][_0xe3ea('0x42')]){_0x5bb631[_0xe3ea('0x50')]=[{'all':!![]}];}return db[_0xe3ea('0x5e')][_0xe3ea('0x5c')](_0x5bb631);})[_0xe3ea('0x24')](function(_0x26f9b2){_0x177452[_0xe3ea('0x43')]=_0x26f9b2;return _0x177452;});}})[_0xe3ea('0x24')](respondWithFilteredResult(_0x140209,_0x5bb631))['catch'](handleError(_0x140209,null));};exports['getHopperBlacks']=function(_0x1e7805,_0x434f8b,_0x289c92){var _0xd8f008={'raw':!![],'where':{}};var _0x2a6341={};var _0x1bf86a={'count':0x0,'rows':[]};return db[_0xe3ea('0x2b')][_0xe3ea('0x5a')]({'where':{'id':_0x1e7805[_0xe3ea('0x45')]['id']}})[_0xe3ea('0x24')](handleEntityNotFound(_0x434f8b,null))[_0xe3ea('0x24')](function(_0x2ca236){if(_0x2ca236){_0x2a6341[_0xe3ea('0x35')]=_['keys'](db[_0xe3ea('0x5f')][_0xe3ea('0x2c')]);_0x2a6341[_0xe3ea('0x31')]=_[_0xe3ea('0x32')](_0x1e7805['query']);_0x2a6341[_0xe3ea('0x33')]=_['intersection'](_0x2a6341[_0xe3ea('0x35')],_0x2a6341[_0xe3ea('0x31')]);_0xd8f008['attributes']=_[_0xe3ea('0x34')](_0x2a6341[_0xe3ea('0x35')],qs[_0xe3ea('0x36')](_0x1e7805['query'][_0xe3ea('0x36')]));_0xd8f008['attributes']=_0xd8f008[_0xe3ea('0x37')][_0xe3ea('0x46')]?_0xd8f008[_0xe3ea('0x37')]:_0x2a6341[_0xe3ea('0x35')];if(!_0x1e7805['query'][_0xe3ea('0x38')](_0xe3ea('0x39'))){_0xd8f008['limit']=qs[_0xe3ea('0x1b')](_0x1e7805['query'][_0xe3ea('0x1b')]);_0xd8f008[_0xe3ea('0x19')]=qs['offset'](_0x1e7805[_0xe3ea('0x31')][_0xe3ea('0x19')]);}_0xd8f008[_0xe3ea('0x3a')]=qs[_0xe3ea('0x3b')](_0x1e7805[_0xe3ea('0x31')][_0xe3ea('0x3b')]);_0xd8f008[_0xe3ea('0x3f')]=qs[_0xe3ea('0x33')](_[_0xe3ea('0x3c')](_0x1e7805[_0xe3ea('0x31')],_0x2a6341[_0xe3ea('0x33')]));_0xd8f008['where'][_0xe3ea('0x58')]=_0x2ca236['id'];if(_0x1e7805['query']['filter']){_0xd8f008['where']=_[_0xe3ea('0x3e')](_0xd8f008[_0xe3ea('0x3f')],{'$or':_['map'](_0xd8f008[_0xe3ea('0x37')],function(_0x244cbc){var _0x386d90={};_0x386d90[_0x244cbc]={'$like':'%'+_0x1e7805[_0xe3ea('0x31')][_0xe3ea('0x3d')]+'%'};return _0x386d90;})});}_0xd8f008=_[_0xe3ea('0x3e')]({},_0xd8f008,_0x1e7805[_0xe3ea('0x41')]);return db[_0xe3ea('0x5f')]['count']({'where':_0xd8f008[_0xe3ea('0x3f')]})[_0xe3ea('0x24')](function(_0x930ff3){_0x1bf86a[_0xe3ea('0x1c')]=_0x930ff3;if(_0x1e7805[_0xe3ea('0x31')]['includeAll']){_0xd8f008['include']=[{'all':!![]}];}return db['CmHopperBlack'][_0xe3ea('0x5c')](_0xd8f008);})[_0xe3ea('0x24')](function(_0xb6fc35){_0x1bf86a['rows']=_0xb6fc35;return _0x1bf86a;});}})[_0xe3ea('0x24')](respondWithFilteredResult(_0x434f8b,_0xd8f008))[_0xe3ea('0x47')](handleError(_0x434f8b,null));};exports[_0xe3ea('0x60')]=function(_0x5df445,_0x1fb091,_0x4ef61e){var _0x4a3c97={};var _0x364b91={};var _0x2d7782;var _0x462c34;return db[_0xe3ea('0x2b')][_0xe3ea('0x5a')]({'where':{'id':_0x5df445[_0xe3ea('0x45')]['id']}})[_0xe3ea('0x24')](handleEntityNotFound(_0x1fb091,null))[_0xe3ea('0x24')](function(_0x50ea71){if(_0x50ea71){_0x2d7782=_0x50ea71;_0x364b91[_0xe3ea('0x35')]=_[_0xe3ea('0x32')](db[_0xe3ea('0x61')]['rawAttributes']);_0x364b91[_0xe3ea('0x31')]=_[_0xe3ea('0x32')](_0x5df445[_0xe3ea('0x31')]);_0x364b91[_0xe3ea('0x33')]=_[_0xe3ea('0x34')](_0x364b91['model'],_0x364b91[_0xe3ea('0x31')]);_0x4a3c97[_0xe3ea('0x37')]=_['intersection'](_0x364b91[_0xe3ea('0x35')],qs[_0xe3ea('0x36')](_0x5df445[_0xe3ea('0x31')][_0xe3ea('0x36')]));_0x4a3c97['attributes']=_0x4a3c97['attributes'][_0xe3ea('0x46')]?_0x4a3c97['attributes']:_0x364b91[_0xe3ea('0x35')];_0x4a3c97[_0xe3ea('0x3a')]=qs[_0xe3ea('0x3b')](_0x5df445['query']['sort']);_0x4a3c97['where']=qs[_0xe3ea('0x33')](_[_0xe3ea('0x3c')](_0x5df445['query'],_0x364b91['filters']));if(_0x5df445['query'][_0xe3ea('0x3d')]){_0x4a3c97[_0xe3ea('0x3f')]=_[_0xe3ea('0x3e')](_0x4a3c97[_0xe3ea('0x3f')],{'$or':_[_0xe3ea('0x2f')](_0x4a3c97[_0xe3ea('0x37')],function(_0x3f7119){var _0x1b233f={};_0x1b233f[_0x3f7119]={'$like':'%'+_0x5df445[_0xe3ea('0x31')][_0xe3ea('0x3d')]+'%'};return _0x1b233f;})});}_0x4a3c97=_[_0xe3ea('0x3e')]({},_0x4a3c97,_0x5df445['options']);return _0x2d7782[_0xe3ea('0x60')](_0x4a3c97);}})['then'](function(_0x52e753){if(_0x52e753){_0x462c34=_0x52e753[_0xe3ea('0x46')];if(!_0x5df445[_0xe3ea('0x31')]['hasOwnProperty'](_0xe3ea('0x39'))){_0x4a3c97[_0xe3ea('0x1b')]=qs[_0xe3ea('0x1b')](_0x5df445[_0xe3ea('0x31')][_0xe3ea('0x1b')]);_0x4a3c97[_0xe3ea('0x19')]=qs[_0xe3ea('0x19')](_0x5df445['query'][_0xe3ea('0x19')]);}return _0x2d7782[_0xe3ea('0x60')](_0x4a3c97);}})[_0xe3ea('0x24')](function(_0x5a20e0){if(_0x5a20e0){return _0x5a20e0?{'count':_0x462c34,'rows':_0x5a20e0}:null;}})[_0xe3ea('0x24')](respondWithResult(_0x1fb091,null))[_0xe3ea('0x47')](handleError(_0x1fb091,null));};exports[_0xe3ea('0x62')]=function(_0x37460d,_0x31ebe3,_0x50ad6f){var _0x1976b1,_0x3b3b78;var _0x213354=[];var _0x60b1c6=moment()['format']('YYYY-MM-DD\x20HH:mm:ss');return db[_0xe3ea('0x2b')][_0xe3ea('0x4c')]({'where':{'id':_0x37460d[_0xe3ea('0x45')]['id']}})[_0xe3ea('0x24')](handleEntityNotFound(_0x31ebe3,null))[_0xe3ea('0x24')](function(_0x5d90a6){if(_0x5d90a6){_0x3b3b78=_0x5d90a6;return _0x5d90a6[_0xe3ea('0x62')](_0x37460d[_0xe3ea('0x48')][_0xe3ea('0x63')],_[_0xe3ea('0x51')](_0x37460d[_0xe3ea('0x48')],[_0xe3ea('0x63'),'id'])||{});}return null;})[_0xe3ea('0x64')](function(_0xf666){var _0x5bcbb5;var _0x4d47fe;_0x1976b1=_0xf666||[];var _0x4e290c=[];if(_0xf666){for(var _0x436fc8=0x0;_0x436fc8<_0xf666['length'];_0x436fc8+=0x1){var _0x4d049d=_0xf666[_0x436fc8]['get']({'plain':!![]});_0x3b3b78['dialCheckDuplicateType']=_0x37460d['body'][_0xe3ea('0x65')]?_0x37460d[_0xe3ea('0x48')][_0xe3ea('0x65')]:_0x3b3b78[_0xe3ea('0x65')];switch(_0x3b3b78['dialCheckDuplicateType']){case _0xe3ea('0x66'):_0x5bcbb5=squel[_0xe3ea('0x67')]()[_0xe3ea('0x68')](_0xe3ea('0x69'))[_0xe3ea('0x6a')]([_0xe3ea('0x6b'),_0xe3ea('0x6c'),_0xe3ea('0x6d'),'ListId',_0xe3ea('0x58'),_0xe3ea('0x53'),_0xe3ea('0x52')],squel['select']()['field'](_0xe3ea('0x6b'),_0xe3ea('0x6b'))[_0xe3ea('0x6e')](_0xe3ea('0x6f'),_0xe3ea('0x6c'))[_0xe3ea('0x6e')]('id',_0xe3ea('0x6d'))[_0xe3ea('0x6e')](_0x4d049d[_0xe3ea('0x70')][_0xe3ea('0x71')](),_0xe3ea('0x72'))[_0xe3ea('0x6e')](_0x37460d[_0xe3ea('0x45')]['id']['toString'](),_0xe3ea('0x58'))['field']('\x27'+_0x60b1c6+'\x27',_0xe3ea('0x53'))[_0xe3ea('0x6e')]('\x27'+_0x60b1c6+'\x27',_0xe3ea('0x52'))[_0xe3ea('0x73')](_0xe3ea('0x74'))['where'](_0xe3ea('0x75'))[_0xe3ea('0x3f')]('ListId\x20=\x20?',_0x4d049d['CmListId'][_0xe3ea('0x71')]())['where']('phone\x20IS\x20NOT\x20NULL')[_0xe3ea('0x3f')](_0xe3ea('0x76'),squel[_0xe3ea('0x77')]()['field'](_0xe3ea('0x78'))['from'](_0xe3ea('0x79'))[_0xe3ea('0x3f')](_0xe3ea('0x7a'),_0x37460d[_0xe3ea('0x45')]['id'][_0xe3ea('0x71')]()))[_0xe3ea('0x3f')]('phone\x20NOT\x20IN\x20(?)',squel[_0xe3ea('0x77')]()[_0xe3ea('0x6e')]('COALESCE(phone,\x27\x27)')['from'](_0xe3ea('0x69'))[_0xe3ea('0x3f')](_0xe3ea('0x7a'),_0x37460d[_0xe3ea('0x45')]['id']['toString']())))['toString']();break;case _0xe3ea('0x7b'):_0x5bcbb5=squel['insert']()[_0xe3ea('0x68')](_0xe3ea('0x69'))[_0xe3ea('0x6a')]([_0xe3ea('0x6b'),_0xe3ea('0x6c'),'ContactId',_0xe3ea('0x72'),_0xe3ea('0x58'),_0xe3ea('0x53'),'updatedAt'],squel[_0xe3ea('0x77')]()[_0xe3ea('0x6e')](_0xe3ea('0x6b'),_0xe3ea('0x6b'))['field'](_0xe3ea('0x6f'),_0xe3ea('0x6c'))[_0xe3ea('0x6e')]('id',_0xe3ea('0x6d'))['field'](_0x4d049d[_0xe3ea('0x70')][_0xe3ea('0x71')](),_0xe3ea('0x72'))['field'](_0x37460d[_0xe3ea('0x45')]['id'][_0xe3ea('0x71')](),'CampaignId')[_0xe3ea('0x6e')]('\x27'+_0x60b1c6+'\x27',_0xe3ea('0x53'))[_0xe3ea('0x6e')]('\x27'+_0x60b1c6+'\x27',_0xe3ea('0x52'))[_0xe3ea('0x73')]('cm_contacts')[_0xe3ea('0x3f')](_0xe3ea('0x75'))[_0xe3ea('0x3f')](_0xe3ea('0x7c'),_0x4d049d[_0xe3ea('0x70')][_0xe3ea('0x71')]())[_0xe3ea('0x3f')](_0xe3ea('0x7d'))[_0xe3ea('0x3f')]('phone\x20NOT\x20IN\x20(?)',squel['select']()[_0xe3ea('0x6e')](_0xe3ea('0x7e'))[_0xe3ea('0x73')](_0xe3ea('0x69'))['where'](_0xe3ea('0x7a'),_0x37460d[_0xe3ea('0x45')]['id'][_0xe3ea('0x71')]())))[_0xe3ea('0x71')]();break;default:_0x5bcbb5=squel[_0xe3ea('0x67')]()[_0xe3ea('0x68')](_0xe3ea('0x69'))[_0xe3ea('0x6a')](['phone',_0xe3ea('0x6c'),_0xe3ea('0x6d'),_0xe3ea('0x72'),_0xe3ea('0x58'),_0xe3ea('0x53'),'updatedAt'],squel['select']()[_0xe3ea('0x6e')](_0xe3ea('0x6b'),'phone')[_0xe3ea('0x6e')](_0xe3ea('0x6f'),_0xe3ea('0x6c'))['field']('id',_0xe3ea('0x6d'))['field'](_0x4d049d[_0xe3ea('0x70')][_0xe3ea('0x71')](),_0xe3ea('0x72'))[_0xe3ea('0x6e')](_0x37460d[_0xe3ea('0x45')]['id']['toString'](),_0xe3ea('0x58'))[_0xe3ea('0x6e')]('\x27'+_0x60b1c6+'\x27',_0xe3ea('0x53'))[_0xe3ea('0x6e')]('\x27'+_0x60b1c6+'\x27',_0xe3ea('0x52'))[_0xe3ea('0x73')](_0xe3ea('0x74'))['where'](_0xe3ea('0x75'))[_0xe3ea('0x3f')]('ListId\x20=\x20?',_0x4d049d[_0xe3ea('0x70')][_0xe3ea('0x71')]())['where'](_0xe3ea('0x7d')))[_0xe3ea('0x71')]();}_0x4d47fe=squel[_0xe3ea('0x67')]()[_0xe3ea('0x68')]('cm_hopper_additional_phones')['fromQuery'](['cmHopperId','scheduledAt',_0xe3ea('0x6b'),'OrderBy',_0xe3ea('0x53'),_0xe3ea('0x52')],squel['select']()['field'](_0xe3ea('0x7f'),'id')[_0xe3ea('0x6e')](_0xe3ea('0x6f'),'scheduledAt')[_0xe3ea('0x6e')](_0xe3ea('0x80'),_0xe3ea('0x6b'))[_0xe3ea('0x6e')]('ci.OrderBY','OrderBy')[_0xe3ea('0x6e')]('\x27'+_0x60b1c6+'\x27','createdAt')['field']('\x27'+_0x60b1c6+'\x27',_0xe3ea('0x52'))[_0xe3ea('0x73')](_0xe3ea('0x81'),'ci')[_0xe3ea('0x82')](_0xe3ea('0x69'),'h',_0xe3ea('0x83'))[_0xe3ea('0x3f')](_0xe3ea('0x84'),_0x4d049d[_0xe3ea('0x70')]['toString']())[_0xe3ea('0x3f')](_0xe3ea('0x85'),_0x37460d['params']['id'][_0xe3ea('0x71')]())[_0xe3ea('0x3f')](_0xe3ea('0x86'),_0x60b1c6))[_0xe3ea('0x71')]();_0x4e290c[_0xe3ea('0x87')](db[_0xe3ea('0x88')][_0xe3ea('0x31')](_0x5bcbb5));_0x213354[_0xe3ea('0x87')](db[_0xe3ea('0x88')]['query'](_0x4d47fe));}return BPromise[_0xe3ea('0x89')](_0x4e290c);}})[_0xe3ea('0x24')](function(){return BPromise[_0xe3ea('0x89')](_0x213354);})['then'](function(){return _0x1976b1;})['then'](respondWithResult(_0x31ebe3,null))[_0xe3ea('0x47')](handleError(_0x31ebe3,null));};exports[_0xe3ea('0x8a')]=function(_0xea359a,_0x3f3898,_0x21cacb){return db[_0xe3ea('0x2b')][_0xe3ea('0x4c')]({'where':{'id':_0xea359a[_0xe3ea('0x45')]['id']}})['then'](handleEntityNotFound(_0x3f3898,null))[_0xe3ea('0x24')](function(_0x429f99){if(_0x429f99){return _0x429f99[_0xe3ea('0x8a')](_0xea359a[_0xe3ea('0x31')][_0xe3ea('0x63')]);}})[_0xe3ea('0x24')](function(_0x3cf978){if(_0x3cf978){return db[_0xe3ea('0x57')][_0xe3ea('0x23')]({'where':{'ListId':_0xea359a[_0xe3ea('0x31')][_0xe3ea('0x63')],'CampaignId':_0xea359a['params']['id']}})[_0xe3ea('0x24')](function(){return _0x3cf978;});}})[_0xe3ea('0x24')](respondWithStatusCode(_0x3f3898,null))[_0xe3ea('0x47')](handleError(_0x3f3898,null));};exports[_0xe3ea('0x8b')]=function(_0xebff0e,_0x261e81,_0x1a324c){var _0x2c01e4={};var _0x14f238={};var _0x248eaf;var _0x382bb3;return db[_0xe3ea('0x2b')][_0xe3ea('0x5a')]({'where':{'id':_0xebff0e['params']['id']}})[_0xe3ea('0x24')](handleEntityNotFound(_0x261e81,null))[_0xe3ea('0x24')](function(_0x43daa3){if(_0x43daa3){_0x248eaf=_0x43daa3;_0x14f238[_0xe3ea('0x35')]=_['keys'](db[_0xe3ea('0x61')][_0xe3ea('0x2c')]);_0x14f238[_0xe3ea('0x31')]=_[_0xe3ea('0x32')](_0xebff0e['query']);_0x14f238[_0xe3ea('0x33')]=_[_0xe3ea('0x34')](_0x14f238['model'],_0x14f238[_0xe3ea('0x31')]);_0x2c01e4[_0xe3ea('0x37')]=_['intersection'](_0x14f238['model'],qs[_0xe3ea('0x36')](_0xebff0e['query'][_0xe3ea('0x36')]));_0x2c01e4[_0xe3ea('0x37')]=_0x2c01e4[_0xe3ea('0x37')][_0xe3ea('0x46')]?_0x2c01e4['attributes']:_0x14f238['model'];_0x2c01e4[_0xe3ea('0x3a')]=qs[_0xe3ea('0x3b')](_0xebff0e[_0xe3ea('0x31')][_0xe3ea('0x3b')]);_0x2c01e4[_0xe3ea('0x3f')]=qs[_0xe3ea('0x33')](_[_0xe3ea('0x3c')](_0xebff0e[_0xe3ea('0x31')],_0x14f238[_0xe3ea('0x33')]));if(_0xebff0e[_0xe3ea('0x31')][_0xe3ea('0x3d')]){_0x2c01e4['where']=_[_0xe3ea('0x3e')](_0x2c01e4[_0xe3ea('0x3f')],{'$or':_[_0xe3ea('0x2f')](_0x2c01e4[_0xe3ea('0x37')],function(_0x438f72){var _0x3884d7={};_0x3884d7[_0x438f72]={'$like':'%'+_0xebff0e[_0xe3ea('0x31')][_0xe3ea('0x3d')]+'%'};return _0x3884d7;})});}_0x2c01e4=_[_0xe3ea('0x3e')]({},_0x2c01e4,_0xebff0e[_0xe3ea('0x41')]);return _0x248eaf[_0xe3ea('0x8b')](_0x2c01e4);}})[_0xe3ea('0x24')](function(_0x4f81dc){if(_0x4f81dc){_0x382bb3=_0x4f81dc['length'];if(!_0xebff0e[_0xe3ea('0x31')]['hasOwnProperty'](_0xe3ea('0x39'))){_0x2c01e4[_0xe3ea('0x1b')]=qs[_0xe3ea('0x1b')](_0xebff0e[_0xe3ea('0x31')][_0xe3ea('0x1b')]);_0x2c01e4['offset']=qs[_0xe3ea('0x19')](_0xebff0e['query']['offset']);}return _0x248eaf[_0xe3ea('0x8b')](_0x2c01e4);}})[_0xe3ea('0x24')](function(_0x23b4f3){if(_0x23b4f3){return _0x23b4f3?{'count':_0x382bb3,'rows':_0x23b4f3}:null;}})[_0xe3ea('0x24')](respondWithResult(_0x261e81,null))[_0xe3ea('0x47')](handleError(_0x261e81,null));};exports[_0xe3ea('0x8c')]=function(_0x781e37,_0x41ccfa,_0x1e777f){var _0x138376,_0x45057e;var _0x119ad3=[];var _0x283e99=moment()[_0xe3ea('0x8d')](_0xe3ea('0x8e'));return db[_0xe3ea('0x2b')][_0xe3ea('0x4c')]({'where':{'id':_0x781e37['params']['id']}})[_0xe3ea('0x24')](handleEntityNotFound(_0x41ccfa,null))[_0xe3ea('0x24')](function(_0x173591){if(_0x173591){_0x45057e=_0x173591;return _0x173591['addBlackLists'](_0x781e37['body'][_0xe3ea('0x63')],_[_0xe3ea('0x51')](_0x781e37[_0xe3ea('0x48')],[_0xe3ea('0x63'),'id'])||{});}return null;})['spread'](function(_0x253d92){var _0x5aa476;var _0x175447;_0x138376=_0x253d92||[];var _0x3555f2=[];if(_0x253d92){for(var _0x5e2f7b=0x0;_0x5e2f7b<_0x253d92[_0xe3ea('0x46')];_0x5e2f7b+=0x1){var _0x12b9d2=_0x253d92[_0x5e2f7b][_0xe3ea('0x25')]({'plain':!![]});_0x5aa476=squel['insert']()[_0xe3ea('0x68')](_0xe3ea('0x8f'))[_0xe3ea('0x6a')]([_0xe3ea('0x6b'),_0xe3ea('0x6d'),_0xe3ea('0x72'),_0xe3ea('0x58'),_0xe3ea('0x53'),_0xe3ea('0x52')],squel[_0xe3ea('0x77')]()[_0xe3ea('0x6e')]('phone',_0xe3ea('0x6b'))[_0xe3ea('0x6e')]('id','ContactId')[_0xe3ea('0x6e')](_0x12b9d2[_0xe3ea('0x70')]['toString'](),'ListId')[_0xe3ea('0x6e')](_0x781e37[_0xe3ea('0x45')]['id'][_0xe3ea('0x71')](),_0xe3ea('0x58'))['field'](_0xe3ea('0x6f'),'createdAt')[_0xe3ea('0x6e')](_0xe3ea('0x6f'),_0xe3ea('0x52'))[_0xe3ea('0x73')](_0xe3ea('0x74'))[_0xe3ea('0x3f')](_0xe3ea('0x75'))[_0xe3ea('0x3f')](_0xe3ea('0x7c'),_0x12b9d2[_0xe3ea('0x70')][_0xe3ea('0x71')]())['where'](_0xe3ea('0x7d')))[_0xe3ea('0x71')]();_0x3555f2[_0xe3ea('0x87')](db[_0xe3ea('0x88')][_0xe3ea('0x31')](_0x5aa476));}return BPromise[_0xe3ea('0x89')](_0x3555f2);}})[_0xe3ea('0x24')](function(){return _0x138376;})[_0xe3ea('0x24')](respondWithResult(_0x41ccfa,null))['catch'](handleError(_0x41ccfa,null));};exports[_0xe3ea('0x90')]=function(_0x10968c,_0x2a5311,_0xd55366){return db['Campaign'][_0xe3ea('0x4c')]({'where':{'id':_0x10968c[_0xe3ea('0x45')]['id']}})[_0xe3ea('0x24')](handleEntityNotFound(_0x2a5311,null))[_0xe3ea('0x24')](function(_0x41832f){if(_0x41832f){return _0x41832f[_0xe3ea('0x90')](_0x10968c[_0xe3ea('0x31')][_0xe3ea('0x63')]);}})[_0xe3ea('0x24')](function(_0x3da549){if(_0x3da549){return db[_0xe3ea('0x5f')][_0xe3ea('0x23')]({'where':{'ListId':_0x10968c[_0xe3ea('0x31')]['ids'],'CampaignId':_0x10968c['params']['id']}})[_0xe3ea('0x24')](function(){return _0x3da549;});}})['then'](respondWithStatusCode(_0x2a5311,null))[_0xe3ea('0x47')](handleError(_0x2a5311,null));};