Viewing file: prePrintAgreeProjectPDF.php (11.64 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?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 formagree.agreeId= '".$_REQUEST["agreeId"]." ' ";
$result = $dbObj->execQuery($query);
$rss = $dbObj->fetchArray($result);
*/
/*----- 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 WHERE formaoffice.Teacher_code = '".$_REQUEST["Teacher_code"]." ' ";
$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.Teacher_code = '".$_REQUEST["Teacher_code"]." ' ";
$result5 = $dbObj->execQuery($query);
$rs = $dbObj->fetchArray($result5);
$query2 = "SELECT * FROM `formagree` f , formagree_type ft WHERE f.agreeId=ft.agreeId AND f.Flag = 'Y' AND f.Teacher_code = '".$_REQUEST["Teacher_code"]."' AND f.agreeId = '".$_REQUEST["agreeId"]."' ";
$result2 = $dbObj->execQuery($query2);
$num_rows = mysql_num_rows($result2);
/*------------------------------*/
$query11 = " SELECT * FROM `formagree` f , formagree_type ft WHERE f.agreeId=ft.agreeId AND f.Teacher_code = ' ".$_REQUEST["Teacher_code"]." ' AND f.agreeId = '".$_REQUEST["agreeId"]."' ";
$result11 = $dbObj->execQuery($query11);
$rs11 = $dbObj->fetchArray($result11);
/*------------------------------*/
$sql = " SELECT SUM(Budget_agree) AS Budget_agree FROM formagree_type WHERE agreeId ='$rs11[agreeId]' ";
$result1 = $dbObj->execQuery($sql);
$rs1 = $dbObj->fetchArray($result1);
//echo number_format($rs1['Budget_agree'],2,'.',',');
/** 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/8500P.jpg', 0, 0, 205, 297);
//-- Set Font
$pdf->SetFont('AngsanaNew','',15);
//-- Set Font
$pdf->SetFont('AngsanaNew','',13);
$pdf->Text(25,25.5,'ผู้อำนวยการ '.$rs4['collegeName']);
$pdf->Text(33,197.2,'ผู้อำนวยการ '.$rs4['collegeName']);
//-- Body
$pdf->SetXY(10,35.3);
$pdf->Cell(88.3,5,$rss['prefixName'].' '.$rss['Teacher_name'].' '.$rss['Teacher_lastname'],0,0,'C');
$pdf->SetXY(110,35.3);
$pdf->Cell(63,5,$rss['Position_name'],0,0,'C');
$pdf->SetXY(18,42.3);
$pdf->Cell(60,5,$rss['Faculty'].' '.$rs4['collegeName'].' ',0,0,'C');
$pdf->Text(75,53.7,$rs4['collegeName']);
//-- เรื่อง
$str = $rs11['Training_name'];
$cutstr = substr($str,0,60);
if(!empty($rs11['Training_name'])){
$pdf->SetXY(63,56.8);
if(strlen($str)>60) {
$pdf->Cell(55,5,$cutstr.'---',0,0,'C');
}
else {
$pdf->Cell(55,5,$cutstr,0,0,'C');
}
}
else{
$pdf->SetXY(63,56.8);
$pdf->Cell(50,5,'-',0,0,'C');
}
//-- ค่าเบี้ยเลี้ยง
/*if(!empty($rs1['Budget_agree'])){
$pdf->SetXY(165,71.5);
$pdf->Cell(34,5,number_format($rs1['Budget_agree'],'2','.',','),0,0,'C');
}
else{
$pdf->SetXY(165,71.5);
$pdf->Cell(34,5,'-',0,0,'C');
}*/
//-- จำนวนเงิน1
if(!empty($rs1["Budget_agree"])){
$pdf->SetXY(165,138);
$pdf->Cell(34,5,number_format($rs1["Budget_agree"],'2','.',','),0,0,'C');
}
else{
$pdf->SetXY(165,138);
$pdf->Cell(34,5,'-',0,0,'C');
}
//-- จำนวนเงินตัวอักษร1
if(!empty($rs1["Budget_agree"])){
$pdf->SetXY(10,137);
$pdf->Cell(120,5,convertNumberToString($rs1['Budget_agree']).'ถ้วน',0,0,'C');
}
else{
$pdf->SetXY(10,137);
$pdf->Cell(120,5,'-',0,0,'C');
}
//-- จำนวนเงิน2
if(!empty($rs1["Budget_agree"])){
$pdf->SetXY(127,200.5);
$pdf->Cell(30,5,number_format($rs1["Budget_agree"],'2','.',','),0,0,'C');
}
else{
$pdf->SetXY(127,200.5);
$pdf->Cell(30,5,'-',0,0,'C');
}
//-- จำนวนเงินตัวอักษร2
if(!empty($rs1["Budget_agree"])){
$pdf->SetXY(33,207.2);
$pdf->Cell(50,5,convertNumberToString($rs1['Budget_agree']).'ถ้วน',0,0,'C');
}
else{
$pdf->SetXY(33,207.2);
$pdf->Cell(50,5,'-',0,0,'C');
}
//-- จำนวนเงิน3
if(!empty($rs1["Budget_agree"])){
$pdf->SetXY(105,235);
$pdf->Cell(30,5,number_format($rs1["Budget_agree"],'2','.',','),0,0,'C');
}
else{
$pdf->SetXY(105,235);
$pdf->Cell(50,5,'-',0,0,'C');
}
//-- จำนวนเงินตัวอักษร3
if(!empty($rs1["Budget_agree"])){
$pdf->SetXY(33,242);
$pdf->Cell(50,5,convertNumberToString($rs1['Budget_agree']).'ถ้วน',0,0,'C');
}
else{
$pdf->SetXY(33,242);
$pdf->Cell(50,5,'-',0,0,'C');
}
//-- จำนวนเงิน4
if(!empty($rs1["Budget_agree"])){
$pdf->SetXY(60,265);
$pdf->Cell(30,5,number_format($rs1["Budget_agree"],'2','.',','),0,0,'C');
}
else{
$pdf->SetXY(60,265);
$pdf->Cell(50,5,'-',0,0,'C');
}
//-- จำนวนเงินตัวอักษร4
if(!empty($rs1["Budget_agree"])){
$pdf->SetXY(50,271.8);
$pdf->Cell(50,5,convertNumberToString($rs1['Budget_agree']).'ถ้วน',0,0,'C');
}
else{
$pdf->SetXY(50,271.8);
$pdf->Cell(50,5,'-',0,0,'C');
}
//-- จำนวนวัน
if(!empty($rs11["Dayout"])){
$pdf->SetXY(130,152);
$pdf->Cell(20,5,$rs11["Dayout"].' '.' วัน',0,0,'C');
}
else{
$pdf->SetXY(130,152);
$pdf->Cell(50,5,'-',0,0,'C');
}
if($num_rows) {
$j = 1;
while($data1 = $dbObj->fetchObject($result2)) {
/*$query9 = " SELECT * FROM formagree_type WHERE agreeId = '".$data1->agreeId."' ";
$result9 = $dbObj->execQuery($query9);
$rs9 = $dbObj->fetchArray($result9);
switch($j) {
case "1" : $pdf->Text(15,77.5,$j.". ".$rs9['agreeName']); $pdf->Text(176,77.5,number_format($rs9['Budget_agree'],'2','.',',')); break;
case "2" : $pdf->Text(15,86,$j.". ".$rs9['agreeName']); $pdf->Text(176,86,number_format($rs9['Budget_agree'],'2','.',',')); break;
case "3" : $pdf->Text(15,94.2,$j.". ".$rs9['agreeName']); $pdf->Text(176,94.2,number_format($rs9['Budget_agree'],'2','.',',')); break;
case "4" : $pdf->Text(15,102.8,$j.". ".$rs9['agreeName']); $pdf->Text(176,102.8,number_format($rs9['Budget_agree'],'2','.',',')); break;
case "5" : $pdf->Text(15,111,$j.". ".$rs9['agreeName']); $pdf->Text(176,111,number_format($rs9['Budget_agree'],'2','.',',')); break;
case "6" : $pdf->Text(15,119.5,$j.". ".$rs9['agreeName']); $pdf->Text(176,119.5,number_format($rs9['Budget_agree'],'2','.',',')); break;
case "7" : $pdf->Text(15,128,$j.". ".$rs9['agreeName']); $pdf->Text(176,128,number_format($rs9['Budget_agree'],'2','.',',')); break;
}
$j++;*/
switch($j) {
case "1" : $pdf->Text(15,77.5,$j.". ".$data1->agreeName); $pdf->Text(176,77.5,number_format($data1->Budget_agree,'2','.',',')); break;
case "2" : $pdf->Text(15,86,$j.". ".$data1->agreeName); $pdf->Text(176,86,number_format($data1->Budget_agree,'2','.',',')); break;
case "3" : $pdf->Text(15,94.2,$j.". ".$data1->agreeName); $pdf->Text(176,94.2,number_format($data1->Budget_agree,'2','.',',')); break;
case "4" : $pdf->Text(15,102.8,$j.". ".$data1->agreeName); $pdf->Text(176,102.8,number_format($data1->Budget_agree,'2','.',',')); break;
case "5" : $pdf->Text(15,111,$j.". ".$data1->agreeName); $pdf->Text(176,111,number_format($data1->Budget_agree,'2','.',',')); break;
case "6" : $pdf->Text(15,119.5,$j.". ".$data1->agreeName); $pdf->Text(176,119.5,number_format($data1->Budget_agree,'2','.',',')); break;
case "7" : $pdf->Text(15,128,$j.". ".$data1->agreeName); $pdf->Text(176,128,number_format($data1->Budget_agree,'2','.',',')); break;
}
$j++;
}
}
//Create file
$pdf->Output();
?>
|