mirror of
https://github.com/HDInnovations/UNIT3D-Community-Edition.git
synced 2026-01-13 07:19:40 -06:00
88 lines
2.8 KiB
PHP
88 lines
2.8 KiB
PHP
<?php
|
|
|
|
declare(strict_types=1);
|
|
|
|
/**
|
|
* NOTICE OF LICENSE.
|
|
*
|
|
* UNIT3D Community Edition is open-sourced software licensed under the GNU Affero General Public License v3.0
|
|
* The details is bundled with this project in the file LICENSE.txt.
|
|
*
|
|
* @project UNIT3D Community Edition
|
|
*
|
|
* @author Roardom <roardom@protonmail.com>
|
|
* @license https://www.gnu.org/licenses/agpl-3.0.en.html/ GNU Affero General Public License v3.0
|
|
*/
|
|
|
|
namespace App\Http\Livewire;
|
|
|
|
use App\Models\Bookmark;
|
|
use App\Models\User;
|
|
use App\Traits\LivewireSort;
|
|
use Illuminate\Support\Facades\DB;
|
|
use Livewire\Attributes\Url;
|
|
use Livewire\Component;
|
|
use Livewire\WithPagination;
|
|
|
|
class UserBookmarks extends Component
|
|
{
|
|
use LivewireSort;
|
|
use WithPagination;
|
|
|
|
public ?User $user = null;
|
|
|
|
#TODO: Update URL attributes once Livewire 3 fixes upstream bug. See: https://github.com/livewire/livewire/discussions/7746
|
|
|
|
#[Url(history: true)]
|
|
public string $sortField = 'bookmarks.created_at';
|
|
|
|
#[Url(history: true)]
|
|
public string $sortDirection = 'desc';
|
|
|
|
final public function mount(int $userId): void
|
|
{
|
|
$this->user = User::find($userId);
|
|
}
|
|
|
|
/**
|
|
* @var \Illuminate\Contracts\Pagination\LengthAwarePaginator<int, Bookmark>
|
|
*/
|
|
final protected \Illuminate\Contracts\Pagination\LengthAwarePaginator $bookmarks {
|
|
get => Bookmark::query()
|
|
->select([
|
|
'bookmarks.torrent_id',
|
|
'bookmarks.created_at as bookmark_created_at',
|
|
'torrents.name',
|
|
'torrents.seeders',
|
|
'torrents.leechers',
|
|
'torrents.times_completed',
|
|
'torrents.size',
|
|
'torrents.created_at as torrent_created_at',
|
|
DB::raw('history.active AND history.seeder AS seeding'),
|
|
DB::raw('history.active AND NOT history.seeder AS leeching'),
|
|
DB::raw('NOT history.active AND history.seeder AS completed'),
|
|
])
|
|
->withCasts([
|
|
'bookmark_created_at' => 'datetime',
|
|
'torrent_created_at' => 'datetime',
|
|
])
|
|
->join('torrents', 'torrents.id', '=', 'bookmarks.torrent_id')
|
|
->leftJoin(
|
|
'history',
|
|
fn ($join) => $join
|
|
->on('history.torrent_id', '=', 'bookmarks.torrent_id')
|
|
->on('history.user_id', '=', 'bookmarks.user_id')
|
|
)
|
|
->where('bookmarks.user_id', '=', $this->user->id)
|
|
->orderBy($this->sortField, $this->sortDirection)
|
|
->paginate(25);
|
|
}
|
|
|
|
final public function render(): \Illuminate\Contracts\View\Factory|\Illuminate\Contracts\View\View|\Illuminate\Contracts\Foundation\Application
|
|
{
|
|
return view('livewire.user-bookmarks', [
|
|
'bookmarks' => $this->bookmarks,
|
|
]);
|
|
}
|
|
}
|