mentecky
Posts: 321
|
| Posted: 06/02/2008, 12:39 AM |
|
I bent the code a bit and created a page that uses the same tables and code discussed in a previous thread. http://forums.yessoftware.com/posts.php?post_id=95561
This allows you to display the recurring events in the calendar control.
You can see it here. http://www.meetwny.com/chat_month_view.php
Viewing a past month you will see more effect because we closed some rooms that used to open around American Idol and Apprentice.
http://www.meetwny.com/chat_month_view.php?chat_roomsDate=2008-05
If anyone is interested I'll post a TIP on how I did it. It's a lot more complex than the original recurring events post.
One thing to note is... all the entries you see in the calendar are created from about 8 records in the recurring database.
Rick
_________________
http://www.ccselite.com |
 |
 |
wkempees
Posts: 1679
|
| Posted: 06/02/2008, 3:36 AM |
|
Rick,
Pleae do post the Tip.
Will these recurring 8 record events mingle nicely with any other 'normal' events?
Eagerly awaiting your post....
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
mentecky
Posts: 321
|
| Posted: 06/02/2008, 4:08 AM |
|
Quote wkempees:
Rick,
Pleae do post the Tip.
Will these recurring 8 record events mingle nicely with any other 'normal' events?
Eagerly awaiting your post....
Walter
OK Walter, I'll do it. It will take me a little preparation because this one is a bit different than my normal making CCS do stuff it doesn't do post. (It involves manually building the SQL in before execute select).
And YES!!!! It deals with "normal" events. On my planet a normal event is a "One Time Event" where the start and end dates are the same. But, you can actually have a one time event that spans several days.
Should I post this here or in the Hints and Tips section?
Rick
_________________
http://www.ccselite.com |
|
|
|
wkempees
Posts: 1679
|
| Posted: 06/02/2008, 4:21 AM |
|
Tips and Solution, yes please.
As to 'normal' events:
One would normaly have a table 'calendar_events' on which the calendar component functions nicely.
This table would hold a simple id,date, event basic layout, the component displaying the rows as events, clickable for more info.
I assume yours, would just expand on that table, or be a secondary table or any other intelligent construct. The reason fo asking is in relation to my booking calendar, in which we not have recurring but spawning events, events with a start - end date.
In that example I merely book a calendar_event (as described above) for every day of the event.
It makes 'booked day'selections a bit easier, but maintenance a bit harder (not too hard though).
I am now (low profile) looking at a combi of both.
Let's post!
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
mentecky
Posts: 321
|
| Posted: 06/02/2008, 4:23 AM |
|
Walter,
PS: If you think I pulled my hair out on the last SQL statement wait until you see this! 
Rick
_________________
http://www.ccselite.com |
|
|
|
wkempees
Posts: 1679
|
| Posted: 06/02/2008, 4:24 AM |
|
Quote :And YES!!!! It deals with "normal" events. On my planet a normal event is a "One Time Event" where the start and end dates are the same. But, you can actually have a one time event that spans several days.
Your previous example :
startdate - enddate, recurrancy (one time, daily, etc)
The start enddate would indicate the period in which the recurrance takes place.
Do you mean that a onetime event with start en endate not equal would indicate a spawning event?
Then how do you do a recurring spawning event, lol.
Walter
[P=2610]
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
mentecky
Posts: 321
|
| Posted: 06/02/2008, 4:27 AM |
|
Quote wkempees:
Tips and Solution, yes please.
As to 'normal' events:
One would normaly have a table 'calendar_events' on which the calendar component functions nicely.
This table would hold a simple id,date, event basic layout, the component displaying the rows as events, clickable for more info.
I assume yours, would just expand on that table, or be a secondary table or any other intelligent construct. The reason fo asking is in relation to my booking calendar, in which we not have recurring but spawning events, events with a start - end date.
In that example I merely book a calendar_event (as described above) for every day of the event.
It makes 'booked day'selections a bit easier, but maintenance a bit harder (not too hard though).
I am now (low profile) looking at a combi of both.
Let's post!
Walter
Yes I just add an "End Date".... Most normal events would get a "One Time" event type and both dates would be the same.
Rick
_________________
http://www.ccselite.com |
|
|
|
mentecky
Posts: 321
|
| Posted: 06/02/2008, 4:35 AM |
|
Quote wkempees:
Quote :And YES!!!! It deals with "normal" events. On my planet a normal event is a "One Time Event" where the start and end dates are the same. But, you can actually have a one time event that spans several days.
Your previous example :
startdate - enddate, recurrancy (one time, daily, etc)
The start enddate would indicate the period in which the recurrance takes place.
Do you mean that a onetime event with start en endate not equal would indicate a spawning event?
Then how do you do a recurring spawning event, lol.
Walter
[P=2610]
I don't, an event to me is a day. To do what you descibe would take multiple entries... but that would seem to be the exception. I do do "Weekday" and "Weekend" in my code which will span a long range of dates though.
Rick
_________________
http://www.ccselite.com |
|
|
|
wkempees
Posts: 1679
|
| Posted: 06/02/2008, 4:44 AM |
|
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
mentecky
Posts: 321
|
| Posted: 06/02/2008, 5:06 AM |
|
Quote wkempees:
If you prefer to write the TIP feel free. I'm just offering something I am actually using in the real world. I haven't even posted it yet. So, picking my solution apart now seems pointless.
Rick
_________________
http://www.ccselite.com |
|
|
|
wkempees
Posts: 1679
|
| Posted: 06/02/2008, 5:40 AM |
|
No, I don't, you do it, it is your method.
I was just curious, your solution stands and remains good.
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
mentecky
Posts: 321
|
| Posted: 06/02/2008, 7:06 PM |
|
As promised I posted my tip. I started a new thread because this one was getting long already. You can find it at http://forums.codecharge.com/posts.php?post_id=97419
Rick
_________________
http://www.ccselite.com |
|
|
|
|
