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
}
}