package com.malk.huagao.service.impl;


import cn.hutool.http.HttpRequest;
import cn.hutool.http.HttpResponse;
import cn.hutool.http.HttpUtil;
import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.malk.huagao.entity.*;
import com.malk.huagao.mapper.KdYdOrderDetailMapper;
import com.malk.huagao.mapper.KdYdOrderMapper;
import com.malk.huagao.mapper.KdYdOrderPaymentMapper;
import com.malk.huagao.service.IKdYdOrderService;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.malk.server.aliwork.YDConf;
import com.malk.server.aliwork.YDParam;
import com.malk.server.aliwork.YDSearch;
import com.malk.server.common.McR;
import com.malk.server.dingtalk.DDR_New;
import com.malk.service.aliwork.YDClient;
import com.malk.utils.UtilHttp;
import com.malk.utils.UtilMap;
import org.apache.commons.lang3.StringUtils;
import org.slf4j.MDC;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;


import java.math.BigDecimal;
import java.math.RoundingMode;
import java.text.SimpleDateFormat;
import java.time.Instant;
import java.time.LocalDateTime;
import java.time.ZoneId;
import java.util.*;

/**
 * <p>
 * 服务实现类
 * </p>
 *
 * @author LQY
 * @since 2025-10-15
 */
@Service
public class KdYdOrderServiceImpl extends ServiceImpl<KdYdOrderMapper, KdYdOrder> implements IKdYdOrderService {
    @Autowired
    private YDClient ydClient;
    @Autowired
    private KdYdOrderMapper kdYdOrderMapper;
    @Autowired
    private KdYdOrderDetailMapper kdYdOrderDetailMapper;
    @Autowired
    private KdYdOrderPaymentMapper kdYdOrderPaymentMapper;


