标准库树下检验项目修改供应商绑定备份修改

chenrui

2025-04-03 3d6da0d6465fa63cf8b214bf7371eab4949f5488

标准库树下检验项目修改供应商绑定备份修改

 basic-server/src/main/java/com/ruoyi/basic/controller/StandardProductListUpdateRecordController.java

@@ -32,8 +32,8 @@

    @ApiOperation(value = "标准树下修改记录分页查询")
    @GetMapping("/standardProductListRecordPage")
    public Result standardProductListRecordPage(Page page, StandardProductListUpdateRecord standardProductListUpdateRecord) {
        return Result.success(standardProductListUpdateRecordService.standardProductListRecordPage(page,standardProductListUpdateRecord));
    public Result standardProductListRecordPage(Page page, StandardProductListUpdateRecordDto standardProductListUpdateRecordDto) {
        return Result.success(standardProductListUpdateRecordService.standardProductListRecordPage(page,standardProductListUpdateRecordDto));
    }

    @ApiOperation(value = "标准树下检验项修改记录查询")

 basic-server/src/main/java/com/ruoyi/basic/controller/StandardTreeController.java

@@ -222,7 +222,7 @@
    @ApiOperation(value = "删除厂家要求值绑定")
    @DeleteMapping("/deleteProductSupplierAsk")
    public Result deleteProductSupplierAsk(Integer supplierAskId) {
        standardProductListSupplierAskService.removeById(supplierAskId);
        standardProductListSupplierAskService.deleteProductSupplierAsk(supplierAskId);
        return Result.success();
    }


 basic-server/src/main/java/com/ruoyi/basic/dto/StandardProductListUpdateRecordDto.java

@@ -15,7 +15,6 @@
 * æ ‡å‡†æ ‘下的检验项目修改记录
 *
 */
@TableName(value ="standard_product_list_update_record")
@Data
public class StandardProductListUpdateRecordDto extends StandardProductListUpdateRecord {

@@ -23,9 +22,9 @@
     * åˆ›å»ºç”¨æˆ·åç§°
     */
   private String createUserName;

    /**
     * ä¿®æ”¹ç”¨æˆ·åç§°
     */

   private String updateUserName;
}

 basic-server/src/main/java/com/ruoyi/basic/mapper/StandardProductListSupplierAskBackupRelMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,24 @@
package com.ruoyi.basic.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.basic.pojo.StandardProductListSupplierAskBackupRel;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface StandardProductListSupplierAskBackupRelMapper extends BaseMapper<StandardProductListSupplierAskBackupRel> {

    /**
     * æ ¹æ®æ ‡å‡†æ ‘下检验项id删除关联厂家备份数据
     * @param productIds
     * @return
     */
    int batchDeleteByProductIds(@Param("productIds") List<Long> productIds);

    /**
     * æ‰¹é‡æ’入关联厂家备份数据
     * @param list
     * @return
     */
    int batchInsertSupplierAskBackUpRel(@Param("list") List<StandardProductListSupplierAskBackupRel> list);
}

 basic-server/src/main/java/com/ruoyi/basic/mapper/StandardProductListSupplierAskMapper.java

@@ -3,6 +3,9 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.basic.pojo.StandardProductListSupplierAsk;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * æ£€éªŒé¡¹ç›®åŽ‚家密度绑定表
@@ -13,6 +16,7 @@
@Mapper
public interface StandardProductListSupplierAskMapper extends BaseMapper<StandardProductListSupplierAsk> {

    int batchInsertSupplierAsk(@Param("list") List<StandardProductListSupplierAsk> list);

}


 basic-server/src/main/java/com/ruoyi/basic/mapper/StandardProductListUpdateRecordMapper.java

@@ -20,10 +20,10 @@
     * æ ‡å‡†æ ‘下检验项修改记录分页查询
     *
     * @param page
     * @param ew
     * @param record
     * @return
     */
    IPage<StandardProductListUpdateRecordDto> standardProductListRecordPage(Page page, @Param("ew") QueryWrapper<StandardProductListUpdateRecord> ew);
    IPage<StandardProductListUpdateRecordDto> standardProductListRecordPage(Page page, @Param("record") StandardProductListUpdateRecordDto record);
}



 basic-server/src/main/java/com/ruoyi/basic/pojo/StandardProductList.java

@@ -221,5 +221,6 @@
    private String conductorType;

    @ApiModelProperty("审核状态 0 æœªæäº¤ 1 å®¡æ ¸ä¸­ 2 å®¡æ ¸é€šè¿‡ 3 å®¡æ ¸æœªé€šè¿‡")
    @TableField(updateStrategy = FieldStrategy.IGNORED)
    private String checkStatus;
}

 basic-server/src/main/java/com/ruoyi/basic/pojo/StandardProductListSupplierAskBackupRel.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,58 @@
package com.ruoyi.basic.pojo;

import com.baomidou.mybatisplus.annotation.*;
import com.fasterxml.jackson.annotation.JsonFormat;
import com.fasterxml.jackson.databind.annotation.JsonSerialize;
import com.fasterxml.jackson.databind.ser.std.ToStringSerializer;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.time.LocalDateTime;

/**
 * æ£€éªŒé¡¹ç›®åŽ‚家密度绑定表
 *
 * @author zhuo
 * @since 2024-09-23
 */
@TableName(value ="standard_product_list_supplier_ask_backup_rel")
@Data
public class StandardProductListSupplierAskBackupRel {

    @TableId(type = IdType.AUTO)
    private Integer supplierAskId;

    @JsonSerialize(using = ToStringSerializer.class)
    @ApiModelProperty("检验项目id")
    private Long productListId;

    @ApiModelProperty("厂家名称")
    private String supplierName;

    @ApiModelProperty("要求值")
    private String ask;

    @ApiModelProperty("要求描述")
    private String tell;

    @ApiModelProperty(value = "创建人id")
    @TableField(fill = FieldFill.INSERT)
    private Integer createUser;


    @ApiModelProperty(value = "修改人id")
    @TableField(fill = FieldFill.INSERT_UPDATE)
    private Integer updateUser;

    @ApiModelProperty(value = "创建时间")
    @TableField(fill = FieldFill.INSERT)
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private LocalDateTime createTime;

    @ApiModelProperty(value = "更新时间")
    @TableField(fill = FieldFill.INSERT_UPDATE)
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private LocalDateTime updateTime;

}


 basic-server/src/main/java/com/ruoyi/basic/service/StandardProductListSupplierAskService.java

@@ -19,5 +19,9 @@

    Integer updateProductSupplierAsk(StandardProductListSupplierAsk supplierAsk);

    void deleteProductSupplierAsk(Integer supplierAskId);

    void backupSupplierAsk(StandardProductListSupplierAsk supplierAsk);

}


 basic-server/src/main/java/com/ruoyi/basic/service/StandardProductListUpdateRecordService.java

@@ -25,10 +25,10 @@
    /**
     * æ ‡å‡†æ ‘下检验项修改记录分页查询
     * @param page
     * @param record
     * @param standardProductListUpdateRecordDto
     * @return
     */
    IPage<StandardProductListUpdateRecordDto> standardProductListRecordPage(Page page, StandardProductListUpdateRecord record);
    IPage<StandardProductListUpdateRecordDto> standardProductListRecordPage(Page page, StandardProductListUpdateRecordDto standardProductListUpdateRecordDto);

    /**
     * æ ‡å‡†æ ‘下检验项修改记录查询

 basic-server/src/main/java/com/ruoyi/basic/service/impl/StandardProductListServiceImpl.java

@@ -12,6 +12,7 @@
import com.ruoyi.basic.mapper.*;
import com.ruoyi.basic.pojo.*;
import com.ruoyi.basic.service.StandardMethodListService;
import com.ruoyi.basic.service.StandardProductListSupplierAskService;
import com.ruoyi.common.exception.base.BaseException;
import com.ruoyi.common.utils.QueryWrappers;
import com.ruoyi.common.utils.SecurityUtils;
@@ -68,6 +69,12 @@
    @Autowired
    private StandardProductListUpdateRecordRelMapper standardProductListUpdateRecordRelMapper;

    @Autowired
    private StandardProductListSupplierAskService standardProductListSupplierAskService;

    @Autowired
    private StandardProductListSupplierAskBackupRelMapper  standardProductListSupplierAskBackupRelMapper;


    @Override
    public int upStandardProductList(StandardProductList list) {
@@ -87,6 +94,10 @@
            BeanUtils.copyProperties(standardProductList, productListBackupRel);
            standardProductListBackupRelMapper.insert(productListBackupRel);
        }
        // å…³è”商家备份
        StandardProductListSupplierAsk standardProductListSupplierAsk = new StandardProductListSupplierAsk();
        standardProductListSupplierAsk.setProductListId(list.getId());
        standardProductListSupplierAskService.backupSupplierAsk(standardProductListSupplierAsk);
        // ä¿®æ”¹çŠ¶æ€
        list.setCheckStatus(StandardProductListChcekTypeEnums.WAIT_CHECK.getCode());
        return standardProductListMapper.updateById(list);
@@ -505,6 +516,10 @@
            BeanUtils.copyProperties(standardProductList, productListBackupRel);
            standardProductListBackupRelMapper.insert(productListBackupRel);
        }
        // å…³è”商家备份
        StandardProductListSupplierAsk standardProductListSupplierAsk = new StandardProductListSupplierAsk();
        standardProductListSupplierAsk.setProductListId(list.getId());
        standardProductListSupplierAskService.backupSupplierAsk(standardProductListSupplierAsk);
        // ä¿®æ”¹çŠ¶æ€
        list.setCheckStatus(StandardProductListChcekTypeEnums.WAIT_CHECK.getCode());
        standardProductListMapper.updateSection(list);
@@ -713,25 +728,41 @@
        }
        // å®¡æ ¸é€šè¿‡
        if(StandardProductListChcekTypeEnums.PASS_CHECK.getCode().equals(standardProductListUpdateRecord.getCheckStatus())){
            // åˆ é™¤å¤‡ä»½æ•°æ®
            standardProductListBackupRelMapper.deleteBatchIds(standardProductListIds);
            // ä¿®æ”¹çŠ¶æ€
            standardProductListMapper.updateProductListCheckStatus(standardProductListIds,StandardProductListChcekTypeEnums.PASS_CHECK.getCode());
        }
        // å®¡æ ¸æœªé€šè¿‡
        if(StandardProductListChcekTypeEnums.NO_PASS_CHECK.getCode().equals(standardProductListUpdateRecord.getCheckStatus())){
            // æŸ¥è¯¢æ‰€æœ‰çš„备份数据
            // æŸ¥è¯¢æ‰€æœ‰æ ‡å‡†æ ‘下的检验项目备份数据
            List<StandardProductListBackupRel> standardProductListBackupRelList = standardProductListBackupRelMapper.selectBatchIds(standardProductListIds);
            // å›žæ»šæ•°æ®
            // å›žæ»šæ ‡å‡†æ ‘下的检验项目数据
            for (StandardProductListBackupRel standardProductListBackupRel : standardProductListBackupRelList) {
                StandardProductList standardProductList = new StandardProductList();
                BeanUtils.copyProperties(standardProductListBackupRel, standardProductList);
                standardProductList.setCheckStatus("");
                standardProductListMapper.updateById(standardProductList);
            }
            // åˆ é™¤å¤‡ä»½æ•°æ®
            standardProductListBackupRelMapper.deleteBatchIds(standardProductListIds);
            // å›žæ»šæ£€éªŒé¡¹ç›®åŽ‚家密度绑定表数据
            QueryWrapper<StandardProductListSupplierAskBackupRel> supplierAskBackupRelQueryWrapper = new QueryWrapper<>();
            supplierAskBackupRelQueryWrapper.in("product_list_id",standardProductListIds);
            List<StandardProductListSupplierAskBackupRel> standardProductListSupplierAskBackupRelList = standardProductListSupplierAskBackupRelMapper.selectList(supplierAskBackupRelQueryWrapper);
            if(!CollectionUtils.isEmpty(standardProductListSupplierAskBackupRelList)){
                QueryWrapper<StandardProductListSupplierAsk> deleteWrapper = new QueryWrapper<>();
                deleteWrapper.in("product_list_id",standardProductListIds);
                standardProductListSupplierAskMapper.delete(deleteWrapper);
                ArrayList<StandardProductListSupplierAsk> supplierAskRollBackList = new ArrayList<>();
                for (StandardProductListSupplierAskBackupRel standardProductListSupplierAskBackupRel : standardProductListSupplierAskBackupRelList) {
                    StandardProductListSupplierAsk standardProductListSupplierAsk = new StandardProductListSupplierAsk();
                    BeanUtils.copyProperties(standardProductListSupplierAskBackupRel, standardProductListSupplierAsk);
                    supplierAskRollBackList.add(standardProductListSupplierAsk);
        }
                standardProductListSupplierAskMapper.batchInsertSupplierAsk(supplierAskRollBackList);
            }

        }
        // åˆ é™¤æ ‡å‡†æ ‘下的检验项目备份数据
        standardProductListBackupRelMapper.deleteBatchIds(standardProductListIds);
        // åˆ é™¤ç»‘定厂家备份数据
        standardProductListSupplierAskBackupRelMapper.batchDeleteByProductIds(standardProductListIds);
        standardProductListUpdateRecordMapper.updateById(standardProductListUpdateRecord);
    }


 basic-server/src/main/java/com/ruoyi/basic/service/impl/StandardProductListSupplierAskServiceImpl.java

@@ -1,13 +1,24 @@
package com.ruoyi.basic.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.basic.enums.StandardProductListChcekTypeEnums;
import com.ruoyi.basic.mapper.StandardProductListMapper;
import com.ruoyi.basic.mapper.StandardProductListSupplierAskBackupRelMapper;
import com.ruoyi.basic.pojo.StandardProductList;
import com.ruoyi.basic.pojo.StandardProductListSupplierAskBackupRel;
import com.ruoyi.common.exception.base.BaseException;
import com.ruoyi.basic.mapper.StandardProductListSupplierAskMapper;
import com.ruoyi.basic.pojo.StandardProductListSupplierAsk;
import com.ruoyi.basic.service.StandardProductListSupplierAskService;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.util.CollectionUtils;

import java.util.ArrayList;
import java.util.List;

/**
@@ -18,6 +29,12 @@
 */
