server/api/campaign/campaign.controller.js

   1 // *************************************************************************
   2 // *                                                                       *
   3 // * xCALLY Motion -  The Omnichannel Contact Center                       *
   4 // * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
   5 // *                                                                       *
   6 // *************************************************************************
   7 // *                                                                       *
   8 // * Email: info@xcally.com                                                *
   9 // * Website: https://www.xcally.com                                       *
  10 // *                                                                       *
  11 // *************************************************************************
  12 // *                                                                       *
  13 // * The SOFTWARE PRODUCT is protected by copyright laws and international *
  14 // * copyright treaties, as well as other intellectual property laws and   *
  15 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
  16 // *                                                                       *
  17 // *************************************************************************
  18 var _0x8107=['api','../../config/utils','../../config/license/util','../../mysqldb','sendStatus','status','json','offset','undefined','limit','count','set','Content-Range','apply','save','update','then','get','IvrCampaigns','UserProfileResource','destroy','name','send','index','Campaign','rawAttributes','fieldName','type','model','map','keys','query','filters','intersection','fields','attributes','length','hasOwnProperty','nolimit','order','sort','filter','where','merge','VIRTUAL','includeAll','findAll','rows','include','options','find','catch','create','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','user','UserProfileSection','userProfileId','autoAssociation','error','params','omit','createdAt','updatedAt','body','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','getHoppers','findOne','pick','CampaignId','CmHopper','CmHopperHistory','getHopperFinals','CmHopperFinal','getHopperBlacks','CmHopperBlack','getLists','CmList','addLists','format','YYYY-MM-DD\x20HH:mm:ss','ids','spread','dialCheckDuplicateType','always','insert','into','fromQuery','phone','scheduledAt','ContactId','select','field','CmListId','toString','ListId','from','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','COALESCE(calleridnum,\x27\x27)','cm_hopper_final','CampaignId\x20=\x20?','phone\x20NOT\x20IN\x20(?)','COALESCE(phone,\x27\x27)','cm_hopper','NOW()','cm_contacts','phone\x20IS\x20NOT\x20NULL','cm_hopper_additional_phones','cmHopperId','OrderBy','h.id','cm_contact_has_items','h.ContactId\x20=\x20ci.CmContactId','h.CampaignId=?','h.createdAt\x20=\x20?','sequelize','all','getBlackLists','addBlackLists','cm_hopper_black','push','removeBlackLists','zip-dir','fast-json-patch','request-promise','moment','bluebird','util','path','sox','fs-extra','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger'];(function(_0x11a379,_0x572c80){var _0xc53c9f=function(_0x4fc488){while(--_0x4fc488){_0x11a379['push'](_0x11a379['shift']());}};_0xc53c9f(++_0x572c80);}(_0x8107,0x109));var _0x7810=function(_0x4dc8fc,_0x27d9a5){_0x4dc8fc=_0x4dc8fc-0x0;var _0x18d77f=_0x8107[_0x4dc8fc];return _0x18d77f;};'use strict';var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require(_0x7810('0x0'));var jsonpatch=require(_0x7810('0x1'));var rp=require(_0x7810('0x2'));var moment=require(_0x7810('0x3'));var BPromise=require(_0x7810('0x4'));var Mustache=require('mustache');var util=require(_0x7810('0x5'));var path=require(_0x7810('0x6'));var sox=require(_0x7810('0x7'));var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x7810('0x8'));var _=require('lodash');var squel=require('squel');var crypto=require(_0x7810('0x9'));var jsforce=require(_0x7810('0xa'));var deskjs=require(_0x7810('0xb'));var toCsv=require('to-csv');var querystring=require(_0x7810('0xc'));var Papa=require(_0x7810('0xd'));var Redis=require(_0x7810('0xe'));var authService=require('../../components/auth/service');var qs=require(_0x7810('0xf'));var as=require(_0x7810('0x10'));var hardwareService=require(_0x7810('0x11'));var logger=require(_0x7810('0x12'))(_0x7810('0x13'));var utils=require(_0x7810('0x14'));var config=require('../../config/environment');var licenseUtil=require(_0x7810('0x15'));var db=require(_0x7810('0x16'))['db'];function respondWithStatusCode(_0x2112c0,_0x3b7067){_0x3b7067=_0x3b7067||0xcc;return function(_0x3cca1b){if(_0x3cca1b){return _0x2112c0[_0x7810('0x17')](_0x3b7067);}return _0x2112c0[_0x7810('0x18')](_0x3b7067)['end']();};}function respondWithResult(_0x1fd34a,_0x5be21f){_0x5be21f=_0x5be21f||0xc8;return function(_0x1bf6e0){if(_0x1bf6e0){return _0x1fd34a['status'](_0x5be21f)[_0x7810('0x19')](_0x1bf6e0);}};}function respondWithFilteredResult(_0x28d6e2,_0xce358){return function(_0x70bb4f){if(_0x70bb4f){var _0x68af0a=typeof _0xce358[_0x7810('0x1a')]===_0x7810('0x1b')&&typeof _0xce358[_0x7810('0x1c')]==='undefined';var _0x13795b=_0x70bb4f['count'];var _0xd55eed=_0x68af0a?0x0:_0xce358[_0x7810('0x1a')];var _0x1fbeed=_0x68af0a?_0x70bb4f[_0x7810('0x1d')]:_0xce358[_0x7810('0x1a')]+_0xce358['limit'];var _0x26f235;if(_0x1fbeed>=_0x13795b){_0x1fbeed=_0x13795b;_0x26f235=0xc8;}else{_0x26f235=0xce;}_0x28d6e2['status'](_0x26f235);return _0x28d6e2[_0x7810('0x1e')](_0x7810('0x1f'),_0xd55eed+'-'+_0x1fbeed+'/'+_0x13795b)[_0x7810('0x19')](_0x70bb4f);}return null;};}function patchUpdates(_0x4290bf){return function(_0x3e5c47){try{jsonpatch[_0x7810('0x20')](_0x3e5c47,_0x4290bf,!![]);}catch(_0x45dd0e){return BPromise['reject'](_0x45dd0e);}return _0x3e5c47[_0x7810('0x21')]();};}function saveUpdates(_0x317dae,_0xd1655d){return function(_0x3233db){if(_0x3233db){return _0x3233db[_0x7810('0x22')](_0x317dae)[_0x7810('0x23')](function(_0x56a6a6){return _0x56a6a6;});}return null;};}function removeEntity(_0x7d74a2,_0x5e1abd){return function(_0x44487f){if(_0x44487f){return _0x44487f['destroy']()[_0x7810('0x23')](function(){var _0x385507=_0x44487f[_0x7810('0x24')]({'plain':!![]});var _0x295ed5=_0x7810('0x25');return db[_0x7810('0x26')][_0x7810('0x27')]({'where':{'type':_0x295ed5,'resourceId':_0x385507['id']}})['then'](function(){return _0x44487f;});})[_0x7810('0x23')](function(){_0x7d74a2[_0x7810('0x18')](0xcc)['end']();});}};}function handleEntityNotFound(_0x1eef42,_0xe5c5d9){return function(_0x180c10){if(!_0x180c10){_0x1eef42[_0x7810('0x17')](0x194);}return _0x180c10;};}function handleError(_0xd00cf6,_0x26425a){_0x26425a=_0x26425a||0x1f4;return function(_0x35edd5){logger['error'](_0x35edd5['stack']);if(_0x35edd5[_0x7810('0x28')]){delete _0x35edd5[_0x7810('0x28')];}_0xd00cf6[_0x7810('0x18')](_0x26425a)[_0x7810('0x29')](_0x35edd5);};}exports[_0x7810('0x2a')]=function(_0x171496,_0x243f58){var _0x4562ff={},_0x3c4a3f={},_0xabf51d={'count':0x0,'rows':[]};var _0x219af2=_['map'](db[_0x7810('0x2b')][_0x7810('0x2c')],function(_0x509ba7){return{'name':_0x509ba7[_0x7810('0x2d')],'type':_0x509ba7[_0x7810('0x2e')]['key']};});_0x3c4a3f[_0x7810('0x2f')]=_[_0x7810('0x30')](_0x219af2,_0x7810('0x28'));_0x3c4a3f['query']=_[_0x7810('0x31')](_0x171496[_0x7810('0x32')]);_0x3c4a3f[_0x7810('0x33')]=_[_0x7810('0x34')](_0x3c4a3f[_0x7810('0x2f')],_0x3c4a3f[_0x7810('0x32')]);_0x4562ff['attributes']=_[_0x7810('0x34')](_0x3c4a3f[_0x7810('0x2f')],qs['fields'](_0x171496[_0x7810('0x32')][_0x7810('0x35')]));_0x4562ff[_0x7810('0x36')]=_0x4562ff['attributes'][_0x7810('0x37')]?_0x4562ff[_0x7810('0x36')]:_0x3c4a3f[_0x7810('0x2f')];if(!_0x171496[_0x7810('0x32')][_0x7810('0x38')](_0x7810('0x39'))){_0x4562ff[_0x7810('0x1c')]=qs['limit'](_0x171496['query'][_0x7810('0x1c')]);_0x4562ff[_0x7810('0x1a')]=qs[_0x7810('0x1a')](_0x171496[_0x7810('0x32')][_0x7810('0x1a')]);}_0x4562ff[_0x7810('0x3a')]=qs[_0x7810('0x3b')](_0x171496['query'][_0x7810('0x3b')]);_0x4562ff['where']=qs[_0x7810('0x33')](_['pick'](_0x171496[_0x7810('0x32')],_0x3c4a3f['filters']),_0x219af2);if(_0x171496[_0x7810('0x32')][_0x7810('0x3c')]){_0x4562ff[_0x7810('0x3d')]=_[_0x7810('0x3e')](_0x4562ff[_0x7810('0x3d')],{'$or':_[_0x7810('0x30')](_0x219af2,function(_0x151231){if(_0x151231[_0x7810('0x2e')]!==_0x7810('0x3f')){var _0x547dfb={};_0x547dfb[_0x151231[_0x7810('0x28')]]={'$like':'%'+_0x171496[_0x7810('0x32')]['filter']+'%'};return _0x547dfb;}})});}_0x4562ff=_[_0x7810('0x3e')]({},_0x4562ff,_0x171496['options']);var _0x5bc8fd={'where':_0x4562ff[_0x7810('0x3d')]};return db['Campaign'][_0x7810('0x1d')](_0x5bc8fd)[_0x7810('0x23')](function(_0x735dbf){_0xabf51d[_0x7810('0x1d')]=_0x735dbf;if(_0x171496[_0x7810('0x32')][_0x7810('0x40')]){_0x4562ff['include']=[{'all':!![]}];}return db['Campaign'][_0x7810('0x41')](_0x4562ff);})[_0x7810('0x23')](function(_0x1c9649){_0xabf51d[_0x7810('0x42')]=_0x1c9649;return _0xabf51d;})['then'](respondWithFilteredResult(_0x243f58,_0x4562ff))['catch'](handleError(_0x243f58,null));};exports['show']=function(_0x458d72,_0x2176c9){var _0x48334c={'raw':![],'where':{'id':_0x458d72['params']['id']}},_0x5b83b9={};_0x5b83b9[_0x7810('0x2f')]=_[_0x7810('0x31')](db['Campaign'][_0x7810('0x2c')]);_0x5b83b9[_0x7810('0x32')]=_[_0x7810('0x31')](_0x458d72[_0x7810('0x32')]);_0x5b83b9[_0x7810('0x33')]=_['intersection'](_0x5b83b9[_0x7810('0x2f')],_0x5b83b9[_0x7810('0x32')]);_0x48334c[_0x7810('0x36')]=_[_0x7810('0x34')](_0x5b83b9[_0x7810('0x2f')],qs[_0x7810('0x35')](_0x458d72[_0x7810('0x32')]['fields']));_0x48334c[_0x7810('0x36')]=_0x48334c[_0x7810('0x36')][_0x7810('0x37')]?_0x48334c[_0x7810('0x36')]:_0x5b83b9[_0x7810('0x2f')];if(_0x458d72[_0x7810('0x32')][_0x7810('0x40')]){_0x48334c[_0x7810('0x43')]=[{'all':!![]}];}_0x48334c=_[_0x7810('0x3e')]({},_0x48334c,_0x458d72[_0x7810('0x44')]);return db[_0x7810('0x2b')][_0x7810('0x45')](_0x48334c)[_0x7810('0x23')](handleEntityNotFound(_0x2176c9,null))['then'](respondWithResult(_0x2176c9,null))[_0x7810('0x46')](handleError(_0x2176c9,null));};exports[_0x7810('0x47')]=function(_0x559098,_0x23f702){return db[_0x7810('0x2b')]['create'](_0x559098['body'],{})['then'](function(_0x229ab4){var _0x57d841=_0x559098['user'][_0x7810('0x24')]({'plain':!![]});if(!_0x57d841)throw new Error(_0x7810('0x48'));if(_0x57d841[_0x7810('0x49')]===_0x7810('0x4a')){var _0x5d8065=_0x229ab4['get']({'plain':!![]});var _0x1ea605=_0x7810('0x25');return db[_0x7810('0x4b')]['find']({'where':{'name':_0x1ea605,'userProfileId':_0x57d841[_0x7810('0x4c')]},'raw':!![]})['then'](function(_0x44acec){if(_0x44acec&&_0x44acec[_0x7810('0x4d')]===0x0){return db[_0x7810('0x26')][_0x7810('0x47')]({'name':_0x5d8065[_0x7810('0x28')],'resourceId':_0x5d8065['id'],'type':_0x44acec[_0x7810('0x28')],'sectionId':_0x44acec['id']},{})[_0x7810('0x23')](function(){return _0x229ab4;});}else{return _0x229ab4;}})[_0x7810('0x46')](function(_0x10a74d){logger[_0x7810('0x4e')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x10a74d);throw _0x10a74d;});}return _0x229ab4;})[_0x7810('0x23')](respondWithResult(_0x23f702,0xc9))[_0x7810('0x46')](handleError(_0x23f702,null));};exports['clone']=function(_0x195238,_0xbce904){var _0x48169f={'where':{'id':_0x195238[_0x7810('0x4f')]['id']}},_0x2bf85e={};_0x2bf85e['model']=_[_0x7810('0x31')](db[_0x7810('0x2b')][_0x7810('0x2c')]);_0x48169f[_0x7810('0x36')]=_[_0x7810('0x34')](_0x2bf85e[_0x7810('0x2f')],qs[_0x7810('0x35')](_0x195238[_0x7810('0x32')]['fields']));_0x48169f[_0x7810('0x36')]=_0x48169f[_0x7810('0x36')][_0x7810('0x37')]?_0x48169f['attributes']:_0x2bf85e['model'];if(_0x195238[_0x7810('0x32')][_0x7810('0x40')]){_0x48169f[_0x7810('0x43')]=[{'all':!![]}];}_0x48169f=_['merge']({},_0x48169f,_0x195238['options']);return db[_0x7810('0x2b')][_0x7810('0x45')](_0x48169f)[_0x7810('0x23')](handleEntityNotFound(_0xbce904,null))[_0x7810('0x23')](function(_0x16b198){if(_0x16b198){var _0x5590d9=_0x16b198[_0x7810('0x24')]({'plain':!![]});_0x5590d9=qs[_0x7810('0x50')](_0x5590d9,['id',_0x7810('0x51'),_0x7810('0x52')]);_0x195238[_0x7810('0x53')]=_[_0x7810('0x50')](_0x195238[_0x7810('0x53')],['id','createdAt',_0x7810('0x52')]);return db[_0x7810('0x2b')][_0x7810('0x47')](_['merge'](_0x5590d9,_0x195238[_0x7810('0x53')]),{'include':_0x195238['query'][_0x7810('0x40')]?[{'all':!![]}]:undefined})[_0x7810('0x23')](function(_0x3c890a){var _0x37fd17=_0x195238[_0x7810('0x4a')][_0x7810('0x24')]({'plain':!![]});if(!_0x37fd17)throw new Error(_0x7810('0x48'));if(_0x37fd17['role']==='user'){var _0x4b635b=_0x3c890a['get']({'plain':!![]});var _0x59ddad=_0x7810('0x25');return db[_0x7810('0x4b')]['find']({'where':{'name':_0x59ddad,'userProfileId':_0x37fd17[_0x7810('0x4c')]},'raw':!![]})[_0x7810('0x23')](function(_0x6dfeed){if(_0x6dfeed&&_0x6dfeed[_0x7810('0x4d')]===0x0){return db[_0x7810('0x26')][_0x7810('0x47')]({'name':_0x4b635b[_0x7810('0x28')],'resourceId':_0x4b635b['id'],'type':_0x6dfeed[_0x7810('0x28')],'sectionId':_0x6dfeed['id']},{})[_0x7810('0x23')](function(){return _0x3c890a;});}else{return _0x3c890a;}})[_0x7810('0x46')](function(_0xd9cc17){logger[_0x7810('0x4e')](_0x7810('0x54'),_0xd9cc17);throw _0xd9cc17;});}return _0x3c890a;});}})[_0x7810('0x23')](respondWithResult(_0xbce904,0xc9))[_0x7810('0x46')](handleError(_0xbce904,null));};exports[_0x7810('0x22')]=function(_0xcf1655,_0x282162){if(_0xcf1655['body']['id']){delete _0xcf1655[_0x7810('0x53')]['id'];}return db[_0x7810('0x2b')][_0x7810('0x45')]({'where':{'id':_0xcf1655[_0x7810('0x4f')]['id']}})[_0x7810('0x23')](handleEntityNotFound(_0x282162,null))['then'](saveUpdates(_0xcf1655['body'],null))[_0x7810('0x23')](respondWithResult(_0x282162,null))[_0x7810('0x46')](handleError(_0x282162,null));};exports[_0x7810('0x27')]=function(_0x69b7e9,_0x6a1a98){return db[_0x7810('0x2b')]['find']({'where':{'id':_0x69b7e9[_0x7810('0x4f')]['id']}})[_0x7810('0x23')](handleEntityNotFound(_0x6a1a98,null))[_0x7810('0x23')](removeEntity(_0x6a1a98,null))[_0x7810('0x46')](handleError(_0x6a1a98,null));};exports[_0x7810('0x55')]=function(_0x52c398,_0x49d417,_0x22dedb){var _0x1be696={'raw':!![],'where':{}};var _0xd65335={};var _0x11a144={'count':0x0,'rows':[]};return db[_0x7810('0x2b')][_0x7810('0x56')]({'where':{'id':_0x52c398['params']['id']}})['then'](handleEntityNotFound(_0x49d417,null))[_0x7810('0x23')](function(_0xb17f35){if(_0xb17f35){_0xd65335[_0x7810('0x2f')]=_['keys'](db['CmHopper'][_0x7810('0x2c')]);_0xd65335[_0x7810('0x32')]=_[_0x7810('0x31')](_0x52c398['query']);_0xd65335[_0x7810('0x33')]=_[_0x7810('0x34')](_0xd65335[_0x7810('0x2f')],_0xd65335[_0x7810('0x32')]);_0x1be696[_0x7810('0x36')]=_[_0x7810('0x34')](_0xd65335[_0x7810('0x2f')],qs['fields'](_0x52c398['query'][_0x7810('0x35')]));_0x1be696['attributes']=_0x1be696[_0x7810('0x36')]['length']?_0x1be696[_0x7810('0x36')]:_0xd65335[_0x7810('0x2f')];if(!_0x52c398[_0x7810('0x32')]['hasOwnProperty'](_0x7810('0x39'))){_0x1be696[_0x7810('0x1c')]=qs[_0x7810('0x1c')](_0x52c398[_0x7810('0x32')][_0x7810('0x1c')]);_0x1be696[_0x7810('0x1a')]=qs[_0x7810('0x1a')](_0x52c398[_0x7810('0x32')][_0x7810('0x1a')]);}_0x1be696['order']=qs['sort'](_0x52c398[_0x7810('0x32')][_0x7810('0x3b')]);_0x1be696[_0x7810('0x3d')]=qs[_0x7810('0x33')](_[_0x7810('0x57')](_0x52c398['query'],_0xd65335[_0x7810('0x33')]));_0x1be696[_0x7810('0x3d')][_0x7810('0x58')]=_0xb17f35['id'];if(_0x52c398['query'][_0x7810('0x3c')]){_0x1be696[_0x7810('0x3d')]=_[_0x7810('0x3e')](_0x1be696[_0x7810('0x3d')],{'$or':_[_0x7810('0x30')](_0x1be696[_0x7810('0x36')],function(_0x1c2964){var _0x341317={};_0x341317[_0x1c2964]={'$like':'%'+_0x52c398['query'][_0x7810('0x3c')]+'%'};return _0x341317;})});}_0x1be696=_[_0x7810('0x3e')]({},_0x1be696,_0x52c398[_0x7810('0x44')]);return db[_0x7810('0x59')][_0x7810('0x1d')]({'where':_0x1be696[_0x7810('0x3d')]})[_0x7810('0x23')](function(_0x34cac3){_0x11a144[_0x7810('0x1d')]=_0x34cac3;if(_0x52c398[_0x7810('0x32')]['includeAll']){_0x1be696[_0x7810('0x43')]=[{'all':!![]}];}return db[_0x7810('0x59')][_0x7810('0x41')](_0x1be696);})[_0x7810('0x23')](function(_0x5d1c37){_0x11a144[_0x7810('0x42')]=_0x5d1c37;return _0x11a144;});}})['then'](respondWithFilteredResult(_0x49d417,_0x1be696))[_0x7810('0x46')](handleError(_0x49d417,null));};exports['getHopperHistories']=function(_0x2ccb09,_0xbadf04,_0x47d4fd){var _0x59b55e={'raw':!![],'where':{}};var _0x26c8c2={};var _0x3d45b5={'count':0x0,'rows':[]};return db[_0x7810('0x2b')]['findOne']({'where':{'id':_0x2ccb09[_0x7810('0x4f')]['id']}})['then'](handleEntityNotFound(_0xbadf04,null))[_0x7810('0x23')](function(_0x1e4444){if(_0x1e4444){_0x26c8c2[_0x7810('0x2f')]=_[_0x7810('0x31')](db[_0x7810('0x5a')][_0x7810('0x2c')]);_0x26c8c2['query']=_['keys'](_0x2ccb09[_0x7810('0x32')]);_0x26c8c2[_0x7810('0x33')]=_[_0x7810('0x34')](_0x26c8c2[_0x7810('0x2f')],_0x26c8c2[_0x7810('0x32')]);_0x59b55e[_0x7810('0x36')]=_[_0x7810('0x34')](_0x26c8c2['model'],qs[_0x7810('0x35')](_0x2ccb09[_0x7810('0x32')][_0x7810('0x35')]));_0x59b55e['attributes']=_0x59b55e[_0x7810('0x36')]['length']?_0x59b55e[_0x7810('0x36')]:_0x26c8c2[_0x7810('0x2f')];if(!_0x2ccb09[_0x7810('0x32')][_0x7810('0x38')]('nolimit')){_0x59b55e[_0x7810('0x1c')]=qs[_0x7810('0x1c')](_0x2ccb09['query'][_0x7810('0x1c')]);_0x59b55e[_0x7810('0x1a')]=qs[_0x7810('0x1a')](_0x2ccb09[_0x7810('0x32')][_0x7810('0x1a')]);}_0x59b55e[_0x7810('0x3a')]=qs[_0x7810('0x3b')](_0x2ccb09['query'][_0x7810('0x3b')]);_0x59b55e['where']=qs[_0x7810('0x33')](_[_0x7810('0x57')](_0x2ccb09['query'],_0x26c8c2[_0x7810('0x33')]));_0x59b55e[_0x7810('0x3d')][_0x7810('0x58')]=_0x1e4444['id'];if(_0x2ccb09['query'][_0x7810('0x3c')]){_0x59b55e[_0x7810('0x3d')]=_[_0x7810('0x3e')](_0x59b55e[_0x7810('0x3d')],{'$or':_['map'](_0x59b55e[_0x7810('0x36')],function(_0x4f2a3b){var _0x31453b={};_0x31453b[_0x4f2a3b]={'$like':'%'+_0x2ccb09[_0x7810('0x32')][_0x7810('0x3c')]+'%'};return _0x31453b;})});}_0x59b55e=_[_0x7810('0x3e')]({},_0x59b55e,_0x2ccb09[_0x7810('0x44')]);return db[_0x7810('0x5a')][_0x7810('0x1d')]({'where':_0x59b55e['where']})[_0x7810('0x23')](function(_0x35ad73){_0x3d45b5[_0x7810('0x1d')]=_0x35ad73;if(_0x2ccb09[_0x7810('0x32')][_0x7810('0x40')]){_0x59b55e[_0x7810('0x43')]=[{'all':!![]}];}return db['CmHopperHistory'][_0x7810('0x41')](_0x59b55e);})[_0x7810('0x23')](function(_0x4b2dcc){_0x3d45b5['rows']=_0x4b2dcc;return _0x3d45b5;});}})[_0x7810('0x23')](respondWithFilteredResult(_0xbadf04,_0x59b55e))[_0x7810('0x46')](handleError(_0xbadf04,null));};exports[_0x7810('0x5b')]=function(_0xc2902,_0x469c23,_0xd1b87e){var _0x8bc1fc={'raw':!![],'where':{}};var _0x3e124d={};var _0x4fd663={'count':0x0,'rows':[]};return db[_0x7810('0x2b')][_0x7810('0x56')]({'where':{'id':_0xc2902['params']['id']}})[_0x7810('0x23')](handleEntityNotFound(_0x469c23,null))[_0x7810('0x23')](function(_0xa43aa3){if(_0xa43aa3){_0x3e124d[_0x7810('0x2f')]=_[_0x7810('0x31')](db[_0x7810('0x5c')][_0x7810('0x2c')]);_0x3e124d[_0x7810('0x32')]=_[_0x7810('0x31')](_0xc2902[_0x7810('0x32')]);_0x3e124d[_0x7810('0x33')]=_[_0x7810('0x34')](_0x3e124d[_0x7810('0x2f')],_0x3e124d[_0x7810('0x32')]);_0x8bc1fc[_0x7810('0x36')]=_[_0x7810('0x34')](_0x3e124d['model'],qs[_0x7810('0x35')](_0xc2902[_0x7810('0x32')]['fields']));_0x8bc1fc['attributes']=_0x8bc1fc['attributes'][_0x7810('0x37')]?_0x8bc1fc[_0x7810('0x36')]:_0x3e124d[_0x7810('0x2f')];if(!_0xc2902[_0x7810('0x32')]['hasOwnProperty']('nolimit')){_0x8bc1fc[_0x7810('0x1c')]=qs[_0x7810('0x1c')](_0xc2902[_0x7810('0x32')]['limit']);_0x8bc1fc[_0x7810('0x1a')]=qs[_0x7810('0x1a')](_0xc2902[_0x7810('0x32')][_0x7810('0x1a')]);}_0x8bc1fc[_0x7810('0x3a')]=qs[_0x7810('0x3b')](_0xc2902[_0x7810('0x32')]['sort']);_0x8bc1fc[_0x7810('0x3d')]=qs[_0x7810('0x33')](_[_0x7810('0x57')](_0xc2902[_0x7810('0x32')],_0x3e124d[_0x7810('0x33')]));_0x8bc1fc[_0x7810('0x3d')][_0x7810('0x58')]=_0xa43aa3['id'];if(_0xc2902[_0x7810('0x32')][_0x7810('0x3c')]){_0x8bc1fc['where']=_[_0x7810('0x3e')](_0x8bc1fc[_0x7810('0x3d')],{'$or':_[_0x7810('0x30')](_0x8bc1fc[_0x7810('0x36')],function(_0x6e4287){var _0x2b52af={};_0x2b52af[_0x6e4287]={'$like':'%'+_0xc2902['query'][_0x7810('0x3c')]+'%'};return _0x2b52af;})});}_0x8bc1fc=_['merge']({},_0x8bc1fc,_0xc2902[_0x7810('0x44')]);return db[_0x7810('0x5c')][_0x7810('0x1d')]({'where':_0x8bc1fc[_0x7810('0x3d')]})[_0x7810('0x23')](function(_0x56a1b7){_0x4fd663['count']=_0x56a1b7;if(_0xc2902[_0x7810('0x32')][_0x7810('0x40')]){_0x8bc1fc[_0x7810('0x43')]=[{'all':!![]}];}return db['CmHopperFinal'][_0x7810('0x41')](_0x8bc1fc);})[_0x7810('0x23')](function(_0x14a7c){_0x4fd663[_0x7810('0x42')]=_0x14a7c;return _0x4fd663;});}})['then'](respondWithFilteredResult(_0x469c23,_0x8bc1fc))[_0x7810('0x46')](handleError(_0x469c23,null));};exports[_0x7810('0x5d')]=function(_0x48d914,_0x914793,_0x1e9296){var _0x2ab741={'raw':!![],'where':{}};var _0x250cfc={};var _0x221fcb={'count':0x0,'rows':[]};return db[_0x7810('0x2b')][_0x7810('0x56')]({'where':{'id':_0x48d914[_0x7810('0x4f')]['id']}})[_0x7810('0x23')](handleEntityNotFound(_0x914793,null))[_0x7810('0x23')](function(_0x14bd3a){if(_0x14bd3a){_0x250cfc['model']=_[_0x7810('0x31')](db[_0x7810('0x5e')][_0x7810('0x2c')]);_0x250cfc['query']=_['keys'](_0x48d914['query']);_0x250cfc[_0x7810('0x33')]=_['intersection'](_0x250cfc[_0x7810('0x2f')],_0x250cfc[_0x7810('0x32')]);_0x2ab741[_0x7810('0x36')]=_[_0x7810('0x34')](_0x250cfc[_0x7810('0x2f')],qs[_0x7810('0x35')](_0x48d914[_0x7810('0x32')]['fields']));_0x2ab741[_0x7810('0x36')]=_0x2ab741[_0x7810('0x36')][_0x7810('0x37')]?_0x2ab741[_0x7810('0x36')]:_0x250cfc[_0x7810('0x2f')];if(!_0x48d914[_0x7810('0x32')][_0x7810('0x38')](_0x7810('0x39'))){_0x2ab741['limit']=qs['limit'](_0x48d914[_0x7810('0x32')][_0x7810('0x1c')]);_0x2ab741[_0x7810('0x1a')]=qs['offset'](_0x48d914['query'][_0x7810('0x1a')]);}_0x2ab741[_0x7810('0x3a')]=qs['sort'](_0x48d914['query'][_0x7810('0x3b')]);_0x2ab741[_0x7810('0x3d')]=qs[_0x7810('0x33')](_[_0x7810('0x57')](_0x48d914[_0x7810('0x32')],_0x250cfc[_0x7810('0x33')]));_0x2ab741[_0x7810('0x3d')]['CampaignId']=_0x14bd3a['id'];if(_0x48d914[_0x7810('0x32')]['filter']){_0x2ab741[_0x7810('0x3d')]=_[_0x7810('0x3e')](_0x2ab741[_0x7810('0x3d')],{'$or':_[_0x7810('0x30')](_0x2ab741[_0x7810('0x36')],function(_0x419cde){var _0x5562b3={};_0x5562b3[_0x419cde]={'$like':'%'+_0x48d914[_0x7810('0x32')]['filter']+'%'};return _0x5562b3;})});}_0x2ab741=_[_0x7810('0x3e')]({},_0x2ab741,_0x48d914['options']);return db[_0x7810('0x5e')]['count']({'where':_0x2ab741['where']})[_0x7810('0x23')](function(_0x5a2666){_0x221fcb[_0x7810('0x1d')]=_0x5a2666;if(_0x48d914[_0x7810('0x32')][_0x7810('0x40')]){_0x2ab741[_0x7810('0x43')]=[{'all':!![]}];}return db[_0x7810('0x5e')]['findAll'](_0x2ab741);})[_0x7810('0x23')](function(_0x4cfa0d){_0x221fcb[_0x7810('0x42')]=_0x4cfa0d;return _0x221fcb;});}})[_0x7810('0x23')](respondWithFilteredResult(_0x914793,_0x2ab741))['catch'](handleError(_0x914793,null));};exports[_0x7810('0x5f')]=function(_0x3b09da,_0xabc3e8,_0x4b26e7){var _0x59e450={};var _0x463a05={};var _0x169082;var _0x3459fc;return db[_0x7810('0x2b')][_0x7810('0x56')]({'where':{'id':_0x3b09da['params']['id']}})[_0x7810('0x23')](handleEntityNotFound(_0xabc3e8,null))['then'](function(_0x30f480){if(_0x30f480){_0x169082=_0x30f480;_0x463a05[_0x7810('0x2f')]=_[_0x7810('0x31')](db[_0x7810('0x60')][_0x7810('0x2c')]);_0x463a05['query']=_['keys'](_0x3b09da['query']);_0x463a05[_0x7810('0x33')]=_[_0x7810('0x34')](_0x463a05[_0x7810('0x2f')],_0x463a05[_0x7810('0x32')]);_0x59e450[_0x7810('0x36')]=_[_0x7810('0x34')](_0x463a05[_0x7810('0x2f')],qs[_0x7810('0x35')](_0x3b09da[_0x7810('0x32')][_0x7810('0x35')]));_0x59e450[_0x7810('0x36')]=_0x59e450[_0x7810('0x36')][_0x7810('0x37')]?_0x59e450[_0x7810('0x36')]:_0x463a05['model'];_0x59e450[_0x7810('0x3a')]=qs[_0x7810('0x3b')](_0x3b09da[_0x7810('0x32')][_0x7810('0x3b')]);_0x59e450[_0x7810('0x3d')]=qs['filters'](_[_0x7810('0x57')](_0x3b09da[_0x7810('0x32')],_0x463a05[_0x7810('0x33')]));if(_0x3b09da['query']['filter']){_0x59e450[_0x7810('0x3d')]=_[_0x7810('0x3e')](_0x59e450[_0x7810('0x3d')],{'$or':_['map'](_0x59e450[_0x7810('0x36')],function(_0x18743c){var _0x4799a6={};_0x4799a6[_0x18743c]={'$like':'%'+_0x3b09da[_0x7810('0x32')][_0x7810('0x3c')]+'%'};return _0x4799a6;})});}_0x59e450=_[_0x7810('0x3e')]({},_0x59e450,_0x3b09da[_0x7810('0x44')]);return _0x169082['getLists'](_0x59e450);}})[_0x7810('0x23')](function(_0x1083be){if(_0x1083be){_0x3459fc=_0x1083be['length'];if(!_0x3b09da[_0x7810('0x32')][_0x7810('0x38')](_0x7810('0x39'))){_0x59e450['limit']=qs[_0x7810('0x1c')](_0x3b09da[_0x7810('0x32')][_0x7810('0x1c')]);_0x59e450['offset']=qs[_0x7810('0x1a')](_0x3b09da[_0x7810('0x32')][_0x7810('0x1a')]);}return _0x169082[_0x7810('0x5f')](_0x59e450);}})[_0x7810('0x23')](function(_0x1f1db8){if(_0x1f1db8){return _0x1f1db8?{'count':_0x3459fc,'rows':_0x1f1db8}:null;}})[_0x7810('0x23')](respondWithResult(_0xabc3e8,null))['catch'](handleError(_0xabc3e8,null));};exports[_0x7810('0x61')]=function(_0x5e5e2,_0xbfed01,_0x78aa32){var _0x5d91b9,_0x520a16;var _0x4d781e=[];var _0x3792e1=moment()[_0x7810('0x62')](_0x7810('0x63'));return db['Campaign'][_0x7810('0x45')]({'where':{'id':_0x5e5e2[_0x7810('0x4f')]['id']}})['then'](handleEntityNotFound(_0xbfed01,null))[_0x7810('0x23')](function(_0x4c0c8a){if(_0x4c0c8a){_0x520a16=_0x4c0c8a;return _0x4c0c8a['addLists'](_0x5e5e2[_0x7810('0x53')][_0x7810('0x64')],_[_0x7810('0x50')](_0x5e5e2[_0x7810('0x53')],[_0x7810('0x64'),'id'])||{});}return null;})[_0x7810('0x65')](function(_0x1fb4c9){var _0x5cdd7c;var _0x3f2599;_0x5d91b9=_0x1fb4c9||[];var _0x2ad35f=[];if(_0x1fb4c9){for(var _0x248e59=0x0;_0x248e59<_0x1fb4c9[_0x7810('0x37')];_0x248e59+=0x1){var _0x53d426=_0x1fb4c9[_0x248e59][_0x7810('0x24')]({'plain':!![]});_0x520a16[_0x7810('0x66')]=_0x5e5e2[_0x7810('0x53')][_0x7810('0x66')]?_0x5e5e2[_0x7810('0x53')][_0x7810('0x66')]:_0x520a16[_0x7810('0x66')];switch(_0x520a16[_0x7810('0x66')]){case _0x7810('0x67'):_0x5cdd7c=squel[_0x7810('0x68')]()[_0x7810('0x69')]('cm_hopper')[_0x7810('0x6a')]([_0x7810('0x6b'),_0x7810('0x6c'),_0x7810('0x6d'),'ListId',_0x7810('0x58'),'createdAt',_0x7810('0x52')],squel[_0x7810('0x6e')]()[_0x7810('0x6f')](_0x7810('0x6b'),_0x7810('0x6b'))[_0x7810('0x6f')]('NOW()',_0x7810('0x6c'))['field']('id',_0x7810('0x6d'))[_0x7810('0x6f')](_0x53d426[_0x7810('0x70')][_0x7810('0x71')](),_0x7810('0x72'))['field'](_0x5e5e2[_0x7810('0x4f')]['id'][_0x7810('0x71')](),_0x7810('0x58'))['field']('\x27'+_0x3792e1+'\x27','createdAt')['field']('\x27'+_0x3792e1+'\x27',_0x7810('0x52'))[_0x7810('0x73')]('cm_contacts')['where'](_0x7810('0x74'))[_0x7810('0x3d')](_0x7810('0x75'),_0x53d426[_0x7810('0x70')][_0x7810('0x71')]())[_0x7810('0x3d')]('phone\x20IS\x20NOT\x20NULL')[_0x7810('0x3d')]('phone\x20NOT\x20IN\x20(?)',squel['select']()['field'](_0x7810('0x76'))['from'](_0x7810('0x77'))[_0x7810('0x3d')](_0x7810('0x78'),_0x5e5e2[_0x7810('0x4f')]['id'][_0x7810('0x71')]()))['where'](_0x7810('0x79'),squel[_0x7810('0x6e')]()['field'](_0x7810('0x7a'))[_0x7810('0x73')]('cm_hopper')['where'](_0x7810('0x78'),_0x5e5e2[_0x7810('0x4f')]['id'][_0x7810('0x71')]())))[_0x7810('0x71')]();break;case'onlyIfOpen':_0x5cdd7c=squel[_0x7810('0x68')]()[_0x7810('0x69')](_0x7810('0x7b'))[_0x7810('0x6a')](['phone',_0x7810('0x6c'),'ContactId','ListId','CampaignId',_0x7810('0x51'),_0x7810('0x52')],squel['select']()[_0x7810('0x6f')](_0x7810('0x6b'),_0x7810('0x6b'))[_0x7810('0x6f')](_0x7810('0x7c'),_0x7810('0x6c'))[_0x7810('0x6f')]('id','ContactId')['field'](_0x53d426[_0x7810('0x70')][_0x7810('0x71')](),_0x7810('0x72'))[_0x7810('0x6f')](_0x5e5e2[_0x7810('0x4f')]['id'][_0x7810('0x71')](),'CampaignId')[_0x7810('0x6f')]('\x27'+_0x3792e1+'\x27',_0x7810('0x51'))[_0x7810('0x6f')]('\x27'+_0x3792e1+'\x27',_0x7810('0x52'))[_0x7810('0x73')](_0x7810('0x7d'))[_0x7810('0x3d')]('deletedAt\x20IS\x20NULL')[_0x7810('0x3d')](_0x7810('0x75'),_0x53d426['CmListId'][_0x7810('0x71')]())[_0x7810('0x3d')]('phone\x20IS\x20NOT\x20NULL')[_0x7810('0x3d')](_0x7810('0x79'),squel[_0x7810('0x6e')]()['field'](_0x7810('0x7a'))[_0x7810('0x73')](_0x7810('0x7b'))[_0x7810('0x3d')](_0x7810('0x78'),_0x5e5e2['params']['id']['toString']())))[_0x7810('0x71')]();break;default:_0x5cdd7c=squel[_0x7810('0x68')]()[_0x7810('0x69')](_0x7810('0x7b'))['fromQuery']([_0x7810('0x6b'),_0x7810('0x6c'),_0x7810('0x6d'),_0x7810('0x72'),'CampaignId',_0x7810('0x51'),_0x7810('0x52')],squel['select']()[_0x7810('0x6f')]('phone',_0x7810('0x6b'))[_0x7810('0x6f')](_0x7810('0x7c'),'scheduledAt')[_0x7810('0x6f')]('id',_0x7810('0x6d'))[_0x7810('0x6f')](_0x53d426['CmListId']['toString'](),'ListId')['field'](_0x5e5e2[_0x7810('0x4f')]['id'][_0x7810('0x71')](),'CampaignId')[_0x7810('0x6f')]('\x27'+_0x3792e1+'\x27',_0x7810('0x51'))[_0x7810('0x6f')]('\x27'+_0x3792e1+'\x27',_0x7810('0x52'))[_0x7810('0x73')]('cm_contacts')['where'](_0x7810('0x74'))['where'](_0x7810('0x75'),_0x53d426[_0x7810('0x70')]['toString']())[_0x7810('0x3d')](_0x7810('0x7e')))[_0x7810('0x71')]();}_0x3f2599=squel[_0x7810('0x68')]()[_0x7810('0x69')](_0x7810('0x7f'))[_0x7810('0x6a')]([_0x7810('0x80'),'scheduledAt',_0x7810('0x6b'),_0x7810('0x81'),'createdAt',_0x7810('0x52')],squel[_0x7810('0x6e')]()[_0x7810('0x6f')](_0x7810('0x82'),'id')[_0x7810('0x6f')](_0x7810('0x7c'),_0x7810('0x6c'))[_0x7810('0x6f')]('ci.item',_0x7810('0x6b'))[_0x7810('0x6f')]('ci.OrderBY',_0x7810('0x81'))[_0x7810('0x6f')]('\x27'+_0x3792e1+'\x27',_0x7810('0x51'))[_0x7810('0x6f')]('\x27'+_0x3792e1+'\x27','updatedAt')[_0x7810('0x73')](_0x7810('0x83'),'ci')['join'](_0x7810('0x7b'),'h',_0x7810('0x84'))[_0x7810('0x3d')]('h.ListId\x20=\x20?',_0x53d426['CmListId']['toString']())[_0x7810('0x3d')](_0x7810('0x85'),_0x5e5e2['params']['id']['toString']())['where'](_0x7810('0x86'),_0x3792e1))['toString']();_0x2ad35f['push'](db[_0x7810('0x87')]['query'](_0x5cdd7c));_0x4d781e['push'](db[_0x7810('0x87')]['query'](_0x3f2599));}return BPromise[_0x7810('0x88')](_0x2ad35f);}})['then'](function(){return BPromise[_0x7810('0x88')](_0x4d781e);})['then'](function(){return _0x5d91b9;})['then'](respondWithResult(_0xbfed01,null))[_0x7810('0x46')](handleError(_0xbfed01,null));};exports['removeLists']=function(_0x3d84a4,_0x36759e,_0x14662b){return db['Campaign'][_0x7810('0x45')]({'where':{'id':_0x3d84a4[_0x7810('0x4f')]['id']}})['then'](handleEntityNotFound(_0x36759e,null))[_0x7810('0x23')](function(_0x5daf6c){if(_0x5daf6c){return _0x5daf6c['removeLists'](_0x3d84a4[_0x7810('0x32')][_0x7810('0x64')]);}})['then'](function(_0x418426){if(_0x418426){return db[_0x7810('0x59')][_0x7810('0x27')]({'where':{'ListId':_0x3d84a4[_0x7810('0x32')][_0x7810('0x64')],'CampaignId':_0x3d84a4['params']['id']}})[_0x7810('0x23')](function(){return _0x418426;});}})['then'](respondWithStatusCode(_0x36759e,null))['catch'](handleError(_0x36759e,null));};exports[_0x7810('0x89')]=function(_0x5acd86,_0x201d49,_0x47a59e){var _0x30ea8={};var _0x45815e={};var _0x18b578;var _0x54a73d;return db[_0x7810('0x2b')][_0x7810('0x56')]({'where':{'id':_0x5acd86[_0x7810('0x4f')]['id']}})[_0x7810('0x23')](handleEntityNotFound(_0x201d49,null))['then'](function(_0x188242){if(_0x188242){_0x18b578=_0x188242;_0x45815e['model']=_['keys'](db[_0x7810('0x60')][_0x7810('0x2c')]);_0x45815e[_0x7810('0x32')]=_[_0x7810('0x31')](_0x5acd86[_0x7810('0x32')]);_0x45815e[_0x7810('0x33')]=_[_0x7810('0x34')](_0x45815e['model'],_0x45815e['query']);_0x30ea8[_0x7810('0x36')]=_[_0x7810('0x34')](_0x45815e[_0x7810('0x2f')],qs['fields'](_0x5acd86[_0x7810('0x32')][_0x7810('0x35')]));_0x30ea8['attributes']=_0x30ea8['attributes'][_0x7810('0x37')]?_0x30ea8[_0x7810('0x36')]:_0x45815e[_0x7810('0x2f')];_0x30ea8[_0x7810('0x3a')]=qs[_0x7810('0x3b')](_0x5acd86[_0x7810('0x32')][_0x7810('0x3b')]);_0x30ea8['where']=qs[_0x7810('0x33')](_[_0x7810('0x57')](_0x5acd86[_0x7810('0x32')],_0x45815e[_0x7810('0x33')]));if(_0x5acd86[_0x7810('0x32')][_0x7810('0x3c')]){_0x30ea8['where']=_[_0x7810('0x3e')](_0x30ea8['where'],{'$or':_[_0x7810('0x30')](_0x30ea8['attributes'],function(_0x5d7223){var _0x5e0747={};_0x5e0747[_0x5d7223]={'$like':'%'+_0x5acd86[_0x7810('0x32')][_0x7810('0x3c')]+'%'};return _0x5e0747;})});}_0x30ea8=_[_0x7810('0x3e')]({},_0x30ea8,_0x5acd86['options']);return _0x18b578['getBlackLists'](_0x30ea8);}})[_0x7810('0x23')](function(_0xcc480){if(_0xcc480){_0x54a73d=_0xcc480['length'];if(!_0x5acd86[_0x7810('0x32')][_0x7810('0x38')](_0x7810('0x39'))){_0x30ea8[_0x7810('0x1c')]=qs[_0x7810('0x1c')](_0x5acd86['query'][_0x7810('0x1c')]);_0x30ea8[_0x7810('0x1a')]=qs[_0x7810('0x1a')](_0x5acd86[_0x7810('0x32')][_0x7810('0x1a')]);}return _0x18b578[_0x7810('0x89')](_0x30ea8);}})[_0x7810('0x23')](function(_0x59a91b){if(_0x59a91b){return _0x59a91b?{'count':_0x54a73d,'rows':_0x59a91b}:null;}})[_0x7810('0x23')](respondWithResult(_0x201d49,null))['catch'](handleError(_0x201d49,null));};exports[_0x7810('0x8a')]=function(_0x32a828,_0x16b7c1,_0x1f3e2c){var _0x41f6a1,_0x359ce1;var _0x25cc81=[];var _0x5a3a6d=moment()[_0x7810('0x62')]('YYYY-MM-DD\x20HH:mm:ss');return db[_0x7810('0x2b')][_0x7810('0x45')]({'where':{'id':_0x32a828['params']['id']}})[_0x7810('0x23')](handleEntityNotFound(_0x16b7c1,null))[_0x7810('0x23')](function(_0x2e75f){if(_0x2e75f){_0x359ce1=_0x2e75f;return _0x2e75f[_0x7810('0x8a')](_0x32a828[_0x7810('0x53')][_0x7810('0x64')],_[_0x7810('0x50')](_0x32a828[_0x7810('0x53')],[_0x7810('0x64'),'id'])||{});}return null;})[_0x7810('0x65')](function(_0x43cc9d){var _0x59f168;var _0x51a232;_0x41f6a1=_0x43cc9d||[];var _0x29ad8e=[];if(_0x43cc9d){for(var _0x3dc29e=0x0;_0x3dc29e<_0x43cc9d[_0x7810('0x37')];_0x3dc29e+=0x1){var _0x33ee93=_0x43cc9d[_0x3dc29e][_0x7810('0x24')]({'plain':!![]});_0x59f168=squel[_0x7810('0x68')]()[_0x7810('0x69')](_0x7810('0x8b'))[_0x7810('0x6a')]([_0x7810('0x6b'),_0x7810('0x6d'),_0x7810('0x72'),_0x7810('0x58'),_0x7810('0x51'),_0x7810('0x52')],squel['select']()[_0x7810('0x6f')](_0x7810('0x6b'),_0x7810('0x6b'))['field']('id',_0x7810('0x6d'))[_0x7810('0x6f')](_0x33ee93[_0x7810('0x70')][_0x7810('0x71')](),'ListId')[_0x7810('0x6f')](_0x32a828[_0x7810('0x4f')]['id']['toString'](),_0x7810('0x58'))[_0x7810('0x6f')]('NOW()',_0x7810('0x51'))[_0x7810('0x6f')](_0x7810('0x7c'),_0x7810('0x52'))[_0x7810('0x73')](_0x7810('0x7d'))['where'](_0x7810('0x74'))[_0x7810('0x3d')]('ListId\x20=\x20?',_0x33ee93[_0x7810('0x70')][_0x7810('0x71')]())[_0x7810('0x3d')]('phone\x20IS\x20NOT\x20NULL'))[_0x7810('0x71')]();_0x29ad8e[_0x7810('0x8c')](db['sequelize']['query'](_0x59f168));}return BPromise[_0x7810('0x88')](_0x29ad8e);}})['then'](function(){return _0x41f6a1;})[_0x7810('0x23')](respondWithResult(_0x16b7c1,null))[_0x7810('0x46')](handleError(_0x16b7c1,null));};exports[_0x7810('0x8d')]=function(_0x3794bf,_0xeab9f7,_0x2f474e){return db[_0x7810('0x2b')][_0x7810('0x45')]({'where':{'id':_0x3794bf[_0x7810('0x4f')]['id']}})[_0x7810('0x23')](handleEntityNotFound(_0xeab9f7,null))[_0x7810('0x23')](function(_0x197ba5){if(_0x197ba5){return _0x197ba5['removeBlackLists'](_0x3794bf[_0x7810('0x32')][_0x7810('0x64')]);}})[_0x7810('0x23')](function(_0x29cb79){if(_0x29cb79){return db[_0x7810('0x5e')][_0x7810('0x27')]({'where':{'ListId':_0x3794bf['query'][_0x7810('0x64')],'CampaignId':_0x3794bf['params']['id']}})[_0x7810('0x23')](function(){return _0x29cb79;});}})[_0x7810('0x23')](respondWithStatusCode(_0xeab9f7,null))['catch'](handleError(_0xeab9f7,null));};