[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 _0xb226=['zip-dir','request-promise','bluebird','mustache','util','path','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','querystring','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','offset','undefined','limit','count','set','Content-Range','apply','reject','update','then','get','UserProfileResource','name','send','index','map','rawAttributes','fieldName','type','model','keys','query','intersection','fields','attributes','hasOwnProperty','order','sort','filters','pick','merge','where','VIRTUAL','filter','options','Campaign','includeAll','include','findAll','catch','show','params','length','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','UserProfileSection','userProfileId','autoAssociation','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','omit','createdAt','updatedAt','destroy','getHoppers','findOne','nolimit','CmHopper','rows','getHopperHistories','CmHopperHistory','getHopperFinals','CmHopperFinal','getHopperBlacks','CmHopperBlack','CampaignId','getLists','CmList','addLists','format','ids','spread','dialCheckDuplicateType','always','into','cm_hopper','phone','scheduledAt','ContactId','ListId','select','field','CmListId','toString','cm_contacts','deletedAt\x20IS\x20NULL','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','COALESCE(calleridnum,\x27\x27)','from','CampaignId\x20=\x20?','COALESCE(phone,\x27\x27)','insert','fromQuery','ListId\x20=\x20?','OrderBy','h.id','NOW()','ci.item','ci.OrderBY','join','h.createdAt\x20=\x20?','push','sequelize','all','removeLists','getBlackLists','addBlackLists','YYYY-MM-DD\x20HH:mm:ss','cm_hopper_black','removeBlackLists','eml-format','rimraf'];(function(_0x3b4c39,_0x264c16){var _0x1d3fe1=function(_0x3a9664){while(--_0x3a9664){_0x3b4c39['push'](_0x3b4c39['shift']());}};_0x1d3fe1(++_0x264c16);}(_0xb226,0x11c));var _0x6b22=function(_0xab567d,_0x1874c0){_0xab567d=_0xab567d-0x0;var _0x144513=_0xb226[_0xab567d];return _0x144513;};'use strict';var emlformat=require(_0x6b22('0x0'));var rimraf=require(_0x6b22('0x1'));var zipdir=require(_0x6b22('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x6b22('0x3'));var moment=require('moment');var BPromise=require(_0x6b22('0x4'));var Mustache=require(_0x6b22('0x5'));var util=require(_0x6b22('0x6'));var path=require(_0x6b22('0x7'));var sox=require('sox');var csv=require(_0x6b22('0x8'));var ejs=require(_0x6b22('0x9'));var fs=require('fs');var fs_extra=require(_0x6b22('0xa'));var _=require(_0x6b22('0xb'));var squel=require(_0x6b22('0xc'));var crypto=require(_0x6b22('0xd'));var jsforce=require(_0x6b22('0xe'));var deskjs=require(_0x6b22('0xf'));var toCsv=require(_0x6b22('0x8'));var querystring=require(_0x6b22('0x10'));var Papa=require('papaparse');var Redis=require(_0x6b22('0x11'));var authService=require('../../components/auth/service');var qs=require(_0x6b22('0x12'));var as=require(_0x6b22('0x13'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x6b22('0x14'))('api');var utils=require(_0x6b22('0x15'));var config=require(_0x6b22('0x16'));var licenseUtil=require(_0x6b22('0x17'));var db=require(_0x6b22('0x18'))['db'];function respondWithStatusCode(_0x1d3e25,_0x2ad007){_0x2ad007=_0x2ad007||0xcc;return function(_0xe26e19){if(_0xe26e19){return _0x1d3e25[_0x6b22('0x19')](_0x2ad007);}return _0x1d3e25[_0x6b22('0x1a')](_0x2ad007)[_0x6b22('0x1b')]();};}function respondWithResult(_0x145c00,_0x5d08cb){_0x5d08cb=_0x5d08cb||0xc8;return function(_0x2e6200){if(_0x2e6200){return _0x145c00[_0x6b22('0x1a')](_0x5d08cb)['json'](_0x2e6200);}};}function respondWithFilteredResult(_0x1119c0,_0x47f1e6){return function(_0x51de96){if(_0x51de96){var _0x4b9e43=typeof _0x47f1e6[_0x6b22('0x1c')]===_0x6b22('0x1d')&&typeof _0x47f1e6[_0x6b22('0x1e')]===_0x6b22('0x1d');var _0x4c1ab8=_0x51de96[_0x6b22('0x1f')];var _0x46210a=_0x4b9e43?0x0:_0x47f1e6[_0x6b22('0x1c')];var _0x3666d4=_0x4b9e43?_0x51de96[_0x6b22('0x1f')]:_0x47f1e6[_0x6b22('0x1c')]+_0x47f1e6[_0x6b22('0x1e')];var _0x8af7b4;if(_0x3666d4>=_0x4c1ab8){_0x3666d4=_0x4c1ab8;_0x8af7b4=0xc8;}else{_0x8af7b4=0xce;}_0x1119c0[_0x6b22('0x1a')](_0x8af7b4);return _0x1119c0[_0x6b22('0x20')](_0x6b22('0x21'),_0x46210a+'-'+_0x3666d4+'/'+_0x4c1ab8)['json'](_0x51de96);}return null;};}function patchUpdates(_0x80c585){return function(_0x15882c){try{jsonpatch[_0x6b22('0x22')](_0x15882c,_0x80c585,!![]);}catch(_0x20e2ef){return BPromise[_0x6b22('0x23')](_0x20e2ef);}return _0x15882c['save']();};}function saveUpdates(_0x406b55,_0x81eaeb){return function(_0x2c8022){if(_0x2c8022){return _0x2c8022[_0x6b22('0x24')](_0x406b55)[_0x6b22('0x25')](function(_0x1df743){return _0x1df743;});}return null;};}function removeEntity(_0x29657e,_0x50a54d){return function(_0x2e9984){if(_0x2e9984){return _0x2e9984['destroy']()[_0x6b22('0x25')](function(){var _0x5b31f9=_0x2e9984[_0x6b22('0x26')]({'plain':!![]});var _0x3220fb='IvrCampaigns';return db[_0x6b22('0x27')]['destroy']({'where':{'type':_0x3220fb,'resourceId':_0x5b31f9['id']}})[_0x6b22('0x25')](function(){return _0x2e9984;});})[_0x6b22('0x25')](function(){_0x29657e['status'](0xcc)[_0x6b22('0x1b')]();});}};}function handleEntityNotFound(_0xa34588,_0xaa3c39){return function(_0x43dd3b){if(!_0x43dd3b){_0xa34588['sendStatus'](0x194);}return _0x43dd3b;};}function handleError(_0x4ebc70,_0x4cc9d1){_0x4cc9d1=_0x4cc9d1||0x1f4;return function(_0x5e6cd4){logger['error'](_0x5e6cd4['stack']);if(_0x5e6cd4['name']){delete _0x5e6cd4[_0x6b22('0x28')];}_0x4ebc70[_0x6b22('0x1a')](_0x4cc9d1)[_0x6b22('0x29')](_0x5e6cd4);};}exports[_0x6b22('0x2a')]=function(_0xdf32ca,_0x29568c){var _0xf5c953={},_0x509bbd={},_0x3a0070={'count':0x0,'rows':[]};var _0x339752=_[_0x6b22('0x2b')](db['Campaign'][_0x6b22('0x2c')],function(_0x2da62b){return{'name':_0x2da62b[_0x6b22('0x2d')],'type':_0x2da62b[_0x6b22('0x2e')]['key']};});_0x509bbd[_0x6b22('0x2f')]=_[_0x6b22('0x2b')](_0x339752,'name');_0x509bbd['query']=_[_0x6b22('0x30')](_0xdf32ca[_0x6b22('0x31')]);_0x509bbd['filters']=_[_0x6b22('0x32')](_0x509bbd[_0x6b22('0x2f')],_0x509bbd[_0x6b22('0x31')]);_0xf5c953['attributes']=_[_0x6b22('0x32')](_0x509bbd[_0x6b22('0x2f')],qs[_0x6b22('0x33')](_0xdf32ca[_0x6b22('0x31')][_0x6b22('0x33')]));_0xf5c953[_0x6b22('0x34')]=_0xf5c953[_0x6b22('0x34')]['length']?_0xf5c953[_0x6b22('0x34')]:_0x509bbd['model'];if(!_0xdf32ca[_0x6b22('0x31')][_0x6b22('0x35')]('nolimit')){_0xf5c953['limit']=qs[_0x6b22('0x1e')](_0xdf32ca['query'][_0x6b22('0x1e')]);_0xf5c953[_0x6b22('0x1c')]=qs[_0x6b22('0x1c')](_0xdf32ca[_0x6b22('0x31')]['offset']);}_0xf5c953[_0x6b22('0x36')]=qs[_0x6b22('0x37')](_0xdf32ca[_0x6b22('0x31')][_0x6b22('0x37')]);_0xf5c953['where']=qs[_0x6b22('0x38')](_[_0x6b22('0x39')](_0xdf32ca[_0x6b22('0x31')],_0x509bbd['filters']),_0x339752);if(_0xdf32ca[_0x6b22('0x31')]['filter']){_0xf5c953['where']=_[_0x6b22('0x3a')](_0xf5c953[_0x6b22('0x3b')],{'$or':_['map'](_0x339752,function(_0x272967){if(_0x272967[_0x6b22('0x2e')]!==_0x6b22('0x3c')){var _0x162840={};_0x162840[_0x272967[_0x6b22('0x28')]]={'$like':'%'+_0xdf32ca[_0x6b22('0x31')][_0x6b22('0x3d')]+'%'};return _0x162840;}})});}_0xf5c953=_[_0x6b22('0x3a')]({},_0xf5c953,_0xdf32ca[_0x6b22('0x3e')]);var _0x4c99fa={'where':_0xf5c953[_0x6b22('0x3b')]};return db[_0x6b22('0x3f')][_0x6b22('0x1f')](_0x4c99fa)['then'](function(_0x1e937f){_0x3a0070['count']=_0x1e937f;if(_0xdf32ca['query'][_0x6b22('0x40')]){_0xf5c953[_0x6b22('0x41')]=[{'all':!![]}];}return db[_0x6b22('0x3f')][_0x6b22('0x42')](_0xf5c953);})[_0x6b22('0x25')](function(_0x17b647){_0x3a0070['rows']=_0x17b647;return _0x3a0070;})[_0x6b22('0x25')](respondWithFilteredResult(_0x29568c,_0xf5c953))[_0x6b22('0x43')](handleError(_0x29568c,null));};exports[_0x6b22('0x44')]=function(_0x1e950b,_0x29fb5a){var _0x1dfbf0={'raw':![],'where':{'id':_0x1e950b[_0x6b22('0x45')]['id']}},_0xbacda7={};_0xbacda7[_0x6b22('0x2f')]=_[_0x6b22('0x30')](db[_0x6b22('0x3f')][_0x6b22('0x2c')]);_0xbacda7['query']=_[_0x6b22('0x30')](_0x1e950b[_0x6b22('0x31')]);_0xbacda7[_0x6b22('0x38')]=_[_0x6b22('0x32')](_0xbacda7[_0x6b22('0x2f')],_0xbacda7[_0x6b22('0x31')]);_0x1dfbf0[_0x6b22('0x34')]=_[_0x6b22('0x32')](_0xbacda7[_0x6b22('0x2f')],qs['fields'](_0x1e950b['query']['fields']));_0x1dfbf0[_0x6b22('0x34')]=_0x1dfbf0[_0x6b22('0x34')][_0x6b22('0x46')]?_0x1dfbf0['attributes']:_0xbacda7[_0x6b22('0x2f')];if(_0x1e950b[_0x6b22('0x31')][_0x6b22('0x40')]){_0x1dfbf0[_0x6b22('0x41')]=[{'all':!![]}];}_0x1dfbf0=_['merge']({},_0x1dfbf0,_0x1e950b[_0x6b22('0x3e')]);return db[_0x6b22('0x3f')][_0x6b22('0x47')](_0x1dfbf0)['then'](handleEntityNotFound(_0x29fb5a,null))[_0x6b22('0x25')](respondWithResult(_0x29fb5a,null))[_0x6b22('0x43')](handleError(_0x29fb5a,null));};exports[_0x6b22('0x48')]=function(_0x52ab18,_0x3bc72c){return db[_0x6b22('0x3f')][_0x6b22('0x48')](_0x52ab18[_0x6b22('0x49')],{})['then'](function(_0x4291db){var _0x46aa98=_0x52ab18[_0x6b22('0x4a')]['get']({'plain':!![]});if(!_0x46aa98)throw new Error(_0x6b22('0x4b'));if(_0x46aa98['role']===_0x6b22('0x4a')){var _0xf23059=_0x4291db[_0x6b22('0x26')]({'plain':!![]});var _0x55949c='IvrCampaigns';return db[_0x6b22('0x4c')][_0x6b22('0x47')]({'where':{'name':_0x55949c,'userProfileId':_0x46aa98[_0x6b22('0x4d')]},'raw':!![]})[_0x6b22('0x25')](function(_0x115c33){if(_0x115c33&&_0x115c33[_0x6b22('0x4e')]===0x0){return db[_0x6b22('0x27')][_0x6b22('0x48')]({'name':_0xf23059[_0x6b22('0x28')],'resourceId':_0xf23059['id'],'type':_0x115c33[_0x6b22('0x28')],'sectionId':_0x115c33['id']},{})[_0x6b22('0x25')](function(){return _0x4291db;});}else{return _0x4291db;}})[_0x6b22('0x43')](function(_0x5c5588){logger[_0x6b22('0x4f')](_0x6b22('0x50'),_0x5c5588);throw _0x5c5588;});}return _0x4291db;})[_0x6b22('0x25')](respondWithResult(_0x3bc72c,0xc9))[_0x6b22('0x43')](handleError(_0x3bc72c,null));};exports[_0x6b22('0x51')]=function(_0x47b58f,_0x9ec569){var _0x1391c2={'where':{'id':_0x47b58f[_0x6b22('0x45')]['id']}},_0x3c626b={};_0x3c626b[_0x6b22('0x2f')]=_[_0x6b22('0x30')](db[_0x6b22('0x3f')]['rawAttributes']);_0x1391c2['attributes']=_['intersection'](_0x3c626b['model'],qs[_0x6b22('0x33')](_0x47b58f[_0x6b22('0x31')][_0x6b22('0x33')]));_0x1391c2['attributes']=_0x1391c2['attributes'][_0x6b22('0x46')]?_0x1391c2[_0x6b22('0x34')]:_0x3c626b['model'];if(_0x47b58f[_0x6b22('0x31')][_0x6b22('0x40')]){_0x1391c2['include']=[{'all':!![]}];}_0x1391c2=_['merge']({},_0x1391c2,_0x47b58f[_0x6b22('0x3e')]);return db[_0x6b22('0x3f')][_0x6b22('0x47')](_0x1391c2)[_0x6b22('0x25')](handleEntityNotFound(_0x9ec569,null))[_0x6b22('0x25')](function(_0x54fba9){if(_0x54fba9){var _0x5a8bcb=_0x54fba9[_0x6b22('0x26')]({'plain':!![]});_0x5a8bcb=qs[_0x6b22('0x52')](_0x5a8bcb,['id',_0x6b22('0x53'),'updatedAt']);_0x47b58f[_0x6b22('0x49')]=_[_0x6b22('0x52')](_0x47b58f[_0x6b22('0x49')],['id',_0x6b22('0x53'),_0x6b22('0x54')]);return db['Campaign'][_0x6b22('0x48')](_[_0x6b22('0x3a')](_0x5a8bcb,_0x47b58f[_0x6b22('0x49')]),{'include':_0x47b58f[_0x6b22('0x31')]['includeAll']?[{'all':!![]}]:undefined})[_0x6b22('0x25')](function(_0x3d14f7){var _0x4c16dd=_0x47b58f[_0x6b22('0x4a')][_0x6b22('0x26')]({'plain':!![]});if(!_0x4c16dd)throw new Error(_0x6b22('0x4b'));if(_0x4c16dd['role']===_0x6b22('0x4a')){var _0x11d181=_0x3d14f7[_0x6b22('0x26')]({'plain':!![]});var _0x1143cc='IvrCampaigns';return db['UserProfileSection'][_0x6b22('0x47')]({'where':{'name':_0x1143cc,'userProfileId':_0x4c16dd[_0x6b22('0x4d')]},'raw':!![]})[_0x6b22('0x25')](function(_0x5c3533){if(_0x5c3533&&_0x5c3533[_0x6b22('0x4e')]===0x0){return db['UserProfileResource'][_0x6b22('0x48')]({'name':_0x11d181['name'],'resourceId':_0x11d181['id'],'type':_0x5c3533[_0x6b22('0x28')],'sectionId':_0x5c3533['id']},{})[_0x6b22('0x25')](function(){return _0x3d14f7;});}else{return _0x3d14f7;}})[_0x6b22('0x43')](function(_0x2e926b){logger['error']('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x2e926b);throw _0x2e926b;});}return _0x3d14f7;});}})[_0x6b22('0x25')](respondWithResult(_0x9ec569,0xc9))['catch'](handleError(_0x9ec569,null));};exports[_0x6b22('0x24')]=function(_0x54fcb9,_0x1c6a3b){if(_0x54fcb9[_0x6b22('0x49')]['id']){delete _0x54fcb9[_0x6b22('0x49')]['id'];}return db['Campaign'][_0x6b22('0x47')]({'where':{'id':_0x54fcb9[_0x6b22('0x45')]['id']}})[_0x6b22('0x25')](handleEntityNotFound(_0x1c6a3b,null))[_0x6b22('0x25')](saveUpdates(_0x54fcb9['body'],null))[_0x6b22('0x25')](respondWithResult(_0x1c6a3b,null))['catch'](handleError(_0x1c6a3b,null));};exports[_0x6b22('0x55')]=function(_0x149ad2,_0x20d36a){return db['Campaign'][_0x6b22('0x47')]({'where':{'id':_0x149ad2[_0x6b22('0x45')]['id']}})[_0x6b22('0x25')](handleEntityNotFound(_0x20d36a,null))[_0x6b22('0x25')](removeEntity(_0x20d36a,null))[_0x6b22('0x43')](handleError(_0x20d36a,null));};exports[_0x6b22('0x56')]=function(_0x1a4f5c,_0x53f532,_0x4b0e27){var _0x51a45f={'raw':!![],'where':{}};var _0x3a7b95={};var _0x41bbfd={'count':0x0,'rows':[]};return db[_0x6b22('0x3f')][_0x6b22('0x57')]({'where':{'id':_0x1a4f5c[_0x6b22('0x45')]['id']}})[_0x6b22('0x25')](handleEntityNotFound(_0x53f532,null))['then'](function(_0x2d79b4){if(_0x2d79b4){_0x3a7b95[_0x6b22('0x2f')]=_[_0x6b22('0x30')](db['CmHopper'][_0x6b22('0x2c')]);_0x3a7b95['query']=_[_0x6b22('0x30')](_0x1a4f5c[_0x6b22('0x31')]);_0x3a7b95['filters']=_[_0x6b22('0x32')](_0x3a7b95[_0x6b22('0x2f')],_0x3a7b95[_0x6b22('0x31')]);_0x51a45f[_0x6b22('0x34')]=_[_0x6b22('0x32')](_0x3a7b95[_0x6b22('0x2f')],qs['fields'](_0x1a4f5c['query'][_0x6b22('0x33')]));_0x51a45f[_0x6b22('0x34')]=_0x51a45f[_0x6b22('0x34')][_0x6b22('0x46')]?_0x51a45f[_0x6b22('0x34')]:_0x3a7b95[_0x6b22('0x2f')];if(!_0x1a4f5c[_0x6b22('0x31')][_0x6b22('0x35')](_0x6b22('0x58'))){_0x51a45f[_0x6b22('0x1e')]=qs[_0x6b22('0x1e')](_0x1a4f5c[_0x6b22('0x31')][_0x6b22('0x1e')]);_0x51a45f[_0x6b22('0x1c')]=qs[_0x6b22('0x1c')](_0x1a4f5c['query'][_0x6b22('0x1c')]);}_0x51a45f[_0x6b22('0x36')]=qs[_0x6b22('0x37')](_0x1a4f5c[_0x6b22('0x31')][_0x6b22('0x37')]);_0x51a45f[_0x6b22('0x3b')]=qs[_0x6b22('0x38')](_[_0x6b22('0x39')](_0x1a4f5c['query'],_0x3a7b95[_0x6b22('0x38')]));_0x51a45f[_0x6b22('0x3b')]['CampaignId']=_0x2d79b4['id'];if(_0x1a4f5c[_0x6b22('0x31')][_0x6b22('0x3d')]){_0x51a45f[_0x6b22('0x3b')]=_[_0x6b22('0x3a')](_0x51a45f[_0x6b22('0x3b')],{'$or':_[_0x6b22('0x2b')](_0x51a45f[_0x6b22('0x34')],function(_0x5157eb){var _0x4100dd={};_0x4100dd[_0x5157eb]={'$like':'%'+_0x1a4f5c[_0x6b22('0x31')][_0x6b22('0x3d')]+'%'};return _0x4100dd;})});}_0x51a45f=_[_0x6b22('0x3a')]({},_0x51a45f,_0x1a4f5c[_0x6b22('0x3e')]);return db[_0x6b22('0x59')][_0x6b22('0x1f')]({'where':_0x51a45f[_0x6b22('0x3b')]})['then'](function(_0x4656f0){_0x41bbfd[_0x6b22('0x1f')]=_0x4656f0;if(_0x1a4f5c[_0x6b22('0x31')][_0x6b22('0x40')]){_0x51a45f[_0x6b22('0x41')]=[{'all':!![]}];}return db[_0x6b22('0x59')][_0x6b22('0x42')](_0x51a45f);})['then'](function(_0x9ef97f){_0x41bbfd[_0x6b22('0x5a')]=_0x9ef97f;return _0x41bbfd;});}})[_0x6b22('0x25')](respondWithFilteredResult(_0x53f532,_0x51a45f))[_0x6b22('0x43')](handleError(_0x53f532,null));};exports[_0x6b22('0x5b')]=function(_0x52703c,_0x19ce26,_0x5e2d9e){var _0x115238={'raw':!![],'where':{}};var _0x5698b2={};var _0x3de7c7={'count':0x0,'rows':[]};return db['Campaign'][_0x6b22('0x57')]({'where':{'id':_0x52703c[_0x6b22('0x45')]['id']}})[_0x6b22('0x25')](handleEntityNotFound(_0x19ce26,null))[_0x6b22('0x25')](function(_0x2b7930){if(_0x2b7930){_0x5698b2[_0x6b22('0x2f')]=_['keys'](db[_0x6b22('0x5c')][_0x6b22('0x2c')]);_0x5698b2[_0x6b22('0x31')]=_[_0x6b22('0x30')](_0x52703c[_0x6b22('0x31')]);_0x5698b2[_0x6b22('0x38')]=_['intersection'](_0x5698b2[_0x6b22('0x2f')],_0x5698b2['query']);_0x115238[_0x6b22('0x34')]=_['intersection'](_0x5698b2[_0x6b22('0x2f')],qs['fields'](_0x52703c['query']['fields']));_0x115238[_0x6b22('0x34')]=_0x115238[_0x6b22('0x34')][_0x6b22('0x46')]?_0x115238[_0x6b22('0x34')]:_0x5698b2[_0x6b22('0x2f')];if(!_0x52703c[_0x6b22('0x31')][_0x6b22('0x35')]('nolimit')){_0x115238[_0x6b22('0x1e')]=qs['limit'](_0x52703c[_0x6b22('0x31')][_0x6b22('0x1e')]);_0x115238[_0x6b22('0x1c')]=qs[_0x6b22('0x1c')](_0x52703c[_0x6b22('0x31')]['offset']);}_0x115238[_0x6b22('0x36')]=qs[_0x6b22('0x37')](_0x52703c['query'][_0x6b22('0x37')]);_0x115238[_0x6b22('0x3b')]=qs[_0x6b22('0x38')](_['pick'](_0x52703c[_0x6b22('0x31')],_0x5698b2[_0x6b22('0x38')]));_0x115238[_0x6b22('0x3b')]['CampaignId']=_0x2b7930['id'];if(_0x52703c[_0x6b22('0x31')][_0x6b22('0x3d')]){_0x115238[_0x6b22('0x3b')]=_[_0x6b22('0x3a')](_0x115238[_0x6b22('0x3b')],{'$or':_[_0x6b22('0x2b')](_0x115238[_0x6b22('0x34')],function(_0xac1035){var _0x491948={};_0x491948[_0xac1035]={'$like':'%'+_0x52703c[_0x6b22('0x31')][_0x6b22('0x3d')]+'%'};return _0x491948;})});}_0x115238=_[_0x6b22('0x3a')]({},_0x115238,_0x52703c['options']);return db[_0x6b22('0x5c')][_0x6b22('0x1f')]({'where':_0x115238[_0x6b22('0x3b')]})['then'](function(_0x161b81){_0x3de7c7[_0x6b22('0x1f')]=_0x161b81;if(_0x52703c[_0x6b22('0x31')][_0x6b22('0x40')]){_0x115238[_0x6b22('0x41')]=[{'all':!![]}];}return db[_0x6b22('0x5c')][_0x6b22('0x42')](_0x115238);})[_0x6b22('0x25')](function(_0x21268a){_0x3de7c7[_0x6b22('0x5a')]=_0x21268a;return _0x3de7c7;});}})[_0x6b22('0x25')](respondWithFilteredResult(_0x19ce26,_0x115238))['catch'](handleError(_0x19ce26,null));};exports[_0x6b22('0x5d')]=function(_0x275086,_0x17223e,_0x2176b0){var _0x5cf4dc={'raw':!![],'where':{}};var _0x257576={};var _0x2b2319={'count':0x0,'rows':[]};return db[_0x6b22('0x3f')][_0x6b22('0x57')]({'where':{'id':_0x275086[_0x6b22('0x45')]['id']}})[_0x6b22('0x25')](handleEntityNotFound(_0x17223e,null))[_0x6b22('0x25')](function(_0x180ec7){if(_0x180ec7){_0x257576[_0x6b22('0x2f')]=_[_0x6b22('0x30')](db[_0x6b22('0x5e')][_0x6b22('0x2c')]);_0x257576['query']=_[_0x6b22('0x30')](_0x275086[_0x6b22('0x31')]);_0x257576[_0x6b22('0x38')]=_['intersection'](_0x257576[_0x6b22('0x2f')],_0x257576[_0x6b22('0x31')]);_0x5cf4dc[_0x6b22('0x34')]=_[_0x6b22('0x32')](_0x257576[_0x6b22('0x2f')],qs[_0x6b22('0x33')](_0x275086[_0x6b22('0x31')][_0x6b22('0x33')]));_0x5cf4dc[_0x6b22('0x34')]=_0x5cf4dc[_0x6b22('0x34')][_0x6b22('0x46')]?_0x5cf4dc['attributes']:_0x257576[_0x6b22('0x2f')];if(!_0x275086[_0x6b22('0x31')][_0x6b22('0x35')](_0x6b22('0x58'))){_0x5cf4dc[_0x6b22('0x1e')]=qs[_0x6b22('0x1e')](_0x275086['query']['limit']);_0x5cf4dc[_0x6b22('0x1c')]=qs[_0x6b22('0x1c')](_0x275086[_0x6b22('0x31')][_0x6b22('0x1c')]);}_0x5cf4dc[_0x6b22('0x36')]=qs[_0x6b22('0x37')](_0x275086[_0x6b22('0x31')][_0x6b22('0x37')]);_0x5cf4dc['where']=qs[_0x6b22('0x38')](_[_0x6b22('0x39')](_0x275086['query'],_0x257576[_0x6b22('0x38')]));_0x5cf4dc[_0x6b22('0x3b')]['CampaignId']=_0x180ec7['id'];if(_0x275086[_0x6b22('0x31')]['filter']){_0x5cf4dc['where']=_[_0x6b22('0x3a')](_0x5cf4dc[_0x6b22('0x3b')],{'$or':_[_0x6b22('0x2b')](_0x5cf4dc[_0x6b22('0x34')],function(_0xea7953){var _0x567691={};_0x567691[_0xea7953]={'$like':'%'+_0x275086[_0x6b22('0x31')]['filter']+'%'};return _0x567691;})});}_0x5cf4dc=_[_0x6b22('0x3a')]({},_0x5cf4dc,_0x275086[_0x6b22('0x3e')]);return db[_0x6b22('0x5e')][_0x6b22('0x1f')]({'where':_0x5cf4dc['where']})[_0x6b22('0x25')](function(_0x16bf7c){_0x2b2319[_0x6b22('0x1f')]=_0x16bf7c;if(_0x275086[_0x6b22('0x31')][_0x6b22('0x40')]){_0x5cf4dc['include']=[{'all':!![]}];}return db[_0x6b22('0x5e')][_0x6b22('0x42')](_0x5cf4dc);})[_0x6b22('0x25')](function(_0x3d904a){_0x2b2319[_0x6b22('0x5a')]=_0x3d904a;return _0x2b2319;});}})['then'](respondWithFilteredResult(_0x17223e,_0x5cf4dc))[_0x6b22('0x43')](handleError(_0x17223e,null));};exports[_0x6b22('0x5f')]=function(_0x2337f2,_0x373ba1,_0x199224){var _0x417c0d={'raw':!![],'where':{}};var _0x3984b6={};var _0x2e3615={'count':0x0,'rows':[]};return db[_0x6b22('0x3f')]['findOne']({'where':{'id':_0x2337f2[_0x6b22('0x45')]['id']}})[_0x6b22('0x25')](handleEntityNotFound(_0x373ba1,null))[_0x6b22('0x25')](function(_0x16735f){if(_0x16735f){_0x3984b6[_0x6b22('0x2f')]=_[_0x6b22('0x30')](db[_0x6b22('0x60')]['rawAttributes']);_0x3984b6[_0x6b22('0x31')]=_[_0x6b22('0x30')](_0x2337f2['query']);_0x3984b6[_0x6b22('0x38')]=_[_0x6b22('0x32')](_0x3984b6[_0x6b22('0x2f')],_0x3984b6[_0x6b22('0x31')]);_0x417c0d[_0x6b22('0x34')]=_[_0x6b22('0x32')](_0x3984b6[_0x6b22('0x2f')],qs[_0x6b22('0x33')](_0x2337f2[_0x6b22('0x31')][_0x6b22('0x33')]));_0x417c0d[_0x6b22('0x34')]=_0x417c0d[_0x6b22('0x34')][_0x6b22('0x46')]?_0x417c0d[_0x6b22('0x34')]:_0x3984b6[_0x6b22('0x2f')];if(!_0x2337f2['query']['hasOwnProperty'](_0x6b22('0x58'))){_0x417c0d[_0x6b22('0x1e')]=qs[_0x6b22('0x1e')](_0x2337f2['query'][_0x6b22('0x1e')]);_0x417c0d['offset']=qs[_0x6b22('0x1c')](_0x2337f2[_0x6b22('0x31')][_0x6b22('0x1c')]);}_0x417c0d[_0x6b22('0x36')]=qs[_0x6b22('0x37')](_0x2337f2[_0x6b22('0x31')]['sort']);_0x417c0d[_0x6b22('0x3b')]=qs[_0x6b22('0x38')](_[_0x6b22('0x39')](_0x2337f2[_0x6b22('0x31')],_0x3984b6[_0x6b22('0x38')]));_0x417c0d[_0x6b22('0x3b')][_0x6b22('0x61')]=_0x16735f['id'];if(_0x2337f2[_0x6b22('0x31')][_0x6b22('0x3d')]){_0x417c0d[_0x6b22('0x3b')]=_[_0x6b22('0x3a')](_0x417c0d[_0x6b22('0x3b')],{'$or':_[_0x6b22('0x2b')](_0x417c0d[_0x6b22('0x34')],function(_0x327d03){var _0x325a9e={};_0x325a9e[_0x327d03]={'$like':'%'+_0x2337f2['query'][_0x6b22('0x3d')]+'%'};return _0x325a9e;})});}_0x417c0d=_[_0x6b22('0x3a')]({},_0x417c0d,_0x2337f2[_0x6b22('0x3e')]);return db[_0x6b22('0x60')][_0x6b22('0x1f')]({'where':_0x417c0d[_0x6b22('0x3b')]})['then'](function(_0x3272f1){_0x2e3615[_0x6b22('0x1f')]=_0x3272f1;if(_0x2337f2[_0x6b22('0x31')]['includeAll']){_0x417c0d['include']=[{'all':!![]}];}return db['CmHopperBlack'][_0x6b22('0x42')](_0x417c0d);})['then'](function(_0x371a9c){_0x2e3615[_0x6b22('0x5a')]=_0x371a9c;return _0x2e3615;});}})[_0x6b22('0x25')](respondWithFilteredResult(_0x373ba1,_0x417c0d))[_0x6b22('0x43')](handleError(_0x373ba1,null));};exports[_0x6b22('0x62')]=function(_0x1a6385,_0x382e5a,_0x52e072){var _0x221caf={};var _0x32aaaf={};var _0x4a3d10;var _0x3c68bb;return db[_0x6b22('0x3f')][_0x6b22('0x57')]({'where':{'id':_0x1a6385[_0x6b22('0x45')]['id']}})[_0x6b22('0x25')](handleEntityNotFound(_0x382e5a,null))[_0x6b22('0x25')](function(_0x5c07c1){if(_0x5c07c1){_0x4a3d10=_0x5c07c1;_0x32aaaf[_0x6b22('0x2f')]=_[_0x6b22('0x30')](db[_0x6b22('0x63')][_0x6b22('0x2c')]);_0x32aaaf[_0x6b22('0x31')]=_[_0x6b22('0x30')](_0x1a6385[_0x6b22('0x31')]);_0x32aaaf[_0x6b22('0x38')]=_[_0x6b22('0x32')](_0x32aaaf[_0x6b22('0x2f')],_0x32aaaf[_0x6b22('0x31')]);_0x221caf[_0x6b22('0x34')]=_[_0x6b22('0x32')](_0x32aaaf[_0x6b22('0x2f')],qs[_0x6b22('0x33')](_0x1a6385['query'][_0x6b22('0x33')]));_0x221caf[_0x6b22('0x34')]=_0x221caf['attributes'][_0x6b22('0x46')]?_0x221caf['attributes']:_0x32aaaf[_0x6b22('0x2f')];_0x221caf['order']=qs[_0x6b22('0x37')](_0x1a6385['query'][_0x6b22('0x37')]);_0x221caf[_0x6b22('0x3b')]=qs[_0x6b22('0x38')](_[_0x6b22('0x39')](_0x1a6385[_0x6b22('0x31')],_0x32aaaf['filters']));if(_0x1a6385[_0x6b22('0x31')][_0x6b22('0x3d')]){_0x221caf[_0x6b22('0x3b')]=_[_0x6b22('0x3a')](_0x221caf[_0x6b22('0x3b')],{'$or':_[_0x6b22('0x2b')](_0x221caf[_0x6b22('0x34')],function(_0x380dff){var _0x98af4f={};_0x98af4f[_0x380dff]={'$like':'%'+_0x1a6385[_0x6b22('0x31')][_0x6b22('0x3d')]+'%'};return _0x98af4f;})});}_0x221caf=_[_0x6b22('0x3a')]({},_0x221caf,_0x1a6385['options']);return _0x4a3d10[_0x6b22('0x62')](_0x221caf);}})[_0x6b22('0x25')](function(_0x3a33a6){if(_0x3a33a6){_0x3c68bb=_0x3a33a6[_0x6b22('0x46')];if(!_0x1a6385['query'][_0x6b22('0x35')](_0x6b22('0x58'))){_0x221caf['limit']=qs['limit'](_0x1a6385[_0x6b22('0x31')]['limit']);_0x221caf[_0x6b22('0x1c')]=qs[_0x6b22('0x1c')](_0x1a6385[_0x6b22('0x31')][_0x6b22('0x1c')]);}return _0x4a3d10[_0x6b22('0x62')](_0x221caf);}})[_0x6b22('0x25')](function(_0x509475){if(_0x509475){return _0x509475?{'count':_0x3c68bb,'rows':_0x509475}:null;}})[_0x6b22('0x25')](respondWithResult(_0x382e5a,null))['catch'](handleError(_0x382e5a,null));};exports[_0x6b22('0x64')]=function(_0x31dac8,_0x160f81,_0x26216b){var _0x1c5f81,_0x2b09de;var _0x32590c=[];var _0xfcb567=moment()[_0x6b22('0x65')]('YYYY-MM-DD\x20HH:mm:ss');return db[_0x6b22('0x3f')][_0x6b22('0x47')]({'where':{'id':_0x31dac8[_0x6b22('0x45')]['id']}})[_0x6b22('0x25')](handleEntityNotFound(_0x160f81,null))[_0x6b22('0x25')](function(_0x272287){if(_0x272287){_0x2b09de=_0x272287;return _0x272287[_0x6b22('0x64')](_0x31dac8['body'][_0x6b22('0x66')],_['omit'](_0x31dac8[_0x6b22('0x49')],[_0x6b22('0x66'),'id'])||{});}return null;})[_0x6b22('0x67')](function(_0xb9b3ec){var _0xbdbd08;var _0x196481;_0x1c5f81=_0xb9b3ec||[];var _0x198c5a=[];if(_0xb9b3ec){for(var _0x41f7ac=0x0;_0x41f7ac<_0xb9b3ec[_0x6b22('0x46')];_0x41f7ac+=0x1){var _0x1a12e4=_0xb9b3ec[_0x41f7ac][_0x6b22('0x26')]({'plain':!![]});_0x2b09de['dialCheckDuplicateType']=_0x31dac8[_0x6b22('0x49')][_0x6b22('0x68')]?_0x31dac8['body'][_0x6b22('0x68')]:_0x2b09de['dialCheckDuplicateType'];switch(_0x2b09de[_0x6b22('0x68')]){case _0x6b22('0x69'):_0xbdbd08=squel['insert']()[_0x6b22('0x6a')](_0x6b22('0x6b'))['fromQuery']([_0x6b22('0x6c'),_0x6b22('0x6d'),_0x6b22('0x6e'),_0x6b22('0x6f'),_0x6b22('0x61'),_0x6b22('0x53'),'updatedAt'],squel[_0x6b22('0x70')]()[_0x6b22('0x71')](_0x6b22('0x6c'),'phone')[_0x6b22('0x71')]('NOW()','scheduledAt')[_0x6b22('0x71')]('id',_0x6b22('0x6e'))['field'](_0x1a12e4[_0x6b22('0x72')]['toString'](),_0x6b22('0x6f'))[_0x6b22('0x71')](_0x31dac8['params']['id'][_0x6b22('0x73')](),_0x6b22('0x61'))['field']('\x27'+_0xfcb567+'\x27',_0x6b22('0x53'))['field']('\x27'+_0xfcb567+'\x27',_0x6b22('0x54'))['from'](_0x6b22('0x74'))[_0x6b22('0x3b')](_0x6b22('0x75'))[_0x6b22('0x3b')]('ListId\x20=\x20?',_0x1a12e4['CmListId']['toString']())[_0x6b22('0x3b')](_0x6b22('0x76'))[_0x6b22('0x3b')](_0x6b22('0x77'),squel[_0x6b22('0x70')]()[_0x6b22('0x71')](_0x6b22('0x78'))[_0x6b22('0x79')]('cm_hopper_final')[_0x6b22('0x3b')](_0x6b22('0x7a'),_0x31dac8['params']['id'][_0x6b22('0x73')]()))[_0x6b22('0x3b')](_0x6b22('0x77'),squel[_0x6b22('0x70')]()[_0x6b22('0x71')](_0x6b22('0x7b'))[_0x6b22('0x79')](_0x6b22('0x6b'))['where'](_0x6b22('0x7a'),_0x31dac8[_0x6b22('0x45')]['id'][_0x6b22('0x73')]())))[_0x6b22('0x73')]();break;case'onlyIfOpen':_0xbdbd08=squel[_0x6b22('0x7c')]()['into'](_0x6b22('0x6b'))['fromQuery']([_0x6b22('0x6c'),_0x6b22('0x6d'),'ContactId','ListId',_0x6b22('0x61'),_0x6b22('0x53'),_0x6b22('0x54')],squel[_0x6b22('0x70')]()['field'](_0x6b22('0x6c'),'phone')[_0x6b22('0x71')]('NOW()',_0x6b22('0x6d'))[_0x6b22('0x71')]('id','ContactId')['field'](_0x1a12e4['CmListId'][_0x6b22('0x73')](),_0x6b22('0x6f'))['field'](_0x31dac8[_0x6b22('0x45')]['id'][_0x6b22('0x73')](),_0x6b22('0x61'))[_0x6b22('0x71')]('\x27'+_0xfcb567+'\x27',_0x6b22('0x53'))['field']('\x27'+_0xfcb567+'\x27',_0x6b22('0x54'))[_0x6b22('0x79')]('cm_contacts')[_0x6b22('0x3b')](_0x6b22('0x75'))[_0x6b22('0x3b')]('ListId\x20=\x20?',_0x1a12e4[_0x6b22('0x72')][_0x6b22('0x73')]())['where'](_0x6b22('0x76'))['where'](_0x6b22('0x77'),squel[_0x6b22('0x70')]()[_0x6b22('0x71')](_0x6b22('0x7b'))[_0x6b22('0x79')](_0x6b22('0x6b'))[_0x6b22('0x3b')](_0x6b22('0x7a'),_0x31dac8[_0x6b22('0x45')]['id'][_0x6b22('0x73')]())))['toString']();break;default:_0xbdbd08=squel[_0x6b22('0x7c')]()['into'](_0x6b22('0x6b'))[_0x6b22('0x7d')](['phone','scheduledAt',_0x6b22('0x6e'),_0x6b22('0x6f'),_0x6b22('0x61'),'createdAt',_0x6b22('0x54')],squel['select']()[_0x6b22('0x71')](_0x6b22('0x6c'),_0x6b22('0x6c'))['field']('NOW()',_0x6b22('0x6d'))[_0x6b22('0x71')]('id',_0x6b22('0x6e'))[_0x6b22('0x71')](_0x1a12e4[_0x6b22('0x72')][_0x6b22('0x73')](),_0x6b22('0x6f'))[_0x6b22('0x71')](_0x31dac8[_0x6b22('0x45')]['id'][_0x6b22('0x73')](),_0x6b22('0x61'))['field']('\x27'+_0xfcb567+'\x27',_0x6b22('0x53'))[_0x6b22('0x71')]('\x27'+_0xfcb567+'\x27',_0x6b22('0x54'))[_0x6b22('0x79')](_0x6b22('0x74'))['where'](_0x6b22('0x75'))[_0x6b22('0x3b')](_0x6b22('0x7e'),_0x1a12e4['CmListId']['toString']())[_0x6b22('0x3b')]('phone\x20IS\x20NOT\x20NULL'))[_0x6b22('0x73')]();}_0x196481=squel[_0x6b22('0x7c')]()[_0x6b22('0x6a')]('cm_hopper_additional_phones')[_0x6b22('0x7d')](['cmHopperId',_0x6b22('0x6d'),_0x6b22('0x6c'),_0x6b22('0x7f'),'createdAt','updatedAt'],squel[_0x6b22('0x70')]()[_0x6b22('0x71')](_0x6b22('0x80'),'id')['field'](_0x6b22('0x81'),'scheduledAt')[_0x6b22('0x71')](_0x6b22('0x82'),'phone')[_0x6b22('0x71')](_0x6b22('0x83'),_0x6b22('0x7f'))[_0x6b22('0x71')]('\x27'+_0xfcb567+'\x27','createdAt')[_0x6b22('0x71')]('\x27'+_0xfcb567+'\x27',_0x6b22('0x54'))[_0x6b22('0x79')]('cm_contact_has_items','ci')[_0x6b22('0x84')](_0x6b22('0x6b'),'h','h.ContactId\x20=\x20ci.CmContactId')[_0x6b22('0x3b')]('h.ListId\x20=\x20?',_0x1a12e4[_0x6b22('0x72')][_0x6b22('0x73')]())[_0x6b22('0x3b')]('h.CampaignId=?',_0x31dac8['params']['id'][_0x6b22('0x73')]())[_0x6b22('0x3b')](_0x6b22('0x85'),_0xfcb567))[_0x6b22('0x73')]();_0x198c5a[_0x6b22('0x86')](db[_0x6b22('0x87')][_0x6b22('0x31')](_0xbdbd08));_0x32590c[_0x6b22('0x86')](db[_0x6b22('0x87')][_0x6b22('0x31')](_0x196481));}return BPromise[_0x6b22('0x88')](_0x198c5a);}})[_0x6b22('0x25')](function(){return BPromise[_0x6b22('0x88')](_0x32590c);})['then'](function(){return _0x1c5f81;})[_0x6b22('0x25')](respondWithResult(_0x160f81,null))['catch'](handleError(_0x160f81,null));};exports[_0x6b22('0x89')]=function(_0x43a6d6,_0x1f7efa,_0x50a02e){return db[_0x6b22('0x3f')]['find']({'where':{'id':_0x43a6d6[_0x6b22('0x45')]['id']}})[_0x6b22('0x25')](handleEntityNotFound(_0x1f7efa,null))[_0x6b22('0x25')](function(_0x49c9f6){if(_0x49c9f6){return _0x49c9f6[_0x6b22('0x89')](_0x43a6d6['query'][_0x6b22('0x66')]);}})[_0x6b22('0x25')](function(_0x1baf96){if(_0x1baf96){return db[_0x6b22('0x59')]['destroy']({'where':{'ListId':_0x43a6d6[_0x6b22('0x31')][_0x6b22('0x66')],'CampaignId':_0x43a6d6[_0x6b22('0x45')]['id']}})['then'](function(){return _0x1baf96;});}})[_0x6b22('0x25')](respondWithStatusCode(_0x1f7efa,null))[_0x6b22('0x43')](handleError(_0x1f7efa,null));};exports[_0x6b22('0x8a')]=function(_0x4d1217,_0x5f2a3b,_0x4529ec){var _0x4b59ee={};var _0x32ac2e={};var _0x16b852;var _0x1b5a5f;return db['Campaign'][_0x6b22('0x57')]({'where':{'id':_0x4d1217[_0x6b22('0x45')]['id']}})[_0x6b22('0x25')](handleEntityNotFound(_0x5f2a3b,null))[_0x6b22('0x25')](function(_0x3ad18a){if(_0x3ad18a){_0x16b852=_0x3ad18a;_0x32ac2e[_0x6b22('0x2f')]=_[_0x6b22('0x30')](db[_0x6b22('0x63')][_0x6b22('0x2c')]);_0x32ac2e[_0x6b22('0x31')]=_['keys'](_0x4d1217[_0x6b22('0x31')]);_0x32ac2e['filters']=_['intersection'](_0x32ac2e[_0x6b22('0x2f')],_0x32ac2e['query']);_0x4b59ee['attributes']=_['intersection'](_0x32ac2e[_0x6b22('0x2f')],qs[_0x6b22('0x33')](_0x4d1217['query'][_0x6b22('0x33')]));_0x4b59ee[_0x6b22('0x34')]=_0x4b59ee[_0x6b22('0x34')][_0x6b22('0x46')]?_0x4b59ee['attributes']:_0x32ac2e['model'];_0x4b59ee[_0x6b22('0x36')]=qs[_0x6b22('0x37')](_0x4d1217[_0x6b22('0x31')][_0x6b22('0x37')]);_0x4b59ee[_0x6b22('0x3b')]=qs['filters'](_[_0x6b22('0x39')](_0x4d1217[_0x6b22('0x31')],_0x32ac2e[_0x6b22('0x38')]));if(_0x4d1217[_0x6b22('0x31')][_0x6b22('0x3d')]){_0x4b59ee[_0x6b22('0x3b')]=_[_0x6b22('0x3a')](_0x4b59ee[_0x6b22('0x3b')],{'$or':_[_0x6b22('0x2b')](_0x4b59ee[_0x6b22('0x34')],function(_0xc5d0b1){var _0x5adc83={};_0x5adc83[_0xc5d0b1]={'$like':'%'+_0x4d1217[_0x6b22('0x31')][_0x6b22('0x3d')]+'%'};return _0x5adc83;})});}_0x4b59ee=_[_0x6b22('0x3a')]({},_0x4b59ee,_0x4d1217['options']);return _0x16b852['getBlackLists'](_0x4b59ee);}})[_0x6b22('0x25')](function(_0x2d09ac){if(_0x2d09ac){_0x1b5a5f=_0x2d09ac[_0x6b22('0x46')];if(!_0x4d1217['query']['hasOwnProperty'](_0x6b22('0x58'))){_0x4b59ee[_0x6b22('0x1e')]=qs[_0x6b22('0x1e')](_0x4d1217[_0x6b22('0x31')][_0x6b22('0x1e')]);_0x4b59ee[_0x6b22('0x1c')]=qs[_0x6b22('0x1c')](_0x4d1217[_0x6b22('0x31')]['offset']);}return _0x16b852[_0x6b22('0x8a')](_0x4b59ee);}})[_0x6b22('0x25')](function(_0x12ae68){if(_0x12ae68){return _0x12ae68?{'count':_0x1b5a5f,'rows':_0x12ae68}:null;}})['then'](respondWithResult(_0x5f2a3b,null))[_0x6b22('0x43')](handleError(_0x5f2a3b,null));};exports[_0x6b22('0x8b')]=function(_0x3406ab,_0x2ff4db,_0xc35f32){var _0x6b7aa7,_0x437262;var _0x4825ae=[];var _0x5f10dc=moment()['format'](_0x6b22('0x8c'));return db[_0x6b22('0x3f')][_0x6b22('0x47')]({'where':{'id':_0x3406ab[_0x6b22('0x45')]['id']}})[_0x6b22('0x25')](handleEntityNotFound(_0x2ff4db,null))[_0x6b22('0x25')](function(_0x2289e7){if(_0x2289e7){_0x437262=_0x2289e7;return _0x2289e7[_0x6b22('0x8b')](_0x3406ab[_0x6b22('0x49')][_0x6b22('0x66')],_[_0x6b22('0x52')](_0x3406ab[_0x6b22('0x49')],['ids','id'])||{});}return null;})['spread'](function(_0xd0052b){var _0x2e51c9;var _0x11bdd5;_0x6b7aa7=_0xd0052b||[];var _0x167b35=[];if(_0xd0052b){for(var _0x38a4a3=0x0;_0x38a4a3<_0xd0052b[_0x6b22('0x46')];_0x38a4a3+=0x1){var _0x50c069=_0xd0052b[_0x38a4a3]['get']({'plain':!![]});_0x2e51c9=squel[_0x6b22('0x7c')]()['into'](_0x6b22('0x8d'))[_0x6b22('0x7d')](['phone',_0x6b22('0x6e'),_0x6b22('0x6f'),_0x6b22('0x61'),_0x6b22('0x53'),_0x6b22('0x54')],squel[_0x6b22('0x70')]()['field'](_0x6b22('0x6c'),_0x6b22('0x6c'))['field']('id',_0x6b22('0x6e'))[_0x6b22('0x71')](_0x50c069[_0x6b22('0x72')]['toString'](),_0x6b22('0x6f'))[_0x6b22('0x71')](_0x3406ab[_0x6b22('0x45')]['id'][_0x6b22('0x73')](),_0x6b22('0x61'))[_0x6b22('0x71')](_0x6b22('0x81'),_0x6b22('0x53'))[_0x6b22('0x71')](_0x6b22('0x81'),_0x6b22('0x54'))[_0x6b22('0x79')](_0x6b22('0x74'))[_0x6b22('0x3b')](_0x6b22('0x75'))[_0x6b22('0x3b')](_0x6b22('0x7e'),_0x50c069[_0x6b22('0x72')][_0x6b22('0x73')]())[_0x6b22('0x3b')]('phone\x20IS\x20NOT\x20NULL'))[_0x6b22('0x73')]();_0x167b35[_0x6b22('0x86')](db['sequelize'][_0x6b22('0x31')](_0x2e51c9));}return BPromise[_0x6b22('0x88')](_0x167b35);}})[_0x6b22('0x25')](function(){return _0x6b7aa7;})[_0x6b22('0x25')](respondWithResult(_0x2ff4db,null))[_0x6b22('0x43')](handleError(_0x2ff4db,null));};exports[_0x6b22('0x8e')]=function(_0x24d6f5,_0x149067,_0x406362){return db['Campaign'][_0x6b22('0x47')]({'where':{'id':_0x24d6f5[_0x6b22('0x45')]['id']}})['then'](handleEntityNotFound(_0x149067,null))['then'](function(_0x4dca95){if(_0x4dca95){return _0x4dca95[_0x6b22('0x8e')](_0x24d6f5[_0x6b22('0x31')][_0x6b22('0x66')]);}})[_0x6b22('0x25')](function(_0x2f00c4){if(_0x2f00c4){return db[_0x6b22('0x60')][_0x6b22('0x55')]({'where':{'ListId':_0x24d6f5['query'][_0x6b22('0x66')],'CampaignId':_0x24d6f5[_0x6b22('0x45')]['id']}})[_0x6b22('0x25')](function(){return _0x2f00c4;});}})[_0x6b22('0x25')](respondWithStatusCode(_0x149067,null))[_0x6b22('0x43')](handleError(_0x149067,null));};