Untitled

<?php

include("../config/db.php");
require_once '../dompdf/autoload.inc.php';

global $connection;
// Reference the Dompdf namespace
use Dompdf\Dompdf;

// Instantiate and use the dompdf class
$dompdf = new Dompdf();


ob_start();
if (isset($_POST['download'])) {
    $q_kelas    = $_POST['pilih_kelas'];
    $q_sesi     = $_POST['sel_sesi'];
    $q_mula     = $_POST['date'];
    $q_akhir    = $_POST['date2'];
    $q_bahagian = $_POST['jbahagian'];
    $step = '+1 day';
	$output_format = 'Y-m-d';
	$html = '';

    ?>


	<style>


		table.resultTable,
		table.resultTable th,
		table.resultTable td {
			border: 1px solid black;
			border-collapse: collapse;

		}

		table.resultTable th {
			width: 1cm;
			height: 4cm;
			padding: 1mm;
			text-align: center;

		}

		table.resultTable td {

			width: 0.1cm;
			height:2cm;
			padding: 1mm;
			text-align: center;

		}

		.page-break  { display: block; page-break-after: always; }

	</style>

	<body>
	<?php
	$start = strtotime($q_mula);
	$end = strtotime($q_akhir);

	while( $start <= $end ) {
		$curr = date("D", $start);
		if ($curr == 'Mon' || $curr == 'Tue' || $curr == 'Wed' || $curr == 'Thu' || $curr == 'Fri') {
			$dates[] = date($output_format, $start);
		}
		$start = strtotime($step, $start);
	}

	//Pages Setup
	$dayPerPage = 5;
	$totalItem = count($dates);
	$totalPage = ceil($totalItem/$dayPerPage);
	$curPage = 1;

	//Extra Day Column
	if (count($dates) < ($dayPerPage * $totalPage)) {
		$extraCol = ($dayPerPage * $totalPage) - count($dates);
		$extraStart = 1;
		while( $extraStart <= $extraCol ) {
			$dates[] = date($output_format, $start);
			$start = strtotime($step, $start);
			$extraStart += 1;
		}
	}
	while ($curPage <= $totalPage) {
		$res = mysqli_query($connection, "select * from sesi WHERE ids='$q_sesi'  ");
		while($row=mysqli_fetch_array($res)) {
			$sesi= $row['sesi'];
		}
		$html .= '<table width="775" border="0" cellspacing="0" cellpadding="0">
		  <tbody>
			<tr>
			  <td align="center" valign="middle"><img src="../images/jata.png" style="height=3.5cm; width:3.5cm"></td>
			</tr>
			<tr>
			  <td align="center" valign="middle">INSTITUT LATIHAN JABATAN TENAGA MANUSIA (ILJTM) KUALA LUMPUR</td>
			</tr>
			<tr>
			  <td align="center" valign="middle">KEMENTERIAN SUMBER MANUSIA</td>
			</tr>
			<tr>
			  <td align="center" valign="middle">DAFTAR KEHADIRAN PELAJAR (INDIVIDU)</td>
			</tr>
			<tr>
			  <td>&nbsp;</td>
			</tr>
		  </tbody>
		</table>

		<table width="775" border="0" cellspacing="0" cellpadding="0">
		  <tbody>
			<tr>
			  <td colspan="6" align="left" valign="middle">INSTITUT : INSTITUT LATIHAN PERINDUSTRIAN KUALA LUMPUR</td>
			</tr>
			<tr>
			  <td align="left" valign="middle">SESI LATIHAN</td>
			  <td align="left" valign="middle">: ' . $sesi . '</td>
			  <td align="left" valign="middle">DARI</td>
			  <td align="left" valign="middle">: ' . $q_mula . '</td>
			  <td align="left" valign="middle">HINGGA</td>
			  <td align="left" valign="middle">: ' . $q_akhir . '</td>
			</tr>
			<tr>
			  <td colspan="6" align="left" valign="middle">&nbsp;</td>
			</tr>
		  </tbody>
		</table>
		<hr>
		<table width="775" border="0" cellspacing="0" cellpadding="0">
		  <tbody>
			<tr>
			  <td>BAHAGIAN</td>
			  <td align="left" valign="middle">: INSTITUT LATIHAN PERINDUSTRIAN KUALA LUMPUR</td>
			</tr>
			<tr>
			  <td>KOD KURSUS</td>
			  <td align="left" valign="middle">: INSTITUT LATIHAN PERINDUSTRIAN KUALA LUMPUR</td>
			</tr>
			<tr>
			  <td>SESI KEMASUKAN</td>
			  <td align="left" valign="middle">: INSTITUT LATIHAN PERINDUSTRIAN KUALA LUMPUR</td>
			</tr>
			<tr>
			  <td>&nbsp;</td>
			  <td>&nbsp;</td>
			</tr>
		  </tbody>
		</table>

		<table  border="1" cellspacing="0" cellpadding="0"     class="resultTable">

			<tr>
				<th rowspan="2" style="font-size:10">Nama</th>
				<th rowspan="2" style="font-size:10">NDP</th>
				<td id="header_tarikh" style="font-size:10">Tarikh</td>';
		$offset = (($curPage - 1) * $dayPerPage) - 1;
		$dayCol = 1;
		while( $dayCol <= 5 ) {
			$html .= "<td colspan='7'>";
			$html .= $dates[$offset + $dayCol];
			$html .= "</td>";
			$dayCol += 1;
		}
		$html .= '</tr>
		<tr>
			<td>SLOT</td>';

		$dayCol = 1;
		while( $dayCol <= 5 ) {
			$totalSlot = 1;
			while( $totalSlot <= 7 ) {
				$html .= "<td style='font-size:10'>";
				$html .= $totalSlot;
				$html .= "</td>";
				$totalSlot += 1;
			}
			$dayCol += 1;
		}

		$html .= '</tr>';

		$q_pelajar ="SELECT  id_pelajar,nama_pelajar,no_ndp FROM pelajar
					 WHERE sesi='$q_sesi'
					 AND kelas='$q_kelas'
					  AND bahagian='$q_bahagian'";


		$pelajar= mysqli_query($connection, $q_pelajar);
		while($row=mysqli_fetch_array($pelajar)){

			$id_pelajar=$row["id_pelajar"];
			$nama_pelajar=$row["nama_pelajar"];
			$no_ndp=$row["no_ndp"];

			$html .= '<tr>';
			$html .= '<td style="font-size:9" >';
			$html .= $nama_pelajar;
			$html .= '</td>';
			$html .= '<td style="font-size:9" >';
			$html .= $no_ndp;
			$html .= '</td>';
			$html .= '<td >';
			$html .= '</td>';

			//Kedatangan
			$dayCol = 1;
			while( $dayCol <= 5 ) {
				$totalSlot = 1;
				$curDate = $dates[$offset + $dayCol];
				while( $totalSlot <= 7 ) {
					//get kedatangan on date and slot
					$kehadiran_query="SELECT `ke`.*, `j`.`slot` FROM `ke` INNER JOIN `jadual` AS `j` ON `ke`.`idj` = `j`.`idj`WHERE id_p='$id_pelajar' AND tarikh = '$curDate' AND slot = '$totalSlot'";
					$Kehadiran= mysqli_query($connection, $kehadiran_query);
					if (mysqli_num_rows($Kehadiran) != 0) {
						while($row=mysqli_fetch_array($Kehadiran)){
							$attendance = $row["kehadiran"];
							$html .= '<td style="font-size:9">';
							$html .= $attendance;
							$html .= '</td>';
						}
					} else {
						$html .= '<td style="font-size:9">';
						$html .= '</td>';
					}
					$totalSlot += 1;
				}
				$dayCol += 1;
			}
			//end kedatangan

			$html .= "</tr>";
		}
		$html .= "</table>";
		if ($curPage < $totalPage) {
			$html .= '<div class="page-break"></div>';
		}
		$curPage += 1;
	}
}

echo $html;

$html=ob_get_clean();
$dompdf = new Dompdf();
$dompdf->loadHtml($html);
// (Optional) Setup the paper size and orientation
$dompdf->setPaper('A4', 'landscape');


// Render the HTML as PDF
$dompdf->render();
// Output the generated PDF (1 = download and 0 = preview)
$dompdf->stream(" laporan rasmi",array("Attachment"=>1));
header("Location: ./index.php");
?>