4e07873c13eee1f0b517e9c17c7294f377b5c59f
[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 _0xae0b=['VoiceMail','VoiceRecording','Agents','membername','User','role','agent','telephone','VoiceQueues','queue','VoiceQueue','inbound','QueueCampaigns','VoiceMusicOnHold','chanspies','voiceprefixes','VoicePrefix','mailqueues','MailQueue','mailaccounts','MailAccount','mailsubstatuses','openchannelqueues','OpenchannelQueue','openchannelaccounts','OpenchannelAccount','smsaccounts','SmsAccount','whatsappqueues','WhatsappQueue','whatsappaccounts','WhatsappAccount','teams','Team','queuecampaigns','users','agents','telephones','admin','user','zendeskaccounts','ZendeskAccount','salesforceaccounts','SalesforceAccount','freshdeskaccounts','FreshdeskAccount','SugarcrmAccount','deskaccounts','DeskAccount','zohoaccounts','dispositions','Disposition','intervals','Interval','pauses','Pause','scheduler','Schedule','sounds','Sound','tags','Tag','templates','Template','triggers','Trigger','Trunk','variables','Variable','plugins','Plugin','extractedreports','reportId','metrics','AnalyticMetric','charAt','toUpperCase','slice','QueryTypes','select','ui.','InteractionId','ui.createdAt','from','ui.UserId\x20=\x20?','sequelize','toString','define','UserProfile','user_profiles','../../components/parsers/qs','query','raw','section','Invalid\x20section\x20\x27','isEmpty','push','UserProfileSection','find','params','all','ignore','length','keys','filters','intersection','fields','attributes','nolimit','offset','order','sort','where','merge','key','VIRTUAL','foreignKey','forEach','options','autoAssociation','includeAll','default','DefaultReports','custom','CustomReports','rows','ids','customSorting','extraQueryConditions','count','include','color','tag','openTabs','true','chat','dataValues','sms','fax','mail','openchannel','whatsapp','lodash','./userProfile.attributes','squel','exports','filter','field','value','findAll','then','map','catch','model','name','resolve','UserProfileResource','associatedResources','AnalyticExtractedReport','resourceId','type','squareprojects','childModel','SquareProject','odbc','SquareOdbc','SquareRecording','SquareProjects','projectName','projects','JscriptyProject','CmContact','parentSections','Lists','ListId','lists','CmList','CmCompany','CmCustomField','chatqueues','ChatQueue','ChatWebsite','faxqueues','FaxQueue','FaxAccount','inboundroutes','outboundroutes','contexts','VoiceContext'];(function(_0x4ab041,_0x16227c){var _0x18b75d=function(_0x2904ee){while(--_0x2904ee){_0x4ab041['push'](_0x4ab041['shift']());}};_0x18b75d(++_0x16227c);}(_0xae0b,0x8e));var _0xbae0=function(_0x3dd15e,_0x1f0015){_0x3dd15e=_0x3dd15e-0x0;var _0x231fd0=_0xae0b[_0x3dd15e];return _0x231fd0;};'use strict';var _=require(_0xbae0('0x0'));var attributes=require(_0xbae0('0x1'));var squel=require(_0xbae0('0x2'));module[_0xbae0('0x3')]=function(_0x1aede5){var _0x232b78=_0x1aede5['models'];function _0xee066b(_0x5502c7,_0x52b3f0){return new Promise(function(_0x517b80,_0x418f62){if(!_0x52b3f0)return _0x517b80(null);var _0x5c63c6=_0x52b3f0[_0xbae0('0x4')]?{[_0x52b3f0[_0xbae0('0x4')][_0xbae0('0x5')]]:_0x52b3f0[_0xbae0('0x4')][_0xbae0('0x6')]}:undefined;return _0x232b78[_0x5502c7][_0xbae0('0x7')]({'where':_0x5c63c6,'raw':!![]})[_0xbae0('0x8')](function(_0x431d92){_0x52b3f0['associatedResources']=_[_0xbae0('0x9')](_0x431d92,'id');_0x517b80(_0x52b3f0);})[_0xbae0('0xa')](function(_0x22a4bc){_0x418f62(_0x22a4bc);});});}function _0x1c6859(_0x2b86ff,_0x24b955){return new Promise(function(_0x2c1f87,_0x26e902){var _0x37420e=_0x2b86ff[_0xbae0('0x4')]?{[_0x2b86ff[_0xbae0('0x4')][_0xbae0('0x5')]]:_0x2b86ff['filter'][_0xbae0('0x6')]}:undefined;return _0x232b78[_0x2b86ff[_0xbae0('0xb')]]['findAll']({'where':_0x37420e,'raw':!![]})['then'](function(_0x34cf49){_0x24b955['associatedResources']=_[_0xbae0('0x9')](_0x34cf49,function(_0x552892){return _0x552892[_0xbae0('0xc')];});_0x2c1f87(_0x24b955);})[_0xbae0('0xa')](function(_0x5dd99a){_0x26e902(_0x5dd99a);});});}function _0x39c9ff(_0xc08fc0,_0xc82903,_0xa3ac56){if(!_0xc82903)return Promise[_0xbae0('0xd')](null);return new Promise(function(_0x50e3e8,_0x4f7772){return _0x232b78[_0xbae0('0xe')][_0xbae0('0x7')]({'where':{'sectionId':_0xc82903['id']},'raw':!![]})['then'](function(_0x174ba4){if(_0xc08fc0[_0xbae0('0x5')]&&_0xc08fc0[_0xbae0('0x5')]!=='id'){_0xc82903[_0xbae0('0xf')]=_[_0xbae0('0x9')](_0x174ba4,function(_0xc823b7){return _0xc823b7[_0xc08fc0[_0xbae0('0x5')]];});}else{if(_0xa3ac56===_0xbae0('0x10')){_0xc82903[_0xbae0('0xf')]=_[_0xbae0('0x9')](_0x174ba4,function(_0x397c82){return{'id':_0x397c82[_0xbae0('0x11')],'type':_0x397c82[_0xbae0('0x12')]};});}else{_0xc82903[_0xbae0('0xf')]=_[_0xbae0('0x9')](_0x174ba4,function(_0x2189c8){return _0x2189c8['resourceId'];});}}_0x50e3e8(_0xc82903);})[_0xbae0('0xa')](function(_0x421300){_0x4f7772(_0x421300);});});}function _0x5c645f(_0x26707c,_0x1c1252){var _0x386ce3={'parentSections':[]};switch(_0x26707c['toLowerCase']()){case _0xbae0('0x13'):_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x15');break;case _0xbae0('0x16'):_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x17');break;case'squarerecordings':_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x18');_0x386ce3['parentSections']=[{'name':_0xbae0('0x19'),'field':_0xbae0('0xc'),'foreignKey':_0xbae0('0x1a')}];break;case _0xbae0('0x1b'):_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x1c');break;case'contacts':_0x386ce3['childModel']=_0xbae0('0x1d');_0x386ce3[_0xbae0('0x1e')]=[{'name':_0xbae0('0x1f'),'field':'id','foreignKey':_0xbae0('0x20')}];break;case _0xbae0('0x21'):_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x22');break;case'companies':_0x386ce3['childModel']=_0xbae0('0x23');break;case'globalcustomfields':_0x386ce3['childModel']=_0xbae0('0x24');break;case _0xbae0('0x25'):_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x26');break;case'chatwebsites':_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x27');break;case _0xbae0('0x28'):_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x29');break;case'faxaccounts':_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x2a');break;case _0xbae0('0x2b'):case'internalroutes':case _0xbae0('0x2c'):_0x386ce3[_0xbae0('0x14')]='VoiceExtension';break;case _0xbae0('0x2d'):_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x2e');break;case'voicemails':_0x386ce3['childModel']=_0xbae0('0x2f');break;case'voicerecordings':_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x30');_0x386ce3[_0xbae0('0x1e')]=[{'name':_0xbae0('0x31'),'field':'name','foreignKey':_0xbae0('0x32'),'model':_0xbae0('0x33'),'filter':{'field':_0xbae0('0x34'),'value':[_0xbae0('0x35')]}},{'name':'Telephones','field':_0xbae0('0xc'),'foreignKey':_0xbae0('0x32'),'model':'User','filter':{'field':_0xbae0('0x34'),'value':[_0xbae0('0x36')]}},{'name':_0xbae0('0x37'),'field':_0xbae0('0xc'),'foreignKey':_0xbae0('0x38'),'model':_0xbae0('0x39'),'filter':{'field':_0xbae0('0x12'),'value':[_0xbae0('0x3a')]}},{'name':_0xbae0('0x3b'),'field':_0xbae0('0xc'),'foreignKey':_0xbae0('0x38'),'model':'VoiceQueue','filter':{'field':_0xbae0('0x12'),'value':['outbound']}}];break;case'musiconholds':_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x3c');break;case _0xbae0('0x3d'):_0x386ce3['childModel']='VoiceChanSpy';break;case _0xbae0('0x3e'):_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x3f');break;case'ivrcampaigns':_0x386ce3['childModel']='Campaign';break;case _0xbae0('0x40'):_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x41');break;case _0xbae0('0x42'):_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x43');break;case _0xbae0('0x44'):_0x386ce3[_0xbae0('0x14')]='MailSubstatus';break;case _0xbae0('0x45'):_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x46');break;case _0xbae0('0x47'):_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x48');break;case'smsqueues':_0x386ce3[_0xbae0('0x14')]='SmsQueue';break;case _0xbae0('0x49'):_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x4a');break;case _0xbae0('0x4b'):_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x4c');break;case _0xbae0('0x4d'):_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x4e');break;case _0xbae0('0x4f'):_0x386ce3['childModel']=_0xbae0('0x50');break;case'voicequeues':case _0xbae0('0x51'):_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x39');if(_0x1c1252){_0x386ce3[_0xbae0('0x1e')]=[{'name':'VoiceQueues'},{'name':_0xbae0('0x3b')}];}break;case _0xbae0('0x52'):case _0xbae0('0x53'):case _0xbae0('0x54'):_0x386ce3['childModel']=_0xbae0('0x33');if(_0x1c1252){_0x386ce3[_0xbae0('0x1e')]=[{'name':'Users','filter':{'field':_0xbae0('0x34'),'value':[_0xbae0('0x55'),_0xbae0('0x56')]},'ignore':!![]},{'name':_0xbae0('0x31')},{'name':'Telephones'}];}break;case _0xbae0('0x57'):_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x58');break;case _0xbae0('0x59'):_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x5a');break;case _0xbae0('0x5b'):_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x5c');break;case'sugarcrmaccounts':_0x386ce3['childModel']=_0xbae0('0x5d');break;case _0xbae0('0x5e'):_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x5f');break;case _0xbae0('0x60'):_0x386ce3['childModel']='ZohoAccount';break;case'vtigeraccounts':_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x33');break;case'cannedanswers':_0x386ce3[_0xbae0('0x14')]='CannedAnswer';break;case _0xbae0('0x61'):_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x62');break;case'customdashboards':_0x386ce3['childModel']='Dashboard';break;case _0xbae0('0x63'):_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x64');break;case _0xbae0('0x65'):_0x386ce3['childModel']=_0xbae0('0x66');break;case _0xbae0('0x67'):_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x68');break;case _0xbae0('0x69'):_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x6a');break;case _0xbae0('0x6b'):_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x6c');break;case _0xbae0('0x6d'):_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x6e');break;case _0xbae0('0x6f'):_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x70');break;case'trunks':_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x71');break;case _0xbae0('0x72'):_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x73');break;case _0xbae0('0x74'):_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x75');break;case _0xbae0('0x76'):_0x386ce3[_0xbae0('0x14')]=_0xbae0('0x10');_0x386ce3['parentSections']=[{'name':'Reports','field':'id','foreignKey':_0xbae0('0x77')}];break;case _0xbae0('0x78'):_0x386ce3['childModel']=_0xbae0('0x79');break;}return _0x386ce3;}function _0x5ae32c(_0x3aee20,_0x51631b){var _0x5bd7da=_0x3aee20[_0xbae0('0x7a')](0x0)[_0xbae0('0x7b')]()+_0x3aee20[_0xbae0('0x7c')](0x1);var _0x2218fa={'type':_0x232b78['Sequelize'][_0xbae0('0x7d')]['SELECT'],'raw':!![]};return new Promise(function(_0x5893e8,_0x29729a){var _0x4a4550=squel[_0xbae0('0x7e')]()[_0xbae0('0x5')](_0xbae0('0x7f')+_0x5bd7da+_0xbae0('0x80'),'id')[_0xbae0('0x5')](_0xbae0('0x81'))[_0xbae0('0x82')]('user_has_'+_0x3aee20+'_interactions','ui')['where'](_0xbae0('0x83'),_0x51631b['id']);return _0x232b78[_0xbae0('0x84')]['query'](_0x4a4550[_0xbae0('0x85')](),_0x2218fa)[_0xbae0('0x8')](function(_0x312a31){_0x51631b[_0x5bd7da+'OpenTabs']=_0x312a31;_0x5893e8(_0x312a31);})[_0xbae0('0xa')](function(_0xc782ac){_0x29729a(_0xc782ac);});});}return _0x1aede5[_0xbae0('0x86')](_0xbae0('0x87'),attributes,{'tableName':_0xbae0('0x88'),'paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x3852b3){var _0x47878c=require(_0xbae0('0x89'));var _0x3c33fc={'raw':_0x3852b3[_0xbae0('0x8a')][_0xbae0('0x8b')],'where':{}};var _0x50f707={};var _0x253b90={'count':0x0,'rows':[]};var _0x2ff91d=_0x3852b3[_0xbae0('0x8a')][_0xbae0('0x8c')];var _0x1634fb=_0x3852b3[_0xbae0('0x8a')]['mergeResources']||![];var _0x10dcbe=_0x5c645f(_0x2ff91d,_0x1634fb);if(!_0x10dcbe[_0xbae0('0x14')])throw new Error(_0xbae0('0x8d')+_0x2ff91d+'\x27');var _0x23aa29=[{'name':_0x2ff91d}];if(!_[_0xbae0('0x8e')](_0x10dcbe[_0xbae0('0x1e')]))_0x23aa29=_0x10dcbe[_0xbae0('0x1e')];var _0x7bd509=[];for(var _0x15ae8c=0x0;_0x15ae8c<_0x23aa29['length'];_0x15ae8c++){_0x7bd509[_0xbae0('0x8f')](_0x232b78[_0xbae0('0x90')][_0xbae0('0x91')]({'where':{'userProfileId':_0x3852b3[_0xbae0('0x92')]['id'],'name':_0x23aa29[_0x15ae8c][_0xbae0('0xc')]},'raw':!![]}));}return Promise[_0xbae0('0x93')](_0x7bd509)[_0xbae0('0x8')](function(_0x2d0582){var _0x12921b=_[_0xbae0('0x4')](_0x2d0582,function(_0x29396c){return _0x29396c?_0x29396c:undefined;});var _0x456cf2=_[_0xbae0('0x4')](_0x23aa29,[_0xbae0('0x94'),!![]]);var _0x473116=_[_0xbae0('0x8e')](_0x12921b)&&_[_0xbae0('0x8e')](_0x456cf2)?null:_['union'](_0x456cf2,_0x12921b);if(!_0x473116)return null;var _0x535042=[];for(var _0x245aaf=0x0;_0x245aaf<_0x473116[_0xbae0('0x95')];_0x245aaf++){var _0x2b757b=_[_0xbae0('0x91')](_0x23aa29,function(_0x270b69){return _0x473116[_0x245aaf]?_0x270b69[_0xbae0('0xc')]===_0x473116[_0x245aaf][_0xbae0('0xc')]:null;});if(_0x2b757b){if(_0x473116[_0x245aaf]['ignore']){_0x535042[_0xbae0('0x8f')](_0xee066b(_0x10dcbe[_0xbae0('0x14')],_0x473116[_0x245aaf]));}else{if(!_0x473116[_0x245aaf]['autoAssociation']){_0x535042[_0xbae0('0x8f')](_0x39c9ff(_0x2b757b,_0x473116[_0x245aaf],_0x10dcbe['childModel']));}else{if(_0x2b757b[_0xbae0('0xb')]){_0x535042[_0xbae0('0x8f')](_0x1c6859(_0x2b757b,_0x473116[_0x245aaf]));}}}}}return Promise[_0xbae0('0x93')](_0x535042);})[_0xbae0('0x8')](function(_0x470aa6){var _0x3f9fee=_0x470aa6;var _0x3b16cf=null;if(_0x3f9fee){_0x3b16cf=_0x3f9fee[_0xbae0('0x95')]===0x1?_0x3f9fee[0x0]:null;}if(!_0x3b16cf&&!_0x3f9fee)return _0x253b90;var _0x311caa=_0x232b78[_0x10dcbe[_0xbae0('0x14')]]['rawAttributes'];_0x50f707[_0xbae0('0xb')]=_[_0xbae0('0x96')](_0x311caa);_0x50f707['query']=_[_0xbae0('0x96')](_0x3852b3[_0xbae0('0x8a')]);_0x50f707[_0xbae0('0x97')]=_[_0xbae0('0x98')](_0x50f707[_0xbae0('0xb')],_0x50f707[_0xbae0('0x8a')]);_0x3c33fc['attributes']=_[_0xbae0('0x98')](_0x50f707[_0xbae0('0xb')],_0x47878c[_0xbae0('0x99')](_0x3852b3[_0xbae0('0x8a')][_0xbae0('0x99')]));_0x3c33fc[_0xbae0('0x9a')]=_0x3c33fc[_0xbae0('0x9a')][_0xbae0('0x95')]?_0x3c33fc['attributes']:_0x50f707['model'];if(!_0x3852b3[_0xbae0('0x8a')]['hasOwnProperty'](_0xbae0('0x9b'))){_0x3c33fc['limit']=_0x47878c['limit'](_0x3852b3[_0xbae0('0x8a')]['limit']);_0x3c33fc['offset']=_0x47878c[_0xbae0('0x9c')](_0x3852b3[_0xbae0('0x8a')][_0xbae0('0x9c')]);}_0x3c33fc[_0xbae0('0x9d')]=_0x47878c[_0xbae0('0x9e')](_0x3852b3['query']['sort']);_0x3c33fc[_0xbae0('0x9f')]=_0x47878c['filters'](_['pick'](_0x3852b3[_0xbae0('0x8a')],_0x50f707[_0xbae0('0x97')]));if(_0x3852b3[_0xbae0('0x8a')]['filter']){_0x3c33fc[_0xbae0('0x9f')]=_[_0xbae0('0xa0')](_0x3c33fc[_0xbae0('0x9f')],{'$or':_[_0xbae0('0x9')](_0x311caa,function(_0x3ebf89){if(_0x3ebf89[_0xbae0('0x12')][_0xbae0('0xa1')]!==_0xbae0('0xa2')){var _0x188951={};_0x188951[_0x3ebf89[_0xbae0('0x5')]]={'$like':'%'+_0x3852b3[_0xbae0('0x8a')][_0xbae0('0x4')]+'%'};return _0x188951;}})});}var _0x2b573b=[];var _0x5b1536=null;var _0x466790={};if(_0x3b16cf){_0x5b1536=_[_0xbae0('0x91')](_0x23aa29,['name',_0x3b16cf[_0xbae0('0xc')]]);if(_0x5b1536[_0xbae0('0x5')]){_0x466790={};if(_0x10dcbe['childModel']===_0xbae0('0x10')){_0x466790[_0x5b1536[_0xbae0('0xa3')]]=_[_0xbae0('0x9')](_0x3b16cf[_0xbae0('0xf')],'id');}else{_0x466790[_0x5b1536['foreignKey']]=_0x3b16cf[_0xbae0('0xf')];}_0x2b573b[_0xbae0('0x8f')](_0x466790);}else{_0x3c33fc[_0xbae0('0x9f')]['id']=_0x3b16cf[_0xbae0('0xf')];}}else{for(var _0x3d22c9=0x0;_0x3d22c9<_0x3f9fee['length'];_0x3d22c9++){_0x5b1536=_[_0xbae0('0x91')](_0x23aa29,[_0xbae0('0xc'),_0x3f9fee[_0x3d22c9][_0xbae0('0xc')]]);if(_0x5b1536[_0xbae0('0x5')]){_0x466790={};_0x466790[_0x5b1536[_0xbae0('0xa3')]]=_0x3f9fee[_0x3d22c9]['associatedResources'];_0x2b573b[_0xbae0('0x8f')](_0x466790);}else{if(!_0x3c33fc[_0xbae0('0x9f')]['id'])_0x3c33fc['where']['id']=[];_0x3f9fee[_0x3d22c9][_0xbae0('0xf')][_0xbae0('0xa4')](function(_0xf7ffc9){_0x3c33fc[_0xbae0('0x9f')]['id'][_0xbae0('0x8f')](_0xf7ffc9);});}}}if(!_['isEmpty'](_0x2b573b)){_0x3c33fc['where']=_[_0xbae0('0xa0')](_0x3c33fc[_0xbae0('0x9f')],{'$and':{'$or':_0x2b573b}});}_0x3c33fc=_['merge']({},_0x3c33fc,_0x3852b3[_0xbae0('0xa5')]);if(_0x3b16cf&&!_0x3b16cf[_0xbae0('0xa6')]&&_0x10dcbe[_0xbae0('0x14')]===_0xbae0('0x10')){if(_0x3852b3[_0xbae0('0x8a')][_0xbae0('0xa7')]){_0x3c33fc['include']=[{'all':!![]}];}return _0x232b78[_0x10dcbe['childModel']][_0xbae0('0x7')](_0x3c33fc)[_0xbae0('0x8')](function(_0x5d40d9){var _0x1ae37c=[];_0x5d40d9[_0xbae0('0xa4')](function(_0x2d1ed1){var _0x9df27a;switch(_0x2d1ed1['reportType']){case _0xbae0('0xa8'):_0x9df27a=_[_0xbae0('0x91')](_0x3b16cf[_0xbae0('0xf')],function(_0x552c68){return _0x552c68['id']===_0x2d1ed1[_0xbae0('0x77')]&&_0x552c68[_0xbae0('0x12')]===_0xbae0('0xa9');});break;case _0xbae0('0xaa'):_0x9df27a=_[_0xbae0('0x91')](_0x3b16cf[_0xbae0('0xf')],function(_0x1b8282){return _0x1b8282['id']===_0x2d1ed1[_0xbae0('0x77')]&&_0x1b8282[_0xbae0('0x12')]===_0xbae0('0xab');});break;}if(_0x9df27a)_0x1ae37c[_0xbae0('0x8f')](_0x2d1ed1);});_0x253b90['count']=_0x1ae37c[_0xbae0('0x95')];_0x253b90[_0xbae0('0xac')]=_0x1ae37c;return _0x253b90;});}else{if(!_[_0xbae0('0x8e')](_0x3852b3[_0xbae0('0x8a')][_0xbae0('0xad')])){_0x3c33fc[_0xbae0('0x9f')]['id']=_0x3c33fc[_0xbae0('0x9f')]['id']?_[_0xbae0('0x98')](_0x3c33fc[_0xbae0('0x9f')]['id'],_0x3852b3[_0xbae0('0x8a')][_0xbae0('0xad')]):_0x3852b3[_0xbae0('0x8a')][_0xbae0('0xad')];if(_0x3852b3[_0xbae0('0x8a')][_0xbae0('0xae')]){_0x3c33fc[_0xbae0('0x9d')]=_0x3852b3['query'][_0xbae0('0xae')];}}if(_0x3852b3[_0xbae0('0x8a')][_0xbae0('0xaf')]){_0x3c33fc[_0xbae0('0x9f')]=_[_0xbae0('0xa0')](_0x3c33fc[_0xbae0('0x9f')],{'$and':_0x3852b3[_0xbae0('0x8a')][_0xbae0('0xaf')]});}return _0x232b78[_0x10dcbe[_0xbae0('0x14')]][_0xbae0('0xb0')]({'where':_0x3c33fc['where']})[_0xbae0('0x8')](function(_0x6eeb1e){_0x253b90[_0xbae0('0xb0')]=_0x6eeb1e;if(_0x3852b3['query'][_0xbae0('0xa7')]){if(_0x10dcbe[_0xbae0('0x14')]==='CmContact'){_0x3c33fc[_0xbae0('0xb1')]=[{'model':_0x232b78[_0xbae0('0x6c')],'as':'Tags','attributes':['id','name',_0xbae0('0xb2')],'required':_0x3852b3[_0xbae0('0x8a')][_0xbae0('0xb3')]?!![]:![]},{'model':_0x232b78[_0xbae0('0x6c')],'as':'ThroughTags','attributes':['id','name',_0xbae0('0xb2')],'through':_0x3852b3[_0xbae0('0x8a')]['tag']?{'attributes':[],'where':{'TagId':_0x3852b3[_0xbae0('0x8a')][_0xbae0('0xb3')]||undefined}}:{},'required':_0x3852b3[_0xbae0('0x8a')][_0xbae0('0xb3')]?!![]:![]}];}else{_0x3c33fc[_0xbae0('0xb1')]=[{'all':!![]}];}}return _0x232b78[_0x10dcbe[_0xbae0('0x14')]]['findAll'](_0x3c33fc);})[_0xbae0('0x8')](function(_0x17dab2){_0x253b90[_0xbae0('0xac')]=_0x17dab2;if(_0x2ff91d===_0xbae0('0x31')&&_0x3852b3[_0xbae0('0x8a')][_0xbae0('0xb4')]===_0xbae0('0xb5')){var _0x22156b=[];for(var _0x22d1b5=0x0;_0x22d1b5<_0x253b90[_0xbae0('0xac')][_0xbae0('0x95')];_0x22d1b5++){_0x22156b[_0xbae0('0x8f')](_0x5ae32c(_0xbae0('0xb6'),_0x253b90['rows'][_0x22d1b5][_0xbae0('0xb7')]));_0x22156b[_0xbae0('0x8f')](_0x5ae32c(_0xbae0('0xb8'),_0x253b90[_0xbae0('0xac')][_0x22d1b5][_0xbae0('0xb7')]));_0x22156b[_0xbae0('0x8f')](_0x5ae32c(_0xbae0('0xb9'),_0x253b90[_0xbae0('0xac')][_0x22d1b5]['dataValues']));_0x22156b[_0xbae0('0x8f')](_0x5ae32c(_0xbae0('0xba'),_0x253b90[_0xbae0('0xac')][_0x22d1b5][_0xbae0('0xb7')]));_0x22156b[_0xbae0('0x8f')](_0x5ae32c(_0xbae0('0xbb'),_0x253b90[_0xbae0('0xac')][_0x22d1b5][_0xbae0('0xb7')]));_0x22156b[_0xbae0('0x8f')](_0x5ae32c(_0xbae0('0xbc'),_0x253b90['rows'][_0x22d1b5][_0xbae0('0xb7')]));}return Promise[_0xbae0('0x93')](_0x22156b)['then'](function(){return _0x253b90;});}return _0x253b90;});}});}}});};