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 "[";
foreach($ap_fecth_appointment as $value) {
// fetch record for none
if($value->repeat_appointment=="Non") {
//$bg_colors=array('#a54f9a','#606ca7','#6e7932','#90786f', '#bb7a7a','#8a3e98','#3193a9','#31a97d','#90740e','#838f98','#4a7396','#a95143','#a98043');
//shuffle($bg_colors);
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",WF_A_P_SYSTEM ).'';
echo '
';
echo '
';
echo "".__("Please select one",WF_A_P_SYSTEM )."";
echo'
';
echo "".__("Please select one",WF_A_P_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 ;
//$bg_colors = array('#a54f9a','#606ca7','#6e7932','#90786f', '#bb7a7a','#8a3e98','#3193a9','#31a97d','#90740e','#838f98','#4a7396','#a95143','#a98043');
//shuffle($bg_colors);
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",WF_A_P_SYSTEM ).'';
echo '
';
echo ''. __("Please select one",WF_A_P_SYSTEM ).'';
echo '
'.__("This field is required",WF_A_P_SYSTEM ).'
';
echo "".__("Please select one",WF_A_P_SYSTEM )."";
echo'
';
echo "".__("Please select one",WF_A_P_SYSTEM )."";
echo'
';
echo ''.__("Please select one",WF_A_P_SYSTEM ).'';
echo '
';
echo ''. __("Please select one",WF_A_P_SYSTEM ).'';
echo '
'.__("This field is required",WF_A_P_SYSTEM ).'
';
echo "".__("Please select one",WF_A_P_SYSTEM )."";
echo '
';
echo "".__("Please select one",WF_A_P_SYSTEM )."";
echo'
'.__("Repeat",WF_A_P_SYSTEM ).':
repeat_appointment=="Non") {echo "checked='checked'"; }
echo 'value=Non onclick=hideAll();>
'.__("Please select one",WF_A_P_SYSTEM ).' repeat_appointment=="daily") {echo "checked='checked'"; }
echo'value=daily onclick=showdaily();>
'.__("Daily",WF_A_P_SYSTEM ).' repeat_appointment=="weekly") {echo "checked='checked'"; }
echo 'value=weekly onclick=showweekly()>
'.__("Weekly",WF_A_P_SYSTEM ).' repeat_appointment=="monthly") {echo "checked='checked'"; }
echo 'value=monthly onclick=showmonthly()>
'.__("Monthly",WF_A_P_SYSTEM ).' repeat_appointment=="PD") {echo "checked='checked'"; }
echo 'value=PD onclick=showParticularDate()>
'.__("Particular Dates",WF_A_P_SYSTEM ).'
'.__("Daily(s)",WF_A_P_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",WF_A_P_SYSTEM ).'';
echo '
';
echo ''. __("Please select one",WF_A_P_SYSTEM ).'';
echo '
'.__("This field is required",WF_A_P_SYSTEM ).'
';
echo "".__("Please select one",WF_A_P_SYSTEM )."";
echo'
';
echo "".__("Please select one",WF_A_P_SYSTEM )."";
echo'
';
echo ''.__("Please select one",WF_A_P_SYSTEM ).'';
echo '
';
echo ''. __("Please select one",WF_A_P_SYSTEM ).'';
echo '
'.__("This field is required",WF_A_P_SYSTEM ).'
';
echo "".__("Please select one",WF_A_P_SYSTEM )."";
echo'
';
echo "".__("Please select one",WF_A_P_SYSTEM )."";
echo'