/**
* @author thanhtuan
* main detail_Booking method
* @param No
* @return gui information about detail booking of table food of all restaurant.
* */
public function getListAllTablRestaurant()
{
$dao = new TableDAO();
$array = $dao->getAvailableTableAllRestaurants();
$data = "";
$data = $data . " <table>\r\n\t<tr>\r\n\t<th>MÃ BÀN ĂN</th>\r\n\t<th>TÊN KHU VỰC</th>\r\n\t<th>GIÁ THÀNH</th>\r\n\t<th>SỐ NGƯỜI</th>\r\n\t<th>TÌNH TRẠNG</th>\r\n\t<th>NHÀ HÀNG</th>\r\n\t</tr>\r\n\t<tr> ";
foreach ($array as $value) {
$TenKV = isset($value["TenKV"]) ? $value["TenKV"] : "";
$MaBanAn = isset($value["MaBanAn"]) ? $value["MaBanAn"] : "";
$GiaThanh = isset($value["GiaThanh"]) ? $value["GiaThanh"] : "";
$SoNguoi = isset($value["SoLuong"]) ? $value["SoLuong"] : "";
$TinhTrang = isset($value["TinhTrang"]) ? $value["TinhTrang"] : "";
$NhaHang = isset($value["TenNH"]) ? $value["TenNH"] : "";
$data = $data . "<td>{$MaBanAn}</td>";
$data = $data . "<td><a onclick='regionInfoLinkClicked();' href='#'>{$TenKV}</td>";
$data = $data . "<td>{$GiaThanh}</td>";
$data = $data . "<td>{$SoNguoi}</td>";
if ($TinhTrang == "0") {
$data = $data . "<td>Chưa đặt</td>";
} else {
$data = $data . "<td><a onclick='bookingDetailLinkClicked();' href='#'>Chi tiết</a></td>";
}
$data = $data . "<td>{$NhaHang}</td>";
$data = $data . "</tr>";
}
$data = $data . "</table>";
$data = $data . "</div>";
return $data;
}
/**
* main save_Booking method
* @param $bookingInfo array customer info: customer name, id number, phone number
* @param $tableId array
* @param $fromDate array
* @param $toDate array
* @author hathao298@gmail.com, thanhtuan
* @return return true if success else return false
* * */
public function saveBooking($bookingInfo, $tableId, $fromDate, $toDate)
{
try {
//check table id
$dao = new TableDAO();
$price = array();
foreach ($tableId as $id) {
$table = $dao->getTableInfo($id);
if ($table == null) {
return "invalid";
} else {
array_push($price, $table["GiaThanh"]);
}
}
// prepare data to saving
$arrBookingInfo = array();
$arrBookingDetailInfo = array();
for ($i = 0; $i < sizeof($tableId); $i++) {
$bookingDetailInfo = array("MaBanAn" => $tableId[$i], "MaNH" => $bookingInfo["MaNH"], "MaPhieu" => $bookingInfo["MaPhieu"], "GiaThanh" => $price[$i], "TuThoiGian" => $fromDate[$i], "DenThoiGian" => $toDate[$i]);
array_push($arrBookingDetailInfo, $bookingDetailInfo);
}
//save data
try {
$dao = new BookingDAO();
return $dao->save($bookingInfo, $arrBookingDetailInfo);
} catch (Exception $e) {
return false;
}
return false;
} catch (Exception $e) {
echo "Not Connect to database";
}
return false;
}
