<?php

namespace AdFuz\Controllers;

use AdFuz\Database\DB;
use AdFuz\Helpers\Common;
use AdFuz\Helpers\TableName;
use AdFuz\Models\AdSpaces;
use AdFuz\Models\Campaigns;
use AdFuz\Models\Ads;

if ( ! defined( 'ABSPATH' ) ) {
	exit;
}

class AdCacheController {

	private const GROUP        = 'ad-fuz';
	private const TTL_SPACE    = 300;
	private const TTL_CAMPAIGN = 60;

	public function __construct() {
	}

	// -------------------------------------------------------------------------
	// Ad Space — unchanged from before
	// -------------------------------------------------------------------------

	public function get_ad_space( int $id ): ?object {
		$cache_key     = "ad_space_{$id}";
		$transient_key = "adfuz_space_{$id}";

		$cached = wp_cache_get( $cache_key, self::GROUP );
		if ( false !== $cached ) {
			return $cached ?: null;
		}

		$cached = get_transient( $transient_key );
		if ( false !== $cached ) {
			wp_cache_set( $cache_key, $cached, self::GROUP );

			return $cached ?: null;
		}

		$row   = AdSpaces::findActiveById( $id );
		$value = $row ? (object) $row : false;

		wp_cache_set( $cache_key, $value, self::GROUP );
		set_transient( $transient_key, $value, self::TTL_SPACE );

		return $value ?: null;
	}

	public function bust_ad_space( int $id ): void {
		wp_cache_delete( "ad_space_{$id}", self::GROUP );
		delete_transient( "adfuz_space_{$id}" );
	}

	// -------------------------------------------------------------------------
	// Campaigns + Ads — now via Campaign::activeWithAdsBySpace()
	// -------------------------------------------------------------------------

	public function get_campaigns_with_ads( int $space_id ): array {
		$cache_key     = "campaigns_ads_{$space_id}";
		$transient_key = "adfuz_c_{$space_id}";

		// L1 — object cache
		$cached = wp_cache_get( $cache_key, self::GROUP );
		if ( false !== $cached ) {
			return $cached;
		}

		// L2 — persistent transient
		$cached = get_transient( $transient_key );
		if ( false !== $cached ) {
			wp_cache_set( $cache_key, $cached, self::GROUP );

			return $cached;
		}

		// DB — via Campaign model (filters active, date-valid, full ad fields)
		$result = Campaigns::activeWithAdsBySpace( $space_id );
		wp_cache_set( $cache_key, $result, self::GROUP );
		set_transient( $transient_key, $result, self::TTL_CAMPAIGN );

		return $result;
	}

	// AdCacheController.php
	public function get_campaigns_ad_count( int $space_id ): int {
		$campaigns_data = $this->get_campaigns_with_ads( $space_id );

		if ( empty( $campaigns_data ) ) {
			return 0;
		}

		$count = 0;
		foreach ( $campaigns_data as $entry ) {
			$count += count( $entry['ads'] );
		}

		return $count;
	}

	public function bust_campaigns( int $space_id ): void {
		wp_cache_delete( "campaigns_ads_{$space_id}", self::GROUP );
		delete_transient( "adfuz_c_{$space_id}" );
	}

	public function bust_campaigns_by_campaign( int $campaign_id ): void {
		$space_ids = DB::get( TableName::ADFUZ_CAMPAIGN_AD_SPACES() )
						->where( 'campaign_id', $campaign_id )
						->select( 'ad_space_id' )
						->get();
		$space_ids = array_column( $space_ids, 'ad_space_id' );
		foreach ( $space_ids as $space_id ) {
			$this->bust_campaigns( (int) $space_id );
		}
	}

	// -------------------------------------------------------------------------
	// Single Ad — now via Ads::findActive()
	// -------------------------------------------------------------------------

	public function get_ad( int $id ): ?array {
		$cache_key = "ad_{$id}";

		$cached = wp_cache_get( $cache_key, self::GROUP );
		if ( false !== $cached ) {
			return $cached ?: null;
		}

		$row   = Ads::findActive( $id );
		$value = $row ?: false;   // keep as array, not (object)

		wp_cache_set( $cache_key, $value, self::GROUP );

		return $value ?: null;
	}

	// -------------------------------------------------------------------------
	// Sequential Pointer — unchanged
	// -------------------------------------------------------------------------

	public function get_sequential_pointer( int $space_id ): int {
		return (int) get_transient( "adfuz_seq_{$space_id}" );
	}

	public function advance_sequential_pointer( int $space_id ): void {
		$current = $this->get_sequential_pointer( $space_id );
		set_transient( "adfuz_seq_{$space_id}", $current + 1, DAY_IN_SECONDS );
	}
}