@Service
public class StandardProductListSupplierAskServiceImpl extends ServiceImpl<StandardProductListSupplierAskMapper, StandardProductListSupplierAsk> implements StandardProductListSupplierAskService {

    @Autowired
    private StandardProductListSupplierAskBackupRelMapper standardProductListSupplierAskBackupRelMapper;

    @Autowired
    private StandardProductListMapper standardProductListMapper;

    /**
     * æŸ¥è¯¢åŽ‚家要求值绑定
@@ -39,10 +56,18 @@
     * @return
     */
    @Override
    @Transactional(rollbackFor = Exception.class)
    public Integer addProductSupplierAsk(StandardProductListSupplierAsk supplierAsk) {
        if (supplierAsk.getProductListId() == null) {
            throw new BaseException("缺少产品对象id");
        }
        // æ–°å¢žå‰å¤‡ä»½
        backupSupplierAsk(supplierAsk);
        // ä¿®æ”¹çŠ¶æ€ä¸ºå¾…提交
        StandardProductList standardProductList = new StandardProductList();
        standardProductList.setId(supplierAsk.getProductListId());
        standardProductList.setCheckStatus(StandardProductListChcekTypeEnums.WAIT_CHECK.getCode());
        standardProductListMapper.updateById(standardProductList);
        // æŸ¥è¯¢æ”¹åŽ‚家是否绑定过
        Long count = baseMapper.selectCount(Wrappers.<StandardProductListSupplierAsk>lambdaQuery()
                .eq(StandardProductListSupplierAsk::getProductListId, supplierAsk.getProductListId())
@@ -51,9 +76,6 @@
            throw new BaseException("该产品已绑定过该厂家");
        }
        baseMapper.insert(supplierAsk);
        //


        return supplierAsk.getSupplierAskId();
    }

@@ -63,10 +85,18 @@
     * @return
     */
    @Override
    @Transactional(rollbackFor = Exception.class)
    public Integer updateProductSupplierAsk(StandardProductListSupplierAsk supplierAsk) {
        if (supplierAsk.getProductListId() == null) {
            throw new BaseException("缺少检验项id");
        }
        // ä¿®æ”¹å‰å¤‡ä»½
        backupSupplierAsk(supplierAsk);
        // ä¿®æ”¹çŠ¶æ€ä¸ºå¾…提交
        StandardProductList standardProductList = new StandardProductList();
        standardProductList.setId(supplierAsk.getProductListId());
        standardProductList.setCheckStatus(StandardProductListChcekTypeEnums.WAIT_CHECK.getCode());
        standardProductListMapper.updateById(standardProductList);
        // æŸ¥è¯¢æ”¹åŽ‚家是否绑定过
        Long count = baseMapper.selectCount(Wrappers.<StandardProductListSupplierAsk>lambdaQuery()
                .ne(StandardProductListSupplierAsk::getSupplierAskId, supplierAsk.getSupplierAskId())
@@ -78,5 +108,47 @@
        baseMapper.updateById(supplierAsk);
        return supplierAsk.getSupplierAskId();
    }

    @Override
    @Transactional(rollbackFor = Exception.class)
    public void deleteProductSupplierAsk(Integer supplierAskId) {
        StandardProductListSupplierAsk supplierAsk = baseMapper.selectById(supplierAskId);
        // åˆ é™¤å‰å¤‡ä»½
        backupSupplierAsk(supplierAsk);
        // ä¿®æ”¹çŠ¶æ€ä¸ºå¾…提交
        StandardProductList standardProductList = new StandardProductList();
        standardProductList.setId(supplierAsk.getProductListId());
        standardProductList.setCheckStatus(StandardProductListChcekTypeEnums.WAIT_CHECK.getCode());
        standardProductListMapper.updateById(standardProductList);
        baseMapper.deleteById(supplierAskId);
    }

    /**
     * æ£€éªŒé¡¹ç›®åŽ‚家密度绑定备份表表备份
     *
     * @param supplierAsk
     */
    @Override
    public void backupSupplierAsk(StandardProductListSupplierAsk supplierAsk) {
        // æŸ¥è¯¢å¤‡ä»½æ•°æ®æ˜¯å¦å­˜åœ¨ï¼Œå¦‚果有不做备份
        QueryWrapper<StandardProductListSupplierAskBackupRel> backupQueryWrapper = new QueryWrapper<>();
        backupQueryWrapper.eq("product_list_id", supplierAsk.getProductListId());
        List<StandardProductListSupplierAskBackupRel> standardProductListSupplierAskBackupRels = standardProductListSupplierAskBackupRelMapper.selectList(backupQueryWrapper);
        // æŸ¥è¯¢åŽŸæ•°æ®è¿›è¡Œå¤‡ä»½
        if(CollectionUtils.isEmpty(standardProductListSupplierAskBackupRels)){
            QueryWrapper<StandardProductListSupplierAsk> queryWrapper = new QueryWrapper<>();
            queryWrapper.eq("product_list_id", supplierAsk.getProductListId());
            List<StandardProductListSupplierAsk> standardProductListSupplierAskList = baseMapper.selectList(queryWrapper);
            List<StandardProductListSupplierAskBackupRel> supplierAskBackupRelInsertList = new ArrayList<>();
            for (StandardProductListSupplierAsk standardProductListSupplierAsk : standardProductListSupplierAskList) {
                StandardProductListSupplierAskBackupRel standardProductListSupplierAskBackupRel = new StandardProductListSupplierAskBackupRel();
                BeanUtils.copyProperties(standardProductListSupplierAsk, standardProductListSupplierAskBackupRel);
                supplierAskBackupRelInsertList.add(standardProductListSupplierAskBackupRel);
            }
            if(!CollectionUtils.isEmpty(supplierAskBackupRelInsertList)){
                standardProductListSupplierAskBackupRelMapper.batchInsertSupplierAskBackUpRel(supplierAskBackupRelInsertList);
            }
        }
    }
}


