开发办公系统核心模块

• 1、项目介绍
• • 1.1网页图片
• 2. 数据库设计
• 3、创建项目
• • • 3.0.0 项目条目图片
    • 3.0.1 oa_dao持久层依赖
    • 3.0.1 oa_biz业务层依赖
    • 3.0.1 oa_web表现层依赖
  • 3.1包及全局配置
  • • 3.1.1 oa_dao全局配置文件spring-dao.xml
    • 3.1.2 oa_biz全局配置文件spring-biz.xml
    • 3.1.3.oa_web全局配置文件spring-web.xml及启动加载文件web.xml
  • 3.2工具类
  • • 3.2.1 编码过滤器
    • 3.2.1 常量类
• 4、功能实现
• • 4.1 部门实现
  • • 4.1.1 实体类
    • 4.1.2 dao接口及sql映射文件
    • 4.1.3 biz接口与实现类
    • 4.1.4 控制器
    • 4.1.5 页面
  • 4.2 员工管理
  • • 4.2.1 实体类
    • 4.2.2 dao接口及sql映射文件
    • 4.2.3 biz接口与实现类
    • 4.2.4 控制器
    • 4.2.5 页面
  • 4.3 登录及个人中心
  • • 4.3.1 biz接口与实现类
    • 4.3.2 控制器
    • 4.3.5 登录拦截器
    • 4.3.6 页面
  • 4.4 报销单处理
  • • 4.4.1实体类
    • 4.4.2Dao和映射文件
    • 4.4.3biz和实现类
    • 4.4.4填写报销单
    • 4.4.5个人报销单、待处理报销单
    • 4.4.6修改报销单
    • 4.4.7提交报销单
    • 4.4.8审核报销单
    • 4.4.9打款
    • 4.4.10 页面
  • 4.5 top.jsp
  • 4.6 bottom.jsp

1、项目介绍

前置条件：

• Mybatis、Spring、Spring MVC
• Mysql

主要技术：

• Spring IOC
• Mybatis+Spring整合
• 声明式事务
• Spring标签库
• Spring拦截器

开发环境：

• 操作系统：win10
• 数据库：Mysql-8.0
• web容器：Tomcat-8.5.69
• 开发工具 ：Intellij IDEA-2021.2.2

相关资料

• Spring -5.3.8
• MyBatis-3.4.4
• mybatis-spring:2.0.4
• mysql-connector-java-8.0.24
• 文档
  • 配置文件模板
  • 页面原型

项目结构

• 三层架构
  • 持久层–Mybatis
  • 表现层–Servlet+Jsp
  • Spring–管理对象、切面处理
• 基于MVC模式
  • 视图–Jsp
  • 模型–JavaBean
  • 控制器–Spring Controller

用例分析：

报销单处理流程：

1.1网页图片

2. 数据库设计

drop database if exists oa;

create database oa;
use oa;




create table claim_voucher
(
   id                   int not null auto_increment,
   cause                varchar(100),
   create_sn            char(5),
   create_time          datetime,
   next_deal_sn         char(5),
   total_amount         double,
   status               varchar(20),
   primary key (id)
);




create table claim_voucher_item
(
   id                   int not null auto_increment,
   claim_voucher_id     int,
   item                 varchar(20),
   amount               double,
   comment              varchar(100),
   primary key (id)
);




create table deal_record
(
   id                   int not null auto_increment,
   claim_voucher_id     int,
   deal_sn              char(5),
   deal_time            datetime,
   deal_way             varchar(20),
   deal_result          varchar(20),
   comment              varchar(100),
   primary key (id)
);




create table department
(
   sn                   char(5) not null,
   name                 varchar(20),
   address              varchar(100),
   primary key (sn)
);




create table employee
(
   sn                   char(5) not null,
   password             varchar(20),
   name                 varchar(20),
   department_sn        char(5),
   post                 varchar(20),
   primary key (sn)
);

alter table claim_voucher add constraint FK_Reference_2 foreign key (next_deal_sn)
      references employee (sn) on delete restrict on update restrict;

alter table claim_voucher add constraint FK_Reference_3 foreign key (create_sn)
      references employee (sn) on delete restrict on update restrict;

alter table claim_voucher_item add constraint FK_Reference_4 foreign key (claim_voucher_id)
      references claim_voucher (id) on delete restrict on update restrict;

alter table deal_record add constraint FK_Reference_5 foreign key (claim_voucher_id)
      references claim_voucher (id) on delete restrict on update restrict;

alter table deal_record add constraint FK_Reference_6 foreign key (deal_sn)
      references employee (sn) on delete restrict on update restrict;

alter table employee add constraint FK_Reference_1 foreign key (department_sn)
      references department (sn) on delete restrict on update restrict;

insert into department values('10001','总经理办公室','星星大厦E座1201');
insert into department values('10002','财务部','星星大厦E座1202');
insert into department values('10003','事业部','星星大厦E座1101');

insert into employee values('10001','000000','刘备','10001','总经理');
insert into employee values('10002','000000','孙尚香','10002','财务');
insert into employee values('10003','000000','关羽','10003','部门经理');
insert into employee values('10004','000000','周仓','10003','员工');

3、创建项目

