grafik_

<?php
include 'config/konek.php';
echo " <font color=#000>
    <b>Filter Tanggal Berdasarkan ";
echo "<form method=POST action=?module=graph>
    Tanggal Mulai : <input type='text' name='tanggal' size='10'>
    Tanggal Akhir : </b><input type='text' name='tanggal_2' size='10'>
     <input type='submit' name='cari' value='Cari'>
     </form><br>";

$query = "select count(*) as Berhasil from plan where Terlaksana = 'Berhasil'";
$hasil = mysql_query($query);
$data  = mysql_fetch_array($hasil);
$Berhasil= $data['Berhasil'];

// mencari jumlah kegagalan dari database
$query = "select count(*) as Gagal from plan where Terlaksana != 'Berhasil'";
$hasil = mysql_query($query);
$data  = mysql_fetch_array($hasil);
$Gagal = $data['Gagal'];

// menghitung total training
$total = $Berhasil+ $Gagal;

// menghitung presentase berhasil dan gagal
if ($total == 0) {
    echo "Tidak ada Pelatihan yang terjadi";
}else {
$keberhasilan = $Berhasil/$total * 100;
$kegagalan = $Gagal/$total * 100;
}

?>
<html>
    <head>
        <!-- 1. Add these JavaScript inclusions in the head of your page -->
        <script type="text/javascript" src="js/jquery.min.js"></script>
        <script type="text/javascript" src="js/highcharts.js"></script>

        <!-- 1a) Optional: add a theme file -->
        <!--
            <script type="text/javascript" src="../js/themes/gray.js"></script>
        -->

        <!-- 1b) Optional: the exporting module -->
        <script type="text/javascript" src="js/modules/exporting.js"></script>


        <!-- 2. Add the JavaScript to initialize the chart on document ready -->
        <script type="text/javascript">

            var chart;
            $(document).ready(function() {
                chart = new Highcharts.Chart({
                    chart: {
                        renderTo: 'container',
                        zoomType: 'xy'
                    },
                    title: {
                        text: 'Laporan Grafik pelatihan'
                    },
                    subtitle: {
                        text: 'LMC'
                    },
                    xAxis: [{
                        categories: ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun',
                            'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec']
                    }],
                    yAxis: [{
                        labels: {
                            formatter: function() {
                                return this.value +'';
                            },
                            style: {
                                color: '#6cb3ea'
                            }
                        },
                        title: {
                            text: 'Persentase training(%)',
                            style: {
                                color: '#6cb3ea'
                            }
                        }
                    }],
                    tooltip: {
                        formatter: function() {
                            return ''+
                                this.x +': '+ this.y +
                                (this.series.name == 'Presentase' ? '' : '%');
                        }
                    },
                    legend: {
                        layout: 'vertical',
                        align: 'left',
                        x: 100,
                        verticalAlign: 'top',
                        y: 100,
                        floating: true,
                        backgroundColor: '#FFFFFF'
                    },
                    series: [{
                        name: 'Berhasil Dilaksanakan',
                        color: '#4572A7',
                        type: 'column',
                        data: [<?php echo $keberhasilan;?>]

                    }, {
                        name: 'Gagal Dilaksanakan',
                        color: '#eaff00',
                        type: 'column',
                        data: [<?php echo $kegagalan;?>]
                    }]
                });


            });

        </script>
        </script>
    </head>
    <body>
<script src="js/highcharts.js"></script>
<script src="js/modules/exporting.js"></script>

<div id="container" style="min-width: 400px; height: 400px; margin: 0 auto"></div>

    </body>
</html>
<?php

echo "<b> <h3> Jumlah Pelatihan saat ini : $total pelatihan</h3></b>";
?>