Gecko [ 122.154.134.11 ]

Name	Size	Permission
images	[ DIR ]	drwxr-xr-x
index.php	1.01 KB	-rw-r--r--
level_report_1.php	40.3 KB	-rw-r--r--
level_report_2.php	33.4 KB	-rw-r--r--
level_report_3.php	22.45 KB	-rw-r--r--
level_report_4.php	14.48 KB	-rw-r--r--
sch_paper_report_1.php	63.51 KB	-rw-r--r--
sch_report_1.php	66.17 KB	-rw-r--r--
student_paper_report_1.php	17.79 KB	-rw-r--r--
student_report_1.php	25.36 KB	-rw-r--r--
test_admin3.php	12.46 KB	-rw-r--r--
test_admin_book2.php	20.8 KB	-rw-r--r--
test_sch.php	6.34 KB	-rw-r--r--
test_sch_2.php	30.45 KB	-rw-r--r--
test_student.php	36.36 KB	-rw-r--r--

Code Editor : test_admin3.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> 
<?php

require_once("../../../modules/bets/time_inc.php");
$officer=$remote_user_id;

$sql_limit = "select * from  bets_school_limit where active='1'";
$dbquery_limit = mysqli_query($connect,$sql_limit);
$result_limit = mysqli_fetch_array($dbquery_limit);

if(!($result_limit)){
		echo "<script>alert('ไม่มีรายการสอบเปิดให้จองสอบในขณะนี้'); document.location.href='index.php?option=bets&remote_user_office=$remote_user_office&remote_user_id=$remote_user_id&remote_login_status=$remote_login_status&remote_sync=$remote_sync';</script>\n";
		exit();
}

$school_limit=$result_limit['school_limit'];
$over_reservation=0;  //กำหนดตัวแปร

