From 44f7e1fe5136eb0666bb599387406ea6b12e659b Mon Sep 17 00:00:00 2001
From: heheng <heheng@123456>
Date: 星期二, 21 一月 2025 16:34:14 +0800
Subject: [PATCH] 特种作业非煤缴费版本

---
 exam-system/src/main/java/com/gkhy/exam/pay/entity/NonCoalPay.java                         |    6 +++---
 exam-system/src/main/java/com/gkhy/exam/pay/service/impl/NonCoalPayServiceImpl.java        |    8 ++++----
 exam-system/src/main/java/com/gkhy/exam/pay/controller/NonCoalPayController.java           |    4 ++--
 exam-system/src/main/java/com/gkhy/exam/pay/service/impl/NonCoalPayStudentServiceImpl.java |   24 +++++++++++++++++++++---
 exam-system/src/main/resources/mapper/pay/NonCoalPayStudentMapper.xml                      |    1 +
 exam-system/src/main/resources/mapper/pay/NonCoalPayMapper.xml                             |   11 ++++++++---
 6 files changed, 39 insertions(+), 15 deletions(-)

diff --git a/exam-system/src/main/java/com/gkhy/exam/pay/controller/NonCoalPayController.java b/exam-system/src/main/java/com/gkhy/exam/pay/controller/NonCoalPayController.java
index 94161ca..ff1eae0 100644
--- a/exam-system/src/main/java/com/gkhy/exam/pay/controller/NonCoalPayController.java
+++ b/exam-system/src/main/java/com/gkhy/exam/pay/controller/NonCoalPayController.java
@@ -124,7 +124,7 @@
     /**
      * 删除非煤缴费管理
      */
