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="/province/select/threeStates"></select>
                        </div>

                        <div class="col-md-1 control-label">
                            District:
                        </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">
                            Commodity:
                        </div>
                        <div class="col-md-5">
                            <select type="text" class="form-control required" name="CommodityId" id="CommodityId" data-api="/commodity/select"></select>
                            <input type="hidden" id="SelectedCommodityIds" name="SelectedCommodityIds" />
                        </div>
                    </div>
                    <div class="form-group">
                        <br />
                        <div class="col-md-1 control-label">
                            Group:
                        </div>
                        <div class="col-md-5">
                            <select type="text" class="form-control required" name="GroupId" id="GroupId" data-api="/groups/select"></select>
                            <input type="hidden" id="SelectedGroupIds" name="SelectedGroupIds" />
                        </div>

                        <div class="col-md-1">
                            <label>
                                <input type="checkbox" name="IsBaseline" id="IsBaseline" /><b>&nbsp;
                                Baseline</b>
                            </label>
                        </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>
                        </div>

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



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

<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');
        var groupId = $('#GroupId');

          window.initializeSelectApis();


        window.initializeCascadeGroupBasedOnProvinceDistrictAndCommodity();

    

        $(commodityId).select2({
            multiple: true,
            allowClear: true,
        }).change(function () {
            var selectedCommodityIDs = $.map($(commodityId).select2('data'), function (val, i) {
                return val.id;
            }).join(",");
            $('#SelectedCommodityIds').val(selectedCommodityIDs);
        });

         $(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);
        });



    })

    function exportExcel() {

        var isBaselineChecked = $('#IsBaseline').is(':checked');
         var provinceId = document.getElementById('ProvinceId').value;
        var districtId = document.getElementById('DistrictId').value;
        var commodityIds = document.getElementById('SelectedCommodityIds').value;
        var groupIds = document.getElementById('SelectedGroupIds').value;
        var fiscalYearId = document.getElementById('FiscalYearId').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}&commodityIds=${commodityIds}&groupIds=${groupIds}&fiscalyear=${fiscalYearId}`;
    }

    function supplyChainReport() {
        window.location.href = `/report/group/supply/export`;
    }

        $("#IsBaseline").click(function () {
        if ($(this).is(":checked")) {
            $(".fiscal-year-info").hide();
            $("#FiscalYearId").val("");

        } else {
            $(".fiscal-year-info").show();

        }
    });
    

</script>


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


</style>