[RESOLVED] Calendar problem

marko11

Hi all,

I'm newbie in php and I wondering if anyone can help me. Problem is how I get weekend table cell. Sa and su should be different color than other day cells in my calendar.

Here is the PHP code:

.start{ background-image: url(alku1.gif);
background-repeat: no-repeat;
background-position: top left}
.end{ background-image: url(loppu1.gif);
background-repeat: no-repeat;
background-position: top left
}
.empties { background-image: url(green.gif);
background-repeat: no-repeat;
background-position: top left
}

</style>

</head>

<body>

<?php
setlocale(LC_TIME, "fin");

$dbuser="root";
$dbpass="";
$host="localhost";

$yhteys=mysql_connect($host, $dbuser, $dbpass) or die(mysql_error());
if (!$conn)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("lincal", $conn);

$today = date('Y-n-j');

$action = mysql_query("SELECT * FROM actions WHERE start1 >= '$today'", $conn) or die("Kysely ei onnistunut:". mysql_error());

$actionlist = array();
while ($row = mysql_fetch_array($action)) {

$start = strtotime($row['start1']);
$end = strtotime($row['end1']);
$actionlist[] = array($start, $end);

}

$month = date('n');
$year = date('Y');
$day = date('j');

echo '<table width="100%" border="2px #009 solid; cellspacing="10" cellpadding="0" style="text-align: center">';
echo "<tr>";
echo "<th>month</th>";
for ($i=1;$i<=5;$i++)

//these are weekdays, mo,tu,we,th,fr,sa,su..

echo '<th style="width: 25px;">Ma</th><th style="width: 25px;">Ti</th><th style="width: 25px;">Ke</th><th style="width: 25px;">To</th><th style="width: 25px;">Pe</th><th style="width: 25px;" bgcolor= "#ECECFF">La</th><th style="width: 25px;" bgcolor= "#E2E2EB">Su</th>';
echo '<th style="width: 25px;">Ma</th><th style="width: 25px;">Ti</th>';

echo '<tr>';

for ($i=0; $i<12; $i++) {

$timestamp = mktime(0,0,0,$month+$i,1,$year);
$dayofweek = date('w', $timestamp);
$amountofdays = date('t', $timestamp);    

$empties = $dayofweek-1;    

echo '<td style=\"width: 20px; text-align: center;\" bgcolor="#FEFEFE">'.strftime("%B %Y", $timestamp).'</td>';

if ($dayofweek == 0) $empties = 6;

$empties--;    

for ($j=-1*$empties; $j<=$amountofdays; $j++) {

$thisDay = mktime(0,0,0,$month+$i,$j,$year);    

    if ($j == date('j') && $i == 0) {
      echo '<td bgcolor= "yellow" span style="color: red;" />';          
    } else {
      $action = false;
      foreach ($actionlist as $tl) {
          if ($tl[0] <= $thisDay && $tl[1] >= $thisDay) $action = true; 
         }

         if ($action == true){
          echo '<td bgcolor="red" />';

         } elseif ($start != $action){ 
         echo '<td class="start" />';
          } elseif ($end == $action) {
      echo '<td class="end" />';
      } else {
           echo '<td bgcolor="#91CD92" />';          
       }           

    }        

    if ($j>0 && ($i>0 || $j>=date('j'))) echo $j;
    else echo '<class="empties" />';
     echo '</td>';

}
    echo '</tr>';

}
echo '</table>';

mysql_close($conn);
?>

Help me, please. Thanks for advance.

Krik

First let me point you to the icons that are just above where you enter your questions or responses. 3 of them are used for code; "#", "<>", and "PHP". It helps a lot if you can use them when posting code.

Now to your queston.

"$dayofweek" looks to be storing the current numeric day of the week so

if ($dayofweek == 0 || $dayofweek == 6) {
   $bgcolor = "#0000FF"; // or what ever color you want
}
else {
    $bgcolor = "#FFFFFF"; // or what ever color you want
}

then in your <td> you have a style tag like so

<td style="background: <?php echo $bgcolor; ?>;">

Should also note I saw this <td> in your code.

<td bgcolor= "yellow" span style="color: red;" />

I would assume you are missing a "><" between yellow and span. But the "/>" while technically it can be used that way it is almost never used with a <td> or a <span>. As you usually put content in both you would use closing tags </td> or </span> after the content.

I also saw this

<class="empties" />

"class" is not an HTML tag. I am guessing you need a "td" in front of it.

Also in this

<table width="100%" border="2px #009 solid; cellspacing="10" cellpadding="0" style="text-align: center">

the "border="2px #009 solid;" should be in the "style" attribute if you wish to use it that way.

Lastly I will note it is probably best if you use only CSS to set the style of an element over using the HMTL attributes. Using both is really unnecessary if you are going to have a "style" attribute in the tag anyway.

marko11

Hi Krik,

And thank's for your answer. I add couple of changes in my code what you propose. But I'm little bit of confuse about the code, where I put the code, if ($dayofweek == 0 || $dayofweek == 6) exactly and is it suppose that other code put somewhere like that mode <td style="background: <?php echo $bgcolor; ?>;"> I'm not sure what you mean? Sorry my bad english.

