[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 _0x0427=['insert','into','ContactId','NOW()','cm_contacts','CampaignId\x20=\x20?','cm_hopper_additional_phones','cmHopperId','ci.OrderBY','cm_contact_has_items','join','h.ContactId\x20=\x20ci.CmContactId','h.CampaignId=?','h.createdAt\x20=\x20?','push','sequelize','all','removeLists','getBlackLists','addBlackLists','spread','cm_hopper_black','removeBlackLists','zip-dir','fast-json-patch','moment','bluebird','mustache','util','path','sox','to-csv','fs-extra','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','../../components/auth/service','api','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','undefined','count','offset','limit','set','reject','save','then','destroy','get','UserProfileResource','error','stack','name','send','map','Campaign','fieldName','type','model','query','keys','filters','intersection','fields','attributes','hasOwnProperty','nolimit','sort','pick','filter','where','merge','VIRTUAL','options','includeAll','include','catch','show','params','length','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','IvrCampaigns','UserProfileSection','find','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','rawAttributes','omit','createdAt','updatedAt','update','getHoppers','CmHopper','order','CampaignId','rows','getHopperHistories','findOne','CmHopperHistory','findAll','getHopperFinals','CmHopperFinal','getHopperBlacks','CmHopperBlack','CmList','getLists','addLists','format','YYYY-MM-DD\x20HH:mm:ss','ids','dialCheckDuplicateType','always','cm_hopper','fromQuery','ListId','select','field','phone','scheduledAt','toString','from','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','CmListId','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','COALESCE(calleridnum,\x27\x27)','COALESCE(phone,\x27\x27)'];(function(_0x34843e,_0x4c4224){var _0x598f7f=function(_0x12a44c){while(--_0x12a44c){_0x34843e['push'](_0x34843e['shift']());}};_0x598f7f(++_0x4c4224);}(_0x0427,0x137));var _0x7042=function(_0x3fb462,_0x5ae278){_0x3fb462=_0x3fb462-0x0;var _0x1b3ebb=_0x0427[_0x3fb462];return _0x1b3ebb;};'use strict';var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require(_0x7042('0x0'));var jsonpatch=require(_0x7042('0x1'));var rp=require('request-promise');var moment=require(_0x7042('0x2'));var BPromise=require(_0x7042('0x3'));var Mustache=require(_0x7042('0x4'));var util=require(_0x7042('0x5'));var path=require(_0x7042('0x6'));var sox=require(_0x7042('0x7'));var csv=require(_0x7042('0x8'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x7042('0x9'));var _=require(_0x7042('0xa'));var squel=require(_0x7042('0xb'));var crypto=require(_0x7042('0xc'));var jsforce=require(_0x7042('0xd'));var deskjs=require(_0x7042('0xe'));var toCsv=require(_0x7042('0x8'));var querystring=require(_0x7042('0xf'));var Papa=require(_0x7042('0x10'));var Redis=require('ioredis');var authService=require(_0x7042('0x11'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0x7042('0x12'));var utils=require('../../config/utils');var config=require(_0x7042('0x13'));var licenseUtil=require(_0x7042('0x14'));var db=require(_0x7042('0x15'))['db'];function respondWithStatusCode(_0x5629f2,_0x5c06f0){_0x5c06f0=_0x5c06f0||0xcc;return function(_0x292c4a){if(_0x292c4a){return _0x5629f2[_0x7042('0x16')](_0x5c06f0);}return _0x5629f2[_0x7042('0x17')](_0x5c06f0)[_0x7042('0x18')]();};}function respondWithResult(_0x25dfe5,_0xee4c2){_0xee4c2=_0xee4c2||0xc8;return function(_0x5def25){if(_0x5def25){return _0x25dfe5[_0x7042('0x17')](_0xee4c2)[_0x7042('0x19')](_0x5def25);}};}function respondWithFilteredResult(_0x6ed505,_0x5c1ef0){return function(_0x4c68c4){if(_0x4c68c4){var _0xc7e44e=typeof _0x5c1ef0['offset']===_0x7042('0x1a')&&typeof _0x5c1ef0['limit']==='undefined';var _0x28add7=_0x4c68c4[_0x7042('0x1b')];var _0x1e69aa=_0xc7e44e?0x0:_0x5c1ef0[_0x7042('0x1c')];var _0x6e18fb=_0xc7e44e?_0x4c68c4['count']:_0x5c1ef0[_0x7042('0x1c')]+_0x5c1ef0[_0x7042('0x1d')];var _0x34fda6;if(_0x6e18fb>=_0x28add7){_0x6e18fb=_0x28add7;_0x34fda6=0xc8;}else{_0x34fda6=0xce;}_0x6ed505[_0x7042('0x17')](_0x34fda6);return _0x6ed505[_0x7042('0x1e')]('Content-Range',_0x1e69aa+'-'+_0x6e18fb+'/'+_0x28add7)[_0x7042('0x19')](_0x4c68c4);}return null;};}function patchUpdates(_0x580f84){return function(_0x363f3c){try{jsonpatch['apply'](_0x363f3c,_0x580f84,!![]);}catch(_0x3b8203){return BPromise[_0x7042('0x1f')](_0x3b8203);}return _0x363f3c[_0x7042('0x20')]();};}function saveUpdates(_0x456dfc,_0x484c82){return function(_0x5a224b){if(_0x5a224b){return _0x5a224b['update'](_0x456dfc)[_0x7042('0x21')](function(_0x30a722){return _0x30a722;});}return null;};}function removeEntity(_0x3af8bc,_0x1949fe){return function(_0x48d529){if(_0x48d529){return _0x48d529[_0x7042('0x22')]()[_0x7042('0x21')](function(){var _0x4611f9=_0x48d529[_0x7042('0x23')]({'plain':!![]});var _0x459ff6='IvrCampaigns';return db[_0x7042('0x24')][_0x7042('0x22')]({'where':{'type':_0x459ff6,'resourceId':_0x4611f9['id']}})[_0x7042('0x21')](function(){return _0x48d529;});})[_0x7042('0x21')](function(){_0x3af8bc[_0x7042('0x17')](0xcc)[_0x7042('0x18')]();});}};}function handleEntityNotFound(_0x162ac7,_0x26543a){return function(_0x4568ec){if(!_0x4568ec){_0x162ac7[_0x7042('0x16')](0x194);}return _0x4568ec;};}function handleError(_0xa9ca06,_0x36fec4){_0x36fec4=_0x36fec4||0x1f4;return function(_0x88c156){logger[_0x7042('0x25')](_0x88c156[_0x7042('0x26')]);if(_0x88c156[_0x7042('0x27')]){delete _0x88c156[_0x7042('0x27')];}_0xa9ca06[_0x7042('0x17')](_0x36fec4)[_0x7042('0x28')](_0x88c156);};}exports['index']=function(_0x519e79,_0x37cf52){var _0x160af6={},_0x300be2={},_0x253a8b={'count':0x0,'rows':[]};var _0x2620c3=_[_0x7042('0x29')](db[_0x7042('0x2a')]['rawAttributes'],function(_0x4823c3){return{'name':_0x4823c3[_0x7042('0x2b')],'type':_0x4823c3[_0x7042('0x2c')]['key']};});_0x300be2[_0x7042('0x2d')]=_[_0x7042('0x29')](_0x2620c3,'name');_0x300be2[_0x7042('0x2e')]=_[_0x7042('0x2f')](_0x519e79[_0x7042('0x2e')]);_0x300be2[_0x7042('0x30')]=_[_0x7042('0x31')](_0x300be2['model'],_0x300be2[_0x7042('0x2e')]);_0x160af6['attributes']=_['intersection'](_0x300be2[_0x7042('0x2d')],qs['fields'](_0x519e79[_0x7042('0x2e')][_0x7042('0x32')]));_0x160af6['attributes']=_0x160af6[_0x7042('0x33')]['length']?_0x160af6[_0x7042('0x33')]:_0x300be2[_0x7042('0x2d')];if(!_0x519e79[_0x7042('0x2e')][_0x7042('0x34')](_0x7042('0x35'))){_0x160af6[_0x7042('0x1d')]=qs[_0x7042('0x1d')](_0x519e79[_0x7042('0x2e')][_0x7042('0x1d')]);_0x160af6['offset']=qs[_0x7042('0x1c')](_0x519e79[_0x7042('0x2e')][_0x7042('0x1c')]);}_0x160af6['order']=qs['sort'](_0x519e79[_0x7042('0x2e')][_0x7042('0x36')]);_0x160af6['where']=qs[_0x7042('0x30')](_[_0x7042('0x37')](_0x519e79[_0x7042('0x2e')],_0x300be2[_0x7042('0x30')]),_0x2620c3);if(_0x519e79[_0x7042('0x2e')][_0x7042('0x38')]){_0x160af6[_0x7042('0x39')]=_[_0x7042('0x3a')](_0x160af6[_0x7042('0x39')],{'$or':_[_0x7042('0x29')](_0x2620c3,function(_0x2b8669){if(_0x2b8669[_0x7042('0x2c')]!==_0x7042('0x3b')){var _0x53a424={};_0x53a424[_0x2b8669['name']]={'$like':'%'+_0x519e79[_0x7042('0x2e')][_0x7042('0x38')]+'%'};return _0x53a424;}})});}_0x160af6=_[_0x7042('0x3a')]({},_0x160af6,_0x519e79[_0x7042('0x3c')]);var _0x4b138b={'where':_0x160af6[_0x7042('0x39')]};return db[_0x7042('0x2a')]['count'](_0x4b138b)['then'](function(_0x1f8e68){_0x253a8b[_0x7042('0x1b')]=_0x1f8e68;if(_0x519e79[_0x7042('0x2e')][_0x7042('0x3d')]){_0x160af6[_0x7042('0x3e')]=[{'all':!![]}];}return db['Campaign']['findAll'](_0x160af6);})[_0x7042('0x21')](function(_0x3897fc){_0x253a8b['rows']=_0x3897fc;return _0x253a8b;})[_0x7042('0x21')](respondWithFilteredResult(_0x37cf52,_0x160af6))[_0x7042('0x3f')](handleError(_0x37cf52,null));};exports[_0x7042('0x40')]=function(_0x59568d,_0x5cffc0){var _0x9c4981={'raw':![],'where':{'id':_0x59568d[_0x7042('0x41')]['id']}},_0x44413e={};_0x44413e['model']=_[_0x7042('0x2f')](db[_0x7042('0x2a')]['rawAttributes']);_0x44413e[_0x7042('0x2e')]=_[_0x7042('0x2f')](_0x59568d[_0x7042('0x2e')]);_0x44413e[_0x7042('0x30')]=_[_0x7042('0x31')](_0x44413e[_0x7042('0x2d')],_0x44413e[_0x7042('0x2e')]);_0x9c4981['attributes']=_[_0x7042('0x31')](_0x44413e[_0x7042('0x2d')],qs['fields'](_0x59568d[_0x7042('0x2e')][_0x7042('0x32')]));_0x9c4981[_0x7042('0x33')]=_0x9c4981[_0x7042('0x33')][_0x7042('0x42')]?_0x9c4981[_0x7042('0x33')]:_0x44413e['model'];if(_0x59568d['query']['includeAll']){_0x9c4981[_0x7042('0x3e')]=[{'all':!![]}];}_0x9c4981=_['merge']({},_0x9c4981,_0x59568d['options']);return db[_0x7042('0x2a')]['find'](_0x9c4981)[_0x7042('0x21')](handleEntityNotFound(_0x5cffc0,null))[_0x7042('0x21')](respondWithResult(_0x5cffc0,null))[_0x7042('0x3f')](handleError(_0x5cffc0,null));};exports[_0x7042('0x43')]=function(_0x1a22d5,_0x11e7ce){return db[_0x7042('0x2a')][_0x7042('0x43')](_0x1a22d5[_0x7042('0x44')],{})[_0x7042('0x21')](function(_0x103d68){var _0x14d11a=_0x1a22d5[_0x7042('0x45')]['get']({'plain':!![]});if(!_0x14d11a)throw new Error(_0x7042('0x46'));if(_0x14d11a[_0x7042('0x47')]===_0x7042('0x45')){var _0x81b898=_0x103d68[_0x7042('0x23')]({'plain':!![]});var _0x288a11=_0x7042('0x48');return db[_0x7042('0x49')][_0x7042('0x4a')]({'where':{'name':_0x288a11,'userProfileId':_0x14d11a[_0x7042('0x4b')]},'raw':!![]})[_0x7042('0x21')](function(_0x445689){if(_0x445689&&_0x445689[_0x7042('0x4c')]===0x0){return db['UserProfileResource'][_0x7042('0x43')]({'name':_0x81b898['name'],'resourceId':_0x81b898['id'],'type':_0x445689[_0x7042('0x27')],'sectionId':_0x445689['id']},{})[_0x7042('0x21')](function(){return _0x103d68;});}else{return _0x103d68;}})[_0x7042('0x3f')](function(_0x5a0c85){logger['error'](_0x7042('0x4d'),_0x5a0c85);throw _0x5a0c85;});}return _0x103d68;})[_0x7042('0x21')](respondWithResult(_0x11e7ce,0xc9))[_0x7042('0x3f')](handleError(_0x11e7ce,null));};exports[_0x7042('0x4e')]=function(_0x58f2f2,_0x497188){var _0x280a41={'where':{'id':_0x58f2f2['params']['id']}},_0x3b4d27={};_0x3b4d27[_0x7042('0x2d')]=_[_0x7042('0x2f')](db['Campaign'][_0x7042('0x4f')]);_0x280a41[_0x7042('0x33')]=_['intersection'](_0x3b4d27[_0x7042('0x2d')],qs[_0x7042('0x32')](_0x58f2f2[_0x7042('0x2e')]['fields']));_0x280a41[_0x7042('0x33')]=_0x280a41[_0x7042('0x33')][_0x7042('0x42')]?_0x280a41[_0x7042('0x33')]:_0x3b4d27[_0x7042('0x2d')];if(_0x58f2f2[_0x7042('0x2e')][_0x7042('0x3d')]){_0x280a41[_0x7042('0x3e')]=[{'all':!![]}];}_0x280a41=_[_0x7042('0x3a')]({},_0x280a41,_0x58f2f2[_0x7042('0x3c')]);return db[_0x7042('0x2a')][_0x7042('0x4a')](_0x280a41)['then'](handleEntityNotFound(_0x497188,null))[_0x7042('0x21')](function(_0x318fd5){if(_0x318fd5){var _0x5d41f6=_0x318fd5[_0x7042('0x23')]({'plain':!![]});_0x5d41f6=qs[_0x7042('0x50')](_0x5d41f6,['id',_0x7042('0x51'),'updatedAt']);_0x58f2f2[_0x7042('0x44')]=_[_0x7042('0x50')](_0x58f2f2[_0x7042('0x44')],['id','createdAt',_0x7042('0x52')]);return db[_0x7042('0x2a')][_0x7042('0x43')](_[_0x7042('0x3a')](_0x5d41f6,_0x58f2f2[_0x7042('0x44')]),{'include':_0x58f2f2[_0x7042('0x2e')][_0x7042('0x3d')]?[{'all':!![]}]:undefined})[_0x7042('0x21')](function(_0x4bc8e9){var _0x2d7dbc=_0x58f2f2[_0x7042('0x45')][_0x7042('0x23')]({'plain':!![]});if(!_0x2d7dbc)throw new Error(_0x7042('0x46'));if(_0x2d7dbc[_0x7042('0x47')]===_0x7042('0x45')){var _0x253936=_0x4bc8e9['get']({'plain':!![]});var _0x1872c7='IvrCampaigns';return db[_0x7042('0x49')][_0x7042('0x4a')]({'where':{'name':_0x1872c7,'userProfileId':_0x2d7dbc[_0x7042('0x4b')]},'raw':!![]})[_0x7042('0x21')](function(_0x50f7c5){if(_0x50f7c5&&_0x50f7c5['autoAssociation']===0x0){return db[_0x7042('0x24')][_0x7042('0x43')]({'name':_0x253936['name'],'resourceId':_0x253936['id'],'type':_0x50f7c5[_0x7042('0x27')],'sectionId':_0x50f7c5['id']},{})[_0x7042('0x21')](function(){return _0x4bc8e9;});}else{return _0x4bc8e9;}})[_0x7042('0x3f')](function(_0x195f08){logger[_0x7042('0x25')](_0x7042('0x4d'),_0x195f08);throw _0x195f08;});}return _0x4bc8e9;});}})[_0x7042('0x21')](respondWithResult(_0x497188,0xc9))[_0x7042('0x3f')](handleError(_0x497188,null));};exports[_0x7042('0x53')]=function(_0x5c14ca,_0x2185f3){if(_0x5c14ca[_0x7042('0x44')]['id']){delete _0x5c14ca[_0x7042('0x44')]['id'];}return db[_0x7042('0x2a')]['find']({'where':{'id':_0x5c14ca[_0x7042('0x41')]['id']}})['then'](handleEntityNotFound(_0x2185f3,null))[_0x7042('0x21')](saveUpdates(_0x5c14ca[_0x7042('0x44')],null))['then'](respondWithResult(_0x2185f3,null))['catch'](handleError(_0x2185f3,null));};exports[_0x7042('0x22')]=function(_0x5ba91e,_0xc51212){return db[_0x7042('0x2a')][_0x7042('0x4a')]({'where':{'id':_0x5ba91e['params']['id']}})['then'](handleEntityNotFound(_0xc51212,null))['then'](removeEntity(_0xc51212,null))[_0x7042('0x3f')](handleError(_0xc51212,null));};exports[_0x7042('0x54')]=function(_0x5158b6,_0x2256d3,_0x10d2d8){var _0x331b54={'raw':!![],'where':{}};var _0x4c70f4={};var _0x245201={'count':0x0,'rows':[]};return db[_0x7042('0x2a')]['findOne']({'where':{'id':_0x5158b6['params']['id']}})[_0x7042('0x21')](handleEntityNotFound(_0x2256d3,null))['then'](function(_0x59bb93){if(_0x59bb93){_0x4c70f4[_0x7042('0x2d')]=_[_0x7042('0x2f')](db[_0x7042('0x55')][_0x7042('0x4f')]);_0x4c70f4[_0x7042('0x2e')]=_[_0x7042('0x2f')](_0x5158b6[_0x7042('0x2e')]);_0x4c70f4[_0x7042('0x30')]=_['intersection'](_0x4c70f4['model'],_0x4c70f4[_0x7042('0x2e')]);_0x331b54[_0x7042('0x33')]=_[_0x7042('0x31')](_0x4c70f4['model'],qs['fields'](_0x5158b6[_0x7042('0x2e')]['fields']));_0x331b54[_0x7042('0x33')]=_0x331b54[_0x7042('0x33')][_0x7042('0x42')]?_0x331b54['attributes']:_0x4c70f4[_0x7042('0x2d')];if(!_0x5158b6[_0x7042('0x2e')]['hasOwnProperty'](_0x7042('0x35'))){_0x331b54[_0x7042('0x1d')]=qs['limit'](_0x5158b6['query'][_0x7042('0x1d')]);_0x331b54[_0x7042('0x1c')]=qs['offset'](_0x5158b6[_0x7042('0x2e')][_0x7042('0x1c')]);}_0x331b54[_0x7042('0x56')]=qs[_0x7042('0x36')](_0x5158b6[_0x7042('0x2e')][_0x7042('0x36')]);_0x331b54[_0x7042('0x39')]=qs[_0x7042('0x30')](_[_0x7042('0x37')](_0x5158b6[_0x7042('0x2e')],_0x4c70f4['filters']));_0x331b54[_0x7042('0x39')][_0x7042('0x57')]=_0x59bb93['id'];if(_0x5158b6[_0x7042('0x2e')][_0x7042('0x38')]){_0x331b54['where']=_[_0x7042('0x3a')](_0x331b54[_0x7042('0x39')],{'$or':_[_0x7042('0x29')](_0x331b54[_0x7042('0x33')],function(_0x5e758c){var _0x10bb7a={};_0x10bb7a[_0x5e758c]={'$like':'%'+_0x5158b6[_0x7042('0x2e')][_0x7042('0x38')]+'%'};return _0x10bb7a;})});}_0x331b54=_[_0x7042('0x3a')]({},_0x331b54,_0x5158b6[_0x7042('0x3c')]);return db['CmHopper']['count']({'where':_0x331b54[_0x7042('0x39')]})['then'](function(_0x29fa20){_0x245201[_0x7042('0x1b')]=_0x29fa20;if(_0x5158b6[_0x7042('0x2e')][_0x7042('0x3d')]){_0x331b54[_0x7042('0x3e')]=[{'all':!![]}];}return db[_0x7042('0x55')]['findAll'](_0x331b54);})[_0x7042('0x21')](function(_0x5317c0){_0x245201[_0x7042('0x58')]=_0x5317c0;return _0x245201;});}})[_0x7042('0x21')](respondWithFilteredResult(_0x2256d3,_0x331b54))['catch'](handleError(_0x2256d3,null));};exports[_0x7042('0x59')]=function(_0x400004,_0x29c861,_0x271a62){var _0x54a65a={'raw':!![],'where':{}};var _0x2b3fb1={};var _0x462bb5={'count':0x0,'rows':[]};return db[_0x7042('0x2a')][_0x7042('0x5a')]({'where':{'id':_0x400004[_0x7042('0x41')]['id']}})[_0x7042('0x21')](handleEntityNotFound(_0x29c861,null))[_0x7042('0x21')](function(_0x356841){if(_0x356841){_0x2b3fb1[_0x7042('0x2d')]=_['keys'](db[_0x7042('0x5b')][_0x7042('0x4f')]);_0x2b3fb1[_0x7042('0x2e')]=_['keys'](_0x400004[_0x7042('0x2e')]);_0x2b3fb1['filters']=_['intersection'](_0x2b3fb1[_0x7042('0x2d')],_0x2b3fb1[_0x7042('0x2e')]);_0x54a65a[_0x7042('0x33')]=_['intersection'](_0x2b3fb1[_0x7042('0x2d')],qs[_0x7042('0x32')](_0x400004[_0x7042('0x2e')]['fields']));_0x54a65a[_0x7042('0x33')]=_0x54a65a[_0x7042('0x33')][_0x7042('0x42')]?_0x54a65a[_0x7042('0x33')]:_0x2b3fb1[_0x7042('0x2d')];if(!_0x400004[_0x7042('0x2e')][_0x7042('0x34')]('nolimit')){_0x54a65a['limit']=qs[_0x7042('0x1d')](_0x400004['query'][_0x7042('0x1d')]);_0x54a65a[_0x7042('0x1c')]=qs['offset'](_0x400004['query'][_0x7042('0x1c')]);}_0x54a65a[_0x7042('0x56')]=qs['sort'](_0x400004[_0x7042('0x2e')][_0x7042('0x36')]);_0x54a65a[_0x7042('0x39')]=qs[_0x7042('0x30')](_[_0x7042('0x37')](_0x400004[_0x7042('0x2e')],_0x2b3fb1['filters']));_0x54a65a[_0x7042('0x39')][_0x7042('0x57')]=_0x356841['id'];if(_0x400004['query']['filter']){_0x54a65a[_0x7042('0x39')]=_['merge'](_0x54a65a[_0x7042('0x39')],{'$or':_[_0x7042('0x29')](_0x54a65a[_0x7042('0x33')],function(_0x5dd90d){var _0x5e8535={};_0x5e8535[_0x5dd90d]={'$like':'%'+_0x400004['query']['filter']+'%'};return _0x5e8535;})});}_0x54a65a=_[_0x7042('0x3a')]({},_0x54a65a,_0x400004[_0x7042('0x3c')]);return db[_0x7042('0x5b')][_0x7042('0x1b')]({'where':_0x54a65a[_0x7042('0x39')]})[_0x7042('0x21')](function(_0x392343){_0x462bb5['count']=_0x392343;if(_0x400004[_0x7042('0x2e')][_0x7042('0x3d')]){_0x54a65a['include']=[{'all':!![]}];}return db[_0x7042('0x5b')][_0x7042('0x5c')](_0x54a65a);})[_0x7042('0x21')](function(_0xfc46ac){_0x462bb5['rows']=_0xfc46ac;return _0x462bb5;});}})['then'](respondWithFilteredResult(_0x29c861,_0x54a65a))['catch'](handleError(_0x29c861,null));};exports[_0x7042('0x5d')]=function(_0x501a3e,_0x234cba,_0x2314fc){var _0x1ce11d={'raw':!![],'where':{}};var _0x50058b={};var _0x94ea96={'count':0x0,'rows':[]};return db[_0x7042('0x2a')][_0x7042('0x5a')]({'where':{'id':_0x501a3e[_0x7042('0x41')]['id']}})['then'](handleEntityNotFound(_0x234cba,null))[_0x7042('0x21')](function(_0x3bdb8b){if(_0x3bdb8b){_0x50058b['model']=_['keys'](db[_0x7042('0x5e')][_0x7042('0x4f')]);_0x50058b[_0x7042('0x2e')]=_['keys'](_0x501a3e[_0x7042('0x2e')]);_0x50058b['filters']=_[_0x7042('0x31')](_0x50058b[_0x7042('0x2d')],_0x50058b[_0x7042('0x2e')]);_0x1ce11d[_0x7042('0x33')]=_[_0x7042('0x31')](_0x50058b[_0x7042('0x2d')],qs[_0x7042('0x32')](_0x501a3e[_0x7042('0x2e')]['fields']));_0x1ce11d[_0x7042('0x33')]=_0x1ce11d[_0x7042('0x33')][_0x7042('0x42')]?_0x1ce11d[_0x7042('0x33')]:_0x50058b[_0x7042('0x2d')];if(!_0x501a3e[_0x7042('0x2e')]['hasOwnProperty']('nolimit')){_0x1ce11d[_0x7042('0x1d')]=qs[_0x7042('0x1d')](_0x501a3e[_0x7042('0x2e')][_0x7042('0x1d')]);_0x1ce11d[_0x7042('0x1c')]=qs[_0x7042('0x1c')](_0x501a3e[_0x7042('0x2e')][_0x7042('0x1c')]);}_0x1ce11d[_0x7042('0x56')]=qs['sort'](_0x501a3e[_0x7042('0x2e')][_0x7042('0x36')]);_0x1ce11d['where']=qs[_0x7042('0x30')](_[_0x7042('0x37')](_0x501a3e[_0x7042('0x2e')],_0x50058b[_0x7042('0x30')]));_0x1ce11d[_0x7042('0x39')][_0x7042('0x57')]=_0x3bdb8b['id'];if(_0x501a3e['query'][_0x7042('0x38')]){_0x1ce11d[_0x7042('0x39')]=_['merge'](_0x1ce11d[_0x7042('0x39')],{'$or':_[_0x7042('0x29')](_0x1ce11d[_0x7042('0x33')],function(_0x25dd26){var _0x28dbdc={};_0x28dbdc[_0x25dd26]={'$like':'%'+_0x501a3e['query'][_0x7042('0x38')]+'%'};return _0x28dbdc;})});}_0x1ce11d=_[_0x7042('0x3a')]({},_0x1ce11d,_0x501a3e['options']);return db[_0x7042('0x5e')][_0x7042('0x1b')]({'where':_0x1ce11d[_0x7042('0x39')]})[_0x7042('0x21')](function(_0xf85af2){_0x94ea96['count']=_0xf85af2;if(_0x501a3e[_0x7042('0x2e')][_0x7042('0x3d')]){_0x1ce11d[_0x7042('0x3e')]=[{'all':!![]}];}return db[_0x7042('0x5e')][_0x7042('0x5c')](_0x1ce11d);})[_0x7042('0x21')](function(_0x3e2077){_0x94ea96[_0x7042('0x58')]=_0x3e2077;return _0x94ea96;});}})[_0x7042('0x21')](respondWithFilteredResult(_0x234cba,_0x1ce11d))[_0x7042('0x3f')](handleError(_0x234cba,null));};exports[_0x7042('0x5f')]=function(_0x34a64d,_0x39c85e,_0x5b5f1a){var _0x4a834e={'raw':!![],'where':{}};var _0x5ab8b5={};var _0x60717c={'count':0x0,'rows':[]};return db[_0x7042('0x2a')]['findOne']({'where':{'id':_0x34a64d[_0x7042('0x41')]['id']}})['then'](handleEntityNotFound(_0x39c85e,null))[_0x7042('0x21')](function(_0x5a3095){if(_0x5a3095){_0x5ab8b5[_0x7042('0x2d')]=_[_0x7042('0x2f')](db[_0x7042('0x60')][_0x7042('0x4f')]);_0x5ab8b5['query']=_['keys'](_0x34a64d[_0x7042('0x2e')]);_0x5ab8b5[_0x7042('0x30')]=_[_0x7042('0x31')](_0x5ab8b5[_0x7042('0x2d')],_0x5ab8b5[_0x7042('0x2e')]);_0x4a834e['attributes']=_[_0x7042('0x31')](_0x5ab8b5[_0x7042('0x2d')],qs['fields'](_0x34a64d['query'][_0x7042('0x32')]));_0x4a834e[_0x7042('0x33')]=_0x4a834e[_0x7042('0x33')][_0x7042('0x42')]?_0x4a834e[_0x7042('0x33')]:_0x5ab8b5[_0x7042('0x2d')];if(!_0x34a64d[_0x7042('0x2e')][_0x7042('0x34')](_0x7042('0x35'))){_0x4a834e['limit']=qs[_0x7042('0x1d')](_0x34a64d[_0x7042('0x2e')][_0x7042('0x1d')]);_0x4a834e[_0x7042('0x1c')]=qs[_0x7042('0x1c')](_0x34a64d['query']['offset']);}_0x4a834e['order']=qs[_0x7042('0x36')](_0x34a64d[_0x7042('0x2e')]['sort']);_0x4a834e[_0x7042('0x39')]=qs[_0x7042('0x30')](_[_0x7042('0x37')](_0x34a64d[_0x7042('0x2e')],_0x5ab8b5['filters']));_0x4a834e[_0x7042('0x39')][_0x7042('0x57')]=_0x5a3095['id'];if(_0x34a64d[_0x7042('0x2e')][_0x7042('0x38')]){_0x4a834e['where']=_[_0x7042('0x3a')](_0x4a834e[_0x7042('0x39')],{'$or':_['map'](_0x4a834e['attributes'],function(_0x31f374){var _0x34dd15={};_0x34dd15[_0x31f374]={'$like':'%'+_0x34a64d[_0x7042('0x2e')][_0x7042('0x38')]+'%'};return _0x34dd15;})});}_0x4a834e=_[_0x7042('0x3a')]({},_0x4a834e,_0x34a64d[_0x7042('0x3c')]);return db[_0x7042('0x60')][_0x7042('0x1b')]({'where':_0x4a834e[_0x7042('0x39')]})[_0x7042('0x21')](function(_0x333ea4){_0x60717c[_0x7042('0x1b')]=_0x333ea4;if(_0x34a64d[_0x7042('0x2e')][_0x7042('0x3d')]){_0x4a834e[_0x7042('0x3e')]=[{'all':!![]}];}return db[_0x7042('0x60')][_0x7042('0x5c')](_0x4a834e);})[_0x7042('0x21')](function(_0x2935dc){_0x60717c[_0x7042('0x58')]=_0x2935dc;return _0x60717c;});}})[_0x7042('0x21')](respondWithFilteredResult(_0x39c85e,_0x4a834e))[_0x7042('0x3f')](handleError(_0x39c85e,null));};exports['getLists']=function(_0x3f3cd1,_0x268042,_0x60ba4f){var _0x5c9a48={};var _0x75fbfe={};var _0x11d0d8;var _0x44d4b6;return db['Campaign'][_0x7042('0x5a')]({'where':{'id':_0x3f3cd1[_0x7042('0x41')]['id']}})[_0x7042('0x21')](handleEntityNotFound(_0x268042,null))[_0x7042('0x21')](function(_0x56ad5b){if(_0x56ad5b){_0x11d0d8=_0x56ad5b;_0x75fbfe[_0x7042('0x2d')]=_[_0x7042('0x2f')](db[_0x7042('0x61')][_0x7042('0x4f')]);_0x75fbfe[_0x7042('0x2e')]=_[_0x7042('0x2f')](_0x3f3cd1[_0x7042('0x2e')]);_0x75fbfe[_0x7042('0x30')]=_[_0x7042('0x31')](_0x75fbfe[_0x7042('0x2d')],_0x75fbfe[_0x7042('0x2e')]);_0x5c9a48[_0x7042('0x33')]=_['intersection'](_0x75fbfe[_0x7042('0x2d')],qs[_0x7042('0x32')](_0x3f3cd1[_0x7042('0x2e')][_0x7042('0x32')]));_0x5c9a48[_0x7042('0x33')]=_0x5c9a48['attributes'][_0x7042('0x42')]?_0x5c9a48[_0x7042('0x33')]:_0x75fbfe['model'];_0x5c9a48[_0x7042('0x56')]=qs[_0x7042('0x36')](_0x3f3cd1[_0x7042('0x2e')]['sort']);_0x5c9a48[_0x7042('0x39')]=qs[_0x7042('0x30')](_['pick'](_0x3f3cd1[_0x7042('0x2e')],_0x75fbfe[_0x7042('0x30')]));if(_0x3f3cd1[_0x7042('0x2e')]['filter']){_0x5c9a48[_0x7042('0x39')]=_[_0x7042('0x3a')](_0x5c9a48[_0x7042('0x39')],{'$or':_['map'](_0x5c9a48[_0x7042('0x33')],function(_0x15226f){var _0x51c9da={};_0x51c9da[_0x15226f]={'$like':'%'+_0x3f3cd1[_0x7042('0x2e')]['filter']+'%'};return _0x51c9da;})});}_0x5c9a48=_[_0x7042('0x3a')]({},_0x5c9a48,_0x3f3cd1['options']);return _0x11d0d8['getLists'](_0x5c9a48);}})['then'](function(_0xf0ff98){if(_0xf0ff98){_0x44d4b6=_0xf0ff98['length'];if(!_0x3f3cd1[_0x7042('0x2e')][_0x7042('0x34')](_0x7042('0x35'))){_0x5c9a48[_0x7042('0x1d')]=qs['limit'](_0x3f3cd1[_0x7042('0x2e')][_0x7042('0x1d')]);_0x5c9a48[_0x7042('0x1c')]=qs[_0x7042('0x1c')](_0x3f3cd1[_0x7042('0x2e')][_0x7042('0x1c')]);}return _0x11d0d8[_0x7042('0x62')](_0x5c9a48);}})[_0x7042('0x21')](function(_0x1a4da8){if(_0x1a4da8){return _0x1a4da8?{'count':_0x44d4b6,'rows':_0x1a4da8}:null;}})[_0x7042('0x21')](respondWithResult(_0x268042,null))[_0x7042('0x3f')](handleError(_0x268042,null));};exports[_0x7042('0x63')]=function(_0x484a5e,_0x1ffa4a,_0x29cc7e){var _0x59fe22,_0x5b5c52;var _0x9dfcce=[];var _0x241ef6=moment()[_0x7042('0x64')](_0x7042('0x65'));return db[_0x7042('0x2a')][_0x7042('0x4a')]({'where':{'id':_0x484a5e[_0x7042('0x41')]['id']}})[_0x7042('0x21')](handleEntityNotFound(_0x1ffa4a,null))[_0x7042('0x21')](function(_0x2502fe){if(_0x2502fe){_0x5b5c52=_0x2502fe;return _0x2502fe[_0x7042('0x63')](_0x484a5e['body'][_0x7042('0x66')],_['omit'](_0x484a5e[_0x7042('0x44')],[_0x7042('0x66'),'id'])||{});}return null;})['spread'](function(_0x526699){var _0x305f11;var _0x112e5c;_0x59fe22=_0x526699||[];var _0x291172=[];if(_0x526699){for(var _0x564e1e=0x0;_0x564e1e<_0x526699[_0x7042('0x42')];_0x564e1e+=0x1){var _0x13f8ec=_0x526699[_0x564e1e][_0x7042('0x23')]({'plain':!![]});_0x5b5c52[_0x7042('0x67')]=_0x484a5e[_0x7042('0x44')][_0x7042('0x67')]?_0x484a5e[_0x7042('0x44')]['dialCheckDuplicateType']:_0x5b5c52[_0x7042('0x67')];switch(_0x5b5c52[_0x7042('0x67')]){case _0x7042('0x68'):_0x305f11=squel['insert']()['into'](_0x7042('0x69'))[_0x7042('0x6a')](['phone','scheduledAt','ContactId',_0x7042('0x6b'),_0x7042('0x57'),_0x7042('0x51'),_0x7042('0x52')],squel[_0x7042('0x6c')]()[_0x7042('0x6d')](_0x7042('0x6e'),_0x7042('0x6e'))[_0x7042('0x6d')]('NOW()',_0x7042('0x6f'))[_0x7042('0x6d')]('id','ContactId')[_0x7042('0x6d')](_0x13f8ec['CmListId'][_0x7042('0x70')](),'ListId')[_0x7042('0x6d')](_0x484a5e[_0x7042('0x41')]['id'][_0x7042('0x70')](),_0x7042('0x57'))['field']('\x27'+_0x241ef6+'\x27',_0x7042('0x51'))[_0x7042('0x6d')]('\x27'+_0x241ef6+'\x27',_0x7042('0x52'))[_0x7042('0x71')]('cm_contacts')[_0x7042('0x39')](_0x7042('0x72'))[_0x7042('0x39')](_0x7042('0x73'),_0x13f8ec[_0x7042('0x74')][_0x7042('0x70')]())[_0x7042('0x39')](_0x7042('0x75'))[_0x7042('0x39')](_0x7042('0x76'),squel[_0x7042('0x6c')]()['field'](_0x7042('0x77'))[_0x7042('0x71')]('cm_hopper_final')['where']('CampaignId\x20=\x20?',_0x484a5e['params']['id']['toString']()))['where'](_0x7042('0x76'),squel['select']()[_0x7042('0x6d')](_0x7042('0x78'))[_0x7042('0x71')](_0x7042('0x69'))[_0x7042('0x39')]('CampaignId\x20=\x20?',_0x484a5e[_0x7042('0x41')]['id'][_0x7042('0x70')]())))[_0x7042('0x70')]();break;case'onlyIfOpen':_0x305f11=squel[_0x7042('0x79')]()[_0x7042('0x7a')]('cm_hopper')[_0x7042('0x6a')]([_0x7042('0x6e'),_0x7042('0x6f'),_0x7042('0x7b'),_0x7042('0x6b'),_0x7042('0x57'),_0x7042('0x51'),'updatedAt'],squel[_0x7042('0x6c')]()[_0x7042('0x6d')](_0x7042('0x6e'),'phone')['field'](_0x7042('0x7c'),_0x7042('0x6f'))['field']('id','ContactId')[_0x7042('0x6d')](_0x13f8ec[_0x7042('0x74')][_0x7042('0x70')](),_0x7042('0x6b'))['field'](_0x484a5e[_0x7042('0x41')]['id'][_0x7042('0x70')](),_0x7042('0x57'))[_0x7042('0x6d')]('\x27'+_0x241ef6+'\x27',_0x7042('0x51'))[_0x7042('0x6d')]('\x27'+_0x241ef6+'\x27','updatedAt')[_0x7042('0x71')](_0x7042('0x7d'))[_0x7042('0x39')](_0x7042('0x72'))[_0x7042('0x39')](_0x7042('0x73'),_0x13f8ec[_0x7042('0x74')][_0x7042('0x70')]())['where'](_0x7042('0x75'))['where']('phone\x20NOT\x20IN\x20(?)',squel[_0x7042('0x6c')]()['field'](_0x7042('0x78'))[_0x7042('0x71')](_0x7042('0x69'))[_0x7042('0x39')](_0x7042('0x7e'),_0x484a5e[_0x7042('0x41')]['id'][_0x7042('0x70')]())))[_0x7042('0x70')]();break;default:_0x305f11=squel[_0x7042('0x79')]()['into'](_0x7042('0x69'))[_0x7042('0x6a')]([_0x7042('0x6e'),'scheduledAt',_0x7042('0x7b'),'ListId','CampaignId',_0x7042('0x51'),_0x7042('0x52')],squel['select']()[_0x7042('0x6d')]('phone',_0x7042('0x6e'))[_0x7042('0x6d')](_0x7042('0x7c'),_0x7042('0x6f'))[_0x7042('0x6d')]('id',_0x7042('0x7b'))[_0x7042('0x6d')](_0x13f8ec[_0x7042('0x74')][_0x7042('0x70')](),'ListId')['field'](_0x484a5e[_0x7042('0x41')]['id']['toString'](),_0x7042('0x57'))[_0x7042('0x6d')]('\x27'+_0x241ef6+'\x27',_0x7042('0x51'))[_0x7042('0x6d')]('\x27'+_0x241ef6+'\x27',_0x7042('0x52'))['from']('cm_contacts')['where'](_0x7042('0x72'))['where'](_0x7042('0x73'),_0x13f8ec['CmListId']['toString']())['where'](_0x7042('0x75')))[_0x7042('0x70')]();}_0x112e5c=squel[_0x7042('0x79')]()[_0x7042('0x7a')](_0x7042('0x7f'))[_0x7042('0x6a')]([_0x7042('0x80'),_0x7042('0x6f'),_0x7042('0x6e'),'OrderBy',_0x7042('0x51'),_0x7042('0x52')],squel[_0x7042('0x6c')]()[_0x7042('0x6d')]('h.id','id')[_0x7042('0x6d')]('NOW()',_0x7042('0x6f'))[_0x7042('0x6d')]('ci.item',_0x7042('0x6e'))[_0x7042('0x6d')](_0x7042('0x81'),'OrderBy')[_0x7042('0x6d')]('\x27'+_0x241ef6+'\x27',_0x7042('0x51'))[_0x7042('0x6d')]('\x27'+_0x241ef6+'\x27',_0x7042('0x52'))[_0x7042('0x71')](_0x7042('0x82'),'ci')[_0x7042('0x83')](_0x7042('0x69'),'h',_0x7042('0x84'))[_0x7042('0x39')]('h.ListId\x20=\x20?',_0x13f8ec['CmListId'][_0x7042('0x70')]())[_0x7042('0x39')](_0x7042('0x85'),_0x484a5e[_0x7042('0x41')]['id'][_0x7042('0x70')]())[_0x7042('0x39')](_0x7042('0x86'),_0x241ef6))[_0x7042('0x70')]();_0x291172[_0x7042('0x87')](db[_0x7042('0x88')][_0x7042('0x2e')](_0x305f11));_0x9dfcce[_0x7042('0x87')](db[_0x7042('0x88')][_0x7042('0x2e')](_0x112e5c));}return BPromise[_0x7042('0x89')](_0x291172);}})[_0x7042('0x21')](function(){return BPromise[_0x7042('0x89')](_0x9dfcce);})['then'](function(){return _0x59fe22;})['then'](respondWithResult(_0x1ffa4a,null))[_0x7042('0x3f')](handleError(_0x1ffa4a,null));};exports['removeLists']=function(_0x3b407b,_0x3432f7,_0x314db7){return db[_0x7042('0x2a')][_0x7042('0x4a')]({'where':{'id':_0x3b407b[_0x7042('0x41')]['id']}})['then'](handleEntityNotFound(_0x3432f7,null))[_0x7042('0x21')](function(_0x43162e){if(_0x43162e){return _0x43162e[_0x7042('0x8a')](_0x3b407b[_0x7042('0x2e')][_0x7042('0x66')]);}})[_0x7042('0x21')](function(_0x5c66fa){if(_0x5c66fa){return db[_0x7042('0x55')]['destroy']({'where':{'ListId':_0x3b407b['query'][_0x7042('0x66')],'CampaignId':_0x3b407b[_0x7042('0x41')]['id']}})[_0x7042('0x21')](function(){return _0x5c66fa;});}})[_0x7042('0x21')](respondWithStatusCode(_0x3432f7,null))[_0x7042('0x3f')](handleError(_0x3432f7,null));};exports[_0x7042('0x8b')]=function(_0x302339,_0x2ab49a,_0x3b37e9){var _0x218b75={};var _0x4fc9e7={};var _0x392ab5;var _0x591d6d;return db[_0x7042('0x2a')][_0x7042('0x5a')]({'where':{'id':_0x302339[_0x7042('0x41')]['id']}})[_0x7042('0x21')](handleEntityNotFound(_0x2ab49a,null))['then'](function(_0x10a106){if(_0x10a106){_0x392ab5=_0x10a106;_0x4fc9e7[_0x7042('0x2d')]=_['keys'](db[_0x7042('0x61')][_0x7042('0x4f')]);_0x4fc9e7[_0x7042('0x2e')]=_[_0x7042('0x2f')](_0x302339[_0x7042('0x2e')]);_0x4fc9e7['filters']=_['intersection'](_0x4fc9e7['model'],_0x4fc9e7[_0x7042('0x2e')]);_0x218b75[_0x7042('0x33')]=_[_0x7042('0x31')](_0x4fc9e7['model'],qs['fields'](_0x302339[_0x7042('0x2e')]['fields']));_0x218b75['attributes']=_0x218b75[_0x7042('0x33')][_0x7042('0x42')]?_0x218b75[_0x7042('0x33')]:_0x4fc9e7[_0x7042('0x2d')];_0x218b75[_0x7042('0x56')]=qs[_0x7042('0x36')](_0x302339['query'][_0x7042('0x36')]);_0x218b75[_0x7042('0x39')]=qs[_0x7042('0x30')](_[_0x7042('0x37')](_0x302339[_0x7042('0x2e')],_0x4fc9e7[_0x7042('0x30')]));if(_0x302339['query'][_0x7042('0x38')]){_0x218b75[_0x7042('0x39')]=_[_0x7042('0x3a')](_0x218b75[_0x7042('0x39')],{'$or':_[_0x7042('0x29')](_0x218b75[_0x7042('0x33')],function(_0x5a4529){var _0x57357e={};_0x57357e[_0x5a4529]={'$like':'%'+_0x302339[_0x7042('0x2e')][_0x7042('0x38')]+'%'};return _0x57357e;})});}_0x218b75=_[_0x7042('0x3a')]({},_0x218b75,_0x302339[_0x7042('0x3c')]);return _0x392ab5['getBlackLists'](_0x218b75);}})[_0x7042('0x21')](function(_0xfba18d){if(_0xfba18d){_0x591d6d=_0xfba18d['length'];if(!_0x302339[_0x7042('0x2e')][_0x7042('0x34')]('nolimit')){_0x218b75[_0x7042('0x1d')]=qs[_0x7042('0x1d')](_0x302339[_0x7042('0x2e')]['limit']);_0x218b75['offset']=qs[_0x7042('0x1c')](_0x302339[_0x7042('0x2e')][_0x7042('0x1c')]);}return _0x392ab5['getBlackLists'](_0x218b75);}})['then'](function(_0x55c18b){if(_0x55c18b){return _0x55c18b?{'count':_0x591d6d,'rows':_0x55c18b}:null;}})[_0x7042('0x21')](respondWithResult(_0x2ab49a,null))[_0x7042('0x3f')](handleError(_0x2ab49a,null));};exports[_0x7042('0x8c')]=function(_0x3239cd,_0x14d90e,_0x310266){var _0x589aed,_0x426ba5;var _0x4fce5a=[];var _0x567233=moment()['format']('YYYY-MM-DD\x20HH:mm:ss');return db[_0x7042('0x2a')]['find']({'where':{'id':_0x3239cd[_0x7042('0x41')]['id']}})['then'](handleEntityNotFound(_0x14d90e,null))[_0x7042('0x21')](function(_0x3e7c8e){if(_0x3e7c8e){_0x426ba5=_0x3e7c8e;return _0x3e7c8e[_0x7042('0x8c')](_0x3239cd[_0x7042('0x44')][_0x7042('0x66')],_[_0x7042('0x50')](_0x3239cd['body'],[_0x7042('0x66'),'id'])||{});}return null;})[_0x7042('0x8d')](function(_0x109a24){var _0x464080;var _0x42242b;_0x589aed=_0x109a24||[];var _0x295a93=[];if(_0x109a24){for(var _0x59b1ef=0x0;_0x59b1ef<_0x109a24[_0x7042('0x42')];_0x59b1ef+=0x1){var _0x1aeb73=_0x109a24[_0x59b1ef][_0x7042('0x23')]({'plain':!![]});_0x464080=squel['insert']()['into'](_0x7042('0x8e'))['fromQuery'](['phone',_0x7042('0x7b'),'ListId',_0x7042('0x57'),_0x7042('0x51'),_0x7042('0x52')],squel[_0x7042('0x6c')]()['field']('phone','phone')[_0x7042('0x6d')]('id',_0x7042('0x7b'))[_0x7042('0x6d')](_0x1aeb73[_0x7042('0x74')][_0x7042('0x70')](),_0x7042('0x6b'))[_0x7042('0x6d')](_0x3239cd[_0x7042('0x41')]['id'][_0x7042('0x70')](),_0x7042('0x57'))[_0x7042('0x6d')](_0x7042('0x7c'),_0x7042('0x51'))[_0x7042('0x6d')](_0x7042('0x7c'),_0x7042('0x52'))[_0x7042('0x71')](_0x7042('0x7d'))['where'](_0x7042('0x72'))['where']('ListId\x20=\x20?',_0x1aeb73[_0x7042('0x74')][_0x7042('0x70')]())[_0x7042('0x39')](_0x7042('0x75')))[_0x7042('0x70')]();_0x295a93[_0x7042('0x87')](db[_0x7042('0x88')][_0x7042('0x2e')](_0x464080));}return BPromise[_0x7042('0x89')](_0x295a93);}})['then'](function(){return _0x589aed;})[_0x7042('0x21')](respondWithResult(_0x14d90e,null))[_0x7042('0x3f')](handleError(_0x14d90e,null));};exports['removeBlackLists']=function(_0x18b18d,_0x4aed19,_0x36d558){return db[_0x7042('0x2a')][_0x7042('0x4a')]({'where':{'id':_0x18b18d[_0x7042('0x41')]['id']}})['then'](handleEntityNotFound(_0x4aed19,null))[_0x7042('0x21')](function(_0x5cfdaf){if(_0x5cfdaf){return _0x5cfdaf[_0x7042('0x8f')](_0x18b18d['query']['ids']);}})[_0x7042('0x21')](function(_0x3929db){if(_0x3929db){return db[_0x7042('0x60')][_0x7042('0x22')]({'where':{'ListId':_0x18b18d[_0x7042('0x2e')][_0x7042('0x66')],'CampaignId':_0x18b18d[_0x7042('0x41')]['id']}})[_0x7042('0x21')](function(){return _0x3929db;});}})['then'](respondWithStatusCode(_0x4aed19,null))['catch'](handleError(_0x4aed19,null));};