using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Globalization;
using System.Linq;
using System.Threading.Tasks;
using Mapster;
using Microsoft.AspNetCore.Mvc;
using NCC.ClayObject;
using NCC;
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.LqYcsdJsj;
using NCC.Extend.Entitys.Dto.LqJinsanjiaoUser;
using NCC.Extend.Entitys.Enum;
using NCC.Extend.Entitys.lq_jinsanjiao_user;
using NCC.Extend.Entitys.lq_hytk_jksyj;
using NCC.Extend.Entitys.lq_kd_jksyj;
using NCC.Extend.Entitys.lq_xh_jksyj;
using NCC.Extend.Entitys.lq_mdxx;
using NCC.Extend.Entitys.lq_ycsd_jsj;
using NCC.Extend.Helpers;
using NCC.Extend.Interfaces.BusinessOperationLog;
using NCC.Extend.Interfaces.LqYcsdJsj;
using NCC.System.Entitys.Permission;
using NCC.FriendlyException;
using NCC.JsonSerialization;
using Newtonsoft.Json;
using SqlSugar;
using Yitter.IdGenerator;
namespace NCC.Extend.LqYcsdJsj
{
///
/// 金三角设定服务
///
[ApiDescriptionSettings(Tag = "绿纤金三角服务", Name = "LqYcsdJsj", Order = 200)]
[Route("api/Extend/[controller]")]
public class LqYcsdJsjService : ILqYcsdJsjService, IDynamicApiController, ITransient
{
private readonly ISqlSugarRepository _lqYcsdJsjRepository;
private readonly SqlSugarScope _db;
private readonly IUserManager _userManager;
private readonly IBusinessOperationLogService _businessOperationLogService;
///
/// 初始化一个类型的新实例
///
public LqYcsdJsjService(
ISqlSugarRepository lqYcsdJsjRepository,
IUserManager userManager,
IBusinessOperationLogService businessOperationLogService)
{
_lqYcsdJsjRepository = lqYcsdJsjRepository;
_db = _lqYcsdJsjRepository.Context;
_userManager = userManager;
_businessOperationLogService = businessOperationLogService;
}
#region 获取金三角设定
///
/// 获取金三角设定
///
/// 参数
///
[HttpGet("{id}")]
public async Task GetInfo(string id)
{
var entity = await _db.Queryable().FirstAsync(p => p.Id == id);
var output = entity.Adapt();
return output;
}
#endregion
#region 获取金三角设定详情
///
/// 获取金三角设定详情(包含成员信息)
///
/// 金三角ID
///
[HttpGet("{id}/detail")]
public async Task GetDetail(string id)
{
var entity = await _db.Queryable().FirstAsync(p => p.Id == id);
if (entity == null)
throw NCCException.Oh(ErrorCode.COM1005);
var output = entity.Adapt();
// 获取成员信息
var members = await _db.Queryable()
.Where(x => x.JsjId == id && x.Status == "ACTIVE" && x.DeleteMark == 0)
.OrderBy(x => x.SortOrder)
.Select(x => new
{
id = x.Id,
userId = x.UserId,
userName = x.UserName,
isLeader = x.IsLeader,
sortOrder = x.SortOrder,
status = x.Status,
})
.ToListAsync();
var memberIds = members.Select(x => x.userId).Where(x => !string.IsNullOrEmpty(x)).ToList();
var hasMemberPerformance = await HasMemberMonthPerformanceAsync(memberIds, entity.Yf);
return new { jsj = output, members = members, hasMemberPerformance, storeEditable = !hasMemberPerformance };
}
#endregion
#region 获取金三角设定列表
///
/// 获取金三角设定列表
///
/// 请求参数
///
[HttpGet("")]
public async Task GetList([FromQuery] LqYcsdJsjListQueryInput input)
{
var sidx = input.sidx == null ? "id" : input.sidx;
var data = await _db.Queryable()
.WhereIF(!string.IsNullOrEmpty(input.id), p => p.Id.Contains(input.id))
.WhereIF(!string.IsNullOrEmpty(input.yf), p => p.Yf.Contains(input.yf))
.WhereIF(!string.IsNullOrEmpty(input.md), p => p.Md.Contains(input.md))
.WhereIF(!string.IsNullOrEmpty(input.jsj), p => p.Jsj.Contains(input.jsj))
.Select(it => new LqYcsdJsjListOutput
{
id = it.Id,
yf = it.Yf,
md = it.Md,
jsj = it.Jsj,
})
.MergeTable()
.OrderBy(sidx + " " + input.sort)
.ToPagedListAsync(input.currentPage, input.pageSize);
return PageResult.SqlSugarPageResult(data);
}
#endregion
#region 获取本月金三角列表
///
/// 获取本月金三角列表
///
/// 本月金三角列表
[HttpGet("Actions/GetThisMonthList")]
public async Task GetThisMonthList()
{
var data = await _db.Queryable()
.Where(x => x.Yf == DateTime.Now.ToString("yyyyMM"))
.Select(it => new LqYcsdJsjListOutput
{
id = it.Id,
yf = it.Yf,
md = it.Md,
jsj = it.Jsj,
})
.MergeTable()
.ToListAsync();
return data;
}
#endregion
#region 获取用户本月金三角信息
///
/// 获取某个用户本月所在的金三角信息
///
/// 用户ID
/// 用户本月所在的金三角信息
[HttpGet("Actions/GetThisMonthJsjInfo")]
public async Task GetThisMonthJsjInfo([FromQuery] string userId)
{
if (string.IsNullOrEmpty(userId))
{
throw NCCException.Oh(ErrorCode.COM1001, "用户ID不能为空");
}
var currentMonth = DateTime.Now.ToString("yyyyMM");
// 先查询用户的金三角关联信息
var jsjUser = await _db.Queryable().Where(x => x.UserId == userId && x.DeleteMark == 0).FirstAsync();
if (jsjUser == null)
{
return null;
}
// 查询金三角信息
var jsj = await _db.Queryable().Where(x => x.Id == jsjUser.JsjId && x.Yf == currentMonth).FirstAsync();
if (jsj == null)
{
return null;
}
// 查询门店信息
var store = await _db.Queryable().Where(x => x.Id == jsj.Md).FirstAsync();
return new LqYcsdJsjByUserMonthOutput
{
jsjId = jsj.Id,
jsjName = jsj.Jsj,
month = jsj.Yf,
storeId = jsj.Md,
storeName = store?.Dm,
userId = jsjUser.UserId,
userName = jsjUser.UserName,
isLeader = jsjUser.IsLeader,
status = jsjUser.Status,
sortOrder = jsjUser.SortOrder,
};
}
#endregion
#region 根据用户和月份获取金三角信息
///
/// 根据用户和时间获取金三角信息
///
///
/// 根据指定的用户ID和时间,从时间中提取月份,查询该用户在该月份的金三角信息。
///
/// 示例请求:
/// GET /api/Extend/LqYcsdJsj/GetJsjInfoByUserMonth?userId=123456&dateTime=2024-12-15%2014:30:00
///
/// 参数说明:
/// - userId: 用户ID,必填
/// - dateTime: 时间,格式为yyyy-MM-dd HH:mm:ss,必填
///
/// 返回信息包括:
/// - 金三角基本信息(ID、名称、月份)
/// - 门店信息(ID、名称)
/// - 用户信息(ID、姓名、是否顾问、状态、排序)
///
/// 查询参数
/// 金三角信息
/// 查询成功
/// 参数错误
/// 未找到相关数据
[HttpGet("GetJsjInfoByUserMonth")]
public async Task GetJsjInfoByUserMonth([FromQuery] LqYcsdJsjByUserMonthInput input)
{
if (string.IsNullOrEmpty(input.UserId))
{
throw NCCException.Oh(ErrorCode.COM1001, "用户ID不能为空");
}
if (input.DateTime == default(DateTime))
{
throw NCCException.Oh(ErrorCode.COM1001, "时间不能为空");
}
// 从时间中提取月份(格式:yyyyMM)
var month = input.DateTime.ToString("yyyyMM");
// 与 GoldTriangleBindingHelper 一致:ACTIVE 优先,同月多条取 F_CreatorTime 最新
var jsjId = await GoldTriangleBindingHelper.GetJsjIdAsync(_db, input.UserId.Trim(), input.DateTime);
if (string.IsNullOrEmpty(jsjId))
{
return null;
}
var jsjUserCandidates = await _db.Queryable()
.Where(x => x.UserId == input.UserId && x.DeleteMark == 0 && x.Month == month && x.JsjId == jsjId)
.OrderBy(x => x.CreatorTime, OrderByType.Desc)
.ToListAsync();
var jsjUser = jsjUserCandidates.FirstOrDefault(x => x.Status == "ACTIVE") ?? jsjUserCandidates.FirstOrDefault();
if (jsjUser == null)
{
return null;
}
// 查询金三角信息
var jsj = await _db.Queryable().Where(x => x.Id == jsjId && x.Yf == month).FirstAsync();
if (jsj == null)
{
return null;
}
// 查询门店信息
var store = await _db.Queryable().Where(x => x.Id == jsj.Md).FirstAsync();
return new LqYcsdJsjByUserMonthOutput
{
jsjId = jsj.Id,
jsjName = jsj.Jsj,
month = jsj.Yf,
storeId = jsj.Md,
storeName = store?.Dm,
userId = jsjUser.UserId,
userName = jsjUser.UserName,
isLeader = jsjUser.IsLeader,
status = jsjUser.Status,
sortOrder = jsjUser.SortOrder,
};
}
#endregion
#region 标记删除用户金三角关联信息
///
/// 标记删除用户金三角关联信息
///
///
/// 根据金三角用户关系ID,将绑定关系的删除标记设置为已删除
///
/// 示例请求:
/// ```json
/// {
/// "id": "关系ID"
/// }
/// ```
///
/// 参数
///
/// 成功删除
/// 参数错误
/// 服务器错误
[HttpPost("Actions/DeleteJsjUserRelation")]
public async Task DeleteJsjUserRelation([FromBody] LqJinsanjiaoUserDeleteInput input)
{
if (string.IsNullOrEmpty(input.Id))
throw NCCException.Oh(ErrorCode.COM1000, "ID不能为空");
var relation = await _db.Queryable()
.FirstAsync(x => x.Id == input.Id && x.DeleteMark == 0);
if (relation == null)
throw NCCException.Oh(ErrorCode.COM1000, "未找到要删除的记录");
await EnsureStorePcJsjEditableAsync(relation.JsjId);
var isOk = await _db.Updateable()
.SetColumns(x => new LqJinsanjiaoUserEntity
{
DeleteMark = 1,
Status = "INACTIVE"
})
.Where(x => x.Id == input.Id && x.DeleteMark == 0)
.ExecuteCommandAsync();
if (!(isOk > 0))
throw NCCException.Oh(ErrorCode.COM1000, "未找到要删除的记录");
await TryWriteBusinessLogAsync(
"金三角设定",
"删除金三角成员",
"lq_jinsanjiao_user",
input.Id,
$"删除金三角成员关联(关系ID:{input.Id})",
JsonConvert.SerializeObject(new { before = new { relation.Id, relation.JsjId, relation.UserId, relation.UserName } }));
}
#endregion
#region 新建金三角
///
/// 新建金三角
///
/// 参数
///
[HttpPost("")]
public async Task Create([FromBody] LqYcsdJsjCrInput input)
{
var userInfo = await _userManager.GetUserInfo();
// 参数验证
if (string.IsNullOrEmpty(input.yf))
throw NCCException.Oh(ErrorCode.COM1000, "月份不能为空");
if (string.IsNullOrEmpty(input.md))
throw NCCException.Oh(ErrorCode.COM1000, "门店不能为空");
if (string.IsNullOrEmpty(input.jsj))
throw NCCException.Oh(ErrorCode.COM1000, "金三角名称不能为空");
// 验证月份格式
if (!DateTime.TryParseExact(input.yf, "yyyyMM", null, DateTimeStyles.None, out _))
{
throw NCCException.Oh(ErrorCode.COM1000, "月份格式必须为yyyyMM");
}
// 验证多人战队必须有顾问
if (input.members != null && input.members.Count >= 2)
{
var hasLeader = input.members.Any(m => m.isLeader == 1);
if (!hasLeader)
{
throw NCCException.Oh(ErrorCode.COM1000, "两人或两人以上的战队必须有一个顾问");
}
}
// 验证成员 UserID 不能为空
if (input.members != null && input.members.Count > 0)
{
foreach (var member in input.members)
{
if (string.IsNullOrEmpty(member.userId))
{
throw NCCException.Oh(ErrorCode.COM1000, $"成员【{member.userName}】的 UserID 不能为空");
}
}
}
// 验证金三角名称是否已存在
var existingJsj = await _db.Queryable().Where(x => x.Yf == input.yf && x.Md == input.md && x.Jsj == input.jsj).FirstAsync();
if (existingJsj != null)
{
throw NCCException.Oh(ErrorCode.COM1000, "该门店该月份已存在同名金三角");
}
try
{
// 开启事务
_db.BeginTran();
// 1. 创建金三角基础信息
var entity = input.Adapt();
entity.Id = YitIdHelper.NextId().ToString();
var isOk = await _db.Insertable(entity).IgnoreColumns(ignoreNullColumn: true).ExecuteCommandAsync();
if (!(isOk > 0))
throw NCCException.Oh(ErrorCode.COM1000);
// 2 创建金三角成员绑定关系
if (input.members != null && input.members.Count > 0)
{
await CreateJsjMembers(entity.Id, input.members, userInfo.userId, input.yf);
}
// 提交事务
_db.CommitTran();
await TryWriteBusinessLogAsync(
"金三角设定",
"新增金三角",
"lq_ycsd_jsj",
entity.Id,
$"新增金三角:{input.jsj}(月份={input.yf},门店={input.md})",
JsonConvert.SerializeObject(new { after = new { entity.Id, input.yf, input.md, input.jsj, memberCount = input.members?.Count ?? 0 } }));
}
catch (Exception ex)
{
// 回滚事务
_db.RollbackTran();
throw NCCException.Oh(ErrorCode.COM1000, ex.Message);
}
}
#endregion
#region 给金三角添加用户绑定关系
///
/// 给金三角添加用户绑定关系
///
///
/// 将用户添加到指定的金三角中,建立绑定关系。
///
/// 示例请求:
/// ```json
/// {
/// "jsjId": "金三角ID",
/// "userId": "用户ID",
/// "userName": "用户姓名",
/// "isLeader": 0,
/// "status": "ACTIVE",
/// "sortOrder": 1
/// }
/// ```
///
/// 参数说明:
/// - jsjId: 金三角ID,必填
/// - userId: 用户ID,必填
/// - userName: 用户姓名,必填
/// - isLeader: 是否顾问(0-否,1-是),默认0
/// - status: 状态(ACTIVE-活跃,INACTIVE-非活跃),默认ACTIVE
/// - sortOrder: 排序号,如果不填则自动设置为最大排序号+1
///
/// 业务规则:
/// 1. 金三角必须存在
/// 2. 用户必须存在
/// 3. 用户不能在同一个月份的其他金三角中(如果已存在绑定关系,需要先解除)
/// 4. 用户不能重复添加到当前金三角
/// 5. 如果多人战队(2人及以上),必须至少有一个顾问
///
/// 添加用户绑定关系的参数
/// 绑定关系ID
/// 添加成功
/// 参数错误或业务规则验证失败
/// 金三角或用户不存在
/// 服务器错误
[HttpPost("Actions/AddUserToJsj")]
public async Task AddUserToJsj([FromBody] LqJinsanjiaoUserCrInput input)
{
var userInfo = await _userManager.GetUserInfo();
// 1. 参数验证
if (string.IsNullOrEmpty(input.jsjId))
throw NCCException.Oh("金三角ID不能为空");
if (string.IsNullOrEmpty(input.userId))
throw NCCException.Oh("用户ID不能为空(请确保选择了有效的系统用户)");
if (string.IsNullOrEmpty(input.userName))
throw NCCException.Oh("用户姓名不能为空");
// 2. 验证金三角是否存在
var jsj = await _db.Queryable().Where(x => x.Id == input.jsjId).FirstAsync();
if (jsj == null)
throw NCCException.Oh("金三角不存在");
await EnsureStorePcJsjEditableAsync(jsj);
// 4. 验证用户是否已经在同一个月份的其他金三角中(幽灵绑定全部作废;有效战队则拦截)
var otherActiveBindings = await _db.Queryable()
.Where(x => x.UserId == input.userId && x.JsjId != input.jsjId && x.Month == jsj.Yf && x.DeleteMark == 0 && x.Status == "ACTIVE")
.ToListAsync();
if (otherActiveBindings.Count > 0)
{
var otherJsjIds = otherActiveBindings.Select(x => x.JsjId).Distinct().ToList();
var existingJsjList = await _db.Queryable()
.Where(x => otherJsjIds.Contains(x.Id))
.ToListAsync();
var existingJsjMap = existingJsjList.ToDictionary(x => x.Id, x => x);
var orphanBindingIds = otherActiveBindings
.Where(x => !existingJsjMap.ContainsKey(x.JsjId))
.Select(x => x.Id)
.ToList();
if (orphanBindingIds.Count > 0)
{
await SoftDeleteBindingsByIdsAsync(orphanBindingIds);
}
var validOther = otherActiveBindings.FirstOrDefault(x => existingJsjMap.ContainsKey(x.JsjId));
if (validOther != null)
{
throw NCCException.Oh($"该用户已在{existingJsjMap[validOther.JsjId].Jsj}金三角中,请先解除绑定关系");
}
}
// 5. 验证用户是否已经在当前金三角中
var currentRelation = await _db.Queryable().Where(x => x.UserId == input.userId && x.JsjId == input.jsjId && x.DeleteMark == 0).FirstAsync();
if (currentRelation != null)
{
// 如果已存在但已删除或非活跃,则恢复;否则提示已存在
if (currentRelation.DeleteMark == 0 && currentRelation.Status == "ACTIVE")
{
throw NCCException.Oh(ErrorCode.COM1000, "该用户已在该金三角中");
}
else
{
// 恢复已删除或非活跃的关系
currentRelation.Status = input.status ?? "ACTIVE";
currentRelation.IsLeader = input.isLeader;
currentRelation.UserName = input.userName;
currentRelation.DeleteMark = 0;
currentRelation.LastModifyTime = DateTime.Now;
currentRelation.LastModifyUserId = userInfo.userId;
// 如果指定了排序号,更新排序号
if (input.sortOrder > 0)
{
currentRelation.SortOrder = input.sortOrder;
}
await _db.Updateable(currentRelation).ExecuteCommandAsync();
await RemapUserMonthPerformanceToJsjAsync(new List { input.userId }, jsj.Yf, input.jsjId);
return new { id = currentRelation.Id, message = "已恢复用户绑定关系" };
}
}
// 6. 获取当前金三角的成员数量(用于验证多人战队必须有顾问)
var memberCount = await _db.Queryable()
.Where(x => x.JsjId == input.jsjId
&& x.DeleteMark == 0
&& x.Status == "ACTIVE")
.CountAsync();
// 如果添加后成员数量>=2,且当前用户不是顾问,则需要验证是否已有顾问
if (memberCount + 1 >= 2 && input.isLeader == 0)
{
var hasLeader = await _db.Queryable().Where(x => x.JsjId == input.jsjId && x.DeleteMark == 0 && x.Status == "ACTIVE" && x.IsLeader == 1).CountAsync() > 0;
if (!hasLeader)
{
throw NCCException.Oh("两人或两人以上的战队必须有一个顾问");
}
}
// 7. 自动计算排序号(如果没有指定)
int sortOrder = input.sortOrder;
if (sortOrder <= 0)
{
var maxSortOrder = await _db.Queryable().Where(x => x.JsjId == input.jsjId && x.DeleteMark == 0).MaxAsync(x => (int?)x.SortOrder);
sortOrder = maxSortOrder.HasValue ? maxSortOrder.Value + 1 : 1;
}
try
{
// 开启事务
_db.BeginTran();
// 8. 创建用户绑定关系
var memberEntity = new LqJinsanjiaoUserEntity
{
Id = YitIdHelper.NextId().ToString(),
JsjId = input.jsjId,
UserId = input.userId,
UserName = input.userName,
IsLeader = input.isLeader,
Status = input.status ?? "ACTIVE",
SortOrder = sortOrder,
CreatorTime = DateTime.Now,
CreatorUserId = userInfo.userId,
DeleteMark = 0,
Month = jsj.Yf, // 使用金三角的月份
};
var isOk = await _db.Insertable(memberEntity).ExecuteCommandAsync();
if (!(isOk > 0))
throw NCCException.Oh("添加用户绑定关系失败");
await RemapUserMonthPerformanceToJsjAsync(new List { input.userId }, jsj.Yf, input.jsjId);
// 提交事务
_db.CommitTran();
return new { id = memberEntity.Id, message = "添加成功" };
}
catch (Exception ex)
{
// 回滚事务
_db.RollbackTran();
throw NCCException.Oh(ErrorCode.COM1000, ex.Message);
}
}
#endregion
#region 获取金三角设定无分页列表
///
/// 获取金三角设定无分页列表
///
/// 请求参数
///
[NonAction]
public async Task GetNoPagingList([FromQuery] LqYcsdJsjListQueryInput input)
{
var sidx = input.sidx == null ? "id" : input.sidx;
var data = await _db.Queryable()
.WhereIF(!string.IsNullOrEmpty(input.id), p => p.Id.Contains(input.id))
.WhereIF(!string.IsNullOrEmpty(input.yf), p => p.Yf.Contains(input.yf))
.WhereIF(!string.IsNullOrEmpty(input.md), p => p.Md.Contains(input.md))
.WhereIF(!string.IsNullOrEmpty(input.jsj), p => p.Jsj.Contains(input.jsj))
.Select(it => new LqYcsdJsjListOutput
{
id = it.Id,
yf = it.Yf,
md = it.Md,
jsj = it.Jsj,
})
.MergeTable()
.OrderBy(sidx + " " + input.sort)
.ToListAsync();
return data;
}
#endregion
#region 导出金三角设定
///
/// 导出金三角设定
///
/// 请求参数
///
[HttpGet("Actions/Export")]
public async Task Export([FromQuery] LqYcsdJsjListQueryInput input)
{
var userInfo = await _userManager.GetUserInfo();
var exportData = new List();
if (input.dataType == 0)
{
var data = Clay.Object(await this.GetList(input));
exportData = data.Solidify>().list;
}
else
{
exportData = await this.GetNoPagingList(input);
}
List paramList =
"[{\"value\":\"主键\",\"field\":\"id\"},{\"value\":\"月份\",\"field\":\"yf\"},{\"value\":\"门店\",\"field\":\"md\"},{\"value\":\"金三角\",\"field\":\"jsj\"}]".ToList();
ExcelConfig excelconfig = new ExcelConfig();
excelconfig.FileName = "金三角设定.xls";
excelconfig.HeadFont = "微软雅黑";
excelconfig.HeadPoint = 10;
excelconfig.IsAllSizeColumn = true;
excelconfig.ColumnModel = new List();
List selectKeyList = 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);
await TryWriteBusinessLogAsync(
"金三角设定",
"导出金三角设定",
"lq_ycsd_jsj",
null,
$"导出金三角设定,共 {exportData.Count} 条",
JsonConvert.SerializeObject(new
{
filters = new { input.yf, input.md, input.jsj, input.dataType },
rowCount = exportData.Count,
fileName = excelconfig.FileName
}));
var fileName = _userManager.UserId + "|" + addPath + "|xls";
var output = new { name = excelconfig.FileName, url = "/api/File/Download?encryption=" + DESCEncryption.Encrypt(fileName, "NCC") };
return output;
}
#endregion
#region 批量删除金三角设定
///
/// 批量删除金三角设定
///
/// 主键数组
///
[HttpPost("batchRemove")]
public async Task BatchRemove([FromBody] List ids)
{
var entitys = await _db.Queryable().In(it => it.Id, ids).ToListAsync();
if (entitys.Count > 0)
{
try
{
_db.BeginTran();
// 先软删成员绑定,避免留下「主表已删、绑定仍 ACTIVE」的幽灵战队
await SoftDeleteBindingsByJsjIdsAsync(ids);
await _db.Deleteable().In(d => d.Id, ids).ExecuteCommandAsync();
_db.CommitTran();
foreach (var item in entitys)
{
await TryWriteBusinessLogAsync(
"金三角设定",
"批量删除金三角",
"lq_ycsd_jsj",
item.Id,
$"批量删除金三角:{item.Jsj}(ID:{item.Id})",
JsonConvert.SerializeObject(new { before = new { item.Id, item.Yf, item.Md, item.Jsj } }));
}
}
catch (Exception)
{
_db.RollbackTran();
throw NCCException.Oh(ErrorCode.COM1002);
}
}
}
#endregion
#region 更新金三角设定
///
/// 更新金三角设定
///
/// 主键
/// 参数
///
[HttpPut("{id}")]
public async Task Update(string id, [FromBody] LqYcsdJsjUpInput input)
{
await EnsureStorePcJsjEditableAsync(id);
var before = await _db.Queryable().FirstAsync(p => p.Id == id);
_ = before ?? throw NCCException.Oh(ErrorCode.COM1005);
var entity = input.Adapt();
var isOk = await _db.Updateable(entity).IgnoreColumns(ignoreAllNullColumns: true).ExecuteCommandAsync();
if (!(isOk > 0))
throw NCCException.Oh(ErrorCode.COM1001);
await TryWriteBusinessLogAsync(
"金三角设定",
"修改金三角",
"lq_ycsd_jsj",
id,
$"修改金三角:{before.Jsj}(ID:{id})",
JsonConvert.SerializeObject(new
{
before = new { before.Id, before.Yf, before.Md, before.Jsj },
after = new { entity.Yf, entity.Md, entity.Jsj }
}));
}
#endregion
#region 删除金三角设定
///
/// 删除金三角设定
///
///
[HttpDelete("{id}")]
public async Task Delete(string id)
{
var entity = await _db.Queryable().FirstAsync(p => p.Id == id);
_ = entity ?? throw NCCException.Oh(ErrorCode.COM1005);
await EnsureStorePcJsjEditableAsync(entity);
try
{
_db.BeginTran();
await SoftDeleteBindingsByJsjIdsAsync(new List { id });
var isOk = await _db.Deleteable().Where(d => d.Id == id).ExecuteCommandAsync();
if (!(isOk > 0))
throw NCCException.Oh(ErrorCode.COM1002);
_db.CommitTran();
}
catch
{
_db.RollbackTran();
throw;
}
await TryWriteBusinessLogAsync(
"金三角设定",
"删除金三角",
"lq_ycsd_jsj",
id,
$"删除金三角:{entity.Jsj}(ID:{id})",
JsonConvert.SerializeObject(new { before = new { entity.Id, entity.Yf, entity.Md, entity.Jsj } }));
}
#endregion
#region 金三角月度业绩统计
///
/// 获取金三角月度业绩统计
///
/// 月份(格式:yyyyMM),为空则查询所有月份
/// 金三角ID,为空则查询所有金三角
/// 门店ID,为空则查询所有门店
/// 金三角月度业绩统计列表
[HttpGet("Actions/GetMonthlyPerformance")]
public async Task GetMonthlyPerformance([FromQuery] string month = null, [FromQuery] string jsjId = null, [FromQuery] string storeId = null)
{
var query = _db.Queryable()
.LeftJoin((jsj, jksyj) => jsj.Id == jksyj.Jsj_id)
.LeftJoin((jsj, jksyj, md) => jsj.Md == md.Id)
.Where((jsj, jksyj, md) => jsj.Yf != null)
.Where((jsj, jksyj, md) => jksyj.Yjsj != null)
.Where((jsj, jksyj, md) => jksyj.Jksyj != null && jksyj.Jksyj != "" && jksyj.Jksyj != "0")
.WhereIF(!string.IsNullOrEmpty(month), (jsj, jksyj, md) => jsj.Yf == month)
.WhereIF(!string.IsNullOrEmpty(jsjId), (jsj, jksyj, md) => jsj.Id == jsjId)
.WhereIF(!string.IsNullOrEmpty(storeId), (jsj, jksyj, md) => jsj.Md == storeId)
.GroupBy(
(jsj, jksyj, md) =>
new
{
jsj.Id,
jsj.Jsj,
jsj.Yf,
jsj.Md,
md.Dm,
}
)
.Select(
(jsj, jksyj, md) =>
new
{
jsjId = jsj.Id,
jsjName = jsj.Jsj,
month = jsj.Yf,
storeId = jsj.Md,
storeName = md.Dm,
totalPerformance = SqlFunc.AggregateSum(SqlFunc.ToDecimal(jksyj.Jksyj)),
orderCount = SqlFunc.AggregateCount(jksyj.Id),
avgPerformance = SqlFunc.AggregateAvg(SqlFunc.ToDecimal(jksyj.Jksyj)),
lastOrderDate = SqlFunc.AggregateMax(jksyj.Yjsj),
firstOrderDate = SqlFunc.AggregateMin(jksyj.Yjsj),
}
)
.OrderBy(jsj => jsj.month, OrderByType.Desc)
.OrderBy(jsj => jsj.totalPerformance, OrderByType.Desc);
var result = await query.ToListAsync();
return result;
}
///
/// 获取金三角月度业绩排名
///
/// 月份(格式:yyyyMM)
/// 排名数量,默认10
/// 金三角月度业绩排名列表
[HttpGet("Actions/GetMonthlyPerformanceRanking")]
public async Task GetMonthlyPerformanceRanking([FromQuery] string month, [FromQuery] int topCount = 10)
{
if (string.IsNullOrEmpty(month))
{
throw NCCException.Oh(ErrorCode.COM1001, "月份参数不能为空");
}
var query = _db.Queryable()
.LeftJoin((jsj, jksyj) => jsj.Id == jksyj.Jsj_id)
.LeftJoin((jsj, jksyj, md) => jsj.Md == md.Id)
.Where((jsj, jksyj, md) => jsj.Yf == month)
.Where((jsj, jksyj, md) => jksyj.Yjsj != null)
.Where((jsj, jksyj, md) => jksyj.Jksyj != null && jksyj.Jksyj != "" && jksyj.Jksyj != "0")
.GroupBy(
(jsj, jksyj, md) =>
new
{
jsj.Id,
jsj.Jsj,
jsj.Yf,
jsj.Md,
md.Dm,
}
)
.Select(
(jsj, jksyj, md) =>
new
{
jsjId = jsj.Id,
jsjName = jsj.Jsj,
month = jsj.Yf,
storeId = jsj.Md,
storeName = md.Dm,
totalPerformance = SqlFunc.AggregateSum(SqlFunc.ToDecimal(jksyj.Jksyj)),
orderCount = SqlFunc.AggregateCount(jksyj.Id),
ranking = 0, // 排名将在后续计算
}
)
.OrderBy(jsj => jsj.totalPerformance, OrderByType.Desc)
.Take(topCount);
var result = await query.ToListAsync();
// 创建包含排名的结果
var rankedResult = result
.Select(
(item, index) =>
new
{
item.jsjId,
item.jsjName,
item.month,
item.storeId,
item.storeName,
item.totalPerformance,
item.orderCount,
ranking = index + 1,
}
)
.ToList();
return rankedResult;
}
///
/// 获取当前登录用户所在战队的业绩与提成档位
///
///
/// 供移动端/门店端展示「我的战队」开单与消耗业绩、成员占比及距下一提成档差额。
///
/// 示例请求:
/// GET /api/Extend/LqYcsdJsj/Actions/GetMyTeamPerformance?month=202607
///
/// 参数说明:
/// - month: 月份,格式 yyyyMM;为空则默认当月
///
/// 返回说明:
/// - hasTeam=false 时仅返回 month、gapHint(本月未绑定金三角),不抛异常
/// - 提成档位与算薪 GetTeamCommissionPoint 一致,按队开单业绩合计计算
/// - 单人战队档位按当月已过天数折算日均门槛
///
/// 查询参数
/// 我的战队业绩
/// 查询成功(含未绑定战队的空态)
/// 当前用户无效
/// 服务器内部错误
[HttpGet("Actions/GetMyTeamPerformance")]
public async Task GetMyTeamPerformance([FromQuery] LqYcsdJsjMyTeamPerformanceQueryInput input)
{
var userId = _userManager.UserId;
if (string.IsNullOrEmpty(userId))
{
throw NCCException.Oh(ErrorCode.COM1001, "当前用户无效");
}
var month = string.IsNullOrWhiteSpace(input?.month)
? DateTime.Now.ToString("yyyyMM")
: input.month.Trim();
var emptyOutput = new LqYcsdJsjMyTeamPerformanceOutput
{
hasTeam = false,
month = month,
gapHint = "本月未绑定金三角",
};
// 与 GetJsjInfoByUserMonth 一致:跳过战队主表已删的幽灵绑定,ACTIVE + 最新创建优先
var jsjId = await GoldTriangleBindingHelper.GetJsjIdByMonthAsync(_db, userId, month);
if (string.IsNullOrEmpty(jsjId))
{
return emptyOutput;
}
var jsjUserCandidates = await _db.Queryable()
.Where(x => x.UserId == userId && x.Month == month && x.DeleteMark == 0 && x.JsjId == jsjId)
.OrderBy(x => x.CreatorTime, OrderByType.Desc)
.ToListAsync();
var jsjUser = jsjUserCandidates.FirstOrDefault(x => x.Status == "ACTIVE") ?? jsjUserCandidates.FirstOrDefault();
if (jsjUser == null)
{
return emptyOutput;
}
var jsj = await _db.Queryable()
.Where(x => x.Id == jsjId && x.Yf == month)
.FirstAsync();
if (jsj == null)
{
return emptyOutput;
}
var members = await _db.Queryable()
.Where(x => x.JsjId == jsj.Id && x.DeleteMark == 0 && x.Status == "ACTIVE")
.OrderBy(x => x.SortOrder)
.ToListAsync();
if (members.Count == 0)
{
return emptyOutput;
}
var storeName = await GetStoreNameById(jsj.Md);
var memberUserIds = members.Select(x => x.UserId).Where(x => !string.IsNullOrEmpty(x)).Distinct().ToList();
var memberPerformance = await AggregateJsjMemberPerformanceAsync(jsj.Id, month, memberUserIds);
var memberOutputs = members.Select(member =>
{
memberPerformance.TryGetValue(member.UserId, out var perf);
return new LqYcsdJsjMyTeamPerformanceMemberOutput
{
userId = member.UserId,
userName = member.UserName,
isLeader = member.IsLeader,
billingAmount = perf.billing,
consumeAmount = perf.consume,
};
}).ToList();
var teamBillingAmount = memberOutputs.Sum(x => x.billingAmount);
var teamConsumeAmount = memberOutputs.Sum(x => x.consumeAmount);
foreach (var memberOutput in memberOutputs)
{
memberOutput.billingRatio = teamBillingAmount > 0
? Math.Round(memberOutput.billingAmount * 100m / teamBillingAmount, 2, MidpointRounding.AwayFromZero)
: 0;
}
if (!DateTime.TryParseExact(month, "yyyyMM", CultureInfo.InvariantCulture, DateTimeStyles.None, out var monthDate))
{
throw NCCException.Oh(ErrorCode.COM1000, "月份格式必须为yyyyMM");
}
var daysInMonth = DateTime.DaysInMonth(monthDate.Year, monthDate.Month);
var workingDays = HealthCoachTeamCommissionHelper.ResolveElapsedWorkingDays(month);
var tierResult = HealthCoachTeamCommissionHelper.Calculate(
members.Count,
teamBillingAmount,
daysInMonth,
workingDays);
return new LqYcsdJsjMyTeamPerformanceOutput
{
hasTeam = true,
jsjId = jsj.Id,
jsjName = jsj.Jsj,
month = month,
storeId = jsj.Md,
storeName = storeName,
memberCount = members.Count,
teamBillingAmount = teamBillingAmount,
teamConsumeAmount = teamConsumeAmount,
currentCommissionRate = tierResult.CurrentRate,
currentCommissionRateText = tierResult.CurrentRateText,
nextTierThreshold = tierResult.NextThreshold,
gapToNextTier = tierResult.GapToNextTier,
isMaxTier = tierResult.IsMaxTier,
gapHint = tierResult.GapHint,
members = memberOutputs,
};
}
#endregion
#region 私有辅助方法
///
/// 创建或更新门店T区
///
/// 月份
/// 门店ID
/// 创建人ID
///
private async Task CreateOrUpdateStoreTArea(string yf, string mdId, string creatorUserId)
{
// 获取门店名称
var storeName = await GetStoreNameById(mdId);
var tAreaName = $"{storeName}T区";
// 检查该门店该月份是否已有T区
var existingTArea = await _db.Queryable().Where(x => x.Yf == yf && x.Md == mdId && x.Jsj == tAreaName).FirstAsync();
if (existingTArea == null)
{
// 创建门店T区
var tAreaEntity = new LqYcsdJsjEntity
{
Id = YitIdHelper.NextId().ToString(),
Yf = yf,
Md = mdId,
Jsj = tAreaName,
};
await _db.Insertable(tAreaEntity).ExecuteCommandAsync();
}
}
///
/// 创建或更新战队T区
///
/// 月份
/// 战队名称
/// 门店ID
/// 创建人ID
///
private async Task CreateOrUpdateTeamTArea(string yf, string teamName, string mdId, string creatorUserId)
{
var tAreaName = $"{teamName}T区";
// 检查该战队该月份是否已有T区
var existingTArea = await _db.Queryable().Where(x => x.Yf == yf && x.Md == mdId && x.Jsj == tAreaName).FirstAsync();
if (existingTArea == null)
{
// 创建战队T区
var tAreaEntity = new LqYcsdJsjEntity
{
Id = YitIdHelper.NextId().ToString(),
Yf = yf,
Md = mdId,
Jsj = tAreaName,
};
await _db.Insertable(tAreaEntity).ExecuteCommandAsync();
}
}
///
/// 创建金三角成员绑定关系
///
/// 金三角ID
/// 成员列表
/// 创建人ID
/// 月份(格式:yyyyMM)
///
private async Task CreateJsjMembers(string jsjId, List members, string creatorUserId, string yf)
{
var memberEntities = new List();
var userIds = members
.Select(x => x.userId)
.Where(x => !string.IsNullOrWhiteSpace(x))
.Distinct()
.ToList();
// 同月一人一队:新建战队写入成员前,作废这些人当月其它未删绑定(含幽灵绑定)
if (userIds.Count > 0)
{
await SoftDeleteUserMonthBindingsAsync(userIds, yf, exceptJsjId: null);
}
for (int i = 0; i < members.Count; i++)
{
var member = members[i];
var memberEntity = new NCC.Extend.Entitys.lq_jinsanjiao_user.LqJinsanjiaoUserEntity
{
Id = YitIdHelper.NextId().ToString(),
JsjId = jsjId,
UserId = member.userId,
UserName = member.userName,
IsLeader = member.isLeader,
Status = "ACTIVE",
SortOrder = member.sortOrder > 0 ? member.sortOrder : i + 1,
CreatorTime = DateTime.Now,
CreatorUserId = creatorUserId,
DeleteMark = 0,
Month = yf,
};
memberEntities.Add(memberEntity);
}
if (memberEntities.Count > 0)
{
await _db.Insertable(memberEntities).ExecuteCommandAsync();
}
// 将成员当月开单/耗卡上的空值或幽灵 jsj_id 纠正到新战队,避免战队业绩漏算
if (userIds.Count > 0)
{
await RemapUserMonthPerformanceToJsjAsync(userIds, yf, jsjId);
}
}
///
/// 根据门店ID获取门店名称
///
/// 门店ID
///
private async Task GetStoreNameById(string mdId)
{
try
{
var storeName = await _db.Queryable().Where(x => x.Id == mdId).Select(x => x.Dm).FirstAsync();
return string.IsNullOrEmpty(storeName) ? "未知门店" : storeName;
}
catch
{
return "未知门店";
}
}
///
/// 是否为门店 PC 端请求(管理端不传此头,不受门店端编辑限制)
///
private static bool IsStorePcRequest()
{
var source = App.HttpContext?.Request?.Headers["X-Client-Source"].ToString();
return string.Equals(source, "store-pc", StringComparison.OrdinalIgnoreCase);
}
///
/// 解析 yyyyMM 月份的起止时间
///
private static (DateTime start, DateTime end) GetMonthRange(string yf)
{
if (!DateTime.TryParseExact(yf, "yyyyMM", CultureInfo.InvariantCulture, DateTimeStyles.None, out var month))
throw NCCException.Oh(ErrorCode.COM1000, "月份格式必须为yyyyMM");
var start = new DateTime(month.Year, month.Month, 1, 0, 0, 0);
var end = start.AddMonths(1).AddSeconds(-1);
return (start, end);
}
///
/// 汇总金三角成员当月开单/消耗业绩(按健康师账号或用户ID匹配)
///
private async Task> AggregateJsjMemberPerformanceAsync(
string jsjId,
string month,
List memberUserIds)
{
var result = memberUserIds.ToDictionary(x => x, _ => (billing: 0m, consume: 0m));
if (string.IsNullOrEmpty(jsjId) || memberUserIds == null || memberUserIds.Count == 0)
{
return result;
}
var (start, end) = GetMonthRange(month);
var users = await _db.Queryable()
.Where(x => memberUserIds.Contains(x.Id))
.Select(x => new { x.Id, x.Account })
.ToListAsync();
var matchKeyToUserId = new Dictionary(StringComparer.Ordinal);
foreach (var user in users)
{
if (!string.IsNullOrEmpty(user.Id))
{
matchKeyToUserId[user.Id] = user.Id;
}
if (!string.IsNullOrEmpty(user.Account))
{
matchKeyToUserId[user.Account] = user.Id;
}
}
var billingRows = await _db.Queryable()
.Where(x => x.Jsj_id == jsjId && x.IsEffective == 1)
.Where(x => x.Yjsj >= start && x.Yjsj <= end)
.Where(x => x.Jksyj != null && x.Jksyj != "" && x.Jksyj != "0")
.Select(x => new { x.Jks, x.Jkszh, x.Jksxm, x.Jksyj })
.ToListAsync();
var consumeRows = await _db.Queryable()
.Where(x => x.JsjId == jsjId && x.IsEffective == 1)
.Where(x => x.Yjsj >= start && x.Yjsj <= end)
.Where(x => x.Jksyj != null && x.Jksyj != 0)
.Select(x => new { x.Jks, x.Jkszh, x.Jksxm, Jksyj = x.Jksyj.Value })
.ToListAsync();
var nameRows = billingRows
.Select(x => (x.Jks, x.Jkszh, x.Jksxm))
.Concat(consumeRows.Select(x => (x.Jks, x.Jkszh, x.Jksxm)));
var nameMap = await HealthCoachIdHelper.ResolveNameKeysToUserIdsAsync(_db, nameRows);
foreach (var row in billingRows)
{
var memberId = ResolveJsjMemberUserId(row.Jks, row.Jkszh, row.Jksxm, matchKeyToUserId, nameMap);
if (string.IsNullOrEmpty(memberId) || !result.ContainsKey(memberId))
{
continue;
}
if (decimal.TryParse(row.Jksyj, out var amount))
{
var current = result[memberId];
result[memberId] = (current.billing + amount, current.consume);
}
}
foreach (var row in consumeRows)
{
var memberId = ResolveJsjMemberUserId(row.Jks, row.Jkszh, row.Jksxm, matchKeyToUserId, nameMap);
if (string.IsNullOrEmpty(memberId) || !result.ContainsKey(memberId))
{
continue;
}
var current = result[memberId];
result[memberId] = (current.billing, current.consume + row.Jksyj);
}
return result;
}
///
/// 将业绩行匹配到战队成员用户ID
///
private static string ResolveJsjMemberUserId(
string jks,
string jkszh,
string jksxm,
IReadOnlyDictionary matchKeyToUserId,
IReadOnlyDictionary nameMap)
{
var key = HealthCoachIdHelper.ResolveMatchKey(jks, jkszh, jksxm, nameMap);
if (string.IsNullOrEmpty(key))
{
return null;
}
return matchKeyToUserId.TryGetValue(key, out var userId) ? userId : null;
}
///
/// 按战队 ID 软删除成员绑定(删除战队主表前调用,防止幽灵 ACTIVE)
///
private async Task SoftDeleteBindingsByJsjIdsAsync(List jsjIds)
{
if (jsjIds == null || jsjIds.Count == 0)
return;
var now = DateTime.Now;
var userId = _userManager.UserId;
await _db.Updateable()
.SetColumns(x => new LqJinsanjiaoUserEntity
{
DeleteMark = 1,
Status = "INACTIVE",
LastModifyTime = now,
LastModifyUserId = userId
})
.Where(x => jsjIds.Contains(x.JsjId) && x.DeleteMark == 0)
.ExecuteCommandAsync();
}
///
/// 按绑定主键软删除
///
private async Task SoftDeleteBindingsByIdsAsync(List bindingIds)
{
if (bindingIds == null || bindingIds.Count == 0)
return;
var now = DateTime.Now;
var userId = _userManager.UserId;
await _db.Updateable()
.SetColumns(x => new LqJinsanjiaoUserEntity
{
DeleteMark = 1,
Status = "INACTIVE",
LastModifyTime = now,
LastModifyUserId = userId
})
.Where(x => bindingIds.Contains(x.Id) && x.DeleteMark == 0)
.ExecuteCommandAsync();
}
///
/// 软删除用户当月其它战队绑定(同月一人一队)
///
private async Task SoftDeleteUserMonthBindingsAsync(List userIds, string month, string exceptJsjId)
{
if (userIds == null || userIds.Count == 0 || string.IsNullOrEmpty(month))
return;
var now = DateTime.Now;
var operatorId = _userManager.UserId;
var query = _db.Updateable()
.SetColumns(x => new LqJinsanjiaoUserEntity
{
DeleteMark = 1,
Status = "INACTIVE",
LastModifyTime = now,
LastModifyUserId = operatorId
})
.Where(x => userIds.Contains(x.UserId) && x.Month == month && x.DeleteMark == 0);
if (!string.IsNullOrEmpty(exceptJsjId))
{
await query.Where(x => x.JsjId != exceptJsjId).ExecuteCommandAsync();
}
else
{
await query.ExecuteCommandAsync();
}
}
///
/// 将成员当月开单/耗卡/退卡业绩中空值或幽灵 jsj_id 纠正到指定战队
///
private async Task RemapUserMonthPerformanceToJsjAsync(List userIds, string month, string newJsjId)
{
if (userIds == null || userIds.Count == 0 || string.IsNullOrEmpty(month) || string.IsNullOrEmpty(newJsjId))
return;
var (start, end) = GetMonthRange(month);
var usedKdJsjIds = await _db.Queryable()
.Where(x => x.IsEffective == 1 && x.Yjsj >= start && x.Yjsj <= end)
.Where(x => userIds.Contains(x.Jks) || userIds.Contains(x.Jkszh))
.Where(x => !SqlFunc.IsNullOrEmpty(x.Jsj_id))
.Select(x => x.Jsj_id)
.Distinct()
.ToListAsync();
var orphanKdIds = await FilterOrphanJsjIdsAsync(usedKdJsjIds);
await _db.Updateable()
.SetColumns(x => x.Jsj_id == newJsjId)
.Where(x => x.IsEffective == 1 && x.Yjsj >= start && x.Yjsj <= end)
.Where(x => userIds.Contains(x.Jks) || userIds.Contains(x.Jkszh))
.Where(x => SqlFunc.IsNullOrEmpty(x.Jsj_id) || orphanKdIds.Contains(x.Jsj_id))
.ExecuteCommandAsync();
var usedXhJsjIds = await _db.Queryable()
.Where(x => x.IsEffective == 1 && x.Yjsj >= start && x.Yjsj <= end)
.Where(x => userIds.Contains(x.Jks) || userIds.Contains(x.Jkszh))
.Where(x => !SqlFunc.IsNullOrEmpty(x.JsjId))
.Select(x => x.JsjId)
.Distinct()
.ToListAsync();
var orphanXhIds = await FilterOrphanJsjIdsAsync(usedXhJsjIds);
await _db.Updateable()
.SetColumns(x => x.JsjId == newJsjId)
.Where(x => x.IsEffective == 1 && x.Yjsj >= start && x.Yjsj <= end)
.Where(x => userIds.Contains(x.Jks) || userIds.Contains(x.Jkszh))
.Where(x => SqlFunc.IsNullOrEmpty(x.JsjId) || orphanXhIds.Contains(x.JsjId))
.ExecuteCommandAsync();
var usedTkJsjIds = await _db.Queryable()
.Where(x => x.IsEffective == StatusEnum.有效.GetHashCode() && x.Tksj >= start && x.Tksj <= end)
.Where(x => userIds.Contains(x.Jks) || userIds.Contains(x.Jkszh))
.Where(x => !SqlFunc.IsNullOrEmpty(x.F_jsjid))
.Select(x => x.F_jsjid)
.Distinct()
.ToListAsync();
var orphanTkIds = await FilterOrphanJsjIdsAsync(usedTkJsjIds);
await _db.Updateable()
.SetColumns(x => x.F_jsjid == newJsjId)
.Where(x => x.IsEffective == StatusEnum.有效.GetHashCode() && x.Tksj >= start && x.Tksj <= end)
.Where(x => userIds.Contains(x.Jks) || userIds.Contains(x.Jkszh))
.Where(x => SqlFunc.IsNullOrEmpty(x.F_jsjid) || orphanTkIds.Contains(x.F_jsjid))
.ExecuteCommandAsync();
}
///
/// 过滤出主表已不存在的金三角 ID
///
private async Task> FilterOrphanJsjIdsAsync(List jsjIds)
{
if (jsjIds == null || jsjIds.Count == 0)
return new List();
var distinct = jsjIds.Where(x => !string.IsNullOrWhiteSpace(x)).Distinct().ToList();
if (distinct.Count == 0)
return new List();
var exists = await _db.Queryable()
.Where(x => distinct.Contains(x.Id))
.Select(x => x.Id)
.ToListAsync();
var existSet = new HashSet(exists, StringComparer.Ordinal);
return distinct.Where(x => !existSet.Contains(x)).ToList();
}
///
/// 判断成员在指定月份是否已有开单/耗卡/退卡相关业绩
///
private async Task HasMemberMonthPerformanceAsync(IEnumerable userIds, string month)
{
var ids = userIds?.Where(x => !string.IsNullOrEmpty(x)).Distinct().ToList();
if (ids == null || ids.Count == 0 || string.IsNullOrEmpty(month))
return false;
var (start, end) = GetMonthRange(month);
var hasBilling = await _db.Queryable()
.Where(x => x.IsEffective == 1)
.Where(x => x.Yjsj >= start && x.Yjsj <= end)
.Where(x => ids.Contains(x.Jkszh) || ids.Contains(x.Jks))
.Where(x => x.Jksyj != null && x.Jksyj != "" && x.Jksyj != "0")
.AnyAsync();
if (hasBilling) return true;
var hasConsume = await _db.Queryable()
.Where(x => x.IsEffective == 1)
.Where(x => x.Yjsj >= start && x.Yjsj <= end)
.Where(x => ids.Contains(x.Jkszh) || ids.Contains(x.Jks))
.Where(x => x.Jksyj != null && x.Jksyj != 0)
.AnyAsync();
if (hasConsume) return true;
var hasRefund = await _db.Queryable()
.Where(x => x.IsEffective == StatusEnum.有效.GetHashCode())
.Where(x => x.Tksj >= start && x.Tksj <= end)
.Where(x => ids.Contains(x.Jkszh) || ids.Contains(x.Jks))
.Where(x => x.Jksyj != null && x.Jksyj != 0)
.AnyAsync();
return hasRefund;
}
///
/// 门店端:战队成员本月已有业绩时禁止修改
///
private async Task EnsureStorePcJsjEditableAsync(string jsjId)
{
if (!IsStorePcRequest() || string.IsNullOrEmpty(jsjId))
return;
var entity = await _db.Queryable().FirstAsync(x => x.Id == jsjId);
if (entity == null)
throw NCCException.Oh(ErrorCode.COM1005);
await EnsureStorePcJsjEditableAsync(entity);
}
///
/// 门店端:战队成员本月已有业绩时禁止修改
///
private async Task EnsureStorePcJsjEditableAsync(LqYcsdJsjEntity entity)
{
if (!IsStorePcRequest() || entity == null)
return;
var memberIds = await _db.Queryable()
.Where(x => x.JsjId == entity.Id && x.DeleteMark == 0 && x.Status == "ACTIVE")
.Select(x => x.UserId)
.ToListAsync();
if (await HasMemberMonthPerformanceAsync(memberIds, entity.Yf))
throw NCCException.Oh("该战队成员本月已有业绩,门店端不可修改,请联系管理端调整");
}
#endregion
private async Task TryWriteBusinessLogAsync(string moduleCode, string actionCode, string bizType, string bizId, string summary, string detailJson = null)
{
try
{
await _businessOperationLogService.WriteAsync(moduleCode, actionCode, bizType, bizId, summary, detailJson);
}
catch (Exception)
{
// 写日志失败不拖垮主业务
}
}
}
}