7 day calendar

daveyc

Hello everyone,

I was wondering if I could trouble you again for a little bit of help.

I'm working on a little project for an internet radio station, where by the station manager can insert shows into the database and these would be pulled out and displayed on the website.

The pulling out of the shows isn't really a problem as such, as i've done this before.

What i'm looking to do is to give the admin a graphical interface for the schedule rather than a form with dropdown menus, where when submitted, it comes back and says "that slot is taken". I think this way may work better.

Dates are not a problem as radio shows are recurring on days of the week, so it doesnt matter about the day of the month for example, just monday - sunday.

Each day will have a table set out like this:

http://i267.photobucket.com/albums/ii293/daveycarter/example.jpg

When the manager clicks on a free slot it will give him a form to fill out with the time and day already set on it, so all they have to do is choose the presenter and submit the form.

I feel rather silly as I said to this guy "yeah, i'll be able to do that.. Cost? don't worry about it, it shouldnt take me long to knock up" :rolleyes:

At the moment, i've set my database up as follows:

http://i267.photobucket.com/albums/ii293/daveycarter/dbexample.jpg

All times are in minutes from midnight; e.g 60 = 01:00, 120 = 02:00 etc etc, and I have a function written that converts the minutes into hours and minutes. (I figured the minutes would be easier to work with)

Where i'm stuck at the moment is how to actually generate something like the first image. I'm okay with pulling out the shows for the specific days and listing them in the correct order, the only problem i'm having is to get it formatted correctly.

Does anyone have any insights? 🙂

Thanks a bunch,

Davey

zabmilenko

Do you have some code so we can scrutinize/edit it and see where it may be going wrong?

Remember to wrap it in [ html ] or [ php ] tags.

daveyc

Hi zabmilenko,

Not at the moment unfortunately. I'm lacking a starting point.. I know what I want to do, and have an idea of how it would work.

I think i've just had a little bit of a brain wave actually. So once I fix this stupid windows activation mid-life crisis that my computer is going through, i'll get onto writing some code and post it here.

Thanks 🙂

Dave

darkstrider

You might want to check out :

http://www.calendarix.com/

either to use the free software or get some ideas from the code.

Cheers.

daveyc

Right, that brainwave I had? Turned out to be gas.

Anyway, I've came up with this so far:


<?php
include('../config/config.php');
$sql = "SELECT * FROM `shows` WHERE `day` = 'Mon' ORDER BY `start` ASC";
$result = mysql_query($sql);

while($row = mysql_fetch_array($result)){

  $start = $row['start']; // Start time in minutes from midnight
  $duration = $row['duration']; // Duration of the show in minutes
  $end = $row['end']; // End time of the show in minutes from midnight

  $math = $duration / 60;
  $divpx = 15; // The height of each hour on the table cell
  $rndup = ceil($math);
  $height = $rndup * $divpx;

echo '<div style="height:'.$height.'px;background-color:#00FF00;">SHOW</div>';

}				  

?>

What i need to do now, is to create a div in between the show and the next one depending on the duration between the end of show 1 and the beginning of show 2.

Example

Show one: Starts at 00:00 and finishes at 06:00

Show two: Starts at 09:00 and finishes at 12:00

So in between i'd like to be able to display a div with a notice saying, slot free between 06:00 and 09:00.

Any ideas? 🙂

Thanks,

Dave

daveyc

Was just thinking.. Would something like incrementing a counter help any?

For example:

If this is the first result in the while loop, then just echo the div.

If it's not the first result, then find the previous result, and find the range between the end time of the first show and the beginning time of the next show, then echo a <div> container with a "slot available" link.

Thinking about it, I reckon it could work, but not sure.

Anyone? 🙂

Davey

daveyc

Anybody have any ideas please??

I'm pulling my hair out over here! hahaha

Also, something I didnt add in the previous message.. How would I go about filling in the remaining space with "Slot available" when there are no more shows on.

e.g. My table goes from 00:00 right through to 00:00 again, and say there were only two shows on any given day. So after 3pm there are no more shows. How could i fill the space from 3pm to 00:00 with "Slot Available".

Confused muchly? Me too! 😛

Davey 🙂

daveyc

Right.. I've given it a go, and the code is pretty damn sketchy, but it's "kinda" doing what I want it to do.

<?php
include('../config/config.php');
$sql = "SELECT * FROM `shows` WHERE `day` = 'Mon' ORDER BY `start` ASC";
$result = mysql_query($sql);

$evenrow = "#999999";
$oddrow = "#CCCCCC";
$oddfore = "#000000";
$evenfore = "#FFFFFF";


while($row = mysql_fetch_array($result)){
  $i = $i + 1;
  $j = $j + 1;
  $r = $r + 1;

  if ($r % 2) {
	$bgcolor = $oddrow;
	$text = $oddfore;
  } else {
  	$bgcolor = $evenrow;
	$text = $evenfore;
  }

$start[$i] = $row['start'];
$title = $row['title'];
$duration = $row['duration'];
$end = $row['end'];
$vari[$i] = $row['end'];
$math = $duration / 60;
$divpx = 14;
$rndup = floor($math);
$total = $rndup * $divpx;
$height = $total;

if($i == 1){
	$height = $height + 14;
	echo '<div align = "center" style="display: table-cell; vertical-align: middle;height:'.$height.'px;color:'.$text.';background-color:'.$bgcolor.';">'.m2h($start[$i]).' - '.m2h($end).' Show: '.$title.'</div>';
	$vari[$i] = $row['end'];									

}else{

	$n = $j - 1;
	$o = $i - 1;
	$range = $start[$i] - $vari[$o];
	$math2 = $range / 60;
	$rndrng = floor($math2);
	$total2 = $rndrng * 14;
	$newheight = $total2;

		if($newheight >= 14){

			echo '<div align = "center" style="height:'.$newheight.'px;background-color:#00FF00;">Empty Slot '.m2h($vari[$o]).' - '.m2h($start[$i]).'.</div>';
			echo '<div align = "center" style="height:'.$height.'px;color:'.$text.';background-color:'.$bgcolor.';">'.m2h($start[$i]).' - '.m2h($end).' Show: '.$title.'</div>';

		}else{

			echo '<div align = "center" style="height:'.$height.'px;color:'.$text.';background-color:'.$bgcolor.';">'.m2h($start[$i]).' - '.m2h($end).' Show: '.$title.'</div>';

		} // End if


}

} // End While				   

?>

The only problem i'm really having at the moment is getting the div's to line up with the table the script is contained in.

Each table row is 15px in height, and to the right of it, is a merged cell which contains my php code, so I figured it should all line up okay. (See the following screenshot)

http://i267.photobucket.com/albums/ii293/daveycarter/table.jpg

At the moment my head is a bit mashed with the code, so there's probably bits in there that REALLY dont need to be there, but could someone please take a look at it and give me some tips on how to better display the output etc.

Thanks muchly!

Dave