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 _0x6c35=['account','index','Campaign','fieldName','type','key','model','map','keys','query','filters','intersection','attributes','hasOwnProperty','nolimit','sort','where','pick','filter','include','findAll','rows','catch','params','rawAttributes','fields','length','includeAll','find','create','user','get','role','IvrCampaigns','UserProfileSection','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','options','updatedAt','omit','createdAt','userProfileId','autoAssociation','getHoppers','order','CampaignId','CmHopper','getHopperHistories','findOne','CmHopperHistory','getHopperFinals','CmHopperFinal','CmHopperBlack','CmList','getLists','addLists','ids','spread','dialCheckDuplicateType','always','insert','into','cm_hopper','scheduledAt','ContactId','select','field','phone','NOW()','toString','ListId','from','cm_contacts','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','CmListId','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','CampaignId\x20=\x20?','onlyIfOpen','fromQuery','COALESCE(phone,\x27\x27)','push','sequelize','all','removeLists','getBlackLists','addBlackLists','cm_hopper_black','removeBlackLists','eml-format','zip-dir','fast-json-patch','request-promise','moment','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','crypto','jsforce','desk.js','querystring','ioredis','../../components/parsers/qs','../../config/logger','../../mysqldb','status','end','json','offset','undefined','limit','count','set','apply','reject','update','then','destroy','UserProfileResource','sendStatus','error','stack','name','send','render','merge','body','contact','message','agent','interaction'];(function(_0x242bac,_0x52ea1d){var _0x52c165=function(_0x381763){while(--_0x381763){_0x242bac['push'](_0x242bac['shift']());}};_0x52c165(++_0x52ea1d);}(_0x6c35,0x16c));var _0x56c3=function(_0x16e842,_0x496dcf){_0x16e842=_0x16e842-0x0;var _0x2b48d6=_0x6c35[_0x16e842];return _0x2b48d6;};'use strict';var emlformat=require(_0x56c3('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x56c3('0x1'));var jsonpatch=require(_0x56c3('0x2'));var rp=require(_0x56c3('0x3'));var moment=require(_0x56c3('0x4'));var BPromise=require('bluebird');var Mustache=require(_0x56c3('0x5'));var util=require(_0x56c3('0x6'));var path=require(_0x56c3('0x7'));var sox=require(_0x56c3('0x8'));var csv=require(_0x56c3('0x9'));var ejs=require(_0x56c3('0xa'));var fs=require('fs');var fs_extra=require(_0x56c3('0xb'));var _=require(_0x56c3('0xc'));var squel=require('squel');var crypto=require(_0x56c3('0xd'));var jsforce=require(_0x56c3('0xe'));var deskjs=require(_0x56c3('0xf'));var toCsv=require(_0x56c3('0x9'));var querystring=require(_0x56c3('0x10'));var Papa=require('papaparse');var Redis=require(_0x56c3('0x11'));var authService=require('../../components/auth/service');var qs=require(_0x56c3('0x12'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0x56c3('0x13'))('api');var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require('../../config/license/util');var db=require(_0x56c3('0x14'))['db'];function respondWithStatusCode(_0x86825e,_0x4b58f2){_0x4b58f2=_0x4b58f2||0xcc;return function(_0x2d6051){if(_0x2d6051){return _0x86825e['sendStatus'](_0x4b58f2);}return _0x86825e[_0x56c3('0x15')](_0x4b58f2)[_0x56c3('0x16')]();};}function respondWithResult(_0x55fe4b,_0x3b331a){_0x3b331a=_0x3b331a||0xc8;return function(_0x4bbcf9){if(_0x4bbcf9){return _0x55fe4b['status'](_0x3b331a)[_0x56c3('0x17')](_0x4bbcf9);}};}function respondWithFilteredResult(_0x3d6ad3,_0x1db031){return function(_0x2b1820){if(_0x2b1820){var _0x378c7b=typeof _0x1db031[_0x56c3('0x18')]===_0x56c3('0x19')&&typeof _0x1db031[_0x56c3('0x1a')]==='undefined';var _0x3485be=_0x2b1820[_0x56c3('0x1b')];var _0x284f72=_0x378c7b?0x0:_0x1db031['offset'];var _0x48a7bd=_0x378c7b?_0x2b1820[_0x56c3('0x1b')]:_0x1db031[_0x56c3('0x18')]+_0x1db031[_0x56c3('0x1a')];var _0x4fb73b;if(_0x48a7bd>=_0x3485be){_0x48a7bd=_0x3485be;_0x4fb73b=0xc8;}else{_0x4fb73b=0xce;}_0x3d6ad3[_0x56c3('0x15')](_0x4fb73b);return _0x3d6ad3[_0x56c3('0x1c')]('Content-Range',_0x284f72+'-'+_0x48a7bd+'/'+_0x3485be)[_0x56c3('0x17')](_0x2b1820);}return null;};}function patchUpdates(_0x2ed1c0){return function(_0x5e1499){try{jsonpatch[_0x56c3('0x1d')](_0x5e1499,_0x2ed1c0,!![]);}catch(_0xa49e5b){return BPromise[_0x56c3('0x1e')](_0xa49e5b);}return _0x5e1499['save']();};}function saveUpdates(_0xff7255,_0x1dbd7c){return function(_0x445d54){if(_0x445d54){return _0x445d54[_0x56c3('0x1f')](_0xff7255)[_0x56c3('0x20')](function(_0x1ee3b4){return _0x1ee3b4;});}return null;};}function removeEntity(_0x32aa68,_0x10e5bf){return function(_0x3c7b6b){if(_0x3c7b6b){return _0x3c7b6b[_0x56c3('0x21')]()[_0x56c3('0x20')](function(){var _0x46ba6d=_0x3c7b6b['get']({'plain':!![]});var _0x3aa5fc='IvrCampaigns';return db[_0x56c3('0x22')][_0x56c3('0x21')]({'where':{'type':_0x3aa5fc,'resourceId':_0x46ba6d['id']}})['then'](function(){return _0x3c7b6b;});})[_0x56c3('0x20')](function(){_0x32aa68[_0x56c3('0x15')](0xcc)['end']();});}};}function handleEntityNotFound(_0x2f0cef,_0x5735a1){return function(_0x5f5386){if(!_0x5f5386){_0x2f0cef[_0x56c3('0x23')](0x194);}return _0x5f5386;};}function handleError(_0xcc77ff,_0x56132c){_0x56132c=_0x56132c||0x1f4;return function(_0x112a23){logger[_0x56c3('0x24')](_0x112a23[_0x56c3('0x25')]);if(_0x112a23[_0x56c3('0x26')]){delete _0x112a23[_0x56c3('0x26')];}_0xcc77ff['status'](_0x56132c)[_0x56c3('0x27')](_0x112a23);};}function getMustacheRender(_0x245055,_0x188f91){return Mustache[_0x56c3('0x28')](_0x245055,_[_0x56c3('0x29')](_0x188f91[_0x56c3('0x2a')],{'contact':_0x188f91[_0x56c3('0x2b')],'message':_0x188f91[_0x56c3('0x2c')],'agent':_0x188f91[_0x56c3('0x2d')],'interaction':_0x188f91[_0x56c3('0x2e')],'account':_0x188f91[_0x56c3('0x2f')]}))||'';}exports[_0x56c3('0x30')]=function(_0x3affd4,_0x3fb986){var _0x5e9d0e={},_0x2ccc8b={},_0xc5e1d4={'count':0x0,'rows':[]};var _0x2c5564=_['map'](db[_0x56c3('0x31')]['rawAttributes'],function(_0x49b070){return{'name':_0x49b070[_0x56c3('0x32')],'type':_0x49b070[_0x56c3('0x33')][_0x56c3('0x34')]};});_0x2ccc8b[_0x56c3('0x35')]=_[_0x56c3('0x36')](_0x2c5564,_0x56c3('0x26'));_0x2ccc8b['query']=_[_0x56c3('0x37')](_0x3affd4[_0x56c3('0x38')]);_0x2ccc8b[_0x56c3('0x39')]=_[_0x56c3('0x3a')](_0x2ccc8b[_0x56c3('0x35')],_0x2ccc8b['query']);_0x5e9d0e[_0x56c3('0x3b')]=_['intersection'](_0x2ccc8b[_0x56c3('0x35')],qs['fields'](_0x3affd4[_0x56c3('0x38')]['fields']));_0x5e9d0e['attributes']=_0x5e9d0e['attributes']['length']?_0x5e9d0e[_0x56c3('0x3b')]:_0x2ccc8b[_0x56c3('0x35')];if(!_0x3affd4['query'][_0x56c3('0x3c')](_0x56c3('0x3d'))){_0x5e9d0e['limit']=qs['limit'](_0x3affd4[_0x56c3('0x38')][_0x56c3('0x1a')]);_0x5e9d0e[_0x56c3('0x18')]=qs['offset'](_0x3affd4[_0x56c3('0x38')][_0x56c3('0x18')]);}_0x5e9d0e['order']=qs[_0x56c3('0x3e')](_0x3affd4['query'][_0x56c3('0x3e')]);_0x5e9d0e[_0x56c3('0x3f')]=qs[_0x56c3('0x39')](_[_0x56c3('0x40')](_0x3affd4[_0x56c3('0x38')],_0x2ccc8b[_0x56c3('0x39')]),_0x2c5564);if(_0x3affd4[_0x56c3('0x38')][_0x56c3('0x41')]){_0x5e9d0e['where']=_[_0x56c3('0x29')](_0x5e9d0e[_0x56c3('0x3f')],{'$or':_[_0x56c3('0x36')](_0x2c5564,function(_0x38b147){if(_0x38b147[_0x56c3('0x33')]!=='VIRTUAL'){var _0x3e4767={};_0x3e4767[_0x38b147[_0x56c3('0x26')]]={'$like':'%'+_0x3affd4['query'][_0x56c3('0x41')]+'%'};return _0x3e4767;}})});}_0x5e9d0e=_['merge']({},_0x5e9d0e,_0x3affd4['options']);var _0x5d6fd9={'where':_0x5e9d0e[_0x56c3('0x3f')]};return db[_0x56c3('0x31')][_0x56c3('0x1b')](_0x5d6fd9)['then'](function(_0x1799cd){_0xc5e1d4[_0x56c3('0x1b')]=_0x1799cd;if(_0x3affd4[_0x56c3('0x38')]['includeAll']){_0x5e9d0e[_0x56c3('0x42')]=[{'all':!![]}];}return db[_0x56c3('0x31')][_0x56c3('0x43')](_0x5e9d0e);})['then'](function(_0x6646ad){_0xc5e1d4[_0x56c3('0x44')]=_0x6646ad;return _0xc5e1d4;})[_0x56c3('0x20')](respondWithFilteredResult(_0x3fb986,_0x5e9d0e))[_0x56c3('0x45')](handleError(_0x3fb986,null));};exports['show']=function(_0x45eac4,_0x42949b){var _0x40d979={'raw':![],'where':{'id':_0x45eac4[_0x56c3('0x46')]['id']}},_0x48b8bd={};_0x48b8bd[_0x56c3('0x35')]=_['keys'](db[_0x56c3('0x31')][_0x56c3('0x47')]);_0x48b8bd[_0x56c3('0x38')]=_[_0x56c3('0x37')](_0x45eac4['query']);_0x48b8bd[_0x56c3('0x39')]=_[_0x56c3('0x3a')](_0x48b8bd[_0x56c3('0x35')],_0x48b8bd[_0x56c3('0x38')]);_0x40d979['attributes']=_['intersection'](_0x48b8bd[_0x56c3('0x35')],qs[_0x56c3('0x48')](_0x45eac4[_0x56c3('0x38')][_0x56c3('0x48')]));_0x40d979[_0x56c3('0x3b')]=_0x40d979[_0x56c3('0x3b')][_0x56c3('0x49')]?_0x40d979[_0x56c3('0x3b')]:_0x48b8bd[_0x56c3('0x35')];if(_0x45eac4[_0x56c3('0x38')][_0x56c3('0x4a')]){_0x40d979[_0x56c3('0x42')]=[{'all':!![]}];}_0x40d979=_['merge']({},_0x40d979,_0x45eac4['options']);return db['Campaign'][_0x56c3('0x4b')](_0x40d979)[_0x56c3('0x20')](handleEntityNotFound(_0x42949b,null))[_0x56c3('0x20')](respondWithResult(_0x42949b,null))[_0x56c3('0x45')](handleError(_0x42949b,null));};exports['create']=function(_0x398227,_0x593724){return db[_0x56c3('0x31')][_0x56c3('0x4c')](_0x398227[_0x56c3('0x2a')],{})[_0x56c3('0x20')](function(_0x444807){var _0x5ca335=_0x398227[_0x56c3('0x4d')][_0x56c3('0x4e')]({'plain':!![]});if(!_0x5ca335)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x5ca335[_0x56c3('0x4f')]===_0x56c3('0x4d')){var _0x122c29=_0x444807['get']({'plain':!![]});var _0x46f1f7=_0x56c3('0x50');return db[_0x56c3('0x51')][_0x56c3('0x4b')]({'where':{'name':_0x46f1f7,'userProfileId':_0x5ca335['userProfileId']},'raw':!![]})[_0x56c3('0x20')](function(_0x21f951){if(_0x21f951&&_0x21f951['autoAssociation']===0x0){return db[_0x56c3('0x22')][_0x56c3('0x4c')]({'name':_0x122c29[_0x56c3('0x26')],'resourceId':_0x122c29['id'],'type':_0x21f951[_0x56c3('0x26')],'sectionId':_0x21f951['id']},{})['then'](function(){return _0x444807;});}else{return _0x444807;}})[_0x56c3('0x45')](function(_0x54acc2){logger[_0x56c3('0x24')](_0x56c3('0x52'),_0x54acc2);throw _0x54acc2;});}return _0x444807;})['then'](respondWithResult(_0x593724,0xc9))['catch'](handleError(_0x593724,null));};exports[_0x56c3('0x53')]=function(_0x3b96a2,_0x465501){var _0x31a585={'where':{'id':_0x3b96a2[_0x56c3('0x46')]['id']}},_0x4d41e1={};_0x4d41e1[_0x56c3('0x35')]=_[_0x56c3('0x37')](db[_0x56c3('0x31')][_0x56c3('0x47')]);_0x31a585[_0x56c3('0x3b')]=_[_0x56c3('0x3a')](_0x4d41e1[_0x56c3('0x35')],qs[_0x56c3('0x48')](_0x3b96a2[_0x56c3('0x38')][_0x56c3('0x48')]));_0x31a585[_0x56c3('0x3b')]=_0x31a585[_0x56c3('0x3b')][_0x56c3('0x49')]?_0x31a585[_0x56c3('0x3b')]:_0x4d41e1[_0x56c3('0x35')];if(_0x3b96a2[_0x56c3('0x38')]['includeAll']){_0x31a585[_0x56c3('0x42')]=[{'all':!![]}];}_0x31a585=_[_0x56c3('0x29')]({},_0x31a585,_0x3b96a2[_0x56c3('0x54')]);return db[_0x56c3('0x31')][_0x56c3('0x4b')](_0x31a585)['then'](handleEntityNotFound(_0x465501,null))[_0x56c3('0x20')](function(_0x1e3e6e){if(_0x1e3e6e){var _0x1ee4bc=_0x1e3e6e[_0x56c3('0x4e')]({'plain':!![]});_0x1ee4bc=qs['omit'](_0x1ee4bc,['id','createdAt',_0x56c3('0x55')]);_0x3b96a2[_0x56c3('0x2a')]=_[_0x56c3('0x56')](_0x3b96a2[_0x56c3('0x2a')],['id',_0x56c3('0x57'),_0x56c3('0x55')]);return db[_0x56c3('0x31')][_0x56c3('0x4c')](_[_0x56c3('0x29')](_0x1ee4bc,_0x3b96a2['body']),{'include':_0x3b96a2['query'][_0x56c3('0x4a')]?[{'all':!![]}]:undefined})[_0x56c3('0x20')](function(_0x259c22){var _0x7b4708=_0x3b96a2['user'][_0x56c3('0x4e')]({'plain':!![]});if(!_0x7b4708)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x7b4708[_0x56c3('0x4f')]===_0x56c3('0x4d')){var _0x264f2e=_0x259c22[_0x56c3('0x4e')]({'plain':!![]});var _0x76d435=_0x56c3('0x50');return db[_0x56c3('0x51')][_0x56c3('0x4b')]({'where':{'name':_0x76d435,'userProfileId':_0x7b4708[_0x56c3('0x58')]},'raw':!![]})[_0x56c3('0x20')](function(_0x3dd1e8){if(_0x3dd1e8&&_0x3dd1e8[_0x56c3('0x59')]===0x0){return db[_0x56c3('0x22')]['create']({'name':_0x264f2e[_0x56c3('0x26')],'resourceId':_0x264f2e['id'],'type':_0x3dd1e8['name'],'sectionId':_0x3dd1e8['id']},{})[_0x56c3('0x20')](function(){return _0x259c22;});}else{return _0x259c22;}})[_0x56c3('0x45')](function(_0x1a6b29){logger[_0x56c3('0x24')](_0x56c3('0x52'),_0x1a6b29);throw _0x1a6b29;});}return _0x259c22;});}})[_0x56c3('0x20')](respondWithResult(_0x465501,0xc9))[_0x56c3('0x45')](handleError(_0x465501,null));};exports[_0x56c3('0x1f')]=function(_0x177b9b,_0x24221b){if(_0x177b9b['body']['id']){delete _0x177b9b['body']['id'];}return db[_0x56c3('0x31')][_0x56c3('0x4b')]({'where':{'id':_0x177b9b[_0x56c3('0x46')]['id']}})[_0x56c3('0x20')](handleEntityNotFound(_0x24221b,null))[_0x56c3('0x20')](saveUpdates(_0x177b9b[_0x56c3('0x2a')],null))[_0x56c3('0x20')](respondWithResult(_0x24221b,null))[_0x56c3('0x45')](handleError(_0x24221b,null));};exports[_0x56c3('0x21')]=function(_0x372200,_0x14ec4a){return db['Campaign'][_0x56c3('0x4b')]({'where':{'id':_0x372200[_0x56c3('0x46')]['id']}})[_0x56c3('0x20')](handleEntityNotFound(_0x14ec4a,null))[_0x56c3('0x20')](removeEntity(_0x14ec4a,null))[_0x56c3('0x45')](handleError(_0x14ec4a,null));};exports[_0x56c3('0x5a')]=function(_0x3948d0,_0x2e99da,_0x552ff3){var _0x14abb7={'raw':!![],'where':{}};var _0x141c17={};var _0x3946a7={'count':0x0,'rows':[]};return db['Campaign']['findOne']({'where':{'id':_0x3948d0[_0x56c3('0x46')]['id']}})[_0x56c3('0x20')](handleEntityNotFound(_0x2e99da,null))[_0x56c3('0x20')](function(_0x25daf0){if(_0x25daf0){_0x141c17[_0x56c3('0x35')]=_[_0x56c3('0x37')](db['CmHopper'][_0x56c3('0x47')]);_0x141c17['query']=_['keys'](_0x3948d0[_0x56c3('0x38')]);_0x141c17['filters']=_[_0x56c3('0x3a')](_0x141c17['model'],_0x141c17['query']);_0x14abb7[_0x56c3('0x3b')]=_[_0x56c3('0x3a')](_0x141c17[_0x56c3('0x35')],qs[_0x56c3('0x48')](_0x3948d0[_0x56c3('0x38')][_0x56c3('0x48')]));_0x14abb7['attributes']=_0x14abb7[_0x56c3('0x3b')][_0x56c3('0x49')]?_0x14abb7[_0x56c3('0x3b')]:_0x141c17[_0x56c3('0x35')];if(!_0x3948d0[_0x56c3('0x38')]['hasOwnProperty'](_0x56c3('0x3d'))){_0x14abb7[_0x56c3('0x1a')]=qs[_0x56c3('0x1a')](_0x3948d0[_0x56c3('0x38')][_0x56c3('0x1a')]);_0x14abb7[_0x56c3('0x18')]=qs['offset'](_0x3948d0[_0x56c3('0x38')][_0x56c3('0x18')]);}_0x14abb7[_0x56c3('0x5b')]=qs[_0x56c3('0x3e')](_0x3948d0[_0x56c3('0x38')][_0x56c3('0x3e')]);_0x14abb7['where']=qs[_0x56c3('0x39')](_[_0x56c3('0x40')](_0x3948d0['query'],_0x141c17[_0x56c3('0x39')]));_0x14abb7[_0x56c3('0x3f')][_0x56c3('0x5c')]=_0x25daf0['id'];if(_0x3948d0[_0x56c3('0x38')]['filter']){_0x14abb7[_0x56c3('0x3f')]=_[_0x56c3('0x29')](_0x14abb7[_0x56c3('0x3f')],{'$or':_[_0x56c3('0x36')](_0x14abb7[_0x56c3('0x3b')],function(_0x3b1e12){var _0x3ea8bf={};_0x3ea8bf[_0x3b1e12]={'$like':'%'+_0x3948d0[_0x56c3('0x38')][_0x56c3('0x41')]+'%'};return _0x3ea8bf;})});}_0x14abb7=_[_0x56c3('0x29')]({},_0x14abb7,_0x3948d0[_0x56c3('0x54')]);return db[_0x56c3('0x5d')][_0x56c3('0x1b')]({'where':_0x14abb7[_0x56c3('0x3f')]})[_0x56c3('0x20')](function(_0x229832){_0x3946a7[_0x56c3('0x1b')]=_0x229832;if(_0x3948d0[_0x56c3('0x38')][_0x56c3('0x4a')]){_0x14abb7[_0x56c3('0x42')]=[{'all':!![]}];}return db[_0x56c3('0x5d')][_0x56c3('0x43')](_0x14abb7);})[_0x56c3('0x20')](function(_0x324aae){_0x3946a7[_0x56c3('0x44')]=_0x324aae;return _0x3946a7;});}})[_0x56c3('0x20')](respondWithFilteredResult(_0x2e99da,_0x14abb7))['catch'](handleError(_0x2e99da,null));};exports[_0x56c3('0x5e')]=function(_0x270108,_0x530ffe,_0x44ad2c){var _0x274bc5={'raw':!![],'where':{}};var _0x46b4f4={};var _0x262486={'count':0x0,'rows':[]};return db['Campaign'][_0x56c3('0x5f')]({'where':{'id':_0x270108[_0x56c3('0x46')]['id']}})['then'](handleEntityNotFound(_0x530ffe,null))[_0x56c3('0x20')](function(_0x3d324f){if(_0x3d324f){_0x46b4f4[_0x56c3('0x35')]=_[_0x56c3('0x37')](db[_0x56c3('0x60')][_0x56c3('0x47')]);_0x46b4f4['query']=_[_0x56c3('0x37')](_0x270108[_0x56c3('0x38')]);_0x46b4f4[_0x56c3('0x39')]=_[_0x56c3('0x3a')](_0x46b4f4['model'],_0x46b4f4[_0x56c3('0x38')]);_0x274bc5[_0x56c3('0x3b')]=_['intersection'](_0x46b4f4[_0x56c3('0x35')],qs[_0x56c3('0x48')](_0x270108['query'][_0x56c3('0x48')]));_0x274bc5[_0x56c3('0x3b')]=_0x274bc5[_0x56c3('0x3b')][_0x56c3('0x49')]?_0x274bc5[_0x56c3('0x3b')]:_0x46b4f4[_0x56c3('0x35')];if(!_0x270108[_0x56c3('0x38')][_0x56c3('0x3c')](_0x56c3('0x3d'))){_0x274bc5[_0x56c3('0x1a')]=qs[_0x56c3('0x1a')](_0x270108[_0x56c3('0x38')][_0x56c3('0x1a')]);_0x274bc5[_0x56c3('0x18')]=qs[_0x56c3('0x18')](_0x270108[_0x56c3('0x38')][_0x56c3('0x18')]);}_0x274bc5[_0x56c3('0x5b')]=qs[_0x56c3('0x3e')](_0x270108['query'][_0x56c3('0x3e')]);_0x274bc5[_0x56c3('0x3f')]=qs[_0x56c3('0x39')](_[_0x56c3('0x40')](_0x270108['query'],_0x46b4f4[_0x56c3('0x39')]));_0x274bc5[_0x56c3('0x3f')][_0x56c3('0x5c')]=_0x3d324f['id'];if(_0x270108[_0x56c3('0x38')][_0x56c3('0x41')]){_0x274bc5[_0x56c3('0x3f')]=_[_0x56c3('0x29')](_0x274bc5[_0x56c3('0x3f')],{'$or':_[_0x56c3('0x36')](_0x274bc5[_0x56c3('0x3b')],function(_0x5268f8){var _0x5d6d62={};_0x5d6d62[_0x5268f8]={'$like':'%'+_0x270108[_0x56c3('0x38')][_0x56c3('0x41')]+'%'};return _0x5d6d62;})});}_0x274bc5=_[_0x56c3('0x29')]({},_0x274bc5,_0x270108[_0x56c3('0x54')]);return db[_0x56c3('0x60')][_0x56c3('0x1b')]({'where':_0x274bc5[_0x56c3('0x3f')]})['then'](function(_0x591764){_0x262486[_0x56c3('0x1b')]=_0x591764;if(_0x270108[_0x56c3('0x38')][_0x56c3('0x4a')]){_0x274bc5[_0x56c3('0x42')]=[{'all':!![]}];}return db[_0x56c3('0x60')][_0x56c3('0x43')](_0x274bc5);})[_0x56c3('0x20')](function(_0x5f5596){_0x262486[_0x56c3('0x44')]=_0x5f5596;return _0x262486;});}})[_0x56c3('0x20')](respondWithFilteredResult(_0x530ffe,_0x274bc5))['catch'](handleError(_0x530ffe,null));};exports[_0x56c3('0x61')]=function(_0x5532ca,_0x2136dc,_0x2a2fa5){var _0xdc6fd2={'raw':!![],'where':{}};var _0x387460={};var _0x4cbf93={'count':0x0,'rows':[]};return db[_0x56c3('0x31')][_0x56c3('0x5f')]({'where':{'id':_0x5532ca[_0x56c3('0x46')]['id']}})['then'](handleEntityNotFound(_0x2136dc,null))[_0x56c3('0x20')](function(_0xea91f1){if(_0xea91f1){_0x387460[_0x56c3('0x35')]=_['keys'](db[_0x56c3('0x62')]['rawAttributes']);_0x387460[_0x56c3('0x38')]=_[_0x56c3('0x37')](_0x5532ca[_0x56c3('0x38')]);_0x387460[_0x56c3('0x39')]=_[_0x56c3('0x3a')](_0x387460[_0x56c3('0x35')],_0x387460[_0x56c3('0x38')]);_0xdc6fd2[_0x56c3('0x3b')]=_[_0x56c3('0x3a')](_0x387460[_0x56c3('0x35')],qs[_0x56c3('0x48')](_0x5532ca[_0x56c3('0x38')][_0x56c3('0x48')]));_0xdc6fd2[_0x56c3('0x3b')]=_0xdc6fd2[_0x56c3('0x3b')][_0x56c3('0x49')]?_0xdc6fd2[_0x56c3('0x3b')]:_0x387460[_0x56c3('0x35')];if(!_0x5532ca[_0x56c3('0x38')][_0x56c3('0x3c')]('nolimit')){_0xdc6fd2['limit']=qs[_0x56c3('0x1a')](_0x5532ca[_0x56c3('0x38')][_0x56c3('0x1a')]);_0xdc6fd2['offset']=qs['offset'](_0x5532ca[_0x56c3('0x38')][_0x56c3('0x18')]);}_0xdc6fd2[_0x56c3('0x5b')]=qs[_0x56c3('0x3e')](_0x5532ca[_0x56c3('0x38')]['sort']);_0xdc6fd2[_0x56c3('0x3f')]=qs[_0x56c3('0x39')](_[_0x56c3('0x40')](_0x5532ca['query'],_0x387460[_0x56c3('0x39')]));_0xdc6fd2[_0x56c3('0x3f')][_0x56c3('0x5c')]=_0xea91f1['id'];if(_0x5532ca[_0x56c3('0x38')]['filter']){_0xdc6fd2['where']=_[_0x56c3('0x29')](_0xdc6fd2['where'],{'$or':_['map'](_0xdc6fd2[_0x56c3('0x3b')],function(_0x4e7236){var _0x44ad8b={};_0x44ad8b[_0x4e7236]={'$like':'%'+_0x5532ca['query']['filter']+'%'};return _0x44ad8b;})});}_0xdc6fd2=_['merge']({},_0xdc6fd2,_0x5532ca[_0x56c3('0x54')]);return db['CmHopperFinal'][_0x56c3('0x1b')]({'where':_0xdc6fd2[_0x56c3('0x3f')]})['then'](function(_0x1829da){_0x4cbf93[_0x56c3('0x1b')]=_0x1829da;if(_0x5532ca[_0x56c3('0x38')]['includeAll']){_0xdc6fd2[_0x56c3('0x42')]=[{'all':!![]}];}return db[_0x56c3('0x62')][_0x56c3('0x43')](_0xdc6fd2);})['then'](function(_0x4c83f3){_0x4cbf93['rows']=_0x4c83f3;return _0x4cbf93;});}})[_0x56c3('0x20')](respondWithFilteredResult(_0x2136dc,_0xdc6fd2))['catch'](handleError(_0x2136dc,null));};exports['getHopperBlacks']=function(_0x2886af,_0x17dbac,_0x14e652){var _0x451cfb={'raw':!![],'where':{}};var _0x2fbd70={};var _0xf7df66={'count':0x0,'rows':[]};return db[_0x56c3('0x31')][_0x56c3('0x5f')]({'where':{'id':_0x2886af['params']['id']}})['then'](handleEntityNotFound(_0x17dbac,null))[_0x56c3('0x20')](function(_0x107f54){if(_0x107f54){_0x2fbd70[_0x56c3('0x35')]=_['keys'](db[_0x56c3('0x63')]['rawAttributes']);_0x2fbd70[_0x56c3('0x38')]=_[_0x56c3('0x37')](_0x2886af['query']);_0x2fbd70[_0x56c3('0x39')]=_[_0x56c3('0x3a')](_0x2fbd70[_0x56c3('0x35')],_0x2fbd70[_0x56c3('0x38')]);_0x451cfb[_0x56c3('0x3b')]=_['intersection'](_0x2fbd70['model'],qs[_0x56c3('0x48')](_0x2886af[_0x56c3('0x38')][_0x56c3('0x48')]));_0x451cfb[_0x56c3('0x3b')]=_0x451cfb[_0x56c3('0x3b')][_0x56c3('0x49')]?_0x451cfb['attributes']:_0x2fbd70['model'];if(!_0x2886af[_0x56c3('0x38')]['hasOwnProperty'](_0x56c3('0x3d'))){_0x451cfb[_0x56c3('0x1a')]=qs[_0x56c3('0x1a')](_0x2886af[_0x56c3('0x38')][_0x56c3('0x1a')]);_0x451cfb[_0x56c3('0x18')]=qs[_0x56c3('0x18')](_0x2886af[_0x56c3('0x38')][_0x56c3('0x18')]);}_0x451cfb[_0x56c3('0x5b')]=qs['sort'](_0x2886af[_0x56c3('0x38')][_0x56c3('0x3e')]);_0x451cfb[_0x56c3('0x3f')]=qs[_0x56c3('0x39')](_['pick'](_0x2886af['query'],_0x2fbd70[_0x56c3('0x39')]));_0x451cfb[_0x56c3('0x3f')][_0x56c3('0x5c')]=_0x107f54['id'];if(_0x2886af[_0x56c3('0x38')][_0x56c3('0x41')]){_0x451cfb['where']=_[_0x56c3('0x29')](_0x451cfb[_0x56c3('0x3f')],{'$or':_[_0x56c3('0x36')](_0x451cfb[_0x56c3('0x3b')],function(_0x18270e){var _0x7dd8b2={};_0x7dd8b2[_0x18270e]={'$like':'%'+_0x2886af[_0x56c3('0x38')][_0x56c3('0x41')]+'%'};return _0x7dd8b2;})});}_0x451cfb=_['merge']({},_0x451cfb,_0x2886af[_0x56c3('0x54')]);return db[_0x56c3('0x63')][_0x56c3('0x1b')]({'where':_0x451cfb[_0x56c3('0x3f')]})[_0x56c3('0x20')](function(_0x4ac841){_0xf7df66[_0x56c3('0x1b')]=_0x4ac841;if(_0x2886af[_0x56c3('0x38')][_0x56c3('0x4a')]){_0x451cfb['include']=[{'all':!![]}];}return db['CmHopperBlack']['findAll'](_0x451cfb);})[_0x56c3('0x20')](function(_0x4e6e62){_0xf7df66[_0x56c3('0x44')]=_0x4e6e62;return _0xf7df66;});}})['then'](respondWithFilteredResult(_0x17dbac,_0x451cfb))[_0x56c3('0x45')](handleError(_0x17dbac,null));};exports['getLists']=function(_0x1808e1,_0x5a6a58,_0x412de5){var _0x4ac9b0={};var _0x5cd4bb={};var _0x3a17ec;var _0x40b689;return db[_0x56c3('0x31')][_0x56c3('0x5f')]({'where':{'id':_0x1808e1[_0x56c3('0x46')]['id']}})['then'](handleEntityNotFound(_0x5a6a58,null))[_0x56c3('0x20')](function(_0x324880){if(_0x324880){_0x3a17ec=_0x324880;_0x5cd4bb['model']=_[_0x56c3('0x37')](db[_0x56c3('0x64')][_0x56c3('0x47')]);_0x5cd4bb[_0x56c3('0x38')]=_['keys'](_0x1808e1[_0x56c3('0x38')]);_0x5cd4bb[_0x56c3('0x39')]=_['intersection'](_0x5cd4bb[_0x56c3('0x35')],_0x5cd4bb[_0x56c3('0x38')]);_0x4ac9b0['attributes']=_['intersection'](_0x5cd4bb[_0x56c3('0x35')],qs[_0x56c3('0x48')](_0x1808e1[_0x56c3('0x38')][_0x56c3('0x48')]));_0x4ac9b0['attributes']=_0x4ac9b0[_0x56c3('0x3b')][_0x56c3('0x49')]?_0x4ac9b0[_0x56c3('0x3b')]:_0x5cd4bb[_0x56c3('0x35')];_0x4ac9b0['order']=qs['sort'](_0x1808e1['query'][_0x56c3('0x3e')]);_0x4ac9b0[_0x56c3('0x3f')]=qs[_0x56c3('0x39')](_[_0x56c3('0x40')](_0x1808e1[_0x56c3('0x38')],_0x5cd4bb['filters']));if(_0x1808e1[_0x56c3('0x38')]['filter']){_0x4ac9b0[_0x56c3('0x3f')]=_[_0x56c3('0x29')](_0x4ac9b0[_0x56c3('0x3f')],{'$or':_[_0x56c3('0x36')](_0x4ac9b0['attributes'],function(_0x568625){var _0x993612={};_0x993612[_0x568625]={'$like':'%'+_0x1808e1['query'][_0x56c3('0x41')]+'%'};return _0x993612;})});}_0x4ac9b0=_[_0x56c3('0x29')]({},_0x4ac9b0,_0x1808e1[_0x56c3('0x54')]);return _0x3a17ec[_0x56c3('0x65')](_0x4ac9b0);}})[_0x56c3('0x20')](function(_0x1af0a1){if(_0x1af0a1){_0x40b689=_0x1af0a1[_0x56c3('0x49')];if(!_0x1808e1['query'][_0x56c3('0x3c')](_0x56c3('0x3d'))){_0x4ac9b0[_0x56c3('0x1a')]=qs[_0x56c3('0x1a')](_0x1808e1[_0x56c3('0x38')]['limit']);_0x4ac9b0[_0x56c3('0x18')]=qs[_0x56c3('0x18')](_0x1808e1[_0x56c3('0x38')][_0x56c3('0x18')]);}return _0x3a17ec[_0x56c3('0x65')](_0x4ac9b0);}})[_0x56c3('0x20')](function(_0x4b6815){if(_0x4b6815){return _0x4b6815?{'count':_0x40b689,'rows':_0x4b6815}:null;}})[_0x56c3('0x20')](respondWithResult(_0x5a6a58,null))[_0x56c3('0x45')](handleError(_0x5a6a58,null));};exports[_0x56c3('0x66')]=function(_0x279b55,_0xd5c2a0,_0x4a1791){var _0x1b5e05,_0x3afeb3;return db[_0x56c3('0x31')][_0x56c3('0x4b')]({'where':{'id':_0x279b55[_0x56c3('0x46')]['id']}})[_0x56c3('0x20')](handleEntityNotFound(_0xd5c2a0,null))[_0x56c3('0x20')](function(_0x2da5d4){if(_0x2da5d4){_0x3afeb3=_0x2da5d4;return _0x2da5d4[_0x56c3('0x66')](_0x279b55[_0x56c3('0x2a')][_0x56c3('0x67')],_[_0x56c3('0x56')](_0x279b55['body'],[_0x56c3('0x67'),'id'])||{});}return null;})[_0x56c3('0x68')](function(_0x350bec){var _0x2045ce;_0x1b5e05=_0x350bec||[];var _0x2f2ac7=[];if(_0x350bec){for(var _0xe25f75=0x0;_0xe25f75<_0x350bec['length'];_0xe25f75+=0x1){var _0x5d50d5=_0x350bec[_0xe25f75][_0x56c3('0x4e')]({'plain':!![]});_0x3afeb3[_0x56c3('0x69')]=_0x279b55[_0x56c3('0x2a')][_0x56c3('0x69')]?_0x279b55['body'][_0x56c3('0x69')]:_0x3afeb3[_0x56c3('0x69')];switch(_0x3afeb3[_0x56c3('0x69')]){case _0x56c3('0x6a'):_0x2045ce=squel[_0x56c3('0x6b')]()[_0x56c3('0x6c')](_0x56c3('0x6d'))['fromQuery'](['phone',_0x56c3('0x6e'),_0x56c3('0x6f'),'ListId','CampaignId',_0x56c3('0x57'),_0x56c3('0x55')],squel[_0x56c3('0x70')]()[_0x56c3('0x71')](_0x56c3('0x72'),_0x56c3('0x72'))['field'](_0x56c3('0x73'),'scheduledAt')[_0x56c3('0x71')]('id','ContactId')[_0x56c3('0x71')](_0x5d50d5['CmListId'][_0x56c3('0x74')](),_0x56c3('0x75'))[_0x56c3('0x71')](_0x279b55[_0x56c3('0x46')]['id'][_0x56c3('0x74')](),_0x56c3('0x5c'))[_0x56c3('0x71')]('NOW()','createdAt')[_0x56c3('0x71')](_0x56c3('0x73'),_0x56c3('0x55'))[_0x56c3('0x76')](_0x56c3('0x77'))[_0x56c3('0x3f')](_0x56c3('0x78'))[_0x56c3('0x3f')](_0x56c3('0x79'),_0x5d50d5[_0x56c3('0x7a')][_0x56c3('0x74')]())[_0x56c3('0x3f')](_0x56c3('0x7b'))[_0x56c3('0x3f')](_0x56c3('0x7c'),squel[_0x56c3('0x70')]()[_0x56c3('0x71')]('COALESCE(calleridnum,\x27\x27)')[_0x56c3('0x76')]('cm_hopper_final')[_0x56c3('0x3f')](_0x56c3('0x7d'),_0x279b55[_0x56c3('0x46')]['id']['toString']()))[_0x56c3('0x3f')](_0x56c3('0x7c'),squel[_0x56c3('0x70')]()['field']('COALESCE(phone,\x27\x27)')[_0x56c3('0x76')](_0x56c3('0x6d'))[_0x56c3('0x3f')]('CampaignId\x20=\x20?',_0x279b55['params']['id'][_0x56c3('0x74')]())))[_0x56c3('0x74')]();break;case _0x56c3('0x7e'):_0x2045ce=squel[_0x56c3('0x6b')]()[_0x56c3('0x6c')](_0x56c3('0x6d'))[_0x56c3('0x7f')]([_0x56c3('0x72'),'scheduledAt','ContactId',_0x56c3('0x75'),_0x56c3('0x5c'),_0x56c3('0x57'),'updatedAt'],squel['select']()[_0x56c3('0x71')](_0x56c3('0x72'),_0x56c3('0x72'))[_0x56c3('0x71')]('NOW()',_0x56c3('0x6e'))[_0x56c3('0x71')]('id',_0x56c3('0x6f'))[_0x56c3('0x71')](_0x5d50d5['CmListId']['toString'](),_0x56c3('0x75'))['field'](_0x279b55[_0x56c3('0x46')]['id']['toString'](),'CampaignId')[_0x56c3('0x71')](_0x56c3('0x73'),_0x56c3('0x57'))['field'](_0x56c3('0x73'),_0x56c3('0x55'))[_0x56c3('0x76')](_0x56c3('0x77'))[_0x56c3('0x3f')](_0x56c3('0x78'))[_0x56c3('0x3f')](_0x56c3('0x79'),_0x5d50d5[_0x56c3('0x7a')][_0x56c3('0x74')]())[_0x56c3('0x3f')](_0x56c3('0x7b'))['where'](_0x56c3('0x7c'),squel[_0x56c3('0x70')]()[_0x56c3('0x71')](_0x56c3('0x80'))[_0x56c3('0x76')](_0x56c3('0x6d'))[_0x56c3('0x3f')](_0x56c3('0x7d'),_0x279b55[_0x56c3('0x46')]['id']['toString']())))[_0x56c3('0x74')]();break;default:_0x2045ce=squel[_0x56c3('0x6b')]()[_0x56c3('0x6c')](_0x56c3('0x6d'))[_0x56c3('0x7f')]([_0x56c3('0x72'),_0x56c3('0x6e'),_0x56c3('0x6f'),_0x56c3('0x75'),'CampaignId',_0x56c3('0x57'),_0x56c3('0x55')],squel[_0x56c3('0x70')]()[_0x56c3('0x71')]('phone',_0x56c3('0x72'))[_0x56c3('0x71')](_0x56c3('0x73'),'scheduledAt')[_0x56c3('0x71')]('id',_0x56c3('0x6f'))['field'](_0x5d50d5[_0x56c3('0x7a')][_0x56c3('0x74')](),_0x56c3('0x75'))[_0x56c3('0x71')](_0x279b55['params']['id'][_0x56c3('0x74')](),_0x56c3('0x5c'))[_0x56c3('0x71')](_0x56c3('0x73'),_0x56c3('0x57'))[_0x56c3('0x71')](_0x56c3('0x73'),'updatedAt')[_0x56c3('0x76')](_0x56c3('0x77'))['where'](_0x56c3('0x78'))[_0x56c3('0x3f')](_0x56c3('0x79'),_0x5d50d5[_0x56c3('0x7a')][_0x56c3('0x74')]())[_0x56c3('0x3f')](_0x56c3('0x7b')))[_0x56c3('0x74')]();}_0x2f2ac7[_0x56c3('0x81')](db[_0x56c3('0x82')][_0x56c3('0x38')](_0x2045ce));}return BPromise[_0x56c3('0x83')](_0x2f2ac7);}})[_0x56c3('0x20')](function(){return _0x1b5e05;})[_0x56c3('0x20')](respondWithResult(_0xd5c2a0,null))[_0x56c3('0x45')](handleError(_0xd5c2a0,null));};exports[_0x56c3('0x84')]=function(_0x40838e,_0x33fc65,_0xae715a){return db[_0x56c3('0x31')][_0x56c3('0x4b')]({'where':{'id':_0x40838e[_0x56c3('0x46')]['id']}})[_0x56c3('0x20')](handleEntityNotFound(_0x33fc65,null))[_0x56c3('0x20')](function(_0x523310){if(_0x523310){return _0x523310[_0x56c3('0x84')](_0x40838e['query']['ids']);}})['then'](function(_0x2fee2f){if(_0x2fee2f){return db[_0x56c3('0x5d')]['destroy']({'where':{'ListId':_0x40838e[_0x56c3('0x38')][_0x56c3('0x67')],'CampaignId':_0x40838e['params']['id']}})[_0x56c3('0x20')](function(){return _0x2fee2f;});}})[_0x56c3('0x20')](respondWithStatusCode(_0x33fc65,null))[_0x56c3('0x45')](handleError(_0x33fc65,null));};exports[_0x56c3('0x85')]=function(_0x3dfd59,_0x3c96db,_0x36e684){var _0x313cb1={};var _0x3cf3fd={};var _0x540264;var _0x35fdf8;return db[_0x56c3('0x31')][_0x56c3('0x5f')]({'where':{'id':_0x3dfd59[_0x56c3('0x46')]['id']}})[_0x56c3('0x20')](handleEntityNotFound(_0x3c96db,null))['then'](function(_0x1e1531){if(_0x1e1531){_0x540264=_0x1e1531;_0x3cf3fd[_0x56c3('0x35')]=_[_0x56c3('0x37')](db[_0x56c3('0x64')][_0x56c3('0x47')]);_0x3cf3fd[_0x56c3('0x38')]=_[_0x56c3('0x37')](_0x3dfd59[_0x56c3('0x38')]);_0x3cf3fd[_0x56c3('0x39')]=_['intersection'](_0x3cf3fd['model'],_0x3cf3fd[_0x56c3('0x38')]);_0x313cb1[_0x56c3('0x3b')]=_['intersection'](_0x3cf3fd[_0x56c3('0x35')],qs[_0x56c3('0x48')](_0x3dfd59['query']['fields']));_0x313cb1['attributes']=_0x313cb1[_0x56c3('0x3b')][_0x56c3('0x49')]?_0x313cb1['attributes']:_0x3cf3fd[_0x56c3('0x35')];_0x313cb1[_0x56c3('0x5b')]=qs[_0x56c3('0x3e')](_0x3dfd59['query'][_0x56c3('0x3e')]);_0x313cb1[_0x56c3('0x3f')]=qs[_0x56c3('0x39')](_[_0x56c3('0x40')](_0x3dfd59[_0x56c3('0x38')],_0x3cf3fd[_0x56c3('0x39')]));if(_0x3dfd59[_0x56c3('0x38')][_0x56c3('0x41')]){_0x313cb1[_0x56c3('0x3f')]=_[_0x56c3('0x29')](_0x313cb1[_0x56c3('0x3f')],{'$or':_[_0x56c3('0x36')](_0x313cb1[_0x56c3('0x3b')],function(_0x19c6a6){var _0x1295d4={};_0x1295d4[_0x19c6a6]={'$like':'%'+_0x3dfd59[_0x56c3('0x38')][_0x56c3('0x41')]+'%'};return _0x1295d4;})});}_0x313cb1=_[_0x56c3('0x29')]({},_0x313cb1,_0x3dfd59[_0x56c3('0x54')]);return _0x540264['getBlackLists'](_0x313cb1);}})[_0x56c3('0x20')](function(_0x48a4df){if(_0x48a4df){_0x35fdf8=_0x48a4df[_0x56c3('0x49')];if(!_0x3dfd59[_0x56c3('0x38')][_0x56c3('0x3c')](_0x56c3('0x3d'))){_0x313cb1['limit']=qs[_0x56c3('0x1a')](_0x3dfd59[_0x56c3('0x38')][_0x56c3('0x1a')]);_0x313cb1[_0x56c3('0x18')]=qs[_0x56c3('0x18')](_0x3dfd59[_0x56c3('0x38')][_0x56c3('0x18')]);}return _0x540264[_0x56c3('0x85')](_0x313cb1);}})[_0x56c3('0x20')](function(_0x96fbe1){if(_0x96fbe1){return _0x96fbe1?{'count':_0x35fdf8,'rows':_0x96fbe1}:null;}})[_0x56c3('0x20')](respondWithResult(_0x3c96db,null))[_0x56c3('0x45')](handleError(_0x3c96db,null));};exports['addBlackLists']=function(_0x24fdb1,_0x296927,_0x3a72bc){var _0x31cb74,_0x45fa3a;return db[_0x56c3('0x31')][_0x56c3('0x4b')]({'where':{'id':_0x24fdb1[_0x56c3('0x46')]['id']}})['then'](handleEntityNotFound(_0x296927,null))[_0x56c3('0x20')](function(_0x527e33){if(_0x527e33){_0x45fa3a=_0x527e33;return _0x527e33[_0x56c3('0x86')](_0x24fdb1[_0x56c3('0x2a')]['ids'],_[_0x56c3('0x56')](_0x24fdb1[_0x56c3('0x2a')],[_0x56c3('0x67'),'id'])||{});}return null;})[_0x56c3('0x68')](function(_0x4fc864){var _0xe29d7;_0x31cb74=_0x4fc864||[];var _0x5a8290=[];if(_0x4fc864){for(var _0x45c428=0x0;_0x45c428<_0x4fc864[_0x56c3('0x49')];_0x45c428+=0x1){var _0x397948=_0x4fc864[_0x45c428][_0x56c3('0x4e')]({'plain':!![]});_0xe29d7=squel['insert']()[_0x56c3('0x6c')](_0x56c3('0x87'))['fromQuery']([_0x56c3('0x72'),_0x56c3('0x6f'),_0x56c3('0x75'),_0x56c3('0x5c'),_0x56c3('0x57'),_0x56c3('0x55')],squel[_0x56c3('0x70')]()[_0x56c3('0x71')](_0x56c3('0x72'),_0x56c3('0x72'))[_0x56c3('0x71')]('id',_0x56c3('0x6f'))[_0x56c3('0x71')](_0x397948[_0x56c3('0x7a')]['toString'](),_0x56c3('0x75'))[_0x56c3('0x71')](_0x24fdb1[_0x56c3('0x46')]['id'][_0x56c3('0x74')](),'CampaignId')[_0x56c3('0x71')](_0x56c3('0x73'),'createdAt')[_0x56c3('0x71')](_0x56c3('0x73'),_0x56c3('0x55'))[_0x56c3('0x76')](_0x56c3('0x77'))['where'](_0x56c3('0x78'))[_0x56c3('0x3f')]('ListId\x20=\x20?',_0x397948[_0x56c3('0x7a')][_0x56c3('0x74')]())[_0x56c3('0x3f')](_0x56c3('0x7b')))[_0x56c3('0x74')]();_0x5a8290[_0x56c3('0x81')](db[_0x56c3('0x82')][_0x56c3('0x38')](_0xe29d7));}return BPromise[_0x56c3('0x83')](_0x5a8290);}})[_0x56c3('0x20')](function(){return _0x31cb74;})[_0x56c3('0x20')](respondWithResult(_0x296927,null))[_0x56c3('0x45')](handleError(_0x296927,null));};exports[_0x56c3('0x88')]=function(_0xebbc0c,_0x3f4643,_0x2318f0){return db['Campaign'][_0x56c3('0x4b')]({'where':{'id':_0xebbc0c[_0x56c3('0x46')]['id']}})['then'](handleEntityNotFound(_0x3f4643,null))[_0x56c3('0x20')](function(_0x5d3f7f){if(_0x5d3f7f){return _0x5d3f7f[_0x56c3('0x88')](_0xebbc0c[_0x56c3('0x38')][_0x56c3('0x67')]);}})[_0x56c3('0x20')](function(_0x44d9ba){if(_0x44d9ba){return db['CmHopperBlack'][_0x56c3('0x21')]({'where':{'ListId':_0xebbc0c['query'][_0x56c3('0x67')],'CampaignId':_0xebbc0c[_0x56c3('0x46')]['id']}})[_0x56c3('0x20')](function(){return _0x44d9ba;});}})[_0x56c3('0x20')](respondWithStatusCode(_0x3f4643,null))[_0x56c3('0x45')](handleError(_0x3f4643,null));};