<?php

namespace PWH_DCFH\App\Admin\Pages;

use WP_Query;

if (!defined('ABSPATH')) {
    exit;
}
if (!class_exists('PWH_DCFH_Export_CSV')) {
    class PWH_DCFH_Export_CSV
    {
        private $_post_type;

        private $contact_form_data;

        /**
         * Initializer Of The Class
         * Add/Remove Necessary Actions/Filters
         */
        public function init()
        {
            $this->_post_type = 'pwh_dcfh';
            $_page = isset($_GET['page']) ? sanitize_key($_GET['page']) : null; // phpcs:ignore
            add_action('admin_menu', [$this, 'menu']);
            if ('export_as_csv' === $_page) {
                $this->contact_form_data = pwh_dcfh_db()::get_contact_form_csv_data();
                add_action('admin_init', function () {
                    ob_start();
                });
                add_action('view_export_as_csv', [$this, 'display_form'], 10, 1);
                add_filter('pwh_dcfh_f_admin_localizations', [$this, 'load_csv_data']);
            }
        }

        /**
         * Register Wp Admin Menu
         */
        public function menu()
        {
            add_submenu_page('edit.php?post_type=pwh_dcfh', __('Export CSV', 'pwh-dcfh'), __('Export CSV', 'pwh-dcfh'), 'export_csv_pwh_dcfh', 'export_as_csv', [$this, 'process_form']);
        }

        /**
         * Filter Admin Localizations
         *
         * @param $localizations
         *
         * @return array
         */
        public function load_csv_data($localizations)
        {
            $localizations['csvData'] = htmlentities(wp_json_encode($this->contact_form_data));
            $localizations['dataPicker'] = ['status' => true, 'format' => 'yy-mm-dd'];

            return $localizations;
        }

        /**
         * Process Form Actions
         */
        public function process_form()
        {
            $contact_form_id = isset($_GET['contact_form_id']) ? sanitize_text_field($_GET['contact_form_id']) : null; // phpcs:ignore
            $post_request = [
                'contact_form_id' => $contact_form_id,
                'contact_form_fields' => '',
                'file_name' => '',
                'start_date' => '',
                'end_date' => '',
            ];
            if (isset($_POST['btn_export_as_csv'], $_POST['_wpnonce'])) {
                $_wpnonce = sanitize_text_field($_POST['_wpnonce']);
                if (!wp_verify_nonce($_wpnonce, 'action_export_as_csv')) {
                    wp_die(esc_html__('Unable to submit this form, please refresh and try again.', 'pwh-dcfh'));
                }
                // $blog_charset = get_bloginfo('charset');
                $blog_charset = 'utf-8';
                $validate_request = true;
                $wp_count_posts = wp_count_posts($this->_post_type);
                $total_posts = (int)($wp_count_posts->draft + $wp_count_posts->private);
                if ($total_posts === 0) {
                    pwh_dcfh_admin_notice()::add_error_message(__('No record found.', 'pwh-dcfh'));
                    $validate_request = false;
                }
                $file_name = isset($_POST['file_name']) ? sanitize_file_name($_POST['file_name']) : null;
                $contact_form_id = isset($_POST['contact_form_id']) ? sanitize_text_field($_POST['contact_form_id']) : null;
                $contact_form_fields = $_POST['contact_form_fields'] ?? null;                  // phpcs:ignore
                $start_date = $_POST['start_date'] ?? null;                                             // phpcs:ignore
                $end_date = $_POST['end_date'] ?? null;                                                   // phpcs:ignore
                $entries_type = $_POST['entries_type'] ?? null;                                       // phpcs:ignore
                if (empty($file_name)) {
                    pwh_dcfh_admin_notice()::add_error_message(__('Please enter csv file name.', 'pwh-dcfh'));
                    $validate_request = false;
                }
                if (empty($contact_form_id)) {
                    pwh_dcfh_admin_notice()::add_error_message(__('Please select form type.', 'pwh-dcfh'));
                    $validate_request = false;
                }
                if (empty($contact_form_fields)) {
                    pwh_dcfh_admin_notice()::add_error_message(__('Please select at least one keyword.', 'pwh-dcfh'));
                    $validate_request = false;
                }
                if (empty($entries_type)) {
                    pwh_dcfh_admin_notice()::add_error_message(__('Please select at least entries type to export.', 'pwh-dcfh'));
                    $validate_request = false;
                }
                $post_request = $_POST;
                if ($validate_request) {
                    $wp_upload_dir = wp_upload_dir();
                    $csv_headers = array_values($contact_form_fields);
                    $date_query = [];
                    if (!empty($start_date) || !empty($end_date)) {
                        $date_query['after'] = $start_date;
                        $date_query['before'] = $end_date;
                        $date_query['inclusive'] = true;
                    }
                    $found_posts_obj = new WP_Query([
                        'post_type' => 'pwh_dcfh',
                        'post_status' => $entries_type,
                        'meta_key' => '_pwh_dcfh_contact_form_id',// phpcs:ignore
                        'meta_value' => $contact_form_id,// phpcs:ignore
                        'date_query' => $date_query
                    ]);
                    $total_posts = $found_posts_obj->found_posts;
                    $posts_per_page = 200;
                    header("Content-Encoding: $blog_charset");
                    header("Content-type: text/csv; charset=$blog_charset");
                    header("Content-Disposition: attachment; filename=$file_name.csv");
                    header("Pragma: no-cache");
                    header("Expires: 0");
                    $f_handle = fopen("php://output", 'wb');
                    if (ob_get_length() > 0) {
                        ob_clean();
                    }
                    fputs($f_handle, $bom = (chr(0xEF).chr(0xBB).chr(0xBF)));
                    fputcsv($f_handle, $csv_headers, ',', '"');
                    for ($i = 0; $i < $total_posts; $i += $posts_per_page) {
                        $post_obj = new WP_Query([
                            'post_type' => 'pwh_dcfh',
                            'post_status' => $entries_type,
                            'posts_per_page' => $posts_per_page,
                            'offset' => $i,
                            'meta_key' => '_pwh_dcfh_contact_form_id',// phpcs:ignore
                            'meta_value' => $contact_form_id,// phpcs:ignore
                            'date_query' => $date_query
                        ]);
                        $csv_data = [];
                        $counter = 0;
                        for ($k = 0; $k < $post_obj->found_posts; $k++) {
                            $posts = $post_obj->posts;
                            if (isset($posts[$k]->ID)) {
                                $post_id = $posts[$k]->ID;
                                $post_excerpt = $posts[$k]->post_excerpt;
                                if (is_serialized($post_excerpt)) {
                                    $page_id = pwh_dcfh_post_meta_handler()::get_page_id_meta_value($post_id);
                                    $form_entries = pwh_dcfh_helpers()::maybe_unserialize($post_excerpt);
                                    if (!empty($form_entries) && is_array($form_entries)) {
                                        foreach ($form_entries as $form_entry) {
                                            $field_id = pwh_dcfh_helpers()::sanitize_key($form_entry['id']);
                                            $csv_data[$counter][$field_id] = $form_entry;
                                        }
                                        foreach (array_keys($contact_form_fields) as $field) {
                                            if ('entry_number' === $field) {
                                                $csv_data[$counter]['entry_number'] = [
                                                    'type' => 'meta',
                                                    'value' => $post_id,
                                                ];
                                            }
                                            if ('read_by' === $field) {
                                                if ('0000-00-00 00:00:00' !== $posts[$k]->post_modified) {
                                                    $csv_data[$counter]['read_by'] = [
                                                        'type' => 'meta',
                                                        'value' => pwh_dcfh_wp_helpers()::get_author_name(pwh_dcfh_post_meta_handler()::get_read_by_meta_value($post_id)),
                                                    ];
                                                } else {
                                                    $csv_data[$counter]['read_by'] = [
                                                        'type' => 'meta',
                                                        'value' => '-',
                                                    ];
                                                }
                                            }
                                            if ('submitter' === $field) {
                                                $csv_data[$counter]['submitter'] = [
                                                    'type' => 'meta',
                                                    'value' => pwh_dcfh_wp_helpers()::get_submitter_name($posts[$k]->post_author),
                                                ];
                                            }
                                            if ('page_title' === $field) {
                                                $csv_data[$counter]['page_title'] = [
                                                    'type' => 'meta',
                                                    'value' => get_the_title($page_id),
                                                ];
                                            }
                                            if ('page_url' === $field) {
                                                $csv_data[$counter]['page_url'] = [
                                                    'type' => 'meta',
                                                    'value' => get_the_permalink($page_id),
                                                ];
                                            }
                                            if ('date' === $field) {
                                                $csv_data[$counter]['date'] = [
                                                    'type' => 'meta',
                                                    'value' => $posts[$k]->post_date,
                                                ];
                                            }
                                            if ('ip_address' === $field) {
                                                $ip_address = pwh_dcfh_post_meta_handler()::get_ip_address_meta_value($post_id);
                                                $csv_data[$counter]['ip_address'] = [
                                                    'type' => 'meta',
                                                    'value' => '' === $ip_address ? '-' : $ip_address,
                                                ];
                                            }
                                            if ('browser' === $field || 'platform' === $field) {
                                                $user_agent_meta = pwh_dcfh_post_meta_handler()::get_user_agent_meta_value($post_id);
                                                if ('browser' === $field) {
                                                    $csv_data[$counter]['browser'] = [
                                                        'type' => 'meta',
                                                        'value' => isset($user_agent_meta['browser']) ? ucfirst($user_agent_meta['browser']) : '-',
                                                    ];
                                                }
                                                if ('platform' === $field) {
                                                    $csv_data[$counter]['platform'] = [
                                                        'type' => 'meta',
                                                        'value' => isset($user_agent_meta['platform']) ? ucfirst($user_agent_meta['platform']) : '-',
                                                    ];
                                                }
                                            }
                                        }
                                        $counter++;
                                    }
                                }
                            }
                        }
                        if (!empty($csv_data)) {
                            foreach ($csv_data as $k => $v) {
                                $csv_rows = [];
                                foreach (array_keys($contact_form_fields) as $field) {
                                    if (isset($csv_data[$k][$field])) {
                                        $form_data = $csv_data[$k][$field];
                                        $wp_subdir = $csv_data[$k][$field]['subdir'] ?? '';
                                        $wp_basedir = rtrim($wp_upload_dir['basedir'], '/').'/'.$wp_subdir;
                                        $wp_baseurl = rtrim($wp_upload_dir['baseurl'], '/').'/'.$wp_subdir;
                                        if ('file' === $form_data['type'] || 'signature_pad' === $form_data['type']) {
                                            $attachments = explode(',', $form_data['value']);
                                            $attachments = array_filter($attachments);
                                            if (!empty($attachments)) {
                                                $attachments_list = [];
                                                foreach ($attachments as $attachment) {
                                                    if (isset($form_data['is_media_library']) && $form_data['is_media_library']) {
                                                        $upload_dir = path_join($wp_basedir, $attachment);
                                                        $upload_url = path_join($wp_baseurl, $attachment);
                                                    } else {
                                                        $upload_dir = pwh_dcfh_file_helpers()::get_form_upload_dir($contact_form_id, $wp_subdir, $attachment);
                                                        $upload_url = pwh_dcfh_file_helpers()::get_form_upload_url($contact_form_id, $wp_subdir, $attachment);
                                                    }
                                                    if (et_()->WPFS()->is_file($upload_dir) && et_()->WPFS()->exists($upload_dir)) {
                                                        $attachments_list[] = $upload_url;
                                                    }
                                                }
                                                $csv_rows[] = implode(',', $attachments_list);
                                            } else {
                                                $csv_rows[] = '-';
                                            }
                                        } else {
                                            $csv_rows[] = '' !== $form_data['value'] ? $form_data['value'] : '-';
                                        }
                                    } else {
                                        $csv_rows[] = '-';
                                    }
                                }
                                fputcsv($f_handle, $csv_rows, ',', '"');
                            }
                        }
                    }
                    $csv_footer[]['path'] = "\n\n";
                    $csv_footer[]['path'] = sprintf(__('Total Entries: %s', 'pwh-dcfh'), $total_posts);
                    if (!empty($start_date)) {
                        $csv_footer[]['path'] = sprintf(__('Start Date: %s', 'pwh-dcfh'), date_i18n("F j, Y", strtotime($start_date)));
                    }
                    if (!empty($end_date)) {
                        $csv_footer[]['path'] = sprintf(__('End Date: %s', 'pwh-dcfh'), date_i18n("F j, Y", strtotime($end_date)));
                    }
                    $csv_footer[]['path'] = sprintf(__('Generated on: %s', 'pwh-dcfh'), date_i18n("F j, Y, g:i a"));
                    $csv_footer[]['path'] = sprintf(__('Generated By: %s', 'pwh-dcfh'), ucwords(pwh_dcfh_wp_helpers()::get_author_name()));
                    foreach ($csv_footer as $footer) {
                        fputcsv($f_handle, $footer, ',', '"');
                    }
                    if (ob_get_length() > 0) {
                        ob_flush();
                    }
                    fclose($f_handle); // phpcs:ignore
                    exit;
                }
            }
            do_action('view_export_as_csv', $post_request);
        }

        /**
         * Display Form HTML Content
         *
         * @param $post_request
         */
        public function display_form($post_request)
        {
            $contact_forms_data = $this->contact_form_data; ?>
            <div class="wrap pwh-dcfh-page" id="page-export-as-csv">
                <h1 class="wp-heading-inline"><?php esc_html_e(get_admin_page_title(), 'pwh-dcfh'); ?></h1>
                <hr class="wp-header-end">
                <?php pwh_dcfh_admin_notice()::show_admin_notice(); ?>
                <span class="spinner"></span>
                <div id="poststuff">
                    <div id="post-body" class="metabox-holder columns-2">
                        <div class="postbox-container">
                            <div class="postbox">
                                <div class="inside">
                                    <form method="POST" autocomplete="off" enctype="application/x-www-form-urlencoded">
                                        <table class="form-table">
                                            <tbody>
                                            <tr>
                                                <td colspan="3" class="text-right">
                                                    <b><?php esc_html_e('Total Entries:', 'pwh-dcfh'); ?></b><span></span>
                                                </td>
                                            </tr>
                                            <tr>
                                                <th><?php esc_html_e('CSV File Name:', 'pwh-dcfh'); ?>
                                                    <span class="required">*</span></th>
                                                <td colspan="3">
                                                    <input title="" type="text" name="file_name" id="file_name" class="form-control" value="<?php echo esc_html($post_request['file_name']); ?>" placeholder="<?php esc_html_e('CSV File Name', 'pwh-dcfh'); ?>" required>
                                                    <p class="helper"><?php esc_html_e('Enter csv file name.', 'pwh-dcfh'); ?></p>
                                                </td>
                                            </tr>
                                            <tr>
                                                <th><?php esc_html_e('Contact Form:', 'pwh-dcfh'); ?>
                                                    <span class="required">*</span></th>
                                                <td colspan="3">
                                                    <select title="" name="contact_form_id" id="contact_form_id" class="form-control" required>
                                                        <option value=""><?php esc_html_e('Select Contact Form', 'pwh-dcfh'); ?></option>
                                                        <?php if (!empty($contact_forms_data)) {
                                                            foreach ($contact_forms_data as $key => $value) { ?>
                                                                <option value="<?php echo esc_html($key); ?>" <?php selected($key, $post_request['contact_form_id']); ?>><?php echo esc_html($value['contact_form_title']); ?></option>
                                                            <?php }
                                                        } ?>
                                                    </select>
                                                    <p class="helper"><?php esc_html_e('Choose contact form.', 'pwh-dcfh'); ?>
                                                    </p>
                                                </td>
                                            </tr>
                                            <tr>
                                                <th><?php esc_html_e('Contact Form Fields:', 'pwh-dcfh'); ?>
                                                    <span class="required">*</span></th>
                                                <td colspan="3">
                                                    <div class="merge-data-tags-list"></div>
                                                    <p class="helper"><?php esc_html_e('Choose contact form fields to export.', 'pwh-dcfh'); ?></p>
                                                </td>
                                            </tr>
                                            <tr>
                                                <th><?php esc_html_e('Start and End Date:', 'pwh-dcfh'); ?></th>
                                                <td>
                                                    <input title="" type="text" name="start_date" id="start_date" class="form-control jquery_ui_datepicker" value="<?php echo esc_html($post_request['start_date']); ?>" placeholder="<?php esc_html_e('Start Date', 'pwh-dcfh'); ?>">
                                                    <p class="helper"><?php esc_html_e('Select start date.', 'pwh-dcfh'); ?></p>
                                                </td>
                                                <td>
                                                    <input title="" type="text" name="end_date" id="end_date" class="form-control jquery_ui_datepicker" value="<?php echo esc_html($post_request['end_date']); ?>" placeholder="<?php esc_html_e('End Date', 'pwh-dcfh'); ?>">
                                                    <p class="helper"><?php esc_html_e('Select end date.', 'pwh-dcfh'); ?></p>
                                                </td>
                                            </tr>
                                            <tr>
                                                <th><?php esc_html_e('Include:', 'pwh-dcfh'); ?>
                                                    <span class="required">*</span></th>
                                                <td colspan="3">
                                                    <?php
                                                    $checkboxes = [
                                                        'private' => 'Read',
                                                        'draft' => 'Unread',
                                                        'spam' => 'Spam',
                                                        'trash' => 'Trash'
                                                    ];
                                                    ?>
                                                    <?php foreach ($checkboxes as $value => $label) {
                                                        $checked = ($value === 'private' || $value === 'draft') ? 'checked' : '';
                                                        ?>
                                                        <label class="bulk-select-button" for="<?php echo esc_attr($value); ?>">
                                                            <input type="checkbox" id="<?php echo esc_attr($value); ?>" name="entries_type[]" class="bulk-select-switcher" value="<?php echo esc_attr($value); ?>" <?php echo esc_attr($checked); ?>>
                                                            <span class="bulk-select-button-label"><?php echo esc_html__($label, 'pwh-dcfh'); ?></span>
                                                        </label>
                                                    <?php } ?>
                                                    <p class="helper"><?php esc_html_e('Choose entries to export.', 'pwh-dcfh'); ?></p>
                                                </td>
                                            </tr>
                                            </tbody>
                                        </table>
                                        <?php
                                        wp_nonce_field('action_export_as_csv', '_wpnonce');
                                        submit_button(esc_html__('Export CSV', 'pwh-dcfh'), 'primary large', 'btn_export_as_csv');
                                        ?>
                                    </form>
                                </div>
                            </div>
                        </div>
                        <div id="postbox-container-1" class="postbox-container">
                            <?php
                            require_once dirname(__DIR__)."/template/documentation-widget.php";
                            require_once dirname(__DIR__)."/template/support-widget.php";
                            ?>
                        </div>
                    </div>
                    <br class="clear">
                </div>
            </div>
            <?php
        }

    }
}