Index: openacs-4/packages/curriculum-central/www/coordinate/index.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/curriculum-central/www/coordinate/index.adp,v diff -u -r1.17 -r1.18 --- openacs-4/packages/curriculum-central/www/coordinate/index.adp 16 Jun 2006 02:21:04 -0000 1.17 +++ openacs-4/packages/curriculum-central/www/coordinate/index.adp 22 Jun 2006 08:27:12 -0000 1.18 @@ -15,13 +15,13 @@

#curriculum-central.uos_administration#

Index: openacs-4/packages/curriculum-central/www/coordinate/uos-all-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/curriculum-central/www/coordinate/uos-all-postgresql.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/curriculum-central/www/coordinate/uos-all-postgresql.xql 2 Feb 2006 11:52:15 -0000 1.1 +++ openacs-4/packages/curriculum-central/www/coordinate/uos-all-postgresql.xql 22 Jun 2006 08:27:12 -0000 1.2 @@ -20,4 +20,22 @@ + + + SELECT n.uos_code, n.uos_name, u.uos_id, u.unit_coordinator_id, + s.short_name, s.pretty_name + FROM cc_uos u, + cc_uos_name n, + workflow_cases c, + workflow_case_fsm f, + workflow_fsm_states s + WHERE c.case_id = f.case_id + AND s.state_id = f.current_state + AND c.workflow_id = :workflow_id + AND u.uos_id = c.object_id + AND u.unit_coordinator_id = :user_id + AND n.name_id = u.uos_name_id + + + Index: openacs-4/packages/curriculum-central/www/coordinate/uos-all.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/curriculum-central/www/coordinate/uos-all.tcl,v diff -u -r1.1 -r1.2 --- openacs-4/packages/curriculum-central/www/coordinate/uos-all.tcl 2 Feb 2006 11:52:15 -0000 1.1 +++ openacs-4/packages/curriculum-central/www/coordinate/uos-all.tcl 22 Jun 2006 08:27:12 -0000 1.2 @@ -44,9 +44,16 @@ -no_data "#curriculum-central.no_uos_have_been_created#" \ -elements $elements -db_multirow -extend {unit_coordinator} all_uos get_all_uos {} { - set unit_coordinator [curriculum_central::staff::pretty_name $unit_coordinator_id] +# If stream coordinator, then list all UoS, otherwise list all UoS that the +# user is the unit coordinator of. +if { [curriculum_central::staff::stream_coordinator_p $user_id] } { + db_multirow -extend {unit_coordinator} all_uos get_all_uos {} { + set unit_coordinator [curriculum_central::staff::pretty_name $unit_coordinator_id] + } +} else { + db_multirow -extend {unit_coordinator} all_uos get_all_uc_uos {} { + set unit_coordinator [curriculum_central::staff::pretty_name $unit_coordinator_id] + } } - ad_return_template