<?php
namespace Strikewise\Admin;

use Strikewise\Calculator\Reference;
use Strikewise\Calculator\ReferenceService;
use Strikewise\History\Repository;

defined( 'ABSPATH' ) || exit;

/**
 * Key figures of the shop, shared by the overview page and the cockpit status.
 */
final class Stats {

	/**
	 * @return array{tracked:int,rows:int,reduced:int,without_prior:int}
	 */
	public static function collect(): array {
		global $wpdb;

		$table = Repository::table();

		// phpcs:disable WordPress.DB.DirectDatabaseQuery -- live counts for the admin overview and the cockpit status.
		// Reduced and without prior: only products that are still in the shop (not trashed or drafts).
		$stats = array(
			'tracked'       => (int) $wpdb->get_var( $wpdb->prepare( 'SELECT COUNT(DISTINCT product_id) FROM %i', $table ) ),
			'rows'          => (int) $wpdb->get_var( $wpdb->prepare( 'SELECT COUNT(*) FROM %i', $table ) ),
			'reduced'       => (int) $wpdb->get_var(
				$wpdb->prepare(
					"SELECT COUNT(*) FROM %i m INNER JOIN %i p ON p.ID = m.post_id AND p.post_status IN ( 'publish', 'private' ) WHERE m.meta_key = %s AND m.meta_value <> ''",
					$wpdb->postmeta,
					$wpdb->posts,
					Repository::META_T0
				)
			),
			'without_prior' => (int) $wpdb->get_var(
				$wpdb->prepare(
					"SELECT COUNT(*) FROM %i m INNER JOIN %i p ON p.ID = m.post_id AND p.post_status IN ( 'publish', 'private' ) WHERE m.meta_key = %s AND m.meta_value = %s",
					$wpdb->postmeta,
					$wpdb->posts,
					ReferenceService::META_STATUS,
					Reference::STATUS_NO_HISTORY
				)
			),
		);
		// phpcs:enable

		return $stats;
	}
}