<tr>
<td height="25" align="center" valign="middle"><?php
echo $rows[0];
?>
</td>
<td align="center" valign="middle"><?php
echo $rows[1];
?>
</td>
<td align="center" valign="middle"><?php
echo $rows[2];
?>
</td>
<td align="center" valign="middle"><?php
echo read_field($conn, "tb_depart", "d_name", $rows[3]);
?>
</td>
<?php
if ($rows[4] == 1) {
?>
<td align="center" valign="middle"><a href="modify_purview_chk.php?id=<?php
echo $rows[0];
?>
&is_on=0">½ûÓÃ</a></td>
<td align="center" valign="middle">¿ªÆô</td>
<?php
} else {
?>
<td align="center" valign="middle">½ûÓÃ</td>
<td align="center" valign="middle"><a href="modify_purview_chk.php?id=<?php
<td height="33" background="../images/list.jpg" id="list"><?php echo read_field($conn,"tb_list","f_name",$_GET[u_id]); ?></td>
</tr>
</table>
<table width="765" border="0" cellpadding="0" cellspacing="0" bgcolor="#DEEBEF" class="big_td">
<tr>
<td width="80" height="25" align="center" valign="middle">日期</td>
<td width="420" align="center" valign="middle">内容提要</td>
<td width="50" align="center" valign="middle">类型</td>
</tr>
<?
while($p_rows = mysql_fetch_array($p_rst)){
?>
<tr>
<td height="30"><?php echo $p_rows[4]; ?></td>
<td><?php echo substr($p_rows[1],0,50).".........<a href='show_plan.php?id=".$p_rows[0]."' target='_blank'>查看全文</a>"; ?></td>
<td><?php echo read_field($conn,"tb_list","f_name",$_GET[u_id]); ?></td>
</tr>
<?php
}
?>
</table>
<table border="1" cellpadding="0" cellspacing="0" bgcolor="#DEEBEF">
<form name="form1" method="post" action="person_plan_chk.php">
<tr>
<td width="15%" height="25" align="right" valign="middle">日期</td>
<td>
<input type="text" id="p_date" name="p_date" readonly="readonly">
<input type="button" onClick="loadCalendar(form1.p_date)">
</td>
</tr>
?>
<tr>
<td height="25" align="center" valign="middle">
<?php
echo $rows[r_date];
?>
</td>
<td height="25" align="center" valign="middle">
<?php
echo $rows[r_time];
?>
</td>
<td height="25" align="center" valign="middle">
<?php
echo read_field($conn, "tb_users", "u_name", $rows[p_id]);
?>
</td>
<td align="center" valign="middle">
<?php
if ($rows[r_type] == 1) {
echo $rows[r_state] == 0 ? "正点上班" : "迟到";
} else {
echo "-";
}
?>
</td>
<td align="center" valign="middle">
<?php
if ($rows[r_type] == 0) {
<!--个人计划-->
<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#DEEBEF">
<tr>
<td width="75" height="25" align="center" valign="middle">日期</td>
<td align="center" valign="middle">内容提要</td>
<td align="center" valign="middle">类型</td>
</tr>
<?
$p_sql = "select * from tb_plan where p_id = ".$_SESSION[id]." order by id desc limit 0,5";
$p_rst = mysql_query($p_sql,$conn);
while($p_rows = mysql_fetch_array($p_rst)){
?>
<tr>
<td height="30" align="center" valign="middle"><?php echo $p_rows[4]; ?></td>
<td align="left" valign="middle"><?php echo substr($p_rows[1],0,20).".........<a href='grjh/show_plan.php?id=".$p_rows[0]."' target='_blank'>查看全文</a>"; ?></td>
<td width="50" align="center" valign="middle"><?php echo read_field($conn,"tb_list","f_name",$p_rows[p_type]); ?></td>
</tr>
<?php
}
?>
</table>
<!-- --------------------------- --> </td>
</tr>
</table> </td>
<td align="center" valign="top">
<table width="100%" height="195" border="0" cellpadding="0" cellspacing="0" class="big_td">
<tr>
<td height="20" align="center" valign="middle" scope="col">审核批示</td>
</tr>
<tr>
<td align="center" valign="top">
<?php
session_start();
include "../conn/conn.php";
include "../inc/chec.php";
include "../inc/func.php";
$l_sql = "select id,l_title,l_content,l_time,is_reply,r_back from tb_lyb order by id desc";
$l_rst = mysql_query($l_sql, $conn);
?>
<link href="../css/style.css" rel="stylesheet" />
<script src="../js/client_js.js"></script>
<table width="765" border="1" cellpadding="0" cellspacing="0" class="big_td">
<tr>
<td height="33" background="../images/list.jpg" id="list"><?php
echo read_field($conn, "tb_list", "f_name", $_GET[u_id]);
?>
</td>
</tr>
</table>
<table width="765" border="0" cellspacing="0" cellpadding="0" bgcolor="#DEEBEF" class="big_td">
<tr>
<td width="15%" height="30" align="left" valign="middle" scope="col">
2007-11-15
</td>
<td align="center" valign="middle" scope="col">注意事项</td>
<td width="15%" align="center" valign="middle" scope="col">
</td>
</tr>
<tr>
<td height="100" colspan="3" align="left" valign="middle" scope="col">
如果对公司有好的建议或意见，请在这里提出。此处发言，完全为匿名，请不要有任何顾虑~
<?php
session_start();
include "../inc/chec.php";
include "../conn/conn.php";
include "../inc/func.php";
//获取用户帐号
$fields = read_field($conn, "tb_users", "u_name", $_GET[id]);
/*删除用户*/
$sqlstr = "delete from tb_users where id = " . $_GET[id];
$result = mysql_query($sqlstr, $conn);
/*******************************/
/*删除group组中相对应的用户*/
$l_sqlstr = "select * from tb_group";
$l_result = mysql_query($l_sqlstr, $conn);
while ($l_rows = mysql_fetch_row($l_result)) {
/* 生成用户组列表 */
$l_list = split(",", $l_rows[2]);
$new_fields = "";
for ($num = 0; $num < count($l_list) - 1; $num++) {
if ($fields != $l_list[$num]) {
$new_fields .= $l_list[$num] . ",";
}
}
$n_sqlstr = "update tb_group set u_member = '" . $new_fields . "' where id = " . $l_rows[0];
mysql_query($n_sqlstr, $conn);
}
/******************************/
if ($result) {
echo "<script>alert('删除成功！');location='show_staf.php';</script>";
} else {
<tr>
<td width="75" height="25" align="center" valign="middle" scope="col">编号</td>
<td width="75" align="center" valign="middle" scope="col">姓名</td>
<td width="75" align="center" valign="middle" scope="col">性别</td>
<td width="75" align="center" valign="middle" scope="col">部门</td>
</tr>
<?php
$sqlstr = "select id,u_name,u_sex,u_depart from tb_users";
$result = mysql_query($sqlstr,$conn);
while($rows = mysql_fetch_row($result)){
?>
<tr>
<td align="center" valign="middle"><?php echo $rows[0]; ?></td>
<td align="center" valign="middle"><?php echo $rows[1]; ?></td>
<td align="center" valign="middle"><?php echo $rows[2]; ?></td>
<td align="center" valign="middle"> <?php echo read_field($conn,"tb_depart","d_name",$rows[3]); ?> </td>
</tr>
<?php
}
?>
</table>
</td></tr></table>
<?php
}
else if($_GET[u_id] == "25"){
$t_sql = "select * from tb_users where u_user = '******'";
$t_result = mysql_query($t_sql,$conn);
$t_rows = mysql_fetch_row($t_result);
?>
<table width="765" border="1" cellpadding="0" cellspacing="0" bgcolor="#DEEBEF" class="big_td">
<form name="form1" method="post" action="personnel_air_chk.php">
<?php
session_start();
include "conn/conn.php";
include "inc/func.php";
$sqlstr = "select id,u_name,u_depart,is_on from tb_users where u_user = '******' and u_pwd = '" . $_POST[pwd] . "'";
$result = mysql_query($sqlstr, $conn);
$record = mysql_fetch_row($result);
if ($record != "" and $record[3] == 1) {
if (getGroup($conn, $record[1], $_POST[u_group])) {
$_SESSION["id"] = $record[0];
$_SESSION["u_name"] = $_POST[username];
$_SESSION["u_depart"] = read_field($conn, "tb_depart", "d_name", $record[2]);
$_SESSION["u_group"] = read_field($conn, "tb_group", "u_group", $_POST[u_group]);
w_log($_POST[action]);
echo "<script>alert('��ӭ����');location='pub_main.php';</script>";
} else {
echo "<script>alert('�û������������');history.go(-1);</script>";
}
} else {
echo "<script>alert('�û������������');history.go(-1);</script>";
}
<?php
session_start();
include "../inc/chec.php";
include "../conn/conn.php";
include "../inc/func.php";
$fields = read_field($conn, "tb_group", "u_group", $_GET[id]);
/*删除用户组*/
$sqlstr = "delete from tb_group where id = " . $_GET[id];
$result = mysql_query($sqlstr, $conn);
/*****************************/
/*删除list功能列表中相对应的组*/
$l_sqlstr = "select * from tb_list";
$l_result = mysql_query($l_sqlstr, $conn);
while ($l_rows = mysql_fetch_row($l_result)) {
if ($l_rows[4] != "0") {
/* 生成用户组列表 */
$l_list = split(",", $l_rows[4]);
$new_fields = "";
for ($num = 0; $num < count($l_list) - 1; $num++) {
if ($fields != $l_list[$num]) {
$new_fields .= $l_list[$num] . ",";
}
}
$n_sqlstr = "update tb_list set o_group = '" . $new_fields . "' where id = " . $l_rows[0];
mysql_query($n_sqlstr, $conn);
} else {
}
}
/******************************/
if ($result) {
<?php
session_start();
include "../conn/conn.php";
include "../inc/chec.php";
include "../inc/func.php";
?>
<link href="../css/style.css" rel="stylesheet" />
<script src="../js/client_js.js"></script>
<table width="765" border="0" cellspacing="0" cellpadding="0" class="big_td">
<form action="t_back_chk.php" method="post" name="tback" id="tback">
<tr>
<td width="100" height="25" align="right" valign="middle" scope="col">回复主题：</td>
<td height="25" align="left" valign="middle" scope="col">
<input type="text" name="t_title" id="t_title" value="<?php
echo read_field($conn, "tb_lyb", "l_title", $_GET[id]);
?>
" readonly="readonly" >
</td>
</tr>
<tr>
<td align="right" valign="middle">回复内容</td>
<td align="left" valign="middle">
<textarea name="r_back" id="r_back" cols="75" rows="10"></textarea>
</td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="hidden" name="id" value="<?php
echo $_GET[id];
?>
