$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])) { if (isset($_REQUEST["Pw" . $_REQUEST["SingleUpdateRowId"]]) && strlen($_REQUEST["Pw" . $_REQUEST["SingleUpdateRowId"]]) > 0) { $_REQUEST["Pw" . $_REQUEST["SingleUpdateRowId"]] = md5($_REQUEST["Pw" . $_REQUEST["SingleUpdateRowId"]]); } $dbTblBenutzer->doUpdate(); } if ($dbTblBenutzer->isDeleteInUpdate()) { $deleteMask = $dbTblBenutzer->doDeleteFromUpdatemask() ? null : $dbTblBenutzer->doDeleteFromUpdatemask(); if ($deleteMask != null) { $lS = $tblMain->createRow(); $lS->setSpawnAll(true); $lS->setAttribute(0, $deleteMask); $tblMain->addRow($lS);
$rNew->setSpawnAll(true); $rNew->setAttribute(0, $insMsk); $itemsTable->addRow($rNew); $itemsTable->addSpacer(0, 10); } } if (isset($_REQUEST["DbTableUpdate" . $regelItemsDbTable->TABLENAME])) { $regelItemsDbTable->doUpdate(); } $itemsTable->addSpacer(0, 15); $rZuordnung = $itemsTable->createRow(); $rZuordnung->setSpawnAll(true); $rZuordnung->setAttribute(0, $regelItemsDbTable->getUpdateAllMask()); $itemsTable->addRow($rZuordnung); $itemsTable->addSpacer(0, 10); $newItemBtn = $regelItemsDbTable->getNewEntryButton("Schaltung anlegen"); $rZuordnung = $itemsTable->createRow(); $rZuordnung->setSpawnAll(true); $rZuordnung->setAttribute(0, $newItemBtn); $itemsTable->addRow($rZuordnung); $form = new Form(); $form->add($spc); $form->add($itemsTable); $form->add($spc); $form->show(); } else { // Regel-Auswahl Combobox anzeigen, // wenn noch keine Regel ausgewählt wurde $form = new Form(); $form->add($spc); $form->add($table);
$alarmgeberDBTbl = new DbTable($_SESSION['config']->DBCONNECT, "homecontrol_alarm_geber", array("name", "ip"), "", "", "name", ""); $alarmgeberDBTbl->setDeleteInUpdate(true); $alarmgeberDBTbl->setHeaderEnabled(true); $alarmgeberDBTbl->setToCheck("name", "ip"); $alarmgeberDBTbl->setWidth("100%"); // -------------------------------------------------- // Neuer Eintrag // -------------------------------------------------- if (isset($_REQUEST['dbTableNew' . $alarmgeberDBTbl->TABLENAME])) { $alarmgeberDBTbl->showInsertMask(); } if (isset($_REQUEST['InsertIntoDB' . $alarmgeberDBTbl->TABLENAME]) && $_REQUEST['InsertIntoDB' . $alarmgeberDBTbl->TABLENAME] == "Speichern") { $alarmgeberDBTbl->doInsert(); } // -------------------------------------------------- // Bearbeiten-Maske // -------------------------------------------------- if (isset($_REQUEST["DbTableUpdate" . $alarmgeberDBTbl->TABLENAME])) { $alarmgeberDBTbl->doUpdate(); } $mskUpdate = $alarmgeberDBTbl->getUpdateAllMask(); $mskUpdate->show(); $spc = new Spacer(); $spc->setHeight(10); $spc->show(); if (!isset($_REQUEST['dbTableNew' . $alarmgeberDBTbl->TABLENAME])) { $newBtn = $alarmgeberDBTbl->getNewEntryButton("Neuen Alarmgeber anlegen"); $newBtn->show(); } $spc->show(); }
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); $table->addSpacer(0, 10); $rZuordnung = $table->createRow(); $rZuordnung->setAttribute(0, $scItemsDbTable->getNewEntryButton()); $rZuordnung->setSpawnAll(true); $table->addRow($rZuordnung); $form->add($table); // -------------------------------------------------- // Bedingungen // -------------------------------------------------- /* $table->addSpacer(1, 30); $r2Title = $table->createRow(); $r2Title->setAttribute(0, new Title("Bedingungen bearbeiten")); $r2Title->setSpawnAll(true); $table->addRow($r2Title); $table->addSpacer(0, 5);
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();
} $rx = $table->createRow(); $rx->setAttribute(0, $insMsk); $rx->setSpawnAll(true); $table->addRow($rx); } } if (isset($_REQUEST["DbTableUpdate" . $scItemsDbTable->TABLENAME])) { $scItemsDbTable->doUpdate(); } $rZuordnung = $table->createRow(); $rZuordnung->setAttribute(0, $scItemsDbTable->getUpdateAllMask()); $rZuordnung->setSpawnAll(true); $table->addRow($rZuordnung); $table->addSpacer(0, 10); $newItemBtn = $scItemsDbTable->getNewEntryButton("Neues Zimmer anlegen"); $form->add($table); $form->add($newItemBtn); } else { $form->add($table); } $form->add(new Spacer()); $form->show(); } function getEtagenImagePath($etage) { $dbTable = new DbTable($_SESSION['config']->DBCONNECT, 'homecontrol_etagen', array("id, pic"), "", "", "", "id=" . $etage); $row = $dbTable->getRow(1); return $row != null ? $row->getNamedAttribute("pic") : "/pics/default_etage.jpg"; } ?>
$hdnFld = $insMsk->getAttribute(1); if ($hdnFld instanceof Hiddenfield) { $insMsk->setAttribute(1, new Hiddenfield("dbTableNew_Shortcut_items", "-")); } $rx = $table->createRow(); $rx->setAttribute(0, $insMsk); $rx->setSpawnAll(true); $table->addRow($rx); } } if (isset($_REQUEST["DbTableUpdate" . $scItemsDbTable->TABLENAME])) { $scItemsDbTable->doUpdate(); } $rZuordnung = $table->createRow(); $rZuordnung->setAttribute(0, $scItemsDbTable->getUpdateAllMask()); $rZuordnung->setSpawnAll(true); $table->addRow($rZuordnung); $table->addSpacer(0, 10); $newItemBtn = $scItemsDbTable->getNewEntryButton(); $form->add($table); $form->add($newItemBtn); $form->add(new Spacer()); } else { $form->add($table); $form->add(new Spacer()); } $form->show(); } ?>
$spc->show(); // -------------------------------------------------- // Neuer Eintrag // -------------------------------------------------- if (isset($_REQUEST['dbTableNew'])) { $scDbTable->setBorder(0); $scDbTable->showInsertMask(); } // -------------------------------------------------- // Bearbeiten-Maske // -------------------------------------------------- $updateMask = $scDbTable->getUpdateMask(); $updateMask->show(); $spc->setHeight(10); $spc->show(); $newBtn = $scDbTable->getNewEntryButton(); $newBtn->show(); $spc->show(); $ln->show(); $spc->setHeight(20); $spc->show(); // -------------------------------------------------- // Zuordnungen // -------------------------------------------------- if (isset($_REQUEST['SelectedShortcutToEdit'])) { $_SESSION['SelectedShortcutToEdit'] = $_REQUEST['SelectedShortcutToEdit']; } $table = new Table(array("", "")); $table->setWidth(640); $rTitle = $table->createRow(); $rTitle->setAttribute(0, new Title("Zuordnungen bearbeiten"));
$c1 = $_SESSION['config']->COLORS['Tabelle_Hintergrund_1']; $c2 = $_SESSION['config']->COLORS['Tabelle_Hintergrund_2']; $termCount = 0; $termDbTable->refresh(); foreach ($termDbTable->ROWS as $r) { $term = new HomeControlTerm($r, $termCount > 0, true); $rTermZuordnung = $table->createRow(); $rTermZuordnung->setStyle("padding", "5px 5px"); $rTermZuordnung->setAttribute(0, $term); $rTermZuordnung->setSpawnAll(true); $rTermZuordnung->setBackgroundColor($termCount % 2 == 0 ? $c1 : $c2); $table->addRow($rTermZuordnung); $termCount++; } $table->addSpacer(0, 10); $newItemBtn = $termDbTable->getNewEntryButton(); $rZuordnung = $table->createRow(); $rZuordnung->setAttribute(0, $newItemBtn); $rZuordnung->setSpawnAll(true); $table->addRow($rZuordnung); } $table->addSpacer(1, 30); } // --------------------------------------------------------------- $form = new Form(); $form->add($table); $form->show(); function doUpdateAlarm() { if (isset($_REQUEST['SelectedAlarmToEdit'])) { $_SESSION['SelectedAlarmToEdit'] = $_REQUEST['SelectedAlarmToEdit'];
$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])) { checkDefaultSender($dbTblSender->ROWS); $dbTblSender->doUpdate(); } if ($dbTblSender->isDeleteInUpdate()) { $deleteMask = $dbTblSender->doDeleteFromUpdatemask() ? null : $dbTblSender->doDeleteFromUpdatemask(); if ($deleteMask != null) { $lS = $tblMain->createRow(); $lS->setSpawnAll(true); $lS->setAttribute(0, $deleteMask); $tblMain->addRow($lS); } }