$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' />";
