/**
* Fills filter table by existing data
*/
public static function resetFilters()
{
/** @var \samson\activerecord\materialfield $filters Array of materialfield objects to fill filter table */
$filters = null;
// TODO: add filter generation by filter type
// check if such data exists in materialfield table
if (dbQuery('materialfield')->join('field')->cond('filtered', 1)->group_by('Value')->exec($filters)) {
// if yes - generate `filter` table
db()->simple_query('TRUNCATE TABLE `' . dbMySQLConnector::$prefix . 'filter`');
foreach ($filters as $filter) {
/** @var \samson\activerecord\filter $newFilter */
$newFilter = new filter();
$newFilter->field_id = $filter->FieldID;
$newFilter->value = $filter->Value;
$newFilter->save();
}
}
}
}
if ($_POST["action"] == 'save') {
if ($_REQUEST["filter_id"] != '') {
if ($filter->load($_REQUEST["filter_id"])) {
$filter->updatevon = $user;
} else {
die('Fehlgeschlagen:' . $filter->errormsg);
}
}
$filter->kurzbz = $_POST["kurzbz"];
$filter->valuename = $_POST["valuename"];
$filter->sql = $_POST["sql"];
$filter->showvalue = isset($_POST["showvalue"]);
$filter->type = $_POST["type"];
$filter->htmlattr = $_POST["htmlattr"];
if (!$filter->save()) {
$errorstr .= $filter->errormsg;
}
$reloadstr .= "<script type='text/javascript'>\n";
$reloadstr .= "\tparent.frame_filter_overview.location.href='filter_overview.php';";
$reloadstr .= "</script>\n";
//echo '<pre>'.var_dump($filter).'</pre>';
}
}
if (isset($_REQUEST['filter_id']) && (!isset($_REQUEST['neu']) || $_REQUEST['neu'] != "true") && is_numeric($_REQUEST['filter_id'])) {
$filter->load($_REQUEST["filter_id"]);
if ($filter->errormsg != '') {
die($filter->errormsg);
}
}
if ($filter->filter_id > 0) {
