Built motion from commit ddca4d0d.|2.5.47
[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 _0x8887=['value','transaction','removeTeams','isEmpty','removeAgents','userSmsQueue:remove','addAgents','omit','spread','getAgents','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','squel','crypto','jsforce','desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/license/util','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./smsQueue.socket','sendStatus','status','json','offset','undefined','count','limit','set','Content-Range','apply','reject','save','then','get','UserProfileResource','destroy','end','stack','name','send','index','SmsQueue','rawAttributes','type','model','map','query','filters','intersection','fields','attributes','length','hasOwnProperty','nolimit','sort','where','pick','filter','merge','options','includeAll','include','rows','catch','params','keys','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','SmsQueues','userProfileId','autoAssociation','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','describe','getMembers','UserSmsQueue','order','SmsQueueId','findAll','User','findAndCountAll','UserId','agent','smsPause','updatedAt','createdAt','format','%s/%s','SIP','getTeams','findOne','addTeams','ids','Team','Agents','online','voicePause','interface','flatMap','sequelize','each','findOrCreate','forEach','emit','userSmsQueue:save','select','field','tq.TeamId','from','team_has_sms_queues','user_has_teams','ut.TeamId\x20=\x20tq.TeamId','SmsQueueId\x20=\x20?','clone','ut.UserId\x20=\x20?','toString','SELECT','every','TeamId','includes','all','compact'];(function(_0x312900,_0x503577){var _0x4036a3=function(_0x203937){while(--_0x203937){_0x312900['push'](_0x312900['shift']());}};_0x4036a3(++_0x503577);}(_0x8887,0x1c6));var _0x7888=function(_0xf79687,_0x5e4a44){_0xf79687=_0xf79687-0x0;var _0x53895e=_0x8887[_0xf79687];return _0x53895e;};'use strict';var emlformat=require(_0x7888('0x0'));var rimraf=require(_0x7888('0x1'));var zipdir=require(_0x7888('0x2'));var jsonpatch=require(_0x7888('0x3'));var rp=require('request-promise');var moment=require(_0x7888('0x4'));var BPromise=require(_0x7888('0x5'));var Mustache=require(_0x7888('0x6'));var util=require(_0x7888('0x7'));var path=require(_0x7888('0x8'));var sox=require(_0x7888('0x9'));var csv=require(_0x7888('0xa'));var ejs=require(_0x7888('0xb'));var fs=require('fs');var fs_extra=require(_0x7888('0xc'));var _=require('lodash');var squel=require(_0x7888('0xd'));var crypto=require(_0x7888('0xe'));var jsforce=require(_0x7888('0xf'));var deskjs=require(_0x7888('0x10'));var toCsv=require(_0x7888('0xa'));var querystring=require(_0x7888('0x11'));var Papa=require(_0x7888('0x12'));var Redis=require('ioredis');var authService=require(_0x7888('0x13'));var qs=require('../../components/parsers/qs');var as=require(_0x7888('0x14'));var hardwareService=require(_0x7888('0x15'));var logger=require(_0x7888('0x16'))(_0x7888('0x17'));var utils=require(_0x7888('0x18'));var config=require('../../config/environment');var licenseUtil=require(_0x7888('0x19'));var db=require(_0x7888('0x1a'))['db'];config[_0x7888('0x1b')]=_[_0x7888('0x1c')](config[_0x7888('0x1b')],{'host':_0x7888('0x1d'),'port':0x18eb});var socket=require(_0x7888('0x1e'))(new Redis(config[_0x7888('0x1b')]));require(_0x7888('0x1f'))['register'](socket);function respondWithStatusCode(_0x122d0d,_0x2381bf){_0x2381bf=_0x2381bf||0xcc;return function(_0x22b207){if(_0x22b207){return _0x122d0d[_0x7888('0x20')](_0x2381bf);}return _0x122d0d[_0x7888('0x21')](_0x2381bf)['end']();};}function respondWithResult(_0xccc677,_0x137c63){_0x137c63=_0x137c63||0xc8;return function(_0x1769d2){if(_0x1769d2){return _0xccc677[_0x7888('0x21')](_0x137c63)[_0x7888('0x22')](_0x1769d2);}};}function respondWithFilteredResult(_0x385f5e,_0x35768a){return function(_0x23f720){if(_0x23f720){var _0x5b92d7=typeof _0x35768a[_0x7888('0x23')]===_0x7888('0x24')&&typeof _0x35768a['limit']===_0x7888('0x24');var _0x1f4f3f=_0x23f720[_0x7888('0x25')];var _0x58bd43=_0x5b92d7?0x0:_0x35768a['offset'];var _0x1f63af=_0x5b92d7?_0x23f720[_0x7888('0x25')]:_0x35768a[_0x7888('0x23')]+_0x35768a[_0x7888('0x26')];var _0xed8573;if(_0x1f63af>=_0x1f4f3f){_0x1f63af=_0x1f4f3f;_0xed8573=0xc8;}else{_0xed8573=0xce;}_0x385f5e[_0x7888('0x21')](_0xed8573);return _0x385f5e[_0x7888('0x27')](_0x7888('0x28'),_0x58bd43+'-'+_0x1f63af+'/'+_0x1f4f3f)[_0x7888('0x22')](_0x23f720);}return null;};}function patchUpdates(_0x5e6a26){return function(_0x627a07){try{jsonpatch[_0x7888('0x29')](_0x627a07,_0x5e6a26,!![]);}catch(_0x4e60d5){return BPromise[_0x7888('0x2a')](_0x4e60d5);}return _0x627a07[_0x7888('0x2b')]();};}function saveUpdates(_0x56ff55,_0x31d631){return function(_0x45d9bb){if(_0x45d9bb){return _0x45d9bb['update'](_0x56ff55)['then'](function(_0x238225){return _0x238225;});}return null;};}function removeEntity(_0x3040da,_0x1a548f){return function(_0x399e5c){if(_0x399e5c){return _0x399e5c['destroy']()[_0x7888('0x2c')](function(){var _0x38bc8d=_0x399e5c[_0x7888('0x2d')]({'plain':!![]});var _0xf978='SmsQueues';return db[_0x7888('0x2e')][_0x7888('0x2f')]({'where':{'type':_0xf978,'resourceId':_0x38bc8d['id']}})['then'](function(){return _0x399e5c;});})[_0x7888('0x2c')](function(){_0x3040da[_0x7888('0x21')](0xcc)[_0x7888('0x30')]();});}};}function handleEntityNotFound(_0x3ed2f7,_0x1ce689){return function(_0x17c73f){if(!_0x17c73f){_0x3ed2f7[_0x7888('0x20')](0x194);}return _0x17c73f;};}function handleError(_0x303853,_0x3d10c8){_0x3d10c8=_0x3d10c8||0x1f4;return function(_0xf10955){logger['error'](_0xf10955[_0x7888('0x31')]);if(_0xf10955[_0x7888('0x32')]){delete _0xf10955[_0x7888('0x32')];}_0x303853['status'](_0x3d10c8)[_0x7888('0x33')](_0xf10955);};}exports[_0x7888('0x34')]=function(_0x220bf9,_0x2a1071){var _0x18ffb9={},_0x5a0a10={},_0x3464c3={'count':0x0,'rows':[]};var _0x4006e8=_['map'](db[_0x7888('0x35')][_0x7888('0x36')],function(_0x12744e){return{'name':_0x12744e['fieldName'],'type':_0x12744e[_0x7888('0x37')]['key']};});_0x5a0a10[_0x7888('0x38')]=_[_0x7888('0x39')](_0x4006e8,_0x7888('0x32'));_0x5a0a10['query']=_['keys'](_0x220bf9[_0x7888('0x3a')]);_0x5a0a10[_0x7888('0x3b')]=_['intersection'](_0x5a0a10[_0x7888('0x38')],_0x5a0a10[_0x7888('0x3a')]);_0x18ffb9['attributes']=_[_0x7888('0x3c')](_0x5a0a10[_0x7888('0x38')],qs['fields'](_0x220bf9[_0x7888('0x3a')][_0x7888('0x3d')]));_0x18ffb9[_0x7888('0x3e')]=_0x18ffb9['attributes'][_0x7888('0x3f')]?_0x18ffb9[_0x7888('0x3e')]:_0x5a0a10[_0x7888('0x38')];if(!_0x220bf9[_0x7888('0x3a')][_0x7888('0x40')](_0x7888('0x41'))){_0x18ffb9[_0x7888('0x26')]=qs[_0x7888('0x26')](_0x220bf9[_0x7888('0x3a')][_0x7888('0x26')]);_0x18ffb9[_0x7888('0x23')]=qs[_0x7888('0x23')](_0x220bf9[_0x7888('0x3a')]['offset']);}_0x18ffb9['order']=qs['sort'](_0x220bf9['query'][_0x7888('0x42')]);_0x18ffb9[_0x7888('0x43')]=qs[_0x7888('0x3b')](_[_0x7888('0x44')](_0x220bf9[_0x7888('0x3a')],_0x5a0a10[_0x7888('0x3b')]),_0x4006e8);if(_0x220bf9[_0x7888('0x3a')][_0x7888('0x45')]){_0x18ffb9['where']=_[_0x7888('0x46')](_0x18ffb9[_0x7888('0x43')],{'$or':_[_0x7888('0x39')](_0x4006e8,function(_0x5960e2){if(_0x5960e2[_0x7888('0x37')]!=='VIRTUAL'){var _0x3a8d97={};_0x3a8d97[_0x5960e2[_0x7888('0x32')]]={'$like':'%'+_0x220bf9[_0x7888('0x3a')]['filter']+'%'};return _0x3a8d97;}})});}_0x18ffb9=_[_0x7888('0x46')]({},_0x18ffb9,_0x220bf9[_0x7888('0x47')]);var _0x2e3baf={'where':_0x18ffb9[_0x7888('0x43')]};return db[_0x7888('0x35')][_0x7888('0x25')](_0x2e3baf)['then'](function(_0x3d6864){_0x3464c3[_0x7888('0x25')]=_0x3d6864;if(_0x220bf9[_0x7888('0x3a')][_0x7888('0x48')]){_0x18ffb9[_0x7888('0x49')]=[{'all':!![]}];}return db['SmsQueue']['findAll'](_0x18ffb9);})[_0x7888('0x2c')](function(_0x3d0c83){_0x3464c3[_0x7888('0x4a')]=_0x3d0c83;return _0x3464c3;})[_0x7888('0x2c')](respondWithFilteredResult(_0x2a1071,_0x18ffb9))[_0x7888('0x4b')](handleError(_0x2a1071,null));};exports['show']=function(_0x2040c0,_0x48ba56){var _0x228db2={'raw':!![],'where':{'id':_0x2040c0[_0x7888('0x4c')]['id']}},_0x421062={};_0x421062[_0x7888('0x38')]=_[_0x7888('0x4d')](db['SmsQueue'][_0x7888('0x36')]);_0x421062['query']=_['keys'](_0x2040c0[_0x7888('0x3a')]);_0x421062[_0x7888('0x3b')]=_['intersection'](_0x421062['model'],_0x421062['query']);_0x228db2[_0x7888('0x3e')]=_[_0x7888('0x3c')](_0x421062['model'],qs[_0x7888('0x3d')](_0x2040c0[_0x7888('0x3a')][_0x7888('0x3d')]));_0x228db2[_0x7888('0x3e')]=_0x228db2[_0x7888('0x3e')]['length']?_0x228db2['attributes']:_0x421062['model'];if(_0x2040c0[_0x7888('0x3a')]['includeAll']){_0x228db2['include']=[{'all':!![]}];}_0x228db2=_[_0x7888('0x46')]({},_0x228db2,_0x2040c0[_0x7888('0x47')]);return db[_0x7888('0x35')][_0x7888('0x4e')](_0x228db2)[_0x7888('0x2c')](handleEntityNotFound(_0x48ba56,null))[_0x7888('0x2c')](respondWithResult(_0x48ba56,null))[_0x7888('0x4b')](handleError(_0x48ba56,null));};exports['create']=function(_0xcef4ad,_0x26d266){return db['SmsQueue'][_0x7888('0x4f')](_0xcef4ad[_0x7888('0x50')],{})[_0x7888('0x2c')](function(_0x38e0d3){var _0x44fdab=_0xcef4ad[_0x7888('0x51')][_0x7888('0x2d')]({'plain':!![]});if(!_0x44fdab)throw new Error(_0x7888('0x52'));if(_0x44fdab[_0x7888('0x53')]===_0x7888('0x51')){var _0x161f64=_0x38e0d3['get']({'plain':!![]});var _0x2b0b51=_0x7888('0x54');return db['UserProfileSection']['find']({'where':{'name':_0x2b0b51,'userProfileId':_0x44fdab[_0x7888('0x55')]},'raw':!![]})[_0x7888('0x2c')](function(_0x28a51d){if(_0x28a51d&&_0x28a51d[_0x7888('0x56')]===0x0){return db[_0x7888('0x2e')]['create']({'name':_0x161f64[_0x7888('0x32')],'resourceId':_0x161f64['id'],'type':_0x28a51d['name'],'sectionId':_0x28a51d['id']},{})[_0x7888('0x2c')](function(){return _0x38e0d3;});}else{return _0x38e0d3;}})[_0x7888('0x4b')](function(_0x165f97){logger[_0x7888('0x57')](_0x7888('0x58'),_0x165f97);throw _0x165f97;});}return _0x38e0d3;})[_0x7888('0x2c')](respondWithResult(_0x26d266,0xc9))[_0x7888('0x4b')](handleError(_0x26d266,null));};exports['update']=function(_0x3993fc,_0x231c13){if(_0x3993fc['body']['id']){delete _0x3993fc['body']['id'];}return db[_0x7888('0x35')][_0x7888('0x4e')]({'where':{'id':_0x3993fc['params']['id']}})[_0x7888('0x2c')](handleEntityNotFound(_0x231c13,null))[_0x7888('0x2c')](saveUpdates(_0x3993fc[_0x7888('0x50')],null))['then'](respondWithResult(_0x231c13,null))['catch'](handleError(_0x231c13,null));};exports[_0x7888('0x2f')]=function(_0x1b2be9,_0x433d6){return db[_0x7888('0x35')][_0x7888('0x4e')]({'where':{'id':_0x1b2be9[_0x7888('0x4c')]['id']}})['then'](handleEntityNotFound(_0x433d6,null))[_0x7888('0x2c')](removeEntity(_0x433d6,null))['catch'](handleError(_0x433d6,null));};exports['describe']=function(_0x39efca,_0xb847a1){return db[_0x7888('0x35')][_0x7888('0x59')]()[_0x7888('0x2c')](respondWithResult(_0xb847a1,null))[_0x7888('0x4b')](handleError(_0xb847a1,null));};exports[_0x7888('0x5a')]=function(_0x1ed67d,_0x14250c,_0x3079b0){var _0x242555={'raw':!![],'where':{}},_0x267140={},_0x38526d;return db[_0x7888('0x35')]['findOne']({'where':{'id':_0x1ed67d[_0x7888('0x4c')]['id']}})[_0x7888('0x2c')](handleEntityNotFound(_0x14250c,null))[_0x7888('0x2c')](function(_0x434210){if(_0x434210){_0x38526d=_0x434210[_0x7888('0x2d')]({'plain':!![]});_0x267140[_0x7888('0x38')]=_[_0x7888('0x4d')](db[_0x7888('0x5b')]['rawAttributes']);_0x267140[_0x7888('0x3a')]=_[_0x7888('0x4d')](_0x1ed67d[_0x7888('0x3a')]);_0x267140['filters']=_[_0x7888('0x3c')](_0x267140[_0x7888('0x38')],_0x267140['query']);_0x242555[_0x7888('0x3e')]=_[_0x7888('0x3c')](_0x267140[_0x7888('0x38')],qs['fields'](_0x1ed67d[_0x7888('0x3a')][_0x7888('0x3d')]));_0x242555[_0x7888('0x3e')]=_0x242555[_0x7888('0x3e')][_0x7888('0x3f')]?_0x242555[_0x7888('0x3e')]:_0x267140['model'];if(!_0x1ed67d[_0x7888('0x3a')][_0x7888('0x40')](_0x7888('0x41'))){_0x242555[_0x7888('0x26')]=qs[_0x7888('0x26')](_0x1ed67d[_0x7888('0x3a')][_0x7888('0x26')]);_0x242555['offset']=qs[_0x7888('0x23')](_0x1ed67d[_0x7888('0x3a')][_0x7888('0x23')]);}_0x242555[_0x7888('0x5c')]=qs[_0x7888('0x42')](_0x1ed67d[_0x7888('0x3a')][_0x7888('0x42')]);_0x242555[_0x7888('0x43')]=qs[_0x7888('0x3b')](_[_0x7888('0x44')](_0x1ed67d[_0x7888('0x3a')],_0x267140[_0x7888('0x3b')]));_0x242555[_0x7888('0x43')][_0x7888('0x5d')]=_0x434210['id'];if(_0x1ed67d[_0x7888('0x3a')][_0x7888('0x45')]){_0x242555[_0x7888('0x43')]=_[_0x7888('0x46')](_0x242555[_0x7888('0x43')],{'$or':_[_0x7888('0x39')](_0x242555[_0x7888('0x3e')],function(_0x4aa95e){var _0x5db51f={};_0x5db51f[_0x4aa95e]={'$like':'%'+_0x1ed67d[_0x7888('0x3a')][_0x7888('0x45')]+'%'};return _0x5db51f;})});}_0x242555=_[_0x7888('0x46')]({},_0x242555,_0x1ed67d[_0x7888('0x47')]);return db[_0x7888('0x5b')][_0x7888('0x5e')](_0x242555);}})[_0x7888('0x2c')](function(_0xd55d90){if(_0xd55d90){return db[_0x7888('0x5f')][_0x7888('0x60')]({'where':{'id':_[_0x7888('0x39')](_0xd55d90,_0x7888('0x61')),'role':_0x7888('0x62')},'attributes':['id',_0x7888('0x32'),_0x7888('0x63'),_0x7888('0x64'),_0x7888('0x65')]});}})[_0x7888('0x2c')](function(_0x5e028b){if(_0x5e028b){return{'count':_0x5e028b[_0x7888('0x25')],'rows':_['map'](_0x5e028b[_0x7888('0x4a')],function(_0x2b1e68){return{'membername':_0x2b1e68[_0x7888('0x32')],'UserId':_0x2b1e68['id'],'queue_name':_0x38526d[_0x7888('0x32')],'SmsQueueId':_0x38526d['id'],'interface':util[_0x7888('0x66')](_0x7888('0x67'),_0x7888('0x68'),_0x2b1e68['name']),'penalty':0x0,'paused':_0x2b1e68[_0x7888('0x63')],'createdAt':_0x2b1e68[_0x7888('0x65')],'updatedAt':_0x2b1e68[_0x7888('0x64')]};})};}else{return{'count':0x0,'rows':[]};}})[_0x7888('0x2c')](respondWithFilteredResult(_0x14250c,_0x242555))[_0x7888('0x4b')](handleError(_0x14250c,null));};exports[_0x7888('0x69')]=function(_0x5ea1f0,_0x16adf5,_0x2b11e5){var _0xf0ac7c={};var _0x1fb61a={};var _0x3d1c57;var _0x33e682;return db[_0x7888('0x35')][_0x7888('0x6a')]({'where':{'id':_0x5ea1f0['params']['id']}})[_0x7888('0x2c')](handleEntityNotFound(_0x16adf5,null))[_0x7888('0x2c')](function(_0x5196c6){if(_0x5196c6){_0x3d1c57=_0x5196c6;_0x1fb61a['model']=_[_0x7888('0x4d')](db['Team'][_0x7888('0x36')]);_0x1fb61a[_0x7888('0x3a')]=_[_0x7888('0x4d')](_0x5ea1f0['query']);_0x1fb61a['filters']=_['intersection'](_0x1fb61a[_0x7888('0x38')],_0x1fb61a[_0x7888('0x3a')]);_0xf0ac7c['attributes']=_[_0x7888('0x3c')](_0x1fb61a[_0x7888('0x38')],qs['fields'](_0x5ea1f0[_0x7888('0x3a')]['fields']));_0xf0ac7c['attributes']=_0xf0ac7c[_0x7888('0x3e')][_0x7888('0x3f')]?_0xf0ac7c['attributes']:_0x1fb61a[_0x7888('0x38')];_0xf0ac7c[_0x7888('0x5c')]=qs['sort'](_0x5ea1f0[_0x7888('0x3a')][_0x7888('0x42')]);_0xf0ac7c[_0x7888('0x43')]=qs['filters'](_['pick'](_0x5ea1f0[_0x7888('0x3a')],_0x1fb61a[_0x7888('0x3b')]));if(_0x5ea1f0[_0x7888('0x3a')][_0x7888('0x45')]){_0xf0ac7c[_0x7888('0x43')]=_[_0x7888('0x46')](_0xf0ac7c[_0x7888('0x43')],{'$or':_[_0x7888('0x39')](_0xf0ac7c[_0x7888('0x3e')],function(_0x41ebd7){var _0x1df15a={};_0x1df15a[_0x41ebd7]={'$like':'%'+_0x5ea1f0[_0x7888('0x3a')]['filter']+'%'};return _0x1df15a;})});}_0xf0ac7c=_[_0x7888('0x46')]({},_0xf0ac7c,_0x5ea1f0[_0x7888('0x47')]);return _0x3d1c57[_0x7888('0x69')](_0xf0ac7c);}})[_0x7888('0x2c')](function(_0x241bdf){if(_0x241bdf){_0x33e682=_0x241bdf['length'];if(!_0x5ea1f0[_0x7888('0x3a')][_0x7888('0x40')]('nolimit')){_0xf0ac7c[_0x7888('0x26')]=qs[_0x7888('0x26')](_0x5ea1f0[_0x7888('0x3a')]['limit']);_0xf0ac7c[_0x7888('0x23')]=qs[_0x7888('0x23')](_0x5ea1f0[_0x7888('0x3a')][_0x7888('0x23')]);}return _0x3d1c57[_0x7888('0x69')](_0xf0ac7c);}})[_0x7888('0x2c')](function(_0x2157af){if(_0x2157af){return _0x2157af?{'count':_0x33e682,'rows':_0x2157af}:null;}})['then'](respondWithResult(_0x16adf5,null))['catch'](handleError(_0x16adf5,null));};exports[_0x7888('0x6b')]=function(_0x2e208b,_0x59c257,_0x4c38f6){var _0x1fd2e2=_0x2e208b[_0x7888('0x50')][_0x7888('0x6c')];return db[_0x7888('0x6d')]['findAll']({'where':{'id':_0x1fd2e2},'attributes':['id'],'include':[{'model':db['User'],'as':_0x7888('0x6e'),'attributes':['id','name',_0x7888('0x6f'),_0x7888('0x70'),_0x7888('0x71')],'raw':!![]}]})['then'](function(_0x112d1a){if(_0x112d1a){var _0x21fa88=_[_0x7888('0x72')](_0x112d1a,function(_0x49d9fa){var _0x7a9b9d=_0x49d9fa[_0x7888('0x2d')]({'plain':!![]});return _0x7a9b9d['Agents'];});return db[_0x7888('0x35')][_0x7888('0x4e')]({'where':{'id':_0x2e208b['params']['id']}})[_0x7888('0x2c')](function(_0x53bff8){return db[_0x7888('0x73')]['transaction'](function(_0x25e3da){return _0x53bff8[_0x7888('0x6b')](_0x1fd2e2,{'transaction':_0x25e3da})[_0x7888('0x2c')](function(){return BPromise[_0x7888('0x74')](_0x21fa88,function(_0x30812d){return db['UserSmsQueue'][_0x7888('0x75')]({'where':{'UserId':_0x30812d['id'],'SmsQueueId':_0x2e208b[_0x7888('0x4c')]['id']},'transaction':_0x25e3da});});})['then'](function(){_0x21fa88[_0x7888('0x76')](function(_0x246b73){socket[_0x7888('0x77')](_0x7888('0x78'),{'UserId':_0x246b73['id'],'SmsQueueId':_0x53bff8['id']});});});});});}})[_0x7888('0x2c')](respondWithStatusCode(_0x59c257,null))[_0x7888('0x4b')](handleError(_0x59c257,null));};exports['removeTeams']=function(_0x4892a8,_0x19d34d,_0x457879){return db[_0x7888('0x6d')][_0x7888('0x5e')]({'where':{'id':_0x4892a8[_0x7888('0x3a')][_0x7888('0x6c')]},'attributes':['id'],'include':[{'model':db[_0x7888('0x5f')],'as':_0x7888('0x6e'),'attributes':['id'],'raw':!![]}]})[_0x7888('0x2c')](handleEntityNotFound(_0x19d34d,null))['then'](function(_0x8a4789){var _0xcda681=_[_0x7888('0x39')](_0x8a4789,'id');var _0x40d113=[];var _0x4e9d49=[];var _0x210e81=squel[_0x7888('0x79')]();_0x210e81[_0x7888('0x7a')](_0x7888('0x7b'))[_0x7888('0x7c')](_0x7888('0x7d'),'tq')['join'](_0x7888('0x7e'),'ut',_0x7888('0x7f'))[_0x7888('0x43')](_0x7888('0x80'),_0x4892a8[_0x7888('0x4c')]['id']);for(var _0x28ab01=0x0;_0x28ab01<_0x8a4789[_0x7888('0x3f')];_0x28ab01+=0x1){let _0x950b09=_0x8a4789[_0x28ab01];for(var _0x4d9868=0x0;_0x4d9868<_0x950b09[_0x7888('0x6e')]['length'];_0x4d9868+=0x1){let _0xd28297=_0x950b09['Agents'][_0x4d9868];var _0x3c7ac0=_0x210e81[_0x7888('0x81')]();_0x3c7ac0[_0x7888('0x43')](_0x7888('0x82'),_0xd28297['id']);_0x4e9d49['push'](db[_0x7888('0x73')]['query'](_0x3c7ac0[_0x7888('0x83')](),{'type':db[_0x7888('0x73')]['QueryTypes'][_0x7888('0x84')]})[_0x7888('0x2c')](function(_0x39092a){if(_0x39092a[_0x7888('0x3f')]===0x1){return _0xd28297['id'];}else{var _0x45330b=_[_0x7888('0x85')](_['map'](_0x39092a,_0x7888('0x86')),function(_0x959fde){return _[_0x7888('0x87')](_0xcda681,_0x959fde);});if(_0x45330b){return _0xd28297['id'];}}}));}}return BPromise[_0x7888('0x88')](_0x4e9d49)[_0x7888('0x2c')](function(_0x26b5b9){_0x40d113=_(_0x40d113)['union'](_0x26b5b9)[_0x7888('0x89')]()[_0x7888('0x8a')]();return db['SmsQueue'][_0x7888('0x4e')]({'where':{'id':_0x4892a8[_0x7888('0x4c')]['id']}})[_0x7888('0x2c')](function(_0x1fde66){return db[_0x7888('0x73')][_0x7888('0x8b')](function(_0x3625f2){return _0x1fde66[_0x7888('0x8c')](_0x4892a8[_0x7888('0x3a')][_0x7888('0x6c')],{'transaction':_0x3625f2})[_0x7888('0x2c')](function(){if(!_[_0x7888('0x8d')](_0x40d113)){return _0x1fde66[_0x7888('0x8e')](_0x40d113,{'transaction':_0x3625f2});}})[_0x7888('0x2c')](function(){_0x40d113['forEach'](function(_0x34a0cd){socket[_0x7888('0x77')](_0x7888('0x8f'),{'UserId':_0x34a0cd,'SmsQueueId':_0x1fde66['id']});});});});});});})['then'](respondWithStatusCode(_0x19d34d,null))[_0x7888('0x4b')](handleError(_0x19d34d,null));};exports[_0x7888('0x90')]=function(_0x60fb38,_0x3707f0,_0x395eb7){return db[_0x7888('0x35')][_0x7888('0x4e')]({'where':{'id':_0x60fb38[_0x7888('0x4c')]['id']}})[_0x7888('0x2c')](handleEntityNotFound(_0x3707f0,null))[_0x7888('0x2c')](function(_0x5bfb06){if(_0x5bfb06){return _0x5bfb06[_0x7888('0x90')](_0x60fb38[_0x7888('0x50')]['ids'],_[_0x7888('0x91')](_0x60fb38['body'],[_0x7888('0x6c'),'id'])||{})[_0x7888('0x92')](function(_0x3ac081){for(var _0x59c81e=0x0;_0x59c81e<_0x60fb38['body'][_0x7888('0x6c')][_0x7888('0x3f')];_0x59c81e+=0x1){socket[_0x7888('0x77')]('userSmsQueue:save',{'UserId':Number(_0x60fb38[_0x7888('0x50')]['ids'][_0x59c81e]),'SmsQueueId':Number(_0x60fb38[_0x7888('0x4c')]['id'])});}return _0x3ac081;});}})[_0x7888('0x2c')](respondWithResult(_0x3707f0,null))[_0x7888('0x4b')](handleError(_0x3707f0,null));};exports[_0x7888('0x8e')]=function(_0x58ef95,_0x343c8d,_0x236e4e){return db['SmsQueue'][_0x7888('0x4e')]({'where':{'id':_0x58ef95['params']['id']}})[_0x7888('0x2c')](handleEntityNotFound(_0x343c8d,null))['then'](function(_0x6384){if(_0x6384){return _0x6384['removeAgents'](_0x58ef95[_0x7888('0x3a')][_0x7888('0x6c')])[_0x7888('0x2c')](function(){if(_['isArray'](_0x58ef95['query'][_0x7888('0x6c')])){for(var _0x20ef9f=0x0;_0x20ef9f<_0x58ef95[_0x7888('0x3a')][_0x7888('0x6c')][_0x7888('0x3f')];_0x20ef9f+=0x1){socket[_0x7888('0x77')]('userSmsQueue:remove',{'UserId':Number(_0x58ef95[_0x7888('0x3a')]['ids'][_0x20ef9f]),'SmsQueueId':Number(_0x58ef95['params']['id'])});}}else{socket[_0x7888('0x77')](_0x7888('0x8f'),{'UserId':Number(_0x58ef95['query'][_0x7888('0x6c')]),'SmsQueueId':Number(_0x58ef95[_0x7888('0x4c')]['id'])});}});}})['then'](respondWithStatusCode(_0x343c8d,null))['catch'](handleError(_0x343c8d,null));};exports[_0x7888('0x93')]=function(_0x316cde,_0x1d8412,_0x928bbf){var _0x16df9e={};var _0xe5187a={};var _0x47f16f;var _0x3bdf3f;return db['SmsQueue'][_0x7888('0x6a')]({'where':{'id':_0x316cde['params']['id']}})[_0x7888('0x2c')](handleEntityNotFound(_0x1d8412,null))[_0x7888('0x2c')](function(_0x18c33b){if(_0x18c33b){_0x47f16f=_0x18c33b;_0xe5187a[_0x7888('0x38')]=_['keys'](db[_0x7888('0x5f')][_0x7888('0x36')]);_0xe5187a[_0x7888('0x3a')]=_[_0x7888('0x4d')](_0x316cde[_0x7888('0x3a')]);_0xe5187a[_0x7888('0x3b')]=_[_0x7888('0x3c')](_0xe5187a[_0x7888('0x38')],_0xe5187a[_0x7888('0x3a')]);_0x16df9e[_0x7888('0x3e')]=_['intersection'](_0xe5187a[_0x7888('0x38')],qs[_0x7888('0x3d')](_0x316cde[_0x7888('0x3a')][_0x7888('0x3d')]));_0x16df9e['attributes']=_0x16df9e[_0x7888('0x3e')][_0x7888('0x3f')]?_0x16df9e[_0x7888('0x3e')]:_0xe5187a[_0x7888('0x38')];_0x16df9e['order']=qs[_0x7888('0x42')](_0x316cde[_0x7888('0x3a')][_0x7888('0x42')]);_0x16df9e[_0x7888('0x43')]=qs[_0x7888('0x3b')](_[_0x7888('0x44')](_0x316cde[_0x7888('0x3a')],_0xe5187a['filters']));if(_0x316cde['query'][_0x7888('0x45')]){_0x16df9e[_0x7888('0x43')]=_[_0x7888('0x46')](_0x16df9e['where'],{'$or':_[_0x7888('0x39')](_0x16df9e['attributes'],function(_0xbcbba9){var _0x32a6e5={};_0x32a6e5[_0xbcbba9]={'$like':'%'+_0x316cde['query']['filter']+'%'};return _0x32a6e5;})});}_0x16df9e=_['merge']({},_0x16df9e,_0x316cde['options']);return _0x47f16f[_0x7888('0x93')](_0x16df9e);}})[_0x7888('0x2c')](function(_0x5b4076){if(_0x5b4076){_0x3bdf3f=_0x5b4076[_0x7888('0x3f')];if(!_0x316cde[_0x7888('0x3a')][_0x7888('0x40')](_0x7888('0x41'))){_0x16df9e[_0x7888('0x26')]=qs[_0x7888('0x26')](_0x316cde[_0x7888('0x3a')][_0x7888('0x26')]);_0x16df9e[_0x7888('0x23')]=qs[_0x7888('0x23')](_0x316cde[_0x7888('0x3a')][_0x7888('0x23')]);}return _0x47f16f[_0x7888('0x93')](_0x16df9e);}})[_0x7888('0x2c')](function(_0x4b0b8c){if(_0x4b0b8c){return _0x4b0b8c?{'count':_0x3bdf3f,'rows':_0x4b0b8c}:null;}})[_0x7888('0x2c')](respondWithResult(_0x1d8412,null))[_0x7888('0x4b')](handleError(_0x1d8412,null));};