insert( $wpdb->prefix . 'apt_category', array( 'name' => $category_name, 'icon' => $category_icon, ) ); } //fetch Category $ap_fetch_cat = $wpdb->get_results( "select * from $wpdb->prefix" . "apt_category" ); if ( isset( $_REQUEST['cat_id'] ) ) { $del = sanitize_text_field( $_REQUEST['cat_id'] ); $wpdb->delete( $wpdb->prefix . 'apt_category', array( 'id' => $del ) ); $wpdb->delete( $wpdb->prefix . 'apt_services', array( 'category' => $del ) ); } $ap_staff_name = $wpdb->get_results( "select * from $wpdb->prefix" . "apt_staff" ); $ap_fetch_service = $wpdb->get_results( "select * from $wpdb->prefix" . "apt_services" ); /* add service */ if ( isset( $_REQUEST['s_name'] ) ) { if ( ! wp_verify_nonce( $_REQUEST['add_service_security'], 'add_service' ) ) { die(); } $s_name = sanitize_text_field( $_REQUEST['s_name'] ); $ap_service_icon = sanitize_text_field( $_REQUEST['ap_service_icon'] ); $ap_ser_bg_color = sanitize_text_field( $_REQUEST['ap_ser_bg_color'] ); $duration = sanitize_text_field( $_REQUEST['duration'] ); $padding_before = sanitize_text_field( $_REQUEST['padding_before'] ); $padding_after = sanitize_text_field( $_REQUEST['padding_after'] ); $service_type = "paid_service"; if ( $service_type == 'free_service' ) { $price_1 = "0.00"; } else { $price_1 = sanitize_text_field( $_REQUEST['price_1'] ); } $capacity_1 = sanitize_text_field( $_REQUEST['capacity_1'] ); $category_id = sanitize_text_field( $_REQUEST['category_id'] ); $a_info = sanitize_text_field( $_REQUEST['a_info'] ); $wpdb->insert( $wpdb->prefix . 'apt_services', array( 'name' => $s_name, 'icon' => $ap_service_icon, 'color' => $ap_ser_bg_color, 'duration' => $duration, 'p_before' => $padding_before, 'p_after' => $padding_after, 'service_type' => $service_type, 'price' => $price_1, 'capacity' => $capacity_1, 'category' => $category_id, 'info_message' => $a_info, ) ); $wpdb->show_errors(); $wpdb->print_error(); } /* Update service */ if ( isset( $_REQUEST['u_s_name'] ) && isset( $_POST['ser_update_form_nonce'] ) ) { if ( ! wp_verify_nonce( $_POST['ser_update_form_nonce'], 'ser_update_form_nonce' ) ) { die(); } $service_id = sanitize_text_field( $_REQUEST['service_id'] ); $u_s_name = sanitize_text_field( $_REQUEST['u_s_name'] ); $update_icon_ser = sanitize_text_field( $_REQUEST['update_icon_ser'] ); $u_cal_bg_color = sanitize_text_field( $_REQUEST['u_cal_bg_color'] ); $u_s_duration = sanitize_text_field( $_REQUEST['u_s_duration'] ); $u_padding_before = sanitize_text_field( $_REQUEST['u_padding_before'] ); $u_padding_after = sanitize_text_field( $_REQUEST['u_padding_after'] ); $u_service_type = "paid_service"; if ( $u_service_type == 'free_service' ) { $u_price = "0.00"; } else { $u_price = sanitize_text_field( $_REQUEST['u_price'] ); } $u_capacity = sanitize_text_field( $_REQUEST['u_capacity'] ); $u_category_id = sanitize_text_field( $_REQUEST['u_category_id'] ); $u_a_info = sanitize_text_field( $_REQUEST['u_a_info'] ); $wpdb->update( $wpdb->prefix . 'apt_services', array( 'name' => $u_s_name, 'icon' => $update_icon_ser, 'color' => $u_cal_bg_color, 'duration' => $u_s_duration, 'p_before' => $u_padding_before, 'p_after' => $u_padding_after, 'service_type' => $u_service_type, 'price' => $u_price, 'capacity' => $u_capacity, 'category' => $u_category_id, 'info_message' => $u_a_info ), array( 'id' => $service_id ) ); $wpdb->show_errors(); $wpdb->print_error(); } // multi service delete if ( isset( $_REQUEST['service_delete'] ) ) { $id_array = sanitize_text_field( $_REQUEST['service_delete'] ); $arr = explode( ',', $id_array ); echo $id_count = count( $arr ); for ( $i = 0; $i <= $id_count; $i ++ ) { $del = $arr[ $i ]; $wpdb->delete( $wpdb->prefix . 'apt_services', array( 'id' => $del ) ); $wpdb->show_errors(); $wpdb->print_error(); } } if ( isset( $_REQUEST['u_category_name'] ) && isset( $_POST['u_cat_form_nonce'] ) ) { if ( ! wp_verify_nonce( $_POST['u_cat_form_nonce'], 'u_cat_form_nonce' ) ) { die(); } $category_name = sanitize_text_field( $_REQUEST['u_category_name'] ); $category_icon = sanitize_text_field( $_REQUEST['u_category_icon'] ); $update_cate_value = sanitize_text_field( $_REQUEST['update_cate_value'] ); $wpdb->update( $wpdb->prefix . 'apt_category', array( 'name' => $category_name, 'icon' => $category_icon, ), array( 'id' => $update_cate_value ) ); } ?>
id; ?>