using System; using System.Security.Claims; using System.Threading.Tasks; using Microsoft.AspNetCore.Mvc; using Microsoft.Extensions.Logging; using NCC.Common.Const; using NCC.Common.Core.Manager; using NCC.Common.Filter; using NCC.Dependency; using NCC.DynamicApiController; using NCC.Extend.Entitys.Dto.Mall; using NCC.Extend.Entitys.Enum; using NCC.Extend.Entitys.lq_mall_appointment; using NCC.Extend.Entitys.lq_mall_member; using NCC.Extend.Entitys.lq_mdxx; using NCC.Extend.Interfaces.BusinessOperationLog; using NCC.FriendlyException; using NCC.System.Entitys.Permission; using SqlSugar; using Yitter.IdGenerator; namespace NCC.Extend { /// /// 会员商城-预约意向(会员提交到店预约意向,门店/后台查看后电话确认;不关联现有预约业务) /// [ApiDescriptionSettings(Tag = "会员商城-预约", Name = "LqMallAppointment", Order = 304)] [Route("api/Extend/LqMallAppointment")] public class LqMallAppointmentService : IDynamicApiController, ITransient { private readonly IUserManager _userManager; private readonly ILogger _logger; private readonly ISqlSugarClient _db; private readonly IBusinessOperationLogService _log; /// /// 构造函数 /// public LqMallAppointmentService( IUserManager userManager, ILogger logger, ISqlSugarClient db, IBusinessOperationLogService log) { _userManager = userManager; _logger = logger; _db = db; _log = log; } #region C 端(会员小程序) /// /// 创建预约意向 /// /// 预约输入 /// 预约 Id 与单号 [HttpPost("CreateAppointment")] public async Task CreateAppointmentAsync([FromBody] MallAppointmentCreateInput input) { var memberId = GetCurrentMemberId(); if (input == null) throw NCCException.Oh("参数不能为空"); if (string.IsNullOrWhiteSpace(input.StoreId)) throw NCCException.Oh("请选择预约门店"); if (input.AppointDate == null) throw NCCException.Oh("请选择期望到店日期"); if (string.IsNullOrWhiteSpace(input.TimeSlot)) throw NCCException.Oh("请选择期望到店时段"); var member = await _db.Queryable() .Where(x => x.Id == memberId && x.DeleteMark == null).FirstAsync(); if (member == null) throw NCCException.Oh("会员不存在"); var store = await _db.Queryable().Where(x => x.Id == input.StoreId).FirstAsync(); if (store == null) throw NCCException.Oh("预约门店不存在"); var phone = string.IsNullOrWhiteSpace(input.ContactPhone) ? member.Phone : input.ContactPhone.Trim(); if (string.IsNullOrWhiteSpace(phone)) throw NCCException.Oh("请填写联系手机号"); var entity = new LqMallAppointmentEntity { Id = YitIdHelper.NextId().ToString(), AppointmentNo = GenerateAppointmentNo(), MemberId = member.Id, MemberName = member.NickName, MemberPhone = phone, StoreId = store.Id, StoreName = store.Dm, AppointDate = input.AppointDate.Value.Date, TimeSlot = input.TimeSlot.Trim(), ProjectDesc = input.ProjectDesc, Remark = input.Remark, Status = (int)MallAppointmentStatusEnum.待确认, CreateTime = DateTime.Now, UpdateTime = DateTime.Now }; var ok = await _db.Insertable(entity).ExecuteCommandAsync(); if (ok <= 0) throw NCCException.Oh("预约提交失败,请重试"); return new { id = entity.Id, appointmentNo = entity.AppointmentNo }; } /// /// 我的预约列表(分页,可按状态过滤) /// /// 查询条件 /// 预约分页列表 [HttpGet("GetMyAppointments")] public async Task GetMyAppointmentsAsync([FromQuery] MallMyAppointmentQueryInput input) { var memberId = GetCurrentMemberId(); var data = await _db.Queryable() .Where(x => x.MemberId == memberId && x.DeleteMark == null) .WhereIF(input.Status.HasValue, x => x.Status == input.Status.Value) .OrderBy(x => x.CreateTime, OrderByType.Desc) .Select(x => new MallAppointmentListOutput { id = x.Id, appointmentNo = x.AppointmentNo, memberId = x.MemberId, memberName = x.MemberName, memberPhone = x.MemberPhone, storeId = x.StoreId, storeName = x.StoreName, appointDate = x.AppointDate, timeSlot = x.TimeSlot, projectDesc = x.ProjectDesc, remark = x.Remark, status = x.Status, confirmUserName = x.ConfirmUserName, confirmTime = x.ConfirmTime, confirmRemark = x.ConfirmRemark, cancelReason = x.CancelReason, createTime = x.CreateTime }) .ToPagedListAsync(input.currentPage, input.pageSize); return PageResult.SqlSugarPageResult(data); } /// /// 我的预约详情 /// /// 预约 Id /// 预约详情 [HttpGet("GetAppointmentDetail")] public async Task GetAppointmentDetailAsync([FromQuery] string id) { var memberId = GetCurrentMemberId(); if (string.IsNullOrWhiteSpace(id)) throw NCCException.Oh("预约 Id 不能为空"); var entity = await _db.Queryable() .Where(x => x.Id == id && x.MemberId == memberId && x.DeleteMark == null).FirstAsync(); if (entity == null) throw NCCException.Oh("预约不存在"); return MapDetail(entity); } /// /// 取消预约(仅待确认可取消) /// /// 预约 Id [HttpPut("CancelAppointment/{id}")] public async Task CancelAppointmentAsync([FromRoute] string id) { var memberId = GetCurrentMemberId(); var entity = await _db.Queryable() .Where(x => x.Id == id && x.MemberId == memberId && x.DeleteMark == null).FirstAsync(); if (entity == null) throw NCCException.Oh("预约不存在"); if (entity.Status != (int)MallAppointmentStatusEnum.待确认) throw NCCException.Oh("仅待确认的预约可取消"); entity.Status = (int)MallAppointmentStatusEnum.已取消; entity.CancelReason = "会员取消"; entity.UpdateTime = DateTime.Now; await _db.Updateable(entity) .UpdateColumns(x => new { x.Status, x.CancelReason, x.UpdateTime }) .ExecuteCommandAsync(); } #endregion #region 管理端 /// /// 管理端预约列表(分页,多条件筛选,全门店) /// /// 查询条件 /// 预约分页列表 [HttpGet("GetAdminList")] public async Task GetAdminListAsync([FromQuery] MallAppointmentAdminQueryInput input) { var data = await BuildAdminQuery(input).ToPagedListAsync(input.currentPage, input.pageSize); return PageResult.SqlSugarPageResult(data); } /// /// 管理端预约详情 /// /// 预约 Id /// 预约详情 [HttpGet("GetAdminDetail")] public async Task GetAdminDetailAsync([FromQuery] string id) { if (string.IsNullOrWhiteSpace(id)) throw NCCException.Oh("预约 Id 不能为空"); var entity = await _db.Queryable() .Where(x => x.Id == id && x.DeleteMark == null).FirstAsync(); if (entity == null) throw NCCException.Oh("预约不存在"); return MapDetail(entity); } /// /// 确认预约(待确认→已确认,记录确认人与沟通结果;管理端与门店端共用) /// /// 确认输入(门店端需传 StoreId 做归属校验) /// 确认结果 [HttpPut("Confirm")] public async Task ConfirmAsync([FromBody] MallAppointmentConfirmInput input) { if (input == null || string.IsNullOrWhiteSpace(input.Id)) throw NCCException.Oh("预约 Id 不能为空"); var entity = await _db.Queryable() .Where(x => x.Id == input.Id && x.DeleteMark == null).FirstAsync(); if (entity == null) throw NCCException.Oh("预约不存在"); if (!string.IsNullOrWhiteSpace(input.StoreId) && entity.StoreId != input.StoreId) throw NCCException.Oh("该预约不属于当前门店"); if (entity.Status == (int)MallAppointmentStatusEnum.已取消) throw NCCException.Oh("预约已取消,无法确认"); if (entity.Status == (int)MallAppointmentStatusEnum.已确认) throw NCCException.Oh("预约已确认,请勿重复操作"); var operatorId = _userManager.UserId; var operatorName = ""; if (!string.IsNullOrWhiteSpace(operatorId)) { operatorName = await _db.Queryable() .Where(x => x.Id == operatorId).Select(x => x.RealName).FirstAsync(); } entity.Status = (int)MallAppointmentStatusEnum.已确认; entity.ConfirmUser = operatorId; entity.ConfirmUserName = operatorName; entity.ConfirmTime = DateTime.Now; entity.ConfirmRemark = input.ConfirmRemark; entity.UpdateTime = DateTime.Now; await _db.Updateable(entity) .UpdateColumns(x => new { x.Status, x.ConfirmUser, x.ConfirmUserName, x.ConfirmTime, x.ConfirmRemark, x.UpdateTime }) .ExecuteCommandAsync(); await _log.WriteAsync("会员商城", "确认预约", "mall_appointment", entity.Id, $"确认会员预约:{entity.MemberName}({entity.MemberPhone}){entity.AppointmentNo}"); return new { success = true, id = entity.Id }; } /// /// 管理端取消预约(待确认/已确认均可取消,记录原因) /// /// 确认输入(复用,读取 Id / ConfirmRemark 作为取消原因) [HttpPut("AdminCancel")] public async Task AdminCancelAsync([FromBody] MallAppointmentConfirmInput input) { if (input == null || string.IsNullOrWhiteSpace(input.Id)) throw NCCException.Oh("预约 Id 不能为空"); var entity = await _db.Queryable() .Where(x => x.Id == input.Id && x.DeleteMark == null).FirstAsync(); if (entity == null) throw NCCException.Oh("预约不存在"); if (!string.IsNullOrWhiteSpace(input.StoreId) && entity.StoreId != input.StoreId) throw NCCException.Oh("该预约不属于当前门店"); if (entity.Status == (int)MallAppointmentStatusEnum.已取消) throw NCCException.Oh("预约已取消"); entity.Status = (int)MallAppointmentStatusEnum.已取消; entity.CancelReason = string.IsNullOrWhiteSpace(input.ConfirmRemark) ? "门店取消" : input.ConfirmRemark.Trim(); entity.UpdateTime = DateTime.Now; await _db.Updateable(entity) .UpdateColumns(x => new { x.Status, x.CancelReason, x.UpdateTime }) .ExecuteCommandAsync(); await _log.WriteAsync("会员商城", "取消预约", "mall_appointment", entity.Id, $"取消会员预约:{entity.MemberName}({entity.MemberPhone}){entity.AppointmentNo}"); } #endregion #region 门店端 /// /// 门店端预约列表(仅本门店,分页,可按状态过滤) /// /// 查询条件(StoreId 必填) /// 预约分页列表 [HttpGet("GetStoreList")] public async Task GetStoreListAsync([FromQuery] MallAppointmentAdminQueryInput input) { if (input == null || string.IsNullOrWhiteSpace(input.StoreId)) throw NCCException.Oh("门店 Id 不能为空"); var data = await BuildAdminQuery(input).ToPagedListAsync(input.currentPage, input.pageSize); return PageResult.SqlSugarPageResult(data); } #endregion #region 私有方法 /// /// 构建管理端/门店端通用查询 /// private ISugarQueryable BuildAdminQuery(MallAppointmentAdminQueryInput input) { return _db.Queryable() .Where(x => x.DeleteMark == null) .WhereIF(!string.IsNullOrWhiteSpace(input.StoreId), x => x.StoreId == input.StoreId) .WhereIF(input.Status.HasValue, x => x.Status == input.Status.Value) .WhereIF(!string.IsNullOrWhiteSpace(input.Keyword), x => x.MemberName.Contains(input.Keyword) || x.MemberPhone.Contains(input.Keyword)) .WhereIF(input.StartDate.HasValue, x => x.AppointDate >= input.StartDate.Value.Date) .WhereIF(input.EndDate.HasValue, x => x.AppointDate <= input.EndDate.Value.Date) .OrderBy(x => x.CreateTime, OrderByType.Desc) .Select(x => new MallAppointmentListOutput { id = x.Id, appointmentNo = x.AppointmentNo, memberId = x.MemberId, memberName = x.MemberName, memberPhone = x.MemberPhone, storeId = x.StoreId, storeName = x.StoreName, appointDate = x.AppointDate, timeSlot = x.TimeSlot, projectDesc = x.ProjectDesc, remark = x.Remark, status = x.Status, confirmUserName = x.ConfirmUserName, confirmTime = x.ConfirmTime, confirmRemark = x.ConfirmRemark, cancelReason = x.CancelReason, createTime = x.CreateTime }); } private static object MapDetail(LqMallAppointmentEntity x) { return new { id = x.Id, appointmentNo = x.AppointmentNo, memberId = x.MemberId, memberName = x.MemberName, memberPhone = x.MemberPhone, storeId = x.StoreId, storeName = x.StoreName, appointDate = x.AppointDate, timeSlot = x.TimeSlot, projectDesc = x.ProjectDesc, remark = x.Remark, status = x.Status, confirmUser = x.ConfirmUser, confirmUserName = x.ConfirmUserName, confirmTime = x.ConfirmTime, confirmRemark = x.ConfirmRemark, cancelReason = x.CancelReason, createTime = x.CreateTime, updateTime = x.UpdateTime }; } /// /// 生成预约单号(Y + 时间戳 + 随机) /// private static string GenerateAppointmentNo() { var rnd = new Random(Guid.NewGuid().GetHashCode()).Next(1000, 9999); return "Y" + DateTime.Now.ToString("yyyyMMddHHmmss") + rnd; } /// /// 获取当前登录会员 Id /// private string GetCurrentMemberId() { var memberId = App.User?.FindFirstValue(ClaimConst.CLAINM_USERID); if (string.IsNullOrWhiteSpace(memberId)) throw NCCException.Oh("未登录"); return memberId; } #endregion } }