OASystemAPI/OASystem/OASystem.Domain/Entities/Groups/Grp_AirTicketReservations.cs

using System.Text.RegularExpressions;

namespace OASystem.Domain.Entities.Groups;

/// <summary>
/// 机票费用录入
/// </summary>
[SugarTable("Grp_AirTicketReservations")]
public class Grp_AirTicketReservations : EntityBase
{
    /************************* 2026版数据结构 *************************/

    /// <summary>
    /// 团组外键编号
    /// </summary>
    [SugarColumn(IsNullable = true, ColumnDataType = "int")]
    public int DIId { get; set; }


    /// <summary>
    /// 数据标识：0-旧数据 1-新数据
    /// </summary>
    [SugarColumn(IsNullable = true, ColumnDataType = "int")]
    public int IsNew { get; set; }

    /// <summary>
    /// 记录类型：0-正常机票 1-退票记录
    /// </summary>
    [SugarColumn(IsNullable = true, ColumnDataType = "int")]
    public int RecordType { get; set; } = 0;

    /// <summary>
    /// 关联的原始机票记录ID（退票记录指向原机票记录）
    /// </summary>
    [SugarColumn(IsNullable = true, ColumnDataType = "int")]
    public int OriginalReservationId { get; set; }

    /// <summary>
    /// 航段代码描述
    /// </summary>
    [SugarColumn(IsNullable = true, ColumnDataType = "varchar(500)")]
    public string FlightsDescription { get; set; }

    /// <summary>
    /// 航班基础信息（去程、联程、返程）
    /// </summary>
    [SugarColumn(IsNullable = true, IsJson = true, ColumnDataType = "varchar(500)")]
    public List<AirTicketBasicInfo> AirTicketBasicInfos { get; set; } = new List<AirTicketBasicInfo>();

    /// <summary>
    /// 客人名称
    /// RecordType = 0 时，存储正常机票的客人名称；RecordType = 1 时，存储退票记录的客人名称（可能与原机票记录不同）
    /// </summary>
    [SugarColumn(IsNullable = true, ColumnDataType = "varchar(200)")]
    public string ClientName { get; set; }

    /// <summary>
    /// 客户人数
    /// </summary>
    [SugarColumn(IsNullable = true, ColumnDataType = "int")]
    public int ClientNum { get; set; }

    /// <summary>
    /// 舱类型(数据类型外键)
    /// </summary>
    [SugarColumn(IsNullable = true, ColumnDataType = "int")]
    public int CType { get; set; }

