公文流转系统
1.项目需求
河北金力集团是我省机械加工的龙头企业，主要从事矿山机械制造及各种机械零部件加工。企业有3个厂区，主厂区位于省高新技术开发区，3个分厂分别在保定、邢台和唐山。为增加企业的核心竞争力和加强管理的科学程度，近期企业将在全集团实行ERP管理，建立网页版公文流转系统。具体部门：主厂区、一分厂、二分厂、三分厂、销售部门、财务部门、办公室；领导：三位副厂长(分别管理生产、销售、财务)、一位厂长。
流转流程：
数据库:
(1)根据用户的角色及相应权限设计用户表 Doc.java
用于储存公文信息
字段：
Id:公文编号
Title:公文标题
Owner:发送公文的机构
Time:公文发送时间
Receiver:接收公文的机构
Status:公文流转状态
Result:公文审核结果
Place:公文储存位置
Tipplace:副厂长审核意见位置
Ftipplace:厂长审签意见位置
Deletestatus:公文的删除状态
Callback:该公文回执信息的接收状态
(2) 用户父权限ID建立用户权限表Permission.java
用于储存用户权限信息
字段：
Id:角色权限编号
Permission:角色权限代码
(3) 公文流转状态建立公文数据表Users.java
用于储存用户信息
字段：
Id:用户编号
Username:用户名
Password:密码
permissionId:角色权限编号
Status:标记用户是否被暂停使用
界面
（1）登录界面：
index.jsp
</style>
</head>
<body>
<div class="header"><h2>河北金力集团公文流转系统</h2></div>
<div class="container">
<div class="login">
<h2 class="logtip">登录</h2>
<form action="login_do" method="post">
<div class="form-group">
<label for="username">用户名</label>
<input type="text" class="form-control" id="username" name="username">
</div>
<div class="form-group">
<label for="password">密码</label>
<input type="password" class="form-control" id="password" name="password">
</div>
<div class="btnbag">
<input type="button" class="btn btn-primary logbtn" onclick="login()" value="登录">
<input type="button" class="btn btn-primary mangbtn" onclick="entermang()" value="进入管理">
</div>
</form>
</div>
</div>
<div class="footer"></div>
</body>
<script>
function login()
{
var username=$("#username").val();
var password=$("#password").val();
if(username==""||password=="")
alert("请将信息填写完整！");
else
{
$.post(
"login_do",
{username:username,
password:password},
function(data){
if(data=="yes")
{
alert("成功登陆！");
window.location="mainpage.jsp";
}
else
alert("用户名或密码错误！或用户已被暂停使用！");
},
"text"
);
}
}
function entermang()
{
var username=$("#username").val();
var password=$("#password").val();
if(username==""||password=="")
alert("请将信息填写完整！");
else
{
$.post(
"login_do",
{username:username,
password:password},
function(data){
if(data=="yes")
{
alert("成功登陆！");
window.location="backmainpage.jsp";
}
else
alert("用户名或密码错误！或用户已被暂停使用！");
},
"text"
);
}
}
</script>
</html>
(2)主界面
backmainpage.jsp
</style> <script> function onload() { <% Cookie[] cookies=request.getCookies(); String value=""; if(cookies!=null){ System.out.println("cookie的长度为:"+cookies.length); for(int i=0;i<cookies.length;i++) { if(cookies[i].getName().equals("username")) { value=cookies[i].getValue(); break; } } } %> $("#informationshow").text("当前登录账户："+"<%=value%>"); } function exitlog(event) { var msg = "您确定要注销吗？"; if (confirm(msg)==true){ event.href="http://localhost:8080/official-document/index.jsp"; } else{ alert("操作取消！"); } } </script> </head> <body onload="onload()"> <div class="header"> <h2>河北金力集团后台管理系统</h2> <div class="loginfoshow" id="userinfor"> <p id="informationshow"></p> <a href="" onclick="exitlog(this)">[注销]</a> </div> </div> <div class="contain"> <div class="list-group"> <%if(value.equals("admit")){ %> <a id="1" href="getAllUser" class="list-group-item list-group-item-aciton" target="operation">用户管理</a> <%} %> <a id="2" href="" class="list-group-item list-group-item-aciton" onclick="updatepwd()">修改密码</a> </div> <div class="operation"> <iframe name="operation" src="" width="100%" height="100%" style="background-color: gray;"></iframe> </div> </div> <div class="footer"></div> </body> <script> function updatepwd() { var username="<%=value%>"; var password=prompt("请输入修改后的密码："); if(password!=""&&password!=null) { $.post( "updateSelf", { username:username, password:password }, function(data) { if(data=="yes") alert("修改成功！"); else alert("修改失败！"); }, "text" ); } } </script> </html>
mainpage.jsp
</style>
<script>
function onload()
{
<%
Cookie[] cookies=request.getCookies();
String value="";
ArrayList<Permission> list=new ArrayList<>();
if(cookies!=null){
System.out.println("cookie的长度为:"+cookies.length);
for(int i=0;i<cookies.length;i++)
{
if(cookies[i].getName().equals("username"))
{
value=cookies[i].getValue();
}
if(cookies[i].getName().equals("pid"))
{
Permission permission=new Permission();
permission.setId(Integer.parseInt(cookies[i].getValue()));
list=DBUtil.getPermission(permission);
}
}
}
%>
$("#informationshow").text("当前登录账户：<%=value %>");
}
function exitlog(event)
{
var msg = "您确定要注销吗？";
if (confirm(msg)==true){
event.href="http://localhost:8080/official-document/index.jsp";
}
else{
alert("操作取消！");
}
}
</script>
</head>
<body onload="onload()">
<div class="header">
<h2>河北金力集团公文流转系统</h2>
<div class="loginfoshow" id="userinfor">
<p id="informationshow"></p>
<a href="" onclick="exitlog(this)">[注销]</a>
</div>
</div>
<div class="contain">
<div class="list-group">
<%for(Permission s:list)
{
if(s.getPermission()==1){%>
<a id="1" href="writedoc.jsp?user=<%=value %>" class="list-group-item list-group-item-aciton" target="operation">公文拟制</a>
<%}else if(s.getPermission()==2){ %>
<a id="2" href="getReceivedorNot?user=<%=value %>&type=received" class="list-group-item list-group-item-aciton" target="operation">签收公文</a>
<%}else if(s.getPermission()==3){ %>
<a id="3" href="showAll" class="list-group-item list-group-item-aciton" target="operation">浏览公文</a>
<%}else if(s.getPermission()==5){ %>
<a id="5" href="getDoc?type=receive" class="list-group-item list-group-item-aciton" target="operation">公文流转</a>
<%}else if(s.getPermission()==6){ %>
<a id="6" href="queryDoc?type=all" class="list-group-item list-group-item-aciton" target="operation">公文查询</a>
<%}else if(s.getPermission()==7){ %>
<a id="7" href="checkDoc?type=notchecked" class="list-group-item list-group-item-aciton" target="operation">审核公文</a>
<%}else if(s.getPermission()==8){ %>
<a id="8" href="fcheckDoc?type=notchecked" class="list-group-item list-group-item-aciton" target="operation">审签公文</a>
<%}} %>
</div>
<div class="operation">
<iframe name="operation" src="" width="100%" height="100%" style="background-color: gray;"></iframe>
</div>
</div>
<div class="footer"></div>
</body>
</html>
（3）公文流转
writecheck.jsp
</style>
</head>
<body>
<%Doc doc=(Doc)request.getAttribute("doc"); %>
<div>公文来源：<%=doc.getOwner() %> 发送日期：<%=doc.getTime() %></div>
<div class="contain">
<div class="title"><h2>河北金立集团文件</h2></div>
<%if(doc.getOwner().equals("salespart")){ %>
<div class="tip">厂[售] [2019] *号</div>
<%}else if(doc.getOwner().equals("financepart")){ %>
<div class="tip">厂[财] [2019] *号</div>
<%}else{ %>
<div class="tip">厂[产] [2019] *号</div>
<%}
FileInputStream fileInputStream;
String text="";
try {
fileInputStream = new FileInputStream(doc.getPlace());
BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(fileInputStream));
String line = null;
try {
while ((line = bufferedReader.readLine()) != null) {
text+=line;
}
} catch (IOException e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
}
fileInputStream.close();
} catch (FileNotFoundException e1) {
// TODO 自动生成的 catch 块
e1.printStackTrace();
} catch (IOException e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
}
if(text.equals("")!=true){
%>
<div class="underline">-------------------------------------------------</div>
<div class="doctitle"><%=doc.getTitle() %></div>
<div class="content"><%=text %></div>
<%}else{ %>
<div class="underline">-------------------------------------------------</div>
<div class="doctitle"><%=doc.getTitle() %></div>
<div class="content">公文内容读取失败！</div>
<%}
String time=doc.getTime();
String[] date=time.split("-");
%>
<div class="time"><%=date[0] %>年<%=date[1] %>月<%=date[2] %>日</div>
</div>
<div class="writesuggest">
<div><h4>请在下方输入审核意见和修改意见：</h4></div>
<textarea rows="20" cols="20" class="suggestion" id="suggestion"></textarea>
<div class="radio">
<label>是否同意该公文：</label>
<label class="radio-inline"><input type="radio" name="result" value="1">同意</label>
<label class="radio-inline"><input type="radio" name="result" value="0">不同意</label>
</div>
<input type="button" value="确认修改" class="btn" onclick="writesug()">
</div>
</body>
<script>
function writesug()
{
var val=$('input:radio[name="result"]:checked').val();
var id=<%=doc.getId()%>;
var tip=$("#suggestion").val();
if(val==null)
{
alert("请勾选是否同意该公文选项！");
}
else{
$.post(
"checked_change",
{
id:id,
result:val,
tip:tip
},
function(data)
{
if(data=="yes")
{
alert("操作成功！");
window.location="checkDoc?type=notchecked";
}
else
alert("操作失败！");
},
"text"
);
}
}
</script>
</html>
writedoc.jsp
</style>
</head>
<body>
<h4>请输入公文标题：</h4>
<div><input type="text" class="form-control" id="title"></div>
<h4>请在下方书写正文：</h4>
<div>
<textarea id="doc" rows="20" cols="40"></textarea>
</div>
<div class="btnbag">
<input type="button" class="btn" value="提交" onclick="submit()">
</div>
</body>
<script type="text/javascript">
function GetQueryString(name) {
var reg = new RegExp("(^|&)" + name + "=([^&]*)(&|$)", "i");
var r = window.location.search.substr(1).match(reg); //获取url中"?"符后的字符串并正则匹配
var context = "";
if (r != null)
context = r[2];
reg = null;
r = null;
return context == null || context == "" || context == "undefined" ? "" : context;
}
function submit()
{
var text=$("#doc").val();
var user=GetQueryString("user");
var title=$("#title").val();
if(text==""||title=="")
{
alert("包含空内容！请填写完整！");
}
else
{
$.post(
"writedoc_do",
{text:text,
user:user,
title:title},
function(data){
if(data=="yes"){
alert("发送成功");
$("#title").val("");
$("#doc").val("");
}
else{
alert("发送失败");
}
},
"text"
);
}
}
</script>
</html>
writefcheck.jsp
</style>
</head>
<body>
<%Doc doc=(Doc)request.getAttribute("doc"); %>
<div>公文来源：<%=doc.getOwner() %> 发送日期：<%=doc.getTime() %></div>
<div class="contain">
<div class="title"><h2>河北金立集团文件</h2></div>
<%if(doc.getOwner().equals("salespart")){ %>
<div class="tip">厂[售] [2019] *号</div>
<%}else if(doc.getOwner().equals("financepart")){ %>
<div class="tip">厂[财] [2019] *号</div>
<%}else{ %>
<div class="tip">厂[产] [2019] *号</div>
<%}
FileInputStream fileInputStream;
String text="";
try {
fileInputStream = new FileInputStream(doc.getPlace());
BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(fileInputStream));
String line = null;
try {
while ((line = bufferedReader.readLine()) != null) {
text+=line;
}
} catch (IOException e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
}
fileInputStream.close();
} catch (FileNotFoundException e1) {
// TODO 自动生成的 catch 块
e1.printStackTrace();
} catch (IOException e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
}
if(text.equals("")!=true){
%>
<div class="underline">-------------------------------------------------</div>
<div class="doctitle"><%=doc.getTitle() %></div>
<div class="content"><%=text %></div>
<%}else{ %>
<div class="underline">-------------------------------------------------</div>
<div class="doctitle"><%=doc.getTitle() %></div>
<div class="content">公文内容读取失败！</div>
<%}
String time=doc.getTime();
String[] date=time.split("-");
%>
<div class="time"><%=date[0] %>年<%=date[1] %>月<%=date[2] %>日</div>
</div>
<div class="writesuggest">
<div><h4>请在下方输入审签意见和修改意见：</h4></div>
<textarea rows="20" cols="20" class="suggestion" id="suggestion"></textarea>
<div class="radio">
<label>是否同意该公文：</label>
<label class="radio-inline"><input type="radio" name="result" value="1">同意</label>
<label class="radio-inline"><input type="radio" name="result" value="0">不同意</label>
</div>
<input type="button" value="确认修改" class="btn" onclick="writesug()">
</div>
</body>
<script>
function writesug()
{
var val=$('input:radio[name="result"]:checked').val();
var id=<%=doc.getId()%>;
var tip=$("#suggestion").val();
if(val==null)
{
alert("请勾选是否同意该公文选项！");
}
else{
$.post(
"fchecked_change",
{
id:id,
result:val,
tip:tip
},
function(data)
{
if(data=="yes")
{
alert("操作成功！");
window.location="fcheckDoc?type=notchecked";
}
else
alert("操作失败！");
},
"text"
);
}
}
</script>
</html>
(4)公文的签收
doc层
package com.official.bean;
public class Doc {
private int id;
private String tipplace;
private String ftipplace;
private int deletestatus;
private int callback;
public int getCallback() {
return callback;
}
public void setCallback(int callback) {
this.callback = callback;
}
public int getDeletestatus() {
return deletestatus;
}
public void setDeletestatus(int deletestatus) {
this.deletestatus = deletestatus;
}
public String getFtipplace() {
return ftipplace;
}
public void setFtipplace(String ftipplace) {
this.ftipplace = ftipplace;
}
public String getTipplace() {
return tipplace;
}
public void setTipplace(String tipplace) {
this.tipplace = tipplace;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
private String title;
private String owner;
private String time;
private String receiver;
private int status;
private int result;
private String place;
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}
public String getOwner() {
return owner;
}
public void setOwner(String owner) {
this.owner = owner;
}
public String getTime() {
return time;
}
public void setTime(String time) {
this.time = time;
}
public String getReceiver() {
return receiver;
}
public void setReceiver(String receiver) {
this.receiver = receiver;
}
public int getStatus() {
return status;
}
public void setStatus(int status) {
this.status = status;
}
public int getResult() {
return result;
}
public void setResult(int result) {
this.result = result;
}
public String getPlace() {
return place;
}
public void setPlace(String place) {
this.place = place;
}
}
