PHP get_guestname Examples

Example #1

File: invoice_export.php Project: bogiesoft/hotelmis-ota

 $objPHPExcel->getActiveSheet()->setCellValue('F1', "Booking No.");
 $objPHPExcel->getActiveSheet()->setCellValue('G1', "Amount");
 $objPHPExcel->getActiveSheet()->setCellValue('H1', "Form of Payment");
 $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']);

Example #2

File: billings.php Project: bogiesoft/hotelmis-ota

    $trans_date = $today;
}
if (!$rcpt_date) {
    $rcpt_date = $today;
}
if (!$quantity) {
    $quantity = 1;
}
if ($bid && !$rateid) {
    $rateid = get_bookingrate($bid);
}
if (!$guestname) {
    $guestname = $res['guestname'];
}
if (!$guestname) {
    $guestname = get_guestname($guestid);
}
$mscludge = "";
if (preg_match('/MSIE/i', $_SERVER['HTTP_USER_AGENT'])) {
    $mscludge = 'onfocus="javascript: this.style.width=\'auto\';" onblur="javascript: this.style.width=18;"';
}
$i = 0;
while ($i < $bill['transcount']) {
    if ($bill['trans'][$i]['status'] != STATUS_VOID) {
        if (isset($totalArr[$bill['trans'][$i]['currency']])) {
            $totalArr[$bill['trans'][$i]['currency']] += $bill['trans'][$i]['grossamount'];
        } else {
            $totalArr[$bill['trans'][$i]['currency']] = $bill['trans'][$i]['grossamount'];
        }
    }
    $i++;