package jnpf.elnEntity.field;

import com.baomidou.mybatisplus.annotation.FieldFill;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.baomidou.mybatisplus.annotation.Version;
import lombok.Data;
import org.apache.ibatis.type.BaseTypeHandler;
import org.apache.ibatis.type.JdbcType;

import java.io.Serializable;
import java.sql.CallableStatement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Types;
import java.util.Date;

@Data
@TableName(value = "eln_field_version", autoResultMap = true)
public class ElnFieldVersionEntity implements Serializable {

    private static final long serialVersionUID = 1L;

    @TableId("f_id")
    private String id;

    @TableField("ziduan_dingyi_id")
    private String ziduanDingyiId;

    @TableField("banben_hao")
    private Integer banbenHao;

    @TableField("ziduan_mingcheng")
    private String ziduanMingcheng;

    @TableField("shuju_leixing")
    private String shujuLeixing;

    @TableField("danwei")
    private String danwei;

    @TableField("shifou_bitian")
    private Integer shifouBitian;

    @TableField("pici_moshi")
    private String piciMoshi;

    @TableField(value = "bangding_peizhi", jdbcType = JdbcType.OTHER,
            typeHandler = JsonbStringTypeHandler.class)
    private String bangdingPeizhi;

    @TableField(value = "kongjian_peizhi", jdbcType = JdbcType.OTHER,
            typeHandler = JsonbStringTypeHandler.class)
    private String kongjianPeizhi;

    @TableField("recommended_checkbox_group_code")
    private String recommendedCheckboxGroupCode;

    @TableField("recommended_checkbox_min_selected")
    private Integer recommendedCheckboxMinSelected;

    @TableField("recommended_checkbox_max_selected")
    private Integer recommendedCheckboxMaxSelected;

    @TableField("biz_status")
    private String bizStatus;

    @TableField("zuofei_yuanyin")
    private String zuofeiYuanyin;

    @TableField("f_tenant_id")
    private String fTenantId;

    @Version
    @TableField("f_version")
    private Integer fVersion;

    @TableField(value = "f_creator_user_id", fill = FieldFill.INSERT)
    private String fCreatorUserId;

    @TableField(value = "f_creator_time", fill = FieldFill.INSERT)
    private Date fCreatorTime;

    @TableField(value = "f_last_modify_user_id", fill = FieldFill.INSERT_UPDATE)
    private String fLastModifyUserId;

    @TableField(value = "f_last_modify_time", fill = FieldFill.INSERT_UPDATE)
    private Date fLastModifyTime;

    @TableField("f_delete_user_id")
    private String fDeleteUserId;

    @TableField("f_delete_time")
    private Date fDeleteTime;

    @TableField("f_delete_mark")
    private Integer fDeleteMark;

    public static final class JsonbStringTypeHandler extends BaseTypeHandler<String> {

        @Override
        public void setNonNullParameter(PreparedStatement statement, int index, String parameter,
                                        JdbcType jdbcType) throws SQLException {
            statement.setObject(index, parameter, Types.OTHER);
        }

        @Override
        public String getNullableResult(ResultSet resultSet, String columnName) throws SQLException {
            return resultSet.getString(columnName);
        }

        @Override
        public String getNullableResult(ResultSet resultSet, int columnIndex) throws SQLException {
            return resultSet.getString(columnIndex);
        }

        @Override
        public String getNullableResult(CallableStatement statement, int columnIndex)
                throws SQLException {
            return statement.getString(columnIndex);
        }
    }
}