Exemplo n.º 1
0
 $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) {
Exemplo n.º 2
0
 $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;