if (substr($key, 0, 4) == 'fach') {
$fach_id = substr($key, 4);
$f = new Fach();
$f->load($fach_id);
$f->setName($_POST[$key]);
$f->save();
}
}
} else {
// aus †bergabevariablen zu deaktivierende klasse_id bestimmen
foreach ($_POST as $key => $value) {
if (substr($key, 0, 7) === 'deaktiv') {
$fach_id = substr($key, 7);
}
}
$f = new Fach();
$f->load($fach_id);
$f->setAktiv("FALSE");
$f->save();
}
$action = 'show';
$what = 'fach';
include 'controller/show.php';
break;
case 'raum':
if (key_exists('update', $_POST)) {
// alle aktiven updaten
foreach ($_POST as $key => $value) {
if (substr($key, 0, 4) == 'raum') {
$raum_id = substr($key, 4);
$r = new Raum();
<?php
$f = new Fach();
$faechers = $f->getAllAsArray();
$htmlf = new HtmlFach($faechers);
?>
<!-- div zum Positionieren -->
<div style="position:absolute; left:100px;">
<!-- Seiten-Überschrift -->
<h2>Fächerliste</h2>
<!--Überschriften zur Unterteilung von aktiven und inaktiven Fächern -->
<h3> Aktive Fächer</h3>
<!-- Tabelle für aktive Fächer - bisher nur zum Auslesen-->
<table border="0">
<tr align="center">
<td colspan="3"><b>Fach</b></td>
</tr>
<!-- Fach hinzufügen am Tabellenanfang -->
<tr>
<td><input type="text" name="newFach"></td>
<td colspan="2"><input type="submit" name="add_class" value="Fach hinzufügen"></td>
</tr>
<tr align="center">
<td colspan="3"><input type="reset" name="reset" value="reset"></td>
</tr>
<!-- eingebaute Leerzeile zur Übersichtlichkeit am Anfang der Tabelle -->
}
if (!isset($pw2)) {
$pw2 = '';
}
include 'views/' . $action . $what . '.php';
break;
case 'registerklasse':
$k = new Klasse();
$klassens = $k->getAllAsArray(' AND aktiv=TRUE ');
$htmlk = new HtmlKlasse($klassens);
$klassen_inaktivs = $k->getAllAsArray(' AND aktiv="FALSE" ');
$htmlk_inaktiv = new HtmlKlasse($klassen_inaktivs);
include 'views/' . $action . $what . '.php';
break;
case 'fach':
$f = new Fach();
$fachs = $f->getAllAsArray(' AND aktiv=TRUE ');
$htmlf = new HtmlFach($fachs);
$fach_inaktivs = $f->getAllAsArray(' AND aktiv="FALSE" ');
$htmlf_inaktiv = new HtmlFach($fach_inaktivs);
include 'views/' . $action . $what . '.php';
break;
case 'raum':
$r = new Raum();
$raums = $r->getAllAsArray(' AND aktiv=TRUE ');
$htmlr = new HtmlRaum($raums);
$raum_inaktivs = $r->getAllAsArray(' AND aktiv="FALSE" ');
$htmlr_inaktiv = new HtmlRaum($raum_inaktivs);
include 'views/' . $action . $what . '.php';
break;
case 'news':
public function getAlteFaecher()
{
$group = UtilGroup::createGroupByFach();
if ($this->isLoggedIn()) {
if ($this->conn->isConnected()) {
$s = "SELECT f.Kennzahl, f.Teilkennziffer, f.Name, f.WS_SS, f.Status, f.SWS, f.CP, f.Herkunft, f.AnzLeistungen, f.AnzahlDozenten, n.Datum FROM fach f LEFT JOIN hatleistung n ON (n.Kennzahl=f.Kennzahl and n.Teilkennziffer=f.Teilkennziffer) WHERE n.PDozentID=" . $this->id . " ORDER BY f.Kennzahl";
$q = new DBQuery($s);
if ($res = $this->conn->executeQuery($q)) {
while ($r = $res->getNextRow()) {
$f = new Fach($this->conn);
$f->init2($r[0], $r[1], $r[2], $r[3], $r[4], $r[5], $r[6], $r[7], $r[8]);
$f->setAnzahlDozenten($r[9]);
$group->addFach($f, $r[10]);
}
return $group;
} else {
$this->last_error = "Fehler beim Auslesen der alten Fächer." . $this->conn->getLastError();
return false;
}
// if-else
} else {
$this->last_error = "Keine Verbindung zur Datenbank.";
return false;
}
} else {
$this->last_error = "Sie sind nicht eingeloggt.";
return false;
}
}
}
} else {
echo '<h3>No file has been selected.</h3>';
}
$action = 'show';
$what = 'raum';
include 'controller/show.php';
break;
case 'raum':
$raum = $_POST['raum'];
$r = new Raum();
$r->setName($raum);
$r->setAktiv(TRUE);
$r->save();
$action = 'show';
$what = 'raum';
include 'controller/show.php';
break;
case 'fach':
$fach = $_POST['fach'];
$f = new Fach();
$f->setName($fach);
$f->setAktiv(TRUE);
$f->save();
$action = 'show';
$what = 'fach';
include 'controller/show.php';
break;
default:
break;
}
<?php
$f = new Fach();
$fachs = $f->getAllAsArray();
$htmlf = new HtmlFach($fachs);
$r = new Raum();
$raums = $r->getAllAsArray();
$htmlr = new HtmlRaum($raums);
$l = new Lehrer();
$lehrers = $l->getAllAsArray();
$htmll = new HtmlLehrer($lehrers);
$weekdays = WEEKDAYS;
$klasse_id = 1;
$b = new Block();
$blocks = $b->getAllAsObject();
$k = new Klasse();
$klassens = $k->getAllAsArray();
$klassens = Html::arrayArrayToNameArray($klassens);
$k_pdm = Html::buildPullDownMenu("klasse_id", $klassens);
/*
// brauche fachs als Array mit id als key und name als value
$lehrers_name = Html::objektArrayToNameArray($lehrers);
$lehrer_pdm = Html::buildPullDownMenu('fach', $lehrers_name);
$lehrer_pdm = Html::addNoneOption($lehrer_pdm);
*/
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
<title>Wochenplaner</title>
<link type="text/css" href="views/Style.css" rel="stylesheet" />
public function getAllAsObject($restriction = '')
{
$sql = "SELECT *\n\t\t\t FROM fach \n\t\t\t WHERE 1=1 ";
$sql .= $restriction . ";";
try {
$result = mysql_query($sql);
if (!$result) {
throw new MysqlException();
}
$fachs = array();
while ($row = mysql_fetch_assoc($result)) {
$f = new Fach();
$f->setId($row['fach_id']);
$f->setName($row['name']);
$f->setAktiv($row['aktiv']);
$fachs[$f->getId()] = $f;
}
} catch (MysqlException $e) {
Html::showAll($e);
}
return $fachs;
}
public function addFach(Fach $f, $res)
{
if ($this->type != UtilGroup::GROUP_FACH) {
return false;
}
// Typ überprüfen
$i = $this->getArrayIndex($f->getKennzahl(), $f->getKennziffer());
if ($i == -1) {
$count = $this->count;
$this->ressourceArr[$count] = $f;
$this->ressourceVal[$count] = new UtilBuffer();
$this->ressourceVal[$count]->add($res);
$this->count++;
} else {
$this->ressourceVal[$i]->addUnique($res);
}
return true;
}
function fach($action)
{
require_once '../class/Fach.class.php';
isset($_POST['stundenplan_id']) ? $stundenplan_id = $_POST['stundenplan_id'] : ($stundenplan_id = '');
switch ($action) {
case "loadAll":
$faecher = Fach::loadAll(NULL, $stundenplan_id);
for ($i = 0; $i < Fach::countAll(NULL, $stundenplan_id); $i++) {
echo $faecher[$i][0] . "-";
echo $faecher[$i][1] . ";";
}
break;
case "getName":
isset($_POST['fach_id']) ? $fach_id = $_POST['fach_id'] : ($fach_id = '');
echo Fach::getNameByID(NULL, $fach_id);
break;
}
}
if (substr($key, 0, 4) == 'fach') {
$fach_id = substr($key, 4);
$f = new Fach();
$f->load($fach_id);
$f->setName($_POST[$key]);
$f->save();
}
}
} else {
// aus †bergabevariablen zu deaktivierende klasse_id bestimmen
foreach ($_POST as $key => $value) {
if (substr($key, 0, 7) === 'deaktiv') {
$fach_id = substr($key, 7);
}
}
$f = new Fach();
$f->load($fach_id);
$f->setAktiv("TRUE");
$f->save();
}
$action = 'show';
$what = 'fach';
include 'controller/show.php';
break;
case 'raum':
if (key_exists('update', $_POST)) {
// alle aktiven updaten
foreach ($_POST as $key => $value) {
if (substr($key, 0, 4) == 'raum') {
$raum_id = substr($key, 4);
$r = new Raum();
