iSeller Commerce
iSeller POS Retail
iSeller POS F&B
iSeller POS Express
Crosslight
WebUI
ClientUI
What's New
Download Trial
Web Solution
Mobile Solution
Enterprise Solution
Custom Development
Blog
Community
Latest Development Blogs
ForumPostTopic
Browse By Tag
Hi,
My application allow user to key in holiday, so have a table to store the holiday records.
Then the system will insert records into ttRecurringEvent and ttRecurrenceInfo table for scheduling. When inserting records, system will check agains the Holiday table, when the recurrence activity fall on the holiday, i would like to make an exception and skip that day, eg:
Recurring event: 1/1/2010 - 30/9/2010
Recurring Day: Every Tuesday
Holiday entered by user: 31/8/2010 which is Tuesday
So i need the activity to be scheduled on every Tuesday from 1/1/2010 - 30/9/2010 except on 31/8/2010 which is holiday.
I understood that in WebScheduler we can do exception by putting it as exception and arrange the schedule on another date.
But in my case, i don't need to have exception on another date, instead i need exception to skip that date.
Pls advise!
Thanks!
I have discussed this issue with the developer and unfortunately, we do not have a workaround for the TotalRecurrence issue. Using the workaround from the previous post the TotalRecurence will not account for the holidays and the total event displayed will be less than the TotalRecurrence pattern.
Regarding holidays from external database, you will need to buffer the list in a HTML hidden input and match the holiday list with the event start time during the OnEventBound client side event handler. There is no workaround to hide the individual recuring event from the server.
Unfrotunately such scenario has not been supported by WebScheduler.
However, after discussing this issue with the developer, a workaround would be to hide the event which shown in the holiday date. This could be achieved using OnEventBound client side event handler by comparing the event date and holidays, if it match set the css style of the event so the event will be hidden. Here is the snippet:
function WebScheduler1_OnEventBound(controlId, evt){ var sched = ISGetObject(controlId); var evtDay = [evt.StartTime.getDate(), evt.StartTime.getDay(), evt.StartTime.getFullYear()].join("/"); for (var i = 0; i < sched.Holidays.length; i++) { var hDate = sched.Holidays[i].Date; var hDateStr = [hDate.getDate(), hDate.getDay(), hDate.getFullYear()].join("/"); if (evtDay == hDateStr) { evt.Element.style.display = "none"; } }}
If we just hide the event as suggested, the schedule will not be correct.Let say my TotalRecurrence = 10, then 1 of the day fall on the holiday.
It's still scheduled, but it's hide during displayed, so the schedule displayed will be 9 recurrence not 10, which is incorrect
Another issue will be, my users are from different institution.Let say i have 10 institution, then my system will have 10 database, so each institute will have their own holiday, be it public holiday or institute holiday, so i cannot insert the holiday at application level.Let say 5 institue login at the same time, then system will bind all holidays from 5 institute to the same application, then 5 institue will c the same holiday, which is incorrectPls advise!
or
Choose this if you're already a member of Intersoft Community Forum. You can link your OpenID account to your existing Intersoft Social ID.
Choose this if you don't have an Intersoft account yet. Your authenticated OpenID will be automatically linked to your new Intersoft account.
Enter your Wordpress Blogname