@extends('layouts.admin')


@push('styles')
    <link rel="stylesheet" href="{{ asset('plugins/datatables-bs4/css/dataTables.bootstrap4.min.css') }}">
    <link rel="stylesheet" href="{{ asset('plugins/datatables-responsive/css/responsive.bootstrap4.min.css') }}">
    <link rel="stylesheet" href="{{ asset('plugins/datatables-buttons/css/buttons.bootstrap4.min.css') }}">


    <link rel="stylesheet" href="{{ asset('plugins/select2/css/select2.min.css') }}">
    <link rel="stylesheet" href="{{ asset('plugins/select2-bootstrap4-theme/select2-bootstrap4.min.css') }}">


    <link rel="stylesheet" href="{{ asset('plugins/icheck-bootstrap/icheck-bootstrap.min.css') }}">


    <style type="text/css">
        .btn_mt {
            margin-top: 31px;
        }
    </style>
@endpush


@section('content')
    <!-- Main content -->
    <section class="content">
        <div class="container-fluid pt-2">

            <div class="col-md-12">
                <!-- general form elements -->
                <div class="card card-info">

                    <!-- form start -->
                    <form method="GET" action="{{ route('account.income_statement') }}">
                        <div class="card-body">
                            <div class="row">

                                <div class="col-md-2 col-sm-4">
                                    <div class="form-group">
                                        <label for="formdate">From Date</label>
                                        <div class="input-group date" id="formdate" data-target-input="nearest">
                                            <input type="text" class="form-control form-control-sm datetimepicker-input"
                                                data-target="#formdate" name="formdate" id="formdate"
                                                value="{{ $formdate }}" placeholder="Enter From Date" required />
                                            <div class="input-group-append" data-target="#formdate"
                                                data-toggle="datetimepicker">
                                                <div class="input-group-text"><i class="fa fa-calendar"></i></div>
                                            </div>
                                        </div>

                                    </div>
                                </div>

                                <div class="col-md-2 col-sm-4">
                                    <div class="form-group">
                                        <label for="todate">To Date</label>
                                        <div class="input-group date" id="todate" data-target-input="nearest">
                                            <input type="text" class="form-control form-control-sm datetimepicker-input"
                                                data-target="#todate" name="todate" id="todate"
                                                value="{{ $todate }}" placeholder="Enter To Date" required />
                                            <div class="input-group-append" data-target="#todate"
                                                data-toggle="datetimepicker">
                                                <div class="input-group-text"><i class="fa fa-calendar"></i></div>
                                            </div>
                                        </div>

                                    </div>
                                </div>

                                <div class="col-md-2 col-sm-4">
                                    <button type="submit" style="margin-top: 30px;"
                                        class="btn btn-primary btn-sm btn_mt">Search</button>
                                    <a href="{{ route('account.income_statement') }}" style="margin-top: 30px;"
                                        class="btn btn-secondary btn-sm btn_mt">Refresh</a>
                                </div>

                            </div>
                        </div>
                    </form>
                </div>
            </div>

            <!-- /.card -->

            <div class="row">
                <!-- left column -->
                <div class="col-md-12">

                    <div class="card card-info">
                        <div class="card-header">
                            <h3 class="card-title">Income Statement Detailed</h3>
                        </div>
                        <!-- /.card-header -->
                        <div class="card-body">
                            <div class="row mb-2">
                                <div class="col-sm-12">
                                    <button id="excelExport" type="button"
                                        class="btn btn-success btn-sm pro_excel float-right">Excel</button>
                                </div>
                            </div>
                            <div id="table2excel" class="table-responsive">
                                <table class="table table-bordered">
                                    <tr>
                                        <th colspan="4">
                                            <div class="row" style="text-align:center">
                                                <div class="col-md-2"></div>
                                                <div class="col-md-8">
                                                    <h3>Income Statement Detailed</h3>
                                                    <h5>{{ $companyInfo->company_name }}</h5>
                                                    <p>Date: </p>
                                                </div>
                                            </div>
                                        </th>
                                    </tr>
                                    <tr>
                                        <th>Description</th>
                                        <th>Taka</th>
                                        <th>Taka</th>
                                        <th>Taka</th>
                                    </tr>

                                    @php
                                        $sale_rtn = 0.0;
                                        $totalPurchase = $purchase->total_amt - $purRtn->rtn_amt;
                                        $totalSale = $saleData->amount - $sale_rtn;
                                        $profit =
                                            $totalSale -
                                            ($totalPurchase + $purchase->tax_amt + $purchase->transport_cost);
                                    @endphp
                                    <tbody>
                                        <tr>
                                            <td>Sale</td>
                                            <td></td>
                                            <td>{{ $saleData->amount }}</td>
                                            <td></td>
                                        </tr>
                                        <tr>
                                            <td>Sale Return</td>
                                            <td></td>
                                            <td>{{ $sale_rtn }}</td>
                                            <td></td>
                                        </tr>

                                        <tr>
                                            <td class="text-right"><b>Net Sale</b></td>
                                            <td></td>
                                            <td></td>
                                            <td>{{ $totalSale }}</td>
                                        </tr>

                                        <tr>
                                            <td>Purchase</td>
                                            <td>{{ $purchase->total_amt }}</td>
                                            <td></td>
                                            <td></td>
                                        </tr>
                                        <tr>
                                            <td>Purchase Return</td>
                                            <td>{{ $purRtn->rtn_amt }}</td>
                                            <td></td>
                                            <td></td>
                                        </tr>

                                        <tr>
                                            <td class="text-right"><b>Net Purchase</b></td>
                                            <td></td>
                                            <td></td>
                                            <td>{{ $totalPurchase }}</td>
                                        </tr>

                                        <tr>
                                            <td>Transportration Cost</td>
                                            <td></td>
                                            <td>{{ $purchase->transport_cost }}</td>
                                            <td></td>
                                        </tr>
                                        <tr>
                                            <td>Tax Amount</td>
                                            <td></td>
                                            <td>{{ $purchase->tax_amt }}</td>
                                            <td></td>
                                        </tr>

                                    </tbody>
                                    <tfoot>
                                        <tr>
                                            <th class="text-right">Total Profit</th>
                                            <th></th>
                                            <th></th>
                                            <th>{{ $profit }}</th>
                                        </tr>
                                    </tfoot>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>
    <!-- /.content -->
