@extends('backEnd.admin.layouts.master')

@section('title')
    Reports
@endsection

@php
    $data = $data['data'] ?? null;
    $to_date = $to_date ?? null;
    $from_date = $from_date ?? null;
@endphp
@section('css')
    <link rel="stylesheet" type="text/css" href="{{ asset('/') }}backEnd/assets/vendor/flatpickr/flatpickr.min.css">
@endsection
@section('body')
    <div class="dashboard-wrapper">
        <div class="dashboard-ecommerce">
            <div class="container-fluid dashboard-content ">
                <!-- ============================================================== -->
                <!-- pageheader  -->
                <!-- ============================================================== -->
                <div class="row">
                    <div class="col-xl-12 col-lg-12 col-md-12 col-sm-12 col-12">
                        <div class="page-header">
                            <h2 class="pageheader-title">Reports</h2>
                            <div class="page-breadcrumb">
                                <nav aria-label="breadcrumb">
                                    <ol class="breadcrumb">
                                        <li class="breadcrumb-item"><a
                                                href="{{ Auth::guard('admin')->check() ? route('admin.home') : (Auth::guard('manager')->check() ? route('manager.home') : (Auth::guard('employee')->check() ? route('employee.home') : '')) }}"
                                                class="breadcrumb-link">Home</a></li>
                                        <li class="breadcrumb-item active" aria-current="page">Reports</li>
                                    </ol>
                                </nav>
                            </div>
                        </div>
                    </div>
                </div>
                <!-- ============================================================== -->
                <!-- end pageheader  -->
                <!-- ============================================================== -->


                <div class="row mb-3">
                    <div class="col-12">
                        <form
                            action="{{ Auth::guard('admin')->check() ? route('admin.reports.index') : (Auth::guard('manager')->check() ? route('manager.reports.index') : '') }}"
                            method="get" class="form-inline ">
                            <div class="form-group">

                                <input type="text" class="form-control mr-2 datetimepicker" placeholder="From Date"
                                    value="{{ $from_date ? $from_date : '' }}" name="from_date">
                                <input type="text" class="form-control mr-2 datetimepicker" placeholder="To Date"
                                    value="{{ $to_date ? $to_date : '' }}" name="to_date">
                            </div>
                            <div class="form-group">
                                <button class="btn btn-dark btn-sm mr-1">Search</button>
                                <a href="{{ Auth::guard('admin')->check() ? route('admin.reports.index') : (Auth::guard('manager')->check() ? route('manager.reports.index') : '') }}"
                                    class="btn btn-info btn-sm">Reset</a>
                            </div>
                        </form>
                    </div>
                </div>
                <div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body table-responsive">
                                <table class="table table-bordered table-striped text-center">
                                    <thead>
                                        <tr>
                                            <td>SL.</td>
                                            <td>Product Name</td>
                                            <td>Product Price</td>
                                            <td>Purchase Price</td>
                                            <td>Marketing Cost</td>
                                            <td>Others Cost</td>
                                            <td>Delivery Charge</td>
                                            <td>Quantity of Sale</td>
                                            <td>Total Amount of Sale</td>
                                            <td>Profit/Loss</td>
                                        </tr>
                                    </thead>
                                    @php
                                        $total_product_sum = 0;
                                        $total_purchase_price_sum = 0;
                                        $total_marketing_cost_sum = 0;
                                        $total_other_cost_sum = 0;
                                        $total_delivery_charge_sum = 0;
                                        $total_qty_sum = 0;
                                        $total_sale_sum = 0;
                                        $total_profit_loss_sum = 0;
                                    @endphp
                                    <tbody>
                                        @php($i = 1)
                                        @if ($data->count() > 0)
                                            @foreach ($data as $key => $orders)