Masalah perhitungan pada Nilai Raport SIASELAH KTSP

Masalah perhitungan pada Nilai Raport SIASELAH KTSP Dibuat 6 Tahun lalu \| 2017-11-11 05:48:23 WIB, Login Terakhir 5 Hari lalu, Telah Dilihat 1587 Kali
Sultan Account
Sultan Account	Rahmat Sasmita Mengatakan : Sultan Account Ketika Nilai UTS dengan Nilai UAS disamakan misalkan semua di jadikan 78, maka nilai malah mengecil dan tidak sesuai? (39) Ada 1 File Kiriman : 1. Screenshot-2017-11-10_LMS_SMK_Plus_AL-MAFTUH.png (6 KB)

Ada 20 Jawaban

Rahmat Sasmita commented on 12 Nov 2017 05:39:11 Sultan Account

	up pk robby

PHPMU.COM Support commented on 12 Nov 2017 11:01:44 Sultan Account

	Assalam, coba buka file "application/raport/raport_nilai_pengetahuan.php" pada baris 172 cari : $rapn[total] dan menjadi : ($ta[uh]+$ta[tugas]+$sms[nilai1]+$sms[nilai2])/4

Rahmat Sasmita commented on 21 Nov 2017 05:03:18 Sultan Account

	Setelah saya ganti seperti itu pak robby, di halaman input nilai sesuai... tapi pas di raport halaman 4 nilai jadi berbeda.... jadi lebih besar Terdapat 2 File dilampirkan : 1. tampilan_hal_6_raport.png (67 KB) 2. tampilan_input_raport.png (16 KB)

Rahmat Sasmita commented on 22 Nov 2017 05:30:24 Sultan Account

	Up pak Robby sebelum pembagian raport

PHPMU.COM Support commented on 23 Nov 2017 07:21:29 Sultan Account

	Iya mas, pada file raport halaman 4 jangan lupa diubah juga perhitungannya seperti di atas,.. ($ta[uh]+$ta[tugas]+$sms[nilai1]+$sms[nilai2])/4 agar sesuai dengan hasil pada perhitungan input,...

Rahmat Sasmita
commented on 24 Nov 2017 05:03:37 Sultan Account

tepatnya pada bagian mana pk Robby??? :) 
 
      echo "<tr>
            <td align=center><b>A.</b></td><td><b>Mata Pelajaran</b></td><td></td><td></td><td></td><td></td><td></td><td></td>
          </tr>";
        $kelompok = mysql_query("SELECT * FROM rb_kelompok_mata_pelajaran");  
        while ($k = mysql_fetch_array($kelompok)){
        echo "<tr>
              <td colspan='8'><b>$k[nama_kelompok_mata_pelajaran]</b></td>
            </tr>";
          $mapel = mysql_query("SELECT * FROM  rb_jadwal_pelajaran a JOIN rb_mata_pelajaran b ON a.kode_pelajaran=b.kode_pelajaran 
                                    where a.kode_kelas='$_GET[kelas]' AND a.id_tahun_akademik='$_GET[tahun]' AND b.id_kelompok_mata_pelajaran='$k[id_kelompok_mata_pelajaran]'");
          $no = 1;
          while ($m = mysql_fetch_array($mapel)){                                
          $rapn = mysql_fetch_array(mysql_query("SELECT kodejdwl, nisn, (sum(uh)+sum(tugas))/4 as total FROM ((SELECT kodejdwl, nisn, sum(nilai1)/count(nisn) as uh, sum(nilai2)/count(nisn) as tugas FROM `rb_nilai_pengetahuan` where nisn='$_GET[id]' GROUP BY kodejdwl) UNION (SELECT kodejdwl, nisn, nilai1, (nilai2*2) FROM rb_nilai_pengetahuan_semester where nisn='$_GET[id]')) as a where a.kodejdwl='$m[kodejdwl]' GROUP by a.kodejdwl"));
 
          $cekpredikat = mysql_num_rows(mysql_query("SELECT * FROM rb_predikat where kode_kelas='$_GET[kelas]'"));
              if ($cekpredikat >= 1){
                  $grade3 = mysql_fetch_array(mysql_query("SELECT * FROM `rb_predikat` where (".number_format($rapn[raport])." >=nilai_a) AND (".number_format($rapn[raport])." <= nilai_b) AND kode_kelas='$_GET[kelas]'"));
              }else{
                  $grade3 = mysql_fetch_array(mysql_query("SELECT * FROM `rb_predikat` where (".number_format($rapn[raport])." >=nilai_a) AND (".number_format($rapn[raport])." <= nilai_b) AND kode_kelas='0'"));
              }
 
          $rapnk = mysql_fetch_array(mysql_query("SELECT sum(GREATEST(nilai1,nilai2,nilai3,nilai4,nilai5,nilai6))/count(nisn) as raport FROM rb_nilai_keterampilan where kodejdwl='$m[kodejdwl]' AND nisn='$s[nisn]'"));
          $cekpredikat2 = mysql_num_rows(mysql_query("SELECT * FROM rb_predikat where kode_kelas='$_GET[kelas]'"));
              if ($cekpredikat2 >= 1){
                  $grade = mysql_fetch_array(mysql_query("SELECT * FROM `rb_predikat` where (".number_format($rapnk[raport])." >=nilai_a) AND (".number_format($rapnk[raport])." <= nilai_b) AND kode_kelas='$_GET[kelas]'"));
              }else{
                  $grade = mysql_fetch_array(mysql_query("SELECT * FROM `rb_predikat` where (".number_format($rapnk[raport])." >=nilai_a) AND (".number_format($rapnk[raport])." <= nilai_b) AND kode_kelas='0'"));
              }
          $des = mysql_fetch_array(mysql_query("SELECT * FROM rb_ledger where kodejdwl='$m[kodejdwl]' AND nisn='$_GET[id]' AND kode_kelas='$_GET[kelas]'"));   
          echo "<tr>
                  <td align=center>$no</td>
                  <td>$m[namamatapelajaran]</td>
                  <td align=center>$m[kkm]</td>
                  <td align=center>".number_format($rapn[total])."</td>
                  <td>".ucwords(terbilang(number_format($rapn[total])))."</td>
                  <td align=center>".number_format($rapnk[raport])."</td>
                  <td>".ucwords(terbilang(number_format($rapnk[raport])))."</td>
                  <td align=center>$des[sikap]</td>
              </tr>";
          $no++;
          }
        }

Rahmat Sasmita commented on 25 Nov 2017 06:15:12 Sultan Account

	Mohon maaf sekali... mohon bantu pk Robby

PHPMU.COM Support
commented on 26 Nov 2017 08:35:47 Sultan Account

Tinggal sesuaikan saja querynya dengan file "application/raport/raport_nilai_pengetahuan.php" yg sdah saya jelaskan di atas :
 
$ta = mysql_fetch_array(mysql_query("SELECT kodejdwl, nisn, sum(nilai1)/count(nisn) as uh, sum(nilai2)/count(nisn) as tugas 
FROM `rb_nilai_pengetahuan` where nisn='$_GET[id]' AND kodejdwl='$m[kodejdwl]' GROUP BY kodejdwl"));
 
$sms = mysql_fetch_array(mysql_query("SELECT * FROM rb_nilai_pengetahuan_semester 
where kodejdwl='$m[kodejdwl]' AND nisn='$_GET[id]'"));
 
$nilai_pengetahuan = number_format(($ta[uh]+$ta[tugas]+$sms[nilai1]+$sms[nilai2])/4);
echo "$nilai_pengetahuan";
 
Hapus saja perhitungan yang lama :
$rapn = mysql_fetch_array(mysql_query("SELECT kodejdwl, nisn, (sum(uh)+sum(tugas))/4 as total FROM ((SELECT kodejdwl, nisn, sum(nilai1)/count(nisn) as uh, sum(nilai2)/count(nisn) as tugas FROM `rb_nilai_pengetahuan` where nisn='$_GET[id]' GROUP BY kodejdwl) UNION (SELECT kodejdwl, nisn, nilai1, (nilai2*2) FROM rb_nilai_pengetahuan_semester where nisn='$_GET[id]')) as a where a.kodejdwl='$m[kodejdwl]' GROUP by a.kodejdwl"));

PHPMU.COM Support
commented on 26 Nov 2017 08:35:49 Sultan Account

Tinggal sesuaikan saja querynya dengan file "application/raport/raport_nilai_pengetahuan.php" yg sdah saya jelaskan di atas :
 
$ta = mysql_fetch_array(mysql_query("SELECT kodejdwl, nisn, sum(nilai1)/count(nisn) as uh, sum(nilai2)/count(nisn) as tugas 
FROM `rb_nilai_pengetahuan` where nisn='$_GET[id]' AND kodejdwl='$m[kodejdwl]' GROUP BY kodejdwl"));
 
$sms = mysql_fetch_array(mysql_query("SELECT * FROM rb_nilai_pengetahuan_semester 
where kodejdwl='$m[kodejdwl]' AND nisn='$_GET[id]'"));
 
$nilai_pengetahuan = number_format(($ta[uh]+$ta[tugas]+$sms[nilai1]+$sms[nilai2])/4);
echo "$nilai_pengetahuan";
 
Hapus saja perhitungan yang lama :
$rapn = mysql_fetch_array(mysql_query("SELECT kodejdwl, nisn, (sum(uh)+sum(tugas))/4 as total FROM ((SELECT kodejdwl, nisn, sum(nilai1)/count(nisn) as uh, sum(nilai2)/count(nisn) as tugas FROM `rb_nilai_pengetahuan` where nisn='$_GET[id]' GROUP BY kodejdwl) UNION (SELECT kodejdwl, nisn, nilai1, (nilai2*2) FROM rb_nilai_pengetahuan_semester where nisn='$_GET[id]')) as a where a.kodejdwl='$m[kodejdwl]' GROUP by a.kodejdwl"));

Rahmat Sasmita commented on 26 Nov 2017 14:23:03 Sultan Account

	Solved pk .... Untuk merubah query pada bagian ledger_kelas dan ledger mapel dimana dan gimana pk?

Rahmat Sasmita commented on 30 Nov 2017 21:07:42 Sultan Account

	Satu lagi pk Robby.... Selain mohon bantuan cara merubah query pada bagian ledger_kelas dan ledger mapel juga masih ada masalah pada nilai penngetahuan setalah edit query... seperti tampilan berikut Terdapat 1 File dilampirkan : 1. 12345.png (14 KB)

Rahmat Sasmita commented on 04 Des 2017 10:32:29 Sultan Account

	up pak robby... minimal bantu saya kenapa jumlah nilai di hal 4 pada nilai pengetahuan... setelah di rubah ke rumus diatas

PHPMU.COM Support
commented on 04 Des 2017 11:03:10 Sultan Account

Assalam , jika kesulitan dalam query bisa gunakan kode php saja untuk menjumlahkannya mas, ex : 
$jumlah_sum = 0;
$query = mysql_query("SELECT * FROM Table blablaaaa");
while($row = mysql_fetch_array($query)){
    $jumlah_sum = $jumlah_sum + $nilai_pengetahuan;
}
echo "Jumlah  = $jumlah_sum";

Rahmat Sasmita
commented on 04 Des 2017 11:17:26 Sultan Account

saya masih blm paham pak.... bisa bantu tuliskan scriptnya pk robby untu saya pasangkan di halaman 4 setelah saya rubah ke rumus $nilai_pengetahuan = number_format(($ta[uh]+$ta[tugas]+$sms[nilai1]+$sms[nilai2])/4);
echo "$nilai_pengetahuan";

Terdapat 1 File dilampirkan :

1. 123451.png (14 KB)

Rahmat Sasmita
commented on 04 Des 2017 11:19:52 Sultan Account

ini script lengkap hal 4 raport :
 
<?php 
session_start();
error_reporting(0);
include "../config/koneksi.php"; 
include "../config/fungsi_indotgl.php"; 
$frt = mysql_fetch_array(mysql_query("SELECT * FROM rb_header_print ORDER BY id_header_print DESC LIMIT 1")); 
?>
<head>
<title>Hal 4 - Raport Siswa</title>
<link rel="stylesheet" href="../bootstrap/css/printer.css">
</head>
<body onload="window.print()">
<?php
$t = mysql_fetch_array(mysql_query("SELECT * FROM rb_tahun_akademik where id_tahun_akademik='$_GET[tahun]'"));
$s = mysql_fetch_array(mysql_query("SELECT a.*, b.*, c.nama_guru as walikelas, c.nip FROM rb_siswa a 
                                      JOIN rb_kelas b ON a.kode_kelas=b.kode_kelas 
                                        LEFT JOIN rb_guru c ON b.nip=c.nip where a.nisn='$_GET[id]'"));
if (substr($_GET[tahun],4,5)=='1'){ $semester = 'Ganjil'; }else{ $semester = 'Genap'; }
$iden = mysql_fetch_array(mysql_query("SELECT * FROM rb_identitas_sekolah ORDER BY id_identitas_sekolah DESC LIMIT 1"));
 
echo "<h1 align=center>LAPORAN HASIL BELAJAR SISWA</h1><br>
      <table width=100%>
        <tr><td>Nama Peserta Didik</td>       <td> : <b>$s[nama]</b> </td>           <td>Kelas / Semester </td> <td>: $s[kode_kelas] (".substr($_GET[tahun],4,5).") $semester</td></tr>
        <tr><td>No Induk</td>            <td> : $s[nipd] / $s[nisn]</td>             <td>Tahun Pelajaran </td> <td>: $t[keterangan]</td></tr>
        <tr><td width=140px>Nama Sekolah</td> <td> : $iden[nama_sekolah] </td>       <td width=140px></td>   <td></td></tr>
 
 
 
      </table><br>";
 
echo "<table id='tablemodul1' width=100% border=1>
          <tr>
            <th rowspan='3'>No</th>
            <th width='160px' rowspan='3'>Komponen</th>
            <th width='60px' rowspan='3'>KKM</th>
            <th colspan='5'>Nilai Hasil Belajar</th>
          </tr>
          </tr>
            <th colspan='2' style='text-align:center'>Pengetahuan dan Pemahaman Konsep</th>
            <th colspan='2' style='text-align:center'>Kemampuan Praktik</th>
            <th colspan='2' style='text-align:center'>Sikap / Afektif</th>
          </tr>
          <tr>
            <th>Angka</th>
            <th width='120px'>Huruf</th>
            <th>Angka</th>
            <th width='120px'>Huruf</th>
            <th>Predikat</th>
          </tr>";
 
      echo "<tr>
            <td align=center><b>A.</b></td><td><b>Mata Pelajaran</b></td><td></td><td></td><td></td><td></td><td></td><td></td>
          </tr>";
        $kelompok = mysql_query("SELECT * FROM rb_kelompok_mata_pelajaran");  
        while ($k = mysql_fetch_array($kelompok)){
        echo "<tr>
              <td colspan='8'><b>$k[nama_kelompok_mata_pelajaran]</b></td>
            </tr>";
          $mapel = mysql_query("SELECT * FROM  rb_jadwal_pelajaran a JOIN rb_mata_pelajaran b ON a.kode_pelajaran=b.kode_pelajaran 
                                    where a.kode_kelas='$_GET[kelas]' AND a.id_tahun_akademik='$_GET[tahun]' AND b.id_kelompok_mata_pelajaran='$k[id_kelompok_mata_pelajaran]'");
          $no = 1;
          while ($m = mysql_fetch_array($mapel)){                                
          $ta = mysql_fetch_array(mysql_query("SELECT kodejdwl, nisn, sum(nilai1)/count(nisn) as uh, sum(nilai2)/count(nisn) as tugas 
FROM `rb_nilai_pengetahuan` where nisn='$_GET[id]' AND kodejdwl='$m[kodejdwl]' GROUP BY kodejdwl"));
 
$sms = mysql_fetch_array(mysql_query("SELECT * FROM rb_nilai_pengetahuan_semester 
where kodejdwl='$m[kodejdwl]' AND nisn='$_GET[id]'"));
 
$nilai_pengetahuan = number_format(($ta[uh]+$ta[tugas]+$sms[nilai1]+$sms[nilai2])/4);
 
          $cekpredikat = mysql_num_rows(mysql_query("SELECT * FROM rb_predikat where kode_kelas='$_GET[kelas]'"));
              if ($cekpredikat >= 1){
                  $grade3 = mysql_fetch_array(mysql_query("SELECT * FROM `rb_predikat` where (".number_format($rapn[raport])." >=nilai_a) AND (".number_format($rapn[raport])." <= nilai_b) AND kode_kelas='$_GET[kelas]'"));
              }else{
                  $grade3 = mysql_fetch_array(mysql_query("SELECT * FROM `rb_predikat` where (".number_format($rapn[raport])." >=nilai_a) AND (".number_format($rapn[raport])." <= nilai_b) AND kode_kelas='0'"));
              }
 
          $rapnk = mysql_fetch_array(mysql_query("SELECT sum(GREATEST(nilai1,nilai2,nilai3,nilai4,nilai5,nilai6))/count(nisn) as raport FROM rb_nilai_keterampilan where kodejdwl='$m[kodejdwl]' AND nisn='$s[nisn]'"));
          $cekpredikat2 = mysql_num_rows(mysql_query("SELECT * FROM rb_predikat where kode_kelas='$_GET[kelas]'"));
              if ($cekpredikat2 >= 1){
                  $grade = mysql_fetch_array(mysql_query("SELECT * FROM `rb_predikat` where (".number_format($rapnk[raport])." >=nilai_a) AND (".number_format($rapnk[raport])." <= nilai_b) AND kode_kelas='$_GET[kelas]'"));
              }else{
                  $grade = mysql_fetch_array(mysql_query("SELECT * FROM `rb_predikat` where (".number_format($rapnk[raport])." >=nilai_a) AND (".number_format($rapnk[raport])." <= nilai_b) AND kode_kelas='0'"));
              }
          $des = mysql_fetch_array(mysql_query("SELECT * FROM rb_ledger where kodejdwl='$m[kodejdwl]' AND nisn='$_GET[id]' AND kode_kelas='$_GET[kelas]'"));   
          echo "<tr>
                  <td align=center>$no</td>
                  <td>$m[namamatapelajaran]</td>
                  <td align=center>$m[kkm]</td>
                  <td align=center>".number_format($nilai_pengetahuan)."</td>
                  <td>".ucwords(terbilang(number_format($nilai_pengetahuan)))."</td>
                  <td align=center>".number_format($rapnk[raport])."</td>
                  <td>".ucwords(terbilang(number_format($rapnk[raport])))."</td>
                  <td align=center>$des[sikap]</td>
              </tr>";
          $no++;
          }
        }
 
        $ta = mysql_fetch_array(mysql_query("SELECT kodejdwl, nisn, sum(nilai1)/count(nisn) as uh, sum(nilai2)/count(nisn) as tugas 
FROM `rb_nilai_pengetahuan` where nisn='$_GET[id]' AND kodejdwl='$m[kodejdwl]' GROUP BY kodejdwl"));        
$rapnk = mysql_fetch_array(mysql_query("SELECT sum(raport) as raporttotal FROM (SELECT sum(GREATEST(nilai1,nilai2,nilai3,nilai4,nilai5,nilai6))/count(nisn) as raport FROM rb_nilai_keterampilan where nisn='$_GET[id]' GROUP BY kodejdwl) as a"));
        $siswa = mysql_num_rows(mysql_query("SELECT * FROM rb_siswa where kode_kelas='$_GET[kelas]'"));
        $rank = mysql_fetch_array(mysql_query("SELECT * FROM rb_peringkat where nisn='$_GET[id]' AND kode_kelas='$_GET[kelas]' AND id_tahun_akademik='$_GET[tahun]'"));
        echo "<tr>
                <td colspan='3' align=center><b>JUMLAH</b></td>
                <td align=center><b>".number_format($ta[total])."</b></td>
                <td align=center></td>
                <td align=center><b>".number_format($rapnk[raporttotal])."</b></td>
                <td align=center></td>
                <td></td>
            </tr>"; 
 
        echo "<tr>
                <td align=center><b></b></td>
                <td><b>PERINGKAT</b></td>
                <td align=center><b>$rank[rank]</b></td>
                <td colspan='2'><b>Dari $siswa Siswa</b></td>
                <td align=center></td>
                <td align=center></td>
                <td></td>
            </tr>"; 
 
        echo "</table><br/>";
?>
 
<table border=0 width=100%>
  <tr>
    <td width="260" align="left">Orang Tua / Wali</td>
    <td width="520"align="center">Mengetahui <br> Kepala SMK Plus AL-MAFTUH</td>
    <td width="260" align="left">Sukabumi, <?php echo tgl_raport(date("Y-m-d")); ?> <br> Wali Kelas</td>
  </tr>
  <tr>
    <td align="left"><br /><br /><br /><br /><br />
      ................................... <br /><br /></td>
 
    <td align="center" valign="top"><br /><br /><br /><br /><br />
      <b>ASEP ABDUL AZIZ, S.Pd<br>
        NIP : -</b>
    </td>
 
    <td align="left" valign="top"><br /><br /><br /><br /><br />
      <b><?php echo $s[walikelas]; ?><br />
      NRY : <?php echo $s[nip]; ?></b>
    </td>
  </tr>
</table> 
</body>

PHPMU.COM Support
commented on 04 Des 2017 11:48:58 Sultan Account

<?php 
session_start();
error_reporting(0);
include "../config/koneksi.php"; 
include "../config/fungsi_indotgl.php"; 
$frt = mysql_fetch_array(mysql_query("SELECT * FROM rb_header_print ORDER BY id_header_print DESC LIMIT 1")); 
?>
<head>
<title>Hal 4 - Raport Siswa</title>
<link rel="stylesheet" href="../bootstrap/css/printer.css">
</head>
<body onload="window.print()">
<?php
$t = mysql_fetch_array(mysql_query("SELECT * FROM rb_tahun_akademik where id_tahun_akademik='$_GET[tahun]'"));
$s = mysql_fetch_array(mysql_query("SELECT a.*, b.*, c.nama_guru as walikelas, c.nip FROM rb_siswa a 
                                      JOIN rb_kelas b ON a.kode_kelas=b.kode_kelas 
                                        LEFT JOIN rb_guru c ON b.nip=c.nip where a.nisn='$_GET[id]'"));
if (substr($_GET[tahun],4,5)=='1'){ $semester = 'Ganjil'; }else{ $semester = 'Genap'; }
$iden = mysql_fetch_array(mysql_query("SELECT * FROM rb_identitas_sekolah ORDER BY id_identitas_sekolah DESC LIMIT 1"));
 
echo "<h1 align=center>LAPORAN HASIL BELAJAR SISWA</h1><br>
      <table width=100%>
        <tr><td>Nama Peserta Didik</td>       <td> : <b>$s[nama]</b> </td>           <td>Kelas / Semester </td> <td>: $s[kode_kelas] (".substr($_GET[tahun],4,5).") $semester</td></tr>
        <tr><td>No Induk</td>            <td> : $s[nipd] / $s[nisn]</td>             <td>Tahun Pelajaran </td> <td>: $t[keterangan]</td></tr>
        <tr><td width=140px>Nama Sekolah</td> <td> : $iden[nama_sekolah] </td>       <td width=140px></td>   <td></td></tr>
 
 
 
      </table><br>";
 
echo "<table id='tablemodul1' width=100% border=1>
          <tr>
            <th rowspan='3'>No</th>
            <th width='160px' rowspan='3'>Komponen</th>
            <th width='60px' rowspan='3'>KKM</th>
            <th colspan='5'>Nilai Hasil Belajar</th>
          </tr>
          </tr>
            <th colspan='2' style='text-align:center'>Pengetahuan dan Pemahaman Konsep</th>
            <th colspan='2' style='text-align:center'>Kemampuan Praktik</th>
            <th colspan='2' style='text-align:center'>Sikap / Afektif</th>
          </tr>
          <tr>
            <th>Angka</th>
            <th width='120px'>Huruf</th>
            <th>Angka</th>
            <th width='120px'>Huruf</th>
            <th>Predikat</th>
          </tr>";
 
      echo "<tr>
            <td align=center><b>A.</b></td><td><b>Mata Pelajaran</b></td><td></td><td></td><td></td><td></td><td></td><td></td>
          </tr>";
        $kelompok = mysql_query("SELECT * FROM rb_kelompok_mata_pelajaran");  
        while ($k = mysql_fetch_array($kelompok)){
        echo "<tr>
              <td colspan='8'><b>$k[nama_kelompok_mata_pelajaran]</b></td>
            </tr>";
          $mapel = mysql_query("SELECT * FROM  rb_jadwal_pelajaran a JOIN rb_mata_pelajaran b ON a.kode_pelajaran=b.kode_pelajaran 
                                    where a.kode_kelas='$_GET[kelas]' AND a.id_tahun_akademik='$_GET[tahun]' AND b.id_kelompok_mata_pelajaran='$k[id_kelompok_mata_pelajaran]'");
          $no = 1;
          $jumlah_sum = 0;
          while ($m = mysql_fetch_array($mapel)){                                
          $ta = mysql_fetch_array(mysql_query("SELECT kodejdwl, nisn, sum(nilai1)/count(nisn) as uh, sum(nilai2)/count(nisn) as tugas 
FROM `rb_nilai_pengetahuan` where nisn='$_GET[id]' AND kodejdwl='$m[kodejdwl]' GROUP BY kodejdwl"));
 
$sms = mysql_fetch_array(mysql_query("SELECT * FROM rb_nilai_pengetahuan_semester 
where kodejdwl='$m[kodejdwl]' AND nisn='$_GET[id]'"));
 
$nilai_pengetahuan = number_format(($ta[uh]+$ta[tugas]+$sms[nilai1]+$sms[nilai2])/4);
$jumlah_sum = $jumlah_sum + $nilai_pengetahuan;
          $cekpredikat = mysql_num_rows(mysql_query("SELECT * FROM rb_predikat where kode_kelas='$_GET[kelas]'"));
              if ($cekpredikat >= 1){
                  $grade3 = mysql_fetch_array(mysql_query("SELECT * FROM `rb_predikat` where (".number_format($rapn[raport])." >=nilai_a) AND (".number_format($rapn[raport])." <= nilai_b) AND kode_kelas='$_GET[kelas]'"));
              }else{
                  $grade3 = mysql_fetch_array(mysql_query("SELECT * FROM `rb_predikat` where (".number_format($rapn[raport])." >=nilai_a) AND (".number_format($rapn[raport])." <= nilai_b) AND kode_kelas='0'"));
              }
 
          $rapnk = mysql_fetch_array(mysql_query("SELECT sum(GREATEST(nilai1,nilai2,nilai3,nilai4,nilai5,nilai6))/count(nisn) as raport FROM rb_nilai_keterampilan where kodejdwl='$m[kodejdwl]' AND nisn='$s[nisn]'"));
          $cekpredikat2 = mysql_num_rows(mysql_query("SELECT * FROM rb_predikat where kode_kelas='$_GET[kelas]'"));
              if ($cekpredikat2 >= 1){
                  $grade = mysql_fetch_array(mysql_query("SELECT * FROM `rb_predikat` where (".number_format($rapnk[raport])." >=nilai_a) AND (".number_format($rapnk[raport])." <= nilai_b) AND kode_kelas='$_GET[kelas]'"));
              }else{
                  $grade = mysql_fetch_array(mysql_query("SELECT * FROM `rb_predikat` where (".number_format($rapnk[raport])." >=nilai_a) AND (".number_format($rapnk[raport])." <= nilai_b) AND kode_kelas='0'"));
              }
          $des = mysql_fetch_array(mysql_query("SELECT * FROM rb_ledger where kodejdwl='$m[kodejdwl]' AND nisn='$_GET[id]' AND kode_kelas='$_GET[kelas]'"));   
          echo "<tr>
                  <td align=center>$no</td>
                  <td>$m[namamatapelajaran]</td>
                  <td align=center>$m[kkm]</td>
                  <td align=center>".number_format($nilai_pengetahuan)."</td>
                  <td>".ucwords(terbilang(number_format($nilai_pengetahuan)))."</td>
                  <td align=center>".number_format($rapnk[raport])."</td>
                  <td>".ucwords(terbilang(number_format($rapnk[raport])))."</td>
                  <td align=center>$des[sikap]</td>
              </tr>";
          $no++;
          }
        }
 
        $ta = mysql_fetch_array(mysql_query("SELECT kodejdwl, nisn, sum(nilai1)/count(nisn) as uh, sum(nilai2)/count(nisn) as tugas 
FROM `rb_nilai_pengetahuan` where nisn='$_GET[id]' AND kodejdwl='$m[kodejdwl]' GROUP BY kodejdwl"));        
$rapnk = mysql_fetch_array(mysql_query("SELECT sum(raport) as raporttotal FROM (SELECT sum(GREATEST(nilai1,nilai2,nilai3,nilai4,nilai5,nilai6))/count(nisn) as raport FROM rb_nilai_keterampilan where nisn='$_GET[id]' GROUP BY kodejdwl) as a"));
        $siswa = mysql_num_rows(mysql_query("SELECT * FROM rb_siswa where kode_kelas='$_GET[kelas]'"));
        $rank = mysql_fetch_array(mysql_query("SELECT * FROM rb_peringkat where nisn='$_GET[id]' AND kode_kelas='$_GET[kelas]' AND id_tahun_akademik='$_GET[tahun]'"));
        echo "<tr>
                <td colspan='3' align=center><b>JUMLAH</b></td>
                <td align=center><b>".number_format($jumlah_sum)."</b></td>
                <td align=center></td>
                <td align=center><b>".number_format($rapnk[raporttotal])."</b></td>
                <td align=center></td>
                <td></td>
            </tr>"; 
 
        echo "<tr>
                <td align=center><b></b></td>
                <td><b>PERINGKAT</b></td>
                <td align=center><b>$rank[rank]</b></td>
                <td colspan='2'><b>Dari $siswa Siswa</b></td>
                <td align=center></td>
                <td align=center></td>
                <td></td>
            </tr>"; 
 
        echo "</table><br/>";
?>
 
<table border=0 width=100%>
  <tr>
    <td width="260" align="left">Orang Tua / Wali</td>
    <td width="520"align="center">Mengetahui <br> Kepala SMK Plus AL-MAFTUH</td>
    <td width="260" align="left">Sukabumi, <?php echo tgl_raport(date("Y-m-d")); ?> <br> Wali Kelas</td>
  </tr>
  <tr>
    <td align="left"><br /><br /><br /><br /><br />
      ................................... <br /><br /></td>
 
    <td align="center" valign="top"><br /><br /><br /><br /><br />
      <b>ASEP ABDUL AZIZ, S.Pd<br>
        NIP : -</b>
    </td>
 
    <td align="left" valign="top"><br /><br /><br /><br /><br />
      <b><?php echo $s[walikelas]; ?><br />
      NRY : <?php echo $s[nip]; ?></b>
    </td>
  </tr>
</table> 
</body>

Rahmat Sasmita commented on 04 Des 2017 11:59:32 Sultan Account

	Ko yang terjumlahkan hanya pada bagian kelompok mapel terakhir,,, tidak semua kelompok mapel pk robby Terdapat 1 File dilampirkan : 1. 1234567.png (46 KB)

Rahmat Sasmita commented on 05 Des 2017 15:04:20 Sultan Account

	up pak robby saya mau print raport

PHPMU.COM Support commented on 05 Des 2017 19:11:38 Sultan Account

	Coba pindahkan $jumlah_sum = 0; di atas query kelompok, jadi posisinya gini : $jumlah_sum = 0; $kelompok = mysql_query("SELECT * FROM rb_kelompok_mata_pelajaran");

Rahmat Sasmita commented on 05 Des 2017 21:36:08 Sultan Account

	Siap pak Robbyy.... Solved. :) Terima Kasih

Maaf, Untuk Memberikan Komentar Anda Harus Login !!!

	BSI - Bank Syariah Indonesia (451)

	ROBBY PRIHANDAYA
	1043-5665-19


	Bank Muamalat (147)
	ROBBY PRIHANDAYA
	4220-0174-81

Hallo! Selamat Datang di Marketplace produk digital, Freelancer terbaik di indonesia (67495 Members, 783 Products, 5291 Topic, 12956 Comments)

Masalah perhitungan pada Nilai Raport SIASELAH KTSP

Ada 20 Jawaban

Projects Remote

Hot Questions

Tentang Kami

Jam Layanan

Knowledgebase