| Date |
Voucher |
Product Details |
Rate |
Pch. Qty |
Sale/Return Qty |
Debit |
Credit |
Due Balance |
| {{ date('d-m-Y',strtotime(request('start_date'))) }} |
Opening Balance |
|
|
|
|
|
|
{{ ($opening_balance) }} |
@php
$total_due = $opening_balance;
$t_invoice = 0;
$t_expense = 0;
$t_return = 0;
$t_payment = 0;
$t_discount = 0;
$t_due = 0;
@endphp
@foreach ($allData as $key => $data)
@php
if(!$data['orderId']){
$total_due += $data['invoice'] + $data['expense'] - $data['return'] - $data['payment'] - $data['discount'];
$t_invoice += $data['invoice'];
$t_expense += $data['expense'];
$t_return += $data['return'];
$t_payment += $data['payment'];
$t_discount += $data['discount'];
$t_due = $total_due;
}
if ($data['orderId']){
$orderItems = \App\Models\SaleOrderDetail::where('sale_order_id',$data['orderId'])->get();
}
@endphp
{{-- {{ dd($orderItems) }}--}}
@if($data['orderId'] && $data['type']=='SALE')
@foreach($orderItems as $orderItem)
@php
$total_due += $orderItem->total_amount;
$t_invoice += $orderItem->total_amount;
$t_return += 0;
$t_payment += 0;
$t_due = $total_due;
@endphp
| {{ date('d-m-Y',strtotime($data['date'])) }} |
{{ $data['particular'] }} |
{{ $orderItem->product->name??'' }} |
{{ ($orderItem->unit_price) }} |
{{ (0) }} |
{{ ($orderItem->quantity) }} |
{{ ($orderItem->total_amount) }} |
{{ (0) }}
|
{{ ($total_due) }} |
@endforeach
@php
$saleOrder = \App\Models\SaleOrder::find($data['orderId']);
@endphp
@if($saleOrder->transport_cost > 0)
@php
$total_due += $saleOrder->transport_cost;
$t_invoice += $saleOrder->transport_cost;
$t_return += 0;
$t_payment += 0;
$t_due = $total_due;
@endphp
| {{ date('d-m-Y',strtotime($data['date'])) }} |
{{ $data['particular'] }} |
{{ 'Transport Cost' }} |
|
|
|
{{ ($saleOrder->transport_cost) }} |
{{ (0) }}
|
{{ ($total_due) }} |
@endif
@if($saleOrder->discount_total > 0)
@php
$total_due -= $saleOrder->discount_total;
$t_invoice -= 0;
$t_return += $saleOrder->discount_total;
$t_payment += 0;
$t_due = $total_due;
@endphp
| {{ date('d-m-Y',strtotime($data['date'])) }} |
{{ $data['particular'] }} |
{{ 'Order discount' }} |
|
|
|
{{ (0) }} |
{{ ($saleOrder->discount_total) }}
|
{{ ($total_due) }} |
@endif
@elseif($data['orderId'] && $data['type']=='RETURN')
@foreach($orderItems as $orderItem)
@php
$total_due -= $orderItem->total_amount;
$t_invoice += 0;
$t_return += $orderItem->total_amount;
$t_payment += 0;
$t_due = $total_due;
@endphp
| {{ date('d-m-Y',strtotime($data['date'])) }} |
{{ $data['particular'] }} |
{{ $orderItem->product->name??'' }} |
{{ ($orderItem->unit_price) }} |
{{ (0) }} |
{{ ($orderItem->quantity) }} |
{{ (0) }} |
{{ ($orderItem->total_amount) }}
|
{{ ($total_due) }} |
@endforeach
@else
| {{ date('d-m-Y',strtotime($data['date'])) }} |
{{ $data['particular'] }} |
|
|
|
|
{{ $data['invoice'] == 0 ? ($data['expense']) : ($data['invoice']) }}
|
@if($data['return'] != 0)
{{ ($data['return']) }}
@elseif($data['payment'] != 0)
{{ ($data['payment']) }}
@elseif($data['discount'] != 0)
{{ ($data['discount']) }}
@endif
|
{{ ($total_due) }} |
@endif
@endforeach
| Total |
{{ ($t_invoice+$t_expense) }} |
{{ ($t_payment+$t_return+$t_discount) }} |
{{ ($t_due) }} |