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