ad0aa954c58eb5a1e79edc67612cf02d9520bef1
[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 _0x9e7b=['type','key','model','query','keys','filters','intersection','attributes','hasOwnProperty','nolimit','order','sort','where','merge','filter','options','includeAll','include','rows','catch','show','params','rawAttributes','fields','length','create','body','user','get','role','find','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','describe','getMembers','findOne','UserSmsQueue','pick','SmsQueueId','findAll','User','findAndCountAll','UserId','agent','smsPause','updatedAt','createdAt','format','%s/%s','SIP','Team','getTeams','ids','Agents','online','voicePause','interface','flatMap','sequelize','addTeams','each','findOrCreate','forEach','emit','userSmsQueue:save','removeTeams','select','field','tq.TeamId','team_has_sms_queues','join','user_has_teams','ut.TeamId\x20=\x20tq.TeamId','clone','push','toString','SELECT','every','TeamId','includes','all','union','compact','value','isEmpty','removeAgents','userSmsQueue:remove','addAgents','omit','isArray','getAgents','eml-format','rimraf','fast-json-patch','request-promise','moment','mustache','util','path','sox','to-csv','ejs','lodash','squel','crypto','jsforce','querystring','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','redis','socket.io-emitter','./smsQueue.socket','register','sendStatus','end','status','json','undefined','limit','count','offset','set','apply','reject','save','update','then','destroy','SmsQueues','UserProfileResource','error','stack','name','index','map','SmsQueue','fieldName'];(function(_0x2b4411,_0x2625ed){var _0x8e41ef=function(_0x2aa8c1){while(--_0x2aa8c1){_0x2b4411['push'](_0x2b4411['shift']());}};_0x8e41ef(++_0x2625ed);}(_0x9e7b,0xed));var _0xb9e7=function(_0x35885a,_0x42fed7){_0x35885a=_0x35885a-0x0;var _0xe86249=_0x9e7b[_0x35885a];return _0xe86249;};'use strict';var emlformat=require(_0xb9e7('0x0'));var rimraf=require(_0xb9e7('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0xb9e7('0x2'));var rp=require(_0xb9e7('0x3'));var moment=require(_0xb9e7('0x4'));var BPromise=require('bluebird');var Mustache=require(_0xb9e7('0x5'));var util=require(_0xb9e7('0x6'));var path=require(_0xb9e7('0x7'));var sox=require(_0xb9e7('0x8'));var csv=require(_0xb9e7('0x9'));var ejs=require(_0xb9e7('0xa'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0xb9e7('0xb'));var squel=require(_0xb9e7('0xc'));var crypto=require(_0xb9e7('0xd'));var jsforce=require(_0xb9e7('0xe'));var deskjs=require('desk.js');var toCsv=require(_0xb9e7('0x9'));var querystring=require(_0xb9e7('0xf'));var Papa=require('papaparse');var Redis=require('ioredis');var authService=require(_0xb9e7('0x10'));var qs=require(_0xb9e7('0x11'));var as=require(_0xb9e7('0x12'));var hardwareService=require(_0xb9e7('0x13'));var logger=require(_0xb9e7('0x14'))('api');var utils=require(_0xb9e7('0x15'));var config=require(_0xb9e7('0x16'));var licenseUtil=require(_0xb9e7('0x17'));var db=require(_0xb9e7('0x18'))['db'];config[_0xb9e7('0x19')]=_['defaults'](config['redis'],{'host':'localhost','port':0x18eb});var socket=require(_0xb9e7('0x1a'))(new Redis(config[_0xb9e7('0x19')]));require(_0xb9e7('0x1b'))[_0xb9e7('0x1c')](socket);function respondWithStatusCode(_0x1ba2ec,_0x4ca423){_0x4ca423=_0x4ca423||0xcc;return function(_0x36b87c){if(_0x36b87c){return _0x1ba2ec[_0xb9e7('0x1d')](_0x4ca423);}return _0x1ba2ec['status'](_0x4ca423)[_0xb9e7('0x1e')]();};}function respondWithResult(_0x337552,_0x5157af){_0x5157af=_0x5157af||0xc8;return function(_0x32a300){if(_0x32a300){return _0x337552[_0xb9e7('0x1f')](_0x5157af)[_0xb9e7('0x20')](_0x32a300);}};}function respondWithFilteredResult(_0x4dd995,_0x1188ec){return function(_0x458113){if(_0x458113){var _0x280839=typeof _0x1188ec['offset']===_0xb9e7('0x21')&&typeof _0x1188ec[_0xb9e7('0x22')]===_0xb9e7('0x21');var _0x46c9a7=_0x458113[_0xb9e7('0x23')];var _0x4c3290=_0x280839?0x0:_0x1188ec[_0xb9e7('0x24')];var _0x70e0f8=_0x280839?_0x458113[_0xb9e7('0x23')]:_0x1188ec[_0xb9e7('0x24')]+_0x1188ec['limit'];var _0x3c20d0;if(_0x70e0f8>=_0x46c9a7){_0x70e0f8=_0x46c9a7;_0x3c20d0=0xc8;}else{_0x3c20d0=0xce;}_0x4dd995[_0xb9e7('0x1f')](_0x3c20d0);return _0x4dd995[_0xb9e7('0x25')]('Content-Range',_0x4c3290+'-'+_0x70e0f8+'/'+_0x46c9a7)['json'](_0x458113);}return null;};}function patchUpdates(_0x31f4ee){return function(_0x57c827){try{jsonpatch[_0xb9e7('0x26')](_0x57c827,_0x31f4ee,!![]);}catch(_0x31acec){return BPromise[_0xb9e7('0x27')](_0x31acec);}return _0x57c827[_0xb9e7('0x28')]();};}function saveUpdates(_0x5375d4,_0x91fdeb){return function(_0x139068){if(_0x139068){return _0x139068[_0xb9e7('0x29')](_0x5375d4)[_0xb9e7('0x2a')](function(_0x278b33){return _0x278b33;});}return null;};}function removeEntity(_0x527473,_0x555d87){return function(_0x4d35ca){if(_0x4d35ca){return _0x4d35ca[_0xb9e7('0x2b')]()[_0xb9e7('0x2a')](function(){var _0x442fbe=_0x4d35ca['get']({'plain':!![]});var _0x57a5af=_0xb9e7('0x2c');return db[_0xb9e7('0x2d')][_0xb9e7('0x2b')]({'where':{'type':_0x57a5af,'resourceId':_0x442fbe['id']}})[_0xb9e7('0x2a')](function(){return _0x4d35ca;});})['then'](function(){_0x527473[_0xb9e7('0x1f')](0xcc)['end']();});}};}function handleEntityNotFound(_0x3c725e,_0x30df1d){return function(_0x49b789){if(!_0x49b789){_0x3c725e[_0xb9e7('0x1d')](0x194);}return _0x49b789;};}function handleError(_0xde6b64,_0xe82bd8){_0xe82bd8=_0xe82bd8||0x1f4;return function(_0x186ea4){logger[_0xb9e7('0x2e')](_0x186ea4[_0xb9e7('0x2f')]);if(_0x186ea4[_0xb9e7('0x30')]){delete _0x186ea4[_0xb9e7('0x30')];}_0xde6b64[_0xb9e7('0x1f')](_0xe82bd8)['send'](_0x186ea4);};}exports[_0xb9e7('0x31')]=function(_0x409d33,_0x11d418){var _0x18734a={},_0x1ffb7d={},_0x445c9d={'count':0x0,'rows':[]};var _0x40565e=_[_0xb9e7('0x32')](db[_0xb9e7('0x33')]['rawAttributes'],function(_0x113c9b){return{'name':_0x113c9b[_0xb9e7('0x34')],'type':_0x113c9b[_0xb9e7('0x35')][_0xb9e7('0x36')]};});_0x1ffb7d[_0xb9e7('0x37')]=_[_0xb9e7('0x32')](_0x40565e,_0xb9e7('0x30'));_0x1ffb7d[_0xb9e7('0x38')]=_[_0xb9e7('0x39')](_0x409d33[_0xb9e7('0x38')]);_0x1ffb7d[_0xb9e7('0x3a')]=_[_0xb9e7('0x3b')](_0x1ffb7d[_0xb9e7('0x37')],_0x1ffb7d[_0xb9e7('0x38')]);_0x18734a[_0xb9e7('0x3c')]=_['intersection'](_0x1ffb7d[_0xb9e7('0x37')],qs['fields'](_0x409d33[_0xb9e7('0x38')]['fields']));_0x18734a['attributes']=_0x18734a[_0xb9e7('0x3c')]['length']?_0x18734a[_0xb9e7('0x3c')]:_0x1ffb7d[_0xb9e7('0x37')];if(!_0x409d33[_0xb9e7('0x38')][_0xb9e7('0x3d')](_0xb9e7('0x3e'))){_0x18734a[_0xb9e7('0x22')]=qs[_0xb9e7('0x22')](_0x409d33[_0xb9e7('0x38')][_0xb9e7('0x22')]);_0x18734a[_0xb9e7('0x24')]=qs[_0xb9e7('0x24')](_0x409d33[_0xb9e7('0x38')][_0xb9e7('0x24')]);}_0x18734a[_0xb9e7('0x3f')]=qs[_0xb9e7('0x40')](_0x409d33[_0xb9e7('0x38')]['sort']);_0x18734a[_0xb9e7('0x41')]=qs[_0xb9e7('0x3a')](_['pick'](_0x409d33['query'],_0x1ffb7d[_0xb9e7('0x3a')]),_0x40565e);if(_0x409d33[_0xb9e7('0x38')]['filter']){_0x18734a[_0xb9e7('0x41')]=_[_0xb9e7('0x42')](_0x18734a['where'],{'$or':_[_0xb9e7('0x32')](_0x40565e,function(_0x39ae0){if(_0x39ae0[_0xb9e7('0x35')]!=='VIRTUAL'){var _0x3348c8={};_0x3348c8[_0x39ae0[_0xb9e7('0x30')]]={'$like':'%'+_0x409d33['query'][_0xb9e7('0x43')]+'%'};return _0x3348c8;}})});}_0x18734a=_[_0xb9e7('0x42')]({},_0x18734a,_0x409d33[_0xb9e7('0x44')]);var _0x9be6ed={'where':_0x18734a[_0xb9e7('0x41')]};return db[_0xb9e7('0x33')][_0xb9e7('0x23')](_0x9be6ed)[_0xb9e7('0x2a')](function(_0x1c77f8){_0x445c9d['count']=_0x1c77f8;if(_0x409d33[_0xb9e7('0x38')][_0xb9e7('0x45')]){_0x18734a[_0xb9e7('0x46')]=[{'all':!![]}];}return db[_0xb9e7('0x33')]['findAll'](_0x18734a);})[_0xb9e7('0x2a')](function(_0x508f61){_0x445c9d[_0xb9e7('0x47')]=_0x508f61;return _0x445c9d;})[_0xb9e7('0x2a')](respondWithFilteredResult(_0x11d418,_0x18734a))[_0xb9e7('0x48')](handleError(_0x11d418,null));};exports[_0xb9e7('0x49')]=function(_0x9e2fdb,_0x265c9f){var _0x153167={'raw':!![],'where':{'id':_0x9e2fdb[_0xb9e7('0x4a')]['id']}},_0x5891fd={};_0x5891fd['model']=_[_0xb9e7('0x39')](db[_0xb9e7('0x33')][_0xb9e7('0x4b')]);_0x5891fd['query']=_[_0xb9e7('0x39')](_0x9e2fdb[_0xb9e7('0x38')]);_0x5891fd[_0xb9e7('0x3a')]=_[_0xb9e7('0x3b')](_0x5891fd[_0xb9e7('0x37')],_0x5891fd[_0xb9e7('0x38')]);_0x153167[_0xb9e7('0x3c')]=_[_0xb9e7('0x3b')](_0x5891fd[_0xb9e7('0x37')],qs[_0xb9e7('0x4c')](_0x9e2fdb[_0xb9e7('0x38')]['fields']));_0x153167[_0xb9e7('0x3c')]=_0x153167[_0xb9e7('0x3c')][_0xb9e7('0x4d')]?_0x153167[_0xb9e7('0x3c')]:_0x5891fd[_0xb9e7('0x37')];if(_0x9e2fdb['query'][_0xb9e7('0x45')]){_0x153167[_0xb9e7('0x46')]=[{'all':!![]}];}_0x153167=_[_0xb9e7('0x42')]({},_0x153167,_0x9e2fdb['options']);return db['SmsQueue']['find'](_0x153167)[_0xb9e7('0x2a')](handleEntityNotFound(_0x265c9f,null))['then'](respondWithResult(_0x265c9f,null))[_0xb9e7('0x48')](handleError(_0x265c9f,null));};exports['create']=function(_0x50a81f,_0x2094a8){return db[_0xb9e7('0x33')][_0xb9e7('0x4e')](_0x50a81f[_0xb9e7('0x4f')],{})[_0xb9e7('0x2a')](function(_0x2080be){var _0x3cedad=_0x50a81f[_0xb9e7('0x50')][_0xb9e7('0x51')]({'plain':!![]});if(!_0x3cedad)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x3cedad[_0xb9e7('0x52')]==='user'){var _0x1f6df6=_0x2080be['get']({'plain':!![]});var _0x1fc7f7=_0xb9e7('0x2c');return db['UserProfileSection'][_0xb9e7('0x53')]({'where':{'name':_0x1fc7f7,'userProfileId':_0x3cedad[_0xb9e7('0x54')]},'raw':!![]})[_0xb9e7('0x2a')](function(_0x3b4d73){if(_0x3b4d73&&_0x3b4d73[_0xb9e7('0x55')]===0x0){return db[_0xb9e7('0x2d')][_0xb9e7('0x4e')]({'name':_0x1f6df6[_0xb9e7('0x30')],'resourceId':_0x1f6df6['id'],'type':_0x3b4d73[_0xb9e7('0x30')],'sectionId':_0x3b4d73['id']},{})[_0xb9e7('0x2a')](function(){return _0x2080be;});}else{return _0x2080be;}})[_0xb9e7('0x48')](function(_0x5523e2){logger['error'](_0xb9e7('0x56'),_0x5523e2);throw _0x5523e2;});}return _0x2080be;})[_0xb9e7('0x2a')](respondWithResult(_0x2094a8,0xc9))[_0xb9e7('0x48')](handleError(_0x2094a8,null));};exports[_0xb9e7('0x29')]=function(_0x5a3fe9,_0x5412e9){if(_0x5a3fe9[_0xb9e7('0x4f')]['id']){delete _0x5a3fe9['body']['id'];}return db[_0xb9e7('0x33')][_0xb9e7('0x53')]({'where':{'id':_0x5a3fe9[_0xb9e7('0x4a')]['id']}})[_0xb9e7('0x2a')](handleEntityNotFound(_0x5412e9,null))[_0xb9e7('0x2a')](saveUpdates(_0x5a3fe9[_0xb9e7('0x4f')],null))['then'](respondWithResult(_0x5412e9,null))[_0xb9e7('0x48')](handleError(_0x5412e9,null));};exports['destroy']=function(_0x4af930,_0x306f4c){return db['SmsQueue'][_0xb9e7('0x53')]({'where':{'id':_0x4af930[_0xb9e7('0x4a')]['id']}})[_0xb9e7('0x2a')](handleEntityNotFound(_0x306f4c,null))[_0xb9e7('0x2a')](removeEntity(_0x306f4c,null))[_0xb9e7('0x48')](handleError(_0x306f4c,null));};exports[_0xb9e7('0x57')]=function(_0x47fd36,_0x376ba6){return db[_0xb9e7('0x33')][_0xb9e7('0x57')]()[_0xb9e7('0x2a')](respondWithResult(_0x376ba6,null))[_0xb9e7('0x48')](handleError(_0x376ba6,null));};exports[_0xb9e7('0x58')]=function(_0x44c2c7,_0x5e184a,_0x28f10c){var _0x236057={'raw':!![],'where':{}},_0xb868db={},_0x5b5675;return db[_0xb9e7('0x33')][_0xb9e7('0x59')]({'where':{'id':_0x44c2c7[_0xb9e7('0x4a')]['id']}})[_0xb9e7('0x2a')](handleEntityNotFound(_0x5e184a,null))['then'](function(_0x4868f0){if(_0x4868f0){_0x5b5675=_0x4868f0['get']({'plain':!![]});_0xb868db['model']=_[_0xb9e7('0x39')](db[_0xb9e7('0x5a')][_0xb9e7('0x4b')]);_0xb868db[_0xb9e7('0x38')]=_['keys'](_0x44c2c7['query']);_0xb868db[_0xb9e7('0x3a')]=_[_0xb9e7('0x3b')](_0xb868db[_0xb9e7('0x37')],_0xb868db['query']);_0x236057[_0xb9e7('0x3c')]=_['intersection'](_0xb868db[_0xb9e7('0x37')],qs['fields'](_0x44c2c7[_0xb9e7('0x38')][_0xb9e7('0x4c')]));_0x236057[_0xb9e7('0x3c')]=_0x236057['attributes'][_0xb9e7('0x4d')]?_0x236057[_0xb9e7('0x3c')]:_0xb868db[_0xb9e7('0x37')];if(!_0x44c2c7[_0xb9e7('0x38')][_0xb9e7('0x3d')]('nolimit')){_0x236057[_0xb9e7('0x22')]=qs[_0xb9e7('0x22')](_0x44c2c7[_0xb9e7('0x38')][_0xb9e7('0x22')]);_0x236057['offset']=qs['offset'](_0x44c2c7[_0xb9e7('0x38')][_0xb9e7('0x24')]);}_0x236057['order']=qs[_0xb9e7('0x40')](_0x44c2c7[_0xb9e7('0x38')][_0xb9e7('0x40')]);_0x236057[_0xb9e7('0x41')]=qs[_0xb9e7('0x3a')](_[_0xb9e7('0x5b')](_0x44c2c7['query'],_0xb868db['filters']));_0x236057[_0xb9e7('0x41')][_0xb9e7('0x5c')]=_0x4868f0['id'];if(_0x44c2c7[_0xb9e7('0x38')][_0xb9e7('0x43')]){_0x236057[_0xb9e7('0x41')]=_['merge'](_0x236057['where'],{'$or':_[_0xb9e7('0x32')](_0x236057['attributes'],function(_0x5e3d0c){var _0x1fb093={};_0x1fb093[_0x5e3d0c]={'$like':'%'+_0x44c2c7[_0xb9e7('0x38')]['filter']+'%'};return _0x1fb093;})});}_0x236057=_[_0xb9e7('0x42')]({},_0x236057,_0x44c2c7[_0xb9e7('0x44')]);return db[_0xb9e7('0x5a')][_0xb9e7('0x5d')](_0x236057);}})['then'](function(_0x30f9a4){if(_0x30f9a4){return db[_0xb9e7('0x5e')][_0xb9e7('0x5f')]({'where':{'id':_['map'](_0x30f9a4,_0xb9e7('0x60')),'role':_0xb9e7('0x61')},'attributes':['id',_0xb9e7('0x30'),_0xb9e7('0x62'),_0xb9e7('0x63'),_0xb9e7('0x64')]});}})['then'](function(_0x2dead7){if(_0x2dead7){return{'count':_0x2dead7[_0xb9e7('0x23')],'rows':_['map'](_0x2dead7[_0xb9e7('0x47')],function(_0xc43470){return{'membername':_0xc43470[_0xb9e7('0x30')],'UserId':_0xc43470['id'],'queue_name':_0x5b5675[_0xb9e7('0x30')],'SmsQueueId':_0x5b5675['id'],'interface':util[_0xb9e7('0x65')](_0xb9e7('0x66'),_0xb9e7('0x67'),_0xc43470[_0xb9e7('0x30')]),'penalty':0x0,'paused':_0xc43470[_0xb9e7('0x62')],'createdAt':_0xc43470[_0xb9e7('0x64')],'updatedAt':_0xc43470[_0xb9e7('0x63')]};})};}else{return{'count':0x0,'rows':[]};}})[_0xb9e7('0x2a')](respondWithFilteredResult(_0x5e184a,_0x236057))[_0xb9e7('0x48')](handleError(_0x5e184a,null));};exports['getTeams']=function(_0x2c3552,_0x131c2c,_0x1fcd0c){var _0x40f36a={};var _0x5de9a7={};var _0x4bce59;var _0x4a3820;return db['SmsQueue'][_0xb9e7('0x59')]({'where':{'id':_0x2c3552['params']['id']}})[_0xb9e7('0x2a')](handleEntityNotFound(_0x131c2c,null))[_0xb9e7('0x2a')](function(_0x469543){if(_0x469543){_0x4bce59=_0x469543;_0x5de9a7['model']=_['keys'](db[_0xb9e7('0x68')][_0xb9e7('0x4b')]);_0x5de9a7['query']=_[_0xb9e7('0x39')](_0x2c3552[_0xb9e7('0x38')]);_0x5de9a7['filters']=_[_0xb9e7('0x3b')](_0x5de9a7[_0xb9e7('0x37')],_0x5de9a7['query']);_0x40f36a[_0xb9e7('0x3c')]=_[_0xb9e7('0x3b')](_0x5de9a7[_0xb9e7('0x37')],qs['fields'](_0x2c3552[_0xb9e7('0x38')][_0xb9e7('0x4c')]));_0x40f36a[_0xb9e7('0x3c')]=_0x40f36a['attributes'][_0xb9e7('0x4d')]?_0x40f36a['attributes']:_0x5de9a7[_0xb9e7('0x37')];_0x40f36a[_0xb9e7('0x3f')]=qs[_0xb9e7('0x40')](_0x2c3552['query'][_0xb9e7('0x40')]);_0x40f36a[_0xb9e7('0x41')]=qs['filters'](_[_0xb9e7('0x5b')](_0x2c3552['query'],_0x5de9a7[_0xb9e7('0x3a')]));if(_0x2c3552['query']['filter']){_0x40f36a['where']=_['merge'](_0x40f36a['where'],{'$or':_[_0xb9e7('0x32')](_0x40f36a[_0xb9e7('0x3c')],function(_0x5ac80b){var _0xc5ac14={};_0xc5ac14[_0x5ac80b]={'$like':'%'+_0x2c3552[_0xb9e7('0x38')][_0xb9e7('0x43')]+'%'};return _0xc5ac14;})});}_0x40f36a=_[_0xb9e7('0x42')]({},_0x40f36a,_0x2c3552['options']);return _0x4bce59[_0xb9e7('0x69')](_0x40f36a);}})[_0xb9e7('0x2a')](function(_0x270247){if(_0x270247){_0x4a3820=_0x270247['length'];if(!_0x2c3552[_0xb9e7('0x38')][_0xb9e7('0x3d')](_0xb9e7('0x3e'))){_0x40f36a[_0xb9e7('0x22')]=qs[_0xb9e7('0x22')](_0x2c3552[_0xb9e7('0x38')]['limit']);_0x40f36a['offset']=qs[_0xb9e7('0x24')](_0x2c3552['query'][_0xb9e7('0x24')]);}return _0x4bce59[_0xb9e7('0x69')](_0x40f36a);}})[_0xb9e7('0x2a')](function(_0x18aafe){if(_0x18aafe){return _0x18aafe?{'count':_0x4a3820,'rows':_0x18aafe}:null;}})[_0xb9e7('0x2a')](respondWithResult(_0x131c2c,null))[_0xb9e7('0x48')](handleError(_0x131c2c,null));};exports['addTeams']=function(_0x48c578,_0x2062a2,_0x51ca24){var _0xa74a3f=_0x48c578['body'][_0xb9e7('0x6a')];return db['Team'][_0xb9e7('0x5d')]({'where':{'id':_0xa74a3f},'attributes':['id'],'include':[{'model':db[_0xb9e7('0x5e')],'as':_0xb9e7('0x6b'),'attributes':['id','name',_0xb9e7('0x6c'),_0xb9e7('0x6d'),_0xb9e7('0x6e')],'raw':!![]}]})[_0xb9e7('0x2a')](function(_0x4fc274){if(_0x4fc274){var _0x3b1b3f=_[_0xb9e7('0x6f')](_0x4fc274,function(_0x4122b5){var _0x248956=_0x4122b5['get']({'plain':!![]});return _0x248956[_0xb9e7('0x6b')];});return db[_0xb9e7('0x33')][_0xb9e7('0x53')]({'where':{'id':_0x48c578[_0xb9e7('0x4a')]['id']}})[_0xb9e7('0x2a')](function(_0x12baeb){return db[_0xb9e7('0x70')]['transaction'](function(_0x3ae89f){return _0x12baeb[_0xb9e7('0x71')](_0xa74a3f,{'transaction':_0x3ae89f})[_0xb9e7('0x2a')](function(){return BPromise[_0xb9e7('0x72')](_0x3b1b3f,function(_0x2de6ab){return db['UserSmsQueue'][_0xb9e7('0x73')]({'where':{'UserId':_0x2de6ab['id'],'SmsQueueId':_0x48c578[_0xb9e7('0x4a')]['id']},'transaction':_0x3ae89f});});})[_0xb9e7('0x2a')](function(){_0x3b1b3f[_0xb9e7('0x74')](function(_0x55b088){socket[_0xb9e7('0x75')](_0xb9e7('0x76'),{'UserId':_0x55b088['id'],'SmsQueueId':_0x12baeb['id']});});});});});}})[_0xb9e7('0x2a')](respondWithStatusCode(_0x2062a2,null))[_0xb9e7('0x48')](handleError(_0x2062a2,null));};exports[_0xb9e7('0x77')]=function(_0xc04890,_0x17a04e,_0xbda634){return db[_0xb9e7('0x68')][_0xb9e7('0x5d')]({'where':{'id':_0xc04890[_0xb9e7('0x38')]['ids']},'attributes':['id'],'include':[{'model':db[_0xb9e7('0x5e')],'as':_0xb9e7('0x6b'),'attributes':['id'],'raw':!![]}]})[_0xb9e7('0x2a')](handleEntityNotFound(_0x17a04e,null))[_0xb9e7('0x2a')](function(_0x1a3f1b){var _0x375670=_[_0xb9e7('0x32')](_0x1a3f1b,'id');var _0x493293=[];var _0x465f5f=[];var _0x44cdd5=squel[_0xb9e7('0x78')]();_0x44cdd5[_0xb9e7('0x79')](_0xb9e7('0x7a'))['from'](_0xb9e7('0x7b'),'tq')[_0xb9e7('0x7c')](_0xb9e7('0x7d'),'ut',_0xb9e7('0x7e'))['where']('SmsQueueId\x20=\x20?',_0xc04890[_0xb9e7('0x4a')]['id']);for(var _0x4a6e76=0x0;_0x4a6e76<_0x1a3f1b['length'];_0x4a6e76+=0x1){let _0x225b5b=_0x1a3f1b[_0x4a6e76];for(var _0xe996dd=0x0;_0xe996dd<_0x225b5b['Agents'][_0xb9e7('0x4d')];_0xe996dd+=0x1){let _0x47a62e=_0x225b5b['Agents'][_0xe996dd];var _0x416621=_0x44cdd5[_0xb9e7('0x7f')]();_0x416621[_0xb9e7('0x41')]('ut.UserId\x20=\x20?',_0x47a62e['id']);_0x465f5f[_0xb9e7('0x80')](db[_0xb9e7('0x70')][_0xb9e7('0x38')](_0x416621[_0xb9e7('0x81')](),{'type':db[_0xb9e7('0x70')]['QueryTypes'][_0xb9e7('0x82')]})[_0xb9e7('0x2a')](function(_0x15f683){if(_0x15f683[_0xb9e7('0x4d')]===0x1){return _0x47a62e['id'];}else{var _0x445317=_[_0xb9e7('0x83')](_[_0xb9e7('0x32')](_0x15f683,_0xb9e7('0x84')),function(_0x5c7da5){return _[_0xb9e7('0x85')](_0x375670,_0x5c7da5);});if(_0x445317){return _0x47a62e['id'];}}}));}}return BPromise[_0xb9e7('0x86')](_0x465f5f)['then'](function(_0x2f299f){_0x493293=_(_0x493293)[_0xb9e7('0x87')](_0x2f299f)[_0xb9e7('0x88')]()[_0xb9e7('0x89')]();return db['SmsQueue'][_0xb9e7('0x53')]({'where':{'id':_0xc04890[_0xb9e7('0x4a')]['id']}})['then'](function(_0x1a96c5){return db[_0xb9e7('0x70')]['transaction'](function(_0x2ff4d1){return _0x1a96c5[_0xb9e7('0x77')](_0xc04890[_0xb9e7('0x38')][_0xb9e7('0x6a')],{'transaction':_0x2ff4d1})[_0xb9e7('0x2a')](function(){if(!_[_0xb9e7('0x8a')](_0x493293)){return _0x1a96c5[_0xb9e7('0x8b')](_0x493293,{'transaction':_0x2ff4d1});}})[_0xb9e7('0x2a')](function(){_0x493293[_0xb9e7('0x74')](function(_0x3689f6){socket[_0xb9e7('0x75')](_0xb9e7('0x8c'),{'UserId':_0x3689f6,'SmsQueueId':_0x1a96c5['id']});});});});});});})[_0xb9e7('0x2a')](respondWithStatusCode(_0x17a04e,null))[_0xb9e7('0x48')](handleError(_0x17a04e,null));};exports[_0xb9e7('0x8d')]=function(_0x47661b,_0x3abe86,_0x1837ac){return db['SmsQueue'][_0xb9e7('0x53')]({'where':{'id':_0x47661b[_0xb9e7('0x4a')]['id']}})[_0xb9e7('0x2a')](handleEntityNotFound(_0x3abe86,null))['then'](function(_0x24308a){if(_0x24308a){return _0x24308a[_0xb9e7('0x8d')](_0x47661b[_0xb9e7('0x4f')][_0xb9e7('0x6a')],_[_0xb9e7('0x8e')](_0x47661b[_0xb9e7('0x4f')],[_0xb9e7('0x6a'),'id'])||{})['spread'](function(_0x1551ad){for(var _0x509962=0x0;_0x509962<_0x47661b[_0xb9e7('0x4f')]['ids'][_0xb9e7('0x4d')];_0x509962+=0x1){socket[_0xb9e7('0x75')](_0xb9e7('0x76'),{'UserId':Number(_0x47661b['body'][_0xb9e7('0x6a')][_0x509962]),'SmsQueueId':Number(_0x47661b['params']['id'])});}return _0x1551ad;});}})[_0xb9e7('0x2a')](respondWithResult(_0x3abe86,null))[_0xb9e7('0x48')](handleError(_0x3abe86,null));};exports[_0xb9e7('0x8b')]=function(_0x3b3360,_0x31d6f8,_0x376b21){return db[_0xb9e7('0x33')]['find']({'where':{'id':_0x3b3360[_0xb9e7('0x4a')]['id']}})[_0xb9e7('0x2a')](handleEntityNotFound(_0x31d6f8,null))[_0xb9e7('0x2a')](function(_0x3635e8){if(_0x3635e8){return _0x3635e8[_0xb9e7('0x8b')](_0x3b3360['query'][_0xb9e7('0x6a')])[_0xb9e7('0x2a')](function(){if(_[_0xb9e7('0x8f')](_0x3b3360[_0xb9e7('0x38')]['ids'])){for(var _0x4e5709=0x0;_0x4e5709<_0x3b3360[_0xb9e7('0x38')][_0xb9e7('0x6a')][_0xb9e7('0x4d')];_0x4e5709+=0x1){socket[_0xb9e7('0x75')]('userSmsQueue:remove',{'UserId':Number(_0x3b3360[_0xb9e7('0x38')][_0xb9e7('0x6a')][_0x4e5709]),'SmsQueueId':Number(_0x3b3360[_0xb9e7('0x4a')]['id'])});}}else{socket['emit'](_0xb9e7('0x8c'),{'UserId':Number(_0x3b3360['query'][_0xb9e7('0x6a')]),'SmsQueueId':Number(_0x3b3360['params']['id'])});}});}})[_0xb9e7('0x2a')](respondWithStatusCode(_0x31d6f8,null))[_0xb9e7('0x48')](handleError(_0x31d6f8,null));};exports[_0xb9e7('0x90')]=function(_0x29f1f3,_0x158f6c,_0xec383){var _0x1f005c={};var _0x4be913={};var _0x4388fe;var _0x5bef75;return db[_0xb9e7('0x33')][_0xb9e7('0x59')]({'where':{'id':_0x29f1f3[_0xb9e7('0x4a')]['id']}})[_0xb9e7('0x2a')](handleEntityNotFound(_0x158f6c,null))['then'](function(_0x37a0ce){if(_0x37a0ce){_0x4388fe=_0x37a0ce;_0x4be913[_0xb9e7('0x37')]=_[_0xb9e7('0x39')](db['User'][_0xb9e7('0x4b')]);_0x4be913[_0xb9e7('0x38')]=_[_0xb9e7('0x39')](_0x29f1f3[_0xb9e7('0x38')]);_0x4be913[_0xb9e7('0x3a')]=_[_0xb9e7('0x3b')](_0x4be913[_0xb9e7('0x37')],_0x4be913[_0xb9e7('0x38')]);_0x1f005c[_0xb9e7('0x3c')]=_['intersection'](_0x4be913[_0xb9e7('0x37')],qs['fields'](_0x29f1f3['query']['fields']));_0x1f005c[_0xb9e7('0x3c')]=_0x1f005c[_0xb9e7('0x3c')]['length']?_0x1f005c[_0xb9e7('0x3c')]:_0x4be913[_0xb9e7('0x37')];_0x1f005c[_0xb9e7('0x3f')]=qs[_0xb9e7('0x40')](_0x29f1f3[_0xb9e7('0x38')][_0xb9e7('0x40')]);_0x1f005c[_0xb9e7('0x41')]=qs[_0xb9e7('0x3a')](_[_0xb9e7('0x5b')](_0x29f1f3[_0xb9e7('0x38')],_0x4be913[_0xb9e7('0x3a')]));if(_0x29f1f3[_0xb9e7('0x38')][_0xb9e7('0x43')]){_0x1f005c[_0xb9e7('0x41')]=_[_0xb9e7('0x42')](_0x1f005c[_0xb9e7('0x41')],{'$or':_[_0xb9e7('0x32')](_0x1f005c[_0xb9e7('0x3c')],function(_0x4b43e4){var _0x256d12={};_0x256d12[_0x4b43e4]={'$like':'%'+_0x29f1f3[_0xb9e7('0x38')][_0xb9e7('0x43')]+'%'};return _0x256d12;})});}_0x1f005c=_['merge']({},_0x1f005c,_0x29f1f3[_0xb9e7('0x44')]);return _0x4388fe[_0xb9e7('0x90')](_0x1f005c);}})['then'](function(_0x5d2293){if(_0x5d2293){_0x5bef75=_0x5d2293['length'];if(!_0x29f1f3[_0xb9e7('0x38')][_0xb9e7('0x3d')](_0xb9e7('0x3e'))){_0x1f005c[_0xb9e7('0x22')]=qs[_0xb9e7('0x22')](_0x29f1f3[_0xb9e7('0x38')][_0xb9e7('0x22')]);_0x1f005c['offset']=qs[_0xb9e7('0x24')](_0x29f1f3[_0xb9e7('0x38')][_0xb9e7('0x24')]);}return _0x4388fe['getAgents'](_0x1f005c);}})[_0xb9e7('0x2a')](function(_0x14953a){if(_0x14953a){return _0x14953a?{'count':_0x5bef75,'rows':_0x14953a}:null;}})['then'](respondWithResult(_0x158f6c,null))['catch'](handleError(_0x158f6c,null));};