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_ag'");
$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 AG Standorte Alle Studenten der Hochschule $hochschule, die bisher noch keine bzw. nicht alle AG-Standorte gewählt haben.
Name
AG
Anzahl gewählt/von
";
$db = dbconnect();
$result_tmp1 = $db->query("DELETE FROM stan_tmp_check_data2 WHERE admin='$user_admin'");
$result_tmp1 = $db->query("INSERT INTO stan_tmp_check_data2
SELECT t1.saaid
, t1.vert_bereich
, t1.uid
, t1.beginn
, t1.ende
, t1.dst_id
, '$user_admin'
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.zuweisung is NULL OR t1.zuweisung='Z')
");
$query = "SELECT distinct a.uid, vorname, nachname, ag, jahrgang, mail, mail2, mtknr
FROM stan_tmp_check_data2 a, stud b
WHERE a.uid=b.uid
AND admin='$user_admin'
AND hs='$hs'
AND durchgefallen!='Y'
AND jahrgang='$jahrgang'
AND saaid NOT IN (SELECT saaid FROM stan_ag_standort_wunsch WHERE prio='1')
ORDER BY b.nachname asc";
$result = $db->query($query)
or die ("Cannot execute query1");
while ($row = $result->fetch_array()){
$result_anz_soll = $db->query("SELECT count(*) Anz
FROM stan_tmp_check_data2
WHERE uid='$row[uid]'");
$row_anz_soll = $result_anz_soll->fetch_array();
$result_anz_ist = $db->query("SELECT count(distinct a.saaid) Anz
FROM stan_ag_standort_wunsch a, stan_tmp_check_data2 b
WHERE a.saaid = b.saaid
AND b.admin='$user_admin'
AND a.uid='$row[uid]'
");
$row_anz_ist = $result_anz_ist->fetch_array();
echo "
";
$result_tmp1 = $db->query("DELETE FROM stan_tmp_check_data2 WHERE admin='$user_admin'");
break;
case "mail":
$db = dbconnect();
$result_tmp1 = $db->query("DELETE FROM stan_tmp_check_data2 WHERE admin='$user_admin'");
$result_tmp1 = $db->query("INSERT INTO stan_tmp_check_data2
SELECT t1.saaid
, t1.vert_bereich
, t1.uid
, t1.beginn
, t1.ende
, t1.dst_id
, '$user_admin'
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.zuweisung is NULL OR t1.zuweisung='Z')
");
$result_fehlend = $db->query("SELECT count(distinct a.uid) Anz
FROM stan_tmp_check_data2 a, stud b
WHERE a.uid=b.uid
AND admin='$user_admin'
AND hs='$hs'
AND saaid NOT IN (SELECT saaid FROM stan_ag_standort_wunsch WHERE prio='1')
ORDER BY b.nachname asc");
$row_fehlend = $result_fehlend->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\")
";
$result_tmp1 = $db->query("DELETE FROM stan_tmp_check_data2 WHERE admin='$user_admin'");
break;
case "mail":
$db = dbconnect();
$result_tmp1 = $db->query("DELETE FROM stan_tmp_check_data2 WHERE admin='$user_admin'");
$result_tmp1 = $db->query("INSERT INTO stan_tmp_check_data2
SELECT t1.saaid
, t1.vert_bereich
, t1.uid
, t1.beginn
, t1.ende
, t1.dst_id
, '$user_admin'
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.zuweisung is NULL OR t1.zuweisung='Z')
");
$result_fehlend = $db->query("SELECT count(distinct a.uid) Anz
FROM stan_tmp_check_data2 a, stud b
WHERE a.uid=b.uid
AND admin='$user_admin'
AND hs='$hs'
AND saaid NOT IN (SELECT saaid FROM stan_ag_standort_wunsch WHERE prio='1')
ORDER BY b.nachname asc");
$row_fehlend = $result_fehlend->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\")