 basic-server/src/main/java/com/ruoyi/basic/service/impl/StandardProductListUpdateRecordServiceImpl.java

@@ -65,8 +65,8 @@
     * @return
     */
    @Override
    public IPage<StandardProductListUpdateRecordDto> standardProductListRecordPage(Page page, StandardProductListUpdateRecord record) {
        return standardProductListUpdateRecordMapper.standardProductListRecordPage(page,QueryWrappers.queryWrappers(record));
    public IPage<StandardProductListUpdateRecordDto> standardProductListRecordPage(Page page, StandardProductListUpdateRecordDto record) {
        return standardProductListUpdateRecordMapper.standardProductListRecordPage(page,record);
    }

    /**

 basic-server/src/main/resources/mapper/StandardProductListSupplierAskBackupRelMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,39 @@
<?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.basic.mapper.StandardProductListSupplierAskBackupRelMapper">

    <delete id="batchDeleteByProductIds">
        delete from standard_product_list_supplier_ask_backup_rel
        where product_list_id in
        <foreach collection="productIds" open="(" close=")" separator="," item="item">
            #{item}
        </foreach>
    </delete>

    <insert id="batchInsertSupplierAskBackUpRel">
        INSERT INTO standard_product_list_supplier_ask_backup_rel (
            supplier_ask_id,
            product_list_id,
            supplier_name,
            ask,
            tell,
            create_user,
            update_user,
            create_time,
            update_time
        )values
        <foreach collection="list" item="item" separator=",">
            (
            #{item.supplierAskId},
            #{item.productListId},
            #{item.supplierName},
            #{item.ask},
            #{item.tell},
            #{item.createUser},
            #{item.updateUser},
            #{item.createTime},
            #{item.updateTime}
            )
        </foreach>
    </insert>
</mapper>

 basic-server/src/main/resources/mapper/StandardProductListSupplierAskMapper.xml

@@ -2,4 +2,30 @@
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.ruoyi.basic.mapper.StandardProductListSupplierAskMapper">

    <insert id="batchInsertSupplierAsk">
        INSERT INTO standard_product_list_supplier_ask (
            supplier_ask_id,
            product_list_id,
            supplier_name,
            ask,
            tell,
            create_user,
            update_user,
            create_time,
            update_time
        )values
        <foreach collection="list" item="item" separator=",">
            (
            #{item.supplierAskId},
            #{item.productListId},
            #{item.supplierName},
            #{item.ask},
            #{item.tell},
            #{item.createUser},
            #{item.updateUser},
            #{item.createTime},
            #{item.updateTime}
            )
        </foreach>
    </insert>
</mapper>

 basic-server/src/main/resources/mapper/StandardProductListUpdateRecordMapper.xml

@@ -5,12 +5,16 @@
<mapper namespace="com.ruoyi.basic.mapper.StandardProductListUpdateRecordMapper">
    <select id="standardProductListRecordPage" resultType="com.ruoyi.basic.dto.StandardProductListUpdateRecordDto">
        SELECT *,
        ( SELECT NAME FROM `user` WHERE id = create_user ) AS createUserName,
        ( SELECT NAME FROM `user` WHERE id = update_user ) AS updateUserName
               T2.name AS create_user_name,
               T3.name AS update_user_name
        FROM
        standard_product_list_update_record
        <if test="ew.customSqlSegment != null and ew.customSqlSegment != ''">
            ${ew.customSqlSegment}
            standard_product_list_update_record T1
        LEFT JOIN user T2 ON T1.create_user = T2.id
        LEFT JOIN user T3 ON T1.update_user = T3.id
        <where>
            <if test="record.createUserName != null and record.createUserName != ''">
                T2.name like concat('%',#{record.createUserName},'%')
        </if>
        </where>
    </select>
</mapper>