[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 _0x96d9=['attributes','length','hasOwnProperty','nolimit','sort','where','filter','merge','type','VIRTUAL','options','includeAll','include','findAll','rows','catch','show','params','find','create','body','user','get','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','rawAttributes','createdAt','omit','updatedAt','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','update','getHoppers','findOne','order','CampaignId','CmHopper','getHopperHistories','CmHopperHistory','pick','getHopperFinals','CmHopperFinal','getHopperBlacks','CmHopperBlack','getLists','format','addLists','ids','spread','dialCheckDuplicateType','always','insert','into','cm_hopper','fromQuery','phone','scheduledAt','ContactId','select','field','CmListId','ListId','toString','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','COALESCE(calleridnum,\x27\x27)','cm_hopper_final','CampaignId\x20=\x20?','phone\x20NOT\x20IN\x20(?)','onlyIfOpen','NOW()','from','cm_contacts','cm_hopper_additional_phones','OrderBy','ci.item','cm_contact_has_items','h.ContactId\x20=\x20ci.CmContactId','h.ListId\x20=\x20?','h.CampaignId=?','push','sequelize','all','removeLists','getBlackLists','addBlackLists','YYYY-MM-DD\x20HH:mm:ss','removeBlackLists','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','path','sox','to-csv','ejs','fs-extra','lodash','squel','jsforce','desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','sendStatus','status','json','offset','undefined','limit','count','apply','reject','destroy','then','IvrCampaigns','UserProfileResource','end','error','stack','name','map','Campaign','fieldName','key','model','query','keys','filters','intersection','fields'];(function(_0xdc972f,_0x541dbe){var _0x4219bd=function(_0x114846){while(--_0x114846){_0xdc972f['push'](_0xdc972f['shift']());}};_0x4219bd(++_0x541dbe);}(_0x96d9,0xea));var _0x996d=function(_0x141c5a,_0x5c8655){_0x141c5a=_0x141c5a-0x0;var _0x5d465a=_0x96d9[_0x141c5a];return _0x5d465a;};'use strict';var emlformat=require(_0x996d('0x0'));var rimraf=require(_0x996d('0x1'));var zipdir=require(_0x996d('0x2'));var jsonpatch=require(_0x996d('0x3'));var rp=require(_0x996d('0x4'));var moment=require(_0x996d('0x5'));var BPromise=require(_0x996d('0x6'));var Mustache=require(_0x996d('0x7'));var util=require('util');var path=require(_0x996d('0x8'));var sox=require(_0x996d('0x9'));var csv=require(_0x996d('0xa'));var ejs=require(_0x996d('0xb'));var fs=require('fs');var fs_extra=require(_0x996d('0xc'));var _=require(_0x996d('0xd'));var squel=require(_0x996d('0xe'));var crypto=require('crypto');var jsforce=require(_0x996d('0xf'));var deskjs=require(_0x996d('0x10'));var toCsv=require(_0x996d('0xa'));var querystring=require(_0x996d('0x11'));var Papa=require(_0x996d('0x12'));var Redis=require('ioredis');var authService=require(_0x996d('0x13'));var qs=require(_0x996d('0x14'));var as=require(_0x996d('0x15'));var hardwareService=require(_0x996d('0x16'));var logger=require('../../config/logger')(_0x996d('0x17'));var utils=require(_0x996d('0x18'));var config=require('../../config/environment');var licenseUtil=require('../../config/license/util');var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x200f12,_0x2a585a){_0x2a585a=_0x2a585a||0xcc;return function(_0x54d85b){if(_0x54d85b){return _0x200f12[_0x996d('0x19')](_0x2a585a);}return _0x200f12[_0x996d('0x1a')](_0x2a585a)['end']();};}function respondWithResult(_0x2890fb,_0x269179){_0x269179=_0x269179||0xc8;return function(_0x18c2b8){if(_0x18c2b8){return _0x2890fb['status'](_0x269179)[_0x996d('0x1b')](_0x18c2b8);}};}function respondWithFilteredResult(_0x4c9568,_0x1da7b0){return function(_0xd8bcba){if(_0xd8bcba){var _0x281281=typeof _0x1da7b0[_0x996d('0x1c')]===_0x996d('0x1d')&&typeof _0x1da7b0[_0x996d('0x1e')]===_0x996d('0x1d');var _0x5a8b12=_0xd8bcba['count'];var _0x465c94=_0x281281?0x0:_0x1da7b0[_0x996d('0x1c')];var _0x33bf07=_0x281281?_0xd8bcba[_0x996d('0x1f')]:_0x1da7b0[_0x996d('0x1c')]+_0x1da7b0[_0x996d('0x1e')];var _0x1c2234;if(_0x33bf07>=_0x5a8b12){_0x33bf07=_0x5a8b12;_0x1c2234=0xc8;}else{_0x1c2234=0xce;}_0x4c9568[_0x996d('0x1a')](_0x1c2234);return _0x4c9568['set']('Content-Range',_0x465c94+'-'+_0x33bf07+'/'+_0x5a8b12)[_0x996d('0x1b')](_0xd8bcba);}return null;};}function patchUpdates(_0x21b00a){return function(_0x2da682){try{jsonpatch[_0x996d('0x20')](_0x2da682,_0x21b00a,!![]);}catch(_0x141bcb){return BPromise[_0x996d('0x21')](_0x141bcb);}return _0x2da682['save']();};}function saveUpdates(_0x2fbc32,_0x76a7e){return function(_0x379165){if(_0x379165){return _0x379165['update'](_0x2fbc32)['then'](function(_0x25d4c3){return _0x25d4c3;});}return null;};}function removeEntity(_0x42fae4,_0x53c4d9){return function(_0x2a9da1){if(_0x2a9da1){return _0x2a9da1[_0x996d('0x22')]()[_0x996d('0x23')](function(){var _0x42935d=_0x2a9da1['get']({'plain':!![]});var _0x534873=_0x996d('0x24');return db[_0x996d('0x25')]['destroy']({'where':{'type':_0x534873,'resourceId':_0x42935d['id']}})[_0x996d('0x23')](function(){return _0x2a9da1;});})['then'](function(){_0x42fae4[_0x996d('0x1a')](0xcc)[_0x996d('0x26')]();});}};}function handleEntityNotFound(_0x139399,_0x4419d0){return function(_0x29f1df){if(!_0x29f1df){_0x139399[_0x996d('0x19')](0x194);}return _0x29f1df;};}function handleError(_0x3c45be,_0x53123b){_0x53123b=_0x53123b||0x1f4;return function(_0xf93301){logger[_0x996d('0x27')](_0xf93301[_0x996d('0x28')]);if(_0xf93301[_0x996d('0x29')]){delete _0xf93301[_0x996d('0x29')];}_0x3c45be[_0x996d('0x1a')](_0x53123b)['send'](_0xf93301);};}exports['index']=function(_0x53cf8f,_0x220893){var _0x6b3221={},_0xf84d49={},_0x2ce7b7={'count':0x0,'rows':[]};var _0x1cf99e=_[_0x996d('0x2a')](db[_0x996d('0x2b')]['rawAttributes'],function(_0x58f595){return{'name':_0x58f595[_0x996d('0x2c')],'type':_0x58f595['type'][_0x996d('0x2d')]};});_0xf84d49[_0x996d('0x2e')]=_['map'](_0x1cf99e,_0x996d('0x29'));_0xf84d49[_0x996d('0x2f')]=_[_0x996d('0x30')](_0x53cf8f['query']);_0xf84d49[_0x996d('0x31')]=_[_0x996d('0x32')](_0xf84d49[_0x996d('0x2e')],_0xf84d49['query']);_0x6b3221['attributes']=_[_0x996d('0x32')](_0xf84d49[_0x996d('0x2e')],qs['fields'](_0x53cf8f[_0x996d('0x2f')][_0x996d('0x33')]));_0x6b3221[_0x996d('0x34')]=_0x6b3221[_0x996d('0x34')][_0x996d('0x35')]?_0x6b3221['attributes']:_0xf84d49[_0x996d('0x2e')];if(!_0x53cf8f[_0x996d('0x2f')][_0x996d('0x36')](_0x996d('0x37'))){_0x6b3221[_0x996d('0x1e')]=qs['limit'](_0x53cf8f[_0x996d('0x2f')][_0x996d('0x1e')]);_0x6b3221[_0x996d('0x1c')]=qs[_0x996d('0x1c')](_0x53cf8f[_0x996d('0x2f')]['offset']);}_0x6b3221['order']=qs['sort'](_0x53cf8f['query'][_0x996d('0x38')]);_0x6b3221[_0x996d('0x39')]=qs[_0x996d('0x31')](_['pick'](_0x53cf8f[_0x996d('0x2f')],_0xf84d49[_0x996d('0x31')]),_0x1cf99e);if(_0x53cf8f[_0x996d('0x2f')][_0x996d('0x3a')]){_0x6b3221[_0x996d('0x39')]=_[_0x996d('0x3b')](_0x6b3221[_0x996d('0x39')],{'$or':_[_0x996d('0x2a')](_0x1cf99e,function(_0x13ba9d){if(_0x13ba9d[_0x996d('0x3c')]!==_0x996d('0x3d')){var _0x3e08b={};_0x3e08b[_0x13ba9d['name']]={'$like':'%'+_0x53cf8f[_0x996d('0x2f')][_0x996d('0x3a')]+'%'};return _0x3e08b;}})});}_0x6b3221=_['merge']({},_0x6b3221,_0x53cf8f[_0x996d('0x3e')]);var _0x523d31={'where':_0x6b3221['where']};return db['Campaign']['count'](_0x523d31)[_0x996d('0x23')](function(_0x288f06){_0x2ce7b7['count']=_0x288f06;if(_0x53cf8f[_0x996d('0x2f')][_0x996d('0x3f')]){_0x6b3221[_0x996d('0x40')]=[{'all':!![]}];}return db[_0x996d('0x2b')][_0x996d('0x41')](_0x6b3221);})['then'](function(_0x113997){_0x2ce7b7[_0x996d('0x42')]=_0x113997;return _0x2ce7b7;})[_0x996d('0x23')](respondWithFilteredResult(_0x220893,_0x6b3221))[_0x996d('0x43')](handleError(_0x220893,null));};exports[_0x996d('0x44')]=function(_0x5dfba5,_0x57c975){var _0x3e4555={'raw':![],'where':{'id':_0x5dfba5[_0x996d('0x45')]['id']}},_0x906237={};_0x906237['model']=_[_0x996d('0x30')](db[_0x996d('0x2b')]['rawAttributes']);_0x906237['query']=_[_0x996d('0x30')](_0x5dfba5['query']);_0x906237[_0x996d('0x31')]=_[_0x996d('0x32')](_0x906237['model'],_0x906237[_0x996d('0x2f')]);_0x3e4555[_0x996d('0x34')]=_[_0x996d('0x32')](_0x906237[_0x996d('0x2e')],qs[_0x996d('0x33')](_0x5dfba5['query'][_0x996d('0x33')]));_0x3e4555['attributes']=_0x3e4555['attributes']['length']?_0x3e4555['attributes']:_0x906237[_0x996d('0x2e')];if(_0x5dfba5[_0x996d('0x2f')][_0x996d('0x3f')]){_0x3e4555['include']=[{'all':!![]}];}_0x3e4555=_['merge']({},_0x3e4555,_0x5dfba5[_0x996d('0x3e')]);return db[_0x996d('0x2b')][_0x996d('0x46')](_0x3e4555)[_0x996d('0x23')](handleEntityNotFound(_0x57c975,null))[_0x996d('0x23')](respondWithResult(_0x57c975,null))['catch'](handleError(_0x57c975,null));};exports[_0x996d('0x47')]=function(_0x23c8aa,_0xed150d){return db[_0x996d('0x2b')][_0x996d('0x47')](_0x23c8aa[_0x996d('0x48')],{})[_0x996d('0x23')](function(_0x4a5046){var _0x4aa0a3=_0x23c8aa[_0x996d('0x49')][_0x996d('0x4a')]({'plain':!![]});if(!_0x4aa0a3)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x4aa0a3['role']===_0x996d('0x49')){var _0x588979=_0x4a5046[_0x996d('0x4a')]({'plain':!![]});var _0xcd988b=_0x996d('0x24');return db[_0x996d('0x4b')]['find']({'where':{'name':_0xcd988b,'userProfileId':_0x4aa0a3[_0x996d('0x4c')]},'raw':!![]})['then'](function(_0x42926e){if(_0x42926e&&_0x42926e[_0x996d('0x4d')]===0x0){return db[_0x996d('0x25')][_0x996d('0x47')]({'name':_0x588979['name'],'resourceId':_0x588979['id'],'type':_0x42926e[_0x996d('0x29')],'sectionId':_0x42926e['id']},{})[_0x996d('0x23')](function(){return _0x4a5046;});}else{return _0x4a5046;}})[_0x996d('0x43')](function(_0x1107c1){logger[_0x996d('0x27')](_0x996d('0x4e'),_0x1107c1);throw _0x1107c1;});}return _0x4a5046;})[_0x996d('0x23')](respondWithResult(_0xed150d,0xc9))[_0x996d('0x43')](handleError(_0xed150d,null));};exports['clone']=function(_0x590549,_0x5096be){var _0x34466f={'where':{'id':_0x590549[_0x996d('0x45')]['id']}},_0x259690={};_0x259690[_0x996d('0x2e')]=_[_0x996d('0x30')](db['Campaign'][_0x996d('0x4f')]);_0x34466f[_0x996d('0x34')]=_[_0x996d('0x32')](_0x259690[_0x996d('0x2e')],qs[_0x996d('0x33')](_0x590549[_0x996d('0x2f')][_0x996d('0x33')]));_0x34466f[_0x996d('0x34')]=_0x34466f[_0x996d('0x34')][_0x996d('0x35')]?_0x34466f['attributes']:_0x259690[_0x996d('0x2e')];if(_0x590549[_0x996d('0x2f')][_0x996d('0x3f')]){_0x34466f['include']=[{'all':!![]}];}_0x34466f=_['merge']({},_0x34466f,_0x590549[_0x996d('0x3e')]);return db[_0x996d('0x2b')][_0x996d('0x46')](_0x34466f)['then'](handleEntityNotFound(_0x5096be,null))['then'](function(_0xc5119){if(_0xc5119){var _0xdac7f1=_0xc5119[_0x996d('0x4a')]({'plain':!![]});_0xdac7f1=qs['omit'](_0xdac7f1,['id',_0x996d('0x50'),'updatedAt']);_0x590549[_0x996d('0x48')]=_[_0x996d('0x51')](_0x590549[_0x996d('0x48')],['id',_0x996d('0x50'),_0x996d('0x52')]);return db[_0x996d('0x2b')][_0x996d('0x47')](_[_0x996d('0x3b')](_0xdac7f1,_0x590549[_0x996d('0x48')]),{'include':_0x590549['query']['includeAll']?[{'all':!![]}]:undefined})['then'](function(_0x1debd5){var _0x6739b=_0x590549[_0x996d('0x49')][_0x996d('0x4a')]({'plain':!![]});if(!_0x6739b)throw new Error(_0x996d('0x53'));if(_0x6739b[_0x996d('0x54')]===_0x996d('0x49')){var _0x3d1d4d=_0x1debd5['get']({'plain':!![]});var _0x3ef853=_0x996d('0x24');return db[_0x996d('0x4b')][_0x996d('0x46')]({'where':{'name':_0x3ef853,'userProfileId':_0x6739b[_0x996d('0x4c')]},'raw':!![]})['then'](function(_0x2babdc){if(_0x2babdc&&_0x2babdc['autoAssociation']===0x0){return db[_0x996d('0x25')][_0x996d('0x47')]({'name':_0x3d1d4d[_0x996d('0x29')],'resourceId':_0x3d1d4d['id'],'type':_0x2babdc['name'],'sectionId':_0x2babdc['id']},{})[_0x996d('0x23')](function(){return _0x1debd5;});}else{return _0x1debd5;}})[_0x996d('0x43')](function(_0x445feb){logger[_0x996d('0x27')](_0x996d('0x4e'),_0x445feb);throw _0x445feb;});}return _0x1debd5;});}})[_0x996d('0x23')](respondWithResult(_0x5096be,0xc9))[_0x996d('0x43')](handleError(_0x5096be,null));};exports[_0x996d('0x55')]=function(_0x3eb579,_0x44b7a5){if(_0x3eb579[_0x996d('0x48')]['id']){delete _0x3eb579[_0x996d('0x48')]['id'];}return db['Campaign'][_0x996d('0x46')]({'where':{'id':_0x3eb579[_0x996d('0x45')]['id']}})['then'](handleEntityNotFound(_0x44b7a5,null))[_0x996d('0x23')](saveUpdates(_0x3eb579[_0x996d('0x48')],null))[_0x996d('0x23')](respondWithResult(_0x44b7a5,null))[_0x996d('0x43')](handleError(_0x44b7a5,null));};exports['destroy']=function(_0x4df866,_0x5eae09){return db['Campaign']['find']({'where':{'id':_0x4df866['params']['id']}})[_0x996d('0x23')](handleEntityNotFound(_0x5eae09,null))['then'](removeEntity(_0x5eae09,null))[_0x996d('0x43')](handleError(_0x5eae09,null));};exports[_0x996d('0x56')]=function(_0x49a166,_0x140dc9,_0x4b7f87){var _0x31bf2a={'raw':!![],'where':{}};var _0x2a34c0={};var _0x51aa5f={'count':0x0,'rows':[]};return db[_0x996d('0x2b')][_0x996d('0x57')]({'where':{'id':_0x49a166[_0x996d('0x45')]['id']}})[_0x996d('0x23')](handleEntityNotFound(_0x140dc9,null))[_0x996d('0x23')](function(_0x35fae8){if(_0x35fae8){_0x2a34c0[_0x996d('0x2e')]=_[_0x996d('0x30')](db['CmHopper'][_0x996d('0x4f')]);_0x2a34c0[_0x996d('0x2f')]=_[_0x996d('0x30')](_0x49a166[_0x996d('0x2f')]);_0x2a34c0[_0x996d('0x31')]=_[_0x996d('0x32')](_0x2a34c0[_0x996d('0x2e')],_0x2a34c0[_0x996d('0x2f')]);_0x31bf2a['attributes']=_['intersection'](_0x2a34c0[_0x996d('0x2e')],qs['fields'](_0x49a166[_0x996d('0x2f')][_0x996d('0x33')]));_0x31bf2a[_0x996d('0x34')]=_0x31bf2a[_0x996d('0x34')][_0x996d('0x35')]?_0x31bf2a['attributes']:_0x2a34c0['model'];if(!_0x49a166[_0x996d('0x2f')][_0x996d('0x36')](_0x996d('0x37'))){_0x31bf2a[_0x996d('0x1e')]=qs[_0x996d('0x1e')](_0x49a166[_0x996d('0x2f')]['limit']);_0x31bf2a['offset']=qs['offset'](_0x49a166['query'][_0x996d('0x1c')]);}_0x31bf2a[_0x996d('0x58')]=qs['sort'](_0x49a166['query'][_0x996d('0x38')]);_0x31bf2a[_0x996d('0x39')]=qs[_0x996d('0x31')](_['pick'](_0x49a166[_0x996d('0x2f')],_0x2a34c0['filters']));_0x31bf2a[_0x996d('0x39')][_0x996d('0x59')]=_0x35fae8['id'];if(_0x49a166[_0x996d('0x2f')][_0x996d('0x3a')]){_0x31bf2a[_0x996d('0x39')]=_[_0x996d('0x3b')](_0x31bf2a[_0x996d('0x39')],{'$or':_[_0x996d('0x2a')](_0x31bf2a[_0x996d('0x34')],function(_0x53d4b5){var _0x5a6868={};_0x5a6868[_0x53d4b5]={'$like':'%'+_0x49a166[_0x996d('0x2f')][_0x996d('0x3a')]+'%'};return _0x5a6868;})});}_0x31bf2a=_['merge']({},_0x31bf2a,_0x49a166[_0x996d('0x3e')]);return db[_0x996d('0x5a')]['count']({'where':_0x31bf2a[_0x996d('0x39')]})[_0x996d('0x23')](function(_0x36e9c7){_0x51aa5f['count']=_0x36e9c7;if(_0x49a166['query'][_0x996d('0x3f')]){_0x31bf2a[_0x996d('0x40')]=[{'all':!![]}];}return db['CmHopper'][_0x996d('0x41')](_0x31bf2a);})[_0x996d('0x23')](function(_0x5b013a){_0x51aa5f[_0x996d('0x42')]=_0x5b013a;return _0x51aa5f;});}})[_0x996d('0x23')](respondWithFilteredResult(_0x140dc9,_0x31bf2a))[_0x996d('0x43')](handleError(_0x140dc9,null));};exports[_0x996d('0x5b')]=function(_0x226a4e,_0x5abcab,_0x426e72){var _0x3d45dd={'raw':!![],'where':{}};var _0x3be48e={};var _0x46c79e={'count':0x0,'rows':[]};return db[_0x996d('0x2b')][_0x996d('0x57')]({'where':{'id':_0x226a4e[_0x996d('0x45')]['id']}})[_0x996d('0x23')](handleEntityNotFound(_0x5abcab,null))[_0x996d('0x23')](function(_0x584951){if(_0x584951){_0x3be48e['model']=_[_0x996d('0x30')](db[_0x996d('0x5c')][_0x996d('0x4f')]);_0x3be48e[_0x996d('0x2f')]=_[_0x996d('0x30')](_0x226a4e[_0x996d('0x2f')]);_0x3be48e[_0x996d('0x31')]=_[_0x996d('0x32')](_0x3be48e[_0x996d('0x2e')],_0x3be48e[_0x996d('0x2f')]);_0x3d45dd['attributes']=_[_0x996d('0x32')](_0x3be48e['model'],qs[_0x996d('0x33')](_0x226a4e[_0x996d('0x2f')][_0x996d('0x33')]));_0x3d45dd[_0x996d('0x34')]=_0x3d45dd[_0x996d('0x34')]['length']?_0x3d45dd['attributes']:_0x3be48e[_0x996d('0x2e')];if(!_0x226a4e[_0x996d('0x2f')][_0x996d('0x36')]('nolimit')){_0x3d45dd[_0x996d('0x1e')]=qs['limit'](_0x226a4e['query'][_0x996d('0x1e')]);_0x3d45dd[_0x996d('0x1c')]=qs['offset'](_0x226a4e[_0x996d('0x2f')][_0x996d('0x1c')]);}_0x3d45dd[_0x996d('0x58')]=qs[_0x996d('0x38')](_0x226a4e[_0x996d('0x2f')]['sort']);_0x3d45dd['where']=qs[_0x996d('0x31')](_[_0x996d('0x5d')](_0x226a4e[_0x996d('0x2f')],_0x3be48e[_0x996d('0x31')]));_0x3d45dd['where'][_0x996d('0x59')]=_0x584951['id'];if(_0x226a4e[_0x996d('0x2f')][_0x996d('0x3a')]){_0x3d45dd[_0x996d('0x39')]=_['merge'](_0x3d45dd[_0x996d('0x39')],{'$or':_[_0x996d('0x2a')](_0x3d45dd['attributes'],function(_0x369d3f){var _0x4734fd={};_0x4734fd[_0x369d3f]={'$like':'%'+_0x226a4e['query'][_0x996d('0x3a')]+'%'};return _0x4734fd;})});}_0x3d45dd=_[_0x996d('0x3b')]({},_0x3d45dd,_0x226a4e[_0x996d('0x3e')]);return db[_0x996d('0x5c')][_0x996d('0x1f')]({'where':_0x3d45dd['where']})[_0x996d('0x23')](function(_0x47f38f){_0x46c79e['count']=_0x47f38f;if(_0x226a4e[_0x996d('0x2f')][_0x996d('0x3f')]){_0x3d45dd['include']=[{'all':!![]}];}return db[_0x996d('0x5c')]['findAll'](_0x3d45dd);})[_0x996d('0x23')](function(_0x476ce8){_0x46c79e[_0x996d('0x42')]=_0x476ce8;return _0x46c79e;});}})[_0x996d('0x23')](respondWithFilteredResult(_0x5abcab,_0x3d45dd))[_0x996d('0x43')](handleError(_0x5abcab,null));};exports[_0x996d('0x5e')]=function(_0x4b9b84,_0x5062e6,_0x5b4d91){var _0x249d5e={'raw':!![],'where':{}};var _0x2d5838={};var _0x38238d={'count':0x0,'rows':[]};return db[_0x996d('0x2b')][_0x996d('0x57')]({'where':{'id':_0x4b9b84[_0x996d('0x45')]['id']}})[_0x996d('0x23')](handleEntityNotFound(_0x5062e6,null))['then'](function(_0x3922f8){if(_0x3922f8){_0x2d5838[_0x996d('0x2e')]=_['keys'](db[_0x996d('0x5f')]['rawAttributes']);_0x2d5838[_0x996d('0x2f')]=_[_0x996d('0x30')](_0x4b9b84[_0x996d('0x2f')]);_0x2d5838[_0x996d('0x31')]=_[_0x996d('0x32')](_0x2d5838[_0x996d('0x2e')],_0x2d5838[_0x996d('0x2f')]);_0x249d5e[_0x996d('0x34')]=_[_0x996d('0x32')](_0x2d5838[_0x996d('0x2e')],qs[_0x996d('0x33')](_0x4b9b84[_0x996d('0x2f')]['fields']));_0x249d5e[_0x996d('0x34')]=_0x249d5e['attributes']['length']?_0x249d5e[_0x996d('0x34')]:_0x2d5838['model'];if(!_0x4b9b84['query']['hasOwnProperty'](_0x996d('0x37'))){_0x249d5e[_0x996d('0x1e')]=qs[_0x996d('0x1e')](_0x4b9b84['query'][_0x996d('0x1e')]);_0x249d5e[_0x996d('0x1c')]=qs[_0x996d('0x1c')](_0x4b9b84['query'][_0x996d('0x1c')]);}_0x249d5e['order']=qs['sort'](_0x4b9b84[_0x996d('0x2f')][_0x996d('0x38')]);_0x249d5e[_0x996d('0x39')]=qs[_0x996d('0x31')](_['pick'](_0x4b9b84['query'],_0x2d5838[_0x996d('0x31')]));_0x249d5e[_0x996d('0x39')][_0x996d('0x59')]=_0x3922f8['id'];if(_0x4b9b84[_0x996d('0x2f')][_0x996d('0x3a')]){_0x249d5e[_0x996d('0x39')]=_['merge'](_0x249d5e[_0x996d('0x39')],{'$or':_[_0x996d('0x2a')](_0x249d5e['attributes'],function(_0xeea435){var _0x34ebb0={};_0x34ebb0[_0xeea435]={'$like':'%'+_0x4b9b84[_0x996d('0x2f')][_0x996d('0x3a')]+'%'};return _0x34ebb0;})});}_0x249d5e=_['merge']({},_0x249d5e,_0x4b9b84[_0x996d('0x3e')]);return db[_0x996d('0x5f')][_0x996d('0x1f')]({'where':_0x249d5e[_0x996d('0x39')]})[_0x996d('0x23')](function(_0x51ad26){_0x38238d[_0x996d('0x1f')]=_0x51ad26;if(_0x4b9b84[_0x996d('0x2f')][_0x996d('0x3f')]){_0x249d5e['include']=[{'all':!![]}];}return db[_0x996d('0x5f')][_0x996d('0x41')](_0x249d5e);})[_0x996d('0x23')](function(_0x29ac71){_0x38238d[_0x996d('0x42')]=_0x29ac71;return _0x38238d;});}})[_0x996d('0x23')](respondWithFilteredResult(_0x5062e6,_0x249d5e))[_0x996d('0x43')](handleError(_0x5062e6,null));};exports[_0x996d('0x60')]=function(_0x5318f3,_0x17cd8e,_0x345505){var _0x3e2d06={'raw':!![],'where':{}};var _0x288a50={};var _0x277628={'count':0x0,'rows':[]};return db[_0x996d('0x2b')]['findOne']({'where':{'id':_0x5318f3[_0x996d('0x45')]['id']}})[_0x996d('0x23')](handleEntityNotFound(_0x17cd8e,null))['then'](function(_0x4c2088){if(_0x4c2088){_0x288a50[_0x996d('0x2e')]=_[_0x996d('0x30')](db[_0x996d('0x61')][_0x996d('0x4f')]);_0x288a50[_0x996d('0x2f')]=_[_0x996d('0x30')](_0x5318f3[_0x996d('0x2f')]);_0x288a50[_0x996d('0x31')]=_[_0x996d('0x32')](_0x288a50[_0x996d('0x2e')],_0x288a50[_0x996d('0x2f')]);_0x3e2d06[_0x996d('0x34')]=_[_0x996d('0x32')](_0x288a50[_0x996d('0x2e')],qs[_0x996d('0x33')](_0x5318f3[_0x996d('0x2f')][_0x996d('0x33')]));_0x3e2d06[_0x996d('0x34')]=_0x3e2d06['attributes'][_0x996d('0x35')]?_0x3e2d06[_0x996d('0x34')]:_0x288a50[_0x996d('0x2e')];if(!_0x5318f3[_0x996d('0x2f')][_0x996d('0x36')](_0x996d('0x37'))){_0x3e2d06['limit']=qs[_0x996d('0x1e')](_0x5318f3[_0x996d('0x2f')]['limit']);_0x3e2d06[_0x996d('0x1c')]=qs[_0x996d('0x1c')](_0x5318f3['query'][_0x996d('0x1c')]);}_0x3e2d06['order']=qs[_0x996d('0x38')](_0x5318f3[_0x996d('0x2f')]['sort']);_0x3e2d06[_0x996d('0x39')]=qs[_0x996d('0x31')](_[_0x996d('0x5d')](_0x5318f3['query'],_0x288a50[_0x996d('0x31')]));_0x3e2d06[_0x996d('0x39')]['CampaignId']=_0x4c2088['id'];if(_0x5318f3[_0x996d('0x2f')][_0x996d('0x3a')]){_0x3e2d06['where']=_['merge'](_0x3e2d06[_0x996d('0x39')],{'$or':_[_0x996d('0x2a')](_0x3e2d06['attributes'],function(_0x5c2ce4){var _0x1ccbf6={};_0x1ccbf6[_0x5c2ce4]={'$like':'%'+_0x5318f3[_0x996d('0x2f')][_0x996d('0x3a')]+'%'};return _0x1ccbf6;})});}_0x3e2d06=_[_0x996d('0x3b')]({},_0x3e2d06,_0x5318f3[_0x996d('0x3e')]);return db['CmHopperBlack'][_0x996d('0x1f')]({'where':_0x3e2d06[_0x996d('0x39')]})[_0x996d('0x23')](function(_0x3d6e8d){_0x277628[_0x996d('0x1f')]=_0x3d6e8d;if(_0x5318f3[_0x996d('0x2f')][_0x996d('0x3f')]){_0x3e2d06[_0x996d('0x40')]=[{'all':!![]}];}return db[_0x996d('0x61')]['findAll'](_0x3e2d06);})['then'](function(_0x2312bd){_0x277628[_0x996d('0x42')]=_0x2312bd;return _0x277628;});}})[_0x996d('0x23')](respondWithFilteredResult(_0x17cd8e,_0x3e2d06))[_0x996d('0x43')](handleError(_0x17cd8e,null));};exports[_0x996d('0x62')]=function(_0x4bd37c,_0x300095,_0xb687f5){var _0x450088={};var _0x2026a8={};var _0x17b359;var _0x19db11;return db[_0x996d('0x2b')]['findOne']({'where':{'id':_0x4bd37c[_0x996d('0x45')]['id']}})[_0x996d('0x23')](handleEntityNotFound(_0x300095,null))[_0x996d('0x23')](function(_0x1f683f){if(_0x1f683f){_0x17b359=_0x1f683f;_0x2026a8['model']=_['keys'](db['CmList']['rawAttributes']);_0x2026a8['query']=_[_0x996d('0x30')](_0x4bd37c['query']);_0x2026a8[_0x996d('0x31')]=_[_0x996d('0x32')](_0x2026a8['model'],_0x2026a8[_0x996d('0x2f')]);_0x450088[_0x996d('0x34')]=_['intersection'](_0x2026a8[_0x996d('0x2e')],qs[_0x996d('0x33')](_0x4bd37c[_0x996d('0x2f')][_0x996d('0x33')]));_0x450088['attributes']=_0x450088[_0x996d('0x34')][_0x996d('0x35')]?_0x450088[_0x996d('0x34')]:_0x2026a8[_0x996d('0x2e')];_0x450088[_0x996d('0x58')]=qs[_0x996d('0x38')](_0x4bd37c[_0x996d('0x2f')]['sort']);_0x450088['where']=qs['filters'](_[_0x996d('0x5d')](_0x4bd37c[_0x996d('0x2f')],_0x2026a8[_0x996d('0x31')]));if(_0x4bd37c['query'][_0x996d('0x3a')]){_0x450088['where']=_[_0x996d('0x3b')](_0x450088[_0x996d('0x39')],{'$or':_[_0x996d('0x2a')](_0x450088['attributes'],function(_0x716370){var _0x3ab056={};_0x3ab056[_0x716370]={'$like':'%'+_0x4bd37c[_0x996d('0x2f')][_0x996d('0x3a')]+'%'};return _0x3ab056;})});}_0x450088=_['merge']({},_0x450088,_0x4bd37c[_0x996d('0x3e')]);return _0x17b359[_0x996d('0x62')](_0x450088);}})[_0x996d('0x23')](function(_0x1f8537){if(_0x1f8537){_0x19db11=_0x1f8537['length'];if(!_0x4bd37c['query'][_0x996d('0x36')](_0x996d('0x37'))){_0x450088['limit']=qs[_0x996d('0x1e')](_0x4bd37c[_0x996d('0x2f')][_0x996d('0x1e')]);_0x450088[_0x996d('0x1c')]=qs[_0x996d('0x1c')](_0x4bd37c[_0x996d('0x2f')][_0x996d('0x1c')]);}return _0x17b359[_0x996d('0x62')](_0x450088);}})[_0x996d('0x23')](function(_0x7388f3){if(_0x7388f3){return _0x7388f3?{'count':_0x19db11,'rows':_0x7388f3}:null;}})[_0x996d('0x23')](respondWithResult(_0x300095,null))['catch'](handleError(_0x300095,null));};exports['addLists']=function(_0x283aae,_0x37b411,_0x5c17c6){var _0x48dd4c,_0x7bb8e8;var _0xd29d6e=[];var _0x4f9fb7=moment()[_0x996d('0x63')]('YYYY-MM-DD\x20HH:mm:ss');return db['Campaign'][_0x996d('0x46')]({'where':{'id':_0x283aae['params']['id']}})['then'](handleEntityNotFound(_0x37b411,null))[_0x996d('0x23')](function(_0x83547){if(_0x83547){_0x7bb8e8=_0x83547;return _0x83547[_0x996d('0x64')](_0x283aae[_0x996d('0x48')][_0x996d('0x65')],_[_0x996d('0x51')](_0x283aae[_0x996d('0x48')],[_0x996d('0x65'),'id'])||{});}return null;})[_0x996d('0x66')](function(_0x492c32){var _0x47b394;var _0xd8f8d0;_0x48dd4c=_0x492c32||[];var _0x292b3c=[];if(_0x492c32){for(var _0x1de50a=0x0;_0x1de50a<_0x492c32[_0x996d('0x35')];_0x1de50a+=0x1){var _0x697ed6=_0x492c32[_0x1de50a][_0x996d('0x4a')]({'plain':!![]});_0x7bb8e8[_0x996d('0x67')]=_0x283aae[_0x996d('0x48')][_0x996d('0x67')]?_0x283aae[_0x996d('0x48')][_0x996d('0x67')]:_0x7bb8e8['dialCheckDuplicateType'];switch(_0x7bb8e8[_0x996d('0x67')]){case _0x996d('0x68'):_0x47b394=squel[_0x996d('0x69')]()[_0x996d('0x6a')](_0x996d('0x6b'))[_0x996d('0x6c')]([_0x996d('0x6d'),_0x996d('0x6e'),_0x996d('0x6f'),'ListId',_0x996d('0x59'),_0x996d('0x50'),'updatedAt'],squel[_0x996d('0x70')]()[_0x996d('0x71')](_0x996d('0x6d'),_0x996d('0x6d'))[_0x996d('0x71')]('NOW()',_0x996d('0x6e'))['field']('id',_0x996d('0x6f'))['field'](_0x697ed6[_0x996d('0x72')]['toString'](),_0x996d('0x73'))[_0x996d('0x71')](_0x283aae[_0x996d('0x45')]['id'][_0x996d('0x74')](),_0x996d('0x59'))[_0x996d('0x71')]('\x27'+_0x4f9fb7+'\x27',_0x996d('0x50'))[_0x996d('0x71')]('\x27'+_0x4f9fb7+'\x27','updatedAt')['from']('cm_contacts')[_0x996d('0x39')](_0x996d('0x75'))['where'](_0x996d('0x76'),_0x697ed6[_0x996d('0x72')][_0x996d('0x74')]())[_0x996d('0x39')](_0x996d('0x77'))[_0x996d('0x39')]('phone\x20NOT\x20IN\x20(?)',squel[_0x996d('0x70')]()[_0x996d('0x71')](_0x996d('0x78'))['from'](_0x996d('0x79'))['where'](_0x996d('0x7a'),_0x283aae[_0x996d('0x45')]['id'][_0x996d('0x74')]()))[_0x996d('0x39')](_0x996d('0x7b'),squel[_0x996d('0x70')]()[_0x996d('0x71')]('COALESCE(phone,\x27\x27)')['from'](_0x996d('0x6b'))[_0x996d('0x39')](_0x996d('0x7a'),_0x283aae[_0x996d('0x45')]['id'][_0x996d('0x74')]())))[_0x996d('0x74')]();break;case _0x996d('0x7c'):_0x47b394=squel[_0x996d('0x69')]()[_0x996d('0x6a')](_0x996d('0x6b'))['fromQuery'](['phone','scheduledAt','ContactId',_0x996d('0x73'),_0x996d('0x59'),_0x996d('0x50'),_0x996d('0x52')],squel[_0x996d('0x70')]()[_0x996d('0x71')](_0x996d('0x6d'),'phone')[_0x996d('0x71')](_0x996d('0x7d'),_0x996d('0x6e'))[_0x996d('0x71')]('id','ContactId')[_0x996d('0x71')](_0x697ed6[_0x996d('0x72')][_0x996d('0x74')](),_0x996d('0x73'))[_0x996d('0x71')](_0x283aae[_0x996d('0x45')]['id'][_0x996d('0x74')](),_0x996d('0x59'))[_0x996d('0x71')]('\x27'+_0x4f9fb7+'\x27',_0x996d('0x50'))[_0x996d('0x71')]('\x27'+_0x4f9fb7+'\x27',_0x996d('0x52'))[_0x996d('0x7e')](_0x996d('0x7f'))[_0x996d('0x39')](_0x996d('0x75'))[_0x996d('0x39')]('ListId\x20=\x20?',_0x697ed6[_0x996d('0x72')][_0x996d('0x74')]())['where'](_0x996d('0x77'))[_0x996d('0x39')](_0x996d('0x7b'),squel['select']()['field']('COALESCE(phone,\x27\x27)')[_0x996d('0x7e')](_0x996d('0x6b'))['where'](_0x996d('0x7a'),_0x283aae[_0x996d('0x45')]['id'][_0x996d('0x74')]())))[_0x996d('0x74')]();break;default:_0x47b394=squel[_0x996d('0x69')]()['into'](_0x996d('0x6b'))['fromQuery']([_0x996d('0x6d'),_0x996d('0x6e'),_0x996d('0x6f'),_0x996d('0x73'),_0x996d('0x59'),_0x996d('0x50'),_0x996d('0x52')],squel[_0x996d('0x70')]()['field'](_0x996d('0x6d'),_0x996d('0x6d'))[_0x996d('0x71')](_0x996d('0x7d'),_0x996d('0x6e'))[_0x996d('0x71')]('id',_0x996d('0x6f'))[_0x996d('0x71')](_0x697ed6[_0x996d('0x72')]['toString'](),_0x996d('0x73'))[_0x996d('0x71')](_0x283aae[_0x996d('0x45')]['id']['toString'](),'CampaignId')['field']('\x27'+_0x4f9fb7+'\x27',_0x996d('0x50'))[_0x996d('0x71')]('\x27'+_0x4f9fb7+'\x27',_0x996d('0x52'))['from'](_0x996d('0x7f'))[_0x996d('0x39')](_0x996d('0x75'))[_0x996d('0x39')](_0x996d('0x76'),_0x697ed6[_0x996d('0x72')][_0x996d('0x74')]())[_0x996d('0x39')]('phone\x20IS\x20NOT\x20NULL'))[_0x996d('0x74')]();}_0xd8f8d0=squel['insert']()[_0x996d('0x6a')](_0x996d('0x80'))[_0x996d('0x6c')](['cmHopperId',_0x996d('0x6e'),_0x996d('0x6d'),_0x996d('0x81'),_0x996d('0x50'),_0x996d('0x52')],squel['select']()[_0x996d('0x71')]('h.id','id')[_0x996d('0x71')](_0x996d('0x7d'),'scheduledAt')[_0x996d('0x71')](_0x996d('0x82'),_0x996d('0x6d'))[_0x996d('0x71')]('ci.OrderBY','OrderBy')['field']('\x27'+_0x4f9fb7+'\x27','createdAt')[_0x996d('0x71')]('\x27'+_0x4f9fb7+'\x27','updatedAt')[_0x996d('0x7e')](_0x996d('0x83'),'ci')['join']('cm_hopper','h',_0x996d('0x84'))['where'](_0x996d('0x85'),_0x697ed6[_0x996d('0x72')][_0x996d('0x74')]())[_0x996d('0x39')](_0x996d('0x86'),_0x283aae[_0x996d('0x45')]['id']['toString']())[_0x996d('0x39')]('h.createdAt\x20=\x20?',_0x4f9fb7))['toString']();_0x292b3c[_0x996d('0x87')](db['sequelize'][_0x996d('0x2f')](_0x47b394));_0xd29d6e['push'](db[_0x996d('0x88')][_0x996d('0x2f')](_0xd8f8d0));}return BPromise[_0x996d('0x89')](_0x292b3c);}})['then'](function(){return BPromise[_0x996d('0x89')](_0xd29d6e);})[_0x996d('0x23')](function(){return _0x48dd4c;})['then'](respondWithResult(_0x37b411,null))['catch'](handleError(_0x37b411,null));};exports[_0x996d('0x8a')]=function(_0x2a193a,_0x4d5cdd,_0x405b0f){return db[_0x996d('0x2b')][_0x996d('0x46')]({'where':{'id':_0x2a193a[_0x996d('0x45')]['id']}})['then'](handleEntityNotFound(_0x4d5cdd,null))[_0x996d('0x23')](function(_0x5144bb){if(_0x5144bb){return _0x5144bb[_0x996d('0x8a')](_0x2a193a[_0x996d('0x2f')][_0x996d('0x65')]);}})[_0x996d('0x23')](function(_0x53f50f){if(_0x53f50f){return db[_0x996d('0x5a')]['destroy']({'where':{'ListId':_0x2a193a[_0x996d('0x2f')]['ids'],'CampaignId':_0x2a193a[_0x996d('0x45')]['id']}})[_0x996d('0x23')](function(){return _0x53f50f;});}})[_0x996d('0x23')](respondWithStatusCode(_0x4d5cdd,null))['catch'](handleError(_0x4d5cdd,null));};exports[_0x996d('0x8b')]=function(_0x36230b,_0x16c2df,_0x523739){var _0x41c540={};var _0x330cf3={};var _0x52ac37;var _0x35923c;return db[_0x996d('0x2b')][_0x996d('0x57')]({'where':{'id':_0x36230b[_0x996d('0x45')]['id']}})['then'](handleEntityNotFound(_0x16c2df,null))[_0x996d('0x23')](function(_0xdaf65d){if(_0xdaf65d){_0x52ac37=_0xdaf65d;_0x330cf3[_0x996d('0x2e')]=_['keys'](db['CmList'][_0x996d('0x4f')]);_0x330cf3[_0x996d('0x2f')]=_[_0x996d('0x30')](_0x36230b[_0x996d('0x2f')]);_0x330cf3[_0x996d('0x31')]=_[_0x996d('0x32')](_0x330cf3[_0x996d('0x2e')],_0x330cf3['query']);_0x41c540['attributes']=_[_0x996d('0x32')](_0x330cf3['model'],qs[_0x996d('0x33')](_0x36230b['query']['fields']));_0x41c540[_0x996d('0x34')]=_0x41c540[_0x996d('0x34')][_0x996d('0x35')]?_0x41c540[_0x996d('0x34')]:_0x330cf3[_0x996d('0x2e')];_0x41c540[_0x996d('0x58')]=qs['sort'](_0x36230b[_0x996d('0x2f')][_0x996d('0x38')]);_0x41c540[_0x996d('0x39')]=qs[_0x996d('0x31')](_[_0x996d('0x5d')](_0x36230b[_0x996d('0x2f')],_0x330cf3[_0x996d('0x31')]));if(_0x36230b['query'][_0x996d('0x3a')]){_0x41c540['where']=_[_0x996d('0x3b')](_0x41c540['where'],{'$or':_[_0x996d('0x2a')](_0x41c540[_0x996d('0x34')],function(_0x344944){var _0x558851={};_0x558851[_0x344944]={'$like':'%'+_0x36230b[_0x996d('0x2f')]['filter']+'%'};return _0x558851;})});}_0x41c540=_[_0x996d('0x3b')]({},_0x41c540,_0x36230b[_0x996d('0x3e')]);return _0x52ac37[_0x996d('0x8b')](_0x41c540);}})[_0x996d('0x23')](function(_0x2a1718){if(_0x2a1718){_0x35923c=_0x2a1718[_0x996d('0x35')];if(!_0x36230b['query'][_0x996d('0x36')](_0x996d('0x37'))){_0x41c540['limit']=qs['limit'](_0x36230b[_0x996d('0x2f')][_0x996d('0x1e')]);_0x41c540[_0x996d('0x1c')]=qs[_0x996d('0x1c')](_0x36230b['query'][_0x996d('0x1c')]);}return _0x52ac37['getBlackLists'](_0x41c540);}})['then'](function(_0x4e3d2d){if(_0x4e3d2d){return _0x4e3d2d?{'count':_0x35923c,'rows':_0x4e3d2d}:null;}})['then'](respondWithResult(_0x16c2df,null))['catch'](handleError(_0x16c2df,null));};exports[_0x996d('0x8c')]=function(_0x582038,_0x33a860,_0xf44c5a){var _0x4f5854,_0x5f07d5;var _0x5689aa=[];var _0x3beb24=moment()[_0x996d('0x63')](_0x996d('0x8d'));return db['Campaign'][_0x996d('0x46')]({'where':{'id':_0x582038[_0x996d('0x45')]['id']}})[_0x996d('0x23')](handleEntityNotFound(_0x33a860,null))['then'](function(_0x1ba7b5){if(_0x1ba7b5){_0x5f07d5=_0x1ba7b5;return _0x1ba7b5[_0x996d('0x8c')](_0x582038[_0x996d('0x48')]['ids'],_[_0x996d('0x51')](_0x582038[_0x996d('0x48')],['ids','id'])||{});}return null;})['spread'](function(_0x17dcc6){var _0x45f39e;var _0x3c08b3;_0x4f5854=_0x17dcc6||[];var _0x47239a=[];if(_0x17dcc6){for(var _0x301bb6=0x0;_0x301bb6<_0x17dcc6[_0x996d('0x35')];_0x301bb6+=0x1){var _0x2c3eef=_0x17dcc6[_0x301bb6][_0x996d('0x4a')]({'plain':!![]});_0x45f39e=squel[_0x996d('0x69')]()[_0x996d('0x6a')]('cm_hopper_black')[_0x996d('0x6c')]([_0x996d('0x6d'),_0x996d('0x6f'),'ListId',_0x996d('0x59'),'createdAt','updatedAt'],squel['select']()[_0x996d('0x71')]('phone',_0x996d('0x6d'))[_0x996d('0x71')]('id',_0x996d('0x6f'))[_0x996d('0x71')](_0x2c3eef[_0x996d('0x72')][_0x996d('0x74')](),_0x996d('0x73'))['field'](_0x582038[_0x996d('0x45')]['id'][_0x996d('0x74')](),_0x996d('0x59'))[_0x996d('0x71')](_0x996d('0x7d'),_0x996d('0x50'))[_0x996d('0x71')]('NOW()',_0x996d('0x52'))[_0x996d('0x7e')](_0x996d('0x7f'))[_0x996d('0x39')](_0x996d('0x75'))['where'](_0x996d('0x76'),_0x2c3eef[_0x996d('0x72')][_0x996d('0x74')]())[_0x996d('0x39')]('phone\x20IS\x20NOT\x20NULL'))[_0x996d('0x74')]();_0x47239a[_0x996d('0x87')](db[_0x996d('0x88')][_0x996d('0x2f')](_0x45f39e));}return BPromise[_0x996d('0x89')](_0x47239a);}})[_0x996d('0x23')](function(){return _0x4f5854;})[_0x996d('0x23')](respondWithResult(_0x33a860,null))['catch'](handleError(_0x33a860,null));};exports['removeBlackLists']=function(_0x57b967,_0x57e2df,_0x5cbb04){return db[_0x996d('0x2b')][_0x996d('0x46')]({'where':{'id':_0x57b967['params']['id']}})[_0x996d('0x23')](handleEntityNotFound(_0x57e2df,null))['then'](function(_0x3db19f){if(_0x3db19f){return _0x3db19f[_0x996d('0x8e')](_0x57b967[_0x996d('0x2f')]['ids']);}})[_0x996d('0x23')](function(_0x10eb82){if(_0x10eb82){return db[_0x996d('0x61')][_0x996d('0x22')]({'where':{'ListId':_0x57b967[_0x996d('0x2f')][_0x996d('0x65')],'CampaignId':_0x57b967['params']['id']}})['then'](function(){return _0x10eb82;});}})[_0x996d('0x23')](respondWithStatusCode(_0x57e2df,null))['catch'](handleError(_0x57e2df,null));};