if(!(isset($_REQUEST['chkday']))){

//หาจำนวนวันสอบ
		$today_date = date("Y-m-d");		
		$test_start=$today_date ." "."06".":"."00".":"."00";
		$sql_alert= "select  count(distinct start_date) as date_num  from bets_test_schuser where school='$remote_user_office' and start_date>='$test_start'";
		$dbquery_alert=mysqli_query($connect,$sql_alert);
		$result_alert=mysqli_fetch_array($dbquery_alert);
		if($result_alert['date_num']>=2){
		$over_reservation=1;
		?>
		<script>alert('โรงเรียนได้จองแล้ว จำนวน 2  วัน จะจองใหม่ได้อีกต่อเมื่อผ่านวันสอบรายการแรกไปก่อน'); </script>
		<?php
		}

$start=$result_limit['start'];
$stop=$result_limit['stop'];
$today=date("Y-m-d");

if($today>$start){
$start=$today;
}
if($today>$stop){
$stop="2016-12-31";
}

$start_ex=explode("-",$start);
$start_ex_mkdate=mktime(0,0,0, $start_ex[1], $start_ex[2], $start_ex[0]);

$stop_ex=explode("-",$stop);
$stop_ex_mkdate=mktime(0,0,0, $stop_ex[1], $stop_ex[2], $stop_ex[0]);

echo "<form id='frm1' name='frm1'>";
echo "<Center><br>";
echo "<Font color='#006666' Size=3><b>จองวันสอบ</b>(คลิกเลือก)</Font>";
echo "</Cener>";
echo "<Br>";
echo "<Table width='70%'>";

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

//  ------------- ส่วนที่ 1 -------------
$year=date('Y');
$month=date('m'); 
$month= intval($month); 
$mkdate=mktime(0,0,0, $month, 1, $year); 
$full_month=date('F',$mkdate); 
$weekday=date('w',$mkdate);  
$last_days=date('t',$mkdate); 
$day=1;
$thai_year=$year+543;

if($month==12){
$next_month=1;
$next_year=$year+1;
}
else{
$next_month=$month+1;
$next_year=$year;
}
$next_mkdate=mktime(0,0,0, $next_month, 1, $next_year);
$next_full_month=date('F',$next_mkdate);
$next_weekday=date('w',$next_mkdate); 
$next_last_days=date('t',$next_mkdate);
$next_thai_year=$next_year+543;

?>
<table border="1">
	<tr bgcolor="#BBBBBB">
		<td colspan="7">
        	<center><b><?php echo "$th_month[$month] $thai_year"; ?></b></center>
        	</td>
	</tr>
	<tr bgcolor="#BBBBBB" align="center">
		<td width="50">อาทิตย์</td>
		<td width="50">จันทร์</td>
		<td width="50">อังคาร</td>
		<td width="50">พุธ</td>
		<td width="50">พฤหัสบดี</td>
 		<td width="50">ศุกร์</td>
		<td width="50">เสาร์</td>
	</tr>
	<tr>
<?php
//  ------------- ส่วนที่ 2 -------------
$start= 1;
while ($start<= $weekday) {
	echo "<td>&nbsp;</td>";
	$start++;
}
//  ------------- ส่วนที่ 3 -------------
$weekday++;
while ($day<=$last_days) {
	$mk_thisday=mktime(0,0,0, $month, $day, $year); 
	if (date("d")==$day) {
		echo "<td bgcolor='#00FF66'>";
			if(($mk_thisday>=$start_ex_mkdate) and ($mk_thisday<=$stop_ex_mkdate)){
			echo"<input type='checkbox' name='chkday' id='chkday' value='$year-$month-$day' onclick='goto_index(1)'>";
			}
		echo "$day</td>"; 
	} else {
		echo "<td>";	
			if(($mk_thisday>=$start_ex_mkdate) and ($mk_thisday<=$stop_ex_mkdate)){
			echo "<input type='checkbox' name='chkday' id='chkday' value='$year-$month-$day' onclick='goto_index(1)'>";
			}
		echo "$day</td>";
	}
	if ($weekday==7 and $day<>$last_days) {
		echo '</tr><tr>';
		$weekday=0;
	}
	
	$day++; 
	$weekday++; 
}
//  ------------- ส่วนที่ 4 -------------
while ($weekday <= 7) {
	echo "<td> &nbsp; </td>";
	$weekday++;
}

echo "</tr>	</table>";

//เดือนที่สอง
?>
<table border="1">
	<tr bgcolor="#BBBBBB">
		<td colspan="7">
        	<center><b><?php echo "$th_month[$next_month] $next_thai_year"; ?></b></center>
        	</td>
	</tr>
	<tr bgcolor="#BBBBBB" align="center">
		<td width="50">อาทิตย์</td>
		<td width="50">จันทร์</td>
		<td width="50">อังคาร</td>
		<td width="50">พุธ</td>
		<td width="50">พฤหัสบดี</td>
 		<td width="50">ศุกร์</td>
		<td width="50">เสาร์</td>
	</tr>
	<tr>
<?php
//  ------------- ส่วนที่ 2 -------------
$start= 1;

while ($start<= $next_weekday) {
	echo "<td>&nbsp;</td>";
	$start++;
}

//  ------------- ส่วนที่ 3 -------------
$next_weekday++;
$day=1;
$dayplus=$last_days+$day;
$tatal_day=$last_days+$next_last_days;
while ($day<=$next_last_days) {
$mk_thisday=mktime(0,0,0, $next_month, $day, $next_year); 
		echo "<td>";
		if(($mk_thisday>=$start_ex_mkdate) and ($mk_thisday<=$stop_ex_mkdate)){
		echo "<input type='checkbox'  name='chkday' id='chkday' value='$next_year-$next_month-$day' onclick='goto_index(1)'>";
		}
		echo "$day</td>";
		$dayplus++;
	if ($next_weekday==7 and $day<>$next_last_days) {
		echo '</tr><tr>';
		$next_weekday=0;
	}
	
	$day++; 
	$next_weekday++; 
}
//  ------------- ส่วนที่ 4 -------------
while ($next_weekday <= 7) {
	echo "<td> &nbsp; </td>";
	$next_weekday++;
}
echo "</tr>	</table>";

echo "</Td></Tr>";

echo "</Table>";
echo "<Br>";
echo "<input type='hidden' name='over_reservation' value='$over_reservation'>";
		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'>";

echo "</form>";
}

