Sid Gifari File Manager
🏠 Root
/
home2
/
iuywvcmy
/
public_html
/
wp-content
/
plugins
/
everest-forms
/
includes
/
export
/
Editing: class-evf-entry-csv-exporter.php
<?php /** * Handles entry CSV export. * * @package EverestForms\Export * @since 1.3.0 */ defined( 'ABSPATH' ) || exit; /** * Include dependencies. */ if ( ! class_exists( 'EVF_CSV_Exporter', false ) ) { require_once EVF_ABSPATH . 'includes/export/abstract-evf-csv-exporter.php'; } /** * EVF_Entry_CSV_Exporter Class. */ class EVF_Entry_CSV_Exporter extends EVF_CSV_Exporter { /** * Form ID. * * @var int|mixed */ public $form_id; /** * Request Data. * * @since 1.8.7 * @var array */ public $request_data; /** * Entry ID. * * @var int|mixed */ public $entry_id; /** * Type of export used in filter names. * * @var string */ protected $export_type = 'entry'; /** * Constructor. * * @param int $form_id Form ID. * @param int $entry_id Entry ID. * @param array $request_data Request Data. */ public function __construct( $form_id = '', $entry_id = '', $request_data = array() ) { $this->form_id = absint( $form_id ); $this->entry_id = absint( $entry_id ); $this->request_data = $request_data; $this->column_names = $this->get_default_column_names(); } /** * Return an array of columns to export. * * @return array */ public function get_default_column_names() { $columns = array(); $form_obj = evf()->form->get( $this->form_id ); $form_data = ! empty( $form_obj->post_content ) ? evf_decode( $form_obj->post_content ) : ''; // Set Entry ID at first. $columns['entry_id'] = esc_html__( 'ID', 'everest-forms' ); // Add whitelisted fields to export columns. if ( ! empty( $form_data['form_fields'] ) ) { foreach ( $form_data['form_fields'] as $field ) { if ( ! in_array( $field['type'], array( 'html', 'title', 'captcha', 'divider' ), true ) ) { switch ( $field['type'] ) { case 'likert': $field_id = $field['id']; foreach ( $field['likert_rows'] as $key => $col_row ) { $col_row_key = "$field_id-likert-$key"; $columns[ $col_row_key ] = $col_row; } break; default: $columns[ $field['id'] ] = evf_clean( $field['label'] ); break; } } } } // Set the default columns. $columns['status'] = esc_html__( 'Status', 'everest-forms' ); $columns['date_created'] = esc_html__( 'Date Created', 'everest-forms' ); $columns['date_created_gmt'] = esc_html__( 'Date Created GMT', 'everest-forms' ); // If user details are disabled globally discard the IP and UA. if ( 'yes' !== get_option( 'everest_forms_disable_user_details' ) ) { $columns['user_device'] = esc_html__( 'User Device', 'everest-forms' ); $columns['user_ip_address'] = esc_html__( 'User IP Address', 'everest-forms' ); } return apply_filters( "everest_forms_export_{$this->export_type}_default_columns", $columns, $this->request_data ); } /** * Prepare data for export. * * @since 1.6.0 */ public function prepare_data_to_export() { $this->row_data = array(); if ( $this->entry_id ) { $entry = evf_get_entry( $this->entry_id ); $this->row_data[] = $this->generate_row_data( $entry ); } else { $entry_ids = evf_search_entries( array( 'limit' => -1, 'order' => 'ASC', 'form_id' => $this->form_id, ) ); // Get the entries. $entries = array_map( 'evf_get_entry', $entry_ids ); $checked_entry_id = isset( $_REQUEST['entry'] ) ? wp_parse_id_list( wp_unslash( $_REQUEST['entry'] ) ) : array(); // phpcs:ignore WordPress.Security.NonceVerification foreach ( $entries as $entry ) { if ( ! empty( $checked_entry_id ) && ! in_array( absint( $entry->entry_id ), $checked_entry_id, true ) ) { continue; } $this->row_data[] = $this->generate_row_data( $entry ); } } return $this->row_data; } /** * Prepare and get quiz report data in CSV format. */ public function get_quiz_report() { $form_data = EVF()->form->get( absint( $this->form_id ), array( 'content_only' => true, ) ); $form_fields = isset( $form_data['form_fields'] ) ? $form_data['form_fields'] : array(); $entry = evf_get_entry( $this->entry_id ); $columns = array( 'ID' ); $row = array( $this->entry_id ); $total_score = 0; $respondent_score = 0; $obtained_score = 0; $include_all_fields = apply_filters( 'evf_include_all_fields_in_quiz_report_csv', false ); // Add form fields in the CSV content. foreach ( $form_fields as $field_id => $field ) { $quiz_enabled = isset( $field['quiz_status'] ) && '1' === $field['quiz_status'] ? true : false; // Move onto next field if this field has quiz disabled and non-quiz fields are to be excluded. if ( false === $include_all_fields && false === $quiz_enabled ) { continue; } $meta_key = isset( $field['meta-key'] ) ? $field['meta-key'] : ''; $given_answer = isset( $entry->meta[ $meta_key ] ) ? $entry->meta[ $meta_key ] : null; $correct_answer = isset( $field['correct_answer'] ) ? $field['correct_answer'] : array(); $field_score = empty( $field['score'] ) ? 0 : $field['score']; $score = 0; $total_score += $field_score; $is_correct = false; if ( ! is_null( $given_answer ) ) { $respondent_score += $field_score; if ( ! empty( $correct_answer ) ) { // Determine if the given answer is correct. if ( 'select' === $field['type'] ) { foreach ( $correct_answer as $answer_key => $answer_status ) { $choice = $field['choices'][ $answer_key ]['label']; if ( $given_answer === $choice ) { $is_correct = true; break; } } } elseif ( 'radio' === $field['type'] ) { $correct_answer_key = array_keys( $correct_answer )[0]; $correct_answer = $field['choices'][ $correct_answer_key ]['label']; $given_answer = evf_maybe_unserialize( $given_answer )['label']; $is_correct = ( $given_answer === $correct_answer ); } elseif ( 'checkbox' === $field['type'] ) { $given_answer_data = evf_maybe_unserialize( $given_answer )['label']; $is_correct = true; $choices = $field['choices']; $correct_answer_keys = array_keys( $correct_answer ); $correct_answers = array(); $given_answers = array(); // Prepare list of correct answers. foreach ( $correct_answer_keys as $correct_answer_key ) { $correct_answers[] = $choices[ $correct_answer_key ]['label']; } // Prepare list of given answers. foreach ( $given_answer_data as $given_answer ) { $given_answers[] = $given_answer; } // See if all the given answers are correct answers. foreach ( $given_answers as $given_answer ) { if ( ! in_array( $given_answer, $correct_answers, true ) ) { $is_correct = false; break; } } } } } // Add score if the given answer is correct. if ( true === $is_correct ) { $score = $field_score; $obtained_score += $field_score; } $columns[] = $this->sanitize_csv_cell_data( $field['label'] ); $row[] = $this->sanitize_csv_cell_data( $score ); } // Add extra columns. $extra_data = array( 'Total Score' => $total_score, 'Respondent Score' => $respondent_score, 'Obtained Score' => $obtained_score, ); foreach ( $extra_data as $key => $value ) { $columns[] = $this->sanitize_csv_cell_data( $key ); $row[] = $this->sanitize_csv_cell_data( $value ); } ob_start(); echo esc_html( implode( ', ', $columns ) ); echo "\n"; echo esc_html( implode( ', ', $row ) ); return ob_get_clean(); } /** * Sanitize data for a cell in CSV. * * @param string $str Data to sanitize. */ public function sanitize_csv_cell_data( $str ) { $str = (string) $str; $str = str_replace( '"', '""', $str ); $str = '"' . $str . '"'; return $str; } /** * Take a entry id and generate row data from it for export. * * @param object $entry Entry object. * @return array */ protected function generate_row_data( $entry ) { $columns = $this->get_column_names(); $row = array(); $fields = json_decode( $entry->fields, true ); foreach ( $columns as $column_id => $column_name ) { $column_id = strstr( $column_id, ':' ) ? current( explode( ':', $column_id ) ) : $column_id; $position = strpos( $column_id, '-likert-' ); if ( $position !== false ) { $column_id = substr( $column_id, 0, $position ); } $value = ''; $raw_value = ''; if ( isset( $fields[ $column_id ] ) ) { // Filter for entry meta data. $field_type = isset( $fields[ $column_id ]['type'] ) ? $fields[ $column_id ]['type'] : ''; switch ( $field_type ) { case 'checkbox': case 'payment-checkbox': $value = isset( $fields[ $column_id ]['value']['label'] ) ? $fields[ $column_id ]['value']['label'] : ''; if ( is_array( $value ) ) { $value = implode( ',', $value ); } else { $value = $value; } break; case 'radio': case 'payment-multiple': $value = $fields[ $column_id ]['value']['label']; break; case 'select': $value = $fields[ $column_id ]['value']; if ( is_array( $value ) ) { $value = implode( ',', $value ); } else { $value = $value; } break; case 'rating': $value = ! empty( $fields[ $column_id ]['value']['value'] ) ? $fields[ $column_id ]['value']['value'] : 0; $number_of_stars = ! empty( $fields[ $column_id ]['number_of_rating'] ) ? $fields[ $column_id ]['number_of_rating'] : 5; $value = $value . '/' . $number_of_stars; break; case 'country': $value = apply_filters( 'everest_forms_plaintext_field_value', $fields[ $column_id ]['value']['country_code'], $fields[ $column_id ]['value'], $entry, 'email-plain' ); break; case 'repeater-fields': $labels = array(); $repeater_fields = array(); $repeater_accumulator = array(); foreach ( $fields[ $column_id ]['value_raw'] as $field_value ) { foreach ( $field_value as $key => $val ) { $repeater_field_value = ''; if ( isset( $repeater_fields[ $val['id'] ] ) ) { $repeater_field_type = isset( $repeater_fields[ $val['id'] ]['type'] ) ? $repeater_fields[ $val['id'] ]['type'] : ''; switch ( $repeater_field_type ) { case 'checkbox': case 'payment-checkbox': $current_value = is_array( $val['value']['label'] ) ? implode( ', ', $val['value']['label'] ) : $val['value']['label']; if ( ! isset( $repeater_accumulator[ $val['id'] ] ) ) { $repeater_accumulator[ $val['id'] ] = array(); } $repeater_accumulator[ $val['id'] ][] = $current_value; $repeater_field_value = implode( ', ', $repeater_accumulator[ $val['id'] ] ); break; case 'radio': case 'payment-multiple': $current_value = $val['value']['label']; if ( ! isset( $repeater_accumulator[ $val['id'] ] ) ) { $repeater_accumulator[ $val['id'] ] = array(); } $repeater_accumulator[ $val['id'] ][] = $current_value; $repeater_field_value = implode( ', ', $repeater_accumulator[ $val['id'] ] ); break; case 'select': $current_value = $val['value']; if ( is_array( $current_value ) ) { $current_value = implode( ', ', $current_value ); } if ( ! isset( $repeater_accumulator[ $val['id'] ] ) ) { $repeater_accumulator[ $val['id'] ] = array(); } $repeater_accumulator[ $val['id'] ][] = $current_value; $repeater_field_value = implode( ', ', $repeater_accumulator[ $val['id'] ] ); break; default: $current_value = $val['value']; if ( ! isset( $repeater_accumulator[ $val['id'] ] ) ) { $repeater_accumulator[ $val['id'] ] = array(); } $repeater_accumulator[ $val['id'] ][] = $current_value; $repeater_field_value = implode( ', ', $repeater_accumulator[ $val['id'] ] ); break; } } else { $repeater_fields[ $val['id'] ] = $val; $current_value = is_array( $val['value'] ) && isset( $val['value']['label'] ) ? $val['value']['label'] : $val['value']; if ( is_array( $current_value ) ) { $current_value = implode( ', ', $current_value ); } $repeater_accumulator[ $val['id'] ][] = $current_value; $repeater_field_value = $current_value; } $fields[ $key ]['value'] = $repeater_field_value; $labels[] = isset( $val['name'] ) ? $val['name'] : ( is_array( $val['value'] ) && isset( $val['value']['name'] ) ? $val['value']['name'] : '' ); } } $labels = array_unique( $labels ); $value = implode( ', ', array_filter( $labels ) ); $fields[ $column_id ]['value'] = $value; break; case 'likert': $form = evf()->form->get( $entry->form_id ); $form_data = evf_decode( $form->post_content ); $form_fields = $form_data['form_fields']; $form_field = ''; $selected_likert = array(); if ( array_key_exists( $column_id, $form_fields ) ) { $form_field = $form_fields[ $column_id ]; $likert_columns = $form_field['likert_columns']; $likert_rows = $form_field['likert_rows']; if ( ! empty( $fields[ $column_id ]['value_raw'] ) ) { foreach ( $fields[ $column_id ]['value_raw'] as $likert_key ) { $selected_likert[] = $likert_columns[ $likert_key ]; } } else { foreach ( $likert_rows as $likert_rows ) { $selected_likert[] = ''; } } } $value = $selected_likert; break; default: $value = apply_filters( 'everest_forms_html_field_value', $fields[ $column_id ]['value'], $fields[ $column_id ], $entry, 'export-csv' ); break; } } elseif ( is_callable( array( $this, "get_column_value_{$column_id}" ) ) ) { // Handle special columns which don't map 1:1 to entry data. $value = $this->{"get_column_value_{$column_id}"}( $entry ); $raw_value = $value; } $column_type = $this->get_entry_type( $column_id, $entry ); if ( is_array( $value ) && isset( $fields[ $column_id ], $fields[ $column_id ]['type'] ) && in_array( $fields[ $column_id ]['type'], array( 'likert' ), true ) ) { foreach ( $value as $key => $val ) { $key = $key + 1; $col_row_key = "$column_id-likert-$key"; $row[ $col_row_key ] = $val; } } else { // It is done to display the currencies symbol instead of its HTML entities values. $clean_value = html_entity_decode( preg_match( '/textarea/', $column_type ) ? sanitize_textarea_field( $value ) : sanitize_text_field( $value ), ENT_QUOTES, 'UTF-8' ); $row[ $column_id ] = apply_filters( 'everest_forms_format_csv_field_data', $clean_value, $raw_value, $column_id, $column_name, $columns, $entry ); } if ( empty( $this->request_data ) ) { $row['status'] = ( isset( $entry->meta['status'] ) && ! empty( $entry->meta['status'] ) ? $entry->meta['status'] : ( isset( $row['status'] ) ? $row['status'] : '' ) ); } } return apply_filters( 'everest_forms_entry_export_row_data', $row, $entry, $this->request_data ); } /** * Get entry type. * * @param string $column_id meta key of the column. * @param object $entry Entry being exported. * @return string */ protected function get_entry_type( $column_id, $entry ) { $fields = json_decode( $entry->fields, 1 ); if ( is_null( $fields ) || ! is_array( $fields ) ) { return false; // Conditional false with fake values. } foreach ( $fields as $field ) { if ( $column_id === $field['id'] ) { return $field['type']; } } return false; } /** * Get entry id value. * * @param object $entry Entry being exported. * @return int */ protected function get_column_value_entry_id( $entry ) { return absint( $entry->entry_id ); } /** * Get entry status value. * * @param object $entry Entry being exported. * @return string */ protected function get_column_value_status( $entry ) { $statuses = evf_get_entry_statuses(); if ( isset( $statuses[ $entry->status ] ) ) { return $statuses[ $entry->status ]; } return $entry->status; } /** * Get date created value. * * @param object $entry Entry being exported. * @return string */ protected function get_column_value_date_created( $entry ) { $timestamp = false; if ( isset( $entry->date_created ) ) { $timestamp = strtotime( $entry->date_created ); } /* translators: 1: entry date 2: entry time */ return sprintf( esc_html__( '%1$s %2$s', 'everest-forms' ), date_i18n( evf_date_format(), $timestamp ), date_i18n( evf_time_format(), $timestamp ) ); } /** * Get GMT date created value. * * @param object $entry Entry being exported. * @return string */ protected function get_column_value_date_created_gmt( $entry ) { $timestamp = false; if ( isset( $entry->date_created ) ) { $timestamp = strtotime( $entry->date_created ) + ( get_option( 'gmt_offset' ) * 3600 ); } /* translators: 1: entry date 2: entry time */ return sprintf( esc_html__( '%1$s %2$s', 'everest-forms' ), date_i18n( evf_date_format(), $timestamp ), date_i18n( evf_time_format(), $timestamp ) ); } /** * Get entry user device value. * * @param object $entry Entry being exported. * @return string */ protected function get_column_value_user_device( $entry ) { return sanitize_text_field( $entry->user_device ); } /** * Get entry user IP address value. * * @param object $entry Entry being exported. * @return string */ protected function get_column_value_user_ip_address( $entry ) { return sanitize_text_field( $entry->user_ip_address ); } }
Save
Cancel
