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<String , Object> 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<String , Object> 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<Map<String, Object>> dataList = projUseDao.selectItemDetail(param);
|
OrderStatisticsAction.exportExcel(title, header,column, dataList, response);
|
}
|
|
|
|
|
/**
|
* 项目剩余次数统计
|
*/
|
@RequestMapping(value = "/summaryItemDetail")
|
public @ResponseBody
|
AjaxResult summaryItemDetail( @RequestParam Map<String , Object> 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<String , Object> 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<Map<String, Object>> dataList = projUseDao.summaryItemDetail(param);
|
OrderStatisticsAction.exportExcel(title, header,column, dataList, response);
|
}
|
|
|
}
|