Built motion from commit (unavailable).|2.5.3

[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 _0xd65e=['COALESCE(calleridnum,\x27\x27)','cm_hopper_final','CampaignId\x20=\x20?','COALESCE(phone,\x27\x27)','onlyIfOpen','phone\x20NOT\x20IN\x20(?)','sequelize','all','removeLists','getBlackLists','addBlackLists','push','removeBlackLists','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','mustache','util','path','to-csv','ejs','squel','desk.js','querystring','ioredis','../../components/auth/service','../../config/license/hardware','../../config/logger','../../config/utils','../../mysqldb','status','end','json','count','offset','apply','reject','save','update','then','get','IvrCampaigns','UserProfileResource','sendStatus','error','stack','name','send','index','rawAttributes','fieldName','type','key','model','map','query','keys','filters','intersection','fields','attributes','length','hasOwnProperty','limit','sort','where','pick','filter','merge','VIRTUAL','options','Campaign','include','rows','catch','show','params','includeAll','create','body','user','role','UserProfileSection','find','userProfileId','clone','omit','createdAt','updatedAt','Unable\x20to\x20retrieve\x20the\x20current\x20user','autoAssociation','destroy','getHoppers','findOne','CmHopper','order','CampaignId','findAll','getHopperHistories','CmHopperHistory','nolimit','getHopperFinals','CmHopperFinal','getHopperBlacks','CmHopperBlack','getLists','addLists','ids','spread','dialCheckDuplicateType','always','insert','into','cm_hopper','fromQuery','ContactId','ListId','phone','field','NOW()','scheduledAt','toString','from','cm_contacts','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','CmListId','phone\x20IS\x20NOT\x20NULL','select'];(function(_0x12b992,_0x2df5d1){var _0x21abe2=function(_0x4ecabc){while(--_0x4ecabc){_0x12b992['push'](_0x12b992['shift']());}};_0x21abe2(++_0x2df5d1);}(_0xd65e,0x91));var _0xed65=function(_0x4fa31e,_0x4d9e52){_0x4fa31e=_0x4fa31e-0x0;var _0x25f16d=_0xd65e[_0x4fa31e];return _0x25f16d;};'use strict';var pdf=require(_0xed65('0x0'));var emlformat=require(_0xed65('0x1'));var rimraf=require(_0xed65('0x2'));var zipdir=require(_0xed65('0x3'));var jsonpatch=require(_0xed65('0x4'));var rp=require(_0xed65('0x5'));var moment=require('moment');var BPromise=require('bluebird');var Mustache=require(_0xed65('0x6'));var util=require(_0xed65('0x7'));var path=require(_0xed65('0x8'));var sox=require('sox');var csv=require(_0xed65('0x9'));var ejs=require(_0xed65('0xa'));var fs=require('fs');var _=require('lodash');var squel=require(_0xed65('0xb'));var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require(_0xed65('0xc'));var toCsv=require(_0xed65('0x9'));var querystring=require(_0xed65('0xd'));var Papa=require('papaparse');var Redis=require(_0xed65('0xe'));var authService=require(_0xed65('0xf'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xed65('0x10'));var logger=require(_0xed65('0x11'))('api');var utils=require(_0xed65('0x12'));var config=require('../../config/environment');var db=require(_0xed65('0x13'))['db'];function respondWithStatusCode(_0x18ff6d,_0x59ba28){_0x59ba28=_0x59ba28||0xcc;return function(_0xf7137b){if(_0xf7137b){return _0x18ff6d['sendStatus'](_0x59ba28);}return _0x18ff6d[_0xed65('0x14')](_0x59ba28)[_0xed65('0x15')]();};}function respondWithResult(_0x4aeb05,_0x5e1465){_0x5e1465=_0x5e1465||0xc8;return function(_0x221225){if(_0x221225){return _0x4aeb05[_0xed65('0x14')](_0x5e1465)[_0xed65('0x16')](_0x221225);}};}function respondWithFilteredResult(_0xf7305e,_0x4d475f){return function(_0x5c439a){if(_0x5c439a){var _0x31df07=_0x5c439a[_0xed65('0x17')],_0x530ba6=_0x4d475f['offset'],_0x4d095f=_0x4d475f[_0xed65('0x18')]+_0x4d475f['limit'],_0x348f2e;if(_0x4d095f>=_0x31df07){_0x4d095f=_0x31df07;_0x348f2e=0xc8;}else{_0x348f2e=0xce;}_0xf7305e[_0xed65('0x14')](_0x348f2e);return _0xf7305e['set']('Content-Range',_0x530ba6+'-'+_0x4d095f+'/'+_0x31df07)['json'](_0x5c439a);}return null;};}function patchUpdates(_0x166823){return function(_0x8eec69){try{jsonpatch[_0xed65('0x19')](_0x8eec69,_0x166823,!![]);}catch(_0x4a876f){return BPromise[_0xed65('0x1a')](_0x4a876f);}return _0x8eec69[_0xed65('0x1b')]();};}function saveUpdates(_0x32ef82,_0x823ab3){return function(_0x5c2693){if(_0x5c2693){return _0x5c2693[_0xed65('0x1c')](_0x32ef82)[_0xed65('0x1d')](function(_0x191b25){return _0x191b25;});}return null;};}function removeEntity(_0x4247a2,_0xd97918){return function(_0x11cdb8){if(_0x11cdb8){return _0x11cdb8['destroy']()[_0xed65('0x1d')](function(){var _0x166766=_0x11cdb8[_0xed65('0x1e')]({'plain':!![]});var _0x121003=_0xed65('0x1f');return db[_0xed65('0x20')]['destroy']({'where':{'type':_0x121003,'resourceId':_0x166766['id']}})[_0xed65('0x1d')](function(){return _0x11cdb8;});})['then'](function(){_0x4247a2[_0xed65('0x14')](0xcc)[_0xed65('0x15')]();});}};}function handleEntityNotFound(_0x3f019a,_0x3071ab){return function(_0x1b2405){if(!_0x1b2405){_0x3f019a[_0xed65('0x21')](0x194);}return _0x1b2405;};}function handleError(_0x4fc923,_0x584260){_0x584260=_0x584260||0x1f4;return function(_0x2acb75){logger[_0xed65('0x22')](_0x2acb75[_0xed65('0x23')]);if(_0x2acb75[_0xed65('0x24')]){delete _0x2acb75[_0xed65('0x24')];}_0x4fc923[_0xed65('0x14')](_0x584260)[_0xed65('0x25')](_0x2acb75);};}exports[_0xed65('0x26')]=function(_0x2c8a6b,_0x19ae52){var _0x26cc87={},_0x322b83={},_0x284290={'count':0x0,'rows':[]};var _0x182837=_['map'](db['Campaign'][_0xed65('0x27')],function(_0x34c714){return{'name':_0x34c714[_0xed65('0x28')],'type':_0x34c714[_0xed65('0x29')][_0xed65('0x2a')]};});_0x322b83[_0xed65('0x2b')]=_[_0xed65('0x2c')](_0x182837,'name');_0x322b83[_0xed65('0x2d')]=_[_0xed65('0x2e')](_0x2c8a6b[_0xed65('0x2d')]);_0x322b83[_0xed65('0x2f')]=_[_0xed65('0x30')](_0x322b83[_0xed65('0x2b')],_0x322b83[_0xed65('0x2d')]);_0x26cc87['attributes']=_[_0xed65('0x30')](_0x322b83['model'],qs[_0xed65('0x31')](_0x2c8a6b[_0xed65('0x2d')][_0xed65('0x31')]));_0x26cc87[_0xed65('0x32')]=_0x26cc87[_0xed65('0x32')][_0xed65('0x33')]?_0x26cc87[_0xed65('0x32')]:_0x322b83[_0xed65('0x2b')];if(!_0x2c8a6b[_0xed65('0x2d')][_0xed65('0x34')]('nolimit')){_0x26cc87['limit']=qs[_0xed65('0x35')](_0x2c8a6b[_0xed65('0x2d')][_0xed65('0x35')]);_0x26cc87[_0xed65('0x18')]=qs['offset'](_0x2c8a6b[_0xed65('0x2d')][_0xed65('0x18')]);}_0x26cc87['order']=qs[_0xed65('0x36')](_0x2c8a6b[_0xed65('0x2d')][_0xed65('0x36')]);_0x26cc87[_0xed65('0x37')]=qs[_0xed65('0x2f')](_[_0xed65('0x38')](_0x2c8a6b[_0xed65('0x2d')],_0x322b83[_0xed65('0x2f')]),_0x182837);if(_0x2c8a6b[_0xed65('0x2d')][_0xed65('0x39')]){_0x26cc87['where']=_[_0xed65('0x3a')](_0x26cc87[_0xed65('0x37')],{'$or':_[_0xed65('0x2c')](_0x182837,function(_0x3d9648){if(_0x3d9648[_0xed65('0x29')]!==_0xed65('0x3b')){var _0x1a87b2={};_0x1a87b2[_0x3d9648[_0xed65('0x24')]]={'$like':'%'+_0x2c8a6b[_0xed65('0x2d')]['filter']+'%'};return _0x1a87b2;}})});}_0x26cc87=_[_0xed65('0x3a')]({},_0x26cc87,_0x2c8a6b[_0xed65('0x3c')]);var _0x3de697={'where':_0x26cc87['where']};return db[_0xed65('0x3d')][_0xed65('0x17')](_0x3de697)[_0xed65('0x1d')](function(_0x48c38b){_0x284290['count']=_0x48c38b;if(_0x2c8a6b[_0xed65('0x2d')]['includeAll']){_0x26cc87[_0xed65('0x3e')]=[{'all':!![]}];}return db[_0xed65('0x3d')]['findAll'](_0x26cc87);})[_0xed65('0x1d')](function(_0xe2f734){_0x284290[_0xed65('0x3f')]=_0xe2f734;return _0x284290;})[_0xed65('0x1d')](respondWithFilteredResult(_0x19ae52,_0x26cc87))[_0xed65('0x40')](handleError(_0x19ae52,null));};exports[_0xed65('0x41')]=function(_0x52307b,_0x15494d){var _0x134661={'raw':![],'where':{'id':_0x52307b[_0xed65('0x42')]['id']}},_0xe98c3a={};_0xe98c3a[_0xed65('0x2b')]=_[_0xed65('0x2e')](db[_0xed65('0x3d')][_0xed65('0x27')]);_0xe98c3a[_0xed65('0x2d')]=_[_0xed65('0x2e')](_0x52307b[_0xed65('0x2d')]);_0xe98c3a[_0xed65('0x2f')]=_['intersection'](_0xe98c3a['model'],_0xe98c3a['query']);_0x134661[_0xed65('0x32')]=_[_0xed65('0x30')](_0xe98c3a['model'],qs[_0xed65('0x31')](_0x52307b['query']['fields']));_0x134661['attributes']=_0x134661['attributes']['length']?_0x134661['attributes']:_0xe98c3a[_0xed65('0x2b')];if(_0x52307b[_0xed65('0x2d')][_0xed65('0x43')]){_0x134661[_0xed65('0x3e')]=[{'all':!![]}];}_0x134661=_['merge']({},_0x134661,_0x52307b[_0xed65('0x3c')]);return db[_0xed65('0x3d')]['find'](_0x134661)[_0xed65('0x1d')](handleEntityNotFound(_0x15494d,null))[_0xed65('0x1d')](respondWithResult(_0x15494d,null))['catch'](handleError(_0x15494d,null));};exports[_0xed65('0x44')]=function(_0x1e7417,_0x22f065){return db[_0xed65('0x3d')][_0xed65('0x44')](_0x1e7417[_0xed65('0x45')],{})[_0xed65('0x1d')](function(_0x3bc109){var _0x569905=_0x1e7417[_0xed65('0x46')][_0xed65('0x1e')]({'plain':!![]});if(!_0x569905)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x569905[_0xed65('0x47')]===_0xed65('0x46')){var _0x4f5282=_0x3bc109[_0xed65('0x1e')]({'plain':!![]});var _0xb268ff=_0xed65('0x1f');return db[_0xed65('0x48')][_0xed65('0x49')]({'where':{'name':_0xb268ff,'userProfileId':_0x569905[_0xed65('0x4a')]},'raw':!![]})[_0xed65('0x1d')](function(_0x5dd5bc){if(_0x5dd5bc&&_0x5dd5bc['autoAssociation']===0x0){return db['UserProfileResource']['create']({'name':_0x4f5282[_0xed65('0x24')],'resourceId':_0x4f5282['id'],'type':_0x5dd5bc[_0xed65('0x24')],'sectionId':_0x5dd5bc['id']},{})[_0xed65('0x1d')](function(){return _0x3bc109;});}else{return _0x3bc109;}})[_0xed65('0x40')](function(_0x120dc9){logger[_0xed65('0x22')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x120dc9);throw _0x120dc9;});}return _0x3bc109;})[_0xed65('0x1d')](respondWithResult(_0x22f065,0xc9))[_0xed65('0x40')](handleError(_0x22f065,null));};exports[_0xed65('0x4b')]=function(_0x19ec02,_0x39325b){var _0x37e474={'where':{'id':_0x19ec02['params']['id']}},_0x2cb170={};_0x2cb170[_0xed65('0x2b')]=_[_0xed65('0x2e')](db[_0xed65('0x3d')][_0xed65('0x27')]);_0x37e474[_0xed65('0x32')]=_[_0xed65('0x30')](_0x2cb170[_0xed65('0x2b')],qs[_0xed65('0x31')](_0x19ec02[_0xed65('0x2d')][_0xed65('0x31')]));_0x37e474[_0xed65('0x32')]=_0x37e474[_0xed65('0x32')]['length']?_0x37e474['attributes']:_0x2cb170[_0xed65('0x2b')];if(_0x19ec02[_0xed65('0x2d')][_0xed65('0x43')]){_0x37e474['include']=[{'all':!![]}];}_0x37e474=_['merge']({},_0x37e474,_0x19ec02[_0xed65('0x3c')]);return db[_0xed65('0x3d')][_0xed65('0x49')](_0x37e474)['then'](handleEntityNotFound(_0x39325b,null))[_0xed65('0x1d')](function(_0x43215c){if(_0x43215c){var _0x57ced0=_0x43215c[_0xed65('0x1e')]({'plain':!![]});_0x57ced0=qs[_0xed65('0x4c')](_0x57ced0,['id',_0xed65('0x4d'),_0xed65('0x4e')]);_0x19ec02[_0xed65('0x45')]=_[_0xed65('0x4c')](_0x19ec02[_0xed65('0x45')],['id',_0xed65('0x4d'),'updatedAt']);return db['Campaign'][_0xed65('0x44')](_[_0xed65('0x3a')](_0x57ced0,_0x19ec02[_0xed65('0x45')]),{'include':_0x19ec02[_0xed65('0x2d')][_0xed65('0x43')]?[{'all':!![]}]:undefined})[_0xed65('0x1d')](function(_0x3d9b47){var _0x490daf=_0x19ec02['user'][_0xed65('0x1e')]({'plain':!![]});if(!_0x490daf)throw new Error(_0xed65('0x4f'));if(_0x490daf[_0xed65('0x47')]===_0xed65('0x46')){var _0x287a9f=_0x3d9b47[_0xed65('0x1e')]({'plain':!![]});var _0x5dd2c2=_0xed65('0x1f');return db['UserProfileSection']['find']({'where':{'name':_0x5dd2c2,'userProfileId':_0x490daf['userProfileId']},'raw':!![]})[_0xed65('0x1d')](function(_0x26d58c){if(_0x26d58c&&_0x26d58c[_0xed65('0x50')]===0x0){return db[_0xed65('0x20')][_0xed65('0x44')]({'name':_0x287a9f[_0xed65('0x24')],'resourceId':_0x287a9f['id'],'type':_0x26d58c['name'],'sectionId':_0x26d58c['id']},{})[_0xed65('0x1d')](function(){return _0x3d9b47;});}else{return _0x3d9b47;}})[_0xed65('0x40')](function(_0x29a561){logger[_0xed65('0x22')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x29a561);throw _0x29a561;});}return _0x3d9b47;});}})[_0xed65('0x1d')](respondWithResult(_0x39325b,0xc9))[_0xed65('0x40')](handleError(_0x39325b,null));};exports[_0xed65('0x1c')]=function(_0x4bd1f0,_0x133598){if(_0x4bd1f0[_0xed65('0x45')]['id']){delete _0x4bd1f0[_0xed65('0x45')]['id'];}return db[_0xed65('0x3d')][_0xed65('0x49')]({'where':{'id':_0x4bd1f0[_0xed65('0x42')]['id']}})[_0xed65('0x1d')](handleEntityNotFound(_0x133598,null))[_0xed65('0x1d')](saveUpdates(_0x4bd1f0[_0xed65('0x45')],null))[_0xed65('0x1d')](respondWithResult(_0x133598,null))['catch'](handleError(_0x133598,null));};exports[_0xed65('0x51')]=function(_0x1d5713,_0xba2024){return db['Campaign'][_0xed65('0x49')]({'where':{'id':_0x1d5713['params']['id']}})[_0xed65('0x1d')](handleEntityNotFound(_0xba2024,null))[_0xed65('0x1d')](removeEntity(_0xba2024,null))[_0xed65('0x40')](handleError(_0xba2024,null));};exports[_0xed65('0x52')]=function(_0x160440,_0x76ed1c,_0x5b7194){var _0x7ffc17={'raw':!![],'where':{}};var _0x51562a={};var _0x25ab8b={'count':0x0,'rows':[]};return db[_0xed65('0x3d')][_0xed65('0x53')]({'where':{'id':_0x160440['params']['id']}})[_0xed65('0x1d')](handleEntityNotFound(_0x76ed1c,null))[_0xed65('0x1d')](function(_0x26f111){if(_0x26f111){_0x51562a[_0xed65('0x2b')]=_[_0xed65('0x2e')](db[_0xed65('0x54')][_0xed65('0x27')]);_0x51562a[_0xed65('0x2d')]=_[_0xed65('0x2e')](_0x160440[_0xed65('0x2d')]);_0x51562a['filters']=_[_0xed65('0x30')](_0x51562a[_0xed65('0x2b')],_0x51562a[_0xed65('0x2d')]);_0x7ffc17[_0xed65('0x32')]=_[_0xed65('0x30')](_0x51562a[_0xed65('0x2b')],qs['fields'](_0x160440[_0xed65('0x2d')][_0xed65('0x31')]));_0x7ffc17['attributes']=_0x7ffc17[_0xed65('0x32')][_0xed65('0x33')]?_0x7ffc17[_0xed65('0x32')]:_0x51562a[_0xed65('0x2b')];if(!_0x160440[_0xed65('0x2d')][_0xed65('0x34')]('nolimit')){_0x7ffc17[_0xed65('0x35')]=qs[_0xed65('0x35')](_0x160440['query'][_0xed65('0x35')]);_0x7ffc17[_0xed65('0x18')]=qs[_0xed65('0x18')](_0x160440[_0xed65('0x2d')][_0xed65('0x18')]);}_0x7ffc17[_0xed65('0x55')]=qs[_0xed65('0x36')](_0x160440['query'][_0xed65('0x36')]);_0x7ffc17['where']=qs[_0xed65('0x2f')](_[_0xed65('0x38')](_0x160440[_0xed65('0x2d')],_0x51562a[_0xed65('0x2f')]));_0x7ffc17['where'][_0xed65('0x56')]=_0x26f111['id'];if(_0x160440[_0xed65('0x2d')][_0xed65('0x39')]){_0x7ffc17[_0xed65('0x37')]=_[_0xed65('0x3a')](_0x7ffc17[_0xed65('0x37')],{'$or':_[_0xed65('0x2c')](_0x7ffc17[_0xed65('0x32')],function(_0x2ddb4c){var _0x2806ac={};_0x2806ac[_0x2ddb4c]={'$like':'%'+_0x160440['query'][_0xed65('0x39')]+'%'};return _0x2806ac;})});}_0x7ffc17=_[_0xed65('0x3a')]({},_0x7ffc17,_0x160440[_0xed65('0x3c')]);return db['CmHopper'][_0xed65('0x17')]({'where':_0x7ffc17[_0xed65('0x37')]})[_0xed65('0x1d')](function(_0x5603d3){_0x25ab8b[_0xed65('0x17')]=_0x5603d3;if(_0x160440['query'][_0xed65('0x43')]){_0x7ffc17[_0xed65('0x3e')]=[{'all':!![]}];}return db[_0xed65('0x54')][_0xed65('0x57')](_0x7ffc17);})[_0xed65('0x1d')](function(_0x5840c5){_0x25ab8b[_0xed65('0x3f')]=_0x5840c5;return _0x25ab8b;});}})[_0xed65('0x1d')](respondWithFilteredResult(_0x76ed1c,_0x7ffc17))[_0xed65('0x40')](handleError(_0x76ed1c,null));};exports[_0xed65('0x58')]=function(_0x166cd0,_0xa30279,_0x1cd200){var _0x3dcaad={'raw':!![],'where':{}};var _0x31f342={};var _0x47465c={'count':0x0,'rows':[]};return db[_0xed65('0x3d')][_0xed65('0x53')]({'where':{'id':_0x166cd0['params']['id']}})['then'](handleEntityNotFound(_0xa30279,null))[_0xed65('0x1d')](function(_0x43821c){if(_0x43821c){_0x31f342[_0xed65('0x2b')]=_[_0xed65('0x2e')](db[_0xed65('0x59')]['rawAttributes']);_0x31f342[_0xed65('0x2d')]=_[_0xed65('0x2e')](_0x166cd0['query']);_0x31f342[_0xed65('0x2f')]=_[_0xed65('0x30')](_0x31f342[_0xed65('0x2b')],_0x31f342[_0xed65('0x2d')]);_0x3dcaad[_0xed65('0x32')]=_[_0xed65('0x30')](_0x31f342['model'],qs[_0xed65('0x31')](_0x166cd0['query'][_0xed65('0x31')]));_0x3dcaad[_0xed65('0x32')]=_0x3dcaad['attributes'][_0xed65('0x33')]?_0x3dcaad[_0xed65('0x32')]:_0x31f342['model'];if(!_0x166cd0[_0xed65('0x2d')][_0xed65('0x34')](_0xed65('0x5a'))){_0x3dcaad['limit']=qs[_0xed65('0x35')](_0x166cd0[_0xed65('0x2d')]['limit']);_0x3dcaad[_0xed65('0x18')]=qs[_0xed65('0x18')](_0x166cd0[_0xed65('0x2d')][_0xed65('0x18')]);}_0x3dcaad[_0xed65('0x55')]=qs[_0xed65('0x36')](_0x166cd0[_0xed65('0x2d')][_0xed65('0x36')]);_0x3dcaad[_0xed65('0x37')]=qs[_0xed65('0x2f')](_[_0xed65('0x38')](_0x166cd0[_0xed65('0x2d')],_0x31f342[_0xed65('0x2f')]));_0x3dcaad['where']['CampaignId']=_0x43821c['id'];if(_0x166cd0[_0xed65('0x2d')][_0xed65('0x39')]){_0x3dcaad[_0xed65('0x37')]=_[_0xed65('0x3a')](_0x3dcaad[_0xed65('0x37')],{'$or':_[_0xed65('0x2c')](_0x3dcaad['attributes'],function(_0x477eca){var _0x179044={};_0x179044[_0x477eca]={'$like':'%'+_0x166cd0[_0xed65('0x2d')][_0xed65('0x39')]+'%'};return _0x179044;})});}_0x3dcaad=_[_0xed65('0x3a')]({},_0x3dcaad,_0x166cd0[_0xed65('0x3c')]);return db[_0xed65('0x59')][_0xed65('0x17')]({'where':_0x3dcaad[_0xed65('0x37')]})[_0xed65('0x1d')](function(_0x8d73d0){_0x47465c[_0xed65('0x17')]=_0x8d73d0;if(_0x166cd0[_0xed65('0x2d')][_0xed65('0x43')]){_0x3dcaad['include']=[{'all':!![]}];}return db[_0xed65('0x59')][_0xed65('0x57')](_0x3dcaad);})[_0xed65('0x1d')](function(_0x11a564){_0x47465c['rows']=_0x11a564;return _0x47465c;});}})[_0xed65('0x1d')](respondWithFilteredResult(_0xa30279,_0x3dcaad))['catch'](handleError(_0xa30279,null));};exports[_0xed65('0x5b')]=function(_0x3898b9,_0x5d148d,_0x34709e){var _0x4fa59e={'raw':!![],'where':{}};var _0x3559c5={};var _0x4d3a3d={'count':0x0,'rows':[]};return db['Campaign'][_0xed65('0x53')]({'where':{'id':_0x3898b9[_0xed65('0x42')]['id']}})[_0xed65('0x1d')](handleEntityNotFound(_0x5d148d,null))[_0xed65('0x1d')](function(_0x3b159f){if(_0x3b159f){_0x3559c5[_0xed65('0x2b')]=_[_0xed65('0x2e')](db[_0xed65('0x5c')][_0xed65('0x27')]);_0x3559c5[_0xed65('0x2d')]=_[_0xed65('0x2e')](_0x3898b9[_0xed65('0x2d')]);_0x3559c5[_0xed65('0x2f')]=_[_0xed65('0x30')](_0x3559c5[_0xed65('0x2b')],_0x3559c5[_0xed65('0x2d')]);_0x4fa59e[_0xed65('0x32')]=_[_0xed65('0x30')](_0x3559c5[_0xed65('0x2b')],qs[_0xed65('0x31')](_0x3898b9[_0xed65('0x2d')][_0xed65('0x31')]));_0x4fa59e['attributes']=_0x4fa59e[_0xed65('0x32')][_0xed65('0x33')]?_0x4fa59e[_0xed65('0x32')]:_0x3559c5['model'];if(!_0x3898b9[_0xed65('0x2d')][_0xed65('0x34')]('nolimit')){_0x4fa59e[_0xed65('0x35')]=qs['limit'](_0x3898b9[_0xed65('0x2d')]['limit']);_0x4fa59e[_0xed65('0x18')]=qs[_0xed65('0x18')](_0x3898b9['query'][_0xed65('0x18')]);}_0x4fa59e[_0xed65('0x55')]=qs['sort'](_0x3898b9[_0xed65('0x2d')]['sort']);_0x4fa59e['where']=qs['filters'](_['pick'](_0x3898b9['query'],_0x3559c5[_0xed65('0x2f')]));_0x4fa59e[_0xed65('0x37')]['CampaignId']=_0x3b159f['id'];if(_0x3898b9[_0xed65('0x2d')][_0xed65('0x39')]){_0x4fa59e[_0xed65('0x37')]=_[_0xed65('0x3a')](_0x4fa59e[_0xed65('0x37')],{'$or':_[_0xed65('0x2c')](_0x4fa59e[_0xed65('0x32')],function(_0x666b55){var _0xb7f2fa={};_0xb7f2fa[_0x666b55]={'$like':'%'+_0x3898b9[_0xed65('0x2d')][_0xed65('0x39')]+'%'};return _0xb7f2fa;})});}_0x4fa59e=_['merge']({},_0x4fa59e,_0x3898b9[_0xed65('0x3c')]);return db[_0xed65('0x5c')][_0xed65('0x17')]({'where':_0x4fa59e['where']})[_0xed65('0x1d')](function(_0x1c458f){_0x4d3a3d[_0xed65('0x17')]=_0x1c458f;if(_0x3898b9[_0xed65('0x2d')]['includeAll']){_0x4fa59e[_0xed65('0x3e')]=[{'all':!![]}];}return db[_0xed65('0x5c')][_0xed65('0x57')](_0x4fa59e);})[_0xed65('0x1d')](function(_0x387a78){_0x4d3a3d[_0xed65('0x3f')]=_0x387a78;return _0x4d3a3d;});}})[_0xed65('0x1d')](respondWithFilteredResult(_0x5d148d,_0x4fa59e))[_0xed65('0x40')](handleError(_0x5d148d,null));};exports[_0xed65('0x5d')]=function(_0x161a3d,_0x2b935e,_0x3bdcec){var _0x3f4750={'raw':!![],'where':{}};var _0x407b80={};var _0x14cd2d={'count':0x0,'rows':[]};return db[_0xed65('0x3d')]['findOne']({'where':{'id':_0x161a3d[_0xed65('0x42')]['id']}})['then'](handleEntityNotFound(_0x2b935e,null))[_0xed65('0x1d')](function(_0x4ebb70){if(_0x4ebb70){_0x407b80[_0xed65('0x2b')]=_[_0xed65('0x2e')](db[_0xed65('0x5e')][_0xed65('0x27')]);_0x407b80[_0xed65('0x2d')]=_[_0xed65('0x2e')](_0x161a3d[_0xed65('0x2d')]);_0x407b80[_0xed65('0x2f')]=_[_0xed65('0x30')](_0x407b80[_0xed65('0x2b')],_0x407b80['query']);_0x3f4750[_0xed65('0x32')]=_[_0xed65('0x30')](_0x407b80['model'],qs[_0xed65('0x31')](_0x161a3d[_0xed65('0x2d')]['fields']));_0x3f4750['attributes']=_0x3f4750['attributes'][_0xed65('0x33')]?_0x3f4750[_0xed65('0x32')]:_0x407b80['model'];if(!_0x161a3d['query'][_0xed65('0x34')](_0xed65('0x5a'))){_0x3f4750[_0xed65('0x35')]=qs[_0xed65('0x35')](_0x161a3d[_0xed65('0x2d')][_0xed65('0x35')]);_0x3f4750[_0xed65('0x18')]=qs[_0xed65('0x18')](_0x161a3d[_0xed65('0x2d')][_0xed65('0x18')]);}_0x3f4750['order']=qs['sort'](_0x161a3d[_0xed65('0x2d')][_0xed65('0x36')]);_0x3f4750['where']=qs['filters'](_['pick'](_0x161a3d[_0xed65('0x2d')],_0x407b80[_0xed65('0x2f')]));_0x3f4750[_0xed65('0x37')]['CampaignId']=_0x4ebb70['id'];if(_0x161a3d[_0xed65('0x2d')][_0xed65('0x39')]){_0x3f4750['where']=_[_0xed65('0x3a')](_0x3f4750['where'],{'$or':_[_0xed65('0x2c')](_0x3f4750['attributes'],function(_0x55c0b8){var _0x575ae8={};_0x575ae8[_0x55c0b8]={'$like':'%'+_0x161a3d[_0xed65('0x2d')][_0xed65('0x39')]+'%'};return _0x575ae8;})});}_0x3f4750=_[_0xed65('0x3a')]({},_0x3f4750,_0x161a3d[_0xed65('0x3c')]);return db[_0xed65('0x5e')]['count']({'where':_0x3f4750[_0xed65('0x37')]})[_0xed65('0x1d')](function(_0x48e8e5){_0x14cd2d[_0xed65('0x17')]=_0x48e8e5;if(_0x161a3d['query']['includeAll']){_0x3f4750[_0xed65('0x3e')]=[{'all':!![]}];}return db['CmHopperBlack'][_0xed65('0x57')](_0x3f4750);})['then'](function(_0x546c2a){_0x14cd2d[_0xed65('0x3f')]=_0x546c2a;return _0x14cd2d;});}})[_0xed65('0x1d')](respondWithFilteredResult(_0x2b935e,_0x3f4750))[_0xed65('0x40')](handleError(_0x2b935e,null));};exports[_0xed65('0x5f')]=function(_0x4d304a,_0x224df3,_0x1d2c0c){var _0x24fa14={};var _0x5dab9c={};var _0x4bbdd9;var _0x1923da;return db[_0xed65('0x3d')][_0xed65('0x53')]({'where':{'id':_0x4d304a[_0xed65('0x42')]['id']}})[_0xed65('0x1d')](handleEntityNotFound(_0x224df3,null))[_0xed65('0x1d')](function(_0x47274a){if(_0x47274a){_0x4bbdd9=_0x47274a;_0x5dab9c['model']=_[_0xed65('0x2e')](db['CmList'][_0xed65('0x27')]);_0x5dab9c[_0xed65('0x2d')]=_[_0xed65('0x2e')](_0x4d304a[_0xed65('0x2d')]);_0x5dab9c['filters']=_[_0xed65('0x30')](_0x5dab9c[_0xed65('0x2b')],_0x5dab9c[_0xed65('0x2d')]);_0x24fa14['attributes']=_[_0xed65('0x30')](_0x5dab9c[_0xed65('0x2b')],qs[_0xed65('0x31')](_0x4d304a[_0xed65('0x2d')][_0xed65('0x31')]));_0x24fa14[_0xed65('0x32')]=_0x24fa14[_0xed65('0x32')][_0xed65('0x33')]?_0x24fa14['attributes']:_0x5dab9c[_0xed65('0x2b')];_0x24fa14[_0xed65('0x55')]=qs[_0xed65('0x36')](_0x4d304a[_0xed65('0x2d')][_0xed65('0x36')]);_0x24fa14[_0xed65('0x37')]=qs['filters'](_[_0xed65('0x38')](_0x4d304a[_0xed65('0x2d')],_0x5dab9c[_0xed65('0x2f')]));if(_0x4d304a[_0xed65('0x2d')][_0xed65('0x39')]){_0x24fa14[_0xed65('0x37')]=_[_0xed65('0x3a')](_0x24fa14['where'],{'$or':_[_0xed65('0x2c')](_0x24fa14['attributes'],function(_0x16b0d6){var _0x4ea688={};_0x4ea688[_0x16b0d6]={'$like':'%'+_0x4d304a[_0xed65('0x2d')]['filter']+'%'};return _0x4ea688;})});}_0x24fa14=_['merge']({},_0x24fa14,_0x4d304a[_0xed65('0x3c')]);return _0x4bbdd9['getLists'](_0x24fa14);}})['then'](function(_0x1e6a0e){if(_0x1e6a0e){_0x1923da=_0x1e6a0e[_0xed65('0x33')];if(!_0x4d304a[_0xed65('0x2d')][_0xed65('0x34')](_0xed65('0x5a'))){_0x24fa14['limit']=qs[_0xed65('0x35')](_0x4d304a[_0xed65('0x2d')][_0xed65('0x35')]);_0x24fa14['offset']=qs[_0xed65('0x18')](_0x4d304a[_0xed65('0x2d')][_0xed65('0x18')]);}return _0x4bbdd9[_0xed65('0x5f')](_0x24fa14);}})[_0xed65('0x1d')](function(_0x171b4e){if(_0x171b4e){return _0x171b4e?{'count':_0x1923da,'rows':_0x171b4e}:null;}})[_0xed65('0x1d')](respondWithResult(_0x224df3,null))['catch'](handleError(_0x224df3,null));};exports[_0xed65('0x60')]=function(_0x4921c2,_0x235d3d,_0x18569f){var _0x742a5a,_0x130b5c;return db[_0xed65('0x3d')]['find']({'where':{'id':_0x4921c2['params']['id']}})['then'](handleEntityNotFound(_0x235d3d,null))[_0xed65('0x1d')](function(_0x1377c7){if(_0x1377c7){_0x130b5c=_0x1377c7;return _0x1377c7[_0xed65('0x60')](_0x4921c2[_0xed65('0x45')]['ids'],_['omit'](_0x4921c2['body'],[_0xed65('0x61'),'id'])||{});}return null;})[_0xed65('0x62')](function(_0x174b9a){var _0xcb5363;_0x742a5a=_0x174b9a||[];var _0x42fc8=[];if(_0x174b9a){for(var _0x3c4053=0x0;_0x3c4053<_0x174b9a[_0xed65('0x33')];_0x3c4053+=0x1){var _0x12043c=_0x174b9a[_0x3c4053][_0xed65('0x1e')]({'plain':!![]});_0x130b5c[_0xed65('0x63')]=_0x4921c2['body']['dialCheckDuplicateType']?_0x4921c2['body'][_0xed65('0x63')]:_0x130b5c['dialCheckDuplicateType'];switch(_0x130b5c['dialCheckDuplicateType']){case _0xed65('0x64'):_0xcb5363=squel[_0xed65('0x65')]()[_0xed65('0x66')](_0xed65('0x67'))[_0xed65('0x68')](['phone','scheduledAt',_0xed65('0x69'),_0xed65('0x6a'),'CampaignId',_0xed65('0x4d'),_0xed65('0x4e')],squel['select']()['field'](_0xed65('0x6b'),_0xed65('0x6b'))[_0xed65('0x6c')](_0xed65('0x6d'),_0xed65('0x6e'))['field']('id',_0xed65('0x69'))['field'](_0x12043c['CmListId'][_0xed65('0x6f')](),_0xed65('0x6a'))[_0xed65('0x6c')](_0x4921c2[_0xed65('0x42')]['id'][_0xed65('0x6f')](),'CampaignId')[_0xed65('0x6c')](_0xed65('0x6d'),_0xed65('0x4d'))[_0xed65('0x6c')]('NOW()',_0xed65('0x4e'))[_0xed65('0x70')](_0xed65('0x71'))[_0xed65('0x37')](_0xed65('0x72'))['where'](_0xed65('0x73'),_0x12043c[_0xed65('0x74')][_0xed65('0x6f')]())[_0xed65('0x37')](_0xed65('0x75'))['where']('phone\x20NOT\x20IN\x20(?)',squel[_0xed65('0x76')]()['field'](_0xed65('0x77'))['from'](_0xed65('0x78'))[_0xed65('0x37')](_0xed65('0x79'),_0x4921c2['params']['id'][_0xed65('0x6f')]()))[_0xed65('0x37')]('phone\x20NOT\x20IN\x20(?)',squel[_0xed65('0x76')]()[_0xed65('0x6c')](_0xed65('0x7a'))[_0xed65('0x70')]('cm_hopper')[_0xed65('0x37')](_0xed65('0x79'),_0x4921c2['params']['id'][_0xed65('0x6f')]())))[_0xed65('0x6f')]();break;case _0xed65('0x7b'):_0xcb5363=squel[_0xed65('0x65')]()['into'](_0xed65('0x67'))[_0xed65('0x68')](['phone',_0xed65('0x6e'),_0xed65('0x69'),_0xed65('0x6a'),'CampaignId',_0xed65('0x4d'),_0xed65('0x4e')],squel[_0xed65('0x76')]()[_0xed65('0x6c')]('phone',_0xed65('0x6b'))[_0xed65('0x6c')](_0xed65('0x6d'),_0xed65('0x6e'))['field']('id',_0xed65('0x69'))[_0xed65('0x6c')](_0x12043c[_0xed65('0x74')]['toString'](),_0xed65('0x6a'))['field'](_0x4921c2[_0xed65('0x42')]['id'][_0xed65('0x6f')](),'CampaignId')[_0xed65('0x6c')](_0xed65('0x6d'),_0xed65('0x4d'))[_0xed65('0x6c')]('NOW()',_0xed65('0x4e'))['from']('cm_contacts')[_0xed65('0x37')](_0xed65('0x72'))[_0xed65('0x37')](_0xed65('0x73'),_0x12043c[_0xed65('0x74')]['toString']())[_0xed65('0x37')](_0xed65('0x75'))['where'](_0xed65('0x7c'),squel[_0xed65('0x76')]()[_0xed65('0x6c')](_0xed65('0x7a'))[_0xed65('0x70')]('cm_hopper')[_0xed65('0x37')](_0xed65('0x79'),_0x4921c2[_0xed65('0x42')]['id'][_0xed65('0x6f')]())))['toString']();break;default:_0xcb5363=squel[_0xed65('0x65')]()[_0xed65('0x66')]('cm_hopper')['fromQuery'](['phone',_0xed65('0x6e'),'ContactId',_0xed65('0x6a'),'CampaignId',_0xed65('0x4d'),_0xed65('0x4e')],squel[_0xed65('0x76')]()[_0xed65('0x6c')](_0xed65('0x6b'),_0xed65('0x6b'))[_0xed65('0x6c')]('NOW()',_0xed65('0x6e'))[_0xed65('0x6c')]('id',_0xed65('0x69'))[_0xed65('0x6c')](_0x12043c[_0xed65('0x74')][_0xed65('0x6f')](),_0xed65('0x6a'))['field'](_0x4921c2[_0xed65('0x42')]['id'][_0xed65('0x6f')](),_0xed65('0x56'))[_0xed65('0x6c')](_0xed65('0x6d'),'createdAt')['field'](_0xed65('0x6d'),_0xed65('0x4e'))['from'](_0xed65('0x71'))[_0xed65('0x37')](_0xed65('0x72'))[_0xed65('0x37')](_0xed65('0x73'),_0x12043c[_0xed65('0x74')][_0xed65('0x6f')]())[_0xed65('0x37')]('phone\x20IS\x20NOT\x20NULL'))[_0xed65('0x6f')]();}_0x42fc8['push'](db[_0xed65('0x7d')][_0xed65('0x2d')](_0xcb5363));}return BPromise[_0xed65('0x7e')](_0x42fc8);}})[_0xed65('0x1d')](function(){return _0x742a5a;})['then'](respondWithResult(_0x235d3d,null))[_0xed65('0x40')](handleError(_0x235d3d,null));};exports['removeLists']=function(_0x5a92b0,_0x3ff451,_0x126c4a){return db['Campaign'][_0xed65('0x49')]({'where':{'id':_0x5a92b0[_0xed65('0x42')]['id']}})[_0xed65('0x1d')](handleEntityNotFound(_0x3ff451,null))['then'](function(_0x330802){if(_0x330802){return _0x330802[_0xed65('0x7f')](_0x5a92b0['query'][_0xed65('0x61')]);}})[_0xed65('0x1d')](function(_0x2b7cff){if(_0x2b7cff){return db[_0xed65('0x54')]['destroy']({'where':{'ListId':_0x5a92b0[_0xed65('0x2d')][_0xed65('0x61')],'CampaignId':_0x5a92b0[_0xed65('0x42')]['id']}})[_0xed65('0x1d')](function(){return _0x2b7cff;});}})['then'](respondWithStatusCode(_0x3ff451,null))[_0xed65('0x40')](handleError(_0x3ff451,null));};exports[_0xed65('0x80')]=function(_0x10c2dc,_0x5b30cd,_0xe6bc5e){var _0xa88d99={'raw':!![],'where':{}};var _0x511e53={};var _0x5c8de9={'count':0x0,'rows':[]};return db[_0xed65('0x3d')][_0xed65('0x53')]({'where':{'id':_0x10c2dc[_0xed65('0x42')]['id']}})['then'](handleEntityNotFound(_0x5b30cd,null))['then'](function(_0x354cbd){if(_0x354cbd){_0x511e53[_0xed65('0x2b')]=_[_0xed65('0x2e')](db['CmList'][_0xed65('0x27')]);_0x511e53[_0xed65('0x2d')]=_[_0xed65('0x2e')](_0x10c2dc[_0xed65('0x2d')]);_0x511e53[_0xed65('0x2f')]=_[_0xed65('0x30')](_0x511e53['model'],_0x511e53[_0xed65('0x2d')]);_0xa88d99[_0xed65('0x32')]=_[_0xed65('0x30')](_0x511e53[_0xed65('0x2b')],qs[_0xed65('0x31')](_0x10c2dc['query']['fields']));_0xa88d99[_0xed65('0x32')]=_0xa88d99[_0xed65('0x32')][_0xed65('0x33')]?_0xa88d99[_0xed65('0x32')]:_0x511e53[_0xed65('0x2b')];if(!_0x10c2dc['query'][_0xed65('0x34')]('nolimit')){_0xa88d99[_0xed65('0x35')]=qs[_0xed65('0x35')](_0x10c2dc[_0xed65('0x2d')]['limit']);_0xa88d99[_0xed65('0x18')]=qs['offset'](_0x10c2dc['query'][_0xed65('0x18')]);}_0xa88d99[_0xed65('0x55')]=qs[_0xed65('0x36')](_0x10c2dc[_0xed65('0x2d')]['sort']);_0xa88d99[_0xed65('0x37')]=qs[_0xed65('0x2f')](_[_0xed65('0x38')](_0x10c2dc[_0xed65('0x2d')],_0x511e53[_0xed65('0x2f')]));_0xa88d99[_0xed65('0x37')][_0xed65('0x56')]=_0x354cbd['id'];if(_0x10c2dc[_0xed65('0x2d')][_0xed65('0x39')]){_0xa88d99[_0xed65('0x37')]=_[_0xed65('0x3a')](_0xa88d99[_0xed65('0x37')],{'$or':_[_0xed65('0x2c')](_0xa88d99[_0xed65('0x32')],function(_0x52ea85){var _0x488415={};_0x488415[_0x52ea85]={'$like':'%'+_0x10c2dc['query'][_0xed65('0x39')]+'%'};return _0x488415;})});}_0xa88d99=_[_0xed65('0x3a')]({},_0xa88d99,_0x10c2dc[_0xed65('0x3c')]);return db['CmList']['count']({'where':_0xa88d99[_0xed65('0x37')]})[_0xed65('0x1d')](function(_0x172f5c){_0x5c8de9[_0xed65('0x17')]=_0x172f5c;if(_0x10c2dc['query'][_0xed65('0x43')]){_0xa88d99[_0xed65('0x3e')]=[{'all':!![]}];}return db['CmList']['findAll'](_0xa88d99);})[_0xed65('0x1d')](function(_0x542e3b){_0x5c8de9[_0xed65('0x3f')]=_0x542e3b;return _0x5c8de9;});}})['then'](respondWithFilteredResult(_0x5b30cd,_0xa88d99))[_0xed65('0x40')](handleError(_0x5b30cd,null));};exports['addBlackLists']=function(_0x53d0ef,_0x18c407,_0x37b7d7){var _0x378512,_0x4fd983;return db[_0xed65('0x3d')][_0xed65('0x49')]({'where':{'id':_0x53d0ef[_0xed65('0x42')]['id']}})[_0xed65('0x1d')](handleEntityNotFound(_0x18c407,null))[_0xed65('0x1d')](function(_0x486b0c){if(_0x486b0c){_0x4fd983=_0x486b0c;return _0x486b0c[_0xed65('0x81')](_0x53d0ef['body']['ids'],_['omit'](_0x53d0ef[_0xed65('0x45')],[_0xed65('0x61'),'id'])||{});}return null;})[_0xed65('0x62')](function(_0x1b1481){var _0x255383;_0x378512=_0x1b1481||[];var _0x178b13=[];if(_0x1b1481){for(var _0x46a365=0x0;_0x46a365<_0x1b1481[_0xed65('0x33')];_0x46a365+=0x1){var _0x5553e9=_0x1b1481[_0x46a365][_0xed65('0x1e')]({'plain':!![]});_0x255383=squel[_0xed65('0x65')]()[_0xed65('0x66')]('cm_hopper_black')['fromQuery']([_0xed65('0x6b'),_0xed65('0x69'),_0xed65('0x6a'),_0xed65('0x56'),_0xed65('0x4d'),'updatedAt'],squel[_0xed65('0x76')]()[_0xed65('0x6c')](_0xed65('0x6b'),'phone')[_0xed65('0x6c')]('id',_0xed65('0x69'))[_0xed65('0x6c')](_0x5553e9['CmListId'][_0xed65('0x6f')](),'ListId')[_0xed65('0x6c')](_0x53d0ef['params']['id']['toString'](),_0xed65('0x56'))[_0xed65('0x6c')]('NOW()',_0xed65('0x4d'))[_0xed65('0x6c')](_0xed65('0x6d'),_0xed65('0x4e'))[_0xed65('0x70')](_0xed65('0x71'))[_0xed65('0x37')]('deletedAt\x20IS\x20NULL')[_0xed65('0x37')](_0xed65('0x73'),_0x5553e9['CmListId']['toString']())[_0xed65('0x37')]('phone\x20IS\x20NOT\x20NULL'))[_0xed65('0x6f')]();_0x178b13[_0xed65('0x82')](db['sequelize'][_0xed65('0x2d')](_0x255383));}return BPromise[_0xed65('0x7e')](_0x178b13);}})[_0xed65('0x1d')](function(){return _0x378512;})[_0xed65('0x1d')](respondWithResult(_0x18c407,null))[_0xed65('0x40')](handleError(_0x18c407,null));};exports[_0xed65('0x83')]=function(_0x1ea3a1,_0x41d25b,_0x3514e7){return db[_0xed65('0x3d')]['find']({'where':{'id':_0x1ea3a1['params']['id']}})[_0xed65('0x1d')](handleEntityNotFound(_0x41d25b,null))[_0xed65('0x1d')](function(_0x58d6e1){if(_0x58d6e1){return _0x58d6e1[_0xed65('0x83')](_0x1ea3a1[_0xed65('0x2d')]['ids']);}})[_0xed65('0x1d')](function(_0x134f97){if(_0x134f97){return db[_0xed65('0x5e')][_0xed65('0x51')]({'where':{'ListId':_0x1ea3a1['query'][_0xed65('0x61')],'CampaignId':_0x1ea3a1[_0xed65('0x42')]['id']}})[_0xed65('0x1d')](function(){return _0x134f97;});}})['then'](respondWithStatusCode(_0x41d25b,null))[_0xed65('0x40')](handleError(_0x41d25b,null));};