hotline/src/Hotline/Orders/Order.cs

using Hotline.FlowEngine.Workflows;
using Hotline.Settings.Hotspots;
using Hotline.Share.Dtos;
using Hotline.Share.Dtos.File;
using Hotline.Share.Enums.FlowEngine;
using Hotline.Share.Enums.Order;
using Hotline.Share.Enums.Settings;
using Hotline.Users;
using SqlSugar;
using XF.Domain.Exceptions;
using XF.Domain.Extensions;
using XF.Domain.Repository;
using XF.Utility.EnumExtensions;

namespace Hotline.Orders
{
    /// <summary>
    /// 工单
    /// </summary>
    [SugarIndex("unique_order_no", nameof(Order.No), OrderByType.Desc, true)]
    public partial class Order : PositionWorkflowEntity
    {
        /// <summary>
        /// 第一次评价结果
        /// </summary>
        [SugarColumn(IsNullable = true, DefaultValue = "")]
        public string? FirstVisitResult { get; set; }

        [SugarColumn(IsNullable = true, DefaultValue = "")]
        public string? FirstVisitResultCode { get; set; }

        #region 来电信息

        /// <summary>
        /// 来源渠道（电话、网站、APP等）
        /// </summary>
        [SugarColumn(DefaultValue = "其他")]
        public string SourceChannel { get; set; }

        [SugarColumn(DefaultValue = "QT")]
        public string SourceChannelCode { get; set; }

        /// <summary>
        /// 渠道为电话时，此字段存在（Call.Id）
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public string? CallId { get; set; }

        /// <summary>
        /// 来电归属地
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public string? CallAddress { get; set; }

        /// <summary>
        /// 来电号码
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public string? FromPhone { get; set; }

        /// <summary>
        /// 转接号码（转接来源）
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public string? TransferPhone { get; set; }

        /// <summary>
        /// 来电/信人姓名
        /// </summary>
        public string FromName { get; set; }

        /// <summary>
        /// 来电/信人性别
        /// </summary>
        public EGender FromGender { get; set; }

        /// <summary>
        /// 来电/信人身份
        /// </summary>
        public EIdentityType IdentityType { get; set; }

        /// <summary>
        /// 证件类型
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public string? LicenceTypeCode { get; set; }

        [SugarColumn(IsNullable = true)]
        public string? LicenceType { get; set; }

        /// <summary>
        /// 证件号码
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public string? LicenceNo { get; set; }

        /// <summary>
        /// 年龄段
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public string? AgeRangeCode { get; set; }

        [SugarColumn(IsNullable = true)]
        public string? AgeRange { get; set; }

        /// <summary>
        /// 联系电话
        /// </summary>
        [SugarColumn(ColumnDescription = "联系电话", IsNullable = true)]
        public string? Contact { get; set; }

        [SugarColumn(ColumnDescription = "联系电话脱敏", IsNullable = true)]
        public string? ContactMask { get; set; }

        /// <summary>
        /// 是否接受短信，勾选校验手机号
        /// </summary>
        public bool AcceptSms { get; set; }

        /// <summary>
        /// 是否已发送短信
        /// </summary>
        public bool SmsSended { get; set; }

        /// <summary>
        /// 是否保密
        /// </summary>
        [SugarColumn(DefaultValue = "t")]
        public bool IsSecret { get; set; }

        /// <summary>
        /// 工作单位(当“来电/信人身份”为“企业”时必填，其他情况非必填)
        /// </summary>
        [SugarColumn(ColumnDescription = "工作单位", IsNullable = true)]
        public string? Company { get; set; }

        #endregion

        #region 诉求信息

        /// <summary>
        /// 工单类型
        /// </summary>
        public EOrderType OrderType { get; set; }

        /// <summary>
        /// 受理类型
        /// </summary>
        //public EAcceptType AcceptType { get; set; }
        public string AcceptType { get; set; }

        public string AcceptTypeCode { get; set; }

        /// <summary>
        /// 紧急程度
        /// </summary>
        public EEmergencyLevel EmergencyLevel { get; set; } = EEmergencyLevel.Normal;

        public string Title { get; set; }

        #region 热点

        /// <summary>
        /// 热点
        /// </summary>
        public string HotspotId { get; set; }

        public string HotspotName { get; set; }

        public string HotspotSpliceName { get; set; }

        /// <summary>
        /// 外部数据（为前端提供级联功能）
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public string? HotspotExternal { get; set; }

        #endregion

        /// <summary>
        /// 事发时间
        /// </summary>
        public DateTime? IncidentTime { get; set; }

