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 _0x3526=['COALESCE(phone,\x27\x27)','onlyIfOpen','deletedAt\x20IS\x20NULL','cm_hopper_additional_phones','cmHopperId','OrderBy','h.id','ci.item','ci.OrderBY','cm_contact_has_items','join','h.ListId\x20=\x20?','h.CampaignId=?','push','sequelize','all','removeLists','getBlackLists','CmList','addBlackLists','cm_hopper_black','removeBlackLists','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','querystring','ioredis','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','reject','save','then','destroy','get','error','stack','name','send','index','Campaign','rawAttributes','fieldName','type','key','model','map','query','keys','filters','intersection','attributes','fields','length','nolimit','order','sort','pick','where','VIRTUAL','filter','options','includeAll','include','findAll','rows','catch','show','params','merge','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','autoAssociation','UserProfileResource','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','omit','createdAt','updatedAt','IvrCampaigns','getHoppers','findOne','CmHopper','hasOwnProperty','CampaignId','CmHopperHistory','getHopperFinals','CmHopperFinal','getHopperBlacks','CmHopperBlack','getLists','addLists','format','YYYY-MM-DD\x20HH:mm:ss','ids','spread','dialCheckDuplicateType','insert','into','cm_hopper','fromQuery','scheduledAt','select','field','phone','NOW()','ContactId','CmListId','toString','ListId','from','cm_contacts','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','COALESCE(calleridnum,\x27\x27)','cm_hopper_final','CampaignId\x20=\x20?'];(function(_0x50b9b0,_0x427e8b){var _0x37316f=function(_0x290bd1){while(--_0x290bd1){_0x50b9b0['push'](_0x50b9b0['shift']());}};_0x37316f(++_0x427e8b);}(_0x3526,0x1db));var _0x6352=function(_0x614875,_0x289fdf){_0x614875=_0x614875-0x0;var _0x546b39=_0x3526[_0x614875];return _0x546b39;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x6352('0x0'));var zipdir=require(_0x6352('0x1'));var jsonpatch=require(_0x6352('0x2'));var rp=require(_0x6352('0x3'));var moment=require(_0x6352('0x4'));var BPromise=require(_0x6352('0x5'));var Mustache=require(_0x6352('0x6'));var util=require(_0x6352('0x7'));var path=require(_0x6352('0x8'));var sox=require(_0x6352('0x9'));var csv=require(_0x6352('0xa'));var ejs=require(_0x6352('0xb'));var fs=require('fs');var fs_extra=require(_0x6352('0xc'));var _=require(_0x6352('0xd'));var squel=require(_0x6352('0xe'));var crypto=require(_0x6352('0xf'));var jsforce=require(_0x6352('0x10'));var deskjs=require(_0x6352('0x11'));var toCsv=require(_0x6352('0xa'));var querystring=require(_0x6352('0x12'));var Papa=require('papaparse');var Redis=require(_0x6352('0x13'));var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0x6352('0x14'))(_0x6352('0x15'));var utils=require(_0x6352('0x16'));var config=require(_0x6352('0x17'));var licenseUtil=require(_0x6352('0x18'));var db=require(_0x6352('0x19'))['db'];function respondWithStatusCode(_0x4abb00,_0x362122){_0x362122=_0x362122||0xcc;return function(_0x2f43aa){if(_0x2f43aa){return _0x4abb00[_0x6352('0x1a')](_0x362122);}return _0x4abb00[_0x6352('0x1b')](_0x362122)[_0x6352('0x1c')]();};}function respondWithResult(_0x38245f,_0x47aa91){_0x47aa91=_0x47aa91||0xc8;return function(_0x505e23){if(_0x505e23){return _0x38245f[_0x6352('0x1b')](_0x47aa91)[_0x6352('0x1d')](_0x505e23);}};}function respondWithFilteredResult(_0xeb0285,_0x56ad95){return function(_0x44b0dc){if(_0x44b0dc){var _0x3b494e=typeof _0x56ad95[_0x6352('0x1e')]===_0x6352('0x1f')&&typeof _0x56ad95[_0x6352('0x20')]===_0x6352('0x1f');var _0x315a7e=_0x44b0dc[_0x6352('0x21')];var _0x2fcc57=_0x3b494e?0x0:_0x56ad95[_0x6352('0x1e')];var _0x486d35=_0x3b494e?_0x44b0dc[_0x6352('0x21')]:_0x56ad95['offset']+_0x56ad95[_0x6352('0x20')];var _0x5dd1c7;if(_0x486d35>=_0x315a7e){_0x486d35=_0x315a7e;_0x5dd1c7=0xc8;}else{_0x5dd1c7=0xce;}_0xeb0285[_0x6352('0x1b')](_0x5dd1c7);return _0xeb0285[_0x6352('0x22')](_0x6352('0x23'),_0x2fcc57+'-'+_0x486d35+'/'+_0x315a7e)[_0x6352('0x1d')](_0x44b0dc);}return null;};}function patchUpdates(_0xaf2621){return function(_0x3d66d8){try{jsonpatch['apply'](_0x3d66d8,_0xaf2621,!![]);}catch(_0x3b72f7){return BPromise[_0x6352('0x24')](_0x3b72f7);}return _0x3d66d8[_0x6352('0x25')]();};}function saveUpdates(_0x9560eb,_0x105755){return function(_0x4b8ded){if(_0x4b8ded){return _0x4b8ded['update'](_0x9560eb)[_0x6352('0x26')](function(_0x37f842){return _0x37f842;});}return null;};}function removeEntity(_0xfef8fd,_0x3988b4){return function(_0x335cfd){if(_0x335cfd){return _0x335cfd[_0x6352('0x27')]()['then'](function(){var _0x57e927=_0x335cfd[_0x6352('0x28')]({'plain':!![]});var _0x5b5621='IvrCampaigns';return db['UserProfileResource'][_0x6352('0x27')]({'where':{'type':_0x5b5621,'resourceId':_0x57e927['id']}})[_0x6352('0x26')](function(){return _0x335cfd;});})[_0x6352('0x26')](function(){_0xfef8fd['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x45cfd8,_0x549bb9){return function(_0x17d977){if(!_0x17d977){_0x45cfd8['sendStatus'](0x194);}return _0x17d977;};}function handleError(_0x2dab10,_0x42ec09){_0x42ec09=_0x42ec09||0x1f4;return function(_0x24b356){logger[_0x6352('0x29')](_0x24b356[_0x6352('0x2a')]);if(_0x24b356[_0x6352('0x2b')]){delete _0x24b356[_0x6352('0x2b')];}_0x2dab10[_0x6352('0x1b')](_0x42ec09)[_0x6352('0x2c')](_0x24b356);};}exports[_0x6352('0x2d')]=function(_0x2ed032,_0x1b6b7a){var _0x23971f={},_0x31a95d={},_0x2ff5bd={'count':0x0,'rows':[]};var _0x2c7365=_['map'](db[_0x6352('0x2e')][_0x6352('0x2f')],function(_0x562e46){return{'name':_0x562e46[_0x6352('0x30')],'type':_0x562e46[_0x6352('0x31')][_0x6352('0x32')]};});_0x31a95d[_0x6352('0x33')]=_[_0x6352('0x34')](_0x2c7365,_0x6352('0x2b'));_0x31a95d[_0x6352('0x35')]=_[_0x6352('0x36')](_0x2ed032[_0x6352('0x35')]);_0x31a95d[_0x6352('0x37')]=_[_0x6352('0x38')](_0x31a95d[_0x6352('0x33')],_0x31a95d['query']);_0x23971f[_0x6352('0x39')]=_[_0x6352('0x38')](_0x31a95d[_0x6352('0x33')],qs[_0x6352('0x3a')](_0x2ed032['query'][_0x6352('0x3a')]));_0x23971f[_0x6352('0x39')]=_0x23971f[_0x6352('0x39')][_0x6352('0x3b')]?_0x23971f[_0x6352('0x39')]:_0x31a95d['model'];if(!_0x2ed032['query']['hasOwnProperty'](_0x6352('0x3c'))){_0x23971f[_0x6352('0x20')]=qs['limit'](_0x2ed032[_0x6352('0x35')][_0x6352('0x20')]);_0x23971f[_0x6352('0x1e')]=qs[_0x6352('0x1e')](_0x2ed032[_0x6352('0x35')][_0x6352('0x1e')]);}_0x23971f[_0x6352('0x3d')]=qs[_0x6352('0x3e')](_0x2ed032['query'][_0x6352('0x3e')]);_0x23971f['where']=qs['filters'](_[_0x6352('0x3f')](_0x2ed032['query'],_0x31a95d[_0x6352('0x37')]),_0x2c7365);if(_0x2ed032[_0x6352('0x35')]['filter']){_0x23971f[_0x6352('0x40')]=_['merge'](_0x23971f['where'],{'$or':_[_0x6352('0x34')](_0x2c7365,function(_0x41245c){if(_0x41245c[_0x6352('0x31')]!==_0x6352('0x41')){var _0x240ebc={};_0x240ebc[_0x41245c[_0x6352('0x2b')]]={'$like':'%'+_0x2ed032['query'][_0x6352('0x42')]+'%'};return _0x240ebc;}})});}_0x23971f=_['merge']({},_0x23971f,_0x2ed032[_0x6352('0x43')]);var _0x461f48={'where':_0x23971f[_0x6352('0x40')]};return db['Campaign'][_0x6352('0x21')](_0x461f48)['then'](function(_0x1c6e69){_0x2ff5bd[_0x6352('0x21')]=_0x1c6e69;if(_0x2ed032[_0x6352('0x35')][_0x6352('0x44')]){_0x23971f[_0x6352('0x45')]=[{'all':!![]}];}return db[_0x6352('0x2e')][_0x6352('0x46')](_0x23971f);})[_0x6352('0x26')](function(_0x1e1952){_0x2ff5bd[_0x6352('0x47')]=_0x1e1952;return _0x2ff5bd;})[_0x6352('0x26')](respondWithFilteredResult(_0x1b6b7a,_0x23971f))[_0x6352('0x48')](handleError(_0x1b6b7a,null));};exports[_0x6352('0x49')]=function(_0x4b3233,_0x27fd8a){var _0x4ddbdb={'raw':![],'where':{'id':_0x4b3233[_0x6352('0x4a')]['id']}},_0x177012={};_0x177012['model']=_[_0x6352('0x36')](db[_0x6352('0x2e')]['rawAttributes']);_0x177012['query']=_[_0x6352('0x36')](_0x4b3233[_0x6352('0x35')]);_0x177012[_0x6352('0x37')]=_[_0x6352('0x38')](_0x177012['model'],_0x177012[_0x6352('0x35')]);_0x4ddbdb[_0x6352('0x39')]=_[_0x6352('0x38')](_0x177012['model'],qs['fields'](_0x4b3233['query'][_0x6352('0x3a')]));_0x4ddbdb[_0x6352('0x39')]=_0x4ddbdb[_0x6352('0x39')][_0x6352('0x3b')]?_0x4ddbdb[_0x6352('0x39')]:_0x177012[_0x6352('0x33')];if(_0x4b3233['query'][_0x6352('0x44')]){_0x4ddbdb['include']=[{'all':!![]}];}_0x4ddbdb=_[_0x6352('0x4b')]({},_0x4ddbdb,_0x4b3233[_0x6352('0x43')]);return db['Campaign'][_0x6352('0x4c')](_0x4ddbdb)[_0x6352('0x26')](handleEntityNotFound(_0x27fd8a,null))[_0x6352('0x26')](respondWithResult(_0x27fd8a,null))[_0x6352('0x48')](handleError(_0x27fd8a,null));};exports['create']=function(_0x43f8af,_0x501994){return db[_0x6352('0x2e')][_0x6352('0x4d')](_0x43f8af[_0x6352('0x4e')],{})[_0x6352('0x26')](function(_0x5949bc){var _0x25a772=_0x43f8af[_0x6352('0x4f')][_0x6352('0x28')]({'plain':!![]});if(!_0x25a772)throw new Error(_0x6352('0x50'));if(_0x25a772[_0x6352('0x51')]===_0x6352('0x4f')){var _0x4a0253=_0x5949bc[_0x6352('0x28')]({'plain':!![]});var _0x142c87='IvrCampaigns';return db[_0x6352('0x52')][_0x6352('0x4c')]({'where':{'name':_0x142c87,'userProfileId':_0x25a772[_0x6352('0x53')]},'raw':!![]})[_0x6352('0x26')](function(_0x2ccf73){if(_0x2ccf73&&_0x2ccf73[_0x6352('0x54')]===0x0){return db[_0x6352('0x55')][_0x6352('0x4d')]({'name':_0x4a0253['name'],'resourceId':_0x4a0253['id'],'type':_0x2ccf73[_0x6352('0x2b')],'sectionId':_0x2ccf73['id']},{})[_0x6352('0x26')](function(){return _0x5949bc;});}else{return _0x5949bc;}})[_0x6352('0x48')](function(_0xa0c13d){logger[_0x6352('0x29')](_0x6352('0x56'),_0xa0c13d);throw _0xa0c13d;});}return _0x5949bc;})['then'](respondWithResult(_0x501994,0xc9))['catch'](handleError(_0x501994,null));};exports['clone']=function(_0x315c26,_0x15416a){var _0xd04b9a={'where':{'id':_0x315c26[_0x6352('0x4a')]['id']}},_0x4f3b23={};_0x4f3b23['model']=_[_0x6352('0x36')](db[_0x6352('0x2e')][_0x6352('0x2f')]);_0xd04b9a[_0x6352('0x39')]=_[_0x6352('0x38')](_0x4f3b23[_0x6352('0x33')],qs[_0x6352('0x3a')](_0x315c26['query'][_0x6352('0x3a')]));_0xd04b9a['attributes']=_0xd04b9a[_0x6352('0x39')]['length']?_0xd04b9a[_0x6352('0x39')]:_0x4f3b23[_0x6352('0x33')];if(_0x315c26[_0x6352('0x35')][_0x6352('0x44')]){_0xd04b9a[_0x6352('0x45')]=[{'all':!![]}];}_0xd04b9a=_[_0x6352('0x4b')]({},_0xd04b9a,_0x315c26[_0x6352('0x43')]);return db[_0x6352('0x2e')][_0x6352('0x4c')](_0xd04b9a)['then'](handleEntityNotFound(_0x15416a,null))['then'](function(_0x279a04){if(_0x279a04){var _0x245a76=_0x279a04[_0x6352('0x28')]({'plain':!![]});_0x245a76=qs[_0x6352('0x57')](_0x245a76,['id',_0x6352('0x58'),_0x6352('0x59')]);_0x315c26[_0x6352('0x4e')]=_[_0x6352('0x57')](_0x315c26[_0x6352('0x4e')],['id',_0x6352('0x58'),_0x6352('0x59')]);return db['Campaign'][_0x6352('0x4d')](_[_0x6352('0x4b')](_0x245a76,_0x315c26['body']),{'include':_0x315c26[_0x6352('0x35')][_0x6352('0x44')]?[{'all':!![]}]:undefined})[_0x6352('0x26')](function(_0x3cbd21){var _0x206c19=_0x315c26[_0x6352('0x4f')]['get']({'plain':!![]});if(!_0x206c19)throw new Error(_0x6352('0x50'));if(_0x206c19[_0x6352('0x51')]==='user'){var _0x272fd4=_0x3cbd21[_0x6352('0x28')]({'plain':!![]});var _0x1ea6ae=_0x6352('0x5a');return db['UserProfileSection'][_0x6352('0x4c')]({'where':{'name':_0x1ea6ae,'userProfileId':_0x206c19[_0x6352('0x53')]},'raw':!![]})[_0x6352('0x26')](function(_0x3b06e6){if(_0x3b06e6&&_0x3b06e6[_0x6352('0x54')]===0x0){return db['UserProfileResource'][_0x6352('0x4d')]({'name':_0x272fd4['name'],'resourceId':_0x272fd4['id'],'type':_0x3b06e6[_0x6352('0x2b')],'sectionId':_0x3b06e6['id']},{})[_0x6352('0x26')](function(){return _0x3cbd21;});}else{return _0x3cbd21;}})[_0x6352('0x48')](function(_0x5a0500){logger['error'](_0x6352('0x56'),_0x5a0500);throw _0x5a0500;});}return _0x3cbd21;});}})[_0x6352('0x26')](respondWithResult(_0x15416a,0xc9))[_0x6352('0x48')](handleError(_0x15416a,null));};exports['update']=function(_0x4a190f,_0x5df225){if(_0x4a190f[_0x6352('0x4e')]['id']){delete _0x4a190f[_0x6352('0x4e')]['id'];}return db['Campaign'][_0x6352('0x4c')]({'where':{'id':_0x4a190f[_0x6352('0x4a')]['id']}})[_0x6352('0x26')](handleEntityNotFound(_0x5df225,null))[_0x6352('0x26')](saveUpdates(_0x4a190f[_0x6352('0x4e')],null))[_0x6352('0x26')](respondWithResult(_0x5df225,null))['catch'](handleError(_0x5df225,null));};exports['destroy']=function(_0x4e76df,_0x594b1c){return db[_0x6352('0x2e')]['find']({'where':{'id':_0x4e76df[_0x6352('0x4a')]['id']}})[_0x6352('0x26')](handleEntityNotFound(_0x594b1c,null))[_0x6352('0x26')](removeEntity(_0x594b1c,null))[_0x6352('0x48')](handleError(_0x594b1c,null));};exports[_0x6352('0x5b')]=function(_0xdbd694,_0x8bfce8,_0x129ed1){var _0x2916aa={'raw':!![],'where':{}};var _0x178d56={};var _0x59e049={'count':0x0,'rows':[]};return db[_0x6352('0x2e')][_0x6352('0x5c')]({'where':{'id':_0xdbd694['params']['id']}})[_0x6352('0x26')](handleEntityNotFound(_0x8bfce8,null))[_0x6352('0x26')](function(_0xcf8a5){if(_0xcf8a5){_0x178d56[_0x6352('0x33')]=_[_0x6352('0x36')](db[_0x6352('0x5d')][_0x6352('0x2f')]);_0x178d56[_0x6352('0x35')]=_['keys'](_0xdbd694[_0x6352('0x35')]);_0x178d56['filters']=_[_0x6352('0x38')](_0x178d56[_0x6352('0x33')],_0x178d56[_0x6352('0x35')]);_0x2916aa[_0x6352('0x39')]=_[_0x6352('0x38')](_0x178d56[_0x6352('0x33')],qs[_0x6352('0x3a')](_0xdbd694['query'][_0x6352('0x3a')]));_0x2916aa[_0x6352('0x39')]=_0x2916aa[_0x6352('0x39')][_0x6352('0x3b')]?_0x2916aa[_0x6352('0x39')]:_0x178d56[_0x6352('0x33')];if(!_0xdbd694[_0x6352('0x35')][_0x6352('0x5e')](_0x6352('0x3c'))){_0x2916aa[_0x6352('0x20')]=qs['limit'](_0xdbd694[_0x6352('0x35')][_0x6352('0x20')]);_0x2916aa['offset']=qs['offset'](_0xdbd694[_0x6352('0x35')][_0x6352('0x1e')]);}_0x2916aa['order']=qs[_0x6352('0x3e')](_0xdbd694[_0x6352('0x35')]['sort']);_0x2916aa[_0x6352('0x40')]=qs['filters'](_[_0x6352('0x3f')](_0xdbd694[_0x6352('0x35')],_0x178d56[_0x6352('0x37')]));_0x2916aa['where'][_0x6352('0x5f')]=_0xcf8a5['id'];if(_0xdbd694[_0x6352('0x35')]['filter']){_0x2916aa['where']=_['merge'](_0x2916aa[_0x6352('0x40')],{'$or':_[_0x6352('0x34')](_0x2916aa[_0x6352('0x39')],function(_0x2e189d){var _0xee5e05={};_0xee5e05[_0x2e189d]={'$like':'%'+_0xdbd694['query'][_0x6352('0x42')]+'%'};return _0xee5e05;})});}_0x2916aa=_['merge']({},_0x2916aa,_0xdbd694[_0x6352('0x43')]);return db[_0x6352('0x5d')][_0x6352('0x21')]({'where':_0x2916aa['where']})[_0x6352('0x26')](function(_0x40ea58){_0x59e049[_0x6352('0x21')]=_0x40ea58;if(_0xdbd694[_0x6352('0x35')][_0x6352('0x44')]){_0x2916aa[_0x6352('0x45')]=[{'all':!![]}];}return db[_0x6352('0x5d')][_0x6352('0x46')](_0x2916aa);})[_0x6352('0x26')](function(_0x3ddac3){_0x59e049['rows']=_0x3ddac3;return _0x59e049;});}})[_0x6352('0x26')](respondWithFilteredResult(_0x8bfce8,_0x2916aa))[_0x6352('0x48')](handleError(_0x8bfce8,null));};exports['getHopperHistories']=function(_0xb6353e,_0x5a359c,_0x5e7860){var _0xfdc628={'raw':!![],'where':{}};var _0xdea9b8={};var _0x2c00ae={'count':0x0,'rows':[]};return db['Campaign'][_0x6352('0x5c')]({'where':{'id':_0xb6353e[_0x6352('0x4a')]['id']}})['then'](handleEntityNotFound(_0x5a359c,null))['then'](function(_0x5c159d){if(_0x5c159d){_0xdea9b8[_0x6352('0x33')]=_[_0x6352('0x36')](db['CmHopperHistory'][_0x6352('0x2f')]);_0xdea9b8[_0x6352('0x35')]=_[_0x6352('0x36')](_0xb6353e['query']);_0xdea9b8[_0x6352('0x37')]=_[_0x6352('0x38')](_0xdea9b8[_0x6352('0x33')],_0xdea9b8[_0x6352('0x35')]);_0xfdc628[_0x6352('0x39')]=_[_0x6352('0x38')](_0xdea9b8[_0x6352('0x33')],qs[_0x6352('0x3a')](_0xb6353e['query']['fields']));_0xfdc628[_0x6352('0x39')]=_0xfdc628[_0x6352('0x39')][_0x6352('0x3b')]?_0xfdc628[_0x6352('0x39')]:_0xdea9b8[_0x6352('0x33')];if(!_0xb6353e[_0x6352('0x35')][_0x6352('0x5e')](_0x6352('0x3c'))){_0xfdc628['limit']=qs['limit'](_0xb6353e['query'][_0x6352('0x20')]);_0xfdc628[_0x6352('0x1e')]=qs[_0x6352('0x1e')](_0xb6353e['query'][_0x6352('0x1e')]);}_0xfdc628[_0x6352('0x3d')]=qs[_0x6352('0x3e')](_0xb6353e[_0x6352('0x35')]['sort']);_0xfdc628[_0x6352('0x40')]=qs[_0x6352('0x37')](_[_0x6352('0x3f')](_0xb6353e[_0x6352('0x35')],_0xdea9b8[_0x6352('0x37')]));_0xfdc628[_0x6352('0x40')][_0x6352('0x5f')]=_0x5c159d['id'];if(_0xb6353e[_0x6352('0x35')]['filter']){_0xfdc628[_0x6352('0x40')]=_[_0x6352('0x4b')](_0xfdc628[_0x6352('0x40')],{'$or':_[_0x6352('0x34')](_0xfdc628['attributes'],function(_0x258a7c){var _0x4e4185={};_0x4e4185[_0x258a7c]={'$like':'%'+_0xb6353e[_0x6352('0x35')][_0x6352('0x42')]+'%'};return _0x4e4185;})});}_0xfdc628=_[_0x6352('0x4b')]({},_0xfdc628,_0xb6353e[_0x6352('0x43')]);return db[_0x6352('0x60')][_0x6352('0x21')]({'where':_0xfdc628[_0x6352('0x40')]})[_0x6352('0x26')](function(_0x17a7b6){_0x2c00ae[_0x6352('0x21')]=_0x17a7b6;if(_0xb6353e[_0x6352('0x35')][_0x6352('0x44')]){_0xfdc628[_0x6352('0x45')]=[{'all':!![]}];}return db[_0x6352('0x60')][_0x6352('0x46')](_0xfdc628);})[_0x6352('0x26')](function(_0x246341){_0x2c00ae[_0x6352('0x47')]=_0x246341;return _0x2c00ae;});}})['then'](respondWithFilteredResult(_0x5a359c,_0xfdc628))['catch'](handleError(_0x5a359c,null));};exports[_0x6352('0x61')]=function(_0x2be178,_0x14155a,_0x3075fb){var _0x3f632b={'raw':!![],'where':{}};var _0x1e4d53={};var _0x5c56ec={'count':0x0,'rows':[]};return db['Campaign'][_0x6352('0x5c')]({'where':{'id':_0x2be178[_0x6352('0x4a')]['id']}})['then'](handleEntityNotFound(_0x14155a,null))[_0x6352('0x26')](function(_0x4f4cbf){if(_0x4f4cbf){_0x1e4d53['model']=_[_0x6352('0x36')](db[_0x6352('0x62')][_0x6352('0x2f')]);_0x1e4d53[_0x6352('0x35')]=_['keys'](_0x2be178['query']);_0x1e4d53[_0x6352('0x37')]=_[_0x6352('0x38')](_0x1e4d53[_0x6352('0x33')],_0x1e4d53['query']);_0x3f632b[_0x6352('0x39')]=_['intersection'](_0x1e4d53[_0x6352('0x33')],qs[_0x6352('0x3a')](_0x2be178[_0x6352('0x35')][_0x6352('0x3a')]));_0x3f632b[_0x6352('0x39')]=_0x3f632b[_0x6352('0x39')][_0x6352('0x3b')]?_0x3f632b[_0x6352('0x39')]:_0x1e4d53['model'];if(!_0x2be178['query'][_0x6352('0x5e')]('nolimit')){_0x3f632b[_0x6352('0x20')]=qs[_0x6352('0x20')](_0x2be178[_0x6352('0x35')][_0x6352('0x20')]);_0x3f632b[_0x6352('0x1e')]=qs[_0x6352('0x1e')](_0x2be178[_0x6352('0x35')][_0x6352('0x1e')]);}_0x3f632b['order']=qs[_0x6352('0x3e')](_0x2be178[_0x6352('0x35')][_0x6352('0x3e')]);_0x3f632b[_0x6352('0x40')]=qs[_0x6352('0x37')](_[_0x6352('0x3f')](_0x2be178[_0x6352('0x35')],_0x1e4d53[_0x6352('0x37')]));_0x3f632b['where'][_0x6352('0x5f')]=_0x4f4cbf['id'];if(_0x2be178[_0x6352('0x35')][_0x6352('0x42')]){_0x3f632b[_0x6352('0x40')]=_['merge'](_0x3f632b[_0x6352('0x40')],{'$or':_[_0x6352('0x34')](_0x3f632b[_0x6352('0x39')],function(_0x59475c){var _0xdaa939={};_0xdaa939[_0x59475c]={'$like':'%'+_0x2be178[_0x6352('0x35')][_0x6352('0x42')]+'%'};return _0xdaa939;})});}_0x3f632b=_['merge']({},_0x3f632b,_0x2be178['options']);return db[_0x6352('0x62')][_0x6352('0x21')]({'where':_0x3f632b[_0x6352('0x40')]})[_0x6352('0x26')](function(_0x104b96){_0x5c56ec['count']=_0x104b96;if(_0x2be178[_0x6352('0x35')][_0x6352('0x44')]){_0x3f632b[_0x6352('0x45')]=[{'all':!![]}];}return db['CmHopperFinal']['findAll'](_0x3f632b);})['then'](function(_0x2089ab){_0x5c56ec[_0x6352('0x47')]=_0x2089ab;return _0x5c56ec;});}})[_0x6352('0x26')](respondWithFilteredResult(_0x14155a,_0x3f632b))[_0x6352('0x48')](handleError(_0x14155a,null));};exports[_0x6352('0x63')]=function(_0x5f210a,_0x290fbd,_0x2af060){var _0x407e16={'raw':!![],'where':{}};var _0x3d91f3={};var _0x224529={'count':0x0,'rows':[]};return db[_0x6352('0x2e')][_0x6352('0x5c')]({'where':{'id':_0x5f210a[_0x6352('0x4a')]['id']}})['then'](handleEntityNotFound(_0x290fbd,null))['then'](function(_0x15c3bf){if(_0x15c3bf){_0x3d91f3[_0x6352('0x33')]=_[_0x6352('0x36')](db['CmHopperBlack']['rawAttributes']);_0x3d91f3['query']=_['keys'](_0x5f210a['query']);_0x3d91f3[_0x6352('0x37')]=_['intersection'](_0x3d91f3[_0x6352('0x33')],_0x3d91f3[_0x6352('0x35')]);_0x407e16[_0x6352('0x39')]=_[_0x6352('0x38')](_0x3d91f3[_0x6352('0x33')],qs['fields'](_0x5f210a[_0x6352('0x35')][_0x6352('0x3a')]));_0x407e16[_0x6352('0x39')]=_0x407e16[_0x6352('0x39')][_0x6352('0x3b')]?_0x407e16[_0x6352('0x39')]:_0x3d91f3['model'];if(!_0x5f210a[_0x6352('0x35')]['hasOwnProperty'](_0x6352('0x3c'))){_0x407e16[_0x6352('0x20')]=qs[_0x6352('0x20')](_0x5f210a['query'][_0x6352('0x20')]);_0x407e16[_0x6352('0x1e')]=qs[_0x6352('0x1e')](_0x5f210a[_0x6352('0x35')]['offset']);}_0x407e16[_0x6352('0x3d')]=qs[_0x6352('0x3e')](_0x5f210a[_0x6352('0x35')][_0x6352('0x3e')]);_0x407e16[_0x6352('0x40')]=qs['filters'](_[_0x6352('0x3f')](_0x5f210a[_0x6352('0x35')],_0x3d91f3[_0x6352('0x37')]));_0x407e16['where'][_0x6352('0x5f')]=_0x15c3bf['id'];if(_0x5f210a[_0x6352('0x35')]['filter']){_0x407e16[_0x6352('0x40')]=_[_0x6352('0x4b')](_0x407e16[_0x6352('0x40')],{'$or':_['map'](_0x407e16['attributes'],function(_0x1f2104){var _0x38360f={};_0x38360f[_0x1f2104]={'$like':'%'+_0x5f210a[_0x6352('0x35')][_0x6352('0x42')]+'%'};return _0x38360f;})});}_0x407e16=_['merge']({},_0x407e16,_0x5f210a[_0x6352('0x43')]);return db[_0x6352('0x64')][_0x6352('0x21')]({'where':_0x407e16[_0x6352('0x40')]})[_0x6352('0x26')](function(_0x161a67){_0x224529[_0x6352('0x21')]=_0x161a67;if(_0x5f210a[_0x6352('0x35')][_0x6352('0x44')]){_0x407e16[_0x6352('0x45')]=[{'all':!![]}];}return db[_0x6352('0x64')]['findAll'](_0x407e16);})[_0x6352('0x26')](function(_0x1a73a8){_0x224529[_0x6352('0x47')]=_0x1a73a8;return _0x224529;});}})['then'](respondWithFilteredResult(_0x290fbd,_0x407e16))[_0x6352('0x48')](handleError(_0x290fbd,null));};exports[_0x6352('0x65')]=function(_0x43e9e1,_0x40cd18,_0x505fff){var _0x4518d3={};var _0x39ccc9={};var _0x29ea85;var _0x546850;return db[_0x6352('0x2e')][_0x6352('0x5c')]({'where':{'id':_0x43e9e1[_0x6352('0x4a')]['id']}})[_0x6352('0x26')](handleEntityNotFound(_0x40cd18,null))[_0x6352('0x26')](function(_0x57550a){if(_0x57550a){_0x29ea85=_0x57550a;_0x39ccc9[_0x6352('0x33')]=_[_0x6352('0x36')](db['CmList'][_0x6352('0x2f')]);_0x39ccc9[_0x6352('0x35')]=_[_0x6352('0x36')](_0x43e9e1[_0x6352('0x35')]);_0x39ccc9[_0x6352('0x37')]=_[_0x6352('0x38')](_0x39ccc9[_0x6352('0x33')],_0x39ccc9[_0x6352('0x35')]);_0x4518d3[_0x6352('0x39')]=_[_0x6352('0x38')](_0x39ccc9[_0x6352('0x33')],qs[_0x6352('0x3a')](_0x43e9e1[_0x6352('0x35')]['fields']));_0x4518d3['attributes']=_0x4518d3[_0x6352('0x39')][_0x6352('0x3b')]?_0x4518d3[_0x6352('0x39')]:_0x39ccc9[_0x6352('0x33')];_0x4518d3['order']=qs[_0x6352('0x3e')](_0x43e9e1[_0x6352('0x35')][_0x6352('0x3e')]);_0x4518d3[_0x6352('0x40')]=qs[_0x6352('0x37')](_[_0x6352('0x3f')](_0x43e9e1[_0x6352('0x35')],_0x39ccc9[_0x6352('0x37')]));if(_0x43e9e1[_0x6352('0x35')][_0x6352('0x42')]){_0x4518d3[_0x6352('0x40')]=_[_0x6352('0x4b')](_0x4518d3['where'],{'$or':_[_0x6352('0x34')](_0x4518d3['attributes'],function(_0x8a4931){var _0x54164c={};_0x54164c[_0x8a4931]={'$like':'%'+_0x43e9e1[_0x6352('0x35')][_0x6352('0x42')]+'%'};return _0x54164c;})});}_0x4518d3=_[_0x6352('0x4b')]({},_0x4518d3,_0x43e9e1[_0x6352('0x43')]);return _0x29ea85[_0x6352('0x65')](_0x4518d3);}})[_0x6352('0x26')](function(_0x920a7f){if(_0x920a7f){_0x546850=_0x920a7f[_0x6352('0x3b')];if(!_0x43e9e1['query'][_0x6352('0x5e')](_0x6352('0x3c'))){_0x4518d3[_0x6352('0x20')]=qs[_0x6352('0x20')](_0x43e9e1[_0x6352('0x35')]['limit']);_0x4518d3['offset']=qs[_0x6352('0x1e')](_0x43e9e1[_0x6352('0x35')][_0x6352('0x1e')]);}return _0x29ea85[_0x6352('0x65')](_0x4518d3);}})['then'](function(_0x2a3eba){if(_0x2a3eba){return _0x2a3eba?{'count':_0x546850,'rows':_0x2a3eba}:null;}})['then'](respondWithResult(_0x40cd18,null))['catch'](handleError(_0x40cd18,null));};exports[_0x6352('0x66')]=function(_0x3e2767,_0x571f2a,_0x5e1b7c){var _0x55ef8b,_0x24304d;var _0x5ca0d3=[];var _0x2352f2=moment()[_0x6352('0x67')](_0x6352('0x68'));return db[_0x6352('0x2e')][_0x6352('0x4c')]({'where':{'id':_0x3e2767[_0x6352('0x4a')]['id']}})['then'](handleEntityNotFound(_0x571f2a,null))['then'](function(_0x267828){if(_0x267828){_0x24304d=_0x267828;return _0x267828['addLists'](_0x3e2767[_0x6352('0x4e')]['ids'],_[_0x6352('0x57')](_0x3e2767[_0x6352('0x4e')],[_0x6352('0x69'),'id'])||{});}return null;})[_0x6352('0x6a')](function(_0x559f09){var _0x2306ad;var _0x3c49eb;_0x55ef8b=_0x559f09||[];var _0x1b61ff=[];if(_0x559f09){for(var _0x1b4351=0x0;_0x1b4351<_0x559f09[_0x6352('0x3b')];_0x1b4351+=0x1){var _0x436b7b=_0x559f09[_0x1b4351][_0x6352('0x28')]({'plain':!![]});_0x24304d[_0x6352('0x6b')]=_0x3e2767['body']['dialCheckDuplicateType']?_0x3e2767[_0x6352('0x4e')][_0x6352('0x6b')]:_0x24304d[_0x6352('0x6b')];switch(_0x24304d[_0x6352('0x6b')]){case'always':_0x2306ad=squel[_0x6352('0x6c')]()[_0x6352('0x6d')](_0x6352('0x6e'))[_0x6352('0x6f')](['phone',_0x6352('0x70'),'ContactId','ListId',_0x6352('0x5f'),'createdAt','updatedAt'],squel[_0x6352('0x71')]()[_0x6352('0x72')](_0x6352('0x73'),_0x6352('0x73'))['field'](_0x6352('0x74'),_0x6352('0x70'))[_0x6352('0x72')]('id',_0x6352('0x75'))[_0x6352('0x72')](_0x436b7b[_0x6352('0x76')][_0x6352('0x77')](),_0x6352('0x78'))[_0x6352('0x72')](_0x3e2767[_0x6352('0x4a')]['id'][_0x6352('0x77')](),'CampaignId')[_0x6352('0x72')]('\x27'+_0x2352f2+'\x27','createdAt')[_0x6352('0x72')]('\x27'+_0x2352f2+'\x27',_0x6352('0x59'))[_0x6352('0x79')](_0x6352('0x7a'))[_0x6352('0x40')]('deletedAt\x20IS\x20NULL')[_0x6352('0x40')](_0x6352('0x7b'),_0x436b7b[_0x6352('0x76')]['toString']())[_0x6352('0x40')](_0x6352('0x7c'))[_0x6352('0x40')](_0x6352('0x7d'),squel[_0x6352('0x71')]()['field'](_0x6352('0x7e'))[_0x6352('0x79')](_0x6352('0x7f'))[_0x6352('0x40')](_0x6352('0x80'),_0x3e2767[_0x6352('0x4a')]['id'][_0x6352('0x77')]()))[_0x6352('0x40')](_0x6352('0x7d'),squel[_0x6352('0x71')]()[_0x6352('0x72')](_0x6352('0x81'))[_0x6352('0x79')]('cm_hopper')[_0x6352('0x40')](_0x6352('0x80'),_0x3e2767[_0x6352('0x4a')]['id'][_0x6352('0x77')]())))['toString']();break;case _0x6352('0x82'):_0x2306ad=squel[_0x6352('0x6c')]()['into'](_0x6352('0x6e'))[_0x6352('0x6f')]([_0x6352('0x73'),_0x6352('0x70'),_0x6352('0x75'),'ListId',_0x6352('0x5f'),_0x6352('0x58'),_0x6352('0x59')],squel['select']()['field'](_0x6352('0x73'),_0x6352('0x73'))[_0x6352('0x72')](_0x6352('0x74'),'scheduledAt')[_0x6352('0x72')]('id',_0x6352('0x75'))[_0x6352('0x72')](_0x436b7b[_0x6352('0x76')][_0x6352('0x77')](),_0x6352('0x78'))[_0x6352('0x72')](_0x3e2767[_0x6352('0x4a')]['id']['toString'](),_0x6352('0x5f'))[_0x6352('0x72')]('\x27'+_0x2352f2+'\x27',_0x6352('0x58'))[_0x6352('0x72')]('\x27'+_0x2352f2+'\x27',_0x6352('0x59'))[_0x6352('0x79')]('cm_contacts')[_0x6352('0x40')](_0x6352('0x83'))['where'](_0x6352('0x7b'),_0x436b7b['CmListId'][_0x6352('0x77')]())[_0x6352('0x40')](_0x6352('0x7c'))[_0x6352('0x40')](_0x6352('0x7d'),squel[_0x6352('0x71')]()['field'](_0x6352('0x81'))[_0x6352('0x79')](_0x6352('0x6e'))['where']('CampaignId\x20=\x20?',_0x3e2767[_0x6352('0x4a')]['id']['toString']())))['toString']();break;default:_0x2306ad=squel[_0x6352('0x6c')]()['into']('cm_hopper')[_0x6352('0x6f')]([_0x6352('0x73'),_0x6352('0x70'),_0x6352('0x75'),_0x6352('0x78'),_0x6352('0x5f'),_0x6352('0x58'),_0x6352('0x59')],squel[_0x6352('0x71')]()['field'](_0x6352('0x73'),'phone')[_0x6352('0x72')]('NOW()',_0x6352('0x70'))['field']('id',_0x6352('0x75'))[_0x6352('0x72')](_0x436b7b[_0x6352('0x76')]['toString'](),_0x6352('0x78'))[_0x6352('0x72')](_0x3e2767[_0x6352('0x4a')]['id'][_0x6352('0x77')](),_0x6352('0x5f'))['field']('\x27'+_0x2352f2+'\x27',_0x6352('0x58'))[_0x6352('0x72')]('\x27'+_0x2352f2+'\x27',_0x6352('0x59'))[_0x6352('0x79')](_0x6352('0x7a'))[_0x6352('0x40')](_0x6352('0x83'))[_0x6352('0x40')](_0x6352('0x7b'),_0x436b7b[_0x6352('0x76')][_0x6352('0x77')]())[_0x6352('0x40')]('phone\x20IS\x20NOT\x20NULL'))[_0x6352('0x77')]();}_0x3c49eb=squel[_0x6352('0x6c')]()[_0x6352('0x6d')](_0x6352('0x84'))[_0x6352('0x6f')]([_0x6352('0x85'),_0x6352('0x70'),_0x6352('0x73'),_0x6352('0x86'),_0x6352('0x58'),_0x6352('0x59')],squel[_0x6352('0x71')]()[_0x6352('0x72')](_0x6352('0x87'),'id')[_0x6352('0x72')](_0x6352('0x74'),_0x6352('0x70'))[_0x6352('0x72')](_0x6352('0x88'),_0x6352('0x73'))[_0x6352('0x72')](_0x6352('0x89'),_0x6352('0x86'))[_0x6352('0x72')]('\x27'+_0x2352f2+'\x27','createdAt')[_0x6352('0x72')]('\x27'+_0x2352f2+'\x27','updatedAt')[_0x6352('0x79')](_0x6352('0x8a'),'ci')[_0x6352('0x8b')](_0x6352('0x6e'),'h','h.ContactId\x20=\x20ci.CmContactId')[_0x6352('0x40')](_0x6352('0x8c'),_0x436b7b[_0x6352('0x76')][_0x6352('0x77')]())[_0x6352('0x40')](_0x6352('0x8d'),_0x3e2767['params']['id'][_0x6352('0x77')]())[_0x6352('0x40')]('h.createdAt\x20=\x20?',_0x2352f2))[_0x6352('0x77')]();_0x1b61ff[_0x6352('0x8e')](db[_0x6352('0x8f')]['query'](_0x2306ad));_0x5ca0d3[_0x6352('0x8e')](db[_0x6352('0x8f')][_0x6352('0x35')](_0x3c49eb));}return BPromise['all'](_0x1b61ff);}})[_0x6352('0x26')](function(){return BPromise[_0x6352('0x90')](_0x5ca0d3);})['then'](function(){return _0x55ef8b;})[_0x6352('0x26')](respondWithResult(_0x571f2a,null))[_0x6352('0x48')](handleError(_0x571f2a,null));};exports[_0x6352('0x91')]=function(_0x443768,_0x5ed7a8,_0xe7b224){return db[_0x6352('0x2e')][_0x6352('0x4c')]({'where':{'id':_0x443768[_0x6352('0x4a')]['id']}})[_0x6352('0x26')](handleEntityNotFound(_0x5ed7a8,null))[_0x6352('0x26')](function(_0x6f6ec2){if(_0x6f6ec2){return _0x6f6ec2[_0x6352('0x91')](_0x443768[_0x6352('0x35')]['ids']);}})[_0x6352('0x26')](function(_0x51b837){if(_0x51b837){return db[_0x6352('0x5d')][_0x6352('0x27')]({'where':{'ListId':_0x443768[_0x6352('0x35')][_0x6352('0x69')],'CampaignId':_0x443768[_0x6352('0x4a')]['id']}})[_0x6352('0x26')](function(){return _0x51b837;});}})['then'](respondWithStatusCode(_0x5ed7a8,null))['catch'](handleError(_0x5ed7a8,null));};exports[_0x6352('0x92')]=function(_0x31ae8e,_0x3ee3c4,_0x57daa1){var _0x2d8d90={};var _0x221333={};var _0x104ff9;var _0x31ed1d;return db[_0x6352('0x2e')]['findOne']({'where':{'id':_0x31ae8e[_0x6352('0x4a')]['id']}})[_0x6352('0x26')](handleEntityNotFound(_0x3ee3c4,null))[_0x6352('0x26')](function(_0x37d872){if(_0x37d872){_0x104ff9=_0x37d872;_0x221333['model']=_[_0x6352('0x36')](db[_0x6352('0x93')][_0x6352('0x2f')]);_0x221333['query']=_[_0x6352('0x36')](_0x31ae8e[_0x6352('0x35')]);_0x221333[_0x6352('0x37')]=_[_0x6352('0x38')](_0x221333['model'],_0x221333[_0x6352('0x35')]);_0x2d8d90[_0x6352('0x39')]=_[_0x6352('0x38')](_0x221333['model'],qs['fields'](_0x31ae8e['query'][_0x6352('0x3a')]));_0x2d8d90[_0x6352('0x39')]=_0x2d8d90['attributes']['length']?_0x2d8d90[_0x6352('0x39')]:_0x221333[_0x6352('0x33')];_0x2d8d90[_0x6352('0x3d')]=qs[_0x6352('0x3e')](_0x31ae8e['query'][_0x6352('0x3e')]);_0x2d8d90['where']=qs[_0x6352('0x37')](_[_0x6352('0x3f')](_0x31ae8e['query'],_0x221333[_0x6352('0x37')]));if(_0x31ae8e[_0x6352('0x35')][_0x6352('0x42')]){_0x2d8d90[_0x6352('0x40')]=_['merge'](_0x2d8d90[_0x6352('0x40')],{'$or':_[_0x6352('0x34')](_0x2d8d90[_0x6352('0x39')],function(_0x297703){var _0x37f64f={};_0x37f64f[_0x297703]={'$like':'%'+_0x31ae8e[_0x6352('0x35')][_0x6352('0x42')]+'%'};return _0x37f64f;})});}_0x2d8d90=_[_0x6352('0x4b')]({},_0x2d8d90,_0x31ae8e[_0x6352('0x43')]);return _0x104ff9[_0x6352('0x92')](_0x2d8d90);}})[_0x6352('0x26')](function(_0x1ec058){if(_0x1ec058){_0x31ed1d=_0x1ec058[_0x6352('0x3b')];if(!_0x31ae8e[_0x6352('0x35')][_0x6352('0x5e')](_0x6352('0x3c'))){_0x2d8d90[_0x6352('0x20')]=qs[_0x6352('0x20')](_0x31ae8e[_0x6352('0x35')][_0x6352('0x20')]);_0x2d8d90[_0x6352('0x1e')]=qs[_0x6352('0x1e')](_0x31ae8e[_0x6352('0x35')][_0x6352('0x1e')]);}return _0x104ff9[_0x6352('0x92')](_0x2d8d90);}})[_0x6352('0x26')](function(_0xeb8f46){if(_0xeb8f46){return _0xeb8f46?{'count':_0x31ed1d,'rows':_0xeb8f46}:null;}})[_0x6352('0x26')](respondWithResult(_0x3ee3c4,null))[_0x6352('0x48')](handleError(_0x3ee3c4,null));};exports[_0x6352('0x94')]=function(_0x233cc6,_0x572ba5,_0x2e8739){var _0x36f9a7,_0x332b52;var _0x60ccf4=[];var _0x4e5646=moment()[_0x6352('0x67')](_0x6352('0x68'));return db[_0x6352('0x2e')][_0x6352('0x4c')]({'where':{'id':_0x233cc6[_0x6352('0x4a')]['id']}})[_0x6352('0x26')](handleEntityNotFound(_0x572ba5,null))[_0x6352('0x26')](function(_0x67a0f2){if(_0x67a0f2){_0x332b52=_0x67a0f2;return _0x67a0f2[_0x6352('0x94')](_0x233cc6[_0x6352('0x4e')][_0x6352('0x69')],_[_0x6352('0x57')](_0x233cc6[_0x6352('0x4e')],['ids','id'])||{});}return null;})[_0x6352('0x6a')](function(_0x4fb9e5){var _0x1b3390;var _0x2ccfa8;_0x36f9a7=_0x4fb9e5||[];var _0x3d3026=[];if(_0x4fb9e5){for(var _0x4afd17=0x0;_0x4afd17<_0x4fb9e5[_0x6352('0x3b')];_0x4afd17+=0x1){var _0x49c7cf=_0x4fb9e5[_0x4afd17][_0x6352('0x28')]({'plain':!![]});_0x1b3390=squel[_0x6352('0x6c')]()['into'](_0x6352('0x95'))[_0x6352('0x6f')]([_0x6352('0x73'),_0x6352('0x75'),_0x6352('0x78'),_0x6352('0x5f'),_0x6352('0x58'),_0x6352('0x59')],squel[_0x6352('0x71')]()[_0x6352('0x72')](_0x6352('0x73'),_0x6352('0x73'))[_0x6352('0x72')]('id',_0x6352('0x75'))[_0x6352('0x72')](_0x49c7cf[_0x6352('0x76')][_0x6352('0x77')](),_0x6352('0x78'))['field'](_0x233cc6[_0x6352('0x4a')]['id'][_0x6352('0x77')](),_0x6352('0x5f'))[_0x6352('0x72')](_0x6352('0x74'),'createdAt')['field'](_0x6352('0x74'),_0x6352('0x59'))[_0x6352('0x79')](_0x6352('0x7a'))[_0x6352('0x40')](_0x6352('0x83'))['where'](_0x6352('0x7b'),_0x49c7cf['CmListId'][_0x6352('0x77')]())[_0x6352('0x40')]('phone\x20IS\x20NOT\x20NULL'))[_0x6352('0x77')]();_0x3d3026[_0x6352('0x8e')](db[_0x6352('0x8f')]['query'](_0x1b3390));}return BPromise[_0x6352('0x90')](_0x3d3026);}})[_0x6352('0x26')](function(){return _0x36f9a7;})[_0x6352('0x26')](respondWithResult(_0x572ba5,null))[_0x6352('0x48')](handleError(_0x572ba5,null));};exports[_0x6352('0x96')]=function(_0x1c3630,_0x3711c8,_0x13cbe8){return db['Campaign'][_0x6352('0x4c')]({'where':{'id':_0x1c3630[_0x6352('0x4a')]['id']}})[_0x6352('0x26')](handleEntityNotFound(_0x3711c8,null))['then'](function(_0x549070){if(_0x549070){return _0x549070[_0x6352('0x96')](_0x1c3630['query'][_0x6352('0x69')]);}})[_0x6352('0x26')](function(_0x504d26){if(_0x504d26){return db[_0x6352('0x64')][_0x6352('0x27')]({'where':{'ListId':_0x1c3630[_0x6352('0x35')][_0x6352('0x69')],'CampaignId':_0x1c3630[_0x6352('0x4a')]['id']}})[_0x6352('0x26')](function(){return _0x504d26;});}})[_0x6352('0x26')](respondWithStatusCode(_0x3711c8,null))[_0x6352('0x48')](handleError(_0x3711c8,null));};