PHP开发的供应链分析报表模块在企业资源计划（ERP）系统中的应用

<?php // 连接数据库$host = 'localhost';$dbname = 'your_database_name';$username = 'your_username';$password = 'your_password';$dsn = "mysql:host=$host;dbname=$dbname;charset=utf8mb4";$options = [    PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,    PDO::ATTR_DEFAULT_FETCH_MODE =&gt; PDO::FETCH_ASSOC,    PDO::ATTR_EMULATE_PREPARES =&gt; false,];try {    $pdo = new PDO($dsn, $username, $password, $options);} catch (PDOException $e) {    exit($e-&gt;getMessage());}// 查询销售额数据$statement = $pdo-&gt;prepare('SELECT date, SUM(amount) AS total_sales FROM sales GROUP BY date');$statement-&gt;execute();$salesData = $statement-&gt;fetchAll();// 展示销售额数据foreach ($salesData as $row) {    echo $row['date'] . ': ' . $row['total_sales'] . ' 元' . PHP_EOL;}// 关闭数据库连接$pdo = null;?&gt;

    <meta charset="utf-8"><title>销售额报表</title><script src="https://cdn.jsdelivr.net/npm/echarts@5.0.2/dist/echarts.min.js"></script><div id="chart" style="width: 800px; height: 400px;"></div>    <script>        // 销售额数据        var salesData = <?php echo json_encode($salesData); ?>;        // 提取日期和销售额        var dates = salesData.map(function (item) {            return item.date;        });        var amounts = salesData.map(function (item) {            return item.total_sales;        });        // 绘制柱状图        var chart = echarts.init(document.getElementById('chart'));        var option = {            xAxis: {                type: 'category',                data: dates            },            yAxis: {                type: 'value'            },            series: [{                data: amounts,                type: 'bar'            }]        };        chart.setOption(option);    </script>