// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x515d=['then','destroy','get','IvrCampaigns','UserProfileResource','error','stack','name','send','rawAttributes','fieldName','type','key','map','query','keys','filters','intersection','model','fields','attributes','hasOwnProperty','nolimit','order','sort','where','filter','merge','options','includeAll','include','rows','catch','show','params','length','Campaign','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','user','find','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','omit','createdAt','updatedAt','UserProfileSection','pick','CampaignId','CmHopper','findAll','getHopperHistories','findOne','CmHopperHistory','getHopperFinals','CmHopperFinal','CmHopperBlack','getLists','CmList','addLists','format','YYYY-MM-DD\x20HH:mm:ss','ids','spread','dialCheckDuplicateType','always','into','cm_hopper','fromQuery','phone','scheduledAt','ContactId','select','field','NOW()','CmListId','toString','ListId','from','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','COALESCE(calleridnum,\x27\x27)','cm_hopper_final','CampaignId\x20=\x20?','onlyIfOpen','cm_contacts','COALESCE(phone,\x27\x27)','insert','cm_hopper_additional_phones','cmHopperId','OrderBy','h.id','ci.OrderBY','cm_contact_has_items','join','h.ContactId\x20=\x20ci.CmContactId','h.ListId\x20=\x20?','h.CampaignId=?','push','sequelize','all','removeLists','getBlackLists','addBlackLists','removeBlackLists','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','sox','fs-extra','lodash','squel','crypto','jsforce','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/license/util','../../mysqldb','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','reject','save','update'];(function(_0x5b184c,_0x504587){var _0x151399=function(_0x3766b1){while(--_0x3766b1){_0x5b184c['push'](_0x5b184c['shift']());}};_0x151399(++_0x504587);}(_0x515d,0x104));var _0xd515=function(_0x119768,_0x238c19){_0x119768=_0x119768-0x0;var _0x5c8503=_0x515d[_0x119768];return _0x5c8503;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0xd515('0x0'));var zipdir=require(_0xd515('0x1'));var jsonpatch=require(_0xd515('0x2'));var rp=require(_0xd515('0x3'));var moment=require(_0xd515('0x4'));var BPromise=require(_0xd515('0x5'));var Mustache=require(_0xd515('0x6'));var util=require(_0xd515('0x7'));var path=require('path');var sox=require(_0xd515('0x8'));var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0xd515('0x9'));var _=require(_0xd515('0xa'));var squel=require(_0xd515('0xb'));var crypto=require(_0xd515('0xc'));var jsforce=require(_0xd515('0xd'));var deskjs=require('desk.js');var toCsv=require(_0xd515('0xe'));var querystring=require(_0xd515('0xf'));var Papa=require(_0xd515('0x10'));var Redis=require(_0xd515('0x11'));var authService=require(_0xd515('0x12'));var qs=require(_0xd515('0x13'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xd515('0x14'));var logger=require(_0xd515('0x15'))(_0xd515('0x16'));var utils=require(_0xd515('0x17'));var config=require('../../config/environment');var licenseUtil=require(_0xd515('0x18'));var db=require(_0xd515('0x19'))['db'];function respondWithStatusCode(_0x29c078,_0x33b905){_0x33b905=_0x33b905||0xcc;return function(_0x1d6bda){if(_0x1d6bda){return _0x29c078[_0xd515('0x1a')](_0x33b905);}return _0x29c078[_0xd515('0x1b')](_0x33b905)[_0xd515('0x1c')]();};}function respondWithResult(_0x1f23b7,_0x43384b){_0x43384b=_0x43384b||0xc8;return function(_0x10620b){if(_0x10620b){return _0x1f23b7[_0xd515('0x1b')](_0x43384b)[_0xd515('0x1d')](_0x10620b);}};}function respondWithFilteredResult(_0x589d04,_0x274550){return function(_0xc41eca){if(_0xc41eca){var _0xc8fbf=typeof _0x274550[_0xd515('0x1e')]===_0xd515('0x1f')&&typeof _0x274550[_0xd515('0x20')]===_0xd515('0x1f');var _0x139e91=_0xc41eca[_0xd515('0x21')];var _0x564c4e=_0xc8fbf?0x0:_0x274550['offset'];var _0x43bb12=_0xc8fbf?_0xc41eca[_0xd515('0x21')]:_0x274550[_0xd515('0x1e')]+_0x274550[_0xd515('0x20')];var _0x1ef858;if(_0x43bb12>=_0x139e91){_0x43bb12=_0x139e91;_0x1ef858=0xc8;}else{_0x1ef858=0xce;}_0x589d04[_0xd515('0x1b')](_0x1ef858);return _0x589d04[_0xd515('0x22')](_0xd515('0x23'),_0x564c4e+'-'+_0x43bb12+'/'+_0x139e91)[_0xd515('0x1d')](_0xc41eca);}return null;};}function patchUpdates(_0x5c7fef){return function(_0x57e1f4){try{jsonpatch[_0xd515('0x24')](_0x57e1f4,_0x5c7fef,!![]);}catch(_0x5b1649){return BPromise[_0xd515('0x25')](_0x5b1649);}return _0x57e1f4[_0xd515('0x26')]();};}function saveUpdates(_0x2b2ed5,_0x4e9d06){return function(_0xb422bc){if(_0xb422bc){return _0xb422bc[_0xd515('0x27')](_0x2b2ed5)[_0xd515('0x28')](function(_0x299b46){return _0x299b46;});}return null;};}function removeEntity(_0x519b7f,_0x430153){return function(_0x11cc9f){if(_0x11cc9f){return _0x11cc9f[_0xd515('0x29')]()[_0xd515('0x28')](function(){var _0x1a5f58=_0x11cc9f[_0xd515('0x2a')]({'plain':!![]});var _0x130533=_0xd515('0x2b');return db[_0xd515('0x2c')]['destroy']({'where':{'type':_0x130533,'resourceId':_0x1a5f58['id']}})['then'](function(){return _0x11cc9f;});})[_0xd515('0x28')](function(){_0x519b7f[_0xd515('0x1b')](0xcc)[_0xd515('0x1c')]();});}};}function handleEntityNotFound(_0x3105b4,_0x1d70a8){return function(_0x2171bc){if(!_0x2171bc){_0x3105b4[_0xd515('0x1a')](0x194);}return _0x2171bc;};}function handleError(_0x33fc3b,_0x53ec33){_0x53ec33=_0x53ec33||0x1f4;return function(_0x38766a){logger[_0xd515('0x2d')](_0x38766a[_0xd515('0x2e')]);if(_0x38766a[_0xd515('0x2f')]){delete _0x38766a[_0xd515('0x2f')];}_0x33fc3b[_0xd515('0x1b')](_0x53ec33)[_0xd515('0x30')](_0x38766a);};}exports['index']=function(_0x587bdc,_0x5d4f45){var _0x1ed161={},_0x1f77cd={},_0x3feaf6={'count':0x0,'rows':[]};var _0x50f61f=_['map'](db['Campaign'][_0xd515('0x31')],function(_0xd2a563){return{'name':_0xd2a563[_0xd515('0x32')],'type':_0xd2a563[_0xd515('0x33')][_0xd515('0x34')]};});_0x1f77cd['model']=_[_0xd515('0x35')](_0x50f61f,'name');_0x1f77cd[_0xd515('0x36')]=_[_0xd515('0x37')](_0x587bdc[_0xd515('0x36')]);_0x1f77cd[_0xd515('0x38')]=_[_0xd515('0x39')](_0x1f77cd[_0xd515('0x3a')],_0x1f77cd[_0xd515('0x36')]);_0x1ed161['attributes']=_[_0xd515('0x39')](_0x1f77cd[_0xd515('0x3a')],qs[_0xd515('0x3b')](_0x587bdc[_0xd515('0x36')][_0xd515('0x3b')]));_0x1ed161['attributes']=_0x1ed161[_0xd515('0x3c')]['length']?_0x1ed161[_0xd515('0x3c')]:_0x1f77cd[_0xd515('0x3a')];if(!_0x587bdc[_0xd515('0x36')][_0xd515('0x3d')](_0xd515('0x3e'))){_0x1ed161[_0xd515('0x20')]=qs[_0xd515('0x20')](_0x587bdc[_0xd515('0x36')][_0xd515('0x20')]);_0x1ed161[_0xd515('0x1e')]=qs[_0xd515('0x1e')](_0x587bdc[_0xd515('0x36')]['offset']);}_0x1ed161[_0xd515('0x3f')]=qs[_0xd515('0x40')](_0x587bdc[_0xd515('0x36')]['sort']);_0x1ed161[_0xd515('0x41')]=qs['filters'](_['pick'](_0x587bdc['query'],_0x1f77cd['filters']),_0x50f61f);if(_0x587bdc[_0xd515('0x36')][_0xd515('0x42')]){_0x1ed161['where']=_[_0xd515('0x43')](_0x1ed161['where'],{'$or':_['map'](_0x50f61f,function(_0x1cabec){if(_0x1cabec['type']!=='VIRTUAL'){var _0x2c2def={};_0x2c2def[_0x1cabec[_0xd515('0x2f')]]={'$like':'%'+_0x587bdc[_0xd515('0x36')][_0xd515('0x42')]+'%'};return _0x2c2def;}})});}_0x1ed161=_[_0xd515('0x43')]({},_0x1ed161,_0x587bdc[_0xd515('0x44')]);var _0x15ef1a={'where':_0x1ed161[_0xd515('0x41')]};return db['Campaign'][_0xd515('0x21')](_0x15ef1a)[_0xd515('0x28')](function(_0x45b7b4){_0x3feaf6['count']=_0x45b7b4;if(_0x587bdc[_0xd515('0x36')][_0xd515('0x45')]){_0x1ed161[_0xd515('0x46')]=[{'all':!![]}];}return db['Campaign']['findAll'](_0x1ed161);})[_0xd515('0x28')](function(_0x3d752){_0x3feaf6[_0xd515('0x47')]=_0x3d752;return _0x3feaf6;})[_0xd515('0x28')](respondWithFilteredResult(_0x5d4f45,_0x1ed161))[_0xd515('0x48')](handleError(_0x5d4f45,null));};exports[_0xd515('0x49')]=function(_0x126661,_0x49a962){var _0x489941={'raw':![],'where':{'id':_0x126661[_0xd515('0x4a')]['id']}},_0x5cfff0={};_0x5cfff0[_0xd515('0x3a')]=_[_0xd515('0x37')](db['Campaign'][_0xd515('0x31')]);_0x5cfff0[_0xd515('0x36')]=_[_0xd515('0x37')](_0x126661[_0xd515('0x36')]);_0x5cfff0[_0xd515('0x38')]=_['intersection'](_0x5cfff0[_0xd515('0x3a')],_0x5cfff0[_0xd515('0x36')]);_0x489941[_0xd515('0x3c')]=_[_0xd515('0x39')](_0x5cfff0[_0xd515('0x3a')],qs[_0xd515('0x3b')](_0x126661['query'][_0xd515('0x3b')]));_0x489941['attributes']=_0x489941[_0xd515('0x3c')][_0xd515('0x4b')]?_0x489941[_0xd515('0x3c')]:_0x5cfff0['model'];if(_0x126661[_0xd515('0x36')][_0xd515('0x45')]){_0x489941['include']=[{'all':!![]}];}_0x489941=_[_0xd515('0x43')]({},_0x489941,_0x126661[_0xd515('0x44')]);return db[_0xd515('0x4c')]['find'](_0x489941)[_0xd515('0x28')](handleEntityNotFound(_0x49a962,null))['then'](respondWithResult(_0x49a962,null))[_0xd515('0x48')](handleError(_0x49a962,null));};exports[_0xd515('0x4d')]=function(_0x39ba14,_0x4843fa){return db[_0xd515('0x4c')]['create'](_0x39ba14[_0xd515('0x4e')],{})[_0xd515('0x28')](function(_0x14bc06){var _0xe84589=_0x39ba14['user']['get']({'plain':!![]});if(!_0xe84589)throw new Error(_0xd515('0x4f'));if(_0xe84589[_0xd515('0x50')]===_0xd515('0x51')){var _0x3eb60f=_0x14bc06['get']({'plain':!![]});var _0x560bb8=_0xd515('0x2b');return db['UserProfileSection'][_0xd515('0x52')]({'where':{'name':_0x560bb8,'userProfileId':_0xe84589['userProfileId']},'raw':!![]})[_0xd515('0x28')](function(_0xbbccf4){if(_0xbbccf4&&_0xbbccf4[_0xd515('0x53')]===0x0){return db[_0xd515('0x2c')]['create']({'name':_0x3eb60f['name'],'resourceId':_0x3eb60f['id'],'type':_0xbbccf4[_0xd515('0x2f')],'sectionId':_0xbbccf4['id']},{})[_0xd515('0x28')](function(){return _0x14bc06;});}else{return _0x14bc06;}})['catch'](function(_0xb1a212){logger[_0xd515('0x2d')](_0xd515('0x54'),_0xb1a212);throw _0xb1a212;});}return _0x14bc06;})[_0xd515('0x28')](respondWithResult(_0x4843fa,0xc9))[_0xd515('0x48')](handleError(_0x4843fa,null));};exports[_0xd515('0x55')]=function(_0x48ecec,_0x5d8c28){var _0x31ebaa={'where':{'id':_0x48ecec[_0xd515('0x4a')]['id']}},_0x2c9629={};_0x2c9629['model']=_[_0xd515('0x37')](db[_0xd515('0x4c')]['rawAttributes']);_0x31ebaa[_0xd515('0x3c')]=_[_0xd515('0x39')](_0x2c9629['model'],qs[_0xd515('0x3b')](_0x48ecec[_0xd515('0x36')][_0xd515('0x3b')]));_0x31ebaa[_0xd515('0x3c')]=_0x31ebaa[_0xd515('0x3c')][_0xd515('0x4b')]?_0x31ebaa['attributes']:_0x2c9629[_0xd515('0x3a')];if(_0x48ecec['query'][_0xd515('0x45')]){_0x31ebaa[_0xd515('0x46')]=[{'all':!![]}];}_0x31ebaa=_[_0xd515('0x43')]({},_0x31ebaa,_0x48ecec['options']);return db[_0xd515('0x4c')][_0xd515('0x52')](_0x31ebaa)[_0xd515('0x28')](handleEntityNotFound(_0x5d8c28,null))[_0xd515('0x28')](function(_0x7b2843){if(_0x7b2843){var _0x21ffed=_0x7b2843[_0xd515('0x2a')]({'plain':!![]});_0x21ffed=qs[_0xd515('0x56')](_0x21ffed,['id',_0xd515('0x57'),_0xd515('0x58')]);_0x48ecec[_0xd515('0x4e')]=_[_0xd515('0x56')](_0x48ecec[_0xd515('0x4e')],['id',_0xd515('0x57'),_0xd515('0x58')]);return db[_0xd515('0x4c')][_0xd515('0x4d')](_[_0xd515('0x43')](_0x21ffed,_0x48ecec[_0xd515('0x4e')]),{'include':_0x48ecec[_0xd515('0x36')][_0xd515('0x45')]?[{'all':!![]}]:undefined})[_0xd515('0x28')](function(_0xe6a36f){var _0x337d1f=_0x48ecec[_0xd515('0x51')][_0xd515('0x2a')]({'plain':!![]});if(!_0x337d1f)throw new Error(_0xd515('0x4f'));if(_0x337d1f['role']===_0xd515('0x51')){var _0x1338f8=_0xe6a36f['get']({'plain':!![]});var _0x390db2=_0xd515('0x2b');return db[_0xd515('0x59')][_0xd515('0x52')]({'where':{'name':_0x390db2,'userProfileId':_0x337d1f['userProfileId']},'raw':!![]})['then'](function(_0x1fb7bc){if(_0x1fb7bc&&_0x1fb7bc[_0xd515('0x53')]===0x0){return db[_0xd515('0x2c')]['create']({'name':_0x1338f8[_0xd515('0x2f')],'resourceId':_0x1338f8['id'],'type':_0x1fb7bc[_0xd515('0x2f')],'sectionId':_0x1fb7bc['id']},{})[_0xd515('0x28')](function(){return _0xe6a36f;});}else{return _0xe6a36f;}})[_0xd515('0x48')](function(_0x20fae4){logger[_0xd515('0x2d')](_0xd515('0x54'),_0x20fae4);throw _0x20fae4;});}return _0xe6a36f;});}})['then'](respondWithResult(_0x5d8c28,0xc9))[_0xd515('0x48')](handleError(_0x5d8c28,null));};exports[_0xd515('0x27')]=function(_0x2cd132,_0x2dc0a5){if(_0x2cd132['body']['id']){delete _0x2cd132[_0xd515('0x4e')]['id'];}return db[_0xd515('0x4c')][_0xd515('0x52')]({'where':{'id':_0x2cd132[_0xd515('0x4a')]['id']}})[_0xd515('0x28')](handleEntityNotFound(_0x2dc0a5,null))[_0xd515('0x28')](saveUpdates(_0x2cd132['body'],null))[_0xd515('0x28')](respondWithResult(_0x2dc0a5,null))[_0xd515('0x48')](handleError(_0x2dc0a5,null));};exports[_0xd515('0x29')]=function(_0x18975f,_0xdaad90){return db[_0xd515('0x4c')][_0xd515('0x52')]({'where':{'id':_0x18975f['params']['id']}})['then'](handleEntityNotFound(_0xdaad90,null))[_0xd515('0x28')](removeEntity(_0xdaad90,null))[_0xd515('0x48')](handleError(_0xdaad90,null));};exports['getHoppers']=function(_0x3b3561,_0x273af7,_0x601d2d){var _0x442ea9={'raw':!![],'where':{}};var _0x2af946={};var _0x1e1e45={'count':0x0,'rows':[]};return db[_0xd515('0x4c')]['findOne']({'where':{'id':_0x3b3561[_0xd515('0x4a')]['id']}})[_0xd515('0x28')](handleEntityNotFound(_0x273af7,null))['then'](function(_0x131438){if(_0x131438){_0x2af946[_0xd515('0x3a')]=_[_0xd515('0x37')](db['CmHopper'][_0xd515('0x31')]);_0x2af946[_0xd515('0x36')]=_[_0xd515('0x37')](_0x3b3561['query']);_0x2af946[_0xd515('0x38')]=_[_0xd515('0x39')](_0x2af946[_0xd515('0x3a')],_0x2af946[_0xd515('0x36')]);_0x442ea9[_0xd515('0x3c')]=_[_0xd515('0x39')](_0x2af946[_0xd515('0x3a')],qs['fields'](_0x3b3561[_0xd515('0x36')][_0xd515('0x3b')]));_0x442ea9['attributes']=_0x442ea9[_0xd515('0x3c')]['length']?_0x442ea9[_0xd515('0x3c')]:_0x2af946[_0xd515('0x3a')];if(!_0x3b3561[_0xd515('0x36')][_0xd515('0x3d')](_0xd515('0x3e'))){_0x442ea9[_0xd515('0x20')]=qs['limit'](_0x3b3561['query']['limit']);_0x442ea9[_0xd515('0x1e')]=qs['offset'](_0x3b3561['query'][_0xd515('0x1e')]);}_0x442ea9[_0xd515('0x3f')]=qs[_0xd515('0x40')](_0x3b3561[_0xd515('0x36')][_0xd515('0x40')]);_0x442ea9[_0xd515('0x41')]=qs[_0xd515('0x38')](_[_0xd515('0x5a')](_0x3b3561[_0xd515('0x36')],_0x2af946['filters']));_0x442ea9[_0xd515('0x41')][_0xd515('0x5b')]=_0x131438['id'];if(_0x3b3561['query'][_0xd515('0x42')]){_0x442ea9[_0xd515('0x41')]=_['merge'](_0x442ea9[_0xd515('0x41')],{'$or':_[_0xd515('0x35')](_0x442ea9[_0xd515('0x3c')],function(_0x25be6e){var _0x1950b6={};_0x1950b6[_0x25be6e]={'$like':'%'+_0x3b3561[_0xd515('0x36')][_0xd515('0x42')]+'%'};return _0x1950b6;})});}_0x442ea9=_[_0xd515('0x43')]({},_0x442ea9,_0x3b3561[_0xd515('0x44')]);return db['CmHopper'][_0xd515('0x21')]({'where':_0x442ea9['where']})[_0xd515('0x28')](function(_0x51c285){_0x1e1e45['count']=_0x51c285;if(_0x3b3561['query'][_0xd515('0x45')]){_0x442ea9[_0xd515('0x46')]=[{'all':!![]}];}return db[_0xd515('0x5c')][_0xd515('0x5d')](_0x442ea9);})['then'](function(_0x3ef3bc){_0x1e1e45[_0xd515('0x47')]=_0x3ef3bc;return _0x1e1e45;});}})[_0xd515('0x28')](respondWithFilteredResult(_0x273af7,_0x442ea9))[_0xd515('0x48')](handleError(_0x273af7,null));};exports[_0xd515('0x5e')]=function(_0x35656e,_0x26efcb,_0x3d5bc8){var _0x3ae5f0={'raw':!![],'where':{}};var _0x25b7e0={};var _0x5edf58={'count':0x0,'rows':[]};return db[_0xd515('0x4c')][_0xd515('0x5f')]({'where':{'id':_0x35656e['params']['id']}})[_0xd515('0x28')](handleEntityNotFound(_0x26efcb,null))['then'](function(_0x16b810){if(_0x16b810){_0x25b7e0['model']=_[_0xd515('0x37')](db[_0xd515('0x60')][_0xd515('0x31')]);_0x25b7e0[_0xd515('0x36')]=_[_0xd515('0x37')](_0x35656e['query']);_0x25b7e0[_0xd515('0x38')]=_[_0xd515('0x39')](_0x25b7e0[_0xd515('0x3a')],_0x25b7e0[_0xd515('0x36')]);_0x3ae5f0[_0xd515('0x3c')]=_[_0xd515('0x39')](_0x25b7e0[_0xd515('0x3a')],qs['fields'](_0x35656e[_0xd515('0x36')][_0xd515('0x3b')]));_0x3ae5f0['attributes']=_0x3ae5f0[_0xd515('0x3c')][_0xd515('0x4b')]?_0x3ae5f0[_0xd515('0x3c')]:_0x25b7e0[_0xd515('0x3a')];if(!_0x35656e[_0xd515('0x36')][_0xd515('0x3d')](_0xd515('0x3e'))){_0x3ae5f0[_0xd515('0x20')]=qs[_0xd515('0x20')](_0x35656e[_0xd515('0x36')]['limit']);_0x3ae5f0[_0xd515('0x1e')]=qs[_0xd515('0x1e')](_0x35656e[_0xd515('0x36')][_0xd515('0x1e')]);}_0x3ae5f0['order']=qs[_0xd515('0x40')](_0x35656e[_0xd515('0x36')][_0xd515('0x40')]);_0x3ae5f0[_0xd515('0x41')]=qs[_0xd515('0x38')](_[_0xd515('0x5a')](_0x35656e['query'],_0x25b7e0[_0xd515('0x38')]));_0x3ae5f0[_0xd515('0x41')][_0xd515('0x5b')]=_0x16b810['id'];if(_0x35656e['query'][_0xd515('0x42')]){_0x3ae5f0['where']=_[_0xd515('0x43')](_0x3ae5f0[_0xd515('0x41')],{'$or':_[_0xd515('0x35')](_0x3ae5f0[_0xd515('0x3c')],function(_0x4f84ae){var _0x36bcfa={};_0x36bcfa[_0x4f84ae]={'$like':'%'+_0x35656e[_0xd515('0x36')][_0xd515('0x42')]+'%'};return _0x36bcfa;})});}_0x3ae5f0=_['merge']({},_0x3ae5f0,_0x35656e[_0xd515('0x44')]);return db[_0xd515('0x60')][_0xd515('0x21')]({'where':_0x3ae5f0[_0xd515('0x41')]})[_0xd515('0x28')](function(_0x5cf607){_0x5edf58[_0xd515('0x21')]=_0x5cf607;if(_0x35656e[_0xd515('0x36')][_0xd515('0x45')]){_0x3ae5f0['include']=[{'all':!![]}];}return db['CmHopperHistory'][_0xd515('0x5d')](_0x3ae5f0);})[_0xd515('0x28')](function(_0x2157ae){_0x5edf58[_0xd515('0x47')]=_0x2157ae;return _0x5edf58;});}})[_0xd515('0x28')](respondWithFilteredResult(_0x26efcb,_0x3ae5f0))['catch'](handleError(_0x26efcb,null));};exports[_0xd515('0x61')]=function(_0x4e8afe,_0xbe54df,_0x4ee971){var _0x4af2f8={'raw':!![],'where':{}};var _0x5a412e={};var _0x1c6c4c={'count':0x0,'rows':[]};return db[_0xd515('0x4c')][_0xd515('0x5f')]({'where':{'id':_0x4e8afe['params']['id']}})['then'](handleEntityNotFound(_0xbe54df,null))[_0xd515('0x28')](function(_0x7f823e){if(_0x7f823e){_0x5a412e[_0xd515('0x3a')]=_['keys'](db[_0xd515('0x62')]['rawAttributes']);_0x5a412e[_0xd515('0x36')]=_[_0xd515('0x37')](_0x4e8afe['query']);_0x5a412e[_0xd515('0x38')]=_[_0xd515('0x39')](_0x5a412e[_0xd515('0x3a')],_0x5a412e[_0xd515('0x36')]);_0x4af2f8['attributes']=_[_0xd515('0x39')](_0x5a412e[_0xd515('0x3a')],qs[_0xd515('0x3b')](_0x4e8afe[_0xd515('0x36')][_0xd515('0x3b')]));_0x4af2f8['attributes']=_0x4af2f8['attributes']['length']?_0x4af2f8[_0xd515('0x3c')]:_0x5a412e[_0xd515('0x3a')];if(!_0x4e8afe['query'][_0xd515('0x3d')]('nolimit')){_0x4af2f8[_0xd515('0x20')]=qs[_0xd515('0x20')](_0x4e8afe[_0xd515('0x36')][_0xd515('0x20')]);_0x4af2f8[_0xd515('0x1e')]=qs[_0xd515('0x1e')](_0x4e8afe[_0xd515('0x36')]['offset']);}_0x4af2f8[_0xd515('0x3f')]=qs['sort'](_0x4e8afe['query']['sort']);_0x4af2f8[_0xd515('0x41')]=qs['filters'](_['pick'](_0x4e8afe[_0xd515('0x36')],_0x5a412e[_0xd515('0x38')]));_0x4af2f8[_0xd515('0x41')]['CampaignId']=_0x7f823e['id'];if(_0x4e8afe['query']['filter']){_0x4af2f8['where']=_['merge'](_0x4af2f8[_0xd515('0x41')],{'$or':_[_0xd515('0x35')](_0x4af2f8[_0xd515('0x3c')],function(_0x209c96){var _0x3ab81c={};_0x3ab81c[_0x209c96]={'$like':'%'+_0x4e8afe[_0xd515('0x36')][_0xd515('0x42')]+'%'};return _0x3ab81c;})});}_0x4af2f8=_[_0xd515('0x43')]({},_0x4af2f8,_0x4e8afe[_0xd515('0x44')]);return db[_0xd515('0x62')]['count']({'where':_0x4af2f8[_0xd515('0x41')]})['then'](function(_0x5f29be){_0x1c6c4c[_0xd515('0x21')]=_0x5f29be;if(_0x4e8afe[_0xd515('0x36')][_0xd515('0x45')]){_0x4af2f8[_0xd515('0x46')]=[{'all':!![]}];}return db[_0xd515('0x62')][_0xd515('0x5d')](_0x4af2f8);})[_0xd515('0x28')](function(_0x3c2370){_0x1c6c4c['rows']=_0x3c2370;return _0x1c6c4c;});}})[_0xd515('0x28')](respondWithFilteredResult(_0xbe54df,_0x4af2f8))[_0xd515('0x48')](handleError(_0xbe54df,null));};exports['getHopperBlacks']=function(_0x11def2,_0x53e4e7,_0x510f17){var _0x3f3483={'raw':!![],'where':{}};var _0x4a4302={};var _0x28716d={'count':0x0,'rows':[]};return db[_0xd515('0x4c')][_0xd515('0x5f')]({'where':{'id':_0x11def2[_0xd515('0x4a')]['id']}})[_0xd515('0x28')](handleEntityNotFound(_0x53e4e7,null))[_0xd515('0x28')](function(_0x1411e7){if(_0x1411e7){_0x4a4302[_0xd515('0x3a')]=_[_0xd515('0x37')](db['CmHopperBlack'][_0xd515('0x31')]);_0x4a4302[_0xd515('0x36')]=_[_0xd515('0x37')](_0x11def2['query']);_0x4a4302['filters']=_[_0xd515('0x39')](_0x4a4302[_0xd515('0x3a')],_0x4a4302['query']);_0x3f3483['attributes']=_['intersection'](_0x4a4302[_0xd515('0x3a')],qs[_0xd515('0x3b')](_0x11def2['query'][_0xd515('0x3b')]));_0x3f3483['attributes']=_0x3f3483[_0xd515('0x3c')][_0xd515('0x4b')]?_0x3f3483[_0xd515('0x3c')]:_0x4a4302[_0xd515('0x3a')];if(!_0x11def2[_0xd515('0x36')][_0xd515('0x3d')](_0xd515('0x3e'))){_0x3f3483[_0xd515('0x20')]=qs['limit'](_0x11def2[_0xd515('0x36')][_0xd515('0x20')]);_0x3f3483[_0xd515('0x1e')]=qs[_0xd515('0x1e')](_0x11def2['query'][_0xd515('0x1e')]);}_0x3f3483[_0xd515('0x3f')]=qs['sort'](_0x11def2[_0xd515('0x36')][_0xd515('0x40')]);_0x3f3483['where']=qs[_0xd515('0x38')](_[_0xd515('0x5a')](_0x11def2[_0xd515('0x36')],_0x4a4302['filters']));_0x3f3483[_0xd515('0x41')][_0xd515('0x5b')]=_0x1411e7['id'];if(_0x11def2['query'][_0xd515('0x42')]){_0x3f3483[_0xd515('0x41')]=_['merge'](_0x3f3483[_0xd515('0x41')],{'$or':_[_0xd515('0x35')](_0x3f3483['attributes'],function(_0x1c3c6c){var _0x3ab747={};_0x3ab747[_0x1c3c6c]={'$like':'%'+_0x11def2[_0xd515('0x36')][_0xd515('0x42')]+'%'};return _0x3ab747;})});}_0x3f3483=_[_0xd515('0x43')]({},_0x3f3483,_0x11def2[_0xd515('0x44')]);return db[_0xd515('0x63')]['count']({'where':_0x3f3483[_0xd515('0x41')]})[_0xd515('0x28')](function(_0x237c6b){_0x28716d[_0xd515('0x21')]=_0x237c6b;if(_0x11def2[_0xd515('0x36')][_0xd515('0x45')]){_0x3f3483[_0xd515('0x46')]=[{'all':!![]}];}return db[_0xd515('0x63')][_0xd515('0x5d')](_0x3f3483);})[_0xd515('0x28')](function(_0x1edaa0){_0x28716d[_0xd515('0x47')]=_0x1edaa0;return _0x28716d;});}})[_0xd515('0x28')](respondWithFilteredResult(_0x53e4e7,_0x3f3483))['catch'](handleError(_0x53e4e7,null));};exports[_0xd515('0x64')]=function(_0x96b1f6,_0x3a6ff8,_0x4ca5e5){var _0x1e734b={};var _0xb04480={};var _0x56b67f;var _0x30c80c;return db[_0xd515('0x4c')][_0xd515('0x5f')]({'where':{'id':_0x96b1f6[_0xd515('0x4a')]['id']}})[_0xd515('0x28')](handleEntityNotFound(_0x3a6ff8,null))[_0xd515('0x28')](function(_0xac5c7f){if(_0xac5c7f){_0x56b67f=_0xac5c7f;_0xb04480['model']=_[_0xd515('0x37')](db[_0xd515('0x65')][_0xd515('0x31')]);_0xb04480['query']=_[_0xd515('0x37')](_0x96b1f6[_0xd515('0x36')]);_0xb04480[_0xd515('0x38')]=_[_0xd515('0x39')](_0xb04480[_0xd515('0x3a')],_0xb04480[_0xd515('0x36')]);_0x1e734b[_0xd515('0x3c')]=_[_0xd515('0x39')](_0xb04480[_0xd515('0x3a')],qs[_0xd515('0x3b')](_0x96b1f6[_0xd515('0x36')][_0xd515('0x3b')]));_0x1e734b[_0xd515('0x3c')]=_0x1e734b['attributes'][_0xd515('0x4b')]?_0x1e734b[_0xd515('0x3c')]:_0xb04480[_0xd515('0x3a')];_0x1e734b[_0xd515('0x3f')]=qs['sort'](_0x96b1f6[_0xd515('0x36')][_0xd515('0x40')]);_0x1e734b[_0xd515('0x41')]=qs[_0xd515('0x38')](_['pick'](_0x96b1f6[_0xd515('0x36')],_0xb04480[_0xd515('0x38')]));if(_0x96b1f6[_0xd515('0x36')][_0xd515('0x42')]){_0x1e734b[_0xd515('0x41')]=_[_0xd515('0x43')](_0x1e734b[_0xd515('0x41')],{'$or':_['map'](_0x1e734b[_0xd515('0x3c')],function(_0x4f05dc){var _0x47121a={};_0x47121a[_0x4f05dc]={'$like':'%'+_0x96b1f6[_0xd515('0x36')][_0xd515('0x42')]+'%'};return _0x47121a;})});}_0x1e734b=_[_0xd515('0x43')]({},_0x1e734b,_0x96b1f6['options']);return _0x56b67f[_0xd515('0x64')](_0x1e734b);}})[_0xd515('0x28')](function(_0x1e6736){if(_0x1e6736){_0x30c80c=_0x1e6736[_0xd515('0x4b')];if(!_0x96b1f6[_0xd515('0x36')][_0xd515('0x3d')]('nolimit')){_0x1e734b[_0xd515('0x20')]=qs[_0xd515('0x20')](_0x96b1f6['query']['limit']);_0x1e734b['offset']=qs[_0xd515('0x1e')](_0x96b1f6[_0xd515('0x36')]['offset']);}return _0x56b67f[_0xd515('0x64')](_0x1e734b);}})[_0xd515('0x28')](function(_0x50ae8d){if(_0x50ae8d){return _0x50ae8d?{'count':_0x30c80c,'rows':_0x50ae8d}:null;}})['then'](respondWithResult(_0x3a6ff8,null))['catch'](handleError(_0x3a6ff8,null));};exports[_0xd515('0x66')]=function(_0x3b43ad,_0x426f9b,_0x3a5736){var _0x13a90c,_0x43c4bd;var _0x40813d=[];var _0x227cd9=moment()[_0xd515('0x67')](_0xd515('0x68'));return db[_0xd515('0x4c')][_0xd515('0x52')]({'where':{'id':_0x3b43ad[_0xd515('0x4a')]['id']}})['then'](handleEntityNotFound(_0x426f9b,null))[_0xd515('0x28')](function(_0x531956){if(_0x531956){_0x43c4bd=_0x531956;return _0x531956[_0xd515('0x66')](_0x3b43ad[_0xd515('0x4e')][_0xd515('0x69')],_[_0xd515('0x56')](_0x3b43ad[_0xd515('0x4e')],[_0xd515('0x69'),'id'])||{});}return null;})[_0xd515('0x6a')](function(_0x1b1c07){var _0x4fb7cc;var _0x1b2cd5;_0x13a90c=_0x1b1c07||[];var _0x31e053=[];if(_0x1b1c07){for(var _0x7cd9a7=0x0;_0x7cd9a7<_0x1b1c07[_0xd515('0x4b')];_0x7cd9a7+=0x1){var _0x39733c=_0x1b1c07[_0x7cd9a7][_0xd515('0x2a')]({'plain':!![]});_0x43c4bd[_0xd515('0x6b')]=_0x3b43ad[_0xd515('0x4e')]['dialCheckDuplicateType']?_0x3b43ad[_0xd515('0x4e')]['dialCheckDuplicateType']:_0x43c4bd['dialCheckDuplicateType'];switch(_0x43c4bd[_0xd515('0x6b')]){case _0xd515('0x6c'):_0x4fb7cc=squel['insert']()[_0xd515('0x6d')](_0xd515('0x6e'))[_0xd515('0x6f')]([_0xd515('0x70'),_0xd515('0x71'),_0xd515('0x72'),'ListId','CampaignId',_0xd515('0x57'),_0xd515('0x58')],squel[_0xd515('0x73')]()[_0xd515('0x74')](_0xd515('0x70'),_0xd515('0x70'))[_0xd515('0x74')](_0xd515('0x75'),_0xd515('0x71'))[_0xd515('0x74')]('id',_0xd515('0x72'))[_0xd515('0x74')](_0x39733c[_0xd515('0x76')][_0xd515('0x77')](),_0xd515('0x78'))['field'](_0x3b43ad[_0xd515('0x4a')]['id']['toString'](),_0xd515('0x5b'))[_0xd515('0x74')]('\x27'+_0x227cd9+'\x27',_0xd515('0x57'))[_0xd515('0x74')]('\x27'+_0x227cd9+'\x27',_0xd515('0x58'))[_0xd515('0x79')]('cm_contacts')[_0xd515('0x41')](_0xd515('0x7a'))[_0xd515('0x41')](_0xd515('0x7b'),_0x39733c['CmListId'][_0xd515('0x77')]())[_0xd515('0x41')](_0xd515('0x7c'))[_0xd515('0x41')](_0xd515('0x7d'),squel[_0xd515('0x73')]()['field'](_0xd515('0x7e'))[_0xd515('0x79')](_0xd515('0x7f'))['where'](_0xd515('0x80'),_0x3b43ad[_0xd515('0x4a')]['id'][_0xd515('0x77')]()))[_0xd515('0x41')]('phone\x20NOT\x20IN\x20(?)',squel[_0xd515('0x73')]()['field']('COALESCE(phone,\x27\x27)')[_0xd515('0x79')](_0xd515('0x6e'))[_0xd515('0x41')](_0xd515('0x80'),_0x3b43ad[_0xd515('0x4a')]['id'][_0xd515('0x77')]())))[_0xd515('0x77')]();break;case _0xd515('0x81'):_0x4fb7cc=squel['insert']()['into']('cm_hopper')[_0xd515('0x6f')]([_0xd515('0x70'),_0xd515('0x71'),_0xd515('0x72'),_0xd515('0x78'),_0xd515('0x5b'),_0xd515('0x57'),'updatedAt'],squel[_0xd515('0x73')]()['field'](_0xd515('0x70'),'phone')[_0xd515('0x74')](_0xd515('0x75'),_0xd515('0x71'))[_0xd515('0x74')]('id','ContactId')['field'](_0x39733c[_0xd515('0x76')]['toString'](),_0xd515('0x78'))['field'](_0x3b43ad['params']['id'][_0xd515('0x77')](),_0xd515('0x5b'))[_0xd515('0x74')]('\x27'+_0x227cd9+'\x27',_0xd515('0x57'))['field']('\x27'+_0x227cd9+'\x27',_0xd515('0x58'))[_0xd515('0x79')](_0xd515('0x82'))[_0xd515('0x41')]('deletedAt\x20IS\x20NULL')[_0xd515('0x41')](_0xd515('0x7b'),_0x39733c[_0xd515('0x76')][_0xd515('0x77')]())['where'](_0xd515('0x7c'))[_0xd515('0x41')]('phone\x20NOT\x20IN\x20(?)',squel[_0xd515('0x73')]()[_0xd515('0x74')](_0xd515('0x83'))[_0xd515('0x79')](_0xd515('0x6e'))[_0xd515('0x41')]('CampaignId\x20=\x20?',_0x3b43ad['params']['id'][_0xd515('0x77')]())))[_0xd515('0x77')]();break;default:_0x4fb7cc=squel[_0xd515('0x84')]()['into']('cm_hopper')['fromQuery']([_0xd515('0x70'),_0xd515('0x71'),_0xd515('0x72'),'ListId','CampaignId',_0xd515('0x57'),'updatedAt'],squel[_0xd515('0x73')]()[_0xd515('0x74')](_0xd515('0x70'),_0xd515('0x70'))[_0xd515('0x74')](_0xd515('0x75'),_0xd515('0x71'))[_0xd515('0x74')]('id',_0xd515('0x72'))[_0xd515('0x74')](_0x39733c[_0xd515('0x76')][_0xd515('0x77')](),_0xd515('0x78'))[_0xd515('0x74')](_0x3b43ad[_0xd515('0x4a')]['id'][_0xd515('0x77')](),_0xd515('0x5b'))[_0xd515('0x74')]('\x27'+_0x227cd9+'\x27',_0xd515('0x57'))['field']('\x27'+_0x227cd9+'\x27',_0xd515('0x58'))[_0xd515('0x79')]('cm_contacts')[_0xd515('0x41')](_0xd515('0x7a'))[_0xd515('0x41')](_0xd515('0x7b'),_0x39733c[_0xd515('0x76')][_0xd515('0x77')]())['where'](_0xd515('0x7c')))[_0xd515('0x77')]();}_0x1b2cd5=squel[_0xd515('0x84')]()[_0xd515('0x6d')](_0xd515('0x85'))[_0xd515('0x6f')]([_0xd515('0x86'),_0xd515('0x71'),_0xd515('0x70'),_0xd515('0x87'),_0xd515('0x57'),_0xd515('0x58')],squel[_0xd515('0x73')]()[_0xd515('0x74')](_0xd515('0x88'),'id')[_0xd515('0x74')](_0xd515('0x75'),_0xd515('0x71'))['field']('ci.item','phone')[_0xd515('0x74')](_0xd515('0x89'),_0xd515('0x87'))[_0xd515('0x74')]('\x27'+_0x227cd9+'\x27','createdAt')['field']('\x27'+_0x227cd9+'\x27','updatedAt')[_0xd515('0x79')](_0xd515('0x8a'),'ci')[_0xd515('0x8b')](_0xd515('0x6e'),'h',_0xd515('0x8c'))[_0xd515('0x41')](_0xd515('0x8d'),_0x39733c['CmListId']['toString']())[_0xd515('0x41')](_0xd515('0x8e'),_0x3b43ad[_0xd515('0x4a')]['id']['toString']())['where']('h.createdAt\x20=\x20?',_0x227cd9))[_0xd515('0x77')]();_0x31e053[_0xd515('0x8f')](db[_0xd515('0x90')]['query'](_0x4fb7cc));_0x40813d[_0xd515('0x8f')](db[_0xd515('0x90')]['query'](_0x1b2cd5));}return BPromise[_0xd515('0x91')](_0x31e053);}})[_0xd515('0x28')](function(){return BPromise['all'](_0x40813d);})[_0xd515('0x28')](function(){return _0x13a90c;})['then'](respondWithResult(_0x426f9b,null))[_0xd515('0x48')](handleError(_0x426f9b,null));};exports[_0xd515('0x92')]=function(_0x7132d2,_0x3bbed9,_0x4a9bbc){return db[_0xd515('0x4c')][_0xd515('0x52')]({'where':{'id':_0x7132d2[_0xd515('0x4a')]['id']}})[_0xd515('0x28')](handleEntityNotFound(_0x3bbed9,null))['then'](function(_0x341960){if(_0x341960){return _0x341960['removeLists'](_0x7132d2[_0xd515('0x36')][_0xd515('0x69')]);}})[_0xd515('0x28')](function(_0x274562){if(_0x274562){return db[_0xd515('0x5c')]['destroy']({'where':{'ListId':_0x7132d2['query']['ids'],'CampaignId':_0x7132d2[_0xd515('0x4a')]['id']}})[_0xd515('0x28')](function(){return _0x274562;});}})[_0xd515('0x28')](respondWithStatusCode(_0x3bbed9,null))[_0xd515('0x48')](handleError(_0x3bbed9,null));};exports[_0xd515('0x93')]=function(_0xb46293,_0x2c4b7e,_0x52b769){var _0x3976ec={};var _0x17cc01={};var _0x5f0668;var _0x4ec671;return db[_0xd515('0x4c')]['findOne']({'where':{'id':_0xb46293[_0xd515('0x4a')]['id']}})[_0xd515('0x28')](handleEntityNotFound(_0x2c4b7e,null))['then'](function(_0x379e0c){if(_0x379e0c){_0x5f0668=_0x379e0c;_0x17cc01[_0xd515('0x3a')]=_[_0xd515('0x37')](db['CmList']['rawAttributes']);_0x17cc01[_0xd515('0x36')]=_[_0xd515('0x37')](_0xb46293[_0xd515('0x36')]);_0x17cc01[_0xd515('0x38')]=_[_0xd515('0x39')](_0x17cc01[_0xd515('0x3a')],_0x17cc01['query']);_0x3976ec[_0xd515('0x3c')]=_[_0xd515('0x39')](_0x17cc01[_0xd515('0x3a')],qs['fields'](_0xb46293[_0xd515('0x36')][_0xd515('0x3b')]));_0x3976ec[_0xd515('0x3c')]=_0x3976ec[_0xd515('0x3c')]['length']?_0x3976ec['attributes']:_0x17cc01[_0xd515('0x3a')];_0x3976ec[_0xd515('0x3f')]=qs[_0xd515('0x40')](_0xb46293[_0xd515('0x36')][_0xd515('0x40')]);_0x3976ec[_0xd515('0x41')]=qs['filters'](_[_0xd515('0x5a')](_0xb46293['query'],_0x17cc01[_0xd515('0x38')]));if(_0xb46293[_0xd515('0x36')][_0xd515('0x42')]){_0x3976ec['where']=_[_0xd515('0x43')](_0x3976ec[_0xd515('0x41')],{'$or':_[_0xd515('0x35')](_0x3976ec[_0xd515('0x3c')],function(_0x129fa5){var _0x5b8425={};_0x5b8425[_0x129fa5]={'$like':'%'+_0xb46293[_0xd515('0x36')]['filter']+'%'};return _0x5b8425;})});}_0x3976ec=_[_0xd515('0x43')]({},_0x3976ec,_0xb46293['options']);return _0x5f0668[_0xd515('0x93')](_0x3976ec);}})['then'](function(_0x255477){if(_0x255477){_0x4ec671=_0x255477['length'];if(!_0xb46293[_0xd515('0x36')]['hasOwnProperty']('nolimit')){_0x3976ec[_0xd515('0x20')]=qs[_0xd515('0x20')](_0xb46293[_0xd515('0x36')][_0xd515('0x20')]);_0x3976ec[_0xd515('0x1e')]=qs[_0xd515('0x1e')](_0xb46293['query'][_0xd515('0x1e')]);}return _0x5f0668[_0xd515('0x93')](_0x3976ec);}})[_0xd515('0x28')](function(_0x30f242){if(_0x30f242){return _0x30f242?{'count':_0x4ec671,'rows':_0x30f242}:null;}})[_0xd515('0x28')](respondWithResult(_0x2c4b7e,null))['catch'](handleError(_0x2c4b7e,null));};exports[_0xd515('0x94')]=function(_0x1301c3,_0x149a8e,_0x5d3c71){var _0x30ca9e,_0x438617;var _0x387519=[];var _0x5cdc5b=moment()[_0xd515('0x67')](_0xd515('0x68'));return db['Campaign'][_0xd515('0x52')]({'where':{'id':_0x1301c3[_0xd515('0x4a')]['id']}})['then'](handleEntityNotFound(_0x149a8e,null))[_0xd515('0x28')](function(_0x2c9d45){if(_0x2c9d45){_0x438617=_0x2c9d45;return _0x2c9d45[_0xd515('0x94')](_0x1301c3[_0xd515('0x4e')][_0xd515('0x69')],_[_0xd515('0x56')](_0x1301c3[_0xd515('0x4e')],[_0xd515('0x69'),'id'])||{});}return null;})[_0xd515('0x6a')](function(_0x35e173){var _0x39e7ad;var _0x1253df;_0x30ca9e=_0x35e173||[];var _0x57b460=[];if(_0x35e173){for(var _0x213e23=0x0;_0x213e23<_0x35e173[_0xd515('0x4b')];_0x213e23+=0x1){var _0x529361=_0x35e173[_0x213e23][_0xd515('0x2a')]({'plain':!![]});_0x39e7ad=squel[_0xd515('0x84')]()[_0xd515('0x6d')]('cm_hopper_black')[_0xd515('0x6f')]([_0xd515('0x70'),'ContactId',_0xd515('0x78'),'CampaignId',_0xd515('0x57'),'updatedAt'],squel[_0xd515('0x73')]()[_0xd515('0x74')](_0xd515('0x70'),_0xd515('0x70'))[_0xd515('0x74')]('id','ContactId')[_0xd515('0x74')](_0x529361[_0xd515('0x76')][_0xd515('0x77')](),'ListId')['field'](_0x1301c3['params']['id'][_0xd515('0x77')](),_0xd515('0x5b'))[_0xd515('0x74')](_0xd515('0x75'),'createdAt')['field']('NOW()',_0xd515('0x58'))[_0xd515('0x79')]('cm_contacts')[_0xd515('0x41')](_0xd515('0x7a'))[_0xd515('0x41')]('ListId\x20=\x20?',_0x529361[_0xd515('0x76')][_0xd515('0x77')]())['where'](_0xd515('0x7c')))[_0xd515('0x77')]();_0x57b460[_0xd515('0x8f')](db[_0xd515('0x90')][_0xd515('0x36')](_0x39e7ad));}return BPromise['all'](_0x57b460);}})['then'](function(){return _0x30ca9e;})[_0xd515('0x28')](respondWithResult(_0x149a8e,null))['catch'](handleError(_0x149a8e,null));};exports[_0xd515('0x95')]=function(_0x2f2fb4,_0x2117e2,_0x2997e6){return db[_0xd515('0x4c')][_0xd515('0x52')]({'where':{'id':_0x2f2fb4[_0xd515('0x4a')]['id']}})[_0xd515('0x28')](handleEntityNotFound(_0x2117e2,null))[_0xd515('0x28')](function(_0x21d165){if(_0x21d165){return _0x21d165[_0xd515('0x95')](_0x2f2fb4['query'][_0xd515('0x69')]);}})['then'](function(_0x4d210a){if(_0x4d210a){return db[_0xd515('0x63')]['destroy']({'where':{'ListId':_0x2f2fb4['query']['ids'],'CampaignId':_0x2f2fb4[_0xd515('0x4a')]['id']}})['then'](function(){return _0x4d210a;});}})[_0xd515('0x28')](respondWithStatusCode(_0x2117e2,null))['catch'](handleError(_0x2117e2,null));};
\ No newline at end of file
+var _0xd403=['onlyIfOpen','insert','cm_contacts','CampaignId\x20=\x20?','cm_hopper_additional_phones','cmHopperId','h.id','ci.OrderBY','OrderBy','cm_contact_has_items','join','h.ContactId\x20=\x20ci.CmContactId','h.ListId\x20=\x20?','h.createdAt\x20=\x20?','push','sequelize','all','removeLists','getBlackLists','format','cm_hopper_black','removeBlackLists','eml-format','rimraf','zip-dir','fast-json-patch','moment','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','end','status','json','offset','undefined','count','limit','apply','reject','save','update','then','destroy','IvrCampaigns','UserProfileResource','sendStatus','error','stack','name','send','map','rawAttributes','fieldName','type','key','query','keys','filters','attributes','intersection','model','fields','length','hasOwnProperty','nolimit','order','sort','where','merge','VIRTUAL','filter','options','includeAll','include','findAll','rows','catch','show','params','Campaign','find','create','body','user','get','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','updatedAt','omit','role','UserProfileSection','getHoppers','findOne','CmHopper','pick','CampaignId','CmHopperHistory','getHopperFinals','CmHopperFinal','getHopperBlacks','CmHopperBlack','getLists','addLists','YYYY-MM-DD\x20HH:mm:ss','ids','spread','dialCheckDuplicateType','always','into','cm_hopper','fromQuery','phone','scheduledAt','ContactId','ListId','createdAt','NOW()','field','toString','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','CmListId','phone\x20IS\x20NOT\x20NULL','select','COALESCE(calleridnum,\x27\x27)','from','phone\x20NOT\x20IN\x20(?)','COALESCE(phone,\x27\x27)'];(function(_0x320fec,_0x49c104){var _0x158c82=function(_0x2f4668){while(--_0x2f4668){_0x320fec['push'](_0x320fec['shift']());}};_0x158c82(++_0x49c104);}(_0xd403,0x1d5));var _0x3d40=function(_0xaa0309,_0x1c8008){_0xaa0309=_0xaa0309-0x0;var _0x5de7ce=_0xd403[_0xaa0309];return _0x5de7ce;};'use strict';var emlformat=require(_0x3d40('0x0'));var rimraf=require(_0x3d40('0x1'));var zipdir=require(_0x3d40('0x2'));var jsonpatch=require(_0x3d40('0x3'));var rp=require('request-promise');var moment=require(_0x3d40('0x4'));var BPromise=require('bluebird');var Mustache=require(_0x3d40('0x5'));var util=require(_0x3d40('0x6'));var path=require(_0x3d40('0x7'));var sox=require(_0x3d40('0x8'));var csv=require(_0x3d40('0x9'));var ejs=require(_0x3d40('0xa'));var fs=require('fs');var fs_extra=require(_0x3d40('0xb'));var _=require(_0x3d40('0xc'));var squel=require(_0x3d40('0xd'));var crypto=require(_0x3d40('0xe'));var jsforce=require(_0x3d40('0xf'));var deskjs=require(_0x3d40('0x10'));var toCsv=require(_0x3d40('0x9'));var querystring=require(_0x3d40('0x11'));var Papa=require(_0x3d40('0x12'));var Redis=require(_0x3d40('0x13'));var authService=require('../../components/auth/service');var qs=require(_0x3d40('0x14'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x3d40('0x15'));var logger=require(_0x3d40('0x16'))(_0x3d40('0x17'));var utils=require('../../config/utils');var config=require(_0x3d40('0x18'));var licenseUtil=require(_0x3d40('0x19'));var db=require(_0x3d40('0x1a'))['db'];function respondWithStatusCode(_0x49ea7c,_0x31c199){_0x31c199=_0x31c199||0xcc;return function(_0x405625){if(_0x405625){return _0x49ea7c['sendStatus'](_0x31c199);}return _0x49ea7c['status'](_0x31c199)[_0x3d40('0x1b')]();};}function respondWithResult(_0x24d2c0,_0x3e6d19){_0x3e6d19=_0x3e6d19||0xc8;return function(_0x5062ec){if(_0x5062ec){return _0x24d2c0[_0x3d40('0x1c')](_0x3e6d19)[_0x3d40('0x1d')](_0x5062ec);}};}function respondWithFilteredResult(_0x311d57,_0x3e6e71){return function(_0x2b5e2d){if(_0x2b5e2d){var _0x359e9d=typeof _0x3e6e71[_0x3d40('0x1e')]==='undefined'&&typeof _0x3e6e71['limit']===_0x3d40('0x1f');var _0x2f38e1=_0x2b5e2d[_0x3d40('0x20')];var _0x75437e=_0x359e9d?0x0:_0x3e6e71[_0x3d40('0x1e')];var _0x2f3663=_0x359e9d?_0x2b5e2d[_0x3d40('0x20')]:_0x3e6e71[_0x3d40('0x1e')]+_0x3e6e71[_0x3d40('0x21')];var _0x402b4e;if(_0x2f3663>=_0x2f38e1){_0x2f3663=_0x2f38e1;_0x402b4e=0xc8;}else{_0x402b4e=0xce;}_0x311d57[_0x3d40('0x1c')](_0x402b4e);return _0x311d57['set']('Content-Range',_0x75437e+'-'+_0x2f3663+'/'+_0x2f38e1)[_0x3d40('0x1d')](_0x2b5e2d);}return null;};}function patchUpdates(_0x41608f){return function(_0x2fc0e2){try{jsonpatch[_0x3d40('0x22')](_0x2fc0e2,_0x41608f,!![]);}catch(_0x28b1c0){return BPromise[_0x3d40('0x23')](_0x28b1c0);}return _0x2fc0e2[_0x3d40('0x24')]();};}function saveUpdates(_0xbd7298,_0x3df1f9){return function(_0x321bc2){if(_0x321bc2){return _0x321bc2[_0x3d40('0x25')](_0xbd7298)[_0x3d40('0x26')](function(_0x181688){return _0x181688;});}return null;};}function removeEntity(_0x5314c5,_0x1a2d0f){return function(_0x14cad3){if(_0x14cad3){return _0x14cad3[_0x3d40('0x27')]()[_0x3d40('0x26')](function(){var _0x645da4=_0x14cad3['get']({'plain':!![]});var _0x45aa46=_0x3d40('0x28');return db[_0x3d40('0x29')][_0x3d40('0x27')]({'where':{'type':_0x45aa46,'resourceId':_0x645da4['id']}})[_0x3d40('0x26')](function(){return _0x14cad3;});})['then'](function(){_0x5314c5[_0x3d40('0x1c')](0xcc)[_0x3d40('0x1b')]();});}};}function handleEntityNotFound(_0x4e4ee9,_0x412d46){return function(_0x1f94ac){if(!_0x1f94ac){_0x4e4ee9[_0x3d40('0x2a')](0x194);}return _0x1f94ac;};}function handleError(_0x537790,_0x38ff70){_0x38ff70=_0x38ff70||0x1f4;return function(_0x265c2c){logger[_0x3d40('0x2b')](_0x265c2c[_0x3d40('0x2c')]);if(_0x265c2c[_0x3d40('0x2d')]){delete _0x265c2c[_0x3d40('0x2d')];}_0x537790[_0x3d40('0x1c')](_0x38ff70)[_0x3d40('0x2e')](_0x265c2c);};}exports['index']=function(_0x4e536f,_0x394fab){var _0xcb3c3b={},_0x5071b9={},_0x2c1ce6={'count':0x0,'rows':[]};var _0x4f235f=_[_0x3d40('0x2f')](db['Campaign'][_0x3d40('0x30')],function(_0xbff1f2){return{'name':_0xbff1f2[_0x3d40('0x31')],'type':_0xbff1f2[_0x3d40('0x32')][_0x3d40('0x33')]};});_0x5071b9['model']=_['map'](_0x4f235f,_0x3d40('0x2d'));_0x5071b9[_0x3d40('0x34')]=_[_0x3d40('0x35')](_0x4e536f['query']);_0x5071b9[_0x3d40('0x36')]=_['intersection'](_0x5071b9['model'],_0x5071b9['query']);_0xcb3c3b[_0x3d40('0x37')]=_[_0x3d40('0x38')](_0x5071b9[_0x3d40('0x39')],qs[_0x3d40('0x3a')](_0x4e536f[_0x3d40('0x34')][_0x3d40('0x3a')]));_0xcb3c3b[_0x3d40('0x37')]=_0xcb3c3b[_0x3d40('0x37')][_0x3d40('0x3b')]?_0xcb3c3b['attributes']:_0x5071b9['model'];if(!_0x4e536f[_0x3d40('0x34')][_0x3d40('0x3c')](_0x3d40('0x3d'))){_0xcb3c3b[_0x3d40('0x21')]=qs[_0x3d40('0x21')](_0x4e536f[_0x3d40('0x34')]['limit']);_0xcb3c3b[_0x3d40('0x1e')]=qs[_0x3d40('0x1e')](_0x4e536f[_0x3d40('0x34')]['offset']);}_0xcb3c3b[_0x3d40('0x3e')]=qs['sort'](_0x4e536f[_0x3d40('0x34')][_0x3d40('0x3f')]);_0xcb3c3b['where']=qs[_0x3d40('0x36')](_['pick'](_0x4e536f['query'],_0x5071b9[_0x3d40('0x36')]),_0x4f235f);if(_0x4e536f[_0x3d40('0x34')]['filter']){_0xcb3c3b[_0x3d40('0x40')]=_[_0x3d40('0x41')](_0xcb3c3b[_0x3d40('0x40')],{'$or':_['map'](_0x4f235f,function(_0x295418){if(_0x295418[_0x3d40('0x32')]!==_0x3d40('0x42')){var _0x2c45c5={};_0x2c45c5[_0x295418[_0x3d40('0x2d')]]={'$like':'%'+_0x4e536f[_0x3d40('0x34')][_0x3d40('0x43')]+'%'};return _0x2c45c5;}})});}_0xcb3c3b=_[_0x3d40('0x41')]({},_0xcb3c3b,_0x4e536f[_0x3d40('0x44')]);var _0x322030={'where':_0xcb3c3b[_0x3d40('0x40')]};return db['Campaign'][_0x3d40('0x20')](_0x322030)['then'](function(_0x575268){_0x2c1ce6['count']=_0x575268;if(_0x4e536f[_0x3d40('0x34')][_0x3d40('0x45')]){_0xcb3c3b[_0x3d40('0x46')]=[{'all':!![]}];}return db['Campaign'][_0x3d40('0x47')](_0xcb3c3b);})[_0x3d40('0x26')](function(_0x46e59d){_0x2c1ce6[_0x3d40('0x48')]=_0x46e59d;return _0x2c1ce6;})['then'](respondWithFilteredResult(_0x394fab,_0xcb3c3b))[_0x3d40('0x49')](handleError(_0x394fab,null));};exports[_0x3d40('0x4a')]=function(_0x17becc,_0x1be4a9){var _0xdde7e4={'raw':![],'where':{'id':_0x17becc[_0x3d40('0x4b')]['id']}},_0x4387f5={};_0x4387f5[_0x3d40('0x39')]=_[_0x3d40('0x35')](db[_0x3d40('0x4c')]['rawAttributes']);_0x4387f5['query']=_[_0x3d40('0x35')](_0x17becc[_0x3d40('0x34')]);_0x4387f5[_0x3d40('0x36')]=_[_0x3d40('0x38')](_0x4387f5[_0x3d40('0x39')],_0x4387f5[_0x3d40('0x34')]);_0xdde7e4[_0x3d40('0x37')]=_[_0x3d40('0x38')](_0x4387f5[_0x3d40('0x39')],qs['fields'](_0x17becc['query'][_0x3d40('0x3a')]));_0xdde7e4[_0x3d40('0x37')]=_0xdde7e4[_0x3d40('0x37')][_0x3d40('0x3b')]?_0xdde7e4[_0x3d40('0x37')]:_0x4387f5['model'];if(_0x17becc[_0x3d40('0x34')][_0x3d40('0x45')]){_0xdde7e4['include']=[{'all':!![]}];}_0xdde7e4=_['merge']({},_0xdde7e4,_0x17becc['options']);return db[_0x3d40('0x4c')][_0x3d40('0x4d')](_0xdde7e4)[_0x3d40('0x26')](handleEntityNotFound(_0x1be4a9,null))['then'](respondWithResult(_0x1be4a9,null))[_0x3d40('0x49')](handleError(_0x1be4a9,null));};exports['create']=function(_0x580eee,_0xa3ba73){return db[_0x3d40('0x4c')][_0x3d40('0x4e')](_0x580eee[_0x3d40('0x4f')],{})['then'](function(_0xb99156){var _0x5d957d=_0x580eee[_0x3d40('0x50')][_0x3d40('0x51')]({'plain':!![]});if(!_0x5d957d)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x5d957d['role']===_0x3d40('0x50')){var _0x1448c4=_0xb99156[_0x3d40('0x51')]({'plain':!![]});var _0x23eadf=_0x3d40('0x28');return db['UserProfileSection']['find']({'where':{'name':_0x23eadf,'userProfileId':_0x5d957d[_0x3d40('0x52')]},'raw':!![]})[_0x3d40('0x26')](function(_0x333538){if(_0x333538&&_0x333538[_0x3d40('0x53')]===0x0){return db[_0x3d40('0x29')][_0x3d40('0x4e')]({'name':_0x1448c4['name'],'resourceId':_0x1448c4['id'],'type':_0x333538[_0x3d40('0x2d')],'sectionId':_0x333538['id']},{})[_0x3d40('0x26')](function(){return _0xb99156;});}else{return _0xb99156;}})[_0x3d40('0x49')](function(_0x10223d){logger[_0x3d40('0x2b')](_0x3d40('0x54'),_0x10223d);throw _0x10223d;});}return _0xb99156;})[_0x3d40('0x26')](respondWithResult(_0xa3ba73,0xc9))[_0x3d40('0x49')](handleError(_0xa3ba73,null));};exports[_0x3d40('0x55')]=function(_0x189e80,_0x40eb86){var _0x1ab188={'where':{'id':_0x189e80[_0x3d40('0x4b')]['id']}},_0x427f2a={};_0x427f2a['model']=_['keys'](db['Campaign']['rawAttributes']);_0x1ab188['attributes']=_[_0x3d40('0x38')](_0x427f2a['model'],qs[_0x3d40('0x3a')](_0x189e80[_0x3d40('0x34')]['fields']));_0x1ab188[_0x3d40('0x37')]=_0x1ab188[_0x3d40('0x37')]['length']?_0x1ab188[_0x3d40('0x37')]:_0x427f2a[_0x3d40('0x39')];if(_0x189e80[_0x3d40('0x34')]['includeAll']){_0x1ab188[_0x3d40('0x46')]=[{'all':!![]}];}_0x1ab188=_['merge']({},_0x1ab188,_0x189e80[_0x3d40('0x44')]);return db['Campaign']['find'](_0x1ab188)['then'](handleEntityNotFound(_0x40eb86,null))[_0x3d40('0x26')](function(_0x18626d){if(_0x18626d){var _0x5ad181=_0x18626d[_0x3d40('0x51')]({'plain':!![]});_0x5ad181=qs['omit'](_0x5ad181,['id','createdAt',_0x3d40('0x56')]);_0x189e80['body']=_[_0x3d40('0x57')](_0x189e80['body'],['id','createdAt',_0x3d40('0x56')]);return db['Campaign'][_0x3d40('0x4e')](_[_0x3d40('0x41')](_0x5ad181,_0x189e80[_0x3d40('0x4f')]),{'include':_0x189e80[_0x3d40('0x34')][_0x3d40('0x45')]?[{'all':!![]}]:undefined})['then'](function(_0x358999){var _0x1d6445=_0x189e80[_0x3d40('0x50')][_0x3d40('0x51')]({'plain':!![]});if(!_0x1d6445)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x1d6445[_0x3d40('0x58')]===_0x3d40('0x50')){var _0x4600a2=_0x358999['get']({'plain':!![]});var _0x44d093=_0x3d40('0x28');return db[_0x3d40('0x59')][_0x3d40('0x4d')]({'where':{'name':_0x44d093,'userProfileId':_0x1d6445[_0x3d40('0x52')]},'raw':!![]})['then'](function(_0x850ccc){if(_0x850ccc&&_0x850ccc[_0x3d40('0x53')]===0x0){return db[_0x3d40('0x29')][_0x3d40('0x4e')]({'name':_0x4600a2[_0x3d40('0x2d')],'resourceId':_0x4600a2['id'],'type':_0x850ccc[_0x3d40('0x2d')],'sectionId':_0x850ccc['id']},{})[_0x3d40('0x26')](function(){return _0x358999;});}else{return _0x358999;}})['catch'](function(_0x5d14f8){logger['error']('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x5d14f8);throw _0x5d14f8;});}return _0x358999;});}})[_0x3d40('0x26')](respondWithResult(_0x40eb86,0xc9))['catch'](handleError(_0x40eb86,null));};exports[_0x3d40('0x25')]=function(_0x471d78,_0x19f033){if(_0x471d78[_0x3d40('0x4f')]['id']){delete _0x471d78[_0x3d40('0x4f')]['id'];}return db[_0x3d40('0x4c')][_0x3d40('0x4d')]({'where':{'id':_0x471d78[_0x3d40('0x4b')]['id']}})[_0x3d40('0x26')](handleEntityNotFound(_0x19f033,null))['then'](saveUpdates(_0x471d78[_0x3d40('0x4f')],null))[_0x3d40('0x26')](respondWithResult(_0x19f033,null))[_0x3d40('0x49')](handleError(_0x19f033,null));};exports[_0x3d40('0x27')]=function(_0x46ef8e,_0x25637f){return db[_0x3d40('0x4c')][_0x3d40('0x4d')]({'where':{'id':_0x46ef8e[_0x3d40('0x4b')]['id']}})['then'](handleEntityNotFound(_0x25637f,null))[_0x3d40('0x26')](removeEntity(_0x25637f,null))[_0x3d40('0x49')](handleError(_0x25637f,null));};exports[_0x3d40('0x5a')]=function(_0x11fc54,_0x2cfc63,_0x213ea9){var _0x4dc423={'raw':!![],'where':{}};var _0x4409a2={};var _0x5cea69={'count':0x0,'rows':[]};return db[_0x3d40('0x4c')][_0x3d40('0x5b')]({'where':{'id':_0x11fc54['params']['id']}})['then'](handleEntityNotFound(_0x2cfc63,null))[_0x3d40('0x26')](function(_0xa531d1){if(_0xa531d1){_0x4409a2[_0x3d40('0x39')]=_['keys'](db[_0x3d40('0x5c')][_0x3d40('0x30')]);_0x4409a2[_0x3d40('0x34')]=_['keys'](_0x11fc54[_0x3d40('0x34')]);_0x4409a2['filters']=_[_0x3d40('0x38')](_0x4409a2[_0x3d40('0x39')],_0x4409a2[_0x3d40('0x34')]);_0x4dc423[_0x3d40('0x37')]=_[_0x3d40('0x38')](_0x4409a2['model'],qs[_0x3d40('0x3a')](_0x11fc54['query']['fields']));_0x4dc423[_0x3d40('0x37')]=_0x4dc423['attributes'][_0x3d40('0x3b')]?_0x4dc423[_0x3d40('0x37')]:_0x4409a2[_0x3d40('0x39')];if(!_0x11fc54['query']['hasOwnProperty'](_0x3d40('0x3d'))){_0x4dc423[_0x3d40('0x21')]=qs['limit'](_0x11fc54['query'][_0x3d40('0x21')]);_0x4dc423['offset']=qs[_0x3d40('0x1e')](_0x11fc54[_0x3d40('0x34')][_0x3d40('0x1e')]);}_0x4dc423['order']=qs[_0x3d40('0x3f')](_0x11fc54[_0x3d40('0x34')][_0x3d40('0x3f')]);_0x4dc423[_0x3d40('0x40')]=qs[_0x3d40('0x36')](_[_0x3d40('0x5d')](_0x11fc54[_0x3d40('0x34')],_0x4409a2['filters']));_0x4dc423[_0x3d40('0x40')]['CampaignId']=_0xa531d1['id'];if(_0x11fc54[_0x3d40('0x34')][_0x3d40('0x43')]){_0x4dc423[_0x3d40('0x40')]=_[_0x3d40('0x41')](_0x4dc423[_0x3d40('0x40')],{'$or':_['map'](_0x4dc423[_0x3d40('0x37')],function(_0x183b7d){var _0x5416f3={};_0x5416f3[_0x183b7d]={'$like':'%'+_0x11fc54[_0x3d40('0x34')]['filter']+'%'};return _0x5416f3;})});}_0x4dc423=_[_0x3d40('0x41')]({},_0x4dc423,_0x11fc54[_0x3d40('0x44')]);return db[_0x3d40('0x5c')][_0x3d40('0x20')]({'where':_0x4dc423[_0x3d40('0x40')]})[_0x3d40('0x26')](function(_0x15e576){_0x5cea69['count']=_0x15e576;if(_0x11fc54[_0x3d40('0x34')][_0x3d40('0x45')]){_0x4dc423[_0x3d40('0x46')]=[{'all':!![]}];}return db[_0x3d40('0x5c')]['findAll'](_0x4dc423);})[_0x3d40('0x26')](function(_0x1e84f0){_0x5cea69[_0x3d40('0x48')]=_0x1e84f0;return _0x5cea69;});}})['then'](respondWithFilteredResult(_0x2cfc63,_0x4dc423))[_0x3d40('0x49')](handleError(_0x2cfc63,null));};exports['getHopperHistories']=function(_0x8883b2,_0x4647e5,_0x5bdbd8){var _0x317dcf={'raw':!![],'where':{}};var _0x568ba9={};var _0x229865={'count':0x0,'rows':[]};return db[_0x3d40('0x4c')][_0x3d40('0x5b')]({'where':{'id':_0x8883b2[_0x3d40('0x4b')]['id']}})[_0x3d40('0x26')](handleEntityNotFound(_0x4647e5,null))[_0x3d40('0x26')](function(_0x2916f9){if(_0x2916f9){_0x568ba9[_0x3d40('0x39')]=_[_0x3d40('0x35')](db['CmHopperHistory'][_0x3d40('0x30')]);_0x568ba9['query']=_[_0x3d40('0x35')](_0x8883b2[_0x3d40('0x34')]);_0x568ba9['filters']=_[_0x3d40('0x38')](_0x568ba9[_0x3d40('0x39')],_0x568ba9[_0x3d40('0x34')]);_0x317dcf['attributes']=_[_0x3d40('0x38')](_0x568ba9['model'],qs[_0x3d40('0x3a')](_0x8883b2[_0x3d40('0x34')][_0x3d40('0x3a')]));_0x317dcf[_0x3d40('0x37')]=_0x317dcf[_0x3d40('0x37')][_0x3d40('0x3b')]?_0x317dcf[_0x3d40('0x37')]:_0x568ba9[_0x3d40('0x39')];if(!_0x8883b2[_0x3d40('0x34')]['hasOwnProperty'](_0x3d40('0x3d'))){_0x317dcf[_0x3d40('0x21')]=qs[_0x3d40('0x21')](_0x8883b2[_0x3d40('0x34')][_0x3d40('0x21')]);_0x317dcf[_0x3d40('0x1e')]=qs[_0x3d40('0x1e')](_0x8883b2[_0x3d40('0x34')][_0x3d40('0x1e')]);}_0x317dcf[_0x3d40('0x3e')]=qs[_0x3d40('0x3f')](_0x8883b2['query'][_0x3d40('0x3f')]);_0x317dcf[_0x3d40('0x40')]=qs['filters'](_[_0x3d40('0x5d')](_0x8883b2[_0x3d40('0x34')],_0x568ba9['filters']));_0x317dcf['where'][_0x3d40('0x5e')]=_0x2916f9['id'];if(_0x8883b2[_0x3d40('0x34')][_0x3d40('0x43')]){_0x317dcf[_0x3d40('0x40')]=_[_0x3d40('0x41')](_0x317dcf[_0x3d40('0x40')],{'$or':_['map'](_0x317dcf[_0x3d40('0x37')],function(_0x97a8f2){var _0x1aca85={};_0x1aca85[_0x97a8f2]={'$like':'%'+_0x8883b2[_0x3d40('0x34')][_0x3d40('0x43')]+'%'};return _0x1aca85;})});}_0x317dcf=_[_0x3d40('0x41')]({},_0x317dcf,_0x8883b2[_0x3d40('0x44')]);return db['CmHopperHistory']['count']({'where':_0x317dcf[_0x3d40('0x40')]})['then'](function(_0x1c0932){_0x229865['count']=_0x1c0932;if(_0x8883b2[_0x3d40('0x34')][_0x3d40('0x45')]){_0x317dcf[_0x3d40('0x46')]=[{'all':!![]}];}return db[_0x3d40('0x5f')][_0x3d40('0x47')](_0x317dcf);})[_0x3d40('0x26')](function(_0x496311){_0x229865[_0x3d40('0x48')]=_0x496311;return _0x229865;});}})['then'](respondWithFilteredResult(_0x4647e5,_0x317dcf))['catch'](handleError(_0x4647e5,null));};exports[_0x3d40('0x60')]=function(_0x3d8be8,_0x37ccdd,_0x44578d){var _0x49e8fe={'raw':!![],'where':{}};var _0x2fbfb5={};var _0x3cbdcf={'count':0x0,'rows':[]};return db['Campaign'][_0x3d40('0x5b')]({'where':{'id':_0x3d8be8[_0x3d40('0x4b')]['id']}})[_0x3d40('0x26')](handleEntityNotFound(_0x37ccdd,null))[_0x3d40('0x26')](function(_0x162945){if(_0x162945){_0x2fbfb5['model']=_['keys'](db[_0x3d40('0x61')][_0x3d40('0x30')]);_0x2fbfb5['query']=_[_0x3d40('0x35')](_0x3d8be8['query']);_0x2fbfb5[_0x3d40('0x36')]=_['intersection'](_0x2fbfb5['model'],_0x2fbfb5['query']);_0x49e8fe[_0x3d40('0x37')]=_['intersection'](_0x2fbfb5[_0x3d40('0x39')],qs[_0x3d40('0x3a')](_0x3d8be8[_0x3d40('0x34')][_0x3d40('0x3a')]));_0x49e8fe[_0x3d40('0x37')]=_0x49e8fe[_0x3d40('0x37')][_0x3d40('0x3b')]?_0x49e8fe['attributes']:_0x2fbfb5[_0x3d40('0x39')];if(!_0x3d8be8[_0x3d40('0x34')][_0x3d40('0x3c')](_0x3d40('0x3d'))){_0x49e8fe[_0x3d40('0x21')]=qs[_0x3d40('0x21')](_0x3d8be8[_0x3d40('0x34')]['limit']);_0x49e8fe['offset']=qs[_0x3d40('0x1e')](_0x3d8be8[_0x3d40('0x34')][_0x3d40('0x1e')]);}_0x49e8fe[_0x3d40('0x3e')]=qs[_0x3d40('0x3f')](_0x3d8be8['query'][_0x3d40('0x3f')]);_0x49e8fe[_0x3d40('0x40')]=qs[_0x3d40('0x36')](_[_0x3d40('0x5d')](_0x3d8be8[_0x3d40('0x34')],_0x2fbfb5[_0x3d40('0x36')]));_0x49e8fe[_0x3d40('0x40')]['CampaignId']=_0x162945['id'];if(_0x3d8be8['query'][_0x3d40('0x43')]){_0x49e8fe[_0x3d40('0x40')]=_[_0x3d40('0x41')](_0x49e8fe[_0x3d40('0x40')],{'$or':_['map'](_0x49e8fe[_0x3d40('0x37')],function(_0x385429){var _0x362bec={};_0x362bec[_0x385429]={'$like':'%'+_0x3d8be8[_0x3d40('0x34')]['filter']+'%'};return _0x362bec;})});}_0x49e8fe=_[_0x3d40('0x41')]({},_0x49e8fe,_0x3d8be8['options']);return db[_0x3d40('0x61')][_0x3d40('0x20')]({'where':_0x49e8fe[_0x3d40('0x40')]})['then'](function(_0x49a656){_0x3cbdcf[_0x3d40('0x20')]=_0x49a656;if(_0x3d8be8['query'][_0x3d40('0x45')]){_0x49e8fe['include']=[{'all':!![]}];}return db['CmHopperFinal'][_0x3d40('0x47')](_0x49e8fe);})[_0x3d40('0x26')](function(_0x51917c){_0x3cbdcf[_0x3d40('0x48')]=_0x51917c;return _0x3cbdcf;});}})[_0x3d40('0x26')](respondWithFilteredResult(_0x37ccdd,_0x49e8fe))[_0x3d40('0x49')](handleError(_0x37ccdd,null));};exports[_0x3d40('0x62')]=function(_0x5512f4,_0x1495ae,_0x281525){var _0x42ca13={'raw':!![],'where':{}};var _0x4b0adb={};var _0x3345bc={'count':0x0,'rows':[]};return db[_0x3d40('0x4c')]['findOne']({'where':{'id':_0x5512f4[_0x3d40('0x4b')]['id']}})[_0x3d40('0x26')](handleEntityNotFound(_0x1495ae,null))[_0x3d40('0x26')](function(_0x382776){if(_0x382776){_0x4b0adb[_0x3d40('0x39')]=_[_0x3d40('0x35')](db['CmHopperBlack'][_0x3d40('0x30')]);_0x4b0adb[_0x3d40('0x34')]=_[_0x3d40('0x35')](_0x5512f4[_0x3d40('0x34')]);_0x4b0adb[_0x3d40('0x36')]=_[_0x3d40('0x38')](_0x4b0adb['model'],_0x4b0adb['query']);_0x42ca13[_0x3d40('0x37')]=_[_0x3d40('0x38')](_0x4b0adb['model'],qs['fields'](_0x5512f4['query'][_0x3d40('0x3a')]));_0x42ca13[_0x3d40('0x37')]=_0x42ca13[_0x3d40('0x37')]['length']?_0x42ca13[_0x3d40('0x37')]:_0x4b0adb['model'];if(!_0x5512f4[_0x3d40('0x34')][_0x3d40('0x3c')](_0x3d40('0x3d'))){_0x42ca13[_0x3d40('0x21')]=qs[_0x3d40('0x21')](_0x5512f4[_0x3d40('0x34')][_0x3d40('0x21')]);_0x42ca13['offset']=qs[_0x3d40('0x1e')](_0x5512f4[_0x3d40('0x34')][_0x3d40('0x1e')]);}_0x42ca13[_0x3d40('0x3e')]=qs[_0x3d40('0x3f')](_0x5512f4[_0x3d40('0x34')]['sort']);_0x42ca13[_0x3d40('0x40')]=qs[_0x3d40('0x36')](_['pick'](_0x5512f4[_0x3d40('0x34')],_0x4b0adb[_0x3d40('0x36')]));_0x42ca13['where'][_0x3d40('0x5e')]=_0x382776['id'];if(_0x5512f4['query'][_0x3d40('0x43')]){_0x42ca13[_0x3d40('0x40')]=_['merge'](_0x42ca13[_0x3d40('0x40')],{'$or':_[_0x3d40('0x2f')](_0x42ca13['attributes'],function(_0x3bd591){var _0x16f64d={};_0x16f64d[_0x3bd591]={'$like':'%'+_0x5512f4[_0x3d40('0x34')][_0x3d40('0x43')]+'%'};return _0x16f64d;})});}_0x42ca13=_['merge']({},_0x42ca13,_0x5512f4['options']);return db[_0x3d40('0x63')][_0x3d40('0x20')]({'where':_0x42ca13[_0x3d40('0x40')]})['then'](function(_0x2ffed4){_0x3345bc['count']=_0x2ffed4;if(_0x5512f4['query'][_0x3d40('0x45')]){_0x42ca13[_0x3d40('0x46')]=[{'all':!![]}];}return db['CmHopperBlack'][_0x3d40('0x47')](_0x42ca13);})[_0x3d40('0x26')](function(_0x3773e9){_0x3345bc[_0x3d40('0x48')]=_0x3773e9;return _0x3345bc;});}})[_0x3d40('0x26')](respondWithFilteredResult(_0x1495ae,_0x42ca13))[_0x3d40('0x49')](handleError(_0x1495ae,null));};exports[_0x3d40('0x64')]=function(_0x230d49,_0x43d62d,_0xd243c4){var _0x334633={};var _0x4abce8={};var _0x3773e5;var _0x37a6bf;return db[_0x3d40('0x4c')][_0x3d40('0x5b')]({'where':{'id':_0x230d49[_0x3d40('0x4b')]['id']}})[_0x3d40('0x26')](handleEntityNotFound(_0x43d62d,null))['then'](function(_0x37bacc){if(_0x37bacc){_0x3773e5=_0x37bacc;_0x4abce8[_0x3d40('0x39')]=_[_0x3d40('0x35')](db['CmList']['rawAttributes']);_0x4abce8[_0x3d40('0x34')]=_[_0x3d40('0x35')](_0x230d49['query']);_0x4abce8[_0x3d40('0x36')]=_[_0x3d40('0x38')](_0x4abce8['model'],_0x4abce8['query']);_0x334633[_0x3d40('0x37')]=_[_0x3d40('0x38')](_0x4abce8['model'],qs['fields'](_0x230d49[_0x3d40('0x34')][_0x3d40('0x3a')]));_0x334633['attributes']=_0x334633['attributes'][_0x3d40('0x3b')]?_0x334633['attributes']:_0x4abce8[_0x3d40('0x39')];_0x334633['order']=qs[_0x3d40('0x3f')](_0x230d49[_0x3d40('0x34')][_0x3d40('0x3f')]);_0x334633['where']=qs[_0x3d40('0x36')](_[_0x3d40('0x5d')](_0x230d49[_0x3d40('0x34')],_0x4abce8[_0x3d40('0x36')]));if(_0x230d49[_0x3d40('0x34')][_0x3d40('0x43')]){_0x334633[_0x3d40('0x40')]=_[_0x3d40('0x41')](_0x334633[_0x3d40('0x40')],{'$or':_['map'](_0x334633[_0x3d40('0x37')],function(_0xc92421){var _0x58f6a7={};_0x58f6a7[_0xc92421]={'$like':'%'+_0x230d49[_0x3d40('0x34')]['filter']+'%'};return _0x58f6a7;})});}_0x334633=_[_0x3d40('0x41')]({},_0x334633,_0x230d49[_0x3d40('0x44')]);return _0x3773e5[_0x3d40('0x64')](_0x334633);}})[_0x3d40('0x26')](function(_0x5b0f25){if(_0x5b0f25){_0x37a6bf=_0x5b0f25[_0x3d40('0x3b')];if(!_0x230d49['query'][_0x3d40('0x3c')](_0x3d40('0x3d'))){_0x334633[_0x3d40('0x21')]=qs[_0x3d40('0x21')](_0x230d49[_0x3d40('0x34')][_0x3d40('0x21')]);_0x334633[_0x3d40('0x1e')]=qs[_0x3d40('0x1e')](_0x230d49[_0x3d40('0x34')][_0x3d40('0x1e')]);}return _0x3773e5['getLists'](_0x334633);}})[_0x3d40('0x26')](function(_0x5d4a70){if(_0x5d4a70){return _0x5d4a70?{'count':_0x37a6bf,'rows':_0x5d4a70}:null;}})[_0x3d40('0x26')](respondWithResult(_0x43d62d,null))[_0x3d40('0x49')](handleError(_0x43d62d,null));};exports[_0x3d40('0x65')]=function(_0xf3c644,_0x26309d,_0x1d8f41){var _0x39bf67,_0x43e18e;var _0x1d5a17=[];var _0x836dc7=moment()['format'](_0x3d40('0x66'));return db[_0x3d40('0x4c')][_0x3d40('0x4d')]({'where':{'id':_0xf3c644[_0x3d40('0x4b')]['id']}})[_0x3d40('0x26')](handleEntityNotFound(_0x26309d,null))[_0x3d40('0x26')](function(_0x41d3ca){if(_0x41d3ca){_0x43e18e=_0x41d3ca;return _0x41d3ca['addLists'](_0xf3c644[_0x3d40('0x4f')]['ids'],_[_0x3d40('0x57')](_0xf3c644['body'],[_0x3d40('0x67'),'id'])||{});}return null;})[_0x3d40('0x68')](function(_0x1b80d6){var _0x275a02;var _0x49848e;_0x39bf67=_0x1b80d6||[];var _0x3eda3d=[];if(_0x1b80d6){for(var _0x2a8851=0x0;_0x2a8851<_0x1b80d6['length'];_0x2a8851+=0x1){var _0x11f1bd=_0x1b80d6[_0x2a8851][_0x3d40('0x51')]({'plain':!![]});_0x43e18e[_0x3d40('0x69')]=_0xf3c644[_0x3d40('0x4f')][_0x3d40('0x69')]?_0xf3c644['body']['dialCheckDuplicateType']:_0x43e18e[_0x3d40('0x69')];switch(_0x43e18e['dialCheckDuplicateType']){case _0x3d40('0x6a'):_0x275a02=squel['insert']()[_0x3d40('0x6b')](_0x3d40('0x6c'))[_0x3d40('0x6d')]([_0x3d40('0x6e'),_0x3d40('0x6f'),_0x3d40('0x70'),_0x3d40('0x71'),_0x3d40('0x5e'),_0x3d40('0x72'),_0x3d40('0x56')],squel['select']()['field'](_0x3d40('0x6e'),'phone')['field'](_0x3d40('0x73'),'scheduledAt')[_0x3d40('0x74')]('id',_0x3d40('0x70'))[_0x3d40('0x74')](_0x11f1bd['CmListId'][_0x3d40('0x75')](),_0x3d40('0x71'))[_0x3d40('0x74')](_0xf3c644[_0x3d40('0x4b')]['id'][_0x3d40('0x75')](),_0x3d40('0x5e'))[_0x3d40('0x74')]('\x27'+_0x836dc7+'\x27',_0x3d40('0x72'))['field']('\x27'+_0x836dc7+'\x27',_0x3d40('0x56'))['from']('cm_contacts')[_0x3d40('0x40')](_0x3d40('0x76'))[_0x3d40('0x40')](_0x3d40('0x77'),_0x11f1bd[_0x3d40('0x78')]['toString']())[_0x3d40('0x40')](_0x3d40('0x79'))[_0x3d40('0x40')]('phone\x20NOT\x20IN\x20(?)',squel[_0x3d40('0x7a')]()[_0x3d40('0x74')](_0x3d40('0x7b'))[_0x3d40('0x7c')]('cm_hopper_final')[_0x3d40('0x40')]('CampaignId\x20=\x20?',_0xf3c644[_0x3d40('0x4b')]['id'][_0x3d40('0x75')]()))[_0x3d40('0x40')](_0x3d40('0x7d'),squel[_0x3d40('0x7a')]()[_0x3d40('0x74')](_0x3d40('0x7e'))[_0x3d40('0x7c')](_0x3d40('0x6c'))[_0x3d40('0x40')]('CampaignId\x20=\x20?',_0xf3c644[_0x3d40('0x4b')]['id'][_0x3d40('0x75')]())))['toString']();break;case _0x3d40('0x7f'):_0x275a02=squel[_0x3d40('0x80')]()[_0x3d40('0x6b')](_0x3d40('0x6c'))['fromQuery']([_0x3d40('0x6e'),_0x3d40('0x6f'),'ContactId',_0x3d40('0x71'),'CampaignId',_0x3d40('0x72'),_0x3d40('0x56')],squel[_0x3d40('0x7a')]()[_0x3d40('0x74')](_0x3d40('0x6e'),'phone')['field'](_0x3d40('0x73'),_0x3d40('0x6f'))[_0x3d40('0x74')]('id',_0x3d40('0x70'))[_0x3d40('0x74')](_0x11f1bd['CmListId'][_0x3d40('0x75')](),_0x3d40('0x71'))[_0x3d40('0x74')](_0xf3c644['params']['id']['toString'](),_0x3d40('0x5e'))[_0x3d40('0x74')]('\x27'+_0x836dc7+'\x27',_0x3d40('0x72'))[_0x3d40('0x74')]('\x27'+_0x836dc7+'\x27',_0x3d40('0x56'))[_0x3d40('0x7c')](_0x3d40('0x81'))[_0x3d40('0x40')](_0x3d40('0x76'))['where'](_0x3d40('0x77'),_0x11f1bd[_0x3d40('0x78')][_0x3d40('0x75')]())[_0x3d40('0x40')](_0x3d40('0x79'))['where'](_0x3d40('0x7d'),squel[_0x3d40('0x7a')]()[_0x3d40('0x74')](_0x3d40('0x7e'))[_0x3d40('0x7c')](_0x3d40('0x6c'))[_0x3d40('0x40')](_0x3d40('0x82'),_0xf3c644[_0x3d40('0x4b')]['id'][_0x3d40('0x75')]())))[_0x3d40('0x75')]();break;default:_0x275a02=squel[_0x3d40('0x80')]()['into'](_0x3d40('0x6c'))[_0x3d40('0x6d')]([_0x3d40('0x6e'),_0x3d40('0x6f'),_0x3d40('0x70'),_0x3d40('0x71'),_0x3d40('0x5e'),_0x3d40('0x72'),_0x3d40('0x56')],squel['select']()[_0x3d40('0x74')](_0x3d40('0x6e'),_0x3d40('0x6e'))[_0x3d40('0x74')](_0x3d40('0x73'),_0x3d40('0x6f'))[_0x3d40('0x74')]('id',_0x3d40('0x70'))['field'](_0x11f1bd[_0x3d40('0x78')][_0x3d40('0x75')](),_0x3d40('0x71'))[_0x3d40('0x74')](_0xf3c644[_0x3d40('0x4b')]['id'][_0x3d40('0x75')](),_0x3d40('0x5e'))[_0x3d40('0x74')]('\x27'+_0x836dc7+'\x27',_0x3d40('0x72'))[_0x3d40('0x74')]('\x27'+_0x836dc7+'\x27',_0x3d40('0x56'))[_0x3d40('0x7c')](_0x3d40('0x81'))[_0x3d40('0x40')]('deletedAt\x20IS\x20NULL')[_0x3d40('0x40')](_0x3d40('0x77'),_0x11f1bd['CmListId'][_0x3d40('0x75')]())[_0x3d40('0x40')](_0x3d40('0x79')))[_0x3d40('0x75')]();}_0x49848e=squel['insert']()[_0x3d40('0x6b')](_0x3d40('0x83'))[_0x3d40('0x6d')]([_0x3d40('0x84'),_0x3d40('0x6f'),_0x3d40('0x6e'),'OrderBy',_0x3d40('0x72'),'updatedAt'],squel[_0x3d40('0x7a')]()[_0x3d40('0x74')](_0x3d40('0x85'),'id')['field']('NOW()',_0x3d40('0x6f'))[_0x3d40('0x74')]('ci.item',_0x3d40('0x6e'))[_0x3d40('0x74')](_0x3d40('0x86'),_0x3d40('0x87'))[_0x3d40('0x74')]('\x27'+_0x836dc7+'\x27',_0x3d40('0x72'))['field']('\x27'+_0x836dc7+'\x27','updatedAt')[_0x3d40('0x7c')](_0x3d40('0x88'),'ci')[_0x3d40('0x89')](_0x3d40('0x6c'),'h',_0x3d40('0x8a'))[_0x3d40('0x40')](_0x3d40('0x8b'),_0x11f1bd[_0x3d40('0x78')][_0x3d40('0x75')]())[_0x3d40('0x40')]('h.CampaignId=?',_0xf3c644[_0x3d40('0x4b')]['id']['toString']())[_0x3d40('0x40')](_0x3d40('0x8c'),_0x836dc7))['toString']();_0x3eda3d[_0x3d40('0x8d')](db[_0x3d40('0x8e')][_0x3d40('0x34')](_0x275a02));_0x1d5a17[_0x3d40('0x8d')](db[_0x3d40('0x8e')][_0x3d40('0x34')](_0x49848e));}return BPromise['all'](_0x3eda3d);}})[_0x3d40('0x26')](function(){return BPromise[_0x3d40('0x8f')](_0x1d5a17);})[_0x3d40('0x26')](function(){return _0x39bf67;})[_0x3d40('0x26')](respondWithResult(_0x26309d,null))[_0x3d40('0x49')](handleError(_0x26309d,null));};exports[_0x3d40('0x90')]=function(_0x2d6556,_0x22e4f5,_0x11851a){return db[_0x3d40('0x4c')][_0x3d40('0x4d')]({'where':{'id':_0x2d6556['params']['id']}})[_0x3d40('0x26')](handleEntityNotFound(_0x22e4f5,null))[_0x3d40('0x26')](function(_0x1c80ff){if(_0x1c80ff){return _0x1c80ff[_0x3d40('0x90')](_0x2d6556[_0x3d40('0x34')][_0x3d40('0x67')]);}})['then'](function(_0x213153){if(_0x213153){return db[_0x3d40('0x5c')]['destroy']({'where':{'ListId':_0x2d6556[_0x3d40('0x34')][_0x3d40('0x67')],'CampaignId':_0x2d6556[_0x3d40('0x4b')]['id']}})['then'](function(){return _0x213153;});}})[_0x3d40('0x26')](respondWithStatusCode(_0x22e4f5,null))[_0x3d40('0x49')](handleError(_0x22e4f5,null));};exports[_0x3d40('0x91')]=function(_0x16f636,_0x1f75b2,_0x10e479){var _0x11c7c3={};var _0x36a069={};var _0x5ab498;var _0x325579;return db[_0x3d40('0x4c')][_0x3d40('0x5b')]({'where':{'id':_0x16f636['params']['id']}})[_0x3d40('0x26')](handleEntityNotFound(_0x1f75b2,null))[_0x3d40('0x26')](function(_0x13e1dc){if(_0x13e1dc){_0x5ab498=_0x13e1dc;_0x36a069[_0x3d40('0x39')]=_['keys'](db['CmList'][_0x3d40('0x30')]);_0x36a069[_0x3d40('0x34')]=_[_0x3d40('0x35')](_0x16f636[_0x3d40('0x34')]);_0x36a069['filters']=_[_0x3d40('0x38')](_0x36a069[_0x3d40('0x39')],_0x36a069[_0x3d40('0x34')]);_0x11c7c3[_0x3d40('0x37')]=_['intersection'](_0x36a069[_0x3d40('0x39')],qs['fields'](_0x16f636[_0x3d40('0x34')][_0x3d40('0x3a')]));_0x11c7c3[_0x3d40('0x37')]=_0x11c7c3[_0x3d40('0x37')][_0x3d40('0x3b')]?_0x11c7c3['attributes']:_0x36a069['model'];_0x11c7c3['order']=qs[_0x3d40('0x3f')](_0x16f636[_0x3d40('0x34')][_0x3d40('0x3f')]);_0x11c7c3['where']=qs['filters'](_[_0x3d40('0x5d')](_0x16f636[_0x3d40('0x34')],_0x36a069[_0x3d40('0x36')]));if(_0x16f636['query'][_0x3d40('0x43')]){_0x11c7c3[_0x3d40('0x40')]=_[_0x3d40('0x41')](_0x11c7c3['where'],{'$or':_[_0x3d40('0x2f')](_0x11c7c3[_0x3d40('0x37')],function(_0x4d7817){var _0x22f625={};_0x22f625[_0x4d7817]={'$like':'%'+_0x16f636[_0x3d40('0x34')][_0x3d40('0x43')]+'%'};return _0x22f625;})});}_0x11c7c3=_[_0x3d40('0x41')]({},_0x11c7c3,_0x16f636[_0x3d40('0x44')]);return _0x5ab498[_0x3d40('0x91')](_0x11c7c3);}})[_0x3d40('0x26')](function(_0x394aba){if(_0x394aba){_0x325579=_0x394aba['length'];if(!_0x16f636[_0x3d40('0x34')]['hasOwnProperty']('nolimit')){_0x11c7c3[_0x3d40('0x21')]=qs[_0x3d40('0x21')](_0x16f636['query']['limit']);_0x11c7c3[_0x3d40('0x1e')]=qs[_0x3d40('0x1e')](_0x16f636[_0x3d40('0x34')][_0x3d40('0x1e')]);}return _0x5ab498[_0x3d40('0x91')](_0x11c7c3);}})[_0x3d40('0x26')](function(_0x3f2ad8){if(_0x3f2ad8){return _0x3f2ad8?{'count':_0x325579,'rows':_0x3f2ad8}:null;}})['then'](respondWithResult(_0x1f75b2,null))[_0x3d40('0x49')](handleError(_0x1f75b2,null));};exports['addBlackLists']=function(_0x5b5cdc,_0x27f2bc,_0x335ad2){var _0x46f5bd,_0x1ba164;var _0x2ed7ba=[];var _0x5b90be=moment()[_0x3d40('0x92')](_0x3d40('0x66'));return db[_0x3d40('0x4c')][_0x3d40('0x4d')]({'where':{'id':_0x5b5cdc[_0x3d40('0x4b')]['id']}})['then'](handleEntityNotFound(_0x27f2bc,null))[_0x3d40('0x26')](function(_0x30a94f){if(_0x30a94f){_0x1ba164=_0x30a94f;return _0x30a94f['addBlackLists'](_0x5b5cdc[_0x3d40('0x4f')]['ids'],_[_0x3d40('0x57')](_0x5b5cdc[_0x3d40('0x4f')],[_0x3d40('0x67'),'id'])||{});}return null;})[_0x3d40('0x68')](function(_0x397301){var _0x5bb0dc;var _0x278733;_0x46f5bd=_0x397301||[];var _0x1ebfef=[];if(_0x397301){for(var _0x4442f8=0x0;_0x4442f8<_0x397301['length'];_0x4442f8+=0x1){var _0x3d17e2=_0x397301[_0x4442f8][_0x3d40('0x51')]({'plain':!![]});_0x5bb0dc=squel[_0x3d40('0x80')]()[_0x3d40('0x6b')](_0x3d40('0x93'))[_0x3d40('0x6d')]([_0x3d40('0x6e'),_0x3d40('0x70'),'ListId',_0x3d40('0x5e'),_0x3d40('0x72'),'updatedAt'],squel['select']()[_0x3d40('0x74')](_0x3d40('0x6e'),_0x3d40('0x6e'))[_0x3d40('0x74')]('id',_0x3d40('0x70'))[_0x3d40('0x74')](_0x3d17e2[_0x3d40('0x78')][_0x3d40('0x75')](),'ListId')['field'](_0x5b5cdc[_0x3d40('0x4b')]['id']['toString'](),'CampaignId')[_0x3d40('0x74')](_0x3d40('0x73'),_0x3d40('0x72'))[_0x3d40('0x74')](_0x3d40('0x73'),_0x3d40('0x56'))[_0x3d40('0x7c')](_0x3d40('0x81'))[_0x3d40('0x40')]('deletedAt\x20IS\x20NULL')['where']('ListId\x20=\x20?',_0x3d17e2[_0x3d40('0x78')]['toString']())['where']('phone\x20IS\x20NOT\x20NULL'))[_0x3d40('0x75')]();_0x1ebfef[_0x3d40('0x8d')](db[_0x3d40('0x8e')][_0x3d40('0x34')](_0x5bb0dc));}return BPromise[_0x3d40('0x8f')](_0x1ebfef);}})[_0x3d40('0x26')](function(){return _0x46f5bd;})['then'](respondWithResult(_0x27f2bc,null))[_0x3d40('0x49')](handleError(_0x27f2bc,null));};exports[_0x3d40('0x94')]=function(_0x177fc5,_0x4d8afe,_0x5df071){return db[_0x3d40('0x4c')][_0x3d40('0x4d')]({'where':{'id':_0x177fc5[_0x3d40('0x4b')]['id']}})['then'](handleEntityNotFound(_0x4d8afe,null))['then'](function(_0x16c7c7){if(_0x16c7c7){return _0x16c7c7[_0x3d40('0x94')](_0x177fc5[_0x3d40('0x34')][_0x3d40('0x67')]);}})[_0x3d40('0x26')](function(_0x1e4d30){if(_0x1e4d30){return db['CmHopperBlack']['destroy']({'where':{'ListId':_0x177fc5[_0x3d40('0x34')][_0x3d40('0x67')],'CampaignId':_0x177fc5[_0x3d40('0x4b')]['id']}})[_0x3d40('0x26')](function(){return _0x1e4d30;});}})[_0x3d40('0x26')](respondWithStatusCode(_0x4d8afe,null))[_0x3d40('0x49')](handleError(_0x4d8afe,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff