@extends('admin.layouts.master')
@section('title', 'Day Collection')
@section('content')

    <!-- Page Wrapper -->
    <div class="page-wrapper">
        <div class="content container-fluid">

            <!-- Page Header -->
            <div class="page-header">
                <div class="row">
                    <div class="col">
                        <h3 class="page-title">Day Collection</h3>
                        <ul class="breadcrumb">
                            <li class="breadcrumb-item"><a href="{{ route('dashboard') }}">Dashboard</a></li>
                            <li class="breadcrumb-item active">Day Collection</li>
                        </ul>
                    </div>
                    <div class="panel-heading col-md-2">
                        <!-- <a href="" class="btn btn-block btn-primary">Add Order</a>-->

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

            <div class="row">
                <div class="col-sm-12">

                    <div class="card">
                        <div class="card-header">
                            Filter
                        </div>
                        <div class="card-body">
                            <form action="/day_collection" method="get">
                                <div class="row">
                                    <div class="col-md-3">


                                        <label>Date</label>
                                        <input type="date" name="date" class="form-control" id="my_date_picker"
                                               value="@php if(isset($_GET['date'])){echo $_GET['date'];}else{ echo date('Y-m-d');} @endphp"
                                               onchange="this.form.submit();">


                                    </div>
                                    <div class="col-md-3">
                                        <label>Deliveryboy</label>
                                        <select class="form-control" name="deliveryboy" onchange="this.form.submit()">
                                            <option value="">--Choose Deliveryboy--</option>
                                            @foreach($filter_deliveryboy as $c)
                                                <option value="{{$c->id}}" @if(isset($_GET['deliveryboy']) && $_GET['deliveryboy']==$c->id) selected @endif>{{$c->name}}</option>
                                            @endforeach
                                        </select>
                                    </div>

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

                    <div class="card">

                        <div class="card-body">
                            @include('admin.includes.msg')
                            <div class="table-responsive">
                                <table class="datatable table table-stripped">
                                    <thead>
                                    <tr>
                                        <!--<th>Sl.No</th>-->
                                        <th>Order Id</th>
                                        <th>Price</th>
                                        <th>Return</th>
                                        <th>Discount</th>
                                        <th>total Epay</th>
                                        <th>total cash</th>
                                        <th>total payment</th>
                                        <th>outstanding amount</th>
                                        <th>Deliveryboy</th>
                                        <th>Status</th>
                                        <th>Delivered Date</th>
                                        <th>payment logs</th>
                                        <th>Action</th>
                                    </tr>
                                    </thead>
                                    <tbody>

                                        @php  $totalreceive=0;$totalreturn_price=0;$totaldiscount=0;$totalepay=0;$totalcash=0;$totalpay=0; @endphp
                                        @foreach($order1 as $key=>$val)

                                            <tr>
                                                <!--<td>{{$key+1}}</td>-->
                                                <td>{{ $val->orderId}}<br>
                                                    @php echo date('h:i A, d M', strtotime($val->created_at)) @endphp
                                                </td>
                                                <td>Rs {{ number_format($val->totalPrice,2)}} @php  $totalreceive+=floatval($val->totalPrice); @endphp</td>
                                                <td>Rs {{ number_format($val->return_price,2)}} @php  $totalreturn_price+=floatval($val->return_price); @endphp</td>
                                                <td>Rs {{ number_format($val->discount,2)}} @php  $totaldiscount+=floatval($val->discount); @endphp</td>                                                
                                                <td>
                                                    Rs {{ number_format(floatval($val->payment_mode['Epay'] ?? 0), 2) }}
                                                    @php
                                                       $totalepay += isset($val->payment_mode['Epay']) ? floatval($val->payment_mode['Epay']) : 0;
                                                    @endphp
                                                </td>
                                                <td>
                                                    Rs {{ number_format(floatval($val->payment_mode['ByCash'] ?? 0), 2) }}
                                                    @php
                                                       $totalcash += isset($val->payment_mode['ByCash']) ? floatval($val->payment_mode['ByCash']) : 0;
                                                    @endphp
                                                </td> 
                                                <td>
                                                    @php 
                                                    $tempepay = isset($val->payment_mode['Epay']) ? floatval($val->payment_mode['Epay']) : 0;
                                                    $tempcash = isset($val->payment_mode['ByCash']) ? floatval($val->payment_mode['ByCash']) : 0;
                                                    @endphp
                                                    Rs {{ number_format($tempepay + $tempcash,2)}}

                                                </td>
                                                <td>Rs {{ $val->outstandingamount}}</td>
                                                <td>
                                                    {{ $val->deliveryboy ?? 'N/A'}}
                                                </td>
                                                <td>{{ $val->orderStatus ?? 'N/A'}}</td>
                                                <td>{{ $val->delivered_date ?? 'N/A'}}</td>
                                                <td>
                                                    <a href="#" data-toggle="modal" data-target="#myModal" onclick="details({{ $val->payment_method_details }})"><img src="../admin/assets/img/details.png" style="width: 20px;">Details</a>
                                                </td>                                                
                                                <td>
                                                    @if($val->id)
                                                        @if($val->is_cash_receive==0)
                                                            <a href="/cash_receive/approve/{{ $val->id }}" class="btn-info btn"> Approve</a>
                                                        @else
                                                            Received
                                                        @endif
                                                    @endif    
                                                </td>

                                            </tr>
                                        @endforeach
                                         

                                    </tbody>
                                    <tfooter>
                                        <tr style="background: #f8f9fa;">
                                            <td><b>Total</b></td>
                                            <td><b>Rs {{number_format($totalreceive,2)}}</b></td>
                                            <td><b>Rs {{number_format($totalreturn_price,2)}}</b></td>
                                            <td><b>Rs {{number_format($totaldiscount,2)}}</b></td>
                                            <td><b>Rs {{number_format($totalepay,2)}}</b></td>
                                            <td><b>Rs {{number_format($totalcash,2)}}</b></td>
                                            <td><b>Rs {{number_format($totalepay + $totalcash,2)}}</b></td>
                                            <td><b>Rs {{number_format($finaloutstandingamount,2)}}</b></td>
                                            <td></td>
                                            <td></td>
                                            <td></td>
                                            <td></td>


                                        </tr>
                                    </tfooter>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>


        </div>
    </div>
