Gecko [ 122.154.134.11 ]

Name	Size	Permission
images	[ DIR ]	drwxr-xr-x
detail.php	2.98 KB	-rw-r--r--
index.php	969 B	-rw-r--r--
livesearch_201.php	17.56 KB	-rw-r--r--
report_1.php	29.01 KB	-rw-r--r--
report_2.php	27.99 KB	-rw-r--r--
sp1.php	59.17 KB	-rw-r--r--
sp2.php	6.04 KB	-rw-r--r--
sp3.php	5.98 KB	-rw-r--r--
std_detail3.php	7.95 KB	-rw-r--r--
std_detail4.php	8.99 KB	-rw-r--r--
teach_list.php	18.65 KB	-rw-r--r--
teach_report.php	9.8 KB	-rw-r--r--

Code Editor : teach_report.php

<?php
/** ensure this file is being included by a parent file */
defined( '_VALID_' ) or die( 'Direct Access to this location is not allowed.' );
$officer=$remote_user_id;
$school_code=$remote_user_office;
$person_id=$remote_user_id;
require_once "../time_inc.php";

?>
<style>
.button {
    background-color: #4CAF50; /* Green */
    border: none;
    color: white;
    padding: 5px 12px;
    text-align: center;
    text-decoration: none;
    display: inline-block;
    font-size: 13px;
    margin: 2px 1px;
    cursor: pointer;
}

