@extends('admin.layouts.master')
@section('title', 'Profite & Loss')
@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">Profite & Loss</h3>
                        <ul class="breadcrumb">
                            <li class="breadcrumb-item"><a href="{{ route('dashboard') }}">Dashboard</a></li>
                            <li class="breadcrumb-item active">Profite & Loss</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="" method="get" id="filter">
                                <div class="row">
                                    <div class="col-md-3">
                                        <label>Date Range</label>
                                        <input type="text" name="date" @if(isset($_GET['date'])) value="{{$_GET['date']}}" @else value="{{ date('Y-m-d', strtotime(' -1 day')) }} - {{ date('Y-m-d') }}"
                                               @endif placeholder="Filter Time" class="form-control" id="daterange">
                                    </div>
                                    <div class="col-md-3">
                                        <label>Select City</label>
                                        <select class="form-control" name="city" id="citySelect">
                                            <option value="">--Search by city--</option>
                                            @foreach($city as $c)
                                                <option value="{{ $c->id }}" 
                                                    @if(request('city') == $c->id) selected @endif>
                                                    {{ $c->cityName }}
                                                </option>
                                            @endforeach
                                        </select>
                                    </div>
                                    <div class="col-md-3">
                                        <label>Select Retailer</label>
                                        <select class="form-control" name="retailer" id="retailerSelect">
                                            <option value="">--Search by retailer--</option>
                                            @foreach($retailers as $r)
                                                <option value="{{ $r->id }}" 
                                                    @if(request('retailer') == $r->id) selected @endif>
                                                    {{ $r->name }} ({{ $r->address }})
                                                </option>
                                            @endforeach
                                        </select>
                                    </div>
                                    <div class="col-md-3">
                                        <label>Select Telecaller</label>
                                        <select class="form-control" name="telecaller" id="telecallerSelect">
                                            <option value="">--Search by Telecaller--</option>
                                            <option value="pos">Point of sale</option>                                            
                                            @foreach($telecaller as $r)
                                                <option value="{{ $r->id }}" 
                                                    @if(request('telecaller') == $r->id) selected @endif>
                                                    {{ $r->name }} ({{ $r->address }})
                                                </option>
                                            @endforeach
                                        </select>
                                    </div>                                    
                                </div>
                                <div class="row" style="padding-top: 20px;">
                                    <div class="col-sm-12 col-md-6"></div>
                                    <div class="col-sm-12 col-md-6">
                                        <div id="DataTables_Table_0_filter" style="text-align: right;">
                                            <label>
                                                <form action="" method="get">
                                                    <input type="search" name="search" value="" class="search form-control form-control-sm" placeholder="Search By order Id" style="margin-left: 0.5em;display: inline-block;width: auto;">
                                                    <button type="submit" class="btn btn-sm btn-primary">
                                                        Search
                                                    </button>
                                                </form>
                                            </label>
                                        </div>
                                    </div>
                                </div>
                            </form>
                        </div>
                        
                        <div class="card-body" style="padding-top: 0;">
                            <b>Total Price</b>: Rs {{ number_format($totalPriceAll, 2) }} <br>
                            <b>Total Profit</b>: Rs {{ number_format($totalProfitAll, 2) }} <br>
                            <b>Total Net Profit</b>: Rs {{ number_format($totalNetProfitAll, 2) }} <br>
                        </div>
                    </div>
                    <div class="card">
                        <div class="card-body">
                            @include('admin.includes.msg')
                            <div class="table-responsive">
                                <table class="datatable1 table table-stripped">
                                    <thead>
                                    <tr>
                                        <th>Sl.No</th>
                                        <th>Order Id</th>
                                        <th>Price</th>
                                        <th>Customer</th>
                                        <th>Outstanding Amount</th>
                                        <th>Profit</th>
                                        <th>Net Profit</th>
                                        <th>Status</th>
                                        <th>Billed By</th>
                                    </tr>
                                    </thead>
                                    <tbody>
                                    @if(!empty($order) &&  $order->count()>0)
                                        @foreach($order as $key=>$val)

                                            <tr>
                                                <td>{{$key+1}}</td>
                                                <td>{{ $val->orderId}}<br>
                                                    @php echo date('h:i A, d M y', strtotime($val->created_at)) @endphp
                                                </td>
                                                <td>Rs {{ $val->totalPrice}} @if($val->commission>0) <br>Paid Amount : {{$val->totalPrice-$val->commission}}  @endif</td>
                                                <td>
                                                    <a href="/customerorderreport/{{$val->userId}}"> 
                                                        {{  $val->firstName }}
                                                    </a>
                                                    <br>
                                                    {{  $val->mobile }}
                                                </td>
                                                <td>
                                                    {{  $val->real_outstanding }}
                                                </td>
                                                <td>
                                                    <a  href="#" data-toggle="modal" data-target="#myModal" onclick="billprofit({{ $val->id}})">
                                                        Rs {{ number_format($val->profit,2)}}
                                                    </a>
                                                </td>
                                                <td>
                                                    Rs {{ number_format($val->netprofit,2)}}
                                                </td>
                                                <td>
                                                    @if($val->is_pos==1)
                                                     <span class="badge badge-warning"> COUNTER </span>
                                                    @endif
                                                    @if($val->orderStatus=="Cancel" || $val->orderStatus=="Deleted")
                                                        <span class="badge badge-danger"> Cancelled </span>
                                                    @elseif($val->orderStatus=="Delivered")
                                                        <span class="badge badge-success"> {{ $val->orderStatus}} </span>
                                                         @if($val->is_pos==1)
                                                          <br>  @php echo date("h:i A, d M ", strtotime($val->created_at));@endphp
                                                         @else
                                                        <br>  @php echo date("h:i A, d M ", strtotime($val->delivered_date));@endphp
                                                        @endif
                                                        <br>  @if(@$logorderIds[$val->id]>0) <code>Partially Returned</code>@endif
                                                    @else
                                                        <span class="badge badge-warning"> {{ $val->orderStatus}} </span>
                                                    @endif


                                                </td>

                                                <td>
                                                    {{ $telecallerMap[$val->telecaller] ?? 'Point of sale' }}
                                                </td>

                                            </tr>
                                        @endforeach

                                    @endif
                                    </tbody>
                                </table>
                                <div class="row">
                                    <div class="col-sm-12 col-md-5">
                                        <div class="dataTables_info" id="DataTables_Table_0_info" role="status" aria-live="polite">
                                            Showing {{ $order->firstItem() }} to {{ $order->lastItem() }} of {{ $order->total() }}  entries
                                        </div>                                            
                                    </div>
                                    <div class="col-sm-12 col-md-7">                                        
                                        {{ $order->appends(Request::except('page'))->links('pagination::bootstrap-4') }}
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>


        </div>
    </div>
    <script type="text/javascript" src="https://cdn.jsdelivr.net/momentjs/latest/moment.min.js"></script>
    <script type="text/javascript" src="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.min.js"></script>
    <link rel="stylesheet" type="text/css" href="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.css"/>


    <script>
        $(function () {
            $('#daterange').daterangepicker({
                timePicker: false,

                locale: {
                    format: 'Y-M-D',
                }
            }, function (start, end, label) {
                setTimeout(function () {
                    $("#filter").submit();
                }, 500);

            });
        });

    </script>
    <script>
        document.addEventListener('DOMContentLoaded', function () {
            const citySelect = document.getElementById('citySelect');
            const retailerSelect = document.getElementById('retailerSelect');
            const telecallerSelect = document.getElementById('telecallerSelect');
            citySelect.addEventListener('change', function () {
                document.getElementById('filter').submit();
            });
            retailerSelect.addEventListener('change', function () {
                document.getElementById('filter').submit();
            });
            telecallerSelect.addEventListener('change', function () {
                document.getElementById('filter').submit();
            });
        });
    </script>
@endsection
<script>
    function details(id) {
        $(".modal-footer").hide();
        $(".modal-title").text("Details");
        $.get("/details/" + id, function (res) {
            $(".modal-body").html(res);
        })
    }

    function track(id) {
        $(".modal-footer").hide();
        $(".modal-title").text("Tracking");
        $.get("/track/" + id, function (res) {
            $(".modal-body").html(res);
        })
    }

    function billprofit(id) {
        $(".modal-footer").show();
        $(".modal-title").text("Bill");
        $.get("/billprofit/" + id, function (res) {
            $(".modal-body").html(res);
        })
    }

    function eway(id) {
        $(".modal-footer").show();
        $(".modal-title").text("E-way");
        $.get("/eway/" + id, function (res) {
            $(".modal-body").html(res);
        })
    }

</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" id="printableArea">

            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-primary" onclick="printDiv('printableArea')">Print</button>
                <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
            </div>

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