function guru_SID(){ $pid=guru_pegawaiId(); $t=mysql_query("SELECT replid FROM aka_guru WHERE pegawai='$pid' LIMIT 0,1"); if(mysql_num_rows($t)>0){ $r=mysql_fetch_array($t); return $r['replid']; } else { return 0; } }
<?php appmod_use('aka/pelajaran', 'aka/tahunajaran', 'aka/tingkat', 'aka/kelas', 'aka/siswa'); $gid = guru_pegawaiId(); $fmod = 'penilaian'; $xtable = new xtable($fmod); $dept = gpost('departemen'); $departemen = departemen_r($dept); if (count($departemen) > 0) { $tajar = gpost('tahunajaran'); $tahunajaran = tahunajaran_r($tajar, $dept); $ting = gpost('tingkat'); $tingkat = tingkat_r($ting, $dept); $kel = gpost('kelas'); $kelas = kelas_r($kel, $ting); $pel = gpost('pelajaran'); $pelajaran = pelajaran_r_pegawai($pel, $gid); // Query $db = siswa_db_bykelas($kel); $t = $db->query(); // echo "SELECT aka_guru.*,hrd_pegawai.nip,hrd_pegawai.nama FROM aka_guru LEFT JOIN hrd_pegawai ON aka_guru.pegawai=hrd_pegawai.replid WHERE aka_guru.pelajaran='$pel' ORDER BY hrd_pegawai.nama"; $xtable->ndata = mysql_num_rows($t); // Page Selection Bar $PSBar = new PSBar_2(); $PSBar->begin(); $PSBar->selection_departemen($fmod, $dept); if (count($tahunajaran) > 0) { $PSBar->selection('Tahun ajaran', iSelect('tahunajaran', $tahunajaran, $tajar, $PSBar->selws, $fmod . "_get()")); } else { $PSBar->end(); hiddenval('tahunajaran', $tajar);