Gecko [ 122.154.134.11 ]

Name	Size	Permission
download.php	2.02 KB	-rw-r--r--
group.php	5.55 KB	-rwxr-xr-x
group_member.php	4.34 KB	-rwxr-xr-x
group_member_report.php	2.99 KB	-rwxr-xr-x
livesearch.php	595 B	-rwxr-xr-x
maildetail.php	9.73 KB	-rwxr-xr-x
maildetail.php-1	4.72 KB	-rwxr-xr-x
maildetailx.php	5.11 KB	-rw-r--r--
permission.php	8.41 KB	-rwxr-xr-x
receive.php	8.81 KB	-rwxr-xr-x
receive.php-1	6.99 KB	-rwxr-xr-x
receive.php-2	7.35 KB	-rwxr-xr-x
receive_mobile.php	7.25 KB	-rwxr-xr-x
search.php	11.3 KB	-rwxr-xr-x
select_send.php	6.45 KB	-rwxr-xr-x
select_send.php-1	5.58 KB	-rwxr-xr-x
select_send_2.php	6.57 KB	-rwxr-xr-x
select_send_3.php	8.89 KB	-rwxr-xr-x
send.php	30.19 KB	-rwxr-xr-x
send.php-1	28.82 KB	-rwxr-xr-x
send_mobile.php	27.75 KB	-rwxr-xr-x
sendto_show.php	2.8 KB	-rwxr-xr-x
sendto_show.php-1	2.19 KB	-rwxr-xr-x

Code Editor : select_send_3.php

<?php
if(isset($_REQUEST['ref_id'])){
$ref_id=$_REQUEST['ref_id']; 
}
else{
		session_start();
		if(!(isset($_SESSION['login_user_id']))){
		exit();
		}
		$ref_id= $_SESSION ['ref_id'] ;
}

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

if(!(isset($_REQUEST['hide_index']))){
$_REQUEST['hide_index']="";
}
?>

<?php
if(isset($_SESSION['user_os'])){
	if($_SESSION['user_os']=='mobile'){
	echo "<meta name = 'viewport' content = 'width = device-width'>";
	}
}
?>
<link rel="stylesheet" href="css/mm_training.css" type="text/css" />

</head>

<div align="center">
<table border="0" width="100%" style="border-collapse: collapse">
		<tr>
			<td bgcolor="#800000"><font face="Tahoma"><font size="2">&nbsp;</font><span lang="th"><font size="2" color="#FFFFFF"><B>กรุณาคลิกเลือกผู้รับ</B></font></span></font> </td>
		</tr>
		</table>

<?php	
require_once "../../../amssplus_connect.php";	
require_once("../../../mainfile.php");

/////////////////////////////////////////////////////	
if(!(isset($_REQUEST['school_code']))){
$_REQUEST['school_code']="";
}

echo "<form name='frm1' action='select_send_3.php' method='post'>";
echo "<br>";
		if(isset($_SESSION['login_user_id'])){
		?>
		<div align='center'>
		<font size='2'>ค้นหาสถานศึกษา <input type="text" size="15" onKeyUp="showResult(this.value)">
		<div id="livesearch"></div>
		</font>
		</div>
		<?php
		}
