f07077374a8ae3245f78d1a16bc913b929881da0
[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 _0xaba6=['type','key','model','query','keys','filters','intersection','fields','attributes','hasOwnProperty','nolimit','limit','sort','pick','filter','where','merge','VIRTUAL','count','includeAll','include','rows','show','length','options','catch','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','find','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','params','getMembers','findOne','UserSmsQueue','order','SmsQueueId','User','findAndCountAll','UserId','agent','smsPause','updatedAt','createdAt','format','%s/%s','getTeams','Team','addTeams','ids','findAll','Agents','voicePause','interface','flatMap','sequelize','transaction','each','findOrCreate','forEach','emit','userSmsQueue:save','field','team_has_sms_queues','join','ut.TeamId\x20=\x20tq.TeamId','clone','ut.UserId\x20=\x20?','push','QueryTypes','SELECT','every','TeamId','union','compact','value','removeTeams','isEmpty','removeAgents','userSmsQueue:remove','addAgents','omit','isArray','getAgents','html-pdf','eml-format','moment','bluebird','util','path','lodash','crypto','jsforce','to-csv','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','redis','localhost','./smsQueue.socket','register','sendStatus','end','status','json','offset','set','Content-Range','apply','reject','save','update','then','destroy','get','SmsQueues','UserProfileResource','error','stack','name','index','map','SmsQueue','rawAttributes'];(function(_0x2e4a84,_0x3de6e1){var _0x16ffe8=function(_0x43382f){while(--_0x43382f){_0x2e4a84['push'](_0x2e4a84['shift']());}};_0x16ffe8(++_0x3de6e1);}(_0xaba6,0xe2));var _0x6aba=function(_0x5ef37b,_0x166e27){_0x5ef37b=_0x5ef37b-0x0;var _0x2a10fa=_0xaba6[_0x5ef37b];return _0x2a10fa;};'use strict';var pdf=require(_0x6aba('0x0'));var emlformat=require(_0x6aba('0x1'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require(_0x6aba('0x2'));var BPromise=require(_0x6aba('0x3'));var Mustache=require('mustache');var util=require(_0x6aba('0x4'));var path=require(_0x6aba('0x5'));var sox=require('sox');var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var _=require(_0x6aba('0x6'));var squel=require('squel');var crypto=require(_0x6aba('0x7'));var jsforce=require(_0x6aba('0x8'));var deskjs=require('desk.js');var toCsv=require(_0x6aba('0x9'));var querystring=require(_0x6aba('0xa'));var Papa=require('papaparse');var Redis=require(_0x6aba('0xb'));var authService=require(_0x6aba('0xc'));var qs=require(_0x6aba('0xd'));var as=require(_0x6aba('0xe'));var hardwareService=require(_0x6aba('0xf'));var logger=require(_0x6aba('0x10'))(_0x6aba('0x11'));var utils=require('../../config/utils');var config=require(_0x6aba('0x12'));var licenseUtil=require(_0x6aba('0x13'));var db=require(_0x6aba('0x14'))['db'];config[_0x6aba('0x15')]=_['defaults'](config[_0x6aba('0x15')],{'host':_0x6aba('0x16'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0x6aba('0x15')]));require(_0x6aba('0x17'))[_0x6aba('0x18')](socket);function respondWithStatusCode(_0x515272,_0x1cf9d9){_0x1cf9d9=_0x1cf9d9||0xcc;return function(_0x1f3035){if(_0x1f3035){return _0x515272[_0x6aba('0x19')](_0x1cf9d9);}return _0x515272['status'](_0x1cf9d9)[_0x6aba('0x1a')]();};}function respondWithResult(_0xe0c63f,_0xa3cb32){_0xa3cb32=_0xa3cb32||0xc8;return function(_0x21921d){if(_0x21921d){return _0xe0c63f[_0x6aba('0x1b')](_0xa3cb32)[_0x6aba('0x1c')](_0x21921d);}};}function respondWithFilteredResult(_0x3009a9,_0x564827){return function(_0x2291d7){if(_0x2291d7){var _0x448f29=_0x2291d7['count'],_0x1c2efe=_0x564827['offset'],_0x5ca5b2=_0x564827[_0x6aba('0x1d')]+_0x564827['limit'],_0x1d6ad4;if(_0x5ca5b2>=_0x448f29){_0x5ca5b2=_0x448f29;_0x1d6ad4=0xc8;}else{_0x1d6ad4=0xce;}_0x3009a9[_0x6aba('0x1b')](_0x1d6ad4);return _0x3009a9[_0x6aba('0x1e')](_0x6aba('0x1f'),_0x1c2efe+'-'+_0x5ca5b2+'/'+_0x448f29)[_0x6aba('0x1c')](_0x2291d7);}return null;};}function patchUpdates(_0x110be5){return function(_0x41a3d2){try{jsonpatch[_0x6aba('0x20')](_0x41a3d2,_0x110be5,!![]);}catch(_0x5953f2){return BPromise[_0x6aba('0x21')](_0x5953f2);}return _0x41a3d2[_0x6aba('0x22')]();};}function saveUpdates(_0x41744c,_0x3dc85b){return function(_0x3f1412){if(_0x3f1412){return _0x3f1412[_0x6aba('0x23')](_0x41744c)[_0x6aba('0x24')](function(_0x67ba6e){return _0x67ba6e;});}return null;};}function removeEntity(_0x2b02c5,_0x222ad8){return function(_0x31ec71){if(_0x31ec71){return _0x31ec71[_0x6aba('0x25')]()[_0x6aba('0x24')](function(){var _0x3aafa3=_0x31ec71[_0x6aba('0x26')]({'plain':!![]});var _0xb947da=_0x6aba('0x27');return db[_0x6aba('0x28')][_0x6aba('0x25')]({'where':{'type':_0xb947da,'resourceId':_0x3aafa3['id']}})['then'](function(){return _0x31ec71;});})['then'](function(){_0x2b02c5[_0x6aba('0x1b')](0xcc)['end']();});}};}function handleEntityNotFound(_0x30ecf9,_0x108ff1){return function(_0x3ca593){if(!_0x3ca593){_0x30ecf9[_0x6aba('0x19')](0x194);}return _0x3ca593;};}function handleError(_0x5eef59,_0x1db130){_0x1db130=_0x1db130||0x1f4;return function(_0x1fcec2){logger[_0x6aba('0x29')](_0x1fcec2[_0x6aba('0x2a')]);if(_0x1fcec2[_0x6aba('0x2b')]){delete _0x1fcec2['name'];}_0x5eef59[_0x6aba('0x1b')](_0x1db130)['send'](_0x1fcec2);};}exports[_0x6aba('0x2c')]=function(_0x3fd125,_0x54e780){var _0x4d601a={},_0x202a81={},_0x21c144={'count':0x0,'rows':[]};var _0x24c5a9=_[_0x6aba('0x2d')](db[_0x6aba('0x2e')][_0x6aba('0x2f')],function(_0x39c449){return{'name':_0x39c449['fieldName'],'type':_0x39c449[_0x6aba('0x30')][_0x6aba('0x31')]};});_0x202a81[_0x6aba('0x32')]=_['map'](_0x24c5a9,_0x6aba('0x2b'));_0x202a81[_0x6aba('0x33')]=_[_0x6aba('0x34')](_0x3fd125['query']);_0x202a81[_0x6aba('0x35')]=_[_0x6aba('0x36')](_0x202a81['model'],_0x202a81[_0x6aba('0x33')]);_0x4d601a['attributes']=_[_0x6aba('0x36')](_0x202a81['model'],qs[_0x6aba('0x37')](_0x3fd125[_0x6aba('0x33')]['fields']));_0x4d601a['attributes']=_0x4d601a[_0x6aba('0x38')]['length']?_0x4d601a[_0x6aba('0x38')]:_0x202a81[_0x6aba('0x32')];if(!_0x3fd125['query'][_0x6aba('0x39')](_0x6aba('0x3a'))){_0x4d601a[_0x6aba('0x3b')]=qs[_0x6aba('0x3b')](_0x3fd125[_0x6aba('0x33')][_0x6aba('0x3b')]);_0x4d601a[_0x6aba('0x1d')]=qs['offset'](_0x3fd125['query'][_0x6aba('0x1d')]);}_0x4d601a['order']=qs[_0x6aba('0x3c')](_0x3fd125[_0x6aba('0x33')][_0x6aba('0x3c')]);_0x4d601a['where']=qs[_0x6aba('0x35')](_[_0x6aba('0x3d')](_0x3fd125[_0x6aba('0x33')],_0x202a81[_0x6aba('0x35')]),_0x24c5a9);if(_0x3fd125[_0x6aba('0x33')][_0x6aba('0x3e')]){_0x4d601a[_0x6aba('0x3f')]=_[_0x6aba('0x40')](_0x4d601a[_0x6aba('0x3f')],{'$or':_['map'](_0x24c5a9,function(_0x1d041e){if(_0x1d041e[_0x6aba('0x30')]!==_0x6aba('0x41')){var _0xc08035={};_0xc08035[_0x1d041e['name']]={'$like':'%'+_0x3fd125[_0x6aba('0x33')]['filter']+'%'};return _0xc08035;}})});}_0x4d601a=_[_0x6aba('0x40')]({},_0x4d601a,_0x3fd125['options']);var _0x4af6e2={'where':_0x4d601a['where']};return db[_0x6aba('0x2e')]['count'](_0x4af6e2)[_0x6aba('0x24')](function(_0x3263a9){_0x21c144[_0x6aba('0x42')]=_0x3263a9;if(_0x3fd125[_0x6aba('0x33')][_0x6aba('0x43')]){_0x4d601a[_0x6aba('0x44')]=[{'all':!![]}];}return db[_0x6aba('0x2e')]['findAll'](_0x4d601a);})[_0x6aba('0x24')](function(_0xe75150){_0x21c144[_0x6aba('0x45')]=_0xe75150;return _0x21c144;})['then'](respondWithFilteredResult(_0x54e780,_0x4d601a))['catch'](handleError(_0x54e780,null));};exports[_0x6aba('0x46')]=function(_0x319d93,_0x4deb8a){var _0x16bf9d={'raw':!![],'where':{'id':_0x319d93['params']['id']}},_0x4b3e2e={};_0x4b3e2e[_0x6aba('0x32')]=_[_0x6aba('0x34')](db[_0x6aba('0x2e')][_0x6aba('0x2f')]);_0x4b3e2e[_0x6aba('0x33')]=_[_0x6aba('0x34')](_0x319d93[_0x6aba('0x33')]);_0x4b3e2e['filters']=_[_0x6aba('0x36')](_0x4b3e2e[_0x6aba('0x32')],_0x4b3e2e[_0x6aba('0x33')]);_0x16bf9d[_0x6aba('0x38')]=_[_0x6aba('0x36')](_0x4b3e2e[_0x6aba('0x32')],qs['fields'](_0x319d93[_0x6aba('0x33')]['fields']));_0x16bf9d['attributes']=_0x16bf9d[_0x6aba('0x38')][_0x6aba('0x47')]?_0x16bf9d[_0x6aba('0x38')]:_0x4b3e2e[_0x6aba('0x32')];if(_0x319d93[_0x6aba('0x33')][_0x6aba('0x43')]){_0x16bf9d[_0x6aba('0x44')]=[{'all':!![]}];}_0x16bf9d=_[_0x6aba('0x40')]({},_0x16bf9d,_0x319d93[_0x6aba('0x48')]);return db[_0x6aba('0x2e')]['find'](_0x16bf9d)[_0x6aba('0x24')](handleEntityNotFound(_0x4deb8a,null))[_0x6aba('0x24')](respondWithResult(_0x4deb8a,null))[_0x6aba('0x49')](handleError(_0x4deb8a,null));};exports[_0x6aba('0x4a')]=function(_0x40ce81,_0x123a4c){return db[_0x6aba('0x2e')][_0x6aba('0x4a')](_0x40ce81[_0x6aba('0x4b')],{})[_0x6aba('0x24')](function(_0x24f87c){var _0xd4afa2=_0x40ce81[_0x6aba('0x4c')]['get']({'plain':!![]});if(!_0xd4afa2)throw new Error(_0x6aba('0x4d'));if(_0xd4afa2[_0x6aba('0x4e')]===_0x6aba('0x4c')){var _0x5a2f8c=_0x24f87c[_0x6aba('0x26')]({'plain':!![]});var _0x5476ec='SmsQueues';return db[_0x6aba('0x4f')][_0x6aba('0x50')]({'where':{'name':_0x5476ec,'userProfileId':_0xd4afa2[_0x6aba('0x51')]},'raw':!![]})['then'](function(_0x2dcce1){if(_0x2dcce1&&_0x2dcce1[_0x6aba('0x52')]===0x0){return db[_0x6aba('0x28')][_0x6aba('0x4a')]({'name':_0x5a2f8c[_0x6aba('0x2b')],'resourceId':_0x5a2f8c['id'],'type':_0x2dcce1[_0x6aba('0x2b')],'sectionId':_0x2dcce1['id']},{})['then'](function(){return _0x24f87c;});}else{return _0x24f87c;}})[_0x6aba('0x49')](function(_0x1e2460){logger['error'](_0x6aba('0x53'),_0x1e2460);throw _0x1e2460;});}return _0x24f87c;})[_0x6aba('0x24')](respondWithResult(_0x123a4c,0xc9))[_0x6aba('0x49')](handleError(_0x123a4c,null));};exports[_0x6aba('0x23')]=function(_0x7635f0,_0x346315){if(_0x7635f0['body']['id']){delete _0x7635f0['body']['id'];}return db[_0x6aba('0x2e')][_0x6aba('0x50')]({'where':{'id':_0x7635f0['params']['id']}})[_0x6aba('0x24')](handleEntityNotFound(_0x346315,null))[_0x6aba('0x24')](saveUpdates(_0x7635f0['body'],null))[_0x6aba('0x24')](respondWithResult(_0x346315,null))['catch'](handleError(_0x346315,null));};exports[_0x6aba('0x25')]=function(_0x342b05,_0x395a8e){return db['SmsQueue'][_0x6aba('0x50')]({'where':{'id':_0x342b05[_0x6aba('0x54')]['id']}})[_0x6aba('0x24')](handleEntityNotFound(_0x395a8e,null))[_0x6aba('0x24')](removeEntity(_0x395a8e,null))[_0x6aba('0x49')](handleError(_0x395a8e,null));};exports['describe']=function(_0x4ed26c,_0x353798){return db[_0x6aba('0x2e')]['describe']()[_0x6aba('0x24')](respondWithResult(_0x353798,null))[_0x6aba('0x49')](handleError(_0x353798,null));};exports[_0x6aba('0x55')]=function(_0x19bcfb,_0x3d0c16,_0x1aedbf){var _0x52c93d={'raw':!![],'where':{}},_0x419290={},_0xa067d3;return db[_0x6aba('0x2e')][_0x6aba('0x56')]({'where':{'id':_0x19bcfb[_0x6aba('0x54')]['id']}})[_0x6aba('0x24')](handleEntityNotFound(_0x3d0c16,null))[_0x6aba('0x24')](function(_0x42eed9){if(_0x42eed9){_0xa067d3=_0x42eed9[_0x6aba('0x26')]({'plain':!![]});_0x419290[_0x6aba('0x32')]=_[_0x6aba('0x34')](db[_0x6aba('0x57')][_0x6aba('0x2f')]);_0x419290[_0x6aba('0x33')]=_[_0x6aba('0x34')](_0x19bcfb[_0x6aba('0x33')]);_0x419290[_0x6aba('0x35')]=_[_0x6aba('0x36')](_0x419290['model'],_0x419290['query']);_0x52c93d[_0x6aba('0x38')]=_['intersection'](_0x419290[_0x6aba('0x32')],qs[_0x6aba('0x37')](_0x19bcfb[_0x6aba('0x33')][_0x6aba('0x37')]));_0x52c93d[_0x6aba('0x38')]=_0x52c93d[_0x6aba('0x38')][_0x6aba('0x47')]?_0x52c93d[_0x6aba('0x38')]:_0x419290[_0x6aba('0x32')];if(!_0x19bcfb['query'][_0x6aba('0x39')](_0x6aba('0x3a'))){_0x52c93d[_0x6aba('0x3b')]=qs['limit'](_0x19bcfb[_0x6aba('0x33')][_0x6aba('0x3b')]);_0x52c93d['offset']=qs[_0x6aba('0x1d')](_0x19bcfb[_0x6aba('0x33')][_0x6aba('0x1d')]);}_0x52c93d[_0x6aba('0x58')]=qs[_0x6aba('0x3c')](_0x19bcfb[_0x6aba('0x33')]['sort']);_0x52c93d[_0x6aba('0x3f')]=qs[_0x6aba('0x35')](_['pick'](_0x19bcfb[_0x6aba('0x33')],_0x419290[_0x6aba('0x35')]));_0x52c93d['where'][_0x6aba('0x59')]=_0x42eed9['id'];if(_0x19bcfb[_0x6aba('0x33')]['filter']){_0x52c93d[_0x6aba('0x3f')]=_[_0x6aba('0x40')](_0x52c93d['where'],{'$or':_[_0x6aba('0x2d')](_0x52c93d[_0x6aba('0x38')],function(_0x12caa8){var _0x12a7d9={};_0x12a7d9[_0x12caa8]={'$like':'%'+_0x19bcfb[_0x6aba('0x33')][_0x6aba('0x3e')]+'%'};return _0x12a7d9;})});}_0x52c93d=_[_0x6aba('0x40')]({},_0x52c93d,_0x19bcfb[_0x6aba('0x48')]);return db['UserSmsQueue']['findAll'](_0x52c93d);}})[_0x6aba('0x24')](function(_0x357a0d){if(_0x357a0d){return db[_0x6aba('0x5a')][_0x6aba('0x5b')]({'where':{'id':_[_0x6aba('0x2d')](_0x357a0d,_0x6aba('0x5c')),'role':_0x6aba('0x5d')},'attributes':['id',_0x6aba('0x2b'),_0x6aba('0x5e'),_0x6aba('0x5f'),_0x6aba('0x60')]});}})['then'](function(_0x1faedb){if(_0x1faedb){return{'count':_0x1faedb[_0x6aba('0x42')],'rows':_[_0x6aba('0x2d')](_0x1faedb[_0x6aba('0x45')],function(_0x469cb1){return{'membername':_0x469cb1[_0x6aba('0x2b')],'UserId':_0x469cb1['id'],'queue_name':_0xa067d3[_0x6aba('0x2b')],'SmsQueueId':_0xa067d3['id'],'interface':util[_0x6aba('0x61')](_0x6aba('0x62'),'SIP',_0x469cb1['name']),'penalty':0x0,'paused':_0x469cb1[_0x6aba('0x5e')],'createdAt':_0x469cb1['createdAt'],'updatedAt':_0x469cb1['updatedAt']};})};}else{return{'count':0x0,'rows':[]};}})[_0x6aba('0x24')](respondWithFilteredResult(_0x3d0c16,_0x52c93d))[_0x6aba('0x49')](handleError(_0x3d0c16,null));};exports[_0x6aba('0x63')]=function(_0x3d769f,_0x27fbde,_0x1c9860){var _0x421699={};var _0x2b6318={};var _0x9d40fb;var _0x42a7ea;return db[_0x6aba('0x2e')][_0x6aba('0x56')]({'where':{'id':_0x3d769f['params']['id']}})[_0x6aba('0x24')](handleEntityNotFound(_0x27fbde,null))[_0x6aba('0x24')](function(_0x4cb071){if(_0x4cb071){_0x9d40fb=_0x4cb071;_0x2b6318[_0x6aba('0x32')]=_[_0x6aba('0x34')](db[_0x6aba('0x64')]['rawAttributes']);_0x2b6318[_0x6aba('0x33')]=_['keys'](_0x3d769f['query']);_0x2b6318['filters']=_[_0x6aba('0x36')](_0x2b6318[_0x6aba('0x32')],_0x2b6318[_0x6aba('0x33')]);_0x421699['attributes']=_[_0x6aba('0x36')](_0x2b6318[_0x6aba('0x32')],qs[_0x6aba('0x37')](_0x3d769f[_0x6aba('0x33')][_0x6aba('0x37')]));_0x421699['attributes']=_0x421699['attributes'][_0x6aba('0x47')]?_0x421699['attributes']:_0x2b6318[_0x6aba('0x32')];_0x421699[_0x6aba('0x58')]=qs[_0x6aba('0x3c')](_0x3d769f[_0x6aba('0x33')][_0x6aba('0x3c')]);_0x421699[_0x6aba('0x3f')]=qs[_0x6aba('0x35')](_[_0x6aba('0x3d')](_0x3d769f[_0x6aba('0x33')],_0x2b6318['filters']));if(_0x3d769f[_0x6aba('0x33')][_0x6aba('0x3e')]){_0x421699[_0x6aba('0x3f')]=_['merge'](_0x421699[_0x6aba('0x3f')],{'$or':_['map'](_0x421699[_0x6aba('0x38')],function(_0x38394b){var _0x53f530={};_0x53f530[_0x38394b]={'$like':'%'+_0x3d769f[_0x6aba('0x33')][_0x6aba('0x3e')]+'%'};return _0x53f530;})});}_0x421699=_[_0x6aba('0x40')]({},_0x421699,_0x3d769f[_0x6aba('0x48')]);return _0x9d40fb[_0x6aba('0x63')](_0x421699);}})['then'](function(_0x216dda){if(_0x216dda){_0x42a7ea=_0x216dda[_0x6aba('0x47')];if(!_0x3d769f[_0x6aba('0x33')][_0x6aba('0x39')]('nolimit')){_0x421699[_0x6aba('0x3b')]=qs[_0x6aba('0x3b')](_0x3d769f['query'][_0x6aba('0x3b')]);_0x421699[_0x6aba('0x1d')]=qs[_0x6aba('0x1d')](_0x3d769f[_0x6aba('0x33')][_0x6aba('0x1d')]);}return _0x9d40fb[_0x6aba('0x63')](_0x421699);}})['then'](function(_0x1ae259){if(_0x1ae259){return _0x1ae259?{'count':_0x42a7ea,'rows':_0x1ae259}:null;}})[_0x6aba('0x24')](respondWithResult(_0x27fbde,null))[_0x6aba('0x49')](handleError(_0x27fbde,null));};exports[_0x6aba('0x65')]=function(_0x1054bf,_0x4d8897,_0x2052f4){var _0x40fa05=_0x1054bf[_0x6aba('0x4b')][_0x6aba('0x66')];return db[_0x6aba('0x64')][_0x6aba('0x67')]({'where':{'id':_0x40fa05},'attributes':['id'],'include':[{'model':db[_0x6aba('0x5a')],'as':_0x6aba('0x68'),'attributes':['id',_0x6aba('0x2b'),'online',_0x6aba('0x69'),_0x6aba('0x6a')],'raw':!![]}]})[_0x6aba('0x24')](function(_0x5e9a2e){if(_0x5e9a2e){var _0x261457=_[_0x6aba('0x6b')](_0x5e9a2e,function(_0x1cf30f){var _0x5cb3d4=_0x1cf30f['get']({'plain':!![]});return _0x5cb3d4[_0x6aba('0x68')];});return db[_0x6aba('0x2e')][_0x6aba('0x50')]({'where':{'id':_0x1054bf[_0x6aba('0x54')]['id']}})[_0x6aba('0x24')](function(_0x6579e7){return db[_0x6aba('0x6c')][_0x6aba('0x6d')](function(_0x38a067){return _0x6579e7[_0x6aba('0x65')](_0x40fa05,{'transaction':_0x38a067})[_0x6aba('0x24')](function(){return BPromise[_0x6aba('0x6e')](_0x261457,function(_0x24b50e){return db[_0x6aba('0x57')][_0x6aba('0x6f')]({'where':{'UserId':_0x24b50e['id'],'SmsQueueId':_0x1054bf[_0x6aba('0x54')]['id']},'transaction':_0x38a067});});})[_0x6aba('0x24')](function(){_0x261457[_0x6aba('0x70')](function(_0x4c9dcb){socket[_0x6aba('0x71')](_0x6aba('0x72'),{'UserId':_0x4c9dcb['id'],'SmsQueueId':_0x6579e7['id']});});});});});}})[_0x6aba('0x24')](respondWithStatusCode(_0x4d8897,null))[_0x6aba('0x49')](handleError(_0x4d8897,null));};exports['removeTeams']=function(_0x24f057,_0x5c24de,_0x96a972){return db[_0x6aba('0x64')][_0x6aba('0x67')]({'where':{'id':_0x24f057['query'][_0x6aba('0x66')]},'attributes':['id'],'include':[{'model':db[_0x6aba('0x5a')],'as':_0x6aba('0x68'),'attributes':['id'],'raw':!![]}]})['then'](handleEntityNotFound(_0x5c24de,null))[_0x6aba('0x24')](function(_0x282ad3){var _0x4bdaf5=_[_0x6aba('0x2d')](_0x282ad3,'id');var _0x202adf=[];var _0x3e757a=[];var _0x276a2f=squel['select']();_0x276a2f[_0x6aba('0x73')]('tq.TeamId')['from'](_0x6aba('0x74'),'tq')[_0x6aba('0x75')]('user_has_teams','ut',_0x6aba('0x76'))['where']('SmsQueueId\x20=\x20?',_0x24f057[_0x6aba('0x54')]['id']);for(var _0x5a6494=0x0;_0x5a6494<_0x282ad3[_0x6aba('0x47')];_0x5a6494+=0x1){let _0x1fc80c=_0x282ad3[_0x5a6494];for(var _0x1ca580=0x0;_0x1ca580<_0x1fc80c[_0x6aba('0x68')]['length'];_0x1ca580+=0x1){let _0x47b3c7=_0x1fc80c[_0x6aba('0x68')][_0x1ca580];var _0x3060f9=_0x276a2f[_0x6aba('0x77')]();_0x3060f9['where'](_0x6aba('0x78'),_0x47b3c7['id']);_0x3e757a[_0x6aba('0x79')](db[_0x6aba('0x6c')][_0x6aba('0x33')](_0x3060f9['toString'](),{'type':db['sequelize'][_0x6aba('0x7a')][_0x6aba('0x7b')]})[_0x6aba('0x24')](function(_0x1d5f8e){if(_0x1d5f8e[_0x6aba('0x47')]===0x1){return _0x47b3c7['id'];}else{var _0x26d9bc=_[_0x6aba('0x7c')](_['map'](_0x1d5f8e,_0x6aba('0x7d')),function(_0x1f98ac){return _['includes'](_0x4bdaf5,_0x1f98ac);});if(_0x26d9bc){return _0x47b3c7['id'];}}}));}}return BPromise['all'](_0x3e757a)['then'](function(_0x1d5d49){_0x202adf=_(_0x202adf)[_0x6aba('0x7e')](_0x1d5d49)[_0x6aba('0x7f')]()[_0x6aba('0x80')]();return db['SmsQueue']['find']({'where':{'id':_0x24f057[_0x6aba('0x54')]['id']}})[_0x6aba('0x24')](function(_0x1f2745){return db[_0x6aba('0x6c')][_0x6aba('0x6d')](function(_0x3ba3ce){return _0x1f2745[_0x6aba('0x81')](_0x24f057[_0x6aba('0x33')][_0x6aba('0x66')],{'transaction':_0x3ba3ce})[_0x6aba('0x24')](function(){if(!_[_0x6aba('0x82')](_0x202adf)){return _0x1f2745[_0x6aba('0x83')](_0x202adf,{'transaction':_0x3ba3ce});}})['then'](function(){_0x202adf[_0x6aba('0x70')](function(_0x54ff06){socket[_0x6aba('0x71')](_0x6aba('0x84'),{'UserId':_0x54ff06,'SmsQueueId':_0x1f2745['id']});});});});});});})[_0x6aba('0x24')](respondWithStatusCode(_0x5c24de,null))['catch'](handleError(_0x5c24de,null));};exports[_0x6aba('0x85')]=function(_0x440b72,_0x3bca2d,_0x51806c){return db[_0x6aba('0x2e')][_0x6aba('0x50')]({'where':{'id':_0x440b72[_0x6aba('0x54')]['id']}})['then'](handleEntityNotFound(_0x3bca2d,null))[_0x6aba('0x24')](function(_0x37fadb){if(_0x37fadb){return _0x37fadb[_0x6aba('0x85')](_0x440b72[_0x6aba('0x4b')][_0x6aba('0x66')],_[_0x6aba('0x86')](_0x440b72[_0x6aba('0x4b')],[_0x6aba('0x66'),'id'])||{})['spread'](function(_0x3bf775){for(var _0x55e0d8=0x0;_0x55e0d8<_0x440b72[_0x6aba('0x4b')][_0x6aba('0x66')][_0x6aba('0x47')];_0x55e0d8+=0x1){socket[_0x6aba('0x71')](_0x6aba('0x72'),{'UserId':_0x440b72[_0x6aba('0x4b')][_0x6aba('0x66')][_0x55e0d8],'SmsQueueId':_0x440b72[_0x6aba('0x54')]['id']});}return _0x3bf775;});}})[_0x6aba('0x24')](respondWithResult(_0x3bca2d,null))[_0x6aba('0x49')](handleError(_0x3bca2d,null));};exports[_0x6aba('0x83')]=function(_0x50bee3,_0xd00572,_0x2a85d7){return db[_0x6aba('0x2e')][_0x6aba('0x50')]({'where':{'id':_0x50bee3[_0x6aba('0x54')]['id']}})[_0x6aba('0x24')](handleEntityNotFound(_0xd00572,null))[_0x6aba('0x24')](function(_0x2d0595){if(_0x2d0595){return _0x2d0595[_0x6aba('0x83')](_0x50bee3[_0x6aba('0x33')][_0x6aba('0x66')])[_0x6aba('0x24')](function(){if(_[_0x6aba('0x87')](_0x50bee3[_0x6aba('0x33')][_0x6aba('0x66')])){for(var _0xda4bab=0x0;_0xda4bab<_0x50bee3[_0x6aba('0x33')][_0x6aba('0x66')]['length'];_0xda4bab+=0x1){socket[_0x6aba('0x71')](_0x6aba('0x84'),{'UserId':Number(_0x50bee3[_0x6aba('0x33')]['ids'][_0xda4bab]),'SmsQueueId':Number(_0x50bee3[_0x6aba('0x54')]['id'])});}}else{socket['emit'](_0x6aba('0x84'),{'UserId':Number(_0x50bee3['query'][_0x6aba('0x66')]),'SmsQueueId':Number(_0x50bee3['params']['id'])});}});}})['then'](respondWithStatusCode(_0xd00572,null))['catch'](handleError(_0xd00572,null));};exports[_0x6aba('0x88')]=function(_0x5b36c7,_0x4eb466,_0x2731c0){var _0x487a05={};var _0x1c15d0={};var _0x195a63;var _0x55898f;return db[_0x6aba('0x2e')][_0x6aba('0x56')]({'where':{'id':_0x5b36c7['params']['id']}})[_0x6aba('0x24')](handleEntityNotFound(_0x4eb466,null))['then'](function(_0x153691){if(_0x153691){_0x195a63=_0x153691;_0x1c15d0['model']=_['keys'](db[_0x6aba('0x5a')][_0x6aba('0x2f')]);_0x1c15d0['query']=_[_0x6aba('0x34')](_0x5b36c7[_0x6aba('0x33')]);_0x1c15d0[_0x6aba('0x35')]=_['intersection'](_0x1c15d0[_0x6aba('0x32')],_0x1c15d0[_0x6aba('0x33')]);_0x487a05[_0x6aba('0x38')]=_[_0x6aba('0x36')](_0x1c15d0[_0x6aba('0x32')],qs[_0x6aba('0x37')](_0x5b36c7[_0x6aba('0x33')][_0x6aba('0x37')]));_0x487a05[_0x6aba('0x38')]=_0x487a05[_0x6aba('0x38')][_0x6aba('0x47')]?_0x487a05[_0x6aba('0x38')]:_0x1c15d0['model'];_0x487a05[_0x6aba('0x58')]=qs[_0x6aba('0x3c')](_0x5b36c7['query'][_0x6aba('0x3c')]);_0x487a05[_0x6aba('0x3f')]=qs[_0x6aba('0x35')](_['pick'](_0x5b36c7['query'],_0x1c15d0[_0x6aba('0x35')]));if(_0x5b36c7[_0x6aba('0x33')][_0x6aba('0x3e')]){_0x487a05[_0x6aba('0x3f')]=_[_0x6aba('0x40')](_0x487a05[_0x6aba('0x3f')],{'$or':_[_0x6aba('0x2d')](_0x487a05[_0x6aba('0x38')],function(_0x2ec801){var _0x3347a3={};_0x3347a3[_0x2ec801]={'$like':'%'+_0x5b36c7[_0x6aba('0x33')][_0x6aba('0x3e')]+'%'};return _0x3347a3;})});}_0x487a05=_[_0x6aba('0x40')]({},_0x487a05,_0x5b36c7['options']);return _0x195a63[_0x6aba('0x88')](_0x487a05);}})[_0x6aba('0x24')](function(_0x1f13d4){if(_0x1f13d4){_0x55898f=_0x1f13d4['length'];if(!_0x5b36c7['query']['hasOwnProperty'](_0x6aba('0x3a'))){_0x487a05[_0x6aba('0x3b')]=qs[_0x6aba('0x3b')](_0x5b36c7[_0x6aba('0x33')][_0x6aba('0x3b')]);_0x487a05['offset']=qs[_0x6aba('0x1d')](_0x5b36c7[_0x6aba('0x33')]['offset']);}return _0x195a63[_0x6aba('0x88')](_0x487a05);}})['then'](function(_0x42ab5f){if(_0x42ab5f){return _0x42ab5f?{'count':_0x55898f,'rows':_0x42ab5f}:null;}})[_0x6aba('0x24')](respondWithResult(_0x4eb466,null))['catch'](handleError(_0x4eb466,null));};