Index: openacs-4/packages/recruiting/www/#rating-sheet.tcl# =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/Attic/#rating-sheet.tcl#,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/#rating-sheet.tcl# 1 Aug 2002 21:18:09 -0000 1.1 @@ -0,0 +1,13 @@ +ad_page_contract { + recruiting user interface + + @author chak (chak@openforce.net) + @creation-date 2002-08-01 + @version $Id: #rating-sheet.tcl#,v 1.1 2002/08/01 21:18:09 chak Exp $ +} { + interview_id +} + +set package_id [ad_conn package_id] +set user_id [ad_verify_and_get_user_id] + Index: openacs-4/packages/recruiting/www/index.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/index.adp,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/index.adp 1 Aug 2002 21:18:09 -0000 1.1 @@ -0,0 +1,8 @@ + +@context_bar@ + +
+<%= [table::outputTable summary] %> + +<%= [table::outputTable options] %> +
Index: openacs-4/packages/recruiting/www/index.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/index.tcl,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/index.tcl 1 Aug 2002 21:18:09 -0000 1.1 @@ -0,0 +1,31 @@ +ad_page_contract { + recruiting user interface + + @author chak (chak@openforce.net) + @creation-date 2002-08-01 + @version $Id: index.tcl,v 1.1 2002/08/01 21:18:09 chak Exp $ +} + +set package_id [ad_conn package_id] +set user_id [ad_verify_and_get_user_id] + +set new_interviews [db_string num_new_interviews {}] +set old_interviews [db_string num_old_interviews {}] + +table::setTitle summary "Your Recruiting Summary" + +if {$new_interviews} { + table::addUnsortedRow summary [list "You have $new_interviews new interviews to complete."] +} +if {$old_interviews} { + table::addUnsortedRow summary [list "You have $old_interviews completed interviews."] +} + +if {!($old_interviews || $new_interviews)} { + table::addUnsortedRow summary [list "You have no recruiting summary."] +} + +table::setTitle options "Options" +table::addUnsortedRow options [list "There are currently no options"] + +set context_bar [list "Recruiting"] Index: openacs-4/packages/recruiting/www/index.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/index.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/index.xql 1 Aug 2002 21:18:09 -0000 1.1 @@ -0,0 +1,26 @@ + + + + + + select count(*) + from recruiting_interviews i + where i.interviewer_id = :user_id + and (select count(*) + from recruiting_ratings r + where r.interview_id = i.interview_id) = 0 + + + + + + select count(*) + from recruiting_interviews i + where i.interviewer_id = :user_id + and (select count(*) + from recruiting_ratings r + where r.interview_id = i.interview_id) != 0 + + + + Index: openacs-4/packages/recruiting/www/my-completed-interviews.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/my-completed-interviews.adp,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/my-completed-interviews.adp 1 Aug 2002 21:18:09 -0000 1.1 @@ -0,0 +1,4 @@ + +@context_bar@ + +<%= [table::outputTable interviews] %> Index: openacs-4/packages/recruiting/www/my-completed-interviews.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/my-completed-interviews.tcl,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/my-completed-interviews.tcl 1 Aug 2002 21:18:09 -0000 1.1 @@ -0,0 +1,24 @@ +ad_page_contract { + recruiting user interface + this page shows a logged in user their completed interviews + + @author chak (chak@openforce.net) + @creation-date 2002-08-01 + @version $Id: my-completed-interviews.tcl,v 1.1 2002/08/01 21:18:09 chak Exp $ +} + +set package_id [ad_conn package_id] +set user_id [ad_verify_and_get_user_id] + +table::setTitle interviews "Candidates you have interviewed" +table::setColumnHeadings interviews [list "Name" "Location" "Average Rating" "Hiring Recommendation"] +table::setColumnAlignment interviews [list left left center center] +db_foreach my_completed_interviews {} { + table::addSortableRow interviews [list "$last_name, $first_name" "$location" "$average_rating" "$should_hire_p" "(view my ratings) (modify interview)"] +} if_no_rows { + table::addSortableRow interviews [list "You haven't interviewed any candidates."] +} + +set context_bar [list [list "index" "Recruiting"] "My Completed Interviews"] + +ad_return_template Index: openacs-4/packages/recruiting/www/my-completed-interviews.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/my-completed-interviews.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/my-completed-interviews.xql 1 Aug 2002 21:18:09 -0000 1.1 @@ -0,0 +1,32 @@ + + + + + + select i.interview_id, + c.candidate_id, + c.last_name, + c.first_name, + c.email, + -- c.phone_number, + c.city||', '||c.state||' '||c.country as location, + round((select avg(r.rating) + from recruiting_ratings r + where interview_id = i.interview_id),1) as average_rating, + (CASE + WHEN i.should_hire_p = 't' + THEN 'Yes' + WHEN i.should_hire_p = 'f' + THEN 'No' + END) as should_hire_p + from recruiting_interviews i, + recruiting_candidates c + where i.interviewer_id = :user_id + and i.candidate_id = c.candidate_id + and (select count(*) + from recruiting_ratings r + where r.interview_id = i.interview_id) != 0 + + + + Index: openacs-4/packages/recruiting/www/my-new-interviews.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/my-new-interviews.adp,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/my-new-interviews.adp 1 Aug 2002 21:18:09 -0000 1.1 @@ -0,0 +1,4 @@ + +@context_bar@ + +<%= [table::outputTable interviews] %> Index: openacs-4/packages/recruiting/www/my-new-interviews.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/my-new-interviews.tcl,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/my-new-interviews.tcl 1 Aug 2002 21:18:09 -0000 1.1 @@ -0,0 +1,23 @@ +ad_page_contract { + recruiting user interface + this page shows a logged in user their to-be-completed interviews + + @author chak (chak@openforce.net) + @creation-date 2002-08-01 + @version $Id: my-new-interviews.tcl,v 1.1 2002/08/01 21:18:09 chak Exp $ +} + +set package_id [ad_conn package_id] +set user_id [ad_verify_and_get_user_id] + +table::setTitle interviews "Candidates for you to interview" +table::setColumnHeadings interviews [list "Name" "Location"] +db_foreach my_new_interviews {} { + table::addSortableRow interviews [list "$last_name, $first_name" "$location" "(rate this candidate)"] +} if_no_rows { + table::addSortableRow interviews [list "You don't have any candidates to interview right now."] +} + +set context_bar [list [list "index" "Recruiting"] "My New Interviews"] + +ad_return_template Index: openacs-4/packages/recruiting/www/my-new-interviews.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/my-new-interviews.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/my-new-interviews.xql 1 Aug 2002 21:18:09 -0000 1.1 @@ -0,0 +1,23 @@ + + + + + + select i.interview_id, + c.candidate_id, + c.last_name, + c.first_name, + c.email, + -- c.phone_number, + c.city||', '||c.state||' '||c.country as location + from recruiting_interviews i, + recruiting_candidates c + where i.interviewer_id = :user_id + and i.candidate_id = c.candidate_id + and (select count(*) + from recruiting_ratings r + where r.interview_id = i.interview_id) = 0 + + + + Index: openacs-4/packages/recruiting/www/rate-candidate.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/rate-candidate.adp,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/rate-candidate.adp 1 Aug 2002 21:18:09 -0000 1.1 @@ -0,0 +1,6 @@ + +@context_bar@ + +

