Index: openacs-4/packages/dotlrn-catalog/catalog/dotlrn-catalog.en_US.ISO-8859-1.xml =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-catalog/catalog/dotlrn-catalog.en_US.ISO-8859-1.xml,v diff -u -N -r1.4 -r1.5 --- openacs-4/packages/dotlrn-catalog/catalog/dotlrn-catalog.en_US.ISO-8859-1.xml 16 Feb 2005 15:28:32 -0000 1.4 +++ openacs-4/packages/dotlrn-catalog/catalog/dotlrn-catalog.en_US.ISO-8859-1.xml 16 Feb 2005 22:21:30 -0000 1.5 @@ -2,7 +2,9 @@ Add this course to one category. + Admin Manage Category Tree + Admin This Course and has Assessment Associate @@ -27,6 +29,7 @@ Your Course List Course Name: Courses + Create Create a new version of Delete Delete Course @@ -64,11 +67,15 @@ Not Associate Not Associated One Course Information - Permission: + Please type a keyword + Privilege on + Privilege on dotLRN-Catalog: Revision List Revisions Revoke Revoke Permissions + Search + Search Course Name with : search for entire email or just part of it search for one first name or last name. Search Users Index: openacs-4/packages/dotlrn-catalog/catalog/dotlrn-catalog.es_ES.ISO-8859-1.xml =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-catalog/catalog/dotlrn-catalog.es_ES.ISO-8859-1.xml,v diff -u -N -r1.2 -r1.3 --- openacs-4/packages/dotlrn-catalog/catalog/dotlrn-catalog.es_ES.ISO-8859-1.xml 16 Feb 2005 15:28:32 -0000 1.2 +++ openacs-4/packages/dotlrn-catalog/catalog/dotlrn-catalog.es_ES.ISO-8859-1.xml 16 Feb 2005 22:21:30 -0000 1.3 @@ -2,7 +2,9 @@ Agregar este curso a una categoria. + Administrador Administrar Arbol de Categorias + Administrar Este Courso y tiene Assessment Asociar @@ -22,11 +24,12 @@ Administracion de Cursos Indice del Catalogo dotLRN Detalles del Curso - Informacion del Curso: + Descripcion: Llave del Curso: Su listado de Cursos Nombre del Curso: - Corsos + Cursos + Creacion Crear una nueva version de Borrar Borrar Cursos @@ -64,11 +67,15 @@ No Asociar No Asociado Informacion de un Curso - Permisos: + Ingrese una palabra + Privilegio sobre + Privilegio sobre dotLRN-Catalog: Listado de Revisiones Revisiones Remover Remover Permisos + Buscar + Buscar nombre del curso que contiene : buscar por direccion de correo electronico o parte de ella buscar por nombre o apellido. Busqueda de Usuarios Index: openacs-4/packages/dotlrn-catalog/lib/course-chunk.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-catalog/lib/course-chunk.adp,v diff -u -N -r1.4 -r1.5 --- openacs-4/packages/dotlrn-catalog/lib/course-chunk.adp 16 Feb 2005 15:28:32 -0000 1.4 +++ openacs-4/packages/dotlrn-catalog/lib/course-chunk.adp 16 Feb 2005 22:21:30 -0000 1.5 @@ -1,11 +1,17 @@ + + +
+ +
+
+

#dotlrn-catalog.info#:

@@ -96,7 +102,9 @@
-

#dotlrn-catalog.dotlrn_assoc#:

+ +

#dotlrn-catalog.dotlrn_assoc#:

