Index: openacs-4/contrib/packages/simulation/www/siminst/index.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/simulation/www/siminst/Attic/index.tcl,v diff -u -N -r1.26 -r1.27 --- openacs-4/contrib/packages/simulation/www/siminst/index.tcl 7 Jan 2004 12:22:40 -0000 1.26 +++ openacs-4/contrib/packages/simulation/www/siminst/index.tcl 7 Jan 2004 14:46:04 -0000 1.27 @@ -25,7 +25,7 @@ sub_class narrow link_url_eval {[export_vars -base wizard { workflow_id }]} display_template { - Edit + Edit } } pretty_name { @@ -44,14 +44,14 @@ copy { sub_class narrow display_template { - Copy + Copy } } delete { sub_class narrow link_url_col delete_url display_template { - Delete + Delete } } } @@ -125,33 +125,47 @@ -multirow casting_sims \ -no_data "No Simulations are in Casting" \ -elements { + edit { + sub_class narrow + link_url_eval {[export_vars -base wizard { workflow_id }]} + display_template { + Edit + } + } pretty_name { label "Simulation" orderby upper(w.pretty_name) + link_url_eval {[export_vars -base wizard { workflow_id }]} } n_users { label "Users enrolled" html { align center } } + n_cases { + label "Cases" + html { align center } + } case_start { label "Start date" } start_now { + label "Start" + sub_class narrow display_template { Start immediately } } copy { sub_class narrow display_template { - Copy + Copy } } delete { sub_class narrow link_url_col delete_url display_template { - Edit + Edit } } } @@ -163,18 +177,21 @@ set sim_in_dev_filter_sql "and ao.creation_user = :user_id" } -db_multirow -extend { delete_url start_url } casting_sims select_casting_sims " +db_multirow -extend { edit_url delete_url start_url } casting_sims select_casting_sims " select w.workflow_id, w.pretty_name, - (select count(*) + (select count(distinct u.user_id) from sim_party_sim_map spsm, party_approved_member_map pamm, users u where spsm.simulation_id = w.workflow_id - and spsm.type = 'auto_enroll' + and spsm.type in ('auto_enroll', 'enrolled') and spsm.party_id = pamm.party_id and pamm.member_id = u.user_id) as n_users, - to_char(ss.case_start, 'YYYY-MM-DD') as case_start + to_char(ss.case_start, 'YYYY-MM-DD') as case_start, + (select count(*) + from workflow_cases c + where c.workflow_id = w.workflow_id) as n_cases from workflows w, sim_simulations ss, acs_objects ao @@ -186,4 +203,7 @@ " { set delete_url [export_vars -base "${base_url}siminst/simulation-delete" { workflow_id }] set start_url [export_vars -base "simulation-start" { workflow_id }] + + set n_users [lc_numeric $n_users] + set n_cases [lc_numeric $n_cases] }