package jnpf.elnMapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import jnpf.elnEntity.field.ElnFieldVersionEntity;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

@Mapper
public interface ElnFieldVersionMapper extends BaseMapper<ElnFieldVersionEntity> {

    @Insert("INSERT INTO eln_field_version ("
            + "ziduan_dingyi_id, banben_hao, ziduan_mingcheng, shuju_leixing, danwei, "
            + "shifou_bitian, pici_moshi, bangding_peizhi, kongjian_peizhi, "
            + "recommended_checkbox_group_code, recommended_checkbox_min_selected, "
            + "recommended_checkbox_max_selected, biz_status, "
            + "zuofei_yuanyin, 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.ziduanDingyiId}, #{entity.banbenHao}, #{entity.ziduanMingcheng}, #{entity.shujuLeixing}, #{entity.danwei}, "
            + "#{entity.shifouBitian}, #{entity.piciMoshi}, #{entity.bangdingPeizhi,jdbcType=OTHER,typeHandler="
            + "jnpf.elnEntity.field.ElnFieldVersionEntity$JsonbStringTypeHandler}, "
            + "#{entity.kongjianPeizhi,jdbcType=OTHER,typeHandler="
            + "jnpf.elnEntity.field.ElnFieldVersionEntity$JsonbStringTypeHandler}, "
            + "#{entity.recommendedCheckboxGroupCode}, #{entity.recommendedCheckboxMinSelected}, "
            + "#{entity.recommendedCheckboxMaxSelected}, #{entity.bizStatus}, "
            + "#{entity.zuofeiYuanyin}, #{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, ziduan_dingyi_id, banben_hao) DO NOTHING")
    int insertIgnoreVersionNo(@Param("entity") ElnFieldVersionEntity entity);
}