c58e600b50600a55cce4fdc06f420e72f43d780f
[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 _0xfa14=['fax','mail','openchannel','whatsapp','lodash','./userProfile.attributes','squel','exports','models','filter','field','value','findAll','associatedResources','map','catch','model','name','UserProfileResource','then','AnalyticExtractedReport','resourceId','type','toLowerCase','squareprojects','childModel','SquareProject','SquareOdbc','squarerecordings','parentSections','SquareProjects','projectName','projects','JscriptyProject','contacts','CmContact','Lists','lists','companies','CmCompany','chatqueues','ChatQueue','chatwebsites','ChatWebsite','faxqueues','faxaccounts','FaxAccount','internalroutes','outboundroutes','VoiceExtension','VoiceContext','voicemails','VoiceMail','voicerecordings','VoiceRecording','Agents','membername','role','agent','Telephones','User','telephone','VoiceQueues','queue','VoiceQueue','inbound','QueueCampaigns','outbound','musiconholds','VoiceMusicOnHold','chanspies','VoiceChanSpy','ivrcampaigns','Campaign','mailqueues','mailaccounts','MailAccount','MailSubstatus','openchannelqueues','openchannelaccounts','smsqueues','SmsQueue','smsaccounts','SmsAccount','whatsappqueues','WhatsappQueue','WhatsappAccount','teams','Team','queuecampaigns','users','agents','telephones','Users','user','ZendeskAccount','salesforceaccounts','SalesforceAccount','sugarcrmaccounts','SugarcrmAccount','DeskAccount','zohoaccounts','ZohoAccount','CannedAnswer','Disposition','customdashboards','Dashboard','pauses','Pause','scheduler','Schedule','sounds','Sound','tags','Tag','Template','triggers','Trigger','trunks','variables','Variable','plugins','Plugin','Reports','metrics','AnalyticMetric','toUpperCase','slice','Sequelize','select','InteractionId','ui.createdAt','user_has_','where','ui.UserId\x20=\x20?','sequelize','query','toString','OpenTabs','define','UserProfile','raw','section','mergeResources','Invalid\x20section\x20\x27','length','push','UserProfileSection','find','params','all','ignore','isEmpty','union','rawAttributes','keys','filters','attributes','fields','hasOwnProperty','nolimit','limit','offset','order','sort','merge','VIRTUAL','foreignKey','options','autoAssociation','includeAll','include','forEach','reportType','default','DefaultReports','custom','reportId','CustomReports','count','Tags','color','tag','ThroughTags','openTabs','true','rows','chat','dataValues','sms'];(function(_0x21120f,_0x52c21a){var _0x2e4b1c=function(_0x2e17da){while(--_0x2e17da){_0x21120f['push'](_0x21120f['shift']());}};_0x2e4b1c(++_0x52c21a);}(_0xfa14,0xc2));var _0x4fa1=function(_0x12fc36,_0x6530d3){_0x12fc36=_0x12fc36-0x0;var _0x55c667=_0xfa14[_0x12fc36];return _0x55c667;};'use strict';var _=require(_0x4fa1('0x0'));var attributes=require(_0x4fa1('0x1'));var qs=require('../../components/parsers/qs');var squel=require(_0x4fa1('0x2'));module[_0x4fa1('0x3')]=function(_0x44c59f){var _0x40944e=_0x44c59f[_0x4fa1('0x4')];function _0x4a1cba(_0x15244d,_0x5dbd96){return new Promise(function(_0x417b8a,_0x2805c7){if(!_0x5dbd96)return _0x417b8a(null);var _0x247cdc=_0x5dbd96['filter']?{[_0x5dbd96[_0x4fa1('0x5')][_0x4fa1('0x6')]]:_0x5dbd96[_0x4fa1('0x5')][_0x4fa1('0x7')]}:undefined;return _0x40944e[_0x15244d][_0x4fa1('0x8')]({'where':_0x247cdc,'raw':!![]})['then'](function(_0x2dd221){_0x5dbd96[_0x4fa1('0x9')]=_[_0x4fa1('0xa')](_0x2dd221,'id');_0x417b8a(_0x5dbd96);})[_0x4fa1('0xb')](function(_0x17eaae){_0x2805c7(_0x17eaae);});});}function _0x23c82f(_0x5edc06,_0x2630e0){return new Promise(function(_0x8dc774,_0x57127c){var _0x33f483=_0x5edc06[_0x4fa1('0x5')]?{[_0x5edc06[_0x4fa1('0x5')][_0x4fa1('0x6')]]:_0x5edc06[_0x4fa1('0x5')][_0x4fa1('0x7')]}:undefined;return _0x40944e[_0x5edc06[_0x4fa1('0xc')]][_0x4fa1('0x8')]({'where':_0x33f483,'raw':!![]})['then'](function(_0x4ce299){_0x2630e0[_0x4fa1('0x9')]=_[_0x4fa1('0xa')](_0x4ce299,function(_0x4e4a77){return _0x4e4a77[_0x4fa1('0xd')];});_0x8dc774(_0x2630e0);})[_0x4fa1('0xb')](function(_0x105759){_0x57127c(_0x105759);});});}function _0x37a686(_0xfcca30,_0x5b2b7a,_0xe9da5b){if(!_0x5b2b7a)return Promise['resolve'](null);return new Promise(function(_0x3fd66e,_0x39da36){return _0x40944e[_0x4fa1('0xe')][_0x4fa1('0x8')]({'where':{'sectionId':_0x5b2b7a['id']},'raw':!![]})[_0x4fa1('0xf')](function(_0x12dcdc){if(_0xfcca30['field']&&_0xfcca30[_0x4fa1('0x6')]!=='id'){_0x5b2b7a[_0x4fa1('0x9')]=_[_0x4fa1('0xa')](_0x12dcdc,function(_0xc64d8b){return _0xc64d8b[_0xfcca30['field']];});}else{if(_0xe9da5b===_0x4fa1('0x10')){_0x5b2b7a[_0x4fa1('0x9')]=_[_0x4fa1('0xa')](_0x12dcdc,function(_0x1c09f6){return{'id':_0x1c09f6[_0x4fa1('0x11')],'type':_0x1c09f6[_0x4fa1('0x12')]};});}else{_0x5b2b7a[_0x4fa1('0x9')]=_[_0x4fa1('0xa')](_0x12dcdc,function(_0x11cfe8){return _0x11cfe8['resourceId'];});}}_0x3fd66e(_0x5b2b7a);})['catch'](function(_0x3e2be1){_0x39da36(_0x3e2be1);});});}function _0xe8c219(_0x5de90c,_0x116329){var _0x56e073={'parentSections':[]};switch(_0x5de90c[_0x4fa1('0x13')]()){case _0x4fa1('0x14'):_0x56e073[_0x4fa1('0x15')]=_0x4fa1('0x16');break;case'odbc':_0x56e073[_0x4fa1('0x15')]=_0x4fa1('0x17');break;case _0x4fa1('0x18'):_0x56e073[_0x4fa1('0x15')]='SquareRecording';_0x56e073[_0x4fa1('0x19')]=[{'name':_0x4fa1('0x1a'),'field':_0x4fa1('0xd'),'foreignKey':_0x4fa1('0x1b')}];break;case _0x4fa1('0x1c'):_0x56e073[_0x4fa1('0x15')]=_0x4fa1('0x1d');break;case _0x4fa1('0x1e'):_0x56e073['childModel']=_0x4fa1('0x1f');_0x56e073[_0x4fa1('0x19')]=[{'name':_0x4fa1('0x20'),'field':'id','foreignKey':'ListId'}];break;case _0x4fa1('0x21'):_0x56e073[_0x4fa1('0x15')]='CmList';break;case _0x4fa1('0x22'):_0x56e073[_0x4fa1('0x15')]=_0x4fa1('0x23');break;case'globalcustomfields':_0x56e073[_0x4fa1('0x15')]='CmCustomField';break;case _0x4fa1('0x24'):_0x56e073['childModel']=_0x4fa1('0x25');break;case _0x4fa1('0x26'):_0x56e073['childModel']=_0x4fa1('0x27');break;case _0x4fa1('0x28'):_0x56e073[_0x4fa1('0x15')]='FaxQueue';break;case _0x4fa1('0x29'):_0x56e073[_0x4fa1('0x15')]=_0x4fa1('0x2a');break;case'inboundroutes':case _0x4fa1('0x2b'):case _0x4fa1('0x2c'):_0x56e073[_0x4fa1('0x15')]=_0x4fa1('0x2d');break;case'contexts':_0x56e073[_0x4fa1('0x15')]=_0x4fa1('0x2e');break;case _0x4fa1('0x2f'):_0x56e073[_0x4fa1('0x15')]=_0x4fa1('0x30');break;case _0x4fa1('0x31'):_0x56e073[_0x4fa1('0x15')]=_0x4fa1('0x32');_0x56e073['parentSections']=[{'name':_0x4fa1('0x33'),'field':_0x4fa1('0xd'),'foreignKey':_0x4fa1('0x34'),'model':'User','filter':{'field':_0x4fa1('0x35'),'value':[_0x4fa1('0x36')]}},{'name':_0x4fa1('0x37'),'field':_0x4fa1('0xd'),'foreignKey':_0x4fa1('0x34'),'model':_0x4fa1('0x38'),'filter':{'field':_0x4fa1('0x35'),'value':[_0x4fa1('0x39')]}},{'name':_0x4fa1('0x3a'),'field':'name','foreignKey':_0x4fa1('0x3b'),'model':_0x4fa1('0x3c'),'filter':{'field':'type','value':[_0x4fa1('0x3d')]}},{'name':_0x4fa1('0x3e'),'field':_0x4fa1('0xd'),'foreignKey':_0x4fa1('0x3b'),'model':'VoiceQueue','filter':{'field':'type','value':[_0x4fa1('0x3f')]}}];break;case _0x4fa1('0x40'):_0x56e073[_0x4fa1('0x15')]=_0x4fa1('0x41');break;case _0x4fa1('0x42'):_0x56e073[_0x4fa1('0x15')]=_0x4fa1('0x43');break;case'voiceprefixes':_0x56e073[_0x4fa1('0x15')]='VoicePrefix';break;case _0x4fa1('0x44'):_0x56e073[_0x4fa1('0x15')]=_0x4fa1('0x45');break;case _0x4fa1('0x46'):_0x56e073[_0x4fa1('0x15')]='MailQueue';break;case _0x4fa1('0x47'):_0x56e073['childModel']=_0x4fa1('0x48');break;case'mailsubstatuses':_0x56e073[_0x4fa1('0x15')]=_0x4fa1('0x49');break;case _0x4fa1('0x4a'):_0x56e073[_0x4fa1('0x15')]='OpenchannelQueue';break;case _0x4fa1('0x4b'):_0x56e073['childModel']='OpenchannelAccount';break;case _0x4fa1('0x4c'):_0x56e073['childModel']=_0x4fa1('0x4d');break;case _0x4fa1('0x4e'):_0x56e073[_0x4fa1('0x15')]=_0x4fa1('0x4f');break;case _0x4fa1('0x50'):_0x56e073['childModel']=_0x4fa1('0x51');break;case'whatsappaccounts':_0x56e073[_0x4fa1('0x15')]=_0x4fa1('0x52');break;case _0x4fa1('0x53'):_0x56e073[_0x4fa1('0x15')]=_0x4fa1('0x54');break;case'voicequeues':case _0x4fa1('0x55'):_0x56e073[_0x4fa1('0x15')]=_0x4fa1('0x3c');if(_0x116329){_0x56e073['parentSections']=[{'name':_0x4fa1('0x3a')},{'name':_0x4fa1('0x3e')}];}break;case _0x4fa1('0x56'):case _0x4fa1('0x57'):case _0x4fa1('0x58'):_0x56e073['childModel']=_0x4fa1('0x38');if(_0x116329){_0x56e073['parentSections']=[{'name':_0x4fa1('0x59'),'filter':{'field':_0x4fa1('0x35'),'value':['admin',_0x4fa1('0x5a')]},'ignore':!![]},{'name':_0x4fa1('0x33')},{'name':_0x4fa1('0x37')}];}break;case'zendeskaccounts':_0x56e073[_0x4fa1('0x15')]=_0x4fa1('0x5b');break;case _0x4fa1('0x5c'):_0x56e073[_0x4fa1('0x15')]=_0x4fa1('0x5d');break;case'freshdeskaccounts':_0x56e073[_0x4fa1('0x15')]='FreshdeskAccount';break;case _0x4fa1('0x5e'):_0x56e073[_0x4fa1('0x15')]=_0x4fa1('0x5f');break;case'deskaccounts':_0x56e073[_0x4fa1('0x15')]=_0x4fa1('0x60');break;case _0x4fa1('0x61'):_0x56e073['childModel']=_0x4fa1('0x62');break;case'vtigeraccounts':_0x56e073['childModel']=_0x4fa1('0x38');break;case'cannedanswers':_0x56e073[_0x4fa1('0x15')]=_0x4fa1('0x63');break;case'dispositions':_0x56e073[_0x4fa1('0x15')]=_0x4fa1('0x64');break;case _0x4fa1('0x65'):_0x56e073[_0x4fa1('0x15')]=_0x4fa1('0x66');break;case'intervals':_0x56e073[_0x4fa1('0x15')]='Interval';break;case _0x4fa1('0x67'):_0x56e073[_0x4fa1('0x15')]=_0x4fa1('0x68');break;case _0x4fa1('0x69'):_0x56e073[_0x4fa1('0x15')]=_0x4fa1('0x6a');break;case _0x4fa1('0x6b'):_0x56e073[_0x4fa1('0x15')]=_0x4fa1('0x6c');break;case _0x4fa1('0x6d'):_0x56e073['childModel']=_0x4fa1('0x6e');break;case'templates':_0x56e073['childModel']=_0x4fa1('0x6f');break;case _0x4fa1('0x70'):_0x56e073[_0x4fa1('0x15')]=_0x4fa1('0x71');break;case _0x4fa1('0x72'):_0x56e073['childModel']='Trunk';break;case _0x4fa1('0x73'):_0x56e073[_0x4fa1('0x15')]=_0x4fa1('0x74');break;case _0x4fa1('0x75'):_0x56e073[_0x4fa1('0x15')]=_0x4fa1('0x76');break;case'extractedreports':_0x56e073['childModel']='AnalyticExtractedReport';_0x56e073[_0x4fa1('0x19')]=[{'name':_0x4fa1('0x77'),'field':'id','foreignKey':'reportId'}];break;case _0x4fa1('0x78'):_0x56e073[_0x4fa1('0x15')]=_0x4fa1('0x79');break;}return _0x56e073;}function _0xa3871b(_0x2bc7c8,_0x529ea0){var _0x37a4f6=_0x2bc7c8['charAt'](0x0)[_0x4fa1('0x7a')]()+_0x2bc7c8[_0x4fa1('0x7b')](0x1);var _0x26f088={'type':_0x40944e[_0x4fa1('0x7c')]['QueryTypes']['SELECT'],'raw':!![]};return new Promise(function(_0x99c682,_0x11acf8){var _0x49bc22=squel[_0x4fa1('0x7d')]()[_0x4fa1('0x6')]('ui.'+_0x37a4f6+_0x4fa1('0x7e'),'id')['field'](_0x4fa1('0x7f'))['from'](_0x4fa1('0x80')+_0x2bc7c8+'_interactions','ui')[_0x4fa1('0x81')](_0x4fa1('0x82'),_0x529ea0['id']);return _0x40944e[_0x4fa1('0x83')][_0x4fa1('0x84')](_0x49bc22[_0x4fa1('0x85')](),_0x26f088)['then'](function(_0x3ae83b){_0x529ea0[_0x37a4f6+_0x4fa1('0x86')]=_0x3ae83b;_0x99c682(_0x3ae83b);})[_0x4fa1('0xb')](function(_0xb5dba0){_0x11acf8(_0xb5dba0);});});}return _0x44c59f[_0x4fa1('0x87')](_0x4fa1('0x88'),attributes,{'tableName':'user_profiles','paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x591ec3){var _0x58d9a8={'raw':_0x591ec3[_0x4fa1('0x84')][_0x4fa1('0x89')],'where':{}};var _0x237415={};var _0x1fc6d6={'count':0x0,'rows':[]};var _0x2f48e5=_0x591ec3[_0x4fa1('0x84')][_0x4fa1('0x8a')];var _0x28752b=_0x591ec3[_0x4fa1('0x84')][_0x4fa1('0x8b')]||![];var _0x38221f=_0xe8c219(_0x2f48e5,_0x28752b);if(!_0x38221f[_0x4fa1('0x15')])throw new Error(_0x4fa1('0x8c')+_0x2f48e5+'\x27');var _0x5e2e67=[{'name':_0x2f48e5}];if(!_['isEmpty'](_0x38221f[_0x4fa1('0x19')]))_0x5e2e67=_0x38221f[_0x4fa1('0x19')];var _0x17abd5=[];for(var _0x5a1564=0x0;_0x5a1564<_0x5e2e67[_0x4fa1('0x8d')];_0x5a1564++){_0x17abd5[_0x4fa1('0x8e')](_0x40944e[_0x4fa1('0x8f')][_0x4fa1('0x90')]({'where':{'userProfileId':_0x591ec3[_0x4fa1('0x91')]['id'],'name':_0x5e2e67[_0x5a1564][_0x4fa1('0xd')]},'raw':!![]}));}return Promise[_0x4fa1('0x92')](_0x17abd5)['then'](function(_0x3ca499){var _0x896f56=_[_0x4fa1('0x5')](_0x3ca499,function(_0x1ac5c1){return _0x1ac5c1?_0x1ac5c1:undefined;});var _0x3e673e=_[_0x4fa1('0x5')](_0x5e2e67,[_0x4fa1('0x93'),!![]]);var _0x3e93f1=_['isEmpty'](_0x896f56)&&_[_0x4fa1('0x94')](_0x3e673e)?null:_[_0x4fa1('0x95')](_0x3e673e,_0x896f56);if(!_0x3e93f1)return null;var _0x1b44fa=[];for(var _0x39e315=0x0;_0x39e315<_0x3e93f1[_0x4fa1('0x8d')];_0x39e315++){var _0x255374=_[_0x4fa1('0x90')](_0x5e2e67,function(_0x2e54f7){return _0x3e93f1[_0x39e315]?_0x2e54f7[_0x4fa1('0xd')]===_0x3e93f1[_0x39e315][_0x4fa1('0xd')]:null;});if(_0x255374){if(_0x3e93f1[_0x39e315][_0x4fa1('0x93')]){_0x1b44fa[_0x4fa1('0x8e')](_0x4a1cba(_0x38221f[_0x4fa1('0x15')],_0x3e93f1[_0x39e315]));}else{if(!_0x3e93f1[_0x39e315]['autoAssociation']){_0x1b44fa[_0x4fa1('0x8e')](_0x37a686(_0x255374,_0x3e93f1[_0x39e315],_0x38221f['childModel']));}else{if(_0x255374['model']){_0x1b44fa['push'](_0x23c82f(_0x255374,_0x3e93f1[_0x39e315]));}}}}}return Promise[_0x4fa1('0x92')](_0x1b44fa);})[_0x4fa1('0xf')](function(_0x25170f){var _0x5d48b2=_0x25170f;var _0x3433e5=null;if(_0x5d48b2){_0x3433e5=_0x5d48b2[_0x4fa1('0x8d')]===0x1?_0x5d48b2[0x0]:null;}if(!_0x3433e5&&!_0x5d48b2)return _0x1fc6d6;var _0x373dd8=_0x40944e[_0x38221f[_0x4fa1('0x15')]][_0x4fa1('0x96')];_0x237415[_0x4fa1('0xc')]=_[_0x4fa1('0x97')](_0x373dd8);_0x237415[_0x4fa1('0x84')]=_[_0x4fa1('0x97')](_0x591ec3[_0x4fa1('0x84')]);_0x237415[_0x4fa1('0x98')]=_['intersection'](_0x237415[_0x4fa1('0xc')],_0x237415[_0x4fa1('0x84')]);_0x58d9a8[_0x4fa1('0x99')]=_['intersection'](_0x237415[_0x4fa1('0xc')],qs[_0x4fa1('0x9a')](_0x591ec3[_0x4fa1('0x84')][_0x4fa1('0x9a')]));_0x58d9a8[_0x4fa1('0x99')]=_0x58d9a8[_0x4fa1('0x99')]['length']?_0x58d9a8['attributes']:_0x237415[_0x4fa1('0xc')];if(!_0x591ec3['query'][_0x4fa1('0x9b')](_0x4fa1('0x9c'))){_0x58d9a8['limit']=qs[_0x4fa1('0x9d')](_0x591ec3['query'][_0x4fa1('0x9d')]);_0x58d9a8[_0x4fa1('0x9e')]=qs['offset'](_0x591ec3[_0x4fa1('0x84')][_0x4fa1('0x9e')]);}_0x58d9a8[_0x4fa1('0x9f')]=qs[_0x4fa1('0xa0')](_0x591ec3[_0x4fa1('0x84')][_0x4fa1('0xa0')]);_0x58d9a8[_0x4fa1('0x81')]=qs[_0x4fa1('0x98')](_['pick'](_0x591ec3[_0x4fa1('0x84')],_0x237415[_0x4fa1('0x98')]));if(_0x591ec3[_0x4fa1('0x84')][_0x4fa1('0x5')]){_0x58d9a8['where']=_[_0x4fa1('0xa1')](_0x58d9a8[_0x4fa1('0x81')],{'$or':_[_0x4fa1('0xa')](_0x373dd8,function(_0x5c1e8d){if(_0x5c1e8d['type']['key']!==_0x4fa1('0xa2')){var _0x16e99a={};_0x16e99a[_0x5c1e8d[_0x4fa1('0x6')]]={'$like':'%'+_0x591ec3[_0x4fa1('0x84')][_0x4fa1('0x5')]+'%'};return _0x16e99a;}})});}var _0xfa4e5d=[];var _0x3ebdbb=null;var _0x4587d7={};if(_0x3433e5){_0x3ebdbb=_[_0x4fa1('0x90')](_0x5e2e67,[_0x4fa1('0xd'),_0x3433e5[_0x4fa1('0xd')]]);if(_0x3ebdbb[_0x4fa1('0x6')]){_0x4587d7={};if(_0x38221f['childModel']===_0x4fa1('0x10')){_0x4587d7[_0x3ebdbb['foreignKey']]=_['map'](_0x3433e5['associatedResources'],'id');}else{_0x4587d7[_0x3ebdbb[_0x4fa1('0xa3')]]=_0x3433e5['associatedResources'];}_0xfa4e5d[_0x4fa1('0x8e')](_0x4587d7);}else{_0x58d9a8[_0x4fa1('0x81')]['id']=_0x3433e5[_0x4fa1('0x9')];}}else{for(var _0x5e3fae=0x0;_0x5e3fae<_0x5d48b2[_0x4fa1('0x8d')];_0x5e3fae++){_0x3ebdbb=_[_0x4fa1('0x90')](_0x5e2e67,[_0x4fa1('0xd'),_0x5d48b2[_0x5e3fae][_0x4fa1('0xd')]]);if(_0x3ebdbb[_0x4fa1('0x6')]){_0x4587d7={};_0x4587d7[_0x3ebdbb[_0x4fa1('0xa3')]]=_0x5d48b2[_0x5e3fae]['associatedResources'];_0xfa4e5d[_0x4fa1('0x8e')](_0x4587d7);}else{if(!_0x58d9a8[_0x4fa1('0x81')]['id'])_0x58d9a8[_0x4fa1('0x81')]['id']=[];_0x5d48b2[_0x5e3fae]['associatedResources']['forEach'](function(_0xac1105){_0x58d9a8[_0x4fa1('0x81')]['id'][_0x4fa1('0x8e')](_0xac1105);});}}}if(!_['isEmpty'](_0xfa4e5d)){_0x58d9a8[_0x4fa1('0x81')]=_[_0x4fa1('0xa1')](_0x58d9a8['where'],{'$and':{'$or':_0xfa4e5d}});}_0x58d9a8=_['merge']({},_0x58d9a8,_0x591ec3[_0x4fa1('0xa4')]);if(_0x3433e5&&!_0x3433e5[_0x4fa1('0xa5')]&&_0x38221f[_0x4fa1('0x15')]==='AnalyticExtractedReport'){if(_0x591ec3[_0x4fa1('0x84')][_0x4fa1('0xa6')]){_0x58d9a8[_0x4fa1('0xa7')]=[{'all':!![]}];}return _0x40944e[_0x38221f['childModel']][_0x4fa1('0x8')](_0x58d9a8)['then'](function(_0x2ae59a){var _0x98d54=[];_0x2ae59a[_0x4fa1('0xa8')](function(_0xaf6980){var _0x512f5d;switch(_0xaf6980[_0x4fa1('0xa9')]){case _0x4fa1('0xaa'):_0x512f5d=_[_0x4fa1('0x90')](_0x3433e5[_0x4fa1('0x9')],function(_0x30374d){return _0x30374d['id']===_0xaf6980['reportId']&&_0x30374d[_0x4fa1('0x12')]===_0x4fa1('0xab');});break;case _0x4fa1('0xac'):_0x512f5d=_[_0x4fa1('0x90')](_0x3433e5[_0x4fa1('0x9')],function(_0x59da4e){return _0x59da4e['id']===_0xaf6980[_0x4fa1('0xad')]&&_0x59da4e[_0x4fa1('0x12')]===_0x4fa1('0xae');});break;}if(_0x512f5d)_0x98d54[_0x4fa1('0x8e')](_0xaf6980);});_0x1fc6d6[_0x4fa1('0xaf')]=_0x98d54['length'];_0x1fc6d6['rows']=_0x98d54;return _0x1fc6d6;});}else{return _0x40944e[_0x38221f['childModel']][_0x4fa1('0xaf')]({'where':_0x58d9a8[_0x4fa1('0x81')]})['then'](function(_0x57fd1c){_0x1fc6d6[_0x4fa1('0xaf')]=_0x57fd1c;if(_0x591ec3[_0x4fa1('0x84')][_0x4fa1('0xa6')]){if(_0x38221f[_0x4fa1('0x15')]===_0x4fa1('0x1f')){_0x58d9a8[_0x4fa1('0xa7')]=[{'model':_0x40944e['Tag'],'as':_0x4fa1('0xb0'),'attributes':['id',_0x4fa1('0xd'),_0x4fa1('0xb1')],'required':_0x591ec3[_0x4fa1('0x84')][_0x4fa1('0xb2')]?!![]:![]},{'model':_0x40944e[_0x4fa1('0x6e')],'as':_0x4fa1('0xb3'),'attributes':['id',_0x4fa1('0xd'),_0x4fa1('0xb1')],'through':_0x591ec3['query'][_0x4fa1('0xb2')]?{'attributes':[],'where':{'TagId':_0x591ec3[_0x4fa1('0x84')][_0x4fa1('0xb2')]||undefined}}:{},'required':_0x591ec3[_0x4fa1('0x84')][_0x4fa1('0xb2')]?!![]:![]}];}else{_0x58d9a8[_0x4fa1('0xa7')]=[{'all':!![]}];}}return _0x40944e[_0x38221f[_0x4fa1('0x15')]]['findAll'](_0x58d9a8);})[_0x4fa1('0xf')](function(_0x2c88d2){_0x1fc6d6['rows']=_0x2c88d2;if(_0x2f48e5===_0x4fa1('0x33')&&_0x591ec3['query'][_0x4fa1('0xb4')]===_0x4fa1('0xb5')){var _0x16339c=[];for(var _0x2afe77=0x0;_0x2afe77<_0x1fc6d6[_0x4fa1('0xb6')][_0x4fa1('0x8d')];_0x2afe77++){_0x16339c['push'](_0xa3871b(_0x4fa1('0xb7'),_0x1fc6d6['rows'][_0x2afe77][_0x4fa1('0xb8')]));_0x16339c[_0x4fa1('0x8e')](_0xa3871b(_0x4fa1('0xb9'),_0x1fc6d6[_0x4fa1('0xb6')][_0x2afe77]['dataValues']));_0x16339c['push'](_0xa3871b(_0x4fa1('0xba'),_0x1fc6d6[_0x4fa1('0xb6')][_0x2afe77][_0x4fa1('0xb8')]));_0x16339c[_0x4fa1('0x8e')](_0xa3871b(_0x4fa1('0xbb'),_0x1fc6d6['rows'][_0x2afe77][_0x4fa1('0xb8')]));_0x16339c['push'](_0xa3871b(_0x4fa1('0xbc'),_0x1fc6d6[_0x4fa1('0xb6')][_0x2afe77]['dataValues']));_0x16339c[_0x4fa1('0x8e')](_0xa3871b(_0x4fa1('0xbd'),_0x1fc6d6[_0x4fa1('0xb6')][_0x2afe77]['dataValues']));}return Promise[_0x4fa1('0x92')](_0x16339c)[_0x4fa1('0xf')](function(){return _0x1fc6d6;});}return _0x1fc6d6;});}});}}});};