Built motion from commit 3c2ce842.|2.6.31
[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 _0x4ca4=['admin','Telephones','zendeskaccounts','ZendeskAccount','salesforceaccounts','SalesforceAccount','freshdeskaccounts','FreshdeskAccount','sugarcrmaccounts','deskaccounts','DeskAccount','ZohoAccount','vtigeraccounts','cannedanswers','dispositions','customdashboards','Dashboard','intervals','Interval','pauses','scheduler','Schedule','sounds','Sound','tags','Tag','templates','Template','triggers','trunks','Trunk','variables','Variable','plugins','extractedreports','Reports','reportId','metrics','toUpperCase','slice','QueryTypes','SELECT','select','ui.','ui.createdAt','from','_interactions','where','sequelize','toString','OpenTabs','define','UserProfile','user_profiles','raw','query','section','mergeResources','Invalid\x20section\x20\x27','isEmpty','push','UserProfileSection','find','params','all','ignore','union','length','rawAttributes','keys','filters','intersection','attributes','fields','nolimit','limit','offset','order','sort','pick','merge','key','VIRTUAL','foreignKey','forEach','options','autoAssociation','include','default','custom','ids','customSorting','extraQueryConditions','count','includeAll','CmContact','color','tag','ThroughTags','rows','openTabs','true','chat','dataValues','sms','fax','mail','whatsapp','./userProfile.attributes','exports','models','filter','field','value','then','associatedResources','map','catch','model','findAll','resolve','UserProfileResource','AnalyticExtractedReport','type','resourceId','squareprojects','SquareProject','SquareOdbc','squarerecordings','parentSections','SquareProjects','name','projectName','projects','JscriptyProject','contacts','childModel','Lists','ListId','lists','CmList','CmCompany','globalcustomfields','CmCustomField','ChatQueue','FaxQueue','internalroutes','outboundroutes','VoiceExtension','contexts','VoiceContext','voicemails','voicerecordings','Agents','User','role','agent','membername','telephone','queue','VoiceQueue','inbound','QueueCampaigns','outbound','VoiceMusicOnHold','VoiceChanSpy','voiceprefixes','ivrcampaigns','Campaign','MailQueue','mailaccounts','mailsubstatuses','MailSubstatus','openchannelqueues','smsqueues','SmsQueue','smsaccounts','SmsAccount','WhatsappQueue','whatsappaccounts','WhatsappAccount','teams','Team','voicequeues','queuecampaigns','users','agents','telephones'];(function(_0x5218c0,_0x2591df){var _0xc5dba=function(_0x54f32d){while(--_0x54f32d){_0x5218c0['push'](_0x5218c0['shift']());}};_0xc5dba(++_0x2591df);}(_0x4ca4,0x6c));var _0x44ca=function(_0x4c04b0,_0x173f9f){_0x4c04b0=_0x4c04b0-0x0;var _0x443938=_0x4ca4[_0x4c04b0];return _0x443938;};'use strict';var _=require('lodash');var attributes=require(_0x44ca('0x0'));var squel=require('squel');module[_0x44ca('0x1')]=function(_0x43cbaa){var _0x3737c5=_0x43cbaa[_0x44ca('0x2')];function _0x5e55bc(_0x755c3b,_0x46e6b7){return new Promise(function(_0x4bcec7,_0x378117){if(!_0x46e6b7)return _0x4bcec7(null);var _0x5eb7a8=_0x46e6b7[_0x44ca('0x3')]?{[_0x46e6b7[_0x44ca('0x3')][_0x44ca('0x4')]]:_0x46e6b7['filter'][_0x44ca('0x5')]}:undefined;return _0x3737c5[_0x755c3b]['findAll']({'where':_0x5eb7a8,'raw':!![]})[_0x44ca('0x6')](function(_0x1cc929){_0x46e6b7[_0x44ca('0x7')]=_[_0x44ca('0x8')](_0x1cc929,'id');_0x4bcec7(_0x46e6b7);})[_0x44ca('0x9')](function(_0x1a2a80){_0x378117(_0x1a2a80);});});}function _0x1cff24(_0x28fafd,_0x2923e1){return new Promise(function(_0x1c8e89,_0x3978bf){var _0x4a66d2=_0x28fafd['filter']?{[_0x28fafd[_0x44ca('0x3')]['field']]:_0x28fafd[_0x44ca('0x3')][_0x44ca('0x5')]}:undefined;return _0x3737c5[_0x28fafd[_0x44ca('0xa')]][_0x44ca('0xb')]({'where':_0x4a66d2,'raw':!![]})['then'](function(_0x1e5a66){_0x2923e1[_0x44ca('0x7')]=_[_0x44ca('0x8')](_0x1e5a66,function(_0x280909){return _0x280909['name'];});_0x1c8e89(_0x2923e1);})['catch'](function(_0x5123f5){_0x3978bf(_0x5123f5);});});}function _0x139947(_0x268138,_0x20ae4c,_0x36b735){if(!_0x20ae4c)return Promise[_0x44ca('0xc')](null);return new Promise(function(_0x5b33b3,_0x3cd9fc){return _0x3737c5[_0x44ca('0xd')][_0x44ca('0xb')]({'where':{'sectionId':_0x20ae4c['id']},'raw':!![]})[_0x44ca('0x6')](function(_0x4216b7){if(_0x268138['field']&&_0x268138['field']!=='id'){_0x20ae4c['associatedResources']=_['map'](_0x4216b7,function(_0x3b2161){return _0x3b2161[_0x268138[_0x44ca('0x4')]];});}else{if(_0x36b735===_0x44ca('0xe')){_0x20ae4c[_0x44ca('0x7')]=_[_0x44ca('0x8')](_0x4216b7,function(_0x21619d){return{'id':_0x21619d['resourceId'],'type':_0x21619d[_0x44ca('0xf')]};});}else{_0x20ae4c[_0x44ca('0x7')]=_['map'](_0x4216b7,function(_0x1d6544){return _0x1d6544[_0x44ca('0x10')];});}}_0x5b33b3(_0x20ae4c);})[_0x44ca('0x9')](function(_0x2ee2af){_0x3cd9fc(_0x2ee2af);});});}function _0x2118ef(_0x85c8ad,_0x1209ac){var _0x190060={'parentSections':[]};switch(_0x85c8ad['toLowerCase']()){case _0x44ca('0x11'):_0x190060['childModel']=_0x44ca('0x12');break;case'odbc':_0x190060['childModel']=_0x44ca('0x13');break;case _0x44ca('0x14'):_0x190060['childModel']='SquareRecording';_0x190060[_0x44ca('0x15')]=[{'name':_0x44ca('0x16'),'field':_0x44ca('0x17'),'foreignKey':_0x44ca('0x18')}];break;case _0x44ca('0x19'):_0x190060['childModel']=_0x44ca('0x1a');break;case _0x44ca('0x1b'):_0x190060[_0x44ca('0x1c')]='CmContact';_0x190060[_0x44ca('0x15')]=[{'name':_0x44ca('0x1d'),'field':'id','foreignKey':_0x44ca('0x1e')}];break;case _0x44ca('0x1f'):_0x190060[_0x44ca('0x1c')]=_0x44ca('0x20');break;case'companies':_0x190060['childModel']=_0x44ca('0x21');break;case _0x44ca('0x22'):_0x190060[_0x44ca('0x1c')]=_0x44ca('0x23');break;case'chatqueues':_0x190060[_0x44ca('0x1c')]=_0x44ca('0x24');break;case'chatwebsites':_0x190060[_0x44ca('0x1c')]='ChatWebsite';break;case'faxqueues':_0x190060[_0x44ca('0x1c')]=_0x44ca('0x25');break;case'faxaccounts':_0x190060['childModel']='FaxAccount';break;case'inboundroutes':case _0x44ca('0x26'):case _0x44ca('0x27'):_0x190060[_0x44ca('0x1c')]=_0x44ca('0x28');break;case _0x44ca('0x29'):_0x190060[_0x44ca('0x1c')]=_0x44ca('0x2a');break;case _0x44ca('0x2b'):_0x190060['childModel']='VoiceMail';break;case _0x44ca('0x2c'):_0x190060['childModel']='VoiceRecording';_0x190060[_0x44ca('0x15')]=[{'name':_0x44ca('0x2d'),'field':_0x44ca('0x17'),'foreignKey':'membername','model':_0x44ca('0x2e'),'filter':{'field':_0x44ca('0x2f'),'value':[_0x44ca('0x30')]}},{'name':'Telephones','field':_0x44ca('0x17'),'foreignKey':_0x44ca('0x31'),'model':_0x44ca('0x2e'),'filter':{'field':_0x44ca('0x2f'),'value':[_0x44ca('0x32')]}},{'name':'VoiceQueues','field':_0x44ca('0x17'),'foreignKey':_0x44ca('0x33'),'model':_0x44ca('0x34'),'filter':{'field':'type','value':[_0x44ca('0x35')]}},{'name':_0x44ca('0x36'),'field':_0x44ca('0x17'),'foreignKey':_0x44ca('0x33'),'model':_0x44ca('0x34'),'filter':{'field':_0x44ca('0xf'),'value':[_0x44ca('0x37')]}}];break;case'musiconholds':_0x190060[_0x44ca('0x1c')]=_0x44ca('0x38');break;case'chanspies':_0x190060[_0x44ca('0x1c')]=_0x44ca('0x39');break;case _0x44ca('0x3a'):_0x190060[_0x44ca('0x1c')]='VoicePrefix';break;case _0x44ca('0x3b'):_0x190060[_0x44ca('0x1c')]=_0x44ca('0x3c');break;case'mailqueues':_0x190060['childModel']=_0x44ca('0x3d');break;case _0x44ca('0x3e'):_0x190060['childModel']='MailAccount';break;case _0x44ca('0x3f'):_0x190060[_0x44ca('0x1c')]=_0x44ca('0x40');break;case _0x44ca('0x41'):_0x190060[_0x44ca('0x1c')]='OpenchannelQueue';break;case'openchannelaccounts':_0x190060['childModel']='OpenchannelAccount';break;case _0x44ca('0x42'):_0x190060[_0x44ca('0x1c')]=_0x44ca('0x43');break;case _0x44ca('0x44'):_0x190060[_0x44ca('0x1c')]=_0x44ca('0x45');break;case'whatsappqueues':_0x190060['childModel']=_0x44ca('0x46');break;case _0x44ca('0x47'):_0x190060[_0x44ca('0x1c')]=_0x44ca('0x48');break;case _0x44ca('0x49'):_0x190060[_0x44ca('0x1c')]=_0x44ca('0x4a');break;case _0x44ca('0x4b'):case _0x44ca('0x4c'):_0x190060['childModel']='VoiceQueue';if(_0x1209ac){_0x190060[_0x44ca('0x15')]=[{'name':'VoiceQueues'},{'name':'QueueCampaigns'}];}break;case _0x44ca('0x4d'):case _0x44ca('0x4e'):case _0x44ca('0x4f'):_0x190060[_0x44ca('0x1c')]=_0x44ca('0x2e');if(_0x1209ac){_0x190060[_0x44ca('0x15')]=[{'name':'Users','filter':{'field':'role','value':[_0x44ca('0x50'),'user']},'ignore':!![]},{'name':_0x44ca('0x2d')},{'name':_0x44ca('0x51')}];}break;case _0x44ca('0x52'):_0x190060[_0x44ca('0x1c')]=_0x44ca('0x53');break;case _0x44ca('0x54'):_0x190060[_0x44ca('0x1c')]=_0x44ca('0x55');break;case _0x44ca('0x56'):_0x190060['childModel']=_0x44ca('0x57');break;case _0x44ca('0x58'):_0x190060[_0x44ca('0x1c')]='SugarcrmAccount';break;case _0x44ca('0x59'):_0x190060[_0x44ca('0x1c')]=_0x44ca('0x5a');break;case'zohoaccounts':_0x190060[_0x44ca('0x1c')]=_0x44ca('0x5b');break;case _0x44ca('0x5c'):_0x190060[_0x44ca('0x1c')]=_0x44ca('0x2e');break;case _0x44ca('0x5d'):_0x190060['childModel']='CannedAnswer';break;case _0x44ca('0x5e'):_0x190060[_0x44ca('0x1c')]='Disposition';break;case _0x44ca('0x5f'):_0x190060[_0x44ca('0x1c')]=_0x44ca('0x60');break;case _0x44ca('0x61'):_0x190060['childModel']=_0x44ca('0x62');break;case _0x44ca('0x63'):_0x190060[_0x44ca('0x1c')]='Pause';break;case _0x44ca('0x64'):_0x190060[_0x44ca('0x1c')]=_0x44ca('0x65');break;case _0x44ca('0x66'):_0x190060[_0x44ca('0x1c')]=_0x44ca('0x67');break;case _0x44ca('0x68'):_0x190060[_0x44ca('0x1c')]=_0x44ca('0x69');break;case _0x44ca('0x6a'):_0x190060[_0x44ca('0x1c')]=_0x44ca('0x6b');break;case _0x44ca('0x6c'):_0x190060['childModel']='Trigger';break;case _0x44ca('0x6d'):_0x190060[_0x44ca('0x1c')]=_0x44ca('0x6e');break;case _0x44ca('0x6f'):_0x190060['childModel']=_0x44ca('0x70');break;case _0x44ca('0x71'):_0x190060[_0x44ca('0x1c')]='Plugin';break;case _0x44ca('0x72'):_0x190060['childModel']=_0x44ca('0xe');_0x190060[_0x44ca('0x15')]=[{'name':_0x44ca('0x73'),'field':'id','foreignKey':_0x44ca('0x74')}];break;case _0x44ca('0x75'):_0x190060[_0x44ca('0x1c')]='AnalyticMetric';break;}return _0x190060;}function _0x1b49db(_0xe529a6,_0x798eb){var _0xe08dc8=_0xe529a6['charAt'](0x0)[_0x44ca('0x76')]()+_0xe529a6[_0x44ca('0x77')](0x1);var _0xf1f0bc={'type':_0x3737c5['Sequelize'][_0x44ca('0x78')][_0x44ca('0x79')],'raw':!![]};return new Promise(function(_0x291720,_0x51d82f){var _0x556996=squel[_0x44ca('0x7a')]()[_0x44ca('0x4')](_0x44ca('0x7b')+_0xe08dc8+'InteractionId','id')[_0x44ca('0x4')](_0x44ca('0x7c'))[_0x44ca('0x7d')]('user_has_'+_0xe529a6+_0x44ca('0x7e'),'ui')[_0x44ca('0x7f')]('ui.UserId\x20=\x20?',_0x798eb['id']);return _0x3737c5[_0x44ca('0x80')]['query'](_0x556996[_0x44ca('0x81')](),_0xf1f0bc)[_0x44ca('0x6')](function(_0x432895){_0x798eb[_0xe08dc8+_0x44ca('0x82')]=_0x432895;_0x291720(_0x432895);})[_0x44ca('0x9')](function(_0xe51d15){_0x51d82f(_0xe51d15);});});}return _0x43cbaa[_0x44ca('0x83')](_0x44ca('0x84'),attributes,{'tableName':_0x44ca('0x85'),'paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x174a1d){var _0xab2fc1=require('../../components/parsers/qs');var _0xac705={'raw':_0x174a1d['query'][_0x44ca('0x86')],'where':{}};var _0xf4b177={};var _0x1b4bf={'count':0x0,'rows':[]};var _0x3499e3=_0x174a1d[_0x44ca('0x87')][_0x44ca('0x88')];var _0x592628=_0x174a1d['query'][_0x44ca('0x89')]||![];var _0x59c7d3=_0x2118ef(_0x3499e3,_0x592628);if(!_0x59c7d3[_0x44ca('0x1c')])throw new Error(_0x44ca('0x8a')+_0x3499e3+'\x27');var _0x520f44=[{'name':_0x3499e3}];if(!_[_0x44ca('0x8b')](_0x59c7d3['parentSections']))_0x520f44=_0x59c7d3[_0x44ca('0x15')];var _0x5436e1=[];for(var _0x546bb7=0x0;_0x546bb7<_0x520f44['length'];_0x546bb7++){_0x5436e1[_0x44ca('0x8c')](_0x3737c5[_0x44ca('0x8d')][_0x44ca('0x8e')]({'where':{'userProfileId':_0x174a1d[_0x44ca('0x8f')]['id'],'name':_0x520f44[_0x546bb7][_0x44ca('0x17')]},'raw':!![]}));}return Promise[_0x44ca('0x90')](_0x5436e1)[_0x44ca('0x6')](function(_0xf4c885){var _0x31d618=_[_0x44ca('0x3')](_0xf4c885,function(_0x27a1f9){return _0x27a1f9?_0x27a1f9:undefined;});var _0x4eef4f=_[_0x44ca('0x3')](_0x520f44,[_0x44ca('0x91'),!![]]);var _0x51d7ff=_[_0x44ca('0x8b')](_0x31d618)&&_['isEmpty'](_0x4eef4f)?null:_[_0x44ca('0x92')](_0x4eef4f,_0x31d618);if(!_0x51d7ff)return null;var _0x4e5a8c=[];for(var _0x2a9b67=0x0;_0x2a9b67<_0x51d7ff[_0x44ca('0x93')];_0x2a9b67++){var _0x2f1f96=_[_0x44ca('0x8e')](_0x520f44,function(_0x2576f0){return _0x51d7ff[_0x2a9b67]?_0x2576f0[_0x44ca('0x17')]===_0x51d7ff[_0x2a9b67]['name']:null;});if(_0x2f1f96){if(_0x51d7ff[_0x2a9b67][_0x44ca('0x91')]){_0x4e5a8c[_0x44ca('0x8c')](_0x5e55bc(_0x59c7d3[_0x44ca('0x1c')],_0x51d7ff[_0x2a9b67]));}else{if(!_0x51d7ff[_0x2a9b67]['autoAssociation']){_0x4e5a8c[_0x44ca('0x8c')](_0x139947(_0x2f1f96,_0x51d7ff[_0x2a9b67],_0x59c7d3[_0x44ca('0x1c')]));}else{if(_0x2f1f96[_0x44ca('0xa')]){_0x4e5a8c[_0x44ca('0x8c')](_0x1cff24(_0x2f1f96,_0x51d7ff[_0x2a9b67]));}}}}}return Promise[_0x44ca('0x90')](_0x4e5a8c);})['then'](function(_0x2f0201){var _0x206af0=_0x2f0201;var _0x5c8b50=null;if(_0x206af0){_0x5c8b50=_0x206af0[_0x44ca('0x93')]===0x1?_0x206af0[0x0]:null;}if(!_0x5c8b50&&!_0x206af0)return _0x1b4bf;var _0x4d9d98=_0x3737c5[_0x59c7d3[_0x44ca('0x1c')]][_0x44ca('0x94')];_0xf4b177['model']=_[_0x44ca('0x95')](_0x4d9d98);_0xf4b177['query']=_[_0x44ca('0x95')](_0x174a1d[_0x44ca('0x87')]);_0xf4b177[_0x44ca('0x96')]=_[_0x44ca('0x97')](_0xf4b177[_0x44ca('0xa')],_0xf4b177[_0x44ca('0x87')]);_0xac705[_0x44ca('0x98')]=_['intersection'](_0xf4b177[_0x44ca('0xa')],_0xab2fc1['fields'](_0x174a1d[_0x44ca('0x87')][_0x44ca('0x99')]));_0xac705[_0x44ca('0x98')]=_0xac705['attributes'][_0x44ca('0x93')]?_0xac705[_0x44ca('0x98')]:_0xf4b177[_0x44ca('0xa')];if(!_0x174a1d[_0x44ca('0x87')]['hasOwnProperty'](_0x44ca('0x9a'))){_0xac705[_0x44ca('0x9b')]=_0xab2fc1[_0x44ca('0x9b')](_0x174a1d[_0x44ca('0x87')][_0x44ca('0x9b')]);_0xac705[_0x44ca('0x9c')]=_0xab2fc1[_0x44ca('0x9c')](_0x174a1d[_0x44ca('0x87')][_0x44ca('0x9c')]);}_0xac705[_0x44ca('0x9d')]=_0xab2fc1[_0x44ca('0x9e')](_0x174a1d[_0x44ca('0x87')][_0x44ca('0x9e')]);_0xac705[_0x44ca('0x7f')]=_0xab2fc1['filters'](_[_0x44ca('0x9f')](_0x174a1d['query'],_0xf4b177[_0x44ca('0x96')]));if(_0x174a1d['query'][_0x44ca('0x3')]){_0xac705['where']=_[_0x44ca('0xa0')](_0xac705[_0x44ca('0x7f')],{'$or':_['map'](_0x4d9d98,function(_0x14ea31){if(_0x14ea31[_0x44ca('0xf')][_0x44ca('0xa1')]!==_0x44ca('0xa2')){var _0x25ba10={};_0x25ba10[_0x14ea31[_0x44ca('0x4')]]={'$like':'%'+_0x174a1d[_0x44ca('0x87')]['filter']+'%'};return _0x25ba10;}})});}var _0x5ea42d=[];var _0x3e2d62=null;var _0x23f90d={};if(_0x5c8b50){_0x3e2d62=_[_0x44ca('0x8e')](_0x520f44,[_0x44ca('0x17'),_0x5c8b50[_0x44ca('0x17')]]);if(_0x3e2d62[_0x44ca('0x4')]){_0x23f90d={};if(_0x59c7d3[_0x44ca('0x1c')]==='AnalyticExtractedReport'){_0x23f90d[_0x3e2d62[_0x44ca('0xa3')]]=_[_0x44ca('0x8')](_0x5c8b50[_0x44ca('0x7')],'id');}else{_0x23f90d[_0x3e2d62[_0x44ca('0xa3')]]=_0x5c8b50[_0x44ca('0x7')];}_0x5ea42d['push'](_0x23f90d);}else{_0xac705[_0x44ca('0x7f')]['id']=_0x5c8b50[_0x44ca('0x7')];}}else{for(var _0x231c2d=0x0;_0x231c2d<_0x206af0[_0x44ca('0x93')];_0x231c2d++){_0x3e2d62=_[_0x44ca('0x8e')](_0x520f44,['name',_0x206af0[_0x231c2d][_0x44ca('0x17')]]);if(_0x3e2d62[_0x44ca('0x4')]){_0x23f90d={};_0x23f90d[_0x3e2d62[_0x44ca('0xa3')]]=_0x206af0[_0x231c2d][_0x44ca('0x7')];_0x5ea42d['push'](_0x23f90d);}else{if(!_0xac705[_0x44ca('0x7f')]['id'])_0xac705[_0x44ca('0x7f')]['id']=[];_0x206af0[_0x231c2d][_0x44ca('0x7')][_0x44ca('0xa4')](function(_0x3025f4){_0xac705[_0x44ca('0x7f')]['id']['push'](_0x3025f4);});}}}if(!_[_0x44ca('0x8b')](_0x5ea42d)){_0xac705[_0x44ca('0x7f')]=_[_0x44ca('0xa0')](_0xac705[_0x44ca('0x7f')],{'$and':{'$or':_0x5ea42d}});}_0xac705=_[_0x44ca('0xa0')]({},_0xac705,_0x174a1d[_0x44ca('0xa5')]);if(_0x5c8b50&&!_0x5c8b50[_0x44ca('0xa6')]&&_0x59c7d3['childModel']==='AnalyticExtractedReport'){if(_0x174a1d['query']['includeAll']){_0xac705[_0x44ca('0xa7')]=[{'all':!![]}];}return _0x3737c5[_0x59c7d3[_0x44ca('0x1c')]][_0x44ca('0xb')](_0xac705)[_0x44ca('0x6')](function(_0x14e3f7){var _0x55a2f6=[];_0x14e3f7[_0x44ca('0xa4')](function(_0x1efe3d){var _0x17be2f;switch(_0x1efe3d['reportType']){case _0x44ca('0xa8'):_0x17be2f=_[_0x44ca('0x8e')](_0x5c8b50[_0x44ca('0x7')],function(_0x5589d8){return _0x5589d8['id']===_0x1efe3d['reportId']&&_0x5589d8[_0x44ca('0xf')]==='DefaultReports';});break;case _0x44ca('0xa9'):_0x17be2f=_['find'](_0x5c8b50[_0x44ca('0x7')],function(_0x450a16){return _0x450a16['id']===_0x1efe3d['reportId']&&_0x450a16[_0x44ca('0xf')]==='CustomReports';});break;}if(_0x17be2f)_0x55a2f6[_0x44ca('0x8c')](_0x1efe3d);});_0x1b4bf['count']=_0x55a2f6[_0x44ca('0x93')];_0x1b4bf['rows']=_0x55a2f6;return _0x1b4bf;});}else{if(!_[_0x44ca('0x8b')](_0x174a1d['query'][_0x44ca('0xaa')])){_0xac705[_0x44ca('0x7f')]['id']=_0xac705['where']['id']?_['intersection'](_0xac705['where']['id'],_0x174a1d[_0x44ca('0x87')][_0x44ca('0xaa')]):_0x174a1d[_0x44ca('0x87')][_0x44ca('0xaa')];if(_0x174a1d[_0x44ca('0x87')][_0x44ca('0xab')]){_0xac705[_0x44ca('0x9d')]=_0x174a1d[_0x44ca('0x87')]['customSorting'];}}if(_0x174a1d['query']['extraQueryConditions']){_0xac705['where']=_[_0x44ca('0xa0')](_0xac705['where'],{'$and':_0x174a1d[_0x44ca('0x87')][_0x44ca('0xac')]});}return _0x3737c5[_0x59c7d3[_0x44ca('0x1c')]]['count']({'where':_0xac705['where']})[_0x44ca('0x6')](function(_0x187cb7){_0x1b4bf[_0x44ca('0xad')]=_0x187cb7;if(_0x174a1d[_0x44ca('0x87')][_0x44ca('0xae')]){if(_0x59c7d3[_0x44ca('0x1c')]===_0x44ca('0xaf')){_0xac705[_0x44ca('0xa7')]=[{'model':_0x3737c5[_0x44ca('0x69')],'as':'Tags','attributes':['id','name',_0x44ca('0xb0')],'required':_0x174a1d[_0x44ca('0x87')][_0x44ca('0xb1')]?!![]:![]},{'model':_0x3737c5[_0x44ca('0x69')],'as':_0x44ca('0xb2'),'attributes':['id',_0x44ca('0x17'),_0x44ca('0xb0')],'through':_0x174a1d[_0x44ca('0x87')][_0x44ca('0xb1')]?{'attributes':[],'where':{'TagId':_0x174a1d[_0x44ca('0x87')][_0x44ca('0xb1')]||undefined}}:{},'required':_0x174a1d[_0x44ca('0x87')][_0x44ca('0xb1')]?!![]:![]}];}else{_0xac705[_0x44ca('0xa7')]=[{'all':!![]}];}}return _0x3737c5[_0x59c7d3[_0x44ca('0x1c')]]['findAll'](_0xac705);})[_0x44ca('0x6')](function(_0x5b85d4){_0x1b4bf[_0x44ca('0xb3')]=_0x5b85d4;if(_0x3499e3===_0x44ca('0x2d')&&_0x174a1d[_0x44ca('0x87')][_0x44ca('0xb4')]===_0x44ca('0xb5')){var _0x610083=[];for(var _0x4801da=0x0;_0x4801da<_0x1b4bf['rows'][_0x44ca('0x93')];_0x4801da++){_0x610083['push'](_0x1b49db(_0x44ca('0xb6'),_0x1b4bf[_0x44ca('0xb3')][_0x4801da][_0x44ca('0xb7')]));_0x610083['push'](_0x1b49db(_0x44ca('0xb8'),_0x1b4bf[_0x44ca('0xb3')][_0x4801da]['dataValues']));_0x610083[_0x44ca('0x8c')](_0x1b49db(_0x44ca('0xb9'),_0x1b4bf['rows'][_0x4801da][_0x44ca('0xb7')]));_0x610083[_0x44ca('0x8c')](_0x1b49db(_0x44ca('0xba'),_0x1b4bf[_0x44ca('0xb3')][_0x4801da][_0x44ca('0xb7')]));_0x610083[_0x44ca('0x8c')](_0x1b49db('openchannel',_0x1b4bf[_0x44ca('0xb3')][_0x4801da]['dataValues']));_0x610083[_0x44ca('0x8c')](_0x1b49db(_0x44ca('0xbb'),_0x1b4bf[_0x44ca('0xb3')][_0x4801da][_0x44ca('0xb7')]));}return Promise[_0x44ca('0x90')](_0x610083)['then'](function(){return _0x1b4bf;});}return _0x1b4bf;});}});}}});};