You need to enable JavaScript to run this app. Salesforce甘特图日期值为空时HTML页显示自定义文本咨询
优惠活动
大模型
产品
解决方案
定价
更多

Salesforce甘特图日期值为空时HTML页显示自定义文本咨询

解决方案

实现思路

通过两层校验避免空日期导致的渲染错误,同时展示自定义提示:

  1. 服务端层面先判断所有依赖的日期字段是否有值,提前拦截空值场景
  2. 前端加异常捕获兜底,避免未知错误直接暴露给用户

修改后完整代码

<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

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.10.16 21:36:06