Code:
<table class="table table-striped- table-bordered table-hover table-checkable">
<thead>
<tr>
<th>NO</th>
<th>NIM</th>
<th>NAMA</th>
<?php
foreach($transkrip as $data)
{
$id_kelas_prodi = $data['id_kelas_prodi'];
}
$id_smt = $this->db->query ("select * from semester where smt='".$id."' and nm_smt='".$this->session->userdata("tahun")."'")->result_array();
$kode_prodi = $this->db->query ("select * from mahasiswa join kelas_prodi on (kelas_prodi.id_kelas_prodi=mahasiswa.id_kelas_prodi)
where mahasiswa.id_kelas_prodi='".$id_kelas_prodi."'")->result_array();
$matkul_dosen = $this->db->query ("select matkul_dosen.id_mk, mata_kuliah.kode_mk, mata_kuliah.sks_mk from matkul_dosen
join mata_kuliah on(matkul_dosen.id_mk=mata_kuliah.id_mk)
where id_smt='".$id_smt[0]['id_smt']."' and kode_prodi='".$kode_prodi[0]['kode_prodi']."'
Group by matkul_dosen.id_mk, mata_kuliah.kode_mk, mata_kuliah.sks_mk")->result_array();
foreach ($matkul_dosen as $key) { ?>
<th><?php echo $key['kode_mk']; ?></th>
<th><?php echo $key['sks_mk']; ?></th>
<?php } ?>
<th>JUMLAH BOBOT</th>
<th>IPS</th>
<th>Jumlah Nilai D</th>
<th>Jumlah Nilai E</th>
</tr>
</thead>
<?php
$no = 1;
$sks = array();
$nilai = array();
foreach($transkrip as $data) {
$total_uas = ($data['uas']*$data['k_uas'])/100;
$total_uts = ($data['uts']*$data['k_uts'])/100;
$total_lain = ($data['lain']*$data['k_lain'])/100;
$nilai_angka = $total_uas+$total_uts+$total_lain;
$sks[] = $data['sks_mk'];
if($nilai_angka >= 85)
{
$nilai_huruf = "A";
}
if(($nilai_angka >= 78) && ($nilai_angka <= 84.99))
{
$nilai_huruf = "AB";
}
if($nilai_angka >= 70 && $nilai_angka <= 77.99)
{
$nilai_huruf = "B";
}
if($nilai_angka >= 63 && $nilai_angka <= 69.99) {
$nilai_huruf = "BC";
}
if($nilai_angka >= 55 && $nilai_angka <= 62.99) {
$nilai_huruf = "C";
}
if($nilai_angka >= 40 && $nilai_angka <= 54.99) {
$nilai_huruf = "D";
}
if($nilai_angka > 0 && $nilai_angka <= 39.99) {
$nilai_huruf = "E";
}
if($nilai_angka == 0) {
$nilai_huruf = "";
}
if($nilai_huruf == "A") {
$nilai_indeks = 4;
}
if($nilai_huruf == "AB") {
$nilai_indeks = 3.5;
}
if($nilai_huruf == "B") {
$nilai_indeks = 3;
}
if($nilai_huruf == "BC") {
$nilai_indeks = 2.5;
}
if($nilai_huruf == "C") {
$nilai_indeks = 2;
}
if($nilai_huruf == "D") {
$nilai_indeks = 1;
}
if($nilai_huruf == "E") {
$nilai_indeks = 0;
}
if($nilai_huruf == "") {
$nilai_indeks = 0;
}
$nilai = $nilai_indeks*$data['sks_mk'];
?>
<tbody>
<tr>
<td><?php echo $no++ ?> </td>
<td><?php echo $data['nim']; ?> </td>
<td><?php echo $data['nm_pd']; ?> </td>
<?php
$id_smt = $this->db->query ("select * from semester where smt='".$id."' and nm_smt='".$this->session->userdata("tahun")."'")->result_array();
$kode_prodi = $this->db->query ("select * from mahasiswa join kelas_prodi on (kelas_prodi.id_kelas_prodi=mahasiswa.id_kelas_prodi)
where mahasiswa.id_kelas_prodi='".$data['id_kelas_prodi']."'")->result_array();
$matkul_dosen = $this->db->query ("select matkul_dosen.id_mk, mata_kuliah.kode_mk, mata_kuliah.sks_mk from matkul_dosen
join mata_kuliah on(matkul_dosen.id_mk=mata_kuliah.id_mk)
join input_nilai on (input_nilai.kode_mk=mata_kuliah.kode_mk)
where id_smt='".$id_smt[0]['id_smt']."' and
kode_prodi='".$kode_prodi[0]['kode_prodi']."' and
input_nilai.kode_mk='".$data['kode_mk']."'
Group by matkul_dosen.id_mk, mata_kuliah.kode_mk, mata_kuliah.sks_mk")->result_array();
foreach ($matkul_dosen as $key) { ?>
<th><?php echo $nilai_huruf; ?></th>
<th><?php echo $nilai_indeks; ?></th>
<?php } ?>
<td><?php echo $nilai; ?> </td>
</tr>
</tbody>
<?php } ?>
</table>
