Built motion from commit (unavailable).|2.5.24
[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 _0x0b78=['SELECT','every','TeamId','includes','union','compact','transaction','isEmpty','removeAgents','userSmsQueue:remove','addAgents','omit','isArray','emit','getAgents','html-pdf','eml-format','zip-dir','fast-json-patch','moment','mustache','util','path','ejs','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','redis','defaults','localhost','./smsQueue.socket','sendStatus','status','end','json','offset','limit','set','apply','save','update','then','destroy','get','SmsQueues','UserProfileResource','error','stack','name','send','index','map','fieldName','type','key','model','query','keys','filters','intersection','fields','attributes','length','hasOwnProperty','nolimit','order','sort','where','pick','merge','options','SmsQueue','count','includeAll','rows','catch','show','params','rawAttributes','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','userProfileId','autoAssociation','describe','getMembers','UserSmsQueue','SmsQueueId','filter','findAll','User','findAndCountAll','UserId','agent','createdAt','%s/%s','SIP','smsPause','findOne','getTeams','addTeams','ids','Team','Agents','online','voicePause','findOrCreate','forEach','userSmsQueue:save','removeTeams','select','tq.TeamId','from','team_has_sms_queues','join','ut.TeamId\x20=\x20tq.TeamId','SmsQueueId\x20=\x20?','clone','ut.UserId\x20=\x20?','push','sequelize','toString','QueryTypes'];(function(_0x6173fc,_0x32aadf){var _0x965fbe=function(_0x50d5b3){while(--_0x50d5b3){_0x6173fc['push'](_0x6173fc['shift']());}};_0x965fbe(++_0x32aadf);}(_0x0b78,0x1ad));var _0x80b7=function(_0x2641f9,_0x26715f){_0x2641f9=_0x2641f9-0x0;var _0x585741=_0x0b78[_0x2641f9];return _0x585741;};'use strict';var pdf=require(_0x80b7('0x0'));var emlformat=require(_0x80b7('0x1'));var rimraf=require('rimraf');var zipdir=require(_0x80b7('0x2'));var jsonpatch=require(_0x80b7('0x3'));var rp=require('request-promise');var moment=require(_0x80b7('0x4'));var BPromise=require('bluebird');var Mustache=require(_0x80b7('0x5'));var util=require(_0x80b7('0x6'));var path=require(_0x80b7('0x7'));var sox=require('sox');var csv=require('to-csv');var ejs=require(_0x80b7('0x8'));var fs=require('fs');var _=require('lodash');var squel=require(_0x80b7('0x9'));var crypto=require(_0x80b7('0xa'));var jsforce=require(_0x80b7('0xb'));var deskjs=require(_0x80b7('0xc'));var toCsv=require('to-csv');var querystring=require(_0x80b7('0xd'));var Papa=require(_0x80b7('0xe'));var Redis=require(_0x80b7('0xf'));var authService=require('../../components/auth/service');var qs=require(_0x80b7('0x10'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x80b7('0x11'));var logger=require(_0x80b7('0x12'))(_0x80b7('0x13'));var utils=require(_0x80b7('0x14'));var config=require(_0x80b7('0x15'));var licenseUtil=require(_0x80b7('0x16'));var db=require(_0x80b7('0x17'))['db'];config[_0x80b7('0x18')]=_[_0x80b7('0x19')](config[_0x80b7('0x18')],{'host':_0x80b7('0x1a'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0x80b7('0x18')]));require(_0x80b7('0x1b'))['register'](socket);function respondWithStatusCode(_0x2ee168,_0x1a6317){_0x1a6317=_0x1a6317||0xcc;return function(_0x4aaa02){if(_0x4aaa02){return _0x2ee168[_0x80b7('0x1c')](_0x1a6317);}return _0x2ee168[_0x80b7('0x1d')](_0x1a6317)[_0x80b7('0x1e')]();};}function respondWithResult(_0x2c0c4e,_0x36d0bb){_0x36d0bb=_0x36d0bb||0xc8;return function(_0x352805){if(_0x352805){return _0x2c0c4e[_0x80b7('0x1d')](_0x36d0bb)[_0x80b7('0x1f')](_0x352805);}};}function respondWithFilteredResult(_0x2d4008,_0x34299c){return function(_0x4c12b1){if(_0x4c12b1){var _0x3bb691=_0x4c12b1['count'],_0x1d62ed=_0x34299c['offset'],_0x205457=_0x34299c[_0x80b7('0x20')]+_0x34299c[_0x80b7('0x21')],_0x125c47;if(_0x205457>=_0x3bb691){_0x205457=_0x3bb691;_0x125c47=0xc8;}else{_0x125c47=0xce;}_0x2d4008[_0x80b7('0x1d')](_0x125c47);return _0x2d4008[_0x80b7('0x22')]('Content-Range',_0x1d62ed+'-'+_0x205457+'/'+_0x3bb691)['json'](_0x4c12b1);}return null;};}function patchUpdates(_0x2aebe3){return function(_0x3aed77){try{jsonpatch[_0x80b7('0x23')](_0x3aed77,_0x2aebe3,!![]);}catch(_0x3ad8c1){return BPromise['reject'](_0x3ad8c1);}return _0x3aed77[_0x80b7('0x24')]();};}function saveUpdates(_0x4c3bed,_0x4d2139){return function(_0x37dd00){if(_0x37dd00){return _0x37dd00[_0x80b7('0x25')](_0x4c3bed)[_0x80b7('0x26')](function(_0x155c00){return _0x155c00;});}return null;};}function removeEntity(_0x3f3aa5,_0x3a029b){return function(_0x29a4e6){if(_0x29a4e6){return _0x29a4e6[_0x80b7('0x27')]()[_0x80b7('0x26')](function(){var _0x1e751a=_0x29a4e6[_0x80b7('0x28')]({'plain':!![]});var _0x311aa3=_0x80b7('0x29');return db[_0x80b7('0x2a')][_0x80b7('0x27')]({'where':{'type':_0x311aa3,'resourceId':_0x1e751a['id']}})['then'](function(){return _0x29a4e6;});})[_0x80b7('0x26')](function(){_0x3f3aa5[_0x80b7('0x1d')](0xcc)['end']();});}};}function handleEntityNotFound(_0x370bfb,_0x37fda1){return function(_0x17d845){if(!_0x17d845){_0x370bfb['sendStatus'](0x194);}return _0x17d845;};}function handleError(_0x1b7715,_0x48995a){_0x48995a=_0x48995a||0x1f4;return function(_0x3ad2ff){logger[_0x80b7('0x2b')](_0x3ad2ff[_0x80b7('0x2c')]);if(_0x3ad2ff[_0x80b7('0x2d')]){delete _0x3ad2ff[_0x80b7('0x2d')];}_0x1b7715[_0x80b7('0x1d')](_0x48995a)[_0x80b7('0x2e')](_0x3ad2ff);};}exports[_0x80b7('0x2f')]=function(_0x3fb3da,_0x44c3ec){var _0xf35e83={},_0x4ae8ad={},_0x5a65b0={'count':0x0,'rows':[]};var _0x36f25e=_[_0x80b7('0x30')](db['SmsQueue']['rawAttributes'],function(_0x106921){return{'name':_0x106921[_0x80b7('0x31')],'type':_0x106921[_0x80b7('0x32')][_0x80b7('0x33')]};});_0x4ae8ad[_0x80b7('0x34')]=_[_0x80b7('0x30')](_0x36f25e,'name');_0x4ae8ad[_0x80b7('0x35')]=_[_0x80b7('0x36')](_0x3fb3da[_0x80b7('0x35')]);_0x4ae8ad[_0x80b7('0x37')]=_['intersection'](_0x4ae8ad[_0x80b7('0x34')],_0x4ae8ad[_0x80b7('0x35')]);_0xf35e83['attributes']=_[_0x80b7('0x38')](_0x4ae8ad[_0x80b7('0x34')],qs[_0x80b7('0x39')](_0x3fb3da[_0x80b7('0x35')][_0x80b7('0x39')]));_0xf35e83[_0x80b7('0x3a')]=_0xf35e83[_0x80b7('0x3a')][_0x80b7('0x3b')]?_0xf35e83['attributes']:_0x4ae8ad['model'];if(!_0x3fb3da['query'][_0x80b7('0x3c')](_0x80b7('0x3d'))){_0xf35e83[_0x80b7('0x21')]=qs[_0x80b7('0x21')](_0x3fb3da[_0x80b7('0x35')][_0x80b7('0x21')]);_0xf35e83[_0x80b7('0x20')]=qs[_0x80b7('0x20')](_0x3fb3da['query'][_0x80b7('0x20')]);}_0xf35e83[_0x80b7('0x3e')]=qs[_0x80b7('0x3f')](_0x3fb3da[_0x80b7('0x35')][_0x80b7('0x3f')]);_0xf35e83[_0x80b7('0x40')]=qs['filters'](_[_0x80b7('0x41')](_0x3fb3da['query'],_0x4ae8ad[_0x80b7('0x37')]),_0x36f25e);if(_0x3fb3da[_0x80b7('0x35')]['filter']){_0xf35e83['where']=_[_0x80b7('0x42')](_0xf35e83['where'],{'$or':_['map'](_0x36f25e,function(_0x295ca6){if(_0x295ca6[_0x80b7('0x32')]!=='VIRTUAL'){var _0xfc8504={};_0xfc8504[_0x295ca6[_0x80b7('0x2d')]]={'$like':'%'+_0x3fb3da['query']['filter']+'%'};return _0xfc8504;}})});}_0xf35e83=_[_0x80b7('0x42')]({},_0xf35e83,_0x3fb3da[_0x80b7('0x43')]);var _0x3b89b4={'where':_0xf35e83[_0x80b7('0x40')]};return db[_0x80b7('0x44')][_0x80b7('0x45')](_0x3b89b4)['then'](function(_0x1c28d2){_0x5a65b0[_0x80b7('0x45')]=_0x1c28d2;if(_0x3fb3da[_0x80b7('0x35')][_0x80b7('0x46')]){_0xf35e83['include']=[{'all':!![]}];}return db[_0x80b7('0x44')]['findAll'](_0xf35e83);})[_0x80b7('0x26')](function(_0x199c29){_0x5a65b0[_0x80b7('0x47')]=_0x199c29;return _0x5a65b0;})[_0x80b7('0x26')](respondWithFilteredResult(_0x44c3ec,_0xf35e83))[_0x80b7('0x48')](handleError(_0x44c3ec,null));};exports[_0x80b7('0x49')]=function(_0x3e77e4,_0x39cd2c){var _0x1c6711={'raw':!![],'where':{'id':_0x3e77e4[_0x80b7('0x4a')]['id']}},_0x1e3456={};_0x1e3456[_0x80b7('0x34')]=_[_0x80b7('0x36')](db['SmsQueue'][_0x80b7('0x4b')]);_0x1e3456[_0x80b7('0x35')]=_['keys'](_0x3e77e4[_0x80b7('0x35')]);_0x1e3456['filters']=_['intersection'](_0x1e3456[_0x80b7('0x34')],_0x1e3456['query']);_0x1c6711['attributes']=_[_0x80b7('0x38')](_0x1e3456[_0x80b7('0x34')],qs['fields'](_0x3e77e4[_0x80b7('0x35')][_0x80b7('0x39')]));_0x1c6711[_0x80b7('0x3a')]=_0x1c6711['attributes'][_0x80b7('0x3b')]?_0x1c6711[_0x80b7('0x3a')]:_0x1e3456[_0x80b7('0x34')];if(_0x3e77e4[_0x80b7('0x35')]['includeAll']){_0x1c6711['include']=[{'all':!![]}];}_0x1c6711=_['merge']({},_0x1c6711,_0x3e77e4[_0x80b7('0x43')]);return db[_0x80b7('0x44')][_0x80b7('0x4c')](_0x1c6711)[_0x80b7('0x26')](handleEntityNotFound(_0x39cd2c,null))[_0x80b7('0x26')](respondWithResult(_0x39cd2c,null))[_0x80b7('0x48')](handleError(_0x39cd2c,null));};exports[_0x80b7('0x4d')]=function(_0x557988,_0x4a6cb5){return db['SmsQueue'][_0x80b7('0x4d')](_0x557988[_0x80b7('0x4e')],{})[_0x80b7('0x26')](function(_0x2d9168){var _0x1fff8c=_0x557988[_0x80b7('0x4f')]['get']({'plain':!![]});if(!_0x1fff8c)throw new Error(_0x80b7('0x50'));if(_0x1fff8c[_0x80b7('0x51')]==='user'){var _0x12dc7b=_0x2d9168[_0x80b7('0x28')]({'plain':!![]});var _0xc5e5a4='SmsQueues';return db['UserProfileSection'][_0x80b7('0x4c')]({'where':{'name':_0xc5e5a4,'userProfileId':_0x1fff8c[_0x80b7('0x52')]},'raw':!![]})[_0x80b7('0x26')](function(_0x416631){if(_0x416631&&_0x416631[_0x80b7('0x53')]===0x0){return db[_0x80b7('0x2a')]['create']({'name':_0x12dc7b[_0x80b7('0x2d')],'resourceId':_0x12dc7b['id'],'type':_0x416631[_0x80b7('0x2d')],'sectionId':_0x416631['id']},{})[_0x80b7('0x26')](function(){return _0x2d9168;});}else{return _0x2d9168;}})[_0x80b7('0x48')](function(_0x2eb688){logger['error']('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x2eb688);throw _0x2eb688;});}return _0x2d9168;})[_0x80b7('0x26')](respondWithResult(_0x4a6cb5,0xc9))[_0x80b7('0x48')](handleError(_0x4a6cb5,null));};exports[_0x80b7('0x25')]=function(_0x53f816,_0x715222){if(_0x53f816['body']['id']){delete _0x53f816[_0x80b7('0x4e')]['id'];}return db[_0x80b7('0x44')][_0x80b7('0x4c')]({'where':{'id':_0x53f816[_0x80b7('0x4a')]['id']}})[_0x80b7('0x26')](handleEntityNotFound(_0x715222,null))[_0x80b7('0x26')](saveUpdates(_0x53f816[_0x80b7('0x4e')],null))[_0x80b7('0x26')](respondWithResult(_0x715222,null))[_0x80b7('0x48')](handleError(_0x715222,null));};exports[_0x80b7('0x27')]=function(_0x1c408c,_0x461998){return db[_0x80b7('0x44')][_0x80b7('0x4c')]({'where':{'id':_0x1c408c['params']['id']}})[_0x80b7('0x26')](handleEntityNotFound(_0x461998,null))[_0x80b7('0x26')](removeEntity(_0x461998,null))[_0x80b7('0x48')](handleError(_0x461998,null));};exports[_0x80b7('0x54')]=function(_0x2bc40a,_0x1c009a){return db[_0x80b7('0x44')]['describe']()[_0x80b7('0x26')](respondWithResult(_0x1c009a,null))[_0x80b7('0x48')](handleError(_0x1c009a,null));};exports[_0x80b7('0x55')]=function(_0x251b87,_0x48c39f,_0x3dff62){var _0x3d7769={'raw':!![],'where':{}},_0x4c041b={},_0x275509;return db[_0x80b7('0x44')]['findOne']({'where':{'id':_0x251b87[_0x80b7('0x4a')]['id']}})[_0x80b7('0x26')](handleEntityNotFound(_0x48c39f,null))['then'](function(_0x4fe677){if(_0x4fe677){_0x275509=_0x4fe677[_0x80b7('0x28')]({'plain':!![]});_0x4c041b['model']=_[_0x80b7('0x36')](db[_0x80b7('0x56')]['rawAttributes']);_0x4c041b[_0x80b7('0x35')]=_[_0x80b7('0x36')](_0x251b87['query']);_0x4c041b[_0x80b7('0x37')]=_[_0x80b7('0x38')](_0x4c041b[_0x80b7('0x34')],_0x4c041b[_0x80b7('0x35')]);_0x3d7769[_0x80b7('0x3a')]=_[_0x80b7('0x38')](_0x4c041b[_0x80b7('0x34')],qs[_0x80b7('0x39')](_0x251b87[_0x80b7('0x35')]['fields']));_0x3d7769['attributes']=_0x3d7769[_0x80b7('0x3a')]['length']?_0x3d7769[_0x80b7('0x3a')]:_0x4c041b[_0x80b7('0x34')];if(!_0x251b87[_0x80b7('0x35')]['hasOwnProperty'](_0x80b7('0x3d'))){_0x3d7769[_0x80b7('0x21')]=qs['limit'](_0x251b87[_0x80b7('0x35')][_0x80b7('0x21')]);_0x3d7769[_0x80b7('0x20')]=qs[_0x80b7('0x20')](_0x251b87['query']['offset']);}_0x3d7769[_0x80b7('0x3e')]=qs[_0x80b7('0x3f')](_0x251b87[_0x80b7('0x35')]['sort']);_0x3d7769['where']=qs[_0x80b7('0x37')](_[_0x80b7('0x41')](_0x251b87[_0x80b7('0x35')],_0x4c041b['filters']));_0x3d7769[_0x80b7('0x40')][_0x80b7('0x57')]=_0x4fe677['id'];if(_0x251b87[_0x80b7('0x35')][_0x80b7('0x58')]){_0x3d7769['where']=_['merge'](_0x3d7769[_0x80b7('0x40')],{'$or':_[_0x80b7('0x30')](_0x3d7769['attributes'],function(_0x5cf1df){var _0x50a69b={};_0x50a69b[_0x5cf1df]={'$like':'%'+_0x251b87['query'][_0x80b7('0x58')]+'%'};return _0x50a69b;})});}_0x3d7769=_['merge']({},_0x3d7769,_0x251b87['options']);return db[_0x80b7('0x56')][_0x80b7('0x59')](_0x3d7769);}})[_0x80b7('0x26')](function(_0x1fe9e6){if(_0x1fe9e6){return db[_0x80b7('0x5a')][_0x80b7('0x5b')]({'where':{'id':_[_0x80b7('0x30')](_0x1fe9e6,_0x80b7('0x5c')),'role':_0x80b7('0x5d')},'attributes':['id','name','smsPause','updatedAt',_0x80b7('0x5e')]});}})[_0x80b7('0x26')](function(_0x1a2c0b){if(_0x1a2c0b){return{'count':_0x1a2c0b[_0x80b7('0x45')],'rows':_['map'](_0x1a2c0b[_0x80b7('0x47')],function(_0x1c3ad6){return{'membername':_0x1c3ad6['name'],'UserId':_0x1c3ad6['id'],'queue_name':_0x275509['name'],'SmsQueueId':_0x275509['id'],'interface':util['format'](_0x80b7('0x5f'),_0x80b7('0x60'),_0x1c3ad6['name']),'penalty':0x0,'paused':_0x1c3ad6[_0x80b7('0x61')],'createdAt':_0x1c3ad6['createdAt'],'updatedAt':_0x1c3ad6['updatedAt']};})};}else{return{'count':0x0,'rows':[]};}})['then'](respondWithFilteredResult(_0x48c39f,_0x3d7769))['catch'](handleError(_0x48c39f,null));};exports['getTeams']=function(_0x4b5e01,_0x5e8526,_0x3c1e8e){var _0x5abf9c={};var _0x3d0469={};var _0x57b55e;var _0x2fd411;return db[_0x80b7('0x44')][_0x80b7('0x62')]({'where':{'id':_0x4b5e01['params']['id']}})[_0x80b7('0x26')](handleEntityNotFound(_0x5e8526,null))[_0x80b7('0x26')](function(_0x482cfc){if(_0x482cfc){_0x57b55e=_0x482cfc;_0x3d0469[_0x80b7('0x34')]=_[_0x80b7('0x36')](db['Team'][_0x80b7('0x4b')]);_0x3d0469[_0x80b7('0x35')]=_[_0x80b7('0x36')](_0x4b5e01['query']);_0x3d0469[_0x80b7('0x37')]=_['intersection'](_0x3d0469['model'],_0x3d0469['query']);_0x5abf9c[_0x80b7('0x3a')]=_['intersection'](_0x3d0469['model'],qs[_0x80b7('0x39')](_0x4b5e01[_0x80b7('0x35')][_0x80b7('0x39')]));_0x5abf9c[_0x80b7('0x3a')]=_0x5abf9c[_0x80b7('0x3a')][_0x80b7('0x3b')]?_0x5abf9c[_0x80b7('0x3a')]:_0x3d0469[_0x80b7('0x34')];_0x5abf9c[_0x80b7('0x3e')]=qs[_0x80b7('0x3f')](_0x4b5e01[_0x80b7('0x35')][_0x80b7('0x3f')]);_0x5abf9c['where']=qs[_0x80b7('0x37')](_[_0x80b7('0x41')](_0x4b5e01[_0x80b7('0x35')],_0x3d0469['filters']));if(_0x4b5e01[_0x80b7('0x35')][_0x80b7('0x58')]){_0x5abf9c[_0x80b7('0x40')]=_[_0x80b7('0x42')](_0x5abf9c[_0x80b7('0x40')],{'$or':_[_0x80b7('0x30')](_0x5abf9c[_0x80b7('0x3a')],function(_0x34aa0f){var _0x53ebf4={};_0x53ebf4[_0x34aa0f]={'$like':'%'+_0x4b5e01[_0x80b7('0x35')][_0x80b7('0x58')]+'%'};return _0x53ebf4;})});}_0x5abf9c=_[_0x80b7('0x42')]({},_0x5abf9c,_0x4b5e01['options']);return _0x57b55e['getTeams'](_0x5abf9c);}})[_0x80b7('0x26')](function(_0x3fbcca){if(_0x3fbcca){_0x2fd411=_0x3fbcca[_0x80b7('0x3b')];if(!_0x4b5e01[_0x80b7('0x35')]['hasOwnProperty'](_0x80b7('0x3d'))){_0x5abf9c[_0x80b7('0x21')]=qs[_0x80b7('0x21')](_0x4b5e01[_0x80b7('0x35')]['limit']);_0x5abf9c[_0x80b7('0x20')]=qs[_0x80b7('0x20')](_0x4b5e01[_0x80b7('0x35')]['offset']);}return _0x57b55e[_0x80b7('0x63')](_0x5abf9c);}})[_0x80b7('0x26')](function(_0x9e3235){if(_0x9e3235){return _0x9e3235?{'count':_0x2fd411,'rows':_0x9e3235}:null;}})[_0x80b7('0x26')](respondWithResult(_0x5e8526,null))[_0x80b7('0x48')](handleError(_0x5e8526,null));};exports[_0x80b7('0x64')]=function(_0x4938db,_0x1a13e2,_0x13524c){var _0x29aade=_0x4938db['body'][_0x80b7('0x65')];return db[_0x80b7('0x66')][_0x80b7('0x59')]({'where':{'id':_0x29aade},'attributes':['id'],'include':[{'model':db[_0x80b7('0x5a')],'as':_0x80b7('0x67'),'attributes':['id','name',_0x80b7('0x68'),_0x80b7('0x69'),'interface'],'raw':!![]}]})[_0x80b7('0x26')](function(_0x5440e4){if(_0x5440e4){var _0x2fc6e8=_['flatMap'](_0x5440e4,function(_0x3008d2){var _0x2d09a3=_0x3008d2['get']({'plain':!![]});return _0x2d09a3[_0x80b7('0x67')];});return db[_0x80b7('0x44')][_0x80b7('0x4c')]({'where':{'id':_0x4938db[_0x80b7('0x4a')]['id']}})[_0x80b7('0x26')](function(_0x4f4af7){return db['sequelize']['transaction'](function(_0x13bb33){return _0x4f4af7[_0x80b7('0x64')](_0x29aade,{'transaction':_0x13bb33})['then'](function(){return BPromise['each'](_0x2fc6e8,function(_0x186d10){return db[_0x80b7('0x56')][_0x80b7('0x6a')]({'where':{'UserId':_0x186d10['id'],'SmsQueueId':_0x4938db[_0x80b7('0x4a')]['id']},'transaction':_0x13bb33});});})[_0x80b7('0x26')](function(){_0x2fc6e8[_0x80b7('0x6b')](function(_0x3216f9){socket['emit'](_0x80b7('0x6c'),{'UserId':_0x3216f9['id'],'SmsQueueId':_0x4f4af7['id']});});});});});}})[_0x80b7('0x26')](respondWithStatusCode(_0x1a13e2,null))[_0x80b7('0x48')](handleError(_0x1a13e2,null));};exports[_0x80b7('0x6d')]=function(_0x1af846,_0x75a296,_0x200ec7){return db[_0x80b7('0x66')][_0x80b7('0x59')]({'where':{'id':_0x1af846['query'][_0x80b7('0x65')]},'attributes':['id'],'include':[{'model':db[_0x80b7('0x5a')],'as':_0x80b7('0x67'),'attributes':['id'],'raw':!![]}]})[_0x80b7('0x26')](handleEntityNotFound(_0x75a296,null))['then'](function(_0x100942){var _0x30603d=_['map'](_0x100942,'id');var _0x1e75ea=[];var _0x632a70=[];var _0x1713e7=squel[_0x80b7('0x6e')]();_0x1713e7['field'](_0x80b7('0x6f'))[_0x80b7('0x70')](_0x80b7('0x71'),'tq')[_0x80b7('0x72')]('user_has_teams','ut',_0x80b7('0x73'))['where'](_0x80b7('0x74'),_0x1af846[_0x80b7('0x4a')]['id']);for(var _0x4a1553=0x0;_0x4a1553<_0x100942[_0x80b7('0x3b')];_0x4a1553+=0x1){let _0xdd5780=_0x100942[_0x4a1553];for(var _0x5c6423=0x0;_0x5c6423<_0xdd5780[_0x80b7('0x67')][_0x80b7('0x3b')];_0x5c6423+=0x1){let _0x5ae94d=_0xdd5780[_0x80b7('0x67')][_0x5c6423];var _0x18315f=_0x1713e7[_0x80b7('0x75')]();_0x18315f['where'](_0x80b7('0x76'),_0x5ae94d['id']);_0x632a70[_0x80b7('0x77')](db[_0x80b7('0x78')][_0x80b7('0x35')](_0x18315f[_0x80b7('0x79')](),{'type':db[_0x80b7('0x78')][_0x80b7('0x7a')][_0x80b7('0x7b')]})[_0x80b7('0x26')](function(_0xbcbf4f){if(_0xbcbf4f['length']===0x1){return _0x5ae94d['id'];}else{var _0x5e5ca2=_[_0x80b7('0x7c')](_[_0x80b7('0x30')](_0xbcbf4f,_0x80b7('0x7d')),function(_0x46e0ff){return _[_0x80b7('0x7e')](_0x30603d,_0x46e0ff);});if(_0x5e5ca2){return _0x5ae94d['id'];}}}));}}return BPromise['all'](_0x632a70)[_0x80b7('0x26')](function(_0xdd0abc){_0x1e75ea=_(_0x1e75ea)[_0x80b7('0x7f')](_0xdd0abc)[_0x80b7('0x80')]()['value']();return db['SmsQueue']['find']({'where':{'id':_0x1af846[_0x80b7('0x4a')]['id']}})['then'](function(_0x5ba717){return db[_0x80b7('0x78')][_0x80b7('0x81')](function(_0x37d6c5){return _0x5ba717[_0x80b7('0x6d')](_0x1af846[_0x80b7('0x35')]['ids'],{'transaction':_0x37d6c5})[_0x80b7('0x26')](function(){if(!_[_0x80b7('0x82')](_0x1e75ea)){return _0x5ba717[_0x80b7('0x83')](_0x1e75ea,{'transaction':_0x37d6c5});}})[_0x80b7('0x26')](function(){_0x1e75ea[_0x80b7('0x6b')](function(_0x33d1fb){socket['emit'](_0x80b7('0x84'),{'UserId':_0x33d1fb,'SmsQueueId':_0x5ba717['id']});});});});});});})[_0x80b7('0x26')](respondWithStatusCode(_0x75a296,null))[_0x80b7('0x48')](handleError(_0x75a296,null));};exports[_0x80b7('0x85')]=function(_0x2e853a,_0x4c5e16,_0xd90591){return db[_0x80b7('0x44')]['find']({'where':{'id':_0x2e853a[_0x80b7('0x4a')]['id']}})[_0x80b7('0x26')](handleEntityNotFound(_0x4c5e16,null))['then'](function(_0x4050b1){if(_0x4050b1){return _0x4050b1[_0x80b7('0x85')](_0x2e853a[_0x80b7('0x4e')][_0x80b7('0x65')],_[_0x80b7('0x86')](_0x2e853a[_0x80b7('0x4e')],['ids','id'])||{})['spread'](function(_0x1f2349){for(var _0x4aeeb8=0x0;_0x4aeeb8<_0x2e853a[_0x80b7('0x4e')][_0x80b7('0x65')][_0x80b7('0x3b')];_0x4aeeb8+=0x1){socket['emit'](_0x80b7('0x6c'),{'UserId':_0x2e853a[_0x80b7('0x4e')][_0x80b7('0x65')][_0x4aeeb8],'SmsQueueId':_0x2e853a[_0x80b7('0x4a')]['id']});}return _0x1f2349;});}})[_0x80b7('0x26')](respondWithResult(_0x4c5e16,null))[_0x80b7('0x48')](handleError(_0x4c5e16,null));};exports[_0x80b7('0x83')]=function(_0x4b4a8a,_0x3900cc,_0x1f9057){return db[_0x80b7('0x44')]['find']({'where':{'id':_0x4b4a8a[_0x80b7('0x4a')]['id']}})['then'](handleEntityNotFound(_0x3900cc,null))[_0x80b7('0x26')](function(_0x498238){if(_0x498238){return _0x498238['removeAgents'](_0x4b4a8a[_0x80b7('0x35')][_0x80b7('0x65')])[_0x80b7('0x26')](function(){if(_[_0x80b7('0x87')](_0x4b4a8a[_0x80b7('0x35')][_0x80b7('0x65')])){for(var _0x4a184a=0x0;_0x4a184a<_0x4b4a8a[_0x80b7('0x35')][_0x80b7('0x65')][_0x80b7('0x3b')];_0x4a184a+=0x1){socket[_0x80b7('0x88')]('userSmsQueue:remove',{'UserId':Number(_0x4b4a8a[_0x80b7('0x35')][_0x80b7('0x65')][_0x4a184a]),'SmsQueueId':Number(_0x4b4a8a[_0x80b7('0x4a')]['id'])});}}else{socket[_0x80b7('0x88')]('userSmsQueue:remove',{'UserId':Number(_0x4b4a8a[_0x80b7('0x35')][_0x80b7('0x65')]),'SmsQueueId':Number(_0x4b4a8a[_0x80b7('0x4a')]['id'])});}});}})[_0x80b7('0x26')](respondWithStatusCode(_0x3900cc,null))['catch'](handleError(_0x3900cc,null));};exports[_0x80b7('0x89')]=function(_0x49d0cb,_0xc852f5,_0x1d94de){var _0x26ac35={};var _0x5cfafd={};var _0x23540c;var _0x54bdc3;return db['SmsQueue'][_0x80b7('0x62')]({'where':{'id':_0x49d0cb[_0x80b7('0x4a')]['id']}})['then'](handleEntityNotFound(_0xc852f5,null))[_0x80b7('0x26')](function(_0x1ba6a0){if(_0x1ba6a0){_0x23540c=_0x1ba6a0;_0x5cfafd['model']=_[_0x80b7('0x36')](db[_0x80b7('0x5a')][_0x80b7('0x4b')]);_0x5cfafd[_0x80b7('0x35')]=_[_0x80b7('0x36')](_0x49d0cb[_0x80b7('0x35')]);_0x5cfafd[_0x80b7('0x37')]=_[_0x80b7('0x38')](_0x5cfafd[_0x80b7('0x34')],_0x5cfafd['query']);_0x26ac35[_0x80b7('0x3a')]=_[_0x80b7('0x38')](_0x5cfafd['model'],qs[_0x80b7('0x39')](_0x49d0cb[_0x80b7('0x35')][_0x80b7('0x39')]));_0x26ac35[_0x80b7('0x3a')]=_0x26ac35[_0x80b7('0x3a')][_0x80b7('0x3b')]?_0x26ac35[_0x80b7('0x3a')]:_0x5cfafd[_0x80b7('0x34')];_0x26ac35[_0x80b7('0x3e')]=qs['sort'](_0x49d0cb[_0x80b7('0x35')][_0x80b7('0x3f')]);_0x26ac35[_0x80b7('0x40')]=qs[_0x80b7('0x37')](_[_0x80b7('0x41')](_0x49d0cb['query'],_0x5cfafd[_0x80b7('0x37')]));if(_0x49d0cb[_0x80b7('0x35')]['filter']){_0x26ac35[_0x80b7('0x40')]=_['merge'](_0x26ac35['where'],{'$or':_[_0x80b7('0x30')](_0x26ac35[_0x80b7('0x3a')],function(_0x3a7dbf){var _0x1293ce={};_0x1293ce[_0x3a7dbf]={'$like':'%'+_0x49d0cb['query'][_0x80b7('0x58')]+'%'};return _0x1293ce;})});}_0x26ac35=_[_0x80b7('0x42')]({},_0x26ac35,_0x49d0cb[_0x80b7('0x43')]);return _0x23540c[_0x80b7('0x89')](_0x26ac35);}})['then'](function(_0x1c65bb){if(_0x1c65bb){_0x54bdc3=_0x1c65bb['length'];if(!_0x49d0cb[_0x80b7('0x35')]['hasOwnProperty'](_0x80b7('0x3d'))){_0x26ac35[_0x80b7('0x21')]=qs[_0x80b7('0x21')](_0x49d0cb[_0x80b7('0x35')][_0x80b7('0x21')]);_0x26ac35[_0x80b7('0x20')]=qs[_0x80b7('0x20')](_0x49d0cb[_0x80b7('0x35')][_0x80b7('0x20')]);}return _0x23540c[_0x80b7('0x89')](_0x26ac35);}})[_0x80b7('0x26')](function(_0x1bc550){if(_0x1bc550){return _0x1bc550?{'count':_0x54bdc3,'rows':_0x1bc550}:null;}})[_0x80b7('0x26')](respondWithResult(_0xc852f5,null))[_0x80b7('0x48')](handleError(_0xc852f5,null));};