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 -r1.1 -r1.2
--- openacs-4/packages/calendar/www/cal-weekview-oracle.xql	24 Aug 2001 01:47:36 -0000	1.1
+++ openacs-4/packages/calendar/www/cal-weekview-oracle.xql	23 Sep 2001 15:12:41 -0000	1.2
@@ -18,4 +18,62 @@
 </fullquery>
 
  
+<fullquery name="get_day_items">      
+      <querytext>
+      
+select   to_char(start_date, 'J') as start_date,
+         to_char(start_date, 'HH24:MI') as pretty_start_date,
+         to_char(end_date, 'HH24:MI') as pretty_end_date,
+         nvl(e.name, a.name) as name,
+         e.event_id as item_id
+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      start_date between
+         to_date(:sunday_of_the_week,'YYYY-MM-DD') and
+         to_date(:saturday_of_the_week,'YYYY-MM-DD')
+and      e.event_id
+in       (
+         select  cal_item_id
+         from    cal_items
+         where   on_which_calendar = :calendar_id
+         )
+
+      </querytext>
+</fullquery>
+
+ 
+<fullquery name="get_day_items">      
+      <querytext>
+      
+select   to_char(start_date, 'J') as start_date,
+         to_char(start_date, 'HH24:MI') as pretty_start_date,
+         to_char(end_date, 'HH24:MI') as pretty_end_date,
+         nvl(e.name, a.name) as name,
+         e.event_id as item_id
+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      start_date between
+         to_date(:sunday_of_the_week,'YYYY-MM-DD') and
+         to_date(:saturday_of_the_week,'YYYY-MM-DD')
+and      e.event_id
+in       (
+         select  cal_item_id
+         from    cal_items
+         where   on_which_calendar = :calendar_id
+         )
+
+      </querytext>
+</fullquery>
+
+ 
 </queryset>