• oa
  • 父moudle
  • 全局定义与组织
• oa_dao
  • 持久层
  • Mybatis依赖、Spring依赖、Mybatis-Spring整合
• oa_biz
  • 业务层
  • Aspectj依赖、AOP依赖
• oa_web
  • 表现层
  • Servlet依赖、Spring MVC依赖

3.0.0 项目条目图片

哈哈哈哈哈就大概大概的把

3.0.1 oa_dao持久层依赖

pom.xml(oa_dao)

    
        oa
        com.imooc
        1.0-SNAPSHOT
    
    4.0.0

    oa_dao
    
        
            mysql
            mysql-connector-java
            8.0.24
        
        
            org.mybatis
            mybatis
            3.4.4
        
        
            org.springframework
            spring-beans
            ${spring.version}
        
        
            org.springframework
            spring-context
            ${spring.version}
        
        
            org.springframework
            spring-jdbc
            ${spring.version}
        
        
            org.mybatis
            mybatis-spring
            2.0.4
        
    

    
        8
        8
    

3.0.1 oa_biz业务层依赖

pom.xml(oa_biz)

    
        oa
        com.imooc
        1.0-SNAPSHOT
    
    4.0.0

    oa_biz
    
        
            com.imooc
            oa_dao
            1.0-SNAPSHOT
        

        
        
            org.springframework
            spring-tx
            ${spring.version}
        
        
            org.springframework
            spring-aop
            ${spring.version}
        

        
            org.aspectj
            aspectjweaver
            1.9.0
        
    

    
        8
        8
    

3.0.1 oa_web表现层依赖

pom.xml(oa_web)

  4.0.0

  com.imooc
  oa_web
  1.0-SNAPSHOT
  war

  oa_web Maven Webapp
  
  http://www.example.com

  
    UTF-8
    1.7
    1.7
  

  
    
      junit
      junit
      4.11
      test
    
    
      com.imooc
      oa_biz
      1.0-SNAPSHOT
    
    
      javax.servlet
      javax.servlet-api
      4.0.0
    
    
      jstl
      jstl
      1.2
    
    
      org.springframework
      spring-web
      5.3.8
    
    
      org.springframework
      spring-webmvc
      5.3.8
    
  

  
    oa_web
    
      
        
          maven-clean-plugin
          3.1.0
        
        
        
          maven-resources-plugin
          3.0.2
        
        
          maven-compiler-plugin
          3.8.0
        
        
          maven-surefire-plugin
          2.22.1
        
        
          maven-war-plugin
          3.2.2
        
        
          maven-install-plugin
          2.5.2
        
        
          maven-deploy-plugin
          2.8.2
        
      
    
  

3.1包及全局配置

• oa_dao
  • dao、entity、global
  • 配置数据源、Session工厂、映射器接口
• oa_biz
  • biz
  • 配置事务（持久化的操作太细，表现层的请求太粗，所有把业务层的方法封装成事务最合适）
• oa_web
  • controller、dto、global
  • 静态资源处理、视图转换器
  • Spring MVC加载

dto层：
通常是用来做数据传输的，当实体类无法满足数据传输的要求时，通常会扩展一个类来进行数据的传输。这里页面可以传入报销单和报销单条目，于是创建一个类既包含报销单，也包含报销单条目

3.1.1 oa_dao全局配置文件spring-dao.xml

• dao、entity、global
• 配置数据源、Session工厂、映射器接口
  spring-dao.xml

3.1.2 oa_biz全局配置文件spring-biz.xml

• biz
• 事务

Spring-biz.xml

3.1.3.oa_web全局配置文件spring-web.xml及启动加载文件web.xml

• controller、dto、global
• 静态资源处理、视图转换器
• Spring MVC加载(复制web.xml模板到WEB-INF)
  spring-web.xml

    
    
	
    

    
    

    
    
        
        
        
        
    

	
    
        
             map){
        map.put("list",departmentBiz.getAll());//把所有部门信息存储到list里
        return "department_list";//转发到department_list.jsp页面去;在spring-web.xml里配置过前缀后缀
    }
    //增
    @RequestMapping("/to_add")
    public String toAdd(Map map){
        map.put("department",new Department());
        return "department_add";//转发到department_add.jsp页面去;在spring-web.xml里配置过前缀后缀
    }

    @RequestMapping("/add")
    public String add(Department department){
        departmentBiz.add(department);
        return "redirect:list";//不能直接转到jsp页面，因为信息还没更新，得转到list的路径下
    }

    //删
    @RequestMapping(value = "/remove",params = "sn")
    public String remove(String sn){
        departmentBiz.remove(sn);
        return "redirect:list";//不能直接转到jsp页面，因为信息还没更新，得转到list的路径下
    }

    //改
    @RequestMapping(value = "/to_update",params = "sn")
    public String toUpdate(String sn,Map map){
        map.put("department",departmentBiz.get(sn));
        return "department_update";//转发到department_add.jsp页面去;在spring-web.xml里配置过前缀后缀
    }
    @RequestMapping("/update")
    public String update(Department department){
        departmentBiz.edit(department);
        return "redirect:list";//不能直接转到jsp页面，因为信息还没更新，得转到list的路径下
    }
}

