<?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);
}
}
