diff options
author | ichdasich <ichdasich@29ba0400-6e00-0410-a75a-ca02368028f8> | 2008-09-10 03:42:44 +0000 |
---|---|---|
committer | ichdasich <ichdasich@29ba0400-6e00-0410-a75a-ca02368028f8> | 2008-09-10 03:42:44 +0000 |
commit | b00d5b96c6d33572b6d7c68688d6d1c4fbd0f0f4 (patch) | |
tree | cf02da8b2839bea3b6a966b575f2ba84966676bb /includes/funktion_schichtplan_Tage.php | |
parent | 34aff10f383fe963cd3f8fd7f096321302e1efb6 (diff) |
moved /inc to ../includes
git-svn-id: svn://svn.cccv.de/engel-system@281 29ba0400-6e00-0410-a75a-ca02368028f8
Diffstat (limited to 'includes/funktion_schichtplan_Tage.php')
-rwxr-xr-x | includes/funktion_schichtplan_Tage.php | 87 |
1 files changed, 87 insertions, 0 deletions
diff --git a/includes/funktion_schichtplan_Tage.php b/includes/funktion_schichtplan_Tage.php new file mode 100755 index 00000000..5ac92e7e --- /dev/null +++ b/includes/funktion_schichtplan_Tage.php @@ -0,0 +1,87 @@ +<?PHP + +if( !function_exists("DatumUm1TagErhoehen")) +{ + function DatumUm1TagErhoehen( $Datum) + { + $Jahr = substr( $Datum, 0, 4); + $Monat = substr( $Datum, 5, 2); + $Tag = substr( $Datum, 8, 2); + + $Tag++; + + switch( $Monat) + { + case 1: $Mmax=31; break; + case 2: $Mmax=28; break; + case 3: $Mmax=31; break; + case 4: $Mmax=30; break; + case 5: $Mmax=31; break; + case 6: $Mmax=30; break; + case 7: $Mmax=31; break; + case 8: $Mmax=31; break; + case 9: $Mmax=30; break; + case 10: $Mmax=31; break; + case 11: $Mmax=30; break; + case 12: $Mmax=31; break; + } + + if( $Tag > $Mmax) + { + $Tag = 1; + $Monat++; + } + + if( $Monat > 12 ) + { + $Monat = 1; + $Jahr++; + } + + $Tag = strlen( $Tag ) == 1 ? "0".$Tag : $Tag; + $Monat = strlen( $Monat ) == 1 ? "0".$Monat : $Monat; + + return ("$Jahr-$Monat-$Tag"); + } //function DatumUm1Tagerhoehen( +} + +//suchen den ersten eintrags +$SQL = "SELECT `DateS` FROM `Shifts` ORDER BY `DateS` LIMIT 1"; +$Erg = mysql_query($SQL, $con); + +$Pos=0; + +if( mysql_num_rows($Erg)>0) +{ + do + { + //Startdatum einlesen und link ausgeben + $DateS = substr(mysql_result($Erg, 0 , 0), 0,10); + $VeranstaltungsTage[$Pos++] = $DateS; + + //auslesen den endes und eventuelle weitere tage ausgeben + $SQL2 = "SELECT MAX(`DateE`) FROM `Shifts` ". + "WHERE ( (`DateS` like '$DateS%') AND NOT (`DateE` like '%00:00:00'))"; + $Erg2 = mysql_query($SQL2, $con); + $DateE = substr(mysql_result($Erg2, 0 , 0), 0,10); + + if( strlen($DateE) == 0) + $DateE = $DateS; + else + while( $DateS != $DateE) + { + $DateS = DatumUm1TagErhoehen( $DateS); + $VeranstaltungsTage[$Pos++] = $DateS; + } + + //suchen den nästen eintrag + $SQL = "SELECT `DateS` FROM `Shifts` ". + "WHERE (`DateS` > '$DateE 23:59:59' ) ". + "ORDER BY `DateS` ". + "LIMIT 1"; + $Erg = mysql_query($SQL, $con); + } while( mysql_fetch_row($Erg) > 0); +} +$VeranstaltungsTageMax = $Pos-1; + +?> |