<?
CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
?>
<script language="JavaScript">

//******************************************
function checkregis() {
if(document.myform.rdo1.checked == false && document.myform.rdo2.checked == false  )   
{        
alert('กรุณาเลือกประเภท ');       
return false;    
}    


//********************************************
}
</script>
 <table cellspacing="0" cellpadding="0" width="100%" height=420 border="0">
        <tbody>
                                <tr>
                                  <td align="left"Valign="top"><br />
                                       <b><img src="images/icon/plus.gif" border="0" align="absmiddle" /> <a href="?name=admin&amp;file=main">หน้าหลักผู้ดูแลระบบ</a><b><img src="images/icon/plus.gif" border="0" align="absmiddle" /> <a href="?name=admin&file=user_la">จัดการบุคลากรทปฏิบัติหน้าที่ผู้อำนวยการกลุ่ม</a> 
                                      <br />
                                      <!-- แสดงผลรายการ -->
  <?
if($_GET[op] == "minepass_edit" AND $_GET[action] == "edit"){
	//////////////////////////////////////////// กรณีแก้ไขข้อมูลส่วนตัว
	if(CheckLevelUser($_SESSION['user_user'],$_GET[op])){
		$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
//		$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE username='".$_SESSION['user_user']."' ");
		$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE id='".$_GET[id]."' ");
		$arr[user] = $db->fetch($res[user]);
		$db->closedb ();

				//ทำการแก้ไขข้อมูลลงดาต้าเบส
				$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
				$db->update_db(TB_user,array(
					"odgroup"=>"$_POST[ODGROUP]",
					"update_date"=>"".TIMESTAMP.""						
					)," id='$_GET[id]' ");				
				$db->closedb ();
				$ProcessOutput .= "<BR><BR>";
				$ProcessOutput .= "<CENTER><A HREF=\"".$URLre."\"><IMG SRC=\"images/icon/login-welcome.gif\" BORDER=\"0\"></A><BR><BR>";
				$ProcessOutput .= "<FONT COLOR=\"#336600\"><B>ได้ทำการแก้ไขข้อมูลเรียบร้อยแล้ว</B></FONT><BR><BR>";
				$ProcessOutput .= "<meta http-equiv=\"refresh\" content=\"1 ;url=?name=admin&file=user_cp_odgroup1\">";
				$ProcessOutput .= "</CENTER>";
				$ProcessOutput .= "<BR><BR>";
		
	}else{
		//กรณีไม่ผ่าน
		$ProcessOutput = $PermissionFalse ;
	}
	echo $ProcessOutput ;
}else if($_GET[op] == ""){
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$limit = 30 ;
$SUMPAGE = $db->num_rows(TB_user,"id","status='1' ");
$page=$_GET[page];
if (empty($page)){
	$page=1;
}
$rt = $SUMPAGE%$limit ;
$totalpage = ($rt!=0) ? floor($SUMPAGE/$limit)+1 : floor($SUMPAGE/$limit); 
$goto = ($page-1)*$limit ;
?>

                                        <table width="100%" align="center" cellspacing="2" cellpadding="1" >
                                          <tr bgcolor="#990000" height="25">
                                           <td><div align="center"><font color="#FFFFFF"><b>ที่</b></font></div></td>
                                            <td><div align="center"><font color="#FFFFFF"><b>ชื่อ - นามสกุล</b></font></div></td>
                                            <td><div align="center"><font color="#FFFFFF"><b>กลุ่ม</b></font></div></td>
                                            <td><div align="center"><font color="#FFFFFF"><b>สถานะ</b></font></div></td>     
											<td><div align="center"><font color="#FFFFFF"><b>จัดการ</b></font></div></td> 
											<td><div align="center"><font color="#FFFFFF"><b>ดำเนินการ</b></font></div></td> 
                                          </tr>
 <?
//	CheckUser($_SESSION['user_user']);
		$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
		$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE username='".$_SESSION['user_user']."' ");
		$arr[user] = $db->fetch($res[user]);
		$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE workgroup='".$arr[user][workgroup]."' and status='1' ORDER BY working DESC LIMIT $goto, $limit ");
		$count=0;
		$i=1;
		while($arr[user] = $db->fetch($res[user])){
		$res[work] = $db->select_query("SELECT * FROM ".TB_WORK_CAT." WHERE  id='".$arr[user][work]."'  ");
		$arr[work] = $db->fetch($res[work]);
		$res[working] = $db->select_query("SELECT * FROM ".TB_WORKGROUP_CAT." WHERE  id='".$arr[user][workgroup]."'  ");
		$arr[working] = $db->fetch($res[working]);
?>
                                          <tr>
											<td width="60" align="center"><? echo"".$i?></td>  
                                            <td width="200" ><? echo $arr[user][category_name];?></td>
											<td width="200" ><? echo $arr[working][category_name];?></td>		


<?
		if($arr[user][odgroup]==4){ 	  
?>
											<td align="center" width="200" > <font color=blue>ปฏิบัติหน้าที่</font></td>
<?}?>

<?
			if($arr[user][odgroup]==1){ 	  
?>
											 <td align="center" width="150" ><font color=red>-</font></td>
<?}?>
											<form NAME="myform" method="post" action="?name=admin&file=user_cp_odgroup1&op=minepass_edit&action=edit&id=<? echo $arr[user][id];?>" enctype="multipart/form-data" onSubmit="return checkregis()">
                                            <td align="center" width="280" >
												
                                                <?
													$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
													$res[category] = $db->select_query("SELECT * FROM ".TB_WORK_CAT." WHERE id='1' or id='4'  ORDER BY id DESC ");
													while ($arr[category] = $db->fetch($res[category]))
													{	?>
													<input type="radio" name="ODGROUP"  value="<?=$arr[category][id];?>"><? echo $arr[category][category_name];?><font color=red>(ร)</font>
													<?
													}
													?>
											
											</td>
                                            <td align="center" width="70"><input type="submit" value=" บันทึก " />
											</form>
											</td>
                                          </tr>
<?
$i++;
 } 
?>
                                        </table>
                                                                
                                    <?
	SplitPage($page,$totalpage,"?name=admin&file=user_cp_odgroup1");
	echo $ShowSumPages ;
	echo "<BR>";
	echo $ShowPages ;
	echo "<BR><BR>";
}

?>
                                      <br />
                                    <br />
                                  </td>
                                </tr>
                              </table>
                            <br /></td>
                          </tr>
                      </table></td>
                    </tr>
                  </tbody>
                </table>
            </div></td>
          </tr>
        </tbody>
      </table>
	 
</div>