@extends('layouts.master')
@section('css')
    <style>
        .buttons-html5,
        .buttons-print {
            background: #405189 !important;
            color: white !important;
            margin: 5px !important;
            height: 31px !important;
            width: 70px !important;
            border-radius: 5px !important;
        }
         .select2-container .select2-search--inline .select2-search__field {
            margin-top: 9px !important;
        }

        .select2-container--default .select2-selection--multiple .select2-selection__choice__display {
            text-wrap: auto ! important;
        }

        .select2-selection.select2-selection--multiple {
            display: flex !important;
        }

        .card-body .col-md-3 {
            padding: 0 5px !important;
        }

        .card-body .col-md-2 {
            padding: 0 5px !important;
        }

        .card-body .col-lg-4 {
            padding: 0 5px !important;
        }

        .buttons-colvis {
            background: #405189 !important;
            color: #fff !important;
        }

        .dt-button-collection button.active {
            background: #405189 !important;
            color: #fff !important;

        }
    </style>
    <link rel="stylesheet" href="https://cdn.datatables.net/1.13.6/css/jquery.dataTables.min.css">
    <link rel="stylesheet" href="https://cdn.datatables.net/buttons/2.4.1/css/buttons.dataTables.min.css">
@endsection
@section('title')
   Gst Report
