Calendar

Bootstrap FullCalendar Plugin
 
Plug-in Help:

Tne Bootstrap FullCalendar plugin offers some rich features with the ability to create events that span multiple days and the ability to easily create over hints for events are two of the most common requests we've heard. It's integration comes from the rich FullCalendar


FullCalendar is a jQuery Based library that generates a calendar with a robust set of features, including support for multi-day events. Above is an example calendar region based on the Bootstrap FullCalendar APEX plugin.
Features include:

Cookies

It gives you the ablility to view (Day, Week, Month) of the calendar it last displayed.
Also which date on the calendar was last displayed,It redisplays the same after having navigating away and back to the calendar.

Navigate to Shared Components > Plug-ins and click Import >.
Follow the wizard to upload and install the plug-in using the file named region_type_plugin_nl_smart4apex_calendar_.sql which is included with theplug-in installation package.
If you are installing the plugin into APEX 4.1, after the plug-in has been installed successfully you will be redirected to the plug-in edit screen. When installing in to APEX 4.2, however, You will be taken to the Component Settings screen. Each will allow you to set the application level defaults for the plugin as seen below.

When using the Bootstrap FullCalendar region plugin, you'll be asked for a SQL statement which will provide the information about the individual events to be rendered on the calendar. Below is the format that the SQL statement must take.

SELECT
id
, title -- title to be shown in event
, all_day -- (valid values 'true' or 'false')
, start_date -- must be of the format 'YYYY-MM-DD"T"HH24:MI:SS'
, end_date -- must be of the format 'YYYY-MM-DD"T"HH24:MI:SS'
, url -- APEX URL Format
, event_color -- Color of this specific Event
, description -- Description
FROM TABLE

Below is an example of a query using the required columns as well as their order. All columns required but may be "NULL":

SELECT
id
title AS title,
'false' AS all_day,
TO_CHAR(start_date, 'YYYY-MM-DD"T"HH24:MI:SS') AS start_date,
TO_CHAR(end_date, 'YYYY-MM-DD"T"HH24:MI:SS') AS end_date,
NULL AS url,
'blue' as event_color
description
FROM EVENTS

The Region Attributes for the Smart4Apex Bootstrap FullCalendar region are as follows:

Calendar Width (px) - Enter the width of the calendar in pixels.
If you leave this value null, the calendar will automatically expand to fill the space given.

Calendar Width (px) - Enter the height of the calendar in pixels. If you leave this value null, the calendar will automatically expand to fill the space given.

Header: Left - Dictates the content of the left section of the calendar header.
Options are:

  • Navigation - Renders the TODAY, NEXT & PREV buttons.
  • Title - Renders the Calendar MONTH, DAY & YEAR depending upon the View Type.
  • View Type - Renders MONTH, WEEK & DAY View selection buttons as appropriate.
  • None - Renders nothing in this region.
Header: Center - Dictates the content of the left section of the calendar header.
Options are:
  • Navigation - Renders the TODAY, NEXT & PREV buttons.
  • Title - Renders the Calendar MONTH, DAY & YEAR depending upon the View Type.
  • Type- Renders MONTH, WEEK & DAY View selection buttons as appropriate.
  • None - Renders nothing in this region.

Header: Right - Dictates the content of the left section of the calendar header. Options are:
  • Navigation - Renders the TODAY, NEXT & PREV buttons.
  • Title - Renders the Calendar MONTH, DAY & YEAR depending upon the View Type.
  • View Type - Renders MONTH, WEEK & DAY View selection buttons as appropriate.
  • None - Renders nothing in this region.
Prevent Href Click - Dictates whether to include an href tag for editing of the elements on a form( it could be a modal form or normal form ).
NB: It makes use of the iFrame Modal plugin to update pageitems on the modal form.

Include Alternatives - Dictates whether to inclue
  • Day - Renders the DAY View.
  • Week - Renders the WEEK the View.

First Day of Week - Dictates which day renders as the first day of the week in the Month and Week calendar views.