@extends('layouts.master')

@section('title', 'Sales Report')

@section('content')

    <div class="content-header">
        <div class="container-fluid">
            <div class="row mb-2">
                <div class="col-sm-6">
                    <h1 class="m-0">Sales Report</h1>
                </div>
                <div class="col-sm-6">
                    <ol class="breadcrumb float-sm-right">
                        <li class="breadcrumb-item"><a href="#">Home</a></li>
                        <li class="breadcrumb-item active">Sales Report</li>
                    </ol>
                </div>
            </div>
        </div>
    </div>


    <div class="content">
        <div class="container-fluid">
            <div class="row">
                <div class="col-lg-12">

                    <div class="row mt-2">
                        <div class="col-lg-3">
                            <label>From Date</label>
                            <input type="date" class="form-control" id="sales_date" name="sales_date" value="{{$from_date}}"
                                onchange="getSales()" >
                        </div>
                        <div class="col-lg-3">
                            <label>To Date</label>
                            <input type="date" class="form-control" id="sales_to_date" name="sales_to_date"  value="{{$to_date}}"
                                onchange="getSales()" >
                        </div>
                        <div class="col-lg-3" style="padding-top: 31px;">
                            <div class="btn-group">
                                <button type="button" class="btn btn-info">Export To </button>
                                <button type="button" class="btn btn-info dropdown-toggle dropdown-icon" data-toggle="dropdown">
                                    <span class="sr-only">Toggle Dropdown</span>
                                </button>
                                <div class="dropdown-menu" role="menu">
                                    <a class="dropdown-item" href="#" onclick="exportExcel()">Excel</a>
                                </div>
                            </div>
                        </div>
                    </div>
                    <br>

                </div>
            </div>
            <div class="row">
                <div class="col-lg-12">
                    <div class="card card-primary card-outline card-outline-tabs" style="padding: 15px">
                        <table class="table ">
                            <tr>
                                <th>#</th>
                                <th>Invoice Date</th>
                                <th>Sales Invoice No</th>
                                <th style="text-align: right">Total Item Value</th>
                                <th style="text-align: right">Total Service Value</th>
                                <th style="text-align: right">Sub Total</th>
                                <th style="text-align: right">Discount</th>
                                <th style="text-align: right">Gross Total</th>
                                <th style="text-align: right">Total Tax</th>
                                <th style="text-align: right">Net Total</th>
                                <!-- <th style="text-align: right">Sales Return</th> -->
                                <th style="text-align: right">Due Amount</th>
                            </tr>
                            @php
                                $count = 1;
                                $due_amount = 0;

                                $sum_total_item_value = 0;
                                $sum_total_service_value = 0;
                                $sum_sub_total = 0;
                                $sum_discount = 0;
                                $sum_total = 0;
                                $sum_total_tax = 0;
                                $sum_net_total = 0;
                                $sum_return_total = 0;
                                $sum_due_amount = 0;

                            @endphp
                            @foreach ($salesInvoice as $value)
                            <tr>
                                @php
                                    $due_amount = $value->net_total - ($value->sales_return_total + $value->sales_return_tax);
                                @endphp

                                <td>{{ $count++ }}</td>
                                <td>{{ $value->invoice_date }}</td>
                                <td>{{ $value->sales_invoice_no }}</td>
                                <td style="text-align: right">{{ number_format($value->total_item_value, 2, '.', ',') }}</td>
                                <td style="text-align: right">{{ number_format($value->total_service_value, 2, '.', ',') }}</td>
                                <td style="text-align: right">{{ number_format($value->sub_total, 2, '.', ',') }}</td>
                                <td style="text-align: right">{{ number_format($value->discount, 2, '.', ',') }}</td>
                                <td style="text-align: right">{{ number_format(($value->total - $value->sales_return_total), 2, '.', ',') }}</td>
                                <td style="text-align: right">{{ number_format(($value->total_tax - $value->sales_return_tax), 2, '.', ',') }}</td>
                                <td style="text-align: right">{{ number_format(($value->net_total - ($value->sales_return_total + $value->sales_return_tax)), 2, '.', ',') }}</td>
                                <td style="text-align: right">{{ number_format($value->due_amount, 2, '.', ',') }}</td>

                            </tr>
                            @php

                            $sum_total_item_value += $value->total_item_value;
                            $sum_total_service_value += $value->total_service_value;
                            $sum_sub_total += $value->sub_total;
                            $sum_discount += $value->discount;
                            $sum_total += ($value->total - $value->sales_return_total);
                            $sum_total_tax += ($value->total_tax - $value->sales_return_tax);
                            $sum_net_total += $value->net_total - ($value->sales_return_total + $value->sales_return_tax);
                            $sum_due_amount += $value->due_amount;

                        @endphp
                            @endforeach

                            <tr>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td style="text-align: right"><b>{{ number_format($sum_total_item_value, 2, '.', ',') }}</b></td>
                                <td style="text-align: right"><b>{{ number_format($sum_total_service_value, 2, '.', ',') }}</b></td>
                                <td style="text-align: right"><b>{{ number_format($sum_sub_total, 2, '.', ',') }}</b></td>
                                <td style="text-align: right"><b>{{ number_format($sum_discount, 2, '.', ',') }}</b></td>
                                <td style="text-align: right"><b>{{ number_format($sum_total, 2, '.', ',') }}</b></td>
                                <td style="text-align: right"><b>{{ number_format($sum_total_tax, 2, '.', ',') }}</b></td>
                                <td style="text-align: right"><b>{{ number_format($sum_net_total, 2, '.', ',') }}</b></td>
                                <td style="text-align: right"><b>{{ number_format($sum_due_amount, 2, '.', ',') }}</b></td>

                            </tr>

                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <script>
        function getSales() {
            var csrf_token = $('meta[name="csrf-token"]').attr('content');
            var date = $("#sales_date").val();
            var to_date = $("#sales_to_date").val();
            $.ajax({
                type: 'post',
                url: '{{ url('/sales-report-by-date') }}',
                data: {
                    _token: csrf_token,
                    date: date,
                    to_date: to_date
                },
                async: true,
                success: function(data) {
                    document.open();
                    document.write(data);
                    document.close();
                    $("#sales_date").val(date);
                    $("#sales_to_date").val(to_date);
                },
                error: function(data) {
                    swlToster('error', "Something went wrong");
                }
            });
        }

        function exportExcel()
        {
            var query = {
                sales_from_date: $('#sales_date').val(),
                sales_to_date: $('#sales_to_date').val()
            }
            var url = "{{URL::to('/export-excel-sales-report')}}?" + $.param(query)
            window.location = url;
        }
    </script>
@endsection