fd863e1b9a6cb35df0d0a41f31f89bd0e9b9514d
[motion2.git] / 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 _0xc3af=['CmList','CmCompany','globalcustomfields','chatqueues','chatwebsites','ChatWebsite','FaxQueue','faxaccounts','inboundroutes','internalroutes','outboundroutes','VoiceExtension','contexts','VoiceContext','voicemails','VoiceMail','voicerecordings','VoiceRecording','membername','User','role','agent','Telephones','telephone','queue','VoiceQueue','inbound','outbound','VoiceMusicOnHold','chanspies','VoiceChanSpy','voiceprefixes','Campaign','mailqueues','mailaccounts','MailAccount','OpenchannelQueue','OpenchannelAccount','smsqueues','SmsQueue','smsaccounts','SmsAccount','whatsappqueues','WhatsappQueue','whatsappaccounts','teams','VoiceQueues','QueueCampaigns','users','agents','Users','user','Agents','zendeskaccounts','ZendeskAccount','SalesforceAccount','freshdeskaccounts','FreshdeskAccount','sugarcrmaccounts','deskaccounts','DeskAccount','zohoaccounts','ZohoAccount','vtigeraccounts','cannedanswers','dispositions','Disposition','customdashboards','Dashboard','intervals','Interval','pauses','scheduler','Schedule','sounds','Sound','tags','Tag','templates','Template','triggers','trunks','variables','Variable','plugins','extractedreports','reportId','metrics','AnalyticMetric','charAt','toUpperCase','slice','QueryTypes','SELECT','select','ui.','InteractionId','ui.createdAt','from','ui.UserId\x20=\x20?','query','toString','OpenTabs','define','user_profiles','../../components/parsers/qs','section','mergeResources','Invalid\x20section\x20\x27','isEmpty','length','push','UserProfileSection','find','params','all','ignore','union','autoAssociation','model','keys','filters','attributes','intersection','fields','nolimit','limit','offset','order','sort','pick','where','key','VIRTUAL','foreignKey','merge','options','includeAll','include','forEach','CustomReports','count','rows','ids','customSorting','extraQueryConditions','Tags','color','tag','true','chat','sms','dataValues','fax','mail','openchannel','whatsapp','lodash','./userProfile.attributes','models','filter','field','value','findAll','map','catch','then','associatedResources','name','resolve','UserProfileResource','AnalyticExtractedReport','resourceId','type','toLowerCase','squareprojects','SquareProject','odbc','SquareOdbc','squarerecordings','childModel','SquareRecording','parentSections','SquareProjects','projects','JscriptyProject','contacts','CmContact','Lists','lists'];(function(_0x1f60c4,_0x1c58e5){var _0x4d3340=function(_0x335584){while(--_0x335584){_0x1f60c4['push'](_0x1f60c4['shift']());}};_0x4d3340(++_0x1c58e5);}(_0xc3af,0x15b));var _0xfc3a=function(_0x21353c,_0x2ea587){_0x21353c=_0x21353c-0x0;var _0xa99120=_0xc3af[_0x21353c];return _0xa99120;};'use strict';var _=require(_0xfc3a('0x0'));var attributes=require(_0xfc3a('0x1'));var squel=require('squel');module['exports']=function(_0x12709e){var _0x309a4f=_0x12709e[_0xfc3a('0x2')];function _0x5265e0(_0x1804fb,_0x1b72d0){return new Promise(function(_0x225140,_0x249e0c){if(!_0x1b72d0)return _0x225140(null);var _0x4224b4=_0x1b72d0[_0xfc3a('0x3')]?{[_0x1b72d0[_0xfc3a('0x3')][_0xfc3a('0x4')]]:_0x1b72d0[_0xfc3a('0x3')][_0xfc3a('0x5')]}:undefined;return _0x309a4f[_0x1804fb][_0xfc3a('0x6')]({'where':_0x4224b4,'raw':!![]})['then'](function(_0x134586){_0x1b72d0['associatedResources']=_[_0xfc3a('0x7')](_0x134586,'id');_0x225140(_0x1b72d0);})[_0xfc3a('0x8')](function(_0x22e15b){_0x249e0c(_0x22e15b);});});}function _0x3f2c41(_0x2035e9,_0x34375b){return new Promise(function(_0x23ffb7,_0x584a6c){var _0x1c7d88=_0x2035e9[_0xfc3a('0x3')]?{[_0x2035e9[_0xfc3a('0x3')][_0xfc3a('0x4')]]:_0x2035e9[_0xfc3a('0x3')][_0xfc3a('0x5')]}:undefined;return _0x309a4f[_0x2035e9['model']][_0xfc3a('0x6')]({'where':_0x1c7d88,'raw':!![]})[_0xfc3a('0x9')](function(_0x16f23d){_0x34375b[_0xfc3a('0xa')]=_['map'](_0x16f23d,function(_0x506e03){return _0x506e03[_0xfc3a('0xb')];});_0x23ffb7(_0x34375b);})[_0xfc3a('0x8')](function(_0x125fb8){_0x584a6c(_0x125fb8);});});}function _0x559987(_0x10a3a0,_0x432299,_0x30b5e6){if(!_0x432299)return Promise[_0xfc3a('0xc')](null);return new Promise(function(_0x520105,_0x515a03){return _0x309a4f[_0xfc3a('0xd')][_0xfc3a('0x6')]({'where':{'sectionId':_0x432299['id']},'raw':!![]})[_0xfc3a('0x9')](function(_0x528c57){if(_0x10a3a0[_0xfc3a('0x4')]&&_0x10a3a0[_0xfc3a('0x4')]!=='id'){_0x432299[_0xfc3a('0xa')]=_['map'](_0x528c57,function(_0x3bd023){return _0x3bd023[_0x10a3a0[_0xfc3a('0x4')]];});}else{if(_0x30b5e6===_0xfc3a('0xe')){_0x432299['associatedResources']=_[_0xfc3a('0x7')](_0x528c57,function(_0x20aa17){return{'id':_0x20aa17[_0xfc3a('0xf')],'type':_0x20aa17[_0xfc3a('0x10')]};});}else{_0x432299[_0xfc3a('0xa')]=_[_0xfc3a('0x7')](_0x528c57,function(_0x486434){return _0x486434[_0xfc3a('0xf')];});}}_0x520105(_0x432299);})[_0xfc3a('0x8')](function(_0x43cf4a){_0x515a03(_0x43cf4a);});});}function _0x4dea7d(_0x44b270,_0xf898d5){var _0x54ee6a={'parentSections':[]};switch(_0x44b270[_0xfc3a('0x11')]()){case _0xfc3a('0x12'):_0x54ee6a['childModel']=_0xfc3a('0x13');break;case _0xfc3a('0x14'):_0x54ee6a['childModel']=_0xfc3a('0x15');break;case _0xfc3a('0x16'):_0x54ee6a[_0xfc3a('0x17')]=_0xfc3a('0x18');_0x54ee6a[_0xfc3a('0x19')]=[{'name':_0xfc3a('0x1a'),'field':_0xfc3a('0xb'),'foreignKey':'projectName'}];break;case _0xfc3a('0x1b'):_0x54ee6a['childModel']=_0xfc3a('0x1c');break;case _0xfc3a('0x1d'):_0x54ee6a[_0xfc3a('0x17')]=_0xfc3a('0x1e');_0x54ee6a[_0xfc3a('0x19')]=[{'name':_0xfc3a('0x1f'),'field':'id','foreignKey':'ListId'}];break;case _0xfc3a('0x20'):_0x54ee6a[_0xfc3a('0x17')]=_0xfc3a('0x21');break;case'companies':_0x54ee6a[_0xfc3a('0x17')]=_0xfc3a('0x22');break;case _0xfc3a('0x23'):_0x54ee6a['childModel']='CmCustomField';break;case _0xfc3a('0x24'):_0x54ee6a[_0xfc3a('0x17')]='ChatQueue';break;case _0xfc3a('0x25'):_0x54ee6a[_0xfc3a('0x17')]=_0xfc3a('0x26');break;case'faxqueues':_0x54ee6a[_0xfc3a('0x17')]=_0xfc3a('0x27');break;case _0xfc3a('0x28'):_0x54ee6a[_0xfc3a('0x17')]='FaxAccount';break;case _0xfc3a('0x29'):case _0xfc3a('0x2a'):case _0xfc3a('0x2b'):_0x54ee6a[_0xfc3a('0x17')]=_0xfc3a('0x2c');break;case _0xfc3a('0x2d'):_0x54ee6a[_0xfc3a('0x17')]=_0xfc3a('0x2e');break;case _0xfc3a('0x2f'):_0x54ee6a[_0xfc3a('0x17')]=_0xfc3a('0x30');break;case _0xfc3a('0x31'):_0x54ee6a['childModel']=_0xfc3a('0x32');_0x54ee6a[_0xfc3a('0x19')]=[{'name':'Agents','field':_0xfc3a('0xb'),'foreignKey':_0xfc3a('0x33'),'model':_0xfc3a('0x34'),'filter':{'field':_0xfc3a('0x35'),'value':[_0xfc3a('0x36')]}},{'name':_0xfc3a('0x37'),'field':_0xfc3a('0xb'),'foreignKey':_0xfc3a('0x33'),'model':_0xfc3a('0x34'),'filter':{'field':_0xfc3a('0x35'),'value':[_0xfc3a('0x38')]}},{'name':'VoiceQueues','field':_0xfc3a('0xb'),'foreignKey':_0xfc3a('0x39'),'model':_0xfc3a('0x3a'),'filter':{'field':_0xfc3a('0x10'),'value':[_0xfc3a('0x3b')]}},{'name':'QueueCampaigns','field':_0xfc3a('0xb'),'foreignKey':_0xfc3a('0x39'),'model':_0xfc3a('0x3a'),'filter':{'field':_0xfc3a('0x10'),'value':[_0xfc3a('0x3c')]}}];break;case'musiconholds':_0x54ee6a[_0xfc3a('0x17')]=_0xfc3a('0x3d');break;case _0xfc3a('0x3e'):_0x54ee6a['childModel']=_0xfc3a('0x3f');break;case _0xfc3a('0x40'):_0x54ee6a[_0xfc3a('0x17')]='VoicePrefix';break;case'ivrcampaigns':_0x54ee6a[_0xfc3a('0x17')]=_0xfc3a('0x41');break;case _0xfc3a('0x42'):_0x54ee6a[_0xfc3a('0x17')]='MailQueue';break;case _0xfc3a('0x43'):_0x54ee6a[_0xfc3a('0x17')]=_0xfc3a('0x44');break;case'mailsubstatuses':_0x54ee6a[_0xfc3a('0x17')]='MailSubstatus';break;case'openchannelqueues':_0x54ee6a['childModel']=_0xfc3a('0x45');break;case'openchannelaccounts':_0x54ee6a[_0xfc3a('0x17')]=_0xfc3a('0x46');break;case _0xfc3a('0x47'):_0x54ee6a[_0xfc3a('0x17')]=_0xfc3a('0x48');break;case _0xfc3a('0x49'):_0x54ee6a[_0xfc3a('0x17')]=_0xfc3a('0x4a');break;case _0xfc3a('0x4b'):_0x54ee6a[_0xfc3a('0x17')]=_0xfc3a('0x4c');break;case _0xfc3a('0x4d'):_0x54ee6a[_0xfc3a('0x17')]='WhatsappAccount';break;case _0xfc3a('0x4e'):_0x54ee6a[_0xfc3a('0x17')]='Team';break;case'voicequeues':case'queuecampaigns':_0x54ee6a[_0xfc3a('0x17')]='VoiceQueue';if(_0xf898d5){_0x54ee6a['parentSections']=[{'name':_0xfc3a('0x4f')},{'name':_0xfc3a('0x50')}];}break;case _0xfc3a('0x51'):case _0xfc3a('0x52'):case'telephones':_0x54ee6a[_0xfc3a('0x17')]=_0xfc3a('0x34');if(_0xf898d5){_0x54ee6a['parentSections']=[{'name':_0xfc3a('0x53'),'filter':{'field':_0xfc3a('0x35'),'value':['admin',_0xfc3a('0x54')]},'ignore':!![]},{'name':_0xfc3a('0x55')},{'name':_0xfc3a('0x37')}];}break;case _0xfc3a('0x56'):_0x54ee6a[_0xfc3a('0x17')]=_0xfc3a('0x57');break;case'salesforceaccounts':_0x54ee6a[_0xfc3a('0x17')]=_0xfc3a('0x58');break;case _0xfc3a('0x59'):_0x54ee6a['childModel']=_0xfc3a('0x5a');break;case _0xfc3a('0x5b'):_0x54ee6a[_0xfc3a('0x17')]='SugarcrmAccount';break;case _0xfc3a('0x5c'):_0x54ee6a[_0xfc3a('0x17')]=_0xfc3a('0x5d');break;case _0xfc3a('0x5e'):_0x54ee6a[_0xfc3a('0x17')]=_0xfc3a('0x5f');break;case _0xfc3a('0x60'):_0x54ee6a['childModel']=_0xfc3a('0x34');break;case _0xfc3a('0x61'):_0x54ee6a[_0xfc3a('0x17')]='CannedAnswer';break;case _0xfc3a('0x62'):_0x54ee6a[_0xfc3a('0x17')]=_0xfc3a('0x63');break;case _0xfc3a('0x64'):_0x54ee6a[_0xfc3a('0x17')]=_0xfc3a('0x65');break;case _0xfc3a('0x66'):_0x54ee6a[_0xfc3a('0x17')]=_0xfc3a('0x67');break;case _0xfc3a('0x68'):_0x54ee6a[_0xfc3a('0x17')]='Pause';break;case _0xfc3a('0x69'):_0x54ee6a['childModel']=_0xfc3a('0x6a');break;case _0xfc3a('0x6b'):_0x54ee6a[_0xfc3a('0x17')]=_0xfc3a('0x6c');break;case _0xfc3a('0x6d'):_0x54ee6a[_0xfc3a('0x17')]=_0xfc3a('0x6e');break;case _0xfc3a('0x6f'):_0x54ee6a['childModel']=_0xfc3a('0x70');break;case _0xfc3a('0x71'):_0x54ee6a['childModel']='Trigger';break;case _0xfc3a('0x72'):_0x54ee6a[_0xfc3a('0x17')]='Trunk';break;case _0xfc3a('0x73'):_0x54ee6a[_0xfc3a('0x17')]=_0xfc3a('0x74');break;case _0xfc3a('0x75'):_0x54ee6a[_0xfc3a('0x17')]='Plugin';break;case _0xfc3a('0x76'):_0x54ee6a['childModel']='AnalyticExtractedReport';_0x54ee6a['parentSections']=[{'name':'Reports','field':'id','foreignKey':_0xfc3a('0x77')}];break;case _0xfc3a('0x78'):_0x54ee6a['childModel']=_0xfc3a('0x79');break;}return _0x54ee6a;}function _0x31457d(_0x5d0f4d,_0x5324d9){var _0xaa0879=_0x5d0f4d[_0xfc3a('0x7a')](0x0)[_0xfc3a('0x7b')]()+_0x5d0f4d[_0xfc3a('0x7c')](0x1);var _0x5a556c={'type':_0x309a4f['Sequelize'][_0xfc3a('0x7d')][_0xfc3a('0x7e')],'raw':!![]};return new Promise(function(_0x4a7dc7,_0x2a20e9){var _0x7a62f7=squel[_0xfc3a('0x7f')]()['field'](_0xfc3a('0x80')+_0xaa0879+_0xfc3a('0x81'),'id')[_0xfc3a('0x4')](_0xfc3a('0x82'))[_0xfc3a('0x83')]('user_has_'+_0x5d0f4d+'_interactions','ui')['where'](_0xfc3a('0x84'),_0x5324d9['id']);return _0x309a4f['sequelize'][_0xfc3a('0x85')](_0x7a62f7[_0xfc3a('0x86')](),_0x5a556c)[_0xfc3a('0x9')](function(_0x2feff8){_0x5324d9[_0xaa0879+_0xfc3a('0x87')]=_0x2feff8;_0x4a7dc7(_0x2feff8);})[_0xfc3a('0x8')](function(_0x2f6c1b){_0x2a20e9(_0x2f6c1b);});});}return _0x12709e[_0xfc3a('0x88')]('UserProfile',attributes,{'tableName':_0xfc3a('0x89'),'paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x25bc63){var _0x195c36=require(_0xfc3a('0x8a'));var _0x3dad92={'raw':_0x25bc63['query']['raw'],'where':{}};var _0x567752={};var _0xd455a3={'count':0x0,'rows':[]};var _0x17d39f=_0x25bc63['query'][_0xfc3a('0x8b')];var _0x5c7e09=_0x25bc63[_0xfc3a('0x85')][_0xfc3a('0x8c')]||![];var _0x359976=_0x4dea7d(_0x17d39f,_0x5c7e09);if(!_0x359976[_0xfc3a('0x17')])throw new Error(_0xfc3a('0x8d')+_0x17d39f+'\x27');var _0x6f9721=[{'name':_0x17d39f}];if(!_[_0xfc3a('0x8e')](_0x359976[_0xfc3a('0x19')]))_0x6f9721=_0x359976[_0xfc3a('0x19')];var _0x54c9fd=[];for(var _0xe0d09c=0x0;_0xe0d09c<_0x6f9721[_0xfc3a('0x8f')];_0xe0d09c++){_0x54c9fd[_0xfc3a('0x90')](_0x309a4f[_0xfc3a('0x91')][_0xfc3a('0x92')]({'where':{'userProfileId':_0x25bc63[_0xfc3a('0x93')]['id'],'name':_0x6f9721[_0xe0d09c]['name']},'raw':!![]}));}return Promise[_0xfc3a('0x94')](_0x54c9fd)['then'](function(_0x567e48){var _0x105949=_['filter'](_0x567e48,function(_0x365533){return _0x365533?_0x365533:undefined;});var _0x50382e=_[_0xfc3a('0x3')](_0x6f9721,[_0xfc3a('0x95'),!![]]);var _0x3b8010=_['isEmpty'](_0x105949)&&_[_0xfc3a('0x8e')](_0x50382e)?null:_[_0xfc3a('0x96')](_0x50382e,_0x105949);if(!_0x3b8010)return null;var _0x4cb9a9=[];for(var _0x1fdb09=0x0;_0x1fdb09<_0x3b8010[_0xfc3a('0x8f')];_0x1fdb09++){var _0x2d0220=_[_0xfc3a('0x92')](_0x6f9721,function(_0xb55d77){return _0x3b8010[_0x1fdb09]?_0xb55d77[_0xfc3a('0xb')]===_0x3b8010[_0x1fdb09]['name']:null;});if(_0x2d0220){if(_0x3b8010[_0x1fdb09][_0xfc3a('0x95')]){_0x4cb9a9[_0xfc3a('0x90')](_0x5265e0(_0x359976[_0xfc3a('0x17')],_0x3b8010[_0x1fdb09]));}else{if(!_0x3b8010[_0x1fdb09][_0xfc3a('0x97')]){_0x4cb9a9[_0xfc3a('0x90')](_0x559987(_0x2d0220,_0x3b8010[_0x1fdb09],_0x359976[_0xfc3a('0x17')]));}else{if(_0x2d0220[_0xfc3a('0x98')]){_0x4cb9a9[_0xfc3a('0x90')](_0x3f2c41(_0x2d0220,_0x3b8010[_0x1fdb09]));}}}}}return Promise['all'](_0x4cb9a9);})[_0xfc3a('0x9')](function(_0x3bb1a0){var _0x55400b=_0x3bb1a0;var _0x542c46=null;if(_0x55400b){_0x542c46=_0x55400b['length']===0x1?_0x55400b[0x0]:null;}if(!_0x542c46&&!_0x55400b)return _0xd455a3;var _0xdc36b3=_0x309a4f[_0x359976['childModel']]['rawAttributes'];_0x567752[_0xfc3a('0x98')]=_['keys'](_0xdc36b3);_0x567752['query']=_[_0xfc3a('0x99')](_0x25bc63[_0xfc3a('0x85')]);_0x567752[_0xfc3a('0x9a')]=_['intersection'](_0x567752[_0xfc3a('0x98')],_0x567752[_0xfc3a('0x85')]);_0x3dad92[_0xfc3a('0x9b')]=_[_0xfc3a('0x9c')](_0x567752[_0xfc3a('0x98')],_0x195c36[_0xfc3a('0x9d')](_0x25bc63['query'][_0xfc3a('0x9d')]));_0x3dad92['attributes']=_0x3dad92['attributes']['length']?_0x3dad92['attributes']:_0x567752['model'];if(!_0x25bc63[_0xfc3a('0x85')]['hasOwnProperty'](_0xfc3a('0x9e'))){_0x3dad92['limit']=_0x195c36[_0xfc3a('0x9f')](_0x25bc63[_0xfc3a('0x85')][_0xfc3a('0x9f')]);_0x3dad92[_0xfc3a('0xa0')]=_0x195c36['offset'](_0x25bc63[_0xfc3a('0x85')][_0xfc3a('0xa0')]);}_0x3dad92[_0xfc3a('0xa1')]=_0x195c36[_0xfc3a('0xa2')](_0x25bc63[_0xfc3a('0x85')][_0xfc3a('0xa2')]);_0x3dad92['where']=_0x195c36[_0xfc3a('0x9a')](_[_0xfc3a('0xa3')](_0x25bc63[_0xfc3a('0x85')],_0x567752[_0xfc3a('0x9a')]));if(_0x25bc63[_0xfc3a('0x85')]['filter']){_0x3dad92[_0xfc3a('0xa4')]=_['merge'](_0x3dad92['where'],{'$or':_[_0xfc3a('0x7')](_0xdc36b3,function(_0x344c36){if(_0x344c36[_0xfc3a('0x10')][_0xfc3a('0xa5')]!==_0xfc3a('0xa6')){var _0x468514={};_0x468514[_0x344c36['field']]={'$like':'%'+_0x25bc63[_0xfc3a('0x85')]['filter']+'%'};return _0x468514;}})});}var _0x34d5ce=[];var _0x11ced7=null;var _0x1a1109={};if(_0x542c46){_0x11ced7=_[_0xfc3a('0x92')](_0x6f9721,[_0xfc3a('0xb'),_0x542c46[_0xfc3a('0xb')]]);if(_0x11ced7['field']){_0x1a1109={};if(_0x359976['childModel']===_0xfc3a('0xe')){_0x1a1109[_0x11ced7[_0xfc3a('0xa7')]]=_[_0xfc3a('0x7')](_0x542c46[_0xfc3a('0xa')],'id');}else{_0x1a1109[_0x11ced7['foreignKey']]=_0x542c46[_0xfc3a('0xa')];}_0x34d5ce['push'](_0x1a1109);}else{_0x3dad92[_0xfc3a('0xa4')]['id']=_0x542c46[_0xfc3a('0xa')];}}else{for(var _0x21e2d4=0x0;_0x21e2d4<_0x55400b['length'];_0x21e2d4++){_0x11ced7=_['find'](_0x6f9721,[_0xfc3a('0xb'),_0x55400b[_0x21e2d4][_0xfc3a('0xb')]]);if(_0x11ced7[_0xfc3a('0x4')]){_0x1a1109={};_0x1a1109[_0x11ced7[_0xfc3a('0xa7')]]=_0x55400b[_0x21e2d4][_0xfc3a('0xa')];_0x34d5ce[_0xfc3a('0x90')](_0x1a1109);}else{if(!_0x3dad92[_0xfc3a('0xa4')]['id'])_0x3dad92['where']['id']=[];_0x55400b[_0x21e2d4][_0xfc3a('0xa')]['forEach'](function(_0x8d4c2d){_0x3dad92[_0xfc3a('0xa4')]['id']['push'](_0x8d4c2d);});}}}if(!_[_0xfc3a('0x8e')](_0x34d5ce)){_0x3dad92[_0xfc3a('0xa4')]=_['merge'](_0x3dad92['where'],{'$and':{'$or':_0x34d5ce}});}_0x3dad92=_[_0xfc3a('0xa8')]({},_0x3dad92,_0x25bc63[_0xfc3a('0xa9')]);if(_0x542c46&&!_0x542c46[_0xfc3a('0x97')]&&_0x359976['childModel']===_0xfc3a('0xe')){if(_0x25bc63[_0xfc3a('0x85')][_0xfc3a('0xaa')]){_0x3dad92[_0xfc3a('0xab')]=[{'all':!![]}];}return _0x309a4f[_0x359976[_0xfc3a('0x17')]][_0xfc3a('0x6')](_0x3dad92)['then'](function(_0x3f3adf){var _0x3ccad5=[];_0x3f3adf[_0xfc3a('0xac')](function(_0x396a96){var _0x503048;switch(_0x396a96['reportType']){case'default':_0x503048=_[_0xfc3a('0x92')](_0x542c46[_0xfc3a('0xa')],function(_0x14eb99){return _0x14eb99['id']===_0x396a96[_0xfc3a('0x77')]&&_0x14eb99[_0xfc3a('0x10')]==='DefaultReports';});break;case'custom':_0x503048=_[_0xfc3a('0x92')](_0x542c46[_0xfc3a('0xa')],function(_0x53ce33){return _0x53ce33['id']===_0x396a96[_0xfc3a('0x77')]&&_0x53ce33[_0xfc3a('0x10')]===_0xfc3a('0xad');});break;}if(_0x503048)_0x3ccad5[_0xfc3a('0x90')](_0x396a96);});_0xd455a3[_0xfc3a('0xae')]=_0x3ccad5[_0xfc3a('0x8f')];_0xd455a3[_0xfc3a('0xaf')]=_0x3ccad5;return _0xd455a3;});}else{if(!_[_0xfc3a('0x8e')](_0x25bc63[_0xfc3a('0x85')][_0xfc3a('0xb0')])){_0x3dad92[_0xfc3a('0xa4')]['id']=_0x3dad92[_0xfc3a('0xa4')]['id']?_[_0xfc3a('0x9c')](_0x3dad92[_0xfc3a('0xa4')]['id'],_0x25bc63['query'][_0xfc3a('0xb0')]):_0x25bc63[_0xfc3a('0x85')]['ids'];if(_0x25bc63['query'][_0xfc3a('0xb1')]){_0x3dad92[_0xfc3a('0xa1')]=_0x25bc63['query'][_0xfc3a('0xb1')];}}if(_0x25bc63[_0xfc3a('0x85')]['extraQueryConditions']){_0x3dad92[_0xfc3a('0xa4')]=_[_0xfc3a('0xa8')](_0x3dad92[_0xfc3a('0xa4')],{'$and':_0x25bc63[_0xfc3a('0x85')][_0xfc3a('0xb2')]});}return _0x309a4f[_0x359976[_0xfc3a('0x17')]][_0xfc3a('0xae')]({'where':_0x3dad92[_0xfc3a('0xa4')]})[_0xfc3a('0x9')](function(_0x46ef93){_0xd455a3[_0xfc3a('0xae')]=_0x46ef93;if(_0x25bc63[_0xfc3a('0x85')][_0xfc3a('0xaa')]){if(_0x359976[_0xfc3a('0x17')]===_0xfc3a('0x1e')){_0x3dad92[_0xfc3a('0xab')]=[{'model':_0x309a4f[_0xfc3a('0x6e')],'as':_0xfc3a('0xb3'),'attributes':['id',_0xfc3a('0xb'),_0xfc3a('0xb4')],'required':_0x25bc63[_0xfc3a('0x85')][_0xfc3a('0xb5')]?!![]:![]},{'model':_0x309a4f[_0xfc3a('0x6e')],'as':'ThroughTags','attributes':['id',_0xfc3a('0xb'),_0xfc3a('0xb4')],'through':_0x25bc63[_0xfc3a('0x85')][_0xfc3a('0xb5')]?{'attributes':[],'where':{'TagId':_0x25bc63[_0xfc3a('0x85')]['tag']||undefined}}:{},'required':_0x25bc63[_0xfc3a('0x85')]['tag']?!![]:![]}];}else{_0x3dad92[_0xfc3a('0xab')]=[{'all':!![]}];}}return _0x309a4f[_0x359976[_0xfc3a('0x17')]][_0xfc3a('0x6')](_0x3dad92);})[_0xfc3a('0x9')](function(_0x4821ba){_0xd455a3[_0xfc3a('0xaf')]=_0x4821ba;if(_0x17d39f===_0xfc3a('0x55')&&_0x25bc63[_0xfc3a('0x85')]['openTabs']===_0xfc3a('0xb6')){var _0xdb7de2=[];for(var _0x194900=0x0;_0x194900<_0xd455a3['rows']['length'];_0x194900++){_0xdb7de2[_0xfc3a('0x90')](_0x31457d(_0xfc3a('0xb7'),_0xd455a3['rows'][_0x194900]['dataValues']));_0xdb7de2[_0xfc3a('0x90')](_0x31457d(_0xfc3a('0xb8'),_0xd455a3[_0xfc3a('0xaf')][_0x194900][_0xfc3a('0xb9')]));_0xdb7de2[_0xfc3a('0x90')](_0x31457d(_0xfc3a('0xba'),_0xd455a3[_0xfc3a('0xaf')][_0x194900][_0xfc3a('0xb9')]));_0xdb7de2[_0xfc3a('0x90')](_0x31457d(_0xfc3a('0xbb'),_0xd455a3[_0xfc3a('0xaf')][_0x194900][_0xfc3a('0xb9')]));_0xdb7de2[_0xfc3a('0x90')](_0x31457d(_0xfc3a('0xbc'),_0xd455a3['rows'][_0x194900][_0xfc3a('0xb9')]));_0xdb7de2[_0xfc3a('0x90')](_0x31457d(_0xfc3a('0xbd'),_0xd455a3[_0xfc3a('0xaf')][_0x194900][_0xfc3a('0xb9')]));}return Promise[_0xfc3a('0x94')](_0xdb7de2)[_0xfc3a('0x9')](function(){return _0xd455a3;});}return _0xd455a3;});}});}}});};