<?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


/**  Configuration  */
require_once( "../configuration.php" );
require_once( $_Config_absolute_path . "/includes/connMySQL.class.php");	
require('../fpdf/fpdf.php');

/**  Config Table for This Page  */
$myTable1 = "personal_tb";
$myTable2 = "formaoffice"; // 
$myTable3 = "budget_year_tb";
$myTable4 ="formofficemoney" ; 
$myTable2PK = "monId";

	
/**  Create Database Object  */
$dbObj = new DBConn;
				
$query = "SELECT *, prefixName as First_name FROM personal_tb LEFT JOIN prefix ON personal_tb.First_name = prefix.prefixId   LEFT JOIN position_tb ON personal_tb.PositionId = position_tb.PositionId LEFT JOIN faculty_tb ON personal_tb.Faculty_code = faculty_tb.Faculty_code  LEFT JOIN  training_tb ON  personal_tb.Teacher_code = training_tb.Teacher_code   LEFT JOIN  formaoffice  ON   training_tb.Teacher_code = formaoffice.Teacher_code    WHERE   training_tb.Teacher_code = '".$_REQUEST["Teacher_code"]." '  and   training_tb.Training_code = '".$_REQUEST["Training_code"]." '  and  formaoffice.codeId = '".$_REQUEST["codeId"]." '       ";
	$result = $dbObj->execQuery($query);
	$rss = $dbObj->fetchArray($result);	
		
		$query = "SELECT *, prefixName as First_name FROM personal_tb LEFT JOIN prefix ON personal_tb.First_name = prefix.prefixId   LEFT JOIN position_tb ON personal_tb.PositionId = position_tb.PositionId LEFT JOIN faculty_tb ON personal_tb.Faculty_code = faculty_tb.Faculty_code  LEFT JOIN  training_tb ON  personal_tb.Teacher_code = training_tb.Teacher_code   LEFT JOIN  formaoffice  ON   training_tb.Teacher_code = formaoffice.Teacher_code   LEFT JOIN  formofficemoney ON    formaoffice.codeId = formofficemoney.codeId   WHERE   formofficemoney.maNo = '".$_REQUEST["maNo"]." '  and   formofficemoney.Teacher_code = '".$_REQUEST["Flag"]." '  Group  By   formofficemoney.maNo ,  formofficemoney.Flag ";
		$result5 = $dbObj->execQuery($query);
		$rss5 = $dbObj->fetchArray($result5);	
		

$query3 = "Select * From  college Where collegeStatus ='1'";
$result3 = $dbObj->execQuery($query3);
$rs3 = $dbObj->fetchArray($result3);

$query4 = "SELECT *, prefixName as First_name FROM personal_tb LEFT JOIN prefix ON personal_tb.First_name = prefix.prefixId LEFT JOIN position_tb ON personal_tb.PositionId = position_tb.PositionId LEFT JOIN faculty_tb ON personal_tb.Faculty_code = faculty_tb.Faculty_code Where personal_tb.Faculty_code = '".$rs['Faculty_code']."' and personal_tb.TeacherId = '1'";
$result4 = $dbObj->execQuery($query4);
$rs4 = $dbObj->fetchArray($result4);	

$query6 = " SELECT * FROM  personal_tb AS pe  LEFT JOIN formofficemoney AS fm ON pe.Teacher_code=fm.Teacher_code  LEFT JOIN formaoffice AS fo ON fm.codeId=fo.codeId  WHERE fm.maNo = '".$_REQUEST["maNo"]."' and fm.Flag = '".$_REQUEST["Flag"]."'  ";
$result6 = $dbObj->execQuery($query6); 
$num_rows = mysql_num_rows($result6);

$query10 = " SELECT * FROM  personal_tb AS pe  LEFT JOIN formofficemoney AS fm ON pe.Teacher_code=fm.Teacher_code  LEFT JOIN formaoffice AS fo ON fm.codeId=fo.codeId  WHERE fm.maNo = '".$_REQUEST["maNo"]."' and fm.Flag = '".$_REQUEST["Flag"]."'  ";
$result10 = $dbObj->execQuery($query10); 
$num_rows10 = mysql_num_rows($result10);

