OA2023/OASystem/OASystem.Domain/Entities/Groups/Grp_ProcessOverview.cs

using AutoMapper.Configuration.Annotations;
using Newtonsoft.Json;
using OASystem.Domain.Enums;
using System.ComponentModel;

namespace OASystem.Domain.Entities.Groups
{
    /// <summary>
    /// 团组流程总览
    /// </summary>
    [SugarTable("Grp_ProcessOverview", "团组流程总览表")]
    public class Grp_ProcessOverview : EntityBase
    {
        /// <summary>
        /// 团组Id
        /// </summary>
        [SugarColumn(ColumnName = "GroupId", ColumnDescription = "团组Id", IsNullable = true, ColumnDataType = "int")]
        public int GroupId { get; set; }

        /// <summary>
        /// 流程顺序
        /// </summary>
        [SugarColumn(ColumnName = "ProcessOrder", ColumnDescription = "流程顺序", IsNullable = true, ColumnDataType = "int")]
        public int ProcessOrder { get; set; }

        /// <summary>
        /// 流程类型 
        /// </summary>
        [SugarColumn(ColumnName = "ProcessType", ColumnDescription = "流程类型", ColumnDataType = "int")]
        public GroupProcessType ProcessType { get; set; }

        /// <summary>
        /// 整体状态 
        /// </summary>
        [SugarColumn(ColumnName = "OverallStatus", ColumnDescription = "流程整体状态", ColumnDataType = "int")]
        public ProcessStatus OverallStatus { get; set; } = ProcessStatus.UnStarted;

        /// <summary>
        /// 开始时间
        /// </summary>
        [SugarColumn(ColumnName = "StartTime", ColumnDescription = "开始时间", IsNullable = true, ColumnDataType = "datetime")]
        public DateTime? StartTime { get; set; }

        /// <summary>
        /// 结束时间
        /// </summary>
        [SugarColumn(ColumnName = "EndTime", ColumnDescription = "结束时间", IsNullable = true, ColumnDataType = "datetime")]
        public DateTime? EndTime { get; set; }

        /// <summary>
        /// 更新人 
        /// </summary>
        [SugarColumn(ColumnName = "UpdatedUserId", ColumnDescription = "更新人", IsNullable = true, ColumnDataType = "int")]
        public int UpdatedUserId { get; set; }

        /// <summary>
        /// 更新时间
        /// </summary>
        [SugarColumn(ColumnName = "UpdatedTime", ColumnDescription = "更新时间", ColumnDataType = "datetime")]
        public DateTime UpdatedTime { get; set; } = DateTime.Now;

        /// <summary>
        /// 节点集合 - 流程包含的所有节点（导航属性）
        /// </summary>
        [Ignore]
        [Navigate(NavigateType.OneToMany, nameof(Grp_ProcessNode.ProcessId))]
        public List<Grp_ProcessNode> Nodes { get; set; } = new List<Grp_ProcessNode>();

        public Grp_ProcessOverview() { }

