public function retrieveCaptainFromBook($captain_id) { $db = DatabaseBook::getInstance(); $mysqli = $db->getConnection(); $query = "SELECT * FROM ea_users WHERE id = {$captain_id}"; $result = $mysqli->query($query); $counter = 0; $captList = array(); while ($news_row = $result->fetch_array()) { $captain = new Captain(); $captain->setFirstName($news_row['first_name']); $captain->setLastName($news_row['last_name']); $captain->setEmail($news_row['email']); $captain->setStreet($news_row['address']); $captain->setCity($news_row['city']); $captain->setState($news_row['state']); $captain->setZip($news_row['zip_code']); $captain->setCaptainId($news_row['id']); $captList[$counter] = $captain; $counter++; } return $captList; }
public function retrieveAppointments($user_type, $email, $appointment_cat) { include_once "DatabaseBook.class.php"; $db = DatabaseBook::getInstance(); $mysqli = $db->getConnection(); if ($user_type == "Captain") { $query = "select * from ea_appointments as ap inner join ea_users as usr on ap.id_users_providers = usr.id where usr.email = '{$email}'"; } elseif ($user_type == "Customer") { $query = "select * from ea_appointments as ap inner join ea_users as usr on ap.id_users_customer = usr.id where usr.email = '{$email}'"; } if ($appointment_cat == "past") { $query .= " AND ap.end_datetime < curdate()"; } elseif ($appointment_cat == "upcoming") { $query .= " AND ap.start_datetime > curdate()"; } $result = $mysqli->query($query); $counter = 0; $list = array(); while ($news_row = $result->fetch_array()) { $appointment = new Appointment(); //$appointment = $appointment->createObject($appointment,$news_row); $appointment->setAppointmentId($news_row[0]); $appointment->setAppointmentDate($news_row['start_datetime']); // $appointment -> setAppointmentDeposit($news_row['appointment_deposit']); // $appointment -> setHullId($news_row['hull_id']); $appointment->setUserId($news_row['id_users_customer']); $appointment->setCaptainId($news_row['id_users_provider']); // $appointment -> setAppointmentStatus($news_row['appointment_status']); $list[$counter] = $appointment; $counter++; } return $list; }