Pada pembuatan statistik perbandingan pasukan ini data statistik mengacu pada data hasil simulasi yang telah tersimpan pada database. adapun yang di tampilkan yaitu
A. Data Team, berisi nilai awal infantri, awal kavelery, awal artelery, awal total
B. Data Intel, berisi nilai awa infantri, awal kavelery, awal artelery, awal total
adapun script dalam pembuatan statistik tersebut adalah sebagai berikut:
<script>
<!DOCTYPE HTML>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Highcharts Example</title>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js"></script>
<script type="text/javascript">
var chart1; // globally available
$(document).ready(function() {
chart1 = new Highcharts.Chart({
chart: {
renderTo: 'container',
type: 'column'
},
title: {
text: 'Statistik Perbandingan Pasukan'
},
xAxis: {
categories: ['Infantri', 'Kaveleri', 'Arteleri', 'Total'],
title: {
text: null
}
},
yAxis: {
min: 0,
title: {
text: 'units',
align: 'high'
},
labels: {
overflow: 'justify'
}
},
tooltip: {
valueSuffix: ' units'
},
plotOptions: {
bar: {
dataLabels: {
enabled: true
}
}
},
legend: {
layout: 'vertical',
align: 'right',
verticalAlign: 'top',
x: -100,
y: 100,
floating: true,
borderWidth: 1,
backgroundColor: '#FFFFFF',
shadow: true
},
credits: {
enabled: false
},
series:
[
<?php
include('conn.php');
$sql = "SELECT idtimbiru FROM tim_biru";
$sql = "SELECT idtimmerah FROM tim_merah";
$query = mysql_query( $sql ) or die(mysql_error());
while( $ret = mysql_fetch_array( $query ) ){
$idtimbiru=$ret['idtimbiru'];
$sql_awal_inf = "SELECT awal_inf FROM tim_biru ";
$sql_awal_kav = "SELECT awal_kav FROM tim_biru ";
$sql_awal_art = "SELECT awal_art FROM tim_biru ";
$sql_awal_tot = "SELECT awal_tot FROM tim_biru ";
$idtimmerah=$ret['idtimmerah'];
$sql_awal_inf_merah = "SELECT awal_inf FROM tim_merah ";
$sql_awal_kav_merah = "SELECT awal_kav FROM tim_merah ";
$sql_awal_art_merah = "SELECT awal_art FROM tim_merah ";
$sql_awal_tot_merah = "SELECT awal_tot FROM tim_merah ";
$query_awal_inf = mysql_query( $sql_awal_inf ) or die(mysql_error());
$query_awal_kav = mysql_query( $sql_awal_kav ) or die(mysql_error());
$query_awal_art = mysql_query( $sql_awal_art ) or die(mysql_error());
$query_awal_tot = mysql_query( $sql_awal_tot ) or die(mysql_error());
$query_awal_inf_merah = mysql_query( $sql_awal_inf_merah ) or die(mysql_error());
$query_awal_kav_merah = mysql_query( $sql_awal_kav_merah ) or die(mysql_error());
$query_awal_art_merah = mysql_query( $sql_awal_art_merah ) or die(mysql_error());
$query_awal_tot_merah = mysql_query( $sql_awal_tot_merah ) or die(mysql_error());
while( $data = mysql_fetch_array( $query_awal_inf ) ){
$awal_inf = $data['awal_inf'];
}
while( $data = mysql_fetch_array( $query_awal_kav ) ){
$awal_kav = $data['awal_kav'];
}
while( $data = mysql_fetch_array( $query_awal_art ) ){
$awal_art = $data['awal_art'];
}
while( $data = mysql_fetch_array( $query_awal_tot ) ){
$awal_tot = $data['awal_tot'];
}
while( $data = mysql_fetch_array( $query_awal_inf_merah ) ){
$awal_inf_merah = $data['awal_inf'];
}
while( $data = mysql_fetch_array( $query_awal_kav_merah ) ){
$awal_kav_merah = $data['awal_kav'];
}
while( $data = mysql_fetch_array( $query_awal_art_merah ) ){
$awal_art_merah = $data['awal_art'];
}
while( $data = mysql_fetch_array( $query_awal_tot_merah ) ){
$awal_tot_merah = $data['awal_tot'];
}
?>
{
name: 'Data Team',
data: [<?php echo $awal_inf; ?> , <?php echo $awal_kav; ?> , <?php echo $awal_art; ?>, <?php echo $awal_tot; ?>]
}, {
name: 'Data Intel',
data: [<?php echo $awal_inf_merah; ?> , <?php echo $awal_kav_merah; ?> , <?php echo $awal_art_merah; ?>, <?php echo $awal_tot_merah; ?>]
}
<?php } ?>
]
});
});
</script>
</head>
<body>
<script type="text/javascript" src="./js/modules/highcharts.js"></script>
<script type="text/javascript" src="./js/modules/data.js"></script>
<script type="text/javascript" src="./js/modules/exporting.js"></script>
<link href="style-table.css" rel="stylesheet" type="text/css" media="screen" />
<meta charset="UTF-8">
<title>Statistik Perbandingan Pasukan - Battlefield Decision Support System</title>
<link rel="stylesheet" href="css/style.css" type="text/css">
</head>
<body>
<div id="header">
<a href="index.html" class="logo"><img src="images/logo2.png" alt=""></a>
<ul>
<li>
<a href="statistik.php">Statistik</a>
</li>
<li class="selected">
<a href="Sisa_Pasukan.php">Statistik Perbandingan Pasukan Pasukan</a>
</li>
</ul>
</div>
<div id="body">
<div class="content">
<div id="container" style="min-width: 400px; height: 400px; margin: 0 auto"></div>
<?php
include "conn.php";
$query=mysql_query("select * from tim_biru order by idtimbiru desc limit 0,5");
?>
<p> </p>
<table id="datatable" class="datatable" width="61%" align="center">
<thead>
<tr>
<p align="center">Data Team</p>
<th width="24%">Awal infantri</th>
<th width="24%">Awal kavelery</th>
<th width="24%">Awal artelery</th>
<th width="24%">Awal total</th>
</tr>
</thead>
<tbody>
<?php
while($row=mysql_fetch_array($query)){
?>
<tr>
<td><?php echo $row['awal_inf'];?></td>
<td><?php echo $row['awal_kav'];?></td>
<td><?php echo $row['awal_art'];?></td>
<td><?php echo $row['awal_tot'];?></td>
</tr>
<?php
}
?>
<?php
include "conn.php";
$query=mysql_query("select * from tim_merah order by idtimmerah desc limit 0,5");
?>
<p> </p>
<table id="datatable" class="datatable" width="61%" align="center">
<thead>
<tr>
<p align="center">Data Intel</p>
<th width="24%">Awal infantri</th>
<th width="24%">Awal kavelery</th>
<th width="24%">Awal artelery</th>
<th width="24%">Awal total</th>
</tr>
</thead>
<tbody>
<?php
while($row=mysql_fetch_array($query)){
?>
<tr>
<td><?php echo $row['awal_inf'];?></td>
<td><?php echo $row['awal_kav'];?></td>
<td><?php echo $row['awal_art'];?></td>
<td><?php echo $row['awal_tot'];?></td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
<div id="footer">
<div>
<p>
© Copyright 2013. Battlefield DSS Team - D4 TKJMD BATCH 6
</p>
</div>
</div>
</body>
</html>
</script>
Tidak ada komentar:
Posting Komentar