Gecko [ 122.154.134.11 ]

Name	Size	Permission
images	[ DIR ]	drwxr-xr-x
install	[ DIR ]	drwxr-xr-x
manual	[ DIR ]	drwxr-xr-x
picture	[ DIR ]	drwxr-xr-x
default.php	485 B	-rwxr-xr-x
index.php	745 B	-rwxr-xr-x
menu.php	3.91 KB	-rwxr-xr-x
menu_mobile.php	963 B	-rwxr-xr-x
permission.php	8.74 KB	-rwxr-xr-x
permission_sch.php	9.93 KB	-rwxr-xr-x
permission_sch_khet.php	14.62 KB	-rwxr-xr-x
pic_show.php	1.73 KB	-rwxr-xr-x
pic_show2.php	655 B	-rwxr-xr-x
return_permission_sch_khet.php	1.2 KB	-rwxr-xr-x
student_khet_career.php	91.08 KB	-rwxr-xr-x
student_sch_career.php	106.32 KB	-rwxr-xr-x
student_sch_career_report1.php	40.91 KB	-rwxr-xr-x
student_sch_career_report1_mob...	19.73 KB	-rwxr-xr-x
student_sch_career_report2.php	43.59 KB	-rwxr-xr-x
student_sch_career_report3.php	9.83 KB	-rwxr-xr-x
student_sch_career_report3_mob...	4.01 KB	-rwxr-xr-x
time_inc.php	4.99 KB	-rwxr-xr-x

Code Editor : student_sch_career_report3.php

<?php
/** ensure this file is being included by a parent file */
defined( '_VALID_' ) or die( 'Direct Access to this location is not allowed.' );

//ปีงบประมาณ
$sql = "select * from  student_main_edyear  where year_active='1' order by  ed_year desc limit 1";
$dbquery = mysqli_query($connect,$sql);
$year_active_result = mysqli_fetch_array($dbquery);
if($year_active_result['ed_year']==""){
echo "<br />";
echo "<div align='center'>ยังไม่ได้กำหนดทำงานในปีการศึกษาใด ๆ  กรุณาไปที่เมนูตั้งค่าระบบ เพื่อกำหนดปีการศึกษา</div>";
exit();
}
echo "<br>";
echo "<table width='50%' border='0' align='center'>";
echo "<tr align='center'><td><font color='#006666' size='3'><strong>สรุปจำนวนนักเรียนระบบการศึกษาต่อและเลือกอาชีพ ปีการศึกษา  $year_active_result[ed_year]</strong></font></td></tr>";
echo "</table>";

$sql = "select  * from system_school order by school_type,school_code";
$dbquery = mysqli_query($connect,$sql);
echo  "<table width=90% border='0' align='center'>";
echo "<Tr bgcolor=#FFCCCC align='center' ><Td width='50'>ที่</Td><Td align='center'>
โรงเรียน</Td><Td>ไม่ระบุ</Td><Td>นิยมความจริง</Td><Td>ชอบค้นหา</Td><Td>ใฝ่ศิลปะ</Td><Td>ชอบสังคม</Td><Td>อนุรักษ์นิยม</Td><Td>แคล่วคล่องว่องไว</Td><Td>มุ่งเน้นประกอบอาชีพอิสระ </Td><Td>ศิลปินใฝ่สังคม</Td><Td>ศิลปินเจ้าระเบียบ </Td><Td>ผู้บริหารนอกกรอบ</Td><Td>ผู้สร้างสรรค์ศิลปะ</Td><Td>นักจัดระเบียบสังคม </Td><Td>นักสังคมผู้คล่องแคล่ว</Td><Td>นักธุรกิจผู้กว้างขวาง</Td><Td>นักบริหารผู้เคร่งครัด </Td><Td>เน้นวินัยใฝ่ประกอบการ </Td><Td>นักธุรกิจยุคใหม่</Td><Td>นักวิทยาศาสตร์ผู้ลงแรง  </Td>
<Td>ศิลปินผู้ขยัน</Td><Td>นักลงมือทำใฝ่สังคม</Td><Td>นักลงมือทำผู้เคร่งครัด</Td><Td>ผู้นำภาคสนาม</Td><Td>ศิลปินช่างคิด </Td><Td>นักวิทยาศาสตร์ใฝ่สังคม</Td><Td>นักวิทยาศาสตร์เจ้าระเบียบ </Td><Td>ผู้นำนักค้นคว้า </Td><Td>นายช่างนักธุรกิจ </Td><Td>นักวิทยาศาสตร์รักอิสระ</Td><td>รวม</td></Tr>";
$M=1;
			$total_0="";
			$total_1="";
			$total_2="";
			$total_3="";
			$total_4="";
			$total_5="";
			$total_6="";
			$total_7="";
			$total_8="";
			$total_9="";
			$total_10="";
			$total_11="";
			$total_12="";
			$total_13="";
			$total_14="";
			$total_15="";
			$total_16="";
			$total_17="";
			$total_18="";
			$total_19="";
			$total_20="";
			$total_21="";
			$total_22="";
			$total_23="";
			$total_24="";
			$total_25="";
			$total_26="";
			$total_27="";
			$total_28="";
			$sum_total="";

