mirror of
https://github.com/FH-Complete/FHC-Core.git
synced 2026-06-01 12:19:28 +00:00
Andreas Österreicher
253 lines
8.8 KiB
PHP
253 lines
8.8 KiB
PHP
<?php
|
|
/* Copyright (C) 2011 Technikum-Wien
|
|
*
|
|
* This program is free software; you can redistribute it and/or modify
|
|
* it under the terms of the GNU General Public License as
|
|
* published by the Free Software Foundation; either version 2 of the
|
|
* License, or (at your option) any later version.
|
|
*
|
|
* This program is distributed in the hope that it will be useful,
|
|
* but WITHOUT ANY WARRANTY; without even the implied warranty of
|
|
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
|
* GNU General Public License for more details.
|
|
*
|
|
* You should have received a copy of the GNU General Public License
|
|
* along with this program; if not, write to the Free Software
|
|
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307, USA.
|
|
*
|
|
* Authors: Karl Burkhart <burkhart@technikum-wien.at>.
|
|
*/
|
|
|
|
$projekt_kurzbz=(isset($_GET['projekt_kurzbz'])?$_GET['projekt_kurzbz']:null);
|
|
$projekt_phase=(isset($_GET['projekt_phase'])?$_GET['projekt_phase']:null);
|
|
|
|
if($projekt_phase != null && (is_numeric($projekt_phase) == false ))
|
|
die('Ungültige ProjektphasenID');
|
|
|
|
|
|
|
|
// header for no cache
|
|
header("Cache-Control: no-cache");
|
|
header("Cache-Control: post-check=0, pre-check=0",false);
|
|
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
|
|
header("Pragma: no-cache");
|
|
// content type setzen
|
|
header("Content-type: application/xhtml+xml");
|
|
|
|
require_once('../config/vilesci.config.inc.php');
|
|
require_once('../include/functions.inc.php');
|
|
require_once('../include/ressource.class.php');
|
|
require_once('../include/basis_db.class.php');
|
|
|
|
$mitarbeiter = '';
|
|
$student='';
|
|
$betriebsmittel='';
|
|
$firma='';
|
|
$rdf_url='http://www.technikum-wien.at/ressource/';
|
|
|
|
echo '
|
|
<RDF:RDF
|
|
xmlns:RDF="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
|
|
xmlns:RESSOURCE="'.$rdf_url.'rdf#"
|
|
>
|
|
';
|
|
|
|
$optional = '';
|
|
$optional_description = '';
|
|
if(isset($_GET['optional']))
|
|
{
|
|
$optional.="\n\t\t\t<RDF:li resource=\"".$rdf_url."opt"."\" />";
|
|
|
|
$optional_description = '
|
|
<RDF:Description about="'.$rdf_url.'opt" >
|
|
<RESSOURCE:ressource_id></RESSOURCE:ressource_id>
|
|
<RESSOURCE:bezeichnung></RESSOURCE:bezeichnung>
|
|
<RESSOURCE:typ><![CDATA[Auswahl]]></RESSOURCE:typ>
|
|
<RESSOURCE:beschreibung></RESSOURCE:beschreibung>
|
|
<RESSOURCE:mitarbeiter_uid></RESSOURCE:mitarbeiter_uid>
|
|
<RESSOURCE:student_uid></RESSOURCE:student_uid>
|
|
<RESSOURCE:betriebsmittel_id></RESSOURCE:betriebsmittel_id>
|
|
<RESSOURCE:firma_id></RESSOURCE:firma_id>
|
|
<RESSOURCE:insertamum></RESSOURCE:insertamum>
|
|
<RESSOURCE:insertvon></RESSOURCE:insertvon>
|
|
<RESSOURCE:updateamum></RESSOURCE:updateamum>
|
|
<RESSOURCE:updatevon></RESSOURCE:updatevon>
|
|
<RESSOURCE:rdf_description></RESSOURCE:rdf_description>
|
|
</RDF:Description>';
|
|
}
|
|
|
|
$ressource = new ressource();
|
|
|
|
if($projekt_kurzbz!=null)
|
|
$ressource->getProjectRessourcen($projekt_kurzbz);
|
|
else if($projekt_phase!= null)
|
|
$ressource->getPhaseRessourcen($projekt_phase);
|
|
|
|
else
|
|
$ressource->getAllRessourcen();
|
|
|
|
foreach ($ressource->result as $res)
|
|
{
|
|
draw_ressource($res);
|
|
}
|
|
|
|
$seq= "
|
|
<RDF:Seq about=\"".$rdf_url."liste\" >
|
|
<RDF:li>
|
|
<RDF:Seq about=\"".$rdf_url."mitarbeiter\" >$mitarbeiter
|
|
</RDF:Seq>
|
|
<RDF:Seq about=\"".$rdf_url."studenten\" >$student
|
|
</RDF:Seq>
|
|
<RDF:Seq about=\"".$rdf_url."betriebsmittel\" >$betriebsmittel
|
|
</RDF:Seq>
|
|
<RDF:Seq about=\"".$rdf_url."firma\" >$firma
|
|
</RDF:Seq>
|
|
</RDF:li>
|
|
\n\t\t</RDF:Seq>
|
|
<RDF:Seq about=\"".$rdf_url."alle\" >
|
|
$optional
|
|
$mitarbeiter
|
|
$student
|
|
$betriebsmittel
|
|
$firma
|
|
\n\t\t</RDF:Seq>
|
|
";
|
|
|
|
$seq.="\n\t</RDF:RDF>";
|
|
|
|
|
|
draw_caption('mitarbeiter');
|
|
draw_caption('studenten');
|
|
draw_caption('betriebsmittel');
|
|
draw_caption('firma');
|
|
echo $optional_description;
|
|
echo $seq;
|
|
|
|
function draw_caption($name)
|
|
{
|
|
global $rdf_url;
|
|
|
|
echo '
|
|
<RDF:Description about="'.$rdf_url.$name.'" >
|
|
<RESSOURCE:ressource_id></RESSOURCE:ressource_id>
|
|
<RESSOURCE:bezeichnung><![CDATA['.ucfirst($name).']]></RESSOURCE:bezeichnung>
|
|
<RESSOURCE:typ><![CDATA['.ucfirst($name).']]></RESSOURCE:typ>
|
|
<RESSOURCE:beschreibung></RESSOURCE:beschreibung>
|
|
<RESSOURCE:mitarbeiter_uid></RESSOURCE:mitarbeiter_uid>
|
|
<RESSOURCE:student_uid></RESSOURCE:student_uid>
|
|
<RESSOURCE:betriebsmittel_id></RESSOURCE:betriebsmittel_id>
|
|
<RESSOURCE:firma_id></RESSOURCE:firma_id>
|
|
<RESSOURCE:insertamum></RESSOURCE:insertamum>
|
|
<RESSOURCE:insertvon></RESSOURCE:insertvon>
|
|
<RESSOURCE:updateamum></RESSOURCE:updateamum>
|
|
<RESSOURCE:updatevon></RESSOURCE:updatevon>
|
|
<RESSOURCE:rdf_description></RESSOURCE:rdf_description>
|
|
</RDF:Description>
|
|
';
|
|
}
|
|
|
|
|
|
// funktion zum ausgeben der einzelnen ressourcen -> es wird unterschienden ob mitarbeiter/student/betriebsmittel/firma
|
|
function draw_ressource($ressource)
|
|
{
|
|
global $rdf_url;
|
|
global $mitarbeiter, $student, $betriebsmittel, $firma;
|
|
|
|
$db = new basis_db();
|
|
$RdfDescription ='';
|
|
$typ = '';
|
|
|
|
// Ressource ist ein Mitarbeiter
|
|
if($ressource->mitarbeiter_uid != '')
|
|
{
|
|
$qry = "SELECT vorname, nachname from campus.vw_mitarbeiter where uid='".addslashes($ressource->mitarbeiter_uid)."'";
|
|
if($db->db_query($qry))
|
|
{
|
|
if($row = $db->db_fetch_object())
|
|
$RdfDescription = $row->vorname.' '.$row->nachname;
|
|
else
|
|
die('Fehler beim Laden der Mitarbeiter-daten');
|
|
}
|
|
else
|
|
die('Fehler beim Laden der Mitarbeiter-daten');
|
|
|
|
$mitarbeiter.="\n\t\t\t<RDF:li resource=\"".$rdf_url.$ressource->ressource_id.'/'.$ressource->projekt_ressource_id."\" />";
|
|
$typ ='Mitarbeiter';
|
|
}
|
|
// Ressource ist ein Student
|
|
if($ressource->student_uid != '')
|
|
{
|
|
$qry = "SELECT vorname, nachname from campus.vw_student where uid='".addslashes($ressource->student_uid)."'";
|
|
if($db->db_query($qry))
|
|
{
|
|
if($row = $db->db_fetch_object())
|
|
$RdfDescription = $row->vorname.' '.$row->nachname;
|
|
else
|
|
die('Fehler beim Laden der Studenten-daten');
|
|
}
|
|
else
|
|
die('Fehler beim Laden der Studenten-daten');
|
|
|
|
$student.="\n\t\t\t<RDF:li resource=\"".$rdf_url.$ressource->ressource_id.'/'.$ressource->projekt_ressource_id."\" />";
|
|
$typ ='Student';
|
|
}
|
|
|
|
// Ressource ist ein Betriebsmittel
|
|
if($ressource->betriebsmittel_id != '')
|
|
{
|
|
$qry = "SELECT betriebsmitteltyp, beschreibung from wawi.tbl_betriebsmittel where betriebsmittel_id='".addslashes($ressource->betriebsmittel_id)."'";
|
|
if($db->db_query($qry))
|
|
{
|
|
if($row = $db->db_fetch_object())
|
|
$RdfDescription = $row->betriebsmitteltyp.', '.$row->beschreibung;
|
|
else
|
|
die('Fehler beim Laden der Betriebsmittel-daten');
|
|
}
|
|
else
|
|
die('Fehler beim Laden der Betriebsmittel-daten');
|
|
|
|
$betriebsmittel.="\n\t\t\t<RDF:li resource=\"".$rdf_url.$ressource->ressource_id.'/'.$ressource->projekt_ressource_id."\" />";
|
|
$typ = 'Betriebsmittel';
|
|
}
|
|
|
|
// Ressource ist eine Firma
|
|
if($ressource->firma_id != '')
|
|
{
|
|
$qry = "SELECT name from public.tbl_firma where firma_id='".addslashes($ressource->firma_id)."'";
|
|
if($db->db_query($qry))
|
|
{
|
|
if($row = $db->db_fetch_object())
|
|
$RdfDescription = $row->name;
|
|
else
|
|
die('Fehler beim Laden der Firmen-daten');
|
|
}
|
|
else
|
|
die('Fehler beim Laden der Firmen-daten');
|
|
|
|
$firma.="\n\t\t\t<RDF:li resource=\"".$rdf_url.$ressource->ressource_id.'/'.$ressource->projekt_ressource_id."\" />";
|
|
$typ = 'Firma';
|
|
}
|
|
|
|
echo '
|
|
<RDF:Description about="'.$rdf_url.$ressource->ressource_id.'/'.$ressource->projekt_ressource_id.'" >
|
|
<RESSOURCE:ressource_id><![CDATA['.$ressource->ressource_id.']]></RESSOURCE:ressource_id>
|
|
<RESSOURCE:bezeichnung><![CDATA['.$ressource->bezeichnung.']]></RESSOURCE:bezeichnung>
|
|
<RESSOURCE:typ><![CDATA['.$typ.']]></RESSOURCE:typ>
|
|
<RESSOURCE:beschreibung><![CDATA['.$ressource->beschreibung.']]></RESSOURCE:beschreibung>
|
|
<RESSOURCE:mitarbeiter_uid><![CDATA['.$ressource->mitarbeiter_uid.']]></RESSOURCE:mitarbeiter_uid>
|
|
<RESSOURCE:student_uid><![CDATA['.$ressource->student_uid.']]></RESSOURCE:student_uid>
|
|
<RESSOURCE:betriebsmittel_id><![CDATA['.$ressource->betriebsmittel_id.']]></RESSOURCE:betriebsmittel_id>
|
|
<RESSOURCE:firma_id><![CDATA['.$ressource->firma_id.']]></RESSOURCE:firma_id>
|
|
<RESSOURCE:insertamum><![CDATA['.$ressource->insertamum.']]></RESSOURCE:insertamum>
|
|
<RESSOURCE:insertvon><![CDATA['.$ressource->insertvon.']]></RESSOURCE:insertvon>
|
|
<RESSOURCE:updateamum><![CDATA['.$ressource->updateamum.']]></RESSOURCE:updateamum>
|
|
<RESSOURCE:updatevon><![CDATA['.$ressource->updatevon.']]></RESSOURCE:updatevon>
|
|
<RESSOURCE:aufwand><![CDATA['.$ressource->aufwand.']]></RESSOURCE:aufwand>
|
|
<RESSOURCE:funktion_kurzbz><![CDATA['.$ressource->funktion_kurzbz.']]></RESSOURCE:funktion_kurzbz>
|
|
<RESSOURCE:projekt_ressource_id><![CDATA['.$ressource->projekt_ressource_id.']]></RESSOURCE:projekt_ressource_id>
|
|
<RESSOURCE:rdf_description><![CDATA['.$RdfDescription.']]></RESSOURCE:rdf_description>
|
|
</RDF:Description>
|
|
';
|
|
}
|
|
?>
|