+
Index: openacs-4/packages/dotlrn-catalog/lib/course-chunk.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-catalog/lib/course-chunk.tcl,v diff -u -N -r1.2 -r1.3 --- openacs-4/packages/dotlrn-catalog/lib/course-chunk.tcl 16 Feb 2005 00:22:12 -0000 1.2 +++ openacs-4/packages/dotlrn-catalog/lib/course-chunk.tcl 16 Feb 2005 22:21:30 -0000 1.3 @@ -12,6 +12,16 @@ set index "" } +if { ![info exists to_index] } { + set to_index "" +} + +if { [info exist return_url] } { + set return_url $return_url +} else { + set return_url "course-info?course_id=$course_id&course_name=$name&course_key=$course_key" +} + if { ![info exists asmid] } { set asmid "-1" } @@ -30,6 +40,16 @@ # Get the category name set category_name "[category::get_name [category::get_mapped_categories $course_id]]" +# Check if user has admin permission over course_id +if { [permission::permission_p -object_id $cc_package_id -privilege "create"] } { + set item_id [dotlrn_catalog::get_item_id -revision_id $course_id] + set admin_p [permission::permission_p -object_id $item_id -privilege "admin"] +} else { + set admin_p 0 +} +set obj_n 0 # For dotlrn associations -db_multirow relations relation { } \ No newline at end of file +db_multirow -extend { obj_n admin_p } relations relation { } { + set obj_n 1 +} \ No newline at end of file Index: openacs-4/packages/dotlrn-catalog/tcl/dotlrn-catalog-procs.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-catalog/tcl/dotlrn-catalog-procs.tcl,v diff -u -N -r1.1 -r1.2 --- openacs-4/packages/dotlrn-catalog/tcl/dotlrn-catalog-procs.tcl 14 Feb 2005 22:46:11 -0000 1.1 +++ openacs-4/packages/dotlrn-catalog/tcl/dotlrn-catalog-procs.tcl 16 Feb 2005 22:21:30 -0000 1.2 @@ -47,7 +47,7 @@ ad_proc -private dotlrn_catalog::check_name { -name:required } { - Checks if @name@ already exists in dotlrn_catalog table + Checks if @name@ already exists in cr_item table @name@ The name of the course_key } { if { [string equal [db_string check_item_name { } -default -1] "-1"] } { Index: openacs-4/packages/dotlrn-catalog/tcl/dotlrn-catalog-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-catalog/tcl/dotlrn-catalog-procs.xql,v diff -u -N -r1.1 -r1.2 --- openacs-4/packages/dotlrn-catalog/tcl/dotlrn-catalog-procs.xql 14 Feb 2005 22:46:11 -0000 1.1 +++ openacs-4/packages/dotlrn-catalog/tcl/dotlrn-catalog-procs.xql 16 Feb 2005 22:21:30 -0000 1.2 @@ -33,7 +33,7 @@ - select course_id from dotlrn_catalog where course_key = :name + select item_id from cr_items where name = :name Index: openacs-4/packages/dotlrn-catalog/www/admin/grant-list.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-catalog/www/admin/grant-list.tcl,v diff -u -N -r1.2 -r1.3 --- openacs-4/packages/dotlrn-catalog/www/admin/grant-list.tcl 14 Feb 2005 22:55:39 -0000 1.2 +++ openacs-4/packages/dotlrn-catalog/www/admin/grant-list.tcl 16 Feb 2005 22:21:30 -0000 1.3 @@ -83,14 +83,16 @@ } } permission { - label "[_ dotlrn-catalog.permission]" + label "[_ dotlrn-catalog.privilege_on_catalog]" display_template { +
- [_ dotlrn-catalog.granted] + [_ dotlrn-catalog.create] [_ dotlrn-catalog.not_allowed] +
} } } Index: openacs-4/packages/dotlrn-catalog/www/admin/grant-list.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-catalog/www/admin/grant-list.xql,v diff -u -N -r1.1 -r1.2 --- openacs-4/packages/dotlrn-catalog/www/admin/grant-list.xql 14 Feb 2005 22:46:11 -0000 1.1 +++ openacs-4/packages/dotlrn-catalog/www/admin/grant-list.xql 16 Feb 2005 22:21:30 -0000 1.2 @@ -14,8 +14,8 @@ select first_names, last_name, user_id as p_user_id, email as db_email - from cc_users where user_id <> :user_id and lower(first_names) like lower('%$user_name%') - or lower(last_name) like lower('%$user_name%') order by first_names, last_name + from cc_users where user_id <> :user_id and (lower(first_names) like lower('%$user_name%') + or lower(last_name) like lower('%$user_name%')) order by first_names, last_name Index: openacs-4/packages/dotlrn-catalog/www/dt-admin/course-add-edit.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-catalog/www/dt-admin/course-add-edit.adp,v diff -u -N -r1.1 -r1.2 --- openacs-4/packages/dotlrn-catalog/www/dt-admin/course-add-edit.adp 14 Feb 2005 22:46:11 -0000 1.1 +++ openacs-4/packages/dotlrn-catalog/www/dt-admin/course-add-edit.adp 16 Feb 2005 22:21:30 -0000 1.2 @@ -2,4 +2,5 @@ @page_title@ @context;noquote@ - \ No newline at end of file + + Index: openacs-4/packages/dotlrn-catalog/www/dt-admin/course-add-edit.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-catalog/www/dt-admin/course-add-edit.tcl,v diff -u -N -r1.4 -r1.5 --- openacs-4/packages/dotlrn-catalog/www/dt-admin/course-add-edit.tcl 16 Feb 2005 15:28:32 -0000 1.4 +++ openacs-4/packages/dotlrn-catalog/www/dt-admin/course-add-edit.tcl 16 Feb 2005 22:21:30 -0000 1.5 @@ -9,10 +9,13 @@ course_id:optional mode:optional { return_url "" } + { index "" } } -if { [string equal $return_url ""]} { +if { [string equal $return_url ""] } { set return_url "course-list" +} else { + set return_url $return_url } set page_title "" @@ -26,7 +29,7 @@ if { [info exist mode] } { if { [string equal $mode 1] } { - permission::require_permission -object_id $course_id -privilege "create" + permission::require_permission -object_id $course_id -privilege "admin" } set mode_p edit } else { @@ -79,8 +82,9 @@ } # Create the form -ad_form -name add_course -export {return_url $return_url mode $mode} -form { +ad_form -name add_course -export {mode $mode} -form { course_id:key + {return_url:text(hidden)} } @@ -104,11 +108,14 @@ set attr_name [lindex $attribute 2] lappend form_attributes [list $attr_name [set $attr_name]] } - if { [catch { set item_id [content::item::new -name $course_key -parent_id $folder_id \ - -content_type "dotlrn_catalog" -creation_user $user_id \ - -attributes $form_attributes -is_live t -title $course_key] } errmsg] } { + if { [dotlrn_catalog::check_name -name $course_key] } { + set item_id [content::item::new -name $course_key -parent_id $folder_id \ + -content_type "dotlrn_catalog" -creation_user $user_id \ + -attributes $form_attributes -is_live t -title $course_key] + } else { ad_return_complaint 1 "\#dotlrn-catalog.name_already\#" - } + ad_script_abort + } # Grant admin privileges to the user over the item in the CR permission::grant -party_id $user_id -object_id $item_id -privilege "admin" @@ -137,15 +144,13 @@ } -new_request { set context [list [list course-list "[_ dotlrn-catalog.course_list]"] "[_ dotlrn-catalog.new_course]"] set page_title "[_ dotlrn-catalog.new_course]" - set return_url "$return_url" } -edit_request { set context [list [list course-list "[_ dotlrn-catalog.course_list]"] "[_ dotlrn-catalog.edit_course]"] set page_title "[_ dotlrn-catalog.edit_course]" - set return_url "$return_url" db_1row get_course_info { } db_string get_course_assessment { } -default "[_ dotlrn-catalog.not_associated]" - + set return_url "$return_url?course_id=$course_id&course_name=$course_name&course_key=$course_key&index=$index" } -after_submit { ad_returnredirect "$return_url" } Index: openacs-4/packages/dotlrn-catalog/www/dt-admin/course-details.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-catalog/www/dt-admin/course-details.tcl,v diff -u -N -r1.1 -r1.2 --- openacs-4/packages/dotlrn-catalog/www/dt-admin/course-details.tcl 16 Feb 2005 15:28:32 -0000 1.1 +++ openacs-4/packages/dotlrn-catalog/www/dt-admin/course-details.tcl 16 Feb 2005 22:21:30 -0000 1.2 @@ -10,6 +10,8 @@ { course_name "" } } +permission::require_permission -object_id $course_id -privilege "admin" + if { [string equal $return_url "index"] } { set context [list [list ../course-info?course_id=$course_id&course_key=$course_key&course_name=$course_name "[_ dotlrn-catalog.one_course_info]"] "[_ dotlrn-catalog.course_details]"] } else { Index: openacs-4/packages/dotlrn-catalog/www/dt-admin/course-info.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-catalog/www/dt-admin/course-info.adp,v diff -u -N -r1.1 -r1.2 --- openacs-4/packages/dotlrn-catalog/www/dt-admin/course-info.adp 16 Feb 2005 00:22:46 -0000 1.1 +++ openacs-4/packages/dotlrn-catalog/www/dt-admin/course-info.adp 16 Feb 2005 22:21:30 -0000 1.2 @@ -3,4 +3,4 @@ @context;noquote@
- + Index: openacs-4/packages/dotlrn-catalog/www/dt-admin/course-info.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-catalog/www/dt-admin/course-info.tcl,v diff -u -N -r1.1 -r1.2 --- openacs-4/packages/dotlrn-catalog/www/dt-admin/course-info.tcl 16 Feb 2005 00:22:46 -0000 1.1 +++ openacs-4/packages/dotlrn-catalog/www/dt-admin/course-info.tcl 16 Feb 2005 22:21:30 -0000 1.2 @@ -7,11 +7,23 @@ course_id:notnull course_key:notnull course_name:notnull + { index "" } + { return_url "" } } + +if { [string equal $index ""] } { + set context [list [list "course-list" "[_ dotlrn-catalog.course_list]"] "[_ dotlrn-catalog.one_course_info]"] +} else { + set context [list [list "../course-info?course_id=$course_id&course_name=$course_name&course_key=$course_key" "[_ dotlrn-catalog.one_course_info]"] "$course_name [_ dotlrn-catalog.course_info]"] + set return_url "${return_url}&index=yes" +} + +# Check permission over course_id +permission::require_permission -object_id $course_id -privilege "admin" + set page_title "$course_key [_ dotlrn-catalog.course_info]" -set context [list "[_ dotlrn-catalog.one_course_info]"] -set return_url "index" + set asm_package_id [apm_package_id_from_key assessment] db_1row get_course_info { } Index: openacs-4/packages/dotlrn-catalog/www/dt-admin/course-list.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-catalog/www/dt-admin/course-list.adp,v diff -u -N -r1.2 -r1.3 --- openacs-4/packages/dotlrn-catalog/www/dt-admin/course-list.adp 16 Feb 2005 00:22:12 -0000 1.2 +++ openacs-4/packages/dotlrn-catalog/www/dt-admin/course-list.adp 16 Feb 2005 22:21:30 -0000 1.3 @@ -8,7 +8,15 @@
| #dotlrn-catalog.grant_per#
-

