mirror of
https://github.com/BillyOutlast/UNIT3D.git
synced 2026-02-05 11:41:22 +01:00
b2e29cfcf0
These columns were previously tiny ints without the (1) display width or regular ints, or smallints. They should all be tinyint(1).
51 lines
1.8 KiB
PHP
51 lines
1.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 HDVinnie <hdinnovations@protonmail.com>
|
|
* @license https://www.gnu.org/licenses/agpl-3.0.en.html/ GNU Affero General Public License v3.0
|
|
*/
|
|
|
|
namespace App\Http\Controllers\Staff;
|
|
|
|
use App\Http\Controllers\Controller;
|
|
use App\Models\User;
|
|
|
|
class UploaderController extends Controller
|
|
{
|
|
/**
|
|
* Display Stats.
|
|
*/
|
|
public function index(): \Illuminate\Contracts\View\Factory|\Illuminate\View\View
|
|
{
|
|
return view('Staff.uploader.index', [
|
|
'uploaders' => User::with(['group'])
|
|
->withCount('torrents as total_uploads')
|
|
->whereRelation('group', 'is_uploader', '=', true)
|
|
// Count recent uploads for current user
|
|
->withCount(['torrents as recent_uploads' => fn ($query) => $query
|
|
->where('created_at', '>', now()->subDays(60))
|
|
])
|
|
// Count total personal releases for current user
|
|
->withCount(['torrents as total_personal_releases' => fn ($query) => $query
|
|
->where('personal_release', '=', true)
|
|
])
|
|
// Count recent personal releases for current user
|
|
->withCount(['torrents as recent_personal_releases' => fn ($query) => $query
|
|
->where('personal_release', '=', true)
|
|
->where('created_at', '>', now()->subDays(60))
|
|
])
|
|
->orderBy('group_id')
|
|
->get(),
|
|
]);
|
|
}
|
|
}
|