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?