4.2.5 页面

department_list.jsp

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>




    

        

            
 部门列表 
            

        
        

            

                

                    

                        

                            

                                
                                    
                                
                                
                                    
                                
                                
                                    
                                
                            
                        
                        

                            

                                
                                    
                                
                                
                                    
                                
                            
                        
                    
                
                

                    
                            

                        

                        

                            
Select
                            
部门编号
                            
部门名称
                            
地址
                            
操作
                        
                        
                        

                        

                                

                                    
                                        
                                        
                                    
                                
                                
${dept.sn}
                                
${dept.name}
                                
${dept.address}
                                

                                    编辑
                                    删除
                                
                            
                        
                        
                    
                
            
        
    

department_add.jsp

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="form" uri="http://www.springframework.org/tags/form" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>




    

        

            
 添加部门 
            

        
        

            

                <%--不使用form表单，这里使用spring mvc里的form表单--%>
                <%--
--%>
                    
                        <%--modelAttribute="department"这里的department这个名字要和控制器里的toAdd那里设置的map里的名称一样--%>
                    

                        

                             基本信息 
                        
                        

                            

                                
                                    
                                    <%--相当于原来的--%>
                                    
                                        
                                    
                                
                            
                            

                                
                                    
                                    
                                        
                                    
                                
                            
                        
                        

                            
                                
                                
                                    
                                
                            
                        
                        

                             保存 
                             返回 
                        
                    
                
            
        
    

department_update.jsp

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="form" uri="http://www.springframework.org/tags/form" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>




    

        

            
 编辑部门 
            

        
        

            

                <%--不使用form表单，这里使用spring mvc里的form表单--%>
                <%----%>
                    
                        <%--modelAttribute="department"这里的department这个名字要和控制器里的toAdd那里设置的map里的名称一样--%>
                    

                        

                             基本信息 
                        
                        

                            

                                
                                    
                                    <%--相当于原来的--%>
                                    
                                        
                                    
                                
                            
                            

                                
                                    
                                    
                                        
                                    
                                
                            
                        
                        

                            
                                
                                
                                    
                                
                            
                        
                        

                             保存 
                             返回 
                        
                    
                
            
        
    

4.3 登录及个人中心

• 登录、退出、个人信息、修改密码
• 关注点：Session操作、登录拦截器（以前是使用登录过滤器的方式，但是这里spring提供了一个登录拦截器的工具）

实体类：Employee
dao接口及sql映射文件也是在前面已经写过的了

4.3.1 biz接口与实现类

package com.imooc.oa.biz;

import com.imooc.oa.entity.Employee;

public interface GlobalBiz {
    Employee login(String sn,String password);
    void changePassword(Employee employee);
}

package com.imooc.oa.biz.impl;

import com.imooc.oa.biz.GlobalBiz;
import com.imooc.oa.dao.EmployeeDao;
import com.imooc.oa.entity.Employee;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;

@Service("globalBiz")
public class GlobalBizImpl implements GlobalBiz {
    @Resource(name = "employeeDao")
    private EmployeeDao employeeDao;

    public Employee login(String sn, String password) {
        Employee employee = employeeDao.select(sn);
        if(employee!=null&&employee.getPassword().equals(password)){
            return  employee;
        }
        return null;
    }

    public void changePassword(Employee employee) {
        employeeDao.update(employee);
    }
}

4.3.2 控制器

package com.imooc.oa.controller;

import com.imooc.oa.biz.GlobalBiz;
import com.imooc.oa.entity.Employee;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;

import javax.servlet.http.HttpSession;
@Controller("globalController")
public class GlobalController {
    @Autowired
    private GlobalBiz globalBiz;

    @RequestMapping("/to_login")
    public String toLogin(){
        return "login";
    }

    @RequestMapping("/login")
    public String login(HttpSession session, @RequestParam String sn, @RequestParam String password){
        Employee employee = globalBiz.login(sn,password);
        if (employee == null) {
            return "redirect:to_login";
        }
        session.setAttribute("employee",employee);
        return "redirect:self";
    }
    @RequestMapping("/self")
    public String self(){
        return  "self";//个人信息的jsp页面
    }

    @RequestMapping("/quit")
    public String quit(HttpSession session){
        session.setAttribute("employee",null);
        return "redirect:to_login";
    }

    @RequestMapping("/to_change_password")
    public String toChangePassword(){
        return "change_password";
    }

    @RequestMapping("/change_password")
    public String changePassword(HttpSession session, @RequestParam String old, @RequestParam String new1 ,@RequestParam String new2){
        Employee employee = (Employee)session.getAttribute("employee");
        if(employee.getPassword().equals(old)){
            if(new1.equals(new2)){
                employee.setPassword(new1);
                globalBiz.changePassword(employee);
                return "redirect:self";
            }
        }
        return "redirect:to_change_password";
    }

}

4.3.5 登录拦截器

这个是Spring提供的，在oa_web包里的global里新建一个类，写完之后要到sping.xml里配置才能生效的。

package com.imooc.oa.global;

import org.springframework.web.servlet.HandlerInterceptor;
import org.springframework.web.servlet.ModelAndView;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

