{{-- Workshop Overview --}}
<div class="row">
    <div class="col-md-12 col-sm-12">
        <div class="max_height300">
            <table class="table table-bordered ">
                <thead>
                <tr>
                    <th>Insp. No.</th>
                    <th>JC No.</th>
                    <th>Esti. No.</th>
                    <th>Supervisor</th>
                    <th>Technicians</th>
                    <th>Vehicle Plate</th>
                    <th>VIN No.</th>
                    <th>Due Date Out</th>
                    <th>Job Type</th>
                    <th>Time Spent (HR)</th>
                    <th>Job Cost</th>
                    <th>Job Status</th>
                </tr>
                </thead>
                <tbody>
                @foreach($workshopOverview as $row1)
                    <tr>
                        <td>{{$row1->inspection_no ? : ''}}</td>
                        <td><a href="{{route('job-card.edit', $row1->id)}}">{{$row1->job_card_number}}</a></td>
                        <td>{{$row1->estimation_number ? : ''}}</td>
                        <td>{{$row1->supervisor_name}}</td>
                        <td>{{$row1->technician_name}}</td>
                        <td>{{$row1->plate_number}}</td>
                        <td>{{$row1->vin_number}}</td>
                        <td>{{$row1->due_date ? date('d-m-Y',strtotime($row1->due_date)) : ''}}</td>
                        <td>{{$row1->job_category}}</td>
                        <td></td>
                        <td>{{$row1->net_amount}}</td>
                        <td>{{$row1->jobCardStatus}}</td>
                    </tr>
                @endforeach
                </tbody>
            </table>
        </div>
    </div>
</div>


{{-- Appointments | Sale Overview | Estimation --}}
<div class="row">
    <div class="col-md-4 col-sm-12">
        <h5 class="m-b-10 text-center" style="font-weight: bold">Appointments</h5>
        <table class="table table-bordered " style="min-height: 173px;">
            <tbody>
            <tr>
                <td class="text-center" style="vertical-align: middle;">
                    <h4>Appointments Pending : {{$appointmentsPending}}</h4>
                </td>
            </tr>
            <tr>
                <td class="text-center" style="vertical-align: middle;">
                    <h4>Converted to Job : {{$appointmentsConverted}}</h4>
                </td>
            </tr>
            </tbody>
        </table>
    </div>
    <div class="col-md-4 col-sm-12">
        <h5 class="m-b-10 text-center" style="font-weight: bold">Sale Overview</h5>
        <table class="table table-bordered" style="min-height: 170px;">
            <thead>
            <tr>
                <th>Segment</th>
                <th>Pending Amount</th>
                <th>Received Amount</th>
                <th>Tax</th>
                <th>Total Amount</th>
            </tr>
            </thead>
            <tbody>
            <tr>
                <td>{{$saleOverview['Retail Sale']['segment']}}</td>
                <td>{{$saleOverview['Retail Sale']['pending_amount']}}</td>
                <td>{{$saleOverview['Retail Sale']['received_amount']}}</td>
                <td>{{$saleOverview['Retail Sale']['tax']}}</td>
                <td>{{$saleOverview['Retail Sale']['total_amount']}}</td>

            </tr>
            <tr>
                <td>{{$saleOverview['Work Shop']['segment']}}</td>
                <td>{{$saleOverview['Work Shop']['pending_amount']}}</td>
                <td>{{$saleOverview['Work Shop']['received_amount']}}</td>
                <td>{{$saleOverview['Work Shop']['tax']}}</td>
                <td>{{$saleOverview['Work Shop']['total_amount']}}</td>

            </tr>

            </tbody>
        </table>
    </div>
    <div class="col-md-4 col-sm-12">
        <h5 class="m-b-10 text-center" style="font-weight: bold">Estimation</h5>
        <div class="max_height300 new-box-shadow smooth-scroller">
            <table class="table table-bordered" style="min-height: 170px;">
                <thead>
                <tr>
                    <th>Est. No.</th>
                    <th>Insp.</th>
                    <th>Insp. Status</th>
                    <th>Est. Status</th>
                    {{--<th>Count</th>--}}
                    <th>Amount</th>
                </tr>
                </thead>
                <tbody>
                @foreach($estimation as $row3)
                    <tr>
                        <td><a href="{{route('estimation.edit',$row3->id)}}">{{$row3->estimation_number}}</a></td>
                        <td>{{$row3->inspection_number ? : ''}}</td>
                        <td>{{$row3->inspection_number ? "Yes" : ''}}</td>
                        <td>{{$row3->estimation_status}}</td>
                        {{--<td></td>--}}
                        <td>{{$row3->total}}</td>
                    </tr>
                @endforeach
                </tbody>
            </table>
        </div>
    </div>
