// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xcb3f=['Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','omit','createdAt','updatedAt','body','userProfileId','findOne','CmHopper','order','pick','rows','getHopperHistories','CmHopperHistory','getHopperFinals','CampaignId','CmHopperFinal','CmHopperBlack','getLists','CmList','addLists','ids','spread','dialCheckDuplicateType','always','insert','fromQuery','phone','scheduledAt','ContactId','ListId','select','field','CmListId','toString','NOW()','from','cm_contacts','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','COALESCE(calleridnum,\x27\x27)','cm_hopper_final','CampaignId\x20=\x20?','COALESCE(phone,\x27\x27)','cm_hopper','into','push','all','removeLists','getBlackLists','addBlackLists','cm_hopper_black','sequelize','removeBlackLists','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','mustache','util','path','to-csv','ejs','fs-extra','crypto','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/license/util','../../mysqldb','sendStatus','status','end','json','limit','count','offset','apply','reject','save','update','then','get','IvrCampaigns','UserProfileResource','destroy','error','stack','name','send','index','Campaign','rawAttributes','fieldName','type','key','model','map','query','keys','filters','intersection','fields','attributes','length','hasOwnProperty','nolimit','sort','where','filter','VIRTUAL','merge','options','includeAll','findAll','catch','show','params','include','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','find','autoAssociation'];(function(_0x8ed2fe,_0x19ca78){var _0x23a751=function(_0x412f75){while(--_0x412f75){_0x8ed2fe['push'](_0x8ed2fe['shift']());}};_0x23a751(++_0x19ca78);}(_0xcb3f,0xbe));var _0xfcb3=function(_0x3dd15e,_0x1f0015){_0x3dd15e=_0x3dd15e-0x0;var _0x231fd0=_0xcb3f[_0x3dd15e];return _0x231fd0;};'use strict';var emlformat=require(_0xfcb3('0x0'));var rimraf=require(_0xfcb3('0x1'));var zipdir=require(_0xfcb3('0x2'));var jsonpatch=require(_0xfcb3('0x3'));var rp=require(_0xfcb3('0x4'));var moment=require(_0xfcb3('0x5'));var BPromise=require('bluebird');var Mustache=require(_0xfcb3('0x6'));var util=require(_0xfcb3('0x7'));var path=require(_0xfcb3('0x8'));var sox=require('sox');var csv=require(_0xfcb3('0x9'));var ejs=require(_0xfcb3('0xa'));var fs=require('fs');var fs_extra=require(_0xfcb3('0xb'));var _=require('lodash');var squel=require('squel');var crypto=require(_0xfcb3('0xc'));var jsforce=require('jsforce');var deskjs=require(_0xfcb3('0xd'));var toCsv=require('to-csv');var querystring=require(_0xfcb3('0xe'));var Papa=require(_0xfcb3('0xf'));var Redis=require(_0xfcb3('0x10'));var authService=require(_0xfcb3('0x11'));var qs=require('../../components/parsers/qs');var as=require(_0xfcb3('0x12'));var hardwareService=require('../../config/license/hardware');var logger=require(_0xfcb3('0x13'))(_0xfcb3('0x14'));var utils=require(_0xfcb3('0x15'));var config=require('../../config/environment');var licenseUtil=require(_0xfcb3('0x16'));var db=require(_0xfcb3('0x17'))['db'];function respondWithStatusCode(_0x3e303d,_0xf6ce2f){_0xf6ce2f=_0xf6ce2f||0xcc;return function(_0x2175db){if(_0x2175db){return _0x3e303d[_0xfcb3('0x18')](_0xf6ce2f);}return _0x3e303d[_0xfcb3('0x19')](_0xf6ce2f)[_0xfcb3('0x1a')]();};}function respondWithResult(_0x29db93,_0x268897){_0x268897=_0x268897||0xc8;return function(_0x3a813d){if(_0x3a813d){return _0x29db93[_0xfcb3('0x19')](_0x268897)[_0xfcb3('0x1b')](_0x3a813d);}};}function respondWithFilteredResult(_0x22768d,_0x3425b7){return function(_0x18b865){if(_0x18b865){var _0x188b73=typeof _0x3425b7['offset']==='undefined'&&typeof _0x3425b7[_0xfcb3('0x1c')]==='undefined';var _0x16dd7b=_0x18b865[_0xfcb3('0x1d')];var _0x23562d=_0x188b73?0x0:_0x3425b7['offset'];var _0x1c3476=_0x188b73?_0x18b865['count']:_0x3425b7[_0xfcb3('0x1e')]+_0x3425b7[_0xfcb3('0x1c')];var _0x4deb4d;if(_0x1c3476>=_0x16dd7b){_0x1c3476=_0x16dd7b;_0x4deb4d=0xc8;}else{_0x4deb4d=0xce;}_0x22768d[_0xfcb3('0x19')](_0x4deb4d);return _0x22768d['set']('Content-Range',_0x23562d+'-'+_0x1c3476+'/'+_0x16dd7b)[_0xfcb3('0x1b')](_0x18b865);}return null;};}function patchUpdates(_0xe3a26c){return function(_0x57b34d){try{jsonpatch[_0xfcb3('0x1f')](_0x57b34d,_0xe3a26c,!![]);}catch(_0x253326){return BPromise[_0xfcb3('0x20')](_0x253326);}return _0x57b34d[_0xfcb3('0x21')]();};}function saveUpdates(_0x16cf4f,_0x1f5210){return function(_0x16026f){if(_0x16026f){return _0x16026f[_0xfcb3('0x22')](_0x16cf4f)[_0xfcb3('0x23')](function(_0xb5ca8b){return _0xb5ca8b;});}return null;};}function removeEntity(_0x83ec28,_0x39ed79){return function(_0x3892ea){if(_0x3892ea){return _0x3892ea['destroy']()[_0xfcb3('0x23')](function(){var _0x195cce=_0x3892ea[_0xfcb3('0x24')]({'plain':!![]});var _0x2f8420=_0xfcb3('0x25');return db[_0xfcb3('0x26')][_0xfcb3('0x27')]({'where':{'type':_0x2f8420,'resourceId':_0x195cce['id']}})[_0xfcb3('0x23')](function(){return _0x3892ea;});})[_0xfcb3('0x23')](function(){_0x83ec28[_0xfcb3('0x19')](0xcc)[_0xfcb3('0x1a')]();});}};}function handleEntityNotFound(_0x557b88,_0x7234a9){return function(_0x5800e1){if(!_0x5800e1){_0x557b88[_0xfcb3('0x18')](0x194);}return _0x5800e1;};}function handleError(_0x18c497,_0x2d5a09){_0x2d5a09=_0x2d5a09||0x1f4;return function(_0xc9277){logger[_0xfcb3('0x28')](_0xc9277[_0xfcb3('0x29')]);if(_0xc9277[_0xfcb3('0x2a')]){delete _0xc9277['name'];}_0x18c497[_0xfcb3('0x19')](_0x2d5a09)[_0xfcb3('0x2b')](_0xc9277);};}exports[_0xfcb3('0x2c')]=function(_0x299e2b,_0x58a61b){var _0x37fb74={},_0xf177c3={},_0xc03e88={'count':0x0,'rows':[]};var _0x5ae7d7=_['map'](db[_0xfcb3('0x2d')][_0xfcb3('0x2e')],function(_0x47b426){return{'name':_0x47b426[_0xfcb3('0x2f')],'type':_0x47b426[_0xfcb3('0x30')][_0xfcb3('0x31')]};});_0xf177c3[_0xfcb3('0x32')]=_[_0xfcb3('0x33')](_0x5ae7d7,_0xfcb3('0x2a'));_0xf177c3[_0xfcb3('0x34')]=_[_0xfcb3('0x35')](_0x299e2b['query']);_0xf177c3[_0xfcb3('0x36')]=_[_0xfcb3('0x37')](_0xf177c3[_0xfcb3('0x32')],_0xf177c3[_0xfcb3('0x34')]);_0x37fb74['attributes']=_[_0xfcb3('0x37')](_0xf177c3['model'],qs['fields'](_0x299e2b[_0xfcb3('0x34')][_0xfcb3('0x38')]));_0x37fb74['attributes']=_0x37fb74[_0xfcb3('0x39')][_0xfcb3('0x3a')]?_0x37fb74['attributes']:_0xf177c3[_0xfcb3('0x32')];if(!_0x299e2b[_0xfcb3('0x34')][_0xfcb3('0x3b')](_0xfcb3('0x3c'))){_0x37fb74[_0xfcb3('0x1c')]=qs[_0xfcb3('0x1c')](_0x299e2b[_0xfcb3('0x34')]['limit']);_0x37fb74['offset']=qs['offset'](_0x299e2b[_0xfcb3('0x34')][_0xfcb3('0x1e')]);}_0x37fb74['order']=qs[_0xfcb3('0x3d')](_0x299e2b[_0xfcb3('0x34')][_0xfcb3('0x3d')]);_0x37fb74[_0xfcb3('0x3e')]=qs['filters'](_['pick'](_0x299e2b[_0xfcb3('0x34')],_0xf177c3[_0xfcb3('0x36')]),_0x5ae7d7);if(_0x299e2b[_0xfcb3('0x34')][_0xfcb3('0x3f')]){_0x37fb74[_0xfcb3('0x3e')]=_['merge'](_0x37fb74['where'],{'$or':_[_0xfcb3('0x33')](_0x5ae7d7,function(_0x58f270){if(_0x58f270['type']!==_0xfcb3('0x40')){var _0xb3a88a={};_0xb3a88a[_0x58f270[_0xfcb3('0x2a')]]={'$like':'%'+_0x299e2b['query'][_0xfcb3('0x3f')]+'%'};return _0xb3a88a;}})});}_0x37fb74=_[_0xfcb3('0x41')]({},_0x37fb74,_0x299e2b[_0xfcb3('0x42')]);var _0x41d9a1={'where':_0x37fb74[_0xfcb3('0x3e')]};return db['Campaign'][_0xfcb3('0x1d')](_0x41d9a1)['then'](function(_0x52990f){_0xc03e88[_0xfcb3('0x1d')]=_0x52990f;if(_0x299e2b[_0xfcb3('0x34')][_0xfcb3('0x43')]){_0x37fb74['include']=[{'all':!![]}];}return db[_0xfcb3('0x2d')][_0xfcb3('0x44')](_0x37fb74);})[_0xfcb3('0x23')](function(_0x1d1cdf){_0xc03e88['rows']=_0x1d1cdf;return _0xc03e88;})[_0xfcb3('0x23')](respondWithFilteredResult(_0x58a61b,_0x37fb74))[_0xfcb3('0x45')](handleError(_0x58a61b,null));};exports[_0xfcb3('0x46')]=function(_0xa67e94,_0x1ba249){var _0x125614={'raw':![],'where':{'id':_0xa67e94[_0xfcb3('0x47')]['id']}},_0x5124ed={};_0x5124ed[_0xfcb3('0x32')]=_[_0xfcb3('0x35')](db[_0xfcb3('0x2d')][_0xfcb3('0x2e')]);_0x5124ed[_0xfcb3('0x34')]=_[_0xfcb3('0x35')](_0xa67e94[_0xfcb3('0x34')]);_0x5124ed[_0xfcb3('0x36')]=_[_0xfcb3('0x37')](_0x5124ed['model'],_0x5124ed[_0xfcb3('0x34')]);_0x125614[_0xfcb3('0x39')]=_[_0xfcb3('0x37')](_0x5124ed[_0xfcb3('0x32')],qs[_0xfcb3('0x38')](_0xa67e94['query'][_0xfcb3('0x38')]));_0x125614[_0xfcb3('0x39')]=_0x125614[_0xfcb3('0x39')][_0xfcb3('0x3a')]?_0x125614[_0xfcb3('0x39')]:_0x5124ed[_0xfcb3('0x32')];if(_0xa67e94['query'][_0xfcb3('0x43')]){_0x125614[_0xfcb3('0x48')]=[{'all':!![]}];}_0x125614=_['merge']({},_0x125614,_0xa67e94[_0xfcb3('0x42')]);return db[_0xfcb3('0x2d')]['find'](_0x125614)[_0xfcb3('0x23')](handleEntityNotFound(_0x1ba249,null))[_0xfcb3('0x23')](respondWithResult(_0x1ba249,null))['catch'](handleError(_0x1ba249,null));};exports[_0xfcb3('0x49')]=function(_0x1fe696,_0x3328e5){return db[_0xfcb3('0x2d')][_0xfcb3('0x49')](_0x1fe696['body'],{})['then'](function(_0x1ce4f1){var _0x4f54a0=_0x1fe696[_0xfcb3('0x4a')][_0xfcb3('0x24')]({'plain':!![]});if(!_0x4f54a0)throw new Error(_0xfcb3('0x4b'));if(_0x4f54a0[_0xfcb3('0x4c')]==='user'){var _0x82e59f=_0x1ce4f1['get']({'plain':!![]});var _0x2987f5='IvrCampaigns';return db[_0xfcb3('0x4d')][_0xfcb3('0x4e')]({'where':{'name':_0x2987f5,'userProfileId':_0x4f54a0['userProfileId']},'raw':!![]})[_0xfcb3('0x23')](function(_0x214e34){if(_0x214e34&&_0x214e34[_0xfcb3('0x4f')]===0x0){return db[_0xfcb3('0x26')][_0xfcb3('0x49')]({'name':_0x82e59f['name'],'resourceId':_0x82e59f['id'],'type':_0x214e34[_0xfcb3('0x2a')],'sectionId':_0x214e34['id']},{})[_0xfcb3('0x23')](function(){return _0x1ce4f1;});}else{return _0x1ce4f1;}})[_0xfcb3('0x45')](function(_0x129bf7){logger['error'](_0xfcb3('0x50'),_0x129bf7);throw _0x129bf7;});}return _0x1ce4f1;})[_0xfcb3('0x23')](respondWithResult(_0x3328e5,0xc9))[_0xfcb3('0x45')](handleError(_0x3328e5,null));};exports[_0xfcb3('0x51')]=function(_0x3924d7,_0x293324){var _0x52438d={'where':{'id':_0x3924d7[_0xfcb3('0x47')]['id']}},_0x4f1ad2={};_0x4f1ad2[_0xfcb3('0x32')]=_[_0xfcb3('0x35')](db[_0xfcb3('0x2d')][_0xfcb3('0x2e')]);_0x52438d[_0xfcb3('0x39')]=_['intersection'](_0x4f1ad2[_0xfcb3('0x32')],qs['fields'](_0x3924d7['query'][_0xfcb3('0x38')]));_0x52438d[_0xfcb3('0x39')]=_0x52438d[_0xfcb3('0x39')][_0xfcb3('0x3a')]?_0x52438d['attributes']:_0x4f1ad2[_0xfcb3('0x32')];if(_0x3924d7[_0xfcb3('0x34')][_0xfcb3('0x43')]){_0x52438d[_0xfcb3('0x48')]=[{'all':!![]}];}_0x52438d=_[_0xfcb3('0x41')]({},_0x52438d,_0x3924d7[_0xfcb3('0x42')]);return db['Campaign'][_0xfcb3('0x4e')](_0x52438d)['then'](handleEntityNotFound(_0x293324,null))[_0xfcb3('0x23')](function(_0x2a9bb1){if(_0x2a9bb1){var _0x40f686=_0x2a9bb1[_0xfcb3('0x24')]({'plain':!![]});_0x40f686=qs[_0xfcb3('0x52')](_0x40f686,['id',_0xfcb3('0x53'),_0xfcb3('0x54')]);_0x3924d7[_0xfcb3('0x55')]=_[_0xfcb3('0x52')](_0x3924d7[_0xfcb3('0x55')],['id',_0xfcb3('0x53'),'updatedAt']);return db[_0xfcb3('0x2d')][_0xfcb3('0x49')](_[_0xfcb3('0x41')](_0x40f686,_0x3924d7['body']),{'include':_0x3924d7[_0xfcb3('0x34')][_0xfcb3('0x43')]?[{'all':!![]}]:undefined})[_0xfcb3('0x23')](function(_0x438ad0){var _0x3060f0=_0x3924d7[_0xfcb3('0x4a')][_0xfcb3('0x24')]({'plain':!![]});if(!_0x3060f0)throw new Error(_0xfcb3('0x4b'));if(_0x3060f0[_0xfcb3('0x4c')]===_0xfcb3('0x4a')){var _0xb45d22=_0x438ad0[_0xfcb3('0x24')]({'plain':!![]});var _0x280cc5=_0xfcb3('0x25');return db[_0xfcb3('0x4d')][_0xfcb3('0x4e')]({'where':{'name':_0x280cc5,'userProfileId':_0x3060f0[_0xfcb3('0x56')]},'raw':!![]})[_0xfcb3('0x23')](function(_0x5a3b21){if(_0x5a3b21&&_0x5a3b21[_0xfcb3('0x4f')]===0x0){return db[_0xfcb3('0x26')][_0xfcb3('0x49')]({'name':_0xb45d22[_0xfcb3('0x2a')],'resourceId':_0xb45d22['id'],'type':_0x5a3b21[_0xfcb3('0x2a')],'sectionId':_0x5a3b21['id']},{})[_0xfcb3('0x23')](function(){return _0x438ad0;});}else{return _0x438ad0;}})[_0xfcb3('0x45')](function(_0x5f46fc){logger[_0xfcb3('0x28')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x5f46fc);throw _0x5f46fc;});}return _0x438ad0;});}})[_0xfcb3('0x23')](respondWithResult(_0x293324,0xc9))[_0xfcb3('0x45')](handleError(_0x293324,null));};exports[_0xfcb3('0x22')]=function(_0x4f5a91,_0x21c9d5){if(_0x4f5a91[_0xfcb3('0x55')]['id']){delete _0x4f5a91['body']['id'];}return db[_0xfcb3('0x2d')][_0xfcb3('0x4e')]({'where':{'id':_0x4f5a91[_0xfcb3('0x47')]['id']}})[_0xfcb3('0x23')](handleEntityNotFound(_0x21c9d5,null))[_0xfcb3('0x23')](saveUpdates(_0x4f5a91[_0xfcb3('0x55')],null))[_0xfcb3('0x23')](respondWithResult(_0x21c9d5,null))[_0xfcb3('0x45')](handleError(_0x21c9d5,null));};exports[_0xfcb3('0x27')]=function(_0x3e5b33,_0x51f8fc){return db[_0xfcb3('0x2d')][_0xfcb3('0x4e')]({'where':{'id':_0x3e5b33['params']['id']}})[_0xfcb3('0x23')](handleEntityNotFound(_0x51f8fc,null))[_0xfcb3('0x23')](removeEntity(_0x51f8fc,null))[_0xfcb3('0x45')](handleError(_0x51f8fc,null));};exports['getHoppers']=function(_0x3633b6,_0x4274e1,_0x406d3a){var _0x1ea6c3={'raw':!![],'where':{}};var _0x4eb3aa={};var _0x208c3f={'count':0x0,'rows':[]};return db[_0xfcb3('0x2d')][_0xfcb3('0x57')]({'where':{'id':_0x3633b6[_0xfcb3('0x47')]['id']}})[_0xfcb3('0x23')](handleEntityNotFound(_0x4274e1,null))[_0xfcb3('0x23')](function(_0x54fc46){if(_0x54fc46){_0x4eb3aa[_0xfcb3('0x32')]=_['keys'](db[_0xfcb3('0x58')][_0xfcb3('0x2e')]);_0x4eb3aa[_0xfcb3('0x34')]=_[_0xfcb3('0x35')](_0x3633b6[_0xfcb3('0x34')]);_0x4eb3aa[_0xfcb3('0x36')]=_[_0xfcb3('0x37')](_0x4eb3aa[_0xfcb3('0x32')],_0x4eb3aa[_0xfcb3('0x34')]);_0x1ea6c3[_0xfcb3('0x39')]=_[_0xfcb3('0x37')](_0x4eb3aa[_0xfcb3('0x32')],qs['fields'](_0x3633b6[_0xfcb3('0x34')]['fields']));_0x1ea6c3['attributes']=_0x1ea6c3[_0xfcb3('0x39')][_0xfcb3('0x3a')]?_0x1ea6c3[_0xfcb3('0x39')]:_0x4eb3aa[_0xfcb3('0x32')];if(!_0x3633b6[_0xfcb3('0x34')]['hasOwnProperty']('nolimit')){_0x1ea6c3[_0xfcb3('0x1c')]=qs[_0xfcb3('0x1c')](_0x3633b6[_0xfcb3('0x34')]['limit']);_0x1ea6c3[_0xfcb3('0x1e')]=qs[_0xfcb3('0x1e')](_0x3633b6['query']['offset']);}_0x1ea6c3[_0xfcb3('0x59')]=qs[_0xfcb3('0x3d')](_0x3633b6['query'][_0xfcb3('0x3d')]);_0x1ea6c3[_0xfcb3('0x3e')]=qs[_0xfcb3('0x36')](_[_0xfcb3('0x5a')](_0x3633b6[_0xfcb3('0x34')],_0x4eb3aa['filters']));_0x1ea6c3[_0xfcb3('0x3e')]['CampaignId']=_0x54fc46['id'];if(_0x3633b6['query'][_0xfcb3('0x3f')]){_0x1ea6c3[_0xfcb3('0x3e')]=_[_0xfcb3('0x41')](_0x1ea6c3[_0xfcb3('0x3e')],{'$or':_[_0xfcb3('0x33')](_0x1ea6c3[_0xfcb3('0x39')],function(_0x155fa8){var _0x4d41a7={};_0x4d41a7[_0x155fa8]={'$like':'%'+_0x3633b6[_0xfcb3('0x34')]['filter']+'%'};return _0x4d41a7;})});}_0x1ea6c3=_[_0xfcb3('0x41')]({},_0x1ea6c3,_0x3633b6[_0xfcb3('0x42')]);return db[_0xfcb3('0x58')]['count']({'where':_0x1ea6c3[_0xfcb3('0x3e')]})['then'](function(_0x21f254){_0x208c3f[_0xfcb3('0x1d')]=_0x21f254;if(_0x3633b6[_0xfcb3('0x34')][_0xfcb3('0x43')]){_0x1ea6c3[_0xfcb3('0x48')]=[{'all':!![]}];}return db[_0xfcb3('0x58')][_0xfcb3('0x44')](_0x1ea6c3);})['then'](function(_0x49776c){_0x208c3f[_0xfcb3('0x5b')]=_0x49776c;return _0x208c3f;});}})[_0xfcb3('0x23')](respondWithFilteredResult(_0x4274e1,_0x1ea6c3))[_0xfcb3('0x45')](handleError(_0x4274e1,null));};exports[_0xfcb3('0x5c')]=function(_0xaee5bb,_0x1a518,_0xcda08d){var _0x502042={'raw':!![],'where':{}};var _0x5a2187={};var _0x21d8e3={'count':0x0,'rows':[]};return db[_0xfcb3('0x2d')][_0xfcb3('0x57')]({'where':{'id':_0xaee5bb[_0xfcb3('0x47')]['id']}})[_0xfcb3('0x23')](handleEntityNotFound(_0x1a518,null))['then'](function(_0x3da2c4){if(_0x3da2c4){_0x5a2187['model']=_[_0xfcb3('0x35')](db['CmHopperHistory'][_0xfcb3('0x2e')]);_0x5a2187['query']=_[_0xfcb3('0x35')](_0xaee5bb[_0xfcb3('0x34')]);_0x5a2187[_0xfcb3('0x36')]=_['intersection'](_0x5a2187[_0xfcb3('0x32')],_0x5a2187[_0xfcb3('0x34')]);_0x502042['attributes']=_[_0xfcb3('0x37')](_0x5a2187['model'],qs[_0xfcb3('0x38')](_0xaee5bb[_0xfcb3('0x34')][_0xfcb3('0x38')]));_0x502042[_0xfcb3('0x39')]=_0x502042['attributes'][_0xfcb3('0x3a')]?_0x502042[_0xfcb3('0x39')]:_0x5a2187[_0xfcb3('0x32')];if(!_0xaee5bb[_0xfcb3('0x34')]['hasOwnProperty']('nolimit')){_0x502042[_0xfcb3('0x1c')]=qs['limit'](_0xaee5bb['query'][_0xfcb3('0x1c')]);_0x502042[_0xfcb3('0x1e')]=qs[_0xfcb3('0x1e')](_0xaee5bb[_0xfcb3('0x34')][_0xfcb3('0x1e')]);}_0x502042[_0xfcb3('0x59')]=qs['sort'](_0xaee5bb['query'][_0xfcb3('0x3d')]);_0x502042[_0xfcb3('0x3e')]=qs[_0xfcb3('0x36')](_[_0xfcb3('0x5a')](_0xaee5bb[_0xfcb3('0x34')],_0x5a2187[_0xfcb3('0x36')]));_0x502042[_0xfcb3('0x3e')]['CampaignId']=_0x3da2c4['id'];if(_0xaee5bb[_0xfcb3('0x34')][_0xfcb3('0x3f')]){_0x502042[_0xfcb3('0x3e')]=_[_0xfcb3('0x41')](_0x502042['where'],{'$or':_['map'](_0x502042[_0xfcb3('0x39')],function(_0x4377d0){var _0x57b2c4={};_0x57b2c4[_0x4377d0]={'$like':'%'+_0xaee5bb[_0xfcb3('0x34')][_0xfcb3('0x3f')]+'%'};return _0x57b2c4;})});}_0x502042=_['merge']({},_0x502042,_0xaee5bb[_0xfcb3('0x42')]);return db[_0xfcb3('0x5d')][_0xfcb3('0x1d')]({'where':_0x502042[_0xfcb3('0x3e')]})[_0xfcb3('0x23')](function(_0x37e7dd){_0x21d8e3['count']=_0x37e7dd;if(_0xaee5bb[_0xfcb3('0x34')][_0xfcb3('0x43')]){_0x502042[_0xfcb3('0x48')]=[{'all':!![]}];}return db['CmHopperHistory'][_0xfcb3('0x44')](_0x502042);})[_0xfcb3('0x23')](function(_0x21fe52){_0x21d8e3['rows']=_0x21fe52;return _0x21d8e3;});}})[_0xfcb3('0x23')](respondWithFilteredResult(_0x1a518,_0x502042))[_0xfcb3('0x45')](handleError(_0x1a518,null));};exports[_0xfcb3('0x5e')]=function(_0x104173,_0xf5a013,_0x2ab172){var _0x4d3410={'raw':!![],'where':{}};var _0x3aa32e={};var _0x2b3a5a={'count':0x0,'rows':[]};return db['Campaign'][_0xfcb3('0x57')]({'where':{'id':_0x104173[_0xfcb3('0x47')]['id']}})[_0xfcb3('0x23')](handleEntityNotFound(_0xf5a013,null))[_0xfcb3('0x23')](function(_0x1f2139){if(_0x1f2139){_0x3aa32e[_0xfcb3('0x32')]=_[_0xfcb3('0x35')](db['CmHopperFinal'][_0xfcb3('0x2e')]);_0x3aa32e['query']=_['keys'](_0x104173[_0xfcb3('0x34')]);_0x3aa32e[_0xfcb3('0x36')]=_[_0xfcb3('0x37')](_0x3aa32e[_0xfcb3('0x32')],_0x3aa32e[_0xfcb3('0x34')]);_0x4d3410[_0xfcb3('0x39')]=_[_0xfcb3('0x37')](_0x3aa32e[_0xfcb3('0x32')],qs[_0xfcb3('0x38')](_0x104173[_0xfcb3('0x34')]['fields']));_0x4d3410[_0xfcb3('0x39')]=_0x4d3410[_0xfcb3('0x39')][_0xfcb3('0x3a')]?_0x4d3410[_0xfcb3('0x39')]:_0x3aa32e[_0xfcb3('0x32')];if(!_0x104173[_0xfcb3('0x34')][_0xfcb3('0x3b')](_0xfcb3('0x3c'))){_0x4d3410[_0xfcb3('0x1c')]=qs[_0xfcb3('0x1c')](_0x104173['query'][_0xfcb3('0x1c')]);_0x4d3410[_0xfcb3('0x1e')]=qs['offset'](_0x104173[_0xfcb3('0x34')]['offset']);}_0x4d3410[_0xfcb3('0x59')]=qs[_0xfcb3('0x3d')](_0x104173[_0xfcb3('0x34')][_0xfcb3('0x3d')]);_0x4d3410[_0xfcb3('0x3e')]=qs[_0xfcb3('0x36')](_[_0xfcb3('0x5a')](_0x104173['query'],_0x3aa32e[_0xfcb3('0x36')]));_0x4d3410[_0xfcb3('0x3e')][_0xfcb3('0x5f')]=_0x1f2139['id'];if(_0x104173[_0xfcb3('0x34')][_0xfcb3('0x3f')]){_0x4d3410[_0xfcb3('0x3e')]=_['merge'](_0x4d3410[_0xfcb3('0x3e')],{'$or':_[_0xfcb3('0x33')](_0x4d3410['attributes'],function(_0x4d9f9c){var _0x1f8d60={};_0x1f8d60[_0x4d9f9c]={'$like':'%'+_0x104173[_0xfcb3('0x34')][_0xfcb3('0x3f')]+'%'};return _0x1f8d60;})});}_0x4d3410=_['merge']({},_0x4d3410,_0x104173['options']);return db['CmHopperFinal'][_0xfcb3('0x1d')]({'where':_0x4d3410['where']})[_0xfcb3('0x23')](function(_0x130ef9){_0x2b3a5a['count']=_0x130ef9;if(_0x104173[_0xfcb3('0x34')][_0xfcb3('0x43')]){_0x4d3410[_0xfcb3('0x48')]=[{'all':!![]}];}return db[_0xfcb3('0x60')]['findAll'](_0x4d3410);})[_0xfcb3('0x23')](function(_0x3eee5c){_0x2b3a5a['rows']=_0x3eee5c;return _0x2b3a5a;});}})['then'](respondWithFilteredResult(_0xf5a013,_0x4d3410))[_0xfcb3('0x45')](handleError(_0xf5a013,null));};exports['getHopperBlacks']=function(_0x1ec8be,_0x14d4c5,_0x2cb6ce){var _0x58e12c={'raw':!![],'where':{}};var _0xa5b2c2={};var _0x32ca1a={'count':0x0,'rows':[]};return db[_0xfcb3('0x2d')][_0xfcb3('0x57')]({'where':{'id':_0x1ec8be[_0xfcb3('0x47')]['id']}})[_0xfcb3('0x23')](handleEntityNotFound(_0x14d4c5,null))[_0xfcb3('0x23')](function(_0x564462){if(_0x564462){_0xa5b2c2['model']=_['keys'](db[_0xfcb3('0x61')][_0xfcb3('0x2e')]);_0xa5b2c2['query']=_[_0xfcb3('0x35')](_0x1ec8be[_0xfcb3('0x34')]);_0xa5b2c2['filters']=_[_0xfcb3('0x37')](_0xa5b2c2['model'],_0xa5b2c2[_0xfcb3('0x34')]);_0x58e12c[_0xfcb3('0x39')]=_[_0xfcb3('0x37')](_0xa5b2c2[_0xfcb3('0x32')],qs[_0xfcb3('0x38')](_0x1ec8be[_0xfcb3('0x34')][_0xfcb3('0x38')]));_0x58e12c[_0xfcb3('0x39')]=_0x58e12c[_0xfcb3('0x39')]['length']?_0x58e12c[_0xfcb3('0x39')]:_0xa5b2c2[_0xfcb3('0x32')];if(!_0x1ec8be[_0xfcb3('0x34')][_0xfcb3('0x3b')](_0xfcb3('0x3c'))){_0x58e12c['limit']=qs[_0xfcb3('0x1c')](_0x1ec8be[_0xfcb3('0x34')]['limit']);_0x58e12c[_0xfcb3('0x1e')]=qs['offset'](_0x1ec8be['query'][_0xfcb3('0x1e')]);}_0x58e12c[_0xfcb3('0x59')]=qs[_0xfcb3('0x3d')](_0x1ec8be['query']['sort']);_0x58e12c[_0xfcb3('0x3e')]=qs[_0xfcb3('0x36')](_[_0xfcb3('0x5a')](_0x1ec8be[_0xfcb3('0x34')],_0xa5b2c2['filters']));_0x58e12c['where'][_0xfcb3('0x5f')]=_0x564462['id'];if(_0x1ec8be[_0xfcb3('0x34')][_0xfcb3('0x3f')]){_0x58e12c[_0xfcb3('0x3e')]=_[_0xfcb3('0x41')](_0x58e12c[_0xfcb3('0x3e')],{'$or':_[_0xfcb3('0x33')](_0x58e12c['attributes'],function(_0x2489f8){var _0x47cec1={};_0x47cec1[_0x2489f8]={'$like':'%'+_0x1ec8be[_0xfcb3('0x34')][_0xfcb3('0x3f')]+'%'};return _0x47cec1;})});}_0x58e12c=_[_0xfcb3('0x41')]({},_0x58e12c,_0x1ec8be[_0xfcb3('0x42')]);return db[_0xfcb3('0x61')][_0xfcb3('0x1d')]({'where':_0x58e12c[_0xfcb3('0x3e')]})[_0xfcb3('0x23')](function(_0x313544){_0x32ca1a[_0xfcb3('0x1d')]=_0x313544;if(_0x1ec8be[_0xfcb3('0x34')]['includeAll']){_0x58e12c[_0xfcb3('0x48')]=[{'all':!![]}];}return db['CmHopperBlack'][_0xfcb3('0x44')](_0x58e12c);})[_0xfcb3('0x23')](function(_0x340eab){_0x32ca1a[_0xfcb3('0x5b')]=_0x340eab;return _0x32ca1a;});}})[_0xfcb3('0x23')](respondWithFilteredResult(_0x14d4c5,_0x58e12c))[_0xfcb3('0x45')](handleError(_0x14d4c5,null));};exports[_0xfcb3('0x62')]=function(_0x4247dd,_0x31e944,_0x5bbc09){var _0x83906f={};var _0x3d6575={};var _0xae4124;var _0x370c89;return db[_0xfcb3('0x2d')][_0xfcb3('0x57')]({'where':{'id':_0x4247dd[_0xfcb3('0x47')]['id']}})[_0xfcb3('0x23')](handleEntityNotFound(_0x31e944,null))[_0xfcb3('0x23')](function(_0x18c95e){if(_0x18c95e){_0xae4124=_0x18c95e;_0x3d6575['model']=_[_0xfcb3('0x35')](db[_0xfcb3('0x63')]['rawAttributes']);_0x3d6575[_0xfcb3('0x34')]=_['keys'](_0x4247dd[_0xfcb3('0x34')]);_0x3d6575[_0xfcb3('0x36')]=_[_0xfcb3('0x37')](_0x3d6575[_0xfcb3('0x32')],_0x3d6575[_0xfcb3('0x34')]);_0x83906f[_0xfcb3('0x39')]=_[_0xfcb3('0x37')](_0x3d6575[_0xfcb3('0x32')],qs[_0xfcb3('0x38')](_0x4247dd[_0xfcb3('0x34')][_0xfcb3('0x38')]));_0x83906f[_0xfcb3('0x39')]=_0x83906f['attributes'][_0xfcb3('0x3a')]?_0x83906f[_0xfcb3('0x39')]:_0x3d6575[_0xfcb3('0x32')];_0x83906f[_0xfcb3('0x59')]=qs['sort'](_0x4247dd['query'][_0xfcb3('0x3d')]);_0x83906f['where']=qs['filters'](_[_0xfcb3('0x5a')](_0x4247dd[_0xfcb3('0x34')],_0x3d6575[_0xfcb3('0x36')]));if(_0x4247dd[_0xfcb3('0x34')]['filter']){_0x83906f[_0xfcb3('0x3e')]=_[_0xfcb3('0x41')](_0x83906f[_0xfcb3('0x3e')],{'$or':_['map'](_0x83906f[_0xfcb3('0x39')],function(_0x594ce0){var _0x34ed53={};_0x34ed53[_0x594ce0]={'$like':'%'+_0x4247dd['query'][_0xfcb3('0x3f')]+'%'};return _0x34ed53;})});}_0x83906f=_['merge']({},_0x83906f,_0x4247dd[_0xfcb3('0x42')]);return _0xae4124[_0xfcb3('0x62')](_0x83906f);}})[_0xfcb3('0x23')](function(_0x1ebb8c){if(_0x1ebb8c){_0x370c89=_0x1ebb8c[_0xfcb3('0x3a')];if(!_0x4247dd[_0xfcb3('0x34')][_0xfcb3('0x3b')](_0xfcb3('0x3c'))){_0x83906f[_0xfcb3('0x1c')]=qs[_0xfcb3('0x1c')](_0x4247dd[_0xfcb3('0x34')][_0xfcb3('0x1c')]);_0x83906f[_0xfcb3('0x1e')]=qs[_0xfcb3('0x1e')](_0x4247dd[_0xfcb3('0x34')][_0xfcb3('0x1e')]);}return _0xae4124[_0xfcb3('0x62')](_0x83906f);}})['then'](function(_0x6e694f){if(_0x6e694f){return _0x6e694f?{'count':_0x370c89,'rows':_0x6e694f}:null;}})['then'](respondWithResult(_0x31e944,null))['catch'](handleError(_0x31e944,null));};exports['addLists']=function(_0x400651,_0x45b10e,_0x70c277){var _0x510811,_0x2c5a43;return db['Campaign']['find']({'where':{'id':_0x400651[_0xfcb3('0x47')]['id']}})[_0xfcb3('0x23')](handleEntityNotFound(_0x45b10e,null))['then'](function(_0x2d12d9){if(_0x2d12d9){_0x2c5a43=_0x2d12d9;return _0x2d12d9[_0xfcb3('0x64')](_0x400651[_0xfcb3('0x55')][_0xfcb3('0x65')],_[_0xfcb3('0x52')](_0x400651[_0xfcb3('0x55')],['ids','id'])||{});}return null;})[_0xfcb3('0x66')](function(_0xa55c68){var _0x1f906f;_0x510811=_0xa55c68||[];var _0x6c23ea=[];if(_0xa55c68){for(var _0x3200ba=0x0;_0x3200ba<_0xa55c68[_0xfcb3('0x3a')];_0x3200ba+=0x1){var _0x1d4d86=_0xa55c68[_0x3200ba][_0xfcb3('0x24')]({'plain':!![]});_0x2c5a43[_0xfcb3('0x67')]=_0x400651[_0xfcb3('0x55')]['dialCheckDuplicateType']?_0x400651['body'][_0xfcb3('0x67')]:_0x2c5a43[_0xfcb3('0x67')];switch(_0x2c5a43[_0xfcb3('0x67')]){case _0xfcb3('0x68'):_0x1f906f=squel[_0xfcb3('0x69')]()['into']('cm_hopper')[_0xfcb3('0x6a')]([_0xfcb3('0x6b'),_0xfcb3('0x6c'),_0xfcb3('0x6d'),_0xfcb3('0x6e'),_0xfcb3('0x5f'),_0xfcb3('0x53'),_0xfcb3('0x54')],squel[_0xfcb3('0x6f')]()[_0xfcb3('0x70')](_0xfcb3('0x6b'),_0xfcb3('0x6b'))['field']('NOW()','scheduledAt')[_0xfcb3('0x70')]('id',_0xfcb3('0x6d'))[_0xfcb3('0x70')](_0x1d4d86[_0xfcb3('0x71')]['toString'](),_0xfcb3('0x6e'))[_0xfcb3('0x70')](_0x400651[_0xfcb3('0x47')]['id'][_0xfcb3('0x72')](),'CampaignId')['field'](_0xfcb3('0x73'),_0xfcb3('0x53'))['field'](_0xfcb3('0x73'),_0xfcb3('0x54'))[_0xfcb3('0x74')](_0xfcb3('0x75'))[_0xfcb3('0x3e')](_0xfcb3('0x76'))[_0xfcb3('0x3e')](_0xfcb3('0x77'),_0x1d4d86[_0xfcb3('0x71')]['toString']())[_0xfcb3('0x3e')](_0xfcb3('0x78'))[_0xfcb3('0x3e')]('phone\x20NOT\x20IN\x20(?)',squel[_0xfcb3('0x6f')]()['field'](_0xfcb3('0x79'))[_0xfcb3('0x74')](_0xfcb3('0x7a'))[_0xfcb3('0x3e')](_0xfcb3('0x7b'),_0x400651[_0xfcb3('0x47')]['id'][_0xfcb3('0x72')]()))[_0xfcb3('0x3e')]('phone\x20NOT\x20IN\x20(?)',squel['select']()[_0xfcb3('0x70')](_0xfcb3('0x7c'))[_0xfcb3('0x74')](_0xfcb3('0x7d'))[_0xfcb3('0x3e')](_0xfcb3('0x7b'),_0x400651[_0xfcb3('0x47')]['id'][_0xfcb3('0x72')]())))[_0xfcb3('0x72')]();break;case'onlyIfOpen':_0x1f906f=squel[_0xfcb3('0x69')]()[_0xfcb3('0x7e')](_0xfcb3('0x7d'))[_0xfcb3('0x6a')]([_0xfcb3('0x6b'),_0xfcb3('0x6c'),_0xfcb3('0x6d'),'ListId','CampaignId',_0xfcb3('0x53'),'updatedAt'],squel[_0xfcb3('0x6f')]()[_0xfcb3('0x70')](_0xfcb3('0x6b'),'phone')[_0xfcb3('0x70')]('NOW()',_0xfcb3('0x6c'))['field']('id',_0xfcb3('0x6d'))[_0xfcb3('0x70')](_0x1d4d86[_0xfcb3('0x71')][_0xfcb3('0x72')](),_0xfcb3('0x6e'))[_0xfcb3('0x70')](_0x400651[_0xfcb3('0x47')]['id'][_0xfcb3('0x72')](),'CampaignId')[_0xfcb3('0x70')](_0xfcb3('0x73'),_0xfcb3('0x53'))['field'](_0xfcb3('0x73'),_0xfcb3('0x54'))[_0xfcb3('0x74')](_0xfcb3('0x75'))[_0xfcb3('0x3e')](_0xfcb3('0x76'))['where'](_0xfcb3('0x77'),_0x1d4d86[_0xfcb3('0x71')]['toString']())[_0xfcb3('0x3e')]('phone\x20IS\x20NOT\x20NULL')['where']('phone\x20NOT\x20IN\x20(?)',squel[_0xfcb3('0x6f')]()[_0xfcb3('0x70')](_0xfcb3('0x7c'))[_0xfcb3('0x74')](_0xfcb3('0x7d'))['where'](_0xfcb3('0x7b'),_0x400651[_0xfcb3('0x47')]['id'][_0xfcb3('0x72')]())))['toString']();break;default:_0x1f906f=squel['insert']()[_0xfcb3('0x7e')](_0xfcb3('0x7d'))[_0xfcb3('0x6a')]([_0xfcb3('0x6b'),_0xfcb3('0x6c'),_0xfcb3('0x6d'),_0xfcb3('0x6e'),'CampaignId','createdAt',_0xfcb3('0x54')],squel[_0xfcb3('0x6f')]()['field'](_0xfcb3('0x6b'),_0xfcb3('0x6b'))['field'](_0xfcb3('0x73'),_0xfcb3('0x6c'))[_0xfcb3('0x70')]('id',_0xfcb3('0x6d'))[_0xfcb3('0x70')](_0x1d4d86[_0xfcb3('0x71')][_0xfcb3('0x72')](),_0xfcb3('0x6e'))['field'](_0x400651[_0xfcb3('0x47')]['id'][_0xfcb3('0x72')](),'CampaignId')['field']('NOW()',_0xfcb3('0x53'))[_0xfcb3('0x70')](_0xfcb3('0x73'),'updatedAt')[_0xfcb3('0x74')](_0xfcb3('0x75'))['where'](_0xfcb3('0x76'))[_0xfcb3('0x3e')](_0xfcb3('0x77'),_0x1d4d86[_0xfcb3('0x71')][_0xfcb3('0x72')]())['where'](_0xfcb3('0x78')))[_0xfcb3('0x72')]();}_0x6c23ea[_0xfcb3('0x7f')](db['sequelize'][_0xfcb3('0x34')](_0x1f906f));}return BPromise[_0xfcb3('0x80')](_0x6c23ea);}})[_0xfcb3('0x23')](function(){return _0x510811;})[_0xfcb3('0x23')](respondWithResult(_0x45b10e,null))[_0xfcb3('0x45')](handleError(_0x45b10e,null));};exports[_0xfcb3('0x81')]=function(_0x53ae8e,_0x39c94c,_0x2ab3fb){return db['Campaign']['find']({'where':{'id':_0x53ae8e['params']['id']}})[_0xfcb3('0x23')](handleEntityNotFound(_0x39c94c,null))['then'](function(_0x8ab8e9){if(_0x8ab8e9){return _0x8ab8e9['removeLists'](_0x53ae8e[_0xfcb3('0x34')][_0xfcb3('0x65')]);}})['then'](function(_0x23269d){if(_0x23269d){return db['CmHopper'][_0xfcb3('0x27')]({'where':{'ListId':_0x53ae8e['query'][_0xfcb3('0x65')],'CampaignId':_0x53ae8e[_0xfcb3('0x47')]['id']}})[_0xfcb3('0x23')](function(){return _0x23269d;});}})['then'](respondWithStatusCode(_0x39c94c,null))['catch'](handleError(_0x39c94c,null));};exports[_0xfcb3('0x82')]=function(_0x11e0ca,_0x3a86f9,_0x63b1c0){var _0x47dc86={};var _0x56bb10={};var _0x2f2da0;var _0x532cb7;return db[_0xfcb3('0x2d')][_0xfcb3('0x57')]({'where':{'id':_0x11e0ca[_0xfcb3('0x47')]['id']}})[_0xfcb3('0x23')](handleEntityNotFound(_0x3a86f9,null))[_0xfcb3('0x23')](function(_0x346296){if(_0x346296){_0x2f2da0=_0x346296;_0x56bb10['model']=_[_0xfcb3('0x35')](db[_0xfcb3('0x63')][_0xfcb3('0x2e')]);_0x56bb10['query']=_['keys'](_0x11e0ca[_0xfcb3('0x34')]);_0x56bb10[_0xfcb3('0x36')]=_[_0xfcb3('0x37')](_0x56bb10['model'],_0x56bb10[_0xfcb3('0x34')]);_0x47dc86[_0xfcb3('0x39')]=_[_0xfcb3('0x37')](_0x56bb10[_0xfcb3('0x32')],qs['fields'](_0x11e0ca[_0xfcb3('0x34')][_0xfcb3('0x38')]));_0x47dc86[_0xfcb3('0x39')]=_0x47dc86[_0xfcb3('0x39')]['length']?_0x47dc86['attributes']:_0x56bb10[_0xfcb3('0x32')];_0x47dc86[_0xfcb3('0x59')]=qs['sort'](_0x11e0ca[_0xfcb3('0x34')][_0xfcb3('0x3d')]);_0x47dc86[_0xfcb3('0x3e')]=qs[_0xfcb3('0x36')](_[_0xfcb3('0x5a')](_0x11e0ca['query'],_0x56bb10[_0xfcb3('0x36')]));if(_0x11e0ca[_0xfcb3('0x34')]['filter']){_0x47dc86[_0xfcb3('0x3e')]=_[_0xfcb3('0x41')](_0x47dc86[_0xfcb3('0x3e')],{'$or':_['map'](_0x47dc86[_0xfcb3('0x39')],function(_0x5b69f5){var _0x1c94ae={};_0x1c94ae[_0x5b69f5]={'$like':'%'+_0x11e0ca[_0xfcb3('0x34')][_0xfcb3('0x3f')]+'%'};return _0x1c94ae;})});}_0x47dc86=_[_0xfcb3('0x41')]({},_0x47dc86,_0x11e0ca[_0xfcb3('0x42')]);return _0x2f2da0[_0xfcb3('0x82')](_0x47dc86);}})[_0xfcb3('0x23')](function(_0x5c7834){if(_0x5c7834){_0x532cb7=_0x5c7834[_0xfcb3('0x3a')];if(!_0x11e0ca[_0xfcb3('0x34')]['hasOwnProperty']('nolimit')){_0x47dc86['limit']=qs[_0xfcb3('0x1c')](_0x11e0ca[_0xfcb3('0x34')][_0xfcb3('0x1c')]);_0x47dc86[_0xfcb3('0x1e')]=qs[_0xfcb3('0x1e')](_0x11e0ca['query'][_0xfcb3('0x1e')]);}return _0x2f2da0[_0xfcb3('0x82')](_0x47dc86);}})[_0xfcb3('0x23')](function(_0x4d702b){if(_0x4d702b){return _0x4d702b?{'count':_0x532cb7,'rows':_0x4d702b}:null;}})[_0xfcb3('0x23')](respondWithResult(_0x3a86f9,null))[_0xfcb3('0x45')](handleError(_0x3a86f9,null));};exports[_0xfcb3('0x83')]=function(_0xf26ffb,_0x117549,_0x2b15ac){var _0x54cf5f,_0x52efac;return db[_0xfcb3('0x2d')][_0xfcb3('0x4e')]({'where':{'id':_0xf26ffb['params']['id']}})[_0xfcb3('0x23')](handleEntityNotFound(_0x117549,null))[_0xfcb3('0x23')](function(_0xb64ade){if(_0xb64ade){_0x52efac=_0xb64ade;return _0xb64ade[_0xfcb3('0x83')](_0xf26ffb[_0xfcb3('0x55')][_0xfcb3('0x65')],_[_0xfcb3('0x52')](_0xf26ffb[_0xfcb3('0x55')],[_0xfcb3('0x65'),'id'])||{});}return null;})[_0xfcb3('0x66')](function(_0x21200f){var _0xdc02ae;_0x54cf5f=_0x21200f||[];var _0x48a68e=[];if(_0x21200f){for(var _0x2a09b4=0x0;_0x2a09b4<_0x21200f['length'];_0x2a09b4+=0x1){var _0x3fb7e5=_0x21200f[_0x2a09b4][_0xfcb3('0x24')]({'plain':!![]});_0xdc02ae=squel[_0xfcb3('0x69')]()['into'](_0xfcb3('0x84'))[_0xfcb3('0x6a')]([_0xfcb3('0x6b'),'ContactId',_0xfcb3('0x6e'),_0xfcb3('0x5f'),_0xfcb3('0x53'),_0xfcb3('0x54')],squel[_0xfcb3('0x6f')]()[_0xfcb3('0x70')]('phone','phone')['field']('id',_0xfcb3('0x6d'))['field'](_0x3fb7e5['CmListId'][_0xfcb3('0x72')](),_0xfcb3('0x6e'))[_0xfcb3('0x70')](_0xf26ffb['params']['id'][_0xfcb3('0x72')](),_0xfcb3('0x5f'))['field'](_0xfcb3('0x73'),_0xfcb3('0x53'))[_0xfcb3('0x70')]('NOW()',_0xfcb3('0x54'))[_0xfcb3('0x74')](_0xfcb3('0x75'))[_0xfcb3('0x3e')](_0xfcb3('0x76'))['where'](_0xfcb3('0x77'),_0x3fb7e5['CmListId']['toString']())[_0xfcb3('0x3e')]('phone\x20IS\x20NOT\x20NULL'))[_0xfcb3('0x72')]();_0x48a68e[_0xfcb3('0x7f')](db[_0xfcb3('0x85')]['query'](_0xdc02ae));}return BPromise[_0xfcb3('0x80')](_0x48a68e);}})[_0xfcb3('0x23')](function(){return _0x54cf5f;})['then'](respondWithResult(_0x117549,null))[_0xfcb3('0x45')](handleError(_0x117549,null));};exports['removeBlackLists']=function(_0x3b9d2f,_0x25bbee,_0x2550b8){return db[_0xfcb3('0x2d')][_0xfcb3('0x4e')]({'where':{'id':_0x3b9d2f[_0xfcb3('0x47')]['id']}})[_0xfcb3('0x23')](handleEntityNotFound(_0x25bbee,null))[_0xfcb3('0x23')](function(_0x1b084e){if(_0x1b084e){return _0x1b084e[_0xfcb3('0x86')](_0x3b9d2f[_0xfcb3('0x34')]['ids']);}})[_0xfcb3('0x23')](function(_0x37dcb8){if(_0x37dcb8){return db[_0xfcb3('0x61')]['destroy']({'where':{'ListId':_0x3b9d2f[_0xfcb3('0x34')]['ids'],'CampaignId':_0x3b9d2f[_0xfcb3('0x47')]['id']}})[_0xfcb3('0x23')](function(){return _0x37dcb8;});}})['then'](respondWithStatusCode(_0x25bbee,null))[_0xfcb3('0x45')](handleError(_0x25bbee,null));};
\ No newline at end of file
+var _0x9001=['pick','getHopperFinals','CmHopperFinal','getHopperBlacks','CmHopperBlack','CmList','getLists','addLists','ids','spread','dialCheckDuplicateType','insert','into','cm_hopper','fromQuery','phone','ContactId','ListId','select','field','NOW()','scheduledAt','CmListId','toString','from','cm_contacts','deletedAt\x20IS\x20NULL','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','COALESCE(calleridnum,\x27\x27)','cm_hopper_final','CampaignId\x20=\x20?','onlyIfOpen','ListId\x20=\x20?','push','sequelize','removeLists','getBlackLists','addBlackLists','cm_hopper_black','all','removeBlackLists','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','mustache','util','path','sox','fs-extra','squel','jsforce','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','end','status','json','undefined','limit','count','offset','Content-Range','apply','reject','then','get','IvrCampaigns','destroy','stack','name','send','index','map','Campaign','rawAttributes','fieldName','type','key','model','query','keys','filters','fields','attributes','length','hasOwnProperty','nolimit','order','sort','where','filter','merge','VIRTUAL','options','includeAll','include','rows','catch','show','params','intersection','create','body','user','UserProfileSection','find','userProfileId','autoAssociation','UserProfileResource','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','omit','updatedAt','createdAt','role','update','getHoppers','findOne','CampaignId','CmHopper','findAll','getHopperHistories','CmHopperHistory'];(function(_0x14f127,_0x26a9cc){var _0xb37e2f=function(_0x9dfd63){while(--_0x9dfd63){_0x14f127['push'](_0x14f127['shift']());}};_0xb37e2f(++_0x26a9cc);}(_0x9001,0xaf));var _0x1900=function(_0x2ec07e,_0x132ab2){_0x2ec07e=_0x2ec07e-0x0;var _0x5d55b0=_0x9001[_0x2ec07e];return _0x5d55b0;};'use strict';var emlformat=require(_0x1900('0x0'));var rimraf=require(_0x1900('0x1'));var zipdir=require(_0x1900('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x1900('0x3'));var moment=require(_0x1900('0x4'));var BPromise=require(_0x1900('0x5'));var Mustache=require(_0x1900('0x6'));var util=require(_0x1900('0x7'));var path=require(_0x1900('0x8'));var sox=require(_0x1900('0x9'));var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x1900('0xa'));var _=require('lodash');var squel=require(_0x1900('0xb'));var crypto=require('crypto');var jsforce=require(_0x1900('0xc'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0x1900('0xd'));var Redis=require(_0x1900('0xe'));var authService=require(_0x1900('0xf'));var qs=require(_0x1900('0x10'));var as=require(_0x1900('0x11'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x1900('0x12'))(_0x1900('0x13'));var utils=require(_0x1900('0x14'));var config=require(_0x1900('0x15'));var licenseUtil=require(_0x1900('0x16'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x2fa469,_0x2b1890){_0x2b1890=_0x2b1890||0xcc;return function(_0x5cda5f){if(_0x5cda5f){return _0x2fa469['sendStatus'](_0x2b1890);}return _0x2fa469['status'](_0x2b1890)[_0x1900('0x17')]();};}function respondWithResult(_0x27bbdd,_0x4f2cf3){_0x4f2cf3=_0x4f2cf3||0xc8;return function(_0x2643db){if(_0x2643db){return _0x27bbdd[_0x1900('0x18')](_0x4f2cf3)[_0x1900('0x19')](_0x2643db);}};}function respondWithFilteredResult(_0x425150,_0x340b4a){return function(_0x26913c){if(_0x26913c){var _0x56bf71=typeof _0x340b4a['offset']===_0x1900('0x1a')&&typeof _0x340b4a[_0x1900('0x1b')]===_0x1900('0x1a');var _0x3adc2c=_0x26913c[_0x1900('0x1c')];var _0xbb16bd=_0x56bf71?0x0:_0x340b4a[_0x1900('0x1d')];var _0x3a064f=_0x56bf71?_0x26913c[_0x1900('0x1c')]:_0x340b4a[_0x1900('0x1d')]+_0x340b4a['limit'];var _0x5934d7;if(_0x3a064f>=_0x3adc2c){_0x3a064f=_0x3adc2c;_0x5934d7=0xc8;}else{_0x5934d7=0xce;}_0x425150[_0x1900('0x18')](_0x5934d7);return _0x425150['set'](_0x1900('0x1e'),_0xbb16bd+'-'+_0x3a064f+'/'+_0x3adc2c)[_0x1900('0x19')](_0x26913c);}return null;};}function patchUpdates(_0x2104d0){return function(_0x16397b){try{jsonpatch[_0x1900('0x1f')](_0x16397b,_0x2104d0,!![]);}catch(_0x26ed2e){return BPromise[_0x1900('0x20')](_0x26ed2e);}return _0x16397b['save']();};}function saveUpdates(_0x381b26,_0x35983f){return function(_0x55e912){if(_0x55e912){return _0x55e912['update'](_0x381b26)[_0x1900('0x21')](function(_0x116050){return _0x116050;});}return null;};}function removeEntity(_0x692d36,_0x581512){return function(_0x404611){if(_0x404611){return _0x404611['destroy']()[_0x1900('0x21')](function(){var _0x542317=_0x404611[_0x1900('0x22')]({'plain':!![]});var _0x157b29=_0x1900('0x23');return db['UserProfileResource'][_0x1900('0x24')]({'where':{'type':_0x157b29,'resourceId':_0x542317['id']}})[_0x1900('0x21')](function(){return _0x404611;});})[_0x1900('0x21')](function(){_0x692d36[_0x1900('0x18')](0xcc)[_0x1900('0x17')]();});}};}function handleEntityNotFound(_0x3291a1,_0x9543ba){return function(_0xe69df8){if(!_0xe69df8){_0x3291a1['sendStatus'](0x194);}return _0xe69df8;};}function handleError(_0x4581ae,_0x25a93b){_0x25a93b=_0x25a93b||0x1f4;return function(_0x309a20){logger['error'](_0x309a20[_0x1900('0x25')]);if(_0x309a20[_0x1900('0x26')]){delete _0x309a20[_0x1900('0x26')];}_0x4581ae[_0x1900('0x18')](_0x25a93b)[_0x1900('0x27')](_0x309a20);};}exports[_0x1900('0x28')]=function(_0x35b3af,_0x3c4b46){var _0x53375c={},_0x17646c={},_0x4f77da={'count':0x0,'rows':[]};var _0x36a631=_[_0x1900('0x29')](db[_0x1900('0x2a')][_0x1900('0x2b')],function(_0x44b5fa){return{'name':_0x44b5fa[_0x1900('0x2c')],'type':_0x44b5fa[_0x1900('0x2d')][_0x1900('0x2e')]};});_0x17646c[_0x1900('0x2f')]=_[_0x1900('0x29')](_0x36a631,_0x1900('0x26'));_0x17646c[_0x1900('0x30')]=_[_0x1900('0x31')](_0x35b3af[_0x1900('0x30')]);_0x17646c[_0x1900('0x32')]=_['intersection'](_0x17646c[_0x1900('0x2f')],_0x17646c[_0x1900('0x30')]);_0x53375c['attributes']=_['intersection'](_0x17646c[_0x1900('0x2f')],qs['fields'](_0x35b3af['query'][_0x1900('0x33')]));_0x53375c[_0x1900('0x34')]=_0x53375c[_0x1900('0x34')][_0x1900('0x35')]?_0x53375c[_0x1900('0x34')]:_0x17646c['model'];if(!_0x35b3af[_0x1900('0x30')][_0x1900('0x36')](_0x1900('0x37'))){_0x53375c[_0x1900('0x1b')]=qs['limit'](_0x35b3af[_0x1900('0x30')][_0x1900('0x1b')]);_0x53375c['offset']=qs[_0x1900('0x1d')](_0x35b3af[_0x1900('0x30')][_0x1900('0x1d')]);}_0x53375c[_0x1900('0x38')]=qs[_0x1900('0x39')](_0x35b3af['query'][_0x1900('0x39')]);_0x53375c[_0x1900('0x3a')]=qs[_0x1900('0x32')](_['pick'](_0x35b3af['query'],_0x17646c['filters']),_0x36a631);if(_0x35b3af[_0x1900('0x30')][_0x1900('0x3b')]){_0x53375c[_0x1900('0x3a')]=_[_0x1900('0x3c')](_0x53375c[_0x1900('0x3a')],{'$or':_[_0x1900('0x29')](_0x36a631,function(_0x131c74){if(_0x131c74['type']!==_0x1900('0x3d')){var _0x401993={};_0x401993[_0x131c74[_0x1900('0x26')]]={'$like':'%'+_0x35b3af[_0x1900('0x30')][_0x1900('0x3b')]+'%'};return _0x401993;}})});}_0x53375c=_[_0x1900('0x3c')]({},_0x53375c,_0x35b3af[_0x1900('0x3e')]);var _0x2a309f={'where':_0x53375c[_0x1900('0x3a')]};return db['Campaign']['count'](_0x2a309f)[_0x1900('0x21')](function(_0x3bb6d9){_0x4f77da[_0x1900('0x1c')]=_0x3bb6d9;if(_0x35b3af[_0x1900('0x30')][_0x1900('0x3f')]){_0x53375c[_0x1900('0x40')]=[{'all':!![]}];}return db['Campaign']['findAll'](_0x53375c);})[_0x1900('0x21')](function(_0x46e7af){_0x4f77da[_0x1900('0x41')]=_0x46e7af;return _0x4f77da;})[_0x1900('0x21')](respondWithFilteredResult(_0x3c4b46,_0x53375c))[_0x1900('0x42')](handleError(_0x3c4b46,null));};exports[_0x1900('0x43')]=function(_0x28eec4,_0x505901){var _0x4a5d9e={'raw':![],'where':{'id':_0x28eec4[_0x1900('0x44')]['id']}},_0x546035={};_0x546035[_0x1900('0x2f')]=_[_0x1900('0x31')](db[_0x1900('0x2a')][_0x1900('0x2b')]);_0x546035[_0x1900('0x30')]=_['keys'](_0x28eec4[_0x1900('0x30')]);_0x546035[_0x1900('0x32')]=_[_0x1900('0x45')](_0x546035['model'],_0x546035[_0x1900('0x30')]);_0x4a5d9e[_0x1900('0x34')]=_[_0x1900('0x45')](_0x546035[_0x1900('0x2f')],qs['fields'](_0x28eec4[_0x1900('0x30')][_0x1900('0x33')]));_0x4a5d9e[_0x1900('0x34')]=_0x4a5d9e['attributes']['length']?_0x4a5d9e[_0x1900('0x34')]:_0x546035[_0x1900('0x2f')];if(_0x28eec4[_0x1900('0x30')][_0x1900('0x3f')]){_0x4a5d9e[_0x1900('0x40')]=[{'all':!![]}];}_0x4a5d9e=_['merge']({},_0x4a5d9e,_0x28eec4[_0x1900('0x3e')]);return db[_0x1900('0x2a')]['find'](_0x4a5d9e)[_0x1900('0x21')](handleEntityNotFound(_0x505901,null))[_0x1900('0x21')](respondWithResult(_0x505901,null))[_0x1900('0x42')](handleError(_0x505901,null));};exports[_0x1900('0x46')]=function(_0x3a290f,_0x153829){return db[_0x1900('0x2a')][_0x1900('0x46')](_0x3a290f[_0x1900('0x47')],{})['then'](function(_0x3f8c0f){var _0x26bd9d=_0x3a290f[_0x1900('0x48')][_0x1900('0x22')]({'plain':!![]});if(!_0x26bd9d)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x26bd9d['role']==='user'){var _0x1603d3=_0x3f8c0f['get']({'plain':!![]});var _0x47324f=_0x1900('0x23');return db[_0x1900('0x49')][_0x1900('0x4a')]({'where':{'name':_0x47324f,'userProfileId':_0x26bd9d[_0x1900('0x4b')]},'raw':!![]})[_0x1900('0x21')](function(_0x2e9ff9){if(_0x2e9ff9&&_0x2e9ff9[_0x1900('0x4c')]===0x0){return db[_0x1900('0x4d')]['create']({'name':_0x1603d3['name'],'resourceId':_0x1603d3['id'],'type':_0x2e9ff9[_0x1900('0x26')],'sectionId':_0x2e9ff9['id']},{})[_0x1900('0x21')](function(){return _0x3f8c0f;});}else{return _0x3f8c0f;}})[_0x1900('0x42')](function(_0x31be10){logger['error'](_0x1900('0x4e'),_0x31be10);throw _0x31be10;});}return _0x3f8c0f;})[_0x1900('0x21')](respondWithResult(_0x153829,0xc9))['catch'](handleError(_0x153829,null));};exports['clone']=function(_0x112c7c,_0x2d1108){var _0x13ffa3={'where':{'id':_0x112c7c[_0x1900('0x44')]['id']}},_0x468671={};_0x468671['model']=_[_0x1900('0x31')](db[_0x1900('0x2a')]['rawAttributes']);_0x13ffa3[_0x1900('0x34')]=_['intersection'](_0x468671[_0x1900('0x2f')],qs['fields'](_0x112c7c[_0x1900('0x30')][_0x1900('0x33')]));_0x13ffa3['attributes']=_0x13ffa3['attributes']['length']?_0x13ffa3[_0x1900('0x34')]:_0x468671[_0x1900('0x2f')];if(_0x112c7c[_0x1900('0x30')]['includeAll']){_0x13ffa3[_0x1900('0x40')]=[{'all':!![]}];}_0x13ffa3=_[_0x1900('0x3c')]({},_0x13ffa3,_0x112c7c[_0x1900('0x3e')]);return db[_0x1900('0x2a')][_0x1900('0x4a')](_0x13ffa3)['then'](handleEntityNotFound(_0x2d1108,null))[_0x1900('0x21')](function(_0x330098){if(_0x330098){var _0x2b0fe0=_0x330098[_0x1900('0x22')]({'plain':!![]});_0x2b0fe0=qs[_0x1900('0x4f')](_0x2b0fe0,['id','createdAt',_0x1900('0x50')]);_0x112c7c[_0x1900('0x47')]=_[_0x1900('0x4f')](_0x112c7c[_0x1900('0x47')],['id',_0x1900('0x51'),_0x1900('0x50')]);return db[_0x1900('0x2a')][_0x1900('0x46')](_[_0x1900('0x3c')](_0x2b0fe0,_0x112c7c[_0x1900('0x47')]),{'include':_0x112c7c[_0x1900('0x30')][_0x1900('0x3f')]?[{'all':!![]}]:undefined})['then'](function(_0x45bf2c){var _0x34c89a=_0x112c7c[_0x1900('0x48')][_0x1900('0x22')]({'plain':!![]});if(!_0x34c89a)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x34c89a[_0x1900('0x52')]===_0x1900('0x48')){var _0x1fddef=_0x45bf2c[_0x1900('0x22')]({'plain':!![]});var _0x1d3d79=_0x1900('0x23');return db['UserProfileSection'][_0x1900('0x4a')]({'where':{'name':_0x1d3d79,'userProfileId':_0x34c89a[_0x1900('0x4b')]},'raw':!![]})['then'](function(_0x1b1af4){if(_0x1b1af4&&_0x1b1af4[_0x1900('0x4c')]===0x0){return db['UserProfileResource'][_0x1900('0x46')]({'name':_0x1fddef['name'],'resourceId':_0x1fddef['id'],'type':_0x1b1af4[_0x1900('0x26')],'sectionId':_0x1b1af4['id']},{})[_0x1900('0x21')](function(){return _0x45bf2c;});}else{return _0x45bf2c;}})[_0x1900('0x42')](function(_0x51a313){logger['error']('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x51a313);throw _0x51a313;});}return _0x45bf2c;});}})[_0x1900('0x21')](respondWithResult(_0x2d1108,0xc9))[_0x1900('0x42')](handleError(_0x2d1108,null));};exports[_0x1900('0x53')]=function(_0x1dfe04,_0x124d88){if(_0x1dfe04[_0x1900('0x47')]['id']){delete _0x1dfe04[_0x1900('0x47')]['id'];}return db[_0x1900('0x2a')][_0x1900('0x4a')]({'where':{'id':_0x1dfe04[_0x1900('0x44')]['id']}})[_0x1900('0x21')](handleEntityNotFound(_0x124d88,null))[_0x1900('0x21')](saveUpdates(_0x1dfe04[_0x1900('0x47')],null))[_0x1900('0x21')](respondWithResult(_0x124d88,null))[_0x1900('0x42')](handleError(_0x124d88,null));};exports[_0x1900('0x24')]=function(_0x2d98ff,_0x5d94e2){return db[_0x1900('0x2a')][_0x1900('0x4a')]({'where':{'id':_0x2d98ff[_0x1900('0x44')]['id']}})[_0x1900('0x21')](handleEntityNotFound(_0x5d94e2,null))[_0x1900('0x21')](removeEntity(_0x5d94e2,null))[_0x1900('0x42')](handleError(_0x5d94e2,null));};exports[_0x1900('0x54')]=function(_0xd9c9c0,_0x4054a9,_0x112479){var _0x152b29={'raw':!![],'where':{}};var _0x56ff00={};var _0x123afc={'count':0x0,'rows':[]};return db['Campaign'][_0x1900('0x55')]({'where':{'id':_0xd9c9c0[_0x1900('0x44')]['id']}})['then'](handleEntityNotFound(_0x4054a9,null))[_0x1900('0x21')](function(_0x4da238){if(_0x4da238){_0x56ff00['model']=_[_0x1900('0x31')](db['CmHopper'][_0x1900('0x2b')]);_0x56ff00[_0x1900('0x30')]=_[_0x1900('0x31')](_0xd9c9c0['query']);_0x56ff00['filters']=_['intersection'](_0x56ff00[_0x1900('0x2f')],_0x56ff00[_0x1900('0x30')]);_0x152b29['attributes']=_[_0x1900('0x45')](_0x56ff00[_0x1900('0x2f')],qs[_0x1900('0x33')](_0xd9c9c0[_0x1900('0x30')]['fields']));_0x152b29['attributes']=_0x152b29[_0x1900('0x34')][_0x1900('0x35')]?_0x152b29[_0x1900('0x34')]:_0x56ff00[_0x1900('0x2f')];if(!_0xd9c9c0['query'][_0x1900('0x36')](_0x1900('0x37'))){_0x152b29[_0x1900('0x1b')]=qs[_0x1900('0x1b')](_0xd9c9c0[_0x1900('0x30')]['limit']);_0x152b29['offset']=qs['offset'](_0xd9c9c0[_0x1900('0x30')][_0x1900('0x1d')]);}_0x152b29[_0x1900('0x38')]=qs['sort'](_0xd9c9c0[_0x1900('0x30')]['sort']);_0x152b29[_0x1900('0x3a')]=qs[_0x1900('0x32')](_['pick'](_0xd9c9c0[_0x1900('0x30')],_0x56ff00[_0x1900('0x32')]));_0x152b29[_0x1900('0x3a')][_0x1900('0x56')]=_0x4da238['id'];if(_0xd9c9c0[_0x1900('0x30')][_0x1900('0x3b')]){_0x152b29[_0x1900('0x3a')]=_['merge'](_0x152b29[_0x1900('0x3a')],{'$or':_[_0x1900('0x29')](_0x152b29[_0x1900('0x34')],function(_0x44b0c9){var _0x4e538b={};_0x4e538b[_0x44b0c9]={'$like':'%'+_0xd9c9c0[_0x1900('0x30')][_0x1900('0x3b')]+'%'};return _0x4e538b;})});}_0x152b29=_['merge']({},_0x152b29,_0xd9c9c0['options']);return db['CmHopper'][_0x1900('0x1c')]({'where':_0x152b29['where']})[_0x1900('0x21')](function(_0x29e4fb){_0x123afc[_0x1900('0x1c')]=_0x29e4fb;if(_0xd9c9c0[_0x1900('0x30')][_0x1900('0x3f')]){_0x152b29[_0x1900('0x40')]=[{'all':!![]}];}return db[_0x1900('0x57')][_0x1900('0x58')](_0x152b29);})[_0x1900('0x21')](function(_0x58ff3f){_0x123afc[_0x1900('0x41')]=_0x58ff3f;return _0x123afc;});}})[_0x1900('0x21')](respondWithFilteredResult(_0x4054a9,_0x152b29))['catch'](handleError(_0x4054a9,null));};exports[_0x1900('0x59')]=function(_0x11e87f,_0x2f22b2,_0x3b330a){var _0x1a1289={'raw':!![],'where':{}};var _0xdd5be3={};var _0x4f3b70={'count':0x0,'rows':[]};return db['Campaign'][_0x1900('0x55')]({'where':{'id':_0x11e87f[_0x1900('0x44')]['id']}})[_0x1900('0x21')](handleEntityNotFound(_0x2f22b2,null))[_0x1900('0x21')](function(_0x4fddea){if(_0x4fddea){_0xdd5be3[_0x1900('0x2f')]=_[_0x1900('0x31')](db[_0x1900('0x5a')][_0x1900('0x2b')]);_0xdd5be3['query']=_[_0x1900('0x31')](_0x11e87f[_0x1900('0x30')]);_0xdd5be3[_0x1900('0x32')]=_[_0x1900('0x45')](_0xdd5be3[_0x1900('0x2f')],_0xdd5be3[_0x1900('0x30')]);_0x1a1289['attributes']=_[_0x1900('0x45')](_0xdd5be3[_0x1900('0x2f')],qs['fields'](_0x11e87f[_0x1900('0x30')]['fields']));_0x1a1289[_0x1900('0x34')]=_0x1a1289['attributes'][_0x1900('0x35')]?_0x1a1289['attributes']:_0xdd5be3[_0x1900('0x2f')];if(!_0x11e87f['query']['hasOwnProperty'](_0x1900('0x37'))){_0x1a1289['limit']=qs[_0x1900('0x1b')](_0x11e87f[_0x1900('0x30')][_0x1900('0x1b')]);_0x1a1289[_0x1900('0x1d')]=qs[_0x1900('0x1d')](_0x11e87f[_0x1900('0x30')][_0x1900('0x1d')]);}_0x1a1289[_0x1900('0x38')]=qs[_0x1900('0x39')](_0x11e87f[_0x1900('0x30')]['sort']);_0x1a1289['where']=qs[_0x1900('0x32')](_[_0x1900('0x5b')](_0x11e87f[_0x1900('0x30')],_0xdd5be3[_0x1900('0x32')]));_0x1a1289[_0x1900('0x3a')][_0x1900('0x56')]=_0x4fddea['id'];if(_0x11e87f[_0x1900('0x30')][_0x1900('0x3b')]){_0x1a1289[_0x1900('0x3a')]=_[_0x1900('0x3c')](_0x1a1289[_0x1900('0x3a')],{'$or':_[_0x1900('0x29')](_0x1a1289[_0x1900('0x34')],function(_0x4784af){var _0x4d010d={};_0x4d010d[_0x4784af]={'$like':'%'+_0x11e87f['query'][_0x1900('0x3b')]+'%'};return _0x4d010d;})});}_0x1a1289=_[_0x1900('0x3c')]({},_0x1a1289,_0x11e87f[_0x1900('0x3e')]);return db['CmHopperHistory'][_0x1900('0x1c')]({'where':_0x1a1289[_0x1900('0x3a')]})[_0x1900('0x21')](function(_0x5eb039){_0x4f3b70[_0x1900('0x1c')]=_0x5eb039;if(_0x11e87f[_0x1900('0x30')][_0x1900('0x3f')]){_0x1a1289['include']=[{'all':!![]}];}return db[_0x1900('0x5a')]['findAll'](_0x1a1289);})[_0x1900('0x21')](function(_0x3f6f72){_0x4f3b70[_0x1900('0x41')]=_0x3f6f72;return _0x4f3b70;});}})[_0x1900('0x21')](respondWithFilteredResult(_0x2f22b2,_0x1a1289))[_0x1900('0x42')](handleError(_0x2f22b2,null));};exports[_0x1900('0x5c')]=function(_0x328bbd,_0x56eda1,_0x4e84e1){var _0x3cd003={'raw':!![],'where':{}};var _0x3e4050={};var _0x392c5a={'count':0x0,'rows':[]};return db[_0x1900('0x2a')][_0x1900('0x55')]({'where':{'id':_0x328bbd['params']['id']}})[_0x1900('0x21')](handleEntityNotFound(_0x56eda1,null))['then'](function(_0xf50ddb){if(_0xf50ddb){_0x3e4050[_0x1900('0x2f')]=_[_0x1900('0x31')](db['CmHopperFinal'][_0x1900('0x2b')]);_0x3e4050[_0x1900('0x30')]=_['keys'](_0x328bbd[_0x1900('0x30')]);_0x3e4050[_0x1900('0x32')]=_[_0x1900('0x45')](_0x3e4050[_0x1900('0x2f')],_0x3e4050[_0x1900('0x30')]);_0x3cd003[_0x1900('0x34')]=_[_0x1900('0x45')](_0x3e4050['model'],qs[_0x1900('0x33')](_0x328bbd[_0x1900('0x30')][_0x1900('0x33')]));_0x3cd003[_0x1900('0x34')]=_0x3cd003[_0x1900('0x34')][_0x1900('0x35')]?_0x3cd003['attributes']:_0x3e4050['model'];if(!_0x328bbd['query'][_0x1900('0x36')](_0x1900('0x37'))){_0x3cd003[_0x1900('0x1b')]=qs[_0x1900('0x1b')](_0x328bbd['query'][_0x1900('0x1b')]);_0x3cd003[_0x1900('0x1d')]=qs['offset'](_0x328bbd[_0x1900('0x30')][_0x1900('0x1d')]);}_0x3cd003[_0x1900('0x38')]=qs['sort'](_0x328bbd['query'][_0x1900('0x39')]);_0x3cd003['where']=qs[_0x1900('0x32')](_[_0x1900('0x5b')](_0x328bbd[_0x1900('0x30')],_0x3e4050['filters']));_0x3cd003[_0x1900('0x3a')][_0x1900('0x56')]=_0xf50ddb['id'];if(_0x328bbd[_0x1900('0x30')][_0x1900('0x3b')]){_0x3cd003[_0x1900('0x3a')]=_[_0x1900('0x3c')](_0x3cd003[_0x1900('0x3a')],{'$or':_[_0x1900('0x29')](_0x3cd003['attributes'],function(_0x3b205e){var _0x45cf18={};_0x45cf18[_0x3b205e]={'$like':'%'+_0x328bbd[_0x1900('0x30')][_0x1900('0x3b')]+'%'};return _0x45cf18;})});}_0x3cd003=_[_0x1900('0x3c')]({},_0x3cd003,_0x328bbd[_0x1900('0x3e')]);return db[_0x1900('0x5d')][_0x1900('0x1c')]({'where':_0x3cd003[_0x1900('0x3a')]})[_0x1900('0x21')](function(_0x131ce0){_0x392c5a[_0x1900('0x1c')]=_0x131ce0;if(_0x328bbd['query'][_0x1900('0x3f')]){_0x3cd003[_0x1900('0x40')]=[{'all':!![]}];}return db[_0x1900('0x5d')][_0x1900('0x58')](_0x3cd003);})['then'](function(_0x518473){_0x392c5a[_0x1900('0x41')]=_0x518473;return _0x392c5a;});}})[_0x1900('0x21')](respondWithFilteredResult(_0x56eda1,_0x3cd003))[_0x1900('0x42')](handleError(_0x56eda1,null));};exports[_0x1900('0x5e')]=function(_0x439547,_0x5ceec5,_0x54e3e9){var _0x375b07={'raw':!![],'where':{}};var _0x5cd73b={};var _0x5755c5={'count':0x0,'rows':[]};return db[_0x1900('0x2a')][_0x1900('0x55')]({'where':{'id':_0x439547['params']['id']}})['then'](handleEntityNotFound(_0x5ceec5,null))[_0x1900('0x21')](function(_0x12a72a){if(_0x12a72a){_0x5cd73b['model']=_[_0x1900('0x31')](db['CmHopperBlack'][_0x1900('0x2b')]);_0x5cd73b[_0x1900('0x30')]=_['keys'](_0x439547[_0x1900('0x30')]);_0x5cd73b['filters']=_[_0x1900('0x45')](_0x5cd73b[_0x1900('0x2f')],_0x5cd73b[_0x1900('0x30')]);_0x375b07[_0x1900('0x34')]=_[_0x1900('0x45')](_0x5cd73b[_0x1900('0x2f')],qs[_0x1900('0x33')](_0x439547[_0x1900('0x30')][_0x1900('0x33')]));_0x375b07[_0x1900('0x34')]=_0x375b07[_0x1900('0x34')][_0x1900('0x35')]?_0x375b07[_0x1900('0x34')]:_0x5cd73b[_0x1900('0x2f')];if(!_0x439547[_0x1900('0x30')]['hasOwnProperty'](_0x1900('0x37'))){_0x375b07['limit']=qs[_0x1900('0x1b')](_0x439547['query'][_0x1900('0x1b')]);_0x375b07[_0x1900('0x1d')]=qs[_0x1900('0x1d')](_0x439547[_0x1900('0x30')][_0x1900('0x1d')]);}_0x375b07['order']=qs[_0x1900('0x39')](_0x439547[_0x1900('0x30')][_0x1900('0x39')]);_0x375b07['where']=qs[_0x1900('0x32')](_['pick'](_0x439547[_0x1900('0x30')],_0x5cd73b[_0x1900('0x32')]));_0x375b07['where'][_0x1900('0x56')]=_0x12a72a['id'];if(_0x439547[_0x1900('0x30')]['filter']){_0x375b07[_0x1900('0x3a')]=_['merge'](_0x375b07[_0x1900('0x3a')],{'$or':_[_0x1900('0x29')](_0x375b07['attributes'],function(_0x1a11cd){var _0x45d90e={};_0x45d90e[_0x1a11cd]={'$like':'%'+_0x439547['query'][_0x1900('0x3b')]+'%'};return _0x45d90e;})});}_0x375b07=_[_0x1900('0x3c')]({},_0x375b07,_0x439547[_0x1900('0x3e')]);return db[_0x1900('0x5f')][_0x1900('0x1c')]({'where':_0x375b07[_0x1900('0x3a')]})[_0x1900('0x21')](function(_0x3f8607){_0x5755c5[_0x1900('0x1c')]=_0x3f8607;if(_0x439547['query']['includeAll']){_0x375b07[_0x1900('0x40')]=[{'all':!![]}];}return db[_0x1900('0x5f')][_0x1900('0x58')](_0x375b07);})['then'](function(_0xb575cd){_0x5755c5['rows']=_0xb575cd;return _0x5755c5;});}})['then'](respondWithFilteredResult(_0x5ceec5,_0x375b07))[_0x1900('0x42')](handleError(_0x5ceec5,null));};exports['getLists']=function(_0xa165d0,_0x1b88bd,_0x38cfae){var _0x15cf55={};var _0x3bc781={};var _0x2383ea;var _0x343adb;return db[_0x1900('0x2a')]['findOne']({'where':{'id':_0xa165d0[_0x1900('0x44')]['id']}})[_0x1900('0x21')](handleEntityNotFound(_0x1b88bd,null))[_0x1900('0x21')](function(_0x28ea31){if(_0x28ea31){_0x2383ea=_0x28ea31;_0x3bc781[_0x1900('0x2f')]=_[_0x1900('0x31')](db[_0x1900('0x60')][_0x1900('0x2b')]);_0x3bc781[_0x1900('0x30')]=_[_0x1900('0x31')](_0xa165d0[_0x1900('0x30')]);_0x3bc781['filters']=_['intersection'](_0x3bc781[_0x1900('0x2f')],_0x3bc781[_0x1900('0x30')]);_0x15cf55['attributes']=_[_0x1900('0x45')](_0x3bc781[_0x1900('0x2f')],qs[_0x1900('0x33')](_0xa165d0[_0x1900('0x30')][_0x1900('0x33')]));_0x15cf55[_0x1900('0x34')]=_0x15cf55[_0x1900('0x34')][_0x1900('0x35')]?_0x15cf55[_0x1900('0x34')]:_0x3bc781['model'];_0x15cf55[_0x1900('0x38')]=qs[_0x1900('0x39')](_0xa165d0[_0x1900('0x30')]['sort']);_0x15cf55[_0x1900('0x3a')]=qs[_0x1900('0x32')](_[_0x1900('0x5b')](_0xa165d0[_0x1900('0x30')],_0x3bc781['filters']));if(_0xa165d0[_0x1900('0x30')]['filter']){_0x15cf55['where']=_[_0x1900('0x3c')](_0x15cf55['where'],{'$or':_[_0x1900('0x29')](_0x15cf55[_0x1900('0x34')],function(_0x936571){var _0x28131a={};_0x28131a[_0x936571]={'$like':'%'+_0xa165d0[_0x1900('0x30')][_0x1900('0x3b')]+'%'};return _0x28131a;})});}_0x15cf55=_[_0x1900('0x3c')]({},_0x15cf55,_0xa165d0[_0x1900('0x3e')]);return _0x2383ea[_0x1900('0x61')](_0x15cf55);}})['then'](function(_0x550ba0){if(_0x550ba0){_0x343adb=_0x550ba0[_0x1900('0x35')];if(!_0xa165d0[_0x1900('0x30')][_0x1900('0x36')]('nolimit')){_0x15cf55[_0x1900('0x1b')]=qs[_0x1900('0x1b')](_0xa165d0['query']['limit']);_0x15cf55[_0x1900('0x1d')]=qs[_0x1900('0x1d')](_0xa165d0['query'][_0x1900('0x1d')]);}return _0x2383ea[_0x1900('0x61')](_0x15cf55);}})['then'](function(_0x224137){if(_0x224137){return _0x224137?{'count':_0x343adb,'rows':_0x224137}:null;}})[_0x1900('0x21')](respondWithResult(_0x1b88bd,null))[_0x1900('0x42')](handleError(_0x1b88bd,null));};exports[_0x1900('0x62')]=function(_0x2bf879,_0x1f3598,_0x4a4919){var _0x2db3d7,_0x519524;return db['Campaign'][_0x1900('0x4a')]({'where':{'id':_0x2bf879[_0x1900('0x44')]['id']}})[_0x1900('0x21')](handleEntityNotFound(_0x1f3598,null))[_0x1900('0x21')](function(_0x576db1){if(_0x576db1){_0x519524=_0x576db1;return _0x576db1[_0x1900('0x62')](_0x2bf879[_0x1900('0x47')][_0x1900('0x63')],_[_0x1900('0x4f')](_0x2bf879[_0x1900('0x47')],['ids','id'])||{});}return null;})[_0x1900('0x64')](function(_0x36f0fa){var _0x78cddc;_0x2db3d7=_0x36f0fa||[];var _0x5911c1=[];if(_0x36f0fa){for(var _0x5da04c=0x0;_0x5da04c<_0x36f0fa[_0x1900('0x35')];_0x5da04c+=0x1){var _0x3c97c5=_0x36f0fa[_0x5da04c]['get']({'plain':!![]});_0x519524[_0x1900('0x65')]=_0x2bf879[_0x1900('0x47')]['dialCheckDuplicateType']?_0x2bf879[_0x1900('0x47')]['dialCheckDuplicateType']:_0x519524[_0x1900('0x65')];switch(_0x519524[_0x1900('0x65')]){case'always':_0x78cddc=squel[_0x1900('0x66')]()[_0x1900('0x67')](_0x1900('0x68'))[_0x1900('0x69')]([_0x1900('0x6a'),'scheduledAt',_0x1900('0x6b'),_0x1900('0x6c'),'CampaignId','createdAt','updatedAt'],squel[_0x1900('0x6d')]()[_0x1900('0x6e')](_0x1900('0x6a'),_0x1900('0x6a'))[_0x1900('0x6e')](_0x1900('0x6f'),_0x1900('0x70'))[_0x1900('0x6e')]('id',_0x1900('0x6b'))[_0x1900('0x6e')](_0x3c97c5[_0x1900('0x71')][_0x1900('0x72')](),_0x1900('0x6c'))[_0x1900('0x6e')](_0x2bf879['params']['id']['toString'](),'CampaignId')[_0x1900('0x6e')](_0x1900('0x6f'),_0x1900('0x51'))[_0x1900('0x6e')](_0x1900('0x6f'),_0x1900('0x50'))[_0x1900('0x73')](_0x1900('0x74'))[_0x1900('0x3a')](_0x1900('0x75'))[_0x1900('0x3a')]('ListId\x20=\x20?',_0x3c97c5[_0x1900('0x71')][_0x1900('0x72')]())[_0x1900('0x3a')](_0x1900('0x76'))[_0x1900('0x3a')](_0x1900('0x77'),squel[_0x1900('0x6d')]()[_0x1900('0x6e')](_0x1900('0x78'))[_0x1900('0x73')](_0x1900('0x79'))[_0x1900('0x3a')]('CampaignId\x20=\x20?',_0x2bf879[_0x1900('0x44')]['id'][_0x1900('0x72')]()))[_0x1900('0x3a')]('phone\x20NOT\x20IN\x20(?)',squel[_0x1900('0x6d')]()[_0x1900('0x6e')]('COALESCE(phone,\x27\x27)')[_0x1900('0x73')]('cm_hopper')[_0x1900('0x3a')](_0x1900('0x7a'),_0x2bf879[_0x1900('0x44')]['id'][_0x1900('0x72')]())))[_0x1900('0x72')]();break;case _0x1900('0x7b'):_0x78cddc=squel[_0x1900('0x66')]()[_0x1900('0x67')]('cm_hopper')[_0x1900('0x69')]([_0x1900('0x6a'),_0x1900('0x70'),_0x1900('0x6b'),_0x1900('0x6c'),_0x1900('0x56'),'createdAt',_0x1900('0x50')],squel[_0x1900('0x6d')]()[_0x1900('0x6e')](_0x1900('0x6a'),_0x1900('0x6a'))[_0x1900('0x6e')](_0x1900('0x6f'),'scheduledAt')[_0x1900('0x6e')]('id',_0x1900('0x6b'))[_0x1900('0x6e')](_0x3c97c5[_0x1900('0x71')][_0x1900('0x72')](),'ListId')['field'](_0x2bf879['params']['id'][_0x1900('0x72')](),_0x1900('0x56'))[_0x1900('0x6e')](_0x1900('0x6f'),'createdAt')[_0x1900('0x6e')](_0x1900('0x6f'),_0x1900('0x50'))[_0x1900('0x73')]('cm_contacts')[_0x1900('0x3a')](_0x1900('0x75'))[_0x1900('0x3a')](_0x1900('0x7c'),_0x3c97c5[_0x1900('0x71')][_0x1900('0x72')]())['where']('phone\x20IS\x20NOT\x20NULL')[_0x1900('0x3a')](_0x1900('0x77'),squel[_0x1900('0x6d')]()[_0x1900('0x6e')]('COALESCE(phone,\x27\x27)')['from']('cm_hopper')[_0x1900('0x3a')]('CampaignId\x20=\x20?',_0x2bf879[_0x1900('0x44')]['id'][_0x1900('0x72')]())))[_0x1900('0x72')]();break;default:_0x78cddc=squel['insert']()[_0x1900('0x67')]('cm_hopper')[_0x1900('0x69')](['phone',_0x1900('0x70'),_0x1900('0x6b'),'ListId','CampaignId',_0x1900('0x51'),_0x1900('0x50')],squel[_0x1900('0x6d')]()[_0x1900('0x6e')](_0x1900('0x6a'),_0x1900('0x6a'))[_0x1900('0x6e')](_0x1900('0x6f'),_0x1900('0x70'))[_0x1900('0x6e')]('id',_0x1900('0x6b'))[_0x1900('0x6e')](_0x3c97c5[_0x1900('0x71')][_0x1900('0x72')](),_0x1900('0x6c'))['field'](_0x2bf879[_0x1900('0x44')]['id']['toString'](),_0x1900('0x56'))[_0x1900('0x6e')](_0x1900('0x6f'),_0x1900('0x51'))[_0x1900('0x6e')](_0x1900('0x6f'),_0x1900('0x50'))[_0x1900('0x73')](_0x1900('0x74'))['where'](_0x1900('0x75'))['where'](_0x1900('0x7c'),_0x3c97c5['CmListId'][_0x1900('0x72')]())[_0x1900('0x3a')](_0x1900('0x76')))[_0x1900('0x72')]();}_0x5911c1[_0x1900('0x7d')](db[_0x1900('0x7e')][_0x1900('0x30')](_0x78cddc));}return BPromise['all'](_0x5911c1);}})[_0x1900('0x21')](function(){return _0x2db3d7;})['then'](respondWithResult(_0x1f3598,null))[_0x1900('0x42')](handleError(_0x1f3598,null));};exports[_0x1900('0x7f')]=function(_0x1bca7c,_0x458fd4,_0x4d52f7){return db[_0x1900('0x2a')][_0x1900('0x4a')]({'where':{'id':_0x1bca7c['params']['id']}})[_0x1900('0x21')](handleEntityNotFound(_0x458fd4,null))['then'](function(_0x1b5657){if(_0x1b5657){return _0x1b5657[_0x1900('0x7f')](_0x1bca7c[_0x1900('0x30')]['ids']);}})['then'](function(_0x86b1bc){if(_0x86b1bc){return db[_0x1900('0x57')][_0x1900('0x24')]({'where':{'ListId':_0x1bca7c[_0x1900('0x30')][_0x1900('0x63')],'CampaignId':_0x1bca7c[_0x1900('0x44')]['id']}})[_0x1900('0x21')](function(){return _0x86b1bc;});}})['then'](respondWithStatusCode(_0x458fd4,null))[_0x1900('0x42')](handleError(_0x458fd4,null));};exports['getBlackLists']=function(_0x55edb2,_0x4c9963,_0x4239bf){var _0x4731fc={};var _0x46b159={};var _0x4c21cf;var _0x292d55;return db['Campaign'][_0x1900('0x55')]({'where':{'id':_0x55edb2['params']['id']}})[_0x1900('0x21')](handleEntityNotFound(_0x4c9963,null))[_0x1900('0x21')](function(_0x3e3745){if(_0x3e3745){_0x4c21cf=_0x3e3745;_0x46b159['model']=_['keys'](db[_0x1900('0x60')][_0x1900('0x2b')]);_0x46b159[_0x1900('0x30')]=_[_0x1900('0x31')](_0x55edb2[_0x1900('0x30')]);_0x46b159['filters']=_[_0x1900('0x45')](_0x46b159['model'],_0x46b159[_0x1900('0x30')]);_0x4731fc['attributes']=_[_0x1900('0x45')](_0x46b159[_0x1900('0x2f')],qs[_0x1900('0x33')](_0x55edb2[_0x1900('0x30')]['fields']));_0x4731fc[_0x1900('0x34')]=_0x4731fc['attributes'][_0x1900('0x35')]?_0x4731fc['attributes']:_0x46b159[_0x1900('0x2f')];_0x4731fc[_0x1900('0x38')]=qs[_0x1900('0x39')](_0x55edb2[_0x1900('0x30')][_0x1900('0x39')]);_0x4731fc[_0x1900('0x3a')]=qs['filters'](_[_0x1900('0x5b')](_0x55edb2['query'],_0x46b159[_0x1900('0x32')]));if(_0x55edb2['query'][_0x1900('0x3b')]){_0x4731fc['where']=_[_0x1900('0x3c')](_0x4731fc['where'],{'$or':_['map'](_0x4731fc[_0x1900('0x34')],function(_0x516f57){var _0x24476a={};_0x24476a[_0x516f57]={'$like':'%'+_0x55edb2['query'][_0x1900('0x3b')]+'%'};return _0x24476a;})});}_0x4731fc=_[_0x1900('0x3c')]({},_0x4731fc,_0x55edb2['options']);return _0x4c21cf[_0x1900('0x80')](_0x4731fc);}})[_0x1900('0x21')](function(_0x58aa7e){if(_0x58aa7e){_0x292d55=_0x58aa7e[_0x1900('0x35')];if(!_0x55edb2[_0x1900('0x30')][_0x1900('0x36')](_0x1900('0x37'))){_0x4731fc[_0x1900('0x1b')]=qs['limit'](_0x55edb2[_0x1900('0x30')][_0x1900('0x1b')]);_0x4731fc['offset']=qs['offset'](_0x55edb2['query'][_0x1900('0x1d')]);}return _0x4c21cf[_0x1900('0x80')](_0x4731fc);}})['then'](function(_0xcf04ec){if(_0xcf04ec){return _0xcf04ec?{'count':_0x292d55,'rows':_0xcf04ec}:null;}})[_0x1900('0x21')](respondWithResult(_0x4c9963,null))[_0x1900('0x42')](handleError(_0x4c9963,null));};exports[_0x1900('0x81')]=function(_0x2ca399,_0x1bb698,_0x589990){var _0x5e749b,_0x95715a;return db[_0x1900('0x2a')]['find']({'where':{'id':_0x2ca399[_0x1900('0x44')]['id']}})[_0x1900('0x21')](handleEntityNotFound(_0x1bb698,null))[_0x1900('0x21')](function(_0xe3ddd6){if(_0xe3ddd6){_0x95715a=_0xe3ddd6;return _0xe3ddd6[_0x1900('0x81')](_0x2ca399[_0x1900('0x47')][_0x1900('0x63')],_['omit'](_0x2ca399[_0x1900('0x47')],[_0x1900('0x63'),'id'])||{});}return null;})[_0x1900('0x64')](function(_0x50b949){var _0x59554b;_0x5e749b=_0x50b949||[];var _0x3cfff6=[];if(_0x50b949){for(var _0x27ad76=0x0;_0x27ad76<_0x50b949[_0x1900('0x35')];_0x27ad76+=0x1){var _0x3e443f=_0x50b949[_0x27ad76][_0x1900('0x22')]({'plain':!![]});_0x59554b=squel['insert']()[_0x1900('0x67')](_0x1900('0x82'))[_0x1900('0x69')]([_0x1900('0x6a'),_0x1900('0x6b'),_0x1900('0x6c'),_0x1900('0x56'),_0x1900('0x51'),_0x1900('0x50')],squel[_0x1900('0x6d')]()[_0x1900('0x6e')](_0x1900('0x6a'),_0x1900('0x6a'))[_0x1900('0x6e')]('id',_0x1900('0x6b'))[_0x1900('0x6e')](_0x3e443f[_0x1900('0x71')]['toString'](),_0x1900('0x6c'))[_0x1900('0x6e')](_0x2ca399[_0x1900('0x44')]['id']['toString'](),_0x1900('0x56'))[_0x1900('0x6e')]('NOW()',_0x1900('0x51'))[_0x1900('0x6e')]('NOW()',_0x1900('0x50'))[_0x1900('0x73')](_0x1900('0x74'))[_0x1900('0x3a')](_0x1900('0x75'))[_0x1900('0x3a')]('ListId\x20=\x20?',_0x3e443f[_0x1900('0x71')][_0x1900('0x72')]())[_0x1900('0x3a')](_0x1900('0x76')))[_0x1900('0x72')]();_0x3cfff6[_0x1900('0x7d')](db[_0x1900('0x7e')]['query'](_0x59554b));}return BPromise[_0x1900('0x83')](_0x3cfff6);}})[_0x1900('0x21')](function(){return _0x5e749b;})[_0x1900('0x21')](respondWithResult(_0x1bb698,null))[_0x1900('0x42')](handleError(_0x1bb698,null));};exports[_0x1900('0x84')]=function(_0x53251f,_0x1210a3,_0x158bdc){return db[_0x1900('0x2a')][_0x1900('0x4a')]({'where':{'id':_0x53251f['params']['id']}})[_0x1900('0x21')](handleEntityNotFound(_0x1210a3,null))[_0x1900('0x21')](function(_0x2f55c4){if(_0x2f55c4){return _0x2f55c4[_0x1900('0x84')](_0x53251f[_0x1900('0x30')]['ids']);}})[_0x1900('0x21')](function(_0x7aaa14){if(_0x7aaa14){return db[_0x1900('0x5f')][_0x1900('0x24')]({'where':{'ListId':_0x53251f[_0x1900('0x30')][_0x1900('0x63')],'CampaignId':_0x53251f[_0x1900('0x44')]['id']}})[_0x1900('0x21')](function(){return _0x7aaa14;});}})[_0x1900('0x21')](respondWithStatusCode(_0x1210a3,null))[_0x1900('0x42')](handleError(_0x1210a3,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff