// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x0e69=['sox','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','papaparse','ioredis','../../components/parsers/advancedSearch','../../config/logger','../../config/utils','../../config/environment','sendStatus','status','json','count','offset','limit','apply','reject','update','then','destroy','get','IvrCampaigns','UserProfileResource','end','stack','name','send','map','Campaign','rawAttributes','fieldName','key','query','intersection','attributes','fields','length','model','hasOwnProperty','nolimit','order','sort','where','filters','pick','merge','type','VIRTUAL','filter','options','includeAll','findAll','rows','show','params','keys','include','find','create','body','role','user','UserProfileSection','userProfileId','autoAssociation','catch','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','omit','updatedAt','createdAt','Unable\x20to\x20retrieve\x20the\x20current\x20user','getHoppers','findOne','CmHopper','CampaignId','getHopperHistories','CmHopperHistory','getHopperFinals','CmHopperFinal','CmHopperBlack','getLists','CmList','addLists','ids','spread','dialCheckDuplicateType','always','insert','cm_hopper','fromQuery','phone','scheduledAt','ContactId','field','NOW()','toString','ListId','from','ListId\x20=\x20?','CmListId','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','COALESCE(calleridnum,\x27\x27)','cm_hopper_final','CampaignId\x20=\x20?','COALESCE(phone,\x27\x27)','onlyIfOpen','into','select','cm_contacts','deletedAt\x20IS\x20NULL','sequelize','all','removeLists','getBlackLists','addBlackLists','cm_hopper_black','push','removeBlackLists','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','path'];(function(_0x363d42,_0x122b81){var _0x4d4137=function(_0x16c37e){while(--_0x16c37e){_0x363d42['push'](_0x363d42['shift']());}};_0x4d4137(++_0x122b81);}(_0x0e69,0x7d));var _0x90e6=function(_0x1cfa0d,_0x4391f2){_0x1cfa0d=_0x1cfa0d-0x0;var _0xe33279=_0x0e69[_0x1cfa0d];return _0xe33279;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x90e6('0x0'));var rimraf=require(_0x90e6('0x1'));var zipdir=require(_0x90e6('0x2'));var jsonpatch=require(_0x90e6('0x3'));var rp=require(_0x90e6('0x4'));var moment=require(_0x90e6('0x5'));var BPromise=require(_0x90e6('0x6'));var Mustache=require(_0x90e6('0x7'));var util=require('util');var path=require(_0x90e6('0x8'));var sox=require(_0x90e6('0x9'));var csv=require(_0x90e6('0xa'));var ejs=require(_0x90e6('0xb'));var fs=require('fs');var _=require(_0x90e6('0xc'));var squel=require(_0x90e6('0xd'));var crypto=require(_0x90e6('0xe'));var jsforce=require(_0x90e6('0xf'));var deskjs=require(_0x90e6('0x10'));var toCsv=require(_0x90e6('0xa'));var querystring=require('querystring');var Papa=require(_0x90e6('0x11'));var Redis=require(_0x90e6('0x12'));var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require(_0x90e6('0x13'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x90e6('0x14'))('api');var utils=require(_0x90e6('0x15'));var config=require(_0x90e6('0x16'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x1d3083,_0x9a8edd){_0x9a8edd=_0x9a8edd||0xcc;return function(_0x5527d1){if(_0x5527d1){return _0x1d3083[_0x90e6('0x17')](_0x9a8edd);}return _0x1d3083[_0x90e6('0x18')](_0x9a8edd)['end']();};}function respondWithResult(_0x42096e,_0x31ce97){_0x31ce97=_0x31ce97||0xc8;return function(_0x4c8fe1){if(_0x4c8fe1){return _0x42096e['status'](_0x31ce97)[_0x90e6('0x19')](_0x4c8fe1);}};}function respondWithFilteredResult(_0x2ea1d9,_0x5879d7){return function(_0x577a1e){if(_0x577a1e){var _0xdbd434=_0x577a1e[_0x90e6('0x1a')],_0x284eca=_0x5879d7[_0x90e6('0x1b')],_0x352f16=_0x5879d7[_0x90e6('0x1b')]+_0x5879d7[_0x90e6('0x1c')],_0x1bd506;if(_0x352f16>=_0xdbd434){_0x352f16=_0xdbd434;_0x1bd506=0xc8;}else{_0x1bd506=0xce;}_0x2ea1d9[_0x90e6('0x18')](_0x1bd506);return _0x2ea1d9['set']('Content-Range',_0x284eca+'-'+_0x352f16+'/'+_0xdbd434)[_0x90e6('0x19')](_0x577a1e);}return null;};}function patchUpdates(_0x54514c){return function(_0x219c31){try{jsonpatch[_0x90e6('0x1d')](_0x219c31,_0x54514c,!![]);}catch(_0x4f03b9){return BPromise[_0x90e6('0x1e')](_0x4f03b9);}return _0x219c31['save']();};}function saveUpdates(_0x4036d7,_0x4cca94){return function(_0x58b365){if(_0x58b365){return _0x58b365[_0x90e6('0x1f')](_0x4036d7)[_0x90e6('0x20')](function(_0x33d6cf){return _0x33d6cf;});}return null;};}function removeEntity(_0x3694ab,_0x3a1033){return function(_0x240e0c){if(_0x240e0c){return _0x240e0c[_0x90e6('0x21')]()[_0x90e6('0x20')](function(){var _0x3b3904=_0x240e0c[_0x90e6('0x22')]({'plain':!![]});var _0x5cee10=_0x90e6('0x23');return db[_0x90e6('0x24')][_0x90e6('0x21')]({'where':{'type':_0x5cee10,'resourceId':_0x3b3904['id']}})['then'](function(){return _0x240e0c;});})['then'](function(){_0x3694ab['status'](0xcc)[_0x90e6('0x25')]();});}};}function handleEntityNotFound(_0x4999c3,_0x227d5a){return function(_0x595f4a){if(!_0x595f4a){_0x4999c3[_0x90e6('0x17')](0x194);}return _0x595f4a;};}function handleError(_0x126e3c,_0x2b94fb){_0x2b94fb=_0x2b94fb||0x1f4;return function(_0x3a4de5){logger['error'](_0x3a4de5[_0x90e6('0x26')]);if(_0x3a4de5['name']){delete _0x3a4de5[_0x90e6('0x27')];}_0x126e3c[_0x90e6('0x18')](_0x2b94fb)[_0x90e6('0x28')](_0x3a4de5);};}exports['index']=function(_0x2442f8,_0x1cccdc){var _0x5c8638={},_0x247cd5={},_0x1154c5={'count':0x0,'rows':[]};var _0xd36dd3=_[_0x90e6('0x29')](db[_0x90e6('0x2a')][_0x90e6('0x2b')],function(_0x36648d){return{'name':_0x36648d[_0x90e6('0x2c')],'type':_0x36648d['type'][_0x90e6('0x2d')]};});_0x247cd5['model']=_[_0x90e6('0x29')](_0xd36dd3,_0x90e6('0x27'));_0x247cd5[_0x90e6('0x2e')]=_['keys'](_0x2442f8[_0x90e6('0x2e')]);_0x247cd5['filters']=_[_0x90e6('0x2f')](_0x247cd5['model'],_0x247cd5[_0x90e6('0x2e')]);_0x5c8638[_0x90e6('0x30')]=_[_0x90e6('0x2f')](_0x247cd5['model'],qs[_0x90e6('0x31')](_0x2442f8[_0x90e6('0x2e')][_0x90e6('0x31')]));_0x5c8638[_0x90e6('0x30')]=_0x5c8638[_0x90e6('0x30')][_0x90e6('0x32')]?_0x5c8638[_0x90e6('0x30')]:_0x247cd5[_0x90e6('0x33')];if(!_0x2442f8[_0x90e6('0x2e')][_0x90e6('0x34')](_0x90e6('0x35'))){_0x5c8638[_0x90e6('0x1c')]=qs['limit'](_0x2442f8[_0x90e6('0x2e')][_0x90e6('0x1c')]);_0x5c8638[_0x90e6('0x1b')]=qs['offset'](_0x2442f8[_0x90e6('0x2e')]['offset']);}_0x5c8638[_0x90e6('0x36')]=qs[_0x90e6('0x37')](_0x2442f8[_0x90e6('0x2e')][_0x90e6('0x37')]);_0x5c8638[_0x90e6('0x38')]=qs[_0x90e6('0x39')](_[_0x90e6('0x3a')](_0x2442f8[_0x90e6('0x2e')],_0x247cd5['filters']),_0xd36dd3);if(_0x2442f8[_0x90e6('0x2e')]['filter']){_0x5c8638[_0x90e6('0x38')]=_[_0x90e6('0x3b')](_0x5c8638[_0x90e6('0x38')],{'$or':_['map'](_0xd36dd3,function(_0x1f5afe){if(_0x1f5afe[_0x90e6('0x3c')]!==_0x90e6('0x3d')){var _0x58b575={};_0x58b575[_0x1f5afe['name']]={'$like':'%'+_0x2442f8['query'][_0x90e6('0x3e')]+'%'};return _0x58b575;}})});}_0x5c8638=_[_0x90e6('0x3b')]({},_0x5c8638,_0x2442f8[_0x90e6('0x3f')]);var _0x3f3173={'where':_0x5c8638[_0x90e6('0x38')]};return db[_0x90e6('0x2a')][_0x90e6('0x1a')](_0x3f3173)[_0x90e6('0x20')](function(_0x2926ff){_0x1154c5[_0x90e6('0x1a')]=_0x2926ff;if(_0x2442f8[_0x90e6('0x2e')][_0x90e6('0x40')]){_0x5c8638['include']=[{'all':!![]}];}return db['Campaign'][_0x90e6('0x41')](_0x5c8638);})[_0x90e6('0x20')](function(_0x58151c){_0x1154c5[_0x90e6('0x42')]=_0x58151c;return _0x1154c5;})['then'](respondWithFilteredResult(_0x1cccdc,_0x5c8638))['catch'](handleError(_0x1cccdc,null));};exports[_0x90e6('0x43')]=function(_0x130dc2,_0x5a724b){var _0x22f4e0={'raw':![],'where':{'id':_0x130dc2[_0x90e6('0x44')]['id']}},_0x3e5c95={};_0x3e5c95['model']=_['keys'](db[_0x90e6('0x2a')][_0x90e6('0x2b')]);_0x3e5c95[_0x90e6('0x2e')]=_[_0x90e6('0x45')](_0x130dc2[_0x90e6('0x2e')]);_0x3e5c95[_0x90e6('0x39')]=_[_0x90e6('0x2f')](_0x3e5c95[_0x90e6('0x33')],_0x3e5c95[_0x90e6('0x2e')]);_0x22f4e0[_0x90e6('0x30')]=_[_0x90e6('0x2f')](_0x3e5c95[_0x90e6('0x33')],qs[_0x90e6('0x31')](_0x130dc2[_0x90e6('0x2e')][_0x90e6('0x31')]));_0x22f4e0[_0x90e6('0x30')]=_0x22f4e0['attributes'][_0x90e6('0x32')]?_0x22f4e0['attributes']:_0x3e5c95[_0x90e6('0x33')];if(_0x130dc2['query'][_0x90e6('0x40')]){_0x22f4e0[_0x90e6('0x46')]=[{'all':!![]}];}_0x22f4e0=_[_0x90e6('0x3b')]({},_0x22f4e0,_0x130dc2[_0x90e6('0x3f')]);return db[_0x90e6('0x2a')][_0x90e6('0x47')](_0x22f4e0)[_0x90e6('0x20')](handleEntityNotFound(_0x5a724b,null))[_0x90e6('0x20')](respondWithResult(_0x5a724b,null))['catch'](handleError(_0x5a724b,null));};exports[_0x90e6('0x48')]=function(_0x44d583,_0x36caec){return db['Campaign'][_0x90e6('0x48')](_0x44d583[_0x90e6('0x49')],{})[_0x90e6('0x20')](function(_0x3fa20b){var _0x225cd7=_0x44d583['user'][_0x90e6('0x22')]({'plain':!![]});if(!_0x225cd7)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x225cd7[_0x90e6('0x4a')]===_0x90e6('0x4b')){var _0x3ca335=_0x3fa20b[_0x90e6('0x22')]({'plain':!![]});var _0x489816='IvrCampaigns';return db[_0x90e6('0x4c')][_0x90e6('0x47')]({'where':{'name':_0x489816,'userProfileId':_0x225cd7[_0x90e6('0x4d')]},'raw':!![]})[_0x90e6('0x20')](function(_0x29d416){if(_0x29d416&&_0x29d416[_0x90e6('0x4e')]===0x0){return db[_0x90e6('0x24')]['create']({'name':_0x3ca335[_0x90e6('0x27')],'resourceId':_0x3ca335['id'],'type':_0x29d416[_0x90e6('0x27')],'sectionId':_0x29d416['id']},{})[_0x90e6('0x20')](function(){return _0x3fa20b;});}else{return _0x3fa20b;}})[_0x90e6('0x4f')](function(_0x27b6c7){logger[_0x90e6('0x50')](_0x90e6('0x51'),_0x27b6c7);throw _0x27b6c7;});}return _0x3fa20b;})[_0x90e6('0x20')](respondWithResult(_0x36caec,0xc9))[_0x90e6('0x4f')](handleError(_0x36caec,null));};exports['clone']=function(_0xa41b24,_0x15587a){var _0x559e85={'where':{'id':_0xa41b24[_0x90e6('0x44')]['id']}},_0x3da942={};_0x3da942[_0x90e6('0x33')]=_[_0x90e6('0x45')](db[_0x90e6('0x2a')][_0x90e6('0x2b')]);_0x559e85[_0x90e6('0x30')]=_[_0x90e6('0x2f')](_0x3da942['model'],qs[_0x90e6('0x31')](_0xa41b24[_0x90e6('0x2e')]['fields']));_0x559e85[_0x90e6('0x30')]=_0x559e85[_0x90e6('0x30')]['length']?_0x559e85[_0x90e6('0x30')]:_0x3da942[_0x90e6('0x33')];if(_0xa41b24[_0x90e6('0x2e')][_0x90e6('0x40')]){_0x559e85['include']=[{'all':!![]}];}_0x559e85=_[_0x90e6('0x3b')]({},_0x559e85,_0xa41b24[_0x90e6('0x3f')]);return db[_0x90e6('0x2a')][_0x90e6('0x47')](_0x559e85)[_0x90e6('0x20')](handleEntityNotFound(_0x15587a,null))[_0x90e6('0x20')](function(_0x2c6ef2){if(_0x2c6ef2){var _0x3d7a39=_0x2c6ef2[_0x90e6('0x22')]({'plain':!![]});_0x3d7a39=qs[_0x90e6('0x52')](_0x3d7a39,['id','createdAt',_0x90e6('0x53')]);_0xa41b24[_0x90e6('0x49')]=_[_0x90e6('0x52')](_0xa41b24['body'],['id',_0x90e6('0x54'),_0x90e6('0x53')]);return db['Campaign'][_0x90e6('0x48')](_[_0x90e6('0x3b')](_0x3d7a39,_0xa41b24[_0x90e6('0x49')]),{'include':_0xa41b24[_0x90e6('0x2e')]['includeAll']?[{'all':!![]}]:undefined})['then'](function(_0x25b97d){var _0x391321=_0xa41b24['user'][_0x90e6('0x22')]({'plain':!![]});if(!_0x391321)throw new Error(_0x90e6('0x55'));if(_0x391321[_0x90e6('0x4a')]===_0x90e6('0x4b')){var _0x37cd28=_0x25b97d[_0x90e6('0x22')]({'plain':!![]});var _0x438c13='IvrCampaigns';return db['UserProfileSection'][_0x90e6('0x47')]({'where':{'name':_0x438c13,'userProfileId':_0x391321[_0x90e6('0x4d')]},'raw':!![]})[_0x90e6('0x20')](function(_0x3752e5){if(_0x3752e5&&_0x3752e5[_0x90e6('0x4e')]===0x0){return db[_0x90e6('0x24')][_0x90e6('0x48')]({'name':_0x37cd28[_0x90e6('0x27')],'resourceId':_0x37cd28['id'],'type':_0x3752e5[_0x90e6('0x27')],'sectionId':_0x3752e5['id']},{})['then'](function(){return _0x25b97d;});}else{return _0x25b97d;}})[_0x90e6('0x4f')](function(_0x25e760){logger[_0x90e6('0x50')](_0x90e6('0x51'),_0x25e760);throw _0x25e760;});}return _0x25b97d;});}})[_0x90e6('0x20')](respondWithResult(_0x15587a,0xc9))[_0x90e6('0x4f')](handleError(_0x15587a,null));};exports[_0x90e6('0x1f')]=function(_0x25e713,_0x31ff95){if(_0x25e713[_0x90e6('0x49')]['id']){delete _0x25e713['body']['id'];}return db[_0x90e6('0x2a')][_0x90e6('0x47')]({'where':{'id':_0x25e713[_0x90e6('0x44')]['id']}})[_0x90e6('0x20')](handleEntityNotFound(_0x31ff95,null))['then'](saveUpdates(_0x25e713[_0x90e6('0x49')],null))['then'](respondWithResult(_0x31ff95,null))['catch'](handleError(_0x31ff95,null));};exports[_0x90e6('0x21')]=function(_0x1a9500,_0x413ef2){return db['Campaign'][_0x90e6('0x47')]({'where':{'id':_0x1a9500[_0x90e6('0x44')]['id']}})[_0x90e6('0x20')](handleEntityNotFound(_0x413ef2,null))[_0x90e6('0x20')](removeEntity(_0x413ef2,null))['catch'](handleError(_0x413ef2,null));};exports[_0x90e6('0x56')]=function(_0x5319fc,_0x5004c1,_0x868dcb){var _0x4e508c={'raw':!![],'where':{}};var _0x329109={};var _0x24ebc6={'count':0x0,'rows':[]};return db[_0x90e6('0x2a')][_0x90e6('0x57')]({'where':{'id':_0x5319fc[_0x90e6('0x44')]['id']}})['then'](handleEntityNotFound(_0x5004c1,null))[_0x90e6('0x20')](function(_0xbb006f){if(_0xbb006f){_0x329109[_0x90e6('0x33')]=_[_0x90e6('0x45')](db[_0x90e6('0x58')]['rawAttributes']);_0x329109[_0x90e6('0x2e')]=_[_0x90e6('0x45')](_0x5319fc['query']);_0x329109['filters']=_[_0x90e6('0x2f')](_0x329109['model'],_0x329109['query']);_0x4e508c['attributes']=_[_0x90e6('0x2f')](_0x329109[_0x90e6('0x33')],qs[_0x90e6('0x31')](_0x5319fc[_0x90e6('0x2e')][_0x90e6('0x31')]));_0x4e508c[_0x90e6('0x30')]=_0x4e508c[_0x90e6('0x30')][_0x90e6('0x32')]?_0x4e508c['attributes']:_0x329109[_0x90e6('0x33')];if(!_0x5319fc[_0x90e6('0x2e')][_0x90e6('0x34')](_0x90e6('0x35'))){_0x4e508c[_0x90e6('0x1c')]=qs[_0x90e6('0x1c')](_0x5319fc[_0x90e6('0x2e')]['limit']);_0x4e508c['offset']=qs[_0x90e6('0x1b')](_0x5319fc[_0x90e6('0x2e')]['offset']);}_0x4e508c[_0x90e6('0x36')]=qs['sort'](_0x5319fc[_0x90e6('0x2e')][_0x90e6('0x37')]);_0x4e508c['where']=qs[_0x90e6('0x39')](_[_0x90e6('0x3a')](_0x5319fc['query'],_0x329109['filters']));_0x4e508c[_0x90e6('0x38')][_0x90e6('0x59')]=_0xbb006f['id'];if(_0x5319fc[_0x90e6('0x2e')][_0x90e6('0x3e')]){_0x4e508c[_0x90e6('0x38')]=_[_0x90e6('0x3b')](_0x4e508c[_0x90e6('0x38')],{'$or':_['map'](_0x4e508c[_0x90e6('0x30')],function(_0x12a276){var _0xbf9ee5={};_0xbf9ee5[_0x12a276]={'$like':'%'+_0x5319fc[_0x90e6('0x2e')][_0x90e6('0x3e')]+'%'};return _0xbf9ee5;})});}_0x4e508c=_[_0x90e6('0x3b')]({},_0x4e508c,_0x5319fc[_0x90e6('0x3f')]);return db['CmHopper'][_0x90e6('0x1a')]({'where':_0x4e508c[_0x90e6('0x38')]})['then'](function(_0x4b6102){_0x24ebc6[_0x90e6('0x1a')]=_0x4b6102;if(_0x5319fc[_0x90e6('0x2e')][_0x90e6('0x40')]){_0x4e508c[_0x90e6('0x46')]=[{'all':!![]}];}return db[_0x90e6('0x58')]['findAll'](_0x4e508c);})['then'](function(_0x3a4f4a){_0x24ebc6[_0x90e6('0x42')]=_0x3a4f4a;return _0x24ebc6;});}})[_0x90e6('0x20')](respondWithFilteredResult(_0x5004c1,_0x4e508c))['catch'](handleError(_0x5004c1,null));};exports[_0x90e6('0x5a')]=function(_0x3c917b,_0x1d376f,_0x394989){var _0x9c9d8f={'raw':!![],'where':{}};var _0x4a5903={};var _0x4212fa={'count':0x0,'rows':[]};return db[_0x90e6('0x2a')][_0x90e6('0x57')]({'where':{'id':_0x3c917b[_0x90e6('0x44')]['id']}})['then'](handleEntityNotFound(_0x1d376f,null))[_0x90e6('0x20')](function(_0x5db8e6){if(_0x5db8e6){_0x4a5903[_0x90e6('0x33')]=_[_0x90e6('0x45')](db[_0x90e6('0x5b')]['rawAttributes']);_0x4a5903[_0x90e6('0x2e')]=_['keys'](_0x3c917b['query']);_0x4a5903[_0x90e6('0x39')]=_[_0x90e6('0x2f')](_0x4a5903[_0x90e6('0x33')],_0x4a5903[_0x90e6('0x2e')]);_0x9c9d8f['attributes']=_['intersection'](_0x4a5903[_0x90e6('0x33')],qs[_0x90e6('0x31')](_0x3c917b[_0x90e6('0x2e')]['fields']));_0x9c9d8f[_0x90e6('0x30')]=_0x9c9d8f[_0x90e6('0x30')][_0x90e6('0x32')]?_0x9c9d8f[_0x90e6('0x30')]:_0x4a5903[_0x90e6('0x33')];if(!_0x3c917b['query'][_0x90e6('0x34')](_0x90e6('0x35'))){_0x9c9d8f[_0x90e6('0x1c')]=qs[_0x90e6('0x1c')](_0x3c917b[_0x90e6('0x2e')][_0x90e6('0x1c')]);_0x9c9d8f['offset']=qs[_0x90e6('0x1b')](_0x3c917b[_0x90e6('0x2e')][_0x90e6('0x1b')]);}_0x9c9d8f['order']=qs[_0x90e6('0x37')](_0x3c917b[_0x90e6('0x2e')][_0x90e6('0x37')]);_0x9c9d8f[_0x90e6('0x38')]=qs[_0x90e6('0x39')](_[_0x90e6('0x3a')](_0x3c917b['query'],_0x4a5903[_0x90e6('0x39')]));_0x9c9d8f['where'][_0x90e6('0x59')]=_0x5db8e6['id'];if(_0x3c917b[_0x90e6('0x2e')][_0x90e6('0x3e')]){_0x9c9d8f[_0x90e6('0x38')]=_[_0x90e6('0x3b')](_0x9c9d8f['where'],{'$or':_[_0x90e6('0x29')](_0x9c9d8f[_0x90e6('0x30')],function(_0x2ef476){var _0x3b8074={};_0x3b8074[_0x2ef476]={'$like':'%'+_0x3c917b['query'][_0x90e6('0x3e')]+'%'};return _0x3b8074;})});}_0x9c9d8f=_[_0x90e6('0x3b')]({},_0x9c9d8f,_0x3c917b[_0x90e6('0x3f')]);return db[_0x90e6('0x5b')][_0x90e6('0x1a')]({'where':_0x9c9d8f['where']})[_0x90e6('0x20')](function(_0x35017c){_0x4212fa['count']=_0x35017c;if(_0x3c917b[_0x90e6('0x2e')][_0x90e6('0x40')]){_0x9c9d8f['include']=[{'all':!![]}];}return db[_0x90e6('0x5b')][_0x90e6('0x41')](_0x9c9d8f);})['then'](function(_0x5a32a6){_0x4212fa[_0x90e6('0x42')]=_0x5a32a6;return _0x4212fa;});}})['then'](respondWithFilteredResult(_0x1d376f,_0x9c9d8f))[_0x90e6('0x4f')](handleError(_0x1d376f,null));};exports[_0x90e6('0x5c')]=function(_0x46febd,_0x84e38b,_0x1b4ac9){var _0x287bfe={'raw':!![],'where':{}};var _0x532632={};var _0x355dc7={'count':0x0,'rows':[]};return db[_0x90e6('0x2a')][_0x90e6('0x57')]({'where':{'id':_0x46febd[_0x90e6('0x44')]['id']}})['then'](handleEntityNotFound(_0x84e38b,null))[_0x90e6('0x20')](function(_0x5d929f){if(_0x5d929f){_0x532632[_0x90e6('0x33')]=_[_0x90e6('0x45')](db[_0x90e6('0x5d')][_0x90e6('0x2b')]);_0x532632[_0x90e6('0x2e')]=_['keys'](_0x46febd[_0x90e6('0x2e')]);_0x532632[_0x90e6('0x39')]=_['intersection'](_0x532632[_0x90e6('0x33')],_0x532632[_0x90e6('0x2e')]);_0x287bfe[_0x90e6('0x30')]=_[_0x90e6('0x2f')](_0x532632[_0x90e6('0x33')],qs[_0x90e6('0x31')](_0x46febd[_0x90e6('0x2e')][_0x90e6('0x31')]));_0x287bfe['attributes']=_0x287bfe[_0x90e6('0x30')][_0x90e6('0x32')]?_0x287bfe[_0x90e6('0x30')]:_0x532632[_0x90e6('0x33')];if(!_0x46febd['query']['hasOwnProperty'](_0x90e6('0x35'))){_0x287bfe[_0x90e6('0x1c')]=qs['limit'](_0x46febd['query'][_0x90e6('0x1c')]);_0x287bfe[_0x90e6('0x1b')]=qs[_0x90e6('0x1b')](_0x46febd['query']['offset']);}_0x287bfe[_0x90e6('0x36')]=qs[_0x90e6('0x37')](_0x46febd[_0x90e6('0x2e')][_0x90e6('0x37')]);_0x287bfe[_0x90e6('0x38')]=qs[_0x90e6('0x39')](_[_0x90e6('0x3a')](_0x46febd[_0x90e6('0x2e')],_0x532632[_0x90e6('0x39')]));_0x287bfe[_0x90e6('0x38')][_0x90e6('0x59')]=_0x5d929f['id'];if(_0x46febd[_0x90e6('0x2e')]['filter']){_0x287bfe[_0x90e6('0x38')]=_[_0x90e6('0x3b')](_0x287bfe[_0x90e6('0x38')],{'$or':_[_0x90e6('0x29')](_0x287bfe[_0x90e6('0x30')],function(_0x1d7fe5){var _0x19fa24={};_0x19fa24[_0x1d7fe5]={'$like':'%'+_0x46febd['query']['filter']+'%'};return _0x19fa24;})});}_0x287bfe=_['merge']({},_0x287bfe,_0x46febd[_0x90e6('0x3f')]);return db[_0x90e6('0x5d')][_0x90e6('0x1a')]({'where':_0x287bfe[_0x90e6('0x38')]})[_0x90e6('0x20')](function(_0x3a19ec){_0x355dc7[_0x90e6('0x1a')]=_0x3a19ec;if(_0x46febd[_0x90e6('0x2e')][_0x90e6('0x40')]){_0x287bfe[_0x90e6('0x46')]=[{'all':!![]}];}return db[_0x90e6('0x5d')][_0x90e6('0x41')](_0x287bfe);})[_0x90e6('0x20')](function(_0x29d4fa){_0x355dc7[_0x90e6('0x42')]=_0x29d4fa;return _0x355dc7;});}})[_0x90e6('0x20')](respondWithFilteredResult(_0x84e38b,_0x287bfe))[_0x90e6('0x4f')](handleError(_0x84e38b,null));};exports['getHopperBlacks']=function(_0x18c512,_0x4cc710,_0x1fe049){var _0x31078f={'raw':!![],'where':{}};var _0x17fed3={};var _0x548413={'count':0x0,'rows':[]};return db[_0x90e6('0x2a')][_0x90e6('0x57')]({'where':{'id':_0x18c512[_0x90e6('0x44')]['id']}})[_0x90e6('0x20')](handleEntityNotFound(_0x4cc710,null))['then'](function(_0x68ca58){if(_0x68ca58){_0x17fed3['model']=_['keys'](db[_0x90e6('0x5e')]['rawAttributes']);_0x17fed3[_0x90e6('0x2e')]=_[_0x90e6('0x45')](_0x18c512[_0x90e6('0x2e')]);_0x17fed3[_0x90e6('0x39')]=_[_0x90e6('0x2f')](_0x17fed3[_0x90e6('0x33')],_0x17fed3[_0x90e6('0x2e')]);_0x31078f[_0x90e6('0x30')]=_[_0x90e6('0x2f')](_0x17fed3[_0x90e6('0x33')],qs[_0x90e6('0x31')](_0x18c512['query']['fields']));_0x31078f[_0x90e6('0x30')]=_0x31078f[_0x90e6('0x30')]['length']?_0x31078f['attributes']:_0x17fed3['model'];if(!_0x18c512[_0x90e6('0x2e')]['hasOwnProperty'](_0x90e6('0x35'))){_0x31078f['limit']=qs[_0x90e6('0x1c')](_0x18c512['query']['limit']);_0x31078f[_0x90e6('0x1b')]=qs[_0x90e6('0x1b')](_0x18c512[_0x90e6('0x2e')][_0x90e6('0x1b')]);}_0x31078f[_0x90e6('0x36')]=qs[_0x90e6('0x37')](_0x18c512[_0x90e6('0x2e')][_0x90e6('0x37')]);_0x31078f[_0x90e6('0x38')]=qs['filters'](_[_0x90e6('0x3a')](_0x18c512[_0x90e6('0x2e')],_0x17fed3[_0x90e6('0x39')]));_0x31078f[_0x90e6('0x38')][_0x90e6('0x59')]=_0x68ca58['id'];if(_0x18c512[_0x90e6('0x2e')][_0x90e6('0x3e')]){_0x31078f['where']=_[_0x90e6('0x3b')](_0x31078f['where'],{'$or':_['map'](_0x31078f[_0x90e6('0x30')],function(_0x52d695){var _0x5255ec={};_0x5255ec[_0x52d695]={'$like':'%'+_0x18c512[_0x90e6('0x2e')][_0x90e6('0x3e')]+'%'};return _0x5255ec;})});}_0x31078f=_[_0x90e6('0x3b')]({},_0x31078f,_0x18c512[_0x90e6('0x3f')]);return db['CmHopperBlack']['count']({'where':_0x31078f[_0x90e6('0x38')]})[_0x90e6('0x20')](function(_0x233aaa){_0x548413[_0x90e6('0x1a')]=_0x233aaa;if(_0x18c512[_0x90e6('0x2e')]['includeAll']){_0x31078f[_0x90e6('0x46')]=[{'all':!![]}];}return db[_0x90e6('0x5e')]['findAll'](_0x31078f);})[_0x90e6('0x20')](function(_0x261035){_0x548413[_0x90e6('0x42')]=_0x261035;return _0x548413;});}})['then'](respondWithFilteredResult(_0x4cc710,_0x31078f))[_0x90e6('0x4f')](handleError(_0x4cc710,null));};exports[_0x90e6('0x5f')]=function(_0x414568,_0x13486d,_0x2c1cc6){var _0x30cfe5={};var _0x25365a={};var _0xc141e9;var _0x2da162;return db['Campaign'][_0x90e6('0x57')]({'where':{'id':_0x414568[_0x90e6('0x44')]['id']}})[_0x90e6('0x20')](handleEntityNotFound(_0x13486d,null))[_0x90e6('0x20')](function(_0x5082b9){if(_0x5082b9){_0xc141e9=_0x5082b9;_0x25365a[_0x90e6('0x33')]=_['keys'](db[_0x90e6('0x60')]['rawAttributes']);_0x25365a[_0x90e6('0x2e')]=_[_0x90e6('0x45')](_0x414568[_0x90e6('0x2e')]);_0x25365a[_0x90e6('0x39')]=_[_0x90e6('0x2f')](_0x25365a[_0x90e6('0x33')],_0x25365a[_0x90e6('0x2e')]);_0x30cfe5['attributes']=_[_0x90e6('0x2f')](_0x25365a[_0x90e6('0x33')],qs[_0x90e6('0x31')](_0x414568[_0x90e6('0x2e')][_0x90e6('0x31')]));_0x30cfe5[_0x90e6('0x30')]=_0x30cfe5[_0x90e6('0x30')]['length']?_0x30cfe5['attributes']:_0x25365a[_0x90e6('0x33')];_0x30cfe5[_0x90e6('0x36')]=qs['sort'](_0x414568[_0x90e6('0x2e')][_0x90e6('0x37')]);_0x30cfe5[_0x90e6('0x38')]=qs[_0x90e6('0x39')](_[_0x90e6('0x3a')](_0x414568[_0x90e6('0x2e')],_0x25365a[_0x90e6('0x39')]));if(_0x414568[_0x90e6('0x2e')][_0x90e6('0x3e')]){_0x30cfe5[_0x90e6('0x38')]=_[_0x90e6('0x3b')](_0x30cfe5[_0x90e6('0x38')],{'$or':_[_0x90e6('0x29')](_0x30cfe5['attributes'],function(_0x541f70){var _0x487fbc={};_0x487fbc[_0x541f70]={'$like':'%'+_0x414568[_0x90e6('0x2e')][_0x90e6('0x3e')]+'%'};return _0x487fbc;})});}_0x30cfe5=_[_0x90e6('0x3b')]({},_0x30cfe5,_0x414568[_0x90e6('0x3f')]);return _0xc141e9[_0x90e6('0x5f')](_0x30cfe5);}})[_0x90e6('0x20')](function(_0x2d17ab){if(_0x2d17ab){_0x2da162=_0x2d17ab['length'];if(!_0x414568[_0x90e6('0x2e')][_0x90e6('0x34')](_0x90e6('0x35'))){_0x30cfe5[_0x90e6('0x1c')]=qs[_0x90e6('0x1c')](_0x414568[_0x90e6('0x2e')][_0x90e6('0x1c')]);_0x30cfe5[_0x90e6('0x1b')]=qs['offset'](_0x414568[_0x90e6('0x2e')][_0x90e6('0x1b')]);}return _0xc141e9[_0x90e6('0x5f')](_0x30cfe5);}})[_0x90e6('0x20')](function(_0x6eacfe){if(_0x6eacfe){return _0x6eacfe?{'count':_0x2da162,'rows':_0x6eacfe}:null;}})[_0x90e6('0x20')](respondWithResult(_0x13486d,null))['catch'](handleError(_0x13486d,null));};exports[_0x90e6('0x61')]=function(_0x581813,_0xf45b8e,_0x339a47){var _0x3a30f9,_0x24a12f;return db[_0x90e6('0x2a')]['find']({'where':{'id':_0x581813[_0x90e6('0x44')]['id']}})[_0x90e6('0x20')](handleEntityNotFound(_0xf45b8e,null))[_0x90e6('0x20')](function(_0xa04298){if(_0xa04298){_0x24a12f=_0xa04298;return _0xa04298[_0x90e6('0x61')](_0x581813[_0x90e6('0x49')][_0x90e6('0x62')],_['omit'](_0x581813[_0x90e6('0x49')],[_0x90e6('0x62'),'id'])||{});}return null;})[_0x90e6('0x63')](function(_0x187b60){var _0x3ab48e;_0x3a30f9=_0x187b60||[];var _0x4b0f86=[];if(_0x187b60){for(var _0x130dab=0x0;_0x130dab<_0x187b60['length'];_0x130dab+=0x1){var _0x141937=_0x187b60[_0x130dab][_0x90e6('0x22')]({'plain':!![]});_0x24a12f[_0x90e6('0x64')]=_0x581813[_0x90e6('0x49')][_0x90e6('0x64')]?_0x581813[_0x90e6('0x49')]['dialCheckDuplicateType']:_0x24a12f['dialCheckDuplicateType'];switch(_0x24a12f[_0x90e6('0x64')]){case _0x90e6('0x65'):_0x3ab48e=squel[_0x90e6('0x66')]()['into'](_0x90e6('0x67'))[_0x90e6('0x68')]([_0x90e6('0x69'),_0x90e6('0x6a'),_0x90e6('0x6b'),'ListId',_0x90e6('0x59'),_0x90e6('0x54'),_0x90e6('0x53')],squel['select']()[_0x90e6('0x6c')](_0x90e6('0x69'),_0x90e6('0x69'))[_0x90e6('0x6c')](_0x90e6('0x6d'),_0x90e6('0x6a'))['field']('id',_0x90e6('0x6b'))[_0x90e6('0x6c')](_0x141937['CmListId'][_0x90e6('0x6e')](),_0x90e6('0x6f'))[_0x90e6('0x6c')](_0x581813[_0x90e6('0x44')]['id'][_0x90e6('0x6e')](),_0x90e6('0x59'))[_0x90e6('0x6c')](_0x90e6('0x6d'),_0x90e6('0x54'))[_0x90e6('0x6c')]('NOW()',_0x90e6('0x53'))[_0x90e6('0x70')]('cm_contacts')[_0x90e6('0x38')]('deletedAt\x20IS\x20NULL')[_0x90e6('0x38')](_0x90e6('0x71'),_0x141937[_0x90e6('0x72')][_0x90e6('0x6e')]())[_0x90e6('0x38')](_0x90e6('0x73'))[_0x90e6('0x38')](_0x90e6('0x74'),squel['select']()[_0x90e6('0x6c')](_0x90e6('0x75'))['from'](_0x90e6('0x76'))[_0x90e6('0x38')](_0x90e6('0x77'),_0x581813[_0x90e6('0x44')]['id'][_0x90e6('0x6e')]()))[_0x90e6('0x38')](_0x90e6('0x74'),squel['select']()[_0x90e6('0x6c')](_0x90e6('0x78'))['from'](_0x90e6('0x67'))[_0x90e6('0x38')](_0x90e6('0x77'),_0x581813[_0x90e6('0x44')]['id'][_0x90e6('0x6e')]())))[_0x90e6('0x6e')]();break;case _0x90e6('0x79'):_0x3ab48e=squel[_0x90e6('0x66')]()[_0x90e6('0x7a')](_0x90e6('0x67'))[_0x90e6('0x68')](['phone','scheduledAt','ContactId',_0x90e6('0x6f'),_0x90e6('0x59'),_0x90e6('0x54'),_0x90e6('0x53')],squel[_0x90e6('0x7b')]()[_0x90e6('0x6c')]('phone','phone')[_0x90e6('0x6c')](_0x90e6('0x6d'),_0x90e6('0x6a'))[_0x90e6('0x6c')]('id','ContactId')[_0x90e6('0x6c')](_0x141937[_0x90e6('0x72')][_0x90e6('0x6e')](),_0x90e6('0x6f'))['field'](_0x581813['params']['id'][_0x90e6('0x6e')](),'CampaignId')[_0x90e6('0x6c')](_0x90e6('0x6d'),'createdAt')[_0x90e6('0x6c')]('NOW()',_0x90e6('0x53'))[_0x90e6('0x70')](_0x90e6('0x7c'))[_0x90e6('0x38')]('deletedAt\x20IS\x20NULL')[_0x90e6('0x38')]('ListId\x20=\x20?',_0x141937['CmListId'][_0x90e6('0x6e')]())[_0x90e6('0x38')](_0x90e6('0x73'))['where'](_0x90e6('0x74'),squel[_0x90e6('0x7b')]()[_0x90e6('0x6c')]('COALESCE(phone,\x27\x27)')['from']('cm_hopper')[_0x90e6('0x38')]('CampaignId\x20=\x20?',_0x581813[_0x90e6('0x44')]['id'][_0x90e6('0x6e')]())))[_0x90e6('0x6e')]();break;default:_0x3ab48e=squel[_0x90e6('0x66')]()[_0x90e6('0x7a')](_0x90e6('0x67'))[_0x90e6('0x68')](['phone',_0x90e6('0x6a'),_0x90e6('0x6b'),_0x90e6('0x6f'),'CampaignId',_0x90e6('0x54'),_0x90e6('0x53')],squel[_0x90e6('0x7b')]()['field']('phone',_0x90e6('0x69'))[_0x90e6('0x6c')](_0x90e6('0x6d'),'scheduledAt')[_0x90e6('0x6c')]('id','ContactId')[_0x90e6('0x6c')](_0x141937[_0x90e6('0x72')]['toString'](),'ListId')[_0x90e6('0x6c')](_0x581813[_0x90e6('0x44')]['id'][_0x90e6('0x6e')](),_0x90e6('0x59'))[_0x90e6('0x6c')](_0x90e6('0x6d'),'createdAt')[_0x90e6('0x6c')](_0x90e6('0x6d'),_0x90e6('0x53'))[_0x90e6('0x70')]('cm_contacts')[_0x90e6('0x38')](_0x90e6('0x7d'))[_0x90e6('0x38')](_0x90e6('0x71'),_0x141937['CmListId'][_0x90e6('0x6e')]())[_0x90e6('0x38')](_0x90e6('0x73')))[_0x90e6('0x6e')]();}_0x4b0f86['push'](db[_0x90e6('0x7e')][_0x90e6('0x2e')](_0x3ab48e));}return BPromise[_0x90e6('0x7f')](_0x4b0f86);}})[_0x90e6('0x20')](function(){return _0x3a30f9;})['then'](respondWithResult(_0xf45b8e,null))[_0x90e6('0x4f')](handleError(_0xf45b8e,null));};exports[_0x90e6('0x80')]=function(_0x19fcf4,_0x29c6a6,_0xaca9dd){return db['Campaign'][_0x90e6('0x47')]({'where':{'id':_0x19fcf4[_0x90e6('0x44')]['id']}})[_0x90e6('0x20')](handleEntityNotFound(_0x29c6a6,null))[_0x90e6('0x20')](function(_0x352e0f){if(_0x352e0f){return _0x352e0f[_0x90e6('0x80')](_0x19fcf4[_0x90e6('0x2e')][_0x90e6('0x62')]);}})[_0x90e6('0x20')](function(_0x2394fb){if(_0x2394fb){return db[_0x90e6('0x58')][_0x90e6('0x21')]({'where':{'ListId':_0x19fcf4['query'][_0x90e6('0x62')],'CampaignId':_0x19fcf4[_0x90e6('0x44')]['id']}})[_0x90e6('0x20')](function(){return _0x2394fb;});}})[_0x90e6('0x20')](respondWithStatusCode(_0x29c6a6,null))['catch'](handleError(_0x29c6a6,null));};exports[_0x90e6('0x81')]=function(_0x4cd671,_0x6aa69c,_0x4472b7){var _0x39f0f1={'raw':!![],'where':{}};var _0x386019={};var _0x343849={'count':0x0,'rows':[]};return db[_0x90e6('0x2a')][_0x90e6('0x57')]({'where':{'id':_0x4cd671[_0x90e6('0x44')]['id']}})[_0x90e6('0x20')](handleEntityNotFound(_0x6aa69c,null))[_0x90e6('0x20')](function(_0x171730){if(_0x171730){_0x386019['model']=_['keys'](db['CmList'][_0x90e6('0x2b')]);_0x386019['query']=_[_0x90e6('0x45')](_0x4cd671['query']);_0x386019['filters']=_['intersection'](_0x386019[_0x90e6('0x33')],_0x386019[_0x90e6('0x2e')]);_0x39f0f1[_0x90e6('0x30')]=_['intersection'](_0x386019[_0x90e6('0x33')],qs[_0x90e6('0x31')](_0x4cd671[_0x90e6('0x2e')][_0x90e6('0x31')]));_0x39f0f1[_0x90e6('0x30')]=_0x39f0f1[_0x90e6('0x30')][_0x90e6('0x32')]?_0x39f0f1['attributes']:_0x386019['model'];if(!_0x4cd671['query'][_0x90e6('0x34')](_0x90e6('0x35'))){_0x39f0f1[_0x90e6('0x1c')]=qs[_0x90e6('0x1c')](_0x4cd671[_0x90e6('0x2e')][_0x90e6('0x1c')]);_0x39f0f1['offset']=qs[_0x90e6('0x1b')](_0x4cd671['query'][_0x90e6('0x1b')]);}_0x39f0f1[_0x90e6('0x36')]=qs[_0x90e6('0x37')](_0x4cd671[_0x90e6('0x2e')][_0x90e6('0x37')]);_0x39f0f1[_0x90e6('0x38')]=qs['filters'](_[_0x90e6('0x3a')](_0x4cd671['query'],_0x386019[_0x90e6('0x39')]));_0x39f0f1['where']['CampaignId']=_0x171730['id'];if(_0x4cd671[_0x90e6('0x2e')][_0x90e6('0x3e')]){_0x39f0f1[_0x90e6('0x38')]=_[_0x90e6('0x3b')](_0x39f0f1[_0x90e6('0x38')],{'$or':_[_0x90e6('0x29')](_0x39f0f1[_0x90e6('0x30')],function(_0x4d9676){var _0x436709={};_0x436709[_0x4d9676]={'$like':'%'+_0x4cd671['query'][_0x90e6('0x3e')]+'%'};return _0x436709;})});}_0x39f0f1=_['merge']({},_0x39f0f1,_0x4cd671['options']);return db[_0x90e6('0x60')]['count']({'where':_0x39f0f1[_0x90e6('0x38')]})[_0x90e6('0x20')](function(_0x53ee17){_0x343849[_0x90e6('0x1a')]=_0x53ee17;if(_0x4cd671[_0x90e6('0x2e')]['includeAll']){_0x39f0f1['include']=[{'all':!![]}];}return db[_0x90e6('0x60')]['findAll'](_0x39f0f1);})['then'](function(_0x37c863){_0x343849[_0x90e6('0x42')]=_0x37c863;return _0x343849;});}})[_0x90e6('0x20')](respondWithFilteredResult(_0x6aa69c,_0x39f0f1))[_0x90e6('0x4f')](handleError(_0x6aa69c,null));};exports[_0x90e6('0x82')]=function(_0x2f1886,_0x1812ac,_0x41c4d6){var _0x1acd33,_0x4dedd0;return db[_0x90e6('0x2a')][_0x90e6('0x47')]({'where':{'id':_0x2f1886[_0x90e6('0x44')]['id']}})['then'](handleEntityNotFound(_0x1812ac,null))[_0x90e6('0x20')](function(_0x175d15){if(_0x175d15){_0x4dedd0=_0x175d15;return _0x175d15[_0x90e6('0x82')](_0x2f1886[_0x90e6('0x49')]['ids'],_[_0x90e6('0x52')](_0x2f1886[_0x90e6('0x49')],[_0x90e6('0x62'),'id'])||{});}return null;})[_0x90e6('0x63')](function(_0x11ff3c){var _0x56859f;_0x1acd33=_0x11ff3c||[];var _0x159092=[];if(_0x11ff3c){for(var _0x5b94f3=0x0;_0x5b94f3<_0x11ff3c[_0x90e6('0x32')];_0x5b94f3+=0x1){var _0x4b1516=_0x11ff3c[_0x5b94f3][_0x90e6('0x22')]({'plain':!![]});_0x56859f=squel['insert']()['into'](_0x90e6('0x83'))[_0x90e6('0x68')](['phone',_0x90e6('0x6b'),_0x90e6('0x6f'),_0x90e6('0x59'),'createdAt',_0x90e6('0x53')],squel[_0x90e6('0x7b')]()[_0x90e6('0x6c')](_0x90e6('0x69'),_0x90e6('0x69'))[_0x90e6('0x6c')]('id',_0x90e6('0x6b'))[_0x90e6('0x6c')](_0x4b1516[_0x90e6('0x72')]['toString'](),_0x90e6('0x6f'))[_0x90e6('0x6c')](_0x2f1886['params']['id'][_0x90e6('0x6e')](),'CampaignId')[_0x90e6('0x6c')](_0x90e6('0x6d'),'createdAt')['field']('NOW()',_0x90e6('0x53'))[_0x90e6('0x70')](_0x90e6('0x7c'))['where'](_0x90e6('0x7d'))[_0x90e6('0x38')](_0x90e6('0x71'),_0x4b1516[_0x90e6('0x72')][_0x90e6('0x6e')]())['where'](_0x90e6('0x73')))['toString']();_0x159092[_0x90e6('0x84')](db[_0x90e6('0x7e')]['query'](_0x56859f));}return BPromise['all'](_0x159092);}})['then'](function(){return _0x1acd33;})['then'](respondWithResult(_0x1812ac,null))[_0x90e6('0x4f')](handleError(_0x1812ac,null));};exports[_0x90e6('0x85')]=function(_0x40095a,_0x5cf531,_0x48a566){return db['Campaign']['find']({'where':{'id':_0x40095a[_0x90e6('0x44')]['id']}})[_0x90e6('0x20')](handleEntityNotFound(_0x5cf531,null))[_0x90e6('0x20')](function(_0x110291){if(_0x110291){return _0x110291[_0x90e6('0x85')](_0x40095a[_0x90e6('0x2e')][_0x90e6('0x62')]);}})[_0x90e6('0x20')](function(_0xfdbebe){if(_0xfdbebe){return db['CmHopperBlack'][_0x90e6('0x21')]({'where':{'ListId':_0x40095a[_0x90e6('0x2e')][_0x90e6('0x62')],'CampaignId':_0x40095a['params']['id']}})['then'](function(){return _0xfdbebe;});}})[_0x90e6('0x20')](respondWithStatusCode(_0x5cf531,null))[_0x90e6('0x4f')](handleError(_0x5cf531,null));};
\ No newline at end of file
+var _0xa9e0=['NOW()','scheduledAt','ContactId','CmListId','toString','from','deletedAt\x20IS\x20NULL','COALESCE(calleridnum,\x27\x27)','cm_hopper_final','CampaignId\x20=\x20?','onlyIfOpen','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','COALESCE(phone,\x27\x27)','cm_contacts','push','sequelize','removeLists','getBlackLists','addBlackLists','cm_hopper_black','removeBlackLists','html-pdf','eml-format','rimraf','request-promise','bluebird','mustache','util','path','sox','ejs','lodash','squel','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/license/util','../../mysqldb','sendStatus','end','status','json','offset','limit','set','Content-Range','apply','reject','save','update','destroy','then','IvrCampaigns','UserProfileResource','stack','name','send','index','map','Campaign','rawAttributes','fieldName','type','key','model','query','keys','intersection','attributes','fields','length','hasOwnProperty','order','sort','filters','filter','merge','where','VIRTUAL','count','include','findAll','rows','catch','show','params','includeAll','options','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','get','UserProfileSection','find','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','omit','updatedAt','createdAt','autoAssociation','getHoppers','findOne','CmHopper','nolimit','pick','CampaignId','getHopperHistories','CmHopperHistory','getHopperFinals','CmHopperFinal','getHopperBlacks','CmHopperBlack','getLists','CmList','addLists','ids','spread','dialCheckDuplicateType','insert','into','cm_hopper','fromQuery','phone','ListId','select','field'];(function(_0x3b6163,_0x421554){var _0x5e0619=function(_0x4f48dd){while(--_0x4f48dd){_0x3b6163['push'](_0x3b6163['shift']());}};_0x5e0619(++_0x421554);}(_0xa9e0,0x123));var _0x0a9e=function(_0x92c450,_0x41f1e3){_0x92c450=_0x92c450-0x0;var _0x2a9599=_0xa9e0[_0x92c450];return _0x2a9599;};'use strict';var pdf=require(_0x0a9e('0x0'));var emlformat=require(_0x0a9e('0x1'));var rimraf=require(_0x0a9e('0x2'));var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require(_0x0a9e('0x3'));var moment=require('moment');var BPromise=require(_0x0a9e('0x4'));var Mustache=require(_0x0a9e('0x5'));var util=require(_0x0a9e('0x6'));var path=require(_0x0a9e('0x7'));var sox=require(_0x0a9e('0x8'));var csv=require('to-csv');var ejs=require(_0x0a9e('0x9'));var fs=require('fs');var _=require(_0x0a9e('0xa'));var squel=require(_0x0a9e('0xb'));var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require(_0x0a9e('0xc'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0x0a9e('0xd'));var Redis=require(_0x0a9e('0xe'));var authService=require(_0x0a9e('0xf'));var qs=require(_0x0a9e('0x10'));var as=require(_0x0a9e('0x11'));var hardwareService=require(_0x0a9e('0x12'));var logger=require('../../config/logger')('api');var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require(_0x0a9e('0x13'));var db=require(_0x0a9e('0x14'))['db'];function respondWithStatusCode(_0xd5b662,_0x26d672){_0x26d672=_0x26d672||0xcc;return function(_0x32d742){if(_0x32d742){return _0xd5b662[_0x0a9e('0x15')](_0x26d672);}return _0xd5b662['status'](_0x26d672)[_0x0a9e('0x16')]();};}function respondWithResult(_0x239b12,_0x2b4227){_0x2b4227=_0x2b4227||0xc8;return function(_0x281129){if(_0x281129){return _0x239b12[_0x0a9e('0x17')](_0x2b4227)[_0x0a9e('0x18')](_0x281129);}};}function respondWithFilteredResult(_0x52a03d,_0x22dccb){return function(_0x5d0880){if(_0x5d0880){var _0x1985b6=_0x5d0880['count'],_0x519dfd=_0x22dccb[_0x0a9e('0x19')],_0x16033c=_0x22dccb['offset']+_0x22dccb[_0x0a9e('0x1a')],_0x12066b;if(_0x16033c>=_0x1985b6){_0x16033c=_0x1985b6;_0x12066b=0xc8;}else{_0x12066b=0xce;}_0x52a03d[_0x0a9e('0x17')](_0x12066b);return _0x52a03d[_0x0a9e('0x1b')](_0x0a9e('0x1c'),_0x519dfd+'-'+_0x16033c+'/'+_0x1985b6)[_0x0a9e('0x18')](_0x5d0880);}return null;};}function patchUpdates(_0x2eb11f){return function(_0x530eb7){try{jsonpatch[_0x0a9e('0x1d')](_0x530eb7,_0x2eb11f,!![]);}catch(_0x1314ae){return BPromise[_0x0a9e('0x1e')](_0x1314ae);}return _0x530eb7[_0x0a9e('0x1f')]();};}function saveUpdates(_0x105080,_0x4bb1e3){return function(_0x2c3407){if(_0x2c3407){return _0x2c3407[_0x0a9e('0x20')](_0x105080)['then'](function(_0x20f109){return _0x20f109;});}return null;};}function removeEntity(_0x5a09ef,_0x588269){return function(_0x3a02e1){if(_0x3a02e1){return _0x3a02e1[_0x0a9e('0x21')]()[_0x0a9e('0x22')](function(){var _0x30bae6=_0x3a02e1['get']({'plain':!![]});var _0xfb6e48=_0x0a9e('0x23');return db[_0x0a9e('0x24')][_0x0a9e('0x21')]({'where':{'type':_0xfb6e48,'resourceId':_0x30bae6['id']}})[_0x0a9e('0x22')](function(){return _0x3a02e1;});})[_0x0a9e('0x22')](function(){_0x5a09ef[_0x0a9e('0x17')](0xcc)['end']();});}};}function handleEntityNotFound(_0x59181e,_0x197ec0){return function(_0x3a8e58){if(!_0x3a8e58){_0x59181e[_0x0a9e('0x15')](0x194);}return _0x3a8e58;};}function handleError(_0x33161b,_0x526cf3){_0x526cf3=_0x526cf3||0x1f4;return function(_0x384319){logger['error'](_0x384319[_0x0a9e('0x25')]);if(_0x384319['name']){delete _0x384319[_0x0a9e('0x26')];}_0x33161b[_0x0a9e('0x17')](_0x526cf3)[_0x0a9e('0x27')](_0x384319);};}exports[_0x0a9e('0x28')]=function(_0x140511,_0x1538a4){var _0x11c3b6={},_0x14de77={},_0x5a101a={'count':0x0,'rows':[]};var _0x3652a7=_[_0x0a9e('0x29')](db[_0x0a9e('0x2a')][_0x0a9e('0x2b')],function(_0x5c877d){return{'name':_0x5c877d[_0x0a9e('0x2c')],'type':_0x5c877d[_0x0a9e('0x2d')][_0x0a9e('0x2e')]};});_0x14de77[_0x0a9e('0x2f')]=_[_0x0a9e('0x29')](_0x3652a7,_0x0a9e('0x26'));_0x14de77[_0x0a9e('0x30')]=_[_0x0a9e('0x31')](_0x140511[_0x0a9e('0x30')]);_0x14de77['filters']=_[_0x0a9e('0x32')](_0x14de77['model'],_0x14de77[_0x0a9e('0x30')]);_0x11c3b6[_0x0a9e('0x33')]=_[_0x0a9e('0x32')](_0x14de77[_0x0a9e('0x2f')],qs[_0x0a9e('0x34')](_0x140511['query'][_0x0a9e('0x34')]));_0x11c3b6[_0x0a9e('0x33')]=_0x11c3b6[_0x0a9e('0x33')][_0x0a9e('0x35')]?_0x11c3b6[_0x0a9e('0x33')]:_0x14de77[_0x0a9e('0x2f')];if(!_0x140511[_0x0a9e('0x30')][_0x0a9e('0x36')]('nolimit')){_0x11c3b6[_0x0a9e('0x1a')]=qs['limit'](_0x140511[_0x0a9e('0x30')][_0x0a9e('0x1a')]);_0x11c3b6[_0x0a9e('0x19')]=qs[_0x0a9e('0x19')](_0x140511['query'][_0x0a9e('0x19')]);}_0x11c3b6[_0x0a9e('0x37')]=qs[_0x0a9e('0x38')](_0x140511[_0x0a9e('0x30')]['sort']);_0x11c3b6['where']=qs[_0x0a9e('0x39')](_['pick'](_0x140511[_0x0a9e('0x30')],_0x14de77[_0x0a9e('0x39')]),_0x3652a7);if(_0x140511[_0x0a9e('0x30')][_0x0a9e('0x3a')]){_0x11c3b6['where']=_[_0x0a9e('0x3b')](_0x11c3b6[_0x0a9e('0x3c')],{'$or':_[_0x0a9e('0x29')](_0x3652a7,function(_0x533942){if(_0x533942[_0x0a9e('0x2d')]!==_0x0a9e('0x3d')){var _0x289467={};_0x289467[_0x533942['name']]={'$like':'%'+_0x140511['query'][_0x0a9e('0x3a')]+'%'};return _0x289467;}})});}_0x11c3b6=_[_0x0a9e('0x3b')]({},_0x11c3b6,_0x140511['options']);var _0x2b814e={'where':_0x11c3b6[_0x0a9e('0x3c')]};return db[_0x0a9e('0x2a')][_0x0a9e('0x3e')](_0x2b814e)['then'](function(_0x5a594b){_0x5a101a[_0x0a9e('0x3e')]=_0x5a594b;if(_0x140511[_0x0a9e('0x30')]['includeAll']){_0x11c3b6[_0x0a9e('0x3f')]=[{'all':!![]}];}return db[_0x0a9e('0x2a')][_0x0a9e('0x40')](_0x11c3b6);})['then'](function(_0x316c8f){_0x5a101a[_0x0a9e('0x41')]=_0x316c8f;return _0x5a101a;})[_0x0a9e('0x22')](respondWithFilteredResult(_0x1538a4,_0x11c3b6))[_0x0a9e('0x42')](handleError(_0x1538a4,null));};exports[_0x0a9e('0x43')]=function(_0xeaa5e5,_0x2881b3){var _0x45a9b8={'raw':![],'where':{'id':_0xeaa5e5[_0x0a9e('0x44')]['id']}},_0x23b089={};_0x23b089[_0x0a9e('0x2f')]=_[_0x0a9e('0x31')](db[_0x0a9e('0x2a')][_0x0a9e('0x2b')]);_0x23b089[_0x0a9e('0x30')]=_['keys'](_0xeaa5e5['query']);_0x23b089[_0x0a9e('0x39')]=_[_0x0a9e('0x32')](_0x23b089[_0x0a9e('0x2f')],_0x23b089[_0x0a9e('0x30')]);_0x45a9b8[_0x0a9e('0x33')]=_[_0x0a9e('0x32')](_0x23b089[_0x0a9e('0x2f')],qs[_0x0a9e('0x34')](_0xeaa5e5[_0x0a9e('0x30')][_0x0a9e('0x34')]));_0x45a9b8[_0x0a9e('0x33')]=_0x45a9b8[_0x0a9e('0x33')]['length']?_0x45a9b8[_0x0a9e('0x33')]:_0x23b089[_0x0a9e('0x2f')];if(_0xeaa5e5[_0x0a9e('0x30')][_0x0a9e('0x45')]){_0x45a9b8[_0x0a9e('0x3f')]=[{'all':!![]}];}_0x45a9b8=_[_0x0a9e('0x3b')]({},_0x45a9b8,_0xeaa5e5[_0x0a9e('0x46')]);return db[_0x0a9e('0x2a')]['find'](_0x45a9b8)[_0x0a9e('0x22')](handleEntityNotFound(_0x2881b3,null))['then'](respondWithResult(_0x2881b3,null))[_0x0a9e('0x42')](handleError(_0x2881b3,null));};exports[_0x0a9e('0x47')]=function(_0x8d6dd1,_0x562fb4){return db[_0x0a9e('0x2a')][_0x0a9e('0x47')](_0x8d6dd1[_0x0a9e('0x48')],{})[_0x0a9e('0x22')](function(_0x45c845){var _0x37be73=_0x8d6dd1[_0x0a9e('0x49')]['get']({'plain':!![]});if(!_0x37be73)throw new Error(_0x0a9e('0x4a'));if(_0x37be73[_0x0a9e('0x4b')]===_0x0a9e('0x49')){var _0x16f976=_0x45c845[_0x0a9e('0x4c')]({'plain':!![]});var _0x992c77=_0x0a9e('0x23');return db[_0x0a9e('0x4d')][_0x0a9e('0x4e')]({'where':{'name':_0x992c77,'userProfileId':_0x37be73['userProfileId']},'raw':!![]})[_0x0a9e('0x22')](function(_0x3fe430){if(_0x3fe430&&_0x3fe430['autoAssociation']===0x0){return db['UserProfileResource']['create']({'name':_0x16f976[_0x0a9e('0x26')],'resourceId':_0x16f976['id'],'type':_0x3fe430[_0x0a9e('0x26')],'sectionId':_0x3fe430['id']},{})[_0x0a9e('0x22')](function(){return _0x45c845;});}else{return _0x45c845;}})[_0x0a9e('0x42')](function(_0x61bb17){logger[_0x0a9e('0x4f')](_0x0a9e('0x50'),_0x61bb17);throw _0x61bb17;});}return _0x45c845;})[_0x0a9e('0x22')](respondWithResult(_0x562fb4,0xc9))['catch'](handleError(_0x562fb4,null));};exports['clone']=function(_0x53975a,_0x39d77d){var _0x204173={'where':{'id':_0x53975a['params']['id']}},_0x14d602={};_0x14d602[_0x0a9e('0x2f')]=_[_0x0a9e('0x31')](db['Campaign']['rawAttributes']);_0x204173[_0x0a9e('0x33')]=_['intersection'](_0x14d602[_0x0a9e('0x2f')],qs['fields'](_0x53975a[_0x0a9e('0x30')][_0x0a9e('0x34')]));_0x204173[_0x0a9e('0x33')]=_0x204173['attributes'][_0x0a9e('0x35')]?_0x204173[_0x0a9e('0x33')]:_0x14d602['model'];if(_0x53975a['query'][_0x0a9e('0x45')]){_0x204173[_0x0a9e('0x3f')]=[{'all':!![]}];}_0x204173=_['merge']({},_0x204173,_0x53975a[_0x0a9e('0x46')]);return db['Campaign'][_0x0a9e('0x4e')](_0x204173)['then'](handleEntityNotFound(_0x39d77d,null))[_0x0a9e('0x22')](function(_0x4a6deb){if(_0x4a6deb){var _0x5da27d=_0x4a6deb['get']({'plain':!![]});_0x5da27d=qs[_0x0a9e('0x51')](_0x5da27d,['id','createdAt',_0x0a9e('0x52')]);_0x53975a[_0x0a9e('0x48')]=_[_0x0a9e('0x51')](_0x53975a[_0x0a9e('0x48')],['id',_0x0a9e('0x53'),_0x0a9e('0x52')]);return db[_0x0a9e('0x2a')][_0x0a9e('0x47')](_['merge'](_0x5da27d,_0x53975a[_0x0a9e('0x48')]),{'include':_0x53975a[_0x0a9e('0x30')][_0x0a9e('0x45')]?[{'all':!![]}]:undefined})[_0x0a9e('0x22')](function(_0xb83dfd){var _0x156662=_0x53975a['user'][_0x0a9e('0x4c')]({'plain':!![]});if(!_0x156662)throw new Error(_0x0a9e('0x4a'));if(_0x156662['role']===_0x0a9e('0x49')){var _0x5cc8fb=_0xb83dfd[_0x0a9e('0x4c')]({'plain':!![]});var _0x5ba1f9='IvrCampaigns';return db['UserProfileSection'][_0x0a9e('0x4e')]({'where':{'name':_0x5ba1f9,'userProfileId':_0x156662['userProfileId']},'raw':!![]})[_0x0a9e('0x22')](function(_0x1fc70e){if(_0x1fc70e&&_0x1fc70e[_0x0a9e('0x54')]===0x0){return db[_0x0a9e('0x24')][_0x0a9e('0x47')]({'name':_0x5cc8fb[_0x0a9e('0x26')],'resourceId':_0x5cc8fb['id'],'type':_0x1fc70e['name'],'sectionId':_0x1fc70e['id']},{})[_0x0a9e('0x22')](function(){return _0xb83dfd;});}else{return _0xb83dfd;}})['catch'](function(_0xca4ade){logger[_0x0a9e('0x4f')](_0x0a9e('0x50'),_0xca4ade);throw _0xca4ade;});}return _0xb83dfd;});}})['then'](respondWithResult(_0x39d77d,0xc9))[_0x0a9e('0x42')](handleError(_0x39d77d,null));};exports[_0x0a9e('0x20')]=function(_0x119677,_0x32e134){if(_0x119677['body']['id']){delete _0x119677[_0x0a9e('0x48')]['id'];}return db[_0x0a9e('0x2a')]['find']({'where':{'id':_0x119677[_0x0a9e('0x44')]['id']}})[_0x0a9e('0x22')](handleEntityNotFound(_0x32e134,null))[_0x0a9e('0x22')](saveUpdates(_0x119677[_0x0a9e('0x48')],null))[_0x0a9e('0x22')](respondWithResult(_0x32e134,null))['catch'](handleError(_0x32e134,null));};exports[_0x0a9e('0x21')]=function(_0x2937e0,_0x281c7d){return db['Campaign'][_0x0a9e('0x4e')]({'where':{'id':_0x2937e0['params']['id']}})['then'](handleEntityNotFound(_0x281c7d,null))[_0x0a9e('0x22')](removeEntity(_0x281c7d,null))[_0x0a9e('0x42')](handleError(_0x281c7d,null));};exports[_0x0a9e('0x55')]=function(_0x19c995,_0x186f39,_0xc8c264){var _0x387489={'raw':!![],'where':{}};var _0x54a37d={};var _0x2d7205={'count':0x0,'rows':[]};return db[_0x0a9e('0x2a')][_0x0a9e('0x56')]({'where':{'id':_0x19c995[_0x0a9e('0x44')]['id']}})[_0x0a9e('0x22')](handleEntityNotFound(_0x186f39,null))[_0x0a9e('0x22')](function(_0x320898){if(_0x320898){_0x54a37d[_0x0a9e('0x2f')]=_[_0x0a9e('0x31')](db[_0x0a9e('0x57')]['rawAttributes']);_0x54a37d[_0x0a9e('0x30')]=_[_0x0a9e('0x31')](_0x19c995[_0x0a9e('0x30')]);_0x54a37d['filters']=_[_0x0a9e('0x32')](_0x54a37d[_0x0a9e('0x2f')],_0x54a37d['query']);_0x387489[_0x0a9e('0x33')]=_[_0x0a9e('0x32')](_0x54a37d[_0x0a9e('0x2f')],qs[_0x0a9e('0x34')](_0x19c995[_0x0a9e('0x30')]['fields']));_0x387489['attributes']=_0x387489['attributes'][_0x0a9e('0x35')]?_0x387489[_0x0a9e('0x33')]:_0x54a37d[_0x0a9e('0x2f')];if(!_0x19c995[_0x0a9e('0x30')][_0x0a9e('0x36')](_0x0a9e('0x58'))){_0x387489[_0x0a9e('0x1a')]=qs[_0x0a9e('0x1a')](_0x19c995['query'][_0x0a9e('0x1a')]);_0x387489[_0x0a9e('0x19')]=qs[_0x0a9e('0x19')](_0x19c995['query'][_0x0a9e('0x19')]);}_0x387489['order']=qs[_0x0a9e('0x38')](_0x19c995[_0x0a9e('0x30')]['sort']);_0x387489[_0x0a9e('0x3c')]=qs[_0x0a9e('0x39')](_[_0x0a9e('0x59')](_0x19c995[_0x0a9e('0x30')],_0x54a37d['filters']));_0x387489[_0x0a9e('0x3c')][_0x0a9e('0x5a')]=_0x320898['id'];if(_0x19c995[_0x0a9e('0x30')][_0x0a9e('0x3a')]){_0x387489['where']=_[_0x0a9e('0x3b')](_0x387489[_0x0a9e('0x3c')],{'$or':_[_0x0a9e('0x29')](_0x387489[_0x0a9e('0x33')],function(_0x4abc8f){var _0x290d43={};_0x290d43[_0x4abc8f]={'$like':'%'+_0x19c995[_0x0a9e('0x30')][_0x0a9e('0x3a')]+'%'};return _0x290d43;})});}_0x387489=_[_0x0a9e('0x3b')]({},_0x387489,_0x19c995[_0x0a9e('0x46')]);return db[_0x0a9e('0x57')][_0x0a9e('0x3e')]({'where':_0x387489[_0x0a9e('0x3c')]})[_0x0a9e('0x22')](function(_0x336dc3){_0x2d7205[_0x0a9e('0x3e')]=_0x336dc3;if(_0x19c995[_0x0a9e('0x30')][_0x0a9e('0x45')]){_0x387489[_0x0a9e('0x3f')]=[{'all':!![]}];}return db['CmHopper'][_0x0a9e('0x40')](_0x387489);})[_0x0a9e('0x22')](function(_0xc599b3){_0x2d7205['rows']=_0xc599b3;return _0x2d7205;});}})[_0x0a9e('0x22')](respondWithFilteredResult(_0x186f39,_0x387489))[_0x0a9e('0x42')](handleError(_0x186f39,null));};exports[_0x0a9e('0x5b')]=function(_0x2b9463,_0x56d650,_0x541e80){var _0x7ebea8={'raw':!![],'where':{}};var _0x2bbdb5={};var _0x4c54fa={'count':0x0,'rows':[]};return db[_0x0a9e('0x2a')]['findOne']({'where':{'id':_0x2b9463[_0x0a9e('0x44')]['id']}})[_0x0a9e('0x22')](handleEntityNotFound(_0x56d650,null))['then'](function(_0x28a942){if(_0x28a942){_0x2bbdb5[_0x0a9e('0x2f')]=_[_0x0a9e('0x31')](db[_0x0a9e('0x5c')][_0x0a9e('0x2b')]);_0x2bbdb5[_0x0a9e('0x30')]=_[_0x0a9e('0x31')](_0x2b9463['query']);_0x2bbdb5[_0x0a9e('0x39')]=_[_0x0a9e('0x32')](_0x2bbdb5[_0x0a9e('0x2f')],_0x2bbdb5[_0x0a9e('0x30')]);_0x7ebea8['attributes']=_[_0x0a9e('0x32')](_0x2bbdb5[_0x0a9e('0x2f')],qs['fields'](_0x2b9463[_0x0a9e('0x30')]['fields']));_0x7ebea8[_0x0a9e('0x33')]=_0x7ebea8[_0x0a9e('0x33')][_0x0a9e('0x35')]?_0x7ebea8[_0x0a9e('0x33')]:_0x2bbdb5['model'];if(!_0x2b9463['query'][_0x0a9e('0x36')](_0x0a9e('0x58'))){_0x7ebea8[_0x0a9e('0x1a')]=qs['limit'](_0x2b9463[_0x0a9e('0x30')][_0x0a9e('0x1a')]);_0x7ebea8['offset']=qs['offset'](_0x2b9463[_0x0a9e('0x30')]['offset']);}_0x7ebea8['order']=qs['sort'](_0x2b9463[_0x0a9e('0x30')][_0x0a9e('0x38')]);_0x7ebea8[_0x0a9e('0x3c')]=qs[_0x0a9e('0x39')](_[_0x0a9e('0x59')](_0x2b9463[_0x0a9e('0x30')],_0x2bbdb5['filters']));_0x7ebea8[_0x0a9e('0x3c')]['CampaignId']=_0x28a942['id'];if(_0x2b9463[_0x0a9e('0x30')][_0x0a9e('0x3a')]){_0x7ebea8[_0x0a9e('0x3c')]=_[_0x0a9e('0x3b')](_0x7ebea8['where'],{'$or':_[_0x0a9e('0x29')](_0x7ebea8[_0x0a9e('0x33')],function(_0x1d4877){var _0x5b74c3={};_0x5b74c3[_0x1d4877]={'$like':'%'+_0x2b9463[_0x0a9e('0x30')][_0x0a9e('0x3a')]+'%'};return _0x5b74c3;})});}_0x7ebea8=_[_0x0a9e('0x3b')]({},_0x7ebea8,_0x2b9463[_0x0a9e('0x46')]);return db[_0x0a9e('0x5c')][_0x0a9e('0x3e')]({'where':_0x7ebea8[_0x0a9e('0x3c')]})[_0x0a9e('0x22')](function(_0x509efe){_0x4c54fa[_0x0a9e('0x3e')]=_0x509efe;if(_0x2b9463[_0x0a9e('0x30')]['includeAll']){_0x7ebea8[_0x0a9e('0x3f')]=[{'all':!![]}];}return db[_0x0a9e('0x5c')][_0x0a9e('0x40')](_0x7ebea8);})['then'](function(_0x96672f){_0x4c54fa['rows']=_0x96672f;return _0x4c54fa;});}})[_0x0a9e('0x22')](respondWithFilteredResult(_0x56d650,_0x7ebea8))[_0x0a9e('0x42')](handleError(_0x56d650,null));};exports[_0x0a9e('0x5d')]=function(_0x1f29bd,_0x842d6f,_0x16341a){var _0x16a039={'raw':!![],'where':{}};var _0x3a9a85={};var _0x501050={'count':0x0,'rows':[]};return db[_0x0a9e('0x2a')][_0x0a9e('0x56')]({'where':{'id':_0x1f29bd[_0x0a9e('0x44')]['id']}})[_0x0a9e('0x22')](handleEntityNotFound(_0x842d6f,null))[_0x0a9e('0x22')](function(_0x3df9e4){if(_0x3df9e4){_0x3a9a85[_0x0a9e('0x2f')]=_[_0x0a9e('0x31')](db[_0x0a9e('0x5e')][_0x0a9e('0x2b')]);_0x3a9a85[_0x0a9e('0x30')]=_[_0x0a9e('0x31')](_0x1f29bd[_0x0a9e('0x30')]);_0x3a9a85['filters']=_[_0x0a9e('0x32')](_0x3a9a85[_0x0a9e('0x2f')],_0x3a9a85[_0x0a9e('0x30')]);_0x16a039[_0x0a9e('0x33')]=_[_0x0a9e('0x32')](_0x3a9a85['model'],qs[_0x0a9e('0x34')](_0x1f29bd[_0x0a9e('0x30')]['fields']));_0x16a039[_0x0a9e('0x33')]=_0x16a039['attributes'][_0x0a9e('0x35')]?_0x16a039[_0x0a9e('0x33')]:_0x3a9a85[_0x0a9e('0x2f')];if(!_0x1f29bd[_0x0a9e('0x30')]['hasOwnProperty'](_0x0a9e('0x58'))){_0x16a039['limit']=qs[_0x0a9e('0x1a')](_0x1f29bd[_0x0a9e('0x30')]['limit']);_0x16a039[_0x0a9e('0x19')]=qs[_0x0a9e('0x19')](_0x1f29bd[_0x0a9e('0x30')]['offset']);}_0x16a039['order']=qs[_0x0a9e('0x38')](_0x1f29bd[_0x0a9e('0x30')][_0x0a9e('0x38')]);_0x16a039[_0x0a9e('0x3c')]=qs[_0x0a9e('0x39')](_[_0x0a9e('0x59')](_0x1f29bd[_0x0a9e('0x30')],_0x3a9a85[_0x0a9e('0x39')]));_0x16a039[_0x0a9e('0x3c')]['CampaignId']=_0x3df9e4['id'];if(_0x1f29bd[_0x0a9e('0x30')]['filter']){_0x16a039[_0x0a9e('0x3c')]=_[_0x0a9e('0x3b')](_0x16a039[_0x0a9e('0x3c')],{'$or':_[_0x0a9e('0x29')](_0x16a039[_0x0a9e('0x33')],function(_0x4e7273){var _0x436313={};_0x436313[_0x4e7273]={'$like':'%'+_0x1f29bd[_0x0a9e('0x30')][_0x0a9e('0x3a')]+'%'};return _0x436313;})});}_0x16a039=_[_0x0a9e('0x3b')]({},_0x16a039,_0x1f29bd[_0x0a9e('0x46')]);return db['CmHopperFinal']['count']({'where':_0x16a039[_0x0a9e('0x3c')]})['then'](function(_0x25eae0){_0x501050[_0x0a9e('0x3e')]=_0x25eae0;if(_0x1f29bd[_0x0a9e('0x30')][_0x0a9e('0x45')]){_0x16a039[_0x0a9e('0x3f')]=[{'all':!![]}];}return db[_0x0a9e('0x5e')]['findAll'](_0x16a039);})['then'](function(_0x1889ed){_0x501050['rows']=_0x1889ed;return _0x501050;});}})[_0x0a9e('0x22')](respondWithFilteredResult(_0x842d6f,_0x16a039))['catch'](handleError(_0x842d6f,null));};exports[_0x0a9e('0x5f')]=function(_0x564db2,_0x558d60,_0x1c49dc){var _0xb8db59={'raw':!![],'where':{}};var _0x5e9b0b={};var _0x170af6={'count':0x0,'rows':[]};return db[_0x0a9e('0x2a')][_0x0a9e('0x56')]({'where':{'id':_0x564db2[_0x0a9e('0x44')]['id']}})[_0x0a9e('0x22')](handleEntityNotFound(_0x558d60,null))['then'](function(_0x5505f4){if(_0x5505f4){_0x5e9b0b[_0x0a9e('0x2f')]=_[_0x0a9e('0x31')](db[_0x0a9e('0x60')][_0x0a9e('0x2b')]);_0x5e9b0b[_0x0a9e('0x30')]=_['keys'](_0x564db2[_0x0a9e('0x30')]);_0x5e9b0b[_0x0a9e('0x39')]=_['intersection'](_0x5e9b0b[_0x0a9e('0x2f')],_0x5e9b0b[_0x0a9e('0x30')]);_0xb8db59[_0x0a9e('0x33')]=_[_0x0a9e('0x32')](_0x5e9b0b[_0x0a9e('0x2f')],qs[_0x0a9e('0x34')](_0x564db2[_0x0a9e('0x30')][_0x0a9e('0x34')]));_0xb8db59[_0x0a9e('0x33')]=_0xb8db59[_0x0a9e('0x33')]['length']?_0xb8db59[_0x0a9e('0x33')]:_0x5e9b0b[_0x0a9e('0x2f')];if(!_0x564db2[_0x0a9e('0x30')][_0x0a9e('0x36')](_0x0a9e('0x58'))){_0xb8db59['limit']=qs['limit'](_0x564db2[_0x0a9e('0x30')][_0x0a9e('0x1a')]);_0xb8db59[_0x0a9e('0x19')]=qs[_0x0a9e('0x19')](_0x564db2[_0x0a9e('0x30')]['offset']);}_0xb8db59[_0x0a9e('0x37')]=qs[_0x0a9e('0x38')](_0x564db2[_0x0a9e('0x30')]['sort']);_0xb8db59[_0x0a9e('0x3c')]=qs['filters'](_[_0x0a9e('0x59')](_0x564db2['query'],_0x5e9b0b[_0x0a9e('0x39')]));_0xb8db59[_0x0a9e('0x3c')][_0x0a9e('0x5a')]=_0x5505f4['id'];if(_0x564db2['query'][_0x0a9e('0x3a')]){_0xb8db59['where']=_[_0x0a9e('0x3b')](_0xb8db59[_0x0a9e('0x3c')],{'$or':_[_0x0a9e('0x29')](_0xb8db59[_0x0a9e('0x33')],function(_0x3a5836){var _0x1bee04={};_0x1bee04[_0x3a5836]={'$like':'%'+_0x564db2[_0x0a9e('0x30')][_0x0a9e('0x3a')]+'%'};return _0x1bee04;})});}_0xb8db59=_[_0x0a9e('0x3b')]({},_0xb8db59,_0x564db2[_0x0a9e('0x46')]);return db[_0x0a9e('0x60')][_0x0a9e('0x3e')]({'where':_0xb8db59[_0x0a9e('0x3c')]})[_0x0a9e('0x22')](function(_0x98c62c){_0x170af6[_0x0a9e('0x3e')]=_0x98c62c;if(_0x564db2['query']['includeAll']){_0xb8db59[_0x0a9e('0x3f')]=[{'all':!![]}];}return db['CmHopperBlack'][_0x0a9e('0x40')](_0xb8db59);})[_0x0a9e('0x22')](function(_0x5d6b69){_0x170af6[_0x0a9e('0x41')]=_0x5d6b69;return _0x170af6;});}})[_0x0a9e('0x22')](respondWithFilteredResult(_0x558d60,_0xb8db59))[_0x0a9e('0x42')](handleError(_0x558d60,null));};exports[_0x0a9e('0x61')]=function(_0x5585d5,_0x148fd9,_0x26cb76){var _0x374f0b={};var _0x34a791={};var _0x5d0e1f;var _0x19e9ed;return db[_0x0a9e('0x2a')][_0x0a9e('0x56')]({'where':{'id':_0x5585d5['params']['id']}})[_0x0a9e('0x22')](handleEntityNotFound(_0x148fd9,null))[_0x0a9e('0x22')](function(_0x17b29d){if(_0x17b29d){_0x5d0e1f=_0x17b29d;_0x34a791['model']=_[_0x0a9e('0x31')](db[_0x0a9e('0x62')][_0x0a9e('0x2b')]);_0x34a791[_0x0a9e('0x30')]=_[_0x0a9e('0x31')](_0x5585d5['query']);_0x34a791[_0x0a9e('0x39')]=_[_0x0a9e('0x32')](_0x34a791['model'],_0x34a791[_0x0a9e('0x30')]);_0x374f0b[_0x0a9e('0x33')]=_[_0x0a9e('0x32')](_0x34a791['model'],qs['fields'](_0x5585d5['query'][_0x0a9e('0x34')]));_0x374f0b[_0x0a9e('0x33')]=_0x374f0b['attributes'][_0x0a9e('0x35')]?_0x374f0b[_0x0a9e('0x33')]:_0x34a791[_0x0a9e('0x2f')];_0x374f0b['order']=qs[_0x0a9e('0x38')](_0x5585d5[_0x0a9e('0x30')][_0x0a9e('0x38')]);_0x374f0b[_0x0a9e('0x3c')]=qs[_0x0a9e('0x39')](_[_0x0a9e('0x59')](_0x5585d5[_0x0a9e('0x30')],_0x34a791[_0x0a9e('0x39')]));if(_0x5585d5[_0x0a9e('0x30')]['filter']){_0x374f0b[_0x0a9e('0x3c')]=_['merge'](_0x374f0b[_0x0a9e('0x3c')],{'$or':_[_0x0a9e('0x29')](_0x374f0b[_0x0a9e('0x33')],function(_0x3cf222){var _0x407e9d={};_0x407e9d[_0x3cf222]={'$like':'%'+_0x5585d5[_0x0a9e('0x30')]['filter']+'%'};return _0x407e9d;})});}_0x374f0b=_[_0x0a9e('0x3b')]({},_0x374f0b,_0x5585d5[_0x0a9e('0x46')]);return _0x5d0e1f[_0x0a9e('0x61')](_0x374f0b);}})[_0x0a9e('0x22')](function(_0x51aa2f){if(_0x51aa2f){_0x19e9ed=_0x51aa2f[_0x0a9e('0x35')];if(!_0x5585d5[_0x0a9e('0x30')][_0x0a9e('0x36')](_0x0a9e('0x58'))){_0x374f0b[_0x0a9e('0x1a')]=qs[_0x0a9e('0x1a')](_0x5585d5[_0x0a9e('0x30')][_0x0a9e('0x1a')]);_0x374f0b[_0x0a9e('0x19')]=qs[_0x0a9e('0x19')](_0x5585d5['query'][_0x0a9e('0x19')]);}return _0x5d0e1f[_0x0a9e('0x61')](_0x374f0b);}})[_0x0a9e('0x22')](function(_0x26b826){if(_0x26b826){return _0x26b826?{'count':_0x19e9ed,'rows':_0x26b826}:null;}})[_0x0a9e('0x22')](respondWithResult(_0x148fd9,null))[_0x0a9e('0x42')](handleError(_0x148fd9,null));};exports[_0x0a9e('0x63')]=function(_0x20ae21,_0x566b90,_0x3b581c){var _0xd2391,_0x1a9ef1;return db['Campaign'][_0x0a9e('0x4e')]({'where':{'id':_0x20ae21[_0x0a9e('0x44')]['id']}})[_0x0a9e('0x22')](handleEntityNotFound(_0x566b90,null))[_0x0a9e('0x22')](function(_0x370b5e){if(_0x370b5e){_0x1a9ef1=_0x370b5e;return _0x370b5e[_0x0a9e('0x63')](_0x20ae21[_0x0a9e('0x48')][_0x0a9e('0x64')],_[_0x0a9e('0x51')](_0x20ae21[_0x0a9e('0x48')],['ids','id'])||{});}return null;})[_0x0a9e('0x65')](function(_0x446e6){var _0x15a9ed;_0xd2391=_0x446e6||[];var _0x3db98f=[];if(_0x446e6){for(var _0x2b624e=0x0;_0x2b624e<_0x446e6[_0x0a9e('0x35')];_0x2b624e+=0x1){var _0x5cb48d=_0x446e6[_0x2b624e][_0x0a9e('0x4c')]({'plain':!![]});_0x1a9ef1['dialCheckDuplicateType']=_0x20ae21['body']['dialCheckDuplicateType']?_0x20ae21[_0x0a9e('0x48')][_0x0a9e('0x66')]:_0x1a9ef1[_0x0a9e('0x66')];switch(_0x1a9ef1[_0x0a9e('0x66')]){case'always':_0x15a9ed=squel[_0x0a9e('0x67')]()[_0x0a9e('0x68')](_0x0a9e('0x69'))[_0x0a9e('0x6a')]([_0x0a9e('0x6b'),'scheduledAt','ContactId',_0x0a9e('0x6c'),_0x0a9e('0x5a'),_0x0a9e('0x53'),'updatedAt'],squel[_0x0a9e('0x6d')]()[_0x0a9e('0x6e')](_0x0a9e('0x6b'),'phone')[_0x0a9e('0x6e')](_0x0a9e('0x6f'),_0x0a9e('0x70'))['field']('id',_0x0a9e('0x71'))[_0x0a9e('0x6e')](_0x5cb48d[_0x0a9e('0x72')]['toString'](),'ListId')['field'](_0x20ae21[_0x0a9e('0x44')]['id'][_0x0a9e('0x73')](),_0x0a9e('0x5a'))[_0x0a9e('0x6e')]('NOW()',_0x0a9e('0x53'))['field'](_0x0a9e('0x6f'),_0x0a9e('0x52'))[_0x0a9e('0x74')]('cm_contacts')[_0x0a9e('0x3c')](_0x0a9e('0x75'))[_0x0a9e('0x3c')]('ListId\x20=\x20?',_0x5cb48d[_0x0a9e('0x72')]['toString']())[_0x0a9e('0x3c')]('phone\x20IS\x20NOT\x20NULL')[_0x0a9e('0x3c')]('phone\x20NOT\x20IN\x20(?)',squel[_0x0a9e('0x6d')]()[_0x0a9e('0x6e')](_0x0a9e('0x76'))[_0x0a9e('0x74')](_0x0a9e('0x77'))[_0x0a9e('0x3c')](_0x0a9e('0x78'),_0x20ae21['params']['id'][_0x0a9e('0x73')]()))[_0x0a9e('0x3c')]('phone\x20NOT\x20IN\x20(?)',squel[_0x0a9e('0x6d')]()[_0x0a9e('0x6e')]('COALESCE(phone,\x27\x27)')[_0x0a9e('0x74')](_0x0a9e('0x69'))[_0x0a9e('0x3c')]('CampaignId\x20=\x20?',_0x20ae21[_0x0a9e('0x44')]['id'][_0x0a9e('0x73')]())))[_0x0a9e('0x73')]();break;case _0x0a9e('0x79'):_0x15a9ed=squel[_0x0a9e('0x67')]()[_0x0a9e('0x68')](_0x0a9e('0x69'))[_0x0a9e('0x6a')]([_0x0a9e('0x6b'),_0x0a9e('0x70'),'ContactId',_0x0a9e('0x6c'),'CampaignId',_0x0a9e('0x53'),_0x0a9e('0x52')],squel[_0x0a9e('0x6d')]()[_0x0a9e('0x6e')](_0x0a9e('0x6b'),_0x0a9e('0x6b'))['field'](_0x0a9e('0x6f'),_0x0a9e('0x70'))[_0x0a9e('0x6e')]('id','ContactId')[_0x0a9e('0x6e')](_0x5cb48d[_0x0a9e('0x72')][_0x0a9e('0x73')](),_0x0a9e('0x6c'))[_0x0a9e('0x6e')](_0x20ae21[_0x0a9e('0x44')]['id'][_0x0a9e('0x73')](),'CampaignId')[_0x0a9e('0x6e')](_0x0a9e('0x6f'),_0x0a9e('0x53'))[_0x0a9e('0x6e')](_0x0a9e('0x6f'),_0x0a9e('0x52'))[_0x0a9e('0x74')]('cm_contacts')['where'](_0x0a9e('0x75'))[_0x0a9e('0x3c')](_0x0a9e('0x7a'),_0x5cb48d[_0x0a9e('0x72')][_0x0a9e('0x73')]())[_0x0a9e('0x3c')](_0x0a9e('0x7b'))['where'](_0x0a9e('0x7c'),squel[_0x0a9e('0x6d')]()[_0x0a9e('0x6e')](_0x0a9e('0x7d'))[_0x0a9e('0x74')](_0x0a9e('0x69'))[_0x0a9e('0x3c')]('CampaignId\x20=\x20?',_0x20ae21[_0x0a9e('0x44')]['id'][_0x0a9e('0x73')]())))[_0x0a9e('0x73')]();break;default:_0x15a9ed=squel['insert']()[_0x0a9e('0x68')](_0x0a9e('0x69'))[_0x0a9e('0x6a')]([_0x0a9e('0x6b'),'scheduledAt',_0x0a9e('0x71'),_0x0a9e('0x6c'),_0x0a9e('0x5a'),_0x0a9e('0x53'),_0x0a9e('0x52')],squel[_0x0a9e('0x6d')]()[_0x0a9e('0x6e')](_0x0a9e('0x6b'),'phone')[_0x0a9e('0x6e')](_0x0a9e('0x6f'),_0x0a9e('0x70'))[_0x0a9e('0x6e')]('id','ContactId')['field'](_0x5cb48d[_0x0a9e('0x72')][_0x0a9e('0x73')](),_0x0a9e('0x6c'))['field'](_0x20ae21[_0x0a9e('0x44')]['id'][_0x0a9e('0x73')](),'CampaignId')[_0x0a9e('0x6e')]('NOW()',_0x0a9e('0x53'))['field']('NOW()','updatedAt')[_0x0a9e('0x74')](_0x0a9e('0x7e'))[_0x0a9e('0x3c')](_0x0a9e('0x75'))[_0x0a9e('0x3c')](_0x0a9e('0x7a'),_0x5cb48d['CmListId'][_0x0a9e('0x73')]())[_0x0a9e('0x3c')](_0x0a9e('0x7b')))[_0x0a9e('0x73')]();}_0x3db98f[_0x0a9e('0x7f')](db[_0x0a9e('0x80')][_0x0a9e('0x30')](_0x15a9ed));}return BPromise['all'](_0x3db98f);}})['then'](function(){return _0xd2391;})[_0x0a9e('0x22')](respondWithResult(_0x566b90,null))['catch'](handleError(_0x566b90,null));};exports[_0x0a9e('0x81')]=function(_0xb326cb,_0x1f0318,_0xa3695f){return db[_0x0a9e('0x2a')][_0x0a9e('0x4e')]({'where':{'id':_0xb326cb['params']['id']}})[_0x0a9e('0x22')](handleEntityNotFound(_0x1f0318,null))['then'](function(_0x50e32a){if(_0x50e32a){return _0x50e32a[_0x0a9e('0x81')](_0xb326cb['query'][_0x0a9e('0x64')]);}})['then'](function(_0x550cbf){if(_0x550cbf){return db[_0x0a9e('0x57')]['destroy']({'where':{'ListId':_0xb326cb[_0x0a9e('0x30')][_0x0a9e('0x64')],'CampaignId':_0xb326cb[_0x0a9e('0x44')]['id']}})['then'](function(){return _0x550cbf;});}})[_0x0a9e('0x22')](respondWithStatusCode(_0x1f0318,null))[_0x0a9e('0x42')](handleError(_0x1f0318,null));};exports[_0x0a9e('0x82')]=function(_0x55b69e,_0x5236c9,_0xdc77d){var _0x948aab={'raw':!![],'where':{}};var _0x89d2cb={};var _0x2f79fb={'count':0x0,'rows':[]};return db[_0x0a9e('0x2a')][_0x0a9e('0x56')]({'where':{'id':_0x55b69e[_0x0a9e('0x44')]['id']}})[_0x0a9e('0x22')](handleEntityNotFound(_0x5236c9,null))[_0x0a9e('0x22')](function(_0x1020a0){if(_0x1020a0){_0x89d2cb['model']=_['keys'](db['CmList'][_0x0a9e('0x2b')]);_0x89d2cb[_0x0a9e('0x30')]=_[_0x0a9e('0x31')](_0x55b69e[_0x0a9e('0x30')]);_0x89d2cb[_0x0a9e('0x39')]=_[_0x0a9e('0x32')](_0x89d2cb[_0x0a9e('0x2f')],_0x89d2cb[_0x0a9e('0x30')]);_0x948aab['attributes']=_['intersection'](_0x89d2cb[_0x0a9e('0x2f')],qs[_0x0a9e('0x34')](_0x55b69e['query'][_0x0a9e('0x34')]));_0x948aab[_0x0a9e('0x33')]=_0x948aab[_0x0a9e('0x33')][_0x0a9e('0x35')]?_0x948aab[_0x0a9e('0x33')]:_0x89d2cb[_0x0a9e('0x2f')];if(!_0x55b69e[_0x0a9e('0x30')][_0x0a9e('0x36')](_0x0a9e('0x58'))){_0x948aab[_0x0a9e('0x1a')]=qs[_0x0a9e('0x1a')](_0x55b69e[_0x0a9e('0x30')]['limit']);_0x948aab[_0x0a9e('0x19')]=qs[_0x0a9e('0x19')](_0x55b69e[_0x0a9e('0x30')][_0x0a9e('0x19')]);}_0x948aab[_0x0a9e('0x37')]=qs[_0x0a9e('0x38')](_0x55b69e[_0x0a9e('0x30')][_0x0a9e('0x38')]);_0x948aab[_0x0a9e('0x3c')]=qs[_0x0a9e('0x39')](_[_0x0a9e('0x59')](_0x55b69e[_0x0a9e('0x30')],_0x89d2cb['filters']));_0x948aab['where'][_0x0a9e('0x5a')]=_0x1020a0['id'];if(_0x55b69e[_0x0a9e('0x30')][_0x0a9e('0x3a')]){_0x948aab[_0x0a9e('0x3c')]=_[_0x0a9e('0x3b')](_0x948aab[_0x0a9e('0x3c')],{'$or':_[_0x0a9e('0x29')](_0x948aab['attributes'],function(_0x26a204){var _0x49fd0e={};_0x49fd0e[_0x26a204]={'$like':'%'+_0x55b69e[_0x0a9e('0x30')][_0x0a9e('0x3a')]+'%'};return _0x49fd0e;})});}_0x948aab=_[_0x0a9e('0x3b')]({},_0x948aab,_0x55b69e[_0x0a9e('0x46')]);return db[_0x0a9e('0x62')][_0x0a9e('0x3e')]({'where':_0x948aab[_0x0a9e('0x3c')]})[_0x0a9e('0x22')](function(_0xa7a754){_0x2f79fb[_0x0a9e('0x3e')]=_0xa7a754;if(_0x55b69e[_0x0a9e('0x30')][_0x0a9e('0x45')]){_0x948aab[_0x0a9e('0x3f')]=[{'all':!![]}];}return db[_0x0a9e('0x62')][_0x0a9e('0x40')](_0x948aab);})[_0x0a9e('0x22')](function(_0x5b78a8){_0x2f79fb['rows']=_0x5b78a8;return _0x2f79fb;});}})[_0x0a9e('0x22')](respondWithFilteredResult(_0x5236c9,_0x948aab))[_0x0a9e('0x42')](handleError(_0x5236c9,null));};exports['addBlackLists']=function(_0x5500de,_0x2cb05c,_0x1feb9){var _0x3304a1,_0x596178;return db[_0x0a9e('0x2a')]['find']({'where':{'id':_0x5500de[_0x0a9e('0x44')]['id']}})['then'](handleEntityNotFound(_0x2cb05c,null))[_0x0a9e('0x22')](function(_0x5e9c92){if(_0x5e9c92){_0x596178=_0x5e9c92;return _0x5e9c92[_0x0a9e('0x83')](_0x5500de[_0x0a9e('0x48')][_0x0a9e('0x64')],_['omit'](_0x5500de[_0x0a9e('0x48')],['ids','id'])||{});}return null;})['spread'](function(_0x44b7af){var _0x23993f;_0x3304a1=_0x44b7af||[];var _0x3c691f=[];if(_0x44b7af){for(var _0x1542e8=0x0;_0x1542e8<_0x44b7af[_0x0a9e('0x35')];_0x1542e8+=0x1){var _0x7b05ba=_0x44b7af[_0x1542e8][_0x0a9e('0x4c')]({'plain':!![]});_0x23993f=squel[_0x0a9e('0x67')]()[_0x0a9e('0x68')](_0x0a9e('0x84'))[_0x0a9e('0x6a')]([_0x0a9e('0x6b'),_0x0a9e('0x71'),_0x0a9e('0x6c'),_0x0a9e('0x5a'),_0x0a9e('0x53'),_0x0a9e('0x52')],squel[_0x0a9e('0x6d')]()[_0x0a9e('0x6e')]('phone',_0x0a9e('0x6b'))[_0x0a9e('0x6e')]('id',_0x0a9e('0x71'))[_0x0a9e('0x6e')](_0x7b05ba['CmListId']['toString'](),'ListId')[_0x0a9e('0x6e')](_0x5500de['params']['id'][_0x0a9e('0x73')](),_0x0a9e('0x5a'))[_0x0a9e('0x6e')](_0x0a9e('0x6f'),_0x0a9e('0x53'))[_0x0a9e('0x6e')](_0x0a9e('0x6f'),_0x0a9e('0x52'))[_0x0a9e('0x74')](_0x0a9e('0x7e'))['where'](_0x0a9e('0x75'))['where'](_0x0a9e('0x7a'),_0x7b05ba['CmListId'][_0x0a9e('0x73')]())[_0x0a9e('0x3c')](_0x0a9e('0x7b')))['toString']();_0x3c691f[_0x0a9e('0x7f')](db[_0x0a9e('0x80')]['query'](_0x23993f));}return BPromise['all'](_0x3c691f);}})[_0x0a9e('0x22')](function(){return _0x3304a1;})[_0x0a9e('0x22')](respondWithResult(_0x2cb05c,null))[_0x0a9e('0x42')](handleError(_0x2cb05c,null));};exports['removeBlackLists']=function(_0x578e8d,_0x4869c1,_0x374964){return db[_0x0a9e('0x2a')][_0x0a9e('0x4e')]({'where':{'id':_0x578e8d[_0x0a9e('0x44')]['id']}})[_0x0a9e('0x22')](handleEntityNotFound(_0x4869c1,null))[_0x0a9e('0x22')](function(_0x183b9b){if(_0x183b9b){return _0x183b9b[_0x0a9e('0x85')](_0x578e8d[_0x0a9e('0x30')][_0x0a9e('0x64')]);}})[_0x0a9e('0x22')](function(_0x2f4de1){if(_0x2f4de1){return db[_0x0a9e('0x60')][_0x0a9e('0x21')]({'where':{'ListId':_0x578e8d[_0x0a9e('0x30')][_0x0a9e('0x64')],'CampaignId':_0x578e8d[_0x0a9e('0x44')]['id']}})[_0x0a9e('0x22')](function(){return _0x2f4de1;});}})['then'](respondWithStatusCode(_0x4869c1,null))[_0x0a9e('0x42')](handleError(_0x4869c1,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff