function mycompetences(&$url)
{
checkPerm('view');
$html = "";
$html .= getTitleArea(Lang::t('_COMPETENCES'), 'competences');
$html .= '<div class="std_block">';
$cmodel = new CompetencesAdm();
$fmodel = new FunctionalrolesAdm();
$id_user = getLogUserId();
$ucomps = $cmodel->getUserCompetences($id_user);
$rcomps = $fmodel->getUserRequiredCompetences($id_user);
$ucomps_info = $cmodel->getCompetencesInfo(array_keys($ucomps));
$language = getLanguage();
$_typologies = $cmodel->getCompetenceTypologies();
$_types = $cmodel->getCompetenceTypes();
$icon_actv = '<span class="ico-sprite subs_actv"><span>' . Lang::t('_COMPETENCE_OBTAINED', 'competences') . '</span></span>';
$icon_req = '<span class="ico-sprite subs_actv"><span>' . Lang::t('_MANDATORY', 'competences') . '</span></span>';
//*******************
require_once _base_ . '/lib/lib.table.php';
$table = new Table(Get::sett('visuItem'), Lang::t('_COMPETENCES'), Lang::t('_COMPETENCES'));
$style_h = array('', '', 'image', 'image', 'image', 'image', 'image');
$label_h = array(Lang::t('_NAME', 'competences'), Lang::t('_TYPOLOGY', 'competences'), Lang::t('_TYPE', 'standard'), Lang::t('_SCORE', 'competences'), Lang::t('_DATE_LAST_COMPLETE', 'subscribe'), Lang::t('_COMPETENCES_REQUIRED', 'competences'));
$table->addHead($label_h, $style_h);
foreach ($ucomps_info as $id_competence => $cinfo) {
$line = array();
$line[] = $cinfo->langs[$language]['name'];
$line[] = $_typologies[$cinfo->typology];
$line[] = $_types[$cinfo->type];
$line[] = $cinfo->type == 'score' ? '<b>' . $ucomps[$id_competence]->score_got . '</b>' : $icon_actv;
$line[] = Format::date($ucomps[$id_competence]->last_assign_date, 'datetime');
$line[] = array_key_exists($id_competence, $rcomps) ? $icon_req : '';
$table->addBody($line);
}
$html .= $table->getTable();
$html .= '</div>';
$html .= Form::openForm('beck_url', 'index.php');
$html .= Form::openButtonSpace();
$html .= Form::getButton('close', 'close', Lang::t('_CLOSE', 'standard'));
$html .= Form::closeButtonSpace();
$html .= Form::closeform();
cout($html, 'content');
}
public function getUserCompetences($id_user, $fncroles = false)
{
if ($id_user <= 0) {
return false;
}
$output = array();
$query = "SELECT * FROM " . $this->_getCompetencesUsersTable() . " WHERE id_user="******" AND score_got>0";
$res = $this->db->query($query);
if ($res) {
while ($obj = $this->db->fetch_obj($res)) {
$output[$obj->id_competence] = $obj;
}
}
//retrieve required competences too
if ($fncroles) {
$fmodel = new FunctionalrolesAdm();
$req = $fmodel->getUserRequiredCompetences($id_user, true);
//$cinfo = $this->getCompetencesInfo(array_keys($req));
foreach ($req as $id_competence => $cdata) {
if (isset($output[$id_competence])) {
$output[$id_competence]->required = true;
$output[$id_competence]->gap = $output[$id_competence]->score_got - $cdata->score;
} else {
$t = new stdClass();
$t->id_competence = $id_competence;
$t->id_user = $id_user;
$t->score_got = 0;
$t->last_assign_date = '';
$t->required = true;
$t->gap = 0 - $cdata->score;
$output[$id_competence] = $t;
}
}
}
return $output;
}
