$fmod = 'ruang'; $xtable = new xtable($fmod); $dept = gpost('departemen'); $departemen = departemen_r($dept); if (count($departemen) > 0) { // Query $sql = "SELECT * FROM aka_ruang WHERE departemen='{$dept}'"; $t = mysql_query($sql); $xtable->ndata = mysql_num_rows($t); $t = mysql_query($sql . $xtable->pageorder_sql('kode', 'nama')); // Page Selection Bar $PSBar = new PSBar_2(); $PSBar->begin(); $PSBar->selection_departemen($fmod, $dept); $PSBar->end(); $xtable->btnbar_f('add'); if ($xtable->ndata > 0) { // Table head $xtable->head('@Kode Ruang', '@Nama Ruang', 'Keterangan'); $nom = 1; while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); $xtable->td($r['kode'], 100); $xtable->td($r['nama'], 200); $xtable->td(nl2br($r['keterangan'])); $xtable->opt_ud($r['replid']); $xtable->row_end(); } $xtable->foot(); } else { $xtable->nodata();
<?php $fmod = 'aspekpenilaian'; $xtable = new xtable($fmod, 'Aspek penilaian'); // Query $t = mysql_query("SELECT * FROM aka_aspekpenilaian ORDER BY aspekpenilaian"); $xtable->ndata = mysql_num_rows($t); $xtable->btnbar_f('notifbox', 'add'); if ($xtable->ndata > 0) { // Table head $xtable->head('Kode', 'Aspek Penilaian'); $nom = 1; while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); $xtable->td($r['kode'], 200); $xtable->td($r['aspekpenilaian']); $xtable->opt_ud($r['replid']); $xtable->row_end(); } $xtable->foot(); } else { $xtable->nodata(); }
$xtable->pageorder = "keu_transaksi.tanggal,keu_transaksi.nomer"; // Query $db = new xdb("keu_transaksi"); $db->where_and("keu_transaksi.pembayaran='" . $pemb['replid'] . "'"); //$db->where_and($xtable->search_sql_get()); //$db->order("keu_transaksi.tanggal,keu_transaksi.nomer"); $t = $db->query(); $xtable->ndata = mysql_num_rows($t); $t = $db->query($xtable->pageorder_sql()); //$t=$db->query($xtable->pageorder_sql('kode','nama')); $s = '<button style="float:left;margin-right:4px" class="btng" onclick="E(\'jenistransaksi\').value=' . JT_INCOME . ';transaksi_form(\'af\')"> <table cellspacing="0" cellpadding="0"><tr> <td><div style="width:20px;height:20px;background:url(' . IMGR . 'inco.png) center no-repeat;margin-right:6px"></div></td><td><span style="font:bold 11px Verdana,Tahoma;color:#fff;margin-right:4px"><b>Pembayaran</b></span></td> </tr></table> </button>'; $xtable->btnbar_f($pemb['lunas'] == 1 ? '<div class="infobox" style="float:left;margin-right:10px">Pembayaran sudah lunas.</div>' : 'add', 'print'); $xtable->search_info('data transaksi dengan uraian atau nomor "<b>{keyw}</b>".'); if ($xtable->ndata > 0) { // Table head $xtable->head('!Tanggal/<br/>No. Transaksi{110px}', 'Uraian', 'Detil Jurnal'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); if ($r['jenis'] == JT_INCOME) { $cl = '#00c804'; } else { if ($r['jenis'] == JT_SISWA) { $cl = '#00c804'; } else { if ($r['jenis'] == JT_CALONSISWA) { $cl = '#00c804'; } else {
require_once APPMOD . 'aka/angkatan.php'; $fmod = 'periode'; $xtable = new xtable($fmod, 'Periode penerimaan'); $dept = gpost('departemen'); $departemen = departemen_r($dept); if (count($departemen) > 0) { // Query $t = mysql_query("SELECT * FROM psb_proses WHERE departemen='{$dept}'"); $xtable->ndata = mysql_num_rows($t); // Page Selection Bar $PSBar = new PSBar_2(); $PSBar->begin(); $PSBar->selection_departemen($fmod, $dept); // Option buttons $PSBar->end(); $xtable->btnbar_f('add', 'print', 'help'); if ($xtable->ndata > 0) { // Table head $xtable->head('Periode penerimaan{200px}', 'Kode Awalan{120px}', 'Angkatan{120px}', 'Kapasitas{C,100px}', 'Calon Siswa{C,100px}', 'Siswa Diterima{C,100px}', 'status{C,80px}', 'keterangan'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); $q = mysql_query("SELECT replid FROM psb_calonsiswa WHERE proses = '" . $r['replid'] . "'"); $n = mysql_num_rows($q); $q = mysql_query("SELECT replid FROM psb_calonsiswa WHERE proses = '" . $r['replid'] . "' AND status<>0"); $n1 = mysql_num_rows($q); //if(diffDay($r['tglselesai'])<0) $s='<br/><span style="color:#ff9000">(lewat dari tgl penutupan)</span>'; //else $s=''; $xtable->td($r['proses'], 200); $xtable->td($r['kodeawalan'], 120); $xtable->td(angkatan_name($r['angkatan']), 120); $xtable->td($r['kapasitas'], 100, 'c');
$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(); } else {
<?php appmod_use('keu/kategori', 'keu/rekening', 'psb/proses', 'psb/kelompok', 'aka/angkatan', 'aka/tahunajaran'); $fmod = 'modul'; $xtable = new xtable($fmod, 'modul pembayaran'); $kmod = gpost('kategori', 1); $kategori = kategori_r(); // Page Selection Bar $PSBar = new PSBar_2(140); $PSBar->begin(); $PSBar->selection('Kategori pembayaran', iSelect('kategori', $kategori, $kmod, $PSBar->selws, $fmod . "_get()")); $PSBar->end(); $s = '<button class="btn" title="Tambah data modul pembayaran" style="float:left;margin-right:4px" onclick="E(\'reftipe\').value=0;modul_form(\'af\')"><div class="bi_add">Modul pembayaran</div></button>'; $xtable->btnbar_f($s); // Query $db = new xdb("keu_modul", "*", "kategori='{$kmod}'", "nama"); $t = $db->query(); $xtable->ndata = mysql_num_rows($t); if ($xtable->ndata > 0) { // Table head $xtable->head('Nama Pembayaran', 'Kode Rekening', 'Keterangan'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); $xtable->td($r['nama'], 300); $s = '<b>Kas:</b> ' . rekening_name($r['rek1']); if ($r['rek2'] != 0) { $s .= '<br/><b>Pendapatan:</b> ' . rekening_name($r['rek2']); } if ($r['rek3'] != 0) { $s .= '<br/><b>Piutang:</b> ' . rekening_name($r['rek3']); }
<tr height="26px"> <td width="<?php echo $labelw; ?> " align="left"><b>Kode atau nama barang:</b></td> <td width="200px"> <?php echo iText('keyword', $keyword, 'width:' . '375px;float:left;margin-right:2px'); ?> <button class="find21" style="float:left;margin-top:2px" title="Cari" onclick="pencarian_get()"></button> </td> <td width="*"> </td></tr> </table></div> <?php $xtable->btnbar_f($fmsg); $xtable->noopt = true; if ($xtable->ndata > 0) { // Table head $xtable->head('Kode', 'Nama', 'Keterangan'); $nom = 1; while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); //$num_judul = @mysql_num_rows(mysql_query("SELECT * FROM sar_pustaka WHERE format=".$r['replid'])); //$num_pustaka = @mysql_fetch_row(mysql_query("SELECT COUNT(d.replid) FROM sar_pustaka p, sar_daftarpustaka d WHERE d.pustaka=p.replid AND p.format=".$r['replid'])); $xtable->td($r['kode'], 120); $xtable->td($r['nama'], 250); //$xtable->td($num_judul,100); //$xtable->td($num_pustaka[0],100); $xtable->td(nl2br($r['keterangan'])); //$xtable->opt_ud($r['replid']);
kelas_warn(0); $PSBar->pass = false; } } if ($PSBar->pass) { if (count($pelajaran) > 0) { $PSBar->selection('Pelajaran', iSelect('pelajaran', $pelajaran, $pel, $PSBar->selws, $fmod . "_get()")); } else { $PSBar->end(); hiddenval('pelajaran', $pel); pelajaran_warn(0); $PSBar->pass = false; } } $PSBar->end(); $xtable->btnbar_f('<button class="btn" style="float:right" onclick="penilaian_simpan()"><div class="bi_save">Simpan</div></button>'); $x = mysql_query("SELECT * FROM aka_jenispengujian WHERE pelajaran='{$pel}'"); if (mysql_num_rows($x) > 0) { if ($xtable->ndata > 0) { // Table head $xtable->noopt = true; $head = array(); $head[0] = '!NIS'; $head[1] = 'nama siswa'; $k = 2; $x = mysql_query("SELECT * FROM aka_jenispengujian WHERE pelajaran='{$pel}'"); while ($y = mysql_fetch_array($x)) { $head[$k++] = '!' . $y['kode'] . '{C}'; } $head[$k] = '!Nilai Akhir{C,80px}'; $xtable->head($head);
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 = mysql_query($sql); $xtable->ndata = mysql_num_rows($t); // Page sort and order $po = $xtable->pageorder_sql('kode', 'barkode', 'kondisi'); $t = mysql_query($sql . $po); $xtable->btnbar_f('b-Grup barang', '<button class="btn" onclick="katalog_form(\'uf\',\'' . $rk['replid'] . '\')"><div class="bi_edit">Edit informasi barang</div></button>', 'add'); notifbox(); 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']; ?>
$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']; ?> </td></tr>
$PSBar->pass = false; } $PSBar->end(); if ($PSBar->pass) { // Query $db = new xdb("aka_alumni"); $db->field("aka_alumni:replid,siswa as idsiswa,keterangan", "aka_siswa:nisn,nama", "departemen:nama as ndepartemen", "aka_angkatan:angkatan as nangkatan"); $db->join("siswa", "aka_siswa"); $db->joinother("aka_siswa", "angkatan", "aka_angkatan"); $db->joinother("aka_angkatan", "departemen", "departemen"); $db->where("aka_alumni.tahunlulus='{$tlulus}'"); $db->where_and($xtable->search_sql_get()); $t = $db->query(); $xtable->ndata_db($t); $t = $db->query($xtable->pageorder_sql('nisn', 'nama', 'angkatan')); $xtable->btnbar_f('add', 'srcbox'); if ($xtable->ndata > 0) { // Table head $xtable->head('@!NISN', '@nama', '@angkatan{C}', 'Keterangan'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); //$t1=dbQSql("SELECT * FROM aka_siswa WHERE replid='".$r['siswa']."' LIMIT 0,1"); //$r1=dbFA($t1); //$xtable->td($r['nis'],80); $xtable->td($r['nisn'], 120); $xtable->td($r['nama'], 300); $xtable->td($r['nangkatan'], 80, 'c'); $xtable->td(nl2br($r['keterangan'])); //$xtable->td($r['tmplahir'].', '.fftgl($r['tgllahir']),100); //$s='<button class="btn" title="Keluarkan siswa dari kelas ini." onclick="siswa_pendataan_kelas_form(\'df\',\''.$r['replid'].'\')"><div class="bi_canb"> </div></button>'; $xtable->opt($r['idsiswa'], 'u', 'd');
$opt = gpost('opt'); $cid = gpost('cid', 0); $fmod = 'katalog'; $xtable = new xtable($fmod, 'Barang'); $lok = gpost('lokasi'); $grup = gpost('grup'); hiddenval('lokasi', $lok); hiddenval('grup', $grup); if ($opt == 'af' || $opt == 'uf') { require_once VWDIR . 'katalog_form.php'; } else { // Query $db = new xdb("sar_katalog", "", "grup='{$grup}'"); $t = $xtable->use_db($db, $xtable->pageorder_sql('kode', 'nama')); $xtable->btnbar_f(iBtn('Inventory', 'bi_arrow', 'title="Kembali ke inventaris" onclick="katalog_back()"')); hiddenval('opf', 'kat'); ?> <div class="tbltopmbar" style="float:left;margin-top:10px"> <table class="stable" cellspacing="0" cellpadding="0" width="100%"> <tr height="30px"><td colspan="2" align="center" style="font-size:15px">Grup Barang <b><?php echo grup_name($grup); ?> </b></td></tr> <tr height="24px"><td width="100px">Lokasi:</td><td><?php echo lokasi_name($lok); ?> </td></tr> <tr height="24px"><td width="100px">Total aset:</td><td><?php echo fRp(grup_aset($grup)); ?>
// ) // ); $t .= '<div class="sfont" style="float:left;width:100%;margin-bottom:15px"><b>tanggal:</b>'; $t .= ' <a href="javascript:void(0)" class="linkb" onclick="transaksi_ctgl_set(1)" >[hari ini]</a>'; $t .= ' <a href="javascript:void(0)" class="linkb" onclick="transaksi_ctgl_set(2)" >[bulan ini]</a>'; $t .= '</div>'; $t .= '<div style="float:left;width:100%;margin-bottom:40px">'; $tglSearch = inputDate('tanggal1', $tanggal1); $tglSearch .= '<div class="sfont" style="float:left;margin-right:4px;margin-top:4px"> sampai </div>'; $tglSearch .= inputDate('tanggal2', $tanggal2); $tglSearch .= '<button style="float:left;margin-left:30px;margin-right:4px" class="btnz" onclick="transaksi_get()">'; $tglSearch .= '<div class="">Tampilkan »</div>'; $tglSearch .= '</button>'; $t .= $tglSearch; $t .= '</div>'; $xtable->btnbar_f('print', 'srcbox', $s, $t); // echo 'ok'; hiddenval('modul', $modid); hiddenval('pembayaran', 0); if ($xtable->ndata > 0) { // Table head $xtable->headCB('@No pendaftaran', '@Nama', 'Biaya pendaftaran{R}', 'Jumlah dibayar{R}', '@Tanggal pembayaran', '@Status'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); $xtable->td($r['nopendaftaran'], 120); $xtable->td($r['nama']); $xtable->td(fRp($r['nominal']), 110, 'r'); $xtable->td(fRp($r['jmlbayar']), 110, 'r'); if ($r['lunas'] == '1') { $s = '<div style="padding:2px;border-radius:2px;background:#00d000;color:#fff;width:96px;margin:auto"><b>Sudah bayar</b></div>'; } else {
$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()"'), iBtn('Edit informasi barang', 'bi_edit', 'onclick="katalog_form(\'uf\',\'' . $rk['replid'] . '\')"'), 'add'); notifbox(); 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']; ?>
<b>Tampilkan:</b> </div>'; $t .= '<div class="sfont" style="float:left;width:100%;margin-bottom:15px"><b>tanggal:</b>'; $t .= ' <a href="javascript:void(0)" class="linkb" onclick="transaksi_ctgl_set(1)" >[hari ini]</a>'; $t .= ' <a href="javascript:void(0)" class="linkb" onclick="transaksi_ctgl_set(2)" >[bulan ini]</a>'; $t .= '</div>'; $t .= '<div style="float:left;width:100%;margin-bottom:40px">'; $tglSearch = inputDate('tanggal1', $tanggal1); $tglSearch .= '<div class="sfont" style="float:left;margin-right:4px;margin-top:4px"> sampai </div>'; $tglSearch .= inputDate('tanggal2', $tanggal2); $tglSearch .= '<button style="float:left;margin-left:30px;margin-right:4px" class="btnz" onclick="transaksi_get()">'; $tglSearch .= '<div class="">Tampilkan »</div>'; $tglSearch .= '</button>'; $t .= $tglSearch; $t .= '</div>'; $xtable->btnbar_f('print', 'srcbox', $t . '<br>', $s); hiddenval('modul', $modid); hiddenval('pembayaran', 0); if ($xtable->ndata > 0) { $xtable->head('@No pendaftaran', '@Nama', 'Biaya pendaftaran{R}', 'Jumlah dibayar{R}', '@Tanggal pembayaran', '@Status'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); $xtable->td($r['nopendaftaran'], 120); $xtable->td($r['nama']); $xtable->td(fRp($r['nominal']), 110, 'r'); $xtable->td(fRp($r['jmlbayar']), 110, 'r'); if ($r['lunas'] == '1') { $s = '<div style="padding:2px;border-radius:2px;background:#00d000;color:#fff;width:96px;margin:auto"><b>Sudah bayar</b></div>'; } else { $s = '<button class="btn" title="Klik untuk transaksi pembayaran." onclick="E(\'pembayaran\').value=' . $r['replid'] . ';pembayaran_form(\'af\')" style="width:100px">Belum bayar</button>'; }
<tr height="26px"> <td width="<?php echo $labelw; ?> " align="left"><b>Kode atau nama barang:</b></td> <td width="200px"> <?php echo iText('keyword', $keyword, 'width:' . '375px;float:left;margin-right:2px'); ?> <button class="find21" style="float:left;margin-top:2px" title="Cari" onclick="pencarian_get()"></button> </td> <td width="*"> </td></tr> </table></div> <?php $xtable->btnbar_f('notifbox', $fmsg); $xtable->noopt = true; if ($xtable->ndata > 0) { // Table head $xtable->head('Kode', 'Nama', 'Keterangan'); $nom = 1; while ($r = mysql_fetch_array($t)) { $xtable->row_begin(); //$num_judul = @mysql_num_rows(mysql_query("SELECT * FROM sar_pustaka WHERE format=".$r['replid'])); //$num_pustaka = @mysql_fetch_row(mysql_query("SELECT COUNT(d.replid) FROM sar_pustaka p, sar_daftarpustaka d WHERE d.pustaka=p.replid AND p.format=".$r['replid'])); $xtable->td($r['kode'], 60); $xtable->td($r['nama'], 250); //$xtable->td($num_judul,100); //$xtable->td($num_pustaka[0],100); $xtable->td(nl2br($r['keterangan'])); //$xtable->opt_ud($r['replid']);
<?php $fmod = 'golongan'; $xtable = new xtable($fmod); $xtable->use_urut('psb_golongan'); // Query $t = mysql_query("SELECT * FROM psb_golongan ORDER BY urut"); $xtable->ndata = mysql_num_rows($t); $xtable->btnbar_f('add', 'updn'); if ($xtable->ndata > 0) { // Table head $xtable->head('Nama golongan', 'Keterangan'); while ($r = mysql_fetch_array($t)) { $xtable->row_begin($r['replid']); $xtable->td($r['golongan'], 200); $xtable->td($r['keterangan']); $xtable->opt_ud($r['replid']); $xtable->row_end(); } $xtable->foot(); } else { $xtable->nodata(); }
} $lok = gpost('lokasi'); $grup = gpost('grup'); hiddenval('lokasi', $lok); hiddenval('grup', $grup); if ($opt == 'af' || $opt == 'uf') { require_once VWDIR . 'katalog_form.php'; } else { // Query $sql = "SELECT * FROM sar_katalog WHERE grup='{$grup}'"; $t = mysql_query($sql); $xtable->ndata = mysql_num_rows($t); // Page sort and order $po = $xtable->pageorder_sql('kode', 'nama'); $t = mysql_query($sql . $po); $xtable->btnbar_f('b-Inventaris', 'add'); notifbox(); hiddenval('opf', 'kat'); ?> <div class="tbltopmbar" style="float:left;margin-top:10px"> <table class="stable" cellspacing="0" cellpadding="0" width="100%"> <tr height="30px"><td colspan="2" align="center" style="font-size:15px">Grup Barang <b><?php echo grup_name($grup); ?> </b></td></tr> <tr height="24px"><td width="100px">Lokasi:</td><td><?php echo lokasi_name($lok); ?> </td></tr> <tr height="24px"><td width="100px">Total aset:</td><td><?php echo fRp(grup_aset($grup));