using System;
using System.Globalization;
using System.Linq;
using System.Security.Cryptography;
using System.Text;
using System.Text.RegularExpressions;
using NCC;
using NCC.Common.Extension;
using NCC.DataEncryption;
namespace NCC.Extend
{
///
/// 员工档案敏感字段加解密、哈希与脱敏(身份证/银行卡)。
/// AES 密钥读取顺序:EmployeeProfile:SensitiveDataAesKey → JWTSettings:IssuerSigningKey(取前 32 字符)。
///
public static class EmployeeProfileSensitiveHelper
{
/// 字典 certificateType-身份证 F_Id
internal const string IdCardCertificateTypeId = "a745d425adbb4321880817661cae8910";
internal const int DuplicateSubmitWindowMinutes = 30;
internal const int SameIpSubmitWindowMinutes = 5;
internal static readonly string[] PublicRequiredFields =
{
"realName", "mobilePhone", "gender", "idCardNo",
"currentAddress", "idCardAddress", "idCardFrontUrl", "idCardBackUrl",
"bankName", "bankCardNo", "bankAccountName",
"urgentContacts", "urgentTelePhone"
};
/// 文化程度合法取值白名单
internal static readonly string[] EducationLevels =
{
"博士", "硕士", "本科", "大专", "中专", "技校", "高中", "初中", "小学"
};
private static readonly string[] FullAddressDetailKeywords =
{
"区", "县", "镇", "乡", "村", "路", "街", "道", "号", "弄", "栋", "单元", "室", "层", "楼", "组", "委", "队",
"巷", "里", "苑", "园", "小区", "社区", "大厦"
};
internal static string NormalizeIdCard(string idCard)
{
return string.IsNullOrWhiteSpace(idCard) ? null : idCard.Trim().ToUpperInvariant();
}
internal static string NormalizeMobile(string mobile)
{
return string.IsNullOrWhiteSpace(mobile) ? null : mobile.Trim();
}
internal static string NormalizeBankCard(string bankCard)
{
return string.IsNullOrWhiteSpace(bankCard) ? null : Regex.Replace(bankCard.Trim(), @"\s+", string.Empty);
}
internal static string ComputeIdCardHash(string idCard)
{
var normalized = NormalizeIdCard(idCard);
if (string.IsNullOrEmpty(normalized))
{
return null;
}
using var sha = SHA256.Create();
var bytes = sha.ComputeHash(Encoding.UTF8.GetBytes(normalized));
return BitConverter.ToString(bytes).Replace("-", string.Empty).ToLowerInvariant();
}
internal static string EncryptSensitive(string plain)
{
if (string.IsNullOrWhiteSpace(plain))
{
return null;
}
return AESEncryption.Encrypt(plain, ResolveAesKey());
}
public static string DecryptSensitive(string cipher)
{
if (string.IsNullOrWhiteSpace(cipher))
{
return null;
}
try
{
return AESEncryption.Decrypt(cipher, ResolveAesKey());
}
catch
{
return null;
}
}
internal static string ResolveAesKey()
{
var configured = App.Configuration["EmployeeProfile:SensitiveDataAesKey"];
if (!string.IsNullOrWhiteSpace(configured))
{
return configured.Trim();
}
var jwtKey = App.Configuration["JWTSettings:IssuerSigningKey"];
if (!string.IsNullOrWhiteSpace(jwtKey))
{
var key = jwtKey.Trim();
return key.Length >= 32 ? key.Substring(0, 32) : key.PadRight(32, '0');
}
throw new InvalidOperationException("未配置 EmployeeProfile:SensitiveDataAesKey 或 JWTSettings:IssuerSigningKey,无法加解密敏感字段");
}
internal static string MaskPhone(string phone)
{
if (string.IsNullOrWhiteSpace(phone) || phone.Length < 7)
{
return "无";
}
return phone.Substring(0, 3) + "****" + phone.Substring(phone.Length - 4);
}
public static string MaskIdCard(string idCard)
{
if (string.IsNullOrWhiteSpace(idCard) || idCard.Length < 8)
{
return "无";
}
return idCard.Substring(0, 4) + "********" + idCard.Substring(idCard.Length - 4);
}
public static string MaskBankCard(string bankCard)
{
if (string.IsNullOrWhiteSpace(bankCard) || bankCard.Length < 8)
{
return "无";
}
return "**** **** **** " + bankCard.Substring(bankCard.Length - 4);
}
/// 审核比对:仅展示后 4 位,仍非完整明文。
internal static string MaskTail4(string value)
{
if (string.IsNullOrWhiteSpace(value) || value.Length < 4)
{
return "无";
}
return "****" + value.Substring(value.Length - 4);
}
public static int? CalcAgeFromIdCard(string idCard, DateTime? birthdayFallback = null)
{
var birth = ParseBirthdayFromIdCard(idCard) ?? birthdayFallback?.Date;
if (!birth.HasValue)
{
return null;
}
var today = DateTime.Today;
var age = today.Year - birth.Value.Year;
if (birth.Value.Date > today.AddYears(-age))
{
age--;
}
return age < 0 ? (int?)null : age;
}
internal static DateTime? ParseBirthdayFromIdCard(string idCard)
{
var normalized = NormalizeIdCard(idCard);
if (string.IsNullOrEmpty(normalized))
{
return null;
}
if (normalized.Length == 18
&& DateTime.TryParseExact(normalized.Substring(6, 8), "yyyyMMdd", null, DateTimeStyles.None, out var dt18))
{
return dt18.Date;
}
if (normalized.Length == 15
&& DateTime.TryParseExact("19" + normalized.Substring(6, 6), "yyyyMMdd", null, DateTimeStyles.None, out var dt15))
{
return dt15.Date;
}
return null;
}
internal static int? ParseGenderFromIdCard(string idCard)
{
var normalized = NormalizeIdCard(idCard);
if (string.IsNullOrEmpty(normalized))
{
return null;
}
var index = normalized.Length == 18 ? 16 : normalized.Length == 15 ? 14 : -1;
if (index < 0 || !char.IsDigit(normalized[index]))
{
return null;
}
return (normalized[index] - '0') % 2 == 1 ? 1 : 2;
}
public static string CalcTenureText(DateTime? entryDate)
{
if (!entryDate.HasValue)
{
return "无";
}
var today = DateTime.Today;
if (entryDate.Value.Date > today)
{
return "未入职";
}
var months = (today.Year - entryDate.Value.Year) * 12 + today.Month - entryDate.Value.Month;
if (today.Day < entryDate.Value.Day)
{
months--;
}
if (months < 0)
{
months = 0;
}
var years = months / 12;
var rem = months % 12;
if (years > 0 && rem > 0)
{
return $"{years}年{rem}个月";
}
if (years > 0)
{
return $"{years}年";
}
return $"{rem}个月";
}
internal static bool IsValidMobile(string mobile)
{
return !string.IsNullOrWhiteSpace(mobile) && Regex.IsMatch(mobile.Trim(), @"^1\d{10}$");
}
internal static bool IsValidBankCard(string bankCard)
{
if (string.IsNullOrWhiteSpace(bankCard))
{
return true;
}
var normalized = NormalizeBankCard(bankCard);
return normalized.Length >= 12 && normalized.Length <= 30 && normalized.All(char.IsDigit);
}
internal static bool IsEnumDefined(int? value) where T : struct, Enum
{
return !value.HasValue || Enum.IsDefined(typeof(T), value.Value);
}
internal static bool IsValidEducation(string education)
{
if (string.IsNullOrWhiteSpace(education))
{
return false;
}
var trimmed = education.Trim();
return EducationLevels.Any(x => x == trimmed);
}
internal static bool IsValidFullAddress(string address)
{
if (string.IsNullOrWhiteSpace(address))
{
return false;
}
var trimmed = address.Trim();
if (trimmed.Length < 8)
{
return false;
}
return FullAddressDetailKeywords.Any(trimmed.Contains);
}
internal static bool IsValidHttpUrl(string url)
{
if (string.IsNullOrWhiteSpace(url))
{
return false;
}
return Uri.TryCreate(url.Trim(), UriKind.Absolute, out var uri)
&& (uri.Scheme == Uri.UriSchemeHttp || uri.Scheme == Uri.UriSchemeHttps);
}
/// 入职日期 + 试用期月数自动推算转正日期;二者齐全时覆盖手工值。
internal static DateTime? CalcRegularizationDate(DateTime? entryDate, int? probationMonths)
{
if (!entryDate.HasValue || !probationMonths.HasValue)
{
return null;
}
return entryDate.Value.Date.AddMonths(probationMonths.Value);
}
internal static bool IsSamePhoneAfterNormalize(string phoneA, string phoneB)
{
var a = NormalizeMobile(phoneA);
var b = NormalizeMobile(phoneB);
return !string.IsNullOrEmpty(a) && a == b;
}
internal static string GenerateSubmissionNo()
{
var rnd = new Random(Guid.NewGuid().GetHashCode()).Next(1000, 9999);
return "EP" + DateTime.Now.ToString("yyyyMMddHHmmss") + rnd;
}
internal static (string ip, string ua) ResolveSubmitClient()
{
var ctx = App.HttpContext;
var ip = ctx?.Connection?.RemoteIpAddress?.ToString();
var ua = ctx?.Request?.Headers["User-Agent"].ToString();
if (ua != null && ua.Length > 500)
{
ua = ua.Substring(0, 500);
}
return (ip, ua);
}
}
}