package jnpf.elnMapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import jnpf.elnEntity.formula.ElnFormulaParameterSlotEntity;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Update;

@Mapper
public interface ElnFormulaParameterSlotMapper extends BaseMapper<ElnFormulaParameterSlotEntity> {

    @Insert("INSERT INTO eln_formula_parameter_slot (gongshi_banben_id, canshu_bianma, "
            + "canshu_mingcheng, shuju_leixing, danwei, shifou_bitian, paixu, f_id, "
            + "f_tenant_id, f_version, f_creator_user_id, f_creator_time, "
            + "f_last_modify_user_id, f_last_modify_time, f_delete_user_id, f_delete_time, "
            + "f_delete_mark) VALUES (#{entity.gongshiBanbenId}, #{entity.canshuBianma}, "
            + "#{entity.canshuMingcheng}, #{entity.shujuLeixing}, #{entity.danwei}, "
            + "#{entity.shifouBitian}, #{entity.paixu}, #{entity.id}, #{entity.fTenantId}, "
            + "#{entity.fVersion}, #{entity.fCreatorUserId}, #{entity.fCreatorTime}, "
            + "#{entity.fLastModifyUserId}, #{entity.fLastModifyTime}, "
            + "#{entity.fDeleteUserId}, #{entity.fDeleteTime}, #{entity.fDeleteMark}) "
            + "ON CONFLICT (f_tenant_id, gongshi_banben_id, canshu_bianma) DO NOTHING")
    int insertIgnoreCode(@Param("entity") ElnFormulaParameterSlotEntity entity);

    @Update("UPDATE eln_formula_parameter_slot SET "
            + "canshu_mingcheng = #{entity.canshuMingcheng}, "
            + "shuju_leixing = #{entity.shujuLeixing}, danwei = #{entity.danwei}, "
            + "shifou_bitian = #{entity.shifouBitian}, paixu = #{entity.paixu}, "
            + "f_last_modify_user_id = #{entity.fLastModifyUserId}, "
            + "f_last_modify_time = #{entity.fLastModifyTime}, f_version = f_version + 1 "
            + "WHERE f_tenant_id = #{entity.fTenantId} AND f_id = #{entity.id} "
            + "AND f_version = #{expectedVersion}")
    int updateMutableByTenantAndVersion(@Param("entity") ElnFormulaParameterSlotEntity entity,
                                        @Param("expectedVersion") Integer expectedVersion);

    @Delete("DELETE FROM eln_formula_parameter_slot "
            + "WHERE f_tenant_id = #{entity.fTenantId} AND f_id = #{entity.id} "
            + "AND f_version = #{expectedVersion}")
    int deleteByTenantAndVersion(@Param("entity") ElnFormulaParameterSlotEntity entity,
                                 @Param("expectedVersion") Integer expectedVersion);
}