LqCardTransferLogService.cs 12.9 KB
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Logging;
using NCC.ClayObject;
using NCC.Common.Configuration;
using NCC.Common.Core.Manager;
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.LqCardTransferLog;
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_khxx;
using NCC.Extend.Interfaces;
using NCC.Extend.Interfaces.BusinessOperationLog;
using NCC.FriendlyException;
using NCC.JsonSerialization;
using NCC.System.Entitys.Permission;
using SqlSugar;
using Yitter.IdGenerator;

namespace NCC.Extend.LqCardTransferLog
{
    /// <summary>
    /// 转卡日志服务
    /// </summary>
    [ApiDescriptionSettings(Tag = "绿纤转卡日志服务", Name = "LqCardTransferLog", Order = 200)]
    [Route("api/Extend/[controller]")]
    public class LqCardTransferLogService : IDynamicApiController, ILqCardTransferLogService, ITransient
    {
        private readonly ISqlSugarClient _db;
        private readonly IUserManager _userManager;
        private readonly ILogger<LqCardTransferLogService> _logger;
        private readonly IBusinessOperationLogService _businessOperationLogService;

        private const string BizLogModuleTransferCard = "会员转卡";

        public LqCardTransferLogService(
            ISqlSugarClient db,
            IUserManager userManager,
            ILogger<LqCardTransferLogService> logger,
            IBusinessOperationLogService businessOperationLogService)
        {
            _db = db;
            _userManager = userManager;
            _logger = logger;
            _businessOperationLogService = businessOperationLogService;
        }

        #region 添加转卡日志
        /// <summary>
        /// 添加转卡日志
        /// </summary>
        /// <param name="input">转卡日志创建输入参数</param>
        /// <returns>创建结果</returns>
        [HttpPost("add")]
        public async Task<dynamic> AddTransferLog([FromBody] LqCardTransferLogCrInput input)
        {
            try
            {
                if (input == null)
                {
                    throw NCCException.Oh("输入参数不能为空");
                }

                var entity = new LqCardTransferLogEntity
                {
                    Id = YitIdHelper.NextId().ToString(),
                    RefundCardId = input.refundCardId,
                    BillingCardId = input.billingCardId,
                    TransferFromMemberId = input.transferFromMemberId,
                    TransferToMemberId = input.transferToMemberId,
                    TransferAmount = input.transferAmount,
                    TransferTime = input.transferTime,
                    OperatorId = input.operatorId,
                    Remarks = input.remarks ?? "",
                    CreateTime = DateTime.Now,
                    IsEffective = 1
                };

                var result = await _db.Insertable(entity).ExecuteCommandAsync();

                await TryWriteBizLogAsync(
                    "新增转卡",
                    "lq_card_transfer_log",
                    entity.Id,
                    $"新增转卡记录 {entity.Id},转出 {input.transferFromMemberId} → 转入 {input.transferToMemberId},金额 {input.transferAmount}",
                    Newtonsoft.Json.JsonConvert.SerializeObject(new
                    {
                        after = new
                        {
                            entity.Id,
                            entity.RefundCardId,
                            entity.BillingCardId,
                            entity.TransferFromMemberId,
                            entity.TransferToMemberId,
                            entity.TransferAmount,
                            entity.TransferTime,
                            entity.Remarks
                        }
                    }));

                return new
                {
                    Success = true,
                    Message = "转卡日志创建成功",
                    Data = new { Id = entity.Id }
                };
            }
            catch (Exception ex)
            {
                throw NCCException.Oh($"创建转卡日志失败: {ex.Message}");
            }
        }
        #endregion

