using CsvHelper;
using System.Globalization;
using TDA;
using TDA.FileIO;
using TDA.TypeDef;
using TDA.Utilities;

namespace Ex106.ExportPartSummary
{
    /// <summary>
    /// <b>Ex106.ExportPartSummary</b> — 导出 Part/Device 信息列表到 CSV 文件。
    /// <para>
    /// 对应 CLI 命令 <c>dp export psum</c>(别名 <c>dsum</c>),
    /// 输出每颗芯片的 Part 信息,包含 Pass/Fail 状态、HardBin/SoftBin、坐标、数据来源等字段。
    /// </para>
    /// </summary>
    /// <remarks>
    /// 使用步骤:
    /// <list type="number">
    ///   <item><b>选择数据源</b>:通过文件对话框选择 STDF 文件或 JSON setup 配置文件。</item>
    ///   <item><b>加载与解析</b>:调用 DataPrism.Load() 和 DoStatisticAnalysis()。</item>
    ///   <item><b>导出 CSV</b>:遍历 PartsDescription,将每颗芯片的信息写入 CSV 文件。</item>
    /// </list>
    /// </remarks>
    public class ExportPartSummary
    {
        /// <summary>
        /// 导出 Part/Device 信息的主流程。
        /// </summary>
        public static void Test()
        {
            // ── 1. 选择数据源 ──────────────────────────────────
            DataPrism? dataPrism = TDAFileDialog.OpenDataPrism();
            if (dataPrism is null)
            {
                Msg.Warning("No valid data source selected.");
                return;
            }

            // ── 2. 加载并解析数据 ─────────────────────────────
            dataPrism.Load();
            dataPrism.DoStatisticAnalysis();

            // ── 3. 生成输出文件路径(保存到第一个数据源同目录)─
            var filePath = dataPrism.DataSourcesInfoList[0].FilePath;
            string dir = Path.GetDirectoryName(filePath)
                         ?? Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
            string outFilePath = Path.Combine(dir,
                $"{Path.GetFileNameWithoutExtension(filePath)}.psum.csv");

            // ── 4. 导出 CSV ──────────────────────────────────
            ExportToCsv(dataPrism, outFilePath);

            Msg.Information($"Part summary exported to: {outFilePath}");
        }

        /// <summary>
        /// 将 DataPrism 中的 Part 信息导出到指定 CSV 文件。
        /// 输出列(与 CLI design 6.3 保持一致):
        /// PartIndex / PartID / HardBin / SoftBin / IsPass / IsFinalData /
        /// TestRound / Site / X / Y / FirstFailTest / DataSourceID / FilePath / Time
        /// </summary>
        /// <param name="dataPrism">已加载并分析完毕的 DataPrism 实例。</param>
        /// <param name="outFilePath">目标 CSV 文件路径。</param>
        public static void ExportToCsv(DataPrism dataPrism, string outFilePath)
        {
            using var writer = new StreamWriter(outFilePath);
            using var csv = new CsvWriter(writer, CultureInfo.InvariantCulture);

            // ── 写入表头 ──────────────────────────────────────
            csv.WriteField("PartIndex");
            csv.WriteField("PartID");
            csv.WriteField("HardBin");
            csv.WriteField("SoftBin");
            csv.WriteField("IsPass");
            csv.WriteField("IsFinalData");
            csv.WriteField("TestRound");
            csv.WriteField("Site");
            csv.WriteField("X");
            csv.WriteField("Y");
            csv.WriteField("FirstFailTest");
            csv.WriteField("DataSourceID");
            csv.WriteField("FilePath");
            csv.WriteField("Time");
            csv.NextRecord();

            // ── 写入每颗芯片数据 ──────────────────────────────
            int partCnt = dataPrism.PartsDescription.Length;
            var dataSources = dataPrism.DataSourcesInfoList;

            for (int i = 0; i < partCnt; i++)
            {
                ref PartInfo part = ref dataPrism.PartsDescription.GetRef(i);

                csv.WriteField(i);                          // PartIndex
                csv.WriteField(part.PartID ?? string.Empty); // PartID
                csv.WriteField(part.HardBinNumber);          // HardBin
                csv.WriteField(part.SoftBinNumber);          // SoftBin
                csv.WriteField(part.IsPass ? "PASS" : "FAIL"); // IsPass
                csv.WriteField(part.IsFinalData);            // IsFinalData
                csv.WriteField(part.TestRoundNumber);        // TestRound
                csv.WriteField(part.SiteNumber);             // Site
                csv.WriteField(part.X);                      // X
                csv.WriteField(part.Y);                      // Y

                // FirstFailTest: 全通过时输出 "PASS",否则输出测试编号
                if (part.FirstFailTestNum == CONST.TESTNUM4PASS)
                    csv.WriteField("PASS");
                else
                    csv.WriteField(part.FirstFailTestNum.ToString());

                csv.WriteField(part.DataSourceInfoID);       // DataSourceID

                // FilePath: 通过 DataSourceInfoID 索引获取来源文件路径
                if (part.DataSourceInfoID >= 0 && part.DataSourceInfoID < dataSources.Count)
                    csv.WriteField(dataSources[part.DataSourceInfoID].FilePath);
                else
                    csv.WriteField(string.Empty);

                csv.WriteField(part.TestTime);               // Time (ms)

                csv.NextRecord();
            }

            csv.Flush();
        }
    }
}