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 {
-
+
}
}
pretty_name {
@@ -44,14 +44,14 @@
copy {
sub_class narrow
display_template {
-
+
}
}
delete {
sub_class narrow
link_url_col delete_url
display_template {
-
+
}
}
}
@@ -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 {
+
+ }
+ }
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 {
-
+
}
}
delete {
sub_class narrow
link_url_col delete_url
display_template {
-
+
}
}
}
@@ -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]
}