<?php
/**
 * Booking statuses repository.
 *
 * @package Abientot
 */

namespace Abientot\Repositories;

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

final class StatusesRepository extends BaseRepository {
	protected string $table_suffix = 'booking_statuses';

	public function find_by_slug( string $slug ): ?array {
		return $this->find_by( 'slug', $slug );
	}

	/**
	 * Returns statuses ordered for admin selectors.
	 *
	 * @return array<int,array<string,mixed>>
	 */
	public function ordered(): array {
		global $wpdb;

		$rows = $wpdb->get_results( "SELECT * FROM {$wpdb->prefix}abientot_booking_statuses ORDER BY sort_order ASC, label ASC", ARRAY_A );

		return is_array( $rows ) ? $rows : array();
	}
}