        /// <summary>
        /// 重复工单Id
        /// </summary>
        [SugarColumn(ColumnDescription = "重复工单Id", ColumnDataType = "json", IsJson = true, IsNullable = true)]
        public List<string>? DuplicateIds { get; set; }

        /// <summary>
        /// 推送分类
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public string? PushTypeCode { get; set; }

        [SugarColumn(IsNullable = true)]
        public string? PushType { get; set; }

        /// <summary>
        /// 附件
        /// </summary>
        [SugarColumn(ColumnDataType = "json", IsJson = true)]
        public List<FileDto>? Additions { get; set; } = new();

        /// <summary>
        /// 诉求内容
        /// </summary>
        [SugarColumn(ColumnDataType = "varchar(2000)")]
        public string Content { get; set; }

        #endregion

        #region 工单属性

        /// <summary>
        /// 工单状态
        /// </summary>
        public EOrderStatus Status { get; set; }

        /// <summary>
        /// 过期状态 //todo 延迟消息更新此字段
        /// </summary>
        public EExpiredStatus ExpiredStatus { get; set; }

        /// <summary>
        /// 来源，区分省平台或110等其他平台同步过来的工单
        /// </summary>
        public ESource Source { get; set; }

        /// <summary>
        /// 处理方式（直办、交办）
        /// </summary>
        [SugarColumn(DefaultValue = "10")]
        public EProcessType ProcessType { get; set; } = EProcessType.Zhiban;

        ///// <summary>
        ///// 进展情况
        ///// </summary>
        //[SugarColumn(DefaultValue = "0")]
        //public EProgress Progress { get; set; }

        /// <summary>
        /// 是否公开
        /// </summary>
        [SugarColumn(DefaultValue = "f")]
        public bool IsPublicity { get; set; }

        /// <summary>
        /// 是否为省工单（省派发工单非政民互动直派的为省工单）
        /// </summary>
        [SugarColumn(DefaultValue = "f")]
        public bool IsProvince { get; set; }

        /// <summary>
        /// 工单编码（20220101000001）
        /// </summary>
        public string No { get; set; }

        /// <summary>
        /// 是否已撤销
        /// </summary>
        [SugarColumn(DefaultValue = "f")]
        public bool IsCancel { get; set; }

        /// <summary>
        /// 市民查询密码
        /// </summary>
        public string? Password { get; set; }

        /// <summary>
        /// 企业名称
        /// </summary>
        public string? EnterpriseName { get; set; }

        /// <summary>
        /// 专班名称
        /// </summary>
        public string? ZhuanBanMingCheng { get; set; }


        #endregion

        #region 流程信息

        /// <summary>
        /// 工单开始时间(受理/接办时间=流程开启时间)
        /// </summary>
        public DateTime? StartTime { get; set; }

        /// <summary>
        /// 过期时间
        /// </summary>
        public DateTime? ExpiredTime { get; set; }

        /// <summary>
        /// 交办时间(中心交部门办理时间)
        /// </summary>
        public DateTime? CenterToOrgTime { get; set; }

        /// <summary>
        /// 归档时间（暂为流程结束时间，因流程结束自动归档）
        /// </summary>
        public DateTime? FiledTime { get; set; }

        /// <summary>
        /// 办结时长（分钟）
        /// 办结时间-交办时间
        /// </summary>
        [SugarColumn(DefaultValue = "0")]
        public double HandleDuration { get; set; }

        /// <summary>
        /// 办结工作日时长
        /// </summary>
        [SugarColumn(DefaultValue = "0")]
        public double HandleDurationWorkday { get; set; }

        /// <summary>
        /// 全流程时长（分钟）
        /// 归档时间-创建时间
        /// </summary>
        [SugarColumn(DefaultValue = "0")]
        public double AllDuration { get; set; }

        /// <summary>
        /// 办理时间限制(如：24小时、7个工作日)
        /// </summary>
        [SugarColumn(IsNullable = true, DefaultValue = "")]
        public string? TimeLimit { get; set; }

        public int? TimeLimitCount { get; set; }

        public ETimeType? TimeLimitUnit { get; set; }

        #region 实际办理信息（节点，部门，意见）

        /// <summary>
        /// 实际办理节点code（会签状态此字段保存最外层会签发起节点code）
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public string? ActualHandleStepCode { get; set; }

        /// <summary>
        /// 实际办理节点名称（会签状态此字段保存最外层会签发起节点名称）
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public string? ActualHandleStepName { get; set; }

