17eb8eb4601df37a84bd2e2bc438a81c3130373f
[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 _0xbbb6=['value','includes','type','name','UserProfileResource','stack','send','rawAttributes','fieldName','model','query','keys','filters','intersection','fields','attributes','length','hasOwnProperty','nolimit','order','sort','pick','where','merge','VoiceQueue','include','findAll','rows','catch','show','params','options','find','create','user','role','userProfileId','autoAssociation','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','includeAll','omit','createdAt','body','updatedAt','Unable\x20to\x20retrieve\x20the\x20current\x20user','UserProfileSection','getHoppers','findOne','VoiceQueueId','CmHopper','CmHopperHistory','CmHopperFinal','CmHopperBlack','getTeams','addTeams','teams','Team','User','Agents','online','voicePause','interface','forEach','penalty','sequelize','transaction','UserVoiceQueue','upsert','isNil','format','SIP/%s','emit','removeTeams','ids','select','field','tq.TeamId','from','join','user_has_teams','ut.TeamId\x20=\x20tq.TeamId','ut.UserId\x20=\x20?','push','toString','SELECT','every','TeamId','all','union','compact','isEmpty','UserVoiceQueueRt','userVoiceQueue:remove','addAgents','spread','userVoiceQueue:save','removeAgents','isArray','getAgents','getMembers','getLists','addLists','dialCheckDuplicateType','always','into','cm_hopper','fromQuery','phone','scheduledAt','ContactId','ListId','CmListId','NOW()','cm_contacts','deletedAt\x20IS\x20NULL','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','COALESCE(calleridnum,\x27\x27)','cm_hopper_final','VoiceQueueId\x20=\x20?','COALESCE(phone,\x27\x27)','onlyIfOpen','insert','ListId\x20=\x20?','removeLists','getBlackLists','CmList','addBlackLists','cm_hopper_black','removeBlackLists','html-pdf','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','path','sox','to-csv','ejs','lodash','crypto','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./voiceQueue.socket','sendStatus','status','end','json','count','offset','limit','set','Content-Range','reject','save','update','then','destroy','get','VoiceQueues','inbound','QueueCampaigns','outbound','filter','ignore','map'];(function(_0x2a56ad,_0x2b94bf){var _0x425175=function(_0x342f20){while(--_0x342f20){_0x2a56ad['push'](_0x2a56ad['shift']());}};_0x425175(++_0x2b94bf);}(_0xbbb6,0x1f4));var _0x6bbb=function(_0x5e795e,_0x48819f){_0x5e795e=_0x5e795e-0x0;var _0x3ae3a6=_0xbbb6[_0x5e795e];return _0x3ae3a6;};'use strict';var pdf=require(_0x6bbb('0x0'));var emlformat=require(_0x6bbb('0x1'));var rimraf=require(_0x6bbb('0x2'));var zipdir=require('zip-dir');var jsonpatch=require(_0x6bbb('0x3'));var rp=require(_0x6bbb('0x4'));var moment=require(_0x6bbb('0x5'));var BPromise=require(_0x6bbb('0x6'));var Mustache=require('mustache');var util=require('util');var path=require(_0x6bbb('0x7'));var sox=require(_0x6bbb('0x8'));var csv=require(_0x6bbb('0x9'));var ejs=require(_0x6bbb('0xa'));var fs=require('fs');var _=require(_0x6bbb('0xb'));var squel=require('squel');var crypto=require(_0x6bbb('0xc'));var jsforce=require('jsforce');var deskjs=require(_0x6bbb('0xd'));var toCsv=require(_0x6bbb('0x9'));var querystring=require(_0x6bbb('0xe'));var Papa=require(_0x6bbb('0xf'));var Redis=require(_0x6bbb('0x10'));var authService=require(_0x6bbb('0x11'));var qs=require(_0x6bbb('0x12'));var as=require(_0x6bbb('0x13'));var hardwareService=require(_0x6bbb('0x14'));var logger=require(_0x6bbb('0x15'))(_0x6bbb('0x16'));var utils=require(_0x6bbb('0x17'));var config=require('../../config/environment');var db=require(_0x6bbb('0x18'))['db'];config[_0x6bbb('0x19')]=_[_0x6bbb('0x1a')](config['redis'],{'host':_0x6bbb('0x1b'),'port':0x18eb});var socket=require(_0x6bbb('0x1c'))(new Redis(config[_0x6bbb('0x19')]));require(_0x6bbb('0x1d'))['register'](socket);function respondWithStatusCode(_0x9d51c0,_0x4a6341){_0x4a6341=_0x4a6341||0xcc;return function(_0x432c1b){if(_0x432c1b){return _0x9d51c0[_0x6bbb('0x1e')](_0x4a6341);}return _0x9d51c0[_0x6bbb('0x1f')](_0x4a6341)[_0x6bbb('0x20')]();};}function respondWithResult(_0x483320,_0x4c9da8){_0x4c9da8=_0x4c9da8||0xc8;return function(_0x2dbf47){if(_0x2dbf47){return _0x483320['status'](_0x4c9da8)[_0x6bbb('0x21')](_0x2dbf47);}};}function respondWithFilteredResult(_0x57698e,_0x19f446){return function(_0x2399c2){if(_0x2399c2){var _0x14dbb5=_0x2399c2[_0x6bbb('0x22')],_0x49019f=_0x19f446[_0x6bbb('0x23')],_0x14c2b1=_0x19f446['offset']+_0x19f446[_0x6bbb('0x24')],_0x4f8c69;if(_0x14c2b1>=_0x14dbb5){_0x14c2b1=_0x14dbb5;_0x4f8c69=0xc8;}else{_0x4f8c69=0xce;}_0x57698e[_0x6bbb('0x1f')](_0x4f8c69);return _0x57698e[_0x6bbb('0x25')](_0x6bbb('0x26'),_0x49019f+'-'+_0x14c2b1+'/'+_0x14dbb5)[_0x6bbb('0x21')](_0x2399c2);}return null;};}function patchUpdates(_0x17583b){return function(_0x6de8db){try{jsonpatch['apply'](_0x6de8db,_0x17583b,!![]);}catch(_0x42c407){return BPromise[_0x6bbb('0x27')](_0x42c407);}return _0x6de8db[_0x6bbb('0x28')]();};}function saveUpdates(_0x2e2ed6,_0x201a6c){return function(_0x13a91f){if(_0x13a91f){return _0x13a91f[_0x6bbb('0x29')](_0x2e2ed6)[_0x6bbb('0x2a')](function(_0x53cb9b){return _0x53cb9b;});}return null;};}function removeEntity(_0x2e4cd6,_0x41f4a9){return function(_0x396d5f){if(_0x396d5f){return _0x396d5f[_0x6bbb('0x2b')]()[_0x6bbb('0x2a')](function(){var _0x1f53dc=_0x396d5f[_0x6bbb('0x2c')]({'plain':!![]});var _0x2d532d=[{'name':_0x6bbb('0x2d'),'value':_0x6bbb('0x2e'),'ignore':![]},{'name':_0x6bbb('0x2f'),'value':_0x6bbb('0x30'),'ignore':![]}];var _0x5dc873=_(_0x2d532d)[_0x6bbb('0x31')](_0x6bbb('0x32'))[_0x6bbb('0x33')](_0x6bbb('0x34'))[_0x6bbb('0x34')]();if(_[_0x6bbb('0x35')](_0x5dc873,_0x1f53dc['type'])){return;}var _0x592262=_['find'](_0x2d532d,[_0x6bbb('0x34'),_0x1f53dc[_0x6bbb('0x36')]])[_0x6bbb('0x37')];return db[_0x6bbb('0x38')][_0x6bbb('0x2b')]({'where':{'type':_0x592262,'resourceId':_0x1f53dc['id']}})[_0x6bbb('0x2a')](function(){return _0x396d5f;});})[_0x6bbb('0x2a')](function(){_0x2e4cd6['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x4122e0,_0x4fa4e5){return function(_0x568558){if(!_0x568558){_0x4122e0['sendStatus'](0x194);}return _0x568558;};}function handleError(_0x3718cf,_0x3e1812){_0x3e1812=_0x3e1812||0x1f4;return function(_0x5ae396){logger['error'](_0x5ae396[_0x6bbb('0x39')]);if(_0x5ae396[_0x6bbb('0x37')]){delete _0x5ae396[_0x6bbb('0x37')];}_0x3718cf[_0x6bbb('0x1f')](_0x3e1812)[_0x6bbb('0x3a')](_0x5ae396);};}exports['index']=function(_0x25b3d5,_0x158e47){var _0x3b3335={},_0x3d6264={},_0x1d76d5={'count':0x0,'rows':[]};var _0x44eb02=_[_0x6bbb('0x33')](db['VoiceQueue'][_0x6bbb('0x3b')],function(_0x3f6a72){return{'name':_0x3f6a72[_0x6bbb('0x3c')],'type':_0x3f6a72[_0x6bbb('0x36')]['key']};});_0x3d6264[_0x6bbb('0x3d')]=_[_0x6bbb('0x33')](_0x44eb02,'name');_0x3d6264[_0x6bbb('0x3e')]=_[_0x6bbb('0x3f')](_0x25b3d5[_0x6bbb('0x3e')]);_0x3d6264[_0x6bbb('0x40')]=_[_0x6bbb('0x41')](_0x3d6264[_0x6bbb('0x3d')],_0x3d6264['query']);_0x3b3335['attributes']=_[_0x6bbb('0x41')](_0x3d6264[_0x6bbb('0x3d')],qs[_0x6bbb('0x42')](_0x25b3d5[_0x6bbb('0x3e')][_0x6bbb('0x42')]));_0x3b3335[_0x6bbb('0x43')]=_0x3b3335[_0x6bbb('0x43')][_0x6bbb('0x44')]?_0x3b3335[_0x6bbb('0x43')]:_0x3d6264[_0x6bbb('0x3d')];if(!_0x25b3d5[_0x6bbb('0x3e')][_0x6bbb('0x45')](_0x6bbb('0x46'))){_0x3b3335[_0x6bbb('0x24')]=qs[_0x6bbb('0x24')](_0x25b3d5[_0x6bbb('0x3e')][_0x6bbb('0x24')]);_0x3b3335['offset']=qs[_0x6bbb('0x23')](_0x25b3d5['query'][_0x6bbb('0x23')]);}_0x3b3335[_0x6bbb('0x47')]=qs[_0x6bbb('0x48')](_0x25b3d5[_0x6bbb('0x3e')][_0x6bbb('0x48')]);_0x3b3335['where']=qs[_0x6bbb('0x40')](_[_0x6bbb('0x49')](_0x25b3d5['query'],_0x3d6264[_0x6bbb('0x40')]),_0x44eb02);if(_0x25b3d5[_0x6bbb('0x3e')]['filter']){_0x3b3335[_0x6bbb('0x4a')]=_[_0x6bbb('0x4b')](_0x3b3335[_0x6bbb('0x4a')],{'$or':_[_0x6bbb('0x33')](_0x44eb02,function(_0x3f9306){if(_0x3f9306[_0x6bbb('0x36')]!=='VIRTUAL'){var _0x4da804={};_0x4da804[_0x3f9306['name']]={'$like':'%'+_0x25b3d5[_0x6bbb('0x3e')][_0x6bbb('0x31')]+'%'};return _0x4da804;}})});}_0x3b3335=_[_0x6bbb('0x4b')]({},_0x3b3335,_0x25b3d5['options']);var _0x3d9d60={'where':_0x3b3335[_0x6bbb('0x4a')]};return db[_0x6bbb('0x4c')][_0x6bbb('0x22')](_0x3d9d60)[_0x6bbb('0x2a')](function(_0xdc429d){_0x1d76d5['count']=_0xdc429d;if(_0x25b3d5[_0x6bbb('0x3e')]['includeAll']){_0x3b3335[_0x6bbb('0x4d')]=[{'all':!![]}];}return db['VoiceQueue'][_0x6bbb('0x4e')](_0x3b3335);})[_0x6bbb('0x2a')](function(_0x5c3d48){_0x1d76d5[_0x6bbb('0x4f')]=_0x5c3d48;return _0x1d76d5;})[_0x6bbb('0x2a')](respondWithFilteredResult(_0x158e47,_0x3b3335))[_0x6bbb('0x50')](handleError(_0x158e47,null));};exports[_0x6bbb('0x51')]=function(_0xb94521,_0x54d046){var _0x5015f8={'raw':![],'where':{'id':_0xb94521[_0x6bbb('0x52')]['id']}},_0x529e66={};_0x529e66[_0x6bbb('0x3d')]=_[_0x6bbb('0x3f')](db[_0x6bbb('0x4c')][_0x6bbb('0x3b')]);_0x529e66[_0x6bbb('0x3e')]=_[_0x6bbb('0x3f')](_0xb94521[_0x6bbb('0x3e')]);_0x529e66[_0x6bbb('0x40')]=_[_0x6bbb('0x41')](_0x529e66[_0x6bbb('0x3d')],_0x529e66[_0x6bbb('0x3e')]);_0x5015f8[_0x6bbb('0x43')]=_[_0x6bbb('0x41')](_0x529e66[_0x6bbb('0x3d')],qs[_0x6bbb('0x42')](_0xb94521[_0x6bbb('0x3e')][_0x6bbb('0x42')]));_0x5015f8[_0x6bbb('0x43')]=_0x5015f8[_0x6bbb('0x43')][_0x6bbb('0x44')]?_0x5015f8['attributes']:_0x529e66[_0x6bbb('0x3d')];if(_0xb94521[_0x6bbb('0x3e')]['includeAll']){_0x5015f8['include']=[{'all':!![]}];}_0x5015f8=_[_0x6bbb('0x4b')]({},_0x5015f8,_0xb94521[_0x6bbb('0x53')]);return db[_0x6bbb('0x4c')][_0x6bbb('0x54')](_0x5015f8)['then'](handleEntityNotFound(_0x54d046,null))[_0x6bbb('0x2a')](respondWithResult(_0x54d046,null))[_0x6bbb('0x50')](handleError(_0x54d046,null));};exports[_0x6bbb('0x55')]=function(_0x2ebc31,_0x3d17e2){return db[_0x6bbb('0x4c')][_0x6bbb('0x55')](_0x2ebc31['body'],{})[_0x6bbb('0x2a')](function(_0x506dac){var _0x3293ad=_0x2ebc31[_0x6bbb('0x56')]['get']({'plain':!![]});if(!_0x3293ad)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x3293ad[_0x6bbb('0x57')]===_0x6bbb('0x56')){var _0xcad222=_0x506dac[_0x6bbb('0x2c')]({'plain':!![]});var _0x2662a7=[{'name':_0x6bbb('0x2d'),'value':_0x6bbb('0x2e')},{'name':_0x6bbb('0x2f'),'value':_0x6bbb('0x30')}];var _0x67b20f=_[_0x6bbb('0x54')](_0x2662a7,['value',_0xcad222[_0x6bbb('0x36')]])[_0x6bbb('0x37')];return db['UserProfileSection'][_0x6bbb('0x54')]({'where':{'name':_0x67b20f,'userProfileId':_0x3293ad[_0x6bbb('0x58')]},'raw':!![]})[_0x6bbb('0x2a')](function(_0x3fe5ab){if(_0x3fe5ab&&_0x3fe5ab[_0x6bbb('0x59')]===0x0){return db[_0x6bbb('0x38')]['create']({'name':_0xcad222[_0x6bbb('0x37')],'resourceId':_0xcad222['id'],'type':_0x3fe5ab['name'],'sectionId':_0x3fe5ab['id']},{})[_0x6bbb('0x2a')](function(){return _0x506dac;});}else{return _0x506dac;}})[_0x6bbb('0x50')](function(_0x5ae3d7){logger[_0x6bbb('0x5a')](_0x6bbb('0x5b'),_0x5ae3d7);throw _0x5ae3d7;});}return _0x506dac;})[_0x6bbb('0x2a')](respondWithResult(_0x3d17e2,0xc9))['catch'](handleError(_0x3d17e2,null));};exports[_0x6bbb('0x5c')]=function(_0x49c49f,_0x480e2e){var _0x426eff={'where':{'id':_0x49c49f[_0x6bbb('0x52')]['id']}},_0x3beb5d={};_0x3beb5d[_0x6bbb('0x3d')]=_['keys'](db[_0x6bbb('0x4c')]['rawAttributes']);_0x426eff[_0x6bbb('0x43')]=_['intersection'](_0x3beb5d['model'],qs[_0x6bbb('0x42')](_0x49c49f[_0x6bbb('0x3e')][_0x6bbb('0x42')]));_0x426eff[_0x6bbb('0x43')]=_0x426eff['attributes']['length']?_0x426eff[_0x6bbb('0x43')]:_0x3beb5d['model'];if(_0x49c49f[_0x6bbb('0x3e')][_0x6bbb('0x5d')]){_0x426eff[_0x6bbb('0x4d')]=[{'all':!![]}];}_0x426eff=_[_0x6bbb('0x4b')]({},_0x426eff,_0x49c49f[_0x6bbb('0x53')]);return db['VoiceQueue']['find'](_0x426eff)[_0x6bbb('0x2a')](handleEntityNotFound(_0x480e2e,null))['then'](function(_0x123534){if(_0x123534){var _0x568e9e=_0x123534[_0x6bbb('0x2c')]({'plain':!![]});_0x568e9e=qs[_0x6bbb('0x5e')](_0x568e9e,['id',_0x6bbb('0x5f'),'updatedAt']);_0x49c49f[_0x6bbb('0x60')]=_['omit'](_0x49c49f[_0x6bbb('0x60')],['id',_0x6bbb('0x5f'),_0x6bbb('0x61')]);return db[_0x6bbb('0x4c')][_0x6bbb('0x55')](_['merge'](_0x568e9e,_0x49c49f['body']),{'include':_0x49c49f[_0x6bbb('0x3e')]['includeAll']?[{'all':!![]}]:undefined})[_0x6bbb('0x2a')](function(_0x11ef04){var _0x44eb7d=_0x49c49f['user'][_0x6bbb('0x2c')]({'plain':!![]});if(!_0x44eb7d)throw new Error(_0x6bbb('0x62'));if(_0x44eb7d[_0x6bbb('0x57')]===_0x6bbb('0x56')){var _0x172a18=_0x11ef04[_0x6bbb('0x2c')]({'plain':!![]});var _0x12c7be=[{'name':_0x6bbb('0x2d'),'value':_0x6bbb('0x2e')},{'name':'QueueCampaigns','value':_0x6bbb('0x30')}];var _0x421b13=_[_0x6bbb('0x54')](_0x12c7be,['value',_0x172a18['type']])[_0x6bbb('0x37')];return db[_0x6bbb('0x63')][_0x6bbb('0x54')]({'where':{'name':_0x421b13,'userProfileId':_0x44eb7d['userProfileId']},'raw':!![]})[_0x6bbb('0x2a')](function(_0x3d2539){if(_0x3d2539&&_0x3d2539[_0x6bbb('0x59')]===0x0){return db[_0x6bbb('0x38')][_0x6bbb('0x55')]({'name':_0x172a18[_0x6bbb('0x37')],'resourceId':_0x172a18['id'],'type':_0x3d2539[_0x6bbb('0x37')],'sectionId':_0x3d2539['id']},{})['then'](function(){return _0x11ef04;});}else{return _0x11ef04;}})[_0x6bbb('0x50')](function(_0x901f54){logger[_0x6bbb('0x5a')](_0x6bbb('0x5b'),_0x901f54);throw _0x901f54;});}return _0x11ef04;});}})[_0x6bbb('0x2a')](respondWithResult(_0x480e2e,0xc9))[_0x6bbb('0x50')](handleError(_0x480e2e,null));};exports[_0x6bbb('0x29')]=function(_0xecdabb,_0x200db9){if(_0xecdabb[_0x6bbb('0x60')]['id']){delete _0xecdabb['body']['id'];}return db[_0x6bbb('0x4c')][_0x6bbb('0x54')]({'where':{'id':_0xecdabb[_0x6bbb('0x52')]['id']}})[_0x6bbb('0x2a')](handleEntityNotFound(_0x200db9,null))[_0x6bbb('0x2a')](saveUpdates(_0xecdabb[_0x6bbb('0x60')],null))[_0x6bbb('0x2a')](respondWithResult(_0x200db9,null))[_0x6bbb('0x50')](handleError(_0x200db9,null));};exports['destroy']=function(_0x36740f,_0x2e3664){return db[_0x6bbb('0x4c')]['find']({'where':{'id':_0x36740f[_0x6bbb('0x52')]['id']}})['then'](handleEntityNotFound(_0x2e3664,null))['then'](removeEntity(_0x2e3664,null))[_0x6bbb('0x50')](handleError(_0x2e3664,null));};exports[_0x6bbb('0x64')]=function(_0x1ae159,_0x20603c,_0x51cb03){var _0x45f0ed={'raw':![],'where':{}};var _0x35261f={};var _0x56e08f={'count':0x0,'rows':[]};return db[_0x6bbb('0x4c')][_0x6bbb('0x65')]({'where':{'id':_0x1ae159['params']['id']}})[_0x6bbb('0x2a')](handleEntityNotFound(_0x20603c,null))[_0x6bbb('0x2a')](function(_0x4e6f7b){if(_0x4e6f7b){_0x35261f['model']=_[_0x6bbb('0x3f')](db['CmHopper']['rawAttributes']);_0x35261f[_0x6bbb('0x3e')]=_[_0x6bbb('0x3f')](_0x1ae159['query']);_0x35261f['filters']=_['intersection'](_0x35261f[_0x6bbb('0x3d')],_0x35261f[_0x6bbb('0x3e')]);_0x45f0ed[_0x6bbb('0x43')]=_[_0x6bbb('0x41')](_0x35261f['model'],qs[_0x6bbb('0x42')](_0x1ae159[_0x6bbb('0x3e')]['fields']));_0x45f0ed[_0x6bbb('0x43')]=_0x45f0ed[_0x6bbb('0x43')][_0x6bbb('0x44')]?_0x45f0ed['attributes']:_0x35261f[_0x6bbb('0x3d')];if(!_0x1ae159[_0x6bbb('0x3e')][_0x6bbb('0x45')](_0x6bbb('0x46'))){_0x45f0ed['limit']=qs['limit'](_0x1ae159['query'][_0x6bbb('0x24')]);_0x45f0ed[_0x6bbb('0x23')]=qs[_0x6bbb('0x23')](_0x1ae159['query']['offset']);}_0x45f0ed['order']=qs[_0x6bbb('0x48')](_0x1ae159[_0x6bbb('0x3e')][_0x6bbb('0x48')]);_0x45f0ed[_0x6bbb('0x4a')]=qs[_0x6bbb('0x40')](_[_0x6bbb('0x49')](_0x1ae159[_0x6bbb('0x3e')],_0x35261f[_0x6bbb('0x40')]));_0x45f0ed[_0x6bbb('0x4a')][_0x6bbb('0x66')]=_0x4e6f7b['id'];if(_0x1ae159['query'][_0x6bbb('0x31')]){_0x45f0ed[_0x6bbb('0x4a')]=_[_0x6bbb('0x4b')](_0x45f0ed['where'],{'$or':_['map'](_0x45f0ed[_0x6bbb('0x43')],function(_0x26fd45){var _0x45d533={};_0x45d533[_0x26fd45]={'$like':'%'+_0x1ae159[_0x6bbb('0x3e')][_0x6bbb('0x31')]+'%'};return _0x45d533;})});}_0x45f0ed=_[_0x6bbb('0x4b')]({},_0x45f0ed,_0x1ae159['options']);return db[_0x6bbb('0x67')]['count']({'where':_0x45f0ed[_0x6bbb('0x4a')]})[_0x6bbb('0x2a')](function(_0x3000e4){_0x56e08f[_0x6bbb('0x22')]=_0x3000e4;if(_0x1ae159['query']['includeAll']){_0x45f0ed[_0x6bbb('0x4d')]=[{'all':!![]}];}return db[_0x6bbb('0x67')]['findAll'](_0x45f0ed);})[_0x6bbb('0x2a')](function(_0x44e7e2){_0x56e08f[_0x6bbb('0x4f')]=_0x44e7e2;return _0x56e08f;});}})[_0x6bbb('0x2a')](respondWithFilteredResult(_0x20603c,_0x45f0ed))[_0x6bbb('0x50')](handleError(_0x20603c,null));};exports['getHopperHistories']=function(_0x452c2d,_0x400886,_0x59e535){var _0x37740d={'raw':!![],'where':{}};var _0x25e5d9={};var _0x3f0f91={'count':0x0,'rows':[]};return db[_0x6bbb('0x4c')][_0x6bbb('0x65')]({'where':{'id':_0x452c2d['params']['id']}})['then'](handleEntityNotFound(_0x400886,null))[_0x6bbb('0x2a')](function(_0x210b51){if(_0x210b51){_0x25e5d9[_0x6bbb('0x3d')]=_[_0x6bbb('0x3f')](db['CmHopperHistory'][_0x6bbb('0x3b')]);_0x25e5d9[_0x6bbb('0x3e')]=_[_0x6bbb('0x3f')](_0x452c2d['query']);_0x25e5d9['filters']=_['intersection'](_0x25e5d9[_0x6bbb('0x3d')],_0x25e5d9['query']);_0x37740d[_0x6bbb('0x43')]=_[_0x6bbb('0x41')](_0x25e5d9[_0x6bbb('0x3d')],qs[_0x6bbb('0x42')](_0x452c2d[_0x6bbb('0x3e')]['fields']));_0x37740d[_0x6bbb('0x43')]=_0x37740d['attributes'][_0x6bbb('0x44')]?_0x37740d[_0x6bbb('0x43')]:_0x25e5d9[_0x6bbb('0x3d')];if(!_0x452c2d['query']['hasOwnProperty'](_0x6bbb('0x46'))){_0x37740d[_0x6bbb('0x24')]=qs[_0x6bbb('0x24')](_0x452c2d[_0x6bbb('0x3e')]['limit']);_0x37740d[_0x6bbb('0x23')]=qs[_0x6bbb('0x23')](_0x452c2d[_0x6bbb('0x3e')][_0x6bbb('0x23')]);}_0x37740d[_0x6bbb('0x47')]=qs[_0x6bbb('0x48')](_0x452c2d[_0x6bbb('0x3e')]['sort']);_0x37740d[_0x6bbb('0x4a')]=qs['filters'](_[_0x6bbb('0x49')](_0x452c2d[_0x6bbb('0x3e')],_0x25e5d9[_0x6bbb('0x40')]));_0x37740d[_0x6bbb('0x4a')][_0x6bbb('0x66')]=_0x210b51['id'];if(_0x452c2d['query'][_0x6bbb('0x31')]){_0x37740d[_0x6bbb('0x4a')]=_[_0x6bbb('0x4b')](_0x37740d['where'],{'$or':_[_0x6bbb('0x33')](_0x37740d[_0x6bbb('0x43')],function(_0x44f628){var _0x18d974={};_0x18d974[_0x44f628]={'$like':'%'+_0x452c2d[_0x6bbb('0x3e')]['filter']+'%'};return _0x18d974;})});}_0x37740d=_[_0x6bbb('0x4b')]({},_0x37740d,_0x452c2d[_0x6bbb('0x53')]);return db[_0x6bbb('0x68')][_0x6bbb('0x22')]({'where':_0x37740d['where']})[_0x6bbb('0x2a')](function(_0x38f6be){_0x3f0f91['count']=_0x38f6be;if(_0x452c2d[_0x6bbb('0x3e')][_0x6bbb('0x5d')]){_0x37740d[_0x6bbb('0x4d')]=[{'all':!![]}];}return db[_0x6bbb('0x68')][_0x6bbb('0x4e')](_0x37740d);})[_0x6bbb('0x2a')](function(_0x738a9f){_0x3f0f91['rows']=_0x738a9f;return _0x3f0f91;});}})['then'](respondWithFilteredResult(_0x400886,_0x37740d))[_0x6bbb('0x50')](handleError(_0x400886,null));};exports['getHopperFinals']=function(_0x19eca2,_0x203134,_0x196231){var _0x2ba821={'raw':!![],'where':{}};var _0x352518={};var _0x13124d={'count':0x0,'rows':[]};return db[_0x6bbb('0x4c')][_0x6bbb('0x65')]({'where':{'id':_0x19eca2[_0x6bbb('0x52')]['id']}})['then'](handleEntityNotFound(_0x203134,null))[_0x6bbb('0x2a')](function(_0x55bdc3){if(_0x55bdc3){_0x352518[_0x6bbb('0x3d')]=_[_0x6bbb('0x3f')](db[_0x6bbb('0x69')][_0x6bbb('0x3b')]);_0x352518['query']=_[_0x6bbb('0x3f')](_0x19eca2[_0x6bbb('0x3e')]);_0x352518['filters']=_[_0x6bbb('0x41')](_0x352518[_0x6bbb('0x3d')],_0x352518[_0x6bbb('0x3e')]);_0x2ba821[_0x6bbb('0x43')]=_[_0x6bbb('0x41')](_0x352518['model'],qs['fields'](_0x19eca2[_0x6bbb('0x3e')][_0x6bbb('0x42')]));_0x2ba821[_0x6bbb('0x43')]=_0x2ba821[_0x6bbb('0x43')][_0x6bbb('0x44')]?_0x2ba821[_0x6bbb('0x43')]:_0x352518[_0x6bbb('0x3d')];if(!_0x19eca2[_0x6bbb('0x3e')][_0x6bbb('0x45')](_0x6bbb('0x46'))){_0x2ba821[_0x6bbb('0x24')]=qs[_0x6bbb('0x24')](_0x19eca2['query'][_0x6bbb('0x24')]);_0x2ba821[_0x6bbb('0x23')]=qs['offset'](_0x19eca2[_0x6bbb('0x3e')][_0x6bbb('0x23')]);}_0x2ba821[_0x6bbb('0x47')]=qs[_0x6bbb('0x48')](_0x19eca2[_0x6bbb('0x3e')][_0x6bbb('0x48')]);_0x2ba821[_0x6bbb('0x4a')]=qs[_0x6bbb('0x40')](_['pick'](_0x19eca2[_0x6bbb('0x3e')],_0x352518[_0x6bbb('0x40')]));_0x2ba821['where'][_0x6bbb('0x66')]=_0x55bdc3['id'];if(_0x19eca2[_0x6bbb('0x3e')][_0x6bbb('0x31')]){_0x2ba821[_0x6bbb('0x4a')]=_[_0x6bbb('0x4b')](_0x2ba821['where'],{'$or':_[_0x6bbb('0x33')](_0x2ba821[_0x6bbb('0x43')],function(_0xf8fc01){var _0x3e7429={};_0x3e7429[_0xf8fc01]={'$like':'%'+_0x19eca2[_0x6bbb('0x3e')][_0x6bbb('0x31')]+'%'};return _0x3e7429;})});}_0x2ba821=_[_0x6bbb('0x4b')]({},_0x2ba821,_0x19eca2[_0x6bbb('0x53')]);return db[_0x6bbb('0x69')][_0x6bbb('0x22')]({'where':_0x2ba821[_0x6bbb('0x4a')]})[_0x6bbb('0x2a')](function(_0x2220fb){_0x13124d[_0x6bbb('0x22')]=_0x2220fb;if(_0x19eca2[_0x6bbb('0x3e')][_0x6bbb('0x5d')]){_0x2ba821['include']=[{'all':!![]}];}return db[_0x6bbb('0x69')][_0x6bbb('0x4e')](_0x2ba821);})[_0x6bbb('0x2a')](function(_0x2e312a){_0x13124d['rows']=_0x2e312a;return _0x13124d;});}})[_0x6bbb('0x2a')](respondWithFilteredResult(_0x203134,_0x2ba821))[_0x6bbb('0x50')](handleError(_0x203134,null));};exports['getHopperBlacks']=function(_0x3eb919,_0xaea5fa,_0x46279b){var _0x2e7bb7={'raw':!![],'where':{}};var _0x4f5c81={};var _0x3391d3={'count':0x0,'rows':[]};return db['VoiceQueue'][_0x6bbb('0x65')]({'where':{'id':_0x3eb919[_0x6bbb('0x52')]['id']}})[_0x6bbb('0x2a')](handleEntityNotFound(_0xaea5fa,null))['then'](function(_0x3d2792){if(_0x3d2792){_0x4f5c81[_0x6bbb('0x3d')]=_[_0x6bbb('0x3f')](db[_0x6bbb('0x6a')]['rawAttributes']);_0x4f5c81[_0x6bbb('0x3e')]=_[_0x6bbb('0x3f')](_0x3eb919['query']);_0x4f5c81['filters']=_[_0x6bbb('0x41')](_0x4f5c81['model'],_0x4f5c81[_0x6bbb('0x3e')]);_0x2e7bb7[_0x6bbb('0x43')]=_[_0x6bbb('0x41')](_0x4f5c81[_0x6bbb('0x3d')],qs[_0x6bbb('0x42')](_0x3eb919[_0x6bbb('0x3e')]['fields']));_0x2e7bb7[_0x6bbb('0x43')]=_0x2e7bb7[_0x6bbb('0x43')][_0x6bbb('0x44')]?_0x2e7bb7[_0x6bbb('0x43')]:_0x4f5c81[_0x6bbb('0x3d')];if(!_0x3eb919['query'][_0x6bbb('0x45')](_0x6bbb('0x46'))){_0x2e7bb7[_0x6bbb('0x24')]=qs[_0x6bbb('0x24')](_0x3eb919[_0x6bbb('0x3e')][_0x6bbb('0x24')]);_0x2e7bb7[_0x6bbb('0x23')]=qs[_0x6bbb('0x23')](_0x3eb919[_0x6bbb('0x3e')][_0x6bbb('0x23')]);}_0x2e7bb7[_0x6bbb('0x47')]=qs['sort'](_0x3eb919[_0x6bbb('0x3e')][_0x6bbb('0x48')]);_0x2e7bb7[_0x6bbb('0x4a')]=qs['filters'](_[_0x6bbb('0x49')](_0x3eb919[_0x6bbb('0x3e')],_0x4f5c81[_0x6bbb('0x40')]));_0x2e7bb7[_0x6bbb('0x4a')][_0x6bbb('0x66')]=_0x3d2792['id'];if(_0x3eb919['query'][_0x6bbb('0x31')]){_0x2e7bb7[_0x6bbb('0x4a')]=_[_0x6bbb('0x4b')](_0x2e7bb7['where'],{'$or':_[_0x6bbb('0x33')](_0x2e7bb7[_0x6bbb('0x43')],function(_0x2aea0a){var _0x4c1b2f={};_0x4c1b2f[_0x2aea0a]={'$like':'%'+_0x3eb919['query']['filter']+'%'};return _0x4c1b2f;})});}_0x2e7bb7=_[_0x6bbb('0x4b')]({},_0x2e7bb7,_0x3eb919[_0x6bbb('0x53')]);return db[_0x6bbb('0x6a')]['count']({'where':_0x2e7bb7[_0x6bbb('0x4a')]})[_0x6bbb('0x2a')](function(_0x35f9cf){_0x3391d3['count']=_0x35f9cf;if(_0x3eb919[_0x6bbb('0x3e')][_0x6bbb('0x5d')]){_0x2e7bb7[_0x6bbb('0x4d')]=[{'all':!![]}];}return db['CmHopperBlack'][_0x6bbb('0x4e')](_0x2e7bb7);})[_0x6bbb('0x2a')](function(_0x16d41e){_0x3391d3[_0x6bbb('0x4f')]=_0x16d41e;return _0x3391d3;});}})[_0x6bbb('0x2a')](respondWithFilteredResult(_0xaea5fa,_0x2e7bb7))['catch'](handleError(_0xaea5fa,null));};exports['getTeams']=function(_0x16293a,_0x34e44e,_0x104783){var _0x4fde19={};var _0xa2a976={};var _0x15994e;var _0x295e36;return db[_0x6bbb('0x4c')][_0x6bbb('0x65')]({'where':{'id':_0x16293a[_0x6bbb('0x52')]['id']}})[_0x6bbb('0x2a')](handleEntityNotFound(_0x34e44e,null))[_0x6bbb('0x2a')](function(_0x42a0eb){if(_0x42a0eb){_0x15994e=_0x42a0eb;_0xa2a976[_0x6bbb('0x3d')]=_['keys'](db['Team']['rawAttributes']);_0xa2a976[_0x6bbb('0x3e')]=_[_0x6bbb('0x3f')](_0x16293a[_0x6bbb('0x3e')]);_0xa2a976[_0x6bbb('0x40')]=_[_0x6bbb('0x41')](_0xa2a976[_0x6bbb('0x3d')],_0xa2a976['query']);_0x4fde19[_0x6bbb('0x43')]=_[_0x6bbb('0x41')](_0xa2a976[_0x6bbb('0x3d')],qs[_0x6bbb('0x42')](_0x16293a[_0x6bbb('0x3e')]['fields']));_0x4fde19[_0x6bbb('0x43')]=_0x4fde19[_0x6bbb('0x43')][_0x6bbb('0x44')]?_0x4fde19[_0x6bbb('0x43')]:_0xa2a976[_0x6bbb('0x3d')];_0x4fde19[_0x6bbb('0x47')]=qs[_0x6bbb('0x48')](_0x16293a[_0x6bbb('0x3e')][_0x6bbb('0x48')]);_0x4fde19[_0x6bbb('0x4a')]=qs['filters'](_['pick'](_0x16293a[_0x6bbb('0x3e')],_0xa2a976[_0x6bbb('0x40')]));if(_0x16293a[_0x6bbb('0x3e')][_0x6bbb('0x31')]){_0x4fde19[_0x6bbb('0x4a')]=_['merge'](_0x4fde19['where'],{'$or':_['map'](_0x4fde19[_0x6bbb('0x43')],function(_0x5bbbad){var _0x537fbb={};_0x537fbb[_0x5bbbad]={'$like':'%'+_0x16293a['query'][_0x6bbb('0x31')]+'%'};return _0x537fbb;})});}_0x4fde19=_[_0x6bbb('0x4b')]({},_0x4fde19,_0x16293a['options']);return _0x15994e['getTeams'](_0x4fde19);}})[_0x6bbb('0x2a')](function(_0x1b6029){if(_0x1b6029){_0x295e36=_0x1b6029['length'];if(!_0x16293a[_0x6bbb('0x3e')][_0x6bbb('0x45')]('nolimit')){_0x4fde19[_0x6bbb('0x24')]=qs[_0x6bbb('0x24')](_0x16293a[_0x6bbb('0x3e')]['limit']);_0x4fde19[_0x6bbb('0x23')]=qs[_0x6bbb('0x23')](_0x16293a[_0x6bbb('0x3e')]['offset']);}return _0x15994e[_0x6bbb('0x6b')](_0x4fde19);}})['then'](function(_0x57e073){if(_0x57e073){return _0x57e073?{'count':_0x295e36,'rows':_0x57e073}:null;}})[_0x6bbb('0x2a')](respondWithResult(_0x34e44e,null))['catch'](handleError(_0x34e44e,null));};exports[_0x6bbb('0x6c')]=function(_0x123e08,_0x40a25a,_0x3deb5e){var _0x364556=_0x123e08[_0x6bbb('0x60')][_0x6bbb('0x6d')];var _0x567501=_['map'](_0x364556,'id');return db[_0x6bbb('0x6e')][_0x6bbb('0x4e')]({'where':{'id':_0x567501},'attributes':['id'],'include':[{'model':db[_0x6bbb('0x6f')],'as':_0x6bbb('0x70'),'attributes':['id','name',_0x6bbb('0x71'),_0x6bbb('0x72'),_0x6bbb('0x73')],'raw':!![]}]})[_0x6bbb('0x2a')](function(_0x3b39b2){if(_0x3b39b2){var _0x487dcf=_['flatMap'](_0x3b39b2,function(_0x17d178){var _0x5f3bc4=_0x17d178['get']({'plain':!![]});_0x5f3bc4[_0x6bbb('0x70')][_0x6bbb('0x74')](function(_0x491df7){_0x491df7[_0x6bbb('0x75')]=_['find'](_0x364556,{'id':_0x5f3bc4['id']})['penalty'];});return _0x5f3bc4[_0x6bbb('0x70')];});return db['VoiceQueue'][_0x6bbb('0x54')]({'where':{'id':_0x123e08[_0x6bbb('0x52')]['id']}})[_0x6bbb('0x2a')](function(_0x14948d){return db[_0x6bbb('0x76')][_0x6bbb('0x77')](function(_0xfd28fc){return _0x14948d[_0x6bbb('0x6c')](_0x567501,{'transaction':_0xfd28fc})['then'](function(){return BPromise['each'](_0x487dcf,function(_0xffebaf){return db[_0x6bbb('0x78')]['findOrCreate']({'where':{'UserId':_0xffebaf['id'],'VoiceQueueId':_0x123e08['params']['id']},'defaults':{'penalty':_0xffebaf[_0x6bbb('0x75')]},'transaction':_0xfd28fc});});})['then'](function(){return BPromise['each'](_[_0x6bbb('0x31')](_0x487dcf,{'online':!![]}),function(_0x3f49e8){return db['UserVoiceQueueRt'][_0x6bbb('0x79')]({'membername':_0x3f49e8[_0x6bbb('0x37')],'UserId':_0x3f49e8['id'],'queue_name':_0x14948d['name'],'VoiceQueueId':_0x14948d['id'],'interface':_[_0x6bbb('0x7a')](_0x3f49e8['interface'])?util[_0x6bbb('0x7b')](_0x6bbb('0x7c'),_0x3f49e8[_0x6bbb('0x37')]):_0x3f49e8[_0x6bbb('0x73')],'paused':_0x3f49e8[_0x6bbb('0x72')]||![],'penalty':_0x3f49e8[_0x6bbb('0x75')]},{'transaction':_0xfd28fc});});})['then'](function(){_0x487dcf[_0x6bbb('0x74')](function(_0x2150a9){socket[_0x6bbb('0x7d')]('userVoiceQueue:save',{'UserId':_0x2150a9['id'],'VoiceQueueId':_0x14948d['id']});});});});});}})[_0x6bbb('0x2a')](respondWithStatusCode(_0x40a25a,null))[_0x6bbb('0x50')](handleError(_0x40a25a,null));};exports[_0x6bbb('0x7e')]=function(_0xaa3a54,_0x243224,_0x45d4bc){return db['Team']['findAll']({'where':{'id':_0xaa3a54['query'][_0x6bbb('0x7f')]},'attributes':['id'],'include':[{'model':db[_0x6bbb('0x6f')],'as':_0x6bbb('0x70'),'attributes':['id'],'raw':!![]}]})[_0x6bbb('0x2a')](handleEntityNotFound(_0x243224,null))['then'](function(_0x4993b7){var _0x106708=_['map'](_0x4993b7,'id');var _0x54f004=[];var _0x5a1be2=[];var _0x33b5c1=squel[_0x6bbb('0x80')]();_0x33b5c1[_0x6bbb('0x81')](_0x6bbb('0x82'))[_0x6bbb('0x83')]('team_has_voice_queues','tq')[_0x6bbb('0x84')](_0x6bbb('0x85'),'ut',_0x6bbb('0x86'))[_0x6bbb('0x4a')]('VoiceQueueId\x20=\x20?',_0xaa3a54[_0x6bbb('0x52')]['id']);for(var _0x286895=0x0;_0x286895<_0x4993b7[_0x6bbb('0x44')];_0x286895+=0x1){let _0x4622b3=_0x4993b7[_0x286895];for(var _0x216f28=0x0;_0x216f28<_0x4622b3['Agents'][_0x6bbb('0x44')];_0x216f28+=0x1){let _0x2372a7=_0x4622b3['Agents'][_0x216f28];var _0x52e298=_0x33b5c1[_0x6bbb('0x5c')]();_0x52e298[_0x6bbb('0x4a')](_0x6bbb('0x87'),_0x2372a7['id']);_0x5a1be2[_0x6bbb('0x88')](db[_0x6bbb('0x76')][_0x6bbb('0x3e')](_0x52e298[_0x6bbb('0x89')](),{'type':db[_0x6bbb('0x76')]['QueryTypes'][_0x6bbb('0x8a')]})[_0x6bbb('0x2a')](function(_0x5379d1){if(_0x5379d1[_0x6bbb('0x44')]===0x1){return _0x2372a7['id'];}else{var _0x1fd1ac=_[_0x6bbb('0x8b')](_[_0x6bbb('0x33')](_0x5379d1,_0x6bbb('0x8c')),function(_0x4ce90f){return _[_0x6bbb('0x35')](_0x106708,_0x4ce90f);});if(_0x1fd1ac){return _0x2372a7['id'];}}}));}}return BPromise[_0x6bbb('0x8d')](_0x5a1be2)['then'](function(_0x4a4f7d){_0x54f004=_(_0x54f004)[_0x6bbb('0x8e')](_0x4a4f7d)[_0x6bbb('0x8f')]()['value']();return db['VoiceQueue'][_0x6bbb('0x54')]({'where':{'id':_0xaa3a54['params']['id']}})['then'](function(_0x54ac5f){return db['sequelize'][_0x6bbb('0x77')](function(_0x27d8e5){return _0x54ac5f[_0x6bbb('0x7e')](_0xaa3a54[_0x6bbb('0x3e')][_0x6bbb('0x7f')],{'transaction':_0x27d8e5})['then'](function(){if(!_[_0x6bbb('0x90')](_0x54f004)){return _0x54ac5f['removeAgents'](_0x54f004,{'transaction':_0x27d8e5})[_0x6bbb('0x2a')](function(){return db[_0x6bbb('0x91')]['destroy']({'where':{'VoiceQueueId':_0xaa3a54[_0x6bbb('0x52')]['id'],'UserId':_0x54f004},'transaction':_0x27d8e5});});}})[_0x6bbb('0x2a')](function(){_0x54f004['forEach'](function(_0x369bf9){socket[_0x6bbb('0x7d')](_0x6bbb('0x92'),{'UserId':_0x369bf9,'VoiceQueueId':_0x54ac5f['id']});});});});});});})[_0x6bbb('0x2a')](respondWithStatusCode(_0x243224,null))[_0x6bbb('0x50')](handleError(_0x243224,null));};exports[_0x6bbb('0x93')]=function(_0x468465,_0x2d31a2,_0x3c7ea6){var _0x408d98,_0xb914cd;return db['VoiceQueue'][_0x6bbb('0x54')]({'where':{'id':_0x468465[_0x6bbb('0x52')]['id']}})[_0x6bbb('0x2a')](handleEntityNotFound(_0x2d31a2,null))['then'](function(_0xba00ff){if(_0xba00ff){_0xb914cd=_0xba00ff;return _0xba00ff['addAgents'](_0x468465[_0x6bbb('0x60')][_0x6bbb('0x7f')],_[_0x6bbb('0x5e')](_0x468465[_0x6bbb('0x60')],[_0x6bbb('0x7f'),'id'])||{})[_0x6bbb('0x94')](function(_0x599836){for(var _0x565d89=0x0;_0x565d89<_0x468465['body']['ids']['length'];_0x565d89+=0x1){socket[_0x6bbb('0x7d')](_0x6bbb('0x95'),{'UserId':_0x468465[_0x6bbb('0x60')]['ids'][_0x565d89],'VoiceQueueId':_0x468465[_0x6bbb('0x52')]['id']});}return _0x599836;});}})[_0x6bbb('0x2a')](function(_0x4b04a4){_0x408d98=_0x4b04a4||[];if(_0xb914cd){return db[_0x6bbb('0x6f')][_0x6bbb('0x4e')]({'where':{'id':_0x468465[_0x6bbb('0x60')][_0x6bbb('0x7f')]},'attributes':['id',_0x6bbb('0x37'),_0x6bbb('0x71'),_0x6bbb('0x72'),_0x6bbb('0x73')],'raw':!![]});}})[_0x6bbb('0x2a')](function(_0x19c375){if(!_[_0x6bbb('0x90')](_0x19c375)){var _0x1b8e80=[];for(var _0x45738b=0x0;_0x45738b<_0x19c375[_0x6bbb('0x44')];_0x45738b++){if(_0x19c375[_0x45738b][_0x6bbb('0x71')]){_0x1b8e80[_0x6bbb('0x88')](db[_0x6bbb('0x91')]['upsert']({'membername':_0x19c375[_0x45738b][_0x6bbb('0x37')],'UserId':_0x19c375[_0x45738b]['id'],'queue_name':_0xb914cd['name'],'VoiceQueueId':_0xb914cd['id'],'interface':_[_0x6bbb('0x7a')](_0x19c375[_0x45738b][_0x6bbb('0x73')])?util[_0x6bbb('0x7b')](_0x6bbb('0x7c'),_0x19c375[_0x45738b][_0x6bbb('0x37')]):_0x19c375[_0x45738b][_0x6bbb('0x73')],'paused':_0x19c375[_0x45738b][_0x6bbb('0x72')]||![],'penalty':_0x468465[_0x6bbb('0x60')][_0x6bbb('0x75')]||0x0}));}}return BPromise[_0x6bbb('0x8d')](_0x1b8e80);}})[_0x6bbb('0x2a')](function(){return _0x408d98;})[_0x6bbb('0x2a')](respondWithResult(_0x2d31a2,null))[_0x6bbb('0x50')](handleError(_0x2d31a2,null));};exports[_0x6bbb('0x96')]=function(_0x5f144a,_0x32475a,_0x48ab5c){return db['VoiceQueue'][_0x6bbb('0x54')]({'where':{'id':_0x5f144a[_0x6bbb('0x52')]['id']}})[_0x6bbb('0x2a')](handleEntityNotFound(_0x32475a,null))[_0x6bbb('0x2a')](function(_0x187240){if(_0x187240){return _0x187240[_0x6bbb('0x96')](_0x5f144a[_0x6bbb('0x3e')][_0x6bbb('0x7f')])[_0x6bbb('0x2a')](function(){if(_[_0x6bbb('0x97')](_0x5f144a[_0x6bbb('0x3e')]['ids'])){for(var _0x36f793=0x0;_0x36f793<_0x5f144a['query'][_0x6bbb('0x7f')][_0x6bbb('0x44')];_0x36f793+=0x1){socket[_0x6bbb('0x7d')]('userVoiceQueue:remove',{'UserId':Number(_0x5f144a[_0x6bbb('0x3e')][_0x6bbb('0x7f')][_0x36f793]),'VoiceQueueId':Number(_0x5f144a['params']['id'])});}}else{socket[_0x6bbb('0x7d')](_0x6bbb('0x92'),{'UserId':Number(_0x5f144a['query'][_0x6bbb('0x7f')]),'VoiceQueueId':Number(_0x5f144a[_0x6bbb('0x52')]['id'])});}});}})[_0x6bbb('0x2a')](function(_0x32e650){return db['UserVoiceQueueRt'][_0x6bbb('0x2b')]({'where':{'VoiceQueueId':_0x5f144a['params']['id'],'UserId':_0x5f144a[_0x6bbb('0x3e')][_0x6bbb('0x7f')]}})[_0x6bbb('0x2a')](function(){return _0x32e650;});})[_0x6bbb('0x2a')](respondWithStatusCode(_0x32475a,null))['catch'](handleError(_0x32475a,null));};exports[_0x6bbb('0x98')]=function(_0x477b36,_0x361e55,_0x47f77f){var _0x5ef2e5={};var _0x4fc378={};var _0x36f97e;var _0x3b5154;return db[_0x6bbb('0x4c')][_0x6bbb('0x65')]({'where':{'id':_0x477b36[_0x6bbb('0x52')]['id']}})[_0x6bbb('0x2a')](handleEntityNotFound(_0x361e55,null))[_0x6bbb('0x2a')](function(_0x742680){if(_0x742680){_0x36f97e=_0x742680;_0x4fc378[_0x6bbb('0x3d')]=_['keys'](db[_0x6bbb('0x6f')][_0x6bbb('0x3b')]);_0x4fc378[_0x6bbb('0x3e')]=_[_0x6bbb('0x3f')](_0x477b36[_0x6bbb('0x3e')]);_0x4fc378[_0x6bbb('0x40')]=_['intersection'](_0x4fc378[_0x6bbb('0x3d')],_0x4fc378[_0x6bbb('0x3e')]);_0x5ef2e5[_0x6bbb('0x43')]=_['intersection'](_0x4fc378[_0x6bbb('0x3d')],qs[_0x6bbb('0x42')](_0x477b36[_0x6bbb('0x3e')][_0x6bbb('0x42')]));_0x5ef2e5['attributes']=_0x5ef2e5[_0x6bbb('0x43')][_0x6bbb('0x44')]?_0x5ef2e5['attributes']:_0x4fc378[_0x6bbb('0x3d')];_0x5ef2e5['order']=qs['sort'](_0x477b36[_0x6bbb('0x3e')]['sort']);_0x5ef2e5['where']=qs[_0x6bbb('0x40')](_[_0x6bbb('0x49')](_0x477b36[_0x6bbb('0x3e')],_0x4fc378[_0x6bbb('0x40')]));if(_0x477b36['query'][_0x6bbb('0x31')]){_0x5ef2e5[_0x6bbb('0x4a')]=_[_0x6bbb('0x4b')](_0x5ef2e5['where'],{'$or':_[_0x6bbb('0x33')](_0x5ef2e5[_0x6bbb('0x43')],function(_0xe0bdc1){var _0x3c2db5={};_0x3c2db5[_0xe0bdc1]={'$like':'%'+_0x477b36['query']['filter']+'%'};return _0x3c2db5;})});}_0x5ef2e5=_[_0x6bbb('0x4b')]({},_0x5ef2e5,_0x477b36[_0x6bbb('0x53')]);return _0x36f97e[_0x6bbb('0x98')](_0x5ef2e5);}})['then'](function(_0x321cc8){if(_0x321cc8){_0x3b5154=_0x321cc8[_0x6bbb('0x44')];if(!_0x477b36[_0x6bbb('0x3e')][_0x6bbb('0x45')](_0x6bbb('0x46'))){_0x5ef2e5['limit']=qs['limit'](_0x477b36[_0x6bbb('0x3e')][_0x6bbb('0x24')]);_0x5ef2e5[_0x6bbb('0x23')]=qs['offset'](_0x477b36[_0x6bbb('0x3e')][_0x6bbb('0x23')]);}return _0x36f97e[_0x6bbb('0x98')](_0x5ef2e5);}})[_0x6bbb('0x2a')](function(_0x1a485b){if(_0x1a485b){return _0x1a485b?{'count':_0x3b5154,'rows':_0x1a485b}:null;}})[_0x6bbb('0x2a')](respondWithResult(_0x361e55,null))[_0x6bbb('0x50')](handleError(_0x361e55,null));};exports[_0x6bbb('0x99')]=function(_0x5b8a3e,_0x31f689,_0x2112e3){var _0x522954={};var _0xb8ad86={};var _0x4b925a;var _0x1483e0;return db[_0x6bbb('0x4c')][_0x6bbb('0x65')]({'where':{'id':_0x5b8a3e['params']['id']}})['then'](handleEntityNotFound(_0x31f689,null))[_0x6bbb('0x2a')](function(_0x8dbe){if(_0x8dbe){_0x4b925a=_0x8dbe;_0xb8ad86['model']=_[_0x6bbb('0x3f')](db[_0x6bbb('0x91')][_0x6bbb('0x3b')]);_0xb8ad86[_0x6bbb('0x3e')]=_[_0x6bbb('0x3f')](_0x5b8a3e[_0x6bbb('0x3e')]);_0xb8ad86['filters']=_[_0x6bbb('0x41')](_0xb8ad86[_0x6bbb('0x3d')],_0xb8ad86[_0x6bbb('0x3e')]);_0x522954[_0x6bbb('0x43')]=_['intersection'](_0xb8ad86['model'],qs[_0x6bbb('0x42')](_0x5b8a3e['query'][_0x6bbb('0x42')]));_0x522954['attributes']=_0x522954[_0x6bbb('0x43')]['length']?_0x522954[_0x6bbb('0x43')]:_0xb8ad86[_0x6bbb('0x3d')];_0x522954[_0x6bbb('0x47')]=qs[_0x6bbb('0x48')](_0x5b8a3e[_0x6bbb('0x3e')][_0x6bbb('0x48')]);_0x522954[_0x6bbb('0x4a')]=qs[_0x6bbb('0x40')](_[_0x6bbb('0x49')](_0x5b8a3e[_0x6bbb('0x3e')],_0xb8ad86[_0x6bbb('0x40')]));if(_0x5b8a3e[_0x6bbb('0x3e')][_0x6bbb('0x31')]){_0x522954[_0x6bbb('0x4a')]=_[_0x6bbb('0x4b')](_0x522954[_0x6bbb('0x4a')],{'$or':_[_0x6bbb('0x33')](_0x522954['attributes'],function(_0x51ad22){var _0x328ca6={};_0x328ca6[_0x51ad22]={'$like':'%'+_0x5b8a3e[_0x6bbb('0x3e')][_0x6bbb('0x31')]+'%'};return _0x328ca6;})});}_0x522954=_[_0x6bbb('0x4b')]({},_0x522954,_0x5b8a3e[_0x6bbb('0x53')]);return _0x4b925a['getMembers'](_0x522954);}})[_0x6bbb('0x2a')](function(_0x1e732c){if(_0x1e732c){_0x1483e0=_0x1e732c['length'];if(!_0x5b8a3e[_0x6bbb('0x3e')][_0x6bbb('0x45')]('nolimit')){_0x522954['limit']=qs['limit'](_0x5b8a3e[_0x6bbb('0x3e')][_0x6bbb('0x24')]);_0x522954['offset']=qs[_0x6bbb('0x23')](_0x5b8a3e[_0x6bbb('0x3e')][_0x6bbb('0x23')]);}return _0x4b925a['getMembers'](_0x522954);}})[_0x6bbb('0x2a')](function(_0x5f45ab){return _0x5f45ab?{'count':_0x1483e0,'rows':_0x5f45ab}:null;})[_0x6bbb('0x2a')](respondWithResult(_0x31f689,null))['catch'](handleError(_0x31f689,null));};exports[_0x6bbb('0x9a')]=function(_0x2dc41f,_0x21ed3b,_0x1f8a65){var _0x5aae8c={};var _0x4ba63e={};var _0x3cf8da;var _0x566b96;return db[_0x6bbb('0x4c')]['findOne']({'where':{'id':_0x2dc41f['params']['id']}})[_0x6bbb('0x2a')](handleEntityNotFound(_0x21ed3b,null))['then'](function(_0x508f8d){if(_0x508f8d){_0x3cf8da=_0x508f8d;_0x4ba63e['model']=_[_0x6bbb('0x3f')](db['CmList']['rawAttributes']);_0x4ba63e[_0x6bbb('0x3e')]=_[_0x6bbb('0x3f')](_0x2dc41f[_0x6bbb('0x3e')]);_0x4ba63e['filters']=_[_0x6bbb('0x41')](_0x4ba63e[_0x6bbb('0x3d')],_0x4ba63e[_0x6bbb('0x3e')]);_0x5aae8c[_0x6bbb('0x43')]=_[_0x6bbb('0x41')](_0x4ba63e[_0x6bbb('0x3d')],qs[_0x6bbb('0x42')](_0x2dc41f[_0x6bbb('0x3e')][_0x6bbb('0x42')]));_0x5aae8c[_0x6bbb('0x43')]=_0x5aae8c[_0x6bbb('0x43')][_0x6bbb('0x44')]?_0x5aae8c[_0x6bbb('0x43')]:_0x4ba63e['model'];_0x5aae8c[_0x6bbb('0x47')]=qs[_0x6bbb('0x48')](_0x2dc41f[_0x6bbb('0x3e')][_0x6bbb('0x48')]);_0x5aae8c['where']=qs['filters'](_[_0x6bbb('0x49')](_0x2dc41f[_0x6bbb('0x3e')],_0x4ba63e['filters']));if(_0x2dc41f['query'][_0x6bbb('0x31')]){_0x5aae8c[_0x6bbb('0x4a')]=_['merge'](_0x5aae8c[_0x6bbb('0x4a')],{'$or':_[_0x6bbb('0x33')](_0x5aae8c['attributes'],function(_0x4c9748){var _0x144426={};_0x144426[_0x4c9748]={'$like':'%'+_0x2dc41f[_0x6bbb('0x3e')][_0x6bbb('0x31')]+'%'};return _0x144426;})});}_0x5aae8c=_[_0x6bbb('0x4b')]({},_0x5aae8c,_0x2dc41f[_0x6bbb('0x53')]);return _0x3cf8da[_0x6bbb('0x9a')](_0x5aae8c);}})[_0x6bbb('0x2a')](function(_0x4694f6){if(_0x4694f6){_0x566b96=_0x4694f6[_0x6bbb('0x44')];if(!_0x2dc41f[_0x6bbb('0x3e')][_0x6bbb('0x45')](_0x6bbb('0x46'))){_0x5aae8c[_0x6bbb('0x24')]=qs[_0x6bbb('0x24')](_0x2dc41f[_0x6bbb('0x3e')][_0x6bbb('0x24')]);_0x5aae8c[_0x6bbb('0x23')]=qs[_0x6bbb('0x23')](_0x2dc41f['query']['offset']);}return _0x3cf8da[_0x6bbb('0x9a')](_0x5aae8c);}})[_0x6bbb('0x2a')](function(_0xafc3ff){if(_0xafc3ff){return _0xafc3ff?{'count':_0x566b96,'rows':_0xafc3ff}:null;}})['then'](respondWithResult(_0x21ed3b,null))[_0x6bbb('0x50')](handleError(_0x21ed3b,null));};exports[_0x6bbb('0x9b')]=function(_0x16a089,_0x4587a9,_0x94dd9d){var _0x432eb7,_0x4cf5d9;return db[_0x6bbb('0x4c')][_0x6bbb('0x54')]({'where':{'id':_0x16a089[_0x6bbb('0x52')]['id']}})['then'](handleEntityNotFound(_0x4587a9,null))[_0x6bbb('0x2a')](function(_0x53c088){if(_0x53c088){_0x4cf5d9=_0x53c088;return _0x53c088[_0x6bbb('0x9b')](_0x16a089['body'][_0x6bbb('0x7f')],_[_0x6bbb('0x5e')](_0x16a089[_0x6bbb('0x60')],['ids','id'])||{});}return null;})[_0x6bbb('0x94')](function(_0x251641){var _0x16d0ad;_0x432eb7=_0x251641||[];var _0x46d4f9=[];if(_0x251641){for(var _0x5a75cc=0x0;_0x5a75cc<_0x251641[_0x6bbb('0x44')];_0x5a75cc+=0x1){var _0x2e1ef6=_0x251641[_0x5a75cc]['get']({'plain':!![]});_0x4cf5d9[_0x6bbb('0x9c')]=_0x16a089[_0x6bbb('0x60')]['dialCheckDuplicateType']?_0x16a089['body'][_0x6bbb('0x9c')]:_0x4cf5d9[_0x6bbb('0x9c')];switch(_0x4cf5d9[_0x6bbb('0x9c')]){case _0x6bbb('0x9d'):_0x16d0ad=squel['insert']()[_0x6bbb('0x9e')](_0x6bbb('0x9f'))[_0x6bbb('0xa0')]([_0x6bbb('0xa1'),_0x6bbb('0xa2'),_0x6bbb('0xa3'),_0x6bbb('0xa4'),'VoiceQueueId',_0x6bbb('0x5f'),_0x6bbb('0x61')],squel[_0x6bbb('0x80')]()[_0x6bbb('0x81')]('phone','phone')['field']('NOW()',_0x6bbb('0xa2'))[_0x6bbb('0x81')]('id',_0x6bbb('0xa3'))[_0x6bbb('0x81')](_0x2e1ef6[_0x6bbb('0xa5')][_0x6bbb('0x89')](),_0x6bbb('0xa4'))['field'](_0x16a089['params']['id'][_0x6bbb('0x89')](),_0x6bbb('0x66'))['field']('NOW()','createdAt')[_0x6bbb('0x81')](_0x6bbb('0xa6'),_0x6bbb('0x61'))[_0x6bbb('0x83')](_0x6bbb('0xa7'))['where'](_0x6bbb('0xa8'))[_0x6bbb('0x4a')]('ListId\x20=\x20?',_0x2e1ef6[_0x6bbb('0xa5')][_0x6bbb('0x89')]())[_0x6bbb('0x4a')](_0x6bbb('0xa9'))[_0x6bbb('0x4a')](_0x6bbb('0xaa'),squel[_0x6bbb('0x80')]()[_0x6bbb('0x81')](_0x6bbb('0xab'))[_0x6bbb('0x83')](_0x6bbb('0xac'))[_0x6bbb('0x4a')](_0x6bbb('0xad'),_0x16a089[_0x6bbb('0x52')]['id'][_0x6bbb('0x89')]()))['where']('phone\x20NOT\x20IN\x20(?)',squel[_0x6bbb('0x80')]()[_0x6bbb('0x81')](_0x6bbb('0xae'))['from'](_0x6bbb('0x9f'))[_0x6bbb('0x4a')](_0x6bbb('0xad'),_0x16a089[_0x6bbb('0x52')]['id']['toString']())))[_0x6bbb('0x89')]();break;case _0x6bbb('0xaf'):_0x16d0ad=squel[_0x6bbb('0xb0')]()[_0x6bbb('0x9e')](_0x6bbb('0x9f'))[_0x6bbb('0xa0')]([_0x6bbb('0xa1'),_0x6bbb('0xa2'),_0x6bbb('0xa3'),_0x6bbb('0xa4'),_0x6bbb('0x66'),'createdAt',_0x6bbb('0x61')],squel[_0x6bbb('0x80')]()[_0x6bbb('0x81')](_0x6bbb('0xa1'),_0x6bbb('0xa1'))['field'](_0x6bbb('0xa6'),'scheduledAt')[_0x6bbb('0x81')]('id','ContactId')[_0x6bbb('0x81')](_0x2e1ef6[_0x6bbb('0xa5')][_0x6bbb('0x89')](),_0x6bbb('0xa4'))[_0x6bbb('0x81')](_0x16a089['params']['id']['toString'](),_0x6bbb('0x66'))[_0x6bbb('0x81')](_0x6bbb('0xa6'),_0x6bbb('0x5f'))[_0x6bbb('0x81')](_0x6bbb('0xa6'),_0x6bbb('0x61'))[_0x6bbb('0x83')](_0x6bbb('0xa7'))[_0x6bbb('0x4a')](_0x6bbb('0xa8'))[_0x6bbb('0x4a')]('ListId\x20=\x20?',_0x2e1ef6['CmListId'][_0x6bbb('0x89')]())[_0x6bbb('0x4a')]('phone\x20IS\x20NOT\x20NULL')[_0x6bbb('0x4a')](_0x6bbb('0xaa'),squel[_0x6bbb('0x80')]()['field'](_0x6bbb('0xae'))[_0x6bbb('0x83')](_0x6bbb('0x9f'))[_0x6bbb('0x4a')]('VoiceQueueId\x20=\x20?',_0x16a089[_0x6bbb('0x52')]['id'][_0x6bbb('0x89')]())))[_0x6bbb('0x89')]();break;default:_0x16d0ad=squel[_0x6bbb('0xb0')]()[_0x6bbb('0x9e')]('cm_hopper')[_0x6bbb('0xa0')]([_0x6bbb('0xa1'),_0x6bbb('0xa2'),_0x6bbb('0xa3'),_0x6bbb('0xa4'),_0x6bbb('0x66'),_0x6bbb('0x5f'),'updatedAt'],squel[_0x6bbb('0x80')]()[_0x6bbb('0x81')]('phone',_0x6bbb('0xa1'))['field']('NOW()','scheduledAt')['field']('id',_0x6bbb('0xa3'))[_0x6bbb('0x81')](_0x2e1ef6[_0x6bbb('0xa5')]['toString'](),'ListId')[_0x6bbb('0x81')](_0x16a089[_0x6bbb('0x52')]['id'][_0x6bbb('0x89')](),_0x6bbb('0x66'))[_0x6bbb('0x81')](_0x6bbb('0xa6'),'createdAt')['field'](_0x6bbb('0xa6'),'updatedAt')['from']('cm_contacts')[_0x6bbb('0x4a')]('deletedAt\x20IS\x20NULL')[_0x6bbb('0x4a')](_0x6bbb('0xb1'),_0x2e1ef6[_0x6bbb('0xa5')]['toString']())[_0x6bbb('0x4a')](_0x6bbb('0xa9')))[_0x6bbb('0x89')]();}_0x46d4f9[_0x6bbb('0x88')](db[_0x6bbb('0x76')][_0x6bbb('0x3e')](_0x16d0ad));}return BPromise[_0x6bbb('0x8d')](_0x46d4f9);}})[_0x6bbb('0x2a')](function(){return _0x432eb7;})['then'](respondWithResult(_0x4587a9,null))['catch'](handleError(_0x4587a9,null));};exports[_0x6bbb('0xb2')]=function(_0x311fe7,_0x11be23,_0x5869a1){return db[_0x6bbb('0x4c')][_0x6bbb('0x54')]({'where':{'id':_0x311fe7[_0x6bbb('0x52')]['id']}})[_0x6bbb('0x2a')](handleEntityNotFound(_0x11be23,null))[_0x6bbb('0x2a')](function(_0x3c5c1c){if(_0x3c5c1c){return _0x3c5c1c['removeLists'](_0x311fe7[_0x6bbb('0x3e')]['ids']);}})[_0x6bbb('0x2a')](function(_0x2faef4){if(_0x2faef4){return db[_0x6bbb('0x67')][_0x6bbb('0x2b')]({'where':{'ListId':_0x311fe7[_0x6bbb('0x3e')]['ids'],'VoiceQueueId':_0x311fe7[_0x6bbb('0x52')]['id']}})[_0x6bbb('0x2a')](function(){return _0x2faef4;});}})['then'](respondWithStatusCode(_0x11be23,null))[_0x6bbb('0x50')](handleError(_0x11be23,null));};exports[_0x6bbb('0xb3')]=function(_0x5bb88f,_0x4dd078,_0x2f090f){var _0x2419ab={};var _0x4485b7={};var _0x1bdd16;var _0x2f2bda;return db[_0x6bbb('0x4c')]['findOne']({'where':{'id':_0x5bb88f['params']['id']}})[_0x6bbb('0x2a')](handleEntityNotFound(_0x4dd078,null))[_0x6bbb('0x2a')](function(_0x2081ca){if(_0x2081ca){_0x1bdd16=_0x2081ca;_0x4485b7[_0x6bbb('0x3d')]=_[_0x6bbb('0x3f')](db[_0x6bbb('0xb4')][_0x6bbb('0x3b')]);_0x4485b7[_0x6bbb('0x3e')]=_[_0x6bbb('0x3f')](_0x5bb88f[_0x6bbb('0x3e')]);_0x4485b7[_0x6bbb('0x40')]=_[_0x6bbb('0x41')](_0x4485b7[_0x6bbb('0x3d')],_0x4485b7[_0x6bbb('0x3e')]);_0x2419ab[_0x6bbb('0x43')]=_[_0x6bbb('0x41')](_0x4485b7[_0x6bbb('0x3d')],qs[_0x6bbb('0x42')](_0x5bb88f[_0x6bbb('0x3e')][_0x6bbb('0x42')]));_0x2419ab['attributes']=_0x2419ab[_0x6bbb('0x43')]['length']?_0x2419ab['attributes']:_0x4485b7[_0x6bbb('0x3d')];_0x2419ab['order']=qs[_0x6bbb('0x48')](_0x5bb88f[_0x6bbb('0x3e')]['sort']);_0x2419ab[_0x6bbb('0x4a')]=qs['filters'](_[_0x6bbb('0x49')](_0x5bb88f[_0x6bbb('0x3e')],_0x4485b7[_0x6bbb('0x40')]));if(_0x5bb88f[_0x6bbb('0x3e')]['filter']){_0x2419ab[_0x6bbb('0x4a')]=_[_0x6bbb('0x4b')](_0x2419ab[_0x6bbb('0x4a')],{'$or':_[_0x6bbb('0x33')](_0x2419ab[_0x6bbb('0x43')],function(_0x444274){var _0x1e592d={};_0x1e592d[_0x444274]={'$like':'%'+_0x5bb88f[_0x6bbb('0x3e')][_0x6bbb('0x31')]+'%'};return _0x1e592d;})});}_0x2419ab=_[_0x6bbb('0x4b')]({},_0x2419ab,_0x5bb88f[_0x6bbb('0x53')]);return _0x1bdd16[_0x6bbb('0xb3')](_0x2419ab);}})[_0x6bbb('0x2a')](function(_0x1a6d10){if(_0x1a6d10){_0x2f2bda=_0x1a6d10['length'];if(!_0x5bb88f[_0x6bbb('0x3e')]['hasOwnProperty'](_0x6bbb('0x46'))){_0x2419ab['limit']=qs[_0x6bbb('0x24')](_0x5bb88f[_0x6bbb('0x3e')]['limit']);_0x2419ab['offset']=qs[_0x6bbb('0x23')](_0x5bb88f[_0x6bbb('0x3e')][_0x6bbb('0x23')]);}return _0x1bdd16[_0x6bbb('0xb3')](_0x2419ab);}})[_0x6bbb('0x2a')](function(_0x5abc8e){if(_0x5abc8e){return _0x5abc8e?{'count':_0x2f2bda,'rows':_0x5abc8e}:null;}})['then'](respondWithResult(_0x4dd078,null))[_0x6bbb('0x50')](handleError(_0x4dd078,null));};exports['addBlackLists']=function(_0xe58d9c,_0x4e4986,_0x229b2b){var _0x535629,_0x14c47f;return db['VoiceQueue']['find']({'where':{'id':_0xe58d9c['params']['id']}})[_0x6bbb('0x2a')](handleEntityNotFound(_0x4e4986,null))['then'](function(_0x5dd104){if(_0x5dd104){_0x14c47f=_0x5dd104;return _0x5dd104[_0x6bbb('0xb5')](_0xe58d9c['body'][_0x6bbb('0x7f')],_[_0x6bbb('0x5e')](_0xe58d9c[_0x6bbb('0x60')],[_0x6bbb('0x7f'),'id'])||{});}return null;})[_0x6bbb('0x94')](function(_0x33a759){var _0x24080a;_0x535629=_0x33a759||[];var _0x25b645=[];if(_0x33a759){for(var _0x58a835=0x0;_0x58a835<_0x33a759[_0x6bbb('0x44')];_0x58a835+=0x1){var _0x2e49a2=_0x33a759[_0x58a835][_0x6bbb('0x2c')]({'plain':!![]});_0x24080a=squel[_0x6bbb('0xb0')]()[_0x6bbb('0x9e')](_0x6bbb('0xb6'))['fromQuery']([_0x6bbb('0xa1'),_0x6bbb('0xa3'),_0x6bbb('0xa4'),_0x6bbb('0x66'),'createdAt',_0x6bbb('0x61')],squel[_0x6bbb('0x80')]()[_0x6bbb('0x81')]('phone','phone')[_0x6bbb('0x81')]('id',_0x6bbb('0xa3'))[_0x6bbb('0x81')](_0x2e49a2[_0x6bbb('0xa5')]['toString'](),_0x6bbb('0xa4'))['field'](_0xe58d9c[_0x6bbb('0x52')]['id'][_0x6bbb('0x89')](),_0x6bbb('0x66'))[_0x6bbb('0x81')](_0x6bbb('0xa6'),'createdAt')['field'](_0x6bbb('0xa6'),'updatedAt')[_0x6bbb('0x83')](_0x6bbb('0xa7'))['where']('deletedAt\x20IS\x20NULL')[_0x6bbb('0x4a')](_0x6bbb('0xb1'),_0x2e49a2[_0x6bbb('0xa5')][_0x6bbb('0x89')]())['where'](_0x6bbb('0xa9')))[_0x6bbb('0x89')]();_0x25b645['push'](db[_0x6bbb('0x76')][_0x6bbb('0x3e')](_0x24080a));}return BPromise[_0x6bbb('0x8d')](_0x25b645);}})[_0x6bbb('0x2a')](function(){return _0x535629;})[_0x6bbb('0x2a')](respondWithResult(_0x4e4986,null))[_0x6bbb('0x50')](handleError(_0x4e4986,null));};exports['removeBlackLists']=function(_0xfc1e13,_0x3eb7b0,_0x16ec36){return db[_0x6bbb('0x4c')][_0x6bbb('0x54')]({'where':{'id':_0xfc1e13[_0x6bbb('0x52')]['id']}})['then'](handleEntityNotFound(_0x3eb7b0,null))['then'](function(_0x854755){if(_0x854755){return _0x854755[_0x6bbb('0xb7')](_0xfc1e13['query'][_0x6bbb('0x7f')]);}})[_0x6bbb('0x2a')](function(_0xd7813f){if(_0xd7813f){return db[_0x6bbb('0x6a')][_0x6bbb('0x2b')]({'where':{'ListId':_0xfc1e13['query'][_0x6bbb('0x7f')],'VoiceQueueId':_0xfc1e13[_0x6bbb('0x52')]['id']}})['then'](function(){return _0xd7813f;});}})[_0x6bbb('0x2a')](respondWithStatusCode(_0x3eb7b0,null))[_0x6bbb('0x50')](handleError(_0x3eb7b0,null));};