 |
Alterseinrichtungen Köniz
|
Admin:
zur Zeit freie Betten oder Wohnungen:
$Ende_y)
$error=1;
if(($Start_y==$Ende_y)&&($Start_m>$Ende_m))
$error=2;
if(($Start_y==$Ende_y)&&($Start_m==$Ende_m)&&($Start_d>$Ende_d))
$error=3;
if(isset($error)) {
unset($update);
echo "FEHLER:das Startdatum liegt hinter dem Enddatum ($Start_d.$Start_m.$Start_y - $Ende_d.$Ende_m.$Ende_y) !
\n";
}
/**********************************************************insert new line into database*****************/
//echo "query:($Start_y-$Start_m-$Start_d','$Ende_y-$Ende_m-$Ende_d','$Anzahl','$Typ','$Name')";
if(isset($update)) {
$sql="INSERT INTO angebot (Start,Ende,Anzahl,Typ,Name) VALUES ('$Start_y-$Start_m-$Start_d','$Ende_y-$Ende_m-$Ende_d','$Anzahl','$Typ','$Name')";
$ergebnis=mysql_query($sql,$verbindung);
if($ergebnis) {
echo "Updated!
";
}
else {
echo "query $sql not successful:
".mysql_errno()."\n";
}
}
/**********************************************************delete line in database***********************/
if(isset($delete)) {
$sql="DELETE FROM angebot WHERE id='$id'";
$ergebnis=mysql_query($sql,$verbindung);
if($ergebnis) {
echo "Deleted!
";
}
else {
echo "query $sql not successful:
".mysql_errno()."\n";
}
}
/*************init of the years******************/
for($y=2010;$y<=2012;$y++) {
for($m=1;$m<=12;$m++) {
for($d=1;$d<=31;$d++) {
$test[$y][$m][$d]=0;
}
}
}
/**********************************************************show table with results***********************/
$sql="SELECT * FROM angebot ORDER BY Start";
$ergebnis=mysql_query($sql,$verbindung);
$start=0;
$end=0;
$datum=0;
if($ergebnis) {
echo "";
//echo "| [id] | ";
echo "[Start] | ";
echo "[Ende] | ";
echo "[Anzahl] | ";
echo "[Typ] | ";
//echo "[Name] | ";
echo " |
";
while($zeile=mysql_fetch_array($ergebnis,MYSQL_ASSOC)) {
//update every line, but only show the proper ones...
$start=explode("-",$zeile[Start]);
$end=explode("-",$zeile[Ende]);
settype($start[1],"integer"); //conversion of the string "03" to the integer "3"
settype($start[2],"integer");
settype($end[1],"integer");
settype($end[2],"integer");
$y_s=$start[0];
$m_s=$start[1];
$d_s=$start[2];
$y_e=$end[0];
$m_e=$end[1];
$d_e=$end[2];
//echo "Start:$y_s-$m_s-$d_s
";
$y_s2=$y_s;
$m_s2=$m_s;
$d_s2=$d_s;
//echo "End:$y_e-$m_e-$d_e
";
for($y=$y_s;$y<=$end[0];$y++) {
//echo "year:$y
";
if($y!=$end[0]) {
$m_e=12;
}
else {
$m_e=$end[1];
}
for($m=$m_s;$m<=$m_e;$m++) {
//echo "month:$m
";
if($y==$end[0]&&$m==$end[1])
$d_e=$end[2];
else
$d_e=31;
for($d=$d_s;$d<=$d_e;$d++) {
//echo "d:$d-";
$test[$y][$m][$d]=1;
}
$d_s=1;
//echo "
";
}
$m_s=1;
}
/* just for testing
echo "
$y-$m-$d
";
foreach($test as $kkk=>$all){
foreach($all as $kk=>$detail){
foreach($detail as $k=>$elem){
//echo "$kkk:$kk:$k:$elem
";
}
}
}
*/
if($zeile[Name]==$Name) { //only show the entry if it belongs to this institution
//echo "| $zeile[id] | ";
echo "$d_s2.$m_s2.$y_s2 | ";
echo "$d_e.$m_e.$y_e | ";
echo "$zeile[Anzahl] | ";
echo "$zeile[Typ] | ";
//echo "$zeile[Name] | ";
echo "löschen |
";
}
}
echo "
";
mysql_free_result($ergebnis);
}
else {
echo "query $sql not successful:
".mysql_errno()."\n";
}
/**********************************************************update jahr2002-2007***********************/
//$year=2002;
//$monat=8;
for($year=2010;$year<=2012;$year++) {
for($monat=1;$monat<=12;$monat++) {
$tofill=$test[$year][$monat];
$filler=implode(",",$tofill);
$tablename="jahr$year";
//echo $filler;
//$sql="REPLACE INTO $tablename (monat,d1,d2,d3,d4,d5,d6,d7,d8,d9,d10,d11,d12,d13,d14,d15,d16,d17,d18,d19,d20,d21,d22,d23,d24,d25,d26,d27,d28,d29,d30,d31) VALUES ($monat,1,1,1,1,1,1,1,1,1,0,1,1,1,1,1,1,1,1,1,0,1,1,1,1,1,1,1,1,1,0,1)";
$sql="REPLACE INTO $tablename (monat,d1,d2,d3,d4,d5,d6,d7,d8,d9,d10,d11,d12,d13,d14,d15,d16,d17,d18,d19,d20,d21,d22,d23,d24,d25,d26,d27,d28,d29,d30,d31) VALUES ($monat,$filler)";
$ergebnis=mysql_query($sql,$verbindung);
if($ergebnis) {
//echo "Year $year filled!
";
}
else {
echo "query $sql not successful:
".mysql_errno()."\n";
}
//echo "->monat:$monat
";
}
//echo "
Year $year filled!
";
}
?>
neue Freischaltung:
oder wenn die Wohnung bis auf weiteres frei ist: