Skip to content

Dataset 60

    <?php
/**
 * Dashboard, katalog, dan status kemutakhiran lewat shortcode. Bekerja di tema apa pun.
 *
 *   [sdb_dashboard]  ringkasan: pencarian, angka utama, indikator, peringkat, sektor, dataset terbaru
 *   [sdb_katalog]    daftar dataset dengan pencarian dan filter
 *   [sdb_status]     peringkat kemutakhiran data per perangkat daerah
 */
if ( ! defined( 'ABSPATH' ) ) {
	exit;
}

/* ---------------------------------------------------------------
 * Pembantu
 * ------------------------------------------------------------- */
function sdb_status_labels() {
	return array(
		'terverifikasi' => 'Terverifikasi',
		'menunggu'      => 'Menunggu verifikasi',
		'diperbarui'    => 'Diperbarui',
		'arsip'         => 'Arsip',
		'perlu_update'  => 'Perlu pembaruan',
	);
}

function sdb_badge( $status ) {
	$labels = sdb_status_labels();
	if ( ! isset( $labels[ $status ] ) ) {
		return '';
	}
	return '<span class="sdbd-badge sdbd-badge--' . esc_attr( $status ) . '">' . esc_html( $labels[ $status ] ) . '</span>';
}

function sdb_term_names( $post_id, $taxonomy ) {
	$terms = get_the_terms( $post_id, $taxonomy );
	if ( ! $terms || is_wp_error( $terms ) ) {
		return '';
	}
	return implode( ', ', wp_list_pluck( $terms, 'name' ) );
}

function sdb_term_total( $taxonomy ) {
	$n = wp_count_terms( array( 'taxonomy' => $taxonomy, 'hide_empty' => true ) );
	return is_wp_error( $n ) ? 0 : (int) $n;
}

function sdb_bar( $pct ) {
	$pct = max( 0, min( 100, (int) $pct ) );
	return '<span class="sdbd-bar" role="img" aria-label="' . $pct . ' persen"><i style="width:' . $pct . '%"></i></span>';
}

function sdb_years() {
	global $wpdb;
	return $wpdb->get_col(
		"SELECT DISTINCT pm.meta_value FROM {$wpdb->postmeta} pm
		 INNER JOIN {$wpdb->posts} p ON p.ID = pm.post_id
		 WHERE pm.meta_key = 'sdb_tahun' AND pm.meta_value <> ''
		 AND p.post_type = 'dataset' AND p.post_status = 'publish'
		 ORDER BY pm.meta_value DESC"
	);
}

/* Mencari halaman yang memuat sebuah shortcode (untuk membuat tautan antarhalaman tanpa pengaturan) */
function sdb_find_page_url( $shortcode ) {
	$key    = 'sdb_pg_' . md5( $shortcode );
	$cached = get_transient( $key );
	if ( $cached !== false ) {
		return $cached === 'none' ? '' : $cached;
	}
	global $wpdb;
	$id  = $wpdb->get_var( $wpdb->prepare(
		"SELECT ID FROM {$wpdb->posts} WHERE post_type='page' AND post_status='publish' AND post_content LIKE %s ORDER BY ID ASC LIMIT 1",
		'%' . $wpdb->esc_like( '[' . $shortcode ) . '%'
	) );
	$url = $id ? get_permalink( (int) $id ) : '';
	set_transient( $key, $url ? $url : 'none', HOUR_IN_SECONDS );
	return $url;
}

add_action( 'save_post_page', function () {
	delete_transient( 'sdb_pg_' . md5( 'sdb_katalog' ) );
	delete_transient( 'sdb_pg_' . md5( 'sdb_status' ) );
	delete_transient( 'sdb_pg_' . md5( 'sdb_dashboard' ) );
} );

function sdb_katalog_url() {
	$u = sdb_find_page_url( 'sdb_katalog' );
	return $u ? $u : (string) get_post_type_archive_link( 'dataset' );
}

function sdb_status_url() {
	return sdb_find_page_url( 'sdb_status' );
}

/* Formulir GET yang tetap bekerja pada permalink polos (?page_id=) */
function sdb_form_target( $url ) {
	$parts  = wp_parse_url( $url );
	$hidden = '';
	if ( ! empty( $parts['query'] ) ) {
		parse_str( $parts['query'], $qv );
		foreach ( $qv as $k => $v ) {
			if ( is_scalar( $v ) ) {
				$hidden .= '<input type="hidden" name="' . esc_attr( $k ) . '" value="' . esc_attr( $v ) . '">';
			}
		}
		$url = strtok( $url, '?' );
	}
	return array( $url, $hidden );
}

