Add command to remove project activities after one year

2 files changed, 22 insertions, 0 deletions

diff --git a/app/Console/BaseCommand.php b/app/Console/BaseCommand.php
index 09059ecf..8ea67ae4 100644
--- a/app/Console/BaseCommand.php
+++ b/app/Console/BaseCommand.php
@@ -18,6 +18,7 @@ use Symfony\Component\Console\Command\Command;
  * @property \Kanboard\Export\TransitionExport                  $transitionExport
  * @property \Kanboard\Model\NotificationModel                  $notificationModel
  * @property \Kanboard\Model\ProjectModel                       $projectModel
+ * @property \Kanboard\Model\ProjectActivityModel               $projectActivityModel
  * @property \Kanboard\Model\ProjectPermissionModel             $projectPermissionModel
  * @property \Kanboard\Model\ProjectDailyColumnStatsModel       $projectDailyColumnStatsModel
  * @property \Kanboard\Model\ProjectDailyStatsModel             $projectDailyStatsModel
diff --git a/app/Console/ProjectActivityArchiveCommand.php b/app/Console/ProjectActivityArchiveCommand.php
new file mode 100644
index 00000000..18a4d7d7
--- /dev/null
+++ b/app/Console/ProjectActivityArchiveCommand.php
@@ -0,0 +1,21 @@
+<?php
+
+namespace Kanboard\Console;
+
+use Symfony\Component\Console\Input\InputInterface;
+use Symfony\Component\Console\Output\OutputInterface;
+
+class ProjectActivityArchiveCommand extends BaseCommand
+{
+    protected function configure()
+    {
+        $this
+            ->setName('projects:archive-activities')
+            ->setDescription('Remove project activities after one year');
+    }
+
+    protected function execute(InputInterface $input, OutputInterface $output)
+    {
+        $this->projectActivityModel->cleanup(strtotime('-1 year'));
+    }
+}