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_admin2.php

<?php
/** ensure this file is being included by a parent file */
defined( '_VALID_' ) or die( 'Direct Access to this location is not allowed.' );
?>
<script type="text/javascript" src="./css/js/calendarDateInput2.js"></script> 
<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/livesearch2.php?q="+str,true);
  xmlhttp.send();
}
</script>
<?php

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

if($index==3){
$sql = "delete from bets_test_schuser where test_id='$_GET[test_id]' and school='$_GET[school]'";
$dbquery = mysqli_query($connect,$sql);
$_REQUEST['school_index']=$_GET['school'];
}

if($index==4){
		$sql = "select * from bets_test where test_active='1'";
		$dbquery = mysqli_query($connect,$sql);
		$rec_date = date("Y-m-d");		
		$test_start=$_POST['test_start']." "."06".":"."00".":"."00";
		$test_stop=$_POST['test_start']." "."18".":"."00".":"."00";
		while($result=mysqli_fetch_array($dbquery)){
		$test_id=$result['id'];
		$chk="chk$test_id";

if(isset($_POST[$chk])){
							$sql_check= "select  id  from bets_test_schuser where school='$_REQUEST[school_index]' and test_id='$result[id]'";
							$dbquery_check=mysqli_query($connect,$sql_check);
							if(mysqli_fetch_array($dbquery_check)){
							$sql_update = "update bets_test_schuser set start_date='$test_start',stop_date='$test_stop',officer='$officer',rec_date='$rec_date]' where school='$_REQUEST[school_index]' and test_id='$result[id]'";
							$dbquery_update=mysqli_query($connect,$sql_update);
							}
							else{
							$sql_insert = "insert into bets_test_schuser (test_id,school,start_date,stop_date,officer,rec_date) values ( '$result[id]','$_REQUEST[school_index]','$test_start','$test_stop','$officer','$rec_date')";
							$dbquery_insert  = mysqli_query($connect,$sql_insert);
							}
					}
		}
		$sql_alert= "select  count(distinct school) as sch_num  from bets_test_schuser where start_date>='$test_start' and '$test_start'<=stop_date";
		$dbquery_alert=mysqli_query($connect,$sql_alert);
		$result_alert=mysqli_fetch_array($dbquery_alert);
		?>
		<script>alert('มีโรงเรียนที่สอบวันเดียวกันนี้ จำนวน <?php echo $result_alert['sch_num'];?> โรงเรียน'   ); </script>
		<?php
}

echo "<br />";
 		//เลือกชั้น
		echo  "<table width=90% border='0' align='center'>";
		echo "<form id='frm1' name='frm1'>";
		echo "<Tr><td align='right'>";
		?>
		ค้นหาโรงเรียน <input type="text" size="15" onkeyup="showResult(this.value)">
		<div id="livesearch"></div>
		<?php
		echo "<div align='right'>";
	
			echo "<Select  name='school_index' size='1' 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($result['school_code']==$_REQUEST['school_index']){
					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>";
		echo "&nbsp;<INPUT TYPE='button' name='smb' value='เลือกโรงเรียน' onclick='goto_index(1)'>";
		echo "</div>";
		echo "</td></Tr></Table>";
		//จบ

if(isset($_REQUEST['school_index'])){
				if($_REQUEST['school_index']!=""){
						$sql_school = "select  school_name from system_school where school_code='$_REQUEST[school_index]'";
						$dbquery_school = mysqli_query($connect,$sql_school );
						$result_school=mysqli_fetch_array($dbquery_school);
				
				echo "<Center>";
				echo "<Font color='#006666' Size='3'><B>กำหนดการสอบโรงเรียน$result_school[school_name]</B></Font><br>";
				
				?>
				<script>DateInput('test_start', true, 'YYYY-MM-DD')</script>
				<?php
				echo "<br>";
				echo "</Center>";
				
				echo  "<table width='70%' border='1' borderColor='#999999' align='center' style='border-collapse: collapse'>";
				echo "<Tr bgcolor='#FFCCCC' align='center'><Td width='70'>ที่<br><input type='checkbox' name='allchk' id='allchk' onclick='CheckAll()'><font color='#006666'>ทั้งหมด</font></Td><Td>ชื่อแบบทดสอบ</Td>";
				echo "<Td width='300'>วันเวลาสอบ</Td>";
				echo "<Td width='40'>ลบ</Td>";
				echo "</Tr>";
				
				$sql_test = "select * from bets_test where test_active='1'";
				$dbquery_test = mysqli_query($connect,$sql_test);
				$N=1;
				while($result_test=mysqli_fetch_array($dbquery_test)){
				if(($N%2) == 0){
				$color="#FFFFC";
				}
				else {
				$color="#FFFFFF";
				}
				
				$sql_schuser = "select * from bets_test_schuser where test_id='$result_test[id]' and school='$_REQUEST[school_index]'";
				$dbquery_schuser = mysqli_query($connect,$sql_schuser);
				$result_schuser=mysqli_fetch_array($dbquery_schuser);
				$start=thai_date_4($result_schuser['start_date']);
				$stop=thai_date_4($result_schuser['stop_date']);

echo "<tr bgcolor=$color><td align='center'>$N</td><td align='left'><input type='checkbox' name='chk$result_test[id]' id='chk$result_test[id]' value='1'>$result_test[test_name]</td><td>$start $stop</td><td align='center'>";
				if($start){
				echo "<a href=?option=bets&task=main/test_admin2&index=3&test_id=$result_test[id]&school=$_REQUEST[school_index]><img src=images/drop.png border='0'></a>";
				}
				echo "</td></tr>";
				
				$N++;
				}
				echo "<tr bgcolor='#FFCCCC'><td align='center' colspan='4'><INPUT TYPE='button' name='smb' value='ตกลง' onclick='goto_url2(1)'></td></tr>";
				echo "</table>";
				} //$_REQUEST['school_index']!=""
				} //ifisset
echo "</form>";

?>
<script>
function goto_url2(val){
		if(val==1){
		callfrm("?option=bets&task=main/test_admin2&index=4"); 
		}
}

function goto_index(val){
	if(val==1){
		callfrm("?option=bets&task=main/test_admin2");  
		}
}

</script>

${this.title}

Code Editor : test_admin2.php