From db85c86418be70bd13b985764b462ad2a3e8bc7f Mon Sep 17 00:00:00 2001
From: Vincent Vanwaelscappel <vincent@cubedesigners.com>
Date: Tue, 17 Jan 2023 10:47:21 +0100
Subject: [PATCH] wait #5686 @1

---
 .docker/config/mariadb/logs.cnf         |  4 +-
 app/Console/Kernel.php                  |  1 +
 app/Jobs/Maintenance/CleanDownloads.php | 52 +++++++++++++++++++++++++
 3 files changed, 55 insertions(+), 2 deletions(-)
 create mode 100644 app/Jobs/Maintenance/CleanDownloads.php

diff --git a/.docker/config/mariadb/logs.cnf b/.docker/config/mariadb/logs.cnf
index 0d659f632..2a54d170e 100644
--- a/.docker/config/mariadb/logs.cnf
+++ b/.docker/config/mariadb/logs.cnf
@@ -1,8 +1,8 @@
 [mariadb]
 skip-log-error
 
-general_log         = 1
+general_log         = 0
 general_log_file    = /var/log/mysql/queries.log
 
-slow_query_log      = 1
+slow_query_log      = 0
 slow_query_log_file    = /var/log/mysql/slow_queries.log
diff --git a/app/Console/Kernel.php b/app/Console/Kernel.php
index 0be0d13be..3517b01cc 100644
--- a/app/Console/Kernel.php
+++ b/app/Console/Kernel.php
@@ -28,6 +28,7 @@ class Kernel extends \Cubist\Backpack\Console\Kernel
 
         $schedule->command('cubist:magic:precache')->everyFiveMinutes();
         $schedule->command('job:dispatch ProcessTotals')->everyTwoHours();
+        $schedule->command('job:dispatch Maintenance\\CleanDownloads')->dailyAt('4:00');
         $schedule->command('fluidbook:farm:ping')->everyMinute();
         $schedule->command('fluidbook:player:updatesources')->everyTwoHours();
         $schedule->command('ws:migrate --publications=v2 --documents=missing')->dailyAt('1:00');
diff --git a/app/Jobs/Maintenance/CleanDownloads.php b/app/Jobs/Maintenance/CleanDownloads.php
new file mode 100644
index 000000000..78cd628a1
--- /dev/null
+++ b/app/Jobs/Maintenance/CleanDownloads.php
@@ -0,0 +1,52 @@
+<?php
+
+namespace App\Jobs\Maintenance;
+
+use App\Jobs\Base;
+use Cubist\Util\Files\Files;
+
+class CleanDownloads extends Base
+{
+    public function handle()
+    {
+        $days = 15;
+        $limit = time() - (3600 * 24 * $days);
+
+        $directoriesToClean = [protected_path('signedexe/')];
+
+        $types = ['elearningmedia', 'elearningpackage', 'quiz', 'fluidbookcollection', 'fluidbookpublication'];
+        foreach ($types as $type) {
+            $directoriesToClean[] = storage_path('app/public/' . $type . '/download/');
+            $directoriesToClean[] = protected_path($type . '/final/');
+        }
+
+        foreach ($directoriesToClean as $path) {
+            if (!file_exists($path) || !is_dir($path)) {
+                continue;
+            }
+            $path = rtrim($path, '/');
+            $it = Files::getDirectoryIterator($path);
+            foreach ($it as $file) {
+                /** @var $file \SplFileInfo */
+                if ($file->isDot()) {
+                    continue;
+                }
+                if ($file->isLink()) {
+                    continue;
+                }
+                if ($file->getMTime() >= $limit) {
+                    continue;
+                }
+                $pathname = $file->getPathname();
+                if ($file->isFile()) {
+                    $type = 'file';
+                    unlink($pathname);
+                } else {
+                    $type = 'dir';
+                    `rm -rf $pathname`;
+                }
+                echo "Deleted $type $pathname\n";
+            }
+        }
+    }
+}
-- 
2.39.5