public function getManageCompetencesTotal($id_fncrole, $filter = false)
{
if ($id_fncrole <= 0) {
return false;
}
//invalid role
//validate filter data and abjust query
$_filter = "";
if (is_array($filter)) {
if (isset($filter['text']) && $filter['text'] != '') {
$_filter .= " WHERE (cl.name LIKE '%" . $filter['text'] . "%' " . " OR ctl.name LIKE '%" . $filter['text'] . "%') ";
}
}
$_cmodel = new CompetencesAdm();
$_language = getLanguage();
//mount query
$query = "SELECT COUNT(*) " . " FROM (" . $this->_getRolesCompetencesTable() . " as fc JOIN " . $_cmodel->_getCompetencesTable() . " as c " . " ON (fc.id_competence = c.id_competence AND fc.id_fncrole=" . (int) $id_fncrole . ")) " . " LEFT JOIN " . $_cmodel->_getCompetencesLangTable() . " as cl ON (c.id_competence = cl.id_competence AND cl.lang_code='" . $_language . "') " . " LEFT JOIN " . $_cmodel->_getCategoriesLangTable() . " as ctl ON (c.id_category = ctl.id_category AND ctl.lang_code='" . $_language . "') " . $_filter;
$res = $this->db->query($query);
//extract total value database
$output = false;
if ($res) {
list($total) = $this->db->fetch_row($res);
$output = $total;
}
return $output;
}
