Salesforce甘特图日期值为空时HTML页显示自定义文本咨询
解决方案
实现思路
通过两层校验避免空日期导致的渲染错误,同时展示自定义提示:
- 服务端层面先判断所有依赖的日期字段是否有值,提前拦截空值场景
- 前端加异常捕获兜底,避免未知错误直接暴露给用户
修改后完整代码
<apex:page standardController="Project__c"> <!-- 若页面已引入SLDS样式可删除该行 --> <apex:slds /> <apex:form > <html> <head> <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script> <script type="text/javascript"> google.charts.load('current', {'packages':['gantt']}); google.charts.setOnLoadCallback(drawChart); function daysToMilliseconds(days) { return days * 24 * 60 * 60 * 1000; } function drawChart() { // 收集所有依赖的日期字段值 const requiredDates = [ "{!Project__c.GLI_Planned_Date__c}", "{!Project__c.GLI_Actual_Date__c}", "{!Project__c.REG_Planned_Date__c}", "{!Project__c.REG_Actual_Date__c}", "{!Project__c.UAT_Planned_Date__c}", "{!Project__c.UAT_Actual_Date__c}", "{!Project__c.STP_Planned_Date__c}", "{!Project__c.STP_Actual_Date__c}", "{!Project__c.ARC_Planned_Date__c}", "{!Project__c.ARC_Actual_Date__c}" ]; // 校验是否存在空日期 const hasEmptyDate = requiredDates.some(dateStr => dateStr.trim() === ''); if (hasEmptyDate) { document.getElementById('error_banner').style.display = 'block'; document.getElementById('chart_div').style.display = 'none'; return; } try { var data = new google.visualization.DataTable(); data.addColumn('string', 'Task ID'); data.addColumn('string', 'Task Name'); data.addColumn('date', 'Start Date'); data.addColumn('date', 'End Date'); data.addColumn('number', 'Duration'); data.addColumn('number', 'Percent Complete'); data.addColumn('string', 'Dependencies'); data.addRows([ ['Research', 'Find sources', new Date("{!Project__c.GLI_Planned_Date__c}"), new Date("{!Project__c.GLI_Actual_Date__c}"), null, 100, null], ['Write', 'Write paper', new Date("{!Project__c.REG_Planned_Date__c}"), new Date("{!Project__c.REG_Actual_Date__c}"), daysToMilliseconds(3), 25, 'null'], ['Cite', 'Create bibliography', new Date("{!Project__c.UAT_Planned_Date__c}"), new Date("{!Project__c.UAT_Actual_Date__c}"), daysToMilliseconds(1), 20, 'null'], ['Complete', 'Hand in paper', new Date("{!Project__c.STP_Planned_Date__c}"), new Date("{!Project__c.STP_Actual_Date__c}"), daysToMilliseconds(1), 0, 'null'], ['Outline', 'Outline paper', new Date("{!Project__c.ARC_Planned_Date__c}"), new Date("{!Project__c.ARC_Actual_Date__c}"), daysToMilliseconds(1), 100, 'null'] ]); var options = { height: 400, gantt: { trackHeight: 30 } }; var chart = new google.visualization.Gantt(document.getElementById('chart_div')); chart.draw(data, options); } catch (e) { // 兜底异常捕获,所有渲染错误都显示自定义提示 document.getElementById('error_banner').style.display = 'block'; document.getElementById('chart_div').style.display = 'none'; } } </script> </head> <body class="slds-scope"> <!-- 错误提示横幅,默认隐藏 --> <div id="error_banner" role="alert" style="display: none;margin: 1rem 0;padding: 0.75rem 1rem;background: #ba0517;color: #fff;border-radius: 4px;"> <h2>Required date values are not available</h2> </div> <div id="chart_div"></div> </body> </html> </apex:form> </apex:page>
关键修改说明
- 新增默认隐藏的错误提示横幅,已经加了行内基础样式,不需要依赖SLDS也能正常显示,你可以自行调整样式匹配页面风格
- 提前校验所有依赖的日期字段是否为空,只要存在空值就直接显示提示、终止甘特图渲染逻辑
- 新增try-catch块做兜底,即使出现日期格式错误、Google Charts加载异常等其他问题,也不会把原生报错暴露给用户
- 补充了原代码缺失的
daysToMilliseconds工具函数实现,避免该函数未定义导致的额外错误
内容的提问来源于stack exchange,提问作者SFDCUser
相关产品推荐
相关产品推荐

