Gecko [ 122.154.134.11 ]

Name	Size	Permission
doc	[ DIR ]	drwxr-xr-x
font	[ DIR ]	drwxr-xr-x
image	[ DIR ]	drwxr-xr-x
makefont	[ DIR ]	drwxr-xr-x
signature	[ DIR ]	drwxr-xr-x
tutorial	[ DIR ]	drwxr-xr-x
FAQ.htm	10.87 KB	-rwxr-xr-x
bg_sch2.png	176.43 KB	-rw-r--r--
changelog.htm	8.83 KB	-rwxr-xr-x
connect.php	436 B	-rwxr-xr-x
display.php	4.13 KB	-rwxr-xr-x
fpdf.css	1.31 KB	-rwxr-xr-x
fpdf.php	48.88 KB	-rwxr-xr-x
install.txt	547 B	-rwxr-xr-x
license.txt	326 B	-rwxr-xr-x
permission_print.php	8.35 KB	-rwxr-xr-x
permission_print_sch.php	13.12 KB	-rwxr-xr-x
permission_print_sch2.php	13.39 KB	-rwxr-xr-x
print_pdf_report.php	14.37 KB	-rwxr-xr-x
print_pdf_report2.php	7.82 KB	-rwxr-xr-x
print_report.php	15.14 KB	-rwxr-xr-x
report_2.php	13.42 KB	-rwxr-xr-x
time_inc.php	4.59 KB	-rwxr-xr-x

Code Editor : print_pdf_report2.php

<?php
session_start();
require("fpdf.php");
require_once "../../../amssplus_connect.php";
//require_once "connect.php";
mysqli_query($connect,"SET character_set_results=tis620");
mysqli_query($connect,"SET character_set_client=tis620");
mysqli_query($connect,"SET character_set_connection=tis620");
function thainumDigit($num){  
    return str_replace(array( '0' , '1' , '2' , '3' , '4' , '5' , '6' ,'7' , '8' , '9' ),  
    array( "๐" , "๑" , "๒" , "๓" , "๔" , "๕" , "๖" , "๗" , "๘" , "๙" ),  
    $num);  
}  
function thainumDigit2($num){  
    return str_replace(array( '01' , '02' , '03' , '04' , '05' , '06' ,'07' , '08' , '09' ),  
    array( "1" , "2" , "3" , "4" , "5" , "6" , "7" , "8" , "9" ),  
    $num);  
}  
$thai_month_arr=array(
	"01"=>"มกราคม",
	"02"=>"กุมภาพันธ์",
	"03"=>"มีนาคม",
	"04"=>"เมษายน",
	"05"=>"พฤษภาคม",
	"06"=>"มิถุนายน",	
	"07"=>"กรกฎาคม",
	"08"=>"สิงหาคม",
	"09"=>"กันยายน",
	"10"=>"ตุลาคม",
	"11"=>"พฤศจิกายน",
	"12"=>"ธันวาคม"					
);
require_once "time_inc.php";	
$id=$_GET['id'];
$user=$_SESSION['login_user_id'];
require_once "time_inc.php";

$sql_person = "select  * from  person_main where  status='0' ";
$dbquery_person = mysqli_query($connect,$sql_person);
While ($result_person = mysqli_fetch_array($dbquery_person)){
$fullname=$result_person['prename'].$result_person['name']." ".$result_person['surname'];
$person_ar[$result_person['person_id']]=$fullname;
}
////////////////////สำนักงานเขต
$sql_office = "select * from system_office_name";
$result_office = mysqli_query($connect,$sql_office);
$oj__office = mysqli_fetch_array($result_office);
$office_name=$oj__office['office_name'];
$office_n=thainumDigit2($office_name);
///////////////

$sql_subject = "select * from permission_main  where id = $id ";
$result_subject = mysqli_query($connect,$sql_subject);
$oj__subject = mysqli_fetch_array($result_subject);
$subject_name=$oj__subject['subject'];
$subject_n=($subject_name);

echo $oj__subject;

/////////////////////////////// เกี่ยวกับผู้ขอไปรับค่ามา ด้วย ไอดี
$sql_id = "select * from permission_main where id = ".$id; //ปรับใหม่ให้ตัดเครื่องหมาย ' ' ออก เพราะว่าข้อมูลเป็นชนิดตัวเลขจะไม่ต้องใส
$dbquery_id = mysqli_query($connect,$sql_id);
While ($ref_result_id = mysqli_fetch_array($dbquery_id)){
$id_id=$ref_result_id['id'];
$person_id=$ref_result_id['person_id'];
$ref_id=$ref_result_id['ref_id'];
$subject_id=$subject_result_id['subject'];
$file_id=$ref_result_id['document'];
$place_id=$place_result_id['place'];
$vehicle_id=$vehicle_result_id['vehicle'];
$grant_person_selected_id=$ref_result_id['grant_person_selected'];
$comment_person_id=$ref_result_id['comment_person'];
$grant_person_id=$ref_result_id['grant_person'];
$report_id=$ref_result_id['report'];
$rec_date_id=$ref_result_id['rec_date'];
}
//echo $sql_id ;
/////////////////////////// ชื่อ ผู้ขอไป
$sql_name = "select * from person_main where person_id=$person_id ";
$dbquery_name = mysqli_query($connect,$sql_name);
$result_name = mysqli_fetch_array($dbquery_name);
		$person_id = $result_name['person_id'];
		$prename=$result_name['prename'];
		$name= $result_name['name'];
		$surname = $result_name['surname'];
		$position_code = $result_name['position_code'];