        /// <summary>
        /// 到达实际办理节点时间（stepBox创建时间）
        /// </summary>
        public DateTime? ActualHandleStepCreateTime { get; set; }

        /// <summary>
        /// 实际办理节点签收时间
        /// </summary>
        public DateTime? ActualHandleStepAcceptTime { get; set; }

        /// <summary>
        /// 实际办理时间
        /// </summary>
        public DateTime? ActualHandleTime { get; set; }

        /// <summary>
        /// 实际办理人id
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public string? ActualHandlerId { get; set; }

        /// <summary>
        /// 实际办理人名称
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public string? ActualHandlerName { get; set; }

        /// <summary>
        /// 实际办理部门名称
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public string? ActualHandleOrgName { get; set; }

        /// <summary>
        /// 实际办理部门编码
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public string? ActualHandleOrgCode { get; set; }

        /// <summary>
        /// 实际办理部门行政区划编码
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public string? ActualHandleOrgAreaCode { get; set; }

        /// <summary>
        /// 实际办理部门行政区划名称
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public string? ActualHandleOrgAreaName { get; set; }

        /// <summary>
        /// 实际办理意见（办理中...or 最终办理意见）
        /// </summary>
        [SugarColumn(Length = 2000)]
        public string ActualOpinion { get; set; } = "办理中...";

        /// <summary>
        /// 真实办理人姓名（手动填写）
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public string? RealHandlerName { get; set; }

        /// <summary>
        /// 真实办理人电话（手动填写）
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public string? RealHandlerPhone { get; set; }

        /// <summary>
        /// 沟通方式（手动填写）
        /// </summary>
        public ERealCommunicationMode? RealCommunicationMode { get; set; }

        /// <summary>
        /// 沟通时间（手动填写）
        /// </summary>
        public DateTime? RealCommunicationTime { get; set; }

        /// <summary>
        /// 沟通地点（手动填写）
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public string? RealCommunicationAddress { get; set; }

        #endregion

        #region 当前办理节点信息

        /// <summary>
        /// 当前办理节点code（非会签：当前被指派节点，会签：会签发起节点）
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public string? CurrentStepCode { get; set; }

        /// <summary>
        /// 当前节点名称
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public string? CurrentStepName { get; set; }

        /// <summary>
        /// 到达当前节点时间（stepBox创建时间）
        /// </summary>
        public DateTime? CurrentStepCreateTime { get; set; }

        #endregion

        #region 一级部门

        /// <summary>
        /// 一级部门code
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public string? OrgLevelOneCode { get; set; }

        /// <summary>
        /// 一级部门名称
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public string? OrgLevelOneName { get; set; }

        #endregion

        #region 受理人(开启流程的话务员)

        /// <summary>
        /// 受理人id
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public string? AcceptorId { get; set; }

        /// <summary>
        /// 受理人名称
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public string? AcceptorName { get; set; }

        /// <summary>
        /// 受理人工号
        /// </summary>
        [SugarColumn(IsNullable = true)]
        public string? AcceptorStaffNo { get; set; }

        /// <summary>
        /// 受理人部门编码
        /// </summary>
        public string? AcceptorOrgCode { get; set; }

        /// <summary>
        /// 受理人部门名称
        /// </summary>
        public string? AcceptorOrgName { get; set; }

        #endregion

        /// <summary>
        /// 会签类型
        /// </summary>
        public ECounterSignType? CounterSignType { get; set; }

        #endregion

        #region 省工单字段

        /// <summary>
        /// 省期满时间（省工单才有）
        /// </summary>
        public DateTime? ExpiredTimeProvince { get; set; }

        ///// <summary>
        ///// 省工单编号（冗余）
        ///// </summary>
        //[SugarColumn(IsNullable = true)]
        //public string? FromProvinceNo { get; set; }

        ///// <summary>
        ///// 同步省工单编号（按省工单要求生成的编号，冗余）
        ///// </summary>
        //[SugarColumn(IsNullable = true)]
        //public string? ToProvinceNo { get; set; }

        //#endregion

        //#region 110字段

        ///// <summary>
        ///// 110工单编号（从110来的和推送给110的都用该字段记录唯一标识）
        ///// </summary>
        //[SugarColumn(IsNullable = true)]
        //public string? No110 { get; set; }

        /// <summary>
        /// 同步省工单编号和省上传下来的工单都用这个字段
        /// </summary>
        public string? ProvinceNo { get; set; }

        /// <summary>
        /// 外部工单唯一标识
        /// </summary>
        public string? ExternalId { get; set; }

