/** * @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; }