@endsection

@push('scripts')
    <script src="{{ asset('plugins/datatables/jquery.dataTables.min.js') }}"></script>
    <script src="{{ asset('plugins/datatables-bs4/js/dataTables.bootstrap4.min.js') }}"></script>
    <script src="{{ asset('plugins/datatables-responsive/js/dataTables.responsive.min.js') }}"></script>

    <script src="{{ asset('plugins/datatables-responsive/js/responsive.bootstrap4.min.js') }}"></script>
    <script src="{{ asset('plugins/datatables-buttons/js/dataTables.buttons.min.js') }}"></script>
    <script src="{{ asset('plugins/datatables-buttons/js/buttons.bootstrap4.min.js') }}"></script>
    <script src="{{ asset('plugins/jszip/jszip.min.js') }}"></script>
    <script src="{{ asset('plugins/pdfmake/pdfmake.min.js') }}"></script>
    <script src="{{ asset('plugins/pdfmake/vfs_fonts.js') }}"></script>
    <script src="{{ asset('plugins/datatables-buttons/js/buttons.html5.min.js') }}"></script>
    <script src="{{ asset('plugins/datatables-buttons/js/buttons.print.min.js') }}"></script>

    <script src="{{ asset('plugins/datatables-buttons/js/buttons.colVis.min.js') }}"></script>

    <script src="{{ asset('plugins/select2/js/select2.full.min.js') }}"></script>
    <script src="{{ asset('js/jquery.table2excel.js') }}"></script>

    <script>
        $("#excelExport").click(function() {
            $("#table2excel").table2excel({
                exclude: ".noExl",
                name: "income_statement_detailed",
                filename: "income_statement_detailed",
                fileext: ".xls"
            });
        });

        function printSlip(sale_id, type) {


            $("#inv_details").html('');


            var url = '{{ route('saleres.printslip', ':id') }}';
            url = url.replace(':id', sale_id);

            var jqxhr = $.get(url, function(data) {
                    if (!data) {
                        alert('No Sale found!');
                    }
                })
                .done(function(data) {

                    if (type == '1') {

                        $("#inv_details").html(data);

                    } else {

                        var mywindow = window.open('', 'Invoice Print', 'height=400,width=600');
                        mywindow.document.write('<html><head><title></title>');
                        mywindow.document.write(
                            '<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-9ndCyUaIbzAi2FUVXJi0CjmCapSmO7SnpJef0486qhLnuZ2cdeRhO02iuK6FUUVM" crossorigin="anonymous">'
                        );
                        mywindow.document.write('</head><body >');
                        mywindow.document.write(data);
                        mywindow.document.write('</body></html>');
                        mywindow.document.close();
                        mywindow.focus();

                        setTimeout(function() {
                            mywindow.print();
                        }, 1000);

                        setTimeout(function() {
                            mywindow.close();
                        }, 1000);

                    }

                })
                .fail(function() {

                })
                .always(function() {

                });

            jqxhr.always(function() {

            });

        }

        $(function() {

            $('#formdate').datetimepicker({
                format: 'DD-MM-YYYY'
            });

            $('#todate').datetimepicker({
                format: 'DD-MM-YYYY'
            });

            $('.select2').select2()

            $('.select2bs4').select2({
                theme: 'bootstrap4'
            })


            $("#example1").DataTable({
                "responsive": true,
                "lengthChange": false,
                "autoWidth": false,
                "paging": false,
                buttons: [{
                        extend: 'excel',
                        title: 'Product List'
                    },
                    {
                        extend: 'pdf',
                        title: 'Product List'
                    },
                    {
                        extend: 'print',
                        title: 'Product List'
                    },
                    'colvis'
                ]

            }).buttons().container().appendTo('#example1_wrapper .col-md-6:eq(0)');

            $('#example2').DataTable({
                "paging": false,
                "lengthChange": false,
                "searching": false,
                "ordering": true,
                "info": true,
                "autoWidth": false,
                "responsive": true,
            });

        });
    </script>
@endpush