core/index_tt_ajax.php at master · jmsperu/core · GitHub

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
<?php
/*
Gibbon, Flexible & Open School System
Copyright (C) 2010, Ross Parker

This program is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program. If not, see <http://www.gnu.org/licenses/>.
*/

@session_start() ;

//Gibbon system-wide includes
include "./functions.php" ;
include "./config.php" ;

//New PDO DB connection
try {
  	$connection2=new PDO("mysql:host=$databaseServer;dbname=$databaseName;charset=utf8", $databaseUsername, $databasePassword);
	$connection2->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
	$connection2->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
}
catch(PDOException $e) {
  echo $e->getMessage();
}

//Set up for i18n via gettext
if (isset($_SESSION[$guid]["i18n"]["code"])) {
	if ($_SESSION[$guid]["i18n"]["code"]!=NULL) {
		putenv("LC_ALL=" . $_SESSION[$guid]["i18n"]["code"]);
		setlocale(LC_ALL, $_SESSION[$guid]["i18n"]["code"]);
		bindtextdomain("gibbon", "./i18n");
		textdomain("gibbon");
		bind_textdomain_codeset("gibbon", 'UTF-8');
	}
}

//Setup variables
$output="" ;
if (isset($_GET["id"])) {
	$id=$_GET["id"] ;
}
else {
	$id="" ;
}

if (isActionAccessible($guid, $connection2, "/modules/Timetable/tt.php")==FALSE) {
	//Acess denied
	$output.="<div class='error'>" ;
		$output.=_("Your request failed because you do not have access to this action.") ;
	$output.="</div>" ;
}
else {
	include "./modules/Timetable/moduleFunctions.php" ;
	$ttDate="" ;
	if ($_POST["ttDate"]!="") {
		$ttDate=dateConvertToTimestamp(dateConvert($guid, $_POST["ttDate"]));
	}

	if ($_POST["fromTT"]=="Y") {
		if ($_POST["schoolCalendar"]=="on" OR $_POST["schoolCalendar"]=="Y") {
			$_SESSION[$guid]["viewCalendarSchool"]="Y" ;
		}
		else {
			$_SESSION[$guid]["viewCalendarSchool"]="N" ;
		}

		if ($_POST["personalCalendar"]=="on" OR $_POST["personalCalendar"]=="Y") {
			$_SESSION[$guid]["viewCalendarPersonal"]="Y" ;
		}
		else {
			$_SESSION[$guid]["viewCalendarPersonal"]="N" ;
		}

		if ($_POST["spaceBookingCalendar"]=="on" OR $_POST["spaceBookingCalendar"]=="Y") {
			$_SESSION[$guid]["viewCalendarSpaceBooking"]="Y" ;
		}
		else {
			$_SESSION[$guid]["viewCalendarSpaceBooking"]="N" ;
		}
	}

	$tt=renderTT($guid, $connection2, $_SESSION[$guid]["gibbonPersonID"], $id, FALSE, $ttDate) ;
	if ($tt!=FALSE) {
		$output.=$tt ;
	}
	else {
		$output.="<div class='error'>" ;
			$output.=_("There is no information for the date specified.") ;
		$output.="</div>" ;
	}
}

print $output ;
?>