Built motion from commit (unavailable).|2.5.21
[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 _0x9c5a=['format','%s/%s','getTeams','findOne','Team','addTeams','User','Agents','voicePause','sequelize','transaction','emit','userSmsQueue:save','removeTeams','ids','select','tq.TeamId','from','team_has_sms_queues','join','user_has_teams','ut.TeamId\x20=\x20tq.TeamId','SmsQueueId\x20=\x20?','clone','ut.UserId\x20=\x20?','push','toString','QueryTypes','every','TeamId','includes','all','union','compact','value','removeAgents','forEach','addAgents','omit','spread','userSmsQueue:remove','getAgents','nolimit','html-pdf','eml-format','zip-dir','fast-json-patch','request-promise','moment','mustache','util','sox','ejs','lodash','jsforce','desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','redis','defaults','localhost','./smsQueue.socket','register','sendStatus','status','end','json','count','offset','limit','set','reject','save','destroy','then','get','SmsQueues','error','stack','name','send','index','map','SmsQueue','rawAttributes','fieldName','type','model','query','keys','filters','intersection','attributes','fields','hasOwnProperty','order','sort','where','pick','filter','VIRTUAL','merge','options','includeAll','findAll','rows','catch','show','params','length','include','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','UserProfileResource','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','describe','UserSmsQueue','SmsQueueId','UserId','smsPause','updatedAt','createdAt'];(function(_0x4ea556,_0x476e74){var _0x5a8ab6=function(_0x171482){while(--_0x171482){_0x4ea556['push'](_0x4ea556['shift']());}};_0x5a8ab6(++_0x476e74);}(_0x9c5a,0x1c3));var _0xa9c5=function(_0xbd913e,_0x2d0d4a){_0xbd913e=_0xbd913e-0x0;var _0x389d28=_0x9c5a[_0xbd913e];return _0x389d28;};'use strict';var pdf=require(_0xa9c5('0x0'));var emlformat=require(_0xa9c5('0x1'));var rimraf=require('rimraf');var zipdir=require(_0xa9c5('0x2'));var jsonpatch=require(_0xa9c5('0x3'));var rp=require(_0xa9c5('0x4'));var moment=require(_0xa9c5('0x5'));var BPromise=require('bluebird');var Mustache=require(_0xa9c5('0x6'));var util=require(_0xa9c5('0x7'));var path=require('path');var sox=require(_0xa9c5('0x8'));var csv=require('to-csv');var ejs=require(_0xa9c5('0x9'));var fs=require('fs');var _=require(_0xa9c5('0xa'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0xa9c5('0xb'));var deskjs=require(_0xa9c5('0xc'));var toCsv=require('to-csv');var querystring=require(_0xa9c5('0xd'));var Papa=require(_0xa9c5('0xe'));var Redis=require('ioredis');var authService=require(_0xa9c5('0xf'));var qs=require(_0xa9c5('0x10'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0xa9c5('0x11'))(_0xa9c5('0x12'));var utils=require(_0xa9c5('0x13'));var config=require(_0xa9c5('0x14'));var licenseUtil=require(_0xa9c5('0x15'));var db=require(_0xa9c5('0x16'))['db'];config[_0xa9c5('0x17')]=_[_0xa9c5('0x18')](config[_0xa9c5('0x17')],{'host':_0xa9c5('0x19'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0xa9c5('0x17')]));require(_0xa9c5('0x1a'))[_0xa9c5('0x1b')](socket);function respondWithStatusCode(_0x3806c4,_0x418ca5){_0x418ca5=_0x418ca5||0xcc;return function(_0x1dad66){if(_0x1dad66){return _0x3806c4[_0xa9c5('0x1c')](_0x418ca5);}return _0x3806c4[_0xa9c5('0x1d')](_0x418ca5)[_0xa9c5('0x1e')]();};}function respondWithResult(_0xcf13f2,_0x4bb57e){_0x4bb57e=_0x4bb57e||0xc8;return function(_0x2b0d73){if(_0x2b0d73){return _0xcf13f2[_0xa9c5('0x1d')](_0x4bb57e)[_0xa9c5('0x1f')](_0x2b0d73);}};}function respondWithFilteredResult(_0x55cce5,_0x2cda1b){return function(_0x1142d9){if(_0x1142d9){var _0x2b9ac5=_0x1142d9[_0xa9c5('0x20')],_0x3b8cf7=_0x2cda1b[_0xa9c5('0x21')],_0x452a9b=_0x2cda1b[_0xa9c5('0x21')]+_0x2cda1b[_0xa9c5('0x22')],_0x349f27;if(_0x452a9b>=_0x2b9ac5){_0x452a9b=_0x2b9ac5;_0x349f27=0xc8;}else{_0x349f27=0xce;}_0x55cce5[_0xa9c5('0x1d')](_0x349f27);return _0x55cce5[_0xa9c5('0x23')]('Content-Range',_0x3b8cf7+'-'+_0x452a9b+'/'+_0x2b9ac5)[_0xa9c5('0x1f')](_0x1142d9);}return null;};}function patchUpdates(_0x21ab50){return function(_0x541c77){try{jsonpatch['apply'](_0x541c77,_0x21ab50,!![]);}catch(_0xce9af6){return BPromise[_0xa9c5('0x24')](_0xce9af6);}return _0x541c77[_0xa9c5('0x25')]();};}function saveUpdates(_0x3b497a,_0xc0bca3){return function(_0xd4b8a1){if(_0xd4b8a1){return _0xd4b8a1['update'](_0x3b497a)['then'](function(_0x3d4e1b){return _0x3d4e1b;});}return null;};}function removeEntity(_0x11d395,_0x4b0f05){return function(_0x6819b3){if(_0x6819b3){return _0x6819b3[_0xa9c5('0x26')]()[_0xa9c5('0x27')](function(){var _0x32fc7d=_0x6819b3[_0xa9c5('0x28')]({'plain':!![]});var _0x40f08b=_0xa9c5('0x29');return db['UserProfileResource']['destroy']({'where':{'type':_0x40f08b,'resourceId':_0x32fc7d['id']}})[_0xa9c5('0x27')](function(){return _0x6819b3;});})['then'](function(){_0x11d395[_0xa9c5('0x1d')](0xcc)[_0xa9c5('0x1e')]();});}};}function handleEntityNotFound(_0x4caefa,_0x11a723){return function(_0x320dc0){if(!_0x320dc0){_0x4caefa['sendStatus'](0x194);}return _0x320dc0;};}function handleError(_0x413edf,_0x32baf9){_0x32baf9=_0x32baf9||0x1f4;return function(_0x198cdf){logger[_0xa9c5('0x2a')](_0x198cdf[_0xa9c5('0x2b')]);if(_0x198cdf['name']){delete _0x198cdf[_0xa9c5('0x2c')];}_0x413edf['status'](_0x32baf9)[_0xa9c5('0x2d')](_0x198cdf);};}exports[_0xa9c5('0x2e')]=function(_0x2eeed1,_0x541475){var _0xc6d0c1={},_0xbe29c5={},_0x5bc9bb={'count':0x0,'rows':[]};var _0x3f11a9=_[_0xa9c5('0x2f')](db[_0xa9c5('0x30')][_0xa9c5('0x31')],function(_0x22ee21){return{'name':_0x22ee21[_0xa9c5('0x32')],'type':_0x22ee21[_0xa9c5('0x33')]['key']};});_0xbe29c5[_0xa9c5('0x34')]=_[_0xa9c5('0x2f')](_0x3f11a9,_0xa9c5('0x2c'));_0xbe29c5[_0xa9c5('0x35')]=_[_0xa9c5('0x36')](_0x2eeed1[_0xa9c5('0x35')]);_0xbe29c5[_0xa9c5('0x37')]=_[_0xa9c5('0x38')](_0xbe29c5['model'],_0xbe29c5['query']);_0xc6d0c1[_0xa9c5('0x39')]=_[_0xa9c5('0x38')](_0xbe29c5[_0xa9c5('0x34')],qs[_0xa9c5('0x3a')](_0x2eeed1[_0xa9c5('0x35')][_0xa9c5('0x3a')]));_0xc6d0c1['attributes']=_0xc6d0c1['attributes']['length']?_0xc6d0c1[_0xa9c5('0x39')]:_0xbe29c5[_0xa9c5('0x34')];if(!_0x2eeed1['query'][_0xa9c5('0x3b')]('nolimit')){_0xc6d0c1[_0xa9c5('0x22')]=qs[_0xa9c5('0x22')](_0x2eeed1[_0xa9c5('0x35')][_0xa9c5('0x22')]);_0xc6d0c1['offset']=qs[_0xa9c5('0x21')](_0x2eeed1[_0xa9c5('0x35')][_0xa9c5('0x21')]);}_0xc6d0c1[_0xa9c5('0x3c')]=qs[_0xa9c5('0x3d')](_0x2eeed1[_0xa9c5('0x35')][_0xa9c5('0x3d')]);_0xc6d0c1[_0xa9c5('0x3e')]=qs['filters'](_[_0xa9c5('0x3f')](_0x2eeed1[_0xa9c5('0x35')],_0xbe29c5[_0xa9c5('0x37')]),_0x3f11a9);if(_0x2eeed1[_0xa9c5('0x35')][_0xa9c5('0x40')]){_0xc6d0c1[_0xa9c5('0x3e')]=_['merge'](_0xc6d0c1[_0xa9c5('0x3e')],{'$or':_['map'](_0x3f11a9,function(_0x2fa3e3){if(_0x2fa3e3['type']!==_0xa9c5('0x41')){var _0xd4305d={};_0xd4305d[_0x2fa3e3[_0xa9c5('0x2c')]]={'$like':'%'+_0x2eeed1['query'][_0xa9c5('0x40')]+'%'};return _0xd4305d;}})});}_0xc6d0c1=_[_0xa9c5('0x42')]({},_0xc6d0c1,_0x2eeed1[_0xa9c5('0x43')]);var _0x26dd0c={'where':_0xc6d0c1['where']};return db[_0xa9c5('0x30')][_0xa9c5('0x20')](_0x26dd0c)[_0xa9c5('0x27')](function(_0x45668e){_0x5bc9bb[_0xa9c5('0x20')]=_0x45668e;if(_0x2eeed1['query'][_0xa9c5('0x44')]){_0xc6d0c1['include']=[{'all':!![]}];}return db[_0xa9c5('0x30')][_0xa9c5('0x45')](_0xc6d0c1);})[_0xa9c5('0x27')](function(_0xc8fca4){_0x5bc9bb[_0xa9c5('0x46')]=_0xc8fca4;return _0x5bc9bb;})[_0xa9c5('0x27')](respondWithFilteredResult(_0x541475,_0xc6d0c1))[_0xa9c5('0x47')](handleError(_0x541475,null));};exports[_0xa9c5('0x48')]=function(_0x1f895a,_0xc28b1a){var _0x4aa4dd={'raw':!![],'where':{'id':_0x1f895a[_0xa9c5('0x49')]['id']}},_0x2e92c5={};_0x2e92c5[_0xa9c5('0x34')]=_[_0xa9c5('0x36')](db[_0xa9c5('0x30')][_0xa9c5('0x31')]);_0x2e92c5['query']=_[_0xa9c5('0x36')](_0x1f895a[_0xa9c5('0x35')]);_0x2e92c5['filters']=_['intersection'](_0x2e92c5['model'],_0x2e92c5['query']);_0x4aa4dd['attributes']=_[_0xa9c5('0x38')](_0x2e92c5[_0xa9c5('0x34')],qs[_0xa9c5('0x3a')](_0x1f895a[_0xa9c5('0x35')][_0xa9c5('0x3a')]));_0x4aa4dd[_0xa9c5('0x39')]=_0x4aa4dd[_0xa9c5('0x39')][_0xa9c5('0x4a')]?_0x4aa4dd[_0xa9c5('0x39')]:_0x2e92c5[_0xa9c5('0x34')];if(_0x1f895a[_0xa9c5('0x35')][_0xa9c5('0x44')]){_0x4aa4dd[_0xa9c5('0x4b')]=[{'all':!![]}];}_0x4aa4dd=_['merge']({},_0x4aa4dd,_0x1f895a[_0xa9c5('0x43')]);return db['SmsQueue'][_0xa9c5('0x4c')](_0x4aa4dd)[_0xa9c5('0x27')](handleEntityNotFound(_0xc28b1a,null))['then'](respondWithResult(_0xc28b1a,null))['catch'](handleError(_0xc28b1a,null));};exports[_0xa9c5('0x4d')]=function(_0x32e64a,_0xeb0720){return db['SmsQueue']['create'](_0x32e64a[_0xa9c5('0x4e')],{})[_0xa9c5('0x27')](function(_0x481f9c){var _0x8ea192=_0x32e64a[_0xa9c5('0x4f')][_0xa9c5('0x28')]({'plain':!![]});if(!_0x8ea192)throw new Error(_0xa9c5('0x50'));if(_0x8ea192[_0xa9c5('0x51')]===_0xa9c5('0x4f')){var _0x4b6fc9=_0x481f9c['get']({'plain':!![]});var _0x54c60c=_0xa9c5('0x29');return db[_0xa9c5('0x52')][_0xa9c5('0x4c')]({'where':{'name':_0x54c60c,'userProfileId':_0x8ea192[_0xa9c5('0x53')]},'raw':!![]})[_0xa9c5('0x27')](function(_0x15d044){if(_0x15d044&&_0x15d044['autoAssociation']===0x0){return db[_0xa9c5('0x54')][_0xa9c5('0x4d')]({'name':_0x4b6fc9[_0xa9c5('0x2c')],'resourceId':_0x4b6fc9['id'],'type':_0x15d044[_0xa9c5('0x2c')],'sectionId':_0x15d044['id']},{})[_0xa9c5('0x27')](function(){return _0x481f9c;});}else{return _0x481f9c;}})[_0xa9c5('0x47')](function(_0x547654){logger['error'](_0xa9c5('0x55'),_0x547654);throw _0x547654;});}return _0x481f9c;})['then'](respondWithResult(_0xeb0720,0xc9))[_0xa9c5('0x47')](handleError(_0xeb0720,null));};exports['update']=function(_0xfae271,_0x2068bc){if(_0xfae271[_0xa9c5('0x4e')]['id']){delete _0xfae271['body']['id'];}return db[_0xa9c5('0x30')][_0xa9c5('0x4c')]({'where':{'id':_0xfae271[_0xa9c5('0x49')]['id']}})[_0xa9c5('0x27')](handleEntityNotFound(_0x2068bc,null))['then'](saveUpdates(_0xfae271['body'],null))[_0xa9c5('0x27')](respondWithResult(_0x2068bc,null))[_0xa9c5('0x47')](handleError(_0x2068bc,null));};exports[_0xa9c5('0x26')]=function(_0x5b4323,_0x31e12e){return db[_0xa9c5('0x30')][_0xa9c5('0x4c')]({'where':{'id':_0x5b4323[_0xa9c5('0x49')]['id']}})[_0xa9c5('0x27')](handleEntityNotFound(_0x31e12e,null))[_0xa9c5('0x27')](removeEntity(_0x31e12e,null))[_0xa9c5('0x47')](handleError(_0x31e12e,null));};exports[_0xa9c5('0x56')]=function(_0x5a7f0a,_0x41f528){return db['SmsQueue'][_0xa9c5('0x56')]()[_0xa9c5('0x27')](respondWithResult(_0x41f528,null))[_0xa9c5('0x47')](handleError(_0x41f528,null));};exports['getMembers']=function(_0x4d475a,_0x1dd3b2,_0x4d866d){var _0x1edab3={'raw':!![],'where':{}},_0x550144={},_0x13a708;return db[_0xa9c5('0x30')]['findOne']({'where':{'id':_0x4d475a[_0xa9c5('0x49')]['id']}})[_0xa9c5('0x27')](handleEntityNotFound(_0x1dd3b2,null))[_0xa9c5('0x27')](function(_0x35339c){if(_0x35339c){_0x13a708=_0x35339c['get']({'plain':!![]});_0x550144['model']=_[_0xa9c5('0x36')](db[_0xa9c5('0x57')][_0xa9c5('0x31')]);_0x550144[_0xa9c5('0x35')]=_[_0xa9c5('0x36')](_0x4d475a[_0xa9c5('0x35')]);_0x550144['filters']=_[_0xa9c5('0x38')](_0x550144[_0xa9c5('0x34')],_0x550144[_0xa9c5('0x35')]);_0x1edab3[_0xa9c5('0x39')]=_[_0xa9c5('0x38')](_0x550144[_0xa9c5('0x34')],qs[_0xa9c5('0x3a')](_0x4d475a[_0xa9c5('0x35')][_0xa9c5('0x3a')]));_0x1edab3[_0xa9c5('0x39')]=_0x1edab3['attributes']['length']?_0x1edab3[_0xa9c5('0x39')]:_0x550144[_0xa9c5('0x34')];if(!_0x4d475a[_0xa9c5('0x35')][_0xa9c5('0x3b')]('nolimit')){_0x1edab3[_0xa9c5('0x22')]=qs['limit'](_0x4d475a[_0xa9c5('0x35')][_0xa9c5('0x22')]);_0x1edab3[_0xa9c5('0x21')]=qs[_0xa9c5('0x21')](_0x4d475a[_0xa9c5('0x35')][_0xa9c5('0x21')]);}_0x1edab3[_0xa9c5('0x3c')]=qs[_0xa9c5('0x3d')](_0x4d475a[_0xa9c5('0x35')][_0xa9c5('0x3d')]);_0x1edab3[_0xa9c5('0x3e')]=qs[_0xa9c5('0x37')](_['pick'](_0x4d475a[_0xa9c5('0x35')],_0x550144[_0xa9c5('0x37')]));_0x1edab3[_0xa9c5('0x3e')][_0xa9c5('0x58')]=_0x35339c['id'];if(_0x4d475a[_0xa9c5('0x35')][_0xa9c5('0x40')]){_0x1edab3[_0xa9c5('0x3e')]=_['merge'](_0x1edab3['where'],{'$or':_[_0xa9c5('0x2f')](_0x1edab3['attributes'],function(_0x2ae087){var _0x2510e4={};_0x2510e4[_0x2ae087]={'$like':'%'+_0x4d475a['query'][_0xa9c5('0x40')]+'%'};return _0x2510e4;})});}_0x1edab3=_[_0xa9c5('0x42')]({},_0x1edab3,_0x4d475a['options']);return db['UserSmsQueue'][_0xa9c5('0x45')](_0x1edab3);}})[_0xa9c5('0x27')](function(_0x22af29){if(_0x22af29){return db['User']['findAndCountAll']({'where':{'id':_[_0xa9c5('0x2f')](_0x22af29,_0xa9c5('0x59')),'role':'agent'},'attributes':['id',_0xa9c5('0x2c'),_0xa9c5('0x5a'),_0xa9c5('0x5b'),_0xa9c5('0x5c')]});}})[_0xa9c5('0x27')](function(_0x45b0a3){if(_0x45b0a3){return{'count':_0x45b0a3['count'],'rows':_[_0xa9c5('0x2f')](_0x45b0a3[_0xa9c5('0x46')],function(_0x4586ba){return{'membername':_0x4586ba[_0xa9c5('0x2c')],'UserId':_0x4586ba['id'],'queue_name':_0x13a708['name'],'SmsQueueId':_0x13a708['id'],'interface':util[_0xa9c5('0x5d')](_0xa9c5('0x5e'),'SIP',_0x4586ba[_0xa9c5('0x2c')]),'penalty':0x0,'paused':_0x4586ba[_0xa9c5('0x5a')],'createdAt':_0x4586ba[_0xa9c5('0x5c')],'updatedAt':_0x4586ba['updatedAt']};})};}else{return{'count':0x0,'rows':[]};}})[_0xa9c5('0x27')](respondWithFilteredResult(_0x1dd3b2,_0x1edab3))[_0xa9c5('0x47')](handleError(_0x1dd3b2,null));};exports[_0xa9c5('0x5f')]=function(_0x2e00f5,_0x2d449a,_0x4db621){var _0x99cac9={};var _0x4acc1f={};var _0x13b6da;var _0x40468b;return db[_0xa9c5('0x30')][_0xa9c5('0x60')]({'where':{'id':_0x2e00f5[_0xa9c5('0x49')]['id']}})[_0xa9c5('0x27')](handleEntityNotFound(_0x2d449a,null))[_0xa9c5('0x27')](function(_0x390d0b){if(_0x390d0b){_0x13b6da=_0x390d0b;_0x4acc1f[_0xa9c5('0x34')]=_[_0xa9c5('0x36')](db[_0xa9c5('0x61')]['rawAttributes']);_0x4acc1f[_0xa9c5('0x35')]=_[_0xa9c5('0x36')](_0x2e00f5['query']);_0x4acc1f[_0xa9c5('0x37')]=_[_0xa9c5('0x38')](_0x4acc1f[_0xa9c5('0x34')],_0x4acc1f['query']);_0x99cac9[_0xa9c5('0x39')]=_[_0xa9c5('0x38')](_0x4acc1f[_0xa9c5('0x34')],qs[_0xa9c5('0x3a')](_0x2e00f5['query'][_0xa9c5('0x3a')]));_0x99cac9[_0xa9c5('0x39')]=_0x99cac9['attributes']['length']?_0x99cac9['attributes']:_0x4acc1f['model'];_0x99cac9['order']=qs['sort'](_0x2e00f5['query']['sort']);_0x99cac9[_0xa9c5('0x3e')]=qs[_0xa9c5('0x37')](_[_0xa9c5('0x3f')](_0x2e00f5[_0xa9c5('0x35')],_0x4acc1f[_0xa9c5('0x37')]));if(_0x2e00f5['query']['filter']){_0x99cac9['where']=_['merge'](_0x99cac9[_0xa9c5('0x3e')],{'$or':_[_0xa9c5('0x2f')](_0x99cac9[_0xa9c5('0x39')],function(_0x2eda17){var _0x5253e8={};_0x5253e8[_0x2eda17]={'$like':'%'+_0x2e00f5['query'][_0xa9c5('0x40')]+'%'};return _0x5253e8;})});}_0x99cac9=_[_0xa9c5('0x42')]({},_0x99cac9,_0x2e00f5[_0xa9c5('0x43')]);return _0x13b6da[_0xa9c5('0x5f')](_0x99cac9);}})[_0xa9c5('0x27')](function(_0x5673f1){if(_0x5673f1){_0x40468b=_0x5673f1[_0xa9c5('0x4a')];if(!_0x2e00f5[_0xa9c5('0x35')][_0xa9c5('0x3b')]('nolimit')){_0x99cac9[_0xa9c5('0x22')]=qs[_0xa9c5('0x22')](_0x2e00f5[_0xa9c5('0x35')][_0xa9c5('0x22')]);_0x99cac9['offset']=qs[_0xa9c5('0x21')](_0x2e00f5[_0xa9c5('0x35')]['offset']);}return _0x13b6da['getTeams'](_0x99cac9);}})[_0xa9c5('0x27')](function(_0x4d3dc0){if(_0x4d3dc0){return _0x4d3dc0?{'count':_0x40468b,'rows':_0x4d3dc0}:null;}})['then'](respondWithResult(_0x2d449a,null))[_0xa9c5('0x47')](handleError(_0x2d449a,null));};exports[_0xa9c5('0x62')]=function(_0xa18f0d,_0x2f9757,_0x22661f){var _0x5bc433=_0xa18f0d[_0xa9c5('0x4e')]['ids'];return db[_0xa9c5('0x61')][_0xa9c5('0x45')]({'where':{'id':_0x5bc433},'attributes':['id'],'include':[{'model':db[_0xa9c5('0x63')],'as':_0xa9c5('0x64'),'attributes':['id','name','online',_0xa9c5('0x65'),'interface'],'raw':!![]}]})['then'](function(_0x38e2f){if(_0x38e2f){var _0x370bbb=_['flatMap'](_0x38e2f,function(_0x5b6d59){var _0x4335ff=_0x5b6d59[_0xa9c5('0x28')]({'plain':!![]});return _0x4335ff[_0xa9c5('0x64')];});return db[_0xa9c5('0x30')]['find']({'where':{'id':_0xa18f0d['params']['id']}})[_0xa9c5('0x27')](function(_0xd2e186){return db[_0xa9c5('0x66')][_0xa9c5('0x67')](function(_0x2f80d9){return _0xd2e186[_0xa9c5('0x62')](_0x5bc433,{'transaction':_0x2f80d9})[_0xa9c5('0x27')](function(){return BPromise['each'](_0x370bbb,function(_0x23ee99){return db[_0xa9c5('0x57')]['findOrCreate']({'where':{'UserId':_0x23ee99['id'],'SmsQueueId':_0xa18f0d[_0xa9c5('0x49')]['id']},'transaction':_0x2f80d9});});})[_0xa9c5('0x27')](function(){_0x370bbb['forEach'](function(_0x185820){socket[_0xa9c5('0x68')](_0xa9c5('0x69'),{'UserId':_0x185820['id'],'SmsQueueId':_0xd2e186['id']});});});});});}})[_0xa9c5('0x27')](respondWithStatusCode(_0x2f9757,null))[_0xa9c5('0x47')](handleError(_0x2f9757,null));};exports[_0xa9c5('0x6a')]=function(_0x1f76d3,_0x13e233,_0xa88eb9){return db[_0xa9c5('0x61')][_0xa9c5('0x45')]({'where':{'id':_0x1f76d3[_0xa9c5('0x35')][_0xa9c5('0x6b')]},'attributes':['id'],'include':[{'model':db[_0xa9c5('0x63')],'as':_0xa9c5('0x64'),'attributes':['id'],'raw':!![]}]})[_0xa9c5('0x27')](handleEntityNotFound(_0x13e233,null))[_0xa9c5('0x27')](function(_0x5f00ad){var _0x425b92=_[_0xa9c5('0x2f')](_0x5f00ad,'id');var _0x447bff=[];var _0x4c7903=[];var _0x3c6092=squel[_0xa9c5('0x6c')]();_0x3c6092['field'](_0xa9c5('0x6d'))[_0xa9c5('0x6e')](_0xa9c5('0x6f'),'tq')[_0xa9c5('0x70')](_0xa9c5('0x71'),'ut',_0xa9c5('0x72'))[_0xa9c5('0x3e')](_0xa9c5('0x73'),_0x1f76d3[_0xa9c5('0x49')]['id']);for(var _0xb09d88=0x0;_0xb09d88<_0x5f00ad[_0xa9c5('0x4a')];_0xb09d88+=0x1){let _0x4fe78=_0x5f00ad[_0xb09d88];for(var _0xf8f816=0x0;_0xf8f816<_0x4fe78['Agents']['length'];_0xf8f816+=0x1){let _0x29a686=_0x4fe78[_0xa9c5('0x64')][_0xf8f816];var _0x5a7508=_0x3c6092[_0xa9c5('0x74')]();_0x5a7508[_0xa9c5('0x3e')](_0xa9c5('0x75'),_0x29a686['id']);_0x4c7903[_0xa9c5('0x76')](db['sequelize']['query'](_0x5a7508[_0xa9c5('0x77')](),{'type':db[_0xa9c5('0x66')][_0xa9c5('0x78')]['SELECT']})[_0xa9c5('0x27')](function(_0x132958){if(_0x132958[_0xa9c5('0x4a')]===0x1){return _0x29a686['id'];}else{var _0x4c84ef=_[_0xa9c5('0x79')](_[_0xa9c5('0x2f')](_0x132958,_0xa9c5('0x7a')),function(_0x1a09f0){return _[_0xa9c5('0x7b')](_0x425b92,_0x1a09f0);});if(_0x4c84ef){return _0x29a686['id'];}}}));}}return BPromise[_0xa9c5('0x7c')](_0x4c7903)[_0xa9c5('0x27')](function(_0x2a82ab){_0x447bff=_(_0x447bff)[_0xa9c5('0x7d')](_0x2a82ab)[_0xa9c5('0x7e')]()[_0xa9c5('0x7f')]();return db[_0xa9c5('0x30')][_0xa9c5('0x4c')]({'where':{'id':_0x1f76d3[_0xa9c5('0x49')]['id']}})[_0xa9c5('0x27')](function(_0x49c5fc){return db['sequelize']['transaction'](function(_0x1d6a2a){return _0x49c5fc[_0xa9c5('0x6a')](_0x1f76d3['query'][_0xa9c5('0x6b')],{'transaction':_0x1d6a2a})[_0xa9c5('0x27')](function(){if(!_['isEmpty'](_0x447bff)){return _0x49c5fc[_0xa9c5('0x80')](_0x447bff,{'transaction':_0x1d6a2a});}})[_0xa9c5('0x27')](function(){_0x447bff[_0xa9c5('0x81')](function(_0x318931){socket[_0xa9c5('0x68')]('userSmsQueue:remove',{'UserId':_0x318931,'SmsQueueId':_0x49c5fc['id']});});});});});});})[_0xa9c5('0x27')](respondWithStatusCode(_0x13e233,null))[_0xa9c5('0x47')](handleError(_0x13e233,null));};exports[_0xa9c5('0x82')]=function(_0x3f15d4,_0x28cfe9,_0x23dbee){return db[_0xa9c5('0x30')][_0xa9c5('0x4c')]({'where':{'id':_0x3f15d4[_0xa9c5('0x49')]['id']}})[_0xa9c5('0x27')](handleEntityNotFound(_0x28cfe9,null))[_0xa9c5('0x27')](function(_0x30ad94){if(_0x30ad94){return _0x30ad94[_0xa9c5('0x82')](_0x3f15d4['body']['ids'],_[_0xa9c5('0x83')](_0x3f15d4[_0xa9c5('0x4e')],[_0xa9c5('0x6b'),'id'])||{})[_0xa9c5('0x84')](function(_0x5b9835){for(var _0x40e9d5=0x0;_0x40e9d5<_0x3f15d4['body']['ids']['length'];_0x40e9d5+=0x1){socket[_0xa9c5('0x68')](_0xa9c5('0x69'),{'UserId':_0x3f15d4['body'][_0xa9c5('0x6b')][_0x40e9d5],'SmsQueueId':_0x3f15d4[_0xa9c5('0x49')]['id']});}return _0x5b9835;});}})[_0xa9c5('0x27')](respondWithResult(_0x28cfe9,null))[_0xa9c5('0x47')](handleError(_0x28cfe9,null));};exports[_0xa9c5('0x80')]=function(_0x3a98d,_0x193fe0,_0x5c3ab0){return db[_0xa9c5('0x30')]['find']({'where':{'id':_0x3a98d[_0xa9c5('0x49')]['id']}})[_0xa9c5('0x27')](handleEntityNotFound(_0x193fe0,null))[_0xa9c5('0x27')](function(_0x20300c){if(_0x20300c){return _0x20300c[_0xa9c5('0x80')](_0x3a98d[_0xa9c5('0x35')][_0xa9c5('0x6b')])[_0xa9c5('0x27')](function(){if(_['isArray'](_0x3a98d[_0xa9c5('0x35')]['ids'])){for(var _0x4453b6=0x0;_0x4453b6<_0x3a98d['query'][_0xa9c5('0x6b')][_0xa9c5('0x4a')];_0x4453b6+=0x1){socket[_0xa9c5('0x68')](_0xa9c5('0x85'),{'UserId':Number(_0x3a98d[_0xa9c5('0x35')][_0xa9c5('0x6b')][_0x4453b6]),'SmsQueueId':Number(_0x3a98d[_0xa9c5('0x49')]['id'])});}}else{socket[_0xa9c5('0x68')]('userSmsQueue:remove',{'UserId':Number(_0x3a98d['query'][_0xa9c5('0x6b')]),'SmsQueueId':Number(_0x3a98d[_0xa9c5('0x49')]['id'])});}});}})[_0xa9c5('0x27')](respondWithStatusCode(_0x193fe0,null))[_0xa9c5('0x47')](handleError(_0x193fe0,null));};exports['getAgents']=function(_0x5361de,_0x214caa,_0x3fa107){var _0xf87d86={};var _0x390231={};var _0x43eec6;var _0x3dc8fc;return db[_0xa9c5('0x30')][_0xa9c5('0x60')]({'where':{'id':_0x5361de[_0xa9c5('0x49')]['id']}})['then'](handleEntityNotFound(_0x214caa,null))[_0xa9c5('0x27')](function(_0x2a5047){if(_0x2a5047){_0x43eec6=_0x2a5047;_0x390231[_0xa9c5('0x34')]=_[_0xa9c5('0x36')](db[_0xa9c5('0x63')][_0xa9c5('0x31')]);_0x390231[_0xa9c5('0x35')]=_[_0xa9c5('0x36')](_0x5361de[_0xa9c5('0x35')]);_0x390231[_0xa9c5('0x37')]=_[_0xa9c5('0x38')](_0x390231[_0xa9c5('0x34')],_0x390231[_0xa9c5('0x35')]);_0xf87d86[_0xa9c5('0x39')]=_[_0xa9c5('0x38')](_0x390231['model'],qs[_0xa9c5('0x3a')](_0x5361de[_0xa9c5('0x35')][_0xa9c5('0x3a')]));_0xf87d86['attributes']=_0xf87d86[_0xa9c5('0x39')]['length']?_0xf87d86[_0xa9c5('0x39')]:_0x390231[_0xa9c5('0x34')];_0xf87d86[_0xa9c5('0x3c')]=qs[_0xa9c5('0x3d')](_0x5361de[_0xa9c5('0x35')][_0xa9c5('0x3d')]);_0xf87d86[_0xa9c5('0x3e')]=qs[_0xa9c5('0x37')](_[_0xa9c5('0x3f')](_0x5361de['query'],_0x390231[_0xa9c5('0x37')]));if(_0x5361de[_0xa9c5('0x35')][_0xa9c5('0x40')]){_0xf87d86[_0xa9c5('0x3e')]=_[_0xa9c5('0x42')](_0xf87d86['where'],{'$or':_[_0xa9c5('0x2f')](_0xf87d86[_0xa9c5('0x39')],function(_0x3ab370){var _0x9b645b={};_0x9b645b[_0x3ab370]={'$like':'%'+_0x5361de[_0xa9c5('0x35')]['filter']+'%'};return _0x9b645b;})});}_0xf87d86=_[_0xa9c5('0x42')]({},_0xf87d86,_0x5361de['options']);return _0x43eec6[_0xa9c5('0x86')](_0xf87d86);}})[_0xa9c5('0x27')](function(_0x14fe27){if(_0x14fe27){_0x3dc8fc=_0x14fe27[_0xa9c5('0x4a')];if(!_0x5361de[_0xa9c5('0x35')][_0xa9c5('0x3b')](_0xa9c5('0x87'))){_0xf87d86[_0xa9c5('0x22')]=qs[_0xa9c5('0x22')](_0x5361de[_0xa9c5('0x35')][_0xa9c5('0x22')]);_0xf87d86[_0xa9c5('0x21')]=qs[_0xa9c5('0x21')](_0x5361de[_0xa9c5('0x35')][_0xa9c5('0x21')]);}return _0x43eec6[_0xa9c5('0x86')](_0xf87d86);}})[_0xa9c5('0x27')](function(_0x523391){if(_0x523391){return _0x523391?{'count':_0x3dc8fc,'rows':_0x523391}:null;}})[_0xa9c5('0x27')](respondWithResult(_0x214caa,null))[_0xa9c5('0x47')](handleError(_0x214caa,null));};