public static function getReservationById($id)
{
$connection = DBUtil::connectDB();
$result = mysql_query("select * from reservation where id={$id}", $connection);
$reservations = [];
while ($row = mysql_fetch_array($result)) {
$r['customerId'] = $row['customer_id'];
$r['consumeSet'] = ConsumeSetDBUtil::getSetById($row['consume_set_id']);
$r['club'] = ClubDBUtil::getClubById($row['club_id']);
$r['status'] = $row['status'];
$r['id'] = $row['id'];
$reservations[] = $r;
}
mysql_close();
return $reservations;
}
private function checkSet($setId)
{
$setAry = ConsumeSetDBUtil::getSetById($setId);
if ($setAry == NULL || empty($setAry)) {
throw new Exception('套餐不存在', 1112);
}
return $setAry;
}
