update( $wpdb->prefix.'apt_appointments', array( 'staff_member' => '1', 'staff_value' => '1', ), array( 'staff_member' => $staff_delete_id ) ); } if(isset($_REQUEST['staff_member_name'])) { $staff_member_name = sanitize_text_field( $_REQUEST['staff_member_name'] ); $staff_icon = sanitize_text_field($_REQUEST['staff_icon']) ; $sunday_staff_hours[] = array('start_time'=>"10:00",'end_time'=>"18:00", 'break_start'=>"14:30",'break_end'=>"15:00"); $monday_staff_hours[] = array('start_time'=>"10:00",'end_time'=>"18:00", 'break_start'=>"14:30",'break_end'=>"15:00"); $tuesday_staff_hours[] = array('start_time'=>"10:00",'end_time'=>"18:00", 'break_start'=>"14:30",'break_end'=>"15:00"); $wednesday_staff_hours[] = array('start_time'=>"10:00",'end_time'=>"18:00", 'break_start'=>"14:30",'break_end'=>"15:00"); $thursday_staff_hours[] = array('start_time'=>"10:00",'end_time'=>"18:00", 'break_start'=>"14:30",'break_end'=>"15:00"); $friday_staff_hours[] = array('start_time'=>"10:00",'end_time'=>"18:00", 'break_start'=>"14:30",'break_end'=>"15:00"); $saturday_staff_hours[] = array('start_time'=>"10:00",'end_time'=>"18:00", 'break_start'=>"14:30",'break_end'=>"15:00"); $wpdb->insert( $wpdb->prefix.'apt_staff', array( 'staff_member_name' => $staff_member_name, 'staff_icon' => $staff_icon, 'schedule_sunday'=>serialize($sunday_staff_hours), 'schedule_monday'=>serialize($monday_staff_hours), 'schedule_tuesday'=>serialize($tuesday_staff_hours), 'schedule_wednesday'=>serialize($wednesday_staff_hours), 'schedule_thursday'=>serialize($thursday_staff_hours), 'schedule_friday'=>serialize($friday_staff_hours), 'schedule_saturday'=>serialize($saturday_staff_hours), )); } if(isset($_REQUEST['staff_name'])) { echo $staff_name = sanitize_text_field( $_REQUEST['staff_name'] ); echo $staff_member_image = sanitize_text_field( $_REQUEST['staff_member_image'] ); echo $staff_id = sanitize_text_field( $_REQUEST['edit_staff_id'] ); echo $staff_email = sanitize_text_field( $_REQUEST['staff_email'] ); echo $staff_skype_id = sanitize_text_field( $_REQUEST['staff_skype_id'] ); echo $staff_contact = sanitize_text_field( $_REQUEST['staff_contact'] ); echo $staff_info = sanitize_text_field( $_REQUEST['staff_info'] ); $update_staff_icon = sanitize_text_field( $_REQUEST['update_staff_icon'] ); $wpdb->update( $wpdb->prefix.'apt_staff', array( 'staff_member_name' => $staff_name, 'staff_member_image' => $staff_member_image, 'staff_email' => $staff_email, 'staff_skype_id' => $staff_skype_id, 'staff_contact' => $staff_contact, 'staff_info' => $staff_info, 'staff_icon' => $update_staff_icon,), array( 'id' => $staff_id ) ); $user_data = array( 'user_pass' => $staff_email, 'user_email' => $staff_email, 'user_login' => $staff_email, 'role' => 'subscriber' // Use default role or another role, e.g. 'editor' ); $user_id = wp_insert_user( $user_data ); add_action( 'admin_init', 'wp_insert_user' ); } if(isset($_REQUEST['sevice_staff_id'])) { echo $satff_cate_service = implode(",",$_REQUEST['satff_cate_service']); echo $staff_services = implode(",",$_REQUEST['staff_services']); echo $sevice_staff_id = sanitize_text_field( $_REQUEST['sevice_staff_id'] ); $wpdb->update( $wpdb->prefix.'apt_staff', array( 'staff_services' => $staff_services, 'staff_service_category' => $satff_cate_service, ), array( 'id' => $sevice_staff_id ) ); } if(isset($_REQUEST['staff_schedule_id'])) { if(isset($_REQUEST['apt_monday_st'])) {$apt_monday_st = sanitize_text_field( $_REQUEST['apt_monday_st'] );} else {$apt_monday_st = sanitize_text_field( $_REQUEST['hd_apt_monday_st']);} if(isset($_REQUEST['apt_monday_end'])) {$apt_monday_end = sanitize_text_field( $_REQUEST['apt_monday_end'] );} else { $apt_monday_end = sanitize_text_field( $_REQUEST['hd_apt_monday_end'] );} if(isset($_REQUEST['apt_monday_break_st'])) {$apt_monday_break_st = sanitize_text_field( $_REQUEST['apt_monday_break_st'] );} else {$apt_monday_break_st = sanitize_text_field( $_REQUEST['hd_apt_monday_break_st'] );} if(isset($_REQUEST['apt_monday_break_end'])) {$apt_monday_break_end = sanitize_text_field( $_REQUEST['apt_monday_break_end'] );} else {$apt_monday_break_end = sanitize_text_field( $_REQUEST['hd_apt_monday_break_end'] );} $mon_all_off = sanitize_text_field( $_REQUEST['mon_all_off'] ); if(isset($_REQUEST['apt_tuesday_st'])) {$apt_tuesday_st = sanitize_text_field( $_REQUEST['apt_tuesday_st'] );} else {$apt_tuesday_st = sanitize_text_field( $_REQUEST['hd_apt_tuesday_st'] );} if(isset($_REQUEST['apt_tuesday_end'])) {$apt_tuesday_end = sanitize_text_field( $_REQUEST['apt_tuesday_end'] );} else { $apt_tuesday_end = sanitize_text_field( $_REQUEST['hd_apt_tuesday_end'] );} if(isset($_REQUEST['apt_tuesday_break_st'])) {$apt_tuesday_break_st = sanitize_text_field( $_REQUEST['apt_tuesday_break_st'] );} else {$apt_tuesday_break_st = sanitize_text_field( $_REQUEST['hd_apt_tuesday_break_st'] );} if(isset($_REQUEST['apt_tuesday_break_end'])) {$apt_tuesday_break_end = sanitize_text_field( $_REQUEST['apt_tuesday_break_end'] );} else {$apt_tuesday_break_end = sanitize_text_field( $_REQUEST['hd_apt_tuesday_break_end'] );} $tue_all_off = sanitize_text_field( $_REQUEST['tue_all_off'] ); if(isset($_REQUEST['apt_wednesday_st'])) {$apt_wednesday_st = sanitize_text_field( $_REQUEST['apt_wednesday_st'] );} else {$apt_wednesday_st = sanitize_text_field( $_REQUEST['hd_apt_wednesday_st'] );} if(isset($_REQUEST['apt_wednesday_end'])) {$apt_wednesday_end = sanitize_text_field( $_REQUEST['apt_wednesday_end'] );} else {$apt_wednesday_end = sanitize_text_field( $_REQUEST['hd_apt_wednesday_end'] );} if(isset($_REQUEST['apt_wednesday_break_st'])) {$apt_wednesday_break_st = sanitize_text_field( $_REQUEST['apt_wednesday_break_st'] );} else {$apt_wednesday_break_st = sanitize_text_field( $_REQUEST['hd_apt_wednesday_break_st'] );} if(isset($_REQUEST['apt_wednesday_break_end'])) {$apt_wednesday_break_end = sanitize_text_field( $_REQUEST['apt_wednesday_break_end'] );} else {$apt_wednesday_break_end = sanitize_text_field( $_REQUEST['hd_apt_wednesday_break_end'] );} $wed_all_off = sanitize_text_field( $_REQUEST['wed_all_off'] ); if(isset($_REQUEST['apt_thursday_st'] )) {$apt_thursday_st = sanitize_text_field( $_REQUEST['apt_thursday_st'] );} else {$apt_thursday_st = sanitize_text_field( $_REQUEST['hd_apt_thursday_st'] );} if(isset($_REQUEST['apt_thursday_end'] )) {$apt_thursday_end = sanitize_text_field( $_REQUEST['apt_thursday_end'] );} else {$apt_thursday_end = sanitize_text_field( $_REQUEST['hd_apt_thursday_end'] );} if(isset($_REQUEST['apt_thursday_break_st'])) {$apt_thursday_break_st = sanitize_text_field( $_REQUEST['apt_thursday_break_st'] );} else {$apt_thursday_break_st = sanitize_text_field( $_REQUEST['hd_apt_thursday_break_st'] );} if(isset($_REQUEST['apt_thursday_break_end'])) {$apt_thursday_break_end = sanitize_text_field( $_REQUEST['apt_thursday_break_end'] );} else {$apt_thursday_break_end = sanitize_text_field( $_REQUEST['hd_apt_thursday_break_end'] );} $thu_all_off = sanitize_text_field( $_REQUEST['thu_all_off'] ); if(isset($_REQUEST['apt_friday_st'])) {$apt_friday_st = sanitize_text_field( $_REQUEST['apt_friday_st'] );} else {$apt_friday_st = sanitize_text_field( $_REQUEST['hd_apt_friday_st'] );} if(isset($_REQUEST['apt_friday_end'])) {$apt_friday_end = sanitize_text_field( $_REQUEST['apt_friday_end'] );} else {$apt_friday_end = sanitize_text_field( $_REQUEST['hd_apt_friday_end'] );} if(isset($_REQUEST['apt_friday_break_st'])) {$apt_friday_break_st = sanitize_text_field( $_REQUEST['apt_friday_break_st'] );} else {$apt_friday_break_st = sanitize_text_field( $_REQUEST['hd_apt_friday_break_st'] );} if(isset($_REQUEST['apt_friday_break_end'])) {$apt_friday_break_end = sanitize_text_field( $_REQUEST['apt_friday_break_end'] );} else {$apt_friday_break_end = sanitize_text_field( $_REQUEST['hd_apt_friday_break_end'] );} $fri_all_off = sanitize_text_field( $_REQUEST['fri_all_off'] ); if(isset($_REQUEST['apt_saturday_st'])) {$apt_saturday_st = sanitize_text_field( $_REQUEST['apt_saturday_st'] );} else {$apt_saturday_st = sanitize_text_field( $_REQUEST['hd_apt_saturday_st'] );} if(isset($_REQUEST['apt_saturday_end'])) {$apt_saturday_end = sanitize_text_field( $_REQUEST['apt_saturday_end'] );} else {$apt_saturday_end = sanitize_text_field( $_REQUEST['hd_apt_saturday_end'] );} if(isset($_REQUEST['apt_saturday_break_st'])) {$apt_saturday_break_st = sanitize_text_field( $_REQUEST['apt_saturday_break_st'] );} else {$apt_saturday_break_st = sanitize_text_field( $_REQUEST['hd_apt_saturday_break_st'] );} if(isset($_REQUEST['apt_saturday_break_end'])) {$apt_saturday_break_end = sanitize_text_field( $_REQUEST['apt_saturday_break_end'] );} else {$apt_saturday_break_end = sanitize_text_field( $_REQUEST['hd_apt_saturday_break_end'] );} $sat_all_off = sanitize_text_field( $_REQUEST['sat_all_off'] ); if(isset($_REQUEST['apt_sunday_st'])) {$apt_sunday_st = sanitize_text_field( $_REQUEST['apt_sunday_st'] );} else {$apt_sunday_st = sanitize_text_field( $_REQUEST['hd_apt_sunday_st'] );} if(isset($_REQUEST['apt_sunday_end'])) {$apt_sunday_end = sanitize_text_field( $_REQUEST['apt_sunday_end'] );} else {$apt_sunday_end = sanitize_text_field( $_REQUEST['hd_apt_sunday_end'] );} if(isset($_REQUEST['apt_sunday_break_st'])) {$apt_sunday_break_st = sanitize_text_field( $_REQUEST['apt_sunday_break_st'] );} else {$apt_sunday_break_st = sanitize_text_field( $_REQUEST['hd_apt_sunday_break_st'] );} if(isset($_REQUEST['apt_sunday_break_end'])) {$apt_sunday_break_end = sanitize_text_field( $_REQUEST['apt_sunday_break_end'] );} else {$apt_sunday_break_end = sanitize_text_field( $_REQUEST['hd_apt_sunday_break_end'] );} $staff_schedule_id = sanitize_text_field( $_REQUEST['staff_schedule_id'] ); $sun_all_off = sanitize_text_field( $_REQUEST['sun_all_off'] ); $sunday[] = array('start_time'=>$apt_sunday_st,'end_time'=>$apt_sunday_end,'break_start'=>$apt_sunday_break_st,'break_end'=>$apt_sunday_break_end); $monday[] = array('start_time'=>$apt_monday_st,'end_time'=>$apt_monday_end,'break_start'=>$apt_monday_break_st,'break_end'=>$apt_monday_break_end); $tuesday[] = array('start_time'=>$apt_tuesday_st,'end_time'=>$apt_tuesday_end,'break_start'=>$apt_tuesday_break_st,'break_end'=>$apt_tuesday_break_end); $wednesday[] = array('start_time'=>$apt_wednesday_st,'end_time'=>$apt_wednesday_end,'break_start'=>$apt_wednesday_break_st,'break_end'=>$apt_wednesday_break_end); $thursday[] = array('start_time'=>$apt_thursday_st,'end_time'=>$apt_thursday_end,'break_start'=>$apt_thursday_break_st,'break_end'=>$apt_thursday_break_end); $friday[] = array('start_time'=>$apt_friday_st,'end_time'=>$apt_friday_end,'break_start'=>$apt_friday_break_st,'break_end'=>$apt_friday_break_end); $saturday[] = array('start_time'=>$apt_saturday_st,'end_time'=>$apt_saturday_end,'break_start'=>$apt_saturday_break_st,'break_end'=>$apt_saturday_break_end); $wpdb->update( $wpdb->prefix.'apt_staff', array( 'schedule_sunday'=>serialize($sunday), 'sun_all_off'=>$sun_all_off, 'schedule_monday'=>serialize($monday), 'mon_all_off'=>$mon_all_off, 'schedule_tuesday'=>serialize($tuesday), 'tue_all_off'=>$tue_all_off, 'schedule_wednesday'=>serialize($wednesday), 'wed_all_off'=>$wed_all_off, 'schedule_thursday'=>serialize($thursday), 'thu_all_off'=>$thu_all_off, 'schedule_friday'=>serialize($friday), 'fri_all_off'=>$fri_all_off, 'schedule_saturday'=>serialize($saturday), 'sat_all_off'=>$sat_all_off, ),array( 'id' => $staff_schedule_id)); } $staff_member_names = $wpdb->get_results( "select * from $wpdb->prefix"."apt_staff"); $ap_fetch_service_cat=$wpdb->get_results("select * from $wpdb->prefix"."apt_category"); if(isset($_REQUEST['holiday_staff_id'])) { if(isset($_REQUEST['staff_allday'])) {$staff_allday = $_REQUEST['staff_allday'];} else {$staff_allday ="0";} $staff_start_time = sanitize_text_field($_REQUEST['staff_start_time']); $staff_end_time = sanitize_text_field($_REQUEST['staff_end_time']); $staff_event_date = sanitize_text_field($_REQUEST['staff_event_date']); $staff_repeat = sanitize_text_field($_REQUEST['staff_repeat']); $staff_re_days = sanitize_text_field($_REQUEST['staff_re_days']); $staff_re_weeks = sanitize_text_field($_REQUEST['staff_re_weeks']); $staff_re_biweeks = sanitize_text_field($_REQUEST['staff_re_biweeks']); $staff_re_months = sanitize_text_field($_REQUEST['staff_re_months']); $staff_start_date = sanitize_text_field($_REQUEST['staff_start_date']); $staff_end_date = sanitize_text_field($_REQUEST['staff_end_date']); $staff_id = $_REQUEST['holiday_staff_id']; $wpdb->update( $wpdb->prefix.'apt_staff', array( 'staff_all_off' => $staff_allday, 'staff_start_time' =>$staff_start_time, 'staff_end_time' => $staff_end_time , 'staff_date' =>$staff_event_date, 'staff_repeat' =>$staff_repeat , 'staff_repeat_day' =>$staff_re_days, 'staff_repeat_week' =>$staff_re_weeks, 'staff_repeat_bi_week' =>$staff_re_biweeks, 'staff_start_date' =>$staff_start_date, 'staff_end_date' =>$staff_end_date, 'staff_repeat_month' =>$staff_re_months,), array( 'id' => $staff_id ) ); } if(isset($_REQUEST['staff_delete_id'])) { $del=$_REQUEST['staff_delete_id']; $wpdb->delete( $wpdb->prefix.'apt_staff', array( 'id' => $del ) ); } ?>

staff_member_name ; ?>

<?php echo $staff_single_member_name->staff_member_name ; ?>

id; ?>

<?php echo $staff_single_member_name->staff_member_name ; ?>
staff_member_name ; ?> staff_contact ; ?>
staff_email ; ?> staff_skype_id ; ?>
staff_info ; ?>

get_results("select * from $wpdb->prefix"."apt_services where category='$ap_fetch_show_service_cat->id'");?>
name; ?> staff_services); foreach($ser_cat as $ser_cats){ if($ap_fetch_show_services->id==$ser_cats){ echo $ap_fetch_show_services->name; }} ?>
get_results("select * from $wpdb->prefix"."apt_services where category='$ap_fetch_service_cat_single->id'");?>
staff_service_category); foreach($cat as $cats){ if($ap_fetch_service_cat_single->id==$cats){echo "checked='checked'";} } ?> data-toggle="tooltip" title="Select all service" /> name ?>
staff_services); foreach($ser_cat as $ser_cats){ if($ap_fetch_service_staff_single->id==$ser_cats){echo "checked='checked'";} } ?> /> name?>
'>

id; ?> schedule_monday);?> schedule_tuesday);?> schedule_wednesday);?> schedule_thursday);?> schedule_friday);?> schedule_saturday);?> schedule_sunday);?>
mon_all_off=='Monday'){ echo "checked='checked'";} ?> onclick="return staff_monday();" />
tue_all_off=='Tuesday'){ echo "checked='checked'";} ?> onclick="return staff_tuesday();" />
wed_all_off=='Wednesday'){ echo "checked='checked'";} ?> onclick="return staff_wednesday();"/>
thu_all_off=='Thursday'){ echo "checked='checked'";} ?> onclick="return staff_thursday();" />
fri_all_off=='Friday'){ echo "checked='checked'";} ?> onclick="return staff_friday();"/>
sat_all_off=='Saturday'){ echo "checked='checked'";} ?> onclick="return staff_saturday();" />
sun_all_off=='Sunday'){ echo "checked='checked'";} ?> onclick="return staff_sunday();"/>