Rate Sheet for @candidate_info.first_name@ @candidate_info.last_name@

+ + Index: openacs-4/packages/recruiting/www/rate-candidate.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/rate-candidate.tcl,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/rate-candidate.tcl 1 Aug 2002 21:18:09 -0000 1.1 @@ -0,0 +1,72 @@ +ad_page_contract { + recruiting user interface + this is a rating sheet for a candidate + + @author chak (chak@openforce.net) + @creation-date 2002-08-01 + @version $Id: rate-candidate.tcl,v 1.1 2002/08/01 21:18:09 chak Exp $ +} { + interview_id + candidate_id +} + +set package_id [ad_conn package_id] +set user_id [ad_verify_and_get_user_id] + +array set candidate_info [recruiting_candidate::get -candidate_id $candidate_id] + +form create rate_sheet + +set criteria_list [list] +set criteria_ids [list] + +db_foreach get_criteria {} { + element create rate_sheet criteria_$criteria_id \ + -label "$criteria_name
$description" \ + -datatype integer \ + -widget radio \ + -options [list [list "1 (low)" 1] [list 2 2] [list 3 3] [list 4 4] [list "5 (high)" 5] [list "Not Applicable / Don't Know" 0]] + + lappend criteria_ids $criteria_id + lappend criteria_list criteria_$criteria_id +} + +element create rate_sheet candidate_id \ + -widget hidden \ + -value $candidate_id + +element create rate_sheet interview_id \ + -widget hidden \ + -value $interview_id + +element create rate_sheet should_hire_p \ + -label "Should we hire $candidate_info(first_name) $candidate_info(last_name)?" \ + -datatype text \ + -widget radio \ + -options [list [list Yes t] [list No f]] + + +if {[form is_valid rate_sheet]} { + form get_values rate_sheet \ + should_hire_p + + foreach criteria_id $criteria_ids { + form get_values rate_sheet \ + criteria_$criteria_id + + if {[set criteria_$criteria_id] != 0} { + recruiting_rating::new \ + -package_id $package_id \ + -interview_id $interview_id \ + -criteria_id $criteria_id \ + -rating [set criteria_$criteria_id] + } + } + + db_dml set_should_hire {} + + ad_returnredirect index + ad_script_abort +} + +set context_bar [list [list "index" "Recruiting"] [list "my-new-interviews" "My New Interviews"] "One Rate Sheet"] Index: openacs-4/packages/recruiting/www/rate-candidate.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/rate-candidate.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/rate-candidate.xql 1 Aug 2002 21:18:09 -0000 1.1 @@ -0,0 +1,23 @@ + + + + + + select criteria_id, + criteria_name, + description + from recruiting_criteria + where package_id = :package_id + and enabled_p = 't' + + + + + + update recruiting_interviews + set should_hire_p = :should_hire_p + where interview_id = :interview_id + + + + Index: openacs-4/packages/recruiting/www/recruiting-master.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/recruiting-master.adp,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/recruiting-master.adp 1 Aug 2002 21:18:09 -0000 1.1 @@ -0,0 +1,28 @@ +<% + + # + # Copyright (C) 2001, 2002 OpenForce, Inc. + # + # This file is part of dotLRN. + # + # dotLRN is free software; you can redistribute it and/or modify it under the + # terms of the GNU General Public License as published by the Free Software + # Foundation; either version 2 of the License, or (at your option) any later + # version. + # + # dotLRN is distributed in the hope that it will be useful, but WITHOUT ANY + # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS + # FOR A PARTICULAR PURPOSE. See the GNU General Public License for more + # details. + # + +%> + + + + + <%= [eval dotlrn::navbar $context_bar] %> + +
+ + Index: openacs-4/packages/recruiting/www/admin/assign-candidate-interview.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/assign-candidate-interview.tcl,v diff -u -r1.1 -r1.2 --- openacs-4/packages/recruiting/www/admin/assign-candidate-interview.tcl 31 Jul 2002 23:54:00 -0000 1.1 +++ openacs-4/packages/recruiting/www/admin/assign-candidate-interview.tcl 1 Aug 2002 21:18:09 -0000 1.2 @@ -35,6 +35,8 @@ db_foreach select_users {} { table::addSortableRow search_results [list "$last_name, $first_names ($email)"] + } if_no_rows { + table::addSortableRow search_results [list "There were no users matching your criteria"] } } Index: openacs-4/packages/recruiting/www/admin/list-candidates.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/list-candidates.tcl,v diff -u -r1.2 -r1.3 --- openacs-4/packages/recruiting/www/admin/list-candidates.tcl 31 Jul 2002 23:54:00 -0000 1.2 +++ openacs-4/packages/recruiting/www/admin/list-candidates.tcl 1 Aug 2002 21:18:09 -0000 1.3 @@ -12,9 +12,10 @@ set user_id [ad_verify_and_get_user_id] table::setTitle candidates "Recruiting Candidates" -table::setColumnHeadings candidates [list "Name" "Location" "Status"] +table::setColumnHeadings candidates [list "Name" "Location" "Status" "Interviews"] +table::setColumnAlignment candidates [list left left left center left] db_foreach get_candidates {} { - table::addSortableRow candidates [list "$first_name $last_name" "$city, $state" "$status" "(email) (details)"] + table::addSortableRow candidates [list "$first_name $last_name
($email)" "$city, $state" "$status" "$num_completed_interviews out of $num_interviews
completed" "(details)"] } if_no_rows { table::addSortableRow candidates [list "No Candidates"] } Index: openacs-4/packages/recruiting/www/admin/list-candidates.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/list-candidates.xql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/recruiting/www/admin/list-candidates.xql 31 Jul 2002 23:54:00 -0000 1.2 +++ openacs-4/packages/recruiting/www/admin/list-candidates.xql 1 Aug 2002 21:18:09 -0000 1.3 @@ -9,7 +9,15 @@ c.city, c.state, c.email, - s.short_desc as status + s.short_desc as status, + (select count(*) + from recruiting_interviews i + where i.candidate_id = c.candidate_id) as num_interviews, + (select count(*) from recruiting_interviews i + where i.candidate_id = c.candidate_id + and (select count(*) + from recruiting_ratings r + where r.interview_id = i.interview_id) != 0) as num_completed_interviews from recruiting_candidates c, recruiting_status_types s where c.status = s.status_type_id Index: openacs-4/packages/recruiting/www/admin/view-one-candidate.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/view-one-candidate.tcl,v diff -u -r1.2 -r1.3 --- openacs-4/packages/recruiting/www/admin/view-one-candidate.tcl 1 Aug 2002 00:45:49 -0000 1.2 +++ openacs-4/packages/recruiting/www/admin/view-one-candidate.tcl 1 Aug 2002 21:18:09 -0000 1.3 @@ -39,7 +39,7 @@ table::setExportVars interviews [export_vars candidate_id] db_foreach get_interviews {} { - table::addUnsortedRow interviews [list "$last_name, $first_names" "$num_ratings out of $possible_ratings"] + table::addUnsortedRow interviews [list "$last_name, $first_names" "$num_ratings out of $possible_ratings" "(view ratings)"] } if_no_rows { table::addUnsortedRow interviews [list "No Interviews assigned. (assign one)"] } Index: openacs-4/packages/recruiting/www/admin/view-ratings-by-criteria.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/view-ratings-by-criteria.adp,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/admin/view-ratings-by-criteria.adp 1 Aug 2002 21:18:09 -0000 1.1 @@ -0,0 +1,10 @@ + +@context_bar@ + + + +
+<%= [table::outputTable ratings] %> + +<%= [table::outputTable summary] %> +
Index: openacs-4/packages/recruiting/www/admin/view-ratings-by-criteria.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/view-ratings-by-criteria.tcl,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/admin/view-ratings-by-criteria.tcl 1 Aug 2002 21:18:09 -0000 1.1 @@ -0,0 +1,36 @@ +ad_page_contract { + recruiting admin interface + access admin function such as: criteria specification + and interviewee status types + + @author chak (chak@openforce.net) + @creation-date 2002-08-01 + @version $Id: view-ratings-by-criteria.tcl,v 1.1 2002/08/01 21:18:09 chak Exp $ +} { + candidate_id:notnull + criteria_id:notnull +} + +array set candidate_info [recruiting_candidate::get -candidate_id $candidate_id] +array set criteria_info [recruiting_criteria::get -criteria_id $criteria_id] + +table::setTitle ratings "$criteria_info(criteria_name) ratings for $candidate_info(first_name) $candidate_info(last_name)" +table::setColumnHeadings ratings [list "Interviewer" "$criteria_info(criteria_name) Rating"] +table::setColumnAlignment ratings [list left center] +db_foreach get_ratings_by_criteria {} { + table::addSortableRow ratings [list "$interviewer_name (view all ratings)" "$rating"] +} if_no_rows { + table::addSortableRow ratings [list "$candidate_info(first_name) $candidate_info(last_name) has no $criteria_info(criteria_name) ratings."] +} + +table::setTitle summary "Summary Information" +table::addUnsortedRow summary [list "Average rating:" [db_string get_average_rating_by_criteria {}]] + +set context_bar [list \ + [list "../" "Recruiting"] \ + [list "index" "Admin"] \ + [list "list-candidates" "Candidates"] \ + [list "view-one-candidate?[export_vars candidate_id]" "One Candidate"] \ + "Criteria Ratings"] + +ad_return_template Index: openacs-4/packages/recruiting/www/admin/view-ratings-by-criteria.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/view-ratings-by-criteria.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/admin/view-ratings-by-criteria.xql 1 Aug 2002 21:18:09 -0000 1.1 @@ -0,0 +1,29 @@ + + + + + + select u.user_id as interviewer_user_id, + u.first_names||' '||u.last_name as interviewer_name, + r.rating + from recruiting_ratings r, + registered_users u + where r.criteria_id = :criteria_id + and r.interview_id = recruiting_interviews.interview_id + and recruiting_interviews.candidate_id = :candidate_id + and recruiting_interviews.interviewer_id = u.user_id + + + + + + select round(avg(r.rating),1) + from recruiting_ratings r, + recruiting_interviews i + where r.criteria_id = :criteria_id + and r.interview_id = i.interview_id + and i.candidate_id = :candidate_id + + + + Index: openacs-4/packages/recruiting/www/admin/view-ratings-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/view-ratings-postgresql.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/admin/view-ratings-postgresql.xql 1 Aug 2002 21:18:09 -0000 1.1 @@ -0,0 +1,21 @@ + + + postgresql7.1 + + + + select (CASE + WHEN (select should_hire_p + from recruiting_interviews i + where i.interview_id = :interview_id) = 't' + THEN 'Yes' + WHEN (select should_hire_p + from recruiting_interviews i + where i.interview_id = :interview_id) = 'f' + THEN 'No' + END) as should_hire_p + + + + + Index: openacs-4/packages/recruiting/www/admin/view-ratings.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/view-ratings.adp,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/admin/view-ratings.adp 1 Aug 2002 21:18:09 -0000 1.1 @@ -0,0 +1,10 @@ + +@context_bar@ + + + +
+<%= [table::outputTable ratings] %> + +<%= [table::outputTable summary] %> +
Index: openacs-4/packages/recruiting/www/admin/view-ratings.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/view-ratings.tcl,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/admin/view-ratings.tcl 1 Aug 2002 21:18:09 -0000 1.1 @@ -0,0 +1,44 @@ +ad_page_contract { + recruiting admin interface + access admin function such as: criteria specification + and interviewee status types + + @author chak (chak@openforce.net) + @creation-date 2002-08-01 + @version $Id: view-ratings.tcl,v 1.1 2002/08/01 21:18:09 chak Exp $ +} { + interview_id:notnull +} + +array set interview_info [recruiting_interview::get -interview_id $interview_id] +array set candidate_info [recruiting_candidate::get -candidate_id $interview_info(candidate_id)] + +set interviewer_id $interview_info(interviewer_id) +set candidate_id $interview_info(candidate_id) + +db_1row get_interviewer_info {} + +table::setTitle ratings "$interviewer_name\'s ratings for $candidate_info(first_name) $candidate_info(last_name)" +table::setColumnHeadings ratings [list "Criteria" "Rating"] +table::setColumnAlignment ratings [list left center] +table::setExportVars ratings [export_vars interview_id] + +db_foreach get_ratings {} { + table::addSortableRow ratings [list "$criteria_name (view all $criteria_name ratings)
$description" "$rating"] +} if_no_rows { + table::addSortableRow ratings [list "$interviewer_name has not made any ratings for $candidate_info(first_name) $candidate_info(last_name)"] +} + +table::setTitle summary "Summary Info" +table::addUnsortedRow summary [list "Interviewed by:" "$interviewer_name
$interviewer_email"] +table::addUnsortedRow summary [list "Average rating:" [db_string get_average_rating {}]] +table::addUnsortedRow summary [list "Hiring suggestion:" [db_string get_should_hire_p {}]] + +set context_bar [list \ + [list "../" "Recruiting"] \ + [list "index" "Admin"] \ + [list "list-candidates" "Candidates"] \ + [list "view-one-candidate?candidate_id=$interview_info(candidate_id)" "One Candidate"] \ + "Interview Ratings"] + +ad_return_template Index: openacs-4/packages/recruiting/www/admin/view-ratings.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/view-ratings.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/admin/view-ratings.xql 1 Aug 2002 21:18:09 -0000 1.1 @@ -0,0 +1,33 @@ + + + + + + select first_names||' '||last_name as interviewer_name, + email as interviewer_email + from registered_users + where user_id = :interviewer_id + + + + + + select cr.criteria_id, + cr.criteria_name, cr.description, + r.rating + from recruiting_criteria cr, + recruiting_ratings r + where r.interview_id = :interview_id + and r.criteria_id = cr.criteria_id + + + + + + select round(avg(r.rating),1) + from recruiting_ratings r + where r.interview_id = :interview_id + + + +