using System.Collections.Concurrent;
using System.Data;
using System.Diagnostics;
using System.IO;
using System.Threading;
using DotNetCore.CAP;
using Fw.Utility.Client;
using Google.Protobuf.WellKnownTypes;
using Hotline.Ai.Visit;
using Hotline.Application.ExportExcel;
using Hotline.Application.FlowEngine;
using Hotline.Application.JudicialManagement;
using Hotline.Application.Orders;
using Hotline.Application.Quality;
using Hotline.Application.StatisticalReport;
using Hotline.Authentications;
using Hotline.CallCenter.BlackLists;
using Hotline.CallCenter.Calls;
using Hotline.CallCenter.Configs;
using Hotline.CallCenter.Devices;
using Hotline.CallCenter.Ivrs;
using Hotline.ContingencyManagement;
using Hotline.FlowEngine;
using Hotline.FlowEngine.Definitions;
using Hotline.FlowEngine.Notifications;
using Hotline.FlowEngine.WorkflowModules;
using Hotline.FlowEngine.Workflows;
using Hotline.Identity.Roles;
using Hotline.Import;
using Hotline.JudicialManagement;
using Hotline.Orders;
using Hotline.Push.Notifies;
using Hotline.Realtimes;
using Hotline.Repository.SqlSugar;
using Hotline.Repository.SqlSugar.CallCenter;
using Hotline.Repository.SqlSugar.System;
using Hotline.Repository.SqlSugar.Ts;
using Hotline.Settings;
using Hotline.Settings.Hotspots;
using Hotline.Settings.TimeLimits;
using Hotline.Share.Dtos;
using Hotline.Share.Dtos.FlowEngine;
using Hotline.Share.Dtos.FlowEngine.Workflow;
using Hotline.Share.Dtos.Order;
using Hotline.Share.Dtos.Realtime;
using Hotline.Share.Dtos.SendSms;
using Hotline.Share.Dtos.TrCallCenter;
using Hotline.Share.Enums.FlowEngine;
using Hotline.Share.Enums.JudicialManagement;
using Hotline.Share.Enums.Order;
using Hotline.Share.Enums.Push;
using Hotline.Share.Enums.Quality;
using Hotline.Share.Enums.Settings;
using Hotline.Share.Mq;
using Hotline.Share.Requests;
using Hotline.Tools;
using Hotline.Users;
using MapsterMapper;
using MediatR;
using Microsoft.AspNetCore.Authorization;
using Microsoft.AspNetCore.Components.Routing;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Routing.Template;
using Microsoft.Extensions.Options;
using MiniExcelLibs;
using MongoDB.Driver;
using NewRock.Sdk;
using NewRock.Sdk.Security;
using SqlSugar;
using SqlSugar.SplitTableExtensions;
using StackExchange.Redis;
using Tr.Sdk;
using XC.RSAUtil;
using XF.Domain.Authentications;
using XF.Domain.Cache;
using XF.Domain.Entities;
using XF.Domain.Exceptions;
using XF.Domain.Filters;
using XF.Domain.Locks;
using XF.Domain.Queues;
using XF.Domain.Repository;
using XF.EasyCaching;
using Order = Hotline.Orders.Order;
namespace Hotline.Api.Controllers;
///
///
///
//[AllowAnonymous]
public class TestController : BaseController
{
private readonly ILogger _logger;
private readonly IAuthorizeGenerator _authorizeGenerator;
private readonly IOptionsSnapshot _options;
private readonly ISessionContext _sessionContext;
private readonly IRepository _userRepository;
private readonly ITypedCache _cache;
private readonly IRealtimeService _realtimeService;
private readonly IBlacklistDomainService _blacklistDomainService;
private readonly IIvrDomainService _ivrDomainService;
private readonly ISugarUnitOfWork _uow;
private readonly IRepository _roleRepository;
private readonly IMediator _mediator;
private readonly IDistributedLock _distributedLock;
private readonly IRepository _orderUrgeRepository;
private readonly IRepositoryTextSearch _repositoryts;
private readonly ITimeLimitDomainService _timeLimitDomainService;
private readonly IWfModuleDomainService _wfModuleDomainService;
private readonly IDaySettingRepository _daySettingRepository;
//private readonly ITrClient _trClient;
private readonly ICapPublisher _capPublisher;
private readonly IQueue _queue;
private readonly IExportApplication _exportApplication;
private readonly IAiVisitService _aiVisitService;
private readonly IRepository _workflowTraceRepository;
private readonly IRepository _workflowStepRepository;
private readonly IWorkflowRepository _workflowRepository;
//private readonly IRepository _workflowStepHandleRepository;
private readonly IRepository _systemOrganizeRepository;
private readonly IOrderRepository _orderRepository;
private readonly IRepository _trCallRecordRepository;
private readonly IQualityApplication _qualityApplication;
private readonly IEnforcementApplication _enforcementApplication;
private readonly IWorkflowDomainService _workflowDomainService;
private readonly IMapper _mapper;
private readonly IOptionsSnapshot _sendSmsConfiguration;
private readonly IOrderReportApplication _orderReportApplication;
private readonly IRepository _enforcementOrdersRepository;
private readonly IRepository _judicialManagementOrdersRepository;
private readonly IRepository _enforcementOrdersHandlerRepository;
private readonly IWorkflowApplication _workflowApplication;
private readonly IRepository _contingencyManagementHotspotRepository;
private readonly IRepository _hotspotRepository;
private readonly IOrderApplication _orderApplication;
//private readonly ITypedCache> _cache;
//private readonly ICacheManager _cache;
public TestController(
INewRockClient client,
ILogger logger,
IAuthorizeGenerator authorizeGenerator,
IOptionsSnapshot options,
ISessionContext sessionContext,
IRepository userRepository,
//ICacheManager cache
//ITypedCache> cache
ITypedCache cache,
IRealtimeService realtimeService,
IBlacklistDomainService blacklistDomainService,
IIvrDomainService ivrDomainService,
ISugarUnitOfWork uow,
IRepository roleRepository,
IMediator mediator,
IDistributedLock distributedLock,
IRepository orderUrgeRepository,
IRepositoryTextSearch repositoryts,
ITimeLimitDomainService timeLimitDomainService,
IWfModuleDomainService wfModuleDomainService,
IDaySettingRepository daySettingRepository,
//ITrClient trClient,
ICapPublisher capPublisher,
IQueue queue,
IExportApplication exportApplication,
IAiVisitService aiVisitService,
IRepository workflowTraceRepository,
IRepository workflowStepRepository,
IWorkflowRepository workflowRepository,
//IRepository workflowStepHandleRepository,
IRepository systemOrganizeRepository,
IOrderRepository orderRepository,
IRepository trCallRecordRepository,
IQualityApplication qualityApplication,
IEnforcementApplication enforcementApplication,
IWorkflowDomainService workflowDomainService,
IMapper mapper,
IOrderApplication orderApplication,
IOptionsSnapshot sendSmsConfiguration,
IOrderReportApplication orderReportApplication,
IRepository enforcementOrdersRepository,
IRepository judicialManagementOrdersRepository,
IRepository enforcementOrdersHandlerRepository,
IRepository contingencyManagementHotspotRepository,
IRepository hotspotRepository
)
{
_logger = logger;
_authorizeGenerator = authorizeGenerator;
_options = options;
_sessionContext = sessionContext;
_userRepository = userRepository;
_cache = cache;
_realtimeService = realtimeService;
_blacklistDomainService = blacklistDomainService;
_ivrDomainService = ivrDomainService;
_uow = uow;
_roleRepository = roleRepository;
_mediator = mediator;
_distributedLock = distributedLock;
_orderUrgeRepository = orderUrgeRepository;
_repositoryts = repositoryts;
_timeLimitDomainService = timeLimitDomainService;
_wfModuleDomainService = wfModuleDomainService;
_daySettingRepository = daySettingRepository;
//_trClient = trClient;
_capPublisher = capPublisher;
_queue = queue;
_exportApplication = exportApplication;
_aiVisitService = aiVisitService;
_workflowTraceRepository = workflowTraceRepository;
_workflowStepRepository = workflowStepRepository;
_workflowRepository = workflowRepository;
//_workflowStepHandleRepository = workflowStepHandleRepository;
_systemOrganizeRepository = systemOrganizeRepository;
_orderRepository = orderRepository;
_trCallRecordRepository = trCallRecordRepository;
_qualityApplication = qualityApplication;
_enforcementApplication = enforcementApplication;
_workflowDomainService = workflowDomainService;
_orderRepository = orderRepository;
_mapper = mapper;
_sendSmsConfiguration = sendSmsConfiguration;
_orderReportApplication = orderReportApplication;
_enforcementOrdersRepository = enforcementOrdersRepository;
_judicialManagementOrdersRepository = judicialManagementOrdersRepository;
_enforcementOrdersHandlerRepository = enforcementOrdersHandlerRepository;
_contingencyManagementHotspotRepository = contingencyManagementHotspotRepository;
_hotspotRepository = hotspotRepository;
_orderApplication = orderApplication;
}
///
/// 推送回访到省上
///
///
[HttpPost("publishVisitToProvince")]
[AllowAnonymous]
public async Task PublsihVisitToProvince([FromBody]DateTime date)
{
//查询需要推送的数据
var list = await _orderRepository.Queryable()
.Includes(x=>x.OrderVisits.Where(q=>q.VisitState== EVisitState.Visited).ToList())
.Where(x => x.CreationTime.Date == date.Date && x.Status == EOrderStatus.Visited && x.ProcessType == EProcessType.Zhiban && x.CounterSignType == null).ToListAsync();
foreach (var item in list)
{
var visit = item.OrderVisits.FirstOrDefault();
if (visit!=null)
{
//推省上
await _capPublisher.PublishAsync(Hotline.Share.Mq.EventNames.HotlineOrderVisited,
new PublishVisitDto()
{
Order = _mapper.Map(item),
No = visit.No,
VisitType = visit.VisitType,
VisitName = visit.CreatorName,
VisitTime = visit.VisitTime,
VisitRemark = "满意",
AreaCode = item.AreaCode!,
SubjectResultSatifyCode = "4",
FirstSatisfactionCode = "4",
ClientGuid = ""
}, cancellationToken: HttpContext.RequestAborted);
}
}
}
[HttpGet("addcontingencymanagementhotspot")]
[AllowAnonymous]
public async Task AddContingencyManagementHotspot([FromQuery] string? Id,string? ParentId)
{
if (!string.IsNullOrWhiteSpace(Id))
{
var data = await _hotspotRepository.GetAsync(Id, HttpContext.RequestAborted);
if(data != null)
{
var newdata = _mapper.Map(data);
newdata.Id = data.Id;
await _contingencyManagementHotspotRepository.AddAsync(newdata, HttpContext.RequestAborted);
}
}
if (!string.IsNullOrEmpty(ParentId))
{
var data = await _hotspotRepository.Queryable().Where(p=>p.ParentId==ParentId).ToListAsync();
if (data != null&&data.Count>0)
{
foreach (var item in data)
{
var newdata = _mapper.Map(item);
newdata.Id = item.Id;
await _contingencyManagementHotspotRepository.AddAsync(newdata, HttpContext.RequestAborted);
}
}
}
}
///
/// 处理司法工单数据
///
///
///
///
[HttpGet("addjudicial_management_orders")]
[AllowAnonymous]
public async Task AddJudicialManagementOrders(DateTime StartTime, DateTime? EndTime)
{
var list = await _enforcementOrdersRepository.Queryable()
.Includes(x => x.Order)
.Where(x => x.CreationTime >= StartTime && x.CreationTime <= EndTime && x.Order.AcceptTypeCode == "35")
.ToListAsync();
foreach (var item in list)
{
var order = item.Order;
if (order != null)
{
var orderData = await _judicialManagementOrdersRepository.GetAsync(p => p.Id == order.Id, HttpContext.RequestAborted);
if (orderData == null)
{
orderData = new JudicialManagementOrders();
//处理工单
_mapper.Map(order, orderData);
orderData.Id = order.Id;
orderData.IsEnforcementOrder = order.IsEnforcementOrder.HasValue ? order.IsEnforcementOrder.Value : false;
orderData.IsTheClueTrue = item.IsTheClueTrue;
orderData.IsPassTheBuckOrder = item.IsPassTheBuckOrder;
orderData.OrderSoure = EOrderSoure.Hotline;
orderData.CreationTime = item.CreationTime;
if (item.EventTypeId == "04" || item.EventTypeId == "05" || item.EventTypeId == "06" || item.EventTypeId == "07" || item.EventTypeId == "08" ||
item.EventTypeId == "0401" || item.EventTypeId == "0501" || item.EventTypeId == "0601" || item.EventTypeId == "0701" || item.EventTypeId == "0801")
{
orderData.EventTypeId = "0901";
orderData.EventTypeName = "其他情形";
orderData.EventTypeSpliceName = "其他类-其他情形";
orderData.EventTypeOneLevelId = "09";
}
else
{
orderData.EventTypeId = item.EventTypeId;
orderData.EventTypeName = item.EventTypeName;
orderData.EventTypeSpliceName = item.EventTypeSpliceName;
orderData.EventTypeOneLevelId = item.EventTypeOneLevelId;
}
List kvs = new List
{
new Kv { Key = order.OrgLevelOneName, Value = order.OrgLevelOneCode }
};
orderData.EnforcementOrdersHandler = kvs;
await _judicialManagementOrdersRepository.AddAsync(orderData, HttpContext.RequestAborted);
//处理部门
EnforcementOrdersHandler enforcementOrdersHandler = new EnforcementOrdersHandler()
{
OrderId = order.Id,
OrderNo = order.No,
OrderSoure = EOrderSoure.Hotline,
OrgCode = order.OrgLevelOneCode,
OrgName = order.OrgLevelOneName,
CreationTime = order.CreationTime
};
await _enforcementOrdersHandlerRepository.AddAsync(enforcementOrdersHandler, HttpContext.RequestAborted);
}
}
}
}
///
/// 计算工单的办理时长
///
///
///
///
[HttpGet("update_order_handle_time")]
[AllowAnonymous]
public async Task UpdateOrderHandleTime(DateTime StartTime, DateTime? EndTime)
{
var list = await _orderRepository.Queryable()
.Where(p => p.CreationTime >= StartTime && p.CreationTime <= EndTime && p.Status >= EOrderStatus.Filed)
.Where(p => p.CreationTimeHandleDuration == null || p.CenterToOrgHandleDuration == null)
.ToListAsync();
if (list.Any())
{
foreach (var item in list)
{
var creationTimeHandleDurationWorkday = item.FiledTime.HasValue
? _timeLimitDomainService.CalcWorkTimeEx(item.CreationTime, item.FiledTime.Value,
item.ProcessType is EProcessType.Zhiban)
: 0;
var centerToOrgHandleDurationWorkday = item.FiledTime.HasValue && item.CenterToOrgTime.HasValue
? _timeLimitDomainService.CalcWorkTimeEx(item.CenterToOrgTime.Value, item.FiledTime.Value,
item.ProcessType is EProcessType.Zhiban)
: 0;
item.CreationTimeHandleDurationWorkday = creationTimeHandleDurationWorkday;
item.CenterToOrgHandleDurationWorkday = centerToOrgHandleDurationWorkday;
if (item.FiledTime.HasValue)
{
var count = Math.Round((item.FiledTime - item.CreationTime).Value.TotalSeconds);
item.CreationTimeHandleDuration = count <= 0 ? 1 : count;
}
else
item.CreationTimeHandleDuration = 0;
if (item.FiledTime.HasValue && item.CenterToOrgTime.HasValue)
{
var count = Math.Round((item.FiledTime - item.CenterToOrgTime).Value.TotalSeconds);
item.CenterToOrgHandleDuration = count <= 0 ? 1 : count;
}
else
item.CenterToOrgHandleDuration = 0;
await _orderRepository.UpdateAsync(item, HttpContext.RequestAborted);
}
}
}
[HttpGet("testo")]
[AllowAnonymous]
public async Task TestOrigin()
{
var messageDto = new Share.Dtos.Push.MessageDto
{
PushBusiness = EPushBusiness.OrderAccept,
ExternalId = "123456789",
OrderId = "123456789",
PushPlatform = EPushPlatform.Sms,
Remark = " order.Title",
Name = "张三",
TemplateCode = "1005",
Params = new List() { "20240610000022", "12345" },
TelNumber = "15881689499",
};
await _mediator.Publish(new PushMessageNotify(messageDto), HttpContext.RequestAborted);
var t = _sendSmsConfiguration.Value.Url;
var now = DateTime.Now.ToString();
return OpenResponse.Ok(now);
}
[HttpGet("init-orgname")]
[AllowAnonymous]
public async Task InitUserOrgFullName()
{
var list = await _userRepository.Queryable().Where(x => 1 == 1 && string.IsNullOrEmpty(x.FullOrgName)).ToListAsync();
foreach (var item in list)
{
var orgFullName = "";
var orgFullCode = "";
var orgId = item.OrgId;
int strLength = orgId.Length;
int segmentsCount = strLength / 3;
List strings = new List();
for (int i = 0; i < segmentsCount; i++)
{
int startIndex = i * 3;
int length = Math.Min(3, strLength - startIndex);
strings.Add(orgId.Substring(startIndex, length));
}
if (strLength > 3)
{
orgFullCode = strings[0];
strings.Remove(orgFullCode);
}
foreach (var str in strings)
{
orgFullCode = orgFullCode + str;
var org = await _systemOrganizeRepository.GetAsync(orgFullCode);
if (org != null)
{
orgFullName = orgFullName + org.Name + "/";
}
}
if (orgFullName.Length > 0)
{
orgFullName = orgFullName.Remove(orgFullName.Length - 1);
}
item.FullOrgName = orgFullName;
await _userRepository.UpdateAsync(item);
}
}
[HttpPost("import")]
[AllowAnonymous]
public async Task> Import(IFormFile file)
{
//var FileName = file.FileName;
//var fileExtension = Path.GetExtension(FileName);
////新文件名
//var newFileName = DateTime.Now.ToString("yyyyMMddhhmmss");
////文件保存路径
//var filePath = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot", "Upload", newFileName);
////判断路径是否存在
//if (!Directory.Exists(filePath))
//{
// //创建路径
// Directory.CreateDirectory(filePath);
//}
//filePath = Path.Combine(filePath, newFileName+ fileExtension);
using (var stream = new MemoryStream())
{
file.CopyTo(stream);
var list = MiniExcel.Query(stream).ToList();
//Directory.Delete(filePath, true);
return list;
}
}
[AllowAnonymous]
[HttpGet("export")]
public async Task