Rohlan Posted July 21, 2008 Share Posted July 21, 2008 Hello! First of all, I am sorry if this isn't the right place to post this... but here goes. I've been trying for the past few days to accomplish something that I finally deemed out of my league when it comes to programming. I need to create/generate a graphical display that shows when and where a team needs to be at a certain time in a day. My MYSQL Table returns the following information: TEAM_ID | CLIENT / LOCATION | BEGIN HOUR | END HOUR | DAY | 1 | FOO | 8 | 11 | 2008-06-07 | 1 | BAR | 9 | 12 | 2008-06-07 | 2 | FOO | 10 | 13 | 2008-06-07 | 2 | JOE | 15 | 18 | 2008-06-07 | 3 | FOO | 18 | 20 | 2008-06-07 | 3 | JOE | 10 | 19 | 2008-06-07 | 4 | BAR | 8 | 14 | 2008-06-07 | I can display this information easily, but my client needs it to be displayed graphically. I've ran into some problems trying to do it by myself, mainly due to overlapping events (which are allowed to occur), therefore I wanted to ask anyone out there to see if they had a suggestion I could follow, a tutorial or some other type of help, anything would be greatly appreciated. ps, Because there will be recurring events, the check for overlapped events needs to be done at "runtime", I have no idea how to achieve this... I've added a picture to illustrate the required output. [attachment deleted by admin] Quote Link to comment https://forums.phpfreaks.com/topic/115830-solved-complex-team-scheduler-calendar/ Share on other sites More sharing options...
revraz Posted July 21, 2008 Share Posted July 21, 2008 Make a Calendar output? Quote Link to comment https://forums.phpfreaks.com/topic/115830-solved-complex-team-scheduler-calendar/#findComment-595474 Share on other sites More sharing options...
JasonLewis Posted July 21, 2008 Share Posted July 21, 2008 This will get complex I would think. I am bored at the moment so I a whacking a script together, but I am running out of time. It's nearly midnight and I'm ready for bed. So if you don't have a solution by tomorrow sometime then you'll probably get a message from me with the script. Quote Link to comment https://forums.phpfreaks.com/topic/115830-solved-complex-team-scheduler-calendar/#findComment-595478 Share on other sites More sharing options...
Rohlan Posted July 21, 2008 Author Share Posted July 21, 2008 Make a Calendar output? I'm not sure what you mean...? This will get complex I would think. I am bored at the moment so I a whacking a script together, but I am running out of time. It's nearly midnight and I'm ready for bed. So if you don't have a solution by tomorrow sometime then you'll probably get a message from me with the script. That would mean the world to me, ProjectFear. I am getting more and more confused as I keep poking around see what I can come up with. The biggest problem I have is knowing whether an event is overlapping or not, because this check needs to be done at run time like I said, I am all sorts of confused ??? Quote Link to comment https://forums.phpfreaks.com/topic/115830-solved-complex-team-scheduler-calendar/#findComment-595692 Share on other sites More sharing options...
revraz Posted July 21, 2008 Share Posted July 21, 2008 I was referring to having a calendar display with your entries in each date. The normal calendar look. Quote Link to comment https://forums.phpfreaks.com/topic/115830-solved-complex-team-scheduler-calendar/#findComment-595864 Share on other sites More sharing options...
Rohlan Posted July 21, 2008 Author Share Posted July 21, 2008 I require that the day-view be displayed like the image I uploaded. The month and week views aren't done yet, they aren't even that important for now. I have finally reached a point where I can safely breathe... I think I found a solution using multiple dimension arrays, thanks to a friend of mine who gave me a push in the right direction. I still need to tinker with it however. Quote Link to comment https://forums.phpfreaks.com/topic/115830-solved-complex-team-scheduler-calendar/#findComment-595893 Share on other sites More sharing options...
Rohlan Posted July 21, 2008 Author Share Posted July 21, 2008 I have found a solution to this problem, here is a snapshot of what I was able to achieve with the help of a friend of mine: [attachment deleted by admin] Quote Link to comment https://forums.phpfreaks.com/topic/115830-solved-complex-team-scheduler-calendar/#findComment-595970 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.