$query11 = " SELECT * FROM  personal_tb AS pe  LEFT JOIN formofficemoney AS fm ON pe.Teacher_code=fm.Teacher_code  LEFT JOIN formaoffice AS fo ON fm.codeId=fo.codeId  WHERE fm.maNo = '".$_REQUEST["maNo"]."' and fm.Flag = '".$_REQUEST["Flag"]."' ";
$result11 = $dbObj->execQuery($query11); 
$num_rows11 = mysql_num_rows($result11);

$query = " SELECT *  FROM personal_tb LEFT JOIN prefix ON personal_tb.First_name = prefix.prefixId LEFT JOIN position_tb ON personal_tb.PositionId = position_tb.PositionId LEFT JOIN faculty_tb ON personal_tb.Faculty_code = faculty_tb.Faculty_code WHERE personal_tb.Teacher_code='".$_REQUEST['Teacher_code']."'";
$result = $dbObj->execQuery($query);
$rs = $dbObj->fetchArray($result);

function readNumber($number, $len) {
	if($number=='0') { $number = ""; }
	else if($number=='1') {
		if($len==2) { $number = ""; }
		else { $number = "หนึ่ง"; }
	}
	else if($number=='2') { 
		if($len==2) { $number = "ยี่"; }
		else { $number = "สอง"; }
	}
	else if($number=='3') { $number = "สาม"; }
	else if($number=='4') { $number = "สี่"; }
	else if($number=='5') { $number = "ห้า"; }
	else if($number=='6') { $number = "หก"; }
	else if($number=='7') { $number = "เจ็ด"; }
	else if($number=='8') { $number = "แปด"; }
	else if($number=='9') { $number = "เก้า"; }
	return $number;
}

function readUnit($len) {
	if($len=='1') { $len = ""; }
	else if($len=='2') { $len = "สิบ"; }
	else if($len=='3') { $len = "ร้อย"; }
	else if($len=='4') { $len = "พัน"; }
	else if($len=='5') { $len = "หมื่น"; }
	else if($len=='6') { $len = "แสน"; }
	else if($len=='7') { $len = "ล้าน"; }
	return $len;
}

function convertNumberToString($amount) {
	list($baht, $satang) = split('[.]', $amount);
	while(strlen($satang) < 2)
		$satang .= '0';
		
	$str = "";
	$len = strlen($baht);
	$i = 0;
	while($i <= strlen($baht)) {
		if($len==1 && $baht[$i-1]!=0 && $baht[$i]==1)
			$str .= "เอ็ด";
		else
			$str .= readNumber($baht[$i], $len);
		if($baht[$i] != 0)
			$str .= readUnit($len);
		$len--;
		$i++;
	}
	if($str != "")
		$str .= "บาท";
	
	$len = strlen($satang);
	$i = 0;
	while($i <= strlen($satang)) {
		if($len==1 && $satang[$i-1]!=0 && $satang[$i]==1)
			$str .= "เอ็ด";
		else
			$str .= readNumber($satang[$i], $len);
		if($satang[$i] != 0)
			$str .= readUnit($len);
		$len--;
		$i++;
	}
	if($satang != '00')
		$str .= "สตางค์";
	return $str;
}
//----------------------------------------

function getMonthTh($mm) {
	if($mm=='01') { $mm='มกราคม'; }
	else if($mm=='02') { $mm='กุมภาพันธ์'; }
	else if($mm=='03') { $mm='มีนาคม'; }
	else if($mm=='04') { $mm='เมษายน'; }
	else if($mm=='05') { $mm='พฤษภาคม';}
	else if($mm=='06') { $mm='มิถุนายน'; }
	else if($mm=='07') { $mm='กรกฎาคม'; }
	else if($mm=='08') { $mm='สิงหาคม'; }
	else if($mm=='09') { $mm='กันยายน'; }
	else if($mm=='10') { $mm='ตุลาคม';}
	else if($mm=='11') { $mm='พฤศจิกายน';}
	else if($mm=='12') { $mm='ธันวาคม'; }

	return "$mm";
}

function getShortMonthTh($mm) {
	if($mm=='01') { $mm='ม.ค.'; }
	else if($mm=='02') { $mm='ก.พ.'; }
	else if($mm=='03') { $mm='มี.ค.'; }
	else if($mm=='04') { $mm='เม.ย.'; }
	else if($mm=='05') { $mm='พ.ค.';}
	else if($mm=='06') { $mm='มิ.ย.'; }
	else if($mm=='07') { $mm='ก.ค.'; }
	else if($mm=='08') { $mm='ส.ค.'; }
	else if($mm=='09') { $mm='ก.ย.'; }
	else if($mm=='10') { $mm='ต.ค.';}
	else if($mm=='11') { $mm='พ.ย.';}
	else if($mm=='12') { $mm='ธ.ค.'; }

	return "$mm";
}