    @Override
    public Map<String, Object> insertkdYdOrder(Map map) {
        Map<String, Object> result = new HashMap<>();

        try {
            MDC.put("MDC_KEY_PID", "1003");
            String formInstId = UtilMap.getString(map, "formInstId");
            String type = UtilMap.getString(map, "type");

            // 处理特殊操作类型
            if ("del".equals(type)) {
                String bm = UtilMap.getString(map, "bm");
                Map<String, String> headers = new HashMap<>();
                headers.put("Content-Type", "application/x-www-form-urlencoded");
                Map<String, Object> formParams = new HashMap<>();
                Map<String, Object> djbh = new HashMap<>();
                djbh.put("djbh", bm);
                result.put("data", djbh);
                String jsonStr = JSON.toJSONString(result);

                formParams.put("jsons", jsonStr);

                System.out.println("====" + formParams);
                HttpResponse response = HttpRequest.post("http://113.45.187.194:70/xk/dyzn/WsBasedyzn.asmx/hgdjydtbdeletexsdd")
                        .headerMap(headers, true)
                        .form(formParams)
                        .timeout(30000)  // 30秒超时
                        .execute();

                String responseBody = response.body();
                // 返回删除操作的格式
                result.put("table", "KD_YD_ORDER");
                result.put("action", "del");
                result.put("data", new HashMap<String, Object>() {{
                    put("bm", bm);  // 删除的主键或标识
                    put("msg", "删除成功");
                }});
                return result;
            }

            if ("cancel".equals(type)) {
                String bm = UtilMap.getString(map, "bm");
                Map<String, String> headers = new HashMap<>();
                headers.put("Content-Type", "application/x-www-form-urlencoded");
                Map<String, Object> formParams = new HashMap<>();
                Map<String, Object> djbh = new HashMap<>();
                djbh.put("djbh", bm);
                result.put("data", djbh);
                String jsonStr = JSON.toJSONString(result);
                System.out.println("==" + jsonStr);
                formParams.put("jsons", jsonStr);
                HttpResponse response = HttpRequest.post("http://113.45.187.194:70/xk/dyzn/WsBasedyzn.asmx/hgdjydtbExcuteOperationxsdd")
                        .headerMap(headers, true)
                        .form(formParams)
                        .timeout(30000)  // 30秒超时
                        .execute();

                String responseBody = response.body();
                String msg = JSON.parseArray(responseBody)
                        .getJSONObject(0)
                        .getString("msg");
                ydClient.operateData(
                        YDParam.builder()
                                .formInstanceId(formInstId)
                                .updateFormDataJson(JSONObject.toJSONString(UtilMap.map("textareaField_mkxqgrvq", msg)))
                                .useLatestVersion(true).build(),
                        YDConf.FORM_OPERATION.update);
                // 返回作废操作的格式
                result.put("table", "KD_YD_ORDER");
                result.put("action", "cancel"); // 作废通常是修改状态
                result.put("data", new HashMap<String, Object>() {{
                    put("bm", bm); // 作废状态
                    put("msg", "作废成功");
                    // 其他作废需要的数据
                }});
                return result;
            }

            // 查询表单数据
            DDR_New ddrNew = ydClient.queryData(YDParam.builder()
                    .formInstId(formInstId)
                    .build(), YDConf.FORM_QUERY.retrieve_id);
            Map formData = ddrNew.getFormData();

            // 提取主表字段
            String djlx = UtilMap.getString(formData, "selectField_mejowmna");
            String khmc = UtilMap.getString(formData, "textField_mejnamf2");
//            String khmc = "五岳";
//            String djbh = UtilMap.getString(formData, "textField_mjs6fuwo");

            // 判断操作类型对应的action
            String actionType;
            String djbh = null;
            if ("edit".equals(type)) {
                djbh = UtilMap.getString(formData, "textField_mjs6fuwo");
                actionType = "edit";
            } else {
                actionType = "add";
                djbh = "";
            }

            // 提取其他字段...
            LocalDateTime rq = parseTimestamp(UtilMap.getString(formData, "dateField_mejowmnb"));
            String khxypj = UtilMap.getString(formData, "selectField_mewirdx4");
            String ywlx = UtilMap.getString(formData, "textField_mfxv2vfz");
            String xsy = UtilMap.getString(formData, "employeeField_mejowmng").replace("[\"", "").replace("\"]", "").trim();
            String xslx = UtilMap.getString(formData, "selectField_mejowmnc");
            String bzq = UtilMap.getString(formData, "selectField_mf6gyfkq");
            String xsbm = UtilMap.getString(formData, "departmentSelectField_mfxv2vfu").replace("[\"", "").replace("\"]", "").trim();
            String bz = UtilMap.getString(formData, "textareaField_mejnamfb");
            String jsbb = UtilMap.getString(formData, "selectField_mejowmnk");
            String sktj = UtilMap.getString(formData, "selectField_mgisux07");
            String zdzkestr = UtilMap.getString(formData, "numberField_mejowmni");
            BigDecimal zdzke = toBigDecimal(zdzkestr);
            String sestr = UtilMap.getString(formData, "numberField_mfxv2vgh");
            BigDecimal se = toBigDecimal(sestr);
            String jestr = UtilMap.getString(formData, "numberField_mfxv2vgj");
            BigDecimal je = toBigDecimal(jestr);
            String jshjstr = UtilMap.getString(formData, "numberField_mewfgzkv");
            BigDecimal jshj = toBigDecimal(jshjstr);
            String sfhs = UtilMap.getString(formData, "radioField_mfxv2vg4");
            String jws = UtilMap.getString(formData, "radioField_mfxv2vgm");
            List<Map> tableField = (List<Map>) formData.get("tableField_mfbx1pqi");
            List<Map> tableFieldPayment = (List<Map>) formData.get("tableField_mhiui6v5");

            // 处理订单明细
            List<Map<String, Object>> orderList = new ArrayList<>();
            if (tableField != null) {
                for (int i = 0; i < tableField.size(); i++) {
                    Map item = tableField.get(i);
                    Map<String, Object> table1Map = new HashMap<>();

                    int detailId = parseInt(safeGetString(item, "numberField_mjzfodew"), 0);
                    String wlbm = safeGetString(item, "textField_mfbx1pqt");
//                    String wlbm = "010101010003";
                    String wlmc = safeGetString(item, "textField_mfbx1pqs");
                    String ggxh = safeGetString(item, "textField_mfbx1pqr");
                    String xsdw = safeGetString(item, "textField_mfbx1pqq");
                    int xssl = parseInt(safeGetString(item, "numberField_mfbx1pr4"), 0);
                    String ssxl = safeGetString(item, "selectField_mfbx1pr1");
                    BigDecimal dj = toBigDecimal(safeGetString(item, "numberField_mfbx1prf"));
                    BigDecimal cxzkje = toBigDecimal(safeGetString(item, "numberField_mk56soin"));
                    BigDecimal hsdj = toBigDecimal(safeGetString(item, "numberField_mfbx1prg"));
                    String sfzp = safeGetString(item, "radioField_mfbx1prc");
                    String bz1 = safeGetString(item, "textareaField_mjryuaok");
                    int sl = parseInt(safeGetString(item, "numberField_mfbx1prb"), 0);
                    BigDecimal zse = toBigDecimal(safeGetString(item, "numberField_mfbx1prh"));
                    BigDecimal zje = toBigDecimal(safeGetString(item, "numberField_mfbx1pri"));
                    BigDecimal zjshj = toBigDecimal(safeGetString(item, "numberField_mfbx1prj"));
                    BigDecimal jj = toBigDecimal(safeGetString(item, "numberField_mfbx1prk"));
                    BigDecimal zkl = toBigDecimal(safeGetString(item, "numberField_mfbx1pru"));
                    BigDecimal zke = toBigDecimal(safeGetString(item, "numberField_mfbx1prt"));
                    LocalDateTime yhrq = parseTimestamp(UtilMap.getString(item, "dateField_mfbx1prs"));
                    BigDecimal xsjzj = toBigDecimal(safeGetString(item, "numberField_mfbx1pr0"));
                    String zmzs = safeGetString(item, "textField_mfxv2vgv");

                    // 设置明细字段
                    table1Map.put("detailId", detailId);
                    table1Map.put("wlbm", wlbm);
                    table1Map.put("wlmc", wlmc);
                    table1Map.put("ggxh", ggxh);
                    table1Map.put("xsdw", xsdw);
                    table1Map.put("xssl", xssl);
                    table1Map.put("ssxl", ssxl);
                    table1Map.put("dj", dj);
                    table1Map.put("cxzkje", cxzkje);
                    table1Map.put("hsdj", hsdj);
                    table1Map.put("sfzp", sfzp);
                    table1Map.put("bz", bz1);
                    table1Map.put("sl", sl);
                    table1Map.put("se1", zse);
                    table1Map.put("je1", zje);
                    table1Map.put("jshj1", zjshj);
                    table1Map.put("jj", jj);
                    table1Map.put("zkl", zkl);
                    table1Map.put("zke", zke);
                    table1Map.put("xsjzj", xsjzj);
                    table1Map.put("zmzs", zmzs);
                    table1Map.put("yhrq", yhrq);

                    orderList.add(table1Map);
                }
            }

            // 处理付款明细
            List<Map<String, Object>> OrderPayList = new ArrayList<>();
            if (tableFieldPayment != null) {
                for (int i = 0; i < tableFieldPayment.size(); i++) {
                    Map row = tableFieldPayment.get(i);
                    Map<String, Object> table2Map = new HashMap<>();
                    int detailId = i + 1;

                    String sfys = safeGetString(row, "radioField_mhiui6v7");
                    String gldh = safeGetString(row, "textField_mhiui6va");
                    BigDecimal ysbl = toBigDecimal(UtilMap.getString(row, "numberField_mhiui6v6"));
                    BigDecimal ysje = toBigDecimal(UtilMap.getString(row, "numberField_mhiui6v8"));
                    BigDecimal ssje = toBigDecimal(UtilMap.getString(row, "numberField_mhiui6vb"));
                    LocalDateTime endTime = parseTimestamp(UtilMap.getString(row, "dateField_mhiui6v9"));

                    table2Map.put("detailId", detailId);
                    table2Map.put("sfys", sfys);
                    table2Map.put("gldh", gldh);
                    table2Map.put("ysbl", ysbl);
                    table2Map.put("ysje", ysje);
                    table2Map.put("ssje", ssje);
                    table2Map.put("endTime", endTime);

                    OrderPayList.add(table2Map);
                }
            }

            // 构建主表数据，映射到数据库表字段
            Map<String, Object> orderData = new HashMap<>();

            // 注意：这里需要将字段名映射到数据库表字段名
            // 示例映射，实际需要根据数据库表结构调整
            orderData.put("djlx", djlx);                    // 单据类型
            orderData.put("djbh", djbh);                    // 单据编号
            orderData.put("khmc", khmc);                    // 客户名称
            orderData.put("rq", rq);                        // 日期
            orderData.put("khxypj", khxypj);                // 客户信用评级
            orderData.put("ywlx", ywlx);                    // 业务类型
            orderData.put("xslx", xslx);                    // 销售类型
            orderData.put("bzq", bzq);                      // 保质期
            orderData.put("xsy", xsy);                      // 销售员
            orderData.put("xsbm", xsbm);                    // 销售部门
            orderData.put("bz", bz);                        // 备注
            orderData.put("jsbb", jsbb);                    // 结算币别
            orderData.put("sktj", sktj);                    // 收款条件
            orderData.put("zdzke", zdzke);                  // 整单折扣额
            orderData.put("se", se);                        // 税额
            orderData.put("je", je);                        // 金额
            orderData.put("jshj", jshj);                    // 价税合计
            orderData.put("sfhs", sfhs);                    // 是否含税
            orderData.put("jws", jws);                      // 价位税

            // 明细数据（需要根据实际数据库设计确定存储方式）
            // 如果明细是单独的表，可能需要单独处理
            orderData.put("OrderDetailList", orderList);         // 订单明细列表
            orderData.put("PaymentDetailList", OrderPayList);    // 付款明细列表

            Map<String, String> headers = new HashMap<>();
            headers.put("Content-Type", "application/x-www-form-urlencoded");

            result.put("data", orderData);
// 将result转换为JSON字符串
            String jsonStr = JSON.toJSONString(result);
// 构建form参数
            Map<String, Object> formParams = new HashMap<>();
            formParams.put("jsons", jsonStr);
// 发送请求
            HttpResponse response = null;
            if (actionType == "add") {
                response = HttpRequest.post("http://113.45.187.194:70/xk/dyzn/WsBasedyzn.asmx/hgdjydtbxsdd")
                        .headerMap(headers, true)
                        .form(formParams)
                        .timeout(30000)  // 30秒超时
                        .execute();
            } else {
                response = HttpRequest.post("http://113.45.187.194:70/xk/dyzn/WsBasedyzn.asmx/hgdjydtbupdatexsdd")
                        .headerMap(headers, true)
                        .form(formParams)
                        .timeout(30000)  // 30秒超时
                        .execute();
            }

            String responseBody = response.body();
            try {
                // 一行代码提取
                String jdbh = JSON.parseArray(responseBody)
                        .getJSONObject(0)
                        .getJSONObject("data")
                        .getString("djbh");
                String msg = JSON.parseArray(responseBody)
                        .getJSONObject(0)
                        .getString("msg");
                ydClient.operateData(
                        YDParam.builder()
                                .formInstanceId(formInstId)
                                .updateFormDataJson(JSONObject.toJSONString(UtilMap.map("textareaField_mkxqgrvq, textField_mjs6fuwo", msg, jdbh)))
                                .useLatestVersion(true).build(),
                        YDConf.FORM_OPERATION.update);

            } catch (Exception e) {
                System.out.println("解析JSON失败: " + e.getMessage());
            }
        } catch (Exception e) {
            // 异常处理
            result.put("table", "KD_YD_SALE_ORDER");
            result.put("action", "error");
            result.put("data", new HashMap<String, Object>() {{
                put("errorMsg", "操作失败：" + e.getMessage());
            }});
            // 可以添加日志记录
            // log.error("insertkdYdOrder error", e);
        }

        return result;
    }