@endsection

<script>
    function details(id) {
        const jsonData = JSON.stringify(id, null, 2);
        const data = JSON.parse(jsonData);
//        alert(data);
        // Get table body element
        const tableBody = document.getElementById('paymentTable').querySelector('tbody');
        // Function to populate the table
        function populateTable(data) {
            tableBody.innerHTML = ''; 
            if (Array.isArray(data) && data.length > 0) {
                data.forEach(row => {
                    const tr = document.createElement('tr');
                    const paymentAmount = parseFloat(row.payment_amount || 0).toFixed(2);
            
                    tr.innerHTML = `
                        <td>${row.payment_mode}</td>
                        <td>₹${paymentAmount}</td>
                        <td>${row.payment_note || 'N/A'}</td>
                    `;
                    tableBody.appendChild(tr);
                });
            }else{
                const tr = document.createElement('tr');
                tr.innerHTML = `
                    <td colspan="3" style="text-align: center;">No Payment Details</td>
                `;
                tableBody.appendChild(tr);
            }
        }

        // Call the function
        populateTable(data);

        
        //let d = JSON.stringify(id, null, 2);
        //alert(d);
        $(".modal-footer").hide();
        $(".modal-title").text("Payment logs");
        //$.get("/details/" + id, function (res) {
            //$(".modal-body").html(d);
        //})
    }
</script>


<!-- Modal -->
<div id="myModal" class="modal fade" role="dialog">
    <div class="modal-dialog modal-lg">

        <!-- Modal content-->
        <div class="modal-content">
            <div class="modal-header">
                <h4 class="modal-title">Modal Header</h4>
                <button type="button" class="close" data-dismiss="modal">&times;</button>
            </div>
            <div class="modal-body">
                <table class="table table-bordered" id="paymentTable">
                    <thead>
                        <tr>
                            <th>Payment Mode</th>
                            <th>Payment Amount</th>
                            <th>Payment Note</th>
                        </tr>
                    </thead>
                    <tbody>
                        <!-- JavaScript will populate rows here -->
                    </tbody>
                </table>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
            </div>

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