private function userFilter(module_report $report)
{
$this->filter['user'] = false;
$f = $report->getTabFilter();
if (sizeof($f) > 0) {
$filter = [];
$params = [];
$n = 0;
foreach ($f as $field => $value) {
if (array_key_exists($value['f'], $this->cor_query)) {
$value['f'] = $this->cor_query[$value['f']];
}
if ($value['o'] == 'LIKE') {
$filter[] = $value['f'] . ' ' . $value['o'] . ' \'%' . str_replace(["'", '%'], ["\\'", '\\%'], ' :user_filter' . $n) . '%\'';
$params[':user_filter' . $n] = $value['v'];
} elseif ($value['o'] == 'OR') {
$filter[] = $value['f'] . ' ' . $value['o'] . ' :user_filter' . $n;
$params[':user_filter' . $n] = $value['v'];
} else {
$filter[] = $value['f'] . ' ' . $value['o'] . ' :user_filter' . $n;
$params[':user_filter' . $n] = $value['v'];
}
$n++;
}
if (count($filter) > 0) {
$filter_user = array('sql' => implode(' AND ', $filter), 'params' => $params);
$this->filter['user'] = $filter_user;
}
}
return;
}
public function testGetterSetter()
{
$report = new module_report(self::$DI['app'], $this->dmin, $this->dmax, 1, '');
$bool = true;
$report->setPrettyString($bool);
$this->assertEquals($bool, $report->getPrettyString());
$title = 'test';
$report->setTitle($title);
$this->assertEquals($title, $report->getTitle());
$bool = false;
$report->setCsv($bool);
$this->assertEquals($bool, $report->getCsv());
$filter = ['test', 'array'];
$report->setFilter($filter);
$this->assertEquals($filter, $report->getTabFilter());
$periode = "2 years";
$report->setPeriode($periode);
$this->assertEquals($periode, $report->getPeriode());
$postingFilter = 'my posting filter !';
$report->setpostingFilter($postingFilter);
$this->assertEquals($postingFilter, $report->getPostingFilter());
$page = 223;
$limit = 125;
$report->setLimit($page, $limit);
$this->assertEquals($page, $report->getNbPage());
$this->assertEquals($limit, $report->getNbRecord());
$report->setGroupBy($bool);
$this->assertEquals($bool, $report->getGroupBy());
$column = ['col1', 'col2'];
$report->setActiveColumn($column);
$this->assertEquals($column, $report->getActiveColumn());
$report->setConfig($bool);
$report->setPrint($bool);
$report->setHasLimit($bool);
$this->assertFalse($report->getConfig());
$this->assertFalse($report->getPrint());
$this->assertFalse($report->getHasLimit());
$result = ['result', 'result'];
$report->setResult($result);
$this->assertEquals($result, $report->getResult());
$total = 3200;
$report->setTotal($total);
$this->assertEquals($total, $report->getTotal());
$default_display = ['a', 'b', 'c'];
$report->setDefault_display($default_display);
$this->assertEquals($default_display, $report->getDefault_display());
}
