Gecko [ 122.154.134.11 ]

Name	Size	Permission
detail.php	3.16 KB	-rw-r--r--
indicator.php	30.6 KB	-rw-r--r--
livesearch1.php	795 B	-rw-r--r--
livesearch2.php	1.03 KB	-rw-r--r--
livesearch3.php	787 B	-rw-r--r--
livesearch4.php	1.02 KB	-rw-r--r--
livesearch_101.php	17.73 KB	-rw-r--r--
permission.php	11.16 KB	-rw-r--r--
report_1.php	31.11 KB	-rw-r--r--
report_2.php	29.43 KB	-rw-r--r--
report_3.php	21.18 KB	-rw-r--r--
report_4.php	5.9 KB	-rw-r--r--
report_5.php	4.04 KB	-rw-r--r--
sp1.php	62.26 KB	-rw-r--r--
sp1_mobile.php	50.04 KB	-rw-r--r--
sp2.php	6.59 KB	-rw-r--r--
sp3.php	5.75 KB	-rw-r--r--
sp4.php	5.23 KB	-rw-r--r--
standard.php	7.89 KB	-rw-r--r--
std_detail.php	8.18 KB	-rw-r--r--
std_detail2.php	9.22 KB	-rw-r--r--
supervision_activity.php	11.1 KB	-rw-r--r--
supervision_activity_number.ph...	10.05 KB	-rw-r--r--
supervision_activity_rate.php	5.49 KB	-rw-r--r--
supervision_item.php	11.3 KB	-rw-r--r--
supervision_year.php	11.12 KB	-rw-r--r--
teach_table.php	13.48 KB	-rw-r--r--

Code Editor : teach_table.php

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

<?php
if(!(isset($_REQUEST['school_index']))){
$_REQUEST['school_index']="";
}
$school_code=$_REQUEST['school_index'];

if(isset($_GET['school_code'])){
$_REQUEST['school_index']=$_GET['school_code'];
}

if(isset($_REQUEST['person_index'])){
$person_id=$_REQUEST['person_index'];
}
else{
$person_id="";
}

$sql = "select * from  person_sch_main  where school_code='$school_code' and person_id='$person_id'";
$dbquery = mysqli_query($connect,$sql);
if(!($result = mysqli_fetch_array($dbquery))){
$person_id="";
}

//ส่วนหัว
echo "<br />";
echo "<table width='60%' border='0' align='center'>";
echo "<tr align='center'><td><font color='#006666' size='3'><strong>ผลงานการจัดการเรียนการสอนของครูรายบุคคล</strong></font></td></tr>";
echo "</table>";
echo "<br>";

//ส่วนเลือกบุลากร
		echo "<form id='frm1' name='frm1'>";
		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)'>";
		echo  "<option  value = ''>เลือกโรงเรียน</option>" ;
		$sql = "select * from  system_school  order by  school_type,school_code";
		$dbquery = mysqli_query($connect,$sql);
		While ($result = mysqli_fetch_array($dbquery))
		   {
					if(($_SESSION['login_status']>10) and ($_SESSION['login_status']<=14)){
								if($_SESSION['user_school']==$result['school_code']){
								echo "<option value=$result[school_code] selected>$result[school_code] $result[school_name]</option>"; 
								}
					}
					else{
								if($_REQUEST['school_index']==$result['school_code']){
								echo "<option value=$result[school_code] selected>$result[school_code] $result[school_name]</option>"; 
								}
								else{
								echo "<option value=$result[school_code]>$result[school_code] $result[school_name]</option>"; 
								}
					}	
			}
		echo "</select>";
		
		if($_SESSION['login_status']<=4){
		?>
		พิมพ์ค้นหาโรงเรียน <input type="text" size="15" style="background: #C0F9BD" onkeyup="showResult(this.value)">&nbsp;หรือพิมพ์ค้นหาครูฯ <input type="text" size="15" style="background: #C0F9BD" onkeyup="showResult_2(this.value)">
		<div id="livesearch"></div><div id="livesearch_2"></div>
		<?php
		}
	
		echo "</td></Tr>";
		echo "<Tr><td align='right'>";
		
		//เลือกบุคลากร
		echo "<div id='person_display' style='display:none' 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 left join person_sch_position on person_sch_main.position_code= person_sch_position.position_code where school_code='$_REQUEST[school_index]' and status='0' and (person_sch_main.position_code='1' or person_sch_main.position_code='2' or person_sch_main.position_code='3' or person_sch_main.position_code='11' or person_sch_main.position_code='12' or person_sch_main.position_code='31' or person_sch_main.position_code='35') order by person_sch_main.position_code,person_sch_main.name";
		$dbquery = mysqli_query($connect,$sql);
		$prename=""; $name="";  $surname="";
		While ($result = mysqli_fetch_array($dbquery))
		   {
					if($result['person_id']==$_REQUEST['person_index']){
					echo  "<option value = $result[person_id] selected>$result[name] $result[surname] ($result[position_name])</option>";
					$prename=$result['prename']; 
					$name=$result['name']; 
					$surname=$result['surname'];
					}
					else{
					echo  "<option value = $result[person_id]>$result[name] $result[surname] ($result[position_name])</option>";
				   }
			}
		echo "</select>";
		echo "</div>";
	
		echo "</td></Tr>";
		echo "</Table>";
		if($_REQUEST['school_index']!=""){
		echo "<script>e_show();</script>"; 
		}
		//จบ
		echo "</form>";
 //end  ส่วนเลือกบุคลากร

