get_results( "SELECT * from $wpdb->prefix" . "apt_staff" );
$ap_fecth_appointment = $wpdb->get_results( "SELECT * from $wpdb->prefix" . "apt_appointments" );
$appointment_category_details = $wpdb->get_results( "SELECT * from $wpdb->prefix" . "apt_category" );
$appointment_customer_details = $wpdb->get_results( "SELECT * from $wpdb->prefix" . "apt_clients" );
$appearence_cal_settings = $wpdb->get_row( "SELECT * from $wpdb->prefix" . "apt_settings" );
$pending_color = $appearence_cal_settings->cal_pending_color;
$approved_color = $appearence_cal_settings->cal_approved_color;
$cancelled_color = $appearence_cal_settings->cal_cancelled_color;
$completed_color = $appearence_cal_settings->cal_completed_color;
$off_time_color = $appearence_cal_settings->cal_off_time_color;
echo "[";
$i = 0;
foreach ( $ap_fecth_appointment as $value ) {
// fetch record for none
if ( $value->repeat_appointment == "Non" ) {
if ( $value->status == 'cancelled' ) {
$bg_colors = $cancelled_color;
}
if ( $value->status == 'pending' ) {
$bg_colors = $pending_color;
}
if ( $value->status == 'approved' ) {
$bg_colors = $approved_color;
}
if ( $value->status == 'completed' ) {
$bg_colors = $completed_color;
}
$contact_no = preg_replace( '/\s+/', '', $value->contact );
$j = $value->id[ $i ++ ];
if ( $j == $value->id ) {
echo $k = "";
} else {
echo $k = ",";
}
echo '{"id":' . $value->id . ',"title":"' . $value->client_name . '","start":"' . $value->booking_date . '","end":"' . $value->booking_date . '","backgroundColor":"' . $bg_colors . '","staff_member":"' . $value->staff_member . '","service_type":"' . $value->service_type . '","booking_date":"' . $value->booking_date . '","status":"' . $value->status . '",
"details":"';
echo '' . __( "Please select one", WL_ABS_SYSTEM ) . '';
echo '
';
echo '
';
echo "" . __( "Please select one", WL_ABS_SYSTEM ) . "";
echo '
';
echo "" . __( "Please select one", WL_ABS_SYSTEM ) . "";
echo '
Repeat:
Repeat Feature available in Pro Version
",
"event_hover":""}';
}
// fetch record for daily
if ( $value->repeat_appointment == "daily" ) {
$dayz = $value->re_days;
for ( $y = 0; $y <= $dayz; $y ++ ) {
$date_format = date( "Y-m-d", strtotime( '+' . $y . ' days', strtotime( $value->booking_date ) ) );
$dateTo = $date_format;
if ( $value->status == 'cancelled' ) {
$bg_colors = $cancelled_color;
}
if ( $value->status == 'pending' ) {
$bg_colors = $pending_color;
}
if ( $value->status == 'approved' ) {
$bg_colors = $approved_color;
}
$j = $value->id[ $i ++ ];
if ( $j == $value->id ) {
echo $k = "";
} else {
echo $k = ",";
}
echo '{"id":' . $value->id . ',"title":"' . $value->client_name . '","start":"' . $dateTo . '","end":"' . $dateTo . '","backgroundColor":"' . $bg_colors . '","staff_member":"' . $value->staff_member . '","service_type":"' . $value->service_type . '","booking_date":"' . $dateTo . '","status":"' . $value->status . '",
"details":"';
echo '' . __( "Please select one", WL_ABS_SYSTEM ) . '';
echo '
';
echo '' . __( "Please select one", WL_ABS_SYSTEM ) . '';
echo '
' . __( "This field is required", WL_ABS_SYSTEM ) . '
';
echo "" . __( "Please select one", WL_ABS_SYSTEM ) . "";
echo '
';
echo "" . __( "Please select one", WL_ABS_SYSTEM ) . "";
echo '
';
echo '' . __( "Please select one", WL_ABS_SYSTEM ) . '';
echo '
';
echo '' . __( "Please select one", WL_ABS_SYSTEM ) . '';
echo '
' . __( "This field is required", WL_ABS_SYSTEM ) . '
';
echo "" . __( "Please select one", WL_ABS_SYSTEM ) . "";
echo '
';
echo "" . __( "Please select one", WL_ABS_SYSTEM ) . "";
echo '
' . __( "Repeat", WL_ABS_SYSTEM ) . ':
repeat_appointment == "Non" ) {
echo "checked='checked'";
}
echo 'value=Non onclick=hideAll();>
' . __( "Please select one", WL_ABS_SYSTEM ) . ' repeat_appointment == "daily" ) {
echo "checked='checked'";
}
echo 'value=daily onclick=showdaily();>
' . __( "Daily", WL_ABS_SYSTEM ) . ' repeat_appointment == "weekly" ) {
echo "checked='checked'";
}
echo 'value=weekly onclick=showweekly()>
' . __( "Weekly", WL_ABS_SYSTEM ) . ' repeat_appointment == "monthly" ) {
echo "checked='checked'";
}
echo 'value=monthly onclick=showmonthly()>
' . __( "Monthly", WL_ABS_SYSTEM ) . ' repeat_appointment == "PD" ) {
echo "checked='checked'";
}
echo 'value=PD onclick=showParticularDate()>
' . __( "Particular Dates", WL_ABS_SYSTEM ) . '
' . __( "Daily(s)", WL_ABS_SYSTEM ) . ': (Min = 1, Max = 99 Days)
Repeat Week(s):(Min = 1, Max = 99 Weeks)
Repeat Month(s):(Min = 1, Max = 99 Months)
Start Date:
End Date:
';
echo '' . __( "Please select one", WL_ABS_SYSTEM ) . '';
echo '
';
echo '' . __( "Please select one", WL_ABS_SYSTEM ) . '';
echo '
' . __( "This field is required", WL_ABS_SYSTEM ) . '
';
echo "" . __( "Please select one", WL_ABS_SYSTEM ) . "";
echo '
';
echo "" . __( "Please select one", WL_ABS_SYSTEM ) . "";
echo '
';
echo '' . __( "Please select one", WL_ABS_SYSTEM ) . '';
echo '
';
echo '' . __( "Please select one", WL_ABS_SYSTEM ) . '';
echo '
' . __( "This field is required", WL_ABS_SYSTEM ) . '
';
echo "" . __( "Please select one", WL_ABS_SYSTEM ) . "";
echo '
';
echo "" . __( "Please select one", WL_ABS_SYSTEM ) . "";
echo '