Gecko [ 122.154.134.11 ]

Name	Size	Permission
sch_answer_qtn.php	26.11 KB	-rw-r--r--
sch_report1.php	13.2 KB	-rw-r--r--
sync.php	3.79 KB	-rw-r--r--
sync.php.bak	3.79 KB	-rw-r--r--
upload_1.php	7.85 KB	-rw-r--r--
upload_2.php	1.46 KB	-rw-r--r--
upload_2_2.php	1.46 KB	-rw-r--r--

Code Editor : sch_answer_qtn.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>DMSS</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" href="../../../css/mm_training.css" type="text/css" />
</head>
<?php
require_once "../../../amssplus_connect.php";	
require_once "../../../mainfile.php";	
require_once "sync.php";

$officer=$remote_user_id;
$user_school=$remote_user_office;

require_once "../time_inc.php";

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

//ส่วนหัว
echo "<br />";
if(!(($index==1) or ($index==2) or ($index==3) or ($index==5))){
echo "<table width='100%' border='0' align='center'>";
echo "<tr align='center'><td><font color='#006666' size='3'><strong>ตอบแบบสอบถาม</strong></font></td></tr>";
echo "</table>";
}

if($index==2){
require_once "upload_2.php";	
}

if($index==3){
require_once "upload_1.php";	
}

