@extends('admin.layout.app')
@section('title','Group Report')
@push('headerscript')
    <link href="{{asset('theme/plugins/select2/css/select2.min.css')}}" rel="stylesheet" type="text/css"/>
    <link href="{{asset('theme/plugins/bootstrap-datepicker/css/bootstrap-datepicker.min.css')}}" rel="stylesheet">
    <link href="{{asset('theme/plugins/datatables/responsive.bootstrap.min.css')}}" rel="stylesheet" type="text/css"/>
    <link href="{{asset('theme/plugins/datatables/dataTables.bootstrap.min.css')}}" rel="stylesheet" type="text/css"/>
    <link href="{{asset('theme/css/custom.css')}}" rel="stylesheet" type="text/css"/>
    <style>
        .table-size {
            padding: 18px !important;
        }

        .table > tbody > tr > td {
            padding: 3px 10px !important;
        }
        .table > thead > tr > th {
            font-weight: bold !important;
            color: black !important;
        }
    </style>
@endpush
@section('content')
    <div class="content">
        <div class="container">
            <div class="row">
                <div class="col-xs-12">
                    <div class="page-title-box">
                        <h4 class="page-title">Group Report</h4>
                        <div class="pull-right">
                            <a href="{{url()->previous()}}"
                               class="btn btn-custom btn-rounded waves-effect waves-light m-b-2 m-r-15"><i
                                    class=" mdi mdi-keyboard-backspace"></i> Back</a>
                            <button type="button" onclick="exportsExcel()"
                                    class="btn btn-success btn-sm pull-right"
                                    title="Export in Excel">
                                <i class="fa fa-file-excel-o"></i>
                            </button>
                            <button type="button" onclick="exportsPdf()"
                                    class="btn btn-danger btn-sm pull-right m-r-10"
                                    title="Export in Pdf">
                                <i class="fa fa-file-pdf-o"></i>
                            </button>
                        </div>
                        <div class="clearfix"></div>
                    </div>
                </div>
            </div>
            <div class="row">
                <div class="col-xs-12">
                    <div class="card-box">
                        <div class="row">
                            <div class="col-xs-12">
                                <div class="row">
                                    <div class="form-group col-sm-3 col-12">
                                        <label for="from_date">From Date</label>
                                        <input type="text" name="from_date" id="from_date"
                                               value="{{date('d-m-Y', strtotime('first day of january this year'))}}"
                                               class="form-control datepicker" autocomplete="off">
                                    </div>
                                    <div class="form-group col-sm-3 col-12">
                                        <label for="to_date">To Date</label>
                                        <input type="text" name="to_date" id="to_date"
                                               value="{{date('d-m-Y')}}"
                                               class="form-control datepicker" autocomplete="off">
                                    </div>
                                    <div class="form-group col-sm-3 col-12">
                                        <label for="group_id">Group Name</label>
                                        {!! Form::select("group_id", [''=>'Select']+$groups, old("group_id"), ['class'=>'form-control' ,'id' => 'group_id']  ) !!}
                                    </div>
                                    <div class="form-group col-sm-3 col-12">
                                        <label for="a_group_id">Account Group Name</label>
                                        {!! Form::select("a_group_id", [''=>'Select']+$account_groups, old("a_group_id"), ['class'=>'form-control' ,'id' => 'a_group_id']  ) !!}
                                    </div>
                                    <div class="form-group col-sm-3 col-12">
                                        <label for="account_ledger_id">Account Name</label>
                                        {!! Form::select("account_ledger_id", [''=>'Select']+$account_ledgers, old("account_ledger_id"), ['class'=>'form-control' ,'id' => 'account_ledger_id']  ) !!}
                                    </div>
                                    <div class="form-group col-sm-3 col-12">
                                        <label for="branch_id">Branch</label>
                                        {!! Form::select("branch_id", \App\Http\Helpers\Helper::getBranchData(), old("branch_id"), ['class'=>'form-control' ,'id' => 'branch_id']  ) !!}
                                    </div>
                                </div>
                                <div class="row">
                                    <div class="col-xs-12 col-12 m-t-15">
                                        <div id="balance_sheet">
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            {!! Form::close() !!}
        </div>
    </div>
@endsection
@push('footerscript')
    <script src="{{asset('theme/plugins/moment/moment.js')}}"></script>
    <script src="{{asset('theme/plugins/select2/js/select2.full.js')}}"></script>
    <script src="{{asset('theme/plugins/bootstrap-datepicker/js/bootstrap-datepicker.min.js')}}"></script>
    <script src="{{asset('theme/plugins/datatables/jquery.dataTables.min.js')}}"></script>
    <script src="{{asset('theme/plugins/datatables/dataTables.bootstrap.js')}}"></script>
    {{--    <script src="{{asset('theme/plugins/datatables/responsive.bootstrap.min.js')}}"></script>--}}
    <script>
        $(window).load(function () {
            $('#to_date').change();
        });
        $('.select2').select2();
        $(".datepicker").datepicker({
            format: 'dd-mm-yyyy',
            autoclose: true,
            endDate: "today"
        });

        $('#from_date, #to_date, #branch_id,#group_id, #a_group_id, #account_ledger_id').on('change', function () {
            var from_date = $('#from_date').val();
            var to_date = $('#to_date').val();
            var branch_id = $('#branch_id').val();
            var group_id = $('#group_id').val();
            var a_group_id = $('#a_group_id').val();
            var account_ledger_id = $('#account_ledger_id').val();
            $.ajax({
                url: '{{route('groupReport.getData') }}',
                type: 'GET',
                data: {
                    from_date: from_date,
                    to_date: to_date,
                    branch_id: branch_id,
                    group_id: group_id,
                    a_group_id: a_group_id,
                    account_ledger_id: account_ledger_id,
                },
                success: function (response) {
                    $('#balance_sheet').html(response);
                }
            });
        });

        function exportsExcel() {
            var from_date = $('#from_date').val();
            var to_date = $('#to_date').val();
            var branch_id = $('#branch_id').val();
            var group_id = $('#group_id').val();
            var a_group_id = $('#a_group_id').val();
            var account_ledger_id = $('#account_ledger_id').val();
            window.location.href = "{{route('groupReport.exportExcel')}}?from_date=" + from_date + "&to_date=" + to_date + "&branch_id=" + branch_id + "&group_id=" + group_id + "&a_group_id=" + a_group_id + "&account_ledger_id=" + account_ledger_id;
        }
        function exportsPdf() {
            var from_date = $('#from_date').val();
            var to_date = $('#to_date').val();
            var branch_id = $('#branch_id').val();
            var group_id = $('#group_id').val();
            var a_group_id = $('#a_group_id').val();
            var account_ledger_id = $('#account_ledger_id').val();
            window.location.href = "{{route('groupReport.exportPdf')}}?from_date=" + from_date + "&to_date=" + to_date + "&branch_id=" + branch_id + "&group_id=" + group_id + "&a_group_id=" + a_group_id + "&account_ledger_id=" + account_ledger_id;
        }
    </script>
@endpush