@extends('backend.layouts.master') @section('section-title', 'Report') @section('page-title', 'Daily Report') @push('css') @endpush @section('content')
Reset Print
{{--
--}}
{{--
--}}

Petty Cash ({{ isset($sdate) ? date('m-d-Y', strtotime($sdate)) : '' }})

@if (isset($invoices)) {{-- @dd($sdate) --}}
@php $data = App\Models\BankAccount::first(); $previous_balance = previous_balance($data->id, $sdate) // ? number_format(previous_balance($data->id, $sdate), 2) // : number_format(previous_balance($data->id, $sdate), 2); @endphp

Previous Balance : {{ $previous_balance }}

@php $total_today_sales = 0; $today_sales_bank_amount = 0; $today_total_due = 0; $total_sale=0; $bank_amount_sal = 0; $amount = 0; @endphp @php $bankAccount = App\Models\BankAccount::where('status',1)->get(); $today_sale = App\Models\BankTransaction::where('pay_type','invpay')->where('date',$sdate)->sum('amount'); $today_total_due = App\Models\Invoice::where('date', $sdate)->sum('total_due'); $today_due_coll = App\Models\BankTransaction::where('pay_type','duepay')->where('date',$sdate)->sum('amount'); $today_deposit = App\Models\BankTransaction::where('pay_type','deposit')->where('date',$sdate)->sum('amount'); $today_expense = App\Models\BankTransaction::where('pay_type','expense')->where('date',$sdate)->sum('amount'); $today_purchase = App\Models\BankTransaction::where('pay_type','purchase')->where('date',$sdate)->sum('amount'); $today_pur_due_pay = App\Models\BankTransaction::where('pay_type','purdue')->where('date',$sdate)->sum('amount'); $today_transfer = App\Models\BankTransaction::where('pay_type','transfer')->where('date',$sdate)->sum('amount'); // $today_transfer_from = App\Models\BankTransaction::where('pay_type','transfer')->where('date',$sdate)->sum('amount'); // dd($today_transfer_from->from_bank_id); $today_total_inc = $today_sale + $today_due_coll + $today_deposit ; $today_total_exp = $today_expense + $today_purchase + $today_pur_due_pay ; $today_balance = $today_total_inc - $today_total_exp; $current_balance = $today_balance + $previous_balance; @endphp {{-- today sales --}} {{-- today due --}} @if($today_total_due != 0) @endif {{-- due collection --}} @if($today_due_coll != 0) @endif {{-- deposit --}} @if($today_deposit != 0) @endif {{-- expenses --}} @if($today_expense != 0) @endif {{-- Purchase --}} @if($today_purchase != 0) @endif {{-- Purchase due pay --}} @if($today_pur_due_pay != 0) @endif {{-- bank transfar --}} @if($today_transfer != 0) {{-- --}} @endif @php $count_bank = App\Models\BankTransaction::where('bank_id', $data->id)->count(); $count_tra = App\Models\Transaction::where('bank_id', $data->id)->count(); $current = 0; $current += current_balance($data->id); @endphp {{-- today balance --}} {{-- current balance --}}

Income
Today Sales Method
{{$today_sale}} @foreach($bankAccount as $cash) @php $cash_amount = App\Models\BankTransaction::where('pay_type','invpay')->where('bank_id',$cash->id)->where('date',$sdate)->sum('amount'); @endphp @if($cash_amount) {{$cash->bank_name}}= {{$cash_amount}}
@endif @endforeach
Today Due
Today Due Method
{{ $today_total_due }} @foreach($bankAccount as $cash) @php $due_collect_amount = App\Models\BankTransaction::where('pay_type','duepay')->where('bank_id',$cash->id)->where('date',$sdate)->sum('amount'); @endphp @if($due_collect_amount != 0) {{-- {{$cash->bank_name}}= {{$due_collect_amount}}
--}} @endif @endforeach
Due Collection
Today Due Collection Method
{{ $today_due_coll }} @foreach($bankAccount as $cash) @php $due_collect_amount = App\Models\BankTransaction::where('pay_type','duepay')->where('bank_id',$cash->id)->where('date',$sdate)->sum('amount'); @endphp @if($due_collect_amount != 0) {{$cash->bank_name}}= {{$due_collect_amount}}
@endif @endforeach
Deposit
Today Deposit Method
{{ $today_deposit }} @foreach($bankAccount as $cash) @php $deposit_amount = App\Models\BankTransaction::where('pay_type','deposit')->where('bank_id',$cash->id)->where('date',$sdate)->sum('amount'); @endphp {{$cash->bank_name}}= {{$deposit_amount}}
@endforeach
Expenses
Today Expense Method
{{ $today_expense }} @foreach($bankAccount as $cash) @php $expense_amount = App\Models\BankTransaction::where('pay_type','expense')->where('bank_id',$cash->id)->where('date',$sdate)->sum('amount'); @endphp @if($expense_amount != 0) {{$cash->bank_name}}= {{$expense_amount}}
@endif @endforeach
Purchase
Today Purchase Method
{{ $today_purchase }} @foreach($bankAccount as $cash) @php $purchase_amount = App\Models\BankTransaction::where('pay_type','purchase')->where('bank_id',$cash->id)->where('date',$sdate)->sum('amount'); @endphp @if($purchase_amount != 0) {{$cash->bank_name}}= {{$purchase_amount}}
@endif @endforeach
Purchase Due Payment
Today Purchase Due Payment Method
{{ $today_pur_due_pay }} @foreach($bankAccount as $cash) @php $purchase_due_pay = App\Models\BankTransaction::where('pay_type','purdue')->where('bank_id',$cash->id)->where('date',$sdate)->sum('amount'); @endphp @if($purchase_due_pay != 0) {{$cash->bank_name}}= {{$purchase_due_pay}}
@endif @endforeach
Bank Transfer
AccountFrom AccountAmount
@foreach($bankAccount as $cash) @php $purc_due_pay = App\Models\BankTransaction::where('pay_type','transfer')->where('from_bank_id',$cash->id)->where('date',$sdate)->get(); @endphp @foreach($purc_due_pay as $trans) From {{$trans->from_bank_account->bank_name}} Transfer To {{$trans->to_bank_account->bank_name}}
@endforeach @endforeach 		@foreach($bankAccount as $cash) @php $purc_due_pay = App\Models\BankTransaction::where('pay_type','transfer')->where('from_bank_id',$cash->id)->where('date',$sdate)->get(); @endphp @foreach($purc_due_pay as $trans) {{$trans->amount}}
@endforeach @endforeach
Total Transfer {{$today_transfer}}
Today Balance : {{ $today_balance }} @foreach($bankAccount as $cash) {{$cash->bank_name}}= {{date_current_balance($cash->id,$sdate)}}
@endforeach
Current Balance : {{ $today_balance + previous_balance($data->id, $sdate) }} {{ empty(get_setting('com_currency')) ? : get_setting('com_currency') }}
@else
@endif
@endsection