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'])) { $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'])) { $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'])) { $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]; ?>