@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;
    }

    #table2excel {
        font-size: 18px;
    }

    /* Table body */
    #table2excel table td,
    #table2excel table th {
        font-size: 18px;
    }

    /* Headings */
    #table2excel h4 {
        font-size: 18px;
        font-weight: bold;
    }

    /* Address & date line */
    #table2excel address,
    #table2excel p small {
        font-size: 18px;
    }

    /* Totals & closing balance */
    #table2excel .font-weight-bolder,
    #table2excel tfoot th,
    #table2excel tfoot td {
        font-size: 18px;
        font-weight: bold;
    }

    .pdf-export #table2excel {
        font-size: 25px;
    }
</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.incomeStatementManual') }}">
                    <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.incomeStatementManual') }}" 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/Expense Cash Report</h3>
                    </div>
                    @php
                    $inDirectAmt = 0;
                    $netDirectExpense = 0;
                    $netSupPay = 0;
                    $netSale = 0;
                    $netAssetsPay = 0;
                    $netIncome=0;
                    $netLoan=0;

                    @endphp
                    <!-- /.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>
                                <button id="pdfExport" type="button" class="btn btn-danger btn-sm float-right mr-2">PDF</button>
                            </div>


                        </div>
                        <div id="table2excel" class="table-responsive mt-3">
                            <div class="text-center mb-3">
                                <h4>Shalimar Kitchen</h4>
                                <address>
                                    <strong>Ramarbagh, Kutubpur, Fatullah, Narayanganj </strong><br>
                                    Mobile No:01711-886946, 01711886947<br>

                                </address>
                                <h4><b>Cash Report</b></h4>
                                <p><small>From {{ $formdate }} To {{ $todate }}</small></p>
                            </div>

                            <div class="row">
                                <!-- Income Table -->
                                <div class="col-md-6">
                                    <table class="table table-bordered table-sm">
                                        <thead class="table-light text-center">
                                            <tr>
                                                <!-- <th colspan="3">Income</th> -->
                                            </tr>
                                            <tr class="bg-secondary">
                                                <th style="text-align: center;">Income</th>
                                                <th class="text-right">Taka</th>
                                                <th class="text-right">Taka</th>
                                            </tr>

                                        </thead>
                                        <tbody style="font-size: 30px;">

                                            <tr>
                                                <th>Opening Balance</th>
                                                <td></td>
                                                <td class="text-right"><b>{{number_format($openingBalance,2)}}</b></td>
                                            </tr>

                                            @foreach ($saleData as $sale)

                                            <tr>
                                                <td>{{$sale->outlet_name}} ({{$sale->payment_method}})</td>
                                                <td class="text-right"><b>{{$sale->amount }}</b></td>
                                                <td></td>


                                            </tr>

                                            @php
                                            $netSale += $sale->amount;
                                            @endphp
                                            @endforeach
                                            <tr>
                                                <td class="text-right"><b>Total Sale</b></td>
                                                <td></td>
                                                <td class="text-right"><b>{{ number_format($netSale, 2) }}</b></td>
                                            </tr>

                                            <thead>
                                                <tr class="bg-secondary">
                                                    <th style="text-align: center;">Income Group name</th>
                                                    <th class="text-right">Sub Group Name</th>
                                                    <th class="text-right">Taka</th>
                                                </tr>
                                            </thead>

                                            @foreach ($income as $inc)

                                            <tr>
                                                <td>{{$inc->group_name}}</td>
                                                <td>{{$inc->sub_group_name}}</td>
                                                <td class="text-right"><b>{{$inc->amount }}</b></td>


                                            </tr>

                                            @php
                                            $netIncome += $inc->amount;
                                            @endphp
                                            @endforeach

                                            @foreach ($loanGivenIncome as $lonInc)
                                            <tr>
                                                <td></td>
                                                <td>{{$lonInc->account_name}}</td>
                                                <td class="text-right"><b>{{$lonInc->payAmount }}</b></td>


                                            </tr>

                                            @php
                                            $netIncome += $lonInc->payAmount;
                                            @endphp
                                            @endforeach
                                            <tr>
                                                <td class="text-right"><b>Total Amount</b></td>
                                                <td></td>
                                                <td class="text-right"><b>{{ number_format($netIncome, 2) }}</b></td>
                                            </tr>

                                            <thead>
                                                <tr class="bg-secondary">
                                                    <th style="text-align: center;">Loan Group Name</th>
                                                    <th class="text-right">Sub Group Name</th>
                                                    <th class="text-right">Taka</th>
                                                </tr>
                                            </thead>

                                            @foreach ($loan as $inc)

                                            <tr>
                                                <td>{{$inc->group_name}}</td>
                                                <td>{{$inc->sub_group_name}}</td>
                                                <td class="text-right"><b>{{$inc->amount }}</b></td>


                                            </tr>

                                            @php
                                            $netLoan += $inc->amount;
                                            @endphp
                                            @endforeach
                                            <tr>
                                                <td class="text-right"><b>Total Amount</b></td>
                                                <td></td>
                                                <td class="text-right"><b>{{ number_format($netLoan, 2) }}</b></td>
                                            </tr>
                                        </tbody>
                                    </table>
                                </div>



                                <!-- Expense Table -->
                                <div class="col-md-6">
                                    <table class="table table-bordered table-sm">
                                        <thead class="table-light text-center">
                                            <tr>
                                                <!-- <th colspan="3">Expenses</th> -->
                                            </tr>
                                            <tr class="bg-secondary">
                                                <th colspan="2">Expense</th>

                                                <th class="text-right">Taka</th>
                                                <th class="text-right">Taka</th>
                                            </tr>
                                        </thead>
                                        <tbody style="font-size: 30px;">
                                            <tr>
                                                <th>Supplier Payment</th>
                                                <td></td>
                                                <td></td>
                                                <td class=" text-right">
                                                </td>
                                            </tr>

                                            @foreach ($supplierBillPayment as $supPayAmt)

                                            @if ($supPayAmt->product_type !== 4)
                                            <tr>
                                                <td></td>
                                                <td>{{$supPayAmt->supplier_name}}</td>
                                                <td style="text-align: right;">{{number_format($supPayAmt->total_amt,2)}}</td>
                                                <td></td>
                                            </tr>

                                            @php

                                            $netSupPay += $supPayAmt->total_amt;
                                            @endphp
                                            @endif

                                            @endforeach
                                            <tr>
                                                <th colspan=""></th>
                                                <th></th>
                                                <th style="text-align: right;">Total Bill Payment</th>
                                                <th style="text-align: right;">{{number_format ($netSupPay,2)}}</th>
                                            </tr>
                                            </tr>
                                            <tr>
                                                <th class="text-left"><b>Direct Expense</b></th>
                                                <th></th>
                                                <th class="text-right"><b></b></th>
                                            </tr>

                                            @foreach ($direct_expense as $directExp)


                                            <tr>
                                                <td>{{$directExp->group_name}}</td>
                                                <td>{{$directExp->sub_group_name}}</td>
                                                <td class="text-right">{{$directExp->amount}}</td>
                                                <td></td>
                                            </tr>
                                            @php
                                            $netDirectExpense +=$directExp->amount;
                                            @endphp
                                            @endforeach
                                            <tr>
                                                <th colspan=""></th>
                                                <th></th>
                                                <th class="text-right">Total Direct Expense</th>
                                                <th class="text-right">{{number_format($netDirectExpense,2)}}</th>
                                            </tr>
                                            <tr>
                                                <th class="text-left"><b>In Direct Expense</b></th>
                                                <th></th>
                                                <th class="text-right"><b></b></th>
                                            </tr>

                                            @foreach ($inDirect_expense as $indirectPay)


                                            <tr>
                                                <td>{{$indirectPay->group_name}} </td>
                                                <td>{{$indirectPay->sub_group_name}} </td>
                                                <td class="text-right">{{$indirectPay->amount}} </td>
                                                <td></td>
                                            </tr>
                                            @php
                                            $inDirectAmt +=$indirectPay->amount;
                                            @endphp
                                            @endforeach
                                            <tr>
                                                <th colspan=""></th>
                                                <th></th>
                                                <th class="text-right">Total In Direct Expense</th>
                                                <th class="text-right">{{number_format($inDirectAmt,2)}} </th>
                                            </tr>
                                            <tr>
                                                <th class="text-left"><b>Assets Expense</b></th>
                                                <th></th>
                                                <th class="text-right"><b></b></th>
                                            </tr>
                                            @foreach ($supplierBillPayment as $asstPay )

                                            @if($asstPay->product_type == 4)
                                            <tr>
                                                <td></td>
                                                <td>{{$asstPay->supplier_name}} </td>
                                                <td class="text-right">{{number_format($asstPay->total_amt,2)}} </td>
                                                <td></td>
                                                @php
                                                $netAssetsPay +=$asstPay->total_amt;
                                                @endphp

                                                @endif
                                            </tr>

                                            @endforeach
                                            @foreach ($assetsPay as $assets)
                                            <tr>
                                                <td></td>
                                                <td>{{$assets->supplier_name}}</td>
                                                <td class="text-right">{{$assets->total_amt}}</td>
                                                <td></td>

                                            </tr>
                                            @php
                                            $netAssetsPay +=$assets->total_amt;
                                            @endphp

                                            @endforeach

                                            @foreach ($current_assets as $currAst)
                                            <tr>
                                                <td>{{$currAst->group_name}} </td>
                                                <td>{{$currAst->sub_group_name}} </td>
                                                <td class="text-right">{{$currAst->amount}} </td>
                                                <td></td>
                                            </tr>
                                            @php
                                            $netAssetsPay +=$currAst->amount;
                                            @endphp
                                            @endforeach

                                            @foreach ($loanGivenExpense as $lonExp)
                                            <tr>
                                                <td> </td>
                                                <td>{{$lonExp->account_name}} </td>
                                                <td class="text-right">{{$lonExp->amount}} </td>
                                                <td></td>
                                            </tr>

                                            @php
                                            $netAssetsPay +=$lonExp->amount;
                                            @endphp
                                            @endforeach
                                            <tr>
                                                <th colspan=""></th>
                                                <th></th>
                                                <th class="text-right">Total Assets Expense</th>
                                                <th class="text-right">{{number_format($netAssetsPay,2)}}</th>
                                            </tr>
                                            @php
                                            $totalExpense = ($inDirectAmt + $netDirectExpense +$netSupPay +$netAssetsPay);
                                            $closingBalance = ($netSale + $openingBalance +$netIncome + $netLoan) -$totalExpense;
                                            @endphp
                                            <tr>
                                                <td></td>
                                                <th>Total Expense</th>
                                                <td></td>
                                                <td>{{ number_format($inDirectAmt + $netDirectExpense +$netSupPay +$netAssetsPay,2)}}</td>
                                            </tr>

                                            <tr>
                                                <td></td>
                                                <th colspan="2">Closing Balance</th>
                                                <td class="text-right font-weight-bolder">


                                                    {{number_format($closingBalance,2)}}
                                                </td>
                                            </tr>
                                            <!-- <tr>
                                                <td>Tax Amount</td>
                                                <td></td>
                                                <td class="text-right"></td>
                                            </tr> -->
                                        </tbody>
                                    </table>
                                </div>
                            </div>

                            <!-- Profit Summary -->
                            <table class="table table-bordered table-sm mt-3">
                                <tfoot style="font-size: 30px;">
                                    <tr style="background-color:#e9f7ef;font-weight:bold; margin-left: 10px;">
                                        <th colspan="3" class="text-right">Total</th>
                                        <td class="text-right w-25">{{ number_format($netSale +$netIncome + $netLoan+$openingBalance, 2) }}</td>
                                        <th colspan="2" class="text-right">Total</th>
                                        <td class="text-right">{{ number_format($totalExpense + $closingBalance,2)}}</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 src="https://cdnjs.cloudflare.com/ajax/libs/jquery-table2excel/1.1.1/jquery.table2excel.min.js"></script>

