'.$testMatch.' is not valid.
';
echo 'Parameter adminLevel is not valid (NUTS_1, NUTS_2, NUTS_3, LAU_1, LAU_2, other).
';
die();
}
$adminLevel = $testMatch;
$testMatch = NULL;
}
if (isset($_REQUEST["categoryType"]) & $_REQUEST["categoryType"] != "") {
$testMatch = $_REQUEST["categoryType"];
if (!($testMatch == 'iso' or $testMatch == 'inspire' or $testMatch == 'custom' or $testMatch == 'opendata')){
//echo 'outputFormat: '.$testMatch.' is not valid.
';
echo 'Parameter categoryType is not valid (inspire, iso, custom).
';
die();
}
$categoryType = $testMatch;
$testMatch = NULL;
}
if (isset($_REQUEST["registratingDepartments"]) & $_REQUEST["registratingDepartments"] != "") {
//validate to csv integer list
$testMatch = $_REQUEST["registratingDepartments"];
$pattern = '/^[\d,]*$/';
if (!preg_match($pattern,$testMatch)){
//echo 'registratingDepartments: '.$testMatch.' is not valid.
';
echo 'Parameter registratingDepartments is not valid (integer or cs integer list).
';
die();
}
$registratingDepartments = $testMatch;
$testMatch = NULL;
}
$jsonString2 = << 0 AND fkey_mb_group_id is not null group by fkey_mb_group_id, wms_id union select wms_id, fkey_mb_group_id from (select wms_owner, wms_id from wms where fkey_mb_group_id = 0 OR fkey_mb_group_id is null group by wms_owner, wms_id) as owner_wms inner join mb_user_mb_group on owner_wms.wms_owner = mb_user_mb_group.fkey_mb_user_id where mb_user_mb_group_type = 2) as test inner join (select layer_id, fkey_wms_id from layer where layer_searchable=1) as layer on test.wms_id = layer.fkey_wms_id group by fkey_mb_group_id ) as layer_count inner join mb_group on mb_group.mb_group_id = layer_count.fkey_mb_group_id WHERE mb_group_admin_code = $1
SQL;
/*$sql = << 0 AND fkey_mb_group_id is not null group by fkey_mb_group_id, wms_id union select wms_id, fkey_mb_group_id from (select wms_owner, wms_id from wms where fkey_mb_group_id = 0 OR fkey_mb_group_id is null group by wms_owner, wms_id) as owner_wms inner join mb_user_mb_group on owner_wms.wms_owner = mb_user_mb_group.fkey_mb_user_id where mb_user_mb_group_type = 2) as test inner join layer on test.wms_id = layer.fkey_wms_id group by fkey_mb_group_id ) as layer_count inner join mb_group on mb_group.mb_group_id = layer_count.fkey_mb_group_id
SQL;*/
$v = array(str_replace('_',' ',$adminLevel));
$t = array('s');
$res = db_prep_query($sql,$v,$t);
$row = array();
$resultObj = array();
if ($res) {
$i = 0;
$dataCount = 0;
while ($row = db_fetch_assoc($res)) {
$resultObj[$i]["label"] = $row["mb_group_name"] . " (".(integer)$row["count"].")";
$resultObj[$i]["value"] = (integer)$row["count"];
$resultObj[$i]["caption"] = $row["mb_group_title"];
$resultObj[$i]["id"] = $row["mb_group_id"];
$dataCount = $dataCount + $resultObj[$i]["value"];
$i++;
}
if ($i == 0) {
$resultObj = false;
$e = new mb_exception("no results!");
} else {
for ($j=0;$jfile;
$jsonObject = json_decode($jsonString);
$i = 0;
$dataCount = 0;
foreach ($jsonObject->searchMD->category[$catId]->subcat as $cat) {
$resultObj[$i]["label"] = $cat->title . " (".$cat->count.")";
$resultObj[$i]["value"] = $cat->count;
$resultObj[$i]["caption"] = $cat->title;
$resultObj[$i]["id"] = $cat->id;
$dataCount = $dataCount + $resultObj[$i]["value"];
$i++;
}
} else {
//count twice - first for number of all results, second for number of opendata classified results
//call searchInterface
$connector = new connector(MAPBENDER_PATH."/php/mod_callMetadata.php?searchText=e&outputFormat=json&searchResources=wms&searchId=test®istratingDepartments=".$registratingDepartments."&maxResults=1");
$jsonString = $connector->file;
$jsonObject = json_decode($jsonString);
$numberOfResults = $jsonObject->wms->md->nresults;
$connector = new connector(MAPBENDER_PATH."/php/mod_callMetadata.php?searchText=e&outputFormat=json&searchResources=wms&searchId=test®istratingDepartments=".$registratingDepartments."&maxResults=1&restrictToOpenData=true");
$jsonString = $connector->file;
$jsonObject = json_decode($jsonString);
$numberOfOpenResults = $jsonObject->wms->md->nresults;
//define values to return
$dataCount = $numberOfResults;
if ($numberOfOpenResults == $numberOfResults) {
$resultObj[0]["label"] = "OpenData (100%)";
$resultObj[0]["value"] = $numberOfResults;
$resultObj[0]["caption"] = "OpenData";
$resultObj[0]["id"] = 0;
$i = 1;
} else {
$resultObj[0]["label"] = "OpenData";
$resultObj[0]["value"] = $numberOfOpenResults;
$resultObj[0]["caption"] = "OpenData";
$resultObj[0]["id"] = 1;
$resultObj[1]["label"] = "Keine freie Lizenz!";
$resultObj[1]["value"] = $numberOfResults;
$resultObj[1]["caption"] = "Keine freie Lizenz!";
$resultObj[1]["id"] = 0;
$i = 2;
}
}
if ($i == 0) {
$resultObj = false;
$e = new mb_exception("no results!");
} else {
for ($j=0;$j