Built motion from commit e1760111.|2.6.18
[motion2.git] / server / api / chatQueue / chatQueue.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 _0x110c=['field','tq.TeamId','team_has_chat_queues','join','user_has_teams','ChatQueueId\x20=\x20?','ut.UserId\x20=\x20?','QueryTypes','every','TeamId','all','union','compact','value','removeTeams','removeAgents','spread','emit','isArray','userChatQueue:remove','getAgents','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','sox','to-csv','ejs','fs-extra','lodash','crypto','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./chatQueue.socket','register','jayson/promise','client','http','request','ChatQueue,\x20%s,\x20%s','request\x20sent','debug','ChatQueue,\x20%s,\x20%s,\x20%s','error','code','message','info','result','catch','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','save','then','destroy','get','ChatQueues','UserProfileResource','stack','name','send','index','ChatQueue','rawAttributes','key','map','query','intersection','model','fields','attributes','length','hasOwnProperty','nolimit','order','sort','where','filters','pick','filter','merge','type','includeAll','findAll','rows','show','keys','include','options','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','autoAssociation','update','params','describe','getMembers','findOne','ChatQueueId','User','UserId','chatPause','updatedAt','createdAt','getTeams','Team','addTeams','ids','Agents','online','voicePause','sequelize','transaction','UserChatQueue','forEach','userChatQueue:save','select'];(function(_0x10c760,_0x1c2ce3){var _0x36471d=function(_0x1856a4){while(--_0x1856a4){_0x10c760['push'](_0x10c760['shift']());}};_0x36471d(++_0x1c2ce3);}(_0x110c,0x141));var _0xc110=function(_0x178e48,_0x3c9509){_0x178e48=_0x178e48-0x0;var _0x440d7e=_0x110c[_0x178e48];return _0x440d7e;};'use strict';var emlformat=require(_0xc110('0x0'));var rimraf=require(_0xc110('0x1'));var zipdir=require(_0xc110('0x2'));var jsonpatch=require(_0xc110('0x3'));var rp=require(_0xc110('0x4'));var moment=require(_0xc110('0x5'));var BPromise=require(_0xc110('0x6'));var Mustache=require(_0xc110('0x7'));var util=require(_0xc110('0x8'));var path=require('path');var sox=require(_0xc110('0x9'));var csv=require(_0xc110('0xa'));var ejs=require(_0xc110('0xb'));var fs=require('fs');var fs_extra=require(_0xc110('0xc'));var _=require(_0xc110('0xd'));var squel=require('squel');var crypto=require(_0xc110('0xe'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0xc110('0xa'));var querystring=require(_0xc110('0xf'));var Papa=require(_0xc110('0x10'));var Redis=require(_0xc110('0x11'));var authService=require(_0xc110('0x12'));var qs=require(_0xc110('0x13'));var as=require(_0xc110('0x14'));var hardwareService=require(_0xc110('0x15'));var logger=require(_0xc110('0x16'))(_0xc110('0x17'));var utils=require(_0xc110('0x18'));var config=require(_0xc110('0x19'));var licenseUtil=require(_0xc110('0x1a'));var db=require(_0xc110('0x1b'))['db'];config[_0xc110('0x1c')]=_[_0xc110('0x1d')](config[_0xc110('0x1c')],{'host':_0xc110('0x1e'),'port':0x18eb});var socket=require(_0xc110('0x1f'))(new Redis(config[_0xc110('0x1c')]));require(_0xc110('0x20'))[_0xc110('0x21')](socket);var jayson=require(_0xc110('0x22'));var client=jayson[_0xc110('0x23')][_0xc110('0x24')]({'port':0x232a});function respondWithRpcPromise(_0x47ed77,_0x45c416,_0x167b42,_0x4e2068){return new BPromise(function(_0x2af2a2,_0x5dafcd){var _0x4f1fb2=_0x4e2068||client;return _0x4f1fb2[_0xc110('0x25')](_0x47ed77,_0x167b42)['then'](function(_0x27a4ac){logger['info'](_0xc110('0x26'),_0x45c416,_0xc110('0x27'));logger[_0xc110('0x28')](_0xc110('0x29'),_0x45c416,_0xc110('0x27'),JSON['stringify'](_0x27a4ac));if(_0x27a4ac[_0xc110('0x2a')]){if(_0x27a4ac[_0xc110('0x2a')][_0xc110('0x2b')]===0x1f4){logger[_0xc110('0x2a')](_0xc110('0x26'),_0x45c416,_0x27a4ac[_0xc110('0x2a')][_0xc110('0x2c')]);return _0x5dafcd(_0x27a4ac[_0xc110('0x2a')][_0xc110('0x2c')]);}logger[_0xc110('0x2a')](_0xc110('0x26'),_0x45c416,_0x27a4ac[_0xc110('0x2a')][_0xc110('0x2c')]);return _0x2af2a2(_0x27a4ac[_0xc110('0x2a')][_0xc110('0x2c')]);}else{logger[_0xc110('0x2d')]('ChatQueue,\x20%s,\x20%s',_0x45c416,'request\x20sent');_0x2af2a2(_0x27a4ac[_0xc110('0x2e')]['message']);}})[_0xc110('0x2f')](function(_0x5689d2){logger[_0xc110('0x2a')]('ChatQueue,\x20%s,\x20%s',_0x45c416,_0x5689d2);_0x5dafcd(_0x5689d2);});});}function respondWithStatusCode(_0x13ecb7,_0x321d66){_0x321d66=_0x321d66||0xcc;return function(_0x1985c3){if(_0x1985c3){return _0x13ecb7[_0xc110('0x30')](_0x321d66);}return _0x13ecb7[_0xc110('0x31')](_0x321d66)[_0xc110('0x32')]();};}function respondWithResult(_0x18e3fc,_0x4ea5bc){_0x4ea5bc=_0x4ea5bc||0xc8;return function(_0x432187){if(_0x432187){return _0x18e3fc[_0xc110('0x31')](_0x4ea5bc)[_0xc110('0x33')](_0x432187);}};}function respondWithFilteredResult(_0x378195,_0x16fb4e){return function(_0x2e8257){if(_0x2e8257){var _0x134384=typeof _0x16fb4e[_0xc110('0x34')]===_0xc110('0x35')&&typeof _0x16fb4e[_0xc110('0x36')]===_0xc110('0x35');var _0x2380cd=_0x2e8257['count'];var _0x139236=_0x134384?0x0:_0x16fb4e['offset'];var _0x5b14e1=_0x134384?_0x2e8257[_0xc110('0x37')]:_0x16fb4e[_0xc110('0x34')]+_0x16fb4e[_0xc110('0x36')];var _0x48e0f7;if(_0x5b14e1>=_0x2380cd){_0x5b14e1=_0x2380cd;_0x48e0f7=0xc8;}else{_0x48e0f7=0xce;}_0x378195[_0xc110('0x31')](_0x48e0f7);return _0x378195[_0xc110('0x38')](_0xc110('0x39'),_0x139236+'-'+_0x5b14e1+'/'+_0x2380cd)[_0xc110('0x33')](_0x2e8257);}return null;};}function patchUpdates(_0x5de7e1){return function(_0x1da380){try{jsonpatch[_0xc110('0x3a')](_0x1da380,_0x5de7e1,!![]);}catch(_0x4895c1){return BPromise['reject'](_0x4895c1);}return _0x1da380[_0xc110('0x3b')]();};}function saveUpdates(_0x27ff6b,_0x1a686b){return function(_0x1276a7){if(_0x1276a7){return _0x1276a7['update'](_0x27ff6b)[_0xc110('0x3c')](function(_0x13c99e){return _0x13c99e;});}return null;};}function removeEntity(_0x27d434,_0x235975){return function(_0x47cb5b){if(_0x47cb5b){return _0x47cb5b[_0xc110('0x3d')]()[_0xc110('0x3c')](function(){var _0x5540ef=_0x47cb5b[_0xc110('0x3e')]({'plain':!![]});var _0x52b456=_0xc110('0x3f');return db[_0xc110('0x40')][_0xc110('0x3d')]({'where':{'type':_0x52b456,'resourceId':_0x5540ef['id']}})[_0xc110('0x3c')](function(){return _0x47cb5b;});})[_0xc110('0x3c')](function(){_0x27d434['status'](0xcc)[_0xc110('0x32')]();});}};}function handleEntityNotFound(_0x2f4ffa,_0x399ec1){return function(_0x275743){if(!_0x275743){_0x2f4ffa[_0xc110('0x30')](0x194);}return _0x275743;};}function handleError(_0x47bb6d,_0x4be720){_0x4be720=_0x4be720||0x1f4;return function(_0x172305){logger['error'](_0x172305[_0xc110('0x41')]);if(_0x172305[_0xc110('0x42')]){delete _0x172305[_0xc110('0x42')];}_0x47bb6d[_0xc110('0x31')](_0x4be720)[_0xc110('0x43')](_0x172305);};}exports[_0xc110('0x44')]=function(_0x5ccea4,_0x3b4b97){var _0x3211e1={},_0x424736={},_0x5c650f={'count':0x0,'rows':[]};var _0x1d482c=_['map'](db[_0xc110('0x45')][_0xc110('0x46')],function(_0xc64916){return{'name':_0xc64916['fieldName'],'type':_0xc64916['type'][_0xc110('0x47')]};});_0x424736['model']=_[_0xc110('0x48')](_0x1d482c,'name');_0x424736[_0xc110('0x49')]=_['keys'](_0x5ccea4['query']);_0x424736['filters']=_[_0xc110('0x4a')](_0x424736[_0xc110('0x4b')],_0x424736[_0xc110('0x49')]);_0x3211e1['attributes']=_[_0xc110('0x4a')](_0x424736[_0xc110('0x4b')],qs[_0xc110('0x4c')](_0x5ccea4[_0xc110('0x49')][_0xc110('0x4c')]));_0x3211e1['attributes']=_0x3211e1[_0xc110('0x4d')][_0xc110('0x4e')]?_0x3211e1[_0xc110('0x4d')]:_0x424736['model'];if(!_0x5ccea4[_0xc110('0x49')][_0xc110('0x4f')](_0xc110('0x50'))){_0x3211e1[_0xc110('0x36')]=qs['limit'](_0x5ccea4[_0xc110('0x49')][_0xc110('0x36')]);_0x3211e1[_0xc110('0x34')]=qs[_0xc110('0x34')](_0x5ccea4[_0xc110('0x49')]['offset']);}_0x3211e1[_0xc110('0x51')]=qs[_0xc110('0x52')](_0x5ccea4['query'][_0xc110('0x52')]);_0x3211e1[_0xc110('0x53')]=qs[_0xc110('0x54')](_[_0xc110('0x55')](_0x5ccea4[_0xc110('0x49')],_0x424736['filters']),_0x1d482c);if(_0x5ccea4[_0xc110('0x49')][_0xc110('0x56')]){_0x3211e1[_0xc110('0x53')]=_[_0xc110('0x57')](_0x3211e1[_0xc110('0x53')],{'$or':_[_0xc110('0x48')](_0x1d482c,function(_0x27193e){if(_0x27193e[_0xc110('0x58')]!=='VIRTUAL'){var _0x3533d7={};_0x3533d7[_0x27193e[_0xc110('0x42')]]={'$like':'%'+_0x5ccea4[_0xc110('0x49')][_0xc110('0x56')]+'%'};return _0x3533d7;}})});}_0x3211e1=_[_0xc110('0x57')]({},_0x3211e1,_0x5ccea4['options']);var _0x48bedb={'where':_0x3211e1[_0xc110('0x53')]};return db['ChatQueue']['count'](_0x48bedb)[_0xc110('0x3c')](function(_0x24b195){_0x5c650f[_0xc110('0x37')]=_0x24b195;if(_0x5ccea4['query'][_0xc110('0x59')]){_0x3211e1['include']=[{'all':!![]}];}return db[_0xc110('0x45')][_0xc110('0x5a')](_0x3211e1);})[_0xc110('0x3c')](function(_0x20924a){_0x5c650f[_0xc110('0x5b')]=_0x20924a;return _0x5c650f;})['then'](respondWithFilteredResult(_0x3b4b97,_0x3211e1))['catch'](handleError(_0x3b4b97,null));};exports[_0xc110('0x5c')]=function(_0x32f311,_0x1a6f4a){var _0x6e9651={'raw':!![],'where':{'id':_0x32f311['params']['id']}},_0xf58d02={};_0xf58d02[_0xc110('0x4b')]=_[_0xc110('0x5d')](db['ChatQueue'][_0xc110('0x46')]);_0xf58d02[_0xc110('0x49')]=_[_0xc110('0x5d')](_0x32f311[_0xc110('0x49')]);_0xf58d02[_0xc110('0x54')]=_[_0xc110('0x4a')](_0xf58d02[_0xc110('0x4b')],_0xf58d02['query']);_0x6e9651['attributes']=_[_0xc110('0x4a')](_0xf58d02[_0xc110('0x4b')],qs[_0xc110('0x4c')](_0x32f311[_0xc110('0x49')][_0xc110('0x4c')]));_0x6e9651['attributes']=_0x6e9651[_0xc110('0x4d')][_0xc110('0x4e')]?_0x6e9651[_0xc110('0x4d')]:_0xf58d02[_0xc110('0x4b')];if(_0x32f311['query'][_0xc110('0x59')]){_0x6e9651[_0xc110('0x5e')]=[{'all':!![]}];}_0x6e9651=_['merge']({},_0x6e9651,_0x32f311[_0xc110('0x5f')]);return db['ChatQueue'][_0xc110('0x60')](_0x6e9651)[_0xc110('0x3c')](handleEntityNotFound(_0x1a6f4a,null))[_0xc110('0x3c')](respondWithResult(_0x1a6f4a,null))[_0xc110('0x2f')](handleError(_0x1a6f4a,null));};exports[_0xc110('0x61')]=function(_0x20f9fe,_0x4472a4){return db[_0xc110('0x45')][_0xc110('0x61')](_0x20f9fe[_0xc110('0x62')],{})[_0xc110('0x3c')](function(_0x28a358){var _0x2aa9e3=_0x20f9fe[_0xc110('0x63')][_0xc110('0x3e')]({'plain':!![]});if(!_0x2aa9e3)throw new Error(_0xc110('0x64'));if(_0x2aa9e3[_0xc110('0x65')]===_0xc110('0x63')){var _0x25a843=_0x28a358[_0xc110('0x3e')]({'plain':!![]});var _0x4fb539=_0xc110('0x3f');return db[_0xc110('0x66')]['find']({'where':{'name':_0x4fb539,'userProfileId':_0x2aa9e3[_0xc110('0x67')]},'raw':!![]})[_0xc110('0x3c')](function(_0x48116a){if(_0x48116a&&_0x48116a[_0xc110('0x68')]===0x0){return db[_0xc110('0x40')][_0xc110('0x61')]({'name':_0x25a843[_0xc110('0x42')],'resourceId':_0x25a843['id'],'type':_0x48116a[_0xc110('0x42')],'sectionId':_0x48116a['id']},{})[_0xc110('0x3c')](function(){return _0x28a358;});}else{return _0x28a358;}})[_0xc110('0x2f')](function(_0x4e5f52){logger[_0xc110('0x2a')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x4e5f52);throw _0x4e5f52;});}return _0x28a358;})[_0xc110('0x3c')](respondWithResult(_0x4472a4,0xc9))['catch'](handleError(_0x4472a4,null));};exports[_0xc110('0x69')]=function(_0x41451c,_0x13e7ac){if(_0x41451c[_0xc110('0x62')]['id']){delete _0x41451c[_0xc110('0x62')]['id'];}return db[_0xc110('0x45')]['find']({'where':{'id':_0x41451c[_0xc110('0x6a')]['id']}})[_0xc110('0x3c')](handleEntityNotFound(_0x13e7ac,null))['then'](saveUpdates(_0x41451c[_0xc110('0x62')],null))[_0xc110('0x3c')](respondWithResult(_0x13e7ac,null))['catch'](handleError(_0x13e7ac,null));};exports['destroy']=function(_0x3cafd4,_0x438e59){return db[_0xc110('0x45')][_0xc110('0x60')]({'where':{'id':_0x3cafd4[_0xc110('0x6a')]['id']}})['then'](handleEntityNotFound(_0x438e59,null))[_0xc110('0x3c')](removeEntity(_0x438e59,null))[_0xc110('0x2f')](handleError(_0x438e59,null));};exports[_0xc110('0x6b')]=function(_0x1e0549,_0x41f830){return db[_0xc110('0x45')][_0xc110('0x6b')]()[_0xc110('0x3c')](respondWithResult(_0x41f830,null))[_0xc110('0x2f')](handleError(_0x41f830,null));};exports[_0xc110('0x6c')]=function(_0x3c0b11,_0xc9518b,_0x2dd75d){var _0x4899ae={'raw':!![],'where':{}},_0x4bfa1c={},_0x26dacc;return db[_0xc110('0x45')][_0xc110('0x6d')]({'where':{'id':_0x3c0b11[_0xc110('0x6a')]['id']}})['then'](handleEntityNotFound(_0xc9518b,null))['then'](function(_0x37db58){if(_0x37db58){_0x26dacc=_0x37db58['get']({'plain':!![]});_0x4bfa1c[_0xc110('0x4b')]=_['keys'](db['UserChatQueue'][_0xc110('0x46')]);_0x4bfa1c['query']=_[_0xc110('0x5d')](_0x3c0b11[_0xc110('0x49')]);_0x4bfa1c[_0xc110('0x54')]=_[_0xc110('0x4a')](_0x4bfa1c[_0xc110('0x4b')],_0x4bfa1c[_0xc110('0x49')]);_0x4899ae[_0xc110('0x4d')]=_[_0xc110('0x4a')](_0x4bfa1c[_0xc110('0x4b')],qs[_0xc110('0x4c')](_0x3c0b11['query'][_0xc110('0x4c')]));_0x4899ae[_0xc110('0x4d')]=_0x4899ae[_0xc110('0x4d')][_0xc110('0x4e')]?_0x4899ae[_0xc110('0x4d')]:_0x4bfa1c['model'];if(!_0x3c0b11['query'][_0xc110('0x4f')](_0xc110('0x50'))){_0x4899ae[_0xc110('0x36')]=qs[_0xc110('0x36')](_0x3c0b11[_0xc110('0x49')]['limit']);_0x4899ae['offset']=qs['offset'](_0x3c0b11[_0xc110('0x49')][_0xc110('0x34')]);}_0x4899ae[_0xc110('0x51')]=qs[_0xc110('0x52')](_0x3c0b11[_0xc110('0x49')][_0xc110('0x52')]);_0x4899ae[_0xc110('0x53')]=qs[_0xc110('0x54')](_[_0xc110('0x55')](_0x3c0b11['query'],_0x4bfa1c[_0xc110('0x54')]));_0x4899ae[_0xc110('0x53')][_0xc110('0x6e')]=_0x37db58['id'];if(_0x3c0b11[_0xc110('0x49')][_0xc110('0x56')]){_0x4899ae[_0xc110('0x53')]=_['merge'](_0x4899ae[_0xc110('0x53')],{'$or':_[_0xc110('0x48')](_0x4899ae[_0xc110('0x4d')],function(_0x319a94){var _0x20c6b2={};_0x20c6b2[_0x319a94]={'$like':'%'+_0x3c0b11[_0xc110('0x49')]['filter']+'%'};return _0x20c6b2;})});}_0x4899ae=_[_0xc110('0x57')]({},_0x4899ae,_0x3c0b11[_0xc110('0x5f')]);return db['UserChatQueue'][_0xc110('0x5a')](_0x4899ae);}})[_0xc110('0x3c')](function(_0x1d5779){if(_0x1d5779){return db[_0xc110('0x6f')]['findAndCountAll']({'where':{'id':_[_0xc110('0x48')](_0x1d5779,_0xc110('0x70')),'role':'agent'},'attributes':['id',_0xc110('0x42'),_0xc110('0x71'),_0xc110('0x72'),_0xc110('0x73')]});}})[_0xc110('0x3c')](function(_0x1b8525){if(_0x1b8525){return{'count':_0x1b8525[_0xc110('0x37')],'rows':_[_0xc110('0x48')](_0x1b8525[_0xc110('0x5b')],function(_0x30a8ce){return{'membername':_0x30a8ce[_0xc110('0x42')],'UserId':_0x30a8ce['id'],'queue_name':_0x26dacc['name'],'ChatQueueId':_0x26dacc['id'],'interface':util['format']('%s/%s','SIP',_0x30a8ce[_0xc110('0x42')]),'penalty':0x0,'paused':_0x30a8ce[_0xc110('0x71')],'createdAt':_0x30a8ce[_0xc110('0x73')],'updatedAt':_0x30a8ce[_0xc110('0x72')]};})};}else{return{'count':0x0,'rows':[]};}})[_0xc110('0x3c')](respondWithFilteredResult(_0xc9518b,_0x4899ae))['catch'](handleError(_0xc9518b,null));};exports[_0xc110('0x74')]=function(_0x124b9e,_0x45d113,_0x1f535c){var _0x621620={};var _0x25f57c={};var _0x36e627;var _0x114207;return db[_0xc110('0x45')][_0xc110('0x6d')]({'where':{'id':_0x124b9e[_0xc110('0x6a')]['id']}})[_0xc110('0x3c')](handleEntityNotFound(_0x45d113,null))[_0xc110('0x3c')](function(_0x43d0f7){if(_0x43d0f7){_0x36e627=_0x43d0f7;_0x25f57c[_0xc110('0x4b')]=_['keys'](db[_0xc110('0x75')]['rawAttributes']);_0x25f57c[_0xc110('0x49')]=_[_0xc110('0x5d')](_0x124b9e['query']);_0x25f57c['filters']=_['intersection'](_0x25f57c[_0xc110('0x4b')],_0x25f57c[_0xc110('0x49')]);_0x621620['attributes']=_[_0xc110('0x4a')](_0x25f57c[_0xc110('0x4b')],qs[_0xc110('0x4c')](_0x124b9e[_0xc110('0x49')][_0xc110('0x4c')]));_0x621620[_0xc110('0x4d')]=_0x621620[_0xc110('0x4d')][_0xc110('0x4e')]?_0x621620['attributes']:_0x25f57c[_0xc110('0x4b')];_0x621620[_0xc110('0x51')]=qs[_0xc110('0x52')](_0x124b9e[_0xc110('0x49')][_0xc110('0x52')]);_0x621620['where']=qs['filters'](_[_0xc110('0x55')](_0x124b9e[_0xc110('0x49')],_0x25f57c['filters']));if(_0x124b9e[_0xc110('0x49')][_0xc110('0x56')]){_0x621620['where']=_[_0xc110('0x57')](_0x621620[_0xc110('0x53')],{'$or':_[_0xc110('0x48')](_0x621620[_0xc110('0x4d')],function(_0xe7e0d4){var _0x5eb3e0={};_0x5eb3e0[_0xe7e0d4]={'$like':'%'+_0x124b9e[_0xc110('0x49')]['filter']+'%'};return _0x5eb3e0;})});}_0x621620=_[_0xc110('0x57')]({},_0x621620,_0x124b9e[_0xc110('0x5f')]);return _0x36e627[_0xc110('0x74')](_0x621620);}})['then'](function(_0x376c5d){if(_0x376c5d){_0x114207=_0x376c5d[_0xc110('0x4e')];if(!_0x124b9e[_0xc110('0x49')]['hasOwnProperty'](_0xc110('0x50'))){_0x621620[_0xc110('0x36')]=qs[_0xc110('0x36')](_0x124b9e[_0xc110('0x49')][_0xc110('0x36')]);_0x621620['offset']=qs[_0xc110('0x34')](_0x124b9e[_0xc110('0x49')][_0xc110('0x34')]);}return _0x36e627[_0xc110('0x74')](_0x621620);}})[_0xc110('0x3c')](function(_0x4207d0){if(_0x4207d0){return _0x4207d0?{'count':_0x114207,'rows':_0x4207d0}:null;}})['then'](respondWithResult(_0x45d113,null))[_0xc110('0x2f')](handleError(_0x45d113,null));};exports[_0xc110('0x76')]=function(_0x527f34,_0x4bb25a,_0x4abca3){var _0x3b1768=_0x527f34[_0xc110('0x62')][_0xc110('0x77')];return db[_0xc110('0x75')][_0xc110('0x5a')]({'where':{'id':_0x3b1768},'attributes':['id'],'include':[{'model':db['User'],'as':_0xc110('0x78'),'attributes':['id',_0xc110('0x42'),_0xc110('0x79'),_0xc110('0x7a'),'interface'],'raw':!![]}]})[_0xc110('0x3c')](function(_0x30ad76){if(_0x30ad76){var _0x2fb026=_['flatMap'](_0x30ad76,function(_0x4bf1bf){var _0x3f834b=_0x4bf1bf[_0xc110('0x3e')]({'plain':!![]});return _0x3f834b[_0xc110('0x78')];});return db[_0xc110('0x45')][_0xc110('0x60')]({'where':{'id':_0x527f34[_0xc110('0x6a')]['id']}})['then'](function(_0x306507){return db[_0xc110('0x7b')][_0xc110('0x7c')](function(_0x931a6d){return _0x306507['addTeams'](_0x3b1768,{'transaction':_0x931a6d})[_0xc110('0x3c')](function(){return BPromise['each'](_0x2fb026,function(_0x57cfef){return db[_0xc110('0x7d')]['findOrCreate']({'where':{'UserId':_0x57cfef['id'],'ChatQueueId':_0x527f34['params']['id']},'transaction':_0x931a6d});});})[_0xc110('0x3c')](function(){_0x2fb026[_0xc110('0x7e')](function(_0x4a2a6a){socket['emit'](_0xc110('0x7f'),{'UserId':_0x4a2a6a['id'],'ChatQueueId':_0x306507['id']});});});});});}})[_0xc110('0x3c')](respondWithStatusCode(_0x4bb25a,null))[_0xc110('0x2f')](handleError(_0x4bb25a,null));};exports['removeTeams']=function(_0x153c96,_0x535413,_0x2d63e1){return db[_0xc110('0x75')][_0xc110('0x5a')]({'where':{'id':_0x153c96[_0xc110('0x49')][_0xc110('0x77')]},'attributes':['id'],'include':[{'model':db[_0xc110('0x6f')],'as':_0xc110('0x78'),'attributes':['id'],'raw':!![]}]})[_0xc110('0x3c')](handleEntityNotFound(_0x535413,null))[_0xc110('0x3c')](function(_0x3e7dc3){var _0x107e5e=_[_0xc110('0x48')](_0x3e7dc3,'id');var _0xadbd19=[];var _0x15bac3=[];var _0x821b1c=squel[_0xc110('0x80')]();_0x821b1c[_0xc110('0x81')](_0xc110('0x82'))['from'](_0xc110('0x83'),'tq')[_0xc110('0x84')](_0xc110('0x85'),'ut','ut.TeamId\x20=\x20tq.TeamId')[_0xc110('0x53')](_0xc110('0x86'),_0x153c96[_0xc110('0x6a')]['id']);for(var _0x1e09cd=0x0;_0x1e09cd<_0x3e7dc3['length'];_0x1e09cd+=0x1){let _0x2a5295=_0x3e7dc3[_0x1e09cd];for(var _0x2eb26d=0x0;_0x2eb26d<_0x2a5295[_0xc110('0x78')]['length'];_0x2eb26d+=0x1){let _0x24d8a6=_0x2a5295[_0xc110('0x78')][_0x2eb26d];var _0x460200=_0x821b1c['clone']();_0x460200[_0xc110('0x53')](_0xc110('0x87'),_0x24d8a6['id']);_0x15bac3['push'](db[_0xc110('0x7b')][_0xc110('0x49')](_0x460200['toString'](),{'type':db[_0xc110('0x7b')][_0xc110('0x88')]['SELECT']})[_0xc110('0x3c')](function(_0x152a54){if(_0x152a54[_0xc110('0x4e')]===0x1){return _0x24d8a6['id'];}else{var _0xce8f5e=_[_0xc110('0x89')](_[_0xc110('0x48')](_0x152a54,_0xc110('0x8a')),function(_0x5278ad){return _['includes'](_0x107e5e,_0x5278ad);});if(_0xce8f5e){return _0x24d8a6['id'];}}}));}}return BPromise[_0xc110('0x8b')](_0x15bac3)['then'](function(_0x34a16c){_0xadbd19=_(_0xadbd19)[_0xc110('0x8c')](_0x34a16c)[_0xc110('0x8d')]()[_0xc110('0x8e')]();return db[_0xc110('0x45')][_0xc110('0x60')]({'where':{'id':_0x153c96[_0xc110('0x6a')]['id']}})[_0xc110('0x3c')](function(_0x1c8654){return db['sequelize'][_0xc110('0x7c')](function(_0x182753){return _0x1c8654[_0xc110('0x8f')](_0x153c96[_0xc110('0x49')][_0xc110('0x77')],{'transaction':_0x182753})['then'](function(){if(!_['isEmpty'](_0xadbd19)){return _0x1c8654[_0xc110('0x90')](_0xadbd19,{'transaction':_0x182753});}})[_0xc110('0x3c')](function(){_0xadbd19[_0xc110('0x7e')](function(_0x4c3e31){socket['emit']('userChatQueue:remove',{'UserId':_0x4c3e31,'ChatQueueId':_0x1c8654['id']});});});});});});})[_0xc110('0x3c')](respondWithStatusCode(_0x535413,null))[_0xc110('0x2f')](handleError(_0x535413,null));};exports['addAgents']=function(_0x18de8f,_0xd49fd8,_0x5d319f){return db['ChatQueue'][_0xc110('0x60')]({'where':{'id':_0x18de8f[_0xc110('0x6a')]['id']}})['then'](handleEntityNotFound(_0xd49fd8,null))['then'](function(_0x4b952e){if(_0x4b952e){return _0x4b952e['addAgents'](_0x18de8f[_0xc110('0x62')][_0xc110('0x77')],_['omit'](_0x18de8f[_0xc110('0x62')],['ids','id'])||{})[_0xc110('0x91')](function(_0x8d2ecd){for(var _0x41e66d=0x0;_0x41e66d<_0x18de8f[_0xc110('0x62')][_0xc110('0x77')][_0xc110('0x4e')];_0x41e66d+=0x1){socket[_0xc110('0x92')](_0xc110('0x7f'),{'UserId':Number(_0x18de8f[_0xc110('0x62')][_0xc110('0x77')][_0x41e66d]),'ChatQueueId':Number(_0x18de8f['params']['id'])});}return _0x8d2ecd;});}})['then'](respondWithResult(_0xd49fd8,null))['catch'](handleError(_0xd49fd8,null));};exports[_0xc110('0x90')]=function(_0x586efa,_0x3b6c5a,_0x5baa44){return db[_0xc110('0x45')]['find']({'where':{'id':_0x586efa['params']['id']}})['then'](handleEntityNotFound(_0x3b6c5a,null))['then'](function(_0x5a02b4){if(_0x5a02b4){return _0x5a02b4[_0xc110('0x90')](_0x586efa[_0xc110('0x49')]['ids'])['then'](function(){if(_[_0xc110('0x93')](_0x586efa['query'][_0xc110('0x77')])){for(var _0x56e1c7=0x0;_0x56e1c7<_0x586efa[_0xc110('0x49')]['ids'][_0xc110('0x4e')];_0x56e1c7+=0x1){socket[_0xc110('0x92')](_0xc110('0x94'),{'UserId':Number(_0x586efa[_0xc110('0x49')][_0xc110('0x77')][_0x56e1c7]),'ChatQueueId':Number(_0x586efa['params']['id'])});}}else{socket[_0xc110('0x92')](_0xc110('0x94'),{'UserId':Number(_0x586efa['query'][_0xc110('0x77')]),'ChatQueueId':Number(_0x586efa[_0xc110('0x6a')]['id'])});}});}})[_0xc110('0x3c')](respondWithStatusCode(_0x3b6c5a,null))[_0xc110('0x2f')](handleError(_0x3b6c5a,null));};exports['getAgents']=function(_0x597497,_0x498029,_0x1786c9){var _0x429963={};var _0x3fa91c={};var _0x4db1ae;var _0x1c55d5;return db[_0xc110('0x45')][_0xc110('0x6d')]({'where':{'id':_0x597497['params']['id']}})['then'](handleEntityNotFound(_0x498029,null))[_0xc110('0x3c')](function(_0x3c1bd7){if(_0x3c1bd7){_0x4db1ae=_0x3c1bd7;_0x3fa91c[_0xc110('0x4b')]=_[_0xc110('0x5d')](db[_0xc110('0x6f')]['rawAttributes']);_0x3fa91c[_0xc110('0x49')]=_[_0xc110('0x5d')](_0x597497['query']);_0x3fa91c[_0xc110('0x54')]=_[_0xc110('0x4a')](_0x3fa91c[_0xc110('0x4b')],_0x3fa91c[_0xc110('0x49')]);_0x429963[_0xc110('0x4d')]=_[_0xc110('0x4a')](_0x3fa91c['model'],qs[_0xc110('0x4c')](_0x597497[_0xc110('0x49')]['fields']));_0x429963[_0xc110('0x4d')]=_0x429963[_0xc110('0x4d')][_0xc110('0x4e')]?_0x429963[_0xc110('0x4d')]:_0x3fa91c[_0xc110('0x4b')];_0x429963[_0xc110('0x51')]=qs['sort'](_0x597497[_0xc110('0x49')][_0xc110('0x52')]);_0x429963[_0xc110('0x53')]=qs[_0xc110('0x54')](_[_0xc110('0x55')](_0x597497['query'],_0x3fa91c['filters']));if(_0x597497[_0xc110('0x49')][_0xc110('0x56')]){_0x429963[_0xc110('0x53')]=_[_0xc110('0x57')](_0x429963[_0xc110('0x53')],{'$or':_[_0xc110('0x48')](_0x429963[_0xc110('0x4d')],function(_0x501d0e){var _0x465652={};_0x465652[_0x501d0e]={'$like':'%'+_0x597497[_0xc110('0x49')][_0xc110('0x56')]+'%'};return _0x465652;})});}_0x429963=_[_0xc110('0x57')]({},_0x429963,_0x597497[_0xc110('0x5f')]);return _0x4db1ae['getAgents'](_0x429963);}})['then'](function(_0x8e2904){if(_0x8e2904){_0x1c55d5=_0x8e2904[_0xc110('0x4e')];if(!_0x597497[_0xc110('0x49')][_0xc110('0x4f')](_0xc110('0x50'))){_0x429963[_0xc110('0x36')]=qs[_0xc110('0x36')](_0x597497[_0xc110('0x49')]['limit']);_0x429963['offset']=qs[_0xc110('0x34')](_0x597497[_0xc110('0x49')][_0xc110('0x34')]);}return _0x4db1ae[_0xc110('0x95')](_0x429963);}})[_0xc110('0x3c')](function(_0x397f1b){if(_0x397f1b){return _0x397f1b?{'count':_0x1c55d5,'rows':_0x397f1b}:null;}})['then'](respondWithResult(_0x498029,null))['catch'](handleError(_0x498029,null));};