YD_Event.Admin/YD_Event.Application/Client/AlbumsController.cs

using YD_Event.Application.Client.Dtos;
using Furion.UnifyResult;

namespace YD_Event.Application.Client;

/// <summary>
/// 相册
/// </summary>
[ApiDescriptionSettings("博客前端接口")]
[AllowAnonymous]
public class AlbumsController : IDynamicApiController
{
    private readonly ISqlSugarRepository<Albums> _albumsRepository;

    public AlbumsController(ISqlSugarRepository<Albums> albumsRepository)
    {
        _albumsRepository = albumsRepository;
    }

    /// <summary>
    /// 相册列表
    /// </summary>
    /// <param name="dto"></param>
    /// <returns></returns>
    [HttpGet]
    public async Task<PageResult<AlbumsOutput>> Get([FromQuery] Pagination dto)
    {
        return await _albumsRepository.AsQueryable().Where(x => x.IsVisible && x.Status == AvailabilityStatus.Enable)
              .OrderBy(x => x.Sort)
              .OrderByDescending(x => x.Id)
              .Select(x => new AlbumsOutput
              {
                  Id = x.Id,
                  Name = x.Name,
                  Cover = x.Cover,
                  Remark = x.Remark,
                  CreatedTime = x.CreatedTime
              }).ToPagedListAsync(dto);
    }

    /// <summary>
    /// 相册下的图片
    /// </summary>
    /// <param name="dto"></param>
    /// <returns></returns>
    [HttpGet]
    public async Task<PageResult<PictureOutput>> Pictures([FromQuery] PicturesQueryInput dto)
    {
        var album = await _albumsRepository.AsQueryable().Where(x => x.Id == dto.AlbumId && x.IsVisible && x.Status == AvailabilityStatus.Enable).Select(x => new
        {
            x.Name,
            x.Cover
        }).FirstAsync();
        UnifyContext.Fill(album);
        return await _albumsRepository.AsQueryable().InnerJoin<Pictures>((albums, pictures) => albums.Id == pictures.AlbumId)
             .Where(albums => albums.IsVisible && albums.Status == AvailabilityStatus.Enable && albums.Id == dto.AlbumId)
             .OrderByDescending((albums, pictures) => pictures.Id)
             .Select((albums, pictures) => new PictureOutput { Id = pictures.Id, Url = pictures.Url }).ToPagedListAsync(dto);
    }
}