Built motion from commit 85328c08.|2.5.50
[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 _0x1eba=['plugins','Plugin','extractedreports','reportId','metrics','AnalyticMetric','charAt','toUpperCase','Sequelize','QueryTypes','SELECT','select','ui.','InteractionId','user_has_','where','sequelize','query','define','user_profiles','raw','section','mergeResources','Invalid\x20section\x20\x27','isEmpty','UserProfileSection','find','params','all','ignore','union','length','push','autoAssociation','model','keys','filters','intersection','fields','attributes','hasOwnProperty','nolimit','limit','offset','order','sort','pick','merge','VIRTUAL','foreignKey','options','includeAll','default','DefaultReports','custom','CustomReports','count','rows','ids','include','ThroughTags','tag','openTabs','chat','dataValues','sms','mail','openchannel','whatsapp','lodash','./userProfile.attributes','../../components/parsers/qs','squel','exports','models','filter','field','value','then','associatedResources','catch','findAll','map','name','UserProfileResource','AnalyticExtractedReport','resourceId','type','toLowerCase','squareprojects','childModel','SquareProject','odbc','SquareOdbc','squarerecordings','parentSections','SquareProjects','projectName','JscriptyProject','CmContact','ListId','lists','CmList','companies','CmCompany','globalcustomfields','CmCustomField','chatqueues','ChatQueue','chatwebsites','ChatWebsite','faxqueues','FaxQueue','faxaccounts','inboundroutes','internalroutes','outboundroutes','VoiceExtension','VoiceContext','voicemails','voicerecordings','VoiceRecording','Agents','membername','role','agent','Telephones','User','telephone','VoiceQueues','queue','VoiceQueue','inbound','QueueCampaigns','outbound','musiconholds','VoiceMusicOnHold','chanspies','VoiceChanSpy','voiceprefixes','ivrcampaigns','Campaign','mailqueues','MailQueue','mailaccounts','MailAccount','mailsubstatuses','MailSubstatus','OpenchannelQueue','openchannelaccounts','OpenchannelAccount','smsqueues','SmsQueue','smsaccounts','SmsAccount','whatsappqueues','WhatsappQueue','whatsappaccounts','teams','Team','voicequeues','users','agents','telephones','Users','admin','user','zendeskaccounts','salesforceaccounts','SalesforceAccount','freshdeskaccounts','FreshdeskAccount','sugarcrmaccounts','SugarcrmAccount','deskaccounts','DeskAccount','zohoaccounts','ZohoAccount','vtigeraccounts','cannedanswers','CannedAnswer','Disposition','customdashboards','Dashboard','intervals','Interval','pauses','Pause','scheduler','Schedule','sounds','Sound','tags','Tag','templates','Template','triggers','Trigger','trunks','Trunk','variables'];(function(_0x1d895d,_0x3e5c93){var _0x2dae23=function(_0x443cd0){while(--_0x443cd0){_0x1d895d['push'](_0x1d895d['shift']());}};_0x2dae23(++_0x3e5c93);}(_0x1eba,0x1d7));var _0xa1eb=function(_0x1fc84d,_0x3f469d){_0x1fc84d=_0x1fc84d-0x0;var _0x2658fa=_0x1eba[_0x1fc84d];return _0x2658fa;};'use strict';var _=require(_0xa1eb('0x0'));var attributes=require(_0xa1eb('0x1'));var qs=require(_0xa1eb('0x2'));var squel=require(_0xa1eb('0x3'));module[_0xa1eb('0x4')]=function(_0x5865fc){var _0x56c5f2=_0x5865fc[_0xa1eb('0x5')];function _0x34be5a(_0x16a13a,_0xf9d704){return new Promise(function(_0x138789,_0x2933d0){if(!_0xf9d704)return _0x138789(null);var _0x1d0d67=_0xf9d704[_0xa1eb('0x6')]?{[_0xf9d704[_0xa1eb('0x6')][_0xa1eb('0x7')]]:_0xf9d704[_0xa1eb('0x6')][_0xa1eb('0x8')]}:undefined;return _0x56c5f2[_0x16a13a]['findAll']({'where':_0x1d0d67,'raw':!![]})[_0xa1eb('0x9')](function(_0x4d4aaf){_0xf9d704[_0xa1eb('0xa')]=_['map'](_0x4d4aaf,'id');_0x138789(_0xf9d704);})[_0xa1eb('0xb')](function(_0x5d7101){_0x2933d0(_0x5d7101);});});}function _0x41a7bc(_0x5502e4,_0xc23b2e){return new Promise(function(_0x325d13,_0x151580){var _0x5839d3=_0x5502e4[_0xa1eb('0x6')]?{[_0x5502e4[_0xa1eb('0x6')]['field']]:_0x5502e4[_0xa1eb('0x6')]['value']}:undefined;return _0x56c5f2[_0x5502e4['model']][_0xa1eb('0xc')]({'where':_0x5839d3,'raw':!![]})['then'](function(_0x25d058){_0xc23b2e[_0xa1eb('0xa')]=_[_0xa1eb('0xd')](_0x25d058,function(_0x2877cb){return _0x2877cb[_0xa1eb('0xe')];});_0x325d13(_0xc23b2e);})[_0xa1eb('0xb')](function(_0x1c858c){_0x151580(_0x1c858c);});});}function _0x45d6dd(_0x211e42,_0x4aa527,_0xbd6a6b){if(!_0x4aa527)return Promise['resolve'](null);return new Promise(function(_0x1401ef,_0x3dafcd){return _0x56c5f2[_0xa1eb('0xf')][_0xa1eb('0xc')]({'where':{'sectionId':_0x4aa527['id']},'raw':!![]})['then'](function(_0x1dd621){if(_0x211e42[_0xa1eb('0x7')]&&_0x211e42[_0xa1eb('0x7')]!=='id'){_0x4aa527[_0xa1eb('0xa')]=_[_0xa1eb('0xd')](_0x1dd621,function(_0x3b8607){return _0x3b8607[_0x211e42[_0xa1eb('0x7')]];});}else{if(_0xbd6a6b===_0xa1eb('0x10')){_0x4aa527['associatedResources']=_[_0xa1eb('0xd')](_0x1dd621,function(_0x56653c){return{'id':_0x56653c[_0xa1eb('0x11')],'type':_0x56653c[_0xa1eb('0x12')]};});}else{_0x4aa527[_0xa1eb('0xa')]=_[_0xa1eb('0xd')](_0x1dd621,function(_0x5e7a34){return _0x5e7a34['resourceId'];});}}_0x1401ef(_0x4aa527);})[_0xa1eb('0xb')](function(_0xc64cb9){_0x3dafcd(_0xc64cb9);});});}function _0x5b0903(_0x437b2a,_0x250728){var _0x258d3a={'parentSections':[]};switch(_0x437b2a[_0xa1eb('0x13')]()){case _0xa1eb('0x14'):_0x258d3a[_0xa1eb('0x15')]=_0xa1eb('0x16');break;case _0xa1eb('0x17'):_0x258d3a[_0xa1eb('0x15')]=_0xa1eb('0x18');break;case _0xa1eb('0x19'):_0x258d3a[_0xa1eb('0x15')]='SquareRecording';_0x258d3a[_0xa1eb('0x1a')]=[{'name':_0xa1eb('0x1b'),'field':'name','foreignKey':_0xa1eb('0x1c')}];break;case'projects':_0x258d3a[_0xa1eb('0x15')]=_0xa1eb('0x1d');break;case'contacts':_0x258d3a[_0xa1eb('0x15')]=_0xa1eb('0x1e');_0x258d3a[_0xa1eb('0x1a')]=[{'name':'Lists','field':'id','foreignKey':_0xa1eb('0x1f')}];break;case _0xa1eb('0x20'):_0x258d3a['childModel']=_0xa1eb('0x21');break;case _0xa1eb('0x22'):_0x258d3a[_0xa1eb('0x15')]=_0xa1eb('0x23');break;case _0xa1eb('0x24'):_0x258d3a['childModel']=_0xa1eb('0x25');break;case _0xa1eb('0x26'):_0x258d3a[_0xa1eb('0x15')]=_0xa1eb('0x27');break;case _0xa1eb('0x28'):_0x258d3a[_0xa1eb('0x15')]=_0xa1eb('0x29');break;case _0xa1eb('0x2a'):_0x258d3a[_0xa1eb('0x15')]=_0xa1eb('0x2b');break;case _0xa1eb('0x2c'):_0x258d3a['childModel']='FaxAccount';break;case _0xa1eb('0x2d'):case _0xa1eb('0x2e'):case _0xa1eb('0x2f'):_0x258d3a[_0xa1eb('0x15')]=_0xa1eb('0x30');break;case'contexts':_0x258d3a['childModel']=_0xa1eb('0x31');break;case _0xa1eb('0x32'):_0x258d3a['childModel']='VoiceMail';break;case _0xa1eb('0x33'):_0x258d3a['childModel']=_0xa1eb('0x34');_0x258d3a['parentSections']=[{'name':_0xa1eb('0x35'),'field':_0xa1eb('0xe'),'foreignKey':_0xa1eb('0x36'),'model':'User','filter':{'field':_0xa1eb('0x37'),'value':[_0xa1eb('0x38')]}},{'name':_0xa1eb('0x39'),'field':'name','foreignKey':_0xa1eb('0x36'),'model':_0xa1eb('0x3a'),'filter':{'field':_0xa1eb('0x37'),'value':[_0xa1eb('0x3b')]}},{'name':_0xa1eb('0x3c'),'field':'name','foreignKey':_0xa1eb('0x3d'),'model':_0xa1eb('0x3e'),'filter':{'field':_0xa1eb('0x12'),'value':[_0xa1eb('0x3f')]}},{'name':_0xa1eb('0x40'),'field':_0xa1eb('0xe'),'foreignKey':_0xa1eb('0x3d'),'model':_0xa1eb('0x3e'),'filter':{'field':'type','value':[_0xa1eb('0x41')]}}];break;case _0xa1eb('0x42'):_0x258d3a[_0xa1eb('0x15')]=_0xa1eb('0x43');break;case _0xa1eb('0x44'):_0x258d3a['childModel']=_0xa1eb('0x45');break;case _0xa1eb('0x46'):_0x258d3a[_0xa1eb('0x15')]='VoicePrefix';break;case _0xa1eb('0x47'):_0x258d3a[_0xa1eb('0x15')]=_0xa1eb('0x48');break;case _0xa1eb('0x49'):_0x258d3a[_0xa1eb('0x15')]=_0xa1eb('0x4a');break;case _0xa1eb('0x4b'):_0x258d3a['childModel']=_0xa1eb('0x4c');break;case _0xa1eb('0x4d'):_0x258d3a['childModel']=_0xa1eb('0x4e');break;case'openchannelqueues':_0x258d3a[_0xa1eb('0x15')]=_0xa1eb('0x4f');break;case _0xa1eb('0x50'):_0x258d3a[_0xa1eb('0x15')]=_0xa1eb('0x51');break;case _0xa1eb('0x52'):_0x258d3a[_0xa1eb('0x15')]=_0xa1eb('0x53');break;case _0xa1eb('0x54'):_0x258d3a[_0xa1eb('0x15')]=_0xa1eb('0x55');break;case _0xa1eb('0x56'):_0x258d3a[_0xa1eb('0x15')]=_0xa1eb('0x57');break;case _0xa1eb('0x58'):_0x258d3a[_0xa1eb('0x15')]='WhatsappAccount';break;case _0xa1eb('0x59'):_0x258d3a['childModel']=_0xa1eb('0x5a');break;case _0xa1eb('0x5b'):case'queuecampaigns':_0x258d3a['childModel']=_0xa1eb('0x3e');if(_0x250728){_0x258d3a[_0xa1eb('0x1a')]=[{'name':_0xa1eb('0x3c')},{'name':'QueueCampaigns'}];}break;case _0xa1eb('0x5c'):case _0xa1eb('0x5d'):case _0xa1eb('0x5e'):_0x258d3a[_0xa1eb('0x15')]=_0xa1eb('0x3a');if(_0x250728){_0x258d3a[_0xa1eb('0x1a')]=[{'name':_0xa1eb('0x5f'),'filter':{'field':_0xa1eb('0x37'),'value':[_0xa1eb('0x60'),_0xa1eb('0x61')]},'ignore':!![]},{'name':_0xa1eb('0x35')},{'name':_0xa1eb('0x39')}];}break;case _0xa1eb('0x62'):_0x258d3a[_0xa1eb('0x15')]='ZendeskAccount';break;case _0xa1eb('0x63'):_0x258d3a[_0xa1eb('0x15')]=_0xa1eb('0x64');break;case _0xa1eb('0x65'):_0x258d3a[_0xa1eb('0x15')]=_0xa1eb('0x66');break;case _0xa1eb('0x67'):_0x258d3a['childModel']=_0xa1eb('0x68');break;case _0xa1eb('0x69'):_0x258d3a[_0xa1eb('0x15')]=_0xa1eb('0x6a');break;case _0xa1eb('0x6b'):_0x258d3a[_0xa1eb('0x15')]=_0xa1eb('0x6c');break;case _0xa1eb('0x6d'):_0x258d3a[_0xa1eb('0x15')]='User';break;case _0xa1eb('0x6e'):_0x258d3a['childModel']=_0xa1eb('0x6f');break;case'dispositions':_0x258d3a[_0xa1eb('0x15')]=_0xa1eb('0x70');break;case _0xa1eb('0x71'):_0x258d3a['childModel']=_0xa1eb('0x72');break;case _0xa1eb('0x73'):_0x258d3a['childModel']=_0xa1eb('0x74');break;case _0xa1eb('0x75'):_0x258d3a[_0xa1eb('0x15')]=_0xa1eb('0x76');break;case _0xa1eb('0x77'):_0x258d3a[_0xa1eb('0x15')]=_0xa1eb('0x78');break;case _0xa1eb('0x79'):_0x258d3a[_0xa1eb('0x15')]=_0xa1eb('0x7a');break;case _0xa1eb('0x7b'):_0x258d3a[_0xa1eb('0x15')]=_0xa1eb('0x7c');break;case _0xa1eb('0x7d'):_0x258d3a[_0xa1eb('0x15')]=_0xa1eb('0x7e');break;case _0xa1eb('0x7f'):_0x258d3a['childModel']=_0xa1eb('0x80');break;case _0xa1eb('0x81'):_0x258d3a[_0xa1eb('0x15')]=_0xa1eb('0x82');break;case _0xa1eb('0x83'):_0x258d3a[_0xa1eb('0x15')]='Variable';break;case _0xa1eb('0x84'):_0x258d3a[_0xa1eb('0x15')]=_0xa1eb('0x85');break;case _0xa1eb('0x86'):_0x258d3a[_0xa1eb('0x15')]=_0xa1eb('0x10');_0x258d3a[_0xa1eb('0x1a')]=[{'name':'Reports','field':'id','foreignKey':_0xa1eb('0x87')}];break;case _0xa1eb('0x88'):_0x258d3a[_0xa1eb('0x15')]=_0xa1eb('0x89');break;}return _0x258d3a;}function _0x4c30ad(_0x5af1e6,_0x58ca4e){var _0x5673fa=_0x5af1e6[_0xa1eb('0x8a')](0x0)[_0xa1eb('0x8b')]()+_0x5af1e6['slice'](0x1);var _0x4643f3={'type':_0x56c5f2[_0xa1eb('0x8c')][_0xa1eb('0x8d')][_0xa1eb('0x8e')],'raw':!![]};return new Promise(function(_0x4edf8e,_0x481d19){var _0x201e6a=squel[_0xa1eb('0x8f')]()[_0xa1eb('0x7')](_0xa1eb('0x90')+_0x5673fa+_0xa1eb('0x91'),'id')[_0xa1eb('0x7')]('ui.createdAt')['from'](_0xa1eb('0x92')+_0x5af1e6+'_interactions','ui')[_0xa1eb('0x93')]('ui.UserId\x20=\x20?',_0x58ca4e['id']);return _0x56c5f2[_0xa1eb('0x94')][_0xa1eb('0x95')](_0x201e6a['toString'](),_0x4643f3)[_0xa1eb('0x9')](function(_0xf48372){_0x58ca4e[_0x5673fa+'OpenTabs']=_0xf48372;_0x4edf8e(_0xf48372);})[_0xa1eb('0xb')](function(_0x17feb5){_0x481d19(_0x17feb5);});});}return _0x5865fc[_0xa1eb('0x96')]('UserProfile',attributes,{'tableName':_0xa1eb('0x97'),'paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x11e85f){var _0x4af59a={'raw':_0x11e85f[_0xa1eb('0x95')][_0xa1eb('0x98')],'where':{}};var _0x139a37={};var _0x4a0545={'count':0x0,'rows':[]};var _0x3a43c3=_0x11e85f['query'][_0xa1eb('0x99')];var _0x1ea97b=_0x11e85f[_0xa1eb('0x95')][_0xa1eb('0x9a')]||![];var _0x2df867=_0x5b0903(_0x3a43c3,_0x1ea97b);if(!_0x2df867['childModel'])throw new Error(_0xa1eb('0x9b')+_0x3a43c3+'\x27');var _0x401800=[{'name':_0x3a43c3}];if(!_[_0xa1eb('0x9c')](_0x2df867['parentSections']))_0x401800=_0x2df867[_0xa1eb('0x1a')];var _0x527921=[];for(var _0x4e582c=0x0;_0x4e582c<_0x401800['length'];_0x4e582c++){_0x527921['push'](_0x56c5f2[_0xa1eb('0x9d')][_0xa1eb('0x9e')]({'where':{'userProfileId':_0x11e85f[_0xa1eb('0x9f')]['id'],'name':_0x401800[_0x4e582c][_0xa1eb('0xe')]},'raw':!![]}));}return Promise[_0xa1eb('0xa0')](_0x527921)[_0xa1eb('0x9')](function(_0x11f031){var _0xc8cb66=_[_0xa1eb('0x6')](_0x11f031,function(_0x43d59b){return _0x43d59b?_0x43d59b:undefined;});var _0x5cf153=_[_0xa1eb('0x6')](_0x401800,[_0xa1eb('0xa1'),!![]]);var _0x46207c=_[_0xa1eb('0x9c')](_0xc8cb66)&&_[_0xa1eb('0x9c')](_0x5cf153)?null:_[_0xa1eb('0xa2')](_0x5cf153,_0xc8cb66);if(!_0x46207c)return null;var _0x4bf3c9=[];for(var _0x113a3a=0x0;_0x113a3a<_0x46207c[_0xa1eb('0xa3')];_0x113a3a++){var _0x16c5a3=_['find'](_0x401800,function(_0x1434a1){return _0x46207c[_0x113a3a]?_0x1434a1[_0xa1eb('0xe')]===_0x46207c[_0x113a3a][_0xa1eb('0xe')]:null;});if(_0x16c5a3){if(_0x46207c[_0x113a3a][_0xa1eb('0xa1')]){_0x4bf3c9[_0xa1eb('0xa4')](_0x34be5a(_0x2df867['childModel'],_0x46207c[_0x113a3a]));}else{if(!_0x46207c[_0x113a3a][_0xa1eb('0xa5')]){_0x4bf3c9['push'](_0x45d6dd(_0x16c5a3,_0x46207c[_0x113a3a],_0x2df867[_0xa1eb('0x15')]));}else{if(_0x16c5a3['model']){_0x4bf3c9[_0xa1eb('0xa4')](_0x41a7bc(_0x16c5a3,_0x46207c[_0x113a3a]));}}}}}return Promise[_0xa1eb('0xa0')](_0x4bf3c9);})[_0xa1eb('0x9')](function(_0x32cdfa){var _0x47c618=_0x32cdfa;var _0x3bc2e7=null;if(_0x47c618){_0x3bc2e7=_0x47c618[_0xa1eb('0xa3')]===0x1?_0x47c618[0x0]:null;}if(!_0x3bc2e7&&!_0x47c618)return _0x4a0545;var _0x2b8191=_0x56c5f2[_0x2df867[_0xa1eb('0x15')]]['rawAttributes'];_0x139a37[_0xa1eb('0xa6')]=_[_0xa1eb('0xa7')](_0x2b8191);_0x139a37[_0xa1eb('0x95')]=_[_0xa1eb('0xa7')](_0x11e85f[_0xa1eb('0x95')]);_0x139a37[_0xa1eb('0xa8')]=_[_0xa1eb('0xa9')](_0x139a37[_0xa1eb('0xa6')],_0x139a37[_0xa1eb('0x95')]);_0x4af59a['attributes']=_['intersection'](_0x139a37['model'],qs[_0xa1eb('0xaa')](_0x11e85f['query'][_0xa1eb('0xaa')]));_0x4af59a[_0xa1eb('0xab')]=_0x4af59a['attributes']['length']?_0x4af59a[_0xa1eb('0xab')]:_0x139a37[_0xa1eb('0xa6')];if(!_0x11e85f[_0xa1eb('0x95')][_0xa1eb('0xac')](_0xa1eb('0xad'))){_0x4af59a['limit']=qs['limit'](_0x11e85f[_0xa1eb('0x95')][_0xa1eb('0xae')]);_0x4af59a[_0xa1eb('0xaf')]=qs[_0xa1eb('0xaf')](_0x11e85f['query'][_0xa1eb('0xaf')]);}_0x4af59a[_0xa1eb('0xb0')]=qs[_0xa1eb('0xb1')](_0x11e85f[_0xa1eb('0x95')][_0xa1eb('0xb1')]);_0x4af59a[_0xa1eb('0x93')]=qs[_0xa1eb('0xa8')](_[_0xa1eb('0xb2')](_0x11e85f[_0xa1eb('0x95')],_0x139a37[_0xa1eb('0xa8')]));if(_0x11e85f[_0xa1eb('0x95')]['filter']){_0x4af59a[_0xa1eb('0x93')]=_[_0xa1eb('0xb3')](_0x4af59a[_0xa1eb('0x93')],{'$or':_[_0xa1eb('0xd')](_0x2b8191,function(_0x3fe7ef){if(_0x3fe7ef[_0xa1eb('0x12')]['key']!==_0xa1eb('0xb4')){var _0x36a94f={};_0x36a94f[_0x3fe7ef[_0xa1eb('0x7')]]={'$like':'%'+_0x11e85f[_0xa1eb('0x95')]['filter']+'%'};return _0x36a94f;}})});}var _0x4e24dc=[];var _0xff1843=null;var _0x5e0cd5={};if(_0x3bc2e7){_0xff1843=_[_0xa1eb('0x9e')](_0x401800,[_0xa1eb('0xe'),_0x3bc2e7['name']]);if(_0xff1843[_0xa1eb('0x7')]){_0x5e0cd5={};if(_0x2df867[_0xa1eb('0x15')]==='AnalyticExtractedReport'){_0x5e0cd5[_0xff1843[_0xa1eb('0xb5')]]=_[_0xa1eb('0xd')](_0x3bc2e7[_0xa1eb('0xa')],'id');}else{_0x5e0cd5[_0xff1843[_0xa1eb('0xb5')]]=_0x3bc2e7[_0xa1eb('0xa')];}_0x4e24dc[_0xa1eb('0xa4')](_0x5e0cd5);}else{_0x4af59a[_0xa1eb('0x93')]['id']=_0x3bc2e7[_0xa1eb('0xa')];}}else{for(var _0x3d32da=0x0;_0x3d32da<_0x47c618[_0xa1eb('0xa3')];_0x3d32da++){_0xff1843=_[_0xa1eb('0x9e')](_0x401800,['name',_0x47c618[_0x3d32da][_0xa1eb('0xe')]]);if(_0xff1843[_0xa1eb('0x7')]){_0x5e0cd5={};_0x5e0cd5[_0xff1843[_0xa1eb('0xb5')]]=_0x47c618[_0x3d32da][_0xa1eb('0xa')];_0x4e24dc['push'](_0x5e0cd5);}else{if(!_0x4af59a[_0xa1eb('0x93')]['id'])_0x4af59a[_0xa1eb('0x93')]['id']=[];_0x47c618[_0x3d32da][_0xa1eb('0xa')]['forEach'](function(_0x214913){_0x4af59a[_0xa1eb('0x93')]['id'][_0xa1eb('0xa4')](_0x214913);});}}}if(!_['isEmpty'](_0x4e24dc)){_0x4af59a[_0xa1eb('0x93')]=_['merge'](_0x4af59a[_0xa1eb('0x93')],{'$and':{'$or':_0x4e24dc}});}_0x4af59a=_[_0xa1eb('0xb3')]({},_0x4af59a,_0x11e85f[_0xa1eb('0xb6')]);if(_0x3bc2e7&&!_0x3bc2e7[_0xa1eb('0xa5')]&&_0x2df867[_0xa1eb('0x15')]===_0xa1eb('0x10')){if(_0x11e85f[_0xa1eb('0x95')][_0xa1eb('0xb7')]){_0x4af59a['include']=[{'all':!![]}];}return _0x56c5f2[_0x2df867[_0xa1eb('0x15')]][_0xa1eb('0xc')](_0x4af59a)[_0xa1eb('0x9')](function(_0x3ae7e1){var _0x454320=[];_0x3ae7e1['forEach'](function(_0x140475){var _0x2a9f79;switch(_0x140475['reportType']){case _0xa1eb('0xb8'):_0x2a9f79=_['find'](_0x3bc2e7['associatedResources'],function(_0x29f795){return _0x29f795['id']===_0x140475[_0xa1eb('0x87')]&&_0x29f795['type']===_0xa1eb('0xb9');});break;case _0xa1eb('0xba'):_0x2a9f79=_['find'](_0x3bc2e7[_0xa1eb('0xa')],function(_0x2c49d1){return _0x2c49d1['id']===_0x140475['reportId']&&_0x2c49d1['type']===_0xa1eb('0xbb');});break;}if(_0x2a9f79)_0x454320['push'](_0x140475);});_0x4a0545[_0xa1eb('0xbc')]=_0x454320[_0xa1eb('0xa3')];_0x4a0545[_0xa1eb('0xbd')]=_0x454320;return _0x4a0545;});}else{if(!_[_0xa1eb('0x9c')](_0x11e85f[_0xa1eb('0x95')][_0xa1eb('0xbe')])){_0x4af59a['where']['id']=_0x4af59a[_0xa1eb('0x93')]['id']?_['intersection'](_0x4af59a[_0xa1eb('0x93')]['id'],_0x11e85f[_0xa1eb('0x95')][_0xa1eb('0xbe')]):_0x11e85f[_0xa1eb('0x95')][_0xa1eb('0xbe')];}return _0x56c5f2[_0x2df867[_0xa1eb('0x15')]][_0xa1eb('0xbc')]({'where':_0x4af59a['where']})[_0xa1eb('0x9')](function(_0x4effc0){_0x4a0545['count']=_0x4effc0;if(_0x11e85f[_0xa1eb('0x95')][_0xa1eb('0xb7')]){if(_0x2df867[_0xa1eb('0x15')]===_0xa1eb('0x1e')){_0x4af59a[_0xa1eb('0xbf')]=[{'model':_0x56c5f2[_0xa1eb('0x7c')],'as':'Tags','attributes':['id',_0xa1eb('0xe'),'color'],'required':_0x11e85f[_0xa1eb('0x95')]['tag']?!![]:![]},{'model':_0x56c5f2[_0xa1eb('0x7c')],'as':_0xa1eb('0xc0'),'attributes':['id','name','color'],'through':_0x11e85f[_0xa1eb('0x95')][_0xa1eb('0xc1')]?{'attributes':[],'where':{'TagId':_0x11e85f[_0xa1eb('0x95')][_0xa1eb('0xc1')]||undefined}}:{},'required':_0x11e85f[_0xa1eb('0x95')][_0xa1eb('0xc1')]?!![]:![]}];}else{_0x4af59a[_0xa1eb('0xbf')]=[{'all':!![]}];}}return _0x56c5f2[_0x2df867[_0xa1eb('0x15')]][_0xa1eb('0xc')](_0x4af59a);})[_0xa1eb('0x9')](function(_0x2fc881){_0x4a0545[_0xa1eb('0xbd')]=_0x2fc881;if(_0x3a43c3===_0xa1eb('0x35')&&_0x11e85f[_0xa1eb('0x95')][_0xa1eb('0xc2')]==='true'){var _0x2593b5=[];for(var _0x34d84d=0x0;_0x34d84d<_0x4a0545['rows'][_0xa1eb('0xa3')];_0x34d84d++){_0x2593b5['push'](_0x4c30ad(_0xa1eb('0xc3'),_0x4a0545[_0xa1eb('0xbd')][_0x34d84d][_0xa1eb('0xc4')]));_0x2593b5['push'](_0x4c30ad(_0xa1eb('0xc5'),_0x4a0545[_0xa1eb('0xbd')][_0x34d84d][_0xa1eb('0xc4')]));_0x2593b5[_0xa1eb('0xa4')](_0x4c30ad('fax',_0x4a0545[_0xa1eb('0xbd')][_0x34d84d]['dataValues']));_0x2593b5[_0xa1eb('0xa4')](_0x4c30ad(_0xa1eb('0xc6'),_0x4a0545[_0xa1eb('0xbd')][_0x34d84d][_0xa1eb('0xc4')]));_0x2593b5[_0xa1eb('0xa4')](_0x4c30ad(_0xa1eb('0xc7'),_0x4a0545[_0xa1eb('0xbd')][_0x34d84d][_0xa1eb('0xc4')]));_0x2593b5['push'](_0x4c30ad(_0xa1eb('0xc8'),_0x4a0545[_0xa1eb('0xbd')][_0x34d84d][_0xa1eb('0xc4')]));}return Promise[_0xa1eb('0xa0')](_0x2593b5)[_0xa1eb('0x9')](function(){return _0x4a0545;});}return _0x4a0545;});}});}}});};