@extends('layouts.backend')
@section('extraCss')
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/fixedheader/3.1.2/css/fixedHeader.dataTables.min.css">
@endsection
@section('mainContentArea')
<div class="card card-default">
    <div class="card-header">
        <h4>
            GST Summary Report
        </h4>
    </div>
    <div class="card-body">
        <form action="">
            <table class="table table-striped">
                <tr>
                    <th>From Date</th>
                    <td><input type="text" readonly class="form-control datepicker" required name="startdate" value="{{ $startdate }}"></td>
                    <th>End Date</th>
                    <td><input type="text" readonly class="form-control datepicker" required name="enddate" value="{{ $enddate }}"></td>
                    <th><button class="btn btn-success"><i class="fa fas fa-search"></i> Search</button></th>
                </tr>
            </table>
        </form>
        <hr/>
        @php
            $output = [];
            $input = [];
        @endphp
        @if(!empty($salesData))
            @if(is_array($salesData) && sizeof($salesData) > 0)
            <div class="text-right">
                <form method="post" action="{{ route('export-data-to-excel') }}" target="_blank">
                    @csrf
                    <input type="hidden" name="label" value="ExportGstSumm-{{ $startdate }}-to-{{ $enddate }}">
                    <input type="hidden" name="html" value="" id="exportedVal">
                    <button class="btn btn-sm btn-warning" type="button" onclick="$('#exportedVal').val($('.exportedData').html());this.form.submit();">Export</button>
                </form>
            </div>
            <div class="exportedData">
                <h3 align="center">GST Input</h3>
                <table class="table table-bordered data-table">
                    <thead>
                        <tr>
                            <th>GSTIN</th>
                            <th>PARTY</th>
                            <th>PARTICULAR</th>
                            <th>HSN</th>
                            <th>TAX</th>
                            <th>TAXABLE VAL</th>
                            <th>IGST TAX%</th>
                            <th>IGST TAX AMT</th>
                            <th>CGST TAX%</th>
                            <th>CGST TAX AMT</th>
                            <th>SGST TAX %</th>
                            <th>SGST TAX AMT</th>
                            <th>TOTAL AFTER TAX</th>
                            {{-- <th>ROUND OFF</th> --}}
                            <th>QTY</th>
                        </tr>
                    </thead>
                    <tbody>
                        @php
                            $taxableValue = 0;
                            $igst_tax_amt = 0;
                            $cgst_tax_amt = 0;
                            $sgst_tax_amt = 0;
                            $total_after_tax = 0;
                            $roundoff = 0;
                            $qty = 0;
                        @endphp
                        @foreach($inData as $date => $saleData)
                        @php
                            $taxableValue+=$saleData['taxableValue'];
                            $igst_tax_amt+=$saleData['igst_tax_amt'];
                            $cgst_tax_amt+=$saleData['cgst_tax_amt'];
                            $sgst_tax_amt+=$saleData['sgst_tax_amt'];
                            $total_after_tax+=$saleData['total_after_tax'];
                            $roundoff+=$saleData['roundoff'];
                            $qty+=$saleData['qty'];
                        @endphp
                        <tr>
                            <td>{{ $saleData['gstin'] }}</td>
                            <td>{{ $saleData['party'] }}</td>
                            <td>{{ $saleData['particular'] }}</td>
                            <td>{{ $saleData['hsn'] }}</td>
                            <td>{{ $saleData['tax'] }}</td>
                            <td>{{ number_format($saleData['taxableValue'], 2, '.', '') }}</td>                                                       
                            <td>{{ $saleData['igst_tax_per'] }}</td>
                            <td>{{ number_format($saleData['igst_tax_amt'], 2, '.', '') }}</td>
                            <td>{{ $saleData['cgst_tax_per'] }}</td>
                            <td>{{ number_format($saleData['cgst_tax_amt'], 2, '.', '')  }}</td>
                            <td>{{ $saleData['sgst_tax_per'] }}</td>
                            <td>{{ number_format($saleData['sgst_tax_amt'], 2, '.', '')  }}</td>
                            <td>{{ number_format($saleData['total_after_tax'], 2, '.', '') }}</td>                           
                            <td>{{ $saleData['qty'] }}</td>
                        </tr>
                        @endforeach
                    </tbody>
                    <tfoot>
                        <tr>
                            <td>{{ '' }}</td>
                            <td>{{ '' }}</td>
                            <td>{{ '' }}</td>
                            <td>{{ '' }}</td>
                            <td>{{ '' }}</td>
                            <td>{{ number_format($taxableValue, 2, '.', '') }}</td>
                            <td>{{ '' }}</td>
                            <td>{{ number_format($igst_tax_amt, 2, '.', '') }}</td>
                            <td>{{ '' }}</td>
                            <td>{{ number_format($cgst_tax_amt, 2, '.', '') }}</td>
                            <td>{{ '' }}</td>
                            <td>{{ number_format($sgst_tax_amt, 2, '.', '') }}</td>
                            <td>{{ number_format($total_after_tax, 2, '.', '') }}</td>
                            {{-- <td>{{ $roundoff }}</td> --}}
                            <td>{{ $qty }}</td>
                        </tr>
                    </tfoot>
                    @php
                        $output['total_after_tax'] = $total_after_tax;
                        $output['igst_tax_amt'] = $igst_tax_amt;
                        $output['cgst_tax_amt'] = $cgst_tax_amt;
                        $output['sgst_tax_amt'] = $sgst_tax_amt;
                        $output['taxableValue'] = $taxableValue;
                        $output['qty'] = $qty;
                    @endphp
                </table>
                <h3 align="center">GST OUTPUT</h3>
                <table class="table table-bordered data-table">
                    <thead>
                        <tr>
                            <th>GSTIN</th>
                            <th>PARTY</th>
                            <th>PARTICULAR</th>
                            <th>HSN</th>
                            <th>TAX</th>
                            <th>TAXABLE VAL</th>
                            <th>IGST TAX%</th>
                            <th>IGST TAX AMT</th>
                            <th>CGST TAX%</th>
                            <th>CGST TAX AMT</th>
                            <th>SGST TAX %</th>
                            <th>SGST TAX AMT</th>
                            <th>TOTAL AFTER TAX</th>
                            {{-- <th>ROUND OFF</th> --}}
                            <th>QTY</th>
                        </tr>
                    </thead>
                    <tbody>
                        @php
                            $taxableValue = 0;
                            $igst_tax_amt = 0;
                            $cgst_tax_amt = 0;
                            $sgst_tax_amt = 0;
                            $total_after_tax = 0;
                            $roundoff = 0;
                            $qty = 0;
                        @endphp
                        @foreach($salesData as $date => $saleData)
                        @php
                            $taxableValue+=$saleData['taxableValue'];
                            $igst_tax_amt+=$saleData['igst_tax_amt'];
                            $cgst_tax_amt+=$saleData['cgst_tax_amt'];
                            $sgst_tax_amt+=$saleData['sgst_tax_amt'];
                            $total_after_tax+=$saleData['total_after_tax'];
                            $roundoff+=$saleData['roundoff'];
                            $qty+=$saleData['qty'];
                        @endphp
                        <tr>
                            <td>{{ $saleData['gstin'] }}</td>
                            <td>{{ $saleData['party'] }}</td>
                            <td>{{ $saleData['particular'] }}</td>
                            <td>{{ $saleData['hsn'] }}</td>
                            <td>{{ $saleData['tax'] }}</td>
                            <td>{{ number_format($saleData['total_after_tax'], 2, '.', '') }}</td>
                            <td>{{ $saleData['igst_tax_per'] }}</td>
                            <td>{{ number_format($saleData['igst_tax_amt'], 2, '.', '') }}</td>
                            <td>{{ $saleData['cgst_tax_per'] }}</td>
                            <td>{{ number_format($saleData['cgst_tax_amt'], 2, '.', '') }}</td>
                            <td>{{ $saleData['sgst_tax_per'] }}</td>
                            <td>{{ number_format($saleData['sgst_tax_amt'], 2, '.', '') }}</td>
                            <td>{{ number_format($saleData['taxableValue'], 2, '.', '') }}</td>
                            {{-- <td>{{ $saleData['roundoff'] }}</td> --}}
                            <td>{{ $saleData['qty'] }}</td>
                        </tr>
                        @endforeach
                    </tbody>
                    <tfoot>
                        <tr>
                            <td>{{ '' }}</td>
                            <td>{{ '' }}</td>
                            <td>{{ '' }}</td>
                            <td>{{ '' }}</td>
                            <td>{{ '' }}</td>
                            <td>{{ number_format($total_after_tax, 2, '.', '') }}</td>
                            <td>{{ '' }}</td>
                            <td>{{ number_format($igst_tax_amt, 2, '.', '') }}</td>
                            <td>{{ '' }}</td>
                            <td>{{ number_format($cgst_tax_amt, 2, '.', '') }}</td>
                            <td>{{ '' }}</td>
                            <td>{{ number_format($sgst_tax_amt, 2, '.', '') }}</td>
                            <td>{{ number_format($taxableValue, 2, '.', '') }}</td>
                            {{-- <td>{{ $roundoff }}</td> --}}
                            <td>{{ $qty }}</td>
                        </tr>
                    </tfoot>
                </table>
                @php
                    $input['total_after_tax'] = $total_after_tax;
                    $input['igst_tax_amt'] = $igst_tax_amt;
                    $input['cgst_tax_amt'] = $cgst_tax_amt;
                    $input['sgst_tax_amt'] = $sgst_tax_amt;
                    $input['taxableValue'] = $taxableValue;
                    $input['qty'] = $qty;
                @endphp
                <table class="table table-striped table-bordered">
                    <thead>
                        <tr>
                            <th>GSTIN</th>
                            <th>PARTY</th>
                            <th>PARTICULAR</th>
                            <th>HSN</th>
                            <th>TAX</th>
                            <th>TAXABLE VAL</th>
                            <th>IGST TAX%</th>
                            <th>IGST TAX AMT</th>
                            <th>CGST TAX%</th>
                            <th>CGST TAX AMT</th>
                            <th>SGST TAX %</th>
                            <th>SGST TAX AMT</th>
                            <th>TOTAL AFTER TAX</th>
                            {{-- <th>ROUND OFF</th> --}}
                            <th>QTY</th>
                        </tr>
                    </thead>
                    <tbody>
                        <tr>
                            <td>{{ 'Totals:' }}</td>
                            <td>{{ '' }}</td>
                            <td>{{ '' }}</td>
                            <td>{{ '' }}</td>
                            <td>{{ '' }}</td>
                            <td>{{ number_format($input['total_after_tax'] - $output['taxableValue'], 2, '.', '') }}</td>
                            <td>{{ '' }}</td>
                            <td>{{ number_format($input['igst_tax_amt'] - $output['igst_tax_amt'], 2, '.', '') }}</td>
                            <td>{{ '' }}</td>
                            <td>{{ number_format($input['cgst_tax_amt'] - $output['cgst_tax_amt'], 2, '.', '') }}</td>
                            <td>{{ '' }}</td>
                            <td>{{ number_format($input['sgst_tax_amt'] - $output['sgst_tax_amt'], 2, '.', '') }}</td>
                            <td>{{ number_format($input['taxableValue'] - $output['total_after_tax'], 2, '.', '') }}</td>
                            {{-- <td>{{ $roundoff }}</td> --}}
                            <td>{{ $input['qty'] - $output['qty'] }}</td>
                        </tr>
                    </tbody>
                </table>
            </div>
            @else
            <div class="alert alert-warning">No record found</div>
            @endif     
        @else
        <div class="alert alert-warning">Please select the dates above to get the report</div>
        @endif
    </div>
</div>
@endsection
@section('extraJs')
<script src="https://cdn.datatables.net/fixedheader/3.1.8/js/dataTables.fixedHeader.min.js"></script>
<script type="text/javascript">
    $(function () { 
      var table = $('.reportTable').DataTable({
          orderCellsTop: true,
          fixedHeader: true
      });
    });
  </script>
@endsection