[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 _0x586a=['fromQuery','phone','scheduledAt','ContactId','select','field','NOW()','CmListId','toString','ListId','from','cm_contacts','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','COALESCE(phone,\x27\x27)','cm_hopper','into','phone\x20NOT\x20IN\x20(?)','CampaignId\x20=\x20?','push','sequelize','removeLists','getBlackLists','addBlackLists','cm_hopper_black','phone\x20IS\x20NOT\x20NULL','all','removeBlackLists','html-pdf','eml-format','fast-json-patch','request-promise','bluebird','mustache','util','path','to-csv','lodash','squel','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','status','end','count','offset','limit','set','Content-Range','json','apply','save','then','get','UserProfileResource','destroy','sendStatus','error','stack','name','send','Campaign','rawAttributes','fieldName','type','model','map','query','keys','intersection','fields','attributes','hasOwnProperty','order','sort','where','filters','pick','filter','merge','VIRTUAL','options','findAll','catch','show','length','includeAll','include','create','body','user','IvrCampaigns','find','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','params','createdAt','updatedAt','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','update','getHoppers','findOne','CmHopper','nolimit','CampaignId','rows','CmHopperHistory','getHopperFinals','CmHopperFinal','getHopperBlacks','CmHopperBlack','getLists','CmList','addLists','omit','ids','spread','dialCheckDuplicateType','insert'];(function(_0x24e3aa,_0x12af36){var _0x3d9a41=function(_0x10d2d2){while(--_0x10d2d2){_0x24e3aa['push'](_0x24e3aa['shift']());}};_0x3d9a41(++_0x12af36);}(_0x586a,0x1a8));var _0xa586=function(_0x100375,_0x1fbd60){_0x100375=_0x100375-0x0;var _0x207472=_0x586a[_0x100375];return _0x207472;};'use strict';var pdf=require(_0xa586('0x0'));var emlformat=require(_0xa586('0x1'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0xa586('0x2'));var rp=require(_0xa586('0x3'));var moment=require('moment');var BPromise=require(_0xa586('0x4'));var Mustache=require(_0xa586('0x5'));var util=require(_0xa586('0x6'));var path=require(_0xa586('0x7'));var sox=require('sox');var csv=require(_0xa586('0x8'));var ejs=require('ejs');var fs=require('fs');var _=require(_0xa586('0x9'));var squel=require(_0xa586('0xa'));var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require(_0xa586('0xb'));var toCsv=require(_0xa586('0x8'));var querystring=require(_0xa586('0xc'));var Papa=require(_0xa586('0xd'));var Redis=require(_0xa586('0xe'));var authService=require(_0xa586('0xf'));var qs=require(_0xa586('0x10'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xa586('0x11'));var logger=require(_0xa586('0x12'))(_0xa586('0x13'));var utils=require(_0xa586('0x14'));var config=require(_0xa586('0x15'));var db=require(_0xa586('0x16'))['db'];function respondWithStatusCode(_0x5f27a7,_0x3f64a5){_0x3f64a5=_0x3f64a5||0xcc;return function(_0x390949){if(_0x390949){return _0x5f27a7['sendStatus'](_0x3f64a5);}return _0x5f27a7[_0xa586('0x17')](_0x3f64a5)[_0xa586('0x18')]();};}function respondWithResult(_0x2e9a46,_0x5c7cff){_0x5c7cff=_0x5c7cff||0xc8;return function(_0x2a1716){if(_0x2a1716){return _0x2e9a46[_0xa586('0x17')](_0x5c7cff)['json'](_0x2a1716);}};}function respondWithFilteredResult(_0x5de39a,_0x566910){return function(_0x24fa9d){if(_0x24fa9d){var _0x2ac1f6=_0x24fa9d[_0xa586('0x19')],_0x380cf1=_0x566910[_0xa586('0x1a')],_0x201480=_0x566910[_0xa586('0x1a')]+_0x566910[_0xa586('0x1b')],_0x8a3bd0;if(_0x201480>=_0x2ac1f6){_0x201480=_0x2ac1f6;_0x8a3bd0=0xc8;}else{_0x8a3bd0=0xce;}_0x5de39a[_0xa586('0x17')](_0x8a3bd0);return _0x5de39a[_0xa586('0x1c')](_0xa586('0x1d'),_0x380cf1+'-'+_0x201480+'/'+_0x2ac1f6)[_0xa586('0x1e')](_0x24fa9d);}return null;};}function patchUpdates(_0x41c413){return function(_0x5be33d){try{jsonpatch[_0xa586('0x1f')](_0x5be33d,_0x41c413,!![]);}catch(_0x4f622b){return BPromise['reject'](_0x4f622b);}return _0x5be33d[_0xa586('0x20')]();};}function saveUpdates(_0x4b7799,_0x25557a){return function(_0x23f9c0){if(_0x23f9c0){return _0x23f9c0['update'](_0x4b7799)[_0xa586('0x21')](function(_0x479713){return _0x479713;});}return null;};}function removeEntity(_0x389861,_0x4be65a){return function(_0x105fc4){if(_0x105fc4){return _0x105fc4['destroy']()[_0xa586('0x21')](function(){var _0x48a4e2=_0x105fc4[_0xa586('0x22')]({'plain':!![]});var _0x17adec='IvrCampaigns';return db[_0xa586('0x23')][_0xa586('0x24')]({'where':{'type':_0x17adec,'resourceId':_0x48a4e2['id']}})['then'](function(){return _0x105fc4;});})[_0xa586('0x21')](function(){_0x389861[_0xa586('0x17')](0xcc)[_0xa586('0x18')]();});}};}function handleEntityNotFound(_0x3a9b3d,_0xc10dac){return function(_0x592a80){if(!_0x592a80){_0x3a9b3d[_0xa586('0x25')](0x194);}return _0x592a80;};}function handleError(_0x1f72fc,_0x1421c0){_0x1421c0=_0x1421c0||0x1f4;return function(_0x4155cd){logger[_0xa586('0x26')](_0x4155cd[_0xa586('0x27')]);if(_0x4155cd[_0xa586('0x28')]){delete _0x4155cd[_0xa586('0x28')];}_0x1f72fc['status'](_0x1421c0)[_0xa586('0x29')](_0x4155cd);};}exports['index']=function(_0x1976cd,_0x2d5022){var _0x148f47={},_0x3176a3={},_0x5e15f7={'count':0x0,'rows':[]};var _0x4d178b=_['map'](db[_0xa586('0x2a')][_0xa586('0x2b')],function(_0x64271d){return{'name':_0x64271d[_0xa586('0x2c')],'type':_0x64271d[_0xa586('0x2d')]['key']};});_0x3176a3[_0xa586('0x2e')]=_[_0xa586('0x2f')](_0x4d178b,_0xa586('0x28'));_0x3176a3[_0xa586('0x30')]=_[_0xa586('0x31')](_0x1976cd[_0xa586('0x30')]);_0x3176a3['filters']=_[_0xa586('0x32')](_0x3176a3[_0xa586('0x2e')],_0x3176a3['query']);_0x148f47['attributes']=_['intersection'](_0x3176a3[_0xa586('0x2e')],qs[_0xa586('0x33')](_0x1976cd[_0xa586('0x30')][_0xa586('0x33')]));_0x148f47[_0xa586('0x34')]=_0x148f47[_0xa586('0x34')]['length']?_0x148f47[_0xa586('0x34')]:_0x3176a3['model'];if(!_0x1976cd['query'][_0xa586('0x35')]('nolimit')){_0x148f47['limit']=qs['limit'](_0x1976cd[_0xa586('0x30')][_0xa586('0x1b')]);_0x148f47[_0xa586('0x1a')]=qs[_0xa586('0x1a')](_0x1976cd['query'][_0xa586('0x1a')]);}_0x148f47[_0xa586('0x36')]=qs[_0xa586('0x37')](_0x1976cd[_0xa586('0x30')][_0xa586('0x37')]);_0x148f47[_0xa586('0x38')]=qs[_0xa586('0x39')](_[_0xa586('0x3a')](_0x1976cd['query'],_0x3176a3['filters']),_0x4d178b);if(_0x1976cd[_0xa586('0x30')][_0xa586('0x3b')]){_0x148f47[_0xa586('0x38')]=_[_0xa586('0x3c')](_0x148f47[_0xa586('0x38')],{'$or':_[_0xa586('0x2f')](_0x4d178b,function(_0x2c1ed3){if(_0x2c1ed3[_0xa586('0x2d')]!==_0xa586('0x3d')){var _0x2445f8={};_0x2445f8[_0x2c1ed3[_0xa586('0x28')]]={'$like':'%'+_0x1976cd['query']['filter']+'%'};return _0x2445f8;}})});}_0x148f47=_[_0xa586('0x3c')]({},_0x148f47,_0x1976cd[_0xa586('0x3e')]);var _0x53dfdd={'where':_0x148f47[_0xa586('0x38')]};return db['Campaign'][_0xa586('0x19')](_0x53dfdd)[_0xa586('0x21')](function(_0x239597){_0x5e15f7[_0xa586('0x19')]=_0x239597;if(_0x1976cd['query']['includeAll']){_0x148f47['include']=[{'all':!![]}];}return db['Campaign'][_0xa586('0x3f')](_0x148f47);})['then'](function(_0x57d0be){_0x5e15f7['rows']=_0x57d0be;return _0x5e15f7;})[_0xa586('0x21')](respondWithFilteredResult(_0x2d5022,_0x148f47))[_0xa586('0x40')](handleError(_0x2d5022,null));};exports[_0xa586('0x41')]=function(_0x1e1f00,_0x4e56c0){var _0x3e80fc={'raw':![],'where':{'id':_0x1e1f00['params']['id']}},_0x5bd684={};_0x5bd684['model']=_[_0xa586('0x31')](db['Campaign']['rawAttributes']);_0x5bd684[_0xa586('0x30')]=_[_0xa586('0x31')](_0x1e1f00[_0xa586('0x30')]);_0x5bd684[_0xa586('0x39')]=_[_0xa586('0x32')](_0x5bd684[_0xa586('0x2e')],_0x5bd684[_0xa586('0x30')]);_0x3e80fc[_0xa586('0x34')]=_[_0xa586('0x32')](_0x5bd684[_0xa586('0x2e')],qs[_0xa586('0x33')](_0x1e1f00[_0xa586('0x30')]['fields']));_0x3e80fc['attributes']=_0x3e80fc[_0xa586('0x34')][_0xa586('0x42')]?_0x3e80fc[_0xa586('0x34')]:_0x5bd684[_0xa586('0x2e')];if(_0x1e1f00[_0xa586('0x30')][_0xa586('0x43')]){_0x3e80fc[_0xa586('0x44')]=[{'all':!![]}];}_0x3e80fc=_[_0xa586('0x3c')]({},_0x3e80fc,_0x1e1f00[_0xa586('0x3e')]);return db[_0xa586('0x2a')]['find'](_0x3e80fc)[_0xa586('0x21')](handleEntityNotFound(_0x4e56c0,null))[_0xa586('0x21')](respondWithResult(_0x4e56c0,null))[_0xa586('0x40')](handleError(_0x4e56c0,null));};exports[_0xa586('0x45')]=function(_0x5ed234,_0xd23ef9){return db['Campaign'][_0xa586('0x45')](_0x5ed234[_0xa586('0x46')],{})[_0xa586('0x21')](function(_0x50e972){var _0x35f3c0=_0x5ed234[_0xa586('0x47')][_0xa586('0x22')]({'plain':!![]});if(!_0x35f3c0)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x35f3c0['role']===_0xa586('0x47')){var _0x1aa35d=_0x50e972['get']({'plain':!![]});var _0xd6bb85=_0xa586('0x48');return db['UserProfileSection'][_0xa586('0x49')]({'where':{'name':_0xd6bb85,'userProfileId':_0x35f3c0[_0xa586('0x4a')]},'raw':!![]})[_0xa586('0x21')](function(_0x2fd17e){if(_0x2fd17e&&_0x2fd17e[_0xa586('0x4b')]===0x0){return db[_0xa586('0x23')][_0xa586('0x45')]({'name':_0x1aa35d[_0xa586('0x28')],'resourceId':_0x1aa35d['id'],'type':_0x2fd17e['name'],'sectionId':_0x2fd17e['id']},{})['then'](function(){return _0x50e972;});}else{return _0x50e972;}})[_0xa586('0x40')](function(_0x5379ca){logger[_0xa586('0x26')](_0xa586('0x4c'),_0x5379ca);throw _0x5379ca;});}return _0x50e972;})[_0xa586('0x21')](respondWithResult(_0xd23ef9,0xc9))[_0xa586('0x40')](handleError(_0xd23ef9,null));};exports[_0xa586('0x4d')]=function(_0x5762b0,_0x4b5b16){var _0x15b912={'where':{'id':_0x5762b0[_0xa586('0x4e')]['id']}},_0x300d66={};_0x300d66[_0xa586('0x2e')]=_[_0xa586('0x31')](db[_0xa586('0x2a')][_0xa586('0x2b')]);_0x15b912['attributes']=_[_0xa586('0x32')](_0x300d66[_0xa586('0x2e')],qs[_0xa586('0x33')](_0x5762b0[_0xa586('0x30')][_0xa586('0x33')]));_0x15b912[_0xa586('0x34')]=_0x15b912[_0xa586('0x34')]['length']?_0x15b912['attributes']:_0x300d66[_0xa586('0x2e')];if(_0x5762b0[_0xa586('0x30')]['includeAll']){_0x15b912['include']=[{'all':!![]}];}_0x15b912=_[_0xa586('0x3c')]({},_0x15b912,_0x5762b0[_0xa586('0x3e')]);return db[_0xa586('0x2a')]['find'](_0x15b912)[_0xa586('0x21')](handleEntityNotFound(_0x4b5b16,null))['then'](function(_0x1846dc){if(_0x1846dc){var _0x187498=_0x1846dc[_0xa586('0x22')]({'plain':!![]});_0x187498=qs['omit'](_0x187498,['id',_0xa586('0x4f'),_0xa586('0x50')]);_0x5762b0[_0xa586('0x46')]=_['omit'](_0x5762b0['body'],['id',_0xa586('0x4f'),_0xa586('0x50')]);return db[_0xa586('0x2a')][_0xa586('0x45')](_[_0xa586('0x3c')](_0x187498,_0x5762b0[_0xa586('0x46')]),{'include':_0x5762b0[_0xa586('0x30')][_0xa586('0x43')]?[{'all':!![]}]:undefined})['then'](function(_0xc87b5f){var _0x482dd6=_0x5762b0[_0xa586('0x47')][_0xa586('0x22')]({'plain':!![]});if(!_0x482dd6)throw new Error(_0xa586('0x51'));if(_0x482dd6[_0xa586('0x52')]===_0xa586('0x47')){var _0x4964f9=_0xc87b5f['get']({'plain':!![]});var _0x344a24=_0xa586('0x48');return db[_0xa586('0x53')]['find']({'where':{'name':_0x344a24,'userProfileId':_0x482dd6[_0xa586('0x4a')]},'raw':!![]})[_0xa586('0x21')](function(_0x5eb139){if(_0x5eb139&&_0x5eb139[_0xa586('0x4b')]===0x0){return db[_0xa586('0x23')][_0xa586('0x45')]({'name':_0x4964f9[_0xa586('0x28')],'resourceId':_0x4964f9['id'],'type':_0x5eb139['name'],'sectionId':_0x5eb139['id']},{})[_0xa586('0x21')](function(){return _0xc87b5f;});}else{return _0xc87b5f;}})[_0xa586('0x40')](function(_0x56de27){logger['error'](_0xa586('0x4c'),_0x56de27);throw _0x56de27;});}return _0xc87b5f;});}})[_0xa586('0x21')](respondWithResult(_0x4b5b16,0xc9))[_0xa586('0x40')](handleError(_0x4b5b16,null));};exports[_0xa586('0x54')]=function(_0x23970a,_0x53e883){if(_0x23970a[_0xa586('0x46')]['id']){delete _0x23970a[_0xa586('0x46')]['id'];}return db['Campaign'][_0xa586('0x49')]({'where':{'id':_0x23970a['params']['id']}})[_0xa586('0x21')](handleEntityNotFound(_0x53e883,null))[_0xa586('0x21')](saveUpdates(_0x23970a[_0xa586('0x46')],null))[_0xa586('0x21')](respondWithResult(_0x53e883,null))[_0xa586('0x40')](handleError(_0x53e883,null));};exports[_0xa586('0x24')]=function(_0x3b4561,_0x2fde78){return db['Campaign']['find']({'where':{'id':_0x3b4561[_0xa586('0x4e')]['id']}})[_0xa586('0x21')](handleEntityNotFound(_0x2fde78,null))[_0xa586('0x21')](removeEntity(_0x2fde78,null))['catch'](handleError(_0x2fde78,null));};exports[_0xa586('0x55')]=function(_0x51b906,_0x4a83b6,_0x3e5ab7){var _0x59319b={'raw':!![],'where':{}};var _0x10bfc6={};var _0x9b52e5={'count':0x0,'rows':[]};return db[_0xa586('0x2a')][_0xa586('0x56')]({'where':{'id':_0x51b906[_0xa586('0x4e')]['id']}})[_0xa586('0x21')](handleEntityNotFound(_0x4a83b6,null))['then'](function(_0x5bbdff){if(_0x5bbdff){_0x10bfc6['model']=_['keys'](db[_0xa586('0x57')][_0xa586('0x2b')]);_0x10bfc6[_0xa586('0x30')]=_[_0xa586('0x31')](_0x51b906['query']);_0x10bfc6['filters']=_['intersection'](_0x10bfc6[_0xa586('0x2e')],_0x10bfc6[_0xa586('0x30')]);_0x59319b[_0xa586('0x34')]=_['intersection'](_0x10bfc6['model'],qs[_0xa586('0x33')](_0x51b906['query'][_0xa586('0x33')]));_0x59319b[_0xa586('0x34')]=_0x59319b[_0xa586('0x34')][_0xa586('0x42')]?_0x59319b['attributes']:_0x10bfc6['model'];if(!_0x51b906['query']['hasOwnProperty'](_0xa586('0x58'))){_0x59319b[_0xa586('0x1b')]=qs[_0xa586('0x1b')](_0x51b906[_0xa586('0x30')][_0xa586('0x1b')]);_0x59319b[_0xa586('0x1a')]=qs[_0xa586('0x1a')](_0x51b906['query'][_0xa586('0x1a')]);}_0x59319b['order']=qs[_0xa586('0x37')](_0x51b906[_0xa586('0x30')][_0xa586('0x37')]);_0x59319b[_0xa586('0x38')]=qs[_0xa586('0x39')](_['pick'](_0x51b906[_0xa586('0x30')],_0x10bfc6[_0xa586('0x39')]));_0x59319b['where'][_0xa586('0x59')]=_0x5bbdff['id'];if(_0x51b906[_0xa586('0x30')][_0xa586('0x3b')]){_0x59319b['where']=_[_0xa586('0x3c')](_0x59319b[_0xa586('0x38')],{'$or':_[_0xa586('0x2f')](_0x59319b[_0xa586('0x34')],function(_0x3201c0){var _0xf30da0={};_0xf30da0[_0x3201c0]={'$like':'%'+_0x51b906[_0xa586('0x30')][_0xa586('0x3b')]+'%'};return _0xf30da0;})});}_0x59319b=_[_0xa586('0x3c')]({},_0x59319b,_0x51b906[_0xa586('0x3e')]);return db[_0xa586('0x57')]['count']({'where':_0x59319b[_0xa586('0x38')]})['then'](function(_0x72af43){_0x9b52e5[_0xa586('0x19')]=_0x72af43;if(_0x51b906[_0xa586('0x30')][_0xa586('0x43')]){_0x59319b[_0xa586('0x44')]=[{'all':!![]}];}return db['CmHopper'][_0xa586('0x3f')](_0x59319b);})['then'](function(_0x4ec50d){_0x9b52e5[_0xa586('0x5a')]=_0x4ec50d;return _0x9b52e5;});}})[_0xa586('0x21')](respondWithFilteredResult(_0x4a83b6,_0x59319b))['catch'](handleError(_0x4a83b6,null));};exports['getHopperHistories']=function(_0x4fb67c,_0x1f5c28,_0x4d9c31){var _0x3d5959={'raw':!![],'where':{}};var _0x2d4990={};var _0x1e9ece={'count':0x0,'rows':[]};return db['Campaign'][_0xa586('0x56')]({'where':{'id':_0x4fb67c[_0xa586('0x4e')]['id']}})[_0xa586('0x21')](handleEntityNotFound(_0x1f5c28,null))[_0xa586('0x21')](function(_0x48e652){if(_0x48e652){_0x2d4990[_0xa586('0x2e')]=_['keys'](db[_0xa586('0x5b')][_0xa586('0x2b')]);_0x2d4990[_0xa586('0x30')]=_[_0xa586('0x31')](_0x4fb67c[_0xa586('0x30')]);_0x2d4990[_0xa586('0x39')]=_[_0xa586('0x32')](_0x2d4990[_0xa586('0x2e')],_0x2d4990[_0xa586('0x30')]);_0x3d5959[_0xa586('0x34')]=_[_0xa586('0x32')](_0x2d4990[_0xa586('0x2e')],qs[_0xa586('0x33')](_0x4fb67c[_0xa586('0x30')]['fields']));_0x3d5959[_0xa586('0x34')]=_0x3d5959[_0xa586('0x34')][_0xa586('0x42')]?_0x3d5959[_0xa586('0x34')]:_0x2d4990[_0xa586('0x2e')];if(!_0x4fb67c[_0xa586('0x30')][_0xa586('0x35')]('nolimit')){_0x3d5959[_0xa586('0x1b')]=qs[_0xa586('0x1b')](_0x4fb67c[_0xa586('0x30')]['limit']);_0x3d5959[_0xa586('0x1a')]=qs[_0xa586('0x1a')](_0x4fb67c[_0xa586('0x30')][_0xa586('0x1a')]);}_0x3d5959[_0xa586('0x36')]=qs['sort'](_0x4fb67c[_0xa586('0x30')]['sort']);_0x3d5959[_0xa586('0x38')]=qs['filters'](_[_0xa586('0x3a')](_0x4fb67c[_0xa586('0x30')],_0x2d4990[_0xa586('0x39')]));_0x3d5959[_0xa586('0x38')]['CampaignId']=_0x48e652['id'];if(_0x4fb67c[_0xa586('0x30')][_0xa586('0x3b')]){_0x3d5959[_0xa586('0x38')]=_['merge'](_0x3d5959[_0xa586('0x38')],{'$or':_[_0xa586('0x2f')](_0x3d5959['attributes'],function(_0x14ddb5){var _0x4def33={};_0x4def33[_0x14ddb5]={'$like':'%'+_0x4fb67c['query'][_0xa586('0x3b')]+'%'};return _0x4def33;})});}_0x3d5959=_[_0xa586('0x3c')]({},_0x3d5959,_0x4fb67c['options']);return db[_0xa586('0x5b')][_0xa586('0x19')]({'where':_0x3d5959[_0xa586('0x38')]})[_0xa586('0x21')](function(_0x42967d){_0x1e9ece[_0xa586('0x19')]=_0x42967d;if(_0x4fb67c[_0xa586('0x30')][_0xa586('0x43')]){_0x3d5959[_0xa586('0x44')]=[{'all':!![]}];}return db['CmHopperHistory'][_0xa586('0x3f')](_0x3d5959);})['then'](function(_0x2337fa){_0x1e9ece[_0xa586('0x5a')]=_0x2337fa;return _0x1e9ece;});}})['then'](respondWithFilteredResult(_0x1f5c28,_0x3d5959))[_0xa586('0x40')](handleError(_0x1f5c28,null));};exports[_0xa586('0x5c')]=function(_0x5df604,_0x71327,_0x22d9ae){var _0x78a33b={'raw':!![],'where':{}};var _0x1aabb6={};var _0x5ef611={'count':0x0,'rows':[]};return db['Campaign'][_0xa586('0x56')]({'where':{'id':_0x5df604[_0xa586('0x4e')]['id']}})[_0xa586('0x21')](handleEntityNotFound(_0x71327,null))['then'](function(_0x5e1d9a){if(_0x5e1d9a){_0x1aabb6['model']=_[_0xa586('0x31')](db['CmHopperFinal'][_0xa586('0x2b')]);_0x1aabb6[_0xa586('0x30')]=_[_0xa586('0x31')](_0x5df604['query']);_0x1aabb6[_0xa586('0x39')]=_[_0xa586('0x32')](_0x1aabb6[_0xa586('0x2e')],_0x1aabb6['query']);_0x78a33b['attributes']=_['intersection'](_0x1aabb6[_0xa586('0x2e')],qs['fields'](_0x5df604[_0xa586('0x30')][_0xa586('0x33')]));_0x78a33b['attributes']=_0x78a33b['attributes'][_0xa586('0x42')]?_0x78a33b['attributes']:_0x1aabb6['model'];if(!_0x5df604[_0xa586('0x30')][_0xa586('0x35')](_0xa586('0x58'))){_0x78a33b[_0xa586('0x1b')]=qs[_0xa586('0x1b')](_0x5df604['query'][_0xa586('0x1b')]);_0x78a33b[_0xa586('0x1a')]=qs['offset'](_0x5df604[_0xa586('0x30')]['offset']);}_0x78a33b[_0xa586('0x36')]=qs[_0xa586('0x37')](_0x5df604[_0xa586('0x30')][_0xa586('0x37')]);_0x78a33b[_0xa586('0x38')]=qs[_0xa586('0x39')](_[_0xa586('0x3a')](_0x5df604[_0xa586('0x30')],_0x1aabb6[_0xa586('0x39')]));_0x78a33b[_0xa586('0x38')][_0xa586('0x59')]=_0x5e1d9a['id'];if(_0x5df604['query']['filter']){_0x78a33b[_0xa586('0x38')]=_[_0xa586('0x3c')](_0x78a33b[_0xa586('0x38')],{'$or':_[_0xa586('0x2f')](_0x78a33b[_0xa586('0x34')],function(_0x6f74a0){var _0x472f26={};_0x472f26[_0x6f74a0]={'$like':'%'+_0x5df604[_0xa586('0x30')][_0xa586('0x3b')]+'%'};return _0x472f26;})});}_0x78a33b=_[_0xa586('0x3c')]({},_0x78a33b,_0x5df604[_0xa586('0x3e')]);return db[_0xa586('0x5d')][_0xa586('0x19')]({'where':_0x78a33b[_0xa586('0x38')]})['then'](function(_0x4a3df4){_0x5ef611[_0xa586('0x19')]=_0x4a3df4;if(_0x5df604[_0xa586('0x30')][_0xa586('0x43')]){_0x78a33b[_0xa586('0x44')]=[{'all':!![]}];}return db[_0xa586('0x5d')][_0xa586('0x3f')](_0x78a33b);})[_0xa586('0x21')](function(_0x3efaee){_0x5ef611[_0xa586('0x5a')]=_0x3efaee;return _0x5ef611;});}})[_0xa586('0x21')](respondWithFilteredResult(_0x71327,_0x78a33b))['catch'](handleError(_0x71327,null));};exports[_0xa586('0x5e')]=function(_0x3eb016,_0x5a085b,_0x4d2e2d){var _0xcea2f3={'raw':!![],'where':{}};var _0x2b8c77={};var _0xa049ff={'count':0x0,'rows':[]};return db[_0xa586('0x2a')][_0xa586('0x56')]({'where':{'id':_0x3eb016[_0xa586('0x4e')]['id']}})['then'](handleEntityNotFound(_0x5a085b,null))[_0xa586('0x21')](function(_0x352aa6){if(_0x352aa6){_0x2b8c77[_0xa586('0x2e')]=_['keys'](db[_0xa586('0x5f')][_0xa586('0x2b')]);_0x2b8c77[_0xa586('0x30')]=_['keys'](_0x3eb016['query']);_0x2b8c77[_0xa586('0x39')]=_['intersection'](_0x2b8c77[_0xa586('0x2e')],_0x2b8c77['query']);_0xcea2f3['attributes']=_['intersection'](_0x2b8c77[_0xa586('0x2e')],qs['fields'](_0x3eb016[_0xa586('0x30')][_0xa586('0x33')]));_0xcea2f3[_0xa586('0x34')]=_0xcea2f3[_0xa586('0x34')]['length']?_0xcea2f3[_0xa586('0x34')]:_0x2b8c77['model'];if(!_0x3eb016[_0xa586('0x30')][_0xa586('0x35')](_0xa586('0x58'))){_0xcea2f3[_0xa586('0x1b')]=qs['limit'](_0x3eb016[_0xa586('0x30')][_0xa586('0x1b')]);_0xcea2f3[_0xa586('0x1a')]=qs[_0xa586('0x1a')](_0x3eb016[_0xa586('0x30')]['offset']);}_0xcea2f3[_0xa586('0x36')]=qs[_0xa586('0x37')](_0x3eb016['query'][_0xa586('0x37')]);_0xcea2f3[_0xa586('0x38')]=qs[_0xa586('0x39')](_['pick'](_0x3eb016[_0xa586('0x30')],_0x2b8c77[_0xa586('0x39')]));_0xcea2f3[_0xa586('0x38')]['CampaignId']=_0x352aa6['id'];if(_0x3eb016[_0xa586('0x30')][_0xa586('0x3b')]){_0xcea2f3[_0xa586('0x38')]=_[_0xa586('0x3c')](_0xcea2f3[_0xa586('0x38')],{'$or':_[_0xa586('0x2f')](_0xcea2f3[_0xa586('0x34')],function(_0x5987c3){var _0x14cb7b={};_0x14cb7b[_0x5987c3]={'$like':'%'+_0x3eb016['query'][_0xa586('0x3b')]+'%'};return _0x14cb7b;})});}_0xcea2f3=_[_0xa586('0x3c')]({},_0xcea2f3,_0x3eb016['options']);return db[_0xa586('0x5f')][_0xa586('0x19')]({'where':_0xcea2f3[_0xa586('0x38')]})[_0xa586('0x21')](function(_0x2d8f1d){_0xa049ff[_0xa586('0x19')]=_0x2d8f1d;if(_0x3eb016[_0xa586('0x30')][_0xa586('0x43')]){_0xcea2f3[_0xa586('0x44')]=[{'all':!![]}];}return db[_0xa586('0x5f')][_0xa586('0x3f')](_0xcea2f3);})[_0xa586('0x21')](function(_0x22d6d6){_0xa049ff['rows']=_0x22d6d6;return _0xa049ff;});}})[_0xa586('0x21')](respondWithFilteredResult(_0x5a085b,_0xcea2f3))[_0xa586('0x40')](handleError(_0x5a085b,null));};exports[_0xa586('0x60')]=function(_0x5e6a07,_0x1c03d1,_0xe3523b){var _0x284eba={};var _0x4ca86d={};var _0x4863b1;var _0x149100;return db[_0xa586('0x2a')][_0xa586('0x56')]({'where':{'id':_0x5e6a07[_0xa586('0x4e')]['id']}})[_0xa586('0x21')](handleEntityNotFound(_0x1c03d1,null))[_0xa586('0x21')](function(_0x47245a){if(_0x47245a){_0x4863b1=_0x47245a;_0x4ca86d[_0xa586('0x2e')]=_['keys'](db[_0xa586('0x61')][_0xa586('0x2b')]);_0x4ca86d[_0xa586('0x30')]=_[_0xa586('0x31')](_0x5e6a07[_0xa586('0x30')]);_0x4ca86d[_0xa586('0x39')]=_['intersection'](_0x4ca86d['model'],_0x4ca86d[_0xa586('0x30')]);_0x284eba[_0xa586('0x34')]=_[_0xa586('0x32')](_0x4ca86d[_0xa586('0x2e')],qs['fields'](_0x5e6a07['query'][_0xa586('0x33')]));_0x284eba[_0xa586('0x34')]=_0x284eba['attributes'][_0xa586('0x42')]?_0x284eba[_0xa586('0x34')]:_0x4ca86d[_0xa586('0x2e')];_0x284eba[_0xa586('0x36')]=qs[_0xa586('0x37')](_0x5e6a07['query'][_0xa586('0x37')]);_0x284eba[_0xa586('0x38')]=qs['filters'](_[_0xa586('0x3a')](_0x5e6a07[_0xa586('0x30')],_0x4ca86d[_0xa586('0x39')]));if(_0x5e6a07[_0xa586('0x30')][_0xa586('0x3b')]){_0x284eba[_0xa586('0x38')]=_[_0xa586('0x3c')](_0x284eba[_0xa586('0x38')],{'$or':_[_0xa586('0x2f')](_0x284eba[_0xa586('0x34')],function(_0x1f616a){var _0x28a637={};_0x28a637[_0x1f616a]={'$like':'%'+_0x5e6a07[_0xa586('0x30')]['filter']+'%'};return _0x28a637;})});}_0x284eba=_['merge']({},_0x284eba,_0x5e6a07[_0xa586('0x3e')]);return _0x4863b1[_0xa586('0x60')](_0x284eba);}})[_0xa586('0x21')](function(_0x3ef3bc){if(_0x3ef3bc){_0x149100=_0x3ef3bc[_0xa586('0x42')];if(!_0x5e6a07['query'][_0xa586('0x35')](_0xa586('0x58'))){_0x284eba[_0xa586('0x1b')]=qs[_0xa586('0x1b')](_0x5e6a07['query'][_0xa586('0x1b')]);_0x284eba[_0xa586('0x1a')]=qs['offset'](_0x5e6a07[_0xa586('0x30')][_0xa586('0x1a')]);}return _0x4863b1[_0xa586('0x60')](_0x284eba);}})[_0xa586('0x21')](function(_0x5747c6){if(_0x5747c6){return _0x5747c6?{'count':_0x149100,'rows':_0x5747c6}:null;}})['then'](respondWithResult(_0x1c03d1,null))[_0xa586('0x40')](handleError(_0x1c03d1,null));};exports['addLists']=function(_0x2517a8,_0x8f187e,_0x44bd3f){var _0x442031,_0x2734e8;return db[_0xa586('0x2a')][_0xa586('0x49')]({'where':{'id':_0x2517a8[_0xa586('0x4e')]['id']}})['then'](handleEntityNotFound(_0x8f187e,null))[_0xa586('0x21')](function(_0x4d9336){if(_0x4d9336){_0x2734e8=_0x4d9336;return _0x4d9336[_0xa586('0x62')](_0x2517a8[_0xa586('0x46')]['ids'],_[_0xa586('0x63')](_0x2517a8[_0xa586('0x46')],[_0xa586('0x64'),'id'])||{});}return null;})[_0xa586('0x65')](function(_0x12bd9c){var _0x4799fa;_0x442031=_0x12bd9c||[];var _0xc556a1=[];if(_0x12bd9c){for(var _0x4dbaa3=0x0;_0x4dbaa3<_0x12bd9c[_0xa586('0x42')];_0x4dbaa3+=0x1){var _0x4b8463=_0x12bd9c[_0x4dbaa3][_0xa586('0x22')]({'plain':!![]});_0x2734e8[_0xa586('0x66')]=_0x2517a8[_0xa586('0x46')]['dialCheckDuplicateType']?_0x2517a8[_0xa586('0x46')][_0xa586('0x66')]:_0x2734e8[_0xa586('0x66')];switch(_0x2734e8['dialCheckDuplicateType']){case'always':_0x4799fa=squel[_0xa586('0x67')]()['into']('cm_hopper')[_0xa586('0x68')]([_0xa586('0x69'),_0xa586('0x6a'),_0xa586('0x6b'),'ListId',_0xa586('0x59'),'createdAt','updatedAt'],squel[_0xa586('0x6c')]()['field'](_0xa586('0x69'),_0xa586('0x69'))[_0xa586('0x6d')](_0xa586('0x6e'),_0xa586('0x6a'))['field']('id',_0xa586('0x6b'))[_0xa586('0x6d')](_0x4b8463[_0xa586('0x6f')][_0xa586('0x70')](),_0xa586('0x71'))[_0xa586('0x6d')](_0x2517a8[_0xa586('0x4e')]['id']['toString'](),_0xa586('0x59'))[_0xa586('0x6d')]('NOW()',_0xa586('0x4f'))[_0xa586('0x6d')](_0xa586('0x6e'),_0xa586('0x50'))[_0xa586('0x72')](_0xa586('0x73'))[_0xa586('0x38')](_0xa586('0x74'))['where'](_0xa586('0x75'),_0x4b8463[_0xa586('0x6f')][_0xa586('0x70')]())[_0xa586('0x38')]('phone\x20IS\x20NOT\x20NULL')[_0xa586('0x38')]('phone\x20NOT\x20IN\x20(?)',squel['select']()[_0xa586('0x6d')]('COALESCE(calleridnum,\x27\x27)')[_0xa586('0x72')]('cm_hopper_final')[_0xa586('0x38')]('CampaignId\x20=\x20?',_0x2517a8['params']['id'][_0xa586('0x70')]()))[_0xa586('0x38')]('phone\x20NOT\x20IN\x20(?)',squel[_0xa586('0x6c')]()[_0xa586('0x6d')](_0xa586('0x76'))[_0xa586('0x72')](_0xa586('0x77'))[_0xa586('0x38')]('CampaignId\x20=\x20?',_0x2517a8['params']['id']['toString']())))[_0xa586('0x70')]();break;case'onlyIfOpen':_0x4799fa=squel[_0xa586('0x67')]()[_0xa586('0x78')](_0xa586('0x77'))[_0xa586('0x68')](['phone',_0xa586('0x6a'),_0xa586('0x6b'),_0xa586('0x71'),_0xa586('0x59'),_0xa586('0x4f'),'updatedAt'],squel['select']()[_0xa586('0x6d')]('phone',_0xa586('0x69'))[_0xa586('0x6d')](_0xa586('0x6e'),_0xa586('0x6a'))[_0xa586('0x6d')]('id',_0xa586('0x6b'))[_0xa586('0x6d')](_0x4b8463[_0xa586('0x6f')][_0xa586('0x70')](),_0xa586('0x71'))['field'](_0x2517a8[_0xa586('0x4e')]['id'][_0xa586('0x70')](),_0xa586('0x59'))['field']('NOW()',_0xa586('0x4f'))[_0xa586('0x6d')](_0xa586('0x6e'),_0xa586('0x50'))[_0xa586('0x72')](_0xa586('0x73'))['where'](_0xa586('0x74'))[_0xa586('0x38')](_0xa586('0x75'),_0x4b8463[_0xa586('0x6f')][_0xa586('0x70')]())['where']('phone\x20IS\x20NOT\x20NULL')[_0xa586('0x38')](_0xa586('0x79'),squel[_0xa586('0x6c')]()['field'](_0xa586('0x76'))['from'](_0xa586('0x77'))[_0xa586('0x38')](_0xa586('0x7a'),_0x2517a8[_0xa586('0x4e')]['id'][_0xa586('0x70')]())))['toString']();break;default:_0x4799fa=squel[_0xa586('0x67')]()[_0xa586('0x78')]('cm_hopper')['fromQuery']([_0xa586('0x69'),_0xa586('0x6a'),_0xa586('0x6b'),'ListId',_0xa586('0x59'),_0xa586('0x4f'),'updatedAt'],squel[_0xa586('0x6c')]()[_0xa586('0x6d')](_0xa586('0x69'),_0xa586('0x69'))['field'](_0xa586('0x6e'),_0xa586('0x6a'))[_0xa586('0x6d')]('id',_0xa586('0x6b'))[_0xa586('0x6d')](_0x4b8463[_0xa586('0x6f')][_0xa586('0x70')](),_0xa586('0x71'))[_0xa586('0x6d')](_0x2517a8['params']['id'][_0xa586('0x70')](),_0xa586('0x59'))[_0xa586('0x6d')](_0xa586('0x6e'),_0xa586('0x4f'))[_0xa586('0x6d')](_0xa586('0x6e'),_0xa586('0x50'))[_0xa586('0x72')](_0xa586('0x73'))['where']('deletedAt\x20IS\x20NULL')['where'](_0xa586('0x75'),_0x4b8463[_0xa586('0x6f')]['toString']())[_0xa586('0x38')]('phone\x20IS\x20NOT\x20NULL'))[_0xa586('0x70')]();}_0xc556a1[_0xa586('0x7b')](db[_0xa586('0x7c')][_0xa586('0x30')](_0x4799fa));}return BPromise['all'](_0xc556a1);}})[_0xa586('0x21')](function(){return _0x442031;})['then'](respondWithResult(_0x8f187e,null))[_0xa586('0x40')](handleError(_0x8f187e,null));};exports[_0xa586('0x7d')]=function(_0x2a21fb,_0x249e87,_0x31a283){return db['Campaign'][_0xa586('0x49')]({'where':{'id':_0x2a21fb['params']['id']}})[_0xa586('0x21')](handleEntityNotFound(_0x249e87,null))[_0xa586('0x21')](function(_0x3bef5c){if(_0x3bef5c){return _0x3bef5c['removeLists'](_0x2a21fb[_0xa586('0x30')][_0xa586('0x64')]);}})[_0xa586('0x21')](function(_0x46b10a){if(_0x46b10a){return db[_0xa586('0x57')][_0xa586('0x24')]({'where':{'ListId':_0x2a21fb[_0xa586('0x30')][_0xa586('0x64')],'CampaignId':_0x2a21fb[_0xa586('0x4e')]['id']}})['then'](function(){return _0x46b10a;});}})[_0xa586('0x21')](respondWithStatusCode(_0x249e87,null))[_0xa586('0x40')](handleError(_0x249e87,null));};exports[_0xa586('0x7e')]=function(_0x378eb6,_0x45b323,_0x2b0e18){var _0x4d539e={'raw':!![],'where':{}};var _0x24f731={};var _0x351120={'count':0x0,'rows':[]};return db[_0xa586('0x2a')][_0xa586('0x56')]({'where':{'id':_0x378eb6[_0xa586('0x4e')]['id']}})[_0xa586('0x21')](handleEntityNotFound(_0x45b323,null))[_0xa586('0x21')](function(_0x4fa9d2){if(_0x4fa9d2){_0x24f731[_0xa586('0x2e')]=_['keys'](db['CmList'][_0xa586('0x2b')]);_0x24f731[_0xa586('0x30')]=_[_0xa586('0x31')](_0x378eb6[_0xa586('0x30')]);_0x24f731[_0xa586('0x39')]=_[_0xa586('0x32')](_0x24f731[_0xa586('0x2e')],_0x24f731['query']);_0x4d539e[_0xa586('0x34')]=_[_0xa586('0x32')](_0x24f731[_0xa586('0x2e')],qs[_0xa586('0x33')](_0x378eb6[_0xa586('0x30')]['fields']));_0x4d539e[_0xa586('0x34')]=_0x4d539e['attributes'][_0xa586('0x42')]?_0x4d539e[_0xa586('0x34')]:_0x24f731['model'];if(!_0x378eb6['query'][_0xa586('0x35')](_0xa586('0x58'))){_0x4d539e[_0xa586('0x1b')]=qs['limit'](_0x378eb6[_0xa586('0x30')][_0xa586('0x1b')]);_0x4d539e['offset']=qs['offset'](_0x378eb6[_0xa586('0x30')][_0xa586('0x1a')]);}_0x4d539e[_0xa586('0x36')]=qs[_0xa586('0x37')](_0x378eb6[_0xa586('0x30')][_0xa586('0x37')]);_0x4d539e['where']=qs[_0xa586('0x39')](_[_0xa586('0x3a')](_0x378eb6[_0xa586('0x30')],_0x24f731[_0xa586('0x39')]));_0x4d539e['where']['CampaignId']=_0x4fa9d2['id'];if(_0x378eb6['query'][_0xa586('0x3b')]){_0x4d539e[_0xa586('0x38')]=_[_0xa586('0x3c')](_0x4d539e[_0xa586('0x38')],{'$or':_[_0xa586('0x2f')](_0x4d539e[_0xa586('0x34')],function(_0x22b07f){var _0x2bc5d5={};_0x2bc5d5[_0x22b07f]={'$like':'%'+_0x378eb6[_0xa586('0x30')][_0xa586('0x3b')]+'%'};return _0x2bc5d5;})});}_0x4d539e=_[_0xa586('0x3c')]({},_0x4d539e,_0x378eb6[_0xa586('0x3e')]);return db['CmList'][_0xa586('0x19')]({'where':_0x4d539e[_0xa586('0x38')]})[_0xa586('0x21')](function(_0x33f17e){_0x351120[_0xa586('0x19')]=_0x33f17e;if(_0x378eb6[_0xa586('0x30')][_0xa586('0x43')]){_0x4d539e[_0xa586('0x44')]=[{'all':!![]}];}return db[_0xa586('0x61')][_0xa586('0x3f')](_0x4d539e);})['then'](function(_0x5189ad){_0x351120[_0xa586('0x5a')]=_0x5189ad;return _0x351120;});}})[_0xa586('0x21')](respondWithFilteredResult(_0x45b323,_0x4d539e))['catch'](handleError(_0x45b323,null));};exports['addBlackLists']=function(_0x206097,_0x11387c,_0x19fa57){var _0x34a012,_0x2dfecd;return db[_0xa586('0x2a')][_0xa586('0x49')]({'where':{'id':_0x206097[_0xa586('0x4e')]['id']}})[_0xa586('0x21')](handleEntityNotFound(_0x11387c,null))['then'](function(_0x4b880c){if(_0x4b880c){_0x2dfecd=_0x4b880c;return _0x4b880c[_0xa586('0x7f')](_0x206097[_0xa586('0x46')]['ids'],_[_0xa586('0x63')](_0x206097[_0xa586('0x46')],[_0xa586('0x64'),'id'])||{});}return null;})[_0xa586('0x65')](function(_0x47ae33){var _0x211927;_0x34a012=_0x47ae33||[];var _0x56682b=[];if(_0x47ae33){for(var _0x1aeda8=0x0;_0x1aeda8<_0x47ae33[_0xa586('0x42')];_0x1aeda8+=0x1){var _0x8c80ac=_0x47ae33[_0x1aeda8][_0xa586('0x22')]({'plain':!![]});_0x211927=squel['insert']()[_0xa586('0x78')](_0xa586('0x80'))[_0xa586('0x68')]([_0xa586('0x69'),_0xa586('0x6b'),_0xa586('0x71'),_0xa586('0x59'),_0xa586('0x4f'),_0xa586('0x50')],squel[_0xa586('0x6c')]()['field'](_0xa586('0x69'),_0xa586('0x69'))[_0xa586('0x6d')]('id','ContactId')[_0xa586('0x6d')](_0x8c80ac[_0xa586('0x6f')]['toString'](),'ListId')[_0xa586('0x6d')](_0x206097['params']['id']['toString'](),_0xa586('0x59'))[_0xa586('0x6d')](_0xa586('0x6e'),'createdAt')['field'](_0xa586('0x6e'),'updatedAt')[_0xa586('0x72')](_0xa586('0x73'))[_0xa586('0x38')](_0xa586('0x74'))[_0xa586('0x38')](_0xa586('0x75'),_0x8c80ac[_0xa586('0x6f')][_0xa586('0x70')]())[_0xa586('0x38')](_0xa586('0x81')))[_0xa586('0x70')]();_0x56682b[_0xa586('0x7b')](db[_0xa586('0x7c')][_0xa586('0x30')](_0x211927));}return BPromise[_0xa586('0x82')](_0x56682b);}})[_0xa586('0x21')](function(){return _0x34a012;})[_0xa586('0x21')](respondWithResult(_0x11387c,null))[_0xa586('0x40')](handleError(_0x11387c,null));};exports[_0xa586('0x83')]=function(_0x3bf892,_0x2abc6f,_0x323a72){return db[_0xa586('0x2a')][_0xa586('0x49')]({'where':{'id':_0x3bf892[_0xa586('0x4e')]['id']}})[_0xa586('0x21')](handleEntityNotFound(_0x2abc6f,null))[_0xa586('0x21')](function(_0x4a427c){if(_0x4a427c){return _0x4a427c['removeBlackLists'](_0x3bf892[_0xa586('0x30')][_0xa586('0x64')]);}})[_0xa586('0x21')](function(_0x3364e0){if(_0x3364e0){return db[_0xa586('0x5f')][_0xa586('0x24')]({'where':{'ListId':_0x3bf892[_0xa586('0x30')][_0xa586('0x64')],'CampaignId':_0x3bf892['params']['id']}})['then'](function(){return _0x3364e0;});}})['then'](respondWithStatusCode(_0x2abc6f,null))[_0xa586('0x40')](handleError(_0x2abc6f,null));};