Built motion from commit 753c950e.|2.5.42
[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 _0x9bfa=['undefined','limit','count','set','Content-Range','apply','reject','save','update','then','get','VoiceQueues','inbound','outbound','filter','ignore','value','includes','type','find','UserProfileResource','destroy','error','stack','name','send','rawAttributes','fieldName','model','map','query','filters','intersection','attributes','fields','hasOwnProperty','nolimit','order','sort','where','merge','includeAll','include','VoiceQueue','findAll','rows','catch','show','params','keys','length','options','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','user','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','createdAt','updatedAt','QueueCampaigns','findOne','CmHopper','VoiceQueueId','CmHopperHistory','pick','getHopperFinals','CmHopperFinal','getHopperBlacks','CmHopperBlack','getTeams','Team','Agents','online','voicePause','penalty','transaction','each','upsert','UserVoiceQueue','findOrCreate','UserVoiceQueueRt','isNil','format','SIP/%s','interface','emit','removeTeams','User','select','field','tq.TeamId','from','team_has_voice_queues','join','user_has_teams','ut.TeamId\x20=\x20tq.TeamId','toString','sequelize','every','TeamId','compact','ids','isEmpty','removeAgents','forEach','userVoiceQueue:remove','addAgents','omit','spread','userVoiceQueue:save','push','all','isArray','getAgents','getMembers','CmList','getLists','addLists','dialCheckDuplicateType','insert','into','cm_hopper','fromQuery','phone','scheduledAt','ContactId','NOW()','CmListId','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','COALESCE(calleridnum,\x27\x27)','VoiceQueueId\x20=\x20?','onlyIfOpen','ListId','cm_contacts','removeLists','getBlackLists','addBlackLists','cm_hopper_black','deletedAt\x20IS\x20NULL','removeBlackLists','eml-format','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','to-csv','ejs','fs-extra','lodash','squel','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','defaults','redis','localhost','./voiceQueue.socket','register','sendStatus','end','status','json','offset'];(function(_0x7e2eb0,_0x17cd58){var _0xd92de4=function(_0x5d005b){while(--_0x5d005b){_0x7e2eb0['push'](_0x7e2eb0['shift']());}};_0xd92de4(++_0x17cd58);}(_0x9bfa,0x93));var _0xa9bf=function(_0x47ef62,_0x2f36a3){_0x47ef62=_0x47ef62-0x0;var _0x229ab6=_0x9bfa[_0x47ef62];return _0x229ab6;};'use strict';var emlformat=require(_0xa9bf('0x0'));var rimraf=require('rimraf');var zipdir=require(_0xa9bf('0x1'));var jsonpatch=require(_0xa9bf('0x2'));var rp=require(_0xa9bf('0x3'));var moment=require(_0xa9bf('0x4'));var BPromise=require(_0xa9bf('0x5'));var Mustache=require(_0xa9bf('0x6'));var util=require(_0xa9bf('0x7'));var path=require(_0xa9bf('0x8'));var sox=require('sox');var csv=require(_0xa9bf('0x9'));var ejs=require(_0xa9bf('0xa'));var fs=require('fs');var fs_extra=require(_0xa9bf('0xb'));var _=require(_0xa9bf('0xc'));var squel=require(_0xa9bf('0xd'));var crypto=require('crypto');var jsforce=require(_0xa9bf('0xe'));var deskjs=require(_0xa9bf('0xf'));var toCsv=require(_0xa9bf('0x9'));var querystring=require(_0xa9bf('0x10'));var Papa=require(_0xa9bf('0x11'));var Redis=require(_0xa9bf('0x12'));var authService=require('../../components/auth/service');var qs=require(_0xa9bf('0x13'));var as=require(_0xa9bf('0x14'));var hardwareService=require(_0xa9bf('0x15'));var logger=require(_0xa9bf('0x16'))(_0xa9bf('0x17'));var utils=require(_0xa9bf('0x18'));var config=require(_0xa9bf('0x19'));var licenseUtil=require(_0xa9bf('0x1a'));var db=require(_0xa9bf('0x1b'))['db'];config['redis']=_[_0xa9bf('0x1c')](config[_0xa9bf('0x1d')],{'host':_0xa9bf('0x1e'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config['redis']));require(_0xa9bf('0x1f'))[_0xa9bf('0x20')](socket);function respondWithStatusCode(_0x2d0510,_0x492c8b){_0x492c8b=_0x492c8b||0xcc;return function(_0x33b9f7){if(_0x33b9f7){return _0x2d0510[_0xa9bf('0x21')](_0x492c8b);}return _0x2d0510['status'](_0x492c8b)[_0xa9bf('0x22')]();};}function respondWithResult(_0x2cd06b,_0x25c23c){_0x25c23c=_0x25c23c||0xc8;return function(_0x445b75){if(_0x445b75){return _0x2cd06b[_0xa9bf('0x23')](_0x25c23c)[_0xa9bf('0x24')](_0x445b75);}};}function respondWithFilteredResult(_0x277751,_0x4b6616){return function(_0x32c7bc){if(_0x32c7bc){var _0x1791df=typeof _0x4b6616[_0xa9bf('0x25')]===_0xa9bf('0x26')&&typeof _0x4b6616[_0xa9bf('0x27')]==='undefined';var _0x1e5ab4=_0x32c7bc[_0xa9bf('0x28')];var _0x1e3d71=_0x1791df?0x0:_0x4b6616[_0xa9bf('0x25')];var _0x490b03=_0x1791df?_0x32c7bc[_0xa9bf('0x28')]:_0x4b6616[_0xa9bf('0x25')]+_0x4b6616['limit'];var _0x2866d6;if(_0x490b03>=_0x1e5ab4){_0x490b03=_0x1e5ab4;_0x2866d6=0xc8;}else{_0x2866d6=0xce;}_0x277751[_0xa9bf('0x23')](_0x2866d6);return _0x277751[_0xa9bf('0x29')](_0xa9bf('0x2a'),_0x1e3d71+'-'+_0x490b03+'/'+_0x1e5ab4)[_0xa9bf('0x24')](_0x32c7bc);}return null;};}function patchUpdates(_0x5e36d2){return function(_0x235404){try{jsonpatch[_0xa9bf('0x2b')](_0x235404,_0x5e36d2,!![]);}catch(_0x4b4ecb){return BPromise[_0xa9bf('0x2c')](_0x4b4ecb);}return _0x235404[_0xa9bf('0x2d')]();};}function saveUpdates(_0x50f433,_0x3e0c79){return function(_0x32730d){if(_0x32730d){return _0x32730d[_0xa9bf('0x2e')](_0x50f433)[_0xa9bf('0x2f')](function(_0x308919){return _0x308919;});}return null;};}function removeEntity(_0x29e77f,_0x301438){return function(_0x507f9e){if(_0x507f9e){return _0x507f9e['destroy']()[_0xa9bf('0x2f')](function(){var _0x2dcd8d=_0x507f9e[_0xa9bf('0x30')]({'plain':!![]});var _0x2a04a2=[{'name':_0xa9bf('0x31'),'value':_0xa9bf('0x32'),'ignore':![]},{'name':'QueueCampaigns','value':_0xa9bf('0x33'),'ignore':![]}];var _0x4b0ab5=_(_0x2a04a2)[_0xa9bf('0x34')](_0xa9bf('0x35'))['map'](_0xa9bf('0x36'))[_0xa9bf('0x36')]();if(_[_0xa9bf('0x37')](_0x4b0ab5,_0x2dcd8d[_0xa9bf('0x38')])){return;}var _0x1626a4=_[_0xa9bf('0x39')](_0x2a04a2,[_0xa9bf('0x36'),_0x2dcd8d[_0xa9bf('0x38')]])['name'];return db[_0xa9bf('0x3a')][_0xa9bf('0x3b')]({'where':{'type':_0x1626a4,'resourceId':_0x2dcd8d['id']}})['then'](function(){return _0x507f9e;});})['then'](function(){_0x29e77f['status'](0xcc)[_0xa9bf('0x22')]();});}};}function handleEntityNotFound(_0x2deb73,_0x4f42e8){return function(_0x487d92){if(!_0x487d92){_0x2deb73[_0xa9bf('0x21')](0x194);}return _0x487d92;};}function handleError(_0x1be952,_0xab7f8d){_0xab7f8d=_0xab7f8d||0x1f4;return function(_0x5e89f5){logger[_0xa9bf('0x3c')](_0x5e89f5[_0xa9bf('0x3d')]);if(_0x5e89f5[_0xa9bf('0x3e')]){delete _0x5e89f5[_0xa9bf('0x3e')];}_0x1be952[_0xa9bf('0x23')](_0xab7f8d)[_0xa9bf('0x3f')](_0x5e89f5);};}exports['index']=function(_0x25670d,_0x3ec33d){var _0x19f4b={},_0x597f4f={},_0x325b95={'count':0x0,'rows':[]};var _0x42a6d0=_['map'](db['VoiceQueue'][_0xa9bf('0x40')],function(_0x41c7b6){return{'name':_0x41c7b6[_0xa9bf('0x41')],'type':_0x41c7b6[_0xa9bf('0x38')]['key']};});_0x597f4f[_0xa9bf('0x42')]=_[_0xa9bf('0x43')](_0x42a6d0,_0xa9bf('0x3e'));_0x597f4f['query']=_['keys'](_0x25670d[_0xa9bf('0x44')]);_0x597f4f[_0xa9bf('0x45')]=_[_0xa9bf('0x46')](_0x597f4f[_0xa9bf('0x42')],_0x597f4f[_0xa9bf('0x44')]);_0x19f4b[_0xa9bf('0x47')]=_[_0xa9bf('0x46')](_0x597f4f[_0xa9bf('0x42')],qs[_0xa9bf('0x48')](_0x25670d[_0xa9bf('0x44')]['fields']));_0x19f4b[_0xa9bf('0x47')]=_0x19f4b[_0xa9bf('0x47')]['length']?_0x19f4b['attributes']:_0x597f4f[_0xa9bf('0x42')];if(!_0x25670d[_0xa9bf('0x44')][_0xa9bf('0x49')](_0xa9bf('0x4a'))){_0x19f4b[_0xa9bf('0x27')]=qs[_0xa9bf('0x27')](_0x25670d[_0xa9bf('0x44')][_0xa9bf('0x27')]);_0x19f4b['offset']=qs[_0xa9bf('0x25')](_0x25670d['query'][_0xa9bf('0x25')]);}_0x19f4b[_0xa9bf('0x4b')]=qs[_0xa9bf('0x4c')](_0x25670d[_0xa9bf('0x44')]['sort']);_0x19f4b[_0xa9bf('0x4d')]=qs[_0xa9bf('0x45')](_['pick'](_0x25670d[_0xa9bf('0x44')],_0x597f4f[_0xa9bf('0x45')]),_0x42a6d0);if(_0x25670d[_0xa9bf('0x44')][_0xa9bf('0x34')]){_0x19f4b[_0xa9bf('0x4d')]=_['merge'](_0x19f4b[_0xa9bf('0x4d')],{'$or':_[_0xa9bf('0x43')](_0x42a6d0,function(_0x112277){if(_0x112277['type']!=='VIRTUAL'){var _0x54dbc2={};_0x54dbc2[_0x112277['name']]={'$like':'%'+_0x25670d[_0xa9bf('0x44')]['filter']+'%'};return _0x54dbc2;}})});}_0x19f4b=_[_0xa9bf('0x4e')]({},_0x19f4b,_0x25670d['options']);var _0x3902d6={'where':_0x19f4b['where']};return db['VoiceQueue'][_0xa9bf('0x28')](_0x3902d6)['then'](function(_0x531787){_0x325b95['count']=_0x531787;if(_0x25670d[_0xa9bf('0x44')][_0xa9bf('0x4f')]){_0x19f4b[_0xa9bf('0x50')]=[{'all':!![]}];}return db[_0xa9bf('0x51')][_0xa9bf('0x52')](_0x19f4b);})[_0xa9bf('0x2f')](function(_0x489a1c){_0x325b95[_0xa9bf('0x53')]=_0x489a1c;return _0x325b95;})['then'](respondWithFilteredResult(_0x3ec33d,_0x19f4b))[_0xa9bf('0x54')](handleError(_0x3ec33d,null));};exports[_0xa9bf('0x55')]=function(_0x3f5980,_0x2e9371){var _0x2789f1={'raw':![],'where':{'id':_0x3f5980[_0xa9bf('0x56')]['id']}},_0x595b38={};_0x595b38[_0xa9bf('0x42')]=_['keys'](db['VoiceQueue'][_0xa9bf('0x40')]);_0x595b38[_0xa9bf('0x44')]=_[_0xa9bf('0x57')](_0x3f5980[_0xa9bf('0x44')]);_0x595b38[_0xa9bf('0x45')]=_[_0xa9bf('0x46')](_0x595b38['model'],_0x595b38[_0xa9bf('0x44')]);_0x2789f1['attributes']=_[_0xa9bf('0x46')](_0x595b38[_0xa9bf('0x42')],qs[_0xa9bf('0x48')](_0x3f5980[_0xa9bf('0x44')][_0xa9bf('0x48')]));_0x2789f1[_0xa9bf('0x47')]=_0x2789f1[_0xa9bf('0x47')][_0xa9bf('0x58')]?_0x2789f1['attributes']:_0x595b38[_0xa9bf('0x42')];if(_0x3f5980['query']['includeAll']){_0x2789f1[_0xa9bf('0x50')]=[{'all':!![]}];}_0x2789f1=_[_0xa9bf('0x4e')]({},_0x2789f1,_0x3f5980[_0xa9bf('0x59')]);return db[_0xa9bf('0x51')]['find'](_0x2789f1)[_0xa9bf('0x2f')](handleEntityNotFound(_0x2e9371,null))['then'](respondWithResult(_0x2e9371,null))['catch'](handleError(_0x2e9371,null));};exports[_0xa9bf('0x5a')]=function(_0x2eadf4,_0xb0b37){return db[_0xa9bf('0x51')][_0xa9bf('0x5a')](_0x2eadf4[_0xa9bf('0x5b')],{})[_0xa9bf('0x2f')](function(_0x38636f){var _0x2364a5=_0x2eadf4['user'][_0xa9bf('0x30')]({'plain':!![]});if(!_0x2364a5)throw new Error(_0xa9bf('0x5c'));if(_0x2364a5[_0xa9bf('0x5d')]===_0xa9bf('0x5e')){var _0x12ba63=_0x38636f[_0xa9bf('0x30')]({'plain':!![]});var _0x466850=[{'name':_0xa9bf('0x31'),'value':'inbound'},{'name':'QueueCampaigns','value':_0xa9bf('0x33')}];var _0x5277ee=_[_0xa9bf('0x39')](_0x466850,['value',_0x12ba63[_0xa9bf('0x38')]])[_0xa9bf('0x3e')];return db[_0xa9bf('0x5f')][_0xa9bf('0x39')]({'where':{'name':_0x5277ee,'userProfileId':_0x2364a5[_0xa9bf('0x60')]},'raw':!![]})['then'](function(_0x3e2557){if(_0x3e2557&&_0x3e2557[_0xa9bf('0x61')]===0x0){return db['UserProfileResource'][_0xa9bf('0x5a')]({'name':_0x12ba63[_0xa9bf('0x3e')],'resourceId':_0x12ba63['id'],'type':_0x3e2557[_0xa9bf('0x3e')],'sectionId':_0x3e2557['id']},{})[_0xa9bf('0x2f')](function(){return _0x38636f;});}else{return _0x38636f;}})['catch'](function(_0x82176f){logger[_0xa9bf('0x3c')](_0xa9bf('0x62'),_0x82176f);throw _0x82176f;});}return _0x38636f;})['then'](respondWithResult(_0xb0b37,0xc9))[_0xa9bf('0x54')](handleError(_0xb0b37,null));};exports[_0xa9bf('0x63')]=function(_0x21b02d,_0x537c48){var _0x539df6={'where':{'id':_0x21b02d['params']['id']}},_0x5604ac={};_0x5604ac[_0xa9bf('0x42')]=_[_0xa9bf('0x57')](db[_0xa9bf('0x51')][_0xa9bf('0x40')]);_0x539df6[_0xa9bf('0x47')]=_[_0xa9bf('0x46')](_0x5604ac['model'],qs['fields'](_0x21b02d[_0xa9bf('0x44')]['fields']));_0x539df6[_0xa9bf('0x47')]=_0x539df6[_0xa9bf('0x47')][_0xa9bf('0x58')]?_0x539df6['attributes']:_0x5604ac['model'];if(_0x21b02d['query'][_0xa9bf('0x4f')]){_0x539df6['include']=[{'all':!![]}];}_0x539df6=_[_0xa9bf('0x4e')]({},_0x539df6,_0x21b02d[_0xa9bf('0x59')]);return db['VoiceQueue'][_0xa9bf('0x39')](_0x539df6)['then'](handleEntityNotFound(_0x537c48,null))[_0xa9bf('0x2f')](function(_0x585a28){if(_0x585a28){var _0x52189e=_0x585a28[_0xa9bf('0x30')]({'plain':!![]});_0x52189e=qs['omit'](_0x52189e,['id',_0xa9bf('0x64'),_0xa9bf('0x65')]);_0x21b02d[_0xa9bf('0x5b')]=_['omit'](_0x21b02d[_0xa9bf('0x5b')],['id','createdAt',_0xa9bf('0x65')]);return db['VoiceQueue'][_0xa9bf('0x5a')](_['merge'](_0x52189e,_0x21b02d[_0xa9bf('0x5b')]),{'include':_0x21b02d[_0xa9bf('0x44')][_0xa9bf('0x4f')]?[{'all':!![]}]:undefined})[_0xa9bf('0x2f')](function(_0x560eb7){var _0x3b1ab5=_0x21b02d[_0xa9bf('0x5e')][_0xa9bf('0x30')]({'plain':!![]});if(!_0x3b1ab5)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x3b1ab5[_0xa9bf('0x5d')]===_0xa9bf('0x5e')){var _0x343e79=_0x560eb7[_0xa9bf('0x30')]({'plain':!![]});var _0x4a1e61=[{'name':'VoiceQueues','value':_0xa9bf('0x32')},{'name':_0xa9bf('0x66'),'value':_0xa9bf('0x33')}];var _0x5e42c9=_[_0xa9bf('0x39')](_0x4a1e61,[_0xa9bf('0x36'),_0x343e79['type']])['name'];return db[_0xa9bf('0x5f')][_0xa9bf('0x39')]({'where':{'name':_0x5e42c9,'userProfileId':_0x3b1ab5[_0xa9bf('0x60')]},'raw':!![]})[_0xa9bf('0x2f')](function(_0x32b41e){if(_0x32b41e&&_0x32b41e[_0xa9bf('0x61')]===0x0){return db[_0xa9bf('0x3a')]['create']({'name':_0x343e79[_0xa9bf('0x3e')],'resourceId':_0x343e79['id'],'type':_0x32b41e['name'],'sectionId':_0x32b41e['id']},{})['then'](function(){return _0x560eb7;});}else{return _0x560eb7;}})['catch'](function(_0x2167c9){logger['error'](_0xa9bf('0x62'),_0x2167c9);throw _0x2167c9;});}return _0x560eb7;});}})[_0xa9bf('0x2f')](respondWithResult(_0x537c48,0xc9))[_0xa9bf('0x54')](handleError(_0x537c48,null));};exports[_0xa9bf('0x2e')]=function(_0x352439,_0x2739c6){if(_0x352439['body']['id']){delete _0x352439[_0xa9bf('0x5b')]['id'];}return db[_0xa9bf('0x51')]['find']({'where':{'id':_0x352439[_0xa9bf('0x56')]['id']}})['then'](handleEntityNotFound(_0x2739c6,null))[_0xa9bf('0x2f')](saveUpdates(_0x352439[_0xa9bf('0x5b')],null))[_0xa9bf('0x2f')](respondWithResult(_0x2739c6,null))[_0xa9bf('0x54')](handleError(_0x2739c6,null));};exports[_0xa9bf('0x3b')]=function(_0x3c20f4,_0x387f0d){return db[_0xa9bf('0x51')]['find']({'where':{'id':_0x3c20f4[_0xa9bf('0x56')]['id']}})[_0xa9bf('0x2f')](handleEntityNotFound(_0x387f0d,null))['then'](removeEntity(_0x387f0d,null))[_0xa9bf('0x54')](handleError(_0x387f0d,null));};exports['getHoppers']=function(_0x4279fe,_0x3b4ae3,_0x15f635){var _0x74cfd={'raw':![],'where':{}};var _0x1f79e9={};var _0x39d22e={'count':0x0,'rows':[]};return db['VoiceQueue'][_0xa9bf('0x67')]({'where':{'id':_0x4279fe[_0xa9bf('0x56')]['id']}})[_0xa9bf('0x2f')](handleEntityNotFound(_0x3b4ae3,null))['then'](function(_0x5152c6){if(_0x5152c6){_0x1f79e9[_0xa9bf('0x42')]=_[_0xa9bf('0x57')](db[_0xa9bf('0x68')][_0xa9bf('0x40')]);_0x1f79e9[_0xa9bf('0x44')]=_[_0xa9bf('0x57')](_0x4279fe['query']);_0x1f79e9[_0xa9bf('0x45')]=_['intersection'](_0x1f79e9[_0xa9bf('0x42')],_0x1f79e9[_0xa9bf('0x44')]);_0x74cfd['attributes']=_[_0xa9bf('0x46')](_0x1f79e9['model'],qs['fields'](_0x4279fe['query']['fields']));_0x74cfd['attributes']=_0x74cfd[_0xa9bf('0x47')]['length']?_0x74cfd[_0xa9bf('0x47')]:_0x1f79e9['model'];if(!_0x4279fe[_0xa9bf('0x44')]['hasOwnProperty'](_0xa9bf('0x4a'))){_0x74cfd[_0xa9bf('0x27')]=qs[_0xa9bf('0x27')](_0x4279fe[_0xa9bf('0x44')]['limit']);_0x74cfd[_0xa9bf('0x25')]=qs[_0xa9bf('0x25')](_0x4279fe[_0xa9bf('0x44')][_0xa9bf('0x25')]);}_0x74cfd['order']=qs[_0xa9bf('0x4c')](_0x4279fe[_0xa9bf('0x44')][_0xa9bf('0x4c')]);_0x74cfd[_0xa9bf('0x4d')]=qs[_0xa9bf('0x45')](_['pick'](_0x4279fe[_0xa9bf('0x44')],_0x1f79e9[_0xa9bf('0x45')]));_0x74cfd[_0xa9bf('0x4d')][_0xa9bf('0x69')]=_0x5152c6['id'];if(_0x4279fe[_0xa9bf('0x44')][_0xa9bf('0x34')]){_0x74cfd[_0xa9bf('0x4d')]=_['merge'](_0x74cfd[_0xa9bf('0x4d')],{'$or':_[_0xa9bf('0x43')](_0x74cfd['attributes'],function(_0x4fb793){var _0x3d6c69={};_0x3d6c69[_0x4fb793]={'$like':'%'+_0x4279fe[_0xa9bf('0x44')][_0xa9bf('0x34')]+'%'};return _0x3d6c69;})});}_0x74cfd=_[_0xa9bf('0x4e')]({},_0x74cfd,_0x4279fe[_0xa9bf('0x59')]);return db[_0xa9bf('0x68')][_0xa9bf('0x28')]({'where':_0x74cfd['where']})[_0xa9bf('0x2f')](function(_0x5dcc4c){_0x39d22e[_0xa9bf('0x28')]=_0x5dcc4c;if(_0x4279fe[_0xa9bf('0x44')][_0xa9bf('0x4f')]){_0x74cfd[_0xa9bf('0x50')]=[{'all':!![]}];}return db['CmHopper'][_0xa9bf('0x52')](_0x74cfd);})[_0xa9bf('0x2f')](function(_0x3f8fa8){_0x39d22e[_0xa9bf('0x53')]=_0x3f8fa8;return _0x39d22e;});}})['then'](respondWithFilteredResult(_0x3b4ae3,_0x74cfd))[_0xa9bf('0x54')](handleError(_0x3b4ae3,null));};exports['getHopperHistories']=function(_0x8a8ac8,_0x303468,_0x50414a){var _0x3a11e1={'raw':!![],'where':{}};var _0x2823d3={};var _0x2ce2dc={'count':0x0,'rows':[]};return db[_0xa9bf('0x51')][_0xa9bf('0x67')]({'where':{'id':_0x8a8ac8['params']['id']}})[_0xa9bf('0x2f')](handleEntityNotFound(_0x303468,null))['then'](function(_0x3fdb8a){if(_0x3fdb8a){_0x2823d3[_0xa9bf('0x42')]=_[_0xa9bf('0x57')](db[_0xa9bf('0x6a')][_0xa9bf('0x40')]);_0x2823d3[_0xa9bf('0x44')]=_[_0xa9bf('0x57')](_0x8a8ac8[_0xa9bf('0x44')]);_0x2823d3[_0xa9bf('0x45')]=_[_0xa9bf('0x46')](_0x2823d3[_0xa9bf('0x42')],_0x2823d3[_0xa9bf('0x44')]);_0x3a11e1[_0xa9bf('0x47')]=_['intersection'](_0x2823d3[_0xa9bf('0x42')],qs[_0xa9bf('0x48')](_0x8a8ac8[_0xa9bf('0x44')][_0xa9bf('0x48')]));_0x3a11e1[_0xa9bf('0x47')]=_0x3a11e1[_0xa9bf('0x47')][_0xa9bf('0x58')]?_0x3a11e1[_0xa9bf('0x47')]:_0x2823d3[_0xa9bf('0x42')];if(!_0x8a8ac8[_0xa9bf('0x44')][_0xa9bf('0x49')](_0xa9bf('0x4a'))){_0x3a11e1['limit']=qs[_0xa9bf('0x27')](_0x8a8ac8[_0xa9bf('0x44')][_0xa9bf('0x27')]);_0x3a11e1[_0xa9bf('0x25')]=qs['offset'](_0x8a8ac8[_0xa9bf('0x44')][_0xa9bf('0x25')]);}_0x3a11e1[_0xa9bf('0x4b')]=qs['sort'](_0x8a8ac8[_0xa9bf('0x44')][_0xa9bf('0x4c')]);_0x3a11e1[_0xa9bf('0x4d')]=qs[_0xa9bf('0x45')](_[_0xa9bf('0x6b')](_0x8a8ac8['query'],_0x2823d3['filters']));_0x3a11e1[_0xa9bf('0x4d')][_0xa9bf('0x69')]=_0x3fdb8a['id'];if(_0x8a8ac8[_0xa9bf('0x44')][_0xa9bf('0x34')]){_0x3a11e1[_0xa9bf('0x4d')]=_[_0xa9bf('0x4e')](_0x3a11e1['where'],{'$or':_[_0xa9bf('0x43')](_0x3a11e1[_0xa9bf('0x47')],function(_0x7c90d6){var _0x984dd8={};_0x984dd8[_0x7c90d6]={'$like':'%'+_0x8a8ac8[_0xa9bf('0x44')][_0xa9bf('0x34')]+'%'};return _0x984dd8;})});}_0x3a11e1=_[_0xa9bf('0x4e')]({},_0x3a11e1,_0x8a8ac8[_0xa9bf('0x59')]);return db[_0xa9bf('0x6a')][_0xa9bf('0x28')]({'where':_0x3a11e1[_0xa9bf('0x4d')]})[_0xa9bf('0x2f')](function(_0x508a30){_0x2ce2dc[_0xa9bf('0x28')]=_0x508a30;if(_0x8a8ac8[_0xa9bf('0x44')][_0xa9bf('0x4f')]){_0x3a11e1[_0xa9bf('0x50')]=[{'all':!![]}];}return db[_0xa9bf('0x6a')][_0xa9bf('0x52')](_0x3a11e1);})[_0xa9bf('0x2f')](function(_0x11b6f3){_0x2ce2dc[_0xa9bf('0x53')]=_0x11b6f3;return _0x2ce2dc;});}})[_0xa9bf('0x2f')](respondWithFilteredResult(_0x303468,_0x3a11e1))[_0xa9bf('0x54')](handleError(_0x303468,null));};exports[_0xa9bf('0x6c')]=function(_0x54ae13,_0x3ccf20,_0xc6b3d7){var _0x342112={'raw':!![],'where':{}};var _0x28494a={};var _0x45f839={'count':0x0,'rows':[]};return db[_0xa9bf('0x51')][_0xa9bf('0x67')]({'where':{'id':_0x54ae13[_0xa9bf('0x56')]['id']}})[_0xa9bf('0x2f')](handleEntityNotFound(_0x3ccf20,null))[_0xa9bf('0x2f')](function(_0x10ec47){if(_0x10ec47){_0x28494a[_0xa9bf('0x42')]=_[_0xa9bf('0x57')](db[_0xa9bf('0x6d')][_0xa9bf('0x40')]);_0x28494a['query']=_[_0xa9bf('0x57')](_0x54ae13[_0xa9bf('0x44')]);_0x28494a[_0xa9bf('0x45')]=_[_0xa9bf('0x46')](_0x28494a[_0xa9bf('0x42')],_0x28494a[_0xa9bf('0x44')]);_0x342112[_0xa9bf('0x47')]=_[_0xa9bf('0x46')](_0x28494a[_0xa9bf('0x42')],qs[_0xa9bf('0x48')](_0x54ae13[_0xa9bf('0x44')][_0xa9bf('0x48')]));_0x342112['attributes']=_0x342112[_0xa9bf('0x47')][_0xa9bf('0x58')]?_0x342112[_0xa9bf('0x47')]:_0x28494a[_0xa9bf('0x42')];if(!_0x54ae13[_0xa9bf('0x44')][_0xa9bf('0x49')](_0xa9bf('0x4a'))){_0x342112[_0xa9bf('0x27')]=qs['limit'](_0x54ae13[_0xa9bf('0x44')][_0xa9bf('0x27')]);_0x342112[_0xa9bf('0x25')]=qs['offset'](_0x54ae13[_0xa9bf('0x44')][_0xa9bf('0x25')]);}_0x342112[_0xa9bf('0x4b')]=qs[_0xa9bf('0x4c')](_0x54ae13['query'][_0xa9bf('0x4c')]);_0x342112[_0xa9bf('0x4d')]=qs[_0xa9bf('0x45')](_[_0xa9bf('0x6b')](_0x54ae13[_0xa9bf('0x44')],_0x28494a[_0xa9bf('0x45')]));_0x342112[_0xa9bf('0x4d')][_0xa9bf('0x69')]=_0x10ec47['id'];if(_0x54ae13[_0xa9bf('0x44')]['filter']){_0x342112[_0xa9bf('0x4d')]=_[_0xa9bf('0x4e')](_0x342112[_0xa9bf('0x4d')],{'$or':_['map'](_0x342112['attributes'],function(_0xe252fc){var _0x3f9847={};_0x3f9847[_0xe252fc]={'$like':'%'+_0x54ae13[_0xa9bf('0x44')][_0xa9bf('0x34')]+'%'};return _0x3f9847;})});}_0x342112=_[_0xa9bf('0x4e')]({},_0x342112,_0x54ae13[_0xa9bf('0x59')]);return db[_0xa9bf('0x6d')][_0xa9bf('0x28')]({'where':_0x342112[_0xa9bf('0x4d')]})['then'](function(_0x20443f){_0x45f839[_0xa9bf('0x28')]=_0x20443f;if(_0x54ae13['query'][_0xa9bf('0x4f')]){_0x342112['include']=[{'all':!![]}];}return db[_0xa9bf('0x6d')][_0xa9bf('0x52')](_0x342112);})[_0xa9bf('0x2f')](function(_0x49516d){_0x45f839[_0xa9bf('0x53')]=_0x49516d;return _0x45f839;});}})[_0xa9bf('0x2f')](respondWithFilteredResult(_0x3ccf20,_0x342112))[_0xa9bf('0x54')](handleError(_0x3ccf20,null));};exports[_0xa9bf('0x6e')]=function(_0x89648d,_0x43df3b,_0x2fee9e){var _0x58ef53={'raw':!![],'where':{}};var _0x545a94={};var _0x49965b={'count':0x0,'rows':[]};return db['VoiceQueue'][_0xa9bf('0x67')]({'where':{'id':_0x89648d['params']['id']}})[_0xa9bf('0x2f')](handleEntityNotFound(_0x43df3b,null))[_0xa9bf('0x2f')](function(_0x5c524b){if(_0x5c524b){_0x545a94[_0xa9bf('0x42')]=_[_0xa9bf('0x57')](db[_0xa9bf('0x6f')]['rawAttributes']);_0x545a94[_0xa9bf('0x44')]=_['keys'](_0x89648d[_0xa9bf('0x44')]);_0x545a94['filters']=_[_0xa9bf('0x46')](_0x545a94[_0xa9bf('0x42')],_0x545a94[_0xa9bf('0x44')]);_0x58ef53[_0xa9bf('0x47')]=_[_0xa9bf('0x46')](_0x545a94[_0xa9bf('0x42')],qs[_0xa9bf('0x48')](_0x89648d[_0xa9bf('0x44')][_0xa9bf('0x48')]));_0x58ef53['attributes']=_0x58ef53['attributes'][_0xa9bf('0x58')]?_0x58ef53[_0xa9bf('0x47')]:_0x545a94[_0xa9bf('0x42')];if(!_0x89648d[_0xa9bf('0x44')][_0xa9bf('0x49')](_0xa9bf('0x4a'))){_0x58ef53[_0xa9bf('0x27')]=qs[_0xa9bf('0x27')](_0x89648d['query'][_0xa9bf('0x27')]);_0x58ef53[_0xa9bf('0x25')]=qs['offset'](_0x89648d['query'][_0xa9bf('0x25')]);}_0x58ef53[_0xa9bf('0x4b')]=qs[_0xa9bf('0x4c')](_0x89648d['query'][_0xa9bf('0x4c')]);_0x58ef53[_0xa9bf('0x4d')]=qs[_0xa9bf('0x45')](_['pick'](_0x89648d['query'],_0x545a94['filters']));_0x58ef53['where'][_0xa9bf('0x69')]=_0x5c524b['id'];if(_0x89648d[_0xa9bf('0x44')][_0xa9bf('0x34')]){_0x58ef53[_0xa9bf('0x4d')]=_[_0xa9bf('0x4e')](_0x58ef53[_0xa9bf('0x4d')],{'$or':_[_0xa9bf('0x43')](_0x58ef53[_0xa9bf('0x47')],function(_0x1e56a8){var _0x1d5819={};_0x1d5819[_0x1e56a8]={'$like':'%'+_0x89648d[_0xa9bf('0x44')]['filter']+'%'};return _0x1d5819;})});}_0x58ef53=_['merge']({},_0x58ef53,_0x89648d[_0xa9bf('0x59')]);return db[_0xa9bf('0x6f')][_0xa9bf('0x28')]({'where':_0x58ef53[_0xa9bf('0x4d')]})[_0xa9bf('0x2f')](function(_0x4e5030){_0x49965b['count']=_0x4e5030;if(_0x89648d[_0xa9bf('0x44')]['includeAll']){_0x58ef53[_0xa9bf('0x50')]=[{'all':!![]}];}return db[_0xa9bf('0x6f')][_0xa9bf('0x52')](_0x58ef53);})[_0xa9bf('0x2f')](function(_0x12b106){_0x49965b['rows']=_0x12b106;return _0x49965b;});}})[_0xa9bf('0x2f')](respondWithFilteredResult(_0x43df3b,_0x58ef53))[_0xa9bf('0x54')](handleError(_0x43df3b,null));};exports['getTeams']=function(_0x237988,_0x32b410,_0x3c88bc){var _0x533500={};var _0x52996a={};var _0x5f17ac;var _0x15df01;return db[_0xa9bf('0x51')][_0xa9bf('0x67')]({'where':{'id':_0x237988[_0xa9bf('0x56')]['id']}})[_0xa9bf('0x2f')](handleEntityNotFound(_0x32b410,null))['then'](function(_0xd54fb6){if(_0xd54fb6){_0x5f17ac=_0xd54fb6;_0x52996a[_0xa9bf('0x42')]=_[_0xa9bf('0x57')](db['Team']['rawAttributes']);_0x52996a[_0xa9bf('0x44')]=_[_0xa9bf('0x57')](_0x237988[_0xa9bf('0x44')]);_0x52996a[_0xa9bf('0x45')]=_[_0xa9bf('0x46')](_0x52996a[_0xa9bf('0x42')],_0x52996a[_0xa9bf('0x44')]);_0x533500['attributes']=_[_0xa9bf('0x46')](_0x52996a['model'],qs[_0xa9bf('0x48')](_0x237988[_0xa9bf('0x44')][_0xa9bf('0x48')]));_0x533500['attributes']=_0x533500['attributes'][_0xa9bf('0x58')]?_0x533500[_0xa9bf('0x47')]:_0x52996a[_0xa9bf('0x42')];_0x533500[_0xa9bf('0x4b')]=qs['sort'](_0x237988['query'][_0xa9bf('0x4c')]);_0x533500[_0xa9bf('0x4d')]=qs[_0xa9bf('0x45')](_[_0xa9bf('0x6b')](_0x237988[_0xa9bf('0x44')],_0x52996a['filters']));if(_0x237988['query'][_0xa9bf('0x34')]){_0x533500[_0xa9bf('0x4d')]=_[_0xa9bf('0x4e')](_0x533500['where'],{'$or':_[_0xa9bf('0x43')](_0x533500['attributes'],function(_0x4f292a){var _0x2e7287={};_0x2e7287[_0x4f292a]={'$like':'%'+_0x237988[_0xa9bf('0x44')][_0xa9bf('0x34')]+'%'};return _0x2e7287;})});}_0x533500=_[_0xa9bf('0x4e')]({},_0x533500,_0x237988[_0xa9bf('0x59')]);return _0x5f17ac[_0xa9bf('0x70')](_0x533500);}})['then'](function(_0x3b1716){if(_0x3b1716){_0x15df01=_0x3b1716['length'];if(!_0x237988['query'][_0xa9bf('0x49')](_0xa9bf('0x4a'))){_0x533500[_0xa9bf('0x27')]=qs[_0xa9bf('0x27')](_0x237988[_0xa9bf('0x44')]['limit']);_0x533500[_0xa9bf('0x25')]=qs[_0xa9bf('0x25')](_0x237988[_0xa9bf('0x44')][_0xa9bf('0x25')]);}return _0x5f17ac[_0xa9bf('0x70')](_0x533500);}})['then'](function(_0x38d687){if(_0x38d687){return _0x38d687?{'count':_0x15df01,'rows':_0x38d687}:null;}})[_0xa9bf('0x2f')](respondWithResult(_0x32b410,null))[_0xa9bf('0x54')](handleError(_0x32b410,null));};exports['addTeams']=function(_0x59adcf,_0x465b2d,_0x38f11b){var _0x5fd560=_0x59adcf[_0xa9bf('0x5b')]['teams'];var _0x2f2b69=_[_0xa9bf('0x43')](_0x5fd560,'id');return db[_0xa9bf('0x71')]['findAll']({'where':{'id':_0x2f2b69},'attributes':['id'],'include':[{'model':db['User'],'as':_0xa9bf('0x72'),'attributes':['id',_0xa9bf('0x3e'),_0xa9bf('0x73'),_0xa9bf('0x74'),'interface'],'raw':!![]}]})['then'](function(_0x4efdaf){if(_0x4efdaf){var _0x22d1d8=_['flatMap'](_0x4efdaf,function(_0x31475b){var _0x2ca05c=_0x31475b[_0xa9bf('0x30')]({'plain':!![]});_0x2ca05c['Agents']['forEach'](function(_0x292671){_0x292671[_0xa9bf('0x75')]=_['find'](_0x5fd560,{'id':_0x2ca05c['id']})[_0xa9bf('0x75')];});return _0x2ca05c[_0xa9bf('0x72')];});return db[_0xa9bf('0x51')][_0xa9bf('0x39')]({'where':{'id':_0x59adcf['params']['id']}})[_0xa9bf('0x2f')](function(_0x19e499){return db['sequelize'][_0xa9bf('0x76')](function(_0x181a98){return _0x19e499['addTeams'](_0x2f2b69,{'transaction':_0x181a98})['then'](function(){return BPromise[_0xa9bf('0x77')](_0x5fd560,function(_0x496220){return db['TeamVoiceQueue'][_0xa9bf('0x78')]({'TeamId':_0x496220['id'],'VoiceQueueId':_0x59adcf[_0xa9bf('0x56')]['id'],'penalty':_0x496220[_0xa9bf('0x75')]},{'transaction':_0x181a98});});})[_0xa9bf('0x2f')](function(){return BPromise[_0xa9bf('0x77')](_0x22d1d8,function(_0x417b98){return db[_0xa9bf('0x79')][_0xa9bf('0x7a')]({'where':{'UserId':_0x417b98['id'],'VoiceQueueId':_0x59adcf['params']['id']},'defaults':{'penalty':_0x417b98[_0xa9bf('0x75')]},'transaction':_0x181a98});});})[_0xa9bf('0x2f')](function(){return BPromise[_0xa9bf('0x77')](_[_0xa9bf('0x34')](_0x22d1d8,{'online':!![]}),function(_0x2db787){return db[_0xa9bf('0x7b')][_0xa9bf('0x78')]({'membername':_0x2db787[_0xa9bf('0x3e')],'UserId':_0x2db787['id'],'queue_name':_0x19e499[_0xa9bf('0x3e')],'VoiceQueueId':_0x19e499['id'],'interface':_[_0xa9bf('0x7c')](_0x2db787['interface'])?util[_0xa9bf('0x7d')](_0xa9bf('0x7e'),_0x2db787['name']):_0x2db787[_0xa9bf('0x7f')],'paused':_0x2db787[_0xa9bf('0x74')]||![],'penalty':_0x2db787['penalty']},{'transaction':_0x181a98});});})[_0xa9bf('0x2f')](function(){_0x22d1d8['forEach'](function(_0x33cee8){socket[_0xa9bf('0x80')]('userVoiceQueue:save',{'UserId':_0x33cee8['id'],'VoiceQueueId':_0x19e499['id']});});});});});}})['then'](respondWithStatusCode(_0x465b2d,null))[_0xa9bf('0x54')](handleError(_0x465b2d,null));};exports[_0xa9bf('0x81')]=function(_0x12ab03,_0x3f2697,_0x18a414){return db['Team'][_0xa9bf('0x52')]({'where':{'id':_0x12ab03[_0xa9bf('0x44')]['ids']},'attributes':['id'],'include':[{'model':db[_0xa9bf('0x82')],'as':_0xa9bf('0x72'),'attributes':['id'],'raw':!![]}]})[_0xa9bf('0x2f')](handleEntityNotFound(_0x3f2697,null))[_0xa9bf('0x2f')](function(_0xd28589){var _0x43fbca=_['map'](_0xd28589,'id');var _0x25b2dc=[];var _0x2343aa=[];var _0x132457=squel[_0xa9bf('0x83')]();_0x132457[_0xa9bf('0x84')](_0xa9bf('0x85'))[_0xa9bf('0x86')](_0xa9bf('0x87'),'tq')[_0xa9bf('0x88')](_0xa9bf('0x89'),'ut',_0xa9bf('0x8a'))[_0xa9bf('0x4d')]('VoiceQueueId\x20=\x20?',_0x12ab03[_0xa9bf('0x56')]['id']);for(var _0x14ad30=0x0;_0x14ad30<_0xd28589['length'];_0x14ad30+=0x1){let _0x5b0429=_0xd28589[_0x14ad30];for(var _0x244cc0=0x0;_0x244cc0<_0x5b0429[_0xa9bf('0x72')][_0xa9bf('0x58')];_0x244cc0+=0x1){let _0x2510b7=_0x5b0429['Agents'][_0x244cc0];var _0x4672f9=_0x132457[_0xa9bf('0x63')]();_0x4672f9[_0xa9bf('0x4d')]('ut.UserId\x20=\x20?',_0x2510b7['id']);_0x2343aa['push'](db['sequelize'][_0xa9bf('0x44')](_0x4672f9[_0xa9bf('0x8b')](),{'type':db[_0xa9bf('0x8c')]['QueryTypes']['SELECT']})['then'](function(_0x131363){if(_0x131363[_0xa9bf('0x58')]===0x1){return _0x2510b7['id'];}else{var _0x3bda45=_[_0xa9bf('0x8d')](_[_0xa9bf('0x43')](_0x131363,_0xa9bf('0x8e')),function(_0x5f4c9c){return _[_0xa9bf('0x37')](_0x43fbca,_0x5f4c9c);});if(_0x3bda45){return _0x2510b7['id'];}}}));}}return BPromise['all'](_0x2343aa)[_0xa9bf('0x2f')](function(_0x5b4f7b){_0x25b2dc=_(_0x25b2dc)['union'](_0x5b4f7b)[_0xa9bf('0x8f')]()['value']();return db[_0xa9bf('0x51')][_0xa9bf('0x39')]({'where':{'id':_0x12ab03['params']['id']}})['then'](function(_0x500329){return db[_0xa9bf('0x8c')]['transaction'](function(_0x471b91){return _0x500329[_0xa9bf('0x81')](_0x12ab03[_0xa9bf('0x44')][_0xa9bf('0x90')],{'transaction':_0x471b91})['then'](function(){if(!_[_0xa9bf('0x91')](_0x25b2dc)){return _0x500329[_0xa9bf('0x92')](_0x25b2dc,{'transaction':_0x471b91})[_0xa9bf('0x2f')](function(){return db[_0xa9bf('0x7b')]['destroy']({'where':{'VoiceQueueId':_0x12ab03[_0xa9bf('0x56')]['id'],'UserId':_0x25b2dc},'transaction':_0x471b91});});}})[_0xa9bf('0x2f')](function(){_0x25b2dc[_0xa9bf('0x93')](function(_0x2a54db){socket[_0xa9bf('0x80')](_0xa9bf('0x94'),{'UserId':_0x2a54db,'VoiceQueueId':_0x500329['id']});});});});});});})['then'](respondWithStatusCode(_0x3f2697,null))['catch'](handleError(_0x3f2697,null));};exports[_0xa9bf('0x95')]=function(_0x1083f7,_0x35ae6d,_0x2a9558){var _0x3f1163,_0x33203b;return db[_0xa9bf('0x51')][_0xa9bf('0x39')]({'where':{'id':_0x1083f7[_0xa9bf('0x56')]['id']}})['then'](handleEntityNotFound(_0x35ae6d,null))['then'](function(_0x22ec48){if(_0x22ec48){_0x33203b=_0x22ec48;return _0x22ec48['addAgents'](_0x1083f7[_0xa9bf('0x5b')][_0xa9bf('0x90')],_[_0xa9bf('0x96')](_0x1083f7[_0xa9bf('0x5b')],[_0xa9bf('0x90'),'id'])||{})[_0xa9bf('0x97')](function(_0x42998d){for(var _0x59224f=0x0;_0x59224f<_0x1083f7[_0xa9bf('0x5b')][_0xa9bf('0x90')][_0xa9bf('0x58')];_0x59224f+=0x1){socket[_0xa9bf('0x80')](_0xa9bf('0x98'),{'UserId':Number(_0x1083f7[_0xa9bf('0x5b')]['ids'][_0x59224f]),'VoiceQueueId':Number(_0x1083f7[_0xa9bf('0x56')]['id'])});}return _0x42998d;});}})[_0xa9bf('0x2f')](function(_0x4736fb){_0x3f1163=_0x4736fb||[];if(_0x33203b){return db['User'][_0xa9bf('0x52')]({'where':{'id':_0x1083f7[_0xa9bf('0x5b')][_0xa9bf('0x90')]},'attributes':['id','name','online',_0xa9bf('0x74'),_0xa9bf('0x7f')],'raw':!![]});}})[_0xa9bf('0x2f')](function(_0x5a09dc){if(!_[_0xa9bf('0x91')](_0x5a09dc)){var _0x56a1c9=[];for(var _0x4a3b59=0x0;_0x4a3b59<_0x5a09dc[_0xa9bf('0x58')];_0x4a3b59++){if(_0x5a09dc[_0x4a3b59][_0xa9bf('0x73')]){_0x56a1c9[_0xa9bf('0x99')](db[_0xa9bf('0x7b')][_0xa9bf('0x78')]({'membername':_0x5a09dc[_0x4a3b59][_0xa9bf('0x3e')],'UserId':_0x5a09dc[_0x4a3b59]['id'],'queue_name':_0x33203b[_0xa9bf('0x3e')],'VoiceQueueId':_0x33203b['id'],'interface':_['isNil'](_0x5a09dc[_0x4a3b59][_0xa9bf('0x7f')])?util['format']('SIP/%s',_0x5a09dc[_0x4a3b59]['name']):_0x5a09dc[_0x4a3b59][_0xa9bf('0x7f')],'paused':_0x5a09dc[_0x4a3b59][_0xa9bf('0x74')]||![],'penalty':_0x1083f7['body']['penalty']||0x0}));}}return BPromise[_0xa9bf('0x9a')](_0x56a1c9);}})['then'](function(){return _0x3f1163;})[_0xa9bf('0x2f')](respondWithResult(_0x35ae6d,null))['catch'](handleError(_0x35ae6d,null));};exports[_0xa9bf('0x92')]=function(_0x37001e,_0x4f772e,_0x40d6c3){return db['VoiceQueue']['find']({'where':{'id':_0x37001e[_0xa9bf('0x56')]['id']}})[_0xa9bf('0x2f')](handleEntityNotFound(_0x4f772e,null))[_0xa9bf('0x2f')](function(_0x3c1474){if(_0x3c1474){return _0x3c1474[_0xa9bf('0x92')](_0x37001e[_0xa9bf('0x44')]['ids'])[_0xa9bf('0x2f')](function(){if(_[_0xa9bf('0x9b')](_0x37001e[_0xa9bf('0x44')][_0xa9bf('0x90')])){for(var _0x26cb8b=0x0;_0x26cb8b<_0x37001e[_0xa9bf('0x44')][_0xa9bf('0x90')]['length'];_0x26cb8b+=0x1){socket['emit'](_0xa9bf('0x94'),{'UserId':Number(_0x37001e['query']['ids'][_0x26cb8b]),'VoiceQueueId':Number(_0x37001e[_0xa9bf('0x56')]['id'])});}}else{socket[_0xa9bf('0x80')]('userVoiceQueue:remove',{'UserId':Number(_0x37001e['query'][_0xa9bf('0x90')]),'VoiceQueueId':Number(_0x37001e['params']['id'])});}});}})['then'](function(_0x57bf14){return db['UserVoiceQueueRt'][_0xa9bf('0x3b')]({'where':{'VoiceQueueId':_0x37001e[_0xa9bf('0x56')]['id'],'UserId':_0x37001e[_0xa9bf('0x44')][_0xa9bf('0x90')]}})['then'](function(){return _0x57bf14;});})[_0xa9bf('0x2f')](respondWithStatusCode(_0x4f772e,null))[_0xa9bf('0x54')](handleError(_0x4f772e,null));};exports[_0xa9bf('0x9c')]=function(_0x2e32ed,_0x46ab8d,_0x127aab){var _0x114a4c={};var _0xa3492c={};var _0x129a1e;var _0xc81547;return db[_0xa9bf('0x51')][_0xa9bf('0x67')]({'where':{'id':_0x2e32ed['params']['id']}})[_0xa9bf('0x2f')](handleEntityNotFound(_0x46ab8d,null))[_0xa9bf('0x2f')](function(_0x41dafa){if(_0x41dafa){_0x129a1e=_0x41dafa;_0xa3492c[_0xa9bf('0x42')]=_[_0xa9bf('0x57')](db[_0xa9bf('0x82')][_0xa9bf('0x40')]);_0xa3492c[_0xa9bf('0x44')]=_[_0xa9bf('0x57')](_0x2e32ed[_0xa9bf('0x44')]);_0xa3492c[_0xa9bf('0x45')]=_[_0xa9bf('0x46')](_0xa3492c[_0xa9bf('0x42')],_0xa3492c[_0xa9bf('0x44')]);_0x114a4c[_0xa9bf('0x47')]=_[_0xa9bf('0x46')](_0xa3492c[_0xa9bf('0x42')],qs[_0xa9bf('0x48')](_0x2e32ed[_0xa9bf('0x44')]['fields']));_0x114a4c[_0xa9bf('0x47')]=_0x114a4c[_0xa9bf('0x47')][_0xa9bf('0x58')]?_0x114a4c[_0xa9bf('0x47')]:_0xa3492c[_0xa9bf('0x42')];_0x114a4c[_0xa9bf('0x4b')]=qs[_0xa9bf('0x4c')](_0x2e32ed[_0xa9bf('0x44')][_0xa9bf('0x4c')]);_0x114a4c['where']=qs[_0xa9bf('0x45')](_[_0xa9bf('0x6b')](_0x2e32ed[_0xa9bf('0x44')],_0xa3492c['filters']));if(_0x2e32ed[_0xa9bf('0x44')][_0xa9bf('0x34')]){_0x114a4c['where']=_[_0xa9bf('0x4e')](_0x114a4c[_0xa9bf('0x4d')],{'$or':_[_0xa9bf('0x43')](_0x114a4c[_0xa9bf('0x47')],function(_0x2a27b1){var _0x23ac10={};_0x23ac10[_0x2a27b1]={'$like':'%'+_0x2e32ed[_0xa9bf('0x44')][_0xa9bf('0x34')]+'%'};return _0x23ac10;})});}_0x114a4c=_[_0xa9bf('0x4e')]({},_0x114a4c,_0x2e32ed[_0xa9bf('0x59')]);return _0x129a1e['getAgents'](_0x114a4c);}})[_0xa9bf('0x2f')](function(_0x5f4f67){if(_0x5f4f67){_0xc81547=_0x5f4f67[_0xa9bf('0x58')];if(!_0x2e32ed[_0xa9bf('0x44')][_0xa9bf('0x49')](_0xa9bf('0x4a'))){_0x114a4c[_0xa9bf('0x27')]=qs['limit'](_0x2e32ed['query'][_0xa9bf('0x27')]);_0x114a4c['offset']=qs[_0xa9bf('0x25')](_0x2e32ed[_0xa9bf('0x44')][_0xa9bf('0x25')]);}return _0x129a1e[_0xa9bf('0x9c')](_0x114a4c);}})[_0xa9bf('0x2f')](function(_0x28c6c6){if(_0x28c6c6){return _0x28c6c6?{'count':_0xc81547,'rows':_0x28c6c6}:null;}})[_0xa9bf('0x2f')](respondWithResult(_0x46ab8d,null))[_0xa9bf('0x54')](handleError(_0x46ab8d,null));};exports[_0xa9bf('0x9d')]=function(_0x489728,_0x4df23c,_0x298d43){var _0x4581c7={};var _0xf811b5={};var _0x1166c4;var _0x18c702;return db[_0xa9bf('0x51')][_0xa9bf('0x67')]({'where':{'id':_0x489728['params']['id']}})[_0xa9bf('0x2f')](handleEntityNotFound(_0x4df23c,null))['then'](function(_0x2a17db){if(_0x2a17db){_0x1166c4=_0x2a17db;_0xf811b5[_0xa9bf('0x42')]=_[_0xa9bf('0x57')](db[_0xa9bf('0x7b')][_0xa9bf('0x40')]);_0xf811b5[_0xa9bf('0x44')]=_[_0xa9bf('0x57')](_0x489728['query']);_0xf811b5[_0xa9bf('0x45')]=_[_0xa9bf('0x46')](_0xf811b5[_0xa9bf('0x42')],_0xf811b5[_0xa9bf('0x44')]);_0x4581c7[_0xa9bf('0x47')]=_[_0xa9bf('0x46')](_0xf811b5[_0xa9bf('0x42')],qs[_0xa9bf('0x48')](_0x489728[_0xa9bf('0x44')][_0xa9bf('0x48')]));_0x4581c7[_0xa9bf('0x47')]=_0x4581c7['attributes'][_0xa9bf('0x58')]?_0x4581c7[_0xa9bf('0x47')]:_0xf811b5[_0xa9bf('0x42')];_0x4581c7[_0xa9bf('0x4b')]=qs['sort'](_0x489728['query'][_0xa9bf('0x4c')]);_0x4581c7['where']=qs[_0xa9bf('0x45')](_[_0xa9bf('0x6b')](_0x489728[_0xa9bf('0x44')],_0xf811b5['filters']));if(_0x489728[_0xa9bf('0x44')][_0xa9bf('0x34')]){_0x4581c7[_0xa9bf('0x4d')]=_[_0xa9bf('0x4e')](_0x4581c7[_0xa9bf('0x4d')],{'$or':_[_0xa9bf('0x43')](_0x4581c7[_0xa9bf('0x47')],function(_0x473deb){var _0x39d3e7={};_0x39d3e7[_0x473deb]={'$like':'%'+_0x489728[_0xa9bf('0x44')][_0xa9bf('0x34')]+'%'};return _0x39d3e7;})});}_0x4581c7=_[_0xa9bf('0x4e')]({},_0x4581c7,_0x489728[_0xa9bf('0x59')]);return _0x1166c4[_0xa9bf('0x9d')](_0x4581c7);}})[_0xa9bf('0x2f')](function(_0x124789){if(_0x124789){_0x18c702=_0x124789[_0xa9bf('0x58')];if(!_0x489728[_0xa9bf('0x44')]['hasOwnProperty'](_0xa9bf('0x4a'))){_0x4581c7['limit']=qs['limit'](_0x489728[_0xa9bf('0x44')][_0xa9bf('0x27')]);_0x4581c7[_0xa9bf('0x25')]=qs['offset'](_0x489728[_0xa9bf('0x44')][_0xa9bf('0x25')]);}return _0x1166c4[_0xa9bf('0x9d')](_0x4581c7);}})[_0xa9bf('0x2f')](function(_0x791640){return _0x791640?{'count':_0x18c702,'rows':_0x791640}:null;})['then'](respondWithResult(_0x4df23c,null))[_0xa9bf('0x54')](handleError(_0x4df23c,null));};exports['getLists']=function(_0x51632d,_0x2074ca,_0x399316){var _0x3e8854={};var _0x514ce8={};var _0x251134;var _0x3a4554;return db[_0xa9bf('0x51')]['findOne']({'where':{'id':_0x51632d[_0xa9bf('0x56')]['id']}})['then'](handleEntityNotFound(_0x2074ca,null))[_0xa9bf('0x2f')](function(_0x1dfe4a){if(_0x1dfe4a){_0x251134=_0x1dfe4a;_0x514ce8[_0xa9bf('0x42')]=_[_0xa9bf('0x57')](db[_0xa9bf('0x9e')][_0xa9bf('0x40')]);_0x514ce8[_0xa9bf('0x44')]=_[_0xa9bf('0x57')](_0x51632d[_0xa9bf('0x44')]);_0x514ce8['filters']=_[_0xa9bf('0x46')](_0x514ce8[_0xa9bf('0x42')],_0x514ce8[_0xa9bf('0x44')]);_0x3e8854[_0xa9bf('0x47')]=_[_0xa9bf('0x46')](_0x514ce8[_0xa9bf('0x42')],qs[_0xa9bf('0x48')](_0x51632d[_0xa9bf('0x44')][_0xa9bf('0x48')]));_0x3e8854[_0xa9bf('0x47')]=_0x3e8854[_0xa9bf('0x47')]['length']?_0x3e8854[_0xa9bf('0x47')]:_0x514ce8[_0xa9bf('0x42')];_0x3e8854[_0xa9bf('0x4b')]=qs[_0xa9bf('0x4c')](_0x51632d['query'][_0xa9bf('0x4c')]);_0x3e8854[_0xa9bf('0x4d')]=qs[_0xa9bf('0x45')](_['pick'](_0x51632d['query'],_0x514ce8['filters']));if(_0x51632d[_0xa9bf('0x44')][_0xa9bf('0x34')]){_0x3e8854[_0xa9bf('0x4d')]=_[_0xa9bf('0x4e')](_0x3e8854[_0xa9bf('0x4d')],{'$or':_[_0xa9bf('0x43')](_0x3e8854[_0xa9bf('0x47')],function(_0x403e2e){var _0x292e5b={};_0x292e5b[_0x403e2e]={'$like':'%'+_0x51632d[_0xa9bf('0x44')][_0xa9bf('0x34')]+'%'};return _0x292e5b;})});}_0x3e8854=_['merge']({},_0x3e8854,_0x51632d[_0xa9bf('0x59')]);return _0x251134[_0xa9bf('0x9f')](_0x3e8854);}})[_0xa9bf('0x2f')](function(_0x49c904){if(_0x49c904){_0x3a4554=_0x49c904[_0xa9bf('0x58')];if(!_0x51632d[_0xa9bf('0x44')]['hasOwnProperty'](_0xa9bf('0x4a'))){_0x3e8854[_0xa9bf('0x27')]=qs[_0xa9bf('0x27')](_0x51632d[_0xa9bf('0x44')][_0xa9bf('0x27')]);_0x3e8854[_0xa9bf('0x25')]=qs[_0xa9bf('0x25')](_0x51632d[_0xa9bf('0x44')][_0xa9bf('0x25')]);}return _0x251134[_0xa9bf('0x9f')](_0x3e8854);}})['then'](function(_0x213432){if(_0x213432){return _0x213432?{'count':_0x3a4554,'rows':_0x213432}:null;}})[_0xa9bf('0x2f')](respondWithResult(_0x2074ca,null))[_0xa9bf('0x54')](handleError(_0x2074ca,null));};exports[_0xa9bf('0xa0')]=function(_0x245323,_0x37603e,_0x24285d){var _0x1e8060,_0x26d1f1;return db['VoiceQueue']['find']({'where':{'id':_0x245323['params']['id']}})[_0xa9bf('0x2f')](handleEntityNotFound(_0x37603e,null))[_0xa9bf('0x2f')](function(_0x1d1a9f){if(_0x1d1a9f){_0x26d1f1=_0x1d1a9f;return _0x1d1a9f[_0xa9bf('0xa0')](_0x245323[_0xa9bf('0x5b')][_0xa9bf('0x90')],_[_0xa9bf('0x96')](_0x245323['body'],['ids','id'])||{});}return null;})[_0xa9bf('0x97')](function(_0x31f7ea){var _0x271c33;_0x1e8060=_0x31f7ea||[];var _0x3472c7=[];if(_0x31f7ea){for(var _0x4abd4b=0x0;_0x4abd4b<_0x31f7ea[_0xa9bf('0x58')];_0x4abd4b+=0x1){var _0x1fd307=_0x31f7ea[_0x4abd4b][_0xa9bf('0x30')]({'plain':!![]});_0x26d1f1[_0xa9bf('0xa1')]=_0x245323[_0xa9bf('0x5b')][_0xa9bf('0xa1')]?_0x245323[_0xa9bf('0x5b')]['dialCheckDuplicateType']:_0x26d1f1[_0xa9bf('0xa1')];switch(_0x26d1f1[_0xa9bf('0xa1')]){case'always':_0x271c33=squel[_0xa9bf('0xa2')]()[_0xa9bf('0xa3')](_0xa9bf('0xa4'))[_0xa9bf('0xa5')]([_0xa9bf('0xa6'),_0xa9bf('0xa7'),_0xa9bf('0xa8'),'ListId',_0xa9bf('0x69'),_0xa9bf('0x64'),_0xa9bf('0x65')],squel['select']()['field'](_0xa9bf('0xa6'),_0xa9bf('0xa6'))['field'](_0xa9bf('0xa9'),_0xa9bf('0xa7'))[_0xa9bf('0x84')]('id','ContactId')['field'](_0x1fd307[_0xa9bf('0xaa')][_0xa9bf('0x8b')](),'ListId')['field'](_0x245323['params']['id'][_0xa9bf('0x8b')](),'VoiceQueueId')['field'](_0xa9bf('0xa9'),_0xa9bf('0x64'))[_0xa9bf('0x84')](_0xa9bf('0xa9'),'updatedAt')[_0xa9bf('0x86')]('cm_contacts')[_0xa9bf('0x4d')]('deletedAt\x20IS\x20NULL')['where'](_0xa9bf('0xab'),_0x1fd307[_0xa9bf('0xaa')]['toString']())[_0xa9bf('0x4d')](_0xa9bf('0xac'))[_0xa9bf('0x4d')](_0xa9bf('0xad'),squel[_0xa9bf('0x83')]()[_0xa9bf('0x84')](_0xa9bf('0xae'))[_0xa9bf('0x86')]('cm_hopper_final')[_0xa9bf('0x4d')](_0xa9bf('0xaf'),_0x245323[_0xa9bf('0x56')]['id'][_0xa9bf('0x8b')]()))[_0xa9bf('0x4d')]('phone\x20NOT\x20IN\x20(?)',squel[_0xa9bf('0x83')]()[_0xa9bf('0x84')]('COALESCE(phone,\x27\x27)')[_0xa9bf('0x86')](_0xa9bf('0xa4'))[_0xa9bf('0x4d')](_0xa9bf('0xaf'),_0x245323['params']['id'][_0xa9bf('0x8b')]())))[_0xa9bf('0x8b')]();break;case _0xa9bf('0xb0'):_0x271c33=squel['insert']()[_0xa9bf('0xa3')](_0xa9bf('0xa4'))[_0xa9bf('0xa5')](['phone','scheduledAt',_0xa9bf('0xa8'),_0xa9bf('0xb1'),_0xa9bf('0x69'),'createdAt',_0xa9bf('0x65')],squel[_0xa9bf('0x83')]()[_0xa9bf('0x84')](_0xa9bf('0xa6'),_0xa9bf('0xa6'))['field'](_0xa9bf('0xa9'),_0xa9bf('0xa7'))['field']('id',_0xa9bf('0xa8'))[_0xa9bf('0x84')](_0x1fd307['CmListId'][_0xa9bf('0x8b')](),'ListId')[_0xa9bf('0x84')](_0x245323[_0xa9bf('0x56')]['id'][_0xa9bf('0x8b')](),_0xa9bf('0x69'))[_0xa9bf('0x84')]('NOW()',_0xa9bf('0x64'))[_0xa9bf('0x84')]('NOW()',_0xa9bf('0x65'))[_0xa9bf('0x86')](_0xa9bf('0xb2'))[_0xa9bf('0x4d')]('deletedAt\x20IS\x20NULL')[_0xa9bf('0x4d')](_0xa9bf('0xab'),_0x1fd307[_0xa9bf('0xaa')][_0xa9bf('0x8b')]())[_0xa9bf('0x4d')](_0xa9bf('0xac'))[_0xa9bf('0x4d')](_0xa9bf('0xad'),squel[_0xa9bf('0x83')]()[_0xa9bf('0x84')]('COALESCE(phone,\x27\x27)')[_0xa9bf('0x86')](_0xa9bf('0xa4'))[_0xa9bf('0x4d')](_0xa9bf('0xaf'),_0x245323[_0xa9bf('0x56')]['id'][_0xa9bf('0x8b')]())))[_0xa9bf('0x8b')]();break;default:_0x271c33=squel[_0xa9bf('0xa2')]()[_0xa9bf('0xa3')](_0xa9bf('0xa4'))[_0xa9bf('0xa5')]([_0xa9bf('0xa6'),'scheduledAt',_0xa9bf('0xa8'),'ListId',_0xa9bf('0x69'),'createdAt',_0xa9bf('0x65')],squel[_0xa9bf('0x83')]()['field'](_0xa9bf('0xa6'),_0xa9bf('0xa6'))['field'](_0xa9bf('0xa9'),_0xa9bf('0xa7'))[_0xa9bf('0x84')]('id',_0xa9bf('0xa8'))[_0xa9bf('0x84')](_0x1fd307[_0xa9bf('0xaa')][_0xa9bf('0x8b')](),_0xa9bf('0xb1'))[_0xa9bf('0x84')](_0x245323['params']['id']['toString'](),_0xa9bf('0x69'))[_0xa9bf('0x84')](_0xa9bf('0xa9'),_0xa9bf('0x64'))[_0xa9bf('0x84')](_0xa9bf('0xa9'),'updatedAt')[_0xa9bf('0x86')](_0xa9bf('0xb2'))[_0xa9bf('0x4d')]('deletedAt\x20IS\x20NULL')[_0xa9bf('0x4d')](_0xa9bf('0xab'),_0x1fd307['CmListId'][_0xa9bf('0x8b')]())[_0xa9bf('0x4d')](_0xa9bf('0xac')))['toString']();}_0x3472c7[_0xa9bf('0x99')](db[_0xa9bf('0x8c')][_0xa9bf('0x44')](_0x271c33));}return BPromise[_0xa9bf('0x9a')](_0x3472c7);}})[_0xa9bf('0x2f')](function(){return _0x1e8060;})[_0xa9bf('0x2f')](respondWithResult(_0x37603e,null))[_0xa9bf('0x54')](handleError(_0x37603e,null));};exports['removeLists']=function(_0xa2ae6d,_0xa6fa5b,_0x6c2570){return db['VoiceQueue'][_0xa9bf('0x39')]({'where':{'id':_0xa2ae6d[_0xa9bf('0x56')]['id']}})['then'](handleEntityNotFound(_0xa6fa5b,null))[_0xa9bf('0x2f')](function(_0x29197e){if(_0x29197e){return _0x29197e[_0xa9bf('0xb3')](_0xa2ae6d[_0xa9bf('0x44')][_0xa9bf('0x90')]);}})[_0xa9bf('0x2f')](function(_0x44af66){if(_0x44af66){return db[_0xa9bf('0x68')][_0xa9bf('0x3b')]({'where':{'ListId':_0xa2ae6d[_0xa9bf('0x44')][_0xa9bf('0x90')],'VoiceQueueId':_0xa2ae6d[_0xa9bf('0x56')]['id']}})['then'](function(){return _0x44af66;});}})[_0xa9bf('0x2f')](respondWithStatusCode(_0xa6fa5b,null))[_0xa9bf('0x54')](handleError(_0xa6fa5b,null));};exports[_0xa9bf('0xb4')]=function(_0x188c97,_0x20edc1,_0x4285b7){var _0x1d49e8={};var _0x5cd42f={};var _0x1a42d0;var _0x552ddc;return db[_0xa9bf('0x51')][_0xa9bf('0x67')]({'where':{'id':_0x188c97['params']['id']}})[_0xa9bf('0x2f')](handleEntityNotFound(_0x20edc1,null))[_0xa9bf('0x2f')](function(_0x13de8a){if(_0x13de8a){_0x1a42d0=_0x13de8a;_0x5cd42f[_0xa9bf('0x42')]=_[_0xa9bf('0x57')](db[_0xa9bf('0x9e')][_0xa9bf('0x40')]);_0x5cd42f['query']=_[_0xa9bf('0x57')](_0x188c97[_0xa9bf('0x44')]);_0x5cd42f[_0xa9bf('0x45')]=_[_0xa9bf('0x46')](_0x5cd42f['model'],_0x5cd42f['query']);_0x1d49e8[_0xa9bf('0x47')]=_[_0xa9bf('0x46')](_0x5cd42f[_0xa9bf('0x42')],qs[_0xa9bf('0x48')](_0x188c97[_0xa9bf('0x44')][_0xa9bf('0x48')]));_0x1d49e8[_0xa9bf('0x47')]=_0x1d49e8[_0xa9bf('0x47')][_0xa9bf('0x58')]?_0x1d49e8[_0xa9bf('0x47')]:_0x5cd42f[_0xa9bf('0x42')];_0x1d49e8[_0xa9bf('0x4b')]=qs[_0xa9bf('0x4c')](_0x188c97[_0xa9bf('0x44')][_0xa9bf('0x4c')]);_0x1d49e8[_0xa9bf('0x4d')]=qs[_0xa9bf('0x45')](_[_0xa9bf('0x6b')](_0x188c97['query'],_0x5cd42f['filters']));if(_0x188c97['query'][_0xa9bf('0x34')]){_0x1d49e8[_0xa9bf('0x4d')]=_['merge'](_0x1d49e8[_0xa9bf('0x4d')],{'$or':_['map'](_0x1d49e8[_0xa9bf('0x47')],function(_0x19a9cb){var _0x1aa495={};_0x1aa495[_0x19a9cb]={'$like':'%'+_0x188c97[_0xa9bf('0x44')][_0xa9bf('0x34')]+'%'};return _0x1aa495;})});}_0x1d49e8=_[_0xa9bf('0x4e')]({},_0x1d49e8,_0x188c97[_0xa9bf('0x59')]);return _0x1a42d0[_0xa9bf('0xb4')](_0x1d49e8);}})[_0xa9bf('0x2f')](function(_0x29c0cc){if(_0x29c0cc){_0x552ddc=_0x29c0cc[_0xa9bf('0x58')];if(!_0x188c97[_0xa9bf('0x44')][_0xa9bf('0x49')]('nolimit')){_0x1d49e8[_0xa9bf('0x27')]=qs['limit'](_0x188c97[_0xa9bf('0x44')][_0xa9bf('0x27')]);_0x1d49e8[_0xa9bf('0x25')]=qs['offset'](_0x188c97[_0xa9bf('0x44')][_0xa9bf('0x25')]);}return _0x1a42d0[_0xa9bf('0xb4')](_0x1d49e8);}})['then'](function(_0xe77604){if(_0xe77604){return _0xe77604?{'count':_0x552ddc,'rows':_0xe77604}:null;}})[_0xa9bf('0x2f')](respondWithResult(_0x20edc1,null))[_0xa9bf('0x54')](handleError(_0x20edc1,null));};exports[_0xa9bf('0xb5')]=function(_0x1d9bef,_0x37f0fd,_0xc63bb4){var _0x3cf115,_0x40eb74;return db[_0xa9bf('0x51')]['find']({'where':{'id':_0x1d9bef[_0xa9bf('0x56')]['id']}})['then'](handleEntityNotFound(_0x37f0fd,null))[_0xa9bf('0x2f')](function(_0x246809){if(_0x246809){_0x40eb74=_0x246809;return _0x246809[_0xa9bf('0xb5')](_0x1d9bef['body'][_0xa9bf('0x90')],_['omit'](_0x1d9bef[_0xa9bf('0x5b')],['ids','id'])||{});}return null;})[_0xa9bf('0x97')](function(_0x8699bc){var _0x485b6a;_0x3cf115=_0x8699bc||[];var _0x3c0306=[];if(_0x8699bc){for(var _0x51d490=0x0;_0x51d490<_0x8699bc['length'];_0x51d490+=0x1){var _0x425df2=_0x8699bc[_0x51d490][_0xa9bf('0x30')]({'plain':!![]});_0x485b6a=squel['insert']()[_0xa9bf('0xa3')](_0xa9bf('0xb6'))[_0xa9bf('0xa5')](['phone',_0xa9bf('0xa8'),_0xa9bf('0xb1'),'VoiceQueueId',_0xa9bf('0x64'),'updatedAt'],squel[_0xa9bf('0x83')]()[_0xa9bf('0x84')]('phone','phone')[_0xa9bf('0x84')]('id',_0xa9bf('0xa8'))[_0xa9bf('0x84')](_0x425df2[_0xa9bf('0xaa')][_0xa9bf('0x8b')](),_0xa9bf('0xb1'))[_0xa9bf('0x84')](_0x1d9bef[_0xa9bf('0x56')]['id'][_0xa9bf('0x8b')](),_0xa9bf('0x69'))[_0xa9bf('0x84')](_0xa9bf('0xa9'),_0xa9bf('0x64'))[_0xa9bf('0x84')](_0xa9bf('0xa9'),_0xa9bf('0x65'))['from'](_0xa9bf('0xb2'))[_0xa9bf('0x4d')](_0xa9bf('0xb7'))[_0xa9bf('0x4d')](_0xa9bf('0xab'),_0x425df2[_0xa9bf('0xaa')][_0xa9bf('0x8b')]())['where'](_0xa9bf('0xac')))[_0xa9bf('0x8b')]();_0x3c0306[_0xa9bf('0x99')](db['sequelize'][_0xa9bf('0x44')](_0x485b6a));}return BPromise['all'](_0x3c0306);}})[_0xa9bf('0x2f')](function(){return _0x3cf115;})[_0xa9bf('0x2f')](respondWithResult(_0x37f0fd,null))[_0xa9bf('0x54')](handleError(_0x37f0fd,null));};exports['removeBlackLists']=function(_0x4f812a,_0x1e0107,_0x4559c3){return db['VoiceQueue'][_0xa9bf('0x39')]({'where':{'id':_0x4f812a[_0xa9bf('0x56')]['id']}})[_0xa9bf('0x2f')](handleEntityNotFound(_0x1e0107,null))[_0xa9bf('0x2f')](function(_0xc0ce49){if(_0xc0ce49){return _0xc0ce49[_0xa9bf('0xb8')](_0x4f812a['query']['ids']);}})[_0xa9bf('0x2f')](function(_0x9de40){if(_0x9de40){return db[_0xa9bf('0x6f')][_0xa9bf('0x3b')]({'where':{'ListId':_0x4f812a[_0xa9bf('0x44')][_0xa9bf('0x90')],'VoiceQueueId':_0x4f812a[_0xa9bf('0x56')]['id']}})[_0xa9bf('0x2f')](function(){return _0x9de40;});}})[_0xa9bf('0x2f')](respondWithStatusCode(_0x1e0107,null))[_0xa9bf('0x54')](handleError(_0x1e0107,null));};