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