[Mapbender-commits] r9871 - trunk/mapbender/http/classes

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2018-02-19 07:54:13 -0800 (Mon, 19 Feb 2018)
New Revision: 9871

Modified:
   trunk/mapbender/http/classes/class_syncCkan.php
Log:
Next fix - set layer name to layer_uuid

Modified: trunk/mapbender/http/classes/class_syncCkan.php
===================================================================
--- trunk/mapbender/http/classes/class_syncCkan.php	2018-02-19 15:37:02 UTC (rev 9870)
+++ trunk/mapbender/http/classes/class_syncCkan.php	2018-02-19 15:54:13 UTC (rev 9871)
@@ -1170,7 +1170,7 @@
 		case "layer":
 			$sql = <<<SQL
 
-SELECT layer.layer_id as metadata_id, layer.layer_title as title, layer.layer_abstract as abstract ,  f_get_responsible_organization_for_ressource(layer.fkey_wms_id, 'wms') as resp_party_id, termsofuse.* FROM layer LEFT OUTER JOIN wms_termsofuse ON layer.fkey_wms_id = wms_termsofuse.fkey_wms_id LEFT OUTER JOIN termsofuse ON wms_termsofuse.fkey_termsofuse_id = termsofuse.termsofuse_id WHERE layer.uuid = $1 AND layer.export2csw IS true AND layer.layer_searchable = 1
+SELECT layer.layer_id as metadata_id, layer.uuid, layer.layer_title as title, layer.layer_abstract as abstract ,  f_get_responsible_organization_for_ressource(layer.fkey_wms_id, 'wms') as resp_party_id, termsofuse.* FROM layer LEFT OUTER JOIN wms_termsofuse ON layer.fkey_wms_id = wms_termsofuse.fkey_wms_id LEFT OUTER JOIN termsofuse ON wms_termsofuse.fkey_termsofuse_id = termsofuse.termsofuse_id WHERE layer.uuid = $1 AND layer.export2csw IS true AND layer.layer_searchable = 1
 
 SQL;
 			break;
@@ -1242,6 +1242,8 @@
 	}
 	if ($resourceType == 'metadata') {
 		$ckanPackage->spatial = $row['geojson'];
+	} else {	
+		$ckanPackage->spatial = '{"type":"Polygon","coordinates":[[[6.05975,48.934399999999997],[6.05975,50.947499999999998],[8.51291,50.947499999999998],[8.51291,48.934399999999997],[6.05975,48.934399999999997]]]}';
 	}
         //$ckanPackage->url = "";
 	//special categories