8a7713cd30f19e6a6898cf4b10d9b8a572f289b8
[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 _0xedd9=['penalty','UserVoiceQueueRt','interface','format','SIP/%s','voicePause','emit','userVoiceQueue:save','User','select','field','tq.TeamId','team_has_voice_queues','join','user_has_teams','ut.TeamId\x20=\x20tq.TeamId','VoiceQueueId\x20=\x20?','ut.UserId\x20=\x20?','push','toString','QueryTypes','SELECT','every','TeamId','union','compact','removeTeams','ids','removeAgents','userVoiceQueue:remove','addAgents','spread','isEmpty','upsert','isNil','all','isArray','getAgents','getMembers','CmList','getLists','dialCheckDuplicateType','always','insert','into','cm_hopper','phone','scheduledAt','ContactId','ListId','NOW()','from','ListId\x20=\x20?','CmListId','phone\x20IS\x20NOT\x20NULL','COALESCE(calleridnum,\x27\x27)','cm_hopper_final','phone\x20NOT\x20IN\x20(?)','COALESCE(phone,\x27\x27)','onlyIfOpen','fromQuery','cm_contacts','deletedAt\x20IS\x20NULL','removeLists','getBlackLists','addBlackLists','cm_hopper_black','removeBlackLists','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','path','sox','to-csv','ejs','squel','jsforce','desk.js','querystring','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./voiceQueue.socket','register','sendStatus','status','end','count','limit','set','reject','save','update','then','destroy','get','inbound','QueueCampaigns','outbound','filter','value','includes','find','type','UserProfileResource','error','stack','name','send','map','VoiceQueue','rawAttributes','fieldName','key','model','keys','query','filters','intersection','attributes','fields','length','nolimit','offset','sort','where','pick','merge','options','includeAll','include','findAll','rows','catch','show','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','VoiceQueues','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','params','createdAt','updatedAt','omit','UserProfileSection','getHoppers','hasOwnProperty','order','CmHopper','CmHopperHistory','VoiceQueueId','findOne','CmHopperFinal','CmHopperBlack','getTeams','Team','addTeams','teams','Agents','online','flatMap','forEach','sequelize','each','UserVoiceQueue','findOrCreate'];(function(_0x47adb8,_0x591ccc){var _0x4689a8=function(_0x2ba76f){while(--_0x2ba76f){_0x47adb8['push'](_0x47adb8['shift']());}};_0x4689a8(++_0x591ccc);}(_0xedd9,0xfc));var _0x9edd=function(_0x208f90,_0x54451e){_0x208f90=_0x208f90-0x0;var _0x2fc0cb=_0xedd9[_0x208f90];return _0x2fc0cb;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x9edd('0x0'));var rimraf=require(_0x9edd('0x1'));var zipdir=require(_0x9edd('0x2'));var jsonpatch=require(_0x9edd('0x3'));var rp=require(_0x9edd('0x4'));var moment=require(_0x9edd('0x5'));var BPromise=require(_0x9edd('0x6'));var Mustache=require(_0x9edd('0x7'));var util=require('util');var path=require(_0x9edd('0x8'));var sox=require(_0x9edd('0x9'));var csv=require(_0x9edd('0xa'));var ejs=require(_0x9edd('0xb'));var fs=require('fs');var _=require('lodash');var squel=require(_0x9edd('0xc'));var crypto=require('crypto');var jsforce=require(_0x9edd('0xd'));var deskjs=require(_0x9edd('0xe'));var toCsv=require(_0x9edd('0xa'));var querystring=require(_0x9edd('0xf'));var Papa=require('papaparse');var Redis=require(_0x9edd('0x10'));var authService=require('../../components/auth/service');var qs=require(_0x9edd('0x11'));var as=require(_0x9edd('0x12'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x9edd('0x13'))(_0x9edd('0x14'));var utils=require('../../config/utils');var config=require(_0x9edd('0x15'));var licenseUtil=require(_0x9edd('0x16'));var db=require(_0x9edd('0x17'))['db'];config[_0x9edd('0x18')]=_[_0x9edd('0x19')](config[_0x9edd('0x18')],{'host':_0x9edd('0x1a'),'port':0x18eb});var socket=require(_0x9edd('0x1b'))(new Redis(config['redis']));require(_0x9edd('0x1c'))[_0x9edd('0x1d')](socket);function respondWithStatusCode(_0x891832,_0x4d9a7){_0x4d9a7=_0x4d9a7||0xcc;return function(_0x13b6b6){if(_0x13b6b6){return _0x891832[_0x9edd('0x1e')](_0x4d9a7);}return _0x891832[_0x9edd('0x1f')](_0x4d9a7)[_0x9edd('0x20')]();};}function respondWithResult(_0x4ea60f,_0x5f5bf4){_0x5f5bf4=_0x5f5bf4||0xc8;return function(_0x448996){if(_0x448996){return _0x4ea60f[_0x9edd('0x1f')](_0x5f5bf4)['json'](_0x448996);}};}function respondWithFilteredResult(_0x1b54c0,_0x35f454){return function(_0x40ba32){if(_0x40ba32){var _0x4d8f33=_0x40ba32[_0x9edd('0x21')],_0x43dc70=_0x35f454['offset'],_0x5d879c=_0x35f454['offset']+_0x35f454[_0x9edd('0x22')],_0x2cdcef;if(_0x5d879c>=_0x4d8f33){_0x5d879c=_0x4d8f33;_0x2cdcef=0xc8;}else{_0x2cdcef=0xce;}_0x1b54c0['status'](_0x2cdcef);return _0x1b54c0[_0x9edd('0x23')]('Content-Range',_0x43dc70+'-'+_0x5d879c+'/'+_0x4d8f33)['json'](_0x40ba32);}return null;};}function patchUpdates(_0x356751){return function(_0x1c46a8){try{jsonpatch['apply'](_0x1c46a8,_0x356751,!![]);}catch(_0x5823bc){return BPromise[_0x9edd('0x24')](_0x5823bc);}return _0x1c46a8[_0x9edd('0x25')]();};}function saveUpdates(_0x477878,_0x542172){return function(_0x3741c8){if(_0x3741c8){return _0x3741c8[_0x9edd('0x26')](_0x477878)[_0x9edd('0x27')](function(_0x2ca65f){return _0x2ca65f;});}return null;};}function removeEntity(_0x339a0d,_0x4c75d2){return function(_0x46c383){if(_0x46c383){return _0x46c383[_0x9edd('0x28')]()[_0x9edd('0x27')](function(){var _0x2f9f86=_0x46c383[_0x9edd('0x29')]({'plain':!![]});var _0x4d507f=[{'name':'VoiceQueues','value':_0x9edd('0x2a'),'ignore':![]},{'name':_0x9edd('0x2b'),'value':_0x9edd('0x2c'),'ignore':![]}];var _0x25e135=_(_0x4d507f)[_0x9edd('0x2d')]('ignore')['map'](_0x9edd('0x2e'))[_0x9edd('0x2e')]();if(_[_0x9edd('0x2f')](_0x25e135,_0x2f9f86['type'])){return;}var _0x238b22=_[_0x9edd('0x30')](_0x4d507f,[_0x9edd('0x2e'),_0x2f9f86[_0x9edd('0x31')]])['name'];return db[_0x9edd('0x32')][_0x9edd('0x28')]({'where':{'type':_0x238b22,'resourceId':_0x2f9f86['id']}})[_0x9edd('0x27')](function(){return _0x46c383;});})[_0x9edd('0x27')](function(){_0x339a0d[_0x9edd('0x1f')](0xcc)[_0x9edd('0x20')]();});}};}function handleEntityNotFound(_0x209aba,_0x1fba7b){return function(_0x19b6c1){if(!_0x19b6c1){_0x209aba[_0x9edd('0x1e')](0x194);}return _0x19b6c1;};}function handleError(_0x4fd03f,_0x138002){_0x138002=_0x138002||0x1f4;return function(_0x6907a5){logger[_0x9edd('0x33')](_0x6907a5[_0x9edd('0x34')]);if(_0x6907a5['name']){delete _0x6907a5[_0x9edd('0x35')];}_0x4fd03f[_0x9edd('0x1f')](_0x138002)[_0x9edd('0x36')](_0x6907a5);};}exports['index']=function(_0x2d2f88,_0x3990fb){var _0xde9b13={},_0x38a7be={},_0x21bc30={'count':0x0,'rows':[]};var _0x2bc4ed=_[_0x9edd('0x37')](db[_0x9edd('0x38')][_0x9edd('0x39')],function(_0x2539c6){return{'name':_0x2539c6[_0x9edd('0x3a')],'type':_0x2539c6[_0x9edd('0x31')][_0x9edd('0x3b')]};});_0x38a7be[_0x9edd('0x3c')]=_['map'](_0x2bc4ed,_0x9edd('0x35'));_0x38a7be['query']=_[_0x9edd('0x3d')](_0x2d2f88[_0x9edd('0x3e')]);_0x38a7be[_0x9edd('0x3f')]=_[_0x9edd('0x40')](_0x38a7be[_0x9edd('0x3c')],_0x38a7be['query']);_0xde9b13[_0x9edd('0x41')]=_[_0x9edd('0x40')](_0x38a7be[_0x9edd('0x3c')],qs[_0x9edd('0x42')](_0x2d2f88[_0x9edd('0x3e')][_0x9edd('0x42')]));_0xde9b13[_0x9edd('0x41')]=_0xde9b13[_0x9edd('0x41')][_0x9edd('0x43')]?_0xde9b13[_0x9edd('0x41')]:_0x38a7be['model'];if(!_0x2d2f88[_0x9edd('0x3e')]['hasOwnProperty'](_0x9edd('0x44'))){_0xde9b13['limit']=qs[_0x9edd('0x22')](_0x2d2f88[_0x9edd('0x3e')][_0x9edd('0x22')]);_0xde9b13['offset']=qs[_0x9edd('0x45')](_0x2d2f88[_0x9edd('0x3e')][_0x9edd('0x45')]);}_0xde9b13['order']=qs[_0x9edd('0x46')](_0x2d2f88['query'][_0x9edd('0x46')]);_0xde9b13[_0x9edd('0x47')]=qs['filters'](_[_0x9edd('0x48')](_0x2d2f88[_0x9edd('0x3e')],_0x38a7be[_0x9edd('0x3f')]),_0x2bc4ed);if(_0x2d2f88[_0x9edd('0x3e')]['filter']){_0xde9b13[_0x9edd('0x47')]=_['merge'](_0xde9b13[_0x9edd('0x47')],{'$or':_[_0x9edd('0x37')](_0x2bc4ed,function(_0x587d74){if(_0x587d74[_0x9edd('0x31')]!=='VIRTUAL'){var _0x548299={};_0x548299[_0x587d74[_0x9edd('0x35')]]={'$like':'%'+_0x2d2f88[_0x9edd('0x3e')][_0x9edd('0x2d')]+'%'};return _0x548299;}})});}_0xde9b13=_[_0x9edd('0x49')]({},_0xde9b13,_0x2d2f88[_0x9edd('0x4a')]);var _0x4737ae={'where':_0xde9b13[_0x9edd('0x47')]};return db[_0x9edd('0x38')][_0x9edd('0x21')](_0x4737ae)[_0x9edd('0x27')](function(_0x37a263){_0x21bc30[_0x9edd('0x21')]=_0x37a263;if(_0x2d2f88[_0x9edd('0x3e')][_0x9edd('0x4b')]){_0xde9b13[_0x9edd('0x4c')]=[{'all':!![]}];}return db['VoiceQueue'][_0x9edd('0x4d')](_0xde9b13);})[_0x9edd('0x27')](function(_0x2231c1){_0x21bc30[_0x9edd('0x4e')]=_0x2231c1;return _0x21bc30;})[_0x9edd('0x27')](respondWithFilteredResult(_0x3990fb,_0xde9b13))[_0x9edd('0x4f')](handleError(_0x3990fb,null));};exports[_0x9edd('0x50')]=function(_0x4e9ad1,_0x4a4656){var _0x4bc7a1={'raw':![],'where':{'id':_0x4e9ad1['params']['id']}},_0x4a7dc9={};_0x4a7dc9[_0x9edd('0x3c')]=_[_0x9edd('0x3d')](db[_0x9edd('0x38')][_0x9edd('0x39')]);_0x4a7dc9[_0x9edd('0x3e')]=_['keys'](_0x4e9ad1[_0x9edd('0x3e')]);_0x4a7dc9[_0x9edd('0x3f')]=_[_0x9edd('0x40')](_0x4a7dc9['model'],_0x4a7dc9[_0x9edd('0x3e')]);_0x4bc7a1[_0x9edd('0x41')]=_[_0x9edd('0x40')](_0x4a7dc9[_0x9edd('0x3c')],qs[_0x9edd('0x42')](_0x4e9ad1[_0x9edd('0x3e')]['fields']));_0x4bc7a1[_0x9edd('0x41')]=_0x4bc7a1[_0x9edd('0x41')]['length']?_0x4bc7a1[_0x9edd('0x41')]:_0x4a7dc9[_0x9edd('0x3c')];if(_0x4e9ad1['query'][_0x9edd('0x4b')]){_0x4bc7a1[_0x9edd('0x4c')]=[{'all':!![]}];}_0x4bc7a1=_[_0x9edd('0x49')]({},_0x4bc7a1,_0x4e9ad1['options']);return db[_0x9edd('0x38')][_0x9edd('0x30')](_0x4bc7a1)[_0x9edd('0x27')](handleEntityNotFound(_0x4a4656,null))[_0x9edd('0x27')](respondWithResult(_0x4a4656,null))['catch'](handleError(_0x4a4656,null));};exports[_0x9edd('0x51')]=function(_0x527727,_0x12ba09){return db['VoiceQueue'][_0x9edd('0x51')](_0x527727[_0x9edd('0x52')],{})['then'](function(_0x8e59bd){var _0x4e2aaf=_0x527727[_0x9edd('0x53')][_0x9edd('0x29')]({'plain':!![]});if(!_0x4e2aaf)throw new Error(_0x9edd('0x54'));if(_0x4e2aaf[_0x9edd('0x55')]===_0x9edd('0x53')){var _0x18548e=_0x8e59bd[_0x9edd('0x29')]({'plain':!![]});var _0x14dd27=[{'name':_0x9edd('0x56'),'value':_0x9edd('0x2a')},{'name':_0x9edd('0x2b'),'value':'outbound'}];var _0x161bea=_[_0x9edd('0x30')](_0x14dd27,[_0x9edd('0x2e'),_0x18548e['type']])[_0x9edd('0x35')];return db['UserProfileSection']['find']({'where':{'name':_0x161bea,'userProfileId':_0x4e2aaf['userProfileId']},'raw':!![]})[_0x9edd('0x27')](function(_0x45f47c){if(_0x45f47c&&_0x45f47c[_0x9edd('0x57')]===0x0){return db[_0x9edd('0x32')]['create']({'name':_0x18548e['name'],'resourceId':_0x18548e['id'],'type':_0x45f47c['name'],'sectionId':_0x45f47c['id']},{})[_0x9edd('0x27')](function(){return _0x8e59bd;});}else{return _0x8e59bd;}})[_0x9edd('0x4f')](function(_0xd5090a){logger[_0x9edd('0x33')](_0x9edd('0x58'),_0xd5090a);throw _0xd5090a;});}return _0x8e59bd;})[_0x9edd('0x27')](respondWithResult(_0x12ba09,0xc9))[_0x9edd('0x4f')](handleError(_0x12ba09,null));};exports[_0x9edd('0x59')]=function(_0x4eb780,_0x16dfdc){var _0x49d0ce={'where':{'id':_0x4eb780[_0x9edd('0x5a')]['id']}},_0x421e82={};_0x421e82['model']=_[_0x9edd('0x3d')](db[_0x9edd('0x38')][_0x9edd('0x39')]);_0x49d0ce['attributes']=_[_0x9edd('0x40')](_0x421e82[_0x9edd('0x3c')],qs[_0x9edd('0x42')](_0x4eb780[_0x9edd('0x3e')][_0x9edd('0x42')]));_0x49d0ce[_0x9edd('0x41')]=_0x49d0ce['attributes']['length']?_0x49d0ce[_0x9edd('0x41')]:_0x421e82['model'];if(_0x4eb780[_0x9edd('0x3e')][_0x9edd('0x4b')]){_0x49d0ce[_0x9edd('0x4c')]=[{'all':!![]}];}_0x49d0ce=_[_0x9edd('0x49')]({},_0x49d0ce,_0x4eb780['options']);return db[_0x9edd('0x38')]['find'](_0x49d0ce)[_0x9edd('0x27')](handleEntityNotFound(_0x16dfdc,null))[_0x9edd('0x27')](function(_0xc6bde6){if(_0xc6bde6){var _0x5ca123=_0xc6bde6[_0x9edd('0x29')]({'plain':!![]});_0x5ca123=qs['omit'](_0x5ca123,['id',_0x9edd('0x5b'),_0x9edd('0x5c')]);_0x4eb780['body']=_[_0x9edd('0x5d')](_0x4eb780['body'],['id',_0x9edd('0x5b'),_0x9edd('0x5c')]);return db[_0x9edd('0x38')]['create'](_[_0x9edd('0x49')](_0x5ca123,_0x4eb780[_0x9edd('0x52')]),{'include':_0x4eb780[_0x9edd('0x3e')][_0x9edd('0x4b')]?[{'all':!![]}]:undefined})[_0x9edd('0x27')](function(_0x4d8fbb){var _0x48f017=_0x4eb780[_0x9edd('0x53')][_0x9edd('0x29')]({'plain':!![]});if(!_0x48f017)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x48f017['role']==='user'){var _0x1bc89b=_0x4d8fbb['get']({'plain':!![]});var _0x5cde37=[{'name':_0x9edd('0x56'),'value':_0x9edd('0x2a')},{'name':'QueueCampaigns','value':_0x9edd('0x2c')}];var _0x11e082=_[_0x9edd('0x30')](_0x5cde37,['value',_0x1bc89b[_0x9edd('0x31')]])['name'];return db[_0x9edd('0x5e')][_0x9edd('0x30')]({'where':{'name':_0x11e082,'userProfileId':_0x48f017['userProfileId']},'raw':!![]})[_0x9edd('0x27')](function(_0x27da1a){if(_0x27da1a&&_0x27da1a['autoAssociation']===0x0){return db[_0x9edd('0x32')][_0x9edd('0x51')]({'name':_0x1bc89b[_0x9edd('0x35')],'resourceId':_0x1bc89b['id'],'type':_0x27da1a[_0x9edd('0x35')],'sectionId':_0x27da1a['id']},{})['then'](function(){return _0x4d8fbb;});}else{return _0x4d8fbb;}})[_0x9edd('0x4f')](function(_0x58330c){logger[_0x9edd('0x33')](_0x9edd('0x58'),_0x58330c);throw _0x58330c;});}return _0x4d8fbb;});}})[_0x9edd('0x27')](respondWithResult(_0x16dfdc,0xc9))['catch'](handleError(_0x16dfdc,null));};exports[_0x9edd('0x26')]=function(_0x286593,_0x130dba){if(_0x286593[_0x9edd('0x52')]['id']){delete _0x286593[_0x9edd('0x52')]['id'];}return db[_0x9edd('0x38')][_0x9edd('0x30')]({'where':{'id':_0x286593['params']['id']}})['then'](handleEntityNotFound(_0x130dba,null))[_0x9edd('0x27')](saveUpdates(_0x286593[_0x9edd('0x52')],null))[_0x9edd('0x27')](respondWithResult(_0x130dba,null))[_0x9edd('0x4f')](handleError(_0x130dba,null));};exports[_0x9edd('0x28')]=function(_0x52f6f3,_0x2e40c8){return db[_0x9edd('0x38')][_0x9edd('0x30')]({'where':{'id':_0x52f6f3['params']['id']}})[_0x9edd('0x27')](handleEntityNotFound(_0x2e40c8,null))[_0x9edd('0x27')](removeEntity(_0x2e40c8,null))['catch'](handleError(_0x2e40c8,null));};exports[_0x9edd('0x5f')]=function(_0x3801c4,_0x58c839,_0x40b7db){var _0x1e2de6={'raw':![],'where':{}};var _0x566be7={};var _0x3f08ac={'count':0x0,'rows':[]};return db['VoiceQueue']['findOne']({'where':{'id':_0x3801c4[_0x9edd('0x5a')]['id']}})[_0x9edd('0x27')](handleEntityNotFound(_0x58c839,null))[_0x9edd('0x27')](function(_0x5b56c7){if(_0x5b56c7){_0x566be7[_0x9edd('0x3c')]=_[_0x9edd('0x3d')](db['CmHopper'][_0x9edd('0x39')]);_0x566be7[_0x9edd('0x3e')]=_[_0x9edd('0x3d')](_0x3801c4[_0x9edd('0x3e')]);_0x566be7['filters']=_['intersection'](_0x566be7[_0x9edd('0x3c')],_0x566be7['query']);_0x1e2de6[_0x9edd('0x41')]=_[_0x9edd('0x40')](_0x566be7[_0x9edd('0x3c')],qs[_0x9edd('0x42')](_0x3801c4[_0x9edd('0x3e')][_0x9edd('0x42')]));_0x1e2de6[_0x9edd('0x41')]=_0x1e2de6[_0x9edd('0x41')][_0x9edd('0x43')]?_0x1e2de6['attributes']:_0x566be7[_0x9edd('0x3c')];if(!_0x3801c4[_0x9edd('0x3e')][_0x9edd('0x60')](_0x9edd('0x44'))){_0x1e2de6[_0x9edd('0x22')]=qs[_0x9edd('0x22')](_0x3801c4[_0x9edd('0x3e')]['limit']);_0x1e2de6[_0x9edd('0x45')]=qs[_0x9edd('0x45')](_0x3801c4['query'][_0x9edd('0x45')]);}_0x1e2de6[_0x9edd('0x61')]=qs['sort'](_0x3801c4[_0x9edd('0x3e')][_0x9edd('0x46')]);_0x1e2de6[_0x9edd('0x47')]=qs['filters'](_[_0x9edd('0x48')](_0x3801c4[_0x9edd('0x3e')],_0x566be7[_0x9edd('0x3f')]));_0x1e2de6['where']['VoiceQueueId']=_0x5b56c7['id'];if(_0x3801c4['query']['filter']){_0x1e2de6[_0x9edd('0x47')]=_[_0x9edd('0x49')](_0x1e2de6[_0x9edd('0x47')],{'$or':_['map'](_0x1e2de6['attributes'],function(_0x49dc1d){var _0x56d794={};_0x56d794[_0x49dc1d]={'$like':'%'+_0x3801c4[_0x9edd('0x3e')][_0x9edd('0x2d')]+'%'};return _0x56d794;})});}_0x1e2de6=_[_0x9edd('0x49')]({},_0x1e2de6,_0x3801c4[_0x9edd('0x4a')]);return db[_0x9edd('0x62')][_0x9edd('0x21')]({'where':_0x1e2de6[_0x9edd('0x47')]})[_0x9edd('0x27')](function(_0x2f2c34){_0x3f08ac[_0x9edd('0x21')]=_0x2f2c34;if(_0x3801c4[_0x9edd('0x3e')]['includeAll']){_0x1e2de6[_0x9edd('0x4c')]=[{'all':!![]}];}return db[_0x9edd('0x62')][_0x9edd('0x4d')](_0x1e2de6);})[_0x9edd('0x27')](function(_0x104afc){_0x3f08ac[_0x9edd('0x4e')]=_0x104afc;return _0x3f08ac;});}})[_0x9edd('0x27')](respondWithFilteredResult(_0x58c839,_0x1e2de6))[_0x9edd('0x4f')](handleError(_0x58c839,null));};exports['getHopperHistories']=function(_0x5ada4e,_0xe02a6,_0x4ec836){var _0x35950b={'raw':!![],'where':{}};var _0x4a685e={};var _0x21c35f={'count':0x0,'rows':[]};return db[_0x9edd('0x38')]['findOne']({'where':{'id':_0x5ada4e[_0x9edd('0x5a')]['id']}})[_0x9edd('0x27')](handleEntityNotFound(_0xe02a6,null))['then'](function(_0x2bcc7a){if(_0x2bcc7a){_0x4a685e[_0x9edd('0x3c')]=_[_0x9edd('0x3d')](db[_0x9edd('0x63')][_0x9edd('0x39')]);_0x4a685e['query']=_[_0x9edd('0x3d')](_0x5ada4e[_0x9edd('0x3e')]);_0x4a685e[_0x9edd('0x3f')]=_[_0x9edd('0x40')](_0x4a685e[_0x9edd('0x3c')],_0x4a685e['query']);_0x35950b['attributes']=_['intersection'](_0x4a685e['model'],qs['fields'](_0x5ada4e[_0x9edd('0x3e')]['fields']));_0x35950b['attributes']=_0x35950b[_0x9edd('0x41')][_0x9edd('0x43')]?_0x35950b[_0x9edd('0x41')]:_0x4a685e[_0x9edd('0x3c')];if(!_0x5ada4e[_0x9edd('0x3e')][_0x9edd('0x60')](_0x9edd('0x44'))){_0x35950b[_0x9edd('0x22')]=qs[_0x9edd('0x22')](_0x5ada4e[_0x9edd('0x3e')]['limit']);_0x35950b[_0x9edd('0x45')]=qs[_0x9edd('0x45')](_0x5ada4e[_0x9edd('0x3e')][_0x9edd('0x45')]);}_0x35950b[_0x9edd('0x61')]=qs[_0x9edd('0x46')](_0x5ada4e[_0x9edd('0x3e')][_0x9edd('0x46')]);_0x35950b['where']=qs['filters'](_[_0x9edd('0x48')](_0x5ada4e[_0x9edd('0x3e')],_0x4a685e[_0x9edd('0x3f')]));_0x35950b[_0x9edd('0x47')][_0x9edd('0x64')]=_0x2bcc7a['id'];if(_0x5ada4e[_0x9edd('0x3e')][_0x9edd('0x2d')]){_0x35950b[_0x9edd('0x47')]=_[_0x9edd('0x49')](_0x35950b[_0x9edd('0x47')],{'$or':_[_0x9edd('0x37')](_0x35950b[_0x9edd('0x41')],function(_0x103a61){var _0xf418d={};_0xf418d[_0x103a61]={'$like':'%'+_0x5ada4e['query'][_0x9edd('0x2d')]+'%'};return _0xf418d;})});}_0x35950b=_[_0x9edd('0x49')]({},_0x35950b,_0x5ada4e['options']);return db[_0x9edd('0x63')][_0x9edd('0x21')]({'where':_0x35950b[_0x9edd('0x47')]})[_0x9edd('0x27')](function(_0x559503){_0x21c35f[_0x9edd('0x21')]=_0x559503;if(_0x5ada4e[_0x9edd('0x3e')][_0x9edd('0x4b')]){_0x35950b[_0x9edd('0x4c')]=[{'all':!![]}];}return db[_0x9edd('0x63')]['findAll'](_0x35950b);})[_0x9edd('0x27')](function(_0x1c21d5){_0x21c35f[_0x9edd('0x4e')]=_0x1c21d5;return _0x21c35f;});}})[_0x9edd('0x27')](respondWithFilteredResult(_0xe02a6,_0x35950b))[_0x9edd('0x4f')](handleError(_0xe02a6,null));};exports['getHopperFinals']=function(_0x4d0734,_0x2f8ce1,_0x5435e3){var _0x30208f={'raw':!![],'where':{}};var _0x52308a={};var _0xe9ab48={'count':0x0,'rows':[]};return db[_0x9edd('0x38')][_0x9edd('0x65')]({'where':{'id':_0x4d0734[_0x9edd('0x5a')]['id']}})[_0x9edd('0x27')](handleEntityNotFound(_0x2f8ce1,null))[_0x9edd('0x27')](function(_0x5975f9){if(_0x5975f9){_0x52308a[_0x9edd('0x3c')]=_[_0x9edd('0x3d')](db[_0x9edd('0x66')][_0x9edd('0x39')]);_0x52308a[_0x9edd('0x3e')]=_[_0x9edd('0x3d')](_0x4d0734[_0x9edd('0x3e')]);_0x52308a[_0x9edd('0x3f')]=_['intersection'](_0x52308a[_0x9edd('0x3c')],_0x52308a[_0x9edd('0x3e')]);_0x30208f[_0x9edd('0x41')]=_[_0x9edd('0x40')](_0x52308a[_0x9edd('0x3c')],qs[_0x9edd('0x42')](_0x4d0734[_0x9edd('0x3e')][_0x9edd('0x42')]));_0x30208f[_0x9edd('0x41')]=_0x30208f[_0x9edd('0x41')][_0x9edd('0x43')]?_0x30208f[_0x9edd('0x41')]:_0x52308a[_0x9edd('0x3c')];if(!_0x4d0734[_0x9edd('0x3e')][_0x9edd('0x60')](_0x9edd('0x44'))){_0x30208f[_0x9edd('0x22')]=qs[_0x9edd('0x22')](_0x4d0734[_0x9edd('0x3e')][_0x9edd('0x22')]);_0x30208f[_0x9edd('0x45')]=qs['offset'](_0x4d0734[_0x9edd('0x3e')]['offset']);}_0x30208f['order']=qs[_0x9edd('0x46')](_0x4d0734[_0x9edd('0x3e')][_0x9edd('0x46')]);_0x30208f[_0x9edd('0x47')]=qs[_0x9edd('0x3f')](_[_0x9edd('0x48')](_0x4d0734[_0x9edd('0x3e')],_0x52308a[_0x9edd('0x3f')]));_0x30208f[_0x9edd('0x47')][_0x9edd('0x64')]=_0x5975f9['id'];if(_0x4d0734['query'][_0x9edd('0x2d')]){_0x30208f[_0x9edd('0x47')]=_['merge'](_0x30208f['where'],{'$or':_[_0x9edd('0x37')](_0x30208f[_0x9edd('0x41')],function(_0x29feb7){var _0x28a8ff={};_0x28a8ff[_0x29feb7]={'$like':'%'+_0x4d0734['query']['filter']+'%'};return _0x28a8ff;})});}_0x30208f=_[_0x9edd('0x49')]({},_0x30208f,_0x4d0734['options']);return db[_0x9edd('0x66')][_0x9edd('0x21')]({'where':_0x30208f[_0x9edd('0x47')]})['then'](function(_0x5cb572){_0xe9ab48['count']=_0x5cb572;if(_0x4d0734[_0x9edd('0x3e')][_0x9edd('0x4b')]){_0x30208f[_0x9edd('0x4c')]=[{'all':!![]}];}return db['CmHopperFinal'][_0x9edd('0x4d')](_0x30208f);})[_0x9edd('0x27')](function(_0x4f12b9){_0xe9ab48[_0x9edd('0x4e')]=_0x4f12b9;return _0xe9ab48;});}})[_0x9edd('0x27')](respondWithFilteredResult(_0x2f8ce1,_0x30208f))['catch'](handleError(_0x2f8ce1,null));};exports['getHopperBlacks']=function(_0x427db2,_0x81cf58,_0x525441){var _0x33fe33={'raw':!![],'where':{}};var _0x16c7f={};var _0x54c6a0={'count':0x0,'rows':[]};return db[_0x9edd('0x38')]['findOne']({'where':{'id':_0x427db2[_0x9edd('0x5a')]['id']}})[_0x9edd('0x27')](handleEntityNotFound(_0x81cf58,null))[_0x9edd('0x27')](function(_0x742e13){if(_0x742e13){_0x16c7f[_0x9edd('0x3c')]=_[_0x9edd('0x3d')](db['CmHopperBlack'][_0x9edd('0x39')]);_0x16c7f[_0x9edd('0x3e')]=_[_0x9edd('0x3d')](_0x427db2['query']);_0x16c7f[_0x9edd('0x3f')]=_['intersection'](_0x16c7f[_0x9edd('0x3c')],_0x16c7f[_0x9edd('0x3e')]);_0x33fe33[_0x9edd('0x41')]=_[_0x9edd('0x40')](_0x16c7f['model'],qs['fields'](_0x427db2['query'][_0x9edd('0x42')]));_0x33fe33[_0x9edd('0x41')]=_0x33fe33[_0x9edd('0x41')]['length']?_0x33fe33[_0x9edd('0x41')]:_0x16c7f[_0x9edd('0x3c')];if(!_0x427db2[_0x9edd('0x3e')][_0x9edd('0x60')](_0x9edd('0x44'))){_0x33fe33[_0x9edd('0x22')]=qs['limit'](_0x427db2['query'][_0x9edd('0x22')]);_0x33fe33[_0x9edd('0x45')]=qs[_0x9edd('0x45')](_0x427db2['query'][_0x9edd('0x45')]);}_0x33fe33[_0x9edd('0x61')]=qs[_0x9edd('0x46')](_0x427db2[_0x9edd('0x3e')]['sort']);_0x33fe33[_0x9edd('0x47')]=qs['filters'](_[_0x9edd('0x48')](_0x427db2[_0x9edd('0x3e')],_0x16c7f[_0x9edd('0x3f')]));_0x33fe33[_0x9edd('0x47')][_0x9edd('0x64')]=_0x742e13['id'];if(_0x427db2['query'][_0x9edd('0x2d')]){_0x33fe33['where']=_[_0x9edd('0x49')](_0x33fe33['where'],{'$or':_[_0x9edd('0x37')](_0x33fe33['attributes'],function(_0x363c5c){var _0x96e3d7={};_0x96e3d7[_0x363c5c]={'$like':'%'+_0x427db2[_0x9edd('0x3e')]['filter']+'%'};return _0x96e3d7;})});}_0x33fe33=_[_0x9edd('0x49')]({},_0x33fe33,_0x427db2[_0x9edd('0x4a')]);return db[_0x9edd('0x67')][_0x9edd('0x21')]({'where':_0x33fe33[_0x9edd('0x47')]})[_0x9edd('0x27')](function(_0x6a24f3){_0x54c6a0[_0x9edd('0x21')]=_0x6a24f3;if(_0x427db2[_0x9edd('0x3e')][_0x9edd('0x4b')]){_0x33fe33[_0x9edd('0x4c')]=[{'all':!![]}];}return db[_0x9edd('0x67')][_0x9edd('0x4d')](_0x33fe33);})[_0x9edd('0x27')](function(_0x33dbe8){_0x54c6a0[_0x9edd('0x4e')]=_0x33dbe8;return _0x54c6a0;});}})[_0x9edd('0x27')](respondWithFilteredResult(_0x81cf58,_0x33fe33))[_0x9edd('0x4f')](handleError(_0x81cf58,null));};exports[_0x9edd('0x68')]=function(_0x1bba37,_0x33e1f0,_0x31ff2f){var _0x5100a9={};var _0x45905b={};var _0x530866;var _0x3a743d;return db[_0x9edd('0x38')][_0x9edd('0x65')]({'where':{'id':_0x1bba37[_0x9edd('0x5a')]['id']}})[_0x9edd('0x27')](handleEntityNotFound(_0x33e1f0,null))['then'](function(_0x2d7cff){if(_0x2d7cff){_0x530866=_0x2d7cff;_0x45905b['model']=_[_0x9edd('0x3d')](db[_0x9edd('0x69')][_0x9edd('0x39')]);_0x45905b[_0x9edd('0x3e')]=_[_0x9edd('0x3d')](_0x1bba37[_0x9edd('0x3e')]);_0x45905b['filters']=_[_0x9edd('0x40')](_0x45905b[_0x9edd('0x3c')],_0x45905b['query']);_0x5100a9['attributes']=_['intersection'](_0x45905b['model'],qs[_0x9edd('0x42')](_0x1bba37[_0x9edd('0x3e')][_0x9edd('0x42')]));_0x5100a9[_0x9edd('0x41')]=_0x5100a9[_0x9edd('0x41')][_0x9edd('0x43')]?_0x5100a9[_0x9edd('0x41')]:_0x45905b[_0x9edd('0x3c')];_0x5100a9[_0x9edd('0x61')]=qs[_0x9edd('0x46')](_0x1bba37['query'][_0x9edd('0x46')]);_0x5100a9['where']=qs['filters'](_[_0x9edd('0x48')](_0x1bba37[_0x9edd('0x3e')],_0x45905b[_0x9edd('0x3f')]));if(_0x1bba37[_0x9edd('0x3e')][_0x9edd('0x2d')]){_0x5100a9['where']=_[_0x9edd('0x49')](_0x5100a9[_0x9edd('0x47')],{'$or':_[_0x9edd('0x37')](_0x5100a9[_0x9edd('0x41')],function(_0x550439){var _0x16f295={};_0x16f295[_0x550439]={'$like':'%'+_0x1bba37[_0x9edd('0x3e')][_0x9edd('0x2d')]+'%'};return _0x16f295;})});}_0x5100a9=_[_0x9edd('0x49')]({},_0x5100a9,_0x1bba37[_0x9edd('0x4a')]);return _0x530866[_0x9edd('0x68')](_0x5100a9);}})[_0x9edd('0x27')](function(_0x9ff2d3){if(_0x9ff2d3){_0x3a743d=_0x9ff2d3[_0x9edd('0x43')];if(!_0x1bba37[_0x9edd('0x3e')][_0x9edd('0x60')]('nolimit')){_0x5100a9[_0x9edd('0x22')]=qs[_0x9edd('0x22')](_0x1bba37[_0x9edd('0x3e')][_0x9edd('0x22')]);_0x5100a9[_0x9edd('0x45')]=qs[_0x9edd('0x45')](_0x1bba37[_0x9edd('0x3e')][_0x9edd('0x45')]);}return _0x530866['getTeams'](_0x5100a9);}})['then'](function(_0x5741cb){if(_0x5741cb){return _0x5741cb?{'count':_0x3a743d,'rows':_0x5741cb}:null;}})[_0x9edd('0x27')](respondWithResult(_0x33e1f0,null))[_0x9edd('0x4f')](handleError(_0x33e1f0,null));};exports[_0x9edd('0x6a')]=function(_0x2810dc,_0x223c42,_0x2e9df8){var _0x3cddc7=_0x2810dc[_0x9edd('0x52')][_0x9edd('0x6b')];var _0x366483=_['map'](_0x3cddc7,'id');return db[_0x9edd('0x69')]['findAll']({'where':{'id':_0x366483},'attributes':['id'],'include':[{'model':db['User'],'as':_0x9edd('0x6c'),'attributes':['id',_0x9edd('0x35'),_0x9edd('0x6d'),'voicePause','interface'],'raw':!![]}]})['then'](function(_0x56bdb9){if(_0x56bdb9){var _0x5a3bca=_[_0x9edd('0x6e')](_0x56bdb9,function(_0x3b683f){var _0x64505a=_0x3b683f['get']({'plain':!![]});_0x64505a[_0x9edd('0x6c')][_0x9edd('0x6f')](function(_0x231917){_0x231917['penalty']=_[_0x9edd('0x30')](_0x3cddc7,{'id':_0x64505a['id']})['penalty'];});return _0x64505a[_0x9edd('0x6c')];});return db[_0x9edd('0x38')][_0x9edd('0x30')]({'where':{'id':_0x2810dc[_0x9edd('0x5a')]['id']}})['then'](function(_0x44933c){return db[_0x9edd('0x70')]['transaction'](function(_0x3309ba){return _0x44933c[_0x9edd('0x6a')](_0x366483,{'transaction':_0x3309ba})[_0x9edd('0x27')](function(){return BPromise[_0x9edd('0x71')](_0x5a3bca,function(_0x5c0254){return db[_0x9edd('0x72')][_0x9edd('0x73')]({'where':{'UserId':_0x5c0254['id'],'VoiceQueueId':_0x2810dc[_0x9edd('0x5a')]['id']},'defaults':{'penalty':_0x5c0254[_0x9edd('0x74')]},'transaction':_0x3309ba});});})[_0x9edd('0x27')](function(){return BPromise[_0x9edd('0x71')](_[_0x9edd('0x2d')](_0x5a3bca,{'online':!![]}),function(_0x5baec8){return db[_0x9edd('0x75')]['upsert']({'membername':_0x5baec8[_0x9edd('0x35')],'UserId':_0x5baec8['id'],'queue_name':_0x44933c[_0x9edd('0x35')],'VoiceQueueId':_0x44933c['id'],'interface':_['isNil'](_0x5baec8[_0x9edd('0x76')])?util[_0x9edd('0x77')](_0x9edd('0x78'),_0x5baec8['name']):_0x5baec8[_0x9edd('0x76')],'paused':_0x5baec8[_0x9edd('0x79')]||![],'penalty':_0x5baec8[_0x9edd('0x74')]},{'transaction':_0x3309ba});});})['then'](function(){_0x5a3bca[_0x9edd('0x6f')](function(_0x517142){socket[_0x9edd('0x7a')](_0x9edd('0x7b'),{'UserId':_0x517142['id'],'VoiceQueueId':_0x44933c['id']});});});});});}})[_0x9edd('0x27')](respondWithStatusCode(_0x223c42,null))[_0x9edd('0x4f')](handleError(_0x223c42,null));};exports['removeTeams']=function(_0x4843f2,_0x3bceb3,_0x12f23f){return db[_0x9edd('0x69')][_0x9edd('0x4d')]({'where':{'id':_0x4843f2[_0x9edd('0x3e')]['ids']},'attributes':['id'],'include':[{'model':db[_0x9edd('0x7c')],'as':_0x9edd('0x6c'),'attributes':['id'],'raw':!![]}]})[_0x9edd('0x27')](handleEntityNotFound(_0x3bceb3,null))[_0x9edd('0x27')](function(_0x37879a){var _0x100cad=_[_0x9edd('0x37')](_0x37879a,'id');var _0x3d1ea5=[];var _0x3173fa=[];var _0x2eb738=squel[_0x9edd('0x7d')]();_0x2eb738[_0x9edd('0x7e')](_0x9edd('0x7f'))['from'](_0x9edd('0x80'),'tq')[_0x9edd('0x81')](_0x9edd('0x82'),'ut',_0x9edd('0x83'))['where'](_0x9edd('0x84'),_0x4843f2[_0x9edd('0x5a')]['id']);for(var _0x3eb99c=0x0;_0x3eb99c<_0x37879a['length'];_0x3eb99c+=0x1){let _0x910adf=_0x37879a[_0x3eb99c];for(var _0x49a24f=0x0;_0x49a24f<_0x910adf['Agents'][_0x9edd('0x43')];_0x49a24f+=0x1){let _0x94a989=_0x910adf[_0x9edd('0x6c')][_0x49a24f];var _0x1934d3=_0x2eb738['clone']();_0x1934d3[_0x9edd('0x47')](_0x9edd('0x85'),_0x94a989['id']);_0x3173fa[_0x9edd('0x86')](db[_0x9edd('0x70')][_0x9edd('0x3e')](_0x1934d3[_0x9edd('0x87')](),{'type':db[_0x9edd('0x70')][_0x9edd('0x88')][_0x9edd('0x89')]})[_0x9edd('0x27')](function(_0xa4a0f3){if(_0xa4a0f3[_0x9edd('0x43')]===0x1){return _0x94a989['id'];}else{var _0x5c17fb=_[_0x9edd('0x8a')](_[_0x9edd('0x37')](_0xa4a0f3,_0x9edd('0x8b')),function(_0x16f5f4){return _[_0x9edd('0x2f')](_0x100cad,_0x16f5f4);});if(_0x5c17fb){return _0x94a989['id'];}}}));}}return BPromise['all'](_0x3173fa)[_0x9edd('0x27')](function(_0x4a4581){_0x3d1ea5=_(_0x3d1ea5)[_0x9edd('0x8c')](_0x4a4581)[_0x9edd('0x8d')]()['value']();return db['VoiceQueue'][_0x9edd('0x30')]({'where':{'id':_0x4843f2[_0x9edd('0x5a')]['id']}})[_0x9edd('0x27')](function(_0x25b361){return db[_0x9edd('0x70')]['transaction'](function(_0x5601fc){return _0x25b361[_0x9edd('0x8e')](_0x4843f2[_0x9edd('0x3e')][_0x9edd('0x8f')],{'transaction':_0x5601fc})[_0x9edd('0x27')](function(){if(!_['isEmpty'](_0x3d1ea5)){return _0x25b361[_0x9edd('0x90')](_0x3d1ea5,{'transaction':_0x5601fc})[_0x9edd('0x27')](function(){return db[_0x9edd('0x75')][_0x9edd('0x28')]({'where':{'VoiceQueueId':_0x4843f2[_0x9edd('0x5a')]['id'],'UserId':_0x3d1ea5},'transaction':_0x5601fc});});}})[_0x9edd('0x27')](function(){_0x3d1ea5[_0x9edd('0x6f')](function(_0x5bda3a){socket[_0x9edd('0x7a')](_0x9edd('0x91'),{'UserId':_0x5bda3a,'VoiceQueueId':_0x25b361['id']});});});});});});})[_0x9edd('0x27')](respondWithStatusCode(_0x3bceb3,null))[_0x9edd('0x4f')](handleError(_0x3bceb3,null));};exports[_0x9edd('0x92')]=function(_0x252617,_0x1f527b,_0x24a665){var _0x8fdcf0,_0x8161b1;return db[_0x9edd('0x38')][_0x9edd('0x30')]({'where':{'id':_0x252617[_0x9edd('0x5a')]['id']}})['then'](handleEntityNotFound(_0x1f527b,null))[_0x9edd('0x27')](function(_0x32cb87){if(_0x32cb87){_0x8161b1=_0x32cb87;return _0x32cb87[_0x9edd('0x92')](_0x252617[_0x9edd('0x52')]['ids'],_[_0x9edd('0x5d')](_0x252617[_0x9edd('0x52')],[_0x9edd('0x8f'),'id'])||{})[_0x9edd('0x93')](function(_0x30f26a){for(var _0x1bf963=0x0;_0x1bf963<_0x252617[_0x9edd('0x52')][_0x9edd('0x8f')][_0x9edd('0x43')];_0x1bf963+=0x1){socket[_0x9edd('0x7a')](_0x9edd('0x7b'),{'UserId':_0x252617['body'][_0x9edd('0x8f')][_0x1bf963],'VoiceQueueId':_0x252617[_0x9edd('0x5a')]['id']});}return _0x30f26a;});}})[_0x9edd('0x27')](function(_0x257dee){_0x8fdcf0=_0x257dee||[];if(_0x8161b1){return db[_0x9edd('0x7c')][_0x9edd('0x4d')]({'where':{'id':_0x252617[_0x9edd('0x52')]['ids']},'attributes':['id',_0x9edd('0x35'),_0x9edd('0x6d'),_0x9edd('0x79'),_0x9edd('0x76')],'raw':!![]});}})[_0x9edd('0x27')](function(_0x116fcb){if(!_[_0x9edd('0x94')](_0x116fcb)){var _0x2cb08b=[];for(var _0x1b780b=0x0;_0x1b780b<_0x116fcb[_0x9edd('0x43')];_0x1b780b++){if(_0x116fcb[_0x1b780b][_0x9edd('0x6d')]){_0x2cb08b[_0x9edd('0x86')](db[_0x9edd('0x75')][_0x9edd('0x95')]({'membername':_0x116fcb[_0x1b780b][_0x9edd('0x35')],'UserId':_0x116fcb[_0x1b780b]['id'],'queue_name':_0x8161b1[_0x9edd('0x35')],'VoiceQueueId':_0x8161b1['id'],'interface':_[_0x9edd('0x96')](_0x116fcb[_0x1b780b]['interface'])?util[_0x9edd('0x77')](_0x9edd('0x78'),_0x116fcb[_0x1b780b][_0x9edd('0x35')]):_0x116fcb[_0x1b780b][_0x9edd('0x76')],'paused':_0x116fcb[_0x1b780b][_0x9edd('0x79')]||![],'penalty':_0x252617[_0x9edd('0x52')][_0x9edd('0x74')]||0x0}));}}return BPromise[_0x9edd('0x97')](_0x2cb08b);}})[_0x9edd('0x27')](function(){return _0x8fdcf0;})['then'](respondWithResult(_0x1f527b,null))[_0x9edd('0x4f')](handleError(_0x1f527b,null));};exports[_0x9edd('0x90')]=function(_0x2d5b04,_0x583feb,_0x248ca2){return db['VoiceQueue'][_0x9edd('0x30')]({'where':{'id':_0x2d5b04['params']['id']}})[_0x9edd('0x27')](handleEntityNotFound(_0x583feb,null))[_0x9edd('0x27')](function(_0x5c79c5){if(_0x5c79c5){return _0x5c79c5[_0x9edd('0x90')](_0x2d5b04[_0x9edd('0x3e')][_0x9edd('0x8f')])[_0x9edd('0x27')](function(){if(_[_0x9edd('0x98')](_0x2d5b04[_0x9edd('0x3e')][_0x9edd('0x8f')])){for(var _0x5c3f89=0x0;_0x5c3f89<_0x2d5b04[_0x9edd('0x3e')][_0x9edd('0x8f')]['length'];_0x5c3f89+=0x1){socket[_0x9edd('0x7a')]('userVoiceQueue:remove',{'UserId':Number(_0x2d5b04[_0x9edd('0x3e')][_0x9edd('0x8f')][_0x5c3f89]),'VoiceQueueId':Number(_0x2d5b04[_0x9edd('0x5a')]['id'])});}}else{socket[_0x9edd('0x7a')](_0x9edd('0x91'),{'UserId':Number(_0x2d5b04[_0x9edd('0x3e')][_0x9edd('0x8f')]),'VoiceQueueId':Number(_0x2d5b04[_0x9edd('0x5a')]['id'])});}});}})[_0x9edd('0x27')](function(_0x2bc46d){return db[_0x9edd('0x75')][_0x9edd('0x28')]({'where':{'VoiceQueueId':_0x2d5b04['params']['id'],'UserId':_0x2d5b04['query'][_0x9edd('0x8f')]}})[_0x9edd('0x27')](function(){return _0x2bc46d;});})[_0x9edd('0x27')](respondWithStatusCode(_0x583feb,null))[_0x9edd('0x4f')](handleError(_0x583feb,null));};exports[_0x9edd('0x99')]=function(_0x1f64f5,_0x43a859,_0x2f4462){var _0x27c709={};var _0x491905={};var _0x1395fa;var _0x49181c;return db[_0x9edd('0x38')][_0x9edd('0x65')]({'where':{'id':_0x1f64f5[_0x9edd('0x5a')]['id']}})[_0x9edd('0x27')](handleEntityNotFound(_0x43a859,null))[_0x9edd('0x27')](function(_0x12561b){if(_0x12561b){_0x1395fa=_0x12561b;_0x491905[_0x9edd('0x3c')]=_[_0x9edd('0x3d')](db[_0x9edd('0x7c')][_0x9edd('0x39')]);_0x491905[_0x9edd('0x3e')]=_[_0x9edd('0x3d')](_0x1f64f5[_0x9edd('0x3e')]);_0x491905[_0x9edd('0x3f')]=_[_0x9edd('0x40')](_0x491905[_0x9edd('0x3c')],_0x491905[_0x9edd('0x3e')]);_0x27c709[_0x9edd('0x41')]=_[_0x9edd('0x40')](_0x491905['model'],qs['fields'](_0x1f64f5[_0x9edd('0x3e')]['fields']));_0x27c709[_0x9edd('0x41')]=_0x27c709[_0x9edd('0x41')][_0x9edd('0x43')]?_0x27c709[_0x9edd('0x41')]:_0x491905['model'];_0x27c709['order']=qs[_0x9edd('0x46')](_0x1f64f5[_0x9edd('0x3e')][_0x9edd('0x46')]);_0x27c709[_0x9edd('0x47')]=qs[_0x9edd('0x3f')](_['pick'](_0x1f64f5[_0x9edd('0x3e')],_0x491905['filters']));if(_0x1f64f5[_0x9edd('0x3e')][_0x9edd('0x2d')]){_0x27c709[_0x9edd('0x47')]=_[_0x9edd('0x49')](_0x27c709['where'],{'$or':_['map'](_0x27c709['attributes'],function(_0x3bb205){var _0x11b5be={};_0x11b5be[_0x3bb205]={'$like':'%'+_0x1f64f5[_0x9edd('0x3e')][_0x9edd('0x2d')]+'%'};return _0x11b5be;})});}_0x27c709=_[_0x9edd('0x49')]({},_0x27c709,_0x1f64f5[_0x9edd('0x4a')]);return _0x1395fa['getAgents'](_0x27c709);}})[_0x9edd('0x27')](function(_0x2779a8){if(_0x2779a8){_0x49181c=_0x2779a8['length'];if(!_0x1f64f5['query'][_0x9edd('0x60')](_0x9edd('0x44'))){_0x27c709[_0x9edd('0x22')]=qs['limit'](_0x1f64f5[_0x9edd('0x3e')][_0x9edd('0x22')]);_0x27c709[_0x9edd('0x45')]=qs[_0x9edd('0x45')](_0x1f64f5['query'][_0x9edd('0x45')]);}return _0x1395fa[_0x9edd('0x99')](_0x27c709);}})[_0x9edd('0x27')](function(_0x18924e){if(_0x18924e){return _0x18924e?{'count':_0x49181c,'rows':_0x18924e}:null;}})[_0x9edd('0x27')](respondWithResult(_0x43a859,null))[_0x9edd('0x4f')](handleError(_0x43a859,null));};exports['getMembers']=function(_0x93a34d,_0x8316f9,_0x1de546){var _0xceabed={};var _0x4a0462={};var _0x57a6bc;var _0x42f2e8;return db[_0x9edd('0x38')][_0x9edd('0x65')]({'where':{'id':_0x93a34d[_0x9edd('0x5a')]['id']}})[_0x9edd('0x27')](handleEntityNotFound(_0x8316f9,null))[_0x9edd('0x27')](function(_0x457a29){if(_0x457a29){_0x57a6bc=_0x457a29;_0x4a0462[_0x9edd('0x3c')]=_[_0x9edd('0x3d')](db[_0x9edd('0x75')][_0x9edd('0x39')]);_0x4a0462[_0x9edd('0x3e')]=_['keys'](_0x93a34d['query']);_0x4a0462[_0x9edd('0x3f')]=_[_0x9edd('0x40')](_0x4a0462[_0x9edd('0x3c')],_0x4a0462[_0x9edd('0x3e')]);_0xceabed[_0x9edd('0x41')]=_[_0x9edd('0x40')](_0x4a0462[_0x9edd('0x3c')],qs[_0x9edd('0x42')](_0x93a34d['query'][_0x9edd('0x42')]));_0xceabed[_0x9edd('0x41')]=_0xceabed[_0x9edd('0x41')][_0x9edd('0x43')]?_0xceabed[_0x9edd('0x41')]:_0x4a0462[_0x9edd('0x3c')];_0xceabed['order']=qs['sort'](_0x93a34d[_0x9edd('0x3e')][_0x9edd('0x46')]);_0xceabed[_0x9edd('0x47')]=qs['filters'](_['pick'](_0x93a34d[_0x9edd('0x3e')],_0x4a0462[_0x9edd('0x3f')]));if(_0x93a34d[_0x9edd('0x3e')][_0x9edd('0x2d')]){_0xceabed[_0x9edd('0x47')]=_[_0x9edd('0x49')](_0xceabed[_0x9edd('0x47')],{'$or':_[_0x9edd('0x37')](_0xceabed[_0x9edd('0x41')],function(_0x44f821){var _0x246d42={};_0x246d42[_0x44f821]={'$like':'%'+_0x93a34d['query'][_0x9edd('0x2d')]+'%'};return _0x246d42;})});}_0xceabed=_['merge']({},_0xceabed,_0x93a34d['options']);return _0x57a6bc['getMembers'](_0xceabed);}})[_0x9edd('0x27')](function(_0x660591){if(_0x660591){_0x42f2e8=_0x660591['length'];if(!_0x93a34d['query']['hasOwnProperty']('nolimit')){_0xceabed[_0x9edd('0x22')]=qs[_0x9edd('0x22')](_0x93a34d[_0x9edd('0x3e')]['limit']);_0xceabed[_0x9edd('0x45')]=qs[_0x9edd('0x45')](_0x93a34d[_0x9edd('0x3e')][_0x9edd('0x45')]);}return _0x57a6bc[_0x9edd('0x9a')](_0xceabed);}})['then'](function(_0x33b06c){return _0x33b06c?{'count':_0x42f2e8,'rows':_0x33b06c}:null;})['then'](respondWithResult(_0x8316f9,null))[_0x9edd('0x4f')](handleError(_0x8316f9,null));};exports['getLists']=function(_0x28706a,_0x20cf26,_0x1121ec){var _0x5f37d1={};var _0x2ef921={};var _0x294e40;var _0x3e2fc7;return db['VoiceQueue']['findOne']({'where':{'id':_0x28706a[_0x9edd('0x5a')]['id']}})[_0x9edd('0x27')](handleEntityNotFound(_0x20cf26,null))[_0x9edd('0x27')](function(_0x2040ad){if(_0x2040ad){_0x294e40=_0x2040ad;_0x2ef921[_0x9edd('0x3c')]=_[_0x9edd('0x3d')](db[_0x9edd('0x9b')][_0x9edd('0x39')]);_0x2ef921[_0x9edd('0x3e')]=_[_0x9edd('0x3d')](_0x28706a['query']);_0x2ef921[_0x9edd('0x3f')]=_[_0x9edd('0x40')](_0x2ef921['model'],_0x2ef921['query']);_0x5f37d1[_0x9edd('0x41')]=_[_0x9edd('0x40')](_0x2ef921[_0x9edd('0x3c')],qs[_0x9edd('0x42')](_0x28706a['query'][_0x9edd('0x42')]));_0x5f37d1[_0x9edd('0x41')]=_0x5f37d1[_0x9edd('0x41')][_0x9edd('0x43')]?_0x5f37d1['attributes']:_0x2ef921[_0x9edd('0x3c')];_0x5f37d1[_0x9edd('0x61')]=qs[_0x9edd('0x46')](_0x28706a['query'][_0x9edd('0x46')]);_0x5f37d1[_0x9edd('0x47')]=qs[_0x9edd('0x3f')](_[_0x9edd('0x48')](_0x28706a[_0x9edd('0x3e')],_0x2ef921[_0x9edd('0x3f')]));if(_0x28706a[_0x9edd('0x3e')]['filter']){_0x5f37d1[_0x9edd('0x47')]=_[_0x9edd('0x49')](_0x5f37d1['where'],{'$or':_[_0x9edd('0x37')](_0x5f37d1['attributes'],function(_0x5a43af){var _0x3fc229={};_0x3fc229[_0x5a43af]={'$like':'%'+_0x28706a[_0x9edd('0x3e')][_0x9edd('0x2d')]+'%'};return _0x3fc229;})});}_0x5f37d1=_[_0x9edd('0x49')]({},_0x5f37d1,_0x28706a[_0x9edd('0x4a')]);return _0x294e40[_0x9edd('0x9c')](_0x5f37d1);}})[_0x9edd('0x27')](function(_0x3c19f7){if(_0x3c19f7){_0x3e2fc7=_0x3c19f7[_0x9edd('0x43')];if(!_0x28706a[_0x9edd('0x3e')][_0x9edd('0x60')]('nolimit')){_0x5f37d1['limit']=qs[_0x9edd('0x22')](_0x28706a[_0x9edd('0x3e')][_0x9edd('0x22')]);_0x5f37d1[_0x9edd('0x45')]=qs[_0x9edd('0x45')](_0x28706a[_0x9edd('0x3e')]['offset']);}return _0x294e40[_0x9edd('0x9c')](_0x5f37d1);}})[_0x9edd('0x27')](function(_0x38eb4f){if(_0x38eb4f){return _0x38eb4f?{'count':_0x3e2fc7,'rows':_0x38eb4f}:null;}})['then'](respondWithResult(_0x20cf26,null))[_0x9edd('0x4f')](handleError(_0x20cf26,null));};exports['addLists']=function(_0x4d14ae,_0x4ab386,_0x11175c){var _0x2af999,_0x124004;return db[_0x9edd('0x38')][_0x9edd('0x30')]({'where':{'id':_0x4d14ae[_0x9edd('0x5a')]['id']}})[_0x9edd('0x27')](handleEntityNotFound(_0x4ab386,null))[_0x9edd('0x27')](function(_0xefe1d2){if(_0xefe1d2){_0x124004=_0xefe1d2;return _0xefe1d2['addLists'](_0x4d14ae[_0x9edd('0x52')][_0x9edd('0x8f')],_['omit'](_0x4d14ae['body'],[_0x9edd('0x8f'),'id'])||{});}return null;})[_0x9edd('0x93')](function(_0x560050){var _0x17c5a6;_0x2af999=_0x560050||[];var _0x42c24c=[];if(_0x560050){for(var _0x9e245f=0x0;_0x9e245f<_0x560050[_0x9edd('0x43')];_0x9e245f+=0x1){var _0x4f292d=_0x560050[_0x9e245f][_0x9edd('0x29')]({'plain':!![]});_0x124004[_0x9edd('0x9d')]=_0x4d14ae[_0x9edd('0x52')]['dialCheckDuplicateType']?_0x4d14ae[_0x9edd('0x52')][_0x9edd('0x9d')]:_0x124004[_0x9edd('0x9d')];switch(_0x124004[_0x9edd('0x9d')]){case _0x9edd('0x9e'):_0x17c5a6=squel[_0x9edd('0x9f')]()[_0x9edd('0xa0')](_0x9edd('0xa1'))['fromQuery']([_0x9edd('0xa2'),_0x9edd('0xa3'),_0x9edd('0xa4'),_0x9edd('0xa5'),_0x9edd('0x64'),_0x9edd('0x5b'),_0x9edd('0x5c')],squel['select']()[_0x9edd('0x7e')]('phone','phone')[_0x9edd('0x7e')](_0x9edd('0xa6'),'scheduledAt')[_0x9edd('0x7e')]('id',_0x9edd('0xa4'))[_0x9edd('0x7e')](_0x4f292d['CmListId']['toString'](),_0x9edd('0xa5'))[_0x9edd('0x7e')](_0x4d14ae['params']['id']['toString'](),_0x9edd('0x64'))[_0x9edd('0x7e')](_0x9edd('0xa6'),_0x9edd('0x5b'))['field']('NOW()',_0x9edd('0x5c'))[_0x9edd('0xa7')]('cm_contacts')[_0x9edd('0x47')]('deletedAt\x20IS\x20NULL')[_0x9edd('0x47')](_0x9edd('0xa8'),_0x4f292d[_0x9edd('0xa9')][_0x9edd('0x87')]())['where'](_0x9edd('0xaa'))[_0x9edd('0x47')]('phone\x20NOT\x20IN\x20(?)',squel[_0x9edd('0x7d')]()['field'](_0x9edd('0xab'))[_0x9edd('0xa7')](_0x9edd('0xac'))[_0x9edd('0x47')](_0x9edd('0x84'),_0x4d14ae[_0x9edd('0x5a')]['id']['toString']()))[_0x9edd('0x47')](_0x9edd('0xad'),squel[_0x9edd('0x7d')]()[_0x9edd('0x7e')](_0x9edd('0xae'))[_0x9edd('0xa7')](_0x9edd('0xa1'))[_0x9edd('0x47')](_0x9edd('0x84'),_0x4d14ae[_0x9edd('0x5a')]['id']['toString']())))[_0x9edd('0x87')]();break;case _0x9edd('0xaf'):_0x17c5a6=squel[_0x9edd('0x9f')]()[_0x9edd('0xa0')](_0x9edd('0xa1'))[_0x9edd('0xb0')]([_0x9edd('0xa2'),_0x9edd('0xa3'),_0x9edd('0xa4'),_0x9edd('0xa5'),_0x9edd('0x64'),_0x9edd('0x5b'),_0x9edd('0x5c')],squel[_0x9edd('0x7d')]()[_0x9edd('0x7e')]('phone',_0x9edd('0xa2'))['field']('NOW()',_0x9edd('0xa3'))[_0x9edd('0x7e')]('id',_0x9edd('0xa4'))['field'](_0x4f292d[_0x9edd('0xa9')][_0x9edd('0x87')](),'ListId')['field'](_0x4d14ae[_0x9edd('0x5a')]['id'][_0x9edd('0x87')](),'VoiceQueueId')[_0x9edd('0x7e')](_0x9edd('0xa6'),'createdAt')[_0x9edd('0x7e')](_0x9edd('0xa6'),_0x9edd('0x5c'))[_0x9edd('0xa7')](_0x9edd('0xb1'))[_0x9edd('0x47')](_0x9edd('0xb2'))[_0x9edd('0x47')]('ListId\x20=\x20?',_0x4f292d[_0x9edd('0xa9')][_0x9edd('0x87')]())[_0x9edd('0x47')](_0x9edd('0xaa'))[_0x9edd('0x47')](_0x9edd('0xad'),squel['select']()[_0x9edd('0x7e')](_0x9edd('0xae'))[_0x9edd('0xa7')](_0x9edd('0xa1'))[_0x9edd('0x47')](_0x9edd('0x84'),_0x4d14ae[_0x9edd('0x5a')]['id']['toString']())))[_0x9edd('0x87')]();break;default:_0x17c5a6=squel[_0x9edd('0x9f')]()[_0x9edd('0xa0')]('cm_hopper')[_0x9edd('0xb0')]([_0x9edd('0xa2'),_0x9edd('0xa3'),_0x9edd('0xa4'),_0x9edd('0xa5'),'VoiceQueueId',_0x9edd('0x5b'),_0x9edd('0x5c')],squel[_0x9edd('0x7d')]()[_0x9edd('0x7e')](_0x9edd('0xa2'),'phone')['field']('NOW()',_0x9edd('0xa3'))[_0x9edd('0x7e')]('id',_0x9edd('0xa4'))[_0x9edd('0x7e')](_0x4f292d[_0x9edd('0xa9')]['toString'](),_0x9edd('0xa5'))[_0x9edd('0x7e')](_0x4d14ae[_0x9edd('0x5a')]['id'][_0x9edd('0x87')](),'VoiceQueueId')[_0x9edd('0x7e')](_0x9edd('0xa6'),'createdAt')[_0x9edd('0x7e')](_0x9edd('0xa6'),_0x9edd('0x5c'))[_0x9edd('0xa7')](_0x9edd('0xb1'))[_0x9edd('0x47')](_0x9edd('0xb2'))[_0x9edd('0x47')](_0x9edd('0xa8'),_0x4f292d[_0x9edd('0xa9')][_0x9edd('0x87')]())['where'](_0x9edd('0xaa')))[_0x9edd('0x87')]();}_0x42c24c['push'](db[_0x9edd('0x70')][_0x9edd('0x3e')](_0x17c5a6));}return BPromise[_0x9edd('0x97')](_0x42c24c);}})['then'](function(){return _0x2af999;})[_0x9edd('0x27')](respondWithResult(_0x4ab386,null))[_0x9edd('0x4f')](handleError(_0x4ab386,null));};exports[_0x9edd('0xb3')]=function(_0x341249,_0x492f78,_0x4e7274){return db['VoiceQueue'][_0x9edd('0x30')]({'where':{'id':_0x341249[_0x9edd('0x5a')]['id']}})[_0x9edd('0x27')](handleEntityNotFound(_0x492f78,null))[_0x9edd('0x27')](function(_0x331526){if(_0x331526){return _0x331526[_0x9edd('0xb3')](_0x341249[_0x9edd('0x3e')][_0x9edd('0x8f')]);}})['then'](function(_0xb1ce05){if(_0xb1ce05){return db[_0x9edd('0x62')]['destroy']({'where':{'ListId':_0x341249[_0x9edd('0x3e')][_0x9edd('0x8f')],'VoiceQueueId':_0x341249[_0x9edd('0x5a')]['id']}})['then'](function(){return _0xb1ce05;});}})[_0x9edd('0x27')](respondWithStatusCode(_0x492f78,null))[_0x9edd('0x4f')](handleError(_0x492f78,null));};exports[_0x9edd('0xb4')]=function(_0x423e1c,_0x4ab8d7,_0x1fc001){var _0x219d8b={};var _0x17b5b3={};var _0x196359;var _0x36faef;return db[_0x9edd('0x38')][_0x9edd('0x65')]({'where':{'id':_0x423e1c[_0x9edd('0x5a')]['id']}})[_0x9edd('0x27')](handleEntityNotFound(_0x4ab8d7,null))[_0x9edd('0x27')](function(_0x4ec4dc){if(_0x4ec4dc){_0x196359=_0x4ec4dc;_0x17b5b3[_0x9edd('0x3c')]=_[_0x9edd('0x3d')](db['CmList']['rawAttributes']);_0x17b5b3[_0x9edd('0x3e')]=_[_0x9edd('0x3d')](_0x423e1c[_0x9edd('0x3e')]);_0x17b5b3[_0x9edd('0x3f')]=_[_0x9edd('0x40')](_0x17b5b3[_0x9edd('0x3c')],_0x17b5b3['query']);_0x219d8b[_0x9edd('0x41')]=_[_0x9edd('0x40')](_0x17b5b3[_0x9edd('0x3c')],qs[_0x9edd('0x42')](_0x423e1c[_0x9edd('0x3e')]['fields']));_0x219d8b[_0x9edd('0x41')]=_0x219d8b[_0x9edd('0x41')][_0x9edd('0x43')]?_0x219d8b[_0x9edd('0x41')]:_0x17b5b3[_0x9edd('0x3c')];_0x219d8b['order']=qs['sort'](_0x423e1c[_0x9edd('0x3e')][_0x9edd('0x46')]);_0x219d8b[_0x9edd('0x47')]=qs[_0x9edd('0x3f')](_[_0x9edd('0x48')](_0x423e1c['query'],_0x17b5b3[_0x9edd('0x3f')]));if(_0x423e1c[_0x9edd('0x3e')][_0x9edd('0x2d')]){_0x219d8b[_0x9edd('0x47')]=_[_0x9edd('0x49')](_0x219d8b[_0x9edd('0x47')],{'$or':_[_0x9edd('0x37')](_0x219d8b['attributes'],function(_0x5e6f1e){var _0x228418={};_0x228418[_0x5e6f1e]={'$like':'%'+_0x423e1c['query']['filter']+'%'};return _0x228418;})});}_0x219d8b=_[_0x9edd('0x49')]({},_0x219d8b,_0x423e1c[_0x9edd('0x4a')]);return _0x196359['getBlackLists'](_0x219d8b);}})['then'](function(_0x3dab89){if(_0x3dab89){_0x36faef=_0x3dab89[_0x9edd('0x43')];if(!_0x423e1c[_0x9edd('0x3e')]['hasOwnProperty'](_0x9edd('0x44'))){_0x219d8b[_0x9edd('0x22')]=qs[_0x9edd('0x22')](_0x423e1c['query'][_0x9edd('0x22')]);_0x219d8b[_0x9edd('0x45')]=qs['offset'](_0x423e1c[_0x9edd('0x3e')][_0x9edd('0x45')]);}return _0x196359['getBlackLists'](_0x219d8b);}})[_0x9edd('0x27')](function(_0x182f1b){if(_0x182f1b){return _0x182f1b?{'count':_0x36faef,'rows':_0x182f1b}:null;}})[_0x9edd('0x27')](respondWithResult(_0x4ab8d7,null))[_0x9edd('0x4f')](handleError(_0x4ab8d7,null));};exports[_0x9edd('0xb5')]=function(_0x108bd5,_0x10b638,_0x39b3b6){var _0x592771,_0x4b33c0;return db['VoiceQueue'][_0x9edd('0x30')]({'where':{'id':_0x108bd5[_0x9edd('0x5a')]['id']}})['then'](handleEntityNotFound(_0x10b638,null))[_0x9edd('0x27')](function(_0x5c3283){if(_0x5c3283){_0x4b33c0=_0x5c3283;return _0x5c3283[_0x9edd('0xb5')](_0x108bd5['body'][_0x9edd('0x8f')],_['omit'](_0x108bd5[_0x9edd('0x52')],[_0x9edd('0x8f'),'id'])||{});}return null;})['spread'](function(_0x28e39c){var _0x53df3c;_0x592771=_0x28e39c||[];var _0x10041e=[];if(_0x28e39c){for(var _0x1fa94d=0x0;_0x1fa94d<_0x28e39c['length'];_0x1fa94d+=0x1){var _0x3b66f3=_0x28e39c[_0x1fa94d]['get']({'plain':!![]});_0x53df3c=squel[_0x9edd('0x9f')]()[_0x9edd('0xa0')](_0x9edd('0xb6'))[_0x9edd('0xb0')]([_0x9edd('0xa2'),_0x9edd('0xa4'),'ListId',_0x9edd('0x64'),_0x9edd('0x5b'),_0x9edd('0x5c')],squel[_0x9edd('0x7d')]()[_0x9edd('0x7e')](_0x9edd('0xa2'),'phone')[_0x9edd('0x7e')]('id',_0x9edd('0xa4'))[_0x9edd('0x7e')](_0x3b66f3[_0x9edd('0xa9')]['toString'](),_0x9edd('0xa5'))[_0x9edd('0x7e')](_0x108bd5['params']['id'][_0x9edd('0x87')](),_0x9edd('0x64'))[_0x9edd('0x7e')](_0x9edd('0xa6'),_0x9edd('0x5b'))['field'](_0x9edd('0xa6'),_0x9edd('0x5c'))[_0x9edd('0xa7')](_0x9edd('0xb1'))[_0x9edd('0x47')](_0x9edd('0xb2'))[_0x9edd('0x47')](_0x9edd('0xa8'),_0x3b66f3['CmListId'][_0x9edd('0x87')]())[_0x9edd('0x47')]('phone\x20IS\x20NOT\x20NULL'))[_0x9edd('0x87')]();_0x10041e[_0x9edd('0x86')](db[_0x9edd('0x70')][_0x9edd('0x3e')](_0x53df3c));}return BPromise[_0x9edd('0x97')](_0x10041e);}})[_0x9edd('0x27')](function(){return _0x592771;})[_0x9edd('0x27')](respondWithResult(_0x10b638,null))[_0x9edd('0x4f')](handleError(_0x10b638,null));};exports[_0x9edd('0xb7')]=function(_0x38c183,_0x3cf8ae,_0x11f5f2){return db['VoiceQueue'][_0x9edd('0x30')]({'where':{'id':_0x38c183[_0x9edd('0x5a')]['id']}})[_0x9edd('0x27')](handleEntityNotFound(_0x3cf8ae,null))[_0x9edd('0x27')](function(_0x181243){if(_0x181243){return _0x181243[_0x9edd('0xb7')](_0x38c183['query'][_0x9edd('0x8f')]);}})[_0x9edd('0x27')](function(_0x1e1ab6){if(_0x1e1ab6){return db[_0x9edd('0x67')][_0x9edd('0x28')]({'where':{'ListId':_0x38c183[_0x9edd('0x3e')][_0x9edd('0x8f')],'VoiceQueueId':_0x38c183[_0x9edd('0x5a')]['id']}})[_0x9edd('0x27')](function(){return _0x1e1ab6;});}})[_0x9edd('0x27')](respondWithStatusCode(_0x3cf8ae,null))['catch'](handleError(_0x3cf8ae,null));};