/* ---------------------------------------------------------------
 * Kemutakhiran data
 * ------------------------------------------------------------- */
function sdb_fresh_days( $freq ) {
	$map = array( 'Bulanan' => 45, 'Triwulanan' => 120, 'Semesteran' => 210, 'Tahunan' => 400 );
	return isset( $map[ $freq ] ) ? $map[ $freq ] : 400;
}

function sdb_is_fresh( $post_id ) {
	$status = get_post_meta( $post_id, 'sdb_status', true );
	if ( in_array( $status, array( 'arsip', 'perlu_update' ), true ) ) {
		return false;
	}
	$ts = strtotime( (string) get_post_meta( $post_id, 'sdb_tgl_pembaruan', true ) );
	if ( ! $ts ) {
		return false;
	}
	return ( time() - $ts ) <= sdb_fresh_days( get_post_meta( $post_id, 'sdb_frekuensi', true ) ) * DAY_IN_SECONDS;
}

function sdb_opd_stats() {
	$cached = get_transient( 'sdb_opd_stats' );
	if ( is_array( $cached ) ) {
		return $cached;
	}
	$ids = get_posts( array(
		'post_type'      => 'dataset',
		'post_status'    => 'publish',
		'posts_per_page' => -1,
		'fields'         => 'ids',
		'no_found_rows'  => true,
	) );
	$opd   = array();
	$total = 0;
	$fresh = 0;
	foreach ( $ids as $id ) {
		$f = sdb_is_fresh( $id );
		$total++;
		if ( $f ) {
			$fresh++;
		}
		$terms = get_the_terms( $id, 'opd' );
		if ( ! $terms || is_wp_error( $terms ) ) {
			$terms = array( (object) array( 'term_id' => 0, 'name' => 'Tanpa produsen data', 'slug' => '' ) );
		}
		foreach ( $terms as $t ) {
			if ( ! isset( $opd[ $t->term_id ] ) ) {
				$opd[ $t->term_id ] = array( 'id' => (int) $t->term_id, 'name' => $t->name, 'slug' => $t->slug, 'total' => 0, 'fresh' => 0 );
			}
			$opd[ $t->term_id ]['total']++;
			if ( $f ) {
				$opd[ $t->term_id ]['fresh']++;
			}
		}
	}
	foreach ( $opd as $k => $o ) {
		$opd[ $k ]['pct'] = $o['total'] ? (int) round( 100 * $o['fresh'] / $o['total'] ) : 0;
	}
	usort( $opd, function ( $a, $b ) {
		if ( $a['pct'] === $b['pct'] ) {
			return $b['total'] <=> $a['total'];
		}
		return $b['pct'] <=> $a['pct'];
	} );
	$out = array(
		'opd'   => array_values( $opd ),
		'total' => $total,
		'fresh' => $fresh,
		'pct'   => $total ? (int) round( 100 * $fresh / $total ) : 0,
	);
	set_transient( 'sdb_opd_stats', $out, HOUR_IN_SECONDS );
	return $out;
}

function sdb_flush_stats() {
	delete_transient( 'sdb_opd_stats' );
}
add_action( 'save_post_dataset', 'sdb_flush_stats', 99 );
add_action( 'deleted_post', 'sdb_flush_stats' );
add_action( 'set_object_terms', 'sdb_flush_stats' );

/* ---------------------------------------------------------------
 * Aset
 * ------------------------------------------------------------- */
add_action( 'wp_enqueue_scripts', function () {
	$file = plugin_dir_path( dirname( __FILE__ ) ) . 'assets/sdb-dashboard.css';
	wp_register_style( 'sdb-dashboard', plugin_dir_url( dirname( __FILE__ ) ) . 'assets/sdb-dashboard.css', array(), file_exists( $file ) ? filemtime( $file ) : '0.4.0' );
	$post = get_post();
	if ( $post && is_singular() ) {
		foreach ( array( 'sdb_dashboard', 'sdb_katalog', 'sdb_status' ) as $tag ) {
			if ( has_shortcode( $post->post_content, $tag ) ) {
				wp_enqueue_style( 'sdb-dashboard' );
				break;
			}
		}
	}
} );

