<?php

namespace WPDeveloper\BetterDocsPro\Core;

use WPDeveloper\BetterDocs\Utils\Base;
use WPDeveloper\BetterDocs\Utils\CSSGenerator;
use WPDeveloper\BetterDocs\Utils\Helper;


class Glossaries extends Base
{
    public $settings;

    public function __construct()
    {

        $enable_glossaries = betterdocs()->settings->get('enable_glossaries', false);

        if ($enable_glossaries && isset($_GET['page']) && $_GET['page'] === 'betterdocs-glossaries') { // phpcs:ignore WordPress.Security.NonceVerification.Recommended
            $this->store_glossary_count();
        }
    }


    public function store_glossary_count()
    {
        global $wpdb;

        // phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- intentional custom taxonomy/glossary aggregation query.
        $glossaries = $wpdb->get_results(
            $wpdb->prepare(
                "SELECT t.term_id, t.name, t.slug
                FROM {$wpdb->terms} t
                INNER JOIN {$wpdb->term_taxonomy} tt ON t.term_id = tt.term_id
                WHERE tt.taxonomy = %s",
                'glossaries'
            ),
            ARRAY_A
        );
        // phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching

        if (!is_array($glossaries)) {
            update_option('store_glossary_count', false);
        } else {
            $glossaryCounts = array();

            // phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- intentional custom query to scan docs content for glossary terms.
            $posts = $wpdb->get_results(
                $wpdb->prepare(
                    "SELECT ID, post_title, post_content
                    FROM {$wpdb->posts}
                    WHERE post_type = %s
                    AND post_status = %s",
                    'docs',
                    'publish'
                ),
                ARRAY_A
            );
            // phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
            $glossaryCounts = array();
    
            foreach ($posts as $post) {
                
                $postId = $post['ID'];
                $postTitle = $post['post_title'];
                $permalink = get_the_permalink( $postId);
                $content = $post['post_content'];
    
                foreach ($glossaries as $glossary) {
                    $name = !empty($glossary['name']) ? $glossary['name'] : '';
                
                    // Skip if $name is empty to avoid regex issues
                    if (empty($name)) {
                        continue;
                    }
                
                    // Remove all 'alt' attribute text to exclude them from the match count
                    $contentWithoutAlt = preg_replace('/alt="[^"]*"/i', '', $content);
                
                    // Count occurrences of the term in $contentWithoutAlt
                    $count = preg_match_all('/\b' . preg_quote($name, '/') . '\b/i', $contentWithoutAlt, $matches);
                
                    if ($count > 0) {
                        if (!isset($glossaryCounts[$name])) {
                            $glossaryCounts[$name] = array();
                        }
                
                        $glossaryCounts[$name][] = array(
                            'post_title' => $postTitle,
                            'permalink' => $permalink,
                            'count' => $count
                        );
                    }
                }
                
            }
    
            update_option('store_glossary_count', $glossaryCounts);
        }
    }
    
}