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 _0x06ba=['mailaccounts','mailsubstatuses','MailSubstatus','openchannelqueues','OpenchannelQueue','OpenchannelAccount','smsqueues','SmsQueue','smsaccounts','SmsAccount','whatsappqueues','WhatsappQueue','whatsappaccounts','WhatsappAccount','teams','Team','queuecampaigns','users','agents','Users','user','Telephones','zendeskaccounts','ZendeskAccount','SalesforceAccount','freshdeskaccounts','FreshdeskAccount','sugarcrmaccounts','SugarcrmAccount','DeskAccount','zohoaccounts','ZohoAccount','cannedanswers','CannedAnswer','dispositions','Disposition','customdashboards','Dashboard','intervals','Interval','pauses','Pause','scheduler','Schedule','sounds','Sound','tags','templates','Template','triggers','Trigger','trunks','variables','plugins','Plugin','extractedreports','Reports','reportId','metrics','AnalyticMetric','charAt','toUpperCase','slice','Sequelize','QueryTypes','SELECT','select','ui.','InteractionId','ui.createdAt','from','where','sequelize','toString','OpenTabs','UserProfile','user_profiles','query','mergeResources','Invalid\x20section\x20\x27','isEmpty','length','UserProfileSection','params','all','ignore','union','find','autoAssociation','push','rawAttributes','keys','filters','attributes','intersection','fields','hasOwnProperty','nolimit','limit','offset','sort','pick','merge','key','foreignKey','forEach','options','includeAll','default','CustomReports','count','color','ThroughTags','tag','include','rows','openTabs','dataValues','sms','fax','openchannel','lodash','../../components/parsers/qs','squel','exports','models','filter','field','then','associatedResources','catch','value','model','findAll','map','AnalyticExtractedReport','resourceId','type','squareprojects','childModel','SquareProject','odbc','SquareOdbc','squarerecordings','SquareRecording','parentSections','SquareProjects','name','projectName','projects','CmContact','CmList','companies','globalcustomfields','chatqueues','ChatQueue','ChatWebsite','faxqueues','FaxQueue','faxaccounts','inboundroutes','internalroutes','outboundroutes','VoiceExtension','contexts','voicemails','voicerecordings','VoiceRecording','Agents','membername','User','role','telephone','VoiceQueues','queue','VoiceQueue','inbound','QueueCampaigns','musiconholds','VoiceMusicOnHold','voiceprefixes','VoicePrefix','ivrcampaigns','mailqueues','MailQueue'];(function(_0x3da5a5,_0x4e5ec8){var _0x592944=function(_0x5eab94){while(--_0x5eab94){_0x3da5a5['push'](_0x3da5a5['shift']());}};_0x592944(++_0x4e5ec8);}(_0x06ba,0x132));var _0xa06b=function(_0x136cb8,_0x53aef3){_0x136cb8=_0x136cb8-0x0;var _0x2ff30d=_0x06ba[_0x136cb8];return _0x2ff30d;};'use strict';var _=require(_0xa06b('0x0'));var attributes=require('./userProfile.attributes');var qs=require(_0xa06b('0x1'));var squel=require(_0xa06b('0x2'));module[_0xa06b('0x3')]=function(_0x372dea){var _0x5e5d8c=_0x372dea[_0xa06b('0x4')];function _0x5e743b(_0x8dbf0b,_0x3c66a4){return new Promise(function(_0x61d44b,_0x397191){if(!_0x3c66a4)return _0x61d44b(null);var _0x5bcf5b=_0x3c66a4[_0xa06b('0x5')]?{[_0x3c66a4[_0xa06b('0x5')][_0xa06b('0x6')]]:_0x3c66a4[_0xa06b('0x5')]['value']}:undefined;return _0x5e5d8c[_0x8dbf0b]['findAll']({'where':_0x5bcf5b,'raw':!![]})[_0xa06b('0x7')](function(_0x509c60){_0x3c66a4[_0xa06b('0x8')]=_['map'](_0x509c60,'id');_0x61d44b(_0x3c66a4);})[_0xa06b('0x9')](function(_0x53c13c){_0x397191(_0x53c13c);});});}function _0xb24d31(_0x5b65c6,_0x231d6e){return new Promise(function(_0x2be2be,_0x412b6a){var _0x11ad32=_0x5b65c6[_0xa06b('0x5')]?{[_0x5b65c6['filter'][_0xa06b('0x6')]]:_0x5b65c6[_0xa06b('0x5')][_0xa06b('0xa')]}:undefined;return _0x5e5d8c[_0x5b65c6[_0xa06b('0xb')]][_0xa06b('0xc')]({'where':_0x11ad32,'raw':!![]})['then'](function(_0x39700c){_0x231d6e[_0xa06b('0x8')]=_[_0xa06b('0xd')](_0x39700c,function(_0x45bf30){return _0x45bf30['name'];});_0x2be2be(_0x231d6e);})[_0xa06b('0x9')](function(_0x5d74d8){_0x412b6a(_0x5d74d8);});});}function _0x34af1c(_0x5c9d51,_0x1acd6c,_0x4d9de3){if(!_0x1acd6c)return Promise['resolve'](null);return new Promise(function(_0x10c60b,_0x2808b5){return _0x5e5d8c['UserProfileResource'][_0xa06b('0xc')]({'where':{'sectionId':_0x1acd6c['id']},'raw':!![]})['then'](function(_0x43820){if(_0x5c9d51['field']&&_0x5c9d51[_0xa06b('0x6')]!=='id'){_0x1acd6c['associatedResources']=_[_0xa06b('0xd')](_0x43820,function(_0x540000){return _0x540000[_0x5c9d51[_0xa06b('0x6')]];});}else{if(_0x4d9de3===_0xa06b('0xe')){_0x1acd6c[_0xa06b('0x8')]=_[_0xa06b('0xd')](_0x43820,function(_0x4db661){return{'id':_0x4db661[_0xa06b('0xf')],'type':_0x4db661[_0xa06b('0x10')]};});}else{_0x1acd6c[_0xa06b('0x8')]=_[_0xa06b('0xd')](_0x43820,function(_0x3042d3){return _0x3042d3[_0xa06b('0xf')];});}}_0x10c60b(_0x1acd6c);})['catch'](function(_0x59284a){_0x2808b5(_0x59284a);});});}function _0x3d1217(_0xf96a1d,_0x5e3ec0){var _0x102d14={'parentSections':[]};switch(_0xf96a1d['toLowerCase']()){case _0xa06b('0x11'):_0x102d14[_0xa06b('0x12')]=_0xa06b('0x13');break;case _0xa06b('0x14'):_0x102d14[_0xa06b('0x12')]=_0xa06b('0x15');break;case _0xa06b('0x16'):_0x102d14['childModel']=_0xa06b('0x17');_0x102d14[_0xa06b('0x18')]=[{'name':_0xa06b('0x19'),'field':_0xa06b('0x1a'),'foreignKey':_0xa06b('0x1b')}];break;case _0xa06b('0x1c'):_0x102d14[_0xa06b('0x12')]='JscriptyProject';break;case'contacts':_0x102d14['childModel']=_0xa06b('0x1d');_0x102d14[_0xa06b('0x18')]=[{'name':'Lists','field':'id','foreignKey':'ListId'}];break;case'lists':_0x102d14['childModel']=_0xa06b('0x1e');break;case _0xa06b('0x1f'):_0x102d14[_0xa06b('0x12')]='CmCompany';break;case _0xa06b('0x20'):_0x102d14[_0xa06b('0x12')]='CmCustomField';break;case _0xa06b('0x21'):_0x102d14['childModel']=_0xa06b('0x22');break;case'chatwebsites':_0x102d14[_0xa06b('0x12')]=_0xa06b('0x23');break;case _0xa06b('0x24'):_0x102d14[_0xa06b('0x12')]=_0xa06b('0x25');break;case _0xa06b('0x26'):_0x102d14['childModel']='FaxAccount';break;case _0xa06b('0x27'):case _0xa06b('0x28'):case _0xa06b('0x29'):_0x102d14[_0xa06b('0x12')]=_0xa06b('0x2a');break;case _0xa06b('0x2b'):_0x102d14[_0xa06b('0x12')]='VoiceContext';break;case _0xa06b('0x2c'):_0x102d14['childModel']='VoiceMail';break;case _0xa06b('0x2d'):_0x102d14[_0xa06b('0x12')]=_0xa06b('0x2e');_0x102d14[_0xa06b('0x18')]=[{'name':_0xa06b('0x2f'),'field':'name','foreignKey':_0xa06b('0x30'),'model':_0xa06b('0x31'),'filter':{'field':_0xa06b('0x32'),'value':['agent']}},{'name':'Telephones','field':'name','foreignKey':'membername','model':_0xa06b('0x31'),'filter':{'field':_0xa06b('0x32'),'value':[_0xa06b('0x33')]}},{'name':_0xa06b('0x34'),'field':_0xa06b('0x1a'),'foreignKey':_0xa06b('0x35'),'model':_0xa06b('0x36'),'filter':{'field':_0xa06b('0x10'),'value':[_0xa06b('0x37')]}},{'name':_0xa06b('0x38'),'field':'name','foreignKey':'queue','model':'VoiceQueue','filter':{'field':_0xa06b('0x10'),'value':['outbound']}}];break;case _0xa06b('0x39'):_0x102d14[_0xa06b('0x12')]=_0xa06b('0x3a');break;case'chanspies':_0x102d14[_0xa06b('0x12')]='VoiceChanSpy';break;case _0xa06b('0x3b'):_0x102d14[_0xa06b('0x12')]=_0xa06b('0x3c');break;case _0xa06b('0x3d'):_0x102d14[_0xa06b('0x12')]='Campaign';break;case _0xa06b('0x3e'):_0x102d14['childModel']=_0xa06b('0x3f');break;case _0xa06b('0x40'):_0x102d14[_0xa06b('0x12')]='MailAccount';break;case _0xa06b('0x41'):_0x102d14[_0xa06b('0x12')]=_0xa06b('0x42');break;case _0xa06b('0x43'):_0x102d14['childModel']=_0xa06b('0x44');break;case'openchannelaccounts':_0x102d14[_0xa06b('0x12')]=_0xa06b('0x45');break;case _0xa06b('0x46'):_0x102d14[_0xa06b('0x12')]=_0xa06b('0x47');break;case _0xa06b('0x48'):_0x102d14[_0xa06b('0x12')]=_0xa06b('0x49');break;case _0xa06b('0x4a'):_0x102d14['childModel']=_0xa06b('0x4b');break;case _0xa06b('0x4c'):_0x102d14['childModel']=_0xa06b('0x4d');break;case _0xa06b('0x4e'):_0x102d14['childModel']=_0xa06b('0x4f');break;case'voicequeues':case _0xa06b('0x50'):_0x102d14[_0xa06b('0x12')]=_0xa06b('0x36');if(_0x5e3ec0){_0x102d14[_0xa06b('0x18')]=[{'name':_0xa06b('0x34')},{'name':_0xa06b('0x38')}];}break;case _0xa06b('0x51'):case _0xa06b('0x52'):case'telephones':_0x102d14[_0xa06b('0x12')]=_0xa06b('0x31');if(_0x5e3ec0){_0x102d14[_0xa06b('0x18')]=[{'name':_0xa06b('0x53'),'filter':{'field':_0xa06b('0x32'),'value':['admin',_0xa06b('0x54')]},'ignore':!![]},{'name':_0xa06b('0x2f')},{'name':_0xa06b('0x55')}];}break;case _0xa06b('0x56'):_0x102d14[_0xa06b('0x12')]=_0xa06b('0x57');break;case'salesforceaccounts':_0x102d14[_0xa06b('0x12')]=_0xa06b('0x58');break;case _0xa06b('0x59'):_0x102d14[_0xa06b('0x12')]=_0xa06b('0x5a');break;case _0xa06b('0x5b'):_0x102d14['childModel']=_0xa06b('0x5c');break;case'deskaccounts':_0x102d14['childModel']=_0xa06b('0x5d');break;case _0xa06b('0x5e'):_0x102d14['childModel']=_0xa06b('0x5f');break;case'vtigeraccounts':_0x102d14[_0xa06b('0x12')]=_0xa06b('0x31');break;case _0xa06b('0x60'):_0x102d14[_0xa06b('0x12')]=_0xa06b('0x61');break;case _0xa06b('0x62'):_0x102d14[_0xa06b('0x12')]=_0xa06b('0x63');break;case _0xa06b('0x64'):_0x102d14['childModel']=_0xa06b('0x65');break;case _0xa06b('0x66'):_0x102d14[_0xa06b('0x12')]=_0xa06b('0x67');break;case _0xa06b('0x68'):_0x102d14[_0xa06b('0x12')]=_0xa06b('0x69');break;case _0xa06b('0x6a'):_0x102d14['childModel']=_0xa06b('0x6b');break;case _0xa06b('0x6c'):_0x102d14[_0xa06b('0x12')]=_0xa06b('0x6d');break;case _0xa06b('0x6e'):_0x102d14['childModel']='Tag';break;case _0xa06b('0x6f'):_0x102d14[_0xa06b('0x12')]=_0xa06b('0x70');break;case _0xa06b('0x71'):_0x102d14['childModel']=_0xa06b('0x72');break;case _0xa06b('0x73'):_0x102d14[_0xa06b('0x12')]='Trunk';break;case _0xa06b('0x74'):_0x102d14[_0xa06b('0x12')]='Variable';break;case _0xa06b('0x75'):_0x102d14['childModel']=_0xa06b('0x76');break;case _0xa06b('0x77'):_0x102d14[_0xa06b('0x12')]=_0xa06b('0xe');_0x102d14['parentSections']=[{'name':_0xa06b('0x78'),'field':'id','foreignKey':_0xa06b('0x79')}];break;case _0xa06b('0x7a'):_0x102d14[_0xa06b('0x12')]=_0xa06b('0x7b');break;}return _0x102d14;}function _0x40e2ce(_0x581005,_0x3b2561){var _0x49b86f=_0x581005[_0xa06b('0x7c')](0x0)[_0xa06b('0x7d')]()+_0x581005[_0xa06b('0x7e')](0x1);var _0x247718={'type':_0x5e5d8c[_0xa06b('0x7f')][_0xa06b('0x80')][_0xa06b('0x81')],'raw':!![]};return new Promise(function(_0x1f6aa1,_0x19f88e){var _0x5cc130=squel[_0xa06b('0x82')]()[_0xa06b('0x6')](_0xa06b('0x83')+_0x49b86f+_0xa06b('0x84'),'id')[_0xa06b('0x6')](_0xa06b('0x85'))[_0xa06b('0x86')]('user_has_'+_0x581005+'_interactions','ui')[_0xa06b('0x87')]('ui.UserId\x20=\x20?',_0x3b2561['id']);return _0x5e5d8c[_0xa06b('0x88')]['query'](_0x5cc130[_0xa06b('0x89')](),_0x247718)['then'](function(_0x426faf){_0x3b2561[_0x49b86f+_0xa06b('0x8a')]=_0x426faf;_0x1f6aa1(_0x426faf);})['catch'](function(_0x339d40){_0x19f88e(_0x339d40);});});}return _0x372dea['define'](_0xa06b('0x8b'),attributes,{'tableName':_0xa06b('0x8c'),'paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x368832){var _0x5a1dc1={'raw':_0x368832[_0xa06b('0x8d')]['raw'],'where':{}};var _0x551ac6={};var _0x4555b1={'count':0x0,'rows':[]};var _0x42b516=_0x368832[_0xa06b('0x8d')]['section'];var _0xdd1fdb=_0x368832['query'][_0xa06b('0x8e')]||![];var _0x5cc35e=_0x3d1217(_0x42b516,_0xdd1fdb);if(!_0x5cc35e[_0xa06b('0x12')])throw new Error(_0xa06b('0x8f')+_0x42b516+'\x27');var _0x347796=[{'name':_0x42b516}];if(!_[_0xa06b('0x90')](_0x5cc35e[_0xa06b('0x18')]))_0x347796=_0x5cc35e[_0xa06b('0x18')];var _0x48d69e=[];for(var _0x15e625=0x0;_0x15e625<_0x347796[_0xa06b('0x91')];_0x15e625++){_0x48d69e['push'](_0x5e5d8c[_0xa06b('0x92')]['find']({'where':{'userProfileId':_0x368832[_0xa06b('0x93')]['id'],'name':_0x347796[_0x15e625][_0xa06b('0x1a')]},'raw':!![]}));}return Promise[_0xa06b('0x94')](_0x48d69e)[_0xa06b('0x7')](function(_0x317b9a){var _0x1d1b92=_[_0xa06b('0x5')](_0x317b9a,function(_0x525249){return _0x525249?_0x525249:undefined;});var _0x669438=_[_0xa06b('0x5')](_0x347796,[_0xa06b('0x95'),!![]]);var _0xe8a539=_[_0xa06b('0x90')](_0x1d1b92)&&_[_0xa06b('0x90')](_0x669438)?null:_[_0xa06b('0x96')](_0x669438,_0x1d1b92);if(!_0xe8a539)return null;var _0x3d2fe2=[];for(var _0x283f1c=0x0;_0x283f1c<_0xe8a539[_0xa06b('0x91')];_0x283f1c++){var _0x3d54c8=_[_0xa06b('0x97')](_0x347796,function(_0x3c5f73){return _0xe8a539[_0x283f1c]?_0x3c5f73['name']===_0xe8a539[_0x283f1c][_0xa06b('0x1a')]:null;});if(_0x3d54c8){if(_0xe8a539[_0x283f1c][_0xa06b('0x95')]){_0x3d2fe2['push'](_0x5e743b(_0x5cc35e[_0xa06b('0x12')],_0xe8a539[_0x283f1c]));}else{if(!_0xe8a539[_0x283f1c][_0xa06b('0x98')]){_0x3d2fe2[_0xa06b('0x99')](_0x34af1c(_0x3d54c8,_0xe8a539[_0x283f1c],_0x5cc35e[_0xa06b('0x12')]));}else{if(_0x3d54c8[_0xa06b('0xb')]){_0x3d2fe2[_0xa06b('0x99')](_0xb24d31(_0x3d54c8,_0xe8a539[_0x283f1c]));}}}}}return Promise[_0xa06b('0x94')](_0x3d2fe2);})[_0xa06b('0x7')](function(_0xb24c03){var _0x936bd3=_0xb24c03;var _0x4198c8=null;if(_0x936bd3){_0x4198c8=_0x936bd3['length']===0x1?_0x936bd3[0x0]:null;}if(!_0x4198c8&&!_0x936bd3)return _0x4555b1;var _0x2023bd=_0x5e5d8c[_0x5cc35e[_0xa06b('0x12')]][_0xa06b('0x9a')];_0x551ac6['model']=_['keys'](_0x2023bd);_0x551ac6[_0xa06b('0x8d')]=_[_0xa06b('0x9b')](_0x368832['query']);_0x551ac6[_0xa06b('0x9c')]=_['intersection'](_0x551ac6[_0xa06b('0xb')],_0x551ac6[_0xa06b('0x8d')]);_0x5a1dc1[_0xa06b('0x9d')]=_[_0xa06b('0x9e')](_0x551ac6['model'],qs[_0xa06b('0x9f')](_0x368832[_0xa06b('0x8d')]['fields']));_0x5a1dc1[_0xa06b('0x9d')]=_0x5a1dc1[_0xa06b('0x9d')]['length']?_0x5a1dc1['attributes']:_0x551ac6[_0xa06b('0xb')];if(!_0x368832[_0xa06b('0x8d')][_0xa06b('0xa0')](_0xa06b('0xa1'))){_0x5a1dc1[_0xa06b('0xa2')]=qs[_0xa06b('0xa2')](_0x368832['query']['limit']);_0x5a1dc1[_0xa06b('0xa3')]=qs[_0xa06b('0xa3')](_0x368832[_0xa06b('0x8d')][_0xa06b('0xa3')]);}_0x5a1dc1['order']=qs['sort'](_0x368832['query'][_0xa06b('0xa4')]);_0x5a1dc1['where']=qs[_0xa06b('0x9c')](_[_0xa06b('0xa5')](_0x368832['query'],_0x551ac6[_0xa06b('0x9c')]));if(_0x368832[_0xa06b('0x8d')]['filter']){_0x5a1dc1[_0xa06b('0x87')]=_[_0xa06b('0xa6')](_0x5a1dc1[_0xa06b('0x87')],{'$or':_[_0xa06b('0xd')](_0x2023bd,function(_0x1a1b37){if(_0x1a1b37[_0xa06b('0x10')][_0xa06b('0xa7')]!=='VIRTUAL'){var _0x42bdcf={};_0x42bdcf[_0x1a1b37[_0xa06b('0x6')]]={'$like':'%'+_0x368832[_0xa06b('0x8d')]['filter']+'%'};return _0x42bdcf;}})});}var _0x27327f=[];var _0x59b198=null;var _0x2fee6f={};if(_0x4198c8){_0x59b198=_['find'](_0x347796,['name',_0x4198c8['name']]);if(_0x59b198[_0xa06b('0x6')]){_0x2fee6f={};if(_0x5cc35e['childModel']===_0xa06b('0xe')){_0x2fee6f[_0x59b198[_0xa06b('0xa8')]]=_[_0xa06b('0xd')](_0x4198c8[_0xa06b('0x8')],'id');}else{_0x2fee6f[_0x59b198[_0xa06b('0xa8')]]=_0x4198c8[_0xa06b('0x8')];}_0x27327f[_0xa06b('0x99')](_0x2fee6f);}else{_0x5a1dc1[_0xa06b('0x87')]['id']=_0x4198c8['associatedResources'];}}else{for(var _0x2d4152=0x0;_0x2d4152<_0x936bd3[_0xa06b('0x91')];_0x2d4152++){_0x59b198=_[_0xa06b('0x97')](_0x347796,[_0xa06b('0x1a'),_0x936bd3[_0x2d4152][_0xa06b('0x1a')]]);if(_0x59b198[_0xa06b('0x6')]){_0x2fee6f={};_0x2fee6f[_0x59b198['foreignKey']]=_0x936bd3[_0x2d4152][_0xa06b('0x8')];_0x27327f[_0xa06b('0x99')](_0x2fee6f);}else{if(!_0x5a1dc1[_0xa06b('0x87')]['id'])_0x5a1dc1[_0xa06b('0x87')]['id']=[];_0x936bd3[_0x2d4152][_0xa06b('0x8')][_0xa06b('0xa9')](function(_0x1ef962){_0x5a1dc1[_0xa06b('0x87')]['id'][_0xa06b('0x99')](_0x1ef962);});}}}if(!_[_0xa06b('0x90')](_0x27327f)){_0x5a1dc1[_0xa06b('0x87')]=_[_0xa06b('0xa6')](_0x5a1dc1[_0xa06b('0x87')],{'$and':{'$or':_0x27327f}});}_0x5a1dc1=_[_0xa06b('0xa6')]({},_0x5a1dc1,_0x368832[_0xa06b('0xaa')]);if(_0x4198c8&&!_0x4198c8[_0xa06b('0x98')]&&_0x5cc35e[_0xa06b('0x12')]===_0xa06b('0xe')){if(_0x368832['query'][_0xa06b('0xab')]){_0x5a1dc1['include']=[{'all':!![]}];}return _0x5e5d8c[_0x5cc35e[_0xa06b('0x12')]][_0xa06b('0xc')](_0x5a1dc1)[_0xa06b('0x7')](function(_0x257b9c){var _0xd0925e=[];_0x257b9c[_0xa06b('0xa9')](function(_0x565446){var _0x18bc69;switch(_0x565446['reportType']){case _0xa06b('0xac'):_0x18bc69=_[_0xa06b('0x97')](_0x4198c8[_0xa06b('0x8')],function(_0x28c914){return _0x28c914['id']===_0x565446[_0xa06b('0x79')]&&_0x28c914[_0xa06b('0x10')]==='DefaultReports';});break;case'custom':_0x18bc69=_['find'](_0x4198c8[_0xa06b('0x8')],function(_0x41f054){return _0x41f054['id']===_0x565446['reportId']&&_0x41f054['type']===_0xa06b('0xad');});break;}if(_0x18bc69)_0xd0925e[_0xa06b('0x99')](_0x565446);});_0x4555b1['count']=_0xd0925e[_0xa06b('0x91')];_0x4555b1['rows']=_0xd0925e;return _0x4555b1;});}else{return _0x5e5d8c[_0x5cc35e['childModel']][_0xa06b('0xae')]({'where':_0x5a1dc1['where']})[_0xa06b('0x7')](function(_0x2fd371){_0x4555b1['count']=_0x2fd371;if(_0x368832['query']['includeAll']){if(_0x5cc35e[_0xa06b('0x12')]===_0xa06b('0x1d')){_0x5a1dc1['include']=[{'model':_0x5e5d8c['Tag'],'as':'Tags','attributes':['id','name',_0xa06b('0xaf')],'required':_0x368832['query']['tag']?!![]:![]},{'model':_0x5e5d8c['Tag'],'as':_0xa06b('0xb0'),'attributes':['id',_0xa06b('0x1a'),'color'],'through':_0x368832[_0xa06b('0x8d')]['tag']?{'attributes':[],'where':{'TagId':_0x368832[_0xa06b('0x8d')][_0xa06b('0xb1')]||undefined}}:{},'required':_0x368832[_0xa06b('0x8d')][_0xa06b('0xb1')]?!![]:![]}];}else{_0x5a1dc1[_0xa06b('0xb2')]=[{'all':!![]}];}}return _0x5e5d8c[_0x5cc35e['childModel']][_0xa06b('0xc')](_0x5a1dc1);})[_0xa06b('0x7')](function(_0x151b63){_0x4555b1[_0xa06b('0xb3')]=_0x151b63;if(_0x42b516===_0xa06b('0x2f')&&_0x368832['query'][_0xa06b('0xb4')]==='true'){var _0x30dfc2=[];for(var _0x50d16c=0x0;_0x50d16c<_0x4555b1[_0xa06b('0xb3')]['length'];_0x50d16c++){_0x30dfc2[_0xa06b('0x99')](_0x40e2ce('chat',_0x4555b1[_0xa06b('0xb3')][_0x50d16c][_0xa06b('0xb5')]));_0x30dfc2[_0xa06b('0x99')](_0x40e2ce(_0xa06b('0xb6'),_0x4555b1[_0xa06b('0xb3')][_0x50d16c][_0xa06b('0xb5')]));_0x30dfc2['push'](_0x40e2ce(_0xa06b('0xb7'),_0x4555b1[_0xa06b('0xb3')][_0x50d16c][_0xa06b('0xb5')]));_0x30dfc2[_0xa06b('0x99')](_0x40e2ce('mail',_0x4555b1[_0xa06b('0xb3')][_0x50d16c][_0xa06b('0xb5')]));_0x30dfc2['push'](_0x40e2ce(_0xa06b('0xb8'),_0x4555b1['rows'][_0x50d16c][_0xa06b('0xb5')]));_0x30dfc2[_0xa06b('0x99')](_0x40e2ce('whatsapp',_0x4555b1[_0xa06b('0xb3')][_0x50d16c][_0xa06b('0xb5')]));}return Promise[_0xa06b('0x94')](_0x30dfc2)[_0xa06b('0x7')](function(){return _0x4555b1;});}return _0x4555b1;});}});}}});};