    @Override
    public void SckdYdOrder(Map map) {
        MDC.put("MDC_KEY_PID", "1003");

        try {
            String formInstId = UtilMap.getString(map, "formInstId");
            String khbm = UtilMap.getString(map, "khbm");

            // 1. 查询订单详情
            DDR_New ddrNew = ydClient.queryData(YDParam.builder()
                    .formInstId(formInstId)
                    .build(), YDConf.FORM_QUERY.retrieve_id);

            if (ddrNew == null || ddrNew.getFormData() == null) {
                throw new RuntimeException("未找到订单信息");
            }

            Map formData1 = ddrNew.getFormData();
            String ddje = UtilMap.getString(formData1, "numberField_mfxv2vgj");

            // 参数校验
            if (ddje == null || ddje.trim().isEmpty()) {
                throw new RuntimeException("订单金额不能为空");
            }

            // 2. 计算订单金额（保留两位小数）
            Double orderAmount = null;
            try {
                orderAmount = Double.parseDouble(ddje);
                orderAmount = Math.round(orderAmount * 100.0) / 100.0;
            } catch (NumberFormatException e) {
                throw new RuntimeException("订单金额格式错误: " + ddje);
            }

            // 3. 查询客户历史信息
            List<Map> list = (List<Map>) ydClient.queryData(YDParam.builder()
                    .formUuid("FORM-F79B680547674A6BBD11C0D511E3C14B28FY")
                    .searchFieldJson(JSONObject.toJSONString(Arrays.asList(
                            new YDSearch("textField_mjm9k35n",
                                    khbm,
                                    "客户编号",
                                    YDSearch.Type.TEXT_FIELD,
                                    YDSearch.Operator.EQ)
                    )))
                    .build(), YDConf.FORM_QUERY.retrieve_list_all).getData();

            if (list == null || list.isEmpty()) {
                throw new RuntimeException("未找到客户信息，客户编号：" + khbm);
            }

            // 4. 获取客户现有信息
            Map customerData = list.get(0);
            Double historicalAmount = UtilMap.getDouble(customerData, "numberField_mjm9k35k");
            String dddateTimestampStr = UtilMap.getString(customerData, "dateField_mjqkkcsg");
            String sfdateTimestampStr = UtilMap.getString(customerData, "dateField_mjm9k35l");

            // 参数校验
            if (dddateTimestampStr == null || dddateTimestampStr.trim().isEmpty()) {
                throw new RuntimeException("最后成交日期不能为空");
            }

            // 处理历史金额
            if (historicalAmount == null) {
                historicalAmount = 0.0;
            } else {
                historicalAmount = Math.round(historicalAmount * 100.0) / 100.0;
            }

            // 5. 计算总金额
            Double totalAmount = orderAmount + historicalAmount;
            totalAmount = Math.round(totalAmount * 100.0) / 100.0;

            System.out.println("金额计算：订单金额=" + orderAmount +
                    ", 历史金额=" + historicalAmount +
                    ", 总金额=" + totalAmount);

            // 6. 时间戳转换
            long dddateTimestamp = Long.parseLong(dddateTimestampStr.trim());
            long currentTimestamp = System.currentTimeMillis();
            long sfdateTimestamp = (sfdateTimestampStr != null && !sfdateTimestampStr.trim().isEmpty())
                    ? Long.parseLong(sfdateTimestampStr.trim()) : 0;

            // 计算时间差（天数）
            long currentToDdDays = (currentTimestamp - dddateTimestamp) / (1000 * 60 * 60 * 24);
            long sfToDdDays = (sfdateTimestamp > 0) ? (sfdateTimestamp - dddateTimestamp) / (1000 * 60 * 60 * 24) : 0;

            System.out.println("时间计算：当前时间-" + timestampToDateString(String.valueOf(currentTimestamp)) +
                    ", 成交日期-" + timestampToDateString(dddateTimestampStr) +
                    ", 当前-成交相差=" + currentToDdDays + "天" +
                    ", 公海-成交相差=" + sfToDdDays + "天");

            String ghcDateTimestamp = null;
            String selectFieldValue = "";
            String khsx = "";

// 1. 设置客户属性（单独判断）
            if (totalAmount >= 75000 && sfToDdDays <= 180) {
                khsx = "自行开发";
            }

// 2. 第一个条件：当前时间-成交日期<90天 且 总金额>0 且 公海日期-成交日期≈180天
            if (currentToDdDays < 90 && totalAmount > 0 && Math.abs(sfToDdDays - 180) <= 1) {
                // 在成交日期上加90天
                ghcDateTimestamp = String.valueOf(calculateTimestamp(sfdateTimestamp, 90));
                selectFieldValue = "半年金额不足";
                System.out.println("条件1触发：公海池时间设为成交日期+90天=" +
                        timestampToDateString(ghcDateTimestamp));
            }
// 3. 第二个条件：总金额≥7.5万 且 公海日期-成交日期≤180天
            else if (totalAmount >= 75000 && sfToDdDays <= 180) {
                // 在成交日期上加180天
                ghcDateTimestamp = String.valueOf(calculateTimestamp(sfdateTimestamp, 180));
                selectFieldValue = "半年金额不足";
                System.out.println("条件2触发：公海池时间设为成交日期+180天=" +
                        timestampToDateString(ghcDateTimestamp));
            }
// 4. 第三个条件：金额<15万 且 公海日期-成交日期>180天
            else if (totalAmount < 150000 && sfToDdDays > 180) {
                selectFieldValue = "一年金额不足";
                System.out.println("条件3触发：金额<15万且公海日期>180天，设置一年金额不足");
            }
// 5. 其他情况
            else {
                if (totalAmount > 0) {
                    // 基础情况：金额大于0
                    ghcDateTimestamp = String.valueOf(calculateTimestamp(sfdateTimestamp, 90));
                    selectFieldValue = "半年金额不足";
                    System.out.println("基础情况：金额大于0，公海池时间+90天=" +
                            timestampToDateString(ghcDateTimestamp));
                } else if (totalAmount < 75000) {
                    // 金额 < 7.5万
                    selectFieldValue = "半年金额不足";
                    System.out.println("金额<7.5万，但未设置公海池时间");
                } else if (totalAmount < 150000) {
                    // 7.5万 ≤ 金额 < 15万
                    selectFieldValue = "一年金额不足";
                    System.out.println("金额7.5-15万，但未设置公海池时间");
                }
            }


            // 8. 构建更新数据
            Map<String, Object> formData = new HashMap<>();
            formData.put("dateField_mjm9k35j", dddateTimestampStr); // 最后成交日期（保持原时间戳）

            // 只有selectField有值时才设置
            if (!selectFieldValue.isEmpty()) {
                formData.put("selectField_l3nrjuq0", selectFieldValue);
            }

            if (ghcDateTimestamp != null) {
                formData.put("dateField_mjm9k35l", ghcDateTimestamp); // 释放公海日期
            } else {
                formData.put("dateField_mjm9k35l", ""); // 明确设置为空
            }

            // 更新累计金额（保留两位小数）
            formData.put("numberField_mjm9k35k", totalAmount);
            formData.put("selectField_mjsco9d4", khsx);

            System.out.println("更新客户数据：" + formData);

            // 9. 执行更新操作
            ydClient.operateData(YDParam.builder()
                    .formUuid("FORM-F79B680547674A6BBD11C0D511E3C14B28FY")
                    .appType("APP_VQDMMWS6OR1VHL8VMFD3")
                    .systemToken("XE766X81JHKXK4Z27SYOI86CPCLQ3J1LV7ODMH2")
                    .noExecuteExpression(false)
                    .searchFieldJson(JSONObject.toJSONString(Arrays.asList(
                            new YDSearch("textField_mjm9k35n",
                                    khbm,
                                    "客户编号",
                                    YDSearch.Type.TEXT_FIELD,
                                    YDSearch.Operator.EQ)
                    )))
                    .formDataJson(JSONObject.toJSONString(formData))
                    .build(), YDConf.FORM_OPERATION.upsert);

            System.out.println("客户信息更新成功，客户编号：" + khbm);

        } catch (Exception e) {
            System.err.println("处理订单失败: " + e.getMessage());
            e.printStackTrace();
            throw new RuntimeException("处理订单失败: " + e.getMessage(), e);
        } finally {
            MDC.remove("MDC_KEY_PID");
        }
    }

