<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script><script type="text/javascript"> google.charts.load('current', {'packages':['corechart']}); google.charts.setOnLoadCallback(drawVisualization); function drawVisualization() { var data = google.visualization.arrayToDataTable([ ['Username', 'Total Sales'], <?php while($sub_row = mysqli_fetch_array($result2)) { echo "['".$sub_row["date"]."', ".$sub_row["number"]."],"; } ?> ]); var options = { title : 'Month & Yearly Total Sales Values', vAxis: {title: 'Total Sales'}, hAxis: {title: 'Month & Year'}, seriesType: 'bars', series: {5: {type: 'line'}} }; var chart = new google.visualization.ComboChart(document.getElementById('Salesman')); chart.draw(data, options); }</script><?php$con = mysqli_connect('localhost','handsmec_sales','handsmec_sales','handsmec_sales_portal') or die(mysqli_error());$query2 = "SELECT DATE_FORMAT(order_datetime,'%Y') as date, SUM(order_total_after_tax) as number FROM tbl_order where status='Confirmed' and type='PROFORMA INVOICE' GROUP BY DATE_FORMAT(order_datetime,'%Y')";$result2 = mysqli_query($con, $query2);?><div id="Salesman" style="width: 650px; height: 500px;"></div>結果將顯示為附加圖像 我需要成為條形圖的代碼結果將根據年份不同顏色，我嘗試著色：青色，紅色代碼，但它會反映任何解決方案的第一種顏色？？
3 回答
郎朗坤
TA貢獻1921條經驗 獲得超9個贊
這是正確的解決方案。
<script type="text/javascript">
google.charts.load("current", {packages:['corechart']});
google.charts.setOnLoadCallback(drawColumnChart);
function drawColumnChart() {
var data = google.visualization.arrayToDataTable([
['Year', 'Total sales', { role: 'style' }, { role: 'annotation' }],
<?php
for($i=0;$i<$resultCount;$i++){
?>[<?php echo "'".$date[$i]."', ".$number[$i].", '".$color[$i]."' , "."'".$number[$i]."'" ?>],
<?php }
?>
]);
var options = {
title: "Yearly Sales report",
chartArea: {width: '50%'},
legend: { position: "none" },
};
var chart = new google.visualization.ColumnChart(document.getElementById("column-chart"));
chart.draw(data, options);
}
</script>
<?php
if($_SESSION['role'] == "Manager") {
$query2 = "SELECT DATE_FORMAT(order_datetime,'%Y') as date, SUM(order_total_after_tax) as number FROM tbl_order where status='Confirmed' and type='PROFORMA INVOICE' GROUP BY DATE_FORMAT(order_datetime,'%Y')";
$result2 = mysqli_query($con, $query2);
$resultCount=$result2->num_rows;
$color = ['#dc7877','#9cbb73','#9ee2d9','#9f9ee2','#e29eba'];
$date = array();
$number = array();
foreach ($result2 as $peopleData) {
$date[] = $peopleData['date'];
$number[] = $peopleData['number'];
}
?>
<div id="column-chart" style="width: 650px; height: 500px;"></div>
開心每一天1111
TA貢獻1836條經驗 獲得超13個贊
嘗試這個：
https://codepen.io/dichado/pen/qBEyKEL
顏色欄在這里設置了樣式屬性：
["Element", "Density", { role: "style" } ]
從集合 ["Element", "Density","style"]:
["Copper", 8.94, "#b87333"],
["Silver", 10.49, "silver"],
["Gold", 19.30, "gold"],
["Platinum", 21.45, "color: #e5e4e2"]
紅顏莎娜
TA貢獻1842條經驗 獲得超13個贊
以下代碼的輸出您可以使用以下代碼
<script type = "text/javascript">
google.charts.load('current', {packages: ['corechart']});
</script>
<script type="text/javascript">
google.charts.load('current', {'packages':['corechart']});
google.charts.setOnLoadCallback(drawVisualization);
function drawVisualization() {
var data = google.visualization.arrayToDataTable([
['Username', 'Total Sales',{role: 'style'}],
['xyz', 200,'#f44336'],
['tyu', 400,'#e91e63'],
['jhon',100,'#9c27b0']
]);
var options = {
title : 'Month & Yearly Total Sales Values',
vAxis: {title: 'Total Sales'},
hAxis: {title: 'Month & Year'},
seriesType: 'bars',
//colors: ['#009900', '#e0440e']
//series: {5: {type: 'line'}}
};
var chart = new google.visualization.ComboChart(document.getElementById('Salesman'));
chart.draw(data, options);
}
- 3 回答
- 0 關注
- 118 瀏覽
添加回答
舉報
0/150
提交
取消