PHP Reservation::find方法代码示例

 public function getReservation($id)
 {
     $reservation = Reservation::find($id);
     if (!$reservation) {
         return Redirect::to('admin/reservation');
     }
     $this->layout->body = View::make('admin.reservation')->with('reservation', $reservation);
 }

 public static function cancel_reservation($id)
 {
     $user = self::get_user_logged_in();
     $reservation = Reservation::find($id);
     $date_limit = new DateTime();
     $date_limit->add(new DateInterval('P1D'));
     if ($reservation) {
         if ($reservation->user->id != $user->id && !$user->manager) {
             Redirect::to(\Slim\Slim::getInstance()->urlFor('reservations_index'), array('message' => 'Varausta ei löydy!', 'error' => true));
         } else {
             if ($reservation->reserved_to <= $date_limit) {
                 Redirect::to(\Slim\Slim::getInstance()->urlFor('reservations_index'), array('message' => 'Varauksen voi peruuttaa viimeistään vuorokautta ennen varauksen ajankohtaa', 'error' => true));
             } else {
                 $reservation->delete();
                 Redirect::to(\Slim\Slim::getInstance()->urlFor('reservations_index'), array('message' => 'Varaus peruutettu!'));
             }
         }
     } else {
         Redirect::to(\Slim\Slim::getInstance()->urlFor('reservations_index'), array('message' => 'Varausta ei löydy!', 'error' => true));
     }
 }

 public function getReserveClose($id = null)
 {
     if (!isset($id) or is_null($id)) {
         return Redirect::to('/admin/reserve');
     }
     $query = Reservation::find($id);
     if (is_null($query)) {
         return Redirect::to('/admin/reserve');
     }
     $query->status = 2;
     $query->save();
     return Redirect::to('admin/reserve/' . $id)->with('message', "The reservation has been closed!");
 }

 /**
  * Remove the specified resource from storage.
  *
  * @param  int  $id
  * @return Response
  */
 public function delete($id)
 {
     $this->reservation->find($id)->delete();
     return Redirect::route('admin.reservations.index');
 }

 /**
  * Remove the specified resource from storage.
  * DELETE /reservations/{id}
  *
  * @param  int  $id
  * @return Response
  */
 public function destroy($id)
 {
     Reservation::find($id)->delete();
     return Response::json(['data' => 'Reservation deleted'], 200);
 }

 public function updateMenuReservation()
 {
     $reservation = Reservation::find(Input::get('id'));
     if (!$reservation) {
         return Redirect::back()->withErrors('Could not find reservation.');
     }
     //$reservation->menus()->detach();
     //$reservation->items()->detach();
     $date1 = new DateTime($reservation->reservation_start);
     $date2 = new DateTime($reservation->reservation_end);
     $diff = $date2->diff($date1)->format("%a");
     $diff += 1;
     $date1 = date_format($date1, 'l, jS F Y');
     $date2 = date_format($date2, 'l, jS F Y');
     $id = Input::get('id');
     $total_price = 0;
     $package_price = 0;
     $pricezs = 0;
     $qty = Input::get('quantity');
     $model = Input::get('model');
     $invid = Input::get('invId');
     $pricey = Input::get('pricey');
     foreach ($reservation->menu() as $value) {
         $total_price += $value->price;
     }
     foreach ($reservation->item as $value) {
     }
     for ($i = 0; $i < count($qty); $i++) {
         if ($qty[$i] > 0) {
             $reservation->items()->attach($invid[$i], ['qty' => $qty[$i]]);
             $pricezs = $pricezs + (int) $pricey[$i] * $qty[$i];
         }
     }
     for ($index = 1; $index <= $diff; $index++) {
         if (count(Input::get('menu' . $index)) > 0) {
             foreach (Input::get('menu' . $index) as $menu) {
                 $reservation->menus()->attach($menu, ['day' => $index]);
                 $price = Menu::find($menu);
                 $total_price += $price->price;
             }
         }
         if (count(Input::get('package' . $index)) > 0) {
             foreach (Input::get('package' . $index) as $package) {
                 foreach (DB::table('menu_package')->where('package_id', '=', $package)->get() as $fuckage) {
                     $reservation->menus()->attach($fuckage->menu_id, ['day' => $index, 'package' => $package]);
                 }
                 $price = Packages::find($package);
                 $package_price += $price->price;
             }
         }
     }
     $reservation->net_total = $total_price * $reservation->pax + $package_price + $pricezs;
     if ($reservation->save()) {
         return Redirect::back()->with('flash_message', 'Reservation has been saved!');
     } else {
         return Redirect::back()->withErrors('Could not update reservation');
     }
 }

 /**
  * Cancel the reservation with id $id by deleting it from database.
  * @param $clustername : the cluster's name
  * @param $id : the reservation's id
  */
 public function deleteReservation(Cluster $cluster, $id)
 {
     //TODO cluster not used with a valid cluster anyone can delete any reservation
     $reservation = Reservation::find($id);
     if (isset($reservation)) {
         $reservation->delete();
     } else {
         return $this->_sendErrorMessage(404, "Reservation.NotFound", "Reservation not found.");
     }
 }

$rsv_id = 0;
$rsv = new Reservation();
try {
    $rsv_id = $rsv->create($fields);
    $success = true;
    $message = 'New reservation creation is complete.<br>';
    echo $message;
} catch (Exception $e) {
    $success = false;
    $message = $e->getMessage();
    echo "Creating a new reservation Error: " . $message . "<br>";
}
echo ($success == true ? "SUCCESS" : "FAILURE") . "<br>";
try {
    echo "<br>Testing find reservation:<br>";
    $success = $rsv->find($rsv_id);
    print_r($rsv->get_reservation_info());
    echo "<br>";
    echo $rsv->get_reservation_info_json();
    echo "<br>";
} catch (Exception $e) {
    $success = false;
    $message = $e->getMessage();
    echo "Find reservation Error: " . $message . "<br>";
}
echo ($success == true ? "SUCCESS" : "FAILURE") . "<br>";
try {
    echo "<br>Testing find reservation by restaurant_id and user_id:<br>";
    $success = $rsv->find_by_restaurant_and_user(3, 1, '01-02-2015');
    print_r($rsv->get_reservation_info());
    echo "<br>";