Exemple #1
0
         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);