From 9b015b51b72ba050b4c38a6ba79eb45b7065e67d Mon Sep 17 00:00:00 2001
From: Lius <Lius2225@163.com>
Date: 星期四, 25 七月 2024 10:11:52 +0800
Subject: [PATCH] 调整sql
---
lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/ProjectMaintenanceOrderMapper.java | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/ProjectMaintenanceOrderMapper.java b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/ProjectMaintenanceOrderMapper.java
index d577d77..acc448c 100644
--- a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/ProjectMaintenanceOrderMapper.java
+++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/ProjectMaintenanceOrderMapper.java
@@ -17,7 +17,7 @@
public interface ProjectMaintenanceOrderMapper extends BaseMapper<ProjectMaintenanceOrder> {
- @Select("select t1.id as value,t1.name as text, t1.name as title from mom_base_supplier t1 where t1.del_flag = '0' GROUP by t1.name ORDER BY t1.create_time desc")
+ @Select("select t1.id as value,t1.name as text, t1.name as title from mom_base_supplier t1 where t1.del_flag = '0' ORDER BY t1.create_time desc")
List<SupplierVo> getSupplier();
@Select("select t1.id as value,t1.name as text, t1.name as title from mom_base_team t1 where t1.del_flag = '0' ORDER BY t1.create_time desc")
--
Gitblit v1.9.3