Index: openacs-4/contrib/packages/survey/survey.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/survey/Attic/survey.info,v
diff -u -r1.3.2.2 -r1.3.2.3
--- openacs-4/contrib/packages/survey/survey.info 2 Sep 2004 15:17:46 -0000 1.3.2.2
+++ openacs-4/contrib/packages/survey/survey.info 21 Oct 2004 07:46:08 -0000 1.3.2.3
@@ -7,17 +7,17 @@
f
f
-
+
Dave Bauer
Luke Pond
Malte Sussdorff
New version of survey package for dotLRN/OpenACS 5.0
dotLRN
New version of survey package for dotLRN/OpenACS 5.0. This version supports branching and sections, uses ad_form templates but so far is not internationalized. Upgrade scripts are available for Oracle only (at the moment).
-
+
-
+ 1
Index: openacs-4/contrib/packages/survey/catalog/survey.de_DE.ISO-8859-1.xml
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/survey/catalog/Attic/survey.de_DE.ISO-8859-1.xml,v
diff -u -r1.1 -r1.1.2.1
--- openacs-4/contrib/packages/survey/catalog/survey.de_DE.ISO-8859-1.xml 14 Feb 2004 14:04:54 -0000 1.1
+++ openacs-4/contrib/packages/survey/catalog/survey.de_DE.ISO-8859-1.xml 21 Oct 2004 07:46:12 -0000 1.1.2.1
@@ -1,8 +1,9 @@
-
+
Erstellt von
am %creation_date%
+ Auszuf�hrende Aktion
Aktionen
Aktiviert?
Neue Frage hinzuf�gen
@@ -56,13 +57,15 @@
E-Mail-Optionen:
Aktivieren
Nachricht eingeben
+ TCL-Code ausf�hren
Aktionen:
Dateianhang
Vorname
Zugeh�rige Evaluation:
Zugeh�rige Evaluation
Allgemeine Evaluation
Teilnehmer
+ Antworten importieren
[Deaktiviert]
Ganze_Zahl
ist
@@ -188,6 +191,7 @@
Keine aktivierten Evaluationen vorhanden
nicht
Nicht gefunden
+ Nichts
Zahl
Einzelner Teilnehmer
Eine R�ckantwort
@@ -213,6 +217,7 @@
Zur�ck
Ergebnis
Bewertete Evaluation
+ Sektionierung
Gruppen-E-Mail senden
E-Mail senden
E-Mail senden an
@@ -233,6 +238,7 @@
Richtig oder Falsch
Richtig/Falsch
Zul�ssige Werte
+ Eintrag in der Datenbank �ndern
Hochgeladene Datei:
Anzeigen
R�ckantwort anzeigen
Index: openacs-4/contrib/packages/survey/catalog/survey.en_US.ISO-8859-1.xml
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/survey/catalog/Attic/survey.en_US.ISO-8859-1.xml,v
diff -u -r1.7 -r1.7.2.1
--- openacs-4/contrib/packages/survey/catalog/survey.en_US.ISO-8859-1.xml 12 Mar 2004 07:18:13 -0000 1.7
+++ openacs-4/contrib/packages/survey/catalog/survey.en_US.ISO-8859-1.xml 21 Oct 2004 07:46:12 -0000 1.7.2.1
@@ -1,5 +1,5 @@
-
+
-- Please Choose --
- Created by
@@ -16,6 +16,7 @@
Add one
Admin This Survey
allow multiple
+ Allow "other" field
Answer Survey
Answer Text
Apply
@@ -30,6 +31,7 @@
By user
Change
Checkboxes
+ Checkboxes with text
choice
Choose a Survey Type
Choose Survey Type
@@ -193,8 +195,11 @@
Modify previous response
Modify Question Responses
Multiple Choice (Checkbox, multiple answers allowed)
+ Multiple Choice (Checkboxes, multiple answer, with text)
Multiple Choice (Drop Down, single answer allowed)
+ Multiple Choice Select with text
Multiple Choice (Radio Buttons, single answer allowed)
+ Multiple Choice Radio with text
New Page after this section
No appropriate questions found
No file given for import!
@@ -385,6 +390,7 @@
Questions
radio
Radio buttons
+ Radio buttons with text
Red
Required?
Respondents
@@ -402,6 +408,7 @@
Section Name
Sectioning:
Select box
+ Select Box with text
Send bulk mail
Send bulk
mail
Index: openacs-4/contrib/packages/survey/sql/postgresql/survey-package-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/survey/sql/postgresql/Attic/survey-package-create.sql,v
diff -u -r1.2.2.3 -r1.2.2.4
--- openacs-4/contrib/packages/survey/sql/postgresql/survey-package-create.sql 2 Sep 2004 15:17:47 -0000 1.2.2.3
+++ openacs-4/contrib/packages/survey/sql/postgresql/survey-package-create.sql 21 Oct 2004 07:46:12 -0000 1.2.2.4
@@ -91,6 +91,10 @@
--Create a new survey with a pretty_id
+-- API for survey_section objects
+
+--Create a new survey with a pretty_id
+
create or replace function survey_section__new (integer,integer,varchar,text,boolean,integer,boolean,boolean,boolean,boolean,integer,integer,text)
returns integer as '
declare
@@ -164,72 +168,6 @@
end;' language 'plpgsql';
-create or replace function survey_section__remove (integer)
-returns integer as '
-declare
- remove_section_id alias for $1;
- v_question_row survey_questions%ROWTYPE;
-begin
- delete from survey_branches where section_id=remove_section_id;
- delete from survey_conditions where question_id in (select question_id from survey_questions where section_id=remove_section_id);
- for v_question_row in select question_id
- from survey_questions
- where section_id=remove_section_id
- loop
- PERFORM survey_question__remove(v_question_row.question_id);
- end loop;
-
- delete from survey_sections
- where section_id = remove_section_id;
-
- PERFORM acs_object__delete(remove_section_id);
-
- return 0;
-
-end;' language 'plpgsql';
-
--- API for predefined questions
-
-create or replace function survey_predefined_question__new (integer,text,varchar,varchar,varchar,varchar,boolean,varchar,varchar,text,varchar,varchar,varchar,integer,integer)
-returns integer as '
-declare
- new__predefined_question_id alias for $1; -- default null
- new__question_text alias for $2; -- default null
- new__abstract_data_type alias for $3; -- default null
- new__presentation_type alias for $4; -- default null
- new__presentation_options alias for $5; -- default null
- new__presentation_alignment alias for $6; -- default below
- new__question_html_p alias for $7; -- default f
- new__summary_type alias for $8;
- new__action_type alias for $9; -- default null
- new__tcl alias for $10; -- default null
- new__table_name alias for $11; -- default null
- new__column_name alias for $12; -- default null
- new__key_name alias for $13; -- default null
- new__creation_user alias for $14; -- default null
- new__context_id alias for $15; -- default null
- v_predefined_question_id survey_predefined_questions.predefined_question_id%TYPE;
-begin
- v_predefined_question_id := acs_object__new (
- new__predefined_question_id,
- ''survey_predefined_question'',
- now(),
- new__creation_user,
- null,
- new__context_id
- );
-
- insert into survey_predefined_questions
- (predefined_question_id,question_text,abstract_data_type,presentation_type,presentation_options,presentation_alignment,question_html_p,summary_type,action_type,tcl,table_name,column_name,key_name)
- values
- (v_predefined_question_id,new__question_text,new__abstract_data_type,new__presentation_type,new__presentation_options,new__presentation_alignment,new__question_html_p,new__summary_type,new__action_type,new__tcl,new__table_name,new__column_name,new__key_name);
-
- return v_predefined_question_id;
-
-end;' language 'plpgsql';
-
--- API for Survey questions
-
--API for a question with a pretty_id passed in.
create or replace function survey_question__new (integer,integer,integer,text,varchar,boolean,boolean,varchar,varchar,varchar,boolean,varchar,varchar,integer,integer,integer,text)
@@ -325,6 +263,73 @@
end;' language 'plpgsql';
+create or replace function survey_section__remove (integer)
+returns integer as '
+declare
+ remove_section_id alias for $1;
+ v_question_row survey_questions%ROWTYPE;
+begin
+ delete from survey_branches where section_id=remove_section_id;
+ delete from survey_conditions where question_id in (select question_id from survey_questions where section_id=remove_section_id);
+ for v_question_row in select question_id
+ from survey_questions
+ where section_id=remove_section_id
+ loop
+ PERFORM survey_question__remove(v_question_row.question_id);
+ end loop;
+
+ delete from survey_sections
+ where section_id = remove_section_id;
+
+ PERFORM acs_object__delete(remove_section_id);
+
+ return 0;
+
+end;' language 'plpgsql';
+
+-- API for predefined questions
+
+create or replace function survey_predefined_question__new (integer,text,varchar,varchar,varchar,varchar,boolean,varchar,varchar,text,varchar,varchar,varchar,integer,integer)
+returns integer as '
+declare
+ new__predefined_question_id alias for $1; -- default null
+ new__question_text alias for $2; -- default null
+ new__abstract_data_type alias for $3; -- default null
+ new__presentation_type alias for $4; -- default null
+ new__presentation_options alias for $5; -- default null
+ new__presentation_alignment alias for $6; -- default below
+ new__question_html_p alias for $7; -- default f
+ new__summary_type alias for $8;
+ new__action_type alias for $9; -- default null
+ new__tcl alias for $10; -- default null
+ new__table_name alias for $11; -- default null
+ new__column_name alias for $12; -- default null
+ new__key_name alias for $13; -- default null
+ new__creation_user alias for $14; -- default null
+ new__context_id alias for $15; -- default null
+ v_predefined_question_id survey_predefined_questions.predefined_question_id%TYPE;
+begin
+ v_predefined_question_id := acs_object__new (
+ new__predefined_question_id,
+ ''survey_predefined_question'',
+ now(),
+ new__creation_user,
+ null,
+ new__context_id
+ );
+
+ insert into survey_predefined_questions
+ (predefined_question_id,question_text,abstract_data_type,presentation_type,presentation_options,presentation_alignment,question_html_p,summary_type,action_type,tcl,table_name,column_name,key_name)
+ values
+ (v_predefined_question_id,new__question_text,new__abstract_data_type,new__presentation_type,new__presentation_options,new__presentation_alignment,new__question_html_p,new__summary_type,new__action_type,new__tcl,new__table_name,new__column_name,new__key_name);
+
+ return v_predefined_question_id;
+
+end;' language 'plpgsql';
+
+-- API for Survey questions
+
+
create or replace function survey_question__remove (integer)
returns integer as '
declare
@@ -346,8 +351,6 @@
end;' language 'plpgsql';
-
-
-- API for survey responses
create or replace function survey_response__new(integer,integer,varchar,boolean,integer,varchar,integer,integer)
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/contrib/packages/survey/sql/postgresql/upgrade/upgrade-0.6-0.7d1.sql'.
Fisheye: No comparison available. Pass `N' to diff?