$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'];
} elseif ($receipts[$j]['status'] == STATUS_CANCEL) {
$status = $_L['STS_cancel'];
} elseif ($receipts[$j]['status'] == STATUS_VOID) {
// end of lines print the footer
if ($lc != 0 && $lc % $LC == 0) {
print_customfooter($pg, $px, $lc);
$pg++;
$lc = 0;
continue;
}
if ($lc == 0) {
print_customheader($logofile, $px, $lc);
}
echo "<tr style=\"border-width:2px; border-color:#000\\ border-style:solid\"> <td>" . $bill['rcpts'][$j]['rcpt_date'] . "</td>";
echo "<td>" . get_foptext($bill['rcpts'][$j]['fop']);
echo "</td>";
echo "<td>" . $bill['rcpts'][$j]['name'] . "</td>";
if ($bill['rcpts'][$j]['fop'] == FOP_CC) {
echo "<td>" . mask_cardnumber($bill['rcpts'][$j]['CCnum']) . "</td>";
} else {
echo "<td>" . $bill['rcpts'][$j]['CCnum'] . "</td>";
}
echo "<td></td>";
echo "<td></td>";
echo "<td>" . sprintf("%02.2f", $bill['rcpts'][$j]['amount']) . " " . $bill['rcpts'][$j]['srcCurrency'] . "</td>";
echo "</tr>";
$total -= $bill['rcpts'][$j]['amount'];
$lc++;
// Next line
$j++;
// Next receipt item
}
/** @endcond */
// print the receipts header
// end of lines print the footer
if ($lc != 0 && $lc % $LC == 0) {
print_customfooter($pg, $px, $lc);
$pg++;
$lc = 0;
continue;
}
if ($lc == 0) {
print_customheader($logofile, $px, $lc);
}
echo "<tr> <td style=\"border-left:1pt solid black;\">" . $bill['rcpts'][$j]['rcpt_date'] . "</td>";
echo "<td style=\"border-left:1pt solid black;\">" . $bill['rcpts'][$j]['name'];
echo "</td>";
echo "<td style=\"border-left:1pt solid black;\">" . get_foptext($bill['rcpts'][$j]['fop']) . "</td>";
if ($bill['rcpts'][$j]['fop'] == FOP_CC) {
echo "<td colspan=3 style=\"border-left:1pt solid black;\">" . mask_cardnumber($bill['rcpts'][$j]['CCnum']) . "</td>";
} else {
echo "<td colspan=3 style=\"border-left:1pt solid black;\">" . $bill['rcpts'][$j]['CCnum'] . "</td>";
}
echo "<td align=right colspan=1 style=\"border-left:1pt solid black; border-right:1pt solid black;\" >" . sprintf("%02.2f", $bill['rcpts'][$j]['amount']) . " " . $bill['rcpts'][$j]['srcCurrency'] . "</td>";
echo "</tr>";
$totalrcpts += $bill['rcpts'][$j]['amount'];
$total -= $bill['rcpts'][$j]['amount'];
$lc++;
// Next line
$j++;
// Next receipt item
}
// print the receipts header
if ($LC - $lc % $LC <= 2) {
$lc = 0;
