68 lines
2.8 KiB
PHP
Executable File
68 lines
2.8 KiB
PHP
Executable File
<?php
|
|
#include_once("kurs/datenbankanbindung.php"); // fügt die Datenbankanbindung ein: Sys:\php\includes\kurs\datenbankanbindung.php
|
|
function get_block($saaid, $jahrgang){
|
|
global $db;
|
|
$db = dbconnect();
|
|
$result_gb1 = $db->query("SELECT antrag_von, date_format(antrag_von, '%d') tag, date_format(antrag_von, '%m') monat, date_format(antrag_von, '%Y') jahr
|
|
FROM stan_frist
|
|
WHERE jahrgang='$jahrgang'");
|
|
$row_gb1 = $result_gb1->fetch_array();
|
|
|
|
$result_gb2 = $db->query("SELECT vert_bereich, uid
|
|
FROM stan_antrag
|
|
WHERE saaid='$saaid'");
|
|
$row_gb2 = $result_gb2->fetch_array();
|
|
|
|
|
|
$result_gb3 = $db->query("SELECT min(beginn) beginn, max(ende) ende
|
|
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.vert_bereich='$row_gb2[vert_bereich]'
|
|
AND t1.uid='$row_gb2[uid]'
|
|
AND (t1.zuweisung is NULL OR t1.zuweisung='Z')
|
|
AND t1.saaid = $saaid # hinzugefügt am 25.07.2019, da Agnes Schach sonst kein Block 2 bekommen hätte
|
|
|
|
");
|
|
|
|
|
|
$row_gb3 = $result_gb3->fetch_array();
|
|
|
|
|
|
|
|
if($row_gb3['beginn'] == $row_gb1['antrag_von']){
|
|
$block = 1;
|
|
}
|
|
|
|
$block2_beg_min = date("Y-m-d", mktime(0, 0, 0, $row_gb1['monat']+3, $row_gb1['tag'], $row_gb1['jahr']));
|
|
#$block2_beg_max = date("Y-m-d", mktime(0, 0, 0, $row_gb1[monat]+5, $row_gb1[tag], $row_gb1[jahr]));
|
|
|
|
if($row_gb3['beginn'] >= $block2_beg_min){
|
|
$block = 2;
|
|
}
|
|
|
|
$block3_beg_min = date("Y-m-d", mktime(0, 0, 0, $row_gb1['monat']+6, $row_gb1['tag'], $row_gb1['jahr']));
|
|
#$block3_beg_max = date("Y-m-d", mktime(0, 0, 0, $row_gb1[monat]+8, $row_gb1[tag], $row_gb1[jahr]));
|
|
echo @$block3_beg_max;
|
|
if($row_gb3['beginn'] >= $block3_beg_min){
|
|
$block = 3;
|
|
}
|
|
|
|
|
|
$block4_beg_min = date("Y-m-d", mktime(0, 0, 0, $row_gb1['monat']+9, $row_gb1['tag'], $row_gb1['jahr']));
|
|
#$block4_beg_max = date("Y-m-d", mktime(0, 0, 0, $row_gb1[monat]+11, $row_gb1[tag], $row_gb1[jahr]));
|
|
echo @$block4_beg_max;
|
|
if($row_gb3['beginn'] >= $block4_beg_min){
|
|
$block = 4;
|
|
}
|
|
|
|
|
|
return $block;
|
|
}
|
|
|
|
#echo get_block(87047, 18);
|
|
?>
|