package com.battery.business.service.report;

import java.sql.Timestamp;
import java.util.List;
import javax.sql.DataSource;
import com.alibaba.fastjson2.JSON;
import com.fasterxml.jackson.annotation.JsonAnySetter;
import com.ruoyi.common.exception.ServiceException;
import jakarta.validation.Valid;
import jakarta.validation.constraints.NotBlank;
import jakarta.validation.constraints.NotNull;
import jakarta.validation.constraints.Size;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.support.GeneratedKeyHolder;
import org.springframework.stereotype.Service;

/** 化成模板仅存详情和循环字段结构，独立于对比模板及所有报表版本。 */
@Service
public class FormationFieldTemplateService
{
    private final JdbcTemplate jdbc;
    private final FormationReportService reports;
    public FormationFieldTemplateService(DataSource source, FormationReportService reports)
    { this.jdbc = new JdbcTemplate(source); this.reports = reports; }

    public record Template(long id, String name, String type, List<FormationField> fields, String creator, long updatedAt) { }
    public record Request(@NotBlank @Size(max = 100) String name,
            @NotNull @Size(min = 1, max = 100) List<@NotNull @Valid FormationField> fields)
    {
        /** 模板不接受整份报表、来源选择或数据值。 */
        @JsonAnySetter
        public void rejectUnknown(String field, Object value) { throw new ServiceException("化成模板不允许提交属性：" + field); }
    }

    /** 查看该类型全部模板，保存顺序即应用顺序。 */
    public List<Template> list()
    {
        return jdbc.query("select template_id,template_name,fields_json,creator_name,updated_at_utc from t_formation_report_field_template where template_type='formation' order by template_name,template_id",
                (rs, index) -> new Template(rs.getLong(1), rs.getString(2), "formation", JSON.parseArray(rs.getString(3), FormationField.class), rs.getString(4), rs.getTimestamp(5).getTime()));
    }

    /** 新增前解析共享定义身份，同名模板须显式更新。 */
    public long create(Request request, long userId, String userName)
    {
        var fields = reports.validateFields(request.fields(), true);
        var key = new GeneratedKeyHolder();
        try
        {
            jdbc.update(connection -> {
                var statement = connection.prepareStatement("insert into t_formation_report_field_template(template_name,template_type,fields_json,creator_id,creator_name,created_at_utc,updated_at_utc) values(?,'formation',?,?,?,?,?)", java.sql.Statement.RETURN_GENERATED_KEYS);
                statement.setString(1, request.name().trim()); statement.setString(2, JSON.toJSONString(fields));
                statement.setLong(3, userId); statement.setString(4, userName);
                var now = new Timestamp(System.currentTimeMillis()); statement.setTimestamp(5, now); statement.setTimestamp(6, now);
                return statement;
            }, key);
            return key.getKey().longValue();
        }
        catch (org.springframework.dao.DuplicateKeyException error) { throw new ServiceException("模板名称已存在"); }
    }

    /** 修改只影响后续主动应用，不访问报表版本；允许跨创建人协作。 */
    public void update(long id, Request request)
    {
        var fields = reports.validateFields(request.fields(), true);
        try
        {
            if (jdbc.update("update t_formation_report_field_template set template_name=?,fields_json=?,updated_at_utc=? where template_id=? and template_type='formation'",
                    request.name().trim(), JSON.toJSONString(fields), new Timestamp(System.currentTimeMillis()), id) == 0)
                throw new ServiceException("化成字段模板不存在");
        }
        catch (org.springframework.dao.DuplicateKeyException error) { throw new ServiceException("模板名称已存在"); }
    }
}