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!'); } } }