Built motion from commit (unavailable).|2.5.30
[motion2.git] / server / api / smsQueue / smsQueue.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 _0xe4b0=['isEmpty','removeAgents','userSmsQueue:remove','addAgents','spread','isArray','getAgents','eml-format','zip-dir','fast-json-patch','moment','mustache','util','to-csv','ejs','fs-extra','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','redis','defaults','socket.io-emitter','./smsQueue.socket','register','sendStatus','status','undefined','count','limit','Content-Range','json','apply','reject','save','update','then','get','SmsQueues','destroy','end','index','map','SmsQueue','fieldName','type','key','model','name','query','keys','filters','intersection','attributes','fields','hasOwnProperty','nolimit','offset','sort','where','pick','filter','merge','VIRTUAL','options','includeAll','findAll','rows','show','params','rawAttributes','length','include','catch','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','autoAssociation','UserProfileResource','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','find','describe','getMembers','findOne','UserSmsQueue','order','SmsQueueId','User','findAndCountAll','UserId','agent','createdAt','format','%s/%s','SIP','smsPause','getTeams','Team','ids','Agents','online','voicePause','interface','flatMap','addTeams','each','findOrCreate','forEach','emit','userSmsQueue:save','field','team_has_sms_queues','join','ut.TeamId\x20=\x20tq.TeamId','SmsQueueId\x20=\x20?','clone','push','sequelize','toString','QueryTypes','every','TeamId','includes','all','compact','value','transaction','removeTeams'];(function(_0x5e89e0,_0x539d02){var _0x335ba6=function(_0x17d734){while(--_0x17d734){_0x5e89e0['push'](_0x5e89e0['shift']());}};_0x335ba6(++_0x539d02);}(_0xe4b0,0x129));var _0x0e4b=function(_0x9e48c3,_0x226549){_0x9e48c3=_0x9e48c3-0x0;var _0x7fa7b2=_0xe4b0[_0x9e48c3];return _0x7fa7b2;};'use strict';var emlformat=require(_0x0e4b('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x0e4b('0x1'));var jsonpatch=require(_0x0e4b('0x2'));var rp=require('request-promise');var moment=require(_0x0e4b('0x3'));var BPromise=require('bluebird');var Mustache=require(_0x0e4b('0x4'));var util=require(_0x0e4b('0x5'));var path=require('path');var sox=require('sox');var csv=require(_0x0e4b('0x6'));var ejs=require(_0x0e4b('0x7'));var fs=require('fs');var fs_extra=require(_0x0e4b('0x8'));var _=require('lodash');var squel=require(_0x0e4b('0x9'));var crypto=require(_0x0e4b('0xa'));var jsforce=require(_0x0e4b('0xb'));var deskjs=require(_0x0e4b('0xc'));var toCsv=require(_0x0e4b('0x6'));var querystring=require(_0x0e4b('0xd'));var Papa=require(_0x0e4b('0xe'));var Redis=require(_0x0e4b('0xf'));var authService=require(_0x0e4b('0x10'));var qs=require(_0x0e4b('0x11'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x0e4b('0x12'));var logger=require(_0x0e4b('0x13'))(_0x0e4b('0x14'));var utils=require(_0x0e4b('0x15'));var config=require(_0x0e4b('0x16'));var licenseUtil=require(_0x0e4b('0x17'));var db=require(_0x0e4b('0x18'))['db'];config[_0x0e4b('0x19')]=_[_0x0e4b('0x1a')](config[_0x0e4b('0x19')],{'host':'localhost','port':0x18eb});var socket=require(_0x0e4b('0x1b'))(new Redis(config['redis']));require(_0x0e4b('0x1c'))[_0x0e4b('0x1d')](socket);function respondWithStatusCode(_0x446e3e,_0x13b4ed){_0x13b4ed=_0x13b4ed||0xcc;return function(_0x574baa){if(_0x574baa){return _0x446e3e[_0x0e4b('0x1e')](_0x13b4ed);}return _0x446e3e[_0x0e4b('0x1f')](_0x13b4ed)['end']();};}function respondWithResult(_0x5302f5,_0xde11e9){_0xde11e9=_0xde11e9||0xc8;return function(_0x24fe17){if(_0x24fe17){return _0x5302f5[_0x0e4b('0x1f')](_0xde11e9)['json'](_0x24fe17);}};}function respondWithFilteredResult(_0x494983,_0x3141db){return function(_0x5066c4){if(_0x5066c4){var _0xebb60b=typeof _0x3141db['offset']===_0x0e4b('0x20')&&typeof _0x3141db['limit']===_0x0e4b('0x20');var _0x56cc06=_0x5066c4[_0x0e4b('0x21')];var _0x2e5550=_0xebb60b?0x0:_0x3141db['offset'];var _0x43410f=_0xebb60b?_0x5066c4[_0x0e4b('0x21')]:_0x3141db['offset']+_0x3141db[_0x0e4b('0x22')];var _0x3fd9b0;if(_0x43410f>=_0x56cc06){_0x43410f=_0x56cc06;_0x3fd9b0=0xc8;}else{_0x3fd9b0=0xce;}_0x494983[_0x0e4b('0x1f')](_0x3fd9b0);return _0x494983['set'](_0x0e4b('0x23'),_0x2e5550+'-'+_0x43410f+'/'+_0x56cc06)[_0x0e4b('0x24')](_0x5066c4);}return null;};}function patchUpdates(_0x82a831){return function(_0x17a30e){try{jsonpatch[_0x0e4b('0x25')](_0x17a30e,_0x82a831,!![]);}catch(_0x2fa5ad){return BPromise[_0x0e4b('0x26')](_0x2fa5ad);}return _0x17a30e[_0x0e4b('0x27')]();};}function saveUpdates(_0x53da1b,_0x52e421){return function(_0x17bd06){if(_0x17bd06){return _0x17bd06[_0x0e4b('0x28')](_0x53da1b)[_0x0e4b('0x29')](function(_0x444912){return _0x444912;});}return null;};}function removeEntity(_0x37d5fb,_0x59dc94){return function(_0x4e2bc3){if(_0x4e2bc3){return _0x4e2bc3['destroy']()[_0x0e4b('0x29')](function(){var _0x3a9f35=_0x4e2bc3[_0x0e4b('0x2a')]({'plain':!![]});var _0x1e1c56=_0x0e4b('0x2b');return db['UserProfileResource'][_0x0e4b('0x2c')]({'where':{'type':_0x1e1c56,'resourceId':_0x3a9f35['id']}})[_0x0e4b('0x29')](function(){return _0x4e2bc3;});})[_0x0e4b('0x29')](function(){_0x37d5fb[_0x0e4b('0x1f')](0xcc)[_0x0e4b('0x2d')]();});}};}function handleEntityNotFound(_0x10dbf5,_0x11a2a0){return function(_0x561296){if(!_0x561296){_0x10dbf5[_0x0e4b('0x1e')](0x194);}return _0x561296;};}function handleError(_0x4bace9,_0x2aa84c){_0x2aa84c=_0x2aa84c||0x1f4;return function(_0xaaa479){logger['error'](_0xaaa479['stack']);if(_0xaaa479['name']){delete _0xaaa479['name'];}_0x4bace9['status'](_0x2aa84c)['send'](_0xaaa479);};}exports[_0x0e4b('0x2e')]=function(_0x831825,_0x191087){var _0x394322={},_0x4edd31={},_0x17aa4a={'count':0x0,'rows':[]};var _0x9d952f=_[_0x0e4b('0x2f')](db[_0x0e4b('0x30')]['rawAttributes'],function(_0x23b93a){return{'name':_0x23b93a[_0x0e4b('0x31')],'type':_0x23b93a[_0x0e4b('0x32')][_0x0e4b('0x33')]};});_0x4edd31[_0x0e4b('0x34')]=_[_0x0e4b('0x2f')](_0x9d952f,_0x0e4b('0x35'));_0x4edd31[_0x0e4b('0x36')]=_[_0x0e4b('0x37')](_0x831825[_0x0e4b('0x36')]);_0x4edd31[_0x0e4b('0x38')]=_[_0x0e4b('0x39')](_0x4edd31[_0x0e4b('0x34')],_0x4edd31[_0x0e4b('0x36')]);_0x394322[_0x0e4b('0x3a')]=_[_0x0e4b('0x39')](_0x4edd31[_0x0e4b('0x34')],qs[_0x0e4b('0x3b')](_0x831825[_0x0e4b('0x36')][_0x0e4b('0x3b')]));_0x394322[_0x0e4b('0x3a')]=_0x394322[_0x0e4b('0x3a')]['length']?_0x394322[_0x0e4b('0x3a')]:_0x4edd31['model'];if(!_0x831825[_0x0e4b('0x36')][_0x0e4b('0x3c')](_0x0e4b('0x3d'))){_0x394322[_0x0e4b('0x22')]=qs[_0x0e4b('0x22')](_0x831825['query'][_0x0e4b('0x22')]);_0x394322[_0x0e4b('0x3e')]=qs[_0x0e4b('0x3e')](_0x831825['query'][_0x0e4b('0x3e')]);}_0x394322['order']=qs[_0x0e4b('0x3f')](_0x831825[_0x0e4b('0x36')][_0x0e4b('0x3f')]);_0x394322[_0x0e4b('0x40')]=qs[_0x0e4b('0x38')](_[_0x0e4b('0x41')](_0x831825['query'],_0x4edd31[_0x0e4b('0x38')]),_0x9d952f);if(_0x831825['query'][_0x0e4b('0x42')]){_0x394322[_0x0e4b('0x40')]=_[_0x0e4b('0x43')](_0x394322[_0x0e4b('0x40')],{'$or':_['map'](_0x9d952f,function(_0x294e3d){if(_0x294e3d[_0x0e4b('0x32')]!==_0x0e4b('0x44')){var _0x23f7a4={};_0x23f7a4[_0x294e3d[_0x0e4b('0x35')]]={'$like':'%'+_0x831825[_0x0e4b('0x36')][_0x0e4b('0x42')]+'%'};return _0x23f7a4;}})});}_0x394322=_[_0x0e4b('0x43')]({},_0x394322,_0x831825[_0x0e4b('0x45')]);var _0x315006={'where':_0x394322[_0x0e4b('0x40')]};return db['SmsQueue'][_0x0e4b('0x21')](_0x315006)[_0x0e4b('0x29')](function(_0x31fd68){_0x17aa4a['count']=_0x31fd68;if(_0x831825[_0x0e4b('0x36')][_0x0e4b('0x46')]){_0x394322['include']=[{'all':!![]}];}return db['SmsQueue'][_0x0e4b('0x47')](_0x394322);})[_0x0e4b('0x29')](function(_0x879f09){_0x17aa4a[_0x0e4b('0x48')]=_0x879f09;return _0x17aa4a;})[_0x0e4b('0x29')](respondWithFilteredResult(_0x191087,_0x394322))['catch'](handleError(_0x191087,null));};exports[_0x0e4b('0x49')]=function(_0x22b1f7,_0x4838e7){var _0xd49f6d={'raw':!![],'where':{'id':_0x22b1f7[_0x0e4b('0x4a')]['id']}},_0x999ac6={};_0x999ac6[_0x0e4b('0x34')]=_[_0x0e4b('0x37')](db['SmsQueue'][_0x0e4b('0x4b')]);_0x999ac6[_0x0e4b('0x36')]=_[_0x0e4b('0x37')](_0x22b1f7[_0x0e4b('0x36')]);_0x999ac6['filters']=_[_0x0e4b('0x39')](_0x999ac6[_0x0e4b('0x34')],_0x999ac6[_0x0e4b('0x36')]);_0xd49f6d['attributes']=_[_0x0e4b('0x39')](_0x999ac6[_0x0e4b('0x34')],qs[_0x0e4b('0x3b')](_0x22b1f7[_0x0e4b('0x36')][_0x0e4b('0x3b')]));_0xd49f6d['attributes']=_0xd49f6d[_0x0e4b('0x3a')][_0x0e4b('0x4c')]?_0xd49f6d['attributes']:_0x999ac6['model'];if(_0x22b1f7[_0x0e4b('0x36')][_0x0e4b('0x46')]){_0xd49f6d[_0x0e4b('0x4d')]=[{'all':!![]}];}_0xd49f6d=_['merge']({},_0xd49f6d,_0x22b1f7[_0x0e4b('0x45')]);return db[_0x0e4b('0x30')]['find'](_0xd49f6d)['then'](handleEntityNotFound(_0x4838e7,null))[_0x0e4b('0x29')](respondWithResult(_0x4838e7,null))[_0x0e4b('0x4e')](handleError(_0x4838e7,null));};exports[_0x0e4b('0x4f')]=function(_0x574042,_0xf09416){return db['SmsQueue'][_0x0e4b('0x4f')](_0x574042[_0x0e4b('0x50')],{})[_0x0e4b('0x29')](function(_0x814120){var _0x4b7158=_0x574042[_0x0e4b('0x51')][_0x0e4b('0x2a')]({'plain':!![]});if(!_0x4b7158)throw new Error(_0x0e4b('0x52'));if(_0x4b7158[_0x0e4b('0x53')]===_0x0e4b('0x51')){var _0x107173=_0x814120[_0x0e4b('0x2a')]({'plain':!![]});var _0x2dd09b=_0x0e4b('0x2b');return db[_0x0e4b('0x54')]['find']({'where':{'name':_0x2dd09b,'userProfileId':_0x4b7158[_0x0e4b('0x55')]},'raw':!![]})[_0x0e4b('0x29')](function(_0x33de15){if(_0x33de15&&_0x33de15[_0x0e4b('0x56')]===0x0){return db[_0x0e4b('0x57')]['create']({'name':_0x107173['name'],'resourceId':_0x107173['id'],'type':_0x33de15[_0x0e4b('0x35')],'sectionId':_0x33de15['id']},{})[_0x0e4b('0x29')](function(){return _0x814120;});}else{return _0x814120;}})[_0x0e4b('0x4e')](function(_0x540d51){logger[_0x0e4b('0x58')](_0x0e4b('0x59'),_0x540d51);throw _0x540d51;});}return _0x814120;})[_0x0e4b('0x29')](respondWithResult(_0xf09416,0xc9))[_0x0e4b('0x4e')](handleError(_0xf09416,null));};exports[_0x0e4b('0x28')]=function(_0x1ff0f7,_0x498851){if(_0x1ff0f7[_0x0e4b('0x50')]['id']){delete _0x1ff0f7[_0x0e4b('0x50')]['id'];}return db[_0x0e4b('0x30')][_0x0e4b('0x5a')]({'where':{'id':_0x1ff0f7[_0x0e4b('0x4a')]['id']}})[_0x0e4b('0x29')](handleEntityNotFound(_0x498851,null))['then'](saveUpdates(_0x1ff0f7['body'],null))[_0x0e4b('0x29')](respondWithResult(_0x498851,null))['catch'](handleError(_0x498851,null));};exports[_0x0e4b('0x2c')]=function(_0x43ac06,_0x1fce09){return db[_0x0e4b('0x30')]['find']({'where':{'id':_0x43ac06[_0x0e4b('0x4a')]['id']}})['then'](handleEntityNotFound(_0x1fce09,null))[_0x0e4b('0x29')](removeEntity(_0x1fce09,null))[_0x0e4b('0x4e')](handleError(_0x1fce09,null));};exports[_0x0e4b('0x5b')]=function(_0x4f6f8c,_0x21fd96){return db[_0x0e4b('0x30')][_0x0e4b('0x5b')]()[_0x0e4b('0x29')](respondWithResult(_0x21fd96,null))[_0x0e4b('0x4e')](handleError(_0x21fd96,null));};exports[_0x0e4b('0x5c')]=function(_0x96adf0,_0x3645e1,_0x55ad23){var _0x2fe287={'raw':!![],'where':{}},_0x3021b5={},_0x1c839d;return db[_0x0e4b('0x30')][_0x0e4b('0x5d')]({'where':{'id':_0x96adf0[_0x0e4b('0x4a')]['id']}})[_0x0e4b('0x29')](handleEntityNotFound(_0x3645e1,null))[_0x0e4b('0x29')](function(_0x360da7){if(_0x360da7){_0x1c839d=_0x360da7[_0x0e4b('0x2a')]({'plain':!![]});_0x3021b5[_0x0e4b('0x34')]=_[_0x0e4b('0x37')](db[_0x0e4b('0x5e')][_0x0e4b('0x4b')]);_0x3021b5[_0x0e4b('0x36')]=_[_0x0e4b('0x37')](_0x96adf0['query']);_0x3021b5[_0x0e4b('0x38')]=_['intersection'](_0x3021b5[_0x0e4b('0x34')],_0x3021b5[_0x0e4b('0x36')]);_0x2fe287[_0x0e4b('0x3a')]=_[_0x0e4b('0x39')](_0x3021b5['model'],qs[_0x0e4b('0x3b')](_0x96adf0['query'][_0x0e4b('0x3b')]));_0x2fe287[_0x0e4b('0x3a')]=_0x2fe287[_0x0e4b('0x3a')][_0x0e4b('0x4c')]?_0x2fe287[_0x0e4b('0x3a')]:_0x3021b5['model'];if(!_0x96adf0[_0x0e4b('0x36')][_0x0e4b('0x3c')](_0x0e4b('0x3d'))){_0x2fe287['limit']=qs['limit'](_0x96adf0[_0x0e4b('0x36')][_0x0e4b('0x22')]);_0x2fe287[_0x0e4b('0x3e')]=qs[_0x0e4b('0x3e')](_0x96adf0[_0x0e4b('0x36')]['offset']);}_0x2fe287[_0x0e4b('0x5f')]=qs['sort'](_0x96adf0[_0x0e4b('0x36')]['sort']);_0x2fe287[_0x0e4b('0x40')]=qs[_0x0e4b('0x38')](_[_0x0e4b('0x41')](_0x96adf0['query'],_0x3021b5[_0x0e4b('0x38')]));_0x2fe287[_0x0e4b('0x40')][_0x0e4b('0x60')]=_0x360da7['id'];if(_0x96adf0['query'][_0x0e4b('0x42')]){_0x2fe287['where']=_[_0x0e4b('0x43')](_0x2fe287['where'],{'$or':_[_0x0e4b('0x2f')](_0x2fe287[_0x0e4b('0x3a')],function(_0x473237){var _0x5c4511={};_0x5c4511[_0x473237]={'$like':'%'+_0x96adf0[_0x0e4b('0x36')][_0x0e4b('0x42')]+'%'};return _0x5c4511;})});}_0x2fe287=_[_0x0e4b('0x43')]({},_0x2fe287,_0x96adf0[_0x0e4b('0x45')]);return db[_0x0e4b('0x5e')]['findAll'](_0x2fe287);}})['then'](function(_0x1f082d){if(_0x1f082d){return db[_0x0e4b('0x61')][_0x0e4b('0x62')]({'where':{'id':_[_0x0e4b('0x2f')](_0x1f082d,_0x0e4b('0x63')),'role':_0x0e4b('0x64')},'attributes':['id',_0x0e4b('0x35'),'smsPause','updatedAt',_0x0e4b('0x65')]});}})[_0x0e4b('0x29')](function(_0x1a630a){if(_0x1a630a){return{'count':_0x1a630a[_0x0e4b('0x21')],'rows':_[_0x0e4b('0x2f')](_0x1a630a[_0x0e4b('0x48')],function(_0x316d49){return{'membername':_0x316d49[_0x0e4b('0x35')],'UserId':_0x316d49['id'],'queue_name':_0x1c839d[_0x0e4b('0x35')],'SmsQueueId':_0x1c839d['id'],'interface':util[_0x0e4b('0x66')](_0x0e4b('0x67'),_0x0e4b('0x68'),_0x316d49[_0x0e4b('0x35')]),'penalty':0x0,'paused':_0x316d49[_0x0e4b('0x69')],'createdAt':_0x316d49['createdAt'],'updatedAt':_0x316d49['updatedAt']};})};}else{return{'count':0x0,'rows':[]};}})['then'](respondWithFilteredResult(_0x3645e1,_0x2fe287))['catch'](handleError(_0x3645e1,null));};exports[_0x0e4b('0x6a')]=function(_0x1d8ac3,_0x417f25,_0x1f9ab7){var _0x395900={};var _0x25af7a={};var _0x54cddb;var _0x1ce3aa;return db[_0x0e4b('0x30')]['findOne']({'where':{'id':_0x1d8ac3['params']['id']}})[_0x0e4b('0x29')](handleEntityNotFound(_0x417f25,null))[_0x0e4b('0x29')](function(_0x48cc38){if(_0x48cc38){_0x54cddb=_0x48cc38;_0x25af7a[_0x0e4b('0x34')]=_[_0x0e4b('0x37')](db[_0x0e4b('0x6b')][_0x0e4b('0x4b')]);_0x25af7a[_0x0e4b('0x36')]=_[_0x0e4b('0x37')](_0x1d8ac3['query']);_0x25af7a[_0x0e4b('0x38')]=_[_0x0e4b('0x39')](_0x25af7a[_0x0e4b('0x34')],_0x25af7a[_0x0e4b('0x36')]);_0x395900[_0x0e4b('0x3a')]=_[_0x0e4b('0x39')](_0x25af7a[_0x0e4b('0x34')],qs[_0x0e4b('0x3b')](_0x1d8ac3['query'][_0x0e4b('0x3b')]));_0x395900[_0x0e4b('0x3a')]=_0x395900[_0x0e4b('0x3a')][_0x0e4b('0x4c')]?_0x395900[_0x0e4b('0x3a')]:_0x25af7a['model'];_0x395900['order']=qs[_0x0e4b('0x3f')](_0x1d8ac3[_0x0e4b('0x36')]['sort']);_0x395900['where']=qs[_0x0e4b('0x38')](_[_0x0e4b('0x41')](_0x1d8ac3[_0x0e4b('0x36')],_0x25af7a[_0x0e4b('0x38')]));if(_0x1d8ac3[_0x0e4b('0x36')][_0x0e4b('0x42')]){_0x395900[_0x0e4b('0x40')]=_[_0x0e4b('0x43')](_0x395900[_0x0e4b('0x40')],{'$or':_[_0x0e4b('0x2f')](_0x395900[_0x0e4b('0x3a')],function(_0x166f96){var _0x26b583={};_0x26b583[_0x166f96]={'$like':'%'+_0x1d8ac3[_0x0e4b('0x36')]['filter']+'%'};return _0x26b583;})});}_0x395900=_[_0x0e4b('0x43')]({},_0x395900,_0x1d8ac3[_0x0e4b('0x45')]);return _0x54cddb['getTeams'](_0x395900);}})[_0x0e4b('0x29')](function(_0x1c5f1e){if(_0x1c5f1e){_0x1ce3aa=_0x1c5f1e['length'];if(!_0x1d8ac3[_0x0e4b('0x36')][_0x0e4b('0x3c')](_0x0e4b('0x3d'))){_0x395900[_0x0e4b('0x22')]=qs[_0x0e4b('0x22')](_0x1d8ac3[_0x0e4b('0x36')][_0x0e4b('0x22')]);_0x395900[_0x0e4b('0x3e')]=qs[_0x0e4b('0x3e')](_0x1d8ac3['query']['offset']);}return _0x54cddb['getTeams'](_0x395900);}})[_0x0e4b('0x29')](function(_0x4d199a){if(_0x4d199a){return _0x4d199a?{'count':_0x1ce3aa,'rows':_0x4d199a}:null;}})[_0x0e4b('0x29')](respondWithResult(_0x417f25,null))['catch'](handleError(_0x417f25,null));};exports['addTeams']=function(_0x15d57e,_0x5ca0f0,_0x24fbe4){var _0x1a33be=_0x15d57e[_0x0e4b('0x50')][_0x0e4b('0x6c')];return db['Team'][_0x0e4b('0x47')]({'where':{'id':_0x1a33be},'attributes':['id'],'include':[{'model':db[_0x0e4b('0x61')],'as':_0x0e4b('0x6d'),'attributes':['id','name',_0x0e4b('0x6e'),_0x0e4b('0x6f'),_0x0e4b('0x70')],'raw':!![]}]})[_0x0e4b('0x29')](function(_0x2ae9a8){if(_0x2ae9a8){var _0x876f65=_[_0x0e4b('0x71')](_0x2ae9a8,function(_0x29bfa5){var _0x519e7c=_0x29bfa5[_0x0e4b('0x2a')]({'plain':!![]});return _0x519e7c[_0x0e4b('0x6d')];});return db[_0x0e4b('0x30')][_0x0e4b('0x5a')]({'where':{'id':_0x15d57e['params']['id']}})[_0x0e4b('0x29')](function(_0x3fdc80){return db['sequelize']['transaction'](function(_0x877829){return _0x3fdc80[_0x0e4b('0x72')](_0x1a33be,{'transaction':_0x877829})[_0x0e4b('0x29')](function(){return BPromise[_0x0e4b('0x73')](_0x876f65,function(_0x50c965){return db[_0x0e4b('0x5e')][_0x0e4b('0x74')]({'where':{'UserId':_0x50c965['id'],'SmsQueueId':_0x15d57e[_0x0e4b('0x4a')]['id']},'transaction':_0x877829});});})[_0x0e4b('0x29')](function(){_0x876f65[_0x0e4b('0x75')](function(_0x959c2d){socket[_0x0e4b('0x76')](_0x0e4b('0x77'),{'UserId':_0x959c2d['id'],'SmsQueueId':_0x3fdc80['id']});});});});});}})['then'](respondWithStatusCode(_0x5ca0f0,null))[_0x0e4b('0x4e')](handleError(_0x5ca0f0,null));};exports['removeTeams']=function(_0x3468fb,_0x535991,_0x5b941b){return db[_0x0e4b('0x6b')][_0x0e4b('0x47')]({'where':{'id':_0x3468fb[_0x0e4b('0x36')][_0x0e4b('0x6c')]},'attributes':['id'],'include':[{'model':db[_0x0e4b('0x61')],'as':_0x0e4b('0x6d'),'attributes':['id'],'raw':!![]}]})['then'](handleEntityNotFound(_0x535991,null))[_0x0e4b('0x29')](function(_0x2d42b9){var _0xdb91db=_[_0x0e4b('0x2f')](_0x2d42b9,'id');var _0x107324=[];var _0x4a0e2d=[];var _0x2334ed=squel['select']();_0x2334ed[_0x0e4b('0x78')]('tq.TeamId')['from'](_0x0e4b('0x79'),'tq')[_0x0e4b('0x7a')]('user_has_teams','ut',_0x0e4b('0x7b'))[_0x0e4b('0x40')](_0x0e4b('0x7c'),_0x3468fb[_0x0e4b('0x4a')]['id']);for(var _0xa0a2f1=0x0;_0xa0a2f1<_0x2d42b9['length'];_0xa0a2f1+=0x1){let _0x3046f1=_0x2d42b9[_0xa0a2f1];for(var _0x2118a6=0x0;_0x2118a6<_0x3046f1['Agents'][_0x0e4b('0x4c')];_0x2118a6+=0x1){let _0x6855a3=_0x3046f1[_0x0e4b('0x6d')][_0x2118a6];var _0x10877d=_0x2334ed[_0x0e4b('0x7d')]();_0x10877d[_0x0e4b('0x40')]('ut.UserId\x20=\x20?',_0x6855a3['id']);_0x4a0e2d[_0x0e4b('0x7e')](db[_0x0e4b('0x7f')]['query'](_0x10877d[_0x0e4b('0x80')](),{'type':db[_0x0e4b('0x7f')][_0x0e4b('0x81')]['SELECT']})[_0x0e4b('0x29')](function(_0x53390f){if(_0x53390f[_0x0e4b('0x4c')]===0x1){return _0x6855a3['id'];}else{var _0x117833=_[_0x0e4b('0x82')](_[_0x0e4b('0x2f')](_0x53390f,_0x0e4b('0x83')),function(_0x202840){return _[_0x0e4b('0x84')](_0xdb91db,_0x202840);});if(_0x117833){return _0x6855a3['id'];}}}));}}return BPromise[_0x0e4b('0x85')](_0x4a0e2d)[_0x0e4b('0x29')](function(_0x31ddda){_0x107324=_(_0x107324)['union'](_0x31ddda)[_0x0e4b('0x86')]()[_0x0e4b('0x87')]();return db[_0x0e4b('0x30')][_0x0e4b('0x5a')]({'where':{'id':_0x3468fb['params']['id']}})[_0x0e4b('0x29')](function(_0xc1fbaa){return db[_0x0e4b('0x7f')][_0x0e4b('0x88')](function(_0x1b2b0c){return _0xc1fbaa[_0x0e4b('0x89')](_0x3468fb[_0x0e4b('0x36')]['ids'],{'transaction':_0x1b2b0c})['then'](function(){if(!_[_0x0e4b('0x8a')](_0x107324)){return _0xc1fbaa[_0x0e4b('0x8b')](_0x107324,{'transaction':_0x1b2b0c});}})[_0x0e4b('0x29')](function(){_0x107324[_0x0e4b('0x75')](function(_0x32d71f){socket[_0x0e4b('0x76')](_0x0e4b('0x8c'),{'UserId':_0x32d71f,'SmsQueueId':_0xc1fbaa['id']});});});});});});})[_0x0e4b('0x29')](respondWithStatusCode(_0x535991,null))['catch'](handleError(_0x535991,null));};exports[_0x0e4b('0x8d')]=function(_0x33dd5b,_0x257a10,_0x161e16){return db['SmsQueue'][_0x0e4b('0x5a')]({'where':{'id':_0x33dd5b[_0x0e4b('0x4a')]['id']}})['then'](handleEntityNotFound(_0x257a10,null))[_0x0e4b('0x29')](function(_0x17ded1){if(_0x17ded1){return _0x17ded1[_0x0e4b('0x8d')](_0x33dd5b[_0x0e4b('0x50')][_0x0e4b('0x6c')],_['omit'](_0x33dd5b[_0x0e4b('0x50')],[_0x0e4b('0x6c'),'id'])||{})[_0x0e4b('0x8e')](function(_0x350a6b){for(var _0x1b52b4=0x0;_0x1b52b4<_0x33dd5b[_0x0e4b('0x50')][_0x0e4b('0x6c')]['length'];_0x1b52b4+=0x1){socket[_0x0e4b('0x76')](_0x0e4b('0x77'),{'UserId':_0x33dd5b[_0x0e4b('0x50')][_0x0e4b('0x6c')][_0x1b52b4],'SmsQueueId':_0x33dd5b[_0x0e4b('0x4a')]['id']});}return _0x350a6b;});}})['then'](respondWithResult(_0x257a10,null))[_0x0e4b('0x4e')](handleError(_0x257a10,null));};exports[_0x0e4b('0x8b')]=function(_0x24262d,_0x5d65ec,_0x1bd0c7){return db[_0x0e4b('0x30')]['find']({'where':{'id':_0x24262d[_0x0e4b('0x4a')]['id']}})[_0x0e4b('0x29')](handleEntityNotFound(_0x5d65ec,null))[_0x0e4b('0x29')](function(_0x1e4e29){if(_0x1e4e29){return _0x1e4e29['removeAgents'](_0x24262d[_0x0e4b('0x36')]['ids'])[_0x0e4b('0x29')](function(){if(_[_0x0e4b('0x8f')](_0x24262d[_0x0e4b('0x36')][_0x0e4b('0x6c')])){for(var _0x2371a7=0x0;_0x2371a7<_0x24262d[_0x0e4b('0x36')]['ids']['length'];_0x2371a7+=0x1){socket[_0x0e4b('0x76')](_0x0e4b('0x8c'),{'UserId':Number(_0x24262d['query'][_0x0e4b('0x6c')][_0x2371a7]),'SmsQueueId':Number(_0x24262d[_0x0e4b('0x4a')]['id'])});}}else{socket[_0x0e4b('0x76')]('userSmsQueue:remove',{'UserId':Number(_0x24262d[_0x0e4b('0x36')][_0x0e4b('0x6c')]),'SmsQueueId':Number(_0x24262d[_0x0e4b('0x4a')]['id'])});}});}})[_0x0e4b('0x29')](respondWithStatusCode(_0x5d65ec,null))[_0x0e4b('0x4e')](handleError(_0x5d65ec,null));};exports[_0x0e4b('0x90')]=function(_0x22e554,_0x270b32,_0x38b824){var _0xd29f3e={};var _0x39bd41={};var _0x389f0c;var _0x59fb1d;return db[_0x0e4b('0x30')][_0x0e4b('0x5d')]({'where':{'id':_0x22e554[_0x0e4b('0x4a')]['id']}})[_0x0e4b('0x29')](handleEntityNotFound(_0x270b32,null))['then'](function(_0x30e103){if(_0x30e103){_0x389f0c=_0x30e103;_0x39bd41[_0x0e4b('0x34')]=_['keys'](db[_0x0e4b('0x61')][_0x0e4b('0x4b')]);_0x39bd41[_0x0e4b('0x36')]=_[_0x0e4b('0x37')](_0x22e554[_0x0e4b('0x36')]);_0x39bd41[_0x0e4b('0x38')]=_['intersection'](_0x39bd41['model'],_0x39bd41[_0x0e4b('0x36')]);_0xd29f3e['attributes']=_[_0x0e4b('0x39')](_0x39bd41[_0x0e4b('0x34')],qs[_0x0e4b('0x3b')](_0x22e554[_0x0e4b('0x36')][_0x0e4b('0x3b')]));_0xd29f3e[_0x0e4b('0x3a')]=_0xd29f3e['attributes'][_0x0e4b('0x4c')]?_0xd29f3e[_0x0e4b('0x3a')]:_0x39bd41[_0x0e4b('0x34')];_0xd29f3e[_0x0e4b('0x5f')]=qs[_0x0e4b('0x3f')](_0x22e554['query'][_0x0e4b('0x3f')]);_0xd29f3e[_0x0e4b('0x40')]=qs[_0x0e4b('0x38')](_['pick'](_0x22e554[_0x0e4b('0x36')],_0x39bd41[_0x0e4b('0x38')]));if(_0x22e554[_0x0e4b('0x36')][_0x0e4b('0x42')]){_0xd29f3e[_0x0e4b('0x40')]=_['merge'](_0xd29f3e[_0x0e4b('0x40')],{'$or':_[_0x0e4b('0x2f')](_0xd29f3e[_0x0e4b('0x3a')],function(_0x3abb9b){var _0x1b7b85={};_0x1b7b85[_0x3abb9b]={'$like':'%'+_0x22e554[_0x0e4b('0x36')][_0x0e4b('0x42')]+'%'};return _0x1b7b85;})});}_0xd29f3e=_[_0x0e4b('0x43')]({},_0xd29f3e,_0x22e554['options']);return _0x389f0c['getAgents'](_0xd29f3e);}})[_0x0e4b('0x29')](function(_0x45da02){if(_0x45da02){_0x59fb1d=_0x45da02['length'];if(!_0x22e554['query'][_0x0e4b('0x3c')]('nolimit')){_0xd29f3e[_0x0e4b('0x22')]=qs[_0x0e4b('0x22')](_0x22e554[_0x0e4b('0x36')][_0x0e4b('0x22')]);_0xd29f3e[_0x0e4b('0x3e')]=qs[_0x0e4b('0x3e')](_0x22e554[_0x0e4b('0x36')]['offset']);}return _0x389f0c['getAgents'](_0xd29f3e);}})[_0x0e4b('0x29')](function(_0x14b628){if(_0x14b628){return _0x14b628?{'count':_0x59fb1d,'rows':_0x14b628}:null;}})[_0x0e4b('0x29')](respondWithResult(_0x270b32,null))['catch'](handleError(_0x270b32,null));};