01.<script type="text/javascript">
02. google.charts.load('current', {
03. 'packages': ['corechart']
04. });
05. google.charts.setOnLoadCallback(drawChart);
06.
07.
08. function drawChart() {
09. var data = google.visualization.arrayToDataTable([
10.
11. ['status_name', 'status_count'],
12.
13.
14.
15. <?php
16. $query = "select status,count(id_data) as count_status from repair_data where date_format(date, '%M')='$month' group by status";
17. $rs = mysqli_query($con, $query);
18. foreach ($rs as $rs_c) {
19. if ($rs_c['status'] == "1") {
20. $status = 'รออนุมัติ';
21. } elseif ($rs_c['status'] == "2") {
22. $status = 'ได้รับการอนุมัติ';
23. } elseif ($rs_c['status'] == "3") {
24. $status = 'กำลังดำเนินการ';
25. }elseif ($rs_c['status'] == "4") {
26. $status = 'ส่งซ่อมนอกสถานที่';
27. }elseif ($rs_c['status'] == "5") {
28. $status = 'สั่งซื้อของทดแทน';
29. }elseif ($rs_c['status'] == "6") {
30. $status = 'ไม่ได้รับการอนุมัติ';
31. } else {
32. $status = '';
33. }
34. echo "['" . $status . "'," . $rs_c['count_status'] . "],";
35. }
36. ?>
37.
38. ]);
39.
40. var options = {
41. title: 'สถานะจำนวนแจ้งซ่อมประจำเดือน <?php echo $printmonth ?>',
42. is3D: true
43. };
44.
45. var chart = new google.visualization.PieChart(document.getElementById('piechart3'));
46.
47. chart.draw(data, options);
48. }
49.</script>
