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 |    8 ++++++++
 1 files changed, 8 insertions(+), 0 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 1f7480a..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
@@ -32,6 +32,10 @@
 
     @Override
     public Page<FlowerMaterialVO> getFlowerMaterialPage(Page page, FlowerMaterialDTO dto) {
+        // 判断传入的排序字段是否在特定的字符串里面,如果不在则将排序字段设置未空
+        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);
 
@@ -49,6 +53,10 @@
 
     @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[]{

--
Gitblit v1.9.3