From 06e4e5ed216062b28f2a2f05f3e4a5e538d41d53 Mon Sep 17 00:00:00 2001
From: lige <bestlige@outlook.com>
Date: 星期五, 15 十二月 2023 18:36:41 +0800
Subject: [PATCH] 套餐价重复项
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjPackageMapper.java | 2 +-
ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjPackageController.java | 8 ++++++++
2 files changed, 9 insertions(+), 1 deletions(-)
diff --git a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjPackageController.java b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjPackageController.java
index 969365e..0ea17ea 100644
--- a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjPackageController.java
+++ b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjPackageController.java
@@ -308,6 +308,14 @@
}
tjpp.setProId(tjProject.getProId());
tjpp.setPacId(tjPackage.getPacId());
+ //鍒ゆ柇褰撳墠濂楅涓嬫湁娌℃湁杩欎釜椤圭洰 鏈夌殑璇濊烦杩囨坊鍔�
+ LambdaQueryWrapper<TjPackageProject> wqq=new LambdaQueryWrapper<>();
+ wqq.eq(TjPackageProject::getPacId,tjPackage.getPacId());
+ wqq.eq(TjPackageProject::getProId,tjProject.getProId());
+ final TjPackageProject one = ppservice.getOne(wqq);
+ if (one!=null){
+ continue;
+ }
ppservice.save(tjpp);
if (null != tjProject.getPriceNow()) {
money = money.add(tjProject.getPriceNow());
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjPackageMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjPackageMapper.java
index 9a0d458..867d132 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjPackageMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjPackageMapper.java
@@ -94,7 +94,7 @@
"on b.pro_id=c.pro_id\n" +
"WHERE !locate(\"濂砛",a.pac_name) and !locate(\"瀛昞",a.pac_name) and !locate(\"濡嘰",a.pac_name) and !locate(\"浜",a.pac_name) and a.pac_status=0 AND a.deleted =0 and a.pac_name like concat('%',#{name},'%')\n" +
"GROUP BY a.pac_id\n" +
- "ORDER BY a.sort DESC;}")
+ "ORDER BY a.sort DESC;\n")
List<TjPackage> getPacListBySqlAndMan(String pacName);
@Select("SELECT a.pac_id,a.pac_name,a.price,GROUP_CONCAT(distinct c.pro_name SEPARATOR ',') AS allProName\n" +
--
Gitblit v1.8.0