Index: openacs-4/packages/calendar/www/cal-item-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/Attic/cal-item-oracle.xql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/calendar/www/cal-item-oracle.xql 24 Aug 2001 01:47:36 -0000 1.1
@@ -0,0 +1,53 @@
+
+
+
+ oracle8.1.6
+
+
+
+
+ select to_char(start_date, 'MM/DD/YYYY') as start_date,
+ to_char(start_date, 'HH24:MI') as start_time,
+ to_char(end_date, 'HH24:MI') as end_time,
+ nvl(a. name, e.name) as name,
+ nvl(e.description, a.description) as description
+ from acs_activities a,
+ acs_events e,
+ timespans s,
+ time_intervals t
+ where e.timespan_id = s.timespan_id
+ and s.interval_id = t.interval_id
+ and e.activity_id = a.activity_id
+ and e.event_id = :cal_item_id
+
+
+
+
+
+
+
+
+
+ select object_id as calendar_id,
+ calendar.name(object_id) as calendar_name
+ from acs_permissions
+ where privilege in (
+ 'calendar_write',
+ 'calendar_admin'
+ )
+ and grantee_id = :user_id
+ and acs_object_util.object_type_p(
+ object_id,
+ 'calendar'
+ ) = 't'
+ and calendar.private_p(
+ object_id
+ ) = 'f'
+
+
+
+
+
+
+
+
Index: openacs-4/packages/calendar/www/cal-item-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/Attic/cal-item-postgresql.xql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/calendar/www/cal-item-postgresql.xql 24 Aug 2001 01:47:36 -0000 1.1
@@ -0,0 +1,53 @@
+
+
+
+ postgresql7.1
+
+
+
+
+ select to_char(start_date, 'MM/DD/YYYY') as start_date,
+ to_char(start_date, 'HH24:MI') as start_time,
+ to_char(end_date, 'HH24:MI') as end_time,
+ coalesce(a. name, e.name) as name,
+ coalesce(e.description, a.description) as description
+ from acs_activities a,
+ acs_events e,
+ timespans s,
+ time_intervals t
+ where e.timespan_id = s.timespan_id
+ and s.interval_id = t.interval_id
+ and e.activity_id = a.activity_id
+ and e.event_id = :cal_item_id
+
+
+
+
+
+
+
+
+
+ select object_id as calendar_id,
+ calendar__name(object_id) as calendar_name
+ from acs_permissions
+ where privilege in (
+ 'calendar_write',
+ 'calendar_admin'
+ )
+ and grantee_id = :user_id
+ and acs_object_util__object_type_p(
+ object_id,
+ 'calendar'
+ ) = 't'
+ and calendar__private_p(
+ object_id
+ ) = 'f'
+
+
+
+
+
+
+
+
Index: openacs-4/packages/calendar/www/cal-options-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/Attic/cal-options-oracle.xql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/calendar/www/cal-options-oracle.xql 24 Aug 2001 01:47:36 -0000 1.1
@@ -0,0 +1,33 @@
+
+
+
+ oracle8.1.6
+
+
+
+
+
+ select unique(calendar_id) as calendar_id,
+ calendar_name,
+ ' ' as checked_p
+ from calendars
+ where acs_permission.permission_p(calendar_id, :user_id, 'calendar_read') = 't'
+ and acs_permission.permission_p(calendar_id, :user_id, 'calendar_show') = 't'
+ and private_p = 'f'
+
+ union
+
+ select unique(on_which_calendar) as calendar_id,
+ calendar.name(on_which_calendar) as calendar_name,
+ ' ' as checked_p
+ from cal_items
+ where acs_permission.permission_p(cal_item_id, :user_id, 'cal_item_read') = 't'
+ and calendar.private_p(on_which_calendar) = 'f'
+
+
+
+
+
+
+
+
Index: openacs-4/packages/calendar/www/cal-options-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/Attic/cal-options-postgresql.xql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/calendar/www/cal-options-postgresql.xql 24 Aug 2001 01:47:36 -0000 1.1
@@ -0,0 +1,33 @@
+
+
+
+ postgresql7.1
+
+
+
+
+
+ select unique(calendar_id) as calendar_id,
+ calendar_name,
+ ' ' as checked_p
+ from calendars
+ where acs_permission__permission_p(calendar_id, :user_id, 'calendar_read') = 't'
+ and acs_permission__permission_p(calendar_id, :user_id, 'calendar_show') = 't'
+ and private_p = 'f'
+
+ union
+
+ select unique(on_which_calendar) as calendar_id,
+ calendar__name(on_which_calendar) as calendar_name,
+ ' ' as checked_p
+ from cal_items
+ where acs_permission__permission_p(cal_item_id, :user_id, 'cal_item_read') = 't'
+ and calendar__private_p(on_which_calendar) = 'f'
+
+
+
+
+
+
+
+
Index: openacs-4/packages/calendar/www/cal-weekview-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/Attic/cal-weekview-oracle.xql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/calendar/www/cal-weekview-oracle.xql 24 Aug 2001 01:47:36 -0000 1.1
@@ -0,0 +1,21 @@
+
+
+
+ oracle8.1.6
+
+
+
+
+select to_char(to_date(:current_date, 'yyyy-mm-dd'), 'D')
+as day_of_the_week,
+ to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')-7, 'SUNDAY'))
+as sunday_of_the_week,
+ to_char(next_day(to_date(:current_date, 'yyyy-mm-dd'), 'Saturday'))
+as saturday_of_the_week
+from dual
+
+
+
+
+
+
Index: openacs-4/packages/calendar/www/cal-weekview-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/Attic/cal-weekview-postgresql.xql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/calendar/www/cal-weekview-postgresql.xql 24 Aug 2001 01:47:36 -0000 1.1
@@ -0,0 +1,21 @@
+
+
+
+ postgresql7.1
+
+
+
+
+select to_char(to_date(:current_date, 'yyyy-mm-dd'), 'D')
+as day_of_the_week,
+ to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')-7, 'SUNDAY'))
+as sunday_of_the_week,
+ to_char(next_day(to_date(:current_date, 'yyyy-mm-dd'), 'Saturday'))
+as saturday_of_the_week
+from dual
+
+
+
+
+
+