/** * Displays a filter menu on the screen. * Currently supports status and last name. */ function displayFilterMenu($filterCrieria) { $sessionOptions = pullUniqueValues("mtn_application", "ap_session"); $statusOptions = pullUniqueValues("mtn_application", "ap_status"); $lastNameOptions = pullUniqueValues("mtn_application", "ap_lastname"); echo "\n\n<p style='margin-bottom: 1cm;'> </p>\n"; echo "<form method='post' name='filterSelection'>\n\n"; displaySelectionMenu("Filter by Session:", "filterSession", $sessionOptions, $filterCrieria['ap_session']); displaySelectionMenu("Filter by Status:", "filterStatus", $statusOptions, $filterCrieria['ap_status']); displaySelectionMenu("Filter by Last Name:", "filterLastName", $lastNameOptions, $filterCrieria['ap_lastname']); echo "<input type='submit' name='filter_button' value='Filter'>\n"; echo "</form>\n\n"; }
/** * Displays a filter menu on the screen. * Currently supports status and last name. */ function displayFilterMenu($table_name, $filters) { echo "\n\n<p style='margin-bottom: 1cm;'> </p>\n"; echo "<form method='post' name='filterSelection'>\n\n"; foreach ($filters as $filter) { if ($_POST[$filter["name"]] != "[BLANK]") { $original = trim(sanitize_text_field($_POST[$filter["name"]])); } $options = pullUniqueValues($table_name, $filter['column']); displaySelectionMenu($filter['label'], $filter['name'], $options, $original); } echo "<input type='submit' name='filter_button' value='Filter'>\n"; echo "</form>\n\n"; }