c1f91f306a5a8fda0d5b2b29fba4df241585d2ec
[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 _0x5162=['querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/environment','../../config/license/util','../../mysqldb','redis','localhost','socket.io-emitter','./smsQueue.socket','register','sendStatus','status','end','json','count','offset','limit','set','Content-Range','apply','update','then','destroy','get','SmsQueues','UserProfileResource','error','name','send','index','map','SmsQueue','rawAttributes','type','model','keys','query','filters','intersection','attributes','fields','hasOwnProperty','nolimit','order','sort','where','filter','merge','VIRTUAL','options','includeAll','include','findAll','rows','catch','params','find','create','user','role','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','body','describe','UserSmsQueue','length','SmsQueueId','User','UserId','agent','smsPause','updatedAt','createdAt','format','%s/%s','SIP','findOne','Team','getTeams','addTeams','Agents','online','interface','flatMap','each','findOrCreate','forEach','emit','userSmsQueue:save','ids','select','field','tq.TeamId','from','team_has_sms_queues','join','user_has_teams','ut.TeamId\x20=\x20tq.TeamId','SmsQueueId\x20=\x20?','clone','ut.UserId\x20=\x20?','push','sequelize','toString','QueryTypes','TeamId','includes','all','union','compact','transaction','removeTeams','isEmpty','removeAgents','userSmsQueue:remove','addAgents','omit','spread','isArray','getAgents','pick','html-pdf','request-promise','moment','bluebird','mustache','util','path','sox','squel','crypto','jsforce','desk.js','to-csv'];(function(_0x36b037,_0x2b234e){var _0x409194=function(_0xddc9dc){while(--_0xddc9dc){_0x36b037['push'](_0x36b037['shift']());}};_0x409194(++_0x2b234e);}(_0x5162,0x103));var _0x2516=function(_0x48c998,_0x37d255){_0x48c998=_0x48c998-0x0;var _0x59c2a2=_0x5162[_0x48c998];return _0x59c2a2;};'use strict';var pdf=require(_0x2516('0x0'));var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require(_0x2516('0x1'));var moment=require(_0x2516('0x2'));var BPromise=require(_0x2516('0x3'));var Mustache=require(_0x2516('0x4'));var util=require(_0x2516('0x5'));var path=require(_0x2516('0x6'));var sox=require(_0x2516('0x7'));var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var _=require('lodash');var squel=require(_0x2516('0x8'));var crypto=require(_0x2516('0x9'));var jsforce=require(_0x2516('0xa'));var deskjs=require(_0x2516('0xb'));var toCsv=require(_0x2516('0xc'));var querystring=require(_0x2516('0xd'));var Papa=require(_0x2516('0xe'));var Redis=require('ioredis');var authService=require(_0x2516('0xf'));var qs=require(_0x2516('0x10'));var as=require(_0x2516('0x11'));var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')('api');var utils=require('../../config/utils');var config=require(_0x2516('0x12'));var licenseUtil=require(_0x2516('0x13'));var db=require(_0x2516('0x14'))['db'];config[_0x2516('0x15')]=_['defaults'](config[_0x2516('0x15')],{'host':_0x2516('0x16'),'port':0x18eb});var socket=require(_0x2516('0x17'))(new Redis(config[_0x2516('0x15')]));require(_0x2516('0x18'))[_0x2516('0x19')](socket);function respondWithStatusCode(_0x3e5e0f,_0x2edb47){_0x2edb47=_0x2edb47||0xcc;return function(_0x1b3c7e){if(_0x1b3c7e){return _0x3e5e0f[_0x2516('0x1a')](_0x2edb47);}return _0x3e5e0f[_0x2516('0x1b')](_0x2edb47)[_0x2516('0x1c')]();};}function respondWithResult(_0x19aacb,_0x5dee15){_0x5dee15=_0x5dee15||0xc8;return function(_0x3543d){if(_0x3543d){return _0x19aacb['status'](_0x5dee15)[_0x2516('0x1d')](_0x3543d);}};}function respondWithFilteredResult(_0x1ced29,_0x1a1005){return function(_0x564d05){if(_0x564d05){var _0x1979d7=_0x564d05[_0x2516('0x1e')],_0x5e96c7=_0x1a1005[_0x2516('0x1f')],_0x532d46=_0x1a1005[_0x2516('0x1f')]+_0x1a1005[_0x2516('0x20')],_0x31a817;if(_0x532d46>=_0x1979d7){_0x532d46=_0x1979d7;_0x31a817=0xc8;}else{_0x31a817=0xce;}_0x1ced29[_0x2516('0x1b')](_0x31a817);return _0x1ced29[_0x2516('0x21')](_0x2516('0x22'),_0x5e96c7+'-'+_0x532d46+'/'+_0x1979d7)[_0x2516('0x1d')](_0x564d05);}return null;};}function patchUpdates(_0x37485b){return function(_0x39ba5b){try{jsonpatch[_0x2516('0x23')](_0x39ba5b,_0x37485b,!![]);}catch(_0x1b0831){return BPromise['reject'](_0x1b0831);}return _0x39ba5b['save']();};}function saveUpdates(_0x12db4d,_0x1c8993){return function(_0x24abe0){if(_0x24abe0){return _0x24abe0[_0x2516('0x24')](_0x12db4d)[_0x2516('0x25')](function(_0x32de7a){return _0x32de7a;});}return null;};}function removeEntity(_0x3d906d,_0x950477){return function(_0x4b1d4f){if(_0x4b1d4f){return _0x4b1d4f[_0x2516('0x26')]()[_0x2516('0x25')](function(){var _0x774b60=_0x4b1d4f[_0x2516('0x27')]({'plain':!![]});var _0x47f4fb=_0x2516('0x28');return db[_0x2516('0x29')][_0x2516('0x26')]({'where':{'type':_0x47f4fb,'resourceId':_0x774b60['id']}})[_0x2516('0x25')](function(){return _0x4b1d4f;});})[_0x2516('0x25')](function(){_0x3d906d['status'](0xcc)[_0x2516('0x1c')]();});}};}function handleEntityNotFound(_0x1750e7,_0x935035){return function(_0x2cb847){if(!_0x2cb847){_0x1750e7[_0x2516('0x1a')](0x194);}return _0x2cb847;};}function handleError(_0x285e67,_0x556f01){_0x556f01=_0x556f01||0x1f4;return function(_0x136893){logger[_0x2516('0x2a')](_0x136893['stack']);if(_0x136893[_0x2516('0x2b')]){delete _0x136893[_0x2516('0x2b')];}_0x285e67[_0x2516('0x1b')](_0x556f01)[_0x2516('0x2c')](_0x136893);};}exports[_0x2516('0x2d')]=function(_0x170324,_0x2e92f2){var _0x3c1daf={},_0x10f9ec={},_0x12d790={'count':0x0,'rows':[]};var _0xc0d4a9=_[_0x2516('0x2e')](db[_0x2516('0x2f')][_0x2516('0x30')],function(_0xe29221){return{'name':_0xe29221['fieldName'],'type':_0xe29221[_0x2516('0x31')]['key']};});_0x10f9ec[_0x2516('0x32')]=_['map'](_0xc0d4a9,_0x2516('0x2b'));_0x10f9ec['query']=_[_0x2516('0x33')](_0x170324[_0x2516('0x34')]);_0x10f9ec[_0x2516('0x35')]=_[_0x2516('0x36')](_0x10f9ec[_0x2516('0x32')],_0x10f9ec[_0x2516('0x34')]);_0x3c1daf[_0x2516('0x37')]=_[_0x2516('0x36')](_0x10f9ec[_0x2516('0x32')],qs['fields'](_0x170324[_0x2516('0x34')][_0x2516('0x38')]));_0x3c1daf[_0x2516('0x37')]=_0x3c1daf[_0x2516('0x37')]['length']?_0x3c1daf['attributes']:_0x10f9ec[_0x2516('0x32')];if(!_0x170324[_0x2516('0x34')][_0x2516('0x39')](_0x2516('0x3a'))){_0x3c1daf[_0x2516('0x20')]=qs[_0x2516('0x20')](_0x170324[_0x2516('0x34')][_0x2516('0x20')]);_0x3c1daf[_0x2516('0x1f')]=qs[_0x2516('0x1f')](_0x170324['query']['offset']);}_0x3c1daf[_0x2516('0x3b')]=qs[_0x2516('0x3c')](_0x170324['query']['sort']);_0x3c1daf[_0x2516('0x3d')]=qs[_0x2516('0x35')](_['pick'](_0x170324[_0x2516('0x34')],_0x10f9ec['filters']),_0xc0d4a9);if(_0x170324[_0x2516('0x34')][_0x2516('0x3e')]){_0x3c1daf['where']=_[_0x2516('0x3f')](_0x3c1daf[_0x2516('0x3d')],{'$or':_[_0x2516('0x2e')](_0xc0d4a9,function(_0x194c9d){if(_0x194c9d[_0x2516('0x31')]!==_0x2516('0x40')){var _0x2137a4={};_0x2137a4[_0x194c9d[_0x2516('0x2b')]]={'$like':'%'+_0x170324[_0x2516('0x34')][_0x2516('0x3e')]+'%'};return _0x2137a4;}})});}_0x3c1daf=_[_0x2516('0x3f')]({},_0x3c1daf,_0x170324[_0x2516('0x41')]);var _0x89b14c={'where':_0x3c1daf['where']};return db[_0x2516('0x2f')][_0x2516('0x1e')](_0x89b14c)['then'](function(_0xfd6236){_0x12d790[_0x2516('0x1e')]=_0xfd6236;if(_0x170324[_0x2516('0x34')][_0x2516('0x42')]){_0x3c1daf[_0x2516('0x43')]=[{'all':!![]}];}return db['SmsQueue'][_0x2516('0x44')](_0x3c1daf);})[_0x2516('0x25')](function(_0x160801){_0x12d790[_0x2516('0x45')]=_0x160801;return _0x12d790;})[_0x2516('0x25')](respondWithFilteredResult(_0x2e92f2,_0x3c1daf))[_0x2516('0x46')](handleError(_0x2e92f2,null));};exports['show']=function(_0x172634,_0x30fb17){var _0xe64acc={'raw':!![],'where':{'id':_0x172634[_0x2516('0x47')]['id']}},_0x17d344={};_0x17d344[_0x2516('0x32')]=_[_0x2516('0x33')](db['SmsQueue'][_0x2516('0x30')]);_0x17d344['query']=_[_0x2516('0x33')](_0x172634['query']);_0x17d344[_0x2516('0x35')]=_[_0x2516('0x36')](_0x17d344[_0x2516('0x32')],_0x17d344['query']);_0xe64acc['attributes']=_[_0x2516('0x36')](_0x17d344[_0x2516('0x32')],qs['fields'](_0x172634['query'][_0x2516('0x38')]));_0xe64acc[_0x2516('0x37')]=_0xe64acc[_0x2516('0x37')]['length']?_0xe64acc[_0x2516('0x37')]:_0x17d344['model'];if(_0x172634[_0x2516('0x34')][_0x2516('0x42')]){_0xe64acc[_0x2516('0x43')]=[{'all':!![]}];}_0xe64acc=_[_0x2516('0x3f')]({},_0xe64acc,_0x172634['options']);return db[_0x2516('0x2f')][_0x2516('0x48')](_0xe64acc)[_0x2516('0x25')](handleEntityNotFound(_0x30fb17,null))[_0x2516('0x25')](respondWithResult(_0x30fb17,null))[_0x2516('0x46')](handleError(_0x30fb17,null));};exports['create']=function(_0x33756a,_0x226466){return db[_0x2516('0x2f')][_0x2516('0x49')](_0x33756a['body'],{})[_0x2516('0x25')](function(_0x35c1a5){var _0x19b57a=_0x33756a[_0x2516('0x4a')][_0x2516('0x27')]({'plain':!![]});if(!_0x19b57a)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x19b57a[_0x2516('0x4b')]===_0x2516('0x4a')){var _0x136d5c=_0x35c1a5[_0x2516('0x27')]({'plain':!![]});var _0x1ebe64=_0x2516('0x28');return db['UserProfileSection']['find']({'where':{'name':_0x1ebe64,'userProfileId':_0x19b57a['userProfileId']},'raw':!![]})[_0x2516('0x25')](function(_0x4f7eb4){if(_0x4f7eb4&&_0x4f7eb4['autoAssociation']===0x0){return db['UserProfileResource'][_0x2516('0x49')]({'name':_0x136d5c[_0x2516('0x2b')],'resourceId':_0x136d5c['id'],'type':_0x4f7eb4[_0x2516('0x2b')],'sectionId':_0x4f7eb4['id']},{})[_0x2516('0x25')](function(){return _0x35c1a5;});}else{return _0x35c1a5;}})[_0x2516('0x46')](function(_0x5cbfba){logger[_0x2516('0x2a')](_0x2516('0x4c'),_0x5cbfba);throw _0x5cbfba;});}return _0x35c1a5;})[_0x2516('0x25')](respondWithResult(_0x226466,0xc9))['catch'](handleError(_0x226466,null));};exports[_0x2516('0x24')]=function(_0x350206,_0x4a7db6){if(_0x350206[_0x2516('0x4d')]['id']){delete _0x350206[_0x2516('0x4d')]['id'];}return db[_0x2516('0x2f')][_0x2516('0x48')]({'where':{'id':_0x350206[_0x2516('0x47')]['id']}})['then'](handleEntityNotFound(_0x4a7db6,null))['then'](saveUpdates(_0x350206[_0x2516('0x4d')],null))['then'](respondWithResult(_0x4a7db6,null))[_0x2516('0x46')](handleError(_0x4a7db6,null));};exports['destroy']=function(_0x275c02,_0x3e4b93){return db[_0x2516('0x2f')][_0x2516('0x48')]({'where':{'id':_0x275c02[_0x2516('0x47')]['id']}})[_0x2516('0x25')](handleEntityNotFound(_0x3e4b93,null))[_0x2516('0x25')](removeEntity(_0x3e4b93,null))[_0x2516('0x46')](handleError(_0x3e4b93,null));};exports[_0x2516('0x4e')]=function(_0xe6bfc7,_0x3f2a6e){return db['SmsQueue'][_0x2516('0x4e')]()[_0x2516('0x25')](respondWithResult(_0x3f2a6e,null))[_0x2516('0x46')](handleError(_0x3f2a6e,null));};exports['getMembers']=function(_0x26715c,_0x58eff3,_0x435450){var _0x10e899={'raw':!![],'where':{}},_0x3d9e2d={},_0x505ccd;return db['SmsQueue']['findOne']({'where':{'id':_0x26715c[_0x2516('0x47')]['id']}})[_0x2516('0x25')](handleEntityNotFound(_0x58eff3,null))[_0x2516('0x25')](function(_0x2b18c3){if(_0x2b18c3){_0x505ccd=_0x2b18c3['get']({'plain':!![]});_0x3d9e2d[_0x2516('0x32')]=_[_0x2516('0x33')](db[_0x2516('0x4f')]['rawAttributes']);_0x3d9e2d[_0x2516('0x34')]=_[_0x2516('0x33')](_0x26715c[_0x2516('0x34')]);_0x3d9e2d[_0x2516('0x35')]=_[_0x2516('0x36')](_0x3d9e2d[_0x2516('0x32')],_0x3d9e2d[_0x2516('0x34')]);_0x10e899[_0x2516('0x37')]=_[_0x2516('0x36')](_0x3d9e2d[_0x2516('0x32')],qs[_0x2516('0x38')](_0x26715c[_0x2516('0x34')][_0x2516('0x38')]));_0x10e899['attributes']=_0x10e899[_0x2516('0x37')][_0x2516('0x50')]?_0x10e899[_0x2516('0x37')]:_0x3d9e2d[_0x2516('0x32')];if(!_0x26715c[_0x2516('0x34')][_0x2516('0x39')](_0x2516('0x3a'))){_0x10e899['limit']=qs[_0x2516('0x20')](_0x26715c[_0x2516('0x34')][_0x2516('0x20')]);_0x10e899[_0x2516('0x1f')]=qs[_0x2516('0x1f')](_0x26715c[_0x2516('0x34')]['offset']);}_0x10e899['order']=qs['sort'](_0x26715c[_0x2516('0x34')][_0x2516('0x3c')]);_0x10e899[_0x2516('0x3d')]=qs[_0x2516('0x35')](_['pick'](_0x26715c['query'],_0x3d9e2d[_0x2516('0x35')]));_0x10e899['where'][_0x2516('0x51')]=_0x2b18c3['id'];if(_0x26715c[_0x2516('0x34')]['filter']){_0x10e899[_0x2516('0x3d')]=_[_0x2516('0x3f')](_0x10e899[_0x2516('0x3d')],{'$or':_[_0x2516('0x2e')](_0x10e899[_0x2516('0x37')],function(_0x261951){var _0x12be1e={};_0x12be1e[_0x261951]={'$like':'%'+_0x26715c[_0x2516('0x34')][_0x2516('0x3e')]+'%'};return _0x12be1e;})});}_0x10e899=_['merge']({},_0x10e899,_0x26715c['options']);return db[_0x2516('0x4f')][_0x2516('0x44')](_0x10e899);}})[_0x2516('0x25')](function(_0x5115a1){if(_0x5115a1){return db[_0x2516('0x52')]['findAndCountAll']({'where':{'id':_[_0x2516('0x2e')](_0x5115a1,_0x2516('0x53')),'role':_0x2516('0x54')},'attributes':['id',_0x2516('0x2b'),_0x2516('0x55'),_0x2516('0x56'),_0x2516('0x57')]});}})[_0x2516('0x25')](function(_0x6029a3){if(_0x6029a3){return{'count':_0x6029a3[_0x2516('0x1e')],'rows':_['map'](_0x6029a3['rows'],function(_0x317942){return{'membername':_0x317942['name'],'UserId':_0x317942['id'],'queue_name':_0x505ccd['name'],'SmsQueueId':_0x505ccd['id'],'interface':util[_0x2516('0x58')](_0x2516('0x59'),_0x2516('0x5a'),_0x317942[_0x2516('0x2b')]),'penalty':0x0,'paused':_0x317942[_0x2516('0x55')],'createdAt':_0x317942[_0x2516('0x57')],'updatedAt':_0x317942[_0x2516('0x56')]};})};}else{return{'count':0x0,'rows':[]};}})[_0x2516('0x25')](respondWithFilteredResult(_0x58eff3,_0x10e899))[_0x2516('0x46')](handleError(_0x58eff3,null));};exports['getTeams']=function(_0xe966c8,_0x2e1029,_0x350562){var _0x55aac6={};var _0x5dca12={};var _0x9df753;var _0x4203e3;return db[_0x2516('0x2f')][_0x2516('0x5b')]({'where':{'id':_0xe966c8[_0x2516('0x47')]['id']}})[_0x2516('0x25')](handleEntityNotFound(_0x2e1029,null))['then'](function(_0x373bbc){if(_0x373bbc){_0x9df753=_0x373bbc;_0x5dca12['model']=_['keys'](db[_0x2516('0x5c')][_0x2516('0x30')]);_0x5dca12[_0x2516('0x34')]=_['keys'](_0xe966c8[_0x2516('0x34')]);_0x5dca12[_0x2516('0x35')]=_[_0x2516('0x36')](_0x5dca12[_0x2516('0x32')],_0x5dca12['query']);_0x55aac6[_0x2516('0x37')]=_[_0x2516('0x36')](_0x5dca12[_0x2516('0x32')],qs[_0x2516('0x38')](_0xe966c8['query'][_0x2516('0x38')]));_0x55aac6[_0x2516('0x37')]=_0x55aac6[_0x2516('0x37')]['length']?_0x55aac6[_0x2516('0x37')]:_0x5dca12['model'];_0x55aac6[_0x2516('0x3b')]=qs[_0x2516('0x3c')](_0xe966c8[_0x2516('0x34')][_0x2516('0x3c')]);_0x55aac6[_0x2516('0x3d')]=qs['filters'](_['pick'](_0xe966c8['query'],_0x5dca12[_0x2516('0x35')]));if(_0xe966c8[_0x2516('0x34')]['filter']){_0x55aac6[_0x2516('0x3d')]=_[_0x2516('0x3f')](_0x55aac6[_0x2516('0x3d')],{'$or':_[_0x2516('0x2e')](_0x55aac6[_0x2516('0x37')],function(_0x20ee24){var _0x493c5c={};_0x493c5c[_0x20ee24]={'$like':'%'+_0xe966c8[_0x2516('0x34')][_0x2516('0x3e')]+'%'};return _0x493c5c;})});}_0x55aac6=_[_0x2516('0x3f')]({},_0x55aac6,_0xe966c8['options']);return _0x9df753['getTeams'](_0x55aac6);}})['then'](function(_0x50dd15){if(_0x50dd15){_0x4203e3=_0x50dd15[_0x2516('0x50')];if(!_0xe966c8[_0x2516('0x34')][_0x2516('0x39')]('nolimit')){_0x55aac6['limit']=qs['limit'](_0xe966c8[_0x2516('0x34')][_0x2516('0x20')]);_0x55aac6[_0x2516('0x1f')]=qs[_0x2516('0x1f')](_0xe966c8[_0x2516('0x34')][_0x2516('0x1f')]);}return _0x9df753[_0x2516('0x5d')](_0x55aac6);}})[_0x2516('0x25')](function(_0x5e9bb0){if(_0x5e9bb0){return _0x5e9bb0?{'count':_0x4203e3,'rows':_0x5e9bb0}:null;}})[_0x2516('0x25')](respondWithResult(_0x2e1029,null))[_0x2516('0x46')](handleError(_0x2e1029,null));};exports[_0x2516('0x5e')]=function(_0x320d38,_0x3e1a27,_0x51f950){var _0x351a53=_0x320d38[_0x2516('0x4d')]['ids'];return db[_0x2516('0x5c')][_0x2516('0x44')]({'where':{'id':_0x351a53},'attributes':['id'],'include':[{'model':db[_0x2516('0x52')],'as':_0x2516('0x5f'),'attributes':['id',_0x2516('0x2b'),_0x2516('0x60'),'voicePause',_0x2516('0x61')],'raw':!![]}]})[_0x2516('0x25')](function(_0x24f7d7){if(_0x24f7d7){var _0x23ef83=_[_0x2516('0x62')](_0x24f7d7,function(_0xe93655){var _0x43a2ed=_0xe93655[_0x2516('0x27')]({'plain':!![]});return _0x43a2ed[_0x2516('0x5f')];});return db['SmsQueue'][_0x2516('0x48')]({'where':{'id':_0x320d38['params']['id']}})[_0x2516('0x25')](function(_0x1b860d){return db['sequelize']['transaction'](function(_0x40efc6){return _0x1b860d[_0x2516('0x5e')](_0x351a53,{'transaction':_0x40efc6})[_0x2516('0x25')](function(){return BPromise[_0x2516('0x63')](_0x23ef83,function(_0xa2ff56){return db[_0x2516('0x4f')][_0x2516('0x64')]({'where':{'UserId':_0xa2ff56['id'],'SmsQueueId':_0x320d38[_0x2516('0x47')]['id']},'transaction':_0x40efc6});});})[_0x2516('0x25')](function(){_0x23ef83[_0x2516('0x65')](function(_0x550b19){socket[_0x2516('0x66')](_0x2516('0x67'),{'UserId':_0x550b19['id'],'SmsQueueId':_0x1b860d['id']});});});});});}})[_0x2516('0x25')](respondWithStatusCode(_0x3e1a27,null))[_0x2516('0x46')](handleError(_0x3e1a27,null));};exports['removeTeams']=function(_0x489dec,_0xabb346,_0x3de1cd){return db[_0x2516('0x5c')]['findAll']({'where':{'id':_0x489dec[_0x2516('0x34')][_0x2516('0x68')]},'attributes':['id'],'include':[{'model':db[_0x2516('0x52')],'as':_0x2516('0x5f'),'attributes':['id'],'raw':!![]}]})[_0x2516('0x25')](handleEntityNotFound(_0xabb346,null))[_0x2516('0x25')](function(_0x581c2c){var _0x2e4654=_[_0x2516('0x2e')](_0x581c2c,'id');var _0x2e58b1=[];var _0x38cf65=[];var _0x124371=squel[_0x2516('0x69')]();_0x124371[_0x2516('0x6a')](_0x2516('0x6b'))[_0x2516('0x6c')](_0x2516('0x6d'),'tq')[_0x2516('0x6e')](_0x2516('0x6f'),'ut',_0x2516('0x70'))[_0x2516('0x3d')](_0x2516('0x71'),_0x489dec[_0x2516('0x47')]['id']);for(var _0x4d9432=0x0;_0x4d9432<_0x581c2c['length'];_0x4d9432+=0x1){let _0x2337ee=_0x581c2c[_0x4d9432];for(var _0x471389=0x0;_0x471389<_0x2337ee[_0x2516('0x5f')][_0x2516('0x50')];_0x471389+=0x1){let _0x33da91=_0x2337ee[_0x2516('0x5f')][_0x471389];var _0x46dbff=_0x124371[_0x2516('0x72')]();_0x46dbff['where'](_0x2516('0x73'),_0x33da91['id']);_0x38cf65[_0x2516('0x74')](db[_0x2516('0x75')]['query'](_0x46dbff[_0x2516('0x76')](),{'type':db['sequelize'][_0x2516('0x77')]['SELECT']})[_0x2516('0x25')](function(_0x270aa0){if(_0x270aa0['length']===0x1){return _0x33da91['id'];}else{var _0xd47496=_['every'](_[_0x2516('0x2e')](_0x270aa0,_0x2516('0x78')),function(_0x177106){return _[_0x2516('0x79')](_0x2e4654,_0x177106);});if(_0xd47496){return _0x33da91['id'];}}}));}}return BPromise[_0x2516('0x7a')](_0x38cf65)[_0x2516('0x25')](function(_0x3a8f28){_0x2e58b1=_(_0x2e58b1)[_0x2516('0x7b')](_0x3a8f28)[_0x2516('0x7c')]()['value']();return db[_0x2516('0x2f')][_0x2516('0x48')]({'where':{'id':_0x489dec[_0x2516('0x47')]['id']}})[_0x2516('0x25')](function(_0x52f632){return db[_0x2516('0x75')][_0x2516('0x7d')](function(_0x135ce4){return _0x52f632[_0x2516('0x7e')](_0x489dec[_0x2516('0x34')]['ids'],{'transaction':_0x135ce4})[_0x2516('0x25')](function(){if(!_[_0x2516('0x7f')](_0x2e58b1)){return _0x52f632[_0x2516('0x80')](_0x2e58b1,{'transaction':_0x135ce4});}})[_0x2516('0x25')](function(){_0x2e58b1[_0x2516('0x65')](function(_0x37e50f){socket['emit'](_0x2516('0x81'),{'UserId':_0x37e50f,'SmsQueueId':_0x52f632['id']});});});});});});})['then'](respondWithStatusCode(_0xabb346,null))[_0x2516('0x46')](handleError(_0xabb346,null));};exports['addAgents']=function(_0x5e6f35,_0x37e3a0,_0x10ed89){return db[_0x2516('0x2f')]['find']({'where':{'id':_0x5e6f35[_0x2516('0x47')]['id']}})[_0x2516('0x25')](handleEntityNotFound(_0x37e3a0,null))['then'](function(_0x25b465){if(_0x25b465){return _0x25b465[_0x2516('0x82')](_0x5e6f35['body']['ids'],_[_0x2516('0x83')](_0x5e6f35[_0x2516('0x4d')],[_0x2516('0x68'),'id'])||{})[_0x2516('0x84')](function(_0x4683c1){for(var _0x41f2b2=0x0;_0x41f2b2<_0x5e6f35['body'][_0x2516('0x68')][_0x2516('0x50')];_0x41f2b2+=0x1){socket[_0x2516('0x66')](_0x2516('0x67'),{'UserId':_0x5e6f35['body'][_0x2516('0x68')][_0x41f2b2],'SmsQueueId':_0x5e6f35[_0x2516('0x47')]['id']});}return _0x4683c1;});}})[_0x2516('0x25')](respondWithResult(_0x37e3a0,null))[_0x2516('0x46')](handleError(_0x37e3a0,null));};exports['removeAgents']=function(_0x2395af,_0x107201,_0x3eaf21){return db['SmsQueue'][_0x2516('0x48')]({'where':{'id':_0x2395af[_0x2516('0x47')]['id']}})[_0x2516('0x25')](handleEntityNotFound(_0x107201,null))[_0x2516('0x25')](function(_0x5f3268){if(_0x5f3268){return _0x5f3268[_0x2516('0x80')](_0x2395af[_0x2516('0x34')][_0x2516('0x68')])[_0x2516('0x25')](function(){if(_[_0x2516('0x85')](_0x2395af[_0x2516('0x34')]['ids'])){for(var _0x28daa5=0x0;_0x28daa5<_0x2395af[_0x2516('0x34')][_0x2516('0x68')]['length'];_0x28daa5+=0x1){socket[_0x2516('0x66')](_0x2516('0x81'),{'UserId':Number(_0x2395af['query']['ids'][_0x28daa5]),'SmsQueueId':Number(_0x2395af[_0x2516('0x47')]['id'])});}}else{socket[_0x2516('0x66')](_0x2516('0x81'),{'UserId':Number(_0x2395af[_0x2516('0x34')][_0x2516('0x68')]),'SmsQueueId':Number(_0x2395af[_0x2516('0x47')]['id'])});}});}})[_0x2516('0x25')](respondWithStatusCode(_0x107201,null))['catch'](handleError(_0x107201,null));};exports[_0x2516('0x86')]=function(_0x2d87d5,_0x1354d3,_0x2afcab){var _0x40e25c={};var _0x1e4d50={};var _0x171389;var _0x434d48;return db[_0x2516('0x2f')][_0x2516('0x5b')]({'where':{'id':_0x2d87d5[_0x2516('0x47')]['id']}})[_0x2516('0x25')](handleEntityNotFound(_0x1354d3,null))['then'](function(_0x32c5a7){if(_0x32c5a7){_0x171389=_0x32c5a7;_0x1e4d50[_0x2516('0x32')]=_['keys'](db[_0x2516('0x52')][_0x2516('0x30')]);_0x1e4d50[_0x2516('0x34')]=_[_0x2516('0x33')](_0x2d87d5[_0x2516('0x34')]);_0x1e4d50['filters']=_[_0x2516('0x36')](_0x1e4d50[_0x2516('0x32')],_0x1e4d50['query']);_0x40e25c[_0x2516('0x37')]=_['intersection'](_0x1e4d50['model'],qs[_0x2516('0x38')](_0x2d87d5[_0x2516('0x34')][_0x2516('0x38')]));_0x40e25c['attributes']=_0x40e25c[_0x2516('0x37')][_0x2516('0x50')]?_0x40e25c['attributes']:_0x1e4d50['model'];_0x40e25c[_0x2516('0x3b')]=qs[_0x2516('0x3c')](_0x2d87d5[_0x2516('0x34')][_0x2516('0x3c')]);_0x40e25c[_0x2516('0x3d')]=qs[_0x2516('0x35')](_[_0x2516('0x87')](_0x2d87d5[_0x2516('0x34')],_0x1e4d50[_0x2516('0x35')]));if(_0x2d87d5['query'][_0x2516('0x3e')]){_0x40e25c[_0x2516('0x3d')]=_[_0x2516('0x3f')](_0x40e25c[_0x2516('0x3d')],{'$or':_[_0x2516('0x2e')](_0x40e25c[_0x2516('0x37')],function(_0x5dd88d){var _0x29dbe6={};_0x29dbe6[_0x5dd88d]={'$like':'%'+_0x2d87d5[_0x2516('0x34')][_0x2516('0x3e')]+'%'};return _0x29dbe6;})});}_0x40e25c=_[_0x2516('0x3f')]({},_0x40e25c,_0x2d87d5[_0x2516('0x41')]);return _0x171389[_0x2516('0x86')](_0x40e25c);}})[_0x2516('0x25')](function(_0x7c5589){if(_0x7c5589){_0x434d48=_0x7c5589[_0x2516('0x50')];if(!_0x2d87d5[_0x2516('0x34')][_0x2516('0x39')](_0x2516('0x3a'))){_0x40e25c[_0x2516('0x20')]=qs['limit'](_0x2d87d5[_0x2516('0x34')][_0x2516('0x20')]);_0x40e25c['offset']=qs['offset'](_0x2d87d5[_0x2516('0x34')][_0x2516('0x1f')]);}return _0x171389[_0x2516('0x86')](_0x40e25c);}})[_0x2516('0x25')](function(_0x132174){if(_0x132174){return _0x132174?{'count':_0x434d48,'rows':_0x132174}:null;}})['then'](respondWithResult(_0x1354d3,null))[_0x2516('0x46')](handleError(_0x1354d3,null));};