}
break;
case 'search':
break;
}
}
if (isset($_POST['Submit'])) {
$action = $_POST['Submit'];
switch ($action) {
case $_L['INV_addroomchg']:
if ($id) {
$checkin = $_POST['checkindate'];
$checkout = $_POST['checkoutdate'];
$userid = $_SESSION["userid"];
$details = array();
$resid = get_ReservationID_By_BillID($id);
$resdetailcount = reservation_details_byResID($resid, $details);
if ($resid) {
foreach ($details as $dt) {
$rateid = $dt['ratesid'];
$roomid = $dt['roomid'];
add_roomcharges($id, $roomid, $rateid, $checkin, $checkout, $userid);
}
} else {
add_roomcharges($id, $roomid, $rateid, $checkin, $checkout, $userid);
}
}
break;
case $_L['BTN_update']:
//filed validations
$fv = new formValidator();
/**
* @ingroup INVOICE_MANAGEMENT
* Delete prorated invoice
* @param $billid [in] bill id
*/
function delete_billing($billid)
{
global $conn;
if (!$billid) {
return;
}
if (!$conn) {
$conn = connect_Hotel_db(HOST, USER, PASS, DB, PORT);
}
$resid = get_ReservationID_By_BillID($billid);
$bid = get_book_id($resid);
$rcptCount = get_receiptsCount_byBillID($billid);
$transCount = get_transactionsCount_byBillID($billid);
//echo "reservation id ".$resid."<br/>";
//echo "booking id ".$bid."<br/>";
//echo "receipt count ".$rcptCount."<br/>";
//echo "trans count ".$transCount."<br/>";
$sql = "";
$sql .= "DELETE b,bk,rc,rv,tr FROM bills b ";
$sql .= "LEFT JOIN booking bk ON b.bill_id = bk.bill_id ";
$sql .= "LEFT JOIN receipts rc ON b.bill_id = rc.bill_id ";
$sql .= "LEFT JOIN reservation rv ON b.bill_id = rv.bill_id ";
$sql .= "LEFT JOIN transactions tr ON b.bill_id = tr.bill_id ";
$sql .= "WHERE b.bill_id=" . $billid;
$stmt = $conn->prepare($sql);
$res = $stmt->execute();
$sql2 = "DELETE FROM reservation_details WHERE reservation_id='" . $resid . "'";
$stmt = $conn->prepare($sql2);
$res = $stmt->execute();
}
