Mr.Combet Webshell 🔥

View File Name : _FarmerDiaryIncomeTab.cshtml


@model RER_Project.DataAccess.ViewModels.Baseline.BaselineViewModel


<div class="table-responsive" style="margin-top: 16px;">
    <table class="table table-bordered table-hover" name="tblIncome_@ViewBag.FiscalYear@ViewBag.Quadrimester" id="tblIncome_@ViewBag.FiscalYear@ViewBag.Quadrimester">
        <thead>
            <tr>
                <th rowspan="2" style="text-align:center;padding-top:20px">Product Name</th>

                <th colspan="5" style="text-align:center">Quantity</th>
                <th rowspan="2">Price Rate (Rs)</th>
                <th rowspan="2" style="text-align:center">Total Sales</th>

                <th colspan="2" style="text-align:center">Area</th>

                <th rowspan="2">Trader</th>
                <th rowspan="2">POS</th>
                <th rowspan="2" style="text-align:center;padding-top:10px">Collection Date (BS)</th>
            </tr>


            <tr>
                <th style="text-align:center">Production </th>
                <th style="text-align:center">Consumption </th>
                <th style="text-align:center">Loss </th>
                <th style="text-align:center">Sales </th>
                <th style="text-align:center"> Unit</th>
                <th style="text-align:center">Production</th>
                <th style="text-align:center">Unit </th>

            </tr>

        </thead>
        <tbody>
        </tbody>

        <tfoot style="line-height:30px;background-color:#edf0ee;color:black" id="tblIncome_@ViewBag.FiscalYear@ViewBag.QuadrimesterFooter">

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

<script type="text/javascript">

    function loadIncome() {

         const ajax = request();

         function request() {
            const url = '/farmer_diary/income/member/' + @Model.MemberDetailView.Id + '/fiscal/' + @ViewBag.FiscalYear + "/quad/" + '@ViewBag.Quadrimester';
             return window.getAjaxRequest(url, "Get", @Model.MemberDetailView.Id);
            }

        ajax.done(function (response) {
              addFarmerDiaryIncomeListToTable(response);
        });

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


    function addFarmerDiaryIncomeListToTable(response) {
        $('#tblIncome_@ViewBag.FiscalYear@ViewBag.Quadrimester tbody > tr').remove();
            $('#tblIncome_@ViewBag.FiscalYear@ViewBag.Quadrimester tfoot > tr').remove();
        var table = $("#tblIncome_@ViewBag.FiscalYear@ViewBag.Quadrimester tbody");
        var totalSales = 0;
        response.forEach(function (x) {

        var row = "<tr>";
                //    row += "<td>" +x.fiscal_year+ "</td>";
                //row += "<td>" + x.quadrimester + "</td>";
                    row += "<td>" + x.category_name + "</td>";
                row += "<td>" +  x.harvesting_production_quantity + "</td>";
                 row += "<td>" + x.consumption_quantity + "</td>";
                row += "<td>" + Number(parseFloat(x.loss_quantity ).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 0 }) + "</td>";
                row += "<td>" + x.sales_quantity + "</td>";
                row += "<td>" + x.income_quantity_unit   + "</td>";

                row += "<td>" + x.sales_price_per_unit + "</td>";
                row += "<td>" +  Number(parseFloat(x.total_sales_amount ).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 })  + "</td>";
                //row += "<td>" + Number(parseFloat( x.investment  ).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 }) + "</td>";
                row += "<td>" + x.production_area + "</td>";
                row += "<td>" + x.production_area_unit + "</td>";
                row += "<td>" + x.trader + "</td>";
                row += "<td>" + x.point_of_selling + "</td>";
                row += "<td>" + x.collection_date_nepali +"</td>";
               
            table.append(row);


              totalSales += parseFloat(x.total_sales_amount);

        })

           var tblFooter = $("#tblIncome_@ViewBag.FiscalYear@ViewBag.Quadrimester tfoot");
         var footerRow = `<tr>
                    <td ><strong>Total :</strong></td>
                    <td colspan="6"></td>
               
                    <td><strong><center> Rs. ${Number(parseFloat(totalSales).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 })}</center></strong></td>
                    <td></td><td></td><td></td><td></td><td></td>
                    </tr>`
         tblFooter.append(footerRow);


    }

</script>



<style>

    .select2-selection__rendered {
        line-height: 29px !important;
    }

    .select2-container .select2-selection--single {
        height: 33px !important;
    }

    .select2-selection__arrow {
        height: 32px !important;
    }
</style>