コード例 #1
0
ファイル: inventaris.php プロジェクト: epiii/siadu-epiii
    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->td(0, 100, 'c');
        $xtable->td(fRp(grup_aset($r['replid'])), 120, 'r');
        $xtable->td(nl2br($r['keterangan']));
        $xtable->opt($r['replid'], 'v', 'u', 'd');
        $xtable->row_end();
    }
    $xtable->foot();
} else {
    $xtable->nodata();
}
コード例 #2
0
ファイル: sar.php プロジェクト: sofiasrifin/sistermetta
function lokasi_aset($d)
{
    $n = 0;
    $t = mysql_query("SELECT replid FROM sar_grup WHERE lokasi='{$d}'");
    while ($r = mysql_fetch_array($t)) {
        $n += grup_aset($r['replid']);
    }
    return $n;
}
コード例 #3
0
    $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));
    ?>
</td></tr>
</table>
</div>
<?php 
    if ($xtable->ndata > 0) {
        // Table head
        $xtable->head('@kode', '@nama barang', 'jenis', 'Jumlah unit~R', 'Aset~R', 'penyusutan<br/>per tahun~R', 'keterangan', '{40px}');
        while ($r = mysql_fetch_array($t)) {
            $xtable->row_begin();
            $n = mysql_num_rows(mysql_query("SELECT replid FROM sar_barang WHERE katalog='" . $r['replid'] . "'"));
            $xtable->td($r['kode'], 80);
            $xtable->td($r['nama'], 200);
            $xtable->td(jenis_name($r['jenis']), 200);
            $xtable->td($n, 80, 'r');