<?php
require("../../config/koneksi.php");
require("../../config/function.php");
require("../../config/crud.php");
$jsis13 = mysqli_num_rows(mysqli_query($koneksi, "SELECT * FROM siswa JOIN kelas ON kelas.kelas=siswa.kelas WHERE kelas.kurikulum='K-2013'"));
$jmap = mysqli_num_rows(mysqli_query($koneksi, "SELECT * FROM mapel_rapor WHERE kurikulum='K-2013'"));

$jmer = mysqli_num_rows(mysqli_query($koneksi, "SELECT * FROM siswa JOIN kelas ON kelas.kelas=siswa.kelas WHERE kelas.kurikulum='K-Merdeka'"));
$jmap2 = mysqli_num_rows(mysqli_query($koneksi, "SELECT * FROM mapel_rapor WHERE kurikulum='K-Merdeka'"));

$nmer = $jmer * $jmap2;
$nk13 = $jsis13 * $jmap;
$r13 = mysqli_num_rows(mysqli_query($koneksi, "SELECT * FROM nilai_rapor"));
$r23 = mysqli_num_rows(mysqli_query($koneksi, "SELECT * FROM nilai_sumatif GROUP BY nis"));
?>
		
				
				
				
				 <ul class="widget-list-content list-unstyled">
                                            <li class="widget-list-item widget-list-item-green">
                                                <span class="widget-list-item-icon"><i class="material-icons-outlined">article</i></span>
                                                <span class="widget-list-item-description">
                                                    <a href="#" class="widget-list-item-description-title">
                                                        <p>Kurikulum Merdeka</p> <?= $r23 ?> dari <?= $nmer ?> data
                                                    </a>
                                                    <span class="widget-list-item-description-progress">
                                                        <div class="progress">
                                                            <div class="progress-bar" role="progressbar" style="width: <?= ($r23/$nmer)*100; ?>%;" aria-valuenow=" <?= ($r23/$nmer)*100; ?>" aria-valuemin="0" aria-valuemax="100"></div>
                                                        </div>
                                                    </span>
                                                </span>
                                            </li>
											 <li class="widget-list-item widget-list-item-blue">
                                                <span class="widget-list-item-icon"><i class="material-icons-outlined">verified_user</i></span>
                                                <span class="widget-list-item-description">
                                                    <a href="#" class="widget-list-item-description-title">
                                                      <p> Kurikulum 2013</p> <?= $r13 ?> dari <?= $nk13 ?> data
                                                    </a>
                                                    <span class="widget-list-item-description-progress">
                                                        <div class="progress">
                                                            <div class="progress-bar bg-success" role="progressbar" style="width: <?= ($r13/$nk13)*100; ?>%;" aria-valuenow="<?= ($r13/$nk13)*100; ?>" aria-valuemin="0" aria-valuemax="100"></div>
                                                        </div>
                                                    </span>
                                                </span>
                                            </li>
				
				
							