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;} $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_A_P_SYSTEM ).''; echo '
'; echo'
'; echo ' '.__("Please select one",WL_A_P_SYSTEM ).''; echo'
'.__("This field is required",WL_A_P_SYSTEM ).'
'.__("This field is required",WL_A_P_SYSTEM ).'
'.__("This field is required",WL_A_P_SYSTEM ).'
'; echo "".__("Please select one",WL_A_P_SYSTEM ).""; echo'
'; echo "".__("Please select one",WL_A_P_SYSTEM ).""; echo'
Repeat:
Repeat Feature available in Pro Version
", "event_hover":"'; echo ''; echo ''; echo ''; echo '
Staff Member'; foreach($appointment_staff_details as $staff_member_single_name ) { if($value->staff_member==$staff_member_single_name->id) {echo $staff_member_single_name->staff_member_name;} } echo'
Services '.$value->service_type.'
Contact No'.$value->contact.'
Date'; $date_format=date("Y-M-d", strtotime($value->booking_date)); echo $date_format; echo '
Start Time '.$value->start_time.'
End Time '.$value->end_time.'
Status '.$value->status.'
"}'; } // 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",WL_A_P_SYSTEM ).''; echo '
'; echo ''. __("Please select one",WL_A_P_SYSTEM ).''; echo'
'; echo ' '.__("Please select one",WL_A_P_SYSTEM ).''; echo'
'.__("This field is required",WL_A_P_SYSTEM ).'
'.__("This field is required",WL_A_P_SYSTEM ).'
'.__("This field is required",WL_A_P_SYSTEM ).'
'; echo "".__("Please select one",WL_A_P_SYSTEM ).""; echo'
'; echo "".__("Please select one",WL_A_P_SYSTEM ).""; echo'
Repeat:
repeat_appointment=="Non") {echo "checked='checked'";} echo 'value=Non onclick=hideAll();> None repeat_appointment=="daily") {echo "checked='checked'";} echo'value=daily onclick=showdaily();> Daily repeat_appointment=="weekly") {echo "checked='checked'";} echo 'value=weekly onclick=showweekly()> Weekly repeat_appointment=="monthly") {echo "checked='checked'";} echo 'value=monthly onclick=showmonthly()> Monthly repeat_appointment=="PD") {echo "checked='checked'";} echo 'value=PD onclick=showParticularDate()> Particular Dates
", "event_hover":"'; echo ''; echo ''; echo ''; echo '
Staff Member'; foreach($appointment_staff_details as $staff_member_single_name ) { if($value->staff_member==$staff_member_single_name->id) {echo $staff_member_single_name->staff_member_name;} } echo'
Services '.$value->service_type.'
Contact No'.$value->contact.'
Date'; $date_format=date("Y-M-d", strtotime($value->booking_date)); echo $date_format; echo '
Start Time '.$value->start_time.'
End Time '.$value->end_time.'
Status '.$value->status.'
"}'; } } // fetch record for weekly if($value->repeat_appointment=="weekly") { $weekz=$value->re_weeks; for($h=0;$h<=$weekz;$h++) { $date_format=date("Y-m-d", strtotime('+'.$h.' week', 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",WL_A_P_SYSTEM ).''; echo '
'; echo ''. __("Please select one",WL_A_P_SYSTEM ).''; echo'
'; echo ' '.__("Please select one",WL_A_P_SYSTEM ).''; echo'
'.__("This field is required",WL_A_P_SYSTEM ).'
'.__("This field is required",WL_A_P_SYSTEM ).'
'.__("This field is required",WL_A_P_SYSTEM ).'
'; echo "".__("Please select one",WL_A_P_SYSTEM ).""; echo'
'; echo "".__("Please select one",WL_A_P_SYSTEM ).""; echo'
Repeat:
repeat_appointment=="Non") {echo "checked='checked'";} echo 'value=Non onclick=hideAll();> None repeat_appointment=="daily") {echo "checked='checked'";} echo'value=daily onclick=showdaily();> Daily repeat_appointment=="weekly") {echo "checked='checked'";} echo 'value=weekly onclick=showweekly()> Weekly repeat_appointment=="monthly") {echo "checked='checked'";} echo 'value=monthly onclick=showmonthly()> Monthly repeat_appointment=="PD") {echo "checked='checked'";} echo 'value=PD onclick=showParticularDate()> Particular Dates
", "event_hover":"'; echo ''; echo ''; echo ''; echo '
Staff Member'; foreach($appointment_staff_details as $staff_member_single_name ) { if($value->staff_member==$staff_member_single_name->id) {echo $staff_member_single_name->staff_member_name;} } echo'
Services '.$value->service_type.'
Contact No'.$value->contact.'
Date'; $date_format=date("Y-M-d", strtotime($value->booking_date)); echo $date_format; echo '
Start Time '.$value->start_time.'
End Time '.$value->end_time.'
Status '.$value->status.'
"}'; } } // fetch record for Monthly if($value->repeat_appointment=="monthly") { $monthz=$value->re_months; for($s=0;$s<=$monthz;$s++) { $date_format=date("Y-m-d", strtotime('+'.$s.'months', 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",WL_A_P_SYSTEM ).''; echo '
'; echo ''. __("Please select one",WL_A_P_SYSTEM ).''; echo'
'; echo ' '.__("Please select one",WL_A_P_SYSTEM ).''; echo'
'.__("This field is required",WL_A_P_SYSTEM ).'
'.__("This field is required",WL_A_P_SYSTEM ).'
'.__("This field is required",WL_A_P_SYSTEM ).'
'; echo "".__("Please select one",WL_A_P_SYSTEM ).""; echo'
'; echo "".__("Please select one",WL_A_P_SYSTEM ).""; echo'
Repeat:
repeat_appointment=="Non") {echo "checked='checked'";} echo 'value=Non onclick=hideAll();> None repeat_appointment=="daily") {echo "checked='checked'";} echo'value=daily onclick=showdaily();> Daily repeat_appointment=="weekly") {echo "checked='checked'";} echo 'value=weekly onclick=showweekly()> Weekly repeat_appointment=="monthly") {echo "checked='checked'";} echo 'value=monthly onclick=showmonthly()> Monthly repeat_appointment=="PD") {echo "checked='checked'";} echo 'value=PD onclick=showParticularDate()> Particular Dates
", "event_hover":"'; echo ''; echo ''; echo ''; echo '
Staff Member'; foreach($appointment_staff_details as $staff_member_single_name ) { if($value->staff_member==$staff_member_single_name->id) {echo $staff_member_single_name->staff_member_name;} } echo'
Services '.$value->service_type.'
Contact No'.$value->contact.'
Date'; $date_format=date("Y-M-d", strtotime($value->booking_date)); echo $date_format; echo '
Start Time '.$value->start_time.'
End Time '.$value->end_time.'
Status '.$value->status.'
"}'; } } // fetch record for particular date if($value->repeat_appointment=="PD") { //$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":"'.$value->re_start_date.'","end":"'.$value->re_end_date.'","backgroundColor":"'.$bg_colors.'","staff_member":"'.$value->staff_member.'","service_type":"'.$value->service_type.'","booking_date":"'.$value->re_start_date.'","status":"'.$value->status.'", "details":"
'; echo ''.__("Please select one",WL_A_P_SYSTEM ).''; echo '
'; echo ''. __("Please select one",WL_A_P_SYSTEM ).''; echo'
'; echo ' '.__("Please select one",WL_A_P_SYSTEM ).''; echo'
'.__("This field is required",WL_A_P_SYSTEM ).'
'.__("This field is required",WL_A_P_SYSTEM ).'
'.__("This field is required",WL_A_P_SYSTEM ).'
'; echo "".__("Please select one",WL_A_P_SYSTEM ).""; echo'
'; echo "".__("Please select one",WL_A_P_SYSTEM ).""; echo'
Repeat:
repeat_appointment=="Non") {echo "checked='checked'";} echo 'value=Non onclick=hideAll();> None repeat_appointment=="daily") {echo "checked='checked'";} echo'value=daily onclick=showdaily();> Daily repeat_appointment=="weekly") {echo "checked='checked'";} echo 'value=weekly onclick=showweekly()> Weekly repeat_appointment=="monthly") {echo "checked='checked'";} echo 'value=monthly onclick=showmonthly()> Monthly repeat_appointment=="PD") {echo "checked='checked'";} echo 'value=PD onclick=showParticularDate()> Particular Dates
", "event_hover":"'; echo ''; echo ''; echo ''; echo '
Staff Member'; foreach($appointment_staff_details as $staff_member_single_name ) { if($value->staff_member==$staff_member_single_name->id) {echo $staff_member_single_name->staff_member_name;} } echo'
Services '.$value->service_type.'
Contact No'.$value->contact.'
Date'; $date_format=date("Y-M-d", strtotime($value->booking_date)); echo $date_format; echo '
Start Time '.$value->start_time.'
End Time '.$value->end_time.'
Status '.$value->status.'
"}'; } } echo "]" ?>