function __construct($ynr, $nr)
{
if ($nr > 0 && $nr < 13) {
$this->monthNr = $nr;
$this->month = CswMonths::mon($nr);
}
if ($ynr > 10 && $ynr <= 30) {
$this->year = $ynr;
//calculate hollidays for current year
$h = getHolidays("20" . $ynr);
foreach ($h as $hday) {
$this->holidays[] = date("y-m-d", $hday->getDate());
$this->holidaysDesc[] = $hday->getDesc()['sv'];
}
}
}
grr_sql_free($res);
} else {
echo '<div class="row">' . PHP_EOL;
include "menu_gauche.php";
if ($_GET['pview'] != 1) {
echo '<div class="col-lg-9 col-md-12 col-xs-12">' . PHP_EOL;
echo '<div id="planning">' . PHP_EOL;
} else {
echo '<div id="print_planning">' . PHP_EOL;
}
include "chargement.php";
$ferie_true = 0;
$class = "";
$title = "";
if ($settings->get("show_holidays") == "Oui") {
$ferie = getHolidays($year);
$tt = mktime(0, 0, 0, $month, $day, $year);
foreach ($ferie as $key => $value) {
if ($tt == $value) {
$ferie_true = 1;
break;
}
}
$sh = getSchoolHolidays($tt, $year);
if ($sh['0'] == true) {
$class .= "vacance ";
$title = " " . $sh['1'];
}
if ($ferie_true) {
$class .= "ferie ";
}
for ($i = 0; $i < ConfigHelper::getConfig('phpui.timetable_days_forward'); $i++) {
$dt = mktime(0, 0, 0, $month, $day + $i, $year);
$daylist[$i] = $dt;
}
$date = mktime(0, 0, 0, $month, $day, $year);
$daysnum = date('t', $date);
for ($i = 1; $i < $daysnum + 1; $i++) {
$date = mktime(0, 0, 0, $month, $i, $year);
$days['day'][] = date('j', $date);
$days['dow'][] = date('w', $date);
$days['sel'][] = $i == $day;
}
$SESSION->save('backto', $_SERVER['QUERY_STRING']);
$SESSION->save('edate', sprintf('%04d/%02d/%02d', $year, $month, $day));
$today = mktime(0, 0, 0, date('n'), date('j'), date('Y'));
$SMARTY->assign('today', $today);
$SMARTY->assign('period', $DB->GetRow('SELECT MIN(date) AS fromdate, MAX(date) AS todate FROM events'));
$SMARTY->assign('eventlist', $eventlist);
$SMARTY->assign('listdata', $listdata);
$SMARTY->assign('days', $days);
$SMARTY->assign('day', $day);
$SMARTY->assign('daylist', $daylist);
$SMARTY->assign('month', $month);
$SMARTY->assign('year', $year);
$SMARTY->assign('date', $date);
$SMARTY->assign('userlist', $LMS->GetUserNames());
if (!ConfigHelper::checkConfig('phpui.big_networks')) {
$SMARTY->assign('customerlist', $LMS->GetCustomerNames());
}
$SMARTY->assign('getHolidays', getHolidays($year));
$SMARTY->display('event/eventlist.html');
$cur_day = $row[2];
$new_day = $row[3];
// echo $date." ".$new_day."<br>";
array_push($swap_days, [$date, $new_day]);
}
}
fclose($file);
return $swap_days;
}
//getHolidays("time_tables/holidays.csv");
//getSwapDays("time_tables/daySwap.csv");
function loadHolidays($holidays)
{
// $timezone = 'Asia/Kolkata';
date_default_timezone_set('Asia/Kolkata');
$conn = dbConnect();
foreach ($holidays as $holiday) {
$date = explode("-", $holiday[0]);
$day = $date[2];
$month = $date[1];
$year = $date[0];
$timestamp = mktime(12, 0, 0, $month, $day, $year);
$des = str_replace("'", "\\'", $holiday[1]);
echo $holiday[0] . ", " . date('d-m-y', $timestamp) . ", " . date('l dS \\o\\f F Y h:i:s A', $timestamp) . "<br>";
$sql = "INSERT INTO `mrbs_holidays`(`date`,`description`) VALUES('{$timestamp}','{$des}')";
$query = $conn->query($sql);
}
$conn->close();
}
loadHolidays(getHolidays("time_tables/holidays.csv"));
function show_holidays($year, $fromyear, $toyear, $flagdays = false, $lang = 'sv')
{
if ($fromyear != 0 and $toyear != 0) {
$hdays = array();
for ($yr = $fromyear; $yr <= $toyear; $yr++) {
$hd = getHolidays($yr, $flagdays);
$hdays = array_merge($hdays, $hd);
}
} else {
$hdays = getHolidays($year, $flagdays);
}
// Hämta helgdagarna
$rows = array();
$hasbad = false;
foreach ($hdays as $hd) {
$rows[] = $hd->mkrow($flagdays, $lang);
if ($hd->date <= 0) {
$hasbad = true;
break;
}
}
if ($hasbad) {
$last = getdate((1 << 30) + (1 << 29) + ((1 << 29) - 1));
// 2^31-1
$lyear = $last['year'] - 1;
if ($lang == 'sv') {
return '<p style="color: blue">Kanske har du angivit ett för sent
eller för tidigt årtal för detta datorsystem? Prova mellan
' . date("Y", 0) . ' och ' . $lyear . '.</p>';
} else {
return '<p style="color: blue">Perhaps you have a too late or too early year for this computer system? Try one between ' . date("Y", 0) . ' and ' . $lyear . '.</p>';
}
} else {
return '<table border="1" class="nobg">' . "<tr><th class=\"nobg\">" . ($lang == 'sv' ? $flagdays ? "Dag" : "Helgdag" : ($flagdays ? 'Day' : 'Holiday')) . "</th><th\nclass=\"nobg\">" . ($lang == 'sv' ? "Datum" : 'Date') . "</th>" . ($flagdays ? $lang == 'sv' ? "<th>Flaggdag</th>" : '<th>Flag day</th>' : "") . "</tr>\n" . implode("\n", $rows) . "\n</table>\n";
}
}
function getStafflyWorkHoursList()
{
$query = "\n\t\t\tSELECT staff.name AS staff_name,SUM(IF(hours_checked IS NULL,hours_own,hours_checked)) AS sum,\n\t\t\t\tROUND(SUM(IF(hours_checked IS NULL,hours_own,hours_checked))/" . getWorkingDays(option('date_range/from'), option('date_range/to'), getHolidays(), getOvertimedays(), false) . ",2) AS avg\n\t\t\tFROM schedule INNER JOIN people staff ON staff.id=schedule.uid\n\t\t\tWHERE completed=1 AND schedule.display=1\n\t\t";
$query = $this->dateRange($query, 'start', true);
$query .= "\tGROUP BY schedule.uid\n\t\t";
$query = $this->orderBy($query, 'sum', 'DESC');
return $this->db->query($query)->result_array();
}
*
*/
if (!defined('e107_INIT')) {
exit;
}
require_once e_PLUGIN . 'dateplus/_class.php';
$pref = e107::pref('dateplus');
$tp = e107::getParser();
$sc = e107::getScBatch('dateplus', true);
$template = e107::getTemplate('dateplus');
$curMonth = date('n');
$curDay = date('j');
$hs = hanukkahStart();
$he = hanukkahStart() + 691200;
$text = "";
$holidays = getHolidays($curMonth, $curDay);
foreach ($holidays as $holiday) {
$holiray[] = array($holiday[0], $holiday[1], $holiday[2]);
}
if ($pref['enableUserdays'] == true) {
$userdays = getUserdays($curMonth, $curDay);
foreach ($userdays as $userday) {
$holiray[] = array($userday[0], $userday[1], $userday[2]);
}
}
if (date('j/n/Y', $hs) == date('j/n/Y')) {
$holiray[] = array('Hanukkah starts', date('n', $hs), date('j', $hs));
}
if (date('j/n/Y', $he) == date('j/n/Y')) {
$holiray[] = array('Hanukkah ends', date('n', $he), date('j', $he));
}
$day_counter = 0;
$dates_array = array();
$calendar .= '
</tr>
</thead>
<tbody>
<tr>';
for ($x = 0; $x < $running_day; $x++) {
$calendar .= '
<td style="height: 200px;"></td>';
$days_in_this_week++;
}
for ($list_day = 1; $list_day <= $days_in_month; $list_day++) {
$style = $list_day == date('j') ? 'primary' : 'default';
$ec = 0;
$holidays = getHolidays($month, $list_day);
foreach ($holidays as $holiday) {
$event .= '<p class="small">' . $holiday[0] . '</p>';
$ec++;
}
if ($pref['enableUserdays'] == true) {
$userdays = getUserdays($month, $list_day);
foreach ($userdays as $userday) {
$event .= '<p class="small">' . $userday[0] . '</p>';
$ec++;
}
}
$hs = hanukkahStart();
$he = hanukkahStart() + 691200;
if (date('j/n/Y', $hs) == $list_day . '/' . $month . '/' . $year) {
$event .= '<p class="small">Hanukkah starts</p>';
function storeTT($TimeTable, $start, $end)
{
$conn = dbConnect();
$holidays = getHolidays();
$RoomIds = loadRoomIds();
$date = $start;
$swaps = getSwapDays("time_tables/daySwap.csv");
// print "End: ".$end."<br>";
while ($end >= $date) {
if (in_array($date, $holidays)) {
echo "Holiday: " . $date . "<br>";
// continue;
} else {
if (in_array($date, $swaps[0])) {
$i = array_search($date, $swaps[0]);
$day = $swaps[1][$i];
print "DaySwap: " . $date . "<br>";
} else {
$day = date("D", strtotime($date));
}
$daySchedule = $TimeTable[$day];
// print "<br> Before: ".$date.", ".$day."<br>";
foreach ($daySchedule as $values) {
$room = $values[0];
$roomId = $RoomIds[$room];
// print count($values[1])."<br>";
foreach ($values[1] as $value) {
// print "here..";
$course = trim($value[0], " \t\n\r\v");
$start_hour = date('H', strtotime($value[1]));
$start_min = date('i', strtotime($value[1]));
$end_hour = date('H', strtotime($value[2]));
$end_min = date('i', strtotime($value[2])) + date("i", strtotime('00:10:00'));
$s = mktime($start_hour, $start_min, 0, date("n", strtotime($date)), date("j", strtotime($date)), date("Y", strtotime($date)));
$e = mktime($end_hour, $end_min, 0, date("n", strtotime($date)), date("j", strtotime($date)), date("Y", strtotime($date)));
$sql = "INSERT INTO `mrbs_entry`(`start_time`, `end_time`,`room_id`,`name`, `type`, `description`)\n\t\t\t\t\t\t\tVALUES ('{$s}','{$e}','{$roomId}','{$course}','I','Regular Class')";
$conn->query($sql);
}
}
}
$date = date("Y-m-d", strtotime("+1 day", strtotime($date)));
// print "After: ".$date."<br>";
}
$conn->close();
}
