Gecko [ 122.154.134.11 ]

Name	Size	Permission
add_score.php	1.58 KB	-rw-r--r--
add_test.php	9.11 KB	-rwxr-xr-x
curriculum.php	7.97 KB	-rwxr-xr-x
curriculum_view.php	25.22 KB	-rwxr-xr-x
examination_set.php	320 B	-rwxr-xr-x
export_to_excel.php	4.24 KB	-rw-r--r--
frm_add_test.php	1.77 KB	-rwxr-xr-x
indicator.php	37.07 KB	-rwxr-xr-x
item_display.php	6.68 KB	-rw-r--r--
khet_paper_report_1.php	61.73 KB	-rw-r--r--
khet_paper_report_2.php	65.56 KB	-rw-r--r--
khet_report_1.php	27.49 KB	-rwxr-xr-x
khet_report_1_mobile.php	8.38 KB	-rwxr-xr-x
khet_report_2.php	68.18 KB	-rwxr-xr-x
level_log.php	1.6 KB	-rw-r--r--
level_record.php	17.37 KB	-rw-r--r--
level_report_1.php	38.07 KB	-rw-r--r--
level_report_2.php	35.32 KB	-rw-r--r--
level_report_3.php	22.22 KB	-rw-r--r--
level_report_4.php	16.65 KB	-rw-r--r--
level_test.php	22.99 KB	-rw-r--r--
livesearch.php	721 B	-rwxr-xr-x
livesearch2.php	729 B	-rw-r--r--
livesearch3.php	756 B	-rw-r--r--
livesearch4.php	727 B	-rw-r--r--
livesearch5.php	1.16 KB	-rw-r--r--
livesearch6.php	1.41 KB	-rw-r--r--
master_test_report.php	16.2 KB	-rw-r--r--
permission.php	11.69 KB	-rwxr-xr-x
print_check.php	3.52 KB	-rw-r--r--
return_ajax_indicator.php	1.64 KB	-rwxr-xr-x
return_ajax_standard.php	805 B	-rwxr-xr-x
return_ajax_substance.php	1.36 KB	-rwxr-xr-x
sch_paper_report_1.php	62.36 KB	-rw-r--r--
sch_report_1.php	65.87 KB	-rwxr-xr-x
sch_report_1_mobile.php	10.62 KB	-rwxr-xr-x
school_limit.php	13.09 KB	-rw-r--r--
standard.php	19.24 KB	-rwxr-xr-x
student_paper_report_1.php	17.6 KB	-rw-r--r--
student_report_1.php	25.54 KB	-rwxr-xr-x
student_report_1_mobile.php	5.51 KB	-rwxr-xr-x
substance.php	16.58 KB	-rwxr-xr-x
test_admin.php	46.87 KB	-rwxr-xr-x
test_admin2.php	6.86 KB	-rw-r--r--
test_admin3.php	11.27 KB	-rw-r--r--
test_admin_book.php	75.57 KB	-rw-r--r--
test_admin_book2.php	19.74 KB	-rw-r--r--
test_import.php	7.86 KB	-rw-r--r--
test_item.php	93.56 KB	-rwxr-xr-x
test_master.php	46.2 KB	-rwxr-xr-x
test_qc.php	15.46 KB	-rw-r--r--
test_qc_person.php	8.05 KB	-rw-r--r--
test_sch.php	6.1 KB	-rwxr-xr-x
test_sch_2.php	26.76 KB	-rwxr-xr-x
test_student.php	34.71 KB	-rwxr-xr-x

Code Editor : test_qc_person.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['p4']!=1) {
echo "<br>";
echo "<div align='center'>คุณไม่ได้รับสิทธิ์ในการตรวจคุณภาพแบบทดสอบ</div>";
exit();
}

?>
<script>
function showResult(str) {
  if (str.length==0) { 
    document.getElementById("livesearch").innerHTML="";
    document.getElementById("livesearch").style.border="0px";
    return;
  }
  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("livesearch").innerHTML=this.responseText;
      document.getElementById("livesearch").style.border="1px solid #A5ACB2";
    }
  }
  xmlhttp.open("GET","modules/bets/main/livesearch6.php?q="+str,true);
  xmlhttp.send();
}
</script>
<?php

