prepare("SELECT * FROM kalenterit"); $kalenterit->execute(); return $kalenterit->fetchAll(); } function getKaikkiAjat($dbh, $paiva) { $kaikkiajat = $dbh->prepare("SELECT id, tunti, paiva FROM paivakalenteri WHERE paiva = :paiva AND (REPLACE (tunti, ':', '') >= ".BUSINESS_HOUR_START_FIX."00 AND REPLACE (tunti, ':', '') <= ".BUSINESS_HOUR_END_FIX."00)"); $kaikkiajat->bindParam(':paiva', $paiva); $kaikkiajat->execute(); return $kaikkiajat->fetchAll(); } function getTunti($dbh, $id) { $tuntidata = $dbh->prepare("SELECT * FROM paivakalenteri_varaukset WHERE paivakalenteri_id = :id AND kalenteri = :kalenteri"); $tuntidata->bindParam(':id', $id); $tuntidata->bindParam(':kalenteri', $_SESSION['kalenteri']); $tuntidata->execute(); return $tuntidata->fetch(); } function getToimipiste($dbh, $id) { $toimipiste = $dbh->prepare("SELECT * FROM toimipisteet WHERE id = :id"); $toimipiste->bindParam(':id', $id); $toimipiste->execute(); $t = $toimipiste->fetch(); return $t['nimi']; } define("WEEK", date("W")+1); //define("YEAR", date("Y")); define("YEAR", '2019'); define("WEEKSINYEAR", date("W", mktime(00, 00, 00, 12, 28, YEAR))); $dayNum = date("N", strtotime('+6 hours')); $current = strtotime('next monday'); if($dayNum == 6 OR $dayNum == 7) { $current = strtotime("+7 days", $current); } if (isset($_GET['week'])): if (preg_match("/^[0-9]{4}W[0-9]{2}$/", $_GET['week'])): $current = strtotime($_GET['week']); endif; endif; if (isset($_GET['weeks']) && isset($_GET['years'])): $current = strtotime("{$_GET['years']}W" . (($_GET['weeks'] < 10) ? "0" : "") . $_GET['weeks']); endif; $paivat = array(); $paivat[] = date('Y-m-d',$current); $paivat[] = date('Y-m-d',strtotime("+1 days", $current)); $paivat[] = date('Y-m-d',strtotime("+2 days", $current)); $paivat[] = date('Y-m-d',strtotime("+3 days", $current)); $paivat[] = date('Y-m-d',strtotime("+4 days", $current)); ?> PMO

Varauskalenteri
Viikko / Viikko

Kalenteri

Ajanvaraus

Valitut ajat:
Ei valintoja.


  • Vapaa 0) { echo getToimipiste($dbh, $tunti_tiedot['toimipiste']); } ?> Varattu
    Opettaja:

    Oppilas: