<?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');
		
	
/**  Create Database Object  */
$dbObj = new DBConn;
				
		/**  Config Table for This Page  */
		$myTable = "personal_tb";
        $myTable1 = "budget_year_tb"; 
		$myTable2 ="durable_type_tb";
	  
	    /*----- personal_tb--------*/
	   
	 $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  formcontract ON  formaoffice.Teacher_code = formcontract.Teacher_code  LEFT  JOIN  formagree  ON formagree.contId= formcontract.contId  WHERE   formaoffice.Teacher_code = '".$_REQUEST["Teacher_code"]." '  and   formaoffice.maNo = '".$_REQUEST["maNo"]." '  and  formagree.agreeId= '".$_REQUEST["agreeId"]." '       ";
		$result = $dbObj->execQuery($query);
		$rss = $dbObj->fetchArray($result);	
		
				/** College Data **/
		$sql = "Select * From  college Where collegeStatus ='1'";
		$result = mysql_query($sql) or die("Error".mysql_error());
		$rs4 = mysql_fetch_array($result);
		$collegeName = $rs4["collegeName"];
		
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";
}

//Create new pdf file
$pdf = new FPDF();

//Set thai font
$pdf->SetThaiFont();

$pdf->AddPage();

//-- Load Form Image to Background
$pdf->Image('../form/moneyAgree-2.jpg', 0, 0, 205, 297);

//-- Set Font
$pdf->SetFont('AngsanaNew','',15);
/*
if(!empty($rss['Noagree'])){
	$pdf->SetXY(141,31);
	$pdf->Cell(34,5,$rss['Noagree'],0,0,'C');
}
else{
	$pdf->SetXY(141,31);
	$pdf->Cell(34,5,'-',0,0,'C');
}

//-- College name and Date , Top-Right Position
$date = explode("-",$rss['Date']);
$day = intval($date[2]);
$month = getMonthTh(intval($date[1]));
$year = intval($date[0]);

if(!empty($day)){
	$pdf->SetXY(150,38);
	$pdf->Cell(40,5,"$day "."  "." $month "." "." $year",0,0,'C');
}
else{
	$pdf->Text(150,38,'-');
}
*/
//-- Set Font
$pdf->SetFont('AngsanaNew','',13);

//--  Request header
if(!empty($rss['maNo'])){
	$pdf->SetXY(21,45);
	$pdf->Cell(34,5,$rss['maNo'],0,0,'C');
}
else{
	$pdf->SetXY(21,45);
	$pdf->Cell(34,5,'-',0,0,'C');
}

$pdf->Text(30,56.5,'ผู้อำนวยการ '.$rs4['collegeName']);

//-- Body
$pdf->SetXY(31,58.7);
$pdf->Cell(88.3,5,$rss['prefixName'].'  '.$rss['Teacher_name'].'  '.$rss['Teacher_lastname'],0,0,'C');
$pdf->SetXY(131.5,58.7);
$pdf->Cell(63,5,$rss['Position_name'],0,0,'C');
$pdf->SetXY(20.9,65.5);
$pdf->Cell(88,5,$rss['Faculty'].'     '.$rs4['collegeName'].'     ',0,0,'C');

//-- เรื่อง
if(strlen($rss['Training_name']) > 100){	
	$tmp[0] = substr($rss['Training_name'],0,91);
	$tmp[1] = substr($rss['Training_name'],91,strlen($rss['Training_name']));
	
	$pdf->SetXY(20,90.3);
	$pdf->Cell(130,5,$tmp[0],0,0,'C');
	
	$pdf->SetXY(21,90.3);
	$pdf->Cell(174,5,$tmp[1],0,0,'L');
}
else{
	$pdf->SetXY(110,72.5);
	$pdf->Cell(50,5,$rss['Training_name'],0,0,'C');
}

//-- มีความประสงค์ขอยืมเงิน
$query = " SELECT * FROM money_source_tb  Where  MoneyS_C='$rss[MoneyS_C]' ";
$result5 = mysql_query($query);
$rs5= mysql_fetch_array($result5);
if(!empty($rs5['MoneyS_M'])){
	$pdf->SetXY(148.5,65.7);
	$pdf->Cell(34,5,$rs5['MoneyS_M'],0,0,'C');
}
else{
	$pdf->SetXY(23.5,48.8);
	$pdf->Cell(34,5,'-',0,0,'C');
}

