18 var _0xce21=['NOW()','field','CmListId','toString','cm_contacts','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','from','cm_hopper_final','COALESCE(phone,\x27\x27)','cm_hopper','CampaignId\x20=\x20?','onlyIfOpen','push','removeLists','ids','getBlackLists','addBlackLists','sequelize','all','removeBlackLists','html-pdf','eml-format','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','path','to-csv','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','sendStatus','status','end','count','offset','limit','Content-Range','json','apply','reject','save','update','then','destroy','get','IvrCampaigns','UserProfileResource','stack','name','index','map','Campaign','fieldName','type','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','filter','where','merge','options','includeAll','include','findAll','rows','show','params','rawAttributes','find','catch','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','omit','createdAt','updatedAt','user','role','UserProfileSection','error','getHoppers','findOne','pick','CampaignId','CmHopper','getHopperHistories','CmHopperHistory','CmHopperFinal','getHopperBlacks','CmHopperBlack','getLists','CmList','addLists','spread','dialCheckDuplicateType','insert','into','fromQuery','scheduledAt','ContactId','ListId','select','phone'];(function(_0x50d933,_0x1ec00c){var _0x437b9d=function(_0x314731){while(--_0x314731){_0x50d933['push'](_0x50d933['shift']());}};_0x437b9d(++_0x1ec00c);}(_0xce21,0x9f));var _0x1ce2=function(_0x432682,_0x253044){_0x432682=_0x432682-0x0;var _0x463d05=_0xce21[_0x432682];return _0x463d05;};'use strict';var pdf=require(_0x1ce2('0x0'));var emlformat=require(_0x1ce2('0x1'));var rimraf=require('rimraf');var zipdir=require(_0x1ce2('0x2'));var jsonpatch=require(_0x1ce2('0x3'));var rp=require(_0x1ce2('0x4'));var moment=require(_0x1ce2('0x5'));var BPromise=require(_0x1ce2('0x6'));var Mustache=require(_0x1ce2('0x7'));var util=require('util');var path=require(_0x1ce2('0x8'));var sox=require('sox');var csv=require(_0x1ce2('0x9'));var ejs=require('ejs');var fs=require('fs');var _=require(_0x1ce2('0xa'));var squel=require(_0x1ce2('0xb'));var crypto=require(_0x1ce2('0xc'));var jsforce=require(_0x1ce2('0xd'));var deskjs=require(_0x1ce2('0xe'));var toCsv=require('to-csv');var querystring=require(_0x1ce2('0xf'));var Papa=require(_0x1ce2('0x10'));var Redis=require(_0x1ce2('0x11'));var authService=require(_0x1ce2('0x12'));var qs=require(_0x1ce2('0x13'));var as=require(_0x1ce2('0x14'));var hardwareService=require(_0x1ce2('0x15'));var logger=require(_0x1ce2('0x16'))(_0x1ce2('0x17'));var utils=require(_0x1ce2('0x18'));var config=require(_0x1ce2('0x19'));var licenseUtil=require('../../config/license/util');var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x28d67d,_0x117362){_0x117362=_0x117362||0xcc;return function(_0x2065cd){if(_0x2065cd){return _0x28d67d[_0x1ce2('0x1a')](_0x117362);}return _0x28d67d[_0x1ce2('0x1b')](_0x117362)[_0x1ce2('0x1c')]();};}function respondWithResult(_0x11b814,_0x2f0650){_0x2f0650=_0x2f0650||0xc8;return function(_0x3a578a){if(_0x3a578a){return _0x11b814[_0x1ce2('0x1b')](_0x2f0650)['json'](_0x3a578a);}};}function respondWithFilteredResult(_0x48c8ea,_0x12222b){return function(_0x538530){if(_0x538530){var _0x5db4ab=_0x538530[_0x1ce2('0x1d')],_0xf5bfaf=_0x12222b[_0x1ce2('0x1e')],_0x42322b=_0x12222b[_0x1ce2('0x1e')]+_0x12222b[_0x1ce2('0x1f')],_0x4730ec;if(_0x42322b>=_0x5db4ab){_0x42322b=_0x5db4ab;_0x4730ec=0xc8;}else{_0x4730ec=0xce;}_0x48c8ea[_0x1ce2('0x1b')](_0x4730ec);return _0x48c8ea['set'](_0x1ce2('0x20'),_0xf5bfaf+'-'+_0x42322b+'/'+_0x5db4ab)[_0x1ce2('0x21')](_0x538530);}return null;};}function patchUpdates(_0x490b6f){return function(_0x5f1d09){try{jsonpatch[_0x1ce2('0x22')](_0x5f1d09,_0x490b6f,!![]);}catch(_0x387ccb){return BPromise[_0x1ce2('0x23')](_0x387ccb);}return _0x5f1d09[_0x1ce2('0x24')]();};}function saveUpdates(_0x4b64cd,_0x120442){return function(_0x563dc2){if(_0x563dc2){return _0x563dc2[_0x1ce2('0x25')](_0x4b64cd)[_0x1ce2('0x26')](function(_0xed9e19){return _0xed9e19;});}return null;};}function removeEntity(_0x2874dc,_0x380d24){return function(_0x24eaa4){if(_0x24eaa4){return _0x24eaa4[_0x1ce2('0x27')]()[_0x1ce2('0x26')](function(){var _0x31e85d=_0x24eaa4[_0x1ce2('0x28')]({'plain':!![]});var _0x8c6ff1=_0x1ce2('0x29');return db[_0x1ce2('0x2a')][_0x1ce2('0x27')]({'where':{'type':_0x8c6ff1,'resourceId':_0x31e85d['id']}})[_0x1ce2('0x26')](function(){return _0x24eaa4;});})[_0x1ce2('0x26')](function(){_0x2874dc[_0x1ce2('0x1b')](0xcc)[_0x1ce2('0x1c')]();});}};}function handleEntityNotFound(_0x517d90,_0x117ebc){return function(_0x2589f7){if(!_0x2589f7){_0x517d90[_0x1ce2('0x1a')](0x194);}return _0x2589f7;};}function handleError(_0x331e9a,_0x24ec71){_0x24ec71=_0x24ec71||0x1f4;return function(_0x21e57a){logger['error'](_0x21e57a[_0x1ce2('0x2b')]);if(_0x21e57a[_0x1ce2('0x2c')]){delete _0x21e57a[_0x1ce2('0x2c')];}_0x331e9a[_0x1ce2('0x1b')](_0x24ec71)['send'](_0x21e57a);};}exports[_0x1ce2('0x2d')]=function(_0x36ae06,_0x4dfba1){var _0x5b4cbf={},_0x69e7a8={},_0xa19cd2={'count':0x0,'rows':[]};var _0xc1634c=_[_0x1ce2('0x2e')](db[_0x1ce2('0x2f')]['rawAttributes'],function(_0x2c1ee2){return{'name':_0x2c1ee2[_0x1ce2('0x30')],'type':_0x2c1ee2[_0x1ce2('0x31')][_0x1ce2('0x32')]};});_0x69e7a8[_0x1ce2('0x33')]=_[_0x1ce2('0x2e')](_0xc1634c,_0x1ce2('0x2c'));_0x69e7a8[_0x1ce2('0x34')]=_[_0x1ce2('0x35')](_0x36ae06['query']);_0x69e7a8[_0x1ce2('0x36')]=_[_0x1ce2('0x37')](_0x69e7a8[_0x1ce2('0x33')],_0x69e7a8['query']);_0x5b4cbf[_0x1ce2('0x38')]=_[_0x1ce2('0x37')](_0x69e7a8[_0x1ce2('0x33')],qs[_0x1ce2('0x39')](_0x36ae06[_0x1ce2('0x34')]['fields']));_0x5b4cbf[_0x1ce2('0x38')]=_0x5b4cbf[_0x1ce2('0x38')][_0x1ce2('0x3a')]?_0x5b4cbf[_0x1ce2('0x38')]:_0x69e7a8[_0x1ce2('0x33')];if(!_0x36ae06[_0x1ce2('0x34')][_0x1ce2('0x3b')](_0x1ce2('0x3c'))){_0x5b4cbf[_0x1ce2('0x1f')]=qs[_0x1ce2('0x1f')](_0x36ae06[_0x1ce2('0x34')]['limit']);_0x5b4cbf[_0x1ce2('0x1e')]=qs[_0x1ce2('0x1e')](_0x36ae06[_0x1ce2('0x34')][_0x1ce2('0x1e')]);}_0x5b4cbf[_0x1ce2('0x3d')]=qs[_0x1ce2('0x3e')](_0x36ae06[_0x1ce2('0x34')][_0x1ce2('0x3e')]);_0x5b4cbf['where']=qs[_0x1ce2('0x36')](_['pick'](_0x36ae06[_0x1ce2('0x34')],_0x69e7a8[_0x1ce2('0x36')]),_0xc1634c);if(_0x36ae06[_0x1ce2('0x34')][_0x1ce2('0x3f')]){_0x5b4cbf[_0x1ce2('0x40')]=_[_0x1ce2('0x41')](_0x5b4cbf[_0x1ce2('0x40')],{'$or':_[_0x1ce2('0x2e')](_0xc1634c,function(_0x306840){if(_0x306840[_0x1ce2('0x31')]!=='VIRTUAL'){var _0x54a7ce={};_0x54a7ce[_0x306840[_0x1ce2('0x2c')]]={'$like':'%'+_0x36ae06[_0x1ce2('0x34')][_0x1ce2('0x3f')]+'%'};return _0x54a7ce;}})});}_0x5b4cbf=_[_0x1ce2('0x41')]({},_0x5b4cbf,_0x36ae06[_0x1ce2('0x42')]);var _0x4c497d={'where':_0x5b4cbf[_0x1ce2('0x40')]};return db[_0x1ce2('0x2f')]['count'](_0x4c497d)[_0x1ce2('0x26')](function(_0x94a24f){_0xa19cd2['count']=_0x94a24f;if(_0x36ae06[_0x1ce2('0x34')][_0x1ce2('0x43')]){_0x5b4cbf[_0x1ce2('0x44')]=[{'all':!![]}];}return db[_0x1ce2('0x2f')][_0x1ce2('0x45')](_0x5b4cbf);})[_0x1ce2('0x26')](function(_0x45deb9){_0xa19cd2[_0x1ce2('0x46')]=_0x45deb9;return _0xa19cd2;})[_0x1ce2('0x26')](respondWithFilteredResult(_0x4dfba1,_0x5b4cbf))['catch'](handleError(_0x4dfba1,null));};exports[_0x1ce2('0x47')]=function(_0x33ecec,_0x59d03b){var _0x3bb0c6={'raw':![],'where':{'id':_0x33ecec[_0x1ce2('0x48')]['id']}},_0x405485={};_0x405485[_0x1ce2('0x33')]=_['keys'](db[_0x1ce2('0x2f')][_0x1ce2('0x49')]);_0x405485[_0x1ce2('0x34')]=_[_0x1ce2('0x35')](_0x33ecec['query']);_0x405485['filters']=_[_0x1ce2('0x37')](_0x405485[_0x1ce2('0x33')],_0x405485[_0x1ce2('0x34')]);_0x3bb0c6[_0x1ce2('0x38')]=_['intersection'](_0x405485[_0x1ce2('0x33')],qs['fields'](_0x33ecec[_0x1ce2('0x34')][_0x1ce2('0x39')]));_0x3bb0c6[_0x1ce2('0x38')]=_0x3bb0c6[_0x1ce2('0x38')][_0x1ce2('0x3a')]?_0x3bb0c6[_0x1ce2('0x38')]:_0x405485[_0x1ce2('0x33')];if(_0x33ecec[_0x1ce2('0x34')][_0x1ce2('0x43')]){_0x3bb0c6[_0x1ce2('0x44')]=[{'all':!![]}];}_0x3bb0c6=_[_0x1ce2('0x41')]({},_0x3bb0c6,_0x33ecec['options']);return db[_0x1ce2('0x2f')][_0x1ce2('0x4a')](_0x3bb0c6)[_0x1ce2('0x26')](handleEntityNotFound(_0x59d03b,null))[_0x1ce2('0x26')](respondWithResult(_0x59d03b,null))[_0x1ce2('0x4b')](handleError(_0x59d03b,null));};exports[_0x1ce2('0x4c')]=function(_0x1ef70e,_0x2f2587){return db[_0x1ce2('0x2f')][_0x1ce2('0x4c')](_0x1ef70e[_0x1ce2('0x4d')],{})[_0x1ce2('0x26')](function(_0x6cf676){var _0x1b41b1=_0x1ef70e['user'][_0x1ce2('0x28')]({'plain':!![]});if(!_0x1b41b1)throw new Error(_0x1ce2('0x4e'));if(_0x1b41b1['role']==='user'){var _0x426499=_0x6cf676[_0x1ce2('0x28')]({'plain':!![]});var _0x4b9117=_0x1ce2('0x29');return db['UserProfileSection'][_0x1ce2('0x4a')]({'where':{'name':_0x4b9117,'userProfileId':_0x1b41b1[_0x1ce2('0x4f')]},'raw':!![]})[_0x1ce2('0x26')](function(_0x576fb5){if(_0x576fb5&&_0x576fb5[_0x1ce2('0x50')]===0x0){return db[_0x1ce2('0x2a')]['create']({'name':_0x426499[_0x1ce2('0x2c')],'resourceId':_0x426499['id'],'type':_0x576fb5[_0x1ce2('0x2c')],'sectionId':_0x576fb5['id']},{})[_0x1ce2('0x26')](function(){return _0x6cf676;});}else{return _0x6cf676;}})[_0x1ce2('0x4b')](function(_0x287b30){logger['error'](_0x1ce2('0x51'),_0x287b30);throw _0x287b30;});}return _0x6cf676;})[_0x1ce2('0x26')](respondWithResult(_0x2f2587,0xc9))[_0x1ce2('0x4b')](handleError(_0x2f2587,null));};exports[_0x1ce2('0x52')]=function(_0x443120,_0x3b2422){var _0x1476f0={'where':{'id':_0x443120[_0x1ce2('0x48')]['id']}},_0x34b45c={};_0x34b45c['model']=_[_0x1ce2('0x35')](db[_0x1ce2('0x2f')]['rawAttributes']);_0x1476f0[_0x1ce2('0x38')]=_['intersection'](_0x34b45c[_0x1ce2('0x33')],qs[_0x1ce2('0x39')](_0x443120[_0x1ce2('0x34')]['fields']));_0x1476f0[_0x1ce2('0x38')]=_0x1476f0['attributes'][_0x1ce2('0x3a')]?_0x1476f0[_0x1ce2('0x38')]:_0x34b45c[_0x1ce2('0x33')];if(_0x443120[_0x1ce2('0x34')][_0x1ce2('0x43')]){_0x1476f0[_0x1ce2('0x44')]=[{'all':!![]}];}_0x1476f0=_[_0x1ce2('0x41')]({},_0x1476f0,_0x443120[_0x1ce2('0x42')]);return db['Campaign'][_0x1ce2('0x4a')](_0x1476f0)[_0x1ce2('0x26')](handleEntityNotFound(_0x3b2422,null))['then'](function(_0xe0d11a){if(_0xe0d11a){var _0x5c3ee2=_0xe0d11a['get']({'plain':!![]});_0x5c3ee2=qs[_0x1ce2('0x53')](_0x5c3ee2,['id',_0x1ce2('0x54'),'updatedAt']);_0x443120[_0x1ce2('0x4d')]=_[_0x1ce2('0x53')](_0x443120[_0x1ce2('0x4d')],['id',_0x1ce2('0x54'),_0x1ce2('0x55')]);return db[_0x1ce2('0x2f')]['create'](_['merge'](_0x5c3ee2,_0x443120[_0x1ce2('0x4d')]),{'include':_0x443120[_0x1ce2('0x34')]['includeAll']?[{'all':!![]}]:undefined})[_0x1ce2('0x26')](function(_0x1f1852){var _0x4f28f4=_0x443120[_0x1ce2('0x56')]['get']({'plain':!![]});if(!_0x4f28f4)throw new Error(_0x1ce2('0x4e'));if(_0x4f28f4[_0x1ce2('0x57')]==='user'){var _0x3f03f9=_0x1f1852[_0x1ce2('0x28')]({'plain':!![]});var _0x14edc6=_0x1ce2('0x29');return db[_0x1ce2('0x58')][_0x1ce2('0x4a')]({'where':{'name':_0x14edc6,'userProfileId':_0x4f28f4[_0x1ce2('0x4f')]},'raw':!![]})[_0x1ce2('0x26')](function(_0x296781){if(_0x296781&&_0x296781[_0x1ce2('0x50')]===0x0){return db[_0x1ce2('0x2a')][_0x1ce2('0x4c')]({'name':_0x3f03f9[_0x1ce2('0x2c')],'resourceId':_0x3f03f9['id'],'type':_0x296781[_0x1ce2('0x2c')],'sectionId':_0x296781['id']},{})['then'](function(){return _0x1f1852;});}else{return _0x1f1852;}})[_0x1ce2('0x4b')](function(_0x429172){logger[_0x1ce2('0x59')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x429172);throw _0x429172;});}return _0x1f1852;});}})['then'](respondWithResult(_0x3b2422,0xc9))[_0x1ce2('0x4b')](handleError(_0x3b2422,null));};exports[_0x1ce2('0x25')]=function(_0x266d81,_0x31d0b4){if(_0x266d81[_0x1ce2('0x4d')]['id']){delete _0x266d81['body']['id'];}return db[_0x1ce2('0x2f')]['find']({'where':{'id':_0x266d81[_0x1ce2('0x48')]['id']}})[_0x1ce2('0x26')](handleEntityNotFound(_0x31d0b4,null))['then'](saveUpdates(_0x266d81[_0x1ce2('0x4d')],null))[_0x1ce2('0x26')](respondWithResult(_0x31d0b4,null))[_0x1ce2('0x4b')](handleError(_0x31d0b4,null));};exports[_0x1ce2('0x27')]=function(_0x37ccd7,_0x2db3e3){return db[_0x1ce2('0x2f')]['find']({'where':{'id':_0x37ccd7['params']['id']}})[_0x1ce2('0x26')](handleEntityNotFound(_0x2db3e3,null))[_0x1ce2('0x26')](removeEntity(_0x2db3e3,null))[_0x1ce2('0x4b')](handleError(_0x2db3e3,null));};exports[_0x1ce2('0x5a')]=function(_0x17ea52,_0x193e8e,_0x36f85e){var _0x1e62ec={'raw':!![],'where':{}};var _0x51170d={};var _0x40bf06={'count':0x0,'rows':[]};return db['Campaign'][_0x1ce2('0x5b')]({'where':{'id':_0x17ea52['params']['id']}})[_0x1ce2('0x26')](handleEntityNotFound(_0x193e8e,null))['then'](function(_0x540236){if(_0x540236){_0x51170d['model']=_[_0x1ce2('0x35')](db['CmHopper']['rawAttributes']);_0x51170d[_0x1ce2('0x34')]=_['keys'](_0x17ea52[_0x1ce2('0x34')]);_0x51170d[_0x1ce2('0x36')]=_[_0x1ce2('0x37')](_0x51170d['model'],_0x51170d['query']);_0x1e62ec[_0x1ce2('0x38')]=_[_0x1ce2('0x37')](_0x51170d[_0x1ce2('0x33')],qs[_0x1ce2('0x39')](_0x17ea52[_0x1ce2('0x34')][_0x1ce2('0x39')]));_0x1e62ec[_0x1ce2('0x38')]=_0x1e62ec[_0x1ce2('0x38')][_0x1ce2('0x3a')]?_0x1e62ec[_0x1ce2('0x38')]:_0x51170d['model'];if(!_0x17ea52[_0x1ce2('0x34')][_0x1ce2('0x3b')](_0x1ce2('0x3c'))){_0x1e62ec[_0x1ce2('0x1f')]=qs[_0x1ce2('0x1f')](_0x17ea52[_0x1ce2('0x34')][_0x1ce2('0x1f')]);_0x1e62ec['offset']=qs[_0x1ce2('0x1e')](_0x17ea52[_0x1ce2('0x34')]['offset']);}_0x1e62ec[_0x1ce2('0x3d')]=qs[_0x1ce2('0x3e')](_0x17ea52['query']['sort']);_0x1e62ec[_0x1ce2('0x40')]=qs[_0x1ce2('0x36')](_[_0x1ce2('0x5c')](_0x17ea52[_0x1ce2('0x34')],_0x51170d['filters']));_0x1e62ec[_0x1ce2('0x40')][_0x1ce2('0x5d')]=_0x540236['id'];if(_0x17ea52[_0x1ce2('0x34')]['filter']){_0x1e62ec['where']=_['merge'](_0x1e62ec[_0x1ce2('0x40')],{'$or':_[_0x1ce2('0x2e')](_0x1e62ec[_0x1ce2('0x38')],function(_0x13ced4){var _0x497454={};_0x497454[_0x13ced4]={'$like':'%'+_0x17ea52['query'][_0x1ce2('0x3f')]+'%'};return _0x497454;})});}_0x1e62ec=_[_0x1ce2('0x41')]({},_0x1e62ec,_0x17ea52['options']);return db['CmHopper'][_0x1ce2('0x1d')]({'where':_0x1e62ec[_0x1ce2('0x40')]})['then'](function(_0x15f285){_0x40bf06[_0x1ce2('0x1d')]=_0x15f285;if(_0x17ea52[_0x1ce2('0x34')][_0x1ce2('0x43')]){_0x1e62ec[_0x1ce2('0x44')]=[{'all':!![]}];}return db[_0x1ce2('0x5e')]['findAll'](_0x1e62ec);})[_0x1ce2('0x26')](function(_0x50a318){_0x40bf06[_0x1ce2('0x46')]=_0x50a318;return _0x40bf06;});}})[_0x1ce2('0x26')](respondWithFilteredResult(_0x193e8e,_0x1e62ec))[_0x1ce2('0x4b')](handleError(_0x193e8e,null));};exports[_0x1ce2('0x5f')]=function(_0x1514af,_0x59a033,_0x29c5df){var _0x303187={'raw':!![],'where':{}};var _0x3cc56b={};var _0x4885bd={'count':0x0,'rows':[]};return db[_0x1ce2('0x2f')][_0x1ce2('0x5b')]({'where':{'id':_0x1514af[_0x1ce2('0x48')]['id']}})[_0x1ce2('0x26')](handleEntityNotFound(_0x59a033,null))[_0x1ce2('0x26')](function(_0x264282){if(_0x264282){_0x3cc56b[_0x1ce2('0x33')]=_[_0x1ce2('0x35')](db[_0x1ce2('0x60')][_0x1ce2('0x49')]);_0x3cc56b[_0x1ce2('0x34')]=_[_0x1ce2('0x35')](_0x1514af[_0x1ce2('0x34')]);_0x3cc56b[_0x1ce2('0x36')]=_['intersection'](_0x3cc56b[_0x1ce2('0x33')],_0x3cc56b[_0x1ce2('0x34')]);_0x303187['attributes']=_[_0x1ce2('0x37')](_0x3cc56b[_0x1ce2('0x33')],qs['fields'](_0x1514af[_0x1ce2('0x34')]['fields']));_0x303187[_0x1ce2('0x38')]=_0x303187[_0x1ce2('0x38')][_0x1ce2('0x3a')]?_0x303187[_0x1ce2('0x38')]:_0x3cc56b[_0x1ce2('0x33')];if(!_0x1514af['query']['hasOwnProperty']('nolimit')){_0x303187[_0x1ce2('0x1f')]=qs[_0x1ce2('0x1f')](_0x1514af[_0x1ce2('0x34')]['limit']);_0x303187['offset']=qs[_0x1ce2('0x1e')](_0x1514af['query']['offset']);}_0x303187[_0x1ce2('0x3d')]=qs['sort'](_0x1514af[_0x1ce2('0x34')][_0x1ce2('0x3e')]);_0x303187[_0x1ce2('0x40')]=qs['filters'](_['pick'](_0x1514af[_0x1ce2('0x34')],_0x3cc56b['filters']));_0x303187[_0x1ce2('0x40')][_0x1ce2('0x5d')]=_0x264282['id'];if(_0x1514af[_0x1ce2('0x34')][_0x1ce2('0x3f')]){_0x303187[_0x1ce2('0x40')]=_[_0x1ce2('0x41')](_0x303187['where'],{'$or':_[_0x1ce2('0x2e')](_0x303187[_0x1ce2('0x38')],function(_0x36e80d){var _0x570f8b={};_0x570f8b[_0x36e80d]={'$like':'%'+_0x1514af[_0x1ce2('0x34')][_0x1ce2('0x3f')]+'%'};return _0x570f8b;})});}_0x303187=_[_0x1ce2('0x41')]({},_0x303187,_0x1514af[_0x1ce2('0x42')]);return db['CmHopperHistory']['count']({'where':_0x303187['where']})[_0x1ce2('0x26')](function(_0xf82acf){_0x4885bd[_0x1ce2('0x1d')]=_0xf82acf;if(_0x1514af[_0x1ce2('0x34')]['includeAll']){_0x303187['include']=[{'all':!![]}];}return db[_0x1ce2('0x60')]['findAll'](_0x303187);})[_0x1ce2('0x26')](function(_0x3c1fdb){_0x4885bd['rows']=_0x3c1fdb;return _0x4885bd;});}})[_0x1ce2('0x26')](respondWithFilteredResult(_0x59a033,_0x303187))[_0x1ce2('0x4b')](handleError(_0x59a033,null));};exports['getHopperFinals']=function(_0x204de4,_0x598474,_0x12a756){var _0x1fcc56={'raw':!![],'where':{}};var _0x106588={};var _0x1941b1={'count':0x0,'rows':[]};return db[_0x1ce2('0x2f')][_0x1ce2('0x5b')]({'where':{'id':_0x204de4[_0x1ce2('0x48')]['id']}})[_0x1ce2('0x26')](handleEntityNotFound(_0x598474,null))['then'](function(_0x5bdaff){if(_0x5bdaff){_0x106588[_0x1ce2('0x33')]=_[_0x1ce2('0x35')](db[_0x1ce2('0x61')][_0x1ce2('0x49')]);_0x106588['query']=_['keys'](_0x204de4[_0x1ce2('0x34')]);_0x106588['filters']=_['intersection'](_0x106588['model'],_0x106588[_0x1ce2('0x34')]);_0x1fcc56[_0x1ce2('0x38')]=_[_0x1ce2('0x37')](_0x106588[_0x1ce2('0x33')],qs[_0x1ce2('0x39')](_0x204de4[_0x1ce2('0x34')][_0x1ce2('0x39')]));_0x1fcc56['attributes']=_0x1fcc56['attributes'][_0x1ce2('0x3a')]?_0x1fcc56['attributes']:_0x106588[_0x1ce2('0x33')];if(!_0x204de4['query'][_0x1ce2('0x3b')](_0x1ce2('0x3c'))){_0x1fcc56['limit']=qs[_0x1ce2('0x1f')](_0x204de4[_0x1ce2('0x34')][_0x1ce2('0x1f')]);_0x1fcc56[_0x1ce2('0x1e')]=qs[_0x1ce2('0x1e')](_0x204de4[_0x1ce2('0x34')]['offset']);}_0x1fcc56['order']=qs[_0x1ce2('0x3e')](_0x204de4['query'][_0x1ce2('0x3e')]);_0x1fcc56[_0x1ce2('0x40')]=qs['filters'](_[_0x1ce2('0x5c')](_0x204de4[_0x1ce2('0x34')],_0x106588[_0x1ce2('0x36')]));_0x1fcc56['where'][_0x1ce2('0x5d')]=_0x5bdaff['id'];if(_0x204de4[_0x1ce2('0x34')][_0x1ce2('0x3f')]){_0x1fcc56[_0x1ce2('0x40')]=_[_0x1ce2('0x41')](_0x1fcc56['where'],{'$or':_[_0x1ce2('0x2e')](_0x1fcc56[_0x1ce2('0x38')],function(_0x1d9e88){var _0xb7d63c={};_0xb7d63c[_0x1d9e88]={'$like':'%'+_0x204de4[_0x1ce2('0x34')][_0x1ce2('0x3f')]+'%'};return _0xb7d63c;})});}_0x1fcc56=_[_0x1ce2('0x41')]({},_0x1fcc56,_0x204de4[_0x1ce2('0x42')]);return db[_0x1ce2('0x61')][_0x1ce2('0x1d')]({'where':_0x1fcc56[_0x1ce2('0x40')]})[_0x1ce2('0x26')](function(_0x4d18be){_0x1941b1[_0x1ce2('0x1d')]=_0x4d18be;if(_0x204de4[_0x1ce2('0x34')][_0x1ce2('0x43')]){_0x1fcc56[_0x1ce2('0x44')]=[{'all':!![]}];}return db[_0x1ce2('0x61')]['findAll'](_0x1fcc56);})['then'](function(_0x3e82dd){_0x1941b1[_0x1ce2('0x46')]=_0x3e82dd;return _0x1941b1;});}})['then'](respondWithFilteredResult(_0x598474,_0x1fcc56))[_0x1ce2('0x4b')](handleError(_0x598474,null));};exports[_0x1ce2('0x62')]=function(_0x82886b,_0x46cbee,_0x2bb98d){var _0x216949={'raw':!![],'where':{}};var _0x14b347={};var _0xd12593={'count':0x0,'rows':[]};return db[_0x1ce2('0x2f')][_0x1ce2('0x5b')]({'where':{'id':_0x82886b['params']['id']}})[_0x1ce2('0x26')](handleEntityNotFound(_0x46cbee,null))[_0x1ce2('0x26')](function(_0x2ce29e){if(_0x2ce29e){_0x14b347['model']=_[_0x1ce2('0x35')](db[_0x1ce2('0x63')][_0x1ce2('0x49')]);_0x14b347[_0x1ce2('0x34')]=_[_0x1ce2('0x35')](_0x82886b[_0x1ce2('0x34')]);_0x14b347['filters']=_[_0x1ce2('0x37')](_0x14b347['model'],_0x14b347[_0x1ce2('0x34')]);_0x216949[_0x1ce2('0x38')]=_[_0x1ce2('0x37')](_0x14b347[_0x1ce2('0x33')],qs[_0x1ce2('0x39')](_0x82886b[_0x1ce2('0x34')]['fields']));_0x216949[_0x1ce2('0x38')]=_0x216949[_0x1ce2('0x38')][_0x1ce2('0x3a')]?_0x216949[_0x1ce2('0x38')]:_0x14b347['model'];if(!_0x82886b[_0x1ce2('0x34')][_0x1ce2('0x3b')](_0x1ce2('0x3c'))){_0x216949[_0x1ce2('0x1f')]=qs[_0x1ce2('0x1f')](_0x82886b[_0x1ce2('0x34')][_0x1ce2('0x1f')]);_0x216949[_0x1ce2('0x1e')]=qs[_0x1ce2('0x1e')](_0x82886b[_0x1ce2('0x34')][_0x1ce2('0x1e')]);}_0x216949[_0x1ce2('0x3d')]=qs['sort'](_0x82886b['query'][_0x1ce2('0x3e')]);_0x216949[_0x1ce2('0x40')]=qs[_0x1ce2('0x36')](_[_0x1ce2('0x5c')](_0x82886b['query'],_0x14b347['filters']));_0x216949['where'][_0x1ce2('0x5d')]=_0x2ce29e['id'];if(_0x82886b[_0x1ce2('0x34')][_0x1ce2('0x3f')]){_0x216949[_0x1ce2('0x40')]=_[_0x1ce2('0x41')](_0x216949[_0x1ce2('0x40')],{'$or':_[_0x1ce2('0x2e')](_0x216949[_0x1ce2('0x38')],function(_0x542059){var _0x3a4905={};_0x3a4905[_0x542059]={'$like':'%'+_0x82886b[_0x1ce2('0x34')]['filter']+'%'};return _0x3a4905;})});}_0x216949=_[_0x1ce2('0x41')]({},_0x216949,_0x82886b[_0x1ce2('0x42')]);return db['CmHopperBlack'][_0x1ce2('0x1d')]({'where':_0x216949[_0x1ce2('0x40')]})[_0x1ce2('0x26')](function(_0x36addf){_0xd12593[_0x1ce2('0x1d')]=_0x36addf;if(_0x82886b[_0x1ce2('0x34')][_0x1ce2('0x43')]){_0x216949[_0x1ce2('0x44')]=[{'all':!![]}];}return db[_0x1ce2('0x63')][_0x1ce2('0x45')](_0x216949);})[_0x1ce2('0x26')](function(_0x15b81b){_0xd12593[_0x1ce2('0x46')]=_0x15b81b;return _0xd12593;});}})[_0x1ce2('0x26')](respondWithFilteredResult(_0x46cbee,_0x216949))[_0x1ce2('0x4b')](handleError(_0x46cbee,null));};exports[_0x1ce2('0x64')]=function(_0x150361,_0x96dd3c,_0x499af8){var _0x2c0cf2={};var _0x7f000b={};var _0x5ca3ec;var _0x49ea0f;return db[_0x1ce2('0x2f')][_0x1ce2('0x5b')]({'where':{'id':_0x150361[_0x1ce2('0x48')]['id']}})[_0x1ce2('0x26')](handleEntityNotFound(_0x96dd3c,null))[_0x1ce2('0x26')](function(_0x5d9750){if(_0x5d9750){_0x5ca3ec=_0x5d9750;_0x7f000b[_0x1ce2('0x33')]=_['keys'](db[_0x1ce2('0x65')][_0x1ce2('0x49')]);_0x7f000b['query']=_[_0x1ce2('0x35')](_0x150361['query']);_0x7f000b[_0x1ce2('0x36')]=_[_0x1ce2('0x37')](_0x7f000b[_0x1ce2('0x33')],_0x7f000b[_0x1ce2('0x34')]);_0x2c0cf2[_0x1ce2('0x38')]=_['intersection'](_0x7f000b['model'],qs[_0x1ce2('0x39')](_0x150361[_0x1ce2('0x34')][_0x1ce2('0x39')]));_0x2c0cf2[_0x1ce2('0x38')]=_0x2c0cf2[_0x1ce2('0x38')]['length']?_0x2c0cf2['attributes']:_0x7f000b[_0x1ce2('0x33')];_0x2c0cf2['order']=qs[_0x1ce2('0x3e')](_0x150361[_0x1ce2('0x34')][_0x1ce2('0x3e')]);_0x2c0cf2[_0x1ce2('0x40')]=qs[_0x1ce2('0x36')](_[_0x1ce2('0x5c')](_0x150361['query'],_0x7f000b[_0x1ce2('0x36')]));if(_0x150361[_0x1ce2('0x34')]['filter']){_0x2c0cf2['where']=_[_0x1ce2('0x41')](_0x2c0cf2[_0x1ce2('0x40')],{'$or':_['map'](_0x2c0cf2[_0x1ce2('0x38')],function(_0x264a2f){var _0x4bee1d={};_0x4bee1d[_0x264a2f]={'$like':'%'+_0x150361[_0x1ce2('0x34')][_0x1ce2('0x3f')]+'%'};return _0x4bee1d;})});}_0x2c0cf2=_[_0x1ce2('0x41')]({},_0x2c0cf2,_0x150361[_0x1ce2('0x42')]);return _0x5ca3ec[_0x1ce2('0x64')](_0x2c0cf2);}})[_0x1ce2('0x26')](function(_0x144d62){if(_0x144d62){_0x49ea0f=_0x144d62[_0x1ce2('0x3a')];if(!_0x150361[_0x1ce2('0x34')]['hasOwnProperty'](_0x1ce2('0x3c'))){_0x2c0cf2[_0x1ce2('0x1f')]=qs[_0x1ce2('0x1f')](_0x150361[_0x1ce2('0x34')][_0x1ce2('0x1f')]);_0x2c0cf2[_0x1ce2('0x1e')]=qs[_0x1ce2('0x1e')](_0x150361[_0x1ce2('0x34')][_0x1ce2('0x1e')]);}return _0x5ca3ec[_0x1ce2('0x64')](_0x2c0cf2);}})[_0x1ce2('0x26')](function(_0x469b95){if(_0x469b95){return _0x469b95?{'count':_0x49ea0f,'rows':_0x469b95}:null;}})['then'](respondWithResult(_0x96dd3c,null))['catch'](handleError(_0x96dd3c,null));};exports[_0x1ce2('0x66')]=function(_0xd0b21e,_0x500053,_0x4e1f05){var _0x1c1a26,_0x3eaaba;return db[_0x1ce2('0x2f')][_0x1ce2('0x4a')]({'where':{'id':_0xd0b21e[_0x1ce2('0x48')]['id']}})[_0x1ce2('0x26')](handleEntityNotFound(_0x500053,null))['then'](function(_0x2601d9){if(_0x2601d9){_0x3eaaba=_0x2601d9;return _0x2601d9[_0x1ce2('0x66')](_0xd0b21e[_0x1ce2('0x4d')]['ids'],_[_0x1ce2('0x53')](_0xd0b21e[_0x1ce2('0x4d')],['ids','id'])||{});}return null;})[_0x1ce2('0x67')](function(_0x56dd72){var _0x191f62;_0x1c1a26=_0x56dd72||[];var _0x551fdf=[];if(_0x56dd72){for(var _0xc6affd=0x0;_0xc6affd<_0x56dd72[_0x1ce2('0x3a')];_0xc6affd+=0x1){var _0x2ef9b5=_0x56dd72[_0xc6affd][_0x1ce2('0x28')]({'plain':!![]});_0x3eaaba['dialCheckDuplicateType']=_0xd0b21e['body'][_0x1ce2('0x68')]?_0xd0b21e['body']['dialCheckDuplicateType']:_0x3eaaba[_0x1ce2('0x68')];switch(_0x3eaaba['dialCheckDuplicateType']){case'always':_0x191f62=squel[_0x1ce2('0x69')]()[_0x1ce2('0x6a')]('cm_hopper')[_0x1ce2('0x6b')](['phone',_0x1ce2('0x6c'),_0x1ce2('0x6d'),_0x1ce2('0x6e'),'CampaignId',_0x1ce2('0x54'),_0x1ce2('0x55')],squel[_0x1ce2('0x6f')]()['field'](_0x1ce2('0x70'),_0x1ce2('0x70'))['field'](_0x1ce2('0x71'),'scheduledAt')[_0x1ce2('0x72')]('id',_0x1ce2('0x6d'))['field'](_0x2ef9b5[_0x1ce2('0x73')][_0x1ce2('0x74')](),'ListId')['field'](_0xd0b21e[_0x1ce2('0x48')]['id']['toString'](),_0x1ce2('0x5d'))['field'](_0x1ce2('0x71'),'createdAt')['field'](_0x1ce2('0x71'),_0x1ce2('0x55'))['from'](_0x1ce2('0x75'))[_0x1ce2('0x40')](_0x1ce2('0x76'))[_0x1ce2('0x40')](_0x1ce2('0x77'),_0x2ef9b5[_0x1ce2('0x73')]['toString']())[_0x1ce2('0x40')](_0x1ce2('0x78'))[_0x1ce2('0x40')](_0x1ce2('0x79'),squel[_0x1ce2('0x6f')]()[_0x1ce2('0x72')]('COALESCE(calleridnum,\x27\x27)')[_0x1ce2('0x7a')](_0x1ce2('0x7b'))[_0x1ce2('0x40')]('CampaignId\x20=\x20?',_0xd0b21e['params']['id'][_0x1ce2('0x74')]()))[_0x1ce2('0x40')]('phone\x20NOT\x20IN\x20(?)',squel[_0x1ce2('0x6f')]()[_0x1ce2('0x72')](_0x1ce2('0x7c'))[_0x1ce2('0x7a')](_0x1ce2('0x7d'))['where'](_0x1ce2('0x7e'),_0xd0b21e[_0x1ce2('0x48')]['id']['toString']())))[_0x1ce2('0x74')]();break;case _0x1ce2('0x7f'):_0x191f62=squel[_0x1ce2('0x69')]()['into'](_0x1ce2('0x7d'))['fromQuery']([_0x1ce2('0x70'),_0x1ce2('0x6c'),_0x1ce2('0x6d'),_0x1ce2('0x6e'),_0x1ce2('0x5d'),_0x1ce2('0x54'),_0x1ce2('0x55')],squel[_0x1ce2('0x6f')]()[_0x1ce2('0x72')]('phone',_0x1ce2('0x70'))['field']('NOW()',_0x1ce2('0x6c'))[_0x1ce2('0x72')]('id',_0x1ce2('0x6d'))[_0x1ce2('0x72')](_0x2ef9b5[_0x1ce2('0x73')][_0x1ce2('0x74')](),_0x1ce2('0x6e'))[_0x1ce2('0x72')](_0xd0b21e[_0x1ce2('0x48')]['id'][_0x1ce2('0x74')](),_0x1ce2('0x5d'))[_0x1ce2('0x72')](_0x1ce2('0x71'),_0x1ce2('0x54'))[_0x1ce2('0x72')](_0x1ce2('0x71'),_0x1ce2('0x55'))[_0x1ce2('0x7a')](_0x1ce2('0x75'))['where'](_0x1ce2('0x76'))['where'](_0x1ce2('0x77'),_0x2ef9b5[_0x1ce2('0x73')][_0x1ce2('0x74')]())[_0x1ce2('0x40')](_0x1ce2('0x78'))[_0x1ce2('0x40')](_0x1ce2('0x79'),squel['select']()[_0x1ce2('0x72')]('COALESCE(phone,\x27\x27)')[_0x1ce2('0x7a')]('cm_hopper')[_0x1ce2('0x40')](_0x1ce2('0x7e'),_0xd0b21e[_0x1ce2('0x48')]['id'][_0x1ce2('0x74')]())))[_0x1ce2('0x74')]();break;default:_0x191f62=squel[_0x1ce2('0x69')]()[_0x1ce2('0x6a')]('cm_hopper')['fromQuery'](['phone','scheduledAt',_0x1ce2('0x6d'),_0x1ce2('0x6e'),_0x1ce2('0x5d'),_0x1ce2('0x54'),_0x1ce2('0x55')],squel[_0x1ce2('0x6f')]()['field'](_0x1ce2('0x70'),_0x1ce2('0x70'))[_0x1ce2('0x72')](_0x1ce2('0x71'),_0x1ce2('0x6c'))[_0x1ce2('0x72')]('id',_0x1ce2('0x6d'))['field'](_0x2ef9b5[_0x1ce2('0x73')][_0x1ce2('0x74')](),_0x1ce2('0x6e'))[_0x1ce2('0x72')](_0xd0b21e['params']['id'][_0x1ce2('0x74')](),_0x1ce2('0x5d'))[_0x1ce2('0x72')]('NOW()','createdAt')[_0x1ce2('0x72')](_0x1ce2('0x71'),_0x1ce2('0x55'))['from']('cm_contacts')[_0x1ce2('0x40')](_0x1ce2('0x76'))['where'](_0x1ce2('0x77'),_0x2ef9b5[_0x1ce2('0x73')][_0x1ce2('0x74')]())[_0x1ce2('0x40')](_0x1ce2('0x78')))[_0x1ce2('0x74')]();}_0x551fdf[_0x1ce2('0x80')](db['sequelize']['query'](_0x191f62));}return BPromise['all'](_0x551fdf);}})[_0x1ce2('0x26')](function(){return _0x1c1a26;})[_0x1ce2('0x26')](respondWithResult(_0x500053,null))['catch'](handleError(_0x500053,null));};exports[_0x1ce2('0x81')]=function(_0x156227,_0x4922e8,_0x2f6ab0){return db[_0x1ce2('0x2f')][_0x1ce2('0x4a')]({'where':{'id':_0x156227[_0x1ce2('0x48')]['id']}})[_0x1ce2('0x26')](handleEntityNotFound(_0x4922e8,null))[_0x1ce2('0x26')](function(_0x922da5){if(_0x922da5){return _0x922da5[_0x1ce2('0x81')](_0x156227[_0x1ce2('0x34')][_0x1ce2('0x82')]);}})[_0x1ce2('0x26')](function(_0x406334){if(_0x406334){return db['CmHopper'][_0x1ce2('0x27')]({'where':{'ListId':_0x156227['query'][_0x1ce2('0x82')],'CampaignId':_0x156227['params']['id']}})[_0x1ce2('0x26')](function(){return _0x406334;});}})['then'](respondWithStatusCode(_0x4922e8,null))['catch'](handleError(_0x4922e8,null));};exports[_0x1ce2('0x83')]=function(_0x50ba12,_0x4f4d38,_0x34cc89){var _0x4433c8={};var _0x2f5111={};var _0x57d57f;var _0x58f25d;return db[_0x1ce2('0x2f')][_0x1ce2('0x5b')]({'where':{'id':_0x50ba12[_0x1ce2('0x48')]['id']}})[_0x1ce2('0x26')](handleEntityNotFound(_0x4f4d38,null))[_0x1ce2('0x26')](function(_0x2a5753){if(_0x2a5753){_0x57d57f=_0x2a5753;_0x2f5111[_0x1ce2('0x33')]=_[_0x1ce2('0x35')](db[_0x1ce2('0x65')][_0x1ce2('0x49')]);_0x2f5111[_0x1ce2('0x34')]=_[_0x1ce2('0x35')](_0x50ba12[_0x1ce2('0x34')]);_0x2f5111['filters']=_[_0x1ce2('0x37')](_0x2f5111[_0x1ce2('0x33')],_0x2f5111[_0x1ce2('0x34')]);_0x4433c8['attributes']=_[_0x1ce2('0x37')](_0x2f5111['model'],qs['fields'](_0x50ba12[_0x1ce2('0x34')][_0x1ce2('0x39')]));_0x4433c8[_0x1ce2('0x38')]=_0x4433c8[_0x1ce2('0x38')][_0x1ce2('0x3a')]?_0x4433c8[_0x1ce2('0x38')]:_0x2f5111['model'];_0x4433c8['order']=qs[_0x1ce2('0x3e')](_0x50ba12[_0x1ce2('0x34')][_0x1ce2('0x3e')]);_0x4433c8[_0x1ce2('0x40')]=qs[_0x1ce2('0x36')](_['pick'](_0x50ba12[_0x1ce2('0x34')],_0x2f5111['filters']));if(_0x50ba12[_0x1ce2('0x34')][_0x1ce2('0x3f')]){_0x4433c8['where']=_[_0x1ce2('0x41')](_0x4433c8[_0x1ce2('0x40')],{'$or':_[_0x1ce2('0x2e')](_0x4433c8[_0x1ce2('0x38')],function(_0xab7430){var _0x5dd691={};_0x5dd691[_0xab7430]={'$like':'%'+_0x50ba12['query'][_0x1ce2('0x3f')]+'%'};return _0x5dd691;})});}_0x4433c8=_[_0x1ce2('0x41')]({},_0x4433c8,_0x50ba12[_0x1ce2('0x42')]);return _0x57d57f[_0x1ce2('0x83')](_0x4433c8);}})[_0x1ce2('0x26')](function(_0x58718a){if(_0x58718a){_0x58f25d=_0x58718a[_0x1ce2('0x3a')];if(!_0x50ba12[_0x1ce2('0x34')]['hasOwnProperty']('nolimit')){_0x4433c8[_0x1ce2('0x1f')]=qs[_0x1ce2('0x1f')](_0x50ba12['query']['limit']);_0x4433c8[_0x1ce2('0x1e')]=qs[_0x1ce2('0x1e')](_0x50ba12[_0x1ce2('0x34')][_0x1ce2('0x1e')]);}return _0x57d57f[_0x1ce2('0x83')](_0x4433c8);}})['then'](function(_0x2adfa9){if(_0x2adfa9){return _0x2adfa9?{'count':_0x58f25d,'rows':_0x2adfa9}:null;}})[_0x1ce2('0x26')](respondWithResult(_0x4f4d38,null))[_0x1ce2('0x4b')](handleError(_0x4f4d38,null));};exports[_0x1ce2('0x84')]=function(_0x3e9f3a,_0x3c28f7,_0x7e429a){var _0x2c8a0e,_0x52db52;return db[_0x1ce2('0x2f')][_0x1ce2('0x4a')]({'where':{'id':_0x3e9f3a[_0x1ce2('0x48')]['id']}})[_0x1ce2('0x26')](handleEntityNotFound(_0x3c28f7,null))[_0x1ce2('0x26')](function(_0x2c71f9){if(_0x2c71f9){_0x52db52=_0x2c71f9;return _0x2c71f9[_0x1ce2('0x84')](_0x3e9f3a[_0x1ce2('0x4d')]['ids'],_[_0x1ce2('0x53')](_0x3e9f3a[_0x1ce2('0x4d')],[_0x1ce2('0x82'),'id'])||{});}return null;})[_0x1ce2('0x67')](function(_0xc00360){var _0x36688c;_0x2c8a0e=_0xc00360||[];var _0xd69699=[];if(_0xc00360){for(var _0x9e3469=0x0;_0x9e3469<_0xc00360[_0x1ce2('0x3a')];_0x9e3469+=0x1){var _0x5e735e=_0xc00360[_0x9e3469][_0x1ce2('0x28')]({'plain':!![]});_0x36688c=squel[_0x1ce2('0x69')]()['into']('cm_hopper_black')[_0x1ce2('0x6b')]([_0x1ce2('0x70'),_0x1ce2('0x6d'),_0x1ce2('0x6e'),'CampaignId',_0x1ce2('0x54'),_0x1ce2('0x55')],squel['select']()[_0x1ce2('0x72')](_0x1ce2('0x70'),_0x1ce2('0x70'))[_0x1ce2('0x72')]('id','ContactId')[_0x1ce2('0x72')](_0x5e735e[_0x1ce2('0x73')]['toString'](),_0x1ce2('0x6e'))[_0x1ce2('0x72')](_0x3e9f3a[_0x1ce2('0x48')]['id'][_0x1ce2('0x74')](),'CampaignId')[_0x1ce2('0x72')](_0x1ce2('0x71'),_0x1ce2('0x54'))['field'](_0x1ce2('0x71'),_0x1ce2('0x55'))['from']('cm_contacts')['where']('deletedAt\x20IS\x20NULL')[_0x1ce2('0x40')](_0x1ce2('0x77'),_0x5e735e[_0x1ce2('0x73')]['toString']())['where'](_0x1ce2('0x78')))['toString']();_0xd69699[_0x1ce2('0x80')](db[_0x1ce2('0x85')]['query'](_0x36688c));}return BPromise[_0x1ce2('0x86')](_0xd69699);}})[_0x1ce2('0x26')](function(){return _0x2c8a0e;})[_0x1ce2('0x26')](respondWithResult(_0x3c28f7,null))['catch'](handleError(_0x3c28f7,null));};exports[_0x1ce2('0x87')]=function(_0x46c727,_0x4d3625,_0x869a0c){return db[_0x1ce2('0x2f')][_0x1ce2('0x4a')]({'where':{'id':_0x46c727['params']['id']}})[_0x1ce2('0x26')](handleEntityNotFound(_0x4d3625,null))[_0x1ce2('0x26')](function(_0xda2c5b){if(_0xda2c5b){return _0xda2c5b[_0x1ce2('0x87')](_0x46c727[_0x1ce2('0x34')][_0x1ce2('0x82')]);}})[_0x1ce2('0x26')](function(_0x20ed7e){if(_0x20ed7e){return db[_0x1ce2('0x63')][_0x1ce2('0x27')]({'where':{'ListId':_0x46c727['query']['ids'],'CampaignId':_0x46c727[_0x1ce2('0x48')]['id']}})[_0x1ce2('0x26')](function(){return _0x20ed7e;});}})['then'](respondWithStatusCode(_0x4d3625,null))[_0x1ce2('0x4b')](handleError(_0x4d3625,null));};
git://repos.xcallymotion.com / motion2.git / blob