        #endregion
    }

    public partial class Order
    {
        /// <summary>
        /// 受理人
        /// </summary>
        [Navigate(NavigateType.OneToOne, nameof(AcceptorId))]
        public User Acceptor { get; set; }

        /// <summary>
        /// 热点
        /// </summary>
        [Navigate(NavigateType.OneToOne, nameof(HotspotId))]
        public Hotspot Hotspot { get; set; }

        /// <summary>
        /// 办理流程
        /// </summary>
        [Navigate(NavigateType.OneToOne, nameof(WorkflowId))]
        public Workflow Workflow { get; set; }

        /// <summary>
        /// 工单扩展信息（12315-投诉）
        /// </summary>
        [Navigate(NavigateType.OneToOne, nameof(Id))]
        public OrderComplain OrderComplain { get; set; }

        /// <summary>
        /// 工单扩展信息（12315-举报）
        /// </summary>
        [Navigate(NavigateType.OneToOne, nameof(Id))]
        public OrderReport OrderReport { get; set; }

        /// <summary>
        /// 已发布工单
        /// </summary>
        [Navigate(NavigateType.OneToOne, nameof(Id))]
        public OrderPublish OrderPublish { get; set; }

        /// <summary>
        /// 已回访工单
        /// </summary>
        [Navigate(NavigateType.OneToMany, nameof(OrderVisit.OrderId))]
        public List<OrderVisit> OrderVisits { get; set; }

        /// <summary>
        /// 甄别
        /// </summary>
        [Navigate(NavigateType.OneToMany, nameof(OrderScreen.OrderId))]
        public List<OrderScreen> OrderScreens { get; set; }

        /// <summary>
        /// 延期
        /// </summary>
        [Navigate(NavigateType.OneToMany, nameof(OrderDelay.OrderId))]
        public List<OrderDelay> OrderDelays { get; set; }

        #region Method

        public void Cancel()
        {
            IsCancel = true;
        }

        public void Redo()
        {
            Status = EOrderStatus.Handling;
            ExpiredStatus = EExpiredStatus.Normal;
        }

        public void CheckIfFiled()
        {
            if (Status is EOrderStatus.Filed)
                throw UserFriendlyException.SameMessage("工单已归档");
        }

        public void Init(string userId, string? userName, string? staffNo)
        {
            AcceptorId = userId;
            AcceptorName = userName;
            AcceptorStaffNo = staffNo;
            if (!string.IsNullOrEmpty(Contact))
                ContactMask = Contact.MaskPhoneNumber();
            Status = EOrderStatus.WaitForAccept;
            ExpiredStatus = EExpiredStatus.Normal;
        }

        /// <summary>
        /// 开始工单办理流程
        /// </summary>
        public void StartManageFlow() => Status = EOrderStatus.Handling;

        /// <summary>
        /// 更新工单办理中状态
        /// </summary>
        public void UpdateHandlingStatus(bool isInCountersign) =>
            Status = isInCountersign ? EOrderStatus.Countersigning : EOrderStatus.Handling;

        /// <summary>
        /// 归档
        /// </summary>
        public void Filed()
        {
            if (Status is EOrderStatus.Filed) return;
            Status = EOrderStatus.Filed;
            FiledTime = DateTime.Now;
        }

        /// <summary>
        /// 发布
        /// </summary>
        /// <param name="isPublicity"></param>
        public void Publish(bool isPublicity)
        {
            //Progress = EProgress.Published;
            Status = EOrderStatus.Published;
            IsPublicity = isPublicity;
        }

        /// <summary>
        /// 已回访
        /// </summary>
        public void Visited(string resultCode, string result)
        {
            if (string.IsNullOrEmpty(resultCode) || string.IsNullOrEmpty(result))
                throw new UserFriendlyException("无效参数");
            if (!string.IsNullOrEmpty(FirstVisitResultCode)) return;
            FirstVisitResultCode = resultCode;
            FirstVisitResult = result;

            //Progress = EProgress.Visited;
            Status = EOrderStatus.Visited;
        }

        public void CenterToOrg(DateTime expiredTime)
        {
            ProcessType = EProcessType.Jiaoban;
            ExpiredTime = expiredTime;
            CenterToOrgTime = DateTime.Now;
        }

        public void OrgToCenter(DateTime expiredTime)
        {
            ProcessType = EProcessType.Zhiban;
            ExpiredTime = expiredTime;
            CenterToOrgTime = null;
        }

        #endregion
    }
}