/** * Zeigt die Eingabemaske an, wenn isset($_REQUEST['dbTableNew']) * ansonsten gibt die Methode false zurÃÂÃÂÃÂück. * * return boolean */ function showInsertMaskIfNeeded() { if (isset($_REQUEST['dbTableNew'])) { $insert = new DbTable($_SESSION['config']->DBCONNECT, "news", array("Title", "Text", "Datum", "Autor"), "Titel, Text, Datum, Autor", "Datum='" . date("Y-m-d") . "', Autor = '" . $_SESSION['config']->CURRENTUSER->VORNAME . " " . $_SESSION['config']->CURRENTUSER->NACHNAME . "' ", "Datum DESC"); $insert->setBorder(0); $insert->showInsertMask(); return true; } else { return false; } }
$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(); } else { if (isset($_REQUEST[$dbTblBenutzer->getNewEntryButtonName()])) { $dbTblBenutzer->setBorder(0); $insMsk = $dbTblBenutzer->getInsertMask(); $hdnFld = $insMsk->getAttribute(1); if ($hdnFld instanceof Hiddenfield) { $insMsk->setAttribute(1, new Hiddenfield($dbTblBenutzer->getNewEntryButtonName(), "-")); } $rNew = $tblMain->createRow(); $rNew->setAttribute(0, $insMsk); $rNew->setSpawnAll(true); $tblMain->addRow($rNew); $tblMain->addSpacer(0, 10); } else { $newBenutzerBtn = $dbTblBenutzer->getNewEntryButton("Neuen Benutzer anlegen"); } } if (isset($_REQUEST["DbTableUpdate" . $dbTblBenutzer->TABLENAME])) {
//$itemsTable->setColSizes(array(150)); $itemsTable->setBorder(0); $ttlItems = new Title("Zu schaltende Objekte"); $ttlItems->setAlign("left"); $itemsTable->addSpacer(0, 15); $r1Title = $itemsTable->createRow(); $r1Title->setSpawnAll(true); $r1Title->setAttribute(0, $ttlItems); $itemsTable->addRow($r1Title); // Neuer Eintrag if (isset($_REQUEST['InsertIntoDB' . $regelItemsDbTable->TABLENAME]) && $_REQUEST['InsertIntoDB' . $regelItemsDbTable->TABLENAME] == "Speichern") { $regelItemsDbTable->doInsert(); $regelItemsDbTable->refresh(); } else { if (isset($_REQUEST[$regelItemsDbTable->getNewEntryButtonName()])) { $regelItemsDbTable->setBorder(0); $insMsk = $regelItemsDbTable->getInsertMask(); $hdnFld = $insMsk->getAttribute(1); if ($hdnFld instanceof Hiddenfield) { $insMsk->setAttribute(1, new Hiddenfield($regelItemsDbTable->getNewEntryButtonName(), "-")); } $rNew = $itemsTable->createRow(); $rNew->setSpawnAll(true); $rNew->setAttribute(0, $insMsk); $itemsTable->addRow($rNew); $itemsTable->addSpacer(0, 10); } } if (isset($_REQUEST["DbTableUpdate" . $regelItemsDbTable->TABLENAME])) { $regelItemsDbTable->doUpdate(); }
if ($_SESSION['config']->CURRENTUSER->STATUS == "admin" && !$_SESSION['config']->CURRENTUSER->STATUS == "user") { $e = new Error("Kein Zugriff", " Sie haben keine Berechtigung für diesen Bereich!"); } $userTable = new DbTable($_SESSION['config']->DBCONNECT, "user", array("Vorname", "Nachname", "User", "Email", "Status"), "Vorname, Nachname, Benutzername, Email, Status", "", " Vorname ASC ", " User != 'Developer' AND User != 'admin' "); $userTable->setHeaderEnabled(true); $userTable->setDeleteInUpdate(true); $userTable->setToCheck("Vorname, Nachname, User, Email, Status"); // Neuer Eintrag if (isset($_REQUEST['InsertIntoDBuser']) && $_REQUEST['InsertIntoDBuser'] == "Speichern") { if ($userTable->doInsert()) { $userTable->refresh(); } $spc->show(); } else { if (isset($_REQUEST[$userTable->getNewEntryButtonName()])) { $userTable->setBorder(0); $insMsk = $userTable->getInsertMask(); $hdnFld = $insMsk->getAttribute(1); if ($hdnFld instanceof Hiddenfield) { $insMsk->setAttribute(1, new Hiddenfield($userTable->getNewEntryButtonName(), "-")); } $insMsk->show(); $spc->show(); } } $userTable->showUpdateMask(); $spc->show(); $form = new Form(); $form->add($userTable->getNewEntryButton("Neuen Benutzer anlegen")); $form->add(new Spacer()); $form->show();
// Zuordnung ausgewählt if (isset($_SESSION['SelectedCronToEdit']) && strlen($_SESSION['SelectedCronToEdit']) > 0) { $scItemsDbTable = new DbTable($_SESSION['config']->DBCONNECT, 'homecontrol_cron_items', array("config_id", "art_id", "zimmer_id", "etagen_id", "on_off", "cron_id"), "Objekt, Objekt-Art, Zimmer, Etage, An/Aus, Job", "cron_id=" . $_SESSION['SelectedCronToEdit'], "config_id DESC, zimmer_id DESC, etagen_id DESC", "cron_id=" . $_SESSION['SelectedCronToEdit']); $scItemsDbTable->setReadOnlyCols(array("id")); $scItemsDbTable->setNoInsertCols(array("id")); $scItemsDbTable->setNoUpdateCols(array("cron_id")); $scItemsDbTable->setDeleteInUpdate(true); $scItemsDbTable->setHeaderEnabled(true); $scItemsDbTable->setWidth("100%"); // Neuer Eintrag if (isset($_REQUEST['InsertIntoDBhomecontrol_cron_items']) && $_REQUEST['InsertIntoDBhomecontrol_cron_items'] == "Speichern") { $scItemsDbTable->doInsert(); $scItemsDbTable->refresh(); } else { if (isset($_REQUEST['dbTableNewhomecontrol_cron_items'])) { $scItemsDbTable->setBorder(0); $insMsk = $scItemsDbTable->getInsertMask(); $hdnFld = $insMsk->getAttribute(1); if ($hdnFld instanceof Hiddenfield) { $insMsk->setAttribute(1, new Hiddenfield("dbTableNewhomecontrol_cron_items", "-")); } $insMsk->show(); } } if (isset($_REQUEST["DbTableUpdate" . $scItemsDbTable->TABLENAME])) { $scItemsDbTable->doUpdate(); } $rZuordnung = $table->createRow(); $rZuordnung->setAttribute(0, $scItemsDbTable->getUpdateAllMask()); $rZuordnung->setSpawnAll(true); $table->addRow($rZuordnung);
} 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); $insMsk = $dbTblSender->getInsertMask(); $hdnFld = $insMsk->getAttribute(1); if ($hdnFld instanceof Hiddenfield) { $insMsk->setAttribute(1, new Hiddenfield($dbTblSender->getNewEntryButtonName(), "-")); } $rNew = $tblMain->createRow(); $rNew->setAttribute(0, $insMsk); $rNew->setSpawnAll(true); $tblMain->addRow($rNew); $tblMain->addSpacer(0, 10); } else { $newSwitchBtn = $dbTblSender->getNewEntryButton("Neuen Sender anlegen"); } } if (isset($_REQUEST["DbTableUpdate" . $dbTblSender->TABLENAME])) {