    /**
     * 计算时间戳：在基础时间戳上添加天数
     *
     * @param baseTimestamp 基础时间戳（毫秒）
     * @param days          要添加的天数
     * @return 计算后的时间戳（毫秒）
     */
    private long calculateTimestamp(long baseTimestamp, int days) {
        try {
            long oneDayMillis = 24L * 60L * 60L * 1000L;
            long daysMillis = (long) days * oneDayMillis;
            return baseTimestamp + daysMillis;
        } catch (Exception e) {
            System.err.println("时间戳计算失败：" + baseTimestamp + ", 天数：" + days);
            return baseTimestamp + (days * 24L * 60L * 60L * 1000L);
        }
    }

    /**
     * 辅助方法：将时间戳转换为可读日期（仅用于调试）
     */
    private String timestampToDateString(String timestamp) {
        try {
            long ts = Long.parseLong(timestamp.trim());
            SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
            return sdf.format(new Date(ts));
        } catch (Exception e) {
            return "无效时间戳：" + timestamp;
        }
    }

    /**
     * 重载方法：直接接收long类型时间戳
     */
    private String timestampToDateString(long timestamp) {
        try {
            SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
            return sdf.format(new Date(timestamp));
        } catch (Exception e) {
            return "无效时间戳：" + timestamp;
        }
    }