//-- ค่าเบี้ยเลี้ยง
if(!empty($rss['Smtotal'])){
	$pdf->SetXY(138.5,79.5);
	$pdf->Cell(34,5,number_format($rss['Smtotal'],'2','.',','),0,0,'C');
}
else{
	$pdf->SetXY(138.5,79.5);
	$pdf->Cell(34,5,'-',0,0,'C');
}

//-- ค่าเช่าที่พัก
if(!empty($rss['STtotal'])){
	$pdf->SetXY(138.5,86.5);
	$pdf->Cell(34,5,number_format($rss['STtotal'],'2','.',','),0,0,'C');
}
else{
	$pdf->SetXY(138.5,86.5);
	$pdf->Cell(34,5,'-',0,0,'C');
}

//-- ค่าพาหนะ
if(!empty($rss['Vehicletotal'])){
	$pdf->SetXY(138.5,93.5);
	$pdf->Cell(34,5,number_format($rss['Vehicletotal'],'2','.',','),0,0,'C');
}
else{
	$pdf->SetXY(138.5,93.5);
	$pdf->Cell(34,5,'-',0,0,'C');
}

//-- ค่าใช้จ่ายอื่นๆ
if(!empty($rss['Crgestotal'])){
	$pdf->SetXY(138.5,100.5);
	$pdf->Cell(34,5,number_format($rss['Crgestotal'],'2','.',','),0,0,'C');
}
else{
	$pdf->SetXY(138.5,100.5);
	$pdf->Cell(34,5,'-',0,0,'C');
}

//-- จำนวนเงิน1
if(!empty($rss["Budget"])){
	$pdf->SetXY(138.5,107);
	$pdf->Cell(34,5,number_format($rss["Budget"],'2','.',','),0,0,'C');
}
else{
	$pdf->SetXY(138.5,107);
	$pdf->Cell(34,5,'-',0,0,'C');
}

//-- จำนวนเงินตัวอักษร1
if(!empty($rss["Budget"])){
	$pdf->SetXY(25,107);
	$pdf->Cell(120,5,convertNumberToString($rss['Budget']).'ถ้วน',0,0,'C');
}
else{
	$pdf->SetXY(25,107);
	$pdf->Cell(120,5,'-',0,0,'C');
}

//-- จำนวนเงิน2
if(!empty($rss["Budget"])){
	$pdf->SetXY(133,187);
	$pdf->Cell(30,5,number_format($rss["Budget"],'2','.',','),0,0,'C');
}
else{
	$pdf->SetXY(133,187);
	$pdf->Cell(30,5,'-',0,0,'C');
}

//-- จำนวนเงินตัวอักษร2
if(!empty($rss["Budget"])){
	$pdf->SetXY(38,187);
	$pdf->Cell(50,5,convertNumberToString($rss['Budget']).'ถ้วน',0,0,'C');
}
else{
	$pdf->SetXY(38,187);
	$pdf->Cell(50,5,'-',0,0,'C');
}

//-- จำนวนเงิน3
if(!empty($rss["Budget"])){
	$pdf->SetXY(133,226.5);
	$pdf->Cell(30,5,number_format($rss["Budget"],'2','.',','),0,0,'C');
}
else{
	$pdf->SetXY(133,226.5);
	$pdf->Cell(50,5,'-',0,0,'C');
}

//-- จำนวนเงินตัวอักษร3
if(!empty($rss["Budget"])){
	$pdf->SetXY(38,226.5);
	$pdf->Cell(50,5,convertNumberToString($rss['Budget']).'ถ้วน',0,0,'C');
}
else{
	$pdf->SetXY(38,226.5);
	$pdf->Cell(50,5,'-',0,0,'C');
}

//-- จำนวนเงิน4
if(!empty($rss["Budget"])){
	$pdf->SetXY(133,260.5);
	$pdf->Cell(30,5,number_format($rss["Budget"],'2','.',','),0,0,'C');
}
else{
	$pdf->SetXY(133,260.5);
	$pdf->Cell(50,5,'-',0,0,'C');
}

//-- จำนวนเงินตัวอักษร4
if(!empty($rss["Budget"])){
	$pdf->SetXY(38,260.5);
	$pdf->Cell(50,5,convertNumberToString($rss['Budget']).'ถ้วน',0,0,'C');
}
else{
	$pdf->SetXY(38,260.5);
	$pdf->Cell(50,5,'-',0,0,'C');
}

$pdf->SetFont('AngsanaNew','B',27);

switch($rss["Dayout"]){
	case "15" : $pdf->Text(110,125.5,'/'); break;
	case "30" : $pdf->Text(126.5,125.5,'/'); break;
}

//Create file
$pdf->Output();
?>