package jnpf.elnEntity.formula;

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 com.fasterxml.jackson.core.type.TypeReference;
import com.fasterxml.jackson.databind.ObjectMapper;
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;
import java.util.ArrayList;
import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;

@Data
@TableName(value = "eln_template_formula_binding", autoResultMap = true)
public class ElnTemplateFormulaBindingEntity implements Serializable {
    private static final long serialVersionUID = 1L;

    @TableId("f_id") private String id;
    @TableField("muban_id") private String mubanId;
    @TableField("gongshi_dingyi_id") private String gongshiDingyiId;
    @TableField("gongshi_banben_id") private String gongshiBanbenId;
    @TableField(value = "canshu_yingshe", jdbcType = JdbcType.OTHER,
            typeHandler = ParameterMappingTypeHandler.class)
    private Map<String, String> canshuYingshe = new LinkedHashMap<>();
    @TableField("jieguo_bangding_id") private String jieguoBangdingId;
    @TableField("bangding_zhuangtai") private String bangdingZhuangtai;
    @TableField("tuopu_xuhao") private Integer tuopuXuhao;
    @TableField("caozuo_bianma") private String caozuoBianma;
    @TableField(value = "jieguo_suo_kuaizhao", jdbcType = JdbcType.OTHER,
            typeHandler = ControlSnapshotListTypeHandler.class)
    private List<ElnFormulaForms.ControlSnapshot> jieguoSuoKuaizhao = new ArrayList<>();
    @TableField("laiyuan_gongshi_bangding_id") private String laiyuanGongshiBangdingId;
    @TableField("daoqi_shijian") private Date daoqiShijian;
    @TableField("zhuangtai_yuanyin") private String zhuangtaiYuanyin;
    @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 ParameterMappingTypeHandler
            extends BaseTypeHandler<Map<String, String>> {
        private static final ObjectMapper MAPPER = new ObjectMapper();
        private static final TypeReference<Map<String, String>> TYPE =
                new TypeReference<Map<String, String>>() { };

        @Override
        public void setNonNullParameter(PreparedStatement statement, int index,
                Map<String, String> parameter, JdbcType jdbcType) throws SQLException {
            try {
                statement.setObject(index, MAPPER.writeValueAsString(parameter), Types.OTHER);
            } catch (Exception ex) {
                throw new SQLException("公式参数映射序列化失败", ex);
            }
        }

        @Override public Map<String, String> getNullableResult(ResultSet rs, String name) throws SQLException {
            return parse(rs.getString(name));
        }
        @Override public Map<String, String> getNullableResult(ResultSet rs, int index) throws SQLException {
            return parse(rs.getString(index));
        }
        @Override public Map<String, String> getNullableResult(CallableStatement cs, int index) throws SQLException {
            return parse(cs.getString(index));
        }
        private static Map<String, String> parse(String json) throws SQLException {
            if (json == null) return null;
            try { return MAPPER.readValue(json, TYPE); }
            catch (Exception ex) { throw new SQLException("公式参数映射解析失败", ex); }
        }
    }

    public static final class ControlSnapshotListTypeHandler
            extends BaseTypeHandler<List<ElnFormulaForms.ControlSnapshot>> {
        private static final ObjectMapper MAPPER = new ObjectMapper();
        private static final TypeReference<List<ElnFormulaForms.ControlSnapshot>> TYPE =
                new TypeReference<List<ElnFormulaForms.ControlSnapshot>>() { };

        @Override
        public void setNonNullParameter(PreparedStatement statement, int index,
                List<ElnFormulaForms.ControlSnapshot> parameter, JdbcType jdbcType) throws SQLException {
            try {
                statement.setObject(index, MAPPER.writeValueAsString(parameter), Types.OTHER);
            } catch (Exception ex) {
                throw new SQLException("公式结果锁快照序列化失败", ex);
            }
        }

        @Override public List<ElnFormulaForms.ControlSnapshot> getNullableResult(ResultSet rs, String name) throws SQLException {
            return parse(rs.getString(name));
        }
        @Override public List<ElnFormulaForms.ControlSnapshot> getNullableResult(ResultSet rs, int index) throws SQLException {
            return parse(rs.getString(index));
        }
        @Override public List<ElnFormulaForms.ControlSnapshot> getNullableResult(CallableStatement cs, int index) throws SQLException {
            return parse(cs.getString(index));
        }
        private static List<ElnFormulaForms.ControlSnapshot> parse(String json) throws SQLException {
            if (json == null) return new ArrayList<>();
            try { return MAPPER.readValue(json, TYPE); }
            catch (Exception ex) { throw new SQLException("公式结果锁快照解析失败", ex); }
        }
    }
}