點擊head.php中的部門管理:
<div class="chromestyle" id="chromemenu">
<ul>
<li><a href="main.php">首頁</a></li>
<li><a href="#" rel="dropmenu1">人事管理</a></li>
<li><a href="#" rel="dropmenu2">考勤排班</a></li>
<li><a href="#" rel="dropmenu3">考勤處理</a></li>
<li><a href="#">考勤報表</a></li>
<li><a href="#">套帳管理</a></li>
<li><a href="#" rel="dropmenu7">系統管理</a></li>
<li><a href="inc/loginout.php">退出</a></li>
</ul>
</div>
<!--人事管理菜單項-->
<div id="dropmenu1" class="dropmenudiv">
<a href="staff/Basicinfo.php" target="mainframe">基本信息</a>
<a href="staff/fuzzyqueryinfo.php" target="mainframe">模糊搜尋</a>
<a href="#">離職統計報表</a>
<a href="#">人事統計</a>
<a href="#">調休計劃</a>
<a href="room/roominfo.php" target="mainframe">宿舍管理</a>
<a href="#">宿舍水電錄入</a>
</div><!--考勤排班菜單項 -->
<div id="dropmenu2" class="dropmenudiv" style="width: 150px;">
<a href="#">CNN</a>
<a href="#">MSNBC</a>
<a href="#">BBC News</a>
</div><!--考勤處理菜單項 -->
<div id="dropmenu3" class="dropmenudiv" style="width: 150px;">
<a href="#">Google</a>
<a href="#">Yahoo</a>
<a href="#">MSN</a>
</div><!--系統管理菜單項 -->
<div id="dropmenu7" class="dropmenudiv" style="width: 150px;">
<a href="user/Userinfo.php" target="mainframe">用戶管理</a>
<a href="department/departmentinfo.php" target="mainframe">部門管理</a>
<a href="#">MSN</a>
</div>
然后顯示departmentinfo.php這個頁面
<link href="../css/table.css" rel="stylesheet" type="text/css" />
<SCRIPT language=javascript src="../css/table.js"></SCRIPT>
<!--HTML部分-->
<TABLE id=secTable cellSpacing=0 cellPadding=0 width=900 border=0>
<TBODY>
<TR align=middle height=20>
<? if($action=="job" || $action=="joblist" || $action=="jobedit") {?>
<TD class=sec1 onclick=secBoard(0)>部門信息</TD>
<TD class=sec2 onclick=secBoard(1)>職務信息</TD>
<? } else {?>
<TD class=sec2 onclick=secBoard(0)>部門信息</TD>
<TD class=sec1 onclick=secBoard(1)>職務信息</TD>
<? }?>
<TD class=sec1 width="60%"></TD>
</TR>
</TBODY>
</TABLE><TABLE class=main_tab id=mainTable height="650px" cellSpacing=0 cellPadding=0 width=900 border=0>
<!--关于部門信息-->
<TBODY style="DISPLAY: block">
<TR>
<TD vAlign=top align=middle><br/>
<?
if($action==""){
include("departmentsearch.php");
}
if($action=="add"){
include("departmentinput.php");
}
if($action=="find"){
include("departmentinput.php");
include("departmentlist.php");
}
if($action=="list"){
include("departmentinput.php");
include("departmentlist.php");
}
if($action=="edit"){
include("departmentinput.php");
}
if($action=="job"){
include("jobnameinput.php");
}
if($action=="joblist"){
include("jobnameinput.php");
include("jobnamelist.php");
}
if($action=="jobedit"){
include("jobnameinput.php");
include("jobnamelist.php");
}
?>
</TD>
</TR>
</TBODY><!--关于職務信息-->
<TBODY style="DISPLAY:none">
<TR>
<TD vAlign=top align=middle><br>
<? include("jobnameinput.php");?>
</TD>
</TR>
</TBODY></TABLE>
也就是說我現在只要點部門信息就會顯示部門的相關操作,點擊職務信息就會顯示該部門下的職務信息和操作,其他頁面如下:
<div class="chromestyle" id="chromemenu">
<ul>
<li><a href="main.php">首頁</a></li>
<li><a href="#" rel="dropmenu1">人事管理</a></li>
<li><a href="#" rel="dropmenu2">考勤排班</a></li>
<li><a href="#" rel="dropmenu3">考勤處理</a></li>
<li><a href="#">考勤報表</a></li>
<li><a href="#">套帳管理</a></li>
<li><a href="#" rel="dropmenu7">系統管理</a></li>
<li><a href="inc/loginout.php">退出</a></li>
</ul>
</div>
<!--人事管理菜單項-->
<div id="dropmenu1" class="dropmenudiv">
<a href="staff/Basicinfo.php" target="mainframe">基本信息</a>
<a href="staff/fuzzyqueryinfo.php" target="mainframe">模糊搜尋</a>
<a href="#">離職統計報表</a>
<a href="#">人事統計</a>
<a href="#">調休計劃</a>
<a href="room/roominfo.php" target="mainframe">宿舍管理</a>
<a href="#">宿舍水電錄入</a>
</div><!--考勤排班菜單項 -->
<div id="dropmenu2" class="dropmenudiv" style="width: 150px;">
<a href="#">CNN</a>
<a href="#">MSNBC</a>
<a href="#">BBC News</a>
</div><!--考勤處理菜單項 -->
<div id="dropmenu3" class="dropmenudiv" style="width: 150px;">
<a href="#">Google</a>
<a href="#">Yahoo</a>
<a href="#">MSN</a>
</div><!--系統管理菜單項 -->
<div id="dropmenu7" class="dropmenudiv" style="width: 150px;">
<a href="user/Userinfo.php" target="mainframe">用戶管理</a>
<a href="department/departmentinfo.php" target="mainframe">部門管理</a>
<a href="#">MSN</a>
</div>
然后顯示departmentinfo.php這個頁面
<link href="../css/table.css" rel="stylesheet" type="text/css" />
<SCRIPT language=javascript src="../css/table.js"></SCRIPT>
<!--HTML部分-->
<TABLE id=secTable cellSpacing=0 cellPadding=0 width=900 border=0>
<TBODY>
<TR align=middle height=20>
<? if($action=="job" || $action=="joblist" || $action=="jobedit") {?>
<TD class=sec1 onclick=secBoard(0)>部門信息</TD>
<TD class=sec2 onclick=secBoard(1)>職務信息</TD>
<? } else {?>
<TD class=sec2 onclick=secBoard(0)>部門信息</TD>
<TD class=sec1 onclick=secBoard(1)>職務信息</TD>
<? }?>
<TD class=sec1 width="60%"></TD>
</TR>
</TBODY>
</TABLE><TABLE class=main_tab id=mainTable height="650px" cellSpacing=0 cellPadding=0 width=900 border=0>
<!--关于部門信息-->
<TBODY style="DISPLAY: block">
<TR>
<TD vAlign=top align=middle><br/>
<?
if($action==""){
include("departmentsearch.php");
}
if($action=="add"){
include("departmentinput.php");
}
if($action=="find"){
include("departmentinput.php");
include("departmentlist.php");
}
if($action=="list"){
include("departmentinput.php");
include("departmentlist.php");
}
if($action=="edit"){
include("departmentinput.php");
}
if($action=="job"){
include("jobnameinput.php");
}
if($action=="joblist"){
include("jobnameinput.php");
include("jobnamelist.php");
}
if($action=="jobedit"){
include("jobnameinput.php");
include("jobnamelist.php");
}
?>
</TD>
</TR>
</TBODY><!--关于職務信息-->
<TBODY style="DISPLAY:none">
<TR>
<TD vAlign=top align=middle><br>
<? include("jobnameinput.php");?>
</TD>
</TR>
</TBODY></TABLE>
也就是說我現在只要點部門信息就會顯示部門的相關操作,點擊職務信息就會顯示該部門下的職務信息和操作,其他頁面如下:
$method=$_GET['method'];
$id=$_GET['id'];
if($method=="edit"){
$sql="select * from _department where id=".$id;
//echo $sql;
$result_d=mysql_query($sql) or die ("執行SQL語句發生錯誤,錯誤信息是: ".mysql_error());
$rows=mysql_fetch_array($result_d);
$name=$rows['departmentname'];
}
?>
<form action="<? echo $PHP_SELF;?>" method="post">
<h3><? if($method=="edit") echo $edit; else echo $add;?>部門信息</h3>
<table width="65%" border="1" align="center" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td width="22%"><div align="right">部門名稱</div></td>
<td width="21%"><input type="text" name="departmentname" value="<? if($method=="edit") echo $name; ?>" /></td>
<? if($method=="edit") {?>
<td width="6%"><input type="submit" name="submit" value="修改" /></td>
<td width="6%"><input type="submit" name="submit" value="刪除" onClick="javascript:alert('確定刪除該部門嗎?');"/></td>
<? } else {?>
<td width="6%"><input type="submit" name="submit" value="增加" /></td>
<td width="39%"><input type="reset" name="reset" value="取消" /></td>
<? }?>
</tr>
</tbody>
</table>
<? if($method=="edit") {?>
該部門的所有職務:
<table width="65%" border="1" align="center" cellpadding="0" cellspacing="0">
<tbody>
<tr bgcolor="#CCCCCC">
<td><div align="center">部門名稱</div></td>
<td><div align="center">職務名稱</div></td>
</tr>
<?
$selec="select _jobnameinfo.did,_jobnameinfo.id,_jobnameinfo.jobname,_department.departmentname from _jobnameinfo,_department where _jobnameinfo.did=_department.id and _department.id=".$id;
$rs=mysql_query($selec) or die("執行SQL語句發現錯誤,錯誤信息是: ".mysql_error());
while($rs_job=mysql_fetch_array($rs)){
$_SESSION['departmentid']=$rs_job['did'];
//echo $_SESSION['departmentid'];
?>
<tr bgcolor="#FFFFFF" onMouseOver=this.style.backgroundColor='#99CC66' onMouseOut=this.style.backgroundColor='' onclick="location.href='departmentinfo.php?action=jobedit&id=<? echo $rs_job['id'];?>&method=edit'">
<td><? echo $rs_job['departmentname'];?></td>
<td><? echo $rs_job['jobname'];?></td>
</tr>
<? }?>
</tbody>
</table>
<? }?>
</form>
<?
$departmentname=$_POST['departmentname'];
$method=$_POST['submit'];
//echo $method;
if($method=="增加"){
$search="select * from _department where departmentname='".$departmentname."'";
$d_result=mysql_query($search) or die("執行SQL語句發生錯誤,錯誤是:".mysql_error());
$row_d=mysql_fetch_array($d_result);
if($departmentname!=$row_d['departmentname']){
//echo "可以添加部門信息";
$insert="insert into _department(departmentname,userlog,logtime,status)
values('".$departmentname."','".$_SESSION['userlog']."','".
date("y-m-d H:i:s")."',".$Cformadd.")";
//echo $insert;
$result=mysql_query($insert) or die("執行SQL語句發生錯誤,錯誤是:".mysql_error());
if($result){
// echo "添加部門信息成功";
$sql="select * from _department where departmentname='".$departmentname."'";
$info=mysql_query($sql) or die('執行SQL語句發現錯誤,錯誤信息是: '.mysql_error());
$info_department=mysql_fetch_array($info);
$_SESSION['departmentid']=$info_department['id'];
header("location:departmentinfo.php?action=job");
}
else{
// echo "添加部門信息失敗";
echo "<script>alert('添加部門失敗!'); history.back();</script>";
}
}
else{
//echo "該部門已經存在";
echo "<script>alert('部門已經存在!');history.back();</script>";
}
}
/*
* 該處是修改部門信息操作
* @Author 盧崇志
*/
else if($method=="修改"){
$search="select * from _department where departmentname='".$departmentname."'";
//echo $search;
$result=mysql_query($search) or die("執行SQL語句發生錯誤,錯誤信息是: ".mysql_error());
$row=mysql_fetch_array($result);
$name=$row['departmentname'];
if($departmentname==$name){
//echo "已經存在該部門";
echo "<script>alert('該部門已經存在!'); history.back();";
}
else{
echo "可以修改該部門信息";
$update="update _department set departmentname='".$departmentname
."',userlog='".$_SESSION['userlog']."',logtime='".date("y-m-d H:i:s")
."',status=".$Cformedit." where id=".$id;
//echo $update;
$result_e=mysql_query($update) or die("執行SQL語句發生錯誤,錯誤信息是: ".mysql_error());
if($result_e){
//echo "修改部門信息成功";
header("location:departmentinfo.php?action=list");
}
else{
//echo "修改部門信息失敗";
echo "<script>alert('修改部門信息失敗!'); history.back();</script>";
}
}
}
else if($method=="刪除"){
//echo "刪除部門信息";
$delete="delete from _department where id=".$id;
//echo $delete;
$result=mysql_query($delete) or die ("執行SQL語句發現錯誤,錯誤信息是: ".mysql_error());
if($result){
//echo "刪除成功";
header("location:departmentinfo.php?action=list");
}
else{
//echo "刪除失敗";
echo "<script>alert('刪除失敗!'); history.back();";
}
}
?>departmentlist.php<?
include("../inc/golbal.php");
include("../db/dbconnect.php");
$method=$_POST['submit'];
$search=$_POST['search'];
$condition=$_POST['condition'];
if($method=="搜索"){
?>
<!---顯示根據條件查詢得到的部門信息----->
<h3 align="left"> 查詢結果顯示:</h3>
<table width="80%" border="1" align="center" cellpadding="0" cellspacing="0">
<tbody>
<tr bgcolor="#999999">
<td><div align="center">部門名稱</div></td>
<td><div align="center">創建日期</div></td>
</tr>
<?
$sql="select * from _department where $search like '%".$condition."%' order by id desc ";
//echo $sql;
$result=mysql_query($sql) or die("執行SQL語句發生錯誤,錯誤是: ".mysql_error());
while($row=mysql_fetch_array($result)){
?>
<tr bgcolor="#FFFFFF" onMouseOver=this.style.backgroundColor='#99CC66' onMouseOut=this.style.backgroundColor='' onclick="location.href='departmentinfo.php?action=edit&id=<? echo $row['id'];?>&method=edit'">
<td><div align="center"><? echo $row['departmentname']; ?></div></td>
<td><div align="center"><? echo $row['logtime']; ?></div></td>
</tr>
<? } ?>
</tbody>
</table>
<?
}
else{
?><!---顯示全部部門信息----->
<h3 align="left">全部部門顯示:</h3>
<table width="80%" border="1" align="center" cellpadding="0" cellspacing="0">
<tbody>
<tr bgcolor="#999999">
<td><div align="center">部門名稱</div></td>
<td><div align="center">創建日期</div></td>
</tr>
<?
$sql="select * from _department order by id desc";
$result_a=mysql_query($sql);
while($row=mysql_fetch_array($result_a)){
?>
<tr bgcolor="#FFFFFF" onMouseOver=this.style.backgroundColor='#99CC66' onMouseOut=this.style.backgroundColor='' onclick="location.href='departmentinfo.php?action=edit&id=<? echo $row['id'];?>&method=edit'">
<td><div align="center"><? echo $row['departmentname'];?></div></td>
<td><div align="center"><? echo $row['logtime'];?></div></td>
</tr>
<? }?>
</tbody>
</table>
<?
}
?>
departmentsearch.php
<form name="department_search" action="departmentinfo.php?action=find" method="post" onSubmit="return checkForm()">
<table width="96%" border="1" align="center" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td width="31%"><div align="right">搜索部門:</div></td>
<td width="16%">
<div align="center">
<select name="search">
<option>----請選擇----</option>
<option value="departmentname">部門名稱</option>
<option value="jobname">職務名稱</option>
</select>
</div></td>
<td width="21%"><input type="text" name="condition" value="" /></td>
<td width="7%"><input type="submit" name="submit" value="搜索" /></td>
<td width="25%"><input type="button" name="add" value="增加" onClick="javascript:location.href='departmentinfo.php?action=add'" /></td>
</tr>
</tbody>
</table>
</form>
我把所有的東西都放里面了.....哥哥們給我看看...謝謝拉.....
{//第109行下,第108行上加入
}
你设置的是显示20条信息,我测试了一下,你用的DIV应该是限制了网页长度650px,无法完全的显示出20条信息那么长!
改成:
<a href=<? echo $filename.'?'.preg_replace("/\bpage(=\d*)?\b/i",'',$_SERVER['QUERY_STRING']).'&';?>page=1>首頁</a>
<a href=<? echo $filename.'?'.preg_replace("/\bpage(=\d*)?\b/i",'',$_SERVER['QUERY_STRING']).'&';?>page=<? echo ($currpage-1);?>>上一頁</a>
其他的地方也是一样,你也可以在最前面加一个
$filename.='?'.preg_replace("/\bpage(=\d*)?\b/i",'',$_SERVER['QUERY_STRING']).'&';
这样只需要改一个地方就行了