java基于SSM框架的ERP财务报销管理系统源码+数据库.zip

package com.cmj.oa.controller; import com.cmj.oa.biz.ClaimVoucherBiz; import com.cmj.oa.biz.EmployeeBiz; import com.cmj.oa.biz.impl.ClaimVoucherBizImpl; import com.cmj.oa.biz.impl.EmployeeBizImpl; import com.cmj.oa.dto.ClaimVoucherInfo; import com.cmj.oa.entity.ClaimVoucher; import com.cmj.oa.entity.ClaimVoucherItem; import com.cmj.oa.entity.DealRecord; import com.cmj.oa.entity.Employee; import com.cmj.oa.global.Contant; import com.cmj.oa.util.DateUtil; import com.cmj.oa.util.FileUtil; import com.cmj.oa.util.ResponseUtil; import net.sf.json.JSONObject; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.poifs.filesystem.POIFSFileSystem; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.*; import org.springframework.web.multipart.MultipartFile; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import java.io.File; import java.io.FileInputStream; import java.io.IOException; import java.text.DateFormat; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Date; import java.util.List; import java.util.Map; @Controller("claimVoucherController") @RequestMapping("/claim_voucher") public class ClaimVoucherController { @Autowired private ClaimVoucherBiz claimVoucherBiz; @Autowired private EmployeeBiz employeeBiz; @RequestMapping("/to_add") public String toAdd(Map<String,Object> map){ map.put("items", Contant.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:detail?id="+info.getClaimVoucher().getId(); } @RequestMapping("/detail") public String detail(int id,Map<String,Object> map){ map.put("claimVoucher",claimVoucherBiz.get(id)); map.put("items",claimVoucherBiz.getItems(id)); map.put("records",claimVoucherBiz.getRecords(id)); return "claim_voucher_detail"; } @RequestMapping("/self") public String self(HttpSession session,Map<String,Object> 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<String,Object> map){ Employee employee = (Employee)session.getAttribute("employee"); map.put("list",claimVoucherBiz.getForDeal(employee.getSn())); return "claim_voucher_deal"; } @RequestMapping("/to_update") public String toUpdate(int id,Map<String,Object> map){ map.put("items",Contant.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"; } @RequestMapping("/submit") public String submit(int id){ claimVoucherBiz.submit(id); return "redirect:deal"; } @RequestMapping("/to_check") public String toCheck(int id,Map<String,Object> 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"; } @RequestMapping("/fuzzyQuery") public String fuzzyQuery(HttpSession session,Map<String,Object> map,@RequestParam String status,@RequestParam String total_amount,@RequestParam String create_time) throws ParseException, IOException { Employee employee = (Employee)session.getAttribute("employee"); String createSn = employee.getSn(); Double totalAmount = null; if (!total_amount.isEmpty() && total_amount != null){ totalAmount = Double.valueOf(total_amount); } map.put("list",claimVoucherBiz.fuzzyQuery(createSn,status,totalAmount,create_time)); return "claim_voucher_self"; } @RequestMapping("/fuzzyQueryForDeal") public String fuzzyQueryForDeal(HttpSession session,Map<String,Object> map,@RequestParam String createSn,@RequestParam String status,@RequestParam String total_amount,@RequestParam String create_time){ Employee employee = (Employee)session.getAttribute("employee"); String nextDealSn = employee.getSn(); Double totalAmount = null; if (!total_amount.isEmpty() && total_amount != null){ totalAmount = Double.valueOf(total_amount); } map.put("list",claimVoucherBiz.fuzzyQueryForDeal(createSn,nextDealSn,status,totalAmount,create_time)); return "claim_voucher_deal"; } @RequestMapping("/delete") @ResponseBody public String deleteClaimVoucher(@RequestParam("ids") String ids){ if (ids.length()==0 || ids.isEmpty()){ return null; } String[] str = ids.split(","); List<Integer> id = new ArrayList<>(); for (int i = 0 ; i < str.length ; i++){ id.add(Integer.parseInt(str[i])); } for (Integer i : id){ claimVoucherBiz.deleteById(i); } return null; } @RequestMapping(value = "/export") public String exportExcel(HttpServletResponse response, HttpServletRequest request,String ids) throws Exception { if (ids.length()==0 || ids.isEmpty()){ return null; } String[] str = ids.split(","); List<Integer> id = new ArrayList<>(); for (int i = 0 ; i < str.length ; i++){ id.add(Integer.parseInt(str[i])); } List<ClaimVoucher> claimVoucherList = new ArrayList<>(); for (Integer i : id) { claimVoucherList.add(claimVoucherBiz.get(i)); } String webPath=request.getServletContext().getRealPath("/"); Workbook wb = fillExcelDataWithTemplate(claimVoucherList, webPath+"/static/excel/claim.xls"); ResponseUtil.export(response,wb,"报销单.xls"); return null; } public Workbook fillExcelDataWithTemplate(List<ClaimVoucher> list , String templateFileUrl) { Workbook wb = null ; try { POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(templateFileUrl)); wb = new HSSFWorkbook(fs); // 取得 模板的 第一个sheet 页 Sheet sheet = wb.getSheetAt(0); // 拿到sheet页有多少列 int cellNums = sheet.getRow(0).getLastCellNum(); // 从第3行 开始