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	-rw-r--r--
bg_sch2.png	176.43 KB	-rw-r--r--
changelog.htm	8.83 KB	-rw-r--r--
connect.php	436 B	-rw-r--r--
display.php	4.13 KB	-rw-r--r--
fpdf.css	1.31 KB	-rw-r--r--
fpdf.php	48.88 KB	-rw-r--r--
install.txt	547 B	-rw-r--r--
license.txt	326 B	-rw-r--r--
permission_print.php	8.35 KB	-rw-r--r--
permission_print_sch.php	13.12 KB	-rw-r--r--
permission_print_sch2.php	13.39 KB	-rw-r--r--
print_pdf_report.php	14.37 KB	-rw-r--r--
print_pdf_report2.php	7.82 KB	-rw-r--r--
print_report.php	15.14 KB	-rw-r--r--
report_2.php	13.42 KB	-rw-r--r--
time_inc.php	4.59 KB	-rw-r--r--

Code Editor : print_pdf_report.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_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_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'];
$file_id=$ref_result_id['document'];
$commentg_person_id=$ref_result_id['commentg_person'];
$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'];
}

//////////////////////
//อาเรย์บุคลากร
$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_person_per = "select * from person_main where person_id='$user'";
$dbquery_person_per = mysqli_query($connect,$sql_person_per);
$result_person_per = mysqli_fetch_array($dbquery_person_per);
		$person_id_per = $result_person_per['person_id'];
		$prename_per=$result_person_per['prename'];
		$name_per= $result_person_per['name'];
		$surname_per = $result_person_per['surname'];
		$position_code_per = $resultperson_per['position_code'];
$full_person_per="$prename$name $surname";

//////////////////////////////
$sql="select * from permission_main where id=$id order by id DESC ";
$dbquery = mysqli_query($connect,$sql);
$result = mysqli_fetch_array($dbquery);
		$id_pa = $result['id'];
		$subject = $result['subject'];
		$place = $result['place'];
		$withdraw = $result['withdraw'];
		$withdraw_form = $result['withdraw_form'];
		$vehicle = $result['vehicle'];
		$ref_id = $result['ref_id'];
		$file = $result['document'];
				$commentg = $result['commentg'];
				$commentg_person = $result['commentg_person'];
				$commentg_date = $result['commentg_date'];
				$commentgdate =  thai_date_3($commentg_date);
				
		$comment = $result['comment'];
		$comment_person = $result['comment_person'];
					$comment_date = $result['comment_date'];
					$commentdate =  thai_date_3($comment_date);
		$grant = $result['grant_x'];
		$grant_comment = $result['grant_comment'];
		$grant_person = $result['grant_person'];
		$report = $result['report'];
		$rec_date = $result['rec_date'];
		$grant_date = $result['grant_date'];
			$grantdate =  thai_date_3($grant_date);
	$sql_date="select * from permission_date where ref_id='$ref_id' and person_id='$user' order by date";
	$dbquery_date = mysqli_query($connect,$sql_date);
	$result_date = mysqli_fetch_array($dbquery_date);
		$date = $result_date['date'];
	$permis_date =  thai_date_3($date);
/*
	$sql_date="select * from permission_date where ref_id='$ref_id' order by date";
	$dbquery_date = mysqli_query($connect,$sql_date);
	While ($result_date = mysqli_fetch_array($dbquery_date)){
	$date = $result_date['date'];

}
*/

$thai_date_grant=thai_date_4($ref_result['grant_date']);

/////////////////////////// ชื่อ ผู้ขอไป
$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)));
//////สิ้นสุด วันแรกไป วันสุดท้ายไป 
///////////เช็คบ็อก ค่าใช้จ่าย1
if($file!=""){
"";
}
else{
 "";
}
"";
if($withdraw==1){
$withdraw1= "/";
}
else if($withdraw==2){
$withdraw1= "";
}
else{
"";
}
///////////////
///////////เช็คบ็อก ค่าใช้จ่าย2
if($file!=""){
"";
}
else{
 "";
}
"";
if($withdraw_==1){
$withdraw2= "";
}
else if($withdraw ==2){
$withdraw2= "/";
}
else{
"";
}
///////////////

/////////เรื่มต้นลายเซ็นผู้ขอไป
$sign_pic= $person_id ;
$sign_pic="signature/".$sign_pic.".png";
if(file_exists($sign_pic)){
}
else{
$sign_pic="signature/emty.png";
}
///////////////////สิ้นสุดลายเซ็นผู้ขอไป
////////////////ลายเซ็นต์ ผู้เห็นชอบ1
$sign_pic_commentg = $commentg_person ;
$sign_pic_commentg ="signature/".$sign_pic_commentg.".png";
if(file_exists($sign_pic_commentg)){
}
else{
$sign_pic_commentg ="signature/emty.png";
}
////////////////////////////////สิ้นสุดลายเซ็น ผู้เห็นชอบ1
////////////////ลายเซ็นต์ ผู้เห็นชอบ2
$sign_pic_comment = $comment_person ;
$sign_pic_comment ="signature/".$sign_pic_comment.".png";
if(file_exists($sign_pic_comment)){
}
else{
$sign_pic_comment ="signature/emty.png";
}
////////////////////////////////สิ้นสุดลายเซ็น ผู้เห็นชอบ2
///////////เช็คบ็อก อนุญาต

