Posted 07 Apr 2011
Link to this post
I have a schedular which is used for creating appointments for staff.When I create a new appointment with recurrence ie. a staff is having an appointment daily for a week.The recurrence information is stored in schedular table's field RecData like this
DTSTART:20110407T100000Z DTEND:20110407T110000Z RRULE:FREQ=DAILY;UNTIL=20110415T000000Z;INTERVAL=1;BYDAY=MO,TU,WE,TH,FR,SA,SU
Now I have a page called as a dashboard with date criteria given ie if the date is selected as 15 April2011 then all the appointments of 15 March 2011 will be displayed.
Now if i create a recurrence appointment of a particular staff .The recurrence rule is as follows:
the staff has an appointment daily from 07 April 2011 to 15 April 2011.
Now when I come to dashboard & select the date as 20 April 2011 then I can the above created appointment,but when i change the date criteria to 21 April 2011 then there is no Record.So Ideally
I want to display the appointment of this particular staff till 30 April 2011 on My dashboard because i have created a recurrence appointment toll 30 April 2011
Urgent Help needed
Posted 11 Apr 2011
Link to this post
I have a schedular which is used to store the staff appointment details.
I also have a dashboard module which has a grid view control to show all the appointments based on the date criteria given on dashboard.meaning if the date selected is 20 March 2011 ,then show all the appointments on the dashbaord which is Scheduled on 20 March 2011.
When a new appointment is created then its appoiintment is stored in a table named "AppointmentSchedular".If the appointment is a recursive appointment then the recursive information is stored in RECDATA field of the AppointmentSchedular table as Follows.
DTSTART:20110411T063000Z DTEND:20110411T073000Z RRULE:FREQ=WEEKLY;UNTIL=20110419T000000Z;INTERVAL=1;BYDAY=MO
What i want is when a new appointment is created which is recursive,then I need to show the recursive appointment on the grid view on Dashbaord Page.
Eg:I created a recursive appointment of a staff on 11 April 2011. The Appointment is Daily basis till 15 April 2011.
So now what i need is, to show this particular appointment from 11 April 2011 to 15 April 2011 on the dashboard.
Urgent Help Needed...