include_once dirname(__FILE__) . "/../login_check.inc.php";
include_once dirname(__FILE__) . "/../queryfunctions.php";
include_once dirname(__FILE__) . "/../functions.php";
include_once dirname(__FILE__) . "/../dailyfunc.php";
include_once dirname(__FILE__) . "/../lang/lang_en.php";
$lang = get_language();
load_language($lang);
$logofile = Get_LogoFile();
access("billing");
$bill = array();
$book = array();
$guest = array();
$inv = $_GET['inv'];
get_bill($inv, $bill);
if ($bill['book_id']) {
get_booking($bill['book_id'], $book);
} else {
if ($bill['reservation_id']) {
get_reservation($bill['reservation_id'], $book);
}
}
if ($book['guestid']) {
get_guest($book['guestid'], $guest);
}
// Default page size A4 - 210mm x 297mm
// Header is set to 60mm
// Footer is set to 27mm
// body of invoice is set to 210mm
// Rough rules of thumb
// font 12px has 59 lines
// font 13px has 52 lines
$id = $book['bill_id'];
get_bill($id, $bill);
$rid = $bill['reservation_id'];
}
}
// if the reservation id is found, load the reservation
if ($rid) {
get_reservation($rid, $res);
// if the bill is not loaded, load the invoice id from the reservation
// load the bill, then attempt to load the booking detail that goes
// with it.
if (!$id && sizeof($bill) == 0) {
$id = $res['bill_id'];
get_bill($id, $bill);
$bid = $bill['book_id'];
get_booking($bid, $book);
}
}
$guestid = $bill['guestid'];
if (!$guestid && $book['guestid']) {
$guestid = $book['guestid'];
}
if (!$guestid && $res['guestid']) {
$guestid = $res['guestid'];
}
if ($book['checkindate']) {
$checkin = $book['checkindate'];
}
if ($book['checkoutdate']) {
$checkout = $book['checkoutdate'];
}
$doctype = $_L['ADP_passport'];
} elseif ($documents[$i]['doctype'] == DOC_DL) {
$doctype = $_L['ADP_driverlicense'];
} elseif ($documents[$i]['doctype'] == DOC_MILITARY) {
$doctype = $_L['ADP_military'];
} elseif ($documents[$i]['doctype'] == DOC_NID) {
$doctype = $_L['ADP_nid'];
} elseif ($documents[$i]['doctype'] == DOC_VISA) {
$doctype = $_L['ADP_visa'];
}
}
$docid = $documents[$i]['docnumber'];
$nationality = $documents[$i]['nationality'];
}
//Get the booking details
get_booking($bid, $res);
echo "<tr >";
echo "<td align=right>";
echo "<table width=100%><tr><td width='33%'></td><td width='33%' align=center><h1>" . $hotel . "</h1></td>";
echo "<td align=right rowspan=2><img src='" . $logofile . "' title='" . $logofile . "' width='70' height='60mm' border='0' /></td></tr>";
echo "</table>";
echo "</tr>";
?>
<tr><td align=center>CUSTOM FORM<br/></td></tr>
<tr><td align=center><h3><?php
echo $_L['FRM_guestinfotitle'];
?>
</h3></td></tr>
<tr><td>
$finaldate = optional_param('finalDate', 1, PARAM_INT);
$days = optional_param('days', null, PARAM_TEXT);
$frequency = optional_param('frequency', 0, PARAM_INT);
$inicio = optional_param('inicio', null, PARAM_TEXT);
$termino = optional_param('termino', null, PARAM_TEXT);
$nombresala = optional_param('nombresala', null, PARAM_TEXT);
$nombremodulo = optional_param('nombremodulo', null, PARAM_TEXT);
$resources = optional_param('resources', "prueba", PARAM_TEXT);
// Callback para from webpage
$callback = optional_param('callback', null, PARAM_RAW_TRIMMED);
// Headers
header('Content-Type: text/javascript');
header('Cache-Control: no-cache');
header('Pragma: no-cache');
if ($action == "getbooking") {
$output = get_booking($type, $campusid, $initialDate, $multiply, $size, $finaldate, $days, $frequency);
$disponible = array();
$modulos = array();
$salas = array();
$ocupado = array();
$agregadosModulos = array();
$agregadosSalas = array();
$output2 = $output;
$contador = 0;
foreach ($output as $disponibilidad) {
if (!in_array($disponibilidad->moduloid, $agregados)) {
$agregados[] = $disponibilidad->moduloid;
$modulos[] = array("id" => $disponibilidad->moduloid, "name" => $disponibilidad->modulonombre, "horaInicio" => $disponibilidad->moduloinicio, "horaFin" => $disponibilidad->modulofin);
}
if ($contador > 0) {
if ($anterior != $disponibilidad->salaid) {
update_room_status($bookroom['roomid'], LOCKED);
}
}
}
break;
case 'List':
break;
case 'Find':
break;
}
}
if (!$book_id && $_POST['book_id']) {
$book_id = $_POST['book_id'];
}
if ($book_id) {
get_booking($book_id, $bookings);
} else {
if (!$book_id && $res_id) {
get_booking_byresid($res_id, $details_id, $bookings);
if ($room_id) {
update_room_status($room_id, BOOKED);
}
} else {
if (!$book_id && $guestid) {
get_booking_byguest($guestid, $bookings);
}
}
}
if ($bookings['guestid']) {
$readonly = "readonly";
} else {
<div class="row">
<div class="col s12">
<!-- Tabel Stok-->
<table id="tabel-booking" class="tabel centered">
<thead>
<tr>
<th data-field="id-booking">ID Booking</th>
<th data-field="id-pengguna">ID Pengguna</th>
<th data-field="id-atk">ID ATK</th>
<th data-field="tanggal-booking">Tanggal Booking</th>
<th data-field="jumlah-atk">Jumlah</th>
</tr>
</thead>
<tbody>
<?php
foreach (get_booking() as $data) {
?>
<tr class="data-row">
<td><?php
echo $data['bid'];
?>
</td>
<td><?php
echo $data['b_uid'];
?>
</td>
<td><?php
echo $data['b_aid'];
?>
</td>
<td><?php
/**
* Get the booking detail by the guest id, first check any open reservation that is due today
* if found, use this reservation, if not found then create a new booking filling in the guest
* detail, but the booking will not be created like with a reservation.
* @ingroup BOOKING_MANAGEMENT
* @param $guestid [in] Guest ID
* @param $booking [in/out] result array
*
* @return number of elements in booking
* @todo complete this function.
*/
function get_booking_byguest($guestid, &$booking)
{
global $conn;
if (!$conn) {
$conn = connect_Hotel_db(HOST, USER, PASS, DB, PORT);
}
if (!$conn) {
return 0;
}
$todaystart = date("d/m/Y") . " 00:00";
$todayend = date("d/m/Y") . " 23:59";
$rightnow = date("d/m/Y H:i");
$booking = array();
$sql = "select book_id from booking where guestid=" . $guestid;
$sql .= " and checkindate >= " . date_to_dbformat("DD/MM/YYYY HH:MI", 1, $todaystart);
$sql .= " and checkoutdate <= " . date_to_dbformat("DD/MM/YYYY HH:MI", 1, $todayend);
$stmt = $conn->prepare($sql);
$results = $stmt->execute();
if ($results && ($row = $stmt->fetch())) {
return get_booking($row['book_id'], $booking);
}
$guest = array();
if (findguestbyid($guestid, $guest)) {
$booking['book_id'] = 0;
$booking['guestid'] = $guestid;
$booking['reservation_id'] = 0;
$booking['bill_id'] = 0;
$booking['no_adults'] = 1;
$booking['no_child1_5'] = 0;
$booking['no_child6_12'] = 0;
$booking['no_babies'] = 0;
$booking['checkindate'] = $rightnow;
$booking['checkoutdate'] = '';
$booking['checkedin_by'] = 0;
$booking['checkedout_by'] = 0;
$booking['checkedout_date'] = 0;
$booking['checkedin_date'] = '';
$booking['cctype'] = '';
$booking['CCnum'] = '';
$booking['expiry'] = '';
$booking['CVV'] = '';
$booking['pp_no'] = $guest['pp_no'];
$booking['idno'] = $guest['idno'];
$booking['address'] = $guest['address'];
$booking['town'] = $guest['town'];
$booking['postal_code'] = $guest['postal_code'];
$booking['phone'] = $guest['phone'];
$booking['email'] = $guest['email'];
$booking['mobilephone'] = $guest['mobilephone'];
$booking['eBridgeID'] = $guest['eBridgeID'];
$booking['IM'] = $guest['IM'];
$booking['nationality'] = $guest['nationality'];
$booking['countrycode'] = $guest['countrycode'];
$booking['nation'] = Get_Country($guest['nationality']);
$booking['country'] = Get_Country($guest['countrycode']);
$booking['instructions'] = '';
$booking['guestname'] = trim(trim($guest['firstname']) . " " . trim($guest['middlename']) . " " . trim($guest['lastname']));
}
return sizeof($booking);
}
$checkout = $res['checkoutdate'];
}
if (!$roomid) {
$roomid = $res['roomid'];
}
if (!$roomtypeid) {
$roomtypeid = $res['roomtypeid'];
}
if (!$ratesid) {
$ratesid = $res['ratesid'];
}
}
$input = "/hotelmis/webtoPDF.php?TMPL=reservation_summary.php&PR=1&rid=" . $resid;
}
if ($bid) {
if (get_booking($bid, $res)) {
$vch = $res['voucher_no'];
if (!$guestid) {
$guestid = $res['guestid'];
}
if (!$checkin) {
$checkin = $res['checkindate'];
}
if (!$checkout) {
$checkout = $res['checkoutdate'];
}
if (!$roomid) {
$roomid = $res['roomid'];
}
if (!$roomtypeid) {
$roomtypeid = $res['roomtypeid'];
