<?php
namespace Mgleis\DiskUsageInsights\Frontend\Controller;

use Mgleis\DiskUsageInsights\Domain\Database;
use Mgleis\DiskUsageInsights\Domain\DatabaseRepository;
use Mgleis\DiskUsageInsights\Frontend\Table;
use Mgleis\DiskUsageInsights\Plugin;
use Mgleis\DiskUsageInsights\WpHelper;

class ShowResultsController {

    private Database $database;

    public function execute() {
        // TODO Validate
        $snapshotName = sanitize_file_name(wp_unslash($_GET['snapshot'] ?? ''));

        $this->database = (new DatabaseRepository())->loadDatabase($snapshotName);
        $sn = $this->database->snapshotRepository->load();
        if ($sn->collectPhaseFinished !== 1) {
            echo "Cannot read database because it is corrupt/incomplete. Please create a new snapshot.";
            exit;
        }

        // TODO validate
        $snapshot = sanitize_file_name(wp_unslash($_GET['snapshot'] ?? ''));
        $root = $sn->root;
        $totalSize = $this->selectInt("SELECT SUM(size) FROM fileentries;");

        $WP_PLUGIN_URL = WpHelper::getPluginUrl();
        $WP_NONCE = wp_create_nonce(Plugin::NONCE);
        $WP_ADMIN_AJAX_URL = admin_url('admin-ajax.php');
        $WP_SNAPSHOT_FILE = $snapshot;

        // Bar Chart
        $wpCoreSize = $this->selectInt("SELECT SUM(size) FROM fileentries WHERE is_wp_core_file = 1;");
        $uploadsSize = $this->selectInt("SELECT dir_recursive_size FROM fileentries WHERE name = 'uploads';"); // TODO wrong
        $themesSize = $this->selectInt("SELECT dir_recursive_size FROM fileentries WHERE name = 'themes';"); // TODO wrong
        $pluginsSize = $this->selectInt("SELECT dir_recursive_size FROM fileentries WHERE name = 'plugins';"); // TODO wrong
        $wpContentSize = $this->selectInt("SELECT dir_recursive_size FROM fileentries WHERE name = 'wp-content';") // TODO wrong
            - $themesSize - $pluginsSize;
        $barChart = [
            ['label' => 'WP Core',      'percent' => round(100 * $wpCoreSize / $totalSize), 'gb' => round($wpCoreSize / 1_000_000, 1)],
            ['label' => 'Uploads',      'percent' => round(100 * $uploadsSize / $totalSize), 'gb' => round($uploadsSize / 1_000_000, 1)],
            ['label' => 'Themes',       'percent' => round(100 * $themesSize / $totalSize), 'gb' => round($themesSize / 1_000_000, 1)],
            ['label' => 'Plugins',      'percent' => round(100 * $pluginsSize / $totalSize), 'gb' => round($pluginsSize / 1_000_000, 1)],
            ['label' => 'wp-content',   'percent' => round(100 * $wpContentSize / $totalSize), 'gb' => round($wpContentSize / 1_000_000, 1)],
        ];

        include_once __DIR__ . '/../../../views/results.php';
    }

    private function selectInt(string $sql) {
        $stmt = $this->database->q->db->prepare($sql);
        $stmt->execute();
        $result = $stmt->fetch();

        return $result[0];
    }

    private function fetchAssoc(string $sql): array {
        $stmt = $this->database->q->db->prepare($sql);
        $stmt->execute();
        $rows = $stmt->fetchAll(\PDO::FETCH_ASSOC);

        return $rows;
    }
}