static function getNotaMediaYTotalofUserinGroup($userid, $groupid)
{
$grade = new Grades();
$qry = 'select avg(tmp.gradeAvg) as media, sum(tmp.gradeAvg) as total ' . 'from (select avg(g.grade) as gradeAvg ' . 'from grades g, group_inbox gr, notice n ' . 'where g.noticeid = gr.notice_id ' . 'and gr.group_id = ' . $groupid . ' and g.noticeid = n.id ' . 'and n.profile_id = ' . $userid . ' group by g.noticeid) as tmp';
$grade->query($qry);
$notas = array();
if ($grade->fetch()) {
$notas[$grade->total] = $grade->media;
}
$grade->free();
return $notas;
}
