DashboardController.php 3.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102
  1. <?php
  2. namespace App\Controllers;
  3. use App\Web\Session;
  4. use League\Flysystem\FileNotFoundException;
  5. use Slim\Http\Request;
  6. use Slim\Http\Response;
  7. class DashboardController extends Controller
  8. {
  9. const PER_PAGE = 21;
  10. const PER_PAGE_ADMIN = 25;
  11. /**
  12. * @param Request $request
  13. * @param Response $response
  14. * @return Response
  15. */
  16. public function redirects(Request $request, Response $response): Response
  17. {
  18. return $response->withRedirect('/home');
  19. }
  20. /**
  21. * @param Request $request
  22. * @param Response $response
  23. * @param $args
  24. * @return Response
  25. */
  26. public function home(Request $request, Response $response, $args): Response
  27. {
  28. $page = isset($args['page']) ? (int)$args['page'] : 0;
  29. $page = max(0, --$page);
  30. if (Session::get('admin', false)) {
  31. $medias = $this->database->query('SELECT `uploads`.*, `users`.`user_code`, `users`.`username` FROM `uploads` LEFT JOIN `users` ON `uploads`.`user_id` = `users`.`id` ORDER BY `timestamp` DESC LIMIT ? OFFSET ?', [self::PER_PAGE_ADMIN, $page * self::PER_PAGE_ADMIN])->fetchAll();
  32. $pages = $this->database->query('SELECT COUNT(*) AS `count` FROM `uploads`')->fetch()->count / self::PER_PAGE_ADMIN;
  33. } else {
  34. $medias = $this->database->query('SELECT `uploads`.*,`users`.`user_code`, `users`.`username` FROM `uploads` INNER JOIN `users` ON `uploads`.`user_id` = `users`.`id` WHERE `user_id` = ? ORDER BY `timestamp` DESC LIMIT ? OFFSET ?', [Session::get('user_id'), self::PER_PAGE, $page * self::PER_PAGE])->fetchAll();
  35. $pages = $this->database->query('SELECT COUNT(*) AS `count` FROM `uploads` WHERE `user_id` = ?', Session::get('user_id'))->fetch()->count / self::PER_PAGE;
  36. }
  37. $filesystem = $this->getStorage();
  38. foreach ($medias as $media) {
  39. $extension = pathinfo($media->filename, PATHINFO_EXTENSION);
  40. try {
  41. $mime = $filesystem->getMimetype($media->storage_path);
  42. $size = $filesystem->getSize($media->storage_path);
  43. } catch (FileNotFoundException $e) {
  44. $mime = null;
  45. }
  46. $media->mimetype = $mime;
  47. $media->extension = $extension;
  48. $media->size = $this->humanFilesize($size);
  49. }
  50. return $this->view->render(
  51. $response,
  52. Session::get('admin', false) ? 'dashboard/admin.twig' : 'dashboard/home.twig',
  53. [
  54. 'medias' => $medias,
  55. 'next' => $page < floor($pages),
  56. 'previous' => $page >= 1,
  57. 'current_page' => ++$page,
  58. ]
  59. );
  60. }
  61. /**
  62. * @param Request $request
  63. * @param Response $response
  64. * @return Response
  65. * @throws FileNotFoundException
  66. */
  67. public function system(Request $request, Response $response): Response
  68. {
  69. $usersCount = $this->database->query('SELECT COUNT(*) AS `count` FROM `users`')->fetch()->count;
  70. $mediasCount = $this->database->query('SELECT COUNT(*) AS `count` FROM `uploads`')->fetch()->count;
  71. $orphanFilesCount = $this->database->query('SELECT COUNT(*) AS `count` FROM `uploads` WHERE `user_id` IS NULL')->fetch()->count;
  72. $medias = $this->database->query('SELECT `users`.`user_code`, `uploads`.`code`, `uploads`.`storage_path` FROM `uploads` LEFT JOIN `users` ON `uploads`.`user_id` = `users`.`id`')->fetchAll();
  73. $totalSize = 0;
  74. $filesystem = $this->getStorage();
  75. foreach ($medias as $media) {
  76. $totalSize += $filesystem->getSize($media->storage_path);
  77. }
  78. return $this->view->render($response, 'dashboard/system.twig', [
  79. 'usersCount' => $usersCount,
  80. 'mediasCount' => $mediasCount,
  81. 'orphanFilesCount' => $orphanFilesCount,
  82. 'totalSize' => $this->humanFilesize($totalSize),
  83. 'max_filesize' => ini_get('post_max_size') . '/' . ini_get('upload_max_filesize'),
  84. ]);
  85. }
  86. }