get_charset_collate(); $table_name = $wpdb->prefix . 'fea_plans'; $sql = "CREATE TABLE $table_name ( id mediumint(9) NOT NULL AUTO_INCREMENT, created_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, expires_after text NOT NULL, title text NOT NULL, slug text NOT NULL, description text NULL, pricing int NOT NULL, currency text NOT NULL, plan_value longtext NULL, plan_parent int NOT NULL, menu_order int NOT NULL, UNIQUE KEY id (id) ) $charset_collate;"; require_once( ABSPATH . 'wp-admin/includes/upgrade.php' ); maybe_create_table( $table_name, $sql ); } public function insert_plan( $args = [] ){ if( empty( $args['created_at'] ) ){ $args['created_at'] = current_time( 'mysql' ); } if( empty( $args['title'] ) ){ $args['title'] = '(no name)'; } if( empty( $args['slug'] ) && '(no name)' !== $args['title'] ){ $args['slug'] = sanitize_title( $args['title'] ); } if( empty( $args['expires_after'] ) ){ $args['expires_after'] = 'never'; } if( empty( $args['pricing'] ) ){ $args['pricing'] = 0; } if( empty( $args['currency'] ) ){ $args['currency'] = 'USD'; } if( empty( $args['plan_parent'] ) ){ $args['plan_parent'] = 0; } if( empty( $args['menu_order'] ) ){ $args['menu_order'] = 0; } global $wpdb; $wpdb->insert( $wpdb->prefix . 'fea_plans', $args ); return $wpdb->insert_id; } public function update_plan( $id, $args ){ global $wpdb; $wpdb->update( $wpdb->prefix . 'fea_plans', $args, array( 'id' => $id ) ); } public function get_plan( $id = 0 ){ if( ! $id ) return $id; global $wpdb; $plan = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM {$wpdb->prefix}fea_plans WHERE id = %d", $id ) ); if( $plan->id == $id ) return $plan; return false; } /** * Retrieve plans data from the database * * @param array $args query arguments * * @return mixed */ public static function get_plans( $args = array() ) { global $wpdb; $args = feadmin_parse_args( $args, array( 'per_page' => 20, 'current_page' => 1, 'orderby' => 'created_at', 'order' => 'DESC', ) ); $sql = "SELECT * FROM {$wpdb->prefix}fea_plans"; if( ! empty( $_REQUEST['s'] ) ){ $value = $_REQUEST['s'] . '%'; $sql .= $wpdb->prepare( ' WHERE title LIKE %s', $value ); } $allowed_orderby = [ 'created_at', 'title' ]; // Modify this list to match your DB columns $allowed_order = [ 'ASC', 'DESC' ]; $orderby = in_array( $args['orderby'], $allowed_orderby, true ) ? $args['orderby'] : 'created_at'; $order = in_array( $args['order'], $allowed_order, true ) ? $args['order'] : 'DESC'; $sql .= " ORDER BY `$orderby` $order"; $sql .= $wpdb->prepare( " LIMIT %d", $args['per_page'] ); $sql .= $wpdb->prepare( " OFFSET %d", ( $args['current_page'] - 1 ) * $args['per_page'] ); $result = $wpdb->get_results( $sql, 'ARRAY_A' ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter -- values are added with $wpdb->prepare() and identifiers come from an allowlist above. return $result; } /** * Returns the count of records in the database. * * @return null|string */ public static function record_count() { global $wpdb; $sql = "SELECT COUNT(*) FROM {$wpdb->prefix}fea_plans"; return $wpdb->get_var( $sql ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter -- only the table prefix is interpolated. } public function ajax_delete_plan(){ // validate if ( ! feadmin_verify_ajax() ) { die(); } if ( ! current_user_can( 'manage_options' ) ) { wp_send_json_error( __( 'You do not have permission to do this.', 'frontend-admin' ) ); } if( empty( $_POST['plan'] ) ) wp_send_json_error( __( 'No plan found', 'frontend-admin' ) ); $plan_id = intval( $_POST['plan'] ); $deleted = $this->delete_plan( $plan_id ); if( 'success' == $deleted ) wp_send_json_success(); wp_send_json_error( __( 'Could not delete plan.', 'frontend-admin' ) ); } public function delete_plan( $id = 0 ){ if( $id == 0 ) return $id; global $wpdb; $wpdb->delete( $wpdb->prefix.'fea_plans', array( 'id' => $id ) ); return 'success'; } public function plans_page_options(){ if( isset( $_REQUEST['page'] ) && $_REQUEST['page'] == 'fea-plans' ){ $option = 'per_page'; $args = [ 'label' => 'Plans', 'default' => 20, 'option' => 'plans_per_page' ]; add_screen_option( $option, $args ); } } function set_plans_per_page($status, $option, $value) { if ( 'plans_per_page' == $option ) return $value; return $status; } public function plans_list(){ global $fa_plans_page; $fa_plans_page = add_submenu_page( 'fea-settings', __( 'Plans', 'frontend-admin' ), __( 'Plans', 'frontend-admin' ), 'manage_options', 'frontend-admin-plans', [ $this, 'admin_plans_page'], 82 ); add_action( "load-$fa_plans_page", array( $this, 'plans_page_options' ) ); } public function get_form( $plan_id ) { if ( is_numeric( $plan_id ) ) { $plan = $this->get_plan( intval( $plan_id ) ); if ( ! $plan ) { esc_html_e( 'Plan not found. Did you erase it?', 'frontend-admin' ); return false; } } if ( 'add_item' == $plan_id ) { $submit_value = __( 'Create Plan', 'frontend-admin' ); $success_message = __( 'Plan has been created successfully.', 'frontend-admin' ); $update = true; $defaults = [ 'title' => __( 'Basic', 'frontend-admin' ), 'expires_after' => 'never', 'pricing' => 1, 'currency' => 'USD', 'plan_value' => [ ] ]; } else { $submit_value = __( 'Update', 'frontend-admin' ); $success_message = __( 'Plan has been updated successfully.', 'frontend-admin' ); $defaults = [ 'title' => $plan->title, 'expires_after' => $plan->expires_after, 'pricing' => $plan->pricing, 'currency' => $plan->currency, ]; } if( function_exists( 'feadmin_get_currencies' ) ){ $currencies = feadmin_get_currencies(); }else{ $currencies = []; } $form = array( 'id' => 'plan_' . $plan_id, 'submit_value' => $submit_value, 'kses' => 0, 'no_cookies' => 1, 'no_record' => 1, 'ajax_submit' => 1, 'update_message' => $success_message, 'show_update_message' => 1, 'custom_fields_save' => 'plan', 'plan_id' => $plan_id, 'default_submit_button' => 1, 'fields' => [ 'title' => array( 'name' => 'title', 'key' => 'title', 'label' => __( 'Title', 'frontend-admin' ), 'type' => 'text', 'instructions' => '', 'default_value' => $defaults['title'], ), /* 'slug' => array( 'name' => 'slug', 'key' => 'slug', 'label' => __( 'Slug', 'frontend-admin' ), 'type' => 'text', 'instructions' => '', 'default_value' => sanitize_title( $defaults['title'] ), 'wrapper' => array( 'class' => 'post-slug-field', ), ), */ 'expires_after' => array( 'name' => 'expires_after', 'key' => 'expires_after', 'label' => __( 'Expiration', 'frontend-admin' ), 'type' => 'select', 'choices' => [ 'never' => __( 'Never', 'frontend-admin' ), 'week' => __( 'Week', 'frontend-admin' ), 'month' => __( 'Month', 'frontend-admin' ), 'year' => __( 'Year', 'frontend-admin' ), ], 'return_format' => 'value', 'instructions' => '', 'default_value' => $defaults['expires_after'], 'multiple' => 0 ), 'pricing' => array( 'name' => 'pricing', 'key' => 'pricing', 'label' => __( 'Price', 'frontend-admin' ), 'type' => 'number', 'instructions' => '', 'min' => 1, 'default_value' => $defaults['pricing'], ), 'currency' => array( 'name' => 'currency', 'key' => 'currency', 'label' => __( 'Currency', 'frontend-admin' ), 'type' => 'select', 'choices' => $currencies, 'return_format' => 'value', 'instructions' => '', 'default_value' => $defaults['currency'], 'multiple' => 0 ), ], ); global $ajax_render_form; if( $ajax_render_form ) { $form['ajax_submit'] = 'plan_form'; $form['close_modal'] = 1; } return $form; } public function admin_plans_page(){ require_once( 'list.php'); $option = 'per_page'; $args = [ 'label' => 'Plans', 'default' => 20, 'option' => 'plans_per_page' ]; add_screen_option( $option, $args ); ?>
plans_list->prepare_items(); fea_instance()->plans_list->display(); } function save_plan( $form ){ if ( empty( $form['plan_id'] ) || empty( $form['record']['fields']['plan'] ) ) { return $form; } $plan_args = []; foreach( $form['record']['fields']['plan'] as $key => $field ){ $plan_args[$key] = $field['_input']; } $response = array( 'modal' => true, 'plan' => $plan_args, 'form_element' => 'plan', ); if( is_numeric( $form['plan_id'] ) ){ $this->update_plan( $form['plan_id'], $plan_args ); $response['plan']['id'] = $form['plan_id']; }else{ $response['new'] = true; $response['plan']['id'] = $this->insert_plan( $plan_args ); } wp_send_json_success( $response ); } public function render_form( $args ) { if ( 'plan' != $args['data_type'] ) return; $form = $this->get_form( sanitize_text_field( $args['form_action'] ) ); if ( $form ) { fea_instance()->form_display->render_form( $form ); } die(); } public function __construct() { $this->create_plans(); add_action( 'frontend_admin/form/on_submit', [ $this, 'save_plan' ] ); add_action( 'wp_ajax_frontend_admin/plans/delete', [ $this, 'ajax_delete_plan'] ); add_action( 'frontend_admin/ajax_add_form', array( $this, 'render_form' ) ); add_filter( 'frontend_admin/forms/get_form', function( $form, $key ){ if( ! $key ) return $form; $key = explode( 'plan_', $key ); if( isset( $key[1] ) ) return $this->get_form( $key[1] ); return $form; }, 10, 2 ); // add_action( 'admin_menu', array( $this, 'plans_list' ), 20 ); // add_filter( 'set-screen-option', array( $this, 'set_plans_per_page' ), 11, 3 ); } } fea_instance()->plans_handler = new Plans_Crud; endif;