    /// <summary>
    /// 机票全价
    /// </summary>
    [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
    public decimal Price { get; set; }

    /// <summary>
    /// 币种
    /// </summary>
    [SugarColumn(IsNullable = true, ColumnDataType = "int")]
    public int Currency { get; set; }

    /// <summary>
    /// 费用信息(含退票信息)
    /// </summary>
    [SugarColumn(IsNullable = true, IsJson = true, ColumnDataType = "varchar(max)")]
    public List<CustTicketInfo> CustTicketInfos { get; set; } = new List<CustTicketInfo>();

    /// <summary>
    /// 报价说明
    /// </summary>
    [SugarColumn(IsNullable = true, ColumnDataType = "varchar(500)")]
    public string PriceDescription { get; set; }

    /************************* 2026版数据结构 *************************/

    #region 旧版兼容以前的数据结构，2026版不使用

    /// <summary>
    /// 航班号
    /// </summary>
    [SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")]
    public string FlightsCode { get; set; }

    /// <summary>
    /// 城市A-B
    /// </summary>
    [SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")]
    public string FlightsCity { get; set; }

    /// <summary>
    /// 航班日期
    /// </summary>
    [SugarColumn(IsNullable = true, ColumnDataType = "varchar(30)")]
    public string FlightsDate { get; set; }

    /// <summary>
    /// 航班时间
    /// </summary>
    [SugarColumn(IsNullable = true, ColumnDataType = "varchar(30)")]
    public string FlightsTime { get; set; }

    /// <summary>
    /// 抵达时间
    /// </summary>
    [SugarColumn(IsNullable = true, ColumnDataType = "varchar(30)")]
    public string ArrivedTime { get; set; }

    /// <summary>
    /// 是否值机
    /// 0 否 1 是
    /// </summary>
    [SugarColumn(IsNullable = true, ColumnDataType = "int")]
    public int IsCheckIn { get; set; }
    /// <summary>
    /// 是否选座
    /// 0 否 1 是
    /// </summary>
    [SugarColumn(IsNullable = true, ColumnDataType = "int")]
    public int IsSetSeat { get; set; }

    /// <summary>
    /// 是否购买行李服务
    /// 0 否 1 是
    /// </summary>
    [SugarColumn(IsNullable = true, ColumnDataType = "int")]
    public int IsPackage { get; set; }
    /// <summary>
    /// 是否行李直挂
    /// 0 否 1 是
    /// </summary>
    [SugarColumn(IsNullable = true, ColumnDataType = "int")]
    public int IsBagHandle { get; set; }
    /// <summary>
    /// 是否火车票出票选座
    /// 0 否 1 是
    /// </summary>
    [SugarColumn(IsNullable = true, ColumnDataType = "int")]
    public int IsTrain { get; set; }

    /// <summary>
    /// 去程航班描述代码
    /// </summary>
    [SugarColumn(IsNullable = true, ColumnDataType = "varchar(500)")]
    public string LeaveDescription { get; set; }
    /// <summary>
    /// 返程航班描述代码
    /// </summary>
    [SugarColumn(IsNullable = true, ColumnDataType = "varchar(500)")]
    public string ReturnDescription { get; set; }
    /// <summary>
    /// 出票前报价
    /// </summary>
    [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
    public decimal PrePrice { get; set; }
    /// <summary>
    /// 出票前报价币种
    /// </summary>
    [SugarColumn(IsNullable = true, ColumnDataType = "int")]
    public int PreCurrency { get; set; }
   
    /// <summary>
    /// 机票编号
    /// </summary>
    [SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")]
    public string TicketNumber { get; set; }
    /// <summary>
    /// 机票票号
    /// </summary>
    [SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")]
    public string TicketCode { get; set; }

    /// <summary>
    /// 客人类型(数据类型外键)
    /// </summary>
    [SugarColumn(IsNullable = true, ColumnDataType = "int")]
    public int PassengerType { get; set; }
    #endregion

}

/// <summary>
/// 机票基础信息
/// </summary>
public class AirTicketBasicInfo
{
    /// <summary>
    /// 序号
    /// </summary>
    public int No { get; set; }

    /// <summary>
    /// 航班号
    /// </summary>
    public string FlightsCode { get; set; }

    /// <summary>
    /// 城市A-B
    /// </summary>
    public string FlightsCity { get; set; }

    /// <summary>
    /// 航班日期
    /// </summary>
    public string FlightsDate { get; set; }

    /// <summary>
    /// 航班时间
    /// </summary>
    public string FlightsTime { get; set; }

    /// <summary>
    /// 抵达时间
    /// </summary>
    public string ArrivedTime { get; set; }

    /// <summary>
    /// 出发航站楼
    /// </summary>
    public string DepartureTerminal { get; set; }

    /// <summary>
    /// 抵达航站楼
    /// </summary>
    public string ArrivalTerminal { get; set; }

    /// <summary>
    /// 机型（如：359、321、32A、73H）
    /// </summary>
    public string AircraftType { get; set; }

    /// <summary>
    /// 耗时（如：11H10M、00H55M、01H35M）
    /// </summary>
    public string Duration { get; set; }

}

/// <summary>
/// 客户机票信息
/// </summary>
public class CustTicketInfo
{
    /// <summary>
    /// 客户ID
    /// </summary>
    public int ClientId { get; set; }

    /// <summary>
    /// 舱类型(数据类型外键)
    /// </summary>
    public int CType { get; set; }

    /// <summary>
    /// 实际价格
    /// </summary>
    public decimal ActualPrice { get; set; }

    /// <summary>
    /// 机票票号
    /// </summary>
    public string TicketCode { get; set; }

    /// <summary>
    /// 机票编号
    /// </summary>
    public string TicketNumber { get; set; }

    /// <summary>
    /// 选中服务ID集合
    /// </summary>
    public List<int> SelectedServiceIds { get; set; } = new List<int>();

    /// <summary>
    /// 附加服务 json数组
    /// </summary>
    public List<AdditionalService> AdditionalServices { get; set; } = new List<AdditionalService>();

    /// <summary>
    /// 机票总费用
    /// 实际价格 + 附加服务费
    /// </summary>
    public decimal TotalTicketPrice { get; set; }

    /// <summary>
    /// 是否已退票
    /// </summary>
    public bool IsRefund { get; set; } = false;

    /// <summary>
    /// 退票记录
    /// </summary>
    public RefundRecord RefundRecord { get; set; } = new RefundRecord();

}

/// <summary>
/// 退票记录
/// </summary>
public class RefundRecord
{
    /// <summary>
    /// 退票金额
    /// </summary>
    public decimal RefundAmount { get; set; }

    /// <summary>
    /// 不可退税费
    /// </summary>
    public decimal NonRefundableTax { get; set; }

    /// <summary>
    /// 退票时间
    /// </summary>
    public string RefundTime { get; set; }

    /// <summary>
    /// 退款账户 
    /// Setdata Id
    /// </summary>
    public int RefundAccount { get; set; }

    /// <summary>
    /// 退票原因
    /// </summary>
    public string RefundReason { get; set; }
}

/// <summary>
/// 附加服务
/// </summary>
public class AdditionalService
{
    //public int Id { get; set; }

    /// <summary>
    /// 服务类型Id（Sys_SetData）
    /// </summary>
    public int ServiceTypeId { get; set; }

    /// <summary>
    /// 金额
    /// </summary>
    public decimal Amount { get; set; }

    /// <summary>
    /// 报价说明
    /// </summary>
    public string PriceDescription { get; set; }

    #region Credit Info
    /// <summary>
    /// 支付方式
    /// </summary>
    public int PayDId { get; set; }
    /// <summary>
    /// 消费方式
    /// </summary>
    public string ConsumptionPatterns { get; set; }
    /// <summary>
    /// 消费日期
    /// </summary>
    public string ConsumptionDate { get; set; }
    /// <summary>
    /// 付款金额
    /// </summary>
    public decimal PayMoney { get; set; }
    /// <summary>
    /// 付款币种 数据类型Id
    /// </summary>
    public int PaymentCurrency { get; set; }
    /// <summary>
    /// 卡类型
    /// </summary>
    public int CTDId { get; set; }
    /// <summary>
    /// 银行卡号
    /// </summary>
    public string BankNo { get; set; }
    /// <summary>
    /// 持卡人姓名
    /// </summary>
    public string CardholderName { get; set; }
    /// <summary>
    /// 当天汇率
    /// </summary>
    public decimal DayRate { get; set; }
    /// <summary>
    /// 公司银行卡号
    /// </summary>
    public string CompanyBankNo { get; set; }
    /// <summary>
    /// 对方开户行
    /// </summary>
    public string OtherBankName { get; set; }
    /// <summary>
    /// 对方银行账号
    /// </summary>
    public string OtherSideNo { get; set; }
    /// <summary>
    /// 对方姓名
    /// </summary>
    public string OtherSideName { get; set; }
    /// 收款方
    /// </summary>
    public string Payee { get; set; }

    /// <summary>
    /// 费用标识
    /// 0 公转 1 私转
    /// </summary>
    public int OrbitalPrivateTransfer { get; set; }
    /// <summary>
    /// 备注
    /// </summary>
    public string Remark { get; set; }

    /// <summary>
    /// 总经理是否审核  
    /// 0 未审核 
    /// 1 已通过 
    /// 2 未通过 
    /// 3 自动审核
    /// </summary>
    public int IsAuditGM { get; set; } = 0;

    /// <summary>
    ///  审核状态描述
    /// </summary>
    public string IsAuditGMStr => IsAuditGM switch
    {
        0 => "未审核",
        1 => "已通过",
        2 => "未通过",
        3 => "自动审核",
        _ => "未知状态"
    };

    /// <summary>
    /// 总经理审核人
    /// </summary>
    public int AuditGMOperate { get; set; }

    /// <summary>
    /// 总经理审核时间
    /// </summary>
    public string AuditGMDate { get; set; }

    /// <summary>
    /// 审核描述
    /// </summary>
    public string AuditStr { get; set; }
    #endregion

}

/// <summary>
/// 航班信息
/// </summary>
public class FlightInfo
{
    /// <summary>
    /// 航段序号
    /// </summary>
    public int SequenceNo { get; set; }

    /// <summary>
    /// 航班号
    /// 例如：CA431
    /// </summary>
    public string FlightNumber { get; set; }

    /// <summary>
    /// 星期
    /// 例如：TU
    /// </summary>
    public string WeekDay { get; set; }

    /// <summary>
    /// 起飞日期
    /// </summary>
    public DateTime DepartureDate { get; set; }

    /// <summary>
    /// 出发机场三字码
    /// 例如：TFU
    /// </summary>
    public string DepartureAirport { get; set; }

    /// <summary>
    /// 到达机场三字码
    /// 例如：FRA
    /// </summary>
    public string ArrivalAirport { get; set; }

    /// <summary>
    /// 起飞时间
    /// 格式：HH:mm
    /// </summary>
    public string DepartureTime { get; set; }

    /// <summary>
    /// 到达时间
    /// 格式：HH:mm
    /// </summary>
    public string ArrivalTime { get; set; }

    /// <summary>
    /// 是否跨天到达
    /// </summary>
    public bool IsNextDayArrival { get; set; }

    /// <summary>
    /// 跨天数量
    /// 例如：
    /// +1 表示次日到达
    /// +2 表示第三天到达
    /// </summary>
    public int NextDayCount { get; set; }

    /// <summary>
    /// 出发航站楼
    /// 例如：T1
    /// </summary>
    public string DepartureTerminal { get; set; }

    /// <summary>
    /// 到达航站楼
    /// 例如：T2
    /// </summary>
    public string ArrivalTerminal { get; set; }

    /// <summary>
    /// 机型代码
    /// 例如：
    /// 359=A350-900
    /// 321=A321
    /// 32A=A320neo
    /// </summary>
    public string AircraftType { get; set; }

    /// <summary>
    /// 飞行时长
    /// 例如：11H10M
    /// </summary>
    public string Duration { get; set; }

    /// <summary>
    /// 原始文本
    /// </summary>
    public string RawText { get; set; }
}

/// <summary>
/// 航班解析器 - 支持多种格式
/// </summary>
public static class FlightParser
{
    private static readonly Dictionary<string, int> MonthMap = new()
    {
        ["JAN"] = 1,
        ["FEB"] = 2,
        ["MAR"] = 3,
        ["APR"] = 4,
        ["MAY"] = 5,
        ["JUN"] = 6,
        ["JUL"] = 7,
        ["AUG"] = 8,
        ["SEP"] = 9,
        ["OCT"] = 10,
        ["NOV"] = 11,
        ["DEC"] = 12
    };

    public static List<FlightInfo> ParseFlights(string text)
    {
        var result = new List<FlightInfo>();

        if (string.IsNullOrWhiteSpace(text))
            return result;

        // 匹配所有以数字开头的行
        var matches = Regex.Matches(
            text,
            @"\d+\..*?(?=\d+\.|$)",
            RegexOptions.Singleline);

        foreach (Match match in matches)
        {
            var flight = ParseLine(match.Value.Trim());
            if (flight != null)
            {
                result.Add(flight);
            }
        }

        result = result.OrderBy(x => x.SequenceNo).ToList();
        FixYear(result);

        return result;
    }

    private static FlightInfo ParseLine(string line)
    {
        var seqMatch = Regex.Match(line, @"^(\d+)\.");
        if (!seqMatch.Success)
            return null;

        var flight = new FlightInfo
        {
            SequenceNo = int.Parse(seqMatch.Groups[1].Value),
            RawText = line
        };

        string content = line.Substring(seqMatch.Length).Trim();
        var parts = Regex.Split(content, @"\s+")
            .Where(p => !string.IsNullOrWhiteSpace(p))
            .ToList();

        if (parts.Count < 5)
            return null;

        int idx = 0;

        // 1. 航班号
        flight.FlightNumber = parts[idx++];

        // 2. 跳过可选的舱位代码（单个大写字母）
        if (idx < parts.Count && Regex.IsMatch(parts[idx], @"^[A-Z]$"))
        {
            idx++;
        }

        // 3. 解析日期（格式：TU23JUN 或 TU27MAY）
        if (idx >= parts.Count)
            return null;

        string dateText = parts[idx++];

        // 提取星期和日期
        var dateMatch = Regex.Match(dateText, @"^([A-Z]{2})(\d{2})([A-Z]{3})$");
        if (dateMatch.Success)
        {
            flight.WeekDay = dateMatch.Groups[1].Value;
            flight.DepartureDate = ParseDate(
                int.Parse(dateMatch.Groups[2].Value),
                dateMatch.Groups[3].Value
            );
        }
        else
        {
            // 兼容旧格式：TU27MAY 直接解析
            flight.WeekDay = dateText.Length >= 2 ? dateText[..2] : "";
            flight.DepartureDate = ParseMonthDay(dateText);
        }

        // 4. 航线（6位：出发+到达）
        if (idx >= parts.Count)
            return null;

        string route = parts[idx++];
        if (route.Length >= 6)
        {
            flight.DepartureAirport = route[..3];
            flight.ArrivalAirport = route.Substring(3, 3);
        }

        // 5. 跳过预订状态码（如 HK4, HK, KL 等）
        if (idx < parts.Count && Regex.IsMatch(parts[idx], @"^[A-Z]{2}\d*$"))
        {
            idx++;
        }

        // 6. 起飞时间
        if (idx >= parts.Count)
            return null;
        flight.DepartureTime = FormatTime(parts[idx++]);

        // 7. 到达时间
        if (idx >= parts.Count)
            return null;

        string arrivalRaw = parts[idx++];
        ParseArrivalTime(arrivalRaw, flight);

        // 8. 跳过可选的舱位代码（如 E）
        if (idx < parts.Count && Regex.IsMatch(parts[idx], @"^[A-Z]$"))
        {
            idx++;
        }

        // 9. 解析剩余字段（航站楼、机型、飞行时长）
        var remain = parts.Skip(idx).ToList();
        ParseRemainFields(remain, flight);

        return flight;
    }

    /// <summary>
    /// 解析到达时间（支持 +1 格式）
    /// </summary>
    private static void ParseArrivalTime(string arrivalRaw, FlightInfo flight)
    {
        if (arrivalRaw.Contains('+'))
        {
            var arr = arrivalRaw.Split('+');
            flight.ArrivalTime = FormatTime(arr[0]);
            flight.IsNextDayArrival = true;
            if (arr.Length > 1 && int.TryParse(arr[1], out int days))
            {
                flight.NextDayCount = days;
            }
        }
        else
        {
            flight.ArrivalTime = FormatTime(arrivalRaw);
        }
    }

    /// <summary>
    /// 解析剩余字段（航站楼、机型、飞行时长）
    /// </summary>
    private static void ParseRemainFields(List<string> remain, FlightInfo flight)
    {
        if (remain.Count == 0)
            return;

        // 从后往前解析
        int idx = remain.Count - 1;

        // 1. 最后一个字段：飞行时长（格式：11H10M 或 00H55M）
        if (idx >= 0 && Regex.IsMatch(remain[idx], @"^\d{2}H\d{2}M$"))
        {
            flight.Duration = remain[idx];
            idx--;
        }

        // 2. 倒数第二个字段：机型（格式：359, 321, 32A, 737 等）
        if (idx >= 0 && Regex.IsMatch(remain[idx], @"^[A-Z]?\d{2,3}[A-Z]?$"))
        {
            flight.AircraftType = remain[idx];
            idx--;
        }

        // 3. 剩余字段解析航站楼
        // 情况1：一个航站楼（出发和到达相同）
        if (idx == 0)
        {
            flight.DepartureTerminal = NormalizeTerminal(remain[0]);
            flight.ArrivalTerminal = flight.DepartureTerminal;
        }
        // 情况2：两个航站楼（出发和到达不同）
        else if (idx >= 1)
        {
            // 检查是否是两个航站楼
            string terminal1 = remain[0];
            string terminal2 = remain[1];

            // 如果两个都是航站楼格式（T1, T2, 1, 2, T3等）
            if (IsTerminalFormat(terminal1) && IsTerminalFormat(terminal2))
            {
                flight.DepartureTerminal = NormalizeTerminal(terminal1);
                flight.ArrivalTerminal = NormalizeTerminal(terminal2);
            }
            // 如果第一个是航站楼，第二个不是，则只解析第一个
            else if (IsTerminalFormat(terminal1))
            {
                flight.DepartureTerminal = NormalizeTerminal(terminal1);
            }
        }
    }

    /// <summary>
    /// 判断是否为航站楼格式
    /// </summary>
    private static bool IsTerminalFormat(string value)
    {
        if (string.IsNullOrWhiteSpace(value))
            return false;

        value = value.Trim().ToUpper();
        // 匹配：T1, T2, T3, 1, 2, 3 等
        return Regex.IsMatch(value, @"^T?\d+$");
    }

    /// <summary>
    /// 标准化航站楼
    /// </summary>
    private static string NormalizeTerminal(string terminal)
    {
        if (string.IsNullOrWhiteSpace(terminal))
            return null;

        terminal = terminal.Trim().ToUpper();

        // 纯数字补 T
        if (Regex.IsMatch(terminal, @"^\d+$"))
        {
            return $"T{terminal}";
        }

        return terminal;
    }

    /// <summary>
    /// 格式化时间
    /// </summary>
    private static string FormatTime(string time)
    {
        if (string.IsNullOrWhiteSpace(time))
            return string.Empty;

        time = time.Split('+')[0];

        if (time.Length == 4)
        {
            return $"{time[..2]}:{time.Substring(2, 2)}";
        }

        if (time.Length == 3)
        {
            return $"0{time[0]}:{time.Substring(1, 2)}";
        }

        return time;
    }

    /// <summary>
    /// 解析日期
    /// </summary>
    private static DateTime ParseDate(int day, string month)
    {
        if (!MonthMap.TryGetValue(month.ToUpper(), out int monthNum))
            return DateTime.MinValue;

        return new DateTime(DateTime.Now.Year, monthNum, day);
    }

    /// <summary>
    /// 解析月日（兼容旧格式）
    /// </summary>
    private static DateTime ParseMonthDay(string value)
    {
        value = Regex.Replace(value, @"^[A-Z]{2}", "");

        var match = Regex.Match(value, @"(\d{2})([A-Z]{3})");
        if (!match.Success)
            return DateTime.MinValue;

        int day = int.Parse(match.Groups[1].Value);
        if (!MonthMap.TryGetValue(match.Groups[2].Value, out int month))
            return DateTime.MinValue;

        return new DateTime(DateTime.Now.Year, month, day);
    }

    /// <summary>
    /// 自动修正跨年
    /// </summary>
    private static void FixYear(List<FlightInfo> flights)
    {
        if (flights.Count <= 1)
            return;

        int currentYear = DateTime.Now.Year;
        DateTime previousDate = DateTime.MinValue;

        foreach (var flight in flights)
        {
            if (flight.DepartureDate == DateTime.MinValue)
                continue;

            var date = new DateTime(
                currentYear,
                flight.DepartureDate.Month,
                flight.DepartureDate.Day);

            if (previousDate != DateTime.MinValue && date < previousDate)
            {
                currentYear++;
                date = new DateTime(
                    currentYear,
                    flight.DepartureDate.Month,
                    flight.DepartureDate.Day);
            }

            flight.DepartureDate = date;
            previousDate = date;
        }
    }
}