efa4a5b07e59a29b00f980c4f141d8b3a3353161
[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 _0x0309=['./voiceQueue.socket','register','sendStatus','status','end','json','offset','undefined','limit','count','Content-Range','then','get','VoiceQueues','inbound','QueueCampaigns','outbound','filter','ignore','map','value','type','find','name','UserProfileResource','error','stack','send','index','VoiceQueue','rawAttributes','model','query','keys','intersection','fields','attributes','length','nolimit','order','sort','where','filters','pick','merge','VIRTUAL','options','includeAll','include','catch','show','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','autoAssociation','clone','params','omit','createdAt','updatedAt','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','destroy','getHoppers','findOne','CmHopper','hasOwnProperty','rows','getHopperHistories','CmHopperHistory','VoiceQueueId','findAll','getHopperFinals','CmHopperFinal','getHopperBlacks','CmHopperBlack','getTeams','addTeams','teams','User','Agents','online','voicePause','interface','flatMap','forEach','penalty','sequelize','transaction','each','TeamVoiceQueue','upsert','isNil','format','emit','userVoiceQueue:save','removeTeams','Team','ids','select','field','tq.TeamId','from','team_has_voice_queues','user_has_teams','ut.TeamId\x20=\x20tq.TeamId','VoiceQueueId\x20=\x20?','push','SELECT','every','includes','all','compact','isEmpty','UserVoiceQueueRt','userVoiceQueue:remove','addAgents','spread','isArray','getAgents','getMembers','getLists','addLists','YYYY-MM-DD\x20HH:mm:ss','dialCheckDuplicateType','always','insert','into','cm_hopper','fromQuery','scheduledAt','ContactId','ListId','CmListId','toString','cm_contacts','ListId\x20=\x20?','COALESCE(calleridnum,\x27\x27)','cm_hopper_final','phone\x20NOT\x20IN\x20(?)','COALESCE(phone,\x27\x27)','onlyIfOpen','phone','deletedAt\x20IS\x20NULL','phone\x20IS\x20NOT\x20NULL','cm_hopper_additional_phones','CmHopperId','OrderBy','ci.item','ci.OrderBy+1','cm_contact_has_items','join','h.ContactId=ci.CmContactId','h.scheduledat=?','ci.ItemClass=?','PHONE','removeLists','CmList','getBlackLists','addBlackLists','NOW()','removeBlackLists','eml-format','zip-dir','request-promise','moment','bluebird','mustache','util','path','sox','fs-extra','lodash','crypto','desk.js','to-csv','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','defaults','redis','localhost','socket.io-emitter'];(function(_0xf9a3e9,_0x62a6e1){var _0x20473c=function(_0x5e605a){while(--_0x5e605a){_0xf9a3e9['push'](_0xf9a3e9['shift']());}};_0x20473c(++_0x62a6e1);}(_0x0309,0x165));var _0x9030=function(_0x3ebce3,_0x530811){_0x3ebce3=_0x3ebce3-0x0;var _0x66897b=_0x0309[_0x3ebce3];return _0x66897b;};'use strict';var emlformat=require(_0x9030('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x9030('0x1'));var jsonpatch=require('fast-json-patch');var rp=require(_0x9030('0x2'));var moment=require(_0x9030('0x3'));var BPromise=require(_0x9030('0x4'));var Mustache=require(_0x9030('0x5'));var util=require(_0x9030('0x6'));var path=require(_0x9030('0x7'));var sox=require(_0x9030('0x8'));var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x9030('0x9'));var _=require(_0x9030('0xa'));var squel=require('squel');var crypto=require(_0x9030('0xb'));var jsforce=require('jsforce');var deskjs=require(_0x9030('0xc'));var toCsv=require(_0x9030('0xd'));var querystring=require(_0x9030('0xe'));var Papa=require('papaparse');var Redis=require(_0x9030('0xf'));var authService=require(_0x9030('0x10'));var qs=require(_0x9030('0x11'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x9030('0x12'));var logger=require(_0x9030('0x13'))(_0x9030('0x14'));var utils=require(_0x9030('0x15'));var config=require(_0x9030('0x16'));var licenseUtil=require(_0x9030('0x17'));var db=require(_0x9030('0x18'))['db'];config['redis']=_[_0x9030('0x19')](config[_0x9030('0x1a')],{'host':_0x9030('0x1b'),'port':0x18eb});var socket=require(_0x9030('0x1c'))(new Redis(config['redis']));require(_0x9030('0x1d'))[_0x9030('0x1e')](socket);function respondWithStatusCode(_0x4a7465,_0x41e659){_0x41e659=_0x41e659||0xcc;return function(_0x4d697a){if(_0x4d697a){return _0x4a7465[_0x9030('0x1f')](_0x41e659);}return _0x4a7465[_0x9030('0x20')](_0x41e659)[_0x9030('0x21')]();};}function respondWithResult(_0xfc6f46,_0x55ac94){_0x55ac94=_0x55ac94||0xc8;return function(_0x213040){if(_0x213040){return _0xfc6f46[_0x9030('0x20')](_0x55ac94)[_0x9030('0x22')](_0x213040);}};}function respondWithFilteredResult(_0x37afac,_0x319db3){return function(_0x1327ec){if(_0x1327ec){var _0x229dcd=typeof _0x319db3[_0x9030('0x23')]===_0x9030('0x24')&&typeof _0x319db3[_0x9030('0x25')]===_0x9030('0x24');var _0x41d506=_0x1327ec[_0x9030('0x26')];var _0x243e7d=_0x229dcd?0x0:_0x319db3[_0x9030('0x23')];var _0x285d93=_0x229dcd?_0x1327ec[_0x9030('0x26')]:_0x319db3['offset']+_0x319db3['limit'];var _0x364d58;if(_0x285d93>=_0x41d506){_0x285d93=_0x41d506;_0x364d58=0xc8;}else{_0x364d58=0xce;}_0x37afac[_0x9030('0x20')](_0x364d58);return _0x37afac['set'](_0x9030('0x27'),_0x243e7d+'-'+_0x285d93+'/'+_0x41d506)[_0x9030('0x22')](_0x1327ec);}return null;};}function patchUpdates(_0x1f806a){return function(_0x3c14ec){try{jsonpatch['apply'](_0x3c14ec,_0x1f806a,!![]);}catch(_0x4753b2){return BPromise['reject'](_0x4753b2);}return _0x3c14ec['save']();};}function saveUpdates(_0xe65792,_0x2b205c){return function(_0xcea904){if(_0xcea904){return _0xcea904['update'](_0xe65792)[_0x9030('0x28')](function(_0x408ce6){return _0x408ce6;});}return null;};}function removeEntity(_0x35adfe,_0xce2840){return function(_0x43ca87){if(_0x43ca87){return _0x43ca87['destroy']()[_0x9030('0x28')](function(){var _0x455eeb=_0x43ca87[_0x9030('0x29')]({'plain':!![]});var _0x463dda=[{'name':_0x9030('0x2a'),'value':_0x9030('0x2b'),'ignore':![]},{'name':_0x9030('0x2c'),'value':_0x9030('0x2d'),'ignore':![]}];var _0x26a803=_(_0x463dda)[_0x9030('0x2e')](_0x9030('0x2f'))[_0x9030('0x30')](_0x9030('0x31'))[_0x9030('0x31')]();if(_['includes'](_0x26a803,_0x455eeb[_0x9030('0x32')])){return;}var _0x4b042c=_[_0x9030('0x33')](_0x463dda,['value',_0x455eeb[_0x9030('0x32')]])[_0x9030('0x34')];return db[_0x9030('0x35')]['destroy']({'where':{'type':_0x4b042c,'resourceId':_0x455eeb['id']}})[_0x9030('0x28')](function(){return _0x43ca87;});})[_0x9030('0x28')](function(){_0x35adfe[_0x9030('0x20')](0xcc)[_0x9030('0x21')]();});}};}function handleEntityNotFound(_0xe2f7c1,_0x14619b){return function(_0x754e00){if(!_0x754e00){_0xe2f7c1[_0x9030('0x1f')](0x194);}return _0x754e00;};}function handleError(_0x134260,_0x3400db){_0x3400db=_0x3400db||0x1f4;return function(_0x42fbf8){logger[_0x9030('0x36')](_0x42fbf8[_0x9030('0x37')]);if(_0x42fbf8[_0x9030('0x34')]){delete _0x42fbf8[_0x9030('0x34')];}_0x134260[_0x9030('0x20')](_0x3400db)[_0x9030('0x38')](_0x42fbf8);};}exports[_0x9030('0x39')]=function(_0x54ebae,_0x582e57){var _0x3779bc={},_0x29ffda={},_0x56c0c6={'count':0x0,'rows':[]};var _0x58cea7=_[_0x9030('0x30')](db[_0x9030('0x3a')][_0x9030('0x3b')],function(_0x3ffd44){return{'name':_0x3ffd44['fieldName'],'type':_0x3ffd44[_0x9030('0x32')]['key']};});_0x29ffda[_0x9030('0x3c')]=_[_0x9030('0x30')](_0x58cea7,'name');_0x29ffda[_0x9030('0x3d')]=_[_0x9030('0x3e')](_0x54ebae[_0x9030('0x3d')]);_0x29ffda['filters']=_[_0x9030('0x3f')](_0x29ffda['model'],_0x29ffda[_0x9030('0x3d')]);_0x3779bc['attributes']=_[_0x9030('0x3f')](_0x29ffda['model'],qs[_0x9030('0x40')](_0x54ebae[_0x9030('0x3d')][_0x9030('0x40')]));_0x3779bc[_0x9030('0x41')]=_0x3779bc[_0x9030('0x41')][_0x9030('0x42')]?_0x3779bc[_0x9030('0x41')]:_0x29ffda[_0x9030('0x3c')];if(!_0x54ebae[_0x9030('0x3d')]['hasOwnProperty'](_0x9030('0x43'))){_0x3779bc[_0x9030('0x25')]=qs[_0x9030('0x25')](_0x54ebae['query'][_0x9030('0x25')]);_0x3779bc[_0x9030('0x23')]=qs[_0x9030('0x23')](_0x54ebae[_0x9030('0x3d')]['offset']);}_0x3779bc[_0x9030('0x44')]=qs[_0x9030('0x45')](_0x54ebae[_0x9030('0x3d')]['sort']);_0x3779bc[_0x9030('0x46')]=qs[_0x9030('0x47')](_[_0x9030('0x48')](_0x54ebae[_0x9030('0x3d')],_0x29ffda[_0x9030('0x47')]),_0x58cea7);if(_0x54ebae['query'][_0x9030('0x2e')]){_0x3779bc['where']=_[_0x9030('0x49')](_0x3779bc[_0x9030('0x46')],{'$or':_[_0x9030('0x30')](_0x58cea7,function(_0x435eb8){if(_0x435eb8[_0x9030('0x32')]!==_0x9030('0x4a')){var _0x355f82={};_0x355f82[_0x435eb8[_0x9030('0x34')]]={'$like':'%'+_0x54ebae['query'][_0x9030('0x2e')]+'%'};return _0x355f82;}})});}_0x3779bc=_[_0x9030('0x49')]({},_0x3779bc,_0x54ebae[_0x9030('0x4b')]);var _0x2b6270={'where':_0x3779bc[_0x9030('0x46')]};return db[_0x9030('0x3a')][_0x9030('0x26')](_0x2b6270)[_0x9030('0x28')](function(_0x141f97){_0x56c0c6[_0x9030('0x26')]=_0x141f97;if(_0x54ebae[_0x9030('0x3d')][_0x9030('0x4c')]){_0x3779bc[_0x9030('0x4d')]=[{'all':!![]}];}return db[_0x9030('0x3a')]['findAll'](_0x3779bc);})[_0x9030('0x28')](function(_0x2e0283){_0x56c0c6['rows']=_0x2e0283;return _0x56c0c6;})[_0x9030('0x28')](respondWithFilteredResult(_0x582e57,_0x3779bc))[_0x9030('0x4e')](handleError(_0x582e57,null));};exports[_0x9030('0x4f')]=function(_0x4c3e62,_0x53030b){var _0x16154f={'raw':![],'where':{'id':_0x4c3e62['params']['id']}},_0x4d8197={};_0x4d8197[_0x9030('0x3c')]=_[_0x9030('0x3e')](db[_0x9030('0x3a')][_0x9030('0x3b')]);_0x4d8197['query']=_[_0x9030('0x3e')](_0x4c3e62['query']);_0x4d8197[_0x9030('0x47')]=_[_0x9030('0x3f')](_0x4d8197[_0x9030('0x3c')],_0x4d8197['query']);_0x16154f[_0x9030('0x41')]=_[_0x9030('0x3f')](_0x4d8197[_0x9030('0x3c')],qs['fields'](_0x4c3e62[_0x9030('0x3d')][_0x9030('0x40')]));_0x16154f['attributes']=_0x16154f[_0x9030('0x41')]['length']?_0x16154f[_0x9030('0x41')]:_0x4d8197['model'];if(_0x4c3e62[_0x9030('0x3d')][_0x9030('0x4c')]){_0x16154f[_0x9030('0x4d')]=[{'all':!![]}];}_0x16154f=_[_0x9030('0x49')]({},_0x16154f,_0x4c3e62[_0x9030('0x4b')]);return db[_0x9030('0x3a')]['find'](_0x16154f)[_0x9030('0x28')](handleEntityNotFound(_0x53030b,null))[_0x9030('0x28')](respondWithResult(_0x53030b,null))[_0x9030('0x4e')](handleError(_0x53030b,null));};exports[_0x9030('0x50')]=function(_0x127c87,_0x573088){return db['VoiceQueue'][_0x9030('0x50')](_0x127c87[_0x9030('0x51')],{})[_0x9030('0x28')](function(_0x241080){var _0x205d6f=_0x127c87[_0x9030('0x52')][_0x9030('0x29')]({'plain':!![]});if(!_0x205d6f)throw new Error(_0x9030('0x53'));if(_0x205d6f[_0x9030('0x54')]===_0x9030('0x52')){var _0x297a84=_0x241080[_0x9030('0x29')]({'plain':!![]});var _0x3092f8=[{'name':'VoiceQueues','value':_0x9030('0x2b')},{'name':_0x9030('0x2c'),'value':'outbound'}];var _0x5c4218=_[_0x9030('0x33')](_0x3092f8,[_0x9030('0x31'),_0x297a84[_0x9030('0x32')]])[_0x9030('0x34')];return db[_0x9030('0x55')][_0x9030('0x33')]({'where':{'name':_0x5c4218,'userProfileId':_0x205d6f['userProfileId']},'raw':!![]})['then'](function(_0x2051d9){if(_0x2051d9&&_0x2051d9[_0x9030('0x56')]===0x0){return db[_0x9030('0x35')][_0x9030('0x50')]({'name':_0x297a84['name'],'resourceId':_0x297a84['id'],'type':_0x2051d9[_0x9030('0x34')],'sectionId':_0x2051d9['id']},{})[_0x9030('0x28')](function(){return _0x241080;});}else{return _0x241080;}})[_0x9030('0x4e')](function(_0x326782){logger[_0x9030('0x36')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x326782);throw _0x326782;});}return _0x241080;})['then'](respondWithResult(_0x573088,0xc9))[_0x9030('0x4e')](handleError(_0x573088,null));};exports[_0x9030('0x57')]=function(_0x25719b,_0x19f84e){var _0x3f3153={'where':{'id':_0x25719b[_0x9030('0x58')]['id']}},_0x17bf72={};_0x17bf72[_0x9030('0x3c')]=_[_0x9030('0x3e')](db[_0x9030('0x3a')]['rawAttributes']);_0x3f3153[_0x9030('0x41')]=_[_0x9030('0x3f')](_0x17bf72[_0x9030('0x3c')],qs[_0x9030('0x40')](_0x25719b[_0x9030('0x3d')][_0x9030('0x40')]));_0x3f3153[_0x9030('0x41')]=_0x3f3153['attributes']['length']?_0x3f3153[_0x9030('0x41')]:_0x17bf72[_0x9030('0x3c')];if(_0x25719b[_0x9030('0x3d')][_0x9030('0x4c')]){_0x3f3153[_0x9030('0x4d')]=[{'all':!![]}];}_0x3f3153=_[_0x9030('0x49')]({},_0x3f3153,_0x25719b[_0x9030('0x4b')]);return db['VoiceQueue']['find'](_0x3f3153)['then'](handleEntityNotFound(_0x19f84e,null))[_0x9030('0x28')](function(_0x580722){if(_0x580722){var _0x1cd8f5=_0x580722['get']({'plain':!![]});_0x1cd8f5=qs[_0x9030('0x59')](_0x1cd8f5,['id',_0x9030('0x5a'),_0x9030('0x5b')]);_0x25719b[_0x9030('0x51')]=_[_0x9030('0x59')](_0x25719b[_0x9030('0x51')],['id',_0x9030('0x5a'),_0x9030('0x5b')]);return db[_0x9030('0x3a')][_0x9030('0x50')](_[_0x9030('0x49')](_0x1cd8f5,_0x25719b[_0x9030('0x51')]),{'include':_0x25719b[_0x9030('0x3d')][_0x9030('0x4c')]?[{'all':!![]}]:undefined})['then'](function(_0x119835){var _0x3f381e=_0x25719b[_0x9030('0x52')][_0x9030('0x29')]({'plain':!![]});if(!_0x3f381e)throw new Error(_0x9030('0x53'));if(_0x3f381e[_0x9030('0x54')]==='user'){var _0x1f6ed9=_0x119835[_0x9030('0x29')]({'plain':!![]});var _0x299594=[{'name':_0x9030('0x2a'),'value':_0x9030('0x2b')},{'name':'QueueCampaigns','value':_0x9030('0x2d')}];var _0x486786=_[_0x9030('0x33')](_0x299594,['value',_0x1f6ed9[_0x9030('0x32')]])[_0x9030('0x34')];return db['UserProfileSection']['find']({'where':{'name':_0x486786,'userProfileId':_0x3f381e['userProfileId']},'raw':!![]})[_0x9030('0x28')](function(_0x4a397a){if(_0x4a397a&&_0x4a397a[_0x9030('0x56')]===0x0){return db[_0x9030('0x35')][_0x9030('0x50')]({'name':_0x1f6ed9['name'],'resourceId':_0x1f6ed9['id'],'type':_0x4a397a[_0x9030('0x34')],'sectionId':_0x4a397a['id']},{})[_0x9030('0x28')](function(){return _0x119835;});}else{return _0x119835;}})[_0x9030('0x4e')](function(_0x6cb4bd){logger['error'](_0x9030('0x5c'),_0x6cb4bd);throw _0x6cb4bd;});}return _0x119835;});}})[_0x9030('0x28')](respondWithResult(_0x19f84e,0xc9))[_0x9030('0x4e')](handleError(_0x19f84e,null));};exports['update']=function(_0x1b4ca5,_0x24973e){if(_0x1b4ca5['body']['id']){delete _0x1b4ca5[_0x9030('0x51')]['id'];}return db[_0x9030('0x3a')][_0x9030('0x33')]({'where':{'id':_0x1b4ca5['params']['id']}})[_0x9030('0x28')](handleEntityNotFound(_0x24973e,null))['then'](saveUpdates(_0x1b4ca5[_0x9030('0x51')],null))[_0x9030('0x28')](respondWithResult(_0x24973e,null))[_0x9030('0x4e')](handleError(_0x24973e,null));};exports[_0x9030('0x5d')]=function(_0x18dfac,_0x156f46){return db[_0x9030('0x3a')]['find']({'where':{'id':_0x18dfac[_0x9030('0x58')]['id']}})['then'](handleEntityNotFound(_0x156f46,null))[_0x9030('0x28')](removeEntity(_0x156f46,null))[_0x9030('0x4e')](handleError(_0x156f46,null));};exports[_0x9030('0x5e')]=function(_0x2e19e5,_0x338c2b,_0x55ecc6){var _0x53e328={'raw':![],'where':{}};var _0x563ead={};var _0x2148e5={'count':0x0,'rows':[]};return db[_0x9030('0x3a')][_0x9030('0x5f')]({'where':{'id':_0x2e19e5['params']['id']}})[_0x9030('0x28')](handleEntityNotFound(_0x338c2b,null))[_0x9030('0x28')](function(_0x1eb537){if(_0x1eb537){_0x563ead['model']=_[_0x9030('0x3e')](db[_0x9030('0x60')][_0x9030('0x3b')]);_0x563ead[_0x9030('0x3d')]=_[_0x9030('0x3e')](_0x2e19e5['query']);_0x563ead[_0x9030('0x47')]=_[_0x9030('0x3f')](_0x563ead[_0x9030('0x3c')],_0x563ead['query']);_0x53e328[_0x9030('0x41')]=_[_0x9030('0x3f')](_0x563ead[_0x9030('0x3c')],qs[_0x9030('0x40')](_0x2e19e5['query']['fields']));_0x53e328[_0x9030('0x41')]=_0x53e328[_0x9030('0x41')][_0x9030('0x42')]?_0x53e328[_0x9030('0x41')]:_0x563ead[_0x9030('0x3c')];if(!_0x2e19e5['query'][_0x9030('0x61')](_0x9030('0x43'))){_0x53e328[_0x9030('0x25')]=qs[_0x9030('0x25')](_0x2e19e5[_0x9030('0x3d')]['limit']);_0x53e328[_0x9030('0x23')]=qs['offset'](_0x2e19e5[_0x9030('0x3d')][_0x9030('0x23')]);}_0x53e328[_0x9030('0x44')]=qs['sort'](_0x2e19e5['query'][_0x9030('0x45')]);_0x53e328[_0x9030('0x46')]=qs[_0x9030('0x47')](_[_0x9030('0x48')](_0x2e19e5[_0x9030('0x3d')],_0x563ead[_0x9030('0x47')]));_0x53e328[_0x9030('0x46')]['VoiceQueueId']=_0x1eb537['id'];if(_0x2e19e5[_0x9030('0x3d')][_0x9030('0x2e')]){_0x53e328['where']=_[_0x9030('0x49')](_0x53e328[_0x9030('0x46')],{'$or':_[_0x9030('0x30')](_0x53e328[_0x9030('0x41')],function(_0x346368){var _0x286d5d={};_0x286d5d[_0x346368]={'$like':'%'+_0x2e19e5[_0x9030('0x3d')][_0x9030('0x2e')]+'%'};return _0x286d5d;})});}_0x53e328=_[_0x9030('0x49')]({},_0x53e328,_0x2e19e5['options']);return db[_0x9030('0x60')]['count']({'where':_0x53e328['where']})['then'](function(_0x39414f){_0x2148e5[_0x9030('0x26')]=_0x39414f;if(_0x2e19e5[_0x9030('0x3d')][_0x9030('0x4c')]){_0x53e328[_0x9030('0x4d')]=[{'all':!![]}];}return db[_0x9030('0x60')]['findAll'](_0x53e328);})[_0x9030('0x28')](function(_0x78850b){_0x2148e5[_0x9030('0x62')]=_0x78850b;return _0x2148e5;});}})[_0x9030('0x28')](respondWithFilteredResult(_0x338c2b,_0x53e328))[_0x9030('0x4e')](handleError(_0x338c2b,null));};exports[_0x9030('0x63')]=function(_0x228c78,_0x39e215,_0x208a8d){var _0x14528a={'raw':!![],'where':{}};var _0x73b926={};var _0x1fad1b={'count':0x0,'rows':[]};return db[_0x9030('0x3a')]['findOne']({'where':{'id':_0x228c78['params']['id']}})[_0x9030('0x28')](handleEntityNotFound(_0x39e215,null))[_0x9030('0x28')](function(_0x4f1860){if(_0x4f1860){_0x73b926[_0x9030('0x3c')]=_[_0x9030('0x3e')](db[_0x9030('0x64')][_0x9030('0x3b')]);_0x73b926[_0x9030('0x3d')]=_['keys'](_0x228c78[_0x9030('0x3d')]);_0x73b926[_0x9030('0x47')]=_[_0x9030('0x3f')](_0x73b926['model'],_0x73b926['query']);_0x14528a['attributes']=_[_0x9030('0x3f')](_0x73b926[_0x9030('0x3c')],qs['fields'](_0x228c78['query'][_0x9030('0x40')]));_0x14528a[_0x9030('0x41')]=_0x14528a['attributes'][_0x9030('0x42')]?_0x14528a[_0x9030('0x41')]:_0x73b926[_0x9030('0x3c')];if(!_0x228c78[_0x9030('0x3d')][_0x9030('0x61')](_0x9030('0x43'))){_0x14528a[_0x9030('0x25')]=qs['limit'](_0x228c78[_0x9030('0x3d')]['limit']);_0x14528a[_0x9030('0x23')]=qs[_0x9030('0x23')](_0x228c78['query']['offset']);}_0x14528a[_0x9030('0x44')]=qs[_0x9030('0x45')](_0x228c78['query'][_0x9030('0x45')]);_0x14528a['where']=qs[_0x9030('0x47')](_[_0x9030('0x48')](_0x228c78[_0x9030('0x3d')],_0x73b926[_0x9030('0x47')]));_0x14528a[_0x9030('0x46')][_0x9030('0x65')]=_0x4f1860['id'];if(_0x228c78[_0x9030('0x3d')][_0x9030('0x2e')]){_0x14528a['where']=_[_0x9030('0x49')](_0x14528a[_0x9030('0x46')],{'$or':_[_0x9030('0x30')](_0x14528a[_0x9030('0x41')],function(_0x107fd6){var _0x24a51d={};_0x24a51d[_0x107fd6]={'$like':'%'+_0x228c78['query'][_0x9030('0x2e')]+'%'};return _0x24a51d;})});}_0x14528a=_[_0x9030('0x49')]({},_0x14528a,_0x228c78[_0x9030('0x4b')]);return db[_0x9030('0x64')]['count']({'where':_0x14528a[_0x9030('0x46')]})[_0x9030('0x28')](function(_0x473fdc){_0x1fad1b[_0x9030('0x26')]=_0x473fdc;if(_0x228c78[_0x9030('0x3d')][_0x9030('0x4c')]){_0x14528a[_0x9030('0x4d')]=[{'all':!![]}];}return db[_0x9030('0x64')][_0x9030('0x66')](_0x14528a);})['then'](function(_0x3197a6){_0x1fad1b[_0x9030('0x62')]=_0x3197a6;return _0x1fad1b;});}})['then'](respondWithFilteredResult(_0x39e215,_0x14528a))[_0x9030('0x4e')](handleError(_0x39e215,null));};exports[_0x9030('0x67')]=function(_0x331f49,_0x3d439e,_0x22c0a3){var _0x7bf24f={'raw':!![],'where':{}};var _0x3a2f1b={};var _0x3a36b0={'count':0x0,'rows':[]};return db[_0x9030('0x3a')][_0x9030('0x5f')]({'where':{'id':_0x331f49[_0x9030('0x58')]['id']}})[_0x9030('0x28')](handleEntityNotFound(_0x3d439e,null))['then'](function(_0x49614e){if(_0x49614e){_0x3a2f1b[_0x9030('0x3c')]=_[_0x9030('0x3e')](db[_0x9030('0x68')][_0x9030('0x3b')]);_0x3a2f1b[_0x9030('0x3d')]=_[_0x9030('0x3e')](_0x331f49['query']);_0x3a2f1b[_0x9030('0x47')]=_[_0x9030('0x3f')](_0x3a2f1b[_0x9030('0x3c')],_0x3a2f1b[_0x9030('0x3d')]);_0x7bf24f[_0x9030('0x41')]=_[_0x9030('0x3f')](_0x3a2f1b[_0x9030('0x3c')],qs[_0x9030('0x40')](_0x331f49[_0x9030('0x3d')][_0x9030('0x40')]));_0x7bf24f[_0x9030('0x41')]=_0x7bf24f['attributes'][_0x9030('0x42')]?_0x7bf24f[_0x9030('0x41')]:_0x3a2f1b['model'];if(!_0x331f49[_0x9030('0x3d')][_0x9030('0x61')]('nolimit')){_0x7bf24f[_0x9030('0x25')]=qs['limit'](_0x331f49[_0x9030('0x3d')][_0x9030('0x25')]);_0x7bf24f[_0x9030('0x23')]=qs[_0x9030('0x23')](_0x331f49[_0x9030('0x3d')][_0x9030('0x23')]);}_0x7bf24f['order']=qs[_0x9030('0x45')](_0x331f49[_0x9030('0x3d')][_0x9030('0x45')]);_0x7bf24f[_0x9030('0x46')]=qs[_0x9030('0x47')](_[_0x9030('0x48')](_0x331f49[_0x9030('0x3d')],_0x3a2f1b['filters']));_0x7bf24f[_0x9030('0x46')][_0x9030('0x65')]=_0x49614e['id'];if(_0x331f49['query'][_0x9030('0x2e')]){_0x7bf24f[_0x9030('0x46')]=_[_0x9030('0x49')](_0x7bf24f[_0x9030('0x46')],{'$or':_[_0x9030('0x30')](_0x7bf24f[_0x9030('0x41')],function(_0x1f7292){var _0x45d673={};_0x45d673[_0x1f7292]={'$like':'%'+_0x331f49[_0x9030('0x3d')][_0x9030('0x2e')]+'%'};return _0x45d673;})});}_0x7bf24f=_['merge']({},_0x7bf24f,_0x331f49[_0x9030('0x4b')]);return db[_0x9030('0x68')][_0x9030('0x26')]({'where':_0x7bf24f['where']})[_0x9030('0x28')](function(_0x1ea0f8){_0x3a36b0[_0x9030('0x26')]=_0x1ea0f8;if(_0x331f49[_0x9030('0x3d')][_0x9030('0x4c')]){_0x7bf24f['include']=[{'all':!![]}];}return db[_0x9030('0x68')]['findAll'](_0x7bf24f);})[_0x9030('0x28')](function(_0x4cbad6){_0x3a36b0[_0x9030('0x62')]=_0x4cbad6;return _0x3a36b0;});}})['then'](respondWithFilteredResult(_0x3d439e,_0x7bf24f))['catch'](handleError(_0x3d439e,null));};exports[_0x9030('0x69')]=function(_0x1a65e2,_0x1fd310,_0x339a98){var _0x3edfc3={'raw':!![],'where':{}};var _0x3c260a={};var _0x17d78d={'count':0x0,'rows':[]};return db[_0x9030('0x3a')][_0x9030('0x5f')]({'where':{'id':_0x1a65e2[_0x9030('0x58')]['id']}})['then'](handleEntityNotFound(_0x1fd310,null))[_0x9030('0x28')](function(_0x1a908b){if(_0x1a908b){_0x3c260a[_0x9030('0x3c')]=_[_0x9030('0x3e')](db[_0x9030('0x6a')][_0x9030('0x3b')]);_0x3c260a[_0x9030('0x3d')]=_[_0x9030('0x3e')](_0x1a65e2[_0x9030('0x3d')]);_0x3c260a['filters']=_[_0x9030('0x3f')](_0x3c260a[_0x9030('0x3c')],_0x3c260a[_0x9030('0x3d')]);_0x3edfc3[_0x9030('0x41')]=_[_0x9030('0x3f')](_0x3c260a[_0x9030('0x3c')],qs['fields'](_0x1a65e2[_0x9030('0x3d')][_0x9030('0x40')]));_0x3edfc3[_0x9030('0x41')]=_0x3edfc3[_0x9030('0x41')][_0x9030('0x42')]?_0x3edfc3[_0x9030('0x41')]:_0x3c260a[_0x9030('0x3c')];if(!_0x1a65e2[_0x9030('0x3d')][_0x9030('0x61')](_0x9030('0x43'))){_0x3edfc3['limit']=qs[_0x9030('0x25')](_0x1a65e2[_0x9030('0x3d')]['limit']);_0x3edfc3[_0x9030('0x23')]=qs[_0x9030('0x23')](_0x1a65e2['query'][_0x9030('0x23')]);}_0x3edfc3[_0x9030('0x44')]=qs[_0x9030('0x45')](_0x1a65e2[_0x9030('0x3d')][_0x9030('0x45')]);_0x3edfc3['where']=qs[_0x9030('0x47')](_[_0x9030('0x48')](_0x1a65e2[_0x9030('0x3d')],_0x3c260a[_0x9030('0x47')]));_0x3edfc3[_0x9030('0x46')][_0x9030('0x65')]=_0x1a908b['id'];if(_0x1a65e2[_0x9030('0x3d')][_0x9030('0x2e')]){_0x3edfc3['where']=_[_0x9030('0x49')](_0x3edfc3['where'],{'$or':_[_0x9030('0x30')](_0x3edfc3['attributes'],function(_0x265cec){var _0x44592a={};_0x44592a[_0x265cec]={'$like':'%'+_0x1a65e2[_0x9030('0x3d')][_0x9030('0x2e')]+'%'};return _0x44592a;})});}_0x3edfc3=_[_0x9030('0x49')]({},_0x3edfc3,_0x1a65e2[_0x9030('0x4b')]);return db[_0x9030('0x6a')][_0x9030('0x26')]({'where':_0x3edfc3['where']})[_0x9030('0x28')](function(_0x29e0e7){_0x17d78d[_0x9030('0x26')]=_0x29e0e7;if(_0x1a65e2[_0x9030('0x3d')][_0x9030('0x4c')]){_0x3edfc3['include']=[{'all':!![]}];}return db[_0x9030('0x6a')][_0x9030('0x66')](_0x3edfc3);})[_0x9030('0x28')](function(_0x4fa249){_0x17d78d[_0x9030('0x62')]=_0x4fa249;return _0x17d78d;});}})[_0x9030('0x28')](respondWithFilteredResult(_0x1fd310,_0x3edfc3))[_0x9030('0x4e')](handleError(_0x1fd310,null));};exports[_0x9030('0x6b')]=function(_0xdb6a45,_0x165c68,_0x1a4c48){var _0xd80634={};var _0x4541e5={};var _0x229fba;var _0x54baf5;return db[_0x9030('0x3a')][_0x9030('0x5f')]({'where':{'id':_0xdb6a45[_0x9030('0x58')]['id']}})[_0x9030('0x28')](handleEntityNotFound(_0x165c68,null))[_0x9030('0x28')](function(_0x5bbef4){if(_0x5bbef4){_0x229fba=_0x5bbef4;_0x4541e5['model']=_[_0x9030('0x3e')](db['Team'][_0x9030('0x3b')]);_0x4541e5[_0x9030('0x3d')]=_[_0x9030('0x3e')](_0xdb6a45[_0x9030('0x3d')]);_0x4541e5[_0x9030('0x47')]=_[_0x9030('0x3f')](_0x4541e5['model'],_0x4541e5[_0x9030('0x3d')]);_0xd80634[_0x9030('0x41')]=_[_0x9030('0x3f')](_0x4541e5['model'],qs[_0x9030('0x40')](_0xdb6a45[_0x9030('0x3d')][_0x9030('0x40')]));_0xd80634[_0x9030('0x41')]=_0xd80634[_0x9030('0x41')][_0x9030('0x42')]?_0xd80634[_0x9030('0x41')]:_0x4541e5[_0x9030('0x3c')];_0xd80634[_0x9030('0x44')]=qs[_0x9030('0x45')](_0xdb6a45['query']['sort']);_0xd80634['where']=qs[_0x9030('0x47')](_[_0x9030('0x48')](_0xdb6a45[_0x9030('0x3d')],_0x4541e5[_0x9030('0x47')]));if(_0xdb6a45[_0x9030('0x3d')]['filter']){_0xd80634['where']=_['merge'](_0xd80634[_0x9030('0x46')],{'$or':_[_0x9030('0x30')](_0xd80634[_0x9030('0x41')],function(_0x27e764){var _0x2ec460={};_0x2ec460[_0x27e764]={'$like':'%'+_0xdb6a45['query'][_0x9030('0x2e')]+'%'};return _0x2ec460;})});}_0xd80634=_[_0x9030('0x49')]({},_0xd80634,_0xdb6a45[_0x9030('0x4b')]);return _0x229fba['getTeams'](_0xd80634);}})['then'](function(_0x18e841){if(_0x18e841){_0x54baf5=_0x18e841[_0x9030('0x42')];if(!_0xdb6a45[_0x9030('0x3d')][_0x9030('0x61')]('nolimit')){_0xd80634['limit']=qs['limit'](_0xdb6a45[_0x9030('0x3d')][_0x9030('0x25')]);_0xd80634[_0x9030('0x23')]=qs[_0x9030('0x23')](_0xdb6a45[_0x9030('0x3d')][_0x9030('0x23')]);}return _0x229fba['getTeams'](_0xd80634);}})[_0x9030('0x28')](function(_0x4c844e){if(_0x4c844e){return _0x4c844e?{'count':_0x54baf5,'rows':_0x4c844e}:null;}})['then'](respondWithResult(_0x165c68,null))[_0x9030('0x4e')](handleError(_0x165c68,null));};exports[_0x9030('0x6c')]=function(_0x4ee5bc,_0xc5e4a2,_0x4d4b48){var _0x5600de=_0x4ee5bc['body'][_0x9030('0x6d')];var _0x1da6df=_[_0x9030('0x30')](_0x5600de,'id');return db['Team'][_0x9030('0x66')]({'where':{'id':_0x1da6df},'attributes':['id'],'include':[{'model':db[_0x9030('0x6e')],'as':_0x9030('0x6f'),'attributes':['id','name',_0x9030('0x70'),_0x9030('0x71'),_0x9030('0x72')],'raw':!![]}]})[_0x9030('0x28')](function(_0x402593){if(_0x402593){var _0x5bf7b0=_[_0x9030('0x73')](_0x402593,function(_0x429d20){var _0x2db35b=_0x429d20[_0x9030('0x29')]({'plain':!![]});_0x2db35b[_0x9030('0x6f')][_0x9030('0x74')](function(_0x383247){_0x383247[_0x9030('0x75')]=_[_0x9030('0x33')](_0x5600de,{'id':_0x2db35b['id']})[_0x9030('0x75')];});return _0x2db35b[_0x9030('0x6f')];});return db[_0x9030('0x3a')][_0x9030('0x33')]({'where':{'id':_0x4ee5bc[_0x9030('0x58')]['id']}})['then'](function(_0x5e3275){return db[_0x9030('0x76')][_0x9030('0x77')](function(_0x3cac6d){return _0x5e3275[_0x9030('0x6c')](_0x1da6df,{'transaction':_0x3cac6d})[_0x9030('0x28')](function(){return BPromise[_0x9030('0x78')](_0x5600de,function(_0x5800f5){return db[_0x9030('0x79')][_0x9030('0x7a')]({'TeamId':_0x5800f5['id'],'VoiceQueueId':_0x4ee5bc[_0x9030('0x58')]['id'],'penalty':_0x5800f5[_0x9030('0x75')]},{'transaction':_0x3cac6d});});})['then'](function(){return BPromise[_0x9030('0x78')](_0x5bf7b0,function(_0x3f06d2){return db['UserVoiceQueue']['findOrCreate']({'where':{'UserId':_0x3f06d2['id'],'VoiceQueueId':_0x4ee5bc[_0x9030('0x58')]['id']},'defaults':{'penalty':_0x3f06d2[_0x9030('0x75')]},'transaction':_0x3cac6d});});})['then'](function(){return BPromise[_0x9030('0x78')](_[_0x9030('0x2e')](_0x5bf7b0,{'online':!![]}),function(_0x20318b){return db['UserVoiceQueueRt'][_0x9030('0x7a')]({'membername':_0x20318b[_0x9030('0x34')],'UserId':_0x20318b['id'],'queue_name':_0x5e3275[_0x9030('0x34')],'VoiceQueueId':_0x5e3275['id'],'interface':_[_0x9030('0x7b')](_0x20318b[_0x9030('0x72')])?util[_0x9030('0x7c')]('SIP/%s',_0x20318b[_0x9030('0x34')]):_0x20318b['interface'],'paused':_0x20318b[_0x9030('0x71')]||![],'penalty':_0x20318b[_0x9030('0x75')]},{'transaction':_0x3cac6d});});})[_0x9030('0x28')](function(){_0x5bf7b0[_0x9030('0x74')](function(_0x398525){socket[_0x9030('0x7d')](_0x9030('0x7e'),{'UserId':_0x398525['id'],'VoiceQueueId':_0x5e3275['id']});});});});});}})[_0x9030('0x28')](respondWithStatusCode(_0xc5e4a2,null))[_0x9030('0x4e')](handleError(_0xc5e4a2,null));};exports[_0x9030('0x7f')]=function(_0x252404,_0x4a7a0b,_0x47618e){return db[_0x9030('0x80')][_0x9030('0x66')]({'where':{'id':_0x252404['query'][_0x9030('0x81')]},'attributes':['id'],'include':[{'model':db[_0x9030('0x6e')],'as':_0x9030('0x6f'),'attributes':['id'],'raw':!![]}]})[_0x9030('0x28')](handleEntityNotFound(_0x4a7a0b,null))['then'](function(_0x13a615){var _0x180e4f=_[_0x9030('0x30')](_0x13a615,'id');var _0x59d747=[];var _0x4e0691=[];var _0x2b44e=squel[_0x9030('0x82')]();_0x2b44e[_0x9030('0x83')](_0x9030('0x84'))[_0x9030('0x85')](_0x9030('0x86'),'tq')['join'](_0x9030('0x87'),'ut',_0x9030('0x88'))['where'](_0x9030('0x89'),_0x252404[_0x9030('0x58')]['id']);for(var _0x338a4b=0x0;_0x338a4b<_0x13a615[_0x9030('0x42')];_0x338a4b+=0x1){let _0x47b91f=_0x13a615[_0x338a4b];for(var _0x2c3902=0x0;_0x2c3902<_0x47b91f[_0x9030('0x6f')]['length'];_0x2c3902+=0x1){let _0xc8ded0=_0x47b91f[_0x9030('0x6f')][_0x2c3902];var _0x22b1d2=_0x2b44e[_0x9030('0x57')]();_0x22b1d2[_0x9030('0x46')]('ut.UserId\x20=\x20?',_0xc8ded0['id']);_0x4e0691[_0x9030('0x8a')](db[_0x9030('0x76')][_0x9030('0x3d')](_0x22b1d2['toString'](),{'type':db['sequelize']['QueryTypes'][_0x9030('0x8b')]})[_0x9030('0x28')](function(_0x321c60){if(_0x321c60['length']===0x1){return _0xc8ded0['id'];}else{var _0x283cf2=_[_0x9030('0x8c')](_[_0x9030('0x30')](_0x321c60,'TeamId'),function(_0x525978){return _[_0x9030('0x8d')](_0x180e4f,_0x525978);});if(_0x283cf2){return _0xc8ded0['id'];}}}));}}return BPromise[_0x9030('0x8e')](_0x4e0691)[_0x9030('0x28')](function(_0x3f6a3a){_0x59d747=_(_0x59d747)['union'](_0x3f6a3a)[_0x9030('0x8f')]()[_0x9030('0x31')]();return db[_0x9030('0x3a')][_0x9030('0x33')]({'where':{'id':_0x252404[_0x9030('0x58')]['id']}})[_0x9030('0x28')](function(_0x3e5ab2){return db[_0x9030('0x76')]['transaction'](function(_0x1ec161){return _0x3e5ab2[_0x9030('0x7f')](_0x252404[_0x9030('0x3d')][_0x9030('0x81')],{'transaction':_0x1ec161})['then'](function(){if(!_[_0x9030('0x90')](_0x59d747)){return _0x3e5ab2['removeAgents'](_0x59d747,{'transaction':_0x1ec161})[_0x9030('0x28')](function(){return db[_0x9030('0x91')][_0x9030('0x5d')]({'where':{'VoiceQueueId':_0x252404['params']['id'],'UserId':_0x59d747},'transaction':_0x1ec161});});}})[_0x9030('0x28')](function(){_0x59d747[_0x9030('0x74')](function(_0x2f97e8){socket['emit'](_0x9030('0x92'),{'UserId':_0x2f97e8,'VoiceQueueId':_0x3e5ab2['id']});});});});});});})[_0x9030('0x28')](respondWithStatusCode(_0x4a7a0b,null))['catch'](handleError(_0x4a7a0b,null));};exports[_0x9030('0x93')]=function(_0xb940d1,_0x1675d5,_0x26555c){var _0x1eb2e8,_0x454434;return db[_0x9030('0x3a')][_0x9030('0x33')]({'where':{'id':_0xb940d1['params']['id']}})['then'](handleEntityNotFound(_0x1675d5,null))[_0x9030('0x28')](function(_0x2a74f3){if(_0x2a74f3){_0x454434=_0x2a74f3;return _0x2a74f3[_0x9030('0x93')](_0xb940d1[_0x9030('0x51')][_0x9030('0x81')],_[_0x9030('0x59')](_0xb940d1['body'],['ids','id'])||{})[_0x9030('0x94')](function(_0x139226){for(var _0x264f41=0x0;_0x264f41<_0xb940d1[_0x9030('0x51')][_0x9030('0x81')][_0x9030('0x42')];_0x264f41+=0x1){socket[_0x9030('0x7d')]('userVoiceQueue:save',{'UserId':Number(_0xb940d1[_0x9030('0x51')]['ids'][_0x264f41]),'VoiceQueueId':Number(_0xb940d1['params']['id'])});}return _0x139226;});}})[_0x9030('0x28')](function(_0x5df1d2){_0x1eb2e8=_0x5df1d2||[];if(_0x454434){return db['User'][_0x9030('0x66')]({'where':{'id':_0xb940d1[_0x9030('0x51')][_0x9030('0x81')]},'attributes':['id',_0x9030('0x34'),'online',_0x9030('0x71'),_0x9030('0x72')],'raw':!![]});}})[_0x9030('0x28')](function(_0x38472e){if(!_['isEmpty'](_0x38472e)){var _0x5f2523=[];for(var _0x556698=0x0;_0x556698<_0x38472e['length'];_0x556698++){if(_0x38472e[_0x556698][_0x9030('0x70')]){_0x5f2523['push'](db[_0x9030('0x91')][_0x9030('0x7a')]({'membername':_0x38472e[_0x556698][_0x9030('0x34')],'UserId':_0x38472e[_0x556698]['id'],'queue_name':_0x454434[_0x9030('0x34')],'VoiceQueueId':_0x454434['id'],'interface':_[_0x9030('0x7b')](_0x38472e[_0x556698][_0x9030('0x72')])?util['format']('SIP/%s',_0x38472e[_0x556698]['name']):_0x38472e[_0x556698][_0x9030('0x72')],'paused':_0x38472e[_0x556698][_0x9030('0x71')]||![],'penalty':_0xb940d1[_0x9030('0x51')][_0x9030('0x75')]||0x0}));}}return BPromise[_0x9030('0x8e')](_0x5f2523);}})[_0x9030('0x28')](function(){return _0x1eb2e8;})[_0x9030('0x28')](respondWithResult(_0x1675d5,null))[_0x9030('0x4e')](handleError(_0x1675d5,null));};exports['removeAgents']=function(_0x18ac5b,_0x369fa5,_0x54f85e){return db['VoiceQueue']['find']({'where':{'id':_0x18ac5b[_0x9030('0x58')]['id']}})[_0x9030('0x28')](handleEntityNotFound(_0x369fa5,null))[_0x9030('0x28')](function(_0x308f26){if(_0x308f26){return _0x308f26['removeAgents'](_0x18ac5b[_0x9030('0x3d')]['ids'])['then'](function(){if(_[_0x9030('0x95')](_0x18ac5b[_0x9030('0x3d')]['ids'])){for(var _0x32cf5e=0x0;_0x32cf5e<_0x18ac5b[_0x9030('0x3d')][_0x9030('0x81')][_0x9030('0x42')];_0x32cf5e+=0x1){socket['emit'](_0x9030('0x92'),{'UserId':Number(_0x18ac5b[_0x9030('0x3d')]['ids'][_0x32cf5e]),'VoiceQueueId':Number(_0x18ac5b[_0x9030('0x58')]['id'])});}}else{socket[_0x9030('0x7d')](_0x9030('0x92'),{'UserId':Number(_0x18ac5b[_0x9030('0x3d')][_0x9030('0x81')]),'VoiceQueueId':Number(_0x18ac5b['params']['id'])});}});}})['then'](function(_0x57ee3e){return db[_0x9030('0x91')][_0x9030('0x5d')]({'where':{'VoiceQueueId':_0x18ac5b['params']['id'],'UserId':_0x18ac5b[_0x9030('0x3d')][_0x9030('0x81')]}})[_0x9030('0x28')](function(){return _0x57ee3e;});})['then'](respondWithStatusCode(_0x369fa5,null))[_0x9030('0x4e')](handleError(_0x369fa5,null));};exports[_0x9030('0x96')]=function(_0x2f57f6,_0x16d3f5,_0x47dab9){var _0x4e763b={};var _0x15ecf1={};var _0x4ebc73;var _0x58b8b0;return db[_0x9030('0x3a')][_0x9030('0x5f')]({'where':{'id':_0x2f57f6['params']['id']}})['then'](handleEntityNotFound(_0x16d3f5,null))['then'](function(_0x5c42db){if(_0x5c42db){_0x4ebc73=_0x5c42db;_0x15ecf1[_0x9030('0x3c')]=_[_0x9030('0x3e')](db[_0x9030('0x6e')][_0x9030('0x3b')]);_0x15ecf1[_0x9030('0x3d')]=_[_0x9030('0x3e')](_0x2f57f6[_0x9030('0x3d')]);_0x15ecf1[_0x9030('0x47')]=_[_0x9030('0x3f')](_0x15ecf1['model'],_0x15ecf1[_0x9030('0x3d')]);_0x4e763b[_0x9030('0x41')]=_[_0x9030('0x3f')](_0x15ecf1[_0x9030('0x3c')],qs[_0x9030('0x40')](_0x2f57f6['query'][_0x9030('0x40')]));_0x4e763b[_0x9030('0x41')]=_0x4e763b[_0x9030('0x41')][_0x9030('0x42')]?_0x4e763b['attributes']:_0x15ecf1[_0x9030('0x3c')];_0x4e763b[_0x9030('0x44')]=qs[_0x9030('0x45')](_0x2f57f6[_0x9030('0x3d')][_0x9030('0x45')]);_0x4e763b[_0x9030('0x46')]=qs[_0x9030('0x47')](_[_0x9030('0x48')](_0x2f57f6[_0x9030('0x3d')],_0x15ecf1['filters']));if(_0x2f57f6['query']['filter']){_0x4e763b[_0x9030('0x46')]=_[_0x9030('0x49')](_0x4e763b[_0x9030('0x46')],{'$or':_['map'](_0x4e763b[_0x9030('0x41')],function(_0x16e44b){var _0x491b8d={};_0x491b8d[_0x16e44b]={'$like':'%'+_0x2f57f6[_0x9030('0x3d')][_0x9030('0x2e')]+'%'};return _0x491b8d;})});}_0x4e763b=_['merge']({},_0x4e763b,_0x2f57f6[_0x9030('0x4b')]);return _0x4ebc73[_0x9030('0x96')](_0x4e763b);}})[_0x9030('0x28')](function(_0x2fcce3){if(_0x2fcce3){_0x58b8b0=_0x2fcce3['length'];if(!_0x2f57f6[_0x9030('0x3d')][_0x9030('0x61')](_0x9030('0x43'))){_0x4e763b[_0x9030('0x25')]=qs[_0x9030('0x25')](_0x2f57f6[_0x9030('0x3d')][_0x9030('0x25')]);_0x4e763b[_0x9030('0x23')]=qs[_0x9030('0x23')](_0x2f57f6[_0x9030('0x3d')][_0x9030('0x23')]);}return _0x4ebc73[_0x9030('0x96')](_0x4e763b);}})['then'](function(_0x31453b){if(_0x31453b){return _0x31453b?{'count':_0x58b8b0,'rows':_0x31453b}:null;}})[_0x9030('0x28')](respondWithResult(_0x16d3f5,null))[_0x9030('0x4e')](handleError(_0x16d3f5,null));};exports[_0x9030('0x97')]=function(_0x39d16a,_0x43b3bc,_0x1638ee){var _0x370aa7={};var _0x584881={};var _0xcd08f0;var _0xbb4105;return db['VoiceQueue']['findOne']({'where':{'id':_0x39d16a['params']['id']}})[_0x9030('0x28')](handleEntityNotFound(_0x43b3bc,null))[_0x9030('0x28')](function(_0x494c1a){if(_0x494c1a){_0xcd08f0=_0x494c1a;_0x584881[_0x9030('0x3c')]=_[_0x9030('0x3e')](db['UserVoiceQueueRt'][_0x9030('0x3b')]);_0x584881['query']=_[_0x9030('0x3e')](_0x39d16a[_0x9030('0x3d')]);_0x584881['filters']=_[_0x9030('0x3f')](_0x584881[_0x9030('0x3c')],_0x584881[_0x9030('0x3d')]);_0x370aa7[_0x9030('0x41')]=_[_0x9030('0x3f')](_0x584881[_0x9030('0x3c')],qs[_0x9030('0x40')](_0x39d16a[_0x9030('0x3d')][_0x9030('0x40')]));_0x370aa7[_0x9030('0x41')]=_0x370aa7[_0x9030('0x41')][_0x9030('0x42')]?_0x370aa7[_0x9030('0x41')]:_0x584881[_0x9030('0x3c')];_0x370aa7[_0x9030('0x44')]=qs[_0x9030('0x45')](_0x39d16a[_0x9030('0x3d')][_0x9030('0x45')]);_0x370aa7[_0x9030('0x46')]=qs['filters'](_[_0x9030('0x48')](_0x39d16a[_0x9030('0x3d')],_0x584881[_0x9030('0x47')]));if(_0x39d16a[_0x9030('0x3d')]['filter']){_0x370aa7[_0x9030('0x46')]=_[_0x9030('0x49')](_0x370aa7[_0x9030('0x46')],{'$or':_[_0x9030('0x30')](_0x370aa7['attributes'],function(_0x2b5b71){var _0x210224={};_0x210224[_0x2b5b71]={'$like':'%'+_0x39d16a[_0x9030('0x3d')][_0x9030('0x2e')]+'%'};return _0x210224;})});}_0x370aa7=_[_0x9030('0x49')]({},_0x370aa7,_0x39d16a[_0x9030('0x4b')]);return _0xcd08f0['getMembers'](_0x370aa7);}})[_0x9030('0x28')](function(_0x4f3a40){if(_0x4f3a40){_0xbb4105=_0x4f3a40[_0x9030('0x42')];if(!_0x39d16a[_0x9030('0x3d')][_0x9030('0x61')](_0x9030('0x43'))){_0x370aa7[_0x9030('0x25')]=qs[_0x9030('0x25')](_0x39d16a[_0x9030('0x3d')][_0x9030('0x25')]);_0x370aa7[_0x9030('0x23')]=qs[_0x9030('0x23')](_0x39d16a[_0x9030('0x3d')][_0x9030('0x23')]);}return _0xcd08f0[_0x9030('0x97')](_0x370aa7);}})[_0x9030('0x28')](function(_0x1c79be){return _0x1c79be?{'count':_0xbb4105,'rows':_0x1c79be}:null;})[_0x9030('0x28')](respondWithResult(_0x43b3bc,null))[_0x9030('0x4e')](handleError(_0x43b3bc,null));};exports[_0x9030('0x98')]=function(_0x44c923,_0x3ef8ae,_0x25a588){var _0x98d1a7={};var _0x469ed7={};var _0x5df211;var _0x223f61;return db['VoiceQueue']['findOne']({'where':{'id':_0x44c923[_0x9030('0x58')]['id']}})[_0x9030('0x28')](handleEntityNotFound(_0x3ef8ae,null))[_0x9030('0x28')](function(_0x43fcad){if(_0x43fcad){_0x5df211=_0x43fcad;_0x469ed7['model']=_[_0x9030('0x3e')](db['CmList'][_0x9030('0x3b')]);_0x469ed7['query']=_[_0x9030('0x3e')](_0x44c923[_0x9030('0x3d')]);_0x469ed7[_0x9030('0x47')]=_[_0x9030('0x3f')](_0x469ed7['model'],_0x469ed7['query']);_0x98d1a7[_0x9030('0x41')]=_[_0x9030('0x3f')](_0x469ed7['model'],qs[_0x9030('0x40')](_0x44c923[_0x9030('0x3d')][_0x9030('0x40')]));_0x98d1a7['attributes']=_0x98d1a7['attributes'][_0x9030('0x42')]?_0x98d1a7['attributes']:_0x469ed7[_0x9030('0x3c')];_0x98d1a7[_0x9030('0x44')]=qs[_0x9030('0x45')](_0x44c923[_0x9030('0x3d')][_0x9030('0x45')]);_0x98d1a7[_0x9030('0x46')]=qs[_0x9030('0x47')](_[_0x9030('0x48')](_0x44c923['query'],_0x469ed7['filters']));if(_0x44c923[_0x9030('0x3d')]['filter']){_0x98d1a7[_0x9030('0x46')]=_['merge'](_0x98d1a7[_0x9030('0x46')],{'$or':_[_0x9030('0x30')](_0x98d1a7[_0x9030('0x41')],function(_0x451341){var _0x280122={};_0x280122[_0x451341]={'$like':'%'+_0x44c923[_0x9030('0x3d')][_0x9030('0x2e')]+'%'};return _0x280122;})});}_0x98d1a7=_[_0x9030('0x49')]({},_0x98d1a7,_0x44c923[_0x9030('0x4b')]);return _0x5df211[_0x9030('0x98')](_0x98d1a7);}})['then'](function(_0x112299){if(_0x112299){_0x223f61=_0x112299[_0x9030('0x42')];if(!_0x44c923[_0x9030('0x3d')][_0x9030('0x61')]('nolimit')){_0x98d1a7['limit']=qs[_0x9030('0x25')](_0x44c923[_0x9030('0x3d')][_0x9030('0x25')]);_0x98d1a7['offset']=qs[_0x9030('0x23')](_0x44c923[_0x9030('0x3d')]['offset']);}return _0x5df211['getLists'](_0x98d1a7);}})[_0x9030('0x28')](function(_0x4e1530){if(_0x4e1530){return _0x4e1530?{'count':_0x223f61,'rows':_0x4e1530}:null;}})['then'](respondWithResult(_0x3ef8ae,null))[_0x9030('0x4e')](handleError(_0x3ef8ae,null));};exports[_0x9030('0x99')]=function(_0x3c01c5,_0x16d53b,_0x5c9077){var _0x2477e2=moment()[_0x9030('0x7c')](_0x9030('0x9a'));var _0x5a0901,_0x25bfbe;return db[_0x9030('0x3a')][_0x9030('0x33')]({'where':{'id':_0x3c01c5[_0x9030('0x58')]['id']}})[_0x9030('0x28')](handleEntityNotFound(_0x16d53b,null))[_0x9030('0x28')](function(_0x2a6a9a){if(_0x2a6a9a){_0x25bfbe=_0x2a6a9a;return _0x2a6a9a['addLists'](_0x3c01c5[_0x9030('0x51')][_0x9030('0x81')],_['omit'](_0x3c01c5[_0x9030('0x51')],[_0x9030('0x81'),'id'])||{});}return null;})[_0x9030('0x94')](function(_0x290077){var _0x302b90;_0x5a0901=_0x290077||[];var _0xff062e=[];if(_0x290077){for(var _0x59c951=0x0;_0x59c951<_0x290077[_0x9030('0x42')];_0x59c951+=0x1){var _0x2133f6=_0x290077[_0x59c951][_0x9030('0x29')]({'plain':!![]});_0x25bfbe['dialCheckDuplicateType']=_0x3c01c5['body'][_0x9030('0x9b')]?_0x3c01c5[_0x9030('0x51')][_0x9030('0x9b')]:_0x25bfbe[_0x9030('0x9b')];switch(_0x25bfbe['dialCheckDuplicateType']){case _0x9030('0x9c'):_0x302b90=squel[_0x9030('0x9d')]()[_0x9030('0x9e')](_0x9030('0x9f'))[_0x9030('0xa0')](['phone',_0x9030('0xa1'),_0x9030('0xa2'),_0x9030('0xa3'),_0x9030('0x65'),'createdAt',_0x9030('0x5b')],squel[_0x9030('0x82')]()[_0x9030('0x83')]('phone','phone')[_0x9030('0x83')]('\x27'+_0x2477e2+'\x27',_0x9030('0xa1'))['field']('id',_0x9030('0xa2'))[_0x9030('0x83')](_0x2133f6[_0x9030('0xa4')][_0x9030('0xa5')](),_0x9030('0xa3'))['field'](_0x3c01c5[_0x9030('0x58')]['id'][_0x9030('0xa5')](),'VoiceQueueId')[_0x9030('0x83')]('\x27'+_0x2477e2+'\x27','createdAt')[_0x9030('0x83')]('\x27'+_0x2477e2+'\x27',_0x9030('0x5b'))[_0x9030('0x85')](_0x9030('0xa6'))[_0x9030('0x46')]('deletedAt\x20IS\x20NULL')[_0x9030('0x46')](_0x9030('0xa7'),_0x2133f6['CmListId'][_0x9030('0xa5')]())[_0x9030('0x46')]('phone\x20IS\x20NOT\x20NULL')[_0x9030('0x46')]('phone\x20NOT\x20IN\x20(?)',squel[_0x9030('0x82')]()[_0x9030('0x83')](_0x9030('0xa8'))['from'](_0x9030('0xa9'))[_0x9030('0x46')](_0x9030('0x89'),_0x3c01c5[_0x9030('0x58')]['id'][_0x9030('0xa5')]()))[_0x9030('0x46')](_0x9030('0xaa'),squel[_0x9030('0x82')]()[_0x9030('0x83')](_0x9030('0xab'))[_0x9030('0x85')](_0x9030('0x9f'))[_0x9030('0x46')]('VoiceQueueId\x20=\x20?',_0x3c01c5[_0x9030('0x58')]['id']['toString']())))[_0x9030('0xa5')]();break;case _0x9030('0xac'):_0x302b90=squel[_0x9030('0x9d')]()[_0x9030('0x9e')](_0x9030('0x9f'))['fromQuery']([_0x9030('0xad'),_0x9030('0xa1'),_0x9030('0xa2'),_0x9030('0xa3'),_0x9030('0x65'),_0x9030('0x5a'),_0x9030('0x5b')],squel[_0x9030('0x82')]()[_0x9030('0x83')](_0x9030('0xad'),'phone')['field']('\x27'+_0x2477e2+'\x27',_0x9030('0xa1'))[_0x9030('0x83')]('id',_0x9030('0xa2'))[_0x9030('0x83')](_0x2133f6[_0x9030('0xa4')][_0x9030('0xa5')](),_0x9030('0xa3'))[_0x9030('0x83')](_0x3c01c5[_0x9030('0x58')]['id']['toString'](),'VoiceQueueId')[_0x9030('0x83')]('\x27'+_0x2477e2+'\x27','createdAt')[_0x9030('0x83')]('\x27'+_0x2477e2+'\x27',_0x9030('0x5b'))[_0x9030('0x85')](_0x9030('0xa6'))['where'](_0x9030('0xae'))[_0x9030('0x46')]('ListId\x20=\x20?',_0x2133f6[_0x9030('0xa4')]['toString']())[_0x9030('0x46')](_0x9030('0xaf'))['where'](_0x9030('0xaa'),squel[_0x9030('0x82')]()[_0x9030('0x83')](_0x9030('0xab'))[_0x9030('0x85')](_0x9030('0x9f'))[_0x9030('0x46')](_0x9030('0x89'),_0x3c01c5['params']['id'][_0x9030('0xa5')]())))[_0x9030('0xa5')]();break;default:_0x302b90=squel['insert']()[_0x9030('0x9e')](_0x9030('0x9f'))[_0x9030('0xa0')]([_0x9030('0xad'),_0x9030('0xa1'),'ContactId',_0x9030('0xa3'),_0x9030('0x65'),_0x9030('0x5a'),_0x9030('0x5b')],squel[_0x9030('0x82')]()[_0x9030('0x83')]('phone',_0x9030('0xad'))['field']('\x27'+_0x2477e2+'\x27',_0x9030('0xa1'))[_0x9030('0x83')]('id',_0x9030('0xa2'))[_0x9030('0x83')](_0x2133f6[_0x9030('0xa4')]['toString'](),_0x9030('0xa3'))[_0x9030('0x83')](_0x3c01c5[_0x9030('0x58')]['id'][_0x9030('0xa5')](),_0x9030('0x65'))[_0x9030('0x83')]('\x27'+_0x2477e2+'\x27',_0x9030('0x5a'))[_0x9030('0x83')]('\x27'+_0x2477e2+'\x27',_0x9030('0x5b'))[_0x9030('0x85')](_0x9030('0xa6'))[_0x9030('0x46')](_0x9030('0xae'))[_0x9030('0x46')](_0x9030('0xa7'),_0x2133f6[_0x9030('0xa4')]['toString']())[_0x9030('0x46')](_0x9030('0xaf')))['toString']();}_0xff062e['push'](db[_0x9030('0x76')][_0x9030('0x3d')](_0x302b90));}return BPromise[_0x9030('0x8e')](_0xff062e);}})[_0x9030('0x28')](function(){var _0x4c714b=[];var _0x4d193d=squel['insert']()[_0x9030('0x9e')](_0x9030('0xb0'))[_0x9030('0xa0')]([_0x9030('0xb1'),'phone',_0x9030('0xb2'),_0x9030('0x5a'),_0x9030('0x5b')],squel[_0x9030('0x82')]()[_0x9030('0x83')]('h.id')['field'](_0x9030('0xb3'))[_0x9030('0x83')](_0x9030('0xb4'))[_0x9030('0x83')]('\x27'+_0x2477e2+'\x27','createdAt')['field']('\x27'+_0x2477e2+'\x27',_0x9030('0x5b'))['from'](_0x9030('0xb5'),'ci')[_0x9030('0xb6')](_0x9030('0x9f'),'h',_0x9030('0xb7'))[_0x9030('0x46')](_0x9030('0xb8'),_0x2477e2)[_0x9030('0x46')](_0x9030('0xb9'),_0x9030('0xba')))[_0x9030('0xa5')]();_0x4c714b[_0x9030('0x8a')](db[_0x9030('0x76')][_0x9030('0x3d')](_0x4d193d));return BPromise[_0x9030('0x8e')](_0x4c714b);})['then'](function(){return _0x5a0901;})['then'](respondWithResult(_0x16d53b,null))[_0x9030('0x4e')](handleError(_0x16d53b,null));};exports[_0x9030('0xbb')]=function(_0x2d4cd,_0x1af4bf,_0x213ca6){return db[_0x9030('0x3a')][_0x9030('0x33')]({'where':{'id':_0x2d4cd[_0x9030('0x58')]['id']}})[_0x9030('0x28')](handleEntityNotFound(_0x1af4bf,null))['then'](function(_0x332c0d){if(_0x332c0d){return _0x332c0d[_0x9030('0xbb')](_0x2d4cd['query'][_0x9030('0x81')]);}})[_0x9030('0x28')](function(_0x20ca02){if(_0x20ca02){return db[_0x9030('0x60')][_0x9030('0x5d')]({'where':{'ListId':_0x2d4cd[_0x9030('0x3d')][_0x9030('0x81')],'VoiceQueueId':_0x2d4cd['params']['id']}})[_0x9030('0x28')](function(){return _0x20ca02;});}})[_0x9030('0x28')](respondWithStatusCode(_0x1af4bf,null))[_0x9030('0x4e')](handleError(_0x1af4bf,null));};exports['getBlackLists']=function(_0x283821,_0x28ec18,_0x1de3de){var _0x106abc={};var _0x578f69={};var _0x45fe4e;var _0x50d2e9;return db[_0x9030('0x3a')]['findOne']({'where':{'id':_0x283821[_0x9030('0x58')]['id']}})['then'](handleEntityNotFound(_0x28ec18,null))[_0x9030('0x28')](function(_0x284ee1){if(_0x284ee1){_0x45fe4e=_0x284ee1;_0x578f69['model']=_[_0x9030('0x3e')](db[_0x9030('0xbc')][_0x9030('0x3b')]);_0x578f69[_0x9030('0x3d')]=_[_0x9030('0x3e')](_0x283821[_0x9030('0x3d')]);_0x578f69['filters']=_['intersection'](_0x578f69[_0x9030('0x3c')],_0x578f69[_0x9030('0x3d')]);_0x106abc['attributes']=_['intersection'](_0x578f69[_0x9030('0x3c')],qs[_0x9030('0x40')](_0x283821[_0x9030('0x3d')][_0x9030('0x40')]));_0x106abc['attributes']=_0x106abc['attributes'][_0x9030('0x42')]?_0x106abc[_0x9030('0x41')]:_0x578f69[_0x9030('0x3c')];_0x106abc[_0x9030('0x44')]=qs[_0x9030('0x45')](_0x283821[_0x9030('0x3d')][_0x9030('0x45')]);_0x106abc['where']=qs[_0x9030('0x47')](_[_0x9030('0x48')](_0x283821[_0x9030('0x3d')],_0x578f69[_0x9030('0x47')]));if(_0x283821[_0x9030('0x3d')][_0x9030('0x2e')]){_0x106abc['where']=_['merge'](_0x106abc[_0x9030('0x46')],{'$or':_['map'](_0x106abc[_0x9030('0x41')],function(_0x526373){var _0x3c677a={};_0x3c677a[_0x526373]={'$like':'%'+_0x283821['query'][_0x9030('0x2e')]+'%'};return _0x3c677a;})});}_0x106abc=_[_0x9030('0x49')]({},_0x106abc,_0x283821[_0x9030('0x4b')]);return _0x45fe4e['getBlackLists'](_0x106abc);}})[_0x9030('0x28')](function(_0x495ffb){if(_0x495ffb){_0x50d2e9=_0x495ffb[_0x9030('0x42')];if(!_0x283821[_0x9030('0x3d')]['hasOwnProperty']('nolimit')){_0x106abc['limit']=qs['limit'](_0x283821[_0x9030('0x3d')][_0x9030('0x25')]);_0x106abc[_0x9030('0x23')]=qs[_0x9030('0x23')](_0x283821[_0x9030('0x3d')][_0x9030('0x23')]);}return _0x45fe4e[_0x9030('0xbd')](_0x106abc);}})[_0x9030('0x28')](function(_0x4dc9ea){if(_0x4dc9ea){return _0x4dc9ea?{'count':_0x50d2e9,'rows':_0x4dc9ea}:null;}})[_0x9030('0x28')](respondWithResult(_0x28ec18,null))['catch'](handleError(_0x28ec18,null));};exports[_0x9030('0xbe')]=function(_0xd914d6,_0x5d0a18,_0x592895){var _0x4ccdc3,_0x29e6d5;return db[_0x9030('0x3a')][_0x9030('0x33')]({'where':{'id':_0xd914d6['params']['id']}})[_0x9030('0x28')](handleEntityNotFound(_0x5d0a18,null))[_0x9030('0x28')](function(_0x223c11){if(_0x223c11){_0x29e6d5=_0x223c11;return _0x223c11[_0x9030('0xbe')](_0xd914d6[_0x9030('0x51')][_0x9030('0x81')],_[_0x9030('0x59')](_0xd914d6[_0x9030('0x51')],[_0x9030('0x81'),'id'])||{});}return null;})[_0x9030('0x94')](function(_0x39ba19){var _0x5b9b39;_0x4ccdc3=_0x39ba19||[];var _0x3bba5e=[];if(_0x39ba19){for(var _0x348032=0x0;_0x348032<_0x39ba19[_0x9030('0x42')];_0x348032+=0x1){var _0x46d768=_0x39ba19[_0x348032][_0x9030('0x29')]({'plain':!![]});_0x5b9b39=squel[_0x9030('0x9d')]()['into']('cm_hopper_black')[_0x9030('0xa0')]([_0x9030('0xad'),'ContactId','ListId',_0x9030('0x65'),_0x9030('0x5a'),_0x9030('0x5b')],squel['select']()[_0x9030('0x83')](_0x9030('0xad'),_0x9030('0xad'))[_0x9030('0x83')]('id',_0x9030('0xa2'))[_0x9030('0x83')](_0x46d768['CmListId'][_0x9030('0xa5')](),'ListId')[_0x9030('0x83')](_0xd914d6[_0x9030('0x58')]['id'][_0x9030('0xa5')](),_0x9030('0x65'))['field'](_0x9030('0xbf'),_0x9030('0x5a'))[_0x9030('0x83')](_0x9030('0xbf'),_0x9030('0x5b'))[_0x9030('0x85')](_0x9030('0xa6'))['where'](_0x9030('0xae'))['where'](_0x9030('0xa7'),_0x46d768[_0x9030('0xa4')][_0x9030('0xa5')]())[_0x9030('0x46')]('phone\x20IS\x20NOT\x20NULL'))[_0x9030('0xa5')]();_0x3bba5e[_0x9030('0x8a')](db['sequelize'][_0x9030('0x3d')](_0x5b9b39));}return BPromise[_0x9030('0x8e')](_0x3bba5e);}})[_0x9030('0x28')](function(){return _0x4ccdc3;})[_0x9030('0x28')](respondWithResult(_0x5d0a18,null))[_0x9030('0x4e')](handleError(_0x5d0a18,null));};exports['removeBlackLists']=function(_0x5d50c1,_0x3a248f,_0x457b5b){return db[_0x9030('0x3a')][_0x9030('0x33')]({'where':{'id':_0x5d50c1['params']['id']}})['then'](handleEntityNotFound(_0x3a248f,null))[_0x9030('0x28')](function(_0x39bb01){if(_0x39bb01){return _0x39bb01[_0x9030('0xc0')](_0x5d50c1['query'][_0x9030('0x81')]);}})[_0x9030('0x28')](function(_0x41e229){if(_0x41e229){return db[_0x9030('0x6a')][_0x9030('0x5d')]({'where':{'ListId':_0x5d50c1[_0x9030('0x3d')][_0x9030('0x81')],'VoiceQueueId':_0x5d50c1[_0x9030('0x58')]['id']}})[_0x9030('0x28')](function(){return _0x41e229;});}})[_0x9030('0x28')](respondWithStatusCode(_0x3a248f,null))[_0x9030('0x4e')](handleError(_0x3a248f,null));};