Gecko [ 122.154.134.11 ]

Name	Size	Permission
add_score_1.php	9.99 KB	-rwxr-xr-x
add_score_2.php	10.23 KB	-rwxr-xr-x
add_score_3.php	11.14 KB	-rwxr-xr-x
getxml_onet.php	6.86 KB	-rwxr-xr-x
livesearch.php	778 B	-rwxr-xr-x
permission.php	9.65 KB	-rwxr-xr-x
report1.php	9.17 KB	-rwxr-xr-x
report11.php	10.97 KB	-rwxr-xr-x
report1_1.php	8.89 KB	-rwxr-xr-x
report1_1_mobile.php	7.08 KB	-rw-r--r--
report1_2.php	12.3 KB	-rwxr-xr-x
report2.php	6.09 KB	-rwxr-xr-x
report21.php	8.62 KB	-rwxr-xr-x
report2_1.php	6.54 KB	-rwxr-xr-x
report2_2.php	5.26 KB	-rwxr-xr-x
report3.php	6.09 KB	-rwxr-xr-x
report31.php	8.63 KB	-rwxr-xr-x
report3_1.php	6.55 KB	-rwxr-xr-x
report3_2.php	5.26 KB	-rwxr-xr-x
report4.php	9.62 KB	-rwxr-xr-x
report41.php	11.64 KB	-rwxr-xr-x
report4_1.php	10.09 KB	-rw-r--r--
report4_1_mobile.php	8.61 KB	-rw-r--r--
report4_2.php	10.56 KB	-rw-r--r--
report5.php	6.09 KB	-rwxr-xr-x
report51.php	8.62 KB	-rwxr-xr-x
report5_1.php	6.54 KB	-rwxr-xr-x
report5_2.php	5.26 KB	-rwxr-xr-x
report6.php	18.25 KB	-rwxr-xr-x
report61.php	19.65 KB	-rwxr-xr-x
report6_1.php	18.52 KB	-rw-r--r--
report6_1_mobile.php	9.04 KB	-rw-r--r--
report6_2.php	13.14 KB	-rw-r--r--
report7.php	6.09 KB	-rwxr-xr-x
report71.php	8.62 KB	-rwxr-xr-x
report7_1.php	6.54 KB	-rwxr-xr-x
report7_2.php	5.26 KB	-rwxr-xr-x
report_nt.php	9.3 KB	-rw-r--r--
report_nt_group.php	7.84 KB	-rw-r--r--
report_onet.php	10.99 KB	-rw-r--r--
report_onet_group.php	12.21 KB	-rw-r--r--
report_onet_xx.php	7.88 KB	-rw-r--r--
test_import.php	6.71 KB	-rw-r--r--

Code Editor : add_score_1.php

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

if(!($result_permission['p1']==1)) {
exit();
}

if(!(isset($_REQUEST['ed_year']))){
$_REQUEST['ed_year']="";
}

if(!(isset($_REQUEST['edit_code']))){
$_REQUEST['edit_code']="";
}

$officer=$_SESSION['login_user_id'];
$class_ar[6]="ชั้นประถมศึกษาปีที่ 6";
$class_ar[9]="ชั้นมัธยมศึกษาปีที่ 3";
$class_ar[12]="ชั้นมัธยมศึกษาปีที่ 6";

echo "<br>";
//ส่วนฟอร์มกำหนดปีการศึกษา

if($_REQUEST['ed_year']==""){
echo "<br />";
echo "<form id='frm1' name='frm1'>";
echo "<Center>";
echo "<Font color='#006666' Size=3><B>กำหนดปีการศึกษา และชั้นสอบ O-NET</Font>";
echo "</Cener>";
echo "<Br><Br>";
echo "<Table width='300' Border='0' Bgcolor='#Fcf9d8'>";
echo "<Tr><Td align='right'>ปีการศึกษา&nbsp;&nbsp;&nbsp;&nbsp;</Td><Td align='left'><Input Type='Text' Name='ed_year'  id='ed_year' Size='4' maxlength='4'></Td></Tr>";
echo "<Tr><Td align='right'>ชั้น&nbsp;&nbsp;&nbsp;&nbsp;</Td>";
echo "<td><div align='left'><Select name='test_class' id='test_class' size='1'>";
echo  "<option  value = ''>เลือก</option>" ;
echo  "<option value = '6'>ประถมศึกษาปีที่ 6</option>";
echo  "<option value = '9'>มัธยมศึกษาปีที่ 3</option>";
echo  "<option value = '12'>มัธยมศึกษาปีที่ 6</option>";
echo "</select>";
echo "</div></td></tr>";

echo "<tr><td>&nbsp;</td><td>&nbsp;</td></tr>";
echo "<tr><td align='center' colspan='2'><INPUT TYPE='button' name='smb' value='ตกลง' onclick='goto_url2(1)'  ></td></tr>";
echo "</Table>";
echo "</form>";
}

