package jnpf.elnMapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import jnpf.elnEntity.runtime.ElnRecordRevisionEntity;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Update;
|
|
@Mapper
|
public interface ElnRecordRevisionMapper extends BaseMapper<ElnRecordRevisionEntity> {
|
|
@Update("UPDATE eln_record_revision SET biz_status = 'HISTORICAL', "
|
+ "f_version = f_version + 1, f_last_modify_user_id = #{userId}, "
|
+ "f_last_modify_time = CURRENT_TIMESTAMP WHERE f_tenant_id = #{tenantId} "
|
+ "AND f_id = #{revisionId} AND dianzi_jilu_id = #{recordId} "
|
+ "AND biz_status = 'DRAFT' AND f_version = #{expectedRevisionVersion} "
|
+ "AND COALESCE(f_delete_mark, 0) = 0")
|
int markHistorical(@Param("tenantId") String tenantId,
|
@Param("recordId") String recordId,
|
@Param("revisionId") String revisionId,
|
@Param("expectedRevisionVersion") Integer expectedRevisionVersion,
|
@Param("userId") String userId);
|
}
|
