Gecko [ 122.154.134.11 ]

Name	Size	Permission
answer_qtn.php	20.81 KB	-rw-r--r--
create_qtn.php	9.78 KB	-rw-r--r--
create_question.php	18.13 KB	-rw-r--r--
create_use_qtn_detail.php	6.47 KB	-rw-r--r--
create_use_qtn_name.php	18.79 KB	-rw-r--r--
on_off_qtn.php	7.32 KB	-rw-r--r--
report1.php	14.43 KB	-rw-r--r--
report2.php	15.14 KB	-rw-r--r--
report3.php	5.03 KB	-rw-r--r--
school_group.php	14.59 KB	-rw-r--r--
school_group_show.php	7.51 KB	-rw-r--r--
upload_1.php	7.97 KB	-rw-r--r--
upload_2.php	1.69 KB	-rw-r--r--
view_qtn.php	16.22 KB	-rw-r--r--

Code Editor : create_use_qtn_detail.php

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

if($index==3){
$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);
$result = mysqli_fetch_array($dbquery);
$qtn_id=$result['qtn_id'];

$sql= "delete from questionnaire_use_qtn  where qtn_use_id='$qtn_use_id'";
$dbquery = mysqli_query($connect,$sql);

$sql2= "select * from questionnaire_qq  where qtn_id ='$qtn_id' order by order_id ,qtn_qq_id";
		$dbquery2 = mysqli_query($connect,$sql2);
		While ($result2 = mysqli_fetch_array($dbquery2)){
		$qtn_qq_id=$result2['qtn_qq_id'];

if(isset($_POST['school'][$qtn_qq_id])){
			$school=$_POST['school'][$qtn_qq_id];
			}
			else{
			$school="";
			}
			if(isset($_POST['upload_file'][$qtn_qq_id])){
			$upload=1;
			}
			else{
			$upload=0;
			}
			
			$sql4="insert into questionnaire_use_qtn(qtn_use_id,qtn_qq_id,school,upload_file,user_id,qtn_time) values('$qtn_use_id','$qtn_qq_id','$school','$upload','$officer','$rec_date')";	
			$dbquery4 = mysqli_query($connect,$sql4);
	}
 		?><script>
			alert("บันทึกข้อมูลเรียบร้อยแล้ว");
		</script><?php
$index=4;		
}

