$j++; continue; } $payedArr[$bill['rcpts'][$j]['srcCurrency']] += $bill['rcpts'][$j]['amount']; // 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++;
} $payedArr[$bill['rcpts'][$j]['srcCurrency']] += $bill['rcpts'][$j]['amount']; // 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
$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) { $status = $_L['STS_open']; } elseif ($receipts[$j]['status'] == STATUS_CLOSED) {
if ($j % 2 == 1) { echo "<tr id=\"row" . $j . "\" onmouseover=\"javascript:setColor('" . $j . "')\" onmouseout=\"javascript:origColor('" . $j . "')\" bgcolor=\"#CCCCCC\">"; } else { 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 {