From 10605ab6dd65845b7adf52ab319a4087813e6808 Mon Sep 17 00:00:00 2001
From: Pu Zhibing <393733352@qq.com>
Date: 星期三, 21 五月 2025 11:26:51 +0800
Subject: [PATCH] 修改bug

---
 UserOKTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/crossCity/server/impl/OrderCrossCityServiceImpl.java |    7 +
 UserOKTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/dao/UserActivityDiscount2Mapper.java          |   16 +++++
 UserOKTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/dao/mapping/UserActivityDiscount1Mapper.xml   |    2 
 UserOKTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/dao/mapping/UserActivityDiscount2Mapper.xml   |   13 ++++
 UserOKTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/model/UserActivityDiscount2.java              |  108 ++++++++++++++++++++++++++++++++++++
 5 files changed, 143 insertions(+), 3 deletions(-)

diff --git a/UserOKTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/crossCity/server/impl/OrderCrossCityServiceImpl.java b/UserOKTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/crossCity/server/impl/OrderCrossCityServiceImpl.java
index d10463d..31aafad 100644
--- a/UserOKTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/crossCity/server/impl/OrderCrossCityServiceImpl.java
+++ b/UserOKTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/crossCity/server/impl/OrderCrossCityServiceImpl.java
@@ -68,6 +68,9 @@
 
     @Resource
     private UserActivityDiscount1Mapper userActivityDiscount1Mapper;
+    
+    @Resource
+    private UserActivityDiscount2Mapper userActivityDiscount2Mapper;
 
     @Resource
     private SysIntegralMapper sysIntegralMapper;
@@ -302,9 +305,9 @@
         }
 
         //计算折扣
