get_results("select * from $wpdb->prefix"."apt_holidays");
$num_rows=count($ap_fecth);
if($num_rows !==0) {
foreach($ap_fecth as $value) {
//$status_show ="Upcoming" ;
$status=date("m/d/Y");
$all_off=$value->all_off;
$id=$value->id;
$name=$value->name;
$start_date=$value->start_date;
$end_date=$value->end_date;
$all_day_off="";
if($all_off=="1") {
$start_time="12:00am";
$end_time="11:59pm";
$all_day_off= __('Full Day Off',WF_A_P_SYSTEM );
} else {
$start_time =$value->start_time ;
$end_time=$value->end_time ;
}
$repeat =$value->repeat_value;
if($repeat=="p_d") {
$date=array($start_date." To ".$end_date);
if($status==$end_date) {
$status_show = __('Running',WF_A_P_SYSTEM);
}
if($status>$end_date) {
$status_show = __('Gone',WF_A_P_SYSTEM);
}
if($status<$end_date) {
$status_show = __('Upcoming',WF_A_P_SYSTEM);
}
} else {
$date=$value->holiday_date;
if($status==$date) {
$status_show = __('Running',WF_A_P_SYSTEM);
}
if($status>$date) {
$status_show = __('Gone',WF_A_P_SYSTEM);
}
if($status<$date) {
$status_show = __('Upcoming',WF_A_P_SYSTEM);
}
}
if($repeat=="no") {
$show_repeat= __('No Repeat',WF_A_P_SYSTEM );
}
if($repeat=="p_d") {
$show_repeat= __('Particular Date(s)',WF_A_P_SYSTEM );
}
if($repeat=="daily") {
$show_repeat= __('Daily',WF_A_P_SYSTEM );
}
if($repeat=="weekly") {
$show_repeat= __('Weekly',WF_A_P_SYSTEM );
}
if($repeat=="bi_weekly") {
$show_repeat= __('Bi-Weekly',WF_A_P_SYSTEM );
}
if($repeat=="monthly") {
$show_repeat= __('Monthly',WF_A_P_SYSTEM );
}
$notes =$value->notes ;
$results["data"][] =array('',$name,$date,array($start_time." To ".$end_time),array($show_repeat." ".$all_day_off),$status_show,array(' '));
}
} else {
$results["data"][] = array(null,null,null,__('No Holiday Add',WF_A_P_SYSTEM),null,null,null);
}
if($results != null) {
wp_send_json($results); // encode and send response
} else {
wp_send_json_error(); // {"success":false}
}
?>