} $PSBar->end(); if ($PSBar->pass) { if ($opt == 'af' || $opt == 'uf') { require_once VWDIR . 'siswa_form.php'; } else { $xtable = new xtable($fmod, 'siswa'); $xtable->search_keyon('nis=>aka_siswa.nis:EQ', 'nama=>aka_siswa.nama:LIKE'); $xtable->docname = "Data Siswa Angkatan " . angkatan_name($angk); $xtable->printparams = array('angkatan' => angkatan_name($angk)); // Query $db = new xdb("aka_siswa"); $db->field("aka_siswa:replid,nis,nisn,nama,tmplahir,tgllahir"); $db->where_and("aka_siswa.angkatan='{$angk}'"); $db->where_and($xtable->search_sql_get()); $t = $xtable->use_db($db, $xtable->pageorder_sql('nis', 'nisn', 'nama')); $xtable->btnbar_f('print', 'srcbox'); if ($xtable->ndata > 0) { // Table head $xtable->head('@!NIS', '@!NISN', '@nama', 'Tempat Tanggal lahir', '{50px}'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); $xtable->td($r['nis'], 80); $xtable->td($r['nisn'], 120); $xtable->td($r['nama']); $xtable->td($r['tmplahir'] . ', ' . fftgl($r['tgllahir']), 100); //$s='<button class="btn" title="Keluarkan siswa dari kelas ini." onclick="siswa_form(\'df\',\''.$r['replid'].'\')"><div class="bi_canb"> </div></button>'; $xtable->opt($r['replid'], 'v'); $xtable->row_end(); } $xtable->foot();
$lokasi = lokasi_r($lok); $PSBar = new PSBar_2(); // Page selection bar $PSBar->begin(); if (count($lokasi) > 0) { $PSBar->selection('lokasi', iSelect('lokasi', $lokasi, $lok, $PSBar->selws, $fmod . "_get()")); } else { $PSBar->end(); hiddenval('lokasi', $lok); lokasi_warn(); exit; } $PSBar->end(); // Query $db = new xdb("sar_grup", "", "lokasi='{$lok}'"); $t = $xtable->use_db($db, $xtable->pageorder_sql('kode', 'nama')); $xtable->btnbar_begin(); $xtable->btnbar_add(); echo '<div class="sfont" style="float:right;margin-top:4px">Total aset: ' . fRp(lokasi_aset($lok)) . '</div>'; $xtable->btnbar_end(); if ($xtable->ndata > 0) { // Table head $xtable->head('@kode', '@nama Grup barang', 'Jumlah unit~C', 'Unit tersedia~C', 'Unit dipinjam~C', 'Total aset~R', 'Keterangan'); $nom = 1; while ($r = mysql_fetch_array($t)) { $xtable->row_begin($r['replid']); $n = mysql_num_rows(mysql_query("SELECT replid FROM sar_barang WHERE grup='" . $r['replid'] . "'")); $xtable->td($r['kode'], 100); $xtable->td($r['nama'], 200); $xtable->td($n, 100, 'c'); $xtable->td(0, 100, 'c');
$xtable->noopt = true; $lok = gpost('lokasi'); $grup = gpost('grup'); $kat = $cid; hiddenval('lokasi', $lok); hiddenval('grup', $grup); hiddenval('katalog', $kat); if ($opt == 'af' || $opt == 'uf') { require_once VWDIR . 'katalog_form.php'; } else { // Katalog Query $tk = mysql_query("SELECT * FROM sar_katalog WHERE replid='{$cid}'"); $rk = mysql_fetch_array($tk); // Query //$sql="SELECT * FROM sar_barang WHERE katalog='$cid'"; $t = $xtable->use_db(new xdb("sar_barang", "", "katalog='{$cid}'"), $xtable->pageorder_sql('kode', 'barkode', 'kondisi')); $xtable->btnbar_f(iBtn('Grup barang', 'bi_arrow', 'title="Kembali ke grup barang" onclick="katalog_unit_back()"')); hiddenval('opf', 'uni'); hiddenval('kondisi_1', mysql_num_rows(mysql_query("SELECT replid FROM sar_barang WHERE katalog='{$cid}' AND kondisi='1'"))); hiddenval('kondisi_2', mysql_num_rows(mysql_query("SELECT replid FROM sar_barang WHERE katalog='{$cid}' AND kondisi='2'"))); hiddenval('kondisi_3', mysql_num_rows(mysql_query("SELECT replid FROM sar_barang WHERE katalog='{$cid}' AND kondisi='3'"))); hiddenval('kondisi_4', mysql_num_rows(mysql_query("SELECT replid FROM sar_barang WHERE katalog='{$cid}' AND kondisi='4'"))); ?> <div class="tbltopmbar" style="float:left;margin-top:10px;margin-bottom:10px"> <table class="stable" cellspacing="0" cellpadding="0" width="100%"><tr valign="top"> <td width="400px"> <table class="stable" cellspacing="0" cellpadding="0"> <tr height="24px"><td colspan="2"><b>Informasi Barang :</b></td></tr> <tr height="24px"><td width="140px">Nama barang:</td><td><?php echo $rk['nama']; ?>
$lokasi = lokasi_r($lok); $PSBar = new PSBar_2(); // Page selection bar $PSBar->begin(); if (count($lokasi) > 0) { $PSBar->selection('lokasi', iSelect('lokasi', $lokasi, $lok, $PSBar->selws, $fmod . "_get()")); } else { $PSBar->end(); hiddenval('lokasi', $lok); lokasi_warn(); exit; } $PSBar->end(); // Query $db = new xdb("sar_aktivitas", "", "lokasi='{$lok}'"); $t = $xtable->use_db($db, $xtable->pageorder_sql('tanggal1')); $xtable->btnbar_f('add'); if ($xtable->ndata > 0) { // Table head $xtable->head('@Tanggal', 'Aktivitas', 'Keterangan'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); $xtable->td(fftgl($r['tanggal1']) . ' - ' . fftgl($r['tanggal2']), 200); $xtable->td(nl2br($r['aktivitas']), 250); $xtable->td(nl2br($r['keterangan'])); $xtable->opt_ud($r['replid']); $xtable->row_end(); } $xtable->foot(); } else { $xtable->nodata();
<?php $fmod = 'departemen'; $xtable = new xtable($fmod); // Query $t = $xtable->use_db(new xdb("departemen"), $xtable->pageorder_sql('nama', 'alamat', 'telepon')); $xtable->btnbar_f('add'); if ($xtable->ndata > 0) { // Table head $xtable->head('@Nama Departemen', '@Alamat', '@Telepon'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin($r['replid']); $xtable->td($r['nama'], 200); $xtable->td(nl2br($r['alamat'])); $xtable->td($r['telepon'], 150); /* $q=mysql_query("SELECT LENGTH(photo) AS psize FROM departemen WHERE replid='".$r['replid']."'"); $h=mysql_fetch_array($q); if($h['psize']>0){ $p='<img src="photo/$.php?id='.$r['replid'].'" width="100px"/>'; }else{ $p=''; } */ //$xtable->td('',150,'c'); $xtable->opt_ud($r['replid']); $xtable->row_end(); } $xtable->foot(); } else { $xtable->nodata();