        /// <summary>
        /// 流程进度默认模板
        /// </summary>
        /// <param name="groupId"></param>
        /// <param name="currUserId"></param>
        /// <param name="visaCountries"></param>
        /// <returns></returns>
        public static List<Grp_ProcessOverview> ProcessInit(int groupId, int currUserId, List<string> visaCountries)
        {
            //单独处理签证流程节点
            var visaNodes = new List<Grp_ProcessNode>();

            if (visaCountries != null && visaCountries.Count > 0)
            {
                var visaDefualtNodes = new List<VisaProcessNode>();
                for (int i = 1; i < visaCountries.Count + 1; i++)
                {
                    visaDefualtNodes.Add(VisaProcessNode.Info(i, visaCountries[i - 1].ToString()));
                }

                visaNodes.Add(new Grp_ProcessNode()
                {
                    NodeOrder = 1,
                    NodeName = "签证流程",
                    OverallStatus = ProcessStatus.InProgress,
                    IsCurrent = true,
                    CreateUserId = currUserId,
                    Remark = JsonConvert.SerializeObject(visaDefualtNodes)
                });
            }

            return new List<Grp_ProcessOverview>
            {
                //商邀报批流程
                new()
                {
                    GroupId = groupId,
                    ProcessOrder = 1,
                    ProcessType = GroupProcessType.Invitation,
                    OverallStatus = ProcessStatus.InProgress,
                    StartTime = DateTime.Now,
                    UpdatedUserId = currUserId,
                    CreateUserId = currUserId,
                    Nodes = new List<Grp_ProcessNode>()
                    {
                        new(){NodeOrder = 1, NodeName="报批资料准备", OverallStatus=ProcessStatus.InProgress, IsCurrent=true,CreateUserId = currUserId },
                        new(){NodeOrder = 2, NodeName="开始报批", OverallStatus=ProcessStatus.UnStarted, IsCurrent=false,CreateUserId = currUserId },
                        new(){NodeOrder = 3, NodeName="报批中", OverallStatus=ProcessStatus.UnStarted, IsCurrent=false,CreateUserId = currUserId },
                        new(){NodeOrder = 4, NodeName="报批已出", OverallStatus=ProcessStatus.UnStarted, IsCurrent=false,CreateUserId = currUserId }
                    }
                },

                //签证流程
                new()
                {
                    GroupId = groupId,
                    ProcessOrder = 2,
                    ProcessType = GroupProcessType.Visa,
                    OverallStatus = ProcessStatus.InProgress,
                    StartTime = DateTime.Now,
                    UpdatedUserId = currUserId,
                    CreateUserId = currUserId,
                    Nodes=visaNodes
                },

                //机票流程
                new()
                {
                    GroupId = groupId,
                    ProcessOrder = 3,
                    ProcessType = GroupProcessType.AirTicket,
                    OverallStatus = ProcessStatus.InProgress,
                    StartTime = DateTime.Now,
                    UpdatedUserId = currUserId,
                    CreateUserId = currUserId,
                    Nodes = new List<Grp_ProcessNode>()
                    {
                        new(){NodeOrder = 1, NodeName="机票占位中", OverallStatus=ProcessStatus.InProgress, IsCurrent=true,CreateUserId = currUserId },
                        new(){NodeOrder = 2, NodeName="机票已出", OverallStatus=ProcessStatus.UnStarted, IsCurrent=false,CreateUserId = currUserId },
                    }
                },

                //酒店流程
                new()
                {
                    GroupId = groupId,
                    ProcessOrder = 4,
                    ProcessType = GroupProcessType.Hotel,
                    OverallStatus = ProcessStatus.InProgress,
                    StartTime = DateTime.Now,
                    UpdatedUserId = currUserId,
                    CreateUserId = currUserId,
                    Nodes = new List<Grp_ProcessNode>()
                {
                    new(){NodeOrder = 1, NodeName="酒店占房中", OverallStatus=ProcessStatus.InProgress, IsCurrent=true,CreateUserId = currUserId },
                    new(){NodeOrder = 2, NodeName="酒店已订", OverallStatus=ProcessStatus.UnStarted, IsCurrent=false,CreateUserId = currUserId },
                }
                },

                //地接流程
                new()
                {
                    GroupId = groupId,
                    ProcessOrder = 5,
                    ProcessType = GroupProcessType.LocalGuide,
                    OverallStatus = ProcessStatus.InProgress,
                    StartTime = DateTime.Now,
                    UpdatedUserId = currUserId,
                    CreateUserId = currUserId,
                    Nodes = new List<Grp_ProcessNode>()
                    {
                        new(){NodeOrder = 1, NodeName="地接对接中", OverallStatus=ProcessStatus.InProgress, IsCurrent=true,CreateUserId = currUserId },
                        new(){NodeOrder = 2, NodeName="地接已安排好", OverallStatus=ProcessStatus.UnStarted, IsCurrent=false,CreateUserId = currUserId },
                        new(){NodeOrder = 2, NodeName="出行物资准备完毕", OverallStatus=ProcessStatus.UnStarted, IsCurrent=false,CreateUserId = currUserId },
                    }
                },

                //费用结算流程
                new()
                {
                    GroupId = groupId,
                    ProcessOrder = 6,
                    ProcessType = GroupProcessType.FeeSettle,
                    OverallStatus = ProcessStatus.InProgress,
                    StartTime = DateTime.Now,
                    UpdatedUserId = currUserId,
                    CreateUserId = currUserId,
                    Nodes = new List<Grp_ProcessNode>()
                    {
                        new(){NodeOrder = 1, NodeName="费用结算中", OverallStatus=ProcessStatus.InProgress, IsCurrent=true,CreateUserId = currUserId },
                        new(){NodeOrder = 2, NodeName="费用结算完毕", OverallStatus=ProcessStatus.UnStarted, IsCurrent=false,CreateUserId = currUserId },
                    }
                }
            };
        }
    }

    /// <summary>
    /// 流程节点
    /// </summary>
    [SugarTable("Grp_ProcessNode", "流程节点")]
    public class Grp_ProcessNode : EntityBase
    {
        /// <summary>
        /// 流程ID
        /// </summary>
        [SugarColumn(ColumnName = "ProcessId", ColumnDescription = "流程ID", IsNullable = true, ColumnDataType = "int")]
        public int ProcessId { get; set; }

        /// <summary>
        /// 节点名称
        /// </summary>
        [SugarColumn(ColumnName = "NodeName", ColumnDescription = "节点名称", ColumnDataType = "varchar(100)")]
        public string NodeName { get; set; }

        /// <summary>
        /// 节点顺序 
        /// </summary>
        [SugarColumn(ColumnName = "NodeOrder", ColumnDescription = "节点顺序", ColumnDataType = "int")]
        public int NodeOrder { get; set; }

        /// <summary>
        /// 节点状态 
        /// </summary>
        [SugarColumn(ColumnName = "OverallStatus", ColumnDescription = "节点状态", ColumnDataType = "int")]
        public ProcessStatus OverallStatus { get; set; } = ProcessStatus.UnStarted;

        /// <summary>
        /// 操作人 
        /// </summary>
        [SugarColumn(ColumnName = "Operator", ColumnDescription = "操作人", IsNullable = true, ColumnDataType = "int")]
        public int? Operator { get; set; }

        /// <summary>
        /// 操作时间 
        /// </summary>
        [SugarColumn(ColumnName = "OperationTime", ColumnDescription = "操作时间", IsNullable = true, ColumnDataType = "datetime")]
        public DateTime? OperationTime { get; set; }

        ///// <summary>
        ///// 国家
        ///// </summary>
        //[SugarColumn(ColumnName = "Country", ColumnDescription = "国家", ColumnDataType = "varchar(100)",IsNullable = true)]
        //public string? Country { get; set; }

        /// <summary>
        /// 是否为当前节点
        /// </summary>
        [SugarColumn(ColumnName = "IsCurrent", ColumnDescription = "是否为当前节点", ColumnDataType = "bit")]
        [DefaultValue(false)]
        public bool IsCurrent { get; set; }

        ///// <summary>
        ///// 流程信息 - 关联的流程信息（导航属性）
        ///// </summary>
        //[Ignore]
        //[Navigate(NavigateType.OneToOne, nameof(ProcessId))]
        //public Grp_ProcessOverview Process { get; set; }
    }

    public class VisaProcessNode
    {
        /// <summary>
        /// 国家名称
        /// </summary>
        public string CountryName { get; set; }

        /// <summary>
        /// 序号
        /// </summary>
        public int OrderNo { get; set; }

        /// <summary>
        /// 收集资料 - 节点名称
        /// </summary>
        public string NodeName1 { get; set; } = "收集资料";

        /// <summary>
        /// 收集资料 - 是否办理
        /// </summary>
        public bool IsHandle1 { get; set; } = false;

        /// <summary>
        /// 收集资料 - 办理时间
        /// </summary>
        public string HandleTime1 { get; set; } = "";

        /// <summary>
        /// 取护照资料 - 节点名称
        /// </summary>
        public string NodeName2 { get; set; } = "取护照资料";

        /// <summary>
        /// 取护照资料 - 是否办理
        /// </summary>
        public bool IsHandle2 { get; set; } = false;

        /// <summary>
        /// 取护照资料 - 办理时间
        /// </summary>
        public string HandleTime2 { get; set; } = "";

        /// <summary>
        /// 填资料 - 节点名称
        /// </summary>
        public string NodeName3 { get; set; } = "填资料";

