Mr.Combet Webshell 🔥

View File Name : _FarmerDiaryInvestmentPlanTab.cshtml



@model RER_Project.DataAccess.ViewModels.Baseline.BaselineViewModel

<div class="table-responsive" style="margin-top: 16px;">
    <table class="table table-bordered table-hover" name="tblInvestmentPlan_@ViewBag.FiscalYear" id="tblInvestmentPlan_@ViewBag.FiscalYear">
        <thead>
            <tr>
                @*<th>Fiscal Year </th>
                <th>Quadrimester</th>*@
                <th style="text-align:center"> Grants (Rs) </th>
                <th style="text-align:center"> Self Investment (Rs)</th>
                <th style="text-align:center"> Remittance (Rs)</th>
                <th style="text-align:center"> Other Investment (Rs)</th>
                <th style="text-align:center"> Loan (Rs)</th>
            </tr>
        </thead>
        <tbody>
        </tbody>

        <tfoot style="line-height:30px;background-color:#edf0ee;color:black" id="tblInvestmentFooter">

        </tfoot>
    </table>
</div>

<script type="text/javascript">

        function loadInvestment() {
             const ajax = request();

         function request() {
            
            const url = '/farmer_diary/investment_plan/member/' + @Model.MemberDetailView.Id + '/fiscal/' + @ViewBag.FiscalYear;

             return window.getAjaxRequest(url, "Get", @Model.MemberDetailView.Id);
            }


        ajax.done(function (response) {

              addInvestmentPlanListToTable(response);
        });

        ajax.fail(function (xhr) {
            ShowMessage("error", xhr.responseText);
        });
    }

    function addInvestmentPlanListToTable(response)
    {
        if (response.length == 0) {
            $('#tblInvestmentFooter').hide();
        }
        else {
               $('#tblInvestmentFooter').show();
        }
        $('#tblInvestmentPlan_@ViewBag.FiscalYear tbody > tr').remove();
        $('#tblInvestmentPlan_@ViewBag.FiscalYear tfoot > tr').remove();
        var table = $("#tblInvestmentPlan_@ViewBag.FiscalYear tbody");
        var grantTotal = 0;
        var selfInvestmentTotal = 0;
        var remittanceTotal = 0;
        var otherInvestmentTotal = 0;
        var loanTotal = 0;
            response.forEach(function (x) {
               
                var row = "<tr>";
                //row += "<td>" +x.fiscal_year+ "</td>";
                //row += "<td>" + x.quadrimester + "</td>";
                row += "<td><center>" + Number(parseFloat(x.grants).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 }) + "</center></td>";
                 row += "<td><center>" +Number(parseFloat(x.self_investment).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 })  + "</center></td>";
                row += "<td><center>" + Number(parseFloat(x.remittance).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 }) + "</center></td>";
                row += "<td><center>" +Number(parseFloat(x.other_investment).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 })  + "</center></td>";
                row += "<td><center>" + Number(parseFloat(x.loan).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 })  + "</center></td>";
                                         
                grantTotal += parseFloat(x.grants);
                 selfInvestmentTotal += parseFloat(x.self_investment);
                remittanceTotal += parseFloat(x.remittance);
                otherInvestmentTotal += parseFloat(x.other_investment);
                   loanTotal += parseFloat(x.loan);
        table.append(row);
            })

           var tblFooter = $("#tblInvestmentPlan_@ViewBag.FiscalYear tfoot");
         var footerRow = `<tr>
                    <td style="white-space:nowrap;"><strong>Total : Rs.  ${Number(parseFloat(grantTotal).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 })}</strong></td>
                  
               
                    <td><strong><center> Rs. ${Number(parseFloat(selfInvestmentTotal).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 })}</center></strong></td> 
                    <td><strong><center> Rs. ${Number(parseFloat(remittanceTotal).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 })}</center></strong></td> 
                    <td><strong><center> Rs. ${Number(parseFloat(otherInvestmentTotal).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 })}</center></strong></td> 
                    <td><strong><center> Rs. ${Number(parseFloat(loanTotal).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 })}</center></strong></td> 
                   </tr>`
                tblFooter.append(footerRow);
    }

</script>