package jnpf.elnMapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import jnpf.elnEntity.formula.ElnFormulaDefEntity;
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 ElnFormulaDefMapper extends BaseMapper<ElnFormulaDefEntity> {

    @Insert("INSERT INTO eln_formula_def (gongshi_bianma, gongshi_mingcheng, yewu_yongtu, "
            + "dangqian_gongshi_banben_id, biz_enabled, beizhu, 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.gongshiBianma}, #{entity.gongshiMingcheng}, #{entity.yewuYongtu}, "
            + "#{entity.dangqianGongshiBanbenId}, #{entity.bizEnabled}, #{entity.beizhu}, "
            + "#{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_bianma) DO NOTHING")
    int insertIgnoreCode(@Param("entity") ElnFormulaDefEntity entity);

    @Update("UPDATE eln_formula_def SET "
            + "gongshi_mingcheng = #{entity.gongshiMingcheng}, "
            + "yewu_yongtu = #{entity.yewuYongtu}, "
            + "dangqian_gongshi_banben_id = #{entity.dangqianGongshiBanbenId}, "
            + "biz_enabled = #{entity.bizEnabled}, beizhu = #{entity.beizhu}, "
            + "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") ElnFormulaDefEntity entity,
                                        @Param("expectedVersion") Integer expectedVersion);
}