//登录拦截器，如果你没有登录就拦截你，所有方法写在登录前;写完之后要到sping.xml里配置才能生效的
public class LoginInterceptor implements HandlerInterceptor {
    @Override
    public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws Exception {
        //有些路径是可以不用登录不拦截的
        String url=request.getRequestURI();
        if(url.toLowerCase().indexOf("login")>=0){
            return true;//去登录的url不拦截，直接放行,toLowerCase()是把字母全部转换成小写
        }
        HttpSession session=request.getSession();
        if(session.getAttribute("employee")!=null){
            return true;//session不为空，证明已经登录过了
        }
        response.sendRedirect("/to_login");
        return false;
    }

    @Override
    public void postHandle(HttpServletRequest request, HttpServletResponse response, Object handler, ModelAndView modelAndView) throws Exception {

    }

    @Override
    public void afterCompletion(HttpServletRequest request, HttpServletResponse response, Object handler, Exception ex) throws Exception {

    }
}

配置的信息在前面已经展示过了

4.3.6 页面

login.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>



    
    
    
    
    
    
    
    
    



    

        

            

                

                    
 报销OA
                    
欢迎使用报销自动化管理系统
                
                

                    
                        

                            

                                工号
                                
                                    
                                    
                                        
                                    
                                
                            
                            

                                密码
                                
                                    
                                    
                                        
                                    
                                
                            
                        
                        

                            登陆
                            
                                
                                
                                记住我
                            
                        
                    
                
            
        
    

change_password.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>




    

        

            
 修改密码 
            

        
        

            

                

                    

                        

                             基本信息 
                        
                        

                            

                                
                                    
                                    
                                        
                                    
                                
                            
                        
                        

                            

                                
                                    
                                    
                                        
                                    
                                
                            
                            

                                
                                    
                                    
                                        
                                    
                                
                            
                        
                        

                             修改 
                             返回 
                        
                    
                
            
        
    

4.4 报销单处理

填写报销单、个人报销单、待处理报销单
修改报销单、提交报销单、审核报销单
打款

4.4.1实体类

package com.imooc.oa.entity;

import org.springframework.format.annotation.DateTimeFormat;

import java.util.Date;

//报销单
public class ClaimVoucher {
    private Integer id;
    private String cause;
    private String createSn;//创建人：关联employee对象
    @DateTimeFormat(pattern = "yyyy-MM-dd hh:mm")
    private Date createTime;//创建时间

    private String nextDealSn;//待处理人：关联employee对象
    private Double totalAmount;//总金额
    private String status;//状态

    private Employee creator;
    private Employee dealer;
}

package com.imooc.oa.entity;
//报销单条目
public class ClaimVoucherItem {
    private Integer id;
    private Integer claimVoucherId;
    private String item;//费用类型
    private Double amount;//金额
    private String comment;//描述
}

package com.imooc.oa.entity;

import org.springframework.format.annotation.DateTimeFormat;

import java.util.Date;

//处理记录
public class DealRecord {
    private Integer id;
    private Integer claimVoucherId;
    private String dealSn;//处理人：关联employee
    @DateTimeFormat(pattern = "yyyy-MM-dd hh:mm")
    private Date dealTime;//处理时间
    private String dealWay;//处理类型
    private String dealResult;//处理结果
    private String comment;//备注

    private Employee dealer;
}

4.4.2Dao和映射文件

package com.imooc.oa.dao;

import com.imooc.oa.entity.ClaimVoucher;
import com.imooc.oa.entity.Employee;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;
//报销单接口
@Repository("claimVoucherDao")
public interface ClaimVoucherDao {

