using PadApplication.DB;
using PadApplication.Entites.DbModels;
using PadApplication.Entites.Dto;
using SqlSugar;

namespace PadApplication.Services;

public class MesQaItemsDetect02Manager : Repository<MesQaItemsDetect02>
{
    //当前类已经继承了 Repository 增、删、查、改的方法

    //根据工单号查首检
    public MesQaItemsDetect02 FindSJByOrderNo(OrderMachineDto query)
    {
        var list = Db.Queryable<MesQaItemsDetect02>()
            .LeftJoin<MesStaff>((sj, staff) => sj.FcheckBy == staff.StaffNo)
            .Where((sj, staff) =>
                sj.Ftype == "首检" && sj.Aufnr == query.orderNo &&
                sj.FcheckDate != null)
            .Select((sj, staff) => new MesQaItemsDetect02
            {
                Id = sj.Id,
                FcheckDate = sj.FcheckDate,
                FcheckResu = sj.FcheckResu,
                // FcheckBy与StaffName组合，如 "工号-姓名"
                FcheckBy = sj.FcheckBy + (staff.StaffName != null ? "-" + staff.StaffName : "")
            })
            .OrderBy(sj => sj.FcheckDate, OrderByType.Desc);

        if (list == null || list.Count() == 0)
        {
            var empty = new MesQaItemsDetect02();
            empty.xjCount = 0; // 可改为 sjCount，更语义化
            return empty;
        }

        var entity = list.First();
        entity.xjCount = list.Count(); // 可改为 sjCount，更语义化
        return entity;
    }

    //根据工单号查巡检
    public MesQaItemsDetect02 FindXJByOrderNo(OrderMachineDto query)
    {
        var list = Db.Queryable<MesQaItemsDetect02>()
            .LeftJoin<MesStaff>((xj, staff) => xj.FcheckBy == staff.StaffNo)
            .Where((xj, staff) =>
                xj.Ftype == "巡检" && xj.Aufnr == query.orderNo &&
                xj.FcheckDate != null)
            .Select((xj, staff) => new MesQaItemsDetect02
            {
                Id = xj.Id,
                FcheckDate = xj.FcheckDate,
                FcheckResu = xj.FcheckResu,
                // FcheckBy与StaffName组合，如 "工号-姓名"
                FcheckBy = xj.FcheckBy + (staff.StaffName != null ? "-" + staff.StaffName : "")
            })
            .OrderBy(xj => xj.FcheckDate, OrderByType.Desc);

        if (list == null || list.Count() == 0)
        {
            var empty = new MesQaItemsDetect02();
            empty.xjCount = 0;
            return empty;
        }

        var entity = list.First();
        entity.xjCount = list.Count();
        return entity;
    }

