package com.mes.device.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.mes.device.entity.EngineeringSequence;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.Date;

/**
 * 工程序号Mapper接口
 * 
 * @author mes
 * @since 2024-11-20
 */
@Mapper
public interface EngineeringSequenceMapper extends BaseMapper<EngineeringSequence> {

    /**
     * 查询指定日期的最大序号
     * 
     * @param date 日期
     * @return 最大序号，如果没有记录返回0
     */
    @Select("SELECT COALESCE(MAX(sequence), 0) FROM engineering_sequence WHERE DATE(date) = DATE(#{date})")
    Integer selectMaxSequenceByDate(@Param("date") Date date);

    /**
     * 根据工程号查询工程序号信息
     * 
     * @param engineeringId 工程号
     * @return 工程序号信息
     */
    @Select("SELECT * FROM engineering_sequence WHERE engineering_id = #{engineeringId} AND is_deleted = 0 LIMIT 1")
    EngineeringSequence selectByEngineeringId(@Param("engineeringId") String engineeringId);
}