Index: openacs-4/packages/evaluation/tcl/evaluation-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/tcl/evaluation-procs.tcl,v
diff -u -N -r1.31.2.3 -r1.31.2.4
--- openacs-4/packages/evaluation/tcl/evaluation-procs.tcl 16 Jun 2005 09:22:36 -0000 1.31.2.3
+++ openacs-4/packages/evaluation/tcl/evaluation-procs.tcl 16 Jun 2005 23:59:53 -0000 1.31.2.4
@@ -1236,8 +1236,45 @@
}
+namespace eval evaluation::merge {
+ ad_proc -callback MergeShowUserInfo -impl evaluation {
+ -user_id:required
+ } {
+ Show the evaluation items of user_id
+ } {
+ set msg "Evaluation items"
+ set result [list $msg]
+ ns_log Notice $msg
+
+ lappend result [list "Answers: [db_list sel_answers { *SQL* }] "]
+ lappend result [list "Evals: [db_list_of_lists sel_evals { *SQL* }] "]
+
+ return $result
+ }
+ ad_proc -callback MergePackageUser -impl evaluation {
+ -from_user_id:required
+ -to_user_id:required
+ } {
+ Merge the entries of two users.
+ The from_user_id is the user_id of the user
+ that will be deleted and all the items
+ of this user will be mapped to the to_user_id.
+ } {
+ set msg "Merging evaluation"
+ set result [list $msg]
+ ns_log Notice $msg
+
+ db_transaction {
+ db_dml upd_from_answers { *SQL* }
+ db_dml upd_from_stud_evals { *SQL* }
+ }
+
+ lappend result "Evaluation merge is done"
+ }
+}
+
ad_register_proc GET /grades-sheet-csv* evaluation::generate_grades_sheet
-ad_register_proc POST /grades-sheet-csv* evaluation::generate_grades_sheet
+ad_register_proc POST /grades-sheet-csv* evaluation::generate_grades_sheet
\ No newline at end of file
Index: openacs-4/packages/evaluation/tcl/evaluation-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/tcl/evaluation-procs.xql,v
diff -u -N -r1.3.2.2 -r1.3.2.3
--- openacs-4/packages/evaluation/tcl/evaluation-procs.xql 8 Jun 2005 18:57:14 -0000 1.3.2.2
+++ openacs-4/packages/evaluation/tcl/evaluation-procs.xql 16 Jun 2005 23:59:53 -0000 1.3.2.3
@@ -222,7 +222,37 @@
where task_id=:task_id
-
-
+
+
+ select answer_id
+ from evaluation_answers
+ where party_id = :user_id
+
+
+
+
+
+ select evaluation_id, grade
+ from evaluation_student_evals
+ where party_id = :user_id
+
+
+
+
+
+ update evaluation_answers
+ set party_id = :to_user_id
+ where party_id = :from_user_id
+
+
+
+
+
+ update evaluation_student_evals
+ set party_id = :to_user_id
+ where party_id = :from_user_id
+
+
+