[motion2.git] / server / api / campaign / campaign.controller.js

// *************************************************************************
// *                                                                       *
// * xCALLY Motion -  The Omnichannel Contact Center                       *
// * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
// *                                                                       *
// *************************************************************************
// *                                                                       *
// * Email: info@xcally.com                                                *
// * Website: https://www.xcally.com                                       *
// *                                                                       *
// *************************************************************************
// *                                                                       *
// * The SOFTWARE PRODUCT is protected by copyright laws and international *
// * copyright treaties, as well as other intellectual property laws and   *
// * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
// *                                                                       *
// *************************************************************************
var _0xd403=['onlyIfOpen','insert','cm_contacts','CampaignId\x20=\x20?','cm_hopper_additional_phones','cmHopperId','h.id','ci.OrderBY','OrderBy','cm_contact_has_items','join','h.ContactId\x20=\x20ci.CmContactId','h.ListId\x20=\x20?','h.createdAt\x20=\x20?','push','sequelize','all','removeLists','getBlackLists','format','cm_hopper_black','removeBlackLists','eml-format','rimraf','zip-dir','fast-json-patch','moment','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','end','status','json','offset','undefined','count','limit','apply','reject','save','update','then','destroy','IvrCampaigns','UserProfileResource','sendStatus','error','stack','name','send','map','rawAttributes','fieldName','type','key','query','keys','filters','attributes','intersection','model','fields','length','hasOwnProperty','nolimit','order','sort','where','merge','VIRTUAL','filter','options','includeAll','include','findAll','rows','catch','show','params','Campaign','find','create','body','user','get','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','updatedAt','omit','role','UserProfileSection','getHoppers','findOne','CmHopper','pick','CampaignId','CmHopperHistory','getHopperFinals','CmHopperFinal','getHopperBlacks','CmHopperBlack','getLists','addLists','YYYY-MM-DD\x20HH:mm:ss','ids','spread','dialCheckDuplicateType','always','into','cm_hopper','fromQuery','phone','scheduledAt','ContactId','ListId','createdAt','NOW()','field','toString','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','CmListId','phone\x20IS\x20NOT\x20NULL','select','COALESCE(calleridnum,\x27\x27)','from','phone\x20NOT\x20IN\x20(?)','COALESCE(phone,\x27\x27)'];(function(_0x320fec,_0x49c104){var _0x158c82=function(_0x2f4668){while(--_0x2f4668){_0x320fec['push'](_0x320fec['shift']());}};_0x158c82(++_0x49c104);}(_0xd403,0x1d5));var _0x3d40=function(_0xaa0309,_0x1c8008){_0xaa0309=_0xaa0309-0x0;var _0x5de7ce=_0xd403[_0xaa0309];return _0x5de7ce;};'use strict';var emlformat=require(_0x3d40('0x0'));var rimraf=require(_0x3d40('0x1'));var zipdir=require(_0x3d40('0x2'));var jsonpatch=require(_0x3d40('0x3'));var rp=require('request-promise');var moment=require(_0x3d40('0x4'));var BPromise=require('bluebird');var Mustache=require(_0x3d40('0x5'));var util=require(_0x3d40('0x6'));var path=require(_0x3d40('0x7'));var sox=require(_0x3d40('0x8'));var csv=require(_0x3d40('0x9'));var ejs=require(_0x3d40('0xa'));var fs=require('fs');var fs_extra=require(_0x3d40('0xb'));var _=require(_0x3d40('0xc'));var squel=require(_0x3d40('0xd'));var crypto=require(_0x3d40('0xe'));var jsforce=require(_0x3d40('0xf'));var deskjs=require(_0x3d40('0x10'));var toCsv=require(_0x3d40('0x9'));var querystring=require(_0x3d40('0x11'));var Papa=require(_0x3d40('0x12'));var Redis=require(_0x3d40('0x13'));var authService=require('../../components/auth/service');var qs=require(_0x3d40('0x14'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x3d40('0x15'));var logger=require(_0x3d40('0x16'))(_0x3d40('0x17'));var utils=require('../../config/utils');var config=require(_0x3d40('0x18'));var licenseUtil=require(_0x3d40('0x19'));var db=require(_0x3d40('0x1a'))['db'];function respondWithStatusCode(_0x49ea7c,_0x31c199){_0x31c199=_0x31c199||0xcc;return function(_0x405625){if(_0x405625){return _0x49ea7c['sendStatus'](_0x31c199);}return _0x49ea7c['status'](_0x31c199)[_0x3d40('0x1b')]();};}function respondWithResult(_0x24d2c0,_0x3e6d19){_0x3e6d19=_0x3e6d19||0xc8;return function(_0x5062ec){if(_0x5062ec){return _0x24d2c0[_0x3d40('0x1c')](_0x3e6d19)[_0x3d40('0x1d')](_0x5062ec);}};}function respondWithFilteredResult(_0x311d57,_0x3e6e71){return function(_0x2b5e2d){if(_0x2b5e2d){var _0x359e9d=typeof _0x3e6e71[_0x3d40('0x1e')]==='undefined'&&typeof _0x3e6e71['limit']===_0x3d40('0x1f');var _0x2f38e1=_0x2b5e2d[_0x3d40('0x20')];var _0x75437e=_0x359e9d?0x0:_0x3e6e71[_0x3d40('0x1e')];var _0x2f3663=_0x359e9d?_0x2b5e2d[_0x3d40('0x20')]:_0x3e6e71[_0x3d40('0x1e')]+_0x3e6e71[_0x3d40('0x21')];var _0x402b4e;if(_0x2f3663>=_0x2f38e1){_0x2f3663=_0x2f38e1;_0x402b4e=0xc8;}else{_0x402b4e=0xce;}_0x311d57[_0x3d40('0x1c')](_0x402b4e);return _0x311d57['set']('Content-Range',_0x75437e+'-'+_0x2f3663+'/'+_0x2f38e1)[_0x3d40('0x1d')](_0x2b5e2d);}return null;};}function patchUpdates(_0x41608f){return function(_0x2fc0e2){try{jsonpatch[_0x3d40('0x22')](_0x2fc0e2,_0x41608f,!![]);}catch(_0x28b1c0){return BPromise[_0x3d40('0x23')](_0x28b1c0);}return _0x2fc0e2[_0x3d40('0x24')]();};}function saveUpdates(_0xbd7298,_0x3df1f9){return function(_0x321bc2){if(_0x321bc2){return _0x321bc2[_0x3d40('0x25')](_0xbd7298)[_0x3d40('0x26')](function(_0x181688){return _0x181688;});}return null;};}function removeEntity(_0x5314c5,_0x1a2d0f){return function(_0x14cad3){if(_0x14cad3){return _0x14cad3[_0x3d40('0x27')]()[_0x3d40('0x26')](function(){var _0x645da4=_0x14cad3['get']({'plain':!![]});var _0x45aa46=_0x3d40('0x28');return db[_0x3d40('0x29')][_0x3d40('0x27')]({'where':{'type':_0x45aa46,'resourceId':_0x645da4['id']}})[_0x3d40('0x26')](function(){return _0x14cad3;});})['then'](function(){_0x5314c5[_0x3d40('0x1c')](0xcc)[_0x3d40('0x1b')]();});}};}function handleEntityNotFound(_0x4e4ee9,_0x412d46){return function(_0x1f94ac){if(!_0x1f94ac){_0x4e4ee9[_0x3d40('0x2a')](0x194);}return _0x1f94ac;};}function handleError(_0x537790,_0x38ff70){_0x38ff70=_0x38ff70||0x1f4;return function(_0x265c2c){logger[_0x3d40('0x2b')](_0x265c2c[_0x3d40('0x2c')]);if(_0x265c2c[_0x3d40('0x2d')]){delete _0x265c2c[_0x3d40('0x2d')];}_0x537790[_0x3d40('0x1c')](_0x38ff70)[_0x3d40('0x2e')](_0x265c2c);};}exports['index']=function(_0x4e536f,_0x394fab){var _0xcb3c3b={},_0x5071b9={},_0x2c1ce6={'count':0x0,'rows':[]};var _0x4f235f=_[_0x3d40('0x2f')](db['Campaign'][_0x3d40('0x30')],function(_0xbff1f2){return{'name':_0xbff1f2[_0x3d40('0x31')],'type':_0xbff1f2[_0x3d40('0x32')][_0x3d40('0x33')]};});_0x5071b9['model']=_['map'](_0x4f235f,_0x3d40('0x2d'));_0x5071b9[_0x3d40('0x34')]=_[_0x3d40('0x35')](_0x4e536f['query']);_0x5071b9[_0x3d40('0x36')]=_['intersection'](_0x5071b9['model'],_0x5071b9['query']);_0xcb3c3b[_0x3d40('0x37')]=_[_0x3d40('0x38')](_0x5071b9[_0x3d40('0x39')],qs[_0x3d40('0x3a')](_0x4e536f[_0x3d40('0x34')][_0x3d40('0x3a')]));_0xcb3c3b[_0x3d40('0x37')]=_0xcb3c3b[_0x3d40('0x37')][_0x3d40('0x3b')]?_0xcb3c3b['attributes']:_0x5071b9['model'];if(!_0x4e536f[_0x3d40('0x34')][_0x3d40('0x3c')](_0x3d40('0x3d'))){_0xcb3c3b[_0x3d40('0x21')]=qs[_0x3d40('0x21')](_0x4e536f[_0x3d40('0x34')]['limit']);_0xcb3c3b[_0x3d40('0x1e')]=qs[_0x3d40('0x1e')](_0x4e536f[_0x3d40('0x34')]['offset']);}_0xcb3c3b[_0x3d40('0x3e')]=qs['sort'](_0x4e536f[_0x3d40('0x34')][_0x3d40('0x3f')]);_0xcb3c3b['where']=qs[_0x3d40('0x36')](_['pick'](_0x4e536f['query'],_0x5071b9[_0x3d40('0x36')]),_0x4f235f);if(_0x4e536f[_0x3d40('0x34')]['filter']){_0xcb3c3b[_0x3d40('0x40')]=_[_0x3d40('0x41')](_0xcb3c3b[_0x3d40('0x40')],{'$or':_['map'](_0x4f235f,function(_0x295418){if(_0x295418[_0x3d40('0x32')]!==_0x3d40('0x42')){var _0x2c45c5={};_0x2c45c5[_0x295418[_0x3d40('0x2d')]]={'$like':'%'+_0x4e536f[_0x3d40('0x34')][_0x3d40('0x43')]+'%'};return _0x2c45c5;}})});}_0xcb3c3b=_[_0x3d40('0x41')]({},_0xcb3c3b,_0x4e536f[_0x3d40('0x44')]);var _0x322030={'where':_0xcb3c3b[_0x3d40('0x40')]};return db['Campaign'][_0x3d40('0x20')](_0x322030)['then'](function(_0x575268){_0x2c1ce6['count']=_0x575268;if(_0x4e536f[_0x3d40('0x34')][_0x3d40('0x45')]){_0xcb3c3b[_0x3d40('0x46')]=[{'all':!![]}];}return db['Campaign'][_0x3d40('0x47')](_0xcb3c3b);})[_0x3d40('0x26')](function(_0x46e59d){_0x2c1ce6[_0x3d40('0x48')]=_0x46e59d;return _0x2c1ce6;})['then'](respondWithFilteredResult(_0x394fab,_0xcb3c3b))[_0x3d40('0x49')](handleError(_0x394fab,null));};exports[_0x3d40('0x4a')]=function(_0x17becc,_0x1be4a9){var _0xdde7e4={'raw':![],'where':{'id':_0x17becc[_0x3d40('0x4b')]['id']}},_0x4387f5={};_0x4387f5[_0x3d40('0x39')]=_[_0x3d40('0x35')](db[_0x3d40('0x4c')]['rawAttributes']);_0x4387f5['query']=_[_0x3d40('0x35')](_0x17becc[_0x3d40('0x34')]);_0x4387f5[_0x3d40('0x36')]=_[_0x3d40('0x38')](_0x4387f5[_0x3d40('0x39')],_0x4387f5[_0x3d40('0x34')]);_0xdde7e4[_0x3d40('0x37')]=_[_0x3d40('0x38')](_0x4387f5[_0x3d40('0x39')],qs['fields'](_0x17becc['query'][_0x3d40('0x3a')]));_0xdde7e4[_0x3d40('0x37')]=_0xdde7e4[_0x3d40('0x37')][_0x3d40('0x3b')]?_0xdde7e4[_0x3d40('0x37')]:_0x4387f5['model'];if(_0x17becc[_0x3d40('0x34')][_0x3d40('0x45')]){_0xdde7e4['include']=[{'all':!![]}];}_0xdde7e4=_['merge']({},_0xdde7e4,_0x17becc['options']);return db[_0x3d40('0x4c')][_0x3d40('0x4d')](_0xdde7e4)[_0x3d40('0x26')](handleEntityNotFound(_0x1be4a9,null))['then'](respondWithResult(_0x1be4a9,null))[_0x3d40('0x49')](handleError(_0x1be4a9,null));};exports['create']=function(_0x580eee,_0xa3ba73){return db[_0x3d40('0x4c')][_0x3d40('0x4e')](_0x580eee[_0x3d40('0x4f')],{})['then'](function(_0xb99156){var _0x5d957d=_0x580eee[_0x3d40('0x50')][_0x3d40('0x51')]({'plain':!![]});if(!_0x5d957d)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x5d957d['role']===_0x3d40('0x50')){var _0x1448c4=_0xb99156[_0x3d40('0x51')]({'plain':!![]});var _0x23eadf=_0x3d40('0x28');return db['UserProfileSection']['find']({'where':{'name':_0x23eadf,'userProfileId':_0x5d957d[_0x3d40('0x52')]},'raw':!![]})[_0x3d40('0x26')](function(_0x333538){if(_0x333538&&_0x333538[_0x3d40('0x53')]===0x0){return db[_0x3d40('0x29')][_0x3d40('0x4e')]({'name':_0x1448c4['name'],'resourceId':_0x1448c4['id'],'type':_0x333538[_0x3d40('0x2d')],'sectionId':_0x333538['id']},{})[_0x3d40('0x26')](function(){return _0xb99156;});}else{return _0xb99156;}})[_0x3d40('0x49')](function(_0x10223d){logger[_0x3d40('0x2b')](_0x3d40('0x54'),_0x10223d);throw _0x10223d;});}return _0xb99156;})[_0x3d40('0x26')](respondWithResult(_0xa3ba73,0xc9))[_0x3d40('0x49')](handleError(_0xa3ba73,null));};exports[_0x3d40('0x55')]=function(_0x189e80,_0x40eb86){var _0x1ab188={'where':{'id':_0x189e80[_0x3d40('0x4b')]['id']}},_0x427f2a={};_0x427f2a['model']=_['keys'](db['Campaign']['rawAttributes']);_0x1ab188['attributes']=_[_0x3d40('0x38')](_0x427f2a['model'],qs[_0x3d40('0x3a')](_0x189e80[_0x3d40('0x34')]['fields']));_0x1ab188[_0x3d40('0x37')]=_0x1ab188[_0x3d40('0x37')]['length']?_0x1ab188[_0x3d40('0x37')]:_0x427f2a[_0x3d40('0x39')];if(_0x189e80[_0x3d40('0x34')]['includeAll']){_0x1ab188[_0x3d40('0x46')]=[{'all':!![]}];}_0x1ab188=_['merge']({},_0x1ab188,_0x189e80[_0x3d40('0x44')]);return db['Campaign']['find'](_0x1ab188)['then'](handleEntityNotFound(_0x40eb86,null))[_0x3d40('0x26')](function(_0x18626d){if(_0x18626d){var _0x5ad181=_0x18626d[_0x3d40('0x51')]({'plain':!![]});_0x5ad181=qs['omit'](_0x5ad181,['id','createdAt',_0x3d40('0x56')]);_0x189e80['body']=_[_0x3d40('0x57')](_0x189e80['body'],['id','createdAt',_0x3d40('0x56')]);return db['Campaign'][_0x3d40('0x4e')](_[_0x3d40('0x41')](_0x5ad181,_0x189e80[_0x3d40('0x4f')]),{'include':_0x189e80[_0x3d40('0x34')][_0x3d40('0x45')]?[{'all':!![]}]:undefined})['then'](function(_0x358999){var _0x1d6445=_0x189e80[_0x3d40('0x50')][_0x3d40('0x51')]({'plain':!![]});if(!_0x1d6445)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x1d6445[_0x3d40('0x58')]===_0x3d40('0x50')){var _0x4600a2=_0x358999['get']({'plain':!![]});var _0x44d093=_0x3d40('0x28');return db[_0x3d40('0x59')][_0x3d40('0x4d')]({'where':{'name':_0x44d093,'userProfileId':_0x1d6445[_0x3d40('0x52')]},'raw':!![]})['then'](function(_0x850ccc){if(_0x850ccc&&_0x850ccc[_0x3d40('0x53')]===0x0){return db[_0x3d40('0x29')][_0x3d40('0x4e')]({'name':_0x4600a2[_0x3d40('0x2d')],'resourceId':_0x4600a2['id'],'type':_0x850ccc[_0x3d40('0x2d')],'sectionId':_0x850ccc['id']},{})[_0x3d40('0x26')](function(){return _0x358999;});}else{return _0x358999;}})['catch'](function(_0x5d14f8){logger['error']('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x5d14f8);throw _0x5d14f8;});}return _0x358999;});}})[_0x3d40('0x26')](respondWithResult(_0x40eb86,0xc9))['catch'](handleError(_0x40eb86,null));};exports[_0x3d40('0x25')]=function(_0x471d78,_0x19f033){if(_0x471d78[_0x3d40('0x4f')]['id']){delete _0x471d78[_0x3d40('0x4f')]['id'];}return db[_0x3d40('0x4c')][_0x3d40('0x4d')]({'where':{'id':_0x471d78[_0x3d40('0x4b')]['id']}})[_0x3d40('0x26')](handleEntityNotFound(_0x19f033,null))['then'](saveUpdates(_0x471d78[_0x3d40('0x4f')],null))[_0x3d40('0x26')](respondWithResult(_0x19f033,null))[_0x3d40('0x49')](handleError(_0x19f033,null));};exports[_0x3d40('0x27')]=function(_0x46ef8e,_0x25637f){return db[_0x3d40('0x4c')][_0x3d40('0x4d')]({'where':{'id':_0x46ef8e[_0x3d40('0x4b')]['id']}})['then'](handleEntityNotFound(_0x25637f,null))[_0x3d40('0x26')](removeEntity(_0x25637f,null))[_0x3d40('0x49')](handleError(_0x25637f,null));};exports[_0x3d40('0x5a')]=function(_0x11fc54,_0x2cfc63,_0x213ea9){var _0x4dc423={'raw':!![],'where':{}};var _0x4409a2={};var _0x5cea69={'count':0x0,'rows':[]};return db[_0x3d40('0x4c')][_0x3d40('0x5b')]({'where':{'id':_0x11fc54['params']['id']}})['then'](handleEntityNotFound(_0x2cfc63,null))[_0x3d40('0x26')](function(_0xa531d1){if(_0xa531d1){_0x4409a2[_0x3d40('0x39')]=_['keys'](db[_0x3d40('0x5c')][_0x3d40('0x30')]);_0x4409a2[_0x3d40('0x34')]=_['keys'](_0x11fc54[_0x3d40('0x34')]);_0x4409a2['filters']=_[_0x3d40('0x38')](_0x4409a2[_0x3d40('0x39')],_0x4409a2[_0x3d40('0x34')]);_0x4dc423[_0x3d40('0x37')]=_[_0x3d40('0x38')](_0x4409a2['model'],qs[_0x3d40('0x3a')](_0x11fc54['query']['fields']));_0x4dc423[_0x3d40('0x37')]=_0x4dc423['attributes'][_0x3d40('0x3b')]?_0x4dc423[_0x3d40('0x37')]:_0x4409a2[_0x3d40('0x39')];if(!_0x11fc54['query']['hasOwnProperty'](_0x3d40('0x3d'))){_0x4dc423[_0x3d40('0x21')]=qs['limit'](_0x11fc54['query'][_0x3d40('0x21')]);_0x4dc423['offset']=qs[_0x3d40('0x1e')](_0x11fc54[_0x3d40('0x34')][_0x3d40('0x1e')]);}_0x4dc423['order']=qs[_0x3d40('0x3f')](_0x11fc54[_0x3d40('0x34')][_0x3d40('0x3f')]);_0x4dc423[_0x3d40('0x40')]=qs[_0x3d40('0x36')](_[_0x3d40('0x5d')](_0x11fc54[_0x3d40('0x34')],_0x4409a2['filters']));_0x4dc423[_0x3d40('0x40')]['CampaignId']=_0xa531d1['id'];if(_0x11fc54[_0x3d40('0x34')][_0x3d40('0x43')]){_0x4dc423[_0x3d40('0x40')]=_[_0x3d40('0x41')](_0x4dc423[_0x3d40('0x40')],{'$or':_['map'](_0x4dc423[_0x3d40('0x37')],function(_0x183b7d){var _0x5416f3={};_0x5416f3[_0x183b7d]={'$like':'%'+_0x11fc54[_0x3d40('0x34')]['filter']+'%'};return _0x5416f3;})});}_0x4dc423=_[_0x3d40('0x41')]({},_0x4dc423,_0x11fc54[_0x3d40('0x44')]);return db[_0x3d40('0x5c')][_0x3d40('0x20')]({'where':_0x4dc423[_0x3d40('0x40')]})[_0x3d40('0x26')](function(_0x15e576){_0x5cea69['count']=_0x15e576;if(_0x11fc54[_0x3d40('0x34')][_0x3d40('0x45')]){_0x4dc423[_0x3d40('0x46')]=[{'all':!![]}];}return db[_0x3d40('0x5c')]['findAll'](_0x4dc423);})[_0x3d40('0x26')](function(_0x1e84f0){_0x5cea69[_0x3d40('0x48')]=_0x1e84f0;return _0x5cea69;});}})['then'](respondWithFilteredResult(_0x2cfc63,_0x4dc423))[_0x3d40('0x49')](handleError(_0x2cfc63,null));};exports['getHopperHistories']=function(_0x8883b2,_0x4647e5,_0x5bdbd8){var _0x317dcf={'raw':!![],'where':{}};var _0x568ba9={};var _0x229865={'count':0x0,'rows':[]};return db[_0x3d40('0x4c')][_0x3d40('0x5b')]({'where':{'id':_0x8883b2[_0x3d40('0x4b')]['id']}})[_0x3d40('0x26')](handleEntityNotFound(_0x4647e5,null))[_0x3d40('0x26')](function(_0x2916f9){if(_0x2916f9){_0x568ba9[_0x3d40('0x39')]=_[_0x3d40('0x35')](db['CmHopperHistory'][_0x3d40('0x30')]);_0x568ba9['query']=_[_0x3d40('0x35')](_0x8883b2[_0x3d40('0x34')]);_0x568ba9['filters']=_[_0x3d40('0x38')](_0x568ba9[_0x3d40('0x39')],_0x568ba9[_0x3d40('0x34')]);_0x317dcf['attributes']=_[_0x3d40('0x38')](_0x568ba9['model'],qs[_0x3d40('0x3a')](_0x8883b2[_0x3d40('0x34')][_0x3d40('0x3a')]));_0x317dcf[_0x3d40('0x37')]=_0x317dcf[_0x3d40('0x37')][_0x3d40('0x3b')]?_0x317dcf[_0x3d40('0x37')]:_0x568ba9[_0x3d40('0x39')];if(!_0x8883b2[_0x3d40('0x34')]['hasOwnProperty'](_0x3d40('0x3d'))){_0x317dcf[_0x3d40('0x21')]=qs[_0x3d40('0x21')](_0x8883b2[_0x3d40('0x34')][_0x3d40('0x21')]);_0x317dcf[_0x3d40('0x1e')]=qs[_0x3d40('0x1e')](_0x8883b2[_0x3d40('0x34')][_0x3d40('0x1e')]);}_0x317dcf[_0x3d40('0x3e')]=qs[_0x3d40('0x3f')](_0x8883b2['query'][_0x3d40('0x3f')]);_0x317dcf[_0x3d40('0x40')]=qs['filters'](_[_0x3d40('0x5d')](_0x8883b2[_0x3d40('0x34')],_0x568ba9['filters']));_0x317dcf['where'][_0x3d40('0x5e')]=_0x2916f9['id'];if(_0x8883b2[_0x3d40('0x34')][_0x3d40('0x43')]){_0x317dcf[_0x3d40('0x40')]=_[_0x3d40('0x41')](_0x317dcf[_0x3d40('0x40')],{'$or':_['map'](_0x317dcf[_0x3d40('0x37')],function(_0x97a8f2){var _0x1aca85={};_0x1aca85[_0x97a8f2]={'$like':'%'+_0x8883b2[_0x3d40('0x34')][_0x3d40('0x43')]+'%'};return _0x1aca85;})});}_0x317dcf=_[_0x3d40('0x41')]({},_0x317dcf,_0x8883b2[_0x3d40('0x44')]);return db['CmHopperHistory']['count']({'where':_0x317dcf[_0x3d40('0x40')]})['then'](function(_0x1c0932){_0x229865['count']=_0x1c0932;if(_0x8883b2[_0x3d40('0x34')][_0x3d40('0x45')]){_0x317dcf[_0x3d40('0x46')]=[{'all':!![]}];}return db[_0x3d40('0x5f')][_0x3d40('0x47')](_0x317dcf);})[_0x3d40('0x26')](function(_0x496311){_0x229865[_0x3d40('0x48')]=_0x496311;return _0x229865;});}})['then'](respondWithFilteredResult(_0x4647e5,_0x317dcf))['catch'](handleError(_0x4647e5,null));};exports[_0x3d40('0x60')]=function(_0x3d8be8,_0x37ccdd,_0x44578d){var _0x49e8fe={'raw':!![],'where':{}};var _0x2fbfb5={};var _0x3cbdcf={'count':0x0,'rows':[]};return db['Campaign'][_0x3d40('0x5b')]({'where':{'id':_0x3d8be8[_0x3d40('0x4b')]['id']}})[_0x3d40('0x26')](handleEntityNotFound(_0x37ccdd,null))[_0x3d40('0x26')](function(_0x162945){if(_0x162945){_0x2fbfb5['model']=_['keys'](db[_0x3d40('0x61')][_0x3d40('0x30')]);_0x2fbfb5['query']=_[_0x3d40('0x35')](_0x3d8be8['query']);_0x2fbfb5[_0x3d40('0x36')]=_['intersection'](_0x2fbfb5['model'],_0x2fbfb5['query']);_0x49e8fe[_0x3d40('0x37')]=_['intersection'](_0x2fbfb5[_0x3d40('0x39')],qs[_0x3d40('0x3a')](_0x3d8be8[_0x3d40('0x34')][_0x3d40('0x3a')]));_0x49e8fe[_0x3d40('0x37')]=_0x49e8fe[_0x3d40('0x37')][_0x3d40('0x3b')]?_0x49e8fe['attributes']:_0x2fbfb5[_0x3d40('0x39')];if(!_0x3d8be8[_0x3d40('0x34')][_0x3d40('0x3c')](_0x3d40('0x3d'))){_0x49e8fe[_0x3d40('0x21')]=qs[_0x3d40('0x21')](_0x3d8be8[_0x3d40('0x34')]['limit']);_0x49e8fe['offset']=qs[_0x3d40('0x1e')](_0x3d8be8[_0x3d40('0x34')][_0x3d40('0x1e')]);}_0x49e8fe[_0x3d40('0x3e')]=qs[_0x3d40('0x3f')](_0x3d8be8['query'][_0x3d40('0x3f')]);_0x49e8fe[_0x3d40('0x40')]=qs[_0x3d40('0x36')](_[_0x3d40('0x5d')](_0x3d8be8[_0x3d40('0x34')],_0x2fbfb5[_0x3d40('0x36')]));_0x49e8fe[_0x3d40('0x40')]['CampaignId']=_0x162945['id'];if(_0x3d8be8['query'][_0x3d40('0x43')]){_0x49e8fe[_0x3d40('0x40')]=_[_0x3d40('0x41')](_0x49e8fe[_0x3d40('0x40')],{'$or':_['map'](_0x49e8fe[_0x3d40('0x37')],function(_0x385429){var _0x362bec={};_0x362bec[_0x385429]={'$like':'%'+_0x3d8be8[_0x3d40('0x34')]['filter']+'%'};return _0x362bec;})});}_0x49e8fe=_[_0x3d40('0x41')]({},_0x49e8fe,_0x3d8be8['options']);return db[_0x3d40('0x61')][_0x3d40('0x20')]({'where':_0x49e8fe[_0x3d40('0x40')]})['then'](function(_0x49a656){_0x3cbdcf[_0x3d40('0x20')]=_0x49a656;if(_0x3d8be8['query'][_0x3d40('0x45')]){_0x49e8fe['include']=[{'all':!![]}];}return db['CmHopperFinal'][_0x3d40('0x47')](_0x49e8fe);})[_0x3d40('0x26')](function(_0x51917c){_0x3cbdcf[_0x3d40('0x48')]=_0x51917c;return _0x3cbdcf;});}})[_0x3d40('0x26')](respondWithFilteredResult(_0x37ccdd,_0x49e8fe))[_0x3d40('0x49')](handleError(_0x37ccdd,null));};exports[_0x3d40('0x62')]=function(_0x5512f4,_0x1495ae,_0x281525){var _0x42ca13={'raw':!![],'where':{}};var _0x4b0adb={};var _0x3345bc={'count':0x0,'rows':[]};return db[_0x3d40('0x4c')]['findOne']({'where':{'id':_0x5512f4[_0x3d40('0x4b')]['id']}})[_0x3d40('0x26')](handleEntityNotFound(_0x1495ae,null))[_0x3d40('0x26')](function(_0x382776){if(_0x382776){_0x4b0adb[_0x3d40('0x39')]=_[_0x3d40('0x35')](db['CmHopperBlack'][_0x3d40('0x30')]);_0x4b0adb[_0x3d40('0x34')]=_[_0x3d40('0x35')](_0x5512f4[_0x3d40('0x34')]);_0x4b0adb[_0x3d40('0x36')]=_[_0x3d40('0x38')](_0x4b0adb['model'],_0x4b0adb['query']);_0x42ca13[_0x3d40('0x37')]=_[_0x3d40('0x38')](_0x4b0adb['model'],qs['fields'](_0x5512f4['query'][_0x3d40('0x3a')]));_0x42ca13[_0x3d40('0x37')]=_0x42ca13[_0x3d40('0x37')]['length']?_0x42ca13[_0x3d40('0x37')]:_0x4b0adb['model'];if(!_0x5512f4[_0x3d40('0x34')][_0x3d40('0x3c')](_0x3d40('0x3d'))){_0x42ca13[_0x3d40('0x21')]=qs[_0x3d40('0x21')](_0x5512f4[_0x3d40('0x34')][_0x3d40('0x21')]);_0x42ca13['offset']=qs[_0x3d40('0x1e')](_0x5512f4[_0x3d40('0x34')][_0x3d40('0x1e')]);}_0x42ca13[_0x3d40('0x3e')]=qs[_0x3d40('0x3f')](_0x5512f4[_0x3d40('0x34')]['sort']);_0x42ca13[_0x3d40('0x40')]=qs[_0x3d40('0x36')](_['pick'](_0x5512f4[_0x3d40('0x34')],_0x4b0adb[_0x3d40('0x36')]));_0x42ca13['where'][_0x3d40('0x5e')]=_0x382776['id'];if(_0x5512f4['query'][_0x3d40('0x43')]){_0x42ca13[_0x3d40('0x40')]=_['merge'](_0x42ca13[_0x3d40('0x40')],{'$or':_[_0x3d40('0x2f')](_0x42ca13['attributes'],function(_0x3bd591){var _0x16f64d={};_0x16f64d[_0x3bd591]={'$like':'%'+_0x5512f4[_0x3d40('0x34')][_0x3d40('0x43')]+'%'};return _0x16f64d;})});}_0x42ca13=_['merge']({},_0x42ca13,_0x5512f4['options']);return db[_0x3d40('0x63')][_0x3d40('0x20')]({'where':_0x42ca13[_0x3d40('0x40')]})['then'](function(_0x2ffed4){_0x3345bc['count']=_0x2ffed4;if(_0x5512f4['query'][_0x3d40('0x45')]){_0x42ca13[_0x3d40('0x46')]=[{'all':!![]}];}return db['CmHopperBlack'][_0x3d40('0x47')](_0x42ca13);})[_0x3d40('0x26')](function(_0x3773e9){_0x3345bc[_0x3d40('0x48')]=_0x3773e9;return _0x3345bc;});}})[_0x3d40('0x26')](respondWithFilteredResult(_0x1495ae,_0x42ca13))[_0x3d40('0x49')](handleError(_0x1495ae,null));};exports[_0x3d40('0x64')]=function(_0x230d49,_0x43d62d,_0xd243c4){var _0x334633={};var _0x4abce8={};var _0x3773e5;var _0x37a6bf;return db[_0x3d40('0x4c')][_0x3d40('0x5b')]({'where':{'id':_0x230d49[_0x3d40('0x4b')]['id']}})[_0x3d40('0x26')](handleEntityNotFound(_0x43d62d,null))['then'](function(_0x37bacc){if(_0x37bacc){_0x3773e5=_0x37bacc;_0x4abce8[_0x3d40('0x39')]=_[_0x3d40('0x35')](db['CmList']['rawAttributes']);_0x4abce8[_0x3d40('0x34')]=_[_0x3d40('0x35')](_0x230d49['query']);_0x4abce8[_0x3d40('0x36')]=_[_0x3d40('0x38')](_0x4abce8['model'],_0x4abce8['query']);_0x334633[_0x3d40('0x37')]=_[_0x3d40('0x38')](_0x4abce8['model'],qs['fields'](_0x230d49[_0x3d40('0x34')][_0x3d40('0x3a')]));_0x334633['attributes']=_0x334633['attributes'][_0x3d40('0x3b')]?_0x334633['attributes']:_0x4abce8[_0x3d40('0x39')];_0x334633['order']=qs[_0x3d40('0x3f')](_0x230d49[_0x3d40('0x34')][_0x3d40('0x3f')]);_0x334633['where']=qs[_0x3d40('0x36')](_[_0x3d40('0x5d')](_0x230d49[_0x3d40('0x34')],_0x4abce8[_0x3d40('0x36')]));if(_0x230d49[_0x3d40('0x34')][_0x3d40('0x43')]){_0x334633[_0x3d40('0x40')]=_[_0x3d40('0x41')](_0x334633[_0x3d40('0x40')],{'$or':_['map'](_0x334633[_0x3d40('0x37')],function(_0xc92421){var _0x58f6a7={};_0x58f6a7[_0xc92421]={'$like':'%'+_0x230d49[_0x3d40('0x34')]['filter']+'%'};return _0x58f6a7;})});}_0x334633=_[_0x3d40('0x41')]({},_0x334633,_0x230d49[_0x3d40('0x44')]);return _0x3773e5[_0x3d40('0x64')](_0x334633);}})[_0x3d40('0x26')](function(_0x5b0f25){if(_0x5b0f25){_0x37a6bf=_0x5b0f25[_0x3d40('0x3b')];if(!_0x230d49['query'][_0x3d40('0x3c')](_0x3d40('0x3d'))){_0x334633[_0x3d40('0x21')]=qs[_0x3d40('0x21')](_0x230d49[_0x3d40('0x34')][_0x3d40('0x21')]);_0x334633[_0x3d40('0x1e')]=qs[_0x3d40('0x1e')](_0x230d49[_0x3d40('0x34')][_0x3d40('0x1e')]);}return _0x3773e5['getLists'](_0x334633);}})[_0x3d40('0x26')](function(_0x5d4a70){if(_0x5d4a70){return _0x5d4a70?{'count':_0x37a6bf,'rows':_0x5d4a70}:null;}})[_0x3d40('0x26')](respondWithResult(_0x43d62d,null))[_0x3d40('0x49')](handleError(_0x43d62d,null));};exports[_0x3d40('0x65')]=function(_0xf3c644,_0x26309d,_0x1d8f41){var _0x39bf67,_0x43e18e;var _0x1d5a17=[];var _0x836dc7=moment()['format'](_0x3d40('0x66'));return db[_0x3d40('0x4c')][_0x3d40('0x4d')]({'where':{'id':_0xf3c644[_0x3d40('0x4b')]['id']}})[_0x3d40('0x26')](handleEntityNotFound(_0x26309d,null))[_0x3d40('0x26')](function(_0x41d3ca){if(_0x41d3ca){_0x43e18e=_0x41d3ca;return _0x41d3ca['addLists'](_0xf3c644[_0x3d40('0x4f')]['ids'],_[_0x3d40('0x57')](_0xf3c644['body'],[_0x3d40('0x67'),'id'])||{});}return null;})[_0x3d40('0x68')](function(_0x1b80d6){var _0x275a02;var _0x49848e;_0x39bf67=_0x1b80d6||[];var _0x3eda3d=[];if(_0x1b80d6){for(var _0x2a8851=0x0;_0x2a8851<_0x1b80d6['length'];_0x2a8851+=0x1){var _0x11f1bd=_0x1b80d6[_0x2a8851][_0x3d40('0x51')]({'plain':!![]});_0x43e18e[_0x3d40('0x69')]=_0xf3c644[_0x3d40('0x4f')][_0x3d40('0x69')]?_0xf3c644['body']['dialCheckDuplicateType']:_0x43e18e[_0x3d40('0x69')];switch(_0x43e18e['dialCheckDuplicateType']){case _0x3d40('0x6a'):_0x275a02=squel['insert']()[_0x3d40('0x6b')](_0x3d40('0x6c'))[_0x3d40('0x6d')]([_0x3d40('0x6e'),_0x3d40('0x6f'),_0x3d40('0x70'),_0x3d40('0x71'),_0x3d40('0x5e'),_0x3d40('0x72'),_0x3d40('0x56')],squel['select']()['field'](_0x3d40('0x6e'),'phone')['field'](_0x3d40('0x73'),'scheduledAt')[_0x3d40('0x74')]('id',_0x3d40('0x70'))[_0x3d40('0x74')](_0x11f1bd['CmListId'][_0x3d40('0x75')](),_0x3d40('0x71'))[_0x3d40('0x74')](_0xf3c644[_0x3d40('0x4b')]['id'][_0x3d40('0x75')](),_0x3d40('0x5e'))[_0x3d40('0x74')]('\x27'+_0x836dc7+'\x27',_0x3d40('0x72'))['field']('\x27'+_0x836dc7+'\x27',_0x3d40('0x56'))['from']('cm_contacts')[_0x3d40('0x40')](_0x3d40('0x76'))[_0x3d40('0x40')](_0x3d40('0x77'),_0x11f1bd[_0x3d40('0x78')]['toString']())[_0x3d40('0x40')](_0x3d40('0x79'))[_0x3d40('0x40')]('phone\x20NOT\x20IN\x20(?)',squel[_0x3d40('0x7a')]()[_0x3d40('0x74')](_0x3d40('0x7b'))[_0x3d40('0x7c')]('cm_hopper_final')[_0x3d40('0x40')]('CampaignId\x20=\x20?',_0xf3c644[_0x3d40('0x4b')]['id'][_0x3d40('0x75')]()))[_0x3d40('0x40')](_0x3d40('0x7d'),squel[_0x3d40('0x7a')]()[_0x3d40('0x74')](_0x3d40('0x7e'))[_0x3d40('0x7c')](_0x3d40('0x6c'))[_0x3d40('0x40')]('CampaignId\x20=\x20?',_0xf3c644[_0x3d40('0x4b')]['id'][_0x3d40('0x75')]())))['toString']();break;case _0x3d40('0x7f'):_0x275a02=squel[_0x3d40('0x80')]()[_0x3d40('0x6b')](_0x3d40('0x6c'))['fromQuery']([_0x3d40('0x6e'),_0x3d40('0x6f'),'ContactId',_0x3d40('0x71'),'CampaignId',_0x3d40('0x72'),_0x3d40('0x56')],squel[_0x3d40('0x7a')]()[_0x3d40('0x74')](_0x3d40('0x6e'),'phone')['field'](_0x3d40('0x73'),_0x3d40('0x6f'))[_0x3d40('0x74')]('id',_0x3d40('0x70'))[_0x3d40('0x74')](_0x11f1bd['CmListId'][_0x3d40('0x75')](),_0x3d40('0x71'))[_0x3d40('0x74')](_0xf3c644['params']['id']['toString'](),_0x3d40('0x5e'))[_0x3d40('0x74')]('\x27'+_0x836dc7+'\x27',_0x3d40('0x72'))[_0x3d40('0x74')]('\x27'+_0x836dc7+'\x27',_0x3d40('0x56'))[_0x3d40('0x7c')](_0x3d40('0x81'))[_0x3d40('0x40')](_0x3d40('0x76'))['where'](_0x3d40('0x77'),_0x11f1bd[_0x3d40('0x78')][_0x3d40('0x75')]())[_0x3d40('0x40')](_0x3d40('0x79'))['where'](_0x3d40('0x7d'),squel[_0x3d40('0x7a')]()[_0x3d40('0x74')](_0x3d40('0x7e'))[_0x3d40('0x7c')](_0x3d40('0x6c'))[_0x3d40('0x40')](_0x3d40('0x82'),_0xf3c644[_0x3d40('0x4b')]['id'][_0x3d40('0x75')]())))[_0x3d40('0x75')]();break;default:_0x275a02=squel[_0x3d40('0x80')]()['into'](_0x3d40('0x6c'))[_0x3d40('0x6d')]([_0x3d40('0x6e'),_0x3d40('0x6f'),_0x3d40('0x70'),_0x3d40('0x71'),_0x3d40('0x5e'),_0x3d40('0x72'),_0x3d40('0x56')],squel['select']()[_0x3d40('0x74')](_0x3d40('0x6e'),_0x3d40('0x6e'))[_0x3d40('0x74')](_0x3d40('0x73'),_0x3d40('0x6f'))[_0x3d40('0x74')]('id',_0x3d40('0x70'))['field'](_0x11f1bd[_0x3d40('0x78')][_0x3d40('0x75')](),_0x3d40('0x71'))[_0x3d40('0x74')](_0xf3c644[_0x3d40('0x4b')]['id'][_0x3d40('0x75')](),_0x3d40('0x5e'))[_0x3d40('0x74')]('\x27'+_0x836dc7+'\x27',_0x3d40('0x72'))[_0x3d40('0x74')]('\x27'+_0x836dc7+'\x27',_0x3d40('0x56'))[_0x3d40('0x7c')](_0x3d40('0x81'))[_0x3d40('0x40')]('deletedAt\x20IS\x20NULL')[_0x3d40('0x40')](_0x3d40('0x77'),_0x11f1bd['CmListId'][_0x3d40('0x75')]())[_0x3d40('0x40')](_0x3d40('0x79')))[_0x3d40('0x75')]();}_0x49848e=squel['insert']()[_0x3d40('0x6b')](_0x3d40('0x83'))[_0x3d40('0x6d')]([_0x3d40('0x84'),_0x3d40('0x6f'),_0x3d40('0x6e'),'OrderBy',_0x3d40('0x72'),'updatedAt'],squel[_0x3d40('0x7a')]()[_0x3d40('0x74')](_0x3d40('0x85'),'id')['field']('NOW()',_0x3d40('0x6f'))[_0x3d40('0x74')]('ci.item',_0x3d40('0x6e'))[_0x3d40('0x74')](_0x3d40('0x86'),_0x3d40('0x87'))[_0x3d40('0x74')]('\x27'+_0x836dc7+'\x27',_0x3d40('0x72'))['field']('\x27'+_0x836dc7+'\x27','updatedAt')[_0x3d40('0x7c')](_0x3d40('0x88'),'ci')[_0x3d40('0x89')](_0x3d40('0x6c'),'h',_0x3d40('0x8a'))[_0x3d40('0x40')](_0x3d40('0x8b'),_0x11f1bd[_0x3d40('0x78')][_0x3d40('0x75')]())[_0x3d40('0x40')]('h.CampaignId=?',_0xf3c644[_0x3d40('0x4b')]['id']['toString']())[_0x3d40('0x40')](_0x3d40('0x8c'),_0x836dc7))['toString']();_0x3eda3d[_0x3d40('0x8d')](db[_0x3d40('0x8e')][_0x3d40('0x34')](_0x275a02));_0x1d5a17[_0x3d40('0x8d')](db[_0x3d40('0x8e')][_0x3d40('0x34')](_0x49848e));}return BPromise['all'](_0x3eda3d);}})[_0x3d40('0x26')](function(){return BPromise[_0x3d40('0x8f')](_0x1d5a17);})[_0x3d40('0x26')](function(){return _0x39bf67;})[_0x3d40('0x26')](respondWithResult(_0x26309d,null))[_0x3d40('0x49')](handleError(_0x26309d,null));};exports[_0x3d40('0x90')]=function(_0x2d6556,_0x22e4f5,_0x11851a){return db[_0x3d40('0x4c')][_0x3d40('0x4d')]({'where':{'id':_0x2d6556['params']['id']}})[_0x3d40('0x26')](handleEntityNotFound(_0x22e4f5,null))[_0x3d40('0x26')](function(_0x1c80ff){if(_0x1c80ff){return _0x1c80ff[_0x3d40('0x90')](_0x2d6556[_0x3d40('0x34')][_0x3d40('0x67')]);}})['then'](function(_0x213153){if(_0x213153){return db[_0x3d40('0x5c')]['destroy']({'where':{'ListId':_0x2d6556[_0x3d40('0x34')][_0x3d40('0x67')],'CampaignId':_0x2d6556[_0x3d40('0x4b')]['id']}})['then'](function(){return _0x213153;});}})[_0x3d40('0x26')](respondWithStatusCode(_0x22e4f5,null))[_0x3d40('0x49')](handleError(_0x22e4f5,null));};exports[_0x3d40('0x91')]=function(_0x16f636,_0x1f75b2,_0x10e479){var _0x11c7c3={};var _0x36a069={};var _0x5ab498;var _0x325579;return db[_0x3d40('0x4c')][_0x3d40('0x5b')]({'where':{'id':_0x16f636['params']['id']}})[_0x3d40('0x26')](handleEntityNotFound(_0x1f75b2,null))[_0x3d40('0x26')](function(_0x13e1dc){if(_0x13e1dc){_0x5ab498=_0x13e1dc;_0x36a069[_0x3d40('0x39')]=_['keys'](db['CmList'][_0x3d40('0x30')]);_0x36a069[_0x3d40('0x34')]=_[_0x3d40('0x35')](_0x16f636[_0x3d40('0x34')]);_0x36a069['filters']=_[_0x3d40('0x38')](_0x36a069[_0x3d40('0x39')],_0x36a069[_0x3d40('0x34')]);_0x11c7c3[_0x3d40('0x37')]=_['intersection'](_0x36a069[_0x3d40('0x39')],qs['fields'](_0x16f636[_0x3d40('0x34')][_0x3d40('0x3a')]));_0x11c7c3[_0x3d40('0x37')]=_0x11c7c3[_0x3d40('0x37')][_0x3d40('0x3b')]?_0x11c7c3['attributes']:_0x36a069['model'];_0x11c7c3['order']=qs[_0x3d40('0x3f')](_0x16f636[_0x3d40('0x34')][_0x3d40('0x3f')]);_0x11c7c3['where']=qs['filters'](_[_0x3d40('0x5d')](_0x16f636[_0x3d40('0x34')],_0x36a069[_0x3d40('0x36')]));if(_0x16f636['query'][_0x3d40('0x43')]){_0x11c7c3[_0x3d40('0x40')]=_[_0x3d40('0x41')](_0x11c7c3['where'],{'$or':_[_0x3d40('0x2f')](_0x11c7c3[_0x3d40('0x37')],function(_0x4d7817){var _0x22f625={};_0x22f625[_0x4d7817]={'$like':'%'+_0x16f636[_0x3d40('0x34')][_0x3d40('0x43')]+'%'};return _0x22f625;})});}_0x11c7c3=_[_0x3d40('0x41')]({},_0x11c7c3,_0x16f636[_0x3d40('0x44')]);return _0x5ab498[_0x3d40('0x91')](_0x11c7c3);}})[_0x3d40('0x26')](function(_0x394aba){if(_0x394aba){_0x325579=_0x394aba['length'];if(!_0x16f636[_0x3d40('0x34')]['hasOwnProperty']('nolimit')){_0x11c7c3[_0x3d40('0x21')]=qs[_0x3d40('0x21')](_0x16f636['query']['limit']);_0x11c7c3[_0x3d40('0x1e')]=qs[_0x3d40('0x1e')](_0x16f636[_0x3d40('0x34')][_0x3d40('0x1e')]);}return _0x5ab498[_0x3d40('0x91')](_0x11c7c3);}})[_0x3d40('0x26')](function(_0x3f2ad8){if(_0x3f2ad8){return _0x3f2ad8?{'count':_0x325579,'rows':_0x3f2ad8}:null;}})['then'](respondWithResult(_0x1f75b2,null))[_0x3d40('0x49')](handleError(_0x1f75b2,null));};exports['addBlackLists']=function(_0x5b5cdc,_0x27f2bc,_0x335ad2){var _0x46f5bd,_0x1ba164;var _0x2ed7ba=[];var _0x5b90be=moment()[_0x3d40('0x92')](_0x3d40('0x66'));return db[_0x3d40('0x4c')][_0x3d40('0x4d')]({'where':{'id':_0x5b5cdc[_0x3d40('0x4b')]['id']}})['then'](handleEntityNotFound(_0x27f2bc,null))[_0x3d40('0x26')](function(_0x30a94f){if(_0x30a94f){_0x1ba164=_0x30a94f;return _0x30a94f['addBlackLists'](_0x5b5cdc[_0x3d40('0x4f')]['ids'],_[_0x3d40('0x57')](_0x5b5cdc[_0x3d40('0x4f')],[_0x3d40('0x67'),'id'])||{});}return null;})[_0x3d40('0x68')](function(_0x397301){var _0x5bb0dc;var _0x278733;_0x46f5bd=_0x397301||[];var _0x1ebfef=[];if(_0x397301){for(var _0x4442f8=0x0;_0x4442f8<_0x397301['length'];_0x4442f8+=0x1){var _0x3d17e2=_0x397301[_0x4442f8][_0x3d40('0x51')]({'plain':!![]});_0x5bb0dc=squel[_0x3d40('0x80')]()[_0x3d40('0x6b')](_0x3d40('0x93'))[_0x3d40('0x6d')]([_0x3d40('0x6e'),_0x3d40('0x70'),'ListId',_0x3d40('0x5e'),_0x3d40('0x72'),'updatedAt'],squel['select']()[_0x3d40('0x74')](_0x3d40('0x6e'),_0x3d40('0x6e'))[_0x3d40('0x74')]('id',_0x3d40('0x70'))[_0x3d40('0x74')](_0x3d17e2[_0x3d40('0x78')][_0x3d40('0x75')](),'ListId')['field'](_0x5b5cdc[_0x3d40('0x4b')]['id']['toString'](),'CampaignId')[_0x3d40('0x74')](_0x3d40('0x73'),_0x3d40('0x72'))[_0x3d40('0x74')](_0x3d40('0x73'),_0x3d40('0x56'))[_0x3d40('0x7c')](_0x3d40('0x81'))[_0x3d40('0x40')]('deletedAt\x20IS\x20NULL')['where']('ListId\x20=\x20?',_0x3d17e2[_0x3d40('0x78')]['toString']())['where']('phone\x20IS\x20NOT\x20NULL'))[_0x3d40('0x75')]();_0x1ebfef[_0x3d40('0x8d')](db[_0x3d40('0x8e')][_0x3d40('0x34')](_0x5bb0dc));}return BPromise[_0x3d40('0x8f')](_0x1ebfef);}})[_0x3d40('0x26')](function(){return _0x46f5bd;})['then'](respondWithResult(_0x27f2bc,null))[_0x3d40('0x49')](handleError(_0x27f2bc,null));};exports[_0x3d40('0x94')]=function(_0x177fc5,_0x4d8afe,_0x5df071){return db[_0x3d40('0x4c')][_0x3d40('0x4d')]({'where':{'id':_0x177fc5[_0x3d40('0x4b')]['id']}})['then'](handleEntityNotFound(_0x4d8afe,null))['then'](function(_0x16c7c7){if(_0x16c7c7){return _0x16c7c7[_0x3d40('0x94')](_0x177fc5[_0x3d40('0x34')][_0x3d40('0x67')]);}})[_0x3d40('0x26')](function(_0x1e4d30){if(_0x1e4d30){return db['CmHopperBlack']['destroy']({'where':{'ListId':_0x177fc5[_0x3d40('0x34')][_0x3d40('0x67')],'CampaignId':_0x177fc5[_0x3d40('0x4b')]['id']}})[_0x3d40('0x26')](function(){return _0x1e4d30;});}})[_0x3d40('0x26')](respondWithStatusCode(_0x4d8afe,null))[_0x3d40('0x49')](handleError(_0x4d8afe,null));};