/* ---------------------------------------------------------------
 * Pengaturan: indikator utama
 * ------------------------------------------------------------- */
add_action( 'admin_menu', function () {
	add_options_page( 'Satu Data Belu', 'Satu Data Belu', 'manage_options', 'sdb-settings', 'sdb_settings_page' );
} );

add_action( 'admin_init', function () {
	register_setting( 'sdb_settings', 'sdb_indikator', array( 'type' => 'array', 'sanitize_callback' => 'sdb_sanitize_indikator', 'default' => array() ) );
} );

function sdb_sanitize_indikator( $in ) {
	$out = array();
	for ( $i = 1; $i <= 6; $i++ ) {
		$r        = ( is_array( $in ) && isset( $in[ $i ] ) && is_array( $in[ $i ] ) ) ? $in[ $i ] : array();
		$out[ $i ] = array(
			'label' => isset( $r['label'] ) ? sanitize_text_field( $r['label'] ) : '',
			'value' => isset( $r['value'] ) ? sanitize_text_field( $r['value'] ) : '',
			'note'  => isset( $r['note'] ) ? sanitize_text_field( $r['note'] ) : '',
		);
	}
	return $out;
}

function sdb_settings_page() {
	if ( ! current_user_can( 'manage_options' ) ) {
		return;
	}
	$ind = get_option( 'sdb_indikator', array() );
	?>
	<div class="wrap">
		<h1>Satu Data Belu</h1>

		<h2>Halaman yang terdeteksi</h2>
		<ul style="list-style:disc;margin-left:20px">
			<li>Dashboard <code>[sdb_dashboard]</code>: <?php echo esc_html( sdb_find_page_url( 'sdb_dashboard' ) ?: 'belum ada' ); ?></li>
			<li>Katalog <code>[sdb_katalog]</code>: <?php echo esc_html( sdb_find_page_url( 'sdb_katalog' ) ?: 'belum ada' ); ?></li>
			<li>Status <code>[sdb_status]</code>: <?php echo esc_html( sdb_find_page_url( 'sdb_status' ) ?: 'belum ada' ); ?></li>
		</ul>
		<p class="description">Buat halaman baru lalu tempel shortcode di atas pada isinya. Tautan antarhalaman terdeteksi otomatis (diperbarui paling lama 1 jam).</p>

		<h2>Indikator utama (tampil di dashboard)</h2>
		<p class="description">Isi nama dan nilai, serta sumber dan tahun. Baris yang kosong tidak ditampilkan. Gunakan angka resmi (BPS atau dinas terkait).</p>
		<form method="post" action="options.php">
			<?php settings_fields( 'sdb_settings' ); ?>
			<table class="form-table"><thead><tr><th>#</th><th>Nama indikator</th><th>Nilai</th><th>Sumber dan tahun</th></tr></thead><tbody>
			<?php for ( $i = 1; $i <= 6; $i++ ) :
				$r = isset( $ind[ $i ] ) ? $ind[ $i ] : array( 'label' => '', 'value' => '', 'note' => '' ); ?>
				<tr>
					<td><?php echo (int) $i; ?></td>
					<td><input type="text" class="regular-text" name="sdb_indikator[<?php echo (int) $i; ?>][label]" value="<?php echo esc_attr( $r['label'] ); ?>"></td>
					<td><input type="text" name="sdb_indikator[<?php echo (int) $i; ?>][value]" value="<?php echo esc_attr( $r['value'] ); ?>"></td>
					<td><input type="text" class="regular-text" name="sdb_indikator[<?php echo (int) $i; ?>][note]" value="<?php echo esc_attr( $r['note'] ); ?>"></td>
				</tr>
			<?php endfor; ?>
			</tbody></table>
			<?php submit_button(); ?>
		</form>
	</div>
	<?php
}

/* ---------------------------------------------------------------
 * Baris dataset
 * ------------------------------------------------------------- */
