{% include 'layouts/header.html' %}

<div class="page-wrapper">
    <!-- ============================================================== -->
    <!-- Bread crumb and right sidebar toggle -->
    <!-- ============================================================== -->
    <div class="page-breadcrumb">
        <div class="row">
            <div class="col-12 d-flex no-block align-items-center">
                <h4 class="page-title"> રિપોટૅ </h4>
                <div class="ml-auto text-right">
                    <nav aria-label="breadcrumb">
                        <ol class="breadcrumb">
                            <li class="breadcrumb-item"><a href="/home">Home</a></li>
                            <li class="breadcrumb-item active" aria-current="page"> રિપોટૅ </li>
                        </ol>
                    </nav>
                </div>
            </div>
        </div>
    </div>
    <!-- ============================================================== -->
    <!-- End Bread crumb and right sidebar toggle -->
    <!-- ============================================================== -->
    <!-- ============================================================== -->
    <!-- Container fluid  -->
    <!-- ============================================================== -->
    <div class="container-fluid" id="all_year_info">
        <!-- ============================================================== -->
        <!-- Start Page Content -->
        <!-- ============================================================== -->
        <div class="row">
            <div class="col-md-2"></div>
            <div class="col-md-12">
                <div class="card" id="year_data">

                </div>
            </div>
            <!--<div class="col-md-2"></div>-->
        </div>
        <div class="row">
            <div class="col-md-12">
                <div class="card table_year_data">
                    <div class="card-body" id="search_view_data">
                        <!--<h5 class="card-title m-b-0">Class Info</h5>-->
                        <div class="row" style="padding-left: 10px;padding-right: 15px;">
                            <h5 class="card-title m-b-0 col-sm-2" style="padding-top: 10px;"> ગુણ પત્રક ની માહિતી </h5>
                            <!--<h5 class="card-title m-b-0 col-sm-1"></h5>-->
                            <label class="card-title col-sm-1" style="padding-top: 10px;"> Search by </label>
                            <select class="form-control col-sm-2" id="search_select_year" style="height:36px;margin-right: 10px" tabindex="1" aria-hidden="true">
                                <option value="શૈક્ષણિક વર્ષ પસંદ કરો" id="0">શૈક્ષણિક વર્ષ પસંદ કરો</option>

                                {% for j in year_data %}
                                <option value="{{ j.year}}" id="{{ j.id}}">{{ j.year}}</option>
                                {% endfor %}
                            </select>
                            <select class="form-control col-sm-2" id="search_select_std" style="height:36px;margin-right: 10px" tabindex="2" aria-hidden="true">
                                <option value="ધોરણ પસંદ કરો" disabled selected id="0">ધોરણ પસંદ કરો</option>
                            </select>
                            <select class="form-control col-sm-2" id="search_select_class" style="height:36px;margin-right: 10px" tabindex="3" aria-hidden="true">
                                <option value="વર્ગ પસંદ કરો" disabled selected id="0">વર્ગ પસંદ કરો</option>
                            </select>
                            <select class="form-control col-sm-2" id="search_select_roll_no" style="height:36px;margin-right: 10px" tabindex="4" aria-hidden="true">
                                <option value="હાજરીપત્રક નં. પસંદ કરો" disabled selected id="0">હાજરીપત્રક નં. પસંદ કરો</option>
                            </select>
                        </div>
                        <hr>

                        <div class="table-responsive" style="max-height: 560px">
                            <script type="text/javascript">
                                var sr = 1;
                            </script>
                            <table id="zero_config" class="table table-striped table-bordered table2excel table2excel_with_colors">

                            </table>
                        </div>


                    </div>
                </div>
            </div>
        </div>
    </div>
    <!-- ============================================================== -->
    <!-- End Container fluid  -->
    <!-- ============================================================== -->
    <!-- ============================================================== -->
    <!-- footer -->
    <!-- ============================================================== -->
    <footer class="footer text-center">
        All Rights Reserved by Rudra-infotech. Designed and Developed by <a href="http://rudra-infotech.com/">Rudra Infotech</a>.
    </footer>
    <!-- ============================================================== -->
    <!-- End footer -->
    <!-- ============================================================== -->
</div>

