@php
$page_name = 'Vapsi 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">Vapsi 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;">
                                    <button id="SearchBtn" class="btn btn-success btn-block"
                                        onclick="getAutoVapsi()">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="fields" id="fieldsExport">
                                        <input type="hidden" name="format" id="formatExport">
                                        <input type="hidden" name="type" id="typeExport">

                                        <button class="btn btn-primary 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">Agent</th>
                                        <th class="text-center" style="width:280px;">
                                            Party
                                        </th>
                                    
                                        <th class="text-center">T-Sale</th>
                                        <th class="text-center">P&L</th>
                                        <th class="text-center">Vapsi %</th>
                                        <th class="text-center">Vapsi Amount</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')}}";
            var LayerToDate = "{{date('Y-m-d')}}";
            function setFormValuesAndSubmit(format) {

                var JsonData = {
                    'FromDate': getCustomDatePicker("FromDate", 'D'),
                    'ToDate': getCustomDatePicker("ToDate", 'D'),
                    'GroupAgentId'	: $('#SearchGroupAgentId').val(),
                    'format': format,
                    'type' : 'autoVapsiReport'
                };

                // Set form values
                $('#FromDateExport').val(JsonData.FromDate);
                $('#ToDateExport').val(JsonData.ToDate);
                $('#GroupAgentIdExport').val(JsonData.GroupAgentId);
                $('#formatExport').val(JsonData.format);
                $('#typeExport').val(JsonData.type);

                // Submit the form
                $('#exportForm').submit();
            }
            function exportExternal(format) {
                event.preventDefault();
                setFormValuesAndSubmit(format);
            }


            $(document).ready(function () {
                    $("#FromDatePanel").html(CustomDatePicker("FromDate", LayerFromDate));
                    $("#ToDatePanel").html(CustomDatePicker("ToDate", LayerToDate));
                    $("#ProcessDatePanel").html(CustomDatePicker("ProcessDate", LayerFromDate));
                setTimeout(function () {
                    CustomJantriControl("jv", "JantriView", "readonly");
                    $('#Day_FromDate').focus().select();
                }, 100);
                getAgentsGroup();
            });

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

                var JsonData = {
                    'FromDate': FromDate,
                    'ToDate': ToDate,
                    'GroupAgentId': $('#SearchGroupAgentId').val(),
                };
                 JsonData['nav'] = nav;
                JsonData['Method'] = "ajax_get_auto_vapsi";
                AjaxLoader("show");
                AjaxCall("/get_auto_vapsi", JsonData, function (response) {
                    $("#ListBodyPanel").html('');
                    AjaxLoader("hide");
                    var total_sale = 0;
                    var total_pl = 0;
                    var total_vapsi_amount = 0;

                    $.each(response.data, function (index, obj) {
                            var vapsiAmount = (this.Rebate / 100) * this.TodayProfit;
                            total_sale += this.TotalSale;
                            total_pl += this.TodayProfit;
                            total_vapsi_amount += vapsiAmount;

                            var html = `<tr class="auto_vapsi_row_${this.LedgerId}">
                                    <td>${parseInt(index) + parseInt(1)}</td>
                                    <td>${this.AgentName}</td>
                                    <td>${this.LedgerName}</td>
                                    <td>${this.TotalSale}</td>
                                    <td>${customRound(this.TodayProfit)}</td>
                                    <td>${this.Rebate}%</td>
                                    <td>${customRound(vapsiAmount)}</td>
                                    </tr>`;
                            
                            $("#ListBodyPanel").append(html);
                        });

                        var finalRow = `<tr>
                                            <td colspan = 4>Total</td>
                                            <td>${total_sale}</td>
                                            <td>${customRound(total_pl)}</td>
                                            <td>${customRound(total_vapsi_amount)}</td>
                                        </tr>`;
                        $("#ListBodyPanel").append(finalRow);
                });
            }



            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");
                    }
                });
            }
            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();
                    }
                });
            });
            
            
        

            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>