function sdb_row( $id ) {
	$opd    = sdb_term_names( $id, 'opd' );
	$sektor = sdb_term_names( $id, 'sektor' );
	$tahun  = get_post_meta( $id, 'sdb_tahun', true );
	$format = get_post_meta( $id, 'sdb_format', true );
	$status = get_post_meta( $id, 'sdb_status', true );

	$h  = '<li class="sdbd-row"><div><h3><a href="' . esc_url( get_permalink( $id ) ) . '">' . esc_html( get_the_title( $id ) ) . '</a></h3><p class="sdbd-meta">';
	$h .= $opd ? '<span>' . esc_html( $opd ) . '</span>' : '';
	$h .= $sektor ? '<span>Sektor ' . esc_html( $sektor ) . '</span>' : '';
	$h .= $tahun ? '<span>Tahun ' . esc_html( $tahun ) . '</span>' : '';
	$h .= $format ? '<span>' . esc_html( $format ) . '</span>' : '';
	$h .= '</p></div><div class="sdbd-side">' . sdb_badge( $status ) . '</div></li>';
	return $h;
}

/* ---------------------------------------------------------------
 * [sdb_dashboard]
 * ------------------------------------------------------------- */
add_shortcode( 'sdb_dashboard', function ( $atts ) {
	if ( ! post_type_exists( 'dataset' ) ) {
		return '';
	}
	$a = shortcode_atts( array(
		'judul'     => 'Dashboard Satu Data Kabupaten Belu',
		'terbaru'   => 6,
		'peringkat' => 5,
	), $atts, 'sdb_dashboard' );
	wp_enqueue_style( 'sdb-dashboard' );

	$st     = sdb_opd_stats();
	$n      = (int) wp_count_posts( 'dataset' )->publish;
	$kat    = sdb_katalog_url();
	$sturl  = sdb_status_url();
	list( $action, $hidden ) = sdb_form_target( $kat );
	$sektor = get_terms( array( 'taxonomy' => 'sektor', 'hide_empty' => false ) );
	$sektor = is_wp_error( $sektor ) ? array() : $sektor;

	$ind = array();
	foreach ( (array) get_option( 'sdb_indikator', array() ) as $r ) {
		if ( ! empty( $r['label'] ) && $r['value'] !== '' ) {
			$ind[] = $r;
		}
	}

	ob_start();
	?>
	<div class="sdbd">
		<section class="sdbd-hero">
			<h2><?php echo esc_html( $a['judul'] ); ?></h2>
			<form class="sdbd-search" role="search" method="get" action="<?php echo esc_url( $action ); ?>">
				<?php echo $hidden; // phpcs:ignore WordPress.Security.EscapeOutput ?>
				<label class="sdbd-sr" for="sdbd-q">Cari dataset</label>
				<input id="sdbd-q" type="search" name="q" placeholder="Cari dataset, indikator, atau OPD">
				<?php if ( $sektor ) : ?>
					<select name="sektor" aria-label="Sektor">
						<option value="">Semua sektor</option>
						<?php foreach ( $sektor as $s ) : ?>
							<option value="<?php echo esc_attr( $s->slug ); ?>"><?php echo esc_html( $s->name ); ?></option>
						<?php endforeach; ?>
					</select>
				<?php endif; ?>
				<button type="submit">Cari data</button>
			</form>
			<ul class="sdbd-stats">
				<li><strong><?php echo esc_html( number_format_i18n( $n ) ); ?></strong> dataset</li>
				<li><strong><?php echo esc_html( number_format_i18n( sdb_term_total( 'opd' ) ) ); ?></strong> perangkat daerah</li>
				<li><strong><?php echo esc_html( number_format_i18n( sdb_term_total( 'sektor' ) ) ); ?></strong> sektor</li>
				<li><strong><?php echo esc_html( $st['pct'] ); ?>%</strong> data mutakhir</li>
			</ul>
		</section>

		<?php if ( $ind ) : ?>
			<section class="sdbd-sec">
				<h2>Indikator utama</h2>
				<div class="sdbd-ind">
					<?php foreach ( $ind as $r ) : ?>
						<div>
							<p class="sdbd-ind__l"><?php echo esc_html( $r['label'] ); ?></p>
							<p class="sdbd-ind__v"><?php echo esc_html( $r['value'] ); ?></p>
							<?php if ( ! empty( $r['note'] ) ) : ?><p class="sdbd-ind__n"><?php echo esc_html( $r['note'] ); ?></p><?php endif; ?>
						</div>
					<?php endforeach; ?>
				</div>
			</section>
		<?php endif; ?>

		<?php if ( $st['opd'] ) : ?>
			<section class="sdbd-sec">
				<div class="sdbd-head">
					<h2>Perangkat daerah dengan data paling mutakhir</h2>
					<?php if ( $sturl ) : ?><a href="<?php echo esc_url( $sturl ); ?>">Lihat semua</a><?php endif; ?>
				</div>
				<p class="sdbd-muted">Persentase dataset yang diperbarui sesuai frekuensi pembaruannya.</p>
				<ol class="sdbd-rank">
					<?php foreach ( array_slice( $st['opd'], 0, max( 1, (int) $a['peringkat'] ) ) as $o ) :
						$link = $o['slug'] ? add_query_arg( 'opd', $o['slug'], $kat ) : ''; ?>
						<li>
							<span class="sdbd-rank__name"><?php echo $link ? '<a href="' . esc_url( $link ) . '">' . esc_html( $o['name'] ) . '</a>' : esc_html( $o['name'] ); ?>
								<small><?php echo esc_html( $o['total'] ); ?> dataset, <?php echo esc_html( $o['fresh'] ); ?> mutakhir</small></span>
							<?php echo sdb_bar( $o['pct'] ); // phpcs:ignore WordPress.Security.EscapeOutput ?>
							<strong><?php echo esc_html( $o['pct'] ); ?>%</strong>
						</li>
					<?php endforeach; ?>
				</ol>
			</section>
		<?php endif; ?>

		<?php if ( $sektor ) : ?>
			<section class="sdbd-sec">
				<h2>Data menurut sektor</h2>
				<ul class="sdbd-links">
					<?php foreach ( $sektor as $s ) : ?>
						<li><a href="<?php echo esc_url( add_query_arg( 'sektor', $s->slug, $kat ) ); ?>"><span><?php echo esc_html( $s->name ); ?></span><span class="sdbd-muted"><?php echo esc_html( $s->count ); ?> dataset</span></a></li>
					<?php endforeach; ?>
				</ul>
			</section>
		<?php endif; ?>

		<?php
		$q = new WP_Query( array( 'post_type' => 'dataset', 'post_status' => 'publish', 'posts_per_page' => max( 1, (int) $a['terbaru'] ), 'no_found_rows' => true ) );
		?>
		<section class="sdbd-sec">
			<div class="sdbd-head">
				<h2>Dataset terbaru</h2>
				<a href="<?php echo esc_url( $kat ); ?>">Lihat semua dataset</a>
			</div>
			<?php if ( $q->have_posts() ) : ?>
				<ul class="sdbd-list">
					<?php foreach ( $q->posts as $p ) { echo sdb_row( $p->ID ); } // phpcs:ignore WordPress.Security.EscapeOutput ?>
				</ul>
			<?php else : ?>
				<p class="sdbd-muted">Belum ada dataset yang dipublikasikan.</p>
			<?php endif; wp_reset_postdata(); ?>
		</section>
	</div>
	<?php
	return ob_get_clean();
} );

