Drawhtmlfunction

Function Definitions

drawHtmlCal

RETURN fintlbx.ARRAY_ATTACHMENTS

Parameters

Parameter Name evnts Direction IN DataType cal_events Description Ordered list of Events that will build out the calendars Title to be displayed at the top of the calendar Determines whether to show a clickable checkbox per event.

title

IN

VARCHAR2

chkboxs

IN

INTEGER

Overview

This function will build an HTML file to display events in a calendar. The events MUST be ordered ascending for this function to work properly. Users will receive an HTML calendar month for months that have an event in evnts . At this time, up to 5 different event types are supported.

Examples:

source data: Date Text Class

18-FEB-14 19-FEB-14 20-FEB-14 21-FEB-14 22-FEB-14

Event 1 Event 2 Event 3 Event 4 Event 5

Cls 1 Cls 2 Cls 3 Cls 4 Cls 5

DECLARE evnts fintlbx.cal_events; calendars fintlbx.array_attachments := fintlbx.array_attachments(); CURSOR cur_events IS SELECT class, date, text from dummydate ORDER BY date; BEGIN OPEN cur_events; FETCH cur_events BULK COLLECT INTO evnts; CLOSE cur_events; --calendars := fintlbx.drawHtmlCal(evnts); -- Default Title without checkboxes calendars := fintlbx.drawHtmlCal(evnts,'Stacked Edit Demo',1); -- Custom Title with checkboxes. --Now email the calendars out fintlbx.send_mail('email1@temple.edu','noreply@temple.edu',null,null,'Calendar Test','Test Body',null,calendars); END;

The above code will render:

Data Types

fintlbx.attach_info

TYPE attach_info IS RECORD ( attach_name data_type lain', attach_content ); CLOB DEFAULT '' VARCHAR2(255), VARCHAR2(40) DEFAULT 'text/p

fintlbx.array_attachments

TYPE array_attachments IS TABLE OF attach_info;

Het einde

Written with StackEdit. Written by Snyder (tua15282).