//Create new pdf file
$pdf = new FPDF('L' , 'mm' , 'A4');

//Set thai font
$pdf->SetThaiFont();

$pdf->AddPage();

//-- Load Form Image to Background
$pdf->Image('../form/FormMoney-4.jpg', 0, 0, 297, 210);

//-- Set Font
$pdf->SetFont('AngsanaNew','',15);

//-- ส่วนราชการ
$pdf->Text(110,30,$rs3['collegeName']);

//-- Set Font
$pdf->SetFont('AngsanaNew','',15);

//-- เบิกค่าใช้จ่ายของ - ชื่อ นามสกุล อาจารย์
$Teacher_code =  $Flag ;
$sql = "Select * From $myTable1  LEFT JOIN prefix ON $myTable1.First_name = prefix.prefixId Where Teacher_code ='$Teacher_code'  ";
 $result8 = mysql_query($sql) or die("Error".mysql_error());
$rs8 = mysql_fetch_array($result8);
$pdf->SetXY(100,33);
$pdf->Cell(73,5,$rs8['prefixName'].'  '.$rs8['Teacher_name'].'  '.$rs8['Teacher_lastname'].' และคณะ',0,0,'C');

// ลงวันที่
$date = explode("-",$rss5['Date_start']);
$day = intval($date[2]);
$month = getMonthTh(intval($date[1]));
$year = intval($date[0]);
if(!empty($day)){
	$pdf->SetXY(190.5,33);
	$pdf->Cell(9,5,$day,0,0,'C');
	$pdf->SetXY(210,33);
	$pdf->Cell(23.5,5,$month,0,0,'C');
	$pdf->SetXY(247,33);
	$pdf->Cell(12,5,$year,0,0,'C');
}
else{
	$pdf->SetXY(190.5,33);
	$pdf->Cell(9,5,'-',0,0,'C');
	$pdf->SetXY(210,33);
	$pdf->Cell(23.5,5,'-',0,0,'C');
	$pdf->SetXY(247,33);
	$pdf->Cell(12,5,'-',0,0,'C');
}

