7c8ebb74a5ae1f1752a2bc98269730b2a442c059
[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 _0xe908=['findAll','rows','show','params','includeAll','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','autoAssociation','UserProfileResource','catch','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','describe','getMembers','findOne','order','pick','User','UserId','agent','smsPause','updatedAt','createdAt','format','%s/%s','SIP','getTeams','Team','addTeams','ids','Agents','online','voicePause','interface','flatMap','sequelize','transaction','each','UserSmsQueue','forEach','userSmsQueue:save','select','field','tq.TeamId','from','team_has_sms_queues','SmsQueueId\x20=\x20?','ut.UserId\x20=\x20?','push','toString','QueryTypes','SELECT','every','TeamId','all','compact','removeTeams','isEmpty','removeAgents','addAgents','omit','spread','userSmsQueue:remove','emit','getAgents','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','util','path','sox','to-csv','squel','crypto','jsforce','querystring','papaparse','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','defaults','redis','localhost','./smsQueue.socket','register','end','status','offset','limit','json','apply','reject','save','update','get','SmsQueues','sendStatus','error','name','map','SmsQueue','rawAttributes','fieldName','type','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','sort','where','filter','merge','VIRTUAL','options','count','then','include'];(function(_0x51ec0e,_0x9b693c){var _0x4667bd=function(_0x44b830){while(--_0x44b830){_0x51ec0e['push'](_0x51ec0e['shift']());}};_0x4667bd(++_0x9b693c);}(_0xe908,0xd1));var _0x8e90=function(_0xdea41a,_0x552987){_0xdea41a=_0xdea41a-0x0;var _0x15d0d8=_0xe908[_0xdea41a];return _0x15d0d8;};'use strict';var pdf=require(_0x8e90('0x0'));var emlformat=require(_0x8e90('0x1'));var rimraf=require(_0x8e90('0x2'));var zipdir=require(_0x8e90('0x3'));var jsonpatch=require(_0x8e90('0x4'));var rp=require('request-promise');var moment=require(_0x8e90('0x5'));var BPromise=require(_0x8e90('0x6'));var Mustache=require(_0x8e90('0x7'));var util=require(_0x8e90('0x8'));var path=require(_0x8e90('0x9'));var sox=require(_0x8e90('0xa'));var csv=require(_0x8e90('0xb'));var ejs=require('ejs');var fs=require('fs');var _=require('lodash');var squel=require(_0x8e90('0xc'));var crypto=require(_0x8e90('0xd'));var jsforce=require(_0x8e90('0xe'));var deskjs=require('desk.js');var toCsv=require(_0x8e90('0xb'));var querystring=require(_0x8e90('0xf'));var Papa=require(_0x8e90('0x10'));var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require(_0x8e90('0x11'));var as=require(_0x8e90('0x12'));var hardwareService=require(_0x8e90('0x13'));var logger=require(_0x8e90('0x14'))(_0x8e90('0x15'));var utils=require(_0x8e90('0x16'));var config=require(_0x8e90('0x17'));var db=require(_0x8e90('0x18'))['db'];config['redis']=_[_0x8e90('0x19')](config[_0x8e90('0x1a')],{'host':_0x8e90('0x1b'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0x8e90('0x1a')]));require(_0x8e90('0x1c'))[_0x8e90('0x1d')](socket);function respondWithStatusCode(_0x2c1230,_0x39c386){_0x39c386=_0x39c386||0xcc;return function(_0x282cc4){if(_0x282cc4){return _0x2c1230['sendStatus'](_0x39c386);}return _0x2c1230['status'](_0x39c386)[_0x8e90('0x1e')]();};}function respondWithResult(_0x390709,_0x189b8d){_0x189b8d=_0x189b8d||0xc8;return function(_0x1d9f77){if(_0x1d9f77){return _0x390709[_0x8e90('0x1f')](_0x189b8d)['json'](_0x1d9f77);}};}function respondWithFilteredResult(_0x5bb635,_0x2df290){return function(_0x2d33cd){if(_0x2d33cd){var _0x1e5a08=_0x2d33cd['count'],_0x23fefb=_0x2df290[_0x8e90('0x20')],_0x3c47a0=_0x2df290[_0x8e90('0x20')]+_0x2df290[_0x8e90('0x21')],_0x4c5fb5;if(_0x3c47a0>=_0x1e5a08){_0x3c47a0=_0x1e5a08;_0x4c5fb5=0xc8;}else{_0x4c5fb5=0xce;}_0x5bb635['status'](_0x4c5fb5);return _0x5bb635['set']('Content-Range',_0x23fefb+'-'+_0x3c47a0+'/'+_0x1e5a08)[_0x8e90('0x22')](_0x2d33cd);}return null;};}function patchUpdates(_0x4939cd){return function(_0x5cef0d){try{jsonpatch[_0x8e90('0x23')](_0x5cef0d,_0x4939cd,!![]);}catch(_0x5de809){return BPromise[_0x8e90('0x24')](_0x5de809);}return _0x5cef0d[_0x8e90('0x25')]();};}function saveUpdates(_0x30739a,_0x59b8d3){return function(_0x2fc1e6){if(_0x2fc1e6){return _0x2fc1e6[_0x8e90('0x26')](_0x30739a)['then'](function(_0x372cfa){return _0x372cfa;});}return null;};}function removeEntity(_0x527817,_0x13e063){return function(_0x21330b){if(_0x21330b){return _0x21330b['destroy']()['then'](function(){var _0x6ca93=_0x21330b[_0x8e90('0x27')]({'plain':!![]});var _0x20a05f=_0x8e90('0x28');return db['UserProfileResource']['destroy']({'where':{'type':_0x20a05f,'resourceId':_0x6ca93['id']}})['then'](function(){return _0x21330b;});})['then'](function(){_0x527817['status'](0xcc)[_0x8e90('0x1e')]();});}};}function handleEntityNotFound(_0x54a7ca,_0x1cb260){return function(_0x324850){if(!_0x324850){_0x54a7ca[_0x8e90('0x29')](0x194);}return _0x324850;};}function handleError(_0x4111cf,_0x4f5bde){_0x4f5bde=_0x4f5bde||0x1f4;return function(_0x5b662f){logger[_0x8e90('0x2a')](_0x5b662f['stack']);if(_0x5b662f[_0x8e90('0x2b')]){delete _0x5b662f[_0x8e90('0x2b')];}_0x4111cf[_0x8e90('0x1f')](_0x4f5bde)['send'](_0x5b662f);};}exports['index']=function(_0x50d407,_0x41da5b){var _0x2965c8={},_0x5f0576={},_0x10eb2e={'count':0x0,'rows':[]};var _0x3820ac=_[_0x8e90('0x2c')](db[_0x8e90('0x2d')][_0x8e90('0x2e')],function(_0x2ea9c5){return{'name':_0x2ea9c5[_0x8e90('0x2f')],'type':_0x2ea9c5[_0x8e90('0x30')][_0x8e90('0x31')]};});_0x5f0576[_0x8e90('0x32')]=_[_0x8e90('0x2c')](_0x3820ac,_0x8e90('0x2b'));_0x5f0576[_0x8e90('0x33')]=_[_0x8e90('0x34')](_0x50d407[_0x8e90('0x33')]);_0x5f0576[_0x8e90('0x35')]=_[_0x8e90('0x36')](_0x5f0576[_0x8e90('0x32')],_0x5f0576[_0x8e90('0x33')]);_0x2965c8[_0x8e90('0x37')]=_['intersection'](_0x5f0576['model'],qs[_0x8e90('0x38')](_0x50d407['query'][_0x8e90('0x38')]));_0x2965c8[_0x8e90('0x37')]=_0x2965c8[_0x8e90('0x37')][_0x8e90('0x39')]?_0x2965c8['attributes']:_0x5f0576[_0x8e90('0x32')];if(!_0x50d407['query'][_0x8e90('0x3a')](_0x8e90('0x3b'))){_0x2965c8[_0x8e90('0x21')]=qs[_0x8e90('0x21')](_0x50d407[_0x8e90('0x33')][_0x8e90('0x21')]);_0x2965c8[_0x8e90('0x20')]=qs[_0x8e90('0x20')](_0x50d407[_0x8e90('0x33')][_0x8e90('0x20')]);}_0x2965c8['order']=qs[_0x8e90('0x3c')](_0x50d407[_0x8e90('0x33')]['sort']);_0x2965c8[_0x8e90('0x3d')]=qs[_0x8e90('0x35')](_['pick'](_0x50d407[_0x8e90('0x33')],_0x5f0576[_0x8e90('0x35')]),_0x3820ac);if(_0x50d407[_0x8e90('0x33')][_0x8e90('0x3e')]){_0x2965c8[_0x8e90('0x3d')]=_[_0x8e90('0x3f')](_0x2965c8[_0x8e90('0x3d')],{'$or':_[_0x8e90('0x2c')](_0x3820ac,function(_0x3ad78b){if(_0x3ad78b['type']!==_0x8e90('0x40')){var _0x5b7a3b={};_0x5b7a3b[_0x3ad78b[_0x8e90('0x2b')]]={'$like':'%'+_0x50d407[_0x8e90('0x33')][_0x8e90('0x3e')]+'%'};return _0x5b7a3b;}})});}_0x2965c8=_[_0x8e90('0x3f')]({},_0x2965c8,_0x50d407[_0x8e90('0x41')]);var _0x9821c5={'where':_0x2965c8['where']};return db[_0x8e90('0x2d')][_0x8e90('0x42')](_0x9821c5)[_0x8e90('0x43')](function(_0x380f88){_0x10eb2e[_0x8e90('0x42')]=_0x380f88;if(_0x50d407[_0x8e90('0x33')]['includeAll']){_0x2965c8[_0x8e90('0x44')]=[{'all':!![]}];}return db[_0x8e90('0x2d')][_0x8e90('0x45')](_0x2965c8);})[_0x8e90('0x43')](function(_0x1faef5){_0x10eb2e[_0x8e90('0x46')]=_0x1faef5;return _0x10eb2e;})[_0x8e90('0x43')](respondWithFilteredResult(_0x41da5b,_0x2965c8))['catch'](handleError(_0x41da5b,null));};exports[_0x8e90('0x47')]=function(_0x4d3919,_0x59071d){var _0xba1d96={'raw':!![],'where':{'id':_0x4d3919[_0x8e90('0x48')]['id']}},_0x216627={};_0x216627[_0x8e90('0x32')]=_[_0x8e90('0x34')](db[_0x8e90('0x2d')][_0x8e90('0x2e')]);_0x216627[_0x8e90('0x33')]=_[_0x8e90('0x34')](_0x4d3919[_0x8e90('0x33')]);_0x216627[_0x8e90('0x35')]=_['intersection'](_0x216627['model'],_0x216627['query']);_0xba1d96[_0x8e90('0x37')]=_[_0x8e90('0x36')](_0x216627[_0x8e90('0x32')],qs[_0x8e90('0x38')](_0x4d3919[_0x8e90('0x33')][_0x8e90('0x38')]));_0xba1d96['attributes']=_0xba1d96[_0x8e90('0x37')][_0x8e90('0x39')]?_0xba1d96[_0x8e90('0x37')]:_0x216627['model'];if(_0x4d3919['query'][_0x8e90('0x49')]){_0xba1d96[_0x8e90('0x44')]=[{'all':!![]}];}_0xba1d96=_[_0x8e90('0x3f')]({},_0xba1d96,_0x4d3919[_0x8e90('0x41')]);return db[_0x8e90('0x2d')][_0x8e90('0x4a')](_0xba1d96)[_0x8e90('0x43')](handleEntityNotFound(_0x59071d,null))['then'](respondWithResult(_0x59071d,null))['catch'](handleError(_0x59071d,null));};exports[_0x8e90('0x4b')]=function(_0xaa568,_0x494bac){return db[_0x8e90('0x2d')][_0x8e90('0x4b')](_0xaa568[_0x8e90('0x4c')],{})[_0x8e90('0x43')](function(_0x440168){var _0x479834=_0xaa568[_0x8e90('0x4d')][_0x8e90('0x27')]({'plain':!![]});if(!_0x479834)throw new Error(_0x8e90('0x4e'));if(_0x479834[_0x8e90('0x4f')]==='user'){var _0x31f93e=_0x440168[_0x8e90('0x27')]({'plain':!![]});var _0x329778=_0x8e90('0x28');return db[_0x8e90('0x50')][_0x8e90('0x4a')]({'where':{'name':_0x329778,'userProfileId':_0x479834[_0x8e90('0x51')]},'raw':!![]})['then'](function(_0x5d93fe){if(_0x5d93fe&&_0x5d93fe[_0x8e90('0x52')]===0x0){return db[_0x8e90('0x53')][_0x8e90('0x4b')]({'name':_0x31f93e['name'],'resourceId':_0x31f93e['id'],'type':_0x5d93fe['name'],'sectionId':_0x5d93fe['id']},{})[_0x8e90('0x43')](function(){return _0x440168;});}else{return _0x440168;}})[_0x8e90('0x54')](function(_0x3308be){logger[_0x8e90('0x2a')](_0x8e90('0x55'),_0x3308be);throw _0x3308be;});}return _0x440168;})[_0x8e90('0x43')](respondWithResult(_0x494bac,0xc9))[_0x8e90('0x54')](handleError(_0x494bac,null));};exports[_0x8e90('0x26')]=function(_0x5868ce,_0x2786e3){if(_0x5868ce[_0x8e90('0x4c')]['id']){delete _0x5868ce[_0x8e90('0x4c')]['id'];}return db['SmsQueue'][_0x8e90('0x4a')]({'where':{'id':_0x5868ce[_0x8e90('0x48')]['id']}})['then'](handleEntityNotFound(_0x2786e3,null))[_0x8e90('0x43')](saveUpdates(_0x5868ce[_0x8e90('0x4c')],null))['then'](respondWithResult(_0x2786e3,null))[_0x8e90('0x54')](handleError(_0x2786e3,null));};exports['destroy']=function(_0x153d46,_0xe390f7){return db[_0x8e90('0x2d')][_0x8e90('0x4a')]({'where':{'id':_0x153d46[_0x8e90('0x48')]['id']}})[_0x8e90('0x43')](handleEntityNotFound(_0xe390f7,null))[_0x8e90('0x43')](removeEntity(_0xe390f7,null))[_0x8e90('0x54')](handleError(_0xe390f7,null));};exports[_0x8e90('0x56')]=function(_0x539757,_0x561ce3){return db[_0x8e90('0x2d')][_0x8e90('0x56')]()[_0x8e90('0x43')](respondWithResult(_0x561ce3,null))['catch'](handleError(_0x561ce3,null));};exports[_0x8e90('0x57')]=function(_0x4761c6,_0x11f33d,_0x17ebf2){var _0x1305d7={'raw':!![],'where':{}},_0x2705f8={},_0x300220;return db['SmsQueue'][_0x8e90('0x58')]({'where':{'id':_0x4761c6[_0x8e90('0x48')]['id']}})[_0x8e90('0x43')](handleEntityNotFound(_0x11f33d,null))['then'](function(_0x522351){if(_0x522351){_0x300220=_0x522351[_0x8e90('0x27')]({'plain':!![]});_0x2705f8['model']=_[_0x8e90('0x34')](db['UserSmsQueue'][_0x8e90('0x2e')]);_0x2705f8[_0x8e90('0x33')]=_[_0x8e90('0x34')](_0x4761c6[_0x8e90('0x33')]);_0x2705f8[_0x8e90('0x35')]=_[_0x8e90('0x36')](_0x2705f8[_0x8e90('0x32')],_0x2705f8[_0x8e90('0x33')]);_0x1305d7['attributes']=_['intersection'](_0x2705f8[_0x8e90('0x32')],qs[_0x8e90('0x38')](_0x4761c6['query'][_0x8e90('0x38')]));_0x1305d7[_0x8e90('0x37')]=_0x1305d7['attributes']['length']?_0x1305d7[_0x8e90('0x37')]:_0x2705f8[_0x8e90('0x32')];if(!_0x4761c6[_0x8e90('0x33')][_0x8e90('0x3a')]('nolimit')){_0x1305d7['limit']=qs[_0x8e90('0x21')](_0x4761c6[_0x8e90('0x33')][_0x8e90('0x21')]);_0x1305d7['offset']=qs[_0x8e90('0x20')](_0x4761c6[_0x8e90('0x33')][_0x8e90('0x20')]);}_0x1305d7[_0x8e90('0x59')]=qs[_0x8e90('0x3c')](_0x4761c6[_0x8e90('0x33')][_0x8e90('0x3c')]);_0x1305d7[_0x8e90('0x3d')]=qs[_0x8e90('0x35')](_[_0x8e90('0x5a')](_0x4761c6[_0x8e90('0x33')],_0x2705f8[_0x8e90('0x35')]));_0x1305d7[_0x8e90('0x3d')]['SmsQueueId']=_0x522351['id'];if(_0x4761c6[_0x8e90('0x33')][_0x8e90('0x3e')]){_0x1305d7[_0x8e90('0x3d')]=_[_0x8e90('0x3f')](_0x1305d7[_0x8e90('0x3d')],{'$or':_[_0x8e90('0x2c')](_0x1305d7[_0x8e90('0x37')],function(_0x2b64f5){var _0x20598c={};_0x20598c[_0x2b64f5]={'$like':'%'+_0x4761c6[_0x8e90('0x33')][_0x8e90('0x3e')]+'%'};return _0x20598c;})});}_0x1305d7=_[_0x8e90('0x3f')]({},_0x1305d7,_0x4761c6[_0x8e90('0x41')]);return db['UserSmsQueue'][_0x8e90('0x45')](_0x1305d7);}})[_0x8e90('0x43')](function(_0x5bb1e4){if(_0x5bb1e4){return db[_0x8e90('0x5b')]['findAndCountAll']({'where':{'id':_[_0x8e90('0x2c')](_0x5bb1e4,_0x8e90('0x5c')),'role':_0x8e90('0x5d')},'attributes':['id',_0x8e90('0x2b'),_0x8e90('0x5e'),_0x8e90('0x5f'),_0x8e90('0x60')]});}})[_0x8e90('0x43')](function(_0x3ec924){if(_0x3ec924){return{'count':_0x3ec924[_0x8e90('0x42')],'rows':_['map'](_0x3ec924[_0x8e90('0x46')],function(_0x51b977){return{'membername':_0x51b977[_0x8e90('0x2b')],'UserId':_0x51b977['id'],'queue_name':_0x300220['name'],'SmsQueueId':_0x300220['id'],'interface':util[_0x8e90('0x61')](_0x8e90('0x62'),_0x8e90('0x63'),_0x51b977[_0x8e90('0x2b')]),'penalty':0x0,'paused':_0x51b977[_0x8e90('0x5e')],'createdAt':_0x51b977['createdAt'],'updatedAt':_0x51b977['updatedAt']};})};}else{return{'count':0x0,'rows':[]};}})[_0x8e90('0x43')](respondWithFilteredResult(_0x11f33d,_0x1305d7))['catch'](handleError(_0x11f33d,null));};exports[_0x8e90('0x64')]=function(_0x26972c,_0xaa1c91,_0x439612){var _0x257d99={};var _0x14213a={};var _0x3c2d86;var _0x48a53c;return db[_0x8e90('0x2d')][_0x8e90('0x58')]({'where':{'id':_0x26972c[_0x8e90('0x48')]['id']}})[_0x8e90('0x43')](handleEntityNotFound(_0xaa1c91,null))[_0x8e90('0x43')](function(_0x2c92e6){if(_0x2c92e6){_0x3c2d86=_0x2c92e6;_0x14213a[_0x8e90('0x32')]=_[_0x8e90('0x34')](db[_0x8e90('0x65')]['rawAttributes']);_0x14213a['query']=_[_0x8e90('0x34')](_0x26972c['query']);_0x14213a[_0x8e90('0x35')]=_[_0x8e90('0x36')](_0x14213a[_0x8e90('0x32')],_0x14213a[_0x8e90('0x33')]);_0x257d99['attributes']=_['intersection'](_0x14213a['model'],qs[_0x8e90('0x38')](_0x26972c[_0x8e90('0x33')][_0x8e90('0x38')]));_0x257d99[_0x8e90('0x37')]=_0x257d99[_0x8e90('0x37')][_0x8e90('0x39')]?_0x257d99[_0x8e90('0x37')]:_0x14213a[_0x8e90('0x32')];_0x257d99['order']=qs[_0x8e90('0x3c')](_0x26972c[_0x8e90('0x33')][_0x8e90('0x3c')]);_0x257d99[_0x8e90('0x3d')]=qs[_0x8e90('0x35')](_[_0x8e90('0x5a')](_0x26972c[_0x8e90('0x33')],_0x14213a['filters']));if(_0x26972c[_0x8e90('0x33')][_0x8e90('0x3e')]){_0x257d99[_0x8e90('0x3d')]=_[_0x8e90('0x3f')](_0x257d99[_0x8e90('0x3d')],{'$or':_['map'](_0x257d99['attributes'],function(_0x1fba44){var _0x2dd316={};_0x2dd316[_0x1fba44]={'$like':'%'+_0x26972c[_0x8e90('0x33')][_0x8e90('0x3e')]+'%'};return _0x2dd316;})});}_0x257d99=_[_0x8e90('0x3f')]({},_0x257d99,_0x26972c[_0x8e90('0x41')]);return _0x3c2d86['getTeams'](_0x257d99);}})[_0x8e90('0x43')](function(_0x435b6c){if(_0x435b6c){_0x48a53c=_0x435b6c['length'];if(!_0x26972c[_0x8e90('0x33')][_0x8e90('0x3a')](_0x8e90('0x3b'))){_0x257d99['limit']=qs[_0x8e90('0x21')](_0x26972c[_0x8e90('0x33')][_0x8e90('0x21')]);_0x257d99[_0x8e90('0x20')]=qs[_0x8e90('0x20')](_0x26972c[_0x8e90('0x33')][_0x8e90('0x20')]);}return _0x3c2d86[_0x8e90('0x64')](_0x257d99);}})[_0x8e90('0x43')](function(_0x37bf3e){if(_0x37bf3e){return _0x37bf3e?{'count':_0x48a53c,'rows':_0x37bf3e}:null;}})[_0x8e90('0x43')](respondWithResult(_0xaa1c91,null))[_0x8e90('0x54')](handleError(_0xaa1c91,null));};exports[_0x8e90('0x66')]=function(_0x402f23,_0x23bda8,_0x2098ff){var _0x197344=_0x402f23[_0x8e90('0x4c')][_0x8e90('0x67')];return db[_0x8e90('0x65')][_0x8e90('0x45')]({'where':{'id':_0x197344},'attributes':['id'],'include':[{'model':db['User'],'as':_0x8e90('0x68'),'attributes':['id',_0x8e90('0x2b'),_0x8e90('0x69'),_0x8e90('0x6a'),_0x8e90('0x6b')],'raw':!![]}]})['then'](function(_0x562171){if(_0x562171){var _0x252c50=_[_0x8e90('0x6c')](_0x562171,function(_0x248d17){var _0x4a591a=_0x248d17['get']({'plain':!![]});return _0x4a591a[_0x8e90('0x68')];});return db['SmsQueue'][_0x8e90('0x4a')]({'where':{'id':_0x402f23[_0x8e90('0x48')]['id']}})[_0x8e90('0x43')](function(_0x56718c){return db[_0x8e90('0x6d')][_0x8e90('0x6e')](function(_0xdb0eed){return _0x56718c[_0x8e90('0x66')](_0x197344,{'transaction':_0xdb0eed})['then'](function(){return BPromise[_0x8e90('0x6f')](_0x252c50,function(_0x4520f8){return db[_0x8e90('0x70')]['findOrCreate']({'where':{'UserId':_0x4520f8['id'],'SmsQueueId':_0x402f23[_0x8e90('0x48')]['id']},'transaction':_0xdb0eed});});})[_0x8e90('0x43')](function(){_0x252c50[_0x8e90('0x71')](function(_0x37d348){socket['emit'](_0x8e90('0x72'),{'UserId':_0x37d348['id'],'SmsQueueId':_0x56718c['id']});});});});});}})[_0x8e90('0x43')](respondWithStatusCode(_0x23bda8,null))[_0x8e90('0x54')](handleError(_0x23bda8,null));};exports['removeTeams']=function(_0x352f9c,_0x3d4aff,_0x195c80){return db[_0x8e90('0x65')][_0x8e90('0x45')]({'where':{'id':_0x352f9c[_0x8e90('0x33')]['ids']},'attributes':['id'],'include':[{'model':db[_0x8e90('0x5b')],'as':'Agents','attributes':['id'],'raw':!![]}]})[_0x8e90('0x43')](handleEntityNotFound(_0x3d4aff,null))[_0x8e90('0x43')](function(_0x22e7d2){var _0x313707=_[_0x8e90('0x2c')](_0x22e7d2,'id');var _0x1abf76=[];var _0x4fd87f=[];var _0x5a7836=squel[_0x8e90('0x73')]();_0x5a7836[_0x8e90('0x74')](_0x8e90('0x75'))[_0x8e90('0x76')](_0x8e90('0x77'),'tq')['join']('user_has_teams','ut','ut.TeamId\x20=\x20tq.TeamId')['where'](_0x8e90('0x78'),_0x352f9c[_0x8e90('0x48')]['id']);for(var _0x54d93f=0x0;_0x54d93f<_0x22e7d2['length'];_0x54d93f+=0x1){let _0x36a204=_0x22e7d2[_0x54d93f];for(var _0x2817d9=0x0;_0x2817d9<_0x36a204['Agents'][_0x8e90('0x39')];_0x2817d9+=0x1){let _0x2efe2e=_0x36a204[_0x8e90('0x68')][_0x2817d9];var _0x16fb60=_0x5a7836['clone']();_0x16fb60[_0x8e90('0x3d')](_0x8e90('0x79'),_0x2efe2e['id']);_0x4fd87f[_0x8e90('0x7a')](db[_0x8e90('0x6d')]['query'](_0x16fb60[_0x8e90('0x7b')](),{'type':db[_0x8e90('0x6d')][_0x8e90('0x7c')][_0x8e90('0x7d')]})[_0x8e90('0x43')](function(_0x559e40){if(_0x559e40[_0x8e90('0x39')]===0x1){return _0x2efe2e['id'];}else{var _0x911a11=_[_0x8e90('0x7e')](_[_0x8e90('0x2c')](_0x559e40,_0x8e90('0x7f')),function(_0x3d49d4){return _['includes'](_0x313707,_0x3d49d4);});if(_0x911a11){return _0x2efe2e['id'];}}}));}}return BPromise[_0x8e90('0x80')](_0x4fd87f)[_0x8e90('0x43')](function(_0x2a3275){_0x1abf76=_(_0x1abf76)['union'](_0x2a3275)[_0x8e90('0x81')]()['value']();return db[_0x8e90('0x2d')]['find']({'where':{'id':_0x352f9c[_0x8e90('0x48')]['id']}})[_0x8e90('0x43')](function(_0x317f08){return db[_0x8e90('0x6d')][_0x8e90('0x6e')](function(_0x1df03c){return _0x317f08[_0x8e90('0x82')](_0x352f9c[_0x8e90('0x33')]['ids'],{'transaction':_0x1df03c})[_0x8e90('0x43')](function(){if(!_[_0x8e90('0x83')](_0x1abf76)){return _0x317f08[_0x8e90('0x84')](_0x1abf76,{'transaction':_0x1df03c});}})[_0x8e90('0x43')](function(){_0x1abf76[_0x8e90('0x71')](function(_0x25dde4){socket['emit']('userSmsQueue:remove',{'UserId':_0x25dde4,'SmsQueueId':_0x317f08['id']});});});});});});})[_0x8e90('0x43')](respondWithStatusCode(_0x3d4aff,null))[_0x8e90('0x54')](handleError(_0x3d4aff,null));};exports[_0x8e90('0x85')]=function(_0x1bb33e,_0x43d908,_0x27d9a0){return db[_0x8e90('0x2d')][_0x8e90('0x4a')]({'where':{'id':_0x1bb33e['params']['id']}})['then'](handleEntityNotFound(_0x43d908,null))['then'](function(_0x126af8){if(_0x126af8){return _0x126af8[_0x8e90('0x85')](_0x1bb33e[_0x8e90('0x4c')][_0x8e90('0x67')],_[_0x8e90('0x86')](_0x1bb33e[_0x8e90('0x4c')],[_0x8e90('0x67'),'id'])||{})[_0x8e90('0x87')](function(_0x572d38){for(var _0x2a1f4e=0x0;_0x2a1f4e<_0x1bb33e[_0x8e90('0x4c')]['ids'][_0x8e90('0x39')];_0x2a1f4e+=0x1){socket['emit'](_0x8e90('0x72'),{'UserId':_0x1bb33e[_0x8e90('0x4c')][_0x8e90('0x67')][_0x2a1f4e],'SmsQueueId':_0x1bb33e[_0x8e90('0x48')]['id']});}return _0x572d38;});}})[_0x8e90('0x43')](respondWithResult(_0x43d908,null))[_0x8e90('0x54')](handleError(_0x43d908,null));};exports[_0x8e90('0x84')]=function(_0x3e52db,_0x1b2744,_0x2673f5){return db[_0x8e90('0x2d')][_0x8e90('0x4a')]({'where':{'id':_0x3e52db[_0x8e90('0x48')]['id']}})[_0x8e90('0x43')](handleEntityNotFound(_0x1b2744,null))[_0x8e90('0x43')](function(_0x260ddf){if(_0x260ddf){return _0x260ddf['removeAgents'](_0x3e52db[_0x8e90('0x33')][_0x8e90('0x67')])[_0x8e90('0x43')](function(){if(_['isArray'](_0x3e52db[_0x8e90('0x33')][_0x8e90('0x67')])){for(var _0x233e1a=0x0;_0x233e1a<_0x3e52db['query'][_0x8e90('0x67')][_0x8e90('0x39')];_0x233e1a+=0x1){socket['emit'](_0x8e90('0x88'),{'UserId':Number(_0x3e52db[_0x8e90('0x33')]['ids'][_0x233e1a]),'SmsQueueId':Number(_0x3e52db[_0x8e90('0x48')]['id'])});}}else{socket[_0x8e90('0x89')](_0x8e90('0x88'),{'UserId':Number(_0x3e52db[_0x8e90('0x33')][_0x8e90('0x67')]),'SmsQueueId':Number(_0x3e52db[_0x8e90('0x48')]['id'])});}});}})[_0x8e90('0x43')](respondWithStatusCode(_0x1b2744,null))[_0x8e90('0x54')](handleError(_0x1b2744,null));};exports[_0x8e90('0x8a')]=function(_0x5abd49,_0x1c7c1c,_0x57de10){var _0x52e91f={};var _0xaf025={};var _0x27d7a5;var _0xc93b35;return db[_0x8e90('0x2d')]['findOne']({'where':{'id':_0x5abd49[_0x8e90('0x48')]['id']}})[_0x8e90('0x43')](handleEntityNotFound(_0x1c7c1c,null))[_0x8e90('0x43')](function(_0x3ef172){if(_0x3ef172){_0x27d7a5=_0x3ef172;_0xaf025[_0x8e90('0x32')]=_[_0x8e90('0x34')](db[_0x8e90('0x5b')][_0x8e90('0x2e')]);_0xaf025[_0x8e90('0x33')]=_['keys'](_0x5abd49[_0x8e90('0x33')]);_0xaf025[_0x8e90('0x35')]=_[_0x8e90('0x36')](_0xaf025[_0x8e90('0x32')],_0xaf025[_0x8e90('0x33')]);_0x52e91f[_0x8e90('0x37')]=_[_0x8e90('0x36')](_0xaf025['model'],qs[_0x8e90('0x38')](_0x5abd49[_0x8e90('0x33')][_0x8e90('0x38')]));_0x52e91f[_0x8e90('0x37')]=_0x52e91f[_0x8e90('0x37')][_0x8e90('0x39')]?_0x52e91f[_0x8e90('0x37')]:_0xaf025['model'];_0x52e91f[_0x8e90('0x59')]=qs[_0x8e90('0x3c')](_0x5abd49['query'][_0x8e90('0x3c')]);_0x52e91f['where']=qs['filters'](_['pick'](_0x5abd49['query'],_0xaf025['filters']));if(_0x5abd49[_0x8e90('0x33')]['filter']){_0x52e91f[_0x8e90('0x3d')]=_[_0x8e90('0x3f')](_0x52e91f[_0x8e90('0x3d')],{'$or':_[_0x8e90('0x2c')](_0x52e91f[_0x8e90('0x37')],function(_0x66baad){var _0x2058e2={};_0x2058e2[_0x66baad]={'$like':'%'+_0x5abd49['query']['filter']+'%'};return _0x2058e2;})});}_0x52e91f=_[_0x8e90('0x3f')]({},_0x52e91f,_0x5abd49[_0x8e90('0x41')]);return _0x27d7a5[_0x8e90('0x8a')](_0x52e91f);}})[_0x8e90('0x43')](function(_0x49a897){if(_0x49a897){_0xc93b35=_0x49a897[_0x8e90('0x39')];if(!_0x5abd49[_0x8e90('0x33')][_0x8e90('0x3a')](_0x8e90('0x3b'))){_0x52e91f[_0x8e90('0x21')]=qs[_0x8e90('0x21')](_0x5abd49[_0x8e90('0x33')][_0x8e90('0x21')]);_0x52e91f['offset']=qs['offset'](_0x5abd49['query'][_0x8e90('0x20')]);}return _0x27d7a5[_0x8e90('0x8a')](_0x52e91f);}})['then'](function(_0x3f6945){if(_0x3f6945){return _0x3f6945?{'count':_0xc93b35,'rows':_0x3f6945}:null;}})['then'](respondWithResult(_0x1c7c1c,null))[_0x8e90('0x54')](handleError(_0x1c7c1c,null));};