if ($lbobot != $r1['bobot']) { $absama = 0; } $lbobot = $r1['bobot']; } } if ($absama == 1) { $npemb = $tnpemb; } $db->field("(" . $sk . ") as JMLNILAI"); $db->field("@TN := ((" . $sb . ")/ " . $tbobot . ") as TNILAI"); $db->field("IF( @TN < " . $SKM . ",0,1) as TLULUS"); //$db->where_and("aka_daftarnilai.penilaian='$peni'"); //$db->group("aka_siswa.replid"); $t = $db->query(); $xtable->ndata_db($t); //$t=$db->query($xtable->pageorder_sql("aka_siswa:nis,nama","aka_daftarnilai.nilai","tuntas"),1); $xtable->btnbar_begin(); echo '<div class="sfont" style="float:left;margin-top:4px;margin-right:10px">Standar Ketuntasan Minimum (SKM): <b>' . $SKM . '</b></div>'; $xtable->btnbar_end(); //echo $xtable->ndata; if ($xtable->ndata > 0) { // Table head $heads = array('@!NIS', '@Nama'); $t1 = dbQSql("SELECT * FROM aka_penilaian WHERE guru='{$gid}' AND pelajaran='{$pel}' AND kelas='{$kls}'"); while ($r1 = dbFA($t1)) { array_push($heads, '!' . $r1['kode'] . '{C}'); } $heads = array_merge($heads, array('!JML Nilai{C}', 'Nilai akhir{C}', '@Ketuntasan', 'Keterangan')); //array_push($heads,'Keterangan'); $xtable->head($heads);