form_id ); $entries_table_list->process_bulk_action(); $entries_table_list->prepare_items(); ?>

views(); ?>

forms ) ) : ?>

is_entries_page() ) { // Trash entry. if ( isset( $_GET['trash'] ) ) { // phpcs:ignore WordPress.Security.NonceVerification $this->trash_entry(); } // Untrash entry. if ( isset( $_GET['untrash'] ) ) { // phpcs:ignore WordPress.Security.NonceVerification $this->untrash_entry(); } // Delete entry. if ( isset( $_GET['delete'] ) ) { // phpcs:ignore WordPress.Security.NonceVerification $this->delete_entry(); } // Export CSV. if ( isset( $_REQUEST['export_action'] ) ) { // phpcs:ignore WordPress.Security.NonceVerification $this->export_csv(); } // Empty Trash. if ( isset( $_REQUEST['delete_all'] ) || isset( $_REQUEST['delete_all2'] ) ) { // phpcs:ignore WordPress.Security.NonceVerification $this->empty_trash(); } } } /** * Trash entry. */ private function trash_entry() { check_admin_referer( 'trash-entry' ); $form_id = isset( $_GET['form_id'] ) ? absint( $_GET['form_id'] ) : ''; if ( isset( $_GET['trash'] ) ) { // phpcs:ignore WordPress.Security.NonceVerification $entry_id = absint( $_GET['trash'] ); // phpcs:ignore WordPress.Security.NonceVerification if ( $entry_id ) { self::update_status( $entry_id, 'trash' ); } } wp_safe_redirect( esc_url_raw( add_query_arg( array( 'form_id' => $form_id, 'trashed' => 1, ), admin_url( 'admin.php?page=evf-entries' ) ) ) ); exit(); } /** * Trash entry. */ private function untrash_entry() { check_admin_referer( 'untrash-entry' ); $form_id = isset( $_GET['form_id'] ) ? absint( $_GET['form_id'] ) : ''; if ( isset( $_GET['untrash'] ) ) { // phpcs:ignore WordPress.Security.NonceVerification $entry_id = absint( $_GET['untrash'] ); // phpcs:ignore WordPress.Security.NonceVerification if ( $entry_id ) { self::update_status( $entry_id, 'publish' ); } } wp_safe_redirect( esc_url_raw( add_query_arg( array( 'form_id' => $form_id, 'untrashed' => 1, ), admin_url( 'admin.php?page=evf-entries' ) ) ) ); exit(); } /** * Delete entry. */ private function delete_entry() { check_admin_referer( 'delete-entry' ); $form_id = isset( $_GET['form_id'] ) ? absint( $_GET['form_id'] ) : ''; if ( isset( $_GET['delete'] ) ) { // phpcs:ignore WordPress.Security.NonceVerification $entry_id = absint( $_GET['delete'] ); // phpcs:ignore WordPress.Security.NonceVerification if ( $entry_id ) { self::remove_entry( $entry_id ); } } wp_safe_redirect( esc_url_raw( add_query_arg( array( 'form_id' => $form_id, 'deleted' => 1, ), admin_url( 'admin.php?page=evf-entries' ) ) ) ); exit(); } /** * Empty Trash. */ public function empty_trash() { global $wpdb; check_admin_referer( 'bulk-entries' ); if ( isset( $_GET['form_id'] ) ) { // phpcs:ignore WordPress.Security.NonceVerification $form_id = absint( $_GET['form_id'] ); // phpcs:ignore WordPress.Security.NonceVerification if ( $form_id ) { $count = 0; $results = $wpdb->get_results( $wpdb->prepare( "SELECT entry_id FROM {$wpdb->prefix}evf_entries WHERE `status` = 'trash' AND form_id = %d", $form_id ) ); // WPCS: cache ok, DB call ok. $entry_ids = array_map( 'intval', wp_list_pluck( $results, 'entry_id' ) ); foreach ( $entry_ids as $entry_id ) { if ( self::remove_entry( $entry_id ) ) { $count ++; } } add_settings_error( 'empty_trash', 'empty_trash', /* translators: %d: number of entries */ sprintf( _n( '%d entry permanently deleted.', '%d entries permanently deleted.', $count, 'everest-forms' ), $count ), 'updated' ); } } } /** * Do the entries export. * * @since 1.3.0 */ public function export_csv() { check_admin_referer( 'bulk-entries' ); if ( isset( $_REQUEST['form_id'] ) && current_user_can( 'export' ) ) { // phpcs:ignore WordPress.Security.NonceVerification include_once EVF_ABSPATH . 'includes/export/class-evf-entry-csv-exporter.php'; $form_id = absint( $_REQUEST['form_id'] ); // phpcs:ignore WordPress.Security.NonceVerification $form_name = strtolower( get_the_title( $form_id ) ); if ( $form_name ) { $exporter = new EVF_Entry_CSV_Exporter( $form_id ); $exporter->set_filename( evf_get_csv_file_name( $form_name ) ); } $exporter->export(); } } /** * Remove entry. * * @param int $entry_id Entry ID. * @return bool */ public static function remove_entry( $entry_id ) { global $wpdb; $delete = $wpdb->delete( $wpdb->prefix . 'evf_entries', array( 'entry_id' => $entry_id ), array( '%d' ) ); if ( apply_filters( 'everest_forms_delete_entrymeta', true ) ) { $wpdb->delete( $wpdb->prefix . 'evf_entrymeta', array( 'entry_id' => $entry_id ), array( '%d' ) ); } return $delete; } /** * Set entry status. * * @param int $entry_id Entry ID. * @param string $status Entry status. */ public static function update_status( $entry_id, $status = 'publish' ) { global $wpdb; if ( in_array( $status, array( 'star', 'unstar' ), true ) ) { $update = $wpdb->update( $wpdb->prefix . 'evf_entries', array( 'starred' => 'star' === $status ? 1 : 0, ), array( 'entry_id' => $entry_id ), array( '%d' ), array( '%d' ) ); } elseif ( in_array( $status, array( 'read', 'unread' ), true ) ) { $update = $wpdb->update( $wpdb->prefix . 'evf_entries', array( 'viewed' => 'read' === $status ? 1 : 0, ), array( 'entry_id' => $entry_id ), array( '%d' ), array( '%d' ) ); } else { $entry = evf_get_entry( $entry_id ); // Preseve entry status. if ( 'trash' === $status ) { $wpdb->insert( $wpdb->prefix . 'evf_entrymeta', array( 'entry_id' => $entry_id, 'meta_key' => '_evf_trash_entry_status', 'meta_value' => sanitize_text_field( $entry->status ), // phpcs:ignore WordPress.DB.SlowDBQuery.slow_db_query_meta_value ) ); } elseif ( 'publish' === $status ) { $status = $wpdb->get_var( $wpdb->prepare( "SELECT meta_value FROM {$wpdb->prefix}evf_entrymeta WHERE entry_id = %d AND meta_key = '_evf_trash_entry_status'", $entry_id ) ); $wpdb->delete( $wpdb->prefix . 'evf_entrymeta', array( 'entry_id' => $entry_id, 'meta_key' => '_evf_trash_entry_status', ) ); } $update = $wpdb->update( $wpdb->prefix . 'evf_entries', array( 'status' => $status ), array( 'entry_id' => $entry_id ), array( '%s' ), array( '%d' ) ); } return $update; } /** * Check new entries with heartbeat API. * * @since 1.5.0 * * @param array $response The Heartbeat response. * @param array $data The $_POST data sent. * @param string $screen_id The screen id. * @return array The Heartbeat response. */ public function check_new_entries( $response, $data, $screen_id ) { if ( 'everest-forms_page_evf-entries' === $screen_id ) { $form_id = ! empty( $data['evf_new_entries_form_id'] ) ? absint( $data['evf_new_entries_form_id'] ) : 0; $last_entry_id = ! empty( $data['evf_new_entries_last_entry_id'] ) ? absint( $data['evf_new_entries_last_entry_id'] ) : 0; // Count new entries. $entries_count = evf_get_count_entries_by_last_entry( $form_id, $last_entry_id ); if ( ! empty( $entries_count ) ) { /* translators: %d - New form entries count. */ $response['evf_new_entries_notification'] = esc_html( sprintf( _n( '%d new entry since you last checked.', '%d new entries since you last checked.', $entries_count, 'everest-forms' ), $entries_count ) ); } } return $response; } } new EVF_Admin_Entries();