query("SELECT 1 FROM stan_admin_rechte, stan_admin_rechte_zuord , stan_admin where stan_admin_rechte.stan_admin_rolle = stan_admin_rechte_zuord.stan_admin_rolle AND stan_admin_rechte_zuord.said = stan_admin.said AND stan_admin.user = '$user_admin' AND stan_admin_rechte_zuord.stan_admin_rolle = 'a_fehl_ers'");
$row = $result->fetch_array();
if ($row[0] != 1){ include("kurs/rechte.php"); exit;}
// Rechteüberprüfung ende
if (isset($_GET['action']))
$action = $_GET['action'];
else
$action = "";
switch($action){
default:
if($hs =='K' or $hs =='k'){ //Empfängeradresse selektieren. Je nach Hochshule verschieden
$hochschule = 'Kehl';
}else{
$hochschule = 'Ludwigsburg';
}
echo"
Fehlende Erstanträge
Fehlende Erstantragsvormerkung Alle Studenten der Hochschule $hochschule, die bisher keinen Antrag vorgemerkt haben
Name
AG
";
$db = dbconnect();
$query = "SELECT distinct Nachname, Vorname, AG, Jahrgang, stud.mail, mtknr
FROM stud
LEFT JOIN stan_antrag USING ( uid )
WHERE stan_antrag.uid IS NULL
AND stud.Jahrgang=\"$jahrgang\"
AND stud.hs = '$hs'
AND stud.stg='I'
AND stud.durchgefallen!=\"Y\"
ORDER BY Nachname asc";
$result = $db->query($query)
or die ("Cannot execute query");
while ($row = $result->fetch_array()){
echo "
";
break;
case "mail":
$db = dbconnect();
$result2 = $db->query("SELECT count(distinct stud.uid) anzahl
FROM stud
LEFT JOIN stan_antrag USING ( uid )
WHERE stan_antrag.uid IS NULL
AND stud.Jahrgang=\"$jahrgang\"
AND stud.hs = '$hs'
AND stud.stg='I'
AND stud.durchgefallen!=\"Y\"
");
$row2 = $result2->fetch_array();
if($hs =='K' or $hs =='k'){ //Empfängeradresse selektieren. Je nach Hochshule verschieden
$result3 = $db->query("SELECT wert2 FROM parameter WHERE pid=7");
$row3 = $result3->fetch_array();
$hochschule = 'Kehl';
}else{
$result3 = $db->query("SELECT wert2 FROM parameter WHERE pid=4");
$row3 = $result3->fetch_array();
$hochschule = 'Ludwigsburg';
}
$result_admin = $db->query("SELECT vorname, nachname FROM stan_admin WHERE user='$user_admin'");
$row_admin = $result_admin->fetch_array();
echo "
![](\"../images/blank.gif\"){kind=spacer}
![](\"../images/mail.png\")
";
break;
case "mail":
$db = dbconnect();
$result2 = $db->query("SELECT count(distinct stud.uid) anzahl
FROM stud
LEFT JOIN stan_antrag USING ( uid )
WHERE stan_antrag.uid IS NULL
AND stud.Jahrgang=\"$jahrgang\"
AND stud.hs = '$hs'
AND stud.stg='I'
AND stud.durchgefallen!=\"Y\"
");
$row2 = $result2->fetch_array();
if($hs =='K' or $hs =='k'){ //Empfängeradresse selektieren. Je nach Hochshule verschieden
$result3 = $db->query("SELECT wert2 FROM parameter WHERE pid=7");
$row3 = $result3->fetch_array();
$hochschule = 'Kehl';
}else{
$result3 = $db->query("SELECT wert2 FROM parameter WHERE pid=4");
$row3 = $result3->fetch_array();
$hochschule = 'Ludwigsburg';
}
$result_admin = $db->query("SELECT vorname, nachname FROM stan_admin WHERE user='$user_admin'");
$row_admin = $result_admin->fetch_array();
echo "
![](\"../images/zurueck.gif\")