浪潮对接单点登录:配置信息调整9

zouyu

6 天以前 dcd4f41b63ac7a103b960062434dad13a3e419b7

浪潮对接单点登录:配置信息调整9

 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;
    }
}

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

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

}

 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 {

}

 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 é’ˆå¯¹è¡¨ã€vehicle_information_collection_review】的数据库操作Mapper
* @createDate 2026-01-06 19:50:48
* @Entity com.ruoyi.pojo.VehicleInformationCollectionReview
*/
@Mapper
public interface VehicleInformationCollectionReviewMapper extends BaseMapper<VehicleInformationCollectionReview> {

}





 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;
}

 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 é’ˆå¯¹è¡¨ã€vehicle_information_collection_review】的数据库操作Service
* @createDate 2026-01-06 19:50:48
*/
public interface VehicleInformationCollectionReviewService extends IService<VehicleInformationCollectionReview> {

    IPage<VehicleInformationCollectionReview> listPage(Page page, VehicleInformationCollectionReview vehicleInformationCollectionReview);

    long insert(VehicleInformationCollectionReview vehicleInformationCollectionReview);
}

 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 é’ˆå¯¹è¡¨ã€vehicle_information_collection_review】的数据库操作Service实现
* @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);
    }
}





 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

 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>