Index: openacs-4/packages/attendance/lib/cp-attendance.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/attendance/lib/cp-attendance.tcl,v diff -u -r1.1 -r1.2 --- openacs-4/packages/attendance/lib/cp-attendance.tcl 9 Jun 2005 05:54:37 -0000 1.1 +++ openacs-4/packages/attendance/lib/cp-attendance.tcl 19 Jun 2005 06:05:05 -0000 1.2 @@ -1,9 +1,14 @@ -set current_url [ad_conn url] +set current_url [ad_conn url]?[ad_conn query] -set package_id [ad_conn package_id] -set community_id [dotlrn_community::get_community_id] +if {![info exists package_id]} { + set package_id [ad_conn package_id] +} +if {![info exists community_id]} { + set community_id [dotlrn_community::get_community_id] +} + set attendance_package_id [db_string "getattpack" "select object_id from acs_objects a, apm_packages b where a.object_id = b.package_id and a.context_id = :package_id and b.package_key = 'attendance';"] set attendance_url [apm_package_url_from_id $attendance_package_id] @@ -29,16 +34,21 @@ -key task_id \ -no_data "No sessions" \ -elements { - task_name { - label "Session" - } - action { - label "Actions" - display_template { Edit | Mark Attendance } - } + task_name { + label "Session" } + date_time { + label "Date and Time" + } + action { + label "Actions" + html "nowrap" + display_template { Edit | Attendance } + } + } -db_multirow -extend {cal_item_id} session_list get_sessions { + +db_multirow -extend {cal_item_id date_time} session_list get_sessions { select et.task_name, et.number_of_members, et.task_id, et.grade_item_id, to_char(et.due_date,'YYYY-MM-DD HH24:MI:SS') as due_date_ansi, et.online_p, @@ -62,5 +72,14 @@ and cri.live_revision = et.task_id and et.mime_type = crmt.mime_type } { - set cal_item_id [db_string "getcalid" "select cal_item_id from evaluation_cal_task_map where task_item_id=:item_id"] + set cal_item_id [db_string "getcalid" "select cal_item_id from evaluation_cal_task_map where task_item_id=:item_id"] + set date_time [db_string datetime { + select to_char(start_date, 'Mon dd, yyyy hh:miam-')||to_char(end_date, 'hh:miam') + from cal_items ci, acs_events e, acs_activities a, timespans s, time_intervals t + where e.timespan_id = s.timespan_id + and s.interval_id = t.interval_id + and e.activity_id = a.activity_id + and e.event_id = ci.cal_item_id + and ci.cal_item_id = :cal_item_id + } -default ""] } \ No newline at end of file