@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.balanceSheet') }}">
                    <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.balanceSheet') }}" 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">Balance Sheet</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>Balance Sheet</h3>
                                                <h5>{{ $companyInfo->company_name }}</h5>
                                                <h6><b>Ramarbagh,Kutubpur,Fatullah,Narayanganj</b></h6>
                                                <p>Date: {{$formdate}} To {{$todate}}</p>
                                            </div>
                                        </div>
                                    </th>
                                </tr>
                                <tr>
                                    <th>Description</th>
                                    <th>Taka</th>
                                    <th>Taka</th>
                                    <th>Taka</th>
                                </tr>

                                @php
                                $totalSale = 0;
                                $withdraw_IncomeTax = 0;
                                $net_profit_netLose = 0;
                                $recv_money_pubali = $receivedMoney ?? 0
                                @endphp
                                <tbody>
                                    <tr>
                                        <td><b>Current Asset :</b></td>
                                        <td></td>
                                        <td></td>
                                        <td></td>
                                    </tr>
                                    <tr>
                                        <td><b>Bank Deposit :</b></td>
                                        <td></td>
                                        <td></td>
                                        <td></td>
                                    </tr>
                                    @foreach ($saleAll as $sale)


                                    <tr>
                                        <td class="text-right">{{ $sale->payment_method }}</td>
                                        @if ($sale->method_id == 6)
                                        <td class="text-right">{{ ($sale->amount + $pubaliBankDepositQuery) - ($recv_money_pubali + $pubaliBankWithdrawQuery) ?? 0 }}</td>
                                        @elseif ($sale->method_id == 5)
                                        <td class="text-right">{{ ($sale->amount + $cityBankDepositQuery) - ($receivedMoneyShajala +$cityBankWithdrawQuery) ?? 0 }}</td>
                                        @elseif ($sale->method_id == 9)
                                        <td class="text-right">{{ $sale->amount - $receivedMoneyShajala ?? 0 }}</td>
                                        @else
                                        <td class="text-right">{{ $sale->amount }}</td>
                                        @endif
                                        <td></td>
                                        <td></td>
                                    </tr>
                                    @php
                                    $totalSale += $sale->amount -($recv_money_pubali + $receivedMoneyShajala);
                                    $factoryKitchenClosingBalance = 0;
                                    @endphp
                                    @endforeach
                                    <tr>
                                        <td class="text-right font-weight-bold">Total Bank Deposit</td>
                                        <td></td>
                                        <td class="text-right font-weight-bold">{{$totalSale}} </td>
                                        <td></td>
                                    </tr>
                                    <tr>
                                        <td class="text-right">Cash in Hand</td>
                                        <td></td>
                                        <td class="text-right font-weight-bold">{{$cashReportClosing}} </td>
                                        <td></td>
                                    </tr>
                                    <tr>
                                        <td><b>Closing Stock :</b></td>
                                        <td></td>
                                        <td></td>
                                        <td></td>
                                    </tr>
                                    <tr>
                                        <td class="text-right">Kitchen Closing</td>
                                        <td class="text-right">{{$kitchenClosing}}</td>
                                        <td></td>
                                        <td class="text-right"> </td>
                                    </tr>

                                    <tr>
                                        <td class="text-right">Factory Closing </td>
                                        <td class="text-right">{{$factoryClosing}} </td>
                                        <td></td>
                                        <td></td>
                                    </tr>
                                    <tr>
                                        <td class="text-right"><b>Total</b> </td>
                                        <td class="text-right"> </td>
                                        <td class="text-right font-weight-bold">
                                            @php
                                            $factoryKitchenClosingBalance = $kitchenClosing + $factoryClosing;
                                            $fixedAssetTotal = 0;
                                            @endphp
                                            {{$factoryKitchenClosingBalance}}
                                        </td>
                                        <td></td>
                                    </tr>

                                    <tr>
                                        <td class="font-weight-bold">Fixed Asset :</td>
                                        <td> </td>
                                        <td></td>
                                        <td class="text-right"></td>
                                    </tr>
                                    @foreach ($fixedAsset as $fixAsset)

                                    <tr>
                                        <td class="">{{$fixAsset->cat_name}}</td>
                                        <td class="text-right">{{$fixAsset->total}} </td>
                                        <td></td>
                                        <td class="text-right"></td>
                                    </tr>
                                    @php
                                    $fixedAssetTotal += $fixAsset->total;
                                    @endphp
                                    @endforeach
                                    <tr>
                                        <td class="text-right">Total</td>
                                        <td></td>
                                        <td class="text-right"><b>{{$fixedAssetTotal}} </b></td>
                                        <td></td>
                                    </tr>
                                    <tr>
                                        <td class="text-right"><b>Total Asset</b></td>
                                        <td></td>
                                        @php
                                        $totalAssetAndClosingAndSale = $totalSale+ $cashReportClosing+ $factoryKitchenClosingBalance+ $fixedAssetTotal ;
                                        @endphp
                                        <td class="text-right"><b>{{$totalAssetAndClosingAndSale}} </b></td>
                                        <td></td>
                                    </tr>



                                    <tr>
                                        <td class=""><b>Capital:</b></td>
                                        <td class="text-right"> </td>
                                        <td></td>
                                        <td></td>
                                    </tr>


                                    <tr>
                                        <td><b>Closing Capital</b></td>
                                        <td></td>
                                        <td></td>
                                        <td class="text-right"><b>{{$capitalClosingBalance}}</b> </td>
                                    </tr>


                                    <tr>
                                        <td><b>Loan :</b></td>
                                        <td></td>
                                        <td class="text-right"><b></b> </td>
                                        <td></td>
                                    </tr>
                                    @php
                                    $loanAmount =0;
                                    $supplierDuesAmount = 0;
                                    $assetsSupplierDuesAmount = 0;
                                    @endphp
                                    @foreach ($loanGiven as $loan )


                                    <tr>
                                        <td class="text-right">
                                            {{$loan->account_name}}
                                        </td>
                                        <td class="text-right"><b>{{$loan->closingAmount}}</b> </td>
                                        <td></td>
                                        <td></td>
                                    </tr>

                                    @php
                                    $loanAmount += $loan->closingAmount;

                                    @endphp
                                    @endforeach

                                    <tr>
                                        <td class="text-right"><b>Total Loan Given</b></td>
                                        <td></td>
                                        <td class="text-right"><b>{{$loanAmount}}</b> </td>
                                        <td></td>
                                    </tr>
                                    <tr>
                                        <td class=""><b>Liabilities:</b></td>
                                        <td></td>
                                        <td class="text-right"><b></b> </td>
                                        <td></td>
                                    </tr>
                                    <tr>
                                        <td class=""><b>Supplier Dues:</b></td>
                                        <td></td>
                                        <td class="text-right"><b></b> </td>
                                        <td></td>
                                    </tr>
                                    @foreach ($supplierDues as $supDue)
                                    @if ($supDue->product_type != 4 && $supDue->due >0 )

                                    <tr>
                                        <td class="">{{$supDue->supplier_name}}</td>
                                        <td></td>
                                        <td class="text-right">{{$supDue->due ?? 0}} </td>
                                        <td></td>
                                    </tr>
                                    @php
                                    $supplierDuesAmount += $supDue->due ?? 0;

                                    @endphp
                                    @endif
                                    @endforeach


                                    <tr>
                                        <td class="text-right"><b>Total</b></td>
                                        <td></td>
                                        <td class="text-right"><b>{{$supplierDuesAmount}}</b> </td>
                                        <td></td>
                                    </tr>

                                    <tr>
                                        <td class=""><b>Asset Supplier Dues:</b></td>
                                        <td></td>
                                        <td class="text-right"><b></b> </td>
                                        <td></td>
                                    </tr>

                                    @foreach ($supplierDues as $supDue)
                                    @if ($supDue->product_type == 4 && $supDue->due >0 )

                                    <tr>
                                        <td class="">{{$supDue->supplier_name}}</td>
                                        <td></td>
                                        <td class="text-right">{{$supDue->due}} </td>
                                        <td></td>
                                    </tr>
                                    @php
                                    $assetsSupplierDuesAmount += $supDue->due;
                                    @endphp
                                    @endif
                                    @endforeach

                                    <tr>
                                        <td class="text-right"><b>Total</b></td>
                                        <td></td>
                                        <td class="text-right"><b>{{$assetsSupplierDuesAmount}}</b> </td>
                                        <td></td>
                                    </tr>
                                    <tr>
                                        <td class="text-right"><b>Total Liabilites</b></td>
                                        <td></td>
                                        <td class="text-right"><b>{{$assetsSupplierDuesAmount + $supplierDuesAmount}}</b> </td>
                                        <td></td>
                                    </tr>
                                </tbody>
                                <tfoot>
                                    <tr>
                                        <td><b>Total Capital & Liabilities </b></td>
                                        <td></td>
                                        <td></td>
                                        <td class="text-right">{{$capitalClosingBalance + $loanAmount + $supplierDuesAmount + $assetsSupplierDuesAmount}} </td>
                                    </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