Software: Apache/2.2.3 (CentOS). PHP/5.1.6 

uname -a: Linux mx-ll-110-164-51-230.static.3bb.co.th 2.6.18-194.el5PAE #1 SMP Fri Apr 2 15:37:44
EDT 2010 i686 

uid=48(apache) gid=48(apache) groups=48(apache) 

Safe-mode: OFF (not secure)

/var/www/html/report/person/   drwxr-xr-x
Free 52.36 GB of 127.8 GB (40.97%)
                            Encoder    Tools    Proc.    FTP brute    Sec.    SQL    PHP-code    Update    Feedback    Self remove    Logout    

Viewing file:     detailperfi.php (13.41 KB)      -rw-r--r--

0 ";
$result1 = $conn->query($query1);
$query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9
FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND ac_hour_in<>0 ";
$result3 = $conn->query($query3);
while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);}
}
//จำนวนชั่วโมงวิชาชีพ(พัฒนาภายใน)
if($case==2){
	$query1 = "SELECT * FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND pr_hour_in<>0 ";
	$result1 = $conn->query($query1);
	$query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9
	FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND pr_hour_in<>0 ";
	$result3 = $conn->query($query3);
	while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);}
}
//จำนวนชั่วโมงคุณธรรมจริยธรรม(พัฒนาภายใน)
if($case==3){
	$query1 = "SELECT * FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND moral_hour_in<>0 ";
	$result1 = $conn->query($query1);
	$query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9
	FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND moral_hour_in<>0 ";
	$result3 = $conn->query($query3);
	while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);}
}
//จำนวนชั่วโมงวิชาการ(พัฒนาภายนอก) ใช้งบ
if($case==4){
	$query1 = "SELECT * FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND ac_hour_outbudget<>0  AND ac_money<>0 ";
	$result1 = $conn->query($query1);
	$query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9
	FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND ac_hour_outbudget<>0  AND ac_money<>0 ";
	$result3 = $conn->query($query3);
	while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);}
}
//จำนวนชั่วโมงวิชาชีพ(พัฒนาภายนอก) ใช้งบ
if($case==5){
	$query1 = "SELECT * FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND pr_hour_outbudget<>0  AND pr_money<>0 ";
	$result1 = $conn->query($query1);
	$query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9
	FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND pr_hour_outbudget<>0  AND pr_money<>0 ";
	$result3 = $conn->query($query3);
	while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);}
}

//จำนวนชั่วโมงคุณธรรมจริยธรรม(พัฒนาภายนอก) ใช้งบ
if($case==6){
	$query1 = "SELECT * FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND moral_hour_outbudget<>0 AND  moral_money<>0 ";
	$result1 = $conn->query($query1);
	$query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9
	FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND moral_hour_outbudget<>0 AND  moral_money<>0 ";
	$result3 = $conn->query($query3);
	while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);}
}

//จำนวนชั่วโมงวิชาการ(พัฒนาภายนอกไม่ใช้งบ)
if($case==7){
	$query1 = "SELECT * FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND ac_hour_out<>0 ";
	$result1 = $conn->query($query1);
	$query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9
	FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND ac_hour_out<>0 ";
	$result3 = $conn->query($query3);
	while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);}
	}
//จำนวนชั่วโมงวิชาชีพ(พัฒนาภายนอกไม่ใช้งบ)
	if($case==8){
		$query1 = "SELECT * FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND pr_hour_out<>0 ";
		$result1 = $conn->query($query1);
		$query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9
		FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND pr_hour_out<>0 ";
		$result3 = $conn->query($query3);
		while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);}
	}
//จำนวนชั่วโมงคุณธรรมจริยธรรม(พัฒนาภายนอกไม่ใช้งบ)
	if($case==9){
		$query1 = "SELECT * FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND moral_hour_out<>0 ";
		$result1 = $conn->query($query1);
		$query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9
		FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND moral_hour_out<>0 ";
		$result3 = $conn->query($query3);
		while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);}
	}

$query2 = "SELECT * FROM persontb  WHERE personCode=$id ";
$result2 = $conn->query($query2);
while($values = $result2->fetch_assoc()){$name=$values['name']." ".$values['surName'];}



?>


  



    
    


fetch_assoc()){
				
			  ?>
			  

		  

			

				
ข้อมูลจำนวนชั่วโมงวิชาการวิชาชีพและคุณธรรมจริยธรรม จำแนกตามปีการศึกษา   ของ 
			
			

			  
ครั้งที่
			  
ชื่อโครงการที่เข้าร่วม
			  
เริ่มต้น
			  
สิ้นสุด
			  
ชม.วก.
			  
ชม.วช.
			  
ชม.คธ.
			  
เงิน วก.
			  
เงิน วช.
			  
เงิน คธ.
			  
รวมเงิน
			  
รวมชั่วโมง
			  
% รายโครงการ
			  
		  
		  

			  

		 	  

			  

			  

			  

			  

			  

			  

			  

			  

			  

			  

			  

			  
%
			  
			  
			  

			  
รวมทั้งหมด
			  

			  

			  

			  

			  

			  

			  

			  

			  

			  
		  




bool(false)