Built motion from commit (unavailable).|2.4.3
[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 _0x7ac4=['request-promise','moment','bluebird','util','path','sox','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','defaults','redis','socket.io-emitter','register','status','end','json','count','offset','limit','set','Content-Range','reject','save','then','destroy','get','MailQueues','UserProfileResource','sendStatus','stack','name','send','index','MailQueue','query','keys','filters','intersection','model','attributes','length','order','sort','pick','filter','merge','where','map','type','key','VIRTUAL','options','includeAll','include','findAll','rows','catch','show','params','rawAttributes','fields','find','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','UserProfileSection','autoAssociation','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','update','describe','getMembers','findOne','UserMailQueue','nolimit','MailQueueId','User','findAndCountAll','UserId','agent','mailPause','updatedAt','createdAt','%s/%s','SIP','Team','getTeams','hasOwnProperty','addTeams','teams','Agents','online','voicePause','interface','sequelize','transaction','each','findOrCreate','forEach','emit','userMailQueue:save','removeTeams','ids','select','field','tq.TeamId','from','team_has_mail_queues','join','user_has_teams','ut.TeamId\x20=\x20tq.TeamId','MailQueueId\x20=\x20?','clone','ut.UserId\x20=\x20?','push','QueryTypes','SELECT','every','includes','all','value','removeAgents','userMailQueue:remove','addAgents','omit','spread','isArray','getAgents','eml-format','fast-json-patch'];(function(_0x43b7e2,_0x205983){var _0x4004c9=function(_0x5c6233){while(--_0x5c6233){_0x43b7e2['push'](_0x43b7e2['shift']());}};_0x4004c9(++_0x205983);}(_0x7ac4,0x8d));var _0x47ac=function(_0x1fe5ee,_0x292522){_0x1fe5ee=_0x1fe5ee-0x0;var _0x3585b2=_0x7ac4[_0x1fe5ee];return _0x3585b2;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x47ac('0x0'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0x47ac('0x1'));var rp=require(_0x47ac('0x2'));var moment=require(_0x47ac('0x3'));var BPromise=require(_0x47ac('0x4'));var Mustache=require('mustache');var util=require(_0x47ac('0x5'));var path=require(_0x47ac('0x6'));var sox=require(_0x47ac('0x7'));var csv=require(_0x47ac('0x8'));var ejs=require(_0x47ac('0x9'));var fs=require('fs');var _=require(_0x47ac('0xa'));var squel=require(_0x47ac('0xb'));var crypto=require(_0x47ac('0xc'));var jsforce=require(_0x47ac('0xd'));var deskjs=require(_0x47ac('0xe'));var toCsv=require(_0x47ac('0x8'));var querystring=require(_0x47ac('0xf'));var Papa=require(_0x47ac('0x10'));var Redis=require('ioredis');var authService=require(_0x47ac('0x11'));var qs=require(_0x47ac('0x12'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x47ac('0x13'))(_0x47ac('0x14'));var utils=require(_0x47ac('0x15'));var config=require(_0x47ac('0x16'));var db=require(_0x47ac('0x17'))['db'];config['redis']=_[_0x47ac('0x18')](config[_0x47ac('0x19')],{'host':'localhost','port':0x18eb});var socket=require(_0x47ac('0x1a'))(new Redis(config['redis']));require('./mailQueue.socket')[_0x47ac('0x1b')](socket);function respondWithStatusCode(_0x52cf45,_0x490952){_0x490952=_0x490952||0xcc;return function(_0x57da2b){if(_0x57da2b){return _0x52cf45['sendStatus'](_0x490952);}return _0x52cf45[_0x47ac('0x1c')](_0x490952)[_0x47ac('0x1d')]();};}function respondWithResult(_0x2f7bad,_0x3b7764){_0x3b7764=_0x3b7764||0xc8;return function(_0x450d2e){if(_0x450d2e){return _0x2f7bad[_0x47ac('0x1c')](_0x3b7764)[_0x47ac('0x1e')](_0x450d2e);}};}function respondWithFilteredResult(_0x26a0f4,_0x5e9c40){return function(_0x5d888d){if(_0x5d888d){var _0x4e1920=_0x5d888d[_0x47ac('0x1f')],_0x1705a2=_0x5e9c40[_0x47ac('0x20')],_0x3259b5=_0x5e9c40[_0x47ac('0x20')]+_0x5e9c40[_0x47ac('0x21')],_0x5cb188;if(_0x3259b5>=_0x4e1920){_0x3259b5=_0x4e1920;_0x5cb188=0xc8;}else{_0x5cb188=0xce;}_0x26a0f4[_0x47ac('0x1c')](_0x5cb188);return _0x26a0f4[_0x47ac('0x22')](_0x47ac('0x23'),_0x1705a2+'-'+_0x3259b5+'/'+_0x4e1920)[_0x47ac('0x1e')](_0x5d888d);}return null;};}function patchUpdates(_0xaf910){return function(_0x737358){try{jsonpatch['apply'](_0x737358,_0xaf910,!![]);}catch(_0xc0a7e4){return BPromise[_0x47ac('0x24')](_0xc0a7e4);}return _0x737358[_0x47ac('0x25')]();};}function saveUpdates(_0x584eb3,_0x467115){return function(_0xcdb5f5){if(_0xcdb5f5){return _0xcdb5f5['update'](_0x584eb3)[_0x47ac('0x26')](function(_0x18a04f){return _0x18a04f;});}return null;};}function removeEntity(_0x5e1fda,_0x554fdd){return function(_0x4c5431){if(_0x4c5431){return _0x4c5431[_0x47ac('0x27')]()[_0x47ac('0x26')](function(){var _0x21daeb=_0x4c5431[_0x47ac('0x28')]({'plain':!![]});var _0x4bfe7c=_0x47ac('0x29');return db[_0x47ac('0x2a')]['destroy']({'where':{'type':_0x4bfe7c,'resourceId':_0x21daeb['id']}})[_0x47ac('0x26')](function(){return _0x4c5431;});})[_0x47ac('0x26')](function(){_0x5e1fda[_0x47ac('0x1c')](0xcc)[_0x47ac('0x1d')]();});}};}function handleEntityNotFound(_0x52218a,_0x48616d){return function(_0x3a3a47){if(!_0x3a3a47){_0x52218a[_0x47ac('0x2b')](0x194);}return _0x3a3a47;};}function handleError(_0x794431,_0x1dd7ed){_0x1dd7ed=_0x1dd7ed||0x1f4;return function(_0x589f4a){logger['error'](_0x589f4a[_0x47ac('0x2c')]);if(_0x589f4a[_0x47ac('0x2d')]){delete _0x589f4a['name'];}_0x794431[_0x47ac('0x1c')](_0x1dd7ed)[_0x47ac('0x2e')](_0x589f4a);};}exports[_0x47ac('0x2f')]=function(_0x34898b,_0x5783e8){var _0x523a3e={},_0x279b57={},_0x14ae7e={'count':0x0,'rows':[]};var _0x1c6682=db[_0x47ac('0x30')]['rawAttributes'];_0x279b57['model']=_['keys'](_0x1c6682);_0x279b57[_0x47ac('0x31')]=_[_0x47ac('0x32')](_0x34898b[_0x47ac('0x31')]);_0x279b57[_0x47ac('0x33')]=_[_0x47ac('0x34')](_0x279b57[_0x47ac('0x35')],_0x279b57[_0x47ac('0x31')]);_0x523a3e['attributes']=_['intersection'](_0x279b57[_0x47ac('0x35')],qs['fields'](_0x34898b[_0x47ac('0x31')]['fields']));_0x523a3e[_0x47ac('0x36')]=_0x523a3e[_0x47ac('0x36')][_0x47ac('0x37')]?_0x523a3e[_0x47ac('0x36')]:_0x279b57[_0x47ac('0x35')];if(!_0x34898b[_0x47ac('0x31')]['hasOwnProperty']('nolimit')){_0x523a3e['limit']=qs[_0x47ac('0x21')](_0x34898b[_0x47ac('0x31')][_0x47ac('0x21')]);_0x523a3e[_0x47ac('0x20')]=qs[_0x47ac('0x20')](_0x34898b[_0x47ac('0x31')]['offset']);}_0x523a3e[_0x47ac('0x38')]=qs[_0x47ac('0x39')](_0x34898b[_0x47ac('0x31')]['sort']);_0x523a3e['where']=qs[_0x47ac('0x33')](_[_0x47ac('0x3a')](_0x34898b['query'],_0x279b57[_0x47ac('0x33')]));if(_0x34898b[_0x47ac('0x31')][_0x47ac('0x3b')]){_0x523a3e['where']=_[_0x47ac('0x3c')](_0x523a3e[_0x47ac('0x3d')],{'$or':_[_0x47ac('0x3e')](_0x1c6682,function(_0x157a62){if(_0x157a62[_0x47ac('0x3f')][_0x47ac('0x40')]!==_0x47ac('0x41')){var _0x3f9b73={};_0x3f9b73[_0x157a62['field']]={'$like':'%'+_0x34898b[_0x47ac('0x31')][_0x47ac('0x3b')]+'%'};return _0x3f9b73;}})});}_0x523a3e=_[_0x47ac('0x3c')]({},_0x523a3e,_0x34898b[_0x47ac('0x42')]);var _0x335679={'where':_0x523a3e[_0x47ac('0x3d')]};return db[_0x47ac('0x30')]['count'](_0x335679)[_0x47ac('0x26')](function(_0x29d96d){_0x14ae7e[_0x47ac('0x1f')]=_0x29d96d;if(_0x34898b['query'][_0x47ac('0x43')]){_0x523a3e[_0x47ac('0x44')]=[{'all':!![]}];}return db[_0x47ac('0x30')][_0x47ac('0x45')](_0x523a3e);})[_0x47ac('0x26')](function(_0x263296){_0x14ae7e[_0x47ac('0x46')]=_0x263296;return _0x14ae7e;})[_0x47ac('0x26')](respondWithFilteredResult(_0x5783e8,_0x523a3e))[_0x47ac('0x47')](handleError(_0x5783e8,null));};exports[_0x47ac('0x48')]=function(_0x14fb0b,_0x45d627){var _0x30eec3={'raw':!![],'where':{'id':_0x14fb0b[_0x47ac('0x49')]['id']}},_0x54bfef={};_0x54bfef[_0x47ac('0x35')]=_[_0x47ac('0x32')](db['MailQueue'][_0x47ac('0x4a')]);_0x54bfef[_0x47ac('0x31')]=_[_0x47ac('0x32')](_0x14fb0b[_0x47ac('0x31')]);_0x54bfef[_0x47ac('0x33')]=_['intersection'](_0x54bfef[_0x47ac('0x35')],_0x54bfef['query']);_0x30eec3[_0x47ac('0x36')]=_[_0x47ac('0x34')](_0x54bfef[_0x47ac('0x35')],qs[_0x47ac('0x4b')](_0x14fb0b[_0x47ac('0x31')]['fields']));_0x30eec3[_0x47ac('0x36')]=_0x30eec3[_0x47ac('0x36')]['length']?_0x30eec3[_0x47ac('0x36')]:_0x54bfef[_0x47ac('0x35')];if(_0x14fb0b[_0x47ac('0x31')][_0x47ac('0x43')]){_0x30eec3[_0x47ac('0x44')]=[{'all':!![]}];}_0x30eec3=_['merge']({},_0x30eec3,_0x14fb0b['options']);return db[_0x47ac('0x30')][_0x47ac('0x4c')](_0x30eec3)[_0x47ac('0x26')](handleEntityNotFound(_0x45d627,null))['then'](respondWithResult(_0x45d627,null))[_0x47ac('0x47')](handleError(_0x45d627,null));};exports['create']=function(_0x43a364,_0x3cbef5){return db['MailQueue']['create'](_0x43a364[_0x47ac('0x4d')],{})[_0x47ac('0x26')](function(_0x1fd4b7){var _0x4df8f7=_0x43a364[_0x47ac('0x4e')][_0x47ac('0x28')]({'plain':!![]});if(!_0x4df8f7)throw new Error(_0x47ac('0x4f'));if(_0x4df8f7['role']==='user'){var _0x2d3a11=_0x1fd4b7[_0x47ac('0x28')]({'plain':!![]});var _0x33f397=_0x47ac('0x29');return db[_0x47ac('0x50')][_0x47ac('0x4c')]({'where':{'name':_0x33f397,'userProfileId':_0x4df8f7['userProfileId']},'raw':!![]})['then'](function(_0x2217f1){if(_0x2217f1&&_0x2217f1[_0x47ac('0x51')]===0x0){return db[_0x47ac('0x2a')]['create']({'name':_0x2d3a11['name'],'resourceId':_0x2d3a11['id'],'type':_0x2217f1[_0x47ac('0x2d')],'sectionId':_0x2217f1['id']},{})[_0x47ac('0x26')](function(){return _0x1fd4b7;});}else{return _0x1fd4b7;}})[_0x47ac('0x47')](function(_0x48d316){logger[_0x47ac('0x52')](_0x47ac('0x53'),_0x48d316);throw _0x48d316;});}return _0x1fd4b7;})['then'](respondWithResult(_0x3cbef5,0xc9))[_0x47ac('0x47')](handleError(_0x3cbef5,null));};exports[_0x47ac('0x54')]=function(_0x19da87,_0x497b2d){if(_0x19da87[_0x47ac('0x4d')]['id']){delete _0x19da87[_0x47ac('0x4d')]['id'];}return db[_0x47ac('0x30')][_0x47ac('0x4c')]({'where':{'id':_0x19da87[_0x47ac('0x49')]['id']}})['then'](handleEntityNotFound(_0x497b2d,null))['then'](saveUpdates(_0x19da87['body'],null))['then'](respondWithResult(_0x497b2d,null))[_0x47ac('0x47')](handleError(_0x497b2d,null));};exports[_0x47ac('0x27')]=function(_0x1ca00c,_0x1ea4e8){return db[_0x47ac('0x30')][_0x47ac('0x4c')]({'where':{'id':_0x1ca00c[_0x47ac('0x49')]['id']}})[_0x47ac('0x26')](handleEntityNotFound(_0x1ea4e8,null))['then'](removeEntity(_0x1ea4e8,null))[_0x47ac('0x47')](handleError(_0x1ea4e8,null));};exports['describe']=function(_0xa8d064,_0x3c702f){return db[_0x47ac('0x30')][_0x47ac('0x55')]()[_0x47ac('0x26')](respondWithResult(_0x3c702f,null))[_0x47ac('0x47')](handleError(_0x3c702f,null));};exports[_0x47ac('0x56')]=function(_0xba2332,_0x44a351,_0x39cfd3){var _0x5f3b9c={'raw':!![],'where':{}},_0x50c026={},_0x527791;return db['MailQueue'][_0x47ac('0x57')]({'where':{'id':_0xba2332[_0x47ac('0x49')]['id']}})['then'](handleEntityNotFound(_0x44a351,null))[_0x47ac('0x26')](function(_0x18cd5d){if(_0x18cd5d){_0x527791=_0x18cd5d['get']({'plain':!![]});_0x50c026[_0x47ac('0x35')]=_[_0x47ac('0x32')](db[_0x47ac('0x58')][_0x47ac('0x4a')]);_0x50c026['query']=_[_0x47ac('0x32')](_0xba2332['query']);_0x50c026['filters']=_[_0x47ac('0x34')](_0x50c026[_0x47ac('0x35')],_0x50c026[_0x47ac('0x31')]);_0x5f3b9c[_0x47ac('0x36')]=_[_0x47ac('0x34')](_0x50c026[_0x47ac('0x35')],qs[_0x47ac('0x4b')](_0xba2332[_0x47ac('0x31')][_0x47ac('0x4b')]));_0x5f3b9c[_0x47ac('0x36')]=_0x5f3b9c[_0x47ac('0x36')][_0x47ac('0x37')]?_0x5f3b9c[_0x47ac('0x36')]:_0x50c026[_0x47ac('0x35')];if(!_0xba2332[_0x47ac('0x31')]['hasOwnProperty'](_0x47ac('0x59'))){_0x5f3b9c[_0x47ac('0x21')]=qs['limit'](_0xba2332['query']['limit']);_0x5f3b9c[_0x47ac('0x20')]=qs['offset'](_0xba2332[_0x47ac('0x31')][_0x47ac('0x20')]);}_0x5f3b9c[_0x47ac('0x38')]=qs[_0x47ac('0x39')](_0xba2332[_0x47ac('0x31')][_0x47ac('0x39')]);_0x5f3b9c[_0x47ac('0x3d')]=qs[_0x47ac('0x33')](_['pick'](_0xba2332[_0x47ac('0x31')],_0x50c026[_0x47ac('0x33')]));_0x5f3b9c[_0x47ac('0x3d')][_0x47ac('0x5a')]=_0x18cd5d['id'];if(_0xba2332[_0x47ac('0x31')][_0x47ac('0x3b')]){_0x5f3b9c[_0x47ac('0x3d')]=_['merge'](_0x5f3b9c[_0x47ac('0x3d')],{'$or':_[_0x47ac('0x3e')](_0x5f3b9c[_0x47ac('0x36')],function(_0x1617ec){var _0x39c45b={};_0x39c45b[_0x1617ec]={'$like':'%'+_0xba2332[_0x47ac('0x31')][_0x47ac('0x3b')]+'%'};return _0x39c45b;})});}_0x5f3b9c=_[_0x47ac('0x3c')]({},_0x5f3b9c,_0xba2332['options']);return db[_0x47ac('0x58')]['findAll'](_0x5f3b9c);}})[_0x47ac('0x26')](function(_0x57260b){if(_0x57260b){return db[_0x47ac('0x5b')][_0x47ac('0x5c')]({'where':{'id':_['map'](_0x57260b,_0x47ac('0x5d')),'role':_0x47ac('0x5e')},'attributes':['id','name',_0x47ac('0x5f'),_0x47ac('0x60'),_0x47ac('0x61')]});}})[_0x47ac('0x26')](function(_0x3f0324){if(_0x3f0324){return{'count':_0x3f0324[_0x47ac('0x1f')],'rows':_['map'](_0x3f0324[_0x47ac('0x46')],function(_0xaa848a){return{'membername':_0xaa848a[_0x47ac('0x2d')],'UserId':_0xaa848a['id'],'queue_name':_0x527791[_0x47ac('0x2d')],'MailQueueId':_0x527791['id'],'interface':util['format'](_0x47ac('0x62'),_0x47ac('0x63'),_0xaa848a['name']),'penalty':0x0,'paused':_0xaa848a[_0x47ac('0x5f')],'createdAt':_0xaa848a[_0x47ac('0x61')],'updatedAt':_0xaa848a[_0x47ac('0x60')]};})};}else{return{'count':0x0,'rows':[]};}})[_0x47ac('0x26')](respondWithFilteredResult(_0x44a351,_0x5f3b9c))[_0x47ac('0x47')](handleError(_0x44a351,null));};exports['getTeams']=function(_0x11fa60,_0x10788b,_0x21580b){var _0x4a91f7={};var _0x5078b4={};var _0x2b0554;var _0x14dd4d;return db[_0x47ac('0x30')][_0x47ac('0x57')]({'where':{'id':_0x11fa60[_0x47ac('0x49')]['id']}})[_0x47ac('0x26')](handleEntityNotFound(_0x10788b,null))[_0x47ac('0x26')](function(_0x5c8458){if(_0x5c8458){_0x2b0554=_0x5c8458;_0x5078b4[_0x47ac('0x35')]=_['keys'](db[_0x47ac('0x64')][_0x47ac('0x4a')]);_0x5078b4[_0x47ac('0x31')]=_[_0x47ac('0x32')](_0x11fa60[_0x47ac('0x31')]);_0x5078b4[_0x47ac('0x33')]=_[_0x47ac('0x34')](_0x5078b4[_0x47ac('0x35')],_0x5078b4[_0x47ac('0x31')]);_0x4a91f7[_0x47ac('0x36')]=_[_0x47ac('0x34')](_0x5078b4[_0x47ac('0x35')],qs[_0x47ac('0x4b')](_0x11fa60[_0x47ac('0x31')][_0x47ac('0x4b')]));_0x4a91f7['attributes']=_0x4a91f7[_0x47ac('0x36')]['length']?_0x4a91f7[_0x47ac('0x36')]:_0x5078b4['model'];_0x4a91f7[_0x47ac('0x38')]=qs[_0x47ac('0x39')](_0x11fa60['query'][_0x47ac('0x39')]);_0x4a91f7[_0x47ac('0x3d')]=qs[_0x47ac('0x33')](_[_0x47ac('0x3a')](_0x11fa60[_0x47ac('0x31')],_0x5078b4[_0x47ac('0x33')]));if(_0x11fa60[_0x47ac('0x31')][_0x47ac('0x3b')]){_0x4a91f7[_0x47ac('0x3d')]=_[_0x47ac('0x3c')](_0x4a91f7[_0x47ac('0x3d')],{'$or':_[_0x47ac('0x3e')](_0x4a91f7[_0x47ac('0x36')],function(_0x368375){var _0x1611d7={};_0x1611d7[_0x368375]={'$like':'%'+_0x11fa60[_0x47ac('0x31')][_0x47ac('0x3b')]+'%'};return _0x1611d7;})});}_0x4a91f7=_[_0x47ac('0x3c')]({},_0x4a91f7,_0x11fa60[_0x47ac('0x42')]);return _0x2b0554[_0x47ac('0x65')](_0x4a91f7);}})[_0x47ac('0x26')](function(_0x474ead){if(_0x474ead){_0x14dd4d=_0x474ead[_0x47ac('0x37')];if(!_0x11fa60[_0x47ac('0x31')][_0x47ac('0x66')](_0x47ac('0x59'))){_0x4a91f7[_0x47ac('0x21')]=qs[_0x47ac('0x21')](_0x11fa60[_0x47ac('0x31')][_0x47ac('0x21')]);_0x4a91f7[_0x47ac('0x20')]=qs[_0x47ac('0x20')](_0x11fa60['query'][_0x47ac('0x20')]);}return _0x2b0554[_0x47ac('0x65')](_0x4a91f7);}})[_0x47ac('0x26')](function(_0x102208){if(_0x102208){return _0x102208?{'count':_0x14dd4d,'rows':_0x102208}:null;}})[_0x47ac('0x26')](respondWithResult(_0x10788b,null))['catch'](handleError(_0x10788b,null));};exports[_0x47ac('0x67')]=function(_0x31d3ac,_0x5d10bb,_0xa48812){var _0x532e52=_0x31d3ac[_0x47ac('0x4d')][_0x47ac('0x68')];return db[_0x47ac('0x64')][_0x47ac('0x45')]({'where':{'id':_[_0x47ac('0x3e')](_0x532e52,'id')},'attributes':['id'],'include':[{'model':db[_0x47ac('0x5b')],'as':_0x47ac('0x69'),'attributes':['id',_0x47ac('0x2d'),_0x47ac('0x6a'),_0x47ac('0x6b'),_0x47ac('0x6c')],'raw':!![]}]})['then'](function(_0x550989){if(_0x550989){var _0x4c659e=_['flatMap'](_0x550989,function(_0x43de18){var _0x2f4aa1=_0x43de18[_0x47ac('0x28')]({'plain':!![]});return _0x2f4aa1['Agents'];});return db[_0x47ac('0x30')]['find']({'where':{'id':_0x31d3ac[_0x47ac('0x49')]['id']}})['then'](function(_0x51afd2){return db[_0x47ac('0x6d')][_0x47ac('0x6e')](function(_0x608f01){return _0x51afd2[_0x47ac('0x67')](_[_0x47ac('0x3e')](_0x532e52,'id'),{'transaction':_0x608f01})[_0x47ac('0x26')](function(){return BPromise[_0x47ac('0x6f')](_0x4c659e,function(_0x599496){return db['UserMailQueue'][_0x47ac('0x70')]({'where':{'UserId':_0x599496['id'],'MailQueueId':_0x31d3ac['params']['id']},'transaction':_0x608f01});});})[_0x47ac('0x26')](function(){_0x4c659e[_0x47ac('0x71')](function(_0xdbeb1c){socket[_0x47ac('0x72')](_0x47ac('0x73'),{'UserId':_0xdbeb1c['id'],'MailQueueId':_0x51afd2['id']});});});});});}})[_0x47ac('0x26')](respondWithStatusCode(_0x5d10bb,null))[_0x47ac('0x47')](handleError(_0x5d10bb,null));};exports[_0x47ac('0x74')]=function(_0x477227,_0x31aaab,_0x32b12d){return db[_0x47ac('0x64')][_0x47ac('0x45')]({'where':{'id':_0x477227['query'][_0x47ac('0x75')]},'attributes':['id'],'include':[{'model':db[_0x47ac('0x5b')],'as':_0x47ac('0x69'),'attributes':['id'],'raw':!![]}]})[_0x47ac('0x26')](handleEntityNotFound(_0x31aaab,null))[_0x47ac('0x26')](function(_0x5c7e13){var _0x1810d8=_[_0x47ac('0x3e')](_0x5c7e13,'id');var _0x13ff0b=[];var _0x3ebf44=[];var _0x420262=squel[_0x47ac('0x76')]();_0x420262[_0x47ac('0x77')](_0x47ac('0x78'))[_0x47ac('0x79')](_0x47ac('0x7a'),'tq')[_0x47ac('0x7b')](_0x47ac('0x7c'),'ut',_0x47ac('0x7d'))[_0x47ac('0x3d')](_0x47ac('0x7e'),_0x477227['params']['id']);for(var _0x1a56f2=0x0;_0x1a56f2<_0x5c7e13[_0x47ac('0x37')];_0x1a56f2+=0x1){let _0x32f44b=_0x5c7e13[_0x1a56f2];for(var _0x28fda6=0x0;_0x28fda6<_0x32f44b[_0x47ac('0x69')]['length'];_0x28fda6+=0x1){let _0x1e155f=_0x32f44b[_0x47ac('0x69')][_0x28fda6];var _0x40e4da=_0x420262[_0x47ac('0x7f')]();_0x40e4da['where'](_0x47ac('0x80'),_0x1e155f['id']);_0x3ebf44[_0x47ac('0x81')](db[_0x47ac('0x6d')][_0x47ac('0x31')](_0x40e4da['toString'](),{'type':db[_0x47ac('0x6d')][_0x47ac('0x82')][_0x47ac('0x83')]})[_0x47ac('0x26')](function(_0x483946){if(_0x483946['length']===0x1){return _0x1e155f['id'];}else{var _0x2eca72=_[_0x47ac('0x84')](_[_0x47ac('0x3e')](_0x483946,'TeamId'),function(_0x113e09){return _[_0x47ac('0x85')](_0x1810d8,_0x113e09);});if(_0x2eca72){return _0x1e155f['id'];}}}));}}return BPromise[_0x47ac('0x86')](_0x3ebf44)[_0x47ac('0x26')](function(_0x20374a){_0x13ff0b=_(_0x13ff0b)['union'](_0x20374a)['compact']()[_0x47ac('0x87')]();return db[_0x47ac('0x30')][_0x47ac('0x4c')]({'where':{'id':_0x477227[_0x47ac('0x49')]['id']}})['then'](function(_0x3a593d){return db[_0x47ac('0x6d')][_0x47ac('0x6e')](function(_0x3fc93f){return _0x3a593d['removeTeams'](_0x477227[_0x47ac('0x31')]['ids'],{'transaction':_0x3fc93f})[_0x47ac('0x26')](function(){if(!_['isEmpty'](_0x13ff0b)){return _0x3a593d[_0x47ac('0x88')](_0x13ff0b,{'transaction':_0x3fc93f});}})['then'](function(){_0x13ff0b[_0x47ac('0x71')](function(_0x1f579a){socket[_0x47ac('0x72')](_0x47ac('0x89'),{'UserId':_0x1f579a,'MailQueueId':_0x3a593d['id']});});});});});});})[_0x47ac('0x26')](respondWithStatusCode(_0x31aaab,null))[_0x47ac('0x47')](handleError(_0x31aaab,null));};exports['addAgents']=function(_0x17e53c,_0x44e751,_0x55b2ce){return db[_0x47ac('0x30')][_0x47ac('0x4c')]({'where':{'id':_0x17e53c[_0x47ac('0x49')]['id']}})[_0x47ac('0x26')](handleEntityNotFound(_0x44e751,null))[_0x47ac('0x26')](function(_0x5e3695){if(_0x5e3695){return _0x5e3695[_0x47ac('0x8a')](_0x17e53c['body'][_0x47ac('0x75')],_[_0x47ac('0x8b')](_0x17e53c[_0x47ac('0x4d')],[_0x47ac('0x75'),'id'])||{})[_0x47ac('0x8c')](function(_0x401e18){for(var _0x1b7e19=0x0;_0x1b7e19<_0x17e53c[_0x47ac('0x4d')][_0x47ac('0x75')][_0x47ac('0x37')];_0x1b7e19+=0x1){socket[_0x47ac('0x72')](_0x47ac('0x73'),{'UserId':_0x17e53c[_0x47ac('0x4d')][_0x47ac('0x75')][_0x1b7e19],'MailQueueId':_0x17e53c[_0x47ac('0x49')]['id']});}return _0x401e18;});}})[_0x47ac('0x26')](respondWithResult(_0x44e751,null))[_0x47ac('0x47')](handleError(_0x44e751,null));};exports[_0x47ac('0x88')]=function(_0x497540,_0x58d11e,_0x49352d){return db['MailQueue']['find']({'where':{'id':_0x497540[_0x47ac('0x49')]['id']}})[_0x47ac('0x26')](handleEntityNotFound(_0x58d11e,null))[_0x47ac('0x26')](function(_0x4ff725){if(_0x4ff725){return _0x4ff725[_0x47ac('0x88')](_0x497540[_0x47ac('0x31')][_0x47ac('0x75')])[_0x47ac('0x26')](function(){if(_[_0x47ac('0x8d')](_0x497540[_0x47ac('0x31')][_0x47ac('0x75')])){for(var _0x2abb10=0x0;_0x2abb10<_0x497540[_0x47ac('0x31')][_0x47ac('0x75')]['length'];_0x2abb10+=0x1){socket[_0x47ac('0x72')](_0x47ac('0x89'),{'UserId':Number(_0x497540[_0x47ac('0x31')][_0x47ac('0x75')][_0x2abb10]),'MailQueueId':Number(_0x497540[_0x47ac('0x49')]['id'])});}}else{socket['emit'](_0x47ac('0x89'),{'UserId':Number(_0x497540[_0x47ac('0x31')][_0x47ac('0x75')]),'MailQueueId':Number(_0x497540['params']['id'])});}});}})['then'](respondWithStatusCode(_0x58d11e,null))[_0x47ac('0x47')](handleError(_0x58d11e,null));};exports[_0x47ac('0x8e')]=function(_0x1c6553,_0x441f6c,_0x206897){var _0x43f664={};var _0x1f7c79={};var _0x33b9c8;var _0x20ae1d;return db[_0x47ac('0x30')][_0x47ac('0x57')]({'where':{'id':_0x1c6553[_0x47ac('0x49')]['id']}})[_0x47ac('0x26')](handleEntityNotFound(_0x441f6c,null))['then'](function(_0x42088e){if(_0x42088e){_0x33b9c8=_0x42088e;_0x1f7c79[_0x47ac('0x35')]=_[_0x47ac('0x32')](db[_0x47ac('0x5b')][_0x47ac('0x4a')]);_0x1f7c79['query']=_[_0x47ac('0x32')](_0x1c6553['query']);_0x1f7c79[_0x47ac('0x33')]=_[_0x47ac('0x34')](_0x1f7c79['model'],_0x1f7c79[_0x47ac('0x31')]);_0x43f664['attributes']=_[_0x47ac('0x34')](_0x1f7c79[_0x47ac('0x35')],qs[_0x47ac('0x4b')](_0x1c6553['query'][_0x47ac('0x4b')]));_0x43f664[_0x47ac('0x36')]=_0x43f664[_0x47ac('0x36')][_0x47ac('0x37')]?_0x43f664[_0x47ac('0x36')]:_0x1f7c79[_0x47ac('0x35')];_0x43f664[_0x47ac('0x38')]=qs[_0x47ac('0x39')](_0x1c6553['query'][_0x47ac('0x39')]);_0x43f664[_0x47ac('0x3d')]=qs[_0x47ac('0x33')](_[_0x47ac('0x3a')](_0x1c6553[_0x47ac('0x31')],_0x1f7c79[_0x47ac('0x33')]));if(_0x1c6553['query'][_0x47ac('0x3b')]){_0x43f664[_0x47ac('0x3d')]=_['merge'](_0x43f664[_0x47ac('0x3d')],{'$or':_[_0x47ac('0x3e')](_0x43f664[_0x47ac('0x36')],function(_0x5cc717){var _0x1a62ba={};_0x1a62ba[_0x5cc717]={'$like':'%'+_0x1c6553[_0x47ac('0x31')][_0x47ac('0x3b')]+'%'};return _0x1a62ba;})});}_0x43f664=_[_0x47ac('0x3c')]({},_0x43f664,_0x1c6553['options']);return _0x33b9c8[_0x47ac('0x8e')](_0x43f664);}})['then'](function(_0x1fba7d){if(_0x1fba7d){_0x20ae1d=_0x1fba7d['length'];if(!_0x1c6553['query']['hasOwnProperty'](_0x47ac('0x59'))){_0x43f664['limit']=qs['limit'](_0x1c6553[_0x47ac('0x31')][_0x47ac('0x21')]);_0x43f664[_0x47ac('0x20')]=qs[_0x47ac('0x20')](_0x1c6553[_0x47ac('0x31')][_0x47ac('0x20')]);}return _0x33b9c8[_0x47ac('0x8e')](_0x43f664);}})[_0x47ac('0x26')](function(_0x19338f){if(_0x19338f){return _0x19338f?{'count':_0x20ae1d,'rows':_0x19338f}:null;}})['then'](respondWithResult(_0x441f6c,null))[_0x47ac('0x47')](handleError(_0x441f6c,null));};