Built motion from commit 1fa89557.|2.6.10
[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 _0x4081=['smsqueues','SmsQueue','smsaccounts','SmsAccount','whatsappqueues','WhatsappQueue','whatsappaccounts','teams','Team','voicequeues','queuecampaigns','VoiceQueue','users','agents','telephones','Users','admin','user','Telephones','zendeskaccounts','ZendeskAccount','salesforceaccounts','SalesforceAccount','freshdeskaccounts','FreshdeskAccount','sugarcrmaccounts','SugarcrmAccount','deskaccounts','DeskAccount','zohoaccounts','ZohoAccount','dispositions','Disposition','intervals','Interval','pauses','Pause','scheduler','Schedule','sounds','Sound','tags','Tag','templates','Template','triggers','trunks','Trunk','variables','extractedreports','Reports','AnalyticMetric','charAt','toUpperCase','slice','Sequelize','SELECT','select','ui.','InteractionId','ui.createdAt','from','user_has_','_interactions','where','ui.UserId\x20=\x20?','sequelize','query','toString','OpenTabs','define','UserProfile','user_profiles','mergeResources','Invalid\x20section\x20\x27','isEmpty','length','push','UserProfileSection','find','params','all','ignore','union','autoAssociation','model','keys','filters','attributes','intersection','fields','hasOwnProperty','nolimit','limit','offset','order','sort','pick','key','foreignKey','forEach','merge','options','includeAll','include','default','reportId','custom','CustomReports','count','ids','customSorting','extraQueryConditions','Tags','color','ThroughTags','tag','rows','openTabs','chat','dataValues','sms','fax','mail','openchannel','whatsapp','./userProfile.attributes','../../components/parsers/qs','squel','exports','filter','value','findAll','then','catch','field','map','name','resolve','UserProfileResource','AnalyticExtractedReport','associatedResources','resourceId','toLowerCase','squareprojects','childModel','SquareProject','SquareOdbc','squarerecordings','parentSections','SquareProjects','projectName','projects','JscriptyProject','CmContact','Lists','lists','CmList','companies','globalcustomfields','ChatWebsite','FaxQueue','faxaccounts','inboundroutes','internalroutes','outboundroutes','contexts','voicemails','VoiceMail','voicerecordings','Agents','membername','User','role','agent','telephone','VoiceQueues','type','inbound','QueueCampaigns','queue','outbound','musiconholds','chanspies','VoiceChanSpy','voiceprefixes','VoicePrefix','ivrcampaigns','Campaign','mailqueues','MailQueue','mailaccounts','MailAccount','mailsubstatuses','MailSubstatus','openchannelqueues','openchannelaccounts','OpenchannelAccount'];(function(_0x5709d9,_0x22f72b){var _0x3f2c4c=function(_0xae945d){while(--_0xae945d){_0x5709d9['push'](_0x5709d9['shift']());}};_0x3f2c4c(++_0x22f72b);}(_0x4081,0x7e));var _0x1408=function(_0x490839,_0x211e1b){_0x490839=_0x490839-0x0;var _0x1ac28d=_0x4081[_0x490839];return _0x1ac28d;};'use strict';var _=require('lodash');var attributes=require(_0x1408('0x0'));var qs=require(_0x1408('0x1'));var squel=require(_0x1408('0x2'));module[_0x1408('0x3')]=function(_0x1a6871){var _0x5eeeff=_0x1a6871['models'];function _0x146239(_0x70d5dd,_0x1cc87e){return new Promise(function(_0x1a9b58,_0x1a6ac3){if(!_0x1cc87e)return _0x1a9b58(null);var _0x24b08c=_0x1cc87e[_0x1408('0x4')]?{[_0x1cc87e[_0x1408('0x4')]['field']]:_0x1cc87e[_0x1408('0x4')][_0x1408('0x5')]}:undefined;return _0x5eeeff[_0x70d5dd][_0x1408('0x6')]({'where':_0x24b08c,'raw':!![]})[_0x1408('0x7')](function(_0x5a9a11){_0x1cc87e['associatedResources']=_['map'](_0x5a9a11,'id');_0x1a9b58(_0x1cc87e);})[_0x1408('0x8')](function(_0x3513c6){_0x1a6ac3(_0x3513c6);});});}function _0x13d881(_0x355ca0,_0x531cb1){return new Promise(function(_0x1f51b9,_0x21798a){var _0x5e0c02=_0x355ca0[_0x1408('0x4')]?{[_0x355ca0[_0x1408('0x4')][_0x1408('0x9')]]:_0x355ca0[_0x1408('0x4')][_0x1408('0x5')]}:undefined;return _0x5eeeff[_0x355ca0['model']][_0x1408('0x6')]({'where':_0x5e0c02,'raw':!![]})['then'](function(_0x44a13e){_0x531cb1['associatedResources']=_[_0x1408('0xa')](_0x44a13e,function(_0x1bb72d){return _0x1bb72d[_0x1408('0xb')];});_0x1f51b9(_0x531cb1);})[_0x1408('0x8')](function(_0x36fcfc){_0x21798a(_0x36fcfc);});});}function _0x120987(_0x32635d,_0x6562bd,_0x1cdb87){if(!_0x6562bd)return Promise[_0x1408('0xc')](null);return new Promise(function(_0x36184f,_0x59a83a){return _0x5eeeff[_0x1408('0xd')][_0x1408('0x6')]({'where':{'sectionId':_0x6562bd['id']},'raw':!![]})[_0x1408('0x7')](function(_0x5974cf){if(_0x32635d['field']&&_0x32635d['field']!=='id'){_0x6562bd['associatedResources']=_[_0x1408('0xa')](_0x5974cf,function(_0x2c2216){return _0x2c2216[_0x32635d['field']];});}else{if(_0x1cdb87===_0x1408('0xe')){_0x6562bd[_0x1408('0xf')]=_[_0x1408('0xa')](_0x5974cf,function(_0x5226a9){return{'id':_0x5226a9['resourceId'],'type':_0x5226a9['type']};});}else{_0x6562bd['associatedResources']=_[_0x1408('0xa')](_0x5974cf,function(_0x1f03a7){return _0x1f03a7[_0x1408('0x10')];});}}_0x36184f(_0x6562bd);})[_0x1408('0x8')](function(_0x301d1f){_0x59a83a(_0x301d1f);});});}function _0x42753d(_0x15d8ed,_0xcdf431){var _0x3fe0d2={'parentSections':[]};switch(_0x15d8ed[_0x1408('0x11')]()){case _0x1408('0x12'):_0x3fe0d2[_0x1408('0x13')]=_0x1408('0x14');break;case'odbc':_0x3fe0d2[_0x1408('0x13')]=_0x1408('0x15');break;case _0x1408('0x16'):_0x3fe0d2['childModel']='SquareRecording';_0x3fe0d2[_0x1408('0x17')]=[{'name':_0x1408('0x18'),'field':_0x1408('0xb'),'foreignKey':_0x1408('0x19')}];break;case _0x1408('0x1a'):_0x3fe0d2[_0x1408('0x13')]=_0x1408('0x1b');break;case'contacts':_0x3fe0d2['childModel']=_0x1408('0x1c');_0x3fe0d2[_0x1408('0x17')]=[{'name':_0x1408('0x1d'),'field':'id','foreignKey':'ListId'}];break;case _0x1408('0x1e'):_0x3fe0d2[_0x1408('0x13')]=_0x1408('0x1f');break;case _0x1408('0x20'):_0x3fe0d2[_0x1408('0x13')]='CmCompany';break;case _0x1408('0x21'):_0x3fe0d2[_0x1408('0x13')]='CmCustomField';break;case'chatqueues':_0x3fe0d2[_0x1408('0x13')]='ChatQueue';break;case'chatwebsites':_0x3fe0d2[_0x1408('0x13')]=_0x1408('0x22');break;case'faxqueues':_0x3fe0d2[_0x1408('0x13')]=_0x1408('0x23');break;case _0x1408('0x24'):_0x3fe0d2[_0x1408('0x13')]='FaxAccount';break;case _0x1408('0x25'):case _0x1408('0x26'):case _0x1408('0x27'):_0x3fe0d2[_0x1408('0x13')]='VoiceExtension';break;case _0x1408('0x28'):_0x3fe0d2['childModel']='VoiceContext';break;case _0x1408('0x29'):_0x3fe0d2['childModel']=_0x1408('0x2a');break;case _0x1408('0x2b'):_0x3fe0d2[_0x1408('0x13')]='VoiceRecording';_0x3fe0d2[_0x1408('0x17')]=[{'name':_0x1408('0x2c'),'field':'name','foreignKey':_0x1408('0x2d'),'model':_0x1408('0x2e'),'filter':{'field':_0x1408('0x2f'),'value':[_0x1408('0x30')]}},{'name':'Telephones','field':'name','foreignKey':'membername','model':_0x1408('0x2e'),'filter':{'field':'role','value':[_0x1408('0x31')]}},{'name':_0x1408('0x32'),'field':_0x1408('0xb'),'foreignKey':'queue','model':'VoiceQueue','filter':{'field':_0x1408('0x33'),'value':[_0x1408('0x34')]}},{'name':_0x1408('0x35'),'field':_0x1408('0xb'),'foreignKey':_0x1408('0x36'),'model':'VoiceQueue','filter':{'field':_0x1408('0x33'),'value':[_0x1408('0x37')]}}];break;case _0x1408('0x38'):_0x3fe0d2[_0x1408('0x13')]='VoiceMusicOnHold';break;case _0x1408('0x39'):_0x3fe0d2['childModel']=_0x1408('0x3a');break;case _0x1408('0x3b'):_0x3fe0d2[_0x1408('0x13')]=_0x1408('0x3c');break;case _0x1408('0x3d'):_0x3fe0d2[_0x1408('0x13')]=_0x1408('0x3e');break;case _0x1408('0x3f'):_0x3fe0d2[_0x1408('0x13')]=_0x1408('0x40');break;case _0x1408('0x41'):_0x3fe0d2['childModel']=_0x1408('0x42');break;case _0x1408('0x43'):_0x3fe0d2[_0x1408('0x13')]=_0x1408('0x44');break;case _0x1408('0x45'):_0x3fe0d2[_0x1408('0x13')]='OpenchannelQueue';break;case _0x1408('0x46'):_0x3fe0d2[_0x1408('0x13')]=_0x1408('0x47');break;case _0x1408('0x48'):_0x3fe0d2[_0x1408('0x13')]=_0x1408('0x49');break;case _0x1408('0x4a'):_0x3fe0d2[_0x1408('0x13')]=_0x1408('0x4b');break;case _0x1408('0x4c'):_0x3fe0d2[_0x1408('0x13')]=_0x1408('0x4d');break;case _0x1408('0x4e'):_0x3fe0d2[_0x1408('0x13')]='WhatsappAccount';break;case _0x1408('0x4f'):_0x3fe0d2['childModel']=_0x1408('0x50');break;case _0x1408('0x51'):case _0x1408('0x52'):_0x3fe0d2[_0x1408('0x13')]=_0x1408('0x53');if(_0xcdf431){_0x3fe0d2[_0x1408('0x17')]=[{'name':_0x1408('0x32')},{'name':_0x1408('0x35')}];}break;case _0x1408('0x54'):case _0x1408('0x55'):case _0x1408('0x56'):_0x3fe0d2[_0x1408('0x13')]='User';if(_0xcdf431){_0x3fe0d2[_0x1408('0x17')]=[{'name':_0x1408('0x57'),'filter':{'field':'role','value':[_0x1408('0x58'),_0x1408('0x59')]},'ignore':!![]},{'name':'Agents'},{'name':_0x1408('0x5a')}];}break;case _0x1408('0x5b'):_0x3fe0d2[_0x1408('0x13')]=_0x1408('0x5c');break;case _0x1408('0x5d'):_0x3fe0d2[_0x1408('0x13')]=_0x1408('0x5e');break;case _0x1408('0x5f'):_0x3fe0d2[_0x1408('0x13')]=_0x1408('0x60');break;case _0x1408('0x61'):_0x3fe0d2[_0x1408('0x13')]=_0x1408('0x62');break;case _0x1408('0x63'):_0x3fe0d2[_0x1408('0x13')]=_0x1408('0x64');break;case _0x1408('0x65'):_0x3fe0d2[_0x1408('0x13')]=_0x1408('0x66');break;case'vtigeraccounts':_0x3fe0d2['childModel']=_0x1408('0x2e');break;case'cannedanswers':_0x3fe0d2[_0x1408('0x13')]='CannedAnswer';break;case _0x1408('0x67'):_0x3fe0d2[_0x1408('0x13')]=_0x1408('0x68');break;case'customdashboards':_0x3fe0d2['childModel']='Dashboard';break;case _0x1408('0x69'):_0x3fe0d2[_0x1408('0x13')]=_0x1408('0x6a');break;case _0x1408('0x6b'):_0x3fe0d2['childModel']=_0x1408('0x6c');break;case _0x1408('0x6d'):_0x3fe0d2['childModel']=_0x1408('0x6e');break;case _0x1408('0x6f'):_0x3fe0d2[_0x1408('0x13')]=_0x1408('0x70');break;case _0x1408('0x71'):_0x3fe0d2[_0x1408('0x13')]=_0x1408('0x72');break;case _0x1408('0x73'):_0x3fe0d2[_0x1408('0x13')]=_0x1408('0x74');break;case _0x1408('0x75'):_0x3fe0d2[_0x1408('0x13')]='Trigger';break;case _0x1408('0x76'):_0x3fe0d2['childModel']=_0x1408('0x77');break;case _0x1408('0x78'):_0x3fe0d2[_0x1408('0x13')]='Variable';break;case'plugins':_0x3fe0d2[_0x1408('0x13')]='Plugin';break;case _0x1408('0x79'):_0x3fe0d2[_0x1408('0x13')]=_0x1408('0xe');_0x3fe0d2['parentSections']=[{'name':_0x1408('0x7a'),'field':'id','foreignKey':'reportId'}];break;case'metrics':_0x3fe0d2[_0x1408('0x13')]=_0x1408('0x7b');break;}return _0x3fe0d2;}function _0x5b3669(_0x4f2865,_0x2c9034){var _0x33c6b4=_0x4f2865[_0x1408('0x7c')](0x0)[_0x1408('0x7d')]()+_0x4f2865[_0x1408('0x7e')](0x1);var _0x4949e9={'type':_0x5eeeff[_0x1408('0x7f')]['QueryTypes'][_0x1408('0x80')],'raw':!![]};return new Promise(function(_0x40301f,_0xa4f37b){var _0x67e9de=squel[_0x1408('0x81')]()['field'](_0x1408('0x82')+_0x33c6b4+_0x1408('0x83'),'id')[_0x1408('0x9')](_0x1408('0x84'))[_0x1408('0x85')](_0x1408('0x86')+_0x4f2865+_0x1408('0x87'),'ui')[_0x1408('0x88')](_0x1408('0x89'),_0x2c9034['id']);return _0x5eeeff[_0x1408('0x8a')][_0x1408('0x8b')](_0x67e9de[_0x1408('0x8c')](),_0x4949e9)['then'](function(_0x1efbbf){_0x2c9034[_0x33c6b4+_0x1408('0x8d')]=_0x1efbbf;_0x40301f(_0x1efbbf);})[_0x1408('0x8')](function(_0x1ecd82){_0xa4f37b(_0x1ecd82);});});}return _0x1a6871[_0x1408('0x8e')](_0x1408('0x8f'),attributes,{'tableName':_0x1408('0x90'),'paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x9fe199){var _0xd68e4a={'raw':_0x9fe199[_0x1408('0x8b')]['raw'],'where':{}};var _0x3ea8f1={};var _0x1997fc={'count':0x0,'rows':[]};var _0x2f8f46=_0x9fe199['query']['section'];var _0x6f839a=_0x9fe199['query'][_0x1408('0x91')]||![];var _0x26c3bb=_0x42753d(_0x2f8f46,_0x6f839a);if(!_0x26c3bb['childModel'])throw new Error(_0x1408('0x92')+_0x2f8f46+'\x27');var _0x1e0ffc=[{'name':_0x2f8f46}];if(!_[_0x1408('0x93')](_0x26c3bb[_0x1408('0x17')]))_0x1e0ffc=_0x26c3bb[_0x1408('0x17')];var _0x40f3f2=[];for(var _0x373717=0x0;_0x373717<_0x1e0ffc[_0x1408('0x94')];_0x373717++){_0x40f3f2[_0x1408('0x95')](_0x5eeeff[_0x1408('0x96')][_0x1408('0x97')]({'where':{'userProfileId':_0x9fe199[_0x1408('0x98')]['id'],'name':_0x1e0ffc[_0x373717]['name']},'raw':!![]}));}return Promise[_0x1408('0x99')](_0x40f3f2)['then'](function(_0x3843bc){var _0x35c73e=_[_0x1408('0x4')](_0x3843bc,function(_0x1c292a){return _0x1c292a?_0x1c292a:undefined;});var _0x347617=_['filter'](_0x1e0ffc,[_0x1408('0x9a'),!![]]);var _0x5848d2=_['isEmpty'](_0x35c73e)&&_['isEmpty'](_0x347617)?null:_[_0x1408('0x9b')](_0x347617,_0x35c73e);if(!_0x5848d2)return null;var _0x4a7963=[];for(var _0x272d91=0x0;_0x272d91<_0x5848d2['length'];_0x272d91++){var _0x1f5569=_['find'](_0x1e0ffc,function(_0x39bcb1){return _0x5848d2[_0x272d91]?_0x39bcb1['name']===_0x5848d2[_0x272d91][_0x1408('0xb')]:null;});if(_0x1f5569){if(_0x5848d2[_0x272d91]['ignore']){_0x4a7963[_0x1408('0x95')](_0x146239(_0x26c3bb[_0x1408('0x13')],_0x5848d2[_0x272d91]));}else{if(!_0x5848d2[_0x272d91][_0x1408('0x9c')]){_0x4a7963['push'](_0x120987(_0x1f5569,_0x5848d2[_0x272d91],_0x26c3bb['childModel']));}else{if(_0x1f5569[_0x1408('0x9d')]){_0x4a7963[_0x1408('0x95')](_0x13d881(_0x1f5569,_0x5848d2[_0x272d91]));}}}}}return Promise[_0x1408('0x99')](_0x4a7963);})[_0x1408('0x7')](function(_0xa105ab){var _0x3c9beb=_0xa105ab;var _0x1525d6=null;if(_0x3c9beb){_0x1525d6=_0x3c9beb[_0x1408('0x94')]===0x1?_0x3c9beb[0x0]:null;}if(!_0x1525d6&&!_0x3c9beb)return _0x1997fc;var _0x1b77aa=_0x5eeeff[_0x26c3bb[_0x1408('0x13')]]['rawAttributes'];_0x3ea8f1['model']=_[_0x1408('0x9e')](_0x1b77aa);_0x3ea8f1[_0x1408('0x8b')]=_[_0x1408('0x9e')](_0x9fe199['query']);_0x3ea8f1[_0x1408('0x9f')]=_['intersection'](_0x3ea8f1['model'],_0x3ea8f1[_0x1408('0x8b')]);_0xd68e4a[_0x1408('0xa0')]=_[_0x1408('0xa1')](_0x3ea8f1[_0x1408('0x9d')],qs[_0x1408('0xa2')](_0x9fe199[_0x1408('0x8b')][_0x1408('0xa2')]));_0xd68e4a[_0x1408('0xa0')]=_0xd68e4a[_0x1408('0xa0')][_0x1408('0x94')]?_0xd68e4a[_0x1408('0xa0')]:_0x3ea8f1[_0x1408('0x9d')];if(!_0x9fe199[_0x1408('0x8b')][_0x1408('0xa3')](_0x1408('0xa4'))){_0xd68e4a['limit']=qs['limit'](_0x9fe199[_0x1408('0x8b')][_0x1408('0xa5')]);_0xd68e4a[_0x1408('0xa6')]=qs[_0x1408('0xa6')](_0x9fe199[_0x1408('0x8b')][_0x1408('0xa6')]);}_0xd68e4a[_0x1408('0xa7')]=qs[_0x1408('0xa8')](_0x9fe199[_0x1408('0x8b')][_0x1408('0xa8')]);_0xd68e4a[_0x1408('0x88')]=qs['filters'](_[_0x1408('0xa9')](_0x9fe199[_0x1408('0x8b')],_0x3ea8f1[_0x1408('0x9f')]));if(_0x9fe199[_0x1408('0x8b')][_0x1408('0x4')]){_0xd68e4a['where']=_['merge'](_0xd68e4a[_0x1408('0x88')],{'$or':_[_0x1408('0xa')](_0x1b77aa,function(_0x18b449){if(_0x18b449[_0x1408('0x33')][_0x1408('0xaa')]!=='VIRTUAL'){var _0x387455={};_0x387455[_0x18b449[_0x1408('0x9')]]={'$like':'%'+_0x9fe199[_0x1408('0x8b')]['filter']+'%'};return _0x387455;}})});}var _0x34ea7d=[];var _0x402667=null;var _0x2029da={};if(_0x1525d6){_0x402667=_[_0x1408('0x97')](_0x1e0ffc,[_0x1408('0xb'),_0x1525d6[_0x1408('0xb')]]);if(_0x402667[_0x1408('0x9')]){_0x2029da={};if(_0x26c3bb[_0x1408('0x13')]===_0x1408('0xe')){_0x2029da[_0x402667[_0x1408('0xab')]]=_[_0x1408('0xa')](_0x1525d6['associatedResources'],'id');}else{_0x2029da[_0x402667[_0x1408('0xab')]]=_0x1525d6[_0x1408('0xf')];}_0x34ea7d[_0x1408('0x95')](_0x2029da);}else{_0xd68e4a[_0x1408('0x88')]['id']=_0x1525d6[_0x1408('0xf')];}}else{for(var _0x318fbb=0x0;_0x318fbb<_0x3c9beb[_0x1408('0x94')];_0x318fbb++){_0x402667=_[_0x1408('0x97')](_0x1e0ffc,[_0x1408('0xb'),_0x3c9beb[_0x318fbb][_0x1408('0xb')]]);if(_0x402667[_0x1408('0x9')]){_0x2029da={};_0x2029da[_0x402667[_0x1408('0xab')]]=_0x3c9beb[_0x318fbb][_0x1408('0xf')];_0x34ea7d[_0x1408('0x95')](_0x2029da);}else{if(!_0xd68e4a[_0x1408('0x88')]['id'])_0xd68e4a[_0x1408('0x88')]['id']=[];_0x3c9beb[_0x318fbb][_0x1408('0xf')][_0x1408('0xac')](function(_0x1eb1fa){_0xd68e4a['where']['id'][_0x1408('0x95')](_0x1eb1fa);});}}}if(!_['isEmpty'](_0x34ea7d)){_0xd68e4a[_0x1408('0x88')]=_[_0x1408('0xad')](_0xd68e4a['where'],{'$and':{'$or':_0x34ea7d}});}_0xd68e4a=_[_0x1408('0xad')]({},_0xd68e4a,_0x9fe199[_0x1408('0xae')]);if(_0x1525d6&&!_0x1525d6[_0x1408('0x9c')]&&_0x26c3bb[_0x1408('0x13')]===_0x1408('0xe')){if(_0x9fe199[_0x1408('0x8b')][_0x1408('0xaf')]){_0xd68e4a[_0x1408('0xb0')]=[{'all':!![]}];}return _0x5eeeff[_0x26c3bb[_0x1408('0x13')]][_0x1408('0x6')](_0xd68e4a)[_0x1408('0x7')](function(_0x26f4fa){var _0x399f36=[];_0x26f4fa[_0x1408('0xac')](function(_0x1474f6){var _0x34e94c;switch(_0x1474f6['reportType']){case _0x1408('0xb1'):_0x34e94c=_[_0x1408('0x97')](_0x1525d6['associatedResources'],function(_0x397266){return _0x397266['id']===_0x1474f6[_0x1408('0xb2')]&&_0x397266[_0x1408('0x33')]==='DefaultReports';});break;case _0x1408('0xb3'):_0x34e94c=_['find'](_0x1525d6['associatedResources'],function(_0x2731c4){return _0x2731c4['id']===_0x1474f6['reportId']&&_0x2731c4['type']===_0x1408('0xb4');});break;}if(_0x34e94c)_0x399f36[_0x1408('0x95')](_0x1474f6);});_0x1997fc[_0x1408('0xb5')]=_0x399f36[_0x1408('0x94')];_0x1997fc['rows']=_0x399f36;return _0x1997fc;});}else{if(!_[_0x1408('0x93')](_0x9fe199[_0x1408('0x8b')][_0x1408('0xb6')])){_0xd68e4a[_0x1408('0x88')]['id']=_0xd68e4a[_0x1408('0x88')]['id']?_[_0x1408('0xa1')](_0xd68e4a['where']['id'],_0x9fe199[_0x1408('0x8b')][_0x1408('0xb6')]):_0x9fe199[_0x1408('0x8b')][_0x1408('0xb6')];if(_0x9fe199[_0x1408('0x8b')][_0x1408('0xb7')]){_0xd68e4a[_0x1408('0xa7')]=_0x9fe199[_0x1408('0x8b')][_0x1408('0xb7')];}}if(_0x9fe199['query'][_0x1408('0xb8')]){_0xd68e4a[_0x1408('0x88')]=_['merge'](_0xd68e4a[_0x1408('0x88')],{'$and':_0x9fe199['query'][_0x1408('0xb8')]});}return _0x5eeeff[_0x26c3bb[_0x1408('0x13')]][_0x1408('0xb5')]({'where':_0xd68e4a[_0x1408('0x88')]})[_0x1408('0x7')](function(_0x4bf3a9){_0x1997fc[_0x1408('0xb5')]=_0x4bf3a9;if(_0x9fe199[_0x1408('0x8b')][_0x1408('0xaf')]){if(_0x26c3bb[_0x1408('0x13')]===_0x1408('0x1c')){_0xd68e4a[_0x1408('0xb0')]=[{'model':_0x5eeeff[_0x1408('0x72')],'as':_0x1408('0xb9'),'attributes':['id',_0x1408('0xb'),_0x1408('0xba')],'required':_0x9fe199[_0x1408('0x8b')]['tag']?!![]:![]},{'model':_0x5eeeff[_0x1408('0x72')],'as':_0x1408('0xbb'),'attributes':['id',_0x1408('0xb'),_0x1408('0xba')],'through':_0x9fe199[_0x1408('0x8b')][_0x1408('0xbc')]?{'attributes':[],'where':{'TagId':_0x9fe199[_0x1408('0x8b')]['tag']||undefined}}:{},'required':_0x9fe199[_0x1408('0x8b')][_0x1408('0xbc')]?!![]:![]}];}else{_0xd68e4a[_0x1408('0xb0')]=[{'all':!![]}];}}return _0x5eeeff[_0x26c3bb[_0x1408('0x13')]][_0x1408('0x6')](_0xd68e4a);})[_0x1408('0x7')](function(_0x50ce0a){_0x1997fc[_0x1408('0xbd')]=_0x50ce0a;if(_0x2f8f46===_0x1408('0x2c')&&_0x9fe199['query'][_0x1408('0xbe')]==='true'){var _0x5ba4e8=[];for(var _0x652e79=0x0;_0x652e79<_0x1997fc['rows'][_0x1408('0x94')];_0x652e79++){_0x5ba4e8[_0x1408('0x95')](_0x5b3669(_0x1408('0xbf'),_0x1997fc[_0x1408('0xbd')][_0x652e79][_0x1408('0xc0')]));_0x5ba4e8[_0x1408('0x95')](_0x5b3669(_0x1408('0xc1'),_0x1997fc[_0x1408('0xbd')][_0x652e79][_0x1408('0xc0')]));_0x5ba4e8[_0x1408('0x95')](_0x5b3669(_0x1408('0xc2'),_0x1997fc[_0x1408('0xbd')][_0x652e79]['dataValues']));_0x5ba4e8['push'](_0x5b3669(_0x1408('0xc3'),_0x1997fc[_0x1408('0xbd')][_0x652e79][_0x1408('0xc0')]));_0x5ba4e8[_0x1408('0x95')](_0x5b3669(_0x1408('0xc4'),_0x1997fc[_0x1408('0xbd')][_0x652e79][_0x1408('0xc0')]));_0x5ba4e8[_0x1408('0x95')](_0x5b3669(_0x1408('0xc5'),_0x1997fc[_0x1408('0xbd')][_0x652e79]['dataValues']));}return Promise[_0x1408('0x99')](_0x5ba4e8)['then'](function(){return _0x1997fc;});}return _0x1997fc;});}});}}});};