require_once("modules/bets/time_inc.php");
$officer=$_SESSION['login_user_id'];
echo "<br />";

if($index==1){

if(isset($_GET["person_id"])){
		$person_id=$_GET["person_id"];
		$person_name=$_GET["person_name"];
		}
		else{
		$person_id="";
		$person_name="";
		}

echo "<form id='frm1' name='frm1'>";
echo "<Center>";
echo "<Font color='#006666' Size=3><B>เพิ่มผู้ตรวจสอบคุณภาพ</Font>";
echo "</Cener>";
echo "<Br><Br>";
echo "<Table width='40%' Border='0' >";

echo "<Tr>";
echo "<td align='center'>";

if($person_id==""){
		?>
		&nbsp;&nbspพิมพ์ชื่อค้นหาบุคลากร <input type="text" size="15" onkeyup="showResult(this.value)">
		<div id="livesearch" align="left"></div><div id="livesearch"></div>
		<?php
		}

echo "</td></tr>";
		if($person_id!=""){
		echo "<tr><td align='center'>ชื่อผู้ตรวจสอบคุณภาพ&nbsp;&nbsp;<input type='text' name='person_name' value='$person_name' readonly><td></tr>";
		}
echo "<input type='hidden' name='person_id' value='$person_id'>";
echo "</table>";

$sql = "select * from bets_test order by id";
$dbquery = mysqli_query($connect,$sql);
echo "<br>";
echo  "<table width='600' border='1'  borderColor='#000000'  align='center' style='border-collapse: collapse'>";
echo "<Tr bgcolor='#FFCCCC' align='center'><Td width='50'>ที่</Td><Td width='400'>ชื่อแบบทดสอบ</Td><Td width='100'>ชั้น</Td><Td width='50'>ตรวจ</Td></Tr>";

$M=1;
While ($result = mysqli_fetch_array($dbquery)){
		$id = $result['id'];
		$test_name= $result['test_name'];
		$class_room= $result['class_room'];
		$master_test= $result['master_test'];
			if(($M%2) == 0)
			$color="#FFFFC";
			else  	$color="#FFFFFF";
			
echo "<Tr bgcolor=$color align='center'><Td>$M</Td><Td align='left'>$test_name</Td><td>";
if($class_room==4){
echo "ป.1";
}
else if($class_room==5){
echo "ป.2";
}
else if($class_room==6){
echo "ป.3";
}
else if($class_room==7){
echo "ป.4";
}
else if($class_room==8){
echo "ป.5";
}
else if($class_room==9){
echo "ป.6";
}
else if($class_room==10){
echo "ม.1";
}
else if($class_room==11){
echo "ม.2";
}
else if($class_room==12){
echo "ม.3";
}
else if($class_room==13){
echo "ม.4";
}
else if($class_room==14){
echo "ม.5";
}
else if($class_room==15){
echo "ม.6";
}
echo "</td><td><input type='checkbox'  name='$id' id='$id' value='1'></td>";
echo "</Tr>";
$M++;
	}

echo "<tr><td align='center' colspan='4'><INPUT TYPE='button' name='smb' value='ตกลง' onclick='goto_url(1)'>
	&nbsp;&nbsp;";
echo "<INPUT TYPE='button' name='back' value='ย้อนกลับ' onclick='goto_url(0)'></td></tr>";
echo "</Table>";
echo "</form>";
}

if($index==3){
$sql = "delete from bets_qc where id=$_GET[id]";
$dbquery = mysqli_query($connect,$sql);
}

if($index==4){
$rec_date = date("Y-m-d");
		$sql = "select * from bets_test order by id";
		$dbquery = mysqli_query($connect,$sql);
		While ($result = mysqli_fetch_array($dbquery)){
		$id = $result['id'];
				if(isset($_POST["$id"])){
						$sql2 = "select * from bets_qc where person_id='$_POST[person_id]' and test_id='$id'";
						$dbquery2 = mysqli_query($connect,$sql2);
						$result2 = mysqli_fetch_array($dbquery2);
						if(!($result2)){
						$sql3 = "insert into bets_qc (person_id, test_id,rec_date) values ('$_POST[person_id]','$id','$rec_date')";
						$dbquery3 = mysqli_query($connect,$sql3);
						}
				}
		}
}

