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 _0x5a13=['exports','models','filter','field','value','findAll','catch','model','associatedResources','map','name','resolve','UserProfileResource','then','AnalyticExtractedReport','type','resourceId','toLowerCase','squareprojects','childModel','odbc','SquareOdbc','SquareRecording','SquareProjects','projectName','projects','contacts','CmContact','Lists','ListId','lists','companies','CmCompany','globalcustomfields','CmCustomField','chatqueues','ChatWebsite','faxaccounts','FaxAccount','outboundroutes','VoiceContext','voicemails','VoiceMail','voicerecordings','Agents','membername','User','role','Telephones','VoiceQueues','queue','VoiceQueue','QueueCampaigns','chanspies','voiceprefixes','VoicePrefix','ivrcampaigns','mailqueues','MailQueue','mailaccounts','MailAccount','MailSubstatus','openchannelqueues','openchannelaccounts','smsqueues','SmsQueue','SmsAccount','whatsappaccounts','teams','Team','voicequeues','parentSections','agents','telephones','admin','user','zendeskaccounts','ZendeskAccount','SalesforceAccount','FreshdeskAccount','sugarcrmaccounts','DeskAccount','zohoaccounts','ZohoAccount','vtigeraccounts','cannedanswers','CannedAnswer','dispositions','Disposition','customdashboards','Dashboard','intervals','Pause','Schedule','sounds','Sound','Tag','templates','Template','triggers','Trigger','trunks','Trunk','Variable','plugins','Plugin','extractedreports','Reports','reportId','metrics','AnalyticMetric','charAt','toUpperCase','slice','Sequelize','QueryTypes','SELECT','select','InteractionId','ui.createdAt','user_has_','_interactions','where','ui.UserId\x20=\x20?','sequelize','toString','OpenTabs','define','UserProfile','../../components/parsers/qs','query','raw','section','Invalid\x20section\x20\x27','isEmpty','length','UserProfileSection','find','params','all','ignore','push','rawAttributes','keys','filters','intersection','attributes','fields','hasOwnProperty','nolimit','limit','offset','order','sort','pick','key','VIRTUAL','foreignKey','merge','options','autoAssociation','include','forEach','DefaultReports','custom','CustomReports','count','rows','ids','customSorting','extraQueryConditions','Tags','tag','ThroughTags','color','openTabs','dataValues','sms','openchannel','whatsapp','lodash','squel'];(function(_0x4b2cc6,_0x29ef43){var _0x3e0b08=function(_0x3b4131){while(--_0x3b4131){_0x4b2cc6['push'](_0x4b2cc6['shift']());}};_0x3e0b08(++_0x29ef43);}(_0x5a13,0xb4));var _0x35a1=function(_0x4cc660,_0x31eb3f){_0x4cc660=_0x4cc660-0x0;var _0x172267=_0x5a13[_0x4cc660];return _0x172267;};'use strict';var _=require(_0x35a1('0x0'));var attributes=require('./userProfile.attributes');var squel=require(_0x35a1('0x1'));module[_0x35a1('0x2')]=function(_0x34914e){var _0x18ad7b=_0x34914e[_0x35a1('0x3')];function _0x2bbbcb(_0x26a201,_0x3dcf17){return new Promise(function(_0x2d1522,_0x197d42){if(!_0x3dcf17)return _0x2d1522(null);var _0x2b8e24=_0x3dcf17[_0x35a1('0x4')]?{[_0x3dcf17[_0x35a1('0x4')][_0x35a1('0x5')]]:_0x3dcf17['filter'][_0x35a1('0x6')]}:undefined;return _0x18ad7b[_0x26a201][_0x35a1('0x7')]({'where':_0x2b8e24,'raw':!![]})['then'](function(_0x4e5af5){_0x3dcf17['associatedResources']=_['map'](_0x4e5af5,'id');_0x2d1522(_0x3dcf17);})[_0x35a1('0x8')](function(_0x1a307a){_0x197d42(_0x1a307a);});});}function _0x5b3ea0(_0x59dc44,_0x44c8dc){return new Promise(function(_0x28e2ed,_0x829616){var _0xc19e0=_0x59dc44[_0x35a1('0x4')]?{[_0x59dc44[_0x35a1('0x4')]['field']]:_0x59dc44[_0x35a1('0x4')][_0x35a1('0x6')]}:undefined;return _0x18ad7b[_0x59dc44[_0x35a1('0x9')]][_0x35a1('0x7')]({'where':_0xc19e0,'raw':!![]})['then'](function(_0x15beb1){_0x44c8dc[_0x35a1('0xa')]=_[_0x35a1('0xb')](_0x15beb1,function(_0x5ead27){return _0x5ead27[_0x35a1('0xc')];});_0x28e2ed(_0x44c8dc);})[_0x35a1('0x8')](function(_0x27a599){_0x829616(_0x27a599);});});}function _0x2fc8e2(_0x29d44a,_0x54e2ef,_0x26ad0e){if(!_0x54e2ef)return Promise[_0x35a1('0xd')](null);return new Promise(function(_0x2da5b5,_0x1cf6b4){return _0x18ad7b[_0x35a1('0xe')]['findAll']({'where':{'sectionId':_0x54e2ef['id']},'raw':!![]})[_0x35a1('0xf')](function(_0x46206c){if(_0x29d44a['field']&&_0x29d44a[_0x35a1('0x5')]!=='id'){_0x54e2ef['associatedResources']=_[_0x35a1('0xb')](_0x46206c,function(_0x1dc095){return _0x1dc095[_0x29d44a[_0x35a1('0x5')]];});}else{if(_0x26ad0e===_0x35a1('0x10')){_0x54e2ef[_0x35a1('0xa')]=_['map'](_0x46206c,function(_0x32c634){return{'id':_0x32c634['resourceId'],'type':_0x32c634[_0x35a1('0x11')]};});}else{_0x54e2ef[_0x35a1('0xa')]=_[_0x35a1('0xb')](_0x46206c,function(_0x1a6fc0){return _0x1a6fc0[_0x35a1('0x12')];});}}_0x2da5b5(_0x54e2ef);})[_0x35a1('0x8')](function(_0x551721){_0x1cf6b4(_0x551721);});});}function _0x3337c2(_0x4b265a,_0x10798b){var _0x3c40b3={'parentSections':[]};switch(_0x4b265a[_0x35a1('0x13')]()){case _0x35a1('0x14'):_0x3c40b3[_0x35a1('0x15')]='SquareProject';break;case _0x35a1('0x16'):_0x3c40b3[_0x35a1('0x15')]=_0x35a1('0x17');break;case'squarerecordings':_0x3c40b3[_0x35a1('0x15')]=_0x35a1('0x18');_0x3c40b3['parentSections']=[{'name':_0x35a1('0x19'),'field':_0x35a1('0xc'),'foreignKey':_0x35a1('0x1a')}];break;case _0x35a1('0x1b'):_0x3c40b3[_0x35a1('0x15')]='JscriptyProject';break;case _0x35a1('0x1c'):_0x3c40b3[_0x35a1('0x15')]=_0x35a1('0x1d');_0x3c40b3['parentSections']=[{'name':_0x35a1('0x1e'),'field':'id','foreignKey':_0x35a1('0x1f')}];break;case _0x35a1('0x20'):_0x3c40b3[_0x35a1('0x15')]='CmList';break;case _0x35a1('0x21'):_0x3c40b3['childModel']=_0x35a1('0x22');break;case _0x35a1('0x23'):_0x3c40b3[_0x35a1('0x15')]=_0x35a1('0x24');break;case _0x35a1('0x25'):_0x3c40b3['childModel']='ChatQueue';break;case'chatwebsites':_0x3c40b3[_0x35a1('0x15')]=_0x35a1('0x26');break;case'faxqueues':_0x3c40b3['childModel']='FaxQueue';break;case _0x35a1('0x27'):_0x3c40b3[_0x35a1('0x15')]=_0x35a1('0x28');break;case'inboundroutes':case'internalroutes':case _0x35a1('0x29'):_0x3c40b3[_0x35a1('0x15')]='VoiceExtension';break;case'contexts':_0x3c40b3[_0x35a1('0x15')]=_0x35a1('0x2a');break;case _0x35a1('0x2b'):_0x3c40b3[_0x35a1('0x15')]=_0x35a1('0x2c');break;case _0x35a1('0x2d'):_0x3c40b3[_0x35a1('0x15')]='VoiceRecording';_0x3c40b3['parentSections']=[{'name':_0x35a1('0x2e'),'field':'name','foreignKey':_0x35a1('0x2f'),'model':_0x35a1('0x30'),'filter':{'field':_0x35a1('0x31'),'value':['agent']}},{'name':_0x35a1('0x32'),'field':_0x35a1('0xc'),'foreignKey':'membername','model':_0x35a1('0x30'),'filter':{'field':_0x35a1('0x31'),'value':['telephone']}},{'name':_0x35a1('0x33'),'field':_0x35a1('0xc'),'foreignKey':_0x35a1('0x34'),'model':_0x35a1('0x35'),'filter':{'field':_0x35a1('0x11'),'value':['inbound']}},{'name':_0x35a1('0x36'),'field':'name','foreignKey':_0x35a1('0x34'),'model':'VoiceQueue','filter':{'field':_0x35a1('0x11'),'value':['outbound']}}];break;case'musiconholds':_0x3c40b3[_0x35a1('0x15')]='VoiceMusicOnHold';break;case _0x35a1('0x37'):_0x3c40b3[_0x35a1('0x15')]='VoiceChanSpy';break;case _0x35a1('0x38'):_0x3c40b3[_0x35a1('0x15')]=_0x35a1('0x39');break;case _0x35a1('0x3a'):_0x3c40b3['childModel']='Campaign';break;case _0x35a1('0x3b'):_0x3c40b3['childModel']=_0x35a1('0x3c');break;case _0x35a1('0x3d'):_0x3c40b3['childModel']=_0x35a1('0x3e');break;case'mailsubstatuses':_0x3c40b3[_0x35a1('0x15')]=_0x35a1('0x3f');break;case _0x35a1('0x40'):_0x3c40b3[_0x35a1('0x15')]='OpenchannelQueue';break;case _0x35a1('0x41'):_0x3c40b3[_0x35a1('0x15')]='OpenchannelAccount';break;case _0x35a1('0x42'):_0x3c40b3['childModel']=_0x35a1('0x43');break;case'smsaccounts':_0x3c40b3[_0x35a1('0x15')]=_0x35a1('0x44');break;case'whatsappqueues':_0x3c40b3[_0x35a1('0x15')]='WhatsappQueue';break;case _0x35a1('0x45'):_0x3c40b3[_0x35a1('0x15')]='WhatsappAccount';break;case _0x35a1('0x46'):_0x3c40b3[_0x35a1('0x15')]=_0x35a1('0x47');break;case _0x35a1('0x48'):case'queuecampaigns':_0x3c40b3[_0x35a1('0x15')]=_0x35a1('0x35');if(_0x10798b){_0x3c40b3[_0x35a1('0x49')]=[{'name':_0x35a1('0x33')},{'name':_0x35a1('0x36')}];}break;case'users':case _0x35a1('0x4a'):case _0x35a1('0x4b'):_0x3c40b3['childModel']=_0x35a1('0x30');if(_0x10798b){_0x3c40b3[_0x35a1('0x49')]=[{'name':'Users','filter':{'field':_0x35a1('0x31'),'value':[_0x35a1('0x4c'),_0x35a1('0x4d')]},'ignore':!![]},{'name':_0x35a1('0x2e')},{'name':_0x35a1('0x32')}];}break;case _0x35a1('0x4e'):_0x3c40b3[_0x35a1('0x15')]=_0x35a1('0x4f');break;case'salesforceaccounts':_0x3c40b3[_0x35a1('0x15')]=_0x35a1('0x50');break;case'freshdeskaccounts':_0x3c40b3[_0x35a1('0x15')]=_0x35a1('0x51');break;case _0x35a1('0x52'):_0x3c40b3['childModel']='SugarcrmAccount';break;case'deskaccounts':_0x3c40b3['childModel']=_0x35a1('0x53');break;case _0x35a1('0x54'):_0x3c40b3[_0x35a1('0x15')]=_0x35a1('0x55');break;case _0x35a1('0x56'):_0x3c40b3[_0x35a1('0x15')]='User';break;case _0x35a1('0x57'):_0x3c40b3[_0x35a1('0x15')]=_0x35a1('0x58');break;case _0x35a1('0x59'):_0x3c40b3[_0x35a1('0x15')]=_0x35a1('0x5a');break;case _0x35a1('0x5b'):_0x3c40b3[_0x35a1('0x15')]=_0x35a1('0x5c');break;case _0x35a1('0x5d'):_0x3c40b3[_0x35a1('0x15')]='Interval';break;case'pauses':_0x3c40b3[_0x35a1('0x15')]=_0x35a1('0x5e');break;case'scheduler':_0x3c40b3[_0x35a1('0x15')]=_0x35a1('0x5f');break;case _0x35a1('0x60'):_0x3c40b3['childModel']=_0x35a1('0x61');break;case'tags':_0x3c40b3[_0x35a1('0x15')]=_0x35a1('0x62');break;case _0x35a1('0x63'):_0x3c40b3[_0x35a1('0x15')]=_0x35a1('0x64');break;case _0x35a1('0x65'):_0x3c40b3['childModel']=_0x35a1('0x66');break;case _0x35a1('0x67'):_0x3c40b3[_0x35a1('0x15')]=_0x35a1('0x68');break;case'variables':_0x3c40b3['childModel']=_0x35a1('0x69');break;case _0x35a1('0x6a'):_0x3c40b3[_0x35a1('0x15')]=_0x35a1('0x6b');break;case _0x35a1('0x6c'):_0x3c40b3[_0x35a1('0x15')]=_0x35a1('0x10');_0x3c40b3[_0x35a1('0x49')]=[{'name':_0x35a1('0x6d'),'field':'id','foreignKey':_0x35a1('0x6e')}];break;case _0x35a1('0x6f'):_0x3c40b3[_0x35a1('0x15')]=_0x35a1('0x70');break;}return _0x3c40b3;}function _0x5846f2(_0x4f58f8,_0x537b87){var _0x5da359=_0x4f58f8[_0x35a1('0x71')](0x0)[_0x35a1('0x72')]()+_0x4f58f8[_0x35a1('0x73')](0x1);var _0x507045={'type':_0x18ad7b[_0x35a1('0x74')][_0x35a1('0x75')][_0x35a1('0x76')],'raw':!![]};return new Promise(function(_0x5236fe,_0x193c9b){var _0x1d9412=squel[_0x35a1('0x77')]()[_0x35a1('0x5')]('ui.'+_0x5da359+_0x35a1('0x78'),'id')[_0x35a1('0x5')](_0x35a1('0x79'))['from'](_0x35a1('0x7a')+_0x4f58f8+_0x35a1('0x7b'),'ui')[_0x35a1('0x7c')](_0x35a1('0x7d'),_0x537b87['id']);return _0x18ad7b[_0x35a1('0x7e')]['query'](_0x1d9412[_0x35a1('0x7f')](),_0x507045)[_0x35a1('0xf')](function(_0x4f705f){_0x537b87[_0x5da359+_0x35a1('0x80')]=_0x4f705f;_0x5236fe(_0x4f705f);})[_0x35a1('0x8')](function(_0x549764){_0x193c9b(_0x549764);});});}return _0x34914e[_0x35a1('0x81')](_0x35a1('0x82'),attributes,{'tableName':'user_profiles','paranoid':![],'indexes':[],'timestamps':!![],'classMethods':{'getResources':function(_0x2922f6){var _0x582760=require(_0x35a1('0x83'));var _0xf9ead1={'raw':_0x2922f6[_0x35a1('0x84')][_0x35a1('0x85')],'where':{}};var _0x3e50d7={};var _0x3bb82b={'count':0x0,'rows':[]};var _0x50591a=_0x2922f6[_0x35a1('0x84')][_0x35a1('0x86')];var _0x5cd225=_0x2922f6[_0x35a1('0x84')]['mergeResources']||![];var _0xf0237d=_0x3337c2(_0x50591a,_0x5cd225);if(!_0xf0237d[_0x35a1('0x15')])throw new Error(_0x35a1('0x87')+_0x50591a+'\x27');var _0x48a9d1=[{'name':_0x50591a}];if(!_[_0x35a1('0x88')](_0xf0237d[_0x35a1('0x49')]))_0x48a9d1=_0xf0237d['parentSections'];var _0x58f6d8=[];for(var _0xc1691f=0x0;_0xc1691f<_0x48a9d1[_0x35a1('0x89')];_0xc1691f++){_0x58f6d8['push'](_0x18ad7b[_0x35a1('0x8a')][_0x35a1('0x8b')]({'where':{'userProfileId':_0x2922f6[_0x35a1('0x8c')]['id'],'name':_0x48a9d1[_0xc1691f][_0x35a1('0xc')]},'raw':!![]}));}return Promise[_0x35a1('0x8d')](_0x58f6d8)['then'](function(_0x87d1e7){var _0x5cd1e4=_[_0x35a1('0x4')](_0x87d1e7,function(_0x7eac84){return _0x7eac84?_0x7eac84:undefined;});var _0x5f060a=_[_0x35a1('0x4')](_0x48a9d1,[_0x35a1('0x8e'),!![]]);var _0xc38344=_[_0x35a1('0x88')](_0x5cd1e4)&&_[_0x35a1('0x88')](_0x5f060a)?null:_['union'](_0x5f060a,_0x5cd1e4);if(!_0xc38344)return null;var _0xee4a20=[];for(var _0x35a281=0x0;_0x35a281<_0xc38344[_0x35a1('0x89')];_0x35a281++){var _0x544d46=_[_0x35a1('0x8b')](_0x48a9d1,function(_0x23eb35){return _0xc38344[_0x35a281]?_0x23eb35[_0x35a1('0xc')]===_0xc38344[_0x35a281]['name']:null;});if(_0x544d46){if(_0xc38344[_0x35a281][_0x35a1('0x8e')]){_0xee4a20[_0x35a1('0x8f')](_0x2bbbcb(_0xf0237d[_0x35a1('0x15')],_0xc38344[_0x35a281]));}else{if(!_0xc38344[_0x35a281]['autoAssociation']){_0xee4a20[_0x35a1('0x8f')](_0x2fc8e2(_0x544d46,_0xc38344[_0x35a281],_0xf0237d[_0x35a1('0x15')]));}else{if(_0x544d46[_0x35a1('0x9')]){_0xee4a20[_0x35a1('0x8f')](_0x5b3ea0(_0x544d46,_0xc38344[_0x35a281]));}}}}}return Promise[_0x35a1('0x8d')](_0xee4a20);})[_0x35a1('0xf')](function(_0x2278fa){var _0x26491f=_0x2278fa;var _0x427713=null;if(_0x26491f){_0x427713=_0x26491f[_0x35a1('0x89')]===0x1?_0x26491f[0x0]:null;}if(!_0x427713&&!_0x26491f)return _0x3bb82b;var _0x464192=_0x18ad7b[_0xf0237d[_0x35a1('0x15')]][_0x35a1('0x90')];_0x3e50d7[_0x35a1('0x9')]=_[_0x35a1('0x91')](_0x464192);_0x3e50d7[_0x35a1('0x84')]=_[_0x35a1('0x91')](_0x2922f6[_0x35a1('0x84')]);_0x3e50d7[_0x35a1('0x92')]=_[_0x35a1('0x93')](_0x3e50d7['model'],_0x3e50d7[_0x35a1('0x84')]);_0xf9ead1[_0x35a1('0x94')]=_[_0x35a1('0x93')](_0x3e50d7[_0x35a1('0x9')],_0x582760[_0x35a1('0x95')](_0x2922f6[_0x35a1('0x84')]['fields']));_0xf9ead1['attributes']=_0xf9ead1[_0x35a1('0x94')][_0x35a1('0x89')]?_0xf9ead1[_0x35a1('0x94')]:_0x3e50d7[_0x35a1('0x9')];if(!_0x2922f6[_0x35a1('0x84')][_0x35a1('0x96')](_0x35a1('0x97'))){_0xf9ead1[_0x35a1('0x98')]=_0x582760[_0x35a1('0x98')](_0x2922f6['query'][_0x35a1('0x98')]);_0xf9ead1[_0x35a1('0x99')]=_0x582760[_0x35a1('0x99')](_0x2922f6[_0x35a1('0x84')][_0x35a1('0x99')]);}_0xf9ead1[_0x35a1('0x9a')]=_0x582760[_0x35a1('0x9b')](_0x2922f6[_0x35a1('0x84')][_0x35a1('0x9b')]);_0xf9ead1[_0x35a1('0x7c')]=_0x582760[_0x35a1('0x92')](_[_0x35a1('0x9c')](_0x2922f6[_0x35a1('0x84')],_0x3e50d7[_0x35a1('0x92')]));if(_0x2922f6[_0x35a1('0x84')][_0x35a1('0x4')]){_0xf9ead1[_0x35a1('0x7c')]=_['merge'](_0xf9ead1[_0x35a1('0x7c')],{'$or':_[_0x35a1('0xb')](_0x464192,function(_0x3dc03f){if(_0x3dc03f['type'][_0x35a1('0x9d')]!==_0x35a1('0x9e')){var _0x4744ae={};_0x4744ae[_0x3dc03f[_0x35a1('0x5')]]={'$like':'%'+_0x2922f6['query'][_0x35a1('0x4')]+'%'};return _0x4744ae;}})});}var _0x3a6bdf=[];var _0x360104=null;var _0x2db4cb={};if(_0x427713){_0x360104=_[_0x35a1('0x8b')](_0x48a9d1,[_0x35a1('0xc'),_0x427713[_0x35a1('0xc')]]);if(_0x360104['field']){_0x2db4cb={};if(_0xf0237d[_0x35a1('0x15')]===_0x35a1('0x10')){_0x2db4cb[_0x360104[_0x35a1('0x9f')]]=_[_0x35a1('0xb')](_0x427713['associatedResources'],'id');}else{_0x2db4cb[_0x360104['foreignKey']]=_0x427713['associatedResources'];}_0x3a6bdf[_0x35a1('0x8f')](_0x2db4cb);}else{_0xf9ead1['where']['id']=_0x427713[_0x35a1('0xa')];}}else{for(var _0x3d5f1c=0x0;_0x3d5f1c<_0x26491f[_0x35a1('0x89')];_0x3d5f1c++){_0x360104=_[_0x35a1('0x8b')](_0x48a9d1,[_0x35a1('0xc'),_0x26491f[_0x3d5f1c][_0x35a1('0xc')]]);if(_0x360104[_0x35a1('0x5')]){_0x2db4cb={};_0x2db4cb[_0x360104[_0x35a1('0x9f')]]=_0x26491f[_0x3d5f1c][_0x35a1('0xa')];_0x3a6bdf[_0x35a1('0x8f')](_0x2db4cb);}else{if(!_0xf9ead1['where']['id'])_0xf9ead1[_0x35a1('0x7c')]['id']=[];_0x26491f[_0x3d5f1c][_0x35a1('0xa')]['forEach'](function(_0x985024){_0xf9ead1['where']['id']['push'](_0x985024);});}}}if(!_[_0x35a1('0x88')](_0x3a6bdf)){_0xf9ead1[_0x35a1('0x7c')]=_[_0x35a1('0xa0')](_0xf9ead1['where'],{'$and':{'$or':_0x3a6bdf}});}_0xf9ead1=_[_0x35a1('0xa0')]({},_0xf9ead1,_0x2922f6[_0x35a1('0xa1')]);if(_0x427713&&!_0x427713[_0x35a1('0xa2')]&&_0xf0237d[_0x35a1('0x15')]==='AnalyticExtractedReport'){if(_0x2922f6[_0x35a1('0x84')]['includeAll']){_0xf9ead1[_0x35a1('0xa3')]=[{'all':!![]}];}return _0x18ad7b[_0xf0237d[_0x35a1('0x15')]][_0x35a1('0x7')](_0xf9ead1)[_0x35a1('0xf')](function(_0x45bf9b){var _0x116d73=[];_0x45bf9b[_0x35a1('0xa4')](function(_0xf8d46b){var _0x5304ea;switch(_0xf8d46b['reportType']){case'default':_0x5304ea=_['find'](_0x427713[_0x35a1('0xa')],function(_0x26aa8c){return _0x26aa8c['id']===_0xf8d46b[_0x35a1('0x6e')]&&_0x26aa8c['type']===_0x35a1('0xa5');});break;case _0x35a1('0xa6'):_0x5304ea=_[_0x35a1('0x8b')](_0x427713['associatedResources'],function(_0x54904f){return _0x54904f['id']===_0xf8d46b[_0x35a1('0x6e')]&&_0x54904f[_0x35a1('0x11')]===_0x35a1('0xa7');});break;}if(_0x5304ea)_0x116d73[_0x35a1('0x8f')](_0xf8d46b);});_0x3bb82b[_0x35a1('0xa8')]=_0x116d73[_0x35a1('0x89')];_0x3bb82b[_0x35a1('0xa9')]=_0x116d73;return _0x3bb82b;});}else{if(!_[_0x35a1('0x88')](_0x2922f6[_0x35a1('0x84')][_0x35a1('0xaa')])){_0xf9ead1[_0x35a1('0x7c')]['id']=_0xf9ead1['where']['id']?_[_0x35a1('0x93')](_0xf9ead1['where']['id'],_0x2922f6[_0x35a1('0x84')]['ids']):_0x2922f6['query'][_0x35a1('0xaa')];if(_0x2922f6[_0x35a1('0x84')][_0x35a1('0xab')]){_0xf9ead1['order']=_0x2922f6[_0x35a1('0x84')]['customSorting'];}}if(_0x2922f6['query'][_0x35a1('0xac')]){_0xf9ead1[_0x35a1('0x7c')]=_[_0x35a1('0xa0')](_0xf9ead1[_0x35a1('0x7c')],{'$and':_0x2922f6[_0x35a1('0x84')]['extraQueryConditions']});}return _0x18ad7b[_0xf0237d[_0x35a1('0x15')]]['count']({'where':_0xf9ead1[_0x35a1('0x7c')]})[_0x35a1('0xf')](function(_0x15e646){_0x3bb82b[_0x35a1('0xa8')]=_0x15e646;if(_0x2922f6[_0x35a1('0x84')]['includeAll']){if(_0xf0237d['childModel']===_0x35a1('0x1d')){_0xf9ead1[_0x35a1('0xa3')]=[{'model':_0x18ad7b[_0x35a1('0x62')],'as':_0x35a1('0xad'),'attributes':['id',_0x35a1('0xc'),'color'],'required':_0x2922f6['query'][_0x35a1('0xae')]?!![]:![]},{'model':_0x18ad7b[_0x35a1('0x62')],'as':_0x35a1('0xaf'),'attributes':['id',_0x35a1('0xc'),_0x35a1('0xb0')],'through':_0x2922f6[_0x35a1('0x84')]['tag']?{'attributes':[],'where':{'TagId':_0x2922f6[_0x35a1('0x84')][_0x35a1('0xae')]||undefined}}:{},'required':_0x2922f6[_0x35a1('0x84')][_0x35a1('0xae')]?!![]:![]}];}else{_0xf9ead1[_0x35a1('0xa3')]=[{'all':!![]}];}}return _0x18ad7b[_0xf0237d[_0x35a1('0x15')]][_0x35a1('0x7')](_0xf9ead1);})[_0x35a1('0xf')](function(_0x5bfd60){_0x3bb82b[_0x35a1('0xa9')]=_0x5bfd60;if(_0x50591a===_0x35a1('0x2e')&&_0x2922f6['query'][_0x35a1('0xb1')]==='true'){var _0x46f719=[];for(var _0x350f83=0x0;_0x350f83<_0x3bb82b[_0x35a1('0xa9')][_0x35a1('0x89')];_0x350f83++){_0x46f719[_0x35a1('0x8f')](_0x5846f2('chat',_0x3bb82b['rows'][_0x350f83][_0x35a1('0xb2')]));_0x46f719[_0x35a1('0x8f')](_0x5846f2(_0x35a1('0xb3'),_0x3bb82b[_0x35a1('0xa9')][_0x350f83][_0x35a1('0xb2')]));_0x46f719[_0x35a1('0x8f')](_0x5846f2('fax',_0x3bb82b['rows'][_0x350f83][_0x35a1('0xb2')]));_0x46f719[_0x35a1('0x8f')](_0x5846f2('mail',_0x3bb82b[_0x35a1('0xa9')][_0x350f83][_0x35a1('0xb2')]));_0x46f719[_0x35a1('0x8f')](_0x5846f2(_0x35a1('0xb4'),_0x3bb82b[_0x35a1('0xa9')][_0x350f83][_0x35a1('0xb2')]));_0x46f719['push'](_0x5846f2(_0x35a1('0xb5'),_0x3bb82b[_0x35a1('0xa9')][_0x350f83]['dataValues']));}return Promise['all'](_0x46f719)[_0x35a1('0xf')](function(){return _0x3bb82b;});}return _0x3bb82b;});}});}}});};