total laba

<table class="table table-striped"id="example">
    <thead class="text-danger">
        <tr>
            <th>No</th>
            <th>Tanggal</th>
            <th>Jual Beli Harian</th>
            <th>Modal Harian</th>
            <th>Laba Kotor</th>
            <th>Pengeluaran</th>
            <th>Laba Bersih</th>
        </tr>
    </thead>
    <tbody>
    <?php
        $no=1;
        $total_all=0;
        $query="
            SELECT a.tgl_transaksi, a.jumlah_pesan,
                SUM(a.total_bayar) AS total,
                SUM(c.modal_tiba * a.jumlah_pesan) AS modal,
                d.jumlah_keluar
            FROM tb_transaksi a
                JOIN tb_historybeli b USING(id_customer)
                JOIN tb_barang c USING(id_barang)
                LEFT JOIN tb_keluar_harian d USING(id_transaksi)
            GROUP BY a.tgl_transaksi
        ";
        $sql = mysqli_query($con,$query) or die(mysqli_error($con));
        while ($data=mysqli_fetch_array($sql)) {
            ?>
            <tr>
                <td><b><?php echo $no++ ?>.</b></td>
                <td>
                <?php
                if ($data['tgl_transaksi']==date('Y-m-d')) {
                      echo "<span class='btn btn-danger btn-block' style='background-color:red;'>"
                           ."<i>".$data['tgl_transaksi']."</i></span>";
                }else{
                     echo $data['tgl_transaksi'];
                }
                ?>
                </td>
                <td><?php echo "Rp.".number_format($data['total']).",-";?></td>
                <td><?php echo "Rp.".number_format( $data['modal']).",-"; ?></td>
                <td><?php echo "Rp.".number_format( $data['total'] -$data['modal']).",-"; ?></td>
                <td><?php echo "Rp.".number_format($data['jumlah_keluar']).",-"; ?></td>
                <td>
                <?php
                    $laba_bersih = $data['total'] -$data['modal'] -$data['jumlah_keluar'];
                    echo "Rp.".number_format($laba_bersih).",-";?>
                </td>
            </tr>
            <?php
            $total_all += $laba_bersih ;
        }
        ?>
        <tr>
            <td colspan="5" align="right"><h4>Total</h4></td>
            <td><h4><?php echo "Rp.".number_format($total_all).",-";  ?></h4></td>
        </tr>
    </tbody>
 </table>