Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include "koneksi.php";
- require "../function.php";
- $idn="select * from identitas";
- $que=mysql_query($idn,$db);
- $i=mysql_fetch_array($que);
- $edit=$_GET['edit'];
- $jur=$_GET['jur'];
- $sm=$_GET['sm'];
- $thn=$_GET['thn'];
- $kepsek="select * from kepsek where tahun_ajaran = '$thn' and semester='$sm'";
- $que=mysql_query($kepsek,$db);
- $k=mysql_fetch_array($que);
- $quepakademik=mysql_query("SELECT p.*,g.NAMA_GURU,g.NIP,g.`status` FROM pakademik p LEFT JOIN guru g on p.id_guru=g.ID_GURU
- WHERE p.id_akademik='$edit'");
- $pak=mysql_fetch_array($quepakademik);
- $guru_pakademik=$pak['NAMA_GURU'];
- if($pak['status']==1){
- $nip_pakademik='';
- } else {
- $nip_pakademik='NIP. '.$pak['NIP']; }
- $sql_tgl="select * from tgl_raport where semester='$sm' and tahun_ajaran = '$thn'";
- $que_tgl=mysql_query($sql_tgl);
- $t=mysql_fetch_array($que_tgl);
- $nam="SELECT w.id_wali_kelas,a.id_akademik, s.NIS,s.NISN, s.NAMA_SISWA
- , s.JENIS_KELAMIN,r.kode_ruang_kelas, r.jurusan,r.kelas
- , a.semester, a.tahun_ajaran , g.NAMA_GURU, g.NIP,g.status
- FROM akademik as a, siswa as s, ruang_kelas as r, wali_kelas as w, guru as g
- WHERE a.id_siswa=s.NIS
- and a.id_akademik='$edit'
- and a.id_ruang_kelas=r.id_ruang_kelas
- and a.tahun_ajaran=w.tahun_ajaran
- and w.id_guru=g.ID_GURU
- and a.id_ruang_kelas=w.id_ruang_kelas
- ";
- $vi=mysql_query($nam,$db);
- $ew=mysql_fetch_array($vi);
- // $quekkm=mysql_query("SELECT * FROM kkm WHERE kelas='$ew[kelas]'");
- // $km=mysql_fetch_array($quekkm);
- // $kkm=$km['kkm'];
- // $idkkm=$km['idkkm'];
- $mu=$ew['id_wali_kelas'];
- if($ew['status']!='1'){
- $nip='NIP '.$ew['NIP'];
- }else{
- $nip='';
- }
- $kel_a=
- "
- SELECT pel.kode_mapel,pel.nama_mapel, g.ID_GURU,g.NAMA_GURU
- ,t.kd1 as tu1,t.kd2 as tu2,t.kd3 as tu3,t.kd4 as tu4,t.kd5 as tu5
- ,li.kd1 as li1,li.kd2 as li2,li.kd3 as li3,li.kd4 as li4,li.kd5 as li5
- ,tgs.kd1 as tgs1, tgs.kd2 as tgs2, tgs.kd3 as tgs3, tgs.kd4 as tgs4, tgs.kd5 as tgs5
- ,uj.uts, uj.uas
- ,pra.kd1 as pra1, pra.kd2 as pra2, pra.kd3 as pra3, pra.kd4 as pra4, pra.kd5 as pra5
- ,pro.kd1 as pro1, pro.kd2 as pro2, pro.kd3 as pro3, pro.kd4 as pro4, pro.kd5 as pro5
- ,pof.kd1 as por1, pof.kd2 as por2, pof.kd3 as por3, pof.kd4 as por4, pof.kd5 as por5
- ,pos.proses1 as pos1, pos.proses2 as pos2, pos.proses3 as pos3, pos.proses4 as pos4, pos.proses5 as pos5
- FROM akademik as a INNER JOIN mengajar as m on a.id_ruang_kelas=m.id_ruang_kelas and a.semester=m.semester and a.tahun_ajaran=m.tahun_ajaran
- INNER JOIN siswa as s on a.id_siswa=s.NIS
- INNER JOIN guru as g on m.id_guru=g.ID_GURU
- INNER JOIN mapel as pel on m.kode_mapel=pel.kode_mapel
- LEFT JOIN tes_tulis as t on a.id_akademik=t.id_akademik and m.kode_mapel=t.kode_mapel and t.kode_mapel=pel.kode_mapel
- LEFT JOIN tes_lisan as li on a.id_akademik=li.id_akademik and m.kode_mapel=li.kode_mapel and li.kode_mapel=pel.kode_mapel
- LEFT JOIN tugas as tgs on a.id_akademik=tgs.id_akademik and m.kode_mapel=tgs.kode_mapel and tgs.kode_mapel=pel.kode_mapel
- LEFT JOIN ujian as uj on a.id_akademik=uj.id_akademik and m.kode_mapel=uj.kode_mapel and uj.kode_mapel=pel.kode_mapel
- LEFT JOIN tes_praktik as pra on a.id_akademik=pra.id_akademik and m.kode_mapel=pra.kode_mapel and pra.kode_mapel=pel.kode_mapel
- LEFT JOIN tes_projek as pro on a.id_akademik=pro.id_akademik and m.kode_mapel=pro.kode_mapel and pro.kode_mapel=pel.kode_mapel
- LEFT JOIN tes_portofolio as pof on a.id_akademik=pof.id_akademik and m.kode_mapel=pof.kode_mapel and pof.kode_mapel=pel.kode_mapel
- LEFT JOIN tes_proses as pos on a.id_akademik=pos.id_akademik and m.kode_mapel=pos.kode_mapel and pos.kode_mapel=pel.kode_mapel
- WHERE a.id_akademik='$edit'
- and pel.jurusan='UMUM'
- and pel.kelompok='A'
- and m.semester='$sm'
- and m.tahun_ajaran='$thn'
- ORDER BY kode_mapel
- ";
- $que_a=mysql_query($kel_a,$db);
- $disk_a=mysql_query($kel_a,$db);
- $kel_b=
- "
- SELECT pel.kode_mapel,pel.nama_mapel, g.ID_GURU,g.NAMA_GURU
- ,t.kd1 as tu1,t.kd2 as tu2,t.kd3 as tu3,t.kd4 as tu4,t.kd5 as tu5
- ,li.kd1 as li1,li.kd2 as li2,li.kd3 as li3,li.kd4 as li4,li.kd5 as li5
- ,tgs.kd1 as tgs1, tgs.kd2 as tgs2, tgs.kd3 as tgs3, tgs.kd4 as tgs4, tgs.kd5 as tgs5
- ,uj.uts, uj.uas
- ,pra.kd1 as pra1, pra.kd2 as pra2, pra.kd3 as pra3, pra.kd4 as pra4, pra.kd5 as pra5
- ,pro.kd1 as pro1, pro.kd2 as pro2, pro.kd3 as pro3, pro.kd4 as pro4, pro.kd5 as pro5
- ,pof.kd1 as por1, pof.kd2 as por2, pof.kd3 as por3, pof.kd4 as por4, pof.kd5 as por5
- ,pos.proses1 as pos1, pos.proses2 as pos2, pos.proses3 as pos3, pos.proses4 as pos4, pos.proses5 as pos5
- FROM akademik as a INNER JOIN mengajar as m on a.id_ruang_kelas=m.id_ruang_kelas and a.semester=m.semester and a.tahun_ajaran=m.tahun_ajaran
- INNER JOIN siswa as s on a.id_siswa=s.NIS
- INNER JOIN guru as g on m.id_guru=g.ID_GURU
- INNER JOIN mapel as pel on m.kode_mapel=pel.kode_mapel
- LEFT JOIN tes_tulis as t on a.id_akademik=t.id_akademik and m.kode_mapel=t.kode_mapel and t.kode_mapel=pel.kode_mapel
- LEFT JOIN tes_lisan as li on a.id_akademik=li.id_akademik and m.kode_mapel=li.kode_mapel and li.kode_mapel=pel.kode_mapel
- LEFT JOIN tugas as tgs on a.id_akademik=tgs.id_akademik and m.kode_mapel=tgs.kode_mapel and tgs.kode_mapel=pel.kode_mapel
- LEFT JOIN ujian as uj on a.id_akademik=uj.id_akademik and m.kode_mapel=uj.kode_mapel and uj.kode_mapel=pel.kode_mapel
- LEFT JOIN tes_praktik as pra on a.id_akademik=pra.id_akademik and m.kode_mapel=pra.kode_mapel and pra.kode_mapel=pel.kode_mapel
- LEFT JOIN tes_projek as pro on a.id_akademik=pro.id_akademik and m.kode_mapel=pro.kode_mapel and pro.kode_mapel=pel.kode_mapel
- LEFT JOIN tes_portofolio as pof on a.id_akademik=pof.id_akademik and m.kode_mapel=pof.kode_mapel and pof.kode_mapel=pel.kode_mapel
- LEFT JOIN tes_proses as pos on a.id_akademik=pos.id_akademik and m.kode_mapel=pos.kode_mapel and pos.kode_mapel=pel.kode_mapel
- WHERE a.id_akademik='$edit'
- and pel.jurusan='UMUM'
- and pel.kelompok='B'
- and m.semester='$sm'
- and m.tahun_ajaran='$thn'
- ORDER BY kode_mapel
- ";
- $que_b=mysql_query($kel_b,$db);
- $disk_b=mysql_query($kel_b,$db);
- $kel_c="
- SELECT pel.kode_mapel,pel.nama_mapel, g.ID_GURU,g.NAMA_GURU
- ,t.kd1 as tu1,t.kd2 as tu2,t.kd3 as tu3,t.kd4 as tu4,t.kd5 as tu5
- ,li.kd1 as li1,li.kd2 as li2,li.kd3 as li3,li.kd4 as li4,li.kd5 as li5
- ,tgs.kd1 as tgs1, tgs.kd2 as tgs2, tgs.kd3 as tgs3, tgs.kd4 as tgs4, tgs.kd5 as tgs5
- ,uj.uts, uj.uas
- ,pra.kd1 as pra1, pra.kd2 as pra2, pra.kd3 as pra3, pra.kd4 as pra4, pra.kd5 as pra5
- ,pro.kd1 as pro1, pro.kd2 as pro2, pro.kd3 as pro3, pro.kd4 as pro4, pro.kd5 as pro5
- ,pof.kd1 as por1, pof.kd2 as por2, pof.kd3 as por3, pof.kd4 as por4, pof.kd5 as por5
- ,pos.proses1 as pos1, pos.proses2 as pos2, pos.proses3 as pos3, pos.proses4 as pos4, pos.proses5 as pos5
- FROM akademik as a INNER JOIN mengajar as m on a.id_ruang_kelas=m.id_ruang_kelas and a.semester=m.semester and a.tahun_ajaran=m.tahun_ajaran
- INNER JOIN siswa as s on a.id_siswa=s.NIS
- INNER JOIN guru as g on m.id_guru=g.ID_GURU
- INNER JOIN mapel as pel on m.kode_mapel=pel.kode_mapel
- LEFT JOIN tes_tulis as t on a.id_akademik=t.id_akademik and m.kode_mapel=t.kode_mapel and t.kode_mapel=pel.kode_mapel
- LEFT JOIN tes_lisan as li on a.id_akademik=li.id_akademik and m.kode_mapel=li.kode_mapel and li.kode_mapel=pel.kode_mapel
- LEFT JOIN tugas as tgs on a.id_akademik=tgs.id_akademik and m.kode_mapel=tgs.kode_mapel and tgs.kode_mapel=pel.kode_mapel
- LEFT JOIN ujian as uj on a.id_akademik=uj.id_akademik and m.kode_mapel=uj.kode_mapel and uj.kode_mapel=pel.kode_mapel
- LEFT JOIN tes_praktik as pra on a.id_akademik=pra.id_akademik and m.kode_mapel=pra.kode_mapel and pra.kode_mapel=pel.kode_mapel
- LEFT JOIN tes_projek as pro on a.id_akademik=pro.id_akademik and m.kode_mapel=pro.kode_mapel and pro.kode_mapel=pel.kode_mapel
- LEFT JOIN tes_portofolio as pof on a.id_akademik=pof.id_akademik and m.kode_mapel=pof.kode_mapel and pof.kode_mapel=pel.kode_mapel
- LEFT JOIN tes_proses as pos on a.id_akademik=pos.id_akademik and m.kode_mapel=pos.kode_mapel and pos.kode_mapel=pel.kode_mapel
- WHERE a.id_akademik='$edit'
- and pel.jurusan='$jur'
- and m.semester='$sm'
- and m.tahun_ajaran='$thn'
- ORDER BY kode_mapel
- ";
- $que_c=mysql_query($kel_c,$db);
- $disk_c=mysql_query($kel_c,$db);
- $kel_d="
- SELECT pel.kode_mapel,pel.nama_mapel, g.ID_GURU,g.NAMA_GURU
- ,t.kd1 as tu1,t.kd2 as tu2,t.kd3 as tu3,t.kd4 as tu4,t.kd5 as tu5
- ,li.kd1 as li1,li.kd2 as li2,li.kd3 as li3,li.kd4 as li4,li.kd5 as li5
- ,tgs.kd1 as tgs1, tgs.kd2 as tgs2, tgs.kd3 as tgs3, tgs.kd4 as tgs4, tgs.kd5 as tgs5
- ,uj.uts, uj.uas
- ,pra.kd1 as pra1, pra.kd2 as pra2, pra.kd3 as pra3, pra.kd4 as pra4, pra.kd5 as pra5
- ,pro.kd1 as pro1, pro.kd2 as pro2, pro.kd3 as pro3, pro.kd4 as pro4, pro.kd5 as pro5
- ,pof.kd1 as por1, pof.kd2 as por2, pof.kd3 as por3, pof.kd4 as por4, pof.kd5 as por5
- ,pos.proses1 as pos1, pos.proses2 as pos2, pos.proses3 as pos3, pos.proses4 as pos4, pos.proses5 as pos5
- FROM akademik as a INNER JOIN mengajar as m on a.id_ruang_kelas=m.id_ruang_kelas and a.semester=m.semester and a.tahun_ajaran=m.tahun_ajaran
- INNER JOIN siswa as s on a.id_siswa=s.NIS
- INNER JOIN guru as g on m.id_guru=g.ID_GURU
- INNER JOIN mapel as pel on m.kode_mapel=pel.kode_mapel
- LEFT JOIN tes_tulis as t on a.id_akademik=t.id_akademik and m.kode_mapel=t.kode_mapel and t.kode_mapel=pel.kode_mapel
- LEFT JOIN tes_lisan as li on a.id_akademik=li.id_akademik and m.kode_mapel=li.kode_mapel and li.kode_mapel=pel.kode_mapel
- LEFT JOIN tugas as tgs on a.id_akademik=tgs.id_akademik and m.kode_mapel=tgs.kode_mapel and tgs.kode_mapel=pel.kode_mapel
- LEFT JOIN ujian as uj on a.id_akademik=uj.id_akademik and m.kode_mapel=uj.kode_mapel and uj.kode_mapel=pel.kode_mapel
- LEFT JOIN tes_praktik as pra on a.id_akademik=pra.id_akademik and m.kode_mapel=pra.kode_mapel and pra.kode_mapel=pel.kode_mapel
- LEFT JOIN tes_projek as pro on a.id_akademik=pro.id_akademik and m.kode_mapel=pro.kode_mapel and pro.kode_mapel=pel.kode_mapel
- LEFT JOIN tes_portofolio as pof on a.id_akademik=pof.id_akademik and m.kode_mapel=pof.kode_mapel and pof.kode_mapel=pel.kode_mapel
- LEFT JOIN tes_proses as pos on a.id_akademik=pos.id_akademik and m.kode_mapel=pos.kode_mapel and pos.kode_mapel=pel.kode_mapel
- WHERE a.id_akademik='$edit'
- and pel.jurusan!='$jur'
- and pel.lintas_peminatan=1
- and m.semester='$sm'
- and m.tahun_ajaran='$thn'
- ORDER BY kode_mapel
- ";
- $que_d=mysql_query($kel_d,$db);
- $disk_d=mysql_query($kel_d,$db);
- $eks="SELECT e.nama_ekskul, n.nilai, n.keterangan
- FROM nilai_eks as n, akademik as a, siswa as s, ekskul as e
- WHERE n.id_akademik=a.id_akademik
- and n.id_ekskul=e.id_ekskul
- and a.id_siswa=s.NIS
- and a.id_akademik='$edit'";
- $que_eks=mysql_query($eks,$db);
- $hadir="SELECT k.sakit, k.izin, k.tanpa_keterangan
- FROM kehadiran as k, akademik as a, siswa as s
- WHERE k.id_akademik=a.id_akademik
- and a.id_siswa=s.NIS
- and a.id_akademik='$edit'";
- $que_hadir=mysql_query($hadir,$db);
- $kel_e=
- "
- SELECT pel.kode_mapel,pel.nama_mapel, g.ID_GURU,g.NAMA_GURU
- ,t.kd1 as tu1,t.kd2 as tu2,t.kd3 as tu3,t.kd4 as tu4,t.kd5 as tu5
- ,li.kd1 as li1,li.kd2 as li2,li.kd3 as li3,li.kd4 as li4,li.kd5 as li5
- ,tgs.kd1 as tgs1, tgs.kd2 as tgs2, tgs.kd3 as tgs3, tgs.kd4 as tgs4, tgs.kd5 as tgs5
- ,uj.uts, uj.uas
- ,pra.kd1 as pra1, pra.kd2 as pra2, pra.kd3 as pra3, pra.kd4 as pra4, pra.kd5 as pra5
- ,pro.kd1 as pro1, pro.kd2 as pro2, pro.kd3 as pro3, pro.kd4 as pro4, pro.kd5 as pro5
- ,pof.kd1 as por1, pof.kd2 as por2, pof.kd3 as por3, pof.kd4 as por4, pof.kd5 as por5
- ,pos.proses1 as pos1, pos.proses2 as pos2, pos.proses3 as pos3, pos.proses4 as pos4, pos.proses5 as pos5
- FROM akademik as a INNER JOIN mengajar as m on a.id_ruang_kelas=m.id_ruang_kelas and a.semester=m.semester and a.tahun_ajaran=m.tahun_ajaran
- INNER JOIN siswa as s on a.id_siswa=s.NIS
- INNER JOIN guru as g on m.id_guru=g.ID_GURU
- INNER JOIN mapel as pel on m.kode_mapel=pel.kode_mapel
- LEFT JOIN tes_tulis as t on a.id_akademik=t.id_akademik and m.kode_mapel=t.kode_mapel and t.kode_mapel=pel.kode_mapel
- LEFT JOIN tes_lisan as li on a.id_akademik=li.id_akademik and m.kode_mapel=li.kode_mapel and li.kode_mapel=pel.kode_mapel
- LEFT JOIN tugas as tgs on a.id_akademik=tgs.id_akademik and m.kode_mapel=tgs.kode_mapel and tgs.kode_mapel=pel.kode_mapel
- LEFT JOIN ujian as uj on a.id_akademik=uj.id_akademik and m.kode_mapel=uj.kode_mapel and uj.kode_mapel=pel.kode_mapel
- LEFT JOIN tes_praktik as pra on a.id_akademik=pra.id_akademik and m.kode_mapel=pra.kode_mapel and pra.kode_mapel=pel.kode_mapel
- LEFT JOIN tes_projek as pro on a.id_akademik=pro.id_akademik and m.kode_mapel=pro.kode_mapel and pro.kode_mapel=pel.kode_mapel
- LEFT JOIN tes_portofolio as pof on a.id_akademik=pof.id_akademik and m.kode_mapel=pof.kode_mapel and pof.kode_mapel=pel.kode_mapel
- LEFT JOIN tes_proses as pos on a.id_akademik=pos.id_akademik and m.kode_mapel=pos.kode_mapel and pos.kode_mapel=pel.kode_mapel
- WHERE a.id_akademik='$edit'
- and pel.jurusan='UMUM'
- and pel.kelompok='D'
- and m.semester='$sm'
- and m.tahun_ajaran='$thn'
- ORDER BY kode_mapel
- ";
- $que_e=mysql_query($kel_e,$db);
- $disk_e=mysql_query($kel_e,$db);
- // $sub_bebanjp= array();
- // $sub_nxb=array();
- // $tkkm = mysql_query("SELECT * FROM kkm
- // WHERE semester='$semester_aktif'
- // and tahun_ajaran='$tahun_aktif'");
- $sppredikat = mysql_query("SELECT nilai FROM spiritual_nilai
- WHERE id_akademik='$edit'");
- $spval = array();
- while($spvals = mysql_fetch_array($sppredikat))
- {
- $spval[] = $spvals['nilai'];
- }
- $valsp = mmmr($spval, 'mode');
- $diskSp1 = predikatdiskripsi($valsp);
- $soval = array();
- $sopredikat = mysql_query("SELECT nilai FROM sosial_nilai
- WHERE id_akademik='$edit'");
- while($sovals = mysql_fetch_array($sopredikat))
- {
- $soval[] = $sovals['nilai'];
- }
- $valso = mmmr($soval, 'mode');
- $diskSo1 = predikatdiskripsi($valso);
- $diskripsiSp = mysql_query("SELECT sn.*,pd.diskripsi predisk,sd.diskripsi FROM spiritual_nilai sn
- LEFT JOIN predikat_diskripsi pd on sn.nilai=pd.predikat
- LEFT JOIN spiritual_diskripsi sd ON sn.id_spiritual=sd.id
- WHERE sn.id_akademik='$edit'");
- $diskripsiSo = mysql_query("SELECT sn.*,pd.diskripsi predisk,sd.diskripsi FROM sosial_nilai sn
- LEFT JOIN predikat_diskripsi pd on sn.nilai=pd.predikat
- LEFT JOIN sosial_diskripsi sd ON sn.id_sosial=sd.id
- WHERE sn.id_akademik='$edit'");
- /* $diskripsiraportSp = "Secara Umum Sikap Spiritual Pesera Didik ".$diskSp1.". ";
- while($diskSp = mysql_fetch_array($diskripsiSp))
- {
- $diskripsiraportSp .= $diskSp['predisk']." dalam ".$diskSp['diskripsi']." ";
- }
- $diskripsiraportSo = "Secara Umum Sikap Sosial Peserta Didik ".$diskSo1.". ";
- while($diskSo = mysql_fetch_array($diskripsiSo))
- {
- $diskripsiraportSo .= $diskSo['predisk']." dalam ".$diskSo['diskripsi']." ";
- }*/
- $diskripsiraportSp = "Selalu ";
- while($diskSp = mysql_fetch_array($diskripsiSp))
- {
- $diskripsiraportSp .= "".$diskSp['diskripsi']." ";
- }
- $diskripsiraportSo = "Sikap Sosial Peserta Didik ".$diskSo1." dalam ";
- while($diskSo = mysql_fetch_array($diskripsiSo))
- {
- $diskripsiraportSo .= "".$diskSo['diskripsi']." ";
- }
- $datanilaip=array();
- $datanilaik=array();
- ?>
- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
- <html xmlns="http://www.w3.org/1999/xhtml">
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
- <LINK rel="stylesheet" type"text/css" href="../print.css" media="print">
- <title>SILACAK Capaian <?=$ew['NIS']?> <?=$ew['NAMA_SISWA']?></title>
- <style type="text/css">
- .right_content table {
- text-align: center;
- width:900px;
- font-size:15px;
- }
- .right_content .kiri {
- text-align:left;
- padding:3px;}
- .vtop{vertical-align: top;}
- .style2 {font-size: 12; }
- </style>
- <script type="text/javascript">
- function printPage() { print(document); }
- </script>
- </head>
- <body>
- <div align="center" style="width:auto;" class="right_content">
- <div id="header" align="center">
- <!--<img src="../img/kopsma.PNG" width="900" height="130" />-->
- </div>
- <table width="529" class="kiri">
- <tr>
- <td>Nama Madrasah </td>
- <td>:</td>
- <td><?=$i['nama_sekolah']?></td>
- <td> </td>
- <td>Kelas</td>
- <td>:</td>
- <td><?=$ew['kode_ruang_kelas']?></td>
- </tr>
- <tr>
- <td>Alamat</td>
- <td>:</td>
- <td><?=$i['alamat_sekolah']?></td>
- <td> </td>
- <td>Semester</td>
- <td>:</td>
- <td><?=$ew['semester']?> <?=nomor($ew['semester'])?></td>
- </tr>
- <tr>
- <td>Nama Peserta Didik</td>
- <td>:</td>
- <td><?=$ew['NAMA_SISWA']?></td>
- <td> </td>
- <td>Tahun Pelajaran</td>
- <td>:</td>
- <td><?=$ew['tahun_ajaran']?></td>
- </tr>
- <tr>
- <td>Nomor Induk/NISN</td>
- <td>:</td>
- <td><?=$ew['NIS']?>/<?=$ew['NISN']?></td>
- <td> </td>
- <td> </td>
- <td> </td>
- <td> </td>
- </tr>
- <tr>
- <td> </td>
- <td> </td>
- <td> </td>
- <td> </td>
- <td> </td>
- <td> </td>
- <td> </td>
- </tr>
- <tr>
- <td></td>
- <td> </td>
- <td> </td>
- <td> </td>
- <td colspan="3"><div id="atas"><img align="right" onClick="printPage()" style="cursor:pointer;" title="Klik Untuk Mencetak Halaman" src="../img/PRINTER.PNG" alt="printer" width="20" height="20" /></div></td>
- </tr>
- </table>
- <table width="529" border="0" cellspacing="0" cellpadding="3">
- <tr><td><b>CAPAIAN HASIL BELAJAR</b></td></tr>
- <tr>
- <td align="left"><b>A. Sikap</b></td>
- </tr>
- <tr>
- <td align="left"><b>1. Sikap Spiritual</b></td>
- </tr>
- <tr>
- <td>
- <table border="1" cellpadding="5" cellspacing="0">
- <tr class="kiri">
- <td><div align="center">Predikat</div></td>
- <td><div align="center">Deskripsi</div></td>
- </tr>
- <tr class="vtop" height="90">
- <td width="100"><?=$valsp?></td>
- <td class="kiri"><div align="justify">
- <?=$diskripsiraportSp?>
- </div></td>
- </tr>
- </table>
- </td>
- </tr>
- <tr>
- <td align="left"><b>2. Sikap Sosial</b></td>
- </tr>
- <tr>
- <td>
- <table border="1" cellpadding="5" cellspacing="0">
- <tr class="kiri">
- <td><div align="center">Predikat</div></td>
- <td><div align="center">Deskripsi</div></td>
- </tr>
- <tr class="vtop" height="25">
- <td width="100"><?=$valso?></td>
- <td class="kiri"><div align="justify">
- <?=$diskripsiraportSo?>
- </div></td>
- </tr>
- </table>
- </td>
- </tr>
- </table>
- <br>
- <table width="529" border="0" cellpadding="3" cellspacing="0">
- <tr>
- <td align="left"><label><b>B. Pengetahuan dan Keterampilan</b></label></td>
- </tr>
- </table>
- <table width="529" border="1" cellpadding="0" cellspacing="0">
- <tr>
- <th colspan="2" rowspan="2">Mata Pelajaran</th>
- <th rowspan="2">KKM</th>
- <!-- <th rowspan="2">Beban<br>/JP<br>(B)</th> -->
- <th colspan="2">Pengetahuan</th>
- <th colspan="2">Ketrampilan</th>
- <!-- <th rowspan="2">Rata-<br>rata<br>(N)</th> -->
- <!-- <th rowspan="2">NxB</th> -->
- </tr>
- <tr>
- <th>Angka</th>
- <th>Predikat</th>
- <th>Angka</th>
- <th>Predikat</th>
- </tr>
- <?php
- $mu=$ew['id_wali_kelas'];
- $map="SELECT m.diskripsi, m.tahun_ajaran, g.NAMA_GURU, g.NIP, w.id_wali_kelas, r.kode_ruang_kelas from diskripsi_m as m, wali_kelas as w, guru as g, ruang_kelas as r
- WHERE m.id_wali_kelas=w.id_wali_kelas
- and g.ID_GURU=w.id_guru
- and r.id_ruang_kelas=w.id_ruang_kelas
- and w.id_wali_kelas='$mu'
- "
- ;
- $ant=mysql_query($map,$db);
- $anpel=mysql_fetch_array($ant);
- ?>
- <tr>
- <th class="kiri" colspan="8">Kelompok A (Wajib)</td>
- </tr>
- <tr>
- <td>1</td>
- <th class="kiri" colspan="7">Pendidikan Agama dan Budi Pekerti</td>
- </tr>
- <?php
- $no=2;
- $c=0;
- $abc = 1;
- while ($n=mysql_fetch_array($que_a)){
- //proses nilai Pengetahuan
- $qutestulis = mysql_query("SELECT * FROM tes_tulis_n
- WHERE id_akademik='$edit'
- and kode_mapel='$n[kode_mapel]'");
- while( $row = mysql_fetch_assoc( $qutestulis))
- {
- $datanilaip[] = $row['nilai']; // Inside while loop
- }
- $quteslisan = mysql_query("SELECT * FROM tes_lisan_n
- WHERE id_akademik='$edit'
- and kode_mapel='$n[kode_mapel]'");
- while( $row = mysql_fetch_assoc( $quteslisan))
- {
- $datanilaip[] = $row['nilai']; // Inside while loop
- }
- $qutestugas = mysql_query("SELECT * FROM tes_tugas_n
- WHERE id_akademik='$edit'
- and kode_mapel='$n[kode_mapel]'");
- while( $row = mysql_fetch_assoc( $qutestugas))
- {
- $datanilaip[] = $row['nilai']; // Inside while loop
- }
- $rat_peng = mmmr($datanilaip);
- if(empty($rat_peng))
- {
- $rat_peng=0;
- }
- // return var_dump($rat_peng);
- // $rat_peng=rata($n['tu1'],$n['tu2'],$n['tu3'],$n['tu4'],$n['tu5']
- // ,$n['li1'],$n['li2'],$n['li3'],$n['li4'],$n['li5'],
- // $n['tgs1'],$n['tgs2'],$n['tgs3'],$n['tgs4'],$n['tgs5']);
- $konv_peng=konversi_100($rat_peng,$n['uts'],$n['uas']);
- //end poses nilai
- //proses nilai ketrampilan
- // $rat_praktek=rataTagihan($n['pra1'],$n['pra2'],$n['pra3'],$n['pra4'],$n['pra5']);
- // $rat_projek=rataTagihan($n['pro1'],$n['pro2'],$n['pro3'],$n['pro4'],$n['pro5']);
- // $rat_portofolio=rataTagihan($n['por1'],$n['por2'],$n['por3'],$n['por4'],$n['por5']);
- $qutespraktek = mysql_query("SELECT * FROM tes_praktek_n
- WHERE id_akademik='$edit'
- and kode_mapel='$n[kode_mapel]'");
- while( $row = mysql_fetch_assoc( $qutespraktek))
- {
- $datanilaik[] = $row['nilai']; // Inside while loop
- }
- $qutesprojek = mysql_query("SELECT * FROM tes_projek_n
- WHERE id_akademik='$edit'
- and kode_mapel='$n[kode_mapel]'");
- while( $row = mysql_fetch_assoc( $qutesprojek))
- {
- $datanilaik[] = $row['nilai']; // Inside while loop
- }
- $qutesportofolio = mysql_query("SELECT * FROM tes_portofolio_n
- WHERE id_akademik='$edit'
- and kode_mapel='$n[kode_mapel]'");
- while( $row = mysql_fetch_assoc( $qutesportofolio))
- {
- $datanilaik[] = $row['nilai']; // Inside while loop
- }
- $rat_ket = mmmr($datanilaik);
- if(empty($rat_ket))
- {
- $rat_ket=0;
- }
- // $rat_ket=rataKet($rat_praktek,$rat_projek,$rat_portofolio);
- $konv_ket=konv_100($rat_ket);
- //ending ketrampilan
- //ending sikap
- $datanilaip=[];
- $datanilaik=[];
- if($c!=$n['kode_mapel']) {
- $data = kkmmapel($n['kode_mapel'],$semester_aktif,$tahun_aktif); $kkm=$data['kkm']; $idkkmmapel=$data['idkkmmapel']; $predikatPeng=predikat_kkmmapel($idkkmmapel,$konv_peng); $predikatKet=predikat_kkmmapel($idkkmmapel,$konv_ket);
- $ratan=0;
- $ratan=($konv_peng+$konv_ket)/2;
- if($n['kode_mapel']>0 and $n['kode_mapel']<5) {
- ?>
- <tr>
- <td></td>
- <td class="kiri"><?=strtolower(chr(64+$abc++))?>. <?=$n['nama_mapel']?>
- <br /></td>
- <td><?=$kkm?></td>
- <!-- <td><?=$bebanjp?></td> -->
- <td><?=$konv_peng?></td>
- <td><?=$predikatPeng?></td>
- <td><?=$konv_ket?></td>
- <td><?=$predikatKet?></td>
- <!-- <td><?=$ratan?></td> -->
- <!-- <td><?=$nxb?></td> -->
- </tr>
- <?php
- }else{ ?>
- <tr>
- <td><?=$no?></td>
- <td class="kiri"><?=$n['nama_mapel']?></td>
- <td><?=$kkm?></td>
- <!-- <td><?=$bebanjp?></td> -->
- <td><?=$konv_peng?></td>
- <td><?=$predikatPeng?></td>
- <td><?=$konv_ket?></td>
- <td><?=$predikatKet?></td>
- <!-- <td><?=$ratan?></td> -->
- <!-- <td><?=$nxb?></td> -->
- </tr>
- <?php
- $no++;
- $c=$n['kode_mapel'];}}
- } ?>
- <tr>
- <th class="kiri" colspan="10">Kelompok B (Wajib)</th>
- </tr>
- <?php
- $no=1;
- $c=0;
- while ($n=mysql_fetch_array($que_b)){
- //proses nilai Pengetahuan
- $qutestulis = mysql_query("SELECT * FROM tes_tulis_n
- WHERE id_akademik='$edit'
- and kode_mapel='$n[kode_mapel]'");
- while( $row = mysql_fetch_assoc( $qutestulis))
- {
- $datanilaip[] = $row['nilai']; // Inside while loop
- }
- $quteslisan = mysql_query("SELECT * FROM tes_lisan_n
- WHERE id_akademik='$edit'
- and kode_mapel='$n[kode_mapel]'");
- while( $row = mysql_fetch_assoc( $quteslisan))
- {
- $datanilaip[] = $row['nilai']; // Inside while loop
- }
- $qutestugas = mysql_query("SELECT * FROM tes_tugas_n
- WHERE id_akademik='$edit'
- and kode_mapel='$n[kode_mapel]'");
- while( $row = mysql_fetch_assoc( $qutestugas))
- {
- $datanilaip[] = $row['nilai']; // Inside while loop
- }
- $rat_peng = mmmr($datanilaip);
- if(empty($rat_peng))
- {
- $rat_peng=0;
- }
- // return var_dump($rat_peng);
- // $rat_peng=rata($n['tu1'],$n['tu2'],$n['tu3'],$n['tu4'],$n['tu5']
- // ,$n['li1'],$n['li2'],$n['li3'],$n['li4'],$n['li5'],
- // $n['tgs1'],$n['tgs2'],$n['tgs3'],$n['tgs4'],$n['tgs5']);
- $konv_peng=konversi_100($rat_peng,$n['uts'],$n['uas']);
- //end poses nilai
- //proses nilai ketrampilan
- // $rat_praktek=rataTagihan($n['pra1'],$n['pra2'],$n['pra3'],$n['pra4'],$n['pra5']);
- // $rat_projek=rataTagihan($n['pro1'],$n['pro2'],$n['pro3'],$n['pro4'],$n['pro5']);
- // $rat_portofolio=rataTagihan($n['por1'],$n['por2'],$n['por3'],$n['por4'],$n['por5']);
- $qutespraktek = mysql_query("SELECT * FROM tes_praktek_n
- WHERE id_akademik='$edit'
- and kode_mapel='$n[kode_mapel]'");
- while( $row = mysql_fetch_assoc( $qutespraktek))
- {
- $datanilaik[] = $row['nilai']; // Inside while loop
- }
- $qutesprojek = mysql_query("SELECT * FROM tes_projek_n
- WHERE id_akademik='$edit'
- and kode_mapel='$n[kode_mapel]'");
- while( $row = mysql_fetch_assoc( $qutesprojek))
- {
- $datanilaik[] = $row['nilai']; // Inside while loop
- }
- $qutesportofolio = mysql_query("SELECT * FROM tes_portofolio_n
- WHERE id_akademik='$edit'
- and kode_mapel='$n[kode_mapel]'");
- while( $row = mysql_fetch_assoc( $qutesportofolio))
- {
- $datanilaik[] = $row['nilai']; // Inside while loop
- }
- $rat_ket = mmmr($datanilaik);
- if(empty($rat_ket))
- {
- $rat_ket=0;
- }
- // $rat_ket=rataKet($rat_praktek,$rat_projek,$rat_portofolio);
- $konv_ket=konv_100($rat_ket);
- //ending ketrampilan
- //ending sikap
- $datanilaip=[];
- $datanilaik=[];
- //ending sikap
- if($c!=$n['kode_mapel']) {
- $data = kkmmapel($n['kode_mapel'],$semester_aktif,$tahun_aktif); $kkm=$data['kkm']; $idkkmmapel=$data['idkkmmapel']; $predikatPeng=predikat_kkmmapel($idkkmmapel,$konv_peng); $predikatKet=predikat_kkmmapel($idkkmmapel,$konv_ket);
- $ratan=0;
- $ratan=($konv_peng+$konv_ket)/2;
- ?>
- <tr>
- <td><?=$no?></td>
- <td class="kiri"><?=$n['nama_mapel']?>
- <br /></td>
- <td><?=$kkm?></td>
- <!-- <td><?=$bebanjp?></td> -->
- <td><?=$konv_peng?></td>
- <td><?=$predikatPeng?></td>
- <td><?=$konv_ket?></td>
- <td><?=$predikatKet?></td>
- <!-- <td><?=$ratan?></td> -->
- <!-- <td><?=$nxb?></td> -->
- </tr>
- <?php $no++;
- $c=$n['kode_mapel'];
- }
- } ?>
- <tr>
- <td><?=$no?></td>
- <th class="kiri" colspan="9">Muatan Lokal</th>
- </tr>
- <?php
- $no=1;
- $c=0;
- $abc = 1;
- while ($n=mysql_fetch_array($que_e)){
- //proses nilai Pengetahuan
- $qutestulis = mysql_query("SELECT * FROM tes_tulis_n
- WHERE id_akademik='$edit'
- and kode_mapel='$n[kode_mapel]'");
- while( $row = mysql_fetch_assoc( $qutestulis))
- {
- $datanilaip[] = $row['nilai']; // Inside while loop
- }
- $quteslisan = mysql_query("SELECT * FROM tes_lisan_n
- WHERE id_akademik='$edit'
- and kode_mapel='$n[kode_mapel]'");
- while( $row = mysql_fetch_assoc( $quteslisan))
- {
- $datanilaip[] = $row['nilai']; // Inside while loop
- }
- $qutestugas = mysql_query("SELECT * FROM tes_tugas_n
- WHERE id_akademik='$edit'
- and kode_mapel='$n[kode_mapel]'");
- while( $row = mysql_fetch_assoc( $qutestugas))
- {
- $datanilaip[] = $row['nilai']; // Inside while loop
- }
- $rat_peng = mmmr($datanilaip);
- if(empty($rat_peng))
- {
- $rat_peng=0;
- }
- // return var_dump($rat_peng);
- // $rat_peng=rata($n['tu1'],$n['tu2'],$n['tu3'],$n['tu4'],$n['tu5']
- // ,$n['li1'],$n['li2'],$n['li3'],$n['li4'],$n['li5'],
- // $n['tgs1'],$n['tgs2'],$n['tgs3'],$n['tgs4'],$n['tgs5']);
- $konv_peng=konversi_100($rat_peng,$n['uts'],$n['uas']);
- //end poses nilai
- //proses nilai ketrampilan
- // $rat_praktek=rataTagihan($n['pra1'],$n['pra2'],$n['pra3'],$n['pra4'],$n['pra5']);
- // $rat_projek=rataTagihan($n['pro1'],$n['pro2'],$n['pro3'],$n['pro4'],$n['pro5']);
- // $rat_portofolio=rataTagihan($n['por1'],$n['por2'],$n['por3'],$n['por4'],$n['por5']);
- $qutespraktek = mysql_query("SELECT * FROM tes_praktek_n
- WHERE id_akademik='$edit'
- and kode_mapel='$n[kode_mapel]'");
- while( $row = mysql_fetch_assoc( $qutespraktek))
- {
- $datanilaik[] = $row['nilai']; // Inside while loop
- }
- $qutesprojek = mysql_query("SELECT * FROM tes_projek_n
- WHERE id_akademik='$edit'
- and kode_mapel='$n[kode_mapel]'");
- while( $row = mysql_fetch_assoc( $qutesprojek))
- {
- $datanilaik[] = $row['nilai']; // Inside while loop
- }
- $qutesportofolio = mysql_query("SELECT * FROM tes_portofolio_n
- WHERE id_akademik='$edit'
- and kode_mapel='$n[kode_mapel]'");
- while( $row = mysql_fetch_assoc( $qutesportofolio))
- {
- $datanilaik[] = $row['nilai']; // Inside while loop
- }
- $rat_ket = mmmr($datanilaik);
- if(empty($rat_ket))
- {
- $rat_ket=0;
- }
- // $rat_ket=rataKet($rat_praktek,$rat_projek,$rat_portofolio);
- $konv_ket=konv_100($rat_ket);
- //ending ketrampilan
- //ending sikap
- $datanilaip=[];
- $datanilaik=[];
- //ending sikap
- if($c!=$n['kode_mapel']) {
- $data = kkmmapel($n['kode_mapel'],$semester_aktif,$tahun_aktif); $kkm=$data['kkm']; $idkkmmapel=$data['idkkmmapel']; $predikatPeng=predikat_kkmmapel($idkkmmapel,$konv_peng); $predikatKet=predikat_kkmmapel($idkkmmapel,$konv_ket);
- $ratan=0;
- $ratan=$ratan=($konv_peng+$konv_ket)/2;
- ?>
- <tr>
- <td></td>
- <td class="kiri"><?=strtolower(chr(64+$abc++))?>. <?=$n['nama_mapel']?>
- <br /></td>
- <td><?=$kkm?></td>
- <!-- <td><?=$bebanjp?></td> -->
- <td><?=$konv_peng?></td>
- <td><?=$predikatPeng?></td>
- <td><?=$konv_ket?></td>
- <td><?=$predikatKet?></td>
- <!-- <td><?=$ratan?></td> -->
- <!-- <td><?=$nxb?></td> -->
- </tr>
- <?php $no++;
- $c=$n['kode_mapel'];}
- }
- ?>
- <tr>
- <th class="kiri" colspan="10">Kelompok C (Peminatan)</th>
- </tr>
- <tr>
- <th>I</th>
- <th class="kiri" colspan="9">Peminatan <?=ubah($ew['jurusan'])?></th>
- </tr>
- <?php
- $no=1;
- $c=0;
- while ($n=mysql_fetch_array($que_c)){
- //proses nilai Pengetahuan
- $qutestulis = mysql_query("SELECT * FROM tes_tulis_n
- WHERE id_akademik='$edit'
- and kode_mapel='$n[kode_mapel]'");
- while( $row = mysql_fetch_assoc( $qutestulis))
- {
- $datanilaip[] = $row['nilai']; // Inside while loop
- }
- $quteslisan = mysql_query("SELECT * FROM tes_lisan_n
- WHERE id_akademik='$edit'
- and kode_mapel='$n[kode_mapel]'");
- while( $row = mysql_fetch_assoc( $quteslisan))
- {
- $datanilaip[] = $row['nilai']; // Inside while loop
- }
- $qutestugas = mysql_query("SELECT * FROM tes_tugas_n
- WHERE id_akademik='$edit'
- and kode_mapel='$n[kode_mapel]'");
- while( $row = mysql_fetch_assoc( $qutestugas))
- {
- $datanilaip[] = $row['nilai']; // Inside while loop
- }
- $rat_peng = mmmr($datanilaip);
- if(empty($rat_peng))
- {
- $rat_peng=0;
- }
- // return var_dump($rat_peng);
- // $rat_peng=rata($n['tu1'],$n['tu2'],$n['tu3'],$n['tu4'],$n['tu5']
- // ,$n['li1'],$n['li2'],$n['li3'],$n['li4'],$n['li5'],
- // $n['tgs1'],$n['tgs2'],$n['tgs3'],$n['tgs4'],$n['tgs5']);
- $konv_peng=konversi_100($rat_peng,$n['uts'],$n['uas']);
- //end poses nilai
- //proses nilai ketrampilan
- // $rat_praktek=rataTagihan($n['pra1'],$n['pra2'],$n['pra3'],$n['pra4'],$n['pra5']);
- // $rat_projek=rataTagihan($n['pro1'],$n['pro2'],$n['pro3'],$n['pro4'],$n['pro5']);
- // $rat_portofolio=rataTagihan($n['por1'],$n['por2'],$n['por3'],$n['por4'],$n['por5']);
- $qutespraktek = mysql_query("SELECT * FROM tes_praktek_n
- WHERE id_akademik='$edit'
- and kode_mapel='$n[kode_mapel]'");
- while( $row = mysql_fetch_assoc( $qutespraktek))
- {
- $datanilaik[] = $row['nilai']; // Inside while loop
- }
- $qutesprojek = mysql_query("SELECT * FROM tes_projek_n
- WHERE id_akademik='$edit'
- and kode_mapel='$n[kode_mapel]'");
- while( $row = mysql_fetch_assoc( $qutesprojek))
- {
- $datanilaik[] = $row['nilai']; // Inside while loop
- }
- $qutesportofolio = mysql_query("SELECT * FROM tes_portofolio_n
- WHERE id_akademik='$edit'
- and kode_mapel='$n[kode_mapel]'");
- while( $row = mysql_fetch_assoc( $qutesportofolio))
- {
- $datanilaik[] = $row['nilai']; // Inside while loop
- }
- $rat_ket = mmmr($datanilaik);
- if(empty($rat_ket))
- {
- $rat_ket=0;
- }
- // $rat_ket=rataKet($rat_praktek,$rat_projek,$rat_portofolio);
- $konv_ket=konv_100($rat_ket);
- //ending ketrampilan
- //ending sikap
- $datanilaip=[];
- $datanilaik=[];
- //ending sikap
- if($c!=$n['kode_mapel']) {
- $data = kkmmapel($n['kode_mapel'],$semester_aktif,$tahun_aktif); $kkm=$data['kkm']; $idkkmmapel=$data['idkkmmapel']; $predikatPeng=predikat_kkmmapel($idkkmmapel,$konv_peng); $predikatKet=predikat_kkmmapel($idkkmmapel,$konv_ket);
- $ratan=0;
- $ratan=$ratan=($konv_peng+$konv_ket)/2;
- ?>
- <tr>
- <td><?=$no?></td>
- <td class="kiri"><?=$n['nama_mapel']?>
- <br /></td>
- <td><?=$kkm?></td>
- <!-- <td><?=$bebanjp?></td> -->
- <td><?=$konv_peng?></td>
- <td><?=$predikatPeng?></td>
- <td><?=$konv_ket?></td>
- <td><?=$predikatKet?></td>
- <!-- <td><?=$ratan?></td> -->
- <!-- <td><?=$nxb?></td> -->
- </tr>
- <?php $no++;
- $c=$n['kode_mapel'];}
- } ?>
- <tr>
- <th>II</th>
- <th class="kiri" colspan="9">Lintas Peminatan</th>
- </tr>
- <?php
- $no=1;
- $c=0;
- while ($n=mysql_fetch_array($que_d)){
- //proses nilai Pengetahuan
- $qutestulis = mysql_query("SELECT * FROM tes_tulis_n
- WHERE id_akademik='$edit'
- and kode_mapel='$n[kode_mapel]'");
- while( $row = mysql_fetch_assoc( $qutestulis))
- {
- $datanilaip[] = $row['nilai']; // Inside while loop
- }
- $quteslisan = mysql_query("SELECT * FROM tes_lisan_n
- WHERE id_akademik='$edit'
- and kode_mapel='$n[kode_mapel]'");
- while( $row = mysql_fetch_assoc( $quteslisan))
- {
- $datanilaip[] = $row['nilai']; // Inside while loop
- }
- $qutestugas = mysql_query("SELECT * FROM tes_tugas_n
- WHERE id_akademik='$edit'
- and kode_mapel='$n[kode_mapel]'");
- while( $row = mysql_fetch_assoc( $qutestugas))
- {
- $datanilaip[] = $row['nilai']; // Inside while loop
- }
- $rat_peng = mmmr($datanilaip);
- if(empty($rat_peng))
- {
- $rat_peng=0;
- }
- // return var_dump($rat_peng);
- // $rat_peng=rata($n['tu1'],$n['tu2'],$n['tu3'],$n['tu4'],$n['tu5']
- // ,$n['li1'],$n['li2'],$n['li3'],$n['li4'],$n['li5'],
- // $n['tgs1'],$n['tgs2'],$n['tgs3'],$n['tgs4'],$n['tgs5']);
- $konv_peng=konversi_100($rat_peng,$n['uts'],$n['uas']);
- //end poses nilai
- //proses nilai ketrampilan
- // $rat_praktek=rataTagihan($n['pra1'],$n['pra2'],$n['pra3'],$n['pra4'],$n['pra5']);
- // $rat_projek=rataTagihan($n['pro1'],$n['pro2'],$n['pro3'],$n['pro4'],$n['pro5']);
- // $rat_portofolio=rataTagihan($n['por1'],$n['por2'],$n['por3'],$n['por4'],$n['por5']);
- $qutespraktek = mysql_query("SELECT * FROM tes_praktek_n
- WHERE id_akademik='$edit'
- and kode_mapel='$n[kode_mapel]'");
- while( $row = mysql_fetch_assoc( $qutespraktek))
- {
- $datanilaik[] = $row['nilai']; // Inside while loop
- }
- $qutesprojek = mysql_query("SELECT * FROM tes_projek_n
- WHERE id_akademik='$edit'
- and kode_mapel='$n[kode_mapel]'");
- while( $row = mysql_fetch_assoc( $qutesprojek))
- {
- $datanilaik[] = $row['nilai']; // Inside while loop
- }
- $qutesportofolio = mysql_query("SELECT * FROM tes_portofolio_n
- WHERE id_akademik='$edit'
- and kode_mapel='$n[kode_mapel]'");
- while( $row = mysql_fetch_assoc( $qutesportofolio))
- {
- $datanilaik[] = $row['nilai']; // Inside while loop
- }
- $rat_ket = mmmr($datanilaik);
- if(empty($rat_ket))
- {
- $rat_ket=0;
- }
- // $rat_ket=rataKet($rat_praktek,$rat_projek,$rat_portofolio);
- $konv_ket=konv_100($rat_ket);
- //ending ketrampilan
- //ending sikap
- $datanilaip=[];
- $datanilaik=[];
- //ending sikap
- if($c!=$n['kode_mapel']) {
- $data = kkmmapel($n['kode_mapel'],$semester_aktif,$tahun_aktif); $kkm=$data['kkm']; $idkkmmapel=$data['idkkmmapel']; $predikatPeng=predikat_kkmmapel($idkkmmapel,$konv_peng); $predikatKet=predikat_kkmmapel($idkkmmapel,$konv_ket);
- $ratan=0;
- $ratan=$ratan=($konv_peng+$konv_ket)/2;
- ?>
- <tr>
- <td><?=$no?></td>
- <td class="kiri"><?=$n['nama_mapel']?></td>
- <td><?=$kkm?></td>
- <!-- <td><?=$bebanjp?></td> -->
- <td><?=$konv_peng?></td>
- <td><?=$predikatPeng?></td>
- <td><?=$konv_ket?></td>
- <td><?=$predikatKet?></td>
- <!-- <td><?=$ratan?></td> -->
- <!-- <td><?=$nxb?></td> -->
- </tr>
- <?php $no++;
- $c=$n['kode_mapel'];}
- } ?>
- </table>
- <br />
- <table width="529" border="0" cellpadding="3" cellspacing="0">
- <tr>
- <td align="left"><label><b>Tabel Interval Berdasarkan KKM </b></label></td>
- </tr>
- </table>
- <table width="200" border="1" cellpadding="0" cellspacing="0">
- <tr>
- <td rowspan="2">KKM</td>
- <td colspan="4">Predikat</td>
- </tr>
- <tr>
- <td>D=Kurang</td>
- <td>C=Cukup</td>
- <td>B=Baik</td>
- <td>A=Sangat Baik</td>
- </tr>
- <tr>
- <td>75</td>
- <td>< 75</td>
- <td>75 ≤ 76 </td>
- <td>77 ≤ 88 </td>
- <td>89 ≤ 100</td>
- </tr>
- </table>
- <br />
- <br>
- <!-- <table style="display: none" width="529" border="1" cellspacing="0" cellpadding="3">
- <tr>
- <th rowspan="2">KKM</th>
- <th colspan="4">Predikat</th>
- </tr>
- <tr>
- <th>D=Kurang</th>
- <th>C=Cukup</th>
- <th>B=Baik</th>
- <th>A=Sangat Baik</th>
- </tr>
- <?php while($rkkm = mysql_fetch_array($tkkm)) {
- $tidkkm=$rkkm['idkkm'];
- ?>
- <tr>
- <td><?=$rkkm['kkm']?></td>
- <?php
- $quekkmp = mysql_query("SELECT * FROM kkm_predikat WHERE idkkm='$tidkkm' ORDER BY predikat DESC");
- while($ddkkm = mysql_fetch_array($quekkmp))
- {?>
- <td>≤ <?=$ddkkm['atas']?></td>
- <?php }
- } ?>
- </tr>
- </table>
- <br /> -->
- </div>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement