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 .= "" . $row['fkey_gui_id'] . " |
";
}
$html .= "
";
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 = '
';
$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**********
}
?>