$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) { $status = $_L['STS_open']; } elseif ($receipts[$j]['status'] == STATUS_CLOSED) { $status = $_L['STS_closed'];
echo "<tr id=\"row" . $j . "\" onmouseover=\"javascript:setColor('" . $j . "')\" onmouseout=\"javascript:origColor('" . $j . "')\" bgcolor=\"#EEEEF8\">"; } echo "<td colspan=2> <del>" . $bill['rcpts'][$i]['CCnum'] . "</del> </td>"; echo "<td> <del>" . $bill['rcpts'][$i]['CVV'] . "</del> </td>"; } else { echo "<td rowspan=2>"; echo "<a href=\"index.php?menu=invoice&id=" . $bill['bill_id'] . "&action=void&pid=" . $bill['rcpts'][$i]['receipt_id'] . "\"><img src=\"images/button_remove.png\" width=\"16\" height=\"16\" border=\"0\" title=\"void transaction\"/></a></td>"; echo "</td>"; echo "<td rowspan=2>"; echo trim($bill['rcpts'][$i]['rcpt_date']); echo "</td>"; echo "<td>"; print get_foptext($bill['rcpts'][$i]['fop']); echo "</td>"; echo "<td>"; print get_creditcardString($bill['rcpts'][$i]['cctype']); $paytotal += $bill['rcpts'][$i]['amount']; $displaytot = $bill['rcpts'][$i]['amount'] * $bill['rcpts'][$i]['exrate']; $payedDisplayArr[$bill['rcpts'][$i]['tgtCurrency']] += $displaytot; echo "</td>"; echo "<td> " . $bill['rcpts'][$i]['expiry'] . "</td>"; echo "<td rowspan=2>"; // only first empty authorization number will be blank, as this will be for cc payments // auto submitted. If partial payments, they will need to process 1 at a time anyway. //$bill['rcpts'][$i]['auth']; if ($bill['rcpts'][$i]['auth'] != '' || $add_authid) { echo $bill['rcpts'][$i]['auth']; } else { $add_authid = 1; echo "<input type='hidden' name='AUTH_RCPTID' id='AUTH_RCPTID' value='" . $bill['rcpts'][$i]['receipt_id'] . "' />"; echo "<input type='text' size='8' maxlength='200' name='AUTH_VALUE' id='AUTH_VALUE' />";