//ส่วนแสดงผล
if(($school_code!="") and ($person_id!="")){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'];

$M=0;
$X=1;
$div_show="";
for($x=$active_year-4; $x<$active_year; $x++ ){
$year=$active_year-$M;
echo  "<table width='60%' border='1' align='center' style='border-collapse: collapse'>";
echo "<Tr bgcolor='#EAECEE'><Td  align='center' colspan='3'><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></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']];
echo "<Tr bgcolor='#FEF9E7'><Td  align='center' width='150'>$class_level</Td><Td  align='center' width='150'>$result_1[room]</Td>";

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

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

$div_show="$year";
$file_name="101";

if(!($result_1['subject']==5 or $result_1['subject']==6 or $result_1['subject']==7)){
		echo "<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)'>$subject</span></Td></Tr>";
		}
		else{
		echo "<Td  align='center'>$subject</Td></Tr>";
		}
}

echo "<Tr bgcolor='#EAECEE'><Td  align='center' colspan='3'><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></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)){
$X++;
$id=$result_2['id'];
$subject=$subject_ar[$result_2['subject']];  
$class_level=$class_ar[$result_2['class_level']];

$a=2;
$b=$X;  
$e_id=$a."_".$b;  
		if(!($result_2['subject']==5 or $result_2['subject']==6 or $result_2['subject']==7)){
		echo "<Tr bgcolor='#FEF9E7'><Td  align='center' width='150'>$class_level</Td><Td  align='center' width='150'>$result_2[room]</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)' onmouseover='OverFunction($a,$b)' onmouseout='OutFunction($a,$b)'>$subject</span></Td></Tr>";
		}
		else{
		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></Tr>";
		}
}
echo "</Table>";
echo "<br>"; 
echo "<div id='$div_show' style='display:block' align='center'></div>";
echo "<br>";  
$M++;
}
}

?>
<script>
function goto_index(val){
	if(val==1){
		callfrm("?option=supervision&task=main/teach_table&index=1"); 
	}
	if(val==2){
		callfrm("?option=supervision&task=main/teach_table&index=1"); 
	}
}

function goto_url(val){
	if(val==0){
		callfrm("?option=supervision&task=main/teach_table");   // page ย้อนกลับ 
	}else if(val==1){
			callfrm("?option=supervision&task=main/teach_table&index=4");   //page ประมวลผล
	}
}

function ajax_show_3(val1,val2,val3,child_table) { 
var livesearch="livesearch_"+val2+".php";
var display_button=val2+"_button";

if (window.XMLHttpRequest) {
    // code for IE7+, Firefox, Chrome, Opera, Safari
    xmlhttp=new XMLHttpRequest();
  } else {  // code for IE6, IE5
    xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
  xmlhttp.onreadystatechange=function() {
    if (this.readyState==4 && this.status==200) {
      document.getElementById(val2).innerHTML=this.responseText;
    }
  }
  xmlhttp.open("GET","modules/warroom/main/"+livesearch+"?q="+val1+"&val3="+val3,true);
  xmlhttp.send();
  
		if(document.getElementById(val2).style.display=="block"){
		document.getElementById(display_button).value="รายละเอียด";
		document.getElementById(display_button).style.backgroundColor = "#A9D0F5";
		document.getElementById(val2).style.display="none";
		document.getElementById(child_table).style.display="none";
		}
		else if(document.getElementById(val2).style.display=="none"){
		document.getElementById(display_button).value="ไม่แสดงรายละเอียด";
		document.getElementById(display_button).style.backgroundColor = "#F78181";
		document.getElementById(val2).style.display="block";
		}
}

function new_windows(subject,person_id,level,ed_year){
window.open('modules/supervision/main/std_detail.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('modules/supervision/main/std_detail2.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_table.php