Mr.Combet Webshell 🔥

Edit File Name : _FarmerDiaryIncomeTab.cshtml

@model RER_Project.DataAccess.ViewModels.Baseline.BaselineViewModel
@using RER_Project.Core.Helpers;
@using RER_Project.BusinessLayer.BusinessService

@{
    var meta = AppUserService.GetCurrent();
}
@{
    var memberStatus = Model.MemberDetailView.IsActive;
}

<div class="form-group col-md-2">
            <label><strong>Date of data collection</strong></label>
            <input type="date" class="required form-control" id="farmerdiarydate" name="farmerdiarydate" />
        </div>

@*<div class="form-group col-md-2">
            <label><strong>Enterprise</strong></label>
            <input type="text" class=" required form-control" id="Enterpriseid" name="Enterpriseid">

</div>*@
        <div class="form-group col-md-2">
            <label><strong>Enterprise</strong></label>
            <select type="text" class="form-control required" name="Commodity" id="CommodityForProductionTab" data-api="/commodity/by/memberid/@Model.MemberDetailView.Id"></select>
        </div>
        <div class="form-group col-md-2">
            <label><strong>Commodity</strong></label>
            <select type="text" class="form-control" name="Category" id="CategoryForProductionTab">
                <option value>Select </option>
            </select>

</div>

<div class="form-group col-md-2 Q">
            <label><strong>Production Quantity</strong></label>
            <input type="text" class="curr form-control currencyFormatter" onkeypress="return isNumberKey(this,event)" name="ProductionQuantitys" id="ProductionQuantitys">

</div>

<div class="form-group col-md-2 Q">
            <label><strong>Consumption Quantity</strong></label>
            <input type="text" class="curr form-control currencyFormatter" onkeypress="return isNumberKey(this,event)" name="ConsumptionQuantity" id="ConsumptionQuantity">

</div>
        <div class="form-group col-md-2 Q">
            <label><strong>Loss Quantity</strong></label>
            <input type="text" class="curr form-control currencyFormatter" onkeypress="return isNumberKey(this,event)" name="lossQuantity" id="lossQuantity">

</div>
        <div class="form-group col-md-2 Q">
            <label><strong>Sales Quantity</strong></label>
            <input type="text" class="curr form-control currencyFormatter" onkeypress="return isNumberKey(this,event)" name="salesQuantity" id="salesQuantity">

</div>

<div class="form-group col-md-2">
            <label><strong>Total Sales Amount</strong></label>
            <div class="inputWithIcon">
                <input type="text" class="curr form-control required currencyFormatter" onkeypress="return isNumberKey(this,event)" name="totalsales" id="totalsales">
                <span><strong>MVR</strong></span>
            </div>
        </div>

<div class="form-group col-md-2 Q">
            <label><strong>Average Selling Price</strong></label>
            <div class="inputWithIcon">
                <input type="text" class="curr form-control currencyFormatter" onkeypress="return isNumberKey(this,event)" name="averageselling" id="averageselling">
                <span><strong>MVR</strong></span>
            </div>
        </div>

<div class="form-group col-md-2" id="rr">
            <label><strong>Local Trader Name</strong></label>
            <div class="inputWithIcon">
                <input type="text" class="curr form-control  "  name="local" id="local">
               
            </div>
        </div>

<div class="form-group col-md-2" id="rp"> 
            <label><strong>Market Name</strong></label>
            <div class="inputWithIcon">
                <input type="text" class="curr form-control " name="marketid" id="marketid">
                
            </div>
        </div>

<div class="form-group col-md-4">
            <label>&nbsp;</label><br />
            @if (meta.RoleId == (int)EnumRoleHelper.Roles.Admin || meta.RoleId == (int)EnumRoleHelper.Roles.ProjectDirector || meta.RoleId == (int)EnumRoleHelper.Roles.BDS || meta.RoleId == (int)EnumRoleHelper.Roles.MnE || meta.RoleId == (int)EnumRoleHelper.Roles.MnEOfficer)
            {
                <input type="button" value="Save" class="btn btn-primary" id="SubmitFarmerDiaryIncome" />
            }
            <a href="/farmer_diary/time_frame/member/@Model.MemberDetailView.Id" class="btn btn-default"><i class="fa fa-arrow-circle-o-left" aria-hidden="true"></i> Back</a>

