function get_query_string_for_export()
{
$str = '';
if (($s = browser_request('s')) != '') {
$str .= '&s=' . $s;
}
if (($status = browser_request('status')) != '') {
$str .= '&status=' . $status;
}
if (($status = browser_request('filter_payment_status')) != '') {
$str .= '&filter_payment_status=' . $status;
}
if (($room_type_ID = browser_request('filter_room_ID')) != '') {
$str .= '&room_type_ID=' . $room_type_ID;
}
if (($checkin = browser_request('filter_date_in')) != '' && ($checkout = browser_request('filter_date_out')) != '') {
$str .= '&filter_date_in=' . $checkin . '&filter_date_out=' . $checkout;
}
return $str;
}
function get_bookings_for_export()
{
global $wpdb;
$sql = "SELECT booking_no, p.post_title, room_price, b.date_in, b.date_out, b.no_of_night, b.no_of_room, amount, amount_paid, b.no_of_adult, b.no_of_child, CONCAT(b.salutation, '. ', b.first_name,' ', b.middle_name, ' ', b.last_name) as guest_name, b.birth_date, b.email_address, b.primary_phone, b.country, b.address_1, b.address_2, b.province, b.city, b.zipcode, b.nationality, b.booking_status, b.payment_status, b.date_booked FROM " . $wpdb->prefix . "bookings b JOIN " . $wpdb->prefix . "posts p ON p.ID = b.room_type_ID WHERE 1 = 1";
if (($s = browser_request('s')) != '') {
$sql .= " AND ( booking_no = '" . $s . "' OR p.post_title LIKE '%" . $s . "%' OR b.first_name LIKE '%" . $s . "%' OR b.last_name LIKE '%" . $s . "%' ) ";
}
if (($status = browser_request('status')) != '') {
$sql .= " AND (b.booking_status = '" . $status . "' ) ";
}
if (($status = browser_request('filter_payment_status')) != '') {
$sql .= " AND (b.payment_status = '" . $status . "' ) ";
}
if (($room_type_ID = browser_request('filter_room_ID')) != '') {
$sql .= " AND (b.room_type_ID = '" . $room_type_ID . "' ) ";
}
if (($checkin = browser_request('filter_date_in')) != '' && ($checkout = browser_request('filter_date_out')) != '') {
$sql .= " AND (date_in >= '" . format_db_date($checkin, 'Y-m-d') . "' AND date_out <= '" . format_db_date($checkout, 'Y-m-d') . "' ) ";
}
$results = $wpdb->get_results($sql, ARRAY_A);
return $results;
}
selected($s, browser_request('filter_payment_status'));
?>
><?php
echo $s;
?>
</option>
<?php
}
?>
</select>
<input type="text" name="filter_date_in" id="filter_date_in" value="<?php
echo browser_request('filter_date_in');
?>
" placeholder="Check In"/>
<input type="text" name="filter_date_out" id="filter_date_out" value="<?php
echo browser_request('filter_date_out');
?>
" placeholder="Check Out"/>
<input type="submit" id="filter" class="button" value="Filter">
<a href="<?php
echo admin_url('/admin.php?page=manage-bookings');
?>
" class="button">Reset</a>
</p>
<input type="hidden" name="page" value="cebu-dream-booking" />
</form>
<form method="POST">
<?php
$booking_list_table->display();
?>
public function render_rooms_and_guest_info()
{
if (defined('DOING_AJAX') && DOING_AJAX) {
$data = array();
$data['rooms_and_guest'] = get_rooms_and_guest_info(browser_request('booking_ID', 0));
include_view('rooms_and_guest_info.html.php', $data);
exit;
}
}
public function get_views()
{
$views = array();
$current = browser_request('status', 'all');
$statuses = booking_statuses();
//All link
$class = $current == 'all' ? ' class="current"' : '';
$all_url = remove_query_arg('status');
$views['all'] = "<a href='{$all_url}' {$class} >All</a>";
foreach ($statuses as $s) {
$slug = sanitize_title_with_dashes($s);
$url = add_query_arg('status', $s);
$class = $current == $slug ? ' class="current"' : '';
$views[$slug] = '<a href="' . $url . '" ' . $class . ' >' . $s . '</a>';
}
return $views;
}
