6e1cb5be1e5563836e47b32ec4d36e6d02b4a528
[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 _0xe985=['VoiceExtension','contexts','VoiceContext','voicemails','voicerecordings','VoiceRecording','Agents','membername','User','agent','Telephones','role','VoiceQueues','VoiceQueue','QueueCampaigns','queue','outbound','chanspies','VoiceChanSpy','voiceprefixes','Campaign','mailqueues','MailQueue','mailaccounts','MailAccount','mailsubstatuses','MailSubstatus','openchannelqueues','openchannelaccounts','OpenchannelAccount','SmsQueue','smsaccounts','SmsAccount','WhatsappQueue','whatsappaccounts','teams','Team','queuecampaigns','users','agents','telephones','admin','zendeskaccounts','salesforceaccounts','SalesforceAccount','freshdeskaccounts','sugarcrmaccounts','SugarcrmAccount','DeskAccount','vtigeraccounts','cannedanswers','CannedAnswer','dispositions','Dashboard','intervals','Interval','pauses','Pause','sounds','Sound','tags','templates','Template','triggers','Trigger','trunks','variables','Variable','plugins','Plugin','Reports','reportId','toUpperCase','slice','QueryTypes','SELECT','select','ui.','InteractionId','user_has_','where','ui.UserId\x20=\x20?','sequelize','query','OpenTabs','user_profiles','../../components/parsers/qs','raw','section','Invalid\x20section\x20\x27','isEmpty','length','push','UserProfileSection','find','params','all','union','ignore','model','keys','filters','intersection','fields','attributes','hasOwnProperty','nolimit','limit','offset','order','sort','pick','key','VIRTUAL','AnalyticExtractedReport','foreignKey','merge','options','autoAssociation','includeAll','reportType','default','DefaultReports','custom','CustomReports','count','rows','ids','customSorting','extraQueryConditions','CmContact','include','tag','Tag','openTabs','chat','dataValues','sms','mail','lodash','./userProfile.attributes','exports','models','filter','field','then','associatedResources','map','catch','value','findAll','name','resolve','UserProfileResource','type','toLowerCase','squareprojects','childModel','SquareProject','odbc','squarerecordings','parentSections','projectName','projects','JscriptyProject','contacts','Lists','ListId','CmList','companies','CmCompany','globalcustomfields','CmCustomField','chatqueues','ChatWebsite','faxqueues','FaxAccount','inboundroutes','internalroutes','outboundroutes'];(function(_0x36bff5,_0x3156cb){var _0x80ade5=function(_0x5eee65){while(--_0x5eee65){_0x36bff5['push'](_0x36bff5['shift']());}};_0x80ade5(++_0x3156cb);}(_0xe985,0x13f));var _0x5e98=function(_0x57a402,_0x40596b){_0x57a402=_0x57a402-0x0;var _0x753a36=_0xe985[_0x57a402];return _0x753a36;};'use strict';var _=require(_0x5e98('0x0'));var attributes=require(_0x5e98('0x1'));var squel=require('squel');module[_0x5e98('0x2')]=function(_0x332c19){var _0x3fd4be=_0x332c19[_0x5e98('0x3')];function _0x3d52b0(_0x3780c4,_0x328f47){return new Promise(function(_0x2d5d4e,_0x41f6d0){if(!_0x328f47)return _0x2d5d4e(null);var _0x4c6a38=_0x328f47[_0x5e98('0x4')]?{[_0x328f47[_0x5e98('0x4')][_0x5e98('0x5')]]:_0x328f47[_0x5e98('0x4')]['value']}:undefined;return _0x3fd4be[_0x3780c4]['findAll']({'where':_0x4c6a38,'raw':!![]})[_0x5e98('0x6')](function(_0x5bba95){_0x328f47[_0x5e98('0x7')]=_[_0x5e98('0x8')](_0x5bba95,'id');_0x2d5d4e(_0x328f47);})[_0x5e98('0x9')](function(_0x57e8b4){_0x41f6d0(_0x57e8b4);});});}function _0x201fa4(_0x35f240,_0x4ba2f8){return new Promise(function(_0x3c30d8,_0x5fe9f7){var _0xd2c7b6=_0x35f240[_0x5e98('0x4')]?{[_0x35f240['filter'][_0x5e98('0x5')]]:_0x35f240[_0x5e98('0x4')][_0x5e98('0xa')]}:undefined;return _0x3fd4be[_0x35f240['model']][_0x5e98('0xb')]({'where':_0xd2c7b6,'raw':!![]})[_0x5e98('0x6')](function(_0x20ea76){_0x4ba2f8[_0x5e98('0x7')]=_['map'](_0x20ea76,function(_0x25b454){return _0x25b454[_0x5e98('0xc')];});_0x3c30d8(_0x4ba2f8);})[_0x5e98('0x9')](function(_0x5aa39a){_0x5fe9f7(_0x5aa39a);});});}function _0x1bde53(_0x40bc37,_0x348ba4,_0x470961){if(!_0x348ba4)return Promise[_0x5e98('0xd')](null);return new Promise(function(_0x1c2251,_0x37b3bc){return _0x3fd4be[_0x5e98('0xe')]['findAll']({'where':{'sectionId':_0x348ba4['id']},'raw':!![]})[_0x5e98('0x6')](function(_0x3e367f){if(_0x40bc37[_0x5e98('0x5')]&&_0x40bc37[_0x5e98('0x5')]!=='id'){_0x348ba4[_0x5e98('0x7')]=_[_0x5e98('0x8')](_0x3e367f,function(_0x23b4b1){return _0x23b4b1[_0x40bc37['field']];});}else{if(_0x470961==='AnalyticExtractedReport'){_0x348ba4['associatedResources']=_[_0x5e98('0x8')](_0x3e367f,function(_0x445d8f){return{'id':_0x445d8f['resourceId'],'type':_0x445d8f[_0x5e98('0xf')]};});}else{_0x348ba4['associatedResources']=_['map'](_0x3e367f,function(_0x14108b){return _0x14108b['resourceId'];});}}_0x1c2251(_0x348ba4);})[_0x5e98('0x9')](function(_0x1d96b2){_0x37b3bc(_0x1d96b2);});});}function _0x6da3f7(_0x2edc3f,_0x200db5){var _0xde2cdf={'parentSections':[]};switch(_0x2edc3f[_0x5e98('0x10')]()){case _0x5e98('0x11'):_0xde2cdf[_0x5e98('0x12')]=_0x5e98('0x13');break;case _0x5e98('0x14'):_0xde2cdf['childModel']='SquareOdbc';break;case _0x5e98('0x15'):_0xde2cdf[_0x5e98('0x12')]='SquareRecording';_0xde2cdf[_0x5e98('0x16')]=[{'name':'SquareProjects','field':_0x5e98('0xc'),'foreignKey':_0x5e98('0x17')}];break;case _0x5e98('0x18'):_0xde2cdf[_0x5e98('0x12')]=_0x5e98('0x19');break;case _0x5e98('0x1a'):_0xde2cdf['childModel']='CmContact';_0xde2cdf[_0x5e98('0x16')]=[{'name':_0x5e98('0x1b'),'field':'id','foreignKey':_0x5e98('0x1c')}];break;case'lists':_0xde2cdf[_0x5e98('0x12')]=_0x5e98('0x1d');break;case _0x5e98('0x1e'):_0xde2cdf['childModel']=_0x5e98('0x1f');break;case _0x5e98('0x20'):_0xde2cdf[_0x5e98('0x12')]=_0x5e98('0x21');break;case _0x5e98('0x22'):_0xde2cdf[_0x5e98('0x12')]='ChatQueue';break;case'chatwebsites':_0xde2cdf[_0x5e98('0x12')]=_0x5e98('0x23');break;case _0x5e98('0x24'):_0xde2cdf[_0x5e98('0x12')]='FaxQueue';break;case'faxaccounts':_0xde2cdf[_0x5e98('0x12')]=_0x5e98('0x25');break;case _0x5e98('0x26'):case _0x5e98('0x27'):case _0x5e98('0x28'):_0xde2cdf[_0x5e98('0x12')]=_0x5e98('0x29');break;case _0x5e98('0x2a'):_0xde2cdf[_0x5e98('0x12')]=_0x5e98('0x2b');break;case _0x5e98('0x2c'):_0xde2cdf[_0x5e98('0x12')]='VoiceMail';break;case _0x5e98('0x2d'):_0xde2cdf[_0x5e98('0x12')]=_0x5e98('0x2e');_0xde2cdf[_0x5e98('0x16')]=[{'name':_0x5e98('0x2f'),'field':_0x5e98('0xc'),'foreignKey':_0x5e98('0x30'),'model':_0x5e98('0x31'),'filter':{'field':'role','value':[_0x5e98('0x32')]}},{'name':_0x5e98('0x33'),'field':_0x5e98('0xc'),'foreignKey':_0x5e98('0x30'),'model':_0x5e98('0x31'),'filter':{'field':_0x5e98('0x34'),'value':['telephone']}},{'name':_0x5e98('0x35'),'field':_0x5e98('0xc'),'foreignKey':'queue','model':_0x5e98('0x36'),'filter':{'field':_0x5e98('0xf'),'value':['inbound']}},{'name':_0x5e98('0x37'),'field':_0x5e98('0xc'),'foreignKey':_0x5e98('0x38'),'model':_0x5e98('0x36'),'filter':{'field':_0x5e98('0xf'),'value':[_0x5e98('0x39')]}}];break;case'musiconholds':_0xde2cdf[_0x5e98('0x12')]='VoiceMusicOnHold';break;case _0x5e98('0x3a'):_0xde2cdf[_0x5e98('0x12')]=_0x5e98('0x3b');break;case _0x5e98('0x3c'):_0xde2cdf[_0x5e98('0x12')]='VoicePrefix';break;case'ivrcampaigns':_0xde2cdf[_0x5e98('0x12')]=_0x5e98('0x3d');break;case _0x5e98('0x3e'):_0xde2cdf['childModel']=_0x5e98('0x3f');break;case _0x5e98('0x40'):_0xde2cdf[_0x5e98('0x12')]=_0x5e98('0x41');break;case _0x5e98('0x42'):_0xde2cdf[_0x5e98('0x12')]=_0x5e98('0x43');break;case _0x5e98('0x44'):_0xde2cdf[_0x5e98('0x12')]='OpenchannelQueue';break;case _0x5e98('0x45'):_0xde2cdf['childModel']=_0x5e98('0x46');break;case'smsqueues':_0xde2cdf['childModel']=_0x5e98('0x47');break;case _0x5e98('0x48'):_0xde2cdf[_0x5e98('0x12')]=_0x5e98('0x49');break;case'whatsappqueues':_0xde2cdf[_0x5e98('0x12')]=_0x5e98('0x4a');break;case _0x5e98('0x4b'):_0xde2cdf[_0x5e98('0x12')]='WhatsappAccount';break;case _0x5e98('0x4c'):_0xde2cdf['childModel']=_0x5e98('0x4d');break;case'voicequeues':case _0x5e98('0x4e'):_0xde2cdf[_0x5e98('0x12')]=_0x5e98('0x36');if(_0x200db5){_0xde2cdf[_0x5e98('0x16')]=[{'name':_0x5e98('0x35')},{'name':_0x5e98('0x37')}];}break;case _0x5e98('0x4f'):case _0x5e98('0x50'):case _0x5e98('0x51'):_0xde2cdf[_0x5e98('0x12')]=_0x5e98('0x31');if(_0x200db5){_0xde2cdf[_0x5e98('0x16')]=[{'name':'Users','filter':{'field':_0x5e98('0x34'),'value':[_0x5e98('0x52'),'user']},'ignore':!![]},{'name':'Agents'},{'name':_0x5e98('0x33')}];}break;case _0x5e98('0x53'):_0xde2cdf[_0x5e98('0x12')]='ZendeskAccount';break;case _0x5e98('0x54'):_0xde2cdf[_0x5e98('0x12')]=_0x5e98('0x55');break;case _0x5e98('0x56'):_0xde2cdf['childModel']='FreshdeskAccount';break;case _0x5e98('0x57'):_0xde2cdf[_0x5e98('0x12')]=_0x5e98('0x58');break;case'deskaccounts':_0xde2cdf[_0x5e98('0x12')]=_0x5e98('0x59');break;case'zohoaccounts':_0xde2cdf[_0x5e98('0x12')]='ZohoAccount';break;case _0x5e98('0x5a'):_0xde2cdf[_0x5e98('0x12')]=_0x5e98('0x31');break;case _0x5e98('0x5b'):_0xde2cdf[_0x5e98('0x12')]=_0x5e98('0x5c');break;case _0x5e98('0x5d'):_0xde2cdf[_0x5e98('0x12')]='Disposition';break;case'customdashboards':_0xde2cdf[_0x5e98('0x12')]=_0x5e98('0x5e');break;case _0x5e98('0x5f'):_0xde2cdf[_0x5e98('0x12')]=_0x5e98('0x60');break;case _0x5e98('0x61'):_0xde2cdf[_0x5e98('0x12')]=_0x5e98('0x62');break;case'scheduler':_0xde2cdf[_0x5e98('0x12')]='Schedule';break;case _0x5e98('0x63'):_0xde2cdf['childModel']=_0x5e98('0x64');break;case _0x5e98('0x65'):_0xde2cdf[_0x5e98('0x12')]='Tag';break;case _0x5e98('0x66'):_0xde2cdf[_0x5e98('0x12')]=_0x5e98('0x67');break;case _0x5e98('0x68'):_0xde2cdf[_0x5e98('0x12')]=_0x5e98('0x69');break;case _0x5e98('0x6a'):_0xde2cdf[_0x5e98('0x12')]='Trunk';break;case _0x5e98('0x6b'):_0xde2cdf['childModel']=_0x5e98('0x6c');break;case _0x5e98('0x6d'):_0xde2cdf[_0x5e98('0x12')]=_0x5e98('0x6e');break;case'extractedreports':_0xde2cdf['childModel']='AnalyticExtractedReport';_0xde2cdf['parentSections']=[{'name':_0x5e98('0x6f'),'field':'id','foreignKey':_0x5e98('0x70')}];break;case'metrics':_0xde2cdf['childModel']='AnalyticMetric';break;}return _0xde2cdf;}function _0x48b1ef(_0x580cb3,_0x1c4cd6){var _0x5b15ac=_0x580cb3['charAt'](0x0)[_0x5e98('0x71')]()+_0x580cb3[_0x5e98('0x72')](0x1);var _0x5e1aa5={'type':_0x3fd4be['Sequelize'][_0x5e98('0x73')][_0x5e98('0x74')],'raw':!![]};return new Promise(function(_0x3d0b3d,_0x236713){var _0x2aa57f=squel[_0x5e98('0x75')]()[_0x5e98('0x5')](_0x5e98('0x76')+_0x5b15ac+_0x5e98('0x77'),'id')['field']('ui.createdAt')['from'](_0x5e98('0x78')+_0x580cb3+'_interactions','ui')[_0x5e98('0x79')](_0x5e98('0x7a'),_0x1c4cd6['id']);return _0x3fd4be[_0x5e98('0x7b')][_0x5e98('0x7c')](_0x2aa57f['toString'](),_0x5e1aa5)['then'](function(_0x4b1323){_0x1c4cd6[_0x5b15ac+_0x5e98('0x7d')]=_0x4b1323;_0x3d0b3d(_0x4b1323);})[_0x5e98('0x9')](function(_0x16083d){_0x236713(_0x16083d);});});}return _0x332c19['define']('UserProfile',attributes,{'tableName':_0x5e98('0x7e'),'paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x38c0dd){var _0x3c965f=require(_0x5e98('0x7f'));var _0x2e13a9={'raw':_0x38c0dd['query'][_0x5e98('0x80')],'where':{}};var _0xbbfb4e={};var _0x472b9c={'count':0x0,'rows':[]};var _0x2cab40=_0x38c0dd[_0x5e98('0x7c')][_0x5e98('0x81')];var _0x2aa182=_0x38c0dd[_0x5e98('0x7c')]['mergeResources']||![];var _0x53db7a=_0x6da3f7(_0x2cab40,_0x2aa182);if(!_0x53db7a[_0x5e98('0x12')])throw new Error(_0x5e98('0x82')+_0x2cab40+'\x27');var _0x599ea9=[{'name':_0x2cab40}];if(!_[_0x5e98('0x83')](_0x53db7a[_0x5e98('0x16')]))_0x599ea9=_0x53db7a['parentSections'];var _0x30701c=[];for(var _0x533a75=0x0;_0x533a75<_0x599ea9[_0x5e98('0x84')];_0x533a75++){_0x30701c[_0x5e98('0x85')](_0x3fd4be[_0x5e98('0x86')][_0x5e98('0x87')]({'where':{'userProfileId':_0x38c0dd[_0x5e98('0x88')]['id'],'name':_0x599ea9[_0x533a75][_0x5e98('0xc')]},'raw':!![]}));}return Promise[_0x5e98('0x89')](_0x30701c)[_0x5e98('0x6')](function(_0x182da1){var _0x2c83d6=_[_0x5e98('0x4')](_0x182da1,function(_0x2b4f38){return _0x2b4f38?_0x2b4f38:undefined;});var _0x109d08=_[_0x5e98('0x4')](_0x599ea9,['ignore',!![]]);var _0x493e72=_[_0x5e98('0x83')](_0x2c83d6)&&_[_0x5e98('0x83')](_0x109d08)?null:_[_0x5e98('0x8a')](_0x109d08,_0x2c83d6);if(!_0x493e72)return null;var _0x1a865f=[];for(var _0x33cebb=0x0;_0x33cebb<_0x493e72['length'];_0x33cebb++){var _0xdf72c4=_[_0x5e98('0x87')](_0x599ea9,function(_0x44f2a9){return _0x493e72[_0x33cebb]?_0x44f2a9['name']===_0x493e72[_0x33cebb][_0x5e98('0xc')]:null;});if(_0xdf72c4){if(_0x493e72[_0x33cebb][_0x5e98('0x8b')]){_0x1a865f['push'](_0x3d52b0(_0x53db7a[_0x5e98('0x12')],_0x493e72[_0x33cebb]));}else{if(!_0x493e72[_0x33cebb]['autoAssociation']){_0x1a865f[_0x5e98('0x85')](_0x1bde53(_0xdf72c4,_0x493e72[_0x33cebb],_0x53db7a[_0x5e98('0x12')]));}else{if(_0xdf72c4[_0x5e98('0x8c')]){_0x1a865f['push'](_0x201fa4(_0xdf72c4,_0x493e72[_0x33cebb]));}}}}}return Promise['all'](_0x1a865f);})['then'](function(_0x160c72){var _0x19c9e9=_0x160c72;var _0x4cb7ce=null;if(_0x19c9e9){_0x4cb7ce=_0x19c9e9[_0x5e98('0x84')]===0x1?_0x19c9e9[0x0]:null;}if(!_0x4cb7ce&&!_0x19c9e9)return _0x472b9c;var _0x2d62e6=_0x3fd4be[_0x53db7a[_0x5e98('0x12')]]['rawAttributes'];_0xbbfb4e[_0x5e98('0x8c')]=_['keys'](_0x2d62e6);_0xbbfb4e[_0x5e98('0x7c')]=_[_0x5e98('0x8d')](_0x38c0dd[_0x5e98('0x7c')]);_0xbbfb4e[_0x5e98('0x8e')]=_[_0x5e98('0x8f')](_0xbbfb4e[_0x5e98('0x8c')],_0xbbfb4e['query']);_0x2e13a9['attributes']=_[_0x5e98('0x8f')](_0xbbfb4e['model'],_0x3c965f[_0x5e98('0x90')](_0x38c0dd[_0x5e98('0x7c')][_0x5e98('0x90')]));_0x2e13a9[_0x5e98('0x91')]=_0x2e13a9[_0x5e98('0x91')][_0x5e98('0x84')]?_0x2e13a9[_0x5e98('0x91')]:_0xbbfb4e[_0x5e98('0x8c')];if(!_0x38c0dd[_0x5e98('0x7c')][_0x5e98('0x92')](_0x5e98('0x93'))){_0x2e13a9['limit']=_0x3c965f[_0x5e98('0x94')](_0x38c0dd[_0x5e98('0x7c')][_0x5e98('0x94')]);_0x2e13a9['offset']=_0x3c965f['offset'](_0x38c0dd[_0x5e98('0x7c')][_0x5e98('0x95')]);}_0x2e13a9[_0x5e98('0x96')]=_0x3c965f[_0x5e98('0x97')](_0x38c0dd['query'][_0x5e98('0x97')]);_0x2e13a9[_0x5e98('0x79')]=_0x3c965f[_0x5e98('0x8e')](_[_0x5e98('0x98')](_0x38c0dd['query'],_0xbbfb4e[_0x5e98('0x8e')]));if(_0x38c0dd[_0x5e98('0x7c')][_0x5e98('0x4')]){_0x2e13a9['where']=_['merge'](_0x2e13a9[_0x5e98('0x79')],{'$or':_[_0x5e98('0x8')](_0x2d62e6,function(_0x4743e0){if(_0x4743e0[_0x5e98('0xf')][_0x5e98('0x99')]!==_0x5e98('0x9a')){var _0x276712={};_0x276712[_0x4743e0[_0x5e98('0x5')]]={'$like':'%'+_0x38c0dd[_0x5e98('0x7c')][_0x5e98('0x4')]+'%'};return _0x276712;}})});}var _0xab9bb8=[];var _0x542195=null;var _0x417b8c={};if(_0x4cb7ce){_0x542195=_[_0x5e98('0x87')](_0x599ea9,[_0x5e98('0xc'),_0x4cb7ce[_0x5e98('0xc')]]);if(_0x542195['field']){_0x417b8c={};if(_0x53db7a['childModel']===_0x5e98('0x9b')){_0x417b8c[_0x542195[_0x5e98('0x9c')]]=_[_0x5e98('0x8')](_0x4cb7ce[_0x5e98('0x7')],'id');}else{_0x417b8c[_0x542195['foreignKey']]=_0x4cb7ce[_0x5e98('0x7')];}_0xab9bb8[_0x5e98('0x85')](_0x417b8c);}else{_0x2e13a9['where']['id']=_0x4cb7ce['associatedResources'];}}else{for(var _0xe416a3=0x0;_0xe416a3<_0x19c9e9[_0x5e98('0x84')];_0xe416a3++){_0x542195=_[_0x5e98('0x87')](_0x599ea9,['name',_0x19c9e9[_0xe416a3][_0x5e98('0xc')]]);if(_0x542195[_0x5e98('0x5')]){_0x417b8c={};_0x417b8c[_0x542195[_0x5e98('0x9c')]]=_0x19c9e9[_0xe416a3][_0x5e98('0x7')];_0xab9bb8['push'](_0x417b8c);}else{if(!_0x2e13a9[_0x5e98('0x79')]['id'])_0x2e13a9[_0x5e98('0x79')]['id']=[];_0x19c9e9[_0xe416a3]['associatedResources']['forEach'](function(_0x185cb3){_0x2e13a9[_0x5e98('0x79')]['id'][_0x5e98('0x85')](_0x185cb3);});}}}if(!_[_0x5e98('0x83')](_0xab9bb8)){_0x2e13a9[_0x5e98('0x79')]=_[_0x5e98('0x9d')](_0x2e13a9[_0x5e98('0x79')],{'$and':{'$or':_0xab9bb8}});}_0x2e13a9=_['merge']({},_0x2e13a9,_0x38c0dd[_0x5e98('0x9e')]);if(_0x4cb7ce&&!_0x4cb7ce[_0x5e98('0x9f')]&&_0x53db7a[_0x5e98('0x12')]==='AnalyticExtractedReport'){if(_0x38c0dd['query'][_0x5e98('0xa0')]){_0x2e13a9['include']=[{'all':!![]}];}return _0x3fd4be[_0x53db7a[_0x5e98('0x12')]]['findAll'](_0x2e13a9)[_0x5e98('0x6')](function(_0x37921e){var _0x117e55=[];_0x37921e['forEach'](function(_0x1b93a8){var _0x1ea3fa;switch(_0x1b93a8[_0x5e98('0xa1')]){case _0x5e98('0xa2'):_0x1ea3fa=_['find'](_0x4cb7ce[_0x5e98('0x7')],function(_0x57cc0f){return _0x57cc0f['id']===_0x1b93a8['reportId']&&_0x57cc0f[_0x5e98('0xf')]===_0x5e98('0xa3');});break;case _0x5e98('0xa4'):_0x1ea3fa=_[_0x5e98('0x87')](_0x4cb7ce['associatedResources'],function(_0x4b642d){return _0x4b642d['id']===_0x1b93a8[_0x5e98('0x70')]&&_0x4b642d[_0x5e98('0xf')]===_0x5e98('0xa5');});break;}if(_0x1ea3fa)_0x117e55['push'](_0x1b93a8);});_0x472b9c[_0x5e98('0xa6')]=_0x117e55['length'];_0x472b9c[_0x5e98('0xa7')]=_0x117e55;return _0x472b9c;});}else{if(!_[_0x5e98('0x83')](_0x38c0dd[_0x5e98('0x7c')]['ids'])){_0x2e13a9[_0x5e98('0x79')]['id']=_0x2e13a9[_0x5e98('0x79')]['id']?_['intersection'](_0x2e13a9[_0x5e98('0x79')]['id'],_0x38c0dd[_0x5e98('0x7c')][_0x5e98('0xa8')]):_0x38c0dd[_0x5e98('0x7c')]['ids'];if(_0x38c0dd[_0x5e98('0x7c')][_0x5e98('0xa9')]){_0x2e13a9[_0x5e98('0x96')]=_0x38c0dd['query']['customSorting'];}}if(_0x38c0dd[_0x5e98('0x7c')][_0x5e98('0xaa')]){_0x2e13a9['where']=_[_0x5e98('0x9d')](_0x2e13a9[_0x5e98('0x79')],{'$and':_0x38c0dd[_0x5e98('0x7c')]['extraQueryConditions']});}return _0x3fd4be[_0x53db7a[_0x5e98('0x12')]]['count']({'where':_0x2e13a9[_0x5e98('0x79')]})['then'](function(_0x5c6002){_0x472b9c[_0x5e98('0xa6')]=_0x5c6002;if(_0x38c0dd['query'][_0x5e98('0xa0')]){if(_0x53db7a['childModel']===_0x5e98('0xab')){_0x2e13a9[_0x5e98('0xac')]=[{'model':_0x3fd4be['Tag'],'as':'Tags','attributes':['id',_0x5e98('0xc'),'color'],'required':_0x38c0dd[_0x5e98('0x7c')][_0x5e98('0xad')]?!![]:![]},{'model':_0x3fd4be[_0x5e98('0xae')],'as':'ThroughTags','attributes':['id',_0x5e98('0xc'),'color'],'through':_0x38c0dd['query'][_0x5e98('0xad')]?{'attributes':[],'where':{'TagId':_0x38c0dd['query'][_0x5e98('0xad')]||undefined}}:{},'required':_0x38c0dd[_0x5e98('0x7c')][_0x5e98('0xad')]?!![]:![]}];}else{_0x2e13a9['include']=[{'all':!![]}];}}return _0x3fd4be[_0x53db7a[_0x5e98('0x12')]][_0x5e98('0xb')](_0x2e13a9);})[_0x5e98('0x6')](function(_0xdfbfc0){_0x472b9c[_0x5e98('0xa7')]=_0xdfbfc0;if(_0x2cab40===_0x5e98('0x2f')&&_0x38c0dd[_0x5e98('0x7c')][_0x5e98('0xaf')]==='true'){var _0x4c888e=[];for(var _0x24e879=0x0;_0x24e879<_0x472b9c[_0x5e98('0xa7')][_0x5e98('0x84')];_0x24e879++){_0x4c888e[_0x5e98('0x85')](_0x48b1ef(_0x5e98('0xb0'),_0x472b9c[_0x5e98('0xa7')][_0x24e879][_0x5e98('0xb1')]));_0x4c888e['push'](_0x48b1ef(_0x5e98('0xb2'),_0x472b9c['rows'][_0x24e879]['dataValues']));_0x4c888e[_0x5e98('0x85')](_0x48b1ef('fax',_0x472b9c[_0x5e98('0xa7')][_0x24e879][_0x5e98('0xb1')]));_0x4c888e['push'](_0x48b1ef(_0x5e98('0xb3'),_0x472b9c[_0x5e98('0xa7')][_0x24e879][_0x5e98('0xb1')]));_0x4c888e[_0x5e98('0x85')](_0x48b1ef('openchannel',_0x472b9c[_0x5e98('0xa7')][_0x24e879]['dataValues']));_0x4c888e[_0x5e98('0x85')](_0x48b1ef('whatsapp',_0x472b9c[_0x5e98('0xa7')][_0x24e879]['dataValues']));}return Promise[_0x5e98('0x89')](_0x4c888e)['then'](function(){return _0x472b9c;});}return _0x472b9c;});}});}}});};