<?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();
if ($_SESSION['config']->CURRENTUSER->STATUS != "admin" && $_SESSION['config']->CURRENTUSER->STATUS != "user") {
/* ------------------------------------
BENUTZERSTATUS ANZEIGEN
------------------------------------ */
$USR = $_SESSION['config']->CURRENTUSER;
$USERSTATUS = new UserStatus($USR, -1, -1);
$tbl = new Table(array(""));
$tbl->setAlign("center");
$r = $tbl->createRow();
$r->setAttribute(0, $USERSTATUS);
$tbl->addRow($r);
$tbl->show();
/* --------------------------------- */
} else {
$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
// --------------------------------------------------
$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();
$regelItemsDbTable->refresh();
<?php
$t = new Title("Benutzer verwalten");
$t->setAlign("left");
$t->show();
$spc = new Spacer(10);
$spc->show();
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();
}
$r2Auswahl->setAttribute(0, new Text("Schaltgruppe auswaehlen: "));
$table->addRow($r2Auswahl);
$r2Auswahl = $table->createRow();
$r2Auswahl->setSpawnAll(true);
$r2Auswahl->setAttribute(0, $cobSelectItems);
$table->addRow($r2Auswahl);
$table->addSpacer(0, 10);
if (isset($_SESSION['SelectedAlarmItemToEdit'])) {
$where = "trigger_id=" . $_SESSION['SelectedAlarmToEdit'] . " AND trigger_type=3 ";
if (isset($_SESSION['SelectedAlarmItemToEdit']) && strlen($_SESSION['SelectedAlarmItemToEdit']) > 0) {
$where .= " AND trigger_subid=" . $_SESSION['SelectedAlarmItemToEdit'];
}
$termDbTable = new DbTable($_SESSION['config']->DBCONNECT, 'homecontrol_term', array("id", "trigger_id", "trigger_type", "config_id", "term_type", "sensor_id", "min", "std", "value", "termcondition", "status", "montag", "dienstag", "mittwoch", "donnerstag", "freitag", "samstag", "sonntag", "order_nr", "and_or"), "", "", "order_nr", $where);
$termDbTable->setReadOnlyCols(array("id"));
$termDbTable->setNoInsertCols(array("id"));
$termDbTable->setDeleteInUpdate(true);
$termDbTable->setHeaderEnabled(true);
$termDbTable->setWidth("100%");
$table->addSpacer(0, 10);
if (isset($_REQUEST[$termDbTable->getNewEntryButtonName()])) {
$addUrl = $termDbTable->getNewEntryButtonName() . "=" . $_REQUEST[$termDbTable->getNewEntryButtonName()];
$hcTermCreator = new HomeControlTermCreator($_SESSION['SelectedAlarmToEdit'], $_SESSION['SelectedAlarmItemToEdit'], 3, $addUrl);
$rNew = $table->createRow();
$rNew->setAlign("center");
$rNew->setAttribute(0, $hcTermCreator);
$rNew->setSpawnAll(true);
$table->addRow($rNew);
$table->addSpacer(0, 20);
}
$c1 = $_SESSION['config']->COLORS['Tabelle_Hintergrund_1'];
$c2 = $_SESSION['config']->COLORS['Tabelle_Hintergrund_2'];
<?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);
