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();
}