Second question, I dont know how I can explain this, but I will try, You sure notice this is a linear year view calendar and its go in to mysql when I reservation a day in my calendar or a days the day cells went red thats ok but when I reservation especially in end of the month days 29,30,31 the reservation doesn't end of those days it continue next month empties and mark empties in red also thats why there is "class=empties", but I notice that it doesn't work and I forget to remove it. Can you see why my code do that? Do I miss something?

Can you help me please. Thanks for your help in advance.

-Marko

Krik

But I'm little bit of confuse about the code, where I put the code, if ($dayofweek == 0 || $dayofweek == 6) exactly

Place it right after the variable "$dayofweek".

Then the "$bgcolor" variable must be placed in all the <td> that need their background set.

Second question, I dont know how I can explain this, but I will try, You sure notice this is a linear year view calendar and its go in to mysql when I reservation a day in my calendar or a days the day cells went red thats ok but when I reservation especially in end of the month days 29,30,31 the reservation doesn't end of those days it continue next month empties and mark empties in red also thats why there is "class=empties", but I notice that it doesn't work and I forget to remove it. Can you see why my code do that? Do I miss something?

Yea your english is bit rough. I think I understand but I need clarify your question.

So, when a reservation is made, at the end of the month, and that reservation carries over to the following month, you are trying to get the calendar to mark the days in the following month reserved?

marko11

Hi Krik,

Here is bit of clarifying, The code do a reservation to next month and mark cells in red, but the code also mark in red the empty cells in beginning of next month. The reservation doesn't stop day 31 or any last day of month reservation carries over to next month. So I try to stop marking next month empty cells in beginning of month.

My calendar design:

                   Mo  Tu  We  Th  Fr  Sa  Su  Mo  Tu  We  Th  Fr  Sa  Su  Mo  Tu  We  Th  Fr  Sa  Su 
                   em  1      2    3   4   5   6   7   8   9   10 11                                              
                     1   2      3    4   5   6   7   8                                                                  29  30  31
                   em em   1   2   3  4   5   6   7   8

em = empty cell in beginning of month. So I booked days 29,30,31 it also booked em and em in next month.

I hope this ********ing a question. If not I can email for you a picture of my calendar, I think that's helping.

Thanks in advance. I hope you can help me I have wondering this problem quite long enough.

-Marko

Krik

I think I understand. You need the days that precede the 1st, on a given month, to be shaded red if the corresponding days of the previous month were reserved.

I have done a lot of calendars but never had to do that. I will have to think on that some. Maybe someone else here will come along and have a solution.

Krik

Ok, I think I have figured it out.

This is just a case of simple math. Is what you will have to do is have your code detect the first day of the month and find out what its numeric day of the week is. So if the 1st is a Wednesday that is 4 days into the week or date('w') will be 3.

You then add 1 to the 3 (or whatever number it is) as the first day of the week numeric value is 0. You then times the 4 by 24 and times that by 60 and times that by 60 again. This gives you the number of seconds since the first day of the week.

And lastly you deduct the above amount form your $timestamp

So at this point your code will look something like

if (date('j', $timestamp) == 1) {
    $deductseconds = (date('w', $timestamp) + 1) * (24 * 60 *60);
    $newtimestamp = $timestamp - $deductseconds;
}

You then create your monthly calendar starting at the $newtimestamp value which is actually starting 4 days prior to the first of the month. You use the value to look for reserved dates and populate your <td>'s based on that.

Now, the one problem I see is how to insert this into your current code. That may take a bit of thought. At least you have the concept and hopefully you can figure out how to manipulate it and your code to get some results.

marko11

Hi Krik,

Thanks for your answer. I try to figure out that but all what you write is make sense in that code. Now you mension that you have done a lot of calendars. Have you ever made reservation calendar where comes half day feature. I mean if some one want booking afternoon and in the calendar comes half day image on the table cell I mean it mark table cell in half day image? I'll try to do also that with checkbox. First come day-month-year and then you can choose half day with checkbox and when you put it in database you have first booked day half day image in the calendar. Do you have any ideas in that kind of design? What I have to do in theory?

-Marko

johanafm

Same as if you had hour bookings for each day: one row per reservation

create table ... (
 day		date,
 time		enum('pre', 'post'),
 ...,
 PRIMARY KEY(day, time)
)

If you had hourly booking, you'd have had to go with TINYINT UNSIGNED for time, and then restrict it to 0-23.
If you have variable start and variable length, you'd need to do some more work to make sure that reservations don't overlap (for whatever resource it is: a teacher, a hotelroom etc).

If you have a need to store data which has bearing on all reservations of a day, then you should split your table in two: one holding days, the other holding times (reservations).

marko11

Hi Johanafm,

I don't have hourly booking just day booking and I do have that kind of database where I store all reservation data. Yes my code "overlap" now and I don't know why but I try to figure out this overlapping. Do you have any ideas about for half day booking with checkbox? When put cross into checkbox then in calendar table cell comes half day image.

-Marko

johanafm

My response was tailored to your "half-day booking". The "hour booking" was just used as an example to show what you are indeed dealing with.

No, your reservations do not overlap. One is for first half of day, and the other is for the other half of the day. How can a reservation for the one room before noon overlap with the times it is booked during the afternoon?

What UI controls you use to select a specific time period doesn't have any effect on how you should store your data. Checkbox is one way, selectbox is another, and it's possible to do that in other ways as well.