// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x876b=['cm_contacts','cm_hopper_additional_phones','cmHopperId','h.id','ci.item','OrderBy','cm_contact_has_items','join','h.ContactId\x20=\x20ci.CmContactId','h.CampaignId=?','h.createdAt\x20=\x20?','sequelize','push','all','removeLists','getBlackLists','addBlackLists','cm_hopper_black','removeBlackLists','zip-dir','fast-json-patch','bluebird','mustache','path','sox','to-csv','fs-extra','lodash','crypto','jsforce','desk.js','papaparse','../../components/auth/service','../../components/parsers/qs','api','../../config/environment','../../config/license/util','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','reject','save','update','then','destroy','get','IvrCampaigns','UserProfileResource','stack','name','index','map','Campaign','rawAttributes','fieldName','key','model','keys','query','filters','attributes','intersection','fields','length','order','sort','where','pick','merge','type','VIRTUAL','filter','options','includeAll','include','findAll','rows','catch','params','find','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','user','userProfileId','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','omit','createdAt','updatedAt','UserProfileSection','autoAssociation','error','getHoppers','findOne','CmHopper','getHopperHistories','hasOwnProperty','nolimit','CmHopperHistory','getHopperFinals','CmHopperFinal','CampaignId','CmHopperBlack','CmList','getLists','format','YYYY-MM-DD\x20HH:mm:ss','ids','spread','dialCheckDuplicateType','insert','into','cm_hopper','fromQuery','phone','ListId','field','NOW()','scheduledAt','ContactId','CmListId','toString','from','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','cm_hopper_final','CampaignId\x20=\x20?','select','COALESCE(phone,\x27\x27)','onlyIfOpen'];(function(_0x37770a,_0x15dd88){var _0x544c8a=function(_0x92dee5){while(--_0x92dee5){_0x37770a['push'](_0x37770a['shift']());}};_0x544c8a(++_0x15dd88);}(_0x876b,0x1ba));var _0xb876=function(_0x5a82e1,_0x3c8860){_0x5a82e1=_0x5a82e1-0x0;var _0xedb5f2=_0x876b[_0x5a82e1];return _0xedb5f2;};'use strict';var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require(_0xb876('0x0'));var jsonpatch=require(_0xb876('0x1'));var rp=require('request-promise');var moment=require('moment');var BPromise=require(_0xb876('0x2'));var Mustache=require(_0xb876('0x3'));var util=require('util');var path=require(_0xb876('0x4'));var sox=require(_0xb876('0x5'));var csv=require(_0xb876('0x6'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0xb876('0x7'));var _=require(_0xb876('0x8'));var squel=require('squel');var crypto=require(_0xb876('0x9'));var jsforce=require(_0xb876('0xa'));var deskjs=require(_0xb876('0xb'));var toCsv=require(_0xb876('0x6'));var querystring=require('querystring');var Papa=require(_0xb876('0xc'));var Redis=require('ioredis');var authService=require(_0xb876('0xd'));var qs=require(_0xb876('0xe'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0xb876('0xf'));var utils=require('../../config/utils');var config=require(_0xb876('0x10'));var licenseUtil=require(_0xb876('0x11'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x84b7bb,_0x19fb7e){_0x19fb7e=_0x19fb7e||0xcc;return function(_0x2c2a0f){if(_0x2c2a0f){return _0x84b7bb[_0xb876('0x12')](_0x19fb7e);}return _0x84b7bb[_0xb876('0x13')](_0x19fb7e)[_0xb876('0x14')]();};}function respondWithResult(_0x39bc32,_0x31a5fa){_0x31a5fa=_0x31a5fa||0xc8;return function(_0x248165){if(_0x248165){return _0x39bc32[_0xb876('0x13')](_0x31a5fa)[_0xb876('0x15')](_0x248165);}};}function respondWithFilteredResult(_0x239804,_0x497380){return function(_0x33f264){if(_0x33f264){var _0x6bf9ad=typeof _0x497380[_0xb876('0x16')]===_0xb876('0x17')&&typeof _0x497380[_0xb876('0x18')]===_0xb876('0x17');var _0x526ea7=_0x33f264[_0xb876('0x19')];var _0x3da83a=_0x6bf9ad?0x0:_0x497380['offset'];var _0x5eb24a=_0x6bf9ad?_0x33f264[_0xb876('0x19')]:_0x497380[_0xb876('0x16')]+_0x497380[_0xb876('0x18')];var _0x587af4;if(_0x5eb24a>=_0x526ea7){_0x5eb24a=_0x526ea7;_0x587af4=0xc8;}else{_0x587af4=0xce;}_0x239804[_0xb876('0x13')](_0x587af4);return _0x239804[_0xb876('0x1a')](_0xb876('0x1b'),_0x3da83a+'-'+_0x5eb24a+'/'+_0x526ea7)[_0xb876('0x15')](_0x33f264);}return null;};}function patchUpdates(_0x10b085){return function(_0x4f9b80){try{jsonpatch['apply'](_0x4f9b80,_0x10b085,!![]);}catch(_0x4b4382){return BPromise[_0xb876('0x1c')](_0x4b4382);}return _0x4f9b80[_0xb876('0x1d')]();};}function saveUpdates(_0x36f701,_0x115f17){return function(_0x5d775c){if(_0x5d775c){return _0x5d775c[_0xb876('0x1e')](_0x36f701)[_0xb876('0x1f')](function(_0x20006c){return _0x20006c;});}return null;};}function removeEntity(_0x359b44,_0xe939c2){return function(_0x351dc3){if(_0x351dc3){return _0x351dc3[_0xb876('0x20')]()[_0xb876('0x1f')](function(){var _0x3589db=_0x351dc3[_0xb876('0x21')]({'plain':!![]});var _0x244e2b=_0xb876('0x22');return db[_0xb876('0x23')][_0xb876('0x20')]({'where':{'type':_0x244e2b,'resourceId':_0x3589db['id']}})[_0xb876('0x1f')](function(){return _0x351dc3;});})[_0xb876('0x1f')](function(){_0x359b44[_0xb876('0x13')](0xcc)['end']();});}};}function handleEntityNotFound(_0x118824,_0x1dcaec){return function(_0x2d6d56){if(!_0x2d6d56){_0x118824['sendStatus'](0x194);}return _0x2d6d56;};}function handleError(_0x15d40e,_0x36a6d9){_0x36a6d9=_0x36a6d9||0x1f4;return function(_0x11c061){logger['error'](_0x11c061[_0xb876('0x24')]);if(_0x11c061[_0xb876('0x25')]){delete _0x11c061['name'];}_0x15d40e[_0xb876('0x13')](_0x36a6d9)['send'](_0x11c061);};}exports[_0xb876('0x26')]=function(_0x29e13e,_0x444581){var _0x285995={},_0x5bb2b7={},_0x96f8ab={'count':0x0,'rows':[]};var _0x265062=_[_0xb876('0x27')](db[_0xb876('0x28')][_0xb876('0x29')],function(_0x42ec82){return{'name':_0x42ec82[_0xb876('0x2a')],'type':_0x42ec82['type'][_0xb876('0x2b')]};});_0x5bb2b7[_0xb876('0x2c')]=_[_0xb876('0x27')](_0x265062,'name');_0x5bb2b7['query']=_[_0xb876('0x2d')](_0x29e13e[_0xb876('0x2e')]);_0x5bb2b7[_0xb876('0x2f')]=_['intersection'](_0x5bb2b7[_0xb876('0x2c')],_0x5bb2b7['query']);_0x285995[_0xb876('0x30')]=_[_0xb876('0x31')](_0x5bb2b7[_0xb876('0x2c')],qs['fields'](_0x29e13e[_0xb876('0x2e')][_0xb876('0x32')]));_0x285995[_0xb876('0x30')]=_0x285995[_0xb876('0x30')][_0xb876('0x33')]?_0x285995[_0xb876('0x30')]:_0x5bb2b7[_0xb876('0x2c')];if(!_0x29e13e[_0xb876('0x2e')]['hasOwnProperty']('nolimit')){_0x285995[_0xb876('0x18')]=qs[_0xb876('0x18')](_0x29e13e[_0xb876('0x2e')][_0xb876('0x18')]);_0x285995['offset']=qs[_0xb876('0x16')](_0x29e13e[_0xb876('0x2e')][_0xb876('0x16')]);}_0x285995[_0xb876('0x34')]=qs[_0xb876('0x35')](_0x29e13e[_0xb876('0x2e')][_0xb876('0x35')]);_0x285995[_0xb876('0x36')]=qs['filters'](_[_0xb876('0x37')](_0x29e13e['query'],_0x5bb2b7[_0xb876('0x2f')]),_0x265062);if(_0x29e13e[_0xb876('0x2e')]['filter']){_0x285995['where']=_[_0xb876('0x38')](_0x285995['where'],{'$or':_[_0xb876('0x27')](_0x265062,function(_0x24ae4d){if(_0x24ae4d[_0xb876('0x39')]!==_0xb876('0x3a')){var _0x29a102={};_0x29a102[_0x24ae4d[_0xb876('0x25')]]={'$like':'%'+_0x29e13e[_0xb876('0x2e')][_0xb876('0x3b')]+'%'};return _0x29a102;}})});}_0x285995=_[_0xb876('0x38')]({},_0x285995,_0x29e13e[_0xb876('0x3c')]);var _0x1ea1ed={'where':_0x285995['where']};return db[_0xb876('0x28')]['count'](_0x1ea1ed)[_0xb876('0x1f')](function(_0x5232f8){_0x96f8ab[_0xb876('0x19')]=_0x5232f8;if(_0x29e13e[_0xb876('0x2e')][_0xb876('0x3d')]){_0x285995[_0xb876('0x3e')]=[{'all':!![]}];}return db[_0xb876('0x28')][_0xb876('0x3f')](_0x285995);})[_0xb876('0x1f')](function(_0x10018e){_0x96f8ab[_0xb876('0x40')]=_0x10018e;return _0x96f8ab;})[_0xb876('0x1f')](respondWithFilteredResult(_0x444581,_0x285995))[_0xb876('0x41')](handleError(_0x444581,null));};exports['show']=function(_0xddfbc0,_0x239052){var _0x32ac1f={'raw':![],'where':{'id':_0xddfbc0[_0xb876('0x42')]['id']}},_0x4dcd29={};_0x4dcd29['model']=_[_0xb876('0x2d')](db[_0xb876('0x28')][_0xb876('0x29')]);_0x4dcd29['query']=_[_0xb876('0x2d')](_0xddfbc0['query']);_0x4dcd29[_0xb876('0x2f')]=_['intersection'](_0x4dcd29['model'],_0x4dcd29[_0xb876('0x2e')]);_0x32ac1f[_0xb876('0x30')]=_['intersection'](_0x4dcd29[_0xb876('0x2c')],qs[_0xb876('0x32')](_0xddfbc0[_0xb876('0x2e')]['fields']));_0x32ac1f[_0xb876('0x30')]=_0x32ac1f[_0xb876('0x30')][_0xb876('0x33')]?_0x32ac1f['attributes']:_0x4dcd29[_0xb876('0x2c')];if(_0xddfbc0['query'][_0xb876('0x3d')]){_0x32ac1f[_0xb876('0x3e')]=[{'all':!![]}];}_0x32ac1f=_['merge']({},_0x32ac1f,_0xddfbc0[_0xb876('0x3c')]);return db[_0xb876('0x28')][_0xb876('0x43')](_0x32ac1f)[_0xb876('0x1f')](handleEntityNotFound(_0x239052,null))[_0xb876('0x1f')](respondWithResult(_0x239052,null))[_0xb876('0x41')](handleError(_0x239052,null));};exports[_0xb876('0x44')]=function(_0x3ff9dd,_0xa4b1af){return db[_0xb876('0x28')][_0xb876('0x44')](_0x3ff9dd[_0xb876('0x45')],{})[_0xb876('0x1f')](function(_0x5147d7){var _0x556883=_0x3ff9dd['user'][_0xb876('0x21')]({'plain':!![]});if(!_0x556883)throw new Error(_0xb876('0x46'));if(_0x556883[_0xb876('0x47')]===_0xb876('0x48')){var _0x1975c5=_0x5147d7[_0xb876('0x21')]({'plain':!![]});var _0x2dc5c8=_0xb876('0x22');return db['UserProfileSection'][_0xb876('0x43')]({'where':{'name':_0x2dc5c8,'userProfileId':_0x556883[_0xb876('0x49')]},'raw':!![]})[_0xb876('0x1f')](function(_0x429ea9){if(_0x429ea9&&_0x429ea9['autoAssociation']===0x0){return db[_0xb876('0x23')][_0xb876('0x44')]({'name':_0x1975c5[_0xb876('0x25')],'resourceId':_0x1975c5['id'],'type':_0x429ea9[_0xb876('0x25')],'sectionId':_0x429ea9['id']},{})[_0xb876('0x1f')](function(){return _0x5147d7;});}else{return _0x5147d7;}})[_0xb876('0x41')](function(_0x4e683d){logger['error'](_0xb876('0x4a'),_0x4e683d);throw _0x4e683d;});}return _0x5147d7;})[_0xb876('0x1f')](respondWithResult(_0xa4b1af,0xc9))[_0xb876('0x41')](handleError(_0xa4b1af,null));};exports[_0xb876('0x4b')]=function(_0x4449c7,_0x5cd816){var _0x45c4f1={'where':{'id':_0x4449c7[_0xb876('0x42')]['id']}},_0x312b07={};_0x312b07[_0xb876('0x2c')]=_[_0xb876('0x2d')](db[_0xb876('0x28')]['rawAttributes']);_0x45c4f1[_0xb876('0x30')]=_[_0xb876('0x31')](_0x312b07[_0xb876('0x2c')],qs[_0xb876('0x32')](_0x4449c7[_0xb876('0x2e')][_0xb876('0x32')]));_0x45c4f1[_0xb876('0x30')]=_0x45c4f1[_0xb876('0x30')][_0xb876('0x33')]?_0x45c4f1[_0xb876('0x30')]:_0x312b07[_0xb876('0x2c')];if(_0x4449c7[_0xb876('0x2e')][_0xb876('0x3d')]){_0x45c4f1['include']=[{'all':!![]}];}_0x45c4f1=_[_0xb876('0x38')]({},_0x45c4f1,_0x4449c7[_0xb876('0x3c')]);return db[_0xb876('0x28')]['find'](_0x45c4f1)[_0xb876('0x1f')](handleEntityNotFound(_0x5cd816,null))['then'](function(_0x2212b9){if(_0x2212b9){var _0xed8ddd=_0x2212b9[_0xb876('0x21')]({'plain':!![]});_0xed8ddd=qs[_0xb876('0x4c')](_0xed8ddd,['id',_0xb876('0x4d'),_0xb876('0x4e')]);_0x4449c7[_0xb876('0x45')]=_[_0xb876('0x4c')](_0x4449c7[_0xb876('0x45')],['id',_0xb876('0x4d'),'updatedAt']);return db[_0xb876('0x28')][_0xb876('0x44')](_['merge'](_0xed8ddd,_0x4449c7['body']),{'include':_0x4449c7[_0xb876('0x2e')]['includeAll']?[{'all':!![]}]:undefined})[_0xb876('0x1f')](function(_0x46d588){var _0x35bb71=_0x4449c7[_0xb876('0x48')][_0xb876('0x21')]({'plain':!![]});if(!_0x35bb71)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x35bb71['role']===_0xb876('0x48')){var _0x503800=_0x46d588['get']({'plain':!![]});var _0xc3ca19=_0xb876('0x22');return db[_0xb876('0x4f')][_0xb876('0x43')]({'where':{'name':_0xc3ca19,'userProfileId':_0x35bb71[_0xb876('0x49')]},'raw':!![]})[_0xb876('0x1f')](function(_0xeebd1f){if(_0xeebd1f&&_0xeebd1f[_0xb876('0x50')]===0x0){return db['UserProfileResource']['create']({'name':_0x503800[_0xb876('0x25')],'resourceId':_0x503800['id'],'type':_0xeebd1f[_0xb876('0x25')],'sectionId':_0xeebd1f['id']},{})['then'](function(){return _0x46d588;});}else{return _0x46d588;}})['catch'](function(_0x11924f){logger[_0xb876('0x51')](_0xb876('0x4a'),_0x11924f);throw _0x11924f;});}return _0x46d588;});}})['then'](respondWithResult(_0x5cd816,0xc9))[_0xb876('0x41')](handleError(_0x5cd816,null));};exports['update']=function(_0x43e878,_0x1e5ead){if(_0x43e878[_0xb876('0x45')]['id']){delete _0x43e878[_0xb876('0x45')]['id'];}return db['Campaign'][_0xb876('0x43')]({'where':{'id':_0x43e878['params']['id']}})['then'](handleEntityNotFound(_0x1e5ead,null))[_0xb876('0x1f')](saveUpdates(_0x43e878[_0xb876('0x45')],null))[_0xb876('0x1f')](respondWithResult(_0x1e5ead,null))[_0xb876('0x41')](handleError(_0x1e5ead,null));};exports[_0xb876('0x20')]=function(_0x220720,_0x1c757c){return db['Campaign']['find']({'where':{'id':_0x220720[_0xb876('0x42')]['id']}})[_0xb876('0x1f')](handleEntityNotFound(_0x1c757c,null))[_0xb876('0x1f')](removeEntity(_0x1c757c,null))[_0xb876('0x41')](handleError(_0x1c757c,null));};exports[_0xb876('0x52')]=function(_0x153032,_0x47fe19,_0x58d516){var _0x44d64e={'raw':!![],'where':{}};var _0x4ac18d={};var _0x484fbd={'count':0x0,'rows':[]};return db['Campaign'][_0xb876('0x53')]({'where':{'id':_0x153032['params']['id']}})[_0xb876('0x1f')](handleEntityNotFound(_0x47fe19,null))[_0xb876('0x1f')](function(_0x175aaf){if(_0x175aaf){_0x4ac18d[_0xb876('0x2c')]=_[_0xb876('0x2d')](db[_0xb876('0x54')][_0xb876('0x29')]);_0x4ac18d[_0xb876('0x2e')]=_['keys'](_0x153032[_0xb876('0x2e')]);_0x4ac18d[_0xb876('0x2f')]=_['intersection'](_0x4ac18d[_0xb876('0x2c')],_0x4ac18d[_0xb876('0x2e')]);_0x44d64e[_0xb876('0x30')]=_['intersection'](_0x4ac18d['model'],qs['fields'](_0x153032['query'][_0xb876('0x32')]));_0x44d64e[_0xb876('0x30')]=_0x44d64e['attributes'][_0xb876('0x33')]?_0x44d64e[_0xb876('0x30')]:_0x4ac18d[_0xb876('0x2c')];if(!_0x153032['query']['hasOwnProperty']('nolimit')){_0x44d64e[_0xb876('0x18')]=qs[_0xb876('0x18')](_0x153032['query']['limit']);_0x44d64e[_0xb876('0x16')]=qs['offset'](_0x153032[_0xb876('0x2e')][_0xb876('0x16')]);}_0x44d64e[_0xb876('0x34')]=qs[_0xb876('0x35')](_0x153032[_0xb876('0x2e')][_0xb876('0x35')]);_0x44d64e[_0xb876('0x36')]=qs[_0xb876('0x2f')](_[_0xb876('0x37')](_0x153032['query'],_0x4ac18d[_0xb876('0x2f')]));_0x44d64e[_0xb876('0x36')]['CampaignId']=_0x175aaf['id'];if(_0x153032['query'][_0xb876('0x3b')]){_0x44d64e['where']=_['merge'](_0x44d64e[_0xb876('0x36')],{'$or':_[_0xb876('0x27')](_0x44d64e[_0xb876('0x30')],function(_0x40bdf9){var _0x31a090={};_0x31a090[_0x40bdf9]={'$like':'%'+_0x153032[_0xb876('0x2e')][_0xb876('0x3b')]+'%'};return _0x31a090;})});}_0x44d64e=_[_0xb876('0x38')]({},_0x44d64e,_0x153032[_0xb876('0x3c')]);return db['CmHopper'][_0xb876('0x19')]({'where':_0x44d64e[_0xb876('0x36')]})[_0xb876('0x1f')](function(_0x30ad49){_0x484fbd[_0xb876('0x19')]=_0x30ad49;if(_0x153032[_0xb876('0x2e')][_0xb876('0x3d')]){_0x44d64e['include']=[{'all':!![]}];}return db[_0xb876('0x54')][_0xb876('0x3f')](_0x44d64e);})[_0xb876('0x1f')](function(_0x13a267){_0x484fbd['rows']=_0x13a267;return _0x484fbd;});}})[_0xb876('0x1f')](respondWithFilteredResult(_0x47fe19,_0x44d64e))[_0xb876('0x41')](handleError(_0x47fe19,null));};exports[_0xb876('0x55')]=function(_0x349680,_0x4ec909,_0x3acd8d){var _0xe66fbf={'raw':!![],'where':{}};var _0x3b077c={};var _0x5704f7={'count':0x0,'rows':[]};return db[_0xb876('0x28')][_0xb876('0x53')]({'where':{'id':_0x349680[_0xb876('0x42')]['id']}})['then'](handleEntityNotFound(_0x4ec909,null))[_0xb876('0x1f')](function(_0x14adca){if(_0x14adca){_0x3b077c[_0xb876('0x2c')]=_['keys'](db['CmHopperHistory']['rawAttributes']);_0x3b077c[_0xb876('0x2e')]=_[_0xb876('0x2d')](_0x349680['query']);_0x3b077c[_0xb876('0x2f')]=_['intersection'](_0x3b077c[_0xb876('0x2c')],_0x3b077c[_0xb876('0x2e')]);_0xe66fbf[_0xb876('0x30')]=_['intersection'](_0x3b077c['model'],qs['fields'](_0x349680[_0xb876('0x2e')]['fields']));_0xe66fbf[_0xb876('0x30')]=_0xe66fbf[_0xb876('0x30')][_0xb876('0x33')]?_0xe66fbf[_0xb876('0x30')]:_0x3b077c[_0xb876('0x2c')];if(!_0x349680[_0xb876('0x2e')][_0xb876('0x56')](_0xb876('0x57'))){_0xe66fbf['limit']=qs['limit'](_0x349680[_0xb876('0x2e')][_0xb876('0x18')]);_0xe66fbf[_0xb876('0x16')]=qs[_0xb876('0x16')](_0x349680[_0xb876('0x2e')][_0xb876('0x16')]);}_0xe66fbf['order']=qs[_0xb876('0x35')](_0x349680[_0xb876('0x2e')][_0xb876('0x35')]);_0xe66fbf[_0xb876('0x36')]=qs[_0xb876('0x2f')](_['pick'](_0x349680['query'],_0x3b077c[_0xb876('0x2f')]));_0xe66fbf[_0xb876('0x36')]['CampaignId']=_0x14adca['id'];if(_0x349680['query']['filter']){_0xe66fbf[_0xb876('0x36')]=_[_0xb876('0x38')](_0xe66fbf[_0xb876('0x36')],{'$or':_[_0xb876('0x27')](_0xe66fbf['attributes'],function(_0x436ed4){var _0x246f22={};_0x246f22[_0x436ed4]={'$like':'%'+_0x349680['query'][_0xb876('0x3b')]+'%'};return _0x246f22;})});}_0xe66fbf=_[_0xb876('0x38')]({},_0xe66fbf,_0x349680['options']);return db[_0xb876('0x58')][_0xb876('0x19')]({'where':_0xe66fbf[_0xb876('0x36')]})[_0xb876('0x1f')](function(_0xd5466e){_0x5704f7[_0xb876('0x19')]=_0xd5466e;if(_0x349680['query'][_0xb876('0x3d')]){_0xe66fbf['include']=[{'all':!![]}];}return db['CmHopperHistory']['findAll'](_0xe66fbf);})[_0xb876('0x1f')](function(_0x4fe0e1){_0x5704f7[_0xb876('0x40')]=_0x4fe0e1;return _0x5704f7;});}})[_0xb876('0x1f')](respondWithFilteredResult(_0x4ec909,_0xe66fbf))[_0xb876('0x41')](handleError(_0x4ec909,null));};exports[_0xb876('0x59')]=function(_0x4d5771,_0x5d1d68,_0x29bf4b){var _0x249713={'raw':!![],'where':{}};var _0x5bb31a={};var _0x1f3a46={'count':0x0,'rows':[]};return db[_0xb876('0x28')]['findOne']({'where':{'id':_0x4d5771[_0xb876('0x42')]['id']}})[_0xb876('0x1f')](handleEntityNotFound(_0x5d1d68,null))[_0xb876('0x1f')](function(_0x5ceba8){if(_0x5ceba8){_0x5bb31a[_0xb876('0x2c')]=_['keys'](db[_0xb876('0x5a')][_0xb876('0x29')]);_0x5bb31a[_0xb876('0x2e')]=_[_0xb876('0x2d')](_0x4d5771[_0xb876('0x2e')]);_0x5bb31a[_0xb876('0x2f')]=_[_0xb876('0x31')](_0x5bb31a[_0xb876('0x2c')],_0x5bb31a[_0xb876('0x2e')]);_0x249713[_0xb876('0x30')]=_[_0xb876('0x31')](_0x5bb31a[_0xb876('0x2c')],qs[_0xb876('0x32')](_0x4d5771[_0xb876('0x2e')]['fields']));_0x249713[_0xb876('0x30')]=_0x249713[_0xb876('0x30')][_0xb876('0x33')]?_0x249713[_0xb876('0x30')]:_0x5bb31a['model'];if(!_0x4d5771['query'][_0xb876('0x56')](_0xb876('0x57'))){_0x249713[_0xb876('0x18')]=qs[_0xb876('0x18')](_0x4d5771[_0xb876('0x2e')]['limit']);_0x249713[_0xb876('0x16')]=qs[_0xb876('0x16')](_0x4d5771[_0xb876('0x2e')][_0xb876('0x16')]);}_0x249713[_0xb876('0x34')]=qs['sort'](_0x4d5771[_0xb876('0x2e')][_0xb876('0x35')]);_0x249713[_0xb876('0x36')]=qs[_0xb876('0x2f')](_[_0xb876('0x37')](_0x4d5771['query'],_0x5bb31a[_0xb876('0x2f')]));_0x249713[_0xb876('0x36')][_0xb876('0x5b')]=_0x5ceba8['id'];if(_0x4d5771[_0xb876('0x2e')][_0xb876('0x3b')]){_0x249713[_0xb876('0x36')]=_[_0xb876('0x38')](_0x249713[_0xb876('0x36')],{'$or':_[_0xb876('0x27')](_0x249713[_0xb876('0x30')],function(_0x56034b){var _0x5209f3={};_0x5209f3[_0x56034b]={'$like':'%'+_0x4d5771[_0xb876('0x2e')]['filter']+'%'};return _0x5209f3;})});}_0x249713=_['merge']({},_0x249713,_0x4d5771[_0xb876('0x3c')]);return db[_0xb876('0x5a')][_0xb876('0x19')]({'where':_0x249713[_0xb876('0x36')]})[_0xb876('0x1f')](function(_0x37369f){_0x1f3a46[_0xb876('0x19')]=_0x37369f;if(_0x4d5771['query'][_0xb876('0x3d')]){_0x249713[_0xb876('0x3e')]=[{'all':!![]}];}return db['CmHopperFinal']['findAll'](_0x249713);})[_0xb876('0x1f')](function(_0x3908d5){_0x1f3a46['rows']=_0x3908d5;return _0x1f3a46;});}})[_0xb876('0x1f')](respondWithFilteredResult(_0x5d1d68,_0x249713))['catch'](handleError(_0x5d1d68,null));};exports['getHopperBlacks']=function(_0x411caf,_0x148419,_0x2b15b3){var _0x4a2b62={'raw':!![],'where':{}};var _0x51e54b={};var _0x220d35={'count':0x0,'rows':[]};return db[_0xb876('0x28')][_0xb876('0x53')]({'where':{'id':_0x411caf['params']['id']}})['then'](handleEntityNotFound(_0x148419,null))['then'](function(_0x790b3){if(_0x790b3){_0x51e54b['model']=_[_0xb876('0x2d')](db[_0xb876('0x5c')]['rawAttributes']);_0x51e54b[_0xb876('0x2e')]=_[_0xb876('0x2d')](_0x411caf[_0xb876('0x2e')]);_0x51e54b['filters']=_[_0xb876('0x31')](_0x51e54b['model'],_0x51e54b['query']);_0x4a2b62[_0xb876('0x30')]=_[_0xb876('0x31')](_0x51e54b[_0xb876('0x2c')],qs['fields'](_0x411caf[_0xb876('0x2e')][_0xb876('0x32')]));_0x4a2b62[_0xb876('0x30')]=_0x4a2b62['attributes']['length']?_0x4a2b62[_0xb876('0x30')]:_0x51e54b['model'];if(!_0x411caf['query'][_0xb876('0x56')](_0xb876('0x57'))){_0x4a2b62[_0xb876('0x18')]=qs[_0xb876('0x18')](_0x411caf[_0xb876('0x2e')][_0xb876('0x18')]);_0x4a2b62[_0xb876('0x16')]=qs[_0xb876('0x16')](_0x411caf[_0xb876('0x2e')][_0xb876('0x16')]);}_0x4a2b62['order']=qs[_0xb876('0x35')](_0x411caf[_0xb876('0x2e')][_0xb876('0x35')]);_0x4a2b62[_0xb876('0x36')]=qs['filters'](_['pick'](_0x411caf[_0xb876('0x2e')],_0x51e54b[_0xb876('0x2f')]));_0x4a2b62[_0xb876('0x36')][_0xb876('0x5b')]=_0x790b3['id'];if(_0x411caf[_0xb876('0x2e')]['filter']){_0x4a2b62[_0xb876('0x36')]=_['merge'](_0x4a2b62[_0xb876('0x36')],{'$or':_[_0xb876('0x27')](_0x4a2b62[_0xb876('0x30')],function(_0x31e14f){var _0x3de37d={};_0x3de37d[_0x31e14f]={'$like':'%'+_0x411caf[_0xb876('0x2e')][_0xb876('0x3b')]+'%'};return _0x3de37d;})});}_0x4a2b62=_[_0xb876('0x38')]({},_0x4a2b62,_0x411caf[_0xb876('0x3c')]);return db[_0xb876('0x5c')][_0xb876('0x19')]({'where':_0x4a2b62[_0xb876('0x36')]})[_0xb876('0x1f')](function(_0xc1d7fb){_0x220d35[_0xb876('0x19')]=_0xc1d7fb;if(_0x411caf['query']['includeAll']){_0x4a2b62[_0xb876('0x3e')]=[{'all':!![]}];}return db[_0xb876('0x5c')]['findAll'](_0x4a2b62);})[_0xb876('0x1f')](function(_0x56b963){_0x220d35[_0xb876('0x40')]=_0x56b963;return _0x220d35;});}})[_0xb876('0x1f')](respondWithFilteredResult(_0x148419,_0x4a2b62))[_0xb876('0x41')](handleError(_0x148419,null));};exports['getLists']=function(_0x57f1ad,_0x56f33e,_0x529cc2){var _0x456ffb={};var _0x47eb6f={};var _0x3700f1;var _0x5d2ead;return db[_0xb876('0x28')][_0xb876('0x53')]({'where':{'id':_0x57f1ad[_0xb876('0x42')]['id']}})[_0xb876('0x1f')](handleEntityNotFound(_0x56f33e,null))['then'](function(_0x45e885){if(_0x45e885){_0x3700f1=_0x45e885;_0x47eb6f['model']=_[_0xb876('0x2d')](db[_0xb876('0x5d')][_0xb876('0x29')]);_0x47eb6f[_0xb876('0x2e')]=_['keys'](_0x57f1ad['query']);_0x47eb6f[_0xb876('0x2f')]=_[_0xb876('0x31')](_0x47eb6f['model'],_0x47eb6f[_0xb876('0x2e')]);_0x456ffb[_0xb876('0x30')]=_[_0xb876('0x31')](_0x47eb6f[_0xb876('0x2c')],qs[_0xb876('0x32')](_0x57f1ad[_0xb876('0x2e')][_0xb876('0x32')]));_0x456ffb[_0xb876('0x30')]=_0x456ffb['attributes']['length']?_0x456ffb['attributes']:_0x47eb6f[_0xb876('0x2c')];_0x456ffb['order']=qs[_0xb876('0x35')](_0x57f1ad[_0xb876('0x2e')][_0xb876('0x35')]);_0x456ffb[_0xb876('0x36')]=qs[_0xb876('0x2f')](_['pick'](_0x57f1ad[_0xb876('0x2e')],_0x47eb6f[_0xb876('0x2f')]));if(_0x57f1ad[_0xb876('0x2e')][_0xb876('0x3b')]){_0x456ffb[_0xb876('0x36')]=_[_0xb876('0x38')](_0x456ffb[_0xb876('0x36')],{'$or':_[_0xb876('0x27')](_0x456ffb[_0xb876('0x30')],function(_0x53e2f0){var _0x2dfe7f={};_0x2dfe7f[_0x53e2f0]={'$like':'%'+_0x57f1ad['query'][_0xb876('0x3b')]+'%'};return _0x2dfe7f;})});}_0x456ffb=_[_0xb876('0x38')]({},_0x456ffb,_0x57f1ad[_0xb876('0x3c')]);return _0x3700f1[_0xb876('0x5e')](_0x456ffb);}})['then'](function(_0x520da7){if(_0x520da7){_0x5d2ead=_0x520da7['length'];if(!_0x57f1ad[_0xb876('0x2e')][_0xb876('0x56')](_0xb876('0x57'))){_0x456ffb['limit']=qs[_0xb876('0x18')](_0x57f1ad[_0xb876('0x2e')]['limit']);_0x456ffb[_0xb876('0x16')]=qs[_0xb876('0x16')](_0x57f1ad[_0xb876('0x2e')][_0xb876('0x16')]);}return _0x3700f1['getLists'](_0x456ffb);}})[_0xb876('0x1f')](function(_0x1083e5){if(_0x1083e5){return _0x1083e5?{'count':_0x5d2ead,'rows':_0x1083e5}:null;}})[_0xb876('0x1f')](respondWithResult(_0x56f33e,null))['catch'](handleError(_0x56f33e,null));};exports['addLists']=function(_0x2e6699,_0x39b2bb,_0x2436a8){var _0x3901d7,_0x4045a0;var _0x39bf86=[];var _0x1b6f64=moment()[_0xb876('0x5f')](_0xb876('0x60'));return db['Campaign'][_0xb876('0x43')]({'where':{'id':_0x2e6699[_0xb876('0x42')]['id']}})[_0xb876('0x1f')](handleEntityNotFound(_0x39b2bb,null))[_0xb876('0x1f')](function(_0x14339a){if(_0x14339a){_0x4045a0=_0x14339a;return _0x14339a['addLists'](_0x2e6699[_0xb876('0x45')][_0xb876('0x61')],_[_0xb876('0x4c')](_0x2e6699['body'],[_0xb876('0x61'),'id'])||{});}return null;})[_0xb876('0x62')](function(_0x56f233){var _0x1219b4;var _0x3950d9;_0x3901d7=_0x56f233||[];var _0x4fc603=[];if(_0x56f233){for(var _0x258768=0x0;_0x258768<_0x56f233[_0xb876('0x33')];_0x258768+=0x1){var _0x4f73a7=_0x56f233[_0x258768][_0xb876('0x21')]({'plain':!![]});_0x4045a0[_0xb876('0x63')]=_0x2e6699[_0xb876('0x45')][_0xb876('0x63')]?_0x2e6699[_0xb876('0x45')][_0xb876('0x63')]:_0x4045a0[_0xb876('0x63')];switch(_0x4045a0[_0xb876('0x63')]){case'always':_0x1219b4=squel[_0xb876('0x64')]()[_0xb876('0x65')](_0xb876('0x66'))[_0xb876('0x67')]([_0xb876('0x68'),'scheduledAt','ContactId',_0xb876('0x69'),'CampaignId',_0xb876('0x4d'),_0xb876('0x4e')],squel['select']()[_0xb876('0x6a')]('phone',_0xb876('0x68'))[_0xb876('0x6a')](_0xb876('0x6b'),_0xb876('0x6c'))[_0xb876('0x6a')]('id',_0xb876('0x6d'))['field'](_0x4f73a7[_0xb876('0x6e')][_0xb876('0x6f')](),_0xb876('0x69'))['field'](_0x2e6699[_0xb876('0x42')]['id'][_0xb876('0x6f')](),_0xb876('0x5b'))[_0xb876('0x6a')]('\x27'+_0x1b6f64+'\x27',_0xb876('0x4d'))[_0xb876('0x6a')]('\x27'+_0x1b6f64+'\x27','updatedAt')[_0xb876('0x70')]('cm_contacts')[_0xb876('0x36')](_0xb876('0x71'))[_0xb876('0x36')](_0xb876('0x72'),_0x4f73a7[_0xb876('0x6e')]['toString']())[_0xb876('0x36')](_0xb876('0x73'))[_0xb876('0x36')](_0xb876('0x74'),squel['select']()[_0xb876('0x6a')]('COALESCE(calleridnum,\x27\x27)')[_0xb876('0x70')](_0xb876('0x75'))['where'](_0xb876('0x76'),_0x2e6699[_0xb876('0x42')]['id'][_0xb876('0x6f')]()))[_0xb876('0x36')](_0xb876('0x74'),squel[_0xb876('0x77')]()['field'](_0xb876('0x78'))[_0xb876('0x70')](_0xb876('0x66'))[_0xb876('0x36')](_0xb876('0x76'),_0x2e6699[_0xb876('0x42')]['id'][_0xb876('0x6f')]())))[_0xb876('0x6f')]();break;case _0xb876('0x79'):_0x1219b4=squel['insert']()[_0xb876('0x65')](_0xb876('0x66'))['fromQuery'](['phone',_0xb876('0x6c'),_0xb876('0x6d'),_0xb876('0x69'),_0xb876('0x5b'),_0xb876('0x4d'),'updatedAt'],squel[_0xb876('0x77')]()[_0xb876('0x6a')](_0xb876('0x68'),_0xb876('0x68'))['field'](_0xb876('0x6b'),_0xb876('0x6c'))[_0xb876('0x6a')]('id',_0xb876('0x6d'))['field'](_0x4f73a7['CmListId'][_0xb876('0x6f')](),_0xb876('0x69'))[_0xb876('0x6a')](_0x2e6699[_0xb876('0x42')]['id'][_0xb876('0x6f')](),_0xb876('0x5b'))[_0xb876('0x6a')]('\x27'+_0x1b6f64+'\x27','createdAt')[_0xb876('0x6a')]('\x27'+_0x1b6f64+'\x27','updatedAt')[_0xb876('0x70')]('cm_contacts')[_0xb876('0x36')](_0xb876('0x71'))['where'](_0xb876('0x72'),_0x4f73a7[_0xb876('0x6e')][_0xb876('0x6f')]())[_0xb876('0x36')](_0xb876('0x73'))['where']('phone\x20NOT\x20IN\x20(?)',squel['select']()['field'](_0xb876('0x78'))[_0xb876('0x70')]('cm_hopper')[_0xb876('0x36')](_0xb876('0x76'),_0x2e6699[_0xb876('0x42')]['id']['toString']())))['toString']();break;default:_0x1219b4=squel[_0xb876('0x64')]()['into']('cm_hopper')[_0xb876('0x67')]([_0xb876('0x68'),'scheduledAt',_0xb876('0x6d'),_0xb876('0x69'),_0xb876('0x5b'),'createdAt',_0xb876('0x4e')],squel[_0xb876('0x77')]()[_0xb876('0x6a')]('phone',_0xb876('0x68'))[_0xb876('0x6a')](_0xb876('0x6b'),_0xb876('0x6c'))[_0xb876('0x6a')]('id',_0xb876('0x6d'))['field'](_0x4f73a7[_0xb876('0x6e')][_0xb876('0x6f')](),'ListId')[_0xb876('0x6a')](_0x2e6699[_0xb876('0x42')]['id'][_0xb876('0x6f')](),_0xb876('0x5b'))[_0xb876('0x6a')]('\x27'+_0x1b6f64+'\x27',_0xb876('0x4d'))[_0xb876('0x6a')]('\x27'+_0x1b6f64+'\x27',_0xb876('0x4e'))[_0xb876('0x70')](_0xb876('0x7a'))[_0xb876('0x36')]('deletedAt\x20IS\x20NULL')[_0xb876('0x36')](_0xb876('0x72'),_0x4f73a7[_0xb876('0x6e')][_0xb876('0x6f')]())[_0xb876('0x36')](_0xb876('0x73')))[_0xb876('0x6f')]();}_0x3950d9=squel['insert']()[_0xb876('0x65')](_0xb876('0x7b'))[_0xb876('0x67')]([_0xb876('0x7c'),'scheduledAt',_0xb876('0x68'),'OrderBy','createdAt',_0xb876('0x4e')],squel['select']()[_0xb876('0x6a')](_0xb876('0x7d'),'id')[_0xb876('0x6a')]('NOW()',_0xb876('0x6c'))[_0xb876('0x6a')](_0xb876('0x7e'),'phone')[_0xb876('0x6a')]('ci.OrderBY',_0xb876('0x7f'))[_0xb876('0x6a')]('\x27'+_0x1b6f64+'\x27',_0xb876('0x4d'))[_0xb876('0x6a')]('\x27'+_0x1b6f64+'\x27',_0xb876('0x4e'))[_0xb876('0x70')](_0xb876('0x80'),'ci')[_0xb876('0x81')](_0xb876('0x66'),'h',_0xb876('0x82'))['where']('h.ListId\x20=\x20?',_0x4f73a7[_0xb876('0x6e')][_0xb876('0x6f')]())[_0xb876('0x36')](_0xb876('0x83'),_0x2e6699[_0xb876('0x42')]['id'][_0xb876('0x6f')]())['where'](_0xb876('0x84'),_0x1b6f64))[_0xb876('0x6f')]();_0x4fc603['push'](db[_0xb876('0x85')]['query'](_0x1219b4));_0x39bf86[_0xb876('0x86')](db[_0xb876('0x85')][_0xb876('0x2e')](_0x3950d9));}return BPromise['all'](_0x4fc603);}})[_0xb876('0x1f')](function(){return BPromise[_0xb876('0x87')](_0x39bf86);})[_0xb876('0x1f')](function(){return _0x3901d7;})[_0xb876('0x1f')](respondWithResult(_0x39b2bb,null))[_0xb876('0x41')](handleError(_0x39b2bb,null));};exports[_0xb876('0x88')]=function(_0x386109,_0x321cb5,_0x140184){return db[_0xb876('0x28')][_0xb876('0x43')]({'where':{'id':_0x386109[_0xb876('0x42')]['id']}})[_0xb876('0x1f')](handleEntityNotFound(_0x321cb5,null))[_0xb876('0x1f')](function(_0x3b9b87){if(_0x3b9b87){return _0x3b9b87[_0xb876('0x88')](_0x386109[_0xb876('0x2e')][_0xb876('0x61')]);}})[_0xb876('0x1f')](function(_0x233555){if(_0x233555){return db['CmHopper'][_0xb876('0x20')]({'where':{'ListId':_0x386109[_0xb876('0x2e')][_0xb876('0x61')],'CampaignId':_0x386109[_0xb876('0x42')]['id']}})['then'](function(){return _0x233555;});}})[_0xb876('0x1f')](respondWithStatusCode(_0x321cb5,null))[_0xb876('0x41')](handleError(_0x321cb5,null));};exports[_0xb876('0x89')]=function(_0x57c1fd,_0x2a44b0,_0x2c22d3){var _0x387cbc={};var _0x56eef4={};var _0x42cb73;var _0x5c654f;return db[_0xb876('0x28')]['findOne']({'where':{'id':_0x57c1fd[_0xb876('0x42')]['id']}})[_0xb876('0x1f')](handleEntityNotFound(_0x2a44b0,null))[_0xb876('0x1f')](function(_0x4e4000){if(_0x4e4000){_0x42cb73=_0x4e4000;_0x56eef4[_0xb876('0x2c')]=_[_0xb876('0x2d')](db[_0xb876('0x5d')][_0xb876('0x29')]);_0x56eef4[_0xb876('0x2e')]=_[_0xb876('0x2d')](_0x57c1fd[_0xb876('0x2e')]);_0x56eef4['filters']=_[_0xb876('0x31')](_0x56eef4['model'],_0x56eef4[_0xb876('0x2e')]);_0x387cbc[_0xb876('0x30')]=_[_0xb876('0x31')](_0x56eef4[_0xb876('0x2c')],qs[_0xb876('0x32')](_0x57c1fd[_0xb876('0x2e')][_0xb876('0x32')]));_0x387cbc[_0xb876('0x30')]=_0x387cbc[_0xb876('0x30')]['length']?_0x387cbc[_0xb876('0x30')]:_0x56eef4[_0xb876('0x2c')];_0x387cbc['order']=qs[_0xb876('0x35')](_0x57c1fd['query'][_0xb876('0x35')]);_0x387cbc[_0xb876('0x36')]=qs[_0xb876('0x2f')](_['pick'](_0x57c1fd[_0xb876('0x2e')],_0x56eef4[_0xb876('0x2f')]));if(_0x57c1fd['query'][_0xb876('0x3b')]){_0x387cbc[_0xb876('0x36')]=_[_0xb876('0x38')](_0x387cbc[_0xb876('0x36')],{'$or':_[_0xb876('0x27')](_0x387cbc[_0xb876('0x30')],function(_0xfb3fc6){var _0x173021={};_0x173021[_0xfb3fc6]={'$like':'%'+_0x57c1fd[_0xb876('0x2e')]['filter']+'%'};return _0x173021;})});}_0x387cbc=_[_0xb876('0x38')]({},_0x387cbc,_0x57c1fd[_0xb876('0x3c')]);return _0x42cb73['getBlackLists'](_0x387cbc);}})[_0xb876('0x1f')](function(_0x5f49f8){if(_0x5f49f8){_0x5c654f=_0x5f49f8[_0xb876('0x33')];if(!_0x57c1fd[_0xb876('0x2e')]['hasOwnProperty'](_0xb876('0x57'))){_0x387cbc[_0xb876('0x18')]=qs[_0xb876('0x18')](_0x57c1fd[_0xb876('0x2e')]['limit']);_0x387cbc[_0xb876('0x16')]=qs[_0xb876('0x16')](_0x57c1fd[_0xb876('0x2e')][_0xb876('0x16')]);}return _0x42cb73[_0xb876('0x89')](_0x387cbc);}})[_0xb876('0x1f')](function(_0x45c2fd){if(_0x45c2fd){return _0x45c2fd?{'count':_0x5c654f,'rows':_0x45c2fd}:null;}})[_0xb876('0x1f')](respondWithResult(_0x2a44b0,null))['catch'](handleError(_0x2a44b0,null));};exports[_0xb876('0x8a')]=function(_0x76a80d,_0x325801,_0x1b4dca){var _0x473df5,_0x383b4a;var _0x118a20=[];var _0x5ce574=moment()[_0xb876('0x5f')](_0xb876('0x60'));return db[_0xb876('0x28')][_0xb876('0x43')]({'where':{'id':_0x76a80d[_0xb876('0x42')]['id']}})['then'](handleEntityNotFound(_0x325801,null))['then'](function(_0x5b740f){if(_0x5b740f){_0x383b4a=_0x5b740f;return _0x5b740f[_0xb876('0x8a')](_0x76a80d[_0xb876('0x45')]['ids'],_['omit'](_0x76a80d[_0xb876('0x45')],[_0xb876('0x61'),'id'])||{});}return null;})[_0xb876('0x62')](function(_0x3e9fe8){var _0x485471;var _0x5a0c44;_0x473df5=_0x3e9fe8||[];var _0x16710d=[];if(_0x3e9fe8){for(var _0x326844=0x0;_0x326844<_0x3e9fe8[_0xb876('0x33')];_0x326844+=0x1){var _0x1abe95=_0x3e9fe8[_0x326844][_0xb876('0x21')]({'plain':!![]});_0x485471=squel[_0xb876('0x64')]()[_0xb876('0x65')](_0xb876('0x8b'))['fromQuery']([_0xb876('0x68'),_0xb876('0x6d'),_0xb876('0x69'),_0xb876('0x5b'),_0xb876('0x4d'),'updatedAt'],squel[_0xb876('0x77')]()[_0xb876('0x6a')]('phone',_0xb876('0x68'))[_0xb876('0x6a')]('id',_0xb876('0x6d'))[_0xb876('0x6a')](_0x1abe95[_0xb876('0x6e')][_0xb876('0x6f')](),_0xb876('0x69'))[_0xb876('0x6a')](_0x76a80d[_0xb876('0x42')]['id']['toString'](),_0xb876('0x5b'))[_0xb876('0x6a')](_0xb876('0x6b'),_0xb876('0x4d'))[_0xb876('0x6a')](_0xb876('0x6b'),_0xb876('0x4e'))[_0xb876('0x70')](_0xb876('0x7a'))['where'](_0xb876('0x71'))[_0xb876('0x36')](_0xb876('0x72'),_0x1abe95[_0xb876('0x6e')][_0xb876('0x6f')]())['where'](_0xb876('0x73')))[_0xb876('0x6f')]();_0x16710d[_0xb876('0x86')](db[_0xb876('0x85')][_0xb876('0x2e')](_0x485471));}return BPromise[_0xb876('0x87')](_0x16710d);}})['then'](function(){return _0x473df5;})['then'](respondWithResult(_0x325801,null))['catch'](handleError(_0x325801,null));};exports[_0xb876('0x8c')]=function(_0x58ea07,_0x41e81e,_0x1fbe3a){return db[_0xb876('0x28')][_0xb876('0x43')]({'where':{'id':_0x58ea07['params']['id']}})['then'](handleEntityNotFound(_0x41e81e,null))[_0xb876('0x1f')](function(_0x4a333c){if(_0x4a333c){return _0x4a333c[_0xb876('0x8c')](_0x58ea07[_0xb876('0x2e')]['ids']);}})[_0xb876('0x1f')](function(_0x2060df){if(_0x2060df){return db[_0xb876('0x5c')][_0xb876('0x20')]({'where':{'ListId':_0x58ea07[_0xb876('0x2e')]['ids'],'CampaignId':_0x58ea07[_0xb876('0x42')]['id']}})[_0xb876('0x1f')](function(){return _0x2060df;});}})[_0xb876('0x1f')](respondWithStatusCode(_0x41e81e,null))[_0xb876('0x41')](handleError(_0x41e81e,null));};
\ No newline at end of file
+var _0x37e4=['stack','name','send','index','Campaign','rawAttributes','fieldName','type','key','model','map','query','keys','filters','intersection','fields','attributes','length','nolimit','order','sort','where','pick','VIRTUAL','merge','count','includeAll','include','findAll','rows','catch','show','params','create','body','user','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','IvrCampaigns','UserProfileSection','find','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','omit','createdAt','updatedAt','getHoppers','findOne','CmHopper','CampaignId','options','getHopperHistories','CmHopperHistory','hasOwnProperty','filter','getHopperFinals','CmHopperFinal','CmHopperBlack','getLists','CmList','addLists','format','spread','dialCheckDuplicateType','always','insert','into','cm_hopper','fromQuery','phone','scheduledAt','ContactId','ListId','select','field','NOW()','toString','from','ListId\x20=\x20?','COALESCE(calleridnum,\x27\x27)','CampaignId\x20=\x20?','COALESCE(phone,\x27\x27)','onlyIfOpen','phone\x20NOT\x20IN\x20(?)','CmListId','cm_contacts','deletedAt\x20IS\x20NULL','phone\x20IS\x20NOT\x20NULL','cm_hopper_additional_phones','OrderBy','h.id','ci.item','h.ContactId\x20=\x20ci.CmContactId','h.CampaignId=?','push','sequelize','all','ids','getBlackLists','addBlackLists','YYYY-MM-DD\x20HH:mm:ss','cm_hopper_black','removeBlackLists','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','sendStatus','status','end','json','offset','undefined','limit','Content-Range','apply','save','update','then','destroy','UserProfileResource','error'];(function(_0x212925,_0xc0e15b){var _0x39c17c=function(_0x1f4b94){while(--_0x1f4b94){_0x212925['push'](_0x212925['shift']());}};_0x39c17c(++_0xc0e15b);}(_0x37e4,0x18e));var _0x437e=function(_0x2ca453,_0x203db6){_0x2ca453=_0x2ca453-0x0;var _0x14b4b2=_0x37e4[_0x2ca453];return _0x14b4b2;};'use strict';var emlformat=require(_0x437e('0x0'));var rimraf=require(_0x437e('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x437e('0x2'));var rp=require(_0x437e('0x3'));var moment=require(_0x437e('0x4'));var BPromise=require(_0x437e('0x5'));var Mustache=require(_0x437e('0x6'));var util=require(_0x437e('0x7'));var path=require(_0x437e('0x8'));var sox=require(_0x437e('0x9'));var csv=require(_0x437e('0xa'));var ejs=require(_0x437e('0xb'));var fs=require('fs');var fs_extra=require(_0x437e('0xc'));var _=require(_0x437e('0xd'));var squel=require(_0x437e('0xe'));var crypto=require(_0x437e('0xf'));var jsforce=require(_0x437e('0x10'));var deskjs=require('desk.js');var toCsv=require(_0x437e('0xa'));var querystring=require('querystring');var Papa=require(_0x437e('0x11'));var Redis=require(_0x437e('0x12'));var authService=require('../../components/auth/service');var qs=require(_0x437e('0x13'));var as=require(_0x437e('0x14'));var hardwareService=require(_0x437e('0x15'));var logger=require(_0x437e('0x16'))(_0x437e('0x17'));var utils=require(_0x437e('0x18'));var config=require('../../config/environment');var licenseUtil=require('../../config/license/util');var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x3182b9,_0x268d1a){_0x268d1a=_0x268d1a||0xcc;return function(_0x1bee2b){if(_0x1bee2b){return _0x3182b9[_0x437e('0x19')](_0x268d1a);}return _0x3182b9[_0x437e('0x1a')](_0x268d1a)[_0x437e('0x1b')]();};}function respondWithResult(_0x158cdb,_0x204e1a){_0x204e1a=_0x204e1a||0xc8;return function(_0x1629be){if(_0x1629be){return _0x158cdb[_0x437e('0x1a')](_0x204e1a)[_0x437e('0x1c')](_0x1629be);}};}function respondWithFilteredResult(_0x1bab5a,_0x128156){return function(_0x5b3f56){if(_0x5b3f56){var _0x355c78=typeof _0x128156[_0x437e('0x1d')]===_0x437e('0x1e')&&typeof _0x128156[_0x437e('0x1f')]===_0x437e('0x1e');var _0x4ba700=_0x5b3f56['count'];var _0x58ef0f=_0x355c78?0x0:_0x128156['offset'];var _0x4ea09b=_0x355c78?_0x5b3f56['count']:_0x128156[_0x437e('0x1d')]+_0x128156['limit'];var _0x567a1a;if(_0x4ea09b>=_0x4ba700){_0x4ea09b=_0x4ba700;_0x567a1a=0xc8;}else{_0x567a1a=0xce;}_0x1bab5a[_0x437e('0x1a')](_0x567a1a);return _0x1bab5a['set'](_0x437e('0x20'),_0x58ef0f+'-'+_0x4ea09b+'/'+_0x4ba700)[_0x437e('0x1c')](_0x5b3f56);}return null;};}function patchUpdates(_0x595925){return function(_0x12b7db){try{jsonpatch[_0x437e('0x21')](_0x12b7db,_0x595925,!![]);}catch(_0x185559){return BPromise['reject'](_0x185559);}return _0x12b7db[_0x437e('0x22')]();};}function saveUpdates(_0x5e2997,_0x5ac03e){return function(_0x438db7){if(_0x438db7){return _0x438db7[_0x437e('0x23')](_0x5e2997)[_0x437e('0x24')](function(_0x151e64){return _0x151e64;});}return null;};}function removeEntity(_0x25dfca,_0x48e9a8){return function(_0x362821){if(_0x362821){return _0x362821[_0x437e('0x25')]()['then'](function(){var _0x36dfeb=_0x362821['get']({'plain':!![]});var _0x31b8e8='IvrCampaigns';return db[_0x437e('0x26')][_0x437e('0x25')]({'where':{'type':_0x31b8e8,'resourceId':_0x36dfeb['id']}})[_0x437e('0x24')](function(){return _0x362821;});})['then'](function(){_0x25dfca['status'](0xcc)[_0x437e('0x1b')]();});}};}function handleEntityNotFound(_0x3b7baf,_0x5c546f){return function(_0x5a224c){if(!_0x5a224c){_0x3b7baf[_0x437e('0x19')](0x194);}return _0x5a224c;};}function handleError(_0x15cb81,_0x541087){_0x541087=_0x541087||0x1f4;return function(_0x27a269){logger[_0x437e('0x27')](_0x27a269[_0x437e('0x28')]);if(_0x27a269[_0x437e('0x29')]){delete _0x27a269[_0x437e('0x29')];}_0x15cb81[_0x437e('0x1a')](_0x541087)[_0x437e('0x2a')](_0x27a269);};}exports[_0x437e('0x2b')]=function(_0x2c54c8,_0x2950de){var _0x148320={},_0x397a33={},_0x1fab11={'count':0x0,'rows':[]};var _0x420437=_['map'](db[_0x437e('0x2c')][_0x437e('0x2d')],function(_0x16bdf1){return{'name':_0x16bdf1[_0x437e('0x2e')],'type':_0x16bdf1[_0x437e('0x2f')][_0x437e('0x30')]};});_0x397a33[_0x437e('0x31')]=_[_0x437e('0x32')](_0x420437,_0x437e('0x29'));_0x397a33[_0x437e('0x33')]=_[_0x437e('0x34')](_0x2c54c8[_0x437e('0x33')]);_0x397a33[_0x437e('0x35')]=_[_0x437e('0x36')](_0x397a33['model'],_0x397a33['query']);_0x148320['attributes']=_[_0x437e('0x36')](_0x397a33[_0x437e('0x31')],qs[_0x437e('0x37')](_0x2c54c8[_0x437e('0x33')][_0x437e('0x37')]));_0x148320['attributes']=_0x148320[_0x437e('0x38')][_0x437e('0x39')]?_0x148320['attributes']:_0x397a33['model'];if(!_0x2c54c8[_0x437e('0x33')]['hasOwnProperty'](_0x437e('0x3a'))){_0x148320[_0x437e('0x1f')]=qs[_0x437e('0x1f')](_0x2c54c8['query'][_0x437e('0x1f')]);_0x148320[_0x437e('0x1d')]=qs[_0x437e('0x1d')](_0x2c54c8['query'][_0x437e('0x1d')]);}_0x148320[_0x437e('0x3b')]=qs[_0x437e('0x3c')](_0x2c54c8[_0x437e('0x33')]['sort']);_0x148320[_0x437e('0x3d')]=qs[_0x437e('0x35')](_[_0x437e('0x3e')](_0x2c54c8[_0x437e('0x33')],_0x397a33[_0x437e('0x35')]),_0x420437);if(_0x2c54c8[_0x437e('0x33')]['filter']){_0x148320[_0x437e('0x3d')]=_['merge'](_0x148320[_0x437e('0x3d')],{'$or':_[_0x437e('0x32')](_0x420437,function(_0x52273f){if(_0x52273f[_0x437e('0x2f')]!==_0x437e('0x3f')){var _0x50be9f={};_0x50be9f[_0x52273f[_0x437e('0x29')]]={'$like':'%'+_0x2c54c8[_0x437e('0x33')]['filter']+'%'};return _0x50be9f;}})});}_0x148320=_[_0x437e('0x40')]({},_0x148320,_0x2c54c8['options']);var _0x4ee63b={'where':_0x148320[_0x437e('0x3d')]};return db['Campaign'][_0x437e('0x41')](_0x4ee63b)['then'](function(_0x59a419){_0x1fab11['count']=_0x59a419;if(_0x2c54c8[_0x437e('0x33')][_0x437e('0x42')]){_0x148320[_0x437e('0x43')]=[{'all':!![]}];}return db[_0x437e('0x2c')][_0x437e('0x44')](_0x148320);})['then'](function(_0xe13d91){_0x1fab11[_0x437e('0x45')]=_0xe13d91;return _0x1fab11;})[_0x437e('0x24')](respondWithFilteredResult(_0x2950de,_0x148320))[_0x437e('0x46')](handleError(_0x2950de,null));};exports[_0x437e('0x47')]=function(_0x598dba,_0x1fc68b){var _0x298067={'raw':![],'where':{'id':_0x598dba[_0x437e('0x48')]['id']}},_0x16ffe6={};_0x16ffe6[_0x437e('0x31')]=_[_0x437e('0x34')](db[_0x437e('0x2c')][_0x437e('0x2d')]);_0x16ffe6['query']=_['keys'](_0x598dba['query']);_0x16ffe6['filters']=_[_0x437e('0x36')](_0x16ffe6['model'],_0x16ffe6[_0x437e('0x33')]);_0x298067[_0x437e('0x38')]=_['intersection'](_0x16ffe6[_0x437e('0x31')],qs['fields'](_0x598dba['query'][_0x437e('0x37')]));_0x298067[_0x437e('0x38')]=_0x298067[_0x437e('0x38')][_0x437e('0x39')]?_0x298067['attributes']:_0x16ffe6[_0x437e('0x31')];if(_0x598dba['query'][_0x437e('0x42')]){_0x298067[_0x437e('0x43')]=[{'all':!![]}];}_0x298067=_[_0x437e('0x40')]({},_0x298067,_0x598dba['options']);return db[_0x437e('0x2c')]['find'](_0x298067)[_0x437e('0x24')](handleEntityNotFound(_0x1fc68b,null))[_0x437e('0x24')](respondWithResult(_0x1fc68b,null))[_0x437e('0x46')](handleError(_0x1fc68b,null));};exports[_0x437e('0x49')]=function(_0x5b4811,_0x2cfd96){return db['Campaign'][_0x437e('0x49')](_0x5b4811[_0x437e('0x4a')],{})['then'](function(_0x49a9cf){var _0x1cf57b=_0x5b4811[_0x437e('0x4b')][_0x437e('0x4c')]({'plain':!![]});if(!_0x1cf57b)throw new Error(_0x437e('0x4d'));if(_0x1cf57b[_0x437e('0x4e')]===_0x437e('0x4b')){var _0x396ec0=_0x49a9cf[_0x437e('0x4c')]({'plain':!![]});var _0xa243ae=_0x437e('0x4f');return db[_0x437e('0x50')][_0x437e('0x51')]({'where':{'name':_0xa243ae,'userProfileId':_0x1cf57b[_0x437e('0x52')]},'raw':!![]})['then'](function(_0x668d88){if(_0x668d88&&_0x668d88[_0x437e('0x53')]===0x0){return db[_0x437e('0x26')][_0x437e('0x49')]({'name':_0x396ec0[_0x437e('0x29')],'resourceId':_0x396ec0['id'],'type':_0x668d88['name'],'sectionId':_0x668d88['id']},{})[_0x437e('0x24')](function(){return _0x49a9cf;});}else{return _0x49a9cf;}})[_0x437e('0x46')](function(_0x2bdd62){logger[_0x437e('0x27')](_0x437e('0x54'),_0x2bdd62);throw _0x2bdd62;});}return _0x49a9cf;})[_0x437e('0x24')](respondWithResult(_0x2cfd96,0xc9))[_0x437e('0x46')](handleError(_0x2cfd96,null));};exports[_0x437e('0x55')]=function(_0x6f0527,_0x537f76){var _0xf9fa04={'where':{'id':_0x6f0527[_0x437e('0x48')]['id']}},_0x31c0b5={};_0x31c0b5[_0x437e('0x31')]=_[_0x437e('0x34')](db['Campaign']['rawAttributes']);_0xf9fa04[_0x437e('0x38')]=_[_0x437e('0x36')](_0x31c0b5[_0x437e('0x31')],qs[_0x437e('0x37')](_0x6f0527[_0x437e('0x33')][_0x437e('0x37')]));_0xf9fa04[_0x437e('0x38')]=_0xf9fa04[_0x437e('0x38')][_0x437e('0x39')]?_0xf9fa04[_0x437e('0x38')]:_0x31c0b5[_0x437e('0x31')];if(_0x6f0527[_0x437e('0x33')][_0x437e('0x42')]){_0xf9fa04[_0x437e('0x43')]=[{'all':!![]}];}_0xf9fa04=_[_0x437e('0x40')]({},_0xf9fa04,_0x6f0527['options']);return db['Campaign'][_0x437e('0x51')](_0xf9fa04)['then'](handleEntityNotFound(_0x537f76,null))['then'](function(_0x473c0b){if(_0x473c0b){var _0x2c493e=_0x473c0b[_0x437e('0x4c')]({'plain':!![]});_0x2c493e=qs[_0x437e('0x56')](_0x2c493e,['id',_0x437e('0x57'),_0x437e('0x58')]);_0x6f0527['body']=_['omit'](_0x6f0527[_0x437e('0x4a')],['id',_0x437e('0x57'),_0x437e('0x58')]);return db[_0x437e('0x2c')][_0x437e('0x49')](_[_0x437e('0x40')](_0x2c493e,_0x6f0527[_0x437e('0x4a')]),{'include':_0x6f0527[_0x437e('0x33')][_0x437e('0x42')]?[{'all':!![]}]:undefined})[_0x437e('0x24')](function(_0x3817f8){var _0x21f8c1=_0x6f0527[_0x437e('0x4b')][_0x437e('0x4c')]({'plain':!![]});if(!_0x21f8c1)throw new Error(_0x437e('0x4d'));if(_0x21f8c1['role']===_0x437e('0x4b')){var _0x50c527=_0x3817f8[_0x437e('0x4c')]({'plain':!![]});var _0x41162b=_0x437e('0x4f');return db['UserProfileSection'][_0x437e('0x51')]({'where':{'name':_0x41162b,'userProfileId':_0x21f8c1[_0x437e('0x52')]},'raw':!![]})[_0x437e('0x24')](function(_0x4e8f2f){if(_0x4e8f2f&&_0x4e8f2f['autoAssociation']===0x0){return db['UserProfileResource'][_0x437e('0x49')]({'name':_0x50c527['name'],'resourceId':_0x50c527['id'],'type':_0x4e8f2f[_0x437e('0x29')],'sectionId':_0x4e8f2f['id']},{})[_0x437e('0x24')](function(){return _0x3817f8;});}else{return _0x3817f8;}})[_0x437e('0x46')](function(_0x1570aa){logger[_0x437e('0x27')](_0x437e('0x54'),_0x1570aa);throw _0x1570aa;});}return _0x3817f8;});}})['then'](respondWithResult(_0x537f76,0xc9))[_0x437e('0x46')](handleError(_0x537f76,null));};exports[_0x437e('0x23')]=function(_0x3a3d17,_0x38513f){if(_0x3a3d17[_0x437e('0x4a')]['id']){delete _0x3a3d17[_0x437e('0x4a')]['id'];}return db[_0x437e('0x2c')][_0x437e('0x51')]({'where':{'id':_0x3a3d17[_0x437e('0x48')]['id']}})[_0x437e('0x24')](handleEntityNotFound(_0x38513f,null))[_0x437e('0x24')](saveUpdates(_0x3a3d17[_0x437e('0x4a')],null))['then'](respondWithResult(_0x38513f,null))[_0x437e('0x46')](handleError(_0x38513f,null));};exports[_0x437e('0x25')]=function(_0x1a3451,_0x205983){return db[_0x437e('0x2c')][_0x437e('0x51')]({'where':{'id':_0x1a3451[_0x437e('0x48')]['id']}})[_0x437e('0x24')](handleEntityNotFound(_0x205983,null))[_0x437e('0x24')](removeEntity(_0x205983,null))[_0x437e('0x46')](handleError(_0x205983,null));};exports[_0x437e('0x59')]=function(_0x54791d,_0x25520c,_0x4608ad){var _0x1d3f9b={'raw':!![],'where':{}};var _0x4136ac={};var _0x412add={'count':0x0,'rows':[]};return db[_0x437e('0x2c')][_0x437e('0x5a')]({'where':{'id':_0x54791d[_0x437e('0x48')]['id']}})['then'](handleEntityNotFound(_0x25520c,null))['then'](function(_0x17ad69){if(_0x17ad69){_0x4136ac[_0x437e('0x31')]=_[_0x437e('0x34')](db[_0x437e('0x5b')][_0x437e('0x2d')]);_0x4136ac[_0x437e('0x33')]=_[_0x437e('0x34')](_0x54791d[_0x437e('0x33')]);_0x4136ac[_0x437e('0x35')]=_['intersection'](_0x4136ac['model'],_0x4136ac[_0x437e('0x33')]);_0x1d3f9b[_0x437e('0x38')]=_[_0x437e('0x36')](_0x4136ac[_0x437e('0x31')],qs[_0x437e('0x37')](_0x54791d['query'][_0x437e('0x37')]));_0x1d3f9b[_0x437e('0x38')]=_0x1d3f9b[_0x437e('0x38')][_0x437e('0x39')]?_0x1d3f9b['attributes']:_0x4136ac[_0x437e('0x31')];if(!_0x54791d[_0x437e('0x33')]['hasOwnProperty']('nolimit')){_0x1d3f9b['limit']=qs[_0x437e('0x1f')](_0x54791d[_0x437e('0x33')][_0x437e('0x1f')]);_0x1d3f9b[_0x437e('0x1d')]=qs[_0x437e('0x1d')](_0x54791d[_0x437e('0x33')][_0x437e('0x1d')]);}_0x1d3f9b[_0x437e('0x3b')]=qs[_0x437e('0x3c')](_0x54791d[_0x437e('0x33')][_0x437e('0x3c')]);_0x1d3f9b[_0x437e('0x3d')]=qs[_0x437e('0x35')](_[_0x437e('0x3e')](_0x54791d[_0x437e('0x33')],_0x4136ac['filters']));_0x1d3f9b[_0x437e('0x3d')][_0x437e('0x5c')]=_0x17ad69['id'];if(_0x54791d[_0x437e('0x33')]['filter']){_0x1d3f9b[_0x437e('0x3d')]=_['merge'](_0x1d3f9b[_0x437e('0x3d')],{'$or':_[_0x437e('0x32')](_0x1d3f9b[_0x437e('0x38')],function(_0x5d1f14){var _0x208684={};_0x208684[_0x5d1f14]={'$like':'%'+_0x54791d['query']['filter']+'%'};return _0x208684;})});}_0x1d3f9b=_[_0x437e('0x40')]({},_0x1d3f9b,_0x54791d[_0x437e('0x5d')]);return db[_0x437e('0x5b')][_0x437e('0x41')]({'where':_0x1d3f9b[_0x437e('0x3d')]})[_0x437e('0x24')](function(_0x51adea){_0x412add[_0x437e('0x41')]=_0x51adea;if(_0x54791d[_0x437e('0x33')][_0x437e('0x42')]){_0x1d3f9b[_0x437e('0x43')]=[{'all':!![]}];}return db['CmHopper']['findAll'](_0x1d3f9b);})[_0x437e('0x24')](function(_0x3ef5a4){_0x412add[_0x437e('0x45')]=_0x3ef5a4;return _0x412add;});}})[_0x437e('0x24')](respondWithFilteredResult(_0x25520c,_0x1d3f9b))[_0x437e('0x46')](handleError(_0x25520c,null));};exports[_0x437e('0x5e')]=function(_0x1afe8a,_0x45b950,_0x390143){var _0x2e6c8a={'raw':!![],'where':{}};var _0xd3b8b6={};var _0x170ac8={'count':0x0,'rows':[]};return db[_0x437e('0x2c')][_0x437e('0x5a')]({'where':{'id':_0x1afe8a[_0x437e('0x48')]['id']}})['then'](handleEntityNotFound(_0x45b950,null))[_0x437e('0x24')](function(_0x1416b9){if(_0x1416b9){_0xd3b8b6[_0x437e('0x31')]=_[_0x437e('0x34')](db[_0x437e('0x5f')][_0x437e('0x2d')]);_0xd3b8b6[_0x437e('0x33')]=_[_0x437e('0x34')](_0x1afe8a[_0x437e('0x33')]);_0xd3b8b6[_0x437e('0x35')]=_['intersection'](_0xd3b8b6[_0x437e('0x31')],_0xd3b8b6[_0x437e('0x33')]);_0x2e6c8a['attributes']=_[_0x437e('0x36')](_0xd3b8b6['model'],qs[_0x437e('0x37')](_0x1afe8a[_0x437e('0x33')]['fields']));_0x2e6c8a[_0x437e('0x38')]=_0x2e6c8a['attributes'][_0x437e('0x39')]?_0x2e6c8a[_0x437e('0x38')]:_0xd3b8b6[_0x437e('0x31')];if(!_0x1afe8a['query'][_0x437e('0x60')](_0x437e('0x3a'))){_0x2e6c8a[_0x437e('0x1f')]=qs[_0x437e('0x1f')](_0x1afe8a[_0x437e('0x33')]['limit']);_0x2e6c8a[_0x437e('0x1d')]=qs[_0x437e('0x1d')](_0x1afe8a['query']['offset']);}_0x2e6c8a[_0x437e('0x3b')]=qs[_0x437e('0x3c')](_0x1afe8a[_0x437e('0x33')][_0x437e('0x3c')]);_0x2e6c8a[_0x437e('0x3d')]=qs['filters'](_[_0x437e('0x3e')](_0x1afe8a['query'],_0xd3b8b6[_0x437e('0x35')]));_0x2e6c8a[_0x437e('0x3d')]['CampaignId']=_0x1416b9['id'];if(_0x1afe8a[_0x437e('0x33')][_0x437e('0x61')]){_0x2e6c8a['where']=_[_0x437e('0x40')](_0x2e6c8a[_0x437e('0x3d')],{'$or':_['map'](_0x2e6c8a['attributes'],function(_0x44f1b7){var _0x1052d0={};_0x1052d0[_0x44f1b7]={'$like':'%'+_0x1afe8a['query'][_0x437e('0x61')]+'%'};return _0x1052d0;})});}_0x2e6c8a=_['merge']({},_0x2e6c8a,_0x1afe8a[_0x437e('0x5d')]);return db['CmHopperHistory'][_0x437e('0x41')]({'where':_0x2e6c8a[_0x437e('0x3d')]})['then'](function(_0xa94f57){_0x170ac8[_0x437e('0x41')]=_0xa94f57;if(_0x1afe8a['query'][_0x437e('0x42')]){_0x2e6c8a[_0x437e('0x43')]=[{'all':!![]}];}return db['CmHopperHistory'][_0x437e('0x44')](_0x2e6c8a);})[_0x437e('0x24')](function(_0x96654){_0x170ac8[_0x437e('0x45')]=_0x96654;return _0x170ac8;});}})[_0x437e('0x24')](respondWithFilteredResult(_0x45b950,_0x2e6c8a))[_0x437e('0x46')](handleError(_0x45b950,null));};exports[_0x437e('0x62')]=function(_0x18c8c1,_0x112597,_0x5f06ab){var _0x1f3495={'raw':!![],'where':{}};var _0x56f902={};var _0x5e36a5={'count':0x0,'rows':[]};return db[_0x437e('0x2c')][_0x437e('0x5a')]({'where':{'id':_0x18c8c1[_0x437e('0x48')]['id']}})['then'](handleEntityNotFound(_0x112597,null))[_0x437e('0x24')](function(_0x121cb1){if(_0x121cb1){_0x56f902['model']=_['keys'](db[_0x437e('0x63')][_0x437e('0x2d')]);_0x56f902['query']=_[_0x437e('0x34')](_0x18c8c1['query']);_0x56f902[_0x437e('0x35')]=_['intersection'](_0x56f902[_0x437e('0x31')],_0x56f902['query']);_0x1f3495[_0x437e('0x38')]=_[_0x437e('0x36')](_0x56f902[_0x437e('0x31')],qs[_0x437e('0x37')](_0x18c8c1[_0x437e('0x33')]['fields']));_0x1f3495[_0x437e('0x38')]=_0x1f3495[_0x437e('0x38')][_0x437e('0x39')]?_0x1f3495[_0x437e('0x38')]:_0x56f902[_0x437e('0x31')];if(!_0x18c8c1['query'][_0x437e('0x60')](_0x437e('0x3a'))){_0x1f3495['limit']=qs[_0x437e('0x1f')](_0x18c8c1[_0x437e('0x33')][_0x437e('0x1f')]);_0x1f3495[_0x437e('0x1d')]=qs[_0x437e('0x1d')](_0x18c8c1['query'][_0x437e('0x1d')]);}_0x1f3495[_0x437e('0x3b')]=qs[_0x437e('0x3c')](_0x18c8c1['query']['sort']);_0x1f3495['where']=qs['filters'](_[_0x437e('0x3e')](_0x18c8c1[_0x437e('0x33')],_0x56f902[_0x437e('0x35')]));_0x1f3495['where'][_0x437e('0x5c')]=_0x121cb1['id'];if(_0x18c8c1['query'][_0x437e('0x61')]){_0x1f3495[_0x437e('0x3d')]=_[_0x437e('0x40')](_0x1f3495[_0x437e('0x3d')],{'$or':_[_0x437e('0x32')](_0x1f3495[_0x437e('0x38')],function(_0x19f27c){var _0x1bbdf6={};_0x1bbdf6[_0x19f27c]={'$like':'%'+_0x18c8c1['query']['filter']+'%'};return _0x1bbdf6;})});}_0x1f3495=_[_0x437e('0x40')]({},_0x1f3495,_0x18c8c1[_0x437e('0x5d')]);return db[_0x437e('0x63')]['count']({'where':_0x1f3495[_0x437e('0x3d')]})['then'](function(_0xfabd0f){_0x5e36a5['count']=_0xfabd0f;if(_0x18c8c1[_0x437e('0x33')]['includeAll']){_0x1f3495[_0x437e('0x43')]=[{'all':!![]}];}return db[_0x437e('0x63')][_0x437e('0x44')](_0x1f3495);})[_0x437e('0x24')](function(_0x4610f6){_0x5e36a5['rows']=_0x4610f6;return _0x5e36a5;});}})['then'](respondWithFilteredResult(_0x112597,_0x1f3495))['catch'](handleError(_0x112597,null));};exports['getHopperBlacks']=function(_0x28d855,_0x3f77a9,_0x266d73){var _0xc8868e={'raw':!![],'where':{}};var _0x39b82a={};var _0x24d99e={'count':0x0,'rows':[]};return db[_0x437e('0x2c')][_0x437e('0x5a')]({'where':{'id':_0x28d855[_0x437e('0x48')]['id']}})[_0x437e('0x24')](handleEntityNotFound(_0x3f77a9,null))[_0x437e('0x24')](function(_0x5ef610){if(_0x5ef610){_0x39b82a[_0x437e('0x31')]=_[_0x437e('0x34')](db[_0x437e('0x64')][_0x437e('0x2d')]);_0x39b82a['query']=_[_0x437e('0x34')](_0x28d855[_0x437e('0x33')]);_0x39b82a[_0x437e('0x35')]=_[_0x437e('0x36')](_0x39b82a[_0x437e('0x31')],_0x39b82a[_0x437e('0x33')]);_0xc8868e[_0x437e('0x38')]=_[_0x437e('0x36')](_0x39b82a[_0x437e('0x31')],qs[_0x437e('0x37')](_0x28d855[_0x437e('0x33')][_0x437e('0x37')]));_0xc8868e[_0x437e('0x38')]=_0xc8868e[_0x437e('0x38')][_0x437e('0x39')]?_0xc8868e[_0x437e('0x38')]:_0x39b82a[_0x437e('0x31')];if(!_0x28d855[_0x437e('0x33')][_0x437e('0x60')]('nolimit')){_0xc8868e[_0x437e('0x1f')]=qs[_0x437e('0x1f')](_0x28d855['query']['limit']);_0xc8868e['offset']=qs['offset'](_0x28d855[_0x437e('0x33')][_0x437e('0x1d')]);}_0xc8868e['order']=qs[_0x437e('0x3c')](_0x28d855[_0x437e('0x33')][_0x437e('0x3c')]);_0xc8868e[_0x437e('0x3d')]=qs[_0x437e('0x35')](_[_0x437e('0x3e')](_0x28d855[_0x437e('0x33')],_0x39b82a[_0x437e('0x35')]));_0xc8868e[_0x437e('0x3d')][_0x437e('0x5c')]=_0x5ef610['id'];if(_0x28d855[_0x437e('0x33')][_0x437e('0x61')]){_0xc8868e['where']=_[_0x437e('0x40')](_0xc8868e['where'],{'$or':_[_0x437e('0x32')](_0xc8868e['attributes'],function(_0x246fce){var _0x5b3ed2={};_0x5b3ed2[_0x246fce]={'$like':'%'+_0x28d855[_0x437e('0x33')][_0x437e('0x61')]+'%'};return _0x5b3ed2;})});}_0xc8868e=_['merge']({},_0xc8868e,_0x28d855[_0x437e('0x5d')]);return db[_0x437e('0x64')][_0x437e('0x41')]({'where':_0xc8868e[_0x437e('0x3d')]})['then'](function(_0x380784){_0x24d99e[_0x437e('0x41')]=_0x380784;if(_0x28d855[_0x437e('0x33')][_0x437e('0x42')]){_0xc8868e[_0x437e('0x43')]=[{'all':!![]}];}return db[_0x437e('0x64')][_0x437e('0x44')](_0xc8868e);})['then'](function(_0xf0a431){_0x24d99e[_0x437e('0x45')]=_0xf0a431;return _0x24d99e;});}})[_0x437e('0x24')](respondWithFilteredResult(_0x3f77a9,_0xc8868e))[_0x437e('0x46')](handleError(_0x3f77a9,null));};exports[_0x437e('0x65')]=function(_0x14321c,_0x52baa4,_0x1ef36f){var _0xff3ffe={};var _0x1dec80={};var _0x2a3cbb;var _0xe98324;return db[_0x437e('0x2c')][_0x437e('0x5a')]({'where':{'id':_0x14321c[_0x437e('0x48')]['id']}})[_0x437e('0x24')](handleEntityNotFound(_0x52baa4,null))[_0x437e('0x24')](function(_0x5bc103){if(_0x5bc103){_0x2a3cbb=_0x5bc103;_0x1dec80[_0x437e('0x31')]=_[_0x437e('0x34')](db[_0x437e('0x66')]['rawAttributes']);_0x1dec80[_0x437e('0x33')]=_[_0x437e('0x34')](_0x14321c[_0x437e('0x33')]);_0x1dec80[_0x437e('0x35')]=_['intersection'](_0x1dec80['model'],_0x1dec80['query']);_0xff3ffe[_0x437e('0x38')]=_[_0x437e('0x36')](_0x1dec80[_0x437e('0x31')],qs[_0x437e('0x37')](_0x14321c['query']['fields']));_0xff3ffe[_0x437e('0x38')]=_0xff3ffe[_0x437e('0x38')]['length']?_0xff3ffe[_0x437e('0x38')]:_0x1dec80['model'];_0xff3ffe['order']=qs[_0x437e('0x3c')](_0x14321c[_0x437e('0x33')][_0x437e('0x3c')]);_0xff3ffe['where']=qs['filters'](_[_0x437e('0x3e')](_0x14321c[_0x437e('0x33')],_0x1dec80[_0x437e('0x35')]));if(_0x14321c[_0x437e('0x33')][_0x437e('0x61')]){_0xff3ffe[_0x437e('0x3d')]=_[_0x437e('0x40')](_0xff3ffe['where'],{'$or':_[_0x437e('0x32')](_0xff3ffe[_0x437e('0x38')],function(_0x2e7537){var _0x9c8f9e={};_0x9c8f9e[_0x2e7537]={'$like':'%'+_0x14321c[_0x437e('0x33')][_0x437e('0x61')]+'%'};return _0x9c8f9e;})});}_0xff3ffe=_['merge']({},_0xff3ffe,_0x14321c[_0x437e('0x5d')]);return _0x2a3cbb[_0x437e('0x65')](_0xff3ffe);}})[_0x437e('0x24')](function(_0x5ed77a){if(_0x5ed77a){_0xe98324=_0x5ed77a['length'];if(!_0x14321c[_0x437e('0x33')][_0x437e('0x60')]('nolimit')){_0xff3ffe[_0x437e('0x1f')]=qs[_0x437e('0x1f')](_0x14321c['query'][_0x437e('0x1f')]);_0xff3ffe[_0x437e('0x1d')]=qs[_0x437e('0x1d')](_0x14321c[_0x437e('0x33')]['offset']);}return _0x2a3cbb[_0x437e('0x65')](_0xff3ffe);}})[_0x437e('0x24')](function(_0x1ec924){if(_0x1ec924){return _0x1ec924?{'count':_0xe98324,'rows':_0x1ec924}:null;}})['then'](respondWithResult(_0x52baa4,null))[_0x437e('0x46')](handleError(_0x52baa4,null));};exports[_0x437e('0x67')]=function(_0x302320,_0x55a77f,_0x3a50e3){var _0x5be8f0,_0x5e1040;var _0x35313b=[];var _0x3d43ef=moment()[_0x437e('0x68')]('YYYY-MM-DD\x20HH:mm:ss');return db[_0x437e('0x2c')][_0x437e('0x51')]({'where':{'id':_0x302320[_0x437e('0x48')]['id']}})[_0x437e('0x24')](handleEntityNotFound(_0x55a77f,null))[_0x437e('0x24')](function(_0x2b9b0b){if(_0x2b9b0b){_0x5e1040=_0x2b9b0b;return _0x2b9b0b[_0x437e('0x67')](_0x302320[_0x437e('0x4a')]['ids'],_[_0x437e('0x56')](_0x302320[_0x437e('0x4a')],['ids','id'])||{});}return null;})[_0x437e('0x69')](function(_0x4d5d88){var _0x4a3e7a;var _0x579059;_0x5be8f0=_0x4d5d88||[];var _0x2a589d=[];if(_0x4d5d88){for(var _0x11a928=0x0;_0x11a928<_0x4d5d88[_0x437e('0x39')];_0x11a928+=0x1){var _0x239e33=_0x4d5d88[_0x11a928][_0x437e('0x4c')]({'plain':!![]});_0x5e1040[_0x437e('0x6a')]=_0x302320[_0x437e('0x4a')][_0x437e('0x6a')]?_0x302320['body'][_0x437e('0x6a')]:_0x5e1040[_0x437e('0x6a')];switch(_0x5e1040[_0x437e('0x6a')]){case _0x437e('0x6b'):_0x4a3e7a=squel[_0x437e('0x6c')]()[_0x437e('0x6d')](_0x437e('0x6e'))[_0x437e('0x6f')]([_0x437e('0x70'),_0x437e('0x71'),_0x437e('0x72'),_0x437e('0x73'),_0x437e('0x5c'),_0x437e('0x57'),_0x437e('0x58')],squel[_0x437e('0x74')]()[_0x437e('0x75')]('phone',_0x437e('0x70'))[_0x437e('0x75')](_0x437e('0x76'),'scheduledAt')[_0x437e('0x75')]('id',_0x437e('0x72'))[_0x437e('0x75')](_0x239e33['CmListId'][_0x437e('0x77')](),'ListId')[_0x437e('0x75')](_0x302320[_0x437e('0x48')]['id']['toString'](),'CampaignId')[_0x437e('0x75')]('\x27'+_0x3d43ef+'\x27',_0x437e('0x57'))['field']('\x27'+_0x3d43ef+'\x27',_0x437e('0x58'))[_0x437e('0x78')]('cm_contacts')[_0x437e('0x3d')]('deletedAt\x20IS\x20NULL')[_0x437e('0x3d')](_0x437e('0x79'),_0x239e33['CmListId'][_0x437e('0x77')]())['where']('phone\x20IS\x20NOT\x20NULL')[_0x437e('0x3d')]('phone\x20NOT\x20IN\x20(?)',squel['select']()[_0x437e('0x75')](_0x437e('0x7a'))[_0x437e('0x78')]('cm_hopper_final')['where'](_0x437e('0x7b'),_0x302320[_0x437e('0x48')]['id']['toString']()))[_0x437e('0x3d')]('phone\x20NOT\x20IN\x20(?)',squel[_0x437e('0x74')]()[_0x437e('0x75')](_0x437e('0x7c'))[_0x437e('0x78')](_0x437e('0x6e'))[_0x437e('0x3d')](_0x437e('0x7b'),_0x302320[_0x437e('0x48')]['id'][_0x437e('0x77')]())))[_0x437e('0x77')]();break;case _0x437e('0x7d'):_0x4a3e7a=squel[_0x437e('0x6c')]()['into'](_0x437e('0x6e'))[_0x437e('0x6f')](['phone',_0x437e('0x71'),_0x437e('0x72'),'ListId',_0x437e('0x5c'),_0x437e('0x57'),_0x437e('0x58')],squel['select']()[_0x437e('0x75')]('phone',_0x437e('0x70'))[_0x437e('0x75')](_0x437e('0x76'),_0x437e('0x71'))[_0x437e('0x75')]('id',_0x437e('0x72'))[_0x437e('0x75')](_0x239e33['CmListId']['toString'](),_0x437e('0x73'))[_0x437e('0x75')](_0x302320['params']['id']['toString'](),_0x437e('0x5c'))[_0x437e('0x75')]('\x27'+_0x3d43ef+'\x27',_0x437e('0x57'))[_0x437e('0x75')]('\x27'+_0x3d43ef+'\x27','updatedAt')[_0x437e('0x78')]('cm_contacts')['where']('deletedAt\x20IS\x20NULL')[_0x437e('0x3d')](_0x437e('0x79'),_0x239e33['CmListId'][_0x437e('0x77')]())[_0x437e('0x3d')]('phone\x20IS\x20NOT\x20NULL')[_0x437e('0x3d')](_0x437e('0x7e'),squel[_0x437e('0x74')]()['field'](_0x437e('0x7c'))[_0x437e('0x78')](_0x437e('0x6e'))['where']('CampaignId\x20=\x20?',_0x302320[_0x437e('0x48')]['id'][_0x437e('0x77')]())))['toString']();break;default:_0x4a3e7a=squel[_0x437e('0x6c')]()[_0x437e('0x6d')]('cm_hopper')[_0x437e('0x6f')](['phone',_0x437e('0x71'),'ContactId','ListId','CampaignId',_0x437e('0x57'),_0x437e('0x58')],squel[_0x437e('0x74')]()[_0x437e('0x75')](_0x437e('0x70'),_0x437e('0x70'))['field'](_0x437e('0x76'),_0x437e('0x71'))[_0x437e('0x75')]('id',_0x437e('0x72'))[_0x437e('0x75')](_0x239e33[_0x437e('0x7f')][_0x437e('0x77')](),_0x437e('0x73'))['field'](_0x302320[_0x437e('0x48')]['id']['toString'](),_0x437e('0x5c'))[_0x437e('0x75')]('\x27'+_0x3d43ef+'\x27',_0x437e('0x57'))[_0x437e('0x75')]('\x27'+_0x3d43ef+'\x27',_0x437e('0x58'))[_0x437e('0x78')](_0x437e('0x80'))['where'](_0x437e('0x81'))[_0x437e('0x3d')]('ListId\x20=\x20?',_0x239e33['CmListId']['toString']())[_0x437e('0x3d')](_0x437e('0x82')))[_0x437e('0x77')]();}_0x579059=squel[_0x437e('0x6c')]()['into'](_0x437e('0x83'))[_0x437e('0x6f')](['cmHopperId',_0x437e('0x71'),_0x437e('0x70'),_0x437e('0x84'),_0x437e('0x57'),_0x437e('0x58')],squel[_0x437e('0x74')]()[_0x437e('0x75')](_0x437e('0x85'),'id')['field'](_0x437e('0x76'),_0x437e('0x71'))[_0x437e('0x75')](_0x437e('0x86'),'phone')[_0x437e('0x75')]('ci.OrderBY',_0x437e('0x84'))[_0x437e('0x75')]('\x27'+_0x3d43ef+'\x27',_0x437e('0x57'))[_0x437e('0x75')]('\x27'+_0x3d43ef+'\x27','updatedAt')[_0x437e('0x78')]('cm_contact_has_items','ci')['join'](_0x437e('0x6e'),'h',_0x437e('0x87'))['where']('h.ListId\x20=\x20?',_0x239e33['CmListId'][_0x437e('0x77')]())[_0x437e('0x3d')](_0x437e('0x88'),_0x302320[_0x437e('0x48')]['id']['toString']())['where']('h.createdAt\x20=\x20?',_0x3d43ef))[_0x437e('0x77')]();_0x2a589d[_0x437e('0x89')](db[_0x437e('0x8a')][_0x437e('0x33')](_0x4a3e7a));_0x35313b['push'](db[_0x437e('0x8a')][_0x437e('0x33')](_0x579059));}return BPromise[_0x437e('0x8b')](_0x2a589d);}})['then'](function(){return BPromise['all'](_0x35313b);})[_0x437e('0x24')](function(){return _0x5be8f0;})[_0x437e('0x24')](respondWithResult(_0x55a77f,null))[_0x437e('0x46')](handleError(_0x55a77f,null));};exports['removeLists']=function(_0xfc097e,_0x587480,_0x41fb63){return db[_0x437e('0x2c')][_0x437e('0x51')]({'where':{'id':_0xfc097e[_0x437e('0x48')]['id']}})['then'](handleEntityNotFound(_0x587480,null))[_0x437e('0x24')](function(_0x34f2b8){if(_0x34f2b8){return _0x34f2b8['removeLists'](_0xfc097e[_0x437e('0x33')][_0x437e('0x8c')]);}})[_0x437e('0x24')](function(_0x4be9cc){if(_0x4be9cc){return db[_0x437e('0x5b')][_0x437e('0x25')]({'where':{'ListId':_0xfc097e[_0x437e('0x33')][_0x437e('0x8c')],'CampaignId':_0xfc097e[_0x437e('0x48')]['id']}})['then'](function(){return _0x4be9cc;});}})[_0x437e('0x24')](respondWithStatusCode(_0x587480,null))['catch'](handleError(_0x587480,null));};exports[_0x437e('0x8d')]=function(_0x2c814c,_0x461bbb,_0x59fce4){var _0x4cb323={};var _0x175b27={};var _0x49f282;var _0x5015d3;return db[_0x437e('0x2c')]['findOne']({'where':{'id':_0x2c814c[_0x437e('0x48')]['id']}})[_0x437e('0x24')](handleEntityNotFound(_0x461bbb,null))['then'](function(_0x2a379f){if(_0x2a379f){_0x49f282=_0x2a379f;_0x175b27[_0x437e('0x31')]=_['keys'](db[_0x437e('0x66')][_0x437e('0x2d')]);_0x175b27['query']=_[_0x437e('0x34')](_0x2c814c[_0x437e('0x33')]);_0x175b27['filters']=_[_0x437e('0x36')](_0x175b27[_0x437e('0x31')],_0x175b27[_0x437e('0x33')]);_0x4cb323[_0x437e('0x38')]=_[_0x437e('0x36')](_0x175b27[_0x437e('0x31')],qs[_0x437e('0x37')](_0x2c814c[_0x437e('0x33')][_0x437e('0x37')]));_0x4cb323[_0x437e('0x38')]=_0x4cb323[_0x437e('0x38')]['length']?_0x4cb323[_0x437e('0x38')]:_0x175b27[_0x437e('0x31')];_0x4cb323[_0x437e('0x3b')]=qs[_0x437e('0x3c')](_0x2c814c['query'][_0x437e('0x3c')]);_0x4cb323[_0x437e('0x3d')]=qs[_0x437e('0x35')](_[_0x437e('0x3e')](_0x2c814c[_0x437e('0x33')],_0x175b27['filters']));if(_0x2c814c[_0x437e('0x33')][_0x437e('0x61')]){_0x4cb323['where']=_[_0x437e('0x40')](_0x4cb323['where'],{'$or':_[_0x437e('0x32')](_0x4cb323[_0x437e('0x38')],function(_0x4a86ae){var _0x2cce41={};_0x2cce41[_0x4a86ae]={'$like':'%'+_0x2c814c[_0x437e('0x33')][_0x437e('0x61')]+'%'};return _0x2cce41;})});}_0x4cb323=_[_0x437e('0x40')]({},_0x4cb323,_0x2c814c['options']);return _0x49f282['getBlackLists'](_0x4cb323);}})[_0x437e('0x24')](function(_0x19eca9){if(_0x19eca9){_0x5015d3=_0x19eca9[_0x437e('0x39')];if(!_0x2c814c[_0x437e('0x33')]['hasOwnProperty'](_0x437e('0x3a'))){_0x4cb323[_0x437e('0x1f')]=qs['limit'](_0x2c814c[_0x437e('0x33')]['limit']);_0x4cb323[_0x437e('0x1d')]=qs['offset'](_0x2c814c[_0x437e('0x33')][_0x437e('0x1d')]);}return _0x49f282[_0x437e('0x8d')](_0x4cb323);}})[_0x437e('0x24')](function(_0x4f654d){if(_0x4f654d){return _0x4f654d?{'count':_0x5015d3,'rows':_0x4f654d}:null;}})[_0x437e('0x24')](respondWithResult(_0x461bbb,null))[_0x437e('0x46')](handleError(_0x461bbb,null));};exports[_0x437e('0x8e')]=function(_0x28ea99,_0x14c742,_0x53c3a6){var _0x27238e,_0x2ceb42;var _0x4516e5=[];var _0xc8860d=moment()[_0x437e('0x68')](_0x437e('0x8f'));return db['Campaign'][_0x437e('0x51')]({'where':{'id':_0x28ea99[_0x437e('0x48')]['id']}})[_0x437e('0x24')](handleEntityNotFound(_0x14c742,null))['then'](function(_0xd80e9a){if(_0xd80e9a){_0x2ceb42=_0xd80e9a;return _0xd80e9a[_0x437e('0x8e')](_0x28ea99[_0x437e('0x4a')][_0x437e('0x8c')],_['omit'](_0x28ea99[_0x437e('0x4a')],[_0x437e('0x8c'),'id'])||{});}return null;})['spread'](function(_0x32797b){var _0x107276;var _0x375584;_0x27238e=_0x32797b||[];var _0x33a2a2=[];if(_0x32797b){for(var _0x7ff9c3=0x0;_0x7ff9c3<_0x32797b[_0x437e('0x39')];_0x7ff9c3+=0x1){var _0x2ea60f=_0x32797b[_0x7ff9c3]['get']({'plain':!![]});_0x107276=squel[_0x437e('0x6c')]()[_0x437e('0x6d')](_0x437e('0x90'))['fromQuery']([_0x437e('0x70'),_0x437e('0x72'),'ListId',_0x437e('0x5c'),_0x437e('0x57'),_0x437e('0x58')],squel[_0x437e('0x74')]()['field'](_0x437e('0x70'),_0x437e('0x70'))[_0x437e('0x75')]('id','ContactId')[_0x437e('0x75')](_0x2ea60f['CmListId'][_0x437e('0x77')](),_0x437e('0x73'))[_0x437e('0x75')](_0x28ea99[_0x437e('0x48')]['id'][_0x437e('0x77')](),_0x437e('0x5c'))['field']('NOW()',_0x437e('0x57'))['field'](_0x437e('0x76'),_0x437e('0x58'))[_0x437e('0x78')](_0x437e('0x80'))[_0x437e('0x3d')]('deletedAt\x20IS\x20NULL')[_0x437e('0x3d')]('ListId\x20=\x20?',_0x2ea60f[_0x437e('0x7f')][_0x437e('0x77')]())['where'](_0x437e('0x82')))[_0x437e('0x77')]();_0x33a2a2[_0x437e('0x89')](db['sequelize']['query'](_0x107276));}return BPromise[_0x437e('0x8b')](_0x33a2a2);}})[_0x437e('0x24')](function(){return _0x27238e;})[_0x437e('0x24')](respondWithResult(_0x14c742,null))[_0x437e('0x46')](handleError(_0x14c742,null));};exports[_0x437e('0x91')]=function(_0x19a8e9,_0xf88a01,_0x568c2f){return db['Campaign'][_0x437e('0x51')]({'where':{'id':_0x19a8e9[_0x437e('0x48')]['id']}})[_0x437e('0x24')](handleEntityNotFound(_0xf88a01,null))[_0x437e('0x24')](function(_0x84e65c){if(_0x84e65c){return _0x84e65c[_0x437e('0x91')](_0x19a8e9[_0x437e('0x33')][_0x437e('0x8c')]);}})[_0x437e('0x24')](function(_0x273f59){if(_0x273f59){return db['CmHopperBlack']['destroy']({'where':{'ListId':_0x19a8e9[_0x437e('0x33')][_0x437e('0x8c')],'CampaignId':_0x19a8e9[_0x437e('0x48')]['id']}})[_0x437e('0x24')](function(){return _0x273f59;});}})['then'](respondWithStatusCode(_0xf88a01,null))[_0x437e('0x46')](handleError(_0xf88a01,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff