From dcd4f41b63ac7a103b960062434dad13a3e419b7 Mon Sep 17 00:00:00 2001
From: zouyu <2723363702@qq.com>
Date: 星期二, 06 一月 2026 20:36:31 +0800
Subject: [PATCH] 浪潮对接单点登录:配置信息调整9
---
src/main/java/com/ruoyi/vehicleInformationCollectionReview/controller/VehicleInformationCollectionController.java | 51 +++++++
src/main/java/com/ruoyi/common/QueryWrappers.java | 68 +++++++++
src/main/java/com/ruoyi/vehicleInformationCollectionReview/service/impl/VehicleInformationCollectionReviewServiceImpl.java | 34 ++++
src/main/java/com/ruoyi/vehicleInformationCollectionReview/mapper/VehicleInformationCollectionReviewMapper.java | 20 ++
src/main/java/com/ruoyi/vehicleInformationCollectionReview/service/VehicleInformationCollectionReviewService.java | 18 ++
src/main/resources/mapper/vehicleInformationCollectionReview/VehicleInformationCollectionReviewMapper.xml | 38 +++++
src/main/java/com/ruoyi/vehicleInformationCollectionReview/pojo/VehicleInformationCollectionReview.java | 116 ++++++++++++++++
src/main/java/com/ruoyi/tide/utils/TideUtils.java | 4
src/main/java/com/ruoyi/vehicleInformationCollectionReview/dto/VehicleInformationCollectionReviewDTO.java | 9 +
src/main/resources/application-tide.yml | 4
10 files changed, 358 insertions(+), 4 deletions(-)
diff --git a/src/main/java/com/ruoyi/common/QueryWrappers.java b/src/main/java/com/ruoyi/common/QueryWrappers.java
new file mode 100644
index 0000000..4f98173
--- /dev/null
+++ b/src/main/java/com/ruoyi/common/QueryWrappers.java
@@ -0,0 +1,68 @@
+package com.ruoyi.common;
+
+import cn.hutool.core.util.ObjectUtil;
+import cn.hutool.core.util.StrUtil;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.toolkit.Wrappers;
+import lombok.AllArgsConstructor;
+import org.springframework.stereotype.Component;
+
+import java.lang.reflect.Field;
+import java.time.LocalDateTime;
+import java.time.format.DateTimeFormatter;
+import java.util.ArrayList;
+import java.util.Arrays;
+import java.util.List;
+import java.util.Map;
+
+/*
+ * 鏉庢灄
+ * 鐢熸垚SQL璇彞*/
+
+@Component
+@AllArgsConstructor
+public class QueryWrappers<T> {
+
+ public static <T> QueryWrapper<T> queryWrappers(T entity) {
+ if (ObjectUtil.isEmpty(entity)) return null;
+ Class<?> aClass = entity.getClass();
+ QueryWrapper<T> wrapper = Wrappers.<T>query();
+ List<Field> fieldList = new ArrayList<>();
+ while (aClass != null) {
+ fieldList.addAll(new ArrayList<>(Arrays.asList(aClass.getDeclaredFields())));
+ aClass = aClass.getSuperclass();
+ }
+ for (Field field : fieldList) {
+ field.setAccessible(true);
+ Object value;
+ try {
+ value = field.get(entity);
+ } catch (IllegalAccessException e) {
+ e.printStackTrace();
+ throw new RuntimeException("鏌ヨ鏉′欢鐢熸垚閿欒");
+ }
+ if(value == null || value.equals("")){
+ continue;
+ }
+ /*boolean bool = field.isAnnotationPresent(TableField.class);
+ if (bool){
+ if(field.getAnnotation(TableField.class).exist()==false)continue;
+ }*/
+ if (!field.getName().equals("orderBy")) {
+ if(value.getClass()== LocalDateTime.class){
+ wrapper.like(StrUtil.toUnderlineCase(field.getName()), ((LocalDateTime) value).format(DateTimeFormatter.ofPattern("yyyy-MM-dd")));
+ }else if(value.getClass()== String.class){
+ wrapper.like(StrUtil.toUnderlineCase(field.getName()), value);
+ }else{
+ wrapper.eq(StrUtil.toUnderlineCase(field.getName()), value);
+ }
+ } else {
+ Map<String, String> map = (Map<String, String>) value;
+ if(map.get("order")!=null){
+ wrapper.orderBy(true, map.get("order").equals("asc"), StrUtil.toUnderlineCase(map.get("field")));
+ }
+ }
+ }
+ return wrapper;
+ }
+}
diff --git a/src/main/java/com/ruoyi/tide/utils/TideUtils.java b/src/main/java/com/ruoyi/tide/utils/TideUtils.java
index 3fec16d..2d27290 100644
--- a/src/main/java/com/ruoyi/tide/utils/TideUtils.java
+++ b/src/main/java/com/ruoyi/tide/utils/TideUtils.java
@@ -21,9 +21,9 @@
@Component
@Slf4j
public class TideUtils {
- private final static String appId = "1151162645026439168";
+ private final static String appId = "1205972857687900160";
- private final static String appSecret = "t1BsMDgwODIwMjUxMTUwMjc3NzMdNi";
+ private final static String appSecret = "MgzPMDYwMTIwMjYxNzQ2NDA3OTYGqt";
// 鍐呯綉鍦板潃
private final static String ip = "http://10.136.0.8:8083";
diff --git a/src/main/java/com/ruoyi/vehicleInformationCollectionReview/controller/VehicleInformationCollectionController.java b/src/main/java/com/ruoyi/vehicleInformationCollectionReview/controller/VehicleInformationCollectionController.java
new file mode 100644
index 0000000..f67804d
--- /dev/null
+++ b/src/main/java/com/ruoyi/vehicleInformationCollectionReview/controller/VehicleInformationCollectionController.java
@@ -0,0 +1,51 @@
+package com.ruoyi.vehicleInformationCollectionReview.controller;
+
+import com.baomidou.mybatisplus.core.toolkit.Wrappers;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.ruoyi.framework.web.domain.AjaxResult;
+import com.ruoyi.vehicleInformationCollectionReview.dto.VehicleInformationCollectionReviewDTO;
+import com.ruoyi.vehicleInformationCollectionReview.pojo.VehicleInformationCollectionReview;
+import com.ruoyi.vehicleInformationCollectionReview.service.VehicleInformationCollectionReviewService;
+import lombok.extern.slf4j.Slf4j;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.web.bind.annotation.*;
+
+import java.util.List;
+
+@Slf4j
+@RestController
+@RequestMapping("/environmentAccess")
+public class VehicleInformationCollectionController {
+
+ @Autowired
+ private VehicleInformationCollectionReviewService vehicleInformationCollectionReviewService;
+
+ // 鏌ヨ杞﹁締淇℃伅鍒嗛〉鍒楄〃
+ @GetMapping("/vehicleInfoPage")
+ public AjaxResult vehicleInfoPage(Page page, VehicleInformationCollectionReview vehicleInformationCollectionReview){
+ return AjaxResult.success(vehicleInformationCollectionReviewService.listPage(page,vehicleInformationCollectionReview));
+ }
+ // 鏂板杞﹁締淇℃伅
+ @PostMapping("/vehicleInfoAdd")
+ public AjaxResult vehicleInfoAdd(@RequestBody VehicleInformationCollectionReview vehicleInformationCollectionReview){
+ return AjaxResult.success(vehicleInformationCollectionReviewService.insert(vehicleInformationCollectionReview));
+ }
+ // 淇敼杞﹁締淇℃伅
+ @PutMapping("/vehicleInfoUpdate")
+ public AjaxResult updateRecord(VehicleInformationCollectionReview vehicleInformationCollectionReview){
+ return AjaxResult.success(vehicleInformationCollectionReviewService.updateById(vehicleInformationCollectionReview));
+ }
+ // 鍒犻櫎杞﹁締淇℃伅锛堟敮鎸佹壒閲忥級
+ @DeleteMapping("/vehicleInfoDelete")
+ public AjaxResult removeRecords(@RequestBody List<Long> ids){
+ return AjaxResult.success(vehicleInformationCollectionReviewService.removeBatchByIds(ids));
+ }
+ // 瀹℃牳杞﹁締淇℃伅
+ @PostMapping("/vehicleInfoReview")
+ public AjaxResult vehicleInfoReview(@RequestBody VehicleInformationCollectionReviewDTO vehicleInformationCollectionReviewDTO){
+ return AjaxResult.success(vehicleInformationCollectionReviewService.update(Wrappers.<VehicleInformationCollectionReview>lambdaUpdate()
+ .set(VehicleInformationCollectionReview::getReviewStatus,vehicleInformationCollectionReviewDTO.getReviewStatus())
+ .eq(VehicleInformationCollectionReview::getId,vehicleInformationCollectionReviewDTO.getId())));
+ }
+
+}
diff --git a/src/main/java/com/ruoyi/vehicleInformationCollectionReview/dto/VehicleInformationCollectionReviewDTO.java b/src/main/java/com/ruoyi/vehicleInformationCollectionReview/dto/VehicleInformationCollectionReviewDTO.java
new file mode 100644
index 0000000..233dc10
--- /dev/null
+++ b/src/main/java/com/ruoyi/vehicleInformationCollectionReview/dto/VehicleInformationCollectionReviewDTO.java
@@ -0,0 +1,9 @@
+package com.ruoyi.vehicleInformationCollectionReview.dto;
+
+import com.ruoyi.vehicleInformationCollectionReview.pojo.VehicleInformationCollectionReview;
+import lombok.Data;
+
+@Data
+public class VehicleInformationCollectionReviewDTO extends VehicleInformationCollectionReview {
+
+}
diff --git a/src/main/java/com/ruoyi/vehicleInformationCollectionReview/mapper/VehicleInformationCollectionReviewMapper.java b/src/main/java/com/ruoyi/vehicleInformationCollectionReview/mapper/VehicleInformationCollectionReviewMapper.java
new file mode 100644
index 0000000..e1b9a5a
--- /dev/null
+++ b/src/main/java/com/ruoyi/vehicleInformationCollectionReview/mapper/VehicleInformationCollectionReviewMapper.java
@@ -0,0 +1,20 @@
+package com.ruoyi.vehicleInformationCollectionReview.mapper;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.ruoyi.vehicleInformationCollectionReview.pojo.VehicleInformationCollectionReview;
+import org.apache.ibatis.annotations.Mapper;
+
+/**
+* @author 27233
+* @description 閽堝琛ㄣ�恦ehicle_information_collection_review銆戠殑鏁版嵁搴撴搷浣淢apper
+* @createDate 2026-01-06 19:50:48
+* @Entity com.ruoyi.pojo.VehicleInformationCollectionReview
+*/
+@Mapper
+public interface VehicleInformationCollectionReviewMapper extends BaseMapper<VehicleInformationCollectionReview> {
+
+}
+
+
+
+
diff --git a/src/main/java/com/ruoyi/vehicleInformationCollectionReview/pojo/VehicleInformationCollectionReview.java b/src/main/java/com/ruoyi/vehicleInformationCollectionReview/pojo/VehicleInformationCollectionReview.java
new file mode 100644
index 0000000..e319a5c
--- /dev/null
+++ b/src/main/java/com/ruoyi/vehicleInformationCollectionReview/pojo/VehicleInformationCollectionReview.java
@@ -0,0 +1,116 @@
+package com.ruoyi.vehicleInformationCollectionReview.pojo;
+
+import com.baomidou.mybatisplus.annotation.*;
+
+import java.time.LocalDateTime;
+import java.util.Date;
+import lombok.Data;
+
+/**
+ *
+ * @TableName vehicle_information_collection_review
+ */
+@TableName(value ="vehicle_information_collection_review")
+@Data
+public class VehicleInformationCollectionReview {
+ /**
+ * 涓婚敭id
+ */
+ @TableId(type = IdType.AUTO)
+ private Long id;
+
+ /**
+ * 杞︾墝鍙风爜
+ */
+ private String plateNo;
+
+ /**
+ * 鍙风墝棰滆壊
+ */
+ private String plateColor;
+
+ /**
+ * 杞﹁締绫诲瀷
+ */
+ private String carType;
+
+ /**
+ * 杞﹁締璇嗗埆浠ｇ爜((vin)
+ */
+ private String carVin;
+
+ /**
+ * 杞﹁締鍨嬪彿
+ */
+ private String carModel;
+
+ /**
+ * 鍙戝姩鏈哄瀷鍙�
+ */
+ private String engineModel;
+
+ /**
+ * 鍙戝姩鏈虹敓浜у巶
+ */
+ private String engineProductFactory;
+
+ /**
+ * 鍙戝姩鏈虹紪鍙�
+ */
+ private String engineNo;
+
+ /**
+ * 鎺掓斁鏍囧噯
+ */
+ private String emissionStandard;
+
+ /**
+ * 娉ㄥ唽鐧昏鏃堕棿
+ */
+ private Date registeDate;
+
+ /**
+ * 浣跨敤鎬ц川
+ */
+ private String natureOfUse;
+
+ /**
+ * 鐕冩补绫诲瀷
+ */
+ private String fuelType;
+
+ /**
+ * 瀹℃牳鐘舵��
+ */
+ private String reviewStatus;
+
+ /**
+ * 绉熸埛id
+ */
+ @TableField(fill = FieldFill.INSERT)
+ private Long tenantId;
+
+ /**
+ * 鍒涘缓浜�
+ */
+ @TableField(fill = FieldFill.INSERT)
+ private Integer createUser;
+
+ /**
+ * 鍒涘缓鏃堕棿
+ */
+ @TableField(fill = FieldFill.INSERT)
+ private LocalDateTime createTime;
+
+ /**
+ * 鏇存柊浜�
+ */
+ @TableField(fill = FieldFill.INSERT_UPDATE)
+ private Integer updateUser;
+
+ /**
+ * 鏇存柊鏃堕棿
+ */
+ @TableField(fill = FieldFill.INSERT_UPDATE)
+ private LocalDateTime updateTime;
+}
\ No newline at end of file
diff --git a/src/main/java/com/ruoyi/vehicleInformationCollectionReview/service/VehicleInformationCollectionReviewService.java b/src/main/java/com/ruoyi/vehicleInformationCollectionReview/service/VehicleInformationCollectionReviewService.java
new file mode 100644
index 0000000..d85fea2
--- /dev/null
+++ b/src/main/java/com/ruoyi/vehicleInformationCollectionReview/service/VehicleInformationCollectionReviewService.java
@@ -0,0 +1,18 @@
+package com.ruoyi.vehicleInformationCollectionReview.service;
+
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.baomidou.mybatisplus.extension.service.IService;
+import com.ruoyi.vehicleInformationCollectionReview.pojo.VehicleInformationCollectionReview;
+
+/**
+* @author 27233
+* @description 閽堝琛ㄣ�恦ehicle_information_collection_review銆戠殑鏁版嵁搴撴搷浣淪ervice
+* @createDate 2026-01-06 19:50:48
+*/
+public interface VehicleInformationCollectionReviewService extends IService<VehicleInformationCollectionReview> {
+
+ IPage<VehicleInformationCollectionReview> listPage(Page page, VehicleInformationCollectionReview vehicleInformationCollectionReview);
+
+ long insert(VehicleInformationCollectionReview vehicleInformationCollectionReview);
+}
diff --git a/src/main/java/com/ruoyi/vehicleInformationCollectionReview/service/impl/VehicleInformationCollectionReviewServiceImpl.java b/src/main/java/com/ruoyi/vehicleInformationCollectionReview/service/impl/VehicleInformationCollectionReviewServiceImpl.java
new file mode 100644
index 0000000..46caf29
--- /dev/null
+++ b/src/main/java/com/ruoyi/vehicleInformationCollectionReview/service/impl/VehicleInformationCollectionReviewServiceImpl.java
@@ -0,0 +1,34 @@
+package com.ruoyi.vehicleInformationCollectionReview.service.impl;
+
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.ruoyi.common.QueryWrappers;
+import com.ruoyi.vehicleInformationCollectionReview.mapper.VehicleInformationCollectionReviewMapper;
+import com.ruoyi.vehicleInformationCollectionReview.pojo.VehicleInformationCollectionReview;
+import com.ruoyi.vehicleInformationCollectionReview.service.VehicleInformationCollectionReviewService;
+import org.springframework.stereotype.Service;
+
+/**
+* @author 27233
+* @description 閽堝琛ㄣ�恦ehicle_information_collection_review銆戠殑鏁版嵁搴撴搷浣淪ervice瀹炵幇
+* @createDate 2026-01-06 19:50:48
+*/
+@Service
+public class VehicleInformationCollectionReviewServiceImpl extends ServiceImpl<VehicleInformationCollectionReviewMapper, VehicleInformationCollectionReview>
+ implements VehicleInformationCollectionReviewService{
+
+ @Override
+ public IPage<VehicleInformationCollectionReview> listPage(Page page, VehicleInformationCollectionReview vehicleInformationCollectionReview) {
+ return baseMapper.selectPage(page, QueryWrappers.queryWrappers(vehicleInformationCollectionReview));
+ }
+
+ @Override
+ public long insert(VehicleInformationCollectionReview vehicleInformationCollectionReview) {
+ return baseMapper.insert(vehicleInformationCollectionReview);
+ }
+}
+
+
+
+
diff --git a/src/main/resources/application-tide.yml b/src/main/resources/application-tide.yml
index 27e2537..0127df1 100644
--- a/src/main/resources/application-tide.yml
+++ b/src/main/resources/application-tide.yml
@@ -62,7 +62,7 @@
druid:
# 涓诲簱鏁版嵁婧�
master:
- url: jdbc:mysql://10.136.12.71:3306/mis_ruoyi?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
+ url: jdbc:mysql://127.0.0.1:3306/mis-ruoyi?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
username: root
password: zttZTT123!
# 浠庡簱鏁版嵁婧�
@@ -142,7 +142,7 @@
database: 0
# 瀵嗙爜
password: zttZTT123!
-# password:
+# password: 123456
# 杩炴帴瓒呮椂鏃堕棿
timeout: 10s
diff --git a/src/main/resources/mapper/vehicleInformationCollectionReview/VehicleInformationCollectionReviewMapper.xml b/src/main/resources/mapper/vehicleInformationCollectionReview/VehicleInformationCollectionReviewMapper.xml
new file mode 100644
index 0000000..7478146
--- /dev/null
+++ b/src/main/resources/mapper/vehicleInformationCollectionReview/VehicleInformationCollectionReviewMapper.xml
@@ -0,0 +1,38 @@
+<?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.vehicleInformationCollectionReview.mapper.VehicleInformationCollectionReviewMapper">
+
+ <resultMap id="BaseResultMap" type="com.ruoyi.vehicleInformationCollectionReview.pojo.VehicleInformationCollectionReview">
+ <id property="id" column="id" jdbcType="BIGINT"/>
+ <result property="plateNo" column="plate_no" jdbcType="VARCHAR"/>
+ <result property="plateColor" column="plate_color" jdbcType="VARCHAR"/>
+ <result property="carType" column="car_type" jdbcType="VARCHAR"/>
+ <result property="carVin" column="car_vin" jdbcType="VARCHAR"/>
+ <result property="carModel" column="car_model" jdbcType="VARCHAR"/>
+ <result property="engineModel" column="engine_model" jdbcType="VARCHAR"/>
+ <result property="engineProductFactory" column="engine_product_factory" jdbcType="VARCHAR"/>
+ <result property="engineNo" column="engine_no" jdbcType="VARCHAR"/>
+ <result property="emissionStandard" column="emission_standard" jdbcType="VARCHAR"/>
+ <result property="registeDate" column="registe_date" jdbcType="TIMESTAMP"/>
+ <result property="natureOfUse" column="nature_of_use" jdbcType="VARCHAR"/>
+ <result property="fuelType" column="fuel_type" jdbcType="VARCHAR"/>
+ <result property="reviewStatus" column="review_status" jdbcType="VARCHAR"/>
+ <result property="tenantId" column="tenant_id" jdbcType="INTEGER"/>
+ <result property="createUser" column="create_user" jdbcType="VARCHAR"/>
+ <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/>
+ <result property="updateUser" column="update_user" jdbcType="VARCHAR"/>
+ <result property="updateTime" column="update_time" jdbcType="TIMESTAMP"/>
+ </resultMap>
+
+ <sql id="Base_Column_List">
+ id,plate_no,plate_color,
+ car_type,car_vin,car_model,
+ engine_model,engine_product_factory,engine_no,
+ emission_standard,registe_date,nature_of_use,
+ fuel_type,review_status,tenant_id,
+ create_user,create_time,update_user,
+ update_time
+ </sql>
+</mapper>
--
Gitblit v1.9.3