package com.matrix.system.hive.statistics; import com.matrix.core.constance.MatrixConstance; import com.matrix.core.pojo.AjaxResult; import com.matrix.core.tools.WebUtil; import com.matrix.system.common.bean.SysUsers; import com.matrix.system.common.tools.DataAuthUtil; import com.matrix.system.hive.dao.SysProjUseDao; 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 org.springframework.web.bind.annotation.ResponseBody; import javax.servlet.http.HttpServletResponse; import java.util.List; import java.util.Map; /** * @author * @description 经营数据 * @date 2020-02-08 10:18 */ @Controller @RequestMapping(value = "/admin/projUseStatistics") public class ProjUseStatisticsAction { @Autowired private SysProjUseDao projUseDao; /** * 项目剩余次数明细 */ @RequestMapping(value = "/showList") public @ResponseBody AjaxResult showList( @RequestParam Map param) { SysUsers sysUsers = (SysUsers) WebUtil.getSession().getAttribute(MatrixConstance.LOGIN_KEY); if(!DataAuthUtil.hasAllShopAuth()){ param.put("shopId", sysUsers.getShopId()); } return AjaxResult.buildSuccessInstance(projUseDao.selectItemDetail(param), projUseDao.selectItemDetailTotal(param)); } @RequestMapping(value = "/exportShowList") public void exportShowList( @RequestParam Map param, HttpServletResponse response) throws Exception { SysUsers sysUsers = (SysUsers) WebUtil.getSession().getAttribute(MatrixConstance.LOGIN_KEY); String title = "项目剩余次数明细"; String[] header = {"客户名", "客户所属门店", "服务名称", "到期日期", "剩余次数", "单价", "项目类型", "套餐类型", "是否使用完成", "备注", "来源", "订单号"}; String[] column = {"VIP_NAME", "SHOP_NAME", "PROJ_NAME", "FAIL_TIME", "SURPLUS_COUNT", "PRICE", "TYPE_NAME", "type", "IS_OVER", "remark", "SOURCE", "ORDER_NO"}; if(!DataAuthUtil.hasAllShopAuth()){ param.put("shopId", sysUsers.getShopId()); } List> dataList = projUseDao.selectItemDetail(param); OrderStatisticsAction.exportExcel(title, header,column, dataList, response); } /** * 项目剩余次数统计 */ @RequestMapping(value = "/summaryItemDetail") public @ResponseBody AjaxResult summaryItemDetail( @RequestParam Map param) { SysUsers sysUsers = (SysUsers) WebUtil.getSession().getAttribute(MatrixConstance.LOGIN_KEY); if(!DataAuthUtil.hasAllShopAuth()){ param.put("shopId", sysUsers.getShopId()); } return AjaxResult.buildSuccessInstance(projUseDao.summaryItemDetail(param), projUseDao.summaryItemDetailTotal(param)); } @RequestMapping(value = "/exportSummaryItemDetail") public void exportSummaryItemDetail( @RequestParam Map param, HttpServletResponse response) throws Exception { SysUsers sysUsers = (SysUsers) WebUtil.getSession().getAttribute(MatrixConstance.LOGIN_KEY); String title = "项目剩余次数统计"; String[] header = {"服务名称", "项目类型", "剩余次数", "剩余消耗总额"}; String[] column = {"PROJ_NAME", "TYPE_NAME", "SURPLUS_COUNT", "PRICE"}; if(!DataAuthUtil.hasAllShopAuth()){ param.put("shopId", sysUsers.getShopId()); } List> dataList = projUseDao.summaryItemDetail(param); OrderStatisticsAction.exportExcel(title, header,column, dataList, response); } }