3aff372da4c69dc494103aa5f0cadd9d420c995a
[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 _0xaeef=['reportType','default','reportId','DefaultReports','custom','CustomReports','count','rows','ids','intersection','extraQueryConditions','includeAll','CmContact','Tag','Tags','color','tag','openTabs','true','chat','dataValues','sms','fax','mail','openchannel','whatsapp','./userProfile.attributes','squel','exports','models','filter','value','then','associatedResources','map','catch','model','findAll','name','UserProfileResource','field','AnalyticExtractedReport','resourceId','type','toLowerCase','squareprojects','childModel','odbc','SquareOdbc','squarerecordings','SquareRecording','parentSections','SquareProjects','projectName','projects','JscriptyProject','Lists','ListId','companies','CmCompany','globalcustomfields','CmCustomField','ChatQueue','chatwebsites','ChatWebsite','faxqueues','FaxQueue','faxaccounts','FaxAccount','inboundroutes','internalroutes','outboundroutes','voicemails','VoiceMail','voicerecordings','VoiceRecording','membername','User','role','agent','Telephones','telephone','queue','VoiceQueue','musiconholds','VoiceMusicOnHold','chanspies','VoiceChanSpy','VoicePrefix','ivrcampaigns','Campaign','mailqueues','MailQueue','MailAccount','mailsubstatuses','MailSubstatus','openchannelqueues','openchannelaccounts','OpenchannelAccount','smsqueues','SmsQueue','smsaccounts','SmsAccount','whatsappqueues','whatsappaccounts','WhatsappAccount','teams','Team','voicequeues','queuecampaigns','VoiceQueues','QueueCampaigns','agents','Users','admin','Agents','ZendeskAccount','salesforceaccounts','freshdeskaccounts','FreshdeskAccount','sugarcrmaccounts','SugarcrmAccount','DeskAccount','ZohoAccount','vtigeraccounts','cannedanswers','CannedAnswer','dispositions','Disposition','customdashboards','Dashboard','intervals','Interval','pauses','Pause','scheduler','Schedule','sounds','Sound','templates','Template','triggers','Trigger','variables','Plugin','extractedreports','metrics','AnalyticMetric','charAt','slice','Sequelize','QueryTypes','SELECT','select','InteractionId','from','user_has_','_interactions','where','ui.UserId\x20=\x20?','sequelize','query','toString','OpenTabs','define','UserProfile','user_profiles','../../components/parsers/qs','raw','mergeResources','Invalid\x20section\x20\x27','length','push','UserProfileSection','find','params','all','isEmpty','ignore','autoAssociation','rawAttributes','keys','filters','attributes','hasOwnProperty','limit','offset','pick','merge','key','VIRTUAL','foreignKey','forEach','options','include'];(function(_0x2c7618,_0x26be9c){var _0x5ce3f0=function(_0x1837b3){while(--_0x1837b3){_0x2c7618['push'](_0x2c7618['shift']());}};_0x5ce3f0(++_0x26be9c);}(_0xaeef,0xdd));var _0xfaee=function(_0x355576,_0x2f44ac){_0x355576=_0x355576-0x0;var _0x52ef48=_0xaeef[_0x355576];return _0x52ef48;};'use strict';var _=require('lodash');var attributes=require(_0xfaee('0x0'));var squel=require(_0xfaee('0x1'));module[_0xfaee('0x2')]=function(_0x32cbe6){var _0xe296d2=_0x32cbe6[_0xfaee('0x3')];function _0x10831e(_0x3f1cda,_0x3a8ee5){return new Promise(function(_0x35e53d,_0x24720f){if(!_0x3a8ee5)return _0x35e53d(null);var _0x5cc465=_0x3a8ee5['filter']?{[_0x3a8ee5[_0xfaee('0x4')]['field']]:_0x3a8ee5[_0xfaee('0x4')][_0xfaee('0x5')]}:undefined;return _0xe296d2[_0x3f1cda]['findAll']({'where':_0x5cc465,'raw':!![]})[_0xfaee('0x6')](function(_0x355491){_0x3a8ee5[_0xfaee('0x7')]=_[_0xfaee('0x8')](_0x355491,'id');_0x35e53d(_0x3a8ee5);})[_0xfaee('0x9')](function(_0x2b9cbd){_0x24720f(_0x2b9cbd);});});}function _0x2ffe04(_0x55bb57,_0x2d8b9b){return new Promise(function(_0x54dc8c,_0xcfe29){var _0x33b96e=_0x55bb57[_0xfaee('0x4')]?{[_0x55bb57[_0xfaee('0x4')]['field']]:_0x55bb57[_0xfaee('0x4')][_0xfaee('0x5')]}:undefined;return _0xe296d2[_0x55bb57[_0xfaee('0xa')]][_0xfaee('0xb')]({'where':_0x33b96e,'raw':!![]})[_0xfaee('0x6')](function(_0x48c8e6){_0x2d8b9b[_0xfaee('0x7')]=_['map'](_0x48c8e6,function(_0x378bc5){return _0x378bc5[_0xfaee('0xc')];});_0x54dc8c(_0x2d8b9b);})[_0xfaee('0x9')](function(_0xa86ab3){_0xcfe29(_0xa86ab3);});});}function _0x211bdc(_0x4dff70,_0x106f91,_0x329bab){if(!_0x106f91)return Promise['resolve'](null);return new Promise(function(_0x59e56b,_0x2e7ae1){return _0xe296d2[_0xfaee('0xd')]['findAll']({'where':{'sectionId':_0x106f91['id']},'raw':!![]})[_0xfaee('0x6')](function(_0x1dabc4){if(_0x4dff70[_0xfaee('0xe')]&&_0x4dff70[_0xfaee('0xe')]!=='id'){_0x106f91[_0xfaee('0x7')]=_['map'](_0x1dabc4,function(_0x225f61){return _0x225f61[_0x4dff70[_0xfaee('0xe')]];});}else{if(_0x329bab===_0xfaee('0xf')){_0x106f91[_0xfaee('0x7')]=_[_0xfaee('0x8')](_0x1dabc4,function(_0x224aa7){return{'id':_0x224aa7[_0xfaee('0x10')],'type':_0x224aa7[_0xfaee('0x11')]};});}else{_0x106f91[_0xfaee('0x7')]=_[_0xfaee('0x8')](_0x1dabc4,function(_0xbe7ef0){return _0xbe7ef0['resourceId'];});}}_0x59e56b(_0x106f91);})[_0xfaee('0x9')](function(_0x2b2ac0){_0x2e7ae1(_0x2b2ac0);});});}function _0x4d13c4(_0x5c8bf4,_0x107ada){var _0x5ace69={'parentSections':[]};switch(_0x5c8bf4[_0xfaee('0x12')]()){case _0xfaee('0x13'):_0x5ace69[_0xfaee('0x14')]='SquareProject';break;case _0xfaee('0x15'):_0x5ace69['childModel']=_0xfaee('0x16');break;case _0xfaee('0x17'):_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x18');_0x5ace69[_0xfaee('0x19')]=[{'name':_0xfaee('0x1a'),'field':'name','foreignKey':_0xfaee('0x1b')}];break;case _0xfaee('0x1c'):_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x1d');break;case'contacts':_0x5ace69[_0xfaee('0x14')]='CmContact';_0x5ace69[_0xfaee('0x19')]=[{'name':_0xfaee('0x1e'),'field':'id','foreignKey':_0xfaee('0x1f')}];break;case'lists':_0x5ace69[_0xfaee('0x14')]='CmList';break;case _0xfaee('0x20'):_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x21');break;case _0xfaee('0x22'):_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x23');break;case'chatqueues':_0x5ace69['childModel']=_0xfaee('0x24');break;case _0xfaee('0x25'):_0x5ace69['childModel']=_0xfaee('0x26');break;case _0xfaee('0x27'):_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x28');break;case _0xfaee('0x29'):_0x5ace69['childModel']=_0xfaee('0x2a');break;case _0xfaee('0x2b'):case _0xfaee('0x2c'):case _0xfaee('0x2d'):_0x5ace69[_0xfaee('0x14')]='VoiceExtension';break;case'contexts':_0x5ace69[_0xfaee('0x14')]='VoiceContext';break;case _0xfaee('0x2e'):_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x2f');break;case _0xfaee('0x30'):_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x31');_0x5ace69[_0xfaee('0x19')]=[{'name':'Agents','field':_0xfaee('0xc'),'foreignKey':_0xfaee('0x32'),'model':_0xfaee('0x33'),'filter':{'field':_0xfaee('0x34'),'value':[_0xfaee('0x35')]}},{'name':_0xfaee('0x36'),'field':_0xfaee('0xc'),'foreignKey':_0xfaee('0x32'),'model':'User','filter':{'field':_0xfaee('0x34'),'value':[_0xfaee('0x37')]}},{'name':'VoiceQueues','field':_0xfaee('0xc'),'foreignKey':'queue','model':'VoiceQueue','filter':{'field':_0xfaee('0x11'),'value':['inbound']}},{'name':'QueueCampaigns','field':_0xfaee('0xc'),'foreignKey':_0xfaee('0x38'),'model':_0xfaee('0x39'),'filter':{'field':'type','value':['outbound']}}];break;case _0xfaee('0x3a'):_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x3b');break;case _0xfaee('0x3c'):_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x3d');break;case'voiceprefixes':_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x3e');break;case _0xfaee('0x3f'):_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x40');break;case _0xfaee('0x41'):_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x42');break;case'mailaccounts':_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x43');break;case _0xfaee('0x44'):_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x45');break;case _0xfaee('0x46'):_0x5ace69[_0xfaee('0x14')]='OpenchannelQueue';break;case _0xfaee('0x47'):_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x48');break;case _0xfaee('0x49'):_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x4a');break;case _0xfaee('0x4b'):_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x4c');break;case _0xfaee('0x4d'):_0x5ace69[_0xfaee('0x14')]='WhatsappQueue';break;case _0xfaee('0x4e'):_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x4f');break;case _0xfaee('0x50'):_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x51');break;case _0xfaee('0x52'):case _0xfaee('0x53'):_0x5ace69[_0xfaee('0x14')]='VoiceQueue';if(_0x107ada){_0x5ace69[_0xfaee('0x19')]=[{'name':_0xfaee('0x54')},{'name':_0xfaee('0x55')}];}break;case'users':case _0xfaee('0x56'):case'telephones':_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x33');if(_0x107ada){_0x5ace69['parentSections']=[{'name':_0xfaee('0x57'),'filter':{'field':_0xfaee('0x34'),'value':[_0xfaee('0x58'),'user']},'ignore':!![]},{'name':_0xfaee('0x59')},{'name':_0xfaee('0x36')}];}break;case'zendeskaccounts':_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x5a');break;case _0xfaee('0x5b'):_0x5ace69[_0xfaee('0x14')]='SalesforceAccount';break;case _0xfaee('0x5c'):_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x5d');break;case _0xfaee('0x5e'):_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x5f');break;case'deskaccounts':_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x60');break;case'zohoaccounts':_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x61');break;case _0xfaee('0x62'):_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x33');break;case _0xfaee('0x63'):_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x64');break;case _0xfaee('0x65'):_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x66');break;case _0xfaee('0x67'):_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x68');break;case _0xfaee('0x69'):_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x6a');break;case _0xfaee('0x6b'):_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x6c');break;case _0xfaee('0x6d'):_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x6e');break;case _0xfaee('0x6f'):_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x70');break;case'tags':_0x5ace69['childModel']='Tag';break;case _0xfaee('0x71'):_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x72');break;case _0xfaee('0x73'):_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x74');break;case'trunks':_0x5ace69[_0xfaee('0x14')]='Trunk';break;case _0xfaee('0x75'):_0x5ace69[_0xfaee('0x14')]='Variable';break;case'plugins':_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x76');break;case _0xfaee('0x77'):_0x5ace69[_0xfaee('0x14')]=_0xfaee('0xf');_0x5ace69['parentSections']=[{'name':'Reports','field':'id','foreignKey':'reportId'}];break;case _0xfaee('0x78'):_0x5ace69[_0xfaee('0x14')]=_0xfaee('0x79');break;}return _0x5ace69;}function _0x2e2ef4(_0x274523,_0x1a2d55){var _0x2b8512=_0x274523[_0xfaee('0x7a')](0x0)['toUpperCase']()+_0x274523[_0xfaee('0x7b')](0x1);var _0x42cbf1={'type':_0xe296d2[_0xfaee('0x7c')][_0xfaee('0x7d')][_0xfaee('0x7e')],'raw':!![]};return new Promise(function(_0x21aaa1,_0x5c42ab){var _0x1da62f=squel[_0xfaee('0x7f')]()[_0xfaee('0xe')]('ui.'+_0x2b8512+_0xfaee('0x80'),'id')[_0xfaee('0xe')]('ui.createdAt')[_0xfaee('0x81')](_0xfaee('0x82')+_0x274523+_0xfaee('0x83'),'ui')[_0xfaee('0x84')](_0xfaee('0x85'),_0x1a2d55['id']);return _0xe296d2[_0xfaee('0x86')][_0xfaee('0x87')](_0x1da62f[_0xfaee('0x88')](),_0x42cbf1)['then'](function(_0x2706fd){_0x1a2d55[_0x2b8512+_0xfaee('0x89')]=_0x2706fd;_0x21aaa1(_0x2706fd);})['catch'](function(_0x291791){_0x5c42ab(_0x291791);});});}return _0x32cbe6[_0xfaee('0x8a')](_0xfaee('0x8b'),attributes,{'tableName':_0xfaee('0x8c'),'paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x52b92a){var _0x23f907=require(_0xfaee('0x8d'));var _0x2f6db8={'raw':_0x52b92a['query'][_0xfaee('0x8e')],'where':{}};var _0x2a382f={};var _0x2b28a2={'count':0x0,'rows':[]};var _0x2e499c=_0x52b92a[_0xfaee('0x87')]['section'];var _0x2d488e=_0x52b92a[_0xfaee('0x87')][_0xfaee('0x8f')]||![];var _0x58f84b=_0x4d13c4(_0x2e499c,_0x2d488e);if(!_0x58f84b[_0xfaee('0x14')])throw new Error(_0xfaee('0x90')+_0x2e499c+'\x27');var _0x5f328e=[{'name':_0x2e499c}];if(!_['isEmpty'](_0x58f84b[_0xfaee('0x19')]))_0x5f328e=_0x58f84b['parentSections'];var _0xadae59=[];for(var _0x10d438=0x0;_0x10d438<_0x5f328e[_0xfaee('0x91')];_0x10d438++){_0xadae59[_0xfaee('0x92')](_0xe296d2[_0xfaee('0x93')][_0xfaee('0x94')]({'where':{'userProfileId':_0x52b92a[_0xfaee('0x95')]['id'],'name':_0x5f328e[_0x10d438]['name']},'raw':!![]}));}return Promise[_0xfaee('0x96')](_0xadae59)[_0xfaee('0x6')](function(_0x2cddfe){var _0x1902a4=_['filter'](_0x2cddfe,function(_0x59a0d8){return _0x59a0d8?_0x59a0d8:undefined;});var _0x2e70d0=_[_0xfaee('0x4')](_0x5f328e,['ignore',!![]]);var _0x186f37=_['isEmpty'](_0x1902a4)&&_[_0xfaee('0x97')](_0x2e70d0)?null:_['union'](_0x2e70d0,_0x1902a4);if(!_0x186f37)return null;var _0x30db16=[];for(var _0x52177e=0x0;_0x52177e<_0x186f37[_0xfaee('0x91')];_0x52177e++){var _0xc94ce1=_['find'](_0x5f328e,function(_0x60afd5){return _0x186f37[_0x52177e]?_0x60afd5[_0xfaee('0xc')]===_0x186f37[_0x52177e]['name']:null;});if(_0xc94ce1){if(_0x186f37[_0x52177e][_0xfaee('0x98')]){_0x30db16[_0xfaee('0x92')](_0x10831e(_0x58f84b[_0xfaee('0x14')],_0x186f37[_0x52177e]));}else{if(!_0x186f37[_0x52177e][_0xfaee('0x99')]){_0x30db16[_0xfaee('0x92')](_0x211bdc(_0xc94ce1,_0x186f37[_0x52177e],_0x58f84b[_0xfaee('0x14')]));}else{if(_0xc94ce1['model']){_0x30db16[_0xfaee('0x92')](_0x2ffe04(_0xc94ce1,_0x186f37[_0x52177e]));}}}}}return Promise[_0xfaee('0x96')](_0x30db16);})[_0xfaee('0x6')](function(_0x3fb6ad){var _0x1449b7=_0x3fb6ad;var _0x4fe30c=null;if(_0x1449b7){_0x4fe30c=_0x1449b7['length']===0x1?_0x1449b7[0x0]:null;}if(!_0x4fe30c&&!_0x1449b7)return _0x2b28a2;var _0x93c1d6=_0xe296d2[_0x58f84b['childModel']][_0xfaee('0x9a')];_0x2a382f[_0xfaee('0xa')]=_[_0xfaee('0x9b')](_0x93c1d6);_0x2a382f[_0xfaee('0x87')]=_[_0xfaee('0x9b')](_0x52b92a[_0xfaee('0x87')]);_0x2a382f[_0xfaee('0x9c')]=_['intersection'](_0x2a382f[_0xfaee('0xa')],_0x2a382f['query']);_0x2f6db8[_0xfaee('0x9d')]=_['intersection'](_0x2a382f['model'],_0x23f907['fields'](_0x52b92a[_0xfaee('0x87')]['fields']));_0x2f6db8[_0xfaee('0x9d')]=_0x2f6db8[_0xfaee('0x9d')]['length']?_0x2f6db8[_0xfaee('0x9d')]:_0x2a382f[_0xfaee('0xa')];if(!_0x52b92a['query'][_0xfaee('0x9e')]('nolimit')){_0x2f6db8[_0xfaee('0x9f')]=_0x23f907[_0xfaee('0x9f')](_0x52b92a['query'][_0xfaee('0x9f')]);_0x2f6db8[_0xfaee('0xa0')]=_0x23f907[_0xfaee('0xa0')](_0x52b92a['query']['offset']);}_0x2f6db8['order']=_0x23f907['sort'](_0x52b92a[_0xfaee('0x87')]['sort']);_0x2f6db8[_0xfaee('0x84')]=_0x23f907[_0xfaee('0x9c')](_[_0xfaee('0xa1')](_0x52b92a[_0xfaee('0x87')],_0x2a382f[_0xfaee('0x9c')]));if(_0x52b92a[_0xfaee('0x87')][_0xfaee('0x4')]){_0x2f6db8[_0xfaee('0x84')]=_[_0xfaee('0xa2')](_0x2f6db8['where'],{'$or':_[_0xfaee('0x8')](_0x93c1d6,function(_0x42504f){if(_0x42504f[_0xfaee('0x11')][_0xfaee('0xa3')]!==_0xfaee('0xa4')){var _0x232fc0={};_0x232fc0[_0x42504f[_0xfaee('0xe')]]={'$like':'%'+_0x52b92a[_0xfaee('0x87')][_0xfaee('0x4')]+'%'};return _0x232fc0;}})});}var _0x310473=[];var _0x37dabf=null;var _0x1f6f5f={};if(_0x4fe30c){_0x37dabf=_[_0xfaee('0x94')](_0x5f328e,[_0xfaee('0xc'),_0x4fe30c[_0xfaee('0xc')]]);if(_0x37dabf[_0xfaee('0xe')]){_0x1f6f5f={};if(_0x58f84b[_0xfaee('0x14')]===_0xfaee('0xf')){_0x1f6f5f[_0x37dabf[_0xfaee('0xa5')]]=_[_0xfaee('0x8')](_0x4fe30c[_0xfaee('0x7')],'id');}else{_0x1f6f5f[_0x37dabf[_0xfaee('0xa5')]]=_0x4fe30c[_0xfaee('0x7')];}_0x310473['push'](_0x1f6f5f);}else{_0x2f6db8[_0xfaee('0x84')]['id']=_0x4fe30c[_0xfaee('0x7')];}}else{for(var _0x4ba6d7=0x0;_0x4ba6d7<_0x1449b7[_0xfaee('0x91')];_0x4ba6d7++){_0x37dabf=_[_0xfaee('0x94')](_0x5f328e,[_0xfaee('0xc'),_0x1449b7[_0x4ba6d7][_0xfaee('0xc')]]);if(_0x37dabf[_0xfaee('0xe')]){_0x1f6f5f={};_0x1f6f5f[_0x37dabf['foreignKey']]=_0x1449b7[_0x4ba6d7][_0xfaee('0x7')];_0x310473['push'](_0x1f6f5f);}else{if(!_0x2f6db8[_0xfaee('0x84')]['id'])_0x2f6db8['where']['id']=[];_0x1449b7[_0x4ba6d7][_0xfaee('0x7')][_0xfaee('0xa6')](function(_0x2e95bf){_0x2f6db8[_0xfaee('0x84')]['id'][_0xfaee('0x92')](_0x2e95bf);});}}}if(!_[_0xfaee('0x97')](_0x310473)){_0x2f6db8[_0xfaee('0x84')]=_['merge'](_0x2f6db8[_0xfaee('0x84')],{'$and':{'$or':_0x310473}});}_0x2f6db8=_[_0xfaee('0xa2')]({},_0x2f6db8,_0x52b92a[_0xfaee('0xa7')]);if(_0x4fe30c&&!_0x4fe30c[_0xfaee('0x99')]&&_0x58f84b[_0xfaee('0x14')]===_0xfaee('0xf')){if(_0x52b92a[_0xfaee('0x87')]['includeAll']){_0x2f6db8[_0xfaee('0xa8')]=[{'all':!![]}];}return _0xe296d2[_0x58f84b[_0xfaee('0x14')]]['findAll'](_0x2f6db8)[_0xfaee('0x6')](function(_0x2f7e98){var _0x1e45f8=[];_0x2f7e98['forEach'](function(_0x197dd4){var _0x22e067;switch(_0x197dd4[_0xfaee('0xa9')]){case _0xfaee('0xaa'):_0x22e067=_[_0xfaee('0x94')](_0x4fe30c[_0xfaee('0x7')],function(_0x362c01){return _0x362c01['id']===_0x197dd4[_0xfaee('0xab')]&&_0x362c01[_0xfaee('0x11')]===_0xfaee('0xac');});break;case _0xfaee('0xad'):_0x22e067=_[_0xfaee('0x94')](_0x4fe30c[_0xfaee('0x7')],function(_0x2a801d){return _0x2a801d['id']===_0x197dd4['reportId']&&_0x2a801d[_0xfaee('0x11')]===_0xfaee('0xae');});break;}if(_0x22e067)_0x1e45f8[_0xfaee('0x92')](_0x197dd4);});_0x2b28a2[_0xfaee('0xaf')]=_0x1e45f8['length'];_0x2b28a2[_0xfaee('0xb0')]=_0x1e45f8;return _0x2b28a2;});}else{if(!_[_0xfaee('0x97')](_0x52b92a[_0xfaee('0x87')][_0xfaee('0xb1')])){_0x2f6db8[_0xfaee('0x84')]['id']=_0x2f6db8[_0xfaee('0x84')]['id']?_[_0xfaee('0xb2')](_0x2f6db8[_0xfaee('0x84')]['id'],_0x52b92a[_0xfaee('0x87')][_0xfaee('0xb1')]):_0x52b92a[_0xfaee('0x87')]['ids'];if(_0x52b92a[_0xfaee('0x87')]['customSorting']){_0x2f6db8['order']=_0x52b92a[_0xfaee('0x87')]['customSorting'];}}if(_0x52b92a[_0xfaee('0x87')][_0xfaee('0xb3')]){_0x2f6db8[_0xfaee('0x84')]=_[_0xfaee('0xa2')](_0x2f6db8[_0xfaee('0x84')],{'$and':_0x52b92a[_0xfaee('0x87')][_0xfaee('0xb3')]});}return _0xe296d2[_0x58f84b[_0xfaee('0x14')]]['count']({'where':_0x2f6db8[_0xfaee('0x84')]})[_0xfaee('0x6')](function(_0x154089){_0x2b28a2['count']=_0x154089;if(_0x52b92a[_0xfaee('0x87')][_0xfaee('0xb4')]){if(_0x58f84b[_0xfaee('0x14')]===_0xfaee('0xb5')){_0x2f6db8[_0xfaee('0xa8')]=[{'model':_0xe296d2[_0xfaee('0xb6')],'as':_0xfaee('0xb7'),'attributes':['id',_0xfaee('0xc'),_0xfaee('0xb8')],'required':_0x52b92a[_0xfaee('0x87')][_0xfaee('0xb9')]?!![]:![]},{'model':_0xe296d2[_0xfaee('0xb6')],'as':'ThroughTags','attributes':['id',_0xfaee('0xc'),'color'],'through':_0x52b92a[_0xfaee('0x87')][_0xfaee('0xb9')]?{'attributes':[],'where':{'TagId':_0x52b92a[_0xfaee('0x87')][_0xfaee('0xb9')]||undefined}}:{},'required':_0x52b92a[_0xfaee('0x87')]['tag']?!![]:![]}];}else{_0x2f6db8[_0xfaee('0xa8')]=[{'all':!![]}];}}return _0xe296d2[_0x58f84b[_0xfaee('0x14')]]['findAll'](_0x2f6db8);})[_0xfaee('0x6')](function(_0x1b4066){_0x2b28a2[_0xfaee('0xb0')]=_0x1b4066;if(_0x2e499c===_0xfaee('0x59')&&_0x52b92a[_0xfaee('0x87')][_0xfaee('0xba')]===_0xfaee('0xbb')){var _0x521c20=[];for(var _0x36a796=0x0;_0x36a796<_0x2b28a2[_0xfaee('0xb0')][_0xfaee('0x91')];_0x36a796++){_0x521c20[_0xfaee('0x92')](_0x2e2ef4(_0xfaee('0xbc'),_0x2b28a2[_0xfaee('0xb0')][_0x36a796][_0xfaee('0xbd')]));_0x521c20['push'](_0x2e2ef4(_0xfaee('0xbe'),_0x2b28a2[_0xfaee('0xb0')][_0x36a796][_0xfaee('0xbd')]));_0x521c20[_0xfaee('0x92')](_0x2e2ef4(_0xfaee('0xbf'),_0x2b28a2[_0xfaee('0xb0')][_0x36a796][_0xfaee('0xbd')]));_0x521c20[_0xfaee('0x92')](_0x2e2ef4(_0xfaee('0xc0'),_0x2b28a2[_0xfaee('0xb0')][_0x36a796][_0xfaee('0xbd')]));_0x521c20[_0xfaee('0x92')](_0x2e2ef4(_0xfaee('0xc1'),_0x2b28a2[_0xfaee('0xb0')][_0x36a796]['dataValues']));_0x521c20[_0xfaee('0x92')](_0x2e2ef4(_0xfaee('0xc2'),_0x2b28a2[_0xfaee('0xb0')][_0x36a796]['dataValues']));}return Promise[_0xfaee('0x96')](_0x521c20)[_0xfaee('0x6')](function(){return _0x2b28a2;});}return _0x2b28a2;});}});}}});};