<?php
define('FPDF_FONTPATH', 'font/');
require('mc_table.php');

session_start(); 
if(!$_SESSION['logged'])
	$_SESSION['kp'];
	$_SESSION['nama'];
	$_SESSION['kodsek'];
	$_SESSION['sekolah'];
	$_SESSION['logged'] = TRUE; 

 //Connect to your database
 include_once "../include/config1.php";
 $curYear = date('Y');

//Set page A4 default Landscape orientation
$pdf=new PDF_MC_Table('L');
//$pdf->Open();
$pdf->AddPage();

//set initial y axis position per page
$y_axis_initial = 50; // mula table header BIL
$y_axis = 72;  // mula table header data

// PRINT HEADER NAMA PPD
$pdf->SetFont('helvetica', 'B', 12);
$pdf->SetX(270);
$pdf->Cell(15,4,'SULIT', 0, 0, 'R', 0);

$pdf->Image('/home/ktefores/public_html/SSO/galeri/uploads/'.$_SESSION['kp'].'.jpg',12,6,12);
//$pdf->Image('/home/ktefores/public_html/SSO/images/jata.png',12,6,20);
$pdf->Image('/home/ktefores/public_html/SSO/images/ktefh-icon.png',250,8,15);


$pdf->SetFont('helvetica', 'B', 13);
$pdf->SetY(10);
$pdf->Cell(290,0,'LAPORAN PEMANTAUAN KECERIAAN KELAS-KELAS TAHUN : '. $curYear, 0, 0, 'C', 0);

$pdf->SetFont('helvetica', 'B', 12);
$pdf->Cell(275,4,"KOLEJ TINGKATAN ENAM FOREST HEIGHTS", 0, 1, 'C', 0);
$pdf->SetFont('helvetica', 'B', 11);
$pdf->Cell(275,4,"Jalan Forest heights 4/2 Taman Dusun Setia 70100, Seremban, NEGERI SEMBILAN", 0, 1, 'C', 0);
$pdf->SetFont('helvetica', 'B', 9);
$pdf->Cell(275,4,"TEL : 06-7633951, FAKS : 06-7633952 Laman Web : http://ktefores.net", 0, 1, 'C', 0);

//Select table recordsource to show in your data

//$res=mysql_query("SELECT * FROM TMUR ORDER BY ID DESC", $link);
//$rowA = mysql_fetch_array($res);

$pdf->SetY(30);
$pdf->Cell(100,0,'NAMA PEGAWAI : '. $_SESSION['nama'], 0, 0, 'L', 0);
$pdf->SetX(120);
//$pdf->Cell(100,0,'MINGGU : '. $rowA['MGU'], 0, 0, 'L', 0);

$pdf->SetFont('helvetica', 'B', 11);
$pdf->SetY(34);
$str = "MARKAH KECERIAAN KELAS-KELAS TAHUN : $curYear"; 
$pdf->Cell(267,8, "$str" , 1, 1, 'C', 0);


//print column titles for the actual page <!----- MS 1 SAHAJA
$pdf->SetFont('Arial', 'B', 9);
$pdf->SetY($y_axis_initial);

$pdf->SetXY(10, 42);
$pdf->MultiCell(7, 4, " \nBil\n", 1,'C');

$pdf->SetXY(17, 42);
$pdf->MultiCell(30, 4, "\nKELAS\n",1,'C',0);

$pdf->SetXY(47, 42);
$pdf->MultiCell(20, 4, "\nK1\n",1,'C',0);

$pdf->SetXY(67, 42);
$pdf->Multicell(20,4," \nK2\n",1,'C',0);

$pdf->SetXY(87, 42);
$pdf->Multicell(20,4," \nK3\n",1,'C',0);

$pdf->SetXY(107, 42);
$pdf->Multicell(20,4," \nK4\n",1,'C',0);

$pdf->SetXY(127, 42);
$pdf->MultiCell(20, 4, "\nK5\n",1,'C',0);

$pdf->SetXY(147, 42);
$pdf->Multicell(20,4," \nK6\n",1,'C',0);

$pdf->SetXY(167, 42);
$pdf->Multicell(20,4," \nK7\n",1,'C',0);

$pdf->SetXY(187, 42);
$pdf->Multicell(20,4," \nK8\n",1,'C',0);

$pdf->SetXY(207, 42);
$pdf->Multicell(20,4," \nK9\n",1,'C',0);

$pdf->SetXY(227, 42);
$pdf->Multicell(20,4," \nK10\n",1,'C',0);

$pdf->SetXY(247, 42);
$pdf->Multicell(30,4," \nJUMLAH\n",1,'C',0);


//Select table recordsource to show in your PDF file
 $sql = mysqli_query($db,"SELECT * FROM TMUR WHERE TMUR.KP = '".$_SESSION['kp']."' ORDER BY ID ASC ", $link);

//initialize counter
$i = 0;

while($row = $sql->fetch_assoc()) 
{
 $bil = $bil+1;

 $pdf->SetFont('Arial', '', 10);
 
 //Table with 1 rows each record and 9 columns
 $pdf->SetWidths(array(7, 30, 20, 20, 20, 20,20, 20, 20, 20,20, 20, 30));
 $pdf->SetAligns(array('C', 'L', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C'));
 $JUM=($row['A1']+$row['A2']+$row['A3']+$row['A4']+$row['A5']+$row['A6']+$row['A7']+$row['A8']+$row['A9']+$row['A10']);
 
for($i=0;$i<1;$i++)
 $pdf->row(array($bil,  $row['KELAS'], $row['A1'], $row['A2'], $row['A3'],$row['A4'], $row['A5'], $row['A6'], $row['A7'],$row['A8'], $row['A9'], $row['A10'], $JUM));

}

//mysql_close($link);
//Create file
$pdf->Output();
?>