d31c4a02de7d7df0378e81eab30c8f92da2cb40a
[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 _0xed17=['telephones','Users','zendeskaccounts','ZendeskAccount','salesforceaccounts','SalesforceAccount','sugarcrmaccounts','SugarcrmAccount','deskaccounts','DeskAccount','CannedAnswer','Disposition','intervals','Interval','pauses','Pause','scheduler','Schedule','Sound','tags','Template','triggers','Trigger','trunks','Trunk','Variable','plugins','extractedreports','AnalyticExtractedReport','Reports','reportId','AnalyticMetric','toUpperCase','QueryTypes','select','ui.','InteractionId','ui.createdAt','from','user_has_','_interactions','where','ui.UserId\x20=\x20?','sequelize','query','toString','OpenTabs','define','UserProfile','user_profiles','raw','Invalid\x20section\x20\x27','isEmpty','push','UserProfileSection','find','params','union','ignore','autoAssociation','all','length','rawAttributes','keys','filters','model','attributes','intersection','fields','hasOwnProperty','limit','offset','order','sort','pick','key','VIRTUAL','foreignKey','forEach','merge','options','includeAll','reportType','default','DefaultReports','custom','count','rows','include','Tag','Tags','tag','ThroughTags','Agents','openTabs','true','chat','sms','fax','dataValues','mail','openchannel','whatsapp','lodash','../../components/parsers/qs','squel','exports','filter','field','value','then','associatedResources','catch','findAll','name','UserProfileResource','map','resourceId','type','squareprojects','SquareProject','odbc','childModel','SquareOdbc','SquareRecording','parentSections','SquareProjects','projects','JscriptyProject','Lists','ListId','lists','CmList','companies','CmCompany','globalcustomfields','CmCustomField','chatqueues','chatwebsites','FaxQueue','faxaccounts','FaxAccount','inboundroutes','internalroutes','outboundroutes','contexts','VoiceContext','VoiceMail','voicerecordings','membername','User','role','agent','Telephones','VoiceQueues','inbound','QueueCampaigns','VoiceQueue','outbound','musiconholds','VoiceMusicOnHold','chanspies','VoiceChanSpy','voiceprefixes','VoicePrefix','ivrcampaigns','Campaign','MailQueue','mailaccounts','mailsubstatuses','MailSubstatus','openchannelqueues','OpenchannelQueue','OpenchannelAccount','SmsQueue','smsaccounts','whatsappqueues','WhatsappQueue','whatsappaccounts','WhatsappAccount','teams','Team','queuecampaigns','users'];(function(_0x4ec339,_0x22430f){var _0x4e0e80=function(_0x321374){while(--_0x321374){_0x4ec339['push'](_0x4ec339['shift']());}};_0x4e0e80(++_0x22430f);}(_0xed17,0x67));var _0x7ed1=function(_0x540315,_0x5e4286){_0x540315=_0x540315-0x0;var _0x45b752=_0xed17[_0x540315];return _0x45b752;};'use strict';var _=require(_0x7ed1('0x0'));var attributes=require('./userProfile.attributes');var qs=require(_0x7ed1('0x1'));var squel=require(_0x7ed1('0x2'));module[_0x7ed1('0x3')]=function(_0x1c90be){var _0x149413=_0x1c90be['models'];function _0x29adfd(_0x545306,_0x47fc8f){return new Promise(function(_0x5c8309,_0x1b77a4){if(!_0x47fc8f)return _0x5c8309(null);var _0x1dcde7=_0x47fc8f[_0x7ed1('0x4')]?{[_0x47fc8f['filter'][_0x7ed1('0x5')]]:_0x47fc8f[_0x7ed1('0x4')][_0x7ed1('0x6')]}:undefined;return _0x149413[_0x545306]['findAll']({'where':_0x1dcde7,'raw':!![]})[_0x7ed1('0x7')](function(_0x477d93){_0x47fc8f[_0x7ed1('0x8')]=_['map'](_0x477d93,'id');_0x5c8309(_0x47fc8f);})[_0x7ed1('0x9')](function(_0x1ff213){_0x1b77a4(_0x1ff213);});});}function _0x2fca6f(_0x574176,_0x1036c0){return new Promise(function(_0x2c0f01,_0x3b0222){var _0x476129=_0x574176[_0x7ed1('0x4')]?{[_0x574176['filter'][_0x7ed1('0x5')]]:_0x574176['filter']['value']}:undefined;return _0x149413[_0x574176['model']][_0x7ed1('0xa')]({'where':_0x476129,'raw':!![]})[_0x7ed1('0x7')](function(_0x93b0cf){_0x1036c0[_0x7ed1('0x8')]=_['map'](_0x93b0cf,function(_0x21ee51){return _0x21ee51[_0x7ed1('0xb')];});_0x2c0f01(_0x1036c0);})[_0x7ed1('0x9')](function(_0x13641b){_0x3b0222(_0x13641b);});});}function _0x16f09d(_0x5e867b,_0x38dd17,_0x59ca4){if(!_0x38dd17)return Promise['resolve'](null);return new Promise(function(_0x3ddadb,_0x3e898f){return _0x149413[_0x7ed1('0xc')][_0x7ed1('0xa')]({'where':{'sectionId':_0x38dd17['id']},'raw':!![]})['then'](function(_0x58056a){if(_0x5e867b[_0x7ed1('0x5')]&&_0x5e867b['field']!=='id'){_0x38dd17[_0x7ed1('0x8')]=_['map'](_0x58056a,function(_0x103bd7){return _0x103bd7[_0x5e867b[_0x7ed1('0x5')]];});}else{if(_0x59ca4==='AnalyticExtractedReport'){_0x38dd17[_0x7ed1('0x8')]=_[_0x7ed1('0xd')](_0x58056a,function(_0x590807){return{'id':_0x590807[_0x7ed1('0xe')],'type':_0x590807[_0x7ed1('0xf')]};});}else{_0x38dd17[_0x7ed1('0x8')]=_[_0x7ed1('0xd')](_0x58056a,function(_0x2de566){return _0x2de566[_0x7ed1('0xe')];});}}_0x3ddadb(_0x38dd17);})[_0x7ed1('0x9')](function(_0x50d65a){_0x3e898f(_0x50d65a);});});}function _0x1b1b4d(_0x2cb8fe,_0x20eb9f){var _0x2d5e9a={'parentSections':[]};switch(_0x2cb8fe['toLowerCase']()){case _0x7ed1('0x10'):_0x2d5e9a['childModel']=_0x7ed1('0x11');break;case _0x7ed1('0x12'):_0x2d5e9a[_0x7ed1('0x13')]=_0x7ed1('0x14');break;case'squarerecordings':_0x2d5e9a[_0x7ed1('0x13')]=_0x7ed1('0x15');_0x2d5e9a[_0x7ed1('0x16')]=[{'name':_0x7ed1('0x17'),'field':'name','foreignKey':'projectName'}];break;case _0x7ed1('0x18'):_0x2d5e9a[_0x7ed1('0x13')]=_0x7ed1('0x19');break;case'contacts':_0x2d5e9a[_0x7ed1('0x13')]='CmContact';_0x2d5e9a[_0x7ed1('0x16')]=[{'name':_0x7ed1('0x1a'),'field':'id','foreignKey':_0x7ed1('0x1b')}];break;case _0x7ed1('0x1c'):_0x2d5e9a[_0x7ed1('0x13')]=_0x7ed1('0x1d');break;case _0x7ed1('0x1e'):_0x2d5e9a[_0x7ed1('0x13')]=_0x7ed1('0x1f');break;case _0x7ed1('0x20'):_0x2d5e9a['childModel']=_0x7ed1('0x21');break;case _0x7ed1('0x22'):_0x2d5e9a[_0x7ed1('0x13')]='ChatQueue';break;case _0x7ed1('0x23'):_0x2d5e9a['childModel']='ChatWebsite';break;case'faxqueues':_0x2d5e9a['childModel']=_0x7ed1('0x24');break;case _0x7ed1('0x25'):_0x2d5e9a[_0x7ed1('0x13')]=_0x7ed1('0x26');break;case _0x7ed1('0x27'):case _0x7ed1('0x28'):case _0x7ed1('0x29'):_0x2d5e9a[_0x7ed1('0x13')]='VoiceExtension';break;case _0x7ed1('0x2a'):_0x2d5e9a[_0x7ed1('0x13')]=_0x7ed1('0x2b');break;case'voicemails':_0x2d5e9a[_0x7ed1('0x13')]=_0x7ed1('0x2c');break;case _0x7ed1('0x2d'):_0x2d5e9a['childModel']='VoiceRecording';_0x2d5e9a[_0x7ed1('0x16')]=[{'name':'Agents','field':'name','foreignKey':_0x7ed1('0x2e'),'model':_0x7ed1('0x2f'),'filter':{'field':_0x7ed1('0x30'),'value':[_0x7ed1('0x31')]}},{'name':_0x7ed1('0x32'),'field':_0x7ed1('0xb'),'foreignKey':_0x7ed1('0x2e'),'model':_0x7ed1('0x2f'),'filter':{'field':'role','value':['telephone']}},{'name':_0x7ed1('0x33'),'field':_0x7ed1('0xb'),'foreignKey':'queue','model':'VoiceQueue','filter':{'field':_0x7ed1('0xf'),'value':[_0x7ed1('0x34')]}},{'name':_0x7ed1('0x35'),'field':_0x7ed1('0xb'),'foreignKey':'queue','model':_0x7ed1('0x36'),'filter':{'field':'type','value':[_0x7ed1('0x37')]}}];break;case _0x7ed1('0x38'):_0x2d5e9a[_0x7ed1('0x13')]=_0x7ed1('0x39');break;case _0x7ed1('0x3a'):_0x2d5e9a[_0x7ed1('0x13')]=_0x7ed1('0x3b');break;case _0x7ed1('0x3c'):_0x2d5e9a[_0x7ed1('0x13')]=_0x7ed1('0x3d');break;case _0x7ed1('0x3e'):_0x2d5e9a[_0x7ed1('0x13')]=_0x7ed1('0x3f');break;case'mailqueues':_0x2d5e9a['childModel']=_0x7ed1('0x40');break;case _0x7ed1('0x41'):_0x2d5e9a[_0x7ed1('0x13')]='MailAccount';break;case _0x7ed1('0x42'):_0x2d5e9a['childModel']=_0x7ed1('0x43');break;case _0x7ed1('0x44'):_0x2d5e9a['childModel']=_0x7ed1('0x45');break;case'openchannelaccounts':_0x2d5e9a[_0x7ed1('0x13')]=_0x7ed1('0x46');break;case'smsqueues':_0x2d5e9a[_0x7ed1('0x13')]=_0x7ed1('0x47');break;case _0x7ed1('0x48'):_0x2d5e9a[_0x7ed1('0x13')]='SmsAccount';break;case _0x7ed1('0x49'):_0x2d5e9a['childModel']=_0x7ed1('0x4a');break;case _0x7ed1('0x4b'):_0x2d5e9a[_0x7ed1('0x13')]=_0x7ed1('0x4c');break;case _0x7ed1('0x4d'):_0x2d5e9a['childModel']=_0x7ed1('0x4e');break;case'voicequeues':case _0x7ed1('0x4f'):_0x2d5e9a[_0x7ed1('0x13')]='VoiceQueue';if(_0x20eb9f){_0x2d5e9a[_0x7ed1('0x16')]=[{'name':'VoiceQueues'},{'name':_0x7ed1('0x35')}];}break;case _0x7ed1('0x50'):case'agents':case _0x7ed1('0x51'):_0x2d5e9a[_0x7ed1('0x13')]='User';if(_0x20eb9f){_0x2d5e9a[_0x7ed1('0x16')]=[{'name':_0x7ed1('0x52'),'filter':{'field':_0x7ed1('0x30'),'value':['admin','user']},'ignore':!![]},{'name':'Agents'},{'name':_0x7ed1('0x32')}];}break;case _0x7ed1('0x53'):_0x2d5e9a[_0x7ed1('0x13')]=_0x7ed1('0x54');break;case _0x7ed1('0x55'):_0x2d5e9a[_0x7ed1('0x13')]=_0x7ed1('0x56');break;case'freshdeskaccounts':_0x2d5e9a[_0x7ed1('0x13')]='FreshdeskAccount';break;case _0x7ed1('0x57'):_0x2d5e9a['childModel']=_0x7ed1('0x58');break;case _0x7ed1('0x59'):_0x2d5e9a['childModel']=_0x7ed1('0x5a');break;case'zohoaccounts':_0x2d5e9a[_0x7ed1('0x13')]='ZohoAccount';break;case'vtigeraccounts':_0x2d5e9a['childModel']=_0x7ed1('0x2f');break;case'cannedanswers':_0x2d5e9a[_0x7ed1('0x13')]=_0x7ed1('0x5b');break;case'dispositions':_0x2d5e9a[_0x7ed1('0x13')]=_0x7ed1('0x5c');break;case'customdashboards':_0x2d5e9a[_0x7ed1('0x13')]='Dashboard';break;case _0x7ed1('0x5d'):_0x2d5e9a[_0x7ed1('0x13')]=_0x7ed1('0x5e');break;case _0x7ed1('0x5f'):_0x2d5e9a['childModel']=_0x7ed1('0x60');break;case _0x7ed1('0x61'):_0x2d5e9a[_0x7ed1('0x13')]=_0x7ed1('0x62');break;case'sounds':_0x2d5e9a[_0x7ed1('0x13')]=_0x7ed1('0x63');break;case _0x7ed1('0x64'):_0x2d5e9a['childModel']='Tag';break;case'templates':_0x2d5e9a[_0x7ed1('0x13')]=_0x7ed1('0x65');break;case _0x7ed1('0x66'):_0x2d5e9a['childModel']=_0x7ed1('0x67');break;case _0x7ed1('0x68'):_0x2d5e9a[_0x7ed1('0x13')]=_0x7ed1('0x69');break;case'variables':_0x2d5e9a['childModel']=_0x7ed1('0x6a');break;case _0x7ed1('0x6b'):_0x2d5e9a[_0x7ed1('0x13')]='Plugin';break;case _0x7ed1('0x6c'):_0x2d5e9a[_0x7ed1('0x13')]=_0x7ed1('0x6d');_0x2d5e9a[_0x7ed1('0x16')]=[{'name':_0x7ed1('0x6e'),'field':'id','foreignKey':_0x7ed1('0x6f')}];break;case'metrics':_0x2d5e9a[_0x7ed1('0x13')]=_0x7ed1('0x70');break;}return _0x2d5e9a;}function _0x5f2ae3(_0x284639,_0xf91833){var _0x5d5b65=_0x284639['charAt'](0x0)[_0x7ed1('0x71')]()+_0x284639['slice'](0x1);var _0x1deae6={'type':_0x149413['Sequelize'][_0x7ed1('0x72')]['SELECT'],'raw':!![]};return new Promise(function(_0x4ac306,_0x39ee6c){var _0x3ee4f8=squel[_0x7ed1('0x73')]()[_0x7ed1('0x5')](_0x7ed1('0x74')+_0x5d5b65+_0x7ed1('0x75'),'id')[_0x7ed1('0x5')](_0x7ed1('0x76'))[_0x7ed1('0x77')](_0x7ed1('0x78')+_0x284639+_0x7ed1('0x79'),'ui')[_0x7ed1('0x7a')](_0x7ed1('0x7b'),_0xf91833['id']);return _0x149413[_0x7ed1('0x7c')][_0x7ed1('0x7d')](_0x3ee4f8[_0x7ed1('0x7e')](),_0x1deae6)['then'](function(_0x270c87){_0xf91833[_0x5d5b65+_0x7ed1('0x7f')]=_0x270c87;_0x4ac306(_0x270c87);})['catch'](function(_0x2d8c34){_0x39ee6c(_0x2d8c34);});});}return _0x1c90be[_0x7ed1('0x80')](_0x7ed1('0x81'),attributes,{'tableName':_0x7ed1('0x82'),'paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x4a02bb){var _0x3fc1ec={'raw':_0x4a02bb[_0x7ed1('0x7d')][_0x7ed1('0x83')],'where':{}};var _0x3456c3={};var _0x123f61={'count':0x0,'rows':[]};var _0x3d0d56=_0x4a02bb['query']['section'];var _0x5a7179=_0x4a02bb[_0x7ed1('0x7d')]['mergeResources']||![];var _0x5a06fe=_0x1b1b4d(_0x3d0d56,_0x5a7179);if(!_0x5a06fe[_0x7ed1('0x13')])throw new Error(_0x7ed1('0x84')+_0x3d0d56+'\x27');var _0x3142fc=[{'name':_0x3d0d56}];if(!_[_0x7ed1('0x85')](_0x5a06fe[_0x7ed1('0x16')]))_0x3142fc=_0x5a06fe[_0x7ed1('0x16')];var _0x1dc101=[];for(var _0x3e71d9=0x0;_0x3e71d9<_0x3142fc['length'];_0x3e71d9++){_0x1dc101[_0x7ed1('0x86')](_0x149413[_0x7ed1('0x87')][_0x7ed1('0x88')]({'where':{'userProfileId':_0x4a02bb[_0x7ed1('0x89')]['id'],'name':_0x3142fc[_0x3e71d9][_0x7ed1('0xb')]},'raw':!![]}));}return Promise['all'](_0x1dc101)[_0x7ed1('0x7')](function(_0x17121c){var _0x1e5f8c=_['filter'](_0x17121c,function(_0x40b6fe){return _0x40b6fe?_0x40b6fe:undefined;});var _0x31c42c=_['filter'](_0x3142fc,['ignore',!![]]);var _0x28bf05=_[_0x7ed1('0x85')](_0x1e5f8c)&&_[_0x7ed1('0x85')](_0x31c42c)?null:_[_0x7ed1('0x8a')](_0x31c42c,_0x1e5f8c);if(!_0x28bf05)return null;var _0xe9084c=[];for(var _0xb8e96b=0x0;_0xb8e96b<_0x28bf05['length'];_0xb8e96b++){var _0x11532e=_[_0x7ed1('0x88')](_0x3142fc,function(_0x5848dc){return _0x28bf05[_0xb8e96b]?_0x5848dc[_0x7ed1('0xb')]===_0x28bf05[_0xb8e96b]['name']:null;});if(_0x11532e){if(_0x28bf05[_0xb8e96b][_0x7ed1('0x8b')]){_0xe9084c[_0x7ed1('0x86')](_0x29adfd(_0x5a06fe[_0x7ed1('0x13')],_0x28bf05[_0xb8e96b]));}else{if(!_0x28bf05[_0xb8e96b][_0x7ed1('0x8c')]){_0xe9084c[_0x7ed1('0x86')](_0x16f09d(_0x11532e,_0x28bf05[_0xb8e96b],_0x5a06fe[_0x7ed1('0x13')]));}else{if(_0x11532e['model']){_0xe9084c[_0x7ed1('0x86')](_0x2fca6f(_0x11532e,_0x28bf05[_0xb8e96b]));}}}}}return Promise[_0x7ed1('0x8d')](_0xe9084c);})[_0x7ed1('0x7')](function(_0x472769){var _0x569c02=_0x472769;var _0x59fe87=null;if(_0x569c02){_0x59fe87=_0x569c02[_0x7ed1('0x8e')]===0x1?_0x569c02[0x0]:null;}if(!_0x59fe87&&!_0x569c02)return _0x123f61;var _0x6f4d10=_0x149413[_0x5a06fe[_0x7ed1('0x13')]][_0x7ed1('0x8f')];_0x3456c3['model']=_['keys'](_0x6f4d10);_0x3456c3[_0x7ed1('0x7d')]=_[_0x7ed1('0x90')](_0x4a02bb[_0x7ed1('0x7d')]);_0x3456c3[_0x7ed1('0x91')]=_['intersection'](_0x3456c3[_0x7ed1('0x92')],_0x3456c3[_0x7ed1('0x7d')]);_0x3fc1ec[_0x7ed1('0x93')]=_[_0x7ed1('0x94')](_0x3456c3[_0x7ed1('0x92')],qs[_0x7ed1('0x95')](_0x4a02bb['query'][_0x7ed1('0x95')]));_0x3fc1ec['attributes']=_0x3fc1ec['attributes'][_0x7ed1('0x8e')]?_0x3fc1ec[_0x7ed1('0x93')]:_0x3456c3[_0x7ed1('0x92')];if(!_0x4a02bb[_0x7ed1('0x7d')][_0x7ed1('0x96')]('nolimit')){_0x3fc1ec['limit']=qs[_0x7ed1('0x97')](_0x4a02bb['query']['limit']);_0x3fc1ec[_0x7ed1('0x98')]=qs[_0x7ed1('0x98')](_0x4a02bb[_0x7ed1('0x7d')][_0x7ed1('0x98')]);}_0x3fc1ec[_0x7ed1('0x99')]=qs[_0x7ed1('0x9a')](_0x4a02bb[_0x7ed1('0x7d')][_0x7ed1('0x9a')]);_0x3fc1ec[_0x7ed1('0x7a')]=qs[_0x7ed1('0x91')](_[_0x7ed1('0x9b')](_0x4a02bb[_0x7ed1('0x7d')],_0x3456c3[_0x7ed1('0x91')]));if(_0x4a02bb[_0x7ed1('0x7d')]['filter']){_0x3fc1ec[_0x7ed1('0x7a')]=_['merge'](_0x3fc1ec[_0x7ed1('0x7a')],{'$or':_[_0x7ed1('0xd')](_0x6f4d10,function(_0x3ef102){if(_0x3ef102['type'][_0x7ed1('0x9c')]!==_0x7ed1('0x9d')){var _0x5fa39f={};_0x5fa39f[_0x3ef102[_0x7ed1('0x5')]]={'$like':'%'+_0x4a02bb[_0x7ed1('0x7d')][_0x7ed1('0x4')]+'%'};return _0x5fa39f;}})});}var _0x51285a=[];var _0x71b272=null;var _0x115f9f={};if(_0x59fe87){_0x71b272=_[_0x7ed1('0x88')](_0x3142fc,[_0x7ed1('0xb'),_0x59fe87[_0x7ed1('0xb')]]);if(_0x71b272[_0x7ed1('0x5')]){_0x115f9f={};if(_0x5a06fe['childModel']==='AnalyticExtractedReport'){_0x115f9f[_0x71b272[_0x7ed1('0x9e')]]=_[_0x7ed1('0xd')](_0x59fe87['associatedResources'],'id');}else{_0x115f9f[_0x71b272[_0x7ed1('0x9e')]]=_0x59fe87['associatedResources'];}_0x51285a['push'](_0x115f9f);}else{_0x3fc1ec[_0x7ed1('0x7a')]['id']=_0x59fe87['associatedResources'];}}else{for(var _0x5bb988=0x0;_0x5bb988<_0x569c02[_0x7ed1('0x8e')];_0x5bb988++){_0x71b272=_[_0x7ed1('0x88')](_0x3142fc,[_0x7ed1('0xb'),_0x569c02[_0x5bb988][_0x7ed1('0xb')]]);if(_0x71b272[_0x7ed1('0x5')]){_0x115f9f={};_0x115f9f[_0x71b272['foreignKey']]=_0x569c02[_0x5bb988][_0x7ed1('0x8')];_0x51285a[_0x7ed1('0x86')](_0x115f9f);}else{if(!_0x3fc1ec[_0x7ed1('0x7a')]['id'])_0x3fc1ec[_0x7ed1('0x7a')]['id']=[];_0x569c02[_0x5bb988]['associatedResources'][_0x7ed1('0x9f')](function(_0x2858bc){_0x3fc1ec[_0x7ed1('0x7a')]['id']['push'](_0x2858bc);});}}}if(!_[_0x7ed1('0x85')](_0x51285a)){_0x3fc1ec[_0x7ed1('0x7a')]=_['merge'](_0x3fc1ec[_0x7ed1('0x7a')],{'$and':{'$or':_0x51285a}});}_0x3fc1ec=_[_0x7ed1('0xa0')]({},_0x3fc1ec,_0x4a02bb[_0x7ed1('0xa1')]);if(_0x59fe87&&!_0x59fe87[_0x7ed1('0x8c')]&&_0x5a06fe[_0x7ed1('0x13')]===_0x7ed1('0x6d')){if(_0x4a02bb[_0x7ed1('0x7d')][_0x7ed1('0xa2')]){_0x3fc1ec['include']=[{'all':!![]}];}return _0x149413[_0x5a06fe['childModel']][_0x7ed1('0xa')](_0x3fc1ec)[_0x7ed1('0x7')](function(_0x3ca5a4){var _0x321afb=[];_0x3ca5a4[_0x7ed1('0x9f')](function(_0x26cde2){var _0x18152f;switch(_0x26cde2[_0x7ed1('0xa3')]){case _0x7ed1('0xa4'):_0x18152f=_[_0x7ed1('0x88')](_0x59fe87[_0x7ed1('0x8')],function(_0x2c7665){return _0x2c7665['id']===_0x26cde2[_0x7ed1('0x6f')]&&_0x2c7665[_0x7ed1('0xf')]===_0x7ed1('0xa5');});break;case _0x7ed1('0xa6'):_0x18152f=_[_0x7ed1('0x88')](_0x59fe87[_0x7ed1('0x8')],function(_0x4368de){return _0x4368de['id']===_0x26cde2['reportId']&&_0x4368de['type']==='CustomReports';});break;}if(_0x18152f)_0x321afb[_0x7ed1('0x86')](_0x26cde2);});_0x123f61[_0x7ed1('0xa7')]=_0x321afb[_0x7ed1('0x8e')];_0x123f61[_0x7ed1('0xa8')]=_0x321afb;return _0x123f61;});}else{return _0x149413[_0x5a06fe[_0x7ed1('0x13')]][_0x7ed1('0xa7')]({'where':_0x3fc1ec[_0x7ed1('0x7a')]})[_0x7ed1('0x7')](function(_0x390c12){_0x123f61['count']=_0x390c12;if(_0x4a02bb[_0x7ed1('0x7d')][_0x7ed1('0xa2')]){if(_0x5a06fe[_0x7ed1('0x13')]==='CmContact'){_0x3fc1ec[_0x7ed1('0xa9')]=[{'model':_0x149413[_0x7ed1('0xaa')],'as':_0x7ed1('0xab'),'attributes':['id',_0x7ed1('0xb'),'color'],'required':_0x4a02bb[_0x7ed1('0x7d')][_0x7ed1('0xac')]?!![]:![]},{'model':_0x149413[_0x7ed1('0xaa')],'as':_0x7ed1('0xad'),'attributes':['id','name','color'],'through':_0x4a02bb[_0x7ed1('0x7d')][_0x7ed1('0xac')]?{'attributes':[],'where':{'TagId':_0x4a02bb['query'][_0x7ed1('0xac')]||undefined}}:{},'required':_0x4a02bb[_0x7ed1('0x7d')]['tag']?!![]:![]}];}else{_0x3fc1ec[_0x7ed1('0xa9')]=[{'all':!![]}];}}return _0x149413[_0x5a06fe[_0x7ed1('0x13')]][_0x7ed1('0xa')](_0x3fc1ec);})[_0x7ed1('0x7')](function(_0x444bf9){_0x123f61[_0x7ed1('0xa8')]=_0x444bf9;if(_0x3d0d56===_0x7ed1('0xae')&&_0x4a02bb[_0x7ed1('0x7d')][_0x7ed1('0xaf')]===_0x7ed1('0xb0')){var _0x589ce4=[];for(var _0x35efdd=0x0;_0x35efdd<_0x123f61['rows'][_0x7ed1('0x8e')];_0x35efdd++){_0x589ce4[_0x7ed1('0x86')](_0x5f2ae3(_0x7ed1('0xb1'),_0x123f61[_0x7ed1('0xa8')][_0x35efdd]['dataValues']));_0x589ce4[_0x7ed1('0x86')](_0x5f2ae3(_0x7ed1('0xb2'),_0x123f61[_0x7ed1('0xa8')][_0x35efdd]['dataValues']));_0x589ce4[_0x7ed1('0x86')](_0x5f2ae3(_0x7ed1('0xb3'),_0x123f61[_0x7ed1('0xa8')][_0x35efdd][_0x7ed1('0xb4')]));_0x589ce4['push'](_0x5f2ae3(_0x7ed1('0xb5'),_0x123f61[_0x7ed1('0xa8')][_0x35efdd][_0x7ed1('0xb4')]));_0x589ce4[_0x7ed1('0x86')](_0x5f2ae3(_0x7ed1('0xb6'),_0x123f61[_0x7ed1('0xa8')][_0x35efdd][_0x7ed1('0xb4')]));_0x589ce4['push'](_0x5f2ae3(_0x7ed1('0xb7'),_0x123f61[_0x7ed1('0xa8')][_0x35efdd][_0x7ed1('0xb4')]));}return Promise[_0x7ed1('0x8d')](_0x589ce4)[_0x7ed1('0x7')](function(){return _0x123f61;});}return _0x123f61;});}});}}});};