$pdf->SetFont('AngsanaNew','',13);
//-- คอลัมน์ ชื่อ - นามสกุล
if($num_rows){
	$i = 1;
	while($data = $dbObj->fetchObject($result6)){
		$query7 = "Select * From $myTable1  LEFT JOIN prefix ON $myTable1.First_name = prefix.prefixId  Where Teacher_code='".$data->Teacher_code."' ";
		$result7 = $dbObj->execQuery($query7);
		$rs7 = $dbObj->fetchArray($result7);
		
		switch($i){							
			case "1" : $pdf->Text(33,61,$rs7['prefixName'].'  '.$rs7['Teacher_name'].'  '.$rs7['Teacher_lastname']); break;
			case "2" : $pdf->Text(33,68.3,$rs7['prefixName'].'  '.$rs7['Teacher_name'].'  '.$rs7['Teacher_lastname']); break;
			case "3" : $pdf->Text(33,76.5,$rs7['prefixName'].'  '.$rs7['Teacher_name'].'  '.$rs7['Teacher_lastname']); break;
			case "4" : $pdf->Text(33,83.5,$rs7['prefixName'].'  '.$rs7['Teacher_name'].'  '.$rs7['Teacher_lastname']); break;
			case "5" : $pdf->Text(33,90.5,$rs7['prefixName'].'  '.$rs7['Teacher_name'].'  '.$rs7['Teacher_lastname']); break;
			case "6" : $pdf->Text(33,97.5,$rs7['prefixName'].'  '.$rs7['Teacher_name'].'  '.$rs7['Teacher_lastname']); break;
			case "7" : $pdf->Text(33,104.5,$rs7['prefixName'].'  '.$rs7['Teacher_name'].'  '.$rs7['Teacher_lastname']); break;
			case "8" : $pdf->Text(33,111.5,$rs7['prefixName'].'  '.$rs7['Teacher_name'].'  '.$rs7['Teacher_lastname']); break;
			case "9" : $pdf->Text(33,118.5,$rs7['prefixName'].'  '.$rs7['Teacher_name'].'  '.$rs7['Teacher_lastname']); break;
			case "10" : $pdf->Text(33,125.5,$rs7['prefixName'].'  '.$rs7['Teacher_name'].'  '.$rs7['Teacher_lastname']); break;
			case "11" : $pdf->Text(33,132.5,$rs7['prefixName'].'  '.$rs7['Teacher_name'].'  '.$rs7['Teacher_lastname']); break;
			case "12" : $pdf->Text(33,139.5,$rs7['prefixName'].'  '.$rs7['Teacher_name'].'  '.$rs7['Teacher_lastname']); break;
		}		
		$i++;
	}	
}		
if($num_rows10){
	$j = 1;
	while($data1 = $dbObj->fetchObject($result10)){
		$query9 = " Select * From personal_tb  LEFT JOIN position_tb ON personal_tb.PositionId = position_tb.PositionId  WHERE Teacher_code='".$data1->Teacher_code."' ";
		$result9 = $dbObj->execQuery($query9);
		$rs9 = $dbObj->fetchArray($result9);
			
		switch($j){							
			case "1" : $pdf->Text(79,61,$rs9['Position_name']); break;
			case "2" : $pdf->Text(79,68.3,$rs9['Position_name']); break;
			case "3" : $pdf->Text(79,76.5,$rs9['Position_name']); break;
			case "4" : $pdf->Text(79,83.5,$rs9['Position_name']); break;
			case "5" : $pdf->Text(79,90.5,$rs9['Position_name']); break;
			case "6" : $pdf->Text(79,97.5,$rs9['Position_name']); break;
			case "7" : $pdf->Text(79,104.5,$rs9['Position_name']); break;
			case "8" : $pdf->Text(79,111.5,$rs9['Position_name']); break;
			case "9" : $pdf->Text(79,118.5,$rs9['Position_name']); break;
			case "10" : $pdf->Text(79,125.5,$rs9['Position_name']); break;
			case "11" : $pdf->Text(79,132.5,$rs9['Position_name']); break;
			case "12" : $pdf->Text(79,139.5,$rs9['Position_name']); break;		
		}		
		$j++;
	}	
}

