Built motion from commit 639a1a7f.|2.6.19
[motion2.git] / server / api / userProfile / userProfile.model.js
index 5380477..8aba751 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x3fc2=['UserProfileSection','find','params','all','ignore','union','model','rawAttributes','keys','filters','attributes','fields','hasOwnProperty','limit','offset','order','sort','pick','key','VIRTUAL','forEach','merge','options','autoAssociation','includeAll','reportType','default','DefaultReports','CustomReports','count','intersection','ids','customSorting','Tag','Tags','color','tag','include','rows','openTabs','true','dataValues','sms','fax','mail','openchannel','whatsapp','lodash','./userProfile.attributes','../../components/parsers/qs','exports','models','filter','field','findAll','associatedResources','map','catch','value','then','name','resolve','UserProfileResource','AnalyticExtractedReport','type','resourceId','toLowerCase','SquareProject','odbc','childModel','SquareOdbc','squarerecordings','SquareRecording','parentSections','projectName','projects','JscriptyProject','contacts','CmContact','Lists','ListId','companies','CmCompany','globalcustomfields','CmCustomField','chatqueues','ChatQueue','ChatWebsite','faxqueues','FaxQueue','faxaccounts','FaxAccount','inboundroutes','internalroutes','outboundroutes','VoiceExtension','contexts','VoiceContext','voicemails','VoiceMail','Agents','membername','User','role','agent','Telephones','telephone','VoiceQueues','queue','VoiceQueue','inbound','outbound','VoiceMusicOnHold','chanspies','VoiceChanSpy','voiceprefixes','VoicePrefix','ivrcampaigns','Campaign','mailqueues','mailaccounts','MailAccount','mailsubstatuses','MailSubstatus','OpenchannelQueue','openchannelaccounts','OpenchannelAccount','smsqueues','SmsQueue','SmsAccount','WhatsappQueue','whatsappaccounts','WhatsappAccount','Team','QueueCampaigns','users','agents','telephones','Users','admin','zendeskaccounts','SalesforceAccount','freshdeskaccounts','FreshdeskAccount','sugarcrmaccounts','deskaccounts','DeskAccount','vtigeraccounts','CannedAnswer','dispositions','Dashboard','Pause','scheduler','Schedule','sounds','Sound','tags','templates','triggers','Trunk','Variable','plugins','Reports','reportId','metrics','AnalyticMetric','Sequelize','QueryTypes','ui.','InteractionId','from','_interactions','where','ui.UserId\x20=\x20?','sequelize','query','toString','define','UserProfile','user_profiles','raw','section','mergeResources','Invalid\x20section\x20\x27','isEmpty','length','push'];(function(_0x4ef5c3,_0x3c8cda){var _0x263741=function(_0x119cff){while(--_0x119cff){_0x4ef5c3['push'](_0x4ef5c3['shift']());}};_0x263741(++_0x3c8cda);}(_0x3fc2,0x1a5));var _0x23fc=function(_0xaa1154,_0x1a9958){_0xaa1154=_0xaa1154-0x0;var _0x3c08cf=_0x3fc2[_0xaa1154];return _0x3c08cf;};'use strict';var _=require(_0x23fc('0x0'));var attributes=require(_0x23fc('0x1'));var qs=require(_0x23fc('0x2'));var squel=require('squel');module[_0x23fc('0x3')]=function(_0x17578b){var _0x179e49=_0x17578b[_0x23fc('0x4')];function _0x48471c(_0x4dd3e8,_0x2b3963){return new Promise(function(_0x2c5bb5,_0x50ff38){if(!_0x2b3963)return _0x2c5bb5(null);var _0x1c54f9=_0x2b3963['filter']?{[_0x2b3963[_0x23fc('0x5')][_0x23fc('0x6')]]:_0x2b3963['filter']['value']}:undefined;return _0x179e49[_0x4dd3e8][_0x23fc('0x7')]({'where':_0x1c54f9,'raw':!![]})['then'](function(_0x569fe0){_0x2b3963[_0x23fc('0x8')]=_[_0x23fc('0x9')](_0x569fe0,'id');_0x2c5bb5(_0x2b3963);})[_0x23fc('0xa')](function(_0x403b09){_0x50ff38(_0x403b09);});});}function _0x453620(_0x585a9a,_0x37a429){return new Promise(function(_0x429b80,_0x185dcf){var _0x2a86b1=_0x585a9a[_0x23fc('0x5')]?{[_0x585a9a['filter'][_0x23fc('0x6')]]:_0x585a9a['filter'][_0x23fc('0xb')]}:undefined;return _0x179e49[_0x585a9a['model']][_0x23fc('0x7')]({'where':_0x2a86b1,'raw':!![]})[_0x23fc('0xc')](function(_0x1e81b8){_0x37a429[_0x23fc('0x8')]=_['map'](_0x1e81b8,function(_0x3fbf96){return _0x3fbf96[_0x23fc('0xd')];});_0x429b80(_0x37a429);})[_0x23fc('0xa')](function(_0x341ad7){_0x185dcf(_0x341ad7);});});}function _0x295025(_0x16d177,_0x314328,_0x502903){if(!_0x314328)return Promise[_0x23fc('0xe')](null);return new Promise(function(_0x3dc838,_0x5a7225){return _0x179e49[_0x23fc('0xf')][_0x23fc('0x7')]({'where':{'sectionId':_0x314328['id']},'raw':!![]})[_0x23fc('0xc')](function(_0x354893){if(_0x16d177['field']&&_0x16d177[_0x23fc('0x6')]!=='id'){_0x314328[_0x23fc('0x8')]=_['map'](_0x354893,function(_0xbd279b){return _0xbd279b[_0x16d177[_0x23fc('0x6')]];});}else{if(_0x502903===_0x23fc('0x10')){_0x314328['associatedResources']=_[_0x23fc('0x9')](_0x354893,function(_0x540044){return{'id':_0x540044['resourceId'],'type':_0x540044[_0x23fc('0x11')]};});}else{_0x314328[_0x23fc('0x8')]=_[_0x23fc('0x9')](_0x354893,function(_0x5602a6){return _0x5602a6[_0x23fc('0x12')];});}}_0x3dc838(_0x314328);})[_0x23fc('0xa')](function(_0x379b9c){_0x5a7225(_0x379b9c);});});}function _0x2bbf98(_0x78f8af,_0x213980){var _0x32ad38={'parentSections':[]};switch(_0x78f8af[_0x23fc('0x13')]()){case'squareprojects':_0x32ad38['childModel']=_0x23fc('0x14');break;case _0x23fc('0x15'):_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x17');break;case _0x23fc('0x18'):_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x19');_0x32ad38[_0x23fc('0x1a')]=[{'name':'SquareProjects','field':_0x23fc('0xd'),'foreignKey':_0x23fc('0x1b')}];break;case _0x23fc('0x1c'):_0x32ad38['childModel']=_0x23fc('0x1d');break;case _0x23fc('0x1e'):_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x1f');_0x32ad38['parentSections']=[{'name':_0x23fc('0x20'),'field':'id','foreignKey':_0x23fc('0x21')}];break;case'lists':_0x32ad38[_0x23fc('0x16')]='CmList';break;case _0x23fc('0x22'):_0x32ad38['childModel']=_0x23fc('0x23');break;case _0x23fc('0x24'):_0x32ad38['childModel']=_0x23fc('0x25');break;case _0x23fc('0x26'):_0x32ad38['childModel']=_0x23fc('0x27');break;case'chatwebsites':_0x32ad38['childModel']=_0x23fc('0x28');break;case _0x23fc('0x29'):_0x32ad38['childModel']=_0x23fc('0x2a');break;case _0x23fc('0x2b'):_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x2c');break;case _0x23fc('0x2d'):case _0x23fc('0x2e'):case _0x23fc('0x2f'):_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x30');break;case _0x23fc('0x31'):_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x32');break;case _0x23fc('0x33'):_0x32ad38['childModel']=_0x23fc('0x34');break;case'voicerecordings':_0x32ad38[_0x23fc('0x16')]='VoiceRecording';_0x32ad38[_0x23fc('0x1a')]=[{'name':_0x23fc('0x35'),'field':'name','foreignKey':_0x23fc('0x36'),'model':_0x23fc('0x37'),'filter':{'field':_0x23fc('0x38'),'value':[_0x23fc('0x39')]}},{'name':_0x23fc('0x3a'),'field':_0x23fc('0xd'),'foreignKey':_0x23fc('0x36'),'model':_0x23fc('0x37'),'filter':{'field':_0x23fc('0x38'),'value':[_0x23fc('0x3b')]}},{'name':_0x23fc('0x3c'),'field':_0x23fc('0xd'),'foreignKey':_0x23fc('0x3d'),'model':_0x23fc('0x3e'),'filter':{'field':'type','value':[_0x23fc('0x3f')]}},{'name':'QueueCampaigns','field':'name','foreignKey':_0x23fc('0x3d'),'model':_0x23fc('0x3e'),'filter':{'field':_0x23fc('0x11'),'value':[_0x23fc('0x40')]}}];break;case'musiconholds':_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x41');break;case _0x23fc('0x42'):_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x43');break;case _0x23fc('0x44'):_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x45');break;case _0x23fc('0x46'):_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x47');break;case _0x23fc('0x48'):_0x32ad38[_0x23fc('0x16')]='MailQueue';break;case _0x23fc('0x49'):_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x4a');break;case _0x23fc('0x4b'):_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x4c');break;case'openchannelqueues':_0x32ad38['childModel']=_0x23fc('0x4d');break;case _0x23fc('0x4e'):_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x4f');break;case _0x23fc('0x50'):_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x51');break;case'smsaccounts':_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x52');break;case'whatsappqueues':_0x32ad38['childModel']=_0x23fc('0x53');break;case _0x23fc('0x54'):_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x55');break;case'teams':_0x32ad38['childModel']=_0x23fc('0x56');break;case'voicequeues':case'queuecampaigns':_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x3e');if(_0x213980){_0x32ad38[_0x23fc('0x1a')]=[{'name':'VoiceQueues'},{'name':_0x23fc('0x57')}];}break;case _0x23fc('0x58'):case _0x23fc('0x59'):case _0x23fc('0x5a'):_0x32ad38['childModel']=_0x23fc('0x37');if(_0x213980){_0x32ad38[_0x23fc('0x1a')]=[{'name':_0x23fc('0x5b'),'filter':{'field':_0x23fc('0x38'),'value':[_0x23fc('0x5c'),'user']},'ignore':!![]},{'name':_0x23fc('0x35')},{'name':_0x23fc('0x3a')}];}break;case _0x23fc('0x5d'):_0x32ad38['childModel']='ZendeskAccount';break;case'salesforceaccounts':_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x5e');break;case _0x23fc('0x5f'):_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x60');break;case _0x23fc('0x61'):_0x32ad38['childModel']='SugarcrmAccount';break;case _0x23fc('0x62'):_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x63');break;case'zohoaccounts':_0x32ad38[_0x23fc('0x16')]='ZohoAccount';break;case _0x23fc('0x64'):_0x32ad38[_0x23fc('0x16')]='User';break;case'cannedanswers':_0x32ad38[_0x23fc('0x16')]=_0x23fc('0x65');break;case _0x23fc('0x66'):_0x32ad38[_0x23fc('0x16')]='Disposition';break;case'customdashboards':_0x32ad38['childModel']=_0x23fc('0x67');break;case'intervals':_0x32ad38[_0x23fc('0x16')]='Interval';break;case'pauses':_0x32ad38['childModel']=_0x23fc('0x68');break;case _0x23fc('0x69'):_0x32ad38['childModel']=_0x23fc('0x6a');break;case _0x23fc('0x6b'):_0x32ad38['childModel']=_0x23fc('0x6c');break;case _0x23fc('0x6d'):_0x32ad38[_0x23fc('0x16')]='Tag';break;case _0x23fc('0x6e'):_0x32ad38[_0x23fc('0x16')]='Template';break;case _0x23fc('0x6f'):_0x32ad38['childModel']='Trigger';break;case'trunks':_0x32ad38['childModel']=_0x23fc('0x70');break;case'variables':_0x32ad38['childModel']=_0x23fc('0x71');break;case _0x23fc('0x72'):_0x32ad38[_0x23fc('0x16')]='Plugin';break;case'extractedreports':_0x32ad38['childModel']=_0x23fc('0x10');_0x32ad38[_0x23fc('0x1a')]=[{'name':_0x23fc('0x73'),'field':'id','foreignKey':_0x23fc('0x74')}];break;case _0x23fc('0x75'):_0x32ad38['childModel']=_0x23fc('0x76');break;}return _0x32ad38;}function _0x451723(_0x5204f8,_0x9223f7){var _0x26c583=_0x5204f8['charAt'](0x0)['toUpperCase']()+_0x5204f8['slice'](0x1);var _0x3da4fc={'type':_0x179e49[_0x23fc('0x77')][_0x23fc('0x78')]['SELECT'],'raw':!![]};return new Promise(function(_0x83fbcb,_0x12e0f4){var _0x53ead9=squel['select']()[_0x23fc('0x6')](_0x23fc('0x79')+_0x26c583+_0x23fc('0x7a'),'id')[_0x23fc('0x6')]('ui.createdAt')[_0x23fc('0x7b')]('user_has_'+_0x5204f8+_0x23fc('0x7c'),'ui')[_0x23fc('0x7d')](_0x23fc('0x7e'),_0x9223f7['id']);return _0x179e49[_0x23fc('0x7f')][_0x23fc('0x80')](_0x53ead9[_0x23fc('0x81')](),_0x3da4fc)[_0x23fc('0xc')](function(_0x1b0254){_0x9223f7[_0x26c583+'OpenTabs']=_0x1b0254;_0x83fbcb(_0x1b0254);})[_0x23fc('0xa')](function(_0x69895e){_0x12e0f4(_0x69895e);});});}return _0x17578b[_0x23fc('0x82')](_0x23fc('0x83'),attributes,{'tableName':_0x23fc('0x84'),'paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x47b355){var _0x1145d0={'raw':_0x47b355['query'][_0x23fc('0x85')],'where':{}};var _0x594cb4={};var _0x244049={'count':0x0,'rows':[]};var _0x353d8c=_0x47b355[_0x23fc('0x80')][_0x23fc('0x86')];var _0x2da0ca=_0x47b355[_0x23fc('0x80')][_0x23fc('0x87')]||![];var _0x331056=_0x2bbf98(_0x353d8c,_0x2da0ca);if(!_0x331056[_0x23fc('0x16')])throw new Error(_0x23fc('0x88')+_0x353d8c+'\x27');var _0x1fab60=[{'name':_0x353d8c}];if(!_[_0x23fc('0x89')](_0x331056[_0x23fc('0x1a')]))_0x1fab60=_0x331056[_0x23fc('0x1a')];var _0x37d3a4=[];for(var _0x3d9edd=0x0;_0x3d9edd<_0x1fab60[_0x23fc('0x8a')];_0x3d9edd++){_0x37d3a4[_0x23fc('0x8b')](_0x179e49[_0x23fc('0x8c')][_0x23fc('0x8d')]({'where':{'userProfileId':_0x47b355[_0x23fc('0x8e')]['id'],'name':_0x1fab60[_0x3d9edd]['name']},'raw':!![]}));}return Promise[_0x23fc('0x8f')](_0x37d3a4)[_0x23fc('0xc')](function(_0x56af64){var _0x5b8821=_[_0x23fc('0x5')](_0x56af64,function(_0x4709d4){return _0x4709d4?_0x4709d4:undefined;});var _0x496036=_['filter'](_0x1fab60,[_0x23fc('0x90'),!![]]);var _0x5e4131=_['isEmpty'](_0x5b8821)&&_['isEmpty'](_0x496036)?null:_[_0x23fc('0x91')](_0x496036,_0x5b8821);if(!_0x5e4131)return null;var _0x48cf12=[];for(var _0x501dce=0x0;_0x501dce<_0x5e4131[_0x23fc('0x8a')];_0x501dce++){var _0x5d9514=_[_0x23fc('0x8d')](_0x1fab60,function(_0x329cb1){return _0x5e4131[_0x501dce]?_0x329cb1[_0x23fc('0xd')]===_0x5e4131[_0x501dce][_0x23fc('0xd')]:null;});if(_0x5d9514){if(_0x5e4131[_0x501dce][_0x23fc('0x90')]){_0x48cf12[_0x23fc('0x8b')](_0x48471c(_0x331056[_0x23fc('0x16')],_0x5e4131[_0x501dce]));}else{if(!_0x5e4131[_0x501dce]['autoAssociation']){_0x48cf12[_0x23fc('0x8b')](_0x295025(_0x5d9514,_0x5e4131[_0x501dce],_0x331056[_0x23fc('0x16')]));}else{if(_0x5d9514[_0x23fc('0x92')]){_0x48cf12[_0x23fc('0x8b')](_0x453620(_0x5d9514,_0x5e4131[_0x501dce]));}}}}}return Promise[_0x23fc('0x8f')](_0x48cf12);})[_0x23fc('0xc')](function(_0x5c07a7){var _0x11b911=_0x5c07a7;var _0x46588a=null;if(_0x11b911){_0x46588a=_0x11b911[_0x23fc('0x8a')]===0x1?_0x11b911[0x0]:null;}if(!_0x46588a&&!_0x11b911)return _0x244049;var _0x25fff6=_0x179e49[_0x331056['childModel']][_0x23fc('0x93')];_0x594cb4['model']=_[_0x23fc('0x94')](_0x25fff6);_0x594cb4[_0x23fc('0x80')]=_[_0x23fc('0x94')](_0x47b355[_0x23fc('0x80')]);_0x594cb4[_0x23fc('0x95')]=_['intersection'](_0x594cb4[_0x23fc('0x92')],_0x594cb4[_0x23fc('0x80')]);_0x1145d0[_0x23fc('0x96')]=_['intersection'](_0x594cb4[_0x23fc('0x92')],qs['fields'](_0x47b355['query'][_0x23fc('0x97')]));_0x1145d0[_0x23fc('0x96')]=_0x1145d0[_0x23fc('0x96')][_0x23fc('0x8a')]?_0x1145d0[_0x23fc('0x96')]:_0x594cb4[_0x23fc('0x92')];if(!_0x47b355[_0x23fc('0x80')][_0x23fc('0x98')]('nolimit')){_0x1145d0[_0x23fc('0x99')]=qs['limit'](_0x47b355['query']['limit']);_0x1145d0[_0x23fc('0x9a')]=qs[_0x23fc('0x9a')](_0x47b355[_0x23fc('0x80')][_0x23fc('0x9a')]);}_0x1145d0[_0x23fc('0x9b')]=qs[_0x23fc('0x9c')](_0x47b355[_0x23fc('0x80')]['sort']);_0x1145d0[_0x23fc('0x7d')]=qs[_0x23fc('0x95')](_[_0x23fc('0x9d')](_0x47b355[_0x23fc('0x80')],_0x594cb4[_0x23fc('0x95')]));if(_0x47b355['query'][_0x23fc('0x5')]){_0x1145d0[_0x23fc('0x7d')]=_['merge'](_0x1145d0['where'],{'$or':_[_0x23fc('0x9')](_0x25fff6,function(_0x404fae){if(_0x404fae[_0x23fc('0x11')][_0x23fc('0x9e')]!==_0x23fc('0x9f')){var _0x5840a2={};_0x5840a2[_0x404fae[_0x23fc('0x6')]]={'$like':'%'+_0x47b355[_0x23fc('0x80')][_0x23fc('0x5')]+'%'};return _0x5840a2;}})});}var _0x32b82e=[];var _0x266ab3=null;var _0x5b6494={};if(_0x46588a){_0x266ab3=_[_0x23fc('0x8d')](_0x1fab60,[_0x23fc('0xd'),_0x46588a[_0x23fc('0xd')]]);if(_0x266ab3['field']){_0x5b6494={};if(_0x331056[_0x23fc('0x16')]===_0x23fc('0x10')){_0x5b6494[_0x266ab3['foreignKey']]=_['map'](_0x46588a[_0x23fc('0x8')],'id');}else{_0x5b6494[_0x266ab3['foreignKey']]=_0x46588a[_0x23fc('0x8')];}_0x32b82e['push'](_0x5b6494);}else{_0x1145d0[_0x23fc('0x7d')]['id']=_0x46588a[_0x23fc('0x8')];}}else{for(var _0x50f14d=0x0;_0x50f14d<_0x11b911[_0x23fc('0x8a')];_0x50f14d++){_0x266ab3=_['find'](_0x1fab60,['name',_0x11b911[_0x50f14d][_0x23fc('0xd')]]);if(_0x266ab3['field']){_0x5b6494={};_0x5b6494[_0x266ab3['foreignKey']]=_0x11b911[_0x50f14d]['associatedResources'];_0x32b82e[_0x23fc('0x8b')](_0x5b6494);}else{if(!_0x1145d0['where']['id'])_0x1145d0['where']['id']=[];_0x11b911[_0x50f14d][_0x23fc('0x8')][_0x23fc('0xa0')](function(_0x17a884){_0x1145d0[_0x23fc('0x7d')]['id'][_0x23fc('0x8b')](_0x17a884);});}}}if(!_[_0x23fc('0x89')](_0x32b82e)){_0x1145d0['where']=_[_0x23fc('0xa1')](_0x1145d0[_0x23fc('0x7d')],{'$and':{'$or':_0x32b82e}});}_0x1145d0=_[_0x23fc('0xa1')]({},_0x1145d0,_0x47b355[_0x23fc('0xa2')]);if(_0x46588a&&!_0x46588a[_0x23fc('0xa3')]&&_0x331056[_0x23fc('0x16')]===_0x23fc('0x10')){if(_0x47b355[_0x23fc('0x80')][_0x23fc('0xa4')]){_0x1145d0['include']=[{'all':!![]}];}return _0x179e49[_0x331056['childModel']][_0x23fc('0x7')](_0x1145d0)[_0x23fc('0xc')](function(_0x381e6a){var _0x4f2a2c=[];_0x381e6a[_0x23fc('0xa0')](function(_0x20e80c){var _0x3760be;switch(_0x20e80c[_0x23fc('0xa5')]){case _0x23fc('0xa6'):_0x3760be=_[_0x23fc('0x8d')](_0x46588a[_0x23fc('0x8')],function(_0x4bd540){return _0x4bd540['id']===_0x20e80c[_0x23fc('0x74')]&&_0x4bd540[_0x23fc('0x11')]===_0x23fc('0xa7');});break;case'custom':_0x3760be=_[_0x23fc('0x8d')](_0x46588a[_0x23fc('0x8')],function(_0xbfb68e){return _0xbfb68e['id']===_0x20e80c[_0x23fc('0x74')]&&_0xbfb68e[_0x23fc('0x11')]===_0x23fc('0xa8');});break;}if(_0x3760be)_0x4f2a2c['push'](_0x20e80c);});_0x244049[_0x23fc('0xa9')]=_0x4f2a2c[_0x23fc('0x8a')];_0x244049['rows']=_0x4f2a2c;return _0x244049;});}else{if(!_[_0x23fc('0x89')](_0x47b355[_0x23fc('0x80')]['ids'])){_0x1145d0[_0x23fc('0x7d')]['id']=_0x1145d0[_0x23fc('0x7d')]['id']?_[_0x23fc('0xaa')](_0x1145d0[_0x23fc('0x7d')]['id'],_0x47b355['query'][_0x23fc('0xab')]):_0x47b355[_0x23fc('0x80')][_0x23fc('0xab')];if(_0x47b355['query']['customSorting']){_0x1145d0[_0x23fc('0x9b')]=_0x47b355[_0x23fc('0x80')][_0x23fc('0xac')];}}if(_0x47b355[_0x23fc('0x80')]['extraQueryConditions']){_0x1145d0[_0x23fc('0x7d')]=_['merge'](_0x1145d0['where'],{'$and':_0x47b355[_0x23fc('0x80')]['extraQueryConditions']});}return _0x179e49[_0x331056[_0x23fc('0x16')]][_0x23fc('0xa9')]({'where':_0x1145d0[_0x23fc('0x7d')]})[_0x23fc('0xc')](function(_0x42bab5){_0x244049[_0x23fc('0xa9')]=_0x42bab5;if(_0x47b355['query']['includeAll']){if(_0x331056[_0x23fc('0x16')]===_0x23fc('0x1f')){_0x1145d0['include']=[{'model':_0x179e49[_0x23fc('0xad')],'as':_0x23fc('0xae'),'attributes':['id',_0x23fc('0xd'),_0x23fc('0xaf')],'required':_0x47b355['query'][_0x23fc('0xb0')]?!![]:![]},{'model':_0x179e49[_0x23fc('0xad')],'as':'ThroughTags','attributes':['id',_0x23fc('0xd'),'color'],'through':_0x47b355[_0x23fc('0x80')]['tag']?{'attributes':[],'where':{'TagId':_0x47b355[_0x23fc('0x80')][_0x23fc('0xb0')]||undefined}}:{},'required':_0x47b355[_0x23fc('0x80')][_0x23fc('0xb0')]?!![]:![]}];}else{_0x1145d0[_0x23fc('0xb1')]=[{'all':!![]}];}}return _0x179e49[_0x331056[_0x23fc('0x16')]][_0x23fc('0x7')](_0x1145d0);})[_0x23fc('0xc')](function(_0x2357ea){_0x244049[_0x23fc('0xb2')]=_0x2357ea;if(_0x353d8c===_0x23fc('0x35')&&_0x47b355[_0x23fc('0x80')][_0x23fc('0xb3')]===_0x23fc('0xb4')){var _0x382fd5=[];for(var _0x3126e2=0x0;_0x3126e2<_0x244049[_0x23fc('0xb2')][_0x23fc('0x8a')];_0x3126e2++){_0x382fd5[_0x23fc('0x8b')](_0x451723('chat',_0x244049[_0x23fc('0xb2')][_0x3126e2][_0x23fc('0xb5')]));_0x382fd5[_0x23fc('0x8b')](_0x451723(_0x23fc('0xb6'),_0x244049[_0x23fc('0xb2')][_0x3126e2][_0x23fc('0xb5')]));_0x382fd5[_0x23fc('0x8b')](_0x451723(_0x23fc('0xb7'),_0x244049[_0x23fc('0xb2')][_0x3126e2]['dataValues']));_0x382fd5[_0x23fc('0x8b')](_0x451723(_0x23fc('0xb8'),_0x244049[_0x23fc('0xb2')][_0x3126e2][_0x23fc('0xb5')]));_0x382fd5[_0x23fc('0x8b')](_0x451723(_0x23fc('0xb9'),_0x244049[_0x23fc('0xb2')][_0x3126e2][_0x23fc('0xb5')]));_0x382fd5['push'](_0x451723(_0x23fc('0xba'),_0x244049['rows'][_0x3126e2][_0x23fc('0xb5')]));}return Promise[_0x23fc('0x8f')](_0x382fd5)['then'](function(){return _0x244049;});}return _0x244049;});}});}}});};
\ No newline at end of file
+var _0xf868=['AnalyticMetric','charAt','toUpperCase','slice','QueryTypes','SELECT','select','ui.','InteractionId','ui.createdAt','from','user_has_','_interactions','ui.UserId\x20=\x20?','sequelize','query','OpenTabs','UserProfile','user_profiles','../../components/parsers/qs','raw','mergeResources','Invalid\x20section\x20\x27','isEmpty','push','UserProfileSection','all','ignore','union','length','find','autoAssociation','model','rawAttributes','keys','filters','attributes','intersection','fields','hasOwnProperty','nolimit','limit','offset','sort','where','pick','key','VIRTUAL','foreignKey','forEach','merge','options','include','reportType','default','DefaultReports','custom','CustomReports','count','rows','ids','order','extraQueryConditions','includeAll','Tags','color','tag','true','dataValues','sms','fax','mail','openchannel','./userProfile.attributes','squel','exports','models','filter','field','value','findAll','then','map','catch','associatedResources','UserProfileResource','AnalyticExtractedReport','resourceId','type','squareprojects','childModel','SquareProject','odbc','squarerecordings','SquareRecording','parentSections','SquareProjects','name','projectName','JscriptyProject','CmContact','Lists','ListId','lists','CmList','companies','CmCompany','CmCustomField','chatqueues','ChatQueue','faxqueues','FaxAccount','inboundroutes','internalroutes','outboundroutes','VoiceExtension','voicemails','VoiceMail','voicerecordings','VoiceRecording','Agents','membername','User','role','agent','telephone','VoiceQueue','QueueCampaigns','outbound','musiconholds','VoiceMusicOnHold','chanspies','VoiceChanSpy','voiceprefixes','VoicePrefix','Campaign','MailQueue','mailaccounts','mailsubstatuses','openchannelqueues','OpenchannelQueue','OpenchannelAccount','smsqueues','SmsQueue','SmsAccount','whatsappqueues','WhatsappQueue','whatsappaccounts','WhatsappAccount','teams','Team','voicequeues','queuecampaigns','VoiceQueues','users','agents','telephones','Users','user','Telephones','zendeskaccounts','SalesforceAccount','freshdeskaccounts','FreshdeskAccount','sugarcrmaccounts','SugarcrmAccount','deskaccounts','DeskAccount','zohoaccounts','CannedAnswer','dispositions','Disposition','customdashboards','intervals','pauses','Pause','scheduler','Schedule','tags','Tag','templates','Template','triggers','Trigger','Trunk','variables','plugins','Plugin','extractedreports','Reports','reportId','metrics'];(function(_0x1e829b,_0x5490cc){var _0x213be3=function(_0x1b7f4a){while(--_0x1b7f4a){_0x1e829b['push'](_0x1e829b['shift']());}};_0x213be3(++_0x5490cc);}(_0xf868,0x109));var _0x8f86=function(_0x4855ac,_0x57608e){_0x4855ac=_0x4855ac-0x0;var _0x4f4cd4=_0xf868[_0x4855ac];return _0x4f4cd4;};'use strict';var _=require('lodash');var attributes=require(_0x8f86('0x0'));var squel=require(_0x8f86('0x1'));module[_0x8f86('0x2')]=function(_0x528890){var _0x3fbffa=_0x528890[_0x8f86('0x3')];function _0x38461b(_0x79cd,_0xfe7173){return new Promise(function(_0x8847df,_0x38d588){if(!_0xfe7173)return _0x8847df(null);var _0x1194e1=_0xfe7173[_0x8f86('0x4')]?{[_0xfe7173['filter'][_0x8f86('0x5')]]:_0xfe7173[_0x8f86('0x4')][_0x8f86('0x6')]}:undefined;return _0x3fbffa[_0x79cd][_0x8f86('0x7')]({'where':_0x1194e1,'raw':!![]})[_0x8f86('0x8')](function(_0x506217){_0xfe7173['associatedResources']=_[_0x8f86('0x9')](_0x506217,'id');_0x8847df(_0xfe7173);})[_0x8f86('0xa')](function(_0x4b49c1){_0x38d588(_0x4b49c1);});});}function _0x4ef7ed(_0x26280b,_0x2bf180){return new Promise(function(_0x272a0a,_0x34363e){var _0x4f2263=_0x26280b[_0x8f86('0x4')]?{[_0x26280b[_0x8f86('0x4')][_0x8f86('0x5')]]:_0x26280b[_0x8f86('0x4')][_0x8f86('0x6')]}:undefined;return _0x3fbffa[_0x26280b['model']][_0x8f86('0x7')]({'where':_0x4f2263,'raw':!![]})['then'](function(_0x2c15f1){_0x2bf180[_0x8f86('0xb')]=_[_0x8f86('0x9')](_0x2c15f1,function(_0x52ede2){return _0x52ede2['name'];});_0x272a0a(_0x2bf180);})[_0x8f86('0xa')](function(_0x1cb6f9){_0x34363e(_0x1cb6f9);});});}function _0x41b650(_0xac0d41,_0x3a16b4,_0x56cd58){if(!_0x3a16b4)return Promise['resolve'](null);return new Promise(function(_0x5d87f3,_0x123f61){return _0x3fbffa[_0x8f86('0xc')]['findAll']({'where':{'sectionId':_0x3a16b4['id']},'raw':!![]})['then'](function(_0x4f5e4f){if(_0xac0d41['field']&&_0xac0d41[_0x8f86('0x5')]!=='id'){_0x3a16b4[_0x8f86('0xb')]=_[_0x8f86('0x9')](_0x4f5e4f,function(_0x1f5965){return _0x1f5965[_0xac0d41[_0x8f86('0x5')]];});}else{if(_0x56cd58===_0x8f86('0xd')){_0x3a16b4[_0x8f86('0xb')]=_[_0x8f86('0x9')](_0x4f5e4f,function(_0xa12f4c){return{'id':_0xa12f4c[_0x8f86('0xe')],'type':_0xa12f4c[_0x8f86('0xf')]};});}else{_0x3a16b4[_0x8f86('0xb')]=_[_0x8f86('0x9')](_0x4f5e4f,function(_0x10339a){return _0x10339a['resourceId'];});}}_0x5d87f3(_0x3a16b4);})['catch'](function(_0x537e20){_0x123f61(_0x537e20);});});}function _0x4a948d(_0x856114,_0x3e6eae){var _0x3a922e={'parentSections':[]};switch(_0x856114['toLowerCase']()){case _0x8f86('0x10'):_0x3a922e[_0x8f86('0x11')]=_0x8f86('0x12');break;case _0x8f86('0x13'):_0x3a922e[_0x8f86('0x11')]='SquareOdbc';break;case _0x8f86('0x14'):_0x3a922e['childModel']=_0x8f86('0x15');_0x3a922e[_0x8f86('0x16')]=[{'name':_0x8f86('0x17'),'field':_0x8f86('0x18'),'foreignKey':_0x8f86('0x19')}];break;case'projects':_0x3a922e[_0x8f86('0x11')]=_0x8f86('0x1a');break;case'contacts':_0x3a922e['childModel']=_0x8f86('0x1b');_0x3a922e[_0x8f86('0x16')]=[{'name':_0x8f86('0x1c'),'field':'id','foreignKey':_0x8f86('0x1d')}];break;case _0x8f86('0x1e'):_0x3a922e['childModel']=_0x8f86('0x1f');break;case _0x8f86('0x20'):_0x3a922e[_0x8f86('0x11')]=_0x8f86('0x21');break;case'globalcustomfields':_0x3a922e[_0x8f86('0x11')]=_0x8f86('0x22');break;case _0x8f86('0x23'):_0x3a922e[_0x8f86('0x11')]=_0x8f86('0x24');break;case'chatwebsites':_0x3a922e['childModel']='ChatWebsite';break;case _0x8f86('0x25'):_0x3a922e[_0x8f86('0x11')]='FaxQueue';break;case'faxaccounts':_0x3a922e['childModel']=_0x8f86('0x26');break;case _0x8f86('0x27'):case _0x8f86('0x28'):case _0x8f86('0x29'):_0x3a922e['childModel']=_0x8f86('0x2a');break;case'contexts':_0x3a922e['childModel']='VoiceContext';break;case _0x8f86('0x2b'):_0x3a922e[_0x8f86('0x11')]=_0x8f86('0x2c');break;case _0x8f86('0x2d'):_0x3a922e['childModel']=_0x8f86('0x2e');_0x3a922e[_0x8f86('0x16')]=[{'name':_0x8f86('0x2f'),'field':_0x8f86('0x18'),'foreignKey':_0x8f86('0x30'),'model':_0x8f86('0x31'),'filter':{'field':_0x8f86('0x32'),'value':[_0x8f86('0x33')]}},{'name':'Telephones','field':_0x8f86('0x18'),'foreignKey':'membername','model':_0x8f86('0x31'),'filter':{'field':'role','value':[_0x8f86('0x34')]}},{'name':'VoiceQueues','field':_0x8f86('0x18'),'foreignKey':'queue','model':_0x8f86('0x35'),'filter':{'field':_0x8f86('0xf'),'value':['inbound']}},{'name':_0x8f86('0x36'),'field':_0x8f86('0x18'),'foreignKey':'queue','model':'VoiceQueue','filter':{'field':_0x8f86('0xf'),'value':[_0x8f86('0x37')]}}];break;case _0x8f86('0x38'):_0x3a922e['childModel']=_0x8f86('0x39');break;case _0x8f86('0x3a'):_0x3a922e[_0x8f86('0x11')]=_0x8f86('0x3b');break;case _0x8f86('0x3c'):_0x3a922e['childModel']=_0x8f86('0x3d');break;case'ivrcampaigns':_0x3a922e[_0x8f86('0x11')]=_0x8f86('0x3e');break;case'mailqueues':_0x3a922e['childModel']=_0x8f86('0x3f');break;case _0x8f86('0x40'):_0x3a922e['childModel']='MailAccount';break;case _0x8f86('0x41'):_0x3a922e[_0x8f86('0x11')]='MailSubstatus';break;case _0x8f86('0x42'):_0x3a922e[_0x8f86('0x11')]=_0x8f86('0x43');break;case'openchannelaccounts':_0x3a922e[_0x8f86('0x11')]=_0x8f86('0x44');break;case _0x8f86('0x45'):_0x3a922e['childModel']=_0x8f86('0x46');break;case'smsaccounts':_0x3a922e['childModel']=_0x8f86('0x47');break;case _0x8f86('0x48'):_0x3a922e['childModel']=_0x8f86('0x49');break;case _0x8f86('0x4a'):_0x3a922e[_0x8f86('0x11')]=_0x8f86('0x4b');break;case _0x8f86('0x4c'):_0x3a922e[_0x8f86('0x11')]=_0x8f86('0x4d');break;case _0x8f86('0x4e'):case _0x8f86('0x4f'):_0x3a922e[_0x8f86('0x11')]=_0x8f86('0x35');if(_0x3e6eae){_0x3a922e[_0x8f86('0x16')]=[{'name':_0x8f86('0x50')},{'name':_0x8f86('0x36')}];}break;case _0x8f86('0x51'):case _0x8f86('0x52'):case _0x8f86('0x53'):_0x3a922e['childModel']='User';if(_0x3e6eae){_0x3a922e[_0x8f86('0x16')]=[{'name':_0x8f86('0x54'),'filter':{'field':_0x8f86('0x32'),'value':['admin',_0x8f86('0x55')]},'ignore':!![]},{'name':_0x8f86('0x2f')},{'name':_0x8f86('0x56')}];}break;case _0x8f86('0x57'):_0x3a922e[_0x8f86('0x11')]='ZendeskAccount';break;case'salesforceaccounts':_0x3a922e[_0x8f86('0x11')]=_0x8f86('0x58');break;case _0x8f86('0x59'):_0x3a922e[_0x8f86('0x11')]=_0x8f86('0x5a');break;case _0x8f86('0x5b'):_0x3a922e[_0x8f86('0x11')]=_0x8f86('0x5c');break;case _0x8f86('0x5d'):_0x3a922e['childModel']=_0x8f86('0x5e');break;case _0x8f86('0x5f'):_0x3a922e['childModel']='ZohoAccount';break;case'vtigeraccounts':_0x3a922e[_0x8f86('0x11')]=_0x8f86('0x31');break;case'cannedanswers':_0x3a922e[_0x8f86('0x11')]=_0x8f86('0x60');break;case _0x8f86('0x61'):_0x3a922e['childModel']=_0x8f86('0x62');break;case _0x8f86('0x63'):_0x3a922e[_0x8f86('0x11')]='Dashboard';break;case _0x8f86('0x64'):_0x3a922e[_0x8f86('0x11')]='Interval';break;case _0x8f86('0x65'):_0x3a922e[_0x8f86('0x11')]=_0x8f86('0x66');break;case _0x8f86('0x67'):_0x3a922e[_0x8f86('0x11')]=_0x8f86('0x68');break;case'sounds':_0x3a922e[_0x8f86('0x11')]='Sound';break;case _0x8f86('0x69'):_0x3a922e[_0x8f86('0x11')]=_0x8f86('0x6a');break;case _0x8f86('0x6b'):_0x3a922e['childModel']=_0x8f86('0x6c');break;case _0x8f86('0x6d'):_0x3a922e['childModel']=_0x8f86('0x6e');break;case'trunks':_0x3a922e[_0x8f86('0x11')]=_0x8f86('0x6f');break;case _0x8f86('0x70'):_0x3a922e['childModel']='Variable';break;case _0x8f86('0x71'):_0x3a922e['childModel']=_0x8f86('0x72');break;case _0x8f86('0x73'):_0x3a922e[_0x8f86('0x11')]=_0x8f86('0xd');_0x3a922e[_0x8f86('0x16')]=[{'name':_0x8f86('0x74'),'field':'id','foreignKey':_0x8f86('0x75')}];break;case _0x8f86('0x76'):_0x3a922e[_0x8f86('0x11')]=_0x8f86('0x77');break;}return _0x3a922e;}function _0x131eb5(_0x1c7259,_0x4ff171){var _0x7692d5=_0x1c7259[_0x8f86('0x78')](0x0)[_0x8f86('0x79')]()+_0x1c7259[_0x8f86('0x7a')](0x1);var _0x3bc42a={'type':_0x3fbffa['Sequelize'][_0x8f86('0x7b')][_0x8f86('0x7c')],'raw':!![]};return new Promise(function(_0x34fbc8,_0x3c5ff5){var _0x59647f=squel[_0x8f86('0x7d')]()[_0x8f86('0x5')](_0x8f86('0x7e')+_0x7692d5+_0x8f86('0x7f'),'id')[_0x8f86('0x5')](_0x8f86('0x80'))[_0x8f86('0x81')](_0x8f86('0x82')+_0x1c7259+_0x8f86('0x83'),'ui')['where'](_0x8f86('0x84'),_0x4ff171['id']);return _0x3fbffa[_0x8f86('0x85')][_0x8f86('0x86')](_0x59647f['toString'](),_0x3bc42a)[_0x8f86('0x8')](function(_0x19fdb7){_0x4ff171[_0x7692d5+_0x8f86('0x87')]=_0x19fdb7;_0x34fbc8(_0x19fdb7);})['catch'](function(_0x475142){_0x3c5ff5(_0x475142);});});}return _0x528890['define'](_0x8f86('0x88'),attributes,{'tableName':_0x8f86('0x89'),'paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x5671aa){var _0x31e621=require(_0x8f86('0x8a'));var _0x13e189={'raw':_0x5671aa[_0x8f86('0x86')][_0x8f86('0x8b')],'where':{}};var _0x211ddb={};var _0x3b3048={'count':0x0,'rows':[]};var _0x4826cb=_0x5671aa['query']['section'];var _0x2a211b=_0x5671aa[_0x8f86('0x86')][_0x8f86('0x8c')]||![];var _0x2aafdd=_0x4a948d(_0x4826cb,_0x2a211b);if(!_0x2aafdd[_0x8f86('0x11')])throw new Error(_0x8f86('0x8d')+_0x4826cb+'\x27');var _0x415066=[{'name':_0x4826cb}];if(!_[_0x8f86('0x8e')](_0x2aafdd[_0x8f86('0x16')]))_0x415066=_0x2aafdd[_0x8f86('0x16')];var _0x211507=[];for(var _0x24e684=0x0;_0x24e684<_0x415066['length'];_0x24e684++){_0x211507[_0x8f86('0x8f')](_0x3fbffa[_0x8f86('0x90')]['find']({'where':{'userProfileId':_0x5671aa['params']['id'],'name':_0x415066[_0x24e684][_0x8f86('0x18')]},'raw':!![]}));}return Promise[_0x8f86('0x91')](_0x211507)[_0x8f86('0x8')](function(_0x4ab660){var _0x3d59e0=_[_0x8f86('0x4')](_0x4ab660,function(_0x106405){return _0x106405?_0x106405:undefined;});var _0xe7e179=_[_0x8f86('0x4')](_0x415066,[_0x8f86('0x92'),!![]]);var _0x50554e=_['isEmpty'](_0x3d59e0)&&_[_0x8f86('0x8e')](_0xe7e179)?null:_[_0x8f86('0x93')](_0xe7e179,_0x3d59e0);if(!_0x50554e)return null;var _0x58b9b7=[];for(var _0x42a259=0x0;_0x42a259<_0x50554e[_0x8f86('0x94')];_0x42a259++){var _0x194f4e=_[_0x8f86('0x95')](_0x415066,function(_0xe3cdff){return _0x50554e[_0x42a259]?_0xe3cdff[_0x8f86('0x18')]===_0x50554e[_0x42a259]['name']:null;});if(_0x194f4e){if(_0x50554e[_0x42a259]['ignore']){_0x58b9b7[_0x8f86('0x8f')](_0x38461b(_0x2aafdd[_0x8f86('0x11')],_0x50554e[_0x42a259]));}else{if(!_0x50554e[_0x42a259][_0x8f86('0x96')]){_0x58b9b7['push'](_0x41b650(_0x194f4e,_0x50554e[_0x42a259],_0x2aafdd[_0x8f86('0x11')]));}else{if(_0x194f4e[_0x8f86('0x97')]){_0x58b9b7[_0x8f86('0x8f')](_0x4ef7ed(_0x194f4e,_0x50554e[_0x42a259]));}}}}}return Promise[_0x8f86('0x91')](_0x58b9b7);})[_0x8f86('0x8')](function(_0x1fe3a3){var _0x1ef935=_0x1fe3a3;var _0x413153=null;if(_0x1ef935){_0x413153=_0x1ef935['length']===0x1?_0x1ef935[0x0]:null;}if(!_0x413153&&!_0x1ef935)return _0x3b3048;var _0x4ed94f=_0x3fbffa[_0x2aafdd[_0x8f86('0x11')]][_0x8f86('0x98')];_0x211ddb[_0x8f86('0x97')]=_[_0x8f86('0x99')](_0x4ed94f);_0x211ddb[_0x8f86('0x86')]=_[_0x8f86('0x99')](_0x5671aa['query']);_0x211ddb[_0x8f86('0x9a')]=_['intersection'](_0x211ddb['model'],_0x211ddb[_0x8f86('0x86')]);_0x13e189[_0x8f86('0x9b')]=_[_0x8f86('0x9c')](_0x211ddb['model'],_0x31e621[_0x8f86('0x9d')](_0x5671aa[_0x8f86('0x86')][_0x8f86('0x9d')]));_0x13e189['attributes']=_0x13e189[_0x8f86('0x9b')][_0x8f86('0x94')]?_0x13e189[_0x8f86('0x9b')]:_0x211ddb[_0x8f86('0x97')];if(!_0x5671aa[_0x8f86('0x86')][_0x8f86('0x9e')](_0x8f86('0x9f'))){_0x13e189[_0x8f86('0xa0')]=_0x31e621[_0x8f86('0xa0')](_0x5671aa[_0x8f86('0x86')][_0x8f86('0xa0')]);_0x13e189[_0x8f86('0xa1')]=_0x31e621['offset'](_0x5671aa['query'][_0x8f86('0xa1')]);}_0x13e189['order']=_0x31e621[_0x8f86('0xa2')](_0x5671aa['query'][_0x8f86('0xa2')]);_0x13e189[_0x8f86('0xa3')]=_0x31e621[_0x8f86('0x9a')](_[_0x8f86('0xa4')](_0x5671aa[_0x8f86('0x86')],_0x211ddb[_0x8f86('0x9a')]));if(_0x5671aa[_0x8f86('0x86')][_0x8f86('0x4')]){_0x13e189['where']=_['merge'](_0x13e189[_0x8f86('0xa3')],{'$or':_['map'](_0x4ed94f,function(_0x106665){if(_0x106665[_0x8f86('0xf')][_0x8f86('0xa5')]!==_0x8f86('0xa6')){var _0x4a61bd={};_0x4a61bd[_0x106665[_0x8f86('0x5')]]={'$like':'%'+_0x5671aa[_0x8f86('0x86')][_0x8f86('0x4')]+'%'};return _0x4a61bd;}})});}var _0x49d0e1=[];var _0x472f7a=null;var _0x4f2f56={};if(_0x413153){_0x472f7a=_[_0x8f86('0x95')](_0x415066,[_0x8f86('0x18'),_0x413153[_0x8f86('0x18')]]);if(_0x472f7a[_0x8f86('0x5')]){_0x4f2f56={};if(_0x2aafdd[_0x8f86('0x11')]==='AnalyticExtractedReport'){_0x4f2f56[_0x472f7a[_0x8f86('0xa7')]]=_[_0x8f86('0x9')](_0x413153[_0x8f86('0xb')],'id');}else{_0x4f2f56[_0x472f7a[_0x8f86('0xa7')]]=_0x413153[_0x8f86('0xb')];}_0x49d0e1[_0x8f86('0x8f')](_0x4f2f56);}else{_0x13e189[_0x8f86('0xa3')]['id']=_0x413153[_0x8f86('0xb')];}}else{for(var _0x5d54f0=0x0;_0x5d54f0<_0x1ef935[_0x8f86('0x94')];_0x5d54f0++){_0x472f7a=_[_0x8f86('0x95')](_0x415066,['name',_0x1ef935[_0x5d54f0][_0x8f86('0x18')]]);if(_0x472f7a[_0x8f86('0x5')]){_0x4f2f56={};_0x4f2f56[_0x472f7a[_0x8f86('0xa7')]]=_0x1ef935[_0x5d54f0][_0x8f86('0xb')];_0x49d0e1[_0x8f86('0x8f')](_0x4f2f56);}else{if(!_0x13e189[_0x8f86('0xa3')]['id'])_0x13e189[_0x8f86('0xa3')]['id']=[];_0x1ef935[_0x5d54f0]['associatedResources'][_0x8f86('0xa8')](function(_0x278f6c){_0x13e189['where']['id'][_0x8f86('0x8f')](_0x278f6c);});}}}if(!_['isEmpty'](_0x49d0e1)){_0x13e189[_0x8f86('0xa3')]=_[_0x8f86('0xa9')](_0x13e189[_0x8f86('0xa3')],{'$and':{'$or':_0x49d0e1}});}_0x13e189=_['merge']({},_0x13e189,_0x5671aa[_0x8f86('0xaa')]);if(_0x413153&&!_0x413153[_0x8f86('0x96')]&&_0x2aafdd['childModel']===_0x8f86('0xd')){if(_0x5671aa[_0x8f86('0x86')]['includeAll']){_0x13e189[_0x8f86('0xab')]=[{'all':!![]}];}return _0x3fbffa[_0x2aafdd[_0x8f86('0x11')]][_0x8f86('0x7')](_0x13e189)[_0x8f86('0x8')](function(_0x564e9d){var _0x4f58e7=[];_0x564e9d[_0x8f86('0xa8')](function(_0x1fe52c){var _0x1d6f48;switch(_0x1fe52c[_0x8f86('0xac')]){case _0x8f86('0xad'):_0x1d6f48=_[_0x8f86('0x95')](_0x413153[_0x8f86('0xb')],function(_0x4e378d){return _0x4e378d['id']===_0x1fe52c['reportId']&&_0x4e378d[_0x8f86('0xf')]===_0x8f86('0xae');});break;case _0x8f86('0xaf'):_0x1d6f48=_['find'](_0x413153['associatedResources'],function(_0x380969){return _0x380969['id']===_0x1fe52c[_0x8f86('0x75')]&&_0x380969['type']===_0x8f86('0xb0');});break;}if(_0x1d6f48)_0x4f58e7['push'](_0x1fe52c);});_0x3b3048[_0x8f86('0xb1')]=_0x4f58e7[_0x8f86('0x94')];_0x3b3048[_0x8f86('0xb2')]=_0x4f58e7;return _0x3b3048;});}else{if(!_['isEmpty'](_0x5671aa['query']['ids'])){_0x13e189[_0x8f86('0xa3')]['id']=_0x13e189[_0x8f86('0xa3')]['id']?_[_0x8f86('0x9c')](_0x13e189[_0x8f86('0xa3')]['id'],_0x5671aa['query'][_0x8f86('0xb3')]):_0x5671aa[_0x8f86('0x86')][_0x8f86('0xb3')];if(_0x5671aa[_0x8f86('0x86')]['customSorting']){_0x13e189[_0x8f86('0xb4')]=_0x5671aa[_0x8f86('0x86')]['customSorting'];}}if(_0x5671aa['query']['extraQueryConditions']){_0x13e189[_0x8f86('0xa3')]=_['merge'](_0x13e189[_0x8f86('0xa3')],{'$and':_0x5671aa[_0x8f86('0x86')][_0x8f86('0xb5')]});}return _0x3fbffa[_0x2aafdd[_0x8f86('0x11')]]['count']({'where':_0x13e189['where']})[_0x8f86('0x8')](function(_0x44dadd){_0x3b3048['count']=_0x44dadd;if(_0x5671aa[_0x8f86('0x86')][_0x8f86('0xb6')]){if(_0x2aafdd[_0x8f86('0x11')]===_0x8f86('0x1b')){_0x13e189[_0x8f86('0xab')]=[{'model':_0x3fbffa['Tag'],'as':_0x8f86('0xb7'),'attributes':['id',_0x8f86('0x18'),'color'],'required':_0x5671aa['query']['tag']?!![]:![]},{'model':_0x3fbffa[_0x8f86('0x6a')],'as':'ThroughTags','attributes':['id',_0x8f86('0x18'),_0x8f86('0xb8')],'through':_0x5671aa[_0x8f86('0x86')][_0x8f86('0xb9')]?{'attributes':[],'where':{'TagId':_0x5671aa[_0x8f86('0x86')][_0x8f86('0xb9')]||undefined}}:{},'required':_0x5671aa[_0x8f86('0x86')]['tag']?!![]:![]}];}else{_0x13e189[_0x8f86('0xab')]=[{'all':!![]}];}}return _0x3fbffa[_0x2aafdd[_0x8f86('0x11')]]['findAll'](_0x13e189);})[_0x8f86('0x8')](function(_0x6baaab){_0x3b3048[_0x8f86('0xb2')]=_0x6baaab;if(_0x4826cb===_0x8f86('0x2f')&&_0x5671aa[_0x8f86('0x86')]['openTabs']===_0x8f86('0xba')){var _0x5ca5b2=[];for(var _0x14fb87=0x0;_0x14fb87<_0x3b3048[_0x8f86('0xb2')][_0x8f86('0x94')];_0x14fb87++){_0x5ca5b2[_0x8f86('0x8f')](_0x131eb5('chat',_0x3b3048[_0x8f86('0xb2')][_0x14fb87][_0x8f86('0xbb')]));_0x5ca5b2[_0x8f86('0x8f')](_0x131eb5(_0x8f86('0xbc'),_0x3b3048['rows'][_0x14fb87]['dataValues']));_0x5ca5b2[_0x8f86('0x8f')](_0x131eb5(_0x8f86('0xbd'),_0x3b3048[_0x8f86('0xb2')][_0x14fb87]['dataValues']));_0x5ca5b2[_0x8f86('0x8f')](_0x131eb5(_0x8f86('0xbe'),_0x3b3048[_0x8f86('0xb2')][_0x14fb87][_0x8f86('0xbb')]));_0x5ca5b2['push'](_0x131eb5(_0x8f86('0xbf'),_0x3b3048[_0x8f86('0xb2')][_0x14fb87]['dataValues']));_0x5ca5b2['push'](_0x131eb5('whatsapp',_0x3b3048['rows'][_0x14fb87][_0x8f86('0xbb')]));}return Promise[_0x8f86('0x91')](_0x5ca5b2)[_0x8f86('0x8')](function(){return _0x3b3048;});}return _0x3b3048;});}});}}});};
\ No newline at end of file