update( $wpdb->prefix . 'apt_settings', array( 'time_zone' => $ap_timezone, 'currency' => $currency, 'ap_theme_color' => $ap_theme_color, 'time_slots' => $time_slots, 'custom_slot' => $custom_slot, 'appt_status' => $appt_status, 'service_duration_type' => $service_duration_type, 'ap_mintime' => $ap_mintime, ), array( 'id' => '1' ) ); } //business setting save if ( isset( $_REQUEST['b_name'] ) && isset( $_POST['ap_bp_settings_nonce'] ) ) { if ( ! wp_verify_nonce( $_POST['ap_bp_settings_nonce'], 'ap_bp_settings_nonce' ) ) { die(); } $b_name = sanitize_text_field( $_REQUEST['b_name'] ); $b_owner = sanitize_text_field( $_REQUEST['b_owner'] ); $b_phone = sanitize_text_field( $_REQUEST['b_phone'] ); $b_fax = sanitize_text_field( $_REQUEST['b_fax'] ); $b_email = sanitize_text_field( $_REQUEST['b_email'] ); $b_blog_url = sanitize_text_field( $_REQUEST['b_blog_url'] ); $b_postal_code = sanitize_text_field( $_REQUEST['b_postal_code'] ); $b_address = sanitize_text_field( $_REQUEST['b_address'] ); $wpdb->update( $wpdb->prefix . 'apt_settings', array( 'b_name' => $b_name, 'b_owner' => $b_owner, 'b_phone' => $b_phone, 'b_fax' => $b_fax, 'b_email' => $b_email, 'b_blog_url' => $b_blog_url, 'b_postal_code' => $b_postal_code, 'b_address' => $b_address, ), array( 'id' => '1' ) ); } //business hours setting save if ( isset( $_REQUEST['bh_hour'] ) && isset( $_POST['ap_bh_settings_nonce'] ) ) { if ( ! wp_verify_nonce( $_POST['ap_bh_settings_nonce'], 'ap_bh_settings_nonce' ) ) { die(); } $monday_st = sanitize_text_field( $_REQUEST['bh_monday_st'] ); $bh_monday_st = substr_replace( $monday_st, ':', 2, - 2 ); $monday_et = sanitize_text_field( $_REQUEST['bh_monday_et'] ); $bh_monday_et = substr_replace( $monday_et, ':', 2, - 2 ); $tuesday_st = sanitize_text_field( $_REQUEST['bh_tuesday_st'] ); $bh_tuesday_st = substr_replace( $tuesday_st, ':', 2, - 2 ); $tuesday_et = sanitize_text_field( $_REQUEST['bh_tuesday_et'] ); $bh_tuesday_et = substr_replace( $tuesday_et, ':', 2, - 2 ); $wednesday_st = sanitize_text_field( $_REQUEST['bh_wednesday_st'] ); $bh_wednesday_st = substr_replace( $wednesday_st, ':', 2, - 2 ); $wednesday_et = sanitize_text_field( $_REQUEST['bh_wednesday_et'] ); $bh_wednesday_et = substr_replace( $wednesday_et, ':', 2, - 2 ); $thursday_st = sanitize_text_field( $_REQUEST['bh_thursday_st'] ); $bh_thursday_st = substr_replace( $thursday_st, ':', 2, - 2 ); $thursday_et = sanitize_text_field( $_REQUEST['bh_thursday_et'] ); $bh_thursday_et = substr_replace( $thursday_et, ':', 2, - 2 ); $friday_st = sanitize_text_field( $_REQUEST['bh_friday_st'] ); $bh_friday_st = substr_replace( $friday_st, ':', 2, - 2 ); $friday_et = sanitize_text_field( $_REQUEST['bh_friday_et'] ); $bh_friday_et = substr_replace( $friday_et, ':', 2, - 2 ); $saturday_st = sanitize_text_field( $_REQUEST['bh_saturday_st'] ); $bh_saturday_st = substr_replace( $saturday_st, ':', 2, - 2 ); $saturday_et = sanitize_text_field( $_REQUEST['bh_saturday_et'] ); $bh_saturday_et = substr_replace( $saturday_et, ':', 2, - 2 ); $sunday_st = sanitize_text_field( $_REQUEST['bh_sunday_st'] ); $bh_sunday_st = substr_replace( $sunday_st, ':', 2, - 2 ); $sunday_et = sanitize_text_field( $_REQUEST['bh_sunday_et'] ); $bh_sunday_et = substr_replace( $sunday_et, ':', 2, - 2 ); $sunday_setting[] = array( 'start_time' => $bh_sunday_st, 'end_time' => $bh_sunday_et ); $monday_setting[] = array( 'start_time' => $bh_monday_st, 'end_time' => $bh_monday_et ); $tuesday_setting[] = array( 'start_time' => $bh_tuesday_st, 'end_time' => $bh_tuesday_et ); $wednesday_setting[] = array( 'start_time' => $bh_wednesday_st, 'end_time' => $bh_wednesday_et ); $thursday_setting[] = array( 'start_time' => $bh_thursday_st, 'end_time' => $bh_thursday_et ); $friday_setting[] = array( 'start_time' => $bh_friday_st, 'end_time' => $bh_friday_et ); $saturday_setting[] = array( 'start_time' => $bh_saturday_st, 'end_time' => $bh_saturday_et ); $wpdb->update( $wpdb->prefix . 'apt_settings', array( 'bh_sunday' => serialize( $sunday_setting ), 'bh_monday' => serialize( $monday_setting ), 'bh_tuesday' => serialize( $tuesday_setting ), 'bh_wednesday' => serialize( $wednesday_setting ), 'bh_thursday' => serialize( $thursday_setting ), 'bh_friday' => serialize( $friday_setting ), 'bh_saturday' => serialize( $saturday_setting ), ), array( 'id' => '1' ) ); } //calendar setting save if ( isset( $_REQUEST['cal_theme_style'] ) && isset( $_POST['ap_calender_settings_nonce'] ) ) { if ( ! wp_verify_nonce( $_POST['ap_calender_settings_nonce'], 'ap_calender_settings_nonce' ) ) { die(); } $cal_theme_style = sanitize_text_field( $_REQUEST['cal_theme_style'] ); $ap_cal_date_format = sanitize_text_field( $_REQUEST['ap_cal_date_format'] ); $ap_cal_time_format = sanitize_text_field( $_REQUEST['ap_cal_time_format'] ); $calendar_view = sanitize_text_field( $_REQUEST['calendar_view'] ); $calendar_start_day = sanitize_text_field( $_REQUEST['calendar_start_day'] ); $pending_color = sanitize_text_field( $_REQUEST['pending_color'] ); $approved_color = sanitize_text_field( $_REQUEST['approved_color'] ); $cancelled_color = sanitize_text_field( $_REQUEST['cancelled_color'] ); $completed_color = sanitize_text_field( $_REQUEST['completed_color'] ); $time_off_color = sanitize_text_field( $_REQUEST['time_off_color'] ); $cal_font_style = sanitize_text_field( $_REQUEST['cal_font_style'] ); $wpdb->update( $wpdb->prefix . 'apt_settings', array( 'cal_theme_style' => $cal_theme_style, 'cal_font_style' => $cal_font_style, 'cal_date_format' => $ap_cal_date_format, 'cal_time_format' => $ap_cal_time_format, 'cal_view' => $calendar_view, 'cal_first_day' => $calendar_start_day, 'cal_pending_color' => $pending_color, 'cal_approved_color' => $approved_color, 'cal_cancelled_color' => $cancelled_color, 'cal_completed_color' => $completed_color, 'cal_off_time_color' => $time_off_color, ), array( 'id' => '1' ) ); } //advance booking setting save if ( isset( $_REQUEST['advance_booking_time'] ) ) { $advance_booking_time = sanitize_text_field( $_REQUEST['advance_booking_time'] ); $advance_cancel_time = sanitize_text_field( $_REQUEST['advance_cancel_time'] ); $wpdb->update( $wpdb->prefix . 'apt_settings', array( 'advance_booking_time' => $advance_booking_time, 'advance_cancel_time' => $advance_cancel_time, ), array( 'id' => '1' ) ); } //appointment reminder setting save if ( isset( $_REQUEST['reminder_time'] ) ) { $reminder_time = sanitize_text_field( $_REQUEST['reminder_time'] ); $subject_reminder = sanitize_text_field( $_REQUEST['subject_reminder'] ); $body_reminder = sanitize_text_field( $_REQUEST['body_reminder'] ); $wpdb->update( $wpdb->prefix . 'apt_settings', array( 'reminder_time' => $reminder_time, 'subject_reminder' => $subject_reminder, 'body_reminder' => $body_reminder, ), array( 'id' => '1' ) ); } $settings_table = $wpdb->prefix . "apt_settings"; $date_format = get_option( 'date_format' ); $time_format = get_option( 'time_format' ); ?>

get_col( "SELECT currency from $settings_table" ); $currency = $settings_currency[0]; ?>
get_col( "SELECT ap_theme_color from $settings_table" ); $ap_theme_color = $settings_ap_theme_color[0]; ?>
get_col( "SELECT custom_slot from $settings_table" ); $custom_slot = $settings_custom_slot[0]; ?>

get_col( "SELECT b_name from $settings_table" ); $b_name = $settings_b_name[0]; ?>
get_col( "SELECT b_owner from $settings_table" ); $b_owner = $settings_b_owner[0]; ?>
get_col( "SELECT b_phone from $settings_table" ); $b_phone = $settings_b_phone[0]; ?>
get_col( "SELECT b_fax from $settings_table" ); $b_fax = $settings_b_fax[0]; ?>
get_col( "SELECT b_email from $settings_table" ); $b_email = $settings_b_email[0]; ?>
get_col( "SELECT b_blog_url from $settings_table" ); $b_blog_url = $settings_b_blog_url[0]; ?>
get_col( "SELECT b_postal_code from $settings_table" ); $b_postal_code = $settings_b_postal_code[0]; ?>
get_col( "SELECT b_address from $settings_table" ); $b_address = $settings_b_address[0]; ?>

get_col( "SELECT bh_monday from $settings_table" ); $monday = unserialize( $settings_bh_monday_st[0] ); ?>
get_col( "SELECT bh_tuesday from $settings_table" ); $tuesday = unserialize( $settings_bh_tuesday_st[0] ); ?>
get_col( "SELECT bh_wednesday from $settings_table" ); $wednesday = unserialize( $settings_bh_wednesday_st[0] ); ?>
get_col( "SELECT bh_thursday from $settings_table" ); $thursday = unserialize( $settings_bh_thursday_st[0] ); ?>
get_col( "SELECT bh_friday from $settings_table" ); $friday = unserialize( $settings_bh_friday_st[0] ); ?>
get_col( "SELECT bh_saturday from $settings_table" ); $saturday = unserialize( $settings_bh_saturday_st[0] ); ?>
get_col( "SELECT bh_sunday from $settings_table" ); $sunday = unserialize( $settings_bh_sunday_st[0] ); ?>

get_col( "SELECT cal_theme_style from $settings_table" ); $cal_theme_style = $settings_cal_theme_style[0]; ?> >
get_col( "SELECT cal_date_format from $settings_table" ); $cal_date_format = $settings_date_format[0]; ?>
get_col( "SELECT cal_time_format from $settings_table" ); $cal_time_format = $settings_cal_time_format[0]; ?>
get_col( "SELECT cal_view from $settings_table" ); $cal_view = $settings_cal_view[0]; ?>
get_col( "SELECT cal_first_day from $settings_table" ); $cal_first_day = $settings_first_day[0]; ?>
get_col( "SELECT cal_pending_color from $settings_table" ); $cal_pending_color = $settings_cal_pending_color[0]; ?>
get_col( "SELECT cal_approved_color from $settings_table" ); $cal_approved_color = $settings_cal_approved_color[0]; ?>
get_col( "SELECT cal_cancelled_color from $settings_table" ); $cal_cancelled_color = $settings_cal_cancelled_color[0]; ?>
get_col( "SELECT cal_completed_color from $settings_table" ); $cal_completed_color = $settings_cal_completed_color[0]; ?>
get_col( "SELECT cal_off_time_color from $settings_table" ); $cal_off_time_color = $settings_cal_off_time_color[0]; ?>