<?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 {