Index: openacs-4/packages/assessment/www/admin/send-mail-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/admin/Attic/send-mail-postgresql.xql,v
diff -u -N
--- openacs-4/packages/assessment/www/admin/send-mail-postgresql.xql	24 Jan 2005 14:54:31 -0000	1.1
+++ /dev/null	1 Jan 1970 00:00:00 -0000
@@ -1,148 +0,0 @@
-<?xml version="1.0"?>
-
-<queryset>
-   <rdbms><type>postgresql</type><version>7.1</version></rdbms>
-
-    <partialquery name="dotlrn_all">
-	<querytext>
-            select '[db_quote $sender_email]' as from_addr,
-               '[db_quote $sender_first_names]' as sender_first_names,
-               '[db_quote $sender_last_name]' as sender_last_name,
-               parties.email,
-	       (case acs_objects.object_type
-	       	     when 'user' then 
-                      (select first_names
-                       from persons
-                       where person_id = parties.party_id)
-		     when 'group' then
-                      (select group_name
-                       from groups
-                       where group_id = parties.party_id)
-		     when 'rel_segment' then
-                      (select segment_name
-                       from rel_segments
-                       where segment_id = parties.party_id)
-		     else '' end) as first_names,
-	       (case acs_objects.object_type
-	       	     when 'user' then
-                      (select last_name
-                       from persons
-                       where person_id = parties.party_id)
-		     else '' end) as last_name,
-               '[db_quote $community_name]' as community_name,
-               '[db_quote $community_url]' as community_url
-            from party_approved_member_map,
-                 parties,
-                 acs_objects
-            where party_approved_member_map.party_id = $segment_id
-            and party_approved_member_map.member_id <> $segment_id
-            and party_approved_member_map.member_id = parties.party_id
-            and parties.party_id = acs_objects.object_id
-	</querytext>
-    </partialquery>
-
-    <partialquery name="dotlrn_responded">
-	<querytext>
- 		select '[db_quote $sender_email]' as from_addr,
-               '[db_quote $sender_first_names]' as sender_first_names,
-               '[db_quote $sender_last_name]' as sender_last_name,
-               parties.email,
-	       (case acs_objects.object_type
-	       	     when 'user' then 
-                      (select first_names
-                       from persons
-                       where person_id = parties.party_id)
-		     when 'group' then
-                      (select group_name
-                       from groups
-                       where group_id = parties.party_id)
-		     when 'rel_segment' then
-                      (select segment_name
-                       from rel_segments
-                       where segment_id = parties.party_id)
-		     else '' end) as first_names,
-	       (case acs_objects.object_type
-	       	     when 'user' then
-                      (select last_name
-                       from persons
-                       where person_id = parties.party_id)
-		     else '' end) as last_name,
-               '[db_quote $community_name]' as community_name,
-               '[db_quote $community_url]' as community_url
-            from party_approved_member_map,
-                 parties,
-                 acs_objects
-            where party_approved_member_map.party_id = $segment_id
-            and party_approved_member_map.member_id <> $segment_id
-            and party_approved_member_map.member_id = parties.party_id
-            and parties.party_id = acs_objects.object_id
-	    and parties.party_id in (
-		select s.subject_id
-		from as_sessions s, cr_revisions r
-		where s.assessment_id = r.revision_id
-		and s.completed_datetime is not null
-		and r.item_id = $assessment_id)
-	</querytext>
-    </partialquery>
-
-    <partialquery name="dotlrn_not_responded">
-	<querytext>
-		select '[db_quote $sender_email]' as from_addr,
-               '[db_quote $sender_first_names]' as sender_first_names,
-               '[db_quote $sender_last_name]' as sender_last_name,
-               parties.email,
-	       (case acs_objects.object_type
-	       	     when 'user' then 
-                      (select first_names
-                       from persons
-                       where person_id = parties.party_id)
-		     when 'group' then
-                      (select group_name
-                       from groups
-                       where group_id = parties.party_id)
-		     when 'rel_segment' then
-                      (select segment_name
-                       from rel_segments
-                       where segment_id = parties.party_id)
-		     else '' end) as first_names,
-	       (case acs_objects.object_type
-	       	     when 'user' then
-                      (select last_name
-                       from persons
-                       where person_id = parties.party_id)
-		     else '' end) as last_name,
-               '[db_quote $community_name]' as community_name,
-               '[db_quote $community_url]' as community_url
-            from party_approved_member_map,
-                 parties,
-                 acs_objects
-            where party_approved_member_map.party_id = $segment_id
-            and party_approved_member_map.member_id <> $segment_id
-            and party_approved_member_map.member_id = parties.party_id
-            and parties.party_id = acs_objects.object_id
-	    and parties.party_id not in (
-		select s.subject_id
-		from as_sessions s, cr_revisions r
-		where s.assessment_id = r.revision_id
-		and s.completed_datetime is not null
-		and r.item_id = $assessment_id)
-	</querytext>
-    </partialquery>
-
-    <partialquery name="responded">
-	<querytext>
- 		select '[db_quote $sender_email]' as from_addr,
-               '[db_quote $sender_first_names]' as sender_first_names,
-               '[db_quote $sender_last_name]' as sender_last_name,
-               parties.email
-            from parties
-            where parties.party_id in (
-		select s.subject_id
-		from as_sessions s, cr_revisions r
-		where s.assessment_id = r.revision_id
-		and s.completed_datetime is not null
-		and r.item_id = $assessment_id)
-	</querytext>
-    </partialquery>
-
-</queryset>