Term Query

Hi.
In term.php the query prepared to find Terms uses table name without prefix to specify fields. As elsewhere the method getDatabaseTableName() should be used.
Best wishes.

Actually it's just the where clause
$where = '1=1';
if ($idProject) $where .= ' AND term.idProject = '.$idProject;
if ($periodType) {
$start=date('Y-m-d');
$end=date('Y-m-d');
if ($periodType=='year') {
$start=$paramYear . '-01-01';
$end=$paramYear . '-12-31';
} else if ($periodType=='month') {
$start=$paramYear . '-' . (($paramMonth<10)?'0':'') . $paramMonth . '-01';
$end=$paramYear . '-' . (($paramMonth<10)?'0':'') . $paramMonth . '-' . date('t',mktime(0,0,0,$paramMonth,1,$paramYear));
} if ($periodType=='week') {
$start=date('Y-m-d', firstDayofWeek($paramWeek, $paramYear));
$end=addDaysToDate($start,6);
}
$where.=" AND ( term.date >= '" . $start . "'";
$where.=" and term.date <='" . $end . "' )";
}

As you can see date and idProject are prefixed "term.".
My fix

//On construit la clause where
$term = new Term();
$termAlias = $term->getDatabaseTableName();
$where = '1=1';
if ($idProject)
$where .= " AND ".$termAlias . ".idProject = " . $idProject;
if ($periodType) {
$start = date('Y-m-d');
$end = date('Y-m-d');
if ($periodType == 'year') {
$start = $paramYear . '-01-01';
$end = $paramYear . '-12-31';
} else if ($periodType == 'month') {
$start = $paramYear . '-' . (($paramMonth < 10) ? '0' : '') . $paramMonth . '-01';
$end = $paramYear . '-' . (($paramMonth < 10) ? '0' : '') . $paramMonth . '-' . date('t', mktime(0, 0, 0, $paramMonth, 1, $paramYear));
} if ($periodType == 'week') {
$start = date('Y-m-d', GlbCalendar::istanza()->firstDayofWeek($paramWeek, $paramYear));
$end = GlbCalendar::istanza()->addDaysToDate($start, 6);
}
$where.=" AND ( ".$termAlias . ".date >= '" . $start . "'";
$where.=" and ". $termAlias . ".date <='" . $end . "' )";
}

$termList = $term->getSqlElementsFromCriteria(null, false, $where);