if($file!=""){
"";
}
else{
 "";
}
"";
if($grant==3){
 $ck3 = "/";
}
else if($grant==4){
$ck4 = "/"; 
}
if($grant==1){
$ck1= "/";
}
else if($grant==2){
$ck2= "/";
}
else{
"";
}
///////////////
/////////เรื่มต้นลายเซ็น ผอ เขต
$sign_pic_boss= $grant_person ;
$sign_pic_boss="signature/".$sign_pic_boss.".png";
if(file_exists($sign_pic_boss)){
}
else{
$sign_pic_boss="signature/emty.png";
}
////////////////////////////////สิ้นสุดลายเซ็น ผอ เขต

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

$pdf->Image('image/bg.png',0,0,210,297);

//$pdf->Image('image/logo.jpg',0,0,297,210);
//$pdf->Image('image/obec.jpg',133,10,30,0);

$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(37,53);
$pdf->Cell(0,8,"{$office_n}" , 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(15,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->Ln(75);
$pdf->SetFont("THSarabunPSK","",16); 
$pdf->SetXY(88,120);
$pdf->Cell(0,8,"{$withdraw1}" , 0 , 1 , 'L');

$pdf->Ln(75);
$pdf->SetFont("THSarabunPSK","",16); 
$pdf->SetXY(114,120);
$pdf->Cell(0,8,"{$withdraw2}" , 0 , 1 , 'L');

$pdf->Ln(75);
$pdf->SetFont("THSarabunPSK","",16); 
$pdf->SetXY(15,129);
$pdf->Cell(0,8,"{$withdraw_form}" , 0 , 1 , 'L');
//////////

//$pdf->SetXY(120,193);
$pdf->Image("$sign_pic",123,146,30,0);
//$pdf->Image('$sign_pic',125,182,35,0);

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

$pdf->SetFont("THSarabunPSK","",16); 
$pdf->SetXY(18,177);
$pdf->Cell(0,8,"{$result['commentg']}" , 0 , 1 , 'L');

$pdf->Image("$sign_pic_commentg",39,185,30,0);

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

$pdf->SetFont("THSarabunPSK","",16); 
$pdf->SetXY(40,204);
$pdf->Cell(0,8,"{$commentgdate}" , 0 , 1 , 'L');

$pdf->SetFont("THSarabunPSK","",16); 
$pdf->SetXY(18,232);
$pdf->Cell(0,8,"{$result['comment']}" , 0 , 1 , 'L');

$pdf->Image("$sign_pic_comment",39,243,30,0);

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

$pdf->SetFont("THSarabunPSK","",16); 
$pdf->SetXY(40,260);
$pdf->Cell(0,8,"{$commentdate}" , 0 , 1 , 'L');
//////เช็คบ็อก

$pdf->SetFont("THSarabunPSK","",16); 
$pdf->SetXY(114,189);
$pdf->Cell(0,8,"{$ck3}" , 0 , 1 , 'L');

$pdf->SetFont("THSarabunPSK","",16); 
$pdf->SetXY(114,197);
$pdf->Cell(0,8,"{$ck4}" , 0 , 1 , 'L');

$pdf->SetFont("THSarabunPSK","",16); 
$pdf->SetXY(114,207);
$pdf->Cell(0,8,"{$ck1}" , 0 , 1 , 'L');

$pdf->SetFont("THSarabunPSK","",16); 
$pdf->SetXY(114,215);
$pdf->Cell(0,8,"{$ck2}" , 0 , 1 , 'L');

//ความเห็น ผอ.เขต
$pdf->SetFont("THSarabunPSK","",16); 
$pdf->SetXY(126,229);
$pdf->Cell(0,8,"{$result[grant_comment]}" , 0 , 1 , 'L');

//$pdf->SetXY(120,193);
$pdf->Image("$sign_pic_boss",135,240,30,0);
//$pdf->Image('$sign_pic',125,182,35,0);

//////////////////ชื่อ ผอ เขต ปรากฏ ล่างลายเซ็น
$pdf->SetFont("THSarabunPSK","",16); 
$pdf->SetXY(130,249);
$pdf->Cell(0,8,"{$person_ar[$grant_person]}" , 0 , 1 , 'L');

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

$pdf->SetFont("THSarabunPSK","",16); 
$pdf->SetXY(138,268);
$pdf->Cell(0,8,"{$grantdate}" , 0 , 1 , 'L');

//$pdf->SetXY(120,193);
//$pdf->Image("$sign_pic",125,182,30,0);
//$pdf->Image('$sign_pic',125,182,35,0);

//$pdf->Ln(8);
//$pdf->SetFont("AngsanaNew","B",26); 
//$pdf->Cell(0,5," กิจกรรมส่งเสริมพัฒนาการด้านคณิตศาสตร์พื้นฐานเพื่อเตรียมความพร้อมสู่ประชาคมอาเซียน "  , 0 , 1 , 'C');

//$pdf->Ln(6);
//$pdf->SetFont("AngsanaNew","B",26); 
//$pdf->Cell(0,5,"และเตรียมความพร้อมในการสอบ O-NET ในวันที่ 1 ธันวาคม พ.ศ. 2557"  , 0 , 1 , 'C');

//$pdf->Ln(12);
//$pdf->SetFont("AngsanaNew","B",24); 
//$pdf->Cell(0,5,"ให้ไว้ ณ วันที่  1  ธันวาคม  พ.ศ. 2557"  , 0 , 1 , 'C');
//$pdf->Ln(20);

//$pdf->Image('image/sara2.jpg',142,160,24,0);

//$pdf->Ln(4);
//$pdf->SetFont("AngsanaNew","B",26); 
//$pdf->Cell(0,5,"ผู้อำนวยการสำนักงานเขตพื้นที่การศึกษามัธยมศึกษา เขต 28 "  , 0 , 1 , 'C');

$pdf->Output();

${this.title}

Code Editor : print_pdf_report.php