<!-- ============================================================== -->
<!-- End Page wrapper  -->
<!-- ============================================================== -->
</div>
<!-- ============================================================== -->
<!-- End Wrapper -->
<!-- ============================================================== -->
<!-- ============================================================== -->
<!-- All Jquery -->
<!-- ============================================================== -->

<div class="modal fade" id="myModal" role="dialog">
    <div class="modal-dialog">

        <!-- Modal content-->
        <div class="modal-content">
            <div class="modal-header">
                <!--<button type="button" class="close" data-dismiss="modal">&times;</button>-->
                <h4 class="modal-title">Confirmation</h4>
            </div>
            <div class="modal-body">
                <p style="color: red"> are you sure you want to delete this record? </p>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-danger delete" data-dismiss="modal">Delete</button>
                <button type="button" class="btn btn-default close_model" data-dismiss="modal">Cancel</button>
            </div>
        </div>

    </div>
</div>

<div class="modal fade" id="myModal_msg" role="dialog">
    <div class="modal-dialog">

        <!-- Modal content-->
        <div class="modal-content">
            <div class="modal-header">
                <!--<button type="button" class="close" data-dismiss="modal">&times;</button>-->
                <h4 class="modal-title">Message</h4>
            </div>
            <div class="modal-body">
                <p style="color: green"> * Record Successfully Deleted. </p>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-danger" data-dismiss="modal">Ok</button>
            </div>
        </div>

    </div>
</div>
<!--open model-->
<!--<link rel="stylesheet" href="model_bootstrap/css/bootstrap.min.css">-->
<script src="model_bootstrap/js/jquery.min.js"></script>
<script src="model_bootstrap/js/bootstrap.min.js"></script>

<script src="assets/libs/jquery/dist/jquery.min.js"></script>
<!-- Bootstrap tether Core JavaScript -->
<script src="assets/libs/popper.js/dist/umd/popper.min.js"></script>
<script src="assets/libs/bootstrap/dist/js/bootstrap.min.js"></script>
<!-- slimscrollbar scrollbar JavaScript -->
<script src="assets/libs/perfect-scrollbar/dist/perfect-scrollbar.jquery.min.js"></script>
<script src="assets/extra-libs/sparkline/sparkline.js"></script>
<!--Wave Effects -->
<script src="dist/js/waves.js"></script>
<!--Menu sidebar -->
<script src="dist/js/sidebarmenu.js"></script>
<!--Custom JavaScript -->
<script src="dist/js/custom.min.js"></script>
<!-- This Page JS -->
<script src="assets/libs/inputmask/dist/min/jquery.inputmask.bundle.min.js"></script>
<script src="dist/js/pages/mask/mask.init.js"></script>
<script src="assets/libs/select2/dist/js/select2.full.min.js"></script>
<script src="assets/libs/select2/dist/js/select2.min.js"></script>
<script src="assets/libs/jquery-asColor/dist/jquery-asColor.min.js"></script>
<script src="assets/libs/jquery-asGradient/dist/jquery-asGradient.js"></script>
<script src="assets/libs/jquery-asColorPicker/dist/jquery-asColorPicker.min.js"></script>
<script src="assets/libs/jquery-minicolors/jquery.minicolors.min.js"></script>
<script src="assets/libs/bootstrap-datepicker/dist/js/bootstrap-datepicker.min.js"></script>
<script src="assets/libs/quill/dist/quill.min.js"></script>


<script src="export/jquery.table2excel.js"></script>

<style>
    /*for print serial no in table*/
    /*    body
        {
            counter-reset: Serial;           
        }*/
    table
    {
        border-collapse: separate;
    }
    /*    tr td:first-child:before
        {
            counter-increment: Serial;
            content:  counter(Serial);
        }*/


    th.rotate {
        /* Something you can count on */
        height: 210px;
        white-space: nowrap;
    }

    th.rotate > div {
        transform: 
            translate(2px, 84px)
            rotate(-91deg);
        width: 30px;
    }

    th.rotate > div.vyakti_data {
        transform: 
            /* Magic Numbers */
            /*translate(25px, 51px)*/
            translate(2px, 95px)
            /* 45 is really 360 - 45 */
            rotate(-91deg);
        /*rotate(315deg);*/
        width: 30px;
    }

    th.rotate > div.total_data {
        transform: 
            /* Magic Numbers */
            /*translate(25px, 51px)*/
            translate(2px, 120px)
            /* 45 is really 360 - 45 */
            rotate(-91deg);
        /*rotate(315deg);*/
        width: 30px;
    }

    th.rotate > div > span {
        border-bottom: 1px solid #ccc;
        padding: 5px 10px;
    }

