<?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\Peer;
use App\Traits\LivewireSort;
use Illuminate\Support\Facades\DB;
use Livewire\Attributes\Url;
use Livewire\Component;
use Livewire\WithPagination;

class PeerSearch extends Component
{
    use LivewireSort;
    use WithPagination;

    #TODO: Update URL attributes once Livewire 3 fixes upstream bug. See: https://github.com/livewire/livewire/discussions/7746

    #[Url(history: true)]
    public bool $sharedIpsOnly = false;

    #[Url(history: true)]
    public bool $sharedSocketsOnly = false;

    #[Url(history: true)]
    public bool $includeSeedsize = false;

    #[Url(history: true)]
    public int $perPage = 25;

    #[Url(history: true)]
    public string $ip = '';

    #[Url(history: true)]
    public string $port = '';

    #[Url(history: true)]
    public string $agent = '';

    #[Url(history: true)]
    public string $torrent = '';

    #[Url(history: true)]
    public string $connectivity = 'any';

    #[Url(history: true)]
    public string $active = 'any';

    #[Url(history: true)]
    public string $groupBy = 'none';

    #[Url(history: true)]
    public string $sortField = 'created_at';

    #[Url(history: true)]
    public string $sortDirection = 'desc';

    final public function updatingIp(): void
    {
        $this->resetPage();
    }

    final public function updatingPort(): void
    {
        $this->resetPage();
    }

    final public function updatingAgent(): void
    {
        $this->resetPage();
    }

    final public function updatingTorrent(): void
    {
        $this->resetPage();
    }

    final public function updatingGroupBy(): void
    {
        if ($this->groupBy === 'none' && $this->sortField === 'size') {
            $this->sortField = 'created_at';
        }
    }

    /**
     * @var \Illuminate\Contracts\Pagination\LengthAwarePaginator<int, Peer>
     */
    final protected \Illuminate\Contracts\Pagination\LengthAwarePaginator $peers {
        get => Peer::query()
            ->when(
                $this->groupBy === 'none',
                fn ($query) => $query
                    ->select([
                        'peers.torrent_id',
                        'peers.user_id',
                        'peers.uploaded',
                        'peers.downloaded',
                        'peers.left',
                        'peers.port',
                        'peers.agent',
                        'peers.created_at',
                        'peers.updated_at',
                        'peers.seeder',
                        'peers.active',
                        'peers.connectable',
                    ])
                    ->selectRaw('INET6_NTOA(peers.ip) as ip')
                    ->with(['user', 'user.group', 'torrent:id,name,size'])
            )
            ->when(
                $this->groupBy === 'user_session',
                fn ($query) => $query
                    ->select(['peers.user_id', 'peers.port', 'peers.agent'])
                    ->selectRaw('COUNT(DISTINCT peers.torrent_id) as torrent_id')
                    ->selectRaw('INET6_NTOA(peers.ip) as ip')
                    ->selectRaw('SUM(peers.uploaded) as uploaded')
                    ->selectRaw('SUM(peers.downloaded) as downloaded')
                    ->selectRaw('SUM(peers."left") as "left"')
                    ->selectRaw('MIN(peers.created_at) as created_at')
                    ->selectRaw('MAX(peers.updated_at) as updated_at')
                    ->selectRaw('COUNT(DISTINCT peers.torrent_id, peers.user_id, peers.peer_id) as peer_count')
                    ->selectRaw('SUM(peers.connectable = TRUE) as connectable_count')
                    ->selectRaw('SUM(peers.connectable = FALSE) as unconnectable_count')
                    ->selectRaw('SUM(peers.active = TRUE) as active_count')
                    ->selectRaw('SUM(peers.active = FALSE) as inactive_count')
                    ->selectRaw('ROUND(COALESCE(SUM(peers.active = FALSE) / SUM(peers.active = TRUE), 0), 2) as inactive_ratio')
                    ->groupBy(['peers.user_id', 'peers.agent', 'peers.ip', 'peers.port'])
                    ->with(['user', 'user.group'])
            )
            ->when(
                $this->groupBy === 'user_ip',
                fn ($query) => $query
                    ->select(['peers.user_id'])
                    ->selectRaw('COUNT(DISTINCT peers.torrent_id) as torrent_id')
                    ->selectRaw('COUNT(DISTINCT peers.agent) as agent')
                    ->selectRaw('INET6_NTOA(peers.ip) as ip')
                    ->selectRaw('COUNT(DISTINCT peers.port) as port')
                    ->selectRaw('SUM(peers.uploaded) as uploaded')
                    ->selectRaw('SUM(peers.downloaded) as downloaded')
                    ->selectRaw('SUM("left") as "left"')
                    ->selectRaw('MIN(peers.created_at) as created_at')
                    ->selectRaw('MAX(peers.updated_at) as updated_at')
                    ->selectRaw('COUNT(*) as peer_count')
                    ->selectRaw('SUM(peers.connectable = TRUE) as connectable_count')
                    ->selectRaw('SUM(peers.connectable = FALSE) as unconnectable_count')
                    ->selectRaw('SUM(peers.active = TRUE) as active_count')
                    ->selectRaw('SUM(peers.active = FALSE) as inactive_count')
                    ->selectRaw('ROUND(COALESCE(SUM(peers.active = FALSE) / SUM(peers.active = TRUE), 0), 2) as inactive_ratio')
                    ->groupBy(['peers.user_id', 'peers.ip'])
                    ->with(['user', 'user.group'])
            )
            ->when(
                $this->groupBy === 'user',
                fn ($query) => $query
                    ->select(['peers.user_id'])
                    ->selectRaw('COUNT(DISTINCT peers.torrent_id) as torrent_id')
                    ->selectRaw('COUNT(DISTINCT peers.agent) as agent')
                    ->selectRaw('COUNT(DISTINCT peers.ip) as ip')
                    ->selectRaw('COUNT(DISTINCT peers.port) as port')
                    ->selectRaw('SUM(peers.uploaded) as uploaded')
                    ->selectRaw('SUM(peers.downloaded) as downloaded')
                    ->selectRaw('SUM("left") as "left"')
                    ->selectRaw('MIN(peers.created_at) as created_at')
                    ->selectRaw('MAX(peers.updated_at) as updated_at')
                    ->selectRaw('COUNT(*) as peer_count')
                    ->selectRaw('SUM(peers.connectable = TRUE) as connectable_count')
                    ->selectRaw('SUM(peers.connectable = FALSE) as unconnectable_count')
                    ->selectRaw('SUM(peers.active = TRUE) as active_count')
                    ->selectRaw('SUM(peers.active = FALSE) as inactive_count')
                    ->selectRaw('ROUND(COALESCE(SUM(peers.active = FALSE) / SUM(peers.active = TRUE), 0), 2) as inactive_ratio')
                    ->groupBy(['peers.user_id'])
                    ->with(['user', 'user.group'])
            )
            ->when(
                $this->sharedIpsOnly,
                fn ($query) => $query
                    ->whereIn(
                        'peers.ip',
                        Peer::query()
                            ->select('ip')
                            ->fromSub(Peer::select('ip', 'user_id')->distinct(), 'distinct_ips')
                            ->groupBy('ip')
                            ->havingRaw('COUNT(*) > 1')
                    )
            )
            ->when(
                $this->sharedSocketsOnly,
                fn ($query) => $query
                    ->whereIn(
                        DB::raw('(peers.ip, peers.port)'),
                        Peer::query()
                            ->select('ip', 'port')
                            ->fromSub(Peer::select('ip', 'port', 'user_id')->distinct(), 'distinct_sockets')
                            ->groupBy('ip', 'port')
                            ->havingRaw('COUNT(*) > 1')
                    )
            )
            ->when(
                $this->includeSeedsize,
                fn ($query) => $query
                    ->join('torrents', 'peers.torrent_id', '=', 'torrents.id')
                    ->when(
                        $this->groupBy === 'none',
                        fn ($query) => $query
                            ->selectRaw('torrents.size as size')
                            ->selectRaw('CASE WHEN peers.connectable = TRUE THEN torrents.size ELSE 0 END as connectable_size')
                            ->selectRaw('CASE WHEN peers.connectable = FALSE THEN torrents.size ELSE 0 END as unconnectable_size'),
                        fn ($query) => $query
                            ->selectRaw('SUM(torrents.size) as size')
                            ->selectRaw('SUM(CASE WHEN peers.connectable = TRUE THEN torrents.size ELSE 0 END) as connectable_size')
                            ->selectRaw('SUM(CASE WHEN peers.connectable = FALSE THEN torrents.size ELSE 0 END) as unconnectable_size')
                    )
            )
            ->when($this->ip !== '', fn ($query) => $query->where(DB::raw('INET6_NTOA(ip)'), 'LIKE', $this->ip.'%'))
            ->when($this->port !== '', fn ($query) => $query->where('peers.port', 'LIKE', $this->port))
            ->when($this->agent !== '', fn ($query) => $query->where('peers.agent', 'LIKE', $this->agent.'%'))
            ->when($this->torrent !== '', fn ($query) => $query->whereRelation('torrent', 'name', 'LIKE', '%'.str_replace(' ', '%', $this->torrent).'%'))
            ->when($this->connectivity === 'connectable', fn ($query) => $query->where('connectable', '=', true))
            ->when($this->connectivity === 'unconnectable', fn ($query) => $query->where('connectable', '=', false))
            ->when($this->active === 'include', fn ($query) => $query->where('active', '=', true))
            ->when($this->active === 'exclude', fn ($query) => $query->where('active', '=', false))
            ->orderBy($this->sortField, $this->sortDirection)
            ->paginate($this->perPage);
    }

    final public function render(): \Illuminate\Contracts\View\Factory|\Illuminate\Contracts\View\View|\Illuminate\Contracts\Foundation\Application
    {
        return view('livewire.peer-search', [
            'peers' => $this->peers,
        ]);
    }
}