forked from Wunderbyte-GmbH/moodle-mod_booking
/
importexcel.php
123 lines (95 loc) · 3.84 KB
/
importexcel.php
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
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
<?php
/**
* Import excel data - change activity completion to user
*
* @package Booking
* @copyright 2015 Andraž Prinčič www.princic.net
* @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
* */
require_once("../../config.php");
require_once("locallib.php");
require_once('importexcel_form.php');
$id = required_param('id', PARAM_INT); // Course Module ID
$url = new moodle_url('/mod/booking/importexcel.php', array('id' => $id));
$urlRedirect = new moodle_url('/mod/booking/view.php', array('id' => $id));
$PAGE->set_url($url);
if (!$cm = get_coursemodule_from_id('booking', $id)) {
print_error("Course Module ID was incorrect");
}
if (!$course = $DB->get_record("course", array("id" => $cm->course))) {
print_error('coursemisconf');
}
require_course_login($course, false, $cm);
$groupmode = groups_get_activity_groupmode($cm);
if (!$booking = booking_get_booking($cm, '')) {
error("Course module is incorrect");
}
if (!$context = context_module::instance($cm->id)) {
print_error('badcontext');
}
require_capability('mod/booking:updatebooking', $context);
$PAGE->navbar->add(get_string("importexceltitle", "booking"));
$PAGE->set_title(format_string($booking->name));
$PAGE->set_heading($course->fullname);
$PAGE->set_pagelayout('standard');
$mform = new importexcel_form($url);
//Form processing and displaying is done here
if ($mform->is_cancelled()) {
//Handle form cancel operation, if cancel button is present on form
redirect($urlRedirect, '', 0);
die;
} else if ($fromform = $mform->get_data()) {
$csvfile = $mform->get_file_content('excelfile');
$lines = explode(PHP_EOL, $csvfile);
$csvArr = array();
foreach ($lines as $line) {
$csvArr[] = str_getcsv($line);
}
$optionIDPos = -1;
$userIDPos = -1;
$completedPos = -1;
foreach ($csvArr[0] as $key => $value) {
switch ($value) {
case get_string("optionid", "booking"):
$optionIDPos = $key;
break;
case get_string("user") . " " . get_string("idnumber"):
$userIDPos = $key;
break;
case get_string("searchFinished", "booking"):
$completedPos = $key;
break;
default:
break;
}
}
if ($optionIDPos > -1 && $userIDPos > -1 && $completedPos > -1) {
array_shift($csvArr);
$completion = new completion_info($course);
foreach ($csvArr as $line) {
if (count($line) >= 3) {
$user = $DB->get_record('booking_answers', array('bookingid' => $booking->id, 'userid' => $line[$userIDPos], 'optionid' => $line[$optionIDPos]));
if ($user !== FALSE) {
$user->completed = $line[$completedPos];
$user->timemodified = time();
$DB->update_record('booking_answers', $user, false);
if ($completion->is_enabled($cm) && $booking->enablecompletion && $user->completed == 0) {
$completion->update_state($cm, COMPLETION_INCOMPLETE, $user->userid);
}
if ($completion->is_enabled($cm) && $booking->enablecompletion && $user->completed == 1) {
$completion->update_state($cm, COMPLETION_COMPLETE, $user->userid);
}
}
}
}
redirect($urlRedirect, get_string('importfinished', 'booking'), 5);
} else {
redirect($urlRedirect, get_string('wrongfile', 'booking'), 5);
}
//In this case you process validated data. $mform->get_data() returns data posted in form.
} else {
echo $OUTPUT->header();
echo $OUTPUT->heading(get_string("importexceltitle", "booking"), 3, 'helptitle', 'uniqueid');
$mform->display();
}
echo $OUTPUT->footer();