/**
* Zeigt die Eingabemaske an, wenn isset($_REQUEST['dbTableNew'])
* ansonsten gibt die Methode false zurÃÂÃÂÃÂück.
*
* return boolean
*/
function showInsertMaskIfNeeded()
{
if (isset($_REQUEST['dbTableNew'])) {
$insert = new DbTable($_SESSION['config']->DBCONNECT, "news", array("Title", "Text", "Datum", "Autor"), "Titel, Text, Datum, Autor", "Datum='" . date("Y-m-d") . "', Autor = '" . $_SESSION['config']->CURRENTUSER->VORNAME . " " . $_SESSION['config']->CURRENTUSER->NACHNAME . "' ", "Datum DESC");
$insert->setBorder(0);
$insert->showInsertMask();
return true;
} else {
return false;
}
}
$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();
}
$mskUpdate = $alarmgeberDBTbl->getUpdateAllMask();
$mskUpdate->show();
$spc = new Spacer();
$spc->setHeight(10);
$spc->show();
$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);
// exec("cp /var/www/pics/default_etage.jpg /var/www/pics/raumplan/".$r['maxId'].".jpg");
// $getMaxSql = "UPDATE homecontrol_etagen SET pic = 'pics/raumplan/".$r['maxId'].".jpg' WHERE id = ".$r['maxId'];
// //$getMaxSql = "UPDATE homecontrol_etagen SET pic = 'pics/default_etage.jpg' WHERE id = ".$r['maxId'];
// $rslt = $_SESSION['config']->DBCONNECT->executeQuery($getMaxSql);
$scDbTable->refresh();
}
// --------------------------------------------------
// Bearbeiten-Maske
// --------------------------------------------------
