function booking_front_user_data()
{
if (isset($_REQUEST['option']) and $_REQUEST['option'] == 'getSchdInfo') {
global $wpdb;
$gc = new booking_general_class();
$ret = '<table width="100%" border="0">';
$date = $_REQUEST['date'];
$loc_id = $_REQUEST['loc_id'];
$day = strtolower(date('l', strtotime($date)));
$schds = $wpdb->get_results("SELECT * FROM " . $wpdb->prefix . "booking_location_schedule WHERE loc_id='" . $loc_id . "' AND schd_day = '" . $day . "' AND schd_status = 'Active' ORDER BY schd_id");
if (is_array($schds)) {
foreach ($schds as $key => $value) {
$user_info = get_userdata($value->user_id);
$ret .= '<tr>
<td><strong>' . $user_info->display_name . '</strong>' . ($user_info->description != '' ? '<p>' . nl2br($user_info->description) . '</p>' : '') . '</td>
<td>' . ucfirst($value->schd_day) . ' (' . $date . ') ' . __('From', 'wpb') . ' ' . $value->schd_time_fr . ' ' . __('To', 'wpb') . ' ' . $value->schd_time_to . ' ' . __('Hrs', 'wpb') . '</td>
<td><a href="' . $gc->get_booking_url(array('schd_id' => $value->schd_id, 'loc_id' => $loc_id, 'date' => $date)) . '">' . __('Book Now', 'wpb') . '</a></td>
</tr>';
}
}
$ret .= '</table>';
echo $ret;
exit;
}
if (isset($_REQUEST['option']) and $_REQUEST['option'] == 'SchdBookingSubmit') {
if (!session_id()) {
@session_start();
}
if ($_REQUEST['loc_id'] == '' or $_REQUEST['schd_id'] == '') {
wp_die('Location not selected.');
}
global $wpdb, $booking_payment_methods;
$gc = new booking_general_class();
$mc = new booking_message_class();
$blc = new booking_log_class();
$log_data['loc_id'] = $_REQUEST['loc_id'];
$log_data['schd_id'] = $_REQUEST['schd_id'];
$log_data['schd_date'] = $_REQUEST['schd_date'];
$log_data['user_id'] = get_current_user_id();
$log_data['c_name'] = $_REQUEST['c_name'];
$log_data['c_email'] = $_REQUEST['c_email'];
$log_data['c_phone'] = $_REQUEST['c_phone'];
$log_data['order_date'] = date("Y-m-d H:i:s");
$log_data['order_price'] = get_option('schd_booking_price');
$log_data['order_status'] = 'Processing';
$wpdb->insert($wpdb->prefix . "booking_log", $log_data);
$log_id = $wpdb->insert_id;
// put data in session //
$_SESSION['b_order']['name'] = $blc->get_loc_data($log_data['loc_id']);
$_SESSION['b_order']['price'] = get_option('schd_booking_price');
$_SESSION['b_order']['log_id'] = $log_id;
// put data in session //
if (get_option('schd_booking_price') == '' || get_option('schd_booking_price') == '0' || get_option('schd_booking_price') == '0.00') {
// booking is free
// send email to user //
$gc->sendOrderEmail($log_id);
$mc->add_message(__('Booking successfully registered. Please check your email for details.', 'wpb'));
$booking_form_page = get_option('booking_form_page');
wp_redirect(get_permalink($booking_form_page));
exit;
} else {
wp_die('Payment not allowed!');
}
}
}
function sendOrderEmail($book_id = '')
{
if ($book_id == '') {
return;
}
$blc = new booking_log_class();
$data = $blc->get_single_row_data($book_id);
if (!is_array($data)) {
return;
}
ob_start();
?>
<table width="90%" border="0">
<tbody>
<tr>
<td><h2><?php
_e('Order Details', 'wpb');
?>
<?php
_e('#');
?>
<?php
echo $data['book_id'];
?>
</h2></td>
<td><p> <strong><?php
_e('Date', 'wpb');
?>
</strong> <?php
echo $data['order_date'];
?>
</p></td>
</tr>
<tr>
<td colspan="2"><hr></td>
</tr>
<tr>
<td valign="top"><strong><?php
_e('Location Details', 'wpb');
?>
</strong></td>
<td><?php
echo $blc->get_loc_data($data['loc_id']);
?>
<p><?php
echo nl2br(get_post_meta($data['loc_id'], 'booking_address', true));
?>
</p>
</td>
</tr>
<tr>
<td colspan="2"><hr></td>
</tr>
<tr>
<td valign="top"><strong><?php
_e('Your Details', 'wpb');
?>
</strong></td>
<td><?php
echo $data['c_name'];
?>
<br><?php
echo $data['c_email'];
?>
<br><?php
echo $data['c_phone'];
?>
<br></td>
</tr>
<tr>
<td colspan="2"><hr></td>
</tr>
<tr>
<td valign="top"><strong><?php
_e('Schedule Details', 'wpb');
?>
</strong></td>
<td><?php
echo $blc->get_schd_data($data['schd_id'], $data['schd_date']);
?>
</td>
</tr>
<tr>
<td colspan="2"><hr></td>
</tr>
<tr>
<td><strong><?php
_e('Order Total', 'wpb');
?>
</strong></td>
<td><?php
echo BOOKING_CURRENCY;
?>
<?php
echo $data['order_price'];
?>
</td>
</tr>
<tr>
<td><strong><?php
_e('Status', 'wpb');
?>
</strong></td>
<td><?php
echo $data['order_status'];
?>
</td>
</tr>
</tbody>
</table>
<?php
$body = ob_get_contents();
ob_end_clean();
add_filter('wp_mail_content_type', array($this, 'set_html_content_type'));
$to = $data['c_email'];
$multiple_tos = array($data['c_email'], get_option('booking_admin_email'));
$headers[] = 'From: ' . get_option('booking_admin_email_from_name') . ' <' . get_option('booking_admin_email') . '>';
$subject = __('Booking Order Status');
wp_mail($multiple_tos, $subject, $body, $headers);
remove_filter('wp_mail_content_type', array($this, 'set_html_content_type'));
return;
}
function wp_booking_log_data()
{
$blc = new booking_log_class();
$blc->display_list();
}
