$objPHPExcel->getActiveSheet()->setCellValue('I1', "Card Type"); $objPHPExcel->getActiveSheet()->setCellValue('J1', "Card Number"); $objPHPExcel->getActiveSheet()->setCellValue('K1', "Auth"); $objPHPExcel->getActiveSheet()->setCellValue('L1', "Transaction Date"); $objPHPExcel->getActiveSheet()->setCellValue('M1', "Source Currency"); $objPHPExcel->getActiveSheet()->setCellValue('N1', "Target Currency"); $objPHPExcel->getActiveSheet()->setCellValue('O1', "Exchange Rate"); $objPHPExcel->getActiveSheet()->setCellValue('P1', "Invoice Status"); $k = 2; for ($j = 0; $j < $rcpt_cnt; $j++) { $objPHPExcel->getActiveSheet()->setCellValue('A' . $k, $receipts[$j]['receiptNo']); $objPHPExcel->getActiveSheet()->setCellValue('B' . $k, $receipts[$j]['invoiceNo']); $objPHPExcel->getActiveSheet()->setCellValue('C' . $k, get_guestname($receipts[$j]['guestid'])); $objPHPExcel->getActiveSheet()->setCellValue('D' . $k, $receipts[$j]['invoiceDate']); $objPHPExcel->getActiveSheet()->setCellValue('E' . $k, $receipts[$j]['receiptDate']); $objPHPExcel->getActiveSheet()->setCellValue('F' . $k, get_bookingvoucher($receipts[$j]['bookID'])); $objPHPExcel->getActiveSheet()->setCellValue('G' . $k, $receipts[$j]['amount']); $objPHPExcel->getActiveSheet()->setCellValue('H' . $k, get_foptext($receipts[$j]['formOfPayment'])); $objPHPExcel->getActiveSheet()->setCellValue('I' . $k, get_creditcardString($receipts[$j]['ccType'])); $cardnum = ''; if ($receipts[$j]['ccNumber'] != "") { $cardnum = mask_cardnumber($receipts[$j]['ccNumber']); } $objPHPExcel->getActiveSheet()->setCellValue('J' . $k, $cardnum); $objPHPExcel->getActiveSheet()->setCellValue('K' . $k, $receipts[$j]['auth']); $objPHPExcel->getActiveSheet()->setCellValue('L' . $k, $receipts[$j]['createdDate']); $objPHPExcel->getActiveSheet()->setCellValue('M' . $k, $receipts[$j]['srcCurrency']); $objPHPExcel->getActiveSheet()->setCellValue('N' . $k, $receipts[$j]['tgtCurrency']); $objPHPExcel->getActiveSheet()->setCellValue('O' . $k, $receipts[$j]['exrate']); $status = $invoices[$j]['status']; if ($receipts[$j]['status'] == STATUS_OPEN) {
$checkindate = $_POST["checkindate"]; $checkoutdate = $_POST["checkoutdate"]; $roomid = $_POST["roomid"]; $roomtypeid = $_POST["roomtypeid"]; $ratesid = $_POST["ratesid"]; $instr = $_POST["instructions"]; $checkedin_by = $_POST["checkedin_by"]; $checkedout_by = $_POST["checkedout_by"]; $checkedout_date = $_POST["checkedout_date"]; $checkedin_date = $_POST["checkedin_date"]; $CCnum = $_POST["CCnum"]; $cctype = $_POST["cctype"]; $expiry = $_POST["expiry"]; $CVV = $_POST["CVV"]; $details_id = isset($_POST['res_det_id']) ? intval($_POST['res_det_id']) : 0; $voucher_no = get_bookingvoucher($book_id); $book_status = get_bookingstatus($book_id); if (!empty($book_id)) { get_booking($book_id, $bookroom); } if (!$ratesid && $res_id) { $ratesid = get_reservationrate($res_id); } if (!$ratesid && $roomtypeid) { $ratesid = get_RateID_byRoomTypeID($roomtypeid); } if (!$ratesid && $roomid) { $ratesid = get_RateID_byRoomID($roomid); } if ($action == $_L['REG_register']) { $book_status = BOOK_REGISTERED;