server/api/userProfile/userProfile.model.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 _0x5613=['push','UserProfileSection','find','all','ignore','isEmpty','union','autoAssociation','rawAttributes','keys','filters','intersection','attributes','hasOwnProperty','nolimit','limit','offset','sort','pick','key','VIRTUAL','foreignKey','merge','includeAll','include','forEach','reportType','default','reportId','DefaultReports','custom','CustomReports','count','rows','ids','customSorting','order','extraQueryConditions','CmContact','color','tag','ThroughTags','true','chat','dataValues','sms','fax','mail','openchannel','whatsapp','lodash','./userProfile.attributes','exports','models','filter','field','findAll','then','map','value','model','associatedResources','name','catch','UserProfileResource','AnalyticExtractedReport','resourceId','type','childModel','SquareProject','odbc','SquareOdbc','squarerecordings','SquareRecording','parentSections','SquareProjects','projectName','projects','JscriptyProject','contacts','Lists','ListId','lists','CmList','companies','CmCustomField','chatqueues','chatwebsites','faxqueues','faxaccounts','FaxAccount','inboundroutes','VoiceExtension','contexts','VoiceContext','voicemails','voicerecordings','VoiceRecording','Agents','membername','User','role','agent','Telephones','VoiceQueues','VoiceQueue','inbound','QueueCampaigns','outbound','musiconholds','VoiceMusicOnHold','chanspies','VoiceChanSpy','voiceprefixes','VoicePrefix','mailqueues','MailQueue','MailAccount','mailsubstatuses','openchannelqueues','OpenchannelQueue','openchannelaccounts','OpenchannelAccount','smsqueues','SmsQueue','smsaccounts','SmsAccount','WhatsappQueue','whatsappaccounts','teams','Team','voicequeues','queuecampaigns','users','agents','telephones','Users','admin','zendeskaccounts','SalesforceAccount','freshdeskaccounts','FreshdeskAccount','sugarcrmaccounts','deskaccounts','DeskAccount','ZohoAccount','vtigeraccounts','cannedanswers','dispositions','Disposition','customdashboards','Dashboard','intervals','Interval','pauses','Pause','Schedule','sounds','Sound','Tag','templates','Template','triggers','Trigger','trunks','variables','Variable','plugins','Reports','metrics','AnalyticMetric','toUpperCase','slice','QueryTypes','SELECT','select','InteractionId','ui.createdAt','_interactions','where','ui.UserId\x20=\x20?','sequelize','OpenTabs','define','UserProfile','user_profiles','../../components/parsers/qs','raw','query','section','mergeResources','length'];(function(_0x12cab3,_0x5ea0b2){var _0x58b835=function(_0x489199){while(--_0x489199){_0x12cab3['push'](_0x12cab3['shift']());}};_0x58b835(++_0x5ea0b2);}(_0x5613,0xf2));var _0x3561=function(_0x39bbe7,_0x133823){_0x39bbe7=_0x39bbe7-0x0;var _0x1605ec=_0x5613[_0x39bbe7];return _0x1605ec;};'use strict';var _=require(_0x3561('0x0'));var attributes=require(_0x3561('0x1'));var squel=require('squel');module[_0x3561('0x2')]=function(_0x5e1605){var _0x399162=_0x5e1605[_0x3561('0x3')];function _0x99ffb(_0x3d4078,_0x218031){return new Promise(function(_0x3b4b48,_0x5f062e){if(!_0x218031)return _0x3b4b48(null);var _0x23f228=_0x218031[_0x3561('0x4')]?{[_0x218031[_0x3561('0x4')][_0x3561('0x5')]]:_0x218031[_0x3561('0x4')]['value']}:undefined;return _0x399162[_0x3d4078][_0x3561('0x6')]({'where':_0x23f228,'raw':!![]})[_0x3561('0x7')](function(_0x202724){_0x218031['associatedResources']=_[_0x3561('0x8')](_0x202724,'id');_0x3b4b48(_0x218031);})['catch'](function(_0x3f0a44){_0x5f062e(_0x3f0a44);});});}function _0x128b26(_0x40a519,_0x35dce7){return new Promise(function(_0x4b5324,_0x28847b){var _0x2cf2ea=_0x40a519['filter']?{[_0x40a519[_0x3561('0x4')][_0x3561('0x5')]]:_0x40a519[_0x3561('0x4')][_0x3561('0x9')]}:undefined;return _0x399162[_0x40a519[_0x3561('0xa')]]['findAll']({'where':_0x2cf2ea,'raw':!![]})[_0x3561('0x7')](function(_0x30ff08){_0x35dce7[_0x3561('0xb')]=_[_0x3561('0x8')](_0x30ff08,function(_0x4d6e78){return _0x4d6e78[_0x3561('0xc')];});_0x4b5324(_0x35dce7);})[_0x3561('0xd')](function(_0x4f53ff){_0x28847b(_0x4f53ff);});});}function _0xc96559(_0x7dbc9c,_0x3baf90,_0x528ad8){if(!_0x3baf90)return Promise['resolve'](null);return new Promise(function(_0x571cab,_0x84353b){return _0x399162[_0x3561('0xe')][_0x3561('0x6')]({'where':{'sectionId':_0x3baf90['id']},'raw':!![]})[_0x3561('0x7')](function(_0x4f6735){if(_0x7dbc9c[_0x3561('0x5')]&&_0x7dbc9c['field']!=='id'){_0x3baf90[_0x3561('0xb')]=_[_0x3561('0x8')](_0x4f6735,function(_0x4f5502){return _0x4f5502[_0x7dbc9c[_0x3561('0x5')]];});}else{if(_0x528ad8===_0x3561('0xf')){_0x3baf90[_0x3561('0xb')]=_[_0x3561('0x8')](_0x4f6735,function(_0x28c028){return{'id':_0x28c028[_0x3561('0x10')],'type':_0x28c028[_0x3561('0x11')]};});}else{_0x3baf90['associatedResources']=_[_0x3561('0x8')](_0x4f6735,function(_0x47de66){return _0x47de66['resourceId'];});}}_0x571cab(_0x3baf90);})['catch'](function(_0x4f9d5e){_0x84353b(_0x4f9d5e);});});}function _0x112ac0(_0x5eba2d,_0x4fc52d){var _0x18ad11={'parentSections':[]};switch(_0x5eba2d['toLowerCase']()){case'squareprojects':_0x18ad11[_0x3561('0x12')]=_0x3561('0x13');break;case _0x3561('0x14'):_0x18ad11[_0x3561('0x12')]=_0x3561('0x15');break;case _0x3561('0x16'):_0x18ad11[_0x3561('0x12')]=_0x3561('0x17');_0x18ad11[_0x3561('0x18')]=[{'name':_0x3561('0x19'),'field':_0x3561('0xc'),'foreignKey':_0x3561('0x1a')}];break;case _0x3561('0x1b'):_0x18ad11[_0x3561('0x12')]=_0x3561('0x1c');break;case _0x3561('0x1d'):_0x18ad11['childModel']='CmContact';_0x18ad11[_0x3561('0x18')]=[{'name':_0x3561('0x1e'),'field':'id','foreignKey':_0x3561('0x1f')}];break;case _0x3561('0x20'):_0x18ad11[_0x3561('0x12')]=_0x3561('0x21');break;case _0x3561('0x22'):_0x18ad11[_0x3561('0x12')]='CmCompany';break;case'globalcustomfields':_0x18ad11[_0x3561('0x12')]=_0x3561('0x23');break;case _0x3561('0x24'):_0x18ad11[_0x3561('0x12')]='ChatQueue';break;case _0x3561('0x25'):_0x18ad11['childModel']='ChatWebsite';break;case _0x3561('0x26'):_0x18ad11[_0x3561('0x12')]='FaxQueue';break;case _0x3561('0x27'):_0x18ad11['childModel']=_0x3561('0x28');break;case _0x3561('0x29'):case'internalroutes':case'outboundroutes':_0x18ad11[_0x3561('0x12')]=_0x3561('0x2a');break;case _0x3561('0x2b'):_0x18ad11['childModel']=_0x3561('0x2c');break;case _0x3561('0x2d'):_0x18ad11[_0x3561('0x12')]='VoiceMail';break;case _0x3561('0x2e'):_0x18ad11[_0x3561('0x12')]=_0x3561('0x2f');_0x18ad11['parentSections']=[{'name':_0x3561('0x30'),'field':'name','foreignKey':_0x3561('0x31'),'model':_0x3561('0x32'),'filter':{'field':_0x3561('0x33'),'value':[_0x3561('0x34')]}},{'name':_0x3561('0x35'),'field':_0x3561('0xc'),'foreignKey':_0x3561('0x31'),'model':_0x3561('0x32'),'filter':{'field':_0x3561('0x33'),'value':['telephone']}},{'name':_0x3561('0x36'),'field':_0x3561('0xc'),'foreignKey':'queue','model':_0x3561('0x37'),'filter':{'field':_0x3561('0x11'),'value':[_0x3561('0x38')]}},{'name':_0x3561('0x39'),'field':'name','foreignKey':'queue','model':_0x3561('0x37'),'filter':{'field':_0x3561('0x11'),'value':[_0x3561('0x3a')]}}];break;case _0x3561('0x3b'):_0x18ad11['childModel']=_0x3561('0x3c');break;case _0x3561('0x3d'):_0x18ad11[_0x3561('0x12')]=_0x3561('0x3e');break;case _0x3561('0x3f'):_0x18ad11[_0x3561('0x12')]=_0x3561('0x40');break;case'ivrcampaigns':_0x18ad11['childModel']='Campaign';break;case _0x3561('0x41'):_0x18ad11[_0x3561('0x12')]=_0x3561('0x42');break;case'mailaccounts':_0x18ad11[_0x3561('0x12')]=_0x3561('0x43');break;case _0x3561('0x44'):_0x18ad11[_0x3561('0x12')]='MailSubstatus';break;case _0x3561('0x45'):_0x18ad11['childModel']=_0x3561('0x46');break;case _0x3561('0x47'):_0x18ad11[_0x3561('0x12')]=_0x3561('0x48');break;case _0x3561('0x49'):_0x18ad11[_0x3561('0x12')]=_0x3561('0x4a');break;case _0x3561('0x4b'):_0x18ad11[_0x3561('0x12')]=_0x3561('0x4c');break;case'whatsappqueues':_0x18ad11['childModel']=_0x3561('0x4d');break;case _0x3561('0x4e'):_0x18ad11[_0x3561('0x12')]='WhatsappAccount';break;case _0x3561('0x4f'):_0x18ad11[_0x3561('0x12')]=_0x3561('0x50');break;case _0x3561('0x51'):case _0x3561('0x52'):_0x18ad11[_0x3561('0x12')]=_0x3561('0x37');if(_0x4fc52d){_0x18ad11[_0x3561('0x18')]=[{'name':_0x3561('0x36')},{'name':_0x3561('0x39')}];}break;case _0x3561('0x53'):case _0x3561('0x54'):case _0x3561('0x55'):_0x18ad11['childModel']=_0x3561('0x32');if(_0x4fc52d){_0x18ad11[_0x3561('0x18')]=[{'name':_0x3561('0x56'),'filter':{'field':_0x3561('0x33'),'value':[_0x3561('0x57'),'user']},'ignore':!![]},{'name':'Agents'},{'name':_0x3561('0x35')}];}break;case _0x3561('0x58'):_0x18ad11[_0x3561('0x12')]='ZendeskAccount';break;case'salesforceaccounts':_0x18ad11[_0x3561('0x12')]=_0x3561('0x59');break;case _0x3561('0x5a'):_0x18ad11[_0x3561('0x12')]=_0x3561('0x5b');break;case _0x3561('0x5c'):_0x18ad11[_0x3561('0x12')]='SugarcrmAccount';break;case _0x3561('0x5d'):_0x18ad11[_0x3561('0x12')]=_0x3561('0x5e');break;case'zohoaccounts':_0x18ad11[_0x3561('0x12')]=_0x3561('0x5f');break;case _0x3561('0x60'):_0x18ad11[_0x3561('0x12')]=_0x3561('0x32');break;case _0x3561('0x61'):_0x18ad11[_0x3561('0x12')]='CannedAnswer';break;case _0x3561('0x62'):_0x18ad11['childModel']=_0x3561('0x63');break;case _0x3561('0x64'):_0x18ad11[_0x3561('0x12')]=_0x3561('0x65');break;case _0x3561('0x66'):_0x18ad11['childModel']=_0x3561('0x67');break;case _0x3561('0x68'):_0x18ad11[_0x3561('0x12')]=_0x3561('0x69');break;case'scheduler':_0x18ad11[_0x3561('0x12')]=_0x3561('0x6a');break;case _0x3561('0x6b'):_0x18ad11[_0x3561('0x12')]=_0x3561('0x6c');break;case'tags':_0x18ad11['childModel']=_0x3561('0x6d');break;case _0x3561('0x6e'):_0x18ad11[_0x3561('0x12')]=_0x3561('0x6f');break;case _0x3561('0x70'):_0x18ad11[_0x3561('0x12')]=_0x3561('0x71');break;case _0x3561('0x72'):_0x18ad11[_0x3561('0x12')]='Trunk';break;case _0x3561('0x73'):_0x18ad11['childModel']=_0x3561('0x74');break;case _0x3561('0x75'):_0x18ad11[_0x3561('0x12')]='Plugin';break;case'extractedreports':_0x18ad11[_0x3561('0x12')]=_0x3561('0xf');_0x18ad11[_0x3561('0x18')]=[{'name':_0x3561('0x76'),'field':'id','foreignKey':'reportId'}];break;case _0x3561('0x77'):_0x18ad11[_0x3561('0x12')]=_0x3561('0x78');break;}return _0x18ad11;}function _0x16672b(_0x114130,_0x2c9a8e){var _0x17a06d=_0x114130['charAt'](0x0)[_0x3561('0x79')]()+_0x114130[_0x3561('0x7a')](0x1);var _0x3aa8ce={'type':_0x399162['Sequelize'][_0x3561('0x7b')][_0x3561('0x7c')],'raw':!![]};return new Promise(function(_0x3a09f3,_0x2de93b){var _0x90980d=squel[_0x3561('0x7d')]()[_0x3561('0x5')]('ui.'+_0x17a06d+_0x3561('0x7e'),'id')[_0x3561('0x5')](_0x3561('0x7f'))['from']('user_has_'+_0x114130+_0x3561('0x80'),'ui')[_0x3561('0x81')](_0x3561('0x82'),_0x2c9a8e['id']);return _0x399162[_0x3561('0x83')]['query'](_0x90980d['toString'](),_0x3aa8ce)['then'](function(_0x3e8ca2){_0x2c9a8e[_0x17a06d+_0x3561('0x84')]=_0x3e8ca2;_0x3a09f3(_0x3e8ca2);})[_0x3561('0xd')](function(_0x1b811a){_0x2de93b(_0x1b811a);});});}return _0x5e1605[_0x3561('0x85')](_0x3561('0x86'),attributes,{'tableName':_0x3561('0x87'),'paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x57d02b){var _0x2e7f0c=require(_0x3561('0x88'));var _0x165a02={'raw':_0x57d02b['query'][_0x3561('0x89')],'where':{}};var _0x308eb8={};var _0x63073b={'count':0x0,'rows':[]};var _0x1d4151=_0x57d02b[_0x3561('0x8a')][_0x3561('0x8b')];var _0x55e720=_0x57d02b[_0x3561('0x8a')][_0x3561('0x8c')]||![];var _0x293b39=_0x112ac0(_0x1d4151,_0x55e720);if(!_0x293b39[_0x3561('0x12')])throw new Error('Invalid\x20section\x20\x27'+_0x1d4151+'\x27');var _0x5ded42=[{'name':_0x1d4151}];if(!_['isEmpty'](_0x293b39[_0x3561('0x18')]))_0x5ded42=_0x293b39[_0x3561('0x18')];var _0x18625e=[];for(var _0x3ad03a=0x0;_0x3ad03a<_0x5ded42[_0x3561('0x8d')];_0x3ad03a++){_0x18625e[_0x3561('0x8e')](_0x399162[_0x3561('0x8f')][_0x3561('0x90')]({'where':{'userProfileId':_0x57d02b['params']['id'],'name':_0x5ded42[_0x3ad03a][_0x3561('0xc')]},'raw':!![]}));}return Promise[_0x3561('0x91')](_0x18625e)[_0x3561('0x7')](function(_0x110e00){var _0x1c729b=_[_0x3561('0x4')](_0x110e00,function(_0x3b6cc3){return _0x3b6cc3?_0x3b6cc3:undefined;});var _0x1ffb8f=_['filter'](_0x5ded42,[_0x3561('0x92'),!![]]);var _0x53799b=_[_0x3561('0x93')](_0x1c729b)&&_[_0x3561('0x93')](_0x1ffb8f)?null:_[_0x3561('0x94')](_0x1ffb8f,_0x1c729b);if(!_0x53799b)return null;var _0x4d4672=[];for(var _0x2edf1f=0x0;_0x2edf1f<_0x53799b['length'];_0x2edf1f++){var _0x2cceec=_[_0x3561('0x90')](_0x5ded42,function(_0x2b2300){return _0x53799b[_0x2edf1f]?_0x2b2300[_0x3561('0xc')]===_0x53799b[_0x2edf1f]['name']:null;});if(_0x2cceec){if(_0x53799b[_0x2edf1f][_0x3561('0x92')]){_0x4d4672[_0x3561('0x8e')](_0x99ffb(_0x293b39[_0x3561('0x12')],_0x53799b[_0x2edf1f]));}else{if(!_0x53799b[_0x2edf1f][_0x3561('0x95')]){_0x4d4672['push'](_0xc96559(_0x2cceec,_0x53799b[_0x2edf1f],_0x293b39[_0x3561('0x12')]));}else{if(_0x2cceec['model']){_0x4d4672[_0x3561('0x8e')](_0x128b26(_0x2cceec,_0x53799b[_0x2edf1f]));}}}}}return Promise['all'](_0x4d4672);})[_0x3561('0x7')](function(_0x48c40d){var _0xaf6daf=_0x48c40d;var _0x55794c=null;if(_0xaf6daf){_0x55794c=_0xaf6daf[_0x3561('0x8d')]===0x1?_0xaf6daf[0x0]:null;}if(!_0x55794c&&!_0xaf6daf)return _0x63073b;var _0x1f4eaf=_0x399162[_0x293b39[_0x3561('0x12')]][_0x3561('0x96')];_0x308eb8[_0x3561('0xa')]=_[_0x3561('0x97')](_0x1f4eaf);_0x308eb8[_0x3561('0x8a')]=_[_0x3561('0x97')](_0x57d02b[_0x3561('0x8a')]);_0x308eb8[_0x3561('0x98')]=_[_0x3561('0x99')](_0x308eb8[_0x3561('0xa')],_0x308eb8['query']);_0x165a02[_0x3561('0x9a')]=_[_0x3561('0x99')](_0x308eb8[_0x3561('0xa')],_0x2e7f0c['fields'](_0x57d02b[_0x3561('0x8a')]['fields']));_0x165a02[_0x3561('0x9a')]=_0x165a02[_0x3561('0x9a')][_0x3561('0x8d')]?_0x165a02[_0x3561('0x9a')]:_0x308eb8[_0x3561('0xa')];if(!_0x57d02b[_0x3561('0x8a')][_0x3561('0x9b')](_0x3561('0x9c'))){_0x165a02[_0x3561('0x9d')]=_0x2e7f0c[_0x3561('0x9d')](_0x57d02b[_0x3561('0x8a')][_0x3561('0x9d')]);_0x165a02[_0x3561('0x9e')]=_0x2e7f0c['offset'](_0x57d02b['query'][_0x3561('0x9e')]);}_0x165a02['order']=_0x2e7f0c[_0x3561('0x9f')](_0x57d02b['query'][_0x3561('0x9f')]);_0x165a02[_0x3561('0x81')]=_0x2e7f0c[_0x3561('0x98')](_[_0x3561('0xa0')](_0x57d02b['query'],_0x308eb8['filters']));if(_0x57d02b[_0x3561('0x8a')][_0x3561('0x4')]){_0x165a02[_0x3561('0x81')]=_['merge'](_0x165a02[_0x3561('0x81')],{'$or':_['map'](_0x1f4eaf,function(_0x35db41){if(_0x35db41[_0x3561('0x11')][_0x3561('0xa1')]!==_0x3561('0xa2')){var _0xf1f10b={};_0xf1f10b[_0x35db41['field']]={'$like':'%'+_0x57d02b['query'][_0x3561('0x4')]+'%'};return _0xf1f10b;}})});}var _0x43d1fa=[];var _0xda678=null;var _0x15d5bb={};if(_0x55794c){_0xda678=_[_0x3561('0x90')](_0x5ded42,[_0x3561('0xc'),_0x55794c[_0x3561('0xc')]]);if(_0xda678['field']){_0x15d5bb={};if(_0x293b39[_0x3561('0x12')]===_0x3561('0xf')){_0x15d5bb[_0xda678[_0x3561('0xa3')]]=_[_0x3561('0x8')](_0x55794c[_0x3561('0xb')],'id');}else{_0x15d5bb[_0xda678[_0x3561('0xa3')]]=_0x55794c[_0x3561('0xb')];}_0x43d1fa[_0x3561('0x8e')](_0x15d5bb);}else{_0x165a02[_0x3561('0x81')]['id']=_0x55794c[_0x3561('0xb')];}}else{for(var _0x517c37=0x0;_0x517c37<_0xaf6daf[_0x3561('0x8d')];_0x517c37++){_0xda678=_['find'](_0x5ded42,[_0x3561('0xc'),_0xaf6daf[_0x517c37][_0x3561('0xc')]]);if(_0xda678['field']){_0x15d5bb={};_0x15d5bb[_0xda678['foreignKey']]=_0xaf6daf[_0x517c37]['associatedResources'];_0x43d1fa[_0x3561('0x8e')](_0x15d5bb);}else{if(!_0x165a02[_0x3561('0x81')]['id'])_0x165a02[_0x3561('0x81')]['id']=[];_0xaf6daf[_0x517c37][_0x3561('0xb')]['forEach'](function(_0x21e08b){_0x165a02[_0x3561('0x81')]['id'][_0x3561('0x8e')](_0x21e08b);});}}}if(!_['isEmpty'](_0x43d1fa)){_0x165a02['where']=_[_0x3561('0xa4')](_0x165a02[_0x3561('0x81')],{'$and':{'$or':_0x43d1fa}});}_0x165a02=_[_0x3561('0xa4')]({},_0x165a02,_0x57d02b['options']);if(_0x55794c&&!_0x55794c[_0x3561('0x95')]&&_0x293b39['childModel']===_0x3561('0xf')){if(_0x57d02b[_0x3561('0x8a')][_0x3561('0xa5')]){_0x165a02[_0x3561('0xa6')]=[{'all':!![]}];}return _0x399162[_0x293b39['childModel']]['findAll'](_0x165a02)[_0x3561('0x7')](function(_0x2ee4f8){var _0x441976=[];_0x2ee4f8[_0x3561('0xa7')](function(_0x4ad894){var _0x291a73;switch(_0x4ad894[_0x3561('0xa8')]){case _0x3561('0xa9'):_0x291a73=_[_0x3561('0x90')](_0x55794c['associatedResources'],function(_0x44a70e){return _0x44a70e['id']===_0x4ad894[_0x3561('0xaa')]&&_0x44a70e[_0x3561('0x11')]===_0x3561('0xab');});break;case _0x3561('0xac'):_0x291a73=_['find'](_0x55794c[_0x3561('0xb')],function(_0x350da7){return _0x350da7['id']===_0x4ad894['reportId']&&_0x350da7['type']===_0x3561('0xad');});break;}if(_0x291a73)_0x441976[_0x3561('0x8e')](_0x4ad894);});_0x63073b[_0x3561('0xae')]=_0x441976['length'];_0x63073b[_0x3561('0xaf')]=_0x441976;return _0x63073b;});}else{if(!_['isEmpty'](_0x57d02b['query']['ids'])){_0x165a02[_0x3561('0x81')]['id']=_0x165a02['where']['id']?_[_0x3561('0x99')](_0x165a02[_0x3561('0x81')]['id'],_0x57d02b['query'][_0x3561('0xb0')]):_0x57d02b[_0x3561('0x8a')][_0x3561('0xb0')];if(_0x57d02b[_0x3561('0x8a')][_0x3561('0xb1')]){_0x165a02[_0x3561('0xb2')]=_0x57d02b[_0x3561('0x8a')][_0x3561('0xb1')];}}if(_0x57d02b['query']['extraQueryConditions']){_0x165a02[_0x3561('0x81')]=_['merge'](_0x165a02['where'],{'$and':_0x57d02b['query'][_0x3561('0xb3')]});}return _0x399162[_0x293b39[_0x3561('0x12')]][_0x3561('0xae')]({'where':_0x165a02[_0x3561('0x81')]})[_0x3561('0x7')](function(_0x530d02){_0x63073b[_0x3561('0xae')]=_0x530d02;if(_0x57d02b[_0x3561('0x8a')][_0x3561('0xa5')]){if(_0x293b39[_0x3561('0x12')]===_0x3561('0xb4')){_0x165a02[_0x3561('0xa6')]=[{'model':_0x399162[_0x3561('0x6d')],'as':'Tags','attributes':['id','name',_0x3561('0xb5')],'required':_0x57d02b[_0x3561('0x8a')][_0x3561('0xb6')]?!![]:![]},{'model':_0x399162[_0x3561('0x6d')],'as':_0x3561('0xb7'),'attributes':['id',_0x3561('0xc'),_0x3561('0xb5')],'through':_0x57d02b[_0x3561('0x8a')][_0x3561('0xb6')]?{'attributes':[],'where':{'TagId':_0x57d02b[_0x3561('0x8a')][_0x3561('0xb6')]||undefined}}:{},'required':_0x57d02b[_0x3561('0x8a')][_0x3561('0xb6')]?!![]:![]}];}else{_0x165a02['include']=[{'all':!![]}];}}return _0x399162[_0x293b39['childModel']][_0x3561('0x6')](_0x165a02);})['then'](function(_0x56fb9c){_0x63073b[_0x3561('0xaf')]=_0x56fb9c;if(_0x1d4151==='Agents'&&_0x57d02b[_0x3561('0x8a')]['openTabs']===_0x3561('0xb8')){var _0x411072=[];for(var _0x3d9072=0x0;_0x3d9072<_0x63073b[_0x3561('0xaf')][_0x3561('0x8d')];_0x3d9072++){_0x411072['push'](_0x16672b(_0x3561('0xb9'),_0x63073b[_0x3561('0xaf')][_0x3d9072][_0x3561('0xba')]));_0x411072[_0x3561('0x8e')](_0x16672b(_0x3561('0xbb'),_0x63073b[_0x3561('0xaf')][_0x3d9072][_0x3561('0xba')]));_0x411072[_0x3561('0x8e')](_0x16672b(_0x3561('0xbc'),_0x63073b[_0x3561('0xaf')][_0x3d9072][_0x3561('0xba')]));_0x411072[_0x3561('0x8e')](_0x16672b(_0x3561('0xbd'),_0x63073b[_0x3561('0xaf')][_0x3d9072]['dataValues']));_0x411072['push'](_0x16672b(_0x3561('0xbe'),_0x63073b[_0x3561('0xaf')][_0x3d9072]['dataValues']));_0x411072[_0x3561('0x8e')](_0x16672b(_0x3561('0xbf'),_0x63073b[_0x3561('0xaf')][_0x3d9072][_0x3561('0xba')]));}return Promise[_0x3561('0x91')](_0x411072)[_0x3561('0x7')](function(){return _0x63073b;});}return _0x63073b;});}});}}});};