<?php
$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();
$table->addSpacer(0, 10);
$cobSelect = new ComboBoxBySql($_SESSION['config']->DBCONNECT, "SELECT id, name FROM homecontrol_cron ORDER BY name", "SelectedCronToEdit", isset($_SESSION['SelectedCronToEdit']) ? $_SESSION['SelectedCronToEdit'] : "", "id", "name", " ");
$cobSelect->setDirectSelect(true);
$rAuswahl = $table->createRow();
$rAuswahl->setColSizes(array(120));
$rAuswahl->setAttribute(0, new Text("Job auswaehlen: "));
$rAuswahl->setAttribute(1, $cobSelect);
$table->addRow($rAuswahl);
$table->addSpacer(0, 20);
$form = new Form();
// 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", "-"));
}
$rZuordnung = $table->createRow();
$rZuordnung->setSpawnAll(true);
$rZuordnung->setAttribute(0, $newItemBtn);
$table->addRow($rZuordnung);
$form = new Form();
$form->add($spc);
$form->add($table);
$form->add($spc);
$form->show();
// -------------------------------------------
// Schaltgruppen
// -------------------------------------------
$regelItemsDbTable = new DbTable($_SESSION['config']->DBCONNECT, 'homecontrol_regeln_items', array("config_id", "art_id", "zimmer_id", "etagen_id", "on_off", "regel_id", "id"), "Objekt, Objekt-Art, Zimmer, Etage, An/Aus", "regel_id=" . $_SESSION['SelectedRegelToEdit'], "config_id DESC, zimmer_id DESC, etagen_id DESC", "regel_id=" . $_SESSION['SelectedRegelToEdit']);
$regelItemsDbTable->setReadOnlyCols(array("id"));
$regelItemsDbTable->setNoInsertCols(array("id"));
$regelItemsDbTable->setNoUpdateCols(array("regel_id", "id"));
$regelItemsDbTable->setDeleteInUpdate(true);
$regelItemsDbTable->setHeaderEnabled(true);
$itemsTable = new Table(array("", ""));
//$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();
$table->addRow($rTitle);
$table->addSpacer(0, 10);
$cobSelect = new ComboBoxBySql($_SESSION['config']->DBCONNECT, "SELECT id, name FROM homecontrol_shortcut ORDER BY name", "SelectedShortcutToEdit", isset($_SESSION['SelectedShortcutToEdit']) ? $_SESSION['SelectedShortcutToEdit'] : "", "id", "name", " ");
$cobSelect->setDirectSelect(true);
$rAuswahl = $table->createRow();
$rAuswahl->setColSizes(array(150));
$rAuswahl->setAttribute(0, new Text("Shortcut auswaehlen: "));
$rAuswahl->setAttribute(1, $cobSelect);
$table->addRow($rAuswahl);
$table->addSpacer(0, 20);
$form = new Form();
// Zuordnung ausgewählt
if (isset($_SESSION['SelectedShortcutToEdit']) && strlen($_SESSION['SelectedShortcutToEdit']) > 0) {
$scItemsDbTable = new DbTable($_SESSION['config']->DBCONNECT, 'homecontrol_shortcut_items', array("config_id", "art_id", "zimmer_id", "etagen_id", "on_off", "shortcut_id"), "Objekt, Objekt-Art, Zimmer, Etage, An/Aus", "shortcut_id=" . $_SESSION['SelectedShortcutToEdit'], "config_id DESC, zimmer_id DESC, etagen_id DESC", "shortcut_id=" . $_SESSION['SelectedShortcutToEdit']);
$scItemsDbTable->setReadOnlyCols(array("id"));
$scItemsDbTable->setNoUpdateCols(array("shortcut_id"));
$scItemsDbTable->setDeleteInUpdate(true);
$scItemsDbTable->setHeaderEnabled(true);
$scItemsDbTable->setWidth("100%");
// Neuer Eintrag
if (isset($_REQUEST['InsertIntoDBhomecontrol_shortcut_items']) && $_REQUEST['InsertIntoDBhomecontrol_shortcut_items'] == "Speichern") {
$scItemsDbTable->doInsert();
$scItemsDbTable->refresh();
} else {
if (isset($_REQUEST['dbTableNewhomecontrol_shortcut_items'])) {
$scItemsDbTable->setBorder(0);
$insMsk = $scItemsDbTable->getInsertMask();
$hdnFld = $insMsk->getAttribute(1);
if ($hdnFld instanceof Hiddenfield) {
$insMsk->setAttribute(1, new Hiddenfield("dbTableNew_Shortcut_items", "-"));
}
