本文整理汇总了PHP中Application_Model_DbTable_DbGlobal::getBookingById方法的典型用法代码示例。如果您正苦于以下问题:PHP Application_Model_DbTable_DbGlobal::getBookingById方法的具体用法?PHP Application_Model_DbTable_DbGlobal::getBookingById怎么用?PHP Application_Model_DbTable_DbGlobal::getBookingById使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Application_Model_DbTable_DbGlobal
的用法示例。
在下文中一共展示了Application_Model_DbTable_DbGlobal::getBookingById方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: sendInvoiceEmail
function sendInvoiceEmail($row_booking_id)
{
$db = new Application_Model_DbTable_DbGlobal();
$row_booking = $db->getBookingById($row_booking_id, 1);
$row_booking_detail = $db->getBookingById($row_booking_id, 2);
$pickup_date = date_create($row_booking["pickup_date"]);
$return_date = date_create($row_booking["return_date"]);
$diff = date_diff($pickup_date, $return_date);
$total_day = $diff->format("%a%") + 1;
if ($row_booking["rental_type"] == 1) {
$duration = " Day(s)";
$total_duration = $total_day;
} elseif ($row_booking["rental_type"] == 2) {
$duration = " Monthly";
$total_duration = $row_booking["total_duration"];
}
$htmlContent = '<div style="font-family:Arial;font-size:10px">
<table align="center" style="width:100%" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td>
<table align="center" width="100%" border="0" cellspacing="0" cellpadding="0" style="width:100% !important;font-family:Arial;font-size:12px">
<tbody>
<tr>
<td>
<table width="100%" align="left" border="0" cellspacing="0" cellpadding="0" style="font-family:Arial;font-size:12px">
<tbody>
<tr>
<td>
<table width="100%" align="center" style="background:#FBFF00">
<tr align="center" style="height:12px;font-size: 30px;">
<td><span style="color:red;font-family:"Kh Kangrey">លីណា-ជួលរថយន្តទេសចរណ៍</span></td>
</tr>
<tr align="center" style="height: 12px;font-size: 30px;">
<td><span style="color:red; font-family:"Bocci Regular ttnorm">Lyna-CarRental.Com</span></td>
</tr>
<tr align="center" style="height: 12px;font-size: 30px;background:#0C109E;border-top:2px solid #ffffff;">
<td><span style="color:red;"></span></td>
</tr>
</table>
</td>
</tr>
<tr style="height:30px"><td><hr /></td></tr>
<tr bgcolor="#ffffff">
<td>
<table width="100%" align="left" border="0" cellspacing="0" cellpadding="0" style="font-family:Arial;font-size:12px">
<tbody>';
if ($row_booking["item_type"] == 1) {
$htmlContent .= '<tr border="1">
<td width="25%" align="left">Bill For : </td>
<td width="25%"align="left">' . $row_booking["customer_name"] . '</td>
<td width="5%"></td>
<td width="15%" align="right"></td>
<td width="30%" align="right"></td>
</tr>
<tr border="1">
<td width="25%" align="left">Phone No. : </td>
<td width="25%"align="left">' . $row_booking["customer_phone"] . '</td>
<td width="5%"></td>
<td width="15%" align="right"></td>
<td width="30%" align="right"></td>
</tr>
<tr border="1">
<td width="25%" align="left">E-mail Address : </td>
<td width="25%"align="left">' . $row_booking["customer_email"] . '</td>
<td width="5%"></td>
<td width="15%" align="right">Flight No.:</td>
<td width="30%" align="right">' . $row_booking["fly_no"] . '</td>
</tr>';
$htmlContent .= '<tr>
<td width="25%" align="left">Pickup Date and Time:</td>
<td width="25%" align="left">' . $row_booking["pickup_date"] . " " . $row_booking["pickup_time"] . '</td>
<td width="5%"></td>
<td width="15%" align="right">Flight Date:</td>
<td width="30%" align="right">' . $row_booking["fly_date"] . '</td>
</tr>
<tr>
<td width="25%" align="left">Pickup Location:</td>
<td width="25%" align="left">' . $row_booking["pickup_location"] . '</td>
<td width="5%"></td>
<td width="15%" align="right"> Time of Arrival:</td>
<td width="30%" align="right">' . $row_booking["fly_time_of_arrival"] . '</td>
</tr>
<tr>
<td width="25%" align="left">Return Date and Time:</td>
<td width="25%" align="left">' . $row_booking["return_date"] . " " . $row_booking["return_time"] . '</td>
<td width="5%"></td>
<td width="15%" align="right">Destination:</td>
<td>' . $row_booking["fly_destination"] . '</td>
</tr>
<tr>
<td width="25%" align="left">Return Location:</td>
<td width="25%" align="left">' . $row_booking["return_location"] . '</td>
<td width="5%"></td>
<td width="15%" align="right">Booking No.: </td>
<td width="30%" align="right" style="color:red;"><b style="color:red">' . $row_booking["booking_no"] . '</b></span></td>
</tr>
<tr>
<td align="left">Duration :</td>
<td align="left">' . $total_day . $duration . '</td>
//.........这里部分代码省略.........
示例2: emailinvoiceAction
function emailinvoiceAction()
{
$this->_helper->layout()->disableLayout();
$id = $this->getRequest()->getParam("id");
$db = new Application_Model_DbTable_DbGlobal();
$row_booking = $db->getBookingById($id, 1);
$row_booking_detail = $db->getBookingById($id, 2);
$this->view->booking = $row_booking;
$this->view->booking_detail = $row_booking_detail;
}