if($index==4){
	$sql="select * from questionnaire_use_qtn_name where qtn_use_id='$_REQUEST[qtn_use_id]' limit 0,1";
			$dbquery = mysqli_query($connect,$sql);
			$row=mysqli_fetch_array($dbquery);
			$qtn_id=$row['qtn_id'];
			$qtn_use_id=$row['qtn_use_id'];
	
$sql= "select * from  questionnaire_school_group order by grp_id desc";
	$dbquery= mysqli_query($connect,$sql);
	$grp_num=1;
	While ($result = mysqli_fetch_array($dbquery)){
	$grp_id[$grp_num]=$result['grp_id'];
	$grp_name[$grp_num]=$result['name'];
	$grp_num++ ;
	}

echo "<br/>";	
echo "<form id='frm1' name='frm1'>";
echo "<table width='100%' border='0' align='center'>";
echo "<tr align='center'><td><font color='#006666' size='3'><strong>ชื่อแบบสอบถาม : $row[qtn_use_name]</strong></font></td></tr>";
echo "</table>";
echo "<br/>";	
echo "<table width='90%' CELLSPACING='1' CELLPADDING='2' align='center'>";
	echo "<tr bgcolor='#ABB2B9' height='30'>";
	echo "<td align='center' width='5%'><b><font color='#FFFFFF'>ที่</b></font></td>";
	echo "<td align='center' width='50%'><b><font color='#FFFFFF'>ข้อคำถาม</b></font></td>";
	echo "<td align='center' width='30%'><b><font color='#FFFFFF'>ใช้ข้อคำถามกับกลุ่มเป้าหมาย</b></font></td>";
	echo "<td align='center'><b><font color='#FFFFFF'>Upload File ได้</b></font></td>";
	echo "<td align='center' width='70'><b><font color='#FFFFFF'>เอกสารประกอบ</b></font></td>";
	echo "</tr>";
	$sql2= "select * from questionnaire_qq  where qtn_id ='$qtn_id' order by order_id ,qtn_qq_id";
	$dbquery2 = mysqli_query($connect,$sql2);	
	$n=1;
	While ($result2 = mysqli_fetch_array($dbquery2)){
	$qtn_qq_id = $result2['qtn_qq_id'];
	$name = $result2['qtn_qq_name'];
					if(($n%2)==0){
						$bgcolor="#e8e8e8";
					}else{
						$bgcolor="#F5F5F5";
					}
				$sql_44="select * from questionnaire_use_qtn where (qtn_use_id='$qtn_use_id') and (qtn_qq_id='$qtn_qq_id')";
				$check="";
				
				$dbquery44= mysqli_query($connect,$sql_44);
				$result44 = mysqli_fetch_array($dbquery44);
					if($result44['upload_file']==1){
					$check="checked";
					}
		echo "<tr bgcolor=$bgcolor>";
		echo "<td align='center'>$n</td>";
		echo "<td align='left'>$name</td>";
		echo "<td align='center'>";
	
		echo "<select name='school[$qtn_qq_id]'>";
		
		echo "<option value='all_sch'";
		 	if($result44['school']=="all_sch"){
		  	$select="selected";
		  	}
			else {
			$select="";
			}
		echo "  $select>ทุกโรงเรียน</option>";
		
		echo "<option value='no_sch'";
			if($result44['school']=="no_sch"){
		  	$select="selected";
		  	}
			else {
			$select="";
			}
		echo " $select>งดใช้</option>";
		
		for($f=1;$f<$grp_num;$f++){
			if($result44['school']==$grp_id[$f]){
		  	$select="selected";
		  	}
			else {
			$select="";
			}
		echo "<option value=$grp_id[$f] $select>$grp_name[$f]</option>";
		}
		echo "</select>";
	
	
		echo "</td>";
		echo "<td align=center><INPUT TYPE='checkbox' NAME='upload_file[$qtn_qq_id]' $check value='1' ></td>";
		
		$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);
		$num_row=mysqli_num_rows($dbquery_upload);

echo "<td align='center'><a href=?option=questionnaire&task=main/upload_1&qtn_use_id=$qtn_use_id&qtn_qq_id=$qtn_qq_id><img src=images/admin/book.gif alt='Upload File' border=0 target=_blank></a>";
		if($num_row>0){
		echo "(".$num_row.")";
		}
		echo "</td>";  	
		echo "</tr>";
	$n++;	
	}	
echo "</table>";
echo "<br/>";
echo "<Input Type=Hidden Name='qtn_use_id' Value=$qtn_use_id>";
echo "<Input Type=Hidden Name='qtn_qq_id' Value=$qtn_qq_id>";
echo "<div align='center'>";
echo "<Input Type='Submit'  Value='ตกลง' onclick='goto_url(2)'>";
echo "</form>";
echo "</div>";
echo "<br/>";
echo "<br/>";
}

if(!($index==4)){
echo "<br/>";
echo "<form id='frm1' name='frm1'>";
echo "<TABLE cellpadding='5' cellspacing='5' border='0' width='90%' align='center'>";
echo "<TR bgcolor='#E6E6E6' height='30'>";
echo "<TD colspan=2 align='center'><B>กำหนดรายละเอียดการใช้แบบสอบถาม</B></TD></TR>";

echo "<TR><TD colspan='2' align='center'>เลือกแบบสอบถาม&nbsp;&nbsp;&nbsp;&nbsp;";
echo "<select name='qtn_use_id'>";

$sql= "select * from questionnaire_use_qtn_name  where officer='$officer' order by qtn_use_id desc";
$dbquery = mysqli_query($connect,$sql);
While ($result = mysqli_fetch_array($dbquery)){
	if($qtn_use_id==$result['qtn_use_id']){
		$select="selected";}
		else{
		$select="";
		}
	echo "<option value='$result[qtn_use_id]' $select>$result[qtn_use_name]</option>";
}
	echo "</select>" ;
echo "</TD></TR>";
echo "</TABLE>";
echo "<br>";
echo "<div align='center'>";
echo "<Input Type='Submit'  Value='ตกลง' onclick='goto_url(1)'>";
echo "</div>";
echo "</form>";
}
?>
<script>
function goto_url(val){
	if(val==1){
	callfrm("?option=questionnaire&task=main/create_use_qtn_detail&index=4");  
	}
	else if(val==2){
	callfrm("?option=questionnaire&task=main/create_use_qtn_detail&index=3");  
	}
}
</script>

${this.title}

Code Editor : create_use_qtn_detail.php