public function update($id)
{
$today = date("Y-m-d H:i:s");
$i = Input::all();
$bookingRemarks = '';
$addition = 0;
$deduction = 0;
if ($i['savethis'] == true) {
$addition -= $i['price_addition'];
$deduction += $i['price_deduction'];
}
$booking = Booking::where('id', $id)->with('reservedRoom.room.roomDetails')->first();
//$booking = ReservedRoom::where('id', $id)->with('room.roomDetails')->first();
$old_status = $booking->status;
$current_price = $booking->price;
$current_price += $addition + $deduction;
if (!empty($booking)) {
$booking->status = $i['status'];
if ($i['status'] == 5) {
$booking->cancelled_at = $today;
$booking->paid = 0;
$booking->price = 0;
$booking->cancelled_remarks = $i['cancelled_remarks'];
} else {
if ($i['status'] == 1) {
$booking->paid = $i['paid'];
} else {
//$booking->paid=0;
$booking->price = $current_price;
$booking->cancelled_remarks = '';
$booking->cancelled_at = '0000-00-00 00:00:00';
}
}
if ($booking->save()) {
if ($i['savethis'] == true) {
$newBookingRemarks = new BookingRemarksHistory();
$newBookingRemarks->additional = $addition;
$newBookingRemarks->deduction = $deduction;
$newBookingRemarks->remarks = $i['bookingremarks'];
$newBookingRemarks->booking_id = $id;
$newBookingRemarks->save();
}
$roomReserved = ReservedRoom::where('booking_id', $booking->id)->get();
foreach ($roomReserved as $rr) {
$rr->status = $i['status'];
$rr->save();
}
$a = new Activity();
$a->actor = Auth::id();
$a->location = 3;
$a->logs = 'Updated booking ID of:' . $booking->id . ' by ' . $booking->firstname . ' ' . $booking->lastname . ' from ' . $this->bookingStatus($old_status) . ' to ' . $this->bookingStatus($booking->status);
//before to after status.
$a->save();
return $booking;
} else {
return '0';
//means failed
}
}
}
$membershipDiscount = null;
if (isset($i['membership_id'])) {
$membership = Customer::where('membership_id', $i['membership_id'])->first();
if ($membership) {
$membershipDiscount = $membership->current_discount;
}
}
$booking = Booking::where('id', $i['booking_id'])->first();
if ($booking) {
$booking->firstname = $i['firstname'];
$booking->lastname = $i['lastname'];
$booking->address = $i['address'];
$booking->contact_number = $i['contact_no'];
$booking->status = 1;
$booking->save();
$reservation = ReservedRoom::where('booking_id', $i['booking_id'])->get();
if (count($reservation) > 0) {
foreach ($reservation as $r) {
$r->firstname = Input::has('firstname') ? $i['firstname'] : 'WALK-IN';
$r->lastname = Input::has('lastname') ? $i['lastname'] : 'WALK-IN';
$r->address = Input::has('address') ? $i['address'] : 'WALK-IN';
$r->contact_number = Input::has('contact_no') ? $i['contact_no'] : 'WALK-IN';
$r->status = 1;
if ($r->save()) {
}
}
}
return $i;
}
});
Route::get('reports', 'ReportsController@index');
