<%@ Page Language="C#" AutoEventWireup="true" CodeFile="feeheadwisereport.aspx.cs" MasterPageFile="~/module/dashboardPage.master" Inherits="module_feeheadwisereport" %>

<asp:Content ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
    <script type="text/javascript">
        $(document).ready(function () {
            let today2 = new Date().toISOString().substr(0, 10);
                     
            document.querySelector("#incomedate").value = today2;
            let today3 = new Date().toISOString().substr(0, 10);
                     
            document.querySelector("#incomedate1").value = today3;
            $.ajax({
                type: "POST",
                contentType: "application/json; charset=utf-8",
                url: "feeheadwisereport.aspx/PopulateDropDownList4",
                data: "",
                dataType: "json",
                success: function (result) {
                    $('select[id$=ddlyears]').empty();
                    $('select[id$=ddlyears]').append("<option value='0'>Select Year</option>");
                    $.each(result.d, function (key, value) {
                        var ddyear1 = value.DeptName;
                        var ddyear2 = value.year1;
                        var dtyear1 = new Date(ddyear1);
                        var dtyear2 = new Date(ddyear2);
                        var stryr = dtyear1.getFullYear() + "-" + dtyear2.getFullYear();

                        $('select[id$=ddlyears]').append($("<option data-toggle='tooltip' data-placement='top' title='" + stryr + "'></option>").val(value.DeptId).html(stryr));
                        //console.log(value.DeptName);
                    });
                    $('select[id$=ddlyears]').val('0').change();
                    //$('select[id$=cat] option:eq(0)').attr("selected", true);
                    //  $('select[id$=ddlclassty]').selectpicker('refresh');
                    //  hdndoc=$('select[id$=cat] option:eq(1)').val();
                },
                error: function ajaxError(result) {
                    console.log(result.status + ' : ' + result.statusText);
                }

            }); 
            $('select[id$=ddlyears]').change(function () {
                $.ajax({
                    type: "POST",
                    contentType: "application/json; charset=utf-8",
                    url: "feeheadwisereport.aspx/PopulateDropDownList15",
                    data: "",
                    dataType: "json",
                    success: function (result) {
                        $('select[id$=ddlclass]').empty();
                        $('select[id$=ddlclass]').append("<option value='0'>Select class</option>");
                        $.each(result.d, function (key, value) {
                            var dd = value.DeptName;


                            $('select[id$=ddlclass]').append($("<option data-toggle='tooltip' data-placement='top' title='" + dd + "'></option>").val(value.DeptId).html(dd));
                            //console.log(value.DeptName);
                        });
                        $('select[id$=ddlclass]').val('0').change();
                        //$('select[id$=cat] option:eq(0)').attr("selected", true);
                        //  $('select[id$=ddlclassty]').selectpicker('refresh');
                        //  hdndoc=$('select[id$=cat] option:eq(1)').val();
                    },
                    error: function ajaxError(result) {
                        console.log(result.status + ' : ' + result.statusText);
                    }

                });
            }); 
            $('select[id$=ddlclass]').change(function () {
                $.ajax({
                    type: "POST",
                    contentType: "application/json; charset=utf-8",
                    url: "feeheadwisereport.aspx/PopulateDropDownList6",
                    data: "{clids :'" + $('select[id$=ddlclass]').val() + "'}",
                    dataType: "json",
                    success: function (result) {
                        $('select[id$=ddldivision]').empty();
                        $('select[id$=ddldivision]').append("<option value='0'>Select Division</option>");
                        $.each(result.d, function (key, value) {
                            var dd = value.DeptName;


                            $('select[id$=ddldivision]').append($("<option data-toggle='tooltip' data-placement='top' title='" + dd + "'></option>").val(value.DeptId).html(dd));
                            //console.log(value.DeptName);
                        });
                     $('select[id$=ddldivisions]').val('0').change();
                        //$('select[id$=cat] option:eq(0)').attr("selected", true);
                        //  $('select[id$=ddlclassty]').selectpicker('refresh');
                        //  hdndoc=$('select[id$=cat] option:eq(1)').val();
                    },
                    error: function ajaxError(result) {
                        console.log(result.status + ' : ' + result.statusText);
                    }

                });
            }); 
        });
        function GetData() {
            var totalpaid = 0;
            var total = 0;
            var remainsamt = 0;
            var totalremainsamt = 0;


            $.ajax({
                url: "feeheadwisereport.aspx/Getdata",
                method: "post",
                contentType: "application/json; charset=utf-8",
                data: "{pdate:'" + $('#incomedate').val() + "',pdate1:'" + $("#incomedate1").val() + "', incomeid:'" + $("select[id$=ddlincome]").val() + "',yrsid : '"+ $('select[id$=ddlyears]').val() +"',divid :'"+ $('select[id$=ddldivision]').val() +"',clsid :'"+ $('select[id$=ddlclass]').val() +"',paymodes : '"+ $("select[id$=ddlpaymode]").val() +"'}",
                dataType: "json",
                success: function (data) {


                    console.log(data.d);
                    if($("select[id$=ddlincome]").val() == "tuitionfee"){
                    //$("#dataemp").find("tbody").empty();
                    // $("#dataemp").find("tbody").empty();

                    table = $('#dataemp').DataTable();
                    table.destroy(); 
                    if (data.d != "") {
                        data = JSON.parse(data.d);
                  
                        $("#tbltutions1").hide();$("#tbltutions2").hide();  $("#tbltutions3").hide();$("#tbltutions4").hide();$("#tbltutions5").hide(); $("#tbltutions6").hide();$("#tbltutions7").hide();  $("#tbltutions8").hide();$("#tbltutions9").hide();$("#tbltutions10").hide(); $("#tbltutions11").hide();$("#tbltutions12").hide();  $("#tbltutions13").hide();$("#tbltutions14").hide();$("#tbltutions15").hide();
                        
                        $("#tbltutions").show();
                        var table = $('#dataemp').DataTable({
                            "aaSorting": [[0, "desc"]],
                            //"ordering": false,
                            "pageLength": 10,
                            "columns": [
                                     { "width": "5%" },
                                     { "width": "8%" },
                                     { "width": "10%" },
                                      { "width": "10%" },
                                     { "width": "14%" },
                                     { "width": "10%" },
                                     { "width": "7%" },
                                     { "width": "6%" },
                                     { "width": "10%" },
                                   

                            ]
                        });
                 
                        $('#dataemp').DataTable().clear().draw();
                        for (var i = 0; i < data.length ; i++) {
                       
                            fullname = data[i].title + "." + data[i].fname + " " + data[i].mname + " " + data[i].lname;
                            // totalremainsamt = totalremainsamt + parseFloat(data[i].amount);
                            var ddyear1 = data[i].fromdate;
                            var ddyear2 = data[i].todate;
                            var dtyear1 = new Date(ddyear1);
                            var dtyear2 = new Date(ddyear2);
                            var stryr = dtyear1.getFullYear() + "-" + dtyear2.getFullYear();
                            table.row.add([
                              data[i].studid, fullname, stryr,data[i].class, data[i].division, data[i].totaltution, data[i].paymentdt,data[i].paymode, data[i].chequenos
                            ]).draw(false);
                            total = total + parseFloat(data[i].totaltution);

                        }
                        if (total > 0) {
                            $("#totalamt").html(total);
                        }
                    } 
                    else{
                        table = $('#dataemp').DataTable();
                        table.destroy();
                        clear();
                        $('#dataemp').DataTable().clear().draw();
                        noty({ text: 'No Records Found!!', layout: 'topRight', type: 'information' });
                        setTimeout(function () { $.noty.closeAll(); }, 3000);
                    }
                        } 
                    else  if($("select[id$=ddlincome]").val() == "admissionfee"){
                        total = 0;
                        table = $('#dataemp1').DataTable();
                        table.destroy(); 
                        if (data.d != "") {
                            data = JSON.parse(data.d);
                            $("#tbltutions").hide();$("#tbltutions2").hide();  $("#tbltutions3").hide();$("#tbltutions4").hide();$("#tbltutions5").hide(); $("#tbltutions6").hide();$("#tbltutions7").hide();  $("#tbltutions8").hide();$("#tbltutions9").hide();$("#tbltutions10").hide(); $("#tbltutions11").hide();$("#tbltutions12").hide();  $("#tbltutions13").hide();$("#tbltutions14").hide();$("#tbltutions15").hide();
                            $("#tbltutions1").show();
                            var table = $('#dataemp1').DataTable({
                                "aaSorting": [[0, "desc"]],
                                //"ordering": false,
                                "pageLength": 10,
                                "columns": [
                                         { "width": "5%" },
                                         { "width": "8%" },
                                         { "width": "10%" },
                                          { "width": "10%" },
                                         { "width": "14%" },
                                         { "width": "10%" },
                                         { "width": "7%" },
                                         { "width": "6%" },
                                         { "width": "10%" },
                                   

                                ]
                            });
                 
                            $('#dataemp1').DataTable().clear().draw();
                            for (var i = 0; i < data.length ; i++) {
                       
                                fullname = data[i].title + "." + data[i].fname + " " + data[i].mname + " " + data[i].lname;
                                // totalremainsamt = totalremainsamt + parseFloat(data[i].amount);
                                var ddyear1 = data[i].fromdate;
                                var ddyear2 = data[i].todate;
                                var dtyear1 = new Date(ddyear1);
                                var dtyear2 = new Date(ddyear2);
                                var stryr = dtyear1.getFullYear() + "-" + dtyear2.getFullYear();
                                table.row.add([
                                  data[i].studid, fullname, stryr,data[i].class, data[i].division, data[i].totaltution, data[i].paymentdt,data[i].paymode, data[i].chequenos
                                ]).draw(false);
                                total = total + parseFloat(data[i].totaltution);

                            }
                            if (total > 0) {
                                $("#totalamt").html(total);
                            }
                        } 
                        else{
                            table = $('#dataemp1').DataTable();
                            table.destroy();
                            clear();
                            $('#dataemp1').DataTable().clear().draw();
                            noty({ text: 'No Records Found!!', layout: 'topRight', type: 'information' });
                            setTimeout(function () { $.noty.closeAll(); }, 3000);
                        }
                       } 
                    else  if($("select[id$=ddlincome]").val() == "cautionmny"){
                        total = 0;
                        table = $('#dataemp2').DataTable();
                        table.destroy(); 
                        if (data.d != "") {
                            data = JSON.parse(data.d);
                            $("#tbltutions").hide();$("#tbltutions1").hide();  $("#tbltutions3").hide();$("#tbltutions4").hide();$("#tbltutions5").hide(); $("#tbltutions6").hide();$("#tbltutions7").hide();  $("#tbltutions8").hide();$("#tbltutions9").hide();$("#tbltutions10").hide(); $("#tbltutions11").hide();$("#tbltutions12").hide();  $("#tbltutions13").hide();$("#tbltutions14").hide();$("#tbltutions15").hide();
                            $("#tbltutions2").show();
                            var table = $('#dataemp2').DataTable({
                                "aaSorting": [[0, "desc"]],
                                //"ordering": false,
                                "pageLength": 10,
                                "columns": [
                                         { "width": "5%" },
                                         { "width": "8%" },
                                         { "width": "10%" },
                                          { "width": "10%" },
                                         { "width": "14%" },
                                         { "width": "10%" },
                                         { "width": "7%" },
                                         { "width": "6%" },
                                         { "width": "10%" },
                                   

                                ]
                            });
                 
                            $('#dataemp2').DataTable().clear().draw();
                            for (var i = 0; i < data.length ; i++) {
                       
                                fullname = data[i].title + "." + data[i].fname + " " + data[i].mname + " " + data[i].lname;
                                // totalremainsamt = totalremainsamt + parseFloat(data[i].amount);
                                var ddyear1 = data[i].fromdate;
                                var ddyear2 = data[i].todate;
                                var dtyear1 = new Date(ddyear1);
                                var dtyear2 = new Date(ddyear2);
                                var stryr = dtyear1.getFullYear() + "-" + dtyear2.getFullYear();
                                table.row.add([
                                  data[i].studid, fullname, stryr,data[i].class, data[i].division, data[i].totaltution, data[i].paymentdt,data[i].paymode, data[i].chequenos
                                ]).draw(false);
                                total = total + parseFloat(data[i].totaltution);

                            }
                            if (total > 0) {
                                $("#totalamt").html(total);
                            }
                        }
                        else{
                            table = $('#dataemp2').DataTable();
                            table.destroy();
                            clear();
                            $('#dataemp2').DataTable().clear().draw();
                            noty({ text: 'No Records Found!!', layout: 'topRight', type: 'information' });
                            setTimeout(function () { $.noty.closeAll(); }, 3000);
                        }
                       }
                    else  if($("select[id$=ddlincome]").val() == "collegefee"){ total = 0;
                        table = $('#dataemp3').DataTable();
                        table.destroy(); 
                        if (data.d != "") {
                            data = JSON.parse(data.d);
                            $("#tbltutions").hide();$("#tbltutions1").hide();  $("#tbltutions2").hide();$("#tbltutions4").hide();$("#tbltutions5").hide(); $("#tbltutions6").hide();$("#tbltutions7").hide();  $("#tbltutions8").hide();$("#tbltutions9").hide();$("#tbltutions10").hide(); $("#tbltutions11").hide();$("#tbltutions12").hide();  $("#tbltutions13").hide();$("#tbltutions14").hide();$("#tbltutions15").hide();
                            $("#tbltutions3").show();
                            var table = $('#dataemp3').DataTable({
                                "aaSorting": [[0, "desc"]],
                                //"ordering": false,
                                "pageLength": 10,
                                "columns": [
                                         { "width": "5%" },
                                         { "width": "8%" },
                                         { "width": "10%" },
                                          { "width": "10%" },
                                         { "width": "14%" },
                                         { "width": "10%" },
                                         { "width": "7%" },
                                         { "width": "6%" },
                                         { "width": "10%" },
                                   

                                ]
                            });
                 
                            $('#dataemp3').DataTable().clear().draw();
                            for (var i = 0; i < data.length ; i++) {
                       
                                fullname = data[i].title + "." + data[i].fname + " " + data[i].mname + " " + data[i].lname;
                                // totalremainsamt = totalremainsamt + parseFloat(data[i].amount);
                                var ddyear1 = data[i].fromdate;
                                var ddyear2 = data[i].todate;
                                var dtyear1 = new Date(ddyear1);
                                var dtyear2 = new Date(ddyear2);
                                var stryr = dtyear1.getFullYear() + "-" + dtyear2.getFullYear();
                                table.row.add([
                                  data[i].studid, fullname, stryr,data[i].class, data[i].division, data[i].totaltution, data[i].paymentdt,data[i].paymode, data[i].chequenos
                                ]).draw(false);
                                total = total + parseFloat(data[i].totaltution);

                            }
                            if (total > 0) {
                                $("#totalamt").html(total);
                            }
                        } 
                        else{
                            table = $('#dataemp3').DataTable();
                            table.destroy();
                            clear();
                            $('#dataemp3').DataTable().clear().draw();
                            noty({ text: 'No Records Found!!', layout: 'topRight', type: 'information' });
                            setTimeout(function () { $.noty.closeAll(); }, 3000);
                        }
                        } 
                    else  if($("select[id$=ddlincome]").val() == "identycrdfee"){ total = 0;
                        table = $('#dataemp4').DataTable();
                        table.destroy(); 
                        if (data.d != "") {
                            data = JSON.parse(data.d);
                            $("#tbltutions").hide();$("#tbltutions1").hide();  $("#tbltutions2").hide();$("#tbltutions3").hide();$("#tbltutions5").hide(); $("#tbltutions6").hide();$("#tbltutions7").hide();  $("#tbltutions8").hide();$("#tbltutions9").hide();$("#tbltutions10").hide(); $("#tbltutions11").hide();$("#tbltutions12").hide();  $("#tbltutions13").hide();$("#tbltutions14").hide();$("#tbltutions15").hide();
                            $("#tbltutions4").show();
                            var table = $('#dataemp4').DataTable({
                                "aaSorting": [[0, "desc"]],
                                //"ordering": false,
                                "pageLength": 10,
                                "columns": [
                                         { "width": "5%" },
                                         { "width": "8%" },
                                         { "width": "10%" },
                                          { "width": "10%" },
                                         { "width": "14%" },
                                         { "width": "10%" },
                                         { "width": "7%" },
                                         { "width": "6%" },
                                         { "width": "10%" },
                                   

                                ]
                            });
                 
                            $('#dataemp4').DataTable().clear().draw();
                            for (var i = 0; i < data.length ; i++) {
                       
                                fullname = data[i].title + "." + data[i].fname + " " + data[i].mname + " " + data[i].lname;
                                // totalremainsamt = totalremainsamt + parseFloat(data[i].amount);
                                var ddyear1 = data[i].fromdate;
                                var ddyear2 = data[i].todate;
                                var dtyear1 = new Date(ddyear1);
                                var dtyear2 = new Date(ddyear2);
                                var stryr = dtyear1.getFullYear() + "-" + dtyear2.getFullYear();
                                table.row.add([
                                  data[i].studid, fullname, stryr,data[i].class, data[i].division, data[i].totaltution, data[i].paymentdt,data[i].paymode, data[i].chequenos
                                ]).draw(false);
                                total = total + parseFloat(data[i].totaltution);

                            }
                            if (total > 0) {
                                $("#totalamt").html(total);
                            }
                        }
                        
                        else{
                            table = $('#dataemp4').DataTable();
                            table.destroy();
                            clear();
                            $('#dataemp4').DataTable().clear().draw();
                            noty({ text: 'No Records Found!!', layout: 'topRight', type: 'information' });
                            setTimeout(function () { $.noty.closeAll(); }, 3000);
                        }
                        } 
                    else  if($("select[id$=ddlincome]").val() == "insurance"){ total = 0;
                        table = $('#dataemp5').DataTable();
                        table.destroy(); 
                        if (data.d != "") {
                            data = JSON.parse(data.d);
                            $("#tbltutions").hide();$("#tbltutions1").hide();  $("#tbltutions2").hide();$("#tbltutions3").hide();$("#tbltutions4").hide(); $("#tbltutions6").hide();$("#tbltutions7").hide();  $("#tbltutions8").hide();$("#tbltutions9").hide();$("#tbltutions10").hide(); $("#tbltutions11").hide();$("#tbltutions12").hide();  $("#tbltutions13").hide();$("#tbltutions14").hide();$("#tbltutions15").hide();
                            $("#tbltutions5").show();
                            var table = $('#dataemp5').DataTable({
                                "aaSorting": [[0, "desc"]],
                                //"ordering": false,
                                "pageLength": 10,
                                "columns": [
                                         { "width": "5%" },
                                         { "width": "8%" },
                                         { "width": "10%" },
                                          { "width": "10%" },
                                         { "width": "14%" },
                                         { "width": "10%" },
                                         { "width": "7%" },
                                         { "width": "6%" },
                                         { "width": "10%" },
                                   

                                ]
                            });
                 
                            $('#dataemp5').DataTable().clear().draw();
                            for (var i = 0; i < data.length ; i++) {
                       
                                fullname = data[i].title + "." + data[i].fname + " " + data[i].mname + " " + data[i].lname;
                                // totalremainsamt = totalremainsamt + parseFloat(data[i].amount);
                                var ddyear1 = data[i].fromdate;
                                var ddyear2 = data[i].todate;
                                var dtyear1 = new Date(ddyear1);
                                var dtyear2 = new Date(ddyear2);
                                var stryr = dtyear1.getFullYear() + "-" + dtyear2.getFullYear();
                                table.row.add([
                                  data[i].studid, fullname, stryr,data[i].class, data[i].division, data[i].totaltution, data[i].paymentdt,data[i].paymode, data[i].chequenos
                                ]).draw(false);
                                total = total + parseFloat(data[i].totaltution);

                            }
                            if (total > 0) {
                                $("#totalamt").html(total);
                            }
                        } 
                        else{
                            table = $('#dataemp5').DataTable();
                            table.destroy();
                            clear();
                            $('#dataemp5').DataTable().clear().draw();
                            noty({ text: 'No Records Found!!', layout: 'topRight', type: 'information' });
                            setTimeout(function () { $.noty.closeAll(); }, 3000);
                        }
                        } 
                    else  if($("select[id$=ddlincome]").val() == "unifees"){ total = 0;
                        table = $('#dataemp6').DataTable();
                        table.destroy(); 
                        if (data.d != "") {
                            data = JSON.parse(data.d);
                            $("#tbltutions").hide();$("#tbltutions1").hide();  $("#tbltutions2").hide();$("#tbltutions3").hide();$("#tbltutions4").hide(); $("#tbltutions5").hide();$("#tbltutions7").hide();  $("#tbltutions8").hide();$("#tbltutions9").hide();$("#tbltutions10").hide(); $("#tbltutions11").hide();$("#tbltutions12").hide();  $("#tbltutions13").hide();$("#tbltutions14").hide();$("#tbltutions15").hide();
                            $("#tbltutions6").show();
                            var table = $('#dataemp6').DataTable({
                                "aaSorting": [[0, "desc"]],
                                //"ordering": false,
                                "pageLength": 10,
                                "columns": [
                                         { "width": "5%" },
                                         { "width": "8%" },
                                         { "width": "10%" },
                                          { "width": "10%" },
                                         { "width": "14%" },
                                         { "width": "10%" },
                                         { "width": "7%" },
                                         { "width": "6%" },
                                         { "width": "10%" },
                                   

                                ]
                            });
                 
                            $('#dataemp6').DataTable().clear().draw();
                            for (var i = 0; i < data.length ; i++) {
                       
                                fullname = data[i].title + "." + data[i].fname + " " + data[i].mname + " " + data[i].lname;
                                // totalremainsamt = totalremainsamt + parseFloat(data[i].amount);
                                var ddyear1 = data[i].fromdate;
                                var ddyear2 = data[i].todate;
                                var dtyear1 = new Date(ddyear1);
                                var dtyear2 = new Date(ddyear2);
                                var stryr = dtyear1.getFullYear() + "-" + dtyear2.getFullYear();
                                table.row.add([
                                  data[i].studid, fullname, stryr,data[i].class, data[i].division, data[i].totaltution, data[i].paymentdt,data[i].paymode, data[i].chequenos
                                ]).draw(false);
                                total = total + parseFloat(data[i].totaltution);

                            }
                            if (total > 0) {
                                $("#totalamt").html(total);
                            }
                        }
                        else{
                            table = $('#dataemp6').DataTable();
                            table.destroy();
                            clear();
                            $('#dataemp6').DataTable().clear().draw();
                            noty({ text: 'No Records Found!!', layout: 'topRight', type: 'information' });
                            setTimeout(function () { $.noty.closeAll(); }, 3000);
                        }
                        } 
                    else  if($("select[id$=ddlincome]").val() == "busfee"){ total = 0;
                            table = $('#dataemp7').DataTable();
                            table.destroy(); 
                            if (data.d != "") {
                                data = JSON.parse(data.d);
                                $("#tbltutions").hide();$("#tbltutions1").hide();  $("#tbltutions2").hide();$("#tbltutions3").hide();$("#tbltutions5").hide(); $("#tbltutions6").hide();$("#tbltutions4").hide();  $("#tbltutions8").hide();$("#tbltutions9").hide();$("#tbltutions10").hide(); $("#tbltutions11").hide();$("#tbltutions12").hide();  $("#tbltutions13").hide();$("#tbltutions14").hide();$("#tbltutions15").hide();
                                $("#tbltutions7").show();
                                var table = $('#dataemp7').DataTable({
                                    "aaSorting": [[0, "desc"]],
                                    //"ordering": false,
                                    "pageLength": 10,
                                    "columns": [
                                             { "width": "5%" },
                                             { "width": "8%" },
                                             { "width": "10%" },
                                              { "width": "10%" },
                                             { "width": "14%" },
                                             { "width": "10%" },
                                             { "width": "7%" },
                                             { "width": "6%" },
                                             { "width": "10%" },
                                   

                                    ]
                                });
                 
                                $('#dataemp7').DataTable().clear().draw();
                                for (var i = 0; i < data.length ; i++) {
                       
                                    fullname = data[i].title + "." + data[i].fname + " " + data[i].mname + " " + data[i].lname;
                                    // totalremainsamt = totalremainsamt + parseFloat(data[i].amount);
                                    var ddyear1 = data[i].fromdate;
                                    var ddyear2 = data[i].todate;
                                    var dtyear1 = new Date(ddyear1);
                                    var dtyear2 = new Date(ddyear2);
                                    var stryr = dtyear1.getFullYear() + "-" + dtyear2.getFullYear();
                                    table.row.add([
                                      data[i].studid, fullname, stryr,data[i].class, data[i].division, data[i].totaltution, data[i].paymentdt,data[i].paymode, data[i].chequenos
                                    ]).draw(false);
                                    total = total + parseFloat(data[i].totaltution);

                                }
                                if (total > 0) {
                                    $("#totalamt").html(total);
                                }
                            }
                            else{
                                table = $('#dataemp7').DataTable();
                                table.destroy();
                                clear();
                                $('#dataemp7').DataTable().clear().draw();
                                noty({ text: 'No Records Found!!', layout: 'topRight', type: 'information' });
                                setTimeout(function () { $.noty.closeAll(); }, 3000);
                            }
                        } 
                    else  if($("select[id$=ddlincome]").val() == "eligibilityfee"){ total = 0;
                                table = $('#dataemp8').DataTable();
                                table.destroy(); 
                                if (data.d != "") {
                                    data = JSON.parse(data.d);
                                    $("#tbltutions").hide();$("#tbltutions1").hide();  $("#tbltutions2").hide();$("#tbltutions3").hide();$("#tbltutions5").hide(); $("#tbltutions6").hide();$("#tbltutions7").hide();  $("#tbltutions4").hide();$("#tbltutions9").hide();$("#tbltutions10").hide(); $("#tbltutions11").hide();$("#tbltutions12").hide();  $("#tbltutions13").hide();$("#tbltutions14").hide();$("#tbltutions15").hide();
                                    $("#tbltutions8").show();
                                    var table = $('#dataemp8').DataTable({
                                        "aaSorting": [[0, "desc"]],
                                        //"ordering": false,
                                        "pageLength": 10,
                                        "columns": [
                                                 { "width": "5%" },
                                                 { "width": "8%" },
                                                 { "width": "10%" },
                                                  { "width": "10%" },
                                                 { "width": "14%" },
                                                 { "width": "10%" },
                                                 { "width": "7%" },
                                                 { "width": "6%" },
                                                 { "width": "10%" },
                                   

                                        ]
                                    });
                 
                                    $('#dataemp8').DataTable().clear().draw();
                                    for (var i = 0; i < data.length ; i++) {
                       
                                        fullname = data[i].title + "." + data[i].fname + " " + data[i].mname + " " + data[i].lname;
                                        // totalremainsamt = totalremainsamt + parseFloat(data[i].amount);
                                        var ddyear1 = data[i].fromdate;
                                        var ddyear2 = data[i].todate;
                                        var dtyear1 = new Date(ddyear1);
                                        var dtyear2 = new Date(ddyear2);
                                        var stryr = dtyear1.getFullYear() + "-" + dtyear2.getFullYear();
                                        table.row.add([
                                          data[i].studid, fullname, stryr,data[i].class, data[i].division, data[i].totaltution, data[i].paymentdt,data[i].paymode, data[i].chequenos
                                        ]).draw(false);
                                        total = total + parseFloat(data[i].totaltution);

                                    }
                                    if (total > 0) {
                                        $("#totalamt").html(total);
                                    } 
                                }
                                else{
                                    table = $('#dataemp8').DataTable();
                                    table.destroy();
                                    clear();
                                    $('#dataemp8').DataTable().clear().draw();
                                    noty({ text: 'No Records Found!!', layout: 'topRight', type: 'information' });
                                    setTimeout(function () { $.noty.closeAll(); }, 3000);
                                }
                        } 
                    else  if($("select[id$=ddlincome]").val() == "exminfee"){ total = 0;
                                    table = $('#dataemp9').DataTable();
                                    table.destroy(); 
                                    if (data.d != "") {
                                        data = JSON.parse(data.d);
                                        $("#tbltutions").hide();$("#tbltutions1").hide();  $("#tbltutions2").hide();$("#tbltutions3").hide();$("#tbltutions5").hide(); $("#tbltutions6").hide();$("#tbltutions7").hide();  $("#tbltutions8").hide();$("#tbltutions4").hide();$("#tbltutions10").hide(); $("#tbltutions11").hide();$("#tbltutions12").hide();  $("#tbltutions13").hide();$("#tbltutions14").hide();$("#tbltutions15").hide();
                                        $("#tbltutions9").show();
                                        var table = $('#dataemp9').DataTable({
                                            "aaSorting": [[0, "desc"]],
                                            //"ordering": false,
                                            "pageLength": 10,
                                            "columns": [
                                                     { "width": "5%" },
                                                     { "width": "8%" },
                                                     { "width": "10%" },
                                                      { "width": "10%" },
                                                     { "width": "14%" },
                                                     { "width": "10%" },
                                                     { "width": "7%" },
                                                     { "width": "6%" },
                                                     { "width": "10%" },
                                   

                                            ]
                                        });
                 
                                        $('#dataemp9').DataTable().clear().draw();
                                        for (var i = 0; i < data.length ; i++) {
                       
                                            fullname = data[i].title + "." + data[i].fname + " " + data[i].mname + " " + data[i].lname;
                                            // totalremainsamt = totalremainsamt + parseFloat(data[i].amount);
                                            var ddyear1 = data[i].fromdate;
                                            var ddyear2 = data[i].todate;
                                            var dtyear1 = new Date(ddyear1);
                                            var dtyear2 = new Date(ddyear2);
                                            var stryr = dtyear1.getFullYear() + "-" + dtyear2.getFullYear();
                                            table.row.add([
                                              data[i].studid, fullname, stryr,data[i].class, data[i].division, data[i].totaltution, data[i].paymentdt,data[i].paymode, data[i].chequenos
                                            ]).draw(false);
                                            total = total + parseFloat(data[i].totaltution);

                                        }
                                        if (total > 0) {
                                            $("#totalamt").html(total);
                                        } 
                                    }
                                    else{
                                        table = $('#dataemp9').DataTable();
                                        table.destroy();
                                        clear();
                                        $('#dataemp9').DataTable().clear().draw();
                                        noty({ text: 'No Records Found!!', layout: 'topRight', type: 'information' });
                                        setTimeout(function () { $.noty.closeAll(); }, 3000);
                                    }
                        } 
                    else  if($("select[id$=ddlincome]").val() == "enrollfee"){ total = 0;
                                        table = $('#dataemp10').DataTable();
                                        table.destroy(); 
                                        if (data.d != "") {
                                            data = JSON.parse(data.d);
                                            $("#tbltutions").hide();$("#tbltutions1").hide();  $("#tbltutions2").hide();$("#tbltutions3").hide();$("#tbltutions5").hide(); $("#tbltutions6").hide();$("#tbltutions7").hide();  $("#tbltutions8").hide();$("#tbltutions9").hide();$("#tbltutions4").hide(); $("#tbltutions11").hide();$("#tbltutions12").hide();  $("#tbltutions13").hide();$("#tbltutions14").hide();$("#tbltutions15").hide();
                                            $("#tbltutions10").show();
                                            var table = $('#dataemp10').DataTable({
                                                "aaSorting": [[0, "desc"]],
                                                //"ordering": false,
                                                "pageLength": 10,
                                                "columns": [
                                                         { "width": "5%" },
                                                         { "width": "8%" },
                                                         { "width": "10%" },
                                                          { "width": "10%" },
                                                         { "width": "14%" },
                                                         { "width": "10%" },
                                                         { "width": "7%" },
                                                         { "width": "6%" },
                                                         { "width": "10%" },
                                   

                                                ]
                                            });
                 
                                            $('#dataemp10').DataTable().clear().draw();
                                            for (var i = 0; i < data.length ; i++) {
                       
                                                fullname = data[i].title + "." + data[i].fname + " " + data[i].mname + " " + data[i].lname;
                                                // totalremainsamt = totalremainsamt + parseFloat(data[i].amount);
                                                var ddyear1 = data[i].fromdate;
                                                var ddyear2 = data[i].todate;
                                                var dtyear1 = new Date(ddyear1);
                                                var dtyear2 = new Date(ddyear2);
                                                var stryr = dtyear1.getFullYear() + "-" + dtyear2.getFullYear();
                                                table.row.add([
                                                  data[i].studid, fullname, stryr,data[i].class, data[i].division, data[i].totaltution, data[i].paymentdt,data[i].paymode, data[i].chequenos
                                                ]).draw(false);
                                                total = total + parseFloat(data[i].totaltution);

                                            }
                                            if (total > 0) {
                                                $("#totalamt").html(total);
                                            } 
                                        }
                                        else{
                                            table = $('#dataemp10').DataTable();
                                            table.destroy();
                                            clear();
                                            $('#dataemp10').DataTable().clear().draw();
                                            noty({ text: 'No Records Found!!', layout: 'topRight', type: 'information' });
                                            setTimeout(function () { $.noty.closeAll(); }, 3000);
                                        }
                        } 
                    else  if($("select[id$=ddlincome]").val() == "lockerfee"){ total = 0;
                                            table = $('#dataemp11').DataTable();
                                            table.destroy(); 
                                            if (data.d != "") {
                                                data = JSON.parse(data.d);
                                                $("#tbltutions").hide();$("#tbltutions1").hide();  $("#tbltutions2").hide();$("#tbltutions3").hide();$("#tbltutions5").hide(); $("#tbltutions6").hide();$("#tbltutions7").hide();  $("#tbltutions8").hide();$("#tbltutions9").hide();$("#tbltutions10").hide(); $("#tbltutions4").hide();$("#tbltutions12").hide();  $("#tbltutions13").hide();$("#tbltutions14").hide();$("#tbltutions15").hide();
                                                $("#tbltutions11").show();
                                                var table = $('#dataemp11').DataTable({
                                                    "aaSorting": [[0, "desc"]],
                                                    //"ordering": false,
                                                    "pageLength": 10,
                                                    "columns": [
                                                             { "width": "5%" },
                                                             { "width": "8%" },
                                                             { "width": "10%" },
                                                              { "width": "10%" },
                                                             { "width": "14%" },
                                                             { "width": "10%" },
                                                             { "width": "7%" },
                                                             { "width": "6%" },
                                                             { "width": "10%" },
                                   

                                                    ]
                                                });
                 
                                                $('#dataemp11').DataTable().clear().draw();
                                                for (var i = 0; i < data.length ; i++) {
                       
                                                    fullname = data[i].title + "." + data[i].fname + " " + data[i].mname + " " + data[i].lname;
                                                    // totalremainsamt = totalremainsamt + parseFloat(data[i].amount);
                                                    var ddyear1 = data[i].fromdate;
                                                    var ddyear2 = data[i].todate;
                                                    var dtyear1 = new Date(ddyear1);
                                                    var dtyear2 = new Date(ddyear2);
                                                    var stryr = dtyear1.getFullYear() + "-" + dtyear2.getFullYear();
                                                    table.row.add([
                                                      data[i].studid, fullname, stryr,data[i].class, data[i].division, data[i].totaltution, data[i].paymentdt,data[i].paymode, data[i].chequenos
                                                    ]).draw(false);
                                                    total = total + parseFloat(data[i].totaltution);

                                                }
                                                if (total > 0) {
                                                    $("#totalamt").html(total);
                                                } 
                                            }
                                            else{
                                                table = $('#dataemp11').DataTable();
                                                table.destroy();
                                                clear();
                                                $('#dataemp11').DataTable().clear().draw();
                                                noty({ text: 'No Records Found!!', layout: 'topRight', type: 'information' });
                                                setTimeout(function () { $.noty.closeAll(); }, 3000);
                                            }
                        } 
                    else  if($("select[id$=ddlincome]").val() == "gamespofee"){ total = 0;
                                                table = $('#dataemp12').DataTable();
                                                table.destroy(); 
                                                if (data.d != "") {
                                                    data = JSON.parse(data.d);
                                                    $("#tbltutions").hide();$("#tbltutions1").hide();  $("#tbltutions2").hide();$("#tbltutions3").hide();$("#tbltutions5").hide(); $("#tbltutions6").hide();$("#tbltutions7").hide();  $("#tbltutions8").hide();$("#tbltutions9").hide();$("#tbltutions10").hide(); $("#tbltutions11").hide();$("#tbltutions4").hide();  $("#tbltutions13").hide();$("#tbltutions14").hide();$("#tbltutions15").hide();
                                                    $("#tbltutions12").show();
                                                    var table = $('#dataemp12').DataTable({
                                                        "aaSorting": [[0, "desc"]],
                                                        //"ordering": false,
                                                        "pageLength": 10,
                                                        "columns": [
                                                                 { "width": "5%" },
                                                                 { "width": "8%" },
                                                                 { "width": "10%" },
                                                                  { "width": "10%" },
                                                                 { "width": "14%" },
                                                                 { "width": "10%" },
                                                                 { "width": "7%" },
                                                                 { "width": "6%" },
                                                                 { "width": "10%" },
                                   

                                                        ]
                                                    });
                 
                                                    $('#dataemp12').DataTable().clear().draw();
                                                    for (var i = 0; i < data.length ; i++) {
                       
                                                        fullname = data[i].title + "." + data[i].fname + " " + data[i].mname + " " + data[i].lname;
                                                        // totalremainsamt = totalremainsamt + parseFloat(data[i].amount);
                                                        var ddyear1 = data[i].fromdate;
                                                        var ddyear2 = data[i].todate;
                                                        var dtyear1 = new Date(ddyear1);
                                                        var dtyear2 = new Date(ddyear2);
                                                        var stryr = dtyear1.getFullYear() + "-" + dtyear2.getFullYear();
                                                        table.row.add([
                                                          data[i].studid, fullname, stryr,data[i].class, data[i].division, data[i].totaltution, data[i].paymentdt,data[i].paymode, data[i].chequenos
                                                        ]).draw(false);
                                                        total = total + parseFloat(data[i].totaltution);

                                                    }
                                                    if (total > 0) {
                                                        $("#totalamt").html(total);
                                                    } 
                                                }
                                                else{
                                                    table = $('#dataemp12').DataTable();
                                                    table.destroy();
                                                    clear();
                                                    $('#dataemp12').DataTable().clear().draw();
                                                    noty({ text: 'No Records Found!!', layout: 'topRight', type: 'information' });
                                                    setTimeout(function () { $.noty.closeAll(); }, 3000);
                                                }
                        } 
                    else  if($("select[id$=ddlincome]").val() == "boardfee"){ total = 0;
                                                    table = $('#dataemp13').DataTable();
                                                    table.destroy(); 
                                                    if (data.d != "") {
                                                        data = JSON.parse(data.d);
                                                        $("#tbltutions").hide();$("#tbltutions1").hide();  $("#tbltutions2").hide();$("#tbltutions3").hide();$("#tbltutions5").hide(); $("#tbltutions6").hide();$("#tbltutions7").hide();  $("#tbltutions8").hide();$("#tbltutions9").hide();$("#tbltutions10").hide(); $("#tbltutions11").hide();$("#tbltutions12").hide();  $("#tbltutions4").hide();$("#tbltutions14").hide();$("#tbltutions15").hide();
                                                        $("#tbltutions13").show();
                                                        var table = $('#dataemp13').DataTable({
                                                            "aaSorting": [[0, "desc"]],
                                                            //"ordering": false,
                                                            "pageLength": 10,
                                                            "columns": [
                                                                     { "width": "5%" },
                                                                     { "width": "8%" },
                                                                     { "width": "10%" },
                                                                      { "width": "10%" },
                                                                     { "width": "14%" },
                                                                     { "width": "10%" },
                                                                     { "width": "7%" },
                                                                     { "width": "6%" },
                                                                     { "width": "10%" },
                                   

                                                            ]
                                                        });
                 
                                                        $('#dataemp13').DataTable().clear().draw();
                                                        for (var i = 0; i < data.length ; i++) {
                       
                                                            fullname = data[i].title + "." + data[i].fname + " " + data[i].mname + " " + data[i].lname;
                                                            // totalremainsamt = totalremainsamt + parseFloat(data[i].amount);
                                                            var ddyear1 = data[i].fromdate;
                                                            var ddyear2 = data[i].todate;
                                                            var dtyear1 = new Date(ddyear1);
                                                            var dtyear2 = new Date(ddyear2);
                                                            var stryr = dtyear1.getFullYear() + "-" + dtyear2.getFullYear();
                                                            table.row.add([
                                                              data[i].studid, fullname, stryr,data[i].class, data[i].division, data[i].totaltution, data[i].paymentdt,data[i].paymode, data[i].chequenos
                                                            ]).draw(false);
                                                            total = total + parseFloat(data[i].totaltution);

                                                        }
                                                        if (total > 0) {
                                                            $("#totalamt").html(total);
                                                        } 
                                                    }
                                                    else{
                                                        table = $('#dataemp13').DataTable();
                                                        table.destroy();
                                                        clear();
                                                        $('#dataemp13').DataTable().clear().draw();
                                                        noty({ text: 'No Records Found!!', layout: 'topRight', type: 'information' });
                                                        setTimeout(function () { $.noty.closeAll(); }, 3000);
                                                    }
                        } 
                    else  if($("select[id$=ddlincome]").val() == "exactivityfee"){ total = 0;
                                                    table = $('#dataemp14').DataTable();
                                                    table.destroy(); 
                                                    if (data.d != "") {
                                                        data = JSON.parse(data.d);
                                                        $("#tbltutions").hide();$("#tbltutions1").hide();  $("#tbltutions2").hide();$("#tbltutions3").hide();$("#tbltutions5").hide(); $("#tbltutions6").hide();$("#tbltutions7").hide();  $("#tbltutions8").hide();$("#tbltutions9").hide();$("#tbltutions10").hide(); $("#tbltutions11").hide();$("#tbltutions12").hide();  $("#tbltutions13").hide();$("#tbltutions4").hide();$("#tbltutions15").hide();
                                                    $("#tbltutions14").show();
                                                    var table = $('#dataemp14').DataTable({
                                                        "aaSorting": [[0, "desc"]],
                                                        //"ordering": false,
                                                        "pageLength": 10,
                                                        "columns": [
                                                                 { "width": "5%" },
                                                                 { "width": "8%" },
                                                                 { "width": "10%" },
                                                                  { "width": "10%" },
                                                                 { "width": "14%" },
                                                                 { "width": "10%" },
                                                                 { "width": "7%" },
                                                                 { "width": "6%" },
                                                                 { "width": "10%" },
                                   

                                                        ]
                                                    });
                 
                                                    $('#dataemp14').DataTable().clear().draw();
                                                    for (var i = 0; i < data.length ; i++) {
                       
                                                        fullname = data[i].title + "." + data[i].fname + " " + data[i].mname + " " + data[i].lname;
                                                        // totalremainsamt = totalremainsamt + parseFloat(data[i].amount);
                                                        var ddyear1 = data[i].fromdate;
                                                        var ddyear2 = data[i].todate;
                                                        var dtyear1 = new Date(ddyear1);
                                                        var dtyear2 = new Date(ddyear2);
                                                        var stryr = dtyear1.getFullYear() + "-" + dtyear2.getFullYear();
                                                        table.row.add([
                                                          data[i].studid, fullname, stryr,data[i].class, data[i].division, data[i].totaltution, data[i].paymentdt,data[i].paymode, data[i].chequenos
                                                        ]).draw(false);
                                                        total = total + parseFloat(data[i].totaltution);

                                                    }
                                                    if (total > 0) {
                                                        $("#totalamt").html(total);
                                                    } 
                                                }
                                                else{
                                                    table = $('#dataemp14').DataTable();
                                                    table.destroy();
                                                    clear();
                                                    $('#dataemp14').DataTable().clear().draw();
                                                    noty({ text: 'No Records Found!!', layout: 'topRight', type: 'information' });
                                                    setTimeout(function () { $.noty.closeAll(); }, 3000);
                                                }
                        } 
                    else  if($("select[id$=ddlincome]").val() == "developfee"){ total = 0;
                            table = $('#dataemp15').DataTable();
                            table.destroy(); 
                            if (data.d != "") {
                                data = JSON.parse(data.d);
                                $("#tbltutions").hide();$("#tbltutions1").hide();  $("#tbltutions2").hide();$("#tbltutions3").hide();$("#tbltutions5").hide(); $("#tbltutions6").hide();$("#tbltutions7").hide();  $("#tbltutions8").hide();$("#tbltutions9").hide();$("#tbltutions10").hide(); $("#tbltutions11").hide();$("#tbltutions12").hide();  $("#tbltutions13").hide();$("#tbltutions14").hide();$("#tbltutions4").hide();
                                $("#tbltutions15").show();
                                var table = $('#dataemp15').DataTable({
                                    "aaSorting": [[0, "desc"]],
                                    //"ordering": false,
                                    "pageLength": 10,
                                    "columns": [
                                             { "width": "5%" },
                                             { "width": "8%" },
                                             { "width": "10%" },
                                              { "width": "10%" },
                                             { "width": "14%" },
                                             { "width": "10%" },
                                             { "width": "7%" },
                                             { "width": "6%" },
                                             { "width": "10%" },
                                   

                                    ]
                                });
                 
                                $('#dataemp15').DataTable().clear().draw();
                                for (var i = 0; i < data.length ; i++) {
                       
                                    fullname = data[i].title + "." + data[i].fname + " " + data[i].mname + " " + data[i].lname;
                                    // totalremainsamt = totalremainsamt + parseFloat(data[i].amount);
                                    var ddyear1 = data[i].fromdate;
                                    var ddyear2 = data[i].todate;
                                    var dtyear1 = new Date(ddyear1);
                                    var dtyear2 = new Date(ddyear2);
                                    var stryr = dtyear1.getFullYear() + "-" + dtyear2.getFullYear();
                                    table.row.add([
                                      data[i].studid, fullname, stryr,data[i].class, data[i].division, data[i].totaltution, data[i].paymentdt,data[i].paymode, data[i].chequenos
                                    ]).draw(false);
                                    total = total + parseFloat(data[i].totaltution);

                                }
                                if (total > 0) {
                                    $("#totalamt").html(total);
                                }
                            }
                            else{
                                table = $('#dataemp15').DataTable();
                                table.destroy();
                                clear();
                                $('#dataemp15').DataTable().clear().draw();
                                noty({ text: 'No Records Found!!', layout: 'topRight', type: 'information' });
                                setTimeout(function () { $.noty.closeAll(); }, 3000);
                            }
                        }
                     
                    
                },
                error: function () {
                    //alert("Error in display");
                    noty({ text: 'Get Error', layout: 'topRight', type: 'error' });
                    setTimeout(function () { $.noty.closeAll(); }, 3000);
                }

            });
        } 
        function clear(){
            $('#incomedate').val();  
            $("#incomedate1").val();  
            $("select[id$=ddlincome]").val("").change(); 
            $('select[id$=ddlyears]').val("0").change();
            $('select[id$=ddldivision]').val("0").change(); 
            $('select[id$=ddlclass]').val("0").change(); 
            $("select[id$=ddlpaymode]").val("").change(); total = 0;
        }
        function ExportDataExam()
        {
            var totalpaid = 0;
            var total = 0;
            var remainsamt = 0;
            var totalremainsamt = 0;


            $.ajax({
                url: "feeheadwisereport.aspx/Getdata",
                method: "post",
                contentType: "application/json; charset=utf-8",
                data: "{pdate:'" + $('#incomedate').val() + "',pdate1:'" + $("#incomedate1").val() + "', incomeid:'" + $("select[id$=ddlincome]").val() + "',yrsid : '"+ $('select[id$=ddlyears]').val() +"',divid :'"+ $('select[id$=ddldivision]').val() +"',clsid :'"+ $('select[id$=ddlclass]').val() +"',paymodes : '"+ $("select[id$=ddlpaymode]").val() +"'}",
                dataType: "json",
                success: function (data) {


                    console.log(data.d);
                    if($("select[id$=ddlincome]").val() == "tuitionfee"){
                        //$("#dataemp").find("tbody").empty();
                        // $("#dataemp").find("tbody").empty();

                        table = $('#dataemp').DataTable();
                        table.destroy(); 
                        if (data.d != "") {
                            data = JSON.parse(data.d);
                  
                            $("#tbltutions1").hide();$("#tbltutions2").hide();  $("#tbltutions3").hide();$("#tbltutions4").hide();$("#tbltutions5").hide(); $("#tbltutions6").hide();$("#tbltutions7").hide();  $("#tbltutions8").hide();$("#tbltutions9").hide();$("#tbltutions10").hide(); $("#tbltutions11").hide();$("#tbltutions12").hide();  $("#tbltutions13").hide();$("#tbltutions14").hide();$("#tbltutions15").hide();
                        
                            $("#tbltutions").show();
                            var table = $('#dataemp').DataTable({
                                "order": [[0, "asc"]],
                                "ordering": false,
                                "pageLength": 10,
                                //"lengthMenu": [[10, 25, 50, -1], [10, 25, 50, "All"]],
                                "dom": 'lBfrtip',
                          
                                //responsive: true,
                                //select: {
                                //    style: 'single'
                                //},
                                buttons: [
                                {
                                    extend: 'excelHtml5',
                                    text: 'Export to Excel',
                                    title: 'Tution Fee Report',
                                    download: 'open',
                                    orientation: 'landscape',
                                    exportOptions: {
                                        columns: ':visible'
                                    }
                                }],
                                "columns": [
                                         { "width": "5%" },
                                         { "width": "8%" },
                                         { "width": "10%" },
                                          { "width": "10%" },
                                         { "width": "14%" },
                                         { "width": "10%" },
                                         { "width": "7%" },
                                         { "width": "6%" },
                                         { "width": "10%" },
                                   

                                ]
                            });
                 
                            $('#dataemp').DataTable().clear().draw();
                            for (var i = 0; i < data.length ; i++) {
                       
                                fullname = data[i].title + "." + data[i].fname + " " + data[i].mname + " " + data[i].lname;
                                // totalremainsamt = totalremainsamt + parseFloat(data[i].amount);
                                var ddyear1 = data[i].fromdate;
                                var ddyear2 = data[i].todate;
                                var dtyear1 = new Date(ddyear1);
                                var dtyear2 = new Date(ddyear2);
                                var stryr = dtyear1.getFullYear() + "-" + dtyear2.getFullYear();
                                table.row.add([
                                  data[i].studid, fullname, stryr,data[i].class, data[i].division, data[i].totaltution, data[i].paymentdt,data[i].paymode, data[i].chequenos
                                ]).draw(false);
                                total = total + parseFloat(data[i].totaltution);

                            }
                            if (total > 0) {
                                $("#totalamt").html(total);
                            }
                        } 
                        else{
                            table = $('#dataemp').DataTable();
                            table.destroy();
                            clear();
                            $('#dataemp').DataTable().clear().draw();
                            noty({ text: 'No Records Found!!', layout: 'topRight', type: 'information' });
                            setTimeout(function () { $.noty.closeAll(); }, 3000);
                        }
                    } 
                    else  if($("select[id$=ddlincome]").val() == "admissionfee"){
                        total = 0;
                        table = $('#dataemp1').DataTable();
                        table.destroy(); 
                        if (data.d != "") {
                            data = JSON.parse(data.d);
                            $("#tbltutions").hide();$("#tbltutions2").hide();  $("#tbltutions3").hide();$("#tbltutions4").hide();$("#tbltutions5").hide(); $("#tbltutions6").hide();$("#tbltutions7").hide();  $("#tbltutions8").hide();$("#tbltutions9").hide();$("#tbltutions10").hide(); $("#tbltutions11").hide();$("#tbltutions12").hide();  $("#tbltutions13").hide();$("#tbltutions14").hide();$("#tbltutions15").hide();
                            $("#tbltutions1").show();
                            var table = $('#dataemp1').DataTable({
                                "order": [[0, "asc"]],
                                "ordering": false,
                                "pageLength": 10,
                                //"lengthMenu": [[10, 25, 50, -1], [10, 25, 50, "All"]],
                                "dom": 'lBfrtip',
                          
                                //responsive: true,
                                //select: {
                                //    style: 'single'
                                //},
                                buttons: [
                                {
                                    extend: 'excelHtml5',
                                    text: 'Export to Excel',
                                    title: 'Admission Fee Report',
                                    download: 'open',
                                    orientation: 'landscape',
                                    exportOptions: {
                                        columns: ':visible'
                                    }
                                }],
                                "columns": [
                                         { "width": "5%" },
                                         { "width": "8%" },
                                         { "width": "10%" },
                                          { "width": "10%" },
                                         { "width": "14%" },
                                         { "width": "10%" },
                                         { "width": "7%" },
                                         { "width": "6%" },
                                         { "width": "10%" },
                                   

                                ]
                            });
                 
                            $('#dataemp1').DataTable().clear().draw();
                            for (var i = 0; i < data.length ; i++) {
                       
                                fullname = data[i].title + "." + data[i].fname + " " + data[i].mname + " " + data[i].lname;
                                // totalremainsamt = totalremainsamt + parseFloat(data[i].amount);
                                var ddyear1 = data[i].fromdate;
                                var ddyear2 = data[i].todate;
                                var dtyear1 = new Date(ddyear1);
                                var dtyear2 = new Date(ddyear2);
                                var stryr = dtyear1.getFullYear() + "-" + dtyear2.getFullYear();
                                table.row.add([
                                  data[i].studid, fullname, stryr,data[i].class, data[i].division, data[i].totaltution, data[i].paymentdt,data[i].paymode, data[i].chequenos
                                ]).draw(false);
                                total = total + parseFloat(data[i].totaltution);

                            }
                            if (total > 0) {
                                $("#totalamt").html(total);
                            }
                        } 
                        else{
                            table = $('#dataemp1').DataTable();
                            table.destroy();
                            clear();
                            $('#dataemp1').DataTable().clear().draw();
                            noty({ text: 'No Records Found!!', layout: 'topRight', type: 'information' });
                            setTimeout(function () { $.noty.closeAll(); }, 3000);
                        }
                    } 
                    else  if($("select[id$=ddlincome]").val() == "cautionmny"){
                        total = 0;
                        table = $('#dataemp2').DataTable();
                        table.destroy(); 
                        if (data.d != "") {
                            data = JSON.parse(data.d);
                            $("#tbltutions").hide();$("#tbltutions1").hide();  $("#tbltutions3").hide();$("#tbltutions4").hide();$("#tbltutions5").hide(); $("#tbltutions6").hide();$("#tbltutions7").hide();  $("#tbltutions8").hide();$("#tbltutions9").hide();$("#tbltutions10").hide(); $("#tbltutions11").hide();$("#tbltutions12").hide();  $("#tbltutions13").hide();$("#tbltutions14").hide();$("#tbltutions15").hide();
                            $("#tbltutions2").show();
                            var table = $('#dataemp2').DataTable({
                                "order": [[0, "asc"]],
                                "ordering": false,
                                "pageLength": 10,
                                //"lengthMenu": [[10, 25, 50, -1], [10, 25, 50, "All"]],
                                "dom": 'lBfrtip',
                          
                                //responsive: true,
                                //select: {
                                //    style: 'single'
                                //},
                                buttons: [
                                {
                                    extend: 'excelHtml5',
                                    text: 'Export to Excel',
                                    title: 'Caution Money Fee Report',
                                    download: 'open',
                                    orientation: 'landscape',
                                    exportOptions: {
                                        columns: ':visible'
                                    }
                                }],
                                "columns": [
                                         { "width": "5%" },
                                         { "width": "8%" },
                                         { "width": "10%" },
                                          { "width": "10%" },
                                         { "width": "14%" },
                                         { "width": "10%" },
                                         { "width": "7%" },
                                         { "width": "6%" },
                                         { "width": "10%" },
                                   

                                ]
                            });
                 
                            $('#dataemp2').DataTable().clear().draw();
                            for (var i = 0; i < data.length ; i++) {
                       
                                fullname = data[i].title + "." + data[i].fname + " " + data[i].mname + " " + data[i].lname;
                                // totalremainsamt = totalremainsamt + parseFloat(data[i].amount);
                                var ddyear1 = data[i].fromdate;
                                var ddyear2 = data[i].todate;
                                var dtyear1 = new Date(ddyear1);
                                var dtyear2 = new Date(ddyear2);
                                var stryr = dtyear1.getFullYear() + "-" + dtyear2.getFullYear();
                                table.row.add([
                                  data[i].studid, fullname, stryr,data[i].class, data[i].division, data[i].totaltution, data[i].paymentdt,data[i].paymode, data[i].chequenos
                                ]).draw(false);
                                total = total + parseFloat(data[i].totaltution);

                            }
                            if (total > 0) {
                                $("#totalamt").html(total);
                            }
                        }
                        else{
                            table = $('#dataemp2').DataTable();
                            table.destroy();
                            clear();
                            $('#dataemp2').DataTable().clear().draw();
                            noty({ text: 'No Records Found!!', layout: 'topRight', type: 'information' });
                            setTimeout(function () { $.noty.closeAll(); }, 3000);
                        }
                    }
                    else  if($("select[id$=ddlincome]").val() == "collegefee"){ total = 0;
                        table = $('#dataemp3').DataTable();
                        table.destroy(); 
                        if (data.d != "") {
                            data = JSON.parse(data.d);
                            $("#tbltutions").hide();$("#tbltutions1").hide();  $("#tbltutions2").hide();$("#tbltutions4").hide();$("#tbltutions5").hide(); $("#tbltutions6").hide();$("#tbltutions7").hide();  $("#tbltutions8").hide();$("#tbltutions9").hide();$("#tbltutions10").hide(); $("#tbltutions11").hide();$("#tbltutions12").hide();  $("#tbltutions13").hide();$("#tbltutions14").hide();$("#tbltutions15").hide();
                            $("#tbltutions3").show();
                            var table = $('#dataemp3').DataTable({
                                "order": [[0, "asc"]],
                                "ordering": false,
                                "pageLength": 10,
                                //"lengthMenu": [[10, 25, 50, -1], [10, 25, 50, "All"]],
                                "dom": 'lBfrtip',
                          
                                //responsive: true,
                                //select: {
                                //    style: 'single'
                                //},
                                buttons: [
                                {
                                    extend: 'excelHtml5',
                                    text: 'Export to Excel',
                                    title: 'College Fee Report',
                                    download: 'open',
                                    orientation: 'landscape',
                                    exportOptions: {
                                        columns: ':visible'
                                    }
                                }],
                                "columns": [
                                         { "width": "5%" },
                                         { "width": "8%" },
                                         { "width": "10%" },
                                          { "width": "10%" },
                                         { "width": "14%" },
                                         { "width": "10%" },
                                         { "width": "7%" },
                                         { "width": "6%" },
                                         { "width": "10%" },
                                   

                                ]
                            });
                 
                            $('#dataemp3').DataTable().clear().draw();
                            for (var i = 0; i < data.length ; i++) {
                       
                                fullname = data[i].title + "." + data[i].fname + " " + data[i].mname + " " + data[i].lname;
                                // totalremainsamt = totalremainsamt + parseFloat(data[i].amount);
                                var ddyear1 = data[i].fromdate;
                                var ddyear2 = data[i].todate;
                                var dtyear1 = new Date(ddyear1);
                                var dtyear2 = new Date(ddyear2);
                                var stryr = dtyear1.getFullYear() + "-" + dtyear2.getFullYear();
                                table.row.add([
                                  data[i].studid, fullname, stryr,data[i].class, data[i].division, data[i].totaltution, data[i].paymentdt,data[i].paymode, data[i].chequenos
                                ]).draw(false);
                                total = total + parseFloat(data[i].totaltution);

                            }
                            if (total > 0) {
                                $("#totalamt").html(total);
                            }
                        } 
                        else{
                            table = $('#dataemp3').DataTable();
                            table.destroy();
                            clear();
                            $('#dataemp3').DataTable().clear().draw();
                            noty({ text: 'No Records Found!!', layout: 'topRight', type: 'information' });
                            setTimeout(function () { $.noty.closeAll(); }, 3000);
                        }
                    } 
                    else  if($("select[id$=ddlincome]").val() == "identycrdfee"){ total = 0;
                        table = $('#dataemp4').DataTable();
                        table.destroy(); 
                        if (data.d != "") {
                            data = JSON.parse(data.d);
                            $("#tbltutions").hide();$("#tbltutions1").hide();  $("#tbltutions2").hide();$("#tbltutions3").hide();$("#tbltutions5").hide(); $("#tbltutions6").hide();$("#tbltutions7").hide();  $("#tbltutions8").hide();$("#tbltutions9").hide();$("#tbltutions10").hide(); $("#tbltutions11").hide();$("#tbltutions12").hide();  $("#tbltutions13").hide();$("#tbltutions14").hide();$("#tbltutions15").hide();
                            $("#tbltutions4").show();
                            var table = $('#dataemp4').DataTable({
                                "order": [[0, "asc"]],
                                "ordering": false,
                                "pageLength": 10,
                                //"lengthMenu": [[10, 25, 50, -1], [10, 25, 50, "All"]],
                                "dom": 'lBfrtip',
                          
                                //responsive: true,
                                //select: {
                                //    style: 'single'
                                //},
                                buttons: [
                                {
                                    extend: 'excelHtml5',
                                    text: 'Export to Excel',
                                    title: 'IdentityCard Fee Report',
                                    download: 'open',
                                    orientation: 'landscape',
                                    exportOptions: {
                                        columns: ':visible'
                                    }
                                }],
                                "columns": [
                                         { "width": "5%" },
                                         { "width": "8%" },
                                         { "width": "10%" },
                                          { "width": "10%" },
                                         { "width": "14%" },
                                         { "width": "10%" },
                                         { "width": "7%" },
                                         { "width": "6%" },
                                         { "width": "10%" },
                                   

                                ]
                            });
                 
                            $('#dataemp4').DataTable().clear().draw();
                            for (var i = 0; i < data.length ; i++) {
                       
                                fullname = data[i].title + "." + data[i].fname + " " + data[i].mname + " " + data[i].lname;
                                // totalremainsamt = totalremainsamt + parseFloat(data[i].amount);
                                var ddyear1 = data[i].fromdate;
                                var ddyear2 = data[i].todate;
                                var dtyear1 = new Date(ddyear1);
                                var dtyear2 = new Date(ddyear2);
                                var stryr = dtyear1.getFullYear() + "-" + dtyear2.getFullYear();
                                table.row.add([
                                  data[i].studid, fullname, stryr,data[i].class, data[i].division, data[i].totaltution, data[i].paymentdt,data[i].paymode, data[i].chequenos
                                ]).draw(false);
                                total = total + parseFloat(data[i].totaltution);

                            }
                            if (total > 0) {
                                $("#totalamt").html(total);
                            }
                        }
                        
                        else{
                            table = $('#dataemp4').DataTable();
                            table.destroy();
                            clear();
                            $('#dataemp4').DataTable().clear().draw();
                            noty({ text: 'No Records Found!!', layout: 'topRight', type: 'information' });
                            setTimeout(function () { $.noty.closeAll(); }, 3000);
                        }
                    } 
                    else  if($("select[id$=ddlincome]").val() == "insurance"){ total = 0;
                        table = $('#dataemp5').DataTable();
                        table.destroy(); 
                        if (data.d != "") {
                            data = JSON.parse(data.d);
                            $("#tbltutions").hide();$("#tbltutions1").hide();  $("#tbltutions2").hide();$("#tbltutions3").hide();$("#tbltutions4").hide(); $("#tbltutions6").hide();$("#tbltutions7").hide();  $("#tbltutions8").hide();$("#tbltutions9").hide();$("#tbltutions10").hide(); $("#tbltutions11").hide();$("#tbltutions12").hide();  $("#tbltutions13").hide();$("#tbltutions14").hide();$("#tbltutions15").hide();
                            $("#tbltutions5").show();
                            var table = $('#dataemp5').DataTable({
                                "order": [[0, "asc"]],
                                "ordering": false,
                                "pageLength": 10,
                                //"lengthMenu": [[10, 25, 50, -1], [10, 25, 50, "All"]],
                                "dom": 'lBfrtip',
                          
                                //responsive: true,
                                //select: {
                                //    style: 'single'
                                //},
                                buttons: [
                                {
                                    extend: 'excelHtml5',
                                    text: 'Export to Excel',
                                    title: 'Insurance Fee Report',
                                    download: 'open',
                                    orientation: 'landscape',
                                    exportOptions: {
                                        columns: ':visible'
                                    }
                                }],
                                "columns": [
                                         { "width": "5%" },
                                         { "width": "8%" },
                                         { "width": "10%" },
                                          { "width": "10%" },
                                         { "width": "14%" },
                                         { "width": "10%" },
                                         { "width": "7%" },
                                         { "width": "6%" },
                                         { "width": "10%" },
                                   

                                ]
                            });
                 
                            $('#dataemp5').DataTable().clear().draw();
                            for (var i = 0; i < data.length ; i++) {
                       
                                fullname = data[i].title + "." + data[i].fname + " " + data[i].mname + " " + data[i].lname;
                                // totalremainsamt = totalremainsamt + parseFloat(data[i].amount);
                                var ddyear1 = data[i].fromdate;
                                var ddyear2 = data[i].todate;
                                var dtyear1 = new Date(ddyear1);
                                var dtyear2 = new Date(ddyear2);
                                var stryr = dtyear1.getFullYear() + "-" + dtyear2.getFullYear();
                                table.row.add([
                                  data[i].studid, fullname, stryr,data[i].class, data[i].division, data[i].totaltution, data[i].paymentdt,data[i].paymode, data[i].chequenos
                                ]).draw(false);
                                total = total + parseFloat(data[i].totaltution);

                            }
                            if (total > 0) {
                                $("#totalamt").html(total);
                            }
                        } 
                        else{
                            table = $('#dataemp5').DataTable();
                            table.destroy();
                            clear();
                            $('#dataemp5').DataTable().clear().draw();
                            noty({ text: 'No Records Found!!', layout: 'topRight', type: 'information' });
                            setTimeout(function () { $.noty.closeAll(); }, 3000);
                        }
                    } 
                    else  if($("select[id$=ddlincome]").val() == "unifees"){ total = 0;
                        table = $('#dataemp6').DataTable();
                        table.destroy(); 
                        if (data.d != "") {
                            data = JSON.parse(data.d);
                            $("#tbltutions").hide();$("#tbltutions1").hide();  $("#tbltutions2").hide();$("#tbltutions3").hide();$("#tbltutions4").hide(); $("#tbltutions5").hide();$("#tbltutions7").hide();  $("#tbltutions8").hide();$("#tbltutions9").hide();$("#tbltutions10").hide(); $("#tbltutions11").hide();$("#tbltutions12").hide();  $("#tbltutions13").hide();$("#tbltutions14").hide();$("#tbltutions15").hide();
                            $("#tbltutions6").show();
                            var table = $('#dataemp6').DataTable({
                                "order": [[0, "asc"]],
                                "ordering": false,
                                "pageLength": 10,
                                //"lengthMenu": [[10, 25, 50, -1], [10, 25, 50, "All"]],
                                "dom": 'lBfrtip',
                          
                                //responsive: true,
                                //select: {
                                //    style: 'single'
                                //},
                                buttons: [
                                {
                                    extend: 'excelHtml5',
                                    text: 'Export to Excel',
                                    title: 'University Fee',
                                    download: 'open',
                                    orientation: 'landscape',
                                    exportOptions: {
                                        columns: ':visible'
                                    }
                                }],
                                "columns": [
                                         { "width": "5%" },
                                         { "width": "8%" },
                                         { "width": "10%" },
                                          { "width": "10%" },
                                         { "width": "14%" },
                                         { "width": "10%" },
                                         { "width": "7%" },
                                         { "width": "6%" },
                                         { "width": "10%" },
                                   

                                ]
                            });
                 
                            $('#dataemp6').DataTable().clear().draw();
                            for (var i = 0; i < data.length ; i++) {
                       
                                fullname = data[i].title + "." + data[i].fname + " " + data[i].mname + " " + data[i].lname;
                                // totalremainsamt = totalremainsamt + parseFloat(data[i].amount);
                                var ddyear1 = data[i].fromdate;
                                var ddyear2 = data[i].todate;
                                var dtyear1 = new Date(ddyear1);
                                var dtyear2 = new Date(ddyear2);
                                var stryr = dtyear1.getFullYear() + "-" + dtyear2.getFullYear();
                                table.row.add([
                                  data[i].studid, fullname, stryr,data[i].class, data[i].division, data[i].totaltution, data[i].paymentdt,data[i].paymode, data[i].chequenos
                                ]).draw(false);
                                total = total + parseFloat(data[i].totaltution);

                            }
                            if (total > 0) {
                                $("#totalamt").html(total);
                            }
                        }
                        else{
                            table = $('#dataemp6').DataTable();
                            table.destroy();
                            clear();
                            $('#dataemp6').DataTable().clear().draw();
                            noty({ text: 'No Records Found!!', layout: 'topRight', type: 'information' });
                            setTimeout(function () { $.noty.closeAll(); }, 3000);
                        }
                    } 
                    else  if($("select[id$=ddlincome]").val() == "busfee"){ total = 0;
                        table = $('#dataemp7').DataTable();
                        table.destroy(); 
                        if (data.d != "") {
                            data = JSON.parse(data.d);
                            $("#tbltutions").hide();$("#tbltutions1").hide();  $("#tbltutions2").hide();$("#tbltutions3").hide();$("#tbltutions5").hide(); $("#tbltutions6").hide();$("#tbltutions4").hide();  $("#tbltutions8").hide();$("#tbltutions9").hide();$("#tbltutions10").hide(); $("#tbltutions11").hide();$("#tbltutions12").hide();  $("#tbltutions13").hide();$("#tbltutions14").hide();$("#tbltutions15").hide();
                            $("#tbltutions7").show();
                            var table = $('#dataemp7').DataTable({
                                "order": [[0, "asc"]],
                                "ordering": false,
                                "pageLength": 10,
                                //"lengthMenu": [[10, 25, 50, -1], [10, 25, 50, "All"]],
                                "dom": 'lBfrtip',
                          
                                //responsive: true,
                                //select: {
                                //    style: 'single'
                                //},
                                buttons: [
                                {
                                    extend: 'excelHtml5',
                                    text: 'Export to Excel',
                                    title: 'Bus Fee Report',
                                    download: 'open',
                                    orientation: 'landscape',
                                    exportOptions: {
                                        columns: ':visible'
                                    }
                                }],
                                "columns": [
                                         { "width": "5%" },
                                         { "width": "8%" },
                                         { "width": "10%" },
                                          { "width": "10%" },
                                         { "width": "14%" },
                                         { "width": "10%" },
                                         { "width": "7%" },
                                         { "width": "6%" },
                                         { "width": "10%" },
                                   

                                ]
                            });
                 
                            $('#dataemp7').DataTable().clear().draw();
                            for (var i = 0; i < data.length ; i++) {
                       
                                fullname = data[i].title + "." + data[i].fname + " " + data[i].mname + " " + data[i].lname;
                                // totalremainsamt = totalremainsamt + parseFloat(data[i].amount);
                                var ddyear1 = data[i].fromdate;
                                var ddyear2 = data[i].todate;
                                var dtyear1 = new Date(ddyear1);
                                var dtyear2 = new Date(ddyear2);
                                var stryr = dtyear1.getFullYear() + "-" + dtyear2.getFullYear();
                                table.row.add([
                                  data[i].studid, fullname, stryr,data[i].class, data[i].division, data[i].totaltution, data[i].paymentdt,data[i].paymode, data[i].chequenos
                                ]).draw(false);
                                total = total + parseFloat(data[i].totaltution);

                            }
                            if (total > 0) {
                                $("#totalamt").html(total);
                            }
                        }
                        else{
                            table = $('#dataemp7').DataTable();
                            table.destroy();
                            clear();
                            $('#dataemp7').DataTable().clear().draw();
                            noty({ text: 'No Records Found!!', layout: 'topRight', type: 'information' });
                            setTimeout(function () { $.noty.closeAll(); }, 3000);
                        }
                    } 
                    else  if($("select[id$=ddlincome]").val() == "eligibilityfee"){ total = 0;
                        table = $('#dataemp8').DataTable();
                        table.destroy(); 
                        if (data.d != "") {
                            data = JSON.parse(data.d);
                            $("#tbltutions").hide();$("#tbltutions1").hide();  $("#tbltutions2").hide();$("#tbltutions3").hide();$("#tbltutions5").hide(); $("#tbltutions6").hide();$("#tbltutions7").hide();  $("#tbltutions4").hide();$("#tbltutions9").hide();$("#tbltutions10").hide(); $("#tbltutions11").hide();$("#tbltutions12").hide();  $("#tbltutions13").hide();$("#tbltutions14").hide();$("#tbltutions15").hide();
                            $("#tbltutions8").show();
                            var table = $('#dataemp8').DataTable({
                                "order": [[0, "asc"]],
                                "ordering": false,
                                "pageLength": 10,
                                //"lengthMenu": [[10, 25, 50, -1], [10, 25, 50, "All"]],
                                "dom": 'lBfrtip',
                          
                                //responsive: true,
                                //select: {
                                //    style: 'single'
                                //},
                                buttons: [
                                {
                                    extend: 'excelHtml5',
                                    text: 'Export to Excel',
                                    title: 'Eligibility Fee Report',
                                    download: 'open',
                                    orientation: 'landscape',
                                    exportOptions: {
                                        columns: ':visible'
                                    }
                                }],
                                "columns": [
                                         { "width": "5%" },
                                         { "width": "8%" },
                                         { "width": "10%" },
                                          { "width": "10%" },
                                         { "width": "14%" },
                                         { "width": "10%" },
                                         { "width": "7%" },
                                         { "width": "6%" },
                                         { "width": "10%" },
                                   

                                ]
                            });
                 
                            $('#dataemp8').DataTable().clear().draw();
                            for (var i = 0; i < data.length ; i++) {
                       
                                fullname = data[i].title + "." + data[i].fname + " " + data[i].mname + " " + data[i].lname;
                                // totalremainsamt = totalremainsamt + parseFloat(data[i].amount);
                                var ddyear1 = data[i].fromdate;
                                var ddyear2 = data[i].todate;
                                var dtyear1 = new Date(ddyear1);
                                var dtyear2 = new Date(ddyear2);
                                var stryr = dtyear1.getFullYear() + "-" + dtyear2.getFullYear();
                                table.row.add([
                                  data[i].studid, fullname, stryr,data[i].class, data[i].division, data[i].totaltution, data[i].paymentdt,data[i].paymode, data[i].chequenos
                                ]).draw(false);
                                total = total + parseFloat(data[i].totaltution);

                            }
                            if (total > 0) {
                                $("#totalamt").html(total);
                            } 
                        }
                        else{
                            table = $('#dataemp8').DataTable();
                            table.destroy();
                            clear();
                            $('#dataemp8').DataTable().clear().draw();
                            noty({ text: 'No Records Found!!', layout: 'topRight', type: 'information' });
                            setTimeout(function () { $.noty.closeAll(); }, 3000);
                        }
                    } 
                    else  if($("select[id$=ddlincome]").val() == "exminfee"){ total = 0;
                        table = $('#dataemp9').DataTable();
                        table.destroy(); 
                        if (data.d != "") {
                            data = JSON.parse(data.d);
                            $("#tbltutions").hide();$("#tbltutions1").hide();  $("#tbltutions2").hide();$("#tbltutions3").hide();$("#tbltutions5").hide(); $("#tbltutions6").hide();$("#tbltutions7").hide();  $("#tbltutions8").hide();$("#tbltutions4").hide();$("#tbltutions10").hide(); $("#tbltutions11").hide();$("#tbltutions12").hide();  $("#tbltutions13").hide();$("#tbltutions14").hide();$("#tbltutions15").hide();
                            $("#tbltutions9").show();
                            var table = $('#dataemp9').DataTable({
                                "order": [[0, "asc"]],
                                "ordering": false,
                                "pageLength": 10,
                                //"lengthMenu": [[10, 25, 50, -1], [10, 25, 50, "All"]],
                                "dom": 'lBfrtip',
                          
                                //responsive: true,
                                //select: {
                                //    style: 'single'
                                //},
                                buttons: [
                                {
                                    extend: 'excelHtml5',
                                    text: 'Export to Excel',
                                    title: 'Exam Fee Report',
                                    download: 'open',
                                    orientation: 'landscape',
                                    exportOptions: {
                                        columns: ':visible'
                                    }
                                }],
                                "columns": [
                                         { "width": "5%" },
                                         { "width": "8%" },
                                         { "width": "10%" },
                                          { "width": "10%" },
                                         { "width": "14%" },
                                         { "width": "10%" },
                                         { "width": "7%" },
                                         { "width": "6%" },
                                         { "width": "10%" },
                                   

                                ]
                            });
                 
                            $('#dataemp9').DataTable().clear().draw();
                            for (var i = 0; i < data.length ; i++) {
                       
                                fullname = data[i].title + "." + data[i].fname + " " + data[i].mname + " " + data[i].lname;
                                // totalremainsamt = totalremainsamt + parseFloat(data[i].amount);
                                var ddyear1 = data[i].fromdate;
                                var ddyear2 = data[i].todate;
                                var dtyear1 = new Date(ddyear1);
                                var dtyear2 = new Date(ddyear2);
                                var stryr = dtyear1.getFullYear() + "-" + dtyear2.getFullYear();
                                table.row.add([
                                  data[i].studid, fullname, stryr,data[i].class, data[i].division, data[i].totaltution, data[i].paymentdt,data[i].paymode, data[i].chequenos
                                ]).draw(false);
                                total = total + parseFloat(data[i].totaltution);

                            }
                            if (total > 0) {
                                $("#totalamt").html(total);
                            } 
                        }
                        else{
                            table = $('#dataemp9').DataTable();
                            table.destroy();
                            clear();
                            $('#dataemp9').DataTable().clear().draw();
                            noty({ text: 'No Records Found!!', layout: 'topRight', type: 'information' });
                            setTimeout(function () { $.noty.closeAll(); }, 3000);
                        }
                    } 
                    else  if($("select[id$=ddlincome]").val() == "enrollfee"){ total = 0;
                        table = $('#dataemp10').DataTable();
                        table.destroy(); 
                        if (data.d != "") {
                            data = JSON.parse(data.d);
                            $("#tbltutions").hide();$("#tbltutions1").hide();  $("#tbltutions2").hide();$("#tbltutions3").hide();$("#tbltutions5").hide(); $("#tbltutions6").hide();$("#tbltutions7").hide();  $("#tbltutions8").hide();$("#tbltutions9").hide();$("#tbltutions4").hide(); $("#tbltutions11").hide();$("#tbltutions12").hide();  $("#tbltutions13").hide();$("#tbltutions14").hide();$("#tbltutions15").hide();
                            $("#tbltutions10").show();
                            var table = $('#dataemp10').DataTable({
                                "order": [[0, "asc"]],
                                "ordering": false,
                                "pageLength": 10,
                                //"lengthMenu": [[10, 25, 50, -1], [10, 25, 50, "All"]],
                                "dom": 'lBfrtip',
                          
                                //responsive: true,
                                //select: {
                                //    style: 'single'
                                //},
                                buttons: [
                                {
                                    extend: 'excelHtml5',
                                    text: 'Export to Excel',
                                    title: 'Enroll Fee Report',
                                    download: 'open',
                                    orientation: 'landscape',
                                    exportOptions: {
                                        columns: ':visible'
                                    }
                                }],
                                "columns": [
                                         { "width": "5%" },
                                         { "width": "8%" },
                                         { "width": "10%" },
                                          { "width": "10%" },
                                         { "width": "14%" },
                                         { "width": "10%" },
                                         { "width": "7%" },
                                         { "width": "6%" },
                                         { "width": "10%" },
                                   

                                ]
                            });
                 
                            $('#dataemp10').DataTable().clear().draw();
                            for (var i = 0; i < data.length ; i++) {
                       
                                fullname = data[i].title + "." + data[i].fname + " " + data[i].mname + " " + data[i].lname;
                                // totalremainsamt = totalremainsamt + parseFloat(data[i].amount);
                                var ddyear1 = data[i].fromdate;
                                var ddyear2 = data[i].todate;
                                var dtyear1 = new Date(ddyear1);
                                var dtyear2 = new Date(ddyear2);
                                var stryr = dtyear1.getFullYear() + "-" + dtyear2.getFullYear();
                                table.row.add([
                                  data[i].studid, fullname, stryr,data[i].class, data[i].division, data[i].totaltution, data[i].paymentdt,data[i].paymode, data[i].chequenos
                                ]).draw(false);
                                total = total + parseFloat(data[i].totaltution);

                            }
                            if (total > 0) {
                                $("#totalamt").html(total);
                            } 
                        }
                        else{
                            table = $('#dataemp10').DataTable();
                            table.destroy();
                            clear();
                            $('#dataemp10').DataTable().clear().draw();
                            noty({ text: 'No Records Found!!', layout: 'topRight', type: 'information' });
                            setTimeout(function () { $.noty.closeAll(); }, 3000);
                        }
                    } 
                    else  if($("select[id$=ddlincome]").val() == "lockerfee"){ total = 0;
                        table = $('#dataemp11').DataTable();
                        table.destroy(); 
                        if (data.d != "") {
                            data = JSON.parse(data.d);
                            $("#tbltutions").hide();$("#tbltutions1").hide();  $("#tbltutions2").hide();$("#tbltutions3").hide();$("#tbltutions5").hide(); $("#tbltutions6").hide();$("#tbltutions7").hide();  $("#tbltutions8").hide();$("#tbltutions9").hide();$("#tbltutions10").hide(); $("#tbltutions4").hide();$("#tbltutions12").hide();  $("#tbltutions13").hide();$("#tbltutions14").hide();$("#tbltutions15").hide();
                            $("#tbltutions11").show();
                            var table = $('#dataemp11').DataTable({
                                "order": [[0, "asc"]],
                                "ordering": false,
                                "pageLength": 10,
                                //"lengthMenu": [[10, 25, 50, -1], [10, 25, 50, "All"]],
                                "dom": 'lBfrtip',
                          
                                //responsive: true,
                                //select: {
                                //    style: 'single'
                                //},
                                buttons: [
                                {
                                    extend: 'excelHtml5',
                                    text: 'Export to Excel',
                                    title: 'Locker Fee Report',
                                    download: 'open',
                                    orientation: 'landscape',
                                    exportOptions: {
                                        columns: ':visible'
                                    }
                                }],
                                "columns": [
                                         { "width": "5%" },
                                         { "width": "8%" },
                                         { "width": "10%" },
                                          { "width": "10%" },
                                         { "width": "14%" },
                                         { "width": "10%" },
                                         { "width": "7%" },
                                         { "width": "6%" },
                                         { "width": "10%" },
                                   

                                ]
                            });
                 
                            $('#dataemp11').DataTable().clear().draw();
                            for (var i = 0; i < data.length ; i++) {
                       
                                fullname = data[i].title + "." + data[i].fname + " " + data[i].mname + " " + data[i].lname;
                                // totalremainsamt = totalremainsamt + parseFloat(data[i].amount);
                                var ddyear1 = data[i].fromdate;
                                var ddyear2 = data[i].todate;
                                var dtyear1 = new Date(ddyear1);
                                var dtyear2 = new Date(ddyear2);
                                var stryr = dtyear1.getFullYear() + "-" + dtyear2.getFullYear();
                                table.row.add([
                                  data[i].studid, fullname, stryr,data[i].class, data[i].division, data[i].totaltution, data[i].paymentdt,data[i].paymode, data[i].chequenos
                                ]).draw(false);
                                total = total + parseFloat(data[i].totaltution);

                            }
                            if (total > 0) {
                                $("#totalamt").html(total);
                            } 
                        }
                        else{
                            table = $('#dataemp11').DataTable();
                            table.destroy();
                            clear();
                            $('#dataemp11').DataTable().clear().draw();
                            noty({ text: 'No Records Found!!', layout: 'topRight', type: 'information' });
                            setTimeout(function () { $.noty.closeAll(); }, 3000);
                        }
                    } 
                    else  if($("select[id$=ddlincome]").val() == "gamespofee"){ total = 0;
                        table = $('#dataemp12').DataTable();
                        table.destroy(); 
                        if (data.d != "") {
                            data = JSON.parse(data.d);
                            $("#tbltutions").hide();$("#tbltutions1").hide();  $("#tbltutions2").hide();$("#tbltutions3").hide();$("#tbltutions5").hide(); $("#tbltutions6").hide();$("#tbltutions7").hide();  $("#tbltutions8").hide();$("#tbltutions9").hide();$("#tbltutions10").hide(); $("#tbltutions11").hide();$("#tbltutions4").hide();  $("#tbltutions13").hide();$("#tbltutions14").hide();$("#tbltutions15").hide();
                            $("#tbltutions12").show();
                            var table = $('#dataemp12').DataTable({
                                "order": [[0, "asc"]],
                                "ordering": false,
                                "pageLength": 10,
                                //"lengthMenu": [[10, 25, 50, -1], [10, 25, 50, "All"]],
                                "dom": 'lBfrtip',
                          
                                //responsive: true,
                                //select: {
                                //    style: 'single'
                                //},
                                buttons: [
                                {
                                    extend: 'excelHtml5',
                                    text: 'Export to Excel',
                                    title: 'Games Fee Report',
                                    download: 'open',
                                    orientation: 'landscape',
                                    exportOptions: {
                                        columns: ':visible'
                                    }
                                }],
                                "columns": [
                                         { "width": "5%" },
                                         { "width": "8%" },
                                         { "width": "10%" },
                                          { "width": "10%" },
                                         { "width": "14%" },
                                         { "width": "10%" },
                                         { "width": "7%" },
                                         { "width": "6%" },
                                         { "width": "10%" },
                                   

                                ]
                            });
                 
                            $('#dataemp12').DataTable().clear().draw();
                            for (var i = 0; i < data.length ; i++) {
                       
                                fullname = data[i].title + "." + data[i].fname + " " + data[i].mname + " " + data[i].lname;
                                // totalremainsamt = totalremainsamt + parseFloat(data[i].amount);
                                var ddyear1 = data[i].fromdate;
                                var ddyear2 = data[i].todate;
                                var dtyear1 = new Date(ddyear1);
                                var dtyear2 = new Date(ddyear2);
                                var stryr = dtyear1.getFullYear() + "-" + dtyear2.getFullYear();
                                table.row.add([
                                  data[i].studid, fullname, stryr,data[i].class, data[i].division, data[i].totaltution, data[i].paymentdt,data[i].paymode, data[i].chequenos
                                ]).draw(false);
                                total = total + parseFloat(data[i].totaltution);

                            }
                            if (total > 0) {
                                $("#totalamt").html(total);
                            } 
                        }
                        else{
                            table = $('#dataemp12').DataTable();
                            table.destroy();
                            clear();
                            $('#dataemp12').DataTable().clear().draw();
                            noty({ text: 'No Records Found!!', layout: 'topRight', type: 'information' });
                            setTimeout(function () { $.noty.closeAll(); }, 3000);
                        }
                    } 
                    else  if($("select[id$=ddlincome]").val() == "boardfee"){ total = 0;
                        table = $('#dataemp13').DataTable();
                        table.destroy(); 
                        if (data.d != "") {
                            data = JSON.parse(data.d);
                            $("#tbltutions").hide();$("#tbltutions1").hide();  $("#tbltutions2").hide();$("#tbltutions3").hide();$("#tbltutions5").hide(); $("#tbltutions6").hide();$("#tbltutions7").hide();  $("#tbltutions8").hide();$("#tbltutions9").hide();$("#tbltutions10").hide(); $("#tbltutions11").hide();$("#tbltutions12").hide();  $("#tbltutions4").hide();$("#tbltutions14").hide();$("#tbltutions15").hide();
                            $("#tbltutions13").show();
                            var table = $('#dataemp13').DataTable({
                                "order": [[0, "asc"]],
                                "ordering": false,
                                "pageLength": 10,
                                //"lengthMenu": [[10, 25, 50, -1], [10, 25, 50, "All"]],
                                "dom": 'lBfrtip',
                          
                                //responsive: true,
                                //select: {
                                //    style: 'single'
                                //},
                                buttons: [
                                {
                                    extend: 'excelHtml5',
                                    text: 'Export to Excel',
                                    title: 'Board Fee Report',
                                    download: 'open',
                                    orientation: 'landscape',
                                    exportOptions: {
                                        columns: ':visible'
                                    }
                                }],
                                "columns": [
                                         { "width": "5%" },
                                         { "width": "8%" },
                                         { "width": "10%" },
                                          { "width": "10%" },
                                         { "width": "14%" },
                                         { "width": "10%" },
                                         { "width": "7%" },
                                         { "width": "6%" },
                                         { "width": "10%" },
                                   

                                ]
                            });
                 
                            $('#dataemp13').DataTable().clear().draw();
                            for (var i = 0; i < data.length ; i++) {
                       
                                fullname = data[i].title + "." + data[i].fname + " " + data[i].mname + " " + data[i].lname;
                                // totalremainsamt = totalremainsamt + parseFloat(data[i].amount);
                                var ddyear1 = data[i].fromdate;
                                var ddyear2 = data[i].todate;
                                var dtyear1 = new Date(ddyear1);
                                var dtyear2 = new Date(ddyear2);
                                var stryr = dtyear1.getFullYear() + "-" + dtyear2.getFullYear();
                                table.row.add([
                                  data[i].studid, fullname, stryr,data[i].class, data[i].division, data[i].totaltution, data[i].paymentdt,data[i].paymode, data[i].chequenos
                                ]).draw(false);
                                total = total + parseFloat(data[i].totaltution);

                            }
                            if (total > 0) {
                                $("#totalamt").html(total);
                            } 
                        }
                        else{
                            table = $('#dataemp13').DataTable();
                            table.destroy();
                            clear();
                            $('#dataemp13').DataTable().clear().draw();
                            noty({ text: 'No Records Found!!', layout: 'topRight', type: 'information' });
                            setTimeout(function () { $.noty.closeAll(); }, 3000);
                        }
                    } 
                    else  if($("select[id$=ddlincome]").val() == "exactivityfee"){ total = 0;
                        table = $('#dataemp14').DataTable();
                        table.destroy(); 
                        if (data.d != "") {
                            data = JSON.parse(data.d);
                            $("#tbltutions").hide();$("#tbltutions1").hide();  $("#tbltutions2").hide();$("#tbltutions3").hide();$("#tbltutions5").hide(); $("#tbltutions6").hide();$("#tbltutions7").hide();  $("#tbltutions8").hide();$("#tbltutions9").hide();$("#tbltutions10").hide(); $("#tbltutions11").hide();$("#tbltutions12").hide();  $("#tbltutions13").hide();$("#tbltutions4").hide();$("#tbltutions15").hide();
                            $("#tbltutions14").show();
                            var table = $('#dataemp14').DataTable({
                                "order": [[0, "asc"]],
                                "ordering": false,
                                "pageLength": 10,
                                //"lengthMenu": [[10, 25, 50, -1], [10, 25, 50, "All"]],
                                "dom": 'lBfrtip',
                          
                                //responsive: true,
                                //select: {
                                //    style: 'single'
                                //},
                                buttons: [
                                {
                                    extend: 'excelHtml5',
                                    text: 'Export to Excel',
                                    title: 'ExtraActivity Report',
                                    download: 'open',
                                    orientation: 'landscape',
                                    exportOptions: {
                                        columns: ':visible'
                                    }
                                }],
                                "columns": [
                                         { "width": "5%" },
                                         { "width": "8%" },
                                         { "width": "10%" },
                                          { "width": "10%" },
                                         { "width": "14%" },
                                         { "width": "10%" },
                                         { "width": "7%" },
                                         { "width": "6%" },
                                         { "width": "10%" },
                                   

                                ]
                            });
                 
                            $('#dataemp14').DataTable().clear().draw();
                            for (var i = 0; i < data.length ; i++) {
                       
                                fullname = data[i].title + "." + data[i].fname + " " + data[i].mname + " " + data[i].lname;
                                // totalremainsamt = totalremainsamt + parseFloat(data[i].amount);
                                var ddyear1 = data[i].fromdate;
                                var ddyear2 = data[i].todate;
                                var dtyear1 = new Date(ddyear1);
                                var dtyear2 = new Date(ddyear2);
                                var stryr = dtyear1.getFullYear() + "-" + dtyear2.getFullYear();
                                table.row.add([
                                  data[i].studid, fullname, stryr,data[i].class, data[i].division, data[i].totaltution, data[i].paymentdt,data[i].paymode, data[i].chequenos
                                ]).draw(false);
                                total = total + parseFloat(data[i].totaltution);

                            }
                            if (total > 0) {
                                $("#totalamt").html(total);
                            } 
                        }
                        else{
                            table = $('#dataemp14').DataTable();
                            table.destroy();
                            clear();
                            $('#dataemp14').DataTable().clear().draw();
                            noty({ text: 'No Records Found!!', layout: 'topRight', type: 'information' });
                            setTimeout(function () { $.noty.closeAll(); }, 3000);
                        }
                    } 
                    else  if($("select[id$=ddlincome]").val() == "developfee"){ total = 0;
                        table = $('#dataemp15').DataTable();
                        table.destroy(); 
                        if (data.d != "") {
                            data = JSON.parse(data.d);
                            $("#tbltutions").hide();$("#tbltutions1").hide();  $("#tbltutions2").hide();$("#tbltutions3").hide();$("#tbltutions5").hide(); $("#tbltutions6").hide();$("#tbltutions7").hide();  $("#tbltutions8").hide();$("#tbltutions9").hide();$("#tbltutions10").hide(); $("#tbltutions11").hide();$("#tbltutions12").hide();  $("#tbltutions13").hide();$("#tbltutions14").hide();$("#tbltutions4").hide();
                            $("#tbltutions15").show();
                            var table = $('#dataemp15').DataTable({
                                "order": [[0, "asc"]],
                                "ordering": false,
                                "pageLength": 10,
                                //"lengthMenu": [[10, 25, 50, -1], [10, 25, 50, "All"]],
                                "dom": 'lBfrtip',
                          
                                //responsive: true,
                                //select: {
                                //    style: 'single'
                                //},
                                buttons: [
                                {
                                    extend: 'excelHtml5',
                                    text: 'Export to Excel',
                                    title: 'Development Fee Report',
                                    download: 'open',
                                    orientation: 'landscape',
                                    exportOptions: {
                                        columns: ':visible'
                                    }
                                }],
                                "columns": [
                                         { "width": "5%" },
                                         { "width": "8%" },
                                         { "width": "10%" },
                                          { "width": "10%" },
                                         { "width": "14%" },
                                         { "width": "10%" },
                                         { "width": "7%" },
                                         { "width": "6%" },
                                         { "width": "10%" },
                                   

                                ]
                            });
                 
                            $('#dataemp15').DataTable().clear().draw();
                            for (var i = 0; i < data.length ; i++) {
                       
                                fullname = data[i].title + "." + data[i].fname + " " + data[i].mname + " " + data[i].lname;
                                // totalremainsamt = totalremainsamt + parseFloat(data[i].amount);
                                var ddyear1 = data[i].fromdate;
                                var ddyear2 = data[i].todate;
                                var dtyear1 = new Date(ddyear1);
                                var dtyear2 = new Date(ddyear2);
                                var stryr = dtyear1.getFullYear() + "-" + dtyear2.getFullYear();
                                table.row.add([
                                  data[i].studid, fullname, stryr,data[i].class, data[i].division, data[i].totaltution, data[i].paymentdt,data[i].paymode, data[i].chequenos
                                ]).draw(false);
                                total = total + parseFloat(data[i].totaltution);

                            }
                            if (total > 0) {
                                $("#totalamt").html(total);
                            }
                        }
                        else{
                            table = $('#dataemp15').DataTable();
                            table.destroy();
                            clear();
                            $('#dataemp15').DataTable().clear().draw();
                            noty({ text: 'No Records Found!!', layout: 'topRight', type: 'information' });
                            setTimeout(function () { $.noty.closeAll(); }, 3000);
                        }
                    }
                     
                    
                },
                error: function () {
                    //alert("Error in display");
                    noty({ text: 'Get Error', layout: 'topRight', type: 'error' });
                    setTimeout(function () { $.noty.closeAll(); }, 3000);
                }

            });
        }
    </script>
      <div class="page-wrapper">
			<div class="page-content">
                <h6>Fee Headwise  Report</h6>

				<div class="card">
					<div class="card-body">
						<div class="card-title d-flex align-items-center">

						</div>
						<hr />
						<form class="row g-2">
							

						<%--	<h6 style="background-color:#00a65a; color: white;text-align:center;font-size:16px">Other Income Voucher</h6>--%>
							<div class="col-md-2"></div>
							<div style="">

							<div class="row">
                                 <div class="col-md-2">
									<label> From<font color="#000000">*</font> </label>
									<input type="date" id="incomedate" class="form-control" />
								</div>
                                 <div class="col-md-2">
									<label>To<font color="#000000">*</font> </label>
									<input type="date" id="incomedate1" class="form-control" />
								</div>
                                  <div class="col-md-2">
									<label>Year <font color="#000000">*</font></label>
									<select id="ddlyears" class="form-select">
                                    
                                         
									</select>
								</div>
                                       <div class="col-md-2">
									<label>Class <font color="#000000">*</font></label>
									<select id="ddlclass" class="form-select">
                                    
                                         
									</select>
								</div>
                                <div class="col-md-2">
									<label>Division <font color="#000000">*</font></label>
									<select id="ddldivision" class="form-select">
                                    
                                         
									</select>
								</div>
                                 
                                  <div class="col-md-2">
									<label>Fee Head <font color="#000000">*</font></label>
									<select id="ddlincome" class="form-select">
                                  
                                         <option value="">Select Head</option>
                                        <option value="tuitionfee">tuitionfee</option>
                                        <option value="admissionfee">admissionfee</option>
                                        <option value="cautionmny">cautionmny</option>
                                        <option value="collegefee">collegefee</option>
                                        <option value="identycrdfee">identycrdfee</option>
                                        <option value="insurance">insurance</option>
                                          <option value="unifees">unifees</option>
                                          <option value="busfee">busfee</option>
                                        <option value="eligibilityfee"> eligibilityfee</option>
                                         <option value="exminfee"> exminfee</option>
                                         <option value="enrollfee"> enrollfee</option>
                                         <option value="lockerfee"> lockerfee</option>
                                         <option value="gamespofee"> gamespofee</option>
                                        <option value="boardfee"> boardfee</option>
                                        <option value="exactivityfee"> exactivityfee</option>
                                         <option value="developfee"> developfee</option>
									</select>
                                      </div>
                                     <div class="col-md-2">
									<label>Pay Mode <font color="#000000">*</font></label>
									<select id="ddlpaymode" class="form-select">
                                            <option value="cash"> Cash</option>
                                        <option value="cheque"> Cheque</option>
                                         <option value="dd"> DD</option>
                                        </select>
                                         </div>
                                <div class="col-md-2" style="margin-top:20px">
								<div class="btn btn-primary">
									<div class="ms-2" id="" onclick="GetData();"> Search </div></div>
								

							</div>
                                </div> 
                                </div> 
                            </form>
                            </div>
                    </div> 
                <hr />
                  <div class="card">
                     
					<div class="card-body">
                    <div class="card-title d-flex align-items-center">
                      
                        
                     </div>
                         <div class="row">
                    <div class="col-md-12">
                            <div class="col-md-3">
                        <label>Total Cash :</label> &nbsp; <label id="totalamt"></label>
                        </div>
                            <div class="col-md-4"></div>
                         <div class="col-md-3" style="float:right;margin-bottom:3px">
                              <button class="btn btn-primary" type="button" style=""  onclick="ExportDataExam();"> Export Data</button>
                             </div>
					
						</div>
						</div>
                               <div class="table-responsive" style="display:none" id="tbltutions">
                                    <table id="dataemp" class="table table-striped table-bordered">
								   
                                <thead> <tr><th>Student ID</th><th>Student Name</th><th>Year</th><th>Class Name</th> <th>Divison</th> <th>Tution Fee</th>	  <th>Payment Date</th>  <th>Payment Mode</th> <th>UTR No.</th> </tr></thead>
								
							   </table>
                    </div>
                         <div class="table-responsive" style="display:none" id="tbltutions1">
                                    <table id="dataemp1" class="table table-striped table-bordered">
								   
                                <thead> <tr><th>Student ID</th><th>Student Name</th><th>Year</th><th>Class Name</th> <th>Divison</th> <th>admissionfee</th>	  <th>Payment Date</th>  <th>Payment Mode</th> <th>UTR No.</th> </tr></thead>
								
							   </table>
                    </div>
                         <div class="table-responsive" style="display:none" id="tbltutions2">
                                    <table id="dataemp2" class="table table-striped table-bordered">
								   
                                <thead> <tr><th>Student ID</th><th>Student Name</th><th>Year</th><th>Class Name</th> <th>Divison</th> <th>cautionmny</th>	  <th>Payment Date</th>  <th>Payment Mode</th> <th>UTR No.</th> </tr></thead>
								
							   </table>
                    </div>
                         <div class="table-responsive" style="display:none" id="tbltutions3">
                                    <table id="dataemp3" class="table table-striped table-bordered">
								   
                                <thead> <tr><th>Student ID</th><th>Student Name</th><th>Year</th><th>Class Name</th> <th>Divison</th> <th>collegefee</th>	  <th>Payment Date</th>  <th>Payment Mode</th> <th>UTR No.</th> </tr></thead>
								
							   </table>
                    </div>
                         <div class="table-responsive" style="display:none" id="tbltutions4">
                                    <table id="dataemp4" class="table table-striped table-bordered">
								   
                                <thead> <tr><th>Student ID</th><th>Student Name</th><th>Year</th><th>Class Name</th> <th>Divison</th> <th>identycrdfee</th>	  <th>Payment Date</th>  <th>Payment Mode</th> <th>UTR No.</th> </tr></thead>
								
							   </table>
                    </div>
                         <div class="table-responsive" style="display:none" id="tbltutions5">
                                    <table id="dataemp5" class="table table-striped table-bordered">
								   
                                <thead> <tr><th>Student ID</th><th>Student Name</th><th>Year</th><th>Class Name</th> <th>Divison</th> <th>insurance</th>	  <th>Payment Date</th>  <th>Payment Mode</th> <th>UTR No.</th> </tr></thead>
								
							   </table>
                    </div>
                         <div class="table-responsive" style="display:none" id="tbltutions6">
                                    <table id="dataemp6" class="table table-striped table-bordered">
								   
                                <thead> <tr><th>Student ID</th><th>Student Name</th><th>Year</th><th>Class Name</th> <th>Divison</th> <th>unifees</th>	  <th>Payment Date</th>  <th>Payment Mode</th> <th>UTR No.</th> </tr></thead>
								
							   </table>
                    </div>
                         <div class="table-responsive" style="display:none" id="tbltutions7">
                                    <table id="dataemp7" class="table table-striped table-bordered">
								   
                                <thead> <tr><th>Student ID</th><th>Student Name</th><th>Year</th><th>Class Name</th> <th>Divison</th> <th>busfee</th>	  <th>Payment Date</th>  <th>Payment Mode</th> <th>UTR No.</th> </tr></thead>
								
							   </table>
                    </div>
                         <div class="table-responsive" style="display:none" id="tbltutions8">
                                    <table id="dataemp8" class="table table-striped table-bordered">
								   
                                <thead> <tr><th>Student ID</th><th>Student Name</th><th>Year</th><th>Class Name</th> <th>Divison</th> <th>eligibilityfee</th>	  <th>Payment Date</th>  <th>Payment Mode</th> <th>UTR No.</th> </tr></thead>
								
							   </table>
                    </div>
                         <div class="table-responsive" style="display:none" id="tbltutions9">
                                    <table id="dataemp9" class="table table-striped table-bordered">
								   
                                <thead> <tr><th>Student ID</th><th>Student Name</th><th>Year</th><th>Class Name</th> <th>Divison</th> <th>exminfee</th>	  <th>Payment Date</th>  <th>Payment Mode</th> <th>UTR No.</th> </tr></thead>
								
							   </table>
                    </div> 
                        <div class="table-responsive" style="display:none" id="tbltutions10">
                                    <table id="dataemp10" class="table table-striped table-bordered">
								   
                                <thead> <tr><th>Student ID</th><th>Student Name</th><th>Year</th><th>Class Name</th> <th>Divison</th> <th>enrollfee</th>	  <th>Payment Date</th>  <th>Payment Mode</th> <th>UTR No.</th> </tr></thead>
								
							   </table>
                    </div>
                        <div class="table-responsive" style="display:none" id="tbltutions11">
                                    <table id="dataemp11" class="table table-striped table-bordered">
								   
                                <thead> <tr><th>Student ID</th><th>Student Name</th><th>Year</th><th>Class Name</th> <th>Divison</th> <th>lockerfee</th>	  <th>Payment Date</th>  <th>Payment Mode</th> <th>UTR No.</th> </tr></thead>
								
							   </table>
                    </div>
                        <div class="table-responsive" style="display:none" id="tbltutions12">
                                    <table id="dataemp12" class="table table-striped table-bordered">
								   
                                <thead> <tr><th>Student ID</th><th>Student Name</th><th>Year</th><th>Class Name</th> <th>Divison</th> <th>gamespofee</th>	  <th>Payment Date</th>  <th>Payment Mode</th> <th>UTR No.</th> </tr></thead>
								
							   </table>
                    </div> 
                         <div class="table-responsive" style="display:none" id="tbltutions13">
                                    <table id="dataemp13" class="table table-striped table-bordered">
								   
                                <thead> <tr><th>Student ID</th><th>Student Name</th><th>Year</th><th>Class Name</th> <th>Divison</th> <th>boardfee</th>	  <th>Payment Date</th>  <th>Payment Mode</th> <th>UTR No.</th> </tr></thead>
								
							   </table>
                    </div> 
                        <div class="table-responsive" style="display:none" id="tbltutions14">
                                    <table id="dataemp14" class="table table-striped table-bordered">
								   
                                <thead> <tr><th>Student ID</th><th>Student Name</th><th>Year</th><th>Class Name</th> <th>Divison</th> <th>exactivityfee</th>	  <th>Payment Date</th>  <th>Payment Mode</th> <th>UTR No.</th> </tr></thead>
								
							   </table>
                    </div>
                         <div class="table-responsive" style="display:none" id="tbltutions15">
                                    <table id="dataemp15" class="table table-striped table-bordered">
								   
                                <thead> <tr><th>Student ID</th><th>Student Name</th><th>Year</th><th>Class Name</th> <th>Divison</th> <th>developfee</th>	  <th>Payment Date</th>  <th>Payment Mode</th> <th>UTR No.</th> </tr></thead>
								
							   </table>
                    </div>
                        
                            </div>
					</div>
                </div> 
          </div>
</asp:Content>