//ส่วนบันทึกข้อมูล
if($index==4){
$rec_date=date("Y-m-d");
		$sql = "select * from system_school order by school_type,school_code";
		$dbquery = mysqli_query($connect,$sql);
		While ($result = mysqli_fetch_array($dbquery)){
		$school_code=$result['school_code'];
		
		if(isset($_POST[$school_code][1])){
		$thai=$_POST[$school_code][1];
		}
		else{
		$thai="";
		}
		
		if(isset($_POST[$school_code][2])){
		$math=$_POST[$school_code][2];
		}
		else{
		$math="";
		}
		
		if(isset($_POST[$school_code][3])){
		$science=$_POST[$school_code][3];
		}
		else{
		$science="";
		}
		
		if(isset($_POST[$school_code][4])){
		$social=$_POST[$school_code][4];
		}
		else{
		$social="";
		}
		
		if(isset($_POST[$school_code][5])){
		$english=$_POST[$school_code][5];
		}
		else{
		$english="";
		}
		
		if(isset($_POST[$school_code][6])){
		$health=$_POST[$school_code][6];
		}
		else{
		$health="";
		}
		
		if(isset($_POST[$school_code][7])){
		$art=$_POST[$school_code][7];
		}
		else{
		$art="";
		}
		
		if(isset($_POST[$school_code][8])){
		$vocation=$_POST[$school_code][8];
		}
		else{
		$vocation="";
		}
		
		if(isset($_POST[$school_code][9])){
		$score_avg=$_POST[$school_code][9];	
		}
		else{
		$score_avg="";
		}
			
		if(!(isset($_POST[$school_code][10]))){
		$_POST[$school_code][10]="";
		}	
		
		if($thai==""){
		$thai=0;
		}	
		if($math==""){
		$math=0;
		}		
		if($science==""){
		$science=0;
		}	
		if($social==""){
		$social=0;
		}		
		if($english==""){
		$english=0;
		}		
		if($health==""){
		$health=0;
		}		
		if($art==""){
		$art=0;
		}		
		if($vocation==""){
		$vocation=0;
		}		
		
						if($_POST[$school_code][10]==0){
						$sql_select = "select * from  achievement_main where test_type='1' and test_class='$_REQUEST[test_class]' and ed_year='$_REQUEST[ed_year]' and school='$school_code' ";
						$dbquery_select = mysqli_query($connect,$sql_select);
						$data_num=mysqli_num_rows($dbquery_select);
									if($data_num>0){
									$sql_update = "update  achievement_main set thai='$thai',
									math='$math',
									science='$science',
									social='$social',
									english='$english',
									health='$health',
									art='$art',
									vocation='$vocation',
									score_avg='$score_avg',									
									officer='$officer',
									rec_date='$rec_date' 
									where  test_type='1' and test_class='$_REQUEST[test_class]' and ed_year='$_REQUEST[ed_year]' and school='$school_code' ";
									$dbquery_update = mysqli_query($connect,$sql_update);
									}
									else {
									$sql_insert = "insert into achievement_main (test_type, test_class, ed_year, school, thai, math, science, social, english, health, art,vocation, score_avg, officer, rec_date) values ('1', '$_REQUEST[test_class]', '$_REQUEST[ed_year]', '$school_code', '$thai', '$math', '$science', '$social', '$english', '$health', '$art', '$vocation', '$score_avg', '$officer', '$rec_date')";
												if($score_avg>0){
												$dbquery_insert = mysqli_query($connect,$sql_insert);
												}
									}
						}
		}	
}
//ส่วนแสดงหลัก
if($index==1 or $index==4 or $index==5 ){
$test_class=$_REQUEST['test_class'];
echo "<br />";
echo "<table width='99%' border='0' align='center'>";
echo "<tr align='center'>
	<td align=center><font color='#990000' size='3'><strong>บันทึกคะแนน O-NET $class_ar[$test_class]  ปีการศึกษา $_REQUEST[ed_year] </strong></font>
<font color='#006666' size='3'><strong></strong></font>
</td></tr>";
echo "</table>";
echo "<br />";

echo "<form id='frm1' name='frm1'>";
$sql = "select * from system_school order by school_type,school_code";
$dbquery = mysqli_query($connect,$sql);
echo  "<table width='98%' border='0' align='center'>";
echo "<Tr bgcolor='#FFCCCC' align='center'><Td width='50'>ที่</Td>";
echo "<Td>โรงเรียน</Td><Td>ภาษาไทย</Td><Td>คณิต</Td><Td>วิทย์</Td><Td>สังคม</Td><Td>อังกฤษ</Td><Td>สุขศึกษา</Td><Td>ศิลปะ</Td><Td>การงาน</Td><Td>เฉลี่ย</Td><Td></Td></Tr>";
$N=1;
$M=1;
echo  "<input type='hidden' name='ed_year' id='ed_year' value='$_REQUEST[ed_year]'>";
echo  "<input type='hidden' name='test_class' id='test_class' value='$_REQUEST[test_class]'>";

While ($result = mysqli_fetch_array($dbquery))
	{
			if(($M%2) == 0){
			$color="#FFFFC";
			}
			else {
			$color="#FFFFFF";
			}
			
						$sql_select = "select * from  achievement_main  where school='$result[school_code]' and ed_year='$_REQUEST[ed_year]' and test_class='$_REQUEST[test_class]' and test_type='1' ";
						$dbquery_select = mysqli_query($connect,$sql_select);
						$result_select  = mysqli_fetch_array($dbquery_select);
						if($result_select){
								if($_REQUEST['edit_code']==$result['school_code']){
								$disable="";
								}
								else{
								$disable="disabled";
								}
						}
						else{
						$disable="";
						}		
									
echo "<Tr  bgcolor=$color align='center'><Td>$N</Td>";
echo "<Td align='left'>$result[school_code] $result[school_name]</Td>";
echo "<Td><input type='text' name='$result[school_code][1]' id='$result[school_code][1]'  size= 6 value='$result_select[thai]'  $disable></Td>";
echo "<Td><input type='text' name='$result[school_code][2]' id='$result[school_code][2]'  size= 6 value='$result_select[math]'  $disable></Td>";
echo "<Td><input type='text' name='$result[school_code][3]' id='$result[school_code][3]'  size= 6 value='$result_select[science]'  $disable ></Td>";
echo "<Td><input type='text' name='$result[school_code][4]' id='$result[school_code][4]'  size= 6 value='$result_select[social]'  $disable></Td>";
echo "<Td><input type='text' name='$result[school_code][5]' id='$result[school_code][5]'  size= 6 value='$result_select[english]' $disable></Td>";
echo "<Td><input type='text' name='$result[school_code][6]' id='$result[school_code][6]'  size= 6 value='$result_select[health]'  $disable></Td>";
echo "<Td><input type='text' name='$result[school_code][7]' id='$result[school_code][7]'  size= 6 value='$result_select[art]'  $disable></Td>";
echo "<Td><input type='text' name='$result[school_code][8]' id='$result[school_code][8]'  size= 6 value='$result_select[vocation]'  $disable></Td>";
echo "<Td><input type='text' name='$result[school_code][9]' id='$result[school_code][9]'  size= 6 value='$result_select[score_avg]'  $disable></Td>";

if($disable=="disabled"){
	echo  "<input type='hidden' name='$result[school_code][10]' id='$result[school_code][10]'  value='1'>";
	}
	else{
	echo  "<input type='hidden' name='$result[school_code][10]' id='$result[school_code][10]'  value='0'>";
	}

if($result_select){
				if($_REQUEST['edit_code']==$result['school_code']){
				echo "<Td align='center'><INPUT TYPE='button' name='smb' value='บันทึก' onclick='goto_url(1)' ></td>";
				}
				else{
				echo "<Td align='center'><a href=?option=achievement&task=main/add_score_1&index=5&ed_year=$_REQUEST[ed_year]&test_class=$_REQUEST[test_class]&edit_code=$result[school_code]><img src=images/edit.png border='0' alt='แก้ไข'></a></Td>";
				}
	}
	else{
	echo "<Td align='center'><INPUT TYPE='button' name='smb' value='บันทึก' onclick='goto_url(1)' ></td>";
	}
$M++;
$N++;
}
echo "</Table>";
echo "<br>";
echo "</form>";
}
?>

function goto_url(val){
	if(val==1){
			if(frm1.ed_year.value == ""){
			alert("ปีการศึกษาไม่ได้ระบุ โปรดระบุปีการศึกษา");
			}else{
			callfrm("?option=achievement&task=main/add_score_1&index=4");  
			} 
	}
}

</script>

${this.title}

Code Editor : add_score_1.php