![](\"../images/blank.gif\") |
Status der Änderungsanträge
|
|
|
|
|
Bezeichnung
|
Vertiefungsbereich
|
Zeitraum
|
Status
|
";
$result_tmp1 = $db->query("DELETE FROM stan_tmp_check_data WHERE uid='$uid1'");
$result_tmp1 = $db->query("INSERT INTO stan_tmp_check_data
SELECT t1.saaid
, t1.vert_bereich
, t1.uid
, t1.beginn
, t1.ende
, t1.dst_id
FROM stan_antrag t1
WHERE t1.status = (
SELECT MAX(t2.status)
FROM stan_antrag t2
WHERE t1.aendid = t2.aendid
)
AND t1.uid = '$uid1'
AND (t1.zuweisung is NULL OR t1.zuweisung='Z')
");
#$result = $db->query("SELECT max(saaid) max_id FROM stan_tmp_check_data WHERE uid='$uid1'");
#$row4 = $result->fetch_array();
#$saaid_neu = $row4[max_id] + 1; // Damit alle Einträge eine ID haben
#$result_tmp1 = $db->query("INSERT INTO stan_tmp_check_data SELECT $saaid_neu, NULL, '$uid1', DATE_SUB(antrag_von, INTERVAL 1 DAY), DATE_SUB(antrag_von, INTERVAL 1 DAY), 'Antragszeitraum Beginn' FROM stan_frist WHERE jahrgang ='$row[Jahrgang]'");
#$result = $db->query("SELECT max(saaid) max_id FROM stan_tmp_check_data WHERE uid='$uid1'");
#$row4 = $result->fetch_array();
#$saaid_neu = $row4[max_id] + 1; // Damit alle Einträge eine ID haben
#$result_tmp1 = $db->query("INSERT INTO stan_tmp_check_data SELECT $saaid_neu, NULL, '$uid1', antrag_bis, antrag_bis, 'Antragszeitraum Ende' FROM stan_frist WHERE jahrgang ='$row[Jahrgang]'");
$query = "SELECT ma.uid, DATE_FORMAT(beginn, '%d.%m.%Y') beginn, DATE_FORMAT(ende, '%d.%m.%Y') ende, bezeichnung, COALESCE( luecke, 'OK' ) AS Luecke, ma.saaid, ma.vbid
FROM stan_tmp_check_data ma
LEFT JOIN ( SELECT saaid, 'Lücke folgt' AS luecke
FROM stan_tmp_check_data a
WHERE a.ende != (SELECT MAX( ende ) FROM stan_tmp_check_data x WHERE x.uid = a.uid)
AND NOT EXISTS ( SELECT saaid FROM stan_tmp_check_data b
WHERE a.uid = b.uid
AND b.beginn = DATE_ADD( a.ende, INTERVAL 1 DAY )
)
OR ( a.beginn IN (select beginn FROM stan_tmp_check_data d WHERE d.saaid != a.saaid)
AND a.ende IN (select ende FROM stan_tmp_check_data e WHERE e.saaid != a.saaid AND e.uid = '$uid1')
)
) L
ON L.saaid = ma.saaid
WHERE ma.uid = '$uid1'
ORDER BY ma.uid, ma.beginn";
$result = $db->query($query)
or die ("Cannot execute query");
while ($row2 = $result->fetch_array()){
$res4a = $db->query("SELECT dst_id, status, zuweisung FROM stan_antrag WHERE saaid='$row2[saaid]'");
$row4a = $res4a->fetch_array();
$res4b = $db->query("SELECT bezeichnung FROM stan_vertiefungsbereich WHERE vbid='$row2[vbid]'");
$row4b = $res4b->fetch_array();
$res4 = $db->query("SELECT bez, ort FROM stan_dienststellen WHERE dst_id='$row4a[dst_id]'");
$row4 = $res4->fetch_array();
if($row4['bez'] != ''){
$dst_bez = $row4['bez']." ".$row4['name'];
$ort = $row4['ort'];
}
if($row4['bez'] == ''){
$res5 = $db->query("SELECT bez, ort FROM stan_dienststellen_tmp WHERE dst_id='$row4a[dst_id]'");
$row5 = $res5->fetch_array();
$dst_bez = $row5['bez']." ".$row5['name'];
$ort = $row5['ort'];
}
if($row4['bez'] == '' AND $row5['bez'] == ''){
$dst_bez = 'Zeitraum vorgemerkt';
$ort = "";
}
echo"
|
$dst_bez
|
$row4b[bezeichnung]
|
$row2[beginn] - $row2[ende]
|
";
if($row4a['status'] == '0' AND $row4a['zuweisung'] == NULL){
$status ='Erstantrag unbearbeitet';
}
if($row4a['status'] == '2' AND $row4a['zuweisung'] == NULL){
$status ='Neu / nicht abgeschickt';
}
if($row4a['status'] == '1' AND $row4a['zuweisung'] == NULL){
$status ='Änderungsantrag neu / abgeschickt';
}
if($row4a['status'] == '0' AND $row4a['zuweisung'] == 'Z'){
$status ='Erstantrag genehmigt';
}
if($row4a['status'] == '1' AND $row4a['zuweisung'] == 'Z'){
$status ='Änderungsantrag genehmigt';
}
echo "$status";
echo"
|
";
}
echo "
|
|
|
|
|
|
|
![](\"../images/zurueck.gif\")