</div>

</form>

<div class="row">
    <div class="col-lg-12">
        <a class="btn btn-primary btnPrevious"><i class="fa fa-arrow-circle-o-left" aria-hidden="true"></i> &nbsp;Previous</a>
        <a class="btn btn-primary btnNext">Next <i class="fa fa-arrow-circle-o-right" aria-hidden="true"></i></a>
    </div>
</div>

<div class="table-responsive" style="margin-top: 16px;">
    <table class="table table-bordered table-hover" name="tblIncomeplan" id="tblIncomeplan">
        <thead>
            <tr>
                <th rowspan="2" style="padding-top:20px">Date of data collection</th>
                @*<th rowspan="2" style="padding-top:20px">Enterprise</th>*@
            <th rowspan="2" style="padding-top:20px">Enterprise</th>

<th rowspan="2" style="padding-top:20px">Commodity</th>
                <th rowspan="2" style="padding-top:20px">Production Quantity</th>
                <th rowspan="2" style="padding-top:20px">Consumption Quantity</th>
                <th rowspan="2" style="padding-top:20px">Loss Quantity</th>
                <th rowspan="2" style="padding-top:20px">Sales Quantity</th>
                <th rowspan="2" style="padding-top:20px">Total Sales Amount</th>
                <th rowspan="2" style="padding-top:20px">Average Selling Price</th>
                <th rowspan="2" style="padding-top:20px">Sold To</th>
               
                <th rowspan="2" style="padding-top:20px">Local Trader Name</th>
                <th rowspan="2" style="padding-top:20px">Market Name</th>

@if (memberStatus)

{
                    <th rowspan="2" style="text-align:center;padding-top:20px">Action</th>

}
            </tr>

</thead>
        <tbody>
        </tbody>
        <tfoot style="line-height:30px;background-color:#edf0ee;color:black" id="tblFooter">

</tfoot>
    </table>

</div>

});

$('#CommodityForProductionTab').off("change").on("change", function () {
        debugger;
        var id = $(this).val();
        if (id == 23) {
            console.log('hi');
            $('.Q').hide();
        }
        else
        {
            $('.Q').show();
        }
    });

function loadIncome() {
        debugger;

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

const url = '/farmer_diary/Income/member/' + @Model.MemberDetailView.Id + "/fiscal/" + '@ViewBag.FiscalYear' + "/quatile/" + '@ViewBag.Quadrimester';
             return window.getAjaxRequest(url, "Get", @Model.MemberDetailView.Id);
            }

ajax.done(function (response) {

addIncomeListToTable(response);
        });

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

}

function addIncomeListToTable(response) {

console.log("RE$sponse", response);

var status = '@memberStatus';
        var totalProductionAreaInHectare = 0.0;
        var averagesellingprice = 0.0;

$('#tblIncomeplan tbody > tr').remove();
          $('#tblIncomeplan tfoot > tr').remove();
        var table = $("#tblIncomeplan tbody");
        response.forEach(function (x) {

var datetime = new Date(x.collectiondate);
            var year = datetime.getFullYear();
            var month = ("0" + (datetime.getMonth() + 1)).slice(-2);
            var day = ("0" + datetime.getDate()).slice(-2);
            var formattedDate = day + "/" + month + "/ " + year;

var row = "<tr>";
            row += "<td>" + formattedDate + "</td>";
                @*row += "<td>" + x.enterprise + "</td>";*@
                row += "<td>" + x.commodity + "</td>";
            row += "<td>" + x.areaofproduction + "</td>";
            row += "<td>" + x.productionqty + " </td>";
            row += "<td>" + x.consumptionqty + "</td>";
            row += "<td>" + x.lossqty + "</td>";
            row += "<td>" + x.saleqty + "</td>";
            row += "<td>" + x.totalsalesamount + "</td>";
                row += "<td>" + x.averagesellingprice + "</td>";
               @* row += "<td>" + getNumberWithComma(x.production_quantity) + "</td>";
                         row += "<td>" + x.quantity_unit + "</td>";*@
            row += "<td>" + x.soldto + "</td>";
            row += "<td>" + x.trdaer_name + "</td>";
            row += "<td>" + x.market_name + "</td>";

row += "<td class='hideshow'>" + "<a class='btn btn-default btn-xs' style='color:dodgerblue' onclick=editfarmerdiaryincomeForm(" + x.id + ") ><i  class='fa fa-edit'></i >"
                    + "</a >&nbsp;&nbsp;<a  class='btn btn-default btn-xs' style='color:dodgerblue' onclick=deletefarmerdiaryIncomePlan(" + x.id + ") ><i class='fa fa-trash'></i ></a> ";

averagesellingprice += parseFloat(x.averagesellingprice || 0);

table.append(row);
            })

var tblFooter = $("#tblIncomeplan tfoot");
           var footerRow = `<tr>
                   <td></td> <td ></td><td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td><strong>Total :${getNumberWithComma(averagesellingprice.toFixed(3))}</strong ></td ><td ></td> <td></td><td></td> <td></td> </tr>`;
            tblFooter.append(footerRow);

if (status === 'False') {
            $('.hideshow').hide();
        }
    }

function editfarmerdiaryincomeForm(IncomeId) {

const ajax = request(IncomeId);

function request(IncomeId) {

const url = '/farmer_diary/Income/' + IncomeId;

return window.getAjaxRequest(url, "Get", IncomeId);

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

var datetime = new Date(response.dateofcollection);
            var year = datetime.getFullYear();
            var month = ("0" + (datetime.getMonth() + 1)).slice(-2);
            var day = ("0" + datetime.getDate()).slice(-2);
            var formattedDate = year + "-" + month + "-" + day;
            console.log("opppppppppdate", formattedDate);

setTimeout(
                function () {
                    $("#CategoryForProductionTab").val(response.area_of_production);

}, 300);

$('#CommodityForProductionTab').val(response.commodity_id);
            $('#CommodityForProductionTab').trigger("change");
            $('#farmerdiarydate').val(formattedDate);

$('#incomeid').val(response.Id);
            $('#Enterpriseid').val(response.enterprise);
           $('#lossQuantity').val(getNumberWithComma(response.loss_qty));
           $('#ConsumptionQuantity').val(getNumberWithComma(response.consumption_qty));
           $('#ProductionQuantitys').val(getNumberWithComma(response.production_qty));
           $('#totalsales').val(getNumberWithComma(response.total_sales_amount));
           $('#salesQuantity').val(getNumberWithComma(response.sales_qty));
        $('#averageselling').val(getNumberWithComma(response.average_selling_price));
            $('#soldto').val(getNumberWithComma(response.sold_to));
            debugger;
            if (response.sold_to == '0') {
                debugger;
                $("#rr").show();
                $('#marketid').val(response.market_name);
               
            }
            else if (response.sold_to == '1')
            {
                debugger;
                $("#rp").show();
                $('#local').val(response.local_name);
            }
            
            window.scrollTo(200, 0);

var val = $('#incomeid').val();

});

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

$("#SubmitFarmerDiaryIncome").off("click").on("click", function () {

function request(model) {

const url = "/farmer_diary/income_plan/create";
                   const data = JSON.stringify(model);
                   debugger;

return window.getAjaxRequest(url, "POST", data);
            }

const form = $("#CreateFarmerDiaryIncomePlan");
               console.log("from", form);

$.validator.unobtrusive.parse(form);

if (!form.valid()) {
                return false;
            };

if (!window.confirmAction()) {
                return;
         };

WorkForce.loader.show();

var allFormData = window.serializeForm(form);

function getModel() {
             return (getFarmerDiaryIncomePlan());
            }

function getFarmerDiaryIncomePlan() {
            var farmerDiaryIncomePlan = {};
            debugger;
            var IncomeId = $('#incomeid').val();
            farmerDiaryIncomePlan.Id =IncomeId;
            farmerDiaryIncomePlan.Enterprise = allFormData.Enterpriseid;
            farmerDiaryIncomePlan.area_of_production = allFormData.Category;
           farmerDiaryIncomePlan.commodity_id = allFormData.Commodity;
           farmerDiaryIncomePlan.dateofcollection = allFormData.farmerdiarydate;
           farmerDiaryIncomePlan.loss_qty = removeCommaFromString(allFormData.lossQuantity);
           farmerDiaryIncomePlan.consumption_qty = removeCommaFromString(allFormData.ConsumptionQuantity);
           farmerDiaryIncomePlan.production_qty = removeCommaFromString(allFormData.ProductionQuantitys);
            farmerDiaryIncomePlan.total_sales_amount = removeCommaFromString(allFormData.totalsales);
             farmerDiaryIncomePlan.average_selling_price = removeCommaFromString(allFormData.averageselling);
            farmerDiaryIncomePlan.sold_to = removeCommaFromString(allFormData.soldto);
            farmerDiaryIncomePlan.local_name = allFormData.local;
            farmerDiaryIncomePlan.market_name = allFormData.marketid;
            farmerDiaryIncomePlan.sales_qty = removeCommaFromString(allFormData.salesQuantity);
            farmerDiaryIncomePlan.GroupId = @Model.MemberDetailView.GroupId;
            farmerDiaryIncomePlan.BaselineId = @Model.Baseline.Id;
            farmerDiaryIncomePlan.DistrictId = @Model.MemberDetailView.DistrictId;
            farmerDiaryIncomePlan.FiscalYear = '@ViewBag.FiscalYear';
            farmerDiaryIncomePlan.MemberId = @Model.MemberDetailView.Id;
            farmerDiaryIncomePlan.Quadtrimester = '@ViewBag.Quadrimester';

return farmerDiaryIncomePlan;

}

const model = getModel();

const ajax = request(model);

ajax.done(function (response) {

WorkForce.loader.hide();
                showNotification("success");

// get the data after sucess
                loadIncome();
                // clear the form in data
                farmerDiaryIncomePlan();
            });

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

})

function farmerDiaryIncomePlan() {

$('#CategoryForProductionTab').val("");
        $('#CommodityForProductionTab').val("");
        $('#farmerdiarydate').val("");
        $('#Enterpriseid').val("");
        $('#lossQuantity').val("");
        $('#ConsumptionQuantity').val("");
        $('#ProductionQuantitys').val("");
        $('#totalsales').val
        $('#salesQuantity').val("");
        $('#averageselling').val("");
        $('#soldto').val("");
        $('#totalsales').val("");
        $('#marketid').val("");
        $('#local').val("");

}

function deletefarmerdiaryIncomePlan(incomeId) {
        let conf = confirm(`Are you sure you want to delete this Farmer Diary Income plan  ?`);
        if (!conf) {

return;
        } else {

const ajaxResponse = requestdeletefarmerdiaryIncomePlan(incomeId);

ajaxResponse.done(function (response) {
                WorkForce.loader.hide();
                if (response) {

farmerDiaryIncomePlan();
                    loadIncome();
                   
                    ShowMessage("success", "Successfully Deleted this Farmer Diary Income Plan");
                }

WorkForce.loader.hide();
            });

ajaxResponse.fail(function (xhr) {
                WorkForce.loader.hide();
                ShowMessage("Error", xhr.responseText);
            });

WorkForce.loader.hide();

}
    }

