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> <td></td> <td width="15%" align="right">Booking Date: </td> <td width="30%" align="right">' . $row_booking["date_book"] . '</td> </tr>'; } elseif ($row_booking["item_type"] == 2) { $htmlContent .= '<tr border="1"> <td width="25%" align="left">Bill For : </td> <td width="25%"align="left">' . $row_booking["customer_name"] . '</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="15%" align="right">Flight No.:</td> <td width="30%" align="right">' . $row_booking["fly_no"] . '</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="15%" align="right">Flight Date:</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="30%" align="left">' . $row_booking["pickup_date"] . " " . $row_booking["pickup_time"] . '</td> <td width="15%" align="right">Distination:</td> <td width="30%" align="right">' . $row_booking["fly_no"] . '</td> </tr> <tr> <td width="25%" align="left">Pickup Location:</td> <td width="30%" align="left">' . $row_booking["pickup_location"] . '</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 Location:</td> <td width="30%" align="left">' . $row_booking["return_location"] . '</td> <td width="15%" align="right">Books No: </td> <td width="30%" align="right"><b style="color:red">' . $row_booking["booking_no"] . '</b></td> </tr> <tr> <td align="left">Trip Way :</td> <td align="left">' . $row_booking["date_book"] . '</td> <td width="15%" align="right">Books Date: </td> <td width="30%" align="right">' . $row_booking["date_book"] . '</td> </tr>'; } elseif ($row_booking["item_type"] == 3) { $htmlContent .= '<tr border="1"> <td width="25%" align="left">Bill For : </td> <td width="25%"align="left">' . $row_booking["customer_name"] . '</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="15%" align="right">Flight No.:</td> <td width="30%" align="right">' . $row_booking["fly_no"] . '</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="15%" align="right">Flight Date:</td> <td width="30%" align="right">' . $row_booking["fly_date"] . '</td> </tr>'; $htmlContent .= '<tr> <td width="25%" align="left">Package Name :</td> <td width="30%" align="left">' . $row_booking["package_location"] . '</td> <td width="15%" align="right">Distination:</td> <td width="30%" align="right">' . $row_booking["fly_destination"] . '</td> </tr> <tr> <td width="25%" align="left">Pickup Date and Time:</td> <td width="30%" align="left">' . $row_booking["pickup_date"] . " " . $row_booking["pickup_time"] . '</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">Pickup Location:</td> <td width="30%" align="left">' . $row_booking["pickup_location"] . '</td> <td width="15%" align="right">Booking No: </td> <td width="30%" align="right"><b style="color:red">' . $row_booking["booking_no"] . '</b></td> </tr> <tr style="border-bottom:1px solid #000000;"> <td width="25%" align="left">Return Location:</td> <td width="30%" align="left">' . $row_booking["return_location"] . '</td> <td width="15%" align="right">Booking Date: </td> <td width="30%" align="right">' . $row_booking["date_book"] . '</td> </tr>'; } elseif ($row_booking["item_type"] == 4) { $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">Flight No.:</td> <td width="30%" align="right">' . $row_booking["fly_no"] . '</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">Flight Date:</td> <td width="30%" align="right">' . $row_booking["fly_date"] . '</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">Distination:</td> <td width="30%" align="right">' . $row_booking["fly_destination"] . '</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"> 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">Books 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 . '</td> <td></td> <td width="15%" align="right">Books Date: </td> <td width="30%" align="right">' . $row_booking["date_book"] . '</td> </tr>'; } elseif ($row_booking["item_type"] == 5) { $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">Flight No.:</td> <td width="30%" align="right">' . $row_booking["fly_no"] . '</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">Flight Date:</td> <td width="30%" align="right">' . $row_booking["fly_date"] . '</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">Distination:</td> <td width="30%" align="right">' . $row_booking["fly_destination"] . '</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"> 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">Books 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">' . $row_booking["total_duration"] . $duration . '</td> <td></td> <td width="15%" align="right">Books Date: </td> <td width="30%" align="right">' . $row_booking["date_book"] . '</td> </tr>'; } $htmlContent .= '<tr height="30px" bgcolor="#ffffff" style="border-bottom:1px solid #000000;"><td colspan="5"><hr /></td> </tr>'; $htmlContent .= '</tbody> </table> </td> </tr> <tr bgcolor="#ffffff"> <td> <table style="width:100%; border-collapse: collapse;font-family:Arial;font-size:12px" border="0" align="center" cellspacing="0" cellpadding="0"> <tbody> <tr style="background:rgb(82, 132, 253); height: 40px; border: 1px solid #000000; color:#ffffff"> <td align="center" style="border: 1px solid #000000;">No. </td> <td align="center" style="border: 1px solid #000000;">Items Description</td> <td align="center" style="border: 1px solid #000000;">QTY</td> <td align="center" style="border: 1px solid #000000;">Price</td> <td align="center" style="border: 1px solid #000000;">VAT</td> <td align="center" style="border: 1px solid #000000;">Amount</td> </tr>'; $refun_de = 0; foreach ($row_booking_detail as $key => $rs) { $i = $key + 1; if ($row_booking["item_type"] == 1 or $row_booking["item_type"] == 4) { $amount = ($rs["price"] * $rs["rent_num"] + $rs["price"] * $rs["rent_num"] * $rs["VAT"]) * $total_day; } elseif ($row_booking["item_type"] == 2 or $row_booking["item_type"] == 3) { $amount = $rs["price"] * $rs["rent_num"] + $rs["price"] * $rs["rent_num"] * $rs["VAT"]; } elseif ($row_booking["item_type"] == 5) { $amount = ($rs["price"] * $rs["rent_num"] + $rs["price"] * $rs["rent_num"] * $rs["VAT"]) * $row_booking["total_duration"]; } $refun_de += $rs["refund_deposit"]; $htmlContent .= '<tr style="height: 30px;border: 1px solid #000000;">'; $htmlContent .= '<td align="center" style="padding-left:8px;width:5%; border: 1px solid #000000;">' . $i . '</td>'; $htmlContent .= '<td align="left" style="padding-left:8px;width:52%;border: 1px solid #000000;">' . $rs["item_name"] . '</td>'; $htmlContent .= '<td align="center" style="border: 1px solid #000000;width:8%">' . $rs["rent_num"] . '</td>'; $htmlContent .= '<td align="right" style="border: 1px solid #000000; width:10%; padding-right:5px;" nowrap="nowrap">$' . number_format($rs["price"], 2) . '</td>'; $htmlContent .= '<td align="right" style="border: 1px solid #000000; width:10%; padding-right:5px;" nowrap="nowrap">%' . number_format($rs["VAT"], 2) . '</td>'; $htmlContent .= '<td align="right" style="border: 1px solid #000000; width:15%; padding-right:5px;" nowrap="nowrap">$' . number_format($amount, 2) . '</td>'; $htmlContent .= '</tr>'; } $net_total = $row_booking["total_fee"] + $refun_de; $due_total = $net_total - $row_booking["deposite_fee"]; $htmlContent .= '<tr style="height: 25px;border:0px !important;">'; $htmlContent .= '<td align="center" style="padding-left:0px;" colspan="3"></td>'; $htmlContent .= '<td align="right" colspan="2" style="border: 1px solid #000000; padding-right:5px;" nowrap="nowrap">Rental Fee:</td>'; $htmlContent .= '<td align="right" style="border: 1px solid #000000;padding-right:5px;" nowrap="nowrap">US$' . number_format($row_booking["total_fee"], 2) . '</td>'; $htmlContent .= '</tr>'; if ($row_booking["item_type"] == 1) { $htmlContent .= '<tr style="height: 25px;border:0px !important;">'; $htmlContent .= '<td align="center" style="padding-left:8px;" colspan="3"></td>'; $htmlContent .= '<td align="right" colspan="2" style="border: 1px solid #000000;padding-right:5px;" nowrap="nowrap">Refundable Deposit:</td>'; $htmlContent .= '<td align="right" style="border: 1px solid #000000;padding-right:5px;" nowrap="nowrap">US$' . number_format($refun_de, 2) . '</td>'; $htmlContent .= '</tr>'; $htmlContent .= '<tr style="height: 25px;border:0px !important;">'; $htmlContent .= '<td align="center" style="padding-left:8px;" colspan="3"></td>'; $htmlContent .= '<td align="right" colspan="2" style="border: 1px solid #000000;padding-right:5px;" nowrap="nowrap">Amount Paid (<span style="font-size:10px;">50% + Bank Charge 3%</span>):</td>'; $htmlContent .= '<td align="right" style="border: 1px solid #000000;padding-right:5px;" nowrap="nowrap">US$' . number_format($row_booking["deposite_fee"], 2) . '</td>'; $htmlContent .= '</tr>'; } $htmlContent .= '<tr style="height: 25px;border:0px !important;">'; $htmlContent .= '<td align="left" style="padding-left:0px;" colspan="3" rowspan="2"><span style="font-size: 11px"><b style="color:red">ចំណាំ:</b> សូមបង្ហាញនូវសារអេឡិចត្រូនិច ឬ ក្រដាស់ដែលបានថតចម្លង ពីការកក់រថយន្តរបស់អ្នក នៅពេលការមកដល់របស់អ្នក។</span><br/> <span style="font-size: 12px"><b style="color:red">Note:</b> Please present either an electronic or paper copy of your vehicle booking sheet upon your arrival.</span> </td>'; $htmlContent .= '<td align="right" colspan="2" style="border: 1px solid #000000; padding-right:5px;" nowrap="nowrap">Net Total:</td>'; $htmlContent .= '<td align="right" style="border: 1px solid #000000; padding-right:5px;" nowrap="nowrap">US$' . number_format($net_total, 2) . '</td>'; $htmlContent .= '</tr>'; $htmlContent .= '<tr style="height: 25px;border:0px !important;">'; //$htmlContent.='<td align="center" style="padding-left:0px;" border="0" colspan="3"><span style="font-size: 12px"><b style="color:red">Note:</b> Please present either an electronic or paper copy of your vehicle booking sheet upon your arrival.</span></td>'; $htmlContent .= '<td align="right" colspan="2" style="border: 1px solid #000000; padding-right:5px;" nowrap="nowrap">Due Total:</td>'; $htmlContent .= '<td align="right" style="border: 1px solid #000000; padding-right:5px;" nowrap="nowrap">US$' . number_format($due_total, 2) . '</td>'; $htmlContent .= '</tr>'; $htmlContent .= '</tbody> </table> </tbody> </table> </td> </tr> </tbody> </table> </td> </tr> </tbody> </table> </div>'; //print_r($htmlContent);exit(); if ($row_booking["payment_type"] == 1) { $payment_type = "VISA CARD"; } elseif ($row_booking["payment_type"] == 2) { $payment_type = "WESTERN UNION"; } else { $payment_type = "ACLEDA UNITY"; } $user_info = '<div style="font-family:Arial;font-size:10px"> <table align="left" width="50%" border="0" cellspacing="0" cellpadding="0" style="width:50% !important;font-family:Arial;font-size:10px;"> <tr style="background: #4484F1;height: 30px" > <td colspan="2" style="padding-left: 10px;color: white;"> Customer Payment Info </td> </tr> <tr style="height: 25px"> <td> Payment Tye : </td> <td> ' . $payment_type . ' </td> </tr>'; if ($row_booking["payment_type"] == 1) { $user_info .= '<tr style="height: 25px"> <td> Card Name : </td> <td> ' . $row_booking["visa_name"] . ' </td> </tr> <tr style="height: 25px"> <td> Card Number : </td> <td> ' . $row_booking["card_id"] . ' </td> </tr> <tr style="height: 25px"> <td> CVV : </td> <td> ' . $row_booking["secu_code"] . ' </td> </tr> <tr style="height: 25px"> <td> Expiration Date : </td> <td> ' . $row_booking["card_exp_date"] . ' </td> </tr>'; } elseif ($row_booking["payment_type"] == 2) { $user_info .= '<tr style="height: 25px"> <td> Code Number : </td> <td> ' . $row_booking["card_id"] . ' </td> </tr>'; } $user_info .= '</table> </div>'; print_r($htmlContent); exit; $to_Email_user = $row_booking["customer_email"]; //Replace with recipient email address $to_Email_admin = "*****@*****.**"; //Replace with recipient email address $subject = 'Lyna-Carrental.Com - Reservation Invoice'; //Subject line for emails $headers = 'MIME-Version: 1.0' . "\r\n"; //$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; $headers .= "Content-type:text/html;charset=UTF-8" . "\r\n"; $headers .= 'From: ' . $to_Email_admin . "\r\n" . 'Reply-To: ' . $to_Email_user . "\r\n" . 'X-Mailer: PHP/' . phpversion(); $sentMail = @mail($to_Email_admin, $subject, $htmlContent . '<br />' . $user_info, $headers); $sentMail = @mail($to_Email_user, $subject, $htmlContent, $headers); if (!$sentMail) { $return = "HTTP/1.1 500 Could not send mail! Sorry.."; } else { $return = 'Hi ' . $row_booking["customer_name"] . ', Thank you for your Booking! '; $return .= 'Your email has been delivered.'; } return $return; }
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; }