From 12202f04511c14844641edce879afd81e10e767b Mon Sep 17 00:00:00 2001
From: Frédéric Guillot <fred@kanboard.net>
Date: Thu, 30 Nov 2017 12:34:45 -0800
Subject: Add command to disable projects not touched during one year

---
 app/Console/BaseCommand.php           |  1 +
 app/Console/ProjectArchiveCommand.php | 30 ++++++++++++++++++++++++++++++
 2 files changed, 31 insertions(+)
 create mode 100644 app/Console/ProjectArchiveCommand.php

(limited to 'app/Console')

diff --git a/app/Console/BaseCommand.php b/app/Console/BaseCommand.php
index 50417071..09059ecf 100644
--- a/app/Console/BaseCommand.php
+++ b/app/Console/BaseCommand.php
@@ -11,6 +11,7 @@ use Symfony\Component\Console\Command\Command;
  * @package  console
  * @author   Frederic Guillot
  *
+ * @property \PicoDb\Database                                   $db
  * @property \Kanboard\Validator\PasswordResetValidator         $passwordResetValidator
  * @property \Kanboard\Export\SubtaskExport                     $subtaskExport
  * @property \Kanboard\Export\TaskExport                        $taskExport
diff --git a/app/Console/ProjectArchiveCommand.php b/app/Console/ProjectArchiveCommand.php
new file mode 100644
index 00000000..2470bf7b
--- /dev/null
+++ b/app/Console/ProjectArchiveCommand.php
@@ -0,0 +1,30 @@
+<?php
+
+namespace Kanboard\Console;
+
+use Kanboard\Model\ProjectModel;
+use Symfony\Component\Console\Input\InputInterface;
+use Symfony\Component\Console\Output\OutputInterface;
+
+class ProjectArchiveCommand extends BaseCommand
+{
+    protected function configure()
+    {
+        $this
+            ->setName('projects:archive')
+            ->setDescription('Disable projects not touched during one year');
+    }
+
+    protected function execute(InputInterface $input, OutputInterface $output)
+    {
+        $projects = $this->db->table(ProjectModel::TABLE)
+            ->eq('is_active', 1)
+            ->lt('last_modified', strtotime('-1 year'))
+            ->findAll();
+
+        foreach ($projects as $project) {
+            $output->writeln('Deactivating project: #'.$project['id'].' - '.$project['name']);
+            $this->projectModel->disable($project['id']);
+        }
+    }
+}
-- 
cgit v1.2.3