$sqlRegelItems = "SELECT id, name FROM homecontrol_regeln"; $cobSelectItems = new ComboBoxBySql($_SESSION['config']->DBCONNECT, $sqlRegelItems, "SelectedRegelToEdit", isset($_SESSION['SelectedRegelToEdit']) ? $_SESSION['SelectedRegelToEdit'] : "", 0, 1, " "); $cobSelectItems->setDirectSelect(true); $r2Auswahl = $table->createRow(); $r2Auswahl->setAttribute(0, new Text("Regel auswaehlen: ")); $r2Auswahl->setAttribute(1, $cobSelectItems); $table->addRow($r2Auswahl); $table->addSpacer(0, 10); if (isset($_SESSION['SelectedRegelToEdit']) && strlen($_SESSION['SelectedRegelToEdit']) > 0) { $where = "trigger_id=" . $_SESSION['SelectedRegelToEdit'] . " AND trigger_type=1 "; $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", "lastSensorintervall", "trigger_jn"), "", "", "term_type,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['SelectedRegelToEdit'], 0, 1, $addUrl); $rNew = $table->createRow(); $rNew->setAlign("center"); $rNew->setSpawnAll(true); $rNew->setAttribute(0, $hcTermCreator); $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();
------------------------------------ */ $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 // -------------------------------------------------- if (isset($_REQUEST["DbTableUpdate" . $alarmgeberDBTbl->TABLENAME])) { $alarmgeberDBTbl->doUpdate(); }
$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", "-")); } $insMsk->show(); } }