From 5cc91e1b876a2a4509d68ce15e63802f2713ead8 Mon Sep 17 00:00:00 2001
From: xuhy <3313886187@qq.com>
Date: 星期一, 29 十二月 2025 14:55:17 +0800
Subject: [PATCH] 新增保险
---
ruoyi-system/src/main/java/com/ruoyi/system/query/TInsuranceQuery.java | 15 +
ruoyi-system/src/main/java/com/ruoyi/system/vo/TInsuranceVO.java | 10 +
ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TInsuranceController.java | 123 +++++++++++++++
ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TInsuranceOrderController.java | 20 ++
ruoyi-system/src/main/java/com/ruoyi/system/mapper/TInsuranceMapper.java | 29 +++
ruoyi-system/src/main/java/com/ruoyi/system/service/TInsuranceService.java | 40 +++++
ruoyi-system/src/main/resources/mapper/system/TInsuranceOrderMapper.xml | 36 ++++
ruoyi-system/src/main/java/com/ruoyi/system/model/TInsurance.java | 69 ++++++++
ruoyi-system/src/main/resources/mapper/system/TInsuranceMapper.xml | 47 +++--
ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TInsuranceServiceImpl.java | 58 +++++++
10 files changed, 425 insertions(+), 22 deletions(-)
diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TInsuranceController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TInsuranceController.java
new file mode 100644
index 0000000..cc49a9d
--- /dev/null
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TInsuranceController.java
@@ -0,0 +1,123 @@
+package com.ruoyi.web.controller.api;
+
+
+import com.baomidou.mybatisplus.core.toolkit.Wrappers;
+import com.ruoyi.common.annotation.Log;
+import com.ruoyi.common.basic.PageInfo;
+import com.ruoyi.common.core.domain.R;
+import com.ruoyi.common.enums.BusinessType;
+import com.ruoyi.framework.web.service.TokenService;
+import com.ruoyi.system.model.TInsurance;
+import com.ruoyi.system.query.TInsuranceQuery;
+import com.ruoyi.system.service.TInsuranceService;
+import com.ruoyi.system.vo.TInsuranceVO;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.validation.annotation.Validated;
+import org.springframework.web.bind.annotation.*;
+
+import java.util.List;
+
+/**
+ * <p>
+ * 保险费用 前端控制器
+ * </p>
+ *
+ * @author xiaochen
+ * @since 2025-12-29
+ */
+@Api(tags = "保险费用")
+@RestController
+@RequestMapping("/t-insurance")
+public class TInsuranceController {
+
+ private final TInsuranceService insuranceService;
+ private final TokenService tokenService;
+ @Autowired
+ public TInsuranceController(TInsuranceService insuranceService, TokenService tokenService) {
+ this.insuranceService = insuranceService;
+ this.tokenService = tokenService;
+ }
+
+ /**
+ * 获取保险管理管理列表
+ */
+ @ApiOperation(value = "获取保险管理分页列表")
+ @PostMapping(value = "/pageList")
+ public R<PageInfo<TInsuranceVO>> pageList(@RequestBody TInsuranceQuery query) {
+ return R.ok(insuranceService.pageList(query));
+ }
+
+ /**
+ * 获取保险管理管理列表
+ */
+ @ApiOperation(value = "获取保险管理列表")
+ @PostMapping(value = "/list")
+ public R<List<TInsurance>> list() {
+ return R.ok(insuranceService.list(Wrappers.lambdaQuery(TInsurance.class).orderByDesc(TInsurance::getCreateTime)));
+ }
+
+ /**
+ * 添加保险管理管理
+ */
+ @Log(title = "保险费用管理-新增保险管理", businessType = BusinessType.INSERT)
+ @ApiOperation(value = "添加保险管理")
+ @PostMapping(value = "/add")
+ public R<Boolean> add(@Validated @RequestBody TInsurance dto) {
+ if (insuranceService.isExit(dto)) {
+ return R.fail("保险标题已存在");
+ }
+ if (insuranceService.isOpen(dto)) {
+ return R.fail("已存在开启状态的保险");
+ }
+ return R.ok(insuranceService.save(dto));
+ }
+
+ /**
+ * 修改保险管理
+ */
+ @Log(title = "保险费用管理-修改保险管理", businessType = BusinessType.UPDATE)
+ @ApiOperation(value = "修改保险管理")
+ @PostMapping(value = "/update")
+ public R<Boolean> update(@Validated @RequestBody TInsurance dto) {
+ if (insuranceService.isExit(dto)) {
+ return R.fail("保险标题已存在");
+ }
+ if (insuranceService.isOpen(dto)) {
+ return R.fail("已存在开启状态的保险");
+ }
+ return R.ok(insuranceService.updateById(dto));
+ }
+
+ /**
+ * 查看保险管理详情
+ */
+ @ApiOperation(value = "查看保险管理详情")
+ @GetMapping(value = "/getDetailById")
+ public R<TInsurance> getDetailById(@RequestParam String id) {
+ return R.ok(insuranceService.getById(id));
+ }
+
+ /**
+ * 删除保险管理
+ */
+ @Log(title = "保险费用管理-删除保险管理", businessType = BusinessType.DELETE)
+ @ApiOperation(value = "删除保险管理")
+ @DeleteMapping(value = "/deleteById")
+ public R<Boolean> deleteById(@RequestParam String id) {
+ return R.ok(insuranceService.removeById(id));
+ }
+
+ /**
+ * 批量删除保险管理
+ */
+ @Log(title = "保险费用管理-删除保险管理", businessType = BusinessType.DELETE)
+ @ApiOperation(value = "批量删除保险管理")
+ @DeleteMapping(value = "/deleteByIds")
+ public R<Boolean> deleteByIds(@RequestBody List<String> ids) {
+ return R.ok(insuranceService.removeByIds(ids));
+ }
+
+}
+
diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TInsuranceOrderController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TInsuranceOrderController.java
new file mode 100644
index 0000000..8a03253
--- /dev/null
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TInsuranceOrderController.java
@@ -0,0 +1,20 @@
+package com.ruoyi.web.controller.api;
+
+
+import org.springframework.web.bind.annotation.RequestMapping;
+import org.springframework.web.bind.annotation.RestController;
+
+/**
+ * <p>
+ * 用户保险费 前端控制器
+ * </p>
+ *
+ * @author xiaochen
+ * @since 2025-12-29
+ */
+@RestController
+@RequestMapping("/t-insurance-order")
+public class TInsuranceOrderController {
+
+}
+
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TInsuranceMapper.java b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TInsuranceMapper.java
new file mode 100644
index 0000000..5362b27
--- /dev/null
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TInsuranceMapper.java
@@ -0,0 +1,29 @@
+package com.ruoyi.system.mapper;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.ruoyi.common.basic.PageInfo;
+import com.ruoyi.system.model.TInsurance;
+import com.ruoyi.system.query.TInsuranceQuery;
+import com.ruoyi.system.vo.TInsuranceVO;
+import org.apache.ibatis.annotations.Param;
+
+import java.util.List;
+
+/**
+ * <p>
+ * 保险费用 Mapper 接口
+ * </p>
+ *
+ * @author xiaochen
+ * @since 2025-12-29
+ */
+public interface TInsuranceMapper extends BaseMapper<TInsurance> {
+
+ /**
+ * 获取保险管理分页列表
+ * @param query
+ * @param pageInfo
+ * @return
+ */
+ List<TInsuranceVO> pageList(@Param("query") TInsuranceQuery query, @Param("pageInfo")PageInfo<TInsuranceVO> pageInfo);
+}
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/model/TInsurance.java b/ruoyi-system/src/main/java/com/ruoyi/system/model/TInsurance.java
new file mode 100644
index 0000000..406f54c
--- /dev/null
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/model/TInsurance.java
@@ -0,0 +1,69 @@
+package com.ruoyi.system.model;
+
+import com.baomidou.mybatisplus.annotation.*;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+import lombok.EqualsAndHashCode;
+
+import java.io.Serializable;
+import java.time.LocalDateTime;
+
+/**
+ * <p>
+ * 保险费用
+ * </p>
+ *
+ * @author xiaochen
+ * @since 2025-12-29
+ */
+@Data
+@EqualsAndHashCode(callSuper = false)
+@TableName("t_insurance")
+@ApiModel(value="TInsurance对象", description="保险费用")
+public class TInsurance implements Serializable {
+
+ private static final long serialVersionUID = 1L;
+
+ @TableId(value = "id", type = IdType.ASSIGN_ID)
+ private String id;
+
+ @ApiModelProperty(value = "标题")
+ @TableField("insurance_title")
+ private String insuranceTitle;
+
+ @ApiModelProperty(value = "费用")
+ @TableField("insurance_money")
+ private Double insuranceMoney;
+
+ @ApiModelProperty(value = "有效期")
+ @TableField("validity_time")
+ private String validityTime;
+
+ @ApiModelProperty(value = "状态 1=开启 2=关闭")
+ @TableField("status")
+ private Integer status;
+
+ @ApiModelProperty(value = "创建时间")
+ @TableField("create_time")
+ private LocalDateTime createTime;
+
+ @ApiModelProperty(value = "修改时间")
+ @TableField("update_time")
+ private LocalDateTime updateTime;
+
+ @ApiModelProperty(value = "创建人")
+ @TableField("create_by")
+ private String createBy;
+
+ @ApiModelProperty(value = "修改人")
+ @TableField("update_by")
+ private String updateBy;
+
+ @ApiModelProperty(value = "是否删除 0=否 1=是")
+ @TableField("disabled")
+ @TableLogic
+ private Integer disabled;
+
+
+}
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/query/TInsuranceQuery.java b/ruoyi-system/src/main/java/com/ruoyi/system/query/TInsuranceQuery.java
new file mode 100644
index 0000000..c46a3a0
--- /dev/null
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/query/TInsuranceQuery.java
@@ -0,0 +1,15 @@
+package com.ruoyi.system.query;
+
+import com.ruoyi.common.core.domain.model.TimeRangeQueryBody;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+@Data
+@ApiModel(value = "保险分页列表查询Query")
+public class TInsuranceQuery extends TimeRangeQueryBody {
+
+ @ApiModelProperty(value = "标题")
+ private String insuranceTitle;
+
+}
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/TInsuranceService.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/TInsuranceService.java
new file mode 100644
index 0000000..bba43fe
--- /dev/null
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/service/TInsuranceService.java
@@ -0,0 +1,40 @@
+package com.ruoyi.system.service;
+
+import com.baomidou.mybatisplus.extension.service.IService;
+import com.ruoyi.common.basic.PageInfo;
+import com.ruoyi.system.model.TInsurance;
+import com.ruoyi.system.query.TInsuranceQuery;
+import com.ruoyi.system.vo.TInsuranceVO;
+
+/**
+ * <p>
+ * 保险费用 服务类
+ * </p>
+ *
+ * @author xiaochen
+ * @since 2025-12-29
+ */
+public interface TInsuranceService extends IService<TInsurance> {
+
+ /**
+ * 判断保险标题是否已存在
+ * @param dto
+ * @return
+ */
+ boolean isExit(TInsurance dto);
+
+ /**
+ * 获取保险管理分页列表
+ * @param query
+ * @return
+ */
+ PageInfo<TInsuranceVO> pageList(TInsuranceQuery query);
+
+ /**
+ * 判断是否存在开启状态的保险
+ * @param dto
+ * @return
+ */
+ boolean isOpen(TInsurance dto);
+
+}
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TInsuranceServiceImpl.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TInsuranceServiceImpl.java
new file mode 100644
index 0000000..b1c45a1
--- /dev/null
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TInsuranceServiceImpl.java
@@ -0,0 +1,58 @@
+package com.ruoyi.system.service.impl;
+
+import com.baomidou.mybatisplus.core.toolkit.Wrappers;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.ruoyi.common.basic.PageInfo;
+import com.ruoyi.common.utils.StringUtils;
+import com.ruoyi.system.mapper.TInsuranceMapper;
+import com.ruoyi.system.model.THelpNeeds;
+import com.ruoyi.system.model.TInsurance;
+import com.ruoyi.system.model.TInsurance;
+import com.ruoyi.system.query.TInsuranceQuery;
+import com.ruoyi.system.service.TInsuranceService;
+import com.ruoyi.system.vo.TInsuranceVO;
+import org.springframework.stereotype.Service;
+
+import java.util.List;
+
+/**
+ * <p>
+ * 保险费用 服务实现类
+ * </p>
+ *
+ * @author xiaochen
+ * @since 2025-12-29
+ */
+@Service
+public class TInsuranceServiceImpl extends ServiceImpl<TInsuranceMapper, TInsurance> implements TInsuranceService {
+
+ @Override
+ public boolean isExit(TInsurance dto) {
+ if(StringUtils.isNotEmpty(dto.getId())){
+ // 修改
+ return this.count(Wrappers.lambdaQuery(TInsurance.class).ne(TInsurance::getId, dto.getId()).eq(TInsurance::getInsuranceTitle, dto.getInsuranceTitle())) > 0;
+ }else {
+ // 新增
+ return this.count(Wrappers.lambdaQuery(TInsurance.class).eq(TInsurance::getInsuranceTitle, dto.getInsuranceTitle())) > 0;
+ }
+ }
+
+ @Override
+ public PageInfo<TInsuranceVO> pageList(TInsuranceQuery query) {
+ PageInfo<TInsuranceVO> pageInfo = new PageInfo<>(query.getPageNum(), query.getPageSize());
+ List<TInsuranceVO> list = this.baseMapper.pageList(query,pageInfo);
+ pageInfo.setRecords( list);
+ return pageInfo;
+ }
+
+ @Override
+ public boolean isOpen(TInsurance dto) {
+ if(StringUtils.isNotEmpty(dto.getId())){
+ // 修改
+ return this.count(Wrappers.lambdaQuery(TInsurance.class).ne(TInsurance::getId, dto.getId()).eq(TInsurance::getStatus, 1)) > 0;
+ }else {
+ // 新增
+ return this.count(Wrappers.lambdaQuery(TInsurance.class).eq(TInsurance::getStatus, 1)) > 0;
+ }
+ }
+}
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/vo/TInsuranceVO.java b/ruoyi-system/src/main/java/com/ruoyi/system/vo/TInsuranceVO.java
new file mode 100644
index 0000000..d7362a8
--- /dev/null
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/vo/TInsuranceVO.java
@@ -0,0 +1,10 @@
+package com.ruoyi.system.vo;
+
+import com.ruoyi.system.model.TInsurance;
+import io.swagger.annotations.ApiModel;
+import lombok.Data;
+
+@Data
+@ApiModel(value = "保险返回信息TInsuranceVO")
+public class TInsuranceVO extends TInsurance {
+}
diff --git a/ruoyi-system/src/main/resources/mapper/system/TInsuranceMapper.xml b/ruoyi-system/src/main/resources/mapper/system/TInsuranceMapper.xml
index a734300..70daaa8 100644
--- a/ruoyi-system/src/main/resources/mapper/system/TInsuranceMapper.xml
+++ b/ruoyi-system/src/main/resources/mapper/system/TInsuranceMapper.xml
@@ -1,31 +1,14 @@
<?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.ruoyi.system.mapper.TInsuranceOrderMapper">
+<mapper namespace="com.ruoyi.system.mapper.TInsuranceMapper">
<!-- 通用查询映射结果 -->
- <resultMap id="BaseResultMap" type="com.ruoyi.system.model.TInsuranceOrder">
+ <resultMap id="BaseResultMap" type="com.ruoyi.system.model.TInsurance">
<id column="id" property="id" />
- <result column="app_user_id" property="appUserId" />
- <result column="name" property="name" />
- <result column="phone" property="phone" />
- <result column="id_card" property="idCard" />
- <result column="img" property="img" />
- <result column="pay_type" property="payType" />
- <result column="pay_no" property="payNo" />
- <result column="pay_money" property="payMoney" />
- <result column="pay_time" property="payTime" />
- <result column="transaction_id" property="transactionId" />
+ <result column="insurance_title" property="insuranceTitle" />
+ <result column="insurance_money" property="insuranceMoney" />
+ <result column="validity_time" property="validityTime" />
<result column="status" property="status" />
- <result column="refund_time" property="refundTime" />
- <result column="request_refund_time" property="requestRefundTime" />
- <result column="refund_money" property="refundMoney" />
- <result column="refund_reason" property="refundReason" />
- <result column="refund_reason_pictures" property="refundReasonPictures" />
- <result column="refund_number" property="refundNumber" />
- <result column="refund_transaction_id" property="refundTransactionId" />
- <result column="refund_status" property="refundStatus" />
- <result column="refund_voucher" property="refundVoucher" />
- <result column="reject_reason" property="rejectReason" />
<result column="create_time" property="createTime" />
<result column="update_time" property="updateTime" />
<result column="create_by" property="createBy" />
@@ -33,4 +16,24 @@
<result column="disabled" property="disabled" />
</resultMap>
+ <!-- 通用查询结果列 -->
+ <sql id="Base_Column_List">
+ id, insurance_title, insurance_money, validity_time, status, create_time, update_time, create_by, update_by, disabled
+ </sql>
+ <select id="pageList" resultType="com.ruoyi.system.vo.TInsuranceVO">
+ select id, insurance_title, insurance_money, validity_time, status, create_time, update_time, create_by, update_by, disabled
+ from t_insurance
+ <where>
+ <if test="query.insuranceTitle != null and query.insuranceTitle != ''">
+ AND insurance_title LIKE concat('%',#{query.insuranceTitle},'%')
+ </if>
+ <if test="query.startTime != null and query.startTime != '' and query.endTime != null and query.endTime != ''">
+ AND validity_time >= #{query.startTime}
+ AND validity_time <= #{query.endTime}
+ </if>
+ AND disabled = ${@com.ruoyi.common.enums.DisabledEnum@NO.getCode()}
+ </where>
+ ORDER BY create_time DESC
+ </select>
+
</mapper>
diff --git a/ruoyi-system/src/main/resources/mapper/system/TInsuranceOrderMapper.xml b/ruoyi-system/src/main/resources/mapper/system/TInsuranceOrderMapper.xml
new file mode 100644
index 0000000..a734300
--- /dev/null
+++ b/ruoyi-system/src/main/resources/mapper/system/TInsuranceOrderMapper.xml
@@ -0,0 +1,36 @@
+<?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.ruoyi.system.mapper.TInsuranceOrderMapper">
+
+ <!-- 通用查询映射结果 -->
+ <resultMap id="BaseResultMap" type="com.ruoyi.system.model.TInsuranceOrder">
+ <id column="id" property="id" />
+ <result column="app_user_id" property="appUserId" />
+ <result column="name" property="name" />
+ <result column="phone" property="phone" />
+ <result column="id_card" property="idCard" />
+ <result column="img" property="img" />
+ <result column="pay_type" property="payType" />
+ <result column="pay_no" property="payNo" />
+ <result column="pay_money" property="payMoney" />
+ <result column="pay_time" property="payTime" />
+ <result column="transaction_id" property="transactionId" />
+ <result column="status" property="status" />
+ <result column="refund_time" property="refundTime" />
+ <result column="request_refund_time" property="requestRefundTime" />
+ <result column="refund_money" property="refundMoney" />
+ <result column="refund_reason" property="refundReason" />
+ <result column="refund_reason_pictures" property="refundReasonPictures" />
+ <result column="refund_number" property="refundNumber" />
+ <result column="refund_transaction_id" property="refundTransactionId" />
+ <result column="refund_status" property="refundStatus" />
+ <result column="refund_voucher" property="refundVoucher" />
+ <result column="reject_reason" property="rejectReason" />
+ <result column="create_time" property="createTime" />
+ <result column="update_time" property="updateTime" />
+ <result column="create_by" property="createBy" />
+ <result column="update_by" property="updateBy" />
+ <result column="disabled" property="disabled" />
+ </resultMap>
+
+</mapper>
--
Gitblit v1.7.1