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 _0x6e4a=['findAll','then','associatedResources','map','catch','model','name','resolve','UserProfileResource','AnalyticExtractedReport','toLowerCase','squareprojects','childModel','odbc','SquareOdbc','SquareRecording','parentSections','projectName','projects','JscriptyProject','contacts','CmContact','Lists','ListId','lists','CmList','companies','globalcustomfields','CmCustomField','chatqueues','ChatQueue','chatwebsites','ChatWebsite','faxqueues','FaxQueue','faxaccounts','FaxAccount','inboundroutes','internalroutes','VoiceExtension','contexts','VoiceContext','voicemails','VoiceMail','voicerecordings','VoiceRecording','Agents','role','membername','User','VoiceQueues','VoiceQueue','type','QueueCampaigns','queue','outbound','musiconholds','VoiceMusicOnHold','chanspies','VoiceChanSpy','VoicePrefix','Campaign','MailQueue','mailaccounts','MailAccount','mailsubstatuses','MailSubstatus','openchannelqueues','openchannelaccounts','smsqueues','SmsQueue','SmsAccount','whatsappqueues','WhatsappQueue','whatsappaccounts','teams','Team','queuecampaigns','agents','telephones','Users','admin','user','Telephones','zendeskaccounts','ZendeskAccount','salesforceaccounts','SalesforceAccount','FreshdeskAccount','sugarcrmaccounts','SugarcrmAccount','deskaccounts','DeskAccount','zohoaccounts','vtigeraccounts','cannedanswers','CannedAnswer','Disposition','customdashboards','Dashboard','intervals','Interval','pauses','Pause','scheduler','sounds','Sound','tags','Tag','templates','Template','triggers','Trigger','Trunk','Variable','Plugin','extractedreports','Reports','reportId','metrics','AnalyticMetric','toUpperCase','Sequelize','select','ui.createdAt','from','user_has_','_interactions','where','ui.UserId\x20=\x20?','sequelize','query','toString','OpenTabs','define','user_profiles','mergeResources','Invalid\x20section\x20\x27','isEmpty','UserProfileSection','params','all','ignore','union','length','find','autoAssociation','push','rawAttributes','keys','intersection','fields','attributes','hasOwnProperty','nolimit','limit','offset','sort','filters','pick','merge','VIRTUAL','foreignKey','forEach','includeAll','include','reportType','DefaultReports','custom','count','rows','ids','customSorting','order','extraQueryConditions','Tags','tag','ThroughTags','color','openTabs','true','chat','dataValues','sms','fax','mail','openchannel','whatsapp','./userProfile.attributes','squel','exports','models','filter','field'];(function(_0x26546c,_0x1f52c2){var _0x45fa97=function(_0x5dc2f1){while(--_0x5dc2f1){_0x26546c['push'](_0x26546c['shift']());}};_0x45fa97(++_0x1f52c2);}(_0x6e4a,0x17e));var _0xa6e4=function(_0x43061a,_0x367741){_0x43061a=_0x43061a-0x0;var _0x24a14a=_0x6e4a[_0x43061a];return _0x24a14a;};'use strict';var _=require('lodash');var attributes=require(_0xa6e4('0x0'));var squel=require(_0xa6e4('0x1'));module[_0xa6e4('0x2')]=function(_0xe76f7d){var _0x30d4cd=_0xe76f7d[_0xa6e4('0x3')];function _0x149a06(_0xe56421,_0x441744){return new Promise(function(_0x2ee2bd,_0x4b0802){if(!_0x441744)return _0x2ee2bd(null);var _0xa5d98f=_0x441744['filter']?{[_0x441744[_0xa6e4('0x4')][_0xa6e4('0x5')]]:_0x441744[_0xa6e4('0x4')]['value']}:undefined;return _0x30d4cd[_0xe56421][_0xa6e4('0x6')]({'where':_0xa5d98f,'raw':!![]})[_0xa6e4('0x7')](function(_0x89201c){_0x441744[_0xa6e4('0x8')]=_[_0xa6e4('0x9')](_0x89201c,'id');_0x2ee2bd(_0x441744);})[_0xa6e4('0xa')](function(_0x369fbf){_0x4b0802(_0x369fbf);});});}function _0x27fe43(_0x192228,_0x50fa82){return new Promise(function(_0x4d726b,_0x5b6bfb){var _0x198252=_0x192228[_0xa6e4('0x4')]?{[_0x192228['filter'][_0xa6e4('0x5')]]:_0x192228[_0xa6e4('0x4')]['value']}:undefined;return _0x30d4cd[_0x192228[_0xa6e4('0xb')]][_0xa6e4('0x6')]({'where':_0x198252,'raw':!![]})[_0xa6e4('0x7')](function(_0x35f52d){_0x50fa82[_0xa6e4('0x8')]=_[_0xa6e4('0x9')](_0x35f52d,function(_0x5ecfb4){return _0x5ecfb4[_0xa6e4('0xc')];});_0x4d726b(_0x50fa82);})[_0xa6e4('0xa')](function(_0x391fff){_0x5b6bfb(_0x391fff);});});}function _0x552cbf(_0x1f30da,_0x472321,_0x35556b){if(!_0x472321)return Promise[_0xa6e4('0xd')](null);return new Promise(function(_0x5214ee,_0x108eef){return _0x30d4cd[_0xa6e4('0xe')]['findAll']({'where':{'sectionId':_0x472321['id']},'raw':!![]})[_0xa6e4('0x7')](function(_0x4688bf){if(_0x1f30da[_0xa6e4('0x5')]&&_0x1f30da[_0xa6e4('0x5')]!=='id'){_0x472321[_0xa6e4('0x8')]=_['map'](_0x4688bf,function(_0x584ca0){return _0x584ca0[_0x1f30da[_0xa6e4('0x5')]];});}else{if(_0x35556b===_0xa6e4('0xf')){_0x472321['associatedResources']=_[_0xa6e4('0x9')](_0x4688bf,function(_0x14cc43){return{'id':_0x14cc43['resourceId'],'type':_0x14cc43['type']};});}else{_0x472321[_0xa6e4('0x8')]=_[_0xa6e4('0x9')](_0x4688bf,function(_0x25435c){return _0x25435c['resourceId'];});}}_0x5214ee(_0x472321);})['catch'](function(_0x71597d){_0x108eef(_0x71597d);});});}function _0x4f9da6(_0x11a2d1,_0x407d32){var _0x440d7f={'parentSections':[]};switch(_0x11a2d1[_0xa6e4('0x10')]()){case _0xa6e4('0x11'):_0x440d7f[_0xa6e4('0x12')]='SquareProject';break;case _0xa6e4('0x13'):_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x14');break;case'squarerecordings':_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x15');_0x440d7f[_0xa6e4('0x16')]=[{'name':'SquareProjects','field':_0xa6e4('0xc'),'foreignKey':_0xa6e4('0x17')}];break;case _0xa6e4('0x18'):_0x440d7f['childModel']=_0xa6e4('0x19');break;case _0xa6e4('0x1a'):_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x1b');_0x440d7f[_0xa6e4('0x16')]=[{'name':_0xa6e4('0x1c'),'field':'id','foreignKey':_0xa6e4('0x1d')}];break;case _0xa6e4('0x1e'):_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x1f');break;case _0xa6e4('0x20'):_0x440d7f[_0xa6e4('0x12')]='CmCompany';break;case _0xa6e4('0x21'):_0x440d7f['childModel']=_0xa6e4('0x22');break;case _0xa6e4('0x23'):_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x24');break;case _0xa6e4('0x25'):_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x26');break;case _0xa6e4('0x27'):_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x28');break;case _0xa6e4('0x29'):_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x2a');break;case _0xa6e4('0x2b'):case _0xa6e4('0x2c'):case'outboundroutes':_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x2d');break;case _0xa6e4('0x2e'):_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x2f');break;case _0xa6e4('0x30'):_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x31');break;case _0xa6e4('0x32'):_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x33');_0x440d7f[_0xa6e4('0x16')]=[{'name':_0xa6e4('0x34'),'field':'name','foreignKey':'membername','model':'User','filter':{'field':_0xa6e4('0x35'),'value':['agent']}},{'name':'Telephones','field':_0xa6e4('0xc'),'foreignKey':_0xa6e4('0x36'),'model':_0xa6e4('0x37'),'filter':{'field':_0xa6e4('0x35'),'value':['telephone']}},{'name':_0xa6e4('0x38'),'field':_0xa6e4('0xc'),'foreignKey':'queue','model':_0xa6e4('0x39'),'filter':{'field':_0xa6e4('0x3a'),'value':['inbound']}},{'name':_0xa6e4('0x3b'),'field':_0xa6e4('0xc'),'foreignKey':_0xa6e4('0x3c'),'model':_0xa6e4('0x39'),'filter':{'field':'type','value':[_0xa6e4('0x3d')]}}];break;case _0xa6e4('0x3e'):_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x3f');break;case _0xa6e4('0x40'):_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x41');break;case'voiceprefixes':_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x42');break;case'ivrcampaigns':_0x440d7f['childModel']=_0xa6e4('0x43');break;case'mailqueues':_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x44');break;case _0xa6e4('0x45'):_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x46');break;case _0xa6e4('0x47'):_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x48');break;case _0xa6e4('0x49'):_0x440d7f[_0xa6e4('0x12')]='OpenchannelQueue';break;case _0xa6e4('0x4a'):_0x440d7f[_0xa6e4('0x12')]='OpenchannelAccount';break;case _0xa6e4('0x4b'):_0x440d7f['childModel']=_0xa6e4('0x4c');break;case'smsaccounts':_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x4d');break;case _0xa6e4('0x4e'):_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x4f');break;case _0xa6e4('0x50'):_0x440d7f[_0xa6e4('0x12')]='WhatsappAccount';break;case _0xa6e4('0x51'):_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x52');break;case'voicequeues':case _0xa6e4('0x53'):_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x39');if(_0x407d32){_0x440d7f['parentSections']=[{'name':_0xa6e4('0x38')},{'name':_0xa6e4('0x3b')}];}break;case'users':case _0xa6e4('0x54'):case _0xa6e4('0x55'):_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x37');if(_0x407d32){_0x440d7f[_0xa6e4('0x16')]=[{'name':_0xa6e4('0x56'),'filter':{'field':'role','value':[_0xa6e4('0x57'),_0xa6e4('0x58')]},'ignore':!![]},{'name':_0xa6e4('0x34')},{'name':_0xa6e4('0x59')}];}break;case _0xa6e4('0x5a'):_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x5b');break;case _0xa6e4('0x5c'):_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x5d');break;case'freshdeskaccounts':_0x440d7f['childModel']=_0xa6e4('0x5e');break;case _0xa6e4('0x5f'):_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x60');break;case _0xa6e4('0x61'):_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x62');break;case _0xa6e4('0x63'):_0x440d7f[_0xa6e4('0x12')]='ZohoAccount';break;case _0xa6e4('0x64'):_0x440d7f['childModel']=_0xa6e4('0x37');break;case _0xa6e4('0x65'):_0x440d7f['childModel']=_0xa6e4('0x66');break;case'dispositions':_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x67');break;case _0xa6e4('0x68'):_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x69');break;case _0xa6e4('0x6a'):_0x440d7f['childModel']=_0xa6e4('0x6b');break;case _0xa6e4('0x6c'):_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x6d');break;case _0xa6e4('0x6e'):_0x440d7f[_0xa6e4('0x12')]='Schedule';break;case _0xa6e4('0x6f'):_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x70');break;case _0xa6e4('0x71'):_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x72');break;case _0xa6e4('0x73'):_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x74');break;case _0xa6e4('0x75'):_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x76');break;case'trunks':_0x440d7f['childModel']=_0xa6e4('0x77');break;case'variables':_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x78');break;case'plugins':_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x79');break;case _0xa6e4('0x7a'):_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0xf');_0x440d7f[_0xa6e4('0x16')]=[{'name':_0xa6e4('0x7b'),'field':'id','foreignKey':_0xa6e4('0x7c')}];break;case _0xa6e4('0x7d'):_0x440d7f[_0xa6e4('0x12')]=_0xa6e4('0x7e');break;}return _0x440d7f;}function _0x104658(_0x16d2b7,_0x343e3b){var _0x5700c6=_0x16d2b7['charAt'](0x0)[_0xa6e4('0x7f')]()+_0x16d2b7['slice'](0x1);var _0x12b13c={'type':_0x30d4cd[_0xa6e4('0x80')]['QueryTypes']['SELECT'],'raw':!![]};return new Promise(function(_0x1d7e3a,_0x3f9521){var _0x18e2c9=squel[_0xa6e4('0x81')]()['field']('ui.'+_0x5700c6+'InteractionId','id')['field'](_0xa6e4('0x82'))[_0xa6e4('0x83')](_0xa6e4('0x84')+_0x16d2b7+_0xa6e4('0x85'),'ui')[_0xa6e4('0x86')](_0xa6e4('0x87'),_0x343e3b['id']);return _0x30d4cd[_0xa6e4('0x88')][_0xa6e4('0x89')](_0x18e2c9[_0xa6e4('0x8a')](),_0x12b13c)['then'](function(_0x49246f){_0x343e3b[_0x5700c6+_0xa6e4('0x8b')]=_0x49246f;_0x1d7e3a(_0x49246f);})[_0xa6e4('0xa')](function(_0x4d6d10){_0x3f9521(_0x4d6d10);});});}return _0xe76f7d[_0xa6e4('0x8c')]('UserProfile',attributes,{'tableName':_0xa6e4('0x8d'),'paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0xb18b9a){var _0x1d7e50=require('../../components/parsers/qs');var _0x22ec03={'raw':_0xb18b9a[_0xa6e4('0x89')]['raw'],'where':{}};var _0x1e8468={};var _0x269617={'count':0x0,'rows':[]};var _0x24ac4a=_0xb18b9a[_0xa6e4('0x89')]['section'];var _0x659ae9=_0xb18b9a['query'][_0xa6e4('0x8e')]||![];var _0x298d25=_0x4f9da6(_0x24ac4a,_0x659ae9);if(!_0x298d25[_0xa6e4('0x12')])throw new Error(_0xa6e4('0x8f')+_0x24ac4a+'\x27');var _0x3b8cab=[{'name':_0x24ac4a}];if(!_[_0xa6e4('0x90')](_0x298d25[_0xa6e4('0x16')]))_0x3b8cab=_0x298d25['parentSections'];var _0x3fee84=[];for(var _0x551b9b=0x0;_0x551b9b<_0x3b8cab['length'];_0x551b9b++){_0x3fee84['push'](_0x30d4cd[_0xa6e4('0x91')]['find']({'where':{'userProfileId':_0xb18b9a[_0xa6e4('0x92')]['id'],'name':_0x3b8cab[_0x551b9b]['name']},'raw':!![]}));}return Promise[_0xa6e4('0x93')](_0x3fee84)['then'](function(_0x3e3bc6){var _0x1fa969=_[_0xa6e4('0x4')](_0x3e3bc6,function(_0x3053a7){return _0x3053a7?_0x3053a7:undefined;});var _0x28bf7f=_[_0xa6e4('0x4')](_0x3b8cab,[_0xa6e4('0x94'),!![]]);var _0x3545ee=_[_0xa6e4('0x90')](_0x1fa969)&&_[_0xa6e4('0x90')](_0x28bf7f)?null:_[_0xa6e4('0x95')](_0x28bf7f,_0x1fa969);if(!_0x3545ee)return null;var _0x524d52=[];for(var _0x2ee002=0x0;_0x2ee002<_0x3545ee[_0xa6e4('0x96')];_0x2ee002++){var _0x5eb1d9=_[_0xa6e4('0x97')](_0x3b8cab,function(_0x3105e5){return _0x3545ee[_0x2ee002]?_0x3105e5[_0xa6e4('0xc')]===_0x3545ee[_0x2ee002][_0xa6e4('0xc')]:null;});if(_0x5eb1d9){if(_0x3545ee[_0x2ee002][_0xa6e4('0x94')]){_0x524d52['push'](_0x149a06(_0x298d25[_0xa6e4('0x12')],_0x3545ee[_0x2ee002]));}else{if(!_0x3545ee[_0x2ee002][_0xa6e4('0x98')]){_0x524d52[_0xa6e4('0x99')](_0x552cbf(_0x5eb1d9,_0x3545ee[_0x2ee002],_0x298d25[_0xa6e4('0x12')]));}else{if(_0x5eb1d9[_0xa6e4('0xb')]){_0x524d52[_0xa6e4('0x99')](_0x27fe43(_0x5eb1d9,_0x3545ee[_0x2ee002]));}}}}}return Promise[_0xa6e4('0x93')](_0x524d52);})['then'](function(_0x96cf51){var _0x1123e6=_0x96cf51;var _0x448ed0=null;if(_0x1123e6){_0x448ed0=_0x1123e6[_0xa6e4('0x96')]===0x1?_0x1123e6[0x0]:null;}if(!_0x448ed0&&!_0x1123e6)return _0x269617;var _0x6100c6=_0x30d4cd[_0x298d25[_0xa6e4('0x12')]][_0xa6e4('0x9a')];_0x1e8468[_0xa6e4('0xb')]=_[_0xa6e4('0x9b')](_0x6100c6);_0x1e8468[_0xa6e4('0x89')]=_[_0xa6e4('0x9b')](_0xb18b9a[_0xa6e4('0x89')]);_0x1e8468['filters']=_[_0xa6e4('0x9c')](_0x1e8468[_0xa6e4('0xb')],_0x1e8468[_0xa6e4('0x89')]);_0x22ec03['attributes']=_[_0xa6e4('0x9c')](_0x1e8468['model'],_0x1d7e50[_0xa6e4('0x9d')](_0xb18b9a[_0xa6e4('0x89')][_0xa6e4('0x9d')]));_0x22ec03[_0xa6e4('0x9e')]=_0x22ec03[_0xa6e4('0x9e')][_0xa6e4('0x96')]?_0x22ec03['attributes']:_0x1e8468[_0xa6e4('0xb')];if(!_0xb18b9a[_0xa6e4('0x89')][_0xa6e4('0x9f')](_0xa6e4('0xa0'))){_0x22ec03[_0xa6e4('0xa1')]=_0x1d7e50[_0xa6e4('0xa1')](_0xb18b9a[_0xa6e4('0x89')][_0xa6e4('0xa1')]);_0x22ec03[_0xa6e4('0xa2')]=_0x1d7e50[_0xa6e4('0xa2')](_0xb18b9a['query'][_0xa6e4('0xa2')]);}_0x22ec03['order']=_0x1d7e50[_0xa6e4('0xa3')](_0xb18b9a[_0xa6e4('0x89')][_0xa6e4('0xa3')]);_0x22ec03[_0xa6e4('0x86')]=_0x1d7e50[_0xa6e4('0xa4')](_[_0xa6e4('0xa5')](_0xb18b9a[_0xa6e4('0x89')],_0x1e8468['filters']));if(_0xb18b9a[_0xa6e4('0x89')][_0xa6e4('0x4')]){_0x22ec03[_0xa6e4('0x86')]=_[_0xa6e4('0xa6')](_0x22ec03[_0xa6e4('0x86')],{'$or':_[_0xa6e4('0x9')](_0x6100c6,function(_0x16b2f4){if(_0x16b2f4[_0xa6e4('0x3a')]['key']!==_0xa6e4('0xa7')){var _0x8d5410={};_0x8d5410[_0x16b2f4[_0xa6e4('0x5')]]={'$like':'%'+_0xb18b9a[_0xa6e4('0x89')][_0xa6e4('0x4')]+'%'};return _0x8d5410;}})});}var _0x229fe6=[];var _0x1031ce=null;var _0x4320aa={};if(_0x448ed0){_0x1031ce=_[_0xa6e4('0x97')](_0x3b8cab,[_0xa6e4('0xc'),_0x448ed0[_0xa6e4('0xc')]]);if(_0x1031ce['field']){_0x4320aa={};if(_0x298d25[_0xa6e4('0x12')]==='AnalyticExtractedReport'){_0x4320aa[_0x1031ce['foreignKey']]=_[_0xa6e4('0x9')](_0x448ed0[_0xa6e4('0x8')],'id');}else{_0x4320aa[_0x1031ce[_0xa6e4('0xa8')]]=_0x448ed0[_0xa6e4('0x8')];}_0x229fe6['push'](_0x4320aa);}else{_0x22ec03['where']['id']=_0x448ed0['associatedResources'];}}else{for(var _0x7ffe80=0x0;_0x7ffe80<_0x1123e6[_0xa6e4('0x96')];_0x7ffe80++){_0x1031ce=_[_0xa6e4('0x97')](_0x3b8cab,[_0xa6e4('0xc'),_0x1123e6[_0x7ffe80]['name']]);if(_0x1031ce[_0xa6e4('0x5')]){_0x4320aa={};_0x4320aa[_0x1031ce[_0xa6e4('0xa8')]]=_0x1123e6[_0x7ffe80]['associatedResources'];_0x229fe6[_0xa6e4('0x99')](_0x4320aa);}else{if(!_0x22ec03[_0xa6e4('0x86')]['id'])_0x22ec03['where']['id']=[];_0x1123e6[_0x7ffe80][_0xa6e4('0x8')][_0xa6e4('0xa9')](function(_0x5c91d3){_0x22ec03['where']['id'][_0xa6e4('0x99')](_0x5c91d3);});}}}if(!_[_0xa6e4('0x90')](_0x229fe6)){_0x22ec03[_0xa6e4('0x86')]=_[_0xa6e4('0xa6')](_0x22ec03[_0xa6e4('0x86')],{'$and':{'$or':_0x229fe6}});}_0x22ec03=_[_0xa6e4('0xa6')]({},_0x22ec03,_0xb18b9a['options']);if(_0x448ed0&&!_0x448ed0[_0xa6e4('0x98')]&&_0x298d25['childModel']===_0xa6e4('0xf')){if(_0xb18b9a['query'][_0xa6e4('0xaa')]){_0x22ec03[_0xa6e4('0xab')]=[{'all':!![]}];}return _0x30d4cd[_0x298d25['childModel']][_0xa6e4('0x6')](_0x22ec03)['then'](function(_0x4d527d){var _0x3ace07=[];_0x4d527d[_0xa6e4('0xa9')](function(_0x35e0e2){var _0x259c2c;switch(_0x35e0e2[_0xa6e4('0xac')]){case'default':_0x259c2c=_[_0xa6e4('0x97')](_0x448ed0[_0xa6e4('0x8')],function(_0x39d6c2){return _0x39d6c2['id']===_0x35e0e2[_0xa6e4('0x7c')]&&_0x39d6c2[_0xa6e4('0x3a')]===_0xa6e4('0xad');});break;case _0xa6e4('0xae'):_0x259c2c=_['find'](_0x448ed0['associatedResources'],function(_0x2249d2){return _0x2249d2['id']===_0x35e0e2[_0xa6e4('0x7c')]&&_0x2249d2[_0xa6e4('0x3a')]==='CustomReports';});break;}if(_0x259c2c)_0x3ace07['push'](_0x35e0e2);});_0x269617[_0xa6e4('0xaf')]=_0x3ace07['length'];_0x269617[_0xa6e4('0xb0')]=_0x3ace07;return _0x269617;});}else{if(!_[_0xa6e4('0x90')](_0xb18b9a['query']['ids'])){_0x22ec03[_0xa6e4('0x86')]['id']=_0x22ec03[_0xa6e4('0x86')]['id']?_[_0xa6e4('0x9c')](_0x22ec03[_0xa6e4('0x86')]['id'],_0xb18b9a[_0xa6e4('0x89')]['ids']):_0xb18b9a['query'][_0xa6e4('0xb1')];if(_0xb18b9a[_0xa6e4('0x89')][_0xa6e4('0xb2')]){_0x22ec03[_0xa6e4('0xb3')]=_0xb18b9a[_0xa6e4('0x89')]['customSorting'];}}if(_0xb18b9a['query'][_0xa6e4('0xb4')]){_0x22ec03[_0xa6e4('0x86')]=_[_0xa6e4('0xa6')](_0x22ec03[_0xa6e4('0x86')],{'$and':_0xb18b9a[_0xa6e4('0x89')][_0xa6e4('0xb4')]});}return _0x30d4cd[_0x298d25['childModel']][_0xa6e4('0xaf')]({'where':_0x22ec03[_0xa6e4('0x86')]})[_0xa6e4('0x7')](function(_0x29f36c){_0x269617['count']=_0x29f36c;if(_0xb18b9a['query']['includeAll']){if(_0x298d25['childModel']===_0xa6e4('0x1b')){_0x22ec03['include']=[{'model':_0x30d4cd[_0xa6e4('0x72')],'as':_0xa6e4('0xb5'),'attributes':['id',_0xa6e4('0xc'),'color'],'required':_0xb18b9a['query'][_0xa6e4('0xb6')]?!![]:![]},{'model':_0x30d4cd[_0xa6e4('0x72')],'as':_0xa6e4('0xb7'),'attributes':['id',_0xa6e4('0xc'),_0xa6e4('0xb8')],'through':_0xb18b9a[_0xa6e4('0x89')][_0xa6e4('0xb6')]?{'attributes':[],'where':{'TagId':_0xb18b9a['query'][_0xa6e4('0xb6')]||undefined}}:{},'required':_0xb18b9a[_0xa6e4('0x89')][_0xa6e4('0xb6')]?!![]:![]}];}else{_0x22ec03[_0xa6e4('0xab')]=[{'all':!![]}];}}return _0x30d4cd[_0x298d25['childModel']][_0xa6e4('0x6')](_0x22ec03);})['then'](function(_0x50f37c){_0x269617[_0xa6e4('0xb0')]=_0x50f37c;if(_0x24ac4a===_0xa6e4('0x34')&&_0xb18b9a[_0xa6e4('0x89')][_0xa6e4('0xb9')]===_0xa6e4('0xba')){var _0xfaf12a=[];for(var _0x38d8e5=0x0;_0x38d8e5<_0x269617[_0xa6e4('0xb0')][_0xa6e4('0x96')];_0x38d8e5++){_0xfaf12a[_0xa6e4('0x99')](_0x104658(_0xa6e4('0xbb'),_0x269617[_0xa6e4('0xb0')][_0x38d8e5][_0xa6e4('0xbc')]));_0xfaf12a['push'](_0x104658(_0xa6e4('0xbd'),_0x269617[_0xa6e4('0xb0')][_0x38d8e5][_0xa6e4('0xbc')]));_0xfaf12a[_0xa6e4('0x99')](_0x104658(_0xa6e4('0xbe'),_0x269617[_0xa6e4('0xb0')][_0x38d8e5]['dataValues']));_0xfaf12a[_0xa6e4('0x99')](_0x104658(_0xa6e4('0xbf'),_0x269617[_0xa6e4('0xb0')][_0x38d8e5][_0xa6e4('0xbc')]));_0xfaf12a[_0xa6e4('0x99')](_0x104658(_0xa6e4('0xc0'),_0x269617['rows'][_0x38d8e5]['dataValues']));_0xfaf12a[_0xa6e4('0x99')](_0x104658(_0xa6e4('0xc1'),_0x269617[_0xa6e4('0xb0')][_0x38d8e5][_0xa6e4('0xbc')]));}return Promise[_0xa6e4('0x93')](_0xfaf12a)[_0xa6e4('0x7')](function(){return _0x269617;});}return _0x269617;});}});}}});};