From 5d9a8ea21c22c8ddd522a1f992a2143012b77733 Mon Sep 17 00:00:00 2001
From: guoshilong <123456>
Date: Fri, 05 Aug 2022 14:37:40 +0800
Subject: [PATCH] 销售,出库,损耗记录按创建时间降序排序
---
src/main/java/org/springblade/modules/sale/mapper/SaleMapper.xml | 2 +-
src/main/java/org/springblade/modules/InventoryLoss/mapper/InventoryMapper.xml | 2 +-
src/main/java/org/springblade/modules/retrieval/mapper/RetrievalMapper.xml | 2 +-
3 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/src/main/java/org/springblade/modules/InventoryLoss/mapper/InventoryMapper.xml b/src/main/java/org/springblade/modules/InventoryLoss/mapper/InventoryMapper.xml
index 3a2a3d9..dcdc2d3 100644
--- a/src/main/java/org/springblade/modules/InventoryLoss/mapper/InventoryMapper.xml
+++ b/src/main/java/org/springblade/modules/InventoryLoss/mapper/InventoryMapper.xml
@@ -20,7 +20,7 @@
<if test="inventory.strainId !=null and inventory.strainId != '' ">
inventory.strain_id = #{inventory.strainId} AND
</if>
- bdb.code = "lossReason" AND inventory.is_deleted = 0
+ bdb.code = "lossReason" AND inventory.is_deleted = 0 ORDER BY inventory.create_time DESC
</select>
</mapper>
diff --git a/src/main/java/org/springblade/modules/retrieval/mapper/RetrievalMapper.xml b/src/main/java/org/springblade/modules/retrieval/mapper/RetrievalMapper.xml
index 93efdd2..9826336 100644
--- a/src/main/java/org/springblade/modules/retrieval/mapper/RetrievalMapper.xml
+++ b/src/main/java/org/springblade/modules/retrieval/mapper/RetrievalMapper.xml
@@ -44,7 +44,7 @@
<if test="retrieval.strainId !=null and retrieval.strainId != '' ">
retrieval.strain_id = #{retrieval.strainId} AND
</if>
- is_deleted = 0
+ is_deleted = 0 ORDER BY retrieval.create_time DESC
</select>
</mapper>
diff --git a/src/main/java/org/springblade/modules/sale/mapper/SaleMapper.xml b/src/main/java/org/springblade/modules/sale/mapper/SaleMapper.xml
index 11691b3..343ed91 100644
--- a/src/main/java/org/springblade/modules/sale/mapper/SaleMapper.xml
+++ b/src/main/java/org/springblade/modules/sale/mapper/SaleMapper.xml
@@ -47,7 +47,7 @@
<if test="sale.strainId !=null and sale.strainId != '' ">
sale.strain_id = #{sale.strainId} AND
</if>
- sale.is_deleted = 0
+ sale.is_deleted = 0 ORDER BY sale.create_time DESC
</select>
--
Gitblit v1.9.3