forked from hansnok/bookingrooms
/
lib.php
118 lines (102 loc) · 3.5 KB
/
lib.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
<?php
// This file is part of Moodle - http://moodle.org/
//
// Moodle 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.
//
// Moodle 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 Moodle. If not, see <http://www.gnu.org/licenses/>.
/**
*
*
* @package local
* @subpackage bookingrooms
* @copyright 2014 Francisco García Ralph (francisco.garcia.ralph@gmail.com)
* Nicolás Bañados Valladares (nbanados@alumnos.uai.cl)
* 2015 Sebastian Riveros(sriveros@alumnos.uai.cl)
* @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
*/
//function library, automatically included with by config.php
//Define here the functions that you would use in some pages.
defined('MOODLE_INTERNAL') || die();
require_once(dirname(__FILE__) . '/../../config.php'); //requiered
require_once("$CFG->libdir/formslib.php");
function hour_module($module) {
global $DB,$USER;
//in format HH:MM:SS (varchar)
//Define lthe hours for misreservas.php
$modules=$DB->get_record('bookingrooms_modules',array("id"=>$module));
$start=explode(":",$modules->hour_start);
$end=explode(":",$modules->hour_end);
$a=$start[0];$b=$start[1];$c=00; //hour;minute;second
$d=$end[0];$e=(int)$end[1];$f=00; //hour;minute;second
$minutes = str_replace(' ', '',$e);
$ModuleStart = new DateTime();
// Is left hour and minutes in 0 (midnigth)
$ModuleStart->setTime($a,$b,0);
$ModuleEnd = new DateTime();
// Is left hour and minutes in 0 (midnigth)
$ModuleEnd->setTime($d,$e,0);
$hour=array(
$ModuleStart,
$ModuloEnd
);
//var_dump($hour);
return $hour;
//returns $hour[start] y $hour[end]
}
function module_hour($unixtime, $factor = null){
$hour = date('G', $unixtime);
$minute = date('i', $unixtime);
$second = $hour*60*60 + $minute*60;
if($factor== null){
$factor = 15*60;
}
if($second > 19*60*60 + 10*60 +$factor){
return 8;
}else if($second > 15*60*60 + 40*60 + $factor){
return 7;
}else if($second > 16*60*60 + 10*60 + $factor){
return 6;
}else if($second > 14*60*60 + 10*60 + $factor){
return 5;
}else if($second > 12*60*60 + 40*60 + $factor){
return 4;
}else if($second > 11*60*60 + 30*60 + $factor){
return 3;
}else if($second > 10*60*60 + 0*60 + $factor){
return 2;
}else if($second > 8*60*60 + 30*60 + $factor){
return 1;
}else{
return 0;
}
}
function booking_availability($date){
global $DB,$USER,$CFG;
//format YYYY-MM-DD
$today = date('Y-m-d',time());
if( !$isbloked = $DB->get_record('bookingrooms_blocked', array("student_id"=>$USER->id, 'status'=>1))){
$sqlWeekBookings = "SELECT *
FROM {bookingrooms_reserves}
WHERE date_reserve >= ?
AND date_reserve <= ADDDATE(?, 7)
AND student_id = ? AND active = 1";
$weekBookings = $DB->get_records_sql($sqlWeekBookings, array($today, $today, $USER->id));
$todayBookings = $DB->count_records ( 'bookingrooms_reserves', array (
'student_id' => $USER->id,
'date_reserve' => date('Y-m-d',$date),
'active' => 1));
$books= array(count($weekBookings),$todayBookings);
}else{
$books = array($CFG->reservesWeek,$CFG->reservesDay);
}
return $books;
}