php - Laravel 5.4 Credit, Debit and Balance Calculation

Question

Now I am doing Invoice Application using Laravel Framework 5.4.

I Save Credit and Debit Amount in Transaction Table. I want to Display Credit amount, Debit amount, Balance Amount in Blade Template (same as like below)

Answer 1

In your Controller :

$transaction = DB::table('transaction')->get();

In your Blade :

        <?php $tbalance=0; ?>
       @foreach($transaction as $trans)
         <tr>
<td>{{$invaccstatements->ref_no}} </td>
<td>{{number_format($invaccstatements->credit, 2)}}</td>
<td>{{number_format($invaccstatements->debit, 2)}}</td>
<td align="right"><?php $chkbala = $invaccstatements->credit - $invaccstatements->debit;  echo $tbalance += $chkbala; ?></td>
</tr> 
    @endforeach