254bdbd60f876e65412f50639e4cf39396f57641
[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 _0x22ab=['mailaccounts','MailAccount','mailsubstatuses','openchannelqueues','OpenchannelQueue','SmsQueue','SmsAccount','whatsappqueues','WhatsappAccount','Team','voicequeues','queuecampaigns','users','agents','telephones','admin','Telephones','salesforceaccounts','SalesforceAccount','freshdeskaccounts','FreshdeskAccount','sugarcrmaccounts','SugarcrmAccount','deskaccounts','DeskAccount','zohoaccounts','vtigeraccounts','cannedanswers','CannedAnswer','dispositions','Disposition','customdashboards','Dashboard','intervals','Interval','Pause','scheduler','sounds','Sound','Tag','templates','Template','triggers','Trigger','trunks','variables','Variable','plugins','Plugin','extractedreports','AnalyticExtractedReport','metrics','whatsappaccounts','charAt','toUpperCase','slice','QueryTypes','SELECT','InteractionId','ui.createdAt','from','user_has_','_interactions','where','ui.UserId\x20=\x20?','sequelize','query','toString','OpenTabs','define','UserProfile','user_profiles','section','mergeResources','Invalid\x20section\x20\x27','isEmpty','UserProfileSection','params','union','length','ignore','push','autoAssociation','all','rawAttributes','model','keys','filters','fields','attributes','nolimit','limit','offset','order','sort','merge','key','find','foreignKey','options','includeAll','include','forEach','reportType','reportId','DefaultReports','CustomReports','count','rows','color','tag','ThroughTags','true','chat','dataValues','sms','fax','mail','openchannel','whatsapp','lodash','./userProfile.attributes','../../components/parsers/qs','exports','filter','value','findAll','then','associatedResources','map','catch','field','UserProfileResource','resourceId','type','SquareProject','odbc','SquareOdbc','childModel','SquareRecording','SquareProjects','name','projectName','projects','CmContact','Lists','ListId','lists','CmList','CmCompany','globalcustomfields','CmCustomField','ChatQueue','chatwebsites','faxqueues','faxaccounts','inboundroutes','internalroutes','outboundroutes','VoiceExtension','contexts','voicemails','VoiceMail','voicerecordings','parentSections','Agents','membername','User','role','agent','queue','VoiceQueue','QueueCampaigns','musiconholds','VoiceMusicOnHold','chanspies','VoicePrefix','ivrcampaigns','Campaign'];(function(_0x536286,_0x4b5516){var _0x4c2e7d=function(_0x47b38b){while(--_0x47b38b){_0x536286['push'](_0x536286['shift']());}};_0x4c2e7d(++_0x4b5516);}(_0x22ab,0x78));var _0xb22a=function(_0x3d8d0a,_0x11bb87){_0x3d8d0a=_0x3d8d0a-0x0;var _0x5b9df5=_0x22ab[_0x3d8d0a];return _0x5b9df5;};'use strict';var _=require(_0xb22a('0x0'));var attributes=require(_0xb22a('0x1'));var qs=require(_0xb22a('0x2'));module[_0xb22a('0x3')]=function(_0x39ab9b){var _0x2b9608=_0x39ab9b['models'];function _0x5b1739(_0x517e90,_0x40b42f){return new Promise(function(_0x45ca9e,_0x353110){if(!_0x40b42f)return _0x45ca9e(null);var _0x5499e7=_0x40b42f[_0xb22a('0x4')]?{[_0x40b42f[_0xb22a('0x4')]['field']]:_0x40b42f[_0xb22a('0x4')][_0xb22a('0x5')]}:undefined;return _0x2b9608[_0x517e90][_0xb22a('0x6')]({'where':_0x5499e7,'raw':!![]})[_0xb22a('0x7')](function(_0x185eaa){_0x40b42f[_0xb22a('0x8')]=_[_0xb22a('0x9')](_0x185eaa,'id');_0x45ca9e(_0x40b42f);})[_0xb22a('0xa')](function(_0x3de3d2){_0x353110(_0x3de3d2);});});}function _0x17efe7(_0x1c54ae,_0x6c4c1){return new Promise(function(_0x532c3a,_0x237be0){var _0x3b59c5=_0x1c54ae[_0xb22a('0x4')]?{[_0x1c54ae['filter'][_0xb22a('0xb')]]:_0x1c54ae[_0xb22a('0x4')][_0xb22a('0x5')]}:undefined;return _0x2b9608[_0x1c54ae['model']][_0xb22a('0x6')]({'where':_0x3b59c5,'raw':!![]})[_0xb22a('0x7')](function(_0x4461c5){_0x6c4c1[_0xb22a('0x8')]=_['map'](_0x4461c5,function(_0x20aa1a){return _0x20aa1a['name'];});_0x532c3a(_0x6c4c1);})[_0xb22a('0xa')](function(_0x2c124b){_0x237be0(_0x2c124b);});});}function _0x1fc148(_0x587cd3,_0x26d1a8,_0x1a8cd0){if(!_0x26d1a8)return resolve(null);return new Promise(function(_0x27a46b,_0x39234e){return _0x2b9608[_0xb22a('0xc')][_0xb22a('0x6')]({'where':{'sectionId':_0x26d1a8['id']},'raw':!![]})['then'](function(_0x4db5d5){if(_0x587cd3['field']&&_0x587cd3[_0xb22a('0xb')]!=='id'){_0x26d1a8[_0xb22a('0x8')]=_['map'](_0x4db5d5,function(_0x44be83){return _0x44be83[_0x587cd3[_0xb22a('0xb')]];});}else{if(_0x1a8cd0==='AnalyticExtractedReport'){_0x26d1a8[_0xb22a('0x8')]=_[_0xb22a('0x9')](_0x4db5d5,function(_0x486e3c){return{'id':_0x486e3c[_0xb22a('0xd')],'type':_0x486e3c[_0xb22a('0xe')]};});}else{_0x26d1a8[_0xb22a('0x8')]=_[_0xb22a('0x9')](_0x4db5d5,function(_0xc1614d){return _0xc1614d['resourceId'];});}}_0x27a46b(_0x26d1a8);})[_0xb22a('0xa')](function(_0x38a5d8){_0x39234e(_0x38a5d8);});});}function _0xc63ba5(_0x2c6dc0,_0xadfb9){var _0x41861c={'parentSections':[]};switch(_0x2c6dc0['toLowerCase']()){case'squareprojects':_0x41861c['childModel']=_0xb22a('0xf');break;case _0xb22a('0x10'):_0x41861c['childModel']=_0xb22a('0x11');break;case'squarerecordings':_0x41861c[_0xb22a('0x12')]=_0xb22a('0x13');_0x41861c['parentSections']=[{'name':_0xb22a('0x14'),'field':_0xb22a('0x15'),'foreignKey':_0xb22a('0x16')}];break;case _0xb22a('0x17'):_0x41861c[_0xb22a('0x12')]='JscriptyProject';break;case'contacts':_0x41861c[_0xb22a('0x12')]=_0xb22a('0x18');_0x41861c['parentSections']=[{'name':_0xb22a('0x19'),'field':'id','foreignKey':_0xb22a('0x1a')}];break;case _0xb22a('0x1b'):_0x41861c[_0xb22a('0x12')]=_0xb22a('0x1c');break;case'companies':_0x41861c[_0xb22a('0x12')]=_0xb22a('0x1d');break;case _0xb22a('0x1e'):_0x41861c[_0xb22a('0x12')]=_0xb22a('0x1f');break;case'chatqueues':_0x41861c[_0xb22a('0x12')]=_0xb22a('0x20');break;case _0xb22a('0x21'):_0x41861c[_0xb22a('0x12')]='ChatWebsite';break;case _0xb22a('0x22'):_0x41861c['childModel']='FaxQueue';break;case _0xb22a('0x23'):_0x41861c[_0xb22a('0x12')]='FaxAccount';break;case _0xb22a('0x24'):case _0xb22a('0x25'):case _0xb22a('0x26'):_0x41861c[_0xb22a('0x12')]=_0xb22a('0x27');break;case _0xb22a('0x28'):_0x41861c[_0xb22a('0x12')]='VoiceContext';break;case _0xb22a('0x29'):_0x41861c[_0xb22a('0x12')]=_0xb22a('0x2a');break;case _0xb22a('0x2b'):_0x41861c[_0xb22a('0x12')]='VoiceRecording';_0x41861c[_0xb22a('0x2c')]=[{'name':_0xb22a('0x2d'),'field':_0xb22a('0x15'),'foreignKey':_0xb22a('0x2e'),'model':_0xb22a('0x2f'),'filter':{'field':_0xb22a('0x30'),'value':[_0xb22a('0x31')]}},{'name':'Telephones','field':_0xb22a('0x15'),'foreignKey':_0xb22a('0x2e'),'model':'User','filter':{'field':'role','value':['telephone']}},{'name':'VoiceQueues','field':_0xb22a('0x15'),'foreignKey':_0xb22a('0x32'),'model':_0xb22a('0x33'),'filter':{'field':_0xb22a('0xe'),'value':['inbound']}},{'name':_0xb22a('0x34'),'field':_0xb22a('0x15'),'foreignKey':'queue','model':'VoiceQueue','filter':{'field':_0xb22a('0xe'),'value':['outbound']}}];break;case _0xb22a('0x35'):_0x41861c['childModel']=_0xb22a('0x36');break;case _0xb22a('0x37'):_0x41861c[_0xb22a('0x12')]='VoiceChanSpy';break;case'voiceprefixes':_0x41861c[_0xb22a('0x12')]=_0xb22a('0x38');break;case _0xb22a('0x39'):_0x41861c[_0xb22a('0x12')]=_0xb22a('0x3a');break;case'mailqueues':_0x41861c['childModel']='MailQueue';break;case _0xb22a('0x3b'):_0x41861c['childModel']=_0xb22a('0x3c');break;case _0xb22a('0x3d'):_0x41861c[_0xb22a('0x12')]='MailSubstatus';break;case _0xb22a('0x3e'):_0x41861c[_0xb22a('0x12')]=_0xb22a('0x3f');break;case'openchannelaccounts':_0x41861c[_0xb22a('0x12')]='OpenchannelAccount';break;case'smsqueues':_0x41861c[_0xb22a('0x12')]=_0xb22a('0x40');break;case'smsaccounts':_0x41861c[_0xb22a('0x12')]=_0xb22a('0x41');break;case _0xb22a('0x42'):_0x41861c[_0xb22a('0x12')]='WhatsappQueue';break;case'whatsappaccounts':_0x41861c[_0xb22a('0x12')]=_0xb22a('0x43');break;case'teams':_0x41861c[_0xb22a('0x12')]=_0xb22a('0x44');break;case _0xb22a('0x45'):case _0xb22a('0x46'):_0x41861c['childModel']=_0xb22a('0x33');if(_0xadfb9){_0x41861c['parentSections']=[{'name':'VoiceQueues'},{'name':_0xb22a('0x34')}];}break;case _0xb22a('0x47'):case _0xb22a('0x48'):case _0xb22a('0x49'):_0x41861c['childModel']='User';if(_0xadfb9){_0x41861c[_0xb22a('0x2c')]=[{'name':'Users','filter':{'field':_0xb22a('0x30'),'value':[_0xb22a('0x4a'),'user']},'ignore':!![]},{'name':_0xb22a('0x2d')},{'name':_0xb22a('0x4b')}];}break;case'zendeskaccounts':_0x41861c[_0xb22a('0x12')]='ZendeskAccount';break;case _0xb22a('0x4c'):_0x41861c['childModel']=_0xb22a('0x4d');break;case _0xb22a('0x4e'):_0x41861c[_0xb22a('0x12')]=_0xb22a('0x4f');break;case _0xb22a('0x50'):_0x41861c[_0xb22a('0x12')]=_0xb22a('0x51');break;case _0xb22a('0x52'):_0x41861c[_0xb22a('0x12')]=_0xb22a('0x53');break;case _0xb22a('0x54'):_0x41861c[_0xb22a('0x12')]='ZohoAccount';break;case _0xb22a('0x55'):_0x41861c['childModel']='User';break;case _0xb22a('0x56'):_0x41861c[_0xb22a('0x12')]=_0xb22a('0x57');break;case _0xb22a('0x58'):_0x41861c['childModel']=_0xb22a('0x59');break;case _0xb22a('0x5a'):_0x41861c['childModel']=_0xb22a('0x5b');break;case _0xb22a('0x5c'):_0x41861c[_0xb22a('0x12')]=_0xb22a('0x5d');break;case'pauses':_0x41861c[_0xb22a('0x12')]=_0xb22a('0x5e');break;case _0xb22a('0x5f'):_0x41861c['childModel']='Schedule';break;case _0xb22a('0x60'):_0x41861c[_0xb22a('0x12')]=_0xb22a('0x61');break;case'tags':_0x41861c['childModel']=_0xb22a('0x62');break;case _0xb22a('0x63'):_0x41861c[_0xb22a('0x12')]=_0xb22a('0x64');break;case _0xb22a('0x65'):_0x41861c[_0xb22a('0x12')]=_0xb22a('0x66');break;case _0xb22a('0x67'):_0x41861c['childModel']='Trunk';break;case _0xb22a('0x68'):_0x41861c[_0xb22a('0x12')]=_0xb22a('0x69');break;case _0xb22a('0x6a'):_0x41861c['childModel']=_0xb22a('0x6b');break;case _0xb22a('0x6c'):_0x41861c[_0xb22a('0x12')]=_0xb22a('0x6d');_0x41861c[_0xb22a('0x2c')]=[{'name':'Reports','field':'id','foreignKey':'reportId'}];break;case _0xb22a('0x6e'):_0x41861c['childModel']='AnalyticMetric';break;case _0xb22a('0x6f'):_0x41861c[_0xb22a('0x12')]='WhatsappAccount';break;}return _0x41861c;}function _0x56789e(_0x475e34,_0x1691fa){var _0x5576d5=_0x475e34[_0xb22a('0x70')](0x0)[_0xb22a('0x71')]()+_0x475e34[_0xb22a('0x72')](0x1);var _0x3fb999={'type':_0x2b9608['Sequelize'][_0xb22a('0x73')][_0xb22a('0x74')],'raw':!![]};return new BPromise(function(_0x33ce40,_0x1c6c50){var _0x27533e=squel['select']()[_0xb22a('0xb')]('ui.'+_0x5576d5+_0xb22a('0x75'),'id')[_0xb22a('0xb')](_0xb22a('0x76'))[_0xb22a('0x77')](_0xb22a('0x78')+_0x475e34+_0xb22a('0x79'),'ui')[_0xb22a('0x7a')](_0xb22a('0x7b'),_0x1691fa['id']);return _0x2b9608[_0xb22a('0x7c')][_0xb22a('0x7d')](_0x27533e[_0xb22a('0x7e')](),_0x3fb999)[_0xb22a('0x7')](function(_0x3e4ff3){_0x1691fa[_0x5576d5+_0xb22a('0x7f')]=_0x3e4ff3;_0x33ce40(_0x3e4ff3);})[_0xb22a('0xa')](function(_0x59263c){_0x1c6c50(_0x59263c);});});}return _0x39ab9b[_0xb22a('0x80')](_0xb22a('0x81'),attributes,{'tableName':_0xb22a('0x82'),'paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x3a3ed9){var _0x36bc5b={'raw':![],'where':{}};var _0x452a6b={};var _0xb6d75e={'count':0x0,'rows':[]};var _0x45c398=_0x3a3ed9[_0xb22a('0x7d')][_0xb22a('0x83')];var _0x383fa3=_0x3a3ed9[_0xb22a('0x7d')][_0xb22a('0x84')]||![];var _0x2b09ba=_0xc63ba5(_0x45c398,_0x383fa3);if(!_0x2b09ba['childModel'])throw new Error(_0xb22a('0x85')+_0x45c398+'\x27');var _0x13ed56=[{'name':_0x45c398}];if(!_[_0xb22a('0x86')](_0x2b09ba['parentSections']))_0x13ed56=_0x2b09ba[_0xb22a('0x2c')];var _0x7c3688=[];for(var _0x2824b7=0x0;_0x2824b7<_0x13ed56['length'];_0x2824b7++){_0x7c3688['push'](_0x2b9608[_0xb22a('0x87')]['find']({'where':{'userProfileId':_0x3a3ed9[_0xb22a('0x88')]['id'],'name':_0x13ed56[_0x2824b7][_0xb22a('0x15')]},'raw':!![]}));}return Promise['all'](_0x7c3688)['then'](function(_0x322043){var _0x201346=_[_0xb22a('0x4')](_0x322043,function(_0x219983){return _0x219983?_0x219983:undefined;});var _0x30c6ee=_[_0xb22a('0x4')](_0x13ed56,['ignore',!![]]);var _0x5024e4=_['isEmpty'](_0x201346)&&_[_0xb22a('0x86')](_0x30c6ee)?null:_[_0xb22a('0x89')](_0x30c6ee,_0x201346);if(!_0x5024e4)return null;var _0x3fab01=[];for(var _0x41cd9f=0x0;_0x41cd9f<_0x5024e4[_0xb22a('0x8a')];_0x41cd9f++){var _0x42b144=_['find'](_0x13ed56,function(_0x5c2e95){return _0x5024e4[_0x41cd9f]?_0x5c2e95[_0xb22a('0x15')]===_0x5024e4[_0x41cd9f][_0xb22a('0x15')]:null;});if(_0x42b144){if(_0x5024e4[_0x41cd9f][_0xb22a('0x8b')]){_0x3fab01[_0xb22a('0x8c')](_0x5b1739(_0x2b09ba[_0xb22a('0x12')],_0x5024e4[_0x41cd9f]));}else{if(!_0x5024e4[_0x41cd9f][_0xb22a('0x8d')]){_0x3fab01['push'](_0x1fc148(_0x42b144,_0x5024e4[_0x41cd9f],_0x2b09ba['childModel']));}else{if(_0x42b144['model']){_0x3fab01[_0xb22a('0x8c')](_0x17efe7(_0x42b144,_0x5024e4[_0x41cd9f]));}}}}}return Promise[_0xb22a('0x8e')](_0x3fab01);})[_0xb22a('0x7')](function(_0x1feca4){var _0x2e21cf=_0x1feca4;var _0x1c30d0=null;if(_0x2e21cf){_0x1c30d0=_0x2e21cf[_0xb22a('0x8a')]===0x1?_0x2e21cf[0x0]:null;}if(!_0x1c30d0&&!_0x2e21cf)return _0xb6d75e;var _0xb73e49=_0x2b9608[_0x2b09ba[_0xb22a('0x12')]][_0xb22a('0x8f')];_0x452a6b[_0xb22a('0x90')]=_[_0xb22a('0x91')](_0xb73e49);_0x452a6b[_0xb22a('0x7d')]=_[_0xb22a('0x91')](_0x3a3ed9[_0xb22a('0x7d')]);_0x452a6b[_0xb22a('0x92')]=_['intersection'](_0x452a6b['model'],_0x452a6b[_0xb22a('0x7d')]);_0x36bc5b['attributes']=_['intersection'](_0x452a6b[_0xb22a('0x90')],qs['fields'](_0x3a3ed9[_0xb22a('0x7d')][_0xb22a('0x93')]));_0x36bc5b['attributes']=_0x36bc5b[_0xb22a('0x94')]['length']?_0x36bc5b[_0xb22a('0x94')]:_0x452a6b[_0xb22a('0x90')];if(!_0x3a3ed9[_0xb22a('0x7d')]['hasOwnProperty'](_0xb22a('0x95'))){_0x36bc5b[_0xb22a('0x96')]=qs[_0xb22a('0x96')](_0x3a3ed9[_0xb22a('0x7d')][_0xb22a('0x96')]);_0x36bc5b[_0xb22a('0x97')]=qs[_0xb22a('0x97')](_0x3a3ed9[_0xb22a('0x7d')]['offset']);}_0x36bc5b[_0xb22a('0x98')]=qs[_0xb22a('0x99')](_0x3a3ed9[_0xb22a('0x7d')]['sort']);_0x36bc5b[_0xb22a('0x7a')]=qs[_0xb22a('0x92')](_['pick'](_0x3a3ed9['query'],_0x452a6b[_0xb22a('0x92')]));if(_0x3a3ed9[_0xb22a('0x7d')]['filter']){_0x36bc5b[_0xb22a('0x7a')]=_[_0xb22a('0x9a')](_0x36bc5b[_0xb22a('0x7a')],{'$or':_[_0xb22a('0x9')](_0xb73e49,function(_0x1a855c){if(_0x1a855c[_0xb22a('0xe')][_0xb22a('0x9b')]!=='VIRTUAL'){var _0x3973d1={};_0x3973d1[_0x1a855c[_0xb22a('0xb')]]={'$like':'%'+_0x3a3ed9[_0xb22a('0x7d')]['filter']+'%'};return _0x3973d1;}})});}var _0x5cb0f3=[];if(_0x1c30d0){var _0x5930a4=_[_0xb22a('0x9c')](_0x13ed56,['name',_0x1c30d0['name']]);if(_0x5930a4[_0xb22a('0xb')]){var _0x570131={};if(_0x2b09ba[_0xb22a('0x12')]===_0xb22a('0x6d')){_0x570131[_0x5930a4[_0xb22a('0x9d')]]=_[_0xb22a('0x9')](_0x1c30d0['associatedResources'],'id');}else{_0x570131[_0x5930a4[_0xb22a('0x9d')]]=_0x1c30d0[_0xb22a('0x8')];}_0x5cb0f3[_0xb22a('0x8c')](_0x570131);}else{_0x36bc5b[_0xb22a('0x7a')]['id']=_0x1c30d0[_0xb22a('0x8')];}}else{for(var _0x1c0b96=0x0;_0x1c0b96<_0x2e21cf[_0xb22a('0x8a')];_0x1c0b96++){var _0x5930a4=_['find'](_0x13ed56,[_0xb22a('0x15'),_0x2e21cf[_0x1c0b96]['name']]);if(_0x5930a4[_0xb22a('0xb')]){var _0x570131={};_0x570131[_0x5930a4['foreignKey']]=_0x2e21cf[_0x1c0b96][_0xb22a('0x8')];_0x5cb0f3[_0xb22a('0x8c')](_0x570131);}else{if(!_0x36bc5b[_0xb22a('0x7a')]['id'])_0x36bc5b[_0xb22a('0x7a')]['id']=[];_0x2e21cf[_0x1c0b96][_0xb22a('0x8')]['forEach'](function(_0x46c945){_0x36bc5b[_0xb22a('0x7a')]['id']['push'](_0x46c945);});}}}if(!_[_0xb22a('0x86')](_0x5cb0f3)){_0x36bc5b[_0xb22a('0x7a')]=_[_0xb22a('0x9a')](_0x36bc5b[_0xb22a('0x7a')],{'$and':{'$or':_0x5cb0f3}});}_0x36bc5b=_[_0xb22a('0x9a')]({},_0x36bc5b,_0x3a3ed9[_0xb22a('0x9e')]);if(_0x1c30d0&&!_0x1c30d0['autoAssociation']&&_0x2b09ba['childModel']===_0xb22a('0x6d')){if(_0x3a3ed9[_0xb22a('0x7d')][_0xb22a('0x9f')]){_0x36bc5b[_0xb22a('0xa0')]=[{'all':!![]}];}return _0x2b9608[_0x2b09ba['childModel']]['findAll'](_0x36bc5b)[_0xb22a('0x7')](function(_0x11ff48){var _0x2e2498=[];_0x11ff48[_0xb22a('0xa1')](function(_0x1af618){var _0x5edc1c;switch(_0x1af618[_0xb22a('0xa2')]){case'default':_0x5edc1c=_['find'](_0x1c30d0[_0xb22a('0x8')],function(_0x188684){return _0x188684['id']===_0x1af618[_0xb22a('0xa3')]&&_0x188684[_0xb22a('0xe')]===_0xb22a('0xa4');});break;case'custom':_0x5edc1c=_[_0xb22a('0x9c')](_0x1c30d0[_0xb22a('0x8')],function(_0x57615c){return _0x57615c['id']===_0x1af618['reportId']&&_0x57615c[_0xb22a('0xe')]===_0xb22a('0xa5');});break;}if(_0x5edc1c)_0x2e2498[_0xb22a('0x8c')](_0x1af618);});_0xb6d75e[_0xb22a('0xa6')]=_0x2e2498[_0xb22a('0x8a')];_0xb6d75e[_0xb22a('0xa7')]=_0x2e2498;return _0xb6d75e;});}else{return _0x2b9608[_0x2b09ba[_0xb22a('0x12')]][_0xb22a('0xa6')]({'where':_0x36bc5b[_0xb22a('0x7a')]})[_0xb22a('0x7')](function(_0x2dfc1a){_0xb6d75e[_0xb22a('0xa6')]=_0x2dfc1a;if(_0x3a3ed9[_0xb22a('0x7d')]['includeAll']){if(_0x2b09ba[_0xb22a('0x12')]===_0xb22a('0x18')){_0x36bc5b[_0xb22a('0xa0')]=[{'model':_0x2b9608[_0xb22a('0x62')],'as':'Tags','attributes':['id','name',_0xb22a('0xa8')],'required':_0x3a3ed9[_0xb22a('0x7d')][_0xb22a('0xa9')]?!![]:![]},{'model':_0x2b9608[_0xb22a('0x62')],'as':_0xb22a('0xaa'),'attributes':['id',_0xb22a('0x15'),'color'],'through':_0x3a3ed9[_0xb22a('0x7d')]['tag']?{'attributes':[],'where':{'TagId':_0x3a3ed9['query'][_0xb22a('0xa9')]||undefined}}:{},'required':_0x3a3ed9[_0xb22a('0x7d')][_0xb22a('0xa9')]?!![]:![]}];}else{_0x36bc5b[_0xb22a('0xa0')]=[{'all':!![]}];}}return _0x2b9608[_0x2b09ba[_0xb22a('0x12')]][_0xb22a('0x6')](_0x36bc5b);})[_0xb22a('0x7')](function(_0x52a945){_0xb6d75e['rows']=_0x52a945;if(_0x45c398===_0xb22a('0x2d')&&_0x3a3ed9[_0xb22a('0x7d')]['openTabs']===_0xb22a('0xab')){var _0x2785ff=[];for(var _0x25da64=0x0;_0x25da64<_0xb6d75e[_0xb22a('0xa7')][_0xb22a('0x8a')];_0x25da64++){_0x2785ff[_0xb22a('0x8c')](_0x56789e(_0xb22a('0xac'),_0xb6d75e[_0xb22a('0xa7')][_0x25da64][_0xb22a('0xad')]));_0x2785ff['push'](_0x56789e(_0xb22a('0xae'),_0xb6d75e['rows'][_0x25da64]['dataValues']));_0x2785ff[_0xb22a('0x8c')](_0x56789e(_0xb22a('0xaf'),_0xb6d75e[_0xb22a('0xa7')][_0x25da64][_0xb22a('0xad')]));_0x2785ff[_0xb22a('0x8c')](_0x56789e(_0xb22a('0xb0'),_0xb6d75e[_0xb22a('0xa7')][_0x25da64][_0xb22a('0xad')]));_0x2785ff[_0xb22a('0x8c')](_0x56789e(_0xb22a('0xb1'),_0xb6d75e[_0xb22a('0xa7')][_0x25da64]['dataValues']));_0x2785ff['push'](_0x56789e(_0xb22a('0xb2'),_0xb6d75e['rows'][_0x25da64][_0xb22a('0xad')]));}return Promise[_0xb22a('0x8e')](_0x2785ff)[_0xb22a('0x7')](function(){return _0xb6d75e;});}return _0xb6d75e;});}});}}});};