diff options
| -rw-r--r-- | app/Console/BaseCommand.php | 1 | ||||
| -rw-r--r-- | app/Console/ProjectArchiveCommand.php | 30 | ||||
| -rw-r--r-- | app/ServiceProvider/CommandProvider.php | 2 | ||||
| -rw-r--r-- | doc/en_US/cli.markdown | 1 | ||||
| -rwxr-xr-x | doc/es_ES/cli.markdown | 1 | ||||
| -rw-r--r-- | doc/ru_RU/cli.markdown | 1 | ||||
| -rw-r--r-- | doc/tr_TR/cli.markdown | 1 |
7 files changed, 37 insertions, 0 deletions
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']); + } + } +} diff --git a/app/ServiceProvider/CommandProvider.php b/app/ServiceProvider/CommandProvider.php index b31162b8..0c6ca5ee 100644 --- a/app/ServiceProvider/CommandProvider.php +++ b/app/ServiceProvider/CommandProvider.php @@ -11,6 +11,7 @@ use Kanboard\Console\LocaleSyncCommand; use Kanboard\Console\PluginInstallCommand; use Kanboard\Console\PluginUninstallCommand; use Kanboard\Console\PluginUpgradeCommand; +use Kanboard\Console\ProjectArchiveCommand; use Kanboard\Console\ProjectDailyColumnStatsExportCommand; use Kanboard\Console\ProjectDailyStatsCalculationCommand; use Kanboard\Console\ResetPasswordCommand; @@ -46,6 +47,7 @@ class CommandProvider implements ServiceProviderInterface $application->add(new TaskOverdueNotificationCommand($container)); $application->add(new SubtaskExportCommand($container)); $application->add(new TaskExportCommand($container)); + $application->add(new ProjectArchiveCommand($container)); $application->add(new ProjectDailyStatsCalculationCommand($container)); $application->add(new ProjectDailyColumnStatsExportCommand($container)); $application->add(new TransitionExportCommand($container)); diff --git a/doc/en_US/cli.markdown b/doc/en_US/cli.markdown index 9ee8ae62..c85b0cff 100644 --- a/doc/en_US/cli.markdown +++ b/doc/en_US/cli.markdown @@ -52,6 +52,7 @@ Available commands: plugin:uninstall Remove a plugin plugin:upgrade Update all installed plugins projects + projects:archive Disable projects not touched during one year projects:daily-stats Calculate daily statistics for all projects trigger trigger:tasks Trigger scheduler event for all tasks diff --git a/doc/es_ES/cli.markdown b/doc/es_ES/cli.markdown index ec46bdd6..0c76c6aa 100755 --- a/doc/es_ES/cli.markdown +++ b/doc/es_ES/cli.markdown @@ -47,6 +47,7 @@ Available commands: plugin:uninstall Eliminar plugin plugin:upgrade Actualizar todos los plugins instalados projects + projects:archive Disable projects not touched during one year projects:daily-stats Calcular diariamente las estadisticas para todos los proyectos trigger trigger:tasks Disparadores de eventos calendarizados para todas las tareas diff --git a/doc/ru_RU/cli.markdown b/doc/ru_RU/cli.markdown index 5ac2b4ec..2e93ff3d 100644 --- a/doc/ru_RU/cli.markdown +++ b/doc/ru_RU/cli.markdown @@ -50,6 +50,7 @@ Available commands: plugin:uninstall Remove a plugin plugin:upgrade Update all installed plugins projects + projects:archive Disable projects not touched during one year projects:daily-stats Calculate daily statistics for all projects trigger trigger:tasks Trigger scheduler event for all tasks diff --git a/doc/tr_TR/cli.markdown b/doc/tr_TR/cli.markdown index 260921c9..aa7fdec9 100644 --- a/doc/tr_TR/cli.markdown +++ b/doc/tr_TR/cli.markdown @@ -50,6 +50,7 @@ Available commands: plugin:uninstall Remove a plugin plugin:upgrade Update all installed plugins projects + projects:archive Disable projects not touched during one year projects:daily-stats Calculate daily statistics for all projects trigger trigger:tasks Trigger scheduler event for all tasks |