Admin
5df5e635f3
"Listening time this week" summed the full duration of every track whose
stream ticket was issued, so pressing play and skipping counted the whole
song. Playback is now measured on the client and reported to the API.
Backend:
- ListeningHistory gains PlayedSeconds, LastProgressAt and IsCounted
(migration TrackPlayedSeconds marks existing rows as counted).
- /tracks/{id}/stream returns a listenId; new
PUT /tracks/listens/{listenId}/progress stores the accumulated seconds,
capped by track duration and elapsed wall-clock time, monotonic and
owner-only.
- A listen counts once it reaches min(30s, 50% of the track). Weekly
stats, streak, recent history/albums, mixes and listensCount only use
counted listens; seconds sum PlayedSeconds.
- ListeningHistoryCleanupJob (daily) deletes uncounted listens older
than 8 days.
web-player:
- ListenTracker accumulates played time (seeks are ignored) and flushes
on pause, track change, ended, every 30s, and on pagehide.
- Proxy route /api/listens/[id]/progress; repeat starts a new listen per
loop.
54 lines
2.2 KiB
C#
54 lines
2.2 KiB
C#
using ErrorOr;
|
|
using Mediator;
|
|
using Microsoft.EntityFrameworkCore;
|
|
using Musify.Application.Shared;
|
|
using Musify.Application.Tracks.Responses;
|
|
using X.PagedList;
|
|
using X.PagedList.EF;
|
|
using Musify.Application.Contracts;
|
|
|
|
namespace Musify.Application.Tracks
|
|
{
|
|
public record GetTracksByUserIdQuery(
|
|
long UserId,
|
|
string? Name,
|
|
int PageNumber,
|
|
int PageSize)
|
|
: IQuery<ErrorOr<PaginatedResponse<TrackApplicationResponse>>>;
|
|
|
|
public class GetTracksByUserIdQueryHandler(IDatabase database)
|
|
: IQueryHandler<GetTracksByUserIdQuery, ErrorOr<PaginatedResponse<TrackApplicationResponse>>>
|
|
{
|
|
public async ValueTask<ErrorOr<PaginatedResponse<TrackApplicationResponse>>> Handle(GetTracksByUserIdQuery request, CancellationToken cancellationToken)
|
|
{
|
|
var pageNumber = request.PageNumber < 1 ? 1 : request.PageNumber;
|
|
var pageSize = request.PageSize < 1 ? 10 : request.PageSize;
|
|
|
|
var tracksQuery = database.UserHasTracks
|
|
.AsNoTracking()
|
|
.Include(ut => ut.Track.Owner)
|
|
.Include(ut => ut.Track.Tags)
|
|
.Where(p => p.UserId == request.UserId);
|
|
|
|
if (!string.IsNullOrEmpty(request.Name))
|
|
{
|
|
var normalizedName = request.Name.Trim().ToUpperInvariant();
|
|
tracksQuery = tracksQuery.Where(t => t.Track.NormalizedTitle.Contains(normalizedName));
|
|
}
|
|
|
|
var totalCount = await tracksQuery.CountAsync(cancellationToken);
|
|
|
|
var pagedEntities = await tracksQuery
|
|
.OrderBy(t => t.Track.CreatedAt)
|
|
.Select(t => new { t.Track, ListensCount = t.Track.ListeningHistories.Count(l => l.IsCounted) })
|
|
.ToPagedListAsync(pageNumber, pageSize, totalCount, cancellationToken);
|
|
|
|
var pagedTracks = new StaticPagedList<TrackApplicationResponse>(
|
|
pagedEntities.Select(x => TrackApplicationResponse.FromEntity(x.Track, x.ListensCount)),
|
|
pagedEntities.PageNumber, pagedEntities.PageSize, pagedEntities.TotalItemCount);
|
|
|
|
return PaginatedResponse<TrackApplicationResponse>.FromPagedList(pagedTracks);
|
|
}
|
|
}
|
|
}
|