Index: openacs-4/contrib/packages/cop-ui/www/ratings/index.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/cop-ui/www/ratings/index.tcl,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/packages/cop-ui/www/ratings/index.tcl 28 Mar 2004 21:17:11 -0000 1.1
+++ openacs-4/contrib/packages/cop-ui/www/ratings/index.tcl 7 May 2004 17:25:40 -0000 1.2
@@ -32,7 +32,7 @@
}
object_title {
label {Item}
- display_template {@ratings.object_title@}
+ display_template {@ratings.object_title@}
}
}
@@ -61,12 +61,15 @@
owner_id {}
}
+set node_id [ad_conn node_id]
+set packages [cop::util::packages -node_id $node_id]
set icons [cop::rating::icon_base]
db_multirow -extend {rating_img object_ratings_url rating} ratings ratings "
- SELECT r.rating_ave, to_char(r.rated_on,'YYYY-MM-DD HH24:MI') as rated_on, o.title as object_title, r.object_one, r.ratings, r.rating_sum, r.rating_ave
+ SELECT o.object_id,r.rating_ave, to_char(r.rated_on,'YYYY-MM-DD HH24:MI') as rated_on, o.title as object_title, r.object_one, r.ratings, r.rating_sum, r.rating_ave
FROM cop_rating_aggregates r, acs_objects o
WHERE o.object_id = r.object_one
+ and o.package_id in ([join $packages ,])
[template::list::orderby_clause -orderby -name "ratings"]" {
set rating [format %.1f [expr {(round(2.0*$rating_ave))/2.0}]]
set rating_img "
"