    /// <summary>
    ///     自动生成首检单
    /// </summary>
    /// <param name="billNo">工单号</param>
    /// <returns>是否成功</returns>
    public bool AutomaticIpqcFirstCheck(string billNo)
    {
        // 获取工单信息
        var womdaa = Db.Queryable<Womdaa>().Where(a => a.Daa001 == billNo)
            .First();
        if (womdaa == null) return false;

        // 获取产品信息
        var mesItems = Db.Queryable<MesItems2>()
            .Where(a => a.AddressCode == "ALL" && a.ItemNo == womdaa.Daa002)
            .First();
        if (mesItems == null) return false;

        // 获取部门信息
        var departmentNo = womdaa.DepartmentNo;

        // 获取产品标准型号
        // string qcModel;
        // try
        // {
        //     qcModel = Db.Queryable<MesItems2>()
        //         .Where(a => a.ItemNo == womdaa.Daa002 && a.AddressCode == "HK")
        //         .Select(a => a.QcModel)
        //         .First();
        // }
        // catch
        // {
        //     qcModel = "Q1";
        // }

        return UseTransaction(db =>
        {
            // 工单处理
            //if (departmentNo == "XS0101")
            if (departmentNo == "MS0102" || departmentNo == "MS01" || departmentNo == "MS0103")//部门兼容
            {
                // 检查是否已存在首检单
                // var existingCheck = Db.Queryable<MesQaItemsDetect02>()
                //     .Where(a => a.Aufnr == billNo && a.Ftype == "首检")
                //     .First();

                // if (existingCheck == null)
                // {
                // 生成首检单号
                var orderNo = GetBillCode();

                // 创建首检单头信息
                var detect = new MesQaItemsDetect02
                {
                    ReleaseNo = orderNo,
                    Aufnr = billNo,
                    LineNo = womdaa.MachineNo,
                    Fsubmit = 0,
                    LotNo = DateTime.Now.ToString("yyyyMMdd"),
                    Ftype = "首检",
                    ItemNo = womdaa.Daa002,
                    CreateBy = "Admin",
                    CreateDate = DateTime.Now,
                    Ismodify1 = 0,
                    Factory = "1000",
                    Fversion = 0,
                    MenuId = 101,
                    Company = "1000",
                    FprodType = "量产",
                    FprodDate = womdaa.Daa006,
                    PlanQty = womdaa.Daa008,
                    Remeke = womdaa.Daa009,
                    DepartmentNo = womdaa.DepartmentNo
                };

                // 插入首检单
                Db.Insertable(detect).IgnoreColumns(true).ExecuteCommand();

                // 插入检验项目
                var checkItems = Db.Queryable<MesQmCheckitemsDt2>()
                    .LeftJoin<MesQmCheckitems2>((t, t2) => t.Pid == t2.Id)
                    .LeftJoin<vMesPqcZsth>((t, t2, b) => t2.ItemNo == b.ItemNo)
                    .Where((t, t2, b) => b.QcItem == womdaa.Daa002)
                    .OrderBy(t => t.Forder)
                    .Select((t, t2, b) => new
                    {
                        t.FcheckItem,
                        t.FcheckTool,
                        t.Fstand,
                        t.FupAllow,
                        t.FdownAllow,
                        t.Forder,
                        t.CheckQty,
                        t.FacQty,
                        t.FspecRequ
                    })
                    .ToList();

                foreach (var item in checkItems)
                {
                    var detail = new MesQaItemsDetectDetail6
                    {
                        FcheckItem = item.FcheckItem,
                        FcheckTool = item.FcheckTool,
                        Fstand = item.Fstand,
                        FupAllow = item.FupAllow,
                        FdownAllow = item.FdownAllow,
                        ForderNo = item.Forder,
                        ReleaseNo = orderNo,
                        CheckQty = item.CheckQty,
                        AcceptableQty = item.FacQty,
                        Company = "1000",
                        Factory = "1000",
                        FspecRequ = item.FspecRequ
                    };

                    Db.Insertable(detail).IgnoreColumns(true).ExecuteCommand();
                }
                // }

                // 更新工单状态表
                var orderSta = Db.Queryable<MesOrderSta>()
                    .Where(a => a.OrderId == womdaa.Id)
                    .First();

                if (orderSta != null) return 1;
                var newSta = new MesOrderSta
                {
                    OrderId = womdaa.Id,
                    OrderNo = womdaa.Daa001,
                    // StartTime =
                    //     DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
                    MachineNo = womdaa.MachineNo
                };
                Db.Insertable(newSta).IgnoreColumns(true).ExecuteCommand();
                // else
                // {
                //     Db.Updateable<MesOrderSta>()
                //         .SetColumns(a =>
                //             a.StartTime ==
                //             DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"))
                //         .Where(a => a.OrderId == womdaa.Id)
                //         .ExecuteCommand();
                // }

                return 1;
            }

            return 0;
        }) > 0;
    }

    /// <summary>
    ///     获取单据编号
    /// </summary>
    /// <param name="company">公司代码</param>
    /// <param name="factory">工厂代码</param>
    /// <param name="prefix">单据前缀</param>
    /// <returns>生成的单据编号</returns>
    private string GetBillCode()
    {
        // 获取当前日期
        var date = DateTime.Now.ToString("yyMMdd");

        // 查询当天最大流水号
        var maxCode = Db.Queryable<MesQaItemsDetect02>()
            .Where(s => s.Company == "1000" && s.Factory == "1000")
            .Where(s => s.ReleaseNo.StartsWith("QCSN" + date))
            .OrderBy(s => s.ReleaseNo, OrderByType.Desc)
            .Select(s => s.ReleaseNo)
            .First();

        // 生成新的流水号
        var sequence = 1;
        if (!string.IsNullOrEmpty(maxCode))
            sequence = int.Parse(maxCode.Substring(10)) + 1;

        // 组装单据编号 QCSN + 年月日 + 5位流水号
        return $"QCSN{date}{sequence:D5}";
    }
}