echo "<div align='center'>";
echo "<br>";
echo "<font size='2'>เลือกสถานศึกษา</font>&nbsp";
echo "<Select  name='school_code' size='1' onChange='this.form.submit()'>";
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($_REQUEST['school_code']==""){
			echo "<option value=$result[school_code]>$result[school_code] $result[school_name]</option>"; 
			}
		else{
				if($_REQUEST['school_code']==$result['school_code']){
				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 "<input type='hidden' name='hide_index' value=1>"; 
	echo "<input type='hidden' name='sd_index'  id='sd_index' value=$sd_index>"; 
	echo "<input type='hidden' name='ref_id' value='$ref_id'>"; 
	
echo "</div>";
echo "</form>";
/////////////////////////
		
if($index==1){
$s_id=$_POST['s_id'];
	for ($i=1;$i<=$_POST['boxchecked'];$i++){
			if (isset($_POST['s_id'][$i])!="") // Check Select Topic
				{ 
					mysqli_query($connect,"INSERT INTO mail_sendto_answer (send_to,ref_id,answer_time) Values('$s_id[$i]','$ref_id','0000-01-01 00:00:00') ") ;
				}
		}
}

if($index==2){
mysqli_query($connect,"DELETE FROM mail_sendto_answer WHERE send_to='$_GET[sendtoname]' and ref_id='$ref_id' ") ;
}

if(($_REQUEST['hide_index']==1) or ($index==1)){
//**
?>
  <form method="POST" action="select_send_3.php" name="form1" onSubmit="return checkform();">
  <TABLE border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width=95% bordercolor="#808000" bgcolor="#FFFBEA">
     <TR >   
	 <td colspan=4>&nbsp;<input name="allbox" onClick="selectall();" type="checkbox"><FONT SIZE="2" COLOR="#990033">เลือก/ไม่เลือกทั้งหมด</FONT><HR></td>
	 </tr>
	 <tr>
<?php

$result1=mysqli_query($connect,"SELECT * FROM  person_sch_main WHERE (status='0' or status='9') and school_code='$_REQUEST[school_code]' order by position_code, name, surname ") ;
$num1 = mysqli_num_rows ($result1) ;

$list1=1;
while ($r1=mysqli_fetch_array($result1)) {
	$e_name = $r1['person_id'] ;
	$prename = $r1['prename'] ;
	$name = $r1['name'] ;
	$surname = $r1['surname'] ;
	$fullname=$prename.$name." ".$surname;
	
$result_select=mysqli_query($connect,"SELECT * FROM mail_sendto_answer WHERE send_to='$e_name' and ref_id='$ref_id'") ;
$num_select = mysqli_num_rows ($result_select) ;
	if ($num_select==0) {
	   ?>
		  <TD  width="25%">&nbsp;&nbsp;&nbsp;<input type="checkbox" name="s_id[<?php echo $list1?>]" value="<?php echo $e_name?>"><FONT SIZE="2" COLOR="#660099"><?php echo $fullname?></FONT></TD>
	
	<?php
	}
		if($list1%2==0){
		echo "</tr><tr>";}
$list1 ++ ;
} 
?>
 </TR>
  	 </table>
<BR><input name="boxchecked" type="hidden" id="boxchecked" value="<?php echo $list1?>"> <input name="sd_index" type="hidden"  value="<?php echo $sd_index?>"><input name="index" type="hidden"  value="1"><input name="school_code" type="hidden"  value="<?php echo $_REQUEST['school_code']?>"><input name="ref_id" type="hidden"  value="<?php echo $ref_id?>">
	 <CENTER><input type="submit" value="  เลือก  " name="submit">
<HR>	</form>

<?php

$result2=mysqli_query($connect,"SELECT * FROM mail_sendto_answer left join person_main on mail_sendto_answer.send_to=person_main.person_id WHERE mail_sendto_answer.ref_id='$ref_id' ") ;
$num2 = mysqli_num_rows ($result2) ;

?>
  <div align="center">
	<table border="0" width="100%"  style="border-collapse: collapse" bgcolor="#EAFFF0">
		<form method="POST" action="" name="form2" >
			<tr>
				<td>&nbsp;<b><font size="2" color="#800080">รายชื่อผู้รับสารที่เลือกไว้ 
				จำนวน <FONT SIZE="2" COLOR="#FF0066"><?php echo $num2 ?></FONT> คน</font></b></td>
			</tr>
			<tr>
				<td>
<?php
$list2=1;
while ($r2=mysqli_fetch_array($result2)) {
	$send_to=$r2['send_to'];
	$sendtoname  = $r2['send_to'] ;
	$e_name = $r2['person_id'] ;
	$prename = $r2['prename'] ;
	$name = $r2['name'] ;
	$surname = $r2['surname'] ;
	
						//กรณีโรงเรียน
					if($name==""){
					$sql= "select * from person_sch_main where person_id='$send_to' ";
					$dbquery= mysqli_query($connect,$sql);
					$result=mysqli_fetch_array($dbquery);
					$prename=$result['prename'];
					$name= $result['name'];
					$surname = $result['surname'];
					}

$fullname=$prename.$name." ".$surname;
?>&nbsp;<FONT SIZE="2" COLOR=""><A HREF="select_send_3.php?sendtoname=<?php echo $sendtoname?>&index=2&sd_index=<?php echo $sd_index?>&school_code=<?php echo $_REQUEST['school_code']?>&hide_index=1"><IMG SRC="../../../images/b_drop.png" WIDTH="16" HEIGHT="16" BORDER="0" ALT="ลบออก"></A>&nbsp; <?php echo $list2?>. <?php echo $fullname?></FONT><BR>
				
<?php
$list2 ++ ;
} 
?>			
				</td>
			</tr>
			<tr>
				<td>
				<p align="center">
				<input type="submit" value="  เสร็จ  " name="submit1" onClick="javascript:window.close()">
				</td>
			</tr>
		</form>
	</table>
</div><HR>
<?php
}
//**
?>
</body>
<script language="JavaScript">
<!--
function selectall(){
	for (var i=0;i<document.form1.elements.length;i++)
	{
		var e = document.form1.elements[i];
		if (e.name != 'allbox')
			e.checked = document.form1.allbox.checked;
	}
}

</html>

${this.title}

Code Editor : select_send_3.php