$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']);
}
}
}