-    @DeleteMapping("/id")
+    @DeleteMapping("/{id}")
     @ApiOperation(value = "删除非煤缴费管理")
     @ApiImplicitParam(name = "id", dataTypeClass = Long.class, value = "id", required = true)
     public AjaxResult remove(@PathVariable Long id) {
@@ -153,7 +153,7 @@
     /**
      * 删除【请填写功能名称】
      */
-    @DeleteMapping("/delNonCalStu/id")
+    @DeleteMapping("/delNonCalStu/{id}")
     @ApiOperation(value = "删除非煤缴费学员")
     @ApiImplicitParam(name = "id", dataTypeClass = Long.class, value = "id", required = true)
     public AjaxResult delNonCalStu(@PathVariable Long id) {
diff --git a/exam-system/src/main/java/com/gkhy/exam/pay/entity/NonCoalPay.java b/exam-system/src/main/java/com/gkhy/exam/pay/entity/NonCoalPay.java
index 3f112a9..2b51d04 100644
--- a/exam-system/src/main/java/com/gkhy/exam/pay/entity/NonCoalPay.java
+++ b/exam-system/src/main/java/com/gkhy/exam/pay/entity/NonCoalPay.java
@@ -61,7 +61,7 @@
      */
     @Excel(name = "缴费类型1初训理论2初训实操3初训理论与实操4复训理论")
     @NotNull(message = "缴费类型不能为空")
-    @ApiModelProperty("缴费类型")
+    @ApiModelProperty("缴费类型1初训理论2初训实操3初训理论与实操4复训理论")
     private Long payType;
 
     /**
@@ -85,7 +85,7 @@
      */
     @Excel(name = "季度1一季度2二季度3三季度4四季度")
     @NotNull(message = "季度不能为空")
-    @ApiModelProperty("季度")
+    @ApiModelProperty("季度1一季度2二季度3三季度4四季度")
     private Long quarter;
 
     /**
@@ -93,7 +93,7 @@
      */
     @Excel(name = "交款人类型1个人2团体")
     @NotNull(message = "交款人类型不能为空")
-    @ApiModelProperty("交款人类型")
+    @ApiModelProperty("交款人类型1个人2团体")
     private Integer payPersonType;
 
     /**
diff --git a/exam-system/src/main/java/com/gkhy/exam/pay/service/impl/NonCoalPayServiceImpl.java b/exam-system/src/main/java/com/gkhy/exam/pay/service/impl/NonCoalPayServiceImpl.java
index b8fb55f..f865384 100644
--- a/exam-system/src/main/java/com/gkhy/exam/pay/service/impl/NonCoalPayServiceImpl.java
+++ b/exam-system/src/main/java/com/gkhy/exam/pay/service/impl/NonCoalPayServiceImpl.java
@@ -161,7 +161,7 @@
                 .eq(NonCoalPay::getDistrictCode, nonCoalPay.getDistrictCode())
                 .eq(NonCoalPay::getBatchName, nonCoalPay.getBatchName())
                 .eq(NonCoalPay::getDelFlag, 0);
-        if (nonCoalPay.getId() == null) {
+        if (nonCoalPay.getId() != null) {
             lambdaQueryWrapper.ne(NonCoalPay::getId, nonCoalPay.getId());
         }
         Long l = baseMapper.selectCount(lambdaQueryWrapper);
@@ -208,7 +208,7 @@
     @Override
     @Transactional
     public int updateNonCoalPayTypeStatus(int payPersonType, Long id) {
-        NonCoalPay byId = getById(id);
+        NonCoalPay byId = nonCoalPayMapper.selectNonCoalPayById(id);
         if (byId == null) {
             throw new ServiceException("该数据不存在");
         }
@@ -246,8 +246,8 @@
      */
     @Override
     public int deleteNonCoalPayById(Long id) {
-        NonCoalPay byId = getById(id);
-        if (byId == null) {
+        NonCoalPay nonCoalPay = nonCoalPayMapper.selectNonCoalPayById(id);
+        if (nonCoalPay == null) {
             throw new ServiceException("该数据不存在");
         }
         //验证是否有学员已缴费
diff --git a/exam-system/src/main/java/com/gkhy/exam/pay/service/impl/NonCoalPayStudentServiceImpl.java b/exam-system/src/main/java/com/gkhy/exam/pay/service/impl/NonCoalPayStudentServiceImpl.java
index c7f231a..7a9f3c4 100644
--- a/exam-system/src/main/java/com/gkhy/exam/pay/service/impl/NonCoalPayStudentServiceImpl.java
+++ b/exam-system/src/main/java/com/gkhy/exam/pay/service/impl/NonCoalPayStudentServiceImpl.java
@@ -4,7 +4,9 @@
 import com.baomidou.mybatisplus.core.toolkit.Wrappers;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import com.gkhy.exam.pay.dto.req.NonCoalPayStudentReqDto;
+import com.gkhy.exam.pay.entity.NonCoalPay;
 import com.gkhy.exam.pay.entity.NonCoalPayStudent;
+import com.gkhy.exam.pay.mapper.NonCoalPayMapper;
 import com.gkhy.exam.pay.mapper.NonCoalPayStudentMapper;
 import com.gkhy.exam.pay.service.NonCoalPayStudentService;
 import com.ruoyi.common.exception.ServiceException;
@@ -30,6 +32,8 @@
 public class NonCoalPayStudentServiceImpl extends ServiceImpl<NonCoalPayStudentMapper, NonCoalPayStudent> implements NonCoalPayStudentService {
     @Resource
     private NonCoalPayStudentMapper nonCoalPayStudentMapper;
+    @Resource
+    private NonCoalPayMapper nonCoalPayMapper;
 
     /**
      * 查询【请填写功能名称】
@@ -63,6 +67,8 @@
     @Override
     public int insertNonCoalPayStudent(NonCoalPayStudent nonCoalPayStudent) {
         checkSameData(nonCoalPayStudent);
+        NonCoalPay nonCoalPay = checkNonCoalPay(nonCoalPayStudent.getNonCoalPayId());
+        nonCoalPayStudent.setPayType(nonCoalPay.getPayType());
         nonCoalPayStudent.setCreateBy(SecurityUtils.getUsername());
         return nonCoalPayStudentMapper.insertNonCoalPayStudent(nonCoalPayStudent);
     }
@@ -77,6 +83,7 @@
     public int updateNonCoalPayStudent(NonCoalPayStudent nonCoalPayStudent) {
         checkData(nonCoalPayStudent.getId());
         checkSameData(nonCoalPayStudent);
+        nonCoalPayStudent.setPayType(null);
         nonCoalPayStudent.setUpdateBy(SecurityUtils.getUsername());
         return nonCoalPayStudentMapper.updateNonCoalPayStudent(nonCoalPayStudent);
     }
@@ -111,7 +118,7 @@
                 .eq(NonCoalPayStudent::getNonCoalPayId, nonCoalPay.getNonCoalPayId())
                 .eq(NonCoalPayStudent::getIdCard, nonCoalPay.getIdCard())
                 .eq(NonCoalPayStudent::getDelFlag, 0);
-        if (nonCoalPay.getId() == null) {
+        if (nonCoalPay.getId() != null) {
             lambdaQueryWrapper.ne(NonCoalPayStudent::getId, nonCoalPay.getId());
         }
         Long l = baseMapper.selectCount(lambdaQueryWrapper);
@@ -161,7 +168,8 @@
         if (StringUtils.isNull(nonCoalPayStudents) || nonCoalPayStudents.isEmpty()) {
             throw new ServiceException("导入数据不能为空!");
         }
-
+        NonCoalPay nonCoalPay = checkNonCoalPay(nonCoalPayId);
+        Integer payPersonType = nonCoalPay.getPayPersonType();
         Set<String> collect = nonCoalPayStudents.stream()
                 .map(NonCoalPayStudent::getIdCard)
                 .collect(Collectors.toSet());
@@ -193,6 +201,7 @@
                 } else {
                     stu.setPayType(1L);
                     stu.setPayStatus(0L);
+                    stu.setPayType(payPersonType.longValue());
                     stu.setNonCoalPayId(nonCoalPayId);
                     save(stu);
                     successNum++;
@@ -217,7 +226,7 @@
     }
 
     private NonCoalPayStudent checkData(Long id) {
-        NonCoalPayStudent byId = getById(id);
+        NonCoalPayStudent byId = nonCoalPayStudentMapper.selectNonCoalPayStudentById(id);
         if (byId == null) {
             throw new RuntimeException("该数据不存在");
         }
@@ -229,4 +238,13 @@
         }
         return byId;
     }
+
+
+    private NonCoalPay checkNonCoalPay(Long nonCoalPayId) {
+        NonCoalPay nonCoalPay = nonCoalPayMapper.selectNonCoalPayById(nonCoalPayId);
+        if (nonCoalPay == null) {
+            throw new ServiceException("该主数据不存在");
+        }
+        return nonCoalPay;
+    }
 }
\ No newline at end of file
diff --git a/exam-system/src/main/resources/mapper/pay/NonCoalPayMapper.xml b/exam-system/src/main/resources/mapper/pay/NonCoalPayMapper.xml
index 1452f5f..0ec925f 100644
--- a/exam-system/src/main/resources/mapper/pay/NonCoalPayMapper.xml
+++ b/exam-system/src/main/resources/mapper/pay/NonCoalPayMapper.xml
@@ -117,7 +117,12 @@
         <if test="payCompanyName != null  and payCompanyName != ''">and a.pay_company_name like concat('%',
             #{payCompanyName}, '%')
         </if>
-
+        <if test="params.startTime != null and params.startTime != ''"><!-- 开始时间检索 -->
+            AND a.create_time &gt;= #{params.startTime}
+        </if>
+        <if test="params.endTime != null and params.endTime != ''"><!-- 结束时间检索 -->
+            AND a.create_time &lt;= #{params.endTime}
+        </if>
         <if test="payCompanyCard != null  and payCompanyCard != ''">and a.pay_company_card = #{payCompanyCard}</if>
         order by a.create_time desc
     </select>
@@ -245,10 +250,10 @@
         where id = #{id}
     </update>
 
-    <update id="deleteNonCoalPayById" parameterType="Long">
+    <update id="deleteNonCoalPayById">
         update non_coal_pay
         set del_flag  = 2,
-            update_by = #{updateBy} non_coal_pay
+            update_by = #{updateBy}
         where id = #{id}
     </update>
 
diff --git a/exam-system/src/main/resources/mapper/pay/NonCoalPayStudentMapper.xml b/exam-system/src/main/resources/mapper/pay/NonCoalPayStudentMapper.xml
index b609a23..d54cf36 100644
--- a/exam-system/src/main/resources/mapper/pay/NonCoalPayStudentMapper.xml
+++ b/exam-system/src/main/resources/mapper/pay/NonCoalPayStudentMapper.xml
@@ -101,6 +101,7 @@
         set pay_type  = 2,
             update_by = #{updateBy}
         where non_coal_pay_id = #{id}
+          and pay_status = 0
     </update>
     <update id="updateNonCoalPayStudent" parameterType="NonCoalPayStudent">
         update non_coal_pay_student

--
Gitblit v1.9.2