@endsection
@section('content')
    <div class="row">
        <div class="col-lg-12">
            <div class="card">
                <div class="card-header phcl-flx">
                    <h5 class="card-title text-center mb-0 text-nowrap">Gst Report</h5>
                    <div class="">
                        <div class="phcl-flx-btns">
                        </div>
                    </div>
                </div>
                <div class="card-body">
                    <div class="row mb-3">
                        <div class="col-md-3 col-sm-6 mb-2">
                            <label class="label">From Date</label>
                            <input class="form-control" value="{{ $from_date }}" type="date"
                                name="from_date" id="from_date">
                        </div>
                        <div class="col-md-3 col-sm-6 mb-2">
                            <label class="label">To Date</label>
                            <input class="form-control" value="{{ $to_date }}" type="date"
                                name="to_date" id="to_date">
                        </div>
                        <div class="col-md-2 mt-1  daybk-rt-btns mb-2" style=" align-content: end;">
                            <button type="button" name="filter" id="filter" class="btn btn-sm btn-primary"><i
                                    class="ri-search-line fs-6"></i></button>
                            <button type="button" name="refresh" id="refresh" class="btn btn-sm btn-danger"><i
                                    class="ri-refresh-line fs-6"></i></button>
                        </div>
                    </div>
                    <table class=" table table-bordered table-striped" style="width:100%" id="fixed-header">
                        <thead>
                            <tr>
                                <th>Particular</th>
                                <th>Vouchers Count</th>
                                <th>Taxable Amount</th>
                                <th>IGST</th>
                                <th>CGST</th>
                                <th>SGST/UTGST</th>
                                <th>Cess</th>
                                <th>Tax Amount</th>
                                <th>Invoice Amount</th>
                            </tr>
                        </thead>
                            <tr>
                                <td>B2B Invoices</td>
                                <td>{{ $b2bSales['count'] }}</td>
                                <td>{{ $b2bSales['taxable_value'] }}</td>
                                <td>{{ $b2bSales['igst'] }}</td>
                                <td>{{ $b2bSales['cgst'] }}</td>
                                <td>{{ $b2bSales['sgst'] }}</td>
                                <td>{{ $b2bSales['cess'] }}</td>
                                <td>{{ $b2bSales['igst'] + $b2bSales['cgst'] + $b2bSales['sgst'] + $b2bSales['cess'] }}</td>
                                <td>{{ $b2bSales['amount'] }}</td>
                            </tr>
                        <tr>
                            <td>B2C Large Invoices</td>
                            <td>{{ $b2cSaleslarge['count'] }}</td>
                            <td>{{ $b2cSaleslarge['taxable_value'] }}</td>
                            <td>{{ $b2cSaleslarge['igst'] }}</td>
                            <td>{{ $b2cSaleslarge['cgst'] }}</td>
                            <td>{{ $b2cSaleslarge['sgst'] }}</td>
                            <td>{{ $b2cSaleslarge['cess'] }}</td>
                            <td>{{ $b2cSaleslarge['igst'] + $b2cSaleslarge['cgst'] + $b2cSaleslarge['sgst'] + $b2cSaleslarge['cess'] }}</td>
                            <td>{{ $b2cSaleslarge['amount'] }}</td>
                        </tr>
                        <tr>
                            <td>B2C Small Invoices</td>
                            <td>{{ $b2cSalesSmall['count'] }}</td>
                            <td>{{ $b2cSalesSmall['taxable_value'] }}</td>
                            <td>{{ $b2cSalesSmall['igst'] }}</td>
                            <td>{{ $b2cSalesSmall['cgst'] }}</td>
                            <td>{{ $b2cSalesSmall['sgst'] }}</td>
                            <td>{{ $b2cSalesSmall['cess'] }}</td>
                            <td>{{ $b2cSalesSmall['igst'] + $b2cSalesSmall['cgst'] + $b2cSalesSmall['sgst'] + $b2cSalesSmall['cess'] }}</td>
                            <td>{{ $b2cSalesSmall['amount'] }}</td>
                        </tr>
                        <tr>
                            <td>Credit Or Debit Notes (Registered)</td>
                            <td>{{$b2bSalesReturn['count'] + $b2bPurchaseReturn['count'] }}</td>
                            <td>{{ $b2bSalesReturn['taxable_value'] - $b2bPurchaseReturn['taxable_value'] }}</td>
                            <td>{{ $b2bSalesReturn['igst'] - $b2bPurchaseReturn['igst'] }}</td>
                            <td>{{ $b2bSalesReturn['cgst'] - $b2bPurchaseReturn['cgst'] }}</td>
                            <td>{{ $b2bSalesReturn['sgst'] - $b2bPurchaseReturn['sgst'] }}</td>
                            <td>{{ $b2bSalesReturn['cess'] - $b2bPurchaseReturn['cess'] }}</td>
                            <td>{{ ($b2bSalesReturn['igst'] + $b2bSalesReturn['cgst'] + $b2bSalesReturn['sgst'] + $b2bSalesReturn['cess']) - ($b2bPurchaseReturn['igst'] + $b2bPurchaseReturn['cgst'] + $b2bPurchaseReturn['sgst'] + $b2bPurchaseReturn['cess']) }}</td>
                            <td>{{ $b2bSalesReturn['amount'] - $b2bPurchaseReturn['amount'] }}</td>
                        </tr>
                        <tr>
                            <td>Credit Or Debit Notes (Unregistered)</td>
                            <td>{{$b2cSalesReturn['count'] + $b2cPurchaseReturn['count'] }}</td>
                            <td>{{ $b2cSalesReturn['taxable_value'] -$b2cPurchaseReturn['taxable_value'] }}</td>
                            <td>{{ $b2cSalesReturn['igst'] -$b2cPurchaseReturn['igst'] }}</td>
                            <td>{{ $b2cSalesReturn['cgst'] -$b2cPurchaseReturn['cgst'] }}</td>
                            <td>{{ $b2cSalesReturn['sgst'] -$b2cPurchaseReturn['sgst'] }}</td>
                            <td>{{ $b2cSalesReturn['cess'] -$b2cPurchaseReturn['cess'] }}</td>
                            <td>{{ ($b2cSalesReturn['igst'] + $b2cSalesReturn['cgst'] + $b2cSalesReturn['sgst'] + $b2cSalesReturn['cess']) - ($b2bPurchaseReturn['igst'] +$b2cPurchaseReturn['cgst'] +$b2cPurchaseReturn['sgst'] +$b2cPurchaseReturn['cess']) }}</td>
                            <td>{{ $b2cSalesReturn['amount'] -$b2cPurchaseReturn['amount'] }}</td>
                        </tr>
                    </thead>
                    </table>
                </div>
            </div>
        </div>
    </div>
@endsection
@section('script')
    <script src="https://code.jquery.com/jquery-3.7.0.min.js"></script>
    <script src="https://cdn.datatables.net/1.13.6/js/jquery.dataTables.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/2.4.1/js/dataTables.buttons.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.10.1/jszip.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/2.4.1/js/buttons.html5.min.js"></script>
    <script src="{{ URL::asset('/assets/js/app.min.js') }}"></script>
    <script>
        $(document).ready(function() {
            $('#filter').click(function(e) {
                e.preventDefault();
                var from_date = $('#from_date').val();
                var to_date = $('#to_date').val();
                //check dates not null
                if (from_date != '' && to_date != '') {
                        window.location = window.location.href.split('?')[0] + '?from_date=' + from_date +
                            '&to_date=' + to_date;
                } else {
                    alert('Both Date is required');
                }
            });
            $('#refresh').click(function(e) {
                e.preventDefault();
                window.location = window.location.href.split('?')[0];
            });
            $('#fixed-header').DataTable({
                dom: 'Bfrtip',
                orderable: false,
                "scrollX": true,
                    autoWidth: true,
                paging: false,
                searching: false,
                buttons: [
                    'excelHtml5'
                ]
            });
        });
    </script>
@endsection