@php
$page_name = 'All 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">All 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:160px;">
                                    <select name="SearchCashAgent" id="SearchCashAgentId"
                                        class="form-control form-control-sm">
                                        <option value="0">ALL CASH AGENTS</option>
                                    </select>
                                </td>
                                <td style="width:150px;">
                                    <button id="SearchBtn" class="btn btn-success btn-block"
                                        onclick="getProfitLoss()">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-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>
                            </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;">
                                            Agent Name
                                        </th>
                                        <th class="text-center">Total Sale</th>
                                        <th class="text-center">Commision</th>
                                        <th class="text-center">Dara Open</th>
                                        <th class="text-center">Akhar Open</th>
                                        <th class="text-center">Total Profit</th>
                                    </tr>
                                </thead>
                                <tbody id="ListBodyPanel">
                                </tbody>
                                <tfoot id="ListFooterPanel"></tfoot>
                            </table>
                        </div>
                    </div>


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


            </div>
             <div class="modal fade" id="AgentModel" style="background: #fff;" tabindex="-1" role="dialog"
                aria-labelledby="basicModalLabel" aria-hidden="true">
                <div class="modal-dialog modal-xl" role="document">
                    <div class="modal-content">
                        <div class="modal-header" style="display: flex; justify-content: center; align-items: center; text-align: center;">
                            <h5 class="modal-title" id="agentname"></h5>
                            <input type="hidden" id="modalAgentId" />
                            <button class="btn btn-success exportToExcel" type="button" style="margin: 0 auto;" onclick="exportExternalModal('pdf')">PDF</button>
                            <button class="btn btn-success exportToExcel" type="button" style="margin: 0 auto;" onclick="exportExternalModal('excel')">Excel</button>
                            <button type="button" class="close" data-dismiss="modal" aria-label="Close" style="position: absolute; right: 10px;">
                                <span aria-hidden="true">×</span>
                            </button>
                        </div>

                        <div class="modal-body" style="padding:3px !important;">
                            <div class="table-responsive">

                                <table style="width:99.9%;" class="table table-bordered">
                                   
                                <div class="table-responsive table2excel CustomFixedTbl">
                                    <table style="width:99.9%;" class="table table-bordered">
                                        <thead>
                                            <tr style="border-top:1px solid #DDD;">
                                                <th>SR.</th>
                                                <th style="width:200px;">Party Name</th>
                                                <th class="text-center">Total Sale</th>
                                                <th class="text-center">Dara Open</th>
                                                <th class="text-right">Akhar Open</th>
                                                <th class="text-right">Hissa</th>
                                                <th class="text-right">T-Profit</th>
                                                <th class="text-right">Rebate</th>
                                                <th class="text-right">HP-Amt</th>
                                                <th class="text-right">Payment</th>
                                                <th class="text-right">Closing</th>
                                            </tr>
                                        </thead>
                                        <tbody id="ShiftListBodyPanel"></tbody>
                                        <tfoot id="ShiftListFooterPanel"></tfoot>
                                    </table>
                                </div>
                          
                                <br>
                            </div>
                        </div>
                    </div>
                </div>
            </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();
                
            });
            // End Agents Group //
            function setFormValuesAndSubmit(format) {
                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(),

                    'fields': JSON.stringify(fields), // Convert array to JSON string
                    'format': format,
                    'type' : 'allAgentReport'
                };

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

                // Submit the form
                $('#exportForm').submit();
            }
            function exportExternal(format) {
                event.preventDefault();
                setFormValuesAndSubmit(format);
            }
            function getProfitLoss() {
                var FromDate = getCustomDatePicker("FromDate", 'D');
                var ToDate = getCustomDatePicker("ToDate", 'D');

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

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

                AjaxCall("/get_all_agent_reports", JsonData, function (response) {
                    $("#ListBodyPanel").html('');
                    AjaxLoader("hide");

                    var sumTotalSale = 0;
                    var sumTotalCommission = 0;
                    var sumDaraOpen = 0;
                    var sumAkharOpen = 0;
                    var sumTodayProfit = 0;
                    var i = 0;
                    $.each(response.data, function (index, obj) {
                        sumTotalSale += this.TotalSale;
                        sumTotalCommission += this.TotalCommission;
                        sumDaraOpen += this.DaraOpen;
                        sumAkharOpen += parseFloat(this.BaharKaAkharOpen) + parseFloat(this.AnderKaAkharOpen);
                        sumTodayProfit += this.TodayProfit;

                        var html = `<tr>
                                <td>${parseInt(i) + parseInt(1)}</td>
                                <td><a href="javascript:void(0)" onclick="getAgentAllShiftReport(${this.AgentId},'${this.AgentName}')">${this.AgentName}</a></td>
                                <td>${customRound(this.TotalSale)}</td>
                                <td>${customRound(this.TotalCommission)}</td>
                                <td>${customRound(this.DaraOpen)}</td>                            
                                <td>${customRound(parseFloat(this.BaharKaAkharOpen) + parseFloat(this.AnderKaAkharOpen))}</td>
                                <td>${customRound(this.TodayProfit)}</td>   
                                </tr>`;
                        
                        $("#ListBodyPanel").append(html);
                        i++;
                    });

                    var htmlSum = `<tr>
                                <th colspan="2">Total</th>
                                <th>${customRound(sumTotalSale)}</th>
                                <th>${customRound(sumTotalCommission)}</th>
                                <th>${customRound(sumDaraOpen)}</th>                            
                                <th>${customRound(sumAkharOpen)}</th>
                                <th>${customRound(sumTodayProfit)}</th>   
                                </tr>`;
                        
                        $("#ListBodyPanel").append(htmlSum);
                })

            }


            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 getCashAgents() {
                $('#SearchCashAgentId').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 COLLECTION 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 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 setFormValuesAndSubmitModal(format) {
                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': $("#modalAgentId").val(),
                    'fields': JSON.stringify(fields), // Convert array to JSON string
                    'format': format,
                    'type' : 'allShift'
                };

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

                // Submit the form
                $('#exportForm').submit();
            }
            function exportExternalModal(format) {
                event.preventDefault();
                
                setFormValuesAndSubmitModal(format);
            }
            function getAgentAllShiftReport(agent_id, agent_name) {
                $("#agentname").text(agent_name);
                $("#modalAgentId").val(agent_id);
                
                $("#ShiftListBodyPanel").html('');
                var JsonData = {
                    'FromDate': getCustomDatePicker("FromDate", 'D'),
                    'ToDate': getCustomDatePicker("ToDate", 'D'),
                    'GroupAgentId': agent_id,
                };
                if (JsonData.ShiftDate == "1970-01-01") {
                    Notify("Invalid ", "Please enter a valid ShiftDate!", "danger");
                    $('#Day_FromDate').focus().select();
                    return false;
                }
                JsonData['nav'] = nav;
                JsonData['Method'] = "ajax_all_shift_short";
                AjaxCall("/get_all_shift_reports", JsonData, function (response) {
                    var i = 0;

                    var sumTotalSale = 0;
                    var sumDaraOpen = 0;
                    var sumBaharKaAkharOpen = 0;
                    var sumHissa = 0;
                    var sumTodayProfit = 0;
                    var sumVapsiAmount = 0;
                    var sumHPAmount = 0;
                    var sumPayment = 0;
                    var sumClosingBalance = 0;

                    $.each(response.data, function (index, obj) {
                        sumTotalSale += parseFloat(this.TotalSale);
                        sumDaraOpen += parseFloat(this.DaraOpen);
                        sumBaharKaAkharOpen += parseFloat(this.BaharKaAkharOpen) + parseFloat(this.AnderKaAkharOpen);
                        sumHissa += parseFloat(this.Hissa);
                        sumTodayProfit += parseFloat(this.TodayProfit);
                        sumVapsiAmount += parseFloat(this.VapsiAmount);
                        sumHPAmount += parseFloat(this.HPAmount);
                        sumPayment += parseFloat(this.Payment);
                        sumClosingBalance += parseFloat(this.ClosingBalance);

                        var html = `<tr>
                                <td>${parseInt(i) + parseInt(1)}</td>
                                <td>${this.LedgerName}</td>
                                <td>${customRound(this.TotalSale)}</td>
                                <td>${customRound(this.DaraOpen)}</td>                       
                                <td>${customRound(parseFloat(this.BaharKaAkharOpen) + parseFloat(this.AnderKaAkharOpen))}</td>
                                <td>${customRound(this.Hissa)}</td>
                                <td>${customRound(this.TodayProfit)}</td>
                                <td>${customRound(this.VapsiAmount)}</td>
                                <td>${customRound(this.HPAmount)}</td>
                                <td>${customRound(this.Payment)}</td>
                                <td>${customRound(this.ClosingBalance)}</td>
                                </tr>`;
                        
                        $("#ShiftListBodyPanel").append(html);
                        i++;
                    });

                    var htmlSum = `<tr>
                            <th colspan="2">Total</th>
                            <th>${customRound(sumTotalSale)}</th>
                            <th>${customRound(sumDaraOpen)}</th>
                            <th>${customRound(sumBaharKaAkharOpen)}</th>
                            <th>${customRound(sumHissa)}</th>
                            <th>${customRound(sumTodayProfit)}</th>
                            <th>${customRound(sumVapsiAmount)}</th>
                            <th>${customRound(sumHPAmount)}</th>
                            <th>${customRound(sumPayment)}</th>
                            <th>${customRound(sumClosingBalance)}</th>
                            </tr>`;

                    $("#ShiftListBodyPanel").append(htmlSum);
                    $("#AgentModel").modal("show");
                });
            }
            
            
            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>