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/eoffice/application/tool/
Upload File :
Current File : /var/www/html/eoffice/application/tool/report_user_no_group.php
<? 
	include("../../config/config.inc.php");
	
	if($Aaction == "Update"){
			$strSQL_up = "REPLACE INTO org_groupmember(gid,staffid)VALUES('$group_id','$staffid')";
			$result_up = mysql_db_query($dbname,$strSQL_up);
			if($result_up){
					echo "<script>alert('บันทึกรายการเรียบร้อยแล้ว'); location.href='report_user_no_group.php?action=';</script>";
			}
	}// end if($Aaction == "Update"){
?>
<html>
<head>
<title>tool จัดกลุ่มงาน</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<LINK href="../../common/style.css" rel=stylesheet>
<script language='javascript' src='daily_popcalendar.js'></script>
<script language='javascript' src='displayelement.js'></script>
<script language='javascript' src='sorttable.js'></script>
<style type="text/css">
<!--
.header1 {	font-family:"MS Sans Serif", Tahoma, Arial;
	font-size:1em;
	font-weight:bold;
	color: #FFFFFF;
}
.main {	font-family:"MS Sans Serif", Tahoma, Arial;
	font-size:0.8em;
	color:#FF0000;
	font-weight:bold;
}
.normal {	font-family:"MS Sans Serif", Tahoma, Arial;
	font-size:0.8em;
}
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
}
-->
</style>
</head>
<body>
<? if($action == ""){?>
<table width="98%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#000000">
  <tr>
    <td width="93" align="center" bgcolor="#CCCCCC"><strong>ลำดับ</strong></td>
    <td width="767" align="center" bgcolor="#CCCCCC"><strong>ชื่อพนักงาน</strong></td>
    <td width="105" align="center" bgcolor="#CCCCCC">&nbsp;</td>
  </tr>
<?
		$strSQL = "SELECT epm_staff.staffid FROM epm_staff Inner Join org_groupmember ON epm_staff.staffid = org_groupmember.staffid Inner Join org_staffgroup ON org_groupmember.gid = org_staffgroup.gid GROUP BY epm_staff.staffid";
		$result = mysql_db_query($dbname,$strSQL);
		while($rs = mysql_fetch_assoc($result)){
			if($temp_staffid > "") $temp_staffid .= ",";
			$temp_staffid .= "$rs[staffid]";
		}
$strSQL1 = "SELECT * FROM epm_staff WHERE staffid NOT IN($temp_staffid) AND staffname NOT LIKE '%Administrator%'";
$result1 = mysql_db_query($dbname,$strSQL1);
$i=0;
while($rs1 = mysql_fetch_assoc($result1)){
		$bgcolor = ($i%2)?'#F1F1F1':'FFFFFF';$i++;
?>
  <tr bgcolor="<?=$bgcolor?>" onmouseover='mOvr(this,&quot;dbf2ae&quot;);' onmouseout='mOut(this,&quot;<?=$bgcolor?>&quot;);' >
    <td align="center" valign="middle" class="menu_java"><?=$i?></td>
    <td align="left" valign="middle" class="menu_java"><? echo "$rs1[prename]$rs1[staffname] $rs1[staffsurname]";?></td>
    <td align="center" valign="middle" class="menu_java"><a href="?action=manage&staffid=<?=$rs1[staffid]?>">นำเข้ากลุ่ม</a></td>
  </tr>
  <?
  }// end while(){
  ?>
</table>
<?
	} //end if($action == ""){
if($action == "manage"){
$strSQL_e = "SELECT * FROM epm_staff  WHERE  staffid='$staffid'";
$result_e = mysql_db_query($dbname,$strSQL_e);
$rs_e = mysql_fetch_assoc($result_e);
?>
<form id="form1" name="form1" method="post" action="">
  <table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
    <tr>
      <td bgcolor="#000000"><table width="100%" border="0" cellspacing="1" cellpadding="3">
        <tr>
          <td colspan="2" bgcolor="#CCCCCC"><strong>จัดการเพิ่มผู้ใช้ในกลุ่มงาน</strong></td>
          </tr>
        <tr>
          <td width="23%" bgcolor="#FFFFFF"><strong>ผู้ใช้งานระบบ</strong></td>
          <td width="77%" bgcolor="#FFFFFF"><? echo "$rs_e[prename]$rs_e[staffname] $rs_e[staffsurname]"; ?></td>
        </tr>
        <tr>
          <td bgcolor="#FFFFFF"><strong>เลือกกลุ่มงาน</strong></td>
          <td bgcolor="#FFFFFF">
		  <?
		  $strSQL_group = "SELECT * FROM org_staffgroup  WHERE  groupname NOT LIKE '%Guest%' AND groupname NOT LIKE '%Administrator%'";
		  $result_group = mysql_db_query($dbname,$strSQL_group);
		  while($rs_g = mysql_fetch_assoc($result_group)){
		 	 echo "<input name=\"group_id\" type=\"radio\" value=\"$rs_g[gid]\"> $rs_g[groupname]<br>";
		  }// end while(){
		  ?>		 </td>
        </tr>
        <tr>
          <td bgcolor="#FFFFFF">&nbsp;</td>
          <td bgcolor="#FFFFFF"><label>
		  <input type="hidden" name="staffid" value="<?=$staffid?>">
		 	<input type="hidden" name="Aaction" value="Update">
            <input type="submit" name="Submit" value="บันทึก">
          </label></td>
        </tr>
      </table></td>
    </tr>
  </table>
</form>
<?
	}// end 	if($action == "manage"){
?>
</body>
</html>
Anon7 - 2021