Displays a calendar or schedule.
This calendar type has time-intervals and custom resource values as column headings.
You can use the calendar setting Show checkboxes to enable checkboxes on a menu item.
The calendar menu item can pass the ids of its selected calendar items, for historical reasons commonly referred to as selecteditems via links from the calendar to other menu items. These menu items then access these ids as a comma-separated string.
Checkboxes use the values from the first calendar item column as calendar item ids. Calendar item ids must be unique unless they are NULL. Any calendar item with NULL in the first column will not show a checkbox.
The calendar item ids that you access through selecteditems are ID values of calendar items that were valid when the user loaded the calendar. No validation is performed to ensure that the ID values are still valid, that their calendar items would still be visible if the user reloads the calendar.
For example, you have a calendar of meetings and a top-link "Postpone all checked meetings by one month". The user checks a few calendar items and then clicks the top link. Now, the checked meetings are postponed , and their calendar items will no longer appear in the calendar, but the calendar still remembers the IDs of the checked calendar items. If the user checks a few more calendar items and clicks the top link again then the Postpone-menuitem will receive both the IDs of the meetings already postponed and the new IDs. You can avoid this by using the execute component's special column
admin_unselectall to clear all checkboxes.
SQL for retrieving the resources for the calendar. The resources of the first result set are displayed as calendar resources, i.e. as columns in the calendar. Resources of subsequent result sets are displayed as dropdown resources on top of the calendar.
SQL for retrieving extra information for the calendar resources. The extra information is displayed directly below the calendar resource headings. It is also possible to specify if a day is a holiday.
Sql for retrieving the calendar items to display in the calendar.
Called after every drag & drop operation.
Called after every resize operation.
Allows you to validate the parameters supplied by the user before any other SQL is run in the component. This call is only made if the component has visible parameters, the SQL is a stored procedure, and 'Validate parameters' is checked.
SQL that can have several resultsets that are displayed at top of component.
|boolean checkbox||Legacy alias. Use "checkbox" instead.|
|heading with checkbox|
|textbox with autosearch|
|textbox with autosuggest|
|textbox with dropdown|
|textbox with popup|
|Default||Inherit layout from menu item.|
|LabelAbove||Full width, label above.|
|LabelLeft||Label to the left.|
|NoLabel||Full width, no label.|
|Standard||Deprecated. Use LabelLeft instead.|
|Current||This is the current step.|
|Done||This step has been completed successfully.|
|Failed||Something went wrong in this step.|
|Future||This step is later on in the process.|
Use this call to restrict which entries a user is allowed to view and edit, and to log which entries a user views.
Access to a menu item is normally controlled through functions and roles alone but some entities need more fine grained control. For example, a user may have access to the View Member menu item for normal members but not for members with a protected identity.
The menu items a user visits are always logged (in ADMINLogMenuItem) but for sensitive data you may need to log exactly what entries are viewed. Do the logging in this call as the common ways of viewing data (grid and InfoSQL) are not allowed to modify the database.
If you bind a scalar function instead of a stored procedure to this call then its name must end with '_GrantAccess'.
CREATE OR ALTER PROCEDURE Example.Entity_ResourceCalendar @FromDate date = NULL, @ToDate date = NULL, @ExtraInfo bit = NULL, @Resources bit = NULL AS BEGIN IF @Resources = 1 BEGIN SELECT RoomId, RoomName FROM Example.Room; SELECT 'Room' AS ResourceLabel; RETURN; END; IF @ExtraInfo = 1 BEGIN RETURN; END; SELECT RoomId AS CalendarItemResourceId, CalendarItemTimeFrom, CalendarItemTimeTo, CalendarItemHeading, CalendarItemText FROM Example.CalendarItems WHERE (CONVERT(date, CalendarItemTimeFrom) <= @ToDate) AND (CONVERT(date, CalendarItemTimeTo) >= @FromDate); END;