function requestdeletefarmerdiaryIncomePlan(incomeId) {
        const url = "/farmer_diary/income_plan/delete/";
        const data = JSON.stringify({ "Id": incomeId });
        return window.getAjaxRequest(url, "POST", data);
    }

$("#ProductionQuantitys").bind("change paste keyup", function () {
        var val = removeCommaFromString($("#ProductionQuantitys").val());
        if (val > 1) {
            $("#salesQuantity").prop('disabled', false);
            $("#ConsumptionQuantity").prop('disabled', false);
            $("#lossQuantity").prop('disabled', false);
        }

else {
            $("#salesQuantity").prop('disabled', true);
            $("#ConsumptionQuantity").prop('disabled', true);
            $("#lossQuantity").prop('disabled', true);
        }
    });

$('#ProductionQuantitys').bind("cut copy paste", function (e) {
        e.preventDefault();
    });

$('#ConsumptionQuantity').bind("cut copy paste", function (e) {
        e.preventDefault();
    });

$('#lossQuantity').bind("cut copy paste", function (e) {
        e.preventDefault();
    });

$('#salesQuantity').bind("cut copy paste", function (e) {
        e.preventDefault();
    });

$("#ConsumptionQuantity").bind("change paste keyup", function () {

var consumptionQuantity = removeCommaFromString($("#ConsumptionQuantity").val());
        var lossQuantity = removeCommaFromString($("#lossQuantity").val());
        var productionQuantity = removeCommaFromString($("#ProductionQuantitys").val());
        var salesQty = removeCommaFromString($("#salesQuantity").val());
        if (consumptionQuantity >= (productionQuantity - lossQuantity - salesQty)) {
            ShowMessage("error", `Consumption Qty must be less than ${Math.abs(parseFloat(productionQuantity - lossQuantity - salesQty))}`);
        }

//var totalSalesQty = parseFloat(productionQuantity) - parseFloat(consumptionQuantity) - parseFloat(lossQuantity);
        //$('#SalesQuantity').val(getNumberWithComma(totalSalesQty));

});

$("#lossQuantity").bind("change paste keyup", function () {
        var productionQuantity = removeCommaFromString($("#ProductionQuantitys").val());

var consumptionQuantity = removeCommaFromString($("#ConsumptionQuantity").val());
        var lossQuantity = removeCommaFromString($("#lossQuantity").val());
        var salesQuantity = removeCommaFromString($("#salesQuantity").val());
        var totalSalesAmount = removeCommaFromString($("#totalsales").val());
        if (lossQuantity >= (productionQuantity - consumptionQuantity)) {
            ShowMessage("error", `Loss Qty must be less than ${Math.abs(parseFloat(productionQuantity - consumptionQuantity))}`);
            return;
        }

var totalSalesQty = parseFloat(productionQuantity) - parseFloat(consumptionQuantity) - parseFloat(lossQuantity);
        $('#salesQuantity').val(getNumberWithComma(totalSalesQty));

var perUnitSalesPrice = parseFloat(totalSalesAmount) / parseFloat(totalSalesQty);

$('#averageselling').val(getNumberWithComma(perUnitSalesPrice))//need to check this ;

});

$("#totalsales").bind("change paste keyup", function () {

var salesQuantity = removeCommaFromString($("#salesQuantity").val());

var totalSalesAmount = removeCommaFromString($("#totalsales").val());

var result = parseFloat(totalSalesAmount) / parseFloat(salesQuantity);
        debugger;
        $('#averageselling').val(getNumberWithComma(result)) //need to check this;
    });

$("#salesQuantity").bind("change paste keyup", function () {

var salesQuantity = removeCommaFromString($("#salesQuantity").val());

var totalSalesAmount = removeCommaFromString($("#totalsales").val());

var result = parseFloat(totalSalesAmount) / parseFloat(salesQuantity);

$('#averageselling').val(getNumberWithComma(result))//need to check this;;
    });

</script>