{% include 'layouts/header.html' %}
<script src="moment/moment.js"></script>

<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-8">
                <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-2"></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>
                        </div>
                        <hr>
                        <button type="button" class="btn btn-primary exportToExcel" style="float: right">Export To Excel</button>
                        <br><br>
                        <div>
                            <table id="zero_config" class="table table-striped table-bordered table2excel table2excel_with_colors" style="max-height:500px;overflow:auto;display: block">
                                <thead style="margin-left: -2px;">
                                    <tr style="background-color: #2255a4;color: white;text-align: center">
                                        {% if school_data!='' %}
                                        <th colspan="13"> શાળાનુ નામ  - {{school_data[0].name}}   </th>
                                        {% else %}
                                        <th colspan="13"> શાળાનુ નામ  - </th>
                                        {% endif %}
                                        <!--<th> </th>-->
                                    </tr>
                                     <tr style="background-color: #2255a4;color: white;text-align: center">
                                        {% if school_data!='' %}
                                        <th colspan="13"> શાળાનુ સરનામું  -{{school_data[0].address}} , {{school_data[0].taluko}} , {{school_data[0].dist}}   </th>
                                        {% else %}
                                        <th colspan="13"> શાળાનુ સરનામું  - </th>
                                        {% endif %}
                                        <!--<th> </th>-->
                                    </tr>
                                    <tr style="background-color: #2255a4;color: white;text-align: center">
                                        <th> ક્રમ </th>
                                        <th> શૈક્ષણિક વર્ષ </th>
                                        <th> ધોરણ </th>
                                        <th> વર્ગ </th>
                                        <th> જી. આર. નં. </th>
                                        <th> હાજર દિવસ </th>
                                        <th> હાજરીપત્રક નં </th>
                                        <th style="white-space: nowrap"> વિદ્યાર્થીનું નામ </th>
                                        <th> કન્યા/ કુમાર </th>
                                        <th> જાતિ </th>
                                        <th style="white-space: nowrap"> સરનામું </th>
                                        <th> જન્મ તારીખ </th>
                                        <th> મોબાઇલ નં </th>
                                    </tr>
                                </thead>
                                <tbody id="tablebody">
                                <script type="text/javascript">
var sr = 1;
                                </script>
                                {% for i in data %}

                                <tr id="{{ i.id }}" style="background-color: #d0dee9;text-align: center">
                                    <td id="sr{{ i.id }}"></td>
                                <script type="text/javascript">
                                    document.getElementById("sr{{ i.id }}").innerHTML = sr;
                                </script>

                                <td>{{ i.year }}</td>
                                <td>{{ i.std_name }}</td>
                                <td>{{ i.class_name }}</td>
                                <td>{{ i.G_r_no }}</td>
                                <td>{{ i.present_day }}</td>
                                <td>{{ i.roll_no }}</td>
                                <td style="white-space: nowrap">{{ i.name }}</td>
                                <td>{{ i.gender }}</td>
                                <td>{{ i.caste }}</td>
                                <td style="white-space: nowrap">{{ i.address }}</td>
                                <td style="white-space: nowrap">{{ i.dob }}</td> 
                                <td>{{ i.mobile_no }}</td>
                                
                                </tr>
                                <script type="text/javascript">
                                    var sr = sr + 1;
                                </script>
                                {% endfor %}

                                </tbody>
                            </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);
    }*/


    /*    scrollbar set
        tbody {
            display:block;
            max-height:400px;
            overflow:auto;
        }
        thead, tbody tr {
            display:table;
            width:100%;
            table-layout:fixed;
        }
        thead {
            width: calc( 100% - 1em )
        }
        table {
            width:400px;
        }
        #tablebody::-webkit-scrollbar {
            width: 5px;
        }
    
        ::-webkit-scrollbar-thumb {
            background: blue; 
            border-radius: 10px;
        }*/
</style>


<script type="text/javascript">


                                    function str_reverse(birth_date1)
                                    {
//        alert('hello ' + birth_date1);
//                                        alert(birth_date1.reverse());
                                        return birth_date1.reverse();
                                    }
                                    $(document).ready(function () {

                                        $(document.body).on('click', '.exportToExcel', function (e) {
//                                        $(".exportToExcel").click(function (e) {
                                            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_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_student/view_student_class',
                                                success: function (data) {
                                                    debugger;
                                                    $('#tablebody').html('');
                                                    $('#tablebody').html(data);
                                                    $("#search_select_std").val(std_value);
                                                    
//                                                    $('#action_col').remove();
                                                    $('.action_col_data').remove();
                                                }, 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;
                                            $.ajax({
                                                cache: false,
                                                type: 'POST',
                                                async: false,
                                                data: JSON.stringify(data),
                                                contentType: 'application/json',
                                                url: '/manage_student/view_student_std',
                                                success: function (data) {
                                                    debugger;
                                                    $('#search_view_data').html('');
                                                    $('#search_view_data').html(data);
                                                    $("#search_select_year").val(year_value);
                                                    $("#search_select_std").val(std_value);
                                                    
                                                    $('#action_col').remove();
                                                    $('.action_col_data').remove();
                                                }, 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_student/view_student_academic_year',
                                                success: function (data) {
                                                    debugger;
//                    alert('data ' + data);
                                                    $('#search_view_data').html('');
                                                    $('#search_view_data').html(data);
                                                    $("#search_select_year").val(year_value);
                                                    $('#action_col').remove();
                                                    $('.action_col_data').remove();
                                                }, error: function (xhr, err) {
                                                    alert('Error ' + err.message);
                                                }
                                            });
                                        })
                                    });


                                    function addUser() {
                                        window.location.href = '/student_report';
                                    }
</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>