Index: openacs-4/packages/recruiting/www/admin/assign-candidate-interview-2.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/assign-candidate-interview-2.tcl,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/admin/assign-candidate-interview-2.tcl 31 Jul 2002 23:54:00 -0000 1.1 @@ -0,0 +1,22 @@ +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-07-30 + @version $Id: assign-candidate-interview-2.tcl,v 1.1 2002/07/31 23:54:00 chak Exp $ +} { + candidate_id:notnull + search_user_id:notnull +} + +set package_id [ad_conn package_id] +set user_id [ad_verify_and_get_user_id] + +recruiting_interview::new \ + -interviewer_id $search_user_id \ + -candidate_id $candidate_id \ + -package_id $package_id + +ns_returnredirect view-one-candidate?[export_vars candidate_id] Index: openacs-4/packages/recruiting/www/admin/assign-candidate-interview.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/assign-candidate-interview.adp,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/admin/assign-candidate-interview.adp 31 Jul 2002 23:54:00 -0000 1.1 @@ -0,0 +1,10 @@ +<master src="recruiting-admin-master"> + +<property name="context_bar">@context_bar@</property> + +<if @searching_p@ eq 1> + <formtemplate id="assign_interview"></formtemplate> +</if> +<else> + <%= [table::outputTable search_results] %> +</else> 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 --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/admin/assign-candidate-interview.tcl 31 Jul 2002 23:54:00 -0000 1.1 @@ -0,0 +1,43 @@ +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-07-30 + @version $Id: assign-candidate-interview.tcl,v 1.1 2002/07/31 23:54:00 chak Exp $ +} { + candidate_id:notnull +} + +set package_id [ad_conn package_id] +set user_id [ad_verify_and_get_user_id] + +set searching_p 1 + +form create assign_interview +element create assign_interview search_text \ + -label "Assign interview to" \ + -datatype text \ + -widget text \ + -html {size 40} + +element create assign_interview candidate_id \ + -widget hidden \ + -value $candidate_id + +if {[form is_valid assign_interview]} { + set searching_p 0 + form get_values assign_interview \ + search_text + + table::setTitle search_results "Choose an interviewer" + + db_foreach select_users {} { + table::addSortableRow search_results [list "<a href=assign-candidate-interview-2?[export_vars "candidate_id search_user_id"]>$last_name, $first_names ($email)</a>"] + } +} + +set context_bar [list [list "../" "Recruiting"] [list "index" "Admin"] [list "list-candidates" "Candidates"] [list "view-one-candidate?[export_vars candidate_id]" "One Candidate"] "Assign Interview"] + +ad_return_template Index: openacs-4/packages/recruiting/www/admin/assign-candidate-interview.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/assign-candidate-interview.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/admin/assign-candidate-interview.xql 31 Jul 2002 23:54:00 -0000 1.1 @@ -0,0 +1,20 @@ +<?xml version="1.0"?> + +<queryset> + + <fullquery name="select_users"> + <querytext> + select user_id as search_user_id, + first_names, + last_name, + email + from registered_users + where lower(last_name) like lower('%' || :search_text || '%') + or lower(first_names) like lower('%' || :search_text || '%') + or lower(email) like lower('%' || :search_text || '%') + and user_id in (select user_id + from dotlrn_users) + </querytext> + </fullquery> + +</queryset> Index: openacs-4/packages/recruiting/www/admin/edit-criteria.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/edit-criteria.adp,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/admin/edit-criteria.adp 31 Jul 2002 23:54:00 -0000 1.1 @@ -0,0 +1,6 @@ +<master src="recruiting-admin-master"> +<property name="context_bar">@context_bar@</property> + +<formtemplate id="edit_criteria"></formtemplate> + + Index: openacs-4/packages/recruiting/www/admin/edit-criteria.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/edit-criteria.tcl,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/admin/edit-criteria.tcl 31 Jul 2002 23:54:00 -0000 1.1 @@ -0,0 +1,53 @@ +ad_page_contract { + recruiting admin interface + new criteria page + + @author chak (chak@openforce.net) + @creation-date 2002-07-30 + @version $Id: edit-criteria.tcl,v 1.1 2002/07/31 23:54:00 chak Exp $ +} { + {criteria_id:notnull} +} + +set package_id [ad_conn package_id] +set user_id [ad_verify_and_get_user_id] + +array set info [recruiting_criteria::get -criteria_id $criteria_id] + +form create edit_criteria +element create edit_criteria criteria_name \ + -label "Criteria Name:" \ + -datatype text \ + -widget text \ + -html {size 60} \ + -value $info(criteria_name) + +element create edit_criteria description \ + -label "Description:" \ + -datatype text \ + -widget textarea \ + -html {rows 5 cols 60 wrap soft} \ + -value $info(description) + +element create edit_criteria criteria_id \ + -widget hidden \ + -value $criteria_id + +if {[form is_valid edit_criteria]} { + form get_values edit_criteria \ + criteria_name description + + recruiting_criteria::update_criteria_type \ + -criteria_id $criteria_id \ + -criteria_name $criteria_name \ + -description $description \ + -package_id $package_id \ + -enabled_p "t" + + ad_returnredirect list-criteria + ad_script_abort +} + +set context_bar [list [list "../" "Recruiting"] [list "index" "Admin"] [list "list-criteria" "Criteria Types"] "Edit Criteria"] + +ad_return_template Index: openacs-4/packages/recruiting/www/admin/edit-status-type.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/edit-status-type.adp,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/admin/edit-status-type.adp 31 Jul 2002 23:54:00 -0000 1.1 @@ -0,0 +1,5 @@ +<master src="recruiting-admin-master"> +<property name="context_bar">@context_bar@</property> + +<formtemplate id="edit_status_type"></formtemplate> + Index: openacs-4/packages/recruiting/www/admin/edit-status-type.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/edit-status-type.tcl,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/admin/edit-status-type.tcl 31 Jul 2002 23:54:00 -0000 1.1 @@ -0,0 +1,54 @@ +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-07-30 + @version $Id: edit-status-type.tcl,v 1.1 2002/07/31 23:54:00 chak Exp $ +} { + status_type_id:notnull +} + +set package_id [ad_conn package_id] +set user_id [ad_verify_and_get_user_id] + +array set info [recruiting_status_type::get -status_type_id $status_type_id] + +form create edit_status_type +element create edit_status_type short_desc \ + -label "Status type:" \ + -datatype text \ + -widget text \ + -html {size 60} \ + -value $info(short_desc) + +element create edit_status_type long_desc \ + -label "Description:" \ + -datatype text \ + -widget textarea \ + -html {rows 5 cols 60 wrap soft} \ + -value $info(long_desc) + +element create edit_status_type status_type_id \ + -widget hidden \ + -value $info(status_type_id) + +if {[form is_valid edit_status_type]} { + form get_values edit_status_type \ + short_desc long_desc + + recruiting_status_type::update_status_type \ + -status_type_id $status_type_id \ + -short_desc $short_desc \ + -long_desc $long_desc \ + -package_id $package_id \ + -enabled_p "t" + + ad_returnredirect list-status-types + ad_script_abort +} + +set context_bar [list [list "../" "Recruiting"] [list "index" "Admin"] [list "list-status-types" "Status Types"] "Edit Status Type"] + +ad_return_template Index: openacs-4/packages/recruiting/www/admin/index.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/index.adp,v diff -u -r1.2 -r1.3 --- openacs-4/packages/recruiting/www/admin/index.adp 30 Jul 2002 22:38:34 -0000 1.2 +++ openacs-4/packages/recruiting/www/admin/index.adp 31 Jul 2002 23:54:00 -0000 1.3 @@ -1,11 +1,8 @@ -<master> +<master src="recruiting-admin-master"> +<property name="context_bar">@context_bar@</property> -<b>Candidates:</b><br> -<a href=list-candidates>View candidates</a><br> -<a href=new-candidate>Add a new candidate</a><br> - -<p> - -<b>Setup:</b><br> -<a href=list-status-types.tcl>Modify candidate status types</a><br> -<a href=list-criteria>Modify interview criteria</a> +<table width=100%><tr><td valign=top> +<%= [table::outputTable summary] %> +</td><td valign=top> +<%= [table::outputTable options] %> +</td></tr></table> Index: openacs-4/packages/recruiting/www/admin/index.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/index.tcl,v diff -u -r1.1 -r1.2 --- openacs-4/packages/recruiting/www/admin/index.tcl 30 Jul 2002 21:33:38 -0000 1.1 +++ openacs-4/packages/recruiting/www/admin/index.tcl 31 Jul 2002 23:54:00 -0000 1.2 @@ -10,3 +10,13 @@ set package_id [ad_conn package_id] set user_id [ad_verify_and_get_user_id] + +table::setTitle options "Recruiting Administration Options" +table::addUnsortedRow options [list "<a href=list-candidates>Candidate Administration</a>"] +table::addUnsortedRow options [list "<a href=list-status-types.tcl>Candidate status types</a>"] +table::addUnsortedRow options [list "<a href=list-criteria>Interview criteria Administration</a>"] + +table::setTitle summary "Summary Information" +table::addUnsortedRow summary [list "Summary Info will go here"] + +set context_bar [list [list "../" "Recruiting"] "Admin"] Index: openacs-4/packages/recruiting/www/admin/list-candidates.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/list-candidates.adp,v diff -u -r1.1 -r1.2 --- openacs-4/packages/recruiting/www/admin/list-candidates.adp 30 Jul 2002 22:38:34 -0000 1.1 +++ openacs-4/packages/recruiting/www/admin/list-candidates.adp 31 Jul 2002 23:54:00 -0000 1.2 @@ -1,15 +1,11 @@ -<master> +<master src="recruiting-admin-master"> +<property name="context_bar">@context_bar@</property> -<b>Candidates:</b><br> - -<table> -<if @list_candidates:rowcount@ gt 0> - <multiple name="list_candidates"> - <tr><td>@list_candidates.last_name@, @list_candidates.first_name@ from @list_candidates.city@, @list_candidates.state@ (<a href="mailto:@list_candidates.email@">send email</a>)</td><td></td></tr> - </multiple> -</if> -<else> - <tr><td>No candidates (<a href=new-candidate>add one</a>)</td></tr> -</else> +<table width=100%> +<tr><td> +<%= [table::outputTable candidates] %> +</td><td valign=top> +<%= [table::outputTable options] %> +</td><tr> </table> 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.1 -r1.2 --- openacs-4/packages/recruiting/www/admin/list-candidates.tcl 30 Jul 2002 22:38:34 -0000 1.1 +++ openacs-4/packages/recruiting/www/admin/list-candidates.tcl 31 Jul 2002 23:54:00 -0000 1.2 @@ -11,6 +11,17 @@ set package_id [ad_conn package_id] set user_id [ad_verify_and_get_user_id] -db_multirow list_candidates get_candidates {} +table::setTitle candidates "Recruiting Candidates" +table::setColumnHeadings candidates [list "Name" "Location" "Status"] +db_foreach get_candidates {} { + table::addSortableRow candidates [list "$first_name $last_name" "$city, $state" "$status" "(<a href=\"mailto:$email\">email</a>) (<a href=\"view-one-candidate?[export_vars candidate_id]\">details</a>)"] +} if_no_rows { + table::addSortableRow candidates [list "No Candidates"] +} +table::setTitle options "Options" +table::addUnsortedRow options [list "<a href=new-candidate>Add a new candidate</a>"] + +set context_bar [list [list "../" "Recruiting"] [list "index" "Admin"] "Candidates"] + ad_return_template 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.1 -r1.2 --- openacs-4/packages/recruiting/www/admin/list-candidates.xql 30 Jul 2002 22:38:34 -0000 1.1 +++ openacs-4/packages/recruiting/www/admin/list-candidates.xql 31 Jul 2002 23:54:00 -0000 1.2 @@ -3,7 +3,8 @@ <fullquery name="get_candidates"> <querytext> - select c.first_name, + select c.candidate_id, + c.first_name, c.last_name, c.city, c.state, Index: openacs-4/packages/recruiting/www/admin/list-criteria.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/list-criteria.adp,v diff -u -r1.1 -r1.2 --- openacs-4/packages/recruiting/www/admin/list-criteria.adp 30 Jul 2002 21:33:38 -0000 1.1 +++ openacs-4/packages/recruiting/www/admin/list-criteria.adp 31 Jul 2002 23:54:00 -0000 1.2 @@ -1,28 +1,11 @@ -<master> +<master src="recruiting-admin-master"> +<property name="context_bar">@context_bar@</property> -<a href="new-criteria">Add New Criteria</a> - +<table width=100%><tr><td valign=top> +<%= [table::outputTable enabled] %> <p> - -<b>Interview criteria:</b> -<table> -<if @enabled_criteria_types:rowcount@ gt 0> - <multiple name="enabled_criteria_types"> - <tr><td>@enabled_criteria_types.criteria_name@</td><td>(<a href="@enabled_criteria_types.disable_url@">disable</a>)</tr> - </multiple> -</if> -<else> - <tr><td>none defined (<a href=new-criteria>add one</a>)</td></tr> -</else> +<%= [table::outputTable disabled] %> +</td><td valign=top> +<%= [table::outputTable options] %> +</td></tr> </table> - -<p> - -<if @disabled_criteria_types:rowcount@ gt 0> - <b>Disabled criteria:</b> - <table> - <multiple name="disabled_criteria_types"> - <tr><td><font color=grey>@disabled_criteria_types.criteria_name@</td><td>(<a href="@disabled_criteria_types.enable_url@">enable</a>)</tr> - </multiple> - </table> -</if> Index: openacs-4/packages/recruiting/www/admin/list-criteria.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/list-criteria.tcl,v diff -u -r1.1 -r1.2 --- openacs-4/packages/recruiting/www/admin/list-criteria.tcl 30 Jul 2002 21:33:38 -0000 1.1 +++ openacs-4/packages/recruiting/www/admin/list-criteria.tcl 31 Jul 2002 23:54:00 -0000 1.2 @@ -11,11 +11,20 @@ set package_id [ad_conn package_id] set user_id [ad_verify_and_get_user_id] -db_multirow enabled_criteria_types get_enabled_criteria_types "" { - set disable_url "disable-criteria?[export_vars criteria_id]" +table::setTitle enabled "Candidate Criteria" +db_foreach get_enabled_criteria_types {} { + table::addUnsortedRow enabled [list "$criteria_name" "(<a href=\"edit-criteria?[export_vars criteria_id]\">edit</a>) (<a href=\"disable-criteria?[export_vars criteria_id]\">disable</a>)"] } -db_multirow disabled_criteria_types get_disabled_criteria_types "" { - set enable_url "enable-criteria?[export_vars criteria_id]" +table::setTitle disabled "Disabled Criteria" +db_foreach get_disabled_criteria_types {} { + table::addUnsortedRow disabled [list "$criteria_name" "(<a href=\"enable-criteria?[export_vars criteria_id]\">enable</a>)"] + } +table::setTitle options "Options" +table::addUnsortedRow options [list "<a href=\"new-criteria\">Add New Criteria</a>"] + +set context_bar [list [list "../" "Recruiting"] [list "index" "Admin"] "Criteria Types"] + +ad_return_template Index: openacs-4/packages/recruiting/www/admin/list-status-types.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/list-status-types.adp,v diff -u -r1.2 -r1.3 --- openacs-4/packages/recruiting/www/admin/list-status-types.adp 30 Jul 2002 22:38:34 -0000 1.2 +++ openacs-4/packages/recruiting/www/admin/list-status-types.adp 31 Jul 2002 23:54:00 -0000 1.3 @@ -1,32 +1,11 @@ -<master> - +<master src="recruiting-admin-master"> <property name="context_bar">@context_bar@</property> -<a href="new-status-type">Add new status type</a> - +<table width=100%><tr><td valign=top> +<%= [table::outputTable enabled] %> <p> - -<b>Candidate status types:</b><br> - -<table> -<if @enabled_status_types:rowcount@ gt 0> - <multiple name="enabled_status_types"> - <tr><td>@enabled_status_types.short_desc@</td><td>(<a href="@enabled_status_types.disable_url@">disable</a>)</td></tr> - </multiple> -</if> -<else> - <tr><td>none defined (<a href=new-status-type>add one</a>)</td></tr> -</else> +<%= [table::outputTable disabled] %> +</td><td valign=top> +<%= [table::outputTable options] %> +</td></tr> </table> - - -<p> - -<if @disabled_status_types:rowcount@ gt 0> - <b>Disabled status types:</b> - <table> - <multiple name="disabled_status_types"> - <tr><td><font color=grey>@disabled_status_types.short_desc@</td><td>(<a href="@disabled_status_types.enable_url@">enable</a>)</tr> - </multiple> - </table> -</if> Index: openacs-4/packages/recruiting/www/admin/list-status-types.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/list-status-types.tcl,v diff -u -r1.1 -r1.2 --- openacs-4/packages/recruiting/www/admin/list-status-types.tcl 30 Jul 2002 21:33:38 -0000 1.1 +++ openacs-4/packages/recruiting/www/admin/list-status-types.tcl 31 Jul 2002 23:54:00 -0000 1.2 @@ -11,14 +11,23 @@ set package_id [ad_conn package_id] set user_id [ad_verify_and_get_user_id] -db_multirow enabled_status_types get_enabled_status_types {} { - set disable_url "disable-status-type?[export_vars status_type_id]" +table::setTitle enabled "Candidate Status Types" +db_foreach get_enabled_status_types {} { + table::addSortableRow enabled [list "$short_desc" "(<a href=\"edit-status-type?[export_vars status_type_id]\">edit</a>) (<a href=\"disable-status-type?[export_vars status_type_id]\">disable</a>)"] +} if_no_rows { + table::addSortableRow enabled [list "There are no status types. (<a href=new-status-type>create one</a>)"] } -db_multirow disabled_status_types get_disabled_status_types {} { - set enable_url "enable-status-type?[export_vars status_type_id]" +table::setTitle disabled "Disabled Candidate Status Types" +db_foreach get_disabled_status_types {} { + table::addSortableRow disabled [list "$short_desc" "(<a href=\"enable-status-type?[export_vars status_type_id]\">enable</a>)"] +} if_no_rows { + table::addSortableRow disabled [list "There are no disabled status types"] } +table::setTitle options "Options" +table::addUnsortedRow options [list "<a href=\"new-status-type\">Add new status type</a>"] + set context_bar [list [list "../" "Recruiting"] [list "index" "Admin"] "Status Types"] ad_return_template Index: openacs-4/packages/recruiting/www/admin/new-candidate.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/new-candidate.adp,v diff -u -r1.1 -r1.2 --- openacs-4/packages/recruiting/www/admin/new-candidate.adp 30 Jul 2002 22:38:34 -0000 1.1 +++ openacs-4/packages/recruiting/www/admin/new-candidate.adp 31 Jul 2002 23:54:00 -0000 1.2 @@ -1,8 +1,17 @@ -<master> +<SCRIPT LANGUAGE="JavaScript"> +function openPage(theImage, theWidth, theHeight) { + OpenWindow=window.open(theImage, "newwin", config='toolbar=no, menubar=no, scrollbars=yes, resizable=no, location=no, directories=no, status=no, width='+theWidth+', height='+theHeight); +} +</SCRIPT> +<master src="recruiting-admin-master"> +<property name="context_bar">@context_bar@</property> + <if @status_type_count@ ne 0> <formtemplate id="new_candidate"></formtemplate> </if> <else> There are no candidate status types defined. You must <a href=new-status-type>define a status type</a> before creating candidates. </else> + + Index: openacs-4/packages/recruiting/www/admin/new-candidate.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/new-candidate.tcl,v diff -u -r1.1 -r1.2 --- openacs-4/packages/recruiting/www/admin/new-candidate.tcl 30 Jul 2002 22:38:34 -0000 1.1 +++ openacs-4/packages/recruiting/www/admin/new-candidate.tcl 31 Jul 2002 23:54:00 -0000 1.2 @@ -81,10 +81,10 @@ -html {size 30} element create new_candidate status \ - -label "Status:" \ + -label "Status (<a href=\"javascript:openPage('status-help',400,300)\">help</a>):" \ -datatype integer \ -widget select \ - -options [db_list_of_lists get_status_types "select short_desc,status_type_id from recruiting_status_types where enabled_p='t' order by short_desc"] \ + -options [db_list_of_lists get_status_types "select short_desc,status_type_id from recruiting_status_types where enabled_p='t' order by short_desc"] if {[form is_valid new_candidate]} { form get_values new_candidate \ @@ -109,4 +109,6 @@ ad_script_abort } +set context_bar [list [list "../" "Recruiting"] [list "index" "Admin"] [list "list-candidates" "Candidates"] "New Candidate"] + ad_return_template Index: openacs-4/packages/recruiting/www/admin/new-criteria.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/new-criteria.adp,v diff -u -r1.1 -r1.2 --- openacs-4/packages/recruiting/www/admin/new-criteria.adp 30 Jul 2002 21:33:38 -0000 1.1 +++ openacs-4/packages/recruiting/www/admin/new-criteria.adp 31 Jul 2002 23:54:00 -0000 1.2 @@ -1,3 +1,6 @@ -<master> +<master src="recruiting-admin-master"> +<property name="context_bar">@context_bar@</property> <formtemplate id="new_criteria"></formtemplate> + + Index: openacs-4/packages/recruiting/www/admin/new-criteria.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/new-criteria.tcl,v diff -u -r1.1 -r1.2 --- openacs-4/packages/recruiting/www/admin/new-criteria.tcl 30 Jul 2002 21:33:38 -0000 1.1 +++ openacs-4/packages/recruiting/www/admin/new-criteria.tcl 31 Jul 2002 23:54:00 -0000 1.2 @@ -37,4 +37,6 @@ ad_script_abort } +set context_bar [list [list "../" "Recruiting"] [list "index" "Admin"] [list "list-criteria" "Criteria Types"] "New Criteria"] + ad_return_template Index: openacs-4/packages/recruiting/www/admin/new-status-type.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/new-status-type.adp,v diff -u -r1.1 -r1.2 --- openacs-4/packages/recruiting/www/admin/new-status-type.adp 30 Jul 2002 21:33:38 -0000 1.1 +++ openacs-4/packages/recruiting/www/admin/new-status-type.adp 31 Jul 2002 23:54:00 -0000 1.2 @@ -1,3 +1,6 @@ -<master> +<master src="recruiting-admin-master"> +<property name="context_bar">@context_bar@</property> <formtemplate id="new_status_type"></formtemplate> + + Index: openacs-4/packages/recruiting/www/admin/new-status-type.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/new-status-type.tcl,v diff -u -r1.1 -r1.2 --- openacs-4/packages/recruiting/www/admin/new-status-type.tcl 30 Jul 2002 21:33:38 -0000 1.1 +++ openacs-4/packages/recruiting/www/admin/new-status-type.tcl 31 Jul 2002 23:54:00 -0000 1.2 @@ -37,4 +37,6 @@ ad_script_abort } +set context_bar [list [list "../" "Recruiting"] [list "index" "Admin"] [list "list-status-types" "Status Types"] "New Status Type"] + ad_return_template Index: openacs-4/packages/recruiting/www/admin/recruiting-admin-master.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/recruiting-admin-master.adp,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/admin/recruiting-admin-master.adp 31 Jul 2002 23:54:00 -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. + # + +%> + +<master> + +<if @context_bar@ not nil> + <%= [eval dotlrn::admin_navbar $context_bar] %> +</if> +<hr> +<slave> + Index: openacs-4/packages/recruiting/www/admin/status-help.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/status-help.adp,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/admin/status-help.adp 31 Jul 2002 23:54:00 -0000 1.1 @@ -0,0 +1 @@ +<%= [table::outputTable types] %> Index: openacs-4/packages/recruiting/www/admin/status-help.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/status-help.tcl,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/admin/status-help.tcl 31 Jul 2002 23:54:00 -0000 1.1 @@ -0,0 +1,18 @@ +ad_page_contract { + recruiting admin interface + list status type definitions + + @author chak (chak@openforce.net) + @creation-date 2002-07-31 + @version $Id: status-help.tcl,v 1.1 2002/07/31 23:54:00 chak Exp $ +} + +set package_id [ad_conn package_id] +set user_id [ad_verify_and_get_user_id] + +table::setColumnHeadings types [list "Choose this..." "When"] +db_foreach get_status_types {} { + table::addSortableRow types [list "<b>$short_desc</b>" "$long_desc"] +} + +ad_return_template Index: openacs-4/packages/recruiting/www/admin/status-help.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/status-help.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/admin/status-help.xql 31 Jul 2002 23:54:00 -0000 1.1 @@ -0,0 +1,14 @@ +<?xml version="1.0"?> +<queryset> + + <fullquery name="get_status_types"> + <querytext> + select short_desc, + long_desc + from recruiting_status_types + where enabled_p = 't' + order by short_desc + </querytext> + </fullquery> + +</queryset> Index: openacs-4/packages/recruiting/www/admin/view-one-candidate.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/view-one-candidate.adp,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/admin/view-one-candidate.adp 31 Jul 2002 23:54:00 -0000 1.1 @@ -0,0 +1,13 @@ +<master src="recruiting-admin-master"> +<property name="context_bar">@context_bar@</property> + +<table width=100%> +<tr><td> +<%= [table::outputTable candidate] %> +<p> +<%= [table::outputTable interviews] %> +</td><td valign=top> +<%= [table::outputTable options] %> +</td></tr> +</table> + 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 --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/admin/view-one-candidate.tcl 31 Jul 2002 23:54:00 -0000 1.1 @@ -0,0 +1,54 @@ +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-07-30 + @version $Id: view-one-candidate.tcl,v 1.1 2002/07/31 23:54:00 chak Exp $ +} { + candidate_id:notnull +} + +set package_id [ad_conn package_id] +set user_id [ad_verify_and_get_user_id] + +array set info [recruiting_candidate::get \ + -candidate_id $candidate_id] + + +set address "$info(address1)<br>" +if {![empty_string_p "$info(address2)"]} { + append address "$info(address2)" +} +append address "$info(city), $info(state) $info(zip)" +if {![empty_string_p "$info(zip_plus_four)"]} { + append address "-$zip_plus_four" +} +append address " $info(country)" + +table::setTitle candidate "Recruiting Candidate Detail" +table::addUnsortedRow candidate [list "Name:" "$info(last_name), $info(first_name)"] +table::addUnsortedRow candidate [list "Address:" "$address"] +table::addUnsortedRow candidate [list "Status:" "$info(status) (<a href=change-candidate-status?candidate_id=$info(candidate_id)>change status</a>)"] + +set possible_ratings [db_string get_num_criteria {}] + +table::setTitle interviews "Interviews for this candidate" +table::setColumnHeadings interviews [list "Interviewer" "Ratings"] +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"] +} if_no_rows { + table::addUnsortedRow interviews [list "No Interviews assigned. (<a href=assign-candidate-interview?[export_vars candidate_id]>assign one</a>)"] +} + +table::setTitle options "Options" +table::addUnsortedRow options [list "<a href=modify-candidate-info?[export_vars candidate_id]>Edit Information</a>"] +table::addUnsortedRow options [list "<a href=change-candidate-status?[export_vars candidate_id]>Change Status</a>"] +table::addUnsortedRow options [list "<a href=assign-candidate-interview?[export_vars candidate_id]>Assign Interview</a>"] + +set context_bar [list [list "../" "Recruiting"] [list "index" "Admin"] [list "list-candidates" "Candidates"] "One Candidate"] + +ad_return_template Index: openacs-4/packages/recruiting/www/admin/view-one-candidate.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/view-one-candidate.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/recruiting/www/admin/view-one-candidate.xql 31 Jul 2002 23:54:00 -0000 1.1 @@ -0,0 +1,28 @@ +<?xml version="1.0"?> +<queryset> + <fullquery name="get_interviews"> + <querytext> + select i.interview_id, + p.person_id, + p.first_names, + p.last_name, + (select count(*) + from recruiting_ratings r + where r.interview_id = i.interview_id) as num_ratings + from persons p, + recruiting_interviews i + where i.interviewer_id = p.person_id + and i.candidate_id = :candidate_id + order by last_name + </querytext> + </fullquery> + + <fullquery name="get_num_criteria"> + <querytext> + select count(*) + from recruiting_criteria + where enabled_p = 't' + </querytext> + </fullquery> + +</queryset>