$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(); } 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); } }
$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(); } 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");
$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", "-")); } $insMsk->show(); } } if (isset($_REQUEST["DbTableUpdate" . $scItemsDbTable->TABLENAME])) { $scItemsDbTable->doUpdate(); } $rZuordnung = $table->createRow();
$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(); } } $userTable->showUpdateMask();
/** * Zeigt das gesamte DIV an */ function show() { echo "<div "; if ($this->XPOS > 0 || $this->YPOS > 0) { $tmp = ":absolute; "; if ($this->YPOS > 0) { $tmp .= " top:" . $this->YPOS . "px; "; } if ($this->XPOS > 0) { $tmp .= " left:" . $this->XPOS . "px; "; } $this->setStyle("position", $tmp); } $this->getToolTipTag(); $this->showStyles(); echo " > "; if ($this->KOPFTEXT_NEED) { /* * Bei berechtigung, Kopftext bearbeiten. */ if ($_SESSION['config']->CURRENTUSER->STATUS == "admin" || $_SESSION['config']->CURRENTUSER->STATUS == "user") { if (isset($_REQUEST['changeHeadInfo']) && strlen($_REQUEST['changeHeadInfo']) > 5) { $ktRl = substr($_REQUEST['changeHeadInfo'], 5); $dbtbl = new DbTable($_SESSION['config']->DBCONNECT, "kopftexte", array("text"), "", "", "", "runlink = '" . $ktRl . "' "); if ($dbtbl->getRowCount() == 0) { $dbtblInsert = new DbTable($_SESSION['config']->DBCONNECT, "kopftexte", array("runlink", "parent", "text"), "", "", "", "runlink = '" . $ktRl . "' "); $dbtblInsert->insertRowByArray(array($ktRl, null, "")); $dbtbl->refresh(); } if (isset($_REQUEST['DbTableUpdate' . $dbtbl->TABLENAME]) && $_REQUEST['DbTableUpdate' . $dbtbl->TABLENAME] == "Speichern") { $dbtbl->doUpdate(); } $frm = $dbtbl->getUpdateAllMask(); $frm->add(new Hiddenfield("changeHeadInfo", $_REQUEST['changeHeadInfo'])); $frm->show(); } else { $sp = new Spacer(5); $sp->show(); $txKtb = new Text("Kopftext bearbeiten<br>"); $txKtb->setFilter(false); $lnk = new Link("?changeHeadInfo=Cnge-" . $_SESSION['runLink'], $txKtb); $lnk->show(); } } $tx = new Text(getKopfText()); $tx->setFilter(false); $tx->show(); } if ($this->getObjectCount() > 0) { foreach ($this->OBJECTS as $obj) { $obj->show(); } } //-------------- include $this->FILE; //-------------- echo "</div>"; }
} if (isset($_REQUEST['DbTableUpdate' . $configDb->TABLENAME]) && !isset($_REQUEST[$abwesendSimulationName])) { $_REQUEST[$abwesendSimulationName] = 'N'; } if (isset($_REQUEST['DbTableUpdate' . $configDb->TABLENAME]) && !isset($_REQUEST[$abwesendMotionName])) { $_REQUEST[$abwesendMotionName] = 'N'; } if (isset($_REQUEST['DbTableUpdate' . $configDb->TABLENAME]) && !isset($_REQUEST[$btSwitchActiveName])) { $_REQUEST[$btSwitchActiveName] = 'N'; } if (isset($_REQUEST['DbTableUpdate' . $configDb->TABLENAME]) && !isset($_REQUEST[$switchButtonsOnIconActiveName])) { $_REQUEST[$switchButtonsOnIconActiveName] = 'N'; } if (isset($_REQUEST['DbTableUpdate' . $configDb->TABLENAME]) && $_REQUEST['DbTableUpdate' . $configDb->TABLENAME] == "Speichern") { $configDb->doUpdate(); $configDb->refresh(); $loginForSwitchNeedRow = getRowByName($configDb->ROWS, "loginForSwitchNeed"); $loginForTimelinePauseNeedRow = getRowByName($configDb->ROWS, "loginForTimelinePauseNeed"); $anwesendMotionRow = getRowByName($configDb->ROWS, "anwesendMotion"); $abwesendAlarmRow = getRowByName($configDb->ROWS, "abwesendAlarm"); $abwesendSimulationRow = getRowByName($configDb->ROWS, "abwesendSimulation"); $abwesendMotionRow = getRowByName($configDb->ROWS, "abwesendMotion"); $sensorlogDauerRow = getRowByName($configDb->ROWS, "sensorlogDauer"); $motionDauerRow = getRowByName($configDb->ROWS, "motionDauer"); $sessionDauerRow = getRowByName($configDb->ROWS, "sessionDauer"); $pagetitelRow = getRowByName($configDb->ROWS, "pagetitel"); $notifyTargetMailRow = getRowByName($configDb->ROWS, "NotifyTargetMail"); $timelineDurationRow = getRowByName($configDb->ROWS, "timelineDuration"); $btSwitchActiveRow = getRowByName($configDb->ROWS, "btSwitchActive"); $switchButtonsOnIconActiveRow = getRowByName($configDb->ROWS, "switchButtonsOnIconActive"); }
$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']; $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);
$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); $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");
function checkSwitch() { if (isset($_REQUEST['schalte']) && $_REQUEST['schalte'] != 0) { $dbActionLog = new DbTable($_SESSION['config']->DBCONNECT, "action_log", array("sessionid", "userid", "zeit"), "Session, Benutzer, Timestamp", "", "geaendert desc", "sessionid='?schalte=" . $_REQUEST['schalte'] . "'" . (strlen($_REQUEST['dimmer']) > 0 ? "-" . $_REQUEST['dimmer'] : "") . (strlen($_REQUEST['tmstmp']) > 0 ? " AND zeit=" . $_REQUEST['tmstmp'] : "")); if (count($dbActionLog->ROWS) == 0) { if (strlen($_REQUEST['tmstmp']) <= 0) { $_REQUEST['tmstmp'] = time(); } $actionLogRow = $dbActionLog->createRow(); $actionLogRow->setNamedAttribute("sessionid", "?schalte=" . $_REQUEST['schalte']); $actionLogRow->setNamedAttribute("userid", $_SESSION['config']->CURRENTUSER->USERID); $actionLogRow->setNamedAttribute("zeit", $_REQUEST['tmstmp']); $actionLogRow->insertIntoDB(); //echo "Dimmer: ".$_REQUEST['dimmer']; $dayInMillis = 86400000; $dbActionLog->setWhere("zeit is null or zeit < " . ($_REQUEST['tmstmp'] - $dayInMillis)); $dbActionLog->refresh(); foreach ($dbActionLog->ROWS as $r) { $r->deleteFromDb(); } $this->switchObject($_REQUEST['schalte'] > 0 ? $_REQUEST['schalte'] : -$_REQUEST['schalte'], $_REQUEST['schalte'] > 0 ? "on" : "off", $_REQUEST['dimmer']); } } }