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; }