Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- global $config;
- mysql_connect($config->database->params->host, $config->database->params->username, $config->database->params->password);
- mysql_select_db($config->database->params->dbname);
- define("IMG_PATH", 'uploads');
- //define("hosturl_1","http://".$_SERVER['HTTP_HOST']."/");
- define("hosturl_1", "http://manage.rentalcommand.com/");
- $path = str_replace("../", "", IMG_PATH);
- function SMTP_AUTH_MAIL($from, $to, $subject, $body, $host, $username, $password) {
- //echo $from.$to.$subject.$host.$username.$password;
- //extract($_REQUEST);
- //$from = "<".$from_booking.">";
- // $to = $test_email;
- // $subject = "Hi!";
- //$body = "<table><tr><td><strong>hello gopesh</strong></td><td>hjkgsdjfghsd</td></tr></table>";
- // $host = "smtp.gmail.com";
- //$username = $username;
- // $password =$password;
- $headers = array('From' => $from,
- 'To' => $to,
- 'Subject' => $subject,
- 'MIME-Version' => '1.0\r\n',
- 'Content-type' => 'text/html');
- $smtp = Mail::factory('smtp', array('host' => $host,
- 'auth' => true,
- 'username' => $username,
- 'password' => $password));
- $mail = $smtp->send($to, $headers, $body);
- if (PEAR::isError($mail)) {
- echo("<p>" . $mail->getMessage() . "</p>");
- } else {
- return 1;
- }
- }
- function check_price($table, $column, $condition, $value, $booking_days) {
- $qry = "SELECT $column FROM $table WHERE $condition=$value";
- $res = mysql_query($qry);
- $f_res = mysql_fetch_assoc($res);
- if ($f_res['rate_type'] == 'Weekly') {
- if ($f_res['min_req_duration'] == 0) {
- $optional_upgrade_price = ($f_res['upgradePrice'] * $booking_days) / 7;
- } elseif ($booking_days > 7) {
- $optional_upgrade_price = ($f_res['upgradePrice'] * $booking_days) / 7;
- // $optional_upgrade_price.= $optional_upgrade_price ($f_res['upgradePrice']."/wk");
- } elseif ($f_res['min_req_duration'] == 7) {
- $optional_upgrade_price = $f_res['upgradePrice'];
- // elseif (($f_res['min_req_duration'] == 7) && ($booking_days > $f_res['min_req_duration']) ) {
- // $optional_upgrade_price= $optional_upgrade_price= ($f_res['upgradePrice']*$booking_days)/7;;
- // }
- }
- } else {
- $optional_upgrade_price = $f_res['upgradePrice'] * $booking_days;
- }
- return number_format($optional_upgrade_price, 2);
- }
- function get_optiional_ugrade_list() {
- $fq = "SELECT * FROM optional_upgrade_property";
- $frun = mysql_query($fq);
- $x = array();
- while ($frow = mysql_fetch_array($frun)) {
- $x[$frow['CounterId']]['opUpgradeName'] = $frow['opUpgradeName'];
- $x[$frow['CounterId']]['rate_type'] = $frow['rate_type'];
- }
- return $x;
- }
- function unhtmlentities($string) {
- // replace numeric entities
- $string = preg_replace('~&#x([0-9a-f]+);~ei', 'chr(hexdec("\\1"))', $string);
- $string = preg_replace('~&#([0-9]+);~e', 'chr("\\1")', $string);
- // replace literal entities
- $trans_tbl = get_html_translation_table(HTML_ENTITIES);
- $trans_tbl = array_flip($trans_tbl);
- return strtr($string, $trans_tbl);
- }
- /* function get_optiional_ugrade_list()
- {
- $fq="SELECT * FROM optional_upgrade";
- $frun=mysql_query($fq);
- $x=array();
- while($frow=mysql_fetch_array($frun))
- {
- $x[$frow['CounterId']]=$frow['opUpgradeName'];
- }
- return $x;
- } */
- function get_val_col($tabel, $column, $condition, $value, $oder = '') {
- $fq = "SELECT $column FROM $tabel WHERE $condition='$value' $oder";
- $frun = mysql_query($fq);
- $frow = mysql_fetch_array($frun);
- return $frow[$column];
- }
- function get_val_col_result($tabel, $column, $condition, $value, $oder = '') {
- $fq = "SELECT $column FROM $tabel WHERE $condition='$value' $oder";
- $frun = mysql_query($fq);
- $frow = mysql_fetch_array($frun);
- return $frow;
- }
- /* function get_val_col_result_1($tabel,$column,$condition,$value,$oder='')
- {
- $fq="SELECT $column FROM $tabel WHERE $condition='$value' and site_id='".$_SESSION['user_site_id']."' $oder";
- $frun=mysql_query($fq);
- $frow=mysql_fetch_array($frun);
- return $frow;
- } */
- function get_val_col_result_1($tabel, $column, $condition, $value, $oder = '') {
- $fq = "SELECT $column FROM $tabel WHERE $condition='$value' and site_id='" . $siteKey . "' $oder";
- $frun = mysql_query($fq);
- $frow = mysql_fetch_array($frun);
- return $frow;
- }
- function get_smtp_detail() {
- $smq = "SELECT * FROM smtp_authentication WHERE site_id='" . $_SESSION['user_site_id'] . "'";
- $smrun = mysql_query($smq);
- $smrow = mysql_fetch_array($smrun);
- return $smrow;
- }
- //echo "<br><br>Amount: ";print_r($row2['credit_amount']);
- $q = "SELECT * FROM propertybooking_summary WHERE booking_reference='$booking_reference' group by booking_reference";
- $run1 = mysql_query($q);
- $row1 = mysql_fetch_array($run1);
- $guestRecipt = $row1['guest_reciept'];
- $OwnerID = get_val_col("propertymaster", "OwnerID", "PropertyID", $row1['PropertyID']);
- $ManagerID = get_val_col("propertymaster", "ManagerID", "PropertyID", $row1['PropertyID']);
- $crossID = get_val_col("propertymaster", "crosshire_id", "PropertyID", $row1['PropertyID']);
- $booking_source = $row1['booking_source'];
- $qp = "SELECT * FROM propertymaster WHERE PropertyID='" . $row1['PropertyID'] . "'";
- $runp1 = mysql_query($qp);
- $rowp1 = mysql_fetch_array($runp1);
- $guestlastname = get_val_col("propertybooking_payment", "last_name", "booking_reference", $row1['booking_reference'], 'order by CounterID desc');
- $Manager_Email = get_val_col("contacts", "Email", "CounterID", $ManagerID);
- $Owner_Email = get_val_col("contacts", "Email", "CounterID", $OwnerID);
- $Cross_Email = get_val_col("contacts", "Email", "CounterID", $crossID);
- $Agent_Email = get_val_col("contacts", "Email", "CounterID", $row1['agent_id']);
- //$frommail=get_val_col("site_info","Email","site_reference",$_SESSION['user_site_id']);
- $frommail = get_val_col("site_info", "Email", "site_reference", $siteKey);
- //$fromnotification=get_val_col("site_info","from_booking","site_reference",$_SESSION['user_site_id']);
- $fromnotification = get_val_col("site_info", "from_booking", "site_reference", $siteKey);
- if ($fromnotification != '')
- $frommail = $fromnotification;
- $Owner_Lastname = get_val_col("contacts", "LastName", "CounterID", $OwnerID);
- $pro_title = get_val_col("propertymaster", "Title", "PropertyID", $row1['PropertyID']);
- $pro_addr = get_val_col("propertymaster", "Addr1", "PropertyID", $row1['PropertyID']);
- $pro_city = get_val_col("propertymaster", "City", "PropertyID", $row1['PropertyID']);
- $pro_state = get_val_col("propertymaster", "StateId", "PropertyID", $row1['PropertyID']);
- $pro_zip = get_val_col("propertymaster", "Postcode", "PropertyID", $row1['PropertyID']);
- $pay_method = get_val_col("propertybooking_payment", "payment_method", "booking_reference", $booking_reference, 'order by payment_date desc');
- $pro_USERID = get_val_col("propertymaster", "user_PropertyID", "PropertyID", $row1['PropertyID']);
- $booking_require_owner_approval = get_val_col("propertymaster", "booking_require_owner_approval", "PropertyID", $row1['PropertyID']);
- $min_date = $row1['DateFrom']; //get_val_col("propertybooking","MIN(DateFrom)","booking_reference",$booking_reference);
- $query = "SELECT * FROM propertybooking_customerdetail WHERE booking_reference='$booking_reference'";
- /* $frommailManager=get_val_col_result_1('mail_format','*','format_name','Manager');
- $frommailOwner=get_val_col_result_1('mail_format','*','format_name','Owner');
- $frommailGuest=get_val_col_result_1('mail_format','*','format_name','Guest');
- $frommailCross=get_val_col_result_1('mail_format','*','format_name','Crosshire');
- $frommailAgent=get_val_col_result_1('mail_format','*','format_name','Agent'); */
- $frommailManager = get_val_col_result('mail_format', '*', 'format_name', 'Manager');
- $frommailOwner = get_val_col_result('mail_format', '*', 'format_name', 'Owner');
- $frommailGuest = get_val_col_result('mail_format', '*', 'format_name', 'Guest');
- $frommailCross = get_val_col_result('mail_format', '*', 'format_name', 'Crosshire');
- $frommailAgent = get_val_col_result('mail_format', '*', 'format_name', 'Agent');
- $crdit_card_fee_amount = get_val_col("propertybooking_payment", "crdit_card_fee_amount", "booking_reference", $booking_reference);
- $notify_owner = get_val_col("propertymaster", "notify_owner_of_booking", "PropertyID", $row1['PropertyID']);
- $run = mysql_query($query);
- $row = mysql_fetch_array($run);
- extract($row);
- $Customer_Email = $Email;
- //$qsite="select * from site_info where site_reference='".$_SESSION['user_site_id']."'";
- $qsite = "select * from site_info where site_reference='" . $siteKey . "'";
- $qsite_run = mysql_query($qsite);
- $site_row = mysql_fetch_array($qsite_run);
- $imgname = $site_row['company_logo'];
- $upload_folder = $site_row['upload_folder'];
- $smtp_info = get_smtp_detail();
- //if(get_val_col("site_info","notify_manager_of_booking","site_reference",$_SESSION['user_site_id'])==1)
- if (get_val_col("site_info", "notify_manager_website_of_booking", "site_reference", $siteKey) == 1) {
- //$msg_content=$site_row['email_msg_content_manager'];
- $msg_content_manager_website = $site_row['email_msg_content_manager_website'];
- $name_re = "Manager";
- }
- //if(get_val_col("site_info","notify_agent_of_booking","site_reference",$_SESSION['user_site_id'])==1)
- if (get_val_col("site_info", "notify_agent_website_of_booking", "site_reference", $siteKey) == 1) {
- //$msg_content=$site_row['email_msg_content_agent'];
- $msg_content_agent_website = $site_row['email_msg_content_agent_website'];
- $name_re = "Agent";
- }
- //if(get_val_col("site_info","notify_crosshire_of_booking","site_reference",$_SESSION['user_site_id'])==1)
- if (get_val_col("site_info", "notify_crosshire_website_of_booking", "site_reference", $siteKey) == 1) {
- //$msg_content=$site_row['email_msg_content_crosshire'];
- $msg_content_crosshire_website = $site_row['email_msg_content_crosshire_website'];
- $name_re = "Crosshire";
- }
- if (get_val_col("site_info", "notify_owner_website_of_booking", "site_reference", $siteKey) == 1) {
- //$msg_content=$site_row['email_msg_content_crosshire'];
- $msg_content_owner_website = $site_row['email_msg_content_owner_website'];
- $name_re = "Owner";
- }
- if (get_val_col("site_info", "notify_guest_website_of_booking", "site_reference", $siteKey) == 1) {
- //$msg_content=$site_row['email_msg_content_crosshire'];
- $msg_content_guest_website = $site_row['email_msg_content_guest_website'];
- $name_re = "Guest";
- }
- $noofdays = $row1['days_booking'];
- ///manager Mail
- //echo $Manager_Email.'ffff'.$Customer_Email.$Owner_Email;
- $mail_msg = '<table width="718" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td style="border-top:4px #e2eff6 solid; border-bottom:4px #626262 solid; padding-bottom:10px;"><table width="718" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="396" style="padding-top:34px; padding-left:20px;"><a href="#"><img src="' . hosturl_1 . $path . '/' . $upload_folder . '/' . $imgname . '" border="0" /></a></td>
- <td width="322" align="right" style="font-family:Arial, Helvetica, sans-serif; font-weight:bold; font-size:13px;"><p style="margin:0px; padding-bottom:3px; padding-top:18px; padding-right:10px;">' . $site_row['site_name'] . '</p>
- <p style="margin:0px; padding-right:10px;" >' . $site_row['Address1'] . ', ' . $site_row['City'] . ', ' . $site_row['StateID'] . ' ' . $site_row['Postalcode'] . '</p>
- <p style="border-bottom:1px #e3e3e3 solid; margin:0px; padding-top:8px;"></p>
- <p style="margin:0px; padding-top:8px; padding-right:10px;">Ph: ' . $site_row['Phone'] . ' Fax: ' . $site_row['Fax'] . '</p>
- <p style="margin:0px; padding-top:5px; padding-right:10px;">E-mail: <a href="mailto:' . $site_row['Email'] . '" style="color:#000; text-decoration:none">' . $site_row['Email'] . '</a></p></td>
- </tr>
- </table></td></tr>';
- $mail_msg.='<tr valign="top" align="left">
- <td height="5"></td>
- </tr>
- <tr valign="top" align="left">
- <td style="border:1px #a9dbf5 solid; background:#eff6fa url(' . hosturl_1 . 'img/titlebg.gif) repeat-x left top; height:35px; line-height:35px; padding-left:23px; color:#005687; font-family:Arial, Helvetica, sans-serif; font-size:18px; font-weight:bold">Receipt</td>
- </tr>';
- $mail_msg.='<tr valign="top" align="left">
- <td style="border:1px #a9dbf5 solid; border-top:0px; padding-bottom:20px;"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td style="padding-left:20px; font-family:Arial, Helvetica, sans-serif; font-size:13px;">' .
- '<p>' . "{##}" . '</p>' .
- '<p><strong>Following are the details of your transaction.</strong></p></td>
- </tr>
- <tr valign="top" align="left">
- <td style="padding-left:20px;"><table width="674" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td style="background:#00649c url(' . hosturl_1 . 'img/bluetitlebg.gif) repeat-x left top; height:27px; font-family:Arial, Helvetica, sans-serif; font-size:13px; font-weight:bold; color:#ffffff; padding-left:10px; line-height:27px;">Booking Information</td>
- </tr>
- </table></td>
- </tr>';
- $mail_msg.='<tr valign="top" align="left">
- <td style="background:#ffffff url(' . hosturl_1 . 'img/contentbg.gif) repeat-x left top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #e3e3e3 solid">Booking ID:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #e3e3e3 solid">' . $new_book_id . '</td>
- </tr>
- </table></td>
- </tr>
- <tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #e3e3e3 solid">Property ID:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #e3e3e3 solid">' . $rowp1['user_PropertyID'] . '</td>
- </tr>
- </table></td>
- </tr>
- <tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #e3e3e3 solid">Property Address:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #e3e3e3 solid">' . $pro_addr . ', ' . $pro_city . ', ' . $pro_state . ' ' . $pro_zip . '</td>
- </tr>
- </table></td>
- </tr>
- <tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #e3e3e3 solid">Booking Duration:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #e3e3e3 solid">' . date('F d, Y', strtotime($min_date)) . ' to ' . date('F d, Y', strtotime(date("Y-m-d", strtotime("+1 day", strtotime($row1['DateTo']))))) . '</td>
- </tr>
- </table></td>
- </tr>
- <tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #e3e3e3 solid">Booking Source:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #e3e3e3 solid">' . $booking_source . '</td>
- </tr>
- </table></td>
- </tr>
- <tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:4px #d6d6d6 solid">Booked By:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:4px #d6d6d6 solid">' . $row1['created_by'] . '</td>
- </tr>
- </table></td>
- </tr>
- </table></td>
- </tr>';
- $mail_msg.=' <tr valign="top" align="left">
- <td height="10"></td>
- </tr>
- <tr valign="top" align="left">
- <td style="padding-left:20px;"><table width="674" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td style="background:#00649c url(' . hosturl_1 . 'img/bluetitlebg.gif) repeat-x left top; height:27px; font-family:Arial, Helvetica, sans-serif; font-size:13px; font-weight:bold; color:#ffffff; padding-left:10px; line-height:27px;">Guest Details</td>
- </tr>
- </table></td>
- </tr>
- <tr valign="top" align="left">
- <td style="background:#ffffff url(' . hosturl_1 . 'img/contentbg.gif) repeat-x left top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #e3e3e3 solid">Guest:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #e3e3e3 solid">' . $first_name . ' ' . $last_name . '</td>
- </tr>
- </table></td>
- </tr>
- <tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #e3e3e3 solid">Address:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #e3e3e3 solid">' . $address . ', ' . $city . ', ' . $state . ' ' . $postal_code . '</td>
- </tr>
- </table></td>
- </tr>
- <tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #e3e3e3 solid">Phone:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #e3e3e3 solid">' . $phonenumber . ' </td>
- </tr>
- </table></td>
- </tr>
- <tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:4px #d6d6d6 solid">Email:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:4px #d6d6d6 solid">' . $Email . '</td>
- </tr>
- </table></td>
- </tr>
- </table></td>
- </tr>
- <tr valign="top" align="left">
- <td height="10"></td>
- </tr>';
- $mail_msg.='<tr valign="top" align="left">
- <td style="padding-left:20px;"><table width="674" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td style="background:#009c64 url(' . hosturl_1 . 'img/greentitlebg.gif) repeat-x left top; height:27px; font-family:Arial, Helvetica, sans-serif; font-size:13px; font-weight:bold; color:#ffffff; padding-left:10px; line-height:27px;">Fees</td>
- </tr>
- </table></td>
- </tr>
- <tr valign="top" align="left">
- <td style="background:#ffffff url(' . hosturl_1 . 'img/contentbg.gif) repeat-x left top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #e3e3e3 solid">Rental:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #e3e3e3 solid">$' . $row1['RentalFees'] . '</td>
- </tr>
- </table></td>
- </tr>';
- $rf = $row1['RentalFees'];
- $uf = $row1['UpgradesFee'];
- $cf = $row1['CleaningFee'];
- $dis = $row1['property_discount'];
- $total = $rf + $uf + $cf - $dis;
- if (isset($row1['tax_amount']) && $row1['tax_amount'] > 0) {
- $t = $row1['tax_amount'];
- } else {
- if ($row1['tax_include'] == 1) {
- if ($row1['cleanfee_include'] == 1)
- $t = ($total * $row1['Tax__Percentage']) / (100 + $row1['Tax__Percentage']);
- else
- $t = (($total - $cf) * $row1['Tax__Percentage']) / (100 + $row1['Tax__Percentage']);
- }
- else {
- if ($row1['cleanfee_include'] == 1)
- $t = ($total * $row1['Tax__Percentage']) / 100;
- else
- $t = (($total - $cf) * $row1['Tax__Percentage']) / 100;
- }
- }
- $tax = $t;
- /* echo "<br><br>Booking tax: " . $t;
- echo "<br><br>Property tax: " . $tax; */
- $tax = sprintf("%.2f", $tax);
- //$total=$total+$tax;
- //$total=$total;
- if ($row1['tax_include'] == 1) {
- $total = $total;
- } else {
- $total = $total + $tax;
- }
- $ccardfee = 0;
- if ($pay_method != 'Cash' and $pay_method != 'Check') {
- $ccardfee = ($total * $row1['CreditCardFee_Percentage']) / 100;
- $ccardfee = sprintf("%.2f", $ccardfee);
- } else {
- $ccardfee = sprintf("%.2f", $ccardfee);
- $total = $total + $ccardfee;
- }
- //$customermail_msg=$customermail_msg.'<tr><td align="right" valign="top"><strong>Optional Upgrade:</strong> </td> <td align="left" valign="top">';
- //$option_upgrade=$row1['optional_upgrade_options'];
- /*
- $upgrdid=array();
- $poolheat=$row1['optional_upgrade_options'];
- $poolheat=explode(',',$poolheat);
- $cnt=count($poolheat);
- for($i=0;$i<$cnt;$i++)
- {
- $poolid=explode('PRICE',$poolheat[$i]);
- $upgrdid[$i]=$poolid[0];
- }
- if($poolheat<>'')
- {
- $upids=implode(',',$upgrdid);
- $pooldetail=Booking::getPoolheat_forguest($upids);
- if($pooldetail)
- {
- //$customermail_msg=$customermail_msg."<table cellspacing=\"5\">";
- while($value=mysql_fetch_array($pooldetail))
- {
- $poolprice=Booking::getPoolPriceByUser($value,$row1);
- $mail_msg.='<tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #e3e3e3 solid">Upgrade, '.$value['opUpgradeName'].':</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #e3e3e3 solid">$'.$poolprice.'('.$value['rate_type'].')</td>
- </tr>
- </table></td>
- </tr>';
- }
- //$customermail_msg=$customermail_msg. "<tr>";
- // $customermail_msg=$customermail_msg."<td align=\"right\">Sub-Total:</td>";
- // $customermail_msg=$customermail_msg."<td align=\"left\">$".$uf=$row1['UpgradesFee']."</td>";
- // $customermail_msg=$customermail_msg."</tr>";
- //$customermail_msg=$customermail_msg."</table>";
- }
- }
- */
- $mail_msg.='<tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #d6d6d6 solid">Optional Upgrade:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #d6d6d6 solid">';
- $option_upgrade = $row1['optional_upgrade_options'];
- if ($option_upgrade <> '') {
- $option_upgrade = explode(",", $option_upgrade);
- $y = get_optiional_ugrade_list($row1['PropertyID']);
- $mail_msg = $mail_msg . "<table cellspacing=\"0\" width='100%'>";
- foreach ($option_upgrade as $value) {
- $val = explode("PRICE", $value);
- //check_price
- $mail_msg = $mail_msg . "<tr align='left'>";
- $mail_msg = $mail_msg . "<td align=\"left\" style='padding-bottom:10px;'>" . $y[$val[0]]['opUpgradeName'] . ":</td>";
- $mail_msg = $mail_msg . "<td align=\"left\" style='padding-bottom:10px;'>$" . $check_price_arr = check_price('optional_upgrade_property', 'rate_type,min_req_duration,upgradePrice', 'CounterId', $val[0], $noofdays) . "</td>";
- //$mail_msg=$mail_msg."<td align=\"left\" style='padding-bottom:10px;'>(".$y[$val[0]]['rate_type'].")</td>";
- $mail_msg = $mail_msg . "</tr>";
- }
- $mail_msg = $mail_msg . "<tr>";
- $mail_msg = $mail_msg . "<td align=\"left\" style='padding-bottom:10px;'>Sub-Total:</td>";
- $mail_msg = $mail_msg . "<td align=\"left\" style='padding-bottom:10px;'>$" . $row1['UpgradesFee'] . "</td>";
- $mail_msg = $mail_msg . "</tr>";
- $mail_msg = $mail_msg . "</table>";
- }
- $mail_msg.='</td>
- </tr>
- </table></td>
- </tr>';
- $mail_msg.='<tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #d6d6d6 solid">Cleaning:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #d6d6d6 solid">$' . $row1['CleaningFee'] . '</td>
- </tr>
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #d6d6d6 solid">Discount:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #d6d6d6 solid">$' . $dis . '</td>
- </tr>
- </table></td>
- </tr>
- <tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">';
- /* <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; color:#00466e; font-weight:bold; background-color:#e5eff4; padding-left:10px; border-bottom:1px #d6d6d6 solid">Sub Total:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; color:#00466e; font-weight:bold; background-color:#e5eff4; border-bottom:1px #d6d6d6 solid">$1,210.00</td>
- </tr> */
- $mail_msg.='</table></td>
- </tr>';
- $mail_msg.='<tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #d6d6d6 solid">Tax:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #d6d6d6 solid">';
- if ($row1['tax_include'] == 1)
- $p = '$' . $tax . ' (' . $row1['Tax__Percentage'] . ' % included in total)';
- else
- $p = '$' . $tax;
- $mail_msg.=$p . '</td>
- </tr>
- </table></td>
- </tr>';
- if ($ccardfee > 0) {
- $mail_msg.='<tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #d6d6d6 solid">Credit Card Fees:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #d6d6d6 solid">$' . sprintf("%.2f", $crdit_card_fee_amount) . ' (' . $row1['CreditCardFee_Percentage'] . ' %)</td>
- </tr>
- </table></td>
- </tr>';
- }
- /* <tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">';
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #d6d6d6 solid">Credit Card Fee:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #d6d6d6 solid">$5.00 (3%)</td>
- </tr>
- </table></td>
- </tr> */
- $mail_msg.='<tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; background-color:#cffdce; padding-bottom:5px; color:#00466e; font-weight:bold; padding-left:10px; border-bottom:4px #d6d6d6 solid">Total:</td>
- <td width="59%" style="padding-top:10px; background-color:#cffdce; padding-bottom:5px; color:#00466e; font-weight:bold; border-bottom:4px #d6d6d6 solid">$' . $row1['Total'] . '</td>
- </tr>
- </table></td>
- </tr>';
- if ($row1['agent_id'] <> 0) {
- $mail_msg.='<tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #d6d6d6 solid">Agent Name:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #d6d6d6 solid">' . get_val_col("contacts", "FirstName", "CounterID", $row1['agent_id']) . '</td>
- </tr>
- </table></td>
- </tr>';
- }
- $mail_msg.='</table></td>
- </tr>
- <tr valign="top" align="left">
- <td height="10"></td>
- </tr>';
- $query = "SELECT * FROM propertybooking_payment WHERE booking_reference='$booking_reference' and advance_amount>0 order by payment_date";
- $run = mysql_query($query);
- $total_row = mysql_num_rows($run);
- $paid_amount = 0.00;
- if ($total_row > 0) {
- $mail_msg.='<tr valign="top" align="left">
- <td style="padding-left:20px;"><table width="674" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td style="background:#00649c url(' . hosturl_1 . 'img/bluetitlebg.gif) repeat-x left top; height:27px; font-family:Arial, Helvetica, sans-serif; font-size:13px; font-weight:bold; color:#ffffff; padding-left:10px; line-height:27px;">Payment Details</td>
- </tr>
- </table></td>
- </tr>';
- while ($row = mysql_fetch_array($run)) {
- $paid_amount = $paid_amount + $row['advance_amount'];
- $mail_msg___.='
- <tr valign="top" align="left">
- <td style="background:#ffffff url(' . hosturl_1 . 'img/contentbg.gif) repeat-x left top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #e3e3e3 solid">Total Fee:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #e3e3e3 solid">$' . $row1['Total'] . '</td>
- </tr>
- </table></td>
- </tr>';
- $mail_msg.='<tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #e3e3e3 solid">Payment Date:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #e3e3e3 solid">' . date('M d, Y', strtotime($row['payment_date'])) . '</td>
- </tr>
- </table></td>
- </tr>';
- }
- }
- $mail_msg.='<tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #d6d6d6 solid"><strong>Amount Paid:</strong></td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #d6d6d6 solid">$' . sprintf("%.2f", $paid_amount) . '</td>
- </tr>
- </table></td>
- </tr>
- <tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:4px #d6d6d6 solid"><strong>Amount Due:</strong></td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:4px #d6d6d6 solid">$' . sprintf("%.2f", $row1['Total'] - $paid_amount) . '</td>
- </tr>
- </table></td>
- </tr>
- </table></td>
- </tr>';
- $mail_msg.=' </table></td>
- </tr>
- </table>';
- // end Manager Mail
- //************** start Customer Mail******************************
- $customermail_msg = '<table width="718" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td style="border-top:4px #e2eff6 solid; border-bottom:4px #626262 solid; padding-bottom:10px;"><table width="718" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="396" style="padding-top:34px; padding-left:20px;"><a href="#"><img src="' . hosturl_1 . $path . '/' . $upload_folder . '/' . $imgname . '" border="0" /></a></td>
- <td width="322" align="right" style="font-family:Arial, Helvetica, sans-serif; font-weight:bold; font-size:13px;"><p style="margin:0px; padding-bottom:3px; padding-top:18px; padding-right:10px;">' . $site_row['site_name'] . '</p>
- <p style="margin:0px; padding-right:10px;" >' . $site_row['Address1'] . ', ' . $site_row['City'] . ', ' . $site_row['StateID'] . ' ' . $site_row['Postalcode'] . '</p>
- <p style="border-bottom:1px #e3e3e3 solid; margin:0px; padding-top:8px;"></p>
- <p style="margin:0px; padding-top:8px; padding-right:10px;">Ph: ' . $site_row['Phone'] . ' Fax: ' . $site_row['Fax'] . '</p>
- <p style="margin:0px; padding-top:5px; padding-right:10px;">E-mail: <a href="mailto:' . $site_row['Email'] . '" style="color:#000; text-decoration:none">' . $site_row['Email'] . '</a></p></td>
- </tr>
- </table></td></tr>';
- $customermail_msg.='<tr valign="top" align="left">
- <td height="5"></td>
- </tr>
- <tr valign="top" align="left">
- <td style="border:1px #a9dbf5 solid; background:#eff6fa url(' . hosturl_1 . 'img/titlebg.gif) repeat-x left top; height:35px; line-height:35px; padding-left:23px; color:#005687; font-family:Arial, Helvetica, sans-serif; font-size:18px; font-weight:bold">Receipt</td>
- </tr>';
- $customermail_msg.='<tr valign="top" align="left">
- <td style="border:1px #a9dbf5 solid; border-top:0px; padding-bottom:20px;"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td style="padding-left:20px; font-family:Arial, Helvetica, sans-serif; font-size:13px;">' . html_entity_decode($site_row['email_msg_content_guest_website']) .
- '<p><strong>Following are the details of your transaction.</strong></p></td>
- </tr>
- <tr valign="top" align="left">
- <td style="padding-left:20px;"><table width="674" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td style="background:#00649c url(' . hosturl_1 . 'img/bluetitlebg.gif) repeat-x left top; height:27px; font-family:Arial, Helvetica, sans-serif; font-size:13px; font-weight:bold; color:#ffffff; padding-left:10px; line-height:27px;">Booking Information</td>
- </tr>
- </table></td>
- </tr>';
- $customermail_msg.='<tr valign="top" align="left">
- <td style="background:#ffffff url(' . hosturl_1 . 'img/contentbg.gif) repeat-x left top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #e3e3e3 solid">Property:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #e3e3e3 solid">' . $pro_title . '</td>
- </tr>
- </table></td>
- </tr>
- <tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #e3e3e3 solid">Property Address:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #e3e3e3 solid">' . $pro_addr . ', ' . $pro_city . ', ' . $pro_state . ' ' . $pro_zip . '</td>
- </tr>
- </table></td>
- </tr>
- <tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #e3e3e3 solid">Booking Duration:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #e3e3e3 solid">' . date('F d, Y', strtotime($min_date)) . ' through ' . date('F d, Y', strtotime(date("Y-m-d", strtotime("+1 day", strtotime($row1['DateTo']))))) . '</td>
- </tr>
- </table></td>
- </tr>
- <tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:4px #d6d6d6 solid">Booking Source:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:4px #d6d6d6 solid">' . $booking_source . '</td>
- </tr>
- </table></td>
- </tr>
- </table></td>
- </tr>';
- $customermail_msg.=' <tr valign="top" align="left">
- <td height="10"></td>
- </tr>
- <tr valign="top" align="left">
- <td style="padding-left:20px;"><table width="674" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td style="background:#00649c url(' . hosturl_1 . 'img/bluetitlebg.gif) repeat-x left top; height:27px; font-family:Arial, Helvetica, sans-serif; font-size:13px; font-weight:bold; color:#ffffff; padding-left:10px; line-height:27px;">Guest Details</td>
- </tr>
- </table></td>
- </tr>
- <tr valign="top" align="left">
- <td style="background:#ffffff url(' . hosturl_1 . 'img/contentbg.gif) repeat-x left top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #e3e3e3 solid">Guest:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #e3e3e3 solid">' . $first_name . ' ' . $last_name . '</td>
- </tr>
- </table></td>
- </tr>
- <tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #e3e3e3 solid">Address:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #e3e3e3 solid">' . $address . ', ' . $city . ', ' . $state . ' ' . $postal_code . '</td>
- </tr>
- </table></td>
- </tr>
- <tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #e3e3e3 solid">Phone:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #e3e3e3 solid">' . $phonenumber . '</td>
- </tr>
- </table></td>
- </tr>
- <tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:4px #d6d6d6 solid">Email:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:4px #d6d6d6 solid">' . $Email . '</td>
- </tr>
- </table></td>
- </tr>
- </table></td>
- </tr>
- <tr valign="top" align="left">
- <td height="10"></td>
- </tr>';
- $customermail_msg.='<tr valign="top" align="left">
- <td style="padding-left:20px;"><table width="674" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td style="background:#009c64 url(' . hosturl_1 . 'img/greentitlebg.gif) repeat-x left top; height:27px; font-family:Arial, Helvetica, sans-serif; font-size:13px; font-weight:bold; color:#ffffff; padding-left:10px; line-height:27px;">Fees</td>
- </tr>
- </table></td>
- </tr>
- <tr valign="top" align="left">
- <td style="background:#ffffff url(' . hosturl_1 . 'img/contentbg.gif) repeat-x left top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #e3e3e3 solid">Rental:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #e3e3e3 solid">$' . $row1['RentalFees'] . '</td>
- </tr>
- </table></td>
- </tr>';
- $rf = $row1['RentalFees'];
- $uf = $row1['UpgradesFee'];
- $cf = $row1['CleaningFee'];
- $dis = $row1['property_discount'];
- $total = $rf + $uf + $cf - $dis;
- if (isset($row1['tax_amount']) && $row1['tax_amount'] > 0) {
- $t = $row1['tax_amount'];
- } else {
- if ($row1['tax_include'] == 1) {
- if ($row1['cleanfee_include'] == 1)
- $t = ($total * $row1['Tax__Percentage']) / (100 + $row1['Tax__Percentage']);
- else
- $t = (($total - $cf) * $row1['Tax__Percentage']) / (100 + $row1['Tax__Percentage']);
- }
- else {
- if ($row1['cleanfee_include'] == 1)
- $t = ($total * $row1['Tax__Percentage']) / 100;
- else
- $t = (($total - $cf) * $row1['Tax__Percentage']) / 100;
- }
- }
- $tax = $t;
- $tax = sprintf("%.2f", $tax);
- if ($row1['tax_include'] == 0)
- $total = $total + $tax;
- $ccardfee = 0;
- if ($pay_method != 'Cash') {
- $ccardfee = ($total * $row1['CreditCardFee_Percentage']) / 100;
- $ccardfee = sprintf("%.2f", $ccardfee);
- } else if ($pay_method == 'Cheque') {
- $ccardfee = 0;
- }
- else
- $ccardfee = sprintf("%.2f", $ccardfee);
- $total = $total + $ccardfee;
- //$customermail_msg=$customermail_msg.'<tr><td align="right" valign="top"><strong>Optional Upgrade:</strong> </td> <td align="left" valign="top">';
- //$option_upgrade=$row1['optional_upgrade_options'];
- /*
- $upgrdid=array();
- $poolheat=$row1['optional_upgrade_options'];
- $poolheat=explode(',',$poolheat);
- $cnt=count($poolheat);
- for($i=0;$i<$cnt;$i++)
- {
- $poolid=explode('PRICE',$poolheat[$i]);
- $upgrdid[$i]=$poolid[0];
- }
- if($poolheat<>'')
- {
- $upids=implode(',',$upgrdid);
- $pooldetail=Booking::getPoolheat_forguest($upids);
- if($pooldetail)
- {
- //$customermail_msg=$customermail_msg."<table cellspacing=\"5\">";
- while($value=mysql_fetch_array($pooldetail))
- {
- $poolprice=Booking::getPoolPriceByUser($value,$row1);
- $customermail_msg.='<tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #e3e3e3 solid">Upgrade, '.$value['opUpgradeName'].':</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #e3e3e3 solid">$'.$poolprice.'('.$value['rate_type'].')</td>
- </tr>
- </table></td>
- </tr>';
- }
- //$customermail_msg=$customermail_msg. "<tr>";
- // $customermail_msg=$customermail_msg."<td align=\"right\">Sub-Total:</td>";
- // $customermail_msg=$customermail_msg."<td align=\"left\">$".$uf=$row1['UpgradesFee']."</td>";
- // $customermail_msg=$customermail_msg."</tr>";
- //$customermail_msg=$customermail_msg."</table>";
- }
- }
- */
- $customermail_msg.='<tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #d6d6d6 solid">Optional Upgrade:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #d6d6d6 solid">';
- $option_upgrade = $row1['optional_upgrade_options'];
- if ($option_upgrade <> '') {
- $option_upgrade = explode(",", $option_upgrade);
- $y = get_optiional_ugrade_list($row1['PropertyID']);
- $customermail_msg = $customermail_msg . "<table cellspacing=\"0\" width='100%'>";
- foreach ($option_upgrade as $value) {
- $val = explode("PRICE", $value);
- //check_price
- $customermail_msg = $customermail_msg . "<tr align='left'>";
- $customermail_msg = $customermail_msg . "<td align=\"left\" style='padding-bottom:10px;'>" . $y[$val[0]]['opUpgradeName'] . ":</td>";
- $customermail_msg = $customermail_msg . "<td align=\"left\" style='padding-bottom:10px;'>$" . $check_price_arr = check_price('optional_upgrade_property', 'rate_type,min_req_duration,upgradePrice', 'CounterId', $val[0], $noofdays) . "</td>";
- //$customermail_msg=$customermail_msg."<td align=\"left\" style='padding-bottom:10px;'>(".$y[$val[0]]['rate_type'].")</td>";
- $customermail_msg = $customermail_msg . "</tr>";
- }
- $customermail_msg = $customermail_msg . "<tr>";
- $customermail_msg = $customermail_msg . "<td align=\"left\" style='padding-bottom:10px;'>Sub-Total:</td>";
- $customermail_msg = $customermail_msg . "<td align=\"left\" style='padding-bottom:10px;'>$" . $row1['UpgradesFee'] . "</td>";
- $customermail_msg = $customermail_msg . "</tr>";
- $customermail_msg = $customermail_msg . "</table>";
- }
- $customermail_msg.='</td>
- </tr>
- </table></td>
- </tr>';
- $customermail_msg.='<tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #d6d6d6 solid">Cleaning:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #d6d6d6 solid">$' . $row1['CleaningFee'] . '</td>
- </tr>
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #d6d6d6 solid">Discount:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #d6d6d6 solid">$' . $dis . '</td>
- </tr>
- </table></td>
- </tr>
- <tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">';
- /* <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; color:#00466e; font-weight:bold; background-color:#e5eff4; padding-left:10px; border-bottom:1px #d6d6d6 solid">Sub Total:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; color:#00466e; font-weight:bold; background-color:#e5eff4; border-bottom:1px #d6d6d6 solid">$1,210.00</td>
- </tr> */
- $customermail_msg.='</table></td>
- </tr>
- <tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #d6d6d6 solid">Tax:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #d6d6d6 solid">';
- if ($row1['tax_include'] == 1)
- $p = '$' . $tax . ' (' . $row1['Tax__Percentage'] . ' % included in total)';
- else
- $p = '$' . $tax;
- $customermail_msg.=$p . '</td>
- </tr>
- </table></td>
- </tr>
- <tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">';
- /* <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #d6d6d6 solid">Credit Card Fee:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #d6d6d6 solid">$5.00 (3%)</td>
- </tr> */
- $customermail_msg.='</table></td>
- </tr>
- <tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; background-color:#cffdce; padding-bottom:5px; color:#00466e; font-weight:bold; padding-left:10px; border-bottom:4px #d6d6d6 solid">Total:</td>
- <td width="59%" style="padding-top:10px; background-color:#cffdce; padding-bottom:5px; color:#00466e; font-weight:bold; border-bottom:4px #d6d6d6 solid">$' .sprintf("%.2f", /*$row1['Total']*/ ($rf + $uf + $cf - $dis + $tax)) . '</td>
- </tr>
- </table></td>
- </tr>
- </table></td>
- </tr>
- <tr valign="top" align="left">
- <td height="10"></td>
- </tr>';
- $query = "SELECT * FROM propertybooking_payment WHERE booking_reference='$booking_reference' and advance_amount>0 order by payment_date";
- $run = mysql_query($query);
- $total_row = mysql_num_rows($run);
- $paid_amount = 0.00;
- if ($total_row > 0) {
- $customermail_msg.='<tr valign="top" align="left">
- <td style="padding-left:20px;"><table width="674" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td style="background:#00649c url(' . hosturl_1 . 'img/bluetitlebg.gif) repeat-x left top; height:27px; font-family:Arial, Helvetica, sans-serif; font-size:13px; font-weight:bold; color:#ffffff; padding-left:10px; line-height:27px;">Payment Details</td>
- </tr>
- </table></td>
- </tr>';
- while ($row = mysql_fetch_array($run)) {
- $paid_amount = $paid_amount + $row['advance_amount'];
- $customermail_msg_______.='
- <tr valign="top" align="left">
- <td style="background:#ffffff url(' . hosturl_1 . 'img/contentbg.gif) repeat-x left top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #e3e3e3 solid">Total Fee:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #e3e3e3 solid">$' .sprintf("%.2f", ($row1['Total']-(isset($row['credit_amount'])?$row['credit_amount']:0))) . '</td>
- </tr>
- </table></td>
- </tr>';
- $customermail_msg.='<tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #e3e3e3 solid">Payment Date:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #e3e3e3 solid">' . date('M d, Y', strtotime($row['payment_date'])) . '</td>
- </tr>
- </table></td>
- </tr>';
- if ($row['payment_method'] != 'Cash' and $row['credit_amount'] != "") {
- $customermail_msg.='<tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #e3e3e3 solid">Credit Card Fee:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #e3e3e3 solid">$' . sprintf("%.2f",$row['credit_amount']) . '</td>
- </tr>
- </table></td>
- </tr>';
- }
- }
- }
- $customermail_msg.='<tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #d6d6d6 solid"><strong>Amount Paid:</strong></td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #d6d6d6 solid">$' . sprintf("%.2f", $paid_amount) . '</td>
- </tr>
- </table></td>
- </tr>
- <tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:4px #d6d6d6 solid"><strong>Amount Due:</strong></td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:4px #d6d6d6 solid">$' . sprintf("%.2f", $row1['Total'] - $paid_amount) . '</td>
- </tr>
- </table></td>
- </tr>
- </table></td>
- </tr>';
- $customermail_msg.=' </table></td>
- </tr>
- </table>';
- // End Customer Mail*********************************//
- //$ownermail_msg='<p>'.$frommailOwner['message'].'</p><br/>';
- $ownermail_msg.='<table width="718" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td style="border-top:4px #e2eff6 solid; border-bottom:4px #626262 solid; padding-bottom:10px;"><table width="718" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="396" style="padding-top:34px; padding-left:20px;"><a href="#"><img src="' . hosturl_1 . $path . '/' . $upload_folder . '/' . $imgname . '" border="0" /></a></td>
- <td width="322" align="right" style="font-family:Arial, Helvetica, sans-serif; font-weight:bold; font-size:13px;"><p style="margin:0px; padding-bottom:3px; padding-top:18px; padding-right:10px;">' . $site_row['site_name'] . '</p>
- <p style="margin:0px; padding-right:10px;" >' . $site_row['Address1'] . ', ' . $site_row['City'] . ', ' . $site_row['StateID'] . ' ' . $site_row['Postalcode'] . '</p>
- <p style="border-bottom:1px #e3e3e3 solid; margin:0px; padding-top:8px;"></p>
- <p style="margin:0px; padding-top:8px; padding-right:10px;">Ph: ' . $site_row['Phone'] . ' Fax: ' . $site_row['Fax'] . '</p>
- <p style="margin:0px; padding-top:5px; padding-right:10px;">E-mail: <a href="mailto:' . $site_row['Email'] . '" style="color:#000; text-decoration:none">' . $site_row['Email'] . '</a></p></td>
- </tr>
- </table></td></tr>';
- $ownermail_msg.='<tr valign="top" align="left">
- <td height="5"></td>
- </tr>
- <tr valign="top" align="left">
- <td style="border:1px #a9dbf5 solid; background:#eff6fa url(' . hosturl_1 . 'img/titlebg.gif) repeat-x left top; height:35px; line-height:35px; padding-left:23px; color:#005687; font-family:Arial, Helvetica, sans-serif; font-size:18px; font-weight:bold">Receipt</td>
- </tr>';
- $ownermail_msg.='<tr valign="top" align="left">
- <td style="border:1px #a9dbf5 solid; border-top:0px; padding-bottom:20px;"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td style="padding-left:20px; font-family:Arial, Helvetica, sans-serif; font-size:13px;"><p> Dear ' . $Owner_Lastname . ',<p>' . html_entity_decode($site_row['email_msg_content_owner_website']) . '</p>
- <p><strong>Following are the details of your transaction.</strong></p>
- <p>Your Property ' . $pro_USERID . ' has been booked!</p></td>
- </tr>
- <tr valign="top" align="left">
- <td style="background:#ffffff url(' . hosturl_1 . 'img/contentbg.gif) repeat-x left top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #e3e3e3 solid">Guest Name:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #e3e3e3 solid">' . $guestlastname . '</td>
- </tr>
- </table></td>
- </tr>
- <tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #e3e3e3 solid">Booking Duration:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #e3e3e3 solid">' . date('F d, Y', strtotime($min_date)) . ' through ' . date('F d, Y', strtotime(date("Y-m-d", strtotime("+1 day", strtotime($row1['DateTo']))))) . '</td>
- </tr>
- </table></td>
- </tr>';
- /*
- $upgrdid=array();
- $poolheat=$row1['optional_upgrade_options'];
- $poolheat=explode(',',$poolheat);
- $cnt=count($poolheat);
- for($i=0;$i<$cnt;$i++)
- {
- $poolid=explode('PRICE',$poolheat[$i]);
- $upgrdid[$i]=$poolid[0];
- }
- $upids=implode(',',$upgrdid);
- $pooldetail=Booking::getPoolheat($upids);
- $poolprice=Booking::getPoolPriceByUser($pooldetail,$row1);
- if($poolprice>0)
- {
- $ownermail_msg.='<tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #e3e3e3 solid">Pool Heat:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #e3e3e3 solid">$'.sprintf('%.2f',$poolprice).'</td>
- </tr>
- </table></td>
- </tr>';
- }
- */
- $ownermail_msg.='<tr valign="top" align="left">
- <td style="padding-left:22px; padding-right:22px; font-family:Arial, Helvetica, sans-serif; font-size:13px; color:#00466e"><table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr valign="top" align="left">
- <td width="41%" style="padding-top:10px; padding-bottom:5px; padding-left:10px; border-bottom:1px #e3e3e3 solid">Rental Amount:</td>
- <td width="59%" style="padding-top:10px; padding-bottom:5px; border-bottom:1px #e3e3e3 solid">$' . ($row1['Total'] + $poolprice) . '</td>
- </tr>
- </table></td>
- </tr>
- </table></td>
- </tr>
- </table></table>';
- //$ownermail_msg = '<p>'.unhtmlentities($msg_content_owner_website).'<p/>'.$ownermail_msg;
- //$customermail_msg = $customermail_msg . '<br/><p>'.unhtmlentities($msg_content_guest_website).'<p/>';
- $new_sub = $rowp1['user_PropertyID'] . " - " . ucfirst($last_name); // Add Propetry ID and guest last name to subject line of mail....
- //if(get_val_col("site_info","notify_manager_of_booking","site_reference",$_SESSION['user_site_id'])==1)
- if (get_val_col("site_info", "notify_manager_website_of_booking", "site_reference", $siteKey)) {
- //$nfem=get_val_col("site_info","notify_manager_email","site_reference",$_SESSION['user_site_id']);
- $nfem = get_val_col("site_info", "notify_manager_website_email", "site_reference", $siteKey);
- if ($nfem != '' && $nfem != 'manager email address')
- $Manager_Email = $nfem;
- $E_mail_From = $frommail;
- $headers = "MIME-Version: 1.0\r\n";
- $headers .= "Content-type: text/html; charset=iso-8859-1\r\n";
- $headers .= 'From: <' . $E_mail_From . '>' . "\r\n";
- $subject = $frommailManager['subject'] ? $frommailManager['subject'] : "Booking Detail";
- $subject = $new_sub . " " . $subject;
- $mail_msg1 = str_replace("{##}", unhtmlentities($msg_content_manager_website), $mail_msg);
- echo "Manager Email ::----->" . $Manager_Email . "<br/>" . $mail_msg1;
- @mail('testforemail.test@gmail.com', 'Manager-' . $subject, $mail_msg1, $headers);
- if ($smtp_info['mailer'] == "smtp_mail") {
- $sendtocustomer = SMTP_AUTH_MAIL($frommail, $Manager_Email, $subject, $mail_msg1, $smtp_info['smtp_host'], $smtp_info['username'], $smtp_info['password']);
- //$sendtocustomer=mail($Customer_Email,$subject,$customermail_msg,$headers);
- } else {
- //echo $Manager_Email."<br>".$mail_msg;
- @mail($Manager_Email, $subject, $mail_msg1, $headers);
- }
- }
- ///new changes
- $E_mail_From = $frommail;
- $headers = "MIME-Version: 1.0\r\n";
- $headers .= "Content-type: text/html; charset=iso-8859-1\r\n";
- $headers .= 'From: <' . $E_mail_From . '>' . "\r\n";
- $subject = $frommailAgent['subject'] ? $frommailAgent['subject'] : "Booking Detail";
- $subject = $new_sub . " " . $subject;
- //if(get_val_col("site_info","notify_agent_of_booking","site_reference",$_SESSION['user_site_id'])==1)
- if (get_val_col("site_info", "notify_agent_website_of_booking", "site_reference", $siteKey)) {
- $mail_msg1 = str_replace("{##}", unhtmlentities($msg_content_agent_website), $mail_msg);
- echo "Agent Email ::----->" . $Agent_Email . "<br/>" . $mail_msg1;
- @mail('testforemail.test@gmail.com', 'agent-' . $subject, $mail_msg1, $headers);
- if ($smtp_info['mailer'] == "smtp_mail") {
- $sendtocustomer = SMTP_AUTH_MAIL($frommail, $Agent_Email, $subject, $mail_msg1, $smtp_info['smtp_host'], $smtp_info['username'], $smtp_info['password']);
- //$sendtocustomer=mail($Customer_Email,$subject,$customermail_msg,$headers);
- } else {
- @mail($Agent_Email, $subject, $mail_msg1, $headers);
- }
- }
- $E_mail_From = $frommail;
- $headers = "MIME-Version: 1.0\r\n";
- $headers .= "Content-type: text/html; charset=iso-8859-1\r\n";
- $headers .= 'From: <' . $E_mail_From . '>' . "\r\n";
- $subject = $frommailCross['subject'] ? $frommailCross['subject'] : "Booking Detail";
- $subject = $new_sub . " " . $subject;
- //if(get_val_col("site_info","notify_crosshire_of_booking","site_reference",$_SESSION['user_site_id'])==1)
- if (get_val_col("site_info", "notify_crosshire_website_of_booking", "site_reference", $siteKey)) {
- $mail_msg1 = str_replace("{##}", unhtmlentities($msg_content_crosshire_website), $mail_msg);
- echo "Crosshire Email ::----->" . $Cross_Email . "<br/>" . $mail_msg1;
- @mail('testforemail.test@gmail.com', 'crosshire-' . $subject, $mail_msg1, $headers);
- if ($smtp_info['mailer'] == "smtp_mail") {
- $sendtocustomer = SMTP_AUTH_MAIL($frommail, $Cross_Email, $subject, $mail_msg1, $smtp_info['smtp_host'], $smtp_info['username'], $smtp_info['password']);
- //$sendtocustomer=mail($Customer_Email,$subject,$customermail_msg,$headers);
- } else {
- @mail($Cross_Email, $subject, $mail_msg1, $headers);
- }
- }
- //end new changes
- $E_mail_From = $frommail;
- $headers = "MIME-Version: 1.0\r\n";
- $headers .= "Content-type: text/html; charset=iso-8859-1\r\n";
- $headers .= 'From: <' . $E_mail_From . '>' . "\r\n";
- $subject = $frommailOwner['subject'] ? $frommailOwner['subject'] : "Booking Detail";
- $subject = $new_sub . " " . $subject;
- if (get_val_col("site_info", "notify_owner_website_of_booking", "site_reference", $siteKey)) {
- if ($notify_owner == 1) {
- echo "Owner Email:----->" . $Owner_Email . "<br/>" . $ownermail_msg;
- @mail('testforemail.test@gmail.com', 'owner-' . $subject, $ownermail_msg, $headers);
- if ($smtp_info['mailer'] == "smtp_mail") {
- $sendtocustomer = SMTP_AUTH_MAIL($frommail, $Owner_Email, $subject, $ownermail_msg, $smtp_info['smtp_host'], $smtp_info['username'], $smtp_info['password']);
- //$sendtocustomer=mail($Customer_Email,$subject,$customermail_msg,$headers);
- } else {
- if (@mail($Owner_Email, $subject, $ownermail_msg, $headers)) {
- $qry = "update propertybooking_summary set maildateTime=CURDATE() where booking_reference='" . $row1['booking_reference'] . "'";
- mysql_query($qry);
- }
- }
- }
- }
- //if(intval($guestRecipt)== 1)
- //{
- //echo 'hhhhh'.$guestRecipt11."hello";
- //echo $customermail_msg;
- if (trim($Customer_Email) <> '') {
- $E_mail_From = $frommail;
- $headers = "MIME-Version: 1.0\r\n";
- $headers .= "Content-type: text/html; charset=iso-8859-1\r\n";
- $headers .= 'From: <' . $E_mail_From . '>' . "\r\n";
- $subject = $frommailGuest['subject'] ? $frommailGuest['subject'] : "Booking Detail";
- $subject = $new_sub . " " . $subject;
- echo "custumor email :: --->" . $Customer_Email . "<br/>" . $customermail_msg;
- @mail('testforemail.test@gmail.com', 'Customer-' . $subject, $mail_msg, $headers);
- if ($smtp_info['mailer'] == "smtp_mail") {
- $sendtocustomer = SMTP_AUTH_MAIL($frommail, $Customer_Email, $subject, $customermail_msg, $smtp_info['smtp_host'], $smtp_info['username'], $smtp_info['password']);
- //$sendtocustomer=mail($Customer_Email,$subject,$customermail_msg,$headers);
- } else {
- $sendtocustomer = mail($Customer_Email, $subject, $customermail_msg, $headers);
- }
- if ($sendtocustomer == '1') {
- $myup = "UPDATE propertybooking_customerdetail SET send_email='1' WHERE booking_reference='$booking_reference'";
- mysql_query($myup);
- }
- }
- //}
- if (get_val_col("site_info", "notify_guest_website_of_booking", "site_reference", $siteKey) == 1) {
- $booking_msg_guest_website = unhtmlentities($site_row['email_msg_content_guest_website']);
- } else {
- $booking_msg_guest_website = "Your booking has been successfully completed.";
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement