barang_revolut3.php

<?php

        $sql = "SELECT a.kodebarang, a.namabarang, a.jumlah AS Saldo_Awal,
                (SELECT SUM(jumlah) FROM barang AS b WHERE b.kodebarang=a.kodebarang AND b.pembelian>0) AS Penambahan,
                (SELECT SUM(jumlah) FROM barang AS b WHERE b.kodebarang=a.kodebarang AND b.penjualan>0) AS Pengurangan
                FROM masterbarang AS a GROUP BY a.kodebarang order by namabarang";

        $datatamu = mysqli_query($con,$sql) or die("Gagal :".mysqli_error());

        echo "<table width='50%' align='center' border='1'>
                <tr>
                        <th>Nomor</th>
                        <th>Kode Barang</th>
                        <th>Nama Barang</th>
                        <th>Saldo Awal</th>
                        <th>Penambahan</th>
                        <th>Pengurangan</th>
                        <th>Balance</th>
        </tr>\n";
        $j = $ttl_awal = $ttl_masuk = $ttl_keluar = $ttl_saldo = 0;
        while($rec=mysqli_fetch_array($datatamu)) {
                $j++;
                $awal   = $rec['Saldo_Awal'];
                $masuk  = $rec['Penambahan'];
                $keluar = $rec['Pengurangan'];
                $saldo  = $awal + $masuk - $keluar;

                $ttl_awal   += $awal;
                $ttl_masuk  += $masuk;
                $ttl_keluar += $keluar;
                $ttl_saldo  += $saldo;

                $str_awal   = number_format($awal,0,',','.');
                $str_masuk  = number_format($masuk,0,',','.');
                $str_keluar = number_format($keluar,0,',','.');
                $str_saldo  = number_format($saldo,0,',','.');

                echo "<tr><td align=right>&nbsp;$j&nbsp;</td>
                <td>". $rec["kodebarang"] ."</td>
                <td>". $rec["namabarang"] ."</td>
                <td align=right>&nbsp;$str_awal&nbsp;</td>
                <td align=right>&nbsp;$str_masuk&nbsp;</td>
                <td align=right>&nbsp;$str_keluar&nbsp;</td>
                <td align=right>&nbsp;$str_saldo&nbsp;</td>
                </tr>\n";
        }
        mysqli_free_result($datatamu);

        $str_awal   = number_format($ttl_awal,0,',','.');
        $str_masuk  = number_format($ttl_masuk,0,',','.');
        $str_keluar = number_format($ttl_keluar,0,',','.');
        $str_saldo  = number_format($ttl_saldo,0,',','.');

        echo "<tr><td align=center colspan=3>Total</td>
                <td align=right>&nbsp;$str_awal&nbsp;</td>
                <td align=right>&nbsp;$str_masuk&nbsp;</td>
                <td align=right>&nbsp;$str_keluar&nbsp;</td>
                <td align=right>&nbsp;$str_saldo&nbsp;</td>
                </tr>\n";

        echo "</table>\n";
        mysqli_close($con);
?>