using NCC.Common.Core.Manager; using NCC.Common.Enum; using NCC.Common.Extension; using NCC.Common.Filter; using NCC.Dependency; using NCC.DynamicApiController; using NCC.FriendlyException; using NCC.Extend.Interfaces.LqReimbursementApplication; using Mapster; using Microsoft.AspNetCore.Mvc; using SqlSugar; using System; using System.Collections.Generic; using System.Globalization; using System.IO; using System.Linq; using System.Linq.Expressions; using System.Threading.Tasks; using NCC.Extend.Entitys; using NCC.Extend.Entitys.Dto.LqReimbursementApplication; using NCC.Extend.Entitys.lq_reimbursement_application_node; using NCC.Extend.Entitys.lq_reimbursement_application_node_user; using NCC.Extend.Entitys.lq_reimbursement_approval_record; using NCC.Extend.Entitys.lq_mdxx; using NCC.Extend.Entitys.lq_reimbursement_workflow_config; using NCC.Extend.Entitys.lq_reimbursement_workflow_node; using NCC.Extend.Entitys.lq_reimbursement_workflow_node_user; using Yitter.IdGenerator; using NCC.Common.Helper; using NCC.JsonSerialization; using NCC.Common.Model.NPOI; using NCC.Common.Configuration; using NCC.DataEncryption; using NCC.ClayObject; using NCC.Extend.Interfaces.BusinessOperationLog; using Newtonsoft.Json; namespace NCC.Extend.LqReimbursementApplication { /// /// 报销申请表服务 /// [ApiDescriptionSettings(Tag = "Extend", Name = "LqReimbursementApplication", Order = 200)] [Route("api/Extend/[controller]")] public class LqReimbursementApplicationService : ILqReimbursementApplicationService, IDynamicApiController, ITransient { private readonly ISqlSugarRepository _lqReimbursementApplicationRepository; private readonly SqlSugarScope _db; private readonly IUserManager _userManager; private readonly IBusinessOperationLogService _businessOperationLogService; /// /// 初始化一个类型的新实例 /// public LqReimbursementApplicationService( ISqlSugarRepository lqReimbursementApplicationRepository, IUserManager userManager, IBusinessOperationLogService businessOperationLogService) { _lqReimbursementApplicationRepository = lqReimbursementApplicationRepository; _db = _lqReimbursementApplicationRepository.Context; _userManager = userManager; _businessOperationLogService = businessOperationLogService; } /// /// 获取报销申请表详情(包含表单和流程信息) /// /// /// 根据申请编号获取报销申请的详细信息,包括表单数据、节点配置、审批历史、购买记录等。 /// /// 示例请求: /// ``` /// GET /api/Extend/LqReimbursementApplication/{id} /// ``` /// /// 参数说明: /// - id: 申请编号(必填) /// /// 返回说明: /// - form: 表单基本信息,包含申请编号、申请人信息、门店信息、审批状态、完成时间等 /// - nodes: 节点配置列表,包含每个节点的审批人、审批记录等 /// - currentApprovers: 当前节点审批人列表 /// - currentNodeOrder: 当前节点顺序 /// - approvalStatus: 审批状态 /// - returnedReason: 退回原因(如果有) /// - purchaseRecords: 关联的购买记录列表 /// - form.completionTime: 完成时间(最后一个审批人通过的时间),如果申请未完成则为null /// /// 申请编号 /// 报销申请详情 /// 查询成功 /// 申请不存在 /// 服务器错误 [HttpGet("{id}")] public async Task GetInfo(string id) { var entity = await _db.Queryable().FirstAsync(p => p.Id == id); _ = entity ?? throw NCCException.Oh(ErrorCode.COM1005); var output = entity.Adapt(); output.approveStatus = entity.ApprovalStatus ?? entity.ApproveStatus; // 获取完成时间(优先使用实体类中的 CompletionTime,如果没有则查询审批记录) if (entity.CompletionTime.HasValue) { output.completionTime = entity.CompletionTime; } else { // 查询最后一次审批通过的记录 var completionRecord = await _db.Queryable() .Where(x => x.ApplicationId == id && x.ApprovalResult == "通过") .OrderBy(x => x.ApprovalTime, OrderByType.Desc) .FirstAsync(); output.completionTime = completionRecord?.ApprovalTime; } // 获取节点配置 var nodes = await _db.Queryable() .Where(x => x.ApplicationId == id) .OrderBy(x => x.NodeOrder) .ToListAsync(); // 获取每个节点的审批人 var nodeUsers = await _db.Queryable() .Where(x => x.ApplicationId == id) .OrderBy(x => x.NodeOrder) .OrderBy(x => x.SortOrder) .ToListAsync(); output.workflowName = await ResolveApplicationWorkflowNameForDetailAsync(entity, nodes, nodeUsers); // 获取审批历史 var approvalRecords = await _db.Queryable() .Where(x => x.ApplicationId == id) .OrderBy(x => x.NodeOrder) .OrderBy(x => x.ApprovalTime) .ToListAsync(); // 获取关联的购买记录 var purchaseRecords = await _db.Queryable() .Where(x => x.ApplicationId == id) .OrderBy(x => x.CreateTime) .ToListAsync(); // 获取门店名称 string storeName = null; if (!string.IsNullOrEmpty(entity.ApplicationStoreId)) { var store = await _db.Queryable() .Where(x => x.Id == entity.ApplicationStoreId) .Select(x => x.Dm) .FirstAsync(); storeName = store ?? null; } output.applicationStoreName = storeName; // 组装节点信息 var nodeList = nodes.Select(n => new { nodeId = n.Id, nodeOrder = n.NodeOrder, nodeName = n.NodeName, approvalType = n.ApprovalType, isRequired = n.IsRequired, approvers = nodeUsers.Where(u => u.NodeId == n.Id).Select(u => new { userId = u.UserId, userName = u.UserName, sortOrder = u.SortOrder }).ToList(), approvalRecords = approvalRecords.Where(r => r.NodeId == n.Id).Select(r => new { approverName = r.ApproverName, approvalResult = r.ApprovalResult, approvalOpinion = r.ApprovalOpinion, approvalTime = r.ApprovalTime }).ToList() }).ToList(); // 获取当前节点审批人 var currentApprovers = new List(); if (entity.CurrentNodeOrder.HasValue && entity.CurrentNodeOrder > 0) { currentApprovers = nodeUsers .Where(u => u.NodeOrder == entity.CurrentNodeOrder.Value) .Select(u => new { userId = u.UserId, userName = u.UserName }) .Cast() .ToList(); } // 组装购买记录数据 var purchaseRecordsList = purchaseRecords.Select(pr => new { id = pr.Id, reimbursementCategoryId = pr.ReimbursementCategoryId, reimbursementCategoryName = pr.ReimbursementCategoryName, unitPrice = pr.UnitPrice, quantity = pr.Quantity, amount = pr.Amount, payeeName = pr.PayeeName, memo = pr.Memo, attachment = pr.Attachment, purchaseTime = pr.PurchaseTime, createTime = pr.CreateTime, createUser = pr.CreateUser, createUserStoreId = pr.CreateUserStoreId, approveStatus = pr.ApproveStatus, approveUser = pr.ApproveUser, approveTime = pr.ApproveTime, applicationId = pr.ApplicationId }).ToList(); return new { form = output, nodes = nodeList, currentApprovers = currentApprovers, currentNodeOrder = entity.CurrentNodeOrder, approvalStatus = entity.ApprovalStatus ?? entity.ApproveStatus, returnedReason = entity.ReturnedReason, purchaseRecords = purchaseRecordsList }; } /// /// 获取报销申请表列表 /// /// /// 获取报销申请表分页列表,支持多种查询条件组合查询。 /// /// 示例请求: /// ``` /// GET /api/Extend/LqReimbursementApplication?currentPage=1&pageSize=20&approveStatus=已通过&completionTime=2026-07-01 00:00:00,2026-07-31 23:59:59 /// ``` /// /// 参数说明: /// - currentPage: 当前页码(默认1) /// - pageSize: 每页数量(默认20) /// - id: 申请编号(可选,模糊查询) /// - applicationUserId: 申请人编号(可选,模糊查询) /// - applicationUserName: 申请人姓名(可选,模糊查询) /// - applicationStoreId: 申请门店ID(可选,模糊查询) /// - applicationTime: 申请时间范围(可选,格式:开始时间,结束时间) /// - amount: 总金额(可选,模糊查询) /// - approveUser: 审批人(可选,精确匹配) /// - approveStatus: 审批结果(可选,模糊查询) /// - approveTime: 审批时间范围(可选,格式:开始时间,结束时间) /// - purchaseRecordsId: 关联购买编号(可选,模糊查询) /// - completionTime: 完成时间范围(可选,格式:开始时间,结束时间,精确到秒,如 2026-07-01 00:00:00,2026-07-31 23:59:59)。完成时间指最后一个审批人通过的时间 /// /// 返回说明: /// - 返回分页列表,包含报销申请详细信息 /// - 每条记录包含:申请编号、申请人信息、门店信息、审批状态、完成时间等 /// - completionTime: 完成时间(最后一个审批人通过的时间),如果申请未完成则为null /// /// 请求参数 /// 分页列表 /// 查询成功 /// 输入参数错误 /// 服务器错误 [HttpGet("")] public async Task GetList([FromQuery] LqReimbursementApplicationListQueryInput input) { List queryApplicationTime = input.applicationTime != null ? input.applicationTime.Split(',').ToObeject>() : null; DateTime? startApplicationTime = queryApplicationTime != null ? Ext.GetDateTime(queryApplicationTime.First()) : null; DateTime? endApplicationTime = queryApplicationTime != null ? Ext.GetDateTime(queryApplicationTime.Last()) : null; List queryApproveTime = input.approveTime != null ? input.approveTime.Split(',').ToObeject>() : null; DateTime? startApproveTime = queryApproveTime != null ? Ext.GetDateTime(queryApproveTime.First()) : null; DateTime? endApproveTime = queryApproveTime != null ? Ext.GetDateTime(queryApproveTime.Last()) : null; List queryCompletionTime = input.completionTime != null ? input.completionTime.Split(',').ToObeject>() : null; DateTime? startCompletionTime = queryCompletionTime != null ? ParseQueryDateTime(queryCompletionTime.First()) : null; DateTime? endCompletionTime = queryCompletionTime != null ? ParseQueryDateTime(queryCompletionTime.Last()) : null; // 如果提供了完成时间筛选,需要先查询符合条件的申请ID,然后在主查询中过滤 List filteredApplicationIdsByCompletionTime = null; if (queryCompletionTime != null) { var startDate = startCompletionTime.ToDate(); var endDate = endCompletionTime.ToDate(); // 先查询实体类中有CompletionTime字段且符合条件的申请ID var entitiesWithCompletionTime = await _db.Queryable() .Where(x => x.CompletionTime.HasValue && x.CompletionTime.Value >= startDate && x.CompletionTime.Value <= endDate) .Select(x => x.Id) .ToListAsync(); // 查询实体类中没有CompletionTime字段的申请,需要从审批记录中获取完成时间 var entitiesWithoutCompletionTime = await _db.Queryable() .Where(x => !x.CompletionTime.HasValue) .Select(x => x.Id) .ToListAsync(); var applicationIdsFromRecords = new List(); if (entitiesWithoutCompletionTime.Any()) { // 从审批记录中查询符合条件的申请ID applicationIdsFromRecords = await _db.Queryable() .Where(x => entitiesWithoutCompletionTime.Contains(x.ApplicationId) && x.ApprovalResult == "通过") .GroupBy(x => x.ApplicationId) .Having(x => SqlFunc.AggregateMax(x.ApprovalTime) >= startDate && SqlFunc.AggregateMax(x.ApprovalTime) <= endDate) .Select(x => x.ApplicationId) .ToListAsync(); } // 合并两种情况的申请ID filteredApplicationIdsByCompletionTime = entitiesWithCompletionTime.Union(applicationIdsFromRecords).ToList(); } var query = _db.Queryable() .WhereIF(!string.IsNullOrEmpty(input.id), p => p.Id.Contains(input.id)) .WhereIF(!string.IsNullOrEmpty(input.applicationUserId), p => p.ApplicationUserId.Contains(input.applicationUserId)) .WhereIF(!string.IsNullOrEmpty(input.applicationUserName), p => p.ApplicationUserName.Contains(input.applicationUserName)) .WhereIF(!string.IsNullOrEmpty(input.applicationStoreId), p => p.ApplicationStoreId.Contains(input.applicationStoreId)) .WhereIF(queryApplicationTime != null, p => p.ApplicationTime >= new DateTime(startApplicationTime.ToDate().Year, startApplicationTime.ToDate().Month, startApplicationTime.ToDate().Day, 0, 0, 0)) .WhereIF(queryApplicationTime != null, p => p.ApplicationTime <= new DateTime(endApplicationTime.ToDate().Year, endApplicationTime.ToDate().Month, endApplicationTime.ToDate().Day, 23, 59, 59)) .WhereIF(!string.IsNullOrEmpty(input.amount), p => p.Amount.Contains(input.amount)) .WhereIF(!string.IsNullOrEmpty(input.approveUser), p => p.ApproveUser.Equals(input.approveUser)) .WhereIF(!string.IsNullOrEmpty(input.approveStatus), p => (p.ApprovalStatus ?? p.ApproveStatus).Contains(input.approveStatus)) .WhereIF(!string.IsNullOrEmpty(input.purchaseRecordsId), p => p.PurchaseRecordsId.Contains(input.purchaseRecordsId)) .WhereIF(filteredApplicationIdsByCompletionTime != null && filteredApplicationIdsByCompletionTime.Any(), p => filteredApplicationIdsByCompletionTime.Contains(p.Id)) .WhereIF(filteredApplicationIdsByCompletionTime != null && !filteredApplicationIdsByCompletionTime.Any(), p => false); // 处理排序(兼容前端传入的字段名) if (string.IsNullOrEmpty(input.sidx)) { query = query.OrderBy(x => x.ApplicationTime, OrderByType.Desc); } else { var sortType = input.sort?.ToLower() == "desc" ? OrderByType.Desc : OrderByType.Asc; switch (input.sidx.ToLower()) { case "id": query = query.OrderBy(x => x.Id, sortType); break; case "applicationtime": case "application_time": query = query.OrderBy(x => x.ApplicationTime, sortType); break; case "amount": query = query.OrderBy(x => x.Amount, sortType); break; case "applicationuserid": case "application_user_id": query = query.OrderBy(x => x.ApplicationUserId, sortType); break; case "applicationusername": case "application_user_name": query = query.OrderBy(x => x.ApplicationUserName, sortType); break; case "approvestatus": case "approve_status": query = query.OrderBy(x => x.ApprovalStatus ?? x.ApproveStatus, sortType); break; case "approvetime": case "approve_time": query = query.OrderBy(x => x.ApproveTime, sortType); break; default: query = query.OrderBy(x => x.ApplicationTime, OrderByType.Desc); break; } } var total = await query.CountAsync(); var entities = await query.ToPageListAsync(input.currentPage, input.pageSize); // 获取当前审批人信息 var applicationIds = entities.Select(x => x.Id).ToList(); var currentApprovers = new List(); if (applicationIds.Any()) { var approverList = await _db.Queryable() .Where(x => applicationIds.Contains(x.ApplicationId)) .InnerJoin((u, a) => u.ApplicationId == a.Id && u.NodeOrder == a.CurrentNodeOrder) .Select((u, a) => new { applicationId = a.Id, approverName = u.UserName }) .ToListAsync(); currentApprovers = approverList.Cast().ToList(); } var approverDict = currentApprovers .GroupBy(x => (string)x.applicationId) .ToDictionary(g => g.Key, g => string.Join(", ", g.Select(x => (string)x.approverName))); // 获取门店名称 var storeIds = entities.Where(x => !string.IsNullOrEmpty(x.ApplicationStoreId)).Select(x => x.ApplicationStoreId).Distinct().ToList(); var storeDict = new Dictionary(); if (storeIds.Any()) { var stores = await _db.Queryable() .Where(x => storeIds.Contains(x.Id)) .Select(x => new { x.Id, x.Dm }) .ToListAsync(); storeDict = stores.ToDictionary(x => x.Id, x => x.Dm ?? ""); } // 批量解析流程名称(含历史数据快照匹配) var applicationWorkflowNameDict = await BuildApplicationWorkflowNameDictAsync(entities); // 获取完成时间(优先使用实体类中的 CompletionTime,如果没有则查询审批记录) var completionTimeDict = new Dictionary(); if (applicationIds.Any()) { var entitiesWithCompletionTime = entities.Where(x => x.CompletionTime.HasValue).ToList(); foreach (var item in entitiesWithCompletionTime) { completionTimeDict[item.Id] = item.CompletionTime; } var entitiesWithoutCompletionTime = entities.Where(x => !x.CompletionTime.HasValue).Select(x => x.Id).ToList(); if (entitiesWithoutCompletionTime.Any()) { var completionRecords = await _db.Queryable() .Where(x => entitiesWithoutCompletionTime.Contains(x.ApplicationId) && x.ApprovalResult == "通过") .GroupBy(x => x.ApplicationId) .Select(x => new { ApplicationId = x.ApplicationId, MaxApprovalTime = SqlFunc.AggregateMax(x.ApprovalTime) }) .ToListAsync(); foreach (var record in completionRecords) { if (!completionTimeDict.ContainsKey(record.ApplicationId)) { completionTimeDict[record.ApplicationId] = record.MaxApprovalTime; } } } } // 组装返回数据 var result = entities.Select(item => new LqReimbursementApplicationListOutput { id = item.Id, applicationNo = item.ApplicationNo, applicationUserId = item.ApplicationUserId, applicationUserName = item.ApplicationUserName, applicationStoreId = item.ApplicationStoreId, applicationStoreName = !string.IsNullOrEmpty(item.ApplicationStoreId) && storeDict.ContainsKey(item.ApplicationStoreId) ? storeDict[item.ApplicationStoreId] : null, applicationTime = item.ApplicationTime, amount = item.Amount, approveUser = item.ApproveUser, approveStatus = item.ApprovalStatus ?? item.ApproveStatus, approveTime = item.ApproveTime, purchaseRecordsId = item.PurchaseRecordsId, currentApprovers = approverDict.ContainsKey(item.Id) ? approverDict[item.Id] : null, currentNodeOrder = item.CurrentNodeOrder, nodeCount = item.NodeCount, completionTime = completionTimeDict.ContainsKey(item.Id) ? completionTimeDict[item.Id] : (item.CompletionTime ?? null), workflowName = applicationWorkflowNameDict.TryGetValue(item.Id, out var resolvedWorkflowName) ? resolvedWorkflowName : null }).ToList(); return PageResult.SqlSugarPageResult( new SqlSugarPagedList { list = result, pagination = new PagedModel { PageIndex = input.currentPage, PageSize = input.pageSize, Total = total } }); } /// /// 新建报销申请表(购买记录购买时间须与申请当月一致,禁止跨月) /// /// 参数 /// 返回创建的申请ID [HttpPost("")] public async Task Create([FromBody] LqReimbursementApplicationCrInput input) { var userInfo = await _userManager.GetUserInfo(); var entity = input.Adapt(); entity.Id = YitIdHelper.NextId().ToString(); // 非管理员只能给自己申请,防止伪造申请人领取他人购买记录 if (!_userManager.IsAdministrator) { entity.ApplicationUserId = userInfo.userId; entity.ApplicationUserName = userInfo.userName; } try { //开启事务 _db.BeginTran(); // 1. 验证节点配置 if (input.nodes == null || input.nodes.Count == 0) { throw new Exception("至少需要配置1个审批节点"); } // 设置合理的上限,避免节点过多 if (input.nodes.Count > 20) { throw new Exception("节点数量不能超过20个"); } // 验证节点顺序是否连续(1, 2, 3, ...) var nodeOrders = input.nodes.Select(n => n.nodeOrder).OrderBy(x => x).ToList(); for (int i = 0; i < nodeOrders.Count; i++) { if (nodeOrders[i] != i + 1) { throw new Exception($"节点顺序必须连续,从1开始"); } } // 验证每个节点至少有一个审批人 foreach (var node in input.nodes) { if (node.approverIds == null || node.approverIds.Count == 0) { throw new Exception($"节点{node.nodeOrder}({node.nodeName})必须至少指定一个审批人"); } } // 2. 设置报销申请初始状态(含流程配置ID,确保入库) entity.WorkflowConfigId = !string.IsNullOrEmpty(input.workflowConfigId) ? input.workflowConfigId.Trim() : null; entity.NodeCount = input.nodes.Count; entity.CurrentNodeOrder = 0; entity.ApprovalStatus = "待审批"; var now = DateTime.Now; entity.ApplicationTime = NormalizeApplicationTime(input.applicationTime, now); if (string.IsNullOrEmpty(entity.ApplicationUserId)) { entity.ApplicationUserId = userInfo.userId; } if (string.IsNullOrEmpty(entity.ApplicationUserName)) { entity.ApplicationUserName = userInfo.userName; } // 同步关联购买编号(与 Update 一致,避免仅传 selectedPurchaseRecordIds 时 F_PurchaseRecordsId 为空) if (input.selectedPurchaseRecordIds != null && input.selectedPurchaseRecordIds.Count > 0) { entity.PurchaseRecordsId = string.Join(",", input.selectedPurchaseRecordIds); } // 生成业务编号(与 ApplicationTime 共用同一 now,禁止客户端传入) var sequence = await GetNextReimbursementApplicationSequenceAsync(now); entity.ApplicationNo = BuildReimbursementApplicationNo(now, sequence); // 3. 保存报销申请表(ignoreNullColumn: false 确保 WorkflowConfigId 等可选字段能正确入库) var isOk = await _db.Insertable(entity).IgnoreColumns(ignoreNullColumn: false).ExecuteCommandAsync(); if (!(isOk > 0)) throw NCCException.Oh(ErrorCode.COM1000); // 4. 创建节点配置 if (input.nodes != null && input.nodes.Count > 0) { foreach (var nodeConfig in input.nodes) { var node = new LqReimbursementApplicationNodeEntity { Id = YitIdHelper.NextId().ToString(), ApplicationId = entity.Id, NodeOrder = nodeConfig.nodeOrder, NodeName = nodeConfig.nodeName, ApprovalType = nodeConfig.approvalType ?? "会签", IsRequired = 1, CreateTime = DateTime.Now }; var nodeResult = await _db.Insertable(node).ExecuteCommandAsync(); if (nodeResult <= 0) { throw new Exception($"创建节点{nodeConfig.nodeOrder}失败"); } // 5. 创建节点审批人 if (nodeConfig.approverIds != null && nodeConfig.approverIds.Count > 0) { for (int i = 0; i < nodeConfig.approverIds.Count; i++) { var nodeUser = new LqReimbursementApplicationNodeUserEntity { Id = YitIdHelper.NextId().ToString(), ApplicationId = entity.Id, NodeId = node.Id, NodeOrder = nodeConfig.nodeOrder, UserId = nodeConfig.approverIds[i], UserName = nodeConfig.approverNames != null && i < nodeConfig.approverNames.Count ? nodeConfig.approverNames[i] : null, SortOrder = i + 1, CreateTime = DateTime.Now }; var userResult = await _db.Insertable(nodeUser).ExecuteCommandAsync(); if (userResult <= 0) { throw new Exception($"创建节点{nodeConfig.nodeOrder}的审批人{nodeConfig.approverIds[i]}失败"); } } } } } // 6. 更新购买记录的审批单编号和审批状态为"待审批"(仅允许绑定申请人本人的购买记录) if (input.selectedPurchaseRecordIds != null && input.selectedPurchaseRecordIds.Count > 0) { await EnsurePurchaseRecordsSameMonthAsApplicationAsync( input.selectedPurchaseRecordIds, entity.ApplicationTime ?? now); await EnsurePurchaseRecordsBelongToApplicantAsync( input.selectedPurchaseRecordIds, entity.ApplicationUserId, null); // 先更新ApplicationId await _db.Updateable() .SetColumns(it => it.ApplicationId == entity.Id) .Where(it => input.selectedPurchaseRecordIds.Contains(it.Id)) .ExecuteCommandAsync(); // 再更新ApproveStatus(分开更新确保都能执行) await _db.Updateable() .SetColumns(it => it.ApproveStatus == "待审批") .Where(it => input.selectedPurchaseRecordIds.Contains(it.Id)) .ExecuteCommandAsync(); } //关闭事务 _db.CommitTran(); await TryWriteBusinessLogAsync( "报销管理", "新增报销申请", "lq_reimbursement_application", entity.Id, $"新增报销申请:{entity.ApplicationNo ?? entity.Id},金额={entity.Amount}", JsonConvert.SerializeObject(new { after = new { entity.Id, entity.ApplicationNo, entity.Amount, entity.ApplicationUserId } })); // 返回创建的申请ID及业务编号 return new { id = entity.Id, applicationNo = entity.ApplicationNo }; } catch (Exception ex) { //回滚事务 _db.RollbackTran(); throw WrapReimbursementApplicationCreateException(ex); } } /// /// 获取报销申请表无分页列表 /// /// 请求参数 /// [NonAction] public async Task GetNoPagingList([FromQuery] LqReimbursementApplicationListQueryInput input) { var sidx = input.sidx == null ? "id" : input.sidx; List queryApplicationTime = input.applicationTime != null ? input.applicationTime.Split(',').ToObeject>() : null; DateTime? startApplicationTime = queryApplicationTime != null ? Ext.GetDateTime(queryApplicationTime.First()) : null; DateTime? endApplicationTime = queryApplicationTime != null ? Ext.GetDateTime(queryApplicationTime.Last()) : null; List queryApproveTime = input.approveTime != null ? input.approveTime.Split(',').ToObeject>() : null; DateTime? startApproveTime = queryApproveTime != null ? Ext.GetDateTime(queryApproveTime.First()) : null; DateTime? endApproveTime = queryApproveTime != null ? Ext.GetDateTime(queryApproveTime.Last()) : null; var entities = await _db.Queryable() .WhereIF(!string.IsNullOrEmpty(input.id), p => p.Id.Contains(input.id)) .WhereIF(!string.IsNullOrEmpty(input.applicationUserId), p => p.ApplicationUserId.Contains(input.applicationUserId)) .WhereIF(!string.IsNullOrEmpty(input.applicationUserName), p => p.ApplicationUserName.Contains(input.applicationUserName)) .WhereIF(!string.IsNullOrEmpty(input.applicationStoreId), p => p.ApplicationStoreId.Contains(input.applicationStoreId)) .WhereIF(queryApplicationTime != null, p => p.ApplicationTime >= new DateTime(startApplicationTime.ToDate().Year, startApplicationTime.ToDate().Month, startApplicationTime.ToDate().Day, 0, 0, 0)) .WhereIF(queryApplicationTime != null, p => p.ApplicationTime <= new DateTime(endApplicationTime.ToDate().Year, endApplicationTime.ToDate().Month, endApplicationTime.ToDate().Day, 23, 59, 59)) .WhereIF(!string.IsNullOrEmpty(input.amount), p => p.Amount.Contains(input.amount)) .WhereIF(!string.IsNullOrEmpty(input.approveUser), p => p.ApproveUser.Equals(input.approveUser)) .WhereIF(!string.IsNullOrEmpty(input.approveStatus), p => (p.ApprovalStatus ?? p.ApproveStatus).Contains(input.approveStatus)) .WhereIF(!string.IsNullOrEmpty(input.purchaseRecordsId), p => p.PurchaseRecordsId.Contains(input.purchaseRecordsId)) .OrderBy(sidx + " " + input.sort) .ToListAsync(); // 批量解析流程名称(含历史数据快照匹配) var applicationWorkflowNameDict = await BuildApplicationWorkflowNameDictAsync(entities); var data = entities.Select(a => new LqReimbursementApplicationListOutput { id = a.Id, applicationNo = a.ApplicationNo, applicationUserId = a.ApplicationUserId, applicationUserName = a.ApplicationUserName, applicationStoreId = a.ApplicationStoreId, applicationTime = a.ApplicationTime, amount = a.Amount, approveUser = a.ApproveUser, approveStatus = a.ApprovalStatus ?? a.ApproveStatus, approveTime = a.ApproveTime, purchaseRecordsId = a.PurchaseRecordsId, workflowName = applicationWorkflowNameDict.TryGetValue(a.Id, out var resolvedWorkflowName) ? resolvedWorkflowName : null }).ToList(); return data; } /// /// 导出报销申请表 /// /// 请求参数 /// [HttpGet("Actions/Export")] public async Task Export([FromQuery] LqReimbursementApplicationListQueryInput input) { var userInfo = await _userManager.GetUserInfo(); var exportData = new List(); if (input.dataType == 0) { var data = Clay.Object(await this.GetList(input)); exportData = data.Solidify>().list; } else { exportData = await this.GetNoPagingList(input); } List paramList = "[{\"value\":\"申请ID\",\"field\":\"id\"},{\"value\":\"编号\",\"field\":\"applicationNo\"},{\"value\":\"申请人编号\",\"field\":\"applicationUserId\"},{\"value\":\"申请人姓名\",\"field\":\"applicationUserName\"},{\"value\":\"申请门店\",\"field\":\"applicationStoreId\"},{\"value\":\"申请时间\",\"field\":\"applicationTime\"},{\"value\":\"总金额\",\"field\":\"amount\"},{\"value\":\"审批人\",\"field\":\"approveUser\"},{\"value\":\"审批结果\",\"field\":\"approveStatus\"},{\"value\":\"审批时间\",\"field\":\"approveTime\"},{\"value\":\"关联购买编号\",\"field\":\"purchaseRecordsId\"},{\"value\":\"流程名称\",\"field\":\"workflowName\"}]".ToList(); ExcelConfig excelconfig = new ExcelConfig(); excelconfig.FileName = "报销申请表.xls"; excelconfig.HeadFont = "微软雅黑"; excelconfig.HeadPoint = 10; excelconfig.IsAllSizeColumn = true; excelconfig.ColumnModel = new List(); // 当未传入 selectKey 时,默认导出全部字段,避免空引用异常 List selectKeyList = !string.IsNullOrEmpty(input.selectKey) ? input.selectKey.Split(',').ToList() : paramList.Select(p => p.field).ToList(); foreach (var item in selectKeyList) { var isExist = paramList.Find(p => p.field == item); if (isExist != null) { excelconfig.ColumnModel.Add(new ExcelColumnModel() { Column = isExist.field, ExcelColumn = isExist.value }); } } var addPath = FileVariable.TemporaryFilePath + excelconfig.FileName; ExcelExportHelper.Export(exportData, excelconfig, addPath); await TryWriteBusinessLogAsync( "报销管理", "导出报销申请", "lq_reimbursement_application", null, $"导出报销申请列表,共 {exportData.Count} 条", JsonConvert.SerializeObject(new { rowCount = exportData.Count, fileName = excelconfig.FileName, input.approveStatus, input.applicationUserId })); var fileName = _userManager.UserId + "|" + addPath + "|xls"; var output = new { name = excelconfig.FileName, url = "/api/File/Download?encryption=" + DESCEncryption.Encrypt(fileName, "NCC") }; return output; } /// /// 批量删除报销申请表(仅待审批/已退回;同步解绑购买记录) /// /// 主键数组 /// [HttpPost("batchRemove")] public async Task BatchRemove([FromBody] List ids) { if (ids == null || ids.Count == 0) { return; } var entitys = await _db.Queryable().In(it => it.Id, ids).ToListAsync(); if (entitys.Count == 0) { return; } foreach (var item in entitys) { EnsureApplicationDeletable(item); if (!_userManager.IsAdministrator && item.ApplicationUserId != _userManager.UserId) { throw new Exception($"只能删除本人的报销申请:{item.ApplicationNo ?? item.Id}"); } } try { _db.BeginTran(); foreach (var item in entitys) { await UnbindPurchaseRecordsOnDeleteAsync(item); await CleanupApplicationChildrenAsync(item.Id); } await _db.Deleteable().In(d => d.Id, ids).ExecuteCommandAsync(); _db.CommitTran(); foreach (var item in entitys) { await TryWriteBusinessLogAsync( "报销管理", "批量删除报销申请", "lq_reimbursement_application", item.Id, $"批量删除报销申请:{item.ApplicationNo ?? item.Id}", JsonConvert.SerializeObject(new { before = new { item.Id, item.ApplicationNo, item.ApprovalStatus } })); } } catch (Exception) { _db.RollbackTran(); throw; } } /// /// 更新报销申请表(改选购买记录时校验购买时间与申请当月一致) /// /// 主键 /// 参数 /// [HttpPut("{id}")] public async Task Update(string id, [FromBody] LqReimbursementApplicationUpInput input) { try { //开启事务 _db.BeginTran(); // 获取原有的关联购买记录ID var oldEntity = await _db.Queryable().FirstAsync(p => p.Id == id); _ = oldEntity ?? throw NCCException.Oh(ErrorCode.COM1005); // 检查是否可以修改:只有"待审批"(CurrentNodeOrder=0)或"已退回"状态的申请才能修改 if (oldEntity.CurrentNodeOrder != null && oldEntity.CurrentNodeOrder != 0 && oldEntity.ApprovalStatus != "已退回") { throw new Exception($"该申请当前状态为{oldEntity.ApprovalStatus},无法修改。只有待审批或已退回状态的申请才能修改。"); } // 非管理员只能改自己的申请,且禁止改申请人(防伪造申请人绑定他人购买) if (!_userManager.IsAdministrator) { if (oldEntity.ApplicationUserId != _userManager.UserId) { throw new Exception("只能修改本人的报销申请"); } input.applicationUserId = oldEntity.ApplicationUserId; input.applicationUserName = oldEntity.ApplicationUserName; } var oldIds = new List(); if (oldEntity != null && !string.IsNullOrEmpty(oldEntity.PurchaseRecordsId)) { // 获取原有购买记录ID列表 oldIds = oldEntity.PurchaseRecordsId.Split(',').Where(x => !string.IsNullOrEmpty(x)).ToList(); } // 获取新的购买记录ID列表 var newIds = input.selectedPurchaseRecordIds ?? new List(); // 确保 purchaseRecordsId 字段包含所有选中的记录ID(逗号分隔) if (newIds.Count > 0) { input.purchaseRecordsId = string.Join(",", newIds); } else { input.purchaseRecordsId = null; } // 找出需要移除关联的记录(在旧列表中但不在新列表中) var idsToRemove = oldIds.Where(x => !newIds.Contains(x)).ToList(); if (idsToRemove.Count > 0) { await UnbindPurchaseRecordsAsync(it => idsToRemove.Contains(it.Id)); } // 更新报销申请表(确保 purchaseRecordsId、WorkflowConfigId 等字段被正确更新) var entity = input.Adapt(); entity.Id = id; // 确保使用路由参数中的主键 entity.WorkflowConfigId = !string.IsNullOrEmpty(input.workflowConfigId) ? input.workflowConfigId.Trim() : oldEntity?.WorkflowConfigId; if (input.applicationTime.HasValue) { entity.ApplicationTime = NormalizeApplicationTime(input.applicationTime, DateTime.Now); } var isOk = await _db.Updateable(entity).IgnoreColumns(ignoreAllNullColumns: true).ExecuteCommandAsync(); if (!(isOk > 0)) throw NCCException.Oh(ErrorCode.COM1001); // 更新所有选中的购买记录的审批单编号和审批状态为"待审批" // 包括新追加的记录和已存在的记录(确保状态正确);仅允许绑定申请人本人的购买记录 if (newIds.Count > 0) { await EnsurePurchaseRecordsSameMonthAsApplicationAsync( newIds, entity.ApplicationTime ?? input.applicationTime ?? oldEntity.ApplicationTime); // 绑定归属以库中原申请人为准(非管理员已强制不可改申请人) var applicantId = !string.IsNullOrEmpty(input.applicationUserId) ? input.applicationUserId : oldEntity.ApplicationUserId; await EnsurePurchaseRecordsBelongToApplicantAsync(newIds, applicantId, id); // 先更新ApplicationId await _db.Updateable() .SetColumns(it => it.ApplicationId == id) .Where(it => newIds.Contains(it.Id)) .ExecuteCommandAsync(); // 再更新ApproveStatus(分开更新确保都能执行) await _db.Updateable() .SetColumns(it => it.ApproveStatus == "待审批") .Where(it => newIds.Contains(it.Id)) .ExecuteCommandAsync(); } //关闭事务 _db.CommitTran(); await TryWriteBusinessLogAsync( "报销管理", "修改报销申请", "lq_reimbursement_application", id, $"修改报销申请:{oldEntity.ApplicationNo ?? id}", JsonConvert.SerializeObject(new { before = new { oldEntity.Id, oldEntity.ApplicationNo, oldEntity.Amount }, after = new { entity.Amount, entity.ApprovalStatus } })); } catch (Exception) { //回滚事务 _db.RollbackTran(); throw; } } /// /// 删除报销申请表(仅待审批/已退回;同步解绑购买记录) /// /// [HttpDelete("{id}")] public async Task Delete(string id) { var entity = await _db.Queryable().FirstAsync(p => p.Id == id); _ = entity ?? throw NCCException.Oh(ErrorCode.COM1005); EnsureApplicationDeletable(entity); if (!_userManager.IsAdministrator && entity.ApplicationUserId != _userManager.UserId) { throw new Exception("只能删除本人的报销申请"); } try { _db.BeginTran(); await UnbindPurchaseRecordsOnDeleteAsync(entity); await CleanupApplicationChildrenAsync(id); var isOk = await _db.Deleteable().Where(d => d.Id == id).ExecuteCommandAsync(); if (!(isOk > 0)) throw NCCException.Oh(ErrorCode.COM1002); _db.CommitTran(); } catch (Exception) { _db.RollbackTran(); throw; } await TryWriteBusinessLogAsync( "报销管理", "删除报销申请", "lq_reimbursement_application", id, $"删除报销申请:{entity.ApplicationNo ?? id}", JsonConvert.SerializeObject(new { before = new { entity.Id, entity.ApplicationNo, entity.Amount, entity.ApprovalStatus, entity.PurchaseRecordsId } })); } /// /// 仅允许删除待审批(未进入流程)或已退回的申请 /// private static void EnsureApplicationDeletable(LqReimbursementApplicationEntity entity) { var status = entity.ApprovalStatus ?? entity.ApproveStatus; var isPending = entity.CurrentNodeOrder == null || entity.CurrentNodeOrder == 0 || status == "待审批" || string.IsNullOrEmpty(status); var isReturned = status == "已退回"; if (!isPending && !isReturned) { throw new Exception($"该申请当前状态为{status ?? "未知"},无法删除。仅待审批或已退回的申请可删除。"); } } /// /// 删除申请时解绑购买记录,恢复为未审批 /// private async Task UnbindPurchaseRecordsOnDeleteAsync(LqReimbursementApplicationEntity entity) { var purchaseIds = await ResolvePurchaseRecordIdsAsync(entity.PurchaseRecordsId, entity.Id); if (purchaseIds.Count == 0) { return; } await UnbindPurchaseRecordsAsync(it => purchaseIds.Contains(it.Id) || it.ApplicationId == entity.Id); } /// /// 解绑购买记录与报销申请(须能把 ApplicationId 写成 NULL) /// private async Task UnbindPurchaseRecordsAsync(Expression> whereExp) { await _db.Updateable() .SetColumns(it => it.ApplicationId == null) .SetColumns(it => it.ApproveStatus == "未审批") .SetColumns(it => it.ApproveTime == null) .SetColumns(it => it.ApproveUser == null) .Where(whereExp) .ExecuteCommandAsync(); } /// /// 修复选中购买记录上指向已退回或不存在申请的脏 ApplicationId(仅处理当前选中 ID,不全表扫描) /// private async Task HealStalePurchaseRecordBindingsAsync(List purchaseRecordIds) { if (purchaseRecordIds == null || purchaseRecordIds.Count == 0) { return; } var records = await _db.Queryable() .Where(x => purchaseRecordIds.Contains(x.Id) && x.ApplicationId != null) .Select(x => new { x.Id, x.ApplicationId }) .ToListAsync(); if (records.Count == 0) { return; } var appIds = records.Select(x => x.ApplicationId).Distinct().ToList(); var apps = await _db.Queryable() .Where(x => appIds.Contains(x.Id)) .Select(x => new { x.Id, x.ApprovalStatus, x.ApproveStatus }) .ToListAsync(); var appStatusMap = apps.ToDictionary(x => x.Id, x => x.ApprovalStatus ?? x.ApproveStatus); var idsToHeal = records .Where(r => !appStatusMap.ContainsKey(r.ApplicationId) || appStatusMap[r.ApplicationId] == "已退回") .Select(r => r.Id) .ToList(); if (idsToHeal.Count == 0) { return; } await UnbindPurchaseRecordsAsync(it => idsToHeal.Contains(it.Id)); } /// /// 清理申请关联的节点、审批人、审批记录 /// private async Task CleanupApplicationChildrenAsync(string applicationId) { await _db.Deleteable() .Where(x => x.ApplicationId == applicationId) .ExecuteCommandAsync(); await _db.Deleteable() .Where(x => x.ApplicationId == applicationId) .ExecuteCommandAsync(); await _db.Deleteable() .Where(x => x.ApplicationId == applicationId) .ExecuteCommandAsync(); } /// /// 提交审批(进入第一个节点;提交时再次校验购买时间与申请当月一致) /// /// 申请编号 /// [HttpPost("{id}/Actions/SubmitApproval")] public async Task SubmitApproval(string id) { var entity = await _db.Queryable().FirstAsync(p => p.Id == id); _ = entity ?? throw NCCException.Oh(ErrorCode.COM1005); if (!_userManager.IsAdministrator && entity.ApplicationUserId != _userManager.UserId) { throw new Exception("只能提交本人的报销申请"); } // 允许"待审批"和"已退回"状态的申请提交审批 if (entity.CurrentNodeOrder != 0 && entity.ApprovalStatus != "已退回") { throw new Exception("该申请已经提交审批,不能重复提交"); } if (entity.NodeCount == null || entity.NodeCount == 0) { throw new Exception("节点配置异常,无法提交审批"); } var submitPurchaseIds = await ResolvePurchaseRecordIdsAsync(entity.PurchaseRecordsId, id); await EnsurePurchaseRecordsSameMonthAsApplicationAsync(submitPurchaseIds, entity.ApplicationTime); try { _db.BeginTran(); // 获取第一个节点 var firstNode = await _db.Queryable() .Where(x => x.ApplicationId == id && x.NodeOrder == 1) .FirstAsync(); if (firstNode == null) { throw new Exception("未找到第一个审批节点配置"); } // 更新报销申请状态 entity.CurrentNodeOrder = 1; entity.CurrentNodeId = firstNode.Id; entity.ApprovalStatus = "审批中"; // 清除退回原因(重新提交审批) entity.ReturnedReason = null; entity.ReturnedNodeOrder = null; await _db.Updateable(entity).ExecuteCommandAsync(); // 获取第一个节点的所有审批人 var firstNodeApprovers = await _db.Queryable() .Where(x => x.ApplicationId == id && x.NodeOrder == 1) .ToListAsync(); // 获取第一个节点已有的审批记录 var existingRecords = await _db.Queryable() .Where(x => x.ApplicationId == id && x.NodeOrder == 1) .ToListAsync(); // 为第一个节点的每个审批人创建待审批记录(如果不存在) foreach (var approver in firstNodeApprovers) { // 检查是否已存在该审批人的"待审批"记录 var existingPendingRecord = existingRecords.FirstOrDefault(x => x.ApproverId == approver.UserId && x.ApprovalResult == "待审批"); if (existingPendingRecord == null) { // 如果不存在"待审批"记录,创建新的待审批记录 // 注意:即使之前有"退回"记录,也创建新的"待审批"记录,保留历史记录 var record = new LqReimbursementApprovalRecordEntity { Id = YitIdHelper.NextId().ToString(), ApplicationId = id, NodeId = firstNode.Id, NodeOrder = 1, ApproverId = approver.UserId, ApproverName = approver.UserName, ApprovalResult = "待审批", IsCurrentNode = 1, ApprovalTime = null }; await _db.Insertable(record).ExecuteCommandAsync(); } else { // 如果已存在"待审批"记录,只更新IsCurrentNode状态 existingPendingRecord.IsCurrentNode = 1; await _db.Updateable(existingPendingRecord).ExecuteCommandAsync(); } } // 更新所有审批记录的IsCurrentNode状态(将第一个节点的"待审批"记录设为1,其他设为0) // 注意:保留所有历史记录(包括"退回"记录),只更新IsCurrentNode状态 await _db.Updateable() .SetColumns(it => it.IsCurrentNode == 0) .Where(it => it.ApplicationId == id && (it.NodeOrder != 1 || it.ApprovalResult != "待审批")) .ExecuteCommandAsync(); _db.CommitTran(); await TryWriteBusinessLogAsync( "报销管理", "提交报销审批", "lq_reimbursement_application", id, $"提交报销审批:{entity.ApplicationNo ?? id}", JsonConvert.SerializeObject(new { applicationId = id, entity.ApplicationNo, entity.NodeCount })); } catch (Exception) { _db.RollbackTran(); throw; } } /// /// 审批操作(通过/不通过/退回) /// /// 申请编号 /// 审批结果:通过/不通过/退回 /// 审批意见 /// [HttpPost("{id}/Actions/Approve")] public async Task Approve(string id, [FromQuery] string result, [FromQuery] string opinion = "") { if (string.IsNullOrWhiteSpace(result)) { throw new Exception("审批结果不能为空"); } var normalizedResult = result.Trim(); if (normalizedResult != "通过" && normalizedResult != "不通过" && normalizedResult != "退回") { throw new Exception("审批结果无效,仅支持:通过、不通过、退回"); } var userInfo = await _userManager.GetUserInfo(); var entity = await _db.Queryable().FirstAsync(p => p.Id == id); _ = entity ?? throw NCCException.Oh(ErrorCode.COM1005); if (entity.CurrentNodeOrder == null || entity.CurrentNodeOrder == 0) { throw new Exception("该申请尚未提交审批"); } if (entity.ApprovalStatus != "审批中") { throw new Exception($"该申请当前状态为{entity.ApprovalStatus},无法进行审批操作"); } // 验证当前用户是否有审批权限(管理员可以审批所有节点) var isAdmin = userInfo.isAdministrator; if (!isAdmin) { var hasPermission = await _db.Queryable() .Where(x => x.ApplicationId == id && x.NodeOrder == entity.CurrentNodeOrder && x.UserId == userInfo.userId) .AnyAsync(); if (!hasPermission) { throw new Exception("您没有当前节点的审批权限"); } } // 检查是否已经审批过(排除待审批状态) // 注意:如果存在"待审批"记录,说明可以审批 // 如果不存在"待审批"记录,但存在其他状态的记录(通过、不通过),说明已经审批过 // 但是,如果之前有"退回"记录,重新提交审批后会创建新的"待审批"记录,所以这里优先检查"待审批"状态 var existingPendingApprovalRecord = await _db.Queryable() .Where(x => x.ApplicationId == id && x.NodeOrder == entity.CurrentNodeOrder && x.ApproverId == userInfo.userId && x.ApprovalResult == "待审批") .FirstAsync(); // 如果存在"待审批"记录,说明可以审批,不需要抛出异常 // 如果不存在"待审批"记录,需要检查是否有"通过"或"不通过"的记录(不包括"退回",因为退回后可以重新审批) // 注意:如果状态已经是"已通过",说明整个流程已完成,不允许再次审批 if (existingPendingApprovalRecord == null) { // 如果申请状态已经是"已通过",不允许再次审批 if (entity.ApprovalStatus == "已通过") { throw new Exception("该申请已经审批通过,无法再次审批"); } // 检查是否有"通过"或"不通过"的记录(不包括"退回") var completedRecord = await _db.Queryable() .Where(x => x.ApplicationId == id && x.NodeOrder == entity.CurrentNodeOrder && x.ApproverId == userInfo.userId && (x.ApprovalResult == "通过" || x.ApprovalResult == "不通过")) .FirstAsync(); if (completedRecord != null) { // 如果申请状态还是"审批中",说明还有其他审批人未审批,当前用户已经审批过,不允许重复审批 throw new Exception("您已经审批过该节点"); } } try { _db.BeginTran(); // 获取当前节点信息 var currentNode = await _db.Queryable() .Where(x => x.ApplicationId == id && x.NodeOrder == entity.CurrentNodeOrder) .FirstAsync(); if (currentNode == null) { throw new Exception("未找到当前节点配置"); } // 查找现有的审批记录(优先查找"待审批"记录) var existingRecord = await _db.Queryable() .Where(x => x.ApplicationId == id && x.NodeOrder == entity.CurrentNodeOrder && x.ApproverId == userInfo.userId && x.ApprovalResult == "待审批") .FirstAsync(); // 如果不存在"待审批"记录,再查找其他记录 if (existingRecord == null) { existingRecord = await _db.Queryable() .Where(x => x.ApplicationId == id && x.NodeOrder == entity.CurrentNodeOrder && x.ApproverId == userInfo.userId) .FirstAsync(); } if (existingRecord != null) { // 如果审批结果是"待审批",允许更新 // 如果已经有明确的审批结果(通过/不通过),则不允许重复审批 // 注意:不包括"退回",因为退回后可以重新审批 if (!string.IsNullOrEmpty(existingRecord.ApprovalResult) && existingRecord.ApprovalResult != "待审批" && existingRecord.ApprovalResult != "" && existingRecord.ApprovalResult != "退回") { // 已经有明确的审批结果(通过/不通过),不允许重复审批 throw new Exception("您已经审批过该节点"); } // 更新现有记录(包括空字符串、"待审批"、"退回"的情况) // 注意:只更新审批结果和意见,不更新审批人信息(ApproverId和ApproverName在创建时已确定) existingRecord.ApprovalResult = normalizedResult; existingRecord.ApprovalOpinion = opinion; existingRecord.ApprovalTime = DateTime.Now; existingRecord.IsCurrentNode = 1; await _db.Updateable(existingRecord).ExecuteCommandAsync(); } else { // 创建新记录(如果不存在) var approvalRecord = new LqReimbursementApprovalRecordEntity { Id = YitIdHelper.NextId().ToString(), ApplicationId = id, NodeId = currentNode.Id, NodeOrder = entity.CurrentNodeOrder.Value, ApproverId = userInfo.userId, ApproverName = userInfo.userName, ApprovalResult = normalizedResult, ApprovalOpinion = opinion, ApprovalTime = DateTime.Now, IsCurrentNode = 1 }; await _db.Insertable(approvalRecord).ExecuteCommandAsync(); } // 根据审批结果处理 if (normalizedResult == "不通过") { // 不通过:审批结束 entity.ApprovalStatus = "未通过"; await _db.Updateable(entity).ExecuteCommandAsync(); // 更新所有购买记录状态为"未通过"(通过ApplicationId关联更新) await _db.Updateable() .SetColumns(it => new LqPurchaseRecordsEntity { ApproveStatus = "未通过", ApproveTime = DateTime.Now, ApproveUser = userInfo.userId }) .Where(it => it.ApplicationId == id) .ExecuteCommandAsync(); } else if (normalizedResult == "退回") { // 退回:退回到上一节点 // 先更新当前节点的退回记录的IsCurrentNode状态(设为0,因为不再是当前节点) var currentNodeOrder = entity.CurrentNodeOrder.Value; await _db.Updateable() .SetColumns(it => it.IsCurrentNode == 0) .Where(x => x.ApplicationId == id && x.NodeOrder == currentNodeOrder) .ExecuteCommandAsync(); if (entity.CurrentNodeOrder == 1) { // 退回到申请人 entity.CurrentNodeOrder = 0; entity.ApprovalStatus = "已退回"; entity.ReturnedNodeOrder = 0; entity.ReturnedReason = opinion; entity.CurrentNodeId = null; // 注意:不退回到发起人时,不删除审批记录,保留所有历史记录(包括退回记录) // 解绑购买记录并重置为「未审批」,直接回到申请人物品购买池,无需逐条点更新 await UnbindPurchaseRecordsAsync(it => it.ApplicationId == id); entity.PurchaseRecordsId = null; } else { // 退回到上一节点 entity.CurrentNodeOrder -= 1; entity.ReturnedNodeOrder = entity.CurrentNodeOrder; entity.ReturnedReason = opinion; // 获取上一节点信息 var prevNode = await _db.Queryable() .Where(x => x.ApplicationId == id && x.NodeOrder == entity.CurrentNodeOrder) .FirstAsync(); if (prevNode != null) { entity.CurrentNodeId = prevNode.Id; } // 获取上一节点已有的审批记录 var prevNodeExistingRecords = await _db.Queryable() .Where(x => x.ApplicationId == id && x.NodeOrder == entity.CurrentNodeOrder) .ToListAsync(); // 获取上一节点的所有审批人 var prevNodeApprovers = await _db.Queryable() .Where(x => x.ApplicationId == id && x.NodeOrder == entity.CurrentNodeOrder) .ToListAsync(); // 为上一节点的每个审批人创建待审批记录(如果不存在) foreach (var approver in prevNodeApprovers) { // 检查是否已存在该审批人的"待审批"记录 var prevNodeExistingPendingRecord = prevNodeExistingRecords.FirstOrDefault(x => x.ApproverId == approver.UserId && x.ApprovalResult == "待审批"); if (prevNodeExistingPendingRecord == null) { // 如果不存在"待审批"记录,创建新的待审批记录 // 注意:即使之前有"退回"或其他记录,也创建新的"待审批"记录,保留历史记录 var record = new LqReimbursementApprovalRecordEntity { Id = YitIdHelper.NextId().ToString(), ApplicationId = id, NodeId = prevNode.Id, NodeOrder = entity.CurrentNodeOrder.Value, ApproverId = approver.UserId, ApproverName = approver.UserName, ApprovalResult = "待审批", IsCurrentNode = 1, ApprovalTime = null }; await _db.Insertable(record).ExecuteCommandAsync(); } else { // 如果已存在"待审批"记录,只更新IsCurrentNode状态 prevNodeExistingPendingRecord.IsCurrentNode = 1; await _db.Updateable(prevNodeExistingPendingRecord).ExecuteCommandAsync(); } } } await _db.Updateable(entity).ExecuteCommandAsync(); } else if (normalizedResult == "通过") { // 通过:判断是否需要进入下一个节点 bool shouldMoveToNext = false; if (currentNode.ApprovalType == "或签") { // 或签:任意一个审批人通过,立即进入下一个节点 shouldMoveToNext = true; } else // 会签 { // 会签:检查是否所有审批人都已通过 var approvers = await _db.Queryable() .Where(x => x.ApplicationId == id && x.NodeOrder == entity.CurrentNodeOrder) .Select(x => x.UserId) .ToListAsync(); // 查询所有"通过"的审批记录,包括当前用户刚审批的记录 // 注意:由于在事务中,需要确保查询包含当前刚更新的记录 var approvedUsers = await _db.Queryable() .Where(x => x.ApplicationId == id && x.NodeOrder == entity.CurrentNodeOrder && x.ApprovalResult == "通过") .Select(x => x.ApproverId) .Distinct() .ToListAsync(); // 如果当前用户刚审批通过,但查询结果中还没有包含,手动添加 if (normalizedResult == "通过" && !approvedUsers.Contains(userInfo.userId)) { approvedUsers.Add(userInfo.userId); } if (approvers.Count == approvedUsers.Count && approvers.Count > 0) { // 所有人都已通过 shouldMoveToNext = true; } // 特殊情况:如果只有一个审批人,且当前审批人就是该审批人,且审批结果是"通过",则直接进入下一节点 else if (approvers.Count == 1 && approvers.Contains(userInfo.userId) && normalizedResult == "通过") { shouldMoveToNext = true; } } if (shouldMoveToNext) { // 进入下一个节点或完成审批 await MoveToNextNode(id, userInfo.userId); } } _db.CommitTran(); await TryWriteBusinessLogAsync( "报销管理", "审批报销申请", "lq_reimbursement_application", id, $"审批报销申请:{entity.ApplicationNo ?? id},结果={normalizedResult}", JsonConvert.SerializeObject(new { applicationId = id, result = normalizedResult, opinion, nodeOrder = entity.CurrentNodeOrder })); } catch (Exception) { _db.RollbackTran(); throw; } } /// /// 从申请单字段或关联购买记录解析购买记录ID列表 /// private async Task> ResolvePurchaseRecordIdsAsync(string purchaseRecordsId, string applicationId) { var ids = new List(); if (!string.IsNullOrEmpty(purchaseRecordsId)) { ids = purchaseRecordsId.Split(',') .Where(x => !string.IsNullOrWhiteSpace(x)) .Select(x => x.Trim()) .Distinct() .ToList(); } if (ids.Count == 0 && !string.IsNullOrEmpty(applicationId)) { ids = await _db.Queryable() .Where(x => x.ApplicationId == applicationId) .Select(x => x.Id) .ToListAsync(); } return ids; } /// /// 校验购买记录购买时间与申请时间须为同一自然月,禁止跨月报销 /// /// 购买记录ID /// 申请时间,为空则取当前时间 private async Task EnsurePurchaseRecordsSameMonthAsApplicationAsync( List purchaseRecordIds, DateTime? applicationTime) { if (purchaseRecordIds == null || purchaseRecordIds.Count == 0) { return; } var appTime = applicationTime ?? DateTime.Now; var appYear = appTime.Year; var appMonth = appTime.Month; var records = await _db.Queryable() .Where(x => purchaseRecordIds.Contains(x.Id)) .Select(x => new { x.Id, x.PurchaseTime }) .ToListAsync(); if (records.Count != purchaseRecordIds.Distinct().Count()) { throw new Exception("存在无效的购买记录,请刷新后重试"); } var mismatchedMonths = new List(); foreach (var record in records) { if (!record.PurchaseTime.HasValue) { throw new Exception("存在缺少购买时间的购买记录,无法申请报销"); } var purchaseTime = record.PurchaseTime.Value; if (purchaseTime.Year != appYear || purchaseTime.Month != appMonth) { mismatchedMonths.Add($"{purchaseTime.Year}-{purchaseTime.Month:D2}"); } } if (mismatchedMonths.Count > 0) { var monthHint = string.Join("、", mismatchedMonths.Distinct()); throw new Exception($"不能申请跨月报销,购买记录必须与申请当月一致(存在 {monthHint} 的购买记录)"); } } /// /// 校验所选购买记录归属申请人本人(报销按个人,不按门店共享) /// /// 购买记录ID /// 申请人用户ID /// 当前申请单ID(编辑时允许已挂靠本单的记录) private async Task EnsurePurchaseRecordsBelongToApplicantAsync( List purchaseRecordIds, string applicantUserId, string currentApplicationId) { if (purchaseRecordIds == null || purchaseRecordIds.Count == 0) { return; } if (string.IsNullOrWhiteSpace(applicantUserId)) { throw new Exception("申请人不能为空,无法绑定购买记录"); } await HealStalePurchaseRecordBindingsAsync(purchaseRecordIds); var records = await _db.Queryable() .Where(x => purchaseRecordIds.Contains(x.Id)) .Select(x => new { x.Id, x.CreateUser, x.ApplicationId, x.ApproveStatus }) .ToListAsync(); if (records.Count != purchaseRecordIds.Distinct().Count()) { throw new Exception("存在无效的购买记录,请刷新后重试"); } var notOwn = records .Where(x => !string.IsNullOrEmpty(x.CreateUser) && x.CreateUser != applicantUserId) .Select(x => x.Id) .ToList(); if (notOwn.Count > 0) { throw new Exception("只能报销本人创建的物品购买记录,不能按门店领取他人单据"); } var occupied = records .Where(x => !string.IsNullOrEmpty(x.ApplicationId) && (string.IsNullOrEmpty(currentApplicationId) || x.ApplicationId != currentApplicationId)) .Select(x => x.Id) .ToList(); if (occupied.Count > 0) { throw new Exception("所选购买记录已关联其他报销申请,请重新选择"); } } /// /// 进入下一个节点 /// private async Task MoveToNextNode(string applicationId, string approveUserId) { var entity = await _db.Queryable() .FirstAsync(x => x.Id == applicationId); // 判断是否是最后一个节点 if (entity.CurrentNodeOrder >= entity.NodeCount) { // 审批完成 entity.CurrentNodeOrder = entity.NodeCount + 1; entity.ApprovalStatus = "已通过"; entity.CurrentNodeId = null; entity.CompletionTime = DateTime.Now; // 设置完成时间 await _db.Updateable(entity).ExecuteCommandAsync(); // 更新所有购买记录状态为"已审批" // 通过ApplicationId关联更新,因为PurchaseRecordsId可能为空 await _db.Updateable() .SetColumns(it => new LqPurchaseRecordsEntity { ApproveStatus = "已审批", ApproveTime = DateTime.Now, ApproveUser = approveUserId }) .Where(it => it.ApplicationId == applicationId) .ExecuteCommandAsync(); } else { // 进入下一个节点 entity.CurrentNodeOrder += 1; // 获取下一个节点信息 var nextNode = await _db.Queryable() .Where(x => x.ApplicationId == applicationId && x.NodeOrder == entity.CurrentNodeOrder) .FirstAsync(); if (nextNode == null) { throw new Exception($"未找到节点{entity.CurrentNodeOrder}的配置"); } entity.CurrentNodeId = nextNode.Id; entity.ApprovalStatus = "审批中"; await _db.Updateable(entity).ExecuteCommandAsync(); // 清除之前的当前节点标记 await _db.Updateable() .SetColumns(it => new LqReimbursementApprovalRecordEntity { IsCurrentNode = 0 }) .Where(it => it.ApplicationId == applicationId) .ExecuteCommandAsync(); // 为下一个节点的每个审批人创建待审批记录 var nextNodeApprovers = await _db.Queryable() .Where(x => x.ApplicationId == applicationId && x.NodeOrder == entity.CurrentNodeOrder) .ToListAsync(); foreach (var approver in nextNodeApprovers) { var record = new LqReimbursementApprovalRecordEntity { Id = YitIdHelper.NextId().ToString(), ApplicationId = applicationId, NodeId = nextNode.Id, NodeOrder = entity.CurrentNodeOrder.Value, ApproverId = approver.UserId, ApproverName = approver.UserName, ApprovalResult = "待审批", IsCurrentNode = 1, ApprovalTime = null }; await _db.Insertable(record).ExecuteCommandAsync(); } } } /// /// 获取所有待办列表(管理员用,所有待审批的申请) /// /// /// 管理员可以查看所有状态为"审批中"的报销申请列表。 /// /// 示例请求: /// ``` /// GET /api/Extend/LqReimbursementApplication/Actions/AllPendingApproval?currentPage=1&pageSize=20 /// ``` /// /// 参数说明: /// - currentPage: 当前页码(默认1) /// - pageSize: 每页数量(默认20) /// - applicationStoreId: 申请门店ID(可选) /// - 其他查询参数与 GetList 接口相同 /// /// 返回说明: /// - 返回分页列表,只包含状态为"审批中"的申请 /// - 每条记录包含:申请编号、申请人信息、门店信息、审批状态、完成时间等 /// - completionTime: 完成时间(最后一个审批人通过的时间),待审批的申请该字段为null /// /// 查询参数 /// 分页列表 /// 查询成功 /// 输入参数错误 /// 服务器错误 [HttpGet("Actions/AllPendingApproval")] public async Task GetAllPendingApprovalList([FromQuery] LqReimbursementApplicationListQueryInput input) { // 管理员可以查看所有待审批的申请 var query = _db.Queryable() .Where(x => x.ApprovalStatus == "审批中") .WhereIF(!string.IsNullOrEmpty(input.applicationStoreId), p => p.ApplicationStoreId.Contains(input.applicationStoreId)); // 处理排序 if (string.IsNullOrEmpty(input.sidx)) { query = query.OrderBy(x => x.ApplicationTime, OrderByType.Desc); } else { var sortType = input.sort?.ToLower() == "desc" ? OrderByType.Desc : OrderByType.Asc; switch (input.sidx.ToLower()) { case "id": query = query.OrderBy(x => x.Id, sortType); break; case "applicationtime": query = query.OrderBy(x => x.ApplicationTime, sortType); break; case "amount": query = query.OrderBy(x => x.Amount, sortType); break; default: query = query.OrderBy(x => x.ApplicationTime, OrderByType.Desc); break; } } var total = await query.CountAsync(); var entities = await query.ToPageListAsync(input.currentPage, input.pageSize); // 获取当前审批人信息 var applicationIds = entities.Select(x => x.Id).ToList(); var currentApprovers = new List(); if (applicationIds.Any()) { var approverList = await _db.Queryable() .Where(x => applicationIds.Contains(x.ApplicationId)) .InnerJoin((u, a) => u.ApplicationId == a.Id && u.NodeOrder == a.CurrentNodeOrder) .Select((u, a) => new { applicationId = a.Id, approverName = u.UserName }) .ToListAsync(); currentApprovers = approverList.Cast().ToList(); } var approverDict = currentApprovers .GroupBy(x => (string)x.applicationId) .ToDictionary(g => g.Key, g => string.Join(", ", g.Select(x => (string)x.approverName))); // 获取门店名称 var storeIds = entities.Where(x => !string.IsNullOrEmpty(x.ApplicationStoreId)).Select(x => x.ApplicationStoreId).Distinct().ToList(); var storeDict = new Dictionary(); if (storeIds.Any()) { var stores = await _db.Queryable() .Where(x => storeIds.Contains(x.Id)) .Select(x => new { x.Id, x.Dm }) .ToListAsync(); storeDict = stores.ToDictionary(x => x.Id, x => x.Dm ?? ""); } // 批量解析流程名称(含历史数据快照匹配) var applicationWorkflowNameDict = await BuildApplicationWorkflowNameDictAsync(entities); // 获取完成时间(优先使用实体类中的 CompletionTime,如果没有则查询审批记录) var completionTimeDict = new Dictionary(); if (applicationIds.Any()) { var entitiesWithCompletionTime = entities.Where(x => x.CompletionTime.HasValue).ToList(); foreach (var item in entitiesWithCompletionTime) { completionTimeDict[item.Id] = item.CompletionTime; } var entitiesWithoutCompletionTime = entities.Where(x => !x.CompletionTime.HasValue).Select(x => x.Id).ToList(); if (entitiesWithoutCompletionTime.Any()) { var completionRecords = await _db.Queryable() .Where(x => entitiesWithoutCompletionTime.Contains(x.ApplicationId) && x.ApprovalResult == "通过") .GroupBy(x => x.ApplicationId) .Select(x => new { ApplicationId = x.ApplicationId, MaxApprovalTime = SqlFunc.AggregateMax(x.ApprovalTime) }) .ToListAsync(); foreach (var record in completionRecords) { if (!completionTimeDict.ContainsKey(record.ApplicationId)) { completionTimeDict[record.ApplicationId] = record.MaxApprovalTime; } } } } // 组装返回数据 var result = entities.Select(item => new LqReimbursementApplicationListOutput { id = item.Id, applicationNo = item.ApplicationNo, applicationUserId = item.ApplicationUserId, applicationUserName = item.ApplicationUserName, applicationStoreId = item.ApplicationStoreId, applicationStoreName = !string.IsNullOrEmpty(item.ApplicationStoreId) && storeDict.ContainsKey(item.ApplicationStoreId) ? storeDict[item.ApplicationStoreId] : null, applicationTime = item.ApplicationTime, amount = item.Amount, approveUser = item.ApproveUser, approveStatus = item.ApprovalStatus ?? item.ApproveStatus, approveTime = item.ApproveTime, purchaseRecordsId = item.PurchaseRecordsId, currentApprovers = approverDict.ContainsKey(item.Id) ? approverDict[item.Id] : null, currentNodeOrder = item.CurrentNodeOrder, nodeCount = item.NodeCount, completionTime = completionTimeDict.ContainsKey(item.Id) ? completionTimeDict[item.Id] : (item.CompletionTime ?? null), workflowName = applicationWorkflowNameDict.TryGetValue(item.Id, out var resolvedWorkflowName) ? resolvedWorkflowName : null }).ToList(); return PageResult.SqlSugarPageResult( new SqlSugarPagedList { list = result, pagination = new PagedModel { PageIndex = input.currentPage, PageSize = input.pageSize, Total = total } }); } /// /// 获取待审批列表(当前用户作为审批人的申请) /// /// 查询参数 /// [HttpGet("Actions/PendingApproval")] public async Task GetPendingApprovalList([FromQuery] LqReimbursementApplicationListQueryInput input) { var userInfo = await _userManager.GetUserInfo(); // 查询当前用户作为审批人的节点 var userNodeOrders = await _db.Queryable() .Where(x => x.UserId == userInfo.userId) .Select(x => new { x.ApplicationId, x.NodeOrder }) .ToListAsync(); if (!userNodeOrders.Any()) { return PageResult.SqlSugarPageResult( new SqlSugarPagedList { list = new List(), pagination = new PagedModel { PageIndex = input.currentPage, PageSize = input.pageSize, Total = 0 } }); } // 获取用户有权限的申请ID和节点顺序 var userApplications = userNodeOrders .GroupBy(x => x.ApplicationId) .ToDictionary(g => g.Key, g => g.Select(x => x.NodeOrder).ToList()); var applicationIds = userApplications.Keys.ToList(); // 先查询所有符合条件的申请 var allApplications = await _db.Queryable() .Where(x => applicationIds.Contains(x.Id) && x.ApprovalStatus == "审批中") .WhereIF(!string.IsNullOrEmpty(input.applicationStoreId), p => p.ApplicationStoreId.Contains(input.applicationStoreId)) .ToListAsync(); // 在内存中过滤:当前节点必须是用户有权限的节点 var filteredApplications = allApplications .Where(x => userApplications.ContainsKey(x.Id) && userApplications[x.Id].Contains(x.CurrentNodeOrder ?? 0)) .ToList(); // 获取过滤后的申请ID列表 var filteredApplicationIds = filteredApplications.Select(x => x.Id).ToList(); // 如果没有符合条件的申请,直接返回空列表 if (!filteredApplicationIds.Any()) { return PageResult.SqlSugarPageResult( new SqlSugarPagedList { list = new List(), pagination = new PagedModel { PageIndex = input.currentPage, PageSize = input.pageSize, Total = 0 } }); } // 对过滤后的申请进行排序 var sortType = input.sort?.ToLower() == "desc" ? OrderByType.Desc : OrderByType.Asc; var orderedApplications = string.IsNullOrEmpty(input.sidx) ? filteredApplications.OrderByDescending(x => x.ApplicationTime) : input.sidx.ToLower() switch { "id" => sortType == OrderByType.Desc ? filteredApplications.OrderByDescending(x => x.Id) : filteredApplications.OrderBy(x => x.Id), "applicationtime" => sortType == OrderByType.Desc ? filteredApplications.OrderByDescending(x => x.ApplicationTime) : filteredApplications.OrderBy(x => x.ApplicationTime), "amount" => sortType == OrderByType.Desc ? filteredApplications.OrderByDescending(x => x.Amount) : filteredApplications.OrderBy(x => x.Amount), _ => filteredApplications.OrderByDescending(x => x.ApplicationTime) }; // 手动分页 var total = filteredApplications.Count; var entities = orderedApplications .Skip((input.currentPage - 1) * input.pageSize) .Take(input.pageSize) .ToList(); // 获取当前审批人信息 var resultApplicationIds = entities.Select(x => x.Id).ToList(); var currentApprovers = new List(); if (resultApplicationIds.Any()) { var approverList = await _db.Queryable() .Where(x => resultApplicationIds.Contains(x.ApplicationId)) .InnerJoin((u, a) => u.ApplicationId == a.Id && u.NodeOrder == a.CurrentNodeOrder) .Select((u, a) => new { applicationId = a.Id, approverName = u.UserName }) .ToListAsync(); currentApprovers = approverList.Cast().ToList(); } var approverDict = currentApprovers .GroupBy(x => (string)x.applicationId) .ToDictionary(g => g.Key, g => string.Join(", ", g.Select(x => (string)x.approverName))); // 获取门店名称 var storeIds = entities.Where(x => !string.IsNullOrEmpty(x.ApplicationStoreId)).Select(x => x.ApplicationStoreId).Distinct().ToList(); var storeDict = new Dictionary(); if (storeIds.Any()) { var stores = await _db.Queryable() .Where(x => storeIds.Contains(x.Id)) .Select(x => new { x.Id, x.Dm }) .ToListAsync(); storeDict = stores.ToDictionary(x => x.Id, x => x.Dm ?? ""); } // 批量解析流程名称(含历史数据快照匹配) var applicationWorkflowNameDict = await BuildApplicationWorkflowNameDictAsync(entities); // 获取完成时间(优先使用实体类中的 CompletionTime,如果没有则查询审批记录) var completionTimeDict3 = new Dictionary(); if (resultApplicationIds.Any()) { var entitiesWithCompletionTime3 = entities.Where(x => x.CompletionTime.HasValue).ToList(); foreach (var item in entitiesWithCompletionTime3) { completionTimeDict3[item.Id] = item.CompletionTime; } var entitiesWithoutCompletionTime3 = entities.Where(x => !x.CompletionTime.HasValue).Select(x => x.Id).ToList(); if (entitiesWithoutCompletionTime3.Any()) { var completionRecords3 = await _db.Queryable() .Where(x => entitiesWithoutCompletionTime3.Contains(x.ApplicationId) && x.ApprovalResult == "通过") .GroupBy(x => x.ApplicationId) .Select(x => new { ApplicationId = x.ApplicationId, MaxApprovalTime = SqlFunc.AggregateMax(x.ApprovalTime) }) .ToListAsync(); foreach (var record in completionRecords3) { if (!completionTimeDict3.ContainsKey(record.ApplicationId)) { completionTimeDict3[record.ApplicationId] = record.MaxApprovalTime; } } } } // 组装返回数据 var result = entities.Select(item => new LqReimbursementApplicationListOutput { id = item.Id, applicationNo = item.ApplicationNo, applicationUserId = item.ApplicationUserId, applicationUserName = item.ApplicationUserName, applicationStoreId = item.ApplicationStoreId, applicationStoreName = !string.IsNullOrEmpty(item.ApplicationStoreId) && storeDict.ContainsKey(item.ApplicationStoreId) ? storeDict[item.ApplicationStoreId] : null, applicationTime = item.ApplicationTime, amount = item.Amount, approveUser = item.ApproveUser, approveStatus = item.ApprovalStatus ?? item.ApproveStatus, approveTime = item.ApproveTime, purchaseRecordsId = item.PurchaseRecordsId, currentApprovers = approverDict.ContainsKey(item.Id) ? approverDict[item.Id] : null, currentNodeOrder = item.CurrentNodeOrder, nodeCount = item.NodeCount, completionTime = completionTimeDict3.ContainsKey(item.Id) ? completionTimeDict3[item.Id] : (item.CompletionTime ?? null), workflowName = applicationWorkflowNameDict.TryGetValue(item.Id, out var resolvedWorkflowName) ? resolvedWorkflowName : null }).ToList(); return PageResult.SqlSugarPageResult( new SqlSugarPagedList { list = result, pagination = new PagedModel { PageIndex = input.currentPage, PageSize = input.pageSize, Total = total } }); } /// /// 获取审批历史 /// /// 申请编号 /// [HttpGet("{id}/Actions/ApprovalHistory")] public async Task GetApprovalHistory(string id) { // 先查询审批记录 var approvalRecords = await _db.Queryable() .Where(x => x.ApplicationId == id) .OrderBy(x => x.NodeOrder) .OrderBy(x => x.ApprovalTime) .ToListAsync(); // 获取节点信息 if (approvalRecords.Any()) { var nodeIds = approvalRecords.Select(x => x.NodeId).Distinct().ToList(); var nodes = await _db.Queryable() .Where(x => nodeIds.Contains(x.Id)) .ToListAsync(); var nodeDict = nodes.ToDictionary(x => x.Id, x => x.NodeName); // 组装结果 var records = approvalRecords.Select(r => new { nodeOrder = r.NodeOrder, nodeName = nodeDict.ContainsKey(r.NodeId) ? nodeDict[r.NodeId] : null, approverName = r.ApproverName, approvalResult = r.ApprovalResult, approvalOpinion = r.ApprovalOpinion, approvalTime = r.ApprovalTime }).ToList(); return records; } return new List(); } /// /// 导出报销表明细(按申请日期与审批状态筛选) /// /// /// 按申请日期(ApplicationTime)半开区间 [开始日 00:00, 结束日次日 00:00) 筛选,并按前端传入的审批状态过滤; /// 默认导出「审批中」「已通过」「未通过」,不包含「待审批」「已退回」等状态。用于线下整理后导入店内支出表。 /// /// 示例请求(日期范围 + 审批状态): /// GET /api/Extend/LqReimbursementApplication/Actions/ExportApprovedDetails?startApplicationDate=2026-07-01&endApplicationDate=2026-07-31&approvalStatuses=审批中,已通过 /// /// 示例请求(兼容旧版 year/month): /// GET /api/Extend/LqReimbursementApplication/Actions/ExportApprovedDetails?year=2026&month=07 /// /// 参数说明: /// - startApplicationDate/endApplicationDate: 申请日期范围,格式 yyyy-MM-dd;传入任一则需同时传入,且优先于 year/month /// - approvalStatuses: 逗号分隔审批状态,可选值:审批中、已通过、未通过;为空时默认三种全选 /// - year/month: 未传日期范围时按整月筛选,month 格式 01-12 /// /// 导出列说明(购买记录关联 lq_reimbursement_category): /// - 一级分类编号/名称、二级分类编号/名称、权责收付实现、费用计入信息 /// /// 年份(可选,默认当前年份;未传申请日期范围时生效) /// 月份(可选,默认当前月份,格式:01-12;未传申请日期范围时生效) /// 申请开始日期(可选,yyyy-MM-dd) /// 申请结束日期(可选,yyyy-MM-dd) /// 审批状态,逗号分隔(可选,默认:审批中,已通过,未通过) /// 导出文件信息 /// 导出成功 /// 参数校验失败 /// 服务器错误 [HttpGet("Actions/ExportApprovedDetails")] public async Task ExportApprovedDetails( int? year = null, string month = null, string startApplicationDate = null, string endApplicationDate = null, string approvalStatuses = null) { try { var (startDate, endExclusive, startLabel, endLabel) = ResolveExportApplicationDateRange( year, month, startApplicationDate, endApplicationDate); var exportStatuses = ResolveExportApprovalStatuses(approvalStatuses); // 查询指定申请日期范围、指定审批状态的报销申请 var applications = await _db.Queryable() .Where(x => x.ApplicationTime.HasValue && x.ApplicationTime.Value >= startDate && x.ApplicationTime.Value < endExclusive) .Where(x => exportStatuses.Contains(x.ApprovalStatus ?? x.ApproveStatus)) .ToListAsync(); // 获取所有关联的购买记录 var applicationIds = applications.Select(x => x.Id).ToList(); var purchaseRecords = new List(); if (applicationIds.Any()) { purchaseRecords = await _db.Queryable() .Where(x => applicationIds.Contains(x.ApplicationId)) .OrderBy(x => x.ApplicationId) .OrderBy(x => x.CreateTime) .ToListAsync(); } // 批量解析工作流程名称(WorkflowConfigId 优先,否则按节点快照匹配) var applicationWorkflowNameDict = await BuildApplicationWorkflowNameDictAsync(applications); // 批量获取完成时间 var completionTimeDict = new Dictionary(); foreach (var app in applications.Where(x => x.CompletionTime.HasValue)) { completionTimeDict[app.Id] = app.CompletionTime; } var rejectedWithoutCompletion = applications .Where(x => !x.CompletionTime.HasValue && (x.ApprovalStatus ?? x.ApproveStatus) == "未通过") .Select(x => x.Id) .ToList(); if (rejectedWithoutCompletion.Any()) { var rejectedRecords = await _db.Queryable() .Where(x => rejectedWithoutCompletion.Contains(x.ApplicationId) && x.ApprovalResult == "不通过") .GroupBy(x => x.ApplicationId) .Select(x => new { ApplicationId = x.ApplicationId, MaxApprovalTime = SqlFunc.AggregateMax(x.ApprovalTime) }) .ToListAsync(); foreach (var record in rejectedRecords) { completionTimeDict[record.ApplicationId] = record.MaxApprovalTime; } } var approvedWithoutCompletion = applications .Where(x => !x.CompletionTime.HasValue && (x.ApprovalStatus ?? x.ApproveStatus) == "已通过" && !completionTimeDict.ContainsKey(x.Id)) .Select(x => x.Id) .ToList(); if (approvedWithoutCompletion.Any()) { var approvedRecords = await _db.Queryable() .Where(x => approvedWithoutCompletion.Contains(x.ApplicationId) && x.ApprovalResult == "通过") .GroupBy(x => x.ApplicationId) .Select(x => new { ApplicationId = x.ApplicationId, MaxApprovalTime = SqlFunc.AggregateMax(x.ApprovalTime) }) .ToListAsync(); foreach (var record in approvedRecords) { completionTimeDict[record.ApplicationId] = record.MaxApprovalTime; } } // 获取申请门店信息 var applicationStoreIds = applications.Where(x => !string.IsNullOrEmpty(x.ApplicationStoreId)) .Select(x => x.ApplicationStoreId) .Distinct() .ToList(); var applicationStores = new Dictionary(); if (applicationStoreIds.Any()) { var storeList = await _db.Queryable() .Where(x => applicationStoreIds.Contains(x.Id)) .Select(x => new { x.Id, x.Dm }) .ToListAsync(); applicationStores = storeList.ToDictionary(x => x.Id, x => x.Dm ?? ""); } // 获取购买门店信息(从购买记录的CreateUserStoreId) var purchaseStoreIds = purchaseRecords.Where(x => !string.IsNullOrEmpty(x.CreateUserStoreId)) .Select(x => x.CreateUserStoreId) .Distinct() .ToList(); var purchaseStores = new Dictionary(); if (purchaseStoreIds.Any()) { var purchaseStoreList = await _db.Queryable() .Where(x => purchaseStoreIds.Contains(x.Id)) .Select(x => new { x.Id, x.Dm }) .ToListAsync(); purchaseStores = purchaseStoreList.ToDictionary(x => x.Id, x => x.Dm ?? ""); } // 批量获取支出分类(购买记录 ReimbursementCategoryId 关联 lq_reimbursement_category) var categoryIds = purchaseRecords .Where(x => !string.IsNullOrEmpty(x.ReimbursementCategoryId)) .Select(x => x.ReimbursementCategoryId) .Distinct() .ToList(); var categoryDict = new Dictionary(); if (categoryIds.Any()) { var categoryList = await _db.Queryable() .Where(x => categoryIds.Contains(x.Id)) .ToListAsync(); categoryDict = categoryList.ToDictionary(x => x.Id, x => x); } // 组装导出数据(包含报销申请和购买记录明细) var exportData = new List(); foreach (var app in applications) { var approvalStatus = app.ApprovalStatus ?? app.ApproveStatus; var workflowName = applicationWorkflowNameDict.TryGetValue(app.Id, out var resolvedWorkflowName) ? resolvedWorkflowName : ResolveFallbackWorkflowName(null); var completionTime = approvalStatus == "审批中" ? null : (completionTimeDict.ContainsKey(app.Id) ? completionTimeDict[app.Id] : app.CompletionTime); var appPurchaseRecords = purchaseRecords.Where(x => x.ApplicationId == app.Id).ToList(); if (appPurchaseRecords.Any()) { // 每个购买记录作为一行 foreach (var pr in appPurchaseRecords) { categoryDict.TryGetValue(pr.ReimbursementCategoryId ?? "", out var category); exportData.Add(new ReimbursementDetailExportOutput { applicationId = app.Id, applicationNo = app.ApplicationNo, applicationUserName = app.ApplicationUserName, applicationStoreId = app.ApplicationStoreId, applicationStoreName = !string.IsNullOrEmpty(app.ApplicationStoreId) && applicationStores.ContainsKey(app.ApplicationStoreId) ? applicationStores[app.ApplicationStoreId] : "", purchaseStoreId = pr.CreateUserStoreId, purchaseStoreName = !string.IsNullOrEmpty(pr.CreateUserStoreId) && purchaseStores.ContainsKey(pr.CreateUserStoreId) ? purchaseStores[pr.CreateUserStoreId] : "", applicationTime = app.ApplicationTime, applicationAmount = ParseApplicationAmount(app.Amount), workflowName = workflowName, completionTime = completionTime, approvalStatus = approvalStatus, purchaseRecordId = pr.Id, reimbursementCategoryId = pr.ReimbursementCategoryId, reimbursementCategoryName = pr.ReimbursementCategoryName, level1Code = category?.Level1Code ?? "", level1Name = category?.Level1Name ?? "", level2Code = category?.Level2Code ?? "", level2Name = category?.TypeName ?? "", implement = category?.Implement ?? "", costsRecorded = category?.CostsRecorded ?? "", unitPrice = pr.UnitPrice, quantity = pr.Quantity ?? 0, amount = pr.Amount, payeeName = pr.PayeeName, memo = pr.Memo, purchaseTime = pr.PurchaseTime }); } } else { // 如果没有购买记录,至少导出报销申请基本信息 exportData.Add(new ReimbursementDetailExportOutput { applicationId = app.Id, applicationNo = app.ApplicationNo, applicationUserName = app.ApplicationUserName, applicationStoreId = app.ApplicationStoreId, applicationStoreName = !string.IsNullOrEmpty(app.ApplicationStoreId) && applicationStores.ContainsKey(app.ApplicationStoreId) ? applicationStores[app.ApplicationStoreId] : "", purchaseStoreId = "", purchaseStoreName = "", applicationTime = app.ApplicationTime, applicationAmount = ParseApplicationAmount(app.Amount), workflowName = workflowName, completionTime = completionTime, approvalStatus = approvalStatus, purchaseRecordId = "", reimbursementCategoryId = "", reimbursementCategoryName = "", level1Code = "", level1Name = "", level2Code = "", level2Name = "", implement = "", costsRecorded = "", unitPrice = 0m, quantity = 0, amount = 0m, payeeName = "", memo = "", purchaseTime = null }); } } // 导出Excel List paramList = "[{\"value\":\"报销申请ID\",\"field\":\"applicationId\"},{\"value\":\"编号\",\"field\":\"applicationNo\"},{\"value\":\"申请人姓名\",\"field\":\"applicationUserName\"},{\"value\":\"申请门店ID\",\"field\":\"applicationStoreId\"},{\"value\":\"申请门店\",\"field\":\"applicationStoreName\"},{\"value\":\"购买门店ID\",\"field\":\"purchaseStoreId\"},{\"value\":\"购买门店\",\"field\":\"purchaseStoreName\"},{\"value\":\"申请时间\",\"field\":\"applicationTime\"},{\"value\":\"申请金额\",\"field\":\"applicationAmount\"},{\"value\":\"工作流程名称\",\"field\":\"workflowName\"},{\"value\":\"完成时间\",\"field\":\"completionTime\"},{\"value\":\"审批状态\",\"field\":\"approvalStatus\"},{\"value\":\"购买记录ID\",\"field\":\"purchaseRecordId\"},{\"value\":\"支出分类ID\",\"field\":\"reimbursementCategoryId\"},{\"value\":\"分类名称\",\"field\":\"reimbursementCategoryName\"},{\"value\":\"一级分类编号\",\"field\":\"level1Code\"},{\"value\":\"一级分类名称\",\"field\":\"level1Name\"},{\"value\":\"二级分类编号\",\"field\":\"level2Code\"},{\"value\":\"二级分类名称\",\"field\":\"level2Name\"},{\"value\":\"权责收付实现\",\"field\":\"implement\"},{\"value\":\"费用计入信息\",\"field\":\"costsRecorded\"},{\"value\":\"单价\",\"field\":\"unitPrice\"},{\"value\":\"数量\",\"field\":\"quantity\"},{\"value\":\"金额\",\"field\":\"amount\"},{\"value\":\"收款人\",\"field\":\"payeeName\"},{\"value\":\"备注说明\",\"field\":\"memo\"},{\"value\":\"购买时间\",\"field\":\"purchaseTime\"}]".ToList(); ExcelConfig excelconfig = new ExcelConfig(); excelconfig.FileName = $"报销表明细_{startLabel}至{endLabel}.xls"; excelconfig.HeadFont = "微软雅黑"; excelconfig.HeadPoint = 10; excelconfig.IsAllSizeColumn = true; excelconfig.ColumnModel = new List(); foreach (var param in paramList) { excelconfig.ColumnModel.Add(new ExcelColumnModel() { Column = param.field, ExcelColumn = param.value }); } // 导出Excel文件(保存到项目根目录下的 ExportFiles 文件夹) // 注意:KeyVariable.SystemPath 可能指向 OSS,所以需要直接查找项目根目录 // 从 AppContext.BaseDirectory 向上查找包含 .git 目录的目录作为项目根目录(优先) var baseDir = AppContext.BaseDirectory; var projectRoot = baseDir; var dir = new DirectoryInfo(baseDir); // 优先查找包含 .git 目录的目录(真正的项目根目录) while (dir != null && dir.Parent != null) { try { if (dir.GetDirectories(".git").Any()) { projectRoot = dir.FullName; break; } } catch { // 忽略访问错误,继续向上查找 } dir = dir.Parent; } // 如果没找到 .git 目录,再查找包含 .sln 文件的目录 if (projectRoot == baseDir) { dir = new DirectoryInfo(baseDir); while (dir != null && dir.Parent != null) { try { if (dir.GetFiles("*.sln").Any()) { projectRoot = dir.FullName; break; } } catch { // 忽略访问错误,继续向上查找 } dir = dir.Parent; } } // 在项目根目录下创建 ExportFiles 文件夹 var exportFilesPath = Path.Combine(projectRoot, "ExportFiles"); if (!Directory.Exists(exportFilesPath)) { Directory.CreateDirectory(exportFilesPath); } var addPath = Path.Combine(exportFilesPath, excelconfig.FileName); ExcelExportHelper.Export(exportData, excelconfig, addPath); var statusSummary = string.Join("、", exportStatuses); var detailJson = JsonConvert.SerializeObject(new { start = startLabel, end = endLabel, statuses = exportStatuses, rowCount = exportData.Count, fileName = excelconfig.FileName }); try { await _businessOperationLogService.WriteAsync( "报销申请", "导出报销明细", "lq_reimbursement_application", null, $"导出报销明细 {startLabel} 至 {endLabel}({statusSummary}),共 {exportData.Count} 条", detailJson); } catch { // 写日志失败不影响导出结果 } var fileName = _userManager.UserId + "|" + addPath + "|xls"; var output = new { name = excelconfig.FileName, url = "/api/File/Download?encryption=" + DESCEncryption.Encrypt(fileName, "NCC") }; return output; } catch (Exception ex) { throw NCCException.Oh($"导出失败:{ex.Message}"); } } private static readonly string[] ExportApprovalStatusWhitelist = { "审批中", "已通过", "未通过" }; /// /// 解析导出申请日期范围:优先使用 start/end,否则回退 year/month 整月 /// private static (DateTime startInclusive, DateTime endExclusive, string startLabel, string endLabel) ResolveExportApplicationDateRange( int? year, string month, string startApplicationDate, string endApplicationDate) { var hasStart = !string.IsNullOrWhiteSpace(startApplicationDate); var hasEnd = !string.IsNullOrWhiteSpace(endApplicationDate); if (hasStart || hasEnd) { if (!hasStart || !hasEnd) { throw NCCException.Oh("申请日期范围需同时传入开始日期和结束日期"); } if (!DateTime.TryParseExact(startApplicationDate.Trim(), "yyyy-MM-dd", CultureInfo.InvariantCulture, DateTimeStyles.None, out var parsedStart)) { throw NCCException.Oh("开始日期格式不正确,请使用 yyyy-MM-dd"); } if (!DateTime.TryParseExact(endApplicationDate.Trim(), "yyyy-MM-dd", CultureInfo.InvariantCulture, DateTimeStyles.None, out var parsedEnd)) { throw NCCException.Oh("结束日期格式不正确,请使用 yyyy-MM-dd"); } parsedStart = parsedStart.Date; parsedEnd = parsedEnd.Date; if (parsedStart > parsedEnd) { throw NCCException.Oh("开始日期不能晚于结束日期"); } return (parsedStart, parsedEnd.AddDays(1), parsedStart.ToString("yyyy-MM-dd"), parsedEnd.ToString("yyyy-MM-dd")); } var now = DateTime.Now; var queryYear = year ?? now.Year; var queryMonth = !string.IsNullOrEmpty(month) ? month : now.ToString("MM"); if (!int.TryParse(queryMonth, out var monthNumber) || monthNumber < 1 || monthNumber > 12) { throw NCCException.Oh("月份格式不正确,请使用 01-12"); } var monthStart = new DateTime(queryYear, monthNumber, 1); var monthEnd = monthStart.AddMonths(1).AddDays(-1); return (monthStart, monthStart.AddMonths(1), monthStart.ToString("yyyy-MM-dd"), monthEnd.ToString("yyyy-MM-dd")); } /// /// 解析导出审批状态列表,默认三种全选 /// private static List ResolveExportApprovalStatuses(string approvalStatuses) { if (string.IsNullOrWhiteSpace(approvalStatuses)) { return ExportApprovalStatusWhitelist.ToList(); } var statuses = approvalStatuses .Split(new[] { ',', ',' }, StringSplitOptions.RemoveEmptyEntries) .Select(s => s.Trim()) .Where(s => !string.IsNullOrEmpty(s)) .Distinct() .ToList(); if (!statuses.Any()) { throw NCCException.Oh("请至少选择一种审批状态"); } var invalidStatuses = statuses.Where(s => !ExportApprovalStatusWhitelist.Contains(s)).ToList(); if (invalidStatuses.Any()) { throw NCCException.Oh($"审批状态无效:{string.Join("、", invalidStatuses)},仅支持:审批中、已通过、未通过"); } return statuses; } private sealed class WorkflowNodeSignature { public int NodeOrder { get; set; } public string NodeName { get; set; } public HashSet UserIds { get; set; } = new HashSet(StringComparer.OrdinalIgnoreCase); } private sealed class WorkflowConfigSignature { public string ConfigId { get; set; } public string WorkflowName { get; set; } public List Nodes { get; set; } = new List(); } /// /// 详情页解析单条报销申请流程名称:优先 WorkflowConfigId,否则复用已加载节点快照匹配。 /// private async Task ResolveApplicationWorkflowNameForDetailAsync( LqReimbursementApplicationEntity entity, List nodes, List nodeUsers) { if (entity == null) { return ResolveFallbackWorkflowName(null); } if (!string.IsNullOrEmpty(entity.WorkflowConfigId)) { var workflowConfigName = await _db.Queryable() .Where(x => x.Id == entity.WorkflowConfigId) .Select(x => x.WorkflowName) .FirstAsync(); if (!string.IsNullOrWhiteSpace(workflowConfigName)) { return workflowConfigName; } } var appSignature = BuildApplicationNodeSignatures(nodes, nodeUsers); var amount = ParseApplicationAmount(entity.Amount); var configSignatures = await LoadWorkflowConfigSignaturesAsync(); return ResolveWorkflowNameFromSnapshot(appSignature, amount, configSignatures); } /// /// 批量加载全部流程配置及其节点、审批人签名(配置量小,避免 N+1)。 /// private async Task> LoadWorkflowConfigSignaturesAsync() { var allConfigs = await _db.Queryable() .ToListAsync(); var allConfigIds = allConfigs.Select(x => x.Id).ToList(); var workflowNodes = allConfigIds.Any() ? await _db.Queryable() .Where(x => allConfigIds.Contains(x.WorkflowConfigId)) .OrderBy(x => x.WorkflowConfigId) .OrderBy(x => x.NodeOrder) .ToListAsync() : new List(); var workflowNodeUsers = allConfigIds.Any() ? await _db.Queryable() .Where(x => allConfigIds.Contains(x.WorkflowConfigId)) .ToListAsync() : new List(); return BuildWorkflowConfigSignatures(allConfigs, workflowNodes, workflowNodeUsers); } /// /// 批量解析报销申请的工作流程名称:优先 WorkflowConfigId,否则按节点+审批人快照匹配配置。 /// private async Task> BuildApplicationWorkflowNameDictAsync( List applications) { var result = new Dictionary(); if (applications == null || !applications.Any()) { return result; } var configIdToName = new Dictionary(); var workflowConfigIds = applications .Where(x => !string.IsNullOrEmpty(x.WorkflowConfigId)) .Select(x => x.WorkflowConfigId) .Distinct() .ToList(); if (workflowConfigIds.Any()) { var configs = await _db.Queryable() .Where(x => workflowConfigIds.Contains(x.Id)) .Select(x => new { x.Id, x.WorkflowName }) .ToListAsync(); configIdToName = configs.ToDictionary(x => x.Id, x => x.WorkflowName ?? ""); } var needSnapshotMatchIds = new List(); foreach (var app in applications) { if (!string.IsNullOrEmpty(app.WorkflowConfigId) && configIdToName.TryGetValue(app.WorkflowConfigId, out var directName) && !string.IsNullOrWhiteSpace(directName)) { result[app.Id] = directName; } else { needSnapshotMatchIds.Add(app.Id); } } if (!needSnapshotMatchIds.Any()) { return result; } var appNodes = await _db.Queryable() .Where(x => needSnapshotMatchIds.Contains(x.ApplicationId)) .OrderBy(x => x.ApplicationId) .OrderBy(x => x.NodeOrder) .ToListAsync(); var appNodeUsers = await _db.Queryable() .Where(x => needSnapshotMatchIds.Contains(x.ApplicationId)) .ToListAsync(); var configSignatures = await LoadWorkflowConfigSignaturesAsync(); var appNodeGroups = appNodes.GroupBy(x => x.ApplicationId) .ToDictionary(g => g.Key, g => g.ToList()); var appUserGroups = appNodeUsers.GroupBy(x => x.ApplicationId) .ToDictionary(g => g.Key, g => g.ToList()); var appDict = applications .Where(x => needSnapshotMatchIds.Contains(x.Id)) .ToDictionary(x => x.Id); foreach (var appId in needSnapshotMatchIds) { appDict.TryGetValue(appId, out var app); appNodeGroups.TryGetValue(appId, out var nodes); appUserGroups.TryGetValue(appId, out var users); var appSignature = BuildApplicationNodeSignatures(nodes, users); var amount = ParseApplicationAmount(app?.Amount); result[appId] = ResolveWorkflowNameFromSnapshot(appSignature, amount, configSignatures); } return result; } private static List BuildWorkflowConfigSignatures( List allConfigs, List workflowNodes, List workflowNodeUsers) { var usersByNodeId = workflowNodeUsers .GroupBy(x => x.NodeId) .ToDictionary( g => g.Key, g => g.Select(u => NormalizeWorkflowUserId(u.UserId)) .Where(id => !string.IsNullOrEmpty(id)) .ToHashSet(StringComparer.OrdinalIgnoreCase)); var nodesByConfigId = workflowNodes .GroupBy(x => x.WorkflowConfigId) .ToDictionary(g => g.Key, g => g.OrderBy(n => n.NodeOrder).ToList()); var signatures = new List(); foreach (var config in allConfigs) { var signature = new WorkflowConfigSignature { ConfigId = config.Id, WorkflowName = config.WorkflowName?.Trim() ?? "" }; if (nodesByConfigId.TryGetValue(config.Id, out var nodes)) { signature.Nodes = nodes.Select(node => new WorkflowNodeSignature { NodeOrder = node.NodeOrder, NodeName = node.NodeName?.Trim() ?? "", UserIds = usersByNodeId.TryGetValue(node.Id, out var userIds) ? userIds : new HashSet(StringComparer.OrdinalIgnoreCase) }).ToList(); } signatures.Add(signature); } return signatures; } private static List BuildApplicationNodeSignatures( List nodes, List users) { if (nodes == null || !nodes.Any()) { return new List(); } var usersByNodeId = (users ?? new List()) .GroupBy(u => u.NodeId) .ToDictionary( g => g.Key, g => g.Select(u => NormalizeWorkflowUserId(u.UserId)) .Where(id => !string.IsNullOrEmpty(id)) .ToHashSet(StringComparer.OrdinalIgnoreCase)); return nodes .OrderBy(n => n.NodeOrder) .Select(node => new WorkflowNodeSignature { NodeOrder = node.NodeOrder, NodeName = node.NodeName?.Trim() ?? "", UserIds = usersByNodeId.TryGetValue(node.Id, out var userIds) ? userIds : new HashSet(StringComparer.OrdinalIgnoreCase) }) .ToList(); } private static string ResolveWorkflowNameFromSnapshot( List appNodes, decimal amount, List configSignatures) { if (appNodes == null || !appNodes.Any()) { return ResolveFallbackWorkflowName(appNodes); } var structuralMatches = configSignatures .Where(config => MatchesWorkflowNodeStructure(appNodes, config.Nodes)) .Where(config => MatchesWorkflowBusinessTypeKeywords(appNodes, config.WorkflowName)) .ToList(); if (structuralMatches.Count == 1) { return structuralMatches[0].WorkflowName; } if (structuralMatches.Count > 1) { var amountFiltered = FilterWorkflowCandidatesByAmount(structuralMatches, amount); var distinctNames = amountFiltered .Select(x => x.WorkflowName) .Where(x => !string.IsNullOrWhiteSpace(x)) .Distinct(StringComparer.Ordinal) .ToList(); if (distinctNames.Count == 1) { return distinctNames[0]; } if (amountFiltered.Count == 1) { return amountFiltered[0].WorkflowName; } } return ResolveFallbackWorkflowName(appNodes); } private static bool MatchesWorkflowNodeStructure( List appNodes, List configNodes) { if (appNodes == null || configNodes == null || appNodes.Count != configNodes.Count) { return false; } for (var i = 0; i < appNodes.Count; i++) { if (appNodes[i].NodeOrder != configNodes[i].NodeOrder) { return false; } if (!appNodes[i].UserIds.SetEquals(configNodes[i].UserIds)) { return false; } } return true; } private static bool MatchesWorkflowBusinessTypeKeywords( List appNodes, string workflowName) { if (string.IsNullOrWhiteSpace(workflowName)) { return false; } var nodeNames = appNodes .Select(x => x.NodeName?.Trim() ?? "") .Where(x => !string.IsNullOrEmpty(x)) .ToList(); if (!nodeNames.Any()) { return true; } if (nodeNames.Any(x => x.Contains("门店支出"))) { return workflowName.Contains("门店支出"); } if (nodeNames.Any(x => x.Contains("退款"))) { return workflowName.Contains("退款"); } if (nodeNames.Any(x => x.Contains("总部报销") || x == "报销")) { return workflowName.Contains("总部报销"); } return nodeNames.Any(nodeName => workflowName.Contains(nodeName, StringComparison.Ordinal) || nodeName.Contains(workflowName, StringComparison.Ordinal)); } private static List FilterWorkflowCandidatesByAmount( List candidates, decimal amount) { if (candidates == null || candidates.Count <= 1) { return candidates ?? new List(); } var isAboveThreshold = amount >= 1000m; var aboveKeywords = new[] { "1000以上" }; var belowKeywords = new[] { "1000以下" }; var hasAmountKeyword = candidates.Any(candidate => aboveKeywords.Any(keyword => candidate.WorkflowName.Contains(keyword)) || belowKeywords.Any(keyword => candidate.WorkflowName.Contains(keyword))); if (!hasAmountKeyword) { return candidates; } var filtered = candidates.Where(candidate => { var name = candidate.WorkflowName ?? ""; var isAboveName = aboveKeywords.Any(keyword => name.Contains(keyword)); var isBelowName = belowKeywords.Any(keyword => name.Contains(keyword)); if (isAboveName && !isBelowName) { return isAboveThreshold; } if (isBelowName && !isAboveName) { return !isAboveThreshold; } return true; }).ToList(); return filtered.Any() ? filtered : candidates; } private static string ResolveFallbackWorkflowName(List appNodes) { if (appNodes != null && appNodes.Any()) { var firstNodeName = appNodes.OrderBy(x => x.NodeOrder).First().NodeName; if (!string.IsNullOrWhiteSpace(firstNodeName)) { return $"历史流程({firstNodeName})"; } } return "历史流程(未知)"; } private static string NormalizeWorkflowUserId(string userId) { return string.IsNullOrWhiteSpace(userId) ? "" : userId.Trim(); } /// /// 规范化申请时间:未传则用当前时间;若仅有日期(时分秒为 00:00:00)则补上当前时分秒。 /// 避免前端 date/datetime 选择器把申请时间落成当天零点。 /// private static DateTime NormalizeApplicationTime(DateTime? input, DateTime now) { if (!input.HasValue) { return now; } var value = input.Value; if (value.TimeOfDay == TimeSpan.Zero) { return new DateTime( value.Year, value.Month, value.Day, now.Hour, now.Minute, now.Second, now.Millisecond); } return value; } /// /// 解析列表查询中的日期时间参数,支持 yyyy-MM-dd HH:mm:ss、yyyy-MM-dd 及毫秒时间戳 /// private static DateTime? ParseQueryDateTime(string value) { if (string.IsNullOrWhiteSpace(value)) { return null; } var trimmed = value.Trim(); if (DateTime.TryParseExact(trimmed, "yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture, DateTimeStyles.None, out var dateTime)) { return dateTime; } if (DateTime.TryParseExact(trimmed, "yyyy-MM-dd", CultureInfo.InvariantCulture, DateTimeStyles.None, out var dateOnly)) { return dateOnly; } try { return Ext.GetDateTime(trimmed); } catch { return null; } } /// /// 安全解析申请金额,避免历史脏数据导致导出失败 /// private static decimal ParseApplicationAmount(string amount) { if (string.IsNullOrWhiteSpace(amount)) { return 0m; } return decimal.TryParse(amount, out var parsedAmount) ? parsedAmount : 0m; } /// /// 在事务内原子获取当月报销申请序号(MySQL 行锁串行,并发不重复) /// private async Task GetNextReimbursementApplicationSequenceAsync(DateTime now) { var period = $"{now.Year}-{now.Month}"; const string upsertSql = @" INSERT INTO lq_reimbursement_application_sequence (F_Period, F_CurrentValue, F_UpdateTime) VALUES (@period, LAST_INSERT_ID(1), @now) ON DUPLICATE KEY UPDATE F_CurrentValue = LAST_INSERT_ID(F_CurrentValue + 1), F_UpdateTime = @now"; var parameters = new[] { new SugarParameter("@period", period), new SugarParameter("@now", now) }; await _db.Ado.ExecuteCommandAsync(upsertSql, parameters); return await _db.Ado.GetIntAsync("SELECT LAST_INSERT_ID()"); } /// /// 组装报销申请业务编号 /// private static string BuildReimbursementApplicationNo(DateTime now, int sequence) { return $"ZC-{now.Year}-{now.Month}-{sequence:D3}"; } /// /// 创建报销申请时的数据库结构/唯一约束异常友好化 /// private static Exception WrapReimbursementApplicationCreateException(Exception ex) { var msg = GetFullExceptionMessage(ex); if (IsMissingReimbursementApplicationNoStructureException(msg)) { return new Exception( "报销申请业务编号所需的数据库结构尚未部署,请先执行序列表 lq_reimbursement_application_sequence 及主表 F_ApplicationNo 唯一索引相关 SQL。", ex); } if (IsReimbursementApplicationNoDuplicateException(msg)) { return new Exception( "报销申请业务编号发生冲突,请检查 F_ApplicationNo 唯一索引及序列表 lq_reimbursement_application_sequence 是否已正确部署。", ex); } return ex; } private static string GetFullExceptionMessage(Exception ex) { var messages = new List(); for (var current = ex; current != null; current = current.InnerException) { if (!string.IsNullOrWhiteSpace(current.Message)) { messages.Add(current.Message); } } return string.Join(" ", messages); } private static bool IsMissingReimbursementApplicationNoStructureException(string msg) { if (string.IsNullOrEmpty(msg)) { return false; } return msg.Contains("lq_reimbursement_application_sequence", StringComparison.OrdinalIgnoreCase) || msg.Contains("F_ApplicationNo", StringComparison.OrdinalIgnoreCase) || msg.Contains("1146") || msg.Contains("1054") || (msg.Contains("doesn't exist", StringComparison.OrdinalIgnoreCase) && (msg.Contains("sequence", StringComparison.OrdinalIgnoreCase) || msg.Contains("ApplicationNo", StringComparison.OrdinalIgnoreCase))); } private static bool IsReimbursementApplicationNoDuplicateException(string msg) { if (string.IsNullOrEmpty(msg)) { return false; } if (!msg.Contains("Duplicate", StringComparison.OrdinalIgnoreCase) && !msg.Contains("1062")) { return false; } return msg.Contains("F_ApplicationNo", StringComparison.OrdinalIgnoreCase) || msg.Contains("ZC-", StringComparison.OrdinalIgnoreCase) || msg.Contains("application_no", StringComparison.OrdinalIgnoreCase); } private async Task TryWriteBusinessLogAsync(string moduleCode, string actionCode, string bizType, string bizId, string summary, string detailJson = null) { try { await _businessOperationLogService.WriteAsync(moduleCode, actionCode, bizType, bizId, summary, detailJson); } catch (Exception) { // 写日志失败不拖垮主业务 } } } /// /// 报销表明细导出输出 /// public class ReimbursementDetailExportOutput { /// /// 报销申请ID /// public string applicationId { get; set; } /// /// 业务编号(如 ZC-2026-7-093) /// public string applicationNo { get; set; } /// /// 申请人姓名 /// public string applicationUserName { get; set; } /// /// 门店ID /// public string applicationStoreId { get; set; } /// /// 申请门店名称 /// public string applicationStoreName { get; set; } /// /// 购买门店ID /// public string purchaseStoreId { get; set; } /// /// 购买门店名称 /// public string purchaseStoreName { get; set; } /// /// 申请时间 /// public DateTime? applicationTime { get; set; } /// /// 申请金额 /// public decimal applicationAmount { get; set; } /// /// 工作流程名称 /// public string workflowName { get; set; } /// /// 完成时间 /// public DateTime? completionTime { get; set; } /// /// 审批状态 /// public string approvalStatus { get; set; } /// /// 购买记录ID /// public string purchaseRecordId { get; set; } /// /// 支出分类ID /// public string reimbursementCategoryId { get; set; } /// /// 支出分类名称 /// public string reimbursementCategoryName { get; set; } /// /// 一级分类编号 /// public string level1Code { get; set; } /// /// 一级分类名称 /// public string level1Name { get; set; } /// /// 二级分类编号 /// public string level2Code { get; set; } /// /// 二级分类名称 /// public string level2Name { get; set; } /// /// 权责收付实现 /// public string implement { get; set; } /// /// 费用计入信息 /// public string costsRecorded { get; set; } /// /// 单价 /// public decimal unitPrice { get; set; } /// /// 数量 /// public int quantity { get; set; } /// /// 金额 /// public decimal amount { get; set; } /// /// 收款人 /// public string payeeName { get; set; } /// /// 备注说明 /// public string memo { get; set; } /// /// 购买时间 /// public DateTime? purchaseTime { get; set; } } }