<?php
//PDF USING MULTIPLE PAGES
//FILE CREATED BY: Carlos Jos้ Vแsquez Sแez
//YOU CAN CONTACT ME: carlos@magallaneslibre.com
//FROM PUNTA ARENAS, MAGALLANES
//INOVO GROUP - http://www.inovo.cl

//include_once "../global0.php";
define('FPDF_FONTPATH','../font/');
require('../fpdf.php');

class PDF extends FPDF
{
	//Page header
	function Header()
	{
		//Logo
		//$this->Image($GLOBALS["COLLEGELOGO"],10,3,18,15);
		//AngsanaNew bold 15
		$this->SetFont('AngsanaNew','B',15);
		//Move to the right
		$this->SetY(7);
		$this->SetX(30);
		//Title
		$this->Cell(0,0,$GLOBALS["COLLEGENAME"],0,0,'L');
		$this->SetX(-10);
		$this->SetFontSize(12);
		$this->Cell(0,0,'RIS302',0,0,'R');
		$this->Ln(7);
		$this->SetX(30);
		$this->SetFontSize(15);
		$this->Cell(0,0,$GLOBALS["SITENAME"],0,0,'L');
		//Draw line
		$this->SetLineWidth(0.4);
		$this->Line(10,19,200,19);
	}
	
	//Page footer
	function Footer()
	{
		//Position at 3.0 cm from bottom
		$this->SetLineWidth(0.4);
		$this->Line(10,286,200,286);
		//Arial italic 8
		$this->SetY(-7);
		$this->SetFont('AngsanaNew','',14);
		//Page number
		$this->Cell(0,0,'หน้า '.$this->PageNo().'/{nb}',0,0,'R');
		$this->SetY(-7);
		//$this->Cell(10);
		$this->Cell(0,0,'วันที่พิมพ์ : '.date("d/m/y H:i"),0,0,'L');
	}
} //End class

//Connect to your database
include("../include/FunctionDB.php");
include("../include/Function.php");
include("../link/function.php");
 ConnectDB();
$sql = "SELECT * FROM  project_tb  WHERE    Orderlist='$Orderlist'   and  Project_code ='$Project_code'  and  Faculty_code='$Faculty_code'   ";
$result = mysql_query($sql) or die(" Error").mysql_error();
$rs = mysql_fetch_array($result);
$row = mysql_num_rows($result);
$strSQL = "Select * FROM  project_tb   WHERE   ProjectId='$ProjectId'      ";
$result = mysql_query($strSQL); 
$num = mysql_num_rows($result );
//Create new pdf file
$pdf=new PDF();

//Set thai font
$pdf->SetThaiFont();

$pdf->AliasNbPages();

//Open file
$pdf->Open();

//Disable automatic page break
$pdf->SetAutoPageBreak(false);

//Add first page
$pdf->AddPage();

//set initial y axis position per page
$y_axis_initial = 40;

//Set Row Height
$row_height = 6;

$pdf->SetFontSize(18);
$pdf->Cell(105);
$pdf->SetY(27);
$pdf->Cell(0,0,'รายได้จากค่าใช้จ่ายในการศึกษาที่รับจริง',0,0,'C');
$pdf->Ln(7);
$pdf->SetFontSize(16);
$pdf->Cell(0,0,'ประจำปีการศึกษา '.$acadYear.'  ภาคการศึกษา '.$semester,0,0,'C');

//print column titles for the actual page

$pdf->SetFillColor(232,232,232);
$pdf->SetFontSize(14);
$pdf->SetY($y_axis_initial);
$pdf->Cell(10,6,'ที่',1,0,'C',1);
$pdf->Cell(120,6,'หลักสูตร',1,0,'C',1);
$pdf->Cell(10,6,'รุ่นที่',1,0,'C',1);
$pdf->Cell(20,6,'จำนวน (คน)',1,0,'C',1);
$pdf->Cell(30,6,'รายได้ (บาท)',1,0,'C',1);

$y_axis = $y_axis_initial + $row_height;

//initialize counter
$i = 0;
$r = 1;
$sumSt = 0;

//Set maximum rows per page
$max = 20;

$i = 1;
 while($row = mysql_fetch_array($result))
 {

	 if($count==0)
	 

		//If the current row is the last one, create new page and print column title
		if ($i == $max)
		{
			//Set $i variable to 0 (first row)
			$i = 0;

			$pdf->AddPage();

			$pdf->SetFont('AngsanaNew','B',18);
			$pdf->Cell(105);
			$pdf->SetY(27);
			$pdf->Cell(0,0,'รายได้จากค่าใช้จ่ายในการศึกษาที่รับจริง',0,0,'C');
			$pdf->Ln(7);
			$pdf->SetFontSize(16);
			$pdf->Cell(0,0,'ประจำปีการศึกษา '.$acadYear.'  ภาคการศึกษา '.$semester,0,0,'C');

			//print column titles for the current page
			$pdf->SetFillColor(232,232,232);
			$pdf->SetFontSize(14);
			$pdf->SetY($y_axis_initial);
			$pdf->Cell(10,6,'ที่',1,0,'C',1);
			$pdf->Cell(120,6,'หลักสูตร',1,0,'C',1);
			$pdf->Cell(10,6,'รุ่นที่',1,0,'C',1);
			$pdf->Cell(20,6,'จำนวน (คน)',1,0,'C',1);
			$pdf->Cell(30,6,'รายได้ (บาท)',1,0,'C',1);
			
			//Go to next row
			$y_axis = $y_axis_initial + $row_height;
		}

		
		
		$pdf->SetFont('AngsanaNew','',14);
		$pdf->SetY($y_axis);
		$pdf->Cell(10,6,$r,1,0,'C');
		$pdf->Cell(120,6,$row["Orderlist"],1,0,'L');
		$pdf->Cell(10,6,$oGe->genNo,1,0,'C');
		$pdf->Cell(20,6,$oSm->studentId,1,0,'R');
		$pdf->Cell(30,6,number_format($row['Budget_use'],2,'.',','), 2),1,0,'R');

		//Go to next row
		$y_axis = $y_axis + $row_height;
		$i = $i + 1;
		$r = $r + 1;
		$sumSt += $oSm->studentId;
	} //End while
	
	$pdf->SetFont('AngsanaNew','B',14);
	$pdf->SetY($y_axis);
	$pdf->Cell(140,6,'รวม',1,0,'C');
	$pdf->Cell(20,6,$sumSt,1,0,'R');
	$pdf->Cell(30,6,number_format($row['Budget_use'],2,'.',','), 2),1,0,'R');

	//Create file
	$pdf->Output();

//} else
	echo "<font face='Microsoft Sans Serif' color='red'><b>ไม่มีข้อมูล...</b></font>";
?>