7e1609925304de33d172f3e5898bce89b9e1a875
[motion2.git] / server / api / campaign / campaign.controller.js
1 // *************************************************************************
2 // *                                                                       *
3 // * xCALLY Motion -  The Omnichannel Contact Center                       *
4 // * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
5 // *                                                                       *
6 // *************************************************************************
7 // *                                                                       *
8 // * Email: info@xcally.com                                                *
9 // * Website: https://www.xcally.com                                       *
10 // *                                                                       *
11 // *************************************************************************
12 // *                                                                       *
13 // * The SOFTWARE PRODUCT is protected by copyright laws and international *
14 // * copyright treaties, as well as other intellectual property laws and   *
15 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
16 // *                                                                       *
17 // *************************************************************************
18 var _0x4517=['../../config/license/hardware','../../config/logger','api','../../config/license/util','sendStatus','status','undefined','limit','count','offset','Content-Range','json','apply','reject','update','then','destroy','get','IvrCampaigns','UserProfileResource','error','name','send','index','map','rawAttributes','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','filter','merge','type','VIRTUAL','options','Campaign','include','rows','catch','show','params','includeAll','find','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','user','UserProfileSection','userProfileId','autoAssociation','create','clone','omit','body','createdAt','updatedAt','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','getHoppers','findOne','CmHopper','pick','CampaignId','findAll','getHopperHistories','CmHopperHistory','CmHopperFinal','getHopperBlacks','CmHopperBlack','CmList','getLists','addLists','format','YYYY-MM-DD\x20HH:mm:ss','ids','dialCheckDuplicateType','insert','into','cm_hopper','fromQuery','phone','ContactId','ListId','select','field','NOW()','scheduledAt','CmListId','toString','from','cm_contacts','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','COALESCE(calleridnum,\x27\x27)','cm_hopper_final','CampaignId\x20=\x20?','onlyIfOpen','deletedAt\x20IS\x20NULL','COALESCE(phone,\x27\x27)','cm_hopper_additional_phones','cmHopperId','h.id','ci.item','ci.OrderBY','OrderBy','cm_contact_has_items','h.ContactId\x20=\x20ci.CmContactId','h.ListId\x20=\x20?','h.CampaignId=?','h.createdAt\x20=\x20?','sequelize','push','all','removeLists','getBlackLists','addBlackLists','removeBlackLists','rimraf','zip-dir','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch'];(function(_0x3050ca,_0x3e36b0){var _0x1eed1d=function(_0x195e8f){while(--_0x195e8f){_0x3050ca['push'](_0x3050ca['shift']());}};_0x1eed1d(++_0x3e36b0);}(_0x4517,0x112));var _0x7451=function(_0x17d25a,_0x425934){_0x17d25a=_0x17d25a-0x0;var _0x586944=_0x4517[_0x17d25a];return _0x586944;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x7451('0x0'));var zipdir=require(_0x7451('0x1'));var jsonpatch=require('fast-json-patch');var rp=require(_0x7451('0x2'));var moment=require(_0x7451('0x3'));var BPromise=require(_0x7451('0x4'));var Mustache=require(_0x7451('0x5'));var util=require(_0x7451('0x6'));var path=require(_0x7451('0x7'));var sox=require(_0x7451('0x8'));var csv=require(_0x7451('0x9'));var ejs=require(_0x7451('0xa'));var fs=require('fs');var fs_extra=require(_0x7451('0xb'));var _=require(_0x7451('0xc'));var squel=require(_0x7451('0xd'));var crypto=require(_0x7451('0xe'));var jsforce=require(_0x7451('0xf'));var deskjs=require(_0x7451('0x10'));var toCsv=require(_0x7451('0x9'));var querystring=require(_0x7451('0x11'));var Papa=require('papaparse');var Redis=require(_0x7451('0x12'));var authService=require(_0x7451('0x13'));var qs=require(_0x7451('0x14'));var as=require(_0x7451('0x15'));var hardwareService=require(_0x7451('0x16'));var logger=require(_0x7451('0x17'))(_0x7451('0x18'));var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require(_0x7451('0x19'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x450463,_0x2cb40b){_0x2cb40b=_0x2cb40b||0xcc;return function(_0x4a14dc){if(_0x4a14dc){return _0x450463[_0x7451('0x1a')](_0x2cb40b);}return _0x450463[_0x7451('0x1b')](_0x2cb40b)['end']();};}function respondWithResult(_0x46811e,_0x282128){_0x282128=_0x282128||0xc8;return function(_0x110ed6){if(_0x110ed6){return _0x46811e[_0x7451('0x1b')](_0x282128)['json'](_0x110ed6);}};}function respondWithFilteredResult(_0x357ea9,_0x313385){return function(_0x408336){if(_0x408336){var _0x58c0cd=typeof _0x313385['offset']===_0x7451('0x1c')&&typeof _0x313385[_0x7451('0x1d')]===_0x7451('0x1c');var _0xa8a121=_0x408336[_0x7451('0x1e')];var _0xd47ee4=_0x58c0cd?0x0:_0x313385[_0x7451('0x1f')];var _0x1120b1=_0x58c0cd?_0x408336[_0x7451('0x1e')]:_0x313385['offset']+_0x313385[_0x7451('0x1d')];var _0x32e250;if(_0x1120b1>=_0xa8a121){_0x1120b1=_0xa8a121;_0x32e250=0xc8;}else{_0x32e250=0xce;}_0x357ea9[_0x7451('0x1b')](_0x32e250);return _0x357ea9['set'](_0x7451('0x20'),_0xd47ee4+'-'+_0x1120b1+'/'+_0xa8a121)[_0x7451('0x21')](_0x408336);}return null;};}function patchUpdates(_0x3ffb08){return function(_0x3b5d59){try{jsonpatch[_0x7451('0x22')](_0x3b5d59,_0x3ffb08,!![]);}catch(_0x293e29){return BPromise[_0x7451('0x23')](_0x293e29);}return _0x3b5d59['save']();};}function saveUpdates(_0x3a0c1e,_0x309be0){return function(_0x561e12){if(_0x561e12){return _0x561e12[_0x7451('0x24')](_0x3a0c1e)[_0x7451('0x25')](function(_0x2962f8){return _0x2962f8;});}return null;};}function removeEntity(_0x57cc15,_0x19e33b){return function(_0x21dd67){if(_0x21dd67){return _0x21dd67[_0x7451('0x26')]()[_0x7451('0x25')](function(){var _0x37bc47=_0x21dd67[_0x7451('0x27')]({'plain':!![]});var _0x3c56f1=_0x7451('0x28');return db[_0x7451('0x29')]['destroy']({'where':{'type':_0x3c56f1,'resourceId':_0x37bc47['id']}})[_0x7451('0x25')](function(){return _0x21dd67;});})[_0x7451('0x25')](function(){_0x57cc15['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0xcc793e,_0x1edcf2){return function(_0x248d83){if(!_0x248d83){_0xcc793e[_0x7451('0x1a')](0x194);}return _0x248d83;};}function handleError(_0x30ef36,_0x19547e){_0x19547e=_0x19547e||0x1f4;return function(_0x4b5b26){logger[_0x7451('0x2a')](_0x4b5b26['stack']);if(_0x4b5b26[_0x7451('0x2b')]){delete _0x4b5b26[_0x7451('0x2b')];}_0x30ef36['status'](_0x19547e)[_0x7451('0x2c')](_0x4b5b26);};}exports[_0x7451('0x2d')]=function(_0x40b6c3,_0x3a397e){var _0x17d52c={},_0x4e24f7={},_0x2071e5={'count':0x0,'rows':[]};var _0x43d305=_[_0x7451('0x2e')](db['Campaign'][_0x7451('0x2f')],function(_0x4654e7){return{'name':_0x4654e7['fieldName'],'type':_0x4654e7['type'][_0x7451('0x30')]};});_0x4e24f7[_0x7451('0x31')]=_['map'](_0x43d305,'name');_0x4e24f7[_0x7451('0x32')]=_[_0x7451('0x33')](_0x40b6c3[_0x7451('0x32')]);_0x4e24f7[_0x7451('0x34')]=_[_0x7451('0x35')](_0x4e24f7[_0x7451('0x31')],_0x4e24f7[_0x7451('0x32')]);_0x17d52c[_0x7451('0x36')]=_['intersection'](_0x4e24f7[_0x7451('0x31')],qs[_0x7451('0x37')](_0x40b6c3['query'][_0x7451('0x37')]));_0x17d52c[_0x7451('0x36')]=_0x17d52c[_0x7451('0x36')][_0x7451('0x38')]?_0x17d52c[_0x7451('0x36')]:_0x4e24f7[_0x7451('0x31')];if(!_0x40b6c3['query'][_0x7451('0x39')](_0x7451('0x3a'))){_0x17d52c['limit']=qs[_0x7451('0x1d')](_0x40b6c3[_0x7451('0x32')]['limit']);_0x17d52c['offset']=qs['offset'](_0x40b6c3['query']['offset']);}_0x17d52c[_0x7451('0x3b')]=qs[_0x7451('0x3c')](_0x40b6c3[_0x7451('0x32')][_0x7451('0x3c')]);_0x17d52c[_0x7451('0x3d')]=qs['filters'](_['pick'](_0x40b6c3['query'],_0x4e24f7['filters']),_0x43d305);if(_0x40b6c3['query'][_0x7451('0x3e')]){_0x17d52c[_0x7451('0x3d')]=_[_0x7451('0x3f')](_0x17d52c[_0x7451('0x3d')],{'$or':_[_0x7451('0x2e')](_0x43d305,function(_0xfa0b5a){if(_0xfa0b5a[_0x7451('0x40')]!==_0x7451('0x41')){var _0x201d96={};_0x201d96[_0xfa0b5a[_0x7451('0x2b')]]={'$like':'%'+_0x40b6c3[_0x7451('0x32')]['filter']+'%'};return _0x201d96;}})});}_0x17d52c=_['merge']({},_0x17d52c,_0x40b6c3[_0x7451('0x42')]);var _0x57f1b2={'where':_0x17d52c[_0x7451('0x3d')]};return db[_0x7451('0x43')]['count'](_0x57f1b2)['then'](function(_0x1f5bf3){_0x2071e5['count']=_0x1f5bf3;if(_0x40b6c3[_0x7451('0x32')]['includeAll']){_0x17d52c[_0x7451('0x44')]=[{'all':!![]}];}return db[_0x7451('0x43')]['findAll'](_0x17d52c);})[_0x7451('0x25')](function(_0x4c326d){_0x2071e5[_0x7451('0x45')]=_0x4c326d;return _0x2071e5;})[_0x7451('0x25')](respondWithFilteredResult(_0x3a397e,_0x17d52c))[_0x7451('0x46')](handleError(_0x3a397e,null));};exports[_0x7451('0x47')]=function(_0x44e636,_0x1d2b1e){var _0x387279={'raw':![],'where':{'id':_0x44e636[_0x7451('0x48')]['id']}},_0x1fcae7={};_0x1fcae7[_0x7451('0x31')]=_[_0x7451('0x33')](db[_0x7451('0x43')][_0x7451('0x2f')]);_0x1fcae7[_0x7451('0x32')]=_['keys'](_0x44e636[_0x7451('0x32')]);_0x1fcae7[_0x7451('0x34')]=_[_0x7451('0x35')](_0x1fcae7[_0x7451('0x31')],_0x1fcae7['query']);_0x387279[_0x7451('0x36')]=_['intersection'](_0x1fcae7['model'],qs['fields'](_0x44e636['query']['fields']));_0x387279[_0x7451('0x36')]=_0x387279[_0x7451('0x36')][_0x7451('0x38')]?_0x387279['attributes']:_0x1fcae7[_0x7451('0x31')];if(_0x44e636[_0x7451('0x32')][_0x7451('0x49')]){_0x387279[_0x7451('0x44')]=[{'all':!![]}];}_0x387279=_[_0x7451('0x3f')]({},_0x387279,_0x44e636[_0x7451('0x42')]);return db[_0x7451('0x43')][_0x7451('0x4a')](_0x387279)[_0x7451('0x25')](handleEntityNotFound(_0x1d2b1e,null))['then'](respondWithResult(_0x1d2b1e,null))['catch'](handleError(_0x1d2b1e,null));};exports['create']=function(_0xd26beb,_0x3acf1d){return db[_0x7451('0x43')]['create'](_0xd26beb['body'],{})['then'](function(_0x7c23ad){var _0x55761d=_0xd26beb['user'][_0x7451('0x27')]({'plain':!![]});if(!_0x55761d)throw new Error(_0x7451('0x4b'));if(_0x55761d[_0x7451('0x4c')]===_0x7451('0x4d')){var _0x24e028=_0x7c23ad['get']({'plain':!![]});var _0x2d39f0='IvrCampaigns';return db[_0x7451('0x4e')][_0x7451('0x4a')]({'where':{'name':_0x2d39f0,'userProfileId':_0x55761d[_0x7451('0x4f')]},'raw':!![]})[_0x7451('0x25')](function(_0x123d8f){if(_0x123d8f&&_0x123d8f[_0x7451('0x50')]===0x0){return db[_0x7451('0x29')][_0x7451('0x51')]({'name':_0x24e028[_0x7451('0x2b')],'resourceId':_0x24e028['id'],'type':_0x123d8f['name'],'sectionId':_0x123d8f['id']},{})['then'](function(){return _0x7c23ad;});}else{return _0x7c23ad;}})[_0x7451('0x46')](function(_0x94f802){logger['error']('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x94f802);throw _0x94f802;});}return _0x7c23ad;})['then'](respondWithResult(_0x3acf1d,0xc9))[_0x7451('0x46')](handleError(_0x3acf1d,null));};exports[_0x7451('0x52')]=function(_0x454a88,_0x22c4db){var _0x2e4f1f={'where':{'id':_0x454a88['params']['id']}},_0x9f5737={};_0x9f5737[_0x7451('0x31')]=_['keys'](db['Campaign']['rawAttributes']);_0x2e4f1f[_0x7451('0x36')]=_[_0x7451('0x35')](_0x9f5737[_0x7451('0x31')],qs[_0x7451('0x37')](_0x454a88[_0x7451('0x32')][_0x7451('0x37')]));_0x2e4f1f[_0x7451('0x36')]=_0x2e4f1f['attributes'][_0x7451('0x38')]?_0x2e4f1f[_0x7451('0x36')]:_0x9f5737[_0x7451('0x31')];if(_0x454a88[_0x7451('0x32')][_0x7451('0x49')]){_0x2e4f1f[_0x7451('0x44')]=[{'all':!![]}];}_0x2e4f1f=_[_0x7451('0x3f')]({},_0x2e4f1f,_0x454a88['options']);return db[_0x7451('0x43')][_0x7451('0x4a')](_0x2e4f1f)[_0x7451('0x25')](handleEntityNotFound(_0x22c4db,null))[_0x7451('0x25')](function(_0x2d2150){if(_0x2d2150){var _0x381d34=_0x2d2150['get']({'plain':!![]});_0x381d34=qs[_0x7451('0x53')](_0x381d34,['id','createdAt','updatedAt']);_0x454a88[_0x7451('0x54')]=_[_0x7451('0x53')](_0x454a88[_0x7451('0x54')],['id',_0x7451('0x55'),_0x7451('0x56')]);return db[_0x7451('0x43')]['create'](_[_0x7451('0x3f')](_0x381d34,_0x454a88['body']),{'include':_0x454a88[_0x7451('0x32')][_0x7451('0x49')]?[{'all':!![]}]:undefined})['then'](function(_0x4ec362){var _0x4d9bfa=_0x454a88['user'][_0x7451('0x27')]({'plain':!![]});if(!_0x4d9bfa)throw new Error(_0x7451('0x4b'));if(_0x4d9bfa[_0x7451('0x4c')]===_0x7451('0x4d')){var _0x1ba928=_0x4ec362[_0x7451('0x27')]({'plain':!![]});var _0x47a038=_0x7451('0x28');return db['UserProfileSection'][_0x7451('0x4a')]({'where':{'name':_0x47a038,'userProfileId':_0x4d9bfa[_0x7451('0x4f')]},'raw':!![]})[_0x7451('0x25')](function(_0x518f9c){if(_0x518f9c&&_0x518f9c['autoAssociation']===0x0){return db[_0x7451('0x29')][_0x7451('0x51')]({'name':_0x1ba928[_0x7451('0x2b')],'resourceId':_0x1ba928['id'],'type':_0x518f9c[_0x7451('0x2b')],'sectionId':_0x518f9c['id']},{})[_0x7451('0x25')](function(){return _0x4ec362;});}else{return _0x4ec362;}})[_0x7451('0x46')](function(_0x248c6c){logger[_0x7451('0x2a')](_0x7451('0x57'),_0x248c6c);throw _0x248c6c;});}return _0x4ec362;});}})[_0x7451('0x25')](respondWithResult(_0x22c4db,0xc9))['catch'](handleError(_0x22c4db,null));};exports['update']=function(_0x309b9b,_0x20ebb3){if(_0x309b9b[_0x7451('0x54')]['id']){delete _0x309b9b['body']['id'];}return db[_0x7451('0x43')][_0x7451('0x4a')]({'where':{'id':_0x309b9b[_0x7451('0x48')]['id']}})['then'](handleEntityNotFound(_0x20ebb3,null))[_0x7451('0x25')](saveUpdates(_0x309b9b[_0x7451('0x54')],null))['then'](respondWithResult(_0x20ebb3,null))['catch'](handleError(_0x20ebb3,null));};exports[_0x7451('0x26')]=function(_0x373ad2,_0x55d485){return db[_0x7451('0x43')][_0x7451('0x4a')]({'where':{'id':_0x373ad2['params']['id']}})['then'](handleEntityNotFound(_0x55d485,null))['then'](removeEntity(_0x55d485,null))[_0x7451('0x46')](handleError(_0x55d485,null));};exports[_0x7451('0x58')]=function(_0x2021c7,_0x1a6666,_0xf0dd25){var _0x37ed5e={'raw':!![],'where':{}};var _0xd2f69e={};var _0x1158b4={'count':0x0,'rows':[]};return db[_0x7451('0x43')][_0x7451('0x59')]({'where':{'id':_0x2021c7[_0x7451('0x48')]['id']}})[_0x7451('0x25')](handleEntityNotFound(_0x1a6666,null))[_0x7451('0x25')](function(_0x5116fa){if(_0x5116fa){_0xd2f69e[_0x7451('0x31')]=_[_0x7451('0x33')](db[_0x7451('0x5a')][_0x7451('0x2f')]);_0xd2f69e['query']=_[_0x7451('0x33')](_0x2021c7['query']);_0xd2f69e['filters']=_[_0x7451('0x35')](_0xd2f69e[_0x7451('0x31')],_0xd2f69e['query']);_0x37ed5e[_0x7451('0x36')]=_['intersection'](_0xd2f69e[_0x7451('0x31')],qs[_0x7451('0x37')](_0x2021c7[_0x7451('0x32')][_0x7451('0x37')]));_0x37ed5e[_0x7451('0x36')]=_0x37ed5e[_0x7451('0x36')][_0x7451('0x38')]?_0x37ed5e['attributes']:_0xd2f69e['model'];if(!_0x2021c7['query'][_0x7451('0x39')](_0x7451('0x3a'))){_0x37ed5e[_0x7451('0x1d')]=qs[_0x7451('0x1d')](_0x2021c7[_0x7451('0x32')][_0x7451('0x1d')]);_0x37ed5e['offset']=qs['offset'](_0x2021c7[_0x7451('0x32')][_0x7451('0x1f')]);}_0x37ed5e[_0x7451('0x3b')]=qs['sort'](_0x2021c7[_0x7451('0x32')][_0x7451('0x3c')]);_0x37ed5e['where']=qs['filters'](_[_0x7451('0x5b')](_0x2021c7[_0x7451('0x32')],_0xd2f69e[_0x7451('0x34')]));_0x37ed5e[_0x7451('0x3d')][_0x7451('0x5c')]=_0x5116fa['id'];if(_0x2021c7[_0x7451('0x32')][_0x7451('0x3e')]){_0x37ed5e[_0x7451('0x3d')]=_[_0x7451('0x3f')](_0x37ed5e[_0x7451('0x3d')],{'$or':_[_0x7451('0x2e')](_0x37ed5e['attributes'],function(_0x591a81){var _0x4f7641={};_0x4f7641[_0x591a81]={'$like':'%'+_0x2021c7[_0x7451('0x32')][_0x7451('0x3e')]+'%'};return _0x4f7641;})});}_0x37ed5e=_['merge']({},_0x37ed5e,_0x2021c7[_0x7451('0x42')]);return db[_0x7451('0x5a')][_0x7451('0x1e')]({'where':_0x37ed5e[_0x7451('0x3d')]})[_0x7451('0x25')](function(_0x27af89){_0x1158b4[_0x7451('0x1e')]=_0x27af89;if(_0x2021c7[_0x7451('0x32')][_0x7451('0x49')]){_0x37ed5e[_0x7451('0x44')]=[{'all':!![]}];}return db['CmHopper'][_0x7451('0x5d')](_0x37ed5e);})[_0x7451('0x25')](function(_0x51a7ed){_0x1158b4['rows']=_0x51a7ed;return _0x1158b4;});}})['then'](respondWithFilteredResult(_0x1a6666,_0x37ed5e))['catch'](handleError(_0x1a6666,null));};exports[_0x7451('0x5e')]=function(_0x5f850e,_0x2cb5e3,_0x57453e){var _0x360555={'raw':!![],'where':{}};var _0x39d146={};var _0x5e28aa={'count':0x0,'rows':[]};return db[_0x7451('0x43')][_0x7451('0x59')]({'where':{'id':_0x5f850e[_0x7451('0x48')]['id']}})[_0x7451('0x25')](handleEntityNotFound(_0x2cb5e3,null))[_0x7451('0x25')](function(_0x1fea7e){if(_0x1fea7e){_0x39d146[_0x7451('0x31')]=_[_0x7451('0x33')](db[_0x7451('0x5f')][_0x7451('0x2f')]);_0x39d146[_0x7451('0x32')]=_[_0x7451('0x33')](_0x5f850e[_0x7451('0x32')]);_0x39d146[_0x7451('0x34')]=_['intersection'](_0x39d146[_0x7451('0x31')],_0x39d146[_0x7451('0x32')]);_0x360555[_0x7451('0x36')]=_[_0x7451('0x35')](_0x39d146[_0x7451('0x31')],qs[_0x7451('0x37')](_0x5f850e['query'][_0x7451('0x37')]));_0x360555[_0x7451('0x36')]=_0x360555[_0x7451('0x36')]['length']?_0x360555[_0x7451('0x36')]:_0x39d146['model'];if(!_0x5f850e[_0x7451('0x32')]['hasOwnProperty'](_0x7451('0x3a'))){_0x360555[_0x7451('0x1d')]=qs['limit'](_0x5f850e[_0x7451('0x32')]['limit']);_0x360555[_0x7451('0x1f')]=qs[_0x7451('0x1f')](_0x5f850e['query'][_0x7451('0x1f')]);}_0x360555[_0x7451('0x3b')]=qs[_0x7451('0x3c')](_0x5f850e[_0x7451('0x32')][_0x7451('0x3c')]);_0x360555[_0x7451('0x3d')]=qs['filters'](_[_0x7451('0x5b')](_0x5f850e[_0x7451('0x32')],_0x39d146[_0x7451('0x34')]));_0x360555[_0x7451('0x3d')][_0x7451('0x5c')]=_0x1fea7e['id'];if(_0x5f850e[_0x7451('0x32')][_0x7451('0x3e')]){_0x360555[_0x7451('0x3d')]=_[_0x7451('0x3f')](_0x360555[_0x7451('0x3d')],{'$or':_['map'](_0x360555[_0x7451('0x36')],function(_0x45b532){var _0x55c63d={};_0x55c63d[_0x45b532]={'$like':'%'+_0x5f850e['query'][_0x7451('0x3e')]+'%'};return _0x55c63d;})});}_0x360555=_[_0x7451('0x3f')]({},_0x360555,_0x5f850e['options']);return db['CmHopperHistory']['count']({'where':_0x360555[_0x7451('0x3d')]})[_0x7451('0x25')](function(_0x34c76d){_0x5e28aa[_0x7451('0x1e')]=_0x34c76d;if(_0x5f850e[_0x7451('0x32')][_0x7451('0x49')]){_0x360555[_0x7451('0x44')]=[{'all':!![]}];}return db['CmHopperHistory'][_0x7451('0x5d')](_0x360555);})[_0x7451('0x25')](function(_0x49fb7e){_0x5e28aa[_0x7451('0x45')]=_0x49fb7e;return _0x5e28aa;});}})['then'](respondWithFilteredResult(_0x2cb5e3,_0x360555))[_0x7451('0x46')](handleError(_0x2cb5e3,null));};exports['getHopperFinals']=function(_0x46074c,_0x31c753,_0x253b7f){var _0x36ecae={'raw':!![],'where':{}};var _0x1ce8c1={};var _0x4c6695={'count':0x0,'rows':[]};return db[_0x7451('0x43')][_0x7451('0x59')]({'where':{'id':_0x46074c[_0x7451('0x48')]['id']}})[_0x7451('0x25')](handleEntityNotFound(_0x31c753,null))['then'](function(_0x4c27a9){if(_0x4c27a9){_0x1ce8c1[_0x7451('0x31')]=_[_0x7451('0x33')](db[_0x7451('0x60')][_0x7451('0x2f')]);_0x1ce8c1['query']=_[_0x7451('0x33')](_0x46074c[_0x7451('0x32')]);_0x1ce8c1[_0x7451('0x34')]=_[_0x7451('0x35')](_0x1ce8c1[_0x7451('0x31')],_0x1ce8c1[_0x7451('0x32')]);_0x36ecae[_0x7451('0x36')]=_[_0x7451('0x35')](_0x1ce8c1[_0x7451('0x31')],qs['fields'](_0x46074c['query']['fields']));_0x36ecae['attributes']=_0x36ecae[_0x7451('0x36')]['length']?_0x36ecae[_0x7451('0x36')]:_0x1ce8c1['model'];if(!_0x46074c['query'][_0x7451('0x39')](_0x7451('0x3a'))){_0x36ecae[_0x7451('0x1d')]=qs[_0x7451('0x1d')](_0x46074c['query'][_0x7451('0x1d')]);_0x36ecae[_0x7451('0x1f')]=qs[_0x7451('0x1f')](_0x46074c['query'][_0x7451('0x1f')]);}_0x36ecae[_0x7451('0x3b')]=qs[_0x7451('0x3c')](_0x46074c['query']['sort']);_0x36ecae['where']=qs[_0x7451('0x34')](_[_0x7451('0x5b')](_0x46074c[_0x7451('0x32')],_0x1ce8c1[_0x7451('0x34')]));_0x36ecae['where'][_0x7451('0x5c')]=_0x4c27a9['id'];if(_0x46074c['query'][_0x7451('0x3e')]){_0x36ecae['where']=_[_0x7451('0x3f')](_0x36ecae[_0x7451('0x3d')],{'$or':_[_0x7451('0x2e')](_0x36ecae[_0x7451('0x36')],function(_0x40e431){var _0x599357={};_0x599357[_0x40e431]={'$like':'%'+_0x46074c[_0x7451('0x32')][_0x7451('0x3e')]+'%'};return _0x599357;})});}_0x36ecae=_[_0x7451('0x3f')]({},_0x36ecae,_0x46074c[_0x7451('0x42')]);return db[_0x7451('0x60')]['count']({'where':_0x36ecae[_0x7451('0x3d')]})['then'](function(_0x621325){_0x4c6695[_0x7451('0x1e')]=_0x621325;if(_0x46074c[_0x7451('0x32')][_0x7451('0x49')]){_0x36ecae[_0x7451('0x44')]=[{'all':!![]}];}return db[_0x7451('0x60')][_0x7451('0x5d')](_0x36ecae);})[_0x7451('0x25')](function(_0x4c5b20){_0x4c6695[_0x7451('0x45')]=_0x4c5b20;return _0x4c6695;});}})[_0x7451('0x25')](respondWithFilteredResult(_0x31c753,_0x36ecae))[_0x7451('0x46')](handleError(_0x31c753,null));};exports[_0x7451('0x61')]=function(_0x499cca,_0x3b9f9c,_0x2d43aa){var _0x2d2cdc={'raw':!![],'where':{}};var _0x29f5f1={};var _0x20cc38={'count':0x0,'rows':[]};return db[_0x7451('0x43')][_0x7451('0x59')]({'where':{'id':_0x499cca[_0x7451('0x48')]['id']}})[_0x7451('0x25')](handleEntityNotFound(_0x3b9f9c,null))[_0x7451('0x25')](function(_0x3218b7){if(_0x3218b7){_0x29f5f1[_0x7451('0x31')]=_[_0x7451('0x33')](db[_0x7451('0x62')][_0x7451('0x2f')]);_0x29f5f1[_0x7451('0x32')]=_[_0x7451('0x33')](_0x499cca[_0x7451('0x32')]);_0x29f5f1[_0x7451('0x34')]=_[_0x7451('0x35')](_0x29f5f1[_0x7451('0x31')],_0x29f5f1[_0x7451('0x32')]);_0x2d2cdc[_0x7451('0x36')]=_[_0x7451('0x35')](_0x29f5f1[_0x7451('0x31')],qs[_0x7451('0x37')](_0x499cca[_0x7451('0x32')][_0x7451('0x37')]));_0x2d2cdc[_0x7451('0x36')]=_0x2d2cdc['attributes']['length']?_0x2d2cdc[_0x7451('0x36')]:_0x29f5f1[_0x7451('0x31')];if(!_0x499cca[_0x7451('0x32')][_0x7451('0x39')](_0x7451('0x3a'))){_0x2d2cdc[_0x7451('0x1d')]=qs['limit'](_0x499cca[_0x7451('0x32')][_0x7451('0x1d')]);_0x2d2cdc[_0x7451('0x1f')]=qs['offset'](_0x499cca[_0x7451('0x32')][_0x7451('0x1f')]);}_0x2d2cdc[_0x7451('0x3b')]=qs[_0x7451('0x3c')](_0x499cca[_0x7451('0x32')][_0x7451('0x3c')]);_0x2d2cdc[_0x7451('0x3d')]=qs[_0x7451('0x34')](_[_0x7451('0x5b')](_0x499cca[_0x7451('0x32')],_0x29f5f1['filters']));_0x2d2cdc['where']['CampaignId']=_0x3218b7['id'];if(_0x499cca[_0x7451('0x32')][_0x7451('0x3e')]){_0x2d2cdc['where']=_[_0x7451('0x3f')](_0x2d2cdc[_0x7451('0x3d')],{'$or':_[_0x7451('0x2e')](_0x2d2cdc[_0x7451('0x36')],function(_0x4dc291){var _0x7d613d={};_0x7d613d[_0x4dc291]={'$like':'%'+_0x499cca[_0x7451('0x32')]['filter']+'%'};return _0x7d613d;})});}_0x2d2cdc=_[_0x7451('0x3f')]({},_0x2d2cdc,_0x499cca[_0x7451('0x42')]);return db[_0x7451('0x62')][_0x7451('0x1e')]({'where':_0x2d2cdc[_0x7451('0x3d')]})[_0x7451('0x25')](function(_0x4b610){_0x20cc38[_0x7451('0x1e')]=_0x4b610;if(_0x499cca[_0x7451('0x32')]['includeAll']){_0x2d2cdc[_0x7451('0x44')]=[{'all':!![]}];}return db[_0x7451('0x62')][_0x7451('0x5d')](_0x2d2cdc);})['then'](function(_0xea53d4){_0x20cc38[_0x7451('0x45')]=_0xea53d4;return _0x20cc38;});}})[_0x7451('0x25')](respondWithFilteredResult(_0x3b9f9c,_0x2d2cdc))[_0x7451('0x46')](handleError(_0x3b9f9c,null));};exports['getLists']=function(_0x3d0309,_0x338263,_0x432390){var _0x21b79f={};var _0x3d5e5d={};var _0x5452ec;var _0x59ca2a;return db['Campaign']['findOne']({'where':{'id':_0x3d0309[_0x7451('0x48')]['id']}})[_0x7451('0x25')](handleEntityNotFound(_0x338263,null))['then'](function(_0x4fc914){if(_0x4fc914){_0x5452ec=_0x4fc914;_0x3d5e5d[_0x7451('0x31')]=_[_0x7451('0x33')](db[_0x7451('0x63')]['rawAttributes']);_0x3d5e5d['query']=_[_0x7451('0x33')](_0x3d0309[_0x7451('0x32')]);_0x3d5e5d[_0x7451('0x34')]=_[_0x7451('0x35')](_0x3d5e5d['model'],_0x3d5e5d[_0x7451('0x32')]);_0x21b79f['attributes']=_['intersection'](_0x3d5e5d['model'],qs['fields'](_0x3d0309[_0x7451('0x32')]['fields']));_0x21b79f['attributes']=_0x21b79f[_0x7451('0x36')][_0x7451('0x38')]?_0x21b79f[_0x7451('0x36')]:_0x3d5e5d[_0x7451('0x31')];_0x21b79f[_0x7451('0x3b')]=qs[_0x7451('0x3c')](_0x3d0309[_0x7451('0x32')][_0x7451('0x3c')]);_0x21b79f[_0x7451('0x3d')]=qs[_0x7451('0x34')](_[_0x7451('0x5b')](_0x3d0309['query'],_0x3d5e5d['filters']));if(_0x3d0309[_0x7451('0x32')][_0x7451('0x3e')]){_0x21b79f[_0x7451('0x3d')]=_['merge'](_0x21b79f[_0x7451('0x3d')],{'$or':_[_0x7451('0x2e')](_0x21b79f[_0x7451('0x36')],function(_0x41424c){var _0x2a0a97={};_0x2a0a97[_0x41424c]={'$like':'%'+_0x3d0309[_0x7451('0x32')][_0x7451('0x3e')]+'%'};return _0x2a0a97;})});}_0x21b79f=_['merge']({},_0x21b79f,_0x3d0309[_0x7451('0x42')]);return _0x5452ec[_0x7451('0x64')](_0x21b79f);}})[_0x7451('0x25')](function(_0x474092){if(_0x474092){_0x59ca2a=_0x474092[_0x7451('0x38')];if(!_0x3d0309[_0x7451('0x32')][_0x7451('0x39')]('nolimit')){_0x21b79f[_0x7451('0x1d')]=qs[_0x7451('0x1d')](_0x3d0309[_0x7451('0x32')][_0x7451('0x1d')]);_0x21b79f[_0x7451('0x1f')]=qs['offset'](_0x3d0309[_0x7451('0x32')][_0x7451('0x1f')]);}return _0x5452ec[_0x7451('0x64')](_0x21b79f);}})['then'](function(_0x2e1d8b){if(_0x2e1d8b){return _0x2e1d8b?{'count':_0x59ca2a,'rows':_0x2e1d8b}:null;}})[_0x7451('0x25')](respondWithResult(_0x338263,null))[_0x7451('0x46')](handleError(_0x338263,null));};exports[_0x7451('0x65')]=function(_0x2c632c,_0x197cc6,_0xf62a85){var _0x3a6fae,_0x29d420;var _0x33e344=[];var _0x5c7fa9=moment()[_0x7451('0x66')](_0x7451('0x67'));return db[_0x7451('0x43')]['find']({'where':{'id':_0x2c632c['params']['id']}})[_0x7451('0x25')](handleEntityNotFound(_0x197cc6,null))['then'](function(_0x4672de){if(_0x4672de){_0x29d420=_0x4672de;return _0x4672de[_0x7451('0x65')](_0x2c632c['body'][_0x7451('0x68')],_[_0x7451('0x53')](_0x2c632c[_0x7451('0x54')],['ids','id'])||{});}return null;})['spread'](function(_0x107182){var _0x4eda52;var _0x55adac;_0x3a6fae=_0x107182||[];var _0x230956=[];if(_0x107182){for(var _0x1ee97f=0x0;_0x1ee97f<_0x107182[_0x7451('0x38')];_0x1ee97f+=0x1){var _0xf184f3=_0x107182[_0x1ee97f]['get']({'plain':!![]});_0x29d420[_0x7451('0x69')]=_0x2c632c[_0x7451('0x54')]['dialCheckDuplicateType']?_0x2c632c[_0x7451('0x54')][_0x7451('0x69')]:_0x29d420['dialCheckDuplicateType'];switch(_0x29d420[_0x7451('0x69')]){case'always':_0x4eda52=squel[_0x7451('0x6a')]()[_0x7451('0x6b')](_0x7451('0x6c'))[_0x7451('0x6d')]([_0x7451('0x6e'),'scheduledAt',_0x7451('0x6f'),_0x7451('0x70'),'CampaignId',_0x7451('0x55'),_0x7451('0x56')],squel[_0x7451('0x71')]()[_0x7451('0x72')](_0x7451('0x6e'),_0x7451('0x6e'))[_0x7451('0x72')](_0x7451('0x73'),_0x7451('0x74'))[_0x7451('0x72')]('id',_0x7451('0x6f'))[_0x7451('0x72')](_0xf184f3[_0x7451('0x75')][_0x7451('0x76')](),_0x7451('0x70'))['field'](_0x2c632c['params']['id'][_0x7451('0x76')](),_0x7451('0x5c'))[_0x7451('0x72')]('\x27'+_0x5c7fa9+'\x27',_0x7451('0x55'))[_0x7451('0x72')]('\x27'+_0x5c7fa9+'\x27',_0x7451('0x56'))[_0x7451('0x77')](_0x7451('0x78'))[_0x7451('0x3d')]('deletedAt\x20IS\x20NULL')['where'](_0x7451('0x79'),_0xf184f3['CmListId']['toString']())[_0x7451('0x3d')](_0x7451('0x7a'))[_0x7451('0x3d')](_0x7451('0x7b'),squel['select']()[_0x7451('0x72')](_0x7451('0x7c'))['from'](_0x7451('0x7d'))[_0x7451('0x3d')](_0x7451('0x7e'),_0x2c632c[_0x7451('0x48')]['id'][_0x7451('0x76')]()))[_0x7451('0x3d')](_0x7451('0x7b'),squel[_0x7451('0x71')]()[_0x7451('0x72')]('COALESCE(phone,\x27\x27)')['from'](_0x7451('0x6c'))['where']('CampaignId\x20=\x20?',_0x2c632c[_0x7451('0x48')]['id'][_0x7451('0x76')]())))[_0x7451('0x76')]();break;case _0x7451('0x7f'):_0x4eda52=squel[_0x7451('0x6a')]()[_0x7451('0x6b')](_0x7451('0x6c'))[_0x7451('0x6d')]([_0x7451('0x6e'),_0x7451('0x74'),_0x7451('0x6f'),_0x7451('0x70'),'CampaignId',_0x7451('0x55'),_0x7451('0x56')],squel['select']()[_0x7451('0x72')]('phone',_0x7451('0x6e'))[_0x7451('0x72')]('NOW()','scheduledAt')['field']('id',_0x7451('0x6f'))[_0x7451('0x72')](_0xf184f3['CmListId'][_0x7451('0x76')](),'ListId')[_0x7451('0x72')](_0x2c632c[_0x7451('0x48')]['id'][_0x7451('0x76')](),_0x7451('0x5c'))[_0x7451('0x72')]('\x27'+_0x5c7fa9+'\x27',_0x7451('0x55'))[_0x7451('0x72')]('\x27'+_0x5c7fa9+'\x27','updatedAt')['from'](_0x7451('0x78'))[_0x7451('0x3d')](_0x7451('0x80'))[_0x7451('0x3d')](_0x7451('0x79'),_0xf184f3[_0x7451('0x75')][_0x7451('0x76')]())[_0x7451('0x3d')](_0x7451('0x7a'))[_0x7451('0x3d')](_0x7451('0x7b'),squel['select']()[_0x7451('0x72')](_0x7451('0x81'))[_0x7451('0x77')](_0x7451('0x6c'))[_0x7451('0x3d')](_0x7451('0x7e'),_0x2c632c['params']['id']['toString']())))[_0x7451('0x76')]();break;default:_0x4eda52=squel[_0x7451('0x6a')]()[_0x7451('0x6b')](_0x7451('0x6c'))[_0x7451('0x6d')]([_0x7451('0x6e'),'scheduledAt',_0x7451('0x6f'),_0x7451('0x70'),_0x7451('0x5c'),_0x7451('0x55'),_0x7451('0x56')],squel[_0x7451('0x71')]()[_0x7451('0x72')](_0x7451('0x6e'),_0x7451('0x6e'))[_0x7451('0x72')](_0x7451('0x73'),_0x7451('0x74'))[_0x7451('0x72')]('id','ContactId')[_0x7451('0x72')](_0xf184f3['CmListId'][_0x7451('0x76')](),_0x7451('0x70'))['field'](_0x2c632c[_0x7451('0x48')]['id']['toString'](),_0x7451('0x5c'))[_0x7451('0x72')]('\x27'+_0x5c7fa9+'\x27','createdAt')['field']('\x27'+_0x5c7fa9+'\x27','updatedAt')['from'](_0x7451('0x78'))['where'](_0x7451('0x80'))[_0x7451('0x3d')]('ListId\x20=\x20?',_0xf184f3[_0x7451('0x75')][_0x7451('0x76')]())['where'](_0x7451('0x7a')))[_0x7451('0x76')]();}_0x55adac=squel['insert']()['into'](_0x7451('0x82'))['fromQuery']([_0x7451('0x83'),_0x7451('0x74'),_0x7451('0x6e'),'OrderBy',_0x7451('0x55'),_0x7451('0x56')],squel[_0x7451('0x71')]()[_0x7451('0x72')](_0x7451('0x84'),'id')['field'](_0x7451('0x73'),_0x7451('0x74'))[_0x7451('0x72')](_0x7451('0x85'),_0x7451('0x6e'))[_0x7451('0x72')](_0x7451('0x86'),_0x7451('0x87'))[_0x7451('0x72')]('\x27'+_0x5c7fa9+'\x27',_0x7451('0x55'))[_0x7451('0x72')]('\x27'+_0x5c7fa9+'\x27','updatedAt')[_0x7451('0x77')](_0x7451('0x88'),'ci')['join'](_0x7451('0x6c'),'h',_0x7451('0x89'))[_0x7451('0x3d')](_0x7451('0x8a'),_0xf184f3[_0x7451('0x75')][_0x7451('0x76')]())[_0x7451('0x3d')](_0x7451('0x8b'),_0x2c632c['params']['id'][_0x7451('0x76')]())['where'](_0x7451('0x8c'),_0x5c7fa9))[_0x7451('0x76')]();_0x230956['push'](db[_0x7451('0x8d')][_0x7451('0x32')](_0x4eda52));_0x33e344[_0x7451('0x8e')](db[_0x7451('0x8d')]['query'](_0x55adac));}return BPromise[_0x7451('0x8f')](_0x230956);}})[_0x7451('0x25')](function(){return BPromise[_0x7451('0x8f')](_0x33e344);})[_0x7451('0x25')](function(){return _0x3a6fae;})['then'](respondWithResult(_0x197cc6,null))[_0x7451('0x46')](handleError(_0x197cc6,null));};exports[_0x7451('0x90')]=function(_0x20b2cf,_0x498083,_0x4c32d9){return db['Campaign'][_0x7451('0x4a')]({'where':{'id':_0x20b2cf[_0x7451('0x48')]['id']}})[_0x7451('0x25')](handleEntityNotFound(_0x498083,null))[_0x7451('0x25')](function(_0x15eb6d){if(_0x15eb6d){return _0x15eb6d[_0x7451('0x90')](_0x20b2cf[_0x7451('0x32')][_0x7451('0x68')]);}})[_0x7451('0x25')](function(_0x5881ec){if(_0x5881ec){return db[_0x7451('0x5a')][_0x7451('0x26')]({'where':{'ListId':_0x20b2cf['query'][_0x7451('0x68')],'CampaignId':_0x20b2cf[_0x7451('0x48')]['id']}})[_0x7451('0x25')](function(){return _0x5881ec;});}})['then'](respondWithStatusCode(_0x498083,null))[_0x7451('0x46')](handleError(_0x498083,null));};exports[_0x7451('0x91')]=function(_0x21c831,_0x5af9d3,_0x59049f){var _0x31c337={};var _0x2d6932={};var _0x425d85;var _0x2ec2bd;return db[_0x7451('0x43')][_0x7451('0x59')]({'where':{'id':_0x21c831['params']['id']}})[_0x7451('0x25')](handleEntityNotFound(_0x5af9d3,null))['then'](function(_0x1c7e3c){if(_0x1c7e3c){_0x425d85=_0x1c7e3c;_0x2d6932['model']=_[_0x7451('0x33')](db[_0x7451('0x63')][_0x7451('0x2f')]);_0x2d6932[_0x7451('0x32')]=_['keys'](_0x21c831[_0x7451('0x32')]);_0x2d6932['filters']=_['intersection'](_0x2d6932['model'],_0x2d6932['query']);_0x31c337[_0x7451('0x36')]=_[_0x7451('0x35')](_0x2d6932['model'],qs['fields'](_0x21c831[_0x7451('0x32')][_0x7451('0x37')]));_0x31c337[_0x7451('0x36')]=_0x31c337[_0x7451('0x36')][_0x7451('0x38')]?_0x31c337[_0x7451('0x36')]:_0x2d6932[_0x7451('0x31')];_0x31c337[_0x7451('0x3b')]=qs[_0x7451('0x3c')](_0x21c831['query'][_0x7451('0x3c')]);_0x31c337[_0x7451('0x3d')]=qs[_0x7451('0x34')](_[_0x7451('0x5b')](_0x21c831['query'],_0x2d6932[_0x7451('0x34')]));if(_0x21c831[_0x7451('0x32')][_0x7451('0x3e')]){_0x31c337['where']=_[_0x7451('0x3f')](_0x31c337['where'],{'$or':_[_0x7451('0x2e')](_0x31c337[_0x7451('0x36')],function(_0x246d10){var _0x2598cb={};_0x2598cb[_0x246d10]={'$like':'%'+_0x21c831['query'][_0x7451('0x3e')]+'%'};return _0x2598cb;})});}_0x31c337=_[_0x7451('0x3f')]({},_0x31c337,_0x21c831[_0x7451('0x42')]);return _0x425d85[_0x7451('0x91')](_0x31c337);}})[_0x7451('0x25')](function(_0x563bf4){if(_0x563bf4){_0x2ec2bd=_0x563bf4['length'];if(!_0x21c831[_0x7451('0x32')][_0x7451('0x39')](_0x7451('0x3a'))){_0x31c337['limit']=qs['limit'](_0x21c831[_0x7451('0x32')][_0x7451('0x1d')]);_0x31c337[_0x7451('0x1f')]=qs[_0x7451('0x1f')](_0x21c831[_0x7451('0x32')][_0x7451('0x1f')]);}return _0x425d85['getBlackLists'](_0x31c337);}})[_0x7451('0x25')](function(_0x16201b){if(_0x16201b){return _0x16201b?{'count':_0x2ec2bd,'rows':_0x16201b}:null;}})[_0x7451('0x25')](respondWithResult(_0x5af9d3,null))[_0x7451('0x46')](handleError(_0x5af9d3,null));};exports[_0x7451('0x92')]=function(_0x4830c9,_0x37997b,_0x4a6e9f){var _0x391961,_0x1cd71e;var _0x264282=[];var _0x5be6f8=moment()[_0x7451('0x66')]('YYYY-MM-DD\x20HH:mm:ss');return db['Campaign']['find']({'where':{'id':_0x4830c9[_0x7451('0x48')]['id']}})['then'](handleEntityNotFound(_0x37997b,null))[_0x7451('0x25')](function(_0x41a623){if(_0x41a623){_0x1cd71e=_0x41a623;return _0x41a623[_0x7451('0x92')](_0x4830c9['body'][_0x7451('0x68')],_[_0x7451('0x53')](_0x4830c9[_0x7451('0x54')],[_0x7451('0x68'),'id'])||{});}return null;})['spread'](function(_0x45d379){var _0x44d06d;var _0xb0ccb9;_0x391961=_0x45d379||[];var _0x4658f7=[];if(_0x45d379){for(var _0xb4d0f6=0x0;_0xb4d0f6<_0x45d379[_0x7451('0x38')];_0xb4d0f6+=0x1){var _0x33e467=_0x45d379[_0xb4d0f6][_0x7451('0x27')]({'plain':!![]});_0x44d06d=squel['insert']()[_0x7451('0x6b')]('cm_hopper_black')[_0x7451('0x6d')]([_0x7451('0x6e'),_0x7451('0x6f'),'ListId','CampaignId',_0x7451('0x55'),_0x7451('0x56')],squel[_0x7451('0x71')]()[_0x7451('0x72')]('phone',_0x7451('0x6e'))[_0x7451('0x72')]('id',_0x7451('0x6f'))[_0x7451('0x72')](_0x33e467[_0x7451('0x75')][_0x7451('0x76')](),'ListId')[_0x7451('0x72')](_0x4830c9[_0x7451('0x48')]['id'][_0x7451('0x76')](),_0x7451('0x5c'))['field'](_0x7451('0x73'),_0x7451('0x55'))['field'](_0x7451('0x73'),_0x7451('0x56'))['from'](_0x7451('0x78'))[_0x7451('0x3d')]('deletedAt\x20IS\x20NULL')['where'](_0x7451('0x79'),_0x33e467[_0x7451('0x75')][_0x7451('0x76')]())[_0x7451('0x3d')](_0x7451('0x7a')))['toString']();_0x4658f7['push'](db[_0x7451('0x8d')][_0x7451('0x32')](_0x44d06d));}return BPromise[_0x7451('0x8f')](_0x4658f7);}})[_0x7451('0x25')](function(){return _0x391961;})[_0x7451('0x25')](respondWithResult(_0x37997b,null))['catch'](handleError(_0x37997b,null));};exports[_0x7451('0x93')]=function(_0x3dff42,_0x3cfd14,_0x5ca0bc){return db[_0x7451('0x43')]['find']({'where':{'id':_0x3dff42[_0x7451('0x48')]['id']}})[_0x7451('0x25')](handleEntityNotFound(_0x3cfd14,null))[_0x7451('0x25')](function(_0x4345ad){if(_0x4345ad){return _0x4345ad[_0x7451('0x93')](_0x3dff42[_0x7451('0x32')][_0x7451('0x68')]);}})[_0x7451('0x25')](function(_0x338952){if(_0x338952){return db[_0x7451('0x62')]['destroy']({'where':{'ListId':_0x3dff42[_0x7451('0x32')][_0x7451('0x68')],'CampaignId':_0x3dff42[_0x7451('0x48')]['id']}})[_0x7451('0x25')](function(){return _0x338952;});}})['then'](respondWithStatusCode(_0x3cfd14,null))[_0x7451('0x46')](handleError(_0x3cfd14,null));};