if($index==4){
$rec_date = date("Y-m-d");
$qtn_use_id=$_POST['qtn_use_id'];
$sql="select * from questionnaire_use_qtn_name where qtn_use_id='$qtn_use_id' limit 0,1";
$dbquery = mysqli_query($connect,$sql);
$row=mysqli_fetch_array($dbquery);
$qtn_use_name=$row['qtn_use_name'];
$qtn_id=$row['qtn_id'];
$qtn_desc=$row['qtn_desc'];
$type=$row['type'];

?><BR>

	<?php
	$sql="select * from questionnaire_use_qtn_name where qtn_use_id='$qtn_use_id' limit 0,1";
			$result=mysqli_query($connect,$sql);
			while($row=mysqli_fetch_array($result)){ /////////////////// ชื่อ template
				$qtn_name=$row['qtn_use_name'];
				$qtn_id=$row['qtn_id'];
				$qtn_desc=$row['qtn_desc'];
				echo "<tr><td colspan='2' valign='top'>";
				/////////////////////////////////////////////////
				
				/////////////////////////////////////////////////
				$sql2="select * from questionnaire_qq  where qtn_id='$qtn_id' order by order_id ,qtn_qq_id";
				$result2=mysqli_query($connect,$sql2);
				$i=0;
				$k=0;
				while($row2=mysqli_fetch_array($result2)){  /////////////////////////// ชื่อคำถามที่
					$qtn_qq_id=$row2['qtn_qq_id'];
					
	// ตรวจรายละเอียดแต่ละข้อ					
			$sql_44="select * from questionnaire_use_qtn where (qtn_use_id='$qtn_use_id') and (qtn_qq_id='$qtn_qq_id')";
			$dbquery44=mysqli_query($connect,$sql_44);
			$result44=mysqli_fetch_array($dbquery44);
			if($result44['school']=='no_sch'){
			continue;
			}
				
					$i++;
//เลือกตัวแปร					
						$sql3="select * from questionnaire_qq_member where qtn_qq_id = $qtn_qq_id order by qtn_qq_m_id";
						$result3=mysqli_query($connect,$sql3);
						$j=0; 
					
						$count = mysqli_num_rows($result3);
						while($row3=mysqli_fetch_row($result3)){						///////////////////////////////// ตัวเลือกกี่ข้อ ก ข
							$j++;
							$qtn_qq_m_id = $row3[0];
							$qtn_qq_m_name=$row3[2];
							$qtn_qq_m_num=$row3[3];
							$min = $row3[4];
							$max = $row3[5];
							$qtn_qq_m_total = $row3[6];
							$qtn_op_id=$row3[7];				
							
							if(($qtn_op_id==1) or ($qtn_op_id==2) or ($qtn_op_id==3)){
									if($type==1){
									$sql_13="select * from questionnaire_answer where (qtn_use_id='$qtn_use_id') and (qtn_qq_id='$qtn_qq_id') and (qtn_qq_m_id='$qtn_qq_m_id') and (user_id='$officer')";
									}
									else{
									$sql_13="select * from questionnaire_answer where (qtn_use_id='$qtn_use_id') and (qtn_qq_id='$qtn_qq_id') and (qtn_qq_m_id='$qtn_qq_m_id') and (school_code='$user_school')";
									}
							$result_13=mysqli_query($connect,$sql_13);
							$num_rows_13 = mysqli_num_rows($result_13);
							}
							
							if($qtn_op_id==1){
							$val=$_POST["$qtn_qq_id$qtn_qq_m_id"];
									if($num_rows_13>=1){
											if($type==1){
											$sql_11="update questionnaire_answer set qtn_value1='$val',qtn_time='$rec_date' where (qtn_use_id='$qtn_use_id') and (qtn_qq_id='$qtn_qq_id') and (qtn_qq_m_id='$qtn_qq_m_id') and (user_id='$officer')"; 
											}
											else{
											$sql_11="update questionnaire_answer set qtn_value1='$val',qtn_time='$rec_date',user_id='$officer' where (qtn_use_id='$qtn_use_id') and (qtn_qq_id='$qtn_qq_id') and (qtn_qq_m_id='$qtn_qq_m_id') and (school_code='$user_school')"; 
											}
									$dbquery = mysqli_query($connect,$sql_11);
									}
									else if(isset($_POST["$qtn_qq_id$qtn_qq_m_id"])){
											if($_POST["$qtn_qq_id$qtn_qq_m_id"]!=""){
											$sql11="insert into questionnaire_answer(qtn_use_id,qtn_qq_id,qtn_qq_m_id,qtn_value1,user_id,qtn_time,school_code) values('$qtn_use_id','$qtn_qq_id','$qtn_qq_m_id','$val','$officer','$rec_date','$user_school')";	
											$dbquery = mysqli_query($connect,$sql11);
											}
									}
							}
							else if($qtn_op_id==2){
							$val=$_POST["$qtn_qq_id$qtn_qq_m_id"];
									if($num_rows_13>=1){
												if($type==1){
												$sql_22="update questionnaire_answer set qtn_value2='$val',qtn_time='$rec_date' where (qtn_use_id='$qtn_use_id') and (qtn_qq_id='$qtn_qq_id') and (qtn_qq_m_id='$qtn_qq_m_id') and (user_id='$officer')"; 
												}
												else{
												$sql_22="update questionnaire_answer set qtn_value2='$val',qtn_time='$rec_date',user_id='$officer' where (qtn_use_id='$qtn_use_id') and (qtn_qq_id='$qtn_qq_id') and (qtn_qq_m_id='$qtn_qq_m_id') and (school_code='$user_school')"; 
												}
									$dbquery = mysqli_query($connect,$sql_22);
									}
									else if(isset($_POST["$qtn_qq_id$qtn_qq_m_id"])){
											if($_POST["$qtn_qq_id$qtn_qq_m_id"]!=""){
											$sql22="insert into questionnaire_answer(qtn_use_id,qtn_qq_id,qtn_qq_m_id,qtn_value2,user_id,qtn_time,school_code) values('$qtn_use_id','$qtn_qq_id','$qtn_qq_m_id','$val','$officer','$rec_date','$user_school')";	
											$dbquery = mysqli_query($connect,$sql22);
											}
									}
							}else if($qtn_op_id==3){
							$val=$_POST["$qtn_qq_id$qtn_qq_m_id"];
									if($num_rows_13>=1){
											if($type==1){
											$sql_33="update questionnaire_answer set qtn_value3='$val',qtn_time='$rec_date' where (qtn_use_id='$qtn_use_id') and (qtn_qq_id='$qtn_qq_id') and (qtn_qq_m_id='$qtn_qq_m_id') and (user_id='$officer')"; 
											}
											else{
											$sql_33="update questionnaire_answer set qtn_value3='$val',qtn_time='$rec_date',user_id='$officer' where (qtn_use_id='$qtn_use_id') and (qtn_qq_id='$qtn_qq_id') and (qtn_qq_m_id='$qtn_qq_m_id') and (school_code='$user_school')"; 
											}
									$dbquery = mysqli_query($connect,$sql_33);
									}
									else if(isset($_POST["$qtn_qq_id$qtn_qq_m_id"])){
											if($_POST["$qtn_qq_id$qtn_qq_m_id"]!=""){
											$val=$_POST["$qtn_qq_id$qtn_qq_m_id"];
											$sql33="insert into questionnaire_answer(qtn_use_id,qtn_qq_id,qtn_qq_m_id,qtn_value3,user_id,qtn_time,school_code) values('$qtn_use_id','$qtn_qq_id','$qtn_qq_m_id','$val','$officer','$rec_date','$user_school')";	
											$dbquery = mysqli_query($connect,$sql33);
											}
									}
							}else if($qtn_op_id==4){
									if($type==1){
									$sql_44="select * from questionnaire_answer where (qtn_use_id='$qtn_use_id') and (qtn_qq_id='$qtn_qq_id') and (qtn_qq_m_id='$qtn_qq_m_id') and (user_id='$officer')";
									}
									else{
									$sql_44="select * from questionnaire_answer where (qtn_use_id='$qtn_use_id') and (qtn_qq_id='$qtn_qq_id') and (qtn_qq_m_id='$qtn_qq_m_id') and (school_code='$user_school')";
									}
							$result_44=mysqli_query($connect,$sql_44);
							$num_rows_44 = mysqli_num_rows($result_44);
							//ลบข้อมูลเดิม
							if($num_rows_44>=1){
									if($type==1){
									$sql = "delete from questionnaire_answer where (qtn_use_id='$qtn_use_id') and (qtn_qq_id='$qtn_qq_id') and (qtn_qq_m_id='$qtn_qq_m_id') and (user_id='$officer')";
									}
									else{
									$sql = "delete from questionnaire_answer where (qtn_use_id='$qtn_use_id') and (qtn_qq_id='$qtn_qq_id') and (qtn_qq_m_id='$qtn_qq_m_id') and (school_code='$user_school')";
									}
							$dbquery = mysqli_query($connect,$sql);
							}
									//บันทึกข้อมูลใหม่	
									$sql4="select * from questionnaire_qq_member_other where qtn_qq_m_id=$qtn_qq_m_id order by qtn_qq_mo_id";
									$result4=mysqli_query($connect,$sql4);
									$k=0;
									while($row4=mysqli_fetch_row($result4)){  /////////////////////////// ชื่อ Radio
									$qtn_qq_mo_id = $row4[0];
														if(isset($_POST["$qtn_qq_id$qtn_qq_m_id"])){
																	if($_POST["$qtn_qq_id$qtn_qq_m_id"]==$qtn_qq_mo_id){
																	$sql444="insert into questionnaire_answer(qtn_use_id,qtn_qq_id,qtn_qq_m_id,qtn_value4,user_id,qtn_time,school_code) values('$qtn_use_id','$qtn_qq_id','$qtn_qq_m_id','$qtn_qq_mo_id','$officer','$rec_date','$user_school')";	
																	$dbquery = mysqli_query($connect,$sql444);
																	}
														}
								////////////////////////////////////////////////
										$k++;
									}  //end while
							}  //end else if($qtn_op_id==4){
							else if($qtn_op_id==5){
									if($type==1){
									$sql_55="select * from questionnaire_answer where (qtn_use_id='$qtn_use_id') and (qtn_qq_id='$qtn_qq_id') and (qtn_qq_m_id='$qtn_qq_m_id') and (user_id='$officer')";
									}
									else{
									$sql_55="select * from questionnaire_answer where (qtn_use_id='$qtn_use_id') and (qtn_qq_id='$qtn_qq_id') and (qtn_qq_m_id='$qtn_qq_m_id') and (school_code='$user_school')";
									}
							$result_55=mysqli_query($connect,$sql_55);
							$num_rows_55 = mysqli_num_rows($result_55);
							//ลบข้อมูลเดิม
							if($num_rows_55>=1){
									if($type==1){
									$sql = "delete from questionnaire_answer where (qtn_use_id='$qtn_use_id') and (qtn_qq_id='$qtn_qq_id') and (qtn_qq_m_id='$qtn_qq_m_id') and (user_id='$officer')";
									}
									else{
									$sql = "delete from questionnaire_answer where (qtn_use_id='$qtn_use_id') and (qtn_qq_id='$qtn_qq_id') and (qtn_qq_m_id='$qtn_qq_m_id') and (school_code='$user_school')";
									}
							$dbquery = mysqli_query($connect,$sql);
							}
									//บันทึกข้อมูลใหม่	
									$sql55="select * from questionnaire_qq_member_other where qtn_qq_m_id='$qtn_qq_m_id'";
									$result55=mysqli_query($connect,$sql55);
									while($row55=mysqli_fetch_row($result55)){  
									$qtn_qq_mo_id = $row55[0];
												if(isset($_POST["$qtn_qq_id$qtn_qq_m_id$qtn_qq_mo_id"])){
												$sql555="insert into questionnaire_answer(qtn_use_id,qtn_qq_id,qtn_qq_m_id,qtn_qq_mo_id,qtn_value5,user_id,qtn_time,school_code) values('$qtn_use_id','$qtn_qq_id','$qtn_qq_m_id','$qtn_qq_mo_id','$qtn_qq_mo_id','$officer','$rec_date','$user_school')";	
												$dbquery = mysqli_query($connect,$sql555);
												}
									}										
							}//end if $qtn_op_id==5){
						}  //end while row3
				} //end while row2
				//////////////////////////
			}  //end while row 
			?> <script>
			alert("บันทึกข้อมูลเรียบร้อยแล้ว โปรดตรวจสอบความถูกต้องอีกครั้ง");
			</script> 
			<?php
$index=7;	
} //end if index==4

