<?php
$sql = "SELECT person_id FROM persons";
$stid = oci_parse($conn, $sql);
$res = oci_execute($stid);
while ($row = oci_fetch_array($stid, OCI_ASSOC)) {
foreach ($row as $id) {
echo "<option value={$id}>{$id}</option>";
}
}
?>
</select>
<input type="submit" name="search_person" value="Search">
</form>
<?php
searchPerson($conn);
?>
<br /><form action="" method="post">
<b>Edit user information</b><br />
Search username: <select name="search_username">
<?php
$sql = "SELECT user_name FROM users";
$stid = oci_parse($conn, $sql);
$res = oci_execute($stid);
while ($row = oci_fetch_array($stid, OCI_ASSOC)) {
foreach ($row as $name) {
echo "<option value='" . $name . "'>{$name}</option>";
}
}
?>
//require_once '../../../salary/payment/class/payments.class.php';
require_once inc_response;
require_once inc_dataReader;
require_once inc_PDODataAccess;
$task = isset($_POST["task"]) ? $_POST["task"] : (isset($_GET["task"]) ? $_GET["task"] : "");
switch ($task) {
case "save":
saveData();
case "delete":
deleteData();
case "select":
selectData();
case "gridSelect":
gridSelect();
case "searchPerson":
searchPerson();
case "searchRetPerson":
searchRetPerson();
case "changePT":
changePT();
//------------------------------------
//------------------------------------
case "selectCourse":
selectCourse();
case "selectEval":
selectEval();
//------------------------------------
//------------------------------------
case "saveIncludeHistory":
saveIncludeHistory();
case "removeIncHistory":
}
/* Magic Begins here! */
extract($_POST);
$data = array();
$results['recordsTotal'] = 0;
$results['recordsFiltered'] = 0;
$searchType = '';
if (isset($type)) {
if ($type == 'person') {
// person search
$searchType = 'person';
}
}
if (isset($term) && isset($location)) {
if ($searchType == 'person') {
$response = json_decode(searchPerson($term, $location, $postal_code, '', ''));
} else {
$response = json_decode(search($term, $location, '', ''));
}
if ($response->results) {
$results['recordsTotal'] = $results['recordsFiltered'] = count($response->results);
} else {
$results['recordsTotal'] = $results['recordsFiltered'] = 0;
}
if (isset($length) && isset($start)) {
if ($searchType == 'person') {
$response = json_decode(search($term, $location, $postal_code, $length, $start));
} else {
$response = json_decode(search($term, $location, $length, $start));
}
}
