package com.matrix.system.hive.statistics; import cn.hutool.core.util.StrUtil; import com.matrix.core.constance.MatrixConstance; import com.matrix.core.pojo.AjaxResult; import com.matrix.core.pojo.PaginationVO; import com.matrix.core.tools.DateUtil; import com.matrix.core.tools.WebUtil; import com.matrix.system.app.dto.BusinessesDto; import com.matrix.system.app.vo.BusinessesDataShowVo; import com.matrix.system.common.bean.SysUsers; import com.matrix.system.common.tools.DataAuthUtil; import com.matrix.system.hive.bean.SysBusinessData; import com.matrix.system.hive.dao.SysBusinessDataDao; import com.matrix.system.hiveErp.analysUtil.StatisticsTimeDaoParam; import com.matrix.system.hiveErp.analysUtil.StatisticsTimeUtil; 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.ResponseBody; import java.util.ArrayList; import java.util.Calendar; import java.util.Date; import java.util.List; /** * @author * @description 经营数据 * @date 2020-02-08 10:18 */ @Controller @RequestMapping(value = "admin/sysBusinessData") public class SysBusinessDataAction { @Autowired private SysBusinessDataDao sysBusinessDataDao; /** * 列表显示 */ @RequestMapping(value = "/showList") public @ResponseBody AjaxResult showList(BusinessDataShowVo businessDataShowVo, PaginationVO pageVo) { SysUsers sysUsers = (SysUsers) WebUtil.getSession().getAttribute(MatrixConstance.LOGIN_KEY); if (!DataAuthUtil.hasAllShopAuth()) { businessDataShowVo.setShopId(sysUsers.getShopId()+""); } pageVo.setSort("createTime"); pageVo.setOrder("desc"); List dataList = sysBusinessDataDao.selectShowList(businessDataShowVo, pageVo); AjaxResult result = new AjaxResult(AjaxResult.STATUS_SUCCESS, dataList, sysBusinessDataDao.selectShowListTotal(businessDataShowVo)); return result; } /** * 日销售汇总 * * @param dailySaleVo * @param pageVo * @return */ @RequestMapping(value = "/findDailySaleData") @ResponseBody public AjaxResult findDailySaleData(DailySaleVo dailySaleVo, PaginationVO pageVo) { SysUsers user = WebUtil.getSessionAttribute(MatrixConstance.LOGIN_KEY); Calendar calendar = Calendar.getInstance(); int total = 999; Date endDate = new Date(); if (dailySaleVo.getEndTime() != null) { if (!dailySaleVo.getEndTime().after(new Date())) { calendar.setTime(dailySaleVo.getEndTime()); endDate = DateUtil.nextNDate(dailySaleVo.getEndTime(), 1); } } calendar.add(Calendar.DATE, 1); calendar.add(Calendar.DATE, -pageVo.getOffset()); String endTime = DateUtil.dateToString(calendar.getTime(), DateUtil.DATE_FORMAT_DD); calendar.add(Calendar.DATE, -pageVo.getLimit()); String startTime = DateUtil.dateToString(calendar.getTime(), DateUtil.DATE_FORMAT_DD); if (dailySaleVo.getBeginTime() != null) { Date startDate = DateUtil.stringToDate(startTime, DateUtil.DATE_FORMAT_DD); if(dailySaleVo.getBeginTime().after(startDate)) { startTime = DateUtil.dateFormatStr(dailySaleVo.getBeginTime(), DateUtil.DATE_FORMAT_DD); } long sub = DateUtil.getTimeSpan(dailySaleVo.getBeginTime(), endDate, null); Long l = sub / (1000 * 3600 * 24); total = l.intValue(); } List xAxis = StatisticsTimeUtil.getTimeSpace(startTime, endTime, "日"); List timeSpaceParam = StatisticsTimeUtil.buidParam(xAxis); List statisticsTimeDaoParams = timeSpaceParam.subList(0, timeSpaceParam.size() - 2); if (dailySaleVo.getShopId() == null) { dailySaleVo.setShopId(user.getShopId()); } List dailySaleVos = sysBusinessDataDao.selectDailySaleData(statisticsTimeDaoParams, dailySaleVo.getShopId()); List result = new ArrayList<>(); for (int i = dailySaleVos.size() - 1; i >= 0; i--) { result.add(dailySaleVos.get(i)); } return AjaxResult.buildSuccessInstance(result, total); } @RequestMapping(value = "/findShopBusinessesData") @ResponseBody public AjaxResult findShopBusinessesData(BusinessDataShowVo businessDataShowVo, PaginationVO pageVo) { int start = pageVo.getOffset(); int size = pageVo.getLimit(); int calenderUnit = Calendar.DATE; Long shopId = null; SysUsers sysUsers = (SysUsers) WebUtil.getSession().getAttribute(MatrixConstance.LOGIN_KEY); if (StrUtil.isNotBlank(businessDataShowVo.getShopId())) { shopId = Long.parseLong(businessDataShowVo.getShopId()); } else { shopId = sysUsers.getShopId(); } Calendar calendar = Calendar.getInstance(); if (businessDataShowVo.getBeginTime() != null) { calendar.setTime(businessDataShowVo.getBeginTime()); } calendar.add(calenderUnit, 1); calendar.add(calenderUnit, -start); String endTime = DateUtil.dateToString(calendar.getTime(), DateUtil.DATE_FORMAT_DD); calendar.add(calenderUnit, -size); String startTime = DateUtil.dateToString(calendar.getTime(), DateUtil.DATE_FORMAT_DD); List xAxis = StatisticsTimeUtil.getTimeSpace(startTime, endTime, "日"); List timeSpaceParam = StatisticsTimeUtil.buidParam(xAxis); List statisticsTimeDaoParams = timeSpaceParam.subList(0, timeSpaceParam.size() - 2); List list = sysBusinessDataDao.selectApiBusinessData(statisticsTimeDaoParams, shopId, sysUsers.getCompanyId()); List result = new ArrayList<>(); for (int i = list.size() - 1; i >= 0; i--) { BusinessesDataShowVo item = list.get(i); String dataTime = item.getDataTime(); item.setDataTime(DateUtil.dateToString(DateUtil.stringToDate(dataTime, DateUtil.DATE_FORMAT_DD), DateUtil.DATE_FORMAT_DD)); result.add(item); } return AjaxResult.buildSuccessInstance(result, 100); } }