Mr.Combet Webshell 🔥

Edit File Name : RuralDashboardBIReport.cshtml

@{
    ViewBag.Title = "Rural Finance BI Report";
    Layout = "~/Views/Shared/_Layout.cshtml";
}

<div class="row wrapper border-bottom white-bg page-heading">
        <div class="col-md-8">
            <ol class="breadcrumb">
                <li class="active">
                    <strong>Rural Finance BI Analysis</strong>
                </li>
            </ol>

</div>
    </div>
    <br />
    <div class="row">
        <div class="col-lg-12">
            <div class="ibox-content" style="margin-bottom:2%">
                <button type="button" class="btn btn-primary pull-right" onclick="tableToExcel('pvtTable','PivotDownload')">
                    <i class="fa fa-file-excel-o" aria-hidden="true"></i>&nbsp;&nbsp;Download Data
                </button>
                <br />
                <br />
                <div class="form">
                    <div class="row">
                        <input type="hidden" id="FromDate" name="FromDate" />
                        <input type="hidden" id="ToDate" name="ToDate" />
                        <input type="hidden" id="FromDateNepali" name="FromDateNepali" />
                        <input type="hidden" id="ToDateNepali" name="ToDateNepali" />
                        <div class="form-group col-md-2">
                            <label><strong>Province</strong></label>
                            <select type="text" class="form-control required" name="ProvinceId" id="ProvinceId" data-api="/province/select/threeStates"></select>
                        </div>

<div class="form-group col-md-2">
                            <label><strong>District</strong></label>
                            <select type="text" class="form-control required" name="DistrictId" id="DistrictId" data-api="/districts/select" disabled></select>

</div>

<div class="form-group col-md-2">
                            <label><strong>Municipality</strong></label>
                            <select type="text" class="form-control required" id="MunicipalityId" name="MunicipalityId" data-api="/municipality/select" disabled></select>

</div>

<div class="form-group col-md-2">
                            <label><strong>Commodity</strong></label>
                            <select type="text" class="form-control required" id="CommodityId" name="CommodityId" data-api="/commodity/select/exceptother"></select>

</div>

<div class="form-group  col-md-2">
                            <label><strong>Fiscal Year</strong></label>
                            <select type="text" class="form-control required" name="FiscalYearId" id="FiscalYearId" data-api="/fiscal_year/select"></select>

</div>
                        <div class="form-group col-md-2">
                            <label><strong>Cooperative</strong></label>
                            <select type="text" class="form-control required" name="CoopId" id="CoopId" data-api="/cooperatives/select"></select>
                        </div>
                        <div class="form-group col-md-1" style="margin-top:22px">

</div>
                    </div>
                </div>

</div>
        </div>
    </div>

$(document).ready(function () {
        window.initializeSelectApis2();
        window.initializeCascadeLocation2();
        loadBIRuralFinance(0, 0, 0, 0, 0);
    })

function loadBIRuralFinance(province, district, municipality, coop, fiscalyear) {
        debugger;
        const ajax = request();

function request() {

const url = `/rural/bi_report/data?province=${province}&coop=${coop}&municipality=${municipality}&district=${district}&fiscalYear=${fiscalyear}`;

return window.getAjaxRequest(url, "Get", 1);
        }

ajax.done(function (response) {
            console.log(response);
            setToPivotTable(response);
        });

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

$('#filter').off("click").on("click", function () {
        //var fromDate = $('#FromDate').val();

//var toDate = $('#ToDate').val();
        var provinceId = $('#ProvinceId').val();
        if (provinceId == "") {
            provinceId = 0;
        }
        else {
            provinceId = Number(provinceId);
        }
        var districtId = $('#DistrictId').val();
        if (districtId == "") {
            districtId = 0;
        }
        else {
            districtId = Number(districtId)
        }

function setToPivotTable(response) {

$("#output").pivotUI(
            response,
            {
                rows: ["Coopearative", "CoopType"],
                cols: ["Province", "District", "Municipality"]
            },
            {
                onRefresh: function (config) {
                    var config_copy = JSON.parse(JSON.stringify(config));
                    //delete some values which are functions
                    delete config_copy["aggregators"];
                    delete config_copy["renderers"];
                    //delete some bulky default values
                    delete config_copy["rendererOptions"];
                    delete config_copy["localeStrings"];
                    $("#output").text(JSON.stringify(config_copy, undefined, 2));
                }
            }
        );
    }

</script>

<style>

@@import url('../../Content/plugins/pivotTable/pivot.css');

#output {
        display: block;
        width: 100%;
        overflow: auto;
    }
</style>