Built motion from commit d5e4af8c.|2.6.23
[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 _0xbc0a=['forEach','default','DefaultReports','custom','CustomReports','rows','ids','customSorting','extraQueryConditions','count','color','tag','include','openTabs','chat','dataValues','sms','fax','mail','openchannel','whatsapp','lodash','./userProfile.attributes','models','field','filter','value','findAll','then','associatedResources','map','model','name','resolve','UserProfileResource','AnalyticExtractedReport','resourceId','catch','childModel','odbc','SquareOdbc','squarerecordings','parentSections','SquareProjects','projectName','projects','contacts','CmContact','Lists','lists','CmList','globalcustomfields','CmCustomField','chatqueues','ChatQueue','chatwebsites','FaxQueue','faxaccounts','inboundroutes','internalroutes','outboundroutes','VoiceExtension','contexts','VoiceContext','voicemails','voicerecordings','VoiceRecording','Agents','membername','User','role','telephone','VoiceQueues','queue','VoiceQueue','type','inbound','QueueCampaigns','outbound','musiconholds','chanspies','VoiceChanSpy','VoicePrefix','Campaign','mailqueues','MailQueue','mailaccounts','MailAccount','mailsubstatuses','MailSubstatus','openchannelqueues','openchannelaccounts','OpenchannelAccount','smsqueues','SmsQueue','smsaccounts','SmsAccount','WhatsappQueue','whatsappaccounts','WhatsappAccount','teams','Team','voicequeues','queuecampaigns','users','agents','telephones','Users','admin','user','zendeskaccounts','SalesforceAccount','freshdeskaccounts','FreshdeskAccount','SugarcrmAccount','deskaccounts','DeskAccount','zohoaccounts','ZohoAccount','vtigeraccounts','cannedanswers','dispositions','customdashboards','Dashboard','intervals','Interval','Pause','scheduler','Schedule','sounds','tags','Tag','templates','Template','Trunk','variables','Variable','plugins','Plugin','extractedreports','reportId','AnalyticMetric','Sequelize','QueryTypes','select','ui.','InteractionId','ui.createdAt','from','where','ui.UserId\x20=\x20?','sequelize','query','toString','OpenTabs','define','UserProfile','user_profiles','../../components/parsers/qs','raw','section','mergeResources','Invalid\x20section\x20\x27','isEmpty','length','push','UserProfileSection','find','params','all','ignore','union','rawAttributes','keys','filters','intersection','fields','attributes','hasOwnProperty','nolimit','limit','offset','order','sort','pick','merge','key','foreignKey','options','autoAssociation','includeAll'];(function(_0x5d80de,_0x2cf15d){var _0x1c7556=function(_0x5bd806){while(--_0x5bd806){_0x5d80de['push'](_0x5d80de['shift']());}};_0x1c7556(++_0x2cf15d);}(_0xbc0a,0xd4));var _0xabc0=function(_0x5a9d13,_0x174908){_0x5a9d13=_0x5a9d13-0x0;var _0x2b971d=_0xbc0a[_0x5a9d13];return _0x2b971d;};'use strict';var _=require(_0xabc0('0x0'));var attributes=require(_0xabc0('0x1'));var squel=require('squel');module['exports']=function(_0xe5e0f){var _0x4d1cf0=_0xe5e0f[_0xabc0('0x2')];function _0x53cd28(_0x3d6332,_0x61f577){return new Promise(function(_0x2230d6,_0x200aaf){if(!_0x61f577)return _0x2230d6(null);var _0x81c60b=_0x61f577['filter']?{[_0x61f577['filter'][_0xabc0('0x3')]]:_0x61f577[_0xabc0('0x4')][_0xabc0('0x5')]}:undefined;return _0x4d1cf0[_0x3d6332][_0xabc0('0x6')]({'where':_0x81c60b,'raw':!![]})[_0xabc0('0x7')](function(_0xbc095c){_0x61f577[_0xabc0('0x8')]=_[_0xabc0('0x9')](_0xbc095c,'id');_0x2230d6(_0x61f577);})['catch'](function(_0x3c0f60){_0x200aaf(_0x3c0f60);});});}function _0x3016a8(_0x17fb56,_0x3e41b1){return new Promise(function(_0x2addcf,_0x17ca49){var _0x262784=_0x17fb56['filter']?{[_0x17fb56[_0xabc0('0x4')][_0xabc0('0x3')]]:_0x17fb56[_0xabc0('0x4')][_0xabc0('0x5')]}:undefined;return _0x4d1cf0[_0x17fb56[_0xabc0('0xa')]][_0xabc0('0x6')]({'where':_0x262784,'raw':!![]})[_0xabc0('0x7')](function(_0x4f3791){_0x3e41b1['associatedResources']=_[_0xabc0('0x9')](_0x4f3791,function(_0x4a3560){return _0x4a3560[_0xabc0('0xb')];});_0x2addcf(_0x3e41b1);})['catch'](function(_0x553d9d){_0x17ca49(_0x553d9d);});});}function _0x3d9343(_0xe4e9a0,_0x387821,_0x19147c){if(!_0x387821)return Promise[_0xabc0('0xc')](null);return new Promise(function(_0x4b5739,_0x2ecb06){return _0x4d1cf0[_0xabc0('0xd')][_0xabc0('0x6')]({'where':{'sectionId':_0x387821['id']},'raw':!![]})[_0xabc0('0x7')](function(_0x38d029){if(_0xe4e9a0['field']&&_0xe4e9a0[_0xabc0('0x3')]!=='id'){_0x387821[_0xabc0('0x8')]=_['map'](_0x38d029,function(_0x3e4ea1){return _0x3e4ea1[_0xe4e9a0['field']];});}else{if(_0x19147c===_0xabc0('0xe')){_0x387821[_0xabc0('0x8')]=_[_0xabc0('0x9')](_0x38d029,function(_0x2aadeb){return{'id':_0x2aadeb[_0xabc0('0xf')],'type':_0x2aadeb['type']};});}else{_0x387821[_0xabc0('0x8')]=_[_0xabc0('0x9')](_0x38d029,function(_0xc1cff1){return _0xc1cff1[_0xabc0('0xf')];});}}_0x4b5739(_0x387821);})[_0xabc0('0x10')](function(_0x4cc152){_0x2ecb06(_0x4cc152);});});}function _0x38df1d(_0x2318b4,_0x929c71){var _0x55812e={'parentSections':[]};switch(_0x2318b4['toLowerCase']()){case'squareprojects':_0x55812e[_0xabc0('0x11')]='SquareProject';break;case _0xabc0('0x12'):_0x55812e[_0xabc0('0x11')]=_0xabc0('0x13');break;case _0xabc0('0x14'):_0x55812e[_0xabc0('0x11')]='SquareRecording';_0x55812e[_0xabc0('0x15')]=[{'name':_0xabc0('0x16'),'field':_0xabc0('0xb'),'foreignKey':_0xabc0('0x17')}];break;case _0xabc0('0x18'):_0x55812e['childModel']='JscriptyProject';break;case _0xabc0('0x19'):_0x55812e[_0xabc0('0x11')]=_0xabc0('0x1a');_0x55812e[_0xabc0('0x15')]=[{'name':_0xabc0('0x1b'),'field':'id','foreignKey':'ListId'}];break;case _0xabc0('0x1c'):_0x55812e['childModel']=_0xabc0('0x1d');break;case'companies':_0x55812e[_0xabc0('0x11')]='CmCompany';break;case _0xabc0('0x1e'):_0x55812e[_0xabc0('0x11')]=_0xabc0('0x1f');break;case _0xabc0('0x20'):_0x55812e[_0xabc0('0x11')]=_0xabc0('0x21');break;case _0xabc0('0x22'):_0x55812e[_0xabc0('0x11')]='ChatWebsite';break;case'faxqueues':_0x55812e[_0xabc0('0x11')]=_0xabc0('0x23');break;case _0xabc0('0x24'):_0x55812e[_0xabc0('0x11')]='FaxAccount';break;case _0xabc0('0x25'):case _0xabc0('0x26'):case _0xabc0('0x27'):_0x55812e['childModel']=_0xabc0('0x28');break;case _0xabc0('0x29'):_0x55812e[_0xabc0('0x11')]=_0xabc0('0x2a');break;case _0xabc0('0x2b'):_0x55812e[_0xabc0('0x11')]='VoiceMail';break;case _0xabc0('0x2c'):_0x55812e[_0xabc0('0x11')]=_0xabc0('0x2d');_0x55812e['parentSections']=[{'name':_0xabc0('0x2e'),'field':'name','foreignKey':_0xabc0('0x2f'),'model':_0xabc0('0x30'),'filter':{'field':_0xabc0('0x31'),'value':['agent']}},{'name':'Telephones','field':_0xabc0('0xb'),'foreignKey':'membername','model':'User','filter':{'field':'role','value':[_0xabc0('0x32')]}},{'name':_0xabc0('0x33'),'field':_0xabc0('0xb'),'foreignKey':_0xabc0('0x34'),'model':_0xabc0('0x35'),'filter':{'field':_0xabc0('0x36'),'value':[_0xabc0('0x37')]}},{'name':_0xabc0('0x38'),'field':_0xabc0('0xb'),'foreignKey':_0xabc0('0x34'),'model':_0xabc0('0x35'),'filter':{'field':_0xabc0('0x36'),'value':[_0xabc0('0x39')]}}];break;case _0xabc0('0x3a'):_0x55812e[_0xabc0('0x11')]='VoiceMusicOnHold';break;case _0xabc0('0x3b'):_0x55812e[_0xabc0('0x11')]=_0xabc0('0x3c');break;case'voiceprefixes':_0x55812e[_0xabc0('0x11')]=_0xabc0('0x3d');break;case'ivrcampaigns':_0x55812e['childModel']=_0xabc0('0x3e');break;case _0xabc0('0x3f'):_0x55812e[_0xabc0('0x11')]=_0xabc0('0x40');break;case _0xabc0('0x41'):_0x55812e[_0xabc0('0x11')]=_0xabc0('0x42');break;case _0xabc0('0x43'):_0x55812e[_0xabc0('0x11')]=_0xabc0('0x44');break;case _0xabc0('0x45'):_0x55812e[_0xabc0('0x11')]='OpenchannelQueue';break;case _0xabc0('0x46'):_0x55812e['childModel']=_0xabc0('0x47');break;case _0xabc0('0x48'):_0x55812e[_0xabc0('0x11')]=_0xabc0('0x49');break;case _0xabc0('0x4a'):_0x55812e[_0xabc0('0x11')]=_0xabc0('0x4b');break;case'whatsappqueues':_0x55812e[_0xabc0('0x11')]=_0xabc0('0x4c');break;case _0xabc0('0x4d'):_0x55812e[_0xabc0('0x11')]=_0xabc0('0x4e');break;case _0xabc0('0x4f'):_0x55812e[_0xabc0('0x11')]=_0xabc0('0x50');break;case _0xabc0('0x51'):case _0xabc0('0x52'):_0x55812e['childModel']=_0xabc0('0x35');if(_0x929c71){_0x55812e[_0xabc0('0x15')]=[{'name':'VoiceQueues'},{'name':'QueueCampaigns'}];}break;case _0xabc0('0x53'):case _0xabc0('0x54'):case _0xabc0('0x55'):_0x55812e['childModel']=_0xabc0('0x30');if(_0x929c71){_0x55812e[_0xabc0('0x15')]=[{'name':_0xabc0('0x56'),'filter':{'field':_0xabc0('0x31'),'value':[_0xabc0('0x57'),_0xabc0('0x58')]},'ignore':!![]},{'name':_0xabc0('0x2e')},{'name':'Telephones'}];}break;case _0xabc0('0x59'):_0x55812e['childModel']='ZendeskAccount';break;case'salesforceaccounts':_0x55812e['childModel']=_0xabc0('0x5a');break;case _0xabc0('0x5b'):_0x55812e[_0xabc0('0x11')]=_0xabc0('0x5c');break;case'sugarcrmaccounts':_0x55812e[_0xabc0('0x11')]=_0xabc0('0x5d');break;case _0xabc0('0x5e'):_0x55812e[_0xabc0('0x11')]=_0xabc0('0x5f');break;case _0xabc0('0x60'):_0x55812e['childModel']=_0xabc0('0x61');break;case _0xabc0('0x62'):_0x55812e['childModel']=_0xabc0('0x30');break;case _0xabc0('0x63'):_0x55812e[_0xabc0('0x11')]='CannedAnswer';break;case _0xabc0('0x64'):_0x55812e[_0xabc0('0x11')]='Disposition';break;case _0xabc0('0x65'):_0x55812e['childModel']=_0xabc0('0x66');break;case _0xabc0('0x67'):_0x55812e[_0xabc0('0x11')]=_0xabc0('0x68');break;case'pauses':_0x55812e[_0xabc0('0x11')]=_0xabc0('0x69');break;case _0xabc0('0x6a'):_0x55812e[_0xabc0('0x11')]=_0xabc0('0x6b');break;case _0xabc0('0x6c'):_0x55812e[_0xabc0('0x11')]='Sound';break;case _0xabc0('0x6d'):_0x55812e[_0xabc0('0x11')]=_0xabc0('0x6e');break;case _0xabc0('0x6f'):_0x55812e[_0xabc0('0x11')]=_0xabc0('0x70');break;case'triggers':_0x55812e['childModel']='Trigger';break;case'trunks':_0x55812e[_0xabc0('0x11')]=_0xabc0('0x71');break;case _0xabc0('0x72'):_0x55812e[_0xabc0('0x11')]=_0xabc0('0x73');break;case _0xabc0('0x74'):_0x55812e[_0xabc0('0x11')]=_0xabc0('0x75');break;case _0xabc0('0x76'):_0x55812e['childModel']=_0xabc0('0xe');_0x55812e[_0xabc0('0x15')]=[{'name':'Reports','field':'id','foreignKey':_0xabc0('0x77')}];break;case'metrics':_0x55812e['childModel']=_0xabc0('0x78');break;}return _0x55812e;}function _0x2ec5cd(_0x58fa77,_0x27b045){var _0x45a2f0=_0x58fa77['charAt'](0x0)['toUpperCase']()+_0x58fa77['slice'](0x1);var _0x482345={'type':_0x4d1cf0[_0xabc0('0x79')][_0xabc0('0x7a')]['SELECT'],'raw':!![]};return new Promise(function(_0x1252be,_0x335729){var _0x5b848f=squel[_0xabc0('0x7b')]()[_0xabc0('0x3')](_0xabc0('0x7c')+_0x45a2f0+_0xabc0('0x7d'),'id')[_0xabc0('0x3')](_0xabc0('0x7e'))[_0xabc0('0x7f')]('user_has_'+_0x58fa77+'_interactions','ui')[_0xabc0('0x80')](_0xabc0('0x81'),_0x27b045['id']);return _0x4d1cf0[_0xabc0('0x82')][_0xabc0('0x83')](_0x5b848f[_0xabc0('0x84')](),_0x482345)['then'](function(_0x4347a5){_0x27b045[_0x45a2f0+_0xabc0('0x85')]=_0x4347a5;_0x1252be(_0x4347a5);})['catch'](function(_0x14afc6){_0x335729(_0x14afc6);});});}return _0xe5e0f[_0xabc0('0x86')](_0xabc0('0x87'),attributes,{'tableName':_0xabc0('0x88'),'paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x45c5a4){var _0xa6863c=require(_0xabc0('0x89'));var _0x583c20={'raw':_0x45c5a4[_0xabc0('0x83')][_0xabc0('0x8a')],'where':{}};var _0x532777={};var _0x4391b0={'count':0x0,'rows':[]};var _0x5de4f3=_0x45c5a4[_0xabc0('0x83')][_0xabc0('0x8b')];var _0x4745ce=_0x45c5a4[_0xabc0('0x83')][_0xabc0('0x8c')]||![];var _0x2ffc2a=_0x38df1d(_0x5de4f3,_0x4745ce);if(!_0x2ffc2a[_0xabc0('0x11')])throw new Error(_0xabc0('0x8d')+_0x5de4f3+'\x27');var _0x111857=[{'name':_0x5de4f3}];if(!_[_0xabc0('0x8e')](_0x2ffc2a['parentSections']))_0x111857=_0x2ffc2a['parentSections'];var _0x4953ad=[];for(var _0xfdb9aa=0x0;_0xfdb9aa<_0x111857[_0xabc0('0x8f')];_0xfdb9aa++){_0x4953ad[_0xabc0('0x90')](_0x4d1cf0[_0xabc0('0x91')][_0xabc0('0x92')]({'where':{'userProfileId':_0x45c5a4[_0xabc0('0x93')]['id'],'name':_0x111857[_0xfdb9aa][_0xabc0('0xb')]},'raw':!![]}));}return Promise[_0xabc0('0x94')](_0x4953ad)[_0xabc0('0x7')](function(_0x2a19e0){var _0x2efbb0=_[_0xabc0('0x4')](_0x2a19e0,function(_0x3843e2){return _0x3843e2?_0x3843e2:undefined;});var _0x36caf2=_[_0xabc0('0x4')](_0x111857,[_0xabc0('0x95'),!![]]);var _0x229cf1=_[_0xabc0('0x8e')](_0x2efbb0)&&_[_0xabc0('0x8e')](_0x36caf2)?null:_[_0xabc0('0x96')](_0x36caf2,_0x2efbb0);if(!_0x229cf1)return null;var _0x261412=[];for(var _0x121228=0x0;_0x121228<_0x229cf1[_0xabc0('0x8f')];_0x121228++){var _0x52be55=_['find'](_0x111857,function(_0x182dec){return _0x229cf1[_0x121228]?_0x182dec[_0xabc0('0xb')]===_0x229cf1[_0x121228][_0xabc0('0xb')]:null;});if(_0x52be55){if(_0x229cf1[_0x121228][_0xabc0('0x95')]){_0x261412['push'](_0x53cd28(_0x2ffc2a['childModel'],_0x229cf1[_0x121228]));}else{if(!_0x229cf1[_0x121228]['autoAssociation']){_0x261412[_0xabc0('0x90')](_0x3d9343(_0x52be55,_0x229cf1[_0x121228],_0x2ffc2a[_0xabc0('0x11')]));}else{if(_0x52be55['model']){_0x261412[_0xabc0('0x90')](_0x3016a8(_0x52be55,_0x229cf1[_0x121228]));}}}}}return Promise[_0xabc0('0x94')](_0x261412);})['then'](function(_0x2ca6d4){var _0x3cc544=_0x2ca6d4;var _0xcf6a4d=null;if(_0x3cc544){_0xcf6a4d=_0x3cc544['length']===0x1?_0x3cc544[0x0]:null;}if(!_0xcf6a4d&&!_0x3cc544)return _0x4391b0;var _0x32d696=_0x4d1cf0[_0x2ffc2a['childModel']][_0xabc0('0x97')];_0x532777[_0xabc0('0xa')]=_['keys'](_0x32d696);_0x532777['query']=_[_0xabc0('0x98')](_0x45c5a4[_0xabc0('0x83')]);_0x532777[_0xabc0('0x99')]=_[_0xabc0('0x9a')](_0x532777['model'],_0x532777[_0xabc0('0x83')]);_0x583c20['attributes']=_['intersection'](_0x532777['model'],_0xa6863c['fields'](_0x45c5a4['query'][_0xabc0('0x9b')]));_0x583c20[_0xabc0('0x9c')]=_0x583c20[_0xabc0('0x9c')][_0xabc0('0x8f')]?_0x583c20[_0xabc0('0x9c')]:_0x532777[_0xabc0('0xa')];if(!_0x45c5a4[_0xabc0('0x83')][_0xabc0('0x9d')](_0xabc0('0x9e'))){_0x583c20['limit']=_0xa6863c['limit'](_0x45c5a4[_0xabc0('0x83')][_0xabc0('0x9f')]);_0x583c20['offset']=_0xa6863c[_0xabc0('0xa0')](_0x45c5a4[_0xabc0('0x83')][_0xabc0('0xa0')]);}_0x583c20[_0xabc0('0xa1')]=_0xa6863c[_0xabc0('0xa2')](_0x45c5a4['query']['sort']);_0x583c20[_0xabc0('0x80')]=_0xa6863c[_0xabc0('0x99')](_[_0xabc0('0xa3')](_0x45c5a4[_0xabc0('0x83')],_0x532777[_0xabc0('0x99')]));if(_0x45c5a4['query'][_0xabc0('0x4')]){_0x583c20['where']=_[_0xabc0('0xa4')](_0x583c20[_0xabc0('0x80')],{'$or':_[_0xabc0('0x9')](_0x32d696,function(_0x242720){if(_0x242720[_0xabc0('0x36')][_0xabc0('0xa5')]!=='VIRTUAL'){var _0x4d70c4={};_0x4d70c4[_0x242720[_0xabc0('0x3')]]={'$like':'%'+_0x45c5a4[_0xabc0('0x83')][_0xabc0('0x4')]+'%'};return _0x4d70c4;}})});}var _0x47c3ef=[];var _0x5735af=null;var _0x9e7665={};if(_0xcf6a4d){_0x5735af=_['find'](_0x111857,[_0xabc0('0xb'),_0xcf6a4d[_0xabc0('0xb')]]);if(_0x5735af[_0xabc0('0x3')]){_0x9e7665={};if(_0x2ffc2a[_0xabc0('0x11')]===_0xabc0('0xe')){_0x9e7665[_0x5735af[_0xabc0('0xa6')]]=_[_0xabc0('0x9')](_0xcf6a4d[_0xabc0('0x8')],'id');}else{_0x9e7665[_0x5735af['foreignKey']]=_0xcf6a4d[_0xabc0('0x8')];}_0x47c3ef[_0xabc0('0x90')](_0x9e7665);}else{_0x583c20['where']['id']=_0xcf6a4d[_0xabc0('0x8')];}}else{for(var _0x66c53d=0x0;_0x66c53d<_0x3cc544[_0xabc0('0x8f')];_0x66c53d++){_0x5735af=_[_0xabc0('0x92')](_0x111857,[_0xabc0('0xb'),_0x3cc544[_0x66c53d]['name']]);if(_0x5735af[_0xabc0('0x3')]){_0x9e7665={};_0x9e7665[_0x5735af[_0xabc0('0xa6')]]=_0x3cc544[_0x66c53d]['associatedResources'];_0x47c3ef['push'](_0x9e7665);}else{if(!_0x583c20['where']['id'])_0x583c20[_0xabc0('0x80')]['id']=[];_0x3cc544[_0x66c53d][_0xabc0('0x8')]['forEach'](function(_0x2c647b){_0x583c20['where']['id']['push'](_0x2c647b);});}}}if(!_[_0xabc0('0x8e')](_0x47c3ef)){_0x583c20[_0xabc0('0x80')]=_['merge'](_0x583c20['where'],{'$and':{'$or':_0x47c3ef}});}_0x583c20=_[_0xabc0('0xa4')]({},_0x583c20,_0x45c5a4[_0xabc0('0xa7')]);if(_0xcf6a4d&&!_0xcf6a4d[_0xabc0('0xa8')]&&_0x2ffc2a['childModel']===_0xabc0('0xe')){if(_0x45c5a4['query'][_0xabc0('0xa9')]){_0x583c20['include']=[{'all':!![]}];}return _0x4d1cf0[_0x2ffc2a['childModel']]['findAll'](_0x583c20)[_0xabc0('0x7')](function(_0xe5b937){var _0x546721=[];_0xe5b937[_0xabc0('0xaa')](function(_0x1160c6){var _0x597cdc;switch(_0x1160c6['reportType']){case _0xabc0('0xab'):_0x597cdc=_['find'](_0xcf6a4d[_0xabc0('0x8')],function(_0x2ac5dd){return _0x2ac5dd['id']===_0x1160c6[_0xabc0('0x77')]&&_0x2ac5dd[_0xabc0('0x36')]===_0xabc0('0xac');});break;case _0xabc0('0xad'):_0x597cdc=_[_0xabc0('0x92')](_0xcf6a4d['associatedResources'],function(_0x37f42b){return _0x37f42b['id']===_0x1160c6['reportId']&&_0x37f42b[_0xabc0('0x36')]===_0xabc0('0xae');});break;}if(_0x597cdc)_0x546721[_0xabc0('0x90')](_0x1160c6);});_0x4391b0['count']=_0x546721[_0xabc0('0x8f')];_0x4391b0[_0xabc0('0xaf')]=_0x546721;return _0x4391b0;});}else{if(!_[_0xabc0('0x8e')](_0x45c5a4['query']['ids'])){_0x583c20[_0xabc0('0x80')]['id']=_0x583c20[_0xabc0('0x80')]['id']?_[_0xabc0('0x9a')](_0x583c20[_0xabc0('0x80')]['id'],_0x45c5a4[_0xabc0('0x83')][_0xabc0('0xb0')]):_0x45c5a4[_0xabc0('0x83')][_0xabc0('0xb0')];if(_0x45c5a4[_0xabc0('0x83')][_0xabc0('0xb1')]){_0x583c20[_0xabc0('0xa1')]=_0x45c5a4[_0xabc0('0x83')][_0xabc0('0xb1')];}}if(_0x45c5a4[_0xabc0('0x83')][_0xabc0('0xb2')]){_0x583c20[_0xabc0('0x80')]=_['merge'](_0x583c20[_0xabc0('0x80')],{'$and':_0x45c5a4[_0xabc0('0x83')][_0xabc0('0xb2')]});}return _0x4d1cf0[_0x2ffc2a['childModel']][_0xabc0('0xb3')]({'where':_0x583c20['where']})[_0xabc0('0x7')](function(_0x3cb430){_0x4391b0[_0xabc0('0xb3')]=_0x3cb430;if(_0x45c5a4[_0xabc0('0x83')][_0xabc0('0xa9')]){if(_0x2ffc2a['childModel']===_0xabc0('0x1a')){_0x583c20['include']=[{'model':_0x4d1cf0['Tag'],'as':'Tags','attributes':['id','name',_0xabc0('0xb4')],'required':_0x45c5a4[_0xabc0('0x83')]['tag']?!![]:![]},{'model':_0x4d1cf0[_0xabc0('0x6e')],'as':'ThroughTags','attributes':['id','name',_0xabc0('0xb4')],'through':_0x45c5a4[_0xabc0('0x83')][_0xabc0('0xb5')]?{'attributes':[],'where':{'TagId':_0x45c5a4[_0xabc0('0x83')][_0xabc0('0xb5')]||undefined}}:{},'required':_0x45c5a4[_0xabc0('0x83')]['tag']?!![]:![]}];}else{_0x583c20[_0xabc0('0xb6')]=[{'all':!![]}];}}return _0x4d1cf0[_0x2ffc2a[_0xabc0('0x11')]][_0xabc0('0x6')](_0x583c20);})['then'](function(_0x419086){_0x4391b0[_0xabc0('0xaf')]=_0x419086;if(_0x5de4f3===_0xabc0('0x2e')&&_0x45c5a4['query'][_0xabc0('0xb7')]==='true'){var _0x25adad=[];for(var _0x16530a=0x0;_0x16530a<_0x4391b0['rows'][_0xabc0('0x8f')];_0x16530a++){_0x25adad[_0xabc0('0x90')](_0x2ec5cd(_0xabc0('0xb8'),_0x4391b0['rows'][_0x16530a][_0xabc0('0xb9')]));_0x25adad[_0xabc0('0x90')](_0x2ec5cd(_0xabc0('0xba'),_0x4391b0[_0xabc0('0xaf')][_0x16530a][_0xabc0('0xb9')]));_0x25adad['push'](_0x2ec5cd(_0xabc0('0xbb'),_0x4391b0[_0xabc0('0xaf')][_0x16530a][_0xabc0('0xb9')]));_0x25adad[_0xabc0('0x90')](_0x2ec5cd(_0xabc0('0xbc'),_0x4391b0[_0xabc0('0xaf')][_0x16530a][_0xabc0('0xb9')]));_0x25adad[_0xabc0('0x90')](_0x2ec5cd(_0xabc0('0xbd'),_0x4391b0['rows'][_0x16530a][_0xabc0('0xb9')]));_0x25adad['push'](_0x2ec5cd(_0xabc0('0xbe'),_0x4391b0[_0xabc0('0xaf')][_0x16530a][_0xabc0('0xb9')]));}return Promise[_0xabc0('0x94')](_0x25adad)['then'](function(){return _0x4391b0;});}return _0x4391b0;});}});}}});};