if($num_rows11){
	$k = 1;
	while($data2 = $dbObj->fetchObject($result11)){
		$query12 = " SELECT * FROM  formofficemoney  WHERE Teacher_code='".$data2->Teacher_code."' and maNo = '".$data2->maNo."'  ";
		$result12 = $dbObj->execQuery($query12);
		$rs12 = $dbObj->fetchArray($result12);
			
		switch($k){							
			case "1" : $pdf->Text(128,61,number_format($rs12['Smtotal'],2,'.',','));  $pdf->Text(145,61,number_format($rs12['STtotal'],2,'.',',')); $pdf->Text(162,61,number_format($rs12['Vehicletotal'],2,'.',',')); $pdf->Text(182,61,number_format($rs12['Crgestotal'],2,'.',',')); $pdf->Text(200,61,number_format($rs12['Budget_use'],2,'.',',')); break;
			case "2" : $pdf->Text(128,68.3,number_format($rs12['Smtotal'],2,'.',','));   $pdf->Text(145,68.3,number_format($rs12['STtotal'],2,'.',',')); $pdf->Text(162,68.3,number_format($rs12['Vehicletotal'],2,'.',',')); $pdf->Text(182,68.3,number_format($rs12['Crgestotal'],2,'.',',')); $pdf->Text(200,68.3,number_format($rs12['Budget_use'],2,'.',',')); break;
			case "3" : $pdf->Text(128,76.5,number_format($rs12['Smtotal'],2,'.',','));   $pdf->Text(145,76.5,number_format($rs12['STtotal'],2,'.',',')); $pdf->Text(162,76.5,number_format($rs12['Vehicletotal'],2,'.',',')); $pdf->Text(182,76.5,number_format($rs12['Crgestotal'],2,'.',',')); $pdf->Text(200,76.5,number_format($rs12['Budget_use'],2,'.',',')); break;
			case "4" : $pdf->Text(128,83.5,number_format($rs12['Smtotal'],2,'.',','));  $pdf->Text(145,83.5,number_format($rs12['STtotal'],2,'.',',')); $pdf->Text(162,83.5,number_format($rs12['Vehicletotal'],2,'.',',')); $pdf->Text(182,83.5,number_format($rs12['Crgestotal'],2,'.',',')); $pdf->Text(200,83.5,number_format($rs12['Budget_use'],2,'.',',')); break;
			case "5" : $pdf->Text(128,90.5,number_format($rs12['Smtotal'],2,'.',','));   $pdf->Text(145,90.5,number_format($rs12['STtotal'],2,'.',',')); $pdf->Text(162,90.5,number_format($rs12['Vehicletotal'],2,'.',',')); $pdf->Text(182,90.5,number_format($rs12['Crgestotal'],2,'.',',')); $pdf->Text(200,90.5,number_format($rs12['Budget_use'],2,'.',',')); break;
			case "6" : $pdf->Text(128,97.5,number_format($rs12['Smtotal'],2,'.',','));   $pdf->Text(145,97.5,number_format($rs12['STtotal'],2,'.',',')); $pdf->Text(162,97.5,number_format($rs12['Vehicletotal'],2,'.',',')); $pdf->Text(182,97.5,number_format($rs12['Crgestotal'],2,'.',',')); $pdf->Text(200,97.5,number_format($rs12['Budget_use'],2,'.',',')); break;
			case "7" : $pdf->Text(128,104.5,number_format($rs12['Smtotal'],2,'.',','));   $pdf->Text(145,104.5,number_format($rs12['STtotal'],2,'.',',')); $pdf->Text(162,104.5,number_format($rs12['Vehicletotal'],2,'.',',')); $pdf->Text(182,104.5,number_format($rs12['Crgestotal'],2,'.',',')); $pdf->Text(200,104.5,number_format($rs12['Budget_use'],2,'.',',')); break;
			case "8" : $pdf->Text(128,111.5,number_format($rs12['Smtotal'],2,'.',','));   $pdf->Text(145,111.5,number_format($rs12['STtotal'],2,'.',',')); $pdf->Text(162,111.5,number_format($rs12['Vehicletotal'],2,'.',',')); $pdf->Text(182,111.5,number_format($rs12['Crgestotal'],2,'.',',')); $pdf->Text(200,111.5,number_format($rs12['Budget_use'],2,'.',',')); break;
			case "9" : $pdf->Text(128,118.5,number_format($rs12['Smtotal'],2,'.',','));   $pdf->Text(145,118.5,number_format($rs12['STtotal'],2,'.',',')); $pdf->Text(162,118.5,number_format($rs12['Vehicletotal'],2,'.',',')); $pdf->Text(182,118.5,number_format($rs12['Crgestotal'],2,'.',',')); $pdf->Text(200,118.5,number_format($rs12['Budget_use'],2,'.',',')); break;
			case "10" : $pdf->Text(128,125.5,number_format($rs12['Smtotal'],2,'.',','));   $pdf->Text(145,125.5,number_format($rs12['STtotal'],2,'.',',')); $pdf->Text(162,125.5,number_format($rs12['Vehicletotal'],2,'.',',')); $pdf->Text(182,125.5,number_format($rs12['Crgestotal'],2,'.',',')); $pdf->Text(200,125.5,number_format($rs12['Budget_use'],2,'.',',')); break;
			case "11" : $pdf->Text(128,132.5,number_format($rs12['Smtotal'],2,'.',','));   $pdf->Text(145,132.5,number_format($rs12['STtotal'],2,'.',',')); $pdf->Text(162,132.5,number_format($rs12['Vehicletotal'],2,'.',',')); $pdf->Text(182,132.5,number_format($rs12['Crgestotal'],2,'.',',')); $pdf->Text(200,132.5,number_format($rs12['Budget_use'],2,'.',',')); break;
			case "12" : $pdf->Text(128,139.5,number_format($rs12['Smtotal'],2,'.',','));   $pdf->Text(145,139.5,number_format($rs12['STtotal'],2,'.',',')); $pdf->Text(162,139.5,number_format($rs12['Vehicletotal'],2,'.',',')); $pdf->Text(182,139.5,number_format($rs12['Crgestotal'],2,'.',',')); $pdf->Text(200,139.5,number_format($rs12['Budget_use'],2,'.',',')); break;
		}		
		$k++;
	}	
}
//-- ค่าเบี้ยเลี้ยง
$sql1 = " SELECT SUM(Smtotal)  AS SumB1  FROM $myTable4  WHERE  Flag='$Flag'   and  maNo='$maNo'  ";
$result1 = mysql_query($sql1);
$rss1 = mysql_fetch_array($result1);
if(!empty($rss1['SumB1'])){
	$pdf->SetXY(110,142.5);
	$pdf->Cell(45,5,number_format($rss1['SumB1'], 2, '.', ','),0,0,'C');
}
else{
	$pdf->SetXY(60,203);
	$pdf->Cell(45,5,'-',0,0,'C');
}
//-- ค่าที่พัก
$sql1 = " SELECT SUM(STtotal)  AS SumB2  FROM $myTable4  WHERE  Flag='$Flag'   and  maNo='$maNo'  ";
				$result1 = mysql_query($sql1);
				$rss1 = mysql_fetch_array($result1);
