MINI SHELL

Server : Apache/2.2.2 (Fedora)
System : Linux App1.pathumtani.go.th 2.6.20-1.2320.fc5smp #1 SMP Tue Jun 12 19:40:16 EDT 2007 i686
User : apache ( 48)
PHP Version : 5.2.9
Disable Function : NONE
Directory :  /var/www/html/pathumthani_eoffice/application/CA2/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : /var/www/html/pathumthani_eoffice/application/CA2/ca_member_dashboard.php
<?
@session_start() ;

require_once "config/config.ini.php";
require_once "common/database.class.php";
include("../../common/CA/class.openssl.php");
$db = new database();
$x=$db->connect();

if($action=="del"&&$id){
	$strSQL="DELETE FROM `ca_member` WHERE (`id`='$id')  ";
	@mysql_query($strSQL);
	echo "<script language=javascript>alert('ทำการลบข้อมูล $id เรียบร้อย');</script>";
}

if($_SERVER[REQUEST_METHOD] == "POST"){	
  $strSQL=" SELECT	ca_member.id FROM ca_member WHERE ca_member.key_status IS NULL ";
  $result=mysql_query($strSQL);
  $i=0;
  while($row=mysql_fetch_assoc($result)){
  $i++;
  	if($_POST["checkbox_".$row[id]]){ 
	$id=$_POST["checkbox_".$row[id]];
	$strSQL="
	UPDATE `ca_member` SET
	`key_status`='approve'
	WHERE
	`member_id`='$id'
	";
	echo "<pre>".$strSQL;
	@mysql_query($strSQL);	
	}
  }
  if($i>0){	echo "<script language=javascript>alert('ปรับปรุงการอนุมัติเรียบร้อย');</script>"; }
}


?>

<html>
<head>
<title></title>
<META http-equiv=Content-Type content="text/html; charset=windows-874">
<SCRIPT language='javascript' src='daily_popcalendar.js'></SCRIPT>
<SCRIPT language='javascript' src='displayelement.js'></SCRIPT>
<style type="text/css">
<!--
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
}
.comment{
	color:#F00;	
}

INPUT{
	FONT-SIZE: 12px; FONT-FAMILY: Tahoma,  "Microsoft Sans "; 
}
-->
</style>
<link href="css/style.css" rel="stylesheet" type="text/css">
</head>
<body>
<form action="" method="post" name="frm1" onSubmit= "return ValidateDoc()">
<table width="100%" border="0" cellspacing="5" cellpadding="0">
  <tr>
    <td align="right"><input type="reset" name="Submit2" value="เพิ่มข้อมูลใหม่" style="width:160px" onClick="window.location='ca_member.php'"/></td>
  </tr>
</table>

<table width="100%" border="0" cellspacing="0" cellpadding="10">
  <tr>
    <td align="center">
	<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#CCCCCC">
	  <tr>
		<td><table width="100%" border="0" cellpadding="0" cellspacing="1">
		  <tr>
			<th width="56" height="25" align="center" bgcolor="#FFFFFF"><strong>ลำดับ</strong></th>
			<th width="132" align="center" bgcolor="#FFFFFF"><strong>ชื่อ-สกุล</strong></th>
			<th width="103" align="center" bgcolor="#FFFFFF"><strong>หน่วยงาน</strong></th>
			<th width="93" align="center" bgcolor="#FFFFFF"><strong>โทรศัพท์</strong></th>
			<th width="144" align="center" bgcolor="#FFFFFF"><strong>หมายเลขประจำตัว</strong></th>
			<th width="187" align="center" bgcolor="#FFFFFF"><strong>ที่อยู่</strong></th>
			<th width="70" align="center" bgcolor="#FFFFFF" class="mainlevel"><strong>อนุมัติ</strong></th>
			<th width="40" align="center" bgcolor="#FFFFFF" class="mainlevel">&nbsp;</th>
		  </tr>
		  <?
		  $strSQL="
		  SELECT
			ca_member.id,
			ca_member.member_id,
			ca_member.ps_prename_th,
			ca_member.ps_name_th,
			ca_member.ps_surname_th,
			ca_member.org_id,
			org_staffgroup.groupname,
			ca_member.org_tel,
			ca_member.ps_card_ID,
			ca_member.ps_home_no,
			ca_member.ps_home_moo,
			ca_member.ps_home_soi,
			ca_member.ps_home_road,
			ca_member.ps_home_villa,		
			ca_member.ps_home_tambon,
			ca_member.ps_home_amphur,
			ca_member.ps_home_province,
			ca_member.ps_home_zipcode
		FROM
			ca_member
			Inner Join org_staffgroup ON ca_member.org_id = org_staffgroup.gid
		";
		//echo "<pre>". $strSQL;
		$result=@mysql_query($strSQL);
		$i=0;
		while($row=mysql_fetch_assoc($result)){ $i++;
		$bgcolor=$bgcolor=='#f1f1f1'?'#ffffff':'#f1f1f1';
		?>
      <tr bgcolor="<?=$bgcolor?>" >
        <td height="24" align="center" valign="top"><?=$i?></td>
        <td align="left" valign="top"><?=$row['ps_prename_th'].$row['ps_name_th']." ".$row['ps_surname_th'];?></td>
        <td align="left" valign="top"><?=$row['groupname']?></td>
        <td align="center" valign="top"><?=$row['org_tel']?></td>
        <td align="center" valign="top"><?=$row['ps_card_ID']?></td>
        <td align="left" valign="top"><span class="mainlevel">
		<?php
		if($row['ps_home_no']){echo $row['ps_home_no']; }
		if($row['ps_home_moo']){echo " ".$row['ps_home_moo']; }
		if($row['ps_home_soi']){echo " ซอย".$row['ps_home_soi']; }
		if($row['ps_home_road']){echo " ถนน".$row['ps_home_road']; }
		if($row['ps_home_villa']){echo " ".$row['ps_home_villa']; }
		if($row['ps_home_tambon']){echo " ต.".$row['ps_home_tambon']; }
		if($row['ps_home_amphur']){echo " อ.".$row['ps_home_amphur']; }
		if($row['ps_home_province']){echo " จ.".$row['ps_home_province']; }
		if($row['ps_home_zipcode']){echo " ".$row['ps_home_zipcode']; }
		?></td>
        <td align="center" class="mainlevel"><input type="checkbox" name="checkbox_<?=$row['id']?>" value="<?=$row['id']?>" /></td>
        <td align="center" class="mainlevel"><a href="ca_member.php?id=<?=$row['id']?>&action=edit" ><img src="../../images/ico_trans_edit.gif" alt="แก้ไข" width="16" height="16" border="0" /></a> &nbsp;<a href="?action=del&id=<?=$row['id']?>" onClick="return confirm('ต้องการลบข้อมูลรหัส <?=$row['id']?> จริงกรือไม่! ')"><img src="../../images/ErrorCircle-16x16.png" alt="ลบ" width="16" height="16" border="0" /></a></td>
      </tr>
	  <?  }  ?>
      <tr bgcolor="<?=$bgcolor?>" >
        <td height="24" colspan="6" align="right" bgcolor="#FFFFFF">&nbsp;&nbsp;&nbsp;&nbsp;		  </td>
        <td height="24" colspan="2" align="left" bgcolor="#FFFFFF"><input type="submit" name="Submit" value="บันทึกสถานะอนุมัติ" style="width:160px" onClick="return confirm('ต้องการบันทึกผลการอนุมัติจริงหรือไม่')"/></td>
        </tr>	  
    </table>
	
	</td>
  </tr>
</table>
</td>
  </tr>
</table>
</form>
</body>
</html>

Anon7 - 2021