<?php
View::composer(array('home', 'registrations.register'), function ($view) {
$all = Registration::get()->sum('tickets');
$today = Registration::where(DB::raw('DATE(registrations.created_at)'), DB::raw('CURDATE()'))->get()->sum('tickets');
$expected = Booking::get()->sum('tickets');
$view->with('registration_count_total', $all)->with('registration_count_today', $today)->with('expected_count', $expected);
});
$smarty->assign('tpl_step', 'edittype');
} else {
if ($request->GetVar('frm_step', 'post') == "savetype") {
$strreservationuntil = "";
if ($request->GetVar('frm_bookingtype', 'post') == "R") {
$reservationuntil = explode(".", $request->GetVar('frm_reservationduration', 'post'));
$strreservationuntil = $reservationuntil[2] . "-" . $reservationuntil[1] . "-" . $reservationuntil[0];
}
$query = sprintf("UPDATE {$tbl_booking} SET booking_type = %s, reservation_until = %s, updated_date = NOW(), fk_updated_user_id = %s WHERE pk_booking_id = %s ", MetabaseGetTextFieldValue($gDatabase, $request->GetVar('frm_bookingtype', 'post')), MetabaseGetTextFieldValue($gDatabase, $strreservationuntil), MetabaseGetTextFieldValue($gDatabase, $request->GetVar('uid', 'session')), MetabaseGetTextFieldValue($gDatabase, $bookid));
$result = MetabaseQuery($gDatabase, $query);
if (!$result) {
$errorhandler->display('SQL', 'editbook.php', $query);
}
} else {
if ($request->GetVar('frm_step', 'post') == "editroom") {
$bookdata = $booking->get($bookingdetailid);
$smarty->assign('tpl_step', 'editroom');
$freerooms[0] = array('roomid' => $bookdata["roomid"], 'name' => $bookdata["room"]);
$freerooms = array_merge($freerooms, $booking->getFreeRooms($bookdata['start'], $bookdata['end']));
$smarty->assign('tpl_rooms', $freerooms);
} else {
if ($request->GetVar('frm_step', 'post') == "saveroom") {
$query = sprintf("UPDATE {$tbl_booking_detail} SET fk_room_id = %s, updated_date = NOW(), fk_updated_user_id = %s WHERE pk_booking_detail_id = %s ", MetabaseGetTextFieldValue($gDatabase, $request->GetVar('frm_room', 'post')), MetabaseGetTextFieldValue($gDatabase, $request->GetVar('uid', 'session')), MetabaseGetTextFieldValue($gDatabase, $bookingdetailid));
$result = MetabaseQuery($gDatabase, $query);
if (!$result) {
$errorhandler->display('SQL', 'editbook.php', $query);
}
} else {
if ($request->GetVar('frm_step', 'post') == "editinfo") {
$smarty->assign('tpl_step', 'editinfo');
} else {