+


+ +
+ #dotlrn-catalog.search_courses# + + + +
+
\ No newline at end of file Index: openacs-4/packages/dotlrn-catalog/www/dt-admin/course-list.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-catalog/www/dt-admin/course-list.tcl,v diff -u -N -r1.3 -r1.4 --- openacs-4/packages/dotlrn-catalog/www/dt-admin/course-list.tcl 16 Feb 2005 15:28:32 -0000 1.3 +++ openacs-4/packages/dotlrn-catalog/www/dt-admin/course-list.tcl 16 Feb 2005 22:21:30 -0000 1.4 @@ -5,6 +5,7 @@ @creation-date 28-01-2005 } { page:optional + keyword:optional } set user_id [ad_conn user_id] @@ -34,11 +35,21 @@ set asm_package_id [apm_package_id_from_key assessment] if { [acs_user::site_wide_admin_p] } { - set query get_course_info_site_wide - set paginator_query site_wide_paginator + if { [info exist keyword] } { + set query get_course_info_site_wide_keyword + set paginator_query site_wide_paginator_keyword + } else { + set query get_course_info_site_wide + set paginator_query site_wide_paginator + } } else { - set query get_course_info - set paginator_query paginator + if { [info exist keyword] } { + set query get_course_info_keyword + set paginator_query site_wide_paginator_keyword + } else { + set query get_course_info + set paginator_query paginator + } } template::list::create \ @@ -56,16 +67,20 @@ key { label "[_ dotlrn-catalog.course_key]" display_template { +
\ @course_list.course_key@ +
} } name { label "[_ dotlrn-catalog.course_name]" display_template { +
@course_list.course_name@ +
} } assessment_id { @@ -117,4 +132,4 @@ set creation_user [dotlrn_catalog::get_creation_user -object_id $item_id] set rel [dotlrn_catalog::has_relation -course_id $course_id] set category_name "[category::get_name [category::get_mapped_categories $course_id]]" -} +} \ No newline at end of file Index: openacs-4/packages/dotlrn-catalog/www/dt-admin/course-list.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-catalog/www/dt-admin/course-list.xql,v diff -u -N -r1.2 -r1.3 --- openacs-4/packages/dotlrn-catalog/www/dt-admin/course-list.xql 16 Feb 2005 00:22:12 -0000 1.2 +++ openacs-4/packages/dotlrn-catalog/www/dt-admin/course-list.xql 16 Feb 2005 22:21:30 -0000 1.3 @@ -20,6 +20,26 @@ + + + select cc.course_id, cc.course_key, cc.course_name, cc.course_info, cc.assessment_id, ci.item_id + from dotlrn_catalog cc, cr_items ci + where cc.course_id = ci.live_revision and + lower(cc.course_name) like lower('%$keyword%') and + ci.item_id in ( + select object_id from acs_permissions where grantee_id = :user_id and + privilege = 'admin') + + + + + + select cc.course_id, cc.course_key, cc.course_name, cc.course_info, cc.assessment_id, ci.item_id + from dotlrn_catalog cc, cr_items ci + where cc.course_id = ci.live_revision and lower(cc.course_name) like lower('%$keyword%') + + + select cr.title from @@ -34,7 +54,7 @@ select cc.course_id, cc.course_key, cc.course_name, cc.course_info, cc.assessment_id, ci.item_id from dotlrn_catalog cc, cr_items ci - where cc.course_id = ci.live_revision and + where cc.course_id = ci.live_revision and ci.item_id in ( select object_id from acs_permissions where grantee_id = :user_id and privilege = 'admin') @@ -49,5 +69,23 @@ + + + select cc.course_id, cc.course_key, cc.course_name, cc.course_info, cc.assessment_id, ci.item_id + from dotlrn_catalog cc, cr_items ci + where cc.course_id = ci.live_revision and lower(cc.course_name) like lower('%$keyword%') and + ci.item_id in ( + select object_id from acs_permissions where grantee_id = :user_id and + privilege = 'admin') + + + + + select cc.course_id, cc.course_key, cc.course_name, cc.course_info, cc.assessment_id, ci.item_id + from dotlrn_catalog cc, cr_items ci + where cc.course_id = ci.live_revision lower(cc.course_name) like lower('%$keyword%') and + + + Index: openacs-4/packages/dotlrn-catalog/www/dt-admin/grant-user-list.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-catalog/www/dt-admin/grant-user-list.tcl,v diff -u -N -r1.1 -r1.2 --- openacs-4/packages/dotlrn-catalog/www/dt-admin/grant-user-list.tcl 14 Feb 2005 22:46:11 -0000 1.1 +++ openacs-4/packages/dotlrn-catalog/www/dt-admin/grant-user-list.tcl 16 Feb 2005 22:21:30 -0000 1.2 @@ -97,14 +97,16 @@ } } permission { - label "[_ dotlrn-catalog.permission]" + label "[_ dotlrn-catalog.privilege_on] $course_key:" display_template { +
- [_ dotlrn-catalog.granted] + [_ dotlrn-catalog.admin] [_ dotlrn-catalog.not_allowed] +
} } } Index: openacs-4/packages/dotlrn-catalog/www/dt-admin/grant-user-list.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-catalog/www/dt-admin/grant-user-list.xql,v diff -u -N -r1.1 -r1.2 --- openacs-4/packages/dotlrn-catalog/www/dt-admin/grant-user-list.xql 14 Feb 2005 22:46:11 -0000 1.1 +++ openacs-4/packages/dotlrn-catalog/www/dt-admin/grant-user-list.xql 16 Feb 2005 22:21:30 -0000 1.2 @@ -14,7 +14,7 @@ select first_names, last_name, user_id as p_user_id, email as db_email from cc_users where user_id <> :user_id - and (lower(first_names) like '%$user_name%' + and (lower(first_names) like lower('%$user_name%') or lower(last_name) like '%$user_name%') order by first_names, last_name @@ -23,16 +23,16 @@ select first_names, last_name, user_id as p_user_id, email as db_email from cc_users where user_id <> :user_id - and lower(email) like '%$user_email%' order by email + and lower(email) like lower('%$user_email%') order by email select first_names, last_name, user_id as p_user_id, email as db_email - from cc_users where user_id <> :user_id - lower(first_names) like '%$user_name%' or lower(last_name) like '%$user_name%') - and lower(email) like '%$user_email%' order by email + from cc_users where user_id <> :user_id and ( + lower(first_names) like lower('%$user_name%') or lower(last_name) like lower('%$user_name%')) + and lower(email) like lower('%$user_email%') order by email
- +