$newItemBtn = $termDbTable->getNewEntryButton("Neue Bedingung anlegen"); $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") {
$r2Auswahl->setSpawnAll(true); $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'];
$tbl->addRow($r); $tbl->show(); /* --------------------------------- */ } else { // ----------------------------------- // Image Upload // ----------------------------------- $t = new Title("Etagen"); $t->setAlign("left"); $t->show(); $spc = new Spacer(20); $ln = new Line(); $scDbTable = new DbTable($_SESSION['config']->DBCONNECT, 'homecontrol_etagen', array("name", "pic"), "Name, Raumplan", "pic = 'pics/default_etage.jpg'", "name", ""); $scDbTable->setDeleteInUpdate(true); $scDbTable->setHeaderEnabled(true); $scDbTable->setNoInsertCols(array("pic")); $scDbTable->setToCheck("name"); $scDbTable->setWidth("100%"); $spc->show(); $scDbTable->setBorder(0); // -------------------------------------------------- // Neuer Eintrag // -------------------------------------------------- if (isset($_REQUEST['dbTableNewhomecontrol_etagen'])) { $scDbTable->showInsertMask(); } if (isset($_REQUEST['InsertIntoDBhomecontrol_etagen']) && $_REQUEST['InsertIntoDBhomecontrol_etagen'] == "Speichern") { $scDbTable->doInsert(); // $getMaxSql = "SELECT max(id) maxId FROM homecontrol_etagen"; // $rslt = $_SESSION['config']->DBCONNECT->executeQuery($getMaxSql); // $r = mysql_fetch_array($rslt);
function show() { $dbArr = getComboArrayBySql("select id, name from homecontrol_sender"); if (count($dbArr) <= 0) { $msg = new Message("Kein Sender vorhanden", "Legen Sie zuerst unter *Einstellungen - Basis* mindestens einen Sender an."); } else { $this->checkSensorOrControlSwitch(); $this->handleEtage(); $this->checkSwitch(); if ($this->LAYOUT_ART == $this->LAYOUTART_MOBILE) { $this->showMobileView(); return; } if ($this->LAYOUT_ART == $this->LAYOUTART_TABLET) { $this->showTabletView(); return; } // ungültige Layout-Art korrigieren auf Default (Desktop) $this->LAYOUT_ART = $this->LAYOUTART_DESKTOP; if (isset($_SESSION['aktEtage']) && strlen($_SESSION['aktEtage']) > 0) { $dbTable = new DbTable($_SESSION['config']->DBCONNECT, 'homecontrol_config', array("id", "name", "funk_id", "funk_id2", "beschreibung", "control_art", "etage", "zimmer", "x", "y", "dimmer", "sender_id"), "", "", "", "etage=" . $_SESSION['aktEtage']); $dbTable->setNoInsertCols("id"); $dbSensorTable = new DbTable($_SESSION['config']->DBCONNECT, 'homecontrol_sensor', array("id", "name", "beschreibung", "status_sensor", "sensor_art", "etage", "zimmer", "x", "y", "lastValue", "lastSignal"), "ID, Name, Beschreibung, Status-Sensor?, Art, Etage, Zimmer, X, Y, Letzter Wert, Letztes Signal", "", "etage, zimmer, name", "etage=" . $_SESSION['aktEtage']); if ($this->EDITMODE) { if ($this->handleSensorEdit($dbSensorTable)) { $dbSensorTable->refresh(); } if ($this->handleControlEdit($dbTable)) { $dbTable->refresh(); } } } $navBar = $this->getNavigationBar(); $navBar->show(); if (isset($_SESSION['aktEtage']) && strlen($_SESSION['aktEtage']) > 0) { if ($this->EDITMODE) { echo "\n \t <script type=\"text/javascript\">\n \t\tfunction Coords () {\n var Ziel = \"?"; if ($_SESSION['AnlageArt'] == "S") { echo "InsertNewSensorControl"; } else { echo "InsertNewControl"; } echo "=do&X=\" + window.event.pageX + \"&Y=\" + window.event.pageY;\n window.location.href = Ziel; \n \t\t}\n </script>\n "; } $this->showMap($dbTable, $dbSensorTable); $this->postHandleControlEdit($dbTable); } } }