/** * 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 // --------------------------------------------------