| | |
|---|
| | | @Mapper |
|---|
| | | public interface MesDvRepairMapper extends BaseMapperX<MesDvRepairDO> { |
|---|
| | | |
|---|
| | | default MesDvRepairDO lockForSpare(Long id) { |
|---|
| | | return selectOne(new LambdaQueryWrapperX<MesDvRepairDO>() |
|---|
| | | .eq(MesDvRepairDO::getId, id).last("FOR UPDATE")); |
|---|
| | | } |
|---|
| | | |
|---|
| | | default PageResult<MesDvRepairDO> selectPage(MesDvRepairPageReqVO reqVO) { |
|---|
| | | return selectPage(reqVO, new LambdaQueryWrapperX<MesDvRepairDO>() |
|---|
| | | .likeIfPresent(MesDvRepairDO::getCode, reqVO.getCode()) |
|---|
| | |
|---|
| | | .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)); |
|---|
| | | } |
|---|
| | | |
|---|
