mybatis-plus树递归结构

public interface MaterialCategoryMapper extends BaseMapper {
    List queryAll(String code, String name, String operationName, String systemDeptId);
}

    
        
        
        
        
        
        
        
        
        
        
        
        
        
    
    
        select *
        from T_DF_MATERIAL_CATEGORY
        WHERE F_VC_PARENT_ID IS NULL
        
            AND F_VC_CODE LIKE CONCAT( '%',#{code}, '%')
        
        
            AND F_VC_NAME LIKE CONCAT( '%',#{name}, '%')
        
        
            AND F_VC_OPERATION_NAME LIKE CONCAT( '%',#{operationName}, '%')
        
        
            AND F_VC_SYSTEM_DEPT_ID LIKE CONCAT(#{systemDeptId}, '%')
        
        ORDER BY F_DT_DATA_CREATE_TIME DESC
    
    
    
    select *
    from T_DF_MATERIAL_CATEGORY
    WHERE F_VC_PARENT_ID = #{id}
    ORDER BY F_DT_DATA_CREATE_TIME DESC

package cn.microvideo.yingyun.jsxtzhdd.services.emergencysupplies.entity;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;
import lombok.EqualsAndHashCode;
import java.time.LocalDateTime;
import java.util.List;
@Data
@EqualsAndHashCode(callSuper = false)
@TableName("T_DF_MATERIAL_CATEGORY")
public class MaterialCategoryDto {
    /**
     * 二级类目列表
     */
    @TableField(exist = false)
    List materialCategoryList;
    /**
     * 主键Id
     */
    @TableId(value = "F_VC_ID")
    private String id;
    /**
     * 数据创建时间
     */
    @TableField(value = "F_DT_DATA_CREATE_TIME")
    private LocalDateTime dataCreateTime;
    /**
     * 数据修改时间
     */
    @TableField(value = "F_DT_DATA_UPDATE_TIME")
    private LocalDateTime dataUpdateTime;
    /**
     * 物资类型
     */
    @TableField("F_VC_MATERIAL_TYPE")
    private String materialType;
    /**
     * 编码
     */
    @TableField("F_VC_CODE")
    private String code;
    /**
     * 名称
     */
    @TableField("F_VC_NAME")
    private String name;
    /**
     * 父级id
     */
    @TableField("F_VC_PARENT_ID")
    private String parentId;
    /**
     * 用户id
     */
    @TableField("F_VC_OPERATION_ID")
    private String operationId;
    /**
     * 用户名称
     */
    @TableField("F_VC_OPERATION_NAME")
    private String operationName;
    /**
     * 挂靠物资数量
     */
    @TableField("F_INT_MATERIAL_NUM")
    private Integer materialNum;
    /**
     * 单位id
     */
    @TableField(value = "F_VC_SYSTEM_DEPT_ID")
    private String systemDeptId;
    /**
     * 单位名称
     */
    @TableField(value = "F_VC_SYSTEM_DEPT_NAME")
    private String systemDeptName;
    /**
     * 1:一级类目;2:二级类目
     */
    private Integer grade;
}