Built motion from commit 85328c08.|2.5.50
[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 _0x7883=['addAgents','getAgents','eml-format','zip-dir','request-promise','bluebird','mustache','util','path','to-csv','lodash','squel','crypto','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','api','../../config/utils','../../config/environment','../../mysqldb','defaults','redis','socket.io-emitter','./smsQueue.socket','status','json','offset','undefined','limit','set','Content-Range','apply','reject','save','update','then','get','destroy','end','sendStatus','error','stack','name','send','index','map','SmsQueue','rawAttributes','fieldName','type','key','model','query','keys','filters','intersection','attributes','fields','hasOwnProperty','nolimit','order','sort','pick','filter','where','merge','options','count','includeAll','rows','params','length','find','catch','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','SmsQueues','UserProfileSection','autoAssociation','UserProfileResource','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','describe','getMembers','findOne','UserSmsQueue','SmsQueueId','User','findAndCountAll','UserId','agent','smsPause','updatedAt','createdAt','format','SIP','getTeams','addTeams','Team','Agents','interface','flatMap','sequelize','transaction','each','forEach','emit','userSmsQueue:save','removeTeams','findAll','select','field','tq.TeamId','from','team_has_sms_queues','join','user_has_teams','clone','ut.UserId\x20=\x20?','push','toString','SELECT','every','includes','all','union','compact','value','ids','isEmpty','removeAgents','userSmsQueue:remove'];(function(_0x2966a5,_0x473add){var _0x54244c=function(_0x12e99e){while(--_0x12e99e){_0x2966a5['push'](_0x2966a5['shift']());}};_0x54244c(++_0x473add);}(_0x7883,0x8b));var _0x3788=function(_0x1245c0,_0x488078){_0x1245c0=_0x1245c0-0x0;var _0x51c137=_0x7883[_0x1245c0];return _0x51c137;};'use strict';var emlformat=require(_0x3788('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x3788('0x1'));var jsonpatch=require('fast-json-patch');var rp=require(_0x3788('0x2'));var moment=require('moment');var BPromise=require(_0x3788('0x3'));var Mustache=require(_0x3788('0x4'));var util=require(_0x3788('0x5'));var path=require(_0x3788('0x6'));var sox=require('sox');var csv=require(_0x3788('0x7'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x3788('0x8'));var squel=require(_0x3788('0x9'));var crypto=require(_0x3788('0xa'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0x3788('0x7'));var querystring=require(_0x3788('0xb'));var Papa=require(_0x3788('0xc'));var Redis=require(_0x3788('0xd'));var authService=require(_0x3788('0xe'));var qs=require(_0x3788('0xf'));var as=require(_0x3788('0x10'));var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0x3788('0x11'));var utils=require(_0x3788('0x12'));var config=require(_0x3788('0x13'));var licenseUtil=require('../../config/license/util');var db=require(_0x3788('0x14'))['db'];config['redis']=_[_0x3788('0x15')](config[_0x3788('0x16')],{'host':'localhost','port':0x18eb});var socket=require(_0x3788('0x17'))(new Redis(config[_0x3788('0x16')]));require(_0x3788('0x18'))['register'](socket);function respondWithStatusCode(_0x22a309,_0x45b914){_0x45b914=_0x45b914||0xcc;return function(_0x271265){if(_0x271265){return _0x22a309['sendStatus'](_0x45b914);}return _0x22a309[_0x3788('0x19')](_0x45b914)['end']();};}function respondWithResult(_0x42414d,_0x4950db){_0x4950db=_0x4950db||0xc8;return function(_0x1fb49e){if(_0x1fb49e){return _0x42414d['status'](_0x4950db)[_0x3788('0x1a')](_0x1fb49e);}};}function respondWithFilteredResult(_0x499c54,_0x2dbda3){return function(_0xe35abe){if(_0xe35abe){var _0x172b39=typeof _0x2dbda3[_0x3788('0x1b')]===_0x3788('0x1c')&&typeof _0x2dbda3[_0x3788('0x1d')]===_0x3788('0x1c');var _0x1467e6=_0xe35abe['count'];var _0x36d439=_0x172b39?0x0:_0x2dbda3[_0x3788('0x1b')];var _0x557557=_0x172b39?_0xe35abe['count']:_0x2dbda3[_0x3788('0x1b')]+_0x2dbda3[_0x3788('0x1d')];var _0x21e87a;if(_0x557557>=_0x1467e6){_0x557557=_0x1467e6;_0x21e87a=0xc8;}else{_0x21e87a=0xce;}_0x499c54[_0x3788('0x19')](_0x21e87a);return _0x499c54[_0x3788('0x1e')](_0x3788('0x1f'),_0x36d439+'-'+_0x557557+'/'+_0x1467e6)[_0x3788('0x1a')](_0xe35abe);}return null;};}function patchUpdates(_0x4ac476){return function(_0x376eeb){try{jsonpatch[_0x3788('0x20')](_0x376eeb,_0x4ac476,!![]);}catch(_0x5ce22c){return BPromise[_0x3788('0x21')](_0x5ce22c);}return _0x376eeb[_0x3788('0x22')]();};}function saveUpdates(_0x2a045d,_0x31c8de){return function(_0x2a6200){if(_0x2a6200){return _0x2a6200[_0x3788('0x23')](_0x2a045d)[_0x3788('0x24')](function(_0x3de3d8){return _0x3de3d8;});}return null;};}function removeEntity(_0x3a0064,_0x5c1d06){return function(_0x19d327){if(_0x19d327){return _0x19d327['destroy']()[_0x3788('0x24')](function(){var _0x204560=_0x19d327[_0x3788('0x25')]({'plain':!![]});var _0x3bdddd='SmsQueues';return db['UserProfileResource'][_0x3788('0x26')]({'where':{'type':_0x3bdddd,'resourceId':_0x204560['id']}})['then'](function(){return _0x19d327;});})[_0x3788('0x24')](function(){_0x3a0064['status'](0xcc)[_0x3788('0x27')]();});}};}function handleEntityNotFound(_0x2cad23,_0x49a0a4){return function(_0x30547a){if(!_0x30547a){_0x2cad23[_0x3788('0x28')](0x194);}return _0x30547a;};}function handleError(_0x44fca4,_0x19ff9c){_0x19ff9c=_0x19ff9c||0x1f4;return function(_0x4af78f){logger[_0x3788('0x29')](_0x4af78f[_0x3788('0x2a')]);if(_0x4af78f[_0x3788('0x2b')]){delete _0x4af78f[_0x3788('0x2b')];}_0x44fca4[_0x3788('0x19')](_0x19ff9c)[_0x3788('0x2c')](_0x4af78f);};}exports[_0x3788('0x2d')]=function(_0x42c28e,_0x205916){var _0x13fb8f={},_0x400220={},_0x231173={'count':0x0,'rows':[]};var _0x281e99=_[_0x3788('0x2e')](db[_0x3788('0x2f')][_0x3788('0x30')],function(_0x203976){return{'name':_0x203976[_0x3788('0x31')],'type':_0x203976[_0x3788('0x32')][_0x3788('0x33')]};});_0x400220[_0x3788('0x34')]=_[_0x3788('0x2e')](_0x281e99,_0x3788('0x2b'));_0x400220[_0x3788('0x35')]=_[_0x3788('0x36')](_0x42c28e[_0x3788('0x35')]);_0x400220[_0x3788('0x37')]=_[_0x3788('0x38')](_0x400220[_0x3788('0x34')],_0x400220[_0x3788('0x35')]);_0x13fb8f[_0x3788('0x39')]=_['intersection'](_0x400220[_0x3788('0x34')],qs[_0x3788('0x3a')](_0x42c28e[_0x3788('0x35')][_0x3788('0x3a')]));_0x13fb8f[_0x3788('0x39')]=_0x13fb8f[_0x3788('0x39')]['length']?_0x13fb8f[_0x3788('0x39')]:_0x400220[_0x3788('0x34')];if(!_0x42c28e[_0x3788('0x35')][_0x3788('0x3b')](_0x3788('0x3c'))){_0x13fb8f['limit']=qs['limit'](_0x42c28e[_0x3788('0x35')]['limit']);_0x13fb8f[_0x3788('0x1b')]=qs[_0x3788('0x1b')](_0x42c28e['query'][_0x3788('0x1b')]);}_0x13fb8f[_0x3788('0x3d')]=qs[_0x3788('0x3e')](_0x42c28e['query'][_0x3788('0x3e')]);_0x13fb8f['where']=qs[_0x3788('0x37')](_[_0x3788('0x3f')](_0x42c28e[_0x3788('0x35')],_0x400220['filters']),_0x281e99);if(_0x42c28e['query'][_0x3788('0x40')]){_0x13fb8f[_0x3788('0x41')]=_[_0x3788('0x42')](_0x13fb8f['where'],{'$or':_[_0x3788('0x2e')](_0x281e99,function(_0x35f69e){if(_0x35f69e[_0x3788('0x32')]!=='VIRTUAL'){var _0x27d204={};_0x27d204[_0x35f69e['name']]={'$like':'%'+_0x42c28e[_0x3788('0x35')]['filter']+'%'};return _0x27d204;}})});}_0x13fb8f=_[_0x3788('0x42')]({},_0x13fb8f,_0x42c28e[_0x3788('0x43')]);var _0x4309fb={'where':_0x13fb8f[_0x3788('0x41')]};return db['SmsQueue']['count'](_0x4309fb)[_0x3788('0x24')](function(_0x1ac97d){_0x231173[_0x3788('0x44')]=_0x1ac97d;if(_0x42c28e[_0x3788('0x35')][_0x3788('0x45')]){_0x13fb8f['include']=[{'all':!![]}];}return db['SmsQueue']['findAll'](_0x13fb8f);})[_0x3788('0x24')](function(_0x3b87e8){_0x231173[_0x3788('0x46')]=_0x3b87e8;return _0x231173;})[_0x3788('0x24')](respondWithFilteredResult(_0x205916,_0x13fb8f))['catch'](handleError(_0x205916,null));};exports['show']=function(_0x45d0dd,_0x2d0b11){var _0x1d539f={'raw':!![],'where':{'id':_0x45d0dd[_0x3788('0x47')]['id']}},_0x1b2173={};_0x1b2173['model']=_[_0x3788('0x36')](db['SmsQueue'][_0x3788('0x30')]);_0x1b2173[_0x3788('0x35')]=_['keys'](_0x45d0dd['query']);_0x1b2173[_0x3788('0x37')]=_[_0x3788('0x38')](_0x1b2173[_0x3788('0x34')],_0x1b2173[_0x3788('0x35')]);_0x1d539f[_0x3788('0x39')]=_['intersection'](_0x1b2173[_0x3788('0x34')],qs[_0x3788('0x3a')](_0x45d0dd['query'][_0x3788('0x3a')]));_0x1d539f['attributes']=_0x1d539f[_0x3788('0x39')][_0x3788('0x48')]?_0x1d539f['attributes']:_0x1b2173[_0x3788('0x34')];if(_0x45d0dd[_0x3788('0x35')][_0x3788('0x45')]){_0x1d539f['include']=[{'all':!![]}];}_0x1d539f=_[_0x3788('0x42')]({},_0x1d539f,_0x45d0dd[_0x3788('0x43')]);return db[_0x3788('0x2f')][_0x3788('0x49')](_0x1d539f)['then'](handleEntityNotFound(_0x2d0b11,null))[_0x3788('0x24')](respondWithResult(_0x2d0b11,null))[_0x3788('0x4a')](handleError(_0x2d0b11,null));};exports[_0x3788('0x4b')]=function(_0x1df1b2,_0x513bd8){return db[_0x3788('0x2f')][_0x3788('0x4b')](_0x1df1b2[_0x3788('0x4c')],{})[_0x3788('0x24')](function(_0x4501c5){var _0xe58929=_0x1df1b2[_0x3788('0x4d')]['get']({'plain':!![]});if(!_0xe58929)throw new Error(_0x3788('0x4e'));if(_0xe58929[_0x3788('0x4f')]===_0x3788('0x4d')){var _0xaf79fa=_0x4501c5['get']({'plain':!![]});var _0x1d9988=_0x3788('0x50');return db[_0x3788('0x51')]['find']({'where':{'name':_0x1d9988,'userProfileId':_0xe58929['userProfileId']},'raw':!![]})[_0x3788('0x24')](function(_0x10fbf8){if(_0x10fbf8&&_0x10fbf8[_0x3788('0x52')]===0x0){return db[_0x3788('0x53')][_0x3788('0x4b')]({'name':_0xaf79fa['name'],'resourceId':_0xaf79fa['id'],'type':_0x10fbf8[_0x3788('0x2b')],'sectionId':_0x10fbf8['id']},{})['then'](function(){return _0x4501c5;});}else{return _0x4501c5;}})[_0x3788('0x4a')](function(_0x567711){logger['error'](_0x3788('0x54'),_0x567711);throw _0x567711;});}return _0x4501c5;})[_0x3788('0x24')](respondWithResult(_0x513bd8,0xc9))[_0x3788('0x4a')](handleError(_0x513bd8,null));};exports[_0x3788('0x23')]=function(_0x19b4c3,_0x1b68c2){if(_0x19b4c3['body']['id']){delete _0x19b4c3[_0x3788('0x4c')]['id'];}return db[_0x3788('0x2f')]['find']({'where':{'id':_0x19b4c3[_0x3788('0x47')]['id']}})[_0x3788('0x24')](handleEntityNotFound(_0x1b68c2,null))[_0x3788('0x24')](saveUpdates(_0x19b4c3['body'],null))['then'](respondWithResult(_0x1b68c2,null))[_0x3788('0x4a')](handleError(_0x1b68c2,null));};exports[_0x3788('0x26')]=function(_0x3bbba1,_0xa5f468){return db[_0x3788('0x2f')][_0x3788('0x49')]({'where':{'id':_0x3bbba1['params']['id']}})[_0x3788('0x24')](handleEntityNotFound(_0xa5f468,null))['then'](removeEntity(_0xa5f468,null))[_0x3788('0x4a')](handleError(_0xa5f468,null));};exports[_0x3788('0x55')]=function(_0x2ff5ba,_0x3a7ee1){return db[_0x3788('0x2f')][_0x3788('0x55')]()[_0x3788('0x24')](respondWithResult(_0x3a7ee1,null))[_0x3788('0x4a')](handleError(_0x3a7ee1,null));};exports[_0x3788('0x56')]=function(_0x58beaf,_0x1478dd,_0x4af703){var _0x4f6502={'raw':!![],'where':{}},_0x1b89a3={},_0x1d204f;return db[_0x3788('0x2f')][_0x3788('0x57')]({'where':{'id':_0x58beaf[_0x3788('0x47')]['id']}})[_0x3788('0x24')](handleEntityNotFound(_0x1478dd,null))[_0x3788('0x24')](function(_0x44a8ec){if(_0x44a8ec){_0x1d204f=_0x44a8ec['get']({'plain':!![]});_0x1b89a3[_0x3788('0x34')]=_[_0x3788('0x36')](db[_0x3788('0x58')][_0x3788('0x30')]);_0x1b89a3[_0x3788('0x35')]=_['keys'](_0x58beaf['query']);_0x1b89a3[_0x3788('0x37')]=_[_0x3788('0x38')](_0x1b89a3[_0x3788('0x34')],_0x1b89a3['query']);_0x4f6502[_0x3788('0x39')]=_['intersection'](_0x1b89a3['model'],qs[_0x3788('0x3a')](_0x58beaf[_0x3788('0x35')][_0x3788('0x3a')]));_0x4f6502['attributes']=_0x4f6502['attributes']['length']?_0x4f6502[_0x3788('0x39')]:_0x1b89a3[_0x3788('0x34')];if(!_0x58beaf[_0x3788('0x35')][_0x3788('0x3b')]('nolimit')){_0x4f6502['limit']=qs['limit'](_0x58beaf[_0x3788('0x35')][_0x3788('0x1d')]);_0x4f6502['offset']=qs[_0x3788('0x1b')](_0x58beaf['query'][_0x3788('0x1b')]);}_0x4f6502[_0x3788('0x3d')]=qs[_0x3788('0x3e')](_0x58beaf['query']['sort']);_0x4f6502['where']=qs[_0x3788('0x37')](_[_0x3788('0x3f')](_0x58beaf['query'],_0x1b89a3[_0x3788('0x37')]));_0x4f6502[_0x3788('0x41')][_0x3788('0x59')]=_0x44a8ec['id'];if(_0x58beaf[_0x3788('0x35')]['filter']){_0x4f6502[_0x3788('0x41')]=_['merge'](_0x4f6502[_0x3788('0x41')],{'$or':_['map'](_0x4f6502[_0x3788('0x39')],function(_0x2af4b5){var _0x190639={};_0x190639[_0x2af4b5]={'$like':'%'+_0x58beaf[_0x3788('0x35')][_0x3788('0x40')]+'%'};return _0x190639;})});}_0x4f6502=_[_0x3788('0x42')]({},_0x4f6502,_0x58beaf[_0x3788('0x43')]);return db[_0x3788('0x58')]['findAll'](_0x4f6502);}})[_0x3788('0x24')](function(_0x31458f){if(_0x31458f){return db[_0x3788('0x5a')][_0x3788('0x5b')]({'where':{'id':_[_0x3788('0x2e')](_0x31458f,_0x3788('0x5c')),'role':_0x3788('0x5d')},'attributes':['id',_0x3788('0x2b'),_0x3788('0x5e'),_0x3788('0x5f'),_0x3788('0x60')]});}})[_0x3788('0x24')](function(_0x219b1d){if(_0x219b1d){return{'count':_0x219b1d[_0x3788('0x44')],'rows':_['map'](_0x219b1d[_0x3788('0x46')],function(_0x3ddf42){return{'membername':_0x3ddf42[_0x3788('0x2b')],'UserId':_0x3ddf42['id'],'queue_name':_0x1d204f[_0x3788('0x2b')],'SmsQueueId':_0x1d204f['id'],'interface':util[_0x3788('0x61')]('%s/%s',_0x3788('0x62'),_0x3ddf42['name']),'penalty':0x0,'paused':_0x3ddf42[_0x3788('0x5e')],'createdAt':_0x3ddf42[_0x3788('0x60')],'updatedAt':_0x3ddf42['updatedAt']};})};}else{return{'count':0x0,'rows':[]};}})[_0x3788('0x24')](respondWithFilteredResult(_0x1478dd,_0x4f6502))['catch'](handleError(_0x1478dd,null));};exports[_0x3788('0x63')]=function(_0x16aeed,_0x32e0f1,_0x38b8d9){var _0xe114be={};var _0x29a6f5={};var _0x176b49;var _0x5e62a1;return db[_0x3788('0x2f')][_0x3788('0x57')]({'where':{'id':_0x16aeed[_0x3788('0x47')]['id']}})[_0x3788('0x24')](handleEntityNotFound(_0x32e0f1,null))[_0x3788('0x24')](function(_0x21c9bf){if(_0x21c9bf){_0x176b49=_0x21c9bf;_0x29a6f5['model']=_[_0x3788('0x36')](db['Team'][_0x3788('0x30')]);_0x29a6f5[_0x3788('0x35')]=_['keys'](_0x16aeed[_0x3788('0x35')]);_0x29a6f5[_0x3788('0x37')]=_['intersection'](_0x29a6f5[_0x3788('0x34')],_0x29a6f5[_0x3788('0x35')]);_0xe114be[_0x3788('0x39')]=_[_0x3788('0x38')](_0x29a6f5[_0x3788('0x34')],qs[_0x3788('0x3a')](_0x16aeed['query']['fields']));_0xe114be[_0x3788('0x39')]=_0xe114be[_0x3788('0x39')][_0x3788('0x48')]?_0xe114be['attributes']:_0x29a6f5['model'];_0xe114be[_0x3788('0x3d')]=qs[_0x3788('0x3e')](_0x16aeed['query'][_0x3788('0x3e')]);_0xe114be[_0x3788('0x41')]=qs[_0x3788('0x37')](_[_0x3788('0x3f')](_0x16aeed[_0x3788('0x35')],_0x29a6f5[_0x3788('0x37')]));if(_0x16aeed['query'][_0x3788('0x40')]){_0xe114be[_0x3788('0x41')]=_['merge'](_0xe114be[_0x3788('0x41')],{'$or':_[_0x3788('0x2e')](_0xe114be[_0x3788('0x39')],function(_0x289693){var _0x1f29e8={};_0x1f29e8[_0x289693]={'$like':'%'+_0x16aeed['query'][_0x3788('0x40')]+'%'};return _0x1f29e8;})});}_0xe114be=_[_0x3788('0x42')]({},_0xe114be,_0x16aeed[_0x3788('0x43')]);return _0x176b49[_0x3788('0x63')](_0xe114be);}})[_0x3788('0x24')](function(_0x3d4a3a){if(_0x3d4a3a){_0x5e62a1=_0x3d4a3a[_0x3788('0x48')];if(!_0x16aeed[_0x3788('0x35')]['hasOwnProperty'](_0x3788('0x3c'))){_0xe114be[_0x3788('0x1d')]=qs[_0x3788('0x1d')](_0x16aeed[_0x3788('0x35')]['limit']);_0xe114be[_0x3788('0x1b')]=qs[_0x3788('0x1b')](_0x16aeed[_0x3788('0x35')][_0x3788('0x1b')]);}return _0x176b49[_0x3788('0x63')](_0xe114be);}})[_0x3788('0x24')](function(_0x296757){if(_0x296757){return _0x296757?{'count':_0x5e62a1,'rows':_0x296757}:null;}})[_0x3788('0x24')](respondWithResult(_0x32e0f1,null))[_0x3788('0x4a')](handleError(_0x32e0f1,null));};exports[_0x3788('0x64')]=function(_0x597afa,_0x15e1e9,_0x52593c){var _0x5c2b3b=_0x597afa['body']['ids'];return db[_0x3788('0x65')]['findAll']({'where':{'id':_0x5c2b3b},'attributes':['id'],'include':[{'model':db[_0x3788('0x5a')],'as':_0x3788('0x66'),'attributes':['id',_0x3788('0x2b'),'online','voicePause',_0x3788('0x67')],'raw':!![]}]})[_0x3788('0x24')](function(_0x2b46c2){if(_0x2b46c2){var _0x1f680d=_[_0x3788('0x68')](_0x2b46c2,function(_0xf5ccb6){var _0x5624cc=_0xf5ccb6[_0x3788('0x25')]({'plain':!![]});return _0x5624cc['Agents'];});return db['SmsQueue']['find']({'where':{'id':_0x597afa[_0x3788('0x47')]['id']}})['then'](function(_0x691505){return db[_0x3788('0x69')][_0x3788('0x6a')](function(_0x303fe8){return _0x691505[_0x3788('0x64')](_0x5c2b3b,{'transaction':_0x303fe8})[_0x3788('0x24')](function(){return BPromise[_0x3788('0x6b')](_0x1f680d,function(_0x478723){return db[_0x3788('0x58')]['findOrCreate']({'where':{'UserId':_0x478723['id'],'SmsQueueId':_0x597afa[_0x3788('0x47')]['id']},'transaction':_0x303fe8});});})['then'](function(){_0x1f680d[_0x3788('0x6c')](function(_0x3492ec){socket[_0x3788('0x6d')](_0x3788('0x6e'),{'UserId':_0x3492ec['id'],'SmsQueueId':_0x691505['id']});});});});});}})[_0x3788('0x24')](respondWithStatusCode(_0x15e1e9,null))['catch'](handleError(_0x15e1e9,null));};exports[_0x3788('0x6f')]=function(_0x4f553a,_0x1f9186,_0xd4ae7e){return db[_0x3788('0x65')][_0x3788('0x70')]({'where':{'id':_0x4f553a['query']['ids']},'attributes':['id'],'include':[{'model':db[_0x3788('0x5a')],'as':_0x3788('0x66'),'attributes':['id'],'raw':!![]}]})['then'](handleEntityNotFound(_0x1f9186,null))['then'](function(_0x3398bb){var _0x1e9e99=_[_0x3788('0x2e')](_0x3398bb,'id');var _0x20bf58=[];var _0x314d42=[];var _0x53d4cb=squel[_0x3788('0x71')]();_0x53d4cb[_0x3788('0x72')](_0x3788('0x73'))[_0x3788('0x74')](_0x3788('0x75'),'tq')[_0x3788('0x76')](_0x3788('0x77'),'ut','ut.TeamId\x20=\x20tq.TeamId')[_0x3788('0x41')]('SmsQueueId\x20=\x20?',_0x4f553a[_0x3788('0x47')]['id']);for(var _0x2dee3b=0x0;_0x2dee3b<_0x3398bb['length'];_0x2dee3b+=0x1){let _0x7ef853=_0x3398bb[_0x2dee3b];for(var _0x5a8f29=0x0;_0x5a8f29<_0x7ef853['Agents'][_0x3788('0x48')];_0x5a8f29+=0x1){let _0x1b331c=_0x7ef853[_0x3788('0x66')][_0x5a8f29];var _0x4d98fc=_0x53d4cb[_0x3788('0x78')]();_0x4d98fc[_0x3788('0x41')](_0x3788('0x79'),_0x1b331c['id']);_0x314d42[_0x3788('0x7a')](db['sequelize'][_0x3788('0x35')](_0x4d98fc[_0x3788('0x7b')](),{'type':db['sequelize']['QueryTypes'][_0x3788('0x7c')]})[_0x3788('0x24')](function(_0x8dd370){if(_0x8dd370[_0x3788('0x48')]===0x1){return _0x1b331c['id'];}else{var _0x588e8b=_[_0x3788('0x7d')](_[_0x3788('0x2e')](_0x8dd370,'TeamId'),function(_0x3c123d){return _[_0x3788('0x7e')](_0x1e9e99,_0x3c123d);});if(_0x588e8b){return _0x1b331c['id'];}}}));}}return BPromise[_0x3788('0x7f')](_0x314d42)[_0x3788('0x24')](function(_0x1b4f5e){_0x20bf58=_(_0x20bf58)[_0x3788('0x80')](_0x1b4f5e)[_0x3788('0x81')]()[_0x3788('0x82')]();return db[_0x3788('0x2f')][_0x3788('0x49')]({'where':{'id':_0x4f553a[_0x3788('0x47')]['id']}})['then'](function(_0x225823){return db[_0x3788('0x69')][_0x3788('0x6a')](function(_0x3ec8f3){return _0x225823['removeTeams'](_0x4f553a['query'][_0x3788('0x83')],{'transaction':_0x3ec8f3})[_0x3788('0x24')](function(){if(!_[_0x3788('0x84')](_0x20bf58)){return _0x225823[_0x3788('0x85')](_0x20bf58,{'transaction':_0x3ec8f3});}})[_0x3788('0x24')](function(){_0x20bf58[_0x3788('0x6c')](function(_0x55de0c){socket[_0x3788('0x6d')](_0x3788('0x86'),{'UserId':_0x55de0c,'SmsQueueId':_0x225823['id']});});});});});});})[_0x3788('0x24')](respondWithStatusCode(_0x1f9186,null))[_0x3788('0x4a')](handleError(_0x1f9186,null));};exports[_0x3788('0x87')]=function(_0x280bd2,_0x201921,_0x3c7726){return db['SmsQueue']['find']({'where':{'id':_0x280bd2[_0x3788('0x47')]['id']}})[_0x3788('0x24')](handleEntityNotFound(_0x201921,null))['then'](function(_0x1dc075){if(_0x1dc075){return _0x1dc075[_0x3788('0x87')](_0x280bd2[_0x3788('0x4c')][_0x3788('0x83')],_['omit'](_0x280bd2[_0x3788('0x4c')],['ids','id'])||{})['spread'](function(_0x26dff3){for(var _0x4eaf8b=0x0;_0x4eaf8b<_0x280bd2[_0x3788('0x4c')]['ids'][_0x3788('0x48')];_0x4eaf8b+=0x1){socket[_0x3788('0x6d')](_0x3788('0x6e'),{'UserId':Number(_0x280bd2['body'][_0x3788('0x83')][_0x4eaf8b]),'SmsQueueId':Number(_0x280bd2[_0x3788('0x47')]['id'])});}return _0x26dff3;});}})['then'](respondWithResult(_0x201921,null))[_0x3788('0x4a')](handleError(_0x201921,null));};exports[_0x3788('0x85')]=function(_0x142775,_0x53913e,_0x4c1007){return db['SmsQueue'][_0x3788('0x49')]({'where':{'id':_0x142775[_0x3788('0x47')]['id']}})[_0x3788('0x24')](handleEntityNotFound(_0x53913e,null))[_0x3788('0x24')](function(_0x5bed77){if(_0x5bed77){return _0x5bed77[_0x3788('0x85')](_0x142775[_0x3788('0x35')]['ids'])[_0x3788('0x24')](function(){if(_['isArray'](_0x142775[_0x3788('0x35')][_0x3788('0x83')])){for(var _0x5b8583=0x0;_0x5b8583<_0x142775[_0x3788('0x35')]['ids'][_0x3788('0x48')];_0x5b8583+=0x1){socket[_0x3788('0x6d')](_0x3788('0x86'),{'UserId':Number(_0x142775[_0x3788('0x35')][_0x3788('0x83')][_0x5b8583]),'SmsQueueId':Number(_0x142775[_0x3788('0x47')]['id'])});}}else{socket['emit'](_0x3788('0x86'),{'UserId':Number(_0x142775[_0x3788('0x35')][_0x3788('0x83')]),'SmsQueueId':Number(_0x142775[_0x3788('0x47')]['id'])});}});}})[_0x3788('0x24')](respondWithStatusCode(_0x53913e,null))[_0x3788('0x4a')](handleError(_0x53913e,null));};exports[_0x3788('0x88')]=function(_0x2d1d01,_0x2e5dfc,_0x20beea){var _0x480e42={};var _0x2f954a={};var _0x417776;var _0x4b1eb9;return db[_0x3788('0x2f')][_0x3788('0x57')]({'where':{'id':_0x2d1d01[_0x3788('0x47')]['id']}})['then'](handleEntityNotFound(_0x2e5dfc,null))[_0x3788('0x24')](function(_0x2e2de6){if(_0x2e2de6){_0x417776=_0x2e2de6;_0x2f954a[_0x3788('0x34')]=_[_0x3788('0x36')](db[_0x3788('0x5a')][_0x3788('0x30')]);_0x2f954a['query']=_[_0x3788('0x36')](_0x2d1d01['query']);_0x2f954a[_0x3788('0x37')]=_[_0x3788('0x38')](_0x2f954a[_0x3788('0x34')],_0x2f954a[_0x3788('0x35')]);_0x480e42[_0x3788('0x39')]=_[_0x3788('0x38')](_0x2f954a[_0x3788('0x34')],qs[_0x3788('0x3a')](_0x2d1d01[_0x3788('0x35')][_0x3788('0x3a')]));_0x480e42['attributes']=_0x480e42[_0x3788('0x39')]['length']?_0x480e42[_0x3788('0x39')]:_0x2f954a['model'];_0x480e42[_0x3788('0x3d')]=qs[_0x3788('0x3e')](_0x2d1d01[_0x3788('0x35')]['sort']);_0x480e42[_0x3788('0x41')]=qs['filters'](_[_0x3788('0x3f')](_0x2d1d01[_0x3788('0x35')],_0x2f954a['filters']));if(_0x2d1d01[_0x3788('0x35')][_0x3788('0x40')]){_0x480e42[_0x3788('0x41')]=_[_0x3788('0x42')](_0x480e42['where'],{'$or':_[_0x3788('0x2e')](_0x480e42[_0x3788('0x39')],function(_0x41cd22){var _0x2db9a7={};_0x2db9a7[_0x41cd22]={'$like':'%'+_0x2d1d01['query'][_0x3788('0x40')]+'%'};return _0x2db9a7;})});}_0x480e42=_[_0x3788('0x42')]({},_0x480e42,_0x2d1d01[_0x3788('0x43')]);return _0x417776[_0x3788('0x88')](_0x480e42);}})[_0x3788('0x24')](function(_0x31b13c){if(_0x31b13c){_0x4b1eb9=_0x31b13c['length'];if(!_0x2d1d01[_0x3788('0x35')][_0x3788('0x3b')]('nolimit')){_0x480e42[_0x3788('0x1d')]=qs[_0x3788('0x1d')](_0x2d1d01[_0x3788('0x35')][_0x3788('0x1d')]);_0x480e42['offset']=qs[_0x3788('0x1b')](_0x2d1d01[_0x3788('0x35')][_0x3788('0x1b')]);}return _0x417776[_0x3788('0x88')](_0x480e42);}})[_0x3788('0x24')](function(_0x4a8fb8){if(_0x4a8fb8){return _0x4a8fb8?{'count':_0x4b1eb9,'rows':_0x4a8fb8}:null;}})['then'](respondWithResult(_0x2e5dfc,null))[_0x3788('0x4a')](handleError(_0x2e5dfc,null));};