<?php

defined( 'ABSPATH' ) || exit;

if ( class_exists( 'AIEO_Pro_Question' ) ) {
	return;
}

class AIEO_Pro_Question {

	const TRANSIENT = 'aieo_pro_question_counts';

	
	public static function for_id( $id ) {
		$rows = self::rows();
		$id   = (string) $id;
		if ( ! isset( $rows[ $id ] ) ) {
			return '';
		}
		return self::fill( (string) $rows[ $id ] );
	}

	
	public static function rows() {
		static $memo = null;
		if ( null !== $memo ) {
			return $memo;
		}
		$memo = array();
		$file = defined( 'AIEO_DIR' ) ? AIEO_DIR . 'includes/dmm/data/pro-questions.php' : '';
		if ( '' !== $file && is_readable( $file ) ) {
			$rows = include $file;
			if ( is_array( $rows ) ) {
				$memo = $rows;
			}
		}
		
		$memo = (array) apply_filters( 'aieo_pro_questions', $memo );
		return $memo;
	}

	
	public static function fill( $s ) {
		$c = self::counts();
		return (string) preg_replace_callback(
			'/\s?\{(products|orders|customers|brands|categories|sessions)\}/',
			static function ( $m ) use ( $c ) {
				$n = isset( $c[ $m[1] ] ) ? (int) $c[ $m[1] ] : 0;
				return $n > 0 ? ' ' . number_format_i18n( $n ) : '';
			},
			$s
		);
	}

	
	public static function counts() {
		$hit = get_transient( self::TRANSIENT );
		if ( is_array( $hit ) && isset( $hit['products'] ) ) {
			return $hit;
		}
		global $wpdb;
		$out = array( 'products' => 0, 'orders' => 0, 'customers' => 0, 'brands' => 0, 'categories' => 0, 'sessions' => 0 );

		if ( post_type_exists( 'product' ) ) {
			$p = wp_count_posts( 'product' );
			$out['products'] = ( $p && isset( $p->publish ) ) ? (int) $p->publish : 0;
		}
		if ( function_exists( 'wc_orders_count' ) ) {
			$out['orders'] = (int) wc_orders_count( 'completed' );
		}
		$tax = taxonomy_exists( 'product_brand' ) ? 'product_brand' : ( taxonomy_exists( 'pwb-brand' ) ? 'pwb-brand' : '' );
		if ( '' !== $tax ) {
			$n = wp_count_terms( array( 'taxonomy' => $tax, 'hide_empty' => false ) );
			$out['brands'] = is_wp_error( $n ) ? 0 : (int) $n;
		}
		if ( taxonomy_exists( 'product_cat' ) ) {
			$n = wp_count_terms( array( 'taxonomy' => 'product_cat', 'hide_empty' => false ) );
			$out['categories'] = is_wp_error( $n ) ? 0 : (int) $n;
		}
		
		
		$out['customers'] = (int) $wpdb->get_var( $wpdb->prepare(
			"SELECT COUNT(*) FROM {$wpdb->usermeta} WHERE meta_key = %s AND meta_value LIKE %s",
			$wpdb->prefix . 'capabilities',
			'%' . $wpdb->esc_like( '"customer"' ) . '%'
		) );
		$t = $wpdb->prefix . 'aieo_sessions';
		if ( (string) $wpdb->get_var( $wpdb->prepare( 'SHOW TABLES LIKE %s', $t ) ) === $t ) {
			$out['sessions'] = (int) $wpdb->get_var( "SELECT COUNT(*) FROM {$t}" ); 
		}

		set_transient( self::TRANSIENT, $out, 10 * MINUTE_IN_SECONDS );
		return $out;
	}
}