    private static LocalDateTime parseTimestamp(String timestampStr) {
        if (timestampStr == null || timestampStr.trim().isEmpty()) return null;
        try {
            long timestamp = Long.parseLong(timestampStr.trim());
            return LocalDateTime.ofInstant(
                    Instant.ofEpochMilli(timestamp),
                    ZoneId.systemDefault()
            );
        } catch (NumberFormatException e) {
            return null;
        }
    }

    private static int parseInt(String str, int defaultValue) {
        if (str == null || str.trim().isEmpty()) {
            return defaultValue;
        }
        try {
            return Integer.parseInt(str.trim());
        } catch (NumberFormatException e) {
            return defaultValue;
        }
    }

    private String safeGetString(Map formData, String key) {
        Object val = formData.get(key);
        return val == null ? "" : String.valueOf(val);
    }

    public static BigDecimal toBigDecimal(String str) {
        if (str == null || str.trim().isEmpty()) {
            return BigDecimal.ZERO.setScale(2, RoundingMode.HALF_UP);
        }
        try {
            return new BigDecimal(str.trim())
                    .setScale(2, RoundingMode.HALF_UP);
        } catch (NumberFormatException e) {
            // 返回默认值而不是抛出异常，避免程序中断
            return BigDecimal.ZERO.setScale(2, RoundingMode.HALF_UP);
        }
    }

    /**
     * 重载方法，支持Number类型输入
     */
    public static BigDecimal toBigDecimal(Number number) {
        if (number == null) {
            return BigDecimal.ZERO.setScale(2, RoundingMode.HALF_UP);
        }
        return new BigDecimal(number.toString())
                .setScale(2, RoundingMode.HALF_UP);
    }
}