$doc->cell('', 0, '', 4);
$doc->cell_format('border:1,align:c');
$doc->nl(30);
$doc->cell('<b>NO</b>', 40);
$doc->cell('<b>MATA PELAJARAN</b>', 0, '', 2);
$doc->cell('<b>NILAI</b>', 80);
$doc->cell('<b>KKM</b>', 80);
$doc->cell('<b>KETUNTASAN</b>', 120);
$no = 1;
$jmlnilai = 0;
$tpel = dbQSql("SELECT aka_pelajaran.replid,aka_pelajaran.nama FROM aka_sks LEFT JOIN aka_pelajaran ON aka_pelajaran.replid=aka_sks.pelajaran WHERE aka_sks.kelas='" . $siswa['idkelas'] . "' GROUP BY aka_sks.pelajaran ORDER BY aka_pelajaran.nama");
while ($rpel = dbFA($tpel)) {
$doc->nl();
// cell($a,$w=0,$al='',$c=1,$r=1,$b=-1,$bg='',$s='',$atr='')
$nilai = rapor_pelajaran_nilai($rpel['replid'], $kls, $siswa['replid']);
$skm = pelajaran_skm($rpel['replid']);
$doc->cell($no++, 40);
$doc->cell($rpel['nama'], '244#', 'l', 2, 1);
$doc->cell(number_format($nilai, 2), 80);
$doc->cell(number_format($skm, 2), 80);
$doc->cell($nilai < $skm ? 'Tidak tuntas' : 'Tuntas', 120);
$jmlnilai += $nilai;
}
$rata = $jmlnilai / ($no - 1);
$doc->nl();
$doc->cell('<b>Jumlah Nilai</b>', 0, '', 3);
$doc->cell('<b>' . $jmlnilai . '</b>' . '[x:fmla="=SUM(D8:D10)" x:num]', 'c');
$doc->cell('', 0, '', 2);
$doc->nl();
$doc->cell('<b>Rata-Rata Nilai</b>', 0, '', 3);
$doc->cell('<b>' . number_format($rata, 2) . '</b>' . '[x:fmla="=AVERAGE(D8:D10)" x:num="' . number_format($rata, 2) . '"]', 0, 'c', 1, 1, -1, '', 'mso-number-format:\'0\\.00_ \'');
function rapor_peringkatkelas_siswa($kls,$siswa){
$db=siswa_db_bykelas($kls);
$db->field("aka_komenrapor:komen");
$db->join_cust("aka_komenrapor ON aka_komenrapor.siswa=aka_siswa.replid AND aka_komenrapor.tahunajaran=aka_tahunajaran.replid");
$sna=""; $phn=array(); $SSKM=array(); $npeni=0;
$t0=dbQSql("SELECT * FROM aka_sks WHERE kelas='$kls' GROUP BY pelajaran");
while($r0=dbFA($t0)){
$pelid=$r0['pelajaran'];
$pel=$r0['pelajaran']; $gid=$r0['guru'];
$SKM=pelajaran_skm($pel);
$SSKM[$pelid]=$SKM;
$db->field($SKM." as SKM_".$pelid);
$t1=dbQSql("SELECT * FROM aka_penilaian WHERE guru='$gid' AND pelajaran='$pel' AND kelas='$kls'");
//echo '<span style="color:red">'."SELECT * FROM aka_penilaian WHERE guru='$gid' AND pelajaran='$pel' AND kelas='$kls'".'</span>';
if(dbNRow($t1)>0){
$phn[$pelid]='@';
$sk=""; $tbobot=0; $sb="";
while($r1=dbFA($t1)){
$db->field("@".$r1['kode']."_".$pelid." := IFNULL((SELECT aka_daftarnilai.nilai FROM aka_daftarnilai WHERE aka_daftarnilai.siswa=aka_siswa.replid AND aka_daftarnilai.penilaian='".$r1['replid']."'),0) as T".$r1['kode']."_".$pelid);
$db->field($r1['bobot']." as B".$r1['kode']."_".$pelid);
$tbobot+=$r1['bobot'];
if($r1['bobot']>0){
if($sk!="")$sk.=" + ";
$sk.="@".$r1['kode']."_".$pelid;
if($sb!="")$sb.=" + ";
$sb.="@".$r1['kode']."_".$pelid." * ".$r1['bobot'];
}
}
if($sk!="") $db->field("(".$sk.") as JMLNILAI_".$pelid);
else $db->field("0 as JMLNILAI_".$pelid);
if($tbobot>0){
if($sb!="") $db->field("@TN_".$pelid." := ((".$sb.")/ ".$tbobot.") as TNILAI_".$pelid);
else $db->field("@TN_".$pelid." := 0 as TNILAI_".$pelid);
} else {
$db->field("@TN_".$pelid." := 0 as TNILAI_".$pelid);
}
$db->field("IF( @TN_".$pelid." < ".$SKM.",0,1) as TLULUS_".$pelid);
if($sna!="")$sna.=" + ";
$sna.="@TN_".$pelid;
$npeni++;
} else {
$phn[$pelid]='';
}
}
if($sna!="") $db->field("(".$sna.") as TNRAPOR");
else $db->field("0 as TNRAPOR");
if($npeni>0) $db->field("((".$sna.")/".$npeni.") as AVGRAPOR");
else $db->field("0 as AVGRAPOR");
$db->order("TNRAPOR DESC");
$s=$db->query();
$rank=array(); $rk=1;
while($v=dbFA($s)){
$rank[$v['replid']]=$rk++;
}
return $rank[$siswa];
}
if ($PSBar->pass) {
if (count($kelas) > 0) {
$PSBar->selection('Kelas', iSelect('kelas', $kelas, $kls, $PSBar->selws, $fmod . "_get()"));
} else {
$PSBar->end();
hiddenval('kelas', $kls);
hiddenval('penilaian', $peni);
echo '<div class="warnbox" style="float:left">Tidak ada kelas yang diajar.</div>';
$PSBar->pass = false;
}
}
$PSBar->end();
if ($PSBar->pass) {
// Query
$db = siswa_db_bykelas($kls);
$SKM = pelajaran_skm($pel);
$db->field("aka_komennilai:komen");
$db->join_cust("aka_komennilai ON aka_komennilai.siswa=aka_siswa.replid AND aka_komennilai.pelajaran='{$pel}'");
$t1 = dbQSql("SELECT * FROM aka_penilaian WHERE guru='{$gid}' AND pelajaran='{$pel}' AND kelas='{$kls}'");
$sk = "";
$tbobot = 0;
$sb = "";
$rpemb = "";
$npemb = "";
$tnpemb = "";
$absama = 1;
$lbobot = -1;
while ($r1 = dbFA($t1)) {
$db->field("@" . $r1['kode'] . " := IFNULL((SELECT aka_daftarnilai.nilai FROM aka_daftarnilai WHERE aka_daftarnilai.siswa=aka_siswa.replid AND aka_daftarnilai.penilaian='" . $r1['replid'] . "'),0) as T" . $r1['kode']);
$db->field($r1['bobot'] . " as B" . $r1['kode']);
//$db->field("@B".$r1['kode']." := ".$r1['bobot']);
