套餐价重复项

lige

2023-12-15 06e4e5ed216062b28f2a2f05f3e4a5e538d41d53

套餐价重复项

 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());

 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" +