While ($result = mysqli_fetch_array($dbquery))
	{
			if(($M%2) == 0)
			$color="#FFFFC";
			else  	$color="#FFFFF";
			$id=$result['id'];
			$sql2 = "select  career_type, COUNT(career_student_main.id) as num  from  career_student_main left join student_main_main on career_student_main.person_id=student_main_main.person_id where student_main_main.ed_year='$year_active_result[ed_year]' and career_student_main.school_code='$result[school_code]' and student_main_main.school_code='$result[school_code]' group by career_type ";
			$dbquery2 = mysqli_query($connect,$sql2);
			$career_0="";
			$career_1="";
			$career_2="";
			$career_3="";
			$career_4="";
			$career_5="";
			$career_6="";
			$career_7="";
			$career_8="";
			$career_9="";
			$career_10="";
			$career_11="";
			$career_12="";
			$career_13="";
			$career_14="";
			$career_15="";
			$career_16="";
			$career_17="";
			$career_18="";
			$career_19="";
			$career_20="";
			$career_21="";
			$career_22="";
			$career_23="";
			$career_24="";
			$career_25="";
			$career_26="";
			$career_27="";
			$career_28="";
			$total=0;
			While ($result2 = mysqli_fetch_array($dbquery2)){
					if($result2['career_type']==0){
					$career_0=$result2['num'];
					}
					if($result2['career_type']==1){
					$career_1=$result2['num'];
					}
					if($result2['career_type']==2){
					$career_2=$result2['num'];
					}
					if($result2['career_type']==3){
					$career_3=$result2['num'];
					}
					if($result2['career_type']==4){
					$career_4=$result2['num'];
					}
					if($result2['career_type']==5){
					$career_5=$result2['num'];
					}
					if($result2['career_type']==6){
					$career_6=$result2['num'];
					}
					if($result2['career_type']==7){
					$career_7=$result2['num'];
					}
					if($result2['career_type']==8){
					$career_8=$result2['num'];
					}
					if($result2['career_type']==9){
					$career_9=$result2['num'];
					}
					if($result2['career_type']==10){
					$career_10=$result2['num'];
					}
					if($result2['career_type']==11){
					$career_11=$result2['num'];
					}
					if($result2['career_type']==12){
					$career_12=$result2['num'];
					}
					if($result2['career_type']==13){
					$career_13=$result2['num'];
					}
					if($result2['career_type']==14){
					$career_14=$result2['num'];
					}
					if($result2['career_type']==15){
					$career_15=$result2['num'];
					}
					if($result2['career_type']==16){
					$career_16=$result2['num'];
					}
					if($result2['career_type']==17){
					$career_17=$result2['num'];
					}
					if($result2['career_type']==18){
					$career_18=$result2['num'];
					}
					if($result2['career_type']==19){
					$career_19=$result2['num'];
					}
					if($result2['career_type']==20){
					$career_20=$result2['num'];
					}
					if($result2['career_type']==21){
					$career_21=$result2['num'];
					}
					if($result2['career_type']==22){
					$career_22=$result2['num'];
					}
					if($result2['career_type']==23){
					$career_23=$result2['num'];
					}
					if($result2['career_type']==24){
					$career_24=$result2['num'];
					}
					if($result2['career_type']==25){
					$career_25=$result2['num'];
					}
					if($result2['career_type']==26){
					$career_26=$result2['num'];
					}
					if($result2['career_type']==27){
					$career_27=$result2['num'];
					}
					if($result2['career_type']==28){
					$career_28=$result2['num'];
					}

}
			$total=$career_0+$career_1+$career_2+$career_3+$career_4+$career_5+$career_6+$career_7+$career_8+$career_9+$career_10+$career_11+$career_12+$career_13+$career_14+$career_15+$career_16+$career_17+$career_18+$career_19+$career_20+$career_21+$career_22+$career_23+$career_24+$career_25+$career_26+$career_27+$career_28;
			$total_0=$total_0+$career_0;
			$total_1=$total_1+$career_1;
			$total_2=$total_2+$career_2;
			$total_3=$total_3+$career_3;
			$total_4=$total_4+$career_4;
			$total_5=$total_5+$career_5;
			$total_6=$total_6+$career_6;
			$total_7=$total_7+$career_7;
			$total_8=$total_8+$career_8;
			$total_9=$total_9+$career_9;
			$total_10=$total_10+$career_10;
			$total_11=$total_11+$career_11;
			$total_12=$total_12+$career_12;
			$total_13=$total_13+$career_13;
			$total_14=$total_14+$career_14;
			$total_15=$total_15+$career_15;
			$total_16=$total_16+$career_16;
			$total_17=$total_17+$career_17;
			$total_18=$total_18+$career_18;
			$total_19=$total_19+$career_19;
			$total_20=$total_20+$career_20;
			$total_21=$total_21+$career_21;
			$total_22=$total_22+$career_22;
			$total_23=$total_23+$career_23;
			$total_24=$total_24+$career_24;
			$total_25=$total_25+$career_25;
			$total_26=$total_26+$career_26;
			$total_27=$total_27+$career_27;
			$total_28=$total_28+$career_28;
			$sum_total=$sum_total+$total;
			
	if($total>0){			
	echo "<Tr bgcolor=$color align='center'><Td>$M</Td>";
	echo "<Td align='left'><a href=?option=career_student&task=student_sch_career_report2&school=$result[school_code]>$result[school_name]</a></Td>";

echo "<Td>$career_0</Td><td>$career_1</td><td>$career_2</td><td>$career_3</td><td>$career_4</td><td>$career_5</td><td>$career_6</td><td>$career_7</td><td>$career_8</td><td>$career_9</td>
	
	<Td>$career_10</Td><td>$career_11</td><td>$career_12</td><td>$career_13</td><td>$career_14</td><td>$career_15</td><td>$career_16</td><td>$career_17</td><td>$career_18</td><td>$career_19</td>

<Td>$career_20</Td><td>$career_21</td><td>$career_22</td><td>$career_23</td><td>$career_24</td><td>$career_25</td><td>$career_26</td><td>$career_27</td><td>$career_28</td>

<td>$total</td>";
	echo "</Tr>";
	$M++;
	}
}
echo "<Tr bgcolor='#99FFFF' align='center'><td colspan='2'>รวม</td><Td>$total_0</Td>

<td>$total_1</td><td>$total_2</td><td>$total_3</td><td>$total_4</td><td>$total_5</td><td>$total_6</td><td>$total_7</td><td>$total_8</td><td>$total_9</td><td>$total_10</td>

<td>$total_11</td><td>$total_12</td><td>$total_13</td><td>$total_14</td><td>$total_15</td><td>$total_16</td><td>$total_17</td><td>$total_18</td><td>$total_19</td><td>$total_20</td>

<td>$total_21</td><td>$total_22</td><td>$total_23</td><td>$total_24</td><td>$total_25</td><td>$total_26</td><td>$total_27</td><td>$total_28</td><td>$sum_total</td>

</tr>";
echo "</Table>";
?>

${this.title}

Code Editor : student_sch_career_report3.php