Mr.Combet Webshell 🔥

View File Name : GetGALSBIReport.cshtml


@{
    ViewBag.Title = "GALS BI Report";
}


    <div class="wrapper wrapper-content animated fadeInRight" style="padding:0px">
        <div class="row wrapper border-bottom white-bg page-heading">
            <div class="col-md-12">
                <ol class="breadcrumb">
                    <li class="active">
                        <strong>GALS BI Dashboard</strong>
                    </li>
                </ol>

            </div>
        </div>
        <br />
        <div class="row">
            <div class="col-lg-12">

                <div class="ibox float-e-margins">
                    <button type="button" class="btn btn-primary" onclick="tableToExcel('pvtTable','PivotDownload')">
                        <i class="fa fa-file-excel-o" aria-hidden="true"></i>&nbsp;&nbsp;Download Data
                    </button>
                </div>
            </div>
        </div>


        <div class="row">
            <div class="col-lg-12">

                <div class="ibox float-e-margins">
                    <div id="output" style="margin: 10px;"></div>
                </div>
            </div>
        </div>
    </div>




<script src="~/Content/plugins/pivotTable/jquery-1.8.3.min.js"></script>
<script src="~/Content/plugins/pivotTable/jquery-ui-1.9.2.custom.min.js"></script>
<script src="~/Content/plugins/pivotTable/pivot.js"></script>

<script type="text/javascript">

    $(document).ready(function () {
        loadBIReportGroupAndAgeWise();
    })

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

        function request() {

            const url = '/report/bi/gals/data';

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


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


        });

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

    function setToPivotTable(response) {

        $("#output").pivotUI(
            response,
            {
                rows: ["MigrantStatus", "AgeGroup"],
                cols: ["Ethnicity", "Origin"]
            }
        );
    }


    var tableToExcel = (function () {
        var uri = 'data:application/vnd.ms-excel;base64,'
            , template = '<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"><head><style> table, td {border:2em solid black;padding:20px !important;border-spacing: 10px}table {border-collapse:collapse}</style> <!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head><body><table>{table}</table></body></html>'
            , base64 = function (s) { return window.btoa(unescape(encodeURIComponent(s))) }
            , format = function (s, c) { return s.replace(/{(\w+)}/g, function (m, p) { return c[p]; }) }
        return function (table, name) {
            debugger;
            if (!table.nodeType) table = document.getElementsByClassName(table)[0]
            var ctx = { worksheet: name || 'Worksheet', table: table.innerHTML }
            window.location.href = uri + base64(format(template, ctx))
        }
    })()


</script>

<style>


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

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