![](\"../images/blank.gif\") |
Daten prüfen
|
|
|
|
";
$result3 = $db->query("SELECT DATE_FORMAT(antrag_von, '%d.%m.%Y') antrag_von, DATE_FORMAT(antrag_bis, '%d.%m.%Y') antrag_bis FROM stan_frist WHERE jahrgang ='$row[Jahrgang]'");
$row3 = $result3->fetch_array();
$result_tmp1 = $db->query("DELETE FROM stan_tmp_check_data WHERE uid='$uid1'");
$result_tmp1 = $db->query("INSERT INTO stan_tmp_check_data SELECT NULL, '$uid1', beginn, ende, 'Praxisbegleitender Unterricht' FROM stan_sperrzeit WHERE jahrgang ='$row[Jahrgang]' AND kennung = '$row[stg]'");
$result_tmp1 = $db->query("INSERT INTO stan_tmp_check_data
SELECT t1.saaid
, t1.uid
, t1.beginn
, t1.ende
, t1.ort
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_tmp1 = $db->query("DELETE FROM stan_tmp_check_data WHERE saaid='$saaid' and saaid !=0");
if($saaid == 'X'){
$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;
$result_tmp1 = $db->query("INSERT INTO stan_tmp_check_data (saaid, uid, beginn, ende, bezeichnung) VALUES ($saaid_neu, '$uid1', '$anfang_neu', '$ende_neu', '$_POST[ort]')");
}else{
$result_tmp1 = $db->query("INSERT INTO stan_tmp_check_data (saaid, uid, beginn, ende, bezeichnung) VALUES ($saaid, '$uid1', '$anfang_neu', '$ende_neu', '$_POST[ort]')");
}
$result_tmp1 = $db->query("INSERT INTO stan_tmp_check_data SELECT 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_tmp1 = $db->query("INSERT INTO stan_tmp_check_data SELECT NULL, '$uid1', DATE_ADD(antrag_bis, INTERVAL 1 DAY), DATE_ADD(antrag_bis, INTERVAL 1 DAY), '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
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");
echo "";
while ($row2 = $result->fetch_array()){
echo"
|
$row2[bezeichnung]
|
";
if($row2[bezeichnung] == 'Antragszeitraum Beginn'){
echo"$row3[antrag_von]";
}elseif($row2[bezeichnung] == 'Antragszeitraum Ende'){
echo"$row3[antrag_bis]";
}else{
echo"$row2[beginn] - $row2[ende]";
}
echo"
|
";
if($row2[Luecke] != 'OK'){
echo "![](\"../images/leerer_zeitraum.gif\") ";
}else{
echo "![](\"../images/gueltig.png\") ";
}
echo"
|
";
}
#$result_tmp1 = $db->query("DELETE FROM stan_tmp_check_data WHERE uid='$uid1'");
echo"
|
|
|
|
|
|
|
![](\"../images/zurueck.gif\")
![](\"../images/edit.png\" "\\"Antrag")
![](\"../images/drop.png\" "\\"Antrag")
![](\"../images/edit_grey.png\" "\\"Antrag")
![](\"../images/drop_grey.png\" "\\"Antrag")
![](\"../images/weitere_aend.gif\")
![](\"../images/daten_prfen.gif\")