| 1 |
<?php |
| 2 |
namespace Mgleis\DiskUsageInsights\Frontend\Controller\Report; |
| 3 |
|
| 4 |
use Mgleis\DiskUsageInsights\Domain\Database; |
| 5 |
use Mgleis\DiskUsageInsights\Frontend\Pagination; |
| 6 |
use Mgleis\DiskUsageInsights\Frontend\Table; |
| 7 |
use Mgleis\DiskUsageInsights\Plugin; |
| 8 |
use PDO; |
| 9 |
|
| 10 |
|
| 11 |
class ShowFoldersMostFilesController { |
| 12 |
|
| 13 |
public function execute(Database $database) { |
| 14 |
check_ajax_referer(Plugin::NONCE); |
| 15 |
|
| 16 |
$WP_ADMIN_AJAX_URL = admin_url('admin-ajax.php'); |
| 17 |
$WP_SNAPSHOT_FILE = sanitize_file_name(wp_unslash($_GET['snapshot'] ?? '')); |
| 18 |
|
| 19 |
$totalSize = $this->selectInt($database, "SELECT SUM(size) FROM fileentries;"); |
| 20 |
|
| 21 |
if (isset($_GET['p'])) { |
| 22 |
|
| 23 |
$pagination = Pagination::parseFromString(esc_url_raw(wp_unslash($_SERVER['REQUEST_URI'] ?? ''))); |
| 24 |
|
| 25 |
} else { |
| 26 |
|
| 27 |
$url = sprintf('%s?action=dui_results_table&table=%s&snapshot=%s', |
| 28 |
esc_url($WP_ADMIN_AJAX_URL), |
| 29 |
'folders-most-files', |
| 30 |
esc_js($WP_SNAPSHOT_FILE) |
| 31 |
); |
| 32 |
|
| 33 |
$totalFileCount = $this->selectInt($database, "SELECT COUNT(*) FROM fileentries WHERE type in ('dir') "); |
| 34 |
|
| 35 |
$pagination = new Pagination($url, $totalFileCount, 0, 10); |
| 36 |
} |
| 37 |
|
| 38 |
// |
| 39 |
// Folders with most files |
| 40 |
// |
| 41 |
$rows = $this->fetchAssoc($database, sprintf("SELECT * FROM fileentries WHERE type in ('dir') ORDER BY dir_count DESC LIMIT %s OFFSET %s", $pagination->getItemsPerPage(), $pagination->calcOffset())); |
| 42 |
$table = []; |
| 43 |
foreach ($rows as $row) { |
| 44 |
$fileEntry = $database->fileEntryRepository->findById($row['id']); |
| 45 |
$relativeName = $database->fileEntryRepository->calcFullPath($fileEntry); |
| 46 |
$table[] = [ |
| 47 |
$relativeName, |
| 48 |
number_format_i18n($row['dir_count']), |
| 49 |
number_format_i18n($row['dir_size']), |
| 50 |
number_format_i18n(round($row['dir_size'] / $row['dir_count'])) |
| 51 |
]; |
| 52 |
} |
| 53 |
(new Table( |
| 54 |
'Folders with most files', |
| 55 |
['Folder', 'File Count', 'File Size', 'Avg File Size'], |
| 56 |
['DUI-table__col--grow', 'DUI-table__col--number', 'DUI-table__col--number', 'DUI-table__col--number'] |
| 57 |
)) |
| 58 |
->withData($table) |
| 59 |
->withPagination($pagination) |
| 60 |
->output(); |
| 61 |
|
| 62 |
} |
| 63 |
|
| 64 |
private function fetchAssoc(Database $database, string $sql): array { |
| 65 |
$stmt = $database->q->db->prepare($sql); |
| 66 |
$stmt->execute(); |
| 67 |
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC); |
| 68 |
|
| 69 |
return $rows; |
| 70 |
} |
| 71 |
|
| 72 |
private function selectInt(Database $database, string $sql) { |
| 73 |
$stmt = $database->q->db->prepare($sql); |
| 74 |
$stmt->execute(); |
| 75 |
$result = $stmt->fetch(); |
| 76 |
|
| 77 |
return $result[0]; |
| 78 |
} |
| 79 |
|
| 80 |
} |
