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
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
|
<?php
require_once __DIR__ . '/consultation_controller.php';
/**
* Export controller for the consultation app.
*
* @author Jan-Hendrik Willms <tleilax+studip@gmail.com>
* @license GPL2 or any later version
* @since Stud.IP 4.3
*/
class Consultation_ExportController extends ConsultationController
{
public function before_filter(&$action, &$args)
{
parent::before_filter($action, $args);
if (!$this->range->isEditableByUser()) {
throw new AccessDeniedException();
}
}
public function bookings_action(bool $expired = false)
{
$csv = [];
$csv[] = [
_('Datum'),
_('Beginn'),
_('Ende'),
_('Person'),
_('Ort'),
_('Notiz'),
_('Grund'),
];
$blocks = ConsultationBlock::findByRange($this->range, 'ORDER BY start ASC', $expired);
foreach ($blocks as $block) {
foreach ($block->slots as $slot) {
foreach ($slot->bookings as $booking) {
$csv[] = [
strftime('%x', $slot->start_time),
date('H:i', $slot->start_time),
date('H:i', $slot->end_time),
$booking->user->getFullName(),
$slot->block->room,
$slot->note ?: $slot->block->note,
$booking->reason
];
}
}
}
$this->render_csv($csv, 'Terminvergabe-Anmeldungen-' . date('Ymd') . '.csv');
}
public function all_action(bool $expired = false)
{
$csv = [];
$csv[] = [
_('Datum'),
_('Beginn'),
_('Ende'),
_('Person'),
_('Ort'),
_('Notiz'),
_('Grund'),
];
$blocks = ConsultationBlock::findByRange($this->range, 'ORDER BY start ASC', $expired);
foreach ($blocks as $block) {
foreach ($block->slots as $slot) {
$csv[] = [
strftime('%x', $slot->start_time),
date('H:i', $slot->start_time),
date('H:i', $slot->end_time),
implode("\n", $slot->bookings->map(function ($booking) {
return $booking->user->getFullName();
})),
$slot->block->room,
$slot->note ?: $slot->block->note,
implode("\n", $slot->bookings->map(function ($booking) {
return $booking->reason;
})),
];
}
}
$this->render_csv($csv, 'Terminvergabe-' . date('Ymd') . '.csv');
}
public function print_action($block_id)
{
$this->blocks = $block_id === 'bulk'
? $this->loadBlock(Request::intArray('ids'))
: [$this->loadBlock($block_id)];
$this->set_layout(null);
}
}
|
