<?php

namespace FluentCrm\App\Services;

use FluentCrm\App\Models\Funnel;
use FluentCrm\App\Models\Campaign;
use FluentCrm\App\Models\Tag;
use FluentCrm\App\Models\Template;
use FluentCrm\App\Models\Subscriber;
use FluentCrm\App\Models\CampaignEmail;

class Stats
{
    public function getCounts()
    {
        // These COUNT(*)s scan millions of rows on large sites and the dashboard runs
        // them on every load — cache the raw numbers for 5 minutes. Titles/routes are
        // built per-request so translations always match the viewer's locale.
        $counts = fluentCrmGetFromCache('dashboard_stat_counts', function () {
            return [
                'total_subscribers' => Subscriber::where('status', 'subscribed')->count(),
                'total_campaigns'   => Campaign::count(),
                'email_sent'        => CampaignEmail::where('status', 'sent')->count(),
                'total_automations' => Funnel::where('status', 'published')->count(),
                'email_pending'     => CampaignEmail::whereIn('status', ['pending', 'scheduled', 'processing'])->count()
            ];
        }, 300);

        $data = [
            'total_subscribers' => [
                'title' => __('Active Contacts', 'fluent-crm'),
                'count' => $counts['total_subscribers'],
                'route' => [
                    'name' => 'subscribers'
                ]
            ],
            'total_campaigns'   => [
                'title' => __('Campaigns', 'fluent-crm'),
                'count' => $counts['total_campaigns'],
                'route' => [
                    'name' => 'campaigns'
                ]
            ],
            'email_sent'        => [
                'title' => __('Emails Sent', 'fluent-crm'),
                'count' => $counts['email_sent'],
                'route' => [
                    'name' => 'all_emails'
                ]
            ],
            'total_automations'   => [
                'title' => __('Active Automations', 'fluent-crm'),
                'count' => $counts['total_automations'],
                'route' => [
                    'name' => 'funnels'
                ]
            ]
        ];

        $pendingEmails = $counts['email_pending'];

        if ($pendingEmails) {
            $data['email_pending'] = [
                'title' => __('Pending Emails', 'fluent-crm'),
                'count' => $pendingEmails,
                'route' => [
                    'name' => 'campaigns'
                ]
            ];
        }

        /**
         * Filter the dashboard statistics data.
         *
         * This filter allows modification of the dashboard statistics data before it is returned.
         *
         * @since 2.7.0
         *
         * @param array $data The dashboard statistics data.
         */
        return apply_filters('fluent_crm/dashboard_stats', $data);
    }

    public function getQuickLinks()
    {
        $urlBase = fluentcrm_menu_url_base();

        $quickLinks = [
            [
                'title' => __('Contact Segments', 'fluent-crm'),
                'url'   => $urlBase . 'contact-groups/lists',
                'icon'  => 'ContactSegments'
            ],
            [
                'title' => __('Recurring Campaigns', 'fluent-crm'),
                'url'   => $urlBase . 'email/recurring-campaigns',
                'icon'  => 'RecurringCampaigns'
            ],
            [
                'title' => __('Email Sequences', 'fluent-crm'),
                'url'   => $urlBase . 'email/sequences',
                'icon'  => 'EmailSequences'
            ],
            [
                'title' => __('MCP for AI Agents', 'fluent-crm'),
                'url'   => $urlBase . 'settings/mcp_settings',
                'icon'  => 'el-icon-connection'
            ],
            [
                'title' => __('Documentations', 'fluent-crm'),
                'url'   =>  $urlBase . 'documentation',
                'icon'  => 'Documentations'
            ],
            [
                'title' => __('Video Tutorials (Free)', 'fluent-crm'),
                'url' => 'https://www.youtube.com/playlist?list=PLXpD0vT4thWG-ZPeM6cco7BS5cJY9bTjL',
                'icon' => 'VideoTutorials',
                'is_external' => true
            ]
        ];

        /**
         * Filter the quick links in FluentCRM.
         *
         * This filter allows modification of the quick links array in FluentCRM.
         *
         * @since 2.7.1
         *
         * @param array $quickLinks An array of quick links.
         */
        return apply_filters('fluent_crm/quick_links', $quickLinks);
    }

    public function getOnboardingStat()
    {

        $formCreated = false;
        if(defined('FLUENTFORM')) {
            $firstFeed = fluentCrmDb()->table('fluentform_form_meta')
                ->where('meta_key', 'fluentcrm_feeds')
                ->first();
            $formCreated = !!$firstFeed;
            if(!$formCreated) {
                $formCreated = !!Funnel::where('trigger_name', 'fluentform_submission_inserted')->first();
            }
        }

        if (fluentcrm_get_option('onboarding_status') == 'yes' && $formCreated) {
            return null;
        }

        $boardingSteps = [
            [
                'label'     => __('Create a Tag', 'fluent-crm'),
                'completed' => !!Tag::first(),
                'route'     => [
                    'name' => 'tags'
                ]
            ],
            [
                'label'     => __('Import Contacts', 'fluent-crm'),
                'completed' => !!Subscriber::first(),
                'route'     => [
                    'name' => 'subscribers'
                ]
            ],
            [
                'label'     => __('Create a Campaign', 'fluent-crm'),
                'completed' => !!Campaign::first(),
                'route'     => [
                    'name' => 'campaigns'
                ]
            ],
            [
                'label'     => __('Create an Automation', 'fluent-crm'),
                'completed' => !!Funnel::first(),
                'route'     => [
                    'name' => 'funnels'
                ]
            ],
            [
                'label'     => __('Create a Form', 'fluent-crm'),
                'completed' => $formCreated,
                'route'     => [
                    'name' => 'forms'
                ]
            ]
        ];

        $completed = 0;
        $total = count($boardingSteps);

        foreach ($boardingSteps as $step) {
            if($step['completed']) {
                $completed++;
            }
        }

        if($completed == $total) {
            fluentcrm_update_option('onboarding_status', 'yes');
            return null;
        }

        return [
            'total'     => $total,
            'completed' => $completed,
            'steps'     => $boardingSteps
        ];
    }

    public function getRecentContacts($limit = 5)
    {
        return Subscriber::where('status', 'subscribed')
            ->orderBy('created_at', 'DESC')
            ->limit($limit)
            ->get();
    }

    public function getActiveAutomations($limit = 5)
    {
        return Funnel::where('status', 'published')
            ->orderBy('created_at', 'DESC')
            ->limit($limit)
            ->get();
    }

    public function getRecentCampaigns($limit = 5)
    {
        $campaigns = Campaign::where('status', 'archived')
            ->orderBy('created_at', 'DESC')
            ->limit($limit)
            ->get();

        foreach ($campaigns as $campaign) {
            $campaign->stats = $campaign->stats();
        }

        return $campaigns;
    }
}
