Mr.Combet Webshell 🔥

View File Name : OverAllGroupReport.cshtml

@{
    ViewBag.Title = "Group Reports";
}

<div class="row">
    <div class="col-lg-12">
        <div class="ibox float-e-margins">
            <br />
            <div class="ibox-content">
                <label><b>Download Data on Memberwise baseline and farmer diary</b></label>
                <hr />
                <div class="form-horizontal">
                    <div class="form-group">

                        <div class="col-md-1 control-label">
                            Province:
                        </div>
                        <div class="col-md-2">
                            <select type="text" class="form-control required" name="ProvinceId" id="ProvinceId" data-api="/user_wise/province/select"></select>
                        </div>

                        <div class="col-md-1 control-label">
                            Atoll:
                        </div>
                        <div class="col-md-2">
                            <select type="text" class="form-control required" name="DistrictId" id="DistrictId" data-api="/districts/select" disabled=""></select>
                        </div>
                        <div class="col-md-1 control-label">
                            Island:
                        </div>
                        <div class="col-md-2">
                            <select type="text" class="form-control required" id="MunicipalityId" name="MunicipalityId" data-api="/municipality/select" disabled="">
                                <option value="">All</option>
                            </select>
                        </div>

                        <div class="col-md-1 control-label">
                            Commodity:
                        </div>
                        <div class="col-md-2">
                            @Html.ListBox("Commodity", null, new { @multiple = "multiple", @style = "display:none", @class = "form-control required clear", @onchange = "getCommodities()" })
                        </div>
                    </div>
                    <div class="form-group">
                        <br />
                        <div class="col-md-1 control-label">
                            IFF:
                        </div>
                        <div class="col-md-5">
                            <select type="text" class="form-control required" name="GroupId" id="GroupId" data-api="/siftgroup/select"></select>
                            <input type="hidden" id="SelectedGroupIds" name="SelectedGroupIds" />
                        </div>

                        <div class="col-md-1 control-label fiscal-year-info">
                            Fiscal Year:
                        </div>
                        <div class="col-md-3 fiscal-year-info">
                            <select type="text" class="form-control " name="FiscalYearId" id="FiscalYearId" data-api="/fiscal_year_unlocked/select"></select>
                            <input type="hidden" id="SelectedFiscalYearId" name="SelectedFiscalYearId" />
                        </div>

                        <div class="col-md-2">
                            <a href="#" onclick="supplyChainReport()" class="btn btn-success">
                                Download Supply Chain Report
                            </a>
                        </div>
                    </div>
                    <br />




                </div>
            </div>
        </div>
    </div>
</div>
<script src="~/Scripts/app/bootstrap-multiselect.js"></script>

@*<link href="https://cdn.jsdelivr.net/npm/select2@4.0.13/dist/css/select2.min.css" rel="stylesheet" />
    <script src="https://cdn.jsdelivr.net/npm/select2@4.0.13/dist/js/select2.min.js"></script>*@