        #region 获取转卡日志列表
        /// <summary>
        /// 获取转卡日志列表
        /// </summary>
        /// <param name="input">查询输入参数</param>
        /// <returns>转卡日志列表</returns>
        [HttpGet("")]
        public async Task<dynamic> GetList([FromQuery] LqCardTransferLogListQueryInput input)
        {
            try
            {
                var result = await BuildTransferLogQuery(input)
                    .OrderBy(x => x.transferTime, OrderByType.Desc)
                    .ToPagedListAsync(input.currentPage, input.pageSize);

                return PageResult<LqCardTransferLogListOutput>.SqlSugarPageResult(result);
            }
            catch (Exception ex)
            {
                throw NCCException.Oh($"获取转卡日志列表失败: {ex.Message}");
            }
        }

        /// <summary>
        /// 获取转卡日志无分页列表(导出用)
        /// </summary>
        [NonAction]
        public async Task<List<LqCardTransferLogListOutput>> GetNoPagingList([FromQuery] LqCardTransferLogListQueryInput input)
        {
            return await BuildTransferLogQuery(input)
                .OrderBy(x => x.transferTime, OrderByType.Desc)
                .ToListAsync();
        }

        /// <summary>
        /// 导出转卡记录(固定列,忽略 selectKey)
        /// </summary>
        /// <remarks>
        /// GET /api/Extend/LqCardTransferLog/Actions/Export?dataType=1
        /// dataType:0 当前页,1 全部。
        /// </remarks>
        /// <param name="input">与列表一致的筛选参数</param>
        /// <returns>Excel 下载信息(name、url)</returns>
        [HttpGet("Actions/Export")]
        public async Task<dynamic> Export([FromQuery] LqCardTransferLogListQueryInput input)
        {
            var exportData = new List<LqCardTransferLogListOutput>();
            if (input.dataType == 0)
            {
                var data = Clay.Object(await GetList(input));
                exportData = data.Solidify<PageResult<LqCardTransferLogListOutput>>().list;
            }
            else
            {
                exportData = await GetNoPagingList(input);
            }

            foreach (var row in exportData)
            {
                row.isEffectiveText = row.isEffective == StatusEnum.有效.GetHashCode() ? "正常" : "作废";
            }

            List<ParamsModel> paramList =
                "[{\"value\":\"转卡ID\",\"field\":\"id\"},{\"value\":\"转出会员名称\",\"field\":\"transferFromMemberName\"},{\"value\":\"转入会员名称\",\"field\":\"transferToMemberName\"},{\"value\":\"转卡金额\",\"field\":\"transferAmount\"},{\"value\":\"转卡时间\",\"field\":\"transferTime\"},{\"value\":\"操作员\",\"field\":\"operatorName\"},{\"value\":\"退卡单号\",\"field\":\"refundCardId\"},{\"value\":\"开单单号\",\"field\":\"billingCardId\"},{\"value\":\"是否有效\",\"field\":\"isEffectiveText\"},{\"value\":\"作废时间\",\"field\":\"voidTime\"},{\"value\":\"备注\",\"field\":\"remarks\"}]"
                    .ToList<ParamsModel>();

            var excelconfig = new ExcelConfig
            {
                FileName = "会员转卡.xls",
                HeadFont = "微软雅黑",
                HeadPoint = 10,
                IsAllSizeColumn = true,
                ColumnModel = new List<ExcelColumnModel>()
            };
            foreach (var param in paramList)
            {
                excelconfig.ColumnModel.Add(new ExcelColumnModel { Column = param.field, ExcelColumn = param.value });
            }

            var addPath = FileVariable.TemporaryFilePath + excelconfig.FileName;
            ExcelExportHelper<LqCardTransferLogListOutput>.Export(exportData, excelconfig, addPath);
            var fileName = _userManager.UserId + "|" + addPath + "|xls";

            await TryWriteBizLogAsync(
                "导出转卡记录",
                "lq_card_transfer_log",
                null,
                $"导出转卡记录,共 {exportData.Count} 条",
                new
                {
                    filters = new
                    {
                        input.transferFromMemberId,
                        input.transferToMemberId,
                        input.operatorId,
                        input.storeId,
                        input.isEffective,
                        input.dataType
                    },
                    rowCount = exportData.Count,
                    fileName = excelconfig.FileName
                }.Serialize());

            return new { name = excelconfig.FileName, url = "/api/File/Download?encryption=" + DESCEncryption.Encrypt(fileName, "NCC") };
        }
        #endregion

        private ISugarQueryable<LqCardTransferLogListOutput> BuildTransferLogQuery(LqCardTransferLogListQueryInput input)
        {
            return _db.Queryable<LqCardTransferLogEntity>()
                .WhereIF(input.isEffective != 0, x => x.IsEffective == input.isEffective)
                .WhereIF(!string.IsNullOrEmpty(input.transferFromMemberId), x => x.TransferFromMemberId == input.transferFromMemberId)
                .WhereIF(!string.IsNullOrEmpty(input.transferToMemberId), x => x.TransferToMemberId == input.transferToMemberId)
                .WhereIF(!string.IsNullOrEmpty(input.operatorId), x => x.OperatorId == input.operatorId)
                .WhereIF(input.transferStartTime.HasValue, x => x.TransferTime >= input.transferStartTime.Value)
                .WhereIF(input.transferEndTime.HasValue, x => x.TransferTime <= input.transferEndTime.Value)
                .WhereIF(input.minTransferAmount.HasValue, x => x.TransferAmount >= input.minTransferAmount.Value)
                .WhereIF(input.maxTransferAmount.HasValue, x => x.TransferAmount <= input.maxTransferAmount.Value)
                .WhereIF(!string.IsNullOrEmpty(input.keyword), x =>
                    x.Id.Contains(input.keyword)
                    || x.RefundCardId.Contains(input.keyword)
                    || x.BillingCardId.Contains(input.keyword)
                    || x.Remarks.Contains(input.keyword)
                    || SqlFunc.Subqueryable<LqKhxxEntity>()
                        .Where(m => m.Id == x.TransferFromMemberId && m.Khmc.Contains(input.keyword)).Any()
                    || SqlFunc.Subqueryable<LqKhxxEntity>()
                        .Where(m => m.Id == x.TransferToMemberId && m.Khmc.Contains(input.keyword)).Any())
                .WhereIF(!string.IsNullOrEmpty(input.storeId), x => SqlFunc.Subqueryable<LqHytkHytkEntity>()
                    .Where(r => r.Id == x.RefundCardId && r.Md == input.storeId).Any())
                .Select(x => new LqCardTransferLogListOutput
                {
                    id = x.Id,
                    refundCardId = x.RefundCardId,
                    billingCardId = x.BillingCardId,
                    transferFromMemberId = x.TransferFromMemberId,
                    transferFromMemberName = SqlFunc.Subqueryable<LqKhxxEntity>()
                        .Where(m => m.Id == x.TransferFromMemberId).Select(m => m.Khmc),
                    transferToMemberId = x.TransferToMemberId,
                    transferToMemberName = SqlFunc.Subqueryable<LqKhxxEntity>()
                        .Where(m => m.Id == x.TransferToMemberId).Select(m => m.Khmc),
                    transferAmount = x.TransferAmount,
                    transferTime = x.TransferTime,
                    operatorId = x.OperatorId,
                    operatorName = SqlFunc.Subqueryable<UserEntity>()
                        .Where(u => u.Id == x.OperatorId).Select(u => u.RealName),
                    remarks = x.Remarks,
                    createTime = x.CreateTime,
                    updateTime = x.UpdateTime,
                    isEffective = x.IsEffective,
                    voidTime = x.VoidTime
                });
        }

        private async Task TryWriteBizLogAsync(
            string actionCode,
            string bizType,
            string bizId,
            string summary,
            string detailJson)
        {
            try
            {
                await _businessOperationLogService.WriteAsync(
                    BizLogModuleTransferCard,
                    actionCode,
                    bizType,
                    bizId,
                    summary,
                    detailJson);
            }
            catch (Exception ex)
            {
                _logger.LogWarning(ex, "写入会员转卡业务操作日志失败 action={Action}", actionCode);
            }
        }
    }
}