@extends('includes.main')

@section('main-container')
    {{-- <div class="card">
        <div class="card-body"> --}}
    <div class="container-fluid">
        <div class="row">
            <div class="col-12">
                <h1>Cash Report</h1>
                <div class="separator mb-5"></div>
            </div>
        </div>

        {{-- Supply form --}}
        <div class="card mb-4">
            <div class="card-body">
                <h5 class="mb-4">Report Filter</h5>
                <form method="POST" id="frm-supply" action="{{ route('report') }}">
                    @csrf
                    <div class="form-row">
                        <div class="form-group col-md-4">
                            <label>From Date</label>
                            <input type="date" class="form-control" name="from_date" id="date" autocomplete="off"
                                placeholder="Date">
                        </div>

                        <div class="form-group col-md-4">
                            <label>To Date</label>
                            <input type="date" class="form-control datepicker" name="to_date" id="date"
                                autocomplete="off" placeholder="Date">
                        </div>

                        <div class="form-group col-md-4">
                            <label>Report By</label>
                            <select name="report_by" id="report-by" class="form-control">
                                <option value="">Select</option>
                                <option value="daily">This Day</option>
                                <option value="monthly">This Month</option>
                                <option value="yearly">This Year</option>
                            </select>
                        </div>
                    </div>
                    <button type="submit" id="" class="btn btn-primary d-block mt-3">Filter</button>
                </form>
            </div>
        </div>

        {{-- Table form --}}
        <div class="row mb-4">
            <div class="col-lg-12 col-md-12 mb-4">
                <div class="row icon-cards-row mb-4">

                    @php
                        // Define icons
                        $icons = [
                            'Expense' => 'https://icons.iconarchive.com/icons/iconsmind/outline/128/Financial-icon.png',
                            'Total Sale' =>
                                'https://icons.iconarchive.com/icons/iconsmind/outline/128/Money-2-icon.png',
                            'Total Sale Later' =>
                                'https://icons.iconarchive.com/icons/iconsmind/outline/128/Coins-icon.png',
                            'Total Profit' =>
                                'https://icons.iconarchive.com/icons/iconsmind/outline/128/Coins-icon.png',
                            'Petrol Stock' =>
                                'https://icons.iconarchive.com/icons/iconsmind/outline/128/Coins-icon.png',
                            'Diesel Stock' =>
                                'https://icons.iconarchive.com/icons/iconsmind/outline/128/Coins-icon.png',
                            'Oogra Total Diesel' =>
                                'https://icons.iconarchive.com/icons/iconsmind/outline/128/Coins-icon.png',
                            'Oogra Total Petrol' =>
                                'https://icons.iconarchive.com/icons/iconsmind/outline/128/Coins-icon.png',
                            'Oogra Total' => 'https://icons.iconarchive.com/icons/iconsmind/outline/128/Coins-icon.png',
                            'Oogra Total Profit' =>
                                'https://icons.iconarchive.com/icons/iconsmind/outline/128/Coins-icon.png',
                        ];

                        // Define values
                        $values = [
                            'Expense' => $expenses ?? 0,
                            'Total Sale' => $totalDispenserSale ?? 0,
                            'Total Sale Later' =>
                                ($totalSaleLater ?? 0) - (($totalOograDiesel ?? 0) + ($totalOograPetroll ?? 0)),
                            'Total Profit' =>
                                ($totalProfit ?? 0) -
                                (($totalOogra[1] ?? 0) + ($totalOogra[2] ?? 0) + ($extraProfit ?? 0)),
                            'Petrol Stock' => $Petrols ?? 0,
                            'Diesel Stock' => $Diesel ?? 0,
                            'Oogra Total Diesel' => $totalOograDiesel ?? 0,
                            'Oogra Total Petrol' => $totalOograPetroll ?? 0,
                            'Oogra Total' => ($totalOograDiesel ?? 0) + ($totalOograPetroll ?? 0),
                            'Oogra Total Profit' => ($totalOogra[1] ?? 0) + ($totalOogra[2] ?? 0),
                        ];
                    @endphp

                    @foreach ($values as $label => $value)
                        <div class="col-md-4 col-lg-4 col-sm-4 col-6 mb-4">
                            <a href="#" class="card">
                                <div class="card-body text-center">
                                    <img src="{{ $icons[$label] }}" width="128" height="128">
                                    <p class="card-text font-weight-semibold mb-0">{{ $label }}</p>
                                    <p class="lead text-center">{{ $value }}</p>
                                </div>
                            </a>
                        </div>
                    @endforeach

                </div>
            </div>
        </div>


        {{-- <div class="col-md-3 col-lg-3 col-sm-3 col-6 mb-4">
                     <a href="#" class="card">
                        <div class="card-body text-center">
                           <i class="iconsminds-coins"></i>
                           <p class="card-text font-weight-semibold mb-0">Total Remain</p>
                           <p class="lead text-center">{{ $transectionsData['totalRemain'] ?? 0 }}</p>
                        </div>
                     </a>
                  </div> --}}
        @if (isset($customerTransactions) && $customerTransactions->count() > 0)
            <div class="card mb-5">
                <div class="card-body">
                    <h5 class="card-title float-left">Customer Transection List</h5>
                    <table class="table">
                        <thead>
                            <tr>
                                <th>Customer Name</th>
                                <th>Credit</th>
                                <th>Debit</th>
                                <th>Detail</th>
                                <th>Remaining</th>

                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($customerTransactions as $transaction)
                                <tr>
                                    <td>{{ $transaction->customer->name }}</td>
                                    <td>{{ $transaction->credit }}</td>
                                    <td>{{ $transaction->debit }}</td>
                                    <td>{{ $transaction->detail }}</td>
                                    <th> <strong>{{ number_format($transaction->total_remaining, 2) }}</strong></th>
                                </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        @else
            <p>No transactions found.</p>
        @endif


        <div class="card">
            @if (session()->has('type'))
                <div class="alert alert-{{ session()->get('type') }}" role="alert">
                    <p>{{ session()->get('message') }}</p>
                </div>
            @endif
            @if ($errors->any())
                <div class="alert alert-danger" role="alert">
                    <ul>
                        @foreach ($errors->all() as $error)
                            <li>{{ $error }}</li>
                        @endforeach
                    </ul>
                </div>
            @endif
            <div class="card-body">
                <h5 class="card-title float-left">Supplies List</h5>
                <table class="table">
                    <thead>
                        <tr>
                            <th>Title</th>
                            <th>Product</th>
                            <th>New Reading</th>
                            <th>Old Reading</th>
                            <th>Sale Later</th>
                            <th>Date</th>
                        </tr>
                    </thead>
                    <tbody>
                        {{-- @foreach ($dispenserReportArray as $title => $items)
                                        @foreach ($items as $item)
                                            <tr>
                                                <td>{{$item->title}}</td>
                                            </tr>                                            
                                        @endforeach
                                        
                                    @endforeach --}}
                        @php
                            $total_sale_later = 0;
                            $temp_product = '';
                            $temp_sale = 0;
                            $temp_price = 0;
                        @endphp
                        @forelse ($dispenserReportArray ?? [] as $profits)
                            @foreach ($profits as $profit)
                                @php
                                    $sale_later = $profit->reading - $profit->old_reading;
                                @endphp

                                                                @php
                                    $temp_product = $profit->title;
                                    $temp_price = $profit->sale_price;
                                    $total_sale_later += $sale_later;
                                @endphp
                                
                                <tr class="item-row-{{ $profit->product_id }}">
                                    <th>{{ $profit->dispenser_id }}</th>
                                    <th>{{ $profit->title }}</th>
                                    <td>{{ $profit->reading }}</td>
                                    <td>{{ $profit->old_reading }}</td>
                                    <td>{{ $sale_later }}</td>
                                    <td>{{ $profit->date }}</td>
                                </tr>

                                                            @endforeach
                        @empty
                            <tr>
                                <td colspan="4" align="center">
                                    No record found.
                                </td>
                            </tr>
                        @endforelse
                        </form>
                    </tbody>
                </table>
            </div>
        </div>
    </div>

@endsection