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 _0x1bc9=['../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','redis','defaults','localhost','register','sendStatus','status','json','count','offset','limit','Content-Range','apply','save','then','destroy','get','end','error','stack','name','send','index','map','rawAttributes','fieldName','type','model','keys','query','filters','intersection','fields','length','attributes','hasOwnProperty','order','sort','pick','filter','merge','where','VIRTUAL','SmsQueue','includeAll','findAll','rows','catch','params','include','find','create','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','user','SmsQueues','update','body','describe','findOne','UserSmsQueue','nolimit','SmsQueueId','options','User','findAndCountAll','UserId','agent','smsPause','updatedAt','createdAt','format','%s/%s','SIP','Team','getTeams','addTeams','ids','online','voicePause','interface','flatMap','Agents','sequelize','transaction','findOrCreate','removeTeams','field','tq.TeamId','from','team_has_sms_queues','join','user_has_teams','SmsQueueId\x20=\x20?','clone','ut.UserId\x20=\x20?','SELECT','every','TeamId','includes','all','union','compact','value','removeAgents','emit','userSmsQueue:remove','addAgents','spread','userSmsQueue:save','getAgents','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','sox','ejs','lodash','squel','crypto','jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch'];(function(_0x270dba,_0x1817d2){var _0x36b83b=function(_0x15a276){while(--_0x15a276){_0x270dba['push'](_0x270dba['shift']());}};_0x36b83b(++_0x1817d2);}(_0x1bc9,0xfb));var _0x91bc=function(_0x4a8bfd,_0x2849a8){_0x4a8bfd=_0x4a8bfd-0x0;var _0x562bd9=_0x1bc9[_0x4a8bfd];return _0x562bd9;};'use strict';var pdf=require(_0x91bc('0x0'));var emlformat=require(_0x91bc('0x1'));var rimraf=require(_0x91bc('0x2'));var zipdir=require(_0x91bc('0x3'));var jsonpatch=require(_0x91bc('0x4'));var rp=require(_0x91bc('0x5'));var moment=require(_0x91bc('0x6'));var BPromise=require(_0x91bc('0x7'));var Mustache=require(_0x91bc('0x8'));var util=require('util');var path=require('path');var sox=require(_0x91bc('0x9'));var csv=require('to-csv');var ejs=require(_0x91bc('0xa'));var fs=require('fs');var _=require(_0x91bc('0xb'));var squel=require(_0x91bc('0xc'));var crypto=require(_0x91bc('0xd'));var jsforce=require(_0x91bc('0xe'));var deskjs=require(_0x91bc('0xf'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0x91bc('0x10'));var Redis=require(_0x91bc('0x11'));var authService=require(_0x91bc('0x12'));var qs=require(_0x91bc('0x13'));var as=require(_0x91bc('0x14'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x91bc('0x15'))(_0x91bc('0x16'));var utils=require(_0x91bc('0x17'));var config=require(_0x91bc('0x18'));var db=require(_0x91bc('0x19'))['db'];config[_0x91bc('0x1a')]=_[_0x91bc('0x1b')](config[_0x91bc('0x1a')],{'host':_0x91bc('0x1c'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0x91bc('0x1a')]));require('./smsQueue.socket')[_0x91bc('0x1d')](socket);function respondWithStatusCode(_0xc3c238,_0x247304){_0x247304=_0x247304||0xcc;return function(_0x5d319f){if(_0x5d319f){return _0xc3c238[_0x91bc('0x1e')](_0x247304);}return _0xc3c238[_0x91bc('0x1f')](_0x247304)['end']();};}function respondWithResult(_0x1b77f8,_0x4f9be8){_0x4f9be8=_0x4f9be8||0xc8;return function(_0x4a72c9){if(_0x4a72c9){return _0x1b77f8['status'](_0x4f9be8)[_0x91bc('0x20')](_0x4a72c9);}};}function respondWithFilteredResult(_0x356c24,_0x22f335){return function(_0x31d1ca){if(_0x31d1ca){var _0x5e4f8e=_0x31d1ca[_0x91bc('0x21')],_0x13fac4=_0x22f335[_0x91bc('0x22')],_0x46a2f4=_0x22f335['offset']+_0x22f335[_0x91bc('0x23')],_0x2e3f47;if(_0x46a2f4>=_0x5e4f8e){_0x46a2f4=_0x5e4f8e;_0x2e3f47=0xc8;}else{_0x2e3f47=0xce;}_0x356c24[_0x91bc('0x1f')](_0x2e3f47);return _0x356c24['set'](_0x91bc('0x24'),_0x13fac4+'-'+_0x46a2f4+'/'+_0x5e4f8e)[_0x91bc('0x20')](_0x31d1ca);}return null;};}function patchUpdates(_0x218e1a){return function(_0x1106c4){try{jsonpatch[_0x91bc('0x25')](_0x1106c4,_0x218e1a,!![]);}catch(_0x14003c){return BPromise['reject'](_0x14003c);}return _0x1106c4[_0x91bc('0x26')]();};}function saveUpdates(_0x5ad2fc,_0x9d4488){return function(_0x17154a){if(_0x17154a){return _0x17154a['update'](_0x5ad2fc)[_0x91bc('0x27')](function(_0x5b260e){return _0x5b260e;});}return null;};}function removeEntity(_0x1b9d29,_0x40cec5){return function(_0x9bfa0f){if(_0x9bfa0f){return _0x9bfa0f[_0x91bc('0x28')]()[_0x91bc('0x27')](function(){var _0x3ba807=_0x9bfa0f[_0x91bc('0x29')]({'plain':!![]});var _0x161c0a='SmsQueues';return db['UserProfileResource'][_0x91bc('0x28')]({'where':{'type':_0x161c0a,'resourceId':_0x3ba807['id']}})[_0x91bc('0x27')](function(){return _0x9bfa0f;});})[_0x91bc('0x27')](function(){_0x1b9d29['status'](0xcc)[_0x91bc('0x2a')]();});}};}function handleEntityNotFound(_0xb8ded4,_0x2bd801){return function(_0x4f5cb6){if(!_0x4f5cb6){_0xb8ded4[_0x91bc('0x1e')](0x194);}return _0x4f5cb6;};}function handleError(_0x4ebfec,_0x2c9a50){_0x2c9a50=_0x2c9a50||0x1f4;return function(_0x423e6a){logger[_0x91bc('0x2b')](_0x423e6a[_0x91bc('0x2c')]);if(_0x423e6a[_0x91bc('0x2d')]){delete _0x423e6a[_0x91bc('0x2d')];}_0x4ebfec['status'](_0x2c9a50)[_0x91bc('0x2e')](_0x423e6a);};}exports[_0x91bc('0x2f')]=function(_0x262ac5,_0x4e4062){var _0x1cc31e={},_0x512eb2={},_0x49090b={'count':0x0,'rows':[]};var _0x8b0994=_[_0x91bc('0x30')](db['SmsQueue'][_0x91bc('0x31')],function(_0x509ea8){return{'name':_0x509ea8[_0x91bc('0x32')],'type':_0x509ea8[_0x91bc('0x33')]['key']};});_0x512eb2[_0x91bc('0x34')]=_[_0x91bc('0x30')](_0x8b0994,'name');_0x512eb2['query']=_[_0x91bc('0x35')](_0x262ac5[_0x91bc('0x36')]);_0x512eb2[_0x91bc('0x37')]=_['intersection'](_0x512eb2['model'],_0x512eb2[_0x91bc('0x36')]);_0x1cc31e['attributes']=_[_0x91bc('0x38')](_0x512eb2[_0x91bc('0x34')],qs[_0x91bc('0x39')](_0x262ac5['query'][_0x91bc('0x39')]));_0x1cc31e['attributes']=_0x1cc31e['attributes'][_0x91bc('0x3a')]?_0x1cc31e[_0x91bc('0x3b')]:_0x512eb2[_0x91bc('0x34')];if(!_0x262ac5[_0x91bc('0x36')][_0x91bc('0x3c')]('nolimit')){_0x1cc31e['limit']=qs['limit'](_0x262ac5['query']['limit']);_0x1cc31e[_0x91bc('0x22')]=qs[_0x91bc('0x22')](_0x262ac5['query']['offset']);}_0x1cc31e[_0x91bc('0x3d')]=qs[_0x91bc('0x3e')](_0x262ac5[_0x91bc('0x36')]['sort']);_0x1cc31e['where']=qs[_0x91bc('0x37')](_[_0x91bc('0x3f')](_0x262ac5[_0x91bc('0x36')],_0x512eb2[_0x91bc('0x37')]),_0x8b0994);if(_0x262ac5['query'][_0x91bc('0x40')]){_0x1cc31e['where']=_[_0x91bc('0x41')](_0x1cc31e[_0x91bc('0x42')],{'$or':_[_0x91bc('0x30')](_0x8b0994,function(_0x263673){if(_0x263673[_0x91bc('0x33')]!==_0x91bc('0x43')){var _0x3d5ba8={};_0x3d5ba8[_0x263673[_0x91bc('0x2d')]]={'$like':'%'+_0x262ac5['query'][_0x91bc('0x40')]+'%'};return _0x3d5ba8;}})});}_0x1cc31e=_[_0x91bc('0x41')]({},_0x1cc31e,_0x262ac5['options']);var _0x537d82={'where':_0x1cc31e[_0x91bc('0x42')]};return db[_0x91bc('0x44')][_0x91bc('0x21')](_0x537d82)[_0x91bc('0x27')](function(_0x4440e6){_0x49090b[_0x91bc('0x21')]=_0x4440e6;if(_0x262ac5[_0x91bc('0x36')][_0x91bc('0x45')]){_0x1cc31e['include']=[{'all':!![]}];}return db[_0x91bc('0x44')][_0x91bc('0x46')](_0x1cc31e);})[_0x91bc('0x27')](function(_0x29bdcd){_0x49090b[_0x91bc('0x47')]=_0x29bdcd;return _0x49090b;})['then'](respondWithFilteredResult(_0x4e4062,_0x1cc31e))[_0x91bc('0x48')](handleError(_0x4e4062,null));};exports['show']=function(_0x425ce0,_0x27e414){var _0x3e93fa={'raw':!![],'where':{'id':_0x425ce0[_0x91bc('0x49')]['id']}},_0x525983={};_0x525983['model']=_['keys'](db[_0x91bc('0x44')][_0x91bc('0x31')]);_0x525983[_0x91bc('0x36')]=_[_0x91bc('0x35')](_0x425ce0[_0x91bc('0x36')]);_0x525983['filters']=_['intersection'](_0x525983['model'],_0x525983[_0x91bc('0x36')]);_0x3e93fa[_0x91bc('0x3b')]=_['intersection'](_0x525983[_0x91bc('0x34')],qs[_0x91bc('0x39')](_0x425ce0[_0x91bc('0x36')][_0x91bc('0x39')]));_0x3e93fa['attributes']=_0x3e93fa['attributes'][_0x91bc('0x3a')]?_0x3e93fa['attributes']:_0x525983[_0x91bc('0x34')];if(_0x425ce0[_0x91bc('0x36')][_0x91bc('0x45')]){_0x3e93fa[_0x91bc('0x4a')]=[{'all':!![]}];}_0x3e93fa=_[_0x91bc('0x41')]({},_0x3e93fa,_0x425ce0['options']);return db['SmsQueue'][_0x91bc('0x4b')](_0x3e93fa)[_0x91bc('0x27')](handleEntityNotFound(_0x27e414,null))[_0x91bc('0x27')](respondWithResult(_0x27e414,null))[_0x91bc('0x48')](handleError(_0x27e414,null));};exports[_0x91bc('0x4c')]=function(_0xdfa3bc,_0x5ac7c4){return db[_0x91bc('0x44')][_0x91bc('0x4c')](_0xdfa3bc['body'],{})['then'](function(_0x205607){var _0x3ed5c7=_0xdfa3bc['user'][_0x91bc('0x29')]({'plain':!![]});if(!_0x3ed5c7)throw new Error(_0x91bc('0x4d'));if(_0x3ed5c7[_0x91bc('0x4e')]===_0x91bc('0x4f')){var _0x315513=_0x205607[_0x91bc('0x29')]({'plain':!![]});var _0x115128=_0x91bc('0x50');return db['UserProfileSection'][_0x91bc('0x4b')]({'where':{'name':_0x115128,'userProfileId':_0x3ed5c7['userProfileId']},'raw':!![]})['then'](function(_0x18ec5e){if(_0x18ec5e&&_0x18ec5e['autoAssociation']===0x0){return db['UserProfileResource'][_0x91bc('0x4c')]({'name':_0x315513[_0x91bc('0x2d')],'resourceId':_0x315513['id'],'type':_0x18ec5e[_0x91bc('0x2d')],'sectionId':_0x18ec5e['id']},{})['then'](function(){return _0x205607;});}else{return _0x205607;}})['catch'](function(_0x4588f1){logger[_0x91bc('0x2b')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x4588f1);throw _0x4588f1;});}return _0x205607;})[_0x91bc('0x27')](respondWithResult(_0x5ac7c4,0xc9))['catch'](handleError(_0x5ac7c4,null));};exports[_0x91bc('0x51')]=function(_0x2e8208,_0x23c75f){if(_0x2e8208[_0x91bc('0x52')]['id']){delete _0x2e8208['body']['id'];}return db[_0x91bc('0x44')][_0x91bc('0x4b')]({'where':{'id':_0x2e8208[_0x91bc('0x49')]['id']}})[_0x91bc('0x27')](handleEntityNotFound(_0x23c75f,null))[_0x91bc('0x27')](saveUpdates(_0x2e8208[_0x91bc('0x52')],null))[_0x91bc('0x27')](respondWithResult(_0x23c75f,null))[_0x91bc('0x48')](handleError(_0x23c75f,null));};exports[_0x91bc('0x28')]=function(_0x1fc717,_0x598777){return db[_0x91bc('0x44')]['find']({'where':{'id':_0x1fc717[_0x91bc('0x49')]['id']}})[_0x91bc('0x27')](handleEntityNotFound(_0x598777,null))[_0x91bc('0x27')](removeEntity(_0x598777,null))[_0x91bc('0x48')](handleError(_0x598777,null));};exports[_0x91bc('0x53')]=function(_0x13ca87,_0x22459f){return db[_0x91bc('0x44')][_0x91bc('0x53')]()[_0x91bc('0x27')](respondWithResult(_0x22459f,null))[_0x91bc('0x48')](handleError(_0x22459f,null));};exports['getMembers']=function(_0x34b0e3,_0x5d285a,_0x34428f){var _0x5af259={'raw':!![],'where':{}},_0x48c5d8={},_0x1d8988;return db[_0x91bc('0x44')][_0x91bc('0x54')]({'where':{'id':_0x34b0e3[_0x91bc('0x49')]['id']}})['then'](handleEntityNotFound(_0x5d285a,null))[_0x91bc('0x27')](function(_0x38f3da){if(_0x38f3da){_0x1d8988=_0x38f3da[_0x91bc('0x29')]({'plain':!![]});_0x48c5d8[_0x91bc('0x34')]=_['keys'](db[_0x91bc('0x55')][_0x91bc('0x31')]);_0x48c5d8[_0x91bc('0x36')]=_['keys'](_0x34b0e3[_0x91bc('0x36')]);_0x48c5d8[_0x91bc('0x37')]=_[_0x91bc('0x38')](_0x48c5d8['model'],_0x48c5d8[_0x91bc('0x36')]);_0x5af259[_0x91bc('0x3b')]=_[_0x91bc('0x38')](_0x48c5d8[_0x91bc('0x34')],qs[_0x91bc('0x39')](_0x34b0e3['query'][_0x91bc('0x39')]));_0x5af259['attributes']=_0x5af259[_0x91bc('0x3b')][_0x91bc('0x3a')]?_0x5af259['attributes']:_0x48c5d8[_0x91bc('0x34')];if(!_0x34b0e3[_0x91bc('0x36')][_0x91bc('0x3c')](_0x91bc('0x56'))){_0x5af259[_0x91bc('0x23')]=qs[_0x91bc('0x23')](_0x34b0e3[_0x91bc('0x36')][_0x91bc('0x23')]);_0x5af259[_0x91bc('0x22')]=qs['offset'](_0x34b0e3[_0x91bc('0x36')][_0x91bc('0x22')]);}_0x5af259[_0x91bc('0x3d')]=qs[_0x91bc('0x3e')](_0x34b0e3['query']['sort']);_0x5af259[_0x91bc('0x42')]=qs['filters'](_[_0x91bc('0x3f')](_0x34b0e3[_0x91bc('0x36')],_0x48c5d8[_0x91bc('0x37')]));_0x5af259['where'][_0x91bc('0x57')]=_0x38f3da['id'];if(_0x34b0e3[_0x91bc('0x36')]['filter']){_0x5af259[_0x91bc('0x42')]=_['merge'](_0x5af259[_0x91bc('0x42')],{'$or':_['map'](_0x5af259[_0x91bc('0x3b')],function(_0x3ee36d){var _0x1d45bf={};_0x1d45bf[_0x3ee36d]={'$like':'%'+_0x34b0e3[_0x91bc('0x36')][_0x91bc('0x40')]+'%'};return _0x1d45bf;})});}_0x5af259=_['merge']({},_0x5af259,_0x34b0e3[_0x91bc('0x58')]);return db[_0x91bc('0x55')][_0x91bc('0x46')](_0x5af259);}})[_0x91bc('0x27')](function(_0x497fc2){if(_0x497fc2){return db[_0x91bc('0x59')][_0x91bc('0x5a')]({'where':{'id':_[_0x91bc('0x30')](_0x497fc2,_0x91bc('0x5b')),'role':_0x91bc('0x5c')},'attributes':['id',_0x91bc('0x2d'),_0x91bc('0x5d'),_0x91bc('0x5e'),_0x91bc('0x5f')]});}})[_0x91bc('0x27')](function(_0x44bea0){if(_0x44bea0){return{'count':_0x44bea0[_0x91bc('0x21')],'rows':_[_0x91bc('0x30')](_0x44bea0[_0x91bc('0x47')],function(_0x521df6){return{'membername':_0x521df6[_0x91bc('0x2d')],'UserId':_0x521df6['id'],'queue_name':_0x1d8988[_0x91bc('0x2d')],'SmsQueueId':_0x1d8988['id'],'interface':util[_0x91bc('0x60')](_0x91bc('0x61'),_0x91bc('0x62'),_0x521df6[_0x91bc('0x2d')]),'penalty':0x0,'paused':_0x521df6[_0x91bc('0x5d')],'createdAt':_0x521df6[_0x91bc('0x5f')],'updatedAt':_0x521df6[_0x91bc('0x5e')]};})};}else{return{'count':0x0,'rows':[]};}})[_0x91bc('0x27')](respondWithFilteredResult(_0x5d285a,_0x5af259))[_0x91bc('0x48')](handleError(_0x5d285a,null));};exports['getTeams']=function(_0x518c22,_0x259d2e,_0x273d06){var _0x4052d6={};var _0x15ac09={};var _0x261f1c;var _0x10914d;return db[_0x91bc('0x44')][_0x91bc('0x54')]({'where':{'id':_0x518c22['params']['id']}})[_0x91bc('0x27')](handleEntityNotFound(_0x259d2e,null))[_0x91bc('0x27')](function(_0x243e04){if(_0x243e04){_0x261f1c=_0x243e04;_0x15ac09[_0x91bc('0x34')]=_['keys'](db[_0x91bc('0x63')]['rawAttributes']);_0x15ac09[_0x91bc('0x36')]=_[_0x91bc('0x35')](_0x518c22[_0x91bc('0x36')]);_0x15ac09[_0x91bc('0x37')]=_[_0x91bc('0x38')](_0x15ac09[_0x91bc('0x34')],_0x15ac09['query']);_0x4052d6[_0x91bc('0x3b')]=_['intersection'](_0x15ac09[_0x91bc('0x34')],qs['fields'](_0x518c22[_0x91bc('0x36')][_0x91bc('0x39')]));_0x4052d6[_0x91bc('0x3b')]=_0x4052d6['attributes'][_0x91bc('0x3a')]?_0x4052d6[_0x91bc('0x3b')]:_0x15ac09[_0x91bc('0x34')];_0x4052d6[_0x91bc('0x3d')]=qs[_0x91bc('0x3e')](_0x518c22['query'][_0x91bc('0x3e')]);_0x4052d6[_0x91bc('0x42')]=qs[_0x91bc('0x37')](_[_0x91bc('0x3f')](_0x518c22[_0x91bc('0x36')],_0x15ac09[_0x91bc('0x37')]));if(_0x518c22[_0x91bc('0x36')][_0x91bc('0x40')]){_0x4052d6[_0x91bc('0x42')]=_[_0x91bc('0x41')](_0x4052d6[_0x91bc('0x42')],{'$or':_['map'](_0x4052d6[_0x91bc('0x3b')],function(_0x443ac5){var _0x13c451={};_0x13c451[_0x443ac5]={'$like':'%'+_0x518c22[_0x91bc('0x36')]['filter']+'%'};return _0x13c451;})});}_0x4052d6=_[_0x91bc('0x41')]({},_0x4052d6,_0x518c22[_0x91bc('0x58')]);return _0x261f1c['getTeams'](_0x4052d6);}})['then'](function(_0xc41eaa){if(_0xc41eaa){_0x10914d=_0xc41eaa['length'];if(!_0x518c22[_0x91bc('0x36')][_0x91bc('0x3c')](_0x91bc('0x56'))){_0x4052d6[_0x91bc('0x23')]=qs[_0x91bc('0x23')](_0x518c22[_0x91bc('0x36')][_0x91bc('0x23')]);_0x4052d6['offset']=qs[_0x91bc('0x22')](_0x518c22[_0x91bc('0x36')][_0x91bc('0x22')]);}return _0x261f1c[_0x91bc('0x64')](_0x4052d6);}})[_0x91bc('0x27')](function(_0x2592cd){if(_0x2592cd){return _0x2592cd?{'count':_0x10914d,'rows':_0x2592cd}:null;}})['then'](respondWithResult(_0x259d2e,null))[_0x91bc('0x48')](handleError(_0x259d2e,null));};exports[_0x91bc('0x65')]=function(_0x445d61,_0xf5206,_0x57d4ed){var _0x43b619=_0x445d61[_0x91bc('0x52')][_0x91bc('0x66')];return db[_0x91bc('0x63')][_0x91bc('0x46')]({'where':{'id':_0x43b619},'attributes':['id'],'include':[{'model':db['User'],'as':'Agents','attributes':['id',_0x91bc('0x2d'),_0x91bc('0x67'),_0x91bc('0x68'),_0x91bc('0x69')],'raw':!![]}]})[_0x91bc('0x27')](function(_0x306106){if(_0x306106){var _0x24e9c9=_[_0x91bc('0x6a')](_0x306106,function(_0x34f26e){var _0x2ccb28=_0x34f26e['get']({'plain':!![]});return _0x2ccb28[_0x91bc('0x6b')];});return db['SmsQueue']['find']({'where':{'id':_0x445d61[_0x91bc('0x49')]['id']}})[_0x91bc('0x27')](function(_0xdf47b){return db[_0x91bc('0x6c')][_0x91bc('0x6d')](function(_0x5802f8){return _0xdf47b['addTeams'](_0x43b619,{'transaction':_0x5802f8})['then'](function(){return BPromise['each'](_0x24e9c9,function(_0x311e2e){return db['UserSmsQueue'][_0x91bc('0x6e')]({'where':{'UserId':_0x311e2e['id'],'SmsQueueId':_0x445d61[_0x91bc('0x49')]['id']},'transaction':_0x5802f8});});})[_0x91bc('0x27')](function(){_0x24e9c9['forEach'](function(_0x5df5cc){socket['emit']('userSmsQueue:save',{'UserId':_0x5df5cc['id'],'SmsQueueId':_0xdf47b['id']});});});});});}})['then'](respondWithStatusCode(_0xf5206,null))[_0x91bc('0x48')](handleError(_0xf5206,null));};exports[_0x91bc('0x6f')]=function(_0x374ebb,_0x21e8e7,_0x531c6b){return db['Team'][_0x91bc('0x46')]({'where':{'id':_0x374ebb[_0x91bc('0x36')][_0x91bc('0x66')]},'attributes':['id'],'include':[{'model':db[_0x91bc('0x59')],'as':'Agents','attributes':['id'],'raw':!![]}]})[_0x91bc('0x27')](handleEntityNotFound(_0x21e8e7,null))['then'](function(_0x404204){var _0x1a2506=_[_0x91bc('0x30')](_0x404204,'id');var _0x242966=[];var _0x41d8c1=[];var _0x24ff53=squel['select']();_0x24ff53[_0x91bc('0x70')](_0x91bc('0x71'))[_0x91bc('0x72')](_0x91bc('0x73'),'tq')[_0x91bc('0x74')](_0x91bc('0x75'),'ut','ut.TeamId\x20=\x20tq.TeamId')[_0x91bc('0x42')](_0x91bc('0x76'),_0x374ebb[_0x91bc('0x49')]['id']);for(var _0x597b59=0x0;_0x597b59<_0x404204[_0x91bc('0x3a')];_0x597b59+=0x1){let _0x400da0=_0x404204[_0x597b59];for(var _0x1fd6c6=0x0;_0x1fd6c6<_0x400da0[_0x91bc('0x6b')][_0x91bc('0x3a')];_0x1fd6c6+=0x1){let _0x1a07ad=_0x400da0[_0x91bc('0x6b')][_0x1fd6c6];var _0x590950=_0x24ff53[_0x91bc('0x77')]();_0x590950['where'](_0x91bc('0x78'),_0x1a07ad['id']);_0x41d8c1['push'](db[_0x91bc('0x6c')][_0x91bc('0x36')](_0x590950['toString'](),{'type':db[_0x91bc('0x6c')]['QueryTypes'][_0x91bc('0x79')]})[_0x91bc('0x27')](function(_0x4c63f0){if(_0x4c63f0[_0x91bc('0x3a')]===0x1){return _0x1a07ad['id'];}else{var _0xeb9a39=_[_0x91bc('0x7a')](_[_0x91bc('0x30')](_0x4c63f0,_0x91bc('0x7b')),function(_0x252b04){return _[_0x91bc('0x7c')](_0x1a2506,_0x252b04);});if(_0xeb9a39){return _0x1a07ad['id'];}}}));}}return BPromise[_0x91bc('0x7d')](_0x41d8c1)[_0x91bc('0x27')](function(_0x308992){_0x242966=_(_0x242966)[_0x91bc('0x7e')](_0x308992)[_0x91bc('0x7f')]()[_0x91bc('0x80')]();return db[_0x91bc('0x44')][_0x91bc('0x4b')]({'where':{'id':_0x374ebb[_0x91bc('0x49')]['id']}})['then'](function(_0x3fc5ab){return db[_0x91bc('0x6c')][_0x91bc('0x6d')](function(_0xedd79b){return _0x3fc5ab[_0x91bc('0x6f')](_0x374ebb[_0x91bc('0x36')][_0x91bc('0x66')],{'transaction':_0xedd79b})[_0x91bc('0x27')](function(){if(!_['isEmpty'](_0x242966)){return _0x3fc5ab[_0x91bc('0x81')](_0x242966,{'transaction':_0xedd79b});}})[_0x91bc('0x27')](function(){_0x242966['forEach'](function(_0x10cbd4){socket[_0x91bc('0x82')](_0x91bc('0x83'),{'UserId':_0x10cbd4,'SmsQueueId':_0x3fc5ab['id']});});});});});});})[_0x91bc('0x27')](respondWithStatusCode(_0x21e8e7,null))['catch'](handleError(_0x21e8e7,null));};exports[_0x91bc('0x84')]=function(_0xdcc1dc,_0xefd3b7,_0x260fee){return db[_0x91bc('0x44')]['find']({'where':{'id':_0xdcc1dc[_0x91bc('0x49')]['id']}})[_0x91bc('0x27')](handleEntityNotFound(_0xefd3b7,null))['then'](function(_0x387915){if(_0x387915){return _0x387915[_0x91bc('0x84')](_0xdcc1dc[_0x91bc('0x52')][_0x91bc('0x66')],_['omit'](_0xdcc1dc['body'],[_0x91bc('0x66'),'id'])||{})[_0x91bc('0x85')](function(_0x2ef610){for(var _0x39f04f=0x0;_0x39f04f<_0xdcc1dc[_0x91bc('0x52')][_0x91bc('0x66')][_0x91bc('0x3a')];_0x39f04f+=0x1){socket['emit'](_0x91bc('0x86'),{'UserId':_0xdcc1dc[_0x91bc('0x52')]['ids'][_0x39f04f],'SmsQueueId':_0xdcc1dc[_0x91bc('0x49')]['id']});}return _0x2ef610;});}})[_0x91bc('0x27')](respondWithResult(_0xefd3b7,null))['catch'](handleError(_0xefd3b7,null));};exports[_0x91bc('0x81')]=function(_0x496719,_0x52519d,_0xe7a2cb){return db[_0x91bc('0x44')][_0x91bc('0x4b')]({'where':{'id':_0x496719[_0x91bc('0x49')]['id']}})[_0x91bc('0x27')](handleEntityNotFound(_0x52519d,null))[_0x91bc('0x27')](function(_0x3ff648){if(_0x3ff648){return _0x3ff648[_0x91bc('0x81')](_0x496719['query']['ids'])[_0x91bc('0x27')](function(){if(_['isArray'](_0x496719[_0x91bc('0x36')][_0x91bc('0x66')])){for(var _0xb63358=0x0;_0xb63358<_0x496719[_0x91bc('0x36')]['ids'][_0x91bc('0x3a')];_0xb63358+=0x1){socket[_0x91bc('0x82')](_0x91bc('0x83'),{'UserId':Number(_0x496719[_0x91bc('0x36')][_0x91bc('0x66')][_0xb63358]),'SmsQueueId':Number(_0x496719[_0x91bc('0x49')]['id'])});}}else{socket[_0x91bc('0x82')](_0x91bc('0x83'),{'UserId':Number(_0x496719[_0x91bc('0x36')][_0x91bc('0x66')]),'SmsQueueId':Number(_0x496719[_0x91bc('0x49')]['id'])});}});}})['then'](respondWithStatusCode(_0x52519d,null))['catch'](handleError(_0x52519d,null));};exports['getAgents']=function(_0x288040,_0x420e42,_0x5c6b66){var _0xb6a2de={};var _0x3978c5={};var _0x2bb7d4;var _0x3d26d1;return db['SmsQueue'][_0x91bc('0x54')]({'where':{'id':_0x288040[_0x91bc('0x49')]['id']}})[_0x91bc('0x27')](handleEntityNotFound(_0x420e42,null))[_0x91bc('0x27')](function(_0x21d136){if(_0x21d136){_0x2bb7d4=_0x21d136;_0x3978c5[_0x91bc('0x34')]=_['keys'](db[_0x91bc('0x59')][_0x91bc('0x31')]);_0x3978c5['query']=_[_0x91bc('0x35')](_0x288040[_0x91bc('0x36')]);_0x3978c5[_0x91bc('0x37')]=_['intersection'](_0x3978c5[_0x91bc('0x34')],_0x3978c5['query']);_0xb6a2de[_0x91bc('0x3b')]=_[_0x91bc('0x38')](_0x3978c5['model'],qs[_0x91bc('0x39')](_0x288040['query'][_0x91bc('0x39')]));_0xb6a2de[_0x91bc('0x3b')]=_0xb6a2de['attributes'][_0x91bc('0x3a')]?_0xb6a2de[_0x91bc('0x3b')]:_0x3978c5['model'];_0xb6a2de[_0x91bc('0x3d')]=qs[_0x91bc('0x3e')](_0x288040['query'][_0x91bc('0x3e')]);_0xb6a2de['where']=qs[_0x91bc('0x37')](_[_0x91bc('0x3f')](_0x288040[_0x91bc('0x36')],_0x3978c5[_0x91bc('0x37')]));if(_0x288040[_0x91bc('0x36')][_0x91bc('0x40')]){_0xb6a2de[_0x91bc('0x42')]=_[_0x91bc('0x41')](_0xb6a2de['where'],{'$or':_[_0x91bc('0x30')](_0xb6a2de[_0x91bc('0x3b')],function(_0x18f0f1){var _0x21e133={};_0x21e133[_0x18f0f1]={'$like':'%'+_0x288040['query'][_0x91bc('0x40')]+'%'};return _0x21e133;})});}_0xb6a2de=_[_0x91bc('0x41')]({},_0xb6a2de,_0x288040[_0x91bc('0x58')]);return _0x2bb7d4[_0x91bc('0x87')](_0xb6a2de);}})[_0x91bc('0x27')](function(_0x301b30){if(_0x301b30){_0x3d26d1=_0x301b30[_0x91bc('0x3a')];if(!_0x288040[_0x91bc('0x36')][_0x91bc('0x3c')]('nolimit')){_0xb6a2de[_0x91bc('0x23')]=qs[_0x91bc('0x23')](_0x288040[_0x91bc('0x36')][_0x91bc('0x23')]);_0xb6a2de[_0x91bc('0x22')]=qs[_0x91bc('0x22')](_0x288040[_0x91bc('0x36')][_0x91bc('0x22')]);}return _0x2bb7d4['getAgents'](_0xb6a2de);}})['then'](function(_0x22923b){if(_0x22923b){return _0x22923b?{'count':_0x3d26d1,'rows':_0x22923b}:null;}})[_0x91bc('0x27')](respondWithResult(_0x420e42,null))[_0x91bc('0x48')](handleError(_0x420e42,null));};