kanboard


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79

#!/usr/bin/env php
<?php

require __DIR__.'/app/common.php';

use Core\Cli;
use Core\Tool;
use Core\Translator;
use Model\Config;
use Model\Task;
use Model\TaskExport;
use Model\Notification;

$config = new Config($registry);

// Load translations
$language = $config->get('language', 'en_US');
if ($language !== 'en_US') Translator::load($language);

// Set timezone
date_default_timezone_set($config->get('timezone', 'UTC'));

// Setup CLI
$cli = new Cli;

// Usage
$cli->register('help', function() {
    echo 'Kanboard command line interface'.PHP_EOL.'==============================='.PHP_EOL.PHP_EOL;
    echo '- Task export to stdout (CSV format): '.$GLOBALS['argv'][0].' export-csv <project_id> <start_date> <end_date>'.PHP_EOL;
    echo '- Send notifications for due tasks: '.$GLOBALS['argv'][0].' send-notifications-due-tasks'.PHP_EOL;
});

// CSV Export
$cli->register('export-csv', function() use ($cli, $registry) {

    if ($GLOBALS['argc'] !== 5) {
        $cli->call($cli->default_command);
    }

    $project_id = $GLOBALS['argv'][2];
    $start_date = $GLOBALS['argv'][3];
    $end_date = $GLOBALS['argv'][4];

    $taskExport = new TaskExport($registry);
    $data = $taskExport->export($project_id, $start_date, $end_date);

    if (is_array($data)) {
        Tool::csv($data);
    }
});

// Send notification for tasks due
$cli->register('send-notifications-due-tasks', function() use ($cli, $registry) {

    $notificationModel = new Notification($registry);
    $taskModel = new Task($registry);
    $tasks = $taskModel->getOverdueTasks();

    // Group tasks by project
    $projects = array();

    foreach ($tasks as $task) {
        $projects[$task['project_id']][] = $task;
    }

    // Send notifications for each project
    foreach ($projects as $project_id => $project_tasks) {

        $users = $notificationModel->getUsersList($project_id);

        $notificationModel->sendEmails(
            'notification_task_due',
            $users,
            array('tasks' => $project_tasks, 'project' => $project_tasks[0]['project_name'])
        );
    }
});

$cli->execute();