using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Authorization;
using Microsoft.AspNetCore.Mvc;
using NCC.ClayObject;
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.DataEncryption;
using NCC.Dependency;
using NCC.DynamicApiController;
using NCC.Extend.Entitys.Dto.LqTrainingCheckin;
using NCC.Extend.Entitys.Enum;
using NCC.Extend.Entitys.lq_training_checkin_record;
using NCC.Extend.Entitys.lq_training_checkin_token;
using NCC.Extend.Helpers;
using NCC.Extend.Interfaces.BusinessOperationLog;
using NCC.FriendlyException;
using NCC.JsonSerialization;
using SqlSugar;
using Yitter.IdGenerator;
namespace NCC.Extend
{
///
/// 培训签到(动态二维码 + 匿名打卡 + 管理端列表导出)
///
[ApiDescriptionSettings(Tag = "培训签到", Name = "LqTrainingCheckin", Order = 212)]
[Route("api/Extend/LqTrainingCheckin")]
public class LqTrainingCheckinService : IDynamicApiController, ITransient
{
private const string BizLogModule = "培训签到";
private const string BizTypeRecord = "lq_training_checkin_record";
private readonly ISqlSugarClient _db;
private readonly IUserManager _userManager;
private readonly IBusinessOperationLogService _businessOperationLogService;
///
/// 初始化培训签到服务
///
public LqTrainingCheckinService(
ISqlSugarClient db,
IUserManager userManager,
IBusinessOperationLogService businessOperationLogService)
{
_db = db;
_userManager = userManager;
_businessOperationLogService = businessOperationLogService;
}
#region 公开接口
///
/// 获取培训签到投屏信息(当前二维码令牌)
///
///
/// 教室门口投屏页轮询调用,返回当前有效动态令牌及过期时间;令牌过期后服务端会自动轮换。
///
/// 示例请求:
/// ```json
/// {}
/// ```
///
/// 参数说明:无
///
/// 当前令牌与轮换配置
/// 成功
[AllowAnonymous]
[HttpGet("GetDisplayInfo")]
public async Task GetDisplayInfoAsync()
{
var now = DateTime.Now;
var rotateMinutes = await TrainingCheckinHelper.GetRotateMinutesAsync(_db);
var (plainToken, tokenEntity) = await EnsureCurrentTokenAsync(rotateMinutes, now);
return new LqTrainingCheckinDisplayInfoOutput
{
token = plainToken,
expireAt = tokenEntity.ExpireTime,
serverTime = now,
rotateMinutes = rotateMinutes
};
}
///
/// 校验培训签到动态令牌
///
///
/// 扫码打开打卡页时调用,令牌无效或过期则不可打卡。
///
/// 示例请求:
/// `GET .../ValidateToken?token=xxx`
///
/// 参数说明:
/// - token: 二维码中的动态令牌
///
/// 动态令牌
/// 是否有效
/// 校验完成
[AllowAnonymous]
[HttpGet("ValidateToken")]
public async Task ValidateTokenAsync([FromQuery] string token)
{
var valid = await IsTokenValidAsync(token, DateTime.Now);
return new LqTrainingCheckinValidateTokenOutput
{
valid = valid,
message = valid ? "令牌有效" : "签到码已失效,请重新扫码"
};
}
///
/// 匿名提交培训签到/签退
///
///
/// 校验动态令牌、姓名与手机号后写入打卡记录,不做场次与人员关联校验。
///
/// 示例请求:
/// ```json
/// {
/// "token": "动态令牌",
/// "realName": "张三",
/// "mobilePhone": "13800138000",
/// "checkinType": 1
/// }
/// ```
///
/// 参数说明:
/// - checkinType: 1=签到,2=签退
///
/// 打卡数据
/// 打卡结果
/// 提交成功
/// 校验失败
[AllowAnonymous]
[HttpPost("Submit")]
public async Task SubmitAsync([FromBody] LqTrainingCheckinSubmitInput input)
{
TrainingCheckinHelper.ValidateSubmitInput(input);
var now = DateTime.Now;
var tokenEntity = await ResolveValidTokenEntityAsync(input.token, now);
if (tokenEntity == null)
throw NCCException.Oh("签到码已失效,请重新扫码");
var (submitIp, _) = TrainingCheckinHelper.ResolveSubmitClient();
var realName = TrainingCheckinHelper.NormalizeRealName(input.realName);
var mobile = TrainingCheckinHelper.NormalizeMobile(input.mobilePhone);
var typeName = TrainingCheckinHelper.GetCheckinTypeName(input.checkinType);
var entity = new LqTrainingCheckinRecordEntity
{
Id = YitIdHelper.NextId().ToString(),
RealName = realName,
MobilePhone = mobile,
CheckinType = input.checkinType,
CheckinTime = now,
SubmitIp = submitIp,
TokenId = tokenEntity.Id,
CreateTime = now
};
var ok = await _db.Insertable(entity).ExecuteCommandAsync();
if (ok <= 0)
throw NCCException.Oh("打卡失败,请稍后重试");
return new LqTrainingCheckinSubmitOutput
{
id = entity.Id,
checkinTypeName = typeName,
checkinTime = entity.CheckinTime,
message = $"{typeName}成功"
};
}
#endregion
#region 管理端
///
/// 手动添加培训签到记录
///
///
/// 管理后台补录打卡记录,支持全部打卡类型;无需动态令牌。
///
/// 示例请求:
/// ```json
/// {
/// "realName": "张三",
/// "mobilePhone": "13800138000",
/// "checkinType": 3,
/// "checkinTime": "2026-09-03 09:00:00"
/// }
/// ```
///
/// 参数说明:
/// - checkinType: 1=签到,2=签退,3=应休,4=请假,5=拓客,6=下店协助,7=下店
/// - checkinTime: 可选,为空则取当前时间
///
/// 补录数据
/// 新建记录信息
/// 添加成功
/// 校验失败
[HttpPost("Create")]
public async Task CreateAsync([FromBody] LqTrainingCheckinCreateInput input)
{
TrainingCheckinHelper.ValidateAdminCreateInput(input);
var now = DateTime.Now;
var realName = TrainingCheckinHelper.NormalizeRealName(input.realName);
var mobile = TrainingCheckinHelper.NormalizeMobile(input.mobilePhone);
var checkinTime = input.checkinTime ?? now;
var (submitIp, _) = TrainingCheckinHelper.ResolveSubmitClient();
var typeName = TrainingCheckinHelper.GetCheckinTypeName(input.checkinType);
var entity = new LqTrainingCheckinRecordEntity
{
Id = YitIdHelper.NextId().ToString(),
RealName = realName,
MobilePhone = mobile,
CheckinType = input.checkinType,
CheckinTime = checkinTime,
SubmitIp = string.IsNullOrWhiteSpace(submitIp) ? "后台补录" : submitIp,
TokenId = null,
CreateTime = now
};
var ok = await _db.Insertable(entity).ExecuteCommandAsync();
if (ok <= 0)
throw NCCException.Oh("添加失败,请稍后重试");
await TryWriteLogAsync(
"添加培训签到",
entity.Id,
$"添加培训签到记录:{realName} {typeName} {checkinTime:yyyy-MM-dd HH:mm:ss}",
new
{
after = new
{
entity.Id,
entity.RealName,
entity.MobilePhone,
entity.CheckinType,
entity.CheckinTime
}
}.Serialize());
return new LqTrainingCheckinSubmitOutput
{
id = entity.Id,
checkinTypeName = typeName,
checkinTime = entity.CheckinTime,
message = "添加成功"
};
}
///
/// 分页查询培训签到记录
///
/// 筛选与分页参数
/// 分页列表
[HttpGet("GetList")]
public async Task GetListAsync([FromQuery] LqTrainingCheckinListQueryInput input)
{
var sidx = string.IsNullOrWhiteSpace(input.sidx) ? "checkinTime" : input.sidx;
var query = BuildListQuery(input);
var data = await query
.Select(it => new LqTrainingCheckinListOutput
{
id = it.Id,
realName = it.RealName,
mobilePhone = it.MobilePhone,
checkinType = it.CheckinType,
checkinTime = it.CheckinTime,
submitIp = it.SubmitIp
})
.MergeTable()
.OrderBy(sidx + " " + input.sort)
.ToPagedListAsync(input.currentPage, input.pageSize);
FillCheckinTypeNames(data.list);
return PageResult.SqlSugarPageResult(data);
}
///
/// 导出培训签到记录
///
/// 筛选与导出列参数
/// 下载地址
[HttpGet("Actions/Export")]
public async Task ExportAsync([FromQuery] LqTrainingCheckinListQueryInput input)
{
_ = await _userManager.GetUserInfo();
var exportData = new List();
if (input.dataType == 0)
{
var data = Clay.Object(await GetListAsync(input));
exportData = data.Solidify>().list;
}
else
{
exportData = await GetNoPagingListAsync(input);
}
var paramList = "[{\"value\":\"姓名\",\"field\":\"realName\"},{\"value\":\"手机号\",\"field\":\"mobilePhone\"},{\"value\":\"类型\",\"field\":\"checkinTypeName\"},{\"value\":\"打卡时间\",\"field\":\"checkinTime\"},{\"value\":\"提交IP\",\"field\":\"submitIp\"}]"
.ToList();
var excelconfig = new ExcelConfig
{
FileName = $"培训签到记录_{DateTime.Now:yyyyMMddHHmmss}.xls",
HeadFont = "微软雅黑",
HeadPoint = 10,
IsAllSizeColumn = true,
ColumnModel = new List()
};
var selectKeyList = (input.selectKey ?? string.Empty).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 output = new
{
name = excelconfig.FileName,
url = "/api/File/Download?encryption=" + DESCEncryption.Encrypt(fileName, "NCC")
};
await TryWriteLogAsync(
"导出培训签到",
null,
$"导出培训签到记录,共 {exportData.Count} 条",
new
{
filters = new { input.keyword, input.checkinType, input.startTime, input.endTime, input.dataType },
rowCount = exportData.Count,
fileName = excelconfig.FileName
}.Serialize());
return output;
}
#endregion
#region 私有方法
[NonAction]
private async Task> GetNoPagingListAsync(LqTrainingCheckinListQueryInput input)
{
var sidx = string.IsNullOrWhiteSpace(input.sidx) ? "checkinTime" : input.sidx;
var list = await BuildListQuery(input)
.Select(it => new LqTrainingCheckinListOutput
{
id = it.Id,
realName = it.RealName,
mobilePhone = it.MobilePhone,
checkinType = it.CheckinType,
checkinTime = it.CheckinTime,
submitIp = it.SubmitIp
})
.MergeTable()
.OrderBy(sidx + " " + input.sort)
.ToListAsync();
FillCheckinTypeNames(list);
return list;
}
private static void FillCheckinTypeNames(IEnumerable list)
{
if (list == null)
return;
foreach (var item in list)
{
item.checkinTypeName = TrainingCheckinHelper.GetCheckinTypeName(item.checkinType);
}
}
private ISugarQueryable BuildListQuery(LqTrainingCheckinListQueryInput input)
{
DateTime? start = ParseDateTime(input.startTime);
DateTime? end = ParseDateTime(input.endTime);
var keyword = (input.keyword ?? string.Empty).Trim();
return _db.Queryable()
.WhereIF(!string.IsNullOrEmpty(keyword), it => it.RealName.Contains(keyword) || it.MobilePhone.Contains(keyword))
.WhereIF(input.checkinType.HasValue, it => it.CheckinType == input.checkinType.Value)
.WhereIF(start.HasValue, it => it.CheckinTime >= start.Value)
.WhereIF(end.HasValue, it => it.CheckinTime <= end.Value);
}
private static DateTime? ParseDateTime(string value)
{
if (string.IsNullOrWhiteSpace(value))
return null;
return DateTime.TryParse(value.Trim(), out var dt) ? dt : (DateTime?)null;
}
private async Task<(string plainToken, LqTrainingCheckinTokenEntity entity)> EnsureCurrentTokenAsync(int rotateMinutes, DateTime now)
{
var current = await _db.Queryable()
.Where(x => x.ExpireTime > now)
.OrderBy(x => x.CreateTime, OrderByType.Desc)
.FirstAsync();
if (current != null && !string.IsNullOrWhiteSpace(current.PlainToken))
return (current.PlainToken, current);
var (plainToken, tokenEntity) = TrainingCheckinHelper.CreateTokenEntity(rotateMinutes, now);
var ok = await _db.Insertable(tokenEntity).ExecuteCommandAsync();
if (ok <= 0)
throw NCCException.Oh("生成签到码失败,请稍后重试");
return (plainToken, tokenEntity);
}
private async Task IsTokenValidAsync(string plainToken, DateTime now)
{
var entity = await ResolveValidTokenEntityAsync(plainToken, now);
return entity != null;
}
private async Task ResolveValidTokenEntityAsync(string plainToken, DateTime now)
{
if (string.IsNullOrWhiteSpace(plainToken))
return null;
var hash = TrainingCheckinHelper.ComputeTokenHash(plainToken);
return await _db.Queryable()
.Where(x => x.TokenHash == hash && x.ExpireTime > now)
.FirstAsync();
}
private async Task TryWriteLogAsync(string actionCode, string bizId, string summary, string detailJson)
{
try
{
await _businessOperationLogService.WriteAsync(
BizLogModule,
actionCode,
BizTypeRecord,
bizId,
summary,
detailJson);
}
catch
{
// 写日志失败不拖垮主业务
}
}
#endregion
}
}