using System; using System.Collections.Generic; using System.Linq; using System.Threading.Tasks; using Microsoft.AspNetCore.Http; using Microsoft.AspNetCore.Mvc; using NCC.ClayObject; using NCC.Code; using NCC.Common.Configuration; using NCC.Common.Core.Manager; using NCC.Common.Enum; using NCC.Common.Extension; using NCC.Common.Filter; using NCC.Common.Helper; using NCC.Common.Model.NPOI; using NCC.Common.Util; using NCC.DataEncryption; using NCC.JsonSerialization; using NCC.Dependency; using NCC.DynamicApiController; using NCC.Extend.Entitys.Dto.LqMemberArrival; using NCC.Extend.Entitys.Enum; using NCC.Extend.Entitys.lq_khxx; using NCC.Extend.Entitys.lq_mdxx; using NCC.Extend.Entitys.lq_member_arrival_record; using NCC.Extend.Interfaces.BusinessOperationLog; using NCC.Extend.Interfaces.LqMemberArrival; using NCC.FriendlyException; using NCC.System.Entitys.Model.Permission.User; using NCC.System.Entitys.Permission; using Newtonsoft.Json; using SqlSugar; using Yitter.IdGenerator; namespace NCC.Extend { /// /// 员工到院转化(独立模块,只读会员/组织/门店) /// [ApiDescriptionSettings(Tag = "员工到院转化", Name = "LqMemberArrival", Order = 213)] [Route("api/Extend/LqMemberArrival")] public class LqMemberArrivalService : ILqMemberArrivalService, IDynamicApiController, ITransient { private const string BizLogModule = "员工到院信息"; private const string BizType = "lq_member_arrival_record"; private const int EffectiveYes = 1; private const int EffectiveNo = 0; private readonly ISqlSugarClient _db; private readonly IUserManager _userManager; private readonly IBusinessOperationLogService _businessOperationLogService; /// /// 初始化员工到院转化服务 /// public LqMemberArrivalService( ISqlSugarClient db, IUserManager userManager, IBusinessOperationLogService businessOperationLogService) { _db = db; _userManager = userManager; _businessOperationLogService = businessOperationLogService; } /// /// 当前登录员工门店内会员分页搜索 /// /// /// 手机端登记页搜索会员。服务端从当前登录用户取门店ID,不信任前端传参。 /// 支持姓名/手机/档案号模糊匹配;仅返回当前门店有效会员。 /// /// 示例请求: /// ```json /// { /// "keyword": "138", /// "currentPage": 1, /// "pageSize": 20 /// } /// ``` /// /// 参数说明: /// - keyword: 姓名/手机/档案号,可选 /// - currentPage/pageSize: 分页参数 /// /// 搜索条件 /// 会员分页列表(memberId/memberName/mobile/archiveNo) /// 已登录时返回分页结果;未登录或登录过期时 HTTP 仍为 200,统一响应体 code=600 /// 当前用户未绑定门店等业务校验失败 /// 服务器错误 [HttpGet("SearchMembers")] public async Task SearchMembersAsync([FromQuery] LqMemberArrivalSearchMembersQueryInput input) { input ??= new LqMemberArrivalSearchMembersQueryInput(); var recorder = await GetRecorderSnapshotAsync(); if (string.IsNullOrWhiteSpace(recorder.sourceMdid)) { throw NCCException.Bah("当前用户未绑定门店,无法搜索会员"); } var kw = string.IsNullOrWhiteSpace(input.keyword) ? null : input.keyword.Trim(); var data = await _db.Queryable() .Where(x => x.Gsmd == recorder.sourceMdid) .Where(x => x.IsEffective == (int)StatusEnum.有效) .WhereIF(kw != null, x => x.Khmc.Contains(kw) || x.Sjh.Contains(kw) || x.Dah.Contains(kw)) .OrderBy(x => x.Khmc) .Select(x => new LqMemberArrivalSearchMemberItemOutput { memberId = x.Id, memberName = x.Khmc, mobile = x.Sjh, archiveNo = x.Dah }) .ToPagedListAsync(input.currentPage, input.pageSize); return PageResult.SqlSugarPageResult(data); } /// /// 提交到院登记 /// /// /// 登记人、来源组织/门店由服务端从当前登录用户快照写入;会员须属于当前门店。 /// 同一门店+会员+自然日仅允许一条有效记录(F_RecordKey 唯一)。 /// 成交=是时见诊必须=是;见诊=否时成交规范化为待确认。 /// 不更新会员主档、FirstVisitTime、预约、沟通、开单、耗卡、工资及人头自动统计表。 /// /// 示例请求: /// ```json /// { /// "memberId": "会员ID", /// "arrivalType": 1, /// "arrivalTime": "2026-07-20T14:30:00", /// "consultationStatus": 0, /// "dealStatus": 0, /// "remark": "自然到院" /// } /// ``` /// /// 参数说明: /// - memberId: 会员ID /// - arrivalType: 1售前 2售后 /// - arrivalTime: 到院时间 /// - consultationStatus/dealStatus: 0待确认 1是 2否 /// - remark: 备注,可选 /// /// 登记内容 /// 主键、编号、版本号 /// 提交成功 /// 参数或重复登记校验失败 /// 服务器错误 [HttpPost("SubmitArrival")] public async Task SubmitArrivalAsync([FromBody] LqMemberArrivalSubmitInput input) { if (input == null) { throw NCCException.Bah("请求体不能为空"); } if (string.IsNullOrWhiteSpace(input.memberId)) { throw NCCException.Bah("memberId 不能为空"); } ValidateArrivalType(input.arrivalType); ValidateOutcomeStatus(input.consultationStatus, "consultationStatus"); ValidateOutcomeStatus(input.dealStatus, "dealStatus"); var recorder = await GetRecorderSnapshotAsync(); if (string.IsNullOrWhiteSpace(recorder.sourceMdid)) { throw NCCException.Bah("当前用户未绑定门店,无法提交到院登记"); } var member = await ValidateMemberInStoreAsync(input.memberId.Trim(), recorder.sourceMdid); var arrivalTime = input.arrivalTime; if (arrivalTime == default) { throw NCCException.Bah("arrivalTime 不能为空"); } var consultationStatus = input.consultationStatus; var dealStatus = input.dealStatus; NormalizeOutcomeStatuses(ref consultationStatus, ref dealStatus); var recordKey = BuildRecordKey(recorder.sourceMdid, member.Id, arrivalTime); var exists = await _db.Queryable() .Where(x => x.RecordKey == recordKey) .AnyAsync(); if (exists) { throw NCCException.Bah("该会员今日在本门店已有有效到院登记,请勿重复提交"); } var now = DateTime.Now; var entity = new LqMemberArrivalRecordEntity { Id = YitIdHelper.NextId().ToString(), RecordNo = GenerateRecordNo(), RecordKey = recordKey, MemberId = member.Id, MemberName = member.Khmc, MemberMobile = member.Sjh, SourceOrganizeId = recorder.sourceOrganizeId, SourceOrganizeName = recorder.sourceOrganizeName, SourceMdid = recorder.sourceMdid, SourceMdName = recorder.sourceMdName, ArrivalType = input.arrivalType, ArrivalTime = arrivalTime, ConsultationStatus = consultationStatus, ConsultationTime = ResolveOutcomeTime(consultationStatus, now), DealStatus = dealStatus, DealTime = ResolveOutcomeTime(dealStatus, now), RecorderUserId = recorder.recorderUserId, RecorderUserName = recorder.recorderUserName, LastModifyUserId = recorder.recorderUserId, LastModifyUserName = recorder.recorderUserName, Remark = string.IsNullOrWhiteSpace(input.remark) ? null : input.remark.Trim(), IsEffective = EffectiveYes, Version = 1, CreateTime = now, UpdateTime = now }; try { await _db.Insertable(entity).ExecuteCommandAsync(); } catch (Exception ex) when (IsDuplicateKeyException(ex)) { throw NCCException.Bah("该会员今日在本门店已有有效到院登记,请勿重复提交"); } var detailJson = JsonConvert.SerializeObject(new { recordNo = entity.RecordNo, memberId = entity.MemberId, memberName = entity.MemberName, sourceMdid = entity.SourceMdid, arrivalType = entity.ArrivalType, arrivalTime = entity.ArrivalTime, consultationStatus = entity.ConsultationStatus, dealStatus = entity.DealStatus, remark = entity.Remark }); await _businessOperationLogService.WriteAsync( BizLogModule, "提交到院登记", BizType, entity.Id, $"提交到院登记 {entity.RecordNo},会员:{entity.MemberName},类型:{EnumHelper.GetEnumDesc(entity.ArrivalType)}", detailJson); return new LqMemberArrivalSubmitOutput { id = entity.Id, recordNo = entity.RecordNo, version = entity.Version }; } /// /// 手机端本人登记分页列表 /// /// /// 仅返回当前登录人登记的记录,可按到院日期、类型、见诊/成交状态筛选。 /// /// 示例请求: /// ```json /// { /// "arrivalDateStart": "2026-07-01", /// "arrivalDateEnd": "2026-07-31", /// "arrivalType": 1, /// "consultationStatus": 1, /// "currentPage": 1, /// "pageSize": 20 /// } /// ``` /// /// 查询条件 /// 分页列表 /// 返回分页结果 /// 服务器错误 [HttpGet("MyList")] public async Task MyListAsync([FromQuery] LqMemberArrivalMyListQueryInput input) { input ??= new LqMemberArrivalMyListQueryInput(); var userId = _userManager.UserId; if (string.IsNullOrWhiteSpace(userId)) { throw NCCException.Oh("未登录或登录已失效"); } var endExclusive = input.arrivalDateEnd?.Date.AddDays(1); var data = await BuildListQuery(null) .Where(x => x.RecorderUserId == userId) .WhereIF(input.arrivalDateStart.HasValue, x => x.ArrivalTime >= input.arrivalDateStart.Value) .WhereIF(endExclusive.HasValue, x => x.ArrivalTime < endExclusive.Value) .WhereIF(input.arrivalType.HasValue, x => x.ArrivalType == input.arrivalType.Value) .WhereIF(input.consultationStatus.HasValue, x => x.ConsultationStatus == input.consultationStatus.Value) .WhereIF(input.dealStatus.HasValue, x => x.DealStatus == input.dealStatus.Value) .OrderBy(x => x.ArrivalTime, OrderByType.Desc) .Select(x => new LqMemberArrivalListOutput { id = x.Id, recordNo = x.RecordNo, memberId = x.MemberId, memberName = x.MemberName, memberMobile = x.MemberMobile, sourceOrganizeId = x.SourceOrganizeId, sourceOrganizeName = x.SourceOrganizeName, sourceMdid = x.SourceMdid, sourceMdName = x.SourceMdName, arrivalType = x.ArrivalType, arrivalTime = x.ArrivalTime, consultationStatus = x.ConsultationStatus, consultationTime = x.ConsultationTime, dealStatus = x.DealStatus, dealTime = x.DealTime, recorderUserId = x.RecorderUserId, recorderUserName = x.RecorderUserName, lastModifyUserId = x.LastModifyUserId, lastModifyUserName = x.LastModifyUserName, remark = x.Remark, isEffective = x.IsEffective, voidReason = x.VoidReason, voidUserId = x.VoidUserId, voidUserName = x.VoidUserName, voidTime = x.VoidTime, version = x.Version, createTime = x.CreateTime, updateTime = x.UpdateTime }) .ToPagedListAsync(input.currentPage, input.pageSize); FillListEnumNames(data.list); return PageResult.SqlSugarPageResult(data); } /// /// 获取到院登记详情 /// /// /// 本人、具备来源组织查看权限或管理员可查看。mobile 返回完整手机号。 /// /// 示例请求: /// ```json /// { "id": "登记主键ID" } /// ``` /// /// 登记主键 /// 详情 /// 返回详情 /// 记录不存在 /// 无数据权限 /// 服务器错误 [HttpGet("GetInfo")] public async Task GetInfoAsync([FromQuery] string id) { var entity = await GetRecordOrThrowAsync(id); await EnsureCanViewRecordAsync(entity); return MapInfoOutput(entity); } /// /// 更新见诊/成交状态 /// /// /// 乐观锁更新。允许登记本人或对来源组织具备 Edit 权限者操作。 /// 成交=是时见诊必须=是;见诊改否时成交规范化为待确认;状态时间按变更设置/清空。 /// /// 示例请求: /// ```json /// { /// "id": "登记主键ID", /// "consultationStatus": 1, /// "dealStatus": 0, /// "remark": "已见诊", /// "version": 1 /// } /// ``` /// /// 更新参数 /// 新版本号 /// 更新成功 /// 参数或版本冲突 /// 无编辑权限 /// 服务器错误 [HttpPost("UpdateOutcome")] public async Task UpdateOutcomeAsync([FromBody] LqMemberArrivalUpdateOutcomeInput input) { if (input == null || string.IsNullOrWhiteSpace(input.id)) { throw NCCException.Oh("id 不能为空"); } ValidateOutcomeStatus(input.consultationStatus, "consultationStatus"); ValidateOutcomeStatus(input.dealStatus, "dealStatus"); var entity = await GetRecordOrThrowAsync(input.id); if (entity.IsEffective != EffectiveYes) { throw NCCException.Bah("该登记已作废,无法修改"); } await EnsureCanUpdateRecordAsync(entity); var consultationStatus = input.consultationStatus; var dealStatus = input.dealStatus; NormalizeOutcomeStatuses(ref consultationStatus, ref dealStatus); var before = new { entity.ConsultationStatus, entity.ConsultationTime, entity.DealStatus, entity.DealTime, entity.Remark, entity.Version }; var now = DateTime.Now; ApplyOutcomeChange(entity, consultationStatus, dealStatus, now); if (input.remark != null) { entity.Remark = string.IsNullOrWhiteSpace(input.remark) ? null : input.remark.Trim(); } entity.LastModifyUserId = _userManager.UserId; entity.LastModifyUserName = _userManager.RealName ?? _userManager.Account; entity.UpdateTime = now; var newVersion = entity.Version + 1; entity.Version = newVersion; var rows = await _db.Updateable(entity) .UpdateColumns(x => new { x.ConsultationStatus, x.ConsultationTime, x.DealStatus, x.DealTime, x.Remark, x.LastModifyUserId, x.LastModifyUserName, x.UpdateTime, x.Version }) .Where(x => x.Id == entity.Id && x.Version == input.version) .ExecuteCommandAsync(); if (rows <= 0) { throw NCCException.Bah("数据已被他人修改,请刷新后重试"); } var detailJson = JsonConvert.SerializeObject(new { before, after = new { entity.ConsultationStatus, entity.ConsultationTime, entity.DealStatus, entity.DealTime, entity.Remark, entity.Version } }); await _businessOperationLogService.WriteAsync( BizLogModule, "更新见诊成交", BizType, entity.Id, $"更新见诊成交 {entity.RecordNo},见诊:{EnumHelper.GetEnumDesc(entity.ConsultationStatus)},成交:{EnumHelper.GetEnumDesc(entity.DealStatus)}", detailJson); return new { message = "更新成功", version = newVersion }; } /// /// 后台分页查询到院登记列表 /// /// /// 管理端列表。非管理员按 organization dataScope 过滤来源组织;管理员查看全部。 /// memberMobile 返回完整手机号。 /// /// 示例请求: /// ```json /// { /// "startTime": "2026-07-01", /// "endTime": "2026-07-31", /// "sourceOrganizeId": "组织ID", /// "sourceMdid": "门店ID", /// "recorderUserId": "登记人ID", /// "memberKeyword": "张三", /// "arrivalType": 1, /// "consultationStatus": 1, /// "dealStatus": 0, /// "isEffective": 1, /// "currentPage": 1, /// "pageSize": 20 /// } /// ``` /// /// 查询条件 /// 标准分页列表 /// 返回分页结果 /// 服务器错误 [HttpGet("GetList")] public async Task GetListAsync([FromQuery] LqMemberArrivalListQueryInput input) { input ??= new LqMemberArrivalListQueryInput(); var userInfo = await _userManager.GetUserInfo(); var allowedOrganizeIds = await ResolveViewOrganizeIdsAsync(userInfo, input.sourceOrganizeId); var endExclusive = input.endTime?.Date.AddDays(1); var memberKw = string.IsNullOrWhiteSpace(input.memberKeyword) ? null : input.memberKeyword.Trim(); var data = await ApplyAdminListFilters(BuildListQuery(allowedOrganizeIds), input, endExclusive, memberKw) .OrderBy(x => x.ArrivalTime, OrderByType.Desc) .Select(x => new LqMemberArrivalListOutput { id = x.Id, recordNo = x.RecordNo, memberId = x.MemberId, memberName = x.MemberName, memberMobile = x.MemberMobile, sourceOrganizeId = x.SourceOrganizeId, sourceOrganizeName = x.SourceOrganizeName, sourceMdid = x.SourceMdid, sourceMdName = x.SourceMdName, arrivalType = x.ArrivalType, arrivalTime = x.ArrivalTime, consultationStatus = x.ConsultationStatus, consultationTime = x.ConsultationTime, dealStatus = x.DealStatus, dealTime = x.DealTime, recorderUserId = x.RecorderUserId, recorderUserName = x.RecorderUserName, lastModifyUserId = x.LastModifyUserId, lastModifyUserName = x.LastModifyUserName, remark = x.Remark, isEffective = x.IsEffective, voidReason = x.VoidReason, voidUserId = x.VoidUserId, voidUserName = x.VoidUserName, voidTime = x.VoidTime, version = x.Version, createTime = x.CreateTime, updateTime = x.UpdateTime }) .ToPagedListAsync(input.currentPage, input.pageSize); FillListEnumNames(data.list); return PageResult.SqlSugarPageResult(data); } /// /// 到院转化统计 /// /// /// 筛选条件与 GetList 一致。统计仅含有效记录(作废不进统计)。 /// 人头按会员ID去重;同会员周期内多记录以最后一次到院记录决定售前/售后及见诊/成交分类。 /// 所有统计按到院时间过滤;售前+售后=总人头。 /// /// 示例请求:与 GetList 相同(无需分页参数) /// /// 查询条件(与 GetList 一致) /// arrival/consultation/deal 各 total/preSales/afterSales 及转化率 /// 返回统计数据 /// 服务器错误 [HttpGet("GetStatistics")] public async Task GetStatisticsAsync([FromQuery] LqMemberArrivalListQueryInput input) { input ??= new LqMemberArrivalListQueryInput(); var userInfo = await _userManager.GetUserInfo(); var allowedOrganizeIds = await ResolveViewOrganizeIdsAsync(userInfo, input.sourceOrganizeId); var endExclusive = input.endTime?.Date.AddDays(1); var memberKw = string.IsNullOrWhiteSpace(input.memberKeyword) ? null : input.memberKeyword.Trim(); var records = await ApplyAdminListFilters(BuildListQuery(allowedOrganizeIds), input, endExclusive, memberKw) .Where(x => x.IsEffective == EffectiveYes) .Select(x => new { x.MemberId, x.ArrivalType, x.ArrivalTime, x.ConsultationStatus, x.DealStatus, x.CreateTime }) .ToListAsync(); return BuildStatistics(records.Select(r => ( r.MemberId, r.ArrivalType, r.ArrivalTime, r.ConsultationStatus, r.DealStatus, r.CreateTime)).ToList(), records.Count); } /// /// 作废到院登记 /// /// /// 仅管理员或对来源组织具备 Edit 权限者可作废。软作废、RecordKey 置空、版本+1,不进统计。 /// /// 示例请求: /// ```json /// { /// "id": "登记主键ID", /// "reason": "重复登记", /// "version": 1 /// } /// ``` /// /// 作废参数 /// 操作结果 /// 作废成功 /// 参数或版本冲突 /// 无编辑权限 /// 服务器错误 [HttpPost("Void")] public async Task VoidAsync([FromBody] LqMemberArrivalVoidInput input) { if (input == null || string.IsNullOrWhiteSpace(input.id)) { throw NCCException.Oh("id 不能为空"); } if (string.IsNullOrWhiteSpace(input.reason)) { throw NCCException.Bah("作废原因不能为空"); } var entity = await GetRecordOrThrowAsync(input.id); if (entity.IsEffective != EffectiveYes) { return new { message = "该登记已作废", idempotent = true }; } await EnsureCanEditOrganizeAsync(entity.SourceOrganizeId); var before = new { entity.IsEffective, entity.RecordKey, entity.Version, entity.VoidReason }; var now = DateTime.Now; var newVersion = entity.Version + 1; entity.IsEffective = EffectiveNo; entity.RecordKey = null; entity.VoidReason = input.reason.Trim(); entity.VoidUserId = _userManager.UserId; entity.VoidUserName = _userManager.RealName ?? _userManager.Account; entity.VoidTime = now; entity.UpdateTime = now; entity.Version = newVersion; var rows = await _db.Updateable(entity) .UpdateColumns(x => new { x.IsEffective, x.RecordKey, x.VoidReason, x.VoidUserId, x.VoidUserName, x.VoidTime, x.UpdateTime, x.Version }) .Where(x => x.Id == entity.Id && x.Version == input.version) .ExecuteCommandAsync(); if (rows <= 0) { throw NCCException.Bah("数据已被他人修改,请刷新后重试"); } var detailJson = JsonConvert.SerializeObject(new { before, after = new { entity.IsEffective, entity.RecordKey, entity.Version, entity.VoidReason, entity.VoidTime }, remark = entity.VoidReason }); await _businessOperationLogService.WriteAsync( BizLogModule, "作废到院登记", BizType, entity.Id, $"作废到院登记 {entity.RecordNo},原因:{entity.VoidReason}", detailJson); return new { message = "作废成功", version = newVersion }; } /// /// 导出到院登记列表 /// /// /// 筛选条件与 GetList 完全一致;导出成功后写入业务操作日志(不含手机号)。 /// /// 示例请求:与 GetList 相同,另加 dataType(0当前页/1全部)、selectKey(导出列) /// /// 查询与导出参数 /// Excel 下载信息 /// 返回下载链接 /// 服务器错误 [HttpGet("Actions/Export")] public async Task ExportAsync([FromQuery] LqMemberArrivalListQueryInput input) { input ??= new LqMemberArrivalListQueryInput(); List exportData; if (input.dataType == 0) { var page = Clay.Object(await GetListAsync(input)); exportData = page.Solidify>().list; } else { exportData = await GetNoPagingListAsync(input); } var paramList = "[{\"value\":\"登记编号\",\"field\":\"recordNo\"},{\"value\":\"会员姓名\",\"field\":\"memberName\"},{\"value\":\"手机号\",\"field\":\"memberMobile\"},{\"value\":\"来源组织\",\"field\":\"sourceOrganizeName\"},{\"value\":\"来源门店\",\"field\":\"sourceMdName\"},{\"value\":\"到院类型\",\"field\":\"arrivalTypeName\"},{\"value\":\"到院时间\",\"field\":\"arrivalTime\"},{\"value\":\"见诊状态\",\"field\":\"consultationStatusName\"},{\"value\":\"见诊时间\",\"field\":\"consultationTime\"},{\"value\":\"成交状态\",\"field\":\"dealStatusName\"},{\"value\":\"成交时间\",\"field\":\"dealTime\"},{\"value\":\"登记人\",\"field\":\"recorderUserName\"},{\"value\":\"备注\",\"field\":\"remark\"},{\"value\":\"是否有效\",\"field\":\"isEffective\"}]" .ToList(); var excelconfig = new ExcelConfig { FileName = "员工到院转化.xls", HeadFont = "微软雅黑", HeadPoint = 10, IsAllSizeColumn = true, ColumnModel = new List() }; var selectKeyList = string.IsNullOrWhiteSpace(input.selectKey) ? paramList.Select(p => p.field).ToList() : input.selectKey.Split(',').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); var fileName = _userManager.UserId + "|" + addPath + "|xls"; var startTimeStr = input.startTime?.ToString("yyyy-MM-dd") ?? ""; var endTimeStr = input.endTime?.ToString("yyyy-MM-dd") ?? ""; var detailJson = JsonConvert.SerializeObject(new { filters = new { startTime = input.startTime, endTime = input.endTime, sourceOrganizeId = input.sourceOrganizeId, sourceMdid = input.sourceMdid, recorderUserId = input.recorderUserId, memberKeyword = input.memberKeyword, arrivalType = input.arrivalType, consultationStatus = input.consultationStatus, dealStatus = input.dealStatus, isEffective = input.isEffective }, rowCount = exportData.Count, fileName = excelconfig.FileName }); await _businessOperationLogService.WriteAsync( BizLogModule, "导出到院登记", BizType, null, $"导出到院登记 {startTimeStr} 至 {endTimeStr},共 {exportData.Count} 条", detailJson); return new { name = excelconfig.FileName, url = "/api/File/Download?encryption=" + DESCEncryption.Encrypt(fileName, "NCC") }; } #region 私有方法 private async Task> GetNoPagingListAsync(LqMemberArrivalListQueryInput input) { var userInfo = await _userManager.GetUserInfo(); var allowedOrganizeIds = await ResolveViewOrganizeIdsAsync(userInfo, input.sourceOrganizeId); var endExclusive = input.endTime?.Date.AddDays(1); var memberKw = string.IsNullOrWhiteSpace(input.memberKeyword) ? null : input.memberKeyword.Trim(); var list = await ApplyAdminListFilters(BuildListQuery(allowedOrganizeIds), input, endExclusive, memberKw) .OrderBy(x => x.ArrivalTime, OrderByType.Desc) .Select(x => new LqMemberArrivalListOutput { id = x.Id, recordNo = x.RecordNo, memberId = x.MemberId, memberName = x.MemberName, memberMobile = x.MemberMobile, sourceOrganizeId = x.SourceOrganizeId, sourceOrganizeName = x.SourceOrganizeName, sourceMdid = x.SourceMdid, sourceMdName = x.SourceMdName, arrivalType = x.ArrivalType, arrivalTime = x.ArrivalTime, consultationStatus = x.ConsultationStatus, consultationTime = x.ConsultationTime, dealStatus = x.DealStatus, dealTime = x.DealTime, recorderUserId = x.RecorderUserId, recorderUserName = x.RecorderUserName, lastModifyUserId = x.LastModifyUserId, lastModifyUserName = x.LastModifyUserName, remark = x.Remark, isEffective = x.IsEffective, voidReason = x.VoidReason, voidUserId = x.VoidUserId, voidUserName = x.VoidUserName, voidTime = x.VoidTime, version = x.Version, createTime = x.CreateTime, updateTime = x.UpdateTime }) .ToListAsync(); FillListEnumNames(list); return list; } private ISugarQueryable BuildListQuery(List allowedOrganizeIds) { return _db.Queryable() .WhereIF(allowedOrganizeIds != null, x => allowedOrganizeIds.Contains(x.SourceOrganizeId)); } private static ISugarQueryable ApplyAdminListFilters( ISugarQueryable query, LqMemberArrivalListQueryInput input, DateTime? endExclusive, string memberKw) { return query .WhereIF(input.startTime.HasValue, x => x.ArrivalTime >= input.startTime.Value) .WhereIF(endExclusive.HasValue, x => x.ArrivalTime < endExclusive.Value) .WhereIF(!string.IsNullOrWhiteSpace(input.sourceMdid), x => x.SourceMdid == input.sourceMdid.Trim()) .WhereIF(!string.IsNullOrWhiteSpace(input.recorderUserId), x => x.RecorderUserId == input.recorderUserId.Trim()) .WhereIF(memberKw != null, x => x.MemberName.Contains(memberKw) || x.MemberMobile.Contains(memberKw) || x.RecordNo.Contains(memberKw) || SqlFunc.Subqueryable() .Where(k => k.Id == x.MemberId && k.Dah.Contains(memberKw)) .Any()) .WhereIF(input.arrivalType.HasValue, x => x.ArrivalType == input.arrivalType.Value) .WhereIF(input.consultationStatus.HasValue, x => x.ConsultationStatus == input.consultationStatus.Value) .WhereIF(input.dealStatus.HasValue, x => x.DealStatus == input.dealStatus.Value) .WhereIF(input.isEffective.HasValue, x => x.IsEffective == input.isEffective.Value); } private static LqMemberArrivalStatisticsOutput BuildStatistics( List<(string MemberId, int ArrivalType, DateTime ArrivalTime, int ConsultationStatus, int DealStatus, DateTime? CreateTime)> records, int recordCount) { var yes = (int)MemberArrivalOutcomeStatusEnum.是; var preSalesType = (int)MemberArrivalTypeEnum.售前; var afterSalesType = (int)MemberArrivalTypeEnum.售后; var lastByMember = records .GroupBy(x => x.MemberId) .Select(g => g .OrderByDescending(x => x.ArrivalTime) .ThenByDescending(x => x.CreateTime ?? DateTime.MinValue) .First()) .ToList(); var arrivalBucket = new LqMemberArrivalStatBucketOutput { total = lastByMember.Count, preSales = lastByMember.Count(x => x.ArrivalType == preSalesType), afterSales = lastByMember.Count(x => x.ArrivalType == afterSalesType) }; var consultationMembers = lastByMember.Where(x => x.ConsultationStatus == yes).ToList(); var dealMembers = lastByMember.Where(x => x.DealStatus == yes).ToList(); var consultationBucket = new LqMemberArrivalStatBucketOutput { total = consultationMembers.Count, preSales = consultationMembers.Count(x => x.ArrivalType == preSalesType), afterSales = consultationMembers.Count(x => x.ArrivalType == afterSalesType) }; var dealBucket = new LqMemberArrivalStatBucketOutput { total = dealMembers.Count, preSales = dealMembers.Count(x => x.ArrivalType == preSalesType), afterSales = dealMembers.Count(x => x.ArrivalType == afterSalesType) }; return new LqMemberArrivalStatisticsOutput { arrival = arrivalBucket, consultation = consultationBucket, deal = dealBucket, arrivalToConsultationRate = SafeRate(consultationBucket.total, arrivalBucket.total), consultationToDealRate = SafeRate(dealBucket.total, consultationBucket.total), arrivalToDealRate = SafeRate(dealBucket.total, arrivalBucket.total), recordCount = recordCount }; } private static decimal? SafeRate(int numerator, int denominator) { if (denominator <= 0) { return null; } return Math.Round((decimal)numerator / denominator, 4, MidpointRounding.AwayFromZero); } private async Task<(string recorderUserId, string recorderUserName, string sourceOrganizeId, string sourceOrganizeName, string sourceMdid, string sourceMdName)> GetRecorderSnapshotAsync() { var userId = _userManager.UserId; if (string.IsNullOrWhiteSpace(userId)) { throw NCCException.Oh("未登录或登录已失效"); } var user = _userManager.User ?? await _db.Queryable() .Where(x => x.Id == userId && x.DeleteMark == null) .FirstAsync(); if (user == null) { throw NCCException.Oh("当前用户不存在或已删除"); } var organizeName = string.Empty; if (!string.IsNullOrWhiteSpace(user.OrganizeId)) { organizeName = await _db.Queryable() .Where(x => x.Id == user.OrganizeId && x.DeleteMark == null) .Select(x => x.FullName) .FirstAsync() ?? string.Empty; } var mdName = string.Empty; if (!string.IsNullOrWhiteSpace(user.Mdid)) { mdName = await _db.Queryable() .Where(x => x.Id == user.Mdid) .Select(x => x.Dm) .FirstAsync() ?? string.Empty; } return ( userId, user.RealName ?? user.Account ?? userId, user.OrganizeId?.Trim(), organizeName, user.Mdid?.Trim(), mdName); } private async Task ValidateMemberInStoreAsync(string memberId, string sourceMdid) { var member = await _db.Queryable() .Where(x => x.Id == memberId && x.IsEffective == (int)StatusEnum.有效) .FirstAsync(); if (member == null) { throw NCCException.Bah("会员不存在或已失效"); } if (!string.Equals(member.Gsmd?.Trim(), sourceMdid, StringComparison.OrdinalIgnoreCase)) { throw NCCException.Bah("该会员不属于当前门店"); } return member; } private async Task GetRecordOrThrowAsync(string id) { if (string.IsNullOrWhiteSpace(id)) { throw NCCException.Oh("id 不能为空"); } var entity = await _db.Queryable() .Where(x => x.Id == id.Trim()) .FirstAsync(); if (entity == null) { throw NCCException.Oh("到院登记不存在"); } return entity; } private async Task EnsureCanViewRecordAsync(LqMemberArrivalRecordEntity entity) { if (string.Equals(entity.RecorderUserId, _userManager.UserId, StringComparison.OrdinalIgnoreCase)) { return; } var userInfo = await _userManager.GetUserInfo(); if (userInfo.isAdministrator) { return; } var allowed = await ResolveViewOrganizeIdsAsync(userInfo, null); if (allowed == null || allowed.Contains(entity.SourceOrganizeId)) { return; } throw NCCException.Oh(ErrorCode.D1013); } private async Task EnsureCanUpdateRecordAsync(LqMemberArrivalRecordEntity entity) { if (string.Equals(entity.RecorderUserId, _userManager.UserId, StringComparison.OrdinalIgnoreCase)) { return; } await EnsureCanEditOrganizeAsync(entity.SourceOrganizeId); } private async Task EnsureCanEditOrganizeAsync(string organizeId) { var userInfo = await _userManager.GetUserInfo(); if (!userInfo.isAdministrator && !(userInfo.dataScope?.Any(x => x.organizeId == organizeId && x.Edit) ?? false)) { // D1013 是项目统一的“无权限”业务码;显式设置 403,避免默认异常状态被包装成 500。 throw NCCException.Oh(ErrorCode.D1013).StatusCode(StatusCodes.Status403Forbidden); } } private async Task> ResolveViewOrganizeIdsAsync(UserInfo userInfo, string sourceOrganizeId) { if (userInfo.isAdministrator) { if (string.IsNullOrWhiteSpace(sourceOrganizeId)) { return null; } return new List { sourceOrganizeId.Trim() }; } var allOrgs = await _db.Queryable() .Where(x => x.DeleteMark == null) .ToListAsync(); var allowed = new HashSet(); foreach (var scope in userInfo.dataScope ?? new List()) { if (!scope.Add && !scope.Edit && !scope.Delete) { continue; } if (string.IsNullOrWhiteSpace(scope.organizeId)) { continue; } foreach (var id in allOrgs.TreeChildNode(scope.organizeId, t => t.Id, t => t.ParentId).Select(x => x.Id)) { allowed.Add(id); } } if (allowed.Count == 0) { return new List { "__no_scope__" }; } if (!string.IsNullOrWhiteSpace(sourceOrganizeId)) { var sel = sourceOrganizeId.Trim(); var subtree = allOrgs.TreeChildNode(sel, t => t.Id, t => t.ParentId).Select(x => x.Id).ToHashSet(); allowed.IntersectWith(subtree); if (allowed.Count == 0) { return new List { "__no_scope__" }; } } return allowed.ToList(); } private static void FillListEnumNames(IEnumerable list) { foreach (var row in list) { row.arrivalTypeName = EnumHelper.GetEnumDesc(row.arrivalType); row.consultationStatusName = EnumHelper.GetEnumDesc(row.consultationStatus); row.dealStatusName = EnumHelper.GetEnumDesc(row.dealStatus); } } private static LqMemberArrivalInfoOutput MapInfoOutput(LqMemberArrivalRecordEntity entity) { return new LqMemberArrivalInfoOutput { id = entity.Id, recordNo = entity.RecordNo, memberId = entity.MemberId, memberName = entity.MemberName, memberMobile = entity.MemberMobile, sourceOrganizeId = entity.SourceOrganizeId, sourceOrganizeName = entity.SourceOrganizeName, sourceMdid = entity.SourceMdid, sourceMdName = entity.SourceMdName, arrivalType = entity.ArrivalType, arrivalTypeName = EnumHelper.GetEnumDesc(entity.ArrivalType), arrivalTime = entity.ArrivalTime, consultationStatus = entity.ConsultationStatus, consultationStatusName = EnumHelper.GetEnumDesc(entity.ConsultationStatus), consultationTime = entity.ConsultationTime, dealStatus = entity.DealStatus, dealStatusName = EnumHelper.GetEnumDesc(entity.DealStatus), dealTime = entity.DealTime, recorderUserId = entity.RecorderUserId, recorderUserName = entity.RecorderUserName, lastModifyUserId = entity.LastModifyUserId, lastModifyUserName = entity.LastModifyUserName, remark = entity.Remark, isEffective = entity.IsEffective, voidReason = entity.VoidReason, voidUserName = entity.VoidUserName, voidTime = entity.VoidTime, version = entity.Version, createTime = entity.CreateTime, updateTime = entity.UpdateTime }; } private static void ValidateArrivalType(int arrivalType) { if (!Enum.IsDefined(typeof(MemberArrivalTypeEnum), arrivalType)) { throw NCCException.Bah("arrivalType 无效,仅支持 1售前 2售后"); } } private static void ValidateOutcomeStatus(int status, string fieldName) { if (!Enum.IsDefined(typeof(MemberArrivalOutcomeStatusEnum), status)) { throw NCCException.Bah($"{fieldName} 无效,仅支持 0待确认 1是 2否"); } } private static void NormalizeOutcomeStatuses(ref int consultationStatus, ref int dealStatus) { var yes = (int)MemberArrivalOutcomeStatusEnum.是; var no = (int)MemberArrivalOutcomeStatusEnum.否; var pending = (int)MemberArrivalOutcomeStatusEnum.待确认; // “见诊=否”是更明确的人工结论,优先于“成交=是”,必须保留见诊否并将成交回待确认。 if (consultationStatus == no) { if (dealStatus == yes) { dealStatus = pending; } } else if (dealStatus == yes) { consultationStatus = yes; } } private static DateTime? ResolveOutcomeTime(int status, DateTime now) { if (status == (int)MemberArrivalOutcomeStatusEnum.待确认) { return null; } return now; } private static void ApplyOutcomeChange(LqMemberArrivalRecordEntity entity, int consultationStatus, int dealStatus, DateTime now) { if (entity.ConsultationStatus != consultationStatus) { entity.ConsultationStatus = consultationStatus; entity.ConsultationTime = ResolveOutcomeTime(consultationStatus, now); } if (entity.DealStatus != dealStatus) { entity.DealStatus = dealStatus; entity.DealTime = ResolveOutcomeTime(dealStatus, now); } } private static string BuildRecordKey(string sourceMdid, string memberId, DateTime arrivalTime) { return $"{sourceMdid}_{memberId}_{arrivalTime:yyyyMMdd}"; } private static string GenerateRecordNo() { var rnd = new Random(Guid.NewGuid().GetHashCode()).Next(1000, 9999); return "MA" + DateTime.Now.ToString("yyyyMMddHHmmss") + rnd; } private static bool IsDuplicateKeyException(Exception ex) { var msg = ex.Message ?? string.Empty; return msg.Contains("Duplicate", StringComparison.OrdinalIgnoreCase) || msg.Contains("duplicate", StringComparison.OrdinalIgnoreCase) || msg.Contains("1062"); } #endregion } }