Built motion from commit 639a1a7f.|2.6.19
[motion2.git] / server / api / userProfile / userProfile.model.js
index 2036040..8aba751 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x8649=['MailQueue','mailaccounts','MailAccount','mailsubstatuses','MailSubstatus','openchannelqueues','OpenchannelQueue','openchannelaccounts','smsqueues','SmsQueue','smsaccounts','SmsAccount','WhatsappQueue','whatsappaccounts','WhatsappAccount','Team','voicequeues','queuecampaigns','VoiceQueues','telephones','admin','user','zendeskaccounts','ZendeskAccount','salesforceaccounts','freshdeskaccounts','FreshdeskAccount','sugarcrmaccounts','SugarcrmAccount','deskaccounts','zohoaccounts','ZohoAccount','cannedanswers','CannedAnswer','dispositions','Disposition','customdashboards','Dashboard','pauses','Pause','scheduler','Schedule','sounds','Sound','tags','Tag','templates','Template','triggers','Trigger','Trunk','variables','Variable','plugins','extractedreports','Reports','reportId','AnalyticMetric','charAt','slice','QueryTypes','SELECT','select','ui.','InteractionId','ui.createdAt','from','user_has_','_interactions','where','ui.UserId\x20=\x20?','query','toString','OpenTabs','define','UserProfile','user_profiles','raw','section','mergeResources','isEmpty','length','UserProfileSection','params','all','ignore','find','autoAssociation','push','model','rawAttributes','keys','filters','intersection','fields','attributes','nolimit','limit','offset','order','sort','pick','merge','key','VIRTUAL','foreignKey','forEach','options','includeAll','include','reportType','DefaultReports','custom','CustomReports','count','rows','ids','customSorting','extraQueryConditions','Tags','color','tag','ThroughTags','openTabs','true','dataValues','sms','openchannel','lodash','./userProfile.attributes','../../components/parsers/qs','models','filter','field','value','findAll','then','associatedResources','map','name','resolve','UserProfileResource','AnalyticExtractedReport','type','resourceId','catch','toLowerCase','childModel','odbc','SquareOdbc','squarerecordings','SquareRecording','SquareProjects','projects','JscriptyProject','contacts','CmContact','Lists','ListId','CmList','companies','CmCompany','globalcustomfields','CmCustomField','chatqueues','ChatQueue','chatwebsites','FaxQueue','faxaccounts','inboundroutes','internalroutes','outboundroutes','VoiceExtension','contexts','VoiceContext','voicemails','voicerecordings','VoiceRecording','parentSections','Agents','membername','User','role','agent','Telephones','telephone','queue','VoiceQueue','inbound','outbound','VoiceMusicOnHold','chanspies','VoicePrefix','Campaign','mailqueues'];(function(_0x2e2e6f,_0x20666f){var _0x125719=function(_0x1eea9e){while(--_0x1eea9e){_0x2e2e6f['push'](_0x2e2e6f['shift']());}};_0x125719(++_0x20666f);}(_0x8649,0x80));var _0x9864=function(_0x17c636,_0x14bfc3){_0x17c636=_0x17c636-0x0;var _0x41e0e7=_0x8649[_0x17c636];return _0x41e0e7;};'use strict';var _=require(_0x9864('0x0'));var attributes=require(_0x9864('0x1'));var qs=require(_0x9864('0x2'));var squel=require('squel');module['exports']=function(_0x5d919a){var _0xff120f=_0x5d919a[_0x9864('0x3')];function _0x3a2ec5(_0x1deb45,_0x53e97f){return new Promise(function(_0x4846fd,_0x5daa99){if(!_0x53e97f)return _0x4846fd(null);var _0x2180c3=_0x53e97f[_0x9864('0x4')]?{[_0x53e97f[_0x9864('0x4')][_0x9864('0x5')]]:_0x53e97f[_0x9864('0x4')][_0x9864('0x6')]}:undefined;return _0xff120f[_0x1deb45][_0x9864('0x7')]({'where':_0x2180c3,'raw':!![]})[_0x9864('0x8')](function(_0x56b645){_0x53e97f[_0x9864('0x9')]=_[_0x9864('0xa')](_0x56b645,'id');_0x4846fd(_0x53e97f);})['catch'](function(_0x3fdab0){_0x5daa99(_0x3fdab0);});});}function _0x141fba(_0x23a97f,_0x5be64a){return new Promise(function(_0x2c730a,_0x42da33){var _0x1ae16a=_0x23a97f[_0x9864('0x4')]?{[_0x23a97f['filter'][_0x9864('0x5')]]:_0x23a97f[_0x9864('0x4')]['value']}:undefined;return _0xff120f[_0x23a97f['model']][_0x9864('0x7')]({'where':_0x1ae16a,'raw':!![]})[_0x9864('0x8')](function(_0x115ea3){_0x5be64a['associatedResources']=_[_0x9864('0xa')](_0x115ea3,function(_0x345110){return _0x345110[_0x9864('0xb')];});_0x2c730a(_0x5be64a);})['catch'](function(_0x49ad30){_0x42da33(_0x49ad30);});});}function _0x2d3578(_0x212df6,_0x577dad,_0x40f07f){if(!_0x577dad)return Promise[_0x9864('0xc')](null);return new Promise(function(_0x3edba3,_0x151225){return _0xff120f[_0x9864('0xd')][_0x9864('0x7')]({'where':{'sectionId':_0x577dad['id']},'raw':!![]})[_0x9864('0x8')](function(_0x2f196c){if(_0x212df6[_0x9864('0x5')]&&_0x212df6[_0x9864('0x5')]!=='id'){_0x577dad[_0x9864('0x9')]=_[_0x9864('0xa')](_0x2f196c,function(_0xcdcff0){return _0xcdcff0[_0x212df6['field']];});}else{if(_0x40f07f===_0x9864('0xe')){_0x577dad[_0x9864('0x9')]=_[_0x9864('0xa')](_0x2f196c,function(_0x1a973d){return{'id':_0x1a973d['resourceId'],'type':_0x1a973d[_0x9864('0xf')]};});}else{_0x577dad[_0x9864('0x9')]=_[_0x9864('0xa')](_0x2f196c,function(_0x186014){return _0x186014[_0x9864('0x10')];});}}_0x3edba3(_0x577dad);})[_0x9864('0x11')](function(_0x3b46b7){_0x151225(_0x3b46b7);});});}function _0x4d0ae8(_0x6c3a5f,_0x4b081b){var _0x678ee3={'parentSections':[]};switch(_0x6c3a5f[_0x9864('0x12')]()){case'squareprojects':_0x678ee3[_0x9864('0x13')]='SquareProject';break;case _0x9864('0x14'):_0x678ee3[_0x9864('0x13')]=_0x9864('0x15');break;case _0x9864('0x16'):_0x678ee3['childModel']=_0x9864('0x17');_0x678ee3['parentSections']=[{'name':_0x9864('0x18'),'field':'name','foreignKey':'projectName'}];break;case _0x9864('0x19'):_0x678ee3[_0x9864('0x13')]=_0x9864('0x1a');break;case _0x9864('0x1b'):_0x678ee3[_0x9864('0x13')]=_0x9864('0x1c');_0x678ee3['parentSections']=[{'name':_0x9864('0x1d'),'field':'id','foreignKey':_0x9864('0x1e')}];break;case'lists':_0x678ee3[_0x9864('0x13')]=_0x9864('0x1f');break;case _0x9864('0x20'):_0x678ee3[_0x9864('0x13')]=_0x9864('0x21');break;case _0x9864('0x22'):_0x678ee3[_0x9864('0x13')]=_0x9864('0x23');break;case _0x9864('0x24'):_0x678ee3[_0x9864('0x13')]=_0x9864('0x25');break;case _0x9864('0x26'):_0x678ee3['childModel']='ChatWebsite';break;case'faxqueues':_0x678ee3['childModel']=_0x9864('0x27');break;case _0x9864('0x28'):_0x678ee3[_0x9864('0x13')]='FaxAccount';break;case _0x9864('0x29'):case _0x9864('0x2a'):case _0x9864('0x2b'):_0x678ee3[_0x9864('0x13')]=_0x9864('0x2c');break;case _0x9864('0x2d'):_0x678ee3[_0x9864('0x13')]=_0x9864('0x2e');break;case _0x9864('0x2f'):_0x678ee3['childModel']='VoiceMail';break;case _0x9864('0x30'):_0x678ee3[_0x9864('0x13')]=_0x9864('0x31');_0x678ee3[_0x9864('0x32')]=[{'name':_0x9864('0x33'),'field':_0x9864('0xb'),'foreignKey':_0x9864('0x34'),'model':_0x9864('0x35'),'filter':{'field':_0x9864('0x36'),'value':[_0x9864('0x37')]}},{'name':_0x9864('0x38'),'field':'name','foreignKey':_0x9864('0x34'),'model':'User','filter':{'field':'role','value':[_0x9864('0x39')]}},{'name':'VoiceQueues','field':_0x9864('0xb'),'foreignKey':_0x9864('0x3a'),'model':_0x9864('0x3b'),'filter':{'field':_0x9864('0xf'),'value':[_0x9864('0x3c')]}},{'name':'QueueCampaigns','field':_0x9864('0xb'),'foreignKey':_0x9864('0x3a'),'model':_0x9864('0x3b'),'filter':{'field':'type','value':[_0x9864('0x3d')]}}];break;case'musiconholds':_0x678ee3[_0x9864('0x13')]=_0x9864('0x3e');break;case _0x9864('0x3f'):_0x678ee3['childModel']='VoiceChanSpy';break;case'voiceprefixes':_0x678ee3[_0x9864('0x13')]=_0x9864('0x40');break;case'ivrcampaigns':_0x678ee3['childModel']=_0x9864('0x41');break;case _0x9864('0x42'):_0x678ee3[_0x9864('0x13')]=_0x9864('0x43');break;case _0x9864('0x44'):_0x678ee3[_0x9864('0x13')]=_0x9864('0x45');break;case _0x9864('0x46'):_0x678ee3[_0x9864('0x13')]=_0x9864('0x47');break;case _0x9864('0x48'):_0x678ee3['childModel']=_0x9864('0x49');break;case _0x9864('0x4a'):_0x678ee3[_0x9864('0x13')]='OpenchannelAccount';break;case _0x9864('0x4b'):_0x678ee3[_0x9864('0x13')]=_0x9864('0x4c');break;case _0x9864('0x4d'):_0x678ee3[_0x9864('0x13')]=_0x9864('0x4e');break;case'whatsappqueues':_0x678ee3[_0x9864('0x13')]=_0x9864('0x4f');break;case _0x9864('0x50'):_0x678ee3[_0x9864('0x13')]=_0x9864('0x51');break;case'teams':_0x678ee3['childModel']=_0x9864('0x52');break;case _0x9864('0x53'):case _0x9864('0x54'):_0x678ee3[_0x9864('0x13')]=_0x9864('0x3b');if(_0x4b081b){_0x678ee3['parentSections']=[{'name':_0x9864('0x55')},{'name':'QueueCampaigns'}];}break;case'users':case'agents':case _0x9864('0x56'):_0x678ee3['childModel']=_0x9864('0x35');if(_0x4b081b){_0x678ee3[_0x9864('0x32')]=[{'name':'Users','filter':{'field':_0x9864('0x36'),'value':[_0x9864('0x57'),_0x9864('0x58')]},'ignore':!![]},{'name':_0x9864('0x33')},{'name':_0x9864('0x38')}];}break;case _0x9864('0x59'):_0x678ee3[_0x9864('0x13')]=_0x9864('0x5a');break;case _0x9864('0x5b'):_0x678ee3['childModel']='SalesforceAccount';break;case _0x9864('0x5c'):_0x678ee3[_0x9864('0x13')]=_0x9864('0x5d');break;case _0x9864('0x5e'):_0x678ee3[_0x9864('0x13')]=_0x9864('0x5f');break;case _0x9864('0x60'):_0x678ee3[_0x9864('0x13')]='DeskAccount';break;case _0x9864('0x61'):_0x678ee3[_0x9864('0x13')]=_0x9864('0x62');break;case'vtigeraccounts':_0x678ee3[_0x9864('0x13')]=_0x9864('0x35');break;case _0x9864('0x63'):_0x678ee3[_0x9864('0x13')]=_0x9864('0x64');break;case _0x9864('0x65'):_0x678ee3[_0x9864('0x13')]=_0x9864('0x66');break;case _0x9864('0x67'):_0x678ee3['childModel']=_0x9864('0x68');break;case'intervals':_0x678ee3['childModel']='Interval';break;case _0x9864('0x69'):_0x678ee3[_0x9864('0x13')]=_0x9864('0x6a');break;case _0x9864('0x6b'):_0x678ee3[_0x9864('0x13')]=_0x9864('0x6c');break;case _0x9864('0x6d'):_0x678ee3['childModel']=_0x9864('0x6e');break;case _0x9864('0x6f'):_0x678ee3[_0x9864('0x13')]=_0x9864('0x70');break;case _0x9864('0x71'):_0x678ee3[_0x9864('0x13')]=_0x9864('0x72');break;case _0x9864('0x73'):_0x678ee3[_0x9864('0x13')]=_0x9864('0x74');break;case'trunks':_0x678ee3[_0x9864('0x13')]=_0x9864('0x75');break;case _0x9864('0x76'):_0x678ee3[_0x9864('0x13')]=_0x9864('0x77');break;case _0x9864('0x78'):_0x678ee3['childModel']='Plugin';break;case _0x9864('0x79'):_0x678ee3['childModel']='AnalyticExtractedReport';_0x678ee3[_0x9864('0x32')]=[{'name':_0x9864('0x7a'),'field':'id','foreignKey':_0x9864('0x7b')}];break;case'metrics':_0x678ee3['childModel']=_0x9864('0x7c');break;}return _0x678ee3;}function _0x563d86(_0x39fa20,_0x41708f){var _0x175bfe=_0x39fa20[_0x9864('0x7d')](0x0)['toUpperCase']()+_0x39fa20[_0x9864('0x7e')](0x1);var _0x471a61={'type':_0xff120f['Sequelize'][_0x9864('0x7f')][_0x9864('0x80')],'raw':!![]};return new Promise(function(_0x2e5a5b,_0x461096){var _0x418eea=squel[_0x9864('0x81')]()[_0x9864('0x5')](_0x9864('0x82')+_0x175bfe+_0x9864('0x83'),'id')[_0x9864('0x5')](_0x9864('0x84'))[_0x9864('0x85')](_0x9864('0x86')+_0x39fa20+_0x9864('0x87'),'ui')[_0x9864('0x88')](_0x9864('0x89'),_0x41708f['id']);return _0xff120f['sequelize'][_0x9864('0x8a')](_0x418eea[_0x9864('0x8b')](),_0x471a61)[_0x9864('0x8')](function(_0x3eab45){_0x41708f[_0x175bfe+_0x9864('0x8c')]=_0x3eab45;_0x2e5a5b(_0x3eab45);})[_0x9864('0x11')](function(_0x4f6281){_0x461096(_0x4f6281);});});}return _0x5d919a[_0x9864('0x8d')](_0x9864('0x8e'),attributes,{'tableName':_0x9864('0x8f'),'paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x4583ee){var _0x1c9415={'raw':_0x4583ee['query'][_0x9864('0x90')],'where':{}};var _0x5b6dfd={};var _0x286a56={'count':0x0,'rows':[]};var _0x2a3ea2=_0x4583ee['query'][_0x9864('0x91')];var _0x2f4a59=_0x4583ee['query'][_0x9864('0x92')]||![];var _0x3405ad=_0x4d0ae8(_0x2a3ea2,_0x2f4a59);if(!_0x3405ad['childModel'])throw new Error('Invalid\x20section\x20\x27'+_0x2a3ea2+'\x27');var _0x118d2a=[{'name':_0x2a3ea2}];if(!_[_0x9864('0x93')](_0x3405ad[_0x9864('0x32')]))_0x118d2a=_0x3405ad[_0x9864('0x32')];var _0x28f90c=[];for(var _0x2fff51=0x0;_0x2fff51<_0x118d2a[_0x9864('0x94')];_0x2fff51++){_0x28f90c['push'](_0xff120f[_0x9864('0x95')]['find']({'where':{'userProfileId':_0x4583ee[_0x9864('0x96')]['id'],'name':_0x118d2a[_0x2fff51][_0x9864('0xb')]},'raw':!![]}));}return Promise[_0x9864('0x97')](_0x28f90c)[_0x9864('0x8')](function(_0x1cb35f){var _0x4ca3a9=_['filter'](_0x1cb35f,function(_0x41ff82){return _0x41ff82?_0x41ff82:undefined;});var _0x416af5=_['filter'](_0x118d2a,[_0x9864('0x98'),!![]]);var _0x557dcd=_[_0x9864('0x93')](_0x4ca3a9)&&_[_0x9864('0x93')](_0x416af5)?null:_['union'](_0x416af5,_0x4ca3a9);if(!_0x557dcd)return null;var _0x195cbb=[];for(var _0x54b36d=0x0;_0x54b36d<_0x557dcd[_0x9864('0x94')];_0x54b36d++){var _0x120bcf=_[_0x9864('0x99')](_0x118d2a,function(_0x5745cd){return _0x557dcd[_0x54b36d]?_0x5745cd[_0x9864('0xb')]===_0x557dcd[_0x54b36d][_0x9864('0xb')]:null;});if(_0x120bcf){if(_0x557dcd[_0x54b36d][_0x9864('0x98')]){_0x195cbb['push'](_0x3a2ec5(_0x3405ad['childModel'],_0x557dcd[_0x54b36d]));}else{if(!_0x557dcd[_0x54b36d][_0x9864('0x9a')]){_0x195cbb[_0x9864('0x9b')](_0x2d3578(_0x120bcf,_0x557dcd[_0x54b36d],_0x3405ad[_0x9864('0x13')]));}else{if(_0x120bcf[_0x9864('0x9c')]){_0x195cbb['push'](_0x141fba(_0x120bcf,_0x557dcd[_0x54b36d]));}}}}}return Promise[_0x9864('0x97')](_0x195cbb);})[_0x9864('0x8')](function(_0x280df6){var _0x67a718=_0x280df6;var _0x1943fc=null;if(_0x67a718){_0x1943fc=_0x67a718[_0x9864('0x94')]===0x1?_0x67a718[0x0]:null;}if(!_0x1943fc&&!_0x67a718)return _0x286a56;var _0x312ba9=_0xff120f[_0x3405ad[_0x9864('0x13')]][_0x9864('0x9d')];_0x5b6dfd['model']=_['keys'](_0x312ba9);_0x5b6dfd[_0x9864('0x8a')]=_[_0x9864('0x9e')](_0x4583ee[_0x9864('0x8a')]);_0x5b6dfd[_0x9864('0x9f')]=_['intersection'](_0x5b6dfd[_0x9864('0x9c')],_0x5b6dfd['query']);_0x1c9415['attributes']=_[_0x9864('0xa0')](_0x5b6dfd['model'],qs[_0x9864('0xa1')](_0x4583ee['query'][_0x9864('0xa1')]));_0x1c9415['attributes']=_0x1c9415[_0x9864('0xa2')][_0x9864('0x94')]?_0x1c9415[_0x9864('0xa2')]:_0x5b6dfd['model'];if(!_0x4583ee['query']['hasOwnProperty'](_0x9864('0xa3'))){_0x1c9415[_0x9864('0xa4')]=qs[_0x9864('0xa4')](_0x4583ee['query'][_0x9864('0xa4')]);_0x1c9415[_0x9864('0xa5')]=qs[_0x9864('0xa5')](_0x4583ee['query'][_0x9864('0xa5')]);}_0x1c9415[_0x9864('0xa6')]=qs[_0x9864('0xa7')](_0x4583ee['query']['sort']);_0x1c9415[_0x9864('0x88')]=qs[_0x9864('0x9f')](_[_0x9864('0xa8')](_0x4583ee[_0x9864('0x8a')],_0x5b6dfd['filters']));if(_0x4583ee[_0x9864('0x8a')]['filter']){_0x1c9415[_0x9864('0x88')]=_[_0x9864('0xa9')](_0x1c9415['where'],{'$or':_[_0x9864('0xa')](_0x312ba9,function(_0x52e17b){if(_0x52e17b[_0x9864('0xf')][_0x9864('0xaa')]!==_0x9864('0xab')){var _0x5b157a={};_0x5b157a[_0x52e17b['field']]={'$like':'%'+_0x4583ee['query']['filter']+'%'};return _0x5b157a;}})});}var _0x285dd5=[];var _0x5da54f=null;var _0x27896f={};if(_0x1943fc){_0x5da54f=_[_0x9864('0x99')](_0x118d2a,['name',_0x1943fc[_0x9864('0xb')]]);if(_0x5da54f[_0x9864('0x5')]){_0x27896f={};if(_0x3405ad[_0x9864('0x13')]==='AnalyticExtractedReport'){_0x27896f[_0x5da54f[_0x9864('0xac')]]=_['map'](_0x1943fc[_0x9864('0x9')],'id');}else{_0x27896f[_0x5da54f[_0x9864('0xac')]]=_0x1943fc[_0x9864('0x9')];}_0x285dd5[_0x9864('0x9b')](_0x27896f);}else{_0x1c9415[_0x9864('0x88')]['id']=_0x1943fc['associatedResources'];}}else{for(var _0x49cc30=0x0;_0x49cc30<_0x67a718[_0x9864('0x94')];_0x49cc30++){_0x5da54f=_[_0x9864('0x99')](_0x118d2a,[_0x9864('0xb'),_0x67a718[_0x49cc30][_0x9864('0xb')]]);if(_0x5da54f[_0x9864('0x5')]){_0x27896f={};_0x27896f[_0x5da54f['foreignKey']]=_0x67a718[_0x49cc30][_0x9864('0x9')];_0x285dd5[_0x9864('0x9b')](_0x27896f);}else{if(!_0x1c9415[_0x9864('0x88')]['id'])_0x1c9415['where']['id']=[];_0x67a718[_0x49cc30][_0x9864('0x9')][_0x9864('0xad')](function(_0x1b2586){_0x1c9415[_0x9864('0x88')]['id'][_0x9864('0x9b')](_0x1b2586);});}}}if(!_['isEmpty'](_0x285dd5)){_0x1c9415[_0x9864('0x88')]=_[_0x9864('0xa9')](_0x1c9415['where'],{'$and':{'$or':_0x285dd5}});}_0x1c9415=_[_0x9864('0xa9')]({},_0x1c9415,_0x4583ee[_0x9864('0xae')]);if(_0x1943fc&&!_0x1943fc['autoAssociation']&&_0x3405ad[_0x9864('0x13')]===_0x9864('0xe')){if(_0x4583ee[_0x9864('0x8a')][_0x9864('0xaf')]){_0x1c9415[_0x9864('0xb0')]=[{'all':!![]}];}return _0xff120f[_0x3405ad[_0x9864('0x13')]][_0x9864('0x7')](_0x1c9415)[_0x9864('0x8')](function(_0x3880fa){var _0x3d000f=[];_0x3880fa[_0x9864('0xad')](function(_0x2fa45f){var _0x3e5f57;switch(_0x2fa45f[_0x9864('0xb1')]){case'default':_0x3e5f57=_[_0x9864('0x99')](_0x1943fc[_0x9864('0x9')],function(_0x591657){return _0x591657['id']===_0x2fa45f[_0x9864('0x7b')]&&_0x591657[_0x9864('0xf')]===_0x9864('0xb2');});break;case _0x9864('0xb3'):_0x3e5f57=_['find'](_0x1943fc[_0x9864('0x9')],function(_0x3805b3){return _0x3805b3['id']===_0x2fa45f['reportId']&&_0x3805b3[_0x9864('0xf')]===_0x9864('0xb4');});break;}if(_0x3e5f57)_0x3d000f[_0x9864('0x9b')](_0x2fa45f);});_0x286a56[_0x9864('0xb5')]=_0x3d000f[_0x9864('0x94')];_0x286a56[_0x9864('0xb6')]=_0x3d000f;return _0x286a56;});}else{if(!_[_0x9864('0x93')](_0x4583ee['query'][_0x9864('0xb7')])){_0x1c9415[_0x9864('0x88')]['id']=_0x1c9415[_0x9864('0x88')]['id']?_[_0x9864('0xa0')](_0x1c9415[_0x9864('0x88')]['id'],_0x4583ee[_0x9864('0x8a')][_0x9864('0xb7')]):_0x4583ee['query'][_0x9864('0xb7')];if(_0x4583ee['query'][_0x9864('0xb8')]){_0x1c9415[_0x9864('0xa6')]=_0x4583ee[_0x9864('0x8a')][_0x9864('0xb8')];}}if(_0x4583ee['query'][_0x9864('0xb9')]){_0x1c9415['where']=_['merge'](_0x1c9415['where'],{'$and':_0x4583ee['query'][_0x9864('0xb9')]});}return _0xff120f[_0x3405ad[_0x9864('0x13')]][_0x9864('0xb5')]({'where':_0x1c9415[_0x9864('0x88')]})[_0x9864('0x8')](function(_0x726e44){_0x286a56[_0x9864('0xb5')]=_0x726e44;if(_0x4583ee['query'][_0x9864('0xaf')]){if(_0x3405ad['childModel']===_0x9864('0x1c')){_0x1c9415[_0x9864('0xb0')]=[{'model':_0xff120f[_0x9864('0x70')],'as':_0x9864('0xba'),'attributes':['id','name',_0x9864('0xbb')],'required':_0x4583ee[_0x9864('0x8a')][_0x9864('0xbc')]?!![]:![]},{'model':_0xff120f[_0x9864('0x70')],'as':_0x9864('0xbd'),'attributes':['id',_0x9864('0xb'),_0x9864('0xbb')],'through':_0x4583ee[_0x9864('0x8a')][_0x9864('0xbc')]?{'attributes':[],'where':{'TagId':_0x4583ee['query'][_0x9864('0xbc')]||undefined}}:{},'required':_0x4583ee[_0x9864('0x8a')]['tag']?!![]:![]}];}else{_0x1c9415[_0x9864('0xb0')]=[{'all':!![]}];}}return _0xff120f[_0x3405ad['childModel']][_0x9864('0x7')](_0x1c9415);})['then'](function(_0xd8197f){_0x286a56[_0x9864('0xb6')]=_0xd8197f;if(_0x2a3ea2==='Agents'&&_0x4583ee[_0x9864('0x8a')][_0x9864('0xbe')]===_0x9864('0xbf')){var _0x185df0=[];for(var _0x40f415=0x0;_0x40f415<_0x286a56['rows'][_0x9864('0x94')];_0x40f415++){_0x185df0[_0x9864('0x9b')](_0x563d86('chat',_0x286a56[_0x9864('0xb6')][_0x40f415][_0x9864('0xc0')]));_0x185df0['push'](_0x563d86(_0x9864('0xc1'),_0x286a56[_0x9864('0xb6')][_0x40f415][_0x9864('0xc0')]));_0x185df0['push'](_0x563d86('fax',_0x286a56[_0x9864('0xb6')][_0x40f415][_0x9864('0xc0')]));_0x185df0['push'](_0x563d86('mail',_0x286a56[_0x9864('0xb6')][_0x40f415][_0x9864('0xc0')]));_0x185df0[_0x9864('0x9b')](_0x563d86(_0x9864('0xc2'),_0x286a56[_0x9864('0xb6')][_0x40f415][_0x9864('0xc0')]));_0x185df0['push'](_0x563d86('whatsapp',_0x286a56[_0x9864('0xb6')][_0x40f415][_0x9864('0xc0')]));}return Promise[_0x9864('0x97')](_0x185df0)['then'](function(){return _0x286a56;});}return _0x286a56;});}});}}});};
\ 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