[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 _0xb71a=['then','end','error','stack','name','send','index','Campaign','rawAttributes','model','keys','query','filters','attributes','intersection','fields','hasOwnProperty','order','where','filter','merge','map','type','VIRTUAL','field','options','includeAll','include','findAll','rows','catch','show','params','length','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','UserProfileSection','UserProfileResource','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','omit','updatedAt','createdAt','autoAssociation','update','findOne','CmHopper','nolimit','sort','pick','CampaignId','CmHopperHistory','CmHopperFinal','getHopperBlacks','CmHopperBlack','CmList','addLists','ids','dialCheckDuplicateType','insert','into','cm_hopper','fromQuery','phone','scheduledAt','ContactId','ListId','select','CmListId','toString','NOW()','from','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','COALESCE(calleridnum,\x27\x27)','cm_hopper_final','CampaignId\x20=\x20?','COALESCE(phone,\x27\x27)','onlyIfOpen','cm_contacts','deletedAt\x20IS\x20NULL','push','sequelize','all','removeLists','getBlackLists','addBlackLists','spread','cm_hopper_black','html-pdf','eml-format','zip-dir','fast-json-patch','request-promise','bluebird','mustache','util','path','ejs','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','../../components/parsers/qs','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','json','count','offset','limit','set','Content-Range','apply','reject','save','destroy','get','IvrCampaigns'];(function(_0x1b6c6d,_0x2983b0){var _0x290d9d=function(_0x5b9779){while(--_0x5b9779){_0x1b6c6d['push'](_0x1b6c6d['shift']());}};_0x290d9d(++_0x2983b0);}(_0xb71a,0x1df));var _0xab71=function(_0x17c483,_0xc69535){_0x17c483=_0x17c483-0x0;var _0x112bdb=_0xb71a[_0x17c483];return _0x112bdb;};'use strict';var pdf=require(_0xab71('0x0'));var emlformat=require(_0xab71('0x1'));var rimraf=require('rimraf');var zipdir=require(_0xab71('0x2'));var jsonpatch=require(_0xab71('0x3'));var rp=require(_0xab71('0x4'));var moment=require('moment');var BPromise=require(_0xab71('0x5'));var Mustache=require(_0xab71('0x6'));var util=require(_0xab71('0x7'));var path=require(_0xab71('0x8'));var sox=require('sox');var csv=require('to-csv');var ejs=require(_0xab71('0x9'));var fs=require('fs');var _=require(_0xab71('0xa'));var squel=require(_0xab71('0xb'));var crypto=require(_0xab71('0xc'));var jsforce=require(_0xab71('0xd'));var deskjs=require(_0xab71('0xe'));var toCsv=require('to-csv');var querystring=require(_0xab71('0xf'));var Papa=require(_0xab71('0x10'));var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require(_0xab71('0x11'));var hardwareService=require(_0xab71('0x12'));var logger=require(_0xab71('0x13'))('api');var utils=require(_0xab71('0x14'));var config=require(_0xab71('0x15'));var db=require(_0xab71('0x16'))['db'];function respondWithStatusCode(_0x40ba27,_0x5234ce){_0x5234ce=_0x5234ce||0xcc;return function(_0x58f202){if(_0x58f202){return _0x40ba27[_0xab71('0x17')](_0x5234ce);}return _0x40ba27[_0xab71('0x18')](_0x5234ce)['end']();};}function respondWithResult(_0x220aa8,_0x587971){_0x587971=_0x587971||0xc8;return function(_0x41ebb0){if(_0x41ebb0){return _0x220aa8[_0xab71('0x18')](_0x587971)[_0xab71('0x19')](_0x41ebb0);}};}function respondWithFilteredResult(_0x3f3eca,_0x3337f1){return function(_0x3ef449){if(_0x3ef449){var _0x2e810c=_0x3ef449[_0xab71('0x1a')],_0x5cf235=_0x3337f1['offset'],_0x2e2574=_0x3337f1[_0xab71('0x1b')]+_0x3337f1[_0xab71('0x1c')],_0x57eba6;if(_0x2e2574>=_0x2e810c){_0x2e2574=_0x2e810c;_0x57eba6=0xc8;}else{_0x57eba6=0xce;}_0x3f3eca['status'](_0x57eba6);return _0x3f3eca[_0xab71('0x1d')](_0xab71('0x1e'),_0x5cf235+'-'+_0x2e2574+'/'+_0x2e810c)[_0xab71('0x19')](_0x3ef449);}return null;};}function patchUpdates(_0x8649ad){return function(_0x499cce){try{jsonpatch[_0xab71('0x1f')](_0x499cce,_0x8649ad,!![]);}catch(_0x52ecda){return BPromise[_0xab71('0x20')](_0x52ecda);}return _0x499cce[_0xab71('0x21')]();};}function saveUpdates(_0x10854a,_0x3a1cfb){return function(_0x3cf397){if(_0x3cf397){return _0x3cf397['update'](_0x10854a)['then'](function(_0x1ed598){return _0x1ed598;});}return null;};}function removeEntity(_0x193397,_0x403c62){return function(_0x3e996a){if(_0x3e996a){return _0x3e996a[_0xab71('0x22')]()['then'](function(){var _0x51e5b=_0x3e996a[_0xab71('0x23')]({'plain':!![]});var _0x187771=_0xab71('0x24');return db['UserProfileResource']['destroy']({'where':{'type':_0x187771,'resourceId':_0x51e5b['id']}})[_0xab71('0x25')](function(){return _0x3e996a;});})[_0xab71('0x25')](function(){_0x193397[_0xab71('0x18')](0xcc)[_0xab71('0x26')]();});}};}function handleEntityNotFound(_0x4d280e,_0x360fd6){return function(_0xb0d260){if(!_0xb0d260){_0x4d280e['sendStatus'](0x194);}return _0xb0d260;};}function handleError(_0xe1799a,_0x5cdd01){_0x5cdd01=_0x5cdd01||0x1f4;return function(_0x3dab6f){logger[_0xab71('0x27')](_0x3dab6f[_0xab71('0x28')]);if(_0x3dab6f[_0xab71('0x29')]){delete _0x3dab6f[_0xab71('0x29')];}_0xe1799a['status'](_0x5cdd01)[_0xab71('0x2a')](_0x3dab6f);};}exports[_0xab71('0x2b')]=function(_0x5209ef,_0x48f3a9){var _0x43d371={},_0x1dfd1e={},_0x3cafbf={'count':0x0,'rows':[]};var _0x545033=db[_0xab71('0x2c')][_0xab71('0x2d')];_0x1dfd1e[_0xab71('0x2e')]=_[_0xab71('0x2f')](_0x545033);_0x1dfd1e['query']=_[_0xab71('0x2f')](_0x5209ef[_0xab71('0x30')]);_0x1dfd1e[_0xab71('0x31')]=_['intersection'](_0x1dfd1e['model'],_0x1dfd1e[_0xab71('0x30')]);_0x43d371[_0xab71('0x32')]=_[_0xab71('0x33')](_0x1dfd1e[_0xab71('0x2e')],qs['fields'](_0x5209ef['query'][_0xab71('0x34')]));_0x43d371[_0xab71('0x32')]=_0x43d371[_0xab71('0x32')]['length']?_0x43d371[_0xab71('0x32')]:_0x1dfd1e[_0xab71('0x2e')];if(!_0x5209ef[_0xab71('0x30')][_0xab71('0x35')]('nolimit')){_0x43d371[_0xab71('0x1c')]=qs[_0xab71('0x1c')](_0x5209ef[_0xab71('0x30')][_0xab71('0x1c')]);_0x43d371[_0xab71('0x1b')]=qs[_0xab71('0x1b')](_0x5209ef[_0xab71('0x30')]['offset']);}_0x43d371[_0xab71('0x36')]=qs['sort'](_0x5209ef['query']['sort']);_0x43d371[_0xab71('0x37')]=qs[_0xab71('0x31')](_['pick'](_0x5209ef[_0xab71('0x30')],_0x1dfd1e[_0xab71('0x31')]));if(_0x5209ef['query'][_0xab71('0x38')]){_0x43d371['where']=_[_0xab71('0x39')](_0x43d371[_0xab71('0x37')],{'$or':_[_0xab71('0x3a')](_0x545033,function(_0xb01591){if(_0xb01591[_0xab71('0x3b')]['key']!==_0xab71('0x3c')){var _0x1965a5={};_0x1965a5[_0xb01591[_0xab71('0x3d')]]={'$like':'%'+_0x5209ef[_0xab71('0x30')][_0xab71('0x38')]+'%'};return _0x1965a5;}})});}_0x43d371=_[_0xab71('0x39')]({},_0x43d371,_0x5209ef[_0xab71('0x3e')]);var _0x5c4eef={'where':_0x43d371[_0xab71('0x37')]};return db[_0xab71('0x2c')][_0xab71('0x1a')](_0x5c4eef)[_0xab71('0x25')](function(_0x2bdfad){_0x3cafbf[_0xab71('0x1a')]=_0x2bdfad;if(_0x5209ef['query'][_0xab71('0x3f')]){_0x43d371[_0xab71('0x40')]=[{'all':!![]}];}return db[_0xab71('0x2c')][_0xab71('0x41')](_0x43d371);})[_0xab71('0x25')](function(_0x83ed4a){_0x3cafbf[_0xab71('0x42')]=_0x83ed4a;return _0x3cafbf;})[_0xab71('0x25')](respondWithFilteredResult(_0x48f3a9,_0x43d371))[_0xab71('0x43')](handleError(_0x48f3a9,null));};exports[_0xab71('0x44')]=function(_0x5b81f5,_0x2d1e8e){var _0x4c81c8={'raw':![],'where':{'id':_0x5b81f5[_0xab71('0x45')]['id']}},_0x40d4ac={};_0x40d4ac[_0xab71('0x2e')]=_[_0xab71('0x2f')](db[_0xab71('0x2c')]['rawAttributes']);_0x40d4ac['query']=_[_0xab71('0x2f')](_0x5b81f5[_0xab71('0x30')]);_0x40d4ac['filters']=_[_0xab71('0x33')](_0x40d4ac[_0xab71('0x2e')],_0x40d4ac[_0xab71('0x30')]);_0x4c81c8[_0xab71('0x32')]=_['intersection'](_0x40d4ac[_0xab71('0x2e')],qs['fields'](_0x5b81f5['query'][_0xab71('0x34')]));_0x4c81c8[_0xab71('0x32')]=_0x4c81c8[_0xab71('0x32')][_0xab71('0x46')]?_0x4c81c8[_0xab71('0x32')]:_0x40d4ac[_0xab71('0x2e')];if(_0x5b81f5[_0xab71('0x30')][_0xab71('0x3f')]){_0x4c81c8[_0xab71('0x40')]=[{'all':!![]}];}_0x4c81c8=_[_0xab71('0x39')]({},_0x4c81c8,_0x5b81f5['options']);return db[_0xab71('0x2c')][_0xab71('0x47')](_0x4c81c8)[_0xab71('0x25')](handleEntityNotFound(_0x2d1e8e,null))[_0xab71('0x25')](respondWithResult(_0x2d1e8e,null))['catch'](handleError(_0x2d1e8e,null));};exports[_0xab71('0x48')]=function(_0x193c5b,_0x11bdeb){return db[_0xab71('0x2c')]['create'](_0x193c5b[_0xab71('0x49')],{})['then'](function(_0x2dd101){var _0x1fd9a7=_0x193c5b[_0xab71('0x4a')][_0xab71('0x23')]({'plain':!![]});if(!_0x1fd9a7)throw new Error(_0xab71('0x4b'));if(_0x1fd9a7['role']===_0xab71('0x4a')){var _0x3836eb=_0x2dd101[_0xab71('0x23')]({'plain':!![]});var _0x5c01b6=_0xab71('0x24');return db[_0xab71('0x4c')][_0xab71('0x47')]({'where':{'name':_0x5c01b6,'userProfileId':_0x1fd9a7['userProfileId']},'raw':!![]})[_0xab71('0x25')](function(_0x4516c9){if(_0x4516c9&&_0x4516c9['autoAssociation']===0x0){return db[_0xab71('0x4d')][_0xab71('0x48')]({'name':_0x3836eb['name'],'resourceId':_0x3836eb['id'],'type':_0x4516c9[_0xab71('0x29')],'sectionId':_0x4516c9['id']},{})[_0xab71('0x25')](function(){return _0x2dd101;});}else{return _0x2dd101;}})[_0xab71('0x43')](function(_0x1465bc){logger[_0xab71('0x27')](_0xab71('0x4e'),_0x1465bc);throw _0x1465bc;});}return _0x2dd101;})['then'](respondWithResult(_0x11bdeb,0xc9))[_0xab71('0x43')](handleError(_0x11bdeb,null));};exports['clone']=function(_0x460296,_0x5079df){var _0x19fa87={'raw':![],'where':{'id':_0x460296['params']['id']}},_0x232261={};_0x232261['model']=_[_0xab71('0x2f')](db[_0xab71('0x2c')][_0xab71('0x2d')]);_0x19fa87[_0xab71('0x32')]=_[_0xab71('0x33')](_0x232261['model'],qs[_0xab71('0x34')](_0x460296['query'][_0xab71('0x34')]));_0x19fa87[_0xab71('0x32')]=_0x19fa87[_0xab71('0x32')][_0xab71('0x46')]?_0x19fa87[_0xab71('0x32')]:_0x232261[_0xab71('0x2e')];if(_0x460296[_0xab71('0x30')][_0xab71('0x3f')]){_0x19fa87['include']=[{'all':!![]}];}_0x19fa87=_['merge']({},_0x19fa87,_0x460296[_0xab71('0x3e')]);return db[_0xab71('0x2c')][_0xab71('0x47')](_0x19fa87)[_0xab71('0x25')](handleEntityNotFound(_0x5079df,null))['then'](function(_0x2fbbec){if(_0x2fbbec){var _0x13bf55=_0x2fbbec[_0xab71('0x23')]({'plain':!![]});_0x13bf55=qs[_0xab71('0x4f')](_0x13bf55,['id','createdAt',_0xab71('0x50')]);_0x460296[_0xab71('0x49')]=_[_0xab71('0x4f')](_0x460296[_0xab71('0x49')],['id',_0xab71('0x51'),_0xab71('0x50')]);return db[_0xab71('0x2c')]['create'](_[_0xab71('0x39')](_0x13bf55,_0x460296[_0xab71('0x49')]),{'include':_0x460296[_0xab71('0x30')]['includeAll']?[{'all':!![]}]:undefined})['then'](function(_0x2ea846){var _0x203606=_0x460296[_0xab71('0x4a')][_0xab71('0x23')]({'plain':!![]});if(!_0x203606)throw new Error(_0xab71('0x4b'));if(_0x203606['role']==='user'){var _0xb5e2ba=_0x2ea846[_0xab71('0x23')]({'plain':!![]});var _0x4923bb=_0xab71('0x24');return db[_0xab71('0x4c')]['find']({'where':{'name':_0x4923bb,'userProfileId':_0x203606['userProfileId']},'raw':!![]})[_0xab71('0x25')](function(_0x608a2f){if(_0x608a2f&&_0x608a2f[_0xab71('0x52')]===0x0){return db['UserProfileResource'][_0xab71('0x48')]({'name':_0xb5e2ba[_0xab71('0x29')],'resourceId':_0xb5e2ba['id'],'type':_0x608a2f['name'],'sectionId':_0x608a2f['id']},{})[_0xab71('0x25')](function(){return _0x2ea846;});}else{return _0x2ea846;}})['catch'](function(_0x26307d){logger[_0xab71('0x27')](_0xab71('0x4e'),_0x26307d);throw _0x26307d;});}return _0x2ea846;});}})[_0xab71('0x25')](respondWithResult(_0x5079df,0xc9))[_0xab71('0x43')](handleError(_0x5079df,null));};exports[_0xab71('0x53')]=function(_0x318e39,_0x3ba6ee){if(_0x318e39['body']['id']){delete _0x318e39['body']['id'];}return db[_0xab71('0x2c')][_0xab71('0x47')]({'where':{'id':_0x318e39[_0xab71('0x45')]['id']}})[_0xab71('0x25')](handleEntityNotFound(_0x3ba6ee,null))['then'](saveUpdates(_0x318e39[_0xab71('0x49')],null))[_0xab71('0x25')](respondWithResult(_0x3ba6ee,null))[_0xab71('0x43')](handleError(_0x3ba6ee,null));};exports[_0xab71('0x22')]=function(_0x514046,_0x503e67){return db[_0xab71('0x2c')][_0xab71('0x47')]({'where':{'id':_0x514046['params']['id']}})[_0xab71('0x25')](handleEntityNotFound(_0x503e67,null))[_0xab71('0x25')](removeEntity(_0x503e67,null))[_0xab71('0x43')](handleError(_0x503e67,null));};exports['getHoppers']=function(_0x2a0c2f,_0x361e6b,_0x28b643){var _0x125ae3={'raw':!![],'where':{}};var _0x4a5c0b={};var _0x2053c5={'count':0x0,'rows':[]};return db[_0xab71('0x2c')][_0xab71('0x54')]({'where':{'id':_0x2a0c2f['params']['id']}})[_0xab71('0x25')](handleEntityNotFound(_0x361e6b,null))['then'](function(_0x22c203){if(_0x22c203){_0x4a5c0b[_0xab71('0x2e')]=_[_0xab71('0x2f')](db[_0xab71('0x55')][_0xab71('0x2d')]);_0x4a5c0b[_0xab71('0x30')]=_['keys'](_0x2a0c2f[_0xab71('0x30')]);_0x4a5c0b[_0xab71('0x31')]=_[_0xab71('0x33')](_0x4a5c0b['model'],_0x4a5c0b[_0xab71('0x30')]);_0x125ae3[_0xab71('0x32')]=_[_0xab71('0x33')](_0x4a5c0b[_0xab71('0x2e')],qs[_0xab71('0x34')](_0x2a0c2f[_0xab71('0x30')]['fields']));_0x125ae3[_0xab71('0x32')]=_0x125ae3[_0xab71('0x32')][_0xab71('0x46')]?_0x125ae3[_0xab71('0x32')]:_0x4a5c0b['model'];if(!_0x2a0c2f[_0xab71('0x30')][_0xab71('0x35')](_0xab71('0x56'))){_0x125ae3[_0xab71('0x1c')]=qs['limit'](_0x2a0c2f[_0xab71('0x30')][_0xab71('0x1c')]);_0x125ae3[_0xab71('0x1b')]=qs[_0xab71('0x1b')](_0x2a0c2f[_0xab71('0x30')][_0xab71('0x1b')]);}_0x125ae3['order']=qs[_0xab71('0x57')](_0x2a0c2f[_0xab71('0x30')]['sort']);_0x125ae3[_0xab71('0x37')]=qs[_0xab71('0x31')](_[_0xab71('0x58')](_0x2a0c2f[_0xab71('0x30')],_0x4a5c0b[_0xab71('0x31')]));_0x125ae3[_0xab71('0x37')][_0xab71('0x59')]=_0x22c203['id'];if(_0x2a0c2f[_0xab71('0x30')]['filter']){_0x125ae3[_0xab71('0x37')]=_['merge'](_0x125ae3[_0xab71('0x37')],{'$or':_[_0xab71('0x3a')](_0x125ae3[_0xab71('0x32')],function(_0x4f47b9){var _0x2d7396={};_0x2d7396[_0x4f47b9]={'$like':'%'+_0x2a0c2f[_0xab71('0x30')][_0xab71('0x38')]+'%'};return _0x2d7396;})});}_0x125ae3=_['merge']({},_0x125ae3,_0x2a0c2f[_0xab71('0x3e')]);return db['CmHopper'][_0xab71('0x1a')]({'where':_0x125ae3[_0xab71('0x37')]})['then'](function(_0x4cd121){_0x2053c5[_0xab71('0x1a')]=_0x4cd121;if(_0x2a0c2f[_0xab71('0x30')][_0xab71('0x3f')]){_0x125ae3['include']=[{'all':!![]}];}return db['CmHopper'][_0xab71('0x41')](_0x125ae3);})['then'](function(_0x220337){_0x2053c5[_0xab71('0x42')]=_0x220337;return _0x2053c5;});}})[_0xab71('0x25')](respondWithFilteredResult(_0x361e6b,_0x125ae3))['catch'](handleError(_0x361e6b,null));};exports['getHopperHistories']=function(_0x4e260c,_0x19977a,_0x3c8809){var _0x4ebb0e={'raw':!![],'where':{}};var _0x557333={};var _0x22f800={'count':0x0,'rows':[]};return db[_0xab71('0x2c')][_0xab71('0x54')]({'where':{'id':_0x4e260c['params']['id']}})[_0xab71('0x25')](handleEntityNotFound(_0x19977a,null))['then'](function(_0x4b2867){if(_0x4b2867){_0x557333[_0xab71('0x2e')]=_[_0xab71('0x2f')](db['CmHopperHistory'][_0xab71('0x2d')]);_0x557333[_0xab71('0x30')]=_[_0xab71('0x2f')](_0x4e260c[_0xab71('0x30')]);_0x557333[_0xab71('0x31')]=_[_0xab71('0x33')](_0x557333[_0xab71('0x2e')],_0x557333[_0xab71('0x30')]);_0x4ebb0e[_0xab71('0x32')]=_[_0xab71('0x33')](_0x557333['model'],qs[_0xab71('0x34')](_0x4e260c['query'][_0xab71('0x34')]));_0x4ebb0e[_0xab71('0x32')]=_0x4ebb0e['attributes'][_0xab71('0x46')]?_0x4ebb0e['attributes']:_0x557333[_0xab71('0x2e')];if(!_0x4e260c[_0xab71('0x30')][_0xab71('0x35')](_0xab71('0x56'))){_0x4ebb0e['limit']=qs['limit'](_0x4e260c[_0xab71('0x30')][_0xab71('0x1c')]);_0x4ebb0e[_0xab71('0x1b')]=qs[_0xab71('0x1b')](_0x4e260c[_0xab71('0x30')]['offset']);}_0x4ebb0e['order']=qs[_0xab71('0x57')](_0x4e260c[_0xab71('0x30')][_0xab71('0x57')]);_0x4ebb0e[_0xab71('0x37')]=qs[_0xab71('0x31')](_[_0xab71('0x58')](_0x4e260c[_0xab71('0x30')],_0x557333[_0xab71('0x31')]));_0x4ebb0e['where'][_0xab71('0x59')]=_0x4b2867['id'];if(_0x4e260c[_0xab71('0x30')]['filter']){_0x4ebb0e[_0xab71('0x37')]=_[_0xab71('0x39')](_0x4ebb0e[_0xab71('0x37')],{'$or':_[_0xab71('0x3a')](_0x4ebb0e[_0xab71('0x32')],function(_0x5edb97){var _0x2b8879={};_0x2b8879[_0x5edb97]={'$like':'%'+_0x4e260c['query'][_0xab71('0x38')]+'%'};return _0x2b8879;})});}_0x4ebb0e=_[_0xab71('0x39')]({},_0x4ebb0e,_0x4e260c['options']);return db[_0xab71('0x5a')][_0xab71('0x1a')]({'where':_0x4ebb0e[_0xab71('0x37')]})[_0xab71('0x25')](function(_0x2ba36e){_0x22f800[_0xab71('0x1a')]=_0x2ba36e;if(_0x4e260c[_0xab71('0x30')][_0xab71('0x3f')]){_0x4ebb0e[_0xab71('0x40')]=[{'all':!![]}];}return db['CmHopperHistory']['findAll'](_0x4ebb0e);})[_0xab71('0x25')](function(_0x3bd5a4){_0x22f800[_0xab71('0x42')]=_0x3bd5a4;return _0x22f800;});}})[_0xab71('0x25')](respondWithFilteredResult(_0x19977a,_0x4ebb0e))[_0xab71('0x43')](handleError(_0x19977a,null));};exports['getHopperFinals']=function(_0x5b4f71,_0x212243,_0x2ea4ec){var _0x5379ed={'raw':!![],'where':{}};var _0x182c83={};var _0x4f618b={'count':0x0,'rows':[]};return db[_0xab71('0x2c')][_0xab71('0x54')]({'where':{'id':_0x5b4f71[_0xab71('0x45')]['id']}})['then'](handleEntityNotFound(_0x212243,null))[_0xab71('0x25')](function(_0x13b32b){if(_0x13b32b){_0x182c83[_0xab71('0x2e')]=_['keys'](db[_0xab71('0x5b')][_0xab71('0x2d')]);_0x182c83[_0xab71('0x30')]=_[_0xab71('0x2f')](_0x5b4f71['query']);_0x182c83[_0xab71('0x31')]=_['intersection'](_0x182c83[_0xab71('0x2e')],_0x182c83[_0xab71('0x30')]);_0x5379ed[_0xab71('0x32')]=_[_0xab71('0x33')](_0x182c83[_0xab71('0x2e')],qs['fields'](_0x5b4f71[_0xab71('0x30')]['fields']));_0x5379ed[_0xab71('0x32')]=_0x5379ed[_0xab71('0x32')][_0xab71('0x46')]?_0x5379ed[_0xab71('0x32')]:_0x182c83[_0xab71('0x2e')];if(!_0x5b4f71[_0xab71('0x30')][_0xab71('0x35')](_0xab71('0x56'))){_0x5379ed['limit']=qs['limit'](_0x5b4f71[_0xab71('0x30')][_0xab71('0x1c')]);_0x5379ed['offset']=qs[_0xab71('0x1b')](_0x5b4f71[_0xab71('0x30')]['offset']);}_0x5379ed[_0xab71('0x36')]=qs[_0xab71('0x57')](_0x5b4f71[_0xab71('0x30')][_0xab71('0x57')]);_0x5379ed[_0xab71('0x37')]=qs[_0xab71('0x31')](_[_0xab71('0x58')](_0x5b4f71[_0xab71('0x30')],_0x182c83[_0xab71('0x31')]));_0x5379ed[_0xab71('0x37')][_0xab71('0x59')]=_0x13b32b['id'];if(_0x5b4f71[_0xab71('0x30')][_0xab71('0x38')]){_0x5379ed[_0xab71('0x37')]=_[_0xab71('0x39')](_0x5379ed[_0xab71('0x37')],{'$or':_[_0xab71('0x3a')](_0x5379ed[_0xab71('0x32')],function(_0x3520b1){var _0x3cd115={};_0x3cd115[_0x3520b1]={'$like':'%'+_0x5b4f71['query'][_0xab71('0x38')]+'%'};return _0x3cd115;})});}_0x5379ed=_['merge']({},_0x5379ed,_0x5b4f71[_0xab71('0x3e')]);return db[_0xab71('0x5b')][_0xab71('0x1a')]({'where':_0x5379ed[_0xab71('0x37')]})[_0xab71('0x25')](function(_0x44f11d){_0x4f618b['count']=_0x44f11d;if(_0x5b4f71[_0xab71('0x30')]['includeAll']){_0x5379ed[_0xab71('0x40')]=[{'all':!![]}];}return db[_0xab71('0x5b')]['findAll'](_0x5379ed);})['then'](function(_0x3b03f0){_0x4f618b[_0xab71('0x42')]=_0x3b03f0;return _0x4f618b;});}})[_0xab71('0x25')](respondWithFilteredResult(_0x212243,_0x5379ed))[_0xab71('0x43')](handleError(_0x212243,null));};exports[_0xab71('0x5c')]=function(_0x32780f,_0x166895,_0x3476d4){var _0x557027={'raw':!![],'where':{}};var _0xf2809a={};var _0x5bbcfd={'count':0x0,'rows':[]};return db[_0xab71('0x2c')][_0xab71('0x54')]({'where':{'id':_0x32780f['params']['id']}})[_0xab71('0x25')](handleEntityNotFound(_0x166895,null))[_0xab71('0x25')](function(_0x87f84a){if(_0x87f84a){_0xf2809a[_0xab71('0x2e')]=_[_0xab71('0x2f')](db[_0xab71('0x5d')][_0xab71('0x2d')]);_0xf2809a[_0xab71('0x30')]=_[_0xab71('0x2f')](_0x32780f[_0xab71('0x30')]);_0xf2809a[_0xab71('0x31')]=_[_0xab71('0x33')](_0xf2809a[_0xab71('0x2e')],_0xf2809a['query']);_0x557027[_0xab71('0x32')]=_[_0xab71('0x33')](_0xf2809a['model'],qs[_0xab71('0x34')](_0x32780f[_0xab71('0x30')][_0xab71('0x34')]));_0x557027[_0xab71('0x32')]=_0x557027[_0xab71('0x32')][_0xab71('0x46')]?_0x557027[_0xab71('0x32')]:_0xf2809a[_0xab71('0x2e')];if(!_0x32780f[_0xab71('0x30')][_0xab71('0x35')](_0xab71('0x56'))){_0x557027[_0xab71('0x1c')]=qs[_0xab71('0x1c')](_0x32780f[_0xab71('0x30')][_0xab71('0x1c')]);_0x557027[_0xab71('0x1b')]=qs['offset'](_0x32780f[_0xab71('0x30')][_0xab71('0x1b')]);}_0x557027[_0xab71('0x36')]=qs[_0xab71('0x57')](_0x32780f[_0xab71('0x30')][_0xab71('0x57')]);_0x557027[_0xab71('0x37')]=qs[_0xab71('0x31')](_[_0xab71('0x58')](_0x32780f[_0xab71('0x30')],_0xf2809a[_0xab71('0x31')]));_0x557027[_0xab71('0x37')][_0xab71('0x59')]=_0x87f84a['id'];if(_0x32780f[_0xab71('0x30')]['filter']){_0x557027[_0xab71('0x37')]=_[_0xab71('0x39')](_0x557027[_0xab71('0x37')],{'$or':_['map'](_0x557027[_0xab71('0x32')],function(_0x3a6a2e){var _0x589002={};_0x589002[_0x3a6a2e]={'$like':'%'+_0x32780f[_0xab71('0x30')][_0xab71('0x38')]+'%'};return _0x589002;})});}_0x557027=_['merge']({},_0x557027,_0x32780f[_0xab71('0x3e')]);return db[_0xab71('0x5d')][_0xab71('0x1a')]({'where':_0x557027[_0xab71('0x37')]})[_0xab71('0x25')](function(_0x554d69){_0x5bbcfd[_0xab71('0x1a')]=_0x554d69;if(_0x32780f[_0xab71('0x30')]['includeAll']){_0x557027[_0xab71('0x40')]=[{'all':!![]}];}return db[_0xab71('0x5d')][_0xab71('0x41')](_0x557027);})[_0xab71('0x25')](function(_0x40b68c){_0x5bbcfd[_0xab71('0x42')]=_0x40b68c;return _0x5bbcfd;});}})[_0xab71('0x25')](respondWithFilteredResult(_0x166895,_0x557027))['catch'](handleError(_0x166895,null));};exports['getLists']=function(_0x2410cf,_0x3cbd1f,_0x38848e){var _0x42eb21={};var _0x25b1b4={};var _0x13524d;var _0x4076a2;return db[_0xab71('0x2c')][_0xab71('0x54')]({'where':{'id':_0x2410cf[_0xab71('0x45')]['id']}})[_0xab71('0x25')](handleEntityNotFound(_0x3cbd1f,null))[_0xab71('0x25')](function(_0x3ee9f9){if(_0x3ee9f9){_0x13524d=_0x3ee9f9;_0x25b1b4[_0xab71('0x2e')]=_[_0xab71('0x2f')](db[_0xab71('0x5e')]['rawAttributes']);_0x25b1b4['query']=_['keys'](_0x2410cf['query']);_0x25b1b4[_0xab71('0x31')]=_['intersection'](_0x25b1b4[_0xab71('0x2e')],_0x25b1b4[_0xab71('0x30')]);_0x42eb21[_0xab71('0x32')]=_[_0xab71('0x33')](_0x25b1b4[_0xab71('0x2e')],qs[_0xab71('0x34')](_0x2410cf[_0xab71('0x30')]['fields']));_0x42eb21[_0xab71('0x32')]=_0x42eb21[_0xab71('0x32')][_0xab71('0x46')]?_0x42eb21[_0xab71('0x32')]:_0x25b1b4[_0xab71('0x2e')];_0x42eb21[_0xab71('0x36')]=qs[_0xab71('0x57')](_0x2410cf['query']['sort']);_0x42eb21[_0xab71('0x37')]=qs[_0xab71('0x31')](_[_0xab71('0x58')](_0x2410cf[_0xab71('0x30')],_0x25b1b4[_0xab71('0x31')]));if(_0x2410cf['query'][_0xab71('0x38')]){_0x42eb21[_0xab71('0x37')]=_[_0xab71('0x39')](_0x42eb21['where'],{'$or':_[_0xab71('0x3a')](_0x42eb21['attributes'],function(_0x2ebd4d){var _0xf39980={};_0xf39980[_0x2ebd4d]={'$like':'%'+_0x2410cf[_0xab71('0x30')][_0xab71('0x38')]+'%'};return _0xf39980;})});}_0x42eb21=_[_0xab71('0x39')]({},_0x42eb21,_0x2410cf['options']);return _0x13524d['getLists'](_0x42eb21);}})['then'](function(_0x367f19){if(_0x367f19){_0x4076a2=_0x367f19[_0xab71('0x46')];if(!_0x2410cf[_0xab71('0x30')]['hasOwnProperty']('nolimit')){_0x42eb21[_0xab71('0x1c')]=qs[_0xab71('0x1c')](_0x2410cf[_0xab71('0x30')][_0xab71('0x1c')]);_0x42eb21[_0xab71('0x1b')]=qs[_0xab71('0x1b')](_0x2410cf['query']['offset']);}return _0x13524d['getLists'](_0x42eb21);}})['then'](function(_0x4ea7c8){if(_0x4ea7c8){return _0x4ea7c8?{'count':_0x4076a2,'rows':_0x4ea7c8}:null;}})[_0xab71('0x25')](respondWithResult(_0x3cbd1f,null))[_0xab71('0x43')](handleError(_0x3cbd1f,null));};exports[_0xab71('0x5f')]=function(_0x5eb357,_0x59e342,_0x446496){var _0xe09018,_0x21e0b1;return db[_0xab71('0x2c')]['find']({'where':{'id':_0x5eb357[_0xab71('0x45')]['id']}})[_0xab71('0x25')](handleEntityNotFound(_0x59e342,null))['then'](function(_0x523300){if(_0x523300){_0x21e0b1=_0x523300;return _0x523300[_0xab71('0x5f')](_0x5eb357[_0xab71('0x49')][_0xab71('0x60')],_[_0xab71('0x4f')](_0x5eb357[_0xab71('0x49')],['ids','id'])||{});}return null;})['spread'](function(_0xbf15b5){var _0x4acf3d;_0xe09018=_0xbf15b5||[];var _0x27d39a=[];if(_0xbf15b5){for(var _0x555355=0x0;_0x555355<_0xbf15b5[_0xab71('0x46')];_0x555355+=0x1){var _0x55a576=_0xbf15b5[_0x555355]['get']({'plain':!![]});_0x21e0b1['dialCheckDuplicateType']=_0x5eb357[_0xab71('0x49')][_0xab71('0x61')]?_0x5eb357[_0xab71('0x49')][_0xab71('0x61')]:_0x21e0b1[_0xab71('0x61')];switch(_0x21e0b1['dialCheckDuplicateType']){case'always':_0x4acf3d=squel[_0xab71('0x62')]()[_0xab71('0x63')](_0xab71('0x64'))[_0xab71('0x65')]([_0xab71('0x66'),_0xab71('0x67'),_0xab71('0x68'),_0xab71('0x69'),'CampaignId',_0xab71('0x51'),_0xab71('0x50')],squel[_0xab71('0x6a')]()[_0xab71('0x3d')]('phone',_0xab71('0x66'))[_0xab71('0x3d')]('NOW()',_0xab71('0x67'))[_0xab71('0x3d')]('id','ContactId')['field'](_0x55a576[_0xab71('0x6b')][_0xab71('0x6c')](),_0xab71('0x69'))[_0xab71('0x3d')](_0x5eb357['params']['id'][_0xab71('0x6c')](),'CampaignId')['field'](_0xab71('0x6d'),_0xab71('0x51'))[_0xab71('0x3d')](_0xab71('0x6d'),_0xab71('0x50'))[_0xab71('0x6e')]('cm_contacts')[_0xab71('0x37')]('deletedAt\x20IS\x20NULL')[_0xab71('0x37')](_0xab71('0x6f'),_0x55a576[_0xab71('0x6b')][_0xab71('0x6c')]())['where'](_0xab71('0x70'))[_0xab71('0x37')](_0xab71('0x71'),squel['select']()[_0xab71('0x3d')](_0xab71('0x72'))['from'](_0xab71('0x73'))[_0xab71('0x37')](_0xab71('0x74'),_0x5eb357['params']['id']['toString']()))[_0xab71('0x37')](_0xab71('0x71'),squel[_0xab71('0x6a')]()['field'](_0xab71('0x75'))[_0xab71('0x6e')](_0xab71('0x64'))[_0xab71('0x37')]('CampaignId\x20=\x20?',_0x5eb357[_0xab71('0x45')]['id'][_0xab71('0x6c')]())))['toString']();break;case _0xab71('0x76'):_0x4acf3d=squel[_0xab71('0x62')]()['into'](_0xab71('0x64'))['fromQuery'](['phone','scheduledAt',_0xab71('0x68'),_0xab71('0x69'),_0xab71('0x59'),_0xab71('0x51'),'updatedAt'],squel['select']()[_0xab71('0x3d')](_0xab71('0x66'),_0xab71('0x66'))[_0xab71('0x3d')](_0xab71('0x6d'),'scheduledAt')[_0xab71('0x3d')]('id',_0xab71('0x68'))[_0xab71('0x3d')](_0x55a576[_0xab71('0x6b')][_0xab71('0x6c')](),'ListId')['field'](_0x5eb357['params']['id'][_0xab71('0x6c')](),_0xab71('0x59'))[_0xab71('0x3d')](_0xab71('0x6d'),_0xab71('0x51'))[_0xab71('0x3d')](_0xab71('0x6d'),_0xab71('0x50'))[_0xab71('0x6e')](_0xab71('0x77'))['where']('deletedAt\x20IS\x20NULL')[_0xab71('0x37')](_0xab71('0x6f'),_0x55a576[_0xab71('0x6b')][_0xab71('0x6c')]())[_0xab71('0x37')]('phone\x20IS\x20NOT\x20NULL')[_0xab71('0x37')]('phone\x20NOT\x20IN\x20(?)',squel[_0xab71('0x6a')]()[_0xab71('0x3d')]('COALESCE(phone,\x27\x27)')[_0xab71('0x6e')]('cm_hopper')[_0xab71('0x37')](_0xab71('0x74'),_0x5eb357[_0xab71('0x45')]['id']['toString']())))[_0xab71('0x6c')]();break;default:_0x4acf3d=squel[_0xab71('0x62')]()[_0xab71('0x63')](_0xab71('0x64'))[_0xab71('0x65')]([_0xab71('0x66'),_0xab71('0x67'),'ContactId',_0xab71('0x69'),_0xab71('0x59'),_0xab71('0x51'),_0xab71('0x50')],squel[_0xab71('0x6a')]()[_0xab71('0x3d')](_0xab71('0x66'),_0xab71('0x66'))[_0xab71('0x3d')](_0xab71('0x6d'),'scheduledAt')[_0xab71('0x3d')]('id',_0xab71('0x68'))['field'](_0x55a576['CmListId']['toString'](),'ListId')[_0xab71('0x3d')](_0x5eb357[_0xab71('0x45')]['id']['toString'](),_0xab71('0x59'))[_0xab71('0x3d')](_0xab71('0x6d'),_0xab71('0x51'))[_0xab71('0x3d')]('NOW()',_0xab71('0x50'))[_0xab71('0x6e')](_0xab71('0x77'))[_0xab71('0x37')](_0xab71('0x78'))[_0xab71('0x37')](_0xab71('0x6f'),_0x55a576[_0xab71('0x6b')][_0xab71('0x6c')]())['where'](_0xab71('0x70')))[_0xab71('0x6c')]();}_0x27d39a[_0xab71('0x79')](db[_0xab71('0x7a')][_0xab71('0x30')](_0x4acf3d));}return BPromise[_0xab71('0x7b')](_0x27d39a);}})[_0xab71('0x25')](function(){return _0xe09018;})['then'](respondWithResult(_0x59e342,null))[_0xab71('0x43')](handleError(_0x59e342,null));};exports[_0xab71('0x7c')]=function(_0x236f71,_0x2edaf0,_0x591407){return db[_0xab71('0x2c')]['find']({'where':{'id':_0x236f71['params']['id']}})[_0xab71('0x25')](handleEntityNotFound(_0x2edaf0,null))[_0xab71('0x25')](function(_0x157289){if(_0x157289){return _0x157289[_0xab71('0x7c')](_0x236f71[_0xab71('0x30')]['ids']);}})[_0xab71('0x25')](function(_0x257aff){if(_0x257aff){return db[_0xab71('0x55')][_0xab71('0x22')]({'where':{'ListId':_0x236f71['query'][_0xab71('0x60')],'CampaignId':_0x236f71[_0xab71('0x45')]['id']}})[_0xab71('0x25')](function(){return _0x257aff;});}})[_0xab71('0x25')](respondWithStatusCode(_0x2edaf0,null))[_0xab71('0x43')](handleError(_0x2edaf0,null));};exports[_0xab71('0x7d')]=function(_0xb248cc,_0x359dda,_0x11bc77){var _0x5b2a38={'raw':!![],'where':{}};var _0x18a757={};var _0xcccf39={'count':0x0,'rows':[]};return db[_0xab71('0x2c')][_0xab71('0x54')]({'where':{'id':_0xb248cc[_0xab71('0x45')]['id']}})['then'](handleEntityNotFound(_0x359dda,null))['then'](function(_0x331a84){if(_0x331a84){_0x18a757[_0xab71('0x2e')]=_['keys'](db[_0xab71('0x5e')]['rawAttributes']);_0x18a757[_0xab71('0x30')]=_[_0xab71('0x2f')](_0xb248cc[_0xab71('0x30')]);_0x18a757[_0xab71('0x31')]=_['intersection'](_0x18a757[_0xab71('0x2e')],_0x18a757['query']);_0x5b2a38['attributes']=_['intersection'](_0x18a757[_0xab71('0x2e')],qs[_0xab71('0x34')](_0xb248cc[_0xab71('0x30')][_0xab71('0x34')]));_0x5b2a38[_0xab71('0x32')]=_0x5b2a38[_0xab71('0x32')]['length']?_0x5b2a38['attributes']:_0x18a757[_0xab71('0x2e')];if(!_0xb248cc[_0xab71('0x30')][_0xab71('0x35')](_0xab71('0x56'))){_0x5b2a38[_0xab71('0x1c')]=qs['limit'](_0xb248cc[_0xab71('0x30')][_0xab71('0x1c')]);_0x5b2a38[_0xab71('0x1b')]=qs[_0xab71('0x1b')](_0xb248cc[_0xab71('0x30')]['offset']);}_0x5b2a38[_0xab71('0x36')]=qs[_0xab71('0x57')](_0xb248cc['query'][_0xab71('0x57')]);_0x5b2a38[_0xab71('0x37')]=qs[_0xab71('0x31')](_[_0xab71('0x58')](_0xb248cc[_0xab71('0x30')],_0x18a757['filters']));_0x5b2a38[_0xab71('0x37')][_0xab71('0x59')]=_0x331a84['id'];if(_0xb248cc[_0xab71('0x30')][_0xab71('0x38')]){_0x5b2a38[_0xab71('0x37')]=_[_0xab71('0x39')](_0x5b2a38['where'],{'$or':_['map'](_0x5b2a38[_0xab71('0x32')],function(_0x5c9be3){var _0xde06b1={};_0xde06b1[_0x5c9be3]={'$like':'%'+_0xb248cc[_0xab71('0x30')][_0xab71('0x38')]+'%'};return _0xde06b1;})});}_0x5b2a38=_['merge']({},_0x5b2a38,_0xb248cc[_0xab71('0x3e')]);return db[_0xab71('0x5e')][_0xab71('0x1a')]({'where':_0x5b2a38['where']})[_0xab71('0x25')](function(_0x1d8472){_0xcccf39[_0xab71('0x1a')]=_0x1d8472;if(_0xb248cc['query'][_0xab71('0x3f')]){_0x5b2a38['include']=[{'all':!![]}];}return db[_0xab71('0x5e')][_0xab71('0x41')](_0x5b2a38);})[_0xab71('0x25')](function(_0x49fd2b){_0xcccf39[_0xab71('0x42')]=_0x49fd2b;return _0xcccf39;});}})[_0xab71('0x25')](respondWithFilteredResult(_0x359dda,_0x5b2a38))['catch'](handleError(_0x359dda,null));};exports[_0xab71('0x7e')]=function(_0x280fd6,_0x5b05e9,_0x5524af){var _0x43a1c7,_0x25a867;return db['Campaign']['find']({'where':{'id':_0x280fd6[_0xab71('0x45')]['id']}})[_0xab71('0x25')](handleEntityNotFound(_0x5b05e9,null))[_0xab71('0x25')](function(_0x2158f0){if(_0x2158f0){_0x25a867=_0x2158f0;return _0x2158f0['addBlackLists'](_0x280fd6[_0xab71('0x49')][_0xab71('0x60')],_[_0xab71('0x4f')](_0x280fd6['body'],[_0xab71('0x60'),'id'])||{});}return null;})[_0xab71('0x7f')](function(_0x5ebd75){var _0x10cf4b;_0x43a1c7=_0x5ebd75||[];var _0x4f63bd=[];if(_0x5ebd75){for(var _0x3108cc=0x0;_0x3108cc<_0x5ebd75['length'];_0x3108cc+=0x1){var _0x7466ba=_0x5ebd75[_0x3108cc]['get']({'plain':!![]});_0x10cf4b=squel['insert']()[_0xab71('0x63')](_0xab71('0x80'))[_0xab71('0x65')]([_0xab71('0x66'),_0xab71('0x68'),_0xab71('0x69'),_0xab71('0x59'),_0xab71('0x51'),_0xab71('0x50')],squel[_0xab71('0x6a')]()[_0xab71('0x3d')](_0xab71('0x66'),_0xab71('0x66'))[_0xab71('0x3d')]('id','ContactId')[_0xab71('0x3d')](_0x7466ba[_0xab71('0x6b')][_0xab71('0x6c')](),'ListId')[_0xab71('0x3d')](_0x280fd6['params']['id']['toString'](),'CampaignId')['field'](_0xab71('0x6d'),'createdAt')['field']('NOW()',_0xab71('0x50'))[_0xab71('0x6e')]('cm_contacts')['where'](_0xab71('0x78'))[_0xab71('0x37')](_0xab71('0x6f'),_0x7466ba['CmListId'][_0xab71('0x6c')]())[_0xab71('0x37')](_0xab71('0x70')))[_0xab71('0x6c')]();_0x4f63bd['push'](db[_0xab71('0x7a')][_0xab71('0x30')](_0x10cf4b));}return BPromise[_0xab71('0x7b')](_0x4f63bd);}})[_0xab71('0x25')](function(){return _0x43a1c7;})[_0xab71('0x25')](respondWithResult(_0x5b05e9,null))[_0xab71('0x43')](handleError(_0x5b05e9,null));};exports['removeBlackLists']=function(_0x3cbf3f,_0x48aebd,_0x47c34f){return db[_0xab71('0x2c')]['find']({'where':{'id':_0x3cbf3f[_0xab71('0x45')]['id']}})['then'](handleEntityNotFound(_0x48aebd,null))[_0xab71('0x25')](function(_0x434c4d){if(_0x434c4d){return _0x434c4d['removeBlackLists'](_0x3cbf3f[_0xab71('0x30')][_0xab71('0x60')]);}})[_0xab71('0x25')](function(_0x563efd){if(_0x563efd){return db[_0xab71('0x5d')][_0xab71('0x22')]({'where':{'ListId':_0x3cbf3f[_0xab71('0x30')]['ids'],'CampaignId':_0x3cbf3f['params']['id']}})[_0xab71('0x25')](function(){return _0x563efd;});}})[_0xab71('0x25')](respondWithStatusCode(_0x48aebd,null))[_0xab71('0x43')](handleError(_0x48aebd,null));};