Index: openacs-4/contrib/packages/project-manager/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/index-postgresql.xql,v
diff -u -r1.10 -r1.11
--- openacs-4/contrib/packages/project-manager/www/index-postgresql.xql	26 Jan 2004 15:39:40 -0000	1.10
+++ openacs-4/contrib/packages/project-manager/www/index-postgresql.xql	26 Feb 2004 15:15:41 -0000	1.11
@@ -5,7 +5,7 @@
 <fullquery name="project_folders">
     <querytext>
         SELECT
-        p.item_id,
+        p.item_id as project_item_id,
         p.project_id,
         p.parent_id as folder_id,
         p.object_type as content_type,
@@ -16,17 +16,36 @@
         p.ongoing_p,
         c.category_id,
         c.category_name,
+        p.earliest_finish_date - current_date as days_to_earliest_finish,
+        p.latest_finish_date - current_date as days_to_latest_finish,
         p.actual_hours_completed,
         p.estimated_hours_total,
         to_char(p.estimated_finish_date, 'MM/DD/YY') as estimated_finish_date,
         to_char(p.earliest_finish_date, 'MM/DD/YY') as earliest_finish_date,
         to_char(p.latest_finish_date, 'MM/DD/YY') as latest_finish_date,
-        o.name as customer_name
-        FROM pm_projectsx p LEFT JOIN organizations o ON p.customer_id = o.organization_id LEFT JOIN (select om.category_id, om.object_id, t.name as category_name from category_object_map om, category_translations t, categories ctg where om.category_id = t.category_id and ctg.category_id = t.category_id and ctg.deprecated_p = 'f') c ON p.item_id = c.object_id, 
+        case when o.name is null then '--no customer--' else o.name end as customer_name,
+        o.organization_id
+        FROM pm_projectsx p 
+             LEFT JOIN organizations o ON p.customer_id = o.organization_id 
+             LEFT JOIN (
+                        select 
+                        om.category_id, 
+                        om.object_id, 
+                        t.name as category_name 
+                        from 
+                        category_object_map om, 
+                        category_translations t, 
+                        categories ctg 
+                        where 
+                        om.category_id = t.category_id and 
+                        ctg.category_id = t.category_id and 
+                        ctg.deprecated_p = 'f')
+                 c ON p.item_id = c.object_id, 
         cr_items i, 
         pm_project_status s
-        WHERE p.project_id = i.live_revision and
-        s.status_id = p.status_id
+        WHERE 
+        p.project_id = i.live_revision and
+        s.status_id           = p.status_id
         [template::list::filter_where_clauses -and -name projects]
         [template::list::orderby_clause -orderby -name projects]
     </querytext>