Built motion from commit (unavailable).|2.5.4
[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 _0x06e3=['all','union','value','isEmpty','userSmsQueue:remove','addAgents','omit','isArray','getAgents','eml-format','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','lodash','jsforce','desk.js','to-csv','querystring','papaparse','ioredis','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','redis','defaults','socket.io-emitter','./smsQueue.socket','sendStatus','status','json','count','offset','limit','set','apply','reject','save','update','then','destroy','SmsQueues','end','error','stack','name','index','rawAttributes','fieldName','type','key','query','filters','model','intersection','fields','attributes','hasOwnProperty','nolimit','order','where','pick','map','VIRTUAL','filter','merge','include','SmsQueue','findAll','show','params','keys','length','options','find','catch','create','body','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','user','UserProfileSection','userProfileId','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','describe','findOne','UserSmsQueue','sort','SmsQueueId','User','UserId','agent','createdAt','rows','format','SIP','smsPause','updatedAt','getTeams','Team','Agents','online','voicePause','interface','flatMap','sequelize','transaction','findOrCreate','emit','userSmsQueue:save','ids','select','tq.TeamId','from','team_has_sms_queues','join','ut.TeamId\x20=\x20tq.TeamId','SmsQueueId\x20=\x20?','push','every','TeamId','includes'];(function(_0x200f67,_0x31e104){var _0x481652=function(_0x243673){while(--_0x243673){_0x200f67['push'](_0x200f67['shift']());}};_0x481652(++_0x31e104);}(_0x06e3,0x8a));var _0x306e=function(_0x2a3091,_0x1157bd){_0x2a3091=_0x2a3091-0x0;var _0x4be3e5=_0x06e3[_0x2a3091];return _0x4be3e5;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x306e('0x0'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0x306e('0x1'));var rp=require(_0x306e('0x2'));var moment=require(_0x306e('0x3'));var BPromise=require(_0x306e('0x4'));var Mustache=require(_0x306e('0x5'));var util=require(_0x306e('0x6'));var path=require(_0x306e('0x7'));var sox=require(_0x306e('0x8'));var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var _=require(_0x306e('0x9'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0x306e('0xa'));var deskjs=require(_0x306e('0xb'));var toCsv=require(_0x306e('0xc'));var querystring=require(_0x306e('0xd'));var Papa=require(_0x306e('0xe'));var Redis=require(_0x306e('0xf'));var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0x306e('0x10'))(_0x306e('0x11'));var utils=require(_0x306e('0x12'));var config=require(_0x306e('0x13'));var db=require(_0x306e('0x14'))['db'];config[_0x306e('0x15')]=_[_0x306e('0x16')](config[_0x306e('0x15')],{'host':'localhost','port':0x18eb});var socket=require(_0x306e('0x17'))(new Redis(config['redis']));require(_0x306e('0x18'))['register'](socket);function respondWithStatusCode(_0x55c0f3,_0x30558e){_0x30558e=_0x30558e||0xcc;return function(_0x2cf66f){if(_0x2cf66f){return _0x55c0f3[_0x306e('0x19')](_0x30558e);}return _0x55c0f3[_0x306e('0x1a')](_0x30558e)['end']();};}function respondWithResult(_0x3af1a6,_0x48ec20){_0x48ec20=_0x48ec20||0xc8;return function(_0x7a1dc4){if(_0x7a1dc4){return _0x3af1a6[_0x306e('0x1a')](_0x48ec20)[_0x306e('0x1b')](_0x7a1dc4);}};}function respondWithFilteredResult(_0x33d147,_0x54b1e5){return function(_0x22e7b9){if(_0x22e7b9){var _0x51e8bf=_0x22e7b9[_0x306e('0x1c')],_0x1a52d8=_0x54b1e5[_0x306e('0x1d')],_0x1e03cb=_0x54b1e5[_0x306e('0x1d')]+_0x54b1e5[_0x306e('0x1e')],_0x256993;if(_0x1e03cb>=_0x51e8bf){_0x1e03cb=_0x51e8bf;_0x256993=0xc8;}else{_0x256993=0xce;}_0x33d147['status'](_0x256993);return _0x33d147[_0x306e('0x1f')]('Content-Range',_0x1a52d8+'-'+_0x1e03cb+'/'+_0x51e8bf)[_0x306e('0x1b')](_0x22e7b9);}return null;};}function patchUpdates(_0x509074){return function(_0x23a120){try{jsonpatch[_0x306e('0x20')](_0x23a120,_0x509074,!![]);}catch(_0x2b2048){return BPromise[_0x306e('0x21')](_0x2b2048);}return _0x23a120[_0x306e('0x22')]();};}function saveUpdates(_0x1f5ba7,_0xabaea0){return function(_0x9cb39c){if(_0x9cb39c){return _0x9cb39c[_0x306e('0x23')](_0x1f5ba7)[_0x306e('0x24')](function(_0x543eab){return _0x543eab;});}return null;};}function removeEntity(_0x54045e,_0x32d842){return function(_0x3d6eae){if(_0x3d6eae){return _0x3d6eae[_0x306e('0x25')]()[_0x306e('0x24')](function(){var _0x455072=_0x3d6eae['get']({'plain':!![]});var _0x6ea923=_0x306e('0x26');return db['UserProfileResource'][_0x306e('0x25')]({'where':{'type':_0x6ea923,'resourceId':_0x455072['id']}})[_0x306e('0x24')](function(){return _0x3d6eae;});})[_0x306e('0x24')](function(){_0x54045e[_0x306e('0x1a')](0xcc)[_0x306e('0x27')]();});}};}function handleEntityNotFound(_0x2e1e4e,_0x4f12c7){return function(_0x2d1a21){if(!_0x2d1a21){_0x2e1e4e[_0x306e('0x19')](0x194);}return _0x2d1a21;};}function handleError(_0x1f2ccb,_0x186341){_0x186341=_0x186341||0x1f4;return function(_0x57cc60){logger[_0x306e('0x28')](_0x57cc60[_0x306e('0x29')]);if(_0x57cc60[_0x306e('0x2a')]){delete _0x57cc60[_0x306e('0x2a')];}_0x1f2ccb[_0x306e('0x1a')](_0x186341)['send'](_0x57cc60);};}exports[_0x306e('0x2b')]=function(_0x4daa39,_0x5eab55){var _0x23ffdf={},_0x1bd969={},_0x5c0bae={'count':0x0,'rows':[]};var _0x2fdcfb=_['map'](db['SmsQueue'][_0x306e('0x2c')],function(_0x1e333b){return{'name':_0x1e333b[_0x306e('0x2d')],'type':_0x1e333b[_0x306e('0x2e')][_0x306e('0x2f')]};});_0x1bd969['model']=_['map'](_0x2fdcfb,_0x306e('0x2a'));_0x1bd969[_0x306e('0x30')]=_['keys'](_0x4daa39['query']);_0x1bd969[_0x306e('0x31')]=_['intersection'](_0x1bd969[_0x306e('0x32')],_0x1bd969['query']);_0x23ffdf['attributes']=_[_0x306e('0x33')](_0x1bd969[_0x306e('0x32')],qs[_0x306e('0x34')](_0x4daa39[_0x306e('0x30')][_0x306e('0x34')]));_0x23ffdf[_0x306e('0x35')]=_0x23ffdf[_0x306e('0x35')]['length']?_0x23ffdf[_0x306e('0x35')]:_0x1bd969[_0x306e('0x32')];if(!_0x4daa39[_0x306e('0x30')][_0x306e('0x36')](_0x306e('0x37'))){_0x23ffdf[_0x306e('0x1e')]=qs[_0x306e('0x1e')](_0x4daa39[_0x306e('0x30')][_0x306e('0x1e')]);_0x23ffdf[_0x306e('0x1d')]=qs[_0x306e('0x1d')](_0x4daa39[_0x306e('0x30')]['offset']);}_0x23ffdf[_0x306e('0x38')]=qs['sort'](_0x4daa39['query']['sort']);_0x23ffdf[_0x306e('0x39')]=qs[_0x306e('0x31')](_[_0x306e('0x3a')](_0x4daa39[_0x306e('0x30')],_0x1bd969[_0x306e('0x31')]),_0x2fdcfb);if(_0x4daa39[_0x306e('0x30')]['filter']){_0x23ffdf[_0x306e('0x39')]=_['merge'](_0x23ffdf[_0x306e('0x39')],{'$or':_[_0x306e('0x3b')](_0x2fdcfb,function(_0x2fa023){if(_0x2fa023[_0x306e('0x2e')]!==_0x306e('0x3c')){var _0x4abb5f={};_0x4abb5f[_0x2fa023[_0x306e('0x2a')]]={'$like':'%'+_0x4daa39[_0x306e('0x30')][_0x306e('0x3d')]+'%'};return _0x4abb5f;}})});}_0x23ffdf=_[_0x306e('0x3e')]({},_0x23ffdf,_0x4daa39['options']);var _0x541691={'where':_0x23ffdf['where']};return db['SmsQueue']['count'](_0x541691)['then'](function(_0x5db27f){_0x5c0bae[_0x306e('0x1c')]=_0x5db27f;if(_0x4daa39['query']['includeAll']){_0x23ffdf[_0x306e('0x3f')]=[{'all':!![]}];}return db[_0x306e('0x40')][_0x306e('0x41')](_0x23ffdf);})[_0x306e('0x24')](function(_0x3c0d16){_0x5c0bae['rows']=_0x3c0d16;return _0x5c0bae;})[_0x306e('0x24')](respondWithFilteredResult(_0x5eab55,_0x23ffdf))['catch'](handleError(_0x5eab55,null));};exports[_0x306e('0x42')]=function(_0x1b30f0,_0xd4d650){var _0x4dc6be={'raw':!![],'where':{'id':_0x1b30f0[_0x306e('0x43')]['id']}},_0x51de18={};_0x51de18[_0x306e('0x32')]=_[_0x306e('0x44')](db['SmsQueue'][_0x306e('0x2c')]);_0x51de18[_0x306e('0x30')]=_[_0x306e('0x44')](_0x1b30f0['query']);_0x51de18['filters']=_[_0x306e('0x33')](_0x51de18[_0x306e('0x32')],_0x51de18['query']);_0x4dc6be[_0x306e('0x35')]=_[_0x306e('0x33')](_0x51de18[_0x306e('0x32')],qs[_0x306e('0x34')](_0x1b30f0['query'][_0x306e('0x34')]));_0x4dc6be[_0x306e('0x35')]=_0x4dc6be[_0x306e('0x35')][_0x306e('0x45')]?_0x4dc6be[_0x306e('0x35')]:_0x51de18[_0x306e('0x32')];if(_0x1b30f0[_0x306e('0x30')]['includeAll']){_0x4dc6be['include']=[{'all':!![]}];}_0x4dc6be=_[_0x306e('0x3e')]({},_0x4dc6be,_0x1b30f0[_0x306e('0x46')]);return db[_0x306e('0x40')][_0x306e('0x47')](_0x4dc6be)[_0x306e('0x24')](handleEntityNotFound(_0xd4d650,null))['then'](respondWithResult(_0xd4d650,null))[_0x306e('0x48')](handleError(_0xd4d650,null));};exports[_0x306e('0x49')]=function(_0x5d25c0,_0x4a2d97){return db[_0x306e('0x40')]['create'](_0x5d25c0[_0x306e('0x4a')],{})[_0x306e('0x24')](function(_0x5c2f65){var _0x150842=_0x5d25c0['user'][_0x306e('0x4b')]({'plain':!![]});if(!_0x150842)throw new Error(_0x306e('0x4c'));if(_0x150842[_0x306e('0x4d')]===_0x306e('0x4e')){var _0x14ca23=_0x5c2f65[_0x306e('0x4b')]({'plain':!![]});var _0xcc2654=_0x306e('0x26');return db[_0x306e('0x4f')]['find']({'where':{'name':_0xcc2654,'userProfileId':_0x150842[_0x306e('0x50')]},'raw':!![]})[_0x306e('0x24')](function(_0x50262f){if(_0x50262f&&_0x50262f['autoAssociation']===0x0){return db['UserProfileResource']['create']({'name':_0x14ca23['name'],'resourceId':_0x14ca23['id'],'type':_0x50262f[_0x306e('0x2a')],'sectionId':_0x50262f['id']},{})[_0x306e('0x24')](function(){return _0x5c2f65;});}else{return _0x5c2f65;}})[_0x306e('0x48')](function(_0x4411a0){logger[_0x306e('0x28')](_0x306e('0x51'),_0x4411a0);throw _0x4411a0;});}return _0x5c2f65;})[_0x306e('0x24')](respondWithResult(_0x4a2d97,0xc9))['catch'](handleError(_0x4a2d97,null));};exports[_0x306e('0x23')]=function(_0x262894,_0x18e381){if(_0x262894[_0x306e('0x4a')]['id']){delete _0x262894[_0x306e('0x4a')]['id'];}return db[_0x306e('0x40')][_0x306e('0x47')]({'where':{'id':_0x262894[_0x306e('0x43')]['id']}})[_0x306e('0x24')](handleEntityNotFound(_0x18e381,null))[_0x306e('0x24')](saveUpdates(_0x262894['body'],null))[_0x306e('0x24')](respondWithResult(_0x18e381,null))[_0x306e('0x48')](handleError(_0x18e381,null));};exports[_0x306e('0x25')]=function(_0x43c077,_0x500e88){return db['SmsQueue'][_0x306e('0x47')]({'where':{'id':_0x43c077[_0x306e('0x43')]['id']}})[_0x306e('0x24')](handleEntityNotFound(_0x500e88,null))['then'](removeEntity(_0x500e88,null))[_0x306e('0x48')](handleError(_0x500e88,null));};exports['describe']=function(_0x50e121,_0x5b2a6e){return db[_0x306e('0x40')][_0x306e('0x52')]()['then'](respondWithResult(_0x5b2a6e,null))[_0x306e('0x48')](handleError(_0x5b2a6e,null));};exports['getMembers']=function(_0x57895b,_0x1b0355,_0x4d02d2){var _0x220be0={'raw':!![],'where':{}},_0x14ba1f={},_0x224e85;return db[_0x306e('0x40')][_0x306e('0x53')]({'where':{'id':_0x57895b[_0x306e('0x43')]['id']}})[_0x306e('0x24')](handleEntityNotFound(_0x1b0355,null))['then'](function(_0x443d76){if(_0x443d76){_0x224e85=_0x443d76[_0x306e('0x4b')]({'plain':!![]});_0x14ba1f[_0x306e('0x32')]=_['keys'](db[_0x306e('0x54')]['rawAttributes']);_0x14ba1f['query']=_[_0x306e('0x44')](_0x57895b[_0x306e('0x30')]);_0x14ba1f[_0x306e('0x31')]=_['intersection'](_0x14ba1f['model'],_0x14ba1f[_0x306e('0x30')]);_0x220be0[_0x306e('0x35')]=_[_0x306e('0x33')](_0x14ba1f['model'],qs[_0x306e('0x34')](_0x57895b[_0x306e('0x30')][_0x306e('0x34')]));_0x220be0[_0x306e('0x35')]=_0x220be0[_0x306e('0x35')][_0x306e('0x45')]?_0x220be0[_0x306e('0x35')]:_0x14ba1f[_0x306e('0x32')];if(!_0x57895b[_0x306e('0x30')][_0x306e('0x36')](_0x306e('0x37'))){_0x220be0[_0x306e('0x1e')]=qs[_0x306e('0x1e')](_0x57895b['query'][_0x306e('0x1e')]);_0x220be0[_0x306e('0x1d')]=qs[_0x306e('0x1d')](_0x57895b['query'][_0x306e('0x1d')]);}_0x220be0[_0x306e('0x38')]=qs['sort'](_0x57895b[_0x306e('0x30')][_0x306e('0x55')]);_0x220be0['where']=qs[_0x306e('0x31')](_[_0x306e('0x3a')](_0x57895b[_0x306e('0x30')],_0x14ba1f[_0x306e('0x31')]));_0x220be0[_0x306e('0x39')][_0x306e('0x56')]=_0x443d76['id'];if(_0x57895b[_0x306e('0x30')][_0x306e('0x3d')]){_0x220be0[_0x306e('0x39')]=_[_0x306e('0x3e')](_0x220be0[_0x306e('0x39')],{'$or':_['map'](_0x220be0[_0x306e('0x35')],function(_0x391155){var _0x4885b4={};_0x4885b4[_0x391155]={'$like':'%'+_0x57895b[_0x306e('0x30')][_0x306e('0x3d')]+'%'};return _0x4885b4;})});}_0x220be0=_[_0x306e('0x3e')]({},_0x220be0,_0x57895b[_0x306e('0x46')]);return db['UserSmsQueue'][_0x306e('0x41')](_0x220be0);}})[_0x306e('0x24')](function(_0x3624d7){if(_0x3624d7){return db[_0x306e('0x57')]['findAndCountAll']({'where':{'id':_['map'](_0x3624d7,_0x306e('0x58')),'role':_0x306e('0x59')},'attributes':['id','name','smsPause','updatedAt',_0x306e('0x5a')]});}})['then'](function(_0xb12b67){if(_0xb12b67){return{'count':_0xb12b67[_0x306e('0x1c')],'rows':_[_0x306e('0x3b')](_0xb12b67[_0x306e('0x5b')],function(_0x16e2f7){return{'membername':_0x16e2f7[_0x306e('0x2a')],'UserId':_0x16e2f7['id'],'queue_name':_0x224e85[_0x306e('0x2a')],'SmsQueueId':_0x224e85['id'],'interface':util[_0x306e('0x5c')]('%s/%s',_0x306e('0x5d'),_0x16e2f7['name']),'penalty':0x0,'paused':_0x16e2f7[_0x306e('0x5e')],'createdAt':_0x16e2f7[_0x306e('0x5a')],'updatedAt':_0x16e2f7[_0x306e('0x5f')]};})};}else{return{'count':0x0,'rows':[]};}})[_0x306e('0x24')](respondWithFilteredResult(_0x1b0355,_0x220be0))[_0x306e('0x48')](handleError(_0x1b0355,null));};exports['getTeams']=function(_0x10dc77,_0xce75d6,_0x432c67){var _0x9162c7={};var _0x26fd25={};var _0x5beac8;var _0x452142;return db[_0x306e('0x40')][_0x306e('0x53')]({'where':{'id':_0x10dc77[_0x306e('0x43')]['id']}})[_0x306e('0x24')](handleEntityNotFound(_0xce75d6,null))[_0x306e('0x24')](function(_0x3eda68){if(_0x3eda68){_0x5beac8=_0x3eda68;_0x26fd25['model']=_[_0x306e('0x44')](db['Team'][_0x306e('0x2c')]);_0x26fd25[_0x306e('0x30')]=_[_0x306e('0x44')](_0x10dc77[_0x306e('0x30')]);_0x26fd25[_0x306e('0x31')]=_[_0x306e('0x33')](_0x26fd25[_0x306e('0x32')],_0x26fd25['query']);_0x9162c7[_0x306e('0x35')]=_['intersection'](_0x26fd25['model'],qs[_0x306e('0x34')](_0x10dc77[_0x306e('0x30')][_0x306e('0x34')]));_0x9162c7['attributes']=_0x9162c7[_0x306e('0x35')][_0x306e('0x45')]?_0x9162c7[_0x306e('0x35')]:_0x26fd25[_0x306e('0x32')];_0x9162c7[_0x306e('0x38')]=qs[_0x306e('0x55')](_0x10dc77[_0x306e('0x30')][_0x306e('0x55')]);_0x9162c7[_0x306e('0x39')]=qs['filters'](_[_0x306e('0x3a')](_0x10dc77[_0x306e('0x30')],_0x26fd25[_0x306e('0x31')]));if(_0x10dc77[_0x306e('0x30')][_0x306e('0x3d')]){_0x9162c7[_0x306e('0x39')]=_[_0x306e('0x3e')](_0x9162c7[_0x306e('0x39')],{'$or':_[_0x306e('0x3b')](_0x9162c7['attributes'],function(_0x1812e6){var _0x364aee={};_0x364aee[_0x1812e6]={'$like':'%'+_0x10dc77[_0x306e('0x30')][_0x306e('0x3d')]+'%'};return _0x364aee;})});}_0x9162c7=_[_0x306e('0x3e')]({},_0x9162c7,_0x10dc77[_0x306e('0x46')]);return _0x5beac8[_0x306e('0x60')](_0x9162c7);}})[_0x306e('0x24')](function(_0x22ad0e){if(_0x22ad0e){_0x452142=_0x22ad0e[_0x306e('0x45')];if(!_0x10dc77[_0x306e('0x30')][_0x306e('0x36')](_0x306e('0x37'))){_0x9162c7[_0x306e('0x1e')]=qs[_0x306e('0x1e')](_0x10dc77[_0x306e('0x30')][_0x306e('0x1e')]);_0x9162c7['offset']=qs[_0x306e('0x1d')](_0x10dc77[_0x306e('0x30')][_0x306e('0x1d')]);}return _0x5beac8[_0x306e('0x60')](_0x9162c7);}})[_0x306e('0x24')](function(_0x303479){if(_0x303479){return _0x303479?{'count':_0x452142,'rows':_0x303479}:null;}})[_0x306e('0x24')](respondWithResult(_0xce75d6,null))[_0x306e('0x48')](handleError(_0xce75d6,null));};exports['addTeams']=function(_0x2452d0,_0x207271,_0x4e9995){var _0x14f21f=_0x2452d0['body']['ids'];return db[_0x306e('0x61')]['findAll']({'where':{'id':_0x14f21f},'attributes':['id'],'include':[{'model':db['User'],'as':_0x306e('0x62'),'attributes':['id',_0x306e('0x2a'),_0x306e('0x63'),_0x306e('0x64'),_0x306e('0x65')],'raw':!![]}]})[_0x306e('0x24')](function(_0x4b3519){if(_0x4b3519){var _0x41e040=_[_0x306e('0x66')](_0x4b3519,function(_0x4366d7){var _0xcd80ee=_0x4366d7[_0x306e('0x4b')]({'plain':!![]});return _0xcd80ee[_0x306e('0x62')];});return db[_0x306e('0x40')][_0x306e('0x47')]({'where':{'id':_0x2452d0['params']['id']}})[_0x306e('0x24')](function(_0x1ae347){return db[_0x306e('0x67')][_0x306e('0x68')](function(_0xa04b45){return _0x1ae347['addTeams'](_0x14f21f,{'transaction':_0xa04b45})['then'](function(){return BPromise['each'](_0x41e040,function(_0x5b2e8e){return db[_0x306e('0x54')][_0x306e('0x69')]({'where':{'UserId':_0x5b2e8e['id'],'SmsQueueId':_0x2452d0[_0x306e('0x43')]['id']},'transaction':_0xa04b45});});})['then'](function(){_0x41e040['forEach'](function(_0x14a8bf){socket[_0x306e('0x6a')](_0x306e('0x6b'),{'UserId':_0x14a8bf['id'],'SmsQueueId':_0x1ae347['id']});});});});});}})[_0x306e('0x24')](respondWithStatusCode(_0x207271,null))[_0x306e('0x48')](handleError(_0x207271,null));};exports['removeTeams']=function(_0x162eca,_0x379fd3,_0x7da7e0){return db[_0x306e('0x61')][_0x306e('0x41')]({'where':{'id':_0x162eca[_0x306e('0x30')][_0x306e('0x6c')]},'attributes':['id'],'include':[{'model':db['User'],'as':_0x306e('0x62'),'attributes':['id'],'raw':!![]}]})[_0x306e('0x24')](handleEntityNotFound(_0x379fd3,null))[_0x306e('0x24')](function(_0x22671a){var _0xc3fa3e=_[_0x306e('0x3b')](_0x22671a,'id');var _0x222763=[];var _0x297c7b=[];var _0x33ad17=squel[_0x306e('0x6d')]();_0x33ad17['field'](_0x306e('0x6e'))[_0x306e('0x6f')](_0x306e('0x70'),'tq')[_0x306e('0x71')]('user_has_teams','ut',_0x306e('0x72'))[_0x306e('0x39')](_0x306e('0x73'),_0x162eca[_0x306e('0x43')]['id']);for(var _0x4bb074=0x0;_0x4bb074<_0x22671a['length'];_0x4bb074+=0x1){let _0x4e6fd3=_0x22671a[_0x4bb074];for(var _0x80a172=0x0;_0x80a172<_0x4e6fd3[_0x306e('0x62')][_0x306e('0x45')];_0x80a172+=0x1){let _0x1d5ade=_0x4e6fd3[_0x306e('0x62')][_0x80a172];var _0x4e0e98=_0x33ad17['clone']();_0x4e0e98['where']('ut.UserId\x20=\x20?',_0x1d5ade['id']);_0x297c7b[_0x306e('0x74')](db[_0x306e('0x67')][_0x306e('0x30')](_0x4e0e98['toString'](),{'type':db[_0x306e('0x67')]['QueryTypes']['SELECT']})[_0x306e('0x24')](function(_0x2ffedb){if(_0x2ffedb['length']===0x1){return _0x1d5ade['id'];}else{var _0x53eff1=_[_0x306e('0x75')](_['map'](_0x2ffedb,_0x306e('0x76')),function(_0x16f58a){return _[_0x306e('0x77')](_0xc3fa3e,_0x16f58a);});if(_0x53eff1){return _0x1d5ade['id'];}}}));}}return BPromise[_0x306e('0x78')](_0x297c7b)['then'](function(_0x3834ec){_0x222763=_(_0x222763)[_0x306e('0x79')](_0x3834ec)['compact']()[_0x306e('0x7a')]();return db[_0x306e('0x40')][_0x306e('0x47')]({'where':{'id':_0x162eca[_0x306e('0x43')]['id']}})[_0x306e('0x24')](function(_0x350e70){return db['sequelize'][_0x306e('0x68')](function(_0x4befc0){return _0x350e70['removeTeams'](_0x162eca[_0x306e('0x30')][_0x306e('0x6c')],{'transaction':_0x4befc0})[_0x306e('0x24')](function(){if(!_[_0x306e('0x7b')](_0x222763)){return _0x350e70['removeAgents'](_0x222763,{'transaction':_0x4befc0});}})[_0x306e('0x24')](function(){_0x222763['forEach'](function(_0x1821b1){socket[_0x306e('0x6a')](_0x306e('0x7c'),{'UserId':_0x1821b1,'SmsQueueId':_0x350e70['id']});});});});});});})[_0x306e('0x24')](respondWithStatusCode(_0x379fd3,null))[_0x306e('0x48')](handleError(_0x379fd3,null));};exports[_0x306e('0x7d')]=function(_0x7b7fd5,_0xe9bc7b,_0x41597c){return db[_0x306e('0x40')][_0x306e('0x47')]({'where':{'id':_0x7b7fd5[_0x306e('0x43')]['id']}})[_0x306e('0x24')](handleEntityNotFound(_0xe9bc7b,null))[_0x306e('0x24')](function(_0x887f26){if(_0x887f26){return _0x887f26[_0x306e('0x7d')](_0x7b7fd5[_0x306e('0x4a')][_0x306e('0x6c')],_[_0x306e('0x7e')](_0x7b7fd5['body'],[_0x306e('0x6c'),'id'])||{})['spread'](function(_0x5c9971){for(var _0x474312=0x0;_0x474312<_0x7b7fd5[_0x306e('0x4a')][_0x306e('0x6c')][_0x306e('0x45')];_0x474312+=0x1){socket[_0x306e('0x6a')](_0x306e('0x6b'),{'UserId':_0x7b7fd5[_0x306e('0x4a')][_0x306e('0x6c')][_0x474312],'SmsQueueId':_0x7b7fd5['params']['id']});}return _0x5c9971;});}})[_0x306e('0x24')](respondWithResult(_0xe9bc7b,null))[_0x306e('0x48')](handleError(_0xe9bc7b,null));};exports['removeAgents']=function(_0x22af44,_0x15f5dd,_0x40fd18){return db[_0x306e('0x40')][_0x306e('0x47')]({'where':{'id':_0x22af44[_0x306e('0x43')]['id']}})['then'](handleEntityNotFound(_0x15f5dd,null))[_0x306e('0x24')](function(_0x31e318){if(_0x31e318){return _0x31e318['removeAgents'](_0x22af44['query'][_0x306e('0x6c')])['then'](function(){if(_[_0x306e('0x7f')](_0x22af44[_0x306e('0x30')][_0x306e('0x6c')])){for(var _0x298c1e=0x0;_0x298c1e<_0x22af44[_0x306e('0x30')][_0x306e('0x6c')][_0x306e('0x45')];_0x298c1e+=0x1){socket[_0x306e('0x6a')](_0x306e('0x7c'),{'UserId':Number(_0x22af44[_0x306e('0x30')]['ids'][_0x298c1e]),'SmsQueueId':Number(_0x22af44[_0x306e('0x43')]['id'])});}}else{socket[_0x306e('0x6a')]('userSmsQueue:remove',{'UserId':Number(_0x22af44[_0x306e('0x30')][_0x306e('0x6c')]),'SmsQueueId':Number(_0x22af44['params']['id'])});}});}})['then'](respondWithStatusCode(_0x15f5dd,null))[_0x306e('0x48')](handleError(_0x15f5dd,null));};exports[_0x306e('0x80')]=function(_0x14d8cf,_0x166b9e,_0x51fc6b){var _0x7b788a={};var _0x283d39={};var _0x5954bc;var _0xc81276;return db[_0x306e('0x40')][_0x306e('0x53')]({'where':{'id':_0x14d8cf[_0x306e('0x43')]['id']}})[_0x306e('0x24')](handleEntityNotFound(_0x166b9e,null))[_0x306e('0x24')](function(_0x28e42f){if(_0x28e42f){_0x5954bc=_0x28e42f;_0x283d39['model']=_[_0x306e('0x44')](db['User'][_0x306e('0x2c')]);_0x283d39['query']=_[_0x306e('0x44')](_0x14d8cf[_0x306e('0x30')]);_0x283d39[_0x306e('0x31')]=_['intersection'](_0x283d39[_0x306e('0x32')],_0x283d39[_0x306e('0x30')]);_0x7b788a[_0x306e('0x35')]=_['intersection'](_0x283d39['model'],qs[_0x306e('0x34')](_0x14d8cf[_0x306e('0x30')]['fields']));_0x7b788a['attributes']=_0x7b788a[_0x306e('0x35')][_0x306e('0x45')]?_0x7b788a[_0x306e('0x35')]:_0x283d39[_0x306e('0x32')];_0x7b788a[_0x306e('0x38')]=qs[_0x306e('0x55')](_0x14d8cf[_0x306e('0x30')][_0x306e('0x55')]);_0x7b788a['where']=qs['filters'](_[_0x306e('0x3a')](_0x14d8cf[_0x306e('0x30')],_0x283d39[_0x306e('0x31')]));if(_0x14d8cf[_0x306e('0x30')][_0x306e('0x3d')]){_0x7b788a[_0x306e('0x39')]=_['merge'](_0x7b788a[_0x306e('0x39')],{'$or':_[_0x306e('0x3b')](_0x7b788a[_0x306e('0x35')],function(_0x7f1f29){var _0x348642={};_0x348642[_0x7f1f29]={'$like':'%'+_0x14d8cf[_0x306e('0x30')][_0x306e('0x3d')]+'%'};return _0x348642;})});}_0x7b788a=_[_0x306e('0x3e')]({},_0x7b788a,_0x14d8cf[_0x306e('0x46')]);return _0x5954bc[_0x306e('0x80')](_0x7b788a);}})[_0x306e('0x24')](function(_0x1d9c21){if(_0x1d9c21){_0xc81276=_0x1d9c21[_0x306e('0x45')];if(!_0x14d8cf[_0x306e('0x30')]['hasOwnProperty'](_0x306e('0x37'))){_0x7b788a[_0x306e('0x1e')]=qs[_0x306e('0x1e')](_0x14d8cf[_0x306e('0x30')][_0x306e('0x1e')]);_0x7b788a[_0x306e('0x1d')]=qs[_0x306e('0x1d')](_0x14d8cf['query'][_0x306e('0x1d')]);}return _0x5954bc[_0x306e('0x80')](_0x7b788a);}})[_0x306e('0x24')](function(_0x1f455c){if(_0x1f455c){return _0x1f455c?{'count':_0xc81276,'rows':_0x1f455c}:null;}})[_0x306e('0x24')](respondWithResult(_0x166b9e,null))['catch'](handleError(_0x166b9e,null));};