package cn.iocoder.yudao.module.mes.dal.mysql.trace.crossregion;

import cn.iocoder.yudao.framework.common.pojo.PageResult;
import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
import cn.iocoder.yudao.module.mes.controller.admin.trace.crossregion.vo.MesTraceCrossRegionWarningPageReqVO;
import cn.iocoder.yudao.module.mes.dal.dataobject.trace.crossregion.MesTraceCrossRegionWarningDO;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * 窜货预警记录 Mapper
 *
 * @author 超级管理员
 */
@Mapper
public interface MesTraceCrossRegionWarningMapper extends BaseMapperX<MesTraceCrossRegionWarningDO> {

    default PageResult<MesTraceCrossRegionWarningDO> selectPage(MesTraceCrossRegionWarningPageReqVO reqVO) {
        return selectPage(reqVO, new LambdaQueryWrapperX<MesTraceCrossRegionWarningDO>()
                .eqIfPresent(MesTraceCrossRegionWarningDO::getStatus, reqVO.getStatus())
                .eqIfPresent(MesTraceCrossRegionWarningDO::getWarningType, reqVO.getWarningType())
                .eqIfPresent(MesTraceCrossRegionWarningDO::getBatchId, reqVO.getBatchId())
                .likeIfPresent(MesTraceCrossRegionWarningDO::getBatchCode, reqVO.getBatchCode())
                .likeIfPresent(MesTraceCrossRegionWarningDO::getBagCode, reqVO.getBagCode())
                .eqIfPresent(MesTraceCrossRegionWarningDO::getClientId, reqVO.getClientId())
                .likeIfPresent(MesTraceCrossRegionWarningDO::getClientName, reqVO.getClientName())
                .betweenIfPresent(MesTraceCrossRegionWarningDO::getEventTime, reqVO.getEventTime())
                .orderByDesc(MesTraceCrossRegionWarningDO::getId));
    }

    /**
     * 按时间范围查询预警列表（供统计分组使用）
     */
    default List<MesTraceCrossRegionWarningDO> selectListByEventTimeBetween(java.time.LocalDateTime startTime,
                                                                            java.time.LocalDateTime endTime) {
        return selectList(new LambdaQueryWrapperX<MesTraceCrossRegionWarningDO>()
                .betweenIfPresent(MesTraceCrossRegionWarningDO::getEventTime, startTime, endTime));
    }

}