summaryrefslogtreecommitdiff
path: root/app/Controller/TaskImportController.php
blob: aff2d390dfb8c748ab417ed074778ccc1ccc65b1 (plain)
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
<?php

namespace Kanboard\Controller;

use Kanboard\Core\Csv;

/**
 * Task Import controller
 *
 * @package  Kanboard\Controller
 * @author   Frederic Guillot
 */
class TaskImportController extends BaseController
{
    /**
     * Upload the file and ask settings
     *
     * @param array $values
     * @param array $errors
     * @throws \Kanboard\Core\Controller\PageNotFoundException
     */
    public function show(array $values = array(), array $errors = array())
    {
        $project = $this->getProject();

        $this->response->html($this->helper->layout->project('task_import/show', array(
            'project' => $project,
            'values' => $values,
            'errors' => $errors,
            'max_size' => ini_get('upload_max_filesize'),
            'delimiters' => Csv::getDelimiters(),
            'enclosures' => Csv::getEnclosures(),
            'title' => t('Import tasks from CSV file'),
        ), 'task_import/sidebar'));
    }

    /**
     * Process CSV file
     */
    public function save()
    {
        $project = $this->getProject();
        $values = $this->request->getValues();
        $filename = $this->request->getFilePath('file');

        if (! file_exists($filename)) {
            $this->show($values, array('file' => array(t('Unable to read your file'))));
        } else {
            $this->taskImport->projectId = $project['id'];

            $csv = new Csv($values['delimiter'], $values['enclosure']);
            $csv->setColumnMapping($this->taskImport->getColumnMapping());
            $csv->read($filename, array($this->taskImport, 'import'));

            if ($this->taskImport->counter > 0) {
                $this->flash->success(t('%d task(s) have been imported successfully.', $this->taskImport->counter));
            } else {
                $this->flash->failure(t('Nothing have been imported!'));
            }

            $this->response->redirect($this->helper->url->to('TaskImportController', 'show', array('project_id' => $project['id'])));
        }
    }

    /**
     * Generate template
     *
     */
    public function template()
    {
        $this->response->withFileDownload('tasks.csv');
        $this->response->csv(array($this->taskImport->getColumnMapping()));
    }
}