if($index==7){  
$qtn_use_id=$_REQUEST['qtn_use_id'];
$sql="select * from questionnaire_use_qtn_name where qtn_use_id='$qtn_use_id' limit 0,1";
$dbquery = mysqli_query($connect,$sql);
$row=mysqli_fetch_array($dbquery);
$qtn_use_name=$row['qtn_use_name'];
$qtn_id=$row['qtn_id'];
$qtn_desc=$row['qtn_desc'];

echo "<form id='frm1' name='frm1'>";	
?>

<TABLE border="1" width="75%" align="center" style="border-collapse: collapse">
<tr><td colspan="2" valign="top">

<TABLE cellpadding="5" cellspacing="5" border="0" width="100%" align="center">
<TR bgcolor="#000000" height="30">
	<TD colspan="10" align=center style="font-family:Tahoma; font-size:10pt;"><font color="#FFFFFF"><b>ชื่อแบบสอบถาม</b> : 
	<?php
	$sql="select * from questionnaire_use_qtn_name where qtn_use_id='$qtn_use_id' limit 0,1";
			$result=mysqli_query($connect,$sql);
			while($row=mysqli_fetch_array($result)){ /////////////////// ชื่อ template
				$qtn_name=$row['qtn_use_name'];
				$qtn_id=$row['qtn_id'];
				$qtn_desc=$row['qtn_desc'];
				$type=$row['type'];
				
				echo "&nbsp;$qtn_name</td>";
				echo "</tr>";
	echo "<tr><td colspan='10' align='left'>";
	echo "<b>คำชี้แจง</b>&nbsp&nbsp$qtn_desc";
	echo "</td></tr>";			
				echo "<tr><td colspan='2' valign='top'>";
				/////////////////////////////////////////////////
				
				/////////////////////////////////////////////////
				$sql2="select * from questionnaire_qq  where qtn_id='$qtn_id' order by order_id ,qtn_qq_id";
				$result2=mysqli_query($connect,$sql2);
				$i=0;
				$k=0;
				while($row2=mysqli_fetch_array($result2)){  /////////////////////////// ชื่อคำถามที่
					$qtn_qq_id=$row2['qtn_qq_id'];
					
	// ตรวจรายละเอียดแต่ละข้อ					
			$sql_44="select * from questionnaire_use_qtn where (qtn_use_id='$qtn_use_id') and (qtn_qq_id='$qtn_qq_id')";
			$dbquery44=mysqli_query($connect,$sql_44);
			$result44=mysqli_fetch_array($dbquery44);
			if($result44['school']=='no_sch'){
			continue;
			}
			$member_grp=0;	
			if($result44['school']>0){	
					$sql_grp= "select * from questionnaire_school_in_group where (grp_id='$result44[school]') and (school_id='$user_school')";		
					$dbquery_grp=mysqli_query($connect,$sql_grp);
					$member_grp=mysqli_num_rows($dbquery_grp);
						if($member_grp<1){
						continue;
						}
			}	
		//จบคัดกรองรายข้อ
				
					$i++;
					echo "<TABLE id='tb_q' cellpadding='5' cellspacing='2' border='0' width=100%>";
					echo "<TR bgcolor='#5e5e5e' height='30'>";
					echo "<TD colspan='8' align='left' style='font-family:Tahoma; font-size:10pt;'><font color='#FFFFFF'><b>&nbsp;คำถามที่$i&nbsp;$row2[2]";
				
// มีเอกสาร
					$sql_upload="select * from  questionnaire_upload  where  qtn_use_id='$qtn_use_id' and qtn_qq_id='$qtn_qq_id' ";
					$dbquery_upload=mysqli_query($connect,$sql_upload);
					$upload_num=mysqli_num_rows($dbquery_upload);
					if($upload_num>=1){
					echo "&nbsp;&nbsp;&nbsp;<a href=?qtn_use_id=$qtn_use_id&qtn_qq_id=$qtn_qq_id&index=2><img src=../../../images/admin/book.gif alt='เอกสารประกอบการรายงาน' border='0' target='_blank'><font size='1' color='#FFFFFF'>[เอกสารประกอบ]</font></a>";
					}
					echo "</td>";
					
//ส่วนของการแสดงuploade_file		
					if($result44['upload_file']=='1'){
					echo "<td width='20' align='center'><a href=?qtn_use_id=$qtn_use_id&qtn_qq_id=$qtn_qq_id&index=3><img src=../../../images/icon/arrow_up.gif alt='ข้อนี้สามารถ Upload ได้' border='0' target='_blank'></a></td>";  	
					}
					else {
					echo "<td width='20'>&nbsp;</td>";
					}
					echo "</tr>";
//เลือกตัวแปร					
						$sql3="select * from questionnaire_qq_member where qtn_qq_id = $qtn_qq_id order by qtn_qq_m_id";
						$result3=mysqli_query($connect,$sql3);
						$j=0; 
					
						$count = mysqli_num_rows($result3);
						while($row3=mysqli_fetch_row($result3)){						///////////////////////////////// ตัวเลือกกี่ข้อ ก ข
							$j++;
							$qtn_qq_m_id = $row3[0];
							$qtn_qq_m_name=$row3[2];
							$qtn_qq_m_num=$row3[3];
							$min = $row3[4];
							$max = $row3[5];
							$qtn_qq_m_total = $row3[6];
							$qtn_op_id=$row3[7];						
							echo "<tr><td valign=top align='left'><b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $j)&nbsp;$qtn_qq_m_name </b></td></tr>";
							echo "<tr><td align='left'>";
							
							if(($qtn_op_id==1) or ($qtn_op_id==2) or ($qtn_op_id==3) or ($qtn_op_id==4)){
									if($type==1){
									$sql_13="select * from questionnaire_answer where (qtn_use_id='$qtn_use_id') and (qtn_qq_id='$qtn_qq_id') and (qtn_qq_m_id='$qtn_qq_m_id') and (user_id='$officer')";
									}
									else{
									$sql_13="select * from questionnaire_answer where (qtn_use_id='$qtn_use_id') and (qtn_qq_id='$qtn_qq_id') and (qtn_qq_m_id='$qtn_qq_m_id') and (school_code='$user_school')";
									}
							$dbquery_13=mysqli_query($connect,$sql_13);
							$result_answer = mysqli_fetch_array($dbquery_13);
							$qtn_value1=$result_answer['qtn_value1'];
							$qtn_value2=$result_answer['qtn_value2'];
							$qtn_value3=$result_answer['qtn_value3'];
							$qtn_value4=$result_answer['qtn_value4'];
							}

if($qtn_op_id==1){
								echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<INPUT TYPE='text' NAME='$qtn_qq_id$qtn_qq_m_id' value='$qtn_value1' onKeyDown='DigitOnly();'>&nbsp;&nbsp;$qtn_qq_m_num";
							}
							else if($qtn_op_id==2){
								echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<INPUT TYPE='text' NAME='$qtn_qq_id$qtn_qq_m_id' value='$qtn_value2'>";
							}else if($qtn_op_id==3){
								echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<TEXTAREA NAME='$qtn_qq_id$qtn_qq_m_id' ROWS='7' COLS='50'>$qtn_value3</TEXTAREA>";
							}else if($qtn_op_id==4){
								$sql4="select * from questionnaire_qq_member_other where qtn_qq_m_id=$qtn_qq_m_id order by qtn_qq_mo_id";
								$result4=mysqli_query($connect,$sql4);
								while($row4=mysqli_fetch_row($result4)){  /////////////////////////// ชื่อ Radio
								$qtn_qq_mo_id = $row4[0];
								if($qtn_qq_mo_id==$qtn_value4){
								$select4="checked";
								}
								else{
								$select4="";
								}
								echo   "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<INPUT TYPE='$row4[3]' NAME='$qtn_qq_id$qtn_qq_m_id' value='$qtn_qq_mo_id' $select4>$row4[2]<br>";			
								}  
							}
							else if($qtn_op_id==5){
								$sql5="select * from questionnaire_qq_member_other where qtn_qq_m_id=$qtn_qq_m_id order by qtn_qq_mo_id";
								$result5=mysqli_query($connect,$sql5);
								$k=0;
								while($row5=mysqli_fetch_row($result5)){  /////////////////////////// 
								$qtn_qq_mo_id = $row5[0];
										if($type==1){
										$sql_55="select * from questionnaire_answer where (qtn_use_id='$qtn_use_id') and (qtn_qq_id='$qtn_qq_id') and (qtn_qq_m_id='$qtn_qq_m_id') and (qtn_qq_mo_id='$qtn_qq_mo_id')and (user_id='$officer')";
										}
										else{
										$sql_55="select * from questionnaire_answer where (qtn_use_id='$qtn_use_id') and (qtn_qq_id='$qtn_qq_id') and (qtn_qq_m_id='$qtn_qq_m_id') and (qtn_qq_mo_id='$qtn_qq_mo_id')and (school_code='$user_school')";
										}
								$dbquery_55=mysqli_query($connect,$sql_55);
								$result_answer = mysqli_fetch_array($dbquery_55);
								$qtn_value5=$result_answer['qtn_value5'];
								
								if($qtn_qq_mo_id==$qtn_value5){
								$select5="checked";
								}
								else{
								$select5="";
								}
								
									echo  "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<INPUT TYPE='$row5[3]' NAME='$qtn_qq_id$qtn_qq_m_id$qtn_qq_mo_id' $select5>$row5[2]<br>";			
									$k++;
								}  
							}
						echo " </td>";
						}
						echo "</tr>";  
						echo "</table>";
				}
				//////////////////////////
				echo "</td></tr>";
			}  
?>
	<tr><td colspan="2" align="center">
	</TABLE>

</td></tr>
<TR bgcolor="#AEB6BF" height="10"><TD  align="center" style="font-family:Tahoma; font-size:10pt;"></TD></TR>
</TABLE>
<?php
echo "<br>";
echo "<Input Type='Hidden' Name='qtn_use_id' Value='$qtn_use_id'>";
echo "<div align='center'><INPUT TYPE='button' name='smb' value='ตกลง' onclick='goto_url(1)'></div>";
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 "</form>";
}

