af3682fc5b9dae716f1ee1410a55278b204f3b02
[motion2.git] / server / api / voiceQueue / voiceQueue.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 _0x3ffc=['ids','select','field','tq.TeamId','team_has_voice_queues','join','user_has_teams','ut.TeamId\x20=\x20tq.TeamId','VoiceQueueId\x20=\x20?','push','QueryTypes','SELECT','TeamId','union','compact','removeAgents','UserVoiceQueueRt','emit','addAgents','spread','userVoiceQueue:save','isEmpty','format','all','isArray','userVoiceQueue:remove','getAgents','getMembers','getLists','CmList','addLists','dialCheckDuplicateType','always','insert','cm_hopper','fromQuery','phone','scheduledAt','ContactId','NOW()','toString','from','cm_contacts','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','COALESCE(calleridnum,\x27\x27)','cm_hopper_final','COALESCE(phone,\x27\x27)','onlyIfOpen','into','ListId','CmListId','deletedAt\x20IS\x20NULL','removeLists','getBlackLists','addBlackLists','cm_hopper_black','removeBlackLists','html-pdf','rimraf','request-promise','moment','bluebird','util','path','to-csv','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','defaults','localhost','socket.io-emitter','redis','./voiceQueue.socket','register','sendStatus','end','offset','status','set','apply','update','then','VoiceQueues','inbound','QueueCampaigns','filter','map','value','type','find','name','destroy','error','stack','index','VoiceQueue','rawAttributes','query','keys','filters','intersection','model','fields','attributes','length','hasOwnProperty','limit','order','sort','where','key','VIRTUAL','merge','count','includeAll','findAll','rows','catch','show','options','create','body','user','UserProfileSection','userProfileId','autoAssociation','UserProfileResource','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','params','include','get','omit','createdAt','updatedAt','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','outbound','findOne','pick','CmHopper','getHopperHistories','CmHopperHistory','nolimit','VoiceQueueId','CmHopperFinal','getHopperBlacks','CmHopperBlack','getTeams','Team','addTeams','User','Agents','online','voicePause','interface','flatMap','forEach','penalty','sequelize','transaction','UserVoiceQueue','findOrCreate','each','upsert','isNil','SIP/%s','removeTeams'];(function(_0x1dd657,_0x323f4){var _0x5a7e2d=function(_0x486cea){while(--_0x486cea){_0x1dd657['push'](_0x1dd657['shift']());}};_0x5a7e2d(++_0x323f4);}(_0x3ffc,0xf2));var _0xc3ff=function(_0x20c205,_0x39bc5e){_0x20c205=_0x20c205-0x0;var _0x3d6cf2=_0x3ffc[_0x20c205];return _0x3d6cf2;};'use strict';var pdf=require(_0xc3ff('0x0'));var emlformat=require('eml-format');var rimraf=require(_0xc3ff('0x1'));var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require(_0xc3ff('0x2'));var moment=require(_0xc3ff('0x3'));var BPromise=require(_0xc3ff('0x4'));var Mustache=require('mustache');var util=require(_0xc3ff('0x5'));var path=require(_0xc3ff('0x6'));var sox=require('sox');var csv=require(_0xc3ff('0x7'));var ejs=require('ejs');var fs=require('fs');var _=require(_0xc3ff('0x8'));var squel=require(_0xc3ff('0x9'));var crypto=require(_0xc3ff('0xa'));var jsforce=require(_0xc3ff('0xb'));var deskjs=require(_0xc3ff('0xc'));var toCsv=require(_0xc3ff('0x7'));var querystring=require(_0xc3ff('0xd'));var Papa=require(_0xc3ff('0xe'));var Redis=require(_0xc3ff('0xf'));var authService=require(_0xc3ff('0x10'));var qs=require(_0xc3ff('0x11'));var hardwareService=require(_0xc3ff('0x12'));var logger=require(_0xc3ff('0x13'))(_0xc3ff('0x14'));var utils=require(_0xc3ff('0x15'));var config=require(_0xc3ff('0x16'));var db=require(_0xc3ff('0x17'))['db'];config['redis']=_[_0xc3ff('0x18')](config['redis'],{'host':_0xc3ff('0x19'),'port':0x18eb});var socket=require(_0xc3ff('0x1a'))(new Redis(config[_0xc3ff('0x1b')]));require(_0xc3ff('0x1c'))[_0xc3ff('0x1d')](socket);function respondWithStatusCode(_0x56e5fe,_0x3a4ca0){_0x3a4ca0=_0x3a4ca0||0xcc;return function(_0xffe5d8){if(_0xffe5d8){return _0x56e5fe[_0xc3ff('0x1e')](_0x3a4ca0);}return _0x56e5fe['status'](_0x3a4ca0)[_0xc3ff('0x1f')]();};}function respondWithResult(_0x25c67e,_0x56a14e){_0x56a14e=_0x56a14e||0xc8;return function(_0x1d0dec){if(_0x1d0dec){return _0x25c67e['status'](_0x56a14e)['json'](_0x1d0dec);}};}function respondWithFilteredResult(_0x127ec7,_0x255187){return function(_0x2a2e23){if(_0x2a2e23){var _0x160b93=_0x2a2e23['count'],_0x3ba5e9=_0x255187[_0xc3ff('0x20')],_0x51c747=_0x255187[_0xc3ff('0x20')]+_0x255187['limit'],_0x1015d8;if(_0x51c747>=_0x160b93){_0x51c747=_0x160b93;_0x1015d8=0xc8;}else{_0x1015d8=0xce;}_0x127ec7[_0xc3ff('0x21')](_0x1015d8);return _0x127ec7[_0xc3ff('0x22')]('Content-Range',_0x3ba5e9+'-'+_0x51c747+'/'+_0x160b93)['json'](_0x2a2e23);}return null;};}function patchUpdates(_0x370650){return function(_0x1115a8){try{jsonpatch[_0xc3ff('0x23')](_0x1115a8,_0x370650,!![]);}catch(_0x4fb756){return BPromise['reject'](_0x4fb756);}return _0x1115a8['save']();};}function saveUpdates(_0x101506,_0x5e87b7){return function(_0x11a677){if(_0x11a677){return _0x11a677[_0xc3ff('0x24')](_0x101506)[_0xc3ff('0x25')](function(_0x4c6d0b){return _0x4c6d0b;});}return null;};}function removeEntity(_0xc4e667,_0x1de88d){return function(_0x31e4a9){if(_0x31e4a9){return _0x31e4a9['destroy']()[_0xc3ff('0x25')](function(){var _0x31c38f=_0x31e4a9['get']({'plain':!![]});var _0x534d97=[{'name':_0xc3ff('0x26'),'value':_0xc3ff('0x27'),'ignore':![]},{'name':_0xc3ff('0x28'),'value':'outbound','ignore':![]}];var _0x1bdeb6=_(_0x534d97)[_0xc3ff('0x29')]('ignore')[_0xc3ff('0x2a')](_0xc3ff('0x2b'))[_0xc3ff('0x2b')]();if(_['includes'](_0x1bdeb6,_0x31c38f[_0xc3ff('0x2c')])){return;}var _0xd4609a=_[_0xc3ff('0x2d')](_0x534d97,['value',_0x31c38f[_0xc3ff('0x2c')]])[_0xc3ff('0x2e')];return db['UserProfileResource'][_0xc3ff('0x2f')]({'where':{'type':_0xd4609a,'resourceId':_0x31c38f['id']}})['then'](function(){return _0x31e4a9;});})['then'](function(){_0xc4e667[_0xc3ff('0x21')](0xcc)[_0xc3ff('0x1f')]();});}};}function handleEntityNotFound(_0x31a8dc,_0x14de81){return function(_0x397d64){if(!_0x397d64){_0x31a8dc[_0xc3ff('0x1e')](0x194);}return _0x397d64;};}function handleError(_0x43507c,_0x54d3d9){_0x54d3d9=_0x54d3d9||0x1f4;return function(_0x3eaacc){logger[_0xc3ff('0x30')](_0x3eaacc[_0xc3ff('0x31')]);if(_0x3eaacc[_0xc3ff('0x2e')]){delete _0x3eaacc[_0xc3ff('0x2e')];}_0x43507c[_0xc3ff('0x21')](_0x54d3d9)['send'](_0x3eaacc);};}exports[_0xc3ff('0x32')]=function(_0x32ce91,_0x48e9a0){var _0x5626b1={},_0x385860={},_0x583bae={'count':0x0,'rows':[]};var _0x59ba9d=db[_0xc3ff('0x33')][_0xc3ff('0x34')];_0x385860['model']=_['keys'](_0x59ba9d);_0x385860[_0xc3ff('0x35')]=_[_0xc3ff('0x36')](_0x32ce91['query']);_0x385860[_0xc3ff('0x37')]=_[_0xc3ff('0x38')](_0x385860[_0xc3ff('0x39')],_0x385860[_0xc3ff('0x35')]);_0x5626b1['attributes']=_[_0xc3ff('0x38')](_0x385860['model'],qs[_0xc3ff('0x3a')](_0x32ce91['query'][_0xc3ff('0x3a')]));_0x5626b1[_0xc3ff('0x3b')]=_0x5626b1[_0xc3ff('0x3b')][_0xc3ff('0x3c')]?_0x5626b1[_0xc3ff('0x3b')]:_0x385860[_0xc3ff('0x39')];if(!_0x32ce91[_0xc3ff('0x35')][_0xc3ff('0x3d')]('nolimit')){_0x5626b1[_0xc3ff('0x3e')]=qs['limit'](_0x32ce91['query'][_0xc3ff('0x3e')]);_0x5626b1[_0xc3ff('0x20')]=qs[_0xc3ff('0x20')](_0x32ce91[_0xc3ff('0x35')]['offset']);}_0x5626b1[_0xc3ff('0x3f')]=qs[_0xc3ff('0x40')](_0x32ce91[_0xc3ff('0x35')]['sort']);_0x5626b1['where']=qs[_0xc3ff('0x37')](_['pick'](_0x32ce91[_0xc3ff('0x35')],_0x385860[_0xc3ff('0x37')]));if(_0x32ce91[_0xc3ff('0x35')][_0xc3ff('0x29')]){_0x5626b1['where']=_['merge'](_0x5626b1[_0xc3ff('0x41')],{'$or':_['map'](_0x59ba9d,function(_0x45874d){if(_0x45874d['type'][_0xc3ff('0x42')]!==_0xc3ff('0x43')){var _0x26e616={};_0x26e616[_0x45874d['field']]={'$like':'%'+_0x32ce91[_0xc3ff('0x35')][_0xc3ff('0x29')]+'%'};return _0x26e616;}})});}_0x5626b1=_[_0xc3ff('0x44')]({},_0x5626b1,_0x32ce91['options']);var _0x45f66e={'where':_0x5626b1[_0xc3ff('0x41')]};return db[_0xc3ff('0x33')][_0xc3ff('0x45')](_0x45f66e)[_0xc3ff('0x25')](function(_0x422d2b){_0x583bae[_0xc3ff('0x45')]=_0x422d2b;if(_0x32ce91[_0xc3ff('0x35')][_0xc3ff('0x46')]){_0x5626b1['include']=[{'all':!![]}];}return db[_0xc3ff('0x33')][_0xc3ff('0x47')](_0x5626b1);})[_0xc3ff('0x25')](function(_0x5ed378){_0x583bae[_0xc3ff('0x48')]=_0x5ed378;return _0x583bae;})[_0xc3ff('0x25')](respondWithFilteredResult(_0x48e9a0,_0x5626b1))[_0xc3ff('0x49')](handleError(_0x48e9a0,null));};exports[_0xc3ff('0x4a')]=function(_0x4d4a43,_0x14f094){var _0x551402={'raw':![],'where':{'id':_0x4d4a43['params']['id']}},_0x5362f4={};_0x5362f4[_0xc3ff('0x39')]=_[_0xc3ff('0x36')](db[_0xc3ff('0x33')][_0xc3ff('0x34')]);_0x5362f4[_0xc3ff('0x35')]=_[_0xc3ff('0x36')](_0x4d4a43['query']);_0x5362f4[_0xc3ff('0x37')]=_['intersection'](_0x5362f4[_0xc3ff('0x39')],_0x5362f4[_0xc3ff('0x35')]);_0x551402[_0xc3ff('0x3b')]=_[_0xc3ff('0x38')](_0x5362f4[_0xc3ff('0x39')],qs['fields'](_0x4d4a43[_0xc3ff('0x35')][_0xc3ff('0x3a')]));_0x551402['attributes']=_0x551402[_0xc3ff('0x3b')][_0xc3ff('0x3c')]?_0x551402['attributes']:_0x5362f4[_0xc3ff('0x39')];if(_0x4d4a43[_0xc3ff('0x35')]['includeAll']){_0x551402['include']=[{'all':!![]}];}_0x551402=_['merge']({},_0x551402,_0x4d4a43[_0xc3ff('0x4b')]);return db['VoiceQueue'][_0xc3ff('0x2d')](_0x551402)['then'](handleEntityNotFound(_0x14f094,null))[_0xc3ff('0x25')](respondWithResult(_0x14f094,null))['catch'](handleError(_0x14f094,null));};exports[_0xc3ff('0x4c')]=function(_0x3b1646,_0x543a86){return db[_0xc3ff('0x33')][_0xc3ff('0x4c')](_0x3b1646[_0xc3ff('0x4d')],{})[_0xc3ff('0x25')](function(_0x48c7f2){var _0x597929=_0x3b1646[_0xc3ff('0x4e')]['get']({'plain':!![]});if(!_0x597929)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x597929['role']===_0xc3ff('0x4e')){var _0x4f877f=_0x48c7f2['get']({'plain':!![]});var _0x21585f=[{'name':_0xc3ff('0x26'),'value':_0xc3ff('0x27')},{'name':_0xc3ff('0x28'),'value':'outbound'}];var _0x2e272c=_[_0xc3ff('0x2d')](_0x21585f,[_0xc3ff('0x2b'),_0x4f877f['type']])['name'];return db[_0xc3ff('0x4f')]['find']({'where':{'name':_0x2e272c,'userProfileId':_0x597929[_0xc3ff('0x50')]},'raw':!![]})[_0xc3ff('0x25')](function(_0x359690){if(_0x359690&&_0x359690[_0xc3ff('0x51')]===0x0){return db[_0xc3ff('0x52')][_0xc3ff('0x4c')]({'name':_0x4f877f[_0xc3ff('0x2e')],'resourceId':_0x4f877f['id'],'type':_0x359690[_0xc3ff('0x2e')],'sectionId':_0x359690['id']},{})['then'](function(){return _0x48c7f2;});}else{return _0x48c7f2;}})[_0xc3ff('0x49')](function(_0x458bba){logger[_0xc3ff('0x30')](_0xc3ff('0x53'),_0x458bba);throw _0x458bba;});}return _0x48c7f2;})['then'](respondWithResult(_0x543a86,0xc9))[_0xc3ff('0x49')](handleError(_0x543a86,null));};exports[_0xc3ff('0x54')]=function(_0x18f98c,_0x4e475d){var _0x35f28b={'raw':![],'where':{'id':_0x18f98c[_0xc3ff('0x55')]['id']}},_0x2e7803={};_0x2e7803[_0xc3ff('0x39')]=_[_0xc3ff('0x36')](db[_0xc3ff('0x33')][_0xc3ff('0x34')]);_0x35f28b[_0xc3ff('0x3b')]=_[_0xc3ff('0x38')](_0x2e7803[_0xc3ff('0x39')],qs[_0xc3ff('0x3a')](_0x18f98c['query'][_0xc3ff('0x3a')]));_0x35f28b[_0xc3ff('0x3b')]=_0x35f28b['attributes'][_0xc3ff('0x3c')]?_0x35f28b['attributes']:_0x2e7803[_0xc3ff('0x39')];if(_0x18f98c[_0xc3ff('0x35')][_0xc3ff('0x46')]){_0x35f28b[_0xc3ff('0x56')]=[{'all':!![]}];}_0x35f28b=_['merge']({},_0x35f28b,_0x18f98c[_0xc3ff('0x4b')]);return db[_0xc3ff('0x33')][_0xc3ff('0x2d')](_0x35f28b)['then'](handleEntityNotFound(_0x4e475d,null))['then'](function(_0x392648){if(_0x392648){var _0xaafaa4=_0x392648[_0xc3ff('0x57')]({'plain':!![]});_0xaafaa4=qs[_0xc3ff('0x58')](_0xaafaa4,['id',_0xc3ff('0x59'),_0xc3ff('0x5a')]);_0x18f98c[_0xc3ff('0x4d')]=_['omit'](_0x18f98c[_0xc3ff('0x4d')],['id','createdAt',_0xc3ff('0x5a')]);return db[_0xc3ff('0x33')][_0xc3ff('0x4c')](_['merge'](_0xaafaa4,_0x18f98c['body']),{'include':_0x18f98c['query']['includeAll']?[{'all':!![]}]:undefined})[_0xc3ff('0x25')](function(_0x135c99){var _0x4a0789=_0x18f98c[_0xc3ff('0x4e')][_0xc3ff('0x57')]({'plain':!![]});if(!_0x4a0789)throw new Error(_0xc3ff('0x5b'));if(_0x4a0789[_0xc3ff('0x5c')]==='user'){var _0x1a2fe6=_0x135c99[_0xc3ff('0x57')]({'plain':!![]});var _0x54a56f=[{'name':_0xc3ff('0x26'),'value':'inbound'},{'name':_0xc3ff('0x28'),'value':_0xc3ff('0x5d')}];var _0x41fbb6=_['find'](_0x54a56f,[_0xc3ff('0x2b'),_0x1a2fe6[_0xc3ff('0x2c')]])[_0xc3ff('0x2e')];return db[_0xc3ff('0x4f')]['find']({'where':{'name':_0x41fbb6,'userProfileId':_0x4a0789[_0xc3ff('0x50')]},'raw':!![]})[_0xc3ff('0x25')](function(_0x31f385){if(_0x31f385&&_0x31f385['autoAssociation']===0x0){return db[_0xc3ff('0x52')][_0xc3ff('0x4c')]({'name':_0x1a2fe6[_0xc3ff('0x2e')],'resourceId':_0x1a2fe6['id'],'type':_0x31f385[_0xc3ff('0x2e')],'sectionId':_0x31f385['id']},{})['then'](function(){return _0x135c99;});}else{return _0x135c99;}})[_0xc3ff('0x49')](function(_0x2bbe95){logger[_0xc3ff('0x30')](_0xc3ff('0x53'),_0x2bbe95);throw _0x2bbe95;});}return _0x135c99;});}})[_0xc3ff('0x25')](respondWithResult(_0x4e475d,0xc9))[_0xc3ff('0x49')](handleError(_0x4e475d,null));};exports[_0xc3ff('0x24')]=function(_0x72e37,_0x333cff){if(_0x72e37[_0xc3ff('0x4d')]['id']){delete _0x72e37[_0xc3ff('0x4d')]['id'];}return db[_0xc3ff('0x33')][_0xc3ff('0x2d')]({'where':{'id':_0x72e37[_0xc3ff('0x55')]['id']}})[_0xc3ff('0x25')](handleEntityNotFound(_0x333cff,null))['then'](saveUpdates(_0x72e37[_0xc3ff('0x4d')],null))[_0xc3ff('0x25')](respondWithResult(_0x333cff,null))['catch'](handleError(_0x333cff,null));};exports[_0xc3ff('0x2f')]=function(_0x28e6b7,_0x4b1c73){return db[_0xc3ff('0x33')]['find']({'where':{'id':_0x28e6b7['params']['id']}})[_0xc3ff('0x25')](handleEntityNotFound(_0x4b1c73,null))[_0xc3ff('0x25')](removeEntity(_0x4b1c73,null))[_0xc3ff('0x49')](handleError(_0x4b1c73,null));};exports['getHoppers']=function(_0x2aa20f,_0x402407,_0x4df462){var _0x5369f6={'raw':![],'where':{}};var _0x3eef75={};var _0x57df63={'count':0x0,'rows':[]};return db['VoiceQueue'][_0xc3ff('0x5e')]({'where':{'id':_0x2aa20f['params']['id']}})[_0xc3ff('0x25')](handleEntityNotFound(_0x402407,null))[_0xc3ff('0x25')](function(_0x2e7331){if(_0x2e7331){_0x3eef75['model']=_[_0xc3ff('0x36')](db['CmHopper'][_0xc3ff('0x34')]);_0x3eef75[_0xc3ff('0x35')]=_[_0xc3ff('0x36')](_0x2aa20f['query']);_0x3eef75[_0xc3ff('0x37')]=_[_0xc3ff('0x38')](_0x3eef75[_0xc3ff('0x39')],_0x3eef75['query']);_0x5369f6[_0xc3ff('0x3b')]=_[_0xc3ff('0x38')](_0x3eef75[_0xc3ff('0x39')],qs[_0xc3ff('0x3a')](_0x2aa20f[_0xc3ff('0x35')][_0xc3ff('0x3a')]));_0x5369f6[_0xc3ff('0x3b')]=_0x5369f6[_0xc3ff('0x3b')][_0xc3ff('0x3c')]?_0x5369f6[_0xc3ff('0x3b')]:_0x3eef75[_0xc3ff('0x39')];if(!_0x2aa20f[_0xc3ff('0x35')][_0xc3ff('0x3d')]('nolimit')){_0x5369f6[_0xc3ff('0x3e')]=qs[_0xc3ff('0x3e')](_0x2aa20f[_0xc3ff('0x35')]['limit']);_0x5369f6['offset']=qs['offset'](_0x2aa20f[_0xc3ff('0x35')][_0xc3ff('0x20')]);}_0x5369f6[_0xc3ff('0x3f')]=qs[_0xc3ff('0x40')](_0x2aa20f[_0xc3ff('0x35')][_0xc3ff('0x40')]);_0x5369f6[_0xc3ff('0x41')]=qs['filters'](_[_0xc3ff('0x5f')](_0x2aa20f['query'],_0x3eef75['filters']));_0x5369f6[_0xc3ff('0x41')]['VoiceQueueId']=_0x2e7331['id'];if(_0x2aa20f[_0xc3ff('0x35')][_0xc3ff('0x29')]){_0x5369f6[_0xc3ff('0x41')]=_[_0xc3ff('0x44')](_0x5369f6['where'],{'$or':_[_0xc3ff('0x2a')](_0x5369f6['attributes'],function(_0xb786db){var _0x4bbea8={};_0x4bbea8[_0xb786db]={'$like':'%'+_0x2aa20f['query'][_0xc3ff('0x29')]+'%'};return _0x4bbea8;})});}_0x5369f6=_[_0xc3ff('0x44')]({},_0x5369f6,_0x2aa20f['options']);return db[_0xc3ff('0x60')]['count']({'where':_0x5369f6[_0xc3ff('0x41')]})[_0xc3ff('0x25')](function(_0x431510){_0x57df63[_0xc3ff('0x45')]=_0x431510;if(_0x2aa20f[_0xc3ff('0x35')][_0xc3ff('0x46')]){_0x5369f6['include']=[{'all':!![]}];}return db[_0xc3ff('0x60')][_0xc3ff('0x47')](_0x5369f6);})[_0xc3ff('0x25')](function(_0x3abd2e){_0x57df63[_0xc3ff('0x48')]=_0x3abd2e;return _0x57df63;});}})[_0xc3ff('0x25')](respondWithFilteredResult(_0x402407,_0x5369f6))[_0xc3ff('0x49')](handleError(_0x402407,null));};exports[_0xc3ff('0x61')]=function(_0x294d7d,_0x588179,_0x54f66d){var _0x27bd7c={'raw':!![],'where':{}};var _0x15c61b={};var _0x61cec0={'count':0x0,'rows':[]};return db[_0xc3ff('0x33')][_0xc3ff('0x5e')]({'where':{'id':_0x294d7d['params']['id']}})[_0xc3ff('0x25')](handleEntityNotFound(_0x588179,null))[_0xc3ff('0x25')](function(_0x58db61){if(_0x58db61){_0x15c61b['model']=_[_0xc3ff('0x36')](db[_0xc3ff('0x62')][_0xc3ff('0x34')]);_0x15c61b[_0xc3ff('0x35')]=_[_0xc3ff('0x36')](_0x294d7d['query']);_0x15c61b[_0xc3ff('0x37')]=_[_0xc3ff('0x38')](_0x15c61b[_0xc3ff('0x39')],_0x15c61b[_0xc3ff('0x35')]);_0x27bd7c[_0xc3ff('0x3b')]=_[_0xc3ff('0x38')](_0x15c61b[_0xc3ff('0x39')],qs[_0xc3ff('0x3a')](_0x294d7d[_0xc3ff('0x35')][_0xc3ff('0x3a')]));_0x27bd7c['attributes']=_0x27bd7c[_0xc3ff('0x3b')][_0xc3ff('0x3c')]?_0x27bd7c[_0xc3ff('0x3b')]:_0x15c61b[_0xc3ff('0x39')];if(!_0x294d7d[_0xc3ff('0x35')][_0xc3ff('0x3d')](_0xc3ff('0x63'))){_0x27bd7c[_0xc3ff('0x3e')]=qs[_0xc3ff('0x3e')](_0x294d7d[_0xc3ff('0x35')][_0xc3ff('0x3e')]);_0x27bd7c[_0xc3ff('0x20')]=qs[_0xc3ff('0x20')](_0x294d7d[_0xc3ff('0x35')][_0xc3ff('0x20')]);}_0x27bd7c[_0xc3ff('0x3f')]=qs['sort'](_0x294d7d[_0xc3ff('0x35')][_0xc3ff('0x40')]);_0x27bd7c[_0xc3ff('0x41')]=qs[_0xc3ff('0x37')](_[_0xc3ff('0x5f')](_0x294d7d[_0xc3ff('0x35')],_0x15c61b[_0xc3ff('0x37')]));_0x27bd7c[_0xc3ff('0x41')]['VoiceQueueId']=_0x58db61['id'];if(_0x294d7d[_0xc3ff('0x35')][_0xc3ff('0x29')]){_0x27bd7c['where']=_[_0xc3ff('0x44')](_0x27bd7c['where'],{'$or':_[_0xc3ff('0x2a')](_0x27bd7c[_0xc3ff('0x3b')],function(_0x5e86a5){var _0x2a8506={};_0x2a8506[_0x5e86a5]={'$like':'%'+_0x294d7d['query'][_0xc3ff('0x29')]+'%'};return _0x2a8506;})});}_0x27bd7c=_[_0xc3ff('0x44')]({},_0x27bd7c,_0x294d7d[_0xc3ff('0x4b')]);return db[_0xc3ff('0x62')]['count']({'where':_0x27bd7c[_0xc3ff('0x41')]})['then'](function(_0x593dfd){_0x61cec0['count']=_0x593dfd;if(_0x294d7d[_0xc3ff('0x35')][_0xc3ff('0x46')]){_0x27bd7c[_0xc3ff('0x56')]=[{'all':!![]}];}return db['CmHopperHistory'][_0xc3ff('0x47')](_0x27bd7c);})[_0xc3ff('0x25')](function(_0x3c6984){_0x61cec0[_0xc3ff('0x48')]=_0x3c6984;return _0x61cec0;});}})[_0xc3ff('0x25')](respondWithFilteredResult(_0x588179,_0x27bd7c))[_0xc3ff('0x49')](handleError(_0x588179,null));};exports['getHopperFinals']=function(_0x31fe73,_0x64009e,_0x852cde){var _0x5de2b8={'raw':!![],'where':{}};var _0x33436f={};var _0x53666e={'count':0x0,'rows':[]};return db[_0xc3ff('0x33')]['findOne']({'where':{'id':_0x31fe73['params']['id']}})[_0xc3ff('0x25')](handleEntityNotFound(_0x64009e,null))['then'](function(_0x1d8522){if(_0x1d8522){_0x33436f[_0xc3ff('0x39')]=_[_0xc3ff('0x36')](db['CmHopperFinal'][_0xc3ff('0x34')]);_0x33436f[_0xc3ff('0x35')]=_[_0xc3ff('0x36')](_0x31fe73[_0xc3ff('0x35')]);_0x33436f[_0xc3ff('0x37')]=_[_0xc3ff('0x38')](_0x33436f[_0xc3ff('0x39')],_0x33436f['query']);_0x5de2b8[_0xc3ff('0x3b')]=_['intersection'](_0x33436f['model'],qs[_0xc3ff('0x3a')](_0x31fe73[_0xc3ff('0x35')][_0xc3ff('0x3a')]));_0x5de2b8['attributes']=_0x5de2b8[_0xc3ff('0x3b')]['length']?_0x5de2b8[_0xc3ff('0x3b')]:_0x33436f[_0xc3ff('0x39')];if(!_0x31fe73['query'][_0xc3ff('0x3d')]('nolimit')){_0x5de2b8[_0xc3ff('0x3e')]=qs['limit'](_0x31fe73[_0xc3ff('0x35')][_0xc3ff('0x3e')]);_0x5de2b8[_0xc3ff('0x20')]=qs[_0xc3ff('0x20')](_0x31fe73[_0xc3ff('0x35')][_0xc3ff('0x20')]);}_0x5de2b8[_0xc3ff('0x3f')]=qs['sort'](_0x31fe73[_0xc3ff('0x35')][_0xc3ff('0x40')]);_0x5de2b8[_0xc3ff('0x41')]=qs['filters'](_[_0xc3ff('0x5f')](_0x31fe73['query'],_0x33436f[_0xc3ff('0x37')]));_0x5de2b8[_0xc3ff('0x41')][_0xc3ff('0x64')]=_0x1d8522['id'];if(_0x31fe73[_0xc3ff('0x35')][_0xc3ff('0x29')]){_0x5de2b8[_0xc3ff('0x41')]=_[_0xc3ff('0x44')](_0x5de2b8[_0xc3ff('0x41')],{'$or':_[_0xc3ff('0x2a')](_0x5de2b8[_0xc3ff('0x3b')],function(_0x9b8a89){var _0x29b804={};_0x29b804[_0x9b8a89]={'$like':'%'+_0x31fe73[_0xc3ff('0x35')][_0xc3ff('0x29')]+'%'};return _0x29b804;})});}_0x5de2b8=_['merge']({},_0x5de2b8,_0x31fe73[_0xc3ff('0x4b')]);return db['CmHopperFinal'][_0xc3ff('0x45')]({'where':_0x5de2b8['where']})[_0xc3ff('0x25')](function(_0x1d69c8){_0x53666e[_0xc3ff('0x45')]=_0x1d69c8;if(_0x31fe73[_0xc3ff('0x35')][_0xc3ff('0x46')]){_0x5de2b8[_0xc3ff('0x56')]=[{'all':!![]}];}return db[_0xc3ff('0x65')][_0xc3ff('0x47')](_0x5de2b8);})[_0xc3ff('0x25')](function(_0x507907){_0x53666e[_0xc3ff('0x48')]=_0x507907;return _0x53666e;});}})['then'](respondWithFilteredResult(_0x64009e,_0x5de2b8))[_0xc3ff('0x49')](handleError(_0x64009e,null));};exports[_0xc3ff('0x66')]=function(_0x292c31,_0x580ae2,_0x1cdfd6){var _0x6f002f={'raw':!![],'where':{}};var _0x4ec289={};var _0x493713={'count':0x0,'rows':[]};return db[_0xc3ff('0x33')][_0xc3ff('0x5e')]({'where':{'id':_0x292c31['params']['id']}})['then'](handleEntityNotFound(_0x580ae2,null))['then'](function(_0x563bea){if(_0x563bea){_0x4ec289['model']=_[_0xc3ff('0x36')](db[_0xc3ff('0x67')][_0xc3ff('0x34')]);_0x4ec289[_0xc3ff('0x35')]=_['keys'](_0x292c31[_0xc3ff('0x35')]);_0x4ec289[_0xc3ff('0x37')]=_[_0xc3ff('0x38')](_0x4ec289[_0xc3ff('0x39')],_0x4ec289[_0xc3ff('0x35')]);_0x6f002f[_0xc3ff('0x3b')]=_[_0xc3ff('0x38')](_0x4ec289[_0xc3ff('0x39')],qs['fields'](_0x292c31['query']['fields']));_0x6f002f[_0xc3ff('0x3b')]=_0x6f002f[_0xc3ff('0x3b')][_0xc3ff('0x3c')]?_0x6f002f['attributes']:_0x4ec289[_0xc3ff('0x39')];if(!_0x292c31[_0xc3ff('0x35')][_0xc3ff('0x3d')](_0xc3ff('0x63'))){_0x6f002f[_0xc3ff('0x3e')]=qs[_0xc3ff('0x3e')](_0x292c31['query'][_0xc3ff('0x3e')]);_0x6f002f['offset']=qs[_0xc3ff('0x20')](_0x292c31['query'][_0xc3ff('0x20')]);}_0x6f002f['order']=qs[_0xc3ff('0x40')](_0x292c31['query'][_0xc3ff('0x40')]);_0x6f002f['where']=qs[_0xc3ff('0x37')](_[_0xc3ff('0x5f')](_0x292c31[_0xc3ff('0x35')],_0x4ec289[_0xc3ff('0x37')]));_0x6f002f['where'][_0xc3ff('0x64')]=_0x563bea['id'];if(_0x292c31[_0xc3ff('0x35')][_0xc3ff('0x29')]){_0x6f002f[_0xc3ff('0x41')]=_[_0xc3ff('0x44')](_0x6f002f[_0xc3ff('0x41')],{'$or':_[_0xc3ff('0x2a')](_0x6f002f['attributes'],function(_0x5161af){var _0x489892={};_0x489892[_0x5161af]={'$like':'%'+_0x292c31['query'][_0xc3ff('0x29')]+'%'};return _0x489892;})});}_0x6f002f=_[_0xc3ff('0x44')]({},_0x6f002f,_0x292c31[_0xc3ff('0x4b')]);return db['CmHopperBlack'][_0xc3ff('0x45')]({'where':_0x6f002f[_0xc3ff('0x41')]})[_0xc3ff('0x25')](function(_0x518236){_0x493713['count']=_0x518236;if(_0x292c31['query'][_0xc3ff('0x46')]){_0x6f002f[_0xc3ff('0x56')]=[{'all':!![]}];}return db[_0xc3ff('0x67')]['findAll'](_0x6f002f);})[_0xc3ff('0x25')](function(_0x45d714){_0x493713[_0xc3ff('0x48')]=_0x45d714;return _0x493713;});}})['then'](respondWithFilteredResult(_0x580ae2,_0x6f002f))['catch'](handleError(_0x580ae2,null));};exports[_0xc3ff('0x68')]=function(_0x28ad8e,_0x1f6fda,_0x181232){var _0x3f60ba={};var _0x2ae818={};var _0x4be8bc;var _0x52cfaf;return db['VoiceQueue'][_0xc3ff('0x5e')]({'where':{'id':_0x28ad8e[_0xc3ff('0x55')]['id']}})[_0xc3ff('0x25')](handleEntityNotFound(_0x1f6fda,null))[_0xc3ff('0x25')](function(_0x346f7b){if(_0x346f7b){_0x4be8bc=_0x346f7b;_0x2ae818['model']=_[_0xc3ff('0x36')](db[_0xc3ff('0x69')]['rawAttributes']);_0x2ae818[_0xc3ff('0x35')]=_[_0xc3ff('0x36')](_0x28ad8e['query']);_0x2ae818['filters']=_[_0xc3ff('0x38')](_0x2ae818[_0xc3ff('0x39')],_0x2ae818[_0xc3ff('0x35')]);_0x3f60ba[_0xc3ff('0x3b')]=_[_0xc3ff('0x38')](_0x2ae818[_0xc3ff('0x39')],qs[_0xc3ff('0x3a')](_0x28ad8e[_0xc3ff('0x35')][_0xc3ff('0x3a')]));_0x3f60ba[_0xc3ff('0x3b')]=_0x3f60ba[_0xc3ff('0x3b')]['length']?_0x3f60ba[_0xc3ff('0x3b')]:_0x2ae818[_0xc3ff('0x39')];_0x3f60ba[_0xc3ff('0x3f')]=qs[_0xc3ff('0x40')](_0x28ad8e[_0xc3ff('0x35')]['sort']);_0x3f60ba['where']=qs[_0xc3ff('0x37')](_[_0xc3ff('0x5f')](_0x28ad8e['query'],_0x2ae818['filters']));if(_0x28ad8e[_0xc3ff('0x35')][_0xc3ff('0x29')]){_0x3f60ba[_0xc3ff('0x41')]=_[_0xc3ff('0x44')](_0x3f60ba[_0xc3ff('0x41')],{'$or':_[_0xc3ff('0x2a')](_0x3f60ba[_0xc3ff('0x3b')],function(_0x5e75cb){var _0x16a22c={};_0x16a22c[_0x5e75cb]={'$like':'%'+_0x28ad8e['query']['filter']+'%'};return _0x16a22c;})});}_0x3f60ba=_[_0xc3ff('0x44')]({},_0x3f60ba,_0x28ad8e[_0xc3ff('0x4b')]);return _0x4be8bc[_0xc3ff('0x68')](_0x3f60ba);}})[_0xc3ff('0x25')](function(_0x5e41ec){if(_0x5e41ec){_0x52cfaf=_0x5e41ec[_0xc3ff('0x3c')];if(!_0x28ad8e[_0xc3ff('0x35')][_0xc3ff('0x3d')]('nolimit')){_0x3f60ba[_0xc3ff('0x3e')]=qs['limit'](_0x28ad8e[_0xc3ff('0x35')][_0xc3ff('0x3e')]);_0x3f60ba[_0xc3ff('0x20')]=qs['offset'](_0x28ad8e[_0xc3ff('0x35')]['offset']);}return _0x4be8bc[_0xc3ff('0x68')](_0x3f60ba);}})[_0xc3ff('0x25')](function(_0x4e31f4){if(_0x4e31f4){return _0x4e31f4?{'count':_0x52cfaf,'rows':_0x4e31f4}:null;}})[_0xc3ff('0x25')](respondWithResult(_0x1f6fda,null))[_0xc3ff('0x49')](handleError(_0x1f6fda,null));};exports[_0xc3ff('0x6a')]=function(_0x190092,_0xbd068c,_0x3dc4d5){var _0x334eaa=_0x190092[_0xc3ff('0x4d')]['teams'];return db['Team']['findAll']({'where':{'id':_[_0xc3ff('0x2a')](_0x334eaa,'id')},'attributes':['id'],'include':[{'model':db[_0xc3ff('0x6b')],'as':_0xc3ff('0x6c'),'attributes':['id',_0xc3ff('0x2e'),_0xc3ff('0x6d'),_0xc3ff('0x6e'),_0xc3ff('0x6f')],'raw':!![]}]})[_0xc3ff('0x25')](function(_0x563eba){if(_0x563eba){var _0x4d09da=_[_0xc3ff('0x70')](_0x563eba,function(_0x3dc2c4){var _0x5a85bf=_0x3dc2c4['get']({'plain':!![]});_0x5a85bf[_0xc3ff('0x6c')][_0xc3ff('0x71')](function(_0x21569e){_0x21569e[_0xc3ff('0x72')]=_['find'](_0x334eaa,{'id':_0x5a85bf['id']})[_0xc3ff('0x72')];});return _0x5a85bf[_0xc3ff('0x6c')];});return db[_0xc3ff('0x33')][_0xc3ff('0x2d')]({'where':{'id':_0x190092[_0xc3ff('0x55')]['id']}})[_0xc3ff('0x25')](function(_0x1757c1){return db[_0xc3ff('0x73')][_0xc3ff('0x74')](function(_0x58b167){return _0x1757c1[_0xc3ff('0x6a')](_['map'](_0x334eaa,'id'),{'transaction':_0x58b167})['then'](function(){return BPromise['each'](_0x4d09da,function(_0x1742b5){return db[_0xc3ff('0x75')][_0xc3ff('0x76')]({'where':{'UserId':_0x1742b5['id'],'VoiceQueueId':_0x190092[_0xc3ff('0x55')]['id']},'defaults':{'penalty':_0x1742b5['penalty']},'transaction':_0x58b167});});})[_0xc3ff('0x25')](function(){return BPromise[_0xc3ff('0x77')](_['filter'](_0x4d09da,{'online':!![]}),function(_0x53a0cc){return db['UserVoiceQueueRt'][_0xc3ff('0x78')]({'membername':_0x53a0cc[_0xc3ff('0x2e')],'UserId':_0x53a0cc['id'],'queue_name':_0x1757c1['name'],'VoiceQueueId':_0x1757c1['id'],'interface':_[_0xc3ff('0x79')](_0x53a0cc[_0xc3ff('0x6f')])?util['format'](_0xc3ff('0x7a'),_0x53a0cc[_0xc3ff('0x2e')]):_0x53a0cc[_0xc3ff('0x6f')],'paused':_0x53a0cc[_0xc3ff('0x6e')]||![],'penalty':_0x53a0cc[_0xc3ff('0x72')]},{'transaction':_0x58b167});});})[_0xc3ff('0x25')](function(){_0x4d09da['forEach'](function(_0x8282df){socket['emit']('userVoiceQueue:save',{'UserId':_0x8282df['id'],'VoiceQueueId':_0x1757c1['id']});});});});});}})[_0xc3ff('0x25')](respondWithStatusCode(_0xbd068c,null))[_0xc3ff('0x49')](handleError(_0xbd068c,null));};exports[_0xc3ff('0x7b')]=function(_0x4be1e2,_0x5121b9,_0x559598){return db[_0xc3ff('0x69')][_0xc3ff('0x47')]({'where':{'id':_0x4be1e2[_0xc3ff('0x35')][_0xc3ff('0x7c')]},'attributes':['id'],'include':[{'model':db['User'],'as':_0xc3ff('0x6c'),'attributes':['id'],'raw':!![]}]})[_0xc3ff('0x25')](handleEntityNotFound(_0x5121b9,null))['then'](function(_0x275e84){var _0x2da0b=_[_0xc3ff('0x2a')](_0x275e84,'id');var _0x546034=[];var _0x1f7c86=[];var _0x5e1f1b=squel[_0xc3ff('0x7d')]();_0x5e1f1b[_0xc3ff('0x7e')](_0xc3ff('0x7f'))['from'](_0xc3ff('0x80'),'tq')[_0xc3ff('0x81')](_0xc3ff('0x82'),'ut',_0xc3ff('0x83'))[_0xc3ff('0x41')](_0xc3ff('0x84'),_0x4be1e2[_0xc3ff('0x55')]['id']);for(var _0x5e8934=0x0;_0x5e8934<_0x275e84[_0xc3ff('0x3c')];_0x5e8934+=0x1){let _0x1aa40a=_0x275e84[_0x5e8934];for(var _0x3bd615=0x0;_0x3bd615<_0x1aa40a[_0xc3ff('0x6c')]['length'];_0x3bd615+=0x1){let _0x8e24=_0x1aa40a['Agents'][_0x3bd615];var _0x3a1841=_0x5e1f1b[_0xc3ff('0x54')]();_0x3a1841[_0xc3ff('0x41')]('ut.UserId\x20=\x20?',_0x8e24['id']);_0x1f7c86[_0xc3ff('0x85')](db[_0xc3ff('0x73')][_0xc3ff('0x35')](_0x3a1841['toString'](),{'type':db[_0xc3ff('0x73')][_0xc3ff('0x86')][_0xc3ff('0x87')]})[_0xc3ff('0x25')](function(_0x5420f5){if(_0x5420f5['length']===0x1){return _0x8e24['id'];}else{var _0x444954=_['every'](_[_0xc3ff('0x2a')](_0x5420f5,_0xc3ff('0x88')),function(_0x540e12){return _['includes'](_0x2da0b,_0x540e12);});if(_0x444954){return _0x8e24['id'];}}}));}}return BPromise['all'](_0x1f7c86)['then'](function(_0x59c10b){_0x546034=_(_0x546034)[_0xc3ff('0x89')](_0x59c10b)[_0xc3ff('0x8a')]()[_0xc3ff('0x2b')]();return db['VoiceQueue'][_0xc3ff('0x2d')]({'where':{'id':_0x4be1e2[_0xc3ff('0x55')]['id']}})['then'](function(_0x17ebf1){return db['sequelize'][_0xc3ff('0x74')](function(_0x206284){return _0x17ebf1[_0xc3ff('0x7b')](_0x4be1e2[_0xc3ff('0x35')][_0xc3ff('0x7c')],{'transaction':_0x206284})[_0xc3ff('0x25')](function(){if(!_['isEmpty'](_0x546034)){return _0x17ebf1[_0xc3ff('0x8b')](_0x546034,{'transaction':_0x206284})[_0xc3ff('0x25')](function(){return db[_0xc3ff('0x8c')][_0xc3ff('0x2f')]({'where':{'VoiceQueueId':_0x4be1e2[_0xc3ff('0x55')]['id'],'UserId':_0x546034},'transaction':_0x206284});});}})[_0xc3ff('0x25')](function(){_0x546034[_0xc3ff('0x71')](function(_0x3dc453){socket[_0xc3ff('0x8d')]('userVoiceQueue:remove',{'UserId':_0x3dc453,'VoiceQueueId':_0x17ebf1['id']});});});});});});})[_0xc3ff('0x25')](respondWithStatusCode(_0x5121b9,null))['catch'](handleError(_0x5121b9,null));};exports[_0xc3ff('0x8e')]=function(_0x407e76,_0x276fb8,_0x2310bc){var _0x95d45e,_0xa24a95;return db[_0xc3ff('0x33')]['find']({'where':{'id':_0x407e76[_0xc3ff('0x55')]['id']}})['then'](handleEntityNotFound(_0x276fb8,null))[_0xc3ff('0x25')](function(_0x5a0669){if(_0x5a0669){_0xa24a95=_0x5a0669;return _0x5a0669[_0xc3ff('0x8e')](_0x407e76[_0xc3ff('0x4d')][_0xc3ff('0x7c')],_[_0xc3ff('0x58')](_0x407e76['body'],['ids','id'])||{})[_0xc3ff('0x8f')](function(_0x489b44){for(var _0xfde556=0x0;_0xfde556<_0x407e76[_0xc3ff('0x4d')]['ids']['length'];_0xfde556+=0x1){socket[_0xc3ff('0x8d')](_0xc3ff('0x90'),{'UserId':_0x407e76[_0xc3ff('0x4d')]['ids'][_0xfde556],'VoiceQueueId':_0x407e76[_0xc3ff('0x55')]['id']});}return _0x489b44;});}})['then'](function(_0x547521){_0x95d45e=_0x547521||[];if(_0xa24a95){return db[_0xc3ff('0x6b')][_0xc3ff('0x47')]({'where':{'id':_0x407e76[_0xc3ff('0x4d')]['ids']},'attributes':['id','name',_0xc3ff('0x6d'),_0xc3ff('0x6e'),'interface'],'raw':!![]});}})[_0xc3ff('0x25')](function(_0x49b9cc){if(!_[_0xc3ff('0x91')](_0x49b9cc)){var _0x532293=[];for(var _0x54513a=0x0;_0x54513a<_0x49b9cc[_0xc3ff('0x3c')];_0x54513a++){if(_0x49b9cc[_0x54513a]['online']){_0x532293[_0xc3ff('0x85')](db[_0xc3ff('0x8c')][_0xc3ff('0x78')]({'membername':_0x49b9cc[_0x54513a][_0xc3ff('0x2e')],'UserId':_0x49b9cc[_0x54513a]['id'],'queue_name':_0xa24a95['name'],'VoiceQueueId':_0xa24a95['id'],'interface':_['isNil'](_0x49b9cc[_0x54513a][_0xc3ff('0x6f')])?util[_0xc3ff('0x92')](_0xc3ff('0x7a'),_0x49b9cc[_0x54513a][_0xc3ff('0x2e')]):_0x49b9cc[_0x54513a][_0xc3ff('0x6f')],'paused':_0x49b9cc[_0x54513a]['voicePause']||![],'penalty':_0x407e76[_0xc3ff('0x4d')]['penalty']||0x0}));}}return BPromise[_0xc3ff('0x93')](_0x532293);}})[_0xc3ff('0x25')](function(){return _0x95d45e;})[_0xc3ff('0x25')](respondWithResult(_0x276fb8,null))[_0xc3ff('0x49')](handleError(_0x276fb8,null));};exports[_0xc3ff('0x8b')]=function(_0x96e9f0,_0x42fa47,_0x317d50){return db[_0xc3ff('0x33')][_0xc3ff('0x2d')]({'where':{'id':_0x96e9f0['params']['id']}})[_0xc3ff('0x25')](handleEntityNotFound(_0x42fa47,null))['then'](function(_0x124b93){if(_0x124b93){return _0x124b93[_0xc3ff('0x8b')](_0x96e9f0[_0xc3ff('0x35')][_0xc3ff('0x7c')])[_0xc3ff('0x25')](function(){if(_[_0xc3ff('0x94')](_0x96e9f0[_0xc3ff('0x35')][_0xc3ff('0x7c')])){for(var _0x577cbd=0x0;_0x577cbd<_0x96e9f0['query'][_0xc3ff('0x7c')][_0xc3ff('0x3c')];_0x577cbd+=0x1){socket[_0xc3ff('0x8d')]('userVoiceQueue:remove',{'UserId':Number(_0x96e9f0[_0xc3ff('0x35')]['ids'][_0x577cbd]),'VoiceQueueId':Number(_0x96e9f0[_0xc3ff('0x55')]['id'])});}}else{socket[_0xc3ff('0x8d')](_0xc3ff('0x95'),{'UserId':Number(_0x96e9f0[_0xc3ff('0x35')][_0xc3ff('0x7c')]),'VoiceQueueId':Number(_0x96e9f0[_0xc3ff('0x55')]['id'])});}});}})[_0xc3ff('0x25')](function(_0x3653d5){return db[_0xc3ff('0x8c')]['destroy']({'where':{'VoiceQueueId':_0x96e9f0[_0xc3ff('0x55')]['id'],'UserId':_0x96e9f0[_0xc3ff('0x35')][_0xc3ff('0x7c')]}})[_0xc3ff('0x25')](function(){return _0x3653d5;});})[_0xc3ff('0x25')](respondWithStatusCode(_0x42fa47,null))['catch'](handleError(_0x42fa47,null));};exports[_0xc3ff('0x96')]=function(_0x151ea1,_0x4b1cf0,_0x3b940b){var _0x5b4075={};var _0x3eae51={};var _0x688d07;var _0x170fde;return db[_0xc3ff('0x33')][_0xc3ff('0x5e')]({'where':{'id':_0x151ea1['params']['id']}})[_0xc3ff('0x25')](handleEntityNotFound(_0x4b1cf0,null))[_0xc3ff('0x25')](function(_0x14cafa){if(_0x14cafa){_0x688d07=_0x14cafa;_0x3eae51[_0xc3ff('0x39')]=_[_0xc3ff('0x36')](db['User'][_0xc3ff('0x34')]);_0x3eae51[_0xc3ff('0x35')]=_[_0xc3ff('0x36')](_0x151ea1['query']);_0x3eae51[_0xc3ff('0x37')]=_[_0xc3ff('0x38')](_0x3eae51[_0xc3ff('0x39')],_0x3eae51[_0xc3ff('0x35')]);_0x5b4075['attributes']=_[_0xc3ff('0x38')](_0x3eae51[_0xc3ff('0x39')],qs[_0xc3ff('0x3a')](_0x151ea1[_0xc3ff('0x35')]['fields']));_0x5b4075[_0xc3ff('0x3b')]=_0x5b4075[_0xc3ff('0x3b')][_0xc3ff('0x3c')]?_0x5b4075[_0xc3ff('0x3b')]:_0x3eae51[_0xc3ff('0x39')];_0x5b4075['order']=qs[_0xc3ff('0x40')](_0x151ea1[_0xc3ff('0x35')][_0xc3ff('0x40')]);_0x5b4075[_0xc3ff('0x41')]=qs[_0xc3ff('0x37')](_[_0xc3ff('0x5f')](_0x151ea1[_0xc3ff('0x35')],_0x3eae51[_0xc3ff('0x37')]));if(_0x151ea1[_0xc3ff('0x35')]['filter']){_0x5b4075[_0xc3ff('0x41')]=_['merge'](_0x5b4075[_0xc3ff('0x41')],{'$or':_[_0xc3ff('0x2a')](_0x5b4075[_0xc3ff('0x3b')],function(_0x38c1b2){var _0x1693a3={};_0x1693a3[_0x38c1b2]={'$like':'%'+_0x151ea1[_0xc3ff('0x35')]['filter']+'%'};return _0x1693a3;})});}_0x5b4075=_[_0xc3ff('0x44')]({},_0x5b4075,_0x151ea1[_0xc3ff('0x4b')]);return _0x688d07[_0xc3ff('0x96')](_0x5b4075);}})[_0xc3ff('0x25')](function(_0x5ac2e5){if(_0x5ac2e5){_0x170fde=_0x5ac2e5[_0xc3ff('0x3c')];if(!_0x151ea1['query'][_0xc3ff('0x3d')]('nolimit')){_0x5b4075[_0xc3ff('0x3e')]=qs[_0xc3ff('0x3e')](_0x151ea1['query'][_0xc3ff('0x3e')]);_0x5b4075[_0xc3ff('0x20')]=qs[_0xc3ff('0x20')](_0x151ea1['query'][_0xc3ff('0x20')]);}return _0x688d07['getAgents'](_0x5b4075);}})[_0xc3ff('0x25')](function(_0x3b9538){if(_0x3b9538){return _0x3b9538?{'count':_0x170fde,'rows':_0x3b9538}:null;}})[_0xc3ff('0x25')](respondWithResult(_0x4b1cf0,null))[_0xc3ff('0x49')](handleError(_0x4b1cf0,null));};exports[_0xc3ff('0x97')]=function(_0x2aa6eb,_0x398af0,_0x225e52){var _0x526efa={};var _0x550973={};var _0xda523d;var _0xfb695a;return db[_0xc3ff('0x33')]['findOne']({'where':{'id':_0x2aa6eb[_0xc3ff('0x55')]['id']}})['then'](handleEntityNotFound(_0x398af0,null))[_0xc3ff('0x25')](function(_0x44da45){if(_0x44da45){_0xda523d=_0x44da45;_0x550973[_0xc3ff('0x39')]=_[_0xc3ff('0x36')](db[_0xc3ff('0x8c')]['rawAttributes']);_0x550973[_0xc3ff('0x35')]=_[_0xc3ff('0x36')](_0x2aa6eb[_0xc3ff('0x35')]);_0x550973[_0xc3ff('0x37')]=_[_0xc3ff('0x38')](_0x550973['model'],_0x550973['query']);_0x526efa[_0xc3ff('0x3b')]=_[_0xc3ff('0x38')](_0x550973['model'],qs[_0xc3ff('0x3a')](_0x2aa6eb[_0xc3ff('0x35')][_0xc3ff('0x3a')]));_0x526efa['attributes']=_0x526efa[_0xc3ff('0x3b')][_0xc3ff('0x3c')]?_0x526efa[_0xc3ff('0x3b')]:_0x550973[_0xc3ff('0x39')];_0x526efa[_0xc3ff('0x3f')]=qs[_0xc3ff('0x40')](_0x2aa6eb['query'][_0xc3ff('0x40')]);_0x526efa['where']=qs['filters'](_[_0xc3ff('0x5f')](_0x2aa6eb[_0xc3ff('0x35')],_0x550973[_0xc3ff('0x37')]));if(_0x2aa6eb[_0xc3ff('0x35')][_0xc3ff('0x29')]){_0x526efa[_0xc3ff('0x41')]=_[_0xc3ff('0x44')](_0x526efa[_0xc3ff('0x41')],{'$or':_[_0xc3ff('0x2a')](_0x526efa[_0xc3ff('0x3b')],function(_0x38d6ca){var _0x1df8c8={};_0x1df8c8[_0x38d6ca]={'$like':'%'+_0x2aa6eb['query'][_0xc3ff('0x29')]+'%'};return _0x1df8c8;})});}_0x526efa=_['merge']({},_0x526efa,_0x2aa6eb[_0xc3ff('0x4b')]);return _0xda523d[_0xc3ff('0x97')](_0x526efa);}})['then'](function(_0x4006e7){if(_0x4006e7){_0xfb695a=_0x4006e7[_0xc3ff('0x3c')];if(!_0x2aa6eb['query']['hasOwnProperty'](_0xc3ff('0x63'))){_0x526efa[_0xc3ff('0x3e')]=qs[_0xc3ff('0x3e')](_0x2aa6eb[_0xc3ff('0x35')][_0xc3ff('0x3e')]);_0x526efa['offset']=qs[_0xc3ff('0x20')](_0x2aa6eb['query'][_0xc3ff('0x20')]);}return _0xda523d[_0xc3ff('0x97')](_0x526efa);}})[_0xc3ff('0x25')](function(_0x44dc1d){return _0x44dc1d?{'count':_0xfb695a,'rows':_0x44dc1d}:null;})[_0xc3ff('0x25')](respondWithResult(_0x398af0,null))[_0xc3ff('0x49')](handleError(_0x398af0,null));};exports[_0xc3ff('0x98')]=function(_0x14cd86,_0x51f18b,_0x317aaa){var _0x1edd8b={};var _0x52ba11={};var _0x52bfa3;var _0x27298a;return db[_0xc3ff('0x33')]['findOne']({'where':{'id':_0x14cd86[_0xc3ff('0x55')]['id']}})[_0xc3ff('0x25')](handleEntityNotFound(_0x51f18b,null))[_0xc3ff('0x25')](function(_0xbe4f9d){if(_0xbe4f9d){_0x52bfa3=_0xbe4f9d;_0x52ba11[_0xc3ff('0x39')]=_[_0xc3ff('0x36')](db[_0xc3ff('0x99')][_0xc3ff('0x34')]);_0x52ba11[_0xc3ff('0x35')]=_['keys'](_0x14cd86[_0xc3ff('0x35')]);_0x52ba11[_0xc3ff('0x37')]=_[_0xc3ff('0x38')](_0x52ba11[_0xc3ff('0x39')],_0x52ba11[_0xc3ff('0x35')]);_0x1edd8b[_0xc3ff('0x3b')]=_[_0xc3ff('0x38')](_0x52ba11[_0xc3ff('0x39')],qs[_0xc3ff('0x3a')](_0x14cd86[_0xc3ff('0x35')]['fields']));_0x1edd8b['attributes']=_0x1edd8b[_0xc3ff('0x3b')][_0xc3ff('0x3c')]?_0x1edd8b[_0xc3ff('0x3b')]:_0x52ba11[_0xc3ff('0x39')];_0x1edd8b['order']=qs[_0xc3ff('0x40')](_0x14cd86[_0xc3ff('0x35')][_0xc3ff('0x40')]);_0x1edd8b[_0xc3ff('0x41')]=qs['filters'](_['pick'](_0x14cd86['query'],_0x52ba11['filters']));if(_0x14cd86['query'][_0xc3ff('0x29')]){_0x1edd8b[_0xc3ff('0x41')]=_['merge'](_0x1edd8b[_0xc3ff('0x41')],{'$or':_[_0xc3ff('0x2a')](_0x1edd8b[_0xc3ff('0x3b')],function(_0x42b376){var _0x22761b={};_0x22761b[_0x42b376]={'$like':'%'+_0x14cd86[_0xc3ff('0x35')][_0xc3ff('0x29')]+'%'};return _0x22761b;})});}_0x1edd8b=_[_0xc3ff('0x44')]({},_0x1edd8b,_0x14cd86['options']);return _0x52bfa3[_0xc3ff('0x98')](_0x1edd8b);}})['then'](function(_0x5b4345){if(_0x5b4345){_0x27298a=_0x5b4345[_0xc3ff('0x3c')];if(!_0x14cd86[_0xc3ff('0x35')]['hasOwnProperty'](_0xc3ff('0x63'))){_0x1edd8b['limit']=qs['limit'](_0x14cd86[_0xc3ff('0x35')][_0xc3ff('0x3e')]);_0x1edd8b[_0xc3ff('0x20')]=qs[_0xc3ff('0x20')](_0x14cd86[_0xc3ff('0x35')][_0xc3ff('0x20')]);}return _0x52bfa3[_0xc3ff('0x98')](_0x1edd8b);}})[_0xc3ff('0x25')](function(_0x4b2bad){if(_0x4b2bad){return _0x4b2bad?{'count':_0x27298a,'rows':_0x4b2bad}:null;}})['then'](respondWithResult(_0x51f18b,null))[_0xc3ff('0x49')](handleError(_0x51f18b,null));};exports[_0xc3ff('0x9a')]=function(_0x4bf2d0,_0x21415d,_0x26adfc){var _0x2af9d1,_0x247366;return db[_0xc3ff('0x33')][_0xc3ff('0x2d')]({'where':{'id':_0x4bf2d0['params']['id']}})[_0xc3ff('0x25')](handleEntityNotFound(_0x21415d,null))['then'](function(_0x37e63d){if(_0x37e63d){_0x247366=_0x37e63d;return _0x37e63d['addLists'](_0x4bf2d0['body']['ids'],_[_0xc3ff('0x58')](_0x4bf2d0['body'],['ids','id'])||{});}return null;})[_0xc3ff('0x8f')](function(_0x3e0eae){var _0x5b2a84;_0x2af9d1=_0x3e0eae||[];var _0x4f85d0=[];if(_0x3e0eae){for(var _0x58d324=0x0;_0x58d324<_0x3e0eae['length'];_0x58d324+=0x1){var _0x659ae=_0x3e0eae[_0x58d324][_0xc3ff('0x57')]({'plain':!![]});_0x247366[_0xc3ff('0x9b')]=_0x4bf2d0[_0xc3ff('0x4d')][_0xc3ff('0x9b')]?_0x4bf2d0[_0xc3ff('0x4d')][_0xc3ff('0x9b')]:_0x247366[_0xc3ff('0x9b')];switch(_0x247366[_0xc3ff('0x9b')]){case _0xc3ff('0x9c'):_0x5b2a84=squel[_0xc3ff('0x9d')]()['into'](_0xc3ff('0x9e'))[_0xc3ff('0x9f')]([_0xc3ff('0xa0'),_0xc3ff('0xa1'),_0xc3ff('0xa2'),'ListId',_0xc3ff('0x64'),_0xc3ff('0x59'),_0xc3ff('0x5a')],squel[_0xc3ff('0x7d')]()[_0xc3ff('0x7e')](_0xc3ff('0xa0'),_0xc3ff('0xa0'))[_0xc3ff('0x7e')](_0xc3ff('0xa3'),_0xc3ff('0xa1'))[_0xc3ff('0x7e')]('id',_0xc3ff('0xa2'))[_0xc3ff('0x7e')](_0x659ae['CmListId']['toString'](),'ListId')[_0xc3ff('0x7e')](_0x4bf2d0[_0xc3ff('0x55')]['id'][_0xc3ff('0xa4')](),_0xc3ff('0x64'))['field'](_0xc3ff('0xa3'),_0xc3ff('0x59'))[_0xc3ff('0x7e')](_0xc3ff('0xa3'),_0xc3ff('0x5a'))[_0xc3ff('0xa5')](_0xc3ff('0xa6'))['where']('deletedAt\x20IS\x20NULL')['where'](_0xc3ff('0xa7'),_0x659ae['CmListId'][_0xc3ff('0xa4')]())[_0xc3ff('0x41')](_0xc3ff('0xa8'))[_0xc3ff('0x41')](_0xc3ff('0xa9'),squel[_0xc3ff('0x7d')]()[_0xc3ff('0x7e')](_0xc3ff('0xaa'))[_0xc3ff('0xa5')](_0xc3ff('0xab'))[_0xc3ff('0x41')]('VoiceQueueId\x20=\x20?',_0x4bf2d0['params']['id']['toString']()))[_0xc3ff('0x41')](_0xc3ff('0xa9'),squel[_0xc3ff('0x7d')]()[_0xc3ff('0x7e')](_0xc3ff('0xac'))[_0xc3ff('0xa5')](_0xc3ff('0x9e'))[_0xc3ff('0x41')]('VoiceQueueId\x20=\x20?',_0x4bf2d0['params']['id'][_0xc3ff('0xa4')]())))[_0xc3ff('0xa4')]();break;case _0xc3ff('0xad'):_0x5b2a84=squel[_0xc3ff('0x9d')]()[_0xc3ff('0xae')](_0xc3ff('0x9e'))[_0xc3ff('0x9f')]([_0xc3ff('0xa0'),_0xc3ff('0xa1'),'ContactId',_0xc3ff('0xaf'),_0xc3ff('0x64'),_0xc3ff('0x59'),_0xc3ff('0x5a')],squel[_0xc3ff('0x7d')]()[_0xc3ff('0x7e')](_0xc3ff('0xa0'),'phone')['field']('NOW()',_0xc3ff('0xa1'))[_0xc3ff('0x7e')]('id',_0xc3ff('0xa2'))[_0xc3ff('0x7e')](_0x659ae[_0xc3ff('0xb0')][_0xc3ff('0xa4')](),_0xc3ff('0xaf'))['field'](_0x4bf2d0['params']['id'][_0xc3ff('0xa4')](),_0xc3ff('0x64'))['field'](_0xc3ff('0xa3'),_0xc3ff('0x59'))[_0xc3ff('0x7e')]('NOW()',_0xc3ff('0x5a'))['from'](_0xc3ff('0xa6'))[_0xc3ff('0x41')]('deletedAt\x20IS\x20NULL')[_0xc3ff('0x41')]('ListId\x20=\x20?',_0x659ae['CmListId'][_0xc3ff('0xa4')]())['where'](_0xc3ff('0xa8'))['where'](_0xc3ff('0xa9'),squel[_0xc3ff('0x7d')]()[_0xc3ff('0x7e')](_0xc3ff('0xac'))[_0xc3ff('0xa5')]('cm_hopper')['where'](_0xc3ff('0x84'),_0x4bf2d0[_0xc3ff('0x55')]['id']['toString']())))['toString']();break;default:_0x5b2a84=squel[_0xc3ff('0x9d')]()[_0xc3ff('0xae')](_0xc3ff('0x9e'))[_0xc3ff('0x9f')](['phone',_0xc3ff('0xa1'),'ContactId',_0xc3ff('0xaf'),_0xc3ff('0x64'),'createdAt',_0xc3ff('0x5a')],squel[_0xc3ff('0x7d')]()[_0xc3ff('0x7e')](_0xc3ff('0xa0'),_0xc3ff('0xa0'))['field'](_0xc3ff('0xa3'),_0xc3ff('0xa1'))[_0xc3ff('0x7e')]('id',_0xc3ff('0xa2'))[_0xc3ff('0x7e')](_0x659ae[_0xc3ff('0xb0')]['toString'](),_0xc3ff('0xaf'))[_0xc3ff('0x7e')](_0x4bf2d0['params']['id'][_0xc3ff('0xa4')](),_0xc3ff('0x64'))[_0xc3ff('0x7e')](_0xc3ff('0xa3'),_0xc3ff('0x59'))[_0xc3ff('0x7e')](_0xc3ff('0xa3'),_0xc3ff('0x5a'))[_0xc3ff('0xa5')](_0xc3ff('0xa6'))['where'](_0xc3ff('0xb1'))[_0xc3ff('0x41')](_0xc3ff('0xa7'),_0x659ae[_0xc3ff('0xb0')]['toString']())[_0xc3ff('0x41')]('phone\x20IS\x20NOT\x20NULL'))[_0xc3ff('0xa4')]();}_0x4f85d0[_0xc3ff('0x85')](db[_0xc3ff('0x73')][_0xc3ff('0x35')](_0x5b2a84));}return BPromise[_0xc3ff('0x93')](_0x4f85d0);}})[_0xc3ff('0x25')](function(){return _0x2af9d1;})[_0xc3ff('0x25')](respondWithResult(_0x21415d,null))[_0xc3ff('0x49')](handleError(_0x21415d,null));};exports['removeLists']=function(_0x31e18c,_0x20281b,_0x34b10e){return db[_0xc3ff('0x33')][_0xc3ff('0x2d')]({'where':{'id':_0x31e18c[_0xc3ff('0x55')]['id']}})['then'](handleEntityNotFound(_0x20281b,null))['then'](function(_0x1f9975){if(_0x1f9975){return _0x1f9975[_0xc3ff('0xb2')](_0x31e18c[_0xc3ff('0x35')][_0xc3ff('0x7c')]);}})[_0xc3ff('0x25')](function(_0x4ba0f5){if(_0x4ba0f5){return db['CmHopper'][_0xc3ff('0x2f')]({'where':{'ListId':_0x31e18c[_0xc3ff('0x35')]['ids'],'VoiceQueueId':_0x31e18c[_0xc3ff('0x55')]['id']}})[_0xc3ff('0x25')](function(){return _0x4ba0f5;});}})[_0xc3ff('0x25')](respondWithStatusCode(_0x20281b,null))[_0xc3ff('0x49')](handleError(_0x20281b,null));};exports[_0xc3ff('0xb3')]=function(_0x5de5db,_0x14528f,_0x3a8a2c){var _0x1f14d2={};var _0x800a52={};var _0x12d842;var _0x2014c5;return db[_0xc3ff('0x33')][_0xc3ff('0x5e')]({'where':{'id':_0x5de5db[_0xc3ff('0x55')]['id']}})['then'](handleEntityNotFound(_0x14528f,null))[_0xc3ff('0x25')](function(_0x50ea74){if(_0x50ea74){_0x12d842=_0x50ea74;_0x800a52[_0xc3ff('0x39')]=_[_0xc3ff('0x36')](db[_0xc3ff('0x99')][_0xc3ff('0x34')]);_0x800a52['query']=_[_0xc3ff('0x36')](_0x5de5db[_0xc3ff('0x35')]);_0x800a52[_0xc3ff('0x37')]=_[_0xc3ff('0x38')](_0x800a52[_0xc3ff('0x39')],_0x800a52[_0xc3ff('0x35')]);_0x1f14d2[_0xc3ff('0x3b')]=_[_0xc3ff('0x38')](_0x800a52[_0xc3ff('0x39')],qs[_0xc3ff('0x3a')](_0x5de5db[_0xc3ff('0x35')][_0xc3ff('0x3a')]));_0x1f14d2[_0xc3ff('0x3b')]=_0x1f14d2[_0xc3ff('0x3b')][_0xc3ff('0x3c')]?_0x1f14d2['attributes']:_0x800a52[_0xc3ff('0x39')];_0x1f14d2[_0xc3ff('0x3f')]=qs[_0xc3ff('0x40')](_0x5de5db[_0xc3ff('0x35')][_0xc3ff('0x40')]);_0x1f14d2[_0xc3ff('0x41')]=qs[_0xc3ff('0x37')](_['pick'](_0x5de5db[_0xc3ff('0x35')],_0x800a52[_0xc3ff('0x37')]));if(_0x5de5db['query'][_0xc3ff('0x29')]){_0x1f14d2[_0xc3ff('0x41')]=_[_0xc3ff('0x44')](_0x1f14d2[_0xc3ff('0x41')],{'$or':_[_0xc3ff('0x2a')](_0x1f14d2[_0xc3ff('0x3b')],function(_0x337705){var _0xdffed3={};_0xdffed3[_0x337705]={'$like':'%'+_0x5de5db[_0xc3ff('0x35')][_0xc3ff('0x29')]+'%'};return _0xdffed3;})});}_0x1f14d2=_[_0xc3ff('0x44')]({},_0x1f14d2,_0x5de5db['options']);return _0x12d842[_0xc3ff('0xb3')](_0x1f14d2);}})['then'](function(_0x35fc97){if(_0x35fc97){_0x2014c5=_0x35fc97['length'];if(!_0x5de5db[_0xc3ff('0x35')]['hasOwnProperty'](_0xc3ff('0x63'))){_0x1f14d2[_0xc3ff('0x3e')]=qs[_0xc3ff('0x3e')](_0x5de5db['query'][_0xc3ff('0x3e')]);_0x1f14d2[_0xc3ff('0x20')]=qs[_0xc3ff('0x20')](_0x5de5db['query'][_0xc3ff('0x20')]);}return _0x12d842['getBlackLists'](_0x1f14d2);}})[_0xc3ff('0x25')](function(_0x5a6faf){if(_0x5a6faf){return _0x5a6faf?{'count':_0x2014c5,'rows':_0x5a6faf}:null;}})[_0xc3ff('0x25')](respondWithResult(_0x14528f,null))[_0xc3ff('0x49')](handleError(_0x14528f,null));};exports[_0xc3ff('0xb4')]=function(_0x4575d0,_0x1d20b2,_0x331ed8){var _0x263ea5,_0x297181;return db[_0xc3ff('0x33')][_0xc3ff('0x2d')]({'where':{'id':_0x4575d0['params']['id']}})[_0xc3ff('0x25')](handleEntityNotFound(_0x1d20b2,null))[_0xc3ff('0x25')](function(_0x539747){if(_0x539747){_0x297181=_0x539747;return _0x539747[_0xc3ff('0xb4')](_0x4575d0[_0xc3ff('0x4d')][_0xc3ff('0x7c')],_[_0xc3ff('0x58')](_0x4575d0[_0xc3ff('0x4d')],['ids','id'])||{});}return null;})[_0xc3ff('0x8f')](function(_0x3a357e){var _0x3f0cb6;_0x263ea5=_0x3a357e||[];var _0x3e34f7=[];if(_0x3a357e){for(var _0x5057b8=0x0;_0x5057b8<_0x3a357e['length'];_0x5057b8+=0x1){var _0xa6ac67=_0x3a357e[_0x5057b8]['get']({'plain':!![]});_0x3f0cb6=squel['insert']()[_0xc3ff('0xae')](_0xc3ff('0xb5'))[_0xc3ff('0x9f')](['phone','ContactId',_0xc3ff('0xaf'),_0xc3ff('0x64'),_0xc3ff('0x59'),_0xc3ff('0x5a')],squel['select']()[_0xc3ff('0x7e')](_0xc3ff('0xa0'),'phone')[_0xc3ff('0x7e')]('id',_0xc3ff('0xa2'))[_0xc3ff('0x7e')](_0xa6ac67['CmListId'][_0xc3ff('0xa4')](),'ListId')[_0xc3ff('0x7e')](_0x4575d0[_0xc3ff('0x55')]['id'][_0xc3ff('0xa4')](),_0xc3ff('0x64'))[_0xc3ff('0x7e')]('NOW()',_0xc3ff('0x59'))[_0xc3ff('0x7e')](_0xc3ff('0xa3'),_0xc3ff('0x5a'))[_0xc3ff('0xa5')]('cm_contacts')[_0xc3ff('0x41')]('deletedAt\x20IS\x20NULL')[_0xc3ff('0x41')](_0xc3ff('0xa7'),_0xa6ac67[_0xc3ff('0xb0')][_0xc3ff('0xa4')]())['where'](_0xc3ff('0xa8')))['toString']();_0x3e34f7[_0xc3ff('0x85')](db[_0xc3ff('0x73')][_0xc3ff('0x35')](_0x3f0cb6));}return BPromise[_0xc3ff('0x93')](_0x3e34f7);}})['then'](function(){return _0x263ea5;})[_0xc3ff('0x25')](respondWithResult(_0x1d20b2,null))['catch'](handleError(_0x1d20b2,null));};exports[_0xc3ff('0xb6')]=function(_0x4ce1f6,_0x2ff3e3,_0x4e141d){return db[_0xc3ff('0x33')][_0xc3ff('0x2d')]({'where':{'id':_0x4ce1f6[_0xc3ff('0x55')]['id']}})['then'](handleEntityNotFound(_0x2ff3e3,null))[_0xc3ff('0x25')](function(_0x52e82a){if(_0x52e82a){return _0x52e82a[_0xc3ff('0xb6')](_0x4ce1f6['query'][_0xc3ff('0x7c')]);}})['then'](function(_0x38651b){if(_0x38651b){return db[_0xc3ff('0x67')][_0xc3ff('0x2f')]({'where':{'ListId':_0x4ce1f6[_0xc3ff('0x35')][_0xc3ff('0x7c')],'VoiceQueueId':_0x4ce1f6['params']['id']}})[_0xc3ff('0x25')](function(){return _0x38651b;});}})['then'](respondWithStatusCode(_0x2ff3e3,null))[_0xc3ff('0x49')](handleError(_0x2ff3e3,null));};