<?php

namespace WP_STATISTICS;

class Export
{

    /**
     * Setup an Export Report Class
     */
    public function __construct()
    {

        //Export Data
        add_action('admin_init', array($this, 'export_data'), 9);
    }

    /**
     * Set the headers to download the export file and then stop running WordPress.
     */
    public function export_data()
    {
        if (isset($_POST['wps_export'])) {
            global $wpdb;

            //Set Time Limit Script Run
            set_time_limit(0);

            //Check Wp Nonce and Require Field
            if (!isset($_POST['table-to-export']) || !isset($_POST['export-file-type']) || !isset($_POST['wps_export_file']) || !wp_verify_nonce($_POST['wps_export_file'], 'wp_statistics_export_nonce')) {
                exit;
            }

            // Load Library
            if (!class_exists('\ExportData')) {
                include(WP_STATISTICS_DIR . "includes/libraries/ExportData.php");
            }

            //Check Current User Capability
            if (User::Access('manage')) {
                $table = sanitize_text_field($_POST['table-to-export']);
                $type  = sanitize_text_field($_POST['export-file-type']);

                // Validate the table name the user passed to us.
                if (!in_array($table, DB::$db_table)) {
                    $table = false;
                }

                // Validate the file type the user passed to us.
                if (!($type == "xml" || $type == "csv" || $type == "tsv")) {
                    $table = false;
                }

                if ($table && $type) {
                    $file_name = 'wp-statistics' . '-' . TimeZone::getCurrentDate('Y-m-d-H-i');

                    switch ($type) {
                        case 'xml':
                            $exporter = new \ExportDataExcel('browser', "{$file_name}.xml");
                            break;
                        case 'csv':
                            $exporter = new \ExportDataCSV('browser', "{$file_name}.csv");
                            break;
                        case 'tsv':
                            $exporter = new \ExportDataTSV('browser', "{$file_name}.tsv");
                            break;
                    }

                    $exporter->initialize();

                    /**
                     * We need to limit the number of results we retrieve to ensure we don't run out of memory, also allow to modify the base query
                     */
                    $query_base = "SELECT * FROM " . DB::table($table);

                    /**
                     * Allow to modify the query
                     */
                    $query = $query_base . ' LIMIT 0,1000';

                    $i            = 1;
                    $more_results = true;
                    $result       = $wpdb->get_results($query, ARRAY_A); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared

                    // If we didn't get any rows, don't output anything.
                    if (count($result) < 1) {
                        echo "No data in table!"; // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped
                        exit;
                    }

                    if (isset($_POST['export-headers']) and $_POST['export-headers']) {
                        foreach ($result[0] as $key => $col) {
                            $columns[] = $key;
                        }
                        $exporter->addRow($columns);
                    }

                    while ($more_results) {
                        foreach ($result as $row) {
                            $exporter->addRow($row);

                            // Make sure we've flushed the output buffer so we don't run out of memory on large exports.
                            ob_flush();
                            flush();
                        }

                        unset($result);
                        $wpdb->flush();

                        $query  = $query_base . ' LIMIT ' . ($i * 1000) . ',1000';
                        $result = $wpdb->get_results($query, ARRAY_A); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared

                        if (count($result) == 0) {
                            $more_results = false;
                        }

                        $i++;
                    }

                    $exporter->finalize();
                    exit;
                }
            }
        }
    }

}

new Export;