//ส่วนการแสดงผล
if(!($index==1)){
echo "<table width='50%' 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'>";
$today = date("Y-m-d H:i:s");

$sql = "select * from bets_test order by id";
$dbquery = mysqli_query($connect,$sql);
echo "<br>";
echo  "<table width='70%' border='0' align='center'>";
echo "<Tr><Td align='left'><INPUT TYPE='button' name='smb' value='เพิ่มผู้ตรวจสอบคุณภาพ' onclick='location.href=\"?option=bets&task=main/test_qc_person&index=1\"'</Td></Tr>";
echo "</table>";

echo  "<table width='70%' border='1'  borderColor='#000000'  align='center' style='border-collapse: collapse'>";
echo "<Tr bgcolor='#FFCCCC' align='center'><Td width='50'>ที่</Td><Td width='400'>ชื่อแบบทดสอบ</Td><Td width='100'>ชั้น</Td><Td>ผู้ตรวจสอบคุณภาพ</Td></Tr>";
$M=1;
While ($result = mysqli_fetch_array($dbquery)){
		$id = $result['id'];
		$test_name= $result['test_name'];
		$class_room= $result['class_room'];
		$master_test= $result['master_test'];
			if(($M%2) == 0)
			$color="#FFFFC";
			else  	$color="#FFFFFF";
			
echo "<Tr bgcolor=$color align='center'><Td>$M</Td><Td align='left'>$test_name</Td><td>";
if($class_room==4){
echo "ป.1";
}
else if($class_room==5){
echo "ป.2";
}
else if($class_room==6){
echo "ป.3";
}
else if($class_room==7){
echo "ป.4";
}
else if($class_room==8){
echo "ป.5";
}
else if($class_room==9){
echo "ป.6";
}
else if($class_room==10){
echo "ม.1";
}
else if($class_room==11){
echo "ม.2";
}
else if($class_room==12){
echo "ม.3";
}
else if($class_room==13){
echo "ม.4";
}
else if($class_room==14){
echo "ม.5";
}
else if($class_room==15){
echo "ม.6";
}
echo "</td><td align='left'>";
				$sql2 = "select  *,bets_qc.id from bets_qc inner join person_main on bets_qc.person_id=person_main.person_id where test_id='$id'";  
				$dbquery2 = mysqli_query($connect,$sql2);
				while($result2 = mysqli_fetch_array($dbquery2)){
				$qc_id=$result2['id'];
				$name=$result2['name'];
				$surname=$result2['surname'];
				echo "<a href=?option=bets&task=main/test_qc_person&index=3&id=$qc_id>$name $surname</a>"; echo "  :  ";
				}
				$sql3 = "select *,bets_qc.id from bets_qc inner join person_sch_main on bets_qc.person_id=person_sch_main.person_id where test_id='$id'";  
				$dbquery3 = mysqli_query($connect,$sql3);
				while($result3 = mysqli_fetch_array($dbquery3)){
				$qc_id=$result3['id'];
				$name=$result3['name'];
				$surname=$result3['surname'];
				echo "<a href=?option=bets&task=main/test_qc_person&index=3&id=$qc_id>$name $surname</a>"; echo "  :  ";
				}
echo "</td>";
echo "</Tr>";
$M++;
	}
echo "</Table>";
echo "</form>";
}

?>
<script>
function goto_url(val){
	if(val==0){
		callfrm("?option=bets&task=main/test_qc_person");   // page ย้อนกลับ 
	}else if(val==1){
		if(frm1.person_id.value == ""){
			alert("กรุณาเลือกบุคลากร");
		}else{
			callfrm("?option=bets&task=main/test_qc_person&index=4");   //page ประมวลผล
		}
	}
}
</script>

${this.title}

Code Editor : test_qc_person.php