| | |
|---|
| | | return selectOne(MesProPalletDO::getTempCode, tempCode); |
|---|
| | | } |
|---|
| | | |
|---|
| | | /** 生成临时托盘码用的全局序号：解析 temp_code 的数字后缀，不存在则返回 0 */ |
|---|
| | | @Select("SELECT IFNULL(MAX(CAST(SUBSTRING(temp_code, 4) AS UNSIGNED)), 0) FROM mes_pro_pallet WHERE deleted = 0") |
|---|
| | | /** 生成临时托盘码用的全局序号：解析 temp_code 的数字后缀，不存在则返回 0。 |
|---|
| | | * 不能过滤 deleted，唯一索引 uk_temp_code 对逻辑删除行仍生效，忽略软删会导致序号回退、码值重复 */ |
|---|
| | | @Select("SELECT IFNULL(MAX(CAST(SUBSTRING(temp_code, 4) AS UNSIGNED)), 0) FROM mes_pro_pallet") |
|---|
| | | Integer selectMaxTempCodeSeq(); |
|---|
| | | |
|---|
| | | @Select("SELECT * FROM mes_pro_pallet WHERE id = #{id} AND deleted = 0 FOR UPDATE") |
|---|
| | |
|---|
| | | void markOutbound(@Param("id") Long id, @Param("salesId") Long salesId, |
|---|
| | | @Param("outboundTime") java.time.LocalDateTime outboundTime); |
|---|
| | | |
|---|
| | | /** 整托扫码入库回写：幂等（已有入库标记的不再更新），用于防重复入库 */ |
|---|
| | | @org.apache.ibatis.annotations.Update("UPDATE mes_pro_pallet SET inbound_event_id = #{eventId}, inbound_time = NOW(), update_time = NOW() " |
|---|
| | | + "WHERE id = #{id} AND deleted = 0 AND inbound_event_id IS NULL") |
|---|
| | | int markInbound(@Param("id") Long id, @Param("eventId") Long eventId); |
|---|
| | | |
|---|
| | | @org.apache.ibatis.annotations.Update("UPDATE mes_pro_pallet SET sales_id = NULL, outbound_time = NULL, update_time = NOW() " |
|---|
| | | + "WHERE id = #{id} AND deleted = 0") |
|---|
| | | void clearOutbound(@Param("id") Long id); |
|---|
