Logo i kalender
Jeg har fået lavet et kalender-script, og det virker også ganske glimrende.. Men nu vil jeg gerne have en "type" på hver dato - altså om det f.eks. er en koncert, biograf premiere osv. Som scriptet er lige nu, viser jeg et billede til højre for hver overskrift. Jeg vil i stedet gerne have at den bliver vist i venstre kolonne - altså under datoerne.Kan det lade sig gøre?
-- Script --
<?php
# Functions
function date_info($info, $month, $year) {
return date($info, mktime(0,0,0,$month,1,$year));
}
# DB CONNECT
open();
function getBookings($month, $year) {
$sql = mysql_query("
SELECT DAYOFMONTH(startdate) AS day, days, rooms, title, beskrivelse, type
FROM testkalender
WHERE MONTH(startdate) = '$month' && YEAR(startdate) = '$year'
ORDER BY day ASC
") or die(mysql_error());
$res = array();
if (!mysql_num_rows($sql)) return $res;
while ($foo = mysql_fetch_assoc($sql)) {
if ($foo['days'] == 1) {
$res[$foo['day']]['title'] .= "<b>".$foo['title']."</b><IMG SRC=graph/kalender_".$foo['type'].".jpg WIDTH=30 HEIGHT=30>\n".$foo['beskrivelse']."\n\n";
$res[$foo['day']]['totalrooms'] = $res[$foo['day']]['totalrooms'] + $foo['rooms'];
} else {
$today = $foo['day'];
for($i=1; $i<=$foo['days']; $i++) {
$res[$today]['title'] .= "<b>".$foo['title']."</b> (Dag ".$i."/".$foo['days'].") <IMG SRC=graph/kalender_".$foo['type'].".jpg WIDTH=30 HEIGHT=30>\n".$foo['beskrivelse']."\n\n";
$res[$today]['totalrooms'] = $res[$today]['totalrooms'] + $foo['rooms'];
$today++;
}
}
}
return $res;
}
# Pre-values
$year = date('Y');
$month = date('m');
# Catch month or year if passed
if (isset($_GET["month"]) && $_GET["month"] >= 1 && $_GET["month"] <= 12) $month = $_GET["month"];
if (isset($_GET["year"]) && $_GET["year"] > $year) $year = $_GET["year"];
# Static date names - language specific
$MONTHNAME = array("", "Januar", "Februar", "Marts", "April", "Maj", "Juni", "Juli", "August", "September", "Oktober", "November", "December");
# Month for listing
$listingmonth = date('m');
if ($year != date('Y')) $listingmonth = 1;
# Init months array with days and first day of month
$MONTHINFO = array();
# Initialize days in month
$MONTHINFO["days"] = date_info("t", $month, $year);
$MONTHINFO["firstday"] = date_info("w", $month, $year);
$MONTHINFO["weekno"] = date_info("W", $month, $year);
# Get room assignment
$ASSIGNMENT = getBookings($month, $year);
# Set colorclass for td
$class = "red";
if ((($MONTHS["firstday"]+$i)%7) == 6) $class = "normal";
?>
<div align="center"><B>År 2003/2004:</B><BR><?php for ($i=$listingmonth; $i<=12; $i++) { ?> | <a href='index.php?side=kalender&year=<?php echo $year; ?>&month=<?php echo $i; ?>'><?php echo $MONTHNAME[$i]; ?></a> <?php } ?>|<a href='index.php?side=kalender&year=<?php echo $year+1; ?>&month=1'><?php echo $year+1; ?></a></div>
<br><br>
<table width="350" border="0" cellspacing="0" cellpadding="0" align="center">
<tr valign="top">
<td colspan="3" class="month" valign="top"><b><?php echo $MONTHNAME[$month]; ?> <?php echo $year; ?></b></td>
</tr>
<?php for ($i=1; $i<=$MONTHINFO["days"]; $i++) { ?>
<tr>
<td witdh="100" valign="top" class="<?php echo $class; ?>"><?php echo $i; ?>.
<?php # Insert week no if week is starting
if ((($MONTHINFO["firstday"]+$i)%7) == 2) echo "Uge: ".++$MONTHINFO["weekno"];
?><BR>
<?php
// BILLEDE SKAL IND HER !!!
?>
</td>
<td witdh="250" class="<?php echo $class; ?>" valign="top">
<?php
if (isset($ASSIGNMENT[$i])) {
echo nl2br($ASSIGNMENT[$i]['title'])."<br>";
echo $ASSIGNMENT[$i]['totalrooms'] . " i alt.";
}
?>
</td>
</tr>
<?php } ?>
</table>
