Databases Reference
In-Depth Information
type: 'POST',
url: 'wwv flow.show',
data: {
p flow id: $('#pFlowId').val(),
p flow step id: $('#pFlowStepId').val(),
p instance: $('#pInstance').val(),
p request: 'PLUGIN=' + uiw.options.ajaxIdentifier,
x01: $.fullCalendar.formatDate(start, 'yyyyMMdd'),
x02: $.fullCalendar.formatDate(end, 'yyyyMMdd')
},
dateType: 'json',
async: false,
success: function(data) {
callback(data);
uiw.element.trigger('apexafterrefresh');
}
});
}
});
})(apex.jQuery);
At this point you should be ready to test the plug-in. For the source of the region, enter a query like
the following:
SELECT id AS id,
title AS title,
'TRUE' 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,
NULL AS class name
FROM events
Because FullCalendar has so many options, this is a great plug-in to customize to better meet your
needs.
Listing 11-6.
PL/SQL Code for the Calendar Plug-in
FUNCTION calendar render (
p region IN APEX PLUGIN.T REGION,
p plugin IN APEX PLUGIN.T PLUGIN,
p is printer friendly IN BOOLEAN
)
RETURN APEX PLUGIN.T REGION RENDER RESULT
IS
l retval APEX PLUGIN.T REGION RENDER RESULT;
l onload code VARCHAR2(4000);
l jqueryui theme VARCHAR2(30) := p plugin.attribute 01;
l crlf CHAR(2) := CHR(13)||CHR(10);
