Built motion from commit 616d3211.|2.6.4
[motion2.git] / server / api / mailQueue / mailQueue.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 _0x7914=['../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','redis','localhost','socket.io-emitter','./mailQueue.socket','register','sendStatus','end','status','offset','undefined','count','set','Content-Range','apply','save','update','then','destroy','get','MailQueues','UserProfileResource','error','stack','send','index','map','rawAttributes','type','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','limit','order','sort','where','pick','filter','merge','VIRTUAL','options','MailQueue','includeAll','findAll','rows','catch','params','create','body','user','role','UserProfileSection','find','userProfileId','autoAssociation','name','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','describe','getMembers','MailQueueId','User','findAndCountAll','UserId','updatedAt','format','%s/%s','SIP','createdAt','getTeams','findOne','Team','addTeams','ids','Agents','online','voicePause','interface','transaction','each','UserMailQueue','forEach','emit','userMailQueue:save','removeTeams','select','field','from','team_has_mail_queues','join','user_has_teams','ut.TeamId\x20=\x20tq.TeamId','MailQueueId\x20=\x20?','clone','sequelize','QueryTypes','SELECT','TeamId','includes','union','compact','value','isEmpty','removeAgents','userMailQueue:remove','addAgents','omit','spread','isArray','getAgents','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch'];(function(_0x2641f9,_0x26715f){var _0x585741=function(_0x2d1462){while(--_0x2d1462){_0x2641f9['push'](_0x2641f9['shift']());}};_0x585741(++_0x26715f);}(_0x7914,0x107));var _0x4791=function(_0x144dbe,_0x18d240){_0x144dbe=_0x144dbe-0x0;var _0x297668=_0x7914[_0x144dbe];return _0x297668;};'use strict';var emlformat=require(_0x4791('0x0'));var rimraf=require(_0x4791('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x4791('0x2'));var rp=require(_0x4791('0x3'));var moment=require(_0x4791('0x4'));var BPromise=require(_0x4791('0x5'));var Mustache=require(_0x4791('0x6'));var util=require(_0x4791('0x7'));var path=require(_0x4791('0x8'));var sox=require(_0x4791('0x9'));var csv=require(_0x4791('0xa'));var ejs=require(_0x4791('0xb'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x4791('0xc'));var squel=require('squel');var crypto=require(_0x4791('0xd'));var jsforce=require(_0x4791('0xe'));var deskjs=require(_0x4791('0xf'));var toCsv=require(_0x4791('0xa'));var querystring=require(_0x4791('0x10'));var Papa=require(_0x4791('0x11'));var Redis=require(_0x4791('0x12'));var authService=require(_0x4791('0x13'));var qs=require('../../components/parsers/qs');var as=require(_0x4791('0x14'));var hardwareService=require(_0x4791('0x15'));var logger=require(_0x4791('0x16'))(_0x4791('0x17'));var utils=require(_0x4791('0x18'));var config=require(_0x4791('0x19'));var licenseUtil=require('../../config/license/util');var db=require(_0x4791('0x1a'))['db'];config[_0x4791('0x1b')]=_['defaults'](config[_0x4791('0x1b')],{'host':_0x4791('0x1c'),'port':0x18eb});var socket=require(_0x4791('0x1d'))(new Redis(config[_0x4791('0x1b')]));require(_0x4791('0x1e'))[_0x4791('0x1f')](socket);function respondWithStatusCode(_0x1c6a2f,_0x57e0d4){_0x57e0d4=_0x57e0d4||0xcc;return function(_0x25a767){if(_0x25a767){return _0x1c6a2f[_0x4791('0x20')](_0x57e0d4);}return _0x1c6a2f['status'](_0x57e0d4)[_0x4791('0x21')]();};}function respondWithResult(_0x356615,_0x38ce4d){_0x38ce4d=_0x38ce4d||0xc8;return function(_0x202cca){if(_0x202cca){return _0x356615[_0x4791('0x22')](_0x38ce4d)['json'](_0x202cca);}};}function respondWithFilteredResult(_0x51e96b,_0x18d3d6){return function(_0x41d373){if(_0x41d373){var _0xce74a5=typeof _0x18d3d6[_0x4791('0x23')]===_0x4791('0x24')&&typeof _0x18d3d6['limit']===_0x4791('0x24');var _0x53363a=_0x41d373['count'];var _0x32a7eb=_0xce74a5?0x0:_0x18d3d6[_0x4791('0x23')];var _0x25286b=_0xce74a5?_0x41d373[_0x4791('0x25')]:_0x18d3d6[_0x4791('0x23')]+_0x18d3d6['limit'];var _0x35946a;if(_0x25286b>=_0x53363a){_0x25286b=_0x53363a;_0x35946a=0xc8;}else{_0x35946a=0xce;}_0x51e96b['status'](_0x35946a);return _0x51e96b[_0x4791('0x26')](_0x4791('0x27'),_0x32a7eb+'-'+_0x25286b+'/'+_0x53363a)['json'](_0x41d373);}return null;};}function patchUpdates(_0x936139){return function(_0x4063dc){try{jsonpatch[_0x4791('0x28')](_0x4063dc,_0x936139,!![]);}catch(_0x18ade6){return BPromise['reject'](_0x18ade6);}return _0x4063dc[_0x4791('0x29')]();};}function saveUpdates(_0x4b94c1,_0x1f94bb){return function(_0x564a43){if(_0x564a43){return _0x564a43[_0x4791('0x2a')](_0x4b94c1)[_0x4791('0x2b')](function(_0x5d1c0c){return _0x5d1c0c;});}return null;};}function removeEntity(_0x407789,_0x2e4234){return function(_0x16616d){if(_0x16616d){return _0x16616d[_0x4791('0x2c')]()[_0x4791('0x2b')](function(){var _0xcbfd8e=_0x16616d[_0x4791('0x2d')]({'plain':!![]});var _0x3dbfaa=_0x4791('0x2e');return db[_0x4791('0x2f')][_0x4791('0x2c')]({'where':{'type':_0x3dbfaa,'resourceId':_0xcbfd8e['id']}})[_0x4791('0x2b')](function(){return _0x16616d;});})[_0x4791('0x2b')](function(){_0x407789['status'](0xcc)[_0x4791('0x21')]();});}};}function handleEntityNotFound(_0x3f2d2e,_0x21dfc0){return function(_0x1dab4b){if(!_0x1dab4b){_0x3f2d2e[_0x4791('0x20')](0x194);}return _0x1dab4b;};}function handleError(_0x46db57,_0x4a101f){_0x4a101f=_0x4a101f||0x1f4;return function(_0x3f340f){logger[_0x4791('0x30')](_0x3f340f[_0x4791('0x31')]);if(_0x3f340f['name']){delete _0x3f340f['name'];}_0x46db57[_0x4791('0x22')](_0x4a101f)[_0x4791('0x32')](_0x3f340f);};}exports[_0x4791('0x33')]=function(_0x472d5b,_0x465149){var _0x827074={},_0x1b4a2d={},_0x2c73f6={'count':0x0,'rows':[]};var _0x2767a1=_[_0x4791('0x34')](db['MailQueue'][_0x4791('0x35')],function(_0x410f14){return{'name':_0x410f14['fieldName'],'type':_0x410f14[_0x4791('0x36')]['key']};});_0x1b4a2d[_0x4791('0x37')]=_[_0x4791('0x34')](_0x2767a1,'name');_0x1b4a2d[_0x4791('0x38')]=_[_0x4791('0x39')](_0x472d5b[_0x4791('0x38')]);_0x1b4a2d[_0x4791('0x3a')]=_[_0x4791('0x3b')](_0x1b4a2d[_0x4791('0x37')],_0x1b4a2d[_0x4791('0x38')]);_0x827074[_0x4791('0x3c')]=_[_0x4791('0x3b')](_0x1b4a2d['model'],qs['fields'](_0x472d5b['query'][_0x4791('0x3d')]));_0x827074[_0x4791('0x3c')]=_0x827074['attributes'][_0x4791('0x3e')]?_0x827074['attributes']:_0x1b4a2d[_0x4791('0x37')];if(!_0x472d5b[_0x4791('0x38')][_0x4791('0x3f')](_0x4791('0x40'))){_0x827074[_0x4791('0x41')]=qs[_0x4791('0x41')](_0x472d5b['query']['limit']);_0x827074[_0x4791('0x23')]=qs['offset'](_0x472d5b['query'][_0x4791('0x23')]);}_0x827074[_0x4791('0x42')]=qs[_0x4791('0x43')](_0x472d5b[_0x4791('0x38')][_0x4791('0x43')]);_0x827074[_0x4791('0x44')]=qs['filters'](_[_0x4791('0x45')](_0x472d5b[_0x4791('0x38')],_0x1b4a2d[_0x4791('0x3a')]),_0x2767a1);if(_0x472d5b['query'][_0x4791('0x46')]){_0x827074[_0x4791('0x44')]=_[_0x4791('0x47')](_0x827074[_0x4791('0x44')],{'$or':_[_0x4791('0x34')](_0x2767a1,function(_0x2617f6){if(_0x2617f6[_0x4791('0x36')]!==_0x4791('0x48')){var _0x136b22={};_0x136b22[_0x2617f6['name']]={'$like':'%'+_0x472d5b[_0x4791('0x38')][_0x4791('0x46')]+'%'};return _0x136b22;}})});}_0x827074=_[_0x4791('0x47')]({},_0x827074,_0x472d5b[_0x4791('0x49')]);var _0x2391ce={'where':_0x827074['where']};return db[_0x4791('0x4a')]['count'](_0x2391ce)[_0x4791('0x2b')](function(_0x5b6536){_0x2c73f6[_0x4791('0x25')]=_0x5b6536;if(_0x472d5b[_0x4791('0x38')][_0x4791('0x4b')]){_0x827074['include']=[{'all':!![]}];}return db['MailQueue'][_0x4791('0x4c')](_0x827074);})[_0x4791('0x2b')](function(_0x2e0e9f){_0x2c73f6[_0x4791('0x4d')]=_0x2e0e9f;return _0x2c73f6;})[_0x4791('0x2b')](respondWithFilteredResult(_0x465149,_0x827074))[_0x4791('0x4e')](handleError(_0x465149,null));};exports['show']=function(_0x46baa8,_0x2b0aae){var _0x3134a3={'raw':!![],'where':{'id':_0x46baa8[_0x4791('0x4f')]['id']}},_0x27ca85={};_0x27ca85[_0x4791('0x37')]=_[_0x4791('0x39')](db[_0x4791('0x4a')][_0x4791('0x35')]);_0x27ca85[_0x4791('0x38')]=_[_0x4791('0x39')](_0x46baa8[_0x4791('0x38')]);_0x27ca85[_0x4791('0x3a')]=_[_0x4791('0x3b')](_0x27ca85[_0x4791('0x37')],_0x27ca85[_0x4791('0x38')]);_0x3134a3[_0x4791('0x3c')]=_[_0x4791('0x3b')](_0x27ca85[_0x4791('0x37')],qs[_0x4791('0x3d')](_0x46baa8[_0x4791('0x38')][_0x4791('0x3d')]));_0x3134a3[_0x4791('0x3c')]=_0x3134a3[_0x4791('0x3c')][_0x4791('0x3e')]?_0x3134a3['attributes']:_0x27ca85[_0x4791('0x37')];if(_0x46baa8[_0x4791('0x38')][_0x4791('0x4b')]){_0x3134a3['include']=[{'all':!![]}];}_0x3134a3=_[_0x4791('0x47')]({},_0x3134a3,_0x46baa8[_0x4791('0x49')]);return db[_0x4791('0x4a')]['find'](_0x3134a3)[_0x4791('0x2b')](handleEntityNotFound(_0x2b0aae,null))[_0x4791('0x2b')](respondWithResult(_0x2b0aae,null))[_0x4791('0x4e')](handleError(_0x2b0aae,null));};exports[_0x4791('0x50')]=function(_0x2c0eff,_0x5ce98a){return db[_0x4791('0x4a')][_0x4791('0x50')](_0x2c0eff[_0x4791('0x51')],{})[_0x4791('0x2b')](function(_0x3ba02d){var _0x1e654e=_0x2c0eff[_0x4791('0x52')]['get']({'plain':!![]});if(!_0x1e654e)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x1e654e[_0x4791('0x53')]===_0x4791('0x52')){var _0x2fff0b=_0x3ba02d[_0x4791('0x2d')]({'plain':!![]});var _0x5b2684=_0x4791('0x2e');return db[_0x4791('0x54')][_0x4791('0x55')]({'where':{'name':_0x5b2684,'userProfileId':_0x1e654e[_0x4791('0x56')]},'raw':!![]})[_0x4791('0x2b')](function(_0x39caff){if(_0x39caff&&_0x39caff[_0x4791('0x57')]===0x0){return db[_0x4791('0x2f')]['create']({'name':_0x2fff0b[_0x4791('0x58')],'resourceId':_0x2fff0b['id'],'type':_0x39caff[_0x4791('0x58')],'sectionId':_0x39caff['id']},{})[_0x4791('0x2b')](function(){return _0x3ba02d;});}else{return _0x3ba02d;}})[_0x4791('0x4e')](function(_0x2450e3){logger[_0x4791('0x30')](_0x4791('0x59'),_0x2450e3);throw _0x2450e3;});}return _0x3ba02d;})[_0x4791('0x2b')](respondWithResult(_0x5ce98a,0xc9))[_0x4791('0x4e')](handleError(_0x5ce98a,null));};exports['update']=function(_0x3e5730,_0x3607a6){if(_0x3e5730[_0x4791('0x51')]['id']){delete _0x3e5730[_0x4791('0x51')]['id'];}return db[_0x4791('0x4a')][_0x4791('0x55')]({'where':{'id':_0x3e5730[_0x4791('0x4f')]['id']}})[_0x4791('0x2b')](handleEntityNotFound(_0x3607a6,null))[_0x4791('0x2b')](saveUpdates(_0x3e5730[_0x4791('0x51')],null))[_0x4791('0x2b')](respondWithResult(_0x3607a6,null))[_0x4791('0x4e')](handleError(_0x3607a6,null));};exports[_0x4791('0x2c')]=function(_0x2951a6,_0xcfda61){return db[_0x4791('0x4a')][_0x4791('0x55')]({'where':{'id':_0x2951a6[_0x4791('0x4f')]['id']}})[_0x4791('0x2b')](handleEntityNotFound(_0xcfda61,null))['then'](removeEntity(_0xcfda61,null))[_0x4791('0x4e')](handleError(_0xcfda61,null));};exports[_0x4791('0x5a')]=function(_0x55589a,_0x41f163){return db[_0x4791('0x4a')][_0x4791('0x5a')]()['then'](respondWithResult(_0x41f163,null))[_0x4791('0x4e')](handleError(_0x41f163,null));};exports[_0x4791('0x5b')]=function(_0x32097a,_0x3e4e3e,_0x1ac72b){var _0x2cda79={'raw':!![],'where':{}},_0x23ce05={},_0x515555;return db[_0x4791('0x4a')]['findOne']({'where':{'id':_0x32097a['params']['id']}})[_0x4791('0x2b')](handleEntityNotFound(_0x3e4e3e,null))[_0x4791('0x2b')](function(_0x3ce889){if(_0x3ce889){_0x515555=_0x3ce889[_0x4791('0x2d')]({'plain':!![]});_0x23ce05[_0x4791('0x37')]=_['keys'](db['UserMailQueue']['rawAttributes']);_0x23ce05[_0x4791('0x38')]=_[_0x4791('0x39')](_0x32097a[_0x4791('0x38')]);_0x23ce05[_0x4791('0x3a')]=_[_0x4791('0x3b')](_0x23ce05[_0x4791('0x37')],_0x23ce05[_0x4791('0x38')]);_0x2cda79[_0x4791('0x3c')]=_['intersection'](_0x23ce05[_0x4791('0x37')],qs['fields'](_0x32097a[_0x4791('0x38')][_0x4791('0x3d')]));_0x2cda79['attributes']=_0x2cda79['attributes'][_0x4791('0x3e')]?_0x2cda79[_0x4791('0x3c')]:_0x23ce05['model'];if(!_0x32097a[_0x4791('0x38')]['hasOwnProperty']('nolimit')){_0x2cda79['limit']=qs['limit'](_0x32097a[_0x4791('0x38')]['limit']);_0x2cda79[_0x4791('0x23')]=qs[_0x4791('0x23')](_0x32097a[_0x4791('0x38')][_0x4791('0x23')]);}_0x2cda79[_0x4791('0x42')]=qs[_0x4791('0x43')](_0x32097a[_0x4791('0x38')][_0x4791('0x43')]);_0x2cda79[_0x4791('0x44')]=qs['filters'](_[_0x4791('0x45')](_0x32097a['query'],_0x23ce05[_0x4791('0x3a')]));_0x2cda79[_0x4791('0x44')][_0x4791('0x5c')]=_0x3ce889['id'];if(_0x32097a[_0x4791('0x38')]['filter']){_0x2cda79['where']=_[_0x4791('0x47')](_0x2cda79[_0x4791('0x44')],{'$or':_[_0x4791('0x34')](_0x2cda79['attributes'],function(_0x34338b){var _0x156f60={};_0x156f60[_0x34338b]={'$like':'%'+_0x32097a[_0x4791('0x38')][_0x4791('0x46')]+'%'};return _0x156f60;})});}_0x2cda79=_[_0x4791('0x47')]({},_0x2cda79,_0x32097a[_0x4791('0x49')]);return db['UserMailQueue'][_0x4791('0x4c')](_0x2cda79);}})[_0x4791('0x2b')](function(_0x3523fd){if(_0x3523fd){return db[_0x4791('0x5d')][_0x4791('0x5e')]({'where':{'id':_[_0x4791('0x34')](_0x3523fd,_0x4791('0x5f')),'role':'agent'},'attributes':['id',_0x4791('0x58'),'mailPause',_0x4791('0x60'),'createdAt']});}})[_0x4791('0x2b')](function(_0x500ceb){if(_0x500ceb){return{'count':_0x500ceb['count'],'rows':_[_0x4791('0x34')](_0x500ceb[_0x4791('0x4d')],function(_0x5d3f7d){return{'membername':_0x5d3f7d[_0x4791('0x58')],'UserId':_0x5d3f7d['id'],'queue_name':_0x515555[_0x4791('0x58')],'MailQueueId':_0x515555['id'],'interface':util[_0x4791('0x61')](_0x4791('0x62'),_0x4791('0x63'),_0x5d3f7d['name']),'penalty':0x0,'paused':_0x5d3f7d['mailPause'],'createdAt':_0x5d3f7d[_0x4791('0x64')],'updatedAt':_0x5d3f7d[_0x4791('0x60')]};})};}else{return{'count':0x0,'rows':[]};}})['then'](respondWithFilteredResult(_0x3e4e3e,_0x2cda79))[_0x4791('0x4e')](handleError(_0x3e4e3e,null));};exports[_0x4791('0x65')]=function(_0x3931de,_0x1cf5ce,_0x385803){var _0x5d3350={};var _0x168d9e={};var _0x42a0cd;var _0x589778;return db[_0x4791('0x4a')][_0x4791('0x66')]({'where':{'id':_0x3931de['params']['id']}})[_0x4791('0x2b')](handleEntityNotFound(_0x1cf5ce,null))[_0x4791('0x2b')](function(_0xc2061b){if(_0xc2061b){_0x42a0cd=_0xc2061b;_0x168d9e[_0x4791('0x37')]=_[_0x4791('0x39')](db[_0x4791('0x67')][_0x4791('0x35')]);_0x168d9e[_0x4791('0x38')]=_[_0x4791('0x39')](_0x3931de[_0x4791('0x38')]);_0x168d9e[_0x4791('0x3a')]=_['intersection'](_0x168d9e[_0x4791('0x37')],_0x168d9e['query']);_0x5d3350['attributes']=_[_0x4791('0x3b')](_0x168d9e[_0x4791('0x37')],qs[_0x4791('0x3d')](_0x3931de[_0x4791('0x38')][_0x4791('0x3d')]));_0x5d3350[_0x4791('0x3c')]=_0x5d3350[_0x4791('0x3c')]['length']?_0x5d3350['attributes']:_0x168d9e[_0x4791('0x37')];_0x5d3350[_0x4791('0x42')]=qs[_0x4791('0x43')](_0x3931de['query'][_0x4791('0x43')]);_0x5d3350[_0x4791('0x44')]=qs[_0x4791('0x3a')](_['pick'](_0x3931de[_0x4791('0x38')],_0x168d9e['filters']));if(_0x3931de[_0x4791('0x38')][_0x4791('0x46')]){_0x5d3350[_0x4791('0x44')]=_['merge'](_0x5d3350[_0x4791('0x44')],{'$or':_[_0x4791('0x34')](_0x5d3350['attributes'],function(_0x346493){var _0x468a67={};_0x468a67[_0x346493]={'$like':'%'+_0x3931de['query'][_0x4791('0x46')]+'%'};return _0x468a67;})});}_0x5d3350=_['merge']({},_0x5d3350,_0x3931de[_0x4791('0x49')]);return _0x42a0cd[_0x4791('0x65')](_0x5d3350);}})[_0x4791('0x2b')](function(_0x1238e2){if(_0x1238e2){_0x589778=_0x1238e2['length'];if(!_0x3931de[_0x4791('0x38')][_0x4791('0x3f')](_0x4791('0x40'))){_0x5d3350[_0x4791('0x41')]=qs[_0x4791('0x41')](_0x3931de[_0x4791('0x38')][_0x4791('0x41')]);_0x5d3350[_0x4791('0x23')]=qs['offset'](_0x3931de['query'][_0x4791('0x23')]);}return _0x42a0cd[_0x4791('0x65')](_0x5d3350);}})[_0x4791('0x2b')](function(_0x1039c6){if(_0x1039c6){return _0x1039c6?{'count':_0x589778,'rows':_0x1039c6}:null;}})[_0x4791('0x2b')](respondWithResult(_0x1cf5ce,null))[_0x4791('0x4e')](handleError(_0x1cf5ce,null));};exports[_0x4791('0x68')]=function(_0x5137c4,_0xb2a20e,_0x56d259){var _0x539bed=_0x5137c4['body'][_0x4791('0x69')];return db['Team'][_0x4791('0x4c')]({'where':{'id':_0x539bed},'attributes':['id'],'include':[{'model':db[_0x4791('0x5d')],'as':_0x4791('0x6a'),'attributes':['id',_0x4791('0x58'),_0x4791('0x6b'),_0x4791('0x6c'),_0x4791('0x6d')],'raw':!![]}]})[_0x4791('0x2b')](function(_0xda9e28){if(_0xda9e28){var _0x36d31f=_['flatMap'](_0xda9e28,function(_0x29d29b){var _0x1302b3=_0x29d29b[_0x4791('0x2d')]({'plain':!![]});return _0x1302b3[_0x4791('0x6a')];});return db[_0x4791('0x4a')][_0x4791('0x55')]({'where':{'id':_0x5137c4[_0x4791('0x4f')]['id']}})['then'](function(_0x3c8dea){return db['sequelize'][_0x4791('0x6e')](function(_0x1ce835){return _0x3c8dea[_0x4791('0x68')](_0x539bed,{'transaction':_0x1ce835})[_0x4791('0x2b')](function(){return BPromise[_0x4791('0x6f')](_0x36d31f,function(_0xb73660){return db[_0x4791('0x70')]['findOrCreate']({'where':{'UserId':_0xb73660['id'],'MailQueueId':_0x5137c4[_0x4791('0x4f')]['id']},'transaction':_0x1ce835});});})[_0x4791('0x2b')](function(){_0x36d31f[_0x4791('0x71')](function(_0x14e456){socket[_0x4791('0x72')](_0x4791('0x73'),{'UserId':_0x14e456['id'],'MailQueueId':_0x3c8dea['id']});});});});});}})[_0x4791('0x2b')](respondWithStatusCode(_0xb2a20e,null))[_0x4791('0x4e')](handleError(_0xb2a20e,null));};exports[_0x4791('0x74')]=function(_0x51881c,_0x19afb6,_0x339244){return db[_0x4791('0x67')]['findAll']({'where':{'id':_0x51881c[_0x4791('0x38')]['ids']},'attributes':['id'],'include':[{'model':db['User'],'as':_0x4791('0x6a'),'attributes':['id'],'raw':!![]}]})[_0x4791('0x2b')](handleEntityNotFound(_0x19afb6,null))[_0x4791('0x2b')](function(_0x360e54){var _0x307c5f=_[_0x4791('0x34')](_0x360e54,'id');var _0x16d92b=[];var _0x36a0e0=[];var _0x2868a3=squel[_0x4791('0x75')]();_0x2868a3[_0x4791('0x76')]('tq.TeamId')[_0x4791('0x77')](_0x4791('0x78'),'tq')[_0x4791('0x79')](_0x4791('0x7a'),'ut',_0x4791('0x7b'))[_0x4791('0x44')](_0x4791('0x7c'),_0x51881c['params']['id']);for(var _0x4e4697=0x0;_0x4e4697<_0x360e54[_0x4791('0x3e')];_0x4e4697+=0x1){let _0x44ce84=_0x360e54[_0x4e4697];for(var _0x3ba8a7=0x0;_0x3ba8a7<_0x44ce84['Agents'][_0x4791('0x3e')];_0x3ba8a7+=0x1){let _0x509c23=_0x44ce84[_0x4791('0x6a')][_0x3ba8a7];var _0x4a781d=_0x2868a3[_0x4791('0x7d')]();_0x4a781d[_0x4791('0x44')]('ut.UserId\x20=\x20?',_0x509c23['id']);_0x36a0e0['push'](db[_0x4791('0x7e')]['query'](_0x4a781d['toString'](),{'type':db[_0x4791('0x7e')][_0x4791('0x7f')][_0x4791('0x80')]})[_0x4791('0x2b')](function(_0x532fde){if(_0x532fde[_0x4791('0x3e')]===0x1){return _0x509c23['id'];}else{var _0x10766d=_['every'](_[_0x4791('0x34')](_0x532fde,_0x4791('0x81')),function(_0x5944b7){return _[_0x4791('0x82')](_0x307c5f,_0x5944b7);});if(_0x10766d){return _0x509c23['id'];}}}));}}return BPromise['all'](_0x36a0e0)[_0x4791('0x2b')](function(_0x5d5484){_0x16d92b=_(_0x16d92b)[_0x4791('0x83')](_0x5d5484)[_0x4791('0x84')]()[_0x4791('0x85')]();return db[_0x4791('0x4a')][_0x4791('0x55')]({'where':{'id':_0x51881c[_0x4791('0x4f')]['id']}})['then'](function(_0x1cca72){return db[_0x4791('0x7e')][_0x4791('0x6e')](function(_0x3729cd){return _0x1cca72['removeTeams'](_0x51881c[_0x4791('0x38')][_0x4791('0x69')],{'transaction':_0x3729cd})[_0x4791('0x2b')](function(){if(!_[_0x4791('0x86')](_0x16d92b)){return _0x1cca72[_0x4791('0x87')](_0x16d92b,{'transaction':_0x3729cd});}})[_0x4791('0x2b')](function(){_0x16d92b['forEach'](function(_0x1ac66b){socket[_0x4791('0x72')](_0x4791('0x88'),{'UserId':_0x1ac66b,'MailQueueId':_0x1cca72['id']});});});});});});})['then'](respondWithStatusCode(_0x19afb6,null))[_0x4791('0x4e')](handleError(_0x19afb6,null));};exports[_0x4791('0x89')]=function(_0x210aff,_0x30514b,_0x203adc){return db[_0x4791('0x4a')][_0x4791('0x55')]({'where':{'id':_0x210aff[_0x4791('0x4f')]['id']}})[_0x4791('0x2b')](handleEntityNotFound(_0x30514b,null))[_0x4791('0x2b')](function(_0x160476){if(_0x160476){return _0x160476['addAgents'](_0x210aff['body'][_0x4791('0x69')],_[_0x4791('0x8a')](_0x210aff[_0x4791('0x51')],[_0x4791('0x69'),'id'])||{})[_0x4791('0x8b')](function(_0x4cb248){for(var _0x2d7025=0x0;_0x2d7025<_0x210aff[_0x4791('0x51')]['ids']['length'];_0x2d7025+=0x1){socket[_0x4791('0x72')](_0x4791('0x73'),{'UserId':Number(_0x210aff[_0x4791('0x51')][_0x4791('0x69')][_0x2d7025]),'MailQueueId':Number(_0x210aff[_0x4791('0x4f')]['id'])});}return _0x4cb248;});}})['then'](respondWithResult(_0x30514b,null))[_0x4791('0x4e')](handleError(_0x30514b,null));};exports[_0x4791('0x87')]=function(_0x1b9ef5,_0x49c7ea,_0x2164e9){return db[_0x4791('0x4a')][_0x4791('0x55')]({'where':{'id':_0x1b9ef5[_0x4791('0x4f')]['id']}})[_0x4791('0x2b')](handleEntityNotFound(_0x49c7ea,null))[_0x4791('0x2b')](function(_0x3587f3){if(_0x3587f3){return _0x3587f3[_0x4791('0x87')](_0x1b9ef5[_0x4791('0x38')]['ids'])[_0x4791('0x2b')](function(){if(_[_0x4791('0x8c')](_0x1b9ef5[_0x4791('0x38')][_0x4791('0x69')])){for(var _0x6e205=0x0;_0x6e205<_0x1b9ef5[_0x4791('0x38')][_0x4791('0x69')][_0x4791('0x3e')];_0x6e205+=0x1){socket[_0x4791('0x72')]('userMailQueue:remove',{'UserId':Number(_0x1b9ef5['query'][_0x4791('0x69')][_0x6e205]),'MailQueueId':Number(_0x1b9ef5[_0x4791('0x4f')]['id'])});}}else{socket[_0x4791('0x72')]('userMailQueue:remove',{'UserId':Number(_0x1b9ef5[_0x4791('0x38')][_0x4791('0x69')]),'MailQueueId':Number(_0x1b9ef5[_0x4791('0x4f')]['id'])});}});}})[_0x4791('0x2b')](respondWithStatusCode(_0x49c7ea,null))[_0x4791('0x4e')](handleError(_0x49c7ea,null));};exports[_0x4791('0x8d')]=function(_0x3dc7ec,_0x5a4df2,_0x152e17){var _0x297cd5={};var _0x56d980={};var _0x32fe3f;var _0x136af2;return db[_0x4791('0x4a')][_0x4791('0x66')]({'where':{'id':_0x3dc7ec[_0x4791('0x4f')]['id']}})[_0x4791('0x2b')](handleEntityNotFound(_0x5a4df2,null))[_0x4791('0x2b')](function(_0x26e7ba){if(_0x26e7ba){_0x32fe3f=_0x26e7ba;_0x56d980[_0x4791('0x37')]=_[_0x4791('0x39')](db[_0x4791('0x5d')]['rawAttributes']);_0x56d980[_0x4791('0x38')]=_['keys'](_0x3dc7ec[_0x4791('0x38')]);_0x56d980['filters']=_[_0x4791('0x3b')](_0x56d980[_0x4791('0x37')],_0x56d980['query']);_0x297cd5[_0x4791('0x3c')]=_[_0x4791('0x3b')](_0x56d980['model'],qs[_0x4791('0x3d')](_0x3dc7ec[_0x4791('0x38')]['fields']));_0x297cd5[_0x4791('0x3c')]=_0x297cd5[_0x4791('0x3c')][_0x4791('0x3e')]?_0x297cd5[_0x4791('0x3c')]:_0x56d980['model'];_0x297cd5[_0x4791('0x42')]=qs[_0x4791('0x43')](_0x3dc7ec['query'][_0x4791('0x43')]);_0x297cd5['where']=qs[_0x4791('0x3a')](_[_0x4791('0x45')](_0x3dc7ec[_0x4791('0x38')],_0x56d980['filters']));if(_0x3dc7ec[_0x4791('0x38')][_0x4791('0x46')]){_0x297cd5['where']=_[_0x4791('0x47')](_0x297cd5[_0x4791('0x44')],{'$or':_[_0x4791('0x34')](_0x297cd5['attributes'],function(_0x2587fd){var _0x86d104={};_0x86d104[_0x2587fd]={'$like':'%'+_0x3dc7ec[_0x4791('0x38')]['filter']+'%'};return _0x86d104;})});}_0x297cd5=_[_0x4791('0x47')]({},_0x297cd5,_0x3dc7ec[_0x4791('0x49')]);return _0x32fe3f[_0x4791('0x8d')](_0x297cd5);}})[_0x4791('0x2b')](function(_0x5347c3){if(_0x5347c3){_0x136af2=_0x5347c3[_0x4791('0x3e')];if(!_0x3dc7ec['query'][_0x4791('0x3f')](_0x4791('0x40'))){_0x297cd5['limit']=qs[_0x4791('0x41')](_0x3dc7ec['query']['limit']);_0x297cd5[_0x4791('0x23')]=qs[_0x4791('0x23')](_0x3dc7ec[_0x4791('0x38')][_0x4791('0x23')]);}return _0x32fe3f[_0x4791('0x8d')](_0x297cd5);}})[_0x4791('0x2b')](function(_0x402117){if(_0x402117){return _0x402117?{'count':_0x136af2,'rows':_0x402117}:null;}})['then'](respondWithResult(_0x5a4df2,null))[_0x4791('0x4e')](handleError(_0x5a4df2,null));};