$full_name="$prename$name   $surname";
/////สิ้นสุดชื่อ ผู้ขอไป  
/////เริ่มชื่อตำแหน่ง ตัวเลขภาษาไทย   
$sql_post = "select * from  person_position where position_code='$position_code'";
$dbquery_post = mysqli_query($connect,$sql_post);
$result_post = mysqli_fetch_array($dbquery_post);
$position_name= (thainumDigit($result_post['position_name']));
/////สิ้นสุดชื่อตำแหน่ง ตัวเลขภาษาไทย   
////////////////////////////////วันแรกไป
$sql_st_date="select * from permission_date  where ref_id='$ref_id' and person_id='$user' order by date " ;
	$dbquery_st_date = mysqli_query($connect,$sql_st_date);
	$result_st_date = mysqli_fetch_array($dbquery_st_date);
	$st_date = $result_st_date['date'];
$st_date =  (thainumDigit2(thai_date_2($st_date)));
////////////////////////////////วันสุดท้ายไป
$sql_end_date="select * from permission_date  where ref_id='$ref_id' and person_id='$user' order by date DESC" ;
	$dbquery_end_date = mysqli_query($connect,$sql_end_date);
	$result_end_date = mysqli_fetch_array($dbquery_end_date);
	$end_date = $result_end_date['date'];
$end_date =  (thainumDigit2(thai_date_2($end_date)));
$reccode_date =  (thainumDigit2(thai_date_2($rec_date)));
//////สิ้นสุด วันแรกไป วันสุดท้ายไป 
/////////เรื่มต้นลายเซ็นผู้ขอไป
$sign_pic= $person_id ;
$sign_pic="signature/".$sign_pic.".png";
if(file_exists($sign_pic)){
}
else{
$sign_pic="signature/emty.png";
}
///////////////////สิ้นสุดลายเซ็นผู้ขอไป
$prrrrrrrrr = $person_ar[$grant_person] ;
////////////////ลายเซ็นต์ ผอ เขต เริ่มตัวแปร รอรับจากข้างบน ยังไม่เสร็จ 
$sign_pic_boss= $person_ar[$grant_person] ;
$sign_pic_boss="signature/".$sign_pic_boss.".png";
if(file_exists($sign_pic_boss)){
}
else{
$sign_pic_boss="signature/emty.png";
}
////////////////////////////////ค้างลายเซ็นผอ

//echo $id ;

$pdf=new FPDF( 'P' , 'mm' , 'A4' );
$pdf->AddPage();
/*
   เพิ่ม Font เข้ามาเท่าที่จะใช้เพราะจะทำ
   ให้ไฟล์ pdf ของเรามีขนาดใหญ่
*/
$pdf->AddFont("THSarabunPSK","","THSarabun.php");
$pdf->AddFont("THSarabunPSK","B","THSarabun Bold.php");
//กำหนดแบบอักษร
$pdf->Image('image/bg.png',0,0,210,297);

$pdf->Ln(10);
$pdf->SetFont("THSarabunPSK","",16); 
$pdf->SetXY(33,23);
$pdf->Cell(0,8,"{$office_n}" , 0 , 1 , 'L');

$pdf->Ln(10);
$pdf->SetFont("THSarabunPSK","",16); 
$pdf->SetXY(105,30);
$pdf->Cell(0,8,"{$reccode_date}" , 0 , 1 , 'L');

$pdf->Ln(10);
$pdf->SetFont("THSarabunPSK","",16); 
$pdf->SetXY(58,62);
$pdf->Cell(0,8,"{$full_name}" , 0 , 1 , 'L');

$pdf->Ln(10);
$pdf->SetFont("THSarabunPSK","",16); 
$pdf->SetXY(139,62);
$pdf->Cell(0,8,"{$position_name}" , 0 , 1 , 'L');

$pdf->Ln(10);
$pdf->SetFont("THSarabunPSK","",16); 
$pdf->SetXY(20,70);
$pdf->Cell(0,8,"{$school_name}" , 0 , 1 , 'L');

$pdf->Ln(10);
$pdf->SetFont("THSarabunPSK","",16); 
$pdf->SetXY(16,70);
$pdf->Cell(0,8,"{$office_n}" , 0 , 1 , 'L');

$pdf->Ln(75);
$pdf->SetFont("THSarabunPSK","",16); 
$pdf->SetXY(13,78);
$pdf->Cell(0,8,"{$subject}" , 0 , 1 , 'L');

$pdf->Ln(75);
$pdf->SetFont("THSarabunPSK","",16); 
$pdf->SetXY(10,86);
$pdf->Cell(0,8,"{$place}" , 0 , 1 , 'L');

$pdf->Ln(75);
$pdf->SetFont("THSarabunPSK","",16); 
$pdf->SetXY(132,93);
$pdf->Cell(0,8,"{$st_date}" , 0 , 1 , 'L');

$pdf->Ln(75);
$pdf->SetFont("THSarabunPSK","",16); 
$pdf->SetXY(10,101);
$pdf->Cell(0,8,"{$end_date}" , 0 , 1 , 'L');

$pdf->Ln(75);
$pdf->SetFont("THSarabunPSK","",16); 
$pdf->SetXY(50,109);
$pdf->Cell(0,8,"{$vehicle}" , 0 , 1 , 'L');

$pdf->Image("$sign_pic",125,182,30,0);

$pdf->SetFont("THSarabunPSK","",16); 
$pdf->SetXY(120,195);
$pdf->Cell(0,8,"{$full_name}" , 0 , 1 , 'L');

$pdf->SetFont("THSarabunPSK","",16); 
$pdf->SetXY(125,263);
$pdf->Cell(0,8,"{$person_ar[$grant_person]}" , 0 , 1 , 'L');

$pdf->SetFont("THSarabunPSK","",16); 
$pdf->SetXY(125,258);
$pdf->Cell(0,8,"{$subject_getid}" , 0 , 1 , 'L');
$pdf->Output();

${this.title}

Code Editor : print_pdf_report2.php