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

#!/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;

$config = new Config($registry->shared('db'), $registry->shared('event'));

// 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;
});

// 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];

    Translator::disableEscaping();

    $task = new Task($registry->shared('db'), $registry->shared('event'));
    $data = $task->export($project_id, $start_date, $end_date);

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

$cli->execute();