        /// <summary>
        /// 填资料 - 是否办理
        /// </summary>
        public bool IsHandle3 { get; set; } = false;

        /// <summary>
        /// 填资料 - 办理时间
        /// </summary>
        public string HandleTime3 { get; set; } = "";

        /// <summary>
        /// 送签 - 节点名称
        /// </summary>
        public string NodeName4 { get; set; } = "送签";

        /// <summary>
        /// 送签 - 是否办理
        /// </summary>
        public bool IsHandle4 { get; set; } = false;

        /// <summary>
        /// 送签 - 办理时间
        /// </summary>
        public string HandleTime4 { get; set; } = "";

        /// <summary>
        /// 出签+取护照 - 节点名称
        /// </summary>
        public string NodeName5 { get; set; } = "签+取护照";

        /// <summary>
        /// 出签+取护照 - 是否办理
        /// </summary>
        public bool IsHandle5 { get; set; } = false;

        /// <summary>
        /// 出签+取护照 - 办理时间
        /// </summary>
        public string HandleTime5 { get; set; } = "";

        /// <summary>
        /// 归还护照 - 节点名称
        /// </summary>
        public string NodeName6 { get; set; } = "归还护照";

        /// <summary>
        /// 归还护照 - 是否办理
        /// </summary>
        public bool IsHandle6 { get; set; } = false;

        /// <summary>
        /// 归还护照 - 办理时间
        /// </summary>
        public string HandleTime6 { get; set; } = "";

        /// <summary>
        /// 归还人
        /// NodeName = "归还护照" 时使用
        /// </summary>
        public string Returner { get; set; } = "";

        public VisaProcessNode() { }

        public static VisaProcessNode Info(int orderNo, string countryName)
        {

            return new VisaProcessNode() { OrderNo = orderNo, CountryName = countryName };
        }
    }

    /// <summary>
    /// 团组流程操作日志
    /// </summary>
    [SugarTable("Grp_ProcessLog", "团组流程总览操作日志")]
    public class Grp_ProcessLog : EntityBase
    {
        /// <summary>
        /// 流程ID
        /// </summary>
        [SugarColumn(ColumnName = "ProcessId", ColumnDescription = "流程ID", IsNullable = true, ColumnDataType = "int")]
        public int? ProcessId { get; set; }

        /// <summary>
        /// 节点ID
        /// </summary>
        [SugarColumn(ColumnName = "NodeId", ColumnDescription = "节点ID", IsNullable = true, ColumnDataType = "int")]
        public int? NodeId { get; set; }

        /// <summary>
        /// 团组ID
        /// </summary>
        [SugarColumn(ColumnName = "GroupId", ColumnDescription = "团组ID", IsNullable = true, ColumnDataType = "int")]
        public int GroupId { get; set; }

        /// <summary>
        /// 操作类型
        /// </summary>
        [SugarColumn(ColumnName = "OpType", ColumnDescription = "操作类型", ColumnDataType = "varchar(50)")]
        public string OpType { get; set; }

        /// <summary>
        /// 操作描述
        /// </summary>
        [SugarColumn(ColumnName = "OpDesc", ColumnDescription = "操作描述", ColumnDataType = "varchar(500)")]
        public string OpDesc { get; set; }

        /// <summary>
        /// 变更前数据
        /// </summary>
        [SugarColumn(ColumnName = "BeforeData", ColumnDescription = "变更前数据", IsNullable = true, ColumnDataType = "nvarchar(max)")]
        public string BeforeData { get; set; }

        /// <summary>
        /// 变更后数据
        /// </summary>
        [SugarColumn(ColumnName = "AfterData", ColumnDescription = "变更后数据", IsNullable = true, ColumnDataType = "nvarchar(max)")]
        public string AfterData { get; set; }

        /// <summary>
        /// 变更字段
        /// </summary>
        [SugarColumn(ColumnName = "ChgFields", ColumnDescription = "变更字段", IsNullable = true, ColumnDataType = "varchar(500)")]
        public string ChgFields { get; set; }
    }

    /// <summary>
    /// 字段变更详情
    /// </summary>
    public class FieldChgDetail
    {
        public string FieldName { get; set; }
        public string BeforeValue { get; set; }
        public string AfterValue { get; set; }
    }
}