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_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'];
$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'];
}

//////////////////////
//อาเรย์บุคลากร
$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;
}
//ส่วนหัว
"<br />";
$sql_name = "select * from person_main where person_id='$user'";
$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&nbsp;&nbsp;$surname";
 "<table width='100%' border='0' align='center'>";
 "<tr align='center'><td><font color='#006666' size='3'><strong>ทะเบียนขออนุญาตไปราชการ</strong></font></td></tr>";
 "<tr align='center'><td><font color='#006666' size='2'><strong>$full_name</strong></font></td></tr>";
 "</table>";
//ส่วนของการแยกหน้า
$sql="select id from permission_main where person_id='$user'";
$dbquery = mysqli_query($connect,$sql);
$num_rows = mysqli_num_rows($dbquery );
$pagelen=5;  // 1_กำหนดแถวต่อหน้า
$url_link="option=permission&task=main/print_report";  // 2_กำหนดลิงค์ฺ
$totalpages=ceil($num_rows/$pagelen);
if(!(isset($_REQUEST['page']))){
$_REQUEST['page']="";
}
if($_REQUEST['page']==""){
$page=$totalpages;
		if($page<2){
		$page=1;
		}
}
else{
		if($totalpages<$_REQUEST['page']){
		$page=$totalpages;
					if($page<1){
					$page=1;
					}
		}
		else{
		$page=$_REQUEST['page'];
		}
}
$start=($page-1)*$pagelen;
if(($totalpages>1) and ($totalpages<16)){
 "<div align=center>";
 "หน้า	";
			for($i=1; $i<=$totalpages; $i++)	{
					if($i==$page){
					"[<b><font size=+1 color=#990000>$i</font></b>]";
					}
					else {
					"<a href=$PHP_SELF?$url_link&page=$i>[$i]</a>";
					}
			}
 "</div>";
}			
if($totalpages>15){
			if($page <=8){
			$e_page=15;
			$s_page=1;
			}
			if($page>8){
					if($totalpages-$page>=7){
					$e_page=$page+7;
					$s_page=$page-7;
					}
					else{
					$e_page=$totalpages;
					$s_page=$totalpages-15;
					}
			}
			 "<div align=center>";
			if($page!=1){
			$f_page1=$page-1;
			 "<<a href=$PHP_SELF?$url_link&page=1>หน้าแรก </a>";
			 "<<<a href=$PHP_SELF?$url_link&page=$f_page1>หน้าก่อน </a>";
			}
			else {
			 "หน้า	";
			}					
			for($i=$s_page; $i<=$e_page; $i++){
					if($i==$page){
					 "[<b><font size=+1 color=#990000>$i</font></b>]";
					}
					else {
					 "<a href=$PHP_SELF?$url_link&page=$i>[$i]</a>";
					}
			}
			if($page<$totalpages)	{
			$f_page2=$page+1;
			 "<a href=$PHP_SELF?$url_link&page=$f_page2> หน้าถัดไป</a>>>";
			 "<a href=$PHP_SELF?$url_link&page=$totalpages> หน้าสุดท้าย</a>>";
			}
			 " <select onchange=\"location.href=this.options[this.selectedIndex].value;\" size=\"1\" name=\"select\">";
			 "<option  value=\"\">หน้า</option>";
				for($p=1;$p<=$totalpages;$p++){
				 "<option  value=\"?$url_link&page=$p\">$p</option>";
				}
			 "</select>";
 "</div>";  
}					
//จบแยกหน้า
$sql="select * from permission_main where person_id='$user' order by id limit $start,$pagelen";
$dbquery = mysqli_query($connect,$sql);

"<table width='95%' border='1' cellpadding='1' cellspacing='0' bordercolor='#333333' align='center'>";
 "<Tr><Td colspan='10' align='left'>";
?>
<?php
 "</Td><Td bgcolor='#FFCCCC' >กำลังปรับส่วนนี้ครับ</Td></Tr>";
 "<Tr bgcolor='#FFCCCC' align='center'><Td width='60'>เลขที่</Td><Td width='100'>วันขออนุญาต</Td><Td>เรื่องราชการ</Td><Td>สถานที่</Td><Td width='100'>วันไปราชการ</Td><Td width='100'>พาหนะ</Td><Td width='150'>ผู้ขออนุญาต</Td><Td width='120'>ความเห็นผู้บังคับบัญชา<br>ขั้นต้น</Td><Td width='150'>อนุมัติ/คำสั่ง</Td><Td width='60'>หมายเหตุ</Td><Td width='60'>พิมพ์</Td></Tr>";

$N=(($page-1)*$pagelen)+1; //*เกี่ยวข้องกับการแยกหน้า
$M=1;
While ($result = mysqli_fetch_array($dbquery)){
		$id_pa = $result['id'];
		$subject = $result['subject'];
		$place = $result['place'];
		$vehicle = $result['vehicle'];
		$ref_id = $result['ref_id'];
		$file = $result['document'];
		$comment = $result['comment'];
		$comment_person = $result['comment_person'];
		$grant = $result['grant_x'];
		$grant_comment = $result['grant_comment'];
		$grant_person = $result['grant_person'];
		$report = $result['report'];
		$rec_date = $result['rec_date'];
			if(($M%2) == 0)
			$color="#FFFFB";
			else  	$color="#FFFFFF";
 "<Tr bgcolor='$color'><Td valign='top' align='center'>$id_pa</Td><Td valign='top' align='left'>";
 thai_date_3($rec_date);
 "</Td><Td valign='top' align='left'>$subject</Td><Td valign='top' align='left' >$place</Td><Td valign='top' align='left'>";

$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);
	While ($result_date = mysqli_fetch_array($dbquery_date)){
		$date = $result_date['date'];
		 thai_date_3($date);
		 "<br />";
	}
 "</Td><Td valign='top' align='left'>$vehicle</Td>";
 "</Td><Td align='center'>";
 "<br>";
 "$full_name</Td>";
 "<Td valign='center' align='center'>";
if($comment_person != ""){
 "<font color='#339900'>$comment</font><br>";
		if(isset($person_ar[$comment_person])){
		 $person_ar[$comment_person];
		 "<br>";
		 thai_date_3($result['comment_date']);
		}
}
else{
 "";
}
 "</td>";

"<Td valign='center' align='center'>";
if($grant==1){
 "<img src=images/yes.png border='0'> อนุมัติ<br><font color='#339900'>$grant_comment</font><br>";
		if(isset($person_ar[$grant_person])){
		$person_ar[$grant_person];
		 "<br>";
		 thai_date_3($result['grant_date']);
		}
}
else if($grant==2){
 "<img src=images/no.png border='0'> ไม่อนุมัติ<br><font color='#990000'>$grant_comment</font><br>";
		if(isset($person_ar[$grant_person])){
		 $person_ar[$grant_person];
		 "<br>";
		 thai_date_3($result['grant_date']);
		}
}
else{
 "รออนุมัติ";
}
 "</Td><td><Td valign='top' align='center'><a href=modules/permission/fpdf/permission_print.php?id=$id_pa target='blank'><img src=images/b_print.png border='0' alt='พิมพ์' ></a></Td></td>";
 "</Tr>";

$M++;
$N++;  //*เกี่ยวข้องกับการแยกหน้า
}	
 "</Table>";

/////////////////////////// ชื่อ ผู้ขอไป
$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->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(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(5,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->SetXY(120,193);
$pdf->Image("$sign_pic",125,182,30,0);
//$pdf->Image('$sign_pic',125,182,35,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->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_report.php