167 lines
3.2 KiB
PHP
Executable File
167 lines
3.2 KiB
PHP
Executable File
<?php
|
|
include("kurs/datenbankanbindung.php"); // fügt die Datenbankanbindung ein: Sys:\php\includes\kurs\datenbankanbindung.php
|
|
require("../stud/func_get_block.php");
|
|
|
|
$db = dbconnect();
|
|
$query = "SELECT t1.saaid
|
|
, w.bezeichnung
|
|
, t1.uid
|
|
, t1.vert_bereich
|
|
, x.vorname
|
|
, x.nachname
|
|
, x.jahrgang
|
|
, t1.beginn
|
|
, t1.ende
|
|
, t1.abteilung
|
|
, x.hs
|
|
, y.bez
|
|
, y.str
|
|
, y.plz
|
|
, y.postfach
|
|
, y.plz_postfach
|
|
, y.ort
|
|
, NULL mail
|
|
FROM stan_antrag t1, stud x, stan_vertiefungsbereich w, stan_dienststellen_tmp y, stan_stellenart z
|
|
WHERE t1.uid=x.uid
|
|
AND t1.dst_id=y.dst_id
|
|
AND t1.vert_bereich=w.vbid
|
|
AND z.artid=t1.art
|
|
AND t1.status = (
|
|
SELECT MAX(t2.status)
|
|
FROM stan_antrag t2
|
|
WHERE t1.aendid = t2.aendid
|
|
AND t2.status !='2'
|
|
)
|
|
AND (upper(bez) like '%MUST%'
|
|
or upper(bez) like '%TEST%'
|
|
or upper(bez) like ''
|
|
or upper(bez) like '%NACHG%'
|
|
)
|
|
AND x.jahrgang = '15'
|
|
ORDER BY hs, uid, beginn";
|
|
|
|
$result = $db->query ($query)
|
|
or die ("Cannot execute query2");
|
|
|
|
|
|
echo "<table>
|
|
<tr>
|
|
<td>
|
|
<b>SAID</b>
|
|
</td>
|
|
<td>
|
|
<b>Vertiefungsbereich</b>
|
|
</td>
|
|
<td>
|
|
<b>Benutzerkennung</b>
|
|
</td>
|
|
<td>
|
|
<b>Vorname</b>
|
|
</td>
|
|
<td>
|
|
<b>Nachname</b>
|
|
</td>
|
|
<td>
|
|
<b>Jahrgang</b>
|
|
</td>
|
|
<td>
|
|
<b>Beginn Praxisstelle</b>
|
|
</td>
|
|
<td>
|
|
<b>Ende Praxisstelle</b>
|
|
</td>
|
|
<td>
|
|
<b>Block</b>
|
|
</td>
|
|
<td>
|
|
<b>Abteilung</b>
|
|
</td>
|
|
<td>
|
|
<b>Hochschule</b>
|
|
</td>
|
|
<td>
|
|
<b>Stellenbezeichnung</b>
|
|
</td>
|
|
<td>
|
|
<b>Stelle Str.</b>
|
|
</td>
|
|
<td>
|
|
<b>PLZ</b>
|
|
</td>
|
|
<td>
|
|
<b>Postfach</b>
|
|
</td>
|
|
<td>
|
|
<b>PLZ Postfach</b>
|
|
</td>
|
|
<td>
|
|
<b>Ort</b>
|
|
</td>
|
|
<td>
|
|
<b>Mail</b>
|
|
</td>
|
|
<tr>
|
|
";
|
|
while ($row = $result->fetch_array()){
|
|
$block = get_block($row['saaid'], $row['jahrgang']);
|
|
echo"
|
|
<tr>
|
|
<td>
|
|
$row[saaid]
|
|
</td>
|
|
<td>
|
|
$row[bezeichnung]
|
|
</td>
|
|
<td>
|
|
$row[uid]
|
|
</td>
|
|
<td>
|
|
$row[vorname]
|
|
</td>
|
|
<td>
|
|
$row[nachname]
|
|
</td>
|
|
<td>
|
|
$row[jahrgang]
|
|
</td>
|
|
<td>
|
|
$row[beginn]
|
|
</td>
|
|
<td>
|
|
$row[ende]
|
|
</td>
|
|
<td>
|
|
$block
|
|
</td>
|
|
<td>
|
|
$row[abteilung]
|
|
</td>
|
|
<td>
|
|
$row[hs]
|
|
</td>
|
|
<td>
|
|
$row[bez]
|
|
</td>
|
|
<td>
|
|
$row[str]
|
|
</td>
|
|
<td>
|
|
$row[plz]
|
|
</td>
|
|
<td>
|
|
$row[postfach]
|
|
</td>
|
|
<td>
|
|
$row[plz_postfach]
|
|
</td>
|
|
<td>
|
|
$row[ort]
|
|
</td>
|
|
<td>
|
|
$row[mail]
|
|
</td>
|
|
<tr>
|
|
";
|
|
}
|
|
echo "</table>";
|
|
?>
|