Index: openacs-4/packages/calendar/www/views-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/Attic/views-oracle.xql,v
diff -u -N
--- openacs-4/packages/calendar/www/views-oracle.xql	8 Sep 2008 20:13:37 -0000	1.8
+++ /dev/null	1 Jan 1970 00:00:00 -0000
@@ -1,118 +0,0 @@
-<?xml version="1.0"?>
-
-<queryset>
-   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
-
-<fullquery name="select_items">
-  <querytext>
-    select /*+ ORDERED */ 
-         to_char(start_date, 'YYYY-MM-DD HH24:MI:SS') as ansi_start_date,
-         to_char(end_date, 'YYYY-MM-DD HH24:MI:SS') as ansi_end_date,
-         to_number(to_char(start_date,'HH24'),'90') as start_hour,
-         to_number(to_char(start_date,'MI'),'90') as start_minutes,
-         to_number(to_char(start_date,'SSSSS'),'99990') as start_seconds,
-         to_number(to_char(end_date,'HH24'),'90') as end_hour,
-         to_number(to_char(end_date,'MI'),'90') as end_minutes,
-         to_number(to_char(end_date,'SSSSS'),'99990') as end_seconds,
-         nvl(e.name, a.name) as name,
-         nvl(e.status_summary, a.status_summary) as status_summary,
-         nvl(e.description, a.description) as description,
-         e.event_id as item_id,
-         (select type from cal_item_types where item_type_id= ci.item_type_id) as item_type,
-	 cals.calendar_id,
-	 cals.calendar_name,
-         cals.package_id as cal_package_id,
-         (select count(1) from attachments where object_id=e.event_id) as num_attachments
-         $additional_select_clause
-    from cal_items ci,
-         acs_events e,
-         timespans s,
-         time_intervals t,
-         acs_activities a,
-         calendars cals
-    where    e.timespan_id = s.timespan_id
-    and      s.interval_id = t.interval_id
-    and      e.activity_id = a.activity_id
-    and      start_date between $interval_limitation_clause
-    and      ci.cal_item_id = e.event_id
-    and      cals.calendar_id = ci.on_which_calendar
-    and      e.event_id = ci.cal_item_id
-    $additional_limitations_clause
-    $calendars_clause
-    $order_by_clause
-  </querytext>
-</fullquery>
-
-<fullquery name="select_all_day_items">
-  <querytext>
-    select 
-         to_char(start_date, 'YYYY-MM-DD HH24:MI:SS') as ansi_start_date,
-         to_char(end_date, 'YYYY-MM-DD HH24:MI:SS') as ansi_end_date,
-         to_number(to_char(start_date,'HH24'),'90') as start_hour,
-         to_number(to_char(end_date,'HH24'),'90') as end_hour,
-         to_number(to_char(end_date,'MI'),'90') as end_minutes,
-         nvl(e.name, a.name) as name,
-         nvl(e.status_summary, a.status_summary) as status_summary,
-         nvl(e.description, a.description) as description,
-         e.event_id as item_id,
-         (select type from cal_item_types where item_type_id= ci.item_type_id) as item_type,
-	 cals.calendar_id,
-	 cals.calendar_name,
-         cals.package_id as cal_package_id,
-         (select count(1) from attachments where object_id=e.event_id) as num_attachments
-         $additional_select_clause
-    from cal_items ci,
-         acs_events e,
-         timespans s,
-         time_intervals t,
-         acs_activities a,
-         calendars cals
-    where    e.timespan_id = s.timespan_id
-    and      s.interval_id = t.interval_id
-    and      e.activity_id = a.activity_id
-    and      start_date between $interval_limitation_clause
-    and      ci.cal_item_id = e.event_id
-    and      cals.calendar_id = ci.on_which_calendar
-    and      e.event_id = ci.cal_item_id
-    $additional_limitations_clause
-    $calendars_clause
-    $order_by_clause
-  </querytext>
-</fullquery>
-	
-<fullquery name="select_day_info">      
-  <querytext>
-    select  to_char(to_date(:current_date, 'yyyy-mm-dd'), 'Day, DD Month YYYY') as day_of_the_week,
-            to_char((to_date(:current_date, 'yyyy-mm-dd') - 1), 'yyyy-mm-dd') as yesterday,
-            to_char((to_date(:current_date, 'yyyy-mm-dd') + 1), 'yyyy-mm-dd') as tomorrow
-    from dual
-  </querytext>
-</fullquery>
-
-<partialquery name="day_interval_limitation">      
-  <querytext>
-    to_date(:current_date,'YYYY-MM-DD') 
-    and (to_date(:current_date,'YYYY-MM-DD') + (24 - 1/3600)/24)
-  </querytext>
-</partialquery>
-
-<partialquery name="week_interval_limitation">      
-  <querytext>
- to_date(:first_weekday_of_the_week_tz, 'YYYY-MM-DD HH24:MI:SS') and to_date(:last_weekday_of_the_week_tz, 'YYYY-MM-DD HH24:MI:SS')
-  </querytext>
-</partialquery>
-
-<partialquery name="month_interval_limitation">      
-  <querytext>
-    to_date(:first_date_of_month_system,'YYYY-MM-DD HH24:MI:SS') 
-    and to_date(:last_date_in_month_system, 'YYYY-MM-DD HH24:MI:SS')
-  </querytext>
-</partialquery>
-
-<partialquery name="list_interval_limitation">      
-  <querytext>
-    to_date(:start_date,'YYYY-MM-DD HH24:MI:SS')  and      to_date(:end_date, 'YYYY-MM-DD HH24:MI:SS')
-  </querytext>
-</partialquery>
-
-</queryset>