if(!empty($rss1['SumB2'])){
	$pdf->SetXY(128,142.5);
	$pdf->Cell(45,5,number_format($rss1['SumB2'], 2, '.', ','),0,0,'C');
}
else{
	$pdf->SetXY(60,203);
	$pdf->Cell(45,5,'-',0,0,'C');
}
//-- ค่าพาหนะ
$sql1 = " SELECT SUM(Vehicletotal)  AS SumB3 FROM $myTable4  WHERE  Flag='$Flag'   and  maNo='$maNo'  ";
				$result1 = mysql_query($sql1);
				$rss1 = mysql_fetch_array($result1);
if(!empty($rss1['SumB3'])){
	$pdf->SetXY(144,142.5);
	$pdf->Cell(45,5,number_format($rss1['SumB3'], 2, '.', ','),0,0,'C');
}
else{
	$pdf->SetXY(60,203);
	$pdf->Cell(45,5,'-',0,0,'C');
}
//-- ค่าอื่นๆ
$sql1 = " SELECT SUM(Crgestotal)  AS SumB4  FROM $myTable4  WHERE  Flag='$Flag'   and  maNo='$maNo'  ";
				$result1 = mysql_query($sql1);
				$rss1 = mysql_fetch_array($result1);
if(!empty($rss1['SumB4'])){
	$pdf->SetXY(165.5,142.5);
	$pdf->Cell(45,5,number_format($rss1['SumB4'], 2, '.', ','),0,0,'C');
}
else{
	$pdf->SetXY(60,203);
	$pdf->Cell(45,5,'-',0,0,'C');
}

//  จำนวนเงิน
$sql1 = " SELECT SUM(Budget_use)  AS SumB5  FROM $myTable4  WHERE  Flag='$Flag'   and  maNo='$maNo'  ";
$result1 = mysql_query($sql1);
$rss1 = mysql_fetch_array($result1);
if(!empty($rss1['SumB5'])){
	$pdf->SetXY(183,142.5);
	$pdf->Cell(45,5,number_format($rss1['SumB5'], 2, '.', ','),0,0,'C');
}
else{
	$pdf->SetXY(60,203);
	$pdf->Cell(45,5,'-',0,0,'C');
}

//  จำนวนเงิน (ตัวอักษร)
if(!empty($rss1['SumB5'])){
	$SumB5 = convertNumberToString($rss1['SumB5']);
	$pdf->SetXY(78,155);
	$pdf->Cell(45,5,$SumB5,0,0,'C');
}
else{
	$pdf->SetXY(60,203);
	$pdf->Cell(45,5,'-',0,0,'C');
}

//-- signature

$pdf->SetXY(144,168.6);
$pdf->Cell(51,5,$rs['First_name'].'  '.$rs['Teacher_name'].'  '.$rs['Teacher_lastname'],0,0,'C');
$pdf->SetXY(146.5,175.3);
$pdf->Cell(49,5,$rs['Position_name'],0,0,'C');

$pdf->SetXY(146,209.8);
$pdf->Cell(50,5,$rs4['First_name'].'  '.$rs4['Teacher_name'].'  '.$rs4['Teacher_lastname'],0,0,'C');
$pdf->SetXY(146.8,216.7);
$pdf->Cell(49,5,$rs4['Position_name'],0,0,'C');

//Create file
$pdf->Output();
?>