    void insert(ClaimVoucher claimVoucher);
    void update(ClaimVoucher claimVoucher);
    void delete(int id);
    ClaimVoucher select(int id);
    List selectByCreateSn(String csn);//查询这个人创建的报销单
    List selectByNextDealSn(String ndsn);//查询这个人需要处理的报销单
}

    
        
        
        
        
        
        
        
        
            
            
        
        
            
            
        
    

    
        insert into claim_voucher(cause,create_sn,create_time,next_deal_sn,total_amount,status)
        values(#{cause},#{createSn},#{createTime},#{nextDealSn},#{totalAmount},#{status})
    
    
        update claim_voucher set cause=#{cause},next_deal_sn=#{nextDealSn},total_amount=#{totalAmount},status=#{status} where id=#{id}
    
    
        delete from claim_voucher where id=#{id}
    
    
        select cv.*,ce.name cname,ce.post cpost,d.name dname,d.post dpost
        from claim_voucher cv
                 left join employee ce on ce.sn=cv.create_sn
                 left join employee d on d.sn = cv.next_deal_sn
        where cv.id=#{id}
    
    
        select cv.*,ce.name cname,ce.post cpost,d.name dname,d.post dpost
        from claim_voucher cv
                 left join employee ce on ce.sn=cv.create_sn
                 left join employee d on d.sn = cv.next_deal_sn
        where cv.create_sn=#{csn} order by cv.create_time desc
    
    
        select cv.*,ce.name cname,ce.post cpost,d.name dname,d.post dpost
        from claim_voucher cv
                 left join employee ce on ce.sn=cv.create_sn
                 left join employee d on d.sn = cv.next_deal_sn
        where cv.next_deal_sn=#{ndsn} order by cv.create_time desc
    

 
package com.imooc.oa.dao;

import com.imooc.oa.entity.ClaimVoucherItem;
import com.imooc.oa.entity.Department;
import org.springframework.stereotype.Repository;

//报销单条目
import java.util.List;
@Repository("claimVoucherItemDao")
public interface ClaimVoucherItemDao {
    void insert(ClaimVoucherItem claimVoucherItem);
    void update(ClaimVoucherItem claimVoucherItem);
    void delete(int id);
    List selectByClaimVoucher(int cvid);
}

 



    
        
        
        
        
        
    

    
        insert into claim_voucher_item(claim_voucher_id,item,amount,comment)
        values(#{claimVoucherId},#{item},#{amount},#{comment})
    
    
        update  claim_voucher_item set claim_voucher_id=#{claimVoucherId},item=#{item},amount=#{amount},comment=#{comment}
        where id=#{id}
    
    
        delete from claim_voucher_item where id=#{id}
    
    
        select * from claim_voucher_item where claim_voucher_id=#{cvid} order by id;
    

package com.imooc.oa.dao;

import com.imooc.oa.entity.DealRecord;
import com.imooc.oa.entity.Department;
import org.springframework.stereotype.Repository;

import java.util.List;
@Repository("dealRecordDao")
public interface DealRecordDao {
    void insert(DealRecord dealRecord);
    List selectByClaimVoucher(int cvid);
}

    
        
        
        
        
        
        
        
        
            
            
        
    

    
        insert into deal_record(claim_voucher_id,deal_sn,deal_time,deal_way,deal_result,comment)
        values(#{claimVoucherId},#{dealSn},#{dealTime},#{dealWay},#{dealResult},#{comment})
    
    
        select d.*,e.name ename,e.post epost
        from deal_record d
        left join employee e on d.deal_sn = e.sn
        where d.claim_voucher_id=#{cvid} order by d.deal_time;
    

 
4.4.3biz和实现类 
package com.imooc.oa.biz;

import com.imooc.oa.entity.ClaimVoucher;
import com.imooc.oa.entity.ClaimVoucherItem;
import com.imooc.oa.entity.DealRecord;

import java.util.List;

public interface ClaimVoucherBiz {
    void save(ClaimVoucher claimVoucher, List items);
    ClaimVoucher get(int id);
    List getItems(int cvid);
    List getRecords(int cvid);

    List getForSelf(String sn);//获取个人的把报销单
    List getForDeal(String sn);//获取需要处理的报销单

    void update(ClaimVoucher claimVoucher, List items);

    void submit(int id);//把编号对应的报销单进行提交

    void deal(DealRecord dealRecord);
}

 
package com.imooc.oa.biz.impl;

import com.imooc.oa.biz.ClaimVoucherBiz;
import com.imooc.oa.dao.ClaimVoucherDao;
import com.imooc.oa.dao.ClaimVoucherItemDao;
import com.imooc.oa.dao.DealRecordDao;
import com.imooc.oa.dao.EmployeeDao;
import com.imooc.oa.entity.ClaimVoucher;
import com.imooc.oa.entity.ClaimVoucherItem;
import com.imooc.oa.entity.DealRecord;
import com.imooc.oa.entity.Employee;
import com.imooc.oa.global.Constant;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.util.Date;
import java.util.List;

@Service("claimVoucherBiz")
public class ClaimVoucherBizImpl implements ClaimVoucherBiz {

    @Resource(name = "claimVoucherDao")
    private ClaimVoucherDao claimVoucherDao;
    @Resource(name = "claimVoucherItemDao")
    private ClaimVoucherItemDao claimVoucherItemDao;

    @Resource(name = "dealRecordDao")
    private DealRecordDao dealRecordDao;
    @Resource(name="employeeDao")
    private EmployeeDao employeeDao;

    @Override
    public List getForSelf(String sn) {
        return claimVoucherDao.selectByCreateSn(sn);
    }

    @Override
    public List getForDeal(String sn) {
        return claimVoucherDao.selectByNextDealSn(sn);
    }

    @Override
    public void submit(int id) {
        
        
        ClaimVoucher claimVoucher=claimVoucherDao.select(id);
        Employee employee=employeeDao.select(claimVoucher.getCreateSn());
        claimVoucher.setStatus(Constant.CLAIMVOUCHER_SUBMIT);
        claimVoucher.setNextDealSn(employeeDao.selectByDepartmentAndPost(employee.getDepartmentSn(),Constant.POST_FM).get(0).getSn());
        claimVoucherDao.update(claimVoucher);

        DealRecord dealRecord=new DealRecord();
        dealRecord.setDealWay(Constant.DEAL_SUBMIT);
        dealRecord.setDealSn(employee.getSn());
        dealRecord.setClaimVoucherId(id);
        dealRecord.setDealResult(Constant.CLAIMVOUCHER_SUBMIT);
        dealRecord.setDealTime(new Date());
        dealRecord.setComment("无");
        dealRecordDao.insert(dealRecord);

    }

    @Override
    public void update(ClaimVoucher claimVoucher, List items) {
        claimVoucher.setNextDealSn(claimVoucher.getCreateSn());
        claimVoucher.setStatus(Constant.CLAIMVOUCHER_CREATED);
        //更新报销单信息
        claimVoucherDao.update(claimVoucher);
        //更新条目信息：将旧条目从数据库中取出来进行对比
        List olds=claimVoucherItemDao.selectByClaimVoucher(claimVoucher.getId());
        for(ClaimVoucherItem old:olds){
            boolean isHave=false;
            for(ClaimVoucherItem item:items){
                if(item.getId()==old.getId()){
                    isHave=true;
                    break;
                }
            }
            if(!isHave){
                //数据库里有表单没有的条目，说明修改的时候把这个条目删除了
                claimVoucherItemDao.delete(old.getId());
            }
            for(ClaimVoucherItem item:items){
                item.setClaimVoucherId(claimVoucher.getId());//为item设置报销单id，否则修改数据时新增item会发生空指针异常
                if(item.getId()!=null&&item.getId()>0){//说明数据库里面有这个条目了，要更新它的内容
                    claimVoucherItemDao.update(item);
                }else {//否则是编辑的时候加入了一个新的条目
                    claimVoucherItemDao.insert(item);
                }
            }
        }
    }


    @Override
    public void deal(DealRecord dealRecord) {
        

        ClaimVoucher claimVoucher=claimVoucherDao.select(dealRecord.getClaimVoucherId());
        Employee employee=employeeDao.select(dealRecord.getDealSn());
        //经过运行发现前端给后端传参时多了个逗号,用split()分割
        String dealWay1=dealRecord.getDealWay().split(",")[1];

        if(dealWay1.equals(Constant.DEAL_PASS)){
            //如果处理方式是通过，则还需要判断是否需要复审
            if(claimVoucher.getTotalAmount()<=Constant.LIMIT_CHECK || employee.getPost().equals(Constant.POST_GM)){
                //小于5000和总经理不需要复审
                claimVoucher.setStatus(Constant.CLAIMVOUCHER_APPROVED);
                claimVoucher.setNextDealSn(employeeDao.selectByDepartmentAndPost(null,Constant.POST_CASHIER).get(0).getSn());

                dealRecord.setDealResult(Constant.CLAIMVOUCHER_APPROVED);


            }else{
                //需要复审
                claimVoucher.setStatus(Constant.CLAIMVOUCHER_RECHECK);
                claimVoucher.setNextDealSn(employeeDao.selectByDepartmentAndPost(null,Constant.POST_GM).get(0).getSn());

                dealRecord.setDealResult(Constant.CLAIMVOUCHER_RECHECK);
            }
        }else if(dealWay1.equals(Constant.DEAL_BACK)){
            //处理方式是打回
            claimVoucher.setStatus(Constant.CLAIMVOUCHER_BACK);
            claimVoucher.setNextDealSn(claimVoucher.getCreateSn());

            dealRecord.setDealResult(Constant.CLAIMVOUCHER_BACK);
        }else if(dealWay1.equals(Constant.DEAL_REJECT)){
            //处理方式是拒绝
            claimVoucher.setStatus(Constant.CLAIMVOUCHER_TERMINATED);
            claimVoucher.setNextDealSn(null);

            dealRecord.setDealResult(Constant.CLAIMVOUCHER_TERMINATED);
        }else if(dealWay1.equals(Constant.DEAL_PAID)){
            //处理方式是打款
            claimVoucher.setStatus(Constant.CLAIMVOUCHER_PAID);
            claimVoucher.setNextDealSn(null);

            dealRecord.setDealResult(Constant.CLAIMVOUCHER_PAID);
        }
        dealRecord.setDealTime(new Date());
        dealRecord.setDealWay(dealWay1);
        claimVoucherDao.update(claimVoucher);
        dealRecordDao.insert(dealRecord);

    }

    @Override
    public void save(ClaimVoucher claimVoucher, List items) {
        claimVoucher.setCreateTime(new Date());
        claimVoucher.setNextDealSn(claimVoucher.getCreateSn());
        claimVoucher.setStatus(Constant.CLAIMVOUCHER_CREATED);
        claimVoucherDao.insert(claimVoucher);
        for(ClaimVoucherItem item:items){
            item.setClaimVoucherId(claimVoucher.getId());//把报销单编号填进去
            claimVoucherItemDao.insert(item);
        }
    }

    @Override
    public ClaimVoucher get(int id) {
        return claimVoucherDao.select(id);
    }

    @Override
    public List getItems(int cvid) {
        return claimVoucherItemDao.selectByClaimVoucher(cvid);
    }

    @Override
    public List getRecords(int cvid) {
        return dealRecordDao.selectByClaimVoucher(cvid);
    }
}

 
4.4.4填写报销单 
流程 
  
保存报销单及条目信息
记录处理流程
 
关注点 
  
dto-报销单信息
不定项表单处理
 控制器里的内容
 
 
package com.imooc.oa.controller;

import com.imooc.oa.biz.ClaimVoucherBiz;
import com.imooc.oa.dto.ClaimVoucherInfo;
import com.imooc.oa.entity.DealRecord;
import com.imooc.oa.entity.Employee;
import com.imooc.oa.global.Constant;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;

import javax.servlet.http.HttpSession;
import java.util.Map;
@Controller("claimVoucherController")
@RequestMapping("/claim_voucher")
public class ClaimVoucherController {
    @Autowired
    private ClaimVoucherBiz claimVoucherBiz;

    @RequestMapping("/to_add")
    public String toAdd(Map map){
        map.put("items", Constant.getItems());//常量类里的费用类型存入
        map.put("info",new ClaimVoucherInfo());
        return "claim_voucher_add";
    }

    @RequestMapping("/add")
    public String add(HttpSession session,ClaimVoucherInfo info){
        Employee employee=(Employee)session.getAttribute("employee");
        info.getClaimVoucher().setCreateSn(employee.getSn());
        claimVoucherBiz.save(info.getClaimVoucher(), info.getItems());
        return "redirect:deal";
    }
 	@RequestMapping("/detail")
    public String detail(int id,Map map){
        map.put("claimVoucher",claimVoucherBiz.get(id));
        map.put("items",claimVoucherBiz.getItems(id));
        map.put("records",claimVoucherBiz.getRecords(id));
        return "claim_voucher_detail";
    }
}

 
4.4.5个人报销单、待处理报销单 
关注点 
  
报销单关联信息显示
处理功能按钮显示
 控制器里的内容
 
 
@RequestMapping("/self")
    public String self(HttpSession session,Map map){
        Employee employee=(Employee)session.getAttribute("employee");
        map.put("list",claimVoucherBiz.getForSelf(employee.getSn()));
        return "claim_voucher_self";
    }

    @RequestMapping("/deal")
    public String deal(HttpSession session,Map map){
        Employee employee=(Employee)session.getAttribute("employee");
        map.put("list",claimVoucherBiz.getForDeal(employee.getSn()));
        return "claim_voucher_deal";
    }
 
4.4.6修改报销单 
流程 
  
修改基本信息
记录处理流程
 控制器里的内容
 
 
@RequestMapping("/to_update")
    public String toUpdate(int id,Map map){
        map.put("items",Constant.getItems());//处理类型
        ClaimVoucherInfo info=new ClaimVoucherInfo();
        info.setClaimVoucher(claimVoucherBiz.get(id));
        info.setItems(claimVoucherBiz.getItems(id));
        map.put("info",info);
        return "claim_voucher_update";
    }

    @RequestMapping("/update")
    public String update(HttpSession session,ClaimVoucherInfo info){
        Employee employee=(Employee)session.getAttribute("employee");
        info.getClaimVoucher().setCreateSn(employee.getSn());
        claimVoucherBiz.update(info.getClaimVoucher(), info.getItems());
        return "redirect:deal";
    }
 
4.4.7提交报销单 
流程 
  
修改状态
记录处理流程
 
关注点 
  
部门经理的获取
 控制器里的内容
 
 
@RequestMapping("/submit")
    public String submit (int id){
        claimVoucherBiz.submit(id);
        return "redirect:deal";
    }
 
4.4.8审核报销单 
流程 
  
修改状态
记录处理流程
 
关注点 
  
不同操作的结果
是否需要复审
 控制器里的内容
 
 
@RequestMapping("/to_check")
    public String toCheck(int id,Map map){
        
        map.put("claimVoucher",claimVoucherBiz.get(id));
        map.put("items",claimVoucherBiz.getItems(id));
        map.put("records",claimVoucherBiz.getRecords(id));
        DealRecord dealRecord=new DealRecord();
        dealRecord.setClaimVoucherId(id);
        map.put("record",dealRecord);
        return "claim_voucher_check";
    }

    @RequestMapping("/check")
    public String check(HttpSession session,DealRecord dealRecord){
        Employee employee=(Employee)session.getAttribute("employee");
        dealRecord.setDealSn(employee.getSn());
        claimVoucherBiz.deal(dealRecord);
        return "redirect:deal";
    }
 
4.4.9打款 
流程 
  
修改状态
记录处理流程
 打款这里同check是一个方法。
 
 
4.4.10 页面 
claim_voucher_add.jsp
 
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="form" uri="http://www.springframework.org/tags/form" %>



    

        

            
 填写报销单 
            

        
        

            

                
                    

                        

                             基本信息 
                        
                        

                            
                                
                                
                                    
                                
                            
                        
                        

                             费用明细 
                        
                        

                            

                                

                                    
                                        
                                    
                                
                                

                                    
                                        
                                        
                                            
                                        
                                    
                                
                                

                                    
                                        
                                        
                                            
                                        
                                    
                                
                                

                                     X 
                                
                            
                        
                        

                            

                                
                                    
                                    
                                        
                                    
                                
                            
                            

                                

                                     + 
                                
                            
                        
                        

                             保存 
                             返回 
                        
                    
                
            
        
    



 
claim_voucher_deal.jsp
 
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="spring" uri="http://www.springframework.org/tags" %>
<%@page import="com.imooc.oa.global.Constant" %>




    

        

            
 待处理报销单 
            

        
        

            

                

                    

                        

                            

                                
                                    
                                
                                
                                    
                                
                                
                                    
                                
                            
                        
                        

                            

                                
                                    
                                
                                
                                    
                                
                            
                        
                    
                
                

                    
                            

                        

                        

                            
Select
                            
事由
                            
状态
                            
创建人
                            
金额
                            
创建时间
                            
操作
                        
                        
                        


                        

                                

                                    
                                        
                                        
                                    
                                
                                
${cv.cause}
                                

                                     ${cv.status}
                                
                                
${cv.creator.name}
                                
${cv.totalAmount}
                                

                                

                                    
                                        修改
                                        提交
                                    
                                    
                                        审核
                                    
                                    
                                        打款
                                    
                                    详细信息
                                
                            

                        

                        
                    
                
            
        
    




 
claim_voucher_detail.jsp
 
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="spring" uri="http://www.springframework.org/tags" %>



    

        

            
 报销单详情 
            

        
        

            

                

                    

                         基本信息 
                    
                    

                        
事由
                        
${claimVoucher.cause}
                    
                    

                        
创建人
                        
${claimVoucher.creator.name}
                        
创建时间
                        

                    
                    

                        
待处理人
                        
${claimVoucher.dealer.name}
                        
状态
                        
${claimVoucher.status}
                    
                    

                         费用明细 
                    
                    

                        
                            
${item.item}
                            
${item.amount}
                            
${item.comment}
                        

                    
                    

                        
总金额
                        
${claimVoucher.totalAmount}
                    
                    

                         处理流程 
                    
                    


                        
                            
${record.dealer.name}
                            

                            
${record.dealWay}
                            
${record.dealResult}
                            
备注：${record.comment}
                        

                    
                    

                         返回 
                    
                
            
        
    




 
claim_voucher_self.jsp
 
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="spring" uri="http://www.springframework.org/tags" %>




    

        

            
 个人报销单 
            

        
        

            

                

                    

                        

                            

                                
                                    
                                
                                
                                    
                                
                                
                                    
                                
                            
                        
                        

                            

                                
                                    
                                
                                
                                    
                                
                            
                        
                    
                
                

                    
                            

                        

                        

                            
Select
                            
事由
                            
状态
                            
创建人
                            
金额
                            
创建时间
                            
操作
                        
                        
                        


                        

                                

                                    
                                        
                                        
                                    
                                
                                
${cv.cause}
                                

                                     ${cv.status}
                                
                                
${cv.creator.name}
                                
${cv.totalAmount}
                                

                                
详细信息
                            

                        

                        
                    
                
            
        
    




 
claim_voucher_check.jsp
 
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="spring" uri="http://www.springframework.org/tags" %>
<%@ taglib prefix="form" uri="http://www.springframework.org/tags/form" %>
<%@ page import="com.imooc.oa.global.Constant" %>



    

        

            
 报销单详情 
            

        
        

            

                

                    

                         基本信息 
                    
                    

                        
事由
                        
${claimVoucher.cause}
                    
                    

                        
创建人
                        
${claimVoucher.creator.name}
                        
创建时间
                        

                    
                    

                        
待处理人
                        
${claimVoucher.dealer.name}
                        
状态
                        
${claimVoucher.status}
                    
                    

                         费用明细 
                    
                    

                        
                            
${item.item}
                            
${item.amount}
                            
${item.comment}
                        

                    
                    

                        
总金额
                        
${claimVoucher.totalAmount}
                    
                    

                         处理流程 
                    
                    


                        
                            
${record.dealer.name}
                            

                            
${record.dealWay}
                            
${record.dealResult}
                            
备注：${record.comment}
                        
                    

                    
                        
                        
                        

                            

                                
                                    
                                    
                                        
                                    
                                
                            
                            


                                
                                    ${Constant.DEAL_PASS}
                                    ${Constant.DEAL_BACK}
                                    ${Constant.DEAL_REJECT}
                                
                                
                                    ${Constant.DEAL_PAID}
                                
                                 返回 
                            
                        
                    
                
            
        
    




 
claim_voucher_update.jsp
 
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="form" uri="http://www.springframework.org/tags/form" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>



    

        

            
 修改报销单 
            

        
        

            

                
                    
                    

                        

                             基本信息 
                        
                        

                            
                                
                                
                                    
                                
                            
                        
                        

                             费用明细 
                        
                        

                            
                                

                                    

                                        
                                            
                                            
                                            
                                        
                                    
                                    

                                        
                                            
                                            
                                                
                                            
                                        
                                    
                                    

                                        
                                            
                                            
                                                
                                            
                                        
                                    
                                    

                                         X 
                                    
                                
                            
                        
                        

                            

                                
                                    
                                    
                                        
                                    
                                
                            
                            

                                

                                     + 
                                
                            
                        
                        

                             保存 
                             返回 
                        
                    
                
            
        
    



 
4.5 top.jsp 
<%@ page contentType="text/html;charset=UTF-8" language="java" %>






    
    

    

    
    
    




    

        

            
                爱慕课OA
            
            
        
        

            

                
                    


                     ${sessionScope.employee.name} 
                    
                
                

                    

                        
                             个人信息
                            
                        
                    
                    

                        
                             设置密码 
                    
                    

                        
                             退出