php chart 多拆线,javascript

我有一个名为total_summary的表，其中包含4个字段-[日期]，[月/年]，[挖泥船]和[驳船量]。

我正在尝试生成一个多条形图，以显示按日期分组的每个挖泥船的总体积。 下面是我编写的用于生成图形的代码：

PHP：

$datelist = "";

$dredgelist = "";

$volumedata = "";

$datearray = "'2019-10-01";

$title = "'Dredging Volume'";

$chartype = "'bar'";

$barcolor = "'rgb(252, 155, 155, 0.5)'";

$x_title = "'Date'";

$yline = "true";

$xline = "false";

$bkcolor = "#F5F5F5";

$sql_query = "SELECT [date], [Dredger], SUM([Barge Volume]) AS 'Dredging Volume' FROM OVERALL_SUMMARY_ORIGINAL

WHERE [Month/Year] in ($datearray) GROUP BY [Date], [Dredger] order by [Date], [Dredger]";

$stmt = sqlsrv_query($conn, $sql_query);

while($row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_NUMERIC)){

$datelabel = $row[0]->format('Y/m/d');

$dredger = $row[1];

$vol = $row[2];

$datelist = $datelist."'".$datelabel."',";

$datelist_2 = trim($datelist,",");

$dredgelist = $dredgelist."'".$dredger."',";

$dredgelist_2 = trim($dredgelist,",");

$volumedata = $volumedata.$vol.",";

$volumedatalist = trim($volumedata,",");

}

?>

Java脚本

/*****first chart********/

var ctx = document.getElementById('myChart2').getContext('2d');

var myChart = new Chart(ctx, {

type:<?php echo $chartype; ?>,

data : {

labels: [<?php echo $datelist_2; ?>],