prefix."apt_staff"; $settings_table = $wpdb->prefix."apt_settings"; if(isset($_REQUEST['client_name'])) { $client_name = sanitize_text_field( $_REQUEST['client_name'] ); $staff_member = "1"; $service_type = sanitize_text_field( $_REQUEST['service_type'] ); $contact = sanitize_text_field( $_REQUEST['contact'] ); if(isset($_REQUEST['booking_date'])) {$newDate = sanitize_text_field( $_REQUEST['booking_date'] );echo $booking_date = date("Y-m-d", strtotime($newDate));} else { echo $booking_date = " " ;} $start_time = sanitize_text_field( $_REQUEST['start_time'] ); $end_time = sanitize_text_field( $_REQUEST['end_time'] ); $client_email = sanitize_text_field( $_REQUEST['client_email'] ); $appointment_status = sanitize_text_field( $_REQUEST['appointment_status'] ); $payment_status = sanitize_text_field( $_REQUEST['payment_status'] ); $repeat = "Non"; $re_days = "1"; $re_weeks = "1"; $re_months = "1"; $re_start_date = " "; $re_end_date = " "; $service_price = sanitize_text_field( $_REQUEST['service_price'] ); $staff_email_details = $wpdb->get_col( "SELECT staff_email from $staff_table where id='$staff_member'" ); $staff_email = $staff_email_details[0]; $staff_name_details = $wpdb->get_col( "SELECT staff_member_name from $staff_table where id='$staff_member'" ); $staff_member_name = $staff_name_details[0]; $settings_payment_currency = $wpdb->get_col( "SELECT currency from $settings_table" ); $payment_currency = $settings_payment_currency[0]; $wpdb->insert( $wpdb->prefix.'apt_appointments', array( 'client_name' => $client_name, 'staff_member' => $staff_member, 'service_type' => $service_type, 'contact' => $contact, 'booking_date' =>$booking_date, 'start_time' => $start_time, 'end_time' => $end_time, 'status' => $appointment_status, 'payment_status' => $payment_status, 'client_email' => $client_email, 'repeat_appointment'=>$repeat, 're_days'=>$re_days, 're_weeks'=>$re_weeks, 're_months'=>$re_months, 're_start_date'=>$re_start_date, 're_end_date'=>$re_end_date, 'staff_email'=>$staff_email, 'appt_booked_by'=>'by_admin', )); $wpdb->insert( $wpdb->prefix.'apt_payment', array( 'payment_type'=>'Cash', 'customer'=>$client_name, 'customer_email'=>$client_email, 'staff'=>$staff_member_name, 'appointment_date'=>$booking_date, 'service'=>$service_type, 'amount'=>$service_price .' '.$payment_currency, 'status'=>$payment_status, )); } if(isset($_REQUEST['staff_id'])) { $staff_id = $_REQUEST['staff_id'] ; $wpdb->update( $wpdb->prefix.'apt_appointments', array( 'staff_id' => $staff_id, ), array( 'staff_member' => $staff_id ) ); } if(isset($_REQUEST['staff_service'])) { $staff_service = $_REQUEST['staff_service'] ; $wpdb->update( $wpdb->prefix.'apt_settings', array( 'staff_service' => $staff_service, ), array( 'id' => 1 )); } if(isset($_REQUEST['staff_id'])){ $staff_id = $_REQUEST['staff_id'] ; $wpdb->update( $wpdb->prefix.'apt_settings', array( 'staff_id' => $staff_id, ), array( 'id' => 1 )); } if(isset($_REQUEST['staff_date'])) { $staff_date = $_REQUEST['staff_date'] ; $wpdb->update( $wpdb->prefix.'apt_settings', array( 'staff_date' => $staff_date, ), array( 'id' => 1 )); } if(isset($_REQUEST['delete_id'])) { $del=$_REQUEST['delete_id']; $wpdb->delete( $wpdb->prefix.'apt_appointments', array( 'id' => $del )); } if(isset($_REQUEST['edit_client_id'])) { $edit_client_id = sanitize_text_field( $_REQUEST['edit_client_id'] ); $edit_client_name = sanitize_text_field( $_REQUEST['edit_client_name'] ); $edit_staff_member = sanitize_text_field( $_REQUEST['edit_staff_member'] ); $edit_service_type = sanitize_text_field( $_REQUEST['edit_service_type'] ); $edit_contact = sanitize_text_field( $_REQUEST['edit_contact'] ); //$newDate = sanitize_text_field( $_REQUEST['edit_booking_date'] ); //$edit_booking_date = date("Y-m-d", strtotime($newDate)); if(isset($_REQUEST['edit_booking_date'])) {$newDate = sanitize_text_field( $_REQUEST['edit_booking_date'] );echo $edit_booking_date = date("Y-m-d", strtotime($newDate));} else { echo $edit_booking_date = " " ;} $edit_start_time = sanitize_text_field( $_REQUEST['edit_start_time'] ); $edit_end_time = sanitize_text_field( $_REQUEST['edit_end_time'] ); $edit_appointment_status = sanitize_text_field( $_REQUEST['edit_status'] ); $edit_payment_status = sanitize_text_field( $_REQUEST['edit_payment_status'] ); $repeat_cl = "Non"; $re_days_cl = "1"; $re_weeks_cl = "1"; $re_months_cl = "1"; $re_start_date_cl = " "; $re_end_date_cl = " "; $staff_details = $wpdb->get_col( "SELECT staff_email from $staff_table where id='$edit_staff_member'" ); $edit_staff_email = $staff_details[0]; $wpdb->update( $wpdb->prefix.'apt_appointments', array( 'client_name' => $edit_client_name, 'staff_member' => $edit_staff_member, 'service_type' => $edit_service_type, 'contact' => $edit_contact, 'booking_date' => $edit_booking_date, 'start_time' => $edit_start_time, 'end_time' => $edit_end_time, 'status' => $edit_appointment_status, 'payment_status' => $edit_payment_status, 'repeat_appointment'=>$repeat_cl, 're_days'=>$re_days_cl, 're_weeks'=>$re_weeks_cl, 're_months'=>$re_months_cl, 're_start_date'=>$re_start_date_cl, 'staff_email'=>$edit_staff_email, 're_end_date'=>$re_end_date_cl, ), array( 'id' => $edit_client_id ) ); } $appointment_service_details = $wpdb->get_results( "SELECT * from $wpdb->prefix"."apt_services"); $appointment_setting_details = $wpdb->get_results( "SELECT * from $wpdb->prefix"."apt_settings"); $appointment_calender_details = $wpdb->get_col( "SELECT client_name from $wpdb->prefix"."apt_appointments"); $appointment_calender_details = array_unique($appointment_calender_details); $appointment_calender_details_date = $wpdb->get_col( "SELECT booking_date from $wpdb->prefix"."apt_appointments"); $appointment_calender_details_date = array_unique($appointment_calender_details_date); $appointment_calender_staff_member = $wpdb->get_col( "SELECT staff_member from $wpdb->prefix"."apt_appointments"); $appointment_calender_staff_member = array_unique($appointment_calender_staff_member); $appointment_calender_service = $wpdb->get_col( "SELECT service_type from $wpdb->prefix"."apt_appointments"); $appointment_calender_service = array_unique($appointment_calender_service); $appointment_category_details = $wpdb->get_results( "SELECT * from $wpdb->prefix"."apt_category"); $appointment_customer_details = $wpdb->get_results( "SELECT * from $wpdb->prefix"."apt_clients"); $appointment_staff_details = $wpdb->get_results( "select * from $wpdb->prefix"."apt_staff"); $appearence_cal_font_style = $wpdb->get_row( "SELECT * from $wpdb->prefix"."apt_settings"); $cal_font_style= $appearence_cal_font_style->cal_font_style; $cal_theme_style= $appearence_cal_font_style->cal_theme_style; $cal_date_format= $appearence_cal_font_style->cal_date_format; $cal_time_format= $appearence_cal_font_style->cal_time_format; $cal_view= $appearence_cal_font_style->cal_view; $cal_first_day= $appearence_cal_font_style->cal_first_day; $cal_pending_color= $appearence_cal_font_style->cal_pending_color; $cal_approved_color= $appearence_cal_font_style->cal_approved_color; $cal_off_time_color= $appearence_cal_font_style->cal_off_time_color; $cal_font_style= $appearence_cal_font_style->cal_font_style; $cal_pending_color= $appearence_cal_font_style->cal_pending_color; $cal_approved_color= $appearence_cal_font_style->cal_approved_color; $cal_cancelled_color= $appearence_cal_font_style->cal_cancelled_color; $cal_completed_color= $appearence_cal_font_style->cal_completed_color; $cal_off_time_color= $appearence_cal_font_style->cal_off_time_color; $ap_holiday_fecthes=$wpdb->get_results("select * from $wpdb->prefix"."apt_holidays"); ?>
first_name; ?> last_name; ?>
prefix."apt_services"; $appointment_details = $wpdb->get_results( "SELECT * from $service_table where category= '$appointment_category_single_detail->id'"); foreach($appointment_details as $appointment_single_detail){ ?>
name ?>