feat:开发

sunpengfei

1 天以前 83fa670fc682d359737afe03bbe2b4a44fd24778

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
using FlexJobApi.Core;
using Furion.DatabaseAccessor;
using Furion.FriendlyException;
using Mapster;
using MediatR;
using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
 
namespace FlexJobApi.UserServer.Application
{
    /// <summary>
    /// 查询个人用户收支明细
    /// </summary>
    public class GetPersonalUserTransactionsQueryHandler(
            IRepository<UserWalletTransaction> rep
        ) :
        IRequestHandler<GetPersonalUserTransactionsQuery, GetPersonalUserTransactionsQueryResult>,
        IRequestHandler<GetPersonalUserTransactionQuery, GetPersonalUserTransactionQueryResult>
    {
        private readonly IRepository<UserWalletTransaction> rep = rep;
 
        /// <summary>
        /// 查询个人用户收支明细分页列表数据
        /// </summary>
        /// <param name="request"></param>
        /// <param name="cancellationToken"></param>
        /// <returns></returns>
        public async Task<GetPersonalUserTransactionsQueryResult> Handle(GetPersonalUserTransactionsQuery request, CancellationToken cancellationToken)
        {
            var logier = JwtUtils.GetCurrentLogier();
            var q = rep.AsQueryable().AsNoTracking()
                .OrderByDescending(it => it.CreatedTime)
                .Where(it => it.Wallet.UserId == logier.Id);
 
            if (request.CreatedTimeStart.HasValue && request.CreatedTimeEnd.HasValue)
            {
                q = q.Where(it => request.CreatedTimeStart <= it.CreatedTime && it.CreatedTime <= request.CreatedTimeEnd);
            }
 
            var data = new GetPersonalUserTransactionsQueryResultObjectData();
            data.SumIncome = await q.Where(it => it.Type == EnumUserWalletTransactionType.Income).SumAsync(it => it.Amount);
            data.SumWithdraw = await q.Where(it => it.Type == EnumUserWalletTransactionType.Withdraw).SumAsync(it => it.Amount);
 
            if (request.Type.HasValue)
            {
                q = q.Where(it => it.Type == request.Type);
            }
 
            var s = q
                .Select(it => new GetPersonalUserTransactionsQueryResultItem
                {
                    Id = it.Id,
                    Title = it.Title,
                    CreatedTime = it.CreatedTime,
                    Balance = it.Balance + (it.Type == EnumUserWalletTransactionType.Income ? it.Amount : (0 - it.Amount)),
                    Amount = it.Type == EnumUserWalletTransactionType.Income ? it.Amount : (0 - it.Amount),
                });
            var list = await request.PageModel.GetPagedListAsync<GetPersonalUserTransactionsQueryResult, GetPersonalUserTransactionsQueryResultItem>(s, cancellationToken);
 
            list.ObjectData = data;
 
            return list;
        }
 
        /// <summary>
        /// 查询个人用户收支明细详情
        /// </summary>
        /// <param name="request"></param>
        /// <param name="cancellationToken"></param>
        /// <returns></returns>
        public async Task<GetPersonalUserTransactionQueryResult> Handle(GetPersonalUserTransactionQuery request, CancellationToken cancellationToken)
        {
            return await rep.AsQueryable().AsNoTracking()
                .Where(it => it.Id == request.Id)
                .GetDetail<UserWalletTransaction, GetPersonalUserTransactionQueryResult>();
        }
    }
}