function trav_acc_send_confirmation_email($booking_no, $booking_pincode, $type = 'new', $subject = '', $description = '') { global $wpdb, $logo_url, $trav_options; $booking_data = trav_acc_get_booking_data($booking_no, $booking_pincode); if (!empty($booking_data)) { // server variables $admin_email = get_option('admin_email'); $home_url = esc_url(home_url()); $site_name = $_SERVER['SERVER_NAME']; $logo_url = esc_url($logo_url); $acc_book_conf_url = trav_acc_get_book_conf_url(); $booking_data['accommodation_id'] = trav_acc_clang_id($booking_data['accommodation_id']); $booking_data['room_type_id'] = trav_room_clang_id($booking_data['room_type_id']); // accommodation info $accommodation_name = get_the_title($booking_data['accommodation_id']); $accommodation_url = esc_url(trav_get_permalink_clang($booking_data['accommodation_id'])); $accommodation_thumbnail = get_the_post_thumbnail($booking_data['accommodation_id'], 'list-thumb'); $accommodation_address = get_post_meta($booking_data['accommodation_id'], 'trav_accommodation_address', true); $accommodation_city = trav_acc_get_city($booking_data['accommodation_id']); $accommodation_country = trav_acc_get_country($booking_data['accommodation_id']); $accommodation_phone = get_post_meta($booking_data['accommodation_id'], 'trav_accommodation_phone', true); $accommodation_email = get_post_meta($booking_data['accommodation_id'], 'trav_accommodation_email', true); $accommodation_room_name = esc_html(get_the_title($booking_data['room_type_id'])); if (empty($accommodation_address)) { $accommodation_address = $accommodation_city . ' ' . $accommodation_country; } $check_in = get_post_meta($booking_data['accommodation_id'], 'trav_accommodation_check_in', true); $check_out = get_post_meta($booking_data['accommodation_id'], 'trav_accommodation_check_out', true); $check_in_time = empty($check_in) ? $booking_data['date_from'] : $booking_data['date_from'] . ' ' . $check_in; $check_out_time = empty($check_out) ? $booking_data['date_to'] : $booking_data['date_to'] . ' ' . $check_out; // booking info $booking_no = $booking_data['booking_no']; $booking_pincode = $booking_data['pin_code']; $date_from = new DateTime($booking_data['date_from']); $date_to = new DateTime($booking_data['date_to']); $number1 = $date_from->format('U'); $number2 = $date_to->format('U'); $booking_nights = ($number2 - $number1) / (3600 * 24); $booking_checkin_time = date('l, F, j, Y', trav_strtotime($booking_data['date_from'])); $booking_checkout_time = date('l, F, j, Y', trav_strtotime($booking_data['date_to'])); $booking_rooms = $booking_data['rooms']; $booking_adults = $booking_data['adults']; $booking_kids = $booking_data['kids']; $booking_room_price = esc_html(trav_get_price_field($booking_data['room_price'] * $booking_data['exchange_rate'], $booking_data['currency_code'], 0)); $booking_tax = esc_html(trav_get_price_field($booking_data['tax'] * $booking_data['exchange_rate'], $booking_data['currency_code'], 0)); $booking_total_price = esc_html(trav_get_price_field($booking_data['total_price'] * $booking_data['exchange_rate'], $booking_data['currency_code'], 0)); $booking_deposit_price = esc_html($booking_data['deposit_price'] . $booking_data['currency_code']); $booking_deposit_paid = esc_html(empty($booking_data['deposit_paid']) ? 'No' : 'Yes'); $booking_update_url = esc_url(add_query_arg(array('booking_no' => $booking_data['booking_no'], 'pin_code' => $booking_data['pin_code']), $acc_book_conf_url)); // customer info $customer_first_name = $booking_data['first_name']; $customer_last_name = $booking_data['last_name']; $customer_email = $booking_data['email']; $customer_country_code = $booking_data['country_code']; $customer_phone = $booking_data['phone']; $customer_address = $booking_data['address']; $customer_city = $booking_data['city']; $customer_zip = $booking_data['zip']; $customer_country = $booking_data['country']; $customer_special_requirements = $booking_data['special_requirements']; $variables = array('home_url', 'site_name', 'logo_url', 'accommodation_name', 'accommodation_url', 'accommodation_thumbnail', 'accommodation_country', 'accommodation_city', 'accommodation_address', 'accommodation_phone', 'accommodation_email', 'accommodation_room_name', 'booking_no', 'booking_pincode', 'booking_nights', 'booking_checkin_time', 'booking_checkout_time', 'booking_rooms', 'booking_adults', 'booking_kids', 'booking_room_price', 'booking_tax', 'booking_total_price', 'booking_deposit_price', 'booking_deposit_paid', 'booking_update_url', 'customer_first_name', 'customer_last_name', 'customer_email', 'customer_country_code', 'customer_phone', 'customer_address', 'customer_city', 'customer_zip', 'customer_country', 'customer_special_requirements'); if (empty($subject)) { if ($type == 'new') { $subject = empty($trav_options['acc_confirm_email_subject']) ? 'Booking Confirmation Email Subject' : $trav_options['acc_confirm_email_subject']; } elseif ($type == 'update') { $subject = empty($trav_options['acc_update_email_subject']) ? 'Booking Updated Email Subject' : $trav_options['acc_update_email_subject']; } elseif ($type == 'cancel') { $subject = empty($trav_options['acc_cancel_email_subject']) ? 'Booking Canceled Email Subject' : $trav_options['acc_cancel_email_subject']; } } if (empty($description)) { if ($type == 'new') { $description = empty($trav_options['acc_confirm_email_description']) ? 'Booking Confirmation Email Description' : $trav_options['acc_confirm_email_description']; } elseif ($type == 'update') { $description = empty($trav_options['acc_update_email_description']) ? 'Booking Confirmation Email Description' : $trav_options['acc_update_email_description']; } elseif ($type == 'cancel') { $description = empty($trav_options['acc_cancel_email_description']) ? 'Booking Confirmation Email Description' : $trav_options['acc_cancel_email_description']; } } foreach ($variables as $variable) { $subject = str_replace("[" . $variable . "]", ${$variable}, $subject); $description = str_replace("[" . $variable . "]", ${$variable}, $description); } if (!empty($trav_options['acc_confirm_email_ical']) && $type == 'new') { $mail_sent = trav_send_ical_event($site_name, $admin_email, $customer_first_name . ' ' . $customer_last_name, $customer_email, $check_in_time, $check_out_time, $subject, $description, $accommodation_address); } else { $mail_sent = trav_send_mail($site_name, $admin_email, $customer_email, $subject, $description); } /* mailing function to business owner */ $bowner_address = ''; if (!empty($trav_options['acc_booked_notify_bowner'])) { if ($type == 'new') { $subject = empty($trav_options['acc_bowner_email_subject']) ? 'You received a booking' : $trav_options['acc_bowner_email_subject']; $description = empty($trav_options['acc_bowner_email_description']) ? 'Booking Details' : $trav_options['acc_bowner_email_description']; } elseif ($type == 'update') { $subject = empty($trav_options['acc_update_bowner_email_subject']) ? 'A booking is updated' : $trav_options['acc_update_bowner_email_subject']; $description = empty($trav_options['acc_update_bowner_email_description']) ? 'Booking Details' : $trav_options['acc_update_bowner_email_description']; } elseif ($type == 'cancel') { $subject = empty($trav_options['acc_cancel_bowner_email_subject']) ? 'A booking is canceled' : $trav_options['acc_cancel_bowner_email_subject']; $description = empty($trav_options['acc_cancel_bowner_email_description']) ? 'Booking Details' : $trav_options['acc_cancel_bowner_email_description']; } foreach ($variables as $variable) { $subject = str_replace("[" . $variable . "]", ${$variable}, $subject); $description = str_replace("[" . $variable . "]", ${$variable}, $description); } if (!empty($accommodation_email)) { $bowner_address = $accommodation_email; } else { $post_author_id = get_post_field('post_author', $booking_data['accommodation_id']); $bowner = get_user_by('id', $post_author_id); if (!empty($bowner)) { $bowner_address = $bowner->user_email; } } if (!empty($bowner_address)) { trav_send_mail($site_name, $admin_email, $bowner_address, $subject, $description); } } /* mailing function to admin */ if (!empty($trav_options['acc_booked_notify_admin'])) { if ($bowner_address != $admin_email) { if ($type == 'new') { $subject = empty($trav_options['acc_admin_email_subject']) ? 'You received a booking' : $trav_options['acc_admin_email_subject']; $description = empty($trav_options['acc_admin_email_description']) ? 'Booking Details' : $trav_options['acc_admin_email_description']; } elseif ($type == 'update') { $subject = empty($trav_options['acc_update_admin_email_subject']) ? 'A booking is updated' : $trav_options['acc_update_admin_email_subject']; $description = empty($trav_options['acc_update_admin_email_description']) ? 'Booking Details' : $trav_options['acc_update_admin_email_description']; } elseif ($type == 'cancel') { $subject = empty($trav_options['acc_cancel_admin_email_subject']) ? 'A booking is canceled' : $trav_options['acc_cancel_admin_email_subject']; $description = empty($trav_options['acc_cancel_admin_email_description']) ? 'Booking Details' : $trav_options['acc_cancel_admin_email_description']; } foreach ($variables as $variable) { $subject = str_replace("[" . $variable . "]", ${$variable}, $subject); $description = str_replace("[" . $variable . "]", ${$variable}, $description); } trav_send_mail($site_name, $admin_email, $admin_email, $subject, $description); } } return true; } return false; }
?> </div> <div class="col-md-6"> <h2><?php echo __('Recent Activity', 'trav'); ?> </h2> <div class="recent-activity"> <ul> <?php $recent_activity = get_user_meta($user_id, 'recent_activity', true); if (!empty($recent_activity)) { $recent_activity_array = unserialize($recent_activity); foreach ($recent_activity_array as $post_id) { $post_id = trav_acc_clang_id($post_id); $post_type = get_post_type($post_id); if (!in_array($post_type, $available_post_types)) { continue; } if ($post_type == 'accommodation') { $_country = get_post_meta($post_id, 'trav_accommodation_country', true); if (!empty($_country)) { if ($country_obj = get_term_by('id', $_country, 'location')) { $_country = __($country_obj->name, 'trav'); } } $_city = get_post_meta($post_id, 'trav_accommodation_city', true); if (!empty($_city)) { if ($user_info['city_obj'] = get_term_by('id', $_city, 'location')) { $_city = __($user_info['city_obj']->name, 'trav');
<?php /* * Accommodation List */ global $acc_list, $current_view, $before_article, $after_article; foreach ($acc_list as $acc_id) { $acc_id = trav_acc_clang_id($acc_id); $avg_price = get_post_meta($acc_id, 'trav_accommodation_avg_price', true); $review = get_post_meta($acc_id, 'review', true); $review = !empty($review) ? round($review, 1) : 0; $brief = get_post_meta($acc_id, 'trav_accommodation_brief', true); $discount_rate = get_post_meta($acc_id, 'trav_accommodation_discount_rate', true); if (empty($brief)) { $brief = apply_filters('the_content', get_post_field('post_content', $acc_id)); $brief = wp_trim_words($brief, 20, ''); } $loc = get_post_meta($acc_id, 'trav_accommodation_loc', true); $rooms = isset($_REQUEST['rooms']) && is_numeric($_REQUEST['rooms']) ? sanitize_text_field($_REQUEST['rooms']) : 1; $adults = isset($_REQUEST['adults']) && is_numeric($_REQUEST['adults']) ? sanitize_text_field($_REQUEST['adults']) : 1; $kids = isset($_REQUEST['kids']) && is_numeric($_REQUEST['kids']) ? sanitize_text_field($_REQUEST['kids']) : 0; $child_ages = isset($_REQUEST['child_ages']) && is_array($_REQUEST['child_ages']) ? $_REQUEST['child_ages'] : array(); $date_from = isset($_REQUEST['date_from']) ? trav_sanitize_date($_REQUEST['date_from']) : ''; $date_to = isset($_REQUEST['date_to']) ? trav_sanitize_date($_REQUEST['date_to']) : ''; if (trav_strtotime($date_from) >= trav_strtotime($date_to)) { $date_from = ''; $date_to = ''; } $query_args = array('adults' => $adults, 'kids' => $kids, 'rooms' => $rooms, 'date_from' => $date_from, 'date_to' => $date_to); if (!empty($child_ages)) { $query_args['child_ages'] = $child_ages;
function trav_get_user_booking_list($user_id, $status = 1, $sortby = 'created', $order = 'desc') { global $wpdb, $trav_options; $sql = ''; $order = $order == 'desc' ? 'desc' : 'asc'; $order_by = ' ORDER BY ' . esc_sql($sortby) . ' ' . $order; $where = ' WHERE 1=1'; $where .= ' AND user_id=' . esc_sql($user_id); if ($status != -1) { $where .= ' AND status=' . esc_sql($status); } // $sql = $wpdb->prepare( 'SELECT * FROM ' . TRAV_ACCOMMODATION_BOOKINGS_TABLE . $where . $order_by, $user_id ); $available_modules = trav_get_available_modules(); $sqls = array(); if (in_array('accommodation', $available_modules)) { $sqls[] = "SELECT 'accommodation' AS post_type, booking_no, pin_code, total_price, created, status, accommodation_id AS post_id, date_from AS event_date, adults, rooms AS tickets FROM " . TRAV_ACCOMMODATION_BOOKINGS_TABLE . $where; } if (in_array('tour', $available_modules)) { $sqls[] = "SELECT 'tour' AS post_type, booking_no, pin_code, total_price, created, status, tour_id AS post_id, tour_date AS event_date, adults, NULL AS tickets FROM " . TRAV_TOUR_BOOKINGS_TABLE . $where; } $sql = implode(' UNION ALL ', $sqls); $sql .= $order_by; //return $sql; $booking_list = $wpdb->get_results($sql); if (empty($booking_list)) { return __('You don\'t have any booked trips yet.', 'trav'); } // if empty return false $acc_book_conf_url = trav_acc_get_book_conf_url(); $tour_book_conf_url = trav_tour_get_book_conf_url(); $html = ''; foreach ($booking_list as $booking_data) { $class = ''; $label = 'UPCOMMING'; if ($booking_data->status == 0) { $class = ' cancelled'; $label = 'CANCELLED'; } if ($booking_data->status == 2) { $class = ' completed'; $label = 'COMPLETED'; } // if ( ( $booking_data->status == 1 ) && ( trav_strtotime( $booking_data->event_date ) < trav_strtotime(date('Y-m-d')) ) ) { $class = ' completed'; $label = 'COMPLETED'; } $html .= '<div class="booking-info clearfix' . $class . '">'; $html .= '<div class="date"> <label class="month">' . date('M', trav_strtotime($booking_data->event_date)) . '</label> <label class="date">' . date('d', trav_strtotime($booking_data->event_date)) . '</label> <label class="day">' . date('D', trav_strtotime($booking_data->event_date)) . '</label> </div>'; $conf_url = ''; $icon_class = ''; if ('accommodation' == $booking_data->post_type) { $conf_url = $acc_book_conf_url; $icon_class = 'soap-icon-hotel blue-color'; } elseif ('tour' == $booking_data->post_type) { $conf_url = $tour_book_conf_url; $icon_class = 'soap-icon-beach yellow-color'; } $url = empty($conf_url) ? '' : add_query_arg(array('booking_no' => $booking_data->booking_no, 'pin_code' => $booking_data->pin_code), $conf_url); $html .= '<h4 class="box-title">'; $html .= '<i class="icon circle ' . $icon_class . '"></i>'; $html .= '<a href="' . esc_url($url) . '">' . get_the_title(trav_acc_clang_id($booking_data->post_id)) . '</a>'; $html .= '<small>'; if ('accommodation' == $booking_data->post_type) { $html .= $booking_data->tickets . __('rooms', 'trav') . ' '; } $html .= $booking_data->adults . __('adults', 'trav') . '</small></h4>'; $html .= '<button class="btn-mini status">' . __($label, 'trav') . '</button>'; $html .= '<dl class="info">'; $html .= '<dt>' . __('booked on', 'trav') . '</dt>'; $html .= '<dd>' . date('l, M, j, Y', trav_strtotime($booking_data->created)) . '</dd>'; $html .= '</dl>'; $html .= '<dl class="info">'; $html .= '<dt>' . __('BOOKING NO', 'trav') . '</dt><dd>' . $booking_data->booking_no . '</dd>'; $html .= '<dt>' . __('PIN CODE', 'trav') . '</dt><dd>' . $booking_data->pin_code . '</dd>'; $html .= '</dl>'; $html .= '</div>'; } return $html; }
<?php /** * Accommodation Booking Confirmation Template */ global $wpdb; global $booking_data, $acc_id, $room_type_id, $deposit_rate, $date_from, $date_to; if (!isset($_REQUEST['booking_no']) || !isset($_REQUEST['pin_code'])) { do_action('trav_acc_conf_wrong_data'); exit; } if (!($booking_data = trav_acc_get_booking_data($_REQUEST['booking_no'], $_REQUEST['pin_code']))) { do_action('trav_acc_conf_wrong_data'); exit; } $acc_id = trav_acc_clang_id($booking_data['accommodation_id']); $room_type_id = trav_room_clang_id($booking_data['room_type_id']); $deposit_rate = get_post_meta($acc_id, 'trav_accommodation_security_deposit', true); $deposit_rate = empty($deposit_rate) ? 0 : $deposit_rate; $date_from = trav_tophptime($booking_data['date_from']); $date_to = trav_tophptime($booking_data['date_to']); if (!is_array($booking_data['child_ages'])) { $booking_data['child_ages'] = unserialize($booking_data['child_ages']); } $query_args = array('date_from' => $date_from, 'date_to' => $date_to, 'rooms' => $booking_data['rooms'], 'adults' => $booking_data['adults'], 'kids' => $booking_data['kids'], 'child_ages' => $booking_data['child_ages'], 'edit_booking_no' => $booking_data['booking_no'], 'pin_code' => $booking_data['pin_code']); // if deposit is required and it is not paid process payment if (!empty($deposit_rate) && empty($booking_data['deposit_paid'])) { // init payment variables $ItemName = ''; if ($deposit_rate < 100) { $ItemName = sprintf(__('Deposit(%d%%) for ', 'trav'), $deposit_rate);