# application.yml
mybatis-plus:
  global-config:
    db-config:
      logic-delete-field: deleted  # 全局邏輯刪除字段名
      logic-delete-value: 1        # 邏輯已刪除值（默認(rèn)為1）
      logic-not-delete-value: 0    # 邏輯未刪除值（默認(rèn)為0）

import com.baomidou.mybatisplus.annotation.TableLogic;
import com.baomidou.mybatisplus.annotation.TableName;
@Data
@TableName("user")
public class User {
    private Long id;
    private String name;
    @TableLogic(value = "0", delval = "1")
    private Integer deleted;
}
@Data
@TableName("product")
public class Product {
    private Long id;
    private String productName;
    @TableLogic(value = "false", delval = "true")
    private Boolean isDeleted;
}

// 1. 查詢時(shí)忽略邏輯刪除條件
List<User> users = userMapper.selectList(
    Wrappers.<User>lambdaQuery()
        .apply("deleted = 1 or deleted = 0")  // 自定義條件覆蓋自動(dòng)添加的條件
);
// 2. 使用自定義SQL完全控制
@Select("SELECT * FROM user WHERE id = #{id}")
User selectByIdIgnoreLogic(@Param("id") Long id);
// 3. 鏈?zhǔn)秸{(diào)用中的特殊處理
userMapper.selectList(
    new QueryWrapper<User>()
        .eq("status", 1)
        .and(wrapper -> wrapper.eq("deleted", 0).or().isNull("deleted"))
);

// 1. 配置類中自定義邏輯刪除處理器
@Configuration
public class MybatisPlusConfig {
    @Bean
    public ISqlInjector sqlInjector() {
        return new LogicSqlInjector() {
            @Override
            protected String getLogicDeleteSql(TableInfo tableInfo, boolean withWhere) {
                // 自定義邏輯刪除SQL生成邏輯
                String logicDeleteField = tableInfo.getLogicDeleteField();
                return "UPDATE " + tableInfo.getTableName() + 
                       " SET " + logicDeleteField + " = #{et." + logicDeleteField + "}" +
                       (withWhere ? " WHERE " + tableInfo.getKeyColumn() + "=#{et." + tableInfo.getKeyProperty() + "}" : "");
            }
        };
    }
}
// 2. 使用@SqlParser注解控制過濾
@SqlParser(filter = true)  // 過濾邏輯刪除數(shù)據(jù)
public List<User> selectActiveUsers();
@SqlParser(filter = false) // 不過濾邏輯刪除數(shù)據(jù)
public List<User> selectAllUsers();

// 1. 多租戶配置類
@Configuration
public class TenantConfig {
    @Bean
    public TenantLineHandler tenantLineHandler() {
        return new TenantLineHandler() {
            @Override
            public String getTenantIdColumn() {
                return "tenant_id";
            }
            @Override
            public Expression getTenantId() {
                return new LongValue(UserContext.getCurrentTenantId());
            }
            @Override
            public boolean ignoreTable(String tableName) {
                // 忽略不需要多租戶的表
                return "system_config".equals(tableName);
            }
        };
    }
}
// 2. 實(shí)體類同時(shí)支持多租戶和邏輯刪除
@Data
@TableName("order")
public class Order {
    private Long id;
    private String orderNo;
    @TableField(fill = FieldFill.INSERT)  // 自動(dòng)填充租戶ID
    private Long tenantId;
    @TableLogic
    private Integer deleted;
}
// 3. 查詢時(shí)自動(dòng)添加租戶和邏輯刪除條件
List<Order> orders = orderMapper.selectList(
    Wrappers.<Order>lambdaQuery()
        .eq(Order::getStatus, 1)
        // 會(huì)自動(dòng)添加：AND tenant_id = 當(dāng)前租戶ID AND deleted = 0
);

// 事務(wù)中處理邏輯刪除
@Transactional
public void deleteUserWithRelatedData(Long userId) {
    // 刪除用戶
    userMapper.deleteById(userId);
    // 同時(shí)處理關(guān)聯(lián)數(shù)據(jù)
    userRoleMapper.deleteByUserId(userId);
    // 記錄操作日志
    logService.saveDeleteLog(userId);
}