Built motion from commit 85328c08.|2.5.50
[motion2.git] / server / api / cmHopper / cmHopper.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 _0x8b19=['$lte','$ne','$eq','$not','$between','$notBetween','$notIn','$like','$notILike','$overlap','$contains','$contained','attributes','intersection','fields','hasOwnProperty','nolimit','order','sort','pick','where','merge','VIRTUAL','options','findAll','rows','catch','show','params','keys','includeAll','include','find','create','body','describe','VoiceQueueId','Campaign','CampaignId','omit','dataValues','createdAt','updatedAt','state','deleted','campaign','membername','user','format','YYYY-MM-DD\x20HH:mm:ss','calleridnum','campaigntype','queue','ivr','CmContact','ContactId','firstName','isNil','calleridname','lastName','finally','getVoiceQueues','outbound','preview','dialOrderByScheduledAt','dialPreviewAutoRecallMe','length','sequelize','transaction','filter','value','direction','prev','isEmpty','hopperIds','ASC','scheduledAt','literal','COALESCE(CmHopper.UserId,\x200)\x20ASC','DESC','priority','recallme','LOCK','UPDATE','Contact','Company','CmList','List','VoiceQueue','Queue','dialActive','hopperId','findOne','CmCompany','CmHopper,\x20%s,\x20%s,\x20%s','getOpenContacts','entity\x20not\x20found','getTimezones','push','utcOffset','timezones','zip-dir','request-promise','bluebird','mustache','path','sox','to-csv','fs-extra','lodash','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','undefined','count','offset','limit','Content-Range','apply','reject','save','update','then','destroy','error','stack','name','send','index','map','CmHopper','rawAttributes','type','key','model','query','filters','concat','$and','$or','$gt','$lt'];(function(_0x34f273,_0x37a8c3){var _0x1f2544=function(_0x1b9a6b){while(--_0x1b9a6b){_0x34f273['push'](_0x34f273['shift']());}};_0x1f2544(++_0x37a8c3);}(_0x8b19,0x1a1));var _0x98b1=function(_0xba6066,_0x318f7b){_0xba6066=_0xba6066-0x0;var _0x546a76=_0x8b19[_0xba6066];return _0x546a76;};'use strict';var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require(_0x98b1('0x0'));var jsonpatch=require('fast-json-patch');var rp=require(_0x98b1('0x1'));var moment=require('moment');var BPromise=require(_0x98b1('0x2'));var Mustache=require(_0x98b1('0x3'));var util=require('util');var path=require(_0x98b1('0x4'));var sox=require(_0x98b1('0x5'));var csv=require(_0x98b1('0x6'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x98b1('0x7'));var _=require(_0x98b1('0x8'));var squel=require('squel');var crypto=require(_0x98b1('0x9'));var jsforce=require(_0x98b1('0xa'));var deskjs=require(_0x98b1('0xb'));var toCsv=require(_0x98b1('0x6'));var querystring=require(_0x98b1('0xc'));var Papa=require(_0x98b1('0xd'));var Redis=require(_0x98b1('0xe'));var authService=require(_0x98b1('0xf'));var qs=require(_0x98b1('0x10'));var as=require(_0x98b1('0x11'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x98b1('0x12'))(_0x98b1('0x13'));var utils=require(_0x98b1('0x14'));var config=require('../../config/environment');var shared=require(_0x98b1('0x15'));var licenseUtil=require(_0x98b1('0x16'));var db=require(_0x98b1('0x17'))['db'];function respondWithStatusCode(_0x569b5e,_0x4b21bd){_0x4b21bd=_0x4b21bd||0xcc;return function(_0x57f460){if(_0x57f460){return _0x569b5e[_0x98b1('0x18')](_0x4b21bd);}return _0x569b5e[_0x98b1('0x19')](_0x4b21bd)[_0x98b1('0x1a')]();};}function respondWithResult(_0x2ad173,_0x3298d9){_0x3298d9=_0x3298d9||0xc8;return function(_0x232677){if(_0x232677){return _0x2ad173['status'](_0x3298d9)[_0x98b1('0x1b')](_0x232677);}};}function respondWithFilteredResult(_0x19ce84,_0x1b2788){return function(_0x57fb61){if(_0x57fb61){var _0x25eb60=typeof _0x1b2788['offset']===_0x98b1('0x1c')&&typeof _0x1b2788['limit']===_0x98b1('0x1c');var _0x3d78e9=_0x57fb61[_0x98b1('0x1d')];var _0x53b804=_0x25eb60?0x0:_0x1b2788['offset'];var _0x329279=_0x25eb60?_0x57fb61[_0x98b1('0x1d')]:_0x1b2788[_0x98b1('0x1e')]+_0x1b2788[_0x98b1('0x1f')];var _0x1d924f;if(_0x329279>=_0x3d78e9){_0x329279=_0x3d78e9;_0x1d924f=0xc8;}else{_0x1d924f=0xce;}_0x19ce84[_0x98b1('0x19')](_0x1d924f);return _0x19ce84['set'](_0x98b1('0x20'),_0x53b804+'-'+_0x329279+'/'+_0x3d78e9)['json'](_0x57fb61);}return null;};}function patchUpdates(_0x335fc5){return function(_0x30a7d5){try{jsonpatch[_0x98b1('0x21')](_0x30a7d5,_0x335fc5,!![]);}catch(_0x5517ad){return BPromise[_0x98b1('0x22')](_0x5517ad);}return _0x30a7d5[_0x98b1('0x23')]();};}function saveUpdates(_0xa4c391,_0x44d818){return function(_0x12e457){if(_0x12e457){return _0x12e457[_0x98b1('0x24')](_0xa4c391)[_0x98b1('0x25')](function(_0x257174){return _0x257174;});}return null;};}function removeEntity(_0x57cf59,_0x2f70e9){return function(_0x1c8c61){if(_0x1c8c61){return _0x1c8c61[_0x98b1('0x26')]()[_0x98b1('0x25')](function(){_0x57cf59[_0x98b1('0x19')](0xcc)['end']();});}};}function handleEntityNotFound(_0x2dbcb7,_0x4e9225){return function(_0x11110f){if(!_0x11110f){_0x2dbcb7[_0x98b1('0x18')](0x194);}return _0x11110f;};}function handleError(_0xdec995,_0x55282f){_0x55282f=_0x55282f||0x1f4;return function(_0x489dc2){logger[_0x98b1('0x27')](_0x489dc2[_0x98b1('0x28')]);if(_0x489dc2['name']){delete _0x489dc2[_0x98b1('0x29')];}_0xdec995[_0x98b1('0x19')](_0x55282f)[_0x98b1('0x2a')](_0x489dc2);};}exports[_0x98b1('0x2b')]=function(_0x2e37eb,_0x1b4183){var _0x2ca8aa={},_0x27ec56={},_0x2b45ff={'count':0x0,'rows':[]};var _0x3b54da=_[_0x98b1('0x2c')](db[_0x98b1('0x2d')][_0x98b1('0x2e')],function(_0x35b674){return{'name':_0x35b674['fieldName'],'type':_0x35b674[_0x98b1('0x2f')][_0x98b1('0x30')]};});_0x27ec56[_0x98b1('0x31')]=_['map'](_0x3b54da,_0x98b1('0x29'));_0x27ec56['query']=_['keys'](_0x2e37eb[_0x98b1('0x32')]);_0x27ec56[_0x98b1('0x33')]=_['intersection'](_0x27ec56[_0x98b1('0x31')],_0x27ec56[_0x98b1('0x32')]);_0x27ec56[_0x98b1('0x33')]=_[_0x98b1('0x34')](_0x27ec56[_0x98b1('0x33')],[_0x98b1('0x35'),_0x98b1('0x36'),_0x98b1('0x37'),'$gte',_0x98b1('0x38'),_0x98b1('0x39'),_0x98b1('0x3a'),_0x98b1('0x3b'),_0x98b1('0x3c'),_0x98b1('0x3d'),_0x98b1('0x3e'),'$in',_0x98b1('0x3f'),_0x98b1('0x40'),'$notLike','$iLike',_0x98b1('0x41'),_0x98b1('0x40'),_0x98b1('0x42'),_0x98b1('0x43'),_0x98b1('0x44'),'$any']);_0x2ca8aa[_0x98b1('0x45')]=_[_0x98b1('0x46')](_0x27ec56[_0x98b1('0x31')],qs[_0x98b1('0x47')](_0x2e37eb[_0x98b1('0x32')][_0x98b1('0x47')]));_0x2ca8aa[_0x98b1('0x45')]=_0x2ca8aa['attributes']['length']?_0x2ca8aa[_0x98b1('0x45')]:_0x27ec56[_0x98b1('0x31')];if(!_0x2e37eb[_0x98b1('0x32')][_0x98b1('0x48')](_0x98b1('0x49'))){_0x2ca8aa['limit']=qs[_0x98b1('0x1f')](_0x2e37eb[_0x98b1('0x32')]['limit']);_0x2ca8aa[_0x98b1('0x1e')]=qs[_0x98b1('0x1e')](_0x2e37eb[_0x98b1('0x32')]['offset']);}_0x2ca8aa[_0x98b1('0x4a')]=qs[_0x98b1('0x4b')](_0x2e37eb[_0x98b1('0x32')]['sort']);_0x2ca8aa['where']=qs[_0x98b1('0x33')](_[_0x98b1('0x4c')](_0x2e37eb[_0x98b1('0x32')],_0x27ec56[_0x98b1('0x33')]),_0x3b54da);if(_0x2e37eb['query']['filter']){_0x2ca8aa[_0x98b1('0x4d')]=_[_0x98b1('0x4e')](_0x2ca8aa[_0x98b1('0x4d')],{'$or':_['map'](_0x3b54da,function(_0x598451){if(_0x598451[_0x98b1('0x2f')]!==_0x98b1('0x4f')){var _0xb53870={};_0xb53870[_0x598451['name']]={'$like':'%'+_0x2e37eb[_0x98b1('0x32')]['filter']+'%'};return _0xb53870;}})});}_0x2ca8aa=_['merge']({},_0x2ca8aa,_0x2e37eb[_0x98b1('0x50')]);var _0xd703d6={'where':_0x2ca8aa[_0x98b1('0x4d')]};return db[_0x98b1('0x2d')][_0x98b1('0x1d')](_0xd703d6)['then'](function(_0x32c649){_0x2b45ff[_0x98b1('0x1d')]=_0x32c649;if(_0x2e37eb[_0x98b1('0x32')]['includeAll']){_0x2ca8aa['include']=[{'all':!![]}];}return db[_0x98b1('0x2d')][_0x98b1('0x51')](_0x2ca8aa);})[_0x98b1('0x25')](function(_0x5d8354){_0x2b45ff[_0x98b1('0x52')]=_0x5d8354;return _0x2b45ff;})['then'](respondWithFilteredResult(_0x1b4183,_0x2ca8aa))[_0x98b1('0x53')](handleError(_0x1b4183,null));};exports[_0x98b1('0x54')]=function(_0x5d1787,_0x431c78){var _0x253024={'raw':!![],'where':{'id':_0x5d1787[_0x98b1('0x55')]['id']}},_0x51ca5a={};_0x51ca5a['model']=_[_0x98b1('0x56')](db['CmHopper'][_0x98b1('0x2e')]);_0x51ca5a[_0x98b1('0x32')]=_[_0x98b1('0x56')](_0x5d1787[_0x98b1('0x32')]);_0x51ca5a[_0x98b1('0x33')]=_[_0x98b1('0x46')](_0x51ca5a['model'],_0x51ca5a[_0x98b1('0x32')]);_0x253024[_0x98b1('0x45')]=_[_0x98b1('0x46')](_0x51ca5a[_0x98b1('0x31')],qs[_0x98b1('0x47')](_0x5d1787[_0x98b1('0x32')][_0x98b1('0x47')]));_0x253024['attributes']=_0x253024[_0x98b1('0x45')]['length']?_0x253024[_0x98b1('0x45')]:_0x51ca5a[_0x98b1('0x31')];if(_0x5d1787[_0x98b1('0x32')][_0x98b1('0x57')]){_0x253024[_0x98b1('0x58')]=[{'all':!![]}];}_0x253024=_[_0x98b1('0x4e')]({},_0x253024,_0x5d1787[_0x98b1('0x50')]);return db[_0x98b1('0x2d')][_0x98b1('0x59')](_0x253024)[_0x98b1('0x25')](handleEntityNotFound(_0x431c78,null))[_0x98b1('0x25')](respondWithResult(_0x431c78,null))[_0x98b1('0x53')](handleError(_0x431c78,null));};exports[_0x98b1('0x5a')]=function(_0x1a1a04,_0x2b48bd){return db[_0x98b1('0x2d')][_0x98b1('0x5a')](_0x1a1a04[_0x98b1('0x5b')],{})[_0x98b1('0x25')](respondWithResult(_0x2b48bd,0xc9))[_0x98b1('0x53')](handleError(_0x2b48bd,null));};exports[_0x98b1('0x24')]=function(_0xe07c11,_0x779f66){if(_0xe07c11[_0x98b1('0x5b')]['id']){delete _0xe07c11['body']['id'];}return db['CmHopper']['find']({'where':{'id':_0xe07c11[_0x98b1('0x55')]['id']}})[_0x98b1('0x25')](handleEntityNotFound(_0x779f66,null))[_0x98b1('0x25')](saveUpdates(_0xe07c11['body'],null))[_0x98b1('0x25')](respondWithResult(_0x779f66,null))[_0x98b1('0x53')](handleError(_0x779f66,null));};exports[_0x98b1('0x5c')]=function(_0x514ec3,_0x4a6fa3){return db[_0x98b1('0x2d')][_0x98b1('0x5c')]()[_0x98b1('0x25')](respondWithResult(_0x4a6fa3,null))[_0x98b1('0x53')](handleError(_0x4a6fa3,null));};exports[_0x98b1('0x26')]=function(_0x1574cf,_0x5cac20){var _0x619ef5;return db[_0x98b1('0x2d')][_0x98b1('0x59')]({'where':{'id':_0x1574cf[_0x98b1('0x55')]['id']}})[_0x98b1('0x25')](handleEntityNotFound(_0x5cac20,null))['then'](function(_0x3cb689){if(_0x3cb689){return _0x3cb689['destroy']()[_0x98b1('0x25')](function(_0x381e4a){return _0x381e4a;});}})[_0x98b1('0x25')](function(_0x17ed15){_0x619ef5=_0x17ed15;if(_0x17ed15){if(_0x17ed15[_0x98b1('0x5d')]||_0x17ed15['CampaignId']){return db[_0x17ed15[_0x98b1('0x5d')]?'VoiceQueue':_0x98b1('0x5e')][_0x98b1('0x59')]({'where':{'id':_0x17ed15[_0x98b1('0x5d')]?_0x17ed15[_0x98b1('0x5d')]:_0x17ed15[_0x98b1('0x5f')]},'attributes':['id','name'],'raw':!![]});}}})[_0x98b1('0x25')](function(_0x219f80){var _0x4b7c9f={};if(_0x219f80){_[_0x98b1('0x4e')](_0x4b7c9f,_[_0x98b1('0x60')](_0x619ef5[_0x98b1('0x61')],[_0x98b1('0x62'),_0x98b1('0x63'),'id']));_0x4b7c9f[_0x98b1('0x64')]=0x15;_0x4b7c9f['statedesc']=_0x98b1('0x65');_0x4b7c9f[_0x98b1('0x66')]=_0x219f80[_0x98b1('0x29')];_0x4b7c9f[_0x98b1('0x67')]=_0x1574cf[_0x98b1('0x68')][_0x98b1('0x29')];_0x4b7c9f['UserId']=_0x1574cf['user']['id'];_0x4b7c9f['deleted']=!![];_0x4b7c9f['deletedat']=moment()[_0x98b1('0x69')](_0x98b1('0x6a'));_0x4b7c9f[_0x98b1('0x6b')]=_0x619ef5['phone'];_0x4b7c9f[_0x98b1('0x6c')]=_0x619ef5[_0x98b1('0x5d')]?_0x98b1('0x6d'):_0x98b1('0x6e');return db[_0x98b1('0x6f')][_0x98b1('0x59')]({'where':{'id':_0x4b7c9f[_0x98b1('0x70')]},'attributes':[_0x98b1('0x71'),'lastName']})['then'](function(_0x95a634){if(!_[_0x98b1('0x72')](_0x5cac20)&&!_[_0x98b1('0x72')](_0x95a634[_0x98b1('0x71')])){_0x4b7c9f[_0x98b1('0x73')]=_0x95a634[_0x98b1('0x71')];if(!_['isNil'](_0x95a634[_0x98b1('0x74')])){_0x4b7c9f[_0x98b1('0x73')]+='\x20'+_0x95a634[_0x98b1('0x74')];}}})[_0x98b1('0x75')](function(){return db['CmHopperFinal'][_0x98b1('0x5a')](_0x4b7c9f);});}})['then'](function(){return _0x5cac20['status'](0xcc)[_0x98b1('0x1a')]();})['catch'](handleError(_0x5cac20,null));};exports['getPreview']=function(_0x1aee01,_0x1a824b,_0x404dbd){var _0x47df83=[];return db[_0x98b1('0x6f')][_0x98b1('0x5c')]()[_0x98b1('0x25')](function(_0x2aaef1){_0x47df83=_[_0x98b1('0x56')](_0x2aaef1);return _0x1aee01[_0x98b1('0x68')][_0x98b1('0x76')]({'where':{'type':_0x98b1('0x77'),'dialActive':!![],'dialMethod':_0x98b1('0x78')},'attributes':['id',_0x98b1('0x79'),_0x98b1('0x7a')],'raw':!![]});})[_0x98b1('0x25')](function(_0x212b26){if(_0x212b26&&_0x212b26[_0x98b1('0x7b')]){return db[_0x98b1('0x7c')][_0x98b1('0x7d')](function(_0x572008){var _0x665fc1={'active':![],'recallme':![],'scheduledAt':{'$lte':moment()['format'](_0x98b1('0x6a'))},'VoiceQueueId':{'$in':_['map'](_0x212b26,'id')},'$or':[{'UserId':null},{'UserId':_0x1aee01[_0x98b1('0x68')]['id']}]};var _0x55dac8={'active':![],'recallme':!![],'VoiceQueueId':{'$in':_(_0x212b26)[_0x98b1('0x7e')]([_0x98b1('0x7a'),0x0])['map']('id')[_0x98b1('0x7f')]()},'$or':[{'UserId':null},{'UserId':_0x1aee01[_0x98b1('0x68')]['id']}]};var _0x5447ea={'$or':[_0x665fc1,_0x55dac8]};var _0x110e6a=[];if(_0x1aee01[_0x98b1('0x5b')][_0x98b1('0x80')]&&_0x1aee01[_0x98b1('0x5b')]['direction']===_0x98b1('0x81')){if(!_[_0x98b1('0x82')](_0x1aee01[_0x98b1('0x5b')][_0x98b1('0x83')])){_0x5447ea['id']={'$in':_0x1aee01[_0x98b1('0x5b')][_0x98b1('0x83')]};}_0x110e6a=[['priority',_0x98b1('0x84')],[_0x98b1('0x85'),_0x212b26[0x0][_0x98b1('0x79')]===_0x98b1('0x84')?'DESC':_0x98b1('0x84')],db[_0x98b1('0x7c')][_0x98b1('0x86')](_0x98b1('0x87')),['id',_0x98b1('0x88')]];}else{if(!_[_0x98b1('0x82')](_0x1aee01['body'][_0x98b1('0x83')])){_0x5447ea['id']={'$notIn':_0x1aee01[_0x98b1('0x5b')][_0x98b1('0x83')]};}_0x110e6a=[[_0x98b1('0x89'),'DESC'],[_0x98b1('0x85'),_0x212b26[0x0][_0x98b1('0x79')]],db[_0x98b1('0x7c')][_0x98b1('0x86')]('COALESCE(CmHopper.UserId,\x200)\x20DESC'),['id',_0x98b1('0x84')]];}return db[_0x98b1('0x2d')]['findOne']({'attributes':['id','scheduledat',_0x98b1('0x8a')],'where':_0x5447ea,'order':_0x110e6a,'transaction':_0x572008,'lock':_0x572008[_0x98b1('0x8b')][_0x98b1('0x8c')],'include':[{'model':db['CmContact'],'as':_0x98b1('0x8d'),'attributes':_0x47df83,'include':[{'model':db['CmCompany'],'as':_0x98b1('0x8e'),'attributes':['id','name']}]},{'model':db[_0x98b1('0x8f')],'as':_0x98b1('0x90'),'attributes':['id',_0x98b1('0x29')]},{'model':db[_0x98b1('0x91')],'as':_0x98b1('0x92'),'attributes':['id',_0x98b1('0x29'),_0x98b1('0x93')]}]})[_0x98b1('0x25')](function(_0x3e2226){if(_0x3e2226){return _0x3e2226['update']({'UserId':_0x1aee01[_0x98b1('0x68')]['id']},{'transaction':_0x572008});}});});}})[_0x98b1('0x25')](handleEntityNotFound(_0x1a824b,null))['then'](respondWithResult(_0x1a824b,null))['catch'](handleError(_0x1a824b,null));};exports['getPreviewRecall']=function(_0xb91713,_0x332c53,_0x54bbd8){var _0x3e5e83=[];return db['CmContact'][_0x98b1('0x5c')]()[_0x98b1('0x25')](function(_0x3ba499){_0x3e5e83=_['keys'](_0x3ba499);return _0xb91713[_0x98b1('0x68')][_0x98b1('0x76')]({'where':{'type':_0x98b1('0x77'),'dialActive':!![],'dialMethod':_0x98b1('0x78')},'attributes':['id',_0x98b1('0x79'),_0x98b1('0x7a')],'raw':!![]});})[_0x98b1('0x25')](function(_0x19e27b){if(_0x19e27b&&_0x19e27b[_0x98b1('0x7b')]){return db['sequelize'][_0x98b1('0x7d')](function(_0x2e2092){var _0x3819f3={'active':![],'recallme':!![],'id':_0xb91713[_0x98b1('0x5b')][_0x98b1('0x94')]};return db[_0x98b1('0x2d')][_0x98b1('0x95')]({'attributes':['id','scheduledat','recallme'],'where':_0x3819f3,'transaction':_0x2e2092,'lock':_0x2e2092[_0x98b1('0x8b')][_0x98b1('0x8c')],'include':[{'model':db[_0x98b1('0x6f')],'as':'Contact','attributes':_0x3e5e83,'include':[{'model':db[_0x98b1('0x96')],'as':_0x98b1('0x8e'),'attributes':['id',_0x98b1('0x29')]}]},{'model':db[_0x98b1('0x8f')],'as':_0x98b1('0x90'),'attributes':['id',_0x98b1('0x29')]},{'model':db[_0x98b1('0x91')],'as':_0x98b1('0x92'),'attributes':['id','name',_0x98b1('0x93')]}]})[_0x98b1('0x25')](function(_0x13e6ad){if(_0x13e6ad){return _0x13e6ad[_0x98b1('0x24')]({'UserId':_0xb91713['user']['id']},{'transaction':_0x2e2092});}});});}})['then'](handleEntityNotFound(_0x332c53,null))[_0x98b1('0x25')](respondWithResult(_0x332c53,null))['catch'](handleError(_0x332c53,null));};exports['getOpenContacts']=function(_0x26117a,_0xb99ccc,_0x498b6f){return _0x26117a[_0x98b1('0x68')][_0x98b1('0x76')]({'where':{'type':_0x98b1('0x77'),'dialActive':!![],'dialMethod':_0x98b1('0x78')},'attributes':['id'],'raw':!![]})[_0x98b1('0x25')](function(_0x25a1d7){if(_0x25a1d7&&_0x25a1d7[_0x98b1('0x7b')]){return db['CmHopper'][_0x98b1('0x1d')]({'where':{'active':![],'recallme':![],'scheduledAt':{'$lte':moment()[_0x98b1('0x69')](_0x98b1('0x6a'))},'VoiceQueueId':{'$in':_[_0x98b1('0x2c')](_0x25a1d7,'id')},'$or':[{'UserId':null},{'UserId':_0x26117a[_0x98b1('0x68')]['id']}]}});}return 0x0;})['then'](function(_0x5dd80c){if(!_[_0x98b1('0x72')](_0x5dd80c)&&_['isNumber'](_0x5dd80c)){return _0xb99ccc[_0x98b1('0x19')](0xc8)[_0x98b1('0x1b')]({'contacts':_0x5dd80c});}else{logger['error'](_0x98b1('0x97'),_0x98b1('0x98'),0x194,_0x98b1('0x99'));_0xb99ccc['sendStatus'](0x194);}})[_0x98b1('0x53')](handleError(_0xb99ccc,null));};exports[_0x98b1('0x9a')]=function(_0x3d4ef5,_0x2cfad7,_0x22f247){var _0x4b0e24=shared['timezones'];var _0x4dd60a=[];_[_0x98b1('0x2c')](_0x4b0e24,function(_0x13f902){_0x4dd60a[_0x98b1('0x9b')]({'id':_0x13f902[_0x98b1('0x29')],'name':_0x13f902[_0x98b1('0x29')],'utcOffset':_0x13f902[_0x98b1('0x9c')]});});return _0x2cfad7[_0x98b1('0x19')](0xc8)['json']({'tz':_0x4dd60a});};exports['getTimezone']=function(_0x3dcc88,_0x2a0393,_0x1042d1){var _0x4f4532=shared[_0x98b1('0x9d')];var _0x3e6963={};if(!_['isNil'](_0x4f4532[_0x3dcc88[_0x98b1('0x5b')]['id']]))_0x3e6963=_0x4f4532[_0x3dcc88[_0x98b1('0x5b')]['id']];return _0x2a0393[_0x98b1('0x19')](0xc8)[_0x98b1('0x1b')](_0x3e6963);};