//ส่วนแสดงผล
if(!(($index==1) or ($index==2) or ($index==3) or ($index==5) or ($index==7))){
$today= date("Y-m-d"); 
$sql = "select *,questionnaire_use_qtn_name.qtn_use_id from questionnaire_use_qtn_name left join questionnaire_on on  questionnaire_use_qtn_name.qtn_use_id=questionnaire_on.qtn_use_id where (questionnaire_on.start<='$today' and questionnaire_on.stop>='$today') ";
$dbquery = mysqli_query($connect,$sql);
echo "<br>";
echo "</table>";
echo  "<table width='80%' border='1' align='center' style='border-collapse: collapse'>";
echo "<Tr bgcolor='#E6E6E6'><Td align='center' width='50' rowspan='2' >ที่</Td><Td align='center' rowspan='2'>ชื่อแบบสอบถาม</Td><Td align='center' colspan='2'>ประเภทการตอบ</Td><Td align='center' rowspan='2' width='170'>ระยะเวลาตอบ</Td><Td align='center' width='120' rowspan='2' width='100'>ตอบแบบสอบถาม</Td></Tr>";
echo "<Tr><td align='center' width='100'>โรงเรียน</Td><td align='center' width='100'>บุคคล</Td></Tr>";

$M=1;
$all_show=0;
While ($result = mysqli_fetch_array($dbquery))
	{
		$qtn_use_id = $result['qtn_use_id'];
		$start= $result['start'];
		$start= thai_date_3($start);
		$stop= $result['stop'];
		$stop= thai_date_3($stop);
		$type= $result['type'];

$show=0;
		
					//ตรวจสอบว่าใช้กับโรงเรียนนี้หรือไม่
					$sql_1= "select * from questionnaire_use_qtn where qtn_use_id='$qtn_use_id'";
					$dbquery_1=mysqli_query($connect,$sql_1);    //มีการกำหนดรายละเอียดแบบสอบถามหรือไม่
					$count_1 = mysqli_num_rows($dbquery_1);
					// ไม่มีการกำหนดรายละเอียดแบบสอบถามให้แสดงรายชื่อแบบสอบถาม
					if($count_1==0){
					$show=1;
					}
					
					//มีการกำหนดกลุ่มหรือไม่  แล้วโรงเรียนเป็นสมาชิกกลุ่มหรือไม่
					While ($result_1 = mysqli_fetch_array($dbquery_1)){
					$school=$result_1['school'];
							if($school>=1){
							$sql_grp= "select * from questionnaire_school_in_group where (grp_id='$school') and (school_id='$user_school')";		
							$dbquery_grp=mysqli_query($connect,$sql_grp);
							$count_grp = mysqli_num_rows($dbquery_grp);
									if($count_grp>=1){
									$show=1;
									}
							}
					}
					
					//ใช้กับทุกโรงเรียนหรือไม่
					$sql_2= "select * from questionnaire_use_qtn where (qtn_use_id='$qtn_use_id') and (school='all_sch')";
					$dbquery_2=mysqli_query($connect,$sql_2);
					$count_2 = mysqli_num_rows($dbquery_2);
					if($count_2>=1){
					$show=1;
					}
					//จบตรวจสอบว่าใช้กับโรงเรียนนี้หรือไม่
					
		if(($M%2) == 0)
		$color="#FFFFC";
		else $color="#FFFFFF";
		
		if($show==1){
		$all_show=$all_show+1;
		echo "<Tr bgcolor=$color><Td align='center'>$M</Td>";
		echo "<Td align='left'>$result[qtn_use_name]</Td>";
		echo "<Td align='center'>";
		if($type==0){
		echo "<img src=../../../images/yes.png border='0'>";
		}
		echo "</Td>";
		echo "<Td align='center'>";
		if($type==1){
		echo "<img src=../../../images/yes.png border='0'>";
		}
		echo "</Td>";
		echo "<Td align='center'>$start - $stop</Td>";
				if($type==1 or $_GET['permission']==1){
echo "<Td align='center'><a href=?qtn_use_id=$qtn_use_id&index=7&remote_user_office=$remote_user_office&remote_user_id=$remote_user_id&remote_login_status=$remote_login_status><img src=../../../images/b_browse.png border='0' alt='ตอบ'></a></Td>";	
				}
				else{
				echo "<td></td>";
				}
		echo "</Tr>";
		$M++;
		 }
	}
echo "</Table>";
			if($all_show==0){
			?> <script>
			alert("ไม่มีแบบสอบถามที่เปิดให้ตอบในขณะนี้");
			</script> 
			<?php
			}
}