/* ---------------------------------------------------------------
 * [sdb_katalog]
 * ------------------------------------------------------------- */
add_shortcode( 'sdb_katalog', function ( $atts ) {
	if ( ! post_type_exists( 'dataset' ) ) {
		return '';
	}
	$a = shortcode_atts( array( 'per' => 12 ), $atts, 'sdb_katalog' );
	wp_enqueue_style( 'sdb-dashboard' );

	$get = function ( $k ) {
		return isset( $_GET[ $k ] ) ? sanitize_text_field( wp_unslash( $_GET[ $k ] ) ) : '';
	};
	$kata   = $get( 'q' );
	$sektor = sanitize_title( $get( 'sektor' ) );
	$opd    = sanitize_title( $get( 'opd' ) );
	$tahun  = $get( 'tahun' );
	$status = sanitize_key( $get( 'status' ) );
	$urut   = $get( 'urut' ) === 'judul' ? 'judul' : 'terbaru';
	$hal    = max( 1, (int) $get( 'hal' ) );

	$args = array(
		'post_type'      => 'dataset',
		'post_status'    => 'publish',
		'posts_per_page' => max( 1, (int) $a['per'] ),
		'paged'          => $hal,
	);
	if ( $kata !== '' ) {
		$args['s'] = $kata;
	}
	$tax = array();
	if ( $sektor ) {
		$tax[] = array( 'taxonomy' => 'sektor', 'field' => 'slug', 'terms' => $sektor );
	}
	if ( $opd ) {
		$tax[] = array( 'taxonomy' => 'opd', 'field' => 'slug', 'terms' => $opd );
	}
	if ( $tax ) {
		$args['tax_query'] = $tax;
	}
	$meta = array();
	if ( $tahun !== '' ) {
		$meta[] = array( 'key' => 'sdb_tahun', 'value' => $tahun );
	}
	if ( $status !== '' ) {
		$meta[] = array( 'key' => 'sdb_status', 'value' => $status );
	}
	if ( $meta ) {
		$args['meta_query'] = $meta;
	}
	if ( $urut === 'judul' ) {
		$args['orderby'] = 'title';
		$args['order']   = 'ASC';
	}
	$q = new WP_Query( $args );

	$base = get_permalink();
	if ( ! $base ) {
		$base = sdb_katalog_url();
	}
	list( $action, $hidden ) = sdb_form_target( $base );
	$params = array_filter( array( 'q' => $kata, 'sektor' => $sektor, 'opd' => $opd, 'tahun' => $tahun, 'status' => $status, 'urut' => $urut === 'judul' ? 'judul' : '' ) );

	ob_start();
	?>
	<div class="sdbd sdbd-katalog">
		<form class="sdbd-filters" method="get" action="<?php echo esc_url( $action ); ?>">
			<?php echo $hidden; // phpcs:ignore WordPress.Security.EscapeOutput ?>
			<label>Kata kunci <input type="search" name="q" value="<?php echo esc_attr( $kata ); ?>" placeholder="mis. populasi ternak"></label>
			<?php foreach ( array( 'sektor' => array( 'Sektor', $sektor ), 'opd' => array( 'OPD / produsen data', $opd ) ) as $tx => $cfg ) :
				$terms = get_terms( array( 'taxonomy' => $tx, 'hide_empty' => true ) );
				if ( is_wp_error( $terms ) || ! $terms ) { continue; } ?>
				<label><?php echo esc_html( $cfg[0] ); ?>
					<select name="<?php echo esc_attr( $tx ); ?>">
						<option value="">Semua</option>
						<?php foreach ( $terms as $t ) : ?>
							<option value="<?php echo esc_attr( $t->slug ); ?>" <?php selected( $cfg[1], $t->slug ); ?>><?php echo esc_html( $t->name ); ?></option>
						<?php endforeach; ?>
					</select>
				</label>
			<?php endforeach; ?>
			<?php $years = sdb_years(); if ( $years ) : ?>
				<label>Tahun data
					<select name="tahun">
						<option value="">Semua tahun</option>
						<?php foreach ( $years as $y ) : ?>
							<option value="<?php echo esc_attr( $y ); ?>" <?php selected( $tahun, $y ); ?>><?php echo esc_html( $y ); ?></option>
						<?php endforeach; ?>
					</select>
				</label>
			<?php endif; ?>
			<label>Status data
				<select name="status">
					<option value="">Semua status</option>
					<?php foreach ( sdb_status_labels() as $k => $l ) : ?>
						<option value="<?php echo esc_attr( $k ); ?>" <?php selected( $status, $k ); ?>><?php echo esc_html( $l ); ?></option>
					<?php endforeach; ?>
				</select>
			</label>
			<label>Urutkan
				<select name="urut">
					<option value="terbaru" <?php selected( $urut, 'terbaru' ); ?>>Terbaru dipublikasikan</option>
					<option value="judul" <?php selected( $urut, 'judul' ); ?>>Judul A sampai Z</option>
				</select>
			</label>
			<div class="sdbd-filters__act">
				<button type="submit">Terapkan</button>
				<a href="<?php echo esc_url( $action . ( $hidden ? '' : '' ) ); ?>">Atur ulang</a>
			</div>
		</form>

		<div class="sdbd-results">
			<p class="sdbd-muted"><?php echo esc_html( number_format_i18n( $q->found_posts ) ); ?> dataset ditemukan</p>
			<?php if ( $q->have_posts() ) : ?>
				<ul class="sdbd-list">
					<?php foreach ( $q->posts as $p ) { echo sdb_row( $p->ID ); } // phpcs:ignore WordPress.Security.EscapeOutput ?>
				</ul>
				<?php if ( $q->max_num_pages > 1 ) : ?>
					<nav class="sdbd-pages" aria-label="Halaman hasil">
						<?php
						$last = (int) $q->max_num_pages;
						$link = function ( $n, $label, $cur = false ) use ( $base, $params ) {
							if ( $cur ) {
								return '<span class="sdbd-pages__cur" aria-current="page">' . esc_html( $label ) . '</span>';
							}
							return '<a href="' . esc_url( add_query_arg( array_merge( $params, array( 'hal' => $n ) ), $base ) ) . '">' . esc_html( $label ) . '</a>';
						};
						if ( $hal > 1 ) {
							echo $link( $hal - 1, 'Sebelumnya' ); // phpcs:ignore WordPress.Security.EscapeOutput
						}
						for ( $i = 1; $i <= $last; $i++ ) {
							if ( $i === 1 || $i === $last || abs( $i - $hal ) <= 2 ) {
								echo $link( $i, (string) $i, $i === $hal ); // phpcs:ignore WordPress.Security.EscapeOutput
							} elseif ( abs( $i - $hal ) === 3 ) {
								echo '<span>…</span>';
							}
						}
						if ( $hal < $last ) {
							echo $link( $hal + 1, 'Berikutnya' ); // phpcs:ignore WordPress.Security.EscapeOutput
						}
						?>
					</nav>
				<?php endif; ?>
			<?php else : ?>
				<div class="sdbd-empty">
					<h3>Tidak ada dataset yang cocok</h3>
					<p>Ubah kata kunci atau hapus sebagian filter, lalu coba lagi.</p>
				</div>
			<?php endif; wp_reset_postdata(); ?>
		</div>
	</div>
	<?php
	return ob_get_clean();
} );

