using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Mvc;
using NCC.Common.Filter;
using NCC.Extend.Entitys.Dto.LqBusinessUnitDashboard;
using NCC.Extend.Entitys.Enum;
using NCC.Extend.Entitys.lq_card_transfer_log;
using NCC.Extend.Entitys.lq_hytk_hytk;
using NCC.Extend.Entitys.lq_kd_kdjlb;
using NCC.Extend.Entitys.lq_khxx;
using NCC.Extend.Entitys.lq_mdxx;
using NCC.Extend.Entitys.lq_xh_hyhk;
using NCC.Extend.Helpers;
using NCC.FriendlyException;
using SqlSugar;
namespace NCC.Extend
{
public partial class LqBusinessUnitDashboardService
{
#region 大客卡金异常
///
/// 获取大客卡金监控阈值(系统配置)
///
///
/// 示例请求:GET /api/Extend/LqBusinessUnitDashboard/Actions/GetLargeAmountThresholds
///
[HttpGet("Actions/GetLargeAmountThresholds")]
public async Task GetLargeAmountThresholds()
{
var (billing, consume, refund, transfer) = await LargeAmountAuditHelper.GetThresholdsAsync(_db);
return new BusinessUnitLargeAmountThresholdOutput
{
billingThreshold = billing,
consumeThreshold = consume,
refundThreshold = refund,
transferThreshold = transfer
};
}
///
/// 大客卡金异常审计列表(大额开单/耗卡/退卡/转卡)
///
///
/// 金额达到系统设置阈值即列入监控;门店范围与重复充值审计一致。
///
/// 示例请求:
/// ```json
/// {
/// "startTime": "2026-07-01 00:00:00",
/// "endTime": "2026-07-31 23:59:59",
/// "currentPage": 1,
/// "pageSize": 20
/// }
/// ```
///
[HttpPost("GetLargeAmountAuditList")]
public async Task GetLargeAmountAuditList(
[FromBody] BusinessUnitLargeAmountAuditListInput input)
{
if (input == null) throw NCCException.Oh("请求参数不能为空");
var duplicateInput = MapLargeAmountToDuplicateInput(input);
var (startDate, endDateTime) = ResolveDuplicateAuditDateRange(duplicateInput);
var storeIds = await ResolveDuplicateAuditStoreIdsAsync(duplicateInput, startDate);
if (!storeIds.Any())
{
return EmptyLargeAmountPageResult(input);
}
var auditRows = await BuildLargeAmountAuditRowsAsync(storeIds, startDate, endDateTime);
if (!string.IsNullOrWhiteSpace(input.StoreId))
auditRows = auditRows.Where(x => x.StoreId == input.StoreId).ToList();
if (!string.IsNullOrWhiteSpace(input.MemberName))
{
var memberName = input.MemberName.Trim();
auditRows = auditRows.Where(x =>
!string.IsNullOrWhiteSpace(x.MemberName) &&
x.MemberName.Contains(memberName)).ToList();
}
if (!string.IsNullOrWhiteSpace(input.BizType))
{
var bizType = input.BizType.Trim();
auditRows = auditRows.Where(x =>
x.BizType.Equals(bizType, StringComparison.OrdinalIgnoreCase)).ToList();
}
var keyword = string.IsNullOrWhiteSpace(input.keyword) ? null : input.keyword.Trim();
if (keyword != null)
{
auditRows = auditRows.Where(x =>
(x.MemberName != null && x.MemberName.Contains(keyword)) ||
(x.StoreName != null && x.StoreName.Contains(keyword)) ||
(x.BizId != null && x.BizId.Contains(keyword))).ToList();
}
auditRows = auditRows.OrderByDescending(x => x.Amount).ThenByDescending(x => x.BizTime).ToList();
var total = auditRows.Count;
var pageIndex = NormalizeCapabilityPageIndex(input.currentPage);
var pageSize = NormalizeCapabilityPageSize(input.pageSize);
var pageList = auditRows.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
return PageResult.SqlSugarPageResult(
new SqlSugarPagedList
{
list = pageList,
pagination = new PagedModel
{
PageIndex = pageIndex,
PageSize = pageSize,
Total = total
}
});
}
private static dynamic EmptyLargeAmountPageResult(BusinessUnitLargeAmountAuditListInput input)
{
return PageResult.SqlSugarPageResult(
new SqlSugarPagedList
{
list = new List(),
pagination = new PagedModel
{
PageIndex = NormalizeCapabilityPageIndex(input.currentPage),
PageSize = NormalizeCapabilityPageSize(input.pageSize),
Total = 0
}
});
}
private static BusinessUnitDuplicateRechargeAuditListInput MapLargeAmountToDuplicateInput(
BusinessUnitLargeAmountAuditListInput input)
{
return new BusinessUnitDuplicateRechargeAuditListInput
{
BusinessUnitId = input.BusinessUnitId,
StoreIds = input.StoreIds,
StatisticsMonth = input.StatisticsMonth,
StartTime = input.StartTime,
EndTime = input.EndTime,
StoreId = input.StoreId,
MemberName = input.MemberName,
currentPage = input.currentPage,
pageSize = input.pageSize,
keyword = input.keyword
};
}
private async Task> BuildLargeAmountAuditRowsAsync(
List storeIds, DateTime startDate, DateTime endDateTime)
{
var (billingThreshold, consumeThreshold, refundThreshold, transferThreshold) =
await LargeAmountAuditHelper.GetThresholdsAsync(_db);
var result = new List();
var billingRows = await _db.Queryable(
(bill, store, member) => new JoinQueryInfos(
JoinType.Left, bill.Djmd == store.Id,
JoinType.Left, bill.Kdhy == member.Id))
.Where((bill, store, member) =>
storeIds.Contains(bill.Djmd) &&
bill.IsEffective == 1 &&
bill.Kdrq.HasValue &&
bill.Kdrq.Value >= startDate &&
bill.Kdrq.Value <= endDateTime &&
bill.Sfyj >= billingThreshold)
.Select((bill, store, member) => new BusinessUnitLargeAmountAuditListOutput
{
BizId = bill.Id,
BizType = nameof(LargeAmountBizType.Billing),
BizTypeName = "开单",
ExceptionType = "LargeAmountBilling",
ExceptionTypeName = "大额开单",
MemberId = bill.Kdhy,
MemberName = member.Khmc,
StoreId = bill.Djmd,
StoreName = store.Dm,
BizTime = bill.Kdrq.Value,
BizDate = bill.Kdrq.Value.Date,
Amount = bill.Sfyj,
ThresholdAmount = billingThreshold,
OperatorId = bill.CreateUser
})
.ToListAsync();
result.AddRange(billingRows);
var consumeRows = await _db.Queryable(
(consume, store, member) => new JoinQueryInfos(
JoinType.Left, consume.Md == store.Id,
JoinType.Left, consume.Hy == member.Id))
.Where((consume, store, member) =>
storeIds.Contains(consume.Md) &&
consume.IsEffective == 1 &&
consume.Hksj.HasValue &&
consume.Hksj.Value >= startDate &&
consume.Hksj.Value <= endDateTime &&
consume.Xfje >= consumeThreshold)
.Select((consume, store, member) => new BusinessUnitLargeAmountAuditListOutput
{
BizId = consume.Id,
BizType = nameof(LargeAmountBizType.Consume),
BizTypeName = "耗卡",
ExceptionType = "LargeAmountConsume",
ExceptionTypeName = "大额耗卡",
MemberId = consume.Hy,
MemberName = member.Khmc ?? consume.Hymc,
StoreId = consume.Md,
StoreName = store.Dm,
BizTime = consume.Hksj.Value,
BizDate = consume.Hksj.Value.Date,
Amount = consume.Xfje ?? 0m,
ThresholdAmount = consumeThreshold,
OperatorId = consume.Czry
})
.ToListAsync();
result.AddRange(consumeRows);
var refundEntities = await _db.Queryable(
(refund, store, member) => new JoinQueryInfos(
JoinType.Left, refund.Md == store.Id,
JoinType.Left, refund.Hy == member.Id))
.Where((refund, store, member) =>
storeIds.Contains(refund.Md) &&
refund.IsEffective == 1)
.Select((refund, store, member) => new
{
refund.Id,
refund.Hy,
MemberName = member.Khmc ?? refund.Hymc,
refund.Md,
StoreName = store.Dm ?? refund.Mdmc,
refund.Tksj,
refund.F_CreateTime,
Amount = refund.ActualRefundAmount ?? refund.Tkje ?? 0m,
OperatorId = refund.Czry ?? refund.F_CreateUser
})
.ToListAsync();
var refundRows = refundEntities
.Select(x =>
{
var bizTime = x.Tksj ?? x.F_CreateTime ?? DateTime.MinValue;
return new { x, bizTime };
})
.Where(x => x.bizTime >= startDate && x.bizTime <= endDateTime && x.x.Amount >= refundThreshold)
.Select(x => new BusinessUnitLargeAmountAuditListOutput
{
BizId = x.x.Id,
BizType = nameof(LargeAmountBizType.RefundCard),
BizTypeName = "退卡",
ExceptionType = "LargeAmountRefundCard",
ExceptionTypeName = "大额退卡",
MemberId = x.x.Hy,
MemberName = x.x.MemberName,
StoreId = x.x.Md,
StoreName = x.x.StoreName,
BizTime = x.bizTime,
BizDate = x.bizTime.Date,
Amount = x.x.Amount,
ThresholdAmount = refundThreshold,
OperatorId = x.x.OperatorId
})
.ToList();
result.AddRange(refundRows);
var transferEntities = await _db.Queryable(
(transfer, refund, store, fromMember, toMember) => new JoinQueryInfos(
JoinType.Left, transfer.RefundCardId == refund.Id,
JoinType.Left, refund.Md == store.Id,
JoinType.Left, transfer.TransferFromMemberId == fromMember.Id,
JoinType.Left, transfer.TransferToMemberId == toMember.Id))
.Where((transfer, refund, store, fromMember, toMember) =>
transfer.IsEffective == 1 &&
transfer.TransferTime >= startDate &&
transfer.TransferTime <= endDateTime &&
transfer.TransferAmount >= transferThreshold &&
storeIds.Contains(refund.Md))
.Select((transfer, refund, store, fromMember, toMember) => new
{
transfer.Id,
transfer.TransferFromMemberId,
transfer.TransferToMemberId,
transfer.TransferAmount,
transfer.TransferTime,
transfer.OperatorId,
transfer.RefundCardId,
refund.Md,
StoreName = store.Dm ?? refund.Mdmc,
FromName = fromMember.Khmc,
ToName = toMember.Khmc
})
.ToListAsync();
var transferRows = transferEntities.Select(x => new BusinessUnitLargeAmountAuditListOutput
{
BizId = x.Id,
BizType = nameof(LargeAmountBizType.CardTransfer),
BizTypeName = "转卡",
ExceptionType = "LargeAmountCardTransfer",
ExceptionTypeName = "大额转卡",
MemberId = x.TransferFromMemberId,
MemberName = $"{x.FromName ?? x.TransferFromMemberId} → {x.ToName ?? x.TransferToMemberId}",
StoreId = x.Md,
StoreName = x.StoreName,
BizTime = x.TransferTime,
BizDate = x.TransferTime.Date,
Amount = x.TransferAmount,
ThresholdAmount = transferThreshold,
OperatorId = x.OperatorId,
RefundCardId = x.RefundCardId
})
.ToList();
result.AddRange(transferRows);
return result;
}
#endregion
}
}