@php
$page_name = 'Final Balance Report';
@endphp
@php
    $userRole = auth()->user()->roles[0]->id;
    $ledger = auth()->user()->getLedger();
    $group_id = 0;
    if($ledger){
        $group_id = $ledger->group_id;
    }
@endphp
@include('partial.header')
<style>
    .highlighted{
        background-color:rgba(51, 175, 101, 0.4) !important;
    }
</style>
<div class="container-fluid">

    @include('partial.navigation')
        <!--************ Main container start ************* -->
                
        <div class="main-container">
            <!-- Content wrapper start -->
            <div class="content-wrapper">

                <div class="table-container">
                    <table class="table" style="margin-bottom: 0px !important;">
                        <tbody>
                            <tr>
                                <!-- <td style="width:25px;">
                                    <a onclick="window.history.back()" href="rpt_all_shift_short#"
                                        data-toggle="dropdown" aria-haspopup="true">
                                        <i style="font-size:24px;" class="icon-keyboard_backspace"></i>
                                    </a>
                                </td> -->
                                <td style="width:150px;">
                                    <h5 class="table-title">Final Balance Report</h5>
                                </td>
                                <td style="width:50px;"><b>Date</b></td>
                                <td style="width:170px;" id="FromDatePanel">
                                    <table style="width:100%;">
                                        <tbody>
                                            <tr class="form-control form-control-sm" style="padding:0px !important;">
                                                <td style="width:32px; padding:0px !important;"><input
                                                        onfocus="this.select();" onmouseup="return false;"
                                                        onkeypress="return isNumberKeyOnly(event)"
                                                        class="form-control form-control-sm"
                                                        style="border:none !important; height:28px !important;"
                                                        type="text" id="Day_FromDate" name="Day_FromDate" value="{{date('d')}}"
                                                        maxlength="2" data-listener-added_e381efce="true"></td>
                                                <td style="width:3px; padding:0px !important;">/</td>
                                                <td style="width:32px; padding:0px !important;"><input
                                                        onfocus="this.select();" onmouseup="return false;"
                                                        onkeypress="return isNumberKeyOnly(event)"
                                                        class="form-control form-control-sm"
                                                        style="border:none !important; height:28px !important;"
                                                        type="text" id="Month_FromDate" name="Month_FromDate" value="{{date('m')}}"
                                                        maxlength="2" data-listener-added_e381efce="true"></td>
                                                <td style="width:3px; padding:0px !important;">/</td>
                                                <td style="width:50px; padding:0px !important;"><input
                                                        onfocus="this.select();" onmouseup="return false;"
                                                        onkeypress="return isNumberKeyOnly(event)"
                                                        class="form-control form-control-sm"
                                                        style="border:none !important; height:28px !important;"
                                                        type="text" id="Year_FromDate" name="Year_FromDate" value="{{date('Y')}}"
                                                        maxlength="4"></td>
                                                        
                                            </tr>
                                        </tbody>
                                    </table>
                                </td>
                                <td style="width:170px;" id="ToDatePanel">
                                    <table style="width:100%;">
                                        <tbody>
                                            <tr class="form-control form-control-sm" style="padding:0px !important;">
                                                <td style="width:32px; padding:0px !important;"><input
                                                        onfocus="this.select();" onmouseup="return false;"
                                                        onkeypress="return isNumberKeyOnly(event)"
                                                        class="form-control form-control-sm"
                                                        style="border:none !important; height:28px !important;"
                                                        type="text" id="Day_ToDate" name="Day_ToDate" value="{{date('d')}}"
                                                        maxlength="2"></td>
                                                <td style="width:3px; padding:0px !important;">/</td>
                                                <td style="width:32px; padding:0px !important;"><input
                                                        onfocus="this.select();" onmouseup="return false;"
                                                        onkeypress="return isNumberKeyOnly(event)"
                                                        class="form-control form-control-sm"
                                                        style="border:none !important; height:28px !important;"
                                                        type="text" id="Month_ToDate" name="Month_ToDate" value="{{date('m')}}"
                                                        maxlength="2"></td>
                                                <td style="width:3px; padding:0px !important;">/</td>
                                                <td style="width:50px; padding:0px !important;"><input
                                                        onfocus="this.select();" onmouseup="return false;"
                                                        onkeypress="return isNumberKeyOnly(event)"
                                                        class="form-control form-control-sm"
                                                        style="border:none !important; height:28px !important;"
                                                        type="text" id="Year_ToDate" name="Year_ToDate" value="{{date('Y')}}"
                                                        maxlength="4"></td>
                                            </tr>
                                        </tbody>
                                    </table>
                                </td>
                                <td style="width:150px;">
                                    <select name="SearchGroupAgentId" id="SearchGroupAgentId"
                                        class="form-control form-control-sm">
                                        <option value="0">ALL AGENTS</option>
                                    </select>
                                </td>
                                <td style="width:180px; {{ $group_id > 0 ? 'display:none;' : '' }}">
                                    <select name="SearchCashAgent" id="SearchCashAgentId"
                                        class="form-control form-control-sm">
                                        <option value="0">ALL CASH AGENTS</option>
                                    </select>
                                </td>
                                <td style="width:180px; {{ $group_id > 0 ? 'display:none;' : '' }}">
                                    <select name="SearchCashCollAgent" id="SearchCashCollAgentId"
                                        class="form-control form-control-sm">
                                        <option value="0">ALL CASH COLL AGENTS</option>
                                    </select>
                                </td>
                                <td style="width:50px;"><b>Filter</b></td>
                                <td style="width:150px;">
                                    <select name="Filter" id="FilterId"
                                        class="form-control form-control-sm">
                                        <option value="1">All</option>
                                        <option value="2">P&L Zero</option>
                                        <option value="3">P&L Non-Zero</option>
                                        <option value="4">CB Zero</option>
                                        <option value="5">CB Non-Zero</option>
                                    </select>
                                </td>
                                <td style="width:150px;">
                                    <button id="SearchBtn" class="btn btn-success btn-block"
                                        onclick="getFinalBalanceReport()">Search <span id="ajax_loader"></span></button>
                                </td>
                                <td style="width:100px;">
                                    <form id="exportForm" method="POST" action="/export_report" style="display: flex;gap: 20px;">
                                        <input type="hidden" name="_token" value="{{ csrf_token() }}">
                                        <input type="hidden" name="FromDate" id="FromDateExport">
                                        <input type="hidden" name="ToDate" id="ToDateExport">
                                        <input type="hidden" name="GroupAgentId" id="GroupAgentIdExport">

                                        <input type="hidden" name="CashAgentId" id="CashAgentIdExport">
                                        <input type="hidden" name="CashCollAgentId" id="CashCollAgentIdExport">
                                        <input type="hidden" name="Filter" id="FilterIdExport">

                                        <input type="hidden" name="fields" id="fieldsExport">
                                        <input type="hidden" name="format" id="formatExport">
                                        <input type="hidden" name="type" id="typeExport">

                                        <button class="btn btn-success btn-block exportToExcel" type="button" onclick="exportExternal('excel')">Excel</button>
                                        <button class="btn btn-success btn-block exportToExcel" type="button" style="margin: 0;" onclick="exportExternal('pdf')">PDF</button>
                                    </form>
                                </td>
                                <td style="width: 220px;"><input class="form-control form-control-sm" type="text" id="searchInput" placeholder="Search"></td>
                            </tr>
                        </tbody>
                    </table>
                    <div class="table-container">
                        <div class="table-responsive table2excel CustomFixedTbl CustomFreezTable"
                            style="min-height: 79vh; max-height: 79vh; overflow-x: scroll;">
                            <table class="table table-bordered" id="finalBalanceReportTable">
                            <thead>
                                    <tr style="border-top:1px solid #DDD;">
                                        <th>Sr.</th>
                                        
                                        <th class="text-center" style="width:280px;">
                                            Party Name
                                        </th>
                                        <th class="text-center">Agent</th>
                                        <th class="text-center">Opening</th>
                                        <th class="text-center">T-Profit</th>
                                        <th class="text-center">Payment</th>
                                        <th class="text-center">Debit</th>
                                        <th class="text-center">Credit</th>
                                    </tr>
                                </thead>
                                <tbody id="ListBodyPanel">
                                </tbody>
                                <tfoot id="ListFooterPanel"></tfoot>
                            </table>
                        </div>
                    </div>


                </div>
                <!-- Content wrapper end -->


            </div>
            <!-- *************
                    ************ Main container end *************
                ************* -->
        </div>

        <script>
            var BaseUrl = "/";
            var nav = "rpt_all_shift_short";
            var LoginRoleId = "2";
         </script>                           

        @include('partial.footer')
        
        <script>
            var LayerLedgerId = "0";
            var LayerFromDate = "{{date('Y-m-d')}}";



            $(document).ready(function () {
                $("#FromDatePanel").html(CustomDatePicker("FromDate", LayerFromDate));

                getAgentsGroup();
                getCashAgents();
                getCashCollAgents()
            });
            function getCashAgents() {
                $('#SearchCashAgentId').html('<option value="0"> -- ALL -- </option>');
                     var JsonData = { 'AgentLedgerId': 0 };
                JsonData['nav'] = nav;
                JsonData['Method'] = "ajax_ajax_cash_agents";
                AjaxCallSync("/ajax_cash_agents", JsonData, function (response) {
                    if (response.status == true) {
                        var Row = '';
                        Row += '<option value="0">ALL CASH AGENTS</option>';
                        $.each(response.data, function (index, obj) {
                            Row += '<option value="' + this.id + '">' + this.name + '</option>';
                        });
                        $('#SearchCashAgentId').html(Row);

                    } else if (response.status == false) {
                        //Notify("Message ",response.message,"danger");
                    }
                });
            }
            function getCashCollAgents() {
                $('#SearchCashCollAgentId').html('<option value="0"> -- ALL -- </option>');
                     var JsonData = { 'AgentLedgerId': 0 };
                JsonData['nav'] = nav;
                JsonData['Method'] = "ajax_ajax_cash_agents";
                AjaxCallSync("/ajax_cash_collection_agent", JsonData, function (response) {
                    if (response.status == true) {
                        var Row = '';
                        Row += '<option value="0">ALL CASH COLL AGENTS</option>';
                        $.each(response.data, function (index, obj) {
                            Row += '<option value="' + this.id + '">' + this.name + '</option>';
                        });
                        $('#SearchCashCollAgentId').html(Row);

                    } else if (response.status == false) {
                        //Notify("Message ",response.message,"danger");
                    }
                });
            }
            function setFormValuesAndSubmit(format, type) {
                if(format == "excel"){
                    var fields = [
                        'LedgerName', 'Mobile', 'AgentName','LimitValue','OpeningBalance','TotalSale','DaraSale','BaharKaAkharSale','AnderKaAkharSale','TotalCommission','DaraOpen','BaharKaAkharOpen','AnderKaAkharOpen','TPC','Hissa','TodayProfit','Kist','VapsiAmount','HPAmount','Payment','ClosingBalance','LedgerName'
                    ];
                }
                else{
                    var fields = [
                        'LedgerName', 'TodayProfit', 'Payment', 'ClosingBalance'
                    ];
                }
                

                var JsonData = {
                    'FromDate': getCustomDatePicker("FromDate", 'D'),
                    'ToDate': getCustomDatePicker("ToDate", 'D'),
                    'GroupAgentId': $('#SearchGroupAgentId').val(),
                    'CashAgentId': $('#SearchCashAgentId').val(),
                    'CashCollAgentId': $('#SearchCashCollAgentId').val(),
                    'Filter':$("#FilterId").val(),
                    'fields': JSON.stringify(fields),
                    'format': format,
                    'type' : type
                };

                // Set form values
                $('#FromDateExport').val(JsonData.FromDate);
                $('#ToDateExport').val(JsonData.ToDate);
                $('#GroupAgentIdExport').val(JsonData.GroupAgentId);
                $('#CashAgentIdExport').val(JsonData.CashAgentId);
                $('#CashCollAgentIdExport').val(JsonData.CashCollAgentId);
                $('#FilterIdExport').val(JsonData.Filter);
                $('#fieldsExport').val(JsonData.fields);
                $('#formatExport').val(JsonData.format);
                $('#typeExport').val(JsonData.type);

                // Submit the form
                $('#exportForm').submit();
            }
            function exportExternal(format) {
                event.preventDefault();
                setFormValuesAndSubmit(format, "finalBalanceReport");
            }
            var $table = $('#finalBalanceReportTable');
            var $tbody = $table.find('tbody');
            var $originalRows;
            function getFinalBalanceReport() {
                var FromDate = getCustomDatePicker("FromDate", 'D');
                var ToDate = getCustomDatePicker("ToDate", 'D');

                var JsonData = {
                    'FromDate': FromDate,
                    'ToDate':ToDate,
                    'GroupAgentId'	: $('#SearchGroupAgentId').val(),
                    'CashAgentId': $('#SearchCashAgentId').val(),
                    'CashCollAgentId': $('#SearchCashCollAgentId').val(),
                    'Filter':$("#FilterId").val()
                };

                JsonData['nav'] = nav;
                JsonData['Method'] = "ajax_get_final_balance_report";
                
                AjaxLoader("show");

                AjaxCall("/get_final_balance_report", JsonData, function (response) {
                    $("#ListBodyPanel").html('');
                    AjaxLoader("hide");
                    
                    var sumOpeningBalance = 0;
                    var sumTodayProfit = 0;
                    var sumPayment = 0;
                    var sumDebit = 0;
                    var sumCredit = 0;

                    $.each(response.data, function (index, obj) {
                        var credit = 0;
                        var debit = 0;

                        if(this.ClosingBalance > 0){
                            debit = this.ClosingBalance;
                        }
                        else{
                            credit = this.ClosingBalance
                        }

                        sumOpeningBalance += this.OpeningBalance;
                        sumTodayProfit += this.TodayProfit;
                        sumPayment += this.Payment;
                        sumDebit += debit;
                        sumCredit += credit;

                        var html = `<tr>
                                <td>${parseInt(index) + parseInt(1)}</td>
                                <td>${this.LedgerName}</td>
                                <td>${this.AgentName}</td>
                                <td>${customRound(this.OpeningBalance)}</td>
                                <td>${customRound(this.TodayProfit)}</td>
                                <td>${customRound(this.Payment)}</td>
                                <td style="color:#10a11a">${Math.abs(customRound(debit))}</td>
                                <td style="color:#c21708">${Math.abs(customRound(credit))}</td>
                                </tr>`;
                        
                        $("#ListBodyPanel").append(html);
                        $originalRows = $tbody.children().clone();
                    });

                    var html = `<tr>
                            <th colspan = "3">Total</th>
                            <th>${customRound(sumOpeningBalance)}</th>
                            <th>${customRound(sumTodayProfit)}</th>
                            <th>${customRound(sumPayment)}</th>
                            <th>${customRound(Math.abs(sumDebit))}</th>
                            <th>${customRound(Math.abs(sumCredit))}</th>
                            </tr>`;
                    
                    $("#ListBodyPanel").append(html);
                })

            }


            function ExportToExl() {
                ExportToExcel_custom("HVS_Detail_FromAllShiftReport", "HPMaintable2excel");
            }
            $(function () {
                $("body").keydown(function (e) {
                    var keyCode = e.keyCode || e.which;
                    if (keyCode == 113) // F2 - Save Transaction
                    {
                        e.preventDefault();
                        AddBtn();
                    }
                    if (keyCode == 116) // F5 - Random
                    {
                        e.preventDefault();
                    }
                });
            });
            function getAgentsGroup() {
                $('#SearchGroupAgentId').html('<option value="0"> -- ALL -- </option>');
                var JsonData = { 'AgentLedgerId': 0 };
                JsonData['nav'] = nav;
                JsonData['Method'] = "ajax_agent_groups";
                AjaxCallSync("/ajax_agents", JsonData, function (response) {
                    if (response.status == true) {
                        var Row = '';
                        Row += '<option value="0">ALL AGENTS</option>';
                        $.each(response.data, function (index, obj) {
                            Row += '<option value="' + this.id + '">' + this.name + '</option>';
                        });
                        $('#SearchGroupAgentId').html(Row);

                    } else if (response.status == false) {
                        //Notify("Message ",response.message,"danger");
                    }
                });
            }
            
            
            ko.bindingHandlers.nextFieldOnEnter = {
                init: function(element, valueAccessor, allBindingsAccessor) {
                    $(element).on('keydown', 'input, select', function (e) {
                        var self = $(this)
                        , form = $(element)
                          , focusable
                          , next
                        ;
                        //LastFocusedControl_Id = $(":focus").attr("id");
                        if (e.keyCode == 13) {
                            focusable = form.find('input,select,button,textarea').filter(':visible');
                            var nextIndex = focusable.index(this) == focusable.length -1 ? 0 : focusable.index(this) + 1;
                            next = focusable.eq(nextIndex);
                                
                                
                            next.focus().select();
                            return false;
                        }
                    });
                }
            };
            ko.applyBindings({});
             $(document).ready(function() {
                // Search functionality
                $('#searchInput').on('keyup', function() {
                    var input = $(this).val().toLowerCase();
                    var filteredRows = [];

                    // If the search input is empty, restore the original rows
                    if (input === "") {
                    $tbody.empty().append($originalRows.clone());
                    return;
                    }

                    // Iterate through the original rows and filter based on input
                    $originalRows.each(function() {
                    var $row = $(this);
                    var match = false;

                    // Check if any cell in the row contains the input text
                    $row.find('td').each(function() {
                        if ($(this).text().toLowerCase().indexOf(input) > -1) {
                        match = true;
                        return false;  // Exit loop if a match is found
                        }
                    });

                    // Add matching rows to the filteredRows array
                    if (match) {
                        filteredRows.push($row);
                    }
                    });

                    // Clear the tbody and append filtered rows or show "No results found"
                    $tbody.empty();

                    if (filteredRows.length > 0) {
                    $.each(filteredRows, function(index, $row) {
                        $tbody.append($row);
                    });
                    } else {
                    // Display a message if no results are found
                    $tbody.append('<tr><td colspan="' + $table.find('thead th').length + '">No results found</td></tr>');
                    }
                });
            });
        </script>