nilai_lihat

<?php

/**
* Lihat Nilai
*/

$nis = $id_tahun_ajar = $nama = $kelas = $table = null;

# persiapan Tahun Ajaran
date_default_timezone_set("Asia/Jakarta");
$tanggal=date("Y-m-d");
$query_tahun_ajar = mysql_query(
                                "SELECT * from tahun_ajaran where '$tanggal' BETWEEN mulai AND akhir"
                                );
$tahun_ajaran= 0;
$find_tahun_ajar = mysql_num_rows($query_tahun_ajar);
if ($find_tahun_ajar == 1 ) {
    $TA=mysql_fetch_array($query_tahun_ajar);
    $id_tahun_ajar=$TA['idTahunAjar'];
    $tahun_ajaran = 1;
}


# Lihat data siswa
$nis = $_SESSION['namasiswa'];
$query_siswa = mysql_query("SELECT * FROM data_siswa LEFT JOIN data_kelas ON data_siswa.idKelas = data_kelas.idKelas WHERE data_siswa.nis='".$nis."' ");
$find_siswa = mysql_num_rows($query_siswa);
if ($find_siswa == 1) {
    $data_siswa = mysql_fetch_array($query_siswa);
    $nama = $data_siswa['namaSiswa'];
    $kelas = $data_siswa['namaKelas'];
}
else
    $_SESSION['alert'] = "ERROR WHEN GET DATA SISWA";


# Jenis Nilai
$jenis = null;
$query_jenis = mysql_query("SELECT * FROM jenis_nilai ORDER BY kodeJenis ASC");
$colspan = 0;
while ($data_jenis = mysql_fetch_array($query_jenis)) {
    $colspan ++;
    $jenis .= "<th>".$data_jenis['jenisNilai']."</th>";
}

#nilai
$tr_nilai = null;
$total = $mp = 0;
$query_nilai =  mysql_query("SELECT * FROM nilai INNER JOIN mata_pelajaran ON nilai.idMP = mata_pelajaran.idMP WHERE nis = '$nis' AND idTahunAjar = '$id_tahun_ajar'");
while ($data_nilai = mysql_fetch_array($query_nilai)) {
    $mp ++;
    $tr_nilai .= "<tr>";

    $mata_pelajaran = $data_nilai['mataPelajaran'];
    $td_MP = "<td>".$mata_pelajaran."</td>";

    #detail_nilai
    $td_detail = null;
    $query_detail = mysql_query("SELECT * FROM detail_nilai WHERE idNilai = '".$data_nilai['idNilai']."' ORDER BY kodeJenis ASC");
    while ($data_detail = mysql_fetch_array($query_detail)) {
        $td_detail .= "<td>".$data_detail['nilai']."</td>";
    }
    $tr_nilai .= $td_MP . $td_detail . "<td>" .$data_nilai['total']. "</td>" . "</tr>";
    $total += $data_nilai['total'];

}

$table = "<table border = '1'>";
$table .= "<tr bgcolor='green'>";
$table .= "<th>Mata Pelajaran</th>";
$table .= $jenis;
$table .= "<th>Rata-rata</th>";
$table .= "</tr>";

$table .= "<tr>";
$table .= $tr_nilai;
$table .= "</tr>";

$table .= "<tr bgcolor='#B4EFC4'>";
$table .= "<td colspan = '".($colspan+1)."' align='center'>Total</td>";
$table .= "<td>".intval($total/$mp)."</td>";
$table .= "</tr>";

$table .= "</table>";


?>

<div>
    <table>
        <tr>
            <td>NIS</td>
            <td>:</td>
            <td><?=$nis?></td>
        </tr>
        <tr>
            <td>Nama</td>
            <td>:</td>
            <td><?=$nama?></td>
        </tr>
        <tr>
            <td>Kelas</td>
            <td>:</td>
            <td><?=$kelas?></td>
        </tr>
        <tr>
            <td colspan="3"><?=$table?></td>
        </tr>
        <tr>
            <td colspan="3"><a href=#>versi cetak</a></td>
        </tr>
    </table>
</div>