Built motion from commit 1fa89557.|2.6.10
[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 _0x3d3d=['flatMap','transaction','findOrCreate','forEach','emit','select','field','tq.TeamId','join','user_has_teams','SmsQueueId\x20=\x20?','clone','push','sequelize','toString','QueryTypes','every','TeamId','union','value','removeTeams','isEmpty','removeAgents','userSmsQueue:remove','addAgents','omit','spread','isArray','getAgents','findOne','rimraf','zip-dir','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','localhost','./smsQueue.socket','register','status','end','json','offset','undefined','count','limit','set','Content-Range','apply','reject','save','update','then','destroy','get','SmsQueues','UserProfileResource','sendStatus','error','stack','name','send','index','map','SmsQueue','rawAttributes','fieldName','key','keys','filters','intersection','model','query','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','options','includeAll','include','rows','catch','params','find','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','body','describe','getMembers','UserSmsQueue','findAll','User','findAndCountAll','UserId','agent','updatedAt','createdAt','format','%s/%s','SIP','getTeams','Team','addTeams','ids','Agents','voicePause','interface'];(function(_0x459409,_0x185644){var _0xf51da4=function(_0x5981e4){while(--_0x5981e4){_0x459409['push'](_0x459409['shift']());}};_0xf51da4(++_0x185644);}(_0x3d3d,0xab));var _0xd3d3=function(_0x3dd15e,_0x1f0015){_0x3dd15e=_0x3dd15e-0x0;var _0x231fd0=_0x3d3d[_0x3dd15e];return _0x231fd0;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0xd3d3('0x0'));var zipdir=require(_0xd3d3('0x1'));var jsonpatch=require('fast-json-patch');var rp=require(_0xd3d3('0x2'));var moment=require(_0xd3d3('0x3'));var BPromise=require(_0xd3d3('0x4'));var Mustache=require(_0xd3d3('0x5'));var util=require(_0xd3d3('0x6'));var path=require(_0xd3d3('0x7'));var sox=require(_0xd3d3('0x8'));var csv=require(_0xd3d3('0x9'));var ejs=require(_0xd3d3('0xa'));var fs=require('fs');var fs_extra=require(_0xd3d3('0xb'));var _=require('lodash');var squel=require(_0xd3d3('0xc'));var crypto=require(_0xd3d3('0xd'));var jsforce=require(_0xd3d3('0xe'));var deskjs=require(_0xd3d3('0xf'));var toCsv=require('to-csv');var querystring=require(_0xd3d3('0x10'));var Papa=require(_0xd3d3('0x11'));var Redis=require(_0xd3d3('0x12'));var authService=require(_0xd3d3('0x13'));var qs=require('../../components/parsers/qs');var as=require(_0xd3d3('0x14'));var hardwareService=require(_0xd3d3('0x15'));var logger=require(_0xd3d3('0x16'))(_0xd3d3('0x17'));var utils=require(_0xd3d3('0x18'));var config=require(_0xd3d3('0x19'));var licenseUtil=require('../../config/license/util');var db=require(_0xd3d3('0x1a'))['db'];config['redis']=_['defaults'](config['redis'],{'host':_0xd3d3('0x1b'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config['redis']));require(_0xd3d3('0x1c'))[_0xd3d3('0x1d')](socket);function respondWithStatusCode(_0x532ee7,_0xefb6ba){_0xefb6ba=_0xefb6ba||0xcc;return function(_0x5419a0){if(_0x5419a0){return _0x532ee7['sendStatus'](_0xefb6ba);}return _0x532ee7[_0xd3d3('0x1e')](_0xefb6ba)[_0xd3d3('0x1f')]();};}function respondWithResult(_0xdced00,_0x1698de){_0x1698de=_0x1698de||0xc8;return function(_0x393b3d){if(_0x393b3d){return _0xdced00['status'](_0x1698de)[_0xd3d3('0x20')](_0x393b3d);}};}function respondWithFilteredResult(_0xa9ce6c,_0x4b663a){return function(_0x4c18e3){if(_0x4c18e3){var _0xd369a3=typeof _0x4b663a[_0xd3d3('0x21')]===_0xd3d3('0x22')&&typeof _0x4b663a['limit']===_0xd3d3('0x22');var _0x37fc96=_0x4c18e3[_0xd3d3('0x23')];var _0x5273ca=_0xd369a3?0x0:_0x4b663a[_0xd3d3('0x21')];var _0x15d155=_0xd369a3?_0x4c18e3[_0xd3d3('0x23')]:_0x4b663a['offset']+_0x4b663a[_0xd3d3('0x24')];var _0x53ac55;if(_0x15d155>=_0x37fc96){_0x15d155=_0x37fc96;_0x53ac55=0xc8;}else{_0x53ac55=0xce;}_0xa9ce6c['status'](_0x53ac55);return _0xa9ce6c[_0xd3d3('0x25')](_0xd3d3('0x26'),_0x5273ca+'-'+_0x15d155+'/'+_0x37fc96)[_0xd3d3('0x20')](_0x4c18e3);}return null;};}function patchUpdates(_0x1330a1){return function(_0x4b1e6d){try{jsonpatch[_0xd3d3('0x27')](_0x4b1e6d,_0x1330a1,!![]);}catch(_0x65b986){return BPromise[_0xd3d3('0x28')](_0x65b986);}return _0x4b1e6d[_0xd3d3('0x29')]();};}function saveUpdates(_0x4130cb,_0xc98ae6){return function(_0x94bc1e){if(_0x94bc1e){return _0x94bc1e[_0xd3d3('0x2a')](_0x4130cb)[_0xd3d3('0x2b')](function(_0x1cb091){return _0x1cb091;});}return null;};}function removeEntity(_0x323829,_0x2a2149){return function(_0x48ab7c){if(_0x48ab7c){return _0x48ab7c[_0xd3d3('0x2c')]()['then'](function(){var _0x400a14=_0x48ab7c[_0xd3d3('0x2d')]({'plain':!![]});var _0x499da7=_0xd3d3('0x2e');return db[_0xd3d3('0x2f')][_0xd3d3('0x2c')]({'where':{'type':_0x499da7,'resourceId':_0x400a14['id']}})['then'](function(){return _0x48ab7c;});})[_0xd3d3('0x2b')](function(){_0x323829[_0xd3d3('0x1e')](0xcc)[_0xd3d3('0x1f')]();});}};}function handleEntityNotFound(_0x5b58d7,_0x47688a){return function(_0x263054){if(!_0x263054){_0x5b58d7[_0xd3d3('0x30')](0x194);}return _0x263054;};}function handleError(_0x349fad,_0xd5ad91){_0xd5ad91=_0xd5ad91||0x1f4;return function(_0x230be5){logger[_0xd3d3('0x31')](_0x230be5[_0xd3d3('0x32')]);if(_0x230be5[_0xd3d3('0x33')]){delete _0x230be5[_0xd3d3('0x33')];}_0x349fad[_0xd3d3('0x1e')](_0xd5ad91)[_0xd3d3('0x34')](_0x230be5);};}exports[_0xd3d3('0x35')]=function(_0x3c05bc,_0x56afd4){var _0x58311d={},_0x2337a8={},_0x4007de={'count':0x0,'rows':[]};var _0x50be0b=_[_0xd3d3('0x36')](db[_0xd3d3('0x37')][_0xd3d3('0x38')],function(_0x3c0832){return{'name':_0x3c0832[_0xd3d3('0x39')],'type':_0x3c0832['type'][_0xd3d3('0x3a')]};});_0x2337a8['model']=_['map'](_0x50be0b,_0xd3d3('0x33'));_0x2337a8['query']=_[_0xd3d3('0x3b')](_0x3c05bc['query']);_0x2337a8[_0xd3d3('0x3c')]=_[_0xd3d3('0x3d')](_0x2337a8[_0xd3d3('0x3e')],_0x2337a8[_0xd3d3('0x3f')]);_0x58311d[_0xd3d3('0x40')]=_['intersection'](_0x2337a8[_0xd3d3('0x3e')],qs[_0xd3d3('0x41')](_0x3c05bc[_0xd3d3('0x3f')][_0xd3d3('0x41')]));_0x58311d[_0xd3d3('0x40')]=_0x58311d[_0xd3d3('0x40')][_0xd3d3('0x42')]?_0x58311d[_0xd3d3('0x40')]:_0x2337a8[_0xd3d3('0x3e')];if(!_0x3c05bc['query'][_0xd3d3('0x43')](_0xd3d3('0x44'))){_0x58311d[_0xd3d3('0x24')]=qs[_0xd3d3('0x24')](_0x3c05bc[_0xd3d3('0x3f')]['limit']);_0x58311d['offset']=qs[_0xd3d3('0x21')](_0x3c05bc[_0xd3d3('0x3f')]['offset']);}_0x58311d[_0xd3d3('0x45')]=qs[_0xd3d3('0x46')](_0x3c05bc[_0xd3d3('0x3f')][_0xd3d3('0x46')]);_0x58311d[_0xd3d3('0x47')]=qs[_0xd3d3('0x3c')](_[_0xd3d3('0x48')](_0x3c05bc['query'],_0x2337a8[_0xd3d3('0x3c')]),_0x50be0b);if(_0x3c05bc[_0xd3d3('0x3f')][_0xd3d3('0x49')]){_0x58311d[_0xd3d3('0x47')]=_[_0xd3d3('0x4a')](_0x58311d['where'],{'$or':_['map'](_0x50be0b,function(_0x5b2d86){if(_0x5b2d86['type']!=='VIRTUAL'){var _0x57d151={};_0x57d151[_0x5b2d86['name']]={'$like':'%'+_0x3c05bc['query'][_0xd3d3('0x49')]+'%'};return _0x57d151;}})});}_0x58311d=_[_0xd3d3('0x4a')]({},_0x58311d,_0x3c05bc[_0xd3d3('0x4b')]);var _0x3da4de={'where':_0x58311d['where']};return db['SmsQueue']['count'](_0x3da4de)[_0xd3d3('0x2b')](function(_0x546d86){_0x4007de[_0xd3d3('0x23')]=_0x546d86;if(_0x3c05bc[_0xd3d3('0x3f')][_0xd3d3('0x4c')]){_0x58311d[_0xd3d3('0x4d')]=[{'all':!![]}];}return db[_0xd3d3('0x37')]['findAll'](_0x58311d);})[_0xd3d3('0x2b')](function(_0x534a5e){_0x4007de[_0xd3d3('0x4e')]=_0x534a5e;return _0x4007de;})['then'](respondWithFilteredResult(_0x56afd4,_0x58311d))[_0xd3d3('0x4f')](handleError(_0x56afd4,null));};exports['show']=function(_0x31d422,_0x203c11){var _0x547240={'raw':!![],'where':{'id':_0x31d422[_0xd3d3('0x50')]['id']}},_0x595eff={};_0x595eff['model']=_[_0xd3d3('0x3b')](db[_0xd3d3('0x37')][_0xd3d3('0x38')]);_0x595eff[_0xd3d3('0x3f')]=_[_0xd3d3('0x3b')](_0x31d422['query']);_0x595eff[_0xd3d3('0x3c')]=_[_0xd3d3('0x3d')](_0x595eff['model'],_0x595eff['query']);_0x547240[_0xd3d3('0x40')]=_[_0xd3d3('0x3d')](_0x595eff[_0xd3d3('0x3e')],qs[_0xd3d3('0x41')](_0x31d422[_0xd3d3('0x3f')][_0xd3d3('0x41')]));_0x547240['attributes']=_0x547240[_0xd3d3('0x40')][_0xd3d3('0x42')]?_0x547240[_0xd3d3('0x40')]:_0x595eff[_0xd3d3('0x3e')];if(_0x31d422['query'][_0xd3d3('0x4c')]){_0x547240[_0xd3d3('0x4d')]=[{'all':!![]}];}_0x547240=_[_0xd3d3('0x4a')]({},_0x547240,_0x31d422[_0xd3d3('0x4b')]);return db[_0xd3d3('0x37')][_0xd3d3('0x51')](_0x547240)[_0xd3d3('0x2b')](handleEntityNotFound(_0x203c11,null))[_0xd3d3('0x2b')](respondWithResult(_0x203c11,null))[_0xd3d3('0x4f')](handleError(_0x203c11,null));};exports[_0xd3d3('0x52')]=function(_0x41493d,_0x368aa6){return db['SmsQueue'][_0xd3d3('0x52')](_0x41493d['body'],{})[_0xd3d3('0x2b')](function(_0x1f4b17){var _0x399f79=_0x41493d[_0xd3d3('0x53')]['get']({'plain':!![]});if(!_0x399f79)throw new Error(_0xd3d3('0x54'));if(_0x399f79[_0xd3d3('0x55')]===_0xd3d3('0x53')){var _0x3ba97c=_0x1f4b17[_0xd3d3('0x2d')]({'plain':!![]});var _0x2ad450='SmsQueues';return db[_0xd3d3('0x56')][_0xd3d3('0x51')]({'where':{'name':_0x2ad450,'userProfileId':_0x399f79[_0xd3d3('0x57')]},'raw':!![]})[_0xd3d3('0x2b')](function(_0x26da9c){if(_0x26da9c&&_0x26da9c[_0xd3d3('0x58')]===0x0){return db[_0xd3d3('0x2f')][_0xd3d3('0x52')]({'name':_0x3ba97c[_0xd3d3('0x33')],'resourceId':_0x3ba97c['id'],'type':_0x26da9c['name'],'sectionId':_0x26da9c['id']},{})['then'](function(){return _0x1f4b17;});}else{return _0x1f4b17;}})['catch'](function(_0x252023){logger[_0xd3d3('0x31')](_0xd3d3('0x59'),_0x252023);throw _0x252023;});}return _0x1f4b17;})[_0xd3d3('0x2b')](respondWithResult(_0x368aa6,0xc9))[_0xd3d3('0x4f')](handleError(_0x368aa6,null));};exports['update']=function(_0x1c5977,_0xd85d58){if(_0x1c5977[_0xd3d3('0x5a')]['id']){delete _0x1c5977['body']['id'];}return db[_0xd3d3('0x37')]['find']({'where':{'id':_0x1c5977[_0xd3d3('0x50')]['id']}})['then'](handleEntityNotFound(_0xd85d58,null))[_0xd3d3('0x2b')](saveUpdates(_0x1c5977[_0xd3d3('0x5a')],null))[_0xd3d3('0x2b')](respondWithResult(_0xd85d58,null))[_0xd3d3('0x4f')](handleError(_0xd85d58,null));};exports[_0xd3d3('0x2c')]=function(_0x56e357,_0x2ad6b5){return db['SmsQueue'][_0xd3d3('0x51')]({'where':{'id':_0x56e357[_0xd3d3('0x50')]['id']}})['then'](handleEntityNotFound(_0x2ad6b5,null))[_0xd3d3('0x2b')](removeEntity(_0x2ad6b5,null))[_0xd3d3('0x4f')](handleError(_0x2ad6b5,null));};exports[_0xd3d3('0x5b')]=function(_0xfb1ca7,_0x4f21ab){return db[_0xd3d3('0x37')][_0xd3d3('0x5b')]()[_0xd3d3('0x2b')](respondWithResult(_0x4f21ab,null))['catch'](handleError(_0x4f21ab,null));};exports[_0xd3d3('0x5c')]=function(_0x42186f,_0x1e3d45,_0x456bc9){var _0x7656fc={'raw':!![],'where':{}},_0x24d4e4={},_0x19e28e;return db['SmsQueue']['findOne']({'where':{'id':_0x42186f[_0xd3d3('0x50')]['id']}})[_0xd3d3('0x2b')](handleEntityNotFound(_0x1e3d45,null))[_0xd3d3('0x2b')](function(_0x53af9a){if(_0x53af9a){_0x19e28e=_0x53af9a[_0xd3d3('0x2d')]({'plain':!![]});_0x24d4e4[_0xd3d3('0x3e')]=_[_0xd3d3('0x3b')](db['UserSmsQueue'][_0xd3d3('0x38')]);_0x24d4e4['query']=_[_0xd3d3('0x3b')](_0x42186f['query']);_0x24d4e4['filters']=_[_0xd3d3('0x3d')](_0x24d4e4[_0xd3d3('0x3e')],_0x24d4e4[_0xd3d3('0x3f')]);_0x7656fc[_0xd3d3('0x40')]=_[_0xd3d3('0x3d')](_0x24d4e4[_0xd3d3('0x3e')],qs[_0xd3d3('0x41')](_0x42186f[_0xd3d3('0x3f')][_0xd3d3('0x41')]));_0x7656fc[_0xd3d3('0x40')]=_0x7656fc[_0xd3d3('0x40')][_0xd3d3('0x42')]?_0x7656fc[_0xd3d3('0x40')]:_0x24d4e4[_0xd3d3('0x3e')];if(!_0x42186f[_0xd3d3('0x3f')][_0xd3d3('0x43')](_0xd3d3('0x44'))){_0x7656fc[_0xd3d3('0x24')]=qs[_0xd3d3('0x24')](_0x42186f[_0xd3d3('0x3f')][_0xd3d3('0x24')]);_0x7656fc[_0xd3d3('0x21')]=qs[_0xd3d3('0x21')](_0x42186f[_0xd3d3('0x3f')][_0xd3d3('0x21')]);}_0x7656fc['order']=qs['sort'](_0x42186f['query']['sort']);_0x7656fc[_0xd3d3('0x47')]=qs['filters'](_[_0xd3d3('0x48')](_0x42186f['query'],_0x24d4e4['filters']));_0x7656fc[_0xd3d3('0x47')]['SmsQueueId']=_0x53af9a['id'];if(_0x42186f[_0xd3d3('0x3f')][_0xd3d3('0x49')]){_0x7656fc[_0xd3d3('0x47')]=_['merge'](_0x7656fc[_0xd3d3('0x47')],{'$or':_[_0xd3d3('0x36')](_0x7656fc[_0xd3d3('0x40')],function(_0x1f55b3){var _0x5019e2={};_0x5019e2[_0x1f55b3]={'$like':'%'+_0x42186f[_0xd3d3('0x3f')][_0xd3d3('0x49')]+'%'};return _0x5019e2;})});}_0x7656fc=_[_0xd3d3('0x4a')]({},_0x7656fc,_0x42186f[_0xd3d3('0x4b')]);return db[_0xd3d3('0x5d')][_0xd3d3('0x5e')](_0x7656fc);}})[_0xd3d3('0x2b')](function(_0x4c3298){if(_0x4c3298){return db[_0xd3d3('0x5f')][_0xd3d3('0x60')]({'where':{'id':_[_0xd3d3('0x36')](_0x4c3298,_0xd3d3('0x61')),'role':_0xd3d3('0x62')},'attributes':['id','name','smsPause',_0xd3d3('0x63'),_0xd3d3('0x64')]});}})[_0xd3d3('0x2b')](function(_0x26a4a0){if(_0x26a4a0){return{'count':_0x26a4a0['count'],'rows':_[_0xd3d3('0x36')](_0x26a4a0['rows'],function(_0x874d8d){return{'membername':_0x874d8d[_0xd3d3('0x33')],'UserId':_0x874d8d['id'],'queue_name':_0x19e28e[_0xd3d3('0x33')],'SmsQueueId':_0x19e28e['id'],'interface':util[_0xd3d3('0x65')](_0xd3d3('0x66'),_0xd3d3('0x67'),_0x874d8d[_0xd3d3('0x33')]),'penalty':0x0,'paused':_0x874d8d['smsPause'],'createdAt':_0x874d8d[_0xd3d3('0x64')],'updatedAt':_0x874d8d['updatedAt']};})};}else{return{'count':0x0,'rows':[]};}})[_0xd3d3('0x2b')](respondWithFilteredResult(_0x1e3d45,_0x7656fc))[_0xd3d3('0x4f')](handleError(_0x1e3d45,null));};exports[_0xd3d3('0x68')]=function(_0x567bc1,_0x520073,_0xf8919c){var _0x1b32a1={};var _0x33bdb8={};var _0x191cc9;var _0x5191d3;return db[_0xd3d3('0x37')]['findOne']({'where':{'id':_0x567bc1[_0xd3d3('0x50')]['id']}})[_0xd3d3('0x2b')](handleEntityNotFound(_0x520073,null))['then'](function(_0x366e54){if(_0x366e54){_0x191cc9=_0x366e54;_0x33bdb8[_0xd3d3('0x3e')]=_[_0xd3d3('0x3b')](db[_0xd3d3('0x69')]['rawAttributes']);_0x33bdb8[_0xd3d3('0x3f')]=_['keys'](_0x567bc1[_0xd3d3('0x3f')]);_0x33bdb8['filters']=_[_0xd3d3('0x3d')](_0x33bdb8[_0xd3d3('0x3e')],_0x33bdb8['query']);_0x1b32a1[_0xd3d3('0x40')]=_[_0xd3d3('0x3d')](_0x33bdb8[_0xd3d3('0x3e')],qs['fields'](_0x567bc1[_0xd3d3('0x3f')]['fields']));_0x1b32a1[_0xd3d3('0x40')]=_0x1b32a1[_0xd3d3('0x40')]['length']?_0x1b32a1[_0xd3d3('0x40')]:_0x33bdb8[_0xd3d3('0x3e')];_0x1b32a1[_0xd3d3('0x45')]=qs[_0xd3d3('0x46')](_0x567bc1[_0xd3d3('0x3f')][_0xd3d3('0x46')]);_0x1b32a1['where']=qs[_0xd3d3('0x3c')](_[_0xd3d3('0x48')](_0x567bc1[_0xd3d3('0x3f')],_0x33bdb8[_0xd3d3('0x3c')]));if(_0x567bc1['query'][_0xd3d3('0x49')]){_0x1b32a1[_0xd3d3('0x47')]=_['merge'](_0x1b32a1[_0xd3d3('0x47')],{'$or':_['map'](_0x1b32a1[_0xd3d3('0x40')],function(_0x1e72e6){var _0x2a0c90={};_0x2a0c90[_0x1e72e6]={'$like':'%'+_0x567bc1[_0xd3d3('0x3f')]['filter']+'%'};return _0x2a0c90;})});}_0x1b32a1=_[_0xd3d3('0x4a')]({},_0x1b32a1,_0x567bc1[_0xd3d3('0x4b')]);return _0x191cc9[_0xd3d3('0x68')](_0x1b32a1);}})['then'](function(_0x1bf958){if(_0x1bf958){_0x5191d3=_0x1bf958[_0xd3d3('0x42')];if(!_0x567bc1[_0xd3d3('0x3f')][_0xd3d3('0x43')]('nolimit')){_0x1b32a1['limit']=qs[_0xd3d3('0x24')](_0x567bc1[_0xd3d3('0x3f')]['limit']);_0x1b32a1[_0xd3d3('0x21')]=qs[_0xd3d3('0x21')](_0x567bc1[_0xd3d3('0x3f')][_0xd3d3('0x21')]);}return _0x191cc9[_0xd3d3('0x68')](_0x1b32a1);}})['then'](function(_0x1a0f18){if(_0x1a0f18){return _0x1a0f18?{'count':_0x5191d3,'rows':_0x1a0f18}:null;}})['then'](respondWithResult(_0x520073,null))['catch'](handleError(_0x520073,null));};exports[_0xd3d3('0x6a')]=function(_0x185a56,_0x2c0017,_0x2385ba){var _0x404a54=_0x185a56[_0xd3d3('0x5a')][_0xd3d3('0x6b')];return db[_0xd3d3('0x69')][_0xd3d3('0x5e')]({'where':{'id':_0x404a54},'attributes':['id'],'include':[{'model':db[_0xd3d3('0x5f')],'as':_0xd3d3('0x6c'),'attributes':['id',_0xd3d3('0x33'),'online',_0xd3d3('0x6d'),_0xd3d3('0x6e')],'raw':!![]}]})[_0xd3d3('0x2b')](function(_0x9de526){if(_0x9de526){var _0x2cd11e=_[_0xd3d3('0x6f')](_0x9de526,function(_0x343e04){var _0xa21f7a=_0x343e04['get']({'plain':!![]});return _0xa21f7a[_0xd3d3('0x6c')];});return db[_0xd3d3('0x37')][_0xd3d3('0x51')]({'where':{'id':_0x185a56[_0xd3d3('0x50')]['id']}})[_0xd3d3('0x2b')](function(_0xc7aec7){return db['sequelize'][_0xd3d3('0x70')](function(_0x16c137){return _0xc7aec7[_0xd3d3('0x6a')](_0x404a54,{'transaction':_0x16c137})[_0xd3d3('0x2b')](function(){return BPromise['each'](_0x2cd11e,function(_0x58204f){return db[_0xd3d3('0x5d')][_0xd3d3('0x71')]({'where':{'UserId':_0x58204f['id'],'SmsQueueId':_0x185a56[_0xd3d3('0x50')]['id']},'transaction':_0x16c137});});})[_0xd3d3('0x2b')](function(){_0x2cd11e[_0xd3d3('0x72')](function(_0x570455){socket[_0xd3d3('0x73')]('userSmsQueue:save',{'UserId':_0x570455['id'],'SmsQueueId':_0xc7aec7['id']});});});});});}})[_0xd3d3('0x2b')](respondWithStatusCode(_0x2c0017,null))[_0xd3d3('0x4f')](handleError(_0x2c0017,null));};exports['removeTeams']=function(_0x459d64,_0x38e9fd,_0x321c83){return db[_0xd3d3('0x69')][_0xd3d3('0x5e')]({'where':{'id':_0x459d64['query'][_0xd3d3('0x6b')]},'attributes':['id'],'include':[{'model':db['User'],'as':_0xd3d3('0x6c'),'attributes':['id'],'raw':!![]}]})['then'](handleEntityNotFound(_0x38e9fd,null))['then'](function(_0x31ce96){var _0x32d95b=_[_0xd3d3('0x36')](_0x31ce96,'id');var _0xfb41ed=[];var _0x1e04b9=[];var _0x140ef1=squel[_0xd3d3('0x74')]();_0x140ef1[_0xd3d3('0x75')](_0xd3d3('0x76'))['from']('team_has_sms_queues','tq')[_0xd3d3('0x77')](_0xd3d3('0x78'),'ut','ut.TeamId\x20=\x20tq.TeamId')[_0xd3d3('0x47')](_0xd3d3('0x79'),_0x459d64['params']['id']);for(var _0x2fffe6=0x0;_0x2fffe6<_0x31ce96['length'];_0x2fffe6+=0x1){let _0xc8e97=_0x31ce96[_0x2fffe6];for(var _0x23d34c=0x0;_0x23d34c<_0xc8e97[_0xd3d3('0x6c')][_0xd3d3('0x42')];_0x23d34c+=0x1){let _0x3aee83=_0xc8e97[_0xd3d3('0x6c')][_0x23d34c];var _0x578c33=_0x140ef1[_0xd3d3('0x7a')]();_0x578c33[_0xd3d3('0x47')]('ut.UserId\x20=\x20?',_0x3aee83['id']);_0x1e04b9[_0xd3d3('0x7b')](db[_0xd3d3('0x7c')][_0xd3d3('0x3f')](_0x578c33[_0xd3d3('0x7d')](),{'type':db[_0xd3d3('0x7c')][_0xd3d3('0x7e')]['SELECT']})[_0xd3d3('0x2b')](function(_0x2335b6){if(_0x2335b6[_0xd3d3('0x42')]===0x1){return _0x3aee83['id'];}else{var _0x49b1c3=_[_0xd3d3('0x7f')](_['map'](_0x2335b6,_0xd3d3('0x80')),function(_0x31ae99){return _['includes'](_0x32d95b,_0x31ae99);});if(_0x49b1c3){return _0x3aee83['id'];}}}));}}return BPromise['all'](_0x1e04b9)[_0xd3d3('0x2b')](function(_0x50006c){_0xfb41ed=_(_0xfb41ed)[_0xd3d3('0x81')](_0x50006c)['compact']()[_0xd3d3('0x82')]();return db[_0xd3d3('0x37')]['find']({'where':{'id':_0x459d64[_0xd3d3('0x50')]['id']}})[_0xd3d3('0x2b')](function(_0x46e3fa){return db[_0xd3d3('0x7c')]['transaction'](function(_0x29f2e7){return _0x46e3fa[_0xd3d3('0x83')](_0x459d64['query'][_0xd3d3('0x6b')],{'transaction':_0x29f2e7})[_0xd3d3('0x2b')](function(){if(!_[_0xd3d3('0x84')](_0xfb41ed)){return _0x46e3fa[_0xd3d3('0x85')](_0xfb41ed,{'transaction':_0x29f2e7});}})[_0xd3d3('0x2b')](function(){_0xfb41ed[_0xd3d3('0x72')](function(_0x262e0b){socket[_0xd3d3('0x73')](_0xd3d3('0x86'),{'UserId':_0x262e0b,'SmsQueueId':_0x46e3fa['id']});});});});});});})[_0xd3d3('0x2b')](respondWithStatusCode(_0x38e9fd,null))[_0xd3d3('0x4f')](handleError(_0x38e9fd,null));};exports[_0xd3d3('0x87')]=function(_0x292408,_0x440004,_0x167add){return db[_0xd3d3('0x37')]['find']({'where':{'id':_0x292408[_0xd3d3('0x50')]['id']}})[_0xd3d3('0x2b')](handleEntityNotFound(_0x440004,null))['then'](function(_0x2bd181){if(_0x2bd181){return _0x2bd181[_0xd3d3('0x87')](_0x292408['body'][_0xd3d3('0x6b')],_[_0xd3d3('0x88')](_0x292408[_0xd3d3('0x5a')],[_0xd3d3('0x6b'),'id'])||{})[_0xd3d3('0x89')](function(_0x488ec7){for(var _0x2121c5=0x0;_0x2121c5<_0x292408[_0xd3d3('0x5a')][_0xd3d3('0x6b')][_0xd3d3('0x42')];_0x2121c5+=0x1){socket['emit']('userSmsQueue:save',{'UserId':Number(_0x292408[_0xd3d3('0x5a')]['ids'][_0x2121c5]),'SmsQueueId':Number(_0x292408[_0xd3d3('0x50')]['id'])});}return _0x488ec7;});}})[_0xd3d3('0x2b')](respondWithResult(_0x440004,null))[_0xd3d3('0x4f')](handleError(_0x440004,null));};exports['removeAgents']=function(_0x547b8d,_0x5f518d,_0x5ce1e6){return db[_0xd3d3('0x37')][_0xd3d3('0x51')]({'where':{'id':_0x547b8d['params']['id']}})['then'](handleEntityNotFound(_0x5f518d,null))[_0xd3d3('0x2b')](function(_0x27cf21){if(_0x27cf21){return _0x27cf21['removeAgents'](_0x547b8d[_0xd3d3('0x3f')][_0xd3d3('0x6b')])['then'](function(){if(_[_0xd3d3('0x8a')](_0x547b8d[_0xd3d3('0x3f')][_0xd3d3('0x6b')])){for(var _0x1f0585=0x0;_0x1f0585<_0x547b8d[_0xd3d3('0x3f')][_0xd3d3('0x6b')][_0xd3d3('0x42')];_0x1f0585+=0x1){socket['emit'](_0xd3d3('0x86'),{'UserId':Number(_0x547b8d[_0xd3d3('0x3f')][_0xd3d3('0x6b')][_0x1f0585]),'SmsQueueId':Number(_0x547b8d['params']['id'])});}}else{socket[_0xd3d3('0x73')](_0xd3d3('0x86'),{'UserId':Number(_0x547b8d[_0xd3d3('0x3f')][_0xd3d3('0x6b')]),'SmsQueueId':Number(_0x547b8d['params']['id'])});}});}})[_0xd3d3('0x2b')](respondWithStatusCode(_0x5f518d,null))[_0xd3d3('0x4f')](handleError(_0x5f518d,null));};exports[_0xd3d3('0x8b')]=function(_0x1021ef,_0x2aa5ed,_0x50450e){var _0x5e5d82={};var _0x49290a={};var _0x5ed610;var _0x20b376;return db[_0xd3d3('0x37')][_0xd3d3('0x8c')]({'where':{'id':_0x1021ef[_0xd3d3('0x50')]['id']}})[_0xd3d3('0x2b')](handleEntityNotFound(_0x2aa5ed,null))[_0xd3d3('0x2b')](function(_0x28be37){if(_0x28be37){_0x5ed610=_0x28be37;_0x49290a[_0xd3d3('0x3e')]=_[_0xd3d3('0x3b')](db[_0xd3d3('0x5f')][_0xd3d3('0x38')]);_0x49290a['query']=_[_0xd3d3('0x3b')](_0x1021ef['query']);_0x49290a[_0xd3d3('0x3c')]=_[_0xd3d3('0x3d')](_0x49290a['model'],_0x49290a[_0xd3d3('0x3f')]);_0x5e5d82[_0xd3d3('0x40')]=_[_0xd3d3('0x3d')](_0x49290a['model'],qs['fields'](_0x1021ef['query'][_0xd3d3('0x41')]));_0x5e5d82['attributes']=_0x5e5d82['attributes'][_0xd3d3('0x42')]?_0x5e5d82['attributes']:_0x49290a[_0xd3d3('0x3e')];_0x5e5d82[_0xd3d3('0x45')]=qs[_0xd3d3('0x46')](_0x1021ef[_0xd3d3('0x3f')][_0xd3d3('0x46')]);_0x5e5d82[_0xd3d3('0x47')]=qs['filters'](_['pick'](_0x1021ef[_0xd3d3('0x3f')],_0x49290a[_0xd3d3('0x3c')]));if(_0x1021ef[_0xd3d3('0x3f')]['filter']){_0x5e5d82[_0xd3d3('0x47')]=_[_0xd3d3('0x4a')](_0x5e5d82[_0xd3d3('0x47')],{'$or':_[_0xd3d3('0x36')](_0x5e5d82[_0xd3d3('0x40')],function(_0x428ab1){var _0x48f599={};_0x48f599[_0x428ab1]={'$like':'%'+_0x1021ef[_0xd3d3('0x3f')][_0xd3d3('0x49')]+'%'};return _0x48f599;})});}_0x5e5d82=_['merge']({},_0x5e5d82,_0x1021ef[_0xd3d3('0x4b')]);return _0x5ed610[_0xd3d3('0x8b')](_0x5e5d82);}})[_0xd3d3('0x2b')](function(_0x1945ce){if(_0x1945ce){_0x20b376=_0x1945ce[_0xd3d3('0x42')];if(!_0x1021ef['query'][_0xd3d3('0x43')](_0xd3d3('0x44'))){_0x5e5d82[_0xd3d3('0x24')]=qs[_0xd3d3('0x24')](_0x1021ef[_0xd3d3('0x3f')][_0xd3d3('0x24')]);_0x5e5d82[_0xd3d3('0x21')]=qs[_0xd3d3('0x21')](_0x1021ef[_0xd3d3('0x3f')][_0xd3d3('0x21')]);}return _0x5ed610[_0xd3d3('0x8b')](_0x5e5d82);}})['then'](function(_0x36a8f7){if(_0x36a8f7){return _0x36a8f7?{'count':_0x20b376,'rows':_0x36a8f7}:null;}})[_0xd3d3('0x2b')](respondWithResult(_0x2aa5ed,null))['catch'](handleError(_0x2aa5ed,null));};