798ad4f700fd06311765c55ae0cdd4eb93119737
[motion2.git] / server / api / campaign / campaign.controller.js
1 // *************************************************************************
2 // *                                                                       *
3 // * xCALLY Motion -  The Omnichannel Contact Center                       *
4 // * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
5 // *                                                                       *
6 // *************************************************************************
7 // *                                                                       *
8 // * Email: info@xcally.com                                                *
9 // * Website: https://www.xcally.com                                       *
10 // *                                                                       *
11 // *************************************************************************
12 // *                                                                       *
13 // * The SOFTWARE PRODUCT is protected by copyright laws and international *
14 // * copyright treaties, as well as other intellectual property laws and   *
15 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
16 // *                                                                       *
17 // *************************************************************************
18 var _0xd64b=['CmHopperHistory','rows','CmHopperFinal','order','getHopperBlacks','CmHopperBlack','CmList','getLists','format','addLists','ids','omit','spread','dialCheckDuplicateType','always','into','cm_hopper','phone','ContactId','ListId','field','scheduledAt','CmListId','toString','cm_contacts','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','COALESCE(calleridnum,\x27\x27)','from','cm_hopper_final','CampaignId\x20=\x20?','select','insert','fromQuery','NOW()','COALESCE(phone,\x27\x27)','cm_hopper_additional_phones','cmHopperId','ci.item','ci.OrderBY','cm_contact_has_items','h.ContactId\x20=\x20ci.CmContactId','h.ListId\x20=\x20?','h.CampaignId=?','h.createdAt\x20=\x20?','all','getBlackLists','addBlackLists','YYYY-MM-DD\x20HH:mm:ss','push','sequelize','removeBlackLists','eml-format','zip-dir','request-promise','moment','bluebird','mustache','util','fs-extra','lodash','squel','crypto','jsforce','desk.js','to-csv','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/license/util','sendStatus','status','end','json','undefined','count','offset','apply','reject','update','then','destroy','get','IvrCampaigns','stack','name','send','index','map','Campaign','rawAttributes','type','model','keys','intersection','query','fields','attributes','length','hasOwnProperty','nolimit','limit','where','pick','merge','filter','options','includeAll','include','findAll','catch','params','filters','find','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','autoAssociation','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','updatedAt','body','createdAt','getHoppers','findOne','CmHopper','sort','CampaignId','getHopperHistories'];(function(_0x3c24fc,_0x392f8b){var _0x580736=function(_0x236a7a){while(--_0x236a7a){_0x3c24fc['push'](_0x3c24fc['shift']());}};_0x580736(++_0x392f8b);}(_0xd64b,0xc1));var _0xbd64=function(_0x1fd9e7,_0x24cdbe){_0x1fd9e7=_0x1fd9e7-0x0;var _0x1781f2=_0xd64b[_0x1fd9e7];return _0x1781f2;};'use strict';var emlformat=require(_0xbd64('0x0'));var rimraf=require('rimraf');var zipdir=require(_0xbd64('0x1'));var jsonpatch=require('fast-json-patch');var rp=require(_0xbd64('0x2'));var moment=require(_0xbd64('0x3'));var BPromise=require(_0xbd64('0x4'));var Mustache=require(_0xbd64('0x5'));var util=require(_0xbd64('0x6'));var path=require('path');var sox=require('sox');var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0xbd64('0x7'));var _=require(_0xbd64('0x8'));var squel=require(_0xbd64('0x9'));var crypto=require(_0xbd64('0xa'));var jsforce=require(_0xbd64('0xb'));var deskjs=require(_0xbd64('0xc'));var toCsv=require(_0xbd64('0xd'));var querystring=require('querystring');var Papa=require('papaparse');var Redis=require(_0xbd64('0xe'));var authService=require(_0xbd64('0xf'));var qs=require(_0xbd64('0x10'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xbd64('0x11'));var logger=require(_0xbd64('0x12'))(_0xbd64('0x13'));var utils=require(_0xbd64('0x14'));var config=require('../../config/environment');var licenseUtil=require(_0xbd64('0x15'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x136f60,_0x2729d8){_0x2729d8=_0x2729d8||0xcc;return function(_0x3a941c){if(_0x3a941c){return _0x136f60[_0xbd64('0x16')](_0x2729d8);}return _0x136f60[_0xbd64('0x17')](_0x2729d8)[_0xbd64('0x18')]();};}function respondWithResult(_0x2e23f2,_0x269e2f){_0x269e2f=_0x269e2f||0xc8;return function(_0x2b5808){if(_0x2b5808){return _0x2e23f2['status'](_0x269e2f)[_0xbd64('0x19')](_0x2b5808);}};}function respondWithFilteredResult(_0x13e7a4,_0x3ff550){return function(_0x32fd34){if(_0x32fd34){var _0x29fc16=typeof _0x3ff550['offset']===_0xbd64('0x1a')&&typeof _0x3ff550['limit']===_0xbd64('0x1a');var _0x1432a6=_0x32fd34[_0xbd64('0x1b')];var _0x1d7a14=_0x29fc16?0x0:_0x3ff550[_0xbd64('0x1c')];var _0x2f4554=_0x29fc16?_0x32fd34[_0xbd64('0x1b')]:_0x3ff550[_0xbd64('0x1c')]+_0x3ff550['limit'];var _0x305545;if(_0x2f4554>=_0x1432a6){_0x2f4554=_0x1432a6;_0x305545=0xc8;}else{_0x305545=0xce;}_0x13e7a4[_0xbd64('0x17')](_0x305545);return _0x13e7a4['set']('Content-Range',_0x1d7a14+'-'+_0x2f4554+'/'+_0x1432a6)[_0xbd64('0x19')](_0x32fd34);}return null;};}function patchUpdates(_0x42b328){return function(_0x196d21){try{jsonpatch[_0xbd64('0x1d')](_0x196d21,_0x42b328,!![]);}catch(_0x2c5551){return BPromise[_0xbd64('0x1e')](_0x2c5551);}return _0x196d21['save']();};}function saveUpdates(_0x4d4a16,_0x6038f){return function(_0x41f2f){if(_0x41f2f){return _0x41f2f[_0xbd64('0x1f')](_0x4d4a16)[_0xbd64('0x20')](function(_0x55e74c){return _0x55e74c;});}return null;};}function removeEntity(_0x51d118,_0x28497c){return function(_0x4afaff){if(_0x4afaff){return _0x4afaff[_0xbd64('0x21')]()['then'](function(){var _0x33452d=_0x4afaff[_0xbd64('0x22')]({'plain':!![]});var _0x3d12a0=_0xbd64('0x23');return db['UserProfileResource'][_0xbd64('0x21')]({'where':{'type':_0x3d12a0,'resourceId':_0x33452d['id']}})[_0xbd64('0x20')](function(){return _0x4afaff;});})[_0xbd64('0x20')](function(){_0x51d118[_0xbd64('0x17')](0xcc)['end']();});}};}function handleEntityNotFound(_0x4e8719,_0x29c9c8){return function(_0x49eac5){if(!_0x49eac5){_0x4e8719['sendStatus'](0x194);}return _0x49eac5;};}function handleError(_0xfa918,_0x5aacdd){_0x5aacdd=_0x5aacdd||0x1f4;return function(_0x3cf5b7){logger['error'](_0x3cf5b7[_0xbd64('0x24')]);if(_0x3cf5b7['name']){delete _0x3cf5b7[_0xbd64('0x25')];}_0xfa918[_0xbd64('0x17')](_0x5aacdd)[_0xbd64('0x26')](_0x3cf5b7);};}exports[_0xbd64('0x27')]=function(_0x306f19,_0x207ffc){var _0x4ed44a={},_0x35bdd5={},_0xe876c9={'count':0x0,'rows':[]};var _0xc44280=_[_0xbd64('0x28')](db[_0xbd64('0x29')][_0xbd64('0x2a')],function(_0x5e70d3){return{'name':_0x5e70d3['fieldName'],'type':_0x5e70d3[_0xbd64('0x2b')]['key']};});_0x35bdd5[_0xbd64('0x2c')]=_[_0xbd64('0x28')](_0xc44280,'name');_0x35bdd5['query']=_[_0xbd64('0x2d')](_0x306f19['query']);_0x35bdd5['filters']=_[_0xbd64('0x2e')](_0x35bdd5[_0xbd64('0x2c')],_0x35bdd5[_0xbd64('0x2f')]);_0x4ed44a['attributes']=_[_0xbd64('0x2e')](_0x35bdd5['model'],qs[_0xbd64('0x30')](_0x306f19[_0xbd64('0x2f')][_0xbd64('0x30')]));_0x4ed44a[_0xbd64('0x31')]=_0x4ed44a[_0xbd64('0x31')][_0xbd64('0x32')]?_0x4ed44a['attributes']:_0x35bdd5['model'];if(!_0x306f19[_0xbd64('0x2f')][_0xbd64('0x33')](_0xbd64('0x34'))){_0x4ed44a[_0xbd64('0x35')]=qs[_0xbd64('0x35')](_0x306f19[_0xbd64('0x2f')]['limit']);_0x4ed44a['offset']=qs[_0xbd64('0x1c')](_0x306f19[_0xbd64('0x2f')][_0xbd64('0x1c')]);}_0x4ed44a['order']=qs['sort'](_0x306f19[_0xbd64('0x2f')]['sort']);_0x4ed44a[_0xbd64('0x36')]=qs['filters'](_[_0xbd64('0x37')](_0x306f19[_0xbd64('0x2f')],_0x35bdd5['filters']),_0xc44280);if(_0x306f19[_0xbd64('0x2f')]['filter']){_0x4ed44a['where']=_[_0xbd64('0x38')](_0x4ed44a[_0xbd64('0x36')],{'$or':_[_0xbd64('0x28')](_0xc44280,function(_0x52f401){if(_0x52f401['type']!=='VIRTUAL'){var _0x344d46={};_0x344d46[_0x52f401[_0xbd64('0x25')]]={'$like':'%'+_0x306f19['query'][_0xbd64('0x39')]+'%'};return _0x344d46;}})});}_0x4ed44a=_[_0xbd64('0x38')]({},_0x4ed44a,_0x306f19[_0xbd64('0x3a')]);var _0x27fd12={'where':_0x4ed44a['where']};return db['Campaign'][_0xbd64('0x1b')](_0x27fd12)['then'](function(_0x595a91){_0xe876c9[_0xbd64('0x1b')]=_0x595a91;if(_0x306f19[_0xbd64('0x2f')][_0xbd64('0x3b')]){_0x4ed44a[_0xbd64('0x3c')]=[{'all':!![]}];}return db[_0xbd64('0x29')][_0xbd64('0x3d')](_0x4ed44a);})[_0xbd64('0x20')](function(_0x762380){_0xe876c9['rows']=_0x762380;return _0xe876c9;})[_0xbd64('0x20')](respondWithFilteredResult(_0x207ffc,_0x4ed44a))[_0xbd64('0x3e')](handleError(_0x207ffc,null));};exports['show']=function(_0x41b27a,_0x1e4983){var _0xe5b069={'raw':![],'where':{'id':_0x41b27a[_0xbd64('0x3f')]['id']}},_0x2bc972={};_0x2bc972[_0xbd64('0x2c')]=_[_0xbd64('0x2d')](db['Campaign'][_0xbd64('0x2a')]);_0x2bc972['query']=_[_0xbd64('0x2d')](_0x41b27a['query']);_0x2bc972[_0xbd64('0x40')]=_[_0xbd64('0x2e')](_0x2bc972[_0xbd64('0x2c')],_0x2bc972['query']);_0xe5b069[_0xbd64('0x31')]=_['intersection'](_0x2bc972['model'],qs['fields'](_0x41b27a[_0xbd64('0x2f')][_0xbd64('0x30')]));_0xe5b069[_0xbd64('0x31')]=_0xe5b069[_0xbd64('0x31')][_0xbd64('0x32')]?_0xe5b069[_0xbd64('0x31')]:_0x2bc972[_0xbd64('0x2c')];if(_0x41b27a['query'][_0xbd64('0x3b')]){_0xe5b069[_0xbd64('0x3c')]=[{'all':!![]}];}_0xe5b069=_[_0xbd64('0x38')]({},_0xe5b069,_0x41b27a['options']);return db[_0xbd64('0x29')][_0xbd64('0x41')](_0xe5b069)[_0xbd64('0x20')](handleEntityNotFound(_0x1e4983,null))[_0xbd64('0x20')](respondWithResult(_0x1e4983,null))[_0xbd64('0x3e')](handleError(_0x1e4983,null));};exports['create']=function(_0x283699,_0x1a9ec8){return db[_0xbd64('0x29')][_0xbd64('0x42')](_0x283699['body'],{})['then'](function(_0x1e008f){var _0x2a7eec=_0x283699[_0xbd64('0x43')][_0xbd64('0x22')]({'plain':!![]});if(!_0x2a7eec)throw new Error(_0xbd64('0x44'));if(_0x2a7eec[_0xbd64('0x45')]===_0xbd64('0x43')){var _0x3807a7=_0x1e008f[_0xbd64('0x22')]({'plain':!![]});var _0x2709b2=_0xbd64('0x23');return db[_0xbd64('0x46')][_0xbd64('0x41')]({'where':{'name':_0x2709b2,'userProfileId':_0x2a7eec[_0xbd64('0x47')]},'raw':!![]})[_0xbd64('0x20')](function(_0x5bd444){if(_0x5bd444&&_0x5bd444[_0xbd64('0x48')]===0x0){return db['UserProfileResource']['create']({'name':_0x3807a7['name'],'resourceId':_0x3807a7['id'],'type':_0x5bd444['name'],'sectionId':_0x5bd444['id']},{})[_0xbd64('0x20')](function(){return _0x1e008f;});}else{return _0x1e008f;}})[_0xbd64('0x3e')](function(_0x5480f5){logger[_0xbd64('0x49')](_0xbd64('0x4a'),_0x5480f5);throw _0x5480f5;});}return _0x1e008f;})[_0xbd64('0x20')](respondWithResult(_0x1a9ec8,0xc9))['catch'](handleError(_0x1a9ec8,null));};exports[_0xbd64('0x4b')]=function(_0x371bad,_0x44cd4f){var _0x1db94c={'where':{'id':_0x371bad[_0xbd64('0x3f')]['id']}},_0x2436c1={};_0x2436c1['model']=_['keys'](db['Campaign'][_0xbd64('0x2a')]);_0x1db94c[_0xbd64('0x31')]=_[_0xbd64('0x2e')](_0x2436c1[_0xbd64('0x2c')],qs['fields'](_0x371bad[_0xbd64('0x2f')][_0xbd64('0x30')]));_0x1db94c[_0xbd64('0x31')]=_0x1db94c[_0xbd64('0x31')][_0xbd64('0x32')]?_0x1db94c[_0xbd64('0x31')]:_0x2436c1['model'];if(_0x371bad[_0xbd64('0x2f')][_0xbd64('0x3b')]){_0x1db94c[_0xbd64('0x3c')]=[{'all':!![]}];}_0x1db94c=_[_0xbd64('0x38')]({},_0x1db94c,_0x371bad[_0xbd64('0x3a')]);return db[_0xbd64('0x29')][_0xbd64('0x41')](_0x1db94c)[_0xbd64('0x20')](handleEntityNotFound(_0x44cd4f,null))[_0xbd64('0x20')](function(_0x1e8e1c){if(_0x1e8e1c){var _0x3812b3=_0x1e8e1c[_0xbd64('0x22')]({'plain':!![]});_0x3812b3=qs['omit'](_0x3812b3,['id','createdAt',_0xbd64('0x4c')]);_0x371bad[_0xbd64('0x4d')]=_['omit'](_0x371bad['body'],['id',_0xbd64('0x4e'),_0xbd64('0x4c')]);return db['Campaign'][_0xbd64('0x42')](_[_0xbd64('0x38')](_0x3812b3,_0x371bad[_0xbd64('0x4d')]),{'include':_0x371bad[_0xbd64('0x2f')][_0xbd64('0x3b')]?[{'all':!![]}]:undefined})[_0xbd64('0x20')](function(_0x2d788){var _0x23e602=_0x371bad[_0xbd64('0x43')]['get']({'plain':!![]});if(!_0x23e602)throw new Error(_0xbd64('0x44'));if(_0x23e602[_0xbd64('0x45')]===_0xbd64('0x43')){var _0x5054a6=_0x2d788[_0xbd64('0x22')]({'plain':!![]});var _0x39fae9='IvrCampaigns';return db[_0xbd64('0x46')][_0xbd64('0x41')]({'where':{'name':_0x39fae9,'userProfileId':_0x23e602[_0xbd64('0x47')]},'raw':!![]})[_0xbd64('0x20')](function(_0x3615bc){if(_0x3615bc&&_0x3615bc[_0xbd64('0x48')]===0x0){return db['UserProfileResource'][_0xbd64('0x42')]({'name':_0x5054a6[_0xbd64('0x25')],'resourceId':_0x5054a6['id'],'type':_0x3615bc[_0xbd64('0x25')],'sectionId':_0x3615bc['id']},{})[_0xbd64('0x20')](function(){return _0x2d788;});}else{return _0x2d788;}})['catch'](function(_0xff862e){logger[_0xbd64('0x49')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0xff862e);throw _0xff862e;});}return _0x2d788;});}})[_0xbd64('0x20')](respondWithResult(_0x44cd4f,0xc9))['catch'](handleError(_0x44cd4f,null));};exports[_0xbd64('0x1f')]=function(_0x10e269,_0x1c10df){if(_0x10e269[_0xbd64('0x4d')]['id']){delete _0x10e269['body']['id'];}return db[_0xbd64('0x29')][_0xbd64('0x41')]({'where':{'id':_0x10e269[_0xbd64('0x3f')]['id']}})[_0xbd64('0x20')](handleEntityNotFound(_0x1c10df,null))[_0xbd64('0x20')](saveUpdates(_0x10e269[_0xbd64('0x4d')],null))['then'](respondWithResult(_0x1c10df,null))['catch'](handleError(_0x1c10df,null));};exports['destroy']=function(_0x36f3a8,_0xd1b21f){return db[_0xbd64('0x29')][_0xbd64('0x41')]({'where':{'id':_0x36f3a8[_0xbd64('0x3f')]['id']}})[_0xbd64('0x20')](handleEntityNotFound(_0xd1b21f,null))['then'](removeEntity(_0xd1b21f,null))[_0xbd64('0x3e')](handleError(_0xd1b21f,null));};exports[_0xbd64('0x4f')]=function(_0x305ffc,_0x333720,_0x12f171){var _0x463105={'raw':!![],'where':{}};var _0x2f3516={};var _0x3d7e47={'count':0x0,'rows':[]};return db[_0xbd64('0x29')][_0xbd64('0x50')]({'where':{'id':_0x305ffc[_0xbd64('0x3f')]['id']}})[_0xbd64('0x20')](handleEntityNotFound(_0x333720,null))['then'](function(_0x5f16fd){if(_0x5f16fd){_0x2f3516[_0xbd64('0x2c')]=_[_0xbd64('0x2d')](db[_0xbd64('0x51')]['rawAttributes']);_0x2f3516[_0xbd64('0x2f')]=_['keys'](_0x305ffc[_0xbd64('0x2f')]);_0x2f3516[_0xbd64('0x40')]=_[_0xbd64('0x2e')](_0x2f3516[_0xbd64('0x2c')],_0x2f3516['query']);_0x463105[_0xbd64('0x31')]=_['intersection'](_0x2f3516[_0xbd64('0x2c')],qs[_0xbd64('0x30')](_0x305ffc[_0xbd64('0x2f')][_0xbd64('0x30')]));_0x463105[_0xbd64('0x31')]=_0x463105['attributes'][_0xbd64('0x32')]?_0x463105[_0xbd64('0x31')]:_0x2f3516['model'];if(!_0x305ffc[_0xbd64('0x2f')][_0xbd64('0x33')](_0xbd64('0x34'))){_0x463105[_0xbd64('0x35')]=qs['limit'](_0x305ffc[_0xbd64('0x2f')]['limit']);_0x463105[_0xbd64('0x1c')]=qs[_0xbd64('0x1c')](_0x305ffc[_0xbd64('0x2f')]['offset']);}_0x463105['order']=qs['sort'](_0x305ffc['query'][_0xbd64('0x52')]);_0x463105[_0xbd64('0x36')]=qs[_0xbd64('0x40')](_[_0xbd64('0x37')](_0x305ffc[_0xbd64('0x2f')],_0x2f3516['filters']));_0x463105[_0xbd64('0x36')][_0xbd64('0x53')]=_0x5f16fd['id'];if(_0x305ffc[_0xbd64('0x2f')][_0xbd64('0x39')]){_0x463105[_0xbd64('0x36')]=_['merge'](_0x463105[_0xbd64('0x36')],{'$or':_[_0xbd64('0x28')](_0x463105[_0xbd64('0x31')],function(_0x808467){var _0x5875da={};_0x5875da[_0x808467]={'$like':'%'+_0x305ffc['query'][_0xbd64('0x39')]+'%'};return _0x5875da;})});}_0x463105=_[_0xbd64('0x38')]({},_0x463105,_0x305ffc[_0xbd64('0x3a')]);return db[_0xbd64('0x51')][_0xbd64('0x1b')]({'where':_0x463105[_0xbd64('0x36')]})[_0xbd64('0x20')](function(_0x344285){_0x3d7e47['count']=_0x344285;if(_0x305ffc[_0xbd64('0x2f')]['includeAll']){_0x463105[_0xbd64('0x3c')]=[{'all':!![]}];}return db[_0xbd64('0x51')][_0xbd64('0x3d')](_0x463105);})['then'](function(_0x15b625){_0x3d7e47['rows']=_0x15b625;return _0x3d7e47;});}})['then'](respondWithFilteredResult(_0x333720,_0x463105))[_0xbd64('0x3e')](handleError(_0x333720,null));};exports[_0xbd64('0x54')]=function(_0x448254,_0x5b5428,_0x364af8){var _0x3a34b7={'raw':!![],'where':{}};var _0x8150bb={};var _0x35cf6a={'count':0x0,'rows':[]};return db['Campaign'][_0xbd64('0x50')]({'where':{'id':_0x448254[_0xbd64('0x3f')]['id']}})[_0xbd64('0x20')](handleEntityNotFound(_0x5b5428,null))[_0xbd64('0x20')](function(_0x339e52){if(_0x339e52){_0x8150bb[_0xbd64('0x2c')]=_[_0xbd64('0x2d')](db[_0xbd64('0x55')][_0xbd64('0x2a')]);_0x8150bb[_0xbd64('0x2f')]=_[_0xbd64('0x2d')](_0x448254[_0xbd64('0x2f')]);_0x8150bb[_0xbd64('0x40')]=_[_0xbd64('0x2e')](_0x8150bb['model'],_0x8150bb['query']);_0x3a34b7[_0xbd64('0x31')]=_[_0xbd64('0x2e')](_0x8150bb[_0xbd64('0x2c')],qs['fields'](_0x448254[_0xbd64('0x2f')]['fields']));_0x3a34b7[_0xbd64('0x31')]=_0x3a34b7[_0xbd64('0x31')][_0xbd64('0x32')]?_0x3a34b7[_0xbd64('0x31')]:_0x8150bb['model'];if(!_0x448254[_0xbd64('0x2f')][_0xbd64('0x33')]('nolimit')){_0x3a34b7[_0xbd64('0x35')]=qs['limit'](_0x448254[_0xbd64('0x2f')][_0xbd64('0x35')]);_0x3a34b7[_0xbd64('0x1c')]=qs[_0xbd64('0x1c')](_0x448254[_0xbd64('0x2f')][_0xbd64('0x1c')]);}_0x3a34b7['order']=qs[_0xbd64('0x52')](_0x448254['query'][_0xbd64('0x52')]);_0x3a34b7[_0xbd64('0x36')]=qs['filters'](_[_0xbd64('0x37')](_0x448254['query'],_0x8150bb[_0xbd64('0x40')]));_0x3a34b7[_0xbd64('0x36')][_0xbd64('0x53')]=_0x339e52['id'];if(_0x448254['query'][_0xbd64('0x39')]){_0x3a34b7[_0xbd64('0x36')]=_[_0xbd64('0x38')](_0x3a34b7[_0xbd64('0x36')],{'$or':_[_0xbd64('0x28')](_0x3a34b7['attributes'],function(_0x58efa2){var _0x42feee={};_0x42feee[_0x58efa2]={'$like':'%'+_0x448254[_0xbd64('0x2f')][_0xbd64('0x39')]+'%'};return _0x42feee;})});}_0x3a34b7=_[_0xbd64('0x38')]({},_0x3a34b7,_0x448254[_0xbd64('0x3a')]);return db[_0xbd64('0x55')][_0xbd64('0x1b')]({'where':_0x3a34b7[_0xbd64('0x36')]})[_0xbd64('0x20')](function(_0x4224c3){_0x35cf6a[_0xbd64('0x1b')]=_0x4224c3;if(_0x448254[_0xbd64('0x2f')][_0xbd64('0x3b')]){_0x3a34b7['include']=[{'all':!![]}];}return db[_0xbd64('0x55')][_0xbd64('0x3d')](_0x3a34b7);})['then'](function(_0x3a375c){_0x35cf6a[_0xbd64('0x56')]=_0x3a375c;return _0x35cf6a;});}})[_0xbd64('0x20')](respondWithFilteredResult(_0x5b5428,_0x3a34b7))[_0xbd64('0x3e')](handleError(_0x5b5428,null));};exports['getHopperFinals']=function(_0x5c6fc0,_0x25ce1e,_0x923e5a){var _0x7f4e70={'raw':!![],'where':{}};var _0x2af19c={};var _0x46a391={'count':0x0,'rows':[]};return db[_0xbd64('0x29')][_0xbd64('0x50')]({'where':{'id':_0x5c6fc0[_0xbd64('0x3f')]['id']}})[_0xbd64('0x20')](handleEntityNotFound(_0x25ce1e,null))[_0xbd64('0x20')](function(_0x1c5e0a){if(_0x1c5e0a){_0x2af19c[_0xbd64('0x2c')]=_['keys'](db[_0xbd64('0x57')][_0xbd64('0x2a')]);_0x2af19c[_0xbd64('0x2f')]=_['keys'](_0x5c6fc0['query']);_0x2af19c[_0xbd64('0x40')]=_[_0xbd64('0x2e')](_0x2af19c['model'],_0x2af19c[_0xbd64('0x2f')]);_0x7f4e70[_0xbd64('0x31')]=_[_0xbd64('0x2e')](_0x2af19c[_0xbd64('0x2c')],qs[_0xbd64('0x30')](_0x5c6fc0[_0xbd64('0x2f')][_0xbd64('0x30')]));_0x7f4e70[_0xbd64('0x31')]=_0x7f4e70[_0xbd64('0x31')][_0xbd64('0x32')]?_0x7f4e70[_0xbd64('0x31')]:_0x2af19c[_0xbd64('0x2c')];if(!_0x5c6fc0['query'][_0xbd64('0x33')]('nolimit')){_0x7f4e70[_0xbd64('0x35')]=qs[_0xbd64('0x35')](_0x5c6fc0[_0xbd64('0x2f')][_0xbd64('0x35')]);_0x7f4e70[_0xbd64('0x1c')]=qs['offset'](_0x5c6fc0[_0xbd64('0x2f')][_0xbd64('0x1c')]);}_0x7f4e70[_0xbd64('0x58')]=qs[_0xbd64('0x52')](_0x5c6fc0['query'][_0xbd64('0x52')]);_0x7f4e70['where']=qs[_0xbd64('0x40')](_[_0xbd64('0x37')](_0x5c6fc0[_0xbd64('0x2f')],_0x2af19c[_0xbd64('0x40')]));_0x7f4e70[_0xbd64('0x36')][_0xbd64('0x53')]=_0x1c5e0a['id'];if(_0x5c6fc0[_0xbd64('0x2f')]['filter']){_0x7f4e70[_0xbd64('0x36')]=_[_0xbd64('0x38')](_0x7f4e70[_0xbd64('0x36')],{'$or':_[_0xbd64('0x28')](_0x7f4e70['attributes'],function(_0x38b2b3){var _0x232cca={};_0x232cca[_0x38b2b3]={'$like':'%'+_0x5c6fc0[_0xbd64('0x2f')][_0xbd64('0x39')]+'%'};return _0x232cca;})});}_0x7f4e70=_[_0xbd64('0x38')]({},_0x7f4e70,_0x5c6fc0[_0xbd64('0x3a')]);return db[_0xbd64('0x57')]['count']({'where':_0x7f4e70[_0xbd64('0x36')]})['then'](function(_0x168c17){_0x46a391['count']=_0x168c17;if(_0x5c6fc0['query'][_0xbd64('0x3b')]){_0x7f4e70[_0xbd64('0x3c')]=[{'all':!![]}];}return db[_0xbd64('0x57')]['findAll'](_0x7f4e70);})[_0xbd64('0x20')](function(_0x49d6fe){_0x46a391[_0xbd64('0x56')]=_0x49d6fe;return _0x46a391;});}})['then'](respondWithFilteredResult(_0x25ce1e,_0x7f4e70))['catch'](handleError(_0x25ce1e,null));};exports[_0xbd64('0x59')]=function(_0x680b67,_0x30a8b4,_0x310ee4){var _0x34c941={'raw':!![],'where':{}};var _0x2e67e9={};var _0x2982c2={'count':0x0,'rows':[]};return db[_0xbd64('0x29')]['findOne']({'where':{'id':_0x680b67['params']['id']}})[_0xbd64('0x20')](handleEntityNotFound(_0x30a8b4,null))['then'](function(_0x216dd1){if(_0x216dd1){_0x2e67e9[_0xbd64('0x2c')]=_[_0xbd64('0x2d')](db['CmHopperBlack'][_0xbd64('0x2a')]);_0x2e67e9[_0xbd64('0x2f')]=_['keys'](_0x680b67[_0xbd64('0x2f')]);_0x2e67e9[_0xbd64('0x40')]=_['intersection'](_0x2e67e9['model'],_0x2e67e9[_0xbd64('0x2f')]);_0x34c941[_0xbd64('0x31')]=_[_0xbd64('0x2e')](_0x2e67e9[_0xbd64('0x2c')],qs[_0xbd64('0x30')](_0x680b67[_0xbd64('0x2f')][_0xbd64('0x30')]));_0x34c941[_0xbd64('0x31')]=_0x34c941[_0xbd64('0x31')][_0xbd64('0x32')]?_0x34c941[_0xbd64('0x31')]:_0x2e67e9[_0xbd64('0x2c')];if(!_0x680b67[_0xbd64('0x2f')][_0xbd64('0x33')](_0xbd64('0x34'))){_0x34c941['limit']=qs[_0xbd64('0x35')](_0x680b67['query'][_0xbd64('0x35')]);_0x34c941[_0xbd64('0x1c')]=qs['offset'](_0x680b67[_0xbd64('0x2f')]['offset']);}_0x34c941[_0xbd64('0x58')]=qs[_0xbd64('0x52')](_0x680b67[_0xbd64('0x2f')][_0xbd64('0x52')]);_0x34c941['where']=qs[_0xbd64('0x40')](_[_0xbd64('0x37')](_0x680b67[_0xbd64('0x2f')],_0x2e67e9[_0xbd64('0x40')]));_0x34c941['where']['CampaignId']=_0x216dd1['id'];if(_0x680b67[_0xbd64('0x2f')][_0xbd64('0x39')]){_0x34c941[_0xbd64('0x36')]=_['merge'](_0x34c941[_0xbd64('0x36')],{'$or':_['map'](_0x34c941[_0xbd64('0x31')],function(_0x1bde47){var _0x21b397={};_0x21b397[_0x1bde47]={'$like':'%'+_0x680b67[_0xbd64('0x2f')][_0xbd64('0x39')]+'%'};return _0x21b397;})});}_0x34c941=_['merge']({},_0x34c941,_0x680b67['options']);return db[_0xbd64('0x5a')][_0xbd64('0x1b')]({'where':_0x34c941[_0xbd64('0x36')]})['then'](function(_0x2c805b){_0x2982c2['count']=_0x2c805b;if(_0x680b67[_0xbd64('0x2f')][_0xbd64('0x3b')]){_0x34c941[_0xbd64('0x3c')]=[{'all':!![]}];}return db['CmHopperBlack'][_0xbd64('0x3d')](_0x34c941);})[_0xbd64('0x20')](function(_0x496475){_0x2982c2['rows']=_0x496475;return _0x2982c2;});}})[_0xbd64('0x20')](respondWithFilteredResult(_0x30a8b4,_0x34c941))['catch'](handleError(_0x30a8b4,null));};exports['getLists']=function(_0x1442ee,_0x237a8c,_0x4e3663){var _0xa932c3={};var _0x540513={};var _0x4011c5;var _0x1c999a;return db[_0xbd64('0x29')]['findOne']({'where':{'id':_0x1442ee[_0xbd64('0x3f')]['id']}})['then'](handleEntityNotFound(_0x237a8c,null))['then'](function(_0x4abd1b){if(_0x4abd1b){_0x4011c5=_0x4abd1b;_0x540513[_0xbd64('0x2c')]=_[_0xbd64('0x2d')](db[_0xbd64('0x5b')]['rawAttributes']);_0x540513[_0xbd64('0x2f')]=_['keys'](_0x1442ee[_0xbd64('0x2f')]);_0x540513['filters']=_['intersection'](_0x540513['model'],_0x540513[_0xbd64('0x2f')]);_0xa932c3[_0xbd64('0x31')]=_[_0xbd64('0x2e')](_0x540513[_0xbd64('0x2c')],qs['fields'](_0x1442ee[_0xbd64('0x2f')][_0xbd64('0x30')]));_0xa932c3[_0xbd64('0x31')]=_0xa932c3['attributes'][_0xbd64('0x32')]?_0xa932c3['attributes']:_0x540513[_0xbd64('0x2c')];_0xa932c3[_0xbd64('0x58')]=qs[_0xbd64('0x52')](_0x1442ee[_0xbd64('0x2f')][_0xbd64('0x52')]);_0xa932c3[_0xbd64('0x36')]=qs[_0xbd64('0x40')](_[_0xbd64('0x37')](_0x1442ee[_0xbd64('0x2f')],_0x540513[_0xbd64('0x40')]));if(_0x1442ee[_0xbd64('0x2f')][_0xbd64('0x39')]){_0xa932c3[_0xbd64('0x36')]=_['merge'](_0xa932c3['where'],{'$or':_[_0xbd64('0x28')](_0xa932c3[_0xbd64('0x31')],function(_0x424f0f){var _0x3275d4={};_0x3275d4[_0x424f0f]={'$like':'%'+_0x1442ee['query'][_0xbd64('0x39')]+'%'};return _0x3275d4;})});}_0xa932c3=_['merge']({},_0xa932c3,_0x1442ee[_0xbd64('0x3a')]);return _0x4011c5['getLists'](_0xa932c3);}})['then'](function(_0x421cd3){if(_0x421cd3){_0x1c999a=_0x421cd3[_0xbd64('0x32')];if(!_0x1442ee['query'][_0xbd64('0x33')]('nolimit')){_0xa932c3[_0xbd64('0x35')]=qs['limit'](_0x1442ee[_0xbd64('0x2f')][_0xbd64('0x35')]);_0xa932c3[_0xbd64('0x1c')]=qs['offset'](_0x1442ee[_0xbd64('0x2f')][_0xbd64('0x1c')]);}return _0x4011c5[_0xbd64('0x5c')](_0xa932c3);}})[_0xbd64('0x20')](function(_0x21a8e6){if(_0x21a8e6){return _0x21a8e6?{'count':_0x1c999a,'rows':_0x21a8e6}:null;}})[_0xbd64('0x20')](respondWithResult(_0x237a8c,null))[_0xbd64('0x3e')](handleError(_0x237a8c,null));};exports['addLists']=function(_0x2b21d0,_0x38ed53,_0x56e59e){var _0x497b8e,_0x5de03a;var _0x20182f=[];var _0x3f3d60=moment()[_0xbd64('0x5d')]('YYYY-MM-DD\x20HH:mm:ss');return db[_0xbd64('0x29')]['find']({'where':{'id':_0x2b21d0[_0xbd64('0x3f')]['id']}})['then'](handleEntityNotFound(_0x38ed53,null))[_0xbd64('0x20')](function(_0x133cb4){if(_0x133cb4){_0x5de03a=_0x133cb4;return _0x133cb4[_0xbd64('0x5e')](_0x2b21d0[_0xbd64('0x4d')][_0xbd64('0x5f')],_[_0xbd64('0x60')](_0x2b21d0[_0xbd64('0x4d')],[_0xbd64('0x5f'),'id'])||{});}return null;})[_0xbd64('0x61')](function(_0x1e9882){var _0x3792f8;var _0x4d684d;_0x497b8e=_0x1e9882||[];var _0x168b3d=[];if(_0x1e9882){for(var _0x1dad77=0x0;_0x1dad77<_0x1e9882[_0xbd64('0x32')];_0x1dad77+=0x1){var _0x23fd87=_0x1e9882[_0x1dad77][_0xbd64('0x22')]({'plain':!![]});_0x5de03a[_0xbd64('0x62')]=_0x2b21d0[_0xbd64('0x4d')][_0xbd64('0x62')]?_0x2b21d0[_0xbd64('0x4d')]['dialCheckDuplicateType']:_0x5de03a['dialCheckDuplicateType'];switch(_0x5de03a[_0xbd64('0x62')]){case _0xbd64('0x63'):_0x3792f8=squel['insert']()[_0xbd64('0x64')](_0xbd64('0x65'))['fromQuery']([_0xbd64('0x66'),'scheduledAt',_0xbd64('0x67'),_0xbd64('0x68'),_0xbd64('0x53'),_0xbd64('0x4e'),_0xbd64('0x4c')],squel['select']()['field']('phone','phone')[_0xbd64('0x69')]('NOW()',_0xbd64('0x6a'))['field']('id','ContactId')[_0xbd64('0x69')](_0x23fd87[_0xbd64('0x6b')][_0xbd64('0x6c')](),_0xbd64('0x68'))[_0xbd64('0x69')](_0x2b21d0[_0xbd64('0x3f')]['id'][_0xbd64('0x6c')](),_0xbd64('0x53'))[_0xbd64('0x69')]('\x27'+_0x3f3d60+'\x27',_0xbd64('0x4e'))[_0xbd64('0x69')]('\x27'+_0x3f3d60+'\x27',_0xbd64('0x4c'))['from'](_0xbd64('0x6d'))[_0xbd64('0x36')](_0xbd64('0x6e'))[_0xbd64('0x36')](_0xbd64('0x6f'),_0x23fd87[_0xbd64('0x6b')]['toString']())[_0xbd64('0x36')](_0xbd64('0x70'))[_0xbd64('0x36')](_0xbd64('0x71'),squel['select']()[_0xbd64('0x69')](_0xbd64('0x72'))[_0xbd64('0x73')](_0xbd64('0x74'))['where'](_0xbd64('0x75'),_0x2b21d0['params']['id']['toString']()))['where'](_0xbd64('0x71'),squel[_0xbd64('0x76')]()['field']('COALESCE(phone,\x27\x27)')[_0xbd64('0x73')](_0xbd64('0x65'))[_0xbd64('0x36')](_0xbd64('0x75'),_0x2b21d0['params']['id']['toString']())))[_0xbd64('0x6c')]();break;case'onlyIfOpen':_0x3792f8=squel[_0xbd64('0x77')]()['into'](_0xbd64('0x65'))[_0xbd64('0x78')]([_0xbd64('0x66'),_0xbd64('0x6a'),'ContactId',_0xbd64('0x68'),_0xbd64('0x53'),_0xbd64('0x4e'),_0xbd64('0x4c')],squel['select']()[_0xbd64('0x69')](_0xbd64('0x66'),_0xbd64('0x66'))[_0xbd64('0x69')](_0xbd64('0x79'),_0xbd64('0x6a'))[_0xbd64('0x69')]('id',_0xbd64('0x67'))[_0xbd64('0x69')](_0x23fd87['CmListId']['toString'](),_0xbd64('0x68'))['field'](_0x2b21d0[_0xbd64('0x3f')]['id'][_0xbd64('0x6c')](),_0xbd64('0x53'))['field']('\x27'+_0x3f3d60+'\x27','createdAt')[_0xbd64('0x69')]('\x27'+_0x3f3d60+'\x27',_0xbd64('0x4c'))[_0xbd64('0x73')](_0xbd64('0x6d'))[_0xbd64('0x36')](_0xbd64('0x6e'))[_0xbd64('0x36')](_0xbd64('0x6f'),_0x23fd87[_0xbd64('0x6b')]['toString']())['where'](_0xbd64('0x70'))[_0xbd64('0x36')](_0xbd64('0x71'),squel[_0xbd64('0x76')]()['field'](_0xbd64('0x7a'))['from'](_0xbd64('0x65'))['where'](_0xbd64('0x75'),_0x2b21d0['params']['id'][_0xbd64('0x6c')]())))[_0xbd64('0x6c')]();break;default:_0x3792f8=squel[_0xbd64('0x77')]()[_0xbd64('0x64')](_0xbd64('0x65'))[_0xbd64('0x78')](['phone',_0xbd64('0x6a'),'ContactId',_0xbd64('0x68'),'CampaignId','createdAt',_0xbd64('0x4c')],squel[_0xbd64('0x76')]()[_0xbd64('0x69')]('phone',_0xbd64('0x66'))[_0xbd64('0x69')](_0xbd64('0x79'),_0xbd64('0x6a'))[_0xbd64('0x69')]('id','ContactId')[_0xbd64('0x69')](_0x23fd87['CmListId']['toString'](),_0xbd64('0x68'))[_0xbd64('0x69')](_0x2b21d0[_0xbd64('0x3f')]['id'][_0xbd64('0x6c')](),_0xbd64('0x53'))[_0xbd64('0x69')]('\x27'+_0x3f3d60+'\x27',_0xbd64('0x4e'))[_0xbd64('0x69')]('\x27'+_0x3f3d60+'\x27',_0xbd64('0x4c'))[_0xbd64('0x73')](_0xbd64('0x6d'))['where'](_0xbd64('0x6e'))[_0xbd64('0x36')](_0xbd64('0x6f'),_0x23fd87[_0xbd64('0x6b')]['toString']())[_0xbd64('0x36')](_0xbd64('0x70')))['toString']();}_0x4d684d=squel['insert']()[_0xbd64('0x64')](_0xbd64('0x7b'))[_0xbd64('0x78')]([_0xbd64('0x7c'),_0xbd64('0x6a'),_0xbd64('0x66'),'OrderBy',_0xbd64('0x4e'),_0xbd64('0x4c')],squel[_0xbd64('0x76')]()[_0xbd64('0x69')]('h.id','id')[_0xbd64('0x69')]('NOW()',_0xbd64('0x6a'))[_0xbd64('0x69')](_0xbd64('0x7d'),_0xbd64('0x66'))['field'](_0xbd64('0x7e'),'OrderBy')[_0xbd64('0x69')]('\x27'+_0x3f3d60+'\x27','createdAt')[_0xbd64('0x69')]('\x27'+_0x3f3d60+'\x27','updatedAt')[_0xbd64('0x73')](_0xbd64('0x7f'),'ci')['join'](_0xbd64('0x65'),'h',_0xbd64('0x80'))['where'](_0xbd64('0x81'),_0x23fd87[_0xbd64('0x6b')][_0xbd64('0x6c')]())['where'](_0xbd64('0x82'),_0x2b21d0[_0xbd64('0x3f')]['id'][_0xbd64('0x6c')]())['where'](_0xbd64('0x83'),_0x3f3d60))[_0xbd64('0x6c')]();_0x168b3d['push'](db['sequelize'][_0xbd64('0x2f')](_0x3792f8));_0x20182f['push'](db['sequelize'][_0xbd64('0x2f')](_0x4d684d));}return BPromise[_0xbd64('0x84')](_0x168b3d);}})[_0xbd64('0x20')](function(){return BPromise['all'](_0x20182f);})[_0xbd64('0x20')](function(){return _0x497b8e;})['then'](respondWithResult(_0x38ed53,null))[_0xbd64('0x3e')](handleError(_0x38ed53,null));};exports['removeLists']=function(_0x45f692,_0x1a899a,_0x4a2067){return db[_0xbd64('0x29')][_0xbd64('0x41')]({'where':{'id':_0x45f692[_0xbd64('0x3f')]['id']}})[_0xbd64('0x20')](handleEntityNotFound(_0x1a899a,null))[_0xbd64('0x20')](function(_0x415a60){if(_0x415a60){return _0x415a60['removeLists'](_0x45f692[_0xbd64('0x2f')][_0xbd64('0x5f')]);}})[_0xbd64('0x20')](function(_0x1a1bce){if(_0x1a1bce){return db[_0xbd64('0x51')][_0xbd64('0x21')]({'where':{'ListId':_0x45f692['query']['ids'],'CampaignId':_0x45f692[_0xbd64('0x3f')]['id']}})[_0xbd64('0x20')](function(){return _0x1a1bce;});}})[_0xbd64('0x20')](respondWithStatusCode(_0x1a899a,null))['catch'](handleError(_0x1a899a,null));};exports[_0xbd64('0x85')]=function(_0x2ab4d7,_0x3067fa,_0x3a35ad){var _0xa573d0={};var _0x46c4a4={};var _0x5a0256;var _0x55170c;return db[_0xbd64('0x29')][_0xbd64('0x50')]({'where':{'id':_0x2ab4d7[_0xbd64('0x3f')]['id']}})[_0xbd64('0x20')](handleEntityNotFound(_0x3067fa,null))['then'](function(_0x4e7e3a){if(_0x4e7e3a){_0x5a0256=_0x4e7e3a;_0x46c4a4['model']=_[_0xbd64('0x2d')](db['CmList'][_0xbd64('0x2a')]);_0x46c4a4[_0xbd64('0x2f')]=_[_0xbd64('0x2d')](_0x2ab4d7['query']);_0x46c4a4[_0xbd64('0x40')]=_[_0xbd64('0x2e')](_0x46c4a4[_0xbd64('0x2c')],_0x46c4a4[_0xbd64('0x2f')]);_0xa573d0[_0xbd64('0x31')]=_[_0xbd64('0x2e')](_0x46c4a4[_0xbd64('0x2c')],qs[_0xbd64('0x30')](_0x2ab4d7[_0xbd64('0x2f')][_0xbd64('0x30')]));_0xa573d0[_0xbd64('0x31')]=_0xa573d0[_0xbd64('0x31')][_0xbd64('0x32')]?_0xa573d0['attributes']:_0x46c4a4[_0xbd64('0x2c')];_0xa573d0['order']=qs[_0xbd64('0x52')](_0x2ab4d7[_0xbd64('0x2f')][_0xbd64('0x52')]);_0xa573d0[_0xbd64('0x36')]=qs[_0xbd64('0x40')](_[_0xbd64('0x37')](_0x2ab4d7['query'],_0x46c4a4['filters']));if(_0x2ab4d7['query']['filter']){_0xa573d0[_0xbd64('0x36')]=_[_0xbd64('0x38')](_0xa573d0[_0xbd64('0x36')],{'$or':_[_0xbd64('0x28')](_0xa573d0[_0xbd64('0x31')],function(_0x35d11f){var _0x46b0dd={};_0x46b0dd[_0x35d11f]={'$like':'%'+_0x2ab4d7[_0xbd64('0x2f')]['filter']+'%'};return _0x46b0dd;})});}_0xa573d0=_[_0xbd64('0x38')]({},_0xa573d0,_0x2ab4d7[_0xbd64('0x3a')]);return _0x5a0256['getBlackLists'](_0xa573d0);}})[_0xbd64('0x20')](function(_0x41294f){if(_0x41294f){_0x55170c=_0x41294f[_0xbd64('0x32')];if(!_0x2ab4d7[_0xbd64('0x2f')][_0xbd64('0x33')](_0xbd64('0x34'))){_0xa573d0[_0xbd64('0x35')]=qs[_0xbd64('0x35')](_0x2ab4d7[_0xbd64('0x2f')][_0xbd64('0x35')]);_0xa573d0[_0xbd64('0x1c')]=qs['offset'](_0x2ab4d7[_0xbd64('0x2f')][_0xbd64('0x1c')]);}return _0x5a0256[_0xbd64('0x85')](_0xa573d0);}})['then'](function(_0x216268){if(_0x216268){return _0x216268?{'count':_0x55170c,'rows':_0x216268}:null;}})['then'](respondWithResult(_0x3067fa,null))[_0xbd64('0x3e')](handleError(_0x3067fa,null));};exports[_0xbd64('0x86')]=function(_0x2e0988,_0x5e85b7,_0x52215e){var _0x33a01c,_0x452ff6;var _0x53fcb0=[];var _0xf28e24=moment()['format'](_0xbd64('0x87'));return db[_0xbd64('0x29')][_0xbd64('0x41')]({'where':{'id':_0x2e0988[_0xbd64('0x3f')]['id']}})[_0xbd64('0x20')](handleEntityNotFound(_0x5e85b7,null))[_0xbd64('0x20')](function(_0x476e9e){if(_0x476e9e){_0x452ff6=_0x476e9e;return _0x476e9e[_0xbd64('0x86')](_0x2e0988[_0xbd64('0x4d')][_0xbd64('0x5f')],_['omit'](_0x2e0988['body'],[_0xbd64('0x5f'),'id'])||{});}return null;})[_0xbd64('0x61')](function(_0x54379f){var _0x1b88aa;var _0xeaaf4d;_0x33a01c=_0x54379f||[];var _0x136a6d=[];if(_0x54379f){for(var _0x39fb65=0x0;_0x39fb65<_0x54379f['length'];_0x39fb65+=0x1){var _0x24793e=_0x54379f[_0x39fb65][_0xbd64('0x22')]({'plain':!![]});_0x1b88aa=squel[_0xbd64('0x77')]()['into']('cm_hopper_black')[_0xbd64('0x78')]([_0xbd64('0x66'),_0xbd64('0x67'),'ListId',_0xbd64('0x53'),'createdAt',_0xbd64('0x4c')],squel['select']()[_0xbd64('0x69')]('phone',_0xbd64('0x66'))[_0xbd64('0x69')]('id',_0xbd64('0x67'))[_0xbd64('0x69')](_0x24793e['CmListId'][_0xbd64('0x6c')](),_0xbd64('0x68'))[_0xbd64('0x69')](_0x2e0988[_0xbd64('0x3f')]['id'][_0xbd64('0x6c')](),_0xbd64('0x53'))[_0xbd64('0x69')](_0xbd64('0x79'),_0xbd64('0x4e'))[_0xbd64('0x69')](_0xbd64('0x79'),'updatedAt')[_0xbd64('0x73')](_0xbd64('0x6d'))['where']('deletedAt\x20IS\x20NULL')[_0xbd64('0x36')](_0xbd64('0x6f'),_0x24793e['CmListId'][_0xbd64('0x6c')]())[_0xbd64('0x36')](_0xbd64('0x70')))['toString']();_0x136a6d[_0xbd64('0x88')](db[_0xbd64('0x89')]['query'](_0x1b88aa));}return BPromise[_0xbd64('0x84')](_0x136a6d);}})[_0xbd64('0x20')](function(){return _0x33a01c;})[_0xbd64('0x20')](respondWithResult(_0x5e85b7,null))[_0xbd64('0x3e')](handleError(_0x5e85b7,null));};exports[_0xbd64('0x8a')]=function(_0x2e5437,_0x1d759c,_0x171d75){return db[_0xbd64('0x29')]['find']({'where':{'id':_0x2e5437['params']['id']}})[_0xbd64('0x20')](handleEntityNotFound(_0x1d759c,null))['then'](function(_0x2acfac){if(_0x2acfac){return _0x2acfac['removeBlackLists'](_0x2e5437[_0xbd64('0x2f')]['ids']);}})[_0xbd64('0x20')](function(_0x42f9f8){if(_0x42f9f8){return db['CmHopperBlack'][_0xbd64('0x21')]({'where':{'ListId':_0x2e5437[_0xbd64('0x2f')][_0xbd64('0x5f')],'CampaignId':_0x2e5437[_0xbd64('0x3f')]['id']}})[_0xbd64('0x20')](function(){return _0x42f9f8;});}})[_0xbd64('0x20')](respondWithStatusCode(_0x1d759c,null))[_0xbd64('0x3e')](handleError(_0x1d759c,null));};