[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 _0x1280=['UserProfileSection','destroy','getHoppers','findOne','limit','CampaignId','CmHopper','rows','CmHopperHistory','hasOwnProperty','getHopperFinals','CmHopperFinal','getHopperBlacks','CmHopperBlack','getLists','CmList','addLists','ids','spread','dialCheckDuplicateType','always','insert','fromQuery','phone','scheduledAt','ContactId','ListId','updatedAt','NOW()','CmListId','toString','from','cm_contacts','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','select','COALESCE(calleridnum,\x27\x27)','cm_hopper_final','CampaignId\x20=\x20?','COALESCE(phone,\x27\x27)','cm_hopper','onlyIfOpen','into','push','sequelize','all','removeLists','getBlackLists','addBlackLists','omit','cm_hopper_black','removeBlackLists','rimraf','zip-dir','request-promise','moment','bluebird','mustache','util','sox','ejs','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','sendStatus','end','status','json','count','offset','apply','update','then','error','name','index','Campaign','model','keys','query','intersection','attributes','fields','length','nolimit','order','sort','filters','pick','filter','where','merge','map','key','VIRTUAL','field','options','include','findAll','catch','show','params','rawAttributes','includeAll','find','create','body','user','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','autoAssociation','UserProfileResource','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','createdAt','IvrCampaigns'];(function(_0x40155b,_0x12111b){var _0x436cc3=function(_0x33206f){while(--_0x33206f){_0x40155b['push'](_0x40155b['shift']());}};_0x436cc3(++_0x12111b);}(_0x1280,0x138));var _0x0128=function(_0x44268d,_0xad8443){_0x44268d=_0x44268d-0x0;var _0x4be92d=_0x1280[_0x44268d];return _0x4be92d;};'use strict';var pdf=require('html-pdf');var emlformat=require('eml-format');var rimraf=require(_0x0128('0x0'));var zipdir=require(_0x0128('0x1'));var jsonpatch=require('fast-json-patch');var rp=require(_0x0128('0x2'));var moment=require(_0x0128('0x3'));var BPromise=require(_0x0128('0x4'));var Mustache=require(_0x0128('0x5'));var util=require(_0x0128('0x6'));var path=require('path');var sox=require(_0x0128('0x7'));var csv=require('to-csv');var ejs=require(_0x0128('0x8'));var fs=require('fs');var _=require(_0x0128('0x9'));var squel=require(_0x0128('0xa'));var crypto=require(_0x0128('0xb'));var jsforce=require(_0x0128('0xc'));var deskjs=require(_0x0128('0xd'));var toCsv=require('to-csv');var querystring=require(_0x0128('0xe'));var Papa=require(_0x0128('0xf'));var Redis=require('ioredis');var authService=require(_0x0128('0x10'));var qs=require(_0x0128('0x11'));var hardwareService=require(_0x0128('0x12'));var logger=require(_0x0128('0x13'))('api');var utils=require(_0x0128('0x14'));var config=require(_0x0128('0x15'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0xd55750,_0x4bf20a){_0x4bf20a=_0x4bf20a||0xcc;return function(_0x421ce7){if(_0x421ce7){return _0xd55750[_0x0128('0x16')](_0x4bf20a);}return _0xd55750['status'](_0x4bf20a)[_0x0128('0x17')]();};}function respondWithResult(_0x23c01d,_0x3dfa4f){_0x3dfa4f=_0x3dfa4f||0xc8;return function(_0x20530e){if(_0x20530e){return _0x23c01d[_0x0128('0x18')](_0x3dfa4f)[_0x0128('0x19')](_0x20530e);}};}function respondWithFilteredResult(_0x4cb31c,_0x5d0549){return function(_0x35c512){if(_0x35c512){var _0x128cd0=_0x35c512[_0x0128('0x1a')],_0x2fdcb5=_0x5d0549[_0x0128('0x1b')],_0x522201=_0x5d0549['offset']+_0x5d0549['limit'],_0x164d76;if(_0x522201>=_0x128cd0){_0x522201=_0x128cd0;_0x164d76=0xc8;}else{_0x164d76=0xce;}_0x4cb31c[_0x0128('0x18')](_0x164d76);return _0x4cb31c['set']('Content-Range',_0x2fdcb5+'-'+_0x522201+'/'+_0x128cd0)[_0x0128('0x19')](_0x35c512);}return null;};}function patchUpdates(_0x5e729e){return function(_0x4bcad1){try{jsonpatch[_0x0128('0x1c')](_0x4bcad1,_0x5e729e,!![]);}catch(_0x528680){return BPromise['reject'](_0x528680);}return _0x4bcad1['save']();};}function saveUpdates(_0x1d6e88,_0xc7da50){return function(_0x27fa21){if(_0x27fa21){return _0x27fa21[_0x0128('0x1d')](_0x1d6e88)[_0x0128('0x1e')](function(_0x202c64){return _0x202c64;});}return null;};}function removeEntity(_0x5421d1,_0x56251b){return function(_0x7ad8ea){if(_0x7ad8ea){return _0x7ad8ea['destroy']()[_0x0128('0x1e')](function(){var _0x4f01aa=_0x7ad8ea['get']({'plain':!![]});var _0x143f46='IvrCampaigns';return db['UserProfileResource']['destroy']({'where':{'type':_0x143f46,'resourceId':_0x4f01aa['id']}})[_0x0128('0x1e')](function(){return _0x7ad8ea;});})[_0x0128('0x1e')](function(){_0x5421d1[_0x0128('0x18')](0xcc)[_0x0128('0x17')]();});}};}function handleEntityNotFound(_0x586307,_0x5abeb7){return function(_0x44f147){if(!_0x44f147){_0x586307['sendStatus'](0x194);}return _0x44f147;};}function handleError(_0x1f44fb,_0x17160d){_0x17160d=_0x17160d||0x1f4;return function(_0x2b2e55){logger[_0x0128('0x1f')](_0x2b2e55['stack']);if(_0x2b2e55['name']){delete _0x2b2e55[_0x0128('0x20')];}_0x1f44fb[_0x0128('0x18')](_0x17160d)['send'](_0x2b2e55);};}exports[_0x0128('0x21')]=function(_0x4dcb1d,_0x2b0849){var _0x77f740={},_0x3dda43={},_0x11cbdf={'count':0x0,'rows':[]};var _0xe368f0=db[_0x0128('0x22')]['rawAttributes'];_0x3dda43[_0x0128('0x23')]=_[_0x0128('0x24')](_0xe368f0);_0x3dda43['query']=_[_0x0128('0x24')](_0x4dcb1d[_0x0128('0x25')]);_0x3dda43['filters']=_[_0x0128('0x26')](_0x3dda43[_0x0128('0x23')],_0x3dda43[_0x0128('0x25')]);_0x77f740[_0x0128('0x27')]=_[_0x0128('0x26')](_0x3dda43[_0x0128('0x23')],qs[_0x0128('0x28')](_0x4dcb1d[_0x0128('0x25')]['fields']));_0x77f740[_0x0128('0x27')]=_0x77f740['attributes'][_0x0128('0x29')]?_0x77f740[_0x0128('0x27')]:_0x3dda43[_0x0128('0x23')];if(!_0x4dcb1d[_0x0128('0x25')]['hasOwnProperty'](_0x0128('0x2a'))){_0x77f740['limit']=qs['limit'](_0x4dcb1d[_0x0128('0x25')]['limit']);_0x77f740[_0x0128('0x1b')]=qs[_0x0128('0x1b')](_0x4dcb1d[_0x0128('0x25')][_0x0128('0x1b')]);}_0x77f740[_0x0128('0x2b')]=qs[_0x0128('0x2c')](_0x4dcb1d[_0x0128('0x25')]['sort']);_0x77f740['where']=qs[_0x0128('0x2d')](_[_0x0128('0x2e')](_0x4dcb1d[_0x0128('0x25')],_0x3dda43['filters']));if(_0x4dcb1d[_0x0128('0x25')][_0x0128('0x2f')]){_0x77f740[_0x0128('0x30')]=_[_0x0128('0x31')](_0x77f740[_0x0128('0x30')],{'$or':_[_0x0128('0x32')](_0xe368f0,function(_0x2b5377){if(_0x2b5377['type'][_0x0128('0x33')]!==_0x0128('0x34')){var _0x43aa0b={};_0x43aa0b[_0x2b5377[_0x0128('0x35')]]={'$like':'%'+_0x4dcb1d['query']['filter']+'%'};return _0x43aa0b;}})});}_0x77f740=_['merge']({},_0x77f740,_0x4dcb1d[_0x0128('0x36')]);var _0x7981c5={'where':_0x77f740[_0x0128('0x30')]};return db[_0x0128('0x22')][_0x0128('0x1a')](_0x7981c5)[_0x0128('0x1e')](function(_0x3e7e74){_0x11cbdf[_0x0128('0x1a')]=_0x3e7e74;if(_0x4dcb1d[_0x0128('0x25')]['includeAll']){_0x77f740[_0x0128('0x37')]=[{'all':!![]}];}return db[_0x0128('0x22')][_0x0128('0x38')](_0x77f740);})[_0x0128('0x1e')](function(_0x2aced1){_0x11cbdf['rows']=_0x2aced1;return _0x11cbdf;})['then'](respondWithFilteredResult(_0x2b0849,_0x77f740))[_0x0128('0x39')](handleError(_0x2b0849,null));};exports[_0x0128('0x3a')]=function(_0x30015a,_0x326e5c){var _0x263bc5={'raw':![],'where':{'id':_0x30015a[_0x0128('0x3b')]['id']}},_0x289897={};_0x289897[_0x0128('0x23')]=_[_0x0128('0x24')](db[_0x0128('0x22')][_0x0128('0x3c')]);_0x289897[_0x0128('0x25')]=_[_0x0128('0x24')](_0x30015a[_0x0128('0x25')]);_0x289897[_0x0128('0x2d')]=_[_0x0128('0x26')](_0x289897['model'],_0x289897[_0x0128('0x25')]);_0x263bc5[_0x0128('0x27')]=_[_0x0128('0x26')](_0x289897['model'],qs[_0x0128('0x28')](_0x30015a[_0x0128('0x25')][_0x0128('0x28')]));_0x263bc5['attributes']=_0x263bc5[_0x0128('0x27')]['length']?_0x263bc5['attributes']:_0x289897[_0x0128('0x23')];if(_0x30015a['query'][_0x0128('0x3d')]){_0x263bc5[_0x0128('0x37')]=[{'all':!![]}];}_0x263bc5=_['merge']({},_0x263bc5,_0x30015a[_0x0128('0x36')]);return db['Campaign'][_0x0128('0x3e')](_0x263bc5)[_0x0128('0x1e')](handleEntityNotFound(_0x326e5c,null))[_0x0128('0x1e')](respondWithResult(_0x326e5c,null))[_0x0128('0x39')](handleError(_0x326e5c,null));};exports[_0x0128('0x3f')]=function(_0x42b92e,_0x2a7d6c){return db[_0x0128('0x22')][_0x0128('0x3f')](_0x42b92e[_0x0128('0x40')],{})[_0x0128('0x1e')](function(_0x46fc07){var _0x143a5a=_0x42b92e[_0x0128('0x41')][_0x0128('0x42')]({'plain':!![]});if(!_0x143a5a)throw new Error(_0x0128('0x43'));if(_0x143a5a[_0x0128('0x44')]===_0x0128('0x41')){var _0x5a61f9=_0x46fc07[_0x0128('0x42')]({'plain':!![]});var _0xd7b031='IvrCampaigns';return db['UserProfileSection'][_0x0128('0x3e')]({'where':{'name':_0xd7b031,'userProfileId':_0x143a5a['userProfileId']},'raw':!![]})['then'](function(_0x469406){if(_0x469406&&_0x469406[_0x0128('0x45')]===0x0){return db[_0x0128('0x46')][_0x0128('0x3f')]({'name':_0x5a61f9[_0x0128('0x20')],'resourceId':_0x5a61f9['id'],'type':_0x469406['name'],'sectionId':_0x469406['id']},{})['then'](function(){return _0x46fc07;});}else{return _0x46fc07;}})[_0x0128('0x39')](function(_0x1c3eaf){logger['error'](_0x0128('0x47'),_0x1c3eaf);throw _0x1c3eaf;});}return _0x46fc07;})['then'](respondWithResult(_0x2a7d6c,0xc9))[_0x0128('0x39')](handleError(_0x2a7d6c,null));};exports[_0x0128('0x48')]=function(_0x38e560,_0x144ba1){var _0x422aa6={'raw':![],'where':{'id':_0x38e560['params']['id']}},_0x11e588={};_0x11e588['model']=_[_0x0128('0x24')](db[_0x0128('0x22')][_0x0128('0x3c')]);_0x422aa6['attributes']=_[_0x0128('0x26')](_0x11e588[_0x0128('0x23')],qs[_0x0128('0x28')](_0x38e560[_0x0128('0x25')][_0x0128('0x28')]));_0x422aa6[_0x0128('0x27')]=_0x422aa6['attributes'][_0x0128('0x29')]?_0x422aa6[_0x0128('0x27')]:_0x11e588['model'];if(_0x38e560['query'][_0x0128('0x3d')]){_0x422aa6[_0x0128('0x37')]=[{'all':!![]}];}_0x422aa6=_[_0x0128('0x31')]({},_0x422aa6,_0x38e560[_0x0128('0x36')]);return db[_0x0128('0x22')]['find'](_0x422aa6)[_0x0128('0x1e')](handleEntityNotFound(_0x144ba1,null))[_0x0128('0x1e')](function(_0x51977b){if(_0x51977b){var _0x114447=_0x51977b[_0x0128('0x42')]({'plain':!![]});_0x114447=qs['omit'](_0x114447,['id',_0x0128('0x49'),'updatedAt']);_0x38e560[_0x0128('0x40')]=_['omit'](_0x38e560[_0x0128('0x40')],['id',_0x0128('0x49'),'updatedAt']);return db[_0x0128('0x22')]['create'](_['merge'](_0x114447,_0x38e560[_0x0128('0x40')]),{'include':_0x38e560[_0x0128('0x25')][_0x0128('0x3d')]?[{'all':!![]}]:undefined})['then'](function(_0x54059c){var _0x56b618=_0x38e560[_0x0128('0x41')][_0x0128('0x42')]({'plain':!![]});if(!_0x56b618)throw new Error(_0x0128('0x43'));if(_0x56b618[_0x0128('0x44')]===_0x0128('0x41')){var _0x168a4b=_0x54059c[_0x0128('0x42')]({'plain':!![]});var _0x425435=_0x0128('0x4a');return db[_0x0128('0x4b')][_0x0128('0x3e')]({'where':{'name':_0x425435,'userProfileId':_0x56b618['userProfileId']},'raw':!![]})[_0x0128('0x1e')](function(_0x45fd73){if(_0x45fd73&&_0x45fd73[_0x0128('0x45')]===0x0){return db[_0x0128('0x46')]['create']({'name':_0x168a4b['name'],'resourceId':_0x168a4b['id'],'type':_0x45fd73[_0x0128('0x20')],'sectionId':_0x45fd73['id']},{})[_0x0128('0x1e')](function(){return _0x54059c;});}else{return _0x54059c;}})[_0x0128('0x39')](function(_0x11a566){logger[_0x0128('0x1f')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x11a566);throw _0x11a566;});}return _0x54059c;});}})[_0x0128('0x1e')](respondWithResult(_0x144ba1,0xc9))[_0x0128('0x39')](handleError(_0x144ba1,null));};exports[_0x0128('0x1d')]=function(_0x4215b7,_0x2e310b){if(_0x4215b7['body']['id']){delete _0x4215b7[_0x0128('0x40')]['id'];}return db[_0x0128('0x22')][_0x0128('0x3e')]({'where':{'id':_0x4215b7[_0x0128('0x3b')]['id']}})[_0x0128('0x1e')](handleEntityNotFound(_0x2e310b,null))['then'](saveUpdates(_0x4215b7[_0x0128('0x40')],null))[_0x0128('0x1e')](respondWithResult(_0x2e310b,null))[_0x0128('0x39')](handleError(_0x2e310b,null));};exports[_0x0128('0x4c')]=function(_0x2ad92a,_0x452029){return db['Campaign']['find']({'where':{'id':_0x2ad92a['params']['id']}})[_0x0128('0x1e')](handleEntityNotFound(_0x452029,null))[_0x0128('0x1e')](removeEntity(_0x452029,null))[_0x0128('0x39')](handleError(_0x452029,null));};exports[_0x0128('0x4d')]=function(_0x289f1c,_0x2be8a4,_0x4eb664){var _0x1d6e00={'raw':!![],'where':{}};var _0x40da5e={};var _0x58c7dc={'count':0x0,'rows':[]};return db[_0x0128('0x22')][_0x0128('0x4e')]({'where':{'id':_0x289f1c['params']['id']}})[_0x0128('0x1e')](handleEntityNotFound(_0x2be8a4,null))['then'](function(_0x51bb42){if(_0x51bb42){_0x40da5e[_0x0128('0x23')]=_[_0x0128('0x24')](db['CmHopper']['rawAttributes']);_0x40da5e[_0x0128('0x25')]=_[_0x0128('0x24')](_0x289f1c['query']);_0x40da5e['filters']=_[_0x0128('0x26')](_0x40da5e[_0x0128('0x23')],_0x40da5e['query']);_0x1d6e00['attributes']=_[_0x0128('0x26')](_0x40da5e[_0x0128('0x23')],qs[_0x0128('0x28')](_0x289f1c['query']['fields']));_0x1d6e00['attributes']=_0x1d6e00[_0x0128('0x27')][_0x0128('0x29')]?_0x1d6e00['attributes']:_0x40da5e[_0x0128('0x23')];if(!_0x289f1c[_0x0128('0x25')]['hasOwnProperty']('nolimit')){_0x1d6e00['limit']=qs[_0x0128('0x4f')](_0x289f1c[_0x0128('0x25')]['limit']);_0x1d6e00['offset']=qs['offset'](_0x289f1c['query']['offset']);}_0x1d6e00['order']=qs['sort'](_0x289f1c[_0x0128('0x25')][_0x0128('0x2c')]);_0x1d6e00['where']=qs['filters'](_[_0x0128('0x2e')](_0x289f1c[_0x0128('0x25')],_0x40da5e[_0x0128('0x2d')]));_0x1d6e00[_0x0128('0x30')][_0x0128('0x50')]=_0x51bb42['id'];if(_0x289f1c[_0x0128('0x25')][_0x0128('0x2f')]){_0x1d6e00[_0x0128('0x30')]=_[_0x0128('0x31')](_0x1d6e00[_0x0128('0x30')],{'$or':_[_0x0128('0x32')](_0x1d6e00[_0x0128('0x27')],function(_0x4fc143){var _0x12597d={};_0x12597d[_0x4fc143]={'$like':'%'+_0x289f1c[_0x0128('0x25')][_0x0128('0x2f')]+'%'};return _0x12597d;})});}_0x1d6e00=_['merge']({},_0x1d6e00,_0x289f1c[_0x0128('0x36')]);return db[_0x0128('0x51')][_0x0128('0x1a')]({'where':_0x1d6e00[_0x0128('0x30')]})[_0x0128('0x1e')](function(_0x4c33c6){_0x58c7dc[_0x0128('0x1a')]=_0x4c33c6;if(_0x289f1c[_0x0128('0x25')]['includeAll']){_0x1d6e00['include']=[{'all':!![]}];}return db[_0x0128('0x51')]['findAll'](_0x1d6e00);})[_0x0128('0x1e')](function(_0x2d4cd9){_0x58c7dc[_0x0128('0x52')]=_0x2d4cd9;return _0x58c7dc;});}})[_0x0128('0x1e')](respondWithFilteredResult(_0x2be8a4,_0x1d6e00))[_0x0128('0x39')](handleError(_0x2be8a4,null));};exports['getHopperHistories']=function(_0x4352b9,_0x3d5f57,_0x2d208c){var _0x196382={'raw':!![],'where':{}};var _0x21ca44={};var _0x161de7={'count':0x0,'rows':[]};return db[_0x0128('0x22')][_0x0128('0x4e')]({'where':{'id':_0x4352b9[_0x0128('0x3b')]['id']}})['then'](handleEntityNotFound(_0x3d5f57,null))[_0x0128('0x1e')](function(_0x258d26){if(_0x258d26){_0x21ca44[_0x0128('0x23')]=_[_0x0128('0x24')](db[_0x0128('0x53')][_0x0128('0x3c')]);_0x21ca44['query']=_[_0x0128('0x24')](_0x4352b9['query']);_0x21ca44[_0x0128('0x2d')]=_[_0x0128('0x26')](_0x21ca44['model'],_0x21ca44[_0x0128('0x25')]);_0x196382[_0x0128('0x27')]=_[_0x0128('0x26')](_0x21ca44[_0x0128('0x23')],qs['fields'](_0x4352b9[_0x0128('0x25')][_0x0128('0x28')]));_0x196382[_0x0128('0x27')]=_0x196382[_0x0128('0x27')][_0x0128('0x29')]?_0x196382[_0x0128('0x27')]:_0x21ca44[_0x0128('0x23')];if(!_0x4352b9[_0x0128('0x25')][_0x0128('0x54')]('nolimit')){_0x196382[_0x0128('0x4f')]=qs[_0x0128('0x4f')](_0x4352b9[_0x0128('0x25')]['limit']);_0x196382[_0x0128('0x1b')]=qs['offset'](_0x4352b9['query'][_0x0128('0x1b')]);}_0x196382['order']=qs['sort'](_0x4352b9['query'][_0x0128('0x2c')]);_0x196382[_0x0128('0x30')]=qs['filters'](_[_0x0128('0x2e')](_0x4352b9[_0x0128('0x25')],_0x21ca44[_0x0128('0x2d')]));_0x196382[_0x0128('0x30')]['CampaignId']=_0x258d26['id'];if(_0x4352b9[_0x0128('0x25')][_0x0128('0x2f')]){_0x196382[_0x0128('0x30')]=_[_0x0128('0x31')](_0x196382['where'],{'$or':_[_0x0128('0x32')](_0x196382['attributes'],function(_0x28eee4){var _0x1cdf53={};_0x1cdf53[_0x28eee4]={'$like':'%'+_0x4352b9[_0x0128('0x25')][_0x0128('0x2f')]+'%'};return _0x1cdf53;})});}_0x196382=_[_0x0128('0x31')]({},_0x196382,_0x4352b9[_0x0128('0x36')]);return db[_0x0128('0x53')][_0x0128('0x1a')]({'where':_0x196382[_0x0128('0x30')]})[_0x0128('0x1e')](function(_0x487daa){_0x161de7[_0x0128('0x1a')]=_0x487daa;if(_0x4352b9[_0x0128('0x25')][_0x0128('0x3d')]){_0x196382['include']=[{'all':!![]}];}return db[_0x0128('0x53')][_0x0128('0x38')](_0x196382);})[_0x0128('0x1e')](function(_0x5928a5){_0x161de7[_0x0128('0x52')]=_0x5928a5;return _0x161de7;});}})[_0x0128('0x1e')](respondWithFilteredResult(_0x3d5f57,_0x196382))[_0x0128('0x39')](handleError(_0x3d5f57,null));};exports[_0x0128('0x55')]=function(_0x3346d9,_0xdf82d8,_0x51555f){var _0x3f6646={'raw':!![],'where':{}};var _0x3a7e36={};var _0x3c3532={'count':0x0,'rows':[]};return db['Campaign'][_0x0128('0x4e')]({'where':{'id':_0x3346d9['params']['id']}})[_0x0128('0x1e')](handleEntityNotFound(_0xdf82d8,null))[_0x0128('0x1e')](function(_0x4f8e7f){if(_0x4f8e7f){_0x3a7e36[_0x0128('0x23')]=_['keys'](db[_0x0128('0x56')][_0x0128('0x3c')]);_0x3a7e36[_0x0128('0x25')]=_[_0x0128('0x24')](_0x3346d9[_0x0128('0x25')]);_0x3a7e36[_0x0128('0x2d')]=_[_0x0128('0x26')](_0x3a7e36[_0x0128('0x23')],_0x3a7e36[_0x0128('0x25')]);_0x3f6646['attributes']=_[_0x0128('0x26')](_0x3a7e36['model'],qs[_0x0128('0x28')](_0x3346d9[_0x0128('0x25')][_0x0128('0x28')]));_0x3f6646['attributes']=_0x3f6646['attributes'][_0x0128('0x29')]?_0x3f6646[_0x0128('0x27')]:_0x3a7e36[_0x0128('0x23')];if(!_0x3346d9['query'][_0x0128('0x54')]('nolimit')){_0x3f6646['limit']=qs[_0x0128('0x4f')](_0x3346d9[_0x0128('0x25')][_0x0128('0x4f')]);_0x3f6646[_0x0128('0x1b')]=qs[_0x0128('0x1b')](_0x3346d9['query'][_0x0128('0x1b')]);}_0x3f6646['order']=qs[_0x0128('0x2c')](_0x3346d9[_0x0128('0x25')][_0x0128('0x2c')]);_0x3f6646[_0x0128('0x30')]=qs[_0x0128('0x2d')](_[_0x0128('0x2e')](_0x3346d9[_0x0128('0x25')],_0x3a7e36['filters']));_0x3f6646['where'][_0x0128('0x50')]=_0x4f8e7f['id'];if(_0x3346d9[_0x0128('0x25')][_0x0128('0x2f')]){_0x3f6646['where']=_[_0x0128('0x31')](_0x3f6646[_0x0128('0x30')],{'$or':_[_0x0128('0x32')](_0x3f6646[_0x0128('0x27')],function(_0x4c51ea){var _0x3c3c0d={};_0x3c3c0d[_0x4c51ea]={'$like':'%'+_0x3346d9[_0x0128('0x25')]['filter']+'%'};return _0x3c3c0d;})});}_0x3f6646=_[_0x0128('0x31')]({},_0x3f6646,_0x3346d9['options']);return db[_0x0128('0x56')][_0x0128('0x1a')]({'where':_0x3f6646[_0x0128('0x30')]})[_0x0128('0x1e')](function(_0x2078dd){_0x3c3532['count']=_0x2078dd;if(_0x3346d9['query'][_0x0128('0x3d')]){_0x3f6646[_0x0128('0x37')]=[{'all':!![]}];}return db[_0x0128('0x56')][_0x0128('0x38')](_0x3f6646);})[_0x0128('0x1e')](function(_0x1f0606){_0x3c3532['rows']=_0x1f0606;return _0x3c3532;});}})['then'](respondWithFilteredResult(_0xdf82d8,_0x3f6646))['catch'](handleError(_0xdf82d8,null));};exports[_0x0128('0x57')]=function(_0x511f7e,_0x3b7279,_0x54b2fc){var _0x463b7e={'raw':!![],'where':{}};var _0x244bbf={};var _0x432dc7={'count':0x0,'rows':[]};return db[_0x0128('0x22')][_0x0128('0x4e')]({'where':{'id':_0x511f7e['params']['id']}})[_0x0128('0x1e')](handleEntityNotFound(_0x3b7279,null))[_0x0128('0x1e')](function(_0x205687){if(_0x205687){_0x244bbf[_0x0128('0x23')]=_[_0x0128('0x24')](db['CmHopperBlack'][_0x0128('0x3c')]);_0x244bbf[_0x0128('0x25')]=_[_0x0128('0x24')](_0x511f7e['query']);_0x244bbf['filters']=_[_0x0128('0x26')](_0x244bbf[_0x0128('0x23')],_0x244bbf['query']);_0x463b7e[_0x0128('0x27')]=_[_0x0128('0x26')](_0x244bbf[_0x0128('0x23')],qs[_0x0128('0x28')](_0x511f7e['query'][_0x0128('0x28')]));_0x463b7e['attributes']=_0x463b7e[_0x0128('0x27')][_0x0128('0x29')]?_0x463b7e[_0x0128('0x27')]:_0x244bbf['model'];if(!_0x511f7e[_0x0128('0x25')][_0x0128('0x54')](_0x0128('0x2a'))){_0x463b7e[_0x0128('0x4f')]=qs[_0x0128('0x4f')](_0x511f7e[_0x0128('0x25')][_0x0128('0x4f')]);_0x463b7e[_0x0128('0x1b')]=qs[_0x0128('0x1b')](_0x511f7e[_0x0128('0x25')][_0x0128('0x1b')]);}_0x463b7e['order']=qs[_0x0128('0x2c')](_0x511f7e[_0x0128('0x25')]['sort']);_0x463b7e[_0x0128('0x30')]=qs['filters'](_['pick'](_0x511f7e[_0x0128('0x25')],_0x244bbf[_0x0128('0x2d')]));_0x463b7e[_0x0128('0x30')][_0x0128('0x50')]=_0x205687['id'];if(_0x511f7e[_0x0128('0x25')]['filter']){_0x463b7e[_0x0128('0x30')]=_[_0x0128('0x31')](_0x463b7e[_0x0128('0x30')],{'$or':_[_0x0128('0x32')](_0x463b7e['attributes'],function(_0x451a27){var _0x5c9b77={};_0x5c9b77[_0x451a27]={'$like':'%'+_0x511f7e[_0x0128('0x25')][_0x0128('0x2f')]+'%'};return _0x5c9b77;})});}_0x463b7e=_[_0x0128('0x31')]({},_0x463b7e,_0x511f7e[_0x0128('0x36')]);return db[_0x0128('0x58')][_0x0128('0x1a')]({'where':_0x463b7e[_0x0128('0x30')]})['then'](function(_0x5768c4){_0x432dc7[_0x0128('0x1a')]=_0x5768c4;if(_0x511f7e[_0x0128('0x25')]['includeAll']){_0x463b7e['include']=[{'all':!![]}];}return db[_0x0128('0x58')][_0x0128('0x38')](_0x463b7e);})[_0x0128('0x1e')](function(_0x52b9d0){_0x432dc7[_0x0128('0x52')]=_0x52b9d0;return _0x432dc7;});}})[_0x0128('0x1e')](respondWithFilteredResult(_0x3b7279,_0x463b7e))[_0x0128('0x39')](handleError(_0x3b7279,null));};exports[_0x0128('0x59')]=function(_0x30be57,_0x442b09,_0x52db23){var _0x1c7ff1={};var _0x4339c4={};var _0x5d3e52;var _0x16f860;return db[_0x0128('0x22')][_0x0128('0x4e')]({'where':{'id':_0x30be57['params']['id']}})[_0x0128('0x1e')](handleEntityNotFound(_0x442b09,null))[_0x0128('0x1e')](function(_0x291a80){if(_0x291a80){_0x5d3e52=_0x291a80;_0x4339c4[_0x0128('0x23')]=_[_0x0128('0x24')](db[_0x0128('0x5a')][_0x0128('0x3c')]);_0x4339c4['query']=_[_0x0128('0x24')](_0x30be57[_0x0128('0x25')]);_0x4339c4[_0x0128('0x2d')]=_[_0x0128('0x26')](_0x4339c4[_0x0128('0x23')],_0x4339c4[_0x0128('0x25')]);_0x1c7ff1[_0x0128('0x27')]=_['intersection'](_0x4339c4[_0x0128('0x23')],qs[_0x0128('0x28')](_0x30be57['query'][_0x0128('0x28')]));_0x1c7ff1['attributes']=_0x1c7ff1[_0x0128('0x27')][_0x0128('0x29')]?_0x1c7ff1['attributes']:_0x4339c4['model'];_0x1c7ff1[_0x0128('0x2b')]=qs[_0x0128('0x2c')](_0x30be57['query'][_0x0128('0x2c')]);_0x1c7ff1[_0x0128('0x30')]=qs[_0x0128('0x2d')](_[_0x0128('0x2e')](_0x30be57[_0x0128('0x25')],_0x4339c4[_0x0128('0x2d')]));if(_0x30be57['query'][_0x0128('0x2f')]){_0x1c7ff1[_0x0128('0x30')]=_[_0x0128('0x31')](_0x1c7ff1[_0x0128('0x30')],{'$or':_[_0x0128('0x32')](_0x1c7ff1[_0x0128('0x27')],function(_0x38f06f){var _0x4ebef5={};_0x4ebef5[_0x38f06f]={'$like':'%'+_0x30be57['query'][_0x0128('0x2f')]+'%'};return _0x4ebef5;})});}_0x1c7ff1=_[_0x0128('0x31')]({},_0x1c7ff1,_0x30be57[_0x0128('0x36')]);return _0x5d3e52[_0x0128('0x59')](_0x1c7ff1);}})[_0x0128('0x1e')](function(_0x9388d){if(_0x9388d){_0x16f860=_0x9388d[_0x0128('0x29')];if(!_0x30be57[_0x0128('0x25')][_0x0128('0x54')](_0x0128('0x2a'))){_0x1c7ff1[_0x0128('0x4f')]=qs[_0x0128('0x4f')](_0x30be57['query'][_0x0128('0x4f')]);_0x1c7ff1['offset']=qs['offset'](_0x30be57[_0x0128('0x25')][_0x0128('0x1b')]);}return _0x5d3e52[_0x0128('0x59')](_0x1c7ff1);}})['then'](function(_0x5747ea){if(_0x5747ea){return _0x5747ea?{'count':_0x16f860,'rows':_0x5747ea}:null;}})[_0x0128('0x1e')](respondWithResult(_0x442b09,null))[_0x0128('0x39')](handleError(_0x442b09,null));};exports[_0x0128('0x5b')]=function(_0x87232b,_0x51664f,_0x2dadca){var _0x34d8ea,_0xb7028;return db[_0x0128('0x22')][_0x0128('0x3e')]({'where':{'id':_0x87232b[_0x0128('0x3b')]['id']}})[_0x0128('0x1e')](handleEntityNotFound(_0x51664f,null))['then'](function(_0x1492d5){if(_0x1492d5){_0xb7028=_0x1492d5;return _0x1492d5[_0x0128('0x5b')](_0x87232b[_0x0128('0x40')]['ids'],_['omit'](_0x87232b[_0x0128('0x40')],[_0x0128('0x5c'),'id'])||{});}return null;})[_0x0128('0x5d')](function(_0x1e0d54){var _0x1982e3;_0x34d8ea=_0x1e0d54||[];var _0x417493=[];if(_0x1e0d54){for(var _0x4dc612=0x0;_0x4dc612<_0x1e0d54[_0x0128('0x29')];_0x4dc612+=0x1){var _0x44ff71=_0x1e0d54[_0x4dc612][_0x0128('0x42')]({'plain':!![]});_0xb7028[_0x0128('0x5e')]=_0x87232b[_0x0128('0x40')][_0x0128('0x5e')]?_0x87232b[_0x0128('0x40')]['dialCheckDuplicateType']:_0xb7028[_0x0128('0x5e')];switch(_0xb7028[_0x0128('0x5e')]){case _0x0128('0x5f'):_0x1982e3=squel[_0x0128('0x60')]()['into']('cm_hopper')[_0x0128('0x61')]([_0x0128('0x62'),_0x0128('0x63'),_0x0128('0x64'),_0x0128('0x65'),_0x0128('0x50'),_0x0128('0x49'),_0x0128('0x66')],squel['select']()[_0x0128('0x35')](_0x0128('0x62'),'phone')[_0x0128('0x35')](_0x0128('0x67'),_0x0128('0x63'))[_0x0128('0x35')]('id',_0x0128('0x64'))['field'](_0x44ff71[_0x0128('0x68')][_0x0128('0x69')](),'ListId')['field'](_0x87232b[_0x0128('0x3b')]['id']['toString'](),_0x0128('0x50'))[_0x0128('0x35')](_0x0128('0x67'),'createdAt')[_0x0128('0x35')](_0x0128('0x67'),_0x0128('0x66'))[_0x0128('0x6a')](_0x0128('0x6b'))[_0x0128('0x30')](_0x0128('0x6c'))['where'](_0x0128('0x6d'),_0x44ff71[_0x0128('0x68')][_0x0128('0x69')]())[_0x0128('0x30')](_0x0128('0x6e'))[_0x0128('0x30')](_0x0128('0x6f'),squel[_0x0128('0x70')]()[_0x0128('0x35')](_0x0128('0x71'))['from'](_0x0128('0x72'))[_0x0128('0x30')](_0x0128('0x73'),_0x87232b[_0x0128('0x3b')]['id'][_0x0128('0x69')]()))[_0x0128('0x30')]('phone\x20NOT\x20IN\x20(?)',squel[_0x0128('0x70')]()[_0x0128('0x35')](_0x0128('0x74'))['from'](_0x0128('0x75'))[_0x0128('0x30')]('CampaignId\x20=\x20?',_0x87232b[_0x0128('0x3b')]['id'][_0x0128('0x69')]())))[_0x0128('0x69')]();break;case _0x0128('0x76'):_0x1982e3=squel['insert']()['into']('cm_hopper')['fromQuery']([_0x0128('0x62'),'scheduledAt',_0x0128('0x64'),_0x0128('0x65'),_0x0128('0x50'),_0x0128('0x49'),_0x0128('0x66')],squel[_0x0128('0x70')]()[_0x0128('0x35')](_0x0128('0x62'),_0x0128('0x62'))[_0x0128('0x35')](_0x0128('0x67'),_0x0128('0x63'))[_0x0128('0x35')]('id',_0x0128('0x64'))[_0x0128('0x35')](_0x44ff71[_0x0128('0x68')][_0x0128('0x69')](),_0x0128('0x65'))['field'](_0x87232b[_0x0128('0x3b')]['id'][_0x0128('0x69')](),_0x0128('0x50'))['field'](_0x0128('0x67'),_0x0128('0x49'))[_0x0128('0x35')](_0x0128('0x67'),_0x0128('0x66'))[_0x0128('0x6a')](_0x0128('0x6b'))[_0x0128('0x30')](_0x0128('0x6c'))[_0x0128('0x30')]('ListId\x20=\x20?',_0x44ff71[_0x0128('0x68')][_0x0128('0x69')]())[_0x0128('0x30')](_0x0128('0x6e'))[_0x0128('0x30')](_0x0128('0x6f'),squel['select']()[_0x0128('0x35')](_0x0128('0x74'))[_0x0128('0x6a')]('cm_hopper')[_0x0128('0x30')]('CampaignId\x20=\x20?',_0x87232b[_0x0128('0x3b')]['id'][_0x0128('0x69')]())))[_0x0128('0x69')]();break;default:_0x1982e3=squel[_0x0128('0x60')]()[_0x0128('0x77')](_0x0128('0x75'))[_0x0128('0x61')]([_0x0128('0x62'),_0x0128('0x63'),'ContactId',_0x0128('0x65'),_0x0128('0x50'),'createdAt',_0x0128('0x66')],squel[_0x0128('0x70')]()[_0x0128('0x35')](_0x0128('0x62'),_0x0128('0x62'))[_0x0128('0x35')]('NOW()',_0x0128('0x63'))[_0x0128('0x35')]('id',_0x0128('0x64'))[_0x0128('0x35')](_0x44ff71[_0x0128('0x68')]['toString'](),_0x0128('0x65'))['field'](_0x87232b[_0x0128('0x3b')]['id'][_0x0128('0x69')](),_0x0128('0x50'))[_0x0128('0x35')](_0x0128('0x67'),_0x0128('0x49'))[_0x0128('0x35')](_0x0128('0x67'),_0x0128('0x66'))['from'](_0x0128('0x6b'))[_0x0128('0x30')](_0x0128('0x6c'))['where']('ListId\x20=\x20?',_0x44ff71['CmListId']['toString']())['where']('phone\x20IS\x20NOT\x20NULL'))[_0x0128('0x69')]();}_0x417493[_0x0128('0x78')](db[_0x0128('0x79')][_0x0128('0x25')](_0x1982e3));}return BPromise[_0x0128('0x7a')](_0x417493);}})[_0x0128('0x1e')](function(){return _0x34d8ea;})[_0x0128('0x1e')](respondWithResult(_0x51664f,null))[_0x0128('0x39')](handleError(_0x51664f,null));};exports['removeLists']=function(_0x40477a,_0x36eddb,_0x482b9f){return db[_0x0128('0x22')][_0x0128('0x3e')]({'where':{'id':_0x40477a[_0x0128('0x3b')]['id']}})[_0x0128('0x1e')](handleEntityNotFound(_0x36eddb,null))[_0x0128('0x1e')](function(_0x20edd2){if(_0x20edd2){return _0x20edd2[_0x0128('0x7b')](_0x40477a['query'][_0x0128('0x5c')]);}})[_0x0128('0x1e')](function(_0x4938b9){if(_0x4938b9){return db[_0x0128('0x51')][_0x0128('0x4c')]({'where':{'ListId':_0x40477a[_0x0128('0x25')]['ids'],'CampaignId':_0x40477a[_0x0128('0x3b')]['id']}})[_0x0128('0x1e')](function(){return _0x4938b9;});}})['then'](respondWithStatusCode(_0x36eddb,null))[_0x0128('0x39')](handleError(_0x36eddb,null));};exports[_0x0128('0x7c')]=function(_0x1f5477,_0x32881d,_0x302e4d){var _0x38b426={'raw':!![],'where':{}};var _0x3576dc={};var _0x3b3979={'count':0x0,'rows':[]};return db[_0x0128('0x22')][_0x0128('0x4e')]({'where':{'id':_0x1f5477[_0x0128('0x3b')]['id']}})['then'](handleEntityNotFound(_0x32881d,null))[_0x0128('0x1e')](function(_0x366f20){if(_0x366f20){_0x3576dc[_0x0128('0x23')]=_[_0x0128('0x24')](db[_0x0128('0x5a')][_0x0128('0x3c')]);_0x3576dc[_0x0128('0x25')]=_[_0x0128('0x24')](_0x1f5477[_0x0128('0x25')]);_0x3576dc['filters']=_[_0x0128('0x26')](_0x3576dc[_0x0128('0x23')],_0x3576dc[_0x0128('0x25')]);_0x38b426['attributes']=_[_0x0128('0x26')](_0x3576dc[_0x0128('0x23')],qs['fields'](_0x1f5477[_0x0128('0x25')][_0x0128('0x28')]));_0x38b426[_0x0128('0x27')]=_0x38b426[_0x0128('0x27')]['length']?_0x38b426[_0x0128('0x27')]:_0x3576dc[_0x0128('0x23')];if(!_0x1f5477['query']['hasOwnProperty'](_0x0128('0x2a'))){_0x38b426[_0x0128('0x4f')]=qs[_0x0128('0x4f')](_0x1f5477[_0x0128('0x25')][_0x0128('0x4f')]);_0x38b426[_0x0128('0x1b')]=qs[_0x0128('0x1b')](_0x1f5477['query'][_0x0128('0x1b')]);}_0x38b426[_0x0128('0x2b')]=qs[_0x0128('0x2c')](_0x1f5477[_0x0128('0x25')][_0x0128('0x2c')]);_0x38b426['where']=qs[_0x0128('0x2d')](_[_0x0128('0x2e')](_0x1f5477['query'],_0x3576dc[_0x0128('0x2d')]));_0x38b426[_0x0128('0x30')][_0x0128('0x50')]=_0x366f20['id'];if(_0x1f5477['query'][_0x0128('0x2f')]){_0x38b426[_0x0128('0x30')]=_[_0x0128('0x31')](_0x38b426['where'],{'$or':_[_0x0128('0x32')](_0x38b426['attributes'],function(_0x5d21ae){var _0x10c3a0={};_0x10c3a0[_0x5d21ae]={'$like':'%'+_0x1f5477[_0x0128('0x25')]['filter']+'%'};return _0x10c3a0;})});}_0x38b426=_[_0x0128('0x31')]({},_0x38b426,_0x1f5477[_0x0128('0x36')]);return db[_0x0128('0x5a')]['count']({'where':_0x38b426[_0x0128('0x30')]})[_0x0128('0x1e')](function(_0x5237a3){_0x3b3979[_0x0128('0x1a')]=_0x5237a3;if(_0x1f5477[_0x0128('0x25')]['includeAll']){_0x38b426[_0x0128('0x37')]=[{'all':!![]}];}return db['CmList'][_0x0128('0x38')](_0x38b426);})['then'](function(_0x514668){_0x3b3979['rows']=_0x514668;return _0x3b3979;});}})[_0x0128('0x1e')](respondWithFilteredResult(_0x32881d,_0x38b426))[_0x0128('0x39')](handleError(_0x32881d,null));};exports[_0x0128('0x7d')]=function(_0x4db8b8,_0x54aef8,_0x5ef087){var _0x2b93cc,_0x24e557;return db[_0x0128('0x22')][_0x0128('0x3e')]({'where':{'id':_0x4db8b8[_0x0128('0x3b')]['id']}})[_0x0128('0x1e')](handleEntityNotFound(_0x54aef8,null))[_0x0128('0x1e')](function(_0x5d02b6){if(_0x5d02b6){_0x24e557=_0x5d02b6;return _0x5d02b6['addBlackLists'](_0x4db8b8[_0x0128('0x40')][_0x0128('0x5c')],_[_0x0128('0x7e')](_0x4db8b8['body'],[_0x0128('0x5c'),'id'])||{});}return null;})[_0x0128('0x5d')](function(_0x2e61d4){var _0x21868f;_0x2b93cc=_0x2e61d4||[];var _0xd6f267=[];if(_0x2e61d4){for(var _0x5f093b=0x0;_0x5f093b<_0x2e61d4[_0x0128('0x29')];_0x5f093b+=0x1){var _0x458dbb=_0x2e61d4[_0x5f093b][_0x0128('0x42')]({'plain':!![]});_0x21868f=squel[_0x0128('0x60')]()['into'](_0x0128('0x7f'))[_0x0128('0x61')](['phone',_0x0128('0x64'),_0x0128('0x65'),_0x0128('0x50'),_0x0128('0x49'),_0x0128('0x66')],squel[_0x0128('0x70')]()[_0x0128('0x35')](_0x0128('0x62'),'phone')['field']('id',_0x0128('0x64'))[_0x0128('0x35')](_0x458dbb['CmListId']['toString'](),_0x0128('0x65'))[_0x0128('0x35')](_0x4db8b8[_0x0128('0x3b')]['id'][_0x0128('0x69')](),_0x0128('0x50'))[_0x0128('0x35')](_0x0128('0x67'),_0x0128('0x49'))[_0x0128('0x35')](_0x0128('0x67'),_0x0128('0x66'))[_0x0128('0x6a')](_0x0128('0x6b'))['where'](_0x0128('0x6c'))[_0x0128('0x30')](_0x0128('0x6d'),_0x458dbb[_0x0128('0x68')][_0x0128('0x69')]())[_0x0128('0x30')](_0x0128('0x6e')))[_0x0128('0x69')]();_0xd6f267['push'](db[_0x0128('0x79')][_0x0128('0x25')](_0x21868f));}return BPromise['all'](_0xd6f267);}})['then'](function(){return _0x2b93cc;})[_0x0128('0x1e')](respondWithResult(_0x54aef8,null))[_0x0128('0x39')](handleError(_0x54aef8,null));};exports[_0x0128('0x80')]=function(_0x3f8d82,_0x44c943,_0x5afd03){return db[_0x0128('0x22')]['find']({'where':{'id':_0x3f8d82['params']['id']}})[_0x0128('0x1e')](handleEntityNotFound(_0x44c943,null))[_0x0128('0x1e')](function(_0x33ffe0){if(_0x33ffe0){return _0x33ffe0[_0x0128('0x80')](_0x3f8d82[_0x0128('0x25')][_0x0128('0x5c')]);}})['then'](function(_0x33bc7c){if(_0x33bc7c){return db['CmHopperBlack'][_0x0128('0x4c')]({'where':{'ListId':_0x3f8d82[_0x0128('0x25')][_0x0128('0x5c')],'CampaignId':_0x3f8d82['params']['id']}})[_0x0128('0x1e')](function(){return _0x33bc7c;});}})[_0x0128('0x1e')](respondWithStatusCode(_0x44c943,null))[_0x0128('0x39')](handleError(_0x44c943,null));};