예제 #1
0
$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);
예제 #3
0
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];
}
예제 #4
0
$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">&nbsp;</div></button>~36px';
        } else {
            $s = '<div style="height:23px;width:36px"></div>';
        }
예제 #5
0
$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);
예제 #6
0
    $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';
예제 #7
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">&nbsp;</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();
예제 #9
0
<?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">';
예제 #10
0
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 {
예제 #11
0
$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';
예제 #12
0
 }
 $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');
예제 #13
0
$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')));
예제 #14
0
    $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';