// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xb903=['request-promise','moment','bluebird','mustache','util','path','sox','ejs','crypto','jsforce','desk.js','to-csv','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','end','status','offset','set','Content-Range','json','reject','update','then','destroy','get','IvrCampaigns','UserProfileResource','sendStatus','error','stack','name','send','map','Campaign','rawAttributes','key','model','query','filters','intersection','fields','attributes','hasOwnProperty','nolimit','limit','order','sort','pick','filter','where','type','VIRTUAL','options','count','includeAll','include','findAll','rows','catch','show','params','keys','length','merge','create','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','user','UserProfileSection','userProfileId','clone','find','omit','createdAt','updatedAt','body','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','getHoppers','CmHopper','CampaignId','getHopperHistories','findOne','CmHopperHistory','getHopperFinals','CmHopperFinal','CmHopperBlack','CmList','getLists','addLists','ids','dialCheckDuplicateType','always','insert','cm_hopper','phone','scheduledAt','select','field','NOW()','ContactId','CmListId','toString','ListId','cm_contacts','deletedAt\x20IS\x20NULL','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','COALESCE(calleridnum,\x27\x27)','from','cm_hopper_final','CampaignId\x20=\x20?','COALESCE(phone,\x27\x27)','onlyIfOpen','into','fromQuery','ListId\x20=\x20?','push','sequelize','all','removeLists','getBlackLists','addBlackLists','spread','cm_hopper_black','removeBlackLists','html-pdf','eml-format','rimraf','zip-dir'];(function(_0x5e6e2a,_0x54984e){var _0x9ca794=function(_0x305a69){while(--_0x305a69){_0x5e6e2a['push'](_0x5e6e2a['shift']());}};_0x9ca794(++_0x54984e);}(_0xb903,0x185));var _0x3b90=function(_0x25723b,_0x4b2be7){_0x25723b=_0x25723b-0x0;var _0x125f8a=_0xb903[_0x25723b];return _0x125f8a;};'use strict';var pdf=require(_0x3b90('0x0'));var emlformat=require(_0x3b90('0x1'));var rimraf=require(_0x3b90('0x2'));var zipdir=require(_0x3b90('0x3'));var jsonpatch=require('fast-json-patch');var rp=require(_0x3b90('0x4'));var moment=require(_0x3b90('0x5'));var BPromise=require(_0x3b90('0x6'));var Mustache=require(_0x3b90('0x7'));var util=require(_0x3b90('0x8'));var path=require(_0x3b90('0x9'));var sox=require(_0x3b90('0xa'));var csv=require('to-csv');var ejs=require(_0x3b90('0xb'));var fs=require('fs');var _=require('lodash');var squel=require('squel');var crypto=require(_0x3b90('0xc'));var jsforce=require(_0x3b90('0xd'));var deskjs=require(_0x3b90('0xe'));var toCsv=require(_0x3b90('0xf'));var querystring=require('querystring');var Papa=require('papaparse');var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x3b90('0x10'));var logger=require(_0x3b90('0x11'))('api');var utils=require(_0x3b90('0x12'));var config=require(_0x3b90('0x13'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x45b75f,_0x174c0d){_0x174c0d=_0x174c0d||0xcc;return function(_0x43c08c){if(_0x43c08c){return _0x45b75f['sendStatus'](_0x174c0d);}return _0x45b75f['status'](_0x174c0d)[_0x3b90('0x14')]();};}function respondWithResult(_0x542cb3,_0x492d39){_0x492d39=_0x492d39||0xc8;return function(_0x3a0a55){if(_0x3a0a55){return _0x542cb3[_0x3b90('0x15')](_0x492d39)['json'](_0x3a0a55);}};}function respondWithFilteredResult(_0x51fb66,_0x3725b9){return function(_0x1b6349){if(_0x1b6349){var _0x381a9e=_0x1b6349['count'],_0x1af265=_0x3725b9[_0x3b90('0x16')],_0x1efe01=_0x3725b9[_0x3b90('0x16')]+_0x3725b9['limit'],_0x529421;if(_0x1efe01>=_0x381a9e){_0x1efe01=_0x381a9e;_0x529421=0xc8;}else{_0x529421=0xce;}_0x51fb66[_0x3b90('0x15')](_0x529421);return _0x51fb66[_0x3b90('0x17')](_0x3b90('0x18'),_0x1af265+'-'+_0x1efe01+'/'+_0x381a9e)[_0x3b90('0x19')](_0x1b6349);}return null;};}function patchUpdates(_0x4f388b){return function(_0x3014d8){try{jsonpatch['apply'](_0x3014d8,_0x4f388b,!![]);}catch(_0xd8d873){return BPromise[_0x3b90('0x1a')](_0xd8d873);}return _0x3014d8['save']();};}function saveUpdates(_0x39ae7c,_0x12e1cf){return function(_0x3642c0){if(_0x3642c0){return _0x3642c0[_0x3b90('0x1b')](_0x39ae7c)[_0x3b90('0x1c')](function(_0x43deca){return _0x43deca;});}return null;};}function removeEntity(_0x3bc7d5,_0x2f4270){return function(_0xa98414){if(_0xa98414){return _0xa98414[_0x3b90('0x1d')]()['then'](function(){var _0x20b06a=_0xa98414[_0x3b90('0x1e')]({'plain':!![]});var _0x175b42=_0x3b90('0x1f');return db[_0x3b90('0x20')][_0x3b90('0x1d')]({'where':{'type':_0x175b42,'resourceId':_0x20b06a['id']}})['then'](function(){return _0xa98414;});})['then'](function(){_0x3bc7d5[_0x3b90('0x15')](0xcc)[_0x3b90('0x14')]();});}};}function handleEntityNotFound(_0x103324,_0x2ffa1a){return function(_0x583523){if(!_0x583523){_0x103324[_0x3b90('0x21')](0x194);}return _0x583523;};}function handleError(_0x2936d7,_0x1787d1){_0x1787d1=_0x1787d1||0x1f4;return function(_0x4caead){logger[_0x3b90('0x22')](_0x4caead[_0x3b90('0x23')]);if(_0x4caead[_0x3b90('0x24')]){delete _0x4caead[_0x3b90('0x24')];}_0x2936d7[_0x3b90('0x15')](_0x1787d1)[_0x3b90('0x25')](_0x4caead);};}exports['index']=function(_0x1a839d,_0x595ac1){var _0xaf453c={},_0x9891e4={},_0x1a193e={'count':0x0,'rows':[]};var _0x38eed0=_[_0x3b90('0x26')](db[_0x3b90('0x27')][_0x3b90('0x28')],function(_0x2430ec){return{'name':_0x2430ec['fieldName'],'type':_0x2430ec['type'][_0x3b90('0x29')]};});_0x9891e4[_0x3b90('0x2a')]=_[_0x3b90('0x26')](_0x38eed0,_0x3b90('0x24'));_0x9891e4['query']=_['keys'](_0x1a839d[_0x3b90('0x2b')]);_0x9891e4[_0x3b90('0x2c')]=_[_0x3b90('0x2d')](_0x9891e4['model'],_0x9891e4[_0x3b90('0x2b')]);_0xaf453c['attributes']=_['intersection'](_0x9891e4[_0x3b90('0x2a')],qs[_0x3b90('0x2e')](_0x1a839d['query'][_0x3b90('0x2e')]));_0xaf453c[_0x3b90('0x2f')]=_0xaf453c[_0x3b90('0x2f')]['length']?_0xaf453c['attributes']:_0x9891e4[_0x3b90('0x2a')];if(!_0x1a839d[_0x3b90('0x2b')][_0x3b90('0x30')](_0x3b90('0x31'))){_0xaf453c['limit']=qs['limit'](_0x1a839d[_0x3b90('0x2b')][_0x3b90('0x32')]);_0xaf453c['offset']=qs['offset'](_0x1a839d[_0x3b90('0x2b')][_0x3b90('0x16')]);}_0xaf453c[_0x3b90('0x33')]=qs[_0x3b90('0x34')](_0x1a839d['query'][_0x3b90('0x34')]);_0xaf453c['where']=qs[_0x3b90('0x2c')](_[_0x3b90('0x35')](_0x1a839d[_0x3b90('0x2b')],_0x9891e4[_0x3b90('0x2c')]));if(_0x1a839d[_0x3b90('0x2b')][_0x3b90('0x36')]){_0xaf453c[_0x3b90('0x37')]=_['merge'](_0xaf453c[_0x3b90('0x37')],{'$or':_[_0x3b90('0x26')](_0x38eed0,function(_0x2fd30c){if(_0x2fd30c[_0x3b90('0x38')]!==_0x3b90('0x39')){var _0x390952={};_0x390952[_0x2fd30c[_0x3b90('0x24')]]={'$like':'%'+_0x1a839d[_0x3b90('0x2b')][_0x3b90('0x36')]+'%'};return _0x390952;}})});}_0xaf453c=_['merge']({},_0xaf453c,_0x1a839d[_0x3b90('0x3a')]);var _0x1b915d={'where':_0xaf453c[_0x3b90('0x37')]};return db[_0x3b90('0x27')][_0x3b90('0x3b')](_0x1b915d)[_0x3b90('0x1c')](function(_0x1a76cb){_0x1a193e[_0x3b90('0x3b')]=_0x1a76cb;if(_0x1a839d[_0x3b90('0x2b')][_0x3b90('0x3c')]){_0xaf453c[_0x3b90('0x3d')]=[{'all':!![]}];}return db[_0x3b90('0x27')][_0x3b90('0x3e')](_0xaf453c);})[_0x3b90('0x1c')](function(_0x3f3e6b){_0x1a193e[_0x3b90('0x3f')]=_0x3f3e6b;return _0x1a193e;})[_0x3b90('0x1c')](respondWithFilteredResult(_0x595ac1,_0xaf453c))[_0x3b90('0x40')](handleError(_0x595ac1,null));};exports[_0x3b90('0x41')]=function(_0x37e8dd,_0x11698a){var _0x4d1157={'raw':![],'where':{'id':_0x37e8dd[_0x3b90('0x42')]['id']}},_0x28d70b={};_0x28d70b[_0x3b90('0x2a')]=_[_0x3b90('0x43')](db['Campaign'][_0x3b90('0x28')]);_0x28d70b['query']=_['keys'](_0x37e8dd[_0x3b90('0x2b')]);_0x28d70b[_0x3b90('0x2c')]=_['intersection'](_0x28d70b[_0x3b90('0x2a')],_0x28d70b[_0x3b90('0x2b')]);_0x4d1157[_0x3b90('0x2f')]=_[_0x3b90('0x2d')](_0x28d70b[_0x3b90('0x2a')],qs[_0x3b90('0x2e')](_0x37e8dd[_0x3b90('0x2b')][_0x3b90('0x2e')]));_0x4d1157[_0x3b90('0x2f')]=_0x4d1157['attributes'][_0x3b90('0x44')]?_0x4d1157[_0x3b90('0x2f')]:_0x28d70b['model'];if(_0x37e8dd[_0x3b90('0x2b')][_0x3b90('0x3c')]){_0x4d1157[_0x3b90('0x3d')]=[{'all':!![]}];}_0x4d1157=_[_0x3b90('0x45')]({},_0x4d1157,_0x37e8dd[_0x3b90('0x3a')]);return db['Campaign']['find'](_0x4d1157)[_0x3b90('0x1c')](handleEntityNotFound(_0x11698a,null))['then'](respondWithResult(_0x11698a,null))[_0x3b90('0x40')](handleError(_0x11698a,null));};exports[_0x3b90('0x46')]=function(_0x330002,_0x27d0a8){return db[_0x3b90('0x27')]['create'](_0x330002['body'],{})[_0x3b90('0x1c')](function(_0x6bc94a){var _0x9e2ee5=_0x330002['user'][_0x3b90('0x1e')]({'plain':!![]});if(!_0x9e2ee5)throw new Error(_0x3b90('0x47'));if(_0x9e2ee5[_0x3b90('0x48')]===_0x3b90('0x49')){var _0x41e951=_0x6bc94a[_0x3b90('0x1e')]({'plain':!![]});var _0x44b01b=_0x3b90('0x1f');return db[_0x3b90('0x4a')]['find']({'where':{'name':_0x44b01b,'userProfileId':_0x9e2ee5[_0x3b90('0x4b')]},'raw':!![]})[_0x3b90('0x1c')](function(_0x2b5b6f){if(_0x2b5b6f&&_0x2b5b6f['autoAssociation']===0x0){return db[_0x3b90('0x20')]['create']({'name':_0x41e951[_0x3b90('0x24')],'resourceId':_0x41e951['id'],'type':_0x2b5b6f[_0x3b90('0x24')],'sectionId':_0x2b5b6f['id']},{})[_0x3b90('0x1c')](function(){return _0x6bc94a;});}else{return _0x6bc94a;}})['catch'](function(_0x2a3fe8){logger[_0x3b90('0x22')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x2a3fe8);throw _0x2a3fe8;});}return _0x6bc94a;})['then'](respondWithResult(_0x27d0a8,0xc9))[_0x3b90('0x40')](handleError(_0x27d0a8,null));};exports[_0x3b90('0x4c')]=function(_0x1eb16e,_0x3f46cf){var _0x50462d={'where':{'id':_0x1eb16e[_0x3b90('0x42')]['id']}},_0x5ee7e2={};_0x5ee7e2[_0x3b90('0x2a')]=_[_0x3b90('0x43')](db[_0x3b90('0x27')][_0x3b90('0x28')]);_0x50462d[_0x3b90('0x2f')]=_[_0x3b90('0x2d')](_0x5ee7e2[_0x3b90('0x2a')],qs[_0x3b90('0x2e')](_0x1eb16e['query'][_0x3b90('0x2e')]));_0x50462d[_0x3b90('0x2f')]=_0x50462d['attributes'][_0x3b90('0x44')]?_0x50462d[_0x3b90('0x2f')]:_0x5ee7e2['model'];if(_0x1eb16e[_0x3b90('0x2b')][_0x3b90('0x3c')]){_0x50462d[_0x3b90('0x3d')]=[{'all':!![]}];}_0x50462d=_[_0x3b90('0x45')]({},_0x50462d,_0x1eb16e[_0x3b90('0x3a')]);return db[_0x3b90('0x27')][_0x3b90('0x4d')](_0x50462d)['then'](handleEntityNotFound(_0x3f46cf,null))[_0x3b90('0x1c')](function(_0x3f5e1d){if(_0x3f5e1d){var _0x32a179=_0x3f5e1d[_0x3b90('0x1e')]({'plain':!![]});_0x32a179=qs[_0x3b90('0x4e')](_0x32a179,['id',_0x3b90('0x4f'),_0x3b90('0x50')]);_0x1eb16e[_0x3b90('0x51')]=_[_0x3b90('0x4e')](_0x1eb16e[_0x3b90('0x51')],['id',_0x3b90('0x4f'),_0x3b90('0x50')]);return db[_0x3b90('0x27')][_0x3b90('0x46')](_[_0x3b90('0x45')](_0x32a179,_0x1eb16e['body']),{'include':_0x1eb16e[_0x3b90('0x2b')]['includeAll']?[{'all':!![]}]:undefined})[_0x3b90('0x1c')](function(_0x290550){var _0x25bdb2=_0x1eb16e[_0x3b90('0x49')][_0x3b90('0x1e')]({'plain':!![]});if(!_0x25bdb2)throw new Error(_0x3b90('0x47'));if(_0x25bdb2['role']===_0x3b90('0x49')){var _0x3ecb23=_0x290550[_0x3b90('0x1e')]({'plain':!![]});var _0x8e1229=_0x3b90('0x1f');return db[_0x3b90('0x4a')]['find']({'where':{'name':_0x8e1229,'userProfileId':_0x25bdb2[_0x3b90('0x4b')]},'raw':!![]})[_0x3b90('0x1c')](function(_0xb41920){if(_0xb41920&&_0xb41920['autoAssociation']===0x0){return db[_0x3b90('0x20')][_0x3b90('0x46')]({'name':_0x3ecb23[_0x3b90('0x24')],'resourceId':_0x3ecb23['id'],'type':_0xb41920[_0x3b90('0x24')],'sectionId':_0xb41920['id']},{})[_0x3b90('0x1c')](function(){return _0x290550;});}else{return _0x290550;}})[_0x3b90('0x40')](function(_0xbd986c){logger[_0x3b90('0x22')](_0x3b90('0x52'),_0xbd986c);throw _0xbd986c;});}return _0x290550;});}})['then'](respondWithResult(_0x3f46cf,0xc9))[_0x3b90('0x40')](handleError(_0x3f46cf,null));};exports['update']=function(_0x53d2d3,_0x3c29e0){if(_0x53d2d3[_0x3b90('0x51')]['id']){delete _0x53d2d3['body']['id'];}return db[_0x3b90('0x27')][_0x3b90('0x4d')]({'where':{'id':_0x53d2d3[_0x3b90('0x42')]['id']}})[_0x3b90('0x1c')](handleEntityNotFound(_0x3c29e0,null))[_0x3b90('0x1c')](saveUpdates(_0x53d2d3[_0x3b90('0x51')],null))[_0x3b90('0x1c')](respondWithResult(_0x3c29e0,null))['catch'](handleError(_0x3c29e0,null));};exports['destroy']=function(_0x3e5532,_0x5e5efa){return db[_0x3b90('0x27')]['find']({'where':{'id':_0x3e5532[_0x3b90('0x42')]['id']}})['then'](handleEntityNotFound(_0x5e5efa,null))['then'](removeEntity(_0x5e5efa,null))['catch'](handleError(_0x5e5efa,null));};exports[_0x3b90('0x53')]=function(_0x470fe3,_0x33fca6,_0x2d8a4b){var _0x1a0c78={'raw':!![],'where':{}};var _0x11c469={};var _0x323d49={'count':0x0,'rows':[]};return db['Campaign']['findOne']({'where':{'id':_0x470fe3['params']['id']}})[_0x3b90('0x1c')](handleEntityNotFound(_0x33fca6,null))[_0x3b90('0x1c')](function(_0x57d3df){if(_0x57d3df){_0x11c469[_0x3b90('0x2a')]=_[_0x3b90('0x43')](db[_0x3b90('0x54')][_0x3b90('0x28')]);_0x11c469[_0x3b90('0x2b')]=_[_0x3b90('0x43')](_0x470fe3[_0x3b90('0x2b')]);_0x11c469[_0x3b90('0x2c')]=_[_0x3b90('0x2d')](_0x11c469['model'],_0x11c469[_0x3b90('0x2b')]);_0x1a0c78['attributes']=_[_0x3b90('0x2d')](_0x11c469[_0x3b90('0x2a')],qs['fields'](_0x470fe3['query'][_0x3b90('0x2e')]));_0x1a0c78[_0x3b90('0x2f')]=_0x1a0c78[_0x3b90('0x2f')][_0x3b90('0x44')]?_0x1a0c78[_0x3b90('0x2f')]:_0x11c469[_0x3b90('0x2a')];if(!_0x470fe3['query'][_0x3b90('0x30')](_0x3b90('0x31'))){_0x1a0c78[_0x3b90('0x32')]=qs['limit'](_0x470fe3[_0x3b90('0x2b')]['limit']);_0x1a0c78[_0x3b90('0x16')]=qs[_0x3b90('0x16')](_0x470fe3[_0x3b90('0x2b')][_0x3b90('0x16')]);}_0x1a0c78[_0x3b90('0x33')]=qs[_0x3b90('0x34')](_0x470fe3['query'][_0x3b90('0x34')]);_0x1a0c78[_0x3b90('0x37')]=qs[_0x3b90('0x2c')](_[_0x3b90('0x35')](_0x470fe3[_0x3b90('0x2b')],_0x11c469[_0x3b90('0x2c')]));_0x1a0c78[_0x3b90('0x37')][_0x3b90('0x55')]=_0x57d3df['id'];if(_0x470fe3['query'][_0x3b90('0x36')]){_0x1a0c78[_0x3b90('0x37')]=_[_0x3b90('0x45')](_0x1a0c78[_0x3b90('0x37')],{'$or':_[_0x3b90('0x26')](_0x1a0c78[_0x3b90('0x2f')],function(_0x1af213){var _0x3e3f81={};_0x3e3f81[_0x1af213]={'$like':'%'+_0x470fe3['query']['filter']+'%'};return _0x3e3f81;})});}_0x1a0c78=_[_0x3b90('0x45')]({},_0x1a0c78,_0x470fe3[_0x3b90('0x3a')]);return db[_0x3b90('0x54')]['count']({'where':_0x1a0c78[_0x3b90('0x37')]})['then'](function(_0x4b70cb){_0x323d49[_0x3b90('0x3b')]=_0x4b70cb;if(_0x470fe3[_0x3b90('0x2b')][_0x3b90('0x3c')]){_0x1a0c78[_0x3b90('0x3d')]=[{'all':!![]}];}return db[_0x3b90('0x54')][_0x3b90('0x3e')](_0x1a0c78);})[_0x3b90('0x1c')](function(_0x37f7bc){_0x323d49[_0x3b90('0x3f')]=_0x37f7bc;return _0x323d49;});}})[_0x3b90('0x1c')](respondWithFilteredResult(_0x33fca6,_0x1a0c78))[_0x3b90('0x40')](handleError(_0x33fca6,null));};exports[_0x3b90('0x56')]=function(_0x2e621a,_0x241d6e,_0x122525){var _0x4e8614={'raw':!![],'where':{}};var _0x212aa4={};var _0x98d7b0={'count':0x0,'rows':[]};return db['Campaign'][_0x3b90('0x57')]({'where':{'id':_0x2e621a['params']['id']}})[_0x3b90('0x1c')](handleEntityNotFound(_0x241d6e,null))[_0x3b90('0x1c')](function(_0x323738){if(_0x323738){_0x212aa4['model']=_[_0x3b90('0x43')](db[_0x3b90('0x58')][_0x3b90('0x28')]);_0x212aa4[_0x3b90('0x2b')]=_[_0x3b90('0x43')](_0x2e621a[_0x3b90('0x2b')]);_0x212aa4[_0x3b90('0x2c')]=_[_0x3b90('0x2d')](_0x212aa4[_0x3b90('0x2a')],_0x212aa4[_0x3b90('0x2b')]);_0x4e8614[_0x3b90('0x2f')]=_[_0x3b90('0x2d')](_0x212aa4['model'],qs['fields'](_0x2e621a['query'][_0x3b90('0x2e')]));_0x4e8614[_0x3b90('0x2f')]=_0x4e8614[_0x3b90('0x2f')][_0x3b90('0x44')]?_0x4e8614[_0x3b90('0x2f')]:_0x212aa4[_0x3b90('0x2a')];if(!_0x2e621a[_0x3b90('0x2b')][_0x3b90('0x30')](_0x3b90('0x31'))){_0x4e8614[_0x3b90('0x32')]=qs[_0x3b90('0x32')](_0x2e621a['query']['limit']);_0x4e8614[_0x3b90('0x16')]=qs[_0x3b90('0x16')](_0x2e621a[_0x3b90('0x2b')][_0x3b90('0x16')]);}_0x4e8614[_0x3b90('0x33')]=qs[_0x3b90('0x34')](_0x2e621a[_0x3b90('0x2b')][_0x3b90('0x34')]);_0x4e8614[_0x3b90('0x37')]=qs[_0x3b90('0x2c')](_[_0x3b90('0x35')](_0x2e621a[_0x3b90('0x2b')],_0x212aa4[_0x3b90('0x2c')]));_0x4e8614[_0x3b90('0x37')][_0x3b90('0x55')]=_0x323738['id'];if(_0x2e621a[_0x3b90('0x2b')][_0x3b90('0x36')]){_0x4e8614[_0x3b90('0x37')]=_['merge'](_0x4e8614[_0x3b90('0x37')],{'$or':_[_0x3b90('0x26')](_0x4e8614[_0x3b90('0x2f')],function(_0x34fdf0){var _0x22d7cb={};_0x22d7cb[_0x34fdf0]={'$like':'%'+_0x2e621a['query'][_0x3b90('0x36')]+'%'};return _0x22d7cb;})});}_0x4e8614=_[_0x3b90('0x45')]({},_0x4e8614,_0x2e621a[_0x3b90('0x3a')]);return db[_0x3b90('0x58')][_0x3b90('0x3b')]({'where':_0x4e8614[_0x3b90('0x37')]})['then'](function(_0x18273c){_0x98d7b0['count']=_0x18273c;if(_0x2e621a['query'][_0x3b90('0x3c')]){_0x4e8614[_0x3b90('0x3d')]=[{'all':!![]}];}return db[_0x3b90('0x58')][_0x3b90('0x3e')](_0x4e8614);})[_0x3b90('0x1c')](function(_0x5de15a){_0x98d7b0[_0x3b90('0x3f')]=_0x5de15a;return _0x98d7b0;});}})[_0x3b90('0x1c')](respondWithFilteredResult(_0x241d6e,_0x4e8614))[_0x3b90('0x40')](handleError(_0x241d6e,null));};exports[_0x3b90('0x59')]=function(_0x21f529,_0x1f6140,_0x19b070){var _0x1e9291={'raw':!![],'where':{}};var _0x2c2e24={};var _0x45be4c={'count':0x0,'rows':[]};return db[_0x3b90('0x27')][_0x3b90('0x57')]({'where':{'id':_0x21f529[_0x3b90('0x42')]['id']}})[_0x3b90('0x1c')](handleEntityNotFound(_0x1f6140,null))[_0x3b90('0x1c')](function(_0x1af0ea){if(_0x1af0ea){_0x2c2e24['model']=_[_0x3b90('0x43')](db[_0x3b90('0x5a')][_0x3b90('0x28')]);_0x2c2e24[_0x3b90('0x2b')]=_[_0x3b90('0x43')](_0x21f529[_0x3b90('0x2b')]);_0x2c2e24['filters']=_[_0x3b90('0x2d')](_0x2c2e24[_0x3b90('0x2a')],_0x2c2e24[_0x3b90('0x2b')]);_0x1e9291[_0x3b90('0x2f')]=_[_0x3b90('0x2d')](_0x2c2e24['model'],qs[_0x3b90('0x2e')](_0x21f529[_0x3b90('0x2b')][_0x3b90('0x2e')]));_0x1e9291[_0x3b90('0x2f')]=_0x1e9291['attributes']['length']?_0x1e9291[_0x3b90('0x2f')]:_0x2c2e24['model'];if(!_0x21f529[_0x3b90('0x2b')][_0x3b90('0x30')](_0x3b90('0x31'))){_0x1e9291[_0x3b90('0x32')]=qs[_0x3b90('0x32')](_0x21f529['query'][_0x3b90('0x32')]);_0x1e9291['offset']=qs[_0x3b90('0x16')](_0x21f529[_0x3b90('0x2b')][_0x3b90('0x16')]);}_0x1e9291['order']=qs[_0x3b90('0x34')](_0x21f529[_0x3b90('0x2b')][_0x3b90('0x34')]);_0x1e9291['where']=qs[_0x3b90('0x2c')](_[_0x3b90('0x35')](_0x21f529[_0x3b90('0x2b')],_0x2c2e24['filters']));_0x1e9291[_0x3b90('0x37')][_0x3b90('0x55')]=_0x1af0ea['id'];if(_0x21f529[_0x3b90('0x2b')][_0x3b90('0x36')]){_0x1e9291[_0x3b90('0x37')]=_[_0x3b90('0x45')](_0x1e9291['where'],{'$or':_['map'](_0x1e9291['attributes'],function(_0x2ad6bc){var _0x4ca435={};_0x4ca435[_0x2ad6bc]={'$like':'%'+_0x21f529[_0x3b90('0x2b')][_0x3b90('0x36')]+'%'};return _0x4ca435;})});}_0x1e9291=_[_0x3b90('0x45')]({},_0x1e9291,_0x21f529[_0x3b90('0x3a')]);return db[_0x3b90('0x5a')]['count']({'where':_0x1e9291[_0x3b90('0x37')]})['then'](function(_0x74241a){_0x45be4c[_0x3b90('0x3b')]=_0x74241a;if(_0x21f529[_0x3b90('0x2b')]['includeAll']){_0x1e9291[_0x3b90('0x3d')]=[{'all':!![]}];}return db[_0x3b90('0x5a')][_0x3b90('0x3e')](_0x1e9291);})[_0x3b90('0x1c')](function(_0x1be56f){_0x45be4c[_0x3b90('0x3f')]=_0x1be56f;return _0x45be4c;});}})[_0x3b90('0x1c')](respondWithFilteredResult(_0x1f6140,_0x1e9291))[_0x3b90('0x40')](handleError(_0x1f6140,null));};exports['getHopperBlacks']=function(_0x38852a,_0x52c38a,_0x152170){var _0x171ac6={'raw':!![],'where':{}};var _0x337da6={};var _0x20c907={'count':0x0,'rows':[]};return db[_0x3b90('0x27')][_0x3b90('0x57')]({'where':{'id':_0x38852a[_0x3b90('0x42')]['id']}})['then'](handleEntityNotFound(_0x52c38a,null))['then'](function(_0x435eb8){if(_0x435eb8){_0x337da6[_0x3b90('0x2a')]=_[_0x3b90('0x43')](db[_0x3b90('0x5b')]['rawAttributes']);_0x337da6['query']=_[_0x3b90('0x43')](_0x38852a[_0x3b90('0x2b')]);_0x337da6['filters']=_[_0x3b90('0x2d')](_0x337da6[_0x3b90('0x2a')],_0x337da6[_0x3b90('0x2b')]);_0x171ac6[_0x3b90('0x2f')]=_[_0x3b90('0x2d')](_0x337da6[_0x3b90('0x2a')],qs['fields'](_0x38852a[_0x3b90('0x2b')][_0x3b90('0x2e')]));_0x171ac6[_0x3b90('0x2f')]=_0x171ac6[_0x3b90('0x2f')][_0x3b90('0x44')]?_0x171ac6[_0x3b90('0x2f')]:_0x337da6[_0x3b90('0x2a')];if(!_0x38852a[_0x3b90('0x2b')][_0x3b90('0x30')](_0x3b90('0x31'))){_0x171ac6[_0x3b90('0x32')]=qs['limit'](_0x38852a['query']['limit']);_0x171ac6['offset']=qs[_0x3b90('0x16')](_0x38852a[_0x3b90('0x2b')][_0x3b90('0x16')]);}_0x171ac6[_0x3b90('0x33')]=qs[_0x3b90('0x34')](_0x38852a[_0x3b90('0x2b')][_0x3b90('0x34')]);_0x171ac6[_0x3b90('0x37')]=qs[_0x3b90('0x2c')](_['pick'](_0x38852a[_0x3b90('0x2b')],_0x337da6['filters']));_0x171ac6['where'][_0x3b90('0x55')]=_0x435eb8['id'];if(_0x38852a[_0x3b90('0x2b')][_0x3b90('0x36')]){_0x171ac6[_0x3b90('0x37')]=_[_0x3b90('0x45')](_0x171ac6['where'],{'$or':_[_0x3b90('0x26')](_0x171ac6['attributes'],function(_0x2fc084){var _0x1a32b2={};_0x1a32b2[_0x2fc084]={'$like':'%'+_0x38852a[_0x3b90('0x2b')][_0x3b90('0x36')]+'%'};return _0x1a32b2;})});}_0x171ac6=_[_0x3b90('0x45')]({},_0x171ac6,_0x38852a[_0x3b90('0x3a')]);return db[_0x3b90('0x5b')][_0x3b90('0x3b')]({'where':_0x171ac6[_0x3b90('0x37')]})[_0x3b90('0x1c')](function(_0x504297){_0x20c907[_0x3b90('0x3b')]=_0x504297;if(_0x38852a[_0x3b90('0x2b')][_0x3b90('0x3c')]){_0x171ac6[_0x3b90('0x3d')]=[{'all':!![]}];}return db[_0x3b90('0x5b')][_0x3b90('0x3e')](_0x171ac6);})[_0x3b90('0x1c')](function(_0x22ecb9){_0x20c907[_0x3b90('0x3f')]=_0x22ecb9;return _0x20c907;});}})[_0x3b90('0x1c')](respondWithFilteredResult(_0x52c38a,_0x171ac6))[_0x3b90('0x40')](handleError(_0x52c38a,null));};exports['getLists']=function(_0x247492,_0x3f0a11,_0x501f79){var _0x3c042e={};var _0x18bcad={};var _0x82efc8;var _0xdeeffd;return db['Campaign'][_0x3b90('0x57')]({'where':{'id':_0x247492['params']['id']}})['then'](handleEntityNotFound(_0x3f0a11,null))['then'](function(_0x4eeedb){if(_0x4eeedb){_0x82efc8=_0x4eeedb;_0x18bcad[_0x3b90('0x2a')]=_[_0x3b90('0x43')](db[_0x3b90('0x5c')][_0x3b90('0x28')]);_0x18bcad[_0x3b90('0x2b')]=_[_0x3b90('0x43')](_0x247492[_0x3b90('0x2b')]);_0x18bcad[_0x3b90('0x2c')]=_['intersection'](_0x18bcad[_0x3b90('0x2a')],_0x18bcad[_0x3b90('0x2b')]);_0x3c042e['attributes']=_[_0x3b90('0x2d')](_0x18bcad[_0x3b90('0x2a')],qs['fields'](_0x247492[_0x3b90('0x2b')]['fields']));_0x3c042e[_0x3b90('0x2f')]=_0x3c042e['attributes'][_0x3b90('0x44')]?_0x3c042e[_0x3b90('0x2f')]:_0x18bcad['model'];_0x3c042e['order']=qs[_0x3b90('0x34')](_0x247492[_0x3b90('0x2b')][_0x3b90('0x34')]);_0x3c042e['where']=qs[_0x3b90('0x2c')](_['pick'](_0x247492[_0x3b90('0x2b')],_0x18bcad['filters']));if(_0x247492[_0x3b90('0x2b')][_0x3b90('0x36')]){_0x3c042e[_0x3b90('0x37')]=_[_0x3b90('0x45')](_0x3c042e[_0x3b90('0x37')],{'$or':_[_0x3b90('0x26')](_0x3c042e['attributes'],function(_0x424702){var _0x3863ef={};_0x3863ef[_0x424702]={'$like':'%'+_0x247492['query'][_0x3b90('0x36')]+'%'};return _0x3863ef;})});}_0x3c042e=_[_0x3b90('0x45')]({},_0x3c042e,_0x247492[_0x3b90('0x3a')]);return _0x82efc8[_0x3b90('0x5d')](_0x3c042e);}})['then'](function(_0x509694){if(_0x509694){_0xdeeffd=_0x509694[_0x3b90('0x44')];if(!_0x247492[_0x3b90('0x2b')]['hasOwnProperty']('nolimit')){_0x3c042e[_0x3b90('0x32')]=qs[_0x3b90('0x32')](_0x247492[_0x3b90('0x2b')]['limit']);_0x3c042e[_0x3b90('0x16')]=qs[_0x3b90('0x16')](_0x247492[_0x3b90('0x2b')][_0x3b90('0x16')]);}return _0x82efc8[_0x3b90('0x5d')](_0x3c042e);}})[_0x3b90('0x1c')](function(_0x305ace){if(_0x305ace){return _0x305ace?{'count':_0xdeeffd,'rows':_0x305ace}:null;}})['then'](respondWithResult(_0x3f0a11,null))[_0x3b90('0x40')](handleError(_0x3f0a11,null));};exports[_0x3b90('0x5e')]=function(_0xd84ba2,_0x364f0e,_0x450a46){var _0x264c54,_0x47e27f;return db['Campaign'][_0x3b90('0x4d')]({'where':{'id':_0xd84ba2[_0x3b90('0x42')]['id']}})[_0x3b90('0x1c')](handleEntityNotFound(_0x364f0e,null))[_0x3b90('0x1c')](function(_0x1f643c){if(_0x1f643c){_0x47e27f=_0x1f643c;return _0x1f643c['addLists'](_0xd84ba2[_0x3b90('0x51')][_0x3b90('0x5f')],_['omit'](_0xd84ba2[_0x3b90('0x51')],[_0x3b90('0x5f'),'id'])||{});}return null;})['spread'](function(_0x1a6ea5){var _0xbc60a4;_0x264c54=_0x1a6ea5||[];var _0x5b400c=[];if(_0x1a6ea5){for(var _0x5c6444=0x0;_0x5c6444<_0x1a6ea5['length'];_0x5c6444+=0x1){var _0x5a4736=_0x1a6ea5[_0x5c6444][_0x3b90('0x1e')]({'plain':!![]});_0x47e27f[_0x3b90('0x60')]=_0xd84ba2[_0x3b90('0x51')]['dialCheckDuplicateType']?_0xd84ba2[_0x3b90('0x51')][_0x3b90('0x60')]:_0x47e27f[_0x3b90('0x60')];switch(_0x47e27f[_0x3b90('0x60')]){case _0x3b90('0x61'):_0xbc60a4=squel[_0x3b90('0x62')]()['into'](_0x3b90('0x63'))['fromQuery']([_0x3b90('0x64'),_0x3b90('0x65'),'ContactId','ListId',_0x3b90('0x55'),_0x3b90('0x4f'),_0x3b90('0x50')],squel[_0x3b90('0x66')]()[_0x3b90('0x67')](_0x3b90('0x64'),_0x3b90('0x64'))[_0x3b90('0x67')](_0x3b90('0x68'),_0x3b90('0x65'))[_0x3b90('0x67')]('id',_0x3b90('0x69'))['field'](_0x5a4736[_0x3b90('0x6a')][_0x3b90('0x6b')](),_0x3b90('0x6c'))[_0x3b90('0x67')](_0xd84ba2[_0x3b90('0x42')]['id'][_0x3b90('0x6b')](),'CampaignId')[_0x3b90('0x67')](_0x3b90('0x68'),_0x3b90('0x4f'))['field'](_0x3b90('0x68'),_0x3b90('0x50'))['from'](_0x3b90('0x6d'))[_0x3b90('0x37')](_0x3b90('0x6e'))[_0x3b90('0x37')]('ListId\x20=\x20?',_0x5a4736[_0x3b90('0x6a')][_0x3b90('0x6b')]())[_0x3b90('0x37')](_0x3b90('0x6f'))['where'](_0x3b90('0x70'),squel[_0x3b90('0x66')]()[_0x3b90('0x67')](_0x3b90('0x71'))[_0x3b90('0x72')](_0x3b90('0x73'))[_0x3b90('0x37')](_0x3b90('0x74'),_0xd84ba2[_0x3b90('0x42')]['id'][_0x3b90('0x6b')]()))[_0x3b90('0x37')](_0x3b90('0x70'),squel[_0x3b90('0x66')]()[_0x3b90('0x67')](_0x3b90('0x75'))[_0x3b90('0x72')](_0x3b90('0x63'))['where'](_0x3b90('0x74'),_0xd84ba2['params']['id'][_0x3b90('0x6b')]())))[_0x3b90('0x6b')]();break;case _0x3b90('0x76'):_0xbc60a4=squel[_0x3b90('0x62')]()[_0x3b90('0x77')](_0x3b90('0x63'))[_0x3b90('0x78')]([_0x3b90('0x64'),_0x3b90('0x65'),_0x3b90('0x69'),_0x3b90('0x6c'),_0x3b90('0x55'),'createdAt','updatedAt'],squel[_0x3b90('0x66')]()['field'](_0x3b90('0x64'),_0x3b90('0x64'))[_0x3b90('0x67')](_0x3b90('0x68'),_0x3b90('0x65'))[_0x3b90('0x67')]('id','ContactId')[_0x3b90('0x67')](_0x5a4736[_0x3b90('0x6a')][_0x3b90('0x6b')](),_0x3b90('0x6c'))[_0x3b90('0x67')](_0xd84ba2[_0x3b90('0x42')]['id'][_0x3b90('0x6b')](),'CampaignId')['field'](_0x3b90('0x68'),_0x3b90('0x4f'))[_0x3b90('0x67')]('NOW()',_0x3b90('0x50'))[_0x3b90('0x72')](_0x3b90('0x6d'))[_0x3b90('0x37')](_0x3b90('0x6e'))[_0x3b90('0x37')](_0x3b90('0x79'),_0x5a4736['CmListId']['toString']())[_0x3b90('0x37')](_0x3b90('0x6f'))[_0x3b90('0x37')](_0x3b90('0x70'),squel[_0x3b90('0x66')]()[_0x3b90('0x67')](_0x3b90('0x75'))['from'](_0x3b90('0x63'))['where'](_0x3b90('0x74'),_0xd84ba2[_0x3b90('0x42')]['id'][_0x3b90('0x6b')]())))['toString']();break;default:_0xbc60a4=squel[_0x3b90('0x62')]()['into'](_0x3b90('0x63'))[_0x3b90('0x78')]([_0x3b90('0x64'),_0x3b90('0x65'),'ContactId',_0x3b90('0x6c'),_0x3b90('0x55'),_0x3b90('0x4f'),'updatedAt'],squel[_0x3b90('0x66')]()[_0x3b90('0x67')](_0x3b90('0x64'),_0x3b90('0x64'))[_0x3b90('0x67')](_0x3b90('0x68'),_0x3b90('0x65'))['field']('id','ContactId')[_0x3b90('0x67')](_0x5a4736[_0x3b90('0x6a')][_0x3b90('0x6b')](),'ListId')[_0x3b90('0x67')](_0xd84ba2[_0x3b90('0x42')]['id'][_0x3b90('0x6b')](),'CampaignId')[_0x3b90('0x67')](_0x3b90('0x68'),'createdAt')[_0x3b90('0x67')](_0x3b90('0x68'),_0x3b90('0x50'))[_0x3b90('0x72')](_0x3b90('0x6d'))[_0x3b90('0x37')]('deletedAt\x20IS\x20NULL')[_0x3b90('0x37')]('ListId\x20=\x20?',_0x5a4736[_0x3b90('0x6a')][_0x3b90('0x6b')]())['where'](_0x3b90('0x6f')))['toString']();}_0x5b400c[_0x3b90('0x7a')](db[_0x3b90('0x7b')][_0x3b90('0x2b')](_0xbc60a4));}return BPromise[_0x3b90('0x7c')](_0x5b400c);}})[_0x3b90('0x1c')](function(){return _0x264c54;})['then'](respondWithResult(_0x364f0e,null))[_0x3b90('0x40')](handleError(_0x364f0e,null));};exports['removeLists']=function(_0x10f4f3,_0x52765c,_0x432b63){return db[_0x3b90('0x27')][_0x3b90('0x4d')]({'where':{'id':_0x10f4f3[_0x3b90('0x42')]['id']}})[_0x3b90('0x1c')](handleEntityNotFound(_0x52765c,null))['then'](function(_0x479af8){if(_0x479af8){return _0x479af8[_0x3b90('0x7d')](_0x10f4f3['query'][_0x3b90('0x5f')]);}})[_0x3b90('0x1c')](function(_0xebae36){if(_0xebae36){return db[_0x3b90('0x54')][_0x3b90('0x1d')]({'where':{'ListId':_0x10f4f3[_0x3b90('0x2b')][_0x3b90('0x5f')],'CampaignId':_0x10f4f3[_0x3b90('0x42')]['id']}})[_0x3b90('0x1c')](function(){return _0xebae36;});}})[_0x3b90('0x1c')](respondWithStatusCode(_0x52765c,null))[_0x3b90('0x40')](handleError(_0x52765c,null));};exports[_0x3b90('0x7e')]=function(_0x2856f7,_0x679fd0,_0x5b5099){var _0x121183={'raw':!![],'where':{}};var _0x1259b9={};var _0x266fc3={'count':0x0,'rows':[]};return db[_0x3b90('0x27')][_0x3b90('0x57')]({'where':{'id':_0x2856f7['params']['id']}})[_0x3b90('0x1c')](handleEntityNotFound(_0x679fd0,null))['then'](function(_0x307477){if(_0x307477){_0x1259b9['model']=_[_0x3b90('0x43')](db[_0x3b90('0x5c')][_0x3b90('0x28')]);_0x1259b9[_0x3b90('0x2b')]=_[_0x3b90('0x43')](_0x2856f7[_0x3b90('0x2b')]);_0x1259b9[_0x3b90('0x2c')]=_[_0x3b90('0x2d')](_0x1259b9[_0x3b90('0x2a')],_0x1259b9[_0x3b90('0x2b')]);_0x121183[_0x3b90('0x2f')]=_[_0x3b90('0x2d')](_0x1259b9['model'],qs[_0x3b90('0x2e')](_0x2856f7[_0x3b90('0x2b')][_0x3b90('0x2e')]));_0x121183[_0x3b90('0x2f')]=_0x121183[_0x3b90('0x2f')][_0x3b90('0x44')]?_0x121183['attributes']:_0x1259b9[_0x3b90('0x2a')];if(!_0x2856f7[_0x3b90('0x2b')][_0x3b90('0x30')](_0x3b90('0x31'))){_0x121183[_0x3b90('0x32')]=qs['limit'](_0x2856f7[_0x3b90('0x2b')][_0x3b90('0x32')]);_0x121183[_0x3b90('0x16')]=qs['offset'](_0x2856f7['query']['offset']);}_0x121183['order']=qs[_0x3b90('0x34')](_0x2856f7[_0x3b90('0x2b')][_0x3b90('0x34')]);_0x121183[_0x3b90('0x37')]=qs[_0x3b90('0x2c')](_[_0x3b90('0x35')](_0x2856f7['query'],_0x1259b9[_0x3b90('0x2c')]));_0x121183[_0x3b90('0x37')][_0x3b90('0x55')]=_0x307477['id'];if(_0x2856f7[_0x3b90('0x2b')][_0x3b90('0x36')]){_0x121183['where']=_['merge'](_0x121183[_0x3b90('0x37')],{'$or':_['map'](_0x121183['attributes'],function(_0x758536){var _0x1cc739={};_0x1cc739[_0x758536]={'$like':'%'+_0x2856f7['query']['filter']+'%'};return _0x1cc739;})});}_0x121183=_[_0x3b90('0x45')]({},_0x121183,_0x2856f7[_0x3b90('0x3a')]);return db[_0x3b90('0x5c')]['count']({'where':_0x121183[_0x3b90('0x37')]})['then'](function(_0x1b2ea8){_0x266fc3[_0x3b90('0x3b')]=_0x1b2ea8;if(_0x2856f7[_0x3b90('0x2b')][_0x3b90('0x3c')]){_0x121183[_0x3b90('0x3d')]=[{'all':!![]}];}return db[_0x3b90('0x5c')][_0x3b90('0x3e')](_0x121183);})['then'](function(_0x411fcf){_0x266fc3[_0x3b90('0x3f')]=_0x411fcf;return _0x266fc3;});}})[_0x3b90('0x1c')](respondWithFilteredResult(_0x679fd0,_0x121183))[_0x3b90('0x40')](handleError(_0x679fd0,null));};exports[_0x3b90('0x7f')]=function(_0xd2ada3,_0x5b4a11,_0x3ff8ec){var _0xa5487d,_0x3b208e;return db[_0x3b90('0x27')][_0x3b90('0x4d')]({'where':{'id':_0xd2ada3[_0x3b90('0x42')]['id']}})['then'](handleEntityNotFound(_0x5b4a11,null))['then'](function(_0x15050b){if(_0x15050b){_0x3b208e=_0x15050b;return _0x15050b[_0x3b90('0x7f')](_0xd2ada3[_0x3b90('0x51')][_0x3b90('0x5f')],_[_0x3b90('0x4e')](_0xd2ada3['body'],['ids','id'])||{});}return null;})[_0x3b90('0x80')](function(_0x423ad3){var _0x4b9466;_0xa5487d=_0x423ad3||[];var _0x1dc5db=[];if(_0x423ad3){for(var _0x3dc7b9=0x0;_0x3dc7b9<_0x423ad3[_0x3b90('0x44')];_0x3dc7b9+=0x1){var _0x381300=_0x423ad3[_0x3dc7b9]['get']({'plain':!![]});_0x4b9466=squel['insert']()['into'](_0x3b90('0x81'))[_0x3b90('0x78')]([_0x3b90('0x64'),_0x3b90('0x69'),_0x3b90('0x6c'),_0x3b90('0x55'),'createdAt',_0x3b90('0x50')],squel[_0x3b90('0x66')]()[_0x3b90('0x67')](_0x3b90('0x64'),_0x3b90('0x64'))[_0x3b90('0x67')]('id',_0x3b90('0x69'))[_0x3b90('0x67')](_0x381300[_0x3b90('0x6a')][_0x3b90('0x6b')](),'ListId')[_0x3b90('0x67')](_0xd2ada3[_0x3b90('0x42')]['id'][_0x3b90('0x6b')](),'CampaignId')['field'](_0x3b90('0x68'),_0x3b90('0x4f'))[_0x3b90('0x67')](_0x3b90('0x68'),_0x3b90('0x50'))['from'](_0x3b90('0x6d'))[_0x3b90('0x37')](_0x3b90('0x6e'))[_0x3b90('0x37')](_0x3b90('0x79'),_0x381300[_0x3b90('0x6a')][_0x3b90('0x6b')]())['where'](_0x3b90('0x6f')))['toString']();_0x1dc5db[_0x3b90('0x7a')](db['sequelize'][_0x3b90('0x2b')](_0x4b9466));}return BPromise[_0x3b90('0x7c')](_0x1dc5db);}})[_0x3b90('0x1c')](function(){return _0xa5487d;})[_0x3b90('0x1c')](respondWithResult(_0x5b4a11,null))[_0x3b90('0x40')](handleError(_0x5b4a11,null));};exports['removeBlackLists']=function(_0x70136,_0x276679,_0x55550f){return db[_0x3b90('0x27')][_0x3b90('0x4d')]({'where':{'id':_0x70136['params']['id']}})[_0x3b90('0x1c')](handleEntityNotFound(_0x276679,null))[_0x3b90('0x1c')](function(_0x44710c){if(_0x44710c){return _0x44710c[_0x3b90('0x82')](_0x70136[_0x3b90('0x2b')][_0x3b90('0x5f')]);}})['then'](function(_0x102592){if(_0x102592){return db[_0x3b90('0x5b')][_0x3b90('0x1d')]({'where':{'ListId':_0x70136[_0x3b90('0x2b')][_0x3b90('0x5f')],'CampaignId':_0x70136[_0x3b90('0x42')]['id']}})[_0x3b90('0x1c')](function(){return _0x102592;});}})[_0x3b90('0x1c')](respondWithStatusCode(_0x276679,null))['catch'](handleError(_0x276679,null));};
\ No newline at end of file
+var _0x9f62=['fieldName','type','query','keys','filters','attributes','intersection','model','fields','length','hasOwnProperty','limit','order','sort','where','pick','filter','options','include','findAll','show','params','includeAll','find','catch','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','clone','omit','updatedAt','merge','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','update','findOne','CmHopper','nolimit','CampaignId','rows','CmHopperHistory','getHopperFinals','CmHopperFinal','getHopperBlacks','CmHopperBlack','CmList','getLists','addLists','spread','dialCheckDuplicateType','always','into','cm_hopper','fromQuery','phone','scheduledAt','createdAt','select','NOW()','field','ContactId','CmListId','toString','ListId','from','cm_contacts','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','COALESCE(calleridnum,\x27\x27)','CampaignId\x20=\x20?','onlyIfOpen','sequelize','all','removeLists','ids','addBlackLists','insert','cm_hopper_black','push','removeBlackLists','eml-format','zip-dir','fast-json-patch','request-promise','mustache','util','path','sox','ejs','lodash','squel','crypto','jsforce','ioredis','../../components/auth/service','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','sendStatus','status','end','json','count','offset','set','Content-Range','reject','save','then','destroy','get','IvrCampaigns','UserProfileResource','error','name','send','index','map','Campaign','rawAttributes'];(function(_0x4c98b9,_0x1ad11b){var _0x3a257a=function(_0x147857){while(--_0x147857){_0x4c98b9['push'](_0x4c98b9['shift']());}};_0x3a257a(++_0x1ad11b);}(_0x9f62,0x154));var _0x29f6=function(_0x381e3,_0x58ba57){_0x381e3=_0x381e3-0x0;var _0x373d4d=_0x9f62[_0x381e3];return _0x373d4d;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x29f6('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x29f6('0x1'));var jsonpatch=require(_0x29f6('0x2'));var rp=require(_0x29f6('0x3'));var moment=require('moment');var BPromise=require('bluebird');var Mustache=require(_0x29f6('0x4'));var util=require(_0x29f6('0x5'));var path=require(_0x29f6('0x6'));var sox=require(_0x29f6('0x7'));var csv=require('to-csv');var ejs=require(_0x29f6('0x8'));var fs=require('fs');var _=require(_0x29f6('0x9'));var squel=require(_0x29f6('0xa'));var crypto=require(_0x29f6('0xb'));var jsforce=require(_0x29f6('0xc'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require('papaparse');var Redis=require(_0x29f6('0xd'));var authService=require(_0x29f6('0xe'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x29f6('0xf'));var logger=require(_0x29f6('0x10'))('api');var utils=require(_0x29f6('0x11'));var config=require(_0x29f6('0x12'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x5b9b6a,_0x559585){_0x559585=_0x559585||0xcc;return function(_0x57b2d2){if(_0x57b2d2){return _0x5b9b6a[_0x29f6('0x13')](_0x559585);}return _0x5b9b6a[_0x29f6('0x14')](_0x559585)[_0x29f6('0x15')]();};}function respondWithResult(_0x11a1fd,_0x17de6e){_0x17de6e=_0x17de6e||0xc8;return function(_0x156c96){if(_0x156c96){return _0x11a1fd[_0x29f6('0x14')](_0x17de6e)[_0x29f6('0x16')](_0x156c96);}};}function respondWithFilteredResult(_0x1ae582,_0x19331f){return function(_0x28d314){if(_0x28d314){var _0x370484=_0x28d314[_0x29f6('0x17')],_0x1dde97=_0x19331f[_0x29f6('0x18')],_0x3a75d0=_0x19331f['offset']+_0x19331f['limit'],_0x25e5a2;if(_0x3a75d0>=_0x370484){_0x3a75d0=_0x370484;_0x25e5a2=0xc8;}else{_0x25e5a2=0xce;}_0x1ae582[_0x29f6('0x14')](_0x25e5a2);return _0x1ae582[_0x29f6('0x19')](_0x29f6('0x1a'),_0x1dde97+'-'+_0x3a75d0+'/'+_0x370484)['json'](_0x28d314);}return null;};}function patchUpdates(_0xcb90){return function(_0x46931d){try{jsonpatch['apply'](_0x46931d,_0xcb90,!![]);}catch(_0x159227){return BPromise[_0x29f6('0x1b')](_0x159227);}return _0x46931d[_0x29f6('0x1c')]();};}function saveUpdates(_0x41b9f0,_0xb6e7a9){return function(_0x2bfb3d){if(_0x2bfb3d){return _0x2bfb3d['update'](_0x41b9f0)[_0x29f6('0x1d')](function(_0x59def4){return _0x59def4;});}return null;};}function removeEntity(_0x4acb15,_0x470019){return function(_0x1fa159){if(_0x1fa159){return _0x1fa159[_0x29f6('0x1e')]()[_0x29f6('0x1d')](function(){var _0x54ddeb=_0x1fa159[_0x29f6('0x1f')]({'plain':!![]});var _0x49f67d=_0x29f6('0x20');return db[_0x29f6('0x21')][_0x29f6('0x1e')]({'where':{'type':_0x49f67d,'resourceId':_0x54ddeb['id']}})[_0x29f6('0x1d')](function(){return _0x1fa159;});})['then'](function(){_0x4acb15[_0x29f6('0x14')](0xcc)[_0x29f6('0x15')]();});}};}function handleEntityNotFound(_0x47c385,_0x1401fb){return function(_0x45f792){if(!_0x45f792){_0x47c385[_0x29f6('0x13')](0x194);}return _0x45f792;};}function handleError(_0x342038,_0x84ccb7){_0x84ccb7=_0x84ccb7||0x1f4;return function(_0x4333bc){logger[_0x29f6('0x22')](_0x4333bc['stack']);if(_0x4333bc[_0x29f6('0x23')]){delete _0x4333bc[_0x29f6('0x23')];}_0x342038[_0x29f6('0x14')](_0x84ccb7)[_0x29f6('0x24')](_0x4333bc);};}exports[_0x29f6('0x25')]=function(_0x16a6ad,_0x3790f5){var _0x17b2f2={},_0x3d88db={},_0x13a3a2={'count':0x0,'rows':[]};var _0x2915bc=_[_0x29f6('0x26')](db[_0x29f6('0x27')][_0x29f6('0x28')],function(_0x375564){return{'name':_0x375564[_0x29f6('0x29')],'type':_0x375564[_0x29f6('0x2a')]['key']};});_0x3d88db['model']=_[_0x29f6('0x26')](_0x2915bc,'name');_0x3d88db[_0x29f6('0x2b')]=_[_0x29f6('0x2c')](_0x16a6ad[_0x29f6('0x2b')]);_0x3d88db[_0x29f6('0x2d')]=_['intersection'](_0x3d88db['model'],_0x3d88db[_0x29f6('0x2b')]);_0x17b2f2[_0x29f6('0x2e')]=_[_0x29f6('0x2f')](_0x3d88db[_0x29f6('0x30')],qs[_0x29f6('0x31')](_0x16a6ad[_0x29f6('0x2b')][_0x29f6('0x31')]));_0x17b2f2[_0x29f6('0x2e')]=_0x17b2f2[_0x29f6('0x2e')][_0x29f6('0x32')]?_0x17b2f2[_0x29f6('0x2e')]:_0x3d88db[_0x29f6('0x30')];if(!_0x16a6ad[_0x29f6('0x2b')][_0x29f6('0x33')]('nolimit')){_0x17b2f2['limit']=qs[_0x29f6('0x34')](_0x16a6ad[_0x29f6('0x2b')][_0x29f6('0x34')]);_0x17b2f2['offset']=qs[_0x29f6('0x18')](_0x16a6ad[_0x29f6('0x2b')][_0x29f6('0x18')]);}_0x17b2f2[_0x29f6('0x35')]=qs[_0x29f6('0x36')](_0x16a6ad['query'][_0x29f6('0x36')]);_0x17b2f2[_0x29f6('0x37')]=qs[_0x29f6('0x2d')](_[_0x29f6('0x38')](_0x16a6ad['query'],_0x3d88db[_0x29f6('0x2d')]));if(_0x16a6ad[_0x29f6('0x2b')][_0x29f6('0x39')]){_0x17b2f2[_0x29f6('0x37')]=_['merge'](_0x17b2f2['where'],{'$or':_[_0x29f6('0x26')](_0x2915bc,function(_0x4bfc80){if(_0x4bfc80[_0x29f6('0x2a')]!=='VIRTUAL'){var _0x3a1a75={};_0x3a1a75[_0x4bfc80['name']]={'$like':'%'+_0x16a6ad[_0x29f6('0x2b')][_0x29f6('0x39')]+'%'};return _0x3a1a75;}})});}_0x17b2f2=_['merge']({},_0x17b2f2,_0x16a6ad[_0x29f6('0x3a')]);var _0x5d2553={'where':_0x17b2f2[_0x29f6('0x37')]};return db[_0x29f6('0x27')]['count'](_0x5d2553)[_0x29f6('0x1d')](function(_0xc6a6b1){_0x13a3a2[_0x29f6('0x17')]=_0xc6a6b1;if(_0x16a6ad[_0x29f6('0x2b')]['includeAll']){_0x17b2f2[_0x29f6('0x3b')]=[{'all':!![]}];}return db[_0x29f6('0x27')][_0x29f6('0x3c')](_0x17b2f2);})[_0x29f6('0x1d')](function(_0x1dbd17){_0x13a3a2['rows']=_0x1dbd17;return _0x13a3a2;})[_0x29f6('0x1d')](respondWithFilteredResult(_0x3790f5,_0x17b2f2))['catch'](handleError(_0x3790f5,null));};exports[_0x29f6('0x3d')]=function(_0x552257,_0xbfe671){var _0x3a8a12={'raw':![],'where':{'id':_0x552257[_0x29f6('0x3e')]['id']}},_0x4b1524={};_0x4b1524[_0x29f6('0x30')]=_[_0x29f6('0x2c')](db[_0x29f6('0x27')]['rawAttributes']);_0x4b1524[_0x29f6('0x2b')]=_[_0x29f6('0x2c')](_0x552257[_0x29f6('0x2b')]);_0x4b1524['filters']=_[_0x29f6('0x2f')](_0x4b1524['model'],_0x4b1524[_0x29f6('0x2b')]);_0x3a8a12['attributes']=_['intersection'](_0x4b1524['model'],qs[_0x29f6('0x31')](_0x552257[_0x29f6('0x2b')][_0x29f6('0x31')]));_0x3a8a12[_0x29f6('0x2e')]=_0x3a8a12[_0x29f6('0x2e')][_0x29f6('0x32')]?_0x3a8a12[_0x29f6('0x2e')]:_0x4b1524[_0x29f6('0x30')];if(_0x552257[_0x29f6('0x2b')][_0x29f6('0x3f')]){_0x3a8a12['include']=[{'all':!![]}];}_0x3a8a12=_['merge']({},_0x3a8a12,_0x552257[_0x29f6('0x3a')]);return db[_0x29f6('0x27')][_0x29f6('0x40')](_0x3a8a12)[_0x29f6('0x1d')](handleEntityNotFound(_0xbfe671,null))['then'](respondWithResult(_0xbfe671,null))[_0x29f6('0x41')](handleError(_0xbfe671,null));};exports[_0x29f6('0x42')]=function(_0x532df5,_0x21f023){return db[_0x29f6('0x27')][_0x29f6('0x42')](_0x532df5[_0x29f6('0x43')],{})[_0x29f6('0x1d')](function(_0x461208){var _0x320b5e=_0x532df5[_0x29f6('0x44')][_0x29f6('0x1f')]({'plain':!![]});if(!_0x320b5e)throw new Error(_0x29f6('0x45'));if(_0x320b5e[_0x29f6('0x46')]===_0x29f6('0x44')){var _0x58ea69=_0x461208[_0x29f6('0x1f')]({'plain':!![]});var _0x463551=_0x29f6('0x20');return db[_0x29f6('0x47')][_0x29f6('0x40')]({'where':{'name':_0x463551,'userProfileId':_0x320b5e['userProfileId']},'raw':!![]})[_0x29f6('0x1d')](function(_0x52be22){if(_0x52be22&&_0x52be22['autoAssociation']===0x0){return db[_0x29f6('0x21')][_0x29f6('0x42')]({'name':_0x58ea69[_0x29f6('0x23')],'resourceId':_0x58ea69['id'],'type':_0x52be22[_0x29f6('0x23')],'sectionId':_0x52be22['id']},{})[_0x29f6('0x1d')](function(){return _0x461208;});}else{return _0x461208;}})['catch'](function(_0x167976){logger[_0x29f6('0x22')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x167976);throw _0x167976;});}return _0x461208;})[_0x29f6('0x1d')](respondWithResult(_0x21f023,0xc9))['catch'](handleError(_0x21f023,null));};exports[_0x29f6('0x48')]=function(_0x241fb0,_0x27601d){var _0x292567={'where':{'id':_0x241fb0[_0x29f6('0x3e')]['id']}},_0x5c9113={};_0x5c9113[_0x29f6('0x30')]=_[_0x29f6('0x2c')](db[_0x29f6('0x27')][_0x29f6('0x28')]);_0x292567[_0x29f6('0x2e')]=_[_0x29f6('0x2f')](_0x5c9113['model'],qs[_0x29f6('0x31')](_0x241fb0[_0x29f6('0x2b')][_0x29f6('0x31')]));_0x292567[_0x29f6('0x2e')]=_0x292567[_0x29f6('0x2e')][_0x29f6('0x32')]?_0x292567[_0x29f6('0x2e')]:_0x5c9113[_0x29f6('0x30')];if(_0x241fb0[_0x29f6('0x2b')][_0x29f6('0x3f')]){_0x292567['include']=[{'all':!![]}];}_0x292567=_['merge']({},_0x292567,_0x241fb0[_0x29f6('0x3a')]);return db[_0x29f6('0x27')][_0x29f6('0x40')](_0x292567)['then'](handleEntityNotFound(_0x27601d,null))[_0x29f6('0x1d')](function(_0x48aa77){if(_0x48aa77){var _0x550190=_0x48aa77[_0x29f6('0x1f')]({'plain':!![]});_0x550190=qs[_0x29f6('0x49')](_0x550190,['id','createdAt','updatedAt']);_0x241fb0[_0x29f6('0x43')]=_[_0x29f6('0x49')](_0x241fb0[_0x29f6('0x43')],['id','createdAt',_0x29f6('0x4a')]);return db[_0x29f6('0x27')][_0x29f6('0x42')](_[_0x29f6('0x4b')](_0x550190,_0x241fb0[_0x29f6('0x43')]),{'include':_0x241fb0[_0x29f6('0x2b')][_0x29f6('0x3f')]?[{'all':!![]}]:undefined})[_0x29f6('0x1d')](function(_0x2fb6f8){var _0x192525=_0x241fb0[_0x29f6('0x44')][_0x29f6('0x1f')]({'plain':!![]});if(!_0x192525)throw new Error(_0x29f6('0x45'));if(_0x192525['role']==='user'){var _0x2bd7d9=_0x2fb6f8['get']({'plain':!![]});var _0x1a5220=_0x29f6('0x20');return db[_0x29f6('0x47')][_0x29f6('0x40')]({'where':{'name':_0x1a5220,'userProfileId':_0x192525[_0x29f6('0x4c')]},'raw':!![]})['then'](function(_0x56c442){if(_0x56c442&&_0x56c442[_0x29f6('0x4d')]===0x0){return db[_0x29f6('0x21')][_0x29f6('0x42')]({'name':_0x2bd7d9[_0x29f6('0x23')],'resourceId':_0x2bd7d9['id'],'type':_0x56c442['name'],'sectionId':_0x56c442['id']},{})[_0x29f6('0x1d')](function(){return _0x2fb6f8;});}else{return _0x2fb6f8;}})['catch'](function(_0x51b9dc){logger[_0x29f6('0x22')](_0x29f6('0x4e'),_0x51b9dc);throw _0x51b9dc;});}return _0x2fb6f8;});}})['then'](respondWithResult(_0x27601d,0xc9))[_0x29f6('0x41')](handleError(_0x27601d,null));};exports[_0x29f6('0x4f')]=function(_0x58bdf4,_0x44b3ee){if(_0x58bdf4[_0x29f6('0x43')]['id']){delete _0x58bdf4[_0x29f6('0x43')]['id'];}return db[_0x29f6('0x27')][_0x29f6('0x40')]({'where':{'id':_0x58bdf4[_0x29f6('0x3e')]['id']}})[_0x29f6('0x1d')](handleEntityNotFound(_0x44b3ee,null))['then'](saveUpdates(_0x58bdf4[_0x29f6('0x43')],null))['then'](respondWithResult(_0x44b3ee,null))[_0x29f6('0x41')](handleError(_0x44b3ee,null));};exports['destroy']=function(_0x4cbd5e,_0x1a3357){return db[_0x29f6('0x27')][_0x29f6('0x40')]({'where':{'id':_0x4cbd5e['params']['id']}})[_0x29f6('0x1d')](handleEntityNotFound(_0x1a3357,null))[_0x29f6('0x1d')](removeEntity(_0x1a3357,null))[_0x29f6('0x41')](handleError(_0x1a3357,null));};exports['getHoppers']=function(_0x728094,_0x35623a,_0x66a7bb){var _0xc50331={'raw':!![],'where':{}};var _0x1f9a9d={};var _0x15cf8e={'count':0x0,'rows':[]};return db[_0x29f6('0x27')][_0x29f6('0x50')]({'where':{'id':_0x728094['params']['id']}})[_0x29f6('0x1d')](handleEntityNotFound(_0x35623a,null))[_0x29f6('0x1d')](function(_0x2e1de8){if(_0x2e1de8){_0x1f9a9d[_0x29f6('0x30')]=_[_0x29f6('0x2c')](db[_0x29f6('0x51')][_0x29f6('0x28')]);_0x1f9a9d[_0x29f6('0x2b')]=_['keys'](_0x728094[_0x29f6('0x2b')]);_0x1f9a9d[_0x29f6('0x2d')]=_['intersection'](_0x1f9a9d[_0x29f6('0x30')],_0x1f9a9d['query']);_0xc50331[_0x29f6('0x2e')]=_[_0x29f6('0x2f')](_0x1f9a9d['model'],qs[_0x29f6('0x31')](_0x728094[_0x29f6('0x2b')]['fields']));_0xc50331['attributes']=_0xc50331['attributes'][_0x29f6('0x32')]?_0xc50331[_0x29f6('0x2e')]:_0x1f9a9d[_0x29f6('0x30')];if(!_0x728094[_0x29f6('0x2b')][_0x29f6('0x33')](_0x29f6('0x52'))){_0xc50331[_0x29f6('0x34')]=qs['limit'](_0x728094[_0x29f6('0x2b')][_0x29f6('0x34')]);_0xc50331[_0x29f6('0x18')]=qs[_0x29f6('0x18')](_0x728094['query'][_0x29f6('0x18')]);}_0xc50331[_0x29f6('0x35')]=qs[_0x29f6('0x36')](_0x728094[_0x29f6('0x2b')][_0x29f6('0x36')]);_0xc50331['where']=qs[_0x29f6('0x2d')](_[_0x29f6('0x38')](_0x728094[_0x29f6('0x2b')],_0x1f9a9d[_0x29f6('0x2d')]));_0xc50331[_0x29f6('0x37')][_0x29f6('0x53')]=_0x2e1de8['id'];if(_0x728094['query'][_0x29f6('0x39')]){_0xc50331['where']=_['merge'](_0xc50331['where'],{'$or':_[_0x29f6('0x26')](_0xc50331['attributes'],function(_0x425da2){var _0x3e901e={};_0x3e901e[_0x425da2]={'$like':'%'+_0x728094[_0x29f6('0x2b')][_0x29f6('0x39')]+'%'};return _0x3e901e;})});}_0xc50331=_[_0x29f6('0x4b')]({},_0xc50331,_0x728094[_0x29f6('0x3a')]);return db[_0x29f6('0x51')]['count']({'where':_0xc50331[_0x29f6('0x37')]})['then'](function(_0xf3a7d0){_0x15cf8e[_0x29f6('0x17')]=_0xf3a7d0;if(_0x728094[_0x29f6('0x2b')][_0x29f6('0x3f')]){_0xc50331[_0x29f6('0x3b')]=[{'all':!![]}];}return db[_0x29f6('0x51')][_0x29f6('0x3c')](_0xc50331);})[_0x29f6('0x1d')](function(_0x18a470){_0x15cf8e[_0x29f6('0x54')]=_0x18a470;return _0x15cf8e;});}})[_0x29f6('0x1d')](respondWithFilteredResult(_0x35623a,_0xc50331))[_0x29f6('0x41')](handleError(_0x35623a,null));};exports['getHopperHistories']=function(_0x4eb7c9,_0x4c152d,_0xa31c7d){var _0xf845f2={'raw':!![],'where':{}};var _0x4d0383={};var _0xf18d73={'count':0x0,'rows':[]};return db['Campaign'][_0x29f6('0x50')]({'where':{'id':_0x4eb7c9[_0x29f6('0x3e')]['id']}})[_0x29f6('0x1d')](handleEntityNotFound(_0x4c152d,null))[_0x29f6('0x1d')](function(_0x45b42c){if(_0x45b42c){_0x4d0383[_0x29f6('0x30')]=_[_0x29f6('0x2c')](db[_0x29f6('0x55')][_0x29f6('0x28')]);_0x4d0383[_0x29f6('0x2b')]=_['keys'](_0x4eb7c9[_0x29f6('0x2b')]);_0x4d0383['filters']=_[_0x29f6('0x2f')](_0x4d0383[_0x29f6('0x30')],_0x4d0383[_0x29f6('0x2b')]);_0xf845f2[_0x29f6('0x2e')]=_[_0x29f6('0x2f')](_0x4d0383[_0x29f6('0x30')],qs[_0x29f6('0x31')](_0x4eb7c9[_0x29f6('0x2b')]['fields']));_0xf845f2[_0x29f6('0x2e')]=_0xf845f2[_0x29f6('0x2e')]['length']?_0xf845f2['attributes']:_0x4d0383[_0x29f6('0x30')];if(!_0x4eb7c9[_0x29f6('0x2b')][_0x29f6('0x33')](_0x29f6('0x52'))){_0xf845f2[_0x29f6('0x34')]=qs[_0x29f6('0x34')](_0x4eb7c9[_0x29f6('0x2b')][_0x29f6('0x34')]);_0xf845f2[_0x29f6('0x18')]=qs[_0x29f6('0x18')](_0x4eb7c9[_0x29f6('0x2b')][_0x29f6('0x18')]);}_0xf845f2['order']=qs['sort'](_0x4eb7c9[_0x29f6('0x2b')][_0x29f6('0x36')]);_0xf845f2['where']=qs[_0x29f6('0x2d')](_[_0x29f6('0x38')](_0x4eb7c9[_0x29f6('0x2b')],_0x4d0383[_0x29f6('0x2d')]));_0xf845f2[_0x29f6('0x37')][_0x29f6('0x53')]=_0x45b42c['id'];if(_0x4eb7c9[_0x29f6('0x2b')]['filter']){_0xf845f2[_0x29f6('0x37')]=_[_0x29f6('0x4b')](_0xf845f2[_0x29f6('0x37')],{'$or':_['map'](_0xf845f2[_0x29f6('0x2e')],function(_0x39373c){var _0x5f3ed9={};_0x5f3ed9[_0x39373c]={'$like':'%'+_0x4eb7c9[_0x29f6('0x2b')][_0x29f6('0x39')]+'%'};return _0x5f3ed9;})});}_0xf845f2=_['merge']({},_0xf845f2,_0x4eb7c9[_0x29f6('0x3a')]);return db['CmHopperHistory'][_0x29f6('0x17')]({'where':_0xf845f2[_0x29f6('0x37')]})[_0x29f6('0x1d')](function(_0x3a7064){_0xf18d73[_0x29f6('0x17')]=_0x3a7064;if(_0x4eb7c9[_0x29f6('0x2b')]['includeAll']){_0xf845f2['include']=[{'all':!![]}];}return db[_0x29f6('0x55')][_0x29f6('0x3c')](_0xf845f2);})['then'](function(_0x3025df){_0xf18d73['rows']=_0x3025df;return _0xf18d73;});}})[_0x29f6('0x1d')](respondWithFilteredResult(_0x4c152d,_0xf845f2))[_0x29f6('0x41')](handleError(_0x4c152d,null));};exports[_0x29f6('0x56')]=function(_0x32981f,_0x13d7b7,_0x2a7b8a){var _0x3454f8={'raw':!![],'where':{}};var _0x5b7929={};var _0x3b94de={'count':0x0,'rows':[]};return db[_0x29f6('0x27')][_0x29f6('0x50')]({'where':{'id':_0x32981f['params']['id']}})['then'](handleEntityNotFound(_0x13d7b7,null))['then'](function(_0x526a1a){if(_0x526a1a){_0x5b7929[_0x29f6('0x30')]=_['keys'](db['CmHopperFinal']['rawAttributes']);_0x5b7929[_0x29f6('0x2b')]=_[_0x29f6('0x2c')](_0x32981f[_0x29f6('0x2b')]);_0x5b7929[_0x29f6('0x2d')]=_[_0x29f6('0x2f')](_0x5b7929['model'],_0x5b7929[_0x29f6('0x2b')]);_0x3454f8['attributes']=_[_0x29f6('0x2f')](_0x5b7929[_0x29f6('0x30')],qs[_0x29f6('0x31')](_0x32981f[_0x29f6('0x2b')]['fields']));_0x3454f8['attributes']=_0x3454f8[_0x29f6('0x2e')][_0x29f6('0x32')]?_0x3454f8[_0x29f6('0x2e')]:_0x5b7929['model'];if(!_0x32981f[_0x29f6('0x2b')][_0x29f6('0x33')]('nolimit')){_0x3454f8[_0x29f6('0x34')]=qs[_0x29f6('0x34')](_0x32981f[_0x29f6('0x2b')][_0x29f6('0x34')]);_0x3454f8[_0x29f6('0x18')]=qs[_0x29f6('0x18')](_0x32981f[_0x29f6('0x2b')][_0x29f6('0x18')]);}_0x3454f8[_0x29f6('0x35')]=qs[_0x29f6('0x36')](_0x32981f['query'][_0x29f6('0x36')]);_0x3454f8['where']=qs['filters'](_['pick'](_0x32981f[_0x29f6('0x2b')],_0x5b7929[_0x29f6('0x2d')]));_0x3454f8['where']['CampaignId']=_0x526a1a['id'];if(_0x32981f[_0x29f6('0x2b')][_0x29f6('0x39')]){_0x3454f8['where']=_['merge'](_0x3454f8['where'],{'$or':_['map'](_0x3454f8[_0x29f6('0x2e')],function(_0x5a8422){var _0x19e1bd={};_0x19e1bd[_0x5a8422]={'$like':'%'+_0x32981f[_0x29f6('0x2b')]['filter']+'%'};return _0x19e1bd;})});}_0x3454f8=_[_0x29f6('0x4b')]({},_0x3454f8,_0x32981f[_0x29f6('0x3a')]);return db['CmHopperFinal'][_0x29f6('0x17')]({'where':_0x3454f8[_0x29f6('0x37')]})[_0x29f6('0x1d')](function(_0x31dbe8){_0x3b94de[_0x29f6('0x17')]=_0x31dbe8;if(_0x32981f[_0x29f6('0x2b')][_0x29f6('0x3f')]){_0x3454f8[_0x29f6('0x3b')]=[{'all':!![]}];}return db[_0x29f6('0x57')][_0x29f6('0x3c')](_0x3454f8);})[_0x29f6('0x1d')](function(_0x111a15){_0x3b94de[_0x29f6('0x54')]=_0x111a15;return _0x3b94de;});}})[_0x29f6('0x1d')](respondWithFilteredResult(_0x13d7b7,_0x3454f8))['catch'](handleError(_0x13d7b7,null));};exports[_0x29f6('0x58')]=function(_0x252bab,_0xa3981d,_0x264617){var _0x43bf20={'raw':!![],'where':{}};var _0x3569f7={};var _0xa13f66={'count':0x0,'rows':[]};return db['Campaign'][_0x29f6('0x50')]({'where':{'id':_0x252bab['params']['id']}})[_0x29f6('0x1d')](handleEntityNotFound(_0xa3981d,null))[_0x29f6('0x1d')](function(_0x3f9f31){if(_0x3f9f31){_0x3569f7[_0x29f6('0x30')]=_[_0x29f6('0x2c')](db[_0x29f6('0x59')][_0x29f6('0x28')]);_0x3569f7[_0x29f6('0x2b')]=_[_0x29f6('0x2c')](_0x252bab['query']);_0x3569f7[_0x29f6('0x2d')]=_[_0x29f6('0x2f')](_0x3569f7['model'],_0x3569f7['query']);_0x43bf20[_0x29f6('0x2e')]=_[_0x29f6('0x2f')](_0x3569f7[_0x29f6('0x30')],qs[_0x29f6('0x31')](_0x252bab['query'][_0x29f6('0x31')]));_0x43bf20[_0x29f6('0x2e')]=_0x43bf20['attributes'][_0x29f6('0x32')]?_0x43bf20[_0x29f6('0x2e')]:_0x3569f7[_0x29f6('0x30')];if(!_0x252bab[_0x29f6('0x2b')][_0x29f6('0x33')](_0x29f6('0x52'))){_0x43bf20[_0x29f6('0x34')]=qs[_0x29f6('0x34')](_0x252bab[_0x29f6('0x2b')][_0x29f6('0x34')]);_0x43bf20[_0x29f6('0x18')]=qs[_0x29f6('0x18')](_0x252bab[_0x29f6('0x2b')]['offset']);}_0x43bf20[_0x29f6('0x35')]=qs[_0x29f6('0x36')](_0x252bab[_0x29f6('0x2b')][_0x29f6('0x36')]);_0x43bf20['where']=qs[_0x29f6('0x2d')](_[_0x29f6('0x38')](_0x252bab[_0x29f6('0x2b')],_0x3569f7['filters']));_0x43bf20[_0x29f6('0x37')][_0x29f6('0x53')]=_0x3f9f31['id'];if(_0x252bab['query'][_0x29f6('0x39')]){_0x43bf20[_0x29f6('0x37')]=_[_0x29f6('0x4b')](_0x43bf20[_0x29f6('0x37')],{'$or':_[_0x29f6('0x26')](_0x43bf20[_0x29f6('0x2e')],function(_0x6c90c3){var _0x1bf0e8={};_0x1bf0e8[_0x6c90c3]={'$like':'%'+_0x252bab[_0x29f6('0x2b')][_0x29f6('0x39')]+'%'};return _0x1bf0e8;})});}_0x43bf20=_[_0x29f6('0x4b')]({},_0x43bf20,_0x252bab['options']);return db['CmHopperBlack'][_0x29f6('0x17')]({'where':_0x43bf20[_0x29f6('0x37')]})[_0x29f6('0x1d')](function(_0x1f0e72){_0xa13f66[_0x29f6('0x17')]=_0x1f0e72;if(_0x252bab[_0x29f6('0x2b')][_0x29f6('0x3f')]){_0x43bf20[_0x29f6('0x3b')]=[{'all':!![]}];}return db['CmHopperBlack']['findAll'](_0x43bf20);})['then'](function(_0x1fd477){_0xa13f66[_0x29f6('0x54')]=_0x1fd477;return _0xa13f66;});}})[_0x29f6('0x1d')](respondWithFilteredResult(_0xa3981d,_0x43bf20))[_0x29f6('0x41')](handleError(_0xa3981d,null));};exports['getLists']=function(_0x414539,_0x4a0651,_0x4f2471){var _0x1ef540={};var _0x5a51c0={};var _0xe7b88c;var _0x2a2e0e;return db[_0x29f6('0x27')][_0x29f6('0x50')]({'where':{'id':_0x414539['params']['id']}})[_0x29f6('0x1d')](handleEntityNotFound(_0x4a0651,null))['then'](function(_0x47785a){if(_0x47785a){_0xe7b88c=_0x47785a;_0x5a51c0[_0x29f6('0x30')]=_[_0x29f6('0x2c')](db[_0x29f6('0x5a')][_0x29f6('0x28')]);_0x5a51c0[_0x29f6('0x2b')]=_['keys'](_0x414539['query']);_0x5a51c0[_0x29f6('0x2d')]=_['intersection'](_0x5a51c0['model'],_0x5a51c0[_0x29f6('0x2b')]);_0x1ef540['attributes']=_[_0x29f6('0x2f')](_0x5a51c0[_0x29f6('0x30')],qs[_0x29f6('0x31')](_0x414539[_0x29f6('0x2b')][_0x29f6('0x31')]));_0x1ef540[_0x29f6('0x2e')]=_0x1ef540['attributes'][_0x29f6('0x32')]?_0x1ef540[_0x29f6('0x2e')]:_0x5a51c0[_0x29f6('0x30')];_0x1ef540[_0x29f6('0x35')]=qs[_0x29f6('0x36')](_0x414539[_0x29f6('0x2b')][_0x29f6('0x36')]);_0x1ef540[_0x29f6('0x37')]=qs[_0x29f6('0x2d')](_[_0x29f6('0x38')](_0x414539[_0x29f6('0x2b')],_0x5a51c0['filters']));if(_0x414539[_0x29f6('0x2b')][_0x29f6('0x39')]){_0x1ef540['where']=_[_0x29f6('0x4b')](_0x1ef540[_0x29f6('0x37')],{'$or':_[_0x29f6('0x26')](_0x1ef540['attributes'],function(_0x5f1781){var _0x1413a5={};_0x1413a5[_0x5f1781]={'$like':'%'+_0x414539[_0x29f6('0x2b')][_0x29f6('0x39')]+'%'};return _0x1413a5;})});}_0x1ef540=_[_0x29f6('0x4b')]({},_0x1ef540,_0x414539[_0x29f6('0x3a')]);return _0xe7b88c[_0x29f6('0x5b')](_0x1ef540);}})['then'](function(_0x34da57){if(_0x34da57){_0x2a2e0e=_0x34da57[_0x29f6('0x32')];if(!_0x414539['query']['hasOwnProperty']('nolimit')){_0x1ef540[_0x29f6('0x34')]=qs['limit'](_0x414539[_0x29f6('0x2b')]['limit']);_0x1ef540[_0x29f6('0x18')]=qs[_0x29f6('0x18')](_0x414539[_0x29f6('0x2b')][_0x29f6('0x18')]);}return _0xe7b88c[_0x29f6('0x5b')](_0x1ef540);}})['then'](function(_0x371ea9){if(_0x371ea9){return _0x371ea9?{'count':_0x2a2e0e,'rows':_0x371ea9}:null;}})['then'](respondWithResult(_0x4a0651,null))[_0x29f6('0x41')](handleError(_0x4a0651,null));};exports[_0x29f6('0x5c')]=function(_0x46147d,_0x19d1cb,_0x478660){var _0x2e00ed,_0x3a9cc2;return db[_0x29f6('0x27')]['find']({'where':{'id':_0x46147d[_0x29f6('0x3e')]['id']}})['then'](handleEntityNotFound(_0x19d1cb,null))[_0x29f6('0x1d')](function(_0x2775d0){if(_0x2775d0){_0x3a9cc2=_0x2775d0;return _0x2775d0['addLists'](_0x46147d[_0x29f6('0x43')]['ids'],_[_0x29f6('0x49')](_0x46147d[_0x29f6('0x43')],['ids','id'])||{});}return null;})[_0x29f6('0x5d')](function(_0x205304){var _0x4ef377;_0x2e00ed=_0x205304||[];var _0x3d6aaf=[];if(_0x205304){for(var _0x22a012=0x0;_0x22a012<_0x205304[_0x29f6('0x32')];_0x22a012+=0x1){var _0x39b911=_0x205304[_0x22a012][_0x29f6('0x1f')]({'plain':!![]});_0x3a9cc2[_0x29f6('0x5e')]=_0x46147d[_0x29f6('0x43')][_0x29f6('0x5e')]?_0x46147d['body'][_0x29f6('0x5e')]:_0x3a9cc2[_0x29f6('0x5e')];switch(_0x3a9cc2[_0x29f6('0x5e')]){case _0x29f6('0x5f'):_0x4ef377=squel['insert']()[_0x29f6('0x60')](_0x29f6('0x61'))[_0x29f6('0x62')]([_0x29f6('0x63'),_0x29f6('0x64'),'ContactId','ListId',_0x29f6('0x53'),_0x29f6('0x65'),'updatedAt'],squel[_0x29f6('0x66')]()['field']('phone',_0x29f6('0x63'))['field'](_0x29f6('0x67'),_0x29f6('0x64'))[_0x29f6('0x68')]('id',_0x29f6('0x69'))['field'](_0x39b911[_0x29f6('0x6a')][_0x29f6('0x6b')](),_0x29f6('0x6c'))[_0x29f6('0x68')](_0x46147d[_0x29f6('0x3e')]['id'][_0x29f6('0x6b')](),'CampaignId')['field'](_0x29f6('0x67'),_0x29f6('0x65'))[_0x29f6('0x68')](_0x29f6('0x67'),_0x29f6('0x4a'))[_0x29f6('0x6d')](_0x29f6('0x6e'))[_0x29f6('0x37')](_0x29f6('0x6f'))[_0x29f6('0x37')](_0x29f6('0x70'),_0x39b911[_0x29f6('0x6a')][_0x29f6('0x6b')]())[_0x29f6('0x37')](_0x29f6('0x71'))['where'](_0x29f6('0x72'),squel[_0x29f6('0x66')]()[_0x29f6('0x68')](_0x29f6('0x73'))[_0x29f6('0x6d')]('cm_hopper_final')[_0x29f6('0x37')](_0x29f6('0x74'),_0x46147d[_0x29f6('0x3e')]['id']['toString']()))[_0x29f6('0x37')](_0x29f6('0x72'),squel[_0x29f6('0x66')]()[_0x29f6('0x68')]('COALESCE(phone,\x27\x27)')[_0x29f6('0x6d')]('cm_hopper')[_0x29f6('0x37')]('CampaignId\x20=\x20?',_0x46147d[_0x29f6('0x3e')]['id'][_0x29f6('0x6b')]())))[_0x29f6('0x6b')]();break;case _0x29f6('0x75'):_0x4ef377=squel['insert']()[_0x29f6('0x60')](_0x29f6('0x61'))[_0x29f6('0x62')]([_0x29f6('0x63'),_0x29f6('0x64'),_0x29f6('0x69'),_0x29f6('0x6c'),_0x29f6('0x53'),_0x29f6('0x65'),_0x29f6('0x4a')],squel[_0x29f6('0x66')]()[_0x29f6('0x68')]('phone',_0x29f6('0x63'))[_0x29f6('0x68')](_0x29f6('0x67'),_0x29f6('0x64'))[_0x29f6('0x68')]('id',_0x29f6('0x69'))[_0x29f6('0x68')](_0x39b911[_0x29f6('0x6a')]['toString'](),_0x29f6('0x6c'))['field'](_0x46147d['params']['id'][_0x29f6('0x6b')](),'CampaignId')[_0x29f6('0x68')](_0x29f6('0x67'),'createdAt')[_0x29f6('0x68')](_0x29f6('0x67'),_0x29f6('0x4a'))[_0x29f6('0x6d')](_0x29f6('0x6e'))[_0x29f6('0x37')](_0x29f6('0x6f'))['where'](_0x29f6('0x70'),_0x39b911[_0x29f6('0x6a')][_0x29f6('0x6b')]())[_0x29f6('0x37')](_0x29f6('0x71'))[_0x29f6('0x37')]('phone\x20NOT\x20IN\x20(?)',squel[_0x29f6('0x66')]()[_0x29f6('0x68')]('COALESCE(phone,\x27\x27)')[_0x29f6('0x6d')](_0x29f6('0x61'))['where'](_0x29f6('0x74'),_0x46147d[_0x29f6('0x3e')]['id']['toString']())))[_0x29f6('0x6b')]();break;default:_0x4ef377=squel['insert']()['into'](_0x29f6('0x61'))[_0x29f6('0x62')]([_0x29f6('0x63'),_0x29f6('0x64'),'ContactId','ListId',_0x29f6('0x53'),_0x29f6('0x65'),_0x29f6('0x4a')],squel[_0x29f6('0x66')]()[_0x29f6('0x68')](_0x29f6('0x63'),_0x29f6('0x63'))[_0x29f6('0x68')](_0x29f6('0x67'),_0x29f6('0x64'))[_0x29f6('0x68')]('id',_0x29f6('0x69'))[_0x29f6('0x68')](_0x39b911['CmListId']['toString'](),_0x29f6('0x6c'))[_0x29f6('0x68')](_0x46147d['params']['id'][_0x29f6('0x6b')](),_0x29f6('0x53'))['field']('NOW()','createdAt')[_0x29f6('0x68')](_0x29f6('0x67'),_0x29f6('0x4a'))[_0x29f6('0x6d')]('cm_contacts')[_0x29f6('0x37')](_0x29f6('0x6f'))[_0x29f6('0x37')](_0x29f6('0x70'),_0x39b911[_0x29f6('0x6a')][_0x29f6('0x6b')]())[_0x29f6('0x37')](_0x29f6('0x71')))[_0x29f6('0x6b')]();}_0x3d6aaf['push'](db[_0x29f6('0x76')][_0x29f6('0x2b')](_0x4ef377));}return BPromise[_0x29f6('0x77')](_0x3d6aaf);}})[_0x29f6('0x1d')](function(){return _0x2e00ed;})['then'](respondWithResult(_0x19d1cb,null))['catch'](handleError(_0x19d1cb,null));};exports[_0x29f6('0x78')]=function(_0x41446f,_0x21f16b,_0x43c37b){return db[_0x29f6('0x27')]['find']({'where':{'id':_0x41446f[_0x29f6('0x3e')]['id']}})[_0x29f6('0x1d')](handleEntityNotFound(_0x21f16b,null))[_0x29f6('0x1d')](function(_0x6bda6e){if(_0x6bda6e){return _0x6bda6e[_0x29f6('0x78')](_0x41446f[_0x29f6('0x2b')][_0x29f6('0x79')]);}})['then'](function(_0x8e9851){if(_0x8e9851){return db[_0x29f6('0x51')][_0x29f6('0x1e')]({'where':{'ListId':_0x41446f[_0x29f6('0x2b')]['ids'],'CampaignId':_0x41446f[_0x29f6('0x3e')]['id']}})[_0x29f6('0x1d')](function(){return _0x8e9851;});}})[_0x29f6('0x1d')](respondWithStatusCode(_0x21f16b,null))[_0x29f6('0x41')](handleError(_0x21f16b,null));};exports['getBlackLists']=function(_0x226c3b,_0x12d246,_0x441903){var _0x5506e8={'raw':!![],'where':{}};var _0x1d74d3={};var _0x318fd1={'count':0x0,'rows':[]};return db[_0x29f6('0x27')][_0x29f6('0x50')]({'where':{'id':_0x226c3b['params']['id']}})[_0x29f6('0x1d')](handleEntityNotFound(_0x12d246,null))[_0x29f6('0x1d')](function(_0x488d3c){if(_0x488d3c){_0x1d74d3['model']=_['keys'](db[_0x29f6('0x5a')][_0x29f6('0x28')]);_0x1d74d3['query']=_[_0x29f6('0x2c')](_0x226c3b[_0x29f6('0x2b')]);_0x1d74d3[_0x29f6('0x2d')]=_[_0x29f6('0x2f')](_0x1d74d3[_0x29f6('0x30')],_0x1d74d3['query']);_0x5506e8[_0x29f6('0x2e')]=_[_0x29f6('0x2f')](_0x1d74d3[_0x29f6('0x30')],qs[_0x29f6('0x31')](_0x226c3b[_0x29f6('0x2b')][_0x29f6('0x31')]));_0x5506e8[_0x29f6('0x2e')]=_0x5506e8[_0x29f6('0x2e')][_0x29f6('0x32')]?_0x5506e8[_0x29f6('0x2e')]:_0x1d74d3['model'];if(!_0x226c3b[_0x29f6('0x2b')][_0x29f6('0x33')]('nolimit')){_0x5506e8[_0x29f6('0x34')]=qs[_0x29f6('0x34')](_0x226c3b[_0x29f6('0x2b')][_0x29f6('0x34')]);_0x5506e8[_0x29f6('0x18')]=qs['offset'](_0x226c3b[_0x29f6('0x2b')][_0x29f6('0x18')]);}_0x5506e8[_0x29f6('0x35')]=qs['sort'](_0x226c3b['query'][_0x29f6('0x36')]);_0x5506e8[_0x29f6('0x37')]=qs[_0x29f6('0x2d')](_[_0x29f6('0x38')](_0x226c3b[_0x29f6('0x2b')],_0x1d74d3[_0x29f6('0x2d')]));_0x5506e8['where']['CampaignId']=_0x488d3c['id'];if(_0x226c3b[_0x29f6('0x2b')][_0x29f6('0x39')]){_0x5506e8[_0x29f6('0x37')]=_[_0x29f6('0x4b')](_0x5506e8[_0x29f6('0x37')],{'$or':_[_0x29f6('0x26')](_0x5506e8['attributes'],function(_0x49feb1){var _0x12e47a={};_0x12e47a[_0x49feb1]={'$like':'%'+_0x226c3b[_0x29f6('0x2b')][_0x29f6('0x39')]+'%'};return _0x12e47a;})});}_0x5506e8=_['merge']({},_0x5506e8,_0x226c3b['options']);return db['CmList'][_0x29f6('0x17')]({'where':_0x5506e8['where']})[_0x29f6('0x1d')](function(_0x5acbea){_0x318fd1[_0x29f6('0x17')]=_0x5acbea;if(_0x226c3b[_0x29f6('0x2b')][_0x29f6('0x3f')]){_0x5506e8[_0x29f6('0x3b')]=[{'all':!![]}];}return db[_0x29f6('0x5a')][_0x29f6('0x3c')](_0x5506e8);})[_0x29f6('0x1d')](function(_0x5731b3){_0x318fd1[_0x29f6('0x54')]=_0x5731b3;return _0x318fd1;});}})[_0x29f6('0x1d')](respondWithFilteredResult(_0x12d246,_0x5506e8))['catch'](handleError(_0x12d246,null));};exports[_0x29f6('0x7a')]=function(_0x15c86e,_0x43acdc,_0x28cc75){var _0x4e055b,_0x4ce645;return db[_0x29f6('0x27')][_0x29f6('0x40')]({'where':{'id':_0x15c86e[_0x29f6('0x3e')]['id']}})[_0x29f6('0x1d')](handleEntityNotFound(_0x43acdc,null))[_0x29f6('0x1d')](function(_0x5e7690){if(_0x5e7690){_0x4ce645=_0x5e7690;return _0x5e7690['addBlackLists'](_0x15c86e[_0x29f6('0x43')][_0x29f6('0x79')],_['omit'](_0x15c86e['body'],['ids','id'])||{});}return null;})[_0x29f6('0x5d')](function(_0x260dd1){var _0x117187;_0x4e055b=_0x260dd1||[];var _0xf37dfa=[];if(_0x260dd1){for(var _0x2b1808=0x0;_0x2b1808<_0x260dd1['length'];_0x2b1808+=0x1){var _0x394d24=_0x260dd1[_0x2b1808][_0x29f6('0x1f')]({'plain':!![]});_0x117187=squel[_0x29f6('0x7b')]()[_0x29f6('0x60')](_0x29f6('0x7c'))['fromQuery']([_0x29f6('0x63'),_0x29f6('0x69'),_0x29f6('0x6c'),_0x29f6('0x53'),_0x29f6('0x65'),_0x29f6('0x4a')],squel[_0x29f6('0x66')]()[_0x29f6('0x68')]('phone',_0x29f6('0x63'))[_0x29f6('0x68')]('id','ContactId')[_0x29f6('0x68')](_0x394d24[_0x29f6('0x6a')][_0x29f6('0x6b')](),'ListId')['field'](_0x15c86e['params']['id']['toString'](),_0x29f6('0x53'))[_0x29f6('0x68')](_0x29f6('0x67'),_0x29f6('0x65'))[_0x29f6('0x68')](_0x29f6('0x67'),_0x29f6('0x4a'))[_0x29f6('0x6d')](_0x29f6('0x6e'))[_0x29f6('0x37')]('deletedAt\x20IS\x20NULL')[_0x29f6('0x37')]('ListId\x20=\x20?',_0x394d24[_0x29f6('0x6a')][_0x29f6('0x6b')]())[_0x29f6('0x37')](_0x29f6('0x71')))[_0x29f6('0x6b')]();_0xf37dfa[_0x29f6('0x7d')](db[_0x29f6('0x76')][_0x29f6('0x2b')](_0x117187));}return BPromise[_0x29f6('0x77')](_0xf37dfa);}})['then'](function(){return _0x4e055b;})['then'](respondWithResult(_0x43acdc,null))[_0x29f6('0x41')](handleError(_0x43acdc,null));};exports['removeBlackLists']=function(_0xe8d96c,_0x43db84,_0x39a4f5){return db[_0x29f6('0x27')][_0x29f6('0x40')]({'where':{'id':_0xe8d96c['params']['id']}})[_0x29f6('0x1d')](handleEntityNotFound(_0x43db84,null))[_0x29f6('0x1d')](function(_0x110d71){if(_0x110d71){return _0x110d71[_0x29f6('0x7e')](_0xe8d96c[_0x29f6('0x2b')][_0x29f6('0x79')]);}})[_0x29f6('0x1d')](function(_0x44e960){if(_0x44e960){return db[_0x29f6('0x59')][_0x29f6('0x1e')]({'where':{'ListId':_0xe8d96c[_0x29f6('0x2b')]['ids'],'CampaignId':_0xe8d96c[_0x29f6('0x3e')]['id']}})['then'](function(){return _0x44e960;});}})[_0x29f6('0x1d')](respondWithStatusCode(_0x43db84,null))[_0x29f6('0x41')](handleError(_0x43db84,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff