} if(count($tingkat)>0){ $PSBar->selection('Tingkat',iSelect('ff2_tingkat',$tingkat,$tingk,$PSBar->selws,$fmod."_get(1)")); } else { $PSBar->end(); hiddenval('ff2_tingkat',$tingk); hiddenval('ff2_kelas',$kls); tingkat_warn(0); $PSBar->pass=false; } if(count($kelas)>0){ $PSBar->selection('Kelas',iSelect('ff2_kelas',$kelas,$kls,$PSBar->selws,$fmod."_get(1)")); } else { $PSBar->end(); hiddenval('ff2_kelas',$kls); kelas_warn(0); $PSBar->pass=false; } $PSBar->end(); if($PSBar->pass){ $xtable->search_box('nis atau nama siswa'); $db=siswa_db_bykelas($kls,$tingk); $db->where_and($xtable->search_sql_get()); $t=$db->query(); $xtable->ndata=mysql_num_rows($t); $t=$db->query($xtable->pageorder_sql('aka_siswa.nis','aka_siswa.nama')); if($xtable->ndata>0){ echo '<div style="width:100%;height:300px;max-height:300px;overflow:auto;float:left">';
$PSBar = new PSBar_2(100, 220); $PSBar->begin(); if (count($tingkat) > 0) { $PSBar->selection('Tingkat', iSelect('tingkat', $tingkat, $tingk, $PSBar->selws, $fmod . "_get()")); } else { $PSBar->end(); hiddenval('tingkat', $tingk); tingkat_warn(1); exit; } if (count($kelas) > 0) { $PSBar->selection('Kelas', iSelect('kelas', $kelas, $kls, $PSBar->selws, $fmod . "_get()")); } else { $PSBar->end(); hiddenval('kelas', $kls); kelas_warn(1); exit; } $PSBar->end(); $xtable = new xtable($fmod, 'siswa'); $xtable->use_select(); // epi_edit $xtable->select_noopt = true; // epi_edit // $xtable->select_cekfunc="siswa_pendataan_kelas_list_cek(param)"; $xtable->search_keyon('nama=>aka_siswa.nama:LIKE|aka_siswa.nis:EQ-0,1'); $xtable->search_box_pos('l', '200px'); $db = siswa_db_bykelas($kls, $tingk); $db->where_and($xtable->search_sql_get()); $t = $db->query(); $xtable->ndata = mysql_num_rows($t);
$PSBar->end(); hiddenval('pstingkat', $ting); hiddenval('pskelas', $kls); hiddenval('keyword', ''); kelas_warn(1, 'float:left'); $PSBar->pass = false; } } if ($PSBar->pass) { if (count($kelas) > 0) { $PSBar->selection('Kelas', iSelect('pskelas', $kelas, $kls, $PSBar->selws, $fmod . "_get(1)")); } else { $PSBar->end(); hiddenval('pskelas', $kls); hiddenval('keyword', ''); kelas_warn(1, 'float:left'); $PSBar->pass = false; } } $PSBar->end(); if ($PSBar->pass) { $xtable->btnbar_begin(); //echo iTextSrc('pskeyword',$keyw,'float:left~width:250px','NIS atau nama siswa...',"peminjaman_member_get_siswa(1)"); $xtable->search_box(); $xtable->btnbar_end(); $t = mysql_query("SELECT * FROM aka_siswa WHERE kelas='{$kls}' " . ($keyw == "" ? "" : " AND (nama LIKE '%{$keyw}%' OR nis='{$keyw}') ") . " ORDER BY nama"); $xtable->ndata = mysql_num_rows($t); //$xtable->search_info($keyw,'Hasil pencarian data siswa dengan NIS atau nama "<b>'.$keyw.'</b>".',"E('pskeyword').value='';peminjaman_member_get_siswa(1)"); $xtable->search_info(); if ($xtable->ndata > 0) { //$xtable->optw='50px';
$PSBar->selection('Tingkat', iSelect('tingkat', $tingkat, $ting, $PSBar->selws, $fmod . "_get()")); } else { $PSBar->end(); hiddenval('tingkat', $ting); hiddenval('kelas', $kls); tingkat_warn(0, 'float:left'); $PSBar->pass = false; } } if ($PSBar->pass) { if (count($kelas) > 0) { $PSBar->selection('Kelas', iSelect('kelas', $kelas, $kls, $PSBar->selws, $fmod . "_get()")); } else { $PSBar->end(); hiddenval('kelas', $kls); kelas_warn(0, 'float:left'); $PSBar->pass = false; } } $PSBar->end(); if ($PSBar->pass) { //echo '<span style="color:red">'."SELECT * FROM aka_sks WHERE kelas='$kls' GROUP BY pelajaran".'</span>'; $db = siswa_db_bykelas($kls); $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"); $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; while ($r0 = dbFA($t0)) {