<?php
/**
 * Sitemap-Provider für das Suchtberatungs-Verzeichnis.
 * Speist Bundesland-, Stadt- und Einzelstellen-URLs in die wp-sitemap.xml ein.
 *
 * @package drogentest-online
 */

if ( ! defined( 'ABSPATH' ) || ! class_exists( 'WP_Sitemaps_Provider' ) ) {
	return;
}

class DGT_SB_Sitemap_Provider extends WP_Sitemaps_Provider {

	public function __construct() {
		$this->name        = 'suchtberatung';
		$this->object_type = 'suchtberatung';
	}

	/** Alle URLs (gecacht innerhalb des Requests). */
	private function all_urls() {
		static $urls = null;
		if ( null !== $urls ) {
			return $urls;
		}
		global $wpdb;
		$urls = array();

		// Bundesland-Übersichtsseiten.
		foreach ( dgt_sb_bundeslaender() as $slug => $name ) {
			$urls[] = array( 'loc' => dgt_sb_bundesland_url( $slug ) );
		}

		// Einzelne Beratungsstellen (Bundesland aus PLZ abgeleitet).
		$c    = dgt_sb_table();
		$a    = dgt_sb_table( 'address' );
		$rows = $wpdb->get_results( "SELECT c.slug, a.zipcode FROM {$c} c JOIN {$a} a ON a.entry_id = c.id WHERE c.status='approved' AND c.visibility='public' AND c.slug <> '' GROUP BY c.id", ARRAY_A ); // phpcs:ignore
		foreach ( (array) $rows as $r ) {
			$bl = dgt_sb_bundesland_from_plz( $r['zipcode'] );
			$urls[] = array( 'loc' => dgt_sb_single_url( $r['slug'], $bl ) );
		}
		return $urls;
	}

	public function get_url_list( $page_num, $object_subtype = '' ) {
		$per    = wp_sitemaps_get_max_urls( $this->object_type );
		$offset = ( max( 1, (int) $page_num ) - 1 ) * $per;
		return array_slice( $this->all_urls(), $offset, $per );
	}

	public function get_max_num_pages( $object_subtype = '' ) {
		$per = wp_sitemaps_get_max_urls( $this->object_type );
		return (int) max( 1, ceil( count( $this->all_urls() ) / $per ) );
	}
}