aschwarz/stellenantrag_neu
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
stellenantrag_neu/stud/ag_ubersicht_alt.php
aschwarz 804fd46590 Rechte für Gruppe geändert
2022-11-28 09:17:05 +01:00

628 lines
31 KiB
PHP
Executable File
Raw Permalink Blame History

<?php
include_once("kurs/datenbankanbindung.php"); // f&uuml;gt die Datenbankanbindung ein: Sys:\php\includes\kurs\datenbankanbindung.php
#require("func_check_vertiefungsbereich.php"); // Prüft, ob doppelte Vertiefungsbereiche abgegeben werden.
require_once("func_pflichtfelder.php"); // Prüft, ob Pflichtfelder ausgefüllt wurden
require_once("func_vertiefungsbereich.php"); // Prüft, ob vertiefungsbereich gewählt wurde, wenn Stellen erfasst sind.
$db = dbconnect();
$ansp = $db->query("SELECT wert1, wert2 FROM parameter WHERE pid='2'");
$uhd = $ansp->fetch_array();
$ansprechpart = "$uhd[wert1]"; // Ansprechpartner bei Probleme
$helpmail = "$uhd[wert2]"; // Kontaktmailadresse bei Problemen
if ($_COOKIE["uid1"] == ""){ include("kurs/anmeldefehler_subdir.php"); exit;} //Wenn man nicht angemeldet ist soll man nichts ausw&auml;hlen k&ouml;nnen
$uid1=$_COOKIE["uid1"];
include("kurs/sta/stan_useronline_write.php"); // F&uuml;r Statistik, wieviele User online sind
// &Uuml;Berpr&uuml;fung, ob die Anmeldefrist &uuml;berschritten ist
$heute = mktime(date("H"), date("i"), date("s"), date("m"), date("d"), date("Y")); // heutiges Datum
$heute_format = date("YmdHis", $heute); // ISO-8601 Format wie in der Datenbank: Formatierung f&uuml;r Vergleiche erforderlich
$res = $db->query("SELECT Jahrgang FROM stud WHERE uid='$uid1'");
$stud_jahr = $res->fetch_array();
$anm_schluss = $db->query("SELECT DATE_Format(anmeldebeginn, '%Y%m%d%H%i%s')AS beginndatum, DATE_Format(anmeldebeginn, '%d.%m.%Y um %H:%i:%s Uhr')AS beginnform, DATE_Format(anmeldeschluss, '%Y%m%d%H%i%s')AS enddatum, DATE_Format(einsicht_ag_ubersicht, '%Y%m%d%H%i%s')AS einsichtdatum, DATE_Format(einsicht_ag_ubersicht, '%d.%m.%Y um %H:%i:%s Uhr')AS einsichtform
FROM stan_frist
WHERE jahrgang=\"$stud_jahr[Jahrgang]\"");
$row_schluss = $anm_schluss->fetch_array(); // Herausfinden des Beginn- Schlussdatums
$a = strtotime ($heute_format); //Umrechnung des Fristgrenztages in eine Zahl
$b = strtotime ($row_schluss[enddatum]); // Umrechnung des Enddatums in eine Zahl
$c = strtotime ($row_schluss[beginndatum]); // Umrechnung des Beginndatums in eine Zahl
$d = strtotime ($row_schluss[einsichtdatum]); // Umrechnung des Beginndatums in eine Zahl
if ($a < $c){
echo "
<html>
<head>
<meta http-equiv=\"content-type\" content=\"text/html; charset=utf-8\">
<link rel=\"stylesheet\" href=\"../styles_pc.css\" type=\"text/css\">
<title>Anmeldungen noch nicht m&ouml;glich!</title>
</head>
<body>
<table border=\"0\" style=\"border-collapse: collapse\" width=\"100%\" cellpadding=\"0\" height=\"100%\" id=\"table1\">
<tr>
<td>
<div align=\"center\">
<table cellspacing=\"0\" cellpadding=\"0\" width=\"550\" border=\"0\">
<tr>
<td width=\"10\" background=\"../images/box_e1.gif\">
<img height=\"40\" src=\"../images/blank.gif\" width=\"22\"></td>
<td nowrap=\"nowrap\" align=\"left\" width=\"3%\" background=\"../images/box_top.gif\" valign=\"top\"></td>
<td width=\"95%\" background=\"../images/box_top.gif\">
<img height=\"10\" src=\"../images/blank.gif\" width=\"1\"><br>
<span class=\"sh\">Anmeldungen noch nicht m&ouml;glich!</span><br>
<img height=\"5\" src=\"../images/blank.gif\" width=\"1\"></td>
<td nowrap=\"nowrap\" align=\"right\" width=\"1%\" background=\"../images/box_e2.gif\">
<img height=\"40\" src=\"../images/blank.gif\" width=\"22\"></td>
</tr>
<tr>
<td width=\"1%\" background=\"../images/box_l.gif\">
<img height=\"1\" src=\"../images/blank.gif\" width=\"22\"></td>
<td colspan=\"2\"><br>
<p align=\"center\"><b>Antr&auml;ge können erst ab $row_schluss[beginnform] bearbeitet werden!</b>
</p>
<p align=\"center\"><a href=\"hauptframe.php\">
<img border=\"0\" src=\"../images/zurueck.gif\" width=\"77\" height=\"22\"></a><br>
</p>
<p></p>
<p></p>
<p></p>
<p></p>
<p><br>
</p>
</td>
<td width=\"1%\" background=\"../images/box_r.gif\">
<img height=\"1\" src=\"../images/blank.gif\" width=\"22\"></td>
</tr>
<tr>
<td nowrap=\"nowrap\" align=\"left\" width=\"1%\" background=\"../images/box_e3.gif\">
<img height=\"16\" src=\"../images/blank.gif\" width=\"22\"></td>
<td nowrap=\"nowrap\" align=\"left\" width=\"98%\" background=\"../images/box_bottom.gif\" colspan=\"2\">
<img height=\"16\" src=\"../images/blank.gif\" width=\"8\"></td>
<td nowrap=\"nowrap\" align=\"right\" width=\"1%\" background=\"../images/box_e4.gif\">
<img height=\"16\" src=\"../images/blank.gif\" width=\"22\"> </td>
</tr>
</table>
</div>
</td>
</tr>
</table>
</body>
</html>";
exit;
} // Ende &Uuml;berpr&uuml;fung der Zeit&uuml;berschreitung
/*
if ($a >= $b){
echo "
<html>
<head>
<meta http-equiv=\"content-type\" content=\"text/html; charset=utf-8\">
<link rel=\"stylesheet\" href=\"../styles_pc.css\" type=\"text/css\">
<title>Anmeldezeit vertstrichen</title>
</head>
<body>
<table border=\"0\" style=\"border-collapse: collapse\" width=\"100%\" cellpadding=\"0\" height=\"100%\" id=\"table1\">
<tr>
<td>
<div align=\"center\">
<table cellspacing=\"0\" cellpadding=\"0\" width=\"550\" border=\"0\">
<tr>
<td width=\"10\" background=\"../images/box_e1.gif\">
<img height=\"40\" src=\"../images/blank.gif\" width=\"22\"></td>
<td nowrap=\"nowrap\" align=\"left\" width=\"3%\" background=\"../images/box_top.gif\" valign=\"top\"></td>
<td width=\"95%\" background=\"../images/box_top.gif\">
<img height=\"10\" src=\"../images/blank.gif\" width=\"1\"><br>
<span class=\"sh\">Anmeldezeit vertstrichen</span><br>
<img height=\"5\" src=\"../images/blank.gif\" width=\"1\"></td>
<td nowrap=\"nowrap\" align=\"right\" width=\"1%\" background=\"../images/box_e2.gif\">
<img height=\"40\" src=\"../images/blank.gif\" width=\"22\"></td>
</tr>
<tr>
<td width=\"1%\" background=\"../images/box_l.gif\">
<img height=\"1\" src=\"../images/blank.gif\" width=\"22\"></td>
<td colspan=\"2\"><br>
<p align=\"center\">Antr&auml;ge können nicht mehr bearbeitet werden!<br>Es sind nur noch <a href=\"antrag_aend.php\">Änderungsanträge</a> möglich
</p>
<p align=\"center\"><a href=\"hauptframe.php\">
<img border=\"0\" src=\"../images/zurueck.gif\" width=\"77\" height=\"22\"></a><br>
</p>
<p></p>
<p></p>
<p></p>
<p></p>
<p><br>
</p>
</td>
<td width=\"1%\" background=\"../images/box_r.gif\">
<img height=\"1\" src=\"../images/blank.gif\" width=\"22\"></td>
</tr>
<tr>
<td nowrap=\"nowrap\" align=\"left\" width=\"1%\" background=\"../images/box_e3.gif\">
<img height=\"16\" src=\"../images/blank.gif\" width=\"22\"></td>
<td nowrap=\"nowrap\" align=\"left\" width=\"98%\" background=\"../images/box_bottom.gif\" colspan=\"2\">
<img height=\"16\" src=\"../images/blank.gif\" width=\"8\"></td>
<td nowrap=\"nowrap\" align=\"right\" width=\"1%\" background=\"../images/box_e4.gif\">
<img height=\"16\" src=\"../images/blank.gif\" width=\"22\"> </td>
</tr>
</table>
</div>
</td>
</tr>
</table>
</body>
</html>";
exit;
} // Ende &Uuml;berpr&uuml;fung der Zeit&uuml;berschreitung
*/
if ($a < $d){
echo "
<html>
<head>
<meta http-equiv=\"content-type\" content=\"text/html; charset=utf-8\">
<link rel=\"stylesheet\" href=\"../styles_pc.css\" type=\"text/css\">
<title>Anmeldungen noch nicht m&ouml;glich!</title>
</head>
<body>
<table border=\"0\" style=\"border-collapse: collapse\" width=\"100%\" cellpadding=\"0\" height=\"100%\" id=\"table1\">
<tr>
<td>
<div align=\"center\">
<table cellspacing=\"0\" cellpadding=\"0\" width=\"550\" border=\"0\">
<tr>
<td width=\"10\" background=\"../images/box_e1.gif\">
<img height=\"40\" src=\"../images/blank.gif\" width=\"22\"></td>
<td nowrap=\"nowrap\" align=\"left\" width=\"3%\" background=\"../images/box_top.gif\" valign=\"top\"></td>
<td width=\"95%\" background=\"../images/box_top.gif\">
<img height=\"10\" src=\"../images/blank.gif\" width=\"1\"><br>
<span class=\"sh\">Anmeldungen noch nicht m&ouml;glich!</span><br>
<img height=\"5\" src=\"../images/blank.gif\" width=\"1\"></td>
<td nowrap=\"nowrap\" align=\"right\" width=\"1%\" background=\"../images/box_e2.gif\">
<img height=\"40\" src=\"../images/blank.gif\" width=\"22\"></td>
</tr>
<tr>
<td width=\"1%\" background=\"../images/box_l.gif\">
<img height=\"1\" src=\"../images/blank.gif\" width=\"22\"></td>
<td colspan=\"2\"><br>
<p align=\"center\"><b>Ihre Standortszuweisungen können erst ab $row_schluss[einsichtform] eingesehen werden!</b>
</p>
<p align=\"center\"><a href=\"hauptframe.php\">
<img border=\"0\" src=\"../images/zurueck.gif\" width=\"77\" height=\"22\"></a><br>
</p>
<p></p>
<p></p>
<p></p>
<p></p>
<p><br>
</p>
</td>
<td width=\"1%\" background=\"../images/box_r.gif\">
<img height=\"1\" src=\"../images/blank.gif\" width=\"22\"></td>
</tr>
<tr>
<td nowrap=\"nowrap\" align=\"left\" width=\"1%\" background=\"../images/box_e3.gif\">
<img height=\"16\" src=\"../images/blank.gif\" width=\"22\"></td>
<td nowrap=\"nowrap\" align=\"left\" width=\"98%\" background=\"../images/box_bottom.gif\" colspan=\"2\">
<img height=\"16\" src=\"../images/blank.gif\" width=\"8\"></td>
<td nowrap=\"nowrap\" align=\"right\" width=\"1%\" background=\"../images/box_e4.gif\">
<img height=\"16\" src=\"../images/blank.gif\" width=\"22\"> </td>
</tr>
</table>
</div>
</td>
</tr>
</table>
</body>
</html>";
exit;
} // Ende &Uuml;berpr&uuml;fung der Zeit&uuml;berschreitung
# Wenn Erstanträge abgesendet wurden, dürfen keine Stellen mehr vorgemerkt werden
$res2 = $db->query("SELECT distinct status
FROM stan_antrag
WHERE uid='$uid1'
LIMIT 1");
$stud_status = $res2->fetch_array();
/* ausgeklammert, weil teilweise Studenten keine Erstanträge abgegeben haben: 15.07.2009
if($stud_status[status] != '0'){
echo "
<html>
<head>
<meta http-equiv=\"content-type\" content=\"text/html; charset=utf-8\">
<link rel=\"stylesheet\" href=\"../styles_pc.css\" type=\"text/css\">
<title>Anmeldungen noch nicht m&ouml;glich!</title>
</head>
<body>
<table border=\"0\" style=\"border-collapse: collapse\" width=\"100%\" cellpadding=\"0\" height=\"100%\" id=\"table1\">
<tr>
<td>
<div align=\"center\">
<table cellspacing=\"0\" cellpadding=\"0\" width=\"550\" border=\"0\">
<tr>
<td width=\"10\" background=\"../images/box_e1.gif\">
<img height=\"40\" src=\"../images/blank.gif\" width=\"22\"></td>
<td nowrap=\"nowrap\" align=\"left\" width=\"3%\" background=\"../images/box_top.gif\" valign=\"top\"></td>
<td width=\"95%\" background=\"../images/box_top.gif\">
<img height=\"10\" src=\"../images/blank.gif\" width=\"1\"><br>
<span class=\"sh\">Anmeldungen nicht m&ouml;glich!</span><br>
<img height=\"5\" src=\"../images/blank.gif\" width=\"1\"></td>
<td nowrap=\"nowrap\" align=\"right\" width=\"1%\" background=\"../images/box_e2.gif\">
<img height=\"40\" src=\"../images/blank.gif\" width=\"22\"></td>
</tr>
<tr>
<td width=\"1%\" background=\"../images/box_l.gif\">
<img height=\"1\" src=\"../images/blank.gif\" width=\"22\"></td>
<td colspan=\"2\"><br>
<p align=\"center\"><b>Die Wahl der AG-Standorte ist erst nach dem Speichern<br>
der Erstanträge möglich</b>
</p>
<p align=\"center\"><a href=\"hauptframe.php\">
<img border=\"0\" src=\"../images/zurueck.gif\" width=\"77\" height=\"22\"></a><br>
</p>
<p></p>
<p></p>
<p></p>
<p></p>
<p><br>
</p>
</td>
<td width=\"1%\" background=\"../images/box_r.gif\">
<img height=\"1\" src=\"../images/blank.gif\" width=\"22\"></td>
</tr>
<tr>
<td nowrap=\"nowrap\" align=\"left\" width=\"1%\" background=\"../images/box_e3.gif\">
<img height=\"16\" src=\"../images/blank.gif\" width=\"22\"></td>
<td nowrap=\"nowrap\" align=\"left\" width=\"98%\" background=\"../images/box_bottom.gif\" colspan=\"2\">
<img height=\"16\" src=\"../images/blank.gif\" width=\"8\"></td>
<td nowrap=\"nowrap\" align=\"right\" width=\"1%\" background=\"../images/box_e4.gif\">
<img height=\"16\" src=\"../images/blank.gif\" width=\"22\"> </td>
</tr>
</table>
</div>
</td>
</tr>
</table>
</body>
</html>";
exit;
}
#################
*/
echo "
<html>
<head>
<meta http-equiv=\"content-type\" content=\"text/html; charset=utf-8\">
<link rel=\"stylesheet\" href=\"../styles_pc.css\" type=\"text/css\">
<script type=\"text/javascript\" src=\"./overlib/overlibmws.js\"><!-- overLIB (c) Erik Bosrup --></script>
<script type=\"text/javascript\">
<!--
OLregisterPlugins('crossframe','iframe','hide','shadow');
overlib=parent.overlib;
nd=parent.nd;
if (typeof window.createPopup!='undefined') {
var oPopup = window.createPopup();
var oPopupBody = oPopup.document.body;
oPopupBody.style.backgroundColor = \"#ccccff\";
oPopupBody.style.border = \"solid blue 1px\";
}
// -->
</script>
<style type=\"text/css\">
<!--
.text_overlib {font-family:Verdana,Arial,sans-serif; font-size:10px;}
.r{text-decoration: none;font-weight: bold; color: black;}
.text_overlib {font-family:Verdana,Arial,sans-serif; font-size:10px;}
-->
</style>
<title>Anträge bearbeiten</title>
</head>
<body>
<div id=\"overDiv\" style=\"position: absolute; visibility: hidden; z-index: 1000; left: 10px; top: 0px; background-image: none;\"></div>
<table border=\"0\" style=\"border-collapse: collapse\" width=\"100%\" cellpadding=\"0\" height=\"100%\" id=\"table1\">
<tr>
<td>
<div align=\"center\">
<table cellspacing=\"0\" cellpadding=\"0\" width=\"100%\" border=\"0\">
<tr>
<td width=\"10\" background=\"../images/box_e1.gif\">
<img height=\"40\" src=\"../images/blank.gif\" width=\"22\"></td>
<td nowrap=\"nowrap\" align=\"left\" width=\"98%\" background=\"../images/box_top.gif\" valign=\"top\">
<img height=\"10\" src=\"../images/blank.gif\" width=\"1\"><br>
<font class=\"hd\">AG-Standorte</font><br>
<img height=\"5\" src=\"../images/blank.gif\" width=\"1\"></td>
<td nowrap=\"nowrap\" align=\"right\" width=\"1%\" background=\"../images/box_e2.gif\">
<img height=\"40\" src=\"../images/blank.gif\" width=\"22\"></td>
</tr>
<tr>
<td width=\"1%\" background=\"../images/box_l.gif\">
<img height=\"1\" src=\"../images/blank.gif\" width=\"22\"></td>
<td>";
$db = dbconnect();
$query = "SELECT distinct vert_bereich
FROM stan_antrag t1
WHERE t1.status = (
SELECT MAX(t2.status)
FROM stan_antrag t2
WHERE t1.aendid = t2.aendid
AND t2.status !='2' #hinzugefügt am 10.06.2009, weil Status 2 angezeigt wurde
)
AND t1.uid = '$uid1'
AND (t1.zuweisung is NULL OR t1.zuweisung='Z')
ORDER BY vert_bereich
";
$result = $db->query ($query)
or die ("Cannot execute query");
while ($row = $result->fetch_array()){
echo"
<table width='100%' bgcolor=#6487DC>
<tr>
<td width='60%' style='border-style: none; border-width: medium' height='0'>
<font color='#FFFFFF'><b>Vertiefungsbereich:
";
$db = dbconnect();
$query1 = $db->query ("SELECT vbid, bezeichnung
FROM stan_vertiefungsbereich
WHERE vbid = '$row[vert_bereich]'");
$row1 = $query1->fetch_array();
echo"
$row1[bezeichnung]
</b></font>
</td>
</tr>
</table>
";
$query2 = "SELECT t1.saaid
, t1.dst_id
, date_format(beginn, '%Y-%m-%d') beginn_form
FROM stan_antrag t1
WHERE t1.status = (
SELECT MAX(t2.status)
FROM stan_antrag t2
WHERE t1.aendid = t2.aendid
AND t2.status !='2' #hinzugefügt am 10.06.2009, weil Status 2 angezeigt wurde
)
AND t1.uid = '$uid1'
AND vert_bereich = '$row[vert_bereich]'
AND (t1.zuweisung is NULL OR t1.zuweisung='Z')
ORDER BY beginn_form";
$result2 = $db->query ($query2)
or die ("Cannot execute query1");
#Überschirften
echo"<table width=100%>
<tr>
<td width=30%>
<b>Ausbildungsstelle</b>
</td>
<td width=70%>
<table width=100%>
<tr>
<td width=20%>
<b>Datum</b>
</td>
<td width=20%>
<b>Zeit</b>
</td>
<td width=20%>
<b>AG-Standort</b>
</td>
<td width=20%>
<b>Adresse/Raum</b>
</td>
<td width=20%>
<b>Status</b>
</td>
</tr>
</table>
</td>
</tr>
</table>
";
while ($row2 = $result2->fetch_array()){
$res4 = $db->query("SELECT bez, ort FROM stan_dienststellen WHERE dst_id='$row2[dst_id]'");
$row4 = $res4->fetch_array();
if($row4[bez] != ''){
$dst_bez = $row4[bez]." ".$row4[name];
$ort = $row4[ort];
}else{
$res5 = $db->query("SELECT bez, ort FROM stan_dienststellen_tmp WHERE dst_id='$row2[dst_id]'");
$row5 = $res5->fetch_array();
$dst_bez = $row5[bez]." ".$row5[name];
$ort = $row5[ort];
}
echo "
<table border=\"0\" cellpadding=\"4\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#E7E8ED\" width=\"100%\" id=\"AutoNumber1\">
<tr>
<td valign=top width=\"30%\" style=\"border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: solid; border-bottom-width: 1px\">
$dst_bez
</td>
<td valign=\"middle\" width=\"70%\" style=\"border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: solid; border-bottom-width: 1px\">
";
$res3 = $db->query("SELECT a.saaid
, a.dst_id
, a.beginn
, a.ende
, DATE_Format(c.datum, '%Y')AS beginn_jahr
, DATE_Format(c.datum, '%m')AS beginn_monat
, DATE_Format(c.datum, '%d')AS beginn_tag
, DATE_Format(c.datum, '%H:%i')AS Uhrzeit
, e.standort
, c.oertlichkeit
, c.hinweis
, c.status
FROM stan_antrag a, stan_ag_standort_wunsch b, stan_ag_standort_termine c, stan_ag_standort d, stan_standort e
WHERE a.saaid=$row2[saaid]
AND a.saaid = b.saaid
AND d.agsid=c.fagsid
AND d.agsid=b.wagsid
AND c.fagsid =b.wagsid
AND d.sid=e.sid
AND b.prio=0
AND DATE_Format(c.datum,'%Y%m%d') >=DATE_Format(a.beginn,'%Y%m%d')
AND DATE_Format(c.datum,'%Y%m%d') <=DATE_Format(a.ende,'%Y%m%d')
AND a.uid = '$uid1'
ORDER BY c.datum ASC
");
while ($row3 = $res3->fetch_array()){
$a = mktime(0, 0, 0, $row3[beginn_monat], $row3[beginn_tag], $row3[beginn_jahr]);
switch(date('w', $a)){
case 0:
$wochentag = 'So';
break;
case 1:
$wochentag = 'Mo';
break;
case 2:
$wochentag = 'Di';
break;
case 3:
$wochentag = 'Mi';
break;
case 4:
$wochentag = 'Do';
break;
case 5:
$wochentag = 'Fr';
break;
case 6:
$wochentag = 'Sa';
break;
}
switch($row3[status]){
case 'A':
if($row3[hinweis] == ''){
$status = 'Findet statt';
}else{
$hinweis = html_entity_decode($row3[hinweis]);
$hinweis = preg_replace("/\r*|\n*/s", "", $hinweis);
$hinweis = trim(strip_tags($hinweis,'<br>'));
$text ="<table width=100%><tr><td width=20%><b>Status:</b></td><td>Findet statt</td></tr><tr><td><b>Bemerkung:</b></td><td>$hinweis</td></tr></table>";
$titel = "Findet statt";
$status = "<a href=\"javascript:void(0);\" onmouseover=\"return overlib('$text',ABOVE, TEXTFONTCLASS,'text_overlib', WIDTH, 350, CAPTION, '$titel',CAPTIONSIZE, '10px');\" onmouseout=\"nd();\"><b>$titel</b></a>";
}
break;
case 'E':
if($row3[hinweis] == ''){
$status = 'Entfällt';
}else{
$hinweis = html_entity_decode($row3[hinweis]);
$hinweis = preg_replace("/\r*|\n*/s", "", $hinweis);
$hinweis = trim(strip_tags($hinweis,'<br>'));
$text ="<table width=100%><tr><td width=20%><b>Status:</b></td><td>Entfällt</td></tr><tr><td><b>Bemerkung:</b></td><td>$hinweis</td></tr></table>";
$titel = "Entfällt";
$status = "<a href=\"javascript:void(0);\" onmouseover=\"return overlib('$text',ABOVE, TEXTFONTCLASS,'text_overlib', WIDTH, 350, CAPTION, '$titel',CAPTIONSIZE, '10px');\" onmouseout=\"nd();\"><b>$titel</b></a>";
}
break;
case 'V':
if($row3[hinweis] == ''){
$status = 'Verschoben';
}else{
$hinweis = html_entity_decode($row3[hinweis]);
$hinweis = preg_replace("/\r*|\n*/s", "", $hinweis);
$hinweis = trim(strip_tags($hinweis,'<br>'));
$text ="<table width=100%><tr><td width=20%><b>Status:</b></td><td>Verschoben</td></tr><tr><td><b>Bemerkung:</b></td><td>$hinweis</td></tr></table>";
$titel = "Verschoben";
$status = "<a href=\"javascript:void(0);\" onmouseover=\"return overlib('$text',ABOVE, TEXTFONTCLASS,'text_overlib', WIDTH, 350, CAPTION, '$titel',CAPTIONSIZE, '10px');\" onmouseout=\"nd();\"><b>$titel</b></a>";
}
break;
}
echo "
<table width=100%>
<tr>
<td valign=top width=20%>
$wochentag, ".date('d.m.Y', $a)."
</td>
<td valign=top width=20%>
$row3[Uhrzeit] Uhr
</td>
<td valign=top width=20%>
$row3[standort]
</td>
<td valign=top width=20%>
$row3[oertlichkeit]
</td>
<td valign=top width=20%>
$status
</td>
</tr>
</table>
";
} // ende while, aktuelle Termine zur saaid
echo"
</td>
</tr>
</table>
";
} // ende while aktuelle saaids
} //ende while distinct vertiefungsbeeich
echo "
</td>
<td width=\"1%\" background=\"../images/box_r.gif\">
<img height=\"1\" src=\"../images/blank.gif\" width=\"22\"></td>
</tr>
<tr>
<td nowrap=\"nowrap\" align=\"left\" width=\"1%\" background=\"../images/box_e3.gif\">
<img height=\"16\" src=\"../images/blank.gif\" width=\"22\"></td>
<td nowrap=\"nowrap\" align=\"left\" width=\"98%\" background=\"../images/box_bottom.gif\">
<img height=\"16\" src=\"../images/blank.gif\" width=\"8\"></td>
<td nowrap=\"nowrap\" align=\"right\" width=\"1%\" background=\"../images/box_e4.gif\">
<img height=\"16\" src=\"../images/blank.gif\" width=\"22\"> </td>
</tr>
</table>
<br>
</form>
</div>
</td>
</tr>
</table>
</body>
</html>";
?>
Reference in New Issue View Git Blame Copy Permalink