报表导出打印
diff --git a/build.gradle b/build.gradle
index d8703b7..761f8b5 100644
--- a/build.gradle
+++ b/build.gradle
@@ -76,6 +76,7 @@
implementation 'org.jetbrains.kotlin:kotlin-stdlib-jdk8'
implementation 'net.javacrumbs.shedlock:shedlock-spring:2.5.0'
implementation 'net.javacrumbs.shedlock:shedlock-provider-redis-spring:2.5.0'
+ implementation 'org.projectlombok:lombok:1.18.10'
implementation 'org.postgresql:postgresql:42.2.5'
implementation 'com.jcabi:jcabi-manifests:1.1'
diff --git a/src/main/java/com/supwisdom/dlpay/restaurant/bean/LaborfeeSearchBean.java b/src/main/java/com/supwisdom/dlpay/restaurant/bean/LaborfeeSearchBean.java
new file mode 100644
index 0000000..41612b6
--- /dev/null
+++ b/src/main/java/com/supwisdom/dlpay/restaurant/bean/LaborfeeSearchBean.java
@@ -0,0 +1,50 @@
+package com.supwisdom.dlpay.restaurant.bean;
+
+public class LaborfeeSearchBean {
+ private String startdate;
+ private String enddate;
+ private String datetype;
+ private String yearmonth;
+
+ public LaborfeeSearchBean() {
+ }
+
+ public LaborfeeSearchBean(String startdate, String enddate, String datetype, String yearmonth) {
+ this.startdate = startdate;
+ this.enddate = enddate;
+ this.datetype = datetype;
+ this.yearmonth = yearmonth;
+ }
+
+ public String getStartdate() {
+ return startdate;
+ }
+
+ public void setStartdate(String startdate) {
+ this.startdate = startdate;
+ }
+
+ public String getEnddate() {
+ return enddate;
+ }
+
+ public void setEnddate(String enddate) {
+ this.enddate = enddate;
+ }
+
+ public String getDatetype() {
+ return datetype;
+ }
+
+ public void setDatetype(String datetype) {
+ this.datetype = datetype;
+ }
+
+ public String getYearmonth() {
+ return yearmonth;
+ }
+
+ public void setYearmonth(String yearmonth) {
+ this.yearmonth = yearmonth;
+ }
+}
diff --git a/src/main/java/com/supwisdom/dlpay/restaurant/bean/LaborfeeSearchData.java b/src/main/java/com/supwisdom/dlpay/restaurant/bean/LaborfeeSearchData.java
new file mode 100644
index 0000000..943496d
--- /dev/null
+++ b/src/main/java/com/supwisdom/dlpay/restaurant/bean/LaborfeeSearchData.java
@@ -0,0 +1,134 @@
+package com.supwisdom.dlpay.restaurant.bean;
+
+public class LaborfeeSearchData {
+ private Integer rownum; //行号
+
+ private Integer dwid; //单位id 设备组一级
+ private String dwname; //单位名称
+ private Integer groupid; //食堂ID 设备组二级
+ private String groupname; //单位名称
+
+ private Double btotalamt; //早餐总金额
+ private Double ltotalamt; //午餐总金额
+ private Double dtotalamt; //晚餐总金额
+
+ private Double bpayamt; //早餐支付金额
+ private Double lpayamt; //午餐支付总金额
+ private Double dpayamt; //晚餐支付总金额
+
+ private Double bfeeamt; //早餐支付金额
+ private Double lfeeamt; //午餐支付总金额
+ private Double dfeeamt; //晚餐支付总金额
+
+ public Integer getRownum() {
+ return rownum;
+ }
+
+ public void setRownum(Integer rownum) {
+ this.rownum = rownum;
+ }
+
+ public Integer getDwid() {
+ return dwid;
+ }
+
+ public void setDwid(Integer dwid) {
+ this.dwid = dwid;
+ }
+
+ public String getDwname() {
+ return dwname;
+ }
+
+ public void setDwname(String dwname) {
+ this.dwname = dwname;
+ }
+
+ public Integer getGroupid() {
+ return groupid;
+ }
+
+ public void setGroupid(Integer groupid) {
+ this.groupid = groupid;
+ }
+
+ public String getGroupname() {
+ return groupname;
+ }
+
+ public void setGroupname(String groupname) {
+ this.groupname = groupname;
+ }
+
+ public Double getBtotalamt() {
+ return btotalamt;
+ }
+
+ public void setBtotalamt(Double btotalamt) {
+ this.btotalamt = btotalamt;
+ }
+
+ public Double getLtotalamt() {
+ return ltotalamt;
+ }
+
+ public void setLtotalamt(Double ltotalamt) {
+ this.ltotalamt = ltotalamt;
+ }
+
+ public Double getDtotalamt() {
+ return dtotalamt;
+ }
+
+ public void setDtotalamt(Double dtotalamt) {
+ this.dtotalamt = dtotalamt;
+ }
+
+ public Double getBpayamt() {
+ return bpayamt;
+ }
+
+ public void setBpayamt(Double bpayamt) {
+ this.bpayamt = bpayamt;
+ }
+
+ public Double getLpayamt() {
+ return lpayamt;
+ }
+
+ public void setLpayamt(Double lpayamt) {
+ this.lpayamt = lpayamt;
+ }
+
+ public Double getDpayamt() {
+ return dpayamt;
+ }
+
+ public void setDpayamt(Double dpayamt) {
+ this.dpayamt = dpayamt;
+ }
+
+ public Double getBfeeamt() {
+ return bfeeamt;
+ }
+
+ public void setBfeeamt(Double bfeeamt) {
+ this.bfeeamt = bfeeamt;
+ }
+
+ public Double getLfeeamt() {
+ return lfeeamt;
+ }
+
+ public void setLfeeamt(Double lfeeamt) {
+ this.lfeeamt = lfeeamt;
+ }
+
+ public Double getDfeeamt() {
+ return dfeeamt;
+ }
+
+ public void setDfeeamt(Double dfeeamt) {
+ this.dfeeamt = dfeeamt;
+ }
+}
diff --git a/src/main/java/com/supwisdom/dlpay/restaurant/bean/LaborfeeShowBean.java b/src/main/java/com/supwisdom/dlpay/restaurant/bean/LaborfeeShowBean.java
new file mode 100644
index 0000000..a7973f6
--- /dev/null
+++ b/src/main/java/com/supwisdom/dlpay/restaurant/bean/LaborfeeShowBean.java
@@ -0,0 +1,151 @@
+package com.supwisdom.dlpay.restaurant.bean;
+
+import java.util.ArrayList;
+import java.util.List;
+
+public class LaborfeeShowBean {
+ private Integer dwid; //单位id 设备组一级
+ private String dwname; //单位名称
+
+ private Double btotalamt; //早餐总金额
+ private Double ltotalamt; //午餐总金额
+ private Double dtotalamt; //晚餐总金额
+
+ private Double bpayamt; //早餐支付金额
+ private Double lpayamt; //午餐支付总金额
+ private Double dpayamt; //晚餐支付总金额
+
+ private Double bfeeamt; //早餐支付金额
+ private Double lfeeamt; //午餐支付总金额
+ private Double dfeeamt; //晚餐支付总金额
+
+ private List<LaborfeeSearchData> datalist = new ArrayList<LaborfeeSearchData>(0);
+
+ public LaborfeeShowBean(){
+ }
+
+ public LaborfeeShowBean(Integer dwid, String dwname, Double btotalamt, Double ltotalamt, Double dtotalamt, Double bpayamt, Double lpayamt, Double dpayamt, Double bfeeamt, Double lfeeamt, Double dfeeamt) {
+ this.dwid = dwid;
+ this.dwname = dwname;
+ this.btotalamt = btotalamt;
+ this.ltotalamt = ltotalamt;
+ this.dtotalamt = dtotalamt;
+ this.bpayamt = bpayamt;
+ this.lpayamt = lpayamt;
+ this.dpayamt = dpayamt;
+ this.bfeeamt = bfeeamt;
+ this.lfeeamt = lfeeamt;
+ this.dfeeamt = dfeeamt;
+ }
+
+ public LaborfeeShowBean(Integer dwid, String dwname, Double btotalamt, Double ltotalamt, Double dtotalamt, Double bpayamt, Double lpayamt, Double dpayamt, Double bfeeamt, Double lfeeamt, Double dfeeamt, List<LaborfeeSearchData> datalist) {
+ this.dwid = dwid;
+ this.dwname = dwname;
+ this.btotalamt = btotalamt;
+ this.ltotalamt = ltotalamt;
+ this.dtotalamt = dtotalamt;
+ this.bpayamt = bpayamt;
+ this.lpayamt = lpayamt;
+ this.dpayamt = dpayamt;
+ this.bfeeamt = bfeeamt;
+ this.lfeeamt = lfeeamt;
+ this.dfeeamt = dfeeamt;
+ this.datalist = datalist;
+ }
+
+ public Integer getDwid() {
+ return dwid;
+ }
+
+ public void setDwid(Integer dwid) {
+ this.dwid = dwid;
+ }
+
+ public String getDwname() {
+ return dwname;
+ }
+
+ public void setDwname(String dwname) {
+ this.dwname = dwname;
+ }
+
+ public Double getBtotalamt() {
+ return btotalamt;
+ }
+
+ public void setBtotalamt(Double btotalamt) {
+ this.btotalamt = btotalamt;
+ }
+
+ public Double getLtotalamt() {
+ return ltotalamt;
+ }
+
+ public void setLtotalamt(Double ltotalamt) {
+ this.ltotalamt = ltotalamt;
+ }
+
+ public Double getDtotalamt() {
+ return dtotalamt;
+ }
+
+ public void setDtotalamt(Double dtotalamt) {
+ this.dtotalamt = dtotalamt;
+ }
+
+ public Double getBpayamt() {
+ return bpayamt;
+ }
+
+ public void setBpayamt(Double bpayamt) {
+ this.bpayamt = bpayamt;
+ }
+
+ public Double getLpayamt() {
+ return lpayamt;
+ }
+
+ public void setLpayamt(Double lpayamt) {
+ this.lpayamt = lpayamt;
+ }
+
+ public Double getDpayamt() {
+ return dpayamt;
+ }
+
+ public void setDpayamt(Double dpayamt) {
+ this.dpayamt = dpayamt;
+ }
+
+ public Double getBfeeamt() {
+ return bfeeamt;
+ }
+
+ public void setBfeeamt(Double bfeeamt) {
+ this.bfeeamt = bfeeamt;
+ }
+
+ public Double getLfeeamt() {
+ return lfeeamt;
+ }
+
+ public void setLfeeamt(Double lfeeamt) {
+ this.lfeeamt = lfeeamt;
+ }
+
+ public Double getDfeeamt() {
+ return dfeeamt;
+ }
+
+ public void setDfeeamt(Double dfeeamt) {
+ this.dfeeamt = dfeeamt;
+ }
+
+ public List<LaborfeeSearchData> getDatalist() {
+ return datalist;
+ }
+
+ public void setDatalist(List<LaborfeeSearchData> datalist) {
+ this.datalist = datalist;
+ }
+}
diff --git a/src/main/java/com/supwisdom/dlpay/restaurant/controller/StatementReportController.java b/src/main/java/com/supwisdom/dlpay/restaurant/controller/StatementReportController.java
new file mode 100644
index 0000000..1bbc804
--- /dev/null
+++ b/src/main/java/com/supwisdom/dlpay/restaurant/controller/StatementReportController.java
@@ -0,0 +1,109 @@
+package com.supwisdom.dlpay.restaurant.controller;
+
+import com.supwisdom.dlpay.framework.domain.TOperator;
+import com.supwisdom.dlpay.framework.service.SystemUtilService;
+import com.supwisdom.dlpay.framework.util.DateUtil;
+
+import com.supwisdom.dlpay.restaurant.bean.LaborfeeSearchBean;
+import com.supwisdom.dlpay.restaurant.bean.LaborfeeShowBean;
+import com.supwisdom.dlpay.restaurant.service.StatementReportService;
+
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.security.access.prepost.PreAuthorize;
+import org.springframework.security.core.annotation.AuthenticationPrincipal;
+import org.springframework.security.core.userdetails.UserDetails;
+import org.springframework.stereotype.Controller;
+import org.springframework.ui.ModelMap;
+import org.springframework.web.bind.annotation.*;
+
+import javax.servlet.http.HttpServletRequest;
+import javax.servlet.http.HttpServletResponse;
+import java.util.List;
+
+@Controller
+@RequestMapping("/report")
+public class StatementReportController {
+ @Autowired
+ private StatementReportService statementReportService;
+ @Autowired
+ private SystemUtilService systemUtilService;
+
+ @GetMapping("/laborfee")
+ public String LaborfeeIndex(@ModelAttribute("searchBean") LaborfeeSearchBean searchBean,
+ @AuthenticationPrincipal UserDetails operUser,
+ ModelMap map) {
+ try {
+ String statdate = statementReportService.getMaxStatementDate();
+ String maxdate = DateUtil.reformatDatetime(statdate, "yyyyMMdd", "yyyy-MM-dd");
+ String maxmonth = DateUtil.reformatDatetime(statdate.substring(0, 6), "yyyyMM", "yyyy-MM");
+ map.addAttribute("maxdate", maxdate);
+ map.addAttribute("maxmonth", maxmonth);
+
+ searchBean.setStartdate(statdate);
+ searchBean.setEnddate(statdate);
+ searchBean.setDatetype("days");
+ searchBean.setYearmonth(maxmonth);
+ map.addAttribute("showlist", statementReportService.getLaborfeeSearchData(searchBean));
+
+ TOperator oper = (TOperator) operUser;
+ map.addAttribute("opercode", oper == null ? "unknow" : oper.getOpercode());
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+
+ return "restaurant/report/laborfee";
+ }
+
+ @PostMapping("/searchlaborfee")
+ @PreAuthorize("hasPermission('/report/laborfee','')")
+ public String searchLaborfee(@ModelAttribute("searchBean") LaborfeeSearchBean searchBean,
+ @AuthenticationPrincipal UserDetails operUser,
+ ModelMap map) {
+ try {
+ TOperator oper = (TOperator) operUser;
+ map.addAttribute("opercode", oper == null ? "unknow" : oper.getOpercode());
+
+ map.addAttribute("showlist", statementReportService.getLaborfeeSearchData(searchBean));
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+ return "restaurant/report/laborfee::laborfeeTable";
+ }
+
+ @GetMapping("/excelexportlaborfee")
+ @PreAuthorize("hasPermission('/report/excelexportlaborfee','')")
+ public void excelExportLaborfee(@ModelAttribute("searchBean") LaborfeeSearchBean searchBean,
+ @AuthenticationPrincipal UserDetails operUser,
+ HttpServletRequest request, HttpServletResponse response, ModelMap map){
+ try {
+ List<LaborfeeShowBean> datalist = statementReportService.getLaborfeeSearchData(searchBean);
+ TOperator oper = (TOperator) operUser;
+ String filename="商户劳务费报表";
+ statementReportService.doCreateLaborfeeExcel(response, datalist, searchBean, filename, oper);
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+ }
+
+ /**
+ * fixme: 一定不能加访问权限
+ * */
+ @GetMapping("/print/printlaborfee")
+ public String printLaborfee(@ModelAttribute("searchBean") LaborfeeSearchBean searchBean,
+ @RequestParam(value = "opercode",required = false) String opercode, ModelMap map) {
+ try {
+ map.addAttribute("showlist", statementReportService.getLaborfeeSearchData(searchBean));
+
+ TOperator oper = statementReportService.getOperatorByOpercode(opercode);
+ map.addAttribute("opername", oper == null ? "unknow" : oper.getOpername());
+ map.addAttribute("period", statementReportService.getLaborfeeSearchPeriod(searchBean));
+ map.addAttribute("printdatetime",DateUtil.reformatDatetime(systemUtilService.getSysdatetime().getHostdatetime(),DateUtil.DATETIME_FMT,"yyyy-MM-dd HH:mm:ss"));
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+ return "restaurant/report/print/printlaborfee";
+ }
+
+
+
+}
diff --git a/src/main/java/com/supwisdom/dlpay/restaurant/service/StatementReportService.java b/src/main/java/com/supwisdom/dlpay/restaurant/service/StatementReportService.java
new file mode 100644
index 0000000..2af4d7a
--- /dev/null
+++ b/src/main/java/com/supwisdom/dlpay/restaurant/service/StatementReportService.java
@@ -0,0 +1,28 @@
+package com.supwisdom.dlpay.restaurant.service;
+
+import com.supwisdom.dlpay.framework.domain.TOperator;
+import com.supwisdom.dlpay.restaurant.bean.LaborfeeSearchBean;
+import com.supwisdom.dlpay.restaurant.bean.LaborfeeShowBean;
+import org.springframework.transaction.annotation.Transactional;
+
+import javax.servlet.http.HttpServletResponse;
+import java.util.List;
+
+public interface StatementReportService {
+ @Transactional(rollbackFor = Exception.class,readOnly = true)
+ TOperator getOperatorByOpercode(String opercode);
+
+ @Transactional(rollbackFor = Exception.class,readOnly = true)
+ String getMaxStatementDate();
+
+ @Transactional(rollbackFor = Exception.class,readOnly = true)
+ List<LaborfeeShowBean> getLaborfeeSearchData(LaborfeeSearchBean searchBean);
+
+ @Transactional(rollbackFor = Exception.class,readOnly = true)
+ String getLaborfeeSearchPeriod(LaborfeeSearchBean searchBean);
+
+ @Transactional(rollbackFor = Exception.class,readOnly = true)
+ void doCreateLaborfeeExcel(HttpServletResponse response, List<LaborfeeShowBean> datalist, LaborfeeSearchBean searchBean, String filename, TOperator oper);
+
+
+}
diff --git a/src/main/java/com/supwisdom/dlpay/restaurant/service/impl/StatementReportServiceImpl.java b/src/main/java/com/supwisdom/dlpay/restaurant/service/impl/StatementReportServiceImpl.java
new file mode 100644
index 0000000..5bc7a76
--- /dev/null
+++ b/src/main/java/com/supwisdom/dlpay/restaurant/service/impl/StatementReportServiceImpl.java
@@ -0,0 +1,394 @@
+package com.supwisdom.dlpay.restaurant.service.impl;
+
+import com.supwisdom.dlpay.framework.dao.OperatorDao;
+import com.supwisdom.dlpay.framework.domain.TOperator;
+import com.supwisdom.dlpay.framework.service.SystemUtilService;
+import com.supwisdom.dlpay.framework.util.DateUtil;
+import com.supwisdom.dlpay.framework.util.MoneyUtil;
+import com.supwisdom.dlpay.framework.util.StringUtil;
+import com.supwisdom.dlpay.restaurant.bean.LaborfeeSearchBean;
+import com.supwisdom.dlpay.restaurant.bean.LaborfeeSearchData;
+import com.supwisdom.dlpay.restaurant.bean.LaborfeeShowBean;
+import com.supwisdom.dlpay.restaurant.dao.CheckCtlDao;
+import com.supwisdom.dlpay.restaurant.domain.TCheckCtl;
+import com.supwisdom.dlpay.restaurant.service.StatementReportService;
+import com.supwisdom.dlpay.restaurant.util.ExcelPoiUtil;
+import com.supwisdom.dlpay.restaurant.util.RestaurantConstant;
+import org.apache.poi.hssf.usermodel.*;
+import org.apache.poi.ss.util.CellRangeAddress;
+import org.hibernate.query.internal.NativeQueryImpl;
+import org.hibernate.transform.Transformers;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Service;
+
+import javax.persistence.EntityManager;
+import javax.persistence.PersistenceContext;
+import javax.persistence.Query;
+import javax.servlet.http.HttpServletResponse;
+import java.io.OutputStream;
+import java.util.ArrayList;
+import java.util.List;
+
+@Service
+public class StatementReportServiceImpl implements StatementReportService {
+ @Autowired
+ private SystemUtilService systemUtilService;
+ @Autowired
+ private CheckCtlDao checkCtlDao;
+ @Autowired
+ private OperatorDao operatorDao;
+
+ @PersistenceContext
+ private EntityManager entityManager;
+
+ @Override
+ public TOperator getOperatorByOpercode(String opercode) {
+ if (!StringUtil.isEmpty(opercode)) return operatorDao.findByOpercode(opercode.trim());
+ return null;
+ }
+
+ @Override
+ public String getMaxStatementDate() {
+ String result = systemUtilService.getSysdatetime().getHostdate();
+ String statdate = systemUtilService.getBusinessValue(RestaurantConstant.TRANSDTL_STATEMENT_LASTDATE);
+ if (DateUtil.checkDatetimeValid(statdate, "yyyyMMdd")) {
+ result = DateUtil.getNewDay(statdate, -1);
+ } else {
+ TCheckCtl checkCtl = checkCtlDao.getById(RestaurantConstant.CHECK_TRANSDTL_CTLID);
+ if (null != checkCtl) {
+ if (checkCtl.getCheckOk()) {
+ result = checkCtl.getCheckdate();
+ } else {
+ result = DateUtil.getNewDay(checkCtl.getCheckdate(), -1);
+ }
+ }
+ }
+ return result;
+ }
+
+ @Override
+ public List<LaborfeeShowBean> getLaborfeeSearchData(LaborfeeSearchBean searchBean) {
+ if (null != searchBean) {
+ String startdate = DateUtil.unParseToDateFormat(searchBean.getStartdate());
+ String enddate = DateUtil.unParseToDateFormat(searchBean.getEnddate());
+ if ("month".equals(searchBean.getDatetype())) {
+ //按月查询
+ startdate = DateUtil.unParseToDateFormat(searchBean.getYearmonth().trim() + "-01");
+ enddate = String.valueOf(DateUtil.getLastDayOfMonth(Integer.valueOf(searchBean.getYearmonth().substring(0, 4)), Integer.valueOf(searchBean.getYearmonth().substring(5, 7))));
+ }
+
+ StringBuffer sb = new StringBuffer("select cast(ROW_NUMBER() OVER() as int4) as rownum,case when a2.devgroupid is not null then a2.devgroupid when a1.devgroupid is not null then a1.devgroupid else t.devgroupid end as dwid," +
+ " case when a2.devgroupid is not null then a2.groupname when a1.devgroupid is not null then a1.groupname else '' end as dwname, " +
+ " t.devgroupid as groupid, case when a1.devgroupid is not null then a1.groupname else '' end as groupname, " +
+ " sum(case when t.mealtype='breakfast' then t.totalamt+t.feeamt else 0 end) as btotalamt, " +
+ " sum(case when t.mealtype='lunch' then t.totalamt+t.feeamt else 0 end) as ltotalamt, " +
+ " sum(case when t.mealtype='dinner' then t.totalamt+t.feeamt else 0 end) as dtotalamt, " +
+ " sum(case when t.mealtype='breakfast' then t.totalamt else 0 end) as bpayamt, " +
+ " sum(case when t.mealtype='lunch' then t.totalamt else 0 end) as lpayamt, " +
+ " sum(case when t.mealtype='dinner' then t.totalamt else 0 end) as dpayamt, " +
+ " sum(case when t.mealtype='breakfast' then t.feeamt else 0 end) as bfeeamt, " +
+ " sum(case when t.mealtype='lunch' then t.feeamt else 0 end) as lfeeamt, " +
+ " sum(case when t.mealtype='dinner' then t.feeamt else 0 end) as dfeeamt " +
+ "from tb_rpt_mealsdtl t left join tb_devicegroup a1 on t.devgroupid=a1.devgroupid left join tb_devicegroup a2 on a1.pid=a2.devgroupid " +
+ "where t.checkdate>=:startdate and t.checkdate<=:enddate " +
+ "group by t.devgroupid,a1.devgroupid,a2.devgroupid order by t.devgroupid ");
+ Query query = entityManager.createNativeQuery(sb.toString());
+ query.setParameter("startdate", startdate);
+ query.setParameter("enddate", enddate);
+ query.unwrap(NativeQueryImpl.class).setResultTransformer(Transformers.aliasToBean(LaborfeeSearchData.class));
+ List<LaborfeeSearchData> list = query.getResultList();
+ if (null != list) return transforLaborfeeShowBean(list);
+ }
+ return new ArrayList<>(0);
+ }
+
+ private List<LaborfeeShowBean> transforLaborfeeShowBean(List<LaborfeeSearchData> list) {
+ if (StringUtil.isEmpty(list)) return new ArrayList<>(0);
+
+ List<LaborfeeShowBean> result = new ArrayList<>(0);
+ LaborfeeShowBean sumBean = new LaborfeeShowBean(-1, "总 计", 0D, 0D, 0D, 0D, 0D, 0D, 0D, 0D, 0D);
+ for (LaborfeeSearchData data : list) {
+ sumBean.setBtotalamt(sumBean.getBtotalamt() + data.getBtotalamt());
+ sumBean.setLtotalamt(sumBean.getLtotalamt() + data.getLtotalamt());
+ sumBean.setDtotalamt(sumBean.getDtotalamt() + data.getDtotalamt());
+ sumBean.setBpayamt(sumBean.getBpayamt() + data.getBpayamt());
+ sumBean.setLpayamt(sumBean.getLpayamt() + data.getLpayamt());
+ sumBean.setDpayamt(sumBean.getDpayamt() + data.getDpayamt());
+ sumBean.setBfeeamt(sumBean.getBfeeamt() + data.getBfeeamt());
+ sumBean.setLfeeamt(sumBean.getLfeeamt() + data.getLfeeamt());
+ sumBean.setDfeeamt(sumBean.getDfeeamt() + data.getDfeeamt()); //总计求和
+
+ boolean exist = false;
+ for (LaborfeeShowBean bean : result) {
+ if (bean.getDwid().intValue() == data.getDwid()) {
+ exist = true;
+ bean.getDatalist().add(data);
+ bean.setBtotalamt(bean.getBtotalamt() + data.getBtotalamt());
+ bean.setLtotalamt(bean.getLtotalamt() + data.getLtotalamt());
+ bean.setDtotalamt(bean.getDtotalamt() + data.getDtotalamt());
+
+ bean.setBpayamt(bean.getBpayamt() + data.getBpayamt());
+ bean.setLpayamt(bean.getLpayamt() + data.getLpayamt());
+ bean.setDpayamt(bean.getDpayamt() + data.getDpayamt());
+
+ bean.setBfeeamt(bean.getBfeeamt() + data.getBfeeamt());
+ bean.setLfeeamt(bean.getLfeeamt() + data.getLfeeamt());
+ bean.setDfeeamt(bean.getDfeeamt() + data.getDfeeamt());
+ break;
+ }
+ }
+
+ if (!exist) {
+ LaborfeeShowBean tmp = new LaborfeeShowBean();
+ tmp.setDwid(data.getDwid());
+ tmp.setDwname(data.getDwname());
+ tmp.setBtotalamt(data.getBtotalamt());
+ tmp.setLtotalamt(data.getLtotalamt());
+ tmp.setDtotalamt(data.getDtotalamt());
+
+ tmp.setBpayamt(data.getBpayamt());
+ tmp.setLpayamt(data.getLpayamt());
+ tmp.setDpayamt(data.getDpayamt());
+
+ tmp.setBfeeamt(data.getBfeeamt());
+ tmp.setLfeeamt(data.getLfeeamt());
+ tmp.setDfeeamt(data.getDfeeamt());
+ tmp.getDatalist().add(data);
+
+ result.add(tmp);
+ }
+
+ }
+
+ result.add(sumBean); //最后加上总计
+ return result;
+ }
+
+ @Override
+ public String getLaborfeeSearchPeriod(LaborfeeSearchBean searchBean) {
+ if ("month".equals(searchBean.getDatetype())) {
+ return DateUtil.reformatDatetime(DateUtil.unParseToDateFormat(searchBean.getYearmonth()), "yyyyMM", "yyyy年MM月份");
+ } else {
+ String startdate = DateUtil.unParseToDateFormat(searchBean.getStartdate());
+ String enddate = DateUtil.unParseToDateFormat(searchBean.getEnddate());
+ if (startdate.equals(enddate)) {
+ return DateUtil.reformatDatetime(startdate, "yyyyMMdd", "yyyy年MM月dd日");
+ } else {
+ return DateUtil.reformatDatetime(startdate, "yyyyMMdd", "yyyy年MM月dd日") + " ~ " + DateUtil.reformatDatetime(enddate, "yyyyMMdd", "yyyy年MM月dd日");
+ }
+ }
+ }
+
+ @Override
+ public void doCreateLaborfeeExcel(HttpServletResponse response, List<LaborfeeShowBean> datalist, LaborfeeSearchBean searchBean, String filename, TOperator oper) {
+ // 创建工作簿实例
+ HSSFWorkbook workbook = new HSSFWorkbook();
+ HSSFSheet sheet = workbook.createSheet("商户劳务费清单(总金额打折版)");
+
+ //TODO：设置列宽
+ //序号|单位|食堂|(正价：早餐|中餐|晚餐)|(折后：早餐|中餐|晚餐)|(劳务费：早餐|中餐|晚餐|小计)
+ int columns = 13; //
+ sheet.setColumnWidth(0, ExcelPoiUtil.columnWidth(6)); //序号
+ sheet.setColumnWidth(1, ExcelPoiUtil.columnWidth(25)); //单位
+ sheet.setColumnWidth(2, ExcelPoiUtil.columnWidth(20)); //食堂
+ for (int i = 3; i < columns; i++) {
+ sheet.setColumnWidth(i, ExcelPoiUtil.columnWidth(12));
+ }
+
+ //标题样式
+ HSSFCellStyle titleStyle = ExcelPoiUtil.creatStyle(workbook, "宋体", true, 20, HSSFCellStyle.ALIGN_CENTER, false); //设置单元格样式
+ //表头样式
+ HSSFCellStyle headStyle = ExcelPoiUtil.creatStyle(workbook, "宋体", true, 15, HSSFCellStyle.ALIGN_CENTER, true); //设置单元格样式
+ //正文样式 有边框-textStyle1 无边框-textStyle2
+ HSSFCellStyle textStyle1 = ExcelPoiUtil.creatStyle(workbook, "宋体", false, 10, HSSFCellStyle.ALIGN_CENTER, true); //设置单元格样式
+ HSSFCellStyle textStyle2 = ExcelPoiUtil.creatStyle(workbook, "宋体", false, 10, HSSFCellStyle.ALIGN_CENTER, false); //设置单元格样式
+
+
+ //TODO：创建标题
+ HSSFRow row0 = ExcelPoiUtil.createRow(sheet, 0, 800); //表格标题
+ ExcelPoiUtil.createCell(row0, 0, titleStyle, filename);
+ sheet.addMergedRegion(new CellRangeAddress(0, 0, 0, columns - 1)); //合并单元格CellRangeAddress构造参数依次表示 起始行，截至行，起始列， 截至列
+
+ //TODO：创建表格页眉
+ HSSFRow row1 = ExcelPoiUtil.createRow(sheet, 1, 400);
+ ExcelPoiUtil.createCell(row1, 0, textStyle2, "区间");
+ ExcelPoiUtil.createCell(row1, 1, textStyle2, getLaborfeeSearchPeriod(searchBean));
+ ExcelPoiUtil.createCell(row1, columns - 1, ExcelPoiUtil.creatStyle(workbook, "宋体", false, 10, HSSFCellStyle.ALIGN_RIGHT, false), "单位：元");
+
+ //TODO：创建表头（poi做多行合并，一定需要先绘制单元格，然后写入数据，最后合并）
+ HSSFRow row2 = ExcelPoiUtil.createRow(sheet, 2, 600);
+ ExcelPoiUtil.createCell(row2, 0, headStyle, "序号");
+ ExcelPoiUtil.createCell(row2, 1, headStyle, "单位");
+ ExcelPoiUtil.createCell(row2, 2, headStyle, "食堂");
+
+ ExcelPoiUtil.createCell(row2, 3, headStyle, "消费正价");
+ ExcelPoiUtil.createCell(row2, 4, headStyle, null);
+ ExcelPoiUtil.createCell(row2, 5, headStyle, null);
+ sheet.addMergedRegion(new CellRangeAddress(2, 2, 3, 5)); //合并单元格CellRangeAddress构造参数依次表示 起始行，截至行，起始列， 截至列
+
+ ExcelPoiUtil.createCell(row2, 6, headStyle, "优惠后支付");
+ ExcelPoiUtil.createCell(row2, 7, headStyle, null);
+ ExcelPoiUtil.createCell(row2, 8, headStyle, null);
+ sheet.addMergedRegion(new CellRangeAddress(2, 2, 6, 8)); //合并单元格CellRangeAddress构造参数依次表示 起始行，截至行，起始列， 截至列
+
+ ExcelPoiUtil.createCell(row2, 9, headStyle, "应支付劳务费");
+ ExcelPoiUtil.createCell(row2, 10, headStyle, null);
+ ExcelPoiUtil.createCell(row2, 11, headStyle, null);
+ ExcelPoiUtil.createCell(row2, 12, headStyle, null);
+ sheet.addMergedRegion(new CellRangeAddress(2, 2, 9, 12)); //合并单元格CellRangeAddress构造参数依次表示 起始行，截至行，起始列， 截至列
+
+
+ HSSFRow row3 = ExcelPoiUtil.createRow(sheet, 3, 800); //表头第二行
+ ExcelPoiUtil.createCell(row3, 0, headStyle, null);
+ sheet.addMergedRegion(new CellRangeAddress(2, 3, 0, 0)); //合并列
+
+ ExcelPoiUtil.createCell(row3, 1, headStyle, null);
+ sheet.addMergedRegion(new CellRangeAddress(2, 3, 1, 1)); //合并列
+
+ ExcelPoiUtil.createCell(row3, 2, headStyle, null);
+ sheet.addMergedRegion(new CellRangeAddress(2, 3, 2, 2)); //合并列
+
+ ExcelPoiUtil.createCell(row3, 3, headStyle, "早餐\n正价金额");
+ ExcelPoiUtil.createCell(row3, 4, headStyle, "午餐\n正价金额");
+ ExcelPoiUtil.createCell(row3, 5, headStyle, "晚餐\n正价金额");
+
+ ExcelPoiUtil.createCell(row3, 6, headStyle, "早餐\n折后金额");
+ ExcelPoiUtil.createCell(row3, 7, headStyle, "午餐\n折后金额");
+ ExcelPoiUtil.createCell(row3, 8, headStyle, "晚餐\n折后金额");
+
+ ExcelPoiUtil.createCell(row3, 9, headStyle, "早餐\n劳务费");
+ ExcelPoiUtil.createCell(row3, 10, headStyle, "午餐\n劳务费");
+ ExcelPoiUtil.createCell(row3, 11, headStyle, "晚餐\n劳务费");
+ ExcelPoiUtil.createCell(row3, 12, headStyle, "应支付劳\n务费小计");
+
+ //TODO: 数据
+ int rowNum = 4;
+ if (StringUtil.isEmpty(datalist)) {
+ //无数据
+ HSSFRow row4 = ExcelPoiUtil.createRow(sheet, rowNum, 500);
+ ExcelPoiUtil.createCell(row4, 0, textStyle1, "无数据");
+ for(int n=1;n<columns;n++) ExcelPoiUtil.createCell(row4, n, textStyle1, null);
+ sheet.addMergedRegion(new CellRangeAddress(rowNum, rowNum, 0, columns - 1)); //合并列
+ } else {
+ //有数据
+ for (int i = 0; i < datalist.size() - 1; i++) {
+ LaborfeeShowBean rowData = datalist.get(i);
+ if (StringUtil.isEmpty(rowData.getDatalist())) continue;
+
+ int firstRowNo = rowNum;
+ HSSFRow row = ExcelPoiUtil.createRow(sheet, rowNum++, 500);
+ ExcelPoiUtil.createCell(row, 0, textStyle1, "" + rowData.getDatalist().get(0).getRownum()); //序号
+ ExcelPoiUtil.createCell(row, 1, textStyle1, rowData.getDwname()); //单位
+
+ for (int j = 0; j < rowData.getDatalist().size(); j++) {
+ LaborfeeSearchData detail = rowData.getDatalist().get(j);
+ if (j > 0) {
+ //非首行
+ row = ExcelPoiUtil.createRow(sheet, rowNum++, 500);
+ ExcelPoiUtil.createCell(row, 0, textStyle1, "" + detail.getRownum()); //序号
+ ExcelPoiUtil.createCell(row, 1, textStyle1, null); //序号
+ }
+ ExcelPoiUtil.createCell(row, 2, textStyle1, detail.getGroupname()); //食堂
+ ExcelPoiUtil.createCell(row, 3, textStyle1, MoneyUtil.formatYuanToString(detail.getBtotalamt())); //早餐
+ ExcelPoiUtil.createCell(row, 4, textStyle1, MoneyUtil.formatYuanToString(detail.getLtotalamt())); //午餐
+ ExcelPoiUtil.createCell(row, 5, textStyle1, MoneyUtil.formatYuanToString(detail.getDtotalamt())); //晚餐
+
+ ExcelPoiUtil.createCell(row, 6, textStyle1, MoneyUtil.formatYuanToString(detail.getBpayamt())); //早餐
+ ExcelPoiUtil.createCell(row, 7, textStyle1, MoneyUtil.formatYuanToString(detail.getLpayamt())); //午餐
+ ExcelPoiUtil.createCell(row, 8, textStyle1, MoneyUtil.formatYuanToString(detail.getDpayamt())); //晚餐
+
+ ExcelPoiUtil.createCell(row, 9, textStyle1, MoneyUtil.formatYuanToString(detail.getBfeeamt())); //早餐
+ ExcelPoiUtil.createCell(row, 10, textStyle1, MoneyUtil.formatYuanToString(detail.getLfeeamt())); //午餐
+ ExcelPoiUtil.createCell(row, 11, textStyle1, MoneyUtil.formatYuanToString(detail.getDfeeamt())); //晚餐
+ ExcelPoiUtil.createCell(row, 12, textStyle1, MoneyUtil.formatYuanToString(detail.getBfeeamt() + detail.getLfeeamt() + detail.getDfeeamt())); //小计
+ }
+ if (rowData.getDatalist().size() > 1) {
+ sheet.addMergedRegion(new CellRangeAddress(firstRowNo, rowNum - 1, 1, 1)); //合并列
+
+ //单位小计行
+ row = ExcelPoiUtil.createRow(sheet, rowNum++, 500);
+ ExcelPoiUtil.createCell(row, 0, textStyle1, rowData.getDwname() + "小计");
+ ExcelPoiUtil.createCell(row, 1, textStyle1, null);
+ ExcelPoiUtil.createCell(row, 2, textStyle1, null);
+ sheet.addMergedRegion(new CellRangeAddress(rowNum - 1, rowNum - 1, 0, 2)); //合并列
+
+ ExcelPoiUtil.createCell(row, 3, textStyle1, MoneyUtil.formatYuanToString(rowData.getBtotalamt())); //早餐
+ ExcelPoiUtil.createCell(row, 4, textStyle1, MoneyUtil.formatYuanToString(rowData.getLtotalamt())); //午餐
+ ExcelPoiUtil.createCell(row, 5, textStyle1, MoneyUtil.formatYuanToString(rowData.getDtotalamt())); //晚餐
+
+ ExcelPoiUtil.createCell(row, 6, textStyle1, MoneyUtil.formatYuanToString(rowData.getBpayamt())); //早餐
+ ExcelPoiUtil.createCell(row, 7, textStyle1, MoneyUtil.formatYuanToString(rowData.getLpayamt())); //午餐
+ ExcelPoiUtil.createCell(row, 8, textStyle1, MoneyUtil.formatYuanToString(rowData.getDpayamt())); //晚餐
+
+ ExcelPoiUtil.createCell(row, 9, textStyle1, MoneyUtil.formatYuanToString(rowData.getBfeeamt())); //早餐
+ ExcelPoiUtil.createCell(row, 10, textStyle1, MoneyUtil.formatYuanToString(rowData.getLfeeamt())); //午餐
+ ExcelPoiUtil.createCell(row, 11, textStyle1, MoneyUtil.formatYuanToString(rowData.getDfeeamt())); //晚餐
+ ExcelPoiUtil.createCell(row, 12, textStyle1, MoneyUtil.formatYuanToString(rowData.getBfeeamt() + rowData.getLfeeamt() + rowData.getDfeeamt())); //小计
+ }
+ }
+
+ //TODO: 总计
+ LaborfeeShowBean sumBean = datalist.get(datalist.size() - 1);
+ HSSFRow sumRow = ExcelPoiUtil.createRow(sheet, rowNum, 500);
+ ExcelPoiUtil.createCell(sumRow, 0, textStyle1, sumBean.getDwname());
+ ExcelPoiUtil.createCell(sumRow, 1, textStyle1, null);
+ ExcelPoiUtil.createCell(sumRow, 2, textStyle1, null);
+ sheet.addMergedRegion(new CellRangeAddress(rowNum, rowNum, 0, 2)); //合并列
+
+ ExcelPoiUtil.createCell(sumRow, 3, textStyle1, MoneyUtil.formatYuanToString(sumBean.getBtotalamt())); //早餐
+ ExcelPoiUtil.createCell(sumRow, 4, textStyle1, MoneyUtil.formatYuanToString(sumBean.getLtotalamt())); //午餐
+ ExcelPoiUtil.createCell(sumRow, 5, textStyle1, MoneyUtil.formatYuanToString(sumBean.getDtotalamt())); //晚餐
+
+ ExcelPoiUtil.createCell(sumRow, 6, textStyle1, MoneyUtil.formatYuanToString(sumBean.getBpayamt())); //早餐
+ ExcelPoiUtil.createCell(sumRow, 7, textStyle1, MoneyUtil.formatYuanToString(sumBean.getLpayamt())); //午餐
+ ExcelPoiUtil.createCell(sumRow, 8, textStyle1, MoneyUtil.formatYuanToString(sumBean.getDpayamt())); //晚餐
+
+ ExcelPoiUtil.createCell(sumRow, 9, textStyle1, MoneyUtil.formatYuanToString(sumBean.getBfeeamt())); //早餐
+ ExcelPoiUtil.createCell(sumRow, 10, textStyle1, MoneyUtil.formatYuanToString(sumBean.getLfeeamt())); //午餐
+ ExcelPoiUtil.createCell(sumRow, 11, textStyle1, MoneyUtil.formatYuanToString(sumBean.getDfeeamt())); //晚餐
+ ExcelPoiUtil.createCell(sumRow, 12, textStyle1, MoneyUtil.formatYuanToString(sumBean.getBfeeamt() + sumBean.getLfeeamt() + sumBean.getDfeeamt())); //小计
+ }
+
+ //TODO: 表格页脚
+ HSSFCellStyle textStyle3 = ExcelPoiUtil.creatStyle(workbook, "宋体", false, 10, HSSFCellStyle.ALIGN_LEFT, false); //设置单元格样式
+ HSSFRow buttom = ExcelPoiUtil.createRow(sheet, ++rowNum, 400);
+ ExcelPoiUtil.createCell(buttom, 0, textStyle3, "制表人：" + (oper == null ? "unknow" : oper.getOpername()) + " " + DateUtil.reformatDatetime(systemUtilService.getSysdatetime().getHostdatetime(), DateUtil.DATETIME_FMT, "yyyy-MM-dd HH:mm:ss"));
+ sheet.addMergedRegion(new CellRangeAddress(rowNum, rowNum, 0, 2)); //合并列
+
+ //TODO: 审核信息
+ HSSFRow signRow10 = ExcelPoiUtil.createRow(sheet, rowNum + 3, 400);
+ ExcelPoiUtil.createCell(signRow10, 0, textStyle3, "银行方审核盖章：");
+ ExcelPoiUtil.createCell(signRow10, 6, textStyle3, "苍山饭店审核盖章：");
+ sheet.addMergedRegion(new CellRangeAddress(rowNum + 3, rowNum + 3, 0, 5)); //合并列
+ sheet.addMergedRegion(new CellRangeAddress(rowNum + 3, rowNum + 3, 6, columns - 1)); //合并列
+ HSSFRow signRow11 = ExcelPoiUtil.createRow(sheet, rowNum + 4, 400);
+ ExcelPoiUtil.createCell(signRow11, 0, textStyle3, "审核人：");
+ ExcelPoiUtil.createCell(signRow11, 6, textStyle3, "审核人：");
+ sheet.addMergedRegion(new CellRangeAddress(rowNum + 4, rowNum + 4, 0, 5)); //合并列
+ sheet.addMergedRegion(new CellRangeAddress(rowNum + 4, rowNum + 4, 6, columns - 1)); //合并列
+
+ HSSFRow signRow20 = ExcelPoiUtil.createRow(sheet, rowNum + 8, 400);
+ ExcelPoiUtil.createCell(signRow20, 0, textStyle3, "市民卡公司审核盖章：");
+ ExcelPoiUtil.createCell(signRow20, 6, textStyle3, "建桥园审核盖章：");
+ sheet.addMergedRegion(new CellRangeAddress(rowNum + 8, rowNum + 8, 0, 5)); //合并列
+ sheet.addMergedRegion(new CellRangeAddress(rowNum + 8, rowNum + 8, 6, columns - 1)); //合并列
+ HSSFRow signRow21 = ExcelPoiUtil.createRow(sheet, rowNum + 9, 400);
+ ExcelPoiUtil.createCell(signRow21, 0, textStyle3, "审核人：");
+ ExcelPoiUtil.createCell(signRow21, 6, textStyle3, "审核人：");
+ sheet.addMergedRegion(new CellRangeAddress(rowNum + 9, rowNum + 9, 0, 5)); //合并列
+ sheet.addMergedRegion(new CellRangeAddress(rowNum + 9, rowNum + 9, 6, columns - 1)); //合并列
+
+ try {
+ response.setContentType("application/x-msdownload");
+ response.setHeader("Content-Disposition", "attachment;" + " filename="+ new String(filename.getBytes(), "ISO-8859-1") + ".xls");
+ OutputStream out = response.getOutputStream();
+ workbook.write(out);
+ out.flush();
+ out.close();
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+
+ }
+
+}
diff --git a/src/main/java/com/supwisdom/dlpay/restaurant/util/ExcelPoiUtil.java b/src/main/java/com/supwisdom/dlpay/restaurant/util/ExcelPoiUtil.java
new file mode 100644
index 0000000..4fa1115
--- /dev/null
+++ b/src/main/java/com/supwisdom/dlpay/restaurant/util/ExcelPoiUtil.java
@@ -0,0 +1,48 @@
+package com.supwisdom.dlpay.restaurant.util;
+
+import org.apache.poi.hssf.usermodel.*;
+import org.apache.poi.hssf.util.HSSFColor;
+
+public class ExcelPoiUtil {
+ public static int columnWidth(int width) {
+ return (int) ((width + 0.72) * 256);
+ }
+
+ public static HSSFCellStyle creatStyle(HSSFWorkbook wb, String fontName, boolean fontWeight, int fontHeightInPoints, short alignment, boolean border){
+ //设置内容字体
+ HSSFFont fontContent = wb.createFont();
+ if (fontWeight) fontContent.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); // 字体加粗
+ fontContent.setFontName(fontName);
+ fontContent.setFontHeightInPoints((short) fontHeightInPoints);
+ //创建内容样式
+ HSSFCellStyle styleContent = wb.createCellStyle();
+ styleContent.setFont(fontContent);
+ styleContent.setWrapText(true);
+ styleContent.setAlignment(alignment);
+ styleContent.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
+ if (border){
+ styleContent.setBorderBottom(HSSFCellStyle.BORDER_THIN);
+ styleContent.setBottomBorderColor(HSSFColor.BLACK.index);
+ styleContent.setBorderLeft(HSSFCellStyle.BORDER_THIN);
+ styleContent.setLeftBorderColor(HSSFColor.BLACK.index);
+ styleContent.setBorderRight(HSSFCellStyle.BORDER_THIN);
+ styleContent.setRightBorderColor(HSSFColor.BLACK.index);
+ styleContent.setBorderTop(HSSFCellStyle.BORDER_THIN);
+ styleContent.setTopBorderColor(HSSFColor.BLACK.index);
+ }
+ return styleContent;
+ }
+
+ public static HSSFRow createRow(HSSFSheet sheet, int rowIndex, int height) {
+ HSSFRow row = sheet.createRow(rowIndex);
+ row.setHeight((short) height);
+ return row;
+ }
+
+ public static HSSFCell createCell(HSSFRow row, int columnIndex, HSSFCellStyle hssfCellStyle, String content) {
+ HSSFCell cell = row.createCell(columnIndex);
+ cell.setCellStyle(hssfCellStyle);
+ cell.setCellValue(content);
+ return cell;
+ }
+}
diff --git a/src/main/kotlin/com/supwisdom/dlpay/security.kt b/src/main/kotlin/com/supwisdom/dlpay/security.kt
index 7e0b13a..0d711ef 100644
--- a/src/main/kotlin/com/supwisdom/dlpay/security.kt
+++ b/src/main/kotlin/com/supwisdom/dlpay/security.kt
@@ -189,6 +189,7 @@
.antMatchers("/login", "/login/form").permitAll()
.antMatchers("/static/**").permitAll()
.antMatchers("/code/image").permitAll()
+ .antMatchers("/report/print/**").permitAll() //报表打印
.antMatchers("/**").hasAnyRole("USER", "ADMIN")
.anyRequest().authenticated()
.and()
diff --git a/src/main/resources/data.sql b/src/main/resources/data.sql
index e01f263..b49c77f 100644
--- a/src/main/resources/data.sql
+++ b/src/main/resources/data.sql
@@ -124,6 +124,8 @@
INSERT INTO "tb_function" (id,createtime,isleaf,lastsaved,menuicon,menuurl,name,ordernum,parentid) VALUES (11, NULL, 0, NULL, 'layui-icon-util', '#', '就餐白名单管理', 7, -1);
INSERT INTO "tb_function"("id", "createtime", "isleaf", "lastsaved", "menuicon", "menuurl", "name", "ordernum", "parentid") VALUES (32, NULL, 1, NULL, '', '/shopsettlement/index', '商户管理', 2, 22);
INSERT INTO "tb_function"("id", "createtime", "isleaf", "lastsaved", "menuicon", "menuurl", "name", "ordernum", "parentid") VALUES (34, NULL, 1, NULL, '', '/customerlist/index', '餐补人员名单管理', 1, 24);
+INSERT INTO "tb_function"("id", "createtime", "isleaf", "lastsaved", "menuicon", "menuurl", "name", "ordernum", "parentid") VALUES (35, NULL, 0, NULL, 'layui-icon-rmb', '#', '报表中心', 10, -1);
+INSERT INTO "tb_function"("id", "createtime", "isleaf", "lastsaved", "menuicon", "menuurl", "name", "ordernum", "parentid") VALUES (36, NULL, 1, NULL, '', '/report/laborfee', '商户劳务费报表', 1, 35);
@@ -307,6 +309,8 @@
INSERT INTO "tb_permission"("id", "resid", "role_func_id", "roleid") VALUES ('297ea57c6e26421b016e264517d40046', 92, NULL, 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs');
INSERT INTO "tb_permission"("id", "resid", "role_func_id", "roleid") VALUES ('297ea57c6e86d617016e86daac05004a', 94, NULL, 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs');
+INSERT INTO "tb_permission"("id", "resid", "role_func_id", "roleid") VALUES ('ff8080816ea5a411016ea5bc08af007d', 95, NULL, 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs');
+INSERT INTO "tb_permission"("id", "resid", "role_func_id", "roleid") VALUES ('ff8080816eb6236e016eb62961f8007d', 96, NULL, 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs');
INSERT INTO "tb_resource" (id,code,function_id,name,uri) VALUES (4, '1', 4, '添加功能', '/function/add');
@@ -402,12 +406,13 @@
INSERT INTO "tb_resource"("id", "code", "function_id", "name", "uri") VALUES (43, '', 18, '审核', '/whitelistcheck/load4checkdetail');
INSERT INTO "tb_resource"("id", "code", "function_id", "name", "uri") VALUES (51, '', 31, '查询', '/whitelistbind/devbind');
INSERT INTO "tb_resource"("id", "code", "function_id", "name", "uri") VALUES (72, '', 31, '绑定', '/whitelistbind/dobinddev');
-
INSERT INTO "tb_resource"("id", "code", "function_id", "name", "uri") VALUES (73, '', 32, '查询', '/shopsettlement/index');
+
INSERT INTO "tb_resource"("id", "code", "function_id", "name", "uri") VALUES (92, '', 32, '添加', '/shopsettlement/loadadd');
INSERT INTO "tb_resource"("id", "code", "function_id", "name", "uri") VALUES (93, '', 32, '删除', '/shopsettlement/delete');
INSERT INTO "tb_resource"("id", "code", "function_id", "name", "uri") VALUES (94, '', 34, '查询', '/customerlist/index');
-
+INSERT INTO "tb_resource"("id", "code", "function_id", "name", "uri") VALUES (95, '', 36, '查询', '/report/laborfee');
+INSERT INTO "tb_resource"("id", "code", "function_id", "name", "uri") VALUES (96, '', 36, '导出', '/report/excelexportlaborfee');
@@ -458,6 +463,10 @@
INSERT INTO "tb_role_function"("id", "functionid", "permissions", "roleid") VALUES ('297ea57c6e26421b016e264517d30043', 32, NULL, 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs');
+INSERT INTO "tb_role_function"("id", "functionid", "permissions", "roleid") VALUES ('ff8080816ea5a411016ea5bc08ae007b', 35, NULL, 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs');
+INSERT INTO "tb_role_function"("id", "functionid", "permissions", "roleid") VALUES ('ff8080816ea5a411016ea5bc08ae007c', 36, NULL, 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs');
+
+
INSERT INTO "tb_shopsettlement" (shopsettlementno,operno,shopid,shopname) VALUES ('1', '1234', '2000000012', '测试商户');
INSERT INTO "tb_subject" (subjno,balflag,displayflag,endflag,fsubjno,opendate,subjlevel,subjname,subjtype) VALUES ('1001', 1, 'y', 1, NULL, 20190604, 1, '库存现金', 1);
INSERT INTO "tb_subject" (subjno,balflag,displayflag,endflag,fsubjno,opendate,subjlevel,subjname,subjtype) VALUES ('1002', 1, 'y', 1, NULL, 20190604, 1, '银行存款', 1);
diff --git a/src/main/resources/static/custom/css/custom.css b/src/main/resources/static/custom/css/custom.css
index 726abe7..6a8e318 100644
--- a/src/main/resources/static/custom/css/custom.css
+++ b/src/main/resources/static/custom/css/custom.css
@@ -7,4 +7,15 @@
opacity: 0;
width: 113px;
height: 34px;
-}
\ No newline at end of file
+}
+
+button.sw-print {height: 34px!important;}
+
+.sw-table thead tr th {font-size: 12px;min-height: 16px;line-height: 16px;text-align: center;font-weight: bold;}
+.sw-table tbody tr td {font-size: 12px;min-height: 16px;line-height: 16px;text-align: center;}
+
+.sw-print thead tr th { color:black!important; border: 1px solid black!important; }
+.sw-print tbody tr td { color:black!important; border: 1px solid black!important; }
+
+.sw-print-sign { border-collapse: collapse; width: 100%;}
+.sw-print-sign tr td { border:0; color: black; font-weight: normal; font-size: 14px; min-height: 15px;line-height: 15px;text-align: left; padding-left: 3px;}
\ No newline at end of file
diff --git a/src/main/resources/static/custom/css/login.css b/src/main/resources/static/custom/css/login.css
index 60c4cf0..1092a1b 100644
--- a/src/main/resources/static/custom/css/login.css
+++ b/src/main/resources/static/custom/css/login.css
@@ -1,7 +1,7 @@
/** EasyWeb */
body {
- background-image: url("../images/bg_login.png");
+ background-image: url("../images/bg_login_st.jpg");
background-repeat: no-repeat;
background-size: cover;
}
diff --git a/src/main/resources/static/custom/images/bg_login_st.jpg b/src/main/resources/static/custom/images/bg_login_st.jpg
new file mode 100644
index 0000000..260a1a3
--- /dev/null
+++ b/src/main/resources/static/custom/images/bg_login_st.jpg
Binary files differ
diff --git a/src/main/resources/static/libs/CLodop/CLodop_Setup_for_Win32NT_https_3.093Extend.exe b/src/main/resources/static/libs/CLodop/CLodop_Setup_for_Win32NT_https_3.093Extend.exe
new file mode 100755
index 0000000..9988d28
--- /dev/null
+++ b/src/main/resources/static/libs/CLodop/CLodop_Setup_for_Win32NT_https_3.093Extend.exe
Binary files differ
diff --git a/src/main/resources/static/libs/CLodop/LodopFuncs.js b/src/main/resources/static/libs/CLodop/LodopFuncs.js
new file mode 100755
index 0000000..59b481c
--- /dev/null
+++ b/src/main/resources/static/libs/CLodop/LodopFuncs.js
@@ -0,0 +1,144 @@
+var CreatedOKLodop7766 = null, CLodopIsLocal;
+
+//====判断是否需要 Web打印服务CLodop:===
+//===(不支持插件的浏览器版本需要用它)===
+function needCLodop() {
+ try {
+ return true;
+ } catch (err) {
+ return true;
+ }
+}
+
+//====页面引用CLodop云打印必须的JS文件,用双端口(8000和18000）避免其中某个被占用：====
+if (needCLodop()) {
+ // https
+ // var src1 = "https://localhost:8443/CLodopfuncs.js?priority=1";
+ // var src2 = "https://localhost:8444/CLodopfuncs.js?priority=0";
+
+ //http
+ var src1 = "http://localhost:8000/CLodopfuncs.js?priority=1";
+ var src2 ="http://localhost:18000/CLodopfuncs.js?priority=0";
+
+ var head = document.head || document.getElementsByTagName("head")[0] || document.documentElement;
+ var oscript = document.createElement("script");
+ oscript.src = src1;
+ head.insertBefore(oscript, head.firstChild);
+ oscript = document.createElement("script");
+ oscript.src = src2;
+ head.insertBefore(oscript, head.firstChild);
+ CLodopIsLocal = !!((src1 + src2).match(/\/\/localho|\/\/127.0.0./i));
+}
+
+//====获取LODOP对象的主过程：====
+function getLodop(oOBJECT, oEMBED) {
+ // debugger
+ var baseUrl = window.location.pathname;
+ var strHtmInstall = "<br><font color='#FF00FF'>打印控件未安装!点击这里<a href='"+baseUrl+"static/libs/CLodop/install_lodop32.exe' target='_self'>执行安装</a>,安装后请刷新页面或重新进入。</font>";
+ var strHtmUpdate = "<br><font color='#FF00FF'>打印控件需要升级!点击这里<a href='"+baseUrl+"static/libs/CLodop/install_lodop32.exe' target='_self'>执行升级</a>,升级后请重新进入。</font>";
+ var strHtm64_Install = "<br><font color='#FF00FF'>打印控件未安装!点击这里<a href='"+baseUrl+"static/libs/CLodop/install_lodop64.exe' target='_self'>执行安装</a>,安装后请刷新页面或重新进入。</font>";
+ var strHtm64_Update = "<br><font color='#FF00FF'>打印控件需要升级!点击这里<a href='"+baseUrl+"static/libs/CLodop/install_lodop64.exe' target='_self'>执行升级</a>,升级后请重新进入。</font>";
+ var strHtmFireFox = "<br><font color='#FF00FF'>（注意：如曾安装过Lodop旧版附件npActiveXPLugin,请在【工具】->【附加组件】->【扩展】中先卸它）</font>";
+ var strHtmChrome = "<font color='#FF00FF'>(如果此前正常，仅因浏览器升级或重安装而出问题，需重新执行以上安装）</font>";
+ var strCLodopInstall_1 = "<font color='#FF00FF'>Web打印服务CLodop未安装启动，点击这里<a href='"+baseUrl+"static/libs/CLodop/CLodop_Setup_for_Win32NT_https_3.093Extend.exe' target='_self'>下载执行安装</a>";
+ var strCLodopInstall_2 = "<br>（若此前已安装过，可<a href='CLodop.protocol:setup' target='_self'>点这里直接再次启动</a>）";
+ var strCLodopInstall_3 = "，成功后请刷新本页面。</font>";
+ var strCLodopUpdate = "<font color='#FF00FF'>Web打印服务CLodop需升级!点击这里<a href='"+baseUrl+"static/libs/CLodop/CLodop_Setup_for_Win32NT_https_3.093Extend.exe' target='_self'>执行升级</a>,升级后请刷新页面。</font>";
+ var LODOP;
+ try {
+ var ua = navigator.userAgent;
+ var isIE = !!(ua.match(/MSIE/i)) || !!(ua.match(/Trident/i));
+ if (needCLodop()) {
+ try {
+ LODOP = getCLodop();
+ } catch (err) {}
+ if (!LODOP && document.readyState !== "complete") {
+ // alert("网页还没下载完毕，请稍等一下再操作.");
+ layer.msg("网页还没下载完毕，请稍等一下再操作.",{icon: 0});
+ return;
+ }
+ if (!LODOP) {
+ // document.body.innerHTML = strCLodopInstall_1 + (CLodopIsLocal ? strCLodopInstall_2 : "") + strCLodopInstall_3 + document.body.innerHTML;
+ layer.open({
+ title: '安装CLodop插件',
+ area: '500px',
+ content: strCLodopInstall_1 + (CLodopIsLocal ? strCLodopInstall_2 : "") + strCLodopInstall_3
+ });
+ return;
+ } else {
+ if (CLODOP.CVERSION < "3.0.4.8") {
+ // document.body.innerHTML = strCLodopUpdate + document.body.innerHTML;
+ layer.open({
+ title: '安装CLodop插件',
+ area: '500px',
+ content: strCLodopUpdate
+ });
+ }
+ if (oEMBED && oEMBED.parentNode)
+ oEMBED.parentNode.removeChild(oEMBED);
+ if (oOBJECT && oOBJECT.parentNode)
+ oOBJECT.parentNode.removeChild(oOBJECT);
+ }
+ } else {
+ var is64IE = isIE && !!(ua.match(/x64/i));
+ //=====如果页面有Lodop就直接使用，没有则新建:==========
+ if (oOBJECT || oEMBED) {
+ if (isIE)
+ LODOP = oOBJECT;
+ else
+ LODOP = oEMBED;
+ } else if (!CreatedOKLodop7766) {
+ LODOP = document.createElement("object");
+ LODOP.setAttribute("width", 0);
+ LODOP.setAttribute("height", 0);
+ LODOP.setAttribute("style", "position:absolute;left:0px;top:-100px;width:0px;height:0px;");
+ if (isIE)
+ LODOP.setAttribute("classid", "clsid:2105C259-1E0C-4534-8141-A753534CB4CA");
+ else
+ LODOP.setAttribute("type", "application/x-print-lodop");
+ document.documentElement.appendChild(LODOP);
+ CreatedOKLodop7766 = LODOP;
+ } else
+ LODOP = CreatedOKLodop7766;
+ //=====Lodop插件未安装时提示下载地址:==========
+ if ((!LODOP) || (!LODOP.VERSION)) {
+ var tipmsg = "";
+ if (ua.indexOf('Chrome') >= 0){
+ // document.body.innerHTML = strHtmChrome + document.body.innerHTML;
+ tipmsg +=strHtmChrome;
+ }
+
+ if (ua.indexOf('Firefox') >= 0){
+ // document.body.innerHTML = strHtmFireFox + document.body.innerHTML;
+ tipmsg += strHtmFireFox;
+ }
+ // document.body.innerHTML = (is64IE ? strHtm64_Install : strHtmInstall) + document.body.innerHTML;
+ tipmsg += (is64IE ? strHtm64_Install : strHtmInstall)
+ layer.open({
+ title: '安装CLodop插件',
+ area: '500px',
+ content: tipmsg
+ });
+ return LODOP;
+ }
+ }
+ if (LODOP.VERSION < "6.2.2.3") {
+ if (!needCLodop()){
+ // document.body.innerHTML = (is64IE ? strHtm64_Update : strHtmUpdate) + document.body.innerHTML;
+ layer.open({
+ title: '安装CLodop插件',
+ area: '500px',
+ content: (is64IE ? strHtm64_Update : strHtmUpdate)
+ });
+ }
+ return LODOP;
+ }
+ //===如下空白位置适合调用统一功能(如注册语句、语言选择等):===
+
+ //=======================================================
+ return LODOP;
+ } catch (err) {
+ // alert("getLodop出错:" + err);
+ layer.msg("getLodop出错:" + err, {icon: 2});
+ }
+}
diff --git a/src/main/resources/static/libs/CLodop/install_lodop32.exe b/src/main/resources/static/libs/CLodop/install_lodop32.exe
new file mode 100755
index 0000000..93cf607
--- /dev/null
+++ b/src/main/resources/static/libs/CLodop/install_lodop32.exe
Binary files differ
diff --git a/src/main/resources/static/libs/CLodop/install_lodop64.exe b/src/main/resources/static/libs/CLodop/install_lodop64.exe
new file mode 100755
index 0000000..a81c111
--- /dev/null
+++ b/src/main/resources/static/libs/CLodop/install_lodop64.exe
Binary files differ
diff --git a/src/main/resources/static/libs/custom.js b/src/main/resources/static/libs/custom.js
index bb28ba5..a0177b3 100644
--- a/src/main/resources/static/libs/custom.js
+++ b/src/main/resources/static/libs/custom.js
@@ -101,4 +101,10 @@
root.dateFormat = function (str) {
return str.replace(/^(\d{4})(\d{2})(\d{2})$/, '$1-$2-$3'); //yyyyMMdd --> yyyy-MM-dd
}
+
+ root.isempty = function (s) {
+ if (s == null || s.length == 0)
+ return true;
+ return /\s/.test(s);
+ }
}(window));
\ No newline at end of file
diff --git a/src/main/resources/templates/home/console.html b/src/main/resources/templates/home/console.html
index 027897c..94a54a5 100755
--- a/src/main/resources/templates/home/console.html
+++ b/src/main/resources/templates/home/console.html
@@ -55,7 +55,7 @@
var element = layui.element;
var device = layui.device;
- layui.link('/static/custom/css/console.css');
+ layui.link('[[@{/static/custom/css/console.css}]]');
// 渲染轮播
carousel.render({
diff --git a/src/main/resources/templates/index.html b/src/main/resources/templates/index.html
index 127ba66..76b87de 100755
--- a/src/main/resources/templates/index.html
+++ b/src/main/resources/templates/index.html
@@ -136,6 +136,7 @@
<script type="text/javascript" th:src="@{/static/libs/zTree/js/jquery.ztree.all-3.5.min.js}"></script>
<script type="text/javascript" th:src="@{/static/libs/custom.js}"></script>
<script type="text/javascript" th:src="@{/static/libs/numberFormat.js}"></script>
+<script type="text/javascript" th:src="@{/static/libs/CLodop/LodopFuncs.js}"></script>
<script>
layui.config({
base: 'static/custom/module/'
diff --git a/src/main/resources/templates/restaurant/report/laborfee.html b/src/main/resources/templates/restaurant/report/laborfee.html
new file mode 100644
index 0000000..ac93c25
--- /dev/null
+++ b/src/main/resources/templates/restaurant/report/laborfee.html
@@ -0,0 +1,280 @@
+<div class="layui-card">
+ <div class="layui-card-header">
+ <h2 class="header-title">商户劳务费报表</h2>
+ <span class="layui-breadcrumb pull-right">
+ <a href="#">报表中心</a>
+ <a><cite>商户劳务费报表</cite></a>
+ </span>
+ </div>
+ <div class="layui-card-body">
+ <div class="layui-form" lay-filter="shopreport-laborfee-search-form">
+ <input type="hidden" id="shopreport-laborfee-hidden-maxdate" th:value="${maxdate}"/>
+ <input type="hidden" id="shopreport-laborfee-hidden-maxmonth" th:value="${maxmonth}"/>
+ <div class="layui-form-item" style="margin-bottom: 0;">
+ <div class="layui-inline">
+ <label class="layui-form-label">汇总日期</label>
+ <div class="layui-input-inline">
+ <input type="text" name="startdate" id="shopreport-laborfee-search-startdate" placeholder="起始日期"
+ th:value="${maxdate}"
+ autocomplete="off" class="layui-input"/>
+ </div>
+ <div class="layui-form-mid">-</div>
+ <div class="layui-input-inline">
+ <input type="text" name="enddate" id="shopreport-laborfee-search-enddate" placeholder="截止日期"
+ th:value="${maxdate}"
+ autocomplete="off" class="layui-input"/>
+ </div>
+ </div>
+
+ <div class="layui-inline">
+ <label class="layui-form-label">汇总月份</label>
+ <div class="layui-input-block">
+ <input type="text" name="yearmonth" id="shopreport-laborfee-search-yearmonth" placeholder="选择月份"
+ th:value="${maxmonth}" autocomplete="off" class="layui-input"/>
+ </div>
+ </div>
+
+ <div class="layui-inline">
+ <div class="layui-input-block" style="margin-left: 0;">
+ <input type="checkbox" name="datetype" id="shopreport-laborfee-datetype" lay-skin="primary"
+ title="按月份查询"/>
+ </div>
+ </div>
+
+ <div class="layui-inline">
+ <button id="shopreport-laborfee-search-btn" class="layui-btn icon-btn" data-type="search"><i
+ class="layui-icon"></i>搜索
+ </button>
+ </div>
+ </div>
+ </div>
+ </div>
+ <div class="layui-card-body">
+ <div class="layui-form toolbar">
+ <div class="layui-btn-group">
+ <button id="shopreport-laborfee-export-excel" class="layui-btn layui-btn-sm layui-btn-primary sw-print"><i class="layui-icon layui-icon-export"></i>导出</button>
+ <button id="shopreport-laborfee-print-table" class="layui-btn layui-btn-sm layui-btn-primary sw-print"><i class="layui-icon layui-icon-print"></i>打印</button>
+ </div>
+ </div>
+ <table class="layui-table sw-table" id="shopreport-laborfee-table" th:fragment="laborfeeTable">
+ <thead>
+ <tr>
+ <th rowspan="3" style="text-align: center;min-width: 35px;">序号</th>
+ <th rowspan="3" style="text-align: center;min-width: 100px;">单位</th>
+ <th rowspan="3" style="text-align: center;min-width: 100px;">食堂</th>
+ <th colspan="3" style="text-align: center;">消费正价</th>
+ <th colspan="3" style="text-align: center;">优惠后支付</th>
+ <th colspan="4" style="text-align: center;">应支付劳务费</th>
+ </tr>
+ <tr>
+ <th rowspan="2" style="text-align: center;min-width: 60px;">早餐<br/>正价金额</th>
+ <th rowspan="2" style="text-align: center;min-width: 60px;">午餐<br/>正价金额</th>
+ <th rowspan="2" style="text-align: center;min-width: 60px;">晚餐<br/>正价金额</th>
+ <!--<th rowspan="2" style="text-align: center;min-width: 60px;">正价金额<br/>小计</th>-->
+
+ <th rowspan="2" style="text-align: center;min-width: 60px;">早餐<br/>折后金额</th>
+ <th rowspan="2" style="text-align: center;min-width: 60px;">午餐<br/>折后金额</th>
+ <th rowspan="2" style="text-align: center;min-width: 60px;">晚餐<br/>折后金额</th>
+ <!--<th rowspan="2" style="text-align: center;min-width: 60px;">折后金额<br/>小计</th>-->
+
+ <th rowspan="2" style="text-align: center;min-width: 60px;">早餐<br/>劳务费</th>
+ <th rowspan="2" style="text-align: center;min-width: 60px;">午餐<br/>劳务费</th>
+ <th rowspan="2" style="text-align: center;min-width: 60px;">晚餐<br/>劳务费</th>
+ <th rowspan="2" style="text-align: center;min-width: 60px;">应支付劳<br/>务费小计</th>
+ </tr>
+ </thead>
+ <tbody id="shopreport-laborfee-tbody" th:data-startdate="${searchBean.startdate}" th:data-enddate="${searchBean.enddate}" th:data-datetype="${searchBean.datetype}" th:data-yearmonth="${searchBean.yearmonth}" th:data-opercode="${opercode}">
+ <tr th:if="${null==showlist || showlist.size()==0}">
+ <td colspan="13">无数据</td>
+ </tr>
+
+ <div th:remove="tag" th:if="${null!=showlist && showlist.size()>0}" th:each="data:${showlist}" th:with="childCount=${data.datalist.size()}">
+ <tr th:if=${!dataStat.last}>
+ <td th:text="${childCount>0}?${data.datalist[0].rownum}:''"></td>
+ <td th:text="${data.dwname}" th:rowspan="${data.datalist.size()}"></td>
+ <td th:text="${childCount>0}?${data.datalist[0].groupname}:''"></td>
+ <td th:text="${childCount>0}?${#numbers.formatDecimal(data.datalist[0].btotalamt,1,2)}:''"></td>
+ <td th:text="${childCount>0}?${#numbers.formatDecimal(data.datalist[0].ltotalamt,1,2)}:''"></td>
+ <td th:text="${childCount>0}?${#numbers.formatDecimal(data.datalist[0].dtotalamt,1,2)}:''"></td>
+ <td th:text="${childCount>0}?${#numbers.formatDecimal(data.datalist[0].bpayamt,1,2)}:''"></td>
+ <td th:text="${childCount>0}?${#numbers.formatDecimal(data.datalist[0].lpayamt,1,2)}:''"></td>
+ <td th:text="${childCount>0}?${#numbers.formatDecimal(data.datalist[0].dpayamt,1,2)}:''"></td>
+ <td th:text="${childCount>0}?${#numbers.formatDecimal(data.datalist[0].bfeeamt,1,2)}:''"></td>
+ <td th:text="${childCount>0}?${#numbers.formatDecimal(data.datalist[0].lfeeamt,1,2)}:''"></td>
+ <td th:text="${childCount>0}?${#numbers.formatDecimal(data.datalist[0].dfeeamt,1,2)}:''"></td>
+ <td th:text="${childCount>0}?${#numbers.formatDecimal(data.datalist[0].bfeeamt+data.datalist[0].lfeeamt+data.datalist[0].dfeeamt,1,2)}:''"></td>
+ </tr>
+ <tr th:each="article,stats:${data.datalist}" th:if="${!stats.first}">
+ <td th:text="${article.rownum}"></td>
+ <td th:text="${article.groupname}"></td>
+ <td th:text="${#numbers.formatDecimal(article.btotalamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(article.ltotalamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(article.dtotalamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(article.bpayamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(article.lpayamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(article.dpayamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(article.bfeeamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(article.lfeeamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(article.dfeeamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(article.bfeeamt+article.lfeeamt+article.dfeeamt,1,2)}"></td>
+ </tr>
+ <tr th:if="${childCount>1}">
+ <td colspan="3" th:text="${data.dwname+'小计'}"></td>
+ <td th:text="${#numbers.formatDecimal(data.btotalamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(data.ltotalamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(data.dtotalamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(data.bpayamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(data.lpayamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(data.dpayamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(data.bfeeamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(data.lfeeamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(data.dfeeamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(data.bfeeamt+data.lfeeamt+data.dfeeamt,1,2)}"></td>
+ </tr>
+ <tr th:if="${dataStat.last}">
+ <td style="font-weight: bold;" colspan="3" th:text="${data.dwname}"></td>
+ <td style="font-weight: bold;" th:text="${#numbers.formatDecimal(data.btotalamt,1,2)}"></td>
+ <td style="font-weight: bold;" th:text="${#numbers.formatDecimal(data.ltotalamt,1,2)}"></td>
+ <td style="font-weight: bold;" th:text="${#numbers.formatDecimal(data.dtotalamt,1,2)}"></td>
+ <td style="font-weight: bold;" th:text="${#numbers.formatDecimal(data.bpayamt,1,2)}"></td>
+ <td style="font-weight: bold;" th:text="${#numbers.formatDecimal(data.lpayamt,1,2)}"></td>
+ <td style="font-weight: bold;" th:text="${#numbers.formatDecimal(data.dpayamt,1,2)}"></td>
+ <td style="font-weight: bold;" th:text="${#numbers.formatDecimal(data.bfeeamt,1,2)}"></td>
+ <td style="font-weight: bold;" th:text="${#numbers.formatDecimal(data.lfeeamt,1,2)}"></td>
+ <td style="font-weight: bold;" th:text="${#numbers.formatDecimal(data.dfeeamt,1,2)}"></td>
+ <td style="font-weight: bold;" th:text="${#numbers.formatDecimal(data.bfeeamt+data.lfeeamt+data.dfeeamt,1,2)}"></td>
+ </tr>
+ </div>
+ </tbody>
+ </table>
+ </div>
+</div>
+
+<script>
+ layui.use(['form', 'layer', 'laydate', 'admin'], function () {
+ var form = layui.form;
+ var laydate = layui.laydate;
+ var layer = layui.layer;
+ var $ = layui.jquery;
+
+ form.render("checkbox");
+ laydate.render({
+ elem: '#shopreport-laborfee-search-yearmonth',
+ type: 'month',
+ max: $("#shopreport-laborfee-hidden-maxdate").val(),
+ trigger: 'click',
+ change: function (value, date, endDate) {
+ $('#shopreport-laborfee-search-yearmonth').val(value);
+ $('#layui-laydate1').remove();
+ }
+ });
+ laydate.render({
+ elem: '#shopreport-laborfee-search-startdate',
+ max: $("#shopreport-laborfee-hidden-maxdate").val(),
+ trigger: 'click'
+ });
+ laydate.render({
+ elem: '#shopreport-laborfee-search-enddate',
+ max: $("#shopreport-laborfee-hidden-maxdate").val(),
+ trigger: 'click'
+ });
+
+ $("#shopreport-laborfee-search-btn").click(function(){
+ var startdate=$("#shopreport-laborfee-search-startdate").val();
+ var enddate = $("#shopreport-laborfee-search-enddate").val();
+ var yearmonth=$("#shopreport-laborfee-search-yearmonth").val();
+ var dtype = $("#shopreport-laborfee-datetype").is(":checked")?"month":"days";
+ if ("month" == dtype) {
+ if (isempty(yearmonth)) {
+ layer.msg('请选择月份', {icon: 2});
+ return;
+ }
+ } else {
+ if (isempty(startdate) || isempty(enddate)) {
+ layer.msg('请选择汇总时间段', {icon: 2});
+ return;
+ }
+ }
+
+ layer.load(2);
+ $.ajax({
+ url: '[[@{/report/searchlaborfee}]]',
+ type: "POST",
+ data: {
+ startdate: startdate,
+ enddate: enddate,
+ datetype: dtype,
+ yearmonth: yearmonth,
+ _csrf: $("meta[name='_csrf_token']").attr("value")
+ },
+ success: function (data) {
+ $("#shopreport-laborfee-table").html(data);
+ layer.closeAll('loading');
+ },
+ error: function (status, err) {
+ layer.closeAll('loading');
+ layer.msg('查询失败了', {icon: 2});
+ }
+ });
+ });
+
+ //打印
+ var LODOP; //声明为全局变量
+ $("#shopreport-laborfee-print-table").click(function(){
+ var startdate= $("#shopreport-laborfee-tbody").attr("data-startdate");
+ var enddate= $("#shopreport-laborfee-tbody").attr("data-enddate");
+ var datetype= $("#shopreport-laborfee-tbody").attr("data-datetype");
+ var yearmonth= $("#shopreport-laborfee-tbody").attr("data-yearmonth");
+ var opercode = $("#shopreport-laborfee-tbody").attr("data-opercode");
+ var url = '/report/print/printlaborfee?startdate=' + startdate + '&enddate=' + enddate + '&datetype=' + datetype + '&yearmonth=' + yearmonth + '&opercode=' + opercode;
+
+ LODOP = getLodop();
+ LODOP.PRINT_INIT("商户劳务费报表");
+ LODOP.SET_PRINT_PAGESIZE(2, 0, 0,"A4");
+ LODOP.ADD_PRINT_URL(30, 20, "95%", "90%", encodeURI(url));
+ LODOP.ADD_PRINT_HTM("95%", "48%", 150, 50, "<font style='font-size:12px'><span tdata='pageNO'>##</span>/<span tdata='pageCount'> ##</span></font>");
+ LODOP.SET_PRINT_STYLEA(0, "ItemType", 1);
+ LODOP.SET_PRINT_STYLEA(0, "HOrient", 3);
+ LODOP.SET_PRINT_STYLEA(0, "VOrient", 3);
+ LODOP.SET_SHOW_MODE("NP_NO_RESULT", true);
+ LODOP.SET_PRINT_MODE("FULL_WIDTH_FOR_OVERFLOW",true);
+ LODOP.PREVIEW();
+ });
+
+ //导出
+ $("#shopreport-laborfee-export-excel").click(function(){
+ var startdate= $("#shopreport-laborfee-tbody").attr("data-startdate");
+ var enddate= $("#shopreport-laborfee-tbody").attr("data-enddate");
+ var datetype= $("#shopreport-laborfee-tbody").attr("data-datetype");
+ var yearmonth= $("#shopreport-laborfee-tbody").attr("data-yearmonth");
+
+ var dataUrl='[[@{/report/excelexportlaborfee}]]?startdate='+startdate+'&enddate='+enddate+'&datetype='+datetype+'&yearmonth='+yearmonth;
+ var xhr = new XMLHttpRequest();
+ xhr.responseType = "blob"; //设置响应类型为blob类型
+ xhr.onload = function () {
+ debugger
+ if (this.status == "200") {
+ //获取响应文件流
+ var blob = this.response;
+ // 转换完成，创建一个a标签用于下载
+ var aElem = document.createElement('a');
+ aElem.href = window.URL.createObjectURL(blob);
+ aElem.download = "商户劳务费报表.xls";
+ aElem.onload = function (e) {
+ window.URL.revokeObjectURL(aElem.href);
+ };
+ $("body").append(aElem); // 修复firefox中无法触发click
+ aElem.click();
+ $(aElem).remove();
+
+ }else if(this.status == "403"){
+ layer.msg('无导出资源权限', {icon: 2});
+ } else {
+ layer.msg('导出excel失败了', {icon: 2});
+ }
+ }
+ xhr.open("GET", dataUrl, true);
+ xhr.send();
+ });
+ });
+</script>
\ No newline at end of file
diff --git a/src/main/resources/templates/restaurant/report/print/printlaborfee.html b/src/main/resources/templates/restaurant/report/print/printlaborfee.html
new file mode 100644
index 0000000..69ceb7b
--- /dev/null
+++ b/src/main/resources/templates/restaurant/report/print/printlaborfee.html
@@ -0,0 +1,148 @@
+<!DOCTYPE html>
+<html xmlns:th="http://www.thymeleaf.org" xmlns:sec="http://www.thymeleaf.org/thymeleaf-extras-springsecurity4">
+<head>
+ <meta charset="UTF-8">
+ <title>商户劳务费报表</title>
+
+ <link rel="stylesheet" th:href="@{/static/libs/layui/css/layui.css}"/>
+ <link rel="stylesheet" th:href="@{/static/custom/css/custom.css}"/>
+</head>
+<body>
+<div class="layui-card">
+ <div class="layui-card-header" style="text-align: center;">
+ <h1>商户劳务费报表</h1>
+ </div>
+ <div class="layui-card-body">
+ <div class="layui-form toolbar">
+ <div style="float: left;padding-left: 3px;" th:text="${'区间：'+period}"></div>
+ <div style="float: right;" th:text="'单位：元'"></div>
+ </div>
+ <table class="layui-table sw-table sw-print">
+ <thead>
+ <tr>
+ <th rowspan="3" style="text-align: center;min-width: 35px;">序号</th>
+ <th rowspan="3" style="text-align: center;min-width: 100px;">单位</th>
+ <th rowspan="3" style="text-align: center;min-width: 100px;">食堂</th>
+ <th colspan="3" style="text-align: center;">消费正价</th>
+ <th colspan="3" style="text-align: center;">优惠后支付</th>
+ <th colspan="4" style="text-align: center;">应支付劳务费</th>
+ </tr>
+ <tr>
+ <th rowspan="2" style="text-align: center;min-width: 60px;">早餐<br/>正价金额</th>
+ <th rowspan="2" style="text-align: center;min-width: 60px;">午餐<br/>正价金额</th>
+ <th rowspan="2" style="text-align: center;min-width: 60px;">晚餐<br/>正价金额</th>
+ <!--<th rowspan="2" style="text-align: center;min-width: 60px;">正价金额<br/>小计</th>-->
+
+ <th rowspan="2" style="text-align: center;min-width: 60px;">早餐<br/>折后金额</th>
+ <th rowspan="2" style="text-align: center;min-width: 60px;">午餐<br/>折后金额</th>
+ <th rowspan="2" style="text-align: center;min-width: 60px;">晚餐<br/>折后金额</th>
+ <!--<th rowspan="2" style="text-align: center;min-width: 60px;">折后金额<br/>小计</th>-->
+
+ <th rowspan="2" style="text-align: center;min-width: 60px;">早餐<br/>劳务费</th>
+ <th rowspan="2" style="text-align: center;min-width: 60px;">午餐<br/>劳务费</th>
+ <th rowspan="2" style="text-align: center;min-width: 60px;">晚餐<br/>劳务费</th>
+ <th rowspan="2" style="text-align: center;min-width: 60px;">应支付劳<br/>务费小计</th>
+ </tr>
+ </thead>
+ <tbody>
+ <tr th:if="${null==showlist || showlist.size()==0}">
+ <td colspan="13">无数据</td>
+ </tr>
+
+ <div th:remove="tag" th:if="${null!=showlist && showlist.size()>0}" th:each="data:${showlist}"
+ th:with="childCount=${data.datalist.size()}">
+ <tr th:if=${!dataStat.last}>
+ <td th:text="${childCount>0}?${data.datalist[0].rownum}:''"></td>
+ <td th:text="${data.dwname}" th:rowspan="${data.datalist.size()}"></td>
+ <td th:text="${childCount>0}?${data.datalist[0].groupname}:''"></td>
+ <td th:text="${childCount>0}?${#numbers.formatDecimal(data.datalist[0].btotalamt,1,2)}:''"></td>
+ <td th:text="${childCount>0}?${#numbers.formatDecimal(data.datalist[0].ltotalamt,1,2)}:''"></td>
+ <td th:text="${childCount>0}?${#numbers.formatDecimal(data.datalist[0].dtotalamt,1,2)}:''"></td>
+ <td th:text="${childCount>0}?${#numbers.formatDecimal(data.datalist[0].bpayamt,1,2)}:''"></td>
+ <td th:text="${childCount>0}?${#numbers.formatDecimal(data.datalist[0].lpayamt,1,2)}:''"></td>
+ <td th:text="${childCount>0}?${#numbers.formatDecimal(data.datalist[0].dpayamt,1,2)}:''"></td>
+ <td th:text="${childCount>0}?${#numbers.formatDecimal(data.datalist[0].bfeeamt,1,2)}:''"></td>
+ <td th:text="${childCount>0}?${#numbers.formatDecimal(data.datalist[0].lfeeamt,1,2)}:''"></td>
+ <td th:text="${childCount>0}?${#numbers.formatDecimal(data.datalist[0].dfeeamt,1,2)}:''"></td>
+ <td th:text="${childCount>0}?${#numbers.formatDecimal(data.datalist[0].bfeeamt+data.datalist[0].lfeeamt+data.datalist[0].dfeeamt,1,2)}:''"></td>
+ </tr>
+ <tr th:each="article,stats:${data.datalist}" th:if="${!stats.first}">
+ <td th:text="${article.rownum}"></td>
+ <td th:text="${article.groupname}"></td>
+ <td th:text="${#numbers.formatDecimal(article.btotalamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(article.ltotalamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(article.dtotalamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(article.bpayamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(article.lpayamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(article.dpayamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(article.bfeeamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(article.lfeeamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(article.dfeeamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(article.bfeeamt+article.lfeeamt+article.dfeeamt,1,2)}"></td>
+ </tr>
+ <tr th:if="${childCount>1}">
+ <td colspan="3" th:text="${data.dwname+'小计'}"></td>
+ <td th:text="${#numbers.formatDecimal(data.btotalamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(data.ltotalamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(data.dtotalamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(data.bpayamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(data.lpayamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(data.dpayamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(data.bfeeamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(data.lfeeamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(data.dfeeamt,1,2)}"></td>
+ <td th:text="${#numbers.formatDecimal(data.bfeeamt+data.lfeeamt+data.dfeeamt,1,2)}"></td>
+ </tr>
+ <tr th:if="${dataStat.last}">
+ <td style="font-weight: bold;" colspan="3" th:text="${data.dwname}"></td>
+ <td style="font-weight: bold;" th:text="${#numbers.formatDecimal(data.btotalamt,1,2)}"></td>
+ <td style="font-weight: bold;" th:text="${#numbers.formatDecimal(data.ltotalamt,1,2)}"></td>
+ <td style="font-weight: bold;" th:text="${#numbers.formatDecimal(data.dtotalamt,1,2)}"></td>
+ <td style="font-weight: bold;" th:text="${#numbers.formatDecimal(data.bpayamt,1,2)}"></td>
+ <td style="font-weight: bold;" th:text="${#numbers.formatDecimal(data.lpayamt,1,2)}"></td>
+ <td style="font-weight: bold;" th:text="${#numbers.formatDecimal(data.dpayamt,1,2)}"></td>
+ <td style="font-weight: bold;" th:text="${#numbers.formatDecimal(data.bfeeamt,1,2)}"></td>
+ <td style="font-weight: bold;" th:text="${#numbers.formatDecimal(data.lfeeamt,1,2)}"></td>
+ <td style="font-weight: bold;" th:text="${#numbers.formatDecimal(data.dfeeamt,1,2)}"></td>
+ <td style="font-weight: bold;"
+ th:text="${#numbers.formatDecimal(data.bfeeamt+data.lfeeamt+data.dfeeamt,1,2)}"></td>
+ </tr>
+ </div>
+ </tbody>
+ </table>
+ <div class="layui-form toolbar">
+ <div style="float: left;padding-left: 3px;" th:text="${'制表人：'+opername+' '+ printdatetime}"></div>
+ </div>
+ </div>
+ <div class="layui-card-body" style="margin-top: 25px;">
+ <table class="sw-print-sign">
+ <tr>
+ <td width="50%">银行方审核盖章：</td>
+ <td width="50%">苍山饭店审核盖章：</td>
+ </tr>
+ <tr>
+ <td>审核人：</td>
+ <td>审核人：</td>
+ </tr>
+ <tr>
+ <td colspan="2"> </td>
+ </tr>
+ <tr>
+ <td colspan="2"> </td>
+ </tr>
+ <tr>
+ <td colspan="2"> </td>
+ </tr>
+ <tr>
+ <td>市民卡公司审核盖章：</td>
+ <td>建桥园审核盖章：</td>
+ </tr>
+ <tr>
+ <td>审核人：</td>
+ <td>审核人：</td>
+ </tr>
+ </table>
+ </div>
+</div>
+</body>
+</html>
\ No newline at end of file
