/**
* Updates tables customers and payments for given $_GET['user_selected']
* @return array $customerUpdate with new list of customers
*/
public static function UpdateUsers()
{
$conn = DB::GetConnection();
$user_selected = $_GET['user_selected'];
$select_status = (int) $_POST['select_status'];
$stmt = $conn->prepare("UPDATE customers SET customers.customer_name = ?,customers.customer_lastname = ?,customers.customer_phone = ? WHERE customers.customer_id = ?");
$stmt->bindParam(1, $_POST['upd_firstname'], \PDO::PARAM_STR);
$stmt->bindParam(2, $_POST['upd_lastname'], \PDO::PARAM_STR);
$stmt->bindParam(3, $_POST['upd_phone'], \PDO::PARAM_STR);
$stmt->bindParam(4, $user_selected, \PDO::PARAM_INT);
$stmt->execute();
$stmt = $conn->prepare("UPDATE payments SET payments.payment_status_id = ? WHERE payments.payment_customer = ?");
$stmt->bindParam(1, $select_status);
$stmt->bindParam(2, $user_selected);
$stmt->execute();
return $customerUpdate = Admin::ViewUsers(true);
}
Session::DestroySession();
}
if (isset($_POST['confirm'])) {
$customerUpdate = AdminClass::UpdateUsers();
header("Location: Admin.php");
} else {
if (isset($_POST['cancel'])) {
header("Location: Admin.php");
} else {
if (isset($_GET['delete'])) {
AdminClass::DeleteUsers();
header("Location: Admin.php");
}
}
}
$customers = AdminClass::ViewUsers();
?>
<form action='' method='get' id='admin_form'></form>
<table class='datatable'>
<caption>
Users List:
</caption>
<tr>
<th scope='col'>Select User: </th>
<th scope='col'>Firstname: </th>
<th scope='col'>Lastname: </th>
<th scope='col'>Phone: </th>
<th scope='col'>Check in: </th>
<th scope='col'>Check out: </th>
<th scope='col'>Room: </th>