/* ---------------------------------------------------------------
 * [sdb_status]
 * ------------------------------------------------------------- */
add_shortcode( 'sdb_status', function () {
	if ( ! post_type_exists( 'dataset' ) ) {
		return '';
	}
	wp_enqueue_style( 'sdb-dashboard' );
	$st  = sdb_opd_stats();
	$kat = sdb_katalog_url();

	ob_start();
	?>
	<div class="sdbd">
		<p>Sebuah dataset dihitung <strong>mutakhir</strong> bila tanggal pembaruannya masih dalam batas frekuensi pembaruan (bulanan 45 hari, triwulanan 120 hari, semesteran 210 hari, tahunan dan lainnya 400 hari). Dataset berstatus arsip atau perlu pembaruan, atau tanpa tanggal pembaruan, tidak dihitung.</p>
		<p><strong><?php echo esc_html( $st['fresh'] ); ?></strong> dari <strong><?php echo esc_html( $st['total'] ); ?></strong> dataset mutakhir (<?php echo esc_html( $st['pct'] ); ?>%).</p>
		<?php if ( $st['opd'] ) : ?>
			<div class="sdbd-tbl">
				<table>
					<thead><tr><th scope="col">Peringkat</th><th scope="col">Perangkat daerah</th><th scope="col">Dataset</th><th scope="col">Mutakhir</th><th scope="col">Kemutakhiran</th></tr></thead>
					<tbody>
						<?php foreach ( $st['opd'] as $i => $o ) :
							$link = $o['slug'] ? add_query_arg( 'opd', $o['slug'], $kat ) : ''; ?>
							<tr>
								<td><?php echo esc_html( $i + 1 ); ?></td>
								<td><?php echo $link ? '<a href="' . esc_url( $link ) . '">' . esc_html( $o['name'] ) . '</a>' : esc_html( $o['name'] ); ?></td>
								<td><?php echo esc_html( $o['total'] ); ?></td>
								<td><?php echo esc_html( $o['fresh'] ); ?></td>
								<td class="sdbd-tbl__bar"><?php echo sdb_bar( $o['pct'] ); // phpcs:ignore WordPress.Security.EscapeOutput ?><strong><?php echo esc_html( $o['pct'] ); ?>%</strong></td>
							</tr>
						<?php endforeach; ?>
					</tbody>
				</table>
			</div>
		<?php else : ?>
			<div class="sdbd-empty"><h3>Belum ada data</h3><p>Statistik muncul setelah dataset dipublikasikan dan tanggal pembaruannya diisi.</p></div>
		<?php endif; ?>
	</div>
	<?php
	return ob_get_clean();
} );