echo "<br><br>";
if(!(($index==1) or ($index==2) or ($index==3) or ($index==5) or ($index==7))){
echo  "<table width='80%' border='0' align='center'>";
echo "<tr><td width='70'><b>หมายเหตุ</b></td><td>แบบสอบถามประเภทโรงเรียน หมายถึง  ผู้อำนวยการโรงเรียน หรือผู้ที่ได้รับมอบหมายเป็นผู้ตอบ โรงเรียนละ 1 ฉบับ</td></tr>";
echo "<tr><td width='70'></td><td>แบบสอบถามประเภทบุคคล หมายถึง แต่ละคนในโรงเรียนตอบแบบสอบถามคนละ 1 ฉบับ</td></tr>";
echo "</table>";
}
?>
<script>
function callfrm(dest)
	{
		frm1.target = "_self"
		frm1.action = dest
		frm1.method = "POST"
		frm1.submit()
	}

function goto_url(val){
	if(val==1){
			callfrm("?index=4"); 
	}
}

function DigitOnly(){
	if ((event.keyCode>=96)&&(event.keyCode<=105))		
		return;
	if ((event.keyCode>=48)&&(event.keyCode<=57))	
		return;
	if (event.keyCode==8 || event.keyCode==9)
		return;
	if ((event.keyCode==37)||(event.keyCode==39)||(event.keyCode==46))
		return;
	if(event.keyCode==13)
		return;
	event.returnValue=false;	
}
</script>

${this.title}

Code Editor : sch_answer_qtn.php