get_charset_collate(); $table_name = $wpdb->prefix . 'fea_submissions'; $sql = "CREATE TABLE $table_name ( id mediumint(9) NOT NULL AUTO_INCREMENT, title text NOT NULL, created_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, user int NOT NULL, fields longtext NOT NULL, form text NOT NULL, status text NOT NULL, UNIQUE KEY id (id) ) $charset_collate;"; include_once ABSPATH . 'wp-admin/includes/upgrade.php'; maybe_create_table( $table_name, $sql ); } public function insert_submission( $args ) { global $wpdb; if( empty( $args['created_at'] ) ){ $args['created_at'] = current_time( 'mysql' ); } if ( empty( $args['title'] ) ) { $args['title'] = '(no name)'; } $wpdb->insert( $wpdb->prefix . 'fea_submissions', $args ); $submits_count = get_option( 'frontend_admin_submissions_all_time', 0 ); $submits_count++; update_option( 'frontend_admin_submissions_all_time', $submits_count ); return $wpdb->insert_id; } public function update_submission( $id, $args ) { if ( isset( $args['fields'] ) && is_array( $args['fields'] ) ) { $args['fields'] = fea_encrypt( json_encode( $args['fields'] ) ); } global $wpdb; $wpdb->update( $wpdb->prefix . 'fea_submissions', $args, array( 'id' => $id ) ); } public function approve_submission( $id ) { global $wpdb; $submission = $this->get_submission( $id ); if ( $submission->status == 'pending' ) { $form = $this->get_form( $submission ); foreach ( fea_instance()->local_actions as $action ) { $name = $action->get_name(); $form = $action->run( $form ); } $wpdb->update( $wpdb->prefix . 'fea_submissions', array( 'status' => 'approved' ), array( 'id' => $id ) ); } } public function get_submission( $id = 0 ) { if ( ! $id ) { return $id; } global $wpdb; $id = (int) $id; $submission = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM {$wpdb->prefix}fea_submissions WHERE id = %d", $id ) ); $submission = maybe_unserialize( $submission ); $submission = wp_unslash( $submission ); return $submission; } public function get_status_label( $slug ) { switch ( $slug ) { case 'in_progress': return __( 'In Progress', 'frontend-admin' ); case 'require_approval': return __( 'Pending Approval', 'frontend-admin' ); case 'verify_email': return __( 'Pending Email Verification', 'frontend-admin' ); case 'email_verified': return __( 'Email Verified', 'frontend-admin' ); case 'pending_payment': return __( 'Pending Payment', 'frontend-admin' ); case 'payment_received': return __( 'Payment Received', 'frontend-admin' ); case 'approved': return __( 'Approved', 'frontend-admin' ); default: return $slug; } } /** * Retrieve submissions data from the database * * @param array $args query arguments * * @return mixed */ /** * Retrieve submissions data from the database * * @param array $args query arguments * * @return mixed */ public static function get_submissions( $args = array() ) { if ( ! current_user_can( 'edit_posts' ) ) { return false; } // Parse and sanitize request parameters $args = wp_parse_args( $args, [ 'orderby' => isset( $_REQUEST['orderby'] ) ? sanitize_key( $_REQUEST['orderby'] ) : '', 'order' => isset( $_REQUEST['order'] ) ? strtoupper( sanitize_text_field( $_REQUEST['order'] ) ) : '', 'per_page' => isset( $_REQUEST['per_page'] ) ? (int) $_REQUEST['per_page'] : 10, 'paged' => isset( $_REQUEST['paged'] ) ? max( 1, (int) $_REQUEST['paged'] ) : 1, ] ); // Allowlisted columns and order directions $allowed_orderby = [ 'created_at', 'title', 'status' ]; // 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'; $per_page = (int) $args['per_page']; $current_page = (int) $args['paged']; $offset = ( $current_page - 1 ) * $per_page; // Base query - update table name accordingly global $wpdb; $table = $wpdb->prefix . 'fea_submissions'; $sql = "SELECT * FROM `$table`"; // Append search query if any if ( ! empty( $_REQUEST['s'] ) ) { $search = sanitize_text_field( $_REQUEST['s'] ); $sql .= $wpdb->prepare( ' WHERE title LIKE %s', '%' . $wpdb->esc_like( $search ) . '%' ); } // Append ORDER BY $sql .= " ORDER BY `$orderby` $order"; // Pagination if ( $per_page !== -1 ) { $sql .= $wpdb->prepare( ' LIMIT %d OFFSET %d', $per_page, $offset ); } // Append WHERE clause if any filters are applied if ( ! empty( $args['form'] ) ) { $sql .= $wpdb->prepare( ' WHERE form = %s', $args['form'] ); } global $current_screen; // Execute query $results = $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. // Send response return $results; } /** * Returns the count of records in the database. * * @return null|string */ public static function record_count( $args = array() ) { global $wpdb; $sql = "SELECT COUNT(form) FROM {$wpdb->prefix}fea_submissions"; if ( ! empty( $args['form'] ) ) { $form = true; $sql .= $wpdb->prepare( ' WHERE form = %s', $args['form'] ); } if ( ! empty( $args['form_key'] ) ) { if ( isset( $form ) ) { $sql .= ' OR'; } else { $sql .= ' WHERE'; } $sql .= $wpdb->prepare( ' form = %s', $args['form_key'] ); $form = true; } if ( ! empty( $args['form_id'] ) ) { if ( isset( $form ) ) { $sql .= ' OR'; } else { $sql .= ' WHERE'; } $sql .= $wpdb->prepare( ' form = %d', $args['form_id'] ); } return $wpdb->get_var( $sql ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter -- values are added with $wpdb->prepare() and identifiers come from an allowlist above. } public function delete_submission( $id = 0 ) { if ( $id == 0 ) { return $id; } global $wpdb; $wpdb->delete( $wpdb->prefix . 'fea_submissions', array( 'id' => $id ) ); return 1; } public function display_submissions() { include_once __DIR__ . '/list.php'; $display_list = true; if ( isset( $_REQUEST['id'] ) ) { $submission_id = absint( $_REQUEST['id'] ); $submission = $this->get_submission( $submission_id ); if ( $submission ) { $user = get_user_by( 'ID', $submission->user ); if ( is_object( $user ) ) { $title = $user->display_name . ' (' . $user->user_login . ')'; } else { $title = '--'; } ?>

fields ), true ); $record = $record['record'] ?? $record; if ( ! empty( $record['approved_by'] ) ) { $approver = get_user_by( 'ID', $record['approved_by'] ); if ( is_object( $approver ) ) { echo '

' . esc_html( sprintf( /* translators: 1: value 2: value 3: value */ __( 'Approved by %1$s (%2$s) on %3$s', 'frontend-admin' ), $approver->display_name, $approver->user_login, $record['approved_at'] ?? '' ) ) . '

'; } } $action = fea_instance()->submissions_list->current_action(); if ( $action == 'edit' ) { $form = $this->get_form( $submission, array(), true, true ); if( ! $form ){ echo '

'. esc_html__( 'Form not found.', 'frontend-admin' ) .'

'; return; } $form['wp_uploader'] = 1; if( empty( $form['object'] ) ){ fea_instance()->form_display->render_form( $form ); }else{ if( 'gutenberg' == ( $form['builder'] ?? '' ) ){ $block_content = render_block( $form['object'] ); echo $block_content; // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped -- rendered block markup. }else{ $form['object']->print_element(); } } if ( ! empty( $form['record']['emails_to_verify'] ) ) { echo '
'; echo '

'. esc_html( __( 'Pending Verification:', 'frontend-admin' ) ) . '

'; } if ( ! empty( $form['record']['verified_emails'] ) ) { echo '
'; echo '

'. esc_html( __( 'Verified Emails:', 'frontend-admin' ) ) . '

'; } $display_list = false; } elseif ( $action == 'delete' ) { if ( empty( $_REQUEST['nonce'] ) ) { die( 'Authentication Error. Please try refreshing the page.' ); } $nonce = esc_attr( wp_kses( $_REQUEST['nonce'], 'strip' ) ); if ( ! wp_verify_nonce( $nonce, 'frontend_admin_delete_submission' ) ) { die( 'Go get a life script kiddies' ); } $this->delete_submission( $submission_id ); } } else { $display_list = true; } } if ( $display_list ) { fea_instance()->submissions_list->prepare_items(); ?>

submissions_list->search_box( 'search', 'search_id' ); fea_instance()->submissions_list->display(); ?>
get_submission( $submission ); if ( ! $submission ) { esc_html_e( 'Submission not found. Did you erase it?', 'frontend-admin' ); return false; } } if ( empty( $form ) ) { $form = fea_instance()->form_display->get_form( $submission->form, $element ); if( ! $form ){ $form_id = explode( ':', $submission->form ); $form_id = $form_id[0]; $form = fea_instance()->form_display->get_form( $form_id, $element ); if( ! $form ){ esc_html_e( 'Form not found. Did you erase it?', 'frontend-admin' ); return false; } } $current_user = wp_get_current_user(); if ( $current_user && $current_user->ID == $submission->user ) { $form['display'] = true; } $fields = json_decode( fea_decrypt( $submission->fields ), true ); $fields = wp_unslash( $fields ); if ( ! isset( $fields['record'] ) ) { $form['record'] = $fields; } else { $form['record'] = $fields['record']; } } $fields = array(); if ( ! empty( $form['record']['fields'] ) ) { foreach ( $form['record']['fields'] as $type ) { if ( is_array( $type ) ) { $fields = array_merge( $fields, $type ); } } } $approval_form = $form; $approval_form['submission'] = $submission->id; $approval_form['submission_title'] = $submission->title; if ( $approval ) { if ( $submission->status == 'approved' ) { $submit_value = __( 'Update', 'frontend-admin' ); $success_message = __( 'Data has been updated.', 'frontend-admin' ); $update = true; } else { $submit_value = __( 'Approve', 'frontend-admin' ); $success_message = __( 'Submission has been approved. Data has been saved.', 'frontend-admin' ); } $approval_form = array_merge( $approval_form, array( 'submit_value' => $submit_value, 'kses' => 0, 'no_cookies' => 1, 'approval' => 1, 'submitted_by' => $submission->user, 'submitted_on' => $submission->created_at, 'return' => admin_url( 'admin.php?page=' . 'fea-settings-submissions&action=edit&id=' . $submission->id ), 'update_message' => $success_message, 'show_update_message' => 1, 'hidden_fields' => [ 'submission' => $submission->id, 'approval_nonce' => wp_create_nonce( 'frontend_admin_approve_submission' ), ] ) ); } $data_types = array( 'post', 'user', 'term', 'product' ); foreach ( $data_types as $type ) { if ( isset( $form['record'][ $type ] ) ) { $approval_form[ "{$type}_id" ] = $form['record'][ $type ]; if ( isset( $update ) && is_numeric( $form['record'][ $type ] ) ) { $approval_form[ "save_to_{$type}" ] = 'edit_' . $type; } else { $approval_form[ "save_to_{$type}" ] = $form[ "save_to_{$type}" ] ?? null; } } } global $ajax_render_form, $fea_form; if( $ajax_render_form ) { $form['ajax_submit'] = 'submission_form'; $form['close_modal'] = 1; } $fea_form = $approval_form; $approval_form['fields'] = apply_filters( 'frontend_admin/submissions/form_fields', $approval_form['fields'], $approval_form, $approval_form['id'] ); return $approval_form; } public function submissions_page_options() { if ( isset( $_REQUEST['page'] ) && $_REQUEST['page'] == 'fea-settings-submissions' ) { $option = 'per_page'; $args = array( 'label' => 'Submissions', 'default' => 20, 'option' => 'submissions_per_page', ); add_screen_option( $option, $args ); } } function set_submissions_per_page( $status, $option, $value ) { if ( 'submissions_per_page' == $option ) { return $value; } return $status; } public function custom_admin_pages() { if ( ! get_option( 'frontend_admin_save_submissions' ) ) { return; } global $fea_submissions_page; $fea_submissions_page = add_submenu_page( 'fea-settings', __( 'Submissions', 'frontend-admin' ), __( 'Submissions', 'frontend-admin' ), 'manage_options', 'fea-settings-submissions', array( $this, 'display_submissions' ), 81 ); add_action( "load-$fea_submissions_page", array( $this, 'submissions_page_options' ) ); } public function render_form( $args ) { if ( 'submission' != $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() { add_action( 'admin_menu', array( $this, 'custom_admin_pages' ), 19 ); $this->create_submissions(); add_filter( 'set-screen-option', array( $this, 'set_submissions_per_page' ), 11, 3 ); add_action( 'frontend_admin/ajax_add_form', array( $this, 'render_form' ) ); add_filter( 'frontend_admin/forms/get_submission', function( $form, $submission ){ if( empty( $submission ) ){ return $form; } //check for approval nonce $nonce = $_POST['_acf_approval_nonce'] ?? ''; if( ! $nonce || ! wp_verify_nonce( $nonce, 'frontend_admin_approve_submission' ) ){ $approval = false; }else{ $approval = true; } $form = $this->get_form( $submission, $form, $approval, true ); return $form; }, 20, 3 ); } } fea_instance()->submissions_handler = new Submissions_Crud(); endif;