Untitled

<?php
// Tentukan path yang tepat ke mPDF
$nama_dokumen='PDF'; //Beri nama file PDF hasil.
define('_MPDF_PATH','mpdf60/'); // Tentukan folder dimana anda menyimpan folder mpdf
include(_MPDF_PATH . "mpdf.php"); // Arahkan ke file mpdf.php didalam folder mpdf
$mpdf=new mPDF('utf-8', 'A4', 10.5, 'arial'); // Membuat file mpdf baru

//Memulai proses untuk menyimpan variabel php dan html
ob_start();

?>
<html>
<head>
<script src="js/jquery.min.js" type="text/javascript"></script>
<script src="js/highcharts.js" type="text/javascript"></script>
<script type="text/javascript">

	var chart1; // globally available
$(document).ready(function() {
      chart1 = new Highcharts.Chart({
         chart: {
            renderTo: 'container',
            type: 'column'
         },
         title: {
            text: 'Grafik Presensi Siswa Kelas <?php echo $_GET['kode']; ?> Periode <?php echo $_GET['awal']; ?>  S/d <?php echo $_GET['akhir']; ?> '
         },
		 subtitle: {
         text: 'Semester <?php echo $_GET['semester']; ?> Tahun Ajaran <?php echo $_GET['thn_ajaran']; ?>'
                },
         xAxis: {
            categories: ['Sakit','Izin','Alpha']
         },
         yAxis: {
            title: {
               text: 'TOTAL'
            }
         },
              series:
            [
            <?php
        	include('../config.php');
			if(isset($_GET['Cetak'])){

           	$kd = $_GET['kode'];
			$sms = $_GET['semester'];
			$ta = $_GET['thn_ajaran'];
			$taw = $_GET['awal'];
			$tak = $_GET['akhir'];
			$sql = "SELECT a.semester,a.thn_ajaran,sum(a.ket='Sakit') as Sakit,sum(a.ket='Izin') as Izin,sum(a.ket='Alpha') as Alpha,b.nama_kelas,b.kode from absensi a,tb_kelas b where a.kd_kelas=b.kd_kelas and b.kode like '%$kd' and a.semester like '%$sms' and a.thn_ajaran like '%$ta' and a.tgl_absen>='$taw' and a.tgl_absen<='$tak' group by b.nama_kelas  asc ";
			//echo 'QUERY PERTAMA: '. $sql;
            $query = mysql_query( $sql )  or die(mysql_error());
            while( $ret = mysql_fetch_array( $query ) ){
            	$kls=$ret['nama_kelas'];
                $sql_jumlah   = "SELECT a.semester,a.thn_ajaran,sum(a.ket='Sakit') as Sakit,sum(a.ket='Izin') as Izin,sum(a.ket='Alpha') as Alpha,b.nama_kelas,b.kode from absensi a,tb_kelas b where a.kd_kelas=b.kd_kelas and b.nama_kelas='$kls' and b.kode like '%$kd' and a.semester like '%$sms' and a.thn_ajaran like '%$ta' and a.tgl_absen>='$taw' and a.tgl_absen<='$tak' group by b.nama_kelas  asc";

				// die('QUERY KEDUA: '. $sql_jumlah);
                 $query_jumlah = mysql_query( $sql_jumlah ) or die(mysql_error());
                 while( $data = mysql_fetch_array( $query_jumlah ) ){
                    $S = $data['Sakit'];
					$A = $data['Alpha'];
					$I = $data['Izin'];

                  }
                  ?>
                  {
                      name: '<?php echo $kls; ?>',
                      data: [<?php echo $S; ?>,<?php echo $I; ?>,<?php echo $A; ?>]

                  },

                  <?php }
				  }?>
            ]
      });
   });
</script>
</head>
<body>
		<div id='container'></div>
        <blockquote>
          <p>Mataram,
		  <?php
		  //$tgl=date('d M Y');
		  //echo $tgl;
		  $tgl=date("j");
		  $array_bulan=array(1=>" Januari "," Februari "," Maret "," April "," Mei "," Juni "," Juli "," Agustus "," September "," November "," Desembar ");
		  $bln=$array_bulan[date("n")];
		  $thn =date("Y");
		  echo "" .$tgl  . $bln . $thn;
		  ?><br>
            Koordinator BK	<br>
            <br>
            <br>
            <br>
            Drs. <br>
            Nip :
          </p>
        </blockquote>
</body>
</html>
<?php
$html = ob_get_contents(); //Proses untuk mengambil hasil dari OB..
ob_end_clean();
//Disini dimulai proses convert UTF-8, kalau ingin ISO-8859-1 cukup dengan mengganti $mpdf->WriteHTML($html);
$mpdf->WriteHTML(utf8_encode($html));
$mpdf->Output($nama_dokumen.".pdf" ,'I');
exit;
?>