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);
|
}
|
