| | |
|---|
| | | /** |
|---|
| | | * MES 维修工单 Mapper |
|---|
| | | * |
|---|
| | | * @author 芋道源码 |
|---|
| | | * @author 超级管理员 |
|---|
| | | */ |
|---|
| | | @Mapper |
|---|
| | | public interface MesDvRepairMapper extends BaseMapperX<MesDvRepairDO> { |
|---|
| | |
|---|
| | | .eqIfPresent(MesDvRepairDO::getResult, reqVO.getResult()) |
|---|
| | | .eqIfPresent(MesDvRepairDO::getStatus, reqVO.getStatus()) |
|---|
| | | .betweenIfPresent(MesDvRepairDO::getRequireDate, reqVO.getRequireDate()) |
|---|
| | | // 参数绑定，按设备台账当前名称模糊查询；列表与导出共享条件。 |
|---|
| | | .apply(cn.hutool.core.util.StrUtil.isNotBlank(reqVO.getMachineryName()), |
|---|
| | | "machinery_id IN (SELECT id FROM mes_dv_machinery WHERE deleted=0 AND name LIKE {0})", |
|---|
| | | "%" + cn.hutool.core.util.StrUtil.trimToEmpty(reqVO.getMachineryName()) + "%") |
|---|
| | | .orderByDesc(MesDvRepairDO::getId)); |
|---|
| | | } |
|---|
| | | |
|---|
