}
if (isset($_REQUEST['InsertIntoDBhomecontrol_etagen']) && $_REQUEST['InsertIntoDBhomecontrol_etagen'] == "Speichern") {
$scDbTable->doInsert();
// $getMaxSql = "SELECT max(id) maxId FROM homecontrol_etagen";
// $rslt = $_SESSION['config']->DBCONNECT->executeQuery($getMaxSql);
// $r = mysql_fetch_array($rslt);
// exec("cp /var/www/pics/default_etage.jpg /var/www/pics/raumplan/".$r['maxId'].".jpg");
// $getMaxSql = "UPDATE homecontrol_etagen SET pic = 'pics/raumplan/".$r['maxId'].".jpg' WHERE id = ".$r['maxId'];
// //$getMaxSql = "UPDATE homecontrol_etagen SET pic = 'pics/default_etage.jpg' WHERE id = ".$r['maxId'];
// $rslt = $_SESSION['config']->DBCONNECT->executeQuery($getMaxSql);
$scDbTable->refresh();
}
// --------------------------------------------------
// Bearbeiten-Maske
// --------------------------------------------------
$tDel = $scDbTable->doDeleteFromUpdatemask();
if (method_exists($tDel, "show")) {
$fDel = new Form();
$fDel->add($tDel);
$fDel->show();
}
if (isset($_REQUEST["DbTableUpdate" . $scDbTable->TABLENAME])) {
$scDbTable->doUpdate();
}
$tblEtagen = new Table(array("Name", "Raumplan", "hochladen", "entfernen"));
$tblEtagen->setHeadEnabled(true);
$tblEtagen->setVAlign("middle");
$tblEtagen->setAlignments(array("left", "center", "center", "right"));
$tblEtagen->setBackgroundColorChange(true);
foreach ($scDbTable->ROWS as $etagenRow) {
$rowId = $etagenRow->getNamedAttribute("rowid");
$tblMain = new Table(array("", ""));
$t2 = new Title("Benutzer-Einstellungen");
$t2->setAlign("left");
$rMainT1 = $tblMain->createRow();
$rMainT1->setSpawnAll(true);
$rMainT1->setAttribute(0, $t2);
$tblMain->addRow($rMainT1);
$dbTblBenutzer = new DbTable($_SESSION['config']->DBCONNECT, 'user', array("Vorname", "Nachname", "User", "Status", "aktiv", "Pw"), "Vorname, Nachname, Benutzername, Status, Aktiv?, Passwort", "", "Nachname, Vorname");
$dbTblBenutzer->setHeaderEnabled(true);
$dbTblBenutzer->setDeleteInUpdate(true);
$dbTblBenutzer->setInvisibleCols(array("Pw"));
$dbTblBenutzer->setNoUpdateCols(array("Pw"));
$dbTblBenutzer->setColSizes(array("200", "40", "60", "90", "50", "50"));
$deleteMask = null;
if ($dbTblBenutzer->isDeleteInUpdate()) {
$deleteMask = !$dbTblBenutzer->doDeleteFromUpdatemask() ? null : $dbTblBenutzer->doDeleteFromUpdatemask();
}
if ($deleteMask != null) {
$rDel = $tblMain->createRow();
$rDel->setAttribute(0, $deleteMask);
$rDel->setSpawnAll(true);
$tblMain->addRow($rDel);
}
$newBenutzerBtn = new Text("");
// Neuer Eintrag
if (isset($_REQUEST['InsertIntoDBuser']) && $_REQUEST['InsertIntoDBuser'] == "Speichern") {
if (isset($_REQUEST['Pw']) && strlen($_REQUEST['Pw']) > 0) {
$_REQUEST['Pw'] = md5($_REQUEST['Pw']);
}
$dbTblBenutzer->doInsert();
$dbTblBenutzer->refresh();
<?php
$tblMain = new Table(array("", ""));
$t2 = new Title("Sender-Einstellungen");
$t2->setAlign("left");
$rMainT1 = $tblMain->createRow();
$rMainT1->setSpawnAll(true);
$rMainT1->setAttribute(0, $t2);
$tblMain->addRow($rMainT1);
$dbTblSender = new DbTable($_SESSION['config']->DBCONNECT, 'homecontrol_sender', array("name", "ip", "etage", "zimmer", "range_von", "range_bis", "default_jn"), "Name, IP, Etage, Zimmer, Bereich von:, Bis, Standard?", "", "default_jn, name");
$dbTblSender->setHeaderEnabled(true);
$dbTblSender->setDeleteInUpdate(true);
$dbTblSender->setColSizes(array("200", "40", "60", "90", "50", "50", "50"));
$deleteMask = null;
if ($dbTblSender->isDeleteInUpdate()) {
$deleteMask = !$dbTblSender->doDeleteFromUpdatemask() ? null : $dbTblSender->doDeleteFromUpdatemask();
}
if ($deleteMask != null) {
$rDel = $tblMain->createRow();
$rDel->setAttribute(0, $deleteMask);
$rDel->setSpawnAll(true);
$tblMain->addRow($rDel);
}
$newSwitchBtn = new Text("");
// Neuer Eintrag
if (isset($_REQUEST['InsertIntoDBhomecontrol_sender']) && $_REQUEST['InsertIntoDBhomecontrol_sender'] == "Speichern") {
checkDefaultSender($dbTblSender->ROWS);
$dbTblSender->doInsert();
$dbTblSender->refresh();
} else {
if (isset($_REQUEST[$dbTblSender->getNewEntryButtonName()])) {
$dbTblSender->setBorder(0);
