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_list.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 "<tr align='center'><td><font color='#006666' size='2'>(ข้อมูลวิชาที่สอนจะช่วยคัดกรองข้อมูลเฉพาะในวิชาที่สอนมาแสดง)</font></td></tr>";
echo "</table>";
}

//ส่วนยืนยันการลบข้อมูล
if($index==2) {
echo "<table width='500' border='0' align='center'>";
echo "<tr><td align='center'><font color='#990000' size='4'>โปรดยืนยันความต้องการลบข้อมูลอีกครั้ง</font><br></td></tr>";
echo "<tr><td align=center>";
echo "<INPUT TYPE='button' name='smb' value='ยืนยัน' onclick='location.href=\"?file=teach_list&index=3&id=$_GET[id]&remote_user_office=$remote_user_office&remote_user_id=$remote_user_id&remote_login_status=$remote_login_status&remote_sync=$remote_sync\"'>
		&nbsp;&nbsp;<INPUT TYPE='button' name='back' value='ยกเลิก' onclick='location.href=\"?file=teach_list&remote_user_office=$remote_user_office&remote_user_id=$remote_user_id&remote_login_status=$remote_login_status&remote_sync=$remote_sync\"'";
echo "</td></tr></table>";
}

//ส่วนลบข้อมูล
if($index==3){
$sql = "delete from supervision_teachtable where id=$_GET[id]";
$dbquery = mysqli_query($connect,$sql);
}

//ส่วนบันทึกข้อมูล
if($index==4){
$rec_date = date("Y-m-d");

//ปีที่ 0
		$year0=$_POST['year0']; 
		if(($_POST["class_level-$year0-1"]!="") and ($_POST["room-$year0-1"]!="") and ($_POST["subject-$year0-1"]!="")){
		$class_level=$_POST["class_level-$year0-1"];
		$room=$_POST["room-$year0-1"];
		$subject=$_POST["subject-$year0-1"];
		$sql = "insert into supervision_teachtable (person_id, school, ed_year, term, subject, class_level, room, rec_date, officer) values ('$person_id', '$school_code', '$year0', '1', '$subject', '$class_level', '$room', '$rec_date', '$officer')";
		$dbquery = mysqli_query($connect,$sql);
		}
		if(($_POST["class_level-$year0-2"]!="") and ($_POST["room-$year0-2"]!="") and ($_POST["subject-$year0-2"]!="")){
		$class_level=$_POST["class_level-$year0-2"];
		$room=$_POST["room-$year0-2"];
		$subject=$_POST["subject-$year0-2"];
		$sql = "insert into supervision_teachtable (person_id, school, ed_year, term, subject, class_level, room, rec_date, officer) values ('$person_id', '$school_code', '$year0', '2', '$subject', '$class_level', '$room', '$rec_date', '$officer')";
		$dbquery = mysqli_query($connect,$sql);
		}
	
		//ปีที่ 1
		$year1=$_POST['year1']; 
		if(($_POST["class_level-$year1-1"]!="") and ($_POST["room-$year1-1"]!="") and ($_POST["subject-$year1-1"]!="")){
		$class_level=$_POST["class_level-$year1-1"];
		$room=$_POST["room-$year1-1"];
		$subject=$_POST["subject-$year1-1"];
		$sql = "insert into supervision_teachtable (person_id, school, ed_year, term, subject, class_level, room, rec_date, officer) values ('$person_id', '$school_code', '$year1', '1', '$subject', '$class_level', '$room', '$rec_date', '$officer')";
		$dbquery = mysqli_query($connect,$sql);
		}
		if(($_POST["class_level-$year1-2"]!="") and ($_POST["room-$year1-2"]!="") and ($_POST["subject-$year1-2"]!="")){
		$class_level=$_POST["class_level-$year1-2"];
		$room=$_POST["room-$year1-2"];
		$subject=$_POST["subject-$year1-2"];
		$sql = "insert into supervision_teachtable (person_id, school, ed_year, term, subject, class_level, room, rec_date, officer) values ('$person_id', '$school_code', '$year1', '2', '$subject', '$class_level', '$room', '$rec_date', '$officer')";
		$dbquery = mysqli_query($connect,$sql);

}
		
		//ปีที่ 2
		$year2=$_POST['year2']; 
		if(($_POST["class_level-$year2-1"]!="") and ($_POST["room-$year2-1"]!="") and ($_POST["subject-$year2-1"]!="")){
		$class_level=$_POST["class_level-$year2-1"];
		$room=$_POST["room-$year2-1"];
		$subject=$_POST["subject-$year2-1"];
		$sql = "insert into supervision_teachtable (person_id, school, ed_year, term, subject, class_level, room, rec_date, officer) values ('$person_id', '$school_code', '$year2', '1', '$subject', '$class_level', '$room', '$rec_date', '$officer')";
		$dbquery = mysqli_query($connect,$sql);

}
		if(($_POST["class_level-$year2-2"]!="") and ($_POST["room-$year2-2"]!="") and ($_POST["subject-$year2-2"]!="")){
		$class_level=$_POST["class_level-$year2-2"];
		$room=$_POST["room-$year2-2"];
		$subject=$_POST["subject-$year2-2"];
		$sql = "insert into supervision_teachtable (person_id, school, ed_year, term, subject, class_level, room, rec_date, officer) values ('$person_id', '$school_code', '$year2', '2', '$subject', '$class_level', '$room', '$rec_date', '$officer')";
		$dbquery = mysqli_query($connect,$sql);

}
	
		//ปีที่ 3
		$year3=$_POST['year3']; 
		if(($_POST["class_level-$year3-1"]!="") and ($_POST["room-$year3-1"]!="") and ($_POST["subject-$year3-1"]!="")){
		$class_level=$_POST["class_level-$year3-1"];
		$room=$_POST["room-$year3-1"];
		$subject=$_POST["subject-$year3-1"];
		$sql = "insert into supervision_teachtable (person_id, school, ed_year, term, subject, class_level, room, rec_date, officer) values ('$person_id', '$school_code', '$year3', '1', '$subject', '$class_level', '$room', '$rec_date', '$officer')";
		$dbquery = mysqli_query($connect,$sql);

}
		if(($_POST["class_level-$year3-2"]!="") and ($_POST["room-$year3-2"]!="") and ($_POST["subject-$year3-2"]!="")){
		$class_level=$_POST["class_level-$year3-2"];
		$room=$_POST["room-$year3-2"];
		$subject=$_POST["subject-$year3-2"];
		$sql = "insert into supervision_teachtable (person_id, school, ed_year, term, subject, class_level, room, rec_date, officer) values ('$person_id', '$school_code', '$year3', '2', '$subject', '$class_level', '$room', '$rec_date', '$officer')";
		$dbquery = mysqli_query($connect,$sql);

}
}

//ส่วนแสดงผล
if(!(($index==1) or ($index==2))){
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='5'><b>ปีการศึกษา $year ภาคเรียนที่ 1</b></Td>";
echo "<Tr bgcolor='#F5CBA7'><Td  align='center' width='150'>ชั้น</Td><Td  align='center' width='150'>ห้องที่</Td><Td  align='center' colspan='2'>วิชา</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'><a href=?file=teach_list&id=$id&index=2&remote_user_office=$remote_user_office&remote_user_id=$remote_user_id&remote_login_status=$remote_login_status&remote_sync=$remote_sync><img src=../../../images/drop.png border='0' alt='ลบ'></a></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><Td  align='center'>";
echo "<Select  name='class_level-$year-1' size='1'>";
echo  "<option value = '' >เลือกชั้น</option>";
echo  "<option value = '1' >อนุบาล 1</option>";
echo  "<option value = '2' >อนุบาล 2</option>";
echo  "<option value = '3' >อนุบาล 3</option>";
echo  "<option value = '4' >ป.1</option>";
echo  "<option value = '5' >ป.2</option>";
echo  "<option value = '6' >ป.3</option>";
echo  "<option value = '7' >ป.4</option>";
echo  "<option value = '8' >ป.5</option>";
echo  "<option value = '9' >ป.6</option>";
echo  "<option value = '10' >ม.1</option>";
echo  "<option value = '11' >ม.2</option>";
echo  "<option value = '12' >ม.3</option>";
echo  "<option value = '13' >ม.4</option>";
echo  "<option value = '14' >ม.5</option>";
echo  "<option value = '15' >ม.6</option>";
echo "</select>";
echo "</Td><Td  align='center'>";
echo "<Select  name='room-$year-1' size='1'>";
echo  "<option value = '' >เลือกห้อง</option>";
echo  "<option value = '1' >ห้องที่ 1</option>";

$sql_room = "select max(classroom) as classroom from  student_main_main where school_code='$school_code' and ed_year='$year'";
$dbquery_room = mysqli_query($connect,$sql_room);
$result_room = mysqli_fetch_array($dbquery_room);
$class_room_max=$result_room['classroom']; 
		for($y=2; $y<=$class_room_max; $y++){
		echo  "<option value = '$y' >ห้องที่ $y</option>";
		 }
echo "</select>";
echo "</Td><Td  align='center'>";
echo "<Select  name='subject-$year-1' size='1'>";
echo  "<option value = '' >เลือกวิชาที่สอน</option>";
echo  "<option value = '21' >กิจกรรมพัฒนาผู้เรียนระดับอนุบาล</option>";
echo  "<option value = '99' >ทุกวิชาระดับประถมศึกษา</option>";
echo  "<option value = '1' >ภาษาไทย</option>";
echo  "<option value = '2' >คณิตศาสตร์</option>";
echo  "<option value = '3' >วิทยาศาสตร์</option>";
echo  "<option value = '4' >สังคมศึกษา</option>";
echo  "<option value = '5' >สุขศึกษา</option>";
echo  "<option value = '6' >ศิลปะ</option>";
echo  "<option value = '7' >การงานอาชีพ</option>";
echo  "<option value = '8' >ภาษาอังกฤษ</option>";

echo "</select>";
echo "</Td><td colspan='2'></td></Tr>";

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

echo "<Tr bgcolor='#F5CBA7'><Td  align='center' width='150'>ชั้น</Td><Td  align='center' width='150'>ห้องที่</Td><Td  align='center' colspan='2'>วิชา</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'><a href=?file=teach_list&id=$id&index=2&remote_user_office=$remote_user_office&remote_user_id=$remote_user_id&remote_login_status=$remote_login_status&remote_sync=$remote_sync><img src=../../../images/drop.png border='0' alt='ลบ'></a></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 "<Tr><Td  align='center'>";
echo "<Select  name='class_level-$year-2' size='1'>";
echo  "<option value = '' >เลือกชั้น</option>";
echo  "<option value = '1' >อนุบาล 1</option>";
echo  "<option value = '2' >อนุบาล 2</option>";
echo  "<option value = '3' >อนุบาล 3</option>";
echo  "<option value = '4' >ป.1</option>";
echo  "<option value = '5' >ป.2</option>";
echo  "<option value = '6' >ป.3</option>";
echo  "<option value = '7' >ป.4</option>";
echo  "<option value = '8' >ป.5</option>";
echo  "<option value = '9' >ป.6</option>";
echo  "<option value = '10' >ม.1</option>";
echo  "<option value = '11' >ม.2</option>";
echo  "<option value = '12' >ม.3</option>";
echo  "<option value = '13' >ม.4</option>";
echo  "<option value = '14' >ม.5</option>";
echo  "<option value = '15' >ม.6</option>";
echo "</select>";
echo "</Td><Td  align='center'>";
echo "<Select  name='room-$year-2'  size='1'>";
echo  "<option value = '' >เลือกห้อง</option>";
echo  "<option value = '1' >ห้องที่ 1</option>";

$sql_room = "select max(classroom) as classroom from  student_main_main where school_code='$school_code' and ed_year='$year'";
$dbquery_room = mysqli_query($connect,$sql_room);
$result_room = mysqli_fetch_array($dbquery_room);
$class_room_max=$result_room['classroom']; 
		for($y=2; $y<=$class_room_max; $y++){
		echo  "<option value = '$y' >ห้องที่ $y</option>";
		 }
echo "</select>";
echo "</Td><Td  align='center'>";
echo "<Select  name='subject-$year-2' size='1'>";
echo  "<option value = '' >เลือกวิชาที่สอน</option>";
echo  "<option value = '21' >กิจกรรมพัฒนาผู้เรียนระดับอนุบาล</option>";
echo  "<option value = '99' >ทุกวิชาระดับประถมศึกษา</option>";
echo  "<option value = '1' >ภาษาไทย</option>";
echo  "<option value = '2' >คณิตศาสตร์</option>";
echo  "<option value = '3' >วิทยาศาสตร์</option>";
echo  "<option value = '4' >สังคมศึกษา</option>";
echo  "<option value = '5' >สุขศึกษา</option>";
echo  "<option value = '6' >ศิลปะ</option>";
echo  "<option value = '7' >การงานอาชีพ</option>";
echo  "<option value = '8' >ภาษาอังกฤษ</option>";

echo "</select>";
echo "</Td><td colspan='2'></td></Tr>";
echo "<input type='hidden' name='year$M' value='$year'>";
echo "<Tr><Td  align='center' colspan='5'><INPUT TYPE='button' name='smb' value='ตกลง' onclick='goto_url(1)' class='button button1'><tr>";

echo "</Table>";
echo "<br>";

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

?>
<script>
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_list.php