function get_skills()
{
global $TPL;
global $skill_class;
$skills = array("" => "Any Skill");
$query = "SELECT * FROM skill";
if ($skill_class != "") {
$query .= prepare(" WHERE skillClass='%s'", $skill_class);
}
$query .= " ORDER BY skillClass,skillName";
$db = new db_alloc();
$db->query($query);
while ($db->next_record()) {
$skill = new skill();
$skill->read_db_record($db);
$skills[$skill->get_id()] = sprintf("%s - %s", $skill->get_value('skillClass'), $skill->get_value('skillName'));
}
return $skills;
}
function get_skills($proficiency)
{
// Return a string of skills with a given proficiency
$query = "SELECT * FROM proficiency LEFT JOIN skill on proficiency.skillID=skill.skillID";
$query .= prepare(" WHERE personID=%d AND skillProficiency='%s' ORDER BY skillName", $this->get_id(), $proficiency);
$db = new db_alloc();
$db->query($query);
while ($db->next_record()) {
$skill = new skill();
$skill->read_db_record($db);
if ($rtn) {
$rtn .= ", ";
}
$rtn .= $skill->get_value('skillName');
}
return $rtn;
}
function show_skills_list()
{
global $TPL;
global $personID;
global $skills;
$db = new db_alloc();
$query = prepare("SELECT * FROM proficiency WHERE personID=%d", $personID);
$db->query($query);
$skills_got = array();
while ($db->next_record()) {
$skill = new skill();
$skill->read_db_record($db);
array_push($skills_got, $skill->get_id());
}
$query = "SELECT * FROM skill ORDER BY skillClass";
$db->query($query);
while ($db->next_record()) {
$skill = new skill();
$skill->read_db_record($db);
if (in_array($skill->get_id(), $skills_got)) {
// dont show this item
} else {
$skills[$skill->get_id()] = sprintf("%s - %s", $skill->get_value('skillClass'), $skill->get_value('skillName'));
}
}
if (count($skills) > 0) {
$TPL["skills"] = page::select_options($skills, "");
}
}
function show_skill_expertise()
{
global $TPL;
global $people_ids;
global $people_header;
global $talent;
global $skill_class;
$currSkillClass = null;
$db = new db_alloc();
$query = "SELECT * FROM proficiency";
$query .= " LEFT JOIN skill ON proficiency.skillID=skill.skillID";
if ($talent != "" || $skill_class != "") {
if ($talent != "") {
$query .= prepare(" WHERE proficiency.skillID=%d", $talent);
} else {
$query .= prepare(" WHERE skillClass='%s'", $skill_class);
}
}
$query .= " GROUP BY skillName ORDER BY skillClass,skillName";
$db->query($query);
while ($db->next_record()) {
$skill = new skill();
$skill->read_db_record($db);
$thisSkillClass = $skill->get_value('skillClass');
if ($currSkillClass != $thisSkillClass) {
$currSkillClass = $thisSkillClass;
if (!isset($people_header)) {
get_people_header();
}
$class_header = sprintf("<tr class=\"highlighted\">\n<th width=\"5%%\">%s </th>\n", $skill->get_value('skillClass', DST_HTML_DISPLAY));
print $class_header . $people_header . "</tr>\n";
}
print sprintf("<tr>\n<th>%s</th>\n", $skill->get_value('skillName', DST_HTML_DISPLAY));
for ($i = 0; $i < count($people_ids); $i++) {
$db2 = new db_alloc();
$query = "SELECT * FROM proficiency";
$query .= prepare(" WHERE skillID=%d AND personID=%d", $skill->get_id(), $people_ids[$i]);
$db2->query($query);
if ($db2->next_record()) {
$proficiency = new proficiency();
$proficiency->read_db_record($db2);
$p = sprintf("<td align=\"center\"><img src=\"../images/skill_%s.png\" alt=\"%s\"/></td>\n", strtolower($proficiency->get_value('skillProficiency')), substr($proficiency->get_value('skillProficiency'), 0, 1));
print $p;
} else {
print "<td align=\"center\">-</td>\n";
}
}
print "</tr>\n";
}
}
