using NCC.Common.Core.Manager;
using NCC.Common.Enum;
using NCC.Common.Extension;
using NCC.Common.Filter;
using NCC.Code;
using NCC.Dependency;
using NCC.DynamicApiController;
using NCC.FriendlyException;
using NCC.Extend.Interfaces.User;
using Mapster;
using Microsoft.AspNetCore.Mvc;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using NCC.System.Entitys.Permission;
using NCC.Extend.Entitys.Dto.User;
using NCC.Common.Helper;
using NCC.JsonSerialization;
using NCC.Common.Model.NPOI;
using NCC.Common.Configuration;
using NCC.DataEncryption;
using NCC.ClayObject;
using NCC.Extend.Entitys.lq_jinsanjiao_user;
using NCC.Extend.Entitys.lq_mdxx;
using NCC.Extend.Entitys.lq_employee_profile;
using NCC.Extend.Entitys.Enum;
using NCC.System.Entitys.System;
namespace NCC.Extend.User
{
///
/// 用户服务
///
[ApiDescriptionSettings(Tag = "绿纤用户服务", Name = "User", Order = 200)]
[Route("api/Extend/[controller]")]
public class UserService : IUserService, IDynamicApiController, ITransient
{
private readonly ISqlSugarRepository _userRepository;
private readonly SqlSugarScope _db;
private readonly IUserManager _userManager;
///
/// 初始化一个类型的新实例
///
public UserService(
ISqlSugarRepository userRepository,
IUserManager userManager)
{
_userRepository = userRepository;
_db = _userRepository.Context;
_userManager = userManager;
}
private static readonly HashSet CrossStoreGwExact = new HashSet(StringComparer.Ordinal)
{
"科技老师",
"总经理",
"经理",
"董事长",
"总裁",
};
///
/// 跨店/总部岗位在未传 mdid 时不按当前登录门店自动过滤(如科技老师供各门店选择)
///
private static bool ShouldAutoFilterByCurrentStoreMdid(string gw)
{
if (string.IsNullOrWhiteSpace(gw))
return false;
return !CrossStoreGwExact.Contains(gw.Trim());
}
#region 获取用户列表
///
/// 获取用户列表
///
///
/// 员工 App「员工信息」与各端选人共用。列表含报道时间 reportDate。
/// crossStore=1 时不自动补当前登录门店;若同时传 mdid 则按该门店筛选。
///
/// 示例请求:
/// GET /api/Extend/User?currentPage=1&pageSize=20&crossStore=1&mdid=门店ID&onlyOnJob=1
///
/// 分页与筛选(mdid / gw / organizeId / onlyOnJob / crossStore 等)
/// 分页用户列表
/// 成功返回列表
[HttpGet("")]
public async Task GetUserList([FromQuery] UserListQueryInput input)
{
var sidx = input.sidx == null ? "id" : input.sidx;
DateTime? monthStart = null;
DateTime? monthLast = null;
if (!string.IsNullOrWhiteSpace(input.onJobMonth))
{
var parts = input.onJobMonth.Split('-');
if (parts.Length == 2 && int.TryParse(parts[0], out var year) && int.TryParse(parts[1], out var month))
{
if (month >= 1 && month <= 12)
{
monthStart = new DateTime(year, month, 1);
monthLast = new DateTime(year, month, DateTime.DaysInMonth(year, month), 23, 59, 59);
}
}
}
if (input.crossStore != 1
&& string.IsNullOrWhiteSpace(input.mdid)
&& !string.IsNullOrWhiteSpace(input.gw)
&& ShouldAutoFilterByCurrentStoreMdid(input.gw))
{
var currentUser = await _userManager.GetUserInfo();
if (currentUser != null && !string.IsNullOrWhiteSpace(currentUser.mdid))
{
input.mdid = currentUser.mdid;
}
}
var gwFilter = string.IsNullOrWhiteSpace(input.gw) ? null : input.gw.Trim();
var data = await _db.Queryable((u, o, p, r, m) => new JoinQueryInfos(
JoinType.Left, o.Id == SqlFunc.ToString(u.OrganizeId),
JoinType.Left, p.Id == SqlFunc.ToString(u.PositionId),
JoinType.Left, r.Id == SqlFunc.ToString(u.RoleId),
JoinType.Left, m.Id == u.Mdid))
.WhereIF(!string.IsNullOrEmpty(input.id), u => u.Id.Contains(input.id))
.WhereIF(!string.IsNullOrEmpty(input.account), u => u.Account.Contains(input.account))
.WhereIF(!string.IsNullOrEmpty(input.realName), u => u.RealName.Contains(input.realName))
.WhereIF(!string.IsNullOrEmpty(input.mobilePhone), u => u.MobilePhone.Contains(input.mobilePhone))
.WhereIF(!string.IsNullOrEmpty(input.mdid), u => u.Mdid == input.mdid)
.WhereIF(!string.IsNullOrEmpty(input.zw), u => u.Zw.Contains(input.zw))
.WhereIF(!string.IsNullOrEmpty(gwFilter), u => u.Gw == gwFilter)
.WhereIF(!string.IsNullOrEmpty(input.gwfl), u => u.Gwfl.Contains(input.gwfl))
.WhereIF(!string.IsNullOrEmpty(input.fyft), u => u.Fyft.Contains(input.fyft))
.WhereIF(!string.IsNullOrEmpty(input.organizeId), u => u.OrganizeId == input.organizeId)
.WhereIF(!string.IsNullOrEmpty(input.positionId), u => u.PositionId == input.positionId)
.WhereIF(!string.IsNullOrEmpty(input.roleId), u => u.RoleId == input.roleId)
.WhereIF(input.enabledMark.HasValue, u => u.EnabledMark == input.enabledMark)
.WhereIF(input.onlyOnJob == 1, u => SqlFunc.IsNull(u.IsOnJob, 1) == 1)
.Where(u => u.DeleteMark == null) // 排除已删除的用户
.WhereIF(monthStart.HasValue && monthLast.HasValue, u =>
u.EntryDate != null && u.EntryDate <= monthLast.Value &&
(u.LeaveDate == null || u.LeaveDate >= monthStart.Value))
.Select((u, o, p, r, m) => new UserListOutput
{
id = u.Id,
account = u.Account,
realName = u.RealName,
nickName = u.NickName,
headIcon = u.HeadIcon,
gender = u.Gender,
birthday = u.Birthday,
mobilePhone = u.MobilePhone,
telePhone = u.TelePhone,
email = u.Email,
urgentContacts = u.UrgentContacts,
urgentTelePhone = u.UrgentTelePhone,
postalAddress = u.PostalAddress,
signature = u.Signature,
firstLogTime = u.FirstLogTime,
prevLogTime = u.PrevLogTime,
isAdministrator = u.IsAdministrator,
description = u.Description,
sortCode = u.SortCode,
managerId = u.ManagerId,
organizeId = u.OrganizeId,
organizeName = o.FullName,
positionId = u.PositionId,
positionName = p.FullName,
roleId = u.RoleId,
roleName = r.FullName,
portalId = u.PortalId,
extensionStr = u.ExtensionStr,
openId = u.OpenId,
mdid = u.Mdid,
mdmc = m.Dm,
zw = u.Zw,
fyft = u.Fyft,
gwfl = u.Gwfl,
gw = u.Gw,
enabledMark = u.EnabledMark,
creatorTime = u.CreatorTime,
creatorUserId = u.CreatorUserId,
entryDate = u.EntryDate,
leaveDate = u.LeaveDate,
reportDate = u.ReportDate
})
.MergeTable()
.OrderBy(sidx + " " + input.sort)
.ToPagedListAsync(input.currentPage, input.pageSize);
return PageResult.SqlSugarPageResult(data);
}
#endregion
#region 获取用户详细信息
///
/// 获取用户详细信息(含档案扩展字段,敏感信息脱敏)
///
[HttpGet("{id}")]
public async Task GetUserInfo(string id)
{
var row = await _db.Queryable((u, o, p, r, m) => new JoinQueryInfos(
JoinType.Left, o.Id == SqlFunc.ToString(u.OrganizeId),
JoinType.Left, p.Id == SqlFunc.ToString(u.PositionId),
JoinType.Left, r.Id == SqlFunc.ToString(u.RoleId),
JoinType.Left, m.Id == u.Mdid))
.Where(u => u.Id == id && u.DeleteMark == null)
.Select((u, o, p, r, m) => new
{
user = u,
organizeName = o.FullName,
positionName = p.FullName,
roleName = r.FullName,
mdmc = m.Dm
})
.FirstAsync();
if (row?.user == null)
{
throw NCCException.Oh("用户不存在");
}
var profile = await _db.Queryable()
.Where(x => x.UserId == id)
.FirstAsync();
var output = MapEmployeeDetail(row.user, row.organizeName, row.positionName, row.roleName, row.mdmc, profile);
await EnrichEmployeeDetailAsync(output, row.user);
return output;
}
#endregion
#region 获取用户下拉选择数据
///
/// 获取用户下拉选择数据
///
/// 门店ID
/// 职位
/// 岗位
/// 是否仅在职:1=仅在职
[HttpGet("Selector")]
public async Task GetUserSelector([FromQuery] string mdid = null, [FromQuery] string zw = null, [FromQuery] string gw = null, [FromQuery] int? onlyOnJob = null)
{
var data = await _db.Queryable()
.WhereIF(!string.IsNullOrEmpty(mdid), u => u.Mdid == mdid)
.WhereIF(!string.IsNullOrEmpty(zw), u => u.Zw != null && u.Zw.Contains(zw))
.WhereIF(!string.IsNullOrEmpty(gw), u => u.Gw == gw)
.WhereIF(onlyOnJob == 1, u => SqlFunc.IsNull(u.IsOnJob, 1) == 1)
.Where(u => u.EnabledMark == 1 && u.DeleteMark == null)
.Select(u => new
{
id = u.Id,
account = u.Account,
realName = u.RealName,
mobilePhone = u.MobilePhone,
mdid = u.Mdid,
zw = u.Zw,
gw = u.Gw
})
.OrderBy(u => u.realName)
.ToListAsync();
return data;
}
#endregion
#region 获取总经理、经理下拉选择数据
///
/// 获取用户下拉选择数据
///
[HttpGet("ManagerSelector")]
public async Task GetManagerSelector()
{
var data = await _db.Queryable()
.Where(u => u.Gw == "总经理" || u.Gw == "经理")
.Where(u => u.EnabledMark == 1 && u.DeleteMark == null)
.Select(u => new
{
id = u.Id,
account = u.Account,
realName = u.RealName,
mobilePhone = u.MobilePhone,
mdid = u.Mdid,
zw = u.Zw,
gw = u.Gw
})
.OrderBy(u => u.realName)
.ToListAsync();
return data;
}
#endregion
#region 员工筛选选项
///
/// 获取员工列表筛选选项(岗位 / 组织 / 门店)
///
///
/// 供员工 App「员工信息」筛选使用:返回有效用户岗位去重列表、组织部门列表、开店门店列表。
///
/// 示例请求:
/// GET /api/Extend/User/FilterOptions
///
/// gwList、organizeList、storeList
/// 成功返回筛选选项
[HttpGet("FilterOptions")]
public async Task GetFilterOptions()
{
var gwList = await _db.Queryable()
.Where(u => u.DeleteMark == null && !string.IsNullOrEmpty(u.Gw))
.Select(u => u.Gw)
.Distinct()
.ToListAsync();
var organizeList = await _db.Queryable()
.Where(o => o.DeleteMark == null)
.OrderBy(o => o.SortCode)
.Select(o => new
{
id = o.Id,
fullName = o.FullName,
parentId = o.ParentId,
category = o.Category
})
.ToListAsync();
var storeList = await _db.Queryable()
.Where(it => it.Zxzt == "开店")
.Where(p => p.Status == null || p.Status != (int)StatusEnum.无效)
.OrderBy(it => it.Dm)
.Select(it => new
{
id = it.Id,
fullName = it.Dm
})
.ToListAsync();
return new
{
gwList = (gwList ?? new List())
.Where(x => !string.IsNullOrWhiteSpace(x))
.Select(x => x.Trim())
.Distinct()
.OrderBy(x => x)
.ToList(),
organizeList,
storeList
};
}
#endregion
private static UserEmployeeDetailOutput MapEmployeeDetail(
UserEntity user,
string organizeName,
string positionName,
string roleName,
string mdmc,
LqEmployeeProfileEntity profile)
{
var bankPlain = profile == null
? null
: EmployeeProfileSensitiveHelper.DecryptSensitive(profile.BankCardCipher);
var output = new UserEmployeeDetailOutput
{
id = user.Id,
account = user.Account,
realName = user.RealName,
nickName = user.NickName,
headIcon = user.HeadIcon,
gender = user.Gender,
birthday = user.Birthday,
mobilePhone = user.MobilePhone,
telePhone = user.TelePhone,
email = user.Email,
urgentContacts = user.UrgentContacts,
urgentTelePhone = user.UrgentTelePhone,
postalAddress = user.PostalAddress,
signature = user.Signature,
firstLogTime = user.FirstLogTime,
prevLogTime = user.PrevLogTime,
isAdministrator = user.IsAdministrator,
description = user.Description,
sortCode = user.SortCode,
managerId = user.ManagerId,
organizeId = user.OrganizeId,
organizeName = organizeName,
positionId = user.PositionId,
positionName = positionName,
roleId = user.RoleId,
roleName = roleName,
portalId = user.PortalId,
extensionStr = user.ExtensionStr,
openId = user.OpenId,
mdid = user.Mdid,
mdmc = mdmc,
zw = user.Zw,
fyft = user.Fyft,
gwfl = user.Gwfl,
gw = user.Gw,
enabledMark = user.EnabledMark,
creatorTime = user.CreatorTime,
creatorUserId = user.CreatorUserId,
entryDate = user.EntryDate,
leaveDate = user.LeaveDate,
reportDate = user.ReportDate,
nation = user.Nation,
nativePlace = user.NativePlace,
education = user.Education,
age = EmployeeProfileSensitiveHelper.CalcAgeFromIdCard(user.CertificatesNumber, user.Birthday),
tenureText = EmployeeProfileSensitiveHelper.CalcTenureText(user.EntryDate),
idCardNo = user.CertificatesNumber,
idCardNoMasked = user.CertificatesNumber,
bankCardNoMasked = EmployeeProfileSensitiveHelper.MaskBankCard(bankPlain)
};
if (profile == null)
{
return output;
}
output.maritalStatusName = profile.MaritalStatus.HasValue
? EnumHelper.GetEnumDesc(profile.MaritalStatus.Value) : null;
output.politicalStatusName = profile.PoliticalStatus.HasValue
? EnumHelper.GetEnumDesc(profile.PoliticalStatus.Value) : null;
output.householdTypeName = profile.HouseholdType.HasValue
? EnumHelper.GetEnumDesc(profile.HouseholdType.Value) : null;
output.currentAddress = profile.CurrentAddress;
output.idCardAddress = profile.IdCardAddress;
output.idCardFrontUrl = profile.IdCardFrontUrl;
output.idCardBackUrl = profile.IdCardBackUrl;
output.employeeNo = profile.EmployeeNo;
output.employeeTypeName = profile.EmployeeType.HasValue
? EnumHelper.GetEnumDesc(profile.EmployeeType.Value) : null;
output.employeeStatusName = profile.EmployeeStatus.HasValue
? EnumHelper.GetEnumDesc(profile.EmployeeStatus.Value) : null;
output.recruitmentTypeName = profile.RecruitmentType.HasValue
? EnumHelper.GetEnumDesc(profile.RecruitmentType.Value) : null;
output.regularizationDate = profile.RegularizationDate;
output.graduateSchool = profile.GraduateSchool;
output.enrollmentDate = profile.EnrollmentDate;
output.graduationDate = profile.GraduationDate;
output.major = profile.Major;
output.emergencyContactRelation = profile.EmergencyContactRelation;
output.emergencyContactAddress = profile.EmergencyContactAddress;
output.bankName = profile.BankName;
output.bankAccountName = profile.BankAccountName;
return output;
}
///
/// 解析字典项、直属上级等展示字段
///
private async Task EnrichEmployeeDetailAsync(UserEmployeeDetailOutput output, UserEntity user)
{
if (output == null || user == null)
{
return;
}
var dictIds = new[] { user.Nation, user.Education, user.CertificatesType }
.Where(x => !string.IsNullOrWhiteSpace(x))
.Select(x => x.Trim())
.Distinct()
.ToList();
var dictionaryNameDict = dictIds.Count == 0
? new Dictionary()
: (await _db.Queryable()
.Where(d => dictIds.Contains(d.Id))
.Select(d => new { d.Id, d.FullName })
.ToListAsync())
.GroupBy(x => x.Id)
.ToDictionary(g => g.Key, g => g.First().FullName ?? string.Empty);
output.nation = ResolveDictionaryDisplayName(user.Nation, dictionaryNameDict);
output.education = ResolveDictionaryDisplayName(user.Education, dictionaryNameDict);
if (!string.IsNullOrWhiteSpace(user.ManagerId))
{
output.managerName = await _db.Queryable()
.Where(u => u.Id == user.ManagerId && u.DeleteMark == null)
.Select(u => u.RealName)
.FirstAsync();
}
}
private static string ResolveDictionaryDisplayName(string value, Dictionary dictionaryNameDict)
{
if (string.IsNullOrWhiteSpace(value))
{
return null;
}
var key = value.Trim();
if (dictionaryNameDict.TryGetValue(key, out var name) && !string.IsNullOrWhiteSpace(name))
{
return name;
}
return key;
}
}
}