<?php require_once "header.php"; require_once "functions.php"; $obj = new Params(); $filter_result = $obj->get(); if (isset($filter_result['edit'])) { $editing_pers_ides = array(); foreach ($filter_result as $k => $v) { if ($k == 'edit') { continue; } $editing_pers_ides[] = $k; } $persons_edit = get_persons_by_ides($editing_pers_ides); get_form_by_edit($persons_edit); } update($filter_result); require_once "footer.php"; ?>
function show_persons() { $obj = new Params(); $filter = $obj->get(); if (isset($filter["filter"])) { //Get personal date values if ($filter['name']) { $personal .= " `name`='{$filter['name']}' and "; } if ($filter['surname']) { $personal .= " `surname`='{$filter['surname']}' and "; } if ($filter['age']) { $personal .= " `age` BETWEEN '{$filter['age']}' AND "; } else { $personal .= " `age` BETWEEN '0' AND "; } if ($filter['ageto']) { $personal .= " '{$filter['ageto']}' and "; } else { $personal .= " '100' and "; } //Get person category if ($filter['category']) { $cat_id = get_id_by_name('Categories', $filter['category']); } //Get persons marks $filter_status = array(); $filter_status = filter_by_pers_dates($personal); $ides = implode(',', $filter_status); if ($ides) { $pers_ides_str = " and `Pers_ID` IN (" . $ides . ")"; if ($cat_id) { $filter_status = filter_by_category($cat_id, $pers_ides_str); if (filter_by_category($cat_id, $pers_ides_str)) { $ides = implode(',', $filter_status); if ($ides) { $pers_ides_str = " and `Pers_ID` IN (" . $ides . ")"; } } } $subj = get_subjects(); $filter_status_copy = $filter_status; foreach ($subj as $id => $name) { if ($filter["subj" . $id] || $filter["subjto" . $id]) { $marks = subject_marks_limit($name, $filter["subj" . $id], $filter["subjto" . $id], $pers_ides_str); $marks_filter[$id] = filter_by_subjects_marks($marks); } if ($marks_filter[$id] === NULL) { $marks_filter[$id] = $filter_status; } $filter_status_copy = array_uintersect($filter_status_copy, $marks_filter[$id], "strcasecmp"); } $filter_status = $filter_status_copy; } //Get personal dates $persons = get_persons_by_ides($filter_status); show_filter_result($persons); } }