/* =====================================================
SHORTCODE LIST + GRAPHIC INTERAKTIF (PUBLIC PAGE)
===================================================== */
function mio_list(){
global $wpdb;
$table = $wpdb->prefix . ‘mio_registrasi’;
// =========================
// STATISTIK GLOBAL
// =========================
$total_peserta = $wpdb->get_var(“SELECT SUM(ikhwan + akhwat) FROM $table”);
$total_ikhwan = $wpdb->get_var(“SELECT SUM(ikhwan) FROM $table”);
$total_akhwat = $wpdb->get_var(“SELECT SUM(akhwat) FROM $table”);
$total_peserta = $total_peserta ?: 0;
$total_ikhwan = $total_ikhwan ?: 0;
$total_akhwat = $total_akhwat ?: 0;
// =========================
// DATA PER KLOTER
// =========================
$kloter_data = $wpdb->get_results(“
SELECT kloter, SUM(ikhwan + akhwat) as total
FROM $table
GROUP BY kloter
“);
ob_start();
?>
Total Peserta
Total Ikhwan
Total Akhwat
Statistik Per Kloter
Progress Kuota Kloter
total / MIO_KUOTA_PER_KLOTER) * 100;
$percent = min($percent,100);
?>
kloter) ?>
(total ?> / )
