@php
$page_name = 'Cash Coll Agent Report';
@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:180px;">
                                    <h5 class="table-title">Cash Coll Agent Report</h5>
                                </td>
                                <td style="width:50px;"><b>Date</b></td>
                                <td style="width:145px;" 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:145px;" 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:150px;">
                                    <select name="Filter" id="FilterId"
                                        class="form-control form-control-sm">
                                        <option value="1">All</option>
                                        <option value="2">CB Zero</option>
                                        <option value="3">CB Non-Zero</option>
                                    </select>
                                </td>
                                <!-- <td style="width:50px;"><b>Sale</b></td> -->
                                <!-- <td style="width:150px;">
                                    <input id="AboveAmount" class="form-control form-control-sm" type="text" placeholder="Above">
                                </td> -->
                                <td style="width:150px;">
                                    <button id="SearchBtn" class="btn btn-success btn-block"
                                        onclick="getCashAgentReport()">Search <span id="ajax_loader"></span></button>
                                </td>
                                <td style="width:150px;">
                                    <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="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>
                                    </form>
                                </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">
                            <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>
            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(),
                    '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);
                $('#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, "cashColAgentReport");
            }

            var LayerLedgerId = "0";
            var LayerFromDate = "{{date('Y-m-d')}}";

            

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

                getAgentsGroup();
            });

            function getCashAgentReport() {
                var FromDate = getCustomDatePicker("FromDate", 'D');
                var ToDate = getCustomDatePicker("ToDate", 'D');

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

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

                AjaxCall("/get_cash_coll_agent_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">${customRound(Math.abs((debit)))}</td>
                                <td style="color:#c21708">${customRound(Math.abs((credit)))}</td>
                                </tr>`;
                        
                        $("#ListBodyPanel").append(html);
                    });

                    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 () {
                $("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({});
        </script>