.button2 {background-color: #008CBA;} /* Blue */
.button3 {background-color: #f44336;} /* Red */ 
.button4 {background-color: #e7e7e7; color: black;} /* Gray */ 
.button5 {background-color: #555555;} /* Black */
</style>

<?php
//ส่วนหัว
echo "<br />";
if(!(($index==2) or ($index==5))){
echo "<table width='70%' border='0' align='center'>";
echo "<tr align='center'><td><font color='#006666' size='3'><strong>ผลการจัดการเรียนการสอนครูรายบุคคล</strong></font></td></tr>";
echo "</table>";
}

echo "<form id='frm1' name='frm1'>";		
		echo "<input type='hidden' name='remote_user_office' value='$remote_user_office'>";
		echo "<input type='hidden' name='remote_user_id' value='$remote_user_id'>";
		echo "<input type='hidden' name='remote_login_status' value='$remote_login_status'>";
		echo "<input type='hidden' name='remote_sync' value='$remote_sync'>";
		
		echo  "<table width=90% border='0' align='center'>";
		echo "<Tr><td align='right'>";
		
	//เลือก	โรงเรียน
		echo "<Select  name='school_index' size='1' style='color: #009900' onchange='goto_index(1)'>";
		$sql = "select * from  system_school  order by  school_type,school_code";
		$dbquery = mysqli_query($connect,$sql);
		While ($result = mysqli_fetch_array($dbquery))
		   {
					if($remote_user_office==$result['school_code']){
								echo "<option value=$result[school_code] selected>$result[school_code] $result[school_name]</option>"; 
					}
			}
		echo "</select>";
		
		echo "</td></Tr>";
		echo "<Tr><td align='right'>";
		
		//เลือกบุคลากร
		echo "<Select  name='person_index' size='1' style='color: #009900' onchange='goto_index(2)'>";
		echo  "<option  value = ''>เลือกครูและบุคลากร</option>" ;
		$sql = "select * from  person_sch_main where school_code='$remote_user_office' and status='0' and (position_code='1' or position_code='2' or position_code='3' or position_code='11' or position_code='12' or position_code='31' or position_code='35')  order by position_code,name";

$dbquery = mysqli_query($connect,$sql);
		$prename=""; $name="";  $surname="";
		While ($result = mysqli_fetch_array($dbquery))
		   {
		   			if($remote_login_status>=4){
							if($result['person_id']==$remote_user_id){
							echo  "<option value = $result[person_id] selected>$result[name] $result[surname]</option>";
							$prename=$result['prename']; 
							$name=$result['name']; 
							$surname=$result['surname'];
							}
					}
					else{
							if($result['person_id']==$_REQUEST['person_index']){
							echo  "<option value = $result[person_id] selected>$result[name] $result[surname]</option>";
							$prename=$result['prename']; 
							$name=$result['name']; 
							$surname=$result['surname'];
							}
							else{
							echo  "<option value = $result[person_id]>$result[name] $result[surname]</option>";
						   }
					}	   
			}
		echo "</select>";
		echo "</td></Tr>";
		echo "</Table>";
echo "</form>";		
		//จบ

//ส่วนแสดงผล
if($index==1){
$person_id=$_POST['person_index'];

echo "<br>";
$subject_ar[99]="ทุกวิชาระดับประถมศึกษา";
$subject_ar[1]="ภาษาไทย";
$subject_ar[2]="คณิตศาสตร์";
$subject_ar[3]="วิทยาศาสตร์";
$subject_ar[4]="สังคมศึกษา";
$subject_ar[5]="สุขศึกษา";
$subject_ar[6]="ศิลปะ";
$subject_ar[7]="การงานอาชีพ";
$subject_ar[8]="ภาษาอังกฤษ";
$subject_ar[21]="อนุบาล";

$class_ar[1]="อนุบาล 1";
$class_ar[2]="อนุบาล 2";
$class_ar[3]="อนุบาล 3";
$class_ar[4]="ป.1";
$class_ar[5]="ป.2";
$class_ar[6]="ป.3";
$class_ar[7]="ป.4";
$class_ar[8]="ป.5";
$class_ar[9]="ป.6";
$class_ar[10]="ม.1";
$class_ar[11]="ม.2";
$class_ar[12]="ม.3";
$class_ar[13]="ม.4";
$class_ar[14]="ม.5";
$class_ar[15]="ม.6";

$sql = "select * from  student_main_edyear where year_active='1'";
$dbquery = mysqli_query($connect,$sql);
$result = mysqli_fetch_array($dbquery);
$active_year=$result['ed_year'];

//echo "<form id='frm1' name='frm1'>";
//echo "<input type='hidden' name='remote_user_office' value='$remote_user_office'>";
//echo "<input type='hidden' name='remote_user_id' value='$remote_user_id'>";
//echo "<input type='hidden' name='remote_login_status' value='$remote_login_status'>";
//echo "<input type='hidden' name='remote_sync' value='$remote_sync'>";

$M=0;
$X=1;
$div_show="";
for($x=$active_year-4; $x<$active_year; $x++ ){
$year=$active_year-$M;
echo  "<table width='70%' border='1' align='center' style='border-collapse: collapse'>";
echo "<Tr bgcolor='#EAECEE'><Td  align='center' colspan='4'><b>ปีการศึกษา $year ภาคเรียนที่ 1</b></Td>";
echo "<Tr bgcolor='#F5CBA7'><Td  align='center' width='150'>ชั้น</Td><Td  align='center' width='150'>ห้องที่</Td><Td  align='center'>วิชา</Td><td width='50' align='center'>แสดงผล</td></Tr>";

$sql_1 = "select * from supervision_teachtable where ed_year='$year' and term='1' and school='$school_code' and person_id='$person_id' order by class_level,room ";
$dbquery_1 = mysqli_query($connect,$sql_1);
while($result_1 = mysqli_fetch_array($dbquery_1)){
$X++;
$id=$result_1['id'];
$subject=$subject_ar[$result_1['subject']];
$class_level=$class_ar[$result_1['class_level']];

$a=1;
$b=$X;  
$e_id=$a."_".$b;

$yy=$a;
$xx=$b;

$div_show="$year";
$file_name="201";

echo "<Tr bgcolor='#FEF9E7'><Td  align='center' width='150'>$class_level</Td><Td  align='center' width='150'>$result_1[room]</Td><Td  align='center'>$subject</Td><td align='center'>";
if(!($result_1['subject']==5 or $result_1['subject']==6 or $result_1['subject']==7)){
echo "<span id='$e_id' onclick='displayFunction($yy,$xx,$school_code,$id,$file_name,$div_show,$person_id)' onmouseover='OverFunction($a,$b)'  onmouseout='OutFunction($a,$b)'><img src=../../../images/browse.png border='0' alt='แสดง'></span>";
}
echo "</td></Tr>";
}

echo "<Tr bgcolor='#EAECEE'><Td  align='center' colspan='4'><b>ปีการศึกษา $year ภาคเรียนที่ 2</b></Td>";

echo "<Tr bgcolor='#F5CBA7'><Td  align='center' width='150'>ชั้น</Td><Td  align='center' width='150'>ห้องที่</Td><Td  align='center'>วิชา</Td><td width='50' align='center'>แสดงผล</td></Tr>";

$sql_2 = "select * from supervision_teachtable where ed_year='$year' and term='2' and school='$school_code' and person_id='$person_id' order by class_level, room";
$dbquery_2 = mysqli_query($connect,$sql_2);
while($result_2 = mysqli_fetch_array($dbquery_2)){
$id=$result_2['id'];
$subject=$subject_ar[$result_2['subject']];
$class_level=$class_ar[$result_2['class_level']];
echo "<Tr bgcolor='#FEF9E7'><Td  align='center' width='150'>$class_level</Td><Td  align='center' width='150'>$result_2[room]</Td><Td  align='center'>$subject</Td><td align='center'><span id='$e_id' onclick='displayFunction($yy,$xx,$school_code,$id,$file_name,$div_show,$person_id)' onmouseover='OverFunction($a,$b)'  onmouseout='OutFunction($a,$b)'><img src=../../../images/browse.png border='0' alt='แสดง'></span></td></Tr>";
}
echo "</Table>";
echo "<br>";

echo "<div id='$div_show' style='display:block' align='center'></div>";
echo "<br>";  
$M++;
}
//echo "</form>";
}

?>
<script>
function goto_index(val){
	if(val==1){
		callfrm("?file=teach_report&index=1"); 
	}
	if(val==2){
		callfrm("?file=teach_report&index=1"); 
	}
}

function goto_url(val){
	if(val==0){
		callfrm("?file=teach_list"); 
	}else if(val==1){
			callfrm("?file=teach_list&index=4");
	}
}

function displayFunction(y,x,school,id,file_name,div_show,person) {

function new_windows(subject,person_id,level,ed_year){
window.open('std_detail3.php?subject='+subject+'&person_id='+person_id+'&level='+level+'&ed_year='+ed_year,'xx', 'width=1000,height=500,scrollbars');
}

function new_windows2(subject,school_code,ed_year,class_level,room,level,teacher){
window.open('std_detail4.php?subject='+subject+'&school_code='+school_code+'&ed_year='+ed_year+'&class_level='+class_level+'&room='+room+'&level='+level+'&teacher='+teacher,'xx', 'width=1000,height=500,scrollbars');
}

</script>

${this.title}

Code Editor : teach_report.php