<?php
/**
 * Storage for campaign categories, e.g. "Winter sale", which group campaigns in the dashboard.
 *
 * @package CNWS\Coupons
 */

namespace CNWS\Coupons;

defined( 'ABSPATH' ) || exit;

// phpcs:disable WordPress.DB.DirectDatabaseQuery -- Plugin-owned table, named through the %i placeholder.

final class CategoryRepository {

	/**
	 * The category with this name, created when it does not exist.
	 *
	 * @param string $name Category name.
	 * @return int Category ID, or 0 for an empty name.
	 */
	public function find_or_create( string $name ): int {
		global $wpdb;

		$name = substr( sanitize_text_field( $name ), 0, 190 );
		$slug = substr( sanitize_title( $name ), 0, 100 );

		if ( '' === $slug ) {
			return 0;
		}

		$table = Tables::categories();
		$id    = (int) $wpdb->get_var( $wpdb->prepare( 'SELECT id FROM %i WHERE slug = %s', $table, $slug ) );

		if ( $id ) {
			return $id;
		}

		$wpdb->insert(
			$table,
			array(
				'slug'       => $slug,
				'name'       => $name,
				'created_at' => current_time( 'mysql', true ),
			)
		);

		return (int) $wpdb->insert_id;
	}

	/**
	 * @return array<int, string> ID => name, alphabetical.
	 */
	public function all(): array {
		global $wpdb;

		$rows = (array) $wpdb->get_results( $wpdb->prepare( 'SELECT id, name FROM %i ORDER BY name', Tables::categories() ) );
		$list = array();

		foreach ( $rows as $row ) {
			$list[ (int) $row->id ] = (string) $row->name;
		}

		return $list;
	}
}