Built motion from commit (unavailable).|2.5.12
[motion2.git] / server / api / openchannelQueue / openchannelQueue.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 _0x6247=['format','%s/%s','SIP','getTeams','Team','addTeams','User','online','voicePause','interface','flatMap','sequelize','each','forEach','userOpenchannelQueue:save','removeTeams','ids','Agents','select','tq.TeamId','from','join','user_has_teams','ut.TeamId\x20=\x20tq.TeamId','OpenchannelQueueId\x20=\x20?','clone','ut.UserId\x20=\x20?','push','QueryTypes','all','union','value','transaction','isEmpty','removeAgents','emit','userOpenchannelQueue:remove','addAgents','omit','isArray','getAgents','rimraf','zip-dir','fast-json-patch','bluebird','mustache','util','path','sox','to-csv','ejs','squel','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./openchannelQueue.socket','sendStatus','end','json','count','offset','status','set','Content-Range','reject','then','destroy','get','error','stack','send','index','map','rawAttributes','type','key','model','name','query','keys','intersection','attributes','fields','length','hasOwnProperty','nolimit','limit','order','sort','filters','pick','filter','where','options','OpenchannelQueue','includeAll','include','findAll','rows','catch','show','params','merge','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','OpenchannelQueues','UserProfileSection','autoAssociation','UserProfileResource','describe','getMembers','findOne','UserOpenchannelQueue','findAndCountAll','agent','openchannelPause','updatedAt','createdAt'];(function(_0x4f6e15,_0x1675bd){var _0x8cb268=function(_0x4f5cf9){while(--_0x4f5cf9){_0x4f6e15['push'](_0x4f6e15['shift']());}};_0x8cb268(++_0x1675bd);}(_0x6247,0xaf));var _0x7624=function(_0xd30bf,_0x2af50e){_0xd30bf=_0xd30bf-0x0;var _0x2949d1=_0x6247[_0xd30bf];return _0x2949d1;};'use strict';var pdf=require('html-pdf');var emlformat=require('eml-format');var rimraf=require(_0x7624('0x0'));var zipdir=require(_0x7624('0x1'));var jsonpatch=require(_0x7624('0x2'));var rp=require('request-promise');var moment=require('moment');var BPromise=require(_0x7624('0x3'));var Mustache=require(_0x7624('0x4'));var util=require(_0x7624('0x5'));var path=require(_0x7624('0x6'));var sox=require(_0x7624('0x7'));var csv=require(_0x7624('0x8'));var ejs=require(_0x7624('0x9'));var fs=require('fs');var _=require('lodash');var squel=require(_0x7624('0xa'));var crypto=require('crypto');var jsforce=require(_0x7624('0xb'));var deskjs=require(_0x7624('0xc'));var toCsv=require(_0x7624('0x8'));var querystring=require(_0x7624('0xd'));var Papa=require(_0x7624('0xe'));var Redis=require(_0x7624('0xf'));var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require(_0x7624('0x10'));var hardwareService=require(_0x7624('0x11'));var logger=require(_0x7624('0x12'))(_0x7624('0x13'));var utils=require(_0x7624('0x14'));var config=require('../../config/environment');var licenseUtil=require('../../config/license/util');var db=require(_0x7624('0x15'))['db'];config[_0x7624('0x16')]=_[_0x7624('0x17')](config[_0x7624('0x16')],{'host':_0x7624('0x18'),'port':0x18eb});var socket=require(_0x7624('0x19'))(new Redis(config[_0x7624('0x16')]));require(_0x7624('0x1a'))['register'](socket);function respondWithStatusCode(_0x494420,_0x4d3941){_0x4d3941=_0x4d3941||0xcc;return function(_0x1afa93){if(_0x1afa93){return _0x494420[_0x7624('0x1b')](_0x4d3941);}return _0x494420['status'](_0x4d3941)[_0x7624('0x1c')]();};}function respondWithResult(_0x571e16,_0x5704e2){_0x5704e2=_0x5704e2||0xc8;return function(_0xee2796){if(_0xee2796){return _0x571e16['status'](_0x5704e2)[_0x7624('0x1d')](_0xee2796);}};}function respondWithFilteredResult(_0xc03359,_0x3a62f9){return function(_0x2c03be){if(_0x2c03be){var _0x5a0ec5=_0x2c03be[_0x7624('0x1e')],_0x31dacb=_0x3a62f9[_0x7624('0x1f')],_0x2509b2=_0x3a62f9[_0x7624('0x1f')]+_0x3a62f9['limit'],_0xf60bdf;if(_0x2509b2>=_0x5a0ec5){_0x2509b2=_0x5a0ec5;_0xf60bdf=0xc8;}else{_0xf60bdf=0xce;}_0xc03359[_0x7624('0x20')](_0xf60bdf);return _0xc03359[_0x7624('0x21')](_0x7624('0x22'),_0x31dacb+'-'+_0x2509b2+'/'+_0x5a0ec5)[_0x7624('0x1d')](_0x2c03be);}return null;};}function patchUpdates(_0x56ea37){return function(_0x4f894a){try{jsonpatch['apply'](_0x4f894a,_0x56ea37,!![]);}catch(_0x3ae394){return BPromise[_0x7624('0x23')](_0x3ae394);}return _0x4f894a['save']();};}function saveUpdates(_0x5a0df0,_0xbf938){return function(_0x48fd62){if(_0x48fd62){return _0x48fd62['update'](_0x5a0df0)[_0x7624('0x24')](function(_0x1022a6){return _0x1022a6;});}return null;};}function removeEntity(_0x1ee73c,_0x47ade0){return function(_0x37065d){if(_0x37065d){return _0x37065d[_0x7624('0x25')]()[_0x7624('0x24')](function(){var _0x5e79f5=_0x37065d[_0x7624('0x26')]({'plain':!![]});var _0x697525='OpenchannelQueues';return db['UserProfileResource'][_0x7624('0x25')]({'where':{'type':_0x697525,'resourceId':_0x5e79f5['id']}})[_0x7624('0x24')](function(){return _0x37065d;});})[_0x7624('0x24')](function(){_0x1ee73c['status'](0xcc)[_0x7624('0x1c')]();});}};}function handleEntityNotFound(_0x4b1548,_0x247a24){return function(_0x1ebfa4){if(!_0x1ebfa4){_0x4b1548[_0x7624('0x1b')](0x194);}return _0x1ebfa4;};}function handleError(_0x3decbd,_0x182b4a){_0x182b4a=_0x182b4a||0x1f4;return function(_0x426873){logger[_0x7624('0x27')](_0x426873[_0x7624('0x28')]);if(_0x426873['name']){delete _0x426873['name'];}_0x3decbd['status'](_0x182b4a)[_0x7624('0x29')](_0x426873);};}exports[_0x7624('0x2a')]=function(_0x2639c5,_0x126c7f){var _0x3f1056={},_0x648a8b={},_0x432a7a={'count':0x0,'rows':[]};var _0x861e8f=_[_0x7624('0x2b')](db['OpenchannelQueue'][_0x7624('0x2c')],function(_0x1d1131){return{'name':_0x1d1131['fieldName'],'type':_0x1d1131[_0x7624('0x2d')][_0x7624('0x2e')]};});_0x648a8b[_0x7624('0x2f')]=_[_0x7624('0x2b')](_0x861e8f,_0x7624('0x30'));_0x648a8b[_0x7624('0x31')]=_[_0x7624('0x32')](_0x2639c5['query']);_0x648a8b['filters']=_[_0x7624('0x33')](_0x648a8b['model'],_0x648a8b[_0x7624('0x31')]);_0x3f1056[_0x7624('0x34')]=_[_0x7624('0x33')](_0x648a8b['model'],qs[_0x7624('0x35')](_0x2639c5['query'][_0x7624('0x35')]));_0x3f1056['attributes']=_0x3f1056[_0x7624('0x34')][_0x7624('0x36')]?_0x3f1056[_0x7624('0x34')]:_0x648a8b[_0x7624('0x2f')];if(!_0x2639c5[_0x7624('0x31')][_0x7624('0x37')](_0x7624('0x38'))){_0x3f1056[_0x7624('0x39')]=qs['limit'](_0x2639c5[_0x7624('0x31')][_0x7624('0x39')]);_0x3f1056['offset']=qs['offset'](_0x2639c5[_0x7624('0x31')][_0x7624('0x1f')]);}_0x3f1056[_0x7624('0x3a')]=qs[_0x7624('0x3b')](_0x2639c5[_0x7624('0x31')][_0x7624('0x3b')]);_0x3f1056['where']=qs[_0x7624('0x3c')](_[_0x7624('0x3d')](_0x2639c5['query'],_0x648a8b['filters']),_0x861e8f);if(_0x2639c5[_0x7624('0x31')][_0x7624('0x3e')]){_0x3f1056[_0x7624('0x3f')]=_['merge'](_0x3f1056[_0x7624('0x3f')],{'$or':_[_0x7624('0x2b')](_0x861e8f,function(_0x4acb91){if(_0x4acb91['type']!=='VIRTUAL'){var _0x4e02cd={};_0x4e02cd[_0x4acb91[_0x7624('0x30')]]={'$like':'%'+_0x2639c5[_0x7624('0x31')][_0x7624('0x3e')]+'%'};return _0x4e02cd;}})});}_0x3f1056=_['merge']({},_0x3f1056,_0x2639c5[_0x7624('0x40')]);var _0x58bfcb={'where':_0x3f1056['where']};return db[_0x7624('0x41')][_0x7624('0x1e')](_0x58bfcb)[_0x7624('0x24')](function(_0x5dcda6){_0x432a7a['count']=_0x5dcda6;if(_0x2639c5['query'][_0x7624('0x42')]){_0x3f1056[_0x7624('0x43')]=[{'all':!![]}];}return db['OpenchannelQueue'][_0x7624('0x44')](_0x3f1056);})[_0x7624('0x24')](function(_0x1504e4){_0x432a7a[_0x7624('0x45')]=_0x1504e4;return _0x432a7a;})[_0x7624('0x24')](respondWithFilteredResult(_0x126c7f,_0x3f1056))[_0x7624('0x46')](handleError(_0x126c7f,null));};exports[_0x7624('0x47')]=function(_0x3958a0,_0x539ed2){var _0x1d793e={'raw':!![],'where':{'id':_0x3958a0[_0x7624('0x48')]['id']}},_0x595355={};_0x595355[_0x7624('0x2f')]=_[_0x7624('0x32')](db['OpenchannelQueue'][_0x7624('0x2c')]);_0x595355['query']=_[_0x7624('0x32')](_0x3958a0['query']);_0x595355['filters']=_['intersection'](_0x595355[_0x7624('0x2f')],_0x595355[_0x7624('0x31')]);_0x1d793e['attributes']=_[_0x7624('0x33')](_0x595355[_0x7624('0x2f')],qs['fields'](_0x3958a0[_0x7624('0x31')][_0x7624('0x35')]));_0x1d793e['attributes']=_0x1d793e[_0x7624('0x34')][_0x7624('0x36')]?_0x1d793e[_0x7624('0x34')]:_0x595355[_0x7624('0x2f')];if(_0x3958a0[_0x7624('0x31')][_0x7624('0x42')]){_0x1d793e[_0x7624('0x43')]=[{'all':!![]}];}_0x1d793e=_[_0x7624('0x49')]({},_0x1d793e,_0x3958a0[_0x7624('0x40')]);return db[_0x7624('0x41')][_0x7624('0x4a')](_0x1d793e)[_0x7624('0x24')](handleEntityNotFound(_0x539ed2,null))[_0x7624('0x24')](respondWithResult(_0x539ed2,null))['catch'](handleError(_0x539ed2,null));};exports[_0x7624('0x4b')]=function(_0x3b3e07,_0x4f0b6e){return db[_0x7624('0x41')][_0x7624('0x4b')](_0x3b3e07[_0x7624('0x4c')],{})['then'](function(_0x5aedb0){var _0x7a8425=_0x3b3e07[_0x7624('0x4d')][_0x7624('0x26')]({'plain':!![]});if(!_0x7a8425)throw new Error(_0x7624('0x4e'));if(_0x7a8425[_0x7624('0x4f')]===_0x7624('0x4d')){var _0x1bc804=_0x5aedb0[_0x7624('0x26')]({'plain':!![]});var _0x58bc28=_0x7624('0x50');return db[_0x7624('0x51')][_0x7624('0x4a')]({'where':{'name':_0x58bc28,'userProfileId':_0x7a8425['userProfileId']},'raw':!![]})['then'](function(_0x18fc3c){if(_0x18fc3c&&_0x18fc3c[_0x7624('0x52')]===0x0){return db[_0x7624('0x53')][_0x7624('0x4b')]({'name':_0x1bc804[_0x7624('0x30')],'resourceId':_0x1bc804['id'],'type':_0x18fc3c[_0x7624('0x30')],'sectionId':_0x18fc3c['id']},{})[_0x7624('0x24')](function(){return _0x5aedb0;});}else{return _0x5aedb0;}})[_0x7624('0x46')](function(_0x3df0c4){logger[_0x7624('0x27')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x3df0c4);throw _0x3df0c4;});}return _0x5aedb0;})[_0x7624('0x24')](respondWithResult(_0x4f0b6e,0xc9))[_0x7624('0x46')](handleError(_0x4f0b6e,null));};exports['update']=function(_0x4fd2f8,_0x1061da){if(_0x4fd2f8['body']['id']){delete _0x4fd2f8[_0x7624('0x4c')]['id'];}return db[_0x7624('0x41')][_0x7624('0x4a')]({'where':{'id':_0x4fd2f8[_0x7624('0x48')]['id']}})[_0x7624('0x24')](handleEntityNotFound(_0x1061da,null))['then'](saveUpdates(_0x4fd2f8['body'],null))[_0x7624('0x24')](respondWithResult(_0x1061da,null))[_0x7624('0x46')](handleError(_0x1061da,null));};exports[_0x7624('0x25')]=function(_0x2d4b2f,_0x26eb44){return db['OpenchannelQueue']['find']({'where':{'id':_0x2d4b2f[_0x7624('0x48')]['id']}})[_0x7624('0x24')](handleEntityNotFound(_0x26eb44,null))['then'](removeEntity(_0x26eb44,null))[_0x7624('0x46')](handleError(_0x26eb44,null));};exports[_0x7624('0x54')]=function(_0x2c2450,_0x1ab493){return db[_0x7624('0x41')][_0x7624('0x54')]()[_0x7624('0x24')](respondWithResult(_0x1ab493,null))[_0x7624('0x46')](handleError(_0x1ab493,null));};exports[_0x7624('0x55')]=function(_0x335d7c,_0x10cfac,_0x3df126){var _0x58ecb1={'raw':!![],'where':{}},_0x20578a={},_0x328285;return db[_0x7624('0x41')][_0x7624('0x56')]({'where':{'id':_0x335d7c[_0x7624('0x48')]['id']}})[_0x7624('0x24')](handleEntityNotFound(_0x10cfac,null))[_0x7624('0x24')](function(_0x2f0252){if(_0x2f0252){_0x328285=_0x2f0252[_0x7624('0x26')]({'plain':!![]});_0x20578a['model']=_[_0x7624('0x32')](db[_0x7624('0x57')][_0x7624('0x2c')]);_0x20578a[_0x7624('0x31')]=_['keys'](_0x335d7c['query']);_0x20578a[_0x7624('0x3c')]=_[_0x7624('0x33')](_0x20578a[_0x7624('0x2f')],_0x20578a[_0x7624('0x31')]);_0x58ecb1[_0x7624('0x34')]=_['intersection'](_0x20578a['model'],qs['fields'](_0x335d7c[_0x7624('0x31')]['fields']));_0x58ecb1[_0x7624('0x34')]=_0x58ecb1['attributes'][_0x7624('0x36')]?_0x58ecb1[_0x7624('0x34')]:_0x20578a[_0x7624('0x2f')];if(!_0x335d7c[_0x7624('0x31')][_0x7624('0x37')]('nolimit')){_0x58ecb1['limit']=qs[_0x7624('0x39')](_0x335d7c[_0x7624('0x31')][_0x7624('0x39')]);_0x58ecb1[_0x7624('0x1f')]=qs[_0x7624('0x1f')](_0x335d7c[_0x7624('0x31')][_0x7624('0x1f')]);}_0x58ecb1['order']=qs[_0x7624('0x3b')](_0x335d7c['query'][_0x7624('0x3b')]);_0x58ecb1[_0x7624('0x3f')]=qs['filters'](_[_0x7624('0x3d')](_0x335d7c['query'],_0x20578a[_0x7624('0x3c')]));_0x58ecb1['where']['OpenchannelQueueId']=_0x2f0252['id'];if(_0x335d7c['query'][_0x7624('0x3e')]){_0x58ecb1[_0x7624('0x3f')]=_['merge'](_0x58ecb1[_0x7624('0x3f')],{'$or':_['map'](_0x58ecb1['attributes'],function(_0xdeece1){var _0xeb44e1={};_0xeb44e1[_0xdeece1]={'$like':'%'+_0x335d7c[_0x7624('0x31')][_0x7624('0x3e')]+'%'};return _0xeb44e1;})});}_0x58ecb1=_[_0x7624('0x49')]({},_0x58ecb1,_0x335d7c[_0x7624('0x40')]);return db['UserOpenchannelQueue'][_0x7624('0x44')](_0x58ecb1);}})[_0x7624('0x24')](function(_0x84ce74){if(_0x84ce74){return db['User'][_0x7624('0x58')]({'where':{'id':_[_0x7624('0x2b')](_0x84ce74,'UserId'),'role':_0x7624('0x59')},'attributes':['id','name',_0x7624('0x5a'),_0x7624('0x5b'),_0x7624('0x5c')]});}})['then'](function(_0x3913ca){if(_0x3913ca){return{'count':_0x3913ca[_0x7624('0x1e')],'rows':_[_0x7624('0x2b')](_0x3913ca[_0x7624('0x45')],function(_0x41c44c){return{'membername':_0x41c44c[_0x7624('0x30')],'UserId':_0x41c44c['id'],'queue_name':_0x328285[_0x7624('0x30')],'OpenchannelQueueId':_0x328285['id'],'interface':util[_0x7624('0x5d')](_0x7624('0x5e'),_0x7624('0x5f'),_0x41c44c[_0x7624('0x30')]),'penalty':0x0,'paused':_0x41c44c[_0x7624('0x5a')],'createdAt':_0x41c44c['createdAt'],'updatedAt':_0x41c44c[_0x7624('0x5b')]};})};}else{return{'count':0x0,'rows':[]};}})['then'](respondWithFilteredResult(_0x10cfac,_0x58ecb1))['catch'](handleError(_0x10cfac,null));};exports[_0x7624('0x60')]=function(_0x14e5e9,_0x28b08e,_0x369768){var _0x1c185d={};var _0x211996={};var _0x311cc0;var _0x951692;return db[_0x7624('0x41')][_0x7624('0x56')]({'where':{'id':_0x14e5e9[_0x7624('0x48')]['id']}})['then'](handleEntityNotFound(_0x28b08e,null))[_0x7624('0x24')](function(_0x370f30){if(_0x370f30){_0x311cc0=_0x370f30;_0x211996['model']=_[_0x7624('0x32')](db[_0x7624('0x61')][_0x7624('0x2c')]);_0x211996['query']=_['keys'](_0x14e5e9[_0x7624('0x31')]);_0x211996['filters']=_[_0x7624('0x33')](_0x211996[_0x7624('0x2f')],_0x211996['query']);_0x1c185d['attributes']=_[_0x7624('0x33')](_0x211996[_0x7624('0x2f')],qs[_0x7624('0x35')](_0x14e5e9[_0x7624('0x31')][_0x7624('0x35')]));_0x1c185d[_0x7624('0x34')]=_0x1c185d['attributes'][_0x7624('0x36')]?_0x1c185d[_0x7624('0x34')]:_0x211996['model'];_0x1c185d[_0x7624('0x3a')]=qs[_0x7624('0x3b')](_0x14e5e9[_0x7624('0x31')][_0x7624('0x3b')]);_0x1c185d[_0x7624('0x3f')]=qs[_0x7624('0x3c')](_['pick'](_0x14e5e9['query'],_0x211996[_0x7624('0x3c')]));if(_0x14e5e9[_0x7624('0x31')]['filter']){_0x1c185d[_0x7624('0x3f')]=_[_0x7624('0x49')](_0x1c185d['where'],{'$or':_[_0x7624('0x2b')](_0x1c185d[_0x7624('0x34')],function(_0x5832de){var _0x3b5d11={};_0x3b5d11[_0x5832de]={'$like':'%'+_0x14e5e9['query'][_0x7624('0x3e')]+'%'};return _0x3b5d11;})});}_0x1c185d=_[_0x7624('0x49')]({},_0x1c185d,_0x14e5e9[_0x7624('0x40')]);return _0x311cc0[_0x7624('0x60')](_0x1c185d);}})[_0x7624('0x24')](function(_0x316c26){if(_0x316c26){_0x951692=_0x316c26[_0x7624('0x36')];if(!_0x14e5e9['query'][_0x7624('0x37')](_0x7624('0x38'))){_0x1c185d[_0x7624('0x39')]=qs[_0x7624('0x39')](_0x14e5e9[_0x7624('0x31')][_0x7624('0x39')]);_0x1c185d[_0x7624('0x1f')]=qs['offset'](_0x14e5e9[_0x7624('0x31')][_0x7624('0x1f')]);}return _0x311cc0[_0x7624('0x60')](_0x1c185d);}})[_0x7624('0x24')](function(_0x213fd6){if(_0x213fd6){return _0x213fd6?{'count':_0x951692,'rows':_0x213fd6}:null;}})['then'](respondWithResult(_0x28b08e,null))[_0x7624('0x46')](handleError(_0x28b08e,null));};exports[_0x7624('0x62')]=function(_0x3ce10d,_0x2f1931,_0x4472b0){var _0x52072d=_0x3ce10d['body']['ids'];return db[_0x7624('0x61')][_0x7624('0x44')]({'where':{'id':_0x52072d},'attributes':['id'],'include':[{'model':db[_0x7624('0x63')],'as':'Agents','attributes':['id',_0x7624('0x30'),_0x7624('0x64'),_0x7624('0x65'),_0x7624('0x66')],'raw':!![]}]})[_0x7624('0x24')](function(_0x34d0cf){if(_0x34d0cf){var _0x14b1c5=_[_0x7624('0x67')](_0x34d0cf,function(_0xb92dd0){var _0x278ce0=_0xb92dd0[_0x7624('0x26')]({'plain':!![]});return _0x278ce0['Agents'];});return db[_0x7624('0x41')][_0x7624('0x4a')]({'where':{'id':_0x3ce10d['params']['id']}})[_0x7624('0x24')](function(_0x5de90c){return db[_0x7624('0x68')]['transaction'](function(_0x4f632f){return _0x5de90c[_0x7624('0x62')](_0x52072d,{'transaction':_0x4f632f})[_0x7624('0x24')](function(){return BPromise[_0x7624('0x69')](_0x14b1c5,function(_0x263d4a){return db[_0x7624('0x57')]['findOrCreate']({'where':{'UserId':_0x263d4a['id'],'OpenchannelQueueId':_0x3ce10d[_0x7624('0x48')]['id']},'transaction':_0x4f632f});});})[_0x7624('0x24')](function(){_0x14b1c5[_0x7624('0x6a')](function(_0x1e0186){socket['emit'](_0x7624('0x6b'),{'UserId':_0x1e0186['id'],'OpenchannelQueueId':_0x5de90c['id']});});});});});}})[_0x7624('0x24')](respondWithStatusCode(_0x2f1931,null))[_0x7624('0x46')](handleError(_0x2f1931,null));};exports[_0x7624('0x6c')]=function(_0x23b365,_0x316981,_0x537b34){return db[_0x7624('0x61')][_0x7624('0x44')]({'where':{'id':_0x23b365[_0x7624('0x31')][_0x7624('0x6d')]},'attributes':['id'],'include':[{'model':db['User'],'as':_0x7624('0x6e'),'attributes':['id'],'raw':!![]}]})[_0x7624('0x24')](handleEntityNotFound(_0x316981,null))[_0x7624('0x24')](function(_0x14af26){var _0x252b8b=_[_0x7624('0x2b')](_0x14af26,'id');var _0x28c426=[];var _0x57c064=[];var _0x2d3851=squel[_0x7624('0x6f')]();_0x2d3851['field'](_0x7624('0x70'))[_0x7624('0x71')]('team_has_openchannel_queues','tq')[_0x7624('0x72')](_0x7624('0x73'),'ut',_0x7624('0x74'))['where'](_0x7624('0x75'),_0x23b365[_0x7624('0x48')]['id']);for(var _0x2c19db=0x0;_0x2c19db<_0x14af26[_0x7624('0x36')];_0x2c19db+=0x1){let _0x145e1f=_0x14af26[_0x2c19db];for(var _0x5c0edc=0x0;_0x5c0edc<_0x145e1f[_0x7624('0x6e')][_0x7624('0x36')];_0x5c0edc+=0x1){let _0xa5df3c=_0x145e1f[_0x7624('0x6e')][_0x5c0edc];var _0x3fdb02=_0x2d3851[_0x7624('0x76')]();_0x3fdb02['where'](_0x7624('0x77'),_0xa5df3c['id']);_0x57c064[_0x7624('0x78')](db[_0x7624('0x68')][_0x7624('0x31')](_0x3fdb02['toString'](),{'type':db[_0x7624('0x68')][_0x7624('0x79')]['SELECT']})['then'](function(_0x5b485f){if(_0x5b485f[_0x7624('0x36')]===0x1){return _0xa5df3c['id'];}else{var _0x28a756=_['every'](_[_0x7624('0x2b')](_0x5b485f,'TeamId'),function(_0x419795){return _['includes'](_0x252b8b,_0x419795);});if(_0x28a756){return _0xa5df3c['id'];}}}));}}return BPromise[_0x7624('0x7a')](_0x57c064)[_0x7624('0x24')](function(_0x239d27){_0x28c426=_(_0x28c426)[_0x7624('0x7b')](_0x239d27)['compact']()[_0x7624('0x7c')]();return db[_0x7624('0x41')][_0x7624('0x4a')]({'where':{'id':_0x23b365[_0x7624('0x48')]['id']}})[_0x7624('0x24')](function(_0xa86d4a){return db[_0x7624('0x68')][_0x7624('0x7d')](function(_0x2ca606){return _0xa86d4a['removeTeams'](_0x23b365[_0x7624('0x31')][_0x7624('0x6d')],{'transaction':_0x2ca606})['then'](function(){if(!_[_0x7624('0x7e')](_0x28c426)){return _0xa86d4a[_0x7624('0x7f')](_0x28c426,{'transaction':_0x2ca606});}})[_0x7624('0x24')](function(){_0x28c426[_0x7624('0x6a')](function(_0x49eabb){socket[_0x7624('0x80')](_0x7624('0x81'),{'UserId':_0x49eabb,'OpenchannelQueueId':_0xa86d4a['id']});});});});});});})['then'](respondWithStatusCode(_0x316981,null))['catch'](handleError(_0x316981,null));};exports[_0x7624('0x82')]=function(_0x314195,_0x1f213b,_0x53eb8d){return db[_0x7624('0x41')]['find']({'where':{'id':_0x314195['params']['id']}})[_0x7624('0x24')](handleEntityNotFound(_0x1f213b,null))['then'](function(_0x21b0d3){if(_0x21b0d3){return _0x21b0d3[_0x7624('0x82')](_0x314195[_0x7624('0x4c')]['ids'],_[_0x7624('0x83')](_0x314195[_0x7624('0x4c')],['ids','id'])||{})['spread'](function(_0x5c69c3){for(var _0x223d1b=0x0;_0x223d1b<_0x314195[_0x7624('0x4c')][_0x7624('0x6d')]['length'];_0x223d1b+=0x1){socket['emit'](_0x7624('0x6b'),{'UserId':_0x314195['body']['ids'][_0x223d1b],'OpenchannelQueueId':_0x314195[_0x7624('0x48')]['id']});}return _0x5c69c3;});}})['then'](respondWithResult(_0x1f213b,null))[_0x7624('0x46')](handleError(_0x1f213b,null));};exports[_0x7624('0x7f')]=function(_0x55c276,_0x5ae36a,_0xebed8d){return db[_0x7624('0x41')][_0x7624('0x4a')]({'where':{'id':_0x55c276[_0x7624('0x48')]['id']}})[_0x7624('0x24')](handleEntityNotFound(_0x5ae36a,null))[_0x7624('0x24')](function(_0x4e4495){if(_0x4e4495){return _0x4e4495['removeAgents'](_0x55c276['query'][_0x7624('0x6d')])['then'](function(){if(_[_0x7624('0x84')](_0x55c276['query'][_0x7624('0x6d')])){for(var _0x49a634=0x0;_0x49a634<_0x55c276[_0x7624('0x31')][_0x7624('0x6d')][_0x7624('0x36')];_0x49a634+=0x1){socket[_0x7624('0x80')]('userOpenchannelQueue:remove',{'UserId':Number(_0x55c276['query']['ids'][_0x49a634]),'OpenchannelQueueId':Number(_0x55c276['params']['id'])});}}else{socket[_0x7624('0x80')](_0x7624('0x81'),{'UserId':Number(_0x55c276[_0x7624('0x31')]['ids']),'OpenchannelQueueId':Number(_0x55c276[_0x7624('0x48')]['id'])});}});}})[_0x7624('0x24')](respondWithStatusCode(_0x5ae36a,null))['catch'](handleError(_0x5ae36a,null));};exports[_0x7624('0x85')]=function(_0x1126cb,_0x5126f7,_0x5ece6c){var _0x2153d2={};var _0x22a054={};var _0x4ee1aa;var _0x52d0f4;return db['OpenchannelQueue']['findOne']({'where':{'id':_0x1126cb[_0x7624('0x48')]['id']}})[_0x7624('0x24')](handleEntityNotFound(_0x5126f7,null))[_0x7624('0x24')](function(_0x179c35){if(_0x179c35){_0x4ee1aa=_0x179c35;_0x22a054[_0x7624('0x2f')]=_['keys'](db[_0x7624('0x63')][_0x7624('0x2c')]);_0x22a054[_0x7624('0x31')]=_[_0x7624('0x32')](_0x1126cb[_0x7624('0x31')]);_0x22a054[_0x7624('0x3c')]=_[_0x7624('0x33')](_0x22a054[_0x7624('0x2f')],_0x22a054['query']);_0x2153d2[_0x7624('0x34')]=_[_0x7624('0x33')](_0x22a054[_0x7624('0x2f')],qs[_0x7624('0x35')](_0x1126cb['query'][_0x7624('0x35')]));_0x2153d2[_0x7624('0x34')]=_0x2153d2[_0x7624('0x34')]['length']?_0x2153d2[_0x7624('0x34')]:_0x22a054[_0x7624('0x2f')];_0x2153d2[_0x7624('0x3a')]=qs['sort'](_0x1126cb[_0x7624('0x31')]['sort']);_0x2153d2[_0x7624('0x3f')]=qs[_0x7624('0x3c')](_['pick'](_0x1126cb[_0x7624('0x31')],_0x22a054[_0x7624('0x3c')]));if(_0x1126cb[_0x7624('0x31')]['filter']){_0x2153d2[_0x7624('0x3f')]=_[_0x7624('0x49')](_0x2153d2[_0x7624('0x3f')],{'$or':_[_0x7624('0x2b')](_0x2153d2['attributes'],function(_0x5e66df){var _0x2c0e20={};_0x2c0e20[_0x5e66df]={'$like':'%'+_0x1126cb[_0x7624('0x31')][_0x7624('0x3e')]+'%'};return _0x2c0e20;})});}_0x2153d2=_[_0x7624('0x49')]({},_0x2153d2,_0x1126cb[_0x7624('0x40')]);return _0x4ee1aa[_0x7624('0x85')](_0x2153d2);}})[_0x7624('0x24')](function(_0x27fa37){if(_0x27fa37){_0x52d0f4=_0x27fa37[_0x7624('0x36')];if(!_0x1126cb[_0x7624('0x31')][_0x7624('0x37')](_0x7624('0x38'))){_0x2153d2[_0x7624('0x39')]=qs[_0x7624('0x39')](_0x1126cb[_0x7624('0x31')][_0x7624('0x39')]);_0x2153d2['offset']=qs[_0x7624('0x1f')](_0x1126cb['query'][_0x7624('0x1f')]);}return _0x4ee1aa[_0x7624('0x85')](_0x2153d2);}})[_0x7624('0x24')](function(_0x2a89bc){if(_0x2a89bc){return _0x2a89bc?{'count':_0x52d0f4,'rows':_0x2a89bc}:null;}})['then'](respondWithResult(_0x5126f7,null))['catch'](handleError(_0x5126f7,null));};