Index: openacs-4/packages/lorsm/lib/user-lorsm.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lorsm/lib/user-lorsm.tcl,v
diff -u -r1.8 -r1.9
--- openacs-4/packages/lorsm/lib/user-lorsm.tcl 17 May 2005 17:03:39 -0000 1.8
+++ openacs-4/packages/lorsm/lib/user-lorsm.tcl 26 May 2005 18:17:04 -0000 1.9
@@ -26,6 +26,8 @@
label "[_ lorsm.Course_Name_1]"
display_template {@d_courses.course_url;noquote@}
html { width 70% }
+ link_url_col course_url
+ link_html {title "[_ lorsm.Access_Course]"}
}
subject {
label "[_ lorsm.Subject]"
@@ -56,19 +58,50 @@
db_multirow -extend { ims_md_id last_viewed total_item_count viewed_item_count viewed_percent course_url } -append d_courses select_d_courses { } {
set ims_md_id $man_id
if { [string eq $format_name "default"] } {
- set course_url "$course_name"
+
+ # micheles
+ set context [site_node::get_url_from_object_id -object_id $lorsm_instance_id]
+ if ([db_0or1row query "
+ select
+ cpr.man_id,
+ cpr.res_id,
+ case
+ when upper(scorm_type) = 'SCO' then 'delivery-scorm'
+ else 'delivery'
+ end as needscorte
+ from
+ ims_cp_resources cpr
+ where
+ cpr.man_id = :man_id
+ order by cpr.scorm_type desc limit 1"
+ ]) {
+
+ set delivery_method $needscorte
+ ns_log Debug "lorsm - $needscorte"
+
+ set course_url "$course_name"
+ ns_log Debug "lorsm - course_url: $course_url"
+ } else {
+ set course_url "NO RESOURCES ERROR"
+ }
} else {
- set course_url "$course_name"
+ set course_url "$course_name"
}
+
# DEDS: these are expensive
# and for demo purposes only
db_0or1row get_last_viewed { }
set all_items [db_list get_total_items { }]
set total_item_count [llength $all_items]
set viewed_items [db_list get_viewed_items { }]
set viewed_item_count [llength $viewed_items]
+
+ ns_log Debug "lorsm - viewed_item_count: $viewed_item_count"
+
set viewed_percent [expr [expr $viewed_item_count * 1.00] / $total_item_count * 100]
- }
+ ns_log Debug "lorsm - viewed_percent: $viewed_percent"
+ }
}
+