<script>

    $(document).ready(function () {

        var provinceId = $('#ProvinceId');
        var districtId = $('#DistrictId');
        var commodityId = $('#CommodityId');
        debugger;
        var fiscalyearid = $('#FiscalYearId');
        var groupId = $('#GroupId');

        $('#Commodity').multiselect({
            includeSelectAllOption: true, buttonWidth: "100%", search: true, enableFiltering: true,
            enableCaseInsensitiveFiltering: true, maxHeight: 300, buttonWidth: '100%', width: 420
        });
        $('.multiselect').css('max-width', '840px');
        $('.multiselect').css('overflow', 'hidden');

        window.initializeSelectApis2();
        window.initializeCascadeLocation2();
       @* window.initializeCascadeGroupBasedOnProvinceDistrictAndCommodity();*@


        $(groupId).select2({
            multiple: true,
            allowClear: true,

            placeholder: {
                id: "",
                placeholder: ""
            },
        }).change(function () {

            $("#GroupId option[value='']").remove();
            var selectedGroupIDs = $.map($(groupId).select2('data'), function (val, i) {
                return val.id;
            }).join(",");
            $('#SelectedGroupIds').val(selectedGroupIDs);
        });

        $(fiscalyearid).select2({
            multiple: true,
            allowClear: true,

            placeholder: {
                id: "",
                placeholder: ""
            },
        }).change(function () {

            $("#FiscalYearId option[value='']").remove();
            var selectedGroupIDs = $.map($(fiscalyearid).select2('data'), function (val, i) {
                return val.id;
            }).join(",");
            $('#SelectedFiscalYearId').val(selectedGroupIDs);
        });



    })

    function getCommodities() {
        debugger;
        var a = Array.from(document.getElementById("Commodity").options).filter(option => option.selected).map(option => option.value);
        console.log("a", a)
        return a;
    }

    function exportExcel() {

        var isBaselineChecked = $('#IsBaseline').is(':checked');
        var provinceId = document.getElementById('ProvinceId').value;
        var districtId = document.getElementById('DistrictId').value;
        var municipalityId = document.getElementById('MunicipalityId').value;
        var commodityIds = document.getElementById('Commodity').value;
        var groupIds = document.getElementById('SelectedGroupIds').value;
        var fiscalYearId = document.getElementById('SelectedFiscalYearId').value;

        if (isBaselineChecked == false && fiscalYearId == "") {
            alert("Fiscal Year is Required For Farmer Diary")
            return;
        }

        //var quadrimester = document.getElementById('QuadrimesterId').value;
        window.location.href = `/report/group/overall/export?provinceId=${provinceId}&districtId=${districtId}&municapilitiesid=${municipalityId}&commodityIds=${commodityIds}&groupIds=${groupIds}&fiscalyear=${fiscalYearId}`;
    }

    function supplyChainReport() {
        debugger;
        var provinceId = document.getElementById('ProvinceId').value;
        var intProvinceId = parseInt(provinceId);
        var districtId = document.getElementById('DistrictId').value;
        var intDistrictId = parseInt(districtId);
        var municipalityId = document.getElementById('MunicipalityId').value;
        var intMunicipalityId = parseInt(municipalityId);
        debugger;
        var commodityIds = getCommodities().toString();
       @* let commodityArray = commodityIds.split(",");*@



        var groupIds = document.getElementById('SelectedGroupIds').value;
        debugger;


        var fiscalYearId = document.getElementById('SelectedFiscalYearId').value;

        window.location.href = `/report/group/supply_chain/export?provinceid=${intProvinceId}&districtid=${intDistrictId}&municapilitiesid=${intMunicipalityId}&fiscalid=${fiscalYearId}&commodityids=${commodityIds}&groupname=${groupIds}`;


        clearfiltervalue();
    }

    function memberReport() {
        debugger;
        var provinceId = document.getElementById('ProvinceId').value;
        var intProvinceId = parseInt(provinceId);
        var districtId = document.getElementById('DistrictId').value;
        var intDistrictId = parseInt(districtId);
        var municipalityId = document.getElementById('MunicipalityId').value;
        var intMunicipalityId = parseInt(municipalityId);
        debugger;
        var commodityIds = getCommodities().toString();
        @* let commodityArray = commodityIds.split(",");*@



        var groupIds = document.getElementById('SelectedGroupIds').value;
        debugger;


        var fiscalYearId = document.getElementById('SelectedFiscalYearId').value;

        window.location.href = `/report/group/member/export?provinceid=${intProvinceId}&districtid=${intDistrictId}&municapilitiesid=${intMunicipalityId}&fiscalid=${fiscalYearId}&commodityids=${commodityIds}&groupname=${groupIds}`;


        clearfiltervalue();
    }



    function clearfiltervalue() {
        $('#ProvinceId').val('');
        $('#DistrictId').val('');
        $('#MunicipalityId').val('');
        debugger;
        $('#Commodity').multiselect('deselectAll', false);

        $('#FiscalYearId').val(null).trigger('change');
        $('#GroupId').val(null).trigger('change');

        debugger;

    }



</script>


<style>

    input[type=checkbox] {
        transform: scale(1.5);
    }
</style>