Postingan lainnya
Menampilkan multi data dengan Chart JS
siang kawan2, saya mau tanya untuk penggunaan Chart JS untuk menampilkan multi data dalam database. saya sudah buat scriptnya, cuma yang muncul hanya di field nya saja. need advice please.
<?php
include "connection.php";
$time=mysql_query("SELECT b.time FROM jem1 a INNER JOIN perhour b ON a.Time_ = b.id where date_ between DATE_ADD(date(now()), INTERVAL -7 DAY) and date(now())");
$data=mysql_query("SELECT a.*, b.time FROM jem1 a INNER JOIN perhour b ON a.Time_ = b.id where date_ between DATE_ADD(date(now()), INTERVAL -7 DAY) and date(now())");
//$time1 = array();
//$mwhdel = array();$mwhrec = array();$mvardel = array();
//while($d=mysql_fetch_array($data)) {
//$time[] = $b['time'];
//$mwhdel[] = $d['MWHDel']; $mwhrec[] = $d['MWHRec']; $mvardel[] = $d['MVARDel'];
//}
?>
<script type="text/javascript">
var ctx = document.getElementById( "jem1Chart" );
ctx.height = 100;
var myChart = new Chart( ctx, {
type: 'line',
data: {
labels: [<?php while ($t = mysql_fetch_array($time)) { echo '"' . $t['time'] . '",'; } ?>],
datasets: [
{
label: "MWH Del",
borderColor: "rgba(0,0,0,.09)",
borderWidth: "1",
data: [<?php while ($d = mysql_fetch_array($data)) { echo '"' . $d['MWHDel'] . '",'; } ?>],
backgroundColor: "rgba(0,0,0,.07)",
},
{
label: "MWH Rec",
borderColor: "rgba(0,0,0,.09)",
borderWidth: "1",
data: [<?php while ($d = mysql_fetch_array($data)) { echo '"' . $d['MWHRec'] . '",'; } ?>],
backgroundColor: "rgba(0,0,0,.07)",
},
{
label: "MVAR Del",
borderColor: "rgba(0, 123, 255, 0.9)",
borderWidth: "1",
backgroundColor: "rgba(0, 123, 255, 0.5)",
data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
pointHighlightStroke: "rgba(26,179,148,1)",
},
{
label: "MVAR Rec",
borderColor: "rgba(0, 123, 255, 0.9)",
borderWidth: "1",
backgroundColor: "rgba(0, 123, 255, 0.5)",
data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
pointHighlightStroke: "rgba(26,179,148,1)",
},
{
label: "PF Del",
borderColor: "rgba(0, 123, 255, 0.9)",
borderWidth: "1",
backgroundColor: "rgba(0, 123, 255, 0.5)",
data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
pointHighlightStroke: "rgba(26,179,148,1)",
},
{
label: "MW",
borderColor: "rgba(0, 123, 255, 0.9)",
borderWidth: "1",
backgroundColor: "rgba(0, 123, 255, 0.5)",
data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
pointHighlightStroke: "rgba(26,179,148,1)",
},
{
label: "MVAR",
borderColor: "rgba(0, 123, 255, 0.9)",
borderWidth: "1",
backgroundColor: "rgba(0, 123, 255, 0.5)",
data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
pointHighlightStroke: "rgba(26,179,148,1)",
},
{
label: "F",
borderColor: "rgba(0, 123, 255, 0.9)",
borderWidth: "1",
backgroundColor: "rgba(0, 123, 255, 0.5)",
data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
pointHighlightStroke: "rgba(26,179,148,1)",
},
{
label: "KV",
borderColor: "rgba(0, 123, 255, 0.9)",
borderWidth: "1",
backgroundColor: "rgba(0, 123, 255, 0.5)",
data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
pointHighlightStroke: "rgba(26,179,148,1)",
},
{
label: "MWH",
borderColor: "rgba(0, 123, 255, 0.9)",
borderWidth: "1",
backgroundColor: "rgba(0, 123, 255, 0.5)",
data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
pointHighlightStroke: "rgba(26,179,148,1)",
},
{
label: "KV (Electrical Package)",
borderColor: "rgba(0, 123, 255, 0.9)",
borderWidth: "1",
backgroundColor: "rgba(0, 123, 255, 0.5)",
data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
pointHighlightStroke: "rgba(26,179,148,1)",
},
{
label: "MW (Electrical Package)",
borderColor: "rgba(0, 123, 255, 0.9)",
borderWidth: "1",
backgroundColor: "rgba(0, 123, 255, 0.5)",
data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
pointHighlightStroke: "rgba(26,179,148,1)",
},
{
label: "MVAR (Electrical Package)",
borderColor: "rgba(0, 123, 255, 0.9)",
borderWidth: "1",
backgroundColor: "rgba(0, 123, 255, 0.5)",
data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
pointHighlightStroke: "rgba(26,179,148,1)",
},
{
label: "PF",
borderColor: "rgba(0, 123, 255, 0.9)",
borderWidth: "1",
backgroundColor: "rgba(0, 123, 255, 0.5)",
data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
pointHighlightStroke: "rgba(26,179,148,1)",
},
{
label: "FREQ",
borderColor: "rgba(0, 123, 255, 0.9)",
borderWidth: "1",
backgroundColor: "rgba(0, 123, 255, 0.5)",
data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
pointHighlightStroke: "rgba(26,179,148,1)",
},
{
label: "MWH Counter",
borderColor: "rgba(0, 123, 255, 0.9)",
borderWidth: "1",
backgroundColor: "rgba(0, 123, 255, 0.5)",
data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
pointHighlightStroke: "rgba(26,179,148,1)",
},
{
label: "MVAR Counter",
borderColor: "rgba(0, 123, 255, 0.9)",
borderWidth: "1",
backgroundColor: "rgba(0, 123, 255, 0.5)",
data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
pointHighlightStroke: "rgba(26,179,148,1)",
},
{
label: "PTLH",
borderColor: "rgba(0, 123, 255, 0.9)",
borderWidth: "1",
backgroundColor: "rgba(0, 123, 255, 0.5)",
data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
pointHighlightStroke: "rgba(26,179,148,1)",
},
{
label: "BSLH",
borderColor: "rgba(0, 123, 255, 0.9)",
borderWidth: "1",
backgroundColor: "rgba(0, 123, 255, 0.5)",
data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
pointHighlightStroke: "rgba(26,179,148,1)",
},
{
label: "PKLH",
borderColor: "rgba(0, 123, 255, 0.9)",
borderWidth: "1",
backgroundColor: "rgba(0, 123, 255, 0.5)",
data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
pointHighlightStroke: "rgba(26,179,148,1)",
},
{
label: "BPSH",
borderColor: "rgba(0, 123, 255, 0.9)",
borderWidth: "1",
backgroundColor: "rgba(0, 123, 255, 0.5)",
data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
pointHighlightStroke: "rgba(26,179,148,1)",
},
{
label: "ATS",
borderColor: "rgba(0, 123, 255, 0.9)",
borderWidth: "1",
backgroundColor: "rgba(0, 123, 255, 0.5)",
data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
pointHighlightStroke: "rgba(26,179,148,1)",
},
{
label: "SS",
borderColor: "rgba(0, 123, 255, 0.9)",
borderWidth: "1",
backgroundColor: "rgba(0, 123, 255, 0.5)",
data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
pointHighlightStroke: "rgba(26,179,148,1)",
},
{
label: "NS",
borderColor: "rgba(0, 123, 255, 0.9)",
borderWidth: "1",
backgroundColor: "rgba(0, 123, 255, 0.5)",
data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
pointHighlightStroke: "rgba(26,179,148,1)",
},
{
label: "FS",
borderColor: "rgba(0, 123, 255, 0.9)",
borderWidth: "1",
backgroundColor: "rgba(0, 123, 255, 0.5)",
data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
pointHighlightStroke: "rgba(26,179,148,1)",
},
{
label: "TRIP",
borderColor: "rgba(0, 123, 255, 0.9)",
borderWidth: "1",
backgroundColor: "rgba(0, 123, 255, 0.5)",
data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
pointHighlightStroke: "rgba(26,179,148,1)",
},
{
label: "Peak Time",
borderColor: "rgba(0, 123, 255, 0.9)",
borderWidth: "1",
backgroundColor: "rgba(0, 123, 255, 0.5)",
data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
pointHighlightStroke: "rgba(26,179,148,1)",
},
{
label: "Peak Numst",
borderColor: "rgba(0, 123, 255, 0.9)",
borderWidth: "1",
backgroundColor: "rgba(0, 123, 255, 0.5)",
data: [<?php echo '"' . $d['MVARDel'] . '",'; ?>],
pointHighlightStroke: "rgba(26,179,148,1)",
}
]
},
options: {
responsive: true,
tooltips: {
mode: 'index',
intersect: false
},
hover: {
mode: 'nearest',
intersect: true
}
}
} );
</script>
0
Belum ada Jawaban. Jadi yang pertama Jawaban
Login untuk ikut Jawaban