-        UserActivityDiscount1 query2 = userActivityDiscount1Mapper.query(orderCrossCity.getCompanyId());
+        UserActivityDiscount2 query2 = userActivityDiscount2Mapper.query(orderCrossCity.getLineId());
         if(null != query2){
-            Double special = query2.getSpecial();
+            Double special = query2.getDiscount();
             orderCrossCity.setDiscount(special);
             double v = new BigDecimal(orderMoney).multiply(new BigDecimal(special / 10)).setScale(2, BigDecimal.ROUND_HALF_EVEN).doubleValue();
             if(orderMoney.compareTo(v) > 0){
diff --git a/UserOKTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/dao/UserActivityDiscount2Mapper.java b/UserOKTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/dao/UserActivityDiscount2Mapper.java
new file mode 100644
index 0000000..1b4608b
--- /dev/null
+++ b/UserOKTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/dao/UserActivityDiscount2Mapper.java
@@ -0,0 +1,16 @@
+package com.stylefeng.guns.modular.system.dao;
+
+import com.baomidou.mybatisplus.mapper.BaseMapper;
+import com.stylefeng.guns.modular.system.model.UserActivityDiscount2;
+import org.apache.ibatis.annotations.Param;
+
+/**
+ * @author zhibing.pu
+ * @Date 2025/5/21 10:31
+ */
+public interface UserActivityDiscount2Mapper extends BaseMapper<UserActivityDiscount2>{
+	
+	
+	
+	UserActivityDiscount2 query(@Param("lineId") Integer lineId);
+}
diff --git a/UserOKTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/dao/mapping/UserActivityDiscount1Mapper.xml b/UserOKTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/dao/mapping/UserActivityDiscount1Mapper.xml
index 4c9e5e3..6dc7720 100644
--- a/UserOKTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/dao/mapping/UserActivityDiscount1Mapper.xml
+++ b/UserOKTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/dao/mapping/UserActivityDiscount1Mapper.xml
@@ -27,6 +27,6 @@
         a.`enable` as `enable`
         from t_user_activity_discount1 a
         left join t_user_activity b on (a.userActivityId = b.id)
-        where now() between a.startTime and a.endTime and b.`status` = 3 and b.companyId = #{companyId} order by b.insertTime desc limit 0,1
+        where now() between a.startTime and a.endTime and a.enable = 2 and b.`status` = 3 and b.companyId = #{companyId} order by b.insertTime desc limit 0,1
     </select>
 </mapper>
\ No newline at end of file
diff --git a/UserOKTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/dao/mapping/UserActivityDiscount2Mapper.xml b/UserOKTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/dao/mapping/UserActivityDiscount2Mapper.xml
new file mode 100644
index 0000000..80de543
--- /dev/null
+++ b/UserOKTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/dao/mapping/UserActivityDiscount2Mapper.xml
@@ -0,0 +1,13 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="com.stylefeng.guns.modular.system.dao.UserActivityDiscount2Mapper">
+
+
+	
+	
+	<select id="query" resultType="com.stylefeng.guns.modular.system.model.UserActivityDiscount2">
+		select a.* from t_user_activity_discount2 a
+		left join t_user_activity b on (a.userActivityId = b.id)
+		where a.lineId = #{lineId} and a.now() between startTime and endTime and a.enable = 2 and b.`status` = 3  order by b.insertTime desc limit 1
+	</select>
+</mapper>
\ No newline at end of file
diff --git a/UserOKTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/model/UserActivityDiscount2.java b/UserOKTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/model/UserActivityDiscount2.java
new file mode 100644
index 0000000..a437cb6
--- /dev/null
+++ b/UserOKTravel/guns-admin/src/main/java/com/stylefeng/guns/modular/system/model/UserActivityDiscount2.java
@@ -0,0 +1,108 @@
+package com.stylefeng.guns.modular.system.model;
+
+import com.baomidou.mybatisplus.annotations.TableField;
+import com.baomidou.mybatisplus.annotations.TableId;
+import com.baomidou.mybatisplus.annotations.TableName;
+import com.baomidou.mybatisplus.enums.IdType;
+
+import java.util.Date;
+
+/**
+ * 用户折扣活动
+ */
+@TableName("t_user_activity_discount2")
+public class UserActivityDiscount2 {
+    /**
+     * 主键
+     */
+    @TableId(value = "id", type = IdType.AUTO)
+    @TableField("id")
+    private Integer id;
+    /**
+     * 活动id
+     */
+    @TableField("userActivityId")
+    private Integer userActivityId;
+    /**
+     * 跨城线路id
+     */
+    @TableField("lineId")
+    private Integer lineId;
+    /**
+     * 折扣(8.5)
+     */
+    @TableField("discount")
+    private Double discount;
+    /**
+     * 活动有效开始时间
+     */
+    @TableField("startTime")
+    private Date startTime;
+    /**
+     * 活动有效结束时间
+     */
+    @TableField("endTime")
+    private Date endTime;
+    /**
+     * 是否启用(1=不启用,2=启用)
+     */
+    @TableField("enable")
+    private Integer enable;
+    
+    
+    public Integer getId() {
+        return id;
+    }
+    
+    public void setId(Integer id) {
+        this.id = id;
+    }
+    
+    public Integer getUserActivityId() {
+        return userActivityId;
+    }
+    
+    public void setUserActivityId(Integer userActivityId) {
+        this.userActivityId = userActivityId;
+    }
+    
+    public Integer getLineId() {
+        return lineId;
+    }
+    
+    public void setLineId(Integer lineId) {
+        this.lineId = lineId;
+    }
+    
+    public Double getDiscount() {
+        return discount;
+    }
+    
+    public void setDiscount(Double discount) {
+        this.discount = discount;
+    }
+    
+    public Date getStartTime() {
+        return startTime;
+    }
+    
+    public void setStartTime(Date startTime) {
+        this.startTime = startTime;
+    }
+    
+    public Date getEndTime() {
+        return endTime;
+    }
+    
+    public void setEndTime(Date endTime) {
+        this.endTime = endTime;
+    }
+    
+    public Integer getEnable() {
+        return enable;
+    }
+    
+    public void setEnable(Integer enable) {
+        this.enable = enable;
+    }
+}

--
Gitblit v1.7.1