"; echo $rowString; } die(); break; case 'monitoring': $metadataIndex = -1; $serviceIndex = 0; $orgaIndex = 0; $alreadyBuildDls = array(); $alreadyReadOrgas = array(); $alreadyBuildVs = array(); $currentUuid = ""; $inspireMonitoring = array( "datasets" => array(), "services" => array(), "organizations" => array() ); //loop over all found metadata uuids for ($i=0; $i < count($sqlTable['uuid']); $i++){ //filter for orga_id //generate entry only if orga_id is the same as expected if (!$registratingDepartments || ($registratingDepartments != null && in_array($groupOwnerArray[4][$i],explode(',',$registratingDepartments)))) { if ($sqlTable['uuid'][$i] != $currentUuid) { //new metadataset identified - initialize it $currentUuid = $sqlTable['uuid'][$i]; //logit($currentUuid); $metadataIndex++; //$e = new mb_exception("index: ".$metadataIndex); $inspireMonitoring['datasets'][$metadataIndex]->datasetid = $sqlTable['datasetid'][$i]; $inspireMonitoring['datasets'][$metadataIndex]->title = $sqlTable['title'][$i]; //logit($inspireMonitoring['datasets'][$metadataIndex]->title); $inspireMonitoring['datasets'][$metadataIndex]->organization = $sqlTable['organization'][$i]; $inspireMonitoring['datasets'][$metadataIndex]->orgaEmail = $sqlTable['orgaEmail'][$i]; $inspireMonitoring['datasets'][$metadataIndex]->relevantArea = (string)ceil((double)$sqlTable['inspire_whole_area'][$i]); $inspireMonitoring['datasets'][$metadataIndex]->actualArea = (string)ceil((double)$sqlTable['inspire_actual_coverage'][$i]); $inspireMonitoring['datasets'][$metadataIndex]->metadataExists = "[X]"; $inspireMonitoring['datasets'][$metadataIndex]->uuid = $sqlTable['uuid'][$i]; //metadata conform $inspireMonitoring['datasets'][$metadataIndex]->metadataConform = "[X]"; //metadata available $inspireMonitoring['datasets'][$metadataIndex]->metadataAvailable = "[X]"; $inspireMonitoring['datasets'][$metadataIndex]->viewServiceAvailable = ""; $inspireMonitoring['datasets'][$metadataIndex]->viewServiceId = ""; $inspireMonitoring['datasets'][$metadataIndex]->downloadServiceAvailable = ""; $inspireMonitoring['datasets'][$metadataIndex]->downloadServiceId = ""; if (isset($sqlTable['inspire_interoperability'][$i]) && $sqlTable['inspire_interoperability'][$i] == "t") { $inspireMonitoring['datasets'][$metadataIndex]->datasetConform = "[X]"; } else { $inspireMonitoring['datasets'][$metadataIndex]->datasetConform = ""; } $insCat = ''; $inspireMonitoring['datasets'][$metadataIndex]->inspireCategories = ''; $inspireMonitoring['datasets'][$metadataIndex]->numberViewServices = 0; $inspireMonitoring['datasets'][$metadataIndex]->numberDownloadServices = 0; $inspireMonitoring['datasets'][$metadataIndex]->report = ""; $inspireMonitoring['datasets'][$metadataIndex]->comment = ""; } if ($metadataIndex > -1) { //prohibit indexes which are not real - otherwise the json array will become an object //build view service //$e = new mb_exception("resource type: ".$sqlTable['resource_type'][$i]." - uuid: ".$sqlTable['uuid'][$i]); //build view services - but only once for each view service uuid (layer uuid) if ($sqlTable['resource_type'][$i] == "layer") { $inspireMonitoring['datasets'][$metadataIndex]->viewServiceId = $sqlTable['resource_uuid'][$i]; $inspireMonitoring['datasets'][$metadataIndex]->viewServiceId = $sqlTable['resource_uuid'][$i]; //get inspire categories $catString = $sqlTable['inspire_cat_monitoring'][$i]; $insCat .= $sqlTable['inspire_cat_monitoring'][$i]; if ($insCat != '') { $insCat .= ","; } $inspireMonitoring['datasets'][$metadataIndex]->numberViewServices++; if (!in_array($sqlTable['resource_uuid'][$i],$alreadyBuildVs)) { //addview view service $inspireMonitoring['services'][$serviceIndex]->id = $sqlTable['resource_uuid'][$i]; //name $inspireMonitoring['services'][$serviceIndex]->name = "Darstellungsdienst für ".$sqlTable['title'][$i]; //typ $inspireMonitoring['services'][$serviceIndex]->type = "Darstellungsdienst"; //url $inspireMonitoring['services'][$serviceIndex]->url = MAPBENDER_PATH."/php/wms.php?layer_id=".$sqlTable['resource_id'][$i]."&REQUEST=GetCapabilities&VERSION=1.1.1&SERVICE=WMS&INSPIRE=1"; //orga $inspireMonitoring['services'][$serviceIndex]->organization = $sqlTable['organization'][$i]; //orga email $inspireMonitoring['services'][$serviceIndex]->orgaEmail = $sqlTable['orgaEmail'][$i]; //metadata exists $inspireMonitoring['services'][$serviceIndex]->metadataExists = "[X]"; //service uuid - view/download difference $inspireMonitoring['services'][$serviceIndex]->serviceUuid = $sqlTable['resource_uuid'][$i]; //metadata conform $inspireMonitoring['services'][$serviceIndex]->metadataConform = "[X]"; //metadata available $inspireMonitoring['services'][$serviceIndex]->metadataAvailable = "[X]"; //service conform $inspireMonitoring['services'][$serviceIndex]->serviceConform = "[X]"; //requests per day $inspireMonitoring['services'][$serviceIndex]->requestsPerDay = ceil((integer)$sqlTable['inspire_annual_requests'][$i] / 365); //comment $inspireMonitoring['services'][$serviceIndex]->report = ""; //report $inspireMonitoring['services'][$serviceIndex]->comment = ""; //increment amount of view services /*if ($sqlTable['inspire_download'][$i] == 1) { //add further inspire_download service element for this layer //increment amount of view services $output['aaData'][$metadataIndex]->numberDownloadServices++; }*/ //$inspireMonitoring['datasets'][$metadataIndex]->numberViewServices++; $serviceIndex++; //Add view service to dataset list //$inspireMonitoring['datasets'][$metadataIndex]->viewServiceId = $sqlTable['resource_uuid'][$i]; $alreadyBuildVs[] = $sqlTable['resource_uuid'][$i]; } } //$e = new mb_exception("generate downloadservice"); if (!in_array($sqlTable['uuid'][$i],$alreadyBuildDls)) { //initialize array of uuids which are already tested for downloadservices! //the options are all the same for one single metadata uuid - therefor this has only to be done once for a uuid! //the service information is pulled from the first organization - TODO - maybe change this? //build download services //get download options //Pull download options for specific dataset from mapbender database and show them $downloadOptionsConnector = new connector("http://localhost".$_SERVER['SCRIPT_NAME']."/../../php/mod_getDownloadOptions.php?id=".$sqlTable['uuid'][$i]); //$e = new mb_exception("download options: ".$downloadOptionsConnector->file); $downloadOptions = json_decode($downloadOptionsConnector->file); if (defined("MAPBENDER_PATH") && MAPBENDER_PATH != '') { $mapbenderUrl = MAPBENDER_PATH; } else { $mapbenderUrl = "http://www.geoportal.rlp.de/mapbender"; } if ($downloadOptions != null) { $mdUuid = $sqlTable['uuid'][$i]; foreach ($downloadOptions->{$mdUuid}->option as $option) { //create download service entries //create ids for download services on the fly //How to generate UUIDs for INSPIRE Download Service Metadata records (not really needed for INSPIRE!!! See DB Metadaten) //12-4-4-4-8 //dataurl //LAYER uuid (12-4), Type (4) - 0001, MD uuid (4-8) //wfs //WFS uuid (12-4), MD uuid (4-4-8) //wmsgetmap //LAYER uuid (12-4), Type (4) - 0002, MD uuid (4-8) // //if (isset($sqlTable['service_uuid'][$i]) && $sqlTable['service_uuid'][$i] != '' ) { //TODO - don't use service uuids from table but from options! //TODO - what to do if metadata id is no uuid????? $uuid = new Uuid(); $uuidTest = $uuid->isuuid($mdUuid); if ($uuidTest) { $mdPart = explode('-',$mdUuid); //$e = new mb_exception("is uuid"); } else { //$e = new mb_exception("is not uuid"); $mdPart = array(); $mdPart[2] = substr($mdUuid,-12,-8); $mdPart[3] = substr($mdUuid,-4); } $servicePart = explode('-',$option->serviceUuid); //$mdPart = explode('-',$mdUuid); switch ($option->type) { case "wmslayergetmap": $dlsFileIdentifier = $servicePart[0]."-".$servicePart[1]."-"."0002"."-".$mdPart[3]."-".$mdPart[4]; $capUrl = $mapbenderUrl."/php/mod_inspireDownloadFeed.php?id=".$sqlTable['uuid'][$i]."&type=SERVICE&generateFrom=wmslayer&layerid=".$option->resourceId; break; case "wmslayerdataurl": $dlsFileIdentifier = $servicePart[0]."-".$servicePart[1]."-"."0001"."-".$mdPart[3]."-".$mdPart[4]; $capUrl = $mapbenderUrl."/php/mod_inspireDownloadFeed.php?id=".$sqlTable['uuid'][$i]."&type=SERVICE&generateFrom=dataurl&layerid=".$option->resourceId; break; case "wfsrequest": $dlsFileIdentifier = $servicePart[0]."-".$servicePart[1]."-".$mdPart[2]."-".$mdPart[3]."-".$mdPart[4]; $capUrl = $mapbenderUrl."/php/mod_inspireDownloadFeed.php?id=".$sqlTable['uuid'][$i]."&type=SERVICE&generateFrom=wfs&wfsid=".$option->serviceId; break; case "downloadlink": $linkPart = md5($option->link); $dlsFileIdentifier = $mdPart[0]."-".$mdPart[1]."-".$mdPart[2]."-".substr($linkPart, -12, 4)."-".substr($linkPart, -8, 8); $capUrl = $mapbenderUrl."/php/mod_inspireDownloadFeed.php?id=".$sqlTable['uuid'][$i]."&type=SERVICE&generateFrom=metadata&id=".$mdUuid; break; } /*} else { //generate dummy uuid - is not good! //$uuid = new Uuid(); //$dlsFileIdentifier = $uuid; $dlsFileIdentifier = "00000000-0000-0000-000000000000"; }*/ if (!in_array($dlsFileIdentifier,$alreadyBuildDls)) { //generate the rest of the service element //addview view service $inspireMonitoring['services'][$serviceIndex]->id = $dlsFileIdentifier; //name $inspireMonitoring['services'][$serviceIndex]->name = "Downloadservice für ".$sqlTable['title'][$i]; //typ $inspireMonitoring['services'][$serviceIndex]->type = "Download-Dienst"; //url $inspireMonitoring['services'][$serviceIndex]->url = $capUrl; //orga $inspireMonitoring['services'][$serviceIndex]->organization = $sqlTable['organization'][$i]; //orga email $inspireMonitoring['services'][$serviceIndex]->orgaEmail = $sqlTable['orgaEmail'][$i]; //metadata exists $inspireMonitoring['services'][$serviceIndex]->metadataExists = "[X]"; //service uuid - view/download difference $inspireMonitoring['services'][$serviceIndex]->serviceUuid = $dlsFileIdentifier; //metadata conform $inspireMonitoring['services'][$serviceIndex]->metadataConform = "[X]"; //metadata available $inspireMonitoring['services'][$serviceIndex]->metadataAvailable = "[X]"; //service conform $inspireMonitoring['services'][$serviceIndex]->serviceConform = "[X]"; //requests per day $inspireMonitoring['services'][$serviceIndex]->requestsPerDay = 0; //comment $inspireMonitoring['services'][$serviceIndex]->report = ""; //report $inspireMonitoring['services'][$serviceIndex]->comment = ""; $inspireMonitoring['datasets'][$metadataIndex]->numberDownloadServices++; $serviceIndex++; //add download service to dataset list $inspireMonitoring['datasets'][$metadataIndex]->downloadServiceId = $dlsFileIdentifier; $alreadyBuildDls[] = $dlsFileIdentifier; } } } } //$e = new mb_exception("generate organization entry"); if (!in_array($sqlTable['organization'][$i],$alreadyReadOrgas)) { $alreadyReadOrgas[] = $sqlTable['organization'][$i]; $inspireMonitoring['organizations'][$orgaIndex]->id = $sqlTable['orgaId'][$i]; $inspireMonitoring['organizations'][$orgaIndex]->name = $sqlTable['organization'][$i]; switch ($sqlTable['adminCode'][$i]) { case "NUTS 1": $inspireMonitoring['organizations'][$orgaIndex]->adminLevel = "Land"; break; case "NUTS 2": $inspireMonitoring['organizations'][$orgaIndex]->adminLevel = "Regierungsbezirk"; break; case "NUTS 3": $inspireMonitoring['organizations'][$orgaIndex]->adminLevel = "Landkreis"; break; case "LAU 1": $inspireMonitoring['organizations'][$orgaIndex]->adminLevel = "Verbandsgemeinde/Stadt"; break; case "LAU 2": $inspireMonitoring['organizations'][$orgaIndex]->adminLevel = "Gemeinde"; break; default: $inspireMonitoring['organizations'][$orgaIndex]->adminLevel = "Andere"; break; } $orgaIndex++; } if ($sqlTable['resource_type'][$i] == "wfs_featuretype" && $sqlTable['inspire_download'][$i] == "1") { //add download service element //$output['aaData'][$metadataIndex]->numberDownloadServices++; $insCat .= $sqlTable['inspire_cat_monitoring'][$i]; if ($insCat != '') { $insCat .= ","; } //$output['aaData'][$metadataIndex]->downloadServices[]->id = $sqlTable['resource_id'][$i]; } //reduce categories if there are double entries $arrayInspireCategories = array_unique(explode(',',(rtrim($insCat,',')))); //$e = new mb_exception($insCat); for ($j=0; $j < 34; $j++) { $catId = $j+1; if (in_array($catId,$arrayInspireCategories)) { $arrayInspireCat[$j] = "[X]"; } else { $arrayInspireCat[$j] = ""; } } $inspireMonitoring['datasets'][$metadataIndex]->inspireCategories = $arrayInspireCat; //set view and downloadservice information if ($inspireMonitoring['datasets'][$metadataIndex]->numberViewServices > 0) { $inspireMonitoring['datasets'][$metadataIndex]->viewServiceAvailable = "[X]"; } if ($inspireMonitoring['datasets'][$metadataIndex]->numberDownloadServices > 0) { $inspireMonitoring['datasets'][$metadataIndex]->downloadServiceAvailable = "[X]"; } } } } if (isset($exportObjects) && $exportObjects != null) { //echo "export ".$exportObjects; switch ($exportObjects) { case "datasets": $html = ""; foreach ($inspireMonitoring["datasets"] as $entry) { $row = ""; $row .= $entry->datasetid."|"; $row .= $entry->title."|"; $row .= $entry->organization."|"; $row .= $entry->orgaEmail."|"; $row .= $entry->relevantArea."|"; $row .= $entry->actualArea."|"; $row .= $entry->metadataExists."|"; $row .= $entry->uuid."|"; $row .= $entry->metadataConform."|"; $row .= $entry->metadataAvailable."|"; $row .= $entry->viewServiceAvailable."|"; $row .= $entry->viewServiceId."|"; $row .= $entry->downloadServiceAvailable."|"; $row .= $entry->downloadServiceId."|"; $row .= $entry->datasetConform."|"; foreach ($entry->inspireCategories as $category) { $row .= $category."|"; } $row .= $entry->report."|"; $row .= $entry->comment; $row .= "\r\n"; $html .= $row; } header('Content-type: application/octetstream'); header('Content-Length: ' . strlen($html)); header('Content-Disposition: attachment; filename="datasets.csv"'); echo $html; break; case "services": $html = ""; foreach ($inspireMonitoring["services"] as $entry) { $row = ""; $row .= $entry->id."|"; $row .= $entry->name."|"; $row .= $entry->type."|"; $row .= $entry->url."|"; $row .= $entry->organization."|"; $row .= $entry->orgaEmail."|"; $row .= $entry->metadataExists."|"; $row .= $entry->serviceUuid."|"; $row .= $entry->metadataConform."|"; $row .= $entry->metadataAvailable."|"; $row .= $entry->serviceConform."|"; $row .= $entry->requestsPerDay."|"; $row .= $entry->report."|"; $row .= $entry->comment; $row .= "\r\n"; $html .= $row; } header('Content-type: application/octetstream'); header('Content-Length: ' . strlen($html)); header('Content-Disposition: attachment; filename="services.csv"'); echo $html; break; case "organizations": $html = ""; foreach ($inspireMonitoring["organizations"] as $entry) { $row = ""; $row .= $entry->id."|"; $row .= $entry->name."|"; $row .= $entry->adminLevel; $row .= "\r\n"; $html .= $row; } header('Content-type: application/octetstream'); header('Content-Length: ' . strlen($html)); header('Content-Disposition: attachment; filename="organizations.csv"'); echo $html; break; } } else { //give away all information as json header('Content-Type: application/json; charset='.CHARSET); echo json_encode($inspireMonitoring, JSON_NUMERIC_CHECK); } break; default: //normal output as json $metadataIndex = -1; $currentUuid = ""; if (isset($iTotal)) { //$e = new mb_exception("iTotal= ".$iTotal); $output = array( "sEcho" => intval($_REQUEST['sEcho']), "iTotalRecords" => $iTotal, "iTotalDisplayRecords" => $iTotal, "aaData" => array() ); } else { $output = array( "sEcho" => intval($_REQUEST['sEcho']), "iTotalRecords" => $iTotal, "iTotalDisplayRecords" => $iTotal, "aaData" => array() ); } /*$output = array( "aaData" => array() );*/ for ($i=0; $i < count($sqlTable['uuid']); $i++){ //filter for orga_id //generate entry only if orga_id is the same as expected if (!$registratingDepartments || ($registratingDepartments != null && in_array($groupOwnerArray[4][$i],explode(',',$registratingDepartments)))) { if ($sqlTable['uuid'][$i] != $currentUuid) { //new metadataset identified - initialize it $currentUuid = $sqlTable['uuid'][$i]; $metadataIndex++; $output['aaData'][$metadataIndex]->detailImage = "
![](\"../img/gnome/stock_zoom-in.png\")
";
//$output['aaData'][$metadataIndex]->title = $sqlTable['title'][$i];
$output['aaData'][$metadataIndex]->title = "".$sqlTable['title'][$i]."";
$output['aaData'][$metadataIndex]->uuid = $sqlTable['uuid'][$i];
$output['aaData'][$metadataIndex]->organization = $sqlTable['organization'][$i];
$insCat = '';
$output['aaData'][$metadataIndex]->inspireCategories = '';
$output['aaData'][$metadataIndex]->numberViewServices = 0;
$output['aaData'][$metadataIndex]->numberDownloadServices = 0;
}
if ($metadataIndex > -1) { //prohibit indexes which are not real - otherwise the json array will become an object
if ($sqlTable['resource_type'][$i] == "layer") {
//addview service element
$output['aaData'][$metadataIndex]->viewServices[]->id = $sqlTable['resource_id'][$i];
$catString = $sqlTable['inspire_cat'][$i];
$insCat .= $sqlTable['inspire_cat'][$i];
if ($insCat != '') {
$insCat .= ",";
}
//increment amount of view services
$output['aaData'][$metadataIndex]->numberViewServices++;
if ($sqlTable['inspire_download'][$i] == 1) {
//add further inspire_download service element for this layer
//increment amount of view services
$output['aaData'][$metadataIndex]->numberDownloadServices++;
}
}
if ($sqlTable['resource_type'][$i] == "wfs_featuretype" && $sqlTable['inspire_download'][$i] == "1") {
//add download service element
$output['aaData'][$metadataIndex]->numberDownloadServices++;
$insCat .= $sqlTable['inspire_cat'][$i];
if ($insCat != '') {
$insCat .= ",";
}
//$output['aaData'][$metadataIndex]->downloadServices[]->id = $sqlTable['resource_id'][$i];
}
//reduce categories if there are double entries
$output['aaData'][$metadataIndex]->inspireCategories = implode(',',array_unique(explode(',',(rtrim($insCat,',')))));
}
}
if (isset($jsonLimit) && $metadataIndex >= $jsonLimit) {
break;
}
}
header('Content-Type: application/json; charset='.CHARSET);
echo json_encode($output, JSON_NUMERIC_CHECK);
//$endTime = microtime();
//$diffTime = $endTime - $startTime;
//echo "".$diffTime."
"; //echo "Ready!"; break; } function getOrganizationInfoForServices($groupOwnerArray) { //split array into two lists which are requested in two separate sqls $listGroupIds = array(); $listOwnerIds = array(); //echo "
count groupOwnerArray: ".count($groupOwnerArray[0]); for ($i=0; $i < count($groupOwnerArray[0]); $i++){ $key = $i; if (!isset($groupOwnerArray[0][$i]) || is_null($groupOwnerArray[0][$i]) || $groupOwnerArray[0][$i] == 0){ $listOwnerIds[$key] = $groupOwnerArray[1][$i]; } else { $listGroupIds[$key] = $groupOwnerArray[0][$i]; } } //for ownerList $metadataContactArray = array(); $metadataContact = array(); $listGroupIdsKeys = array_keys($listGroupIds); $listOwnerIdsKeys = array_keys($listOwnerIds); $listOwnerIdsString = implode(",",$listOwnerIds); $listGroupIdsString = implode(",",$listGroupIds); //do the database requests if ($listOwnerIdsString != "") { $sql = "SELECT mb_group_name as metadatapointofcontactorgname, mb_group_title as metadatapointofcontactorgtitle, mb_group_id, mb_group_logo_path as metadatapointofcontactorglogo, mb_group_address as metadatapointofcontactorgaddress, mb_group_email as metadatapointofcontactorgemail, mb_group_postcode as metadatapointofcontactorgpostcode, mb_group_city as metadatapointofcontactorgcity, mb_group_voicetelephone as metadatapointofcontactorgtelephone, mb_group_facsimiletelephone as metadatapointofcontactorgfax, mb_group_admin_code , b.mb_user_id as mb_user_id FROM mb_group AS a, mb_user AS b, mb_user_mb_group AS c WHERE b.mb_user_id IN (".$listOwnerIdsString.") AND b.mb_user_id = c.fkey_mb_user_id AND c.fkey_mb_group_id = a.mb_group_id AND c.mb_user_mb_group_type=2"; $resultOrgaOwner = db_query($sql); $index = 0; while ($row = db_fetch_array($resultOrgaOwner)) { //push information into metadataContactArray $metadataContactOwnerArray[$index]['metadatapointofcontactorgname'] = $row['metadatapointofcontactorgname']; $metadataContactOwnerArray[$index]['metadatapointofcontactorgemail'] = $row['metadatapointofcontactorgemail']; $metadataContactOwnerArray[$index]['mb_user_id'] = $row['mb_user_id']; $metadataContactOwnerArray[$index]['orga_id'] = $row['mb_group_id']; $metadataContactOwnerArray[$index]['admin_code'] = $row['mb_group_admin_code']; $index++; } $index = 0; //push information directly into $groupOwnerArray at indizes from for ($i=0; $i < count($listOwnerIdsKeys); $i++){ //find index of user with special id in array $metadataContactOwnerArray['user_id'] $index = findIndexInMultiDimArray($metadataContactOwnerArray, $listOwnerIds[$listOwnerIdsKeys[$i]], 'mb_user_id'); $groupOwnerArray[2][$listOwnerIdsKeys[$i]] = $metadataContactOwnerArray[$index]['user_id']; //user_id - 2 $groupOwnerArray[3][$listOwnerIdsKeys[$i]] = $metadataContactOwnerArray[$index]['metadatapointofcontactorgname']; //orga_name - 3 $groupOwnerArray[4][$listOwnerIdsKeys[$i]] = $metadataContactOwnerArray[$index]['orga_id']; $groupOwnerArray[5][$listOwnerIdsKeys[$i]] = $metadataContactOwnerArray[$index]['metadatapointofcontactorgemail']; //orga_email 5 $groupOwnerArray[6][$listOwnerIdsKeys[$i]] = $metadataContactOwnerArray[$index]['admin_code']; // 6 } } //for groupList if ($listGroupIdsString != "") { $sql = "SELECT mb_group_name as metadatapointofcontactorgname, mb_group_title as metadatapointofcontactorgtitle, mb_group_id, mb_group_logo_path as metadatapointofcontactorglogo, mb_group_address as metadatapointofcontactorgaddress, mb_group_email as metadatapointofcontactorgemail, mb_group_postcode as metadatapointofcontactorgpostcode, mb_group_city as metadatapointofcontactorgcity, mb_group_voicetelephone as metadatapointofcontactorgtelephone, mb_group_facsimiletelephone as metadatapointofcontactorgfax, mb_group_id, mb_group_admin_code FROM mb_group WHERE mb_group_id IN (".$listGroupIdsString.")"; $resultOrgaGroup = db_query($sql); $index = 0; while ($row = db_fetch_array($resultOrgaGroup)) { //push information into metadataContactArray $metadataContactGroupArray[$index]['metadatapointofcontactorgname'] = $row['metadatapointofcontactorgname']; $metadataContactGroupArray[$index]['metadatapointofcontactorgemail'] = $row['metadatapointofcontactorgemail']; $metadataContactGroupArray[$index]['mb_group_id'] = $row['mb_group_id']; $metadataContactGroupArray[$index]['orga_id'] = $row['mb_group_id']; $metadataContactGroupArray[$index]['admin_code'] = $row['mb_group_admin_code']; $index++; } $index = 0; //push information directly into $groupOwnerArray at indizes from for ($i=0; $i < count($listGroupIdsKeys); $i++){ //find index of user with special id in array $metadataContactGroupArray['user_id'] $index = findIndexInMultiDimArray($metadataContactGroupArray, $listGroupIds[$listGroupIdsKeys[$i]], 'mb_group_id'); $groupOwnerArray[2][$listGroupIdsKeys[$i]] = $metadataContactGroupArray[$index]['mb_group_id']; //user_id - 2 $groupOwnerArray[3][$listGroupIdsKeys[$i]] = $metadataContactGroupArray[$index]['metadatapointofcontactorgname']; //orga_name - 3 $groupOwnerArray[4][$listGroupIdsKeys[$i]] = $metadataContactGroupArray[$index]['orga_id']; $groupOwnerArray[5][$listGroupIdsKeys[$i]] = $metadataContactGroupArray[$index]['metadatapointofcontactorgemail']; $groupOwnerArray[6][$listGroupIdsKeys[$i]] = $metadataContactGroupArray[$index]['admin_code']; } } return $groupOwnerArray; } function replaceCategories($idString, $inspireCategories){ $idString = str_replace('}{',',',$idString); $idString = str_replace('{','',str_replace('}','',$idString)); $idArray = explode(',',$idString); $catStringNew = ""; for ($i=0; $i < count($idArray); $i++){ if (isset($inspireCategories['title'][$idArray[$i]]) && $inspireCategories['title'][$idArray[$i]] != '') { $catStringNew .= $inspireCategories['title'][$idArray[$i]]." (".$inspireCategories['key'][$idArray[$i]]."),"; } } $catStringNew = rtrim($catStringNew,','); return $catStringNew; } function replaceCategoriesList($idString){ $idString = str_replace('}{',',',$idString); $idString = str_replace('{','',str_replace('}','',$idString)); return $idString; } function findIndexInMultiDimArray($multiDimArray, $needle, $columnName) { foreach($multiDimArray as $index => $object) { if($object[$columnName] == $needle) return $index; } return FALSE; } //for debugging purposes only function logit($text){ if($h = fopen("/tmp/pullInspireMonitoring.log","a")){ $content = $text .chr(13).chr(10); if(!fwrite($h,$content)){ #exit; } fclose($h); } } ?>