$inp = app_form_gpost('jenismutasi', 'siswa', 'tanggal', 'keterangan'); if ($opt == 'a' || $opt == 'u' || $opt == 'd') { $q = false; if ($opt == 'a') { // add $q = dbInsert($dbtable, $inp); $q = dbQSql("UPDATE aka_siswa SET aktif='3' WHERE replid='" . $inp['siswa'] . "'"); } else { if ($opt == 'u') { // edit $q = dbUpdate($dbtable, $inp, "siswa='{$cid}'"); } else { if ($opt == 'd') { // delete $q = dbDel($dbtable, "siswa='{$cid}'"); $q = dbQSql("UPDATE aka_siswa SET aktif='1' WHERE replid='{$cid}'"); } } } $fform->notif($q); } else { if ($opt == 'uf' || $opt == 'df') { // Prepocessing form $db = new xdb("aka_mutasi"); $db->field("aka_mutasi:replid,jenismutasi,siswa,tanggal,keterangan", "aka_siswa:nis as snis,nama as ssiswa"); $db->join("siswa", "aka_siswa"); $db->where("aka_mutasi.siswa='{$cid}'"); $r = $db->gofetch(); } else { $r = array(); $r['tanggal'] = date("Y-m-d");
} appmod_use('aka/siswa', 'aka/kelas'); $ssid = session_id(); // form Module $fmod = "siswa_pendataan_kelas"; $dbtable = 'aka_siswa_kelas'; if ($opt == 'a') { $kls = gpost('kelas'); $data = gpost('data'); if ($data != "") { $q = true; $did = explode(",", $data); $n = count($did); for ($i = 0; $i < $n; $i++) { $cid = $did[$i]; $q &= dbQSql("INSERT INTO aka_siswa_kelas SET kelas='{$kls}',siswa='{$cid}'"); //log_print("INSERT INTO aka_siswa_kelas SET kelas='$kls',siswa='$cid'"); } } } else { if ($opt == 'd') { // delete $kls = gpost('kelas'); $q = dbDel($dbtable, "siswa='{$cid}' AND kelas='{$kls}'"); } else { if ($opt == 'af') { $fform = new fform($fmod, 'af', $cid, 'Cari item'); $fform->reg['title_af'] = '<idata>'; $fform->reg['btnlabel_a_y'] = 'Pilih yg ditandai'; $fform->reg['btnlabel_a_n'] = 'Batal'; $fform->dimension(500);
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]; }
$db->where_and($xtable->search_sql_get()); $t = $db->query(); $xtable->ndata = mysql_num_rows($t); $xtable->search_box('nis atau nama siswa'); $xtable->search_info('data siswa dengan nis atau nama "<b>{keyw}</b>"' . ($angk == 0 ? '' : ' pada tahun ajaran ' . $tahunajaran[$tajar]) . '.'); $fid = 0; if ($xtable->ndata > 0) { // $xtable->head('NIS','Nama','Tunggakan{R}','{40px}'); $xtable->head('NIS', 'Nama', 'Uang Sekolah{R}', '{40px}'); while ($r = mysql_fetch_array($t)) { // $xtable->row_begin(); $xtable->row_begin($r['replid']); $t2 = dbQSql("SELECT * FROM keu_pembayaran WHERE modul='{$modid}' AND siswa='" . $r['replid'] . "'"); $r2 = dbFA($t2); $dibayar = 0; $t3 = dbQSql("SELECT * FROM keu_transaksi WHERE pembayaran='" . $r2['replid'] . "'"); while ($r3 = dbFA($t3)) { $dibayar += $r3['nominal']; // print_r($r3);exit(); } if ($fid == 0) { $fid = $r['replid']; } $xtable->td($r['nis'], 40); $xtable->td($r['nama']); $xtable->td(fRp($r2['nominal'] - $dibayar), 80, 'r'); if (admin_isoperator()) { $s = '<button class="btn" title="Proses" onclick="E(\'siswa\').value=' . $r['replid'] . ';pembayaran_proses_get()"><div class="bi_arrow2b"> </div></button>~36px'; } else { $s = '<div style="height:23px;width:36px"></div>'; }
$doc->cell('<b>KELAS</b>', 100, '', 2); $doc->cell('<b>: ' . $siswa['nkelas'] . '</b>', 0, '', 4); $doc->nl(); $doc->cell('', 40); $doc->cell('', 60); $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);
$tgl_f = $tgl[0] . "-" . $tgl[1] . "-1"; $tgl_c = date("Y-m-d"); $tgl_l = $tgl[0] . "-" . $tgl[1] . "-" . $dim; $tgl_cm = $tgl[0] . "-" . $tgl[1] . "-"; $data = gpost('data'); //log_print("DATA: ".$data); if ($data != "") { $did = explode(",", $data); $n = count($did); for ($i = 0; $i < $n; $i++) { $tgl = $did[$i]; $tanggal = $tgl_cm . $tgl; $absen = gpost('absen_' . $tgl); $keterangan = gpost('keterangan_' . $tgl); dbDel("aka_absen_guru", "guru='{$cid}' AND tanggal='{$tanggal}'"); $q = dbQSql("INSERT INTO aka_absen_guru SET absen='{$absen}',keterangan='{$keterangan}',guru='{$cid}',tanggal='{$tanggal}'"); //log_print("INSERT INTO aka_siswa_kelas SET kelas='$kls',siswa='$cid'"); } } } else { if ($opt == 'd') { // delete $kls = gpost('kelas'); $q = dbDel($dbtable, "guru='{$cid}' AND kelas='{$kls}'"); } else { if ($opt == 'af' || $opt == 'uf') { $fform = new fform($fmod, $opt, $cid, 'Data presensi guru'); $fform->reg['btnlabel_a_n'] = 'Batal'; $fform->dimension(600); $fform->ptop = 5; $fform->globalkey = '0';
//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); while ($r = mysql_fetch_array($t)) { $xtable->row_begin($r['replid']); $xtable->td($r['nis'], 60); $xtable->td($r['nama'], 250); $t1 = dbQSql("SELECT * FROM aka_penilaian WHERE guru='{$gid}' AND pelajaran='{$pel}' AND kelas='{$kls}'"); while ($r1 = dbFA($t1)) { //$db->field("IF(aka_daftarnilai.penilaian = '".$r1['replid']."', aka_daftarnilai.nilai, 0) as ".$r1['kode']); //$db->join_cust("aka_daftarnilai ON aka_daftarnilai.penilaian='".$r1['replid']."'"); //array_push($heads,$r1['kode']); $nil = $r["T" . $r1['kode']]; if ($nil < $SKM) { $nil = '<span style="color:#ff0000">' . $nil . '</span>'; } $xtable->td($nil, 50, 'c', $r['B' . $r1['kode']] == 0 ? 'style="color:#aaa;background:#eee"' : ''); } $xtable->td($r["JMLNILAI"], 70, 'c'); $xtable->td(number_format($r["TNILAI"], 2), 70, 'c'); $xtable->td($r['TLULUS'] == 1 ? 'Tuntas ' : '<span style="color:#ff0000">Belum tuntas</span>', 80); $xtable->td($r['komen'], '', '', 'id="ket_' . $r['replid'] . '"'); $s = '<button class="btn" title="Edit keterangan" onclick="nilairapor_komen_form(\'uf\',' . $r['replid'] . ')"><div class="bi_editb"> </div></button>';
<?php appmod_use('aka/siswa', 'aka/kelas', 'aka/pelajaran', 'aka/rapor'); // cell($a,$w=0,$c=1,$r=1,$al='',$b=-1,$bg='',$s='',$atr='') $token = gets('token'); $token = doc_decrypt($token); $doc = new doc(); $doc->dochead("Data Siswa Angkatan " . gets('angkatan'), 5); $doc->row_blank(5); $t = dbQSql($token); $no = 1; $doc->head('No{C}', '@!NIS', '@!NISN', '@nama', 'Tempat Tanggal lahir'); while ($r = dbFA($t)) { $doc->nl(); $doc->cell($no++, 40, 'c'); $doc->cell($r['nis'], 50); $doc->cell($r['nisn'], 80); $doc->cell($r['nama'], 0); $doc->cell($r['tmplahir'] . ', ' . fftgl($r['tgllahir']), 170); } $doc->end();
<?php require_once(MODDIR.'fform/fform.php'); require_once(MODDIR.'control.php'); $opt=gpost('opt');$cid=gpost('cid',0); $ssid=session_id(); // form Module $fmod="tools_label_buku"; $dbtable='pus_tpjm'; if($opt=='a'){ $data=gpost('data'); if($data!=""){ $q=true; $did=explode(",",$data); $n=count($did); for($i=0;$i<$n;$i++){ $cid=$did[$i]; $q&=dbQSql("INSERT INTO pus_tpjm SET buku='$cid',ssid='$ssid'"); } } } else if($opt=='d'){ // delete $q=dbDel($dbtable,"replid='$cid'"); } else if($opt=='af'){ $fform=new fform($fmod,'af',$cid,'Cari item'); $fform->reg['title_af']='<idata>'; $fform->reg['btnlabel_a_y']='Pilih yg ditandai'; $fform->reg['btnlabel_a_n']='Batal'; $fform->dimension(600); $fform->ptop=20; $fform->globalkey='0'; $fform->head('Pilih Item Yang Akan Dicetak'); echo '<tr><td><div id="box_tools_label_buku_list">';
if ($opt == 'a' || $opt == 'u' || $opt == 'd') { $q = false; if ($opt == 'a') { // add $q = dbInsert($dbtable, $inp); } else { if ($opt == 'u') { // edit $data = gpost('data'); if ($data != "") { $did = explode(",", $data); $n = count($did); for ($i = 0; $i < $n; $i++) { $cid = $did[$i]; $bobot = gpost('bobot_' . $cid); $q = dbQSql("UPDATE aka_penilaian SET bobot='{$bobot}' WHERE replid='{$cid}'"); } } } else { if ($opt == 'd') { // delete $q = dbDel($dbtable, "replid='{$cid}'"); } } } $fform->notif($q); } else { if ($opt == 'uf' || $opt == 'df') { // Prepocessing form $r = dbSFA("*", $dbtable, "W/replid='{$cid}'"); } else {
$dbtable = 'pus_tpjm'; $fform = new fform($fmod, $opt, $cid, 'item'); if ($opt == 'a' || $opt == 'u' || $opt == 'd') { $q = false; $ec = 0; $ec = 0; if ($opt == 'a') { // add $data = gpost('data'); if ($data != "") { $q = true; $did = explode(",", $data); $n = count($did); for ($i = 0; $i < $n; $i++) { $cid = $did[$i]; $q &= dbQSql("INSERT INTO pus_tpjm SET buku='{$cid}',ssid='{$ssid}'"); //log_print("INSERT INTO aka_siswa_kelas SET kelas='$kls',siswa='$cid'"); } } } else { if ($opt == 'd') { // delete $q = dbDel($dbtable, "replid='{$cid}'"); } } //$fform->notif($q); } else { if ($opt == 'df') { // Delete form $fform->reg['title_df'] = 'Keluarkan Item Dari Daftar Peminjaman'; $fform->reg['btnlabel_u_n'] = 'Tidak';
} $heads = array_merge($heads, array('@!JML Nilai{C,2}', '@Rata-rata{C,2}', '@Peringkat{C,2}', 'Keterangan{2}')); //array_push($heads,'Keterangan'); $xtable->head_addrow($heads); $heads2 = array(); $n = count($SSKM); foreach ($SSKM as $k => $v) { array_push($heads2, '!SKM: ' . $v . '{C}'); } $xtable->head_addrow($heads2); $xtable->head_multi(); while ($r = mysql_fetch_array($t)) { $xtable->row_begin($r['replid']); $xtable->td($r['nis'], 60); $xtable->td($r['nama'], 200); $t0 = dbQSql("SELECT aka_sks.*,aka_pelajaran.kode as kodepel FROM aka_sks LEFT JOIN aka_pelajaran ON aka_pelajaran.replid=aka_sks.pelajaran WHERE kelas='{$kls}' GROUP BY aka_sks.pelajaran ORDER BY aka_pelajaran.nama"); while ($r0 = dbFA($t0)) { $pelid = $r0['pelajaran']; if (isset($r["TNILAI_" . $pelid])) { $nil = number_format($r["TNILAI_" . $pelid], 2); if ($r['TLULUS_' . $pelid] != 1) { $nil = '<span style="color:#ff0000">' . $nil . '</span>'; } } else { $nil = ''; } $xtable->td($nil, 50, 'c'); } $xtable->td(number_format($r["TNRAPOR"], 2), 70, 'c'); $xtable->td(number_format($r["AVGRAPOR"], 2), 70, 'c'); $xtable->td($rank[$r['replid']], 60, 'c');
$fmod = "daftarnilai"; $fform = new fform($fmod, $opt, $cid, 'nilai'); $dbtable = 'aka_daftarnilai'; if ($opt == 'u') { $q = false; $pel = gpost('pelajaran'); $kls = gpost('kelas'); $peni = gpost('penilaian'); $data = gpost('data'); if ($data != "") { $did = explode(",", $data); $n = count($did); for ($i = 0; $i < $n; $i++) { $cid = $did[$i]; $nilai = gpost('nilai_' . $cid); $q = dbQSql("UPDATE aka_daftarnilai SET nilai='{$nilai}' WHERE penilaian='{$peni}' AND siswa='{$cid}'"); //log_print("INSERT INTO aka_siswa_kelas SET kelas='$kls',siswa='$cid'"); } } $fform->notif($q); } else { if ($opt == 'uf') { //$fform->reg['title_af']='<idata>'; //$fform->reg['btnlabel_a_y']='Pilih yg ditandai'; //$fform->reg['btnlabel_a_n']='Batal'; $fform->dimension(600); $fform->ptop = 20; $fform->globalkey = '0'; $fform->head(); $fform->rheight = ''; $fform->fl('Pelajaran', pelajaran_name(gpost('pelajaran')));
$tgl_f = $tgl[0] . "-" . $tgl[1] . "-1"; $tgl_c = date("Y-m-d"); $tgl_l = $tgl[0] . "-" . $tgl[1] . "-" . $dim; $tgl_cm = $tgl[0] . "-" . $tgl[1] . "-"; $data = gpost('data'); //log_print("DATA: ".$data); if ($data != "") { $did = explode(",", $data); $n = count($did); for ($i = 0; $i < $n; $i++) { $tgl = $did[$i]; $tanggal = $tgl_cm . $tgl; $absen = gpost('absen_' . $tgl); $keterangan = gpost('keterangan_' . $tgl); dbDel("aka_absen", "siswa='{$cid}' AND tanggal='{$tanggal}'"); $q = dbQSql("INSERT INTO aka_absen SET absen='{$absen}',keterangan='{$keterangan}',siswa='{$cid}',tanggal='{$tanggal}'"); //log_print("INSERT INTO aka_siswa_kelas SET kelas='$kls',siswa='$cid'"); } } } else { if ($opt == 'd') { // delete $kls = gpost('kelas'); $q = dbDel($dbtable, "siswa='{$cid}' AND kelas='{$kls}'"); } else { if ($opt == 'af' || $opt == 'uf') { $fform = new fform($fmod, $opt, $cid, 'Data presensi siswa'); $fform->reg['btnlabel_a_n'] = 'Batal'; $fform->dimension(600); $fform->ptop = 5; $fform->globalkey = '0';