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.
41 lines
1.5 KiB
C#
41 lines
1.5 KiB
C#
using Microsoft.EntityFrameworkCore;
|
|
using Musify.Application.Contracts;
|
|
using Musify.Application.Mixes.Responses;
|
|
using Musify.Domain.Entities;
|
|
|
|
namespace Musify.Application.Mixes
|
|
{
|
|
|
|
internal static class MixItemMapper
|
|
{
|
|
public static async Task<List<MixItemApplicationResponse>> ToResponsesAsync(
|
|
IDatabase database,
|
|
IReadOnlyList<MixItem> orderedItems,
|
|
CancellationToken cancellationToken)
|
|
{
|
|
var trackIds = orderedItems.Select(item => item.TrackId).Distinct().ToList();
|
|
|
|
var tracksById = await database.Tracks
|
|
.AsNoTracking()
|
|
.Include(track => track.Owner)
|
|
.Where(track => trackIds.Contains(track.Id))
|
|
.Select(track => new { Track = track, ListensCount = track.ListeningHistories.Count(l => l.IsCounted) })
|
|
.ToDictionaryAsync(x => x.Track.Id, cancellationToken);
|
|
|
|
return orderedItems
|
|
.Where(item => tracksById.ContainsKey(item.TrackId))
|
|
.Select(item =>
|
|
{
|
|
var entry = tracksById[item.TrackId];
|
|
return new MixItemApplicationResponse(
|
|
item.TrackId,
|
|
entry.Track.Title,
|
|
entry.Track.Owner.Name,
|
|
entry.Track.DurationSeconds,
|
|
entry.ListensCount);
|
|
})
|
|
.ToList();
|
|
}
|
|
}
|
|
}
|