| SI.No. |
Item Code |
Description |
Opn Qty |
Opn Cost |
Total Cost |
Cost Avg |
Qty In |
Total Cost(In) |
Qty Out |
Total Cost(Out) |
Total Balance Qty |
Total Value |
@php $i=$total_balance=$total_value=$total_in=$total_out=0;$total_opnqty=$total_unitcost=$total_purcost=$total_salecost=0; @endphp
@foreach($results as $row)
@php $i++; $total_balance += $row->qty_bal; $total_value += $row->net_value; $total_in += $row->qty_in; $total_out += $row->qty_out;$total_opnqty += $row->opn_qty;$total_unitcost +=$row->unit_cost;$total_purcost +=$row->pur_cost;$total_salecost +=$row->sale_cost; @endphp
| {{$i}} |
{{$row->item_code}} |
{{$row->description}} |
{{$row->opn_qty}} |
{{$row->opn_cost}} |
{{$row->unit_cost}} |
{{number_format($row->cost_avg,2)}} |
{{$row->qty_in}} |
{{$row->pur_cost}} |
{{$row->qty_out}} |
{{$row->sale_cost}} |
{{$row->qty_bal}} |
{{number_format($row->net_value,2)}} |
@endforeach
| Total: |
{{$total_opnqty}} |
|
{{$total_unitcost}} |
|
{{$total_in}} |
{{$total_purcost}} |
{{$total_out}} |
{{$total_salecost}} |
{{$total_balance}} |
{{number_format($total_value,2)}} |
|