Bitte einen Benutzer auswählen'; } else { $result = db_prep_query( "SELECT fkey_gui_id FROM gui_mb_user WHERE fkey_mb_user_id = $1", $id, array('i')); } $html .= ""; while($row = db_fetch_assoc($result)) { $html .= ""; } $html .= "
" . $row['fkey_gui_id'] . "
"; die($html); } if($_REQUEST['action'] == "getForm"){ //$e = new mb_exception($_REQUEST['serviceType']); switch ($_REQUEST['serviceType']) { case "wms": $sql = "SELECT DISTINCT u.mb_user_id, w.wms_id,w.wms_title,u.mb_user_name" ." FROM mb_proxy_log AS m INNER JOIN wms AS w ON" ." (m.fkey_wms_id = w.wms_id AND w.wms_owner=$1)" ." INNER JOIN mb_user u ON(m.fkey_mb_user_id = u.mb_user_id)" ." ORDER BY u.mb_user_name ASC, u.mb_user_id "; break; case "wfs": $sql = "SELECT DISTINCT u.mb_user_id, w.wfs_id,w.wfs_title,u.mb_user_name" ." FROM mb_proxy_log AS m INNER JOIN wfs AS w ON" ." (m.fkey_wfs_id = w.wfs_id AND w.wfs_owner=$1)" ." INNER JOIN mb_user u ON(m.fkey_mb_user_id = u.mb_user_id)" ." ORDER BY u.mb_user_name ASC, u.mb_user_id "; break; } $mb_user_id = $_SESSION['mb_user_id']; $v = array($mb_user_id); $t = array('i'); $users = array(); $services = array(); /*$sql = "SELECT DISTINCT u.mb_user_id, w.wms_id,w.wms_title,u.mb_user_name" ." FROM mb_proxy_log AS m INNER JOIN wms AS w ON" ." (m.fkey_wms_id = w.wms_id AND w.wms_owner=$1)" ." INNER JOIN mb_user u ON(m.fkey_mb_user_id = u.mb_user_id)" ." ORDER BY u.mb_user_name ASC, u.mb_user_id ";*/ $result = db_prep_query($sql,$v,$t); while($row = db_fetch_assoc($result)){ $users[$row['mb_user_id']] = $row['mb_user_name']; switch ($_REQUEST['serviceType']) { case "wms": $services[$row['wms_id']] = $row['wms_title']; break; case "wfs": $services[$row['wfs_id']] = $row['wfs_title']; break; } } $form = '
OwsProxy Logs Abfrage
User / GUI

OwsProxy Logs Abfrageergebnis
'; $jsonOutput = array("form"=>$form,"error"=>"","message"=>""); if(count($users) == 0 || count($services) == 0){ $jsonOutput["message"] = "In der OwsProxy-Tabelle ist kein Datensatz vorhanden. Keine Abfrage ist möglich."; } header("ContentType: application/json"); die(json_encode($jsonOutput)); } else { require_once dirname(__FILE__) . "/../classes/class_owsproxy_log.php"; $function = isset($_REQUEST['function']) ? $_REQUEST['function'] : null;#getServiceLogs,deleteServiceLogs,listServiceLogs $listType = isset($_REQUEST['listType']) ? $_REQUEST['listType'] : null;#service,user $serviceType = isset($_REQUEST['serviceType']) ? $_REQUEST['serviceType'] : null;#wms, wfs $userId = isset($_REQUEST['userId']) ? $_REQUEST['userId'] : null;#XXX $serviceId = isset($_REQUEST['serviceId']) ? $_REQUEST['serviceId'] : null;# XXX $timeFrom = isset($_REQUEST['timeFrom']) ? $_REQUEST['timeFrom'] : null;# $timeTo = isset($_REQUEST['timeTo']) ? $_REQUEST['timeTo'] : null;# $withContactData = isset($_REQUEST['withContactData']) ? $_REQUEST['withContactData'] : null;# 1, if ($serviceType === null) { $e = new mb_exception("Parameter serviceType is missing!"); die ("Der Parameter 'serviceType' wurde nicht uebergeben."); } //begin serviceType handling********** $mb_user_id = $_SESSION['mb_user_id']; $export = "export dummy"; switch ($serviceType) { case "wms": $serviceLog = OwsLogCsv::create($mb_user_id, $function, $userId, $serviceId, $listType, $timeFrom, $timeTo, $withContactData, $serviceType); $serviceLog->handle(); switch ($_REQUEST['action']) { case "getCsv": header("Content-Type: text/csv; charset=".CHARSET); header("Content-Disposition: attachment; filename=csv_export.csv"); header("Pragma: no-cache"); header("Expires: 0"); $export = $serviceLog->getAsCsv(); break; case "getJson": $export = json_encode($serviceLog->getAsArray($function)); break; } break; case "wfs": $serviceLog = OwsLogCsv::create($mb_user_id, $function, $userId, $serviceId, $listType, $timeFrom, $timeTo, $withContactData, $serviceType); $serviceLog->handle(); switch ($_REQUEST['action']) { case "getCsv": header("Content-Type: text/csv; charset=".CHARSET); header("Content-Disposition: attachment; filename=csv_export.csv"); header("Pragma: no-cache"); header("Expires: 0"); $export = $serviceLog->getAsCsv(); break; case "getJson": $export = json_encode($serviceLog->getAsArray($function)); break; } break; default: die ("Der 'serviceType' ".$serviceType." ist nicht unterstuetzt."); break; } print $export; die(); //end serviceType handling********** //$e = new mb_exception("servicetype not supported"); /* if($serviceType == "wms"){ $mb_user_id = $_SESSION['mb_user_id']; if($_REQUEST['action'] == "getCsv"){ $wmslog = OwsLogCsv::create($mb_user_id, $function, $userId, $serviceId, $listType, $timeFrom, $timeTo, $withContactData, $serviceType); $wmslog->handle(); header("Content-Type: text/csv; charset=".CHARSET); header("Content-Disposition: attachment; filename=csv_export.csv"); header("Pragma: no-cache"); header("Expires: 0"); $csv = $wmslog->getAsCsv(); print $csv; die(); } else if($_REQUEST['action'] == "getJson"){ $wmslog = OwsLogCsv::create($mb_user_id, $function, $userId, $serviceId, $listType, $timeFrom, $timeTo, $withContactData, $serviceType); $wmslog->handle(); print json_encode($wmslog->getAsArray($function)); die(); } } else { $e = new mb_exception("servicetype not supported"); die ("Der 'serviceType'".$serviceType." ist nicht unterstuetzt."); }*/ //end serviceType handling********** } ?>