- ".$translation['layer'];
break;
case "wfs":
$wfsId = $id;
$sql = "SELECT ";
$sql .= "wfs.wfs_title as servicetitle, wfs.wfs_version as serviceversion, wfs.wfs_abstract as serviceabstract, wfs.wfs_id as serviceid, wfs.wfs_id as contentid,wfs.fees, wfs.accessconstraints, wfs.individualname as contactperson, wfs.wfs_getcapabilities,";
$sql .= "wfs.positionname as contactposition, wfs.providername as contactorganization, wfs.deliverypoint as address, wfs.city, wfs_timestamp as timestamp, wfs_owner as owner, wfs.wfs_owsproxy as owsproxy, wfs.fkey_mb_group_id,";
$sql .= "wfs.administrativearea as stateorprovince, wfs.postalcode as postcode, wfs.voice as contactvoicetelephone, wfs.facsimile as contactfacsimiletelephone, ";
$sql .= "wfs.electronicmailaddress as contactelectronicmailaddress, wfs.country ";
$sql .= "FROM wfs WHERE wfs_id = $1";
$v = array($wfsId);
$t = array('i');
$resourceSymbol = "
- ".$translation['wfs'];
$serviceType = 'wfs';
break;
case "featuretype":
$featuretypeId = $id;
$sql = "SELECT ";
$sql .= "wfs_featuretype.featuretype_id as contentid, wfs_featuretype.featuretype_title as contenttitle, wfs_featuretype.featuretype_abstract as contentabstract, wfs_featuretype.featuretype_name as contentname,wfs_featuretype.featuretype_srs, ";
$sql .= "wfs.wfs_title as servicetitle, wfs.wfs_version as serviceversion, wfs.wfs_abstract as serviceabstract, wfs.wfs_id as serviceid, wfs.fees, wfs.accessconstraints, wfs.individualname as contactperson, wfs.wfs_getcapabilities, wfs.wfs_describefeaturetype, ";
$sql .= "wfs.positionname as contactposition, wfs.providername as contactorganization, wfs.deliverypoint as address, wfs.city, wfs_timestamp as timestamp, wfs_owner as owner, wfs.wfs_owsproxy as owsproxy, wfs.fkey_mb_group_id,";
$sql .= "wfs.administrativearea as stateorprovince, wfs.postalcode as postcode, wfs.voice as contactvoicetelephone, wfs.facsimile as contactfacsimiletelephone, ";
$sql .= "wfs.electronicmailaddress as contactelectronicmailaddress, wfs.country ";
$sql .= "FROM wfs_featuretype, wfs WHERE wfs_featuretype.featuretype_id = $1 AND wfs_featuretype.fkey_wfs_id = wfs.wfs_id LIMIT 1";
$v = array($featuretypeId);
$t = array('i');
$serviceType = 'wfs';
$resourceSymbol = "
- ".$translation['featuretype'];
$serviceType = 'wfs';
break;
case "wfs-conf":
echo 'Not yet implemented!';
$serviceType = 'wfs';
die();
break;
case "wmc":
$wmcId = $id;
$sql = "SELECT ";
$sql .= "mb_user_wmc.wmc_serial_id as contentid, mb_user_wmc.wmc_title as contenttitle, mb_user_wmc.abstract as contentabstract, mb_user_wmc.minx as contentminx,mb_user_wmc.miny as contentminy,mb_user_wmc.maxx as contentmaxx,mb_user_wmc.maxy as contentmaxy,mb_user_wmc.srs as contentcrs, ";
$sql .= "mb_user.mb_user_position_name as contactposition, mb_user.mb_user_organisation_name as contactorganization, (mb_user.mb_user_street || ' ' || mb_user.mb_user_housenumber) as address, mb_user.mb_user_city as city, mb_user_wmc.wmc_timestamp as timestamp, mb_user_wmc.fkey_user_id as owner,";
$sql .= "mb_user.mb_user_country as stateorprovince, mb_user.mb_user_postal_code as postcode, mb_user.mb_user_phone as contactvoicetelephone, mb_user.mb_user_phone1 as contactfacsimiletelephone, ";
$sql .= "mb_user.mb_user_email as contactelectronicmailaddress ";
$sql .= "FROM mb_user_wmc, mb_user WHERE mb_user_wmc.wmc_serial_id = $1 AND mb_user_wmc.fkey_user_id = mb_user.mb_user_id LIMIT 1";
$v = array($wmcId);
$t = array('i');
$serviceType = 'wmc';
$resourceSymbol = "
- ".$translation['wmc'];
break;
}
//read resource information from database
//$e = new mb_exception("mod_showMetadata: sql: ".$sql);
$res = db_prep_query($sql,$v,$t);
$resourceMetadata = db_fetch_array($res);
if (!isset($resourceMetadata['contentid']) or ($resourceMetadata['contentid'] == '')) {
echo 'No result for the requested id found in the registry!';
die();
}
if($resourceMetadata['owsproxy']!='') {
$resourceSecured = true;
}
else {
$resourceSecured = false;
}
$serviceId = $resourceMetadata['serviceid'];
/*switch ($serviceType) {
case "wms":
#$resourceSymbol = "- ';
$html .= '
- '.$translation["overview"].' '; $html .= '
- '.$translation["properties"].' '; $html .= '
- '.$translation["contact"].' '; $html .= '
- '.$translation["termsOfUse"].' '; $html .= '
- '.$translation["quality"].' '; $html .= '
- '.$translation["interfaces"].' '; $html .= '
| \n\t\t\t"; $t_b = "\n\t\t | \n\t\t\n\t\t\t"; $t_c = "\n\t\t | \n\t
|---|
'.$translation["overview"].'
'; $html .= ''.$translation["overview"].'
'; $html .= '';
$html .= $tableBegin;
if ($resourceMetadata['contenttitle'] !='') {
$html .= $t_a.$translation['resourceTitle'].$t_b."".displayText($resourceMetadata['contenttitle'])."".$t_c;
} else {
$html .= $t_a.$translation['resourceTitle'].$t_b."".displayText($resourceMetadata['servicetitle'])."".$t_c;
}
//decide if a root layer have been found - then the type will be a server
#$html .= "
".$resourceMetadata['contentpos']."
";
#$html .= "
".$resource."
";
if ($resource == 'layer' & $resourceMetadata['contentpos'] == 0) {
$resourceSymbol = "
- ".$translation['wms'];
}
$html .= $t_a.$translation['kindOfResource'].$t_b.$resourceSymbol.$t_c;
//identification information:
$html .= $t_a.$translation['contentId'].$t_b.$resourceMetadata['contentid'].$t_c;
if (isset($resourceMetadata['contentname']) && ($resourceMetadata['contentname'] != '')) {
$html .= $t_a.$translation['contentName'].$t_b.$resourceMetadata['contentname'].$t_c;
}
if ($resource != 'wmc') {
$html .= $t_a.$translation['serviceId'].$t_b."".$serviceId."".$t_c;
}
if (($resource == 'wms' or $resource == 'layer' or $resource == 'wmc' ) and isset($resourceMetadata['preview'])) {
$html .= $t_a.$translation['preview'].$t_b.$resourceMetadata['preview'];
if (isset($resourceMetadata['legend'])) {
$html .= $resourceMetadata['legend'];
}
$html .= $t_c;
}
if ($metadataContactGroup['metadatapointofcontactorglogo'] != '') {
$html .= $t_a.$translation['contactOrganization'].$t_b."";
}
$html .= displayText($metadataContactGroup['metadatacontactorganization']).$t_c;
if ($resourceMetadata['contentabstract'] != '') {
$html .= $t_a.$translation['resourceAbstract'].$t_b.displayText($resourceMetadata['contentabstract']).$t_c;
} else {
$html .= $t_a.$translation['resourceAbstract'].$t_b.displayText($resourceMetadata['serviceabstract']).$t_c;
}
$user = new User();
$layerAccessibility = $user->isLayerAccessible ($layerId);
//
//
// Monitoring is only available if the user is allowed to access this service
//
if ($resource == 'wms' or $resource == 'layer'){
if ($layerAccessibility) {
$is_public = $user->isPublic();
//show abo function to registred and authorized users
if (!$is_public) {
if ($subscribe == 1) {
$user->addSubscription($resourceMetadata['serviceid']);
}
else if ($subscribe == 0) {
$user->cancelSubscription($resourceMetadata['serviceid']);
}
$is_subscribed = $user->hasSubscription($resourceMetadata['serviceid']);
if ($is_subscribed) {
$aboStr = "
".$t_c;
$html .= $t_a."".$t_b."".$t_c;
}
if (WRAPPER_PATH != '' && $resource == 'wmc') {
$showMapUrl = $mapbenderBaseUrl.WRAPPER_PATH."?WMC=".$resourceMetadata['contentid'];
//$html .= $t_a.$translation['addLayerToMap'].$t_b."".$t_c;
$html .= $t_a."".$t_b."".$t_c;
}
$html .= $tableEnd;
$html .= '';
$html .= ''.$translation["properties"].'
'; $html .= ''.$translation["properties"].'
'; $html .= '';
$html .= $tableBegin;
if ($resource == 'wms' or $resource == 'layer'){
if ($resourceMetadata['layer_queryable'] == '1') {
$html .= $t_a.$translation['queryable'].$t_b."
".$t_c;
} else {
$html .= $t_a.$translation['queryable'].$t_b."
".$t_c;
}
}
$epsgString = '';
if (($resource == 'wms') || ($resource == 'layer')) {
for ($j = 0; $j < count($contentBboxes); $j++) {
$epsgString .= $contentBboxes[$j]['epsg']." ";
if ($contentBboxes[$j]['epsg'] == 'EPSG:4326') {
$wgs84Bbox = $contentBboxes[$j]['minx'].",".$contentBboxes[$j]['miny'].",".$contentBboxes[$j]['maxx'].",".$contentBboxes[$j]['maxy'];
$getMapUrl = getExtentGraphic(explode(",", $wgs84Bbox));
}
}
$html .= $t_a.$translation['crs'].$t_b.$epsgString.$t_c;
}
if (($resource == 'featuretype') ) {
$epsgString .= $resourceMetadata['featuretype_srs'];
$html .= $t_a.$translation['crs'].$t_b.$epsgString.$t_c;
}
if ($resource == 'wmc') {
$epsgString .= $resourceMetadata['contentcrs']." ";
if ($resourceMetadata['contentcrs'] == 'EPSG:4326') {
$wgs84Bbox = $resourceMetadata['contentminx'].",".$resourceMetadata['contentminy'].",".$resourceMetadata['contentmaxx'].",".$resourceMetadata['contentmaxy'];
$getMapUrl = getExtentGraphic(explode(",", $wgs84Bbox));
} elseif ($resourceMetadata['contentcrs'] != ''){
//transform crs
$oldEPSG = preg_replace("/EPSG:/","", $resourceMetadata['contentcrs']);
$ll = transform(
floatval($resourceMetadata['contentminx']),
floatval($resourceMetadata['contentminy']),
$oldEPSG,
"4326"
);
$ur = transform(
floatval($resourceMetadata['contentmaxx']),
floatval($resourceMetadata['contentmaxy']),
$oldEPSG,
"4326"
);
$wgs84Bbox = round($ll["x"],4).",".round($ll["y"],4).",".round($ur["x"],4).",".round($ur["y"],4);
$getMapUrl = getExtentGraphic(explode(",", $wgs84Bbox));
}
$html .= $t_a.$translation['wmccrs'].$t_b.$epsgString.$t_c;
}
if (isset($wgs84Bbox)) {
$html .= $t_a.$translation['wgs84Bbox'].$t_b.$wgs84Bbox.$t_c;
if (defined('EXTENTSERVICEURL')) {
$html .= $t_a.$translation['wgs84BboxGraphic'].$t_b."".$t_c;
} else {
$html .= $t_a.$translation['wgs84BboxGraphic'].$t_b.$translation['graphicUnavailable'].$t_c;
}
//show preview map - dynamically
}
$html .= $tableEnd;
$html .= $tableBegin;
//Scales
if ((isset($resourceMetadata['contentminscale']) & $resourceMetadata['contentminscale'] != '0') or (isset($resourceMetadata['contentmaxscale']) & $resourceMetadata['contentmaxscale'] != '0')){
$html .= $t_a.$translation['restrictedScale'].$t_b.$t_c;
if (isset($resourceMetadata['contentminscale']) & $resourceMetadata['contentminscale'] != '0' & $resourceMetadata['contentminscale'] != "") {
$html .= $t_a.$translation['maxscale'].$t_b. "1 : ".$resourceMetadata['contentminscale'].$t_c;
}
if (isset($resourceMetadata['contentmaxscale']) & $resourceMetadata['contentmaxscale'] != '0' & $resourceMetadata['contentmaxscale'] != "") {
$html .= $t_a.$translation['minscale'].$t_b. "1 : ".$resourceMetadata['contentmaxscale'].$t_c;
}
//$html .= '';
}
$html .= $tableEnd;
if (isset($resourceMetadata['wfs_describefeaturetype']) && ($resourceMetadata['wfs_describefeaturetype'] != '')) {
$html .= $t_a.$translation['describeFeaturetype'].$t_b."Link".$t_c;
#$html .= $t_a.$translation['describeFeaturetype'].$t_b."Link".$t_c;
}
if (isset($resourceMetadata['featuretype_geomType']) && ($resourceMetadata['featuretype_geomType'] != '')) {
$html .= $t_a.$translation['geomtype'].$t_b.$resourceMetadata['featuretype_geomType'].$t_c;
}
if ($resource == 'wms' or $resource == 'layer'){
$html .= $tableBegin;
//part for coupled resources - if they exists (first this is realized only for layers):
//get metadata entries
//get MetadataURLs from md_metadata table
$sql = <<
";
break;
case "upload" :
$metadataList .= "
";
break;
case "metador" :
$metadataList .= "
";
break;
default:
break;
}
$metadataList .= "".$row["uuid"]." ".$translation['validate']."
";
$i++;
}
if ($i != 0) {
$html .= $t_a.$translation['Coupled Metadata'].$t_b;
$html .= $metadataList;
}
$html .= $t_c;
$html .= $tableEnd;
}
$html .= $tableEnd;
$html .= '
'.$translation["contact"].'
'; $html .= ''.$translation["contact"].'
'; $html .= ''; $html .= '
'.$translation['metadataProvider'].'
'; $html .= $tableBegin; if ($metadataContactGroup['metadatapointofcontactorglogo'] != '') { $html .= $t_a.$translation['logo'].$t_b."'.$translation['serviceProvider'].'
'; $html .= $tableBegin; $html .= $t_a.$translation['contactOrganization'].$t_b.displayText($resourceMetadata['contactorganization']).$t_c; $html .= $t_a.$translation['contactPerson'].$t_b.displayText($resourceMetadata['contactperson']).$t_c; $html .= $t_a.$translation['contactAddress'].$t_b.displayText($resourceMetadata['address']).$t_c; $html .= $t_a.$translation['contactCity'].$t_b.displayText($resourceMetadata['postcode'].' '.$resourceMetadata['city']).$t_c; $html .= $t_a.$translation['contactTelephone'].$t_b.displayText($resourceMetadata['contactvoicetelephone']).$t_c; $html .= $t_a.$translation['email'].$t_b.displayText($resourceMetadata['contactelectronicmailaddress']).$t_c; $html .= $tableEnd; $html .= ''; $html .= ''.$translation["termsOfUse"].'
'; $html .= ''.$translation["termsOfUse"].'
'; $html .= ''; if ($resource == 'wms' or $resource == 'layer') { $touServiceConnector = new connector($mapbenderProtocol."localhost".$_SERVER['SCRIPT_NAME']."/../mod_getServiceDisclaimer.php?resource=wms&id=".$resourceMetadata['serviceid']."&languageCode=".$languageCode."&asTable=true"); $tou = $touServiceConnector->file; } if ($resource == 'wmc' ) { $e = new mb_notice("mod_showMetadata: wmcid for disclaimer: ".$resourceMetadata['contentid']); $touWmcConnector = new connector($mapbenderProtocol."localhost".$_SERVER['SCRIPT_NAME']."/../mod_getWmcDisclaimer.php?&id=".$resourceMetadata['contentid']."&languageCode=".$languageCode."&hostName=".$hostName); $tou = $touWmcConnector->file; } if ($tou == ''){ $html .= $translation['noTouInformation']; } else { $html .= $tou; } $html .= '
'; $html .= ''.$translation["quality"].'
'; $html .= ''.$translation["quality"].'
'; $html .= '';
$html .= $tableBegin;
if ($resource != 'wmc') {
switch ($serviceQuality['last_status']) {
case '1':
$html .= $t_a.$translation['status'].$t_b."
".$t_c;
break;
case '0':
$html .= $t_a.$translation['status'].$t_b."
".$t_c;
break;
case '-1':
$html .= $t_a.$translation['status'].$t_b."
".$t_c;
break;
}
if (isset($serviceQuality['availability'])) {
$html .= $t_a.$translation['availability'].$t_b.$serviceQuality['availability']." %".$t_c;
} else {
$html .= $t_a.$translation['availability'].$t_b.$translation['notMonitored'].$t_c;
}
} else { //resource is wmc
$html .= $translation['wmcQualityText'];
}
$html .= $tableEnd;
$html .= '
'.$translation["interfaces"].'
'; $html .= ''.$translation["interfaces"].'
'; $html .= '';
/*$translation['mapbenderCapabilities'] = 'Geoportal Capabilities';
$translation['originalCapabilities'] = 'Original Capabilities';
$translation['kml'] = 'KML';
$translation['inspireMetadata'] = 'INSPIRE Service Metadaten';
$translation['securedCapabilities'] = 'Secured Capabilities URL';*/
$html .= $tableBegin;
if ($resource == 'wmc') {
$html .= $t_a.$translation['wmc'].$t_b."XML".$t_c;
//show qr for link
//create uuid for qr graphic
$uuid = new Uuid;
$filename = "qr_wmc_".$uuid.".png";
//generate qr on the fly in tmp folder
//link to invoke wmc per get api if wrapper path isset
if (WRAPPER_PATH != "") {
$invokeLink = $mapbenderBaseUrl."".WRAPPER_PATH."?WMC=".$resourceMetadata['contentid'];
QRcode::png($invokeLink,TMPDIR."/".$filename);
$html .= $t_a.$translation['loadWmc'].$t_b."".$t_c;
}
}
if ($resource == 'wfs') {
}
if ($resource == 'wms' or $resource == 'layer'){
$html .= $t_a.$translation['mapbenderCapabilities'].$t_b."".$translation['capabilities']."
".$t_c;
$capUrl = $resourceMetadata['wms_getcapabilities'].getConjunctionCharacter($resourceMetadata['wms_getcapabilities']).'REQUEST=GetCapabilities&VERSION=1.1.1&SERVICE=WMS';
//show only original url if the resource is not secured!
if (!$resourceSecured) {
$html .= $t_a.$translation['originalCapabilities'].$t_b."".$translation['capabilities']."".$t_c;
}
$html .= $t_a.$translation['inspireCapabilities'].$t_b."".$translation['capabilities']." ".$t_c;
$html .= $t_a.$translation['inspireMetadata'].$t_b."
".$t_c;
$html .= $t_a.$translation['inspireMetadataValidation'].$t_b."".$translation['showInspireMetadataValidation']."".$t_c;
//if service is secured and http_auth is adjusted show secured url
if ($resourceSecured) {
$securedLink = HTTP_AUTH_PROXY."/".$layerId."?REQUEST=GetCapabilities&VERSION=1.1.1&SERVICE=WMS";
$html .= $t_a.$translation['securedCapabilities'].$t_b."".$translation['capabilities']." ".$t_c;
}
//kml
$html .= $t_a.$translation['kml'].$t_b."
".$t_c;
}
$html .= $tableEnd;
$html .= '
", $string); return $string; } function getExtentGraphic($layer_4326_box) { $rlp_4326_box = array(6.05,48.9,8.6,50.96); if ($layer_4326_box[0] <= $rlp_4326_box[0] || $layer_4326_box[2] >= $rlp_4326_box[2] || $layer_4326_box[1] <= $rlp_4326_box[1] || $layer_4326_box[3] >= $rlp_4326_box[3]) { if ($layer_4326_box[0] < $rlp_4326_box[0]) { $rlp_4326_box[0] = $layer_4326_box[0]; } if ($layer_4326_box[2] > $rlp_4326_box[2]) { $rlp_4326_box[2] = $layer_4326_box[2]; } if ($layer_4326_box[1] < $rlp_4326_box[1]) { $rlp_4326_box[1] = $layer_4326_box[1]; } if ($layer_4326_box[3] > $rlp_4326_box[3]) { $rlp_4326_box[3] = $layer_4326_box[3]; } $d_x = $rlp_4326_box[2] - $rlp_4326_box[0]; $d_y = $rlp_4326_box[3] - $rlp_4326_box[1]; $new_minx = $rlp_4326_box[0] - 0.05*($d_x); $new_maxx = $rlp_4326_box[2] + 0.05*($d_x); $new_miny = $rlp_4326_box[1] - 0.05*($d_y); $new_maxy = $rlp_4326_box[3] + 0.05*($d_y); if ($new_minx < -180) $rlp_4326_box[0] = -180; else $rlp_4326_box[0] = $new_minx; if ($new_maxx > 180) $rlp_4326_box[2] = 180; else $rlp_4326_box[2] = $new_maxx; if ($new_miny < -90) $rlp_4326_box[1] = -90; else $rlp_4326_box[1] = $new_miny; if ($new_maxy > 90) $rlp_4326_box[3] = 90; else $rlp_4326_box[3] = $new_maxy; } $getMapUrl = EXTENTSERVICEURL."VERSION=1.1.1&REQUEST=GetMap&SERVICE=WMS&LAYERS=".EXTENTSERVICELAYER."&STYLES=&SRS=EPSG:4326&BBOX=".$rlp_4326_box[0].",".$rlp_4326_box[1].",".$rlp_4326_box[2].",".$rlp_4326_box[3]."&WIDTH=120&HEIGHT=120&FORMAT=image/png&BGCOLOR=0xffffff&TRANSPARENT=TRUE&EXCEPTIONS=application/vnd.ogc.se_inimage&minx=".$layer_4326_box[0]."&miny=".$layer_4326_box[1]."&maxx=".$layer_4326_box[2]."&maxy=".$layer_4326_box[3]; return $getMapUrl; } //from php/mod_coordsLookup_server.php function transform ($x, $y, $oldEPSG, $newEPSG) { if (is_null($x) || !is_numeric($x) || is_null($y) || !is_numeric($y) || is_null($oldEPSG) || !is_numeric($oldEPSG) || is_null($newEPSG) || !is_numeric($newEPSG)) { return null; } $sqlMinx = "SELECT X(transform(GeometryFromText('POINT(".$x." ".$y.")',".$oldEPSG."),".$newEPSG.")) as minx"; $resMinx = db_query($sqlMinx); $minx = floatval(db_result($resMinx,0,"minx")); $sqlMiny = "SELECT Y(transform(GeometryFromText('POINT(".$x." ".$y.")',".$oldEPSG."),".$newEPSG.")) as miny"; $resMiny = db_query($sqlMiny); $miny = floatval(db_result($resMiny,0,"miny")); return array("x" => $minx, "y" => $miny); } function getConjunctionCharacter ($url) { if (mb_strpos($url, "?") !== false) { if (mb_substr($url, mb_strlen($url)-1, 1) == "?") { return ""; } else if (mb_substr($url, mb_strlen($url)-1, 1) == "&"){ return ""; } else { return "&"; } } else { return "?"; } return ""; } ?>