if($index==3){
$sql = "delete from bets_test_schuser where test_id='$_GET[test_id]' and school='$_GET[school]'";
$dbquery = mysqli_query($connect,$sql);
echo "<script>document.location.href='?file=test_admin3&index=7&chkday=$_REQUEST[chkday]&over_reservation=$_REQUEST[over_reservation]&remote_user_office=$remote_user_office&remote_user_id=$remote_user_id&remote_login_status=$remote_login_status&remote_sync=$remote_sync';</script>\n";
}

if($index==4){ 
		$rec_date = date("Y-m-d");		
		$test_start=$_POST['chkday']." "."06".":"."00".":"."00";
		$test_stop=$_POST['chkday']." "."23".":"."00".":"."00";
		
		$sql = "select * from bets_test where test_active='1'";
		$dbquery = mysqli_query($connect,$sql);
		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='$remote_user_office' 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='$remote_user_office' 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]','$remote_user_office','$test_start','$test_stop','$officer','$rec_date')";
							$dbquery_insert  = mysqli_query($connect,$sql_insert);
							}
					}
		}
		echo "<script>document.location.href='?file=test_sch&remote_user_office=$remote_user_office&remote_user_id=$remote_user_id&remote_login_status=$remote_login_status&remote_sync=$remote_sync';</script>\n";
}

if($index==7){
		if(!(isset($_REQUEST['chkday']))){
		exit();
		}
		$test_start=$_REQUEST['chkday']." "."06".":"."00".":"."00";
		$test_stop=$_REQUEST['chkday']." "."23".":"."00".":"."00";
		$sql_alert= "select  count(distinct school) as sch_num  from bets_test_schuser where start_date>='$test_start' and stop_date<='$test_stop' ";
		$dbquery_alert=mysqli_query($connect,$sql_alert);
		$result_alert=mysqli_fetch_array($dbquery_alert);
		if($result_alert['sch_num']>=$school_limit){
		?>
		<script>alert('มีโรงเรียนจองสอบวันเดียวกันนี้ จำนวน <?php echo $school_limit;?> โรงเรียนแล้ว  ขอให้เลือกจองวันใหม่'   ); </script>
		<?php
		echo "<script>document.location.href='?file=test_admin3&remote_user_office=$remote_user_office&remote_user_id=$remote_user_id&remote_login_status=$remote_login_status&remote_sync=$remote_sync';</script>\n";
		exit();
		}
echo "<br />";
$date_test= thai_date_2($_REQUEST['chkday']);
 		//เลือกชั้น
		echo "<form id='frm1' name='frm1'>";
				echo "<Center>";
				echo "<Font color='#006666' Size='3'><B>เลือกแบบทดสอบ</B></Font><br>";
				echo "<Font color='#006666' Size='2'><B>เพื่อสอบวันที่  $date_test</B></Font><br><br>";
			echo "</Center>";
				
				echo  "<table width='70%' border='0' align='center'>";
				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='$remote_user_office'";
				$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=?file=test_admin3&index=3&test_id=$result_test[id]&school=$remote_user_office&chkday=$_REQUEST[chkday]&over_reservation=$_REQUEST[over_reservation]&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'></a>";
				}
				echo "</td></tr>";
				
				$N++;
				}
				echo "<input type='hidden' name='chkday' value='$_REQUEST[chkday]'>";
				if($_REQUEST['over_reservation']==0){
				echo "<tr bgcolor='#FFCCCC'><td align='center' colspan='4'><INPUT TYPE='button' name='smb' value='ตกลง' onclick='goto_url2(1)'></td></tr>";
				}
				echo "</table>";
		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'>";
echo "</form>";
}
		
?>
<script>
function goto_url2(val){
		if(val==1){
		callfrm("?file=test_admin3&index=4"); 
		}
}

function goto_index(val){
	if(val==1){
		callfrm("?file=test_admin3&index=7");  
		}
}

</script>

${this.title}

Code Editor : test_admin3.php