</style>



<script type="text/javascript">

                                $(document).ready(function () {

                                    $(document.body).on('click', '.exportToExcel', function (e) {
//            alert('alert');
                                        var table = $('.table2excel');
                                        if (table && table.length) {
//                var preserveColors = (table.hasClass('table2excel_with_colors') ? true : false);
                                            var preserveColors = (table.hasClass('table2excel_with_colors') ? false : true);
                                            $(table).table2excel({
                                                exclude: ".noExl",
                                                name: "Excel Document Name",
                                                filename: "પરિણામ_" + new Date().toUTCString().replace(/[\-\:\.]/g, "") + ".xls",
                                                fileext: ".xls",
                                                exclude_img: true,
                                                exclude_links: true,
                                                exclude_inputs: true,
                                                preserveColors: preserveColors
                                            });
                                        }
                                    })


                                    $(document.body).on('change', '#search_select_roll_no', function (e) {
                                        var id = $('#search_select_roll_no').find('option:selected').attr('id');

                                        var class_id = $('#search_select_class').find('option:selected').attr('id');
                                        var class_value = $('#search_select_class').find('option:selected').attr('value');

                                        var year_id = $('#search_select_year').find('option:selected').attr('id');
                                        var std_id = $('#search_select_std').find('option:selected').attr('id');
                                        var std_value = $('#search_select_std').find('option:selected').attr('value');
                                        var year_value = $('#search_select_year').find('option:selected').attr('value');


                                        var data = {};
                                        data.id = id;
                                        data.std_id = std_id;
                                        $.ajax({
                                            type: 'POST',
                                            data: JSON.stringify(data),
                                            contentType: 'application/json',
                                            url: '/manage_result/select_data_roll_no',
                                            success: function (data) {
                                                debugger;
                                                $('#zero_config').html('');
                                                $('#zero_config').html(data);

                                                $("#tbl_year").html('શૈક્ષણિક વર્ષ - ' + year_value);
                                                $("#tbl_std").html('ધોરણ - ' + std_value);
                                                $("#tbl_class").html('વર્ગ - ' + class_value);
                                                
                                                $('#actions').remove();
                                                $('#last_line').remove();
                                                $('.action_col_data_last').remove();
                                                $('.action_col_data').remove();
                                            }, error: function (xhr, err) {
                                                alert('Error ' + err.message);
                                            }
                                        });
                                    })

                                    $(document.body).on('change', '#search_select_class', function (e) {
                                        var id = $('#search_select_class').find('option:selected').attr('id');
                                        var class_value = $('#search_select_class').find('option:selected').attr('value');

                                        var year_id = $('#search_select_year').find('option:selected').attr('id');
                                        var std_id = $('#search_select_std').find('option:selected').attr('id');
                                        var std_value = $('#search_select_std').find('option:selected').attr('value');
                                        var year_value = $('#search_select_year').find('option:selected').attr('value');
                                        var data = {};
                                        data.id = id;
                                        data.year_id = year_id;
                                        data.std_id = std_id;

                                        $.ajax({
                                            cache: false,
                                            type: 'POST',
                                            async: false,
                                            data: JSON.stringify(data),
                                            contentType: 'application/json',
                                            url: '/manage_result/view_year_class',
                                            success: function (data) {
                                                debugger;
//                    alert('data ' + data);
                                                $('#search_view_data').html('');
                                                $('#search_view_data').html(data);
                                                $("#search_select_year").val(year_value);
                                                $("#search_select_std").val(std_value);
                                                $("#search_select_class").val(class_value);

                                                $("#tbl_year").html('શૈક્ષણિક વર્ષ - ' + year_value);
                                                $("#tbl_std").html('ધોરણ - ' + std_value);
                                                $("#tbl_class").html('વર્ગ - ' + class_value);
                                                
                                                $('#disp_data1').remove();
                                                $('#disp_data2').remove();
                                                
                                                $('#actions').remove();
                                                $('#last_line').remove();
                                                $('.action_col_data_last').remove();
                                                $('.action_col_data').remove();
                                                $('#title_name').html('ગુણ પત્રક ની માહિતી');

                                            }, error: function (xhr, err) {
                                                alert('Error ' + err.message);
                                            }
                                        });
                                    })
//    
                                    $(document.body).on('change', '#search_select_std', function (e) {
                                        var year_id = $('#search_select_year').find('option:selected').attr('id');
                                        var id = $('#search_select_std').find('option:selected').attr('id');
                                        var std_value = $('#search_select_std').find('option:selected').attr('value');
                                        var year_value = $('#search_select_year').find('option:selected').attr('value');
                                        var data = {};
                                        data.id = id;
                                        data.year_id = year_id;
                                        data.std_id = id;
                                        $.ajax({
                                            cache: false,
                                            type: 'POST',
                                            async: false,
                                            data: JSON.stringify(data),
                                            contentType: 'application/json',
                                            url: '/manage_result/view_result_std',
                                            success: function (data) {
                                                debugger;
//                    alert('data ' + data);
                                                $('#search_view_data').html('');
                                                $('#search_view_data').html(data);
                                                $("#search_select_year").val(year_value);
                                                $("#search_select_std").val(std_value);

                                                $("#tbl_year").html('શૈક્ષણિક વર્ષ - ' + year_value);
                                                $("#tbl_std").html('ધોરણ - ' + std_value);
                                                $("#tbl_class").html('વર્ગ - ');

                                                $('#disp_data1').remove();
                                                $('#disp_data2').remove();
                                                
                                                $('#actions').remove();
                                                $('#last_line').remove();
                                                $('.action_col_data_last').remove();
                                                $('.action_col_data').remove();
                                                $('#title_name').html('ગુણ પત્રક ની માહિતી');

                                            }, error: function (xhr, err) {
                                                alert('Error ' + err.message);
                                            }
                                        });
                                    })

                                    $(document.body).on('change', '#search_select_year', function (e) {
                                        var id = $('#search_select_year').find('option:selected').attr('id');
                                        var year_value = $('#search_select_year').find('option:selected').attr('value');

                                        var data = {};
                                        data.id = id;
                                        $.ajax({
                                            cache: false,
                                            type: 'POST',
                                            async: false,
                                            data: JSON.stringify(data),
                                            contentType: 'application/json',
                                            url: '/manage_result/view_result_academic_year',
                                            success: function (data) {
                                                debugger;
//                    alert('data ' + data);
                                                $('#search_select_std').html('');
                                                $('#search_select_std').html(data);
                                                $("#search_select_year").val(year_value);
                                            }, error: function (xhr, err) {
                                                alert('Error ' + err.message);
                                            }
                                        });
                                    })
                                });


                                function addUser() {
                                    window.location.href = '/manage_result';
                                }
</script>
<script>
//***********************************//
// For select 2
//***********************************//
    $(".select2").select2();

    /*colorpicker*/
    $('.demo').each(function () {
        //
        // Dear reader, it's actually very easy to initialize MiniColors. For example:
        //
        //  $(selector).minicolors();
        //
        // The way I've done it below is just for the demo, so don't get confused
        // by it. Also, data- attributes aren't supported at this time...they're
        // only used for this demo.
        //
        $(this).minicolors({
            control: $(this).attr('data-control') || 'hue',
            position: $(this).attr('data-position') || 'bottom left',
            change: function (value, opacity) {
                if (!value)
                    return;
                if (opacity)
                    value += ', ' + opacity;
                if (typeof console === 'object') {
                    console.log(value);
                }
            },
            theme: 'bootstrap'
        });

    });
    /*datwpicker*/
    jQuery('.mydatepicker').datepicker();
    jQuery('#datepicker-autoclose').datepicker({
        autoclose: true,
        todayHighlight: true
    });
    var quill = new Quill('#editor', {
        theme: 'snow'
    });

</script>
</body>

</html>