<script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf/2.5.1/jspdf.umd.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/html2canvas/1.4.1/html2canvas.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/xlsx@0.18.5/dist/xlsx.full.min.js"></script>



<script>
    $("#excelExport").click(function() {
        var wb = XLSX.utils.book_new();
        var allTables = document.querySelectorAll("#table2excel table");

        let allRows = [];

        allTables.forEach((table) => {
            const wsData = XLSX.utils.sheet_to_json(XLSX.utils.table_to_sheet(table), {
                header: 1
            });
            allRows = allRows.concat([
                []
            ], wsData); // add space between tables
        });

        const ws = XLSX.utils.aoa_to_sheet(allRows);
        XLSX.utils.book_append_sheet(wb, ws, "Cash Report");
        XLSX.writeFile(wb, "cash_report.xlsx");
    });



    $("#pdfExport").click(function() {

        // 🔥 Add class for PDF font
        $("body").addClass("pdf-export");

        const {
            jsPDF
        } = window.jspdf;
        const pdf = new jsPDF("p", "pt", "a4");
        const element = document.getElementById("table2excel");

        html2canvas(element, {
            scale: 2.5, // NOT font size, only clarity
            useCORS: true
        }).then((canvas) => {

            const imgData = canvas.toDataURL("image/png");
            const imgWidth = 595.28;
            const pageHeight = 841.89;
            const imgHeight = (canvas.height * imgWidth) / canvas.width;

            let heightLeft = imgHeight;
            let position = 0;

            pdf.addImage(imgData, "PNG", 0, position, imgWidth, imgHeight);
            heightLeft -= pageHeight;

            while (heightLeft > 0) {
                position = heightLeft - imgHeight;
                pdf.addPage();
                pdf.addImage(imgData, "PNG", 0, position, imgWidth, imgHeight);
                heightLeft -= pageHeight;
            }

            pdf.save("cash_report.pdf");

            // 🔥 Remove class after export
            $("body").removeClass("pdf-export");
        });
    });




    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