</div>


{{-- Payable Vs. Receivables Overview | Purchase Overview --}}
<div class="row m-t-30">
    <div class="col-md-6 col-sm-12">
        <div class="card-box new-box-shadow" style="min-height: 400px;">
            <h5 class="m-b-10 text-center" style="font-weight: bold">Payable Vs. Receivables Overview</h5>
            <div id="chart" style="height: 280px;"></div>
        </div>
    </div>
    <div class="col-md-6 col-sm-12">
        <div class="row">
            <div class="col-md-12 col-sm-12">
                <h5 class="m-b-5 m-t-0 text-center" style="font-weight: bold">Purchase Overview</h5>
                <div class="max_height300 new-box-shadow smooth-scroller">
                    <table class="table table-bordered m-b-0" style="min-height: 170px;">
                        <thead>
                        <tr>
                            <th>Purchase Order</th>
                            <th>Purchase Invoice</th>
                            <th>Vendor</th>
                            <th style="width: 10%">Amount</th>
                            <th style="width: 10%">Tax</th>
                            <th style="width: 10%">Total</th>
                        </tr>
                        </thead>
                        <tbody>
                        @foreach($purchaseOverView as $row4)
                            <tr>
                                <td><a href="{{route('purchase-order.edit',$row4->id)}}">{{$row4->order_no}}</a></td>
                                <td>
                                    <a href="{{route('purchase-invoice.edit',$row4->id)}}">{{$row4->order_invoice_no}}</a>
                                </td>
                                <td>{{$row4->supplier_name}}</td>
                                <td>{{$row4->bill_amount - $row4->vat_amount}}</td>
                                <td>{{$row4->vat_amount}}</td>
                                <td>{{$row4->bill_amount}}</td>
                            </tr>
                        @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
            <div class="col-md-12 col-sm-12">
                <h5 class="m-b-5  text-center" style="font-weight: bold">Inventory Overview</h5>
                <div class="max_height300 new-box-shadow smooth-scroller">
                    <table class="table table-bordered m-b-0" style="min-height: 170px;">
                        <thead>
                        <tr>
                            <th>Item Code</th>
                            <th>Item Name</th>
                            <th style="width: 10%">Current Qty</th>
                            <th style="width: 10%">Committed Qty</th>
                            <th style="width: 10%">Incoming Qty</th>
                        </tr>
                        </thead>
                        <tbody>
                        @foreach($inventoryOverView as $row5)
                            <tr>
                                <td>{{$row5->part_number}}</td>
                                <td>{{$row5->part_description}}</td>
                                <td>{{$row5->stock_in}}</td>
                                <td>{{$row5->committed_stock}}</td>
                                <td>{{$row5->incoming_stock}}</td>
                            </tr>
                        @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>


{{-- Pending Receivables | Pending Payables | Inventory Request --}}
<div class="row">
    <div class="col-md-6 col-sm-12">
        <h5 class="m-b-10 text-center" style="font-weight: bold">Pending Receivables</h5>
        <div class="max_height300 new-box-shadow smooth-scroller">
            <table class="table table-bordered" style="min-height: 170px;">
                <thead>
                <tr>
                    <th>Customer</th>
                    <th>Total</th>
                    <th>Pending Invoices</th>
                </tr>
                </thead>
                <tbody>
                @foreach($pendingReceivble as $row6)
                    <tr>
                        <td>{{$row6['customer_name']}}</td>
                        <td>{{$row6['total']}}</td>
                        <td>{{$row6['pending_invoice']}}</td>
                    </tr>
                @endforeach
                </tbody>
            </table>
        </div>
    </div>
    <div class="col-md-6 col-sm-12">
        <h5 class="m-b-10 text-center" style="font-weight: bold">Pending Payables</h5>
        <div class="max_height300 new-box-shadow smooth-scroller">
            <table class="table table-bordered" style="min-height: 170px;">
                <thead>
                <tr>
                    <th>Vendors</th>
                    <th>Total</th>
                    <th>Pending Invoice</th>
                </tr>
                </thead>
                <tbody>
                @foreach($pendingPayables as $row7)
                    <tr>
                        <td>{{$row7['supplier_name']}}</td>
                        <td>{{$row7['total']}}</td>
                        <td>{{$row7['pending_invoice']}}</td>
                    </tr>
                @endforeach
                </tbody>
            </table>
        </div>
    </div>
    {{--    <div class="col-md-4 col-sm-12">--}}
    {{--        <h5 class="m-b-10 text-center" style="font-weight: bold">Inventory Request</h5>--}}
    {{--        <div class="max_height300">--}}
    {{--            <table class="table table-bordered">--}}
    {{--                <thead>--}}
    {{--                <tr>--}}
    {{--                    <th>Item Code</th>--}}
    {{--                    <th>Item Name</th>--}}
    {{--                    <th>Requester</th>--}}
    {{--                    <th>Approver</th>--}}
    {{--                    <th>PO</th>--}}
    {{--                </tr>--}}
    {{--                </thead>--}}
    {{--                <tbody>--}}
    {{--                @foreach($inventoryRequest as $row8)--}}
    {{--                    <tr>--}}
    {{--                        <td>{{$row8->item_code}}</td>--}}
    {{--                        <td>{{$row8->item_name}}</td>--}}
    {{--                        <td>{{$row8->requester}}</td>--}}
    {{--                        <td>{{$row8->approver}}</td>--}}
    {{--                        <td>{{$row8->po_no}}</td>--}}
    {{--                    </tr>--}}
    {{--                @endforeach--}}
    {{--                </tbody>--}}
    {{--            </table>--}}
    {{--        </div>--}}
    {{--    </div>--}}
</div>

<script>

    $(".datepicker").datepicker({
        format: 'dd-mm-yyyy',
        autoclose: true,
        endDate: "today"
    });


    const data = [];
    for (let m = 1; m < 6; m++) {
        let monthLabel = '';
        let payable = 0;
        let receivables = 0;
        switch (m) {
            case 1:
                monthLabel = '90+';
                payable = {{\App\Helper\CommonClass::payables(1)}};
                receivables = {{\App\Helper\CommonClass::receivables(1)}};
                break;
            case 2:
                monthLabel = '60-90';
                payable = {{\App\Helper\CommonClass::payables(2)}};
                receivables = {{\App\Helper\CommonClass::receivables(2)}};
                break;
            case 3:
                monthLabel = '30-60';
                payable = {{\App\Helper\CommonClass::payables(3)}};
                receivables = {{\App\Helper\CommonClass::receivables(3)}};
                break;
            case 4:
                monthLabel = '1-30';
                payable = {{\App\Helper\CommonClass::payables(4)}};
                receivables = {{\App\Helper\CommonClass::receivables(4)}};
                break;
            default:
                monthLabel = 'Current';
                payable = {{\App\Helper\CommonClass::payables(5)}};
                receivables = {{\App\Helper\CommonClass::receivables(5)}};
        }
        data.push({month: monthLabel, value: payable, val2: receivables});
    }
    new Morris.Bar({
        // ID of the element in which to draw the chart.
        element: 'chart',
        // Chart data records -- each entry in this array corresponds to a point on the chart.
        data: data,
        // The name of the data record attribute that contains x-values.
        xkey: 'month',
        // A list of names of data record attributes that contain y-values.
        ykeys: ['value', 'val2'],
        // Labels for the ykeys -- will be displayed when you hover over the chart.
        labels: ['Payables', 'Receivables'],
        // Bar colors
        barColors: ["rgba(75, 211, 150, 0.5)", "rgba(245, 112, 122, 0.5)"],
    });
</script>