prefix . "ap_appointments";
$FilterData = $_POST['filtername'];
//if filter by service n staff
$underscore_pos = stripos($FilterData, '-');
$filter_by = substr($FilterData, 0, $underscore_pos);
if($FilterData =='today') {
$today_date = date('Y-m-d'); // first time pagination data and total page like 1 2 3 only today
$AllAppointments = $wpdb->get_results("select * from `$AppointmentTableName` WHERE `date` ='$today_date' ORDER BY `date` DESC limit $Offset, $NoOfRow ");
$cat=$wpdb->get_results("select * from `$AppointmentTableName` WHERE `date` ='$today_date' ORDER BY `date` DESC");
}
if($FilterData =='pending') {
$AllAppointments = $wpdb->get_results("select * from `$AppointmentTableName` WHERE `status` ='pending' ORDER BY `date` DESC limit $Offset,$NoOfRow");
$cat = $wpdb->get_results("select * from `$AppointmentTableName` WHERE `status` ='pending' ORDER BY `date` DESC");
}
if($FilterData =='approved') {
$AllAppointments = $wpdb->get_results("select * from `$AppointmentTableName` WHERE `status` ='approved' ORDER BY `date` DESC limit $Offset,$NoOfRow");
$cat = $wpdb->get_results("select * from `$AppointmentTableName` WHERE `status` ='approved' ORDER BY `date` DESC");
}
if($FilterData =='cancelled') {
$AllAppointments = $wpdb->get_results("select * from `$AppointmentTableName` WHERE `status` ='cancelled' ORDER BY `date` DESC limit $Offset,$NoOfRow");
$cat = $wpdb->get_results("select * from `$AppointmentTableName` WHERE `status` ='cancelled' ORDER BY `date` DESC");
}
if($FilterData =='done') {
$AllAppointments = $wpdb->get_results("select * from `$AppointmentTableName` WHERE `status` ='done' ORDER BY `date` DESC limit $Offset,$NoOfRow");
$cat = $wpdb->get_results("select * from `$AppointmentTableName` WHERE `status` ='done' ORDER BY `date` DESC");
}
if($FilterData =='All') {
//first time pagination data and total page like 1 2 3 only All appointment filter
$table_name = $wpdb->prefix . "ap_appointments";
$AllAppointments = $wpdb->get_results("select * from `$table_name` ORDER BY `date` DESC limit $Offset,$NoOfRow");
$cat = $wpdb->get_results("select * from `$table_name` ORDER BY `date` DESC");
}
} else {
// filter pagination with get filter
if(isset($_GET['filtername'])) {
global $wpdb;
$AppointmentTableName = $wpdb->prefix . "ap_appointments";
$FilterData = $_GET['filtername'];
//if filter by service n staff
$underscore_pos = stripos($FilterData, '-');
$filter_by = substr($FilterData, 0, $underscore_pos);
if($FilterData =='today') {
$today_date = date('Y-m-d');
$AllAppointments = $wpdb->get_results("select * from `$AppointmentTableName` WHERE `date` ='$today_date' ORDER BY `date` DESC limit $Offset,$NoOfRow");
$cat = $wpdb->get_results("select * from `$AppointmentTableName` WHERE `date` ='$today_date' ORDER BY `date` DESC");
}
if($FilterData =='pending') {
$AllAppointments = $wpdb->get_results("select * from `$AppointmentTableName` WHERE `status` ='pending' ORDER BY `date` DESC limit $Offset,$NoOfRow");
$cat = $wpdb->get_results("select * from `$AppointmentTableName` WHERE `status` ='pending' ORDER BY `date` DESC");
}
if($FilterData =='approved') {
$AllAppointments = $wpdb->get_results("select * from `$AppointmentTableName` WHERE `status` ='approved' ORDER BY `date` DESC limit $Offset,$NoOfRow");
$cat = $wpdb->get_results("select * from `$AppointmentTableName` WHERE `status` ='approved' ORDER BY `date` DESC");
}
if($FilterData =='cancelled') {
$AllAppointments = $wpdb->get_results("select * from `$AppointmentTableName` WHERE `status` ='cancelled' ORDER BY `date` DESC limit $Offset,$NoOfRow");
$cat = $wpdb->get_results("select * from `$AppointmentTableName` WHERE `status` ='cancelled' ORDER BY `date` DESC");
}
if($FilterData =='done') {
$AllAppointments = $wpdb->get_results("select * from `$AppointmentTableName` WHERE `status` ='done' ORDER BY `date` DESC limit $Offset,$NoOfRow");
$cat = $wpdb->get_results("select * from `$AppointmentTableName` WHERE `status` ='done' ORDER BY `date` DESC");
}
//pagination get value
if($FilterData =='All') {
$AllAppointments = $wpdb->get_results("select * from `$AppointmentTableName` ORDER BY `date` DESC limit $Offset,$NoOfRow");
$cat = $wpdb->get_results("select * from `$AppointmentTableName` ORDER BY `date` DESC");
}
} else {
//all appointment with pagination
global $wpdb;
$AppointmentTableName = $wpdb->prefix . "ap_appointments";
$AllAppointments = $wpdb->get_results("select * from `$AppointmentTableName` ORDER BY `date` DESC limit $Offset, $NoOfRow");
$cat = $wpdb->get_results("select * from `$AppointmentTableName` ORDER BY `date` DESC");
}
}?>
prefix . "ap_appointments";
$wpdb->query($wpdb->prepare("DELETE FROM `$AppointmentTable` WHERE `id` = %s;",$DeleteId));
echo "";
echo "";
}
}
// delete all selected appointment with checkbox
if(isset($_POST['deleteall'])) {
if(isset($_POST['checkbox'])) {
$AppointmentTable = $wpdb->prefix . "ap_appointments";
for($i=0; $i<=count($_POST['checkbox'])-1; $i++) {
$DeleteId = intval( $_POST['checkbox'][$i] );
$wpdb->query($wpdb->prepare("DELETE FROM `$AppointmentTable` WHERE `id` = %s;",$DeleteId));
}
echo "";
echo "";
} else {
echo "";
}
}
?>