<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>
- Output for git.master, git.master_jit, rfc.property-hooks
- <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 />
Warning: Undefined array key "PHP_AUTH_USER" in /in/4aPln on line 217
Warning: include(): open_basedir restriction in effect. File(../includes/config.inc.php) is not within the allowed path(s): (/tmp:/in:/etc) in /in/4aPln on line 223
Warning: include(../includes/config.inc.php): Failed to open stream: Operation not permitted in /in/4aPln on line 223
Warning: include(): Failed opening '../includes/config.inc.php' for inclusion (include_path='.:') in /in/4aPln on line 223
Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /in/4aPln:224
Stack trace:
#0 {main}
thrown in /in/4aPln on line 224
Process exited with code 255.
This tab shows result from various feature-branches currently under review by the php developers. Contact me to have additional branches featured.
Active branches
Archived branches
Once feature-branches are merged or declined, they are no longer available. Their functionality (when merged) can be viewed from the main output page
preferences:
45.7 ms | 409 KiB | 8 Q