package com.ruoyi.inspect.service;

import com.ruoyi.framework.exception.ErrorException;
import lombok.RequiredArgsConstructor;
import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.Collections;
import java.util.List;
import java.util.Map;

/**
 * 删除委托拥有的业务记录；标准、模板、设备、用户等公共资料不属于委托。
 */
@Service
@RequiredArgsConstructor
public class InsOrderDeletionService {

    private final NamedParameterJdbcTemplate jdbc;

    @Transactional(rollbackFor = Exception.class)
    public int deleteOrder(Integer orderId) {
        if (orderId == null || orderId <= 0) {
            throw new ErrorException("请选择要删除的委托单");
        }
        List<Map<String, Object>> orders = jdbc.queryForList(
                "SELECT type_source, ifs_inventory_id FROM ins_order WHERE id = :id FOR UPDATE",
                Collections.singletonMap("id", orderId));
        if (orders.isEmpty()) {
            throw new ErrorException("委托单不存在或已被删除");
        }
        Map<String, Object> order = orders.get(0);
        Object source = order.get("type_source");
        Object inventoryId = order.get("ifs_inventory_id");
        if ((source instanceof Number && ((Number) source).intValue() == 1)
                || (inventoryId != null && !inventoryId.toString().trim().isEmpty())) {
            throw new ErrorException("此入口仅允许删除委托下单中的委托单");
        }

        List<Long> orderIds = Collections.singletonList(orderId.longValue());
        List<Long> sampleIds = ids("ins_sample", "id", "ins_order_id", orderIds);
        List<Long> productIds = ids("ins_product", "id", "ins_sample_id", sampleIds);
        List<Long> reportIds = ids("ins_report", "id", "ins_order_id", orderIds);
        List<Long> inspectionIds = ids("cnas_inspection_order", "inspection_order_id", "ins_order_id", orderIds);
        List<Long> processSampleIds = ids("cnas_process_sample", "id", "inspection_order_id", inspectionIds);
        List<Long> satisfactionIds = ids("cnas_client_satisfaction", "client_satisfaction_id", "order_id", orderIds);
        List<Long> verifyIds = ids("ins_order_factory_verify", "factory_verify_id", "ins_order_id", orderIds);
        List<Long> warningIds = ids("ins_product_deviation_warning", "deviation_warning_id", "ins_order_id", orderIds);
        List<Long> evaluateIds = ids("cnas_quality_monitor_details_evaluate", "details_evaluate_id", "ins_order_id", orderIds);
        List<Long> retestIds = ids("ins_unqualified_retest_product", "id", "ins_product_id", productIds);
        List<Long> handlerIds = ids("ins_unqualified_handler", "id", "ins_order_id", orderIds);

        // 先删除外部业务模块中由本委托生成的记录，再删除检验主从表。
        delete("cnas_client_satisfaction_attachment", "client_satisfaction_id", satisfactionIds);
        delete("cnas_client_satisfaction", "client_satisfaction_id", satisfactionIds);
        delete("cnas_process_complain", "ins_report_id", reportIds);
        delete("cnas_quality_monitor_details_evaluate_file", "details_evaluate_id", evaluateIds);
        delete("cnas_quality_monitor_details_evaluate", "ins_order_id", orderIds);
        delete("cnas_process_deal", "ins_sample_id", sampleIds);
        delete("cnas_process_deal", "process_sample_id", processSampleIds);
        // 报告发送记录的历史字段 inspection_order_id 实际存储 ins_order.id。
        delete("cnas_process_report", "inspection_order_id", orderIds);
        delete("cnas_process_order_device", "inspection_order_id", inspectionIds);
        delete("cnas_process_sample", "inspection_order_id", inspectionIds);
        delete("cnas_inspection_order_detail", "inspection_order_id", inspectionIds);
        delete("cnas_inspection_order", "inspection_order_id", inspectionIds);

        delete("auxiliary_output_working_hours", "order_id", orderIds);
        delete("auxiliary_output_working_hours_temporary", "order_id", orderIds);
        delete("auxiliary_output_working_hours", "sample_id", sampleIds);
        delete("auxiliary_output_working_hours_temporary", "sample_id", sampleIds);
        delete("auxiliary_output_working_hours", "ins_product_id", productIds);
        delete("auxiliary_output_working_hours_temporary", "ins_product_id", productIds);

        delete("ins_report_edit_session", "report_id", reportIds);
        delete("ins_report_return_record", "report_id", reportIds);
        delete("ins_report_return_record", "ins_order_id", orderIds);
        delete("seal_usage_ledger", "report_id", reportIds);
        delete("seal_usage_ledger", "ins_order_id", orderIds);
        delete("ins_report", "ins_order_id", orderIds);

        delete("ins_product_deviation_warning_detail", "deviation_warning_id", warningIds);
        delete("ins_product_deviation_warning_detail", "ins_order_id", orderIds);
        delete("ins_product_deviation_warning_detail", "ins_product_id", productIds);
        delete("ins_product_deviation_warning", "ins_order_id", orderIds);
        delete("ins_product_deviation_warning", "ins_product_id", productIds);
        delete("ins_order_rates", "ins_order_id", orderIds);
        delete("ins_order_rates", "ins_product_id", productIds);
        delete("ins_unqualified_retest_result", "retest_product_id", retestIds);
        delete("ins_unqualified_retest_product", "ins_product_id", productIds);
        delete("ins_unqualified_retest_product", "ins_sample_id", sampleIds);
        delete("ins_unqualified_handler_file", "unqualified_id", handlerIds);
        delete("ins_unqualified_handler", "ins_order_id", orderIds);
        delete("ins_product_result", "ins_product_id", productIds);
        delete("ins_product_user", "ins_product_id", productIds);
        delete("ins_product", "ins_sample_id", sampleIds);
        delete("warehouse_history", "ins_sample_id", sampleIds);
        delete("ins_sample_receipt", "ins_order_id", orderIds);
        // 历史字段名为 ins_sample_id，实际存储 ins_order.id，不能按样品 ID 删除。
        delete("ins_sample_user", "ins_sample_id", orderIds);
        delete("ins_sample", "ins_order_id", orderIds);

        delete("ins_order_factory_verify_item", "factory_verify_id", verifyIds);
        delete("ins_order_factory_verify", "ins_order_id", orderIds);
        delete("device_record", "ins_order_id", orderIds);
        delete("ins_order_file", "ins_order_id", orderIds);
        delete("ins_order_template_device", "ins_order_id", orderIds);
        delete("ins_order_standard_template", "ins_order_id", orderIds);
        delete("ins_order_state", "ins_order_id", orderIds);
        return delete("ins_order", "id", orderIds);
    }

    // 表名、列名仅来自本类固定的关联清单；所有业务 ID 均使用绑定参数。
    private List<Long> ids(String table, String key, String foreignKey, List<Long> parentIds) {
        if (parentIds.isEmpty()) {
            return Collections.emptyList();
        }
        return jdbc.queryForList("SELECT " + key + " FROM " + table + " WHERE " + foreignKey + " IN (:ids)",
                Collections.singletonMap("ids", parentIds), Long.class);
    }

    private int delete(String table, String foreignKey, List<Long> parentIds) {
        if (parentIds.isEmpty()) {
            return 0;
        }
        return jdbc.update("DELETE FROM " + table + " WHERE " + foreignKey + " IN (:ids)",
                Collections.singletonMap("ids", parentIds));
    }
}