0aa63059dafd1ee87055cd40e30d930d001aeddc
[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 _0xcb2c=['SmsQueues','UserProfileResource','destroy','end','error','name','index','map','SmsQueue','rawAttributes','fieldName','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','sort','where','pick','filter','merge','options','findAll','rows','catch','show','include','find','create','body','user','role','UserProfileSection','userProfileId','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','params','describe','findOne','UserSmsQueue','order','SmsQueueId','User','findAndCountAll','UserId','agent','smsPause','updatedAt','createdAt','format','getTeams','Team','addTeams','ids','Agents','online','voicePause','interface','sequelize','transaction','findOrCreate','forEach','emit','userSmsQueue:save','removeTeams','field','tq.TeamId','team_has_sms_queues','join','user_has_teams','ut.TeamId\x20=\x20tq.TeamId','SmsQueueId\x20=\x20?','clone','ut.UserId\x20=\x20?','push','toString','QueryTypes','includes','union','compact','value','isEmpty','removeAgents','addAgents','omit','isArray','userSmsQueue:remove','getAgents','eml-format','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','ejs','fs-extra','squel','crypto','jsforce','to-csv','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','redis','socket.io-emitter','./smsQueue.socket','register','sendStatus','status','offset','limit','undefined','count','set','Content-Range','json','update','then','get'];(function(_0x3c57df,_0x5f1ca1){var _0x329c6a=function(_0x2129ca){while(--_0x2129ca){_0x3c57df['push'](_0x3c57df['shift']());}};_0x329c6a(++_0x5f1ca1);}(_0xcb2c,0x16b));var _0xccb2=function(_0x1eda20,_0x1149f4){_0x1eda20=_0x1eda20-0x0;var _0x31b953=_0xcb2c[_0x1eda20];return _0x31b953;};'use strict';var emlformat=require(_0xccb2('0x0'));var rimraf=require('rimraf');var zipdir=require(_0xccb2('0x1'));var jsonpatch=require(_0xccb2('0x2'));var rp=require(_0xccb2('0x3'));var moment=require(_0xccb2('0x4'));var BPromise=require(_0xccb2('0x5'));var Mustache=require(_0xccb2('0x6'));var util=require(_0xccb2('0x7'));var path=require(_0xccb2('0x8'));var sox=require(_0xccb2('0x9'));var csv=require('to-csv');var ejs=require(_0xccb2('0xa'));var fs=require('fs');var fs_extra=require(_0xccb2('0xb'));var _=require('lodash');var squel=require(_0xccb2('0xc'));var crypto=require(_0xccb2('0xd'));var jsforce=require(_0xccb2('0xe'));var deskjs=require('desk.js');var toCsv=require(_0xccb2('0xf'));var querystring=require('querystring');var Papa=require(_0xccb2('0x10'));var Redis=require(_0xccb2('0x11'));var authService=require('../../components/auth/service');var qs=require(_0xccb2('0x12'));var as=require(_0xccb2('0x13'));var hardwareService=require(_0xccb2('0x14'));var logger=require('../../config/logger')(_0xccb2('0x15'));var utils=require(_0xccb2('0x16'));var config=require(_0xccb2('0x17'));var licenseUtil=require(_0xccb2('0x18'));var db=require(_0xccb2('0x19'))['db'];config[_0xccb2('0x1a')]=_['defaults'](config[_0xccb2('0x1a')],{'host':'localhost','port':0x18eb});var socket=require(_0xccb2('0x1b'))(new Redis(config[_0xccb2('0x1a')]));require(_0xccb2('0x1c'))[_0xccb2('0x1d')](socket);function respondWithStatusCode(_0x24b24d,_0x56e514){_0x56e514=_0x56e514||0xcc;return function(_0x17d5d3){if(_0x17d5d3){return _0x24b24d[_0xccb2('0x1e')](_0x56e514);}return _0x24b24d[_0xccb2('0x1f')](_0x56e514)['end']();};}function respondWithResult(_0x4072ac,_0x10ef53){_0x10ef53=_0x10ef53||0xc8;return function(_0x376ef9){if(_0x376ef9){return _0x4072ac[_0xccb2('0x1f')](_0x10ef53)['json'](_0x376ef9);}};}function respondWithFilteredResult(_0x49c0a2,_0x584569){return function(_0x5a4572){if(_0x5a4572){var _0x3d1264=typeof _0x584569[_0xccb2('0x20')]==='undefined'&&typeof _0x584569[_0xccb2('0x21')]===_0xccb2('0x22');var _0x2b7bb6=_0x5a4572[_0xccb2('0x23')];var _0x5df448=_0x3d1264?0x0:_0x584569[_0xccb2('0x20')];var _0x353f33=_0x3d1264?_0x5a4572[_0xccb2('0x23')]:_0x584569[_0xccb2('0x20')]+_0x584569['limit'];var _0x4f2cca;if(_0x353f33>=_0x2b7bb6){_0x353f33=_0x2b7bb6;_0x4f2cca=0xc8;}else{_0x4f2cca=0xce;}_0x49c0a2[_0xccb2('0x1f')](_0x4f2cca);return _0x49c0a2[_0xccb2('0x24')](_0xccb2('0x25'),_0x5df448+'-'+_0x353f33+'/'+_0x2b7bb6)[_0xccb2('0x26')](_0x5a4572);}return null;};}function patchUpdates(_0x4edf33){return function(_0x43cd15){try{jsonpatch['apply'](_0x43cd15,_0x4edf33,!![]);}catch(_0x7dec92){return BPromise['reject'](_0x7dec92);}return _0x43cd15['save']();};}function saveUpdates(_0xdce329,_0x390e86){return function(_0x180d36){if(_0x180d36){return _0x180d36[_0xccb2('0x27')](_0xdce329)[_0xccb2('0x28')](function(_0x457892){return _0x457892;});}return null;};}function removeEntity(_0x504f68,_0x237c99){return function(_0x49b062){if(_0x49b062){return _0x49b062['destroy']()[_0xccb2('0x28')](function(){var _0x7fa063=_0x49b062[_0xccb2('0x29')]({'plain':!![]});var _0x2c87c0=_0xccb2('0x2a');return db[_0xccb2('0x2b')][_0xccb2('0x2c')]({'where':{'type':_0x2c87c0,'resourceId':_0x7fa063['id']}})[_0xccb2('0x28')](function(){return _0x49b062;});})[_0xccb2('0x28')](function(){_0x504f68[_0xccb2('0x1f')](0xcc)[_0xccb2('0x2d')]();});}};}function handleEntityNotFound(_0x549f70,_0x302c87){return function(_0x12b770){if(!_0x12b770){_0x549f70[_0xccb2('0x1e')](0x194);}return _0x12b770;};}function handleError(_0x3ed02e,_0x3dafc3){_0x3dafc3=_0x3dafc3||0x1f4;return function(_0x3fdbde){logger[_0xccb2('0x2e')](_0x3fdbde['stack']);if(_0x3fdbde[_0xccb2('0x2f')]){delete _0x3fdbde[_0xccb2('0x2f')];}_0x3ed02e[_0xccb2('0x1f')](_0x3dafc3)['send'](_0x3fdbde);};}exports[_0xccb2('0x30')]=function(_0x390a19,_0x241976){var _0x11daa0={},_0xd3e68={},_0x1737a9={'count':0x0,'rows':[]};var _0x7456c5=_[_0xccb2('0x31')](db[_0xccb2('0x32')][_0xccb2('0x33')],function(_0x38cc9b){return{'name':_0x38cc9b[_0xccb2('0x34')],'type':_0x38cc9b['type'][_0xccb2('0x35')]};});_0xd3e68[_0xccb2('0x36')]=_[_0xccb2('0x31')](_0x7456c5,'name');_0xd3e68[_0xccb2('0x37')]=_[_0xccb2('0x38')](_0x390a19['query']);_0xd3e68[_0xccb2('0x39')]=_[_0xccb2('0x3a')](_0xd3e68[_0xccb2('0x36')],_0xd3e68[_0xccb2('0x37')]);_0x11daa0[_0xccb2('0x3b')]=_[_0xccb2('0x3a')](_0xd3e68[_0xccb2('0x36')],qs[_0xccb2('0x3c')](_0x390a19[_0xccb2('0x37')][_0xccb2('0x3c')]));_0x11daa0[_0xccb2('0x3b')]=_0x11daa0[_0xccb2('0x3b')][_0xccb2('0x3d')]?_0x11daa0['attributes']:_0xd3e68[_0xccb2('0x36')];if(!_0x390a19['query'][_0xccb2('0x3e')](_0xccb2('0x3f'))){_0x11daa0[_0xccb2('0x21')]=qs[_0xccb2('0x21')](_0x390a19[_0xccb2('0x37')][_0xccb2('0x21')]);_0x11daa0['offset']=qs[_0xccb2('0x20')](_0x390a19[_0xccb2('0x37')][_0xccb2('0x20')]);}_0x11daa0['order']=qs[_0xccb2('0x40')](_0x390a19[_0xccb2('0x37')][_0xccb2('0x40')]);_0x11daa0[_0xccb2('0x41')]=qs[_0xccb2('0x39')](_[_0xccb2('0x42')](_0x390a19[_0xccb2('0x37')],_0xd3e68[_0xccb2('0x39')]),_0x7456c5);if(_0x390a19[_0xccb2('0x37')][_0xccb2('0x43')]){_0x11daa0[_0xccb2('0x41')]=_[_0xccb2('0x44')](_0x11daa0[_0xccb2('0x41')],{'$or':_[_0xccb2('0x31')](_0x7456c5,function(_0x5884be){if(_0x5884be['type']!=='VIRTUAL'){var _0x401398={};_0x401398[_0x5884be['name']]={'$like':'%'+_0x390a19[_0xccb2('0x37')][_0xccb2('0x43')]+'%'};return _0x401398;}})});}_0x11daa0=_[_0xccb2('0x44')]({},_0x11daa0,_0x390a19[_0xccb2('0x45')]);var _0x2351c2={'where':_0x11daa0[_0xccb2('0x41')]};return db[_0xccb2('0x32')][_0xccb2('0x23')](_0x2351c2)[_0xccb2('0x28')](function(_0x5c5572){_0x1737a9[_0xccb2('0x23')]=_0x5c5572;if(_0x390a19['query']['includeAll']){_0x11daa0['include']=[{'all':!![]}];}return db[_0xccb2('0x32')][_0xccb2('0x46')](_0x11daa0);})[_0xccb2('0x28')](function(_0x3007cb){_0x1737a9[_0xccb2('0x47')]=_0x3007cb;return _0x1737a9;})[_0xccb2('0x28')](respondWithFilteredResult(_0x241976,_0x11daa0))[_0xccb2('0x48')](handleError(_0x241976,null));};exports[_0xccb2('0x49')]=function(_0x205cf6,_0x284f84){var _0x22457c={'raw':!![],'where':{'id':_0x205cf6['params']['id']}},_0x353241={};_0x353241[_0xccb2('0x36')]=_[_0xccb2('0x38')](db[_0xccb2('0x32')][_0xccb2('0x33')]);_0x353241['query']=_[_0xccb2('0x38')](_0x205cf6[_0xccb2('0x37')]);_0x353241['filters']=_['intersection'](_0x353241[_0xccb2('0x36')],_0x353241['query']);_0x22457c['attributes']=_['intersection'](_0x353241[_0xccb2('0x36')],qs['fields'](_0x205cf6[_0xccb2('0x37')][_0xccb2('0x3c')]));_0x22457c[_0xccb2('0x3b')]=_0x22457c[_0xccb2('0x3b')]['length']?_0x22457c[_0xccb2('0x3b')]:_0x353241[_0xccb2('0x36')];if(_0x205cf6[_0xccb2('0x37')]['includeAll']){_0x22457c[_0xccb2('0x4a')]=[{'all':!![]}];}_0x22457c=_[_0xccb2('0x44')]({},_0x22457c,_0x205cf6[_0xccb2('0x45')]);return db[_0xccb2('0x32')][_0xccb2('0x4b')](_0x22457c)['then'](handleEntityNotFound(_0x284f84,null))['then'](respondWithResult(_0x284f84,null))['catch'](handleError(_0x284f84,null));};exports['create']=function(_0x338fe1,_0x43f3d0){return db[_0xccb2('0x32')][_0xccb2('0x4c')](_0x338fe1[_0xccb2('0x4d')],{})[_0xccb2('0x28')](function(_0x147f23){var _0x329c4f=_0x338fe1[_0xccb2('0x4e')]['get']({'plain':!![]});if(!_0x329c4f)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x329c4f[_0xccb2('0x4f')]===_0xccb2('0x4e')){var _0x3ddaa9=_0x147f23['get']({'plain':!![]});var _0x4bed94=_0xccb2('0x2a');return db[_0xccb2('0x50')][_0xccb2('0x4b')]({'where':{'name':_0x4bed94,'userProfileId':_0x329c4f[_0xccb2('0x51')]},'raw':!![]})['then'](function(_0x4c8838){if(_0x4c8838&&_0x4c8838['autoAssociation']===0x0){return db['UserProfileResource']['create']({'name':_0x3ddaa9[_0xccb2('0x2f')],'resourceId':_0x3ddaa9['id'],'type':_0x4c8838[_0xccb2('0x2f')],'sectionId':_0x4c8838['id']},{})[_0xccb2('0x28')](function(){return _0x147f23;});}else{return _0x147f23;}})[_0xccb2('0x48')](function(_0x384b97){logger[_0xccb2('0x2e')](_0xccb2('0x52'),_0x384b97);throw _0x384b97;});}return _0x147f23;})[_0xccb2('0x28')](respondWithResult(_0x43f3d0,0xc9))['catch'](handleError(_0x43f3d0,null));};exports[_0xccb2('0x27')]=function(_0x2c00d8,_0x6aa0ea){if(_0x2c00d8[_0xccb2('0x4d')]['id']){delete _0x2c00d8[_0xccb2('0x4d')]['id'];}return db['SmsQueue']['find']({'where':{'id':_0x2c00d8[_0xccb2('0x53')]['id']}})['then'](handleEntityNotFound(_0x6aa0ea,null))[_0xccb2('0x28')](saveUpdates(_0x2c00d8[_0xccb2('0x4d')],null))[_0xccb2('0x28')](respondWithResult(_0x6aa0ea,null))['catch'](handleError(_0x6aa0ea,null));};exports['destroy']=function(_0x5739d4,_0x311b41){return db[_0xccb2('0x32')][_0xccb2('0x4b')]({'where':{'id':_0x5739d4[_0xccb2('0x53')]['id']}})[_0xccb2('0x28')](handleEntityNotFound(_0x311b41,null))[_0xccb2('0x28')](removeEntity(_0x311b41,null))[_0xccb2('0x48')](handleError(_0x311b41,null));};exports[_0xccb2('0x54')]=function(_0x3bcf12,_0x3284b3){return db[_0xccb2('0x32')][_0xccb2('0x54')]()[_0xccb2('0x28')](respondWithResult(_0x3284b3,null))[_0xccb2('0x48')](handleError(_0x3284b3,null));};exports['getMembers']=function(_0x3d561a,_0x20626e,_0x19d8a9){var _0x78b2c0={'raw':!![],'where':{}},_0xb94670={},_0x397b98;return db[_0xccb2('0x32')][_0xccb2('0x55')]({'where':{'id':_0x3d561a['params']['id']}})['then'](handleEntityNotFound(_0x20626e,null))[_0xccb2('0x28')](function(_0x2f8169){if(_0x2f8169){_0x397b98=_0x2f8169[_0xccb2('0x29')]({'plain':!![]});_0xb94670['model']=_[_0xccb2('0x38')](db[_0xccb2('0x56')][_0xccb2('0x33')]);_0xb94670[_0xccb2('0x37')]=_[_0xccb2('0x38')](_0x3d561a[_0xccb2('0x37')]);_0xb94670[_0xccb2('0x39')]=_['intersection'](_0xb94670[_0xccb2('0x36')],_0xb94670[_0xccb2('0x37')]);_0x78b2c0[_0xccb2('0x3b')]=_['intersection'](_0xb94670['model'],qs[_0xccb2('0x3c')](_0x3d561a['query']['fields']));_0x78b2c0[_0xccb2('0x3b')]=_0x78b2c0['attributes'][_0xccb2('0x3d')]?_0x78b2c0[_0xccb2('0x3b')]:_0xb94670[_0xccb2('0x36')];if(!_0x3d561a[_0xccb2('0x37')][_0xccb2('0x3e')](_0xccb2('0x3f'))){_0x78b2c0[_0xccb2('0x21')]=qs[_0xccb2('0x21')](_0x3d561a[_0xccb2('0x37')][_0xccb2('0x21')]);_0x78b2c0['offset']=qs[_0xccb2('0x20')](_0x3d561a[_0xccb2('0x37')]['offset']);}_0x78b2c0[_0xccb2('0x57')]=qs[_0xccb2('0x40')](_0x3d561a[_0xccb2('0x37')]['sort']);_0x78b2c0[_0xccb2('0x41')]=qs['filters'](_['pick'](_0x3d561a['query'],_0xb94670[_0xccb2('0x39')]));_0x78b2c0[_0xccb2('0x41')][_0xccb2('0x58')]=_0x2f8169['id'];if(_0x3d561a[_0xccb2('0x37')][_0xccb2('0x43')]){_0x78b2c0['where']=_['merge'](_0x78b2c0['where'],{'$or':_[_0xccb2('0x31')](_0x78b2c0[_0xccb2('0x3b')],function(_0x31a5bf){var _0x23a49d={};_0x23a49d[_0x31a5bf]={'$like':'%'+_0x3d561a['query'][_0xccb2('0x43')]+'%'};return _0x23a49d;})});}_0x78b2c0=_['merge']({},_0x78b2c0,_0x3d561a[_0xccb2('0x45')]);return db[_0xccb2('0x56')][_0xccb2('0x46')](_0x78b2c0);}})[_0xccb2('0x28')](function(_0x1dffcb){if(_0x1dffcb){return db[_0xccb2('0x59')][_0xccb2('0x5a')]({'where':{'id':_[_0xccb2('0x31')](_0x1dffcb,_0xccb2('0x5b')),'role':_0xccb2('0x5c')},'attributes':['id',_0xccb2('0x2f'),_0xccb2('0x5d'),_0xccb2('0x5e'),_0xccb2('0x5f')]});}})[_0xccb2('0x28')](function(_0x782e4f){if(_0x782e4f){return{'count':_0x782e4f[_0xccb2('0x23')],'rows':_[_0xccb2('0x31')](_0x782e4f[_0xccb2('0x47')],function(_0x56ed1b){return{'membername':_0x56ed1b[_0xccb2('0x2f')],'UserId':_0x56ed1b['id'],'queue_name':_0x397b98['name'],'SmsQueueId':_0x397b98['id'],'interface':util[_0xccb2('0x60')]('%s/%s','SIP',_0x56ed1b[_0xccb2('0x2f')]),'penalty':0x0,'paused':_0x56ed1b[_0xccb2('0x5d')],'createdAt':_0x56ed1b[_0xccb2('0x5f')],'updatedAt':_0x56ed1b[_0xccb2('0x5e')]};})};}else{return{'count':0x0,'rows':[]};}})[_0xccb2('0x28')](respondWithFilteredResult(_0x20626e,_0x78b2c0))['catch'](handleError(_0x20626e,null));};exports[_0xccb2('0x61')]=function(_0x2e7ad0,_0x63dfdf,_0x246edd){var _0x56fde8={};var _0x23d870={};var _0x379682;var _0x497a10;return db[_0xccb2('0x32')]['findOne']({'where':{'id':_0x2e7ad0[_0xccb2('0x53')]['id']}})['then'](handleEntityNotFound(_0x63dfdf,null))[_0xccb2('0x28')](function(_0x499e7a){if(_0x499e7a){_0x379682=_0x499e7a;_0x23d870[_0xccb2('0x36')]=_[_0xccb2('0x38')](db[_0xccb2('0x62')][_0xccb2('0x33')]);_0x23d870[_0xccb2('0x37')]=_[_0xccb2('0x38')](_0x2e7ad0[_0xccb2('0x37')]);_0x23d870[_0xccb2('0x39')]=_['intersection'](_0x23d870[_0xccb2('0x36')],_0x23d870[_0xccb2('0x37')]);_0x56fde8['attributes']=_[_0xccb2('0x3a')](_0x23d870[_0xccb2('0x36')],qs[_0xccb2('0x3c')](_0x2e7ad0['query']['fields']));_0x56fde8[_0xccb2('0x3b')]=_0x56fde8[_0xccb2('0x3b')][_0xccb2('0x3d')]?_0x56fde8[_0xccb2('0x3b')]:_0x23d870['model'];_0x56fde8[_0xccb2('0x57')]=qs[_0xccb2('0x40')](_0x2e7ad0['query']['sort']);_0x56fde8[_0xccb2('0x41')]=qs[_0xccb2('0x39')](_[_0xccb2('0x42')](_0x2e7ad0[_0xccb2('0x37')],_0x23d870['filters']));if(_0x2e7ad0[_0xccb2('0x37')][_0xccb2('0x43')]){_0x56fde8['where']=_[_0xccb2('0x44')](_0x56fde8['where'],{'$or':_[_0xccb2('0x31')](_0x56fde8[_0xccb2('0x3b')],function(_0x655204){var _0x3ed948={};_0x3ed948[_0x655204]={'$like':'%'+_0x2e7ad0[_0xccb2('0x37')][_0xccb2('0x43')]+'%'};return _0x3ed948;})});}_0x56fde8=_[_0xccb2('0x44')]({},_0x56fde8,_0x2e7ad0[_0xccb2('0x45')]);return _0x379682[_0xccb2('0x61')](_0x56fde8);}})[_0xccb2('0x28')](function(_0x3909b7){if(_0x3909b7){_0x497a10=_0x3909b7[_0xccb2('0x3d')];if(!_0x2e7ad0[_0xccb2('0x37')][_0xccb2('0x3e')]('nolimit')){_0x56fde8[_0xccb2('0x21')]=qs[_0xccb2('0x21')](_0x2e7ad0[_0xccb2('0x37')][_0xccb2('0x21')]);_0x56fde8[_0xccb2('0x20')]=qs['offset'](_0x2e7ad0[_0xccb2('0x37')][_0xccb2('0x20')]);}return _0x379682[_0xccb2('0x61')](_0x56fde8);}})[_0xccb2('0x28')](function(_0x395d64){if(_0x395d64){return _0x395d64?{'count':_0x497a10,'rows':_0x395d64}:null;}})[_0xccb2('0x28')](respondWithResult(_0x63dfdf,null))[_0xccb2('0x48')](handleError(_0x63dfdf,null));};exports[_0xccb2('0x63')]=function(_0x404715,_0x3026b3,_0x3a66a6){var _0x448219=_0x404715[_0xccb2('0x4d')][_0xccb2('0x64')];return db[_0xccb2('0x62')][_0xccb2('0x46')]({'where':{'id':_0x448219},'attributes':['id'],'include':[{'model':db['User'],'as':_0xccb2('0x65'),'attributes':['id',_0xccb2('0x2f'),_0xccb2('0x66'),_0xccb2('0x67'),_0xccb2('0x68')],'raw':!![]}]})['then'](function(_0x139a62){if(_0x139a62){var _0x3248b5=_['flatMap'](_0x139a62,function(_0x4dc89a){var _0xac2fca=_0x4dc89a[_0xccb2('0x29')]({'plain':!![]});return _0xac2fca[_0xccb2('0x65')];});return db['SmsQueue'][_0xccb2('0x4b')]({'where':{'id':_0x404715[_0xccb2('0x53')]['id']}})[_0xccb2('0x28')](function(_0x4ba73e){return db[_0xccb2('0x69')][_0xccb2('0x6a')](function(_0x318bd5){return _0x4ba73e[_0xccb2('0x63')](_0x448219,{'transaction':_0x318bd5})[_0xccb2('0x28')](function(){return BPromise['each'](_0x3248b5,function(_0x378e49){return db[_0xccb2('0x56')][_0xccb2('0x6b')]({'where':{'UserId':_0x378e49['id'],'SmsQueueId':_0x404715[_0xccb2('0x53')]['id']},'transaction':_0x318bd5});});})[_0xccb2('0x28')](function(){_0x3248b5[_0xccb2('0x6c')](function(_0x5b915a){socket[_0xccb2('0x6d')](_0xccb2('0x6e'),{'UserId':_0x5b915a['id'],'SmsQueueId':_0x4ba73e['id']});});});});});}})[_0xccb2('0x28')](respondWithStatusCode(_0x3026b3,null))['catch'](handleError(_0x3026b3,null));};exports[_0xccb2('0x6f')]=function(_0x57469f,_0x124647,_0x45113b){return db[_0xccb2('0x62')][_0xccb2('0x46')]({'where':{'id':_0x57469f[_0xccb2('0x37')][_0xccb2('0x64')]},'attributes':['id'],'include':[{'model':db[_0xccb2('0x59')],'as':'Agents','attributes':['id'],'raw':!![]}]})[_0xccb2('0x28')](handleEntityNotFound(_0x124647,null))[_0xccb2('0x28')](function(_0x21518a){var _0x36fead=_[_0xccb2('0x31')](_0x21518a,'id');var _0x277b83=[];var _0x228591=[];var _0x52bd64=squel['select']();_0x52bd64[_0xccb2('0x70')](_0xccb2('0x71'))['from'](_0xccb2('0x72'),'tq')[_0xccb2('0x73')](_0xccb2('0x74'),'ut',_0xccb2('0x75'))[_0xccb2('0x41')](_0xccb2('0x76'),_0x57469f[_0xccb2('0x53')]['id']);for(var _0x2962a1=0x0;_0x2962a1<_0x21518a['length'];_0x2962a1+=0x1){let _0x1b3b08=_0x21518a[_0x2962a1];for(var _0x1c284a=0x0;_0x1c284a<_0x1b3b08[_0xccb2('0x65')][_0xccb2('0x3d')];_0x1c284a+=0x1){let _0x84638e=_0x1b3b08[_0xccb2('0x65')][_0x1c284a];var _0x1af46c=_0x52bd64[_0xccb2('0x77')]();_0x1af46c['where'](_0xccb2('0x78'),_0x84638e['id']);_0x228591[_0xccb2('0x79')](db[_0xccb2('0x69')][_0xccb2('0x37')](_0x1af46c[_0xccb2('0x7a')](),{'type':db['sequelize'][_0xccb2('0x7b')]['SELECT']})['then'](function(_0x53895b){if(_0x53895b[_0xccb2('0x3d')]===0x1){return _0x84638e['id'];}else{var _0x4e784f=_['every'](_[_0xccb2('0x31')](_0x53895b,'TeamId'),function(_0x33ed11){return _[_0xccb2('0x7c')](_0x36fead,_0x33ed11);});if(_0x4e784f){return _0x84638e['id'];}}}));}}return BPromise['all'](_0x228591)['then'](function(_0x3ad8b3){_0x277b83=_(_0x277b83)[_0xccb2('0x7d')](_0x3ad8b3)[_0xccb2('0x7e')]()[_0xccb2('0x7f')]();return db[_0xccb2('0x32')][_0xccb2('0x4b')]({'where':{'id':_0x57469f[_0xccb2('0x53')]['id']}})['then'](function(_0x8d0a8e){return db[_0xccb2('0x69')][_0xccb2('0x6a')](function(_0x3bae2f){return _0x8d0a8e[_0xccb2('0x6f')](_0x57469f[_0xccb2('0x37')][_0xccb2('0x64')],{'transaction':_0x3bae2f})[_0xccb2('0x28')](function(){if(!_[_0xccb2('0x80')](_0x277b83)){return _0x8d0a8e[_0xccb2('0x81')](_0x277b83,{'transaction':_0x3bae2f});}})[_0xccb2('0x28')](function(){_0x277b83[_0xccb2('0x6c')](function(_0x1c88a2){socket[_0xccb2('0x6d')]('userSmsQueue:remove',{'UserId':_0x1c88a2,'SmsQueueId':_0x8d0a8e['id']});});});});});});})[_0xccb2('0x28')](respondWithStatusCode(_0x124647,null))[_0xccb2('0x48')](handleError(_0x124647,null));};exports[_0xccb2('0x82')]=function(_0x37a04a,_0x49ea59,_0x47268e){return db['SmsQueue']['find']({'where':{'id':_0x37a04a[_0xccb2('0x53')]['id']}})[_0xccb2('0x28')](handleEntityNotFound(_0x49ea59,null))[_0xccb2('0x28')](function(_0x16941f){if(_0x16941f){return _0x16941f[_0xccb2('0x82')](_0x37a04a[_0xccb2('0x4d')][_0xccb2('0x64')],_[_0xccb2('0x83')](_0x37a04a[_0xccb2('0x4d')],[_0xccb2('0x64'),'id'])||{})['spread'](function(_0x17cc7d){for(var _0x4e5453=0x0;_0x4e5453<_0x37a04a[_0xccb2('0x4d')][_0xccb2('0x64')][_0xccb2('0x3d')];_0x4e5453+=0x1){socket['emit']('userSmsQueue:save',{'UserId':Number(_0x37a04a[_0xccb2('0x4d')][_0xccb2('0x64')][_0x4e5453]),'SmsQueueId':Number(_0x37a04a['params']['id'])});}return _0x17cc7d;});}})['then'](respondWithResult(_0x49ea59,null))[_0xccb2('0x48')](handleError(_0x49ea59,null));};exports[_0xccb2('0x81')]=function(_0x9421b9,_0xc54594,_0x557cc8){return db[_0xccb2('0x32')]['find']({'where':{'id':_0x9421b9[_0xccb2('0x53')]['id']}})[_0xccb2('0x28')](handleEntityNotFound(_0xc54594,null))['then'](function(_0x3538ad){if(_0x3538ad){return _0x3538ad['removeAgents'](_0x9421b9[_0xccb2('0x37')][_0xccb2('0x64')])['then'](function(){if(_[_0xccb2('0x84')](_0x9421b9[_0xccb2('0x37')][_0xccb2('0x64')])){for(var _0x206878=0x0;_0x206878<_0x9421b9[_0xccb2('0x37')][_0xccb2('0x64')][_0xccb2('0x3d')];_0x206878+=0x1){socket[_0xccb2('0x6d')](_0xccb2('0x85'),{'UserId':Number(_0x9421b9[_0xccb2('0x37')][_0xccb2('0x64')][_0x206878]),'SmsQueueId':Number(_0x9421b9[_0xccb2('0x53')]['id'])});}}else{socket[_0xccb2('0x6d')](_0xccb2('0x85'),{'UserId':Number(_0x9421b9['query'][_0xccb2('0x64')]),'SmsQueueId':Number(_0x9421b9[_0xccb2('0x53')]['id'])});}});}})['then'](respondWithStatusCode(_0xc54594,null))['catch'](handleError(_0xc54594,null));};exports[_0xccb2('0x86')]=function(_0x4f94d3,_0x4573c4,_0x278397){var _0x2dba12={};var _0x29eb88={};var _0x4a5879;var _0x3cc5ad;return db[_0xccb2('0x32')][_0xccb2('0x55')]({'where':{'id':_0x4f94d3[_0xccb2('0x53')]['id']}})['then'](handleEntityNotFound(_0x4573c4,null))['then'](function(_0x523190){if(_0x523190){_0x4a5879=_0x523190;_0x29eb88['model']=_[_0xccb2('0x38')](db[_0xccb2('0x59')][_0xccb2('0x33')]);_0x29eb88['query']=_[_0xccb2('0x38')](_0x4f94d3['query']);_0x29eb88[_0xccb2('0x39')]=_[_0xccb2('0x3a')](_0x29eb88[_0xccb2('0x36')],_0x29eb88[_0xccb2('0x37')]);_0x2dba12[_0xccb2('0x3b')]=_[_0xccb2('0x3a')](_0x29eb88[_0xccb2('0x36')],qs[_0xccb2('0x3c')](_0x4f94d3['query'][_0xccb2('0x3c')]));_0x2dba12[_0xccb2('0x3b')]=_0x2dba12[_0xccb2('0x3b')]['length']?_0x2dba12['attributes']:_0x29eb88[_0xccb2('0x36')];_0x2dba12['order']=qs[_0xccb2('0x40')](_0x4f94d3[_0xccb2('0x37')][_0xccb2('0x40')]);_0x2dba12['where']=qs['filters'](_[_0xccb2('0x42')](_0x4f94d3[_0xccb2('0x37')],_0x29eb88[_0xccb2('0x39')]));if(_0x4f94d3[_0xccb2('0x37')][_0xccb2('0x43')]){_0x2dba12['where']=_[_0xccb2('0x44')](_0x2dba12[_0xccb2('0x41')],{'$or':_[_0xccb2('0x31')](_0x2dba12['attributes'],function(_0x2aae08){var _0x4d1acd={};_0x4d1acd[_0x2aae08]={'$like':'%'+_0x4f94d3['query'][_0xccb2('0x43')]+'%'};return _0x4d1acd;})});}_0x2dba12=_[_0xccb2('0x44')]({},_0x2dba12,_0x4f94d3[_0xccb2('0x45')]);return _0x4a5879[_0xccb2('0x86')](_0x2dba12);}})[_0xccb2('0x28')](function(_0x3aef3a){if(_0x3aef3a){_0x3cc5ad=_0x3aef3a[_0xccb2('0x3d')];if(!_0x4f94d3[_0xccb2('0x37')][_0xccb2('0x3e')](_0xccb2('0x3f'))){_0x2dba12[_0xccb2('0x21')]=qs['limit'](_0x4f94d3[_0xccb2('0x37')]['limit']);_0x2dba12[_0xccb2('0x20')]=qs['offset'](_0x4f94d3['query']['offset']);}return _0x4a5879[_0xccb2('0x86')](_0x2dba12);}})['then'](function(_0x2c49a6){if(_0x2c49a6){return _0x2c49a6?{'count':_0x3cc5ad,'rows':_0x2c49a6}:null;}})[_0xccb2('0x28')](respondWithResult(_0x4573c4,null))[_0xccb2('0x48')](handleError(_0x4573c4,null));};