From 0a8bc68140f77ab95c6569a266206b1d473ef49b Mon Sep 17 00:00:00 2001
From: 陶杰 <1378534974@qq.com>
Date: 星期四, 19 十二月 2024 09:34:15 +0800
Subject: [PATCH] 1.花材统计报表：控制排序字段
---
src/main/java/com/mzl/flower/service/impl/statisticsAnalysis/StatisticAnalysisServiceImpl.java | 77 +++++++++++++++++++++++++++++++++++++-
1 files changed, 74 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/mzl/flower/service/impl/statisticsAnalysis/StatisticAnalysisServiceImpl.java b/src/main/java/com/mzl/flower/service/impl/statisticsAnalysis/StatisticAnalysisServiceImpl.java
index eb95d76..9cc8f69 100644
--- a/src/main/java/com/mzl/flower/service/impl/statisticsAnalysis/StatisticAnalysisServiceImpl.java
+++ b/src/main/java/com/mzl/flower/service/impl/statisticsAnalysis/StatisticAnalysisServiceImpl.java
@@ -1,30 +1,101 @@
package com.mzl.flower.service.impl.statisticsAnalysis;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.mzl.flower.base.cache.DictCacheClient;
import com.mzl.flower.dto.request.statisticAnalysis.FlowerMaterialDTO;
+import com.mzl.flower.dto.response.report.OrderReportResultVO;
import com.mzl.flower.dto.response.statisticAnalysis.FlowerMaterialStaticVO;
import com.mzl.flower.dto.response.statisticAnalysis.FlowerMaterialVO;
+import com.mzl.flower.mapper.statisticsAnalysis.FlowerMaterialMapper;
+import com.mzl.flower.service.BaseService;
import com.mzl.flower.service.statisticsAnalysis.StatisticAnalysisService;
+import com.mzl.flower.utils.ExcelExportUtil;
import lombok.extern.slf4j.Slf4j;
+import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
+import org.springframework.util.CollectionUtils;
import javax.servlet.http.HttpServletResponse;
+import java.net.URLEncoder;
+import java.util.ArrayList;
+import java.util.List;
@Slf4j
@Service
-public class StatisticAnalysisServiceImpl implements StatisticAnalysisService {
+public class StatisticAnalysisServiceImpl extends BaseService implements StatisticAnalysisService {
+
+ @Autowired
+ private DictCacheClient dictCacheClient;
+
+ @Autowired
+ private FlowerMaterialMapper flowerMaterialMapper;
+
@Override
public Page<FlowerMaterialVO> getFlowerMaterialPage(Page page, FlowerMaterialDTO dto) {
- return null;
+ // 判断传入的排序字段是否在特定的字符串里面，如果不在则将排序字段设置未空
+ if (!"f.`level`".equals(dto.getOrderField()) && !"f.price".equals(dto.getOrderField())&&!"f.stock".equals(dto.getOrderField())) {
+ dto.setOrderField(null);
+ }
+
+ Page<FlowerMaterialVO> result=flowerMaterialMapper.getFlowerMaterialPage(page, dto);
+
+ return result;
}
@Override
public FlowerMaterialStaticVO getFlowerMaterialStatis(FlowerMaterialDTO dto) {
- return null;
+ List<FlowerMaterialStaticVO> list= flowerMaterialMapper.getFlowerMaterialStatis(dto);
+ if(!CollectionUtils.isEmpty(list)){
+ return list.get(0);
+ }
+ return null;
}
@Override
public void exportFlowerMaterialSales(HttpServletResponse response, FlowerMaterialDTO dto) {
+ // 判断传入的排序字段是否在特定的字符串里面，如果不在则将排序字段设置未空
+ if (!"f.`level`".equals(dto.getOrderField()) && !"f.price".equals(dto.getOrderField())&&!"f.stock".equals(dto.getOrderField())) {
+ dto.setOrderField(null);
+ }
+ List<FlowerMaterialVO> list=flowerMaterialMapper.getFlowerMaterialList(dto);
+ String[] rowsName = new String[]{
+ "序号"
+ ,"供应商ID", "供应商名称","注册手机号","联系方式","所属集货站","品类","商品名称","等级","商品规格","价格","库存","状态",};
+ List<Object[]> dataList = new ArrayList<>();
+ int sn = 1;
+ for (FlowerMaterialVO o : list) {
+ Object[] objs = new Object[rowsName.length];
+ int a = 0;
+ objs[a++] = sn; // 序号
+ objs[a++] = o.getSupplierId(); // 供应商ID
+ objs[a++] = o.getSupplierName(); // 供应商名称
+ objs[a++] = o.getLoginName(); // 注册手机号
+ objs[a++] = o.getContactTel(); // 联系方式"
+ objs[a++] = o.getStationName(); // 所属集货站
+ objs[a++] = o.getCategoryName(); // 品类
+ objs[a++] = o.getFlowerName(); //商品名称
+// String dictValue = dictCacheClient.getDict("FLOWER_LEVEL", o.getFlowerLevel());
+// objs[a++] = dictValue; //等级
+ objs[a++] = o.getFlowerLevelStr(); //等级
+ objs[a++] = o.getFlowerUnit(); //商品规格
+ objs[a++] = o.getFlowerPrice();//价格
+ objs[a++] = o.getFlowerStock();//库存
+// String dictValueStatus = dictCacheClient.getDict("FLOWER_STATUS", o.getFlowerStatus());
+ // objs[a++] =dictValueStatus;
+ objs[a++] = o.getFlowerStatusStr(); // 状态
+
+ dataList.add(objs);
+ sn++;
+ }
+
+ ExcelExportUtil excelExportUtil = new ExcelExportUtil("花材统计报表", rowsName, dataList, response);
+ try {
+ response.addHeader("filename", URLEncoder.encode("花材统计报表.xls", "UTF-8"));
+ response.addHeader("Access-Control-Expose-Headers", "filename");
+ excelExportUtil.export();
+ } catch (Exception e) {
+ log.error(e.getMessage(), e);
+ }
}
}
--
Gitblit v1.9.3