@ 2017-07-10T15:54:02Z <html>
<head>
<style type="text/css">
body,tr,td {font-family:Arial; font-size:10pt}}
b {font-family:Arial; font-size:10pt; font-weight:bold}
.small {font-family:Arial; font-size:8pt}
.kopf {font-family:Arial; font-size:8pt;padding:3px;margin:0px;border:solid 1px;border-spacing:0px;background-color:#999999}
.inhalt {font-family:Arial; font-size:8pt;padding:3px;margin:0px;border:solid 1px #000000;border-spacing:0px}
.inhalt_del {font:-family:Arial; color:#AAAAAA; font-size:8pt;padding:3px;margin:0px;border:solid 1px #000000;border-spacing:0px}
.gesamt {font-family:Arial; font-weight:bold; font-size:8pt;padding:3px;margin:0px;border:solid 1px;border-spacing:0px}
.inhaltgrau {color:#bbbbbb;font-family:Arial; font-size:8pt;padding:3px;margin:0px;border:solid 1px black;border-spacing:0px}
.inhaltgraugrau {color:#bbbbbb;font-family:Arial; font-size:8pt;padding:3px;margin:0px;border:solid 1px black;border-spacing:0px}
a:link { color:#0000AA; text-decoration:underline; }
a:visited{ color:#0000AA; text-decoration:underline; }
a:focus { color:#0000AA; text-decoration:underline; }
a:hover { color:#0000EE; text-decoration:underline; }
a:active { color:#0000AA; text-decoration:underline; }
</style>
<SCRIPT LANGUAGE="JavaScript" SRC="combined/CalendarPopup.js"></SCRIPT>
<SCRIPT LANGUAGE="JavaScript">document.write(getCalendarStyles());</SCRIPT>
<script type="text/javascript">
function flip(uebergabe1, uebergabe2)
{
for ( i = 0 ; i <= uebergabe2 ; i++ )
{
if ( document.getElementsByName(uebergabe1)[i].style.display == "" )
{
document.getElementsByName(uebergabe1)[i].style.display = "none";
aktion = "einblenden";
}
else
{
document.getElementsByName(uebergabe1)[i].style.display = "";
aktion = "ausblenden";
}
}
if ( aktion == "ausblenden") {
document.getElementById('img_' + uebergabe1).src = "/fesch/img/minus.gif";
} else {
document.getElementById('img_' + uebergabe1).src = "/fesch/img/plus.gif";
}
}
function formLeeren(uebergabe3){
var obj = document.forms[uebergabe3];
for(i=0;i<obj.elements.length;i++){
if(obj.elements[i].type == 'text' || obj.elements[i].type == 'textarea'){
obj.elements[i].value = '';
} else {
obj.elements[i].selectedIndex = 0;
}
}
}
var fenster;
function neues() {
fenster = window.open (
"",
"NeuesFenster", // Name des neuen Fensters
+"toolbar=0" // Toolbar
+",location=0" // Adress-Leiste
+",directories=0" // Zusatzleisten
+",status=0" // Statusleiste
+",menubar=0" // Menü
+",scrollbars=0" // Scrollbars
+",resizable=0" // Fenstergrösse veränderbar?
+",width=920" // Fensterbreite in Pixeln
+",height=840" // Fensterhöhe in Pixeln
);
fenster.moveTo(
50, // X-Koordinate
50 // Y-Koordinate
); // der linken oberen Ecke
fenster.location.href = "/fesch/map.php";
//Dateiname und Pfad der Datei, die angezeigt werden soll
}
function neues2() {
fenster = window.open (
"",
"NeuesFenster", // Name des neuen Fensters
+"toolbar=0" // Toolbar
+",location=0" // Adress-Leiste
+",directories=0" // Zusatzleisten
+",status=0" // Statusleiste
+",menubar=0" // Menü
+",scrollbars=0" // Scrollbars
+",resizable=0" // Fenstergrösse veränderbar?
+",width=920" // Fensterbreite in Pixeln
+",height=840" // Fensterhöhe in Pixeln
);
fenster.moveTo(
50, // X-Koordinate
50 // Y-Koordinate
); // der linken oberen Ecke
fenster.location.href = "/fesch/map_ia.php";
//Dateiname und Pfad der Datei, die angezeigt werden soll
}
</script>
<STYLE>
.TESTcpYearNavigation,
.TESTcpMonthNavigation
{
background-color:#6677DD;
text-align:center;
vertical-align:center;
text-decoration:none;
color:#FFFFFF;
font-weight:bold;
}
.TESTcpDayColumnHeader,
.TESTcpYearNavigation,
.TESTcpMonthNavigation,
.TESTcpCurrentMonthDate,
.TESTcpCurrentMonthDateDisabled,
.TESTcpOtherMonthDate,
.TESTcpOtherMonthDateDisabled,
.TESTcpCurrentDate,
.TESTcpCurrentDateDisabled,
.TESTcpTodayText,
.TESTcpTodayTextDisabled,
.TESTcpText
{
font-family:arial;
font-size:8pt;
}
TD.TESTcpDayColumnHeader
{
text-align:right;
border:solid thin #6677DD;
border-width:0 0 1 0;
}
.TESTcpCurrentMonthDate,
.TESTcpOtherMonthDate,
.TESTcpCurrentDate
{
text-align:right;
text-decoration:none;
}
.TESTcpCurrentMonthDateDisabled,
.TESTcpOtherMonthDateDisabled,
.TESTcpCurrentDateDisabled
{
color:#D0D0D0;
text-align:right;
text-decoration:line-through;
}
.TESTcpCurrentMonthDate
{
color:#6677DD;
font-weight:bold;
}
.TESTcpCurrentDate
{
color: #FFFFFF;
font-weight:bold;
}
.TESTcpOtherMonthDate
{
color:#808080;
}
TD.TESTcpCurrentDate
{
color:#FFFFFF;
background-color: #6677DD;
border-width:1;
border:solid thin #000000;
}
TD.TESTcpCurrentDateDisabled
{
border-width:1;
border:solid thin #FFAAAA;
}
TD.TESTcpTodayText,
TD.TESTcpTodayTextDisabled
{
border:solid thin #6677DD;
border-width:1 0 0 0;
}
A.TESTcpTodayText,
SPAN.TESTcpTodayTextDisabled
{
height:20px;
}
A.TESTcpTodayText
{
color:#6677DD;
font-weight:bold;
}
SPAN.TESTcpTodayTextDisabled
{
color:#D0D0D0;
}
.TESTcpBorder
{
border:solid thin #6677DD;
}
</STYLE>
<title>FESCH - Metadatensuche zur Schätzungskarten</title>
</head>
<BODY bgcolor="#ffffff" text="#000000" link="#996600" vlink="#666666" alink="#336600">
<br />
<?php
$user = $_SERVER['PHP_AUTH_USER'];
/*echo "<pre>";
print_r($_SERVER);
echo "</pre>";*/
include("../includes/config.inc.php");
$mysql_connection = mysql_connect($db_host,$db_user,$db_passwd);
mysql_select_db($db_name);
function to_space($word, $minus=FALSE) {
if($minus)
$word = str_replace("-", " ", $word);
$word = str_replace("+", " ", $word);
$word = str_replace("_", " ", $word);
$word = str_replace("'", " ", $word);
$word = str_replace("/", " ", $word);
$word = str_replace("\\", " ", $word);
//$word = str_replace("%", " ", $word);
$word = str_replace("*", "%", $word);
return $word;
}
$kartentyp = array("S"=>"Schätzungsreinkarte", "F"=>"Feldschätzungskarte", "D"=>"Deckpause");
$error = FALSE;
if($_SERVER['QUERY_STRING'] == "gesamte_statistik" || $_SERVER['QUERY_STRING'] == "gesamte_statistik_ASC") {
$_POST['submit'] = true;
$_POST['statistik_Gemeinde'] = "%";
$_POST['search_in'] = "statistik";
}
if($_POST['search_in'] == "dibos") {
if($_POST['submit']) {
if($_POST['search'] == "fulltext") {
// Volltext
if(trim($_POST['keywords'] == ""))
$error_1 = TRUE;
$error_txt_1 = "Raster-Metadaten-Suche: Sie haben keine Suchbegriffe angegeben.";
} else {
// Detail
if(empty($_POST['landkreis']) && empty($_POST['Kartentyp']) && empty($_POST['Finanzamtsbezirk']) && trim($_POST['Gemeinde'])=="" && trim($_POST['Gmkg'])=="" && trim($_POST['Nr_Gmkg_txt'])=="" && trim($_POST['keywords_d'])=="") {
$error_2 = TRUE;
$error_txt_2 = "Raster-Metadaten-Suche: Bitte geben Sie mindestens ein Suchkriterium an.";
}
}
}
if($_POST['submit'] && !($error_1 OR $error_2 OR $error_3)) {
for($j=0;$j<count($_POST);$j++)
mysql_real_escape_string($_POST[$j]);
if($_POST['search'] == "fulltext") {
// Volltext
//$query = "SELECT *,IF(`Finanzamtsbezirk`='-', 'unbekannt', REPLACE(REPLACE(`Finanzamtsbezirk`, 'Hr.', 'Herr'), 'Fr.', 'Frau')) as fab,(CONCAT_WS(' ', LOWER(IF(`Kartentyp`='S',' Schätzungsreinkarte',' ')), LOWER(IF(`Kartentyp`='F', ' Feldschätzungskarte', ' ')), LOWER(IF(`Kartentyp`='D', ' Deckpause', ' ')), LOWER(`Finanzamtsbezirk`), LOWER(`Landkreis`)";
$query = "SELECT *,IF(`Finanzamtsbezirk`='-', 'unbekannt', REPLACE(REPLACE(`Finanzamtsbezirk`, 'Hr.', 'Herr'), 'Fr.', 'Frau')) as fab,(CONCAT_WS(' ', LOWER(`Finanzamtsbezirk`), LOWER(`Landkreis`)";
$query .= ", LOWER(`Landkreis_Soll`), LOWER(`BEZ_Gemeinde`), LOWER(`Gmkg`), LOWER(`Nr_Gmkg`), LOWER(`lfd_Nr_Gemarkung`), LOWER(`Bezeichnung`), LOWER(`Bemerkung`), LOWER(`Kartentyp`), LOWER(`Scan`), ' ')) as such_kriterium FROM `fesch_sachdaten_LJ_raster` HAVING";
$keywords = explode(" ", to_space($_POST['keywords']));
//print_r($keywords);
foreach($keywords as $keyword) {
$query .= " (such_kriterium LIKE '% ".strtolower(trim(to_space($keyword)))." %') ".$_POST['link'];
}
$query = substr($query, 0, strlen($query)-3)." ORDER BY Nr_Gmkg,CAST(lfd_Nr_Gemarkung as SIGNED),prefix_nr_gmkg";
//echo $query;
} else {
// Detail
$query = "SELECT * FROM `fesch_sachdaten_LJ_raster` WHERE";
if(!empty($_POST['landkreis']))
$query .= " `Landkreis_Soll`='".$_POST['landkreis']."' AND";
if(!empty($_POST['Kartentyp']))
$query .= " `Kartentyp`='".$_POST['Kartentyp']."' AND";
if(!empty($_POST['Finanzamtsbezirk']))
$query .= " `Finanzamtsbezirk`='".$_POST['Finanzamtsbezirk']."' AND";
if(trim($_POST['Gemeinde']) != "") {
$keywords = explode(" ", to_space($_POST['Gemeinde']));
foreach($keywords as $keyword) {
$query .= " (LCASE(`BEZ_Gemeinde`) LIKE '%".strtolower(trim(to_space($keyword)))."%') AND";
}
}
if(trim($_POST['Gmkg']) != "") {
$keywords = explode(" ", to_space($_POST['Gmkg']));
foreach($keywords as $keyword) {
$query .= " (LCASE(`Gmkg`) LIKE '%".strtolower(trim(to_space($keyword)))."%') AND";
}
}
if(trim($_POST['Nr_Gmkg_txt']) != "") {
$keywords = explode(" ", to_space($_POST['Nr_Gmkg_txt'], TRUE));
foreach($keywords as $keyword) {
$query .= " ((LCASE(`lfd_Nr_Gemarkung`) LIKE '%".strtolower(trim(to_space($keyword)))."%') OR (LCASE(`Nr_Gmkg`) LIKE '%".strtolower(trim(to_space($keyword)))."%')) AND";
}
}
if(trim($_POST['keywords_d']) != "") {
$keywords = explode(" ", to_space($_POST['keywords_d']));
foreach($keywords as $keyword) {
$query .= " ((LCASE(`Bemerkung`) LIKE '%".strtolower(trim(to_space($keyword)))."%') OR (LCASE(`Bezeichnung`) LIKE '%".strtolower(trim(to_space($keyword)))."%')) AND";
}
}
$query = substr($query, 0, strlen($query)-3)." ORDER BY Nr_Gmkg,CAST(lfd_Nr_Gemarkung as SIGNED),prefix_nr_gmkg";
}
// Ausgabe der Suchergebnisse folgt
$results = mysql_query($query);
//echo mysql_error();
//echo $query;
$count = mysql_num_rows($results);
if($count < 1) {
if($_POST['search'] == "fulltext") {
$error_txt_1 = "Ihre Suche ergab keine Treffer.";
$error_1 = TRUE;
} else {
$error_txt_2 = "Ihre Suche ergab keine Treffer.";
$error_2 = TRUE;
}
/*} elseif($count > 50) {
$error_txt = "Ihre Suche ergab mehr als 50 Treffer - bitte verfeinern Sie Ihre Suche.";
$error = TRUE;*/
} else {
if($_POST['view'] == "text") {
?>
<table border="0">
<tr>
<td style="width:300px"><h2>BSK-Info</h2></td><td align=right style="width:350px"><i>Zuletzt aktualisiert: <?php echo date("d.m.Y", filemtime($path_abs."/fesch/index.php")); ?>.</i></td>
</tr>
<tr>
<td colspan=2><a href="index.php">Zu den Suchmasken</a> | <a href="fertig.php">Fertigstellung von Gemarkung melden</a> | <a href="map.php">interaktive Grabloch- und Gemarkungskarte</a></td>
</tr>
</table><br />
<?php
while($o = mysql_fetch_array($results)) {
//print_r($o);
?>
<table border="0" width="600" style="border-spacing:0px" class="inhalt">
<tr>
<td width="300"><b><?php echo $o['prefix_nr_gmkg']." ".$o['Nr_Gmkg']."-".$o['lfd_Nr_Gemarkung']." ".$o['Gmkg']."</b>"; ?></b></td><td width="300"><?php echo $o['Landkreis_Soll']." » ".$o['BEZ_Gemeinde']; ?></td>
</tr>
<tr>
<td colspan=2 style="padding-left:40px">
<table border=0>
<tr><td class="small">Bezeichnung: </td><td class="small"><?php echo $o['Bezeichnung']; ?></td></tr>
<tr><td class="small">Kartentyp: </td><td class="small"><?php echo $kartentyp[$o['Kartentyp']]; ?></td></tr>
<tr><td class="small">Finanzamtsbezirk: </td><td class="small"><?php echo $o['Finanzamtsbezirk']; ?></td></tr>
<tr><td class="small">Scan-Büro: </td><td class="small"><?php echo $o['Scan']; ?></td></tr>
<tr><td class="small" valign="top">Bemerkung: </td><td class="small"><?php echo $o['Bemerkung']; ?></td></tr>
<?php
// Dateinamen
$filename = $o['Nr_Gmkg'].str_repeat("0", 4-strlen($o['Nr_Gmkg'])).$o['Nr_Gmkg'];
if(is_numeric($o['lfd_Nr_Gemarkung'])) {
$filename .= str_repeat("_", 3-strlen($o['lfd_Nr_Gemarkung'])).$o['lfd_Nr_Gemarkung'];
} else {
$char = $o['lfd_Nr_Gemarkung'][strlen($o['lfd_Nr_Gemarkung'])-1];
$num = substr($o['lfd_Nr_Gemarkung'], 0, strlen($o['lfd_Nr_Gemarkung'])-1);
$filename .= str_repeat("_", 3-strlen($num)).$num.$char;
}
//echo $filename;
if(file_exists($path_abs."/dibos/jpg/".$filename.".jpg")) {
echo "<tr><td class=\"small\">Karte: </td><td class=\"small\"><a href=\"/dibos/jpg/".$filename.".jpg\" target=\"_blank\"><img src=\"/images/jpg.png\" border=0 width=16></a> <a href=\"/dibos/jpg/".$filename.".jpg\" target=\"_blank\">".$filename.".jpg</a></td></tr>";
}
if(file_exists($path_abs."/dibos/jgw/".$filename.".jgw")) {
echo "<tr><td class=\"small\">JGW-Datei: </td><td class=\"small\"><a href=\"/dibos/jgw/".$filename.".jgw\" target=\"_blank\"><img src=\"/images/jgw.png\" border=0 width=16></a> <a href=\"/dibos/jgw/".$filename.".jgw\" target=\"_blank\">".$filename.".jgw</a></td></tr>";
}
//if($o['long'] != NULL) {
// echo "<tr><td class=\"small\">Google Map: </td><td class=\"small\"><a href=\"http://maps.google.com/maps?f=q&hl=de&q=E".$o['long']."+N".$o['lat']."&t=h&om=1\" target=\"_blank\"><img src=\"/images/G.gif\" border=\"0\"></a> <a href=\"http://maps.google.com/maps?f=q&hl=de&q=E".$o['long']."+N".$o['lat']."&t=h&om=1\" target=\"_blank\">zur Karte</a></td></tr>";
//}
?>
</table>
</td>
</tr>
</table><br />
<?php
}
} else {
// tabellarische Ansicht
?>
<table border="0">
<tr>
<td style="width:300px"><h2>BSK-Info</h2></td><td align=right style="width:350px"><i>Zuletzt aktualisiert: <?php echo date("d.m.Y", filemtime($path_abs."/fesch/index.php")); ?>.</i></td>
</tr>
<tr>
<td colspan=2><a href="index.php">Zu den Suchmasken</a> | <a href="fertig.php">Fertigstellung von Gemarkung melden</a> | <a href="map.php">interaktive Grabloch- und Gemarkungskarte</a></td>
</tr>
</table><br />
<table cellspacing=0 style="border: solid 1px #000000;border-collapse:collapse;">
<?php
$i = 0;
while($o = mysql_fetch_array($results)){
// Dateinamen
$filename = $o['prefix_nr_gmkg'].str_repeat("0", 4-strlen($o['Nr_Gmkg'])).$o['Nr_Gmkg'];
if(is_numeric($o['lfd_Nr_Gemarkung'])) {
$filename .= str_repeat("_", 3-strlen($o['lfd_Nr_Gemarkung'])).$o['lfd_Nr_Gemarkung'];
} else {
$char = $o['lfd_Nr_Gemarkung'][strlen($o['lfd_Nr_Gemarkung'])-1];
$num = substr($o['lfd_Nr_Gemarkung'], 0, strlen($o['lfd_Nr_Gemarkung'])-1);
$filename .= str_repeat("_", 3-strlen($num)).$num.$char;
}
if($i == 0 OR $i%15==0) {
?>
<tr class="kopf">
<th class="kopf" height=22 width=70>Nr. Gmkg.</th>
<th class="kopf" width=75>Gemarkung</th>
<th class="kopf" width=75>Landkreis</th>
<th class="kopf" width=75>Gemeinde</th>
<th class="kopf" width=170>Bezeichnung</th>
<th class="kopf" width=170>Bemerkung</th>
<th class="kopf" width=75>Kartentyp</th>
<th class="kopf" width=100>Finanzamtsb.</th>
<th class="kopf" width=80>Scan-Büro</th>
<th class="kopf" width=60>Karte/JGW</th>
</tr>
<?php
}
if($o['Zusatz_Info'] == "Karte existiert nicht") {
$suffix_del = "_del";
} else {
$suffix_del = "";
}
?>
<tr<?php if($i%2==1) echo " style=\"background-color:#DDDDDD\""; ?> class="inhalt<?php echo $suffix_del; ?>">
<td class="inhalt<?php echo $suffix_del; ?>" height=22 align=right valign=top width=70><?php echo $o['prefix_nr_gmkg']." ".$o['Nr_Gmkg']; ?> - <?php echo $o['lfd_Nr_Gemarkung']; ?> </td>
<td class="inhalt<?php echo $suffix_del; ?>" valign=top align=center width=75><?php echo $o['Gmkg']; ?> </td>
<td class="inhalt<?php echo $suffix_del; ?>" valign=top align=center width=75><?php echo substr(strstr($o['Landkreis_Soll'], "("), 1, -1); ?> </td>
<td class="inhalt<?php echo $suffix_del; ?>" valign=top align=center width=75><?php echo $o['BEZ_Gemeinde']; ?> </td>
<td class="inhalt<?php echo $suffix_del; ?>" valign=top width=170><?php echo $o['Bezeichnung']; ?> </td>
<td class="inhalt<?php echo $suffix_del; ?>" valign=top width=170><?php echo $o['Bemerkung']; ?> </td>
<td class="inhalt<?php echo $suffix_del; ?>" valign=top align=center width=75><?php echo $o['Kartentyp']; ?> </td>
<td class="inhalt<?php echo $suffix_del; ?>" valign=top align=center width=100><?php echo $o['Finanzamtsbezirk']; ?> </td>
<td class="inhalt<?php echo $suffix_del; ?>" valign=top align=center width=80><?php echo $o['Scan']; ?> </td>
<td class="inhalt<?php echo $suffix_del; ?>" valign=top width=60><?php if(file_exists($path_abs."/dibos/jpg/".$filename.".jpg")) echo "<a href=\"/dibos/jpg/".$filename.".jpg\" target=\"_blank\" ALT=\"".$filename.".jpg\" text=\"".$filename.".jpg\"><img src=\"/images/jpg.png\" border=0 width=16></a>"; ?>
<?php if(file_exists($path_abs."/dibos/jgw/".$filename.".jgw")) echo "<a href=\"/dibos/jgw/".$filename.".jgw\" target=\"_blank\" ALT=\"".$filename.".jgw\" text=\"".$filename.".jgw\"><img src=\"/images/jgw.png\" border=0 width=16 style=\"padding:0;margin:0\"></a>"; ?>
<?php /*if($o['long'] != NULL) echo "<a href=\"http://maps.google.com/maps?f=q&hl=de&q=E".$o['long']."+N".$o['lat']."&t=h&om=1\" target=\"_blank\"><img src=\"/images/G.gif\" border=\"0\"></a>"; */?></td>
</tr>
<?php
$i++;
}
echo "</table>";
}
}
}
}
if(!$_POST['submit'] OR $error_1 OR $error_2 OR $error_3) {
?>
<table border="0">
<tr>
<td style="width:300px"><h2>BSK-Info</h2></td><td align=right style="width:350px"><i>Zuletzt aktualisiert: <?php echo date("d.m.Y", filemtime($path_abs."/index.php")); ?>.</i></td>
</tr>
<tr>
<td colspan=2><a href="index.php">Zu den Suchmasken</a> | <a href="fertig.php">Fertigstellung von Gemarkung melden</a> | <a href="map.php">interaktive Grabloch- und Gemarkungskarte</a></td>
</tr>
</table><br />
<a name="formular_1"></a>
<?php if($error_1) echo "<b style=\"color:#FF0000\">".$error_txt_1."</b><br /><br />"; ?>
<form name="form1" method="POST" action="index.php#formular_1">
<input type="hidden" name="search" value="fulltext">
<input type="hidden" name="search_in" value="dibos">
<b>Raster und Metadaten - Volltextsuche</b><br />
<table border="0" style="padding-left:150px">
<tr>
<td rowspan=4 <?php if($error_1) echo "style=\"background-color:red\""; ?>>
</td>
</tr>
<tr>
<td style="width:200px">Suchbegriff/e:</td>
<td colspan=2><input type="text" name="keywords" value="<?php echo $_POST['keywords']; ?>" style="width:200px"></td>
</tr>
<tr>
<td style="width:200px">verknüpft über</td>
<td width=130> <input type="radio" name="link" value="AND" <?php if($_POST['link'] == "AND" OR empty($_POST['link'])) echo "checked"; ?>> UND</td><td width=70><input type="radio" name="link" value="OR" <?php if($_POST['link'] == "OR") echo "checked"; ?>> ODER</td>
</tr>
<?php
/*
<tr>
<td style="width:200px">Ansicht</td>
<td width=130> <input type="radio" name="view" value="tab" <?php if($_POST['view'] == "tab" OR empty($_POST['view'])) echo "checked"; ?>> tabellarisch</td><td width=70><input type="radio" name="view" value="text" <?php if($_POST['view'] == "text") echo "checked"; ?>> Text</td>
</tr>
*/
?>
<tr>
<td> </td>
<td colspan=3 align=right><input type="reset" name="reset" value="Eingaben löschen" onclick="formLeeren(0)";><input type="submit" name="submit" value="suchen"></td>
</tr>
</table>
</form>
<a name="formular_2"></a>
<?php if($error_2) echo "<b style=\"color:#FF0000\">".$error_txt_2."</b><br /><br />"; ?>
<form name="form2" method="POST" action="index.php#formular_2">
<input type="hidden" name="search" value="detail">
<input type="hidden" name="search_in" value="dibos">
<b>Raster und Metadaten - Detailsuche</b><br />
<table border="0" style="padding-left:150px">
<tr>
<td rowspan=9 <?php if($error_2) echo "style=\"background-color:red\""; ?>>
</td>
</tr>
<tr>
<td>Landkreis:</td>
<td colspan=2>
<select name="landkreis" style="width:200px">
<option value="">keine Auswahl getroffen</option>
<?php
$lkq = mysql_query("SELECT DISTINCT(Landkreis_Soll) FROM `fesch_sachdaten_LJ_raster` ORDER BY Landkreis_Soll");
while($lk = mysql_fetch_array($lkq)) {
if($_POST['landkreis'] == $lk['Landkreis_Soll'])
echo "<option value=\"".$lk['Landkreis_Soll']."\" selected>".$lk['Landkreis_Soll']."</option>\n";
else
echo "<option value=\"".$lk['Landkreis_Soll']."\">".$lk['Landkreis_Soll']."</option>\n";
}
?>
</select>
</td>
</tr>
<tr>
<td style="width:200px">Gemeinde:</td>
<td colspan=2><input type="text" name="Gemeinde" value="<?php echo $_POST['Gemeinde']; ?>" style="width:200px"></td>
</tr>
<tr>
<td>Nr. Gemarkung:</td>
<td colspan=2><input type="text" name="Nr_Gmkg_txt" value="<?php echo $_POST['Nr_Gmkg_txt']; ?>" style="width:200px"></td>
</tr>
<tr>
<td>Gemarkung:</td>
<td colspan=2><input type="text" name="Gmkg" value="<?php echo $_POST['Gmkg']; ?>" style="width:200px"></td>
</tr>
<tr>
<td>Finanzamtsbezirk:</td>
<td colspan=2>
<select name="Finanzamtsbezirk" style="width:200px">
<option value="">keine Auswahl getroffen</option>
<?php
$fabq = mysql_query("SELECT DISTINCT(IF(`Finanzamtsbezirk`='-', 'unbekannt', REPLACE(REPLACE(`Finanzamtsbezirk`, 'Hr.', 'Herr'), 'Fr.', 'Frau'))) as fab,`Finanzamtsbezirk` FROM `fesch_sachdaten_LJ_raster` ORDER BY fab");
while($fab = mysql_fetch_array($fabq)) {
if($_POST['Finanzamtsbezirk'] == $fab['Finanzamtsbezirk'])
echo "<option value=\"".$fab['Finanzamtsbezirk']."\" selected>".$fab['Finanzamtsbezirk']."</option>\n";
else
echo "<option value=\"".$fab['Finanzamtsbezirk']."\">".$fab['Finanzamtsbezirk']."</option>\n";
}
?>
</select>
</td>
</tr>
<tr>
<td>Kartentyp:</td>
<td colspan=2>
<select name="Kartentyp" style="width:200px">
<option value="">keine Auswahl getroffen</option>
<?php
foreach($kartentyp as $typ=>$bez) {
if($_POST['Kartentyp'] == $typ)
echo "<option value=\"".$typ."\" selected>".$bez."</option>\n";
else
echo "<option value=\"".$typ."\">".$bez."</option>\n";
}
?>
</select>
</td>
</tr>
<tr>
<td>Bezeichnung/Bemerkung:</td>
<td colspan=2><input type="text" name="keywords_d" value="<?php echo $_POST['keywords_D']; ?>" style="width:200px"></td>
</tr>
<?php
/*<tr>
<td style="width:200px">Ansicht</td>
<td width=130> <input type="radio" name="view" value="tab" <?php if($_POST['view'] == "tab" OR empty($_POST['view'])) echo "checked"; ?>> tabellarisch</td><td width=70><input type="radio" name="view" value="text" <?php if($_POST['view'] == "text") echo "checked"; ?>> Text</td>
</tr>*/
?>
<tr>
<td> </td>
<td colspan=3 align=right><input type="reset" name="reset" value="Eingaben löschen" onclick="formLeeren(1)";><input type="submit" name="submit" value="suchen"></td>
</tr>
</table><br />
</form>
<!--<table border=0>
<tr>
<td style="width:550px">
Stern <b>*</b> kann als Wildcard/Platzhalter genutzt werden. Ansonsten ist nur der Bindestrich <b>-</b> als Sonderzeichen zugelassen. Bei der Volltextsuche sind Wörter optimal mit Leerzeichen zu trennen.
</td>
</tr>
</table>-->
<?php
}
mysql_close($mysql_connection);
?>
<br /><br />
<table border="0">
<tr>
<td colspan=2>
<b>Metadaten zu den Urkarten der Reichsbodenschätzung / Statistik zu den geprüften Gemarkungen in FESCH </b><br />
Dieser Auszug ist gesetzlich geschützt und darf nur mit Zustimmung des Ministeriums der Finanzen des Landes Brandenburg vervielfältigt, umgearbeitet, veröffentlicht oder an Dritte weitergegeben werden.<br />Vervielfältigung und Umarbeitungen zur dienstlichen Verwendung innerhalb der Behörde oder zum eigenen nicht gewerblichen Gebrauch sind jedoch zulässig.
</td>
</tr>
</table><br />
</body>
</html>
Enable javascript to submit You have javascript disabled. You will not be able to edit any code.
Here you find the average performance (time & memory) of each version. A grayed out version indicates it didn't complete successfully (based on exit-code).
Version System time (s) User time (s) Memory (MiB) 8.3.6 0.023 0.000 17.00 8.3.5 0.007 0.007 16.54 8.3.4 0.012 0.003 19.21 8.3.3 0.008 0.008 19.21 8.3.2 0.011 0.000 20.54 8.3.1 0.005 0.003 22.17 8.3.0 0.004 0.004 19.33 8.2.18 0.012 0.009 18.68 8.2.17 0.009 0.006 22.96 8.2.16 0.017 0.000 20.64 8.2.15 0.008 0.000 24.18 8.2.14 0.004 0.004 24.66 8.2.13 0.008 0.000 21.00 8.2.12 0.004 0.004 26.35 8.2.11 0.003 0.006 20.77 8.2.10 0.003 0.010 18.16 8.2.9 0.006 0.003 18.22 8.2.8 0.005 0.003 19.27 8.2.7 0.003 0.006 18.00 8.2.6 0.004 0.004 18.18 8.2.5 0.003 0.006 18.29 8.2.4 0.004 0.004 20.61 8.2.3 0.004 0.004 21.13 8.2.2 0.003 0.006 18.54 8.2.1 0.000 0.008 18.37 8.2.0 0.000 0.008 18.46 8.1.28 0.014 0.007 25.92 8.1.27 0.004 0.004 23.82 8.1.26 0.004 0.004 26.35 8.1.25 0.008 0.000 28.09 8.1.24 0.011 0.000 23.92 8.1.23 0.008 0.004 22.75 8.1.22 0.009 0.000 18.03 8.1.21 0.006 0.003 19.03 8.1.20 0.004 0.004 17.60 8.1.19 0.000 0.009 17.60 8.1.18 0.003 0.005 18.10 8.1.17 0.004 0.004 18.77 8.1.16 0.004 0.004 19.26 8.1.15 0.003 0.005 19.28 8.1.14 0.003 0.005 19.87 8.1.13 0.006 0.003 19.17 8.1.12 0.004 0.004 17.70 8.1.11 0.004 0.004 17.79 8.1.10 0.004 0.004 17.63 8.1.9 0.000 0.008 17.76 8.1.8 0.004 0.004 17.63 8.1.7 0.004 0.004 17.79 8.1.6 0.000 0.009 17.93 8.1.5 0.008 0.000 17.87 8.1.4 0.004 0.004 17.93 8.1.3 0.005 0.003 17.97 8.1.2 0.000 0.009 18.01 8.1.1 0.003 0.006 17.89 8.1.0 0.005 0.003 17.75 8.0.30 0.004 0.004 20.43 8.0.29 0.000 0.008 17.25 8.0.28 0.008 0.000 18.74 8.0.27 0.000 0.007 17.49 8.0.26 0.003 0.006 17.25 8.0.25 0.000 0.007 17.38 8.0.24 0.003 0.006 17.42 8.0.23 0.007 0.003 17.34 8.0.22 0.004 0.004 17.28 8.0.21 0.004 0.004 17.35 8.0.20 0.000 0.008 17.43 8.0.19 0.007 0.003 17.24 8.0.18 0.008 0.000 17.35 8.0.17 0.007 0.000 17.30 8.0.16 0.000 0.007 17.40 8.0.15 0.003 0.005 17.14 8.0.14 0.000 0.008 17.10 8.0.13 0.000 0.006 13.77 8.0.12 0.004 0.004 17.25 8.0.11 0.000 0.008 17.18 8.0.10 0.003 0.006 17.37 8.0.9 0.003 0.006 17.34 8.0.8 0.010 0.014 17.21 8.0.7 0.004 0.004 17.34 8.0.6 0.004 0.004 17.16 8.0.5 0.008 0.000 17.33 8.0.3 0.009 0.011 17.36 8.0.2 0.016 0.004 17.47 8.0.1 0.003 0.006 17.25 8.0.0 0.009 0.009 17.00 7.4.33 0.003 0.003 15.55 7.4.32 0.000 0.007 16.79 7.4.30 0.000 0.007 16.87 7.4.29 0.008 0.003 16.88 7.4.28 0.000 0.008 16.69 7.4.27 0.005 0.003 16.82 7.4.26 0.004 0.004 16.74 7.4.25 0.003 0.006 16.85 7.4.24 0.004 0.004 16.92 7.4.23 0.000 0.007 16.89 7.4.22 0.012 0.006 16.92 7.4.21 0.004 0.010 16.77 7.4.20 0.004 0.004 16.71 7.4.16 0.008 0.010 16.82 7.4.15 0.010 0.010 17.40 7.4.14 0.007 0.015 17.86 7.4.13 0.008 0.016 17.02 7.4.12 0.012 0.008 16.83 7.4.11 0.012 0.006 16.84 7.4.10 0.006 0.012 16.80 7.4.9 0.008 0.012 16.88 7.4.8 0.011 0.008 19.39 7.4.7 0.010 0.011 16.88 7.4.6 0.004 0.014 16.93 7.4.5 0.003 0.010 16.63 7.4.4 0.009 0.008 16.90 7.4.3 0.010 0.006 16.95 7.4.0 0.007 0.010 15.35 7.3.33 0.003 0.003 13.73 7.3.32 0.003 0.003 13.64 7.3.31 0.000 0.007 16.54 7.3.30 0.000 0.007 16.58 7.3.29 0.008 0.007 16.75 7.3.28 0.007 0.013 16.67 7.3.27 0.010 0.009 17.40 7.3.26 0.014 0.008 16.78 7.3.25 0.015 0.008 16.71 7.3.24 0.012 0.009 16.64 7.3.23 0.011 0.015 16.74 7.3.21 0.017 0.000 16.68 7.3.20 0.007 0.010 16.73 7.3.19 0.012 0.008 16.85 7.3.18 0.010 0.010 16.79 7.3.17 0.010 0.013 16.70 7.3.16 0.013 0.003 16.56 7.3.12 0.009 0.010 15.22 7.3.11 0.009 0.006 15.00 7.3.10 0.006 0.009 15.10 7.3.9 0.003 0.009 15.09 7.3.8 0.008 0.006 15.19 7.3.7 0.005 0.009 15.12 7.3.6 0.009 0.006 15.18 7.3.5 0.007 0.009 15.11 7.3.4 0.006 0.009 15.14 7.3.3 0.010 0.005 15.12 7.3.2 0.007 0.008 16.66 7.3.1 0.006 0.009 16.61 7.3.0 0.008 0.007 16.64 7.2.33 0.010 0.010 16.93 7.2.32 0.006 0.013 16.91 7.2.31 0.007 0.011 17.05 7.2.30 0.006 0.012 16.73 7.2.29 0.009 0.009 16.68 7.2.25 0.008 0.011 15.17 7.2.24 0.007 0.012 15.20 7.2.23 0.007 0.008 15.26 7.2.22 0.004 0.007 15.28 7.2.21 0.008 0.005 15.10 7.2.20 0.003 0.011 15.17 7.2.19 0.001 0.014 15.25 7.2.18 0.006 0.011 15.11 7.2.17 0.007 0.007 15.22 7.2.9 0.056 0.006 14.80 7.2.8 0.058 0.010 15.05 7.2.7 0.051 0.012 15.03 7.2.6 0.064 0.003 15.33 7.2.5 0.059 0.010 14.99 7.2.4 0.046 0.013 15.23 7.2.3 0.062 0.010 15.10 7.2.2 0.060 0.010 15.38 7.2.1 0.013 0.005 15.20 7.2.0 0.013 0.010 14.99 7.1.33 0.005 0.010 15.64 7.1.32 0.003 0.010 15.85 7.1.31 0.009 0.006 15.85 7.1.30 0.007 0.007 15.67 7.1.29 0.008 0.004 15.79 7.1.28 0.004 0.009 15.88 7.1.27 0.006 0.006 15.85 7.1.26 0.006 0.009 15.68 7.1.21 0.087 0.012 13.93 7.1.20 0.052 0.003 14.15 7.1.19 0.057 0.014 14.10 7.1.18 0.080 0.010 13.66 7.1.17 0.057 0.003 13.93 7.1.16 0.018 0.007 14.11 7.1.15 0.061 0.006 14.08 7.1.14 0.100 0.003 14.18 7.1.13 0.102 0.000 13.99 7.1.12 0.087 0.010 13.98 7.1.11 0.076 0.006 14.00 7.1.10 0.044 0.007 14.07 7.1.9 0.013 0.006 14.16 7.1.8 0.032 0.003 14.20 7.1.7 0.005 0.010 14.34 7.1.6 0.071 0.007 31.99 7.1.5 0.034 0.007 31.79 7.1.4 0.028 0.007 31.94 7.1.3 0.036 0.004 32.12 7.1.2 0.056 0.009 32.14 7.1.1 0.034 0.012 13.74 7.1.0 0.089 0.014 14.24 7.0.31 0.049 0.006 13.28 7.0.30 0.066 0.013 13.75 7.0.29 0.076 0.006 13.61 7.0.28 0.070 0.010 13.45 7.0.27 0.056 0.007 13.93 7.0.26 0.075 0.003 13.73 7.0.25 0.076 0.010 13.79 7.0.24 0.006 0.009 13.92 7.0.23 0.047 0.007 13.86 7.0.22 0.054 0.006 13.78 7.0.21 0.083 0.011 13.92 7.0.20 0.078 0.010 13.69 7.0.19 0.028 0.007 13.57 7.0.18 0.058 0.010 13.73 7.0.17 0.017 0.006 13.86 7.0.16 0.007 0.013 13.85 7.0.15 0.041 0.011 13.83 7.0.14 0.004 0.015 13.58 7.0.13 0.075 0.003 13.66 7.0.12 0.057 0.010 14.06 7.0.11 0.073 0.010 13.79 7.0.10 0.081 0.007 13.63 7.0.9 0.073 0.013 13.85 7.0.8 0.113 0.007 13.57 7.0.7 0.057 0.006 13.87 7.0.6 0.106 0.013 13.94 7.0.5 0.093 0.013 13.86 7.0.4 0.057 0.007 13.87 7.0.3 0.099 0.004 13.61 7.0.2 0.090 0.003 13.88 7.0.1 0.054 0.003 13.71 7.0.0 0.036 0.004 13.92
preferences:dark mode live preview
42.19 ms | 400 KiB | 5 Q