 <?php
include ('../includes/connection.php');

if(isset($_POST['save'])){ 
$class_id = $_POST['class_id'];  
$subject_id = $_POST['sub_id'];  
$year=date("Y");   
$teacher_roll_no = $_POST['teacher_roll_no']; 
    if(!empty($_POST['selected_students'])){

        foreach($_POST['student_roll_no'] as $key => $student_roll_no){

          $student_id = $_POST['selected_students'][$key];
          // Skip empty marks
              if($student_id == ""){
                  continue;
              }
              
      // CHECK RECORD
          $check_query = mysqli_query($conn,
          "SELECT * FROM students_to_subject
          WHERE
          class_id='$class_id' 
          AND sub_id='$sub_id'
          AND student_roll_no='$student_roll_no'");

          // UPDATE
          if(mysqli_num_rows($check_query) > 0){

              $update = mysqli_query($conn,
              "UPDATE students_to_subject SET

              teacher_roll_no='$teacher_roll_no',
              class_id='$class_id',
              sub_id='$sub_id',
              selected_students='$selected_students',
              student_roll_no='$student_roll_no', 
              Year='$year'

              WHERE
              class_id='$class_id' 
              AND sub_id='$sub_id'
              AND student_roll_no='$student_roll_no'
              ");

              if(!$update){
                  die(mysqli_error($conn));
              }

          }else {
                  // INSERT QUERY
                  $insert = mysqli_query($conn,
                  "INSERT INTO `students_to_subject`(`student_roll_no`, `class_id`, `sub_id`, `teacher_roll_no`, `year`, `selected_students`) VALUES ('$student_roll_no','$class_id','$subject_id','$teacher_roll_no','$year','$student_id')");

              }
            }
              ?>
               <script type="text/javascript">
                   alert("Selected students inserted successfully");
               </script>
              <?php   
          } else {
      ?>
         <script type="text/javascript">
             alert("No student selected");
         </script>
        <?php  
 
    } 
}
?>
 <head>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="icon" type="image/jpg" href="../assets/img/mzumbe1.jpg">
  <title>SARMS | SIKIRARI ACADEMIC RESURT MANAGEMENT SYSTEM</title> 
  <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700&display=fallback">
  <!-- Font Awesome -->
  <link rel="stylesheet" href="../stp_con/fontawesome-free/css/all.min.css">
  <!-- daterange picker -->
  <link rel="stylesheet" href="../stp_con/daterangepicker/daterangepicker.css">
  <!-- iCheck for checkboxes and radio inputs -->
  <link rel="stylesheet" href="../stp_con/icheck-bootstrap/icheck-bootstrap.min.css">
  <!-- Bootstrap Color Picker -->
  <link rel="stylesheet" href="../stp_con/bootstrap-colorpicker/css/bootstrap-colorpicker.min.css">
  <!-- Tempusdominus Bootstrap 4 -->
  <link rel="stylesheet" href="../stp_con/tempusdominus-bootstrap-4/css/tempusdominus-bootstrap-4.min.css">
  <!-- Select2 -->
  <link rel="stylesheet" href="../stp_con/select2/css/select2.min.css">
  <link rel="stylesheet" href="stp_con/select2-bootstrap4-theme/select2-bootstrap4.min.css">
  <!-- Bootstrap4 Duallistbox -->
  <link rel="stylesheet" href="../stp_con/bootstrap4-duallistbox/bootstrap-duallistbox.min.css">
  <!-- BS Stepper -->
  <link rel="stylesheet" href="../stp_con/bs-stepper/css/bs-stepper.min.css">
  <!-- dropzonejs -->
  <link rel="stylesheet" href="../stp_con/dropzone/min/dropzone.min.css">
  <!-- Theme style -->
  <link rel="stylesheet" href="../assets/css/adminlte.min.css">
   <link rel="stylesheet" type="text/css" href="../stp_con/parsley/parsley.css"/>
   
</head>
  <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <br>
    <section class="content-header" >
      <div class="container-fluid">
        <div class="row mb-2">
          <div class="col-sm-6">
            <a><strong>Student information</strong></a>
          </div> 
          <div class="col-sm-6">
            <ol class="breadcrumb float-sm-right">
              <li class="breadcrumb-item"><a href="admin.php?page=dashboad">Home</a></li> 
              <li class="breadcrumb-item active">Students information</li>
            </ol>
          </div>
        </div>
      </div><!-- /.container-fluid -->
    </section> 
   <!-- Main content -->
    <section class="content">
      <div class="container-fluid">
        <div class="row"> 
          <!-- /.col -->
          <div class="col-md-12">
            <div class="card"> 
              <div class="card-header p-2">
                <ul class="nav nav-pills ">
                  <li class="nav-item"><a class="nav-link active" href="#teacher" data-toggle="tab"><i class="fas fa-th-list"></i> Student List</a></li>  
                </ul>
              </div>
              <!-- /.card-header --> 
              <div class="card-body"> 
              <div class="tab-content">
              <!-- /.tab-pane -->
              <div class="active tab-pane" id="teacher">
              <div class="container-fluid">
                <div class="row">
                  <div class="col-sm-12"> 
                  <div class="row"> 
                        <!-- ./col -->
                         <?php   
                            $T_id=$q['teacher_roll_no'];  
                            $selected_teacher = mysqli_query($conn," SELECT * FROM teacher_course ,class_srms WHERE class_srms.class_id=teacher_course.class_id AND teacher_course.teacher_roll_no='$T_id' ");
                              while($row = mysqli_fetch_array($selected_teacher)){ 
                              $cl_id=$row['class_id']; 
                            ?>  
                            <div class="col-lg-3 col-6">
                              <!-- small card -->
                              <div class="small-box bg-info">
                                <div class="inner"> 
                                  <h3><?php
                                  $count = mysqli_query($conn,"SELECT count(student_roll_no) as no_3 FROM student_srms where class_id='$cl_id'");
                                    $no_2 = mysqli_fetch_array($count);
                                   echo $no_2['no_3']; ?></h3> 
                                  <p>A STUDENT OF <?php echo $row['class_name']; ?></p>
                                </div>
                                <div class="icon">
                                  <i class="fas fa-edit"></i>
                                </div> 
                                <a href="admin.php?page=student_list&Id_2=<?php echo $row['class_id']; ?>" class="small-box-footer">
                                  More info <i class="fas fa-arrow-circle-right"></i>
                                </a> 
                              </div>
                            </div> 
                          <?php }?>
                      </div>
                      <br> 
                    <div class="card">  
                      <div class="card-header"> 
                      <?php 
                      $id=$_GET['Id_2'];
                      $allocate = mysqli_query($conn,"SELECT *  FROm  student_srms,class_srms WHERE student_srms.class_id=class_srms.class_id AND student_srms.class_id='$id'");
                      $allo = mysqli_fetch_array($allocate); 
                      if ($allo) {?> 
                      <div class="float-right mb-2"> 
                         <a data-toggle="modal" href="#class_1342" class="btn btn-info btn-lg float-right ml-2" >
                            <i class="fa fa-list"></i>   Allocate student
                        </a> 
                   </div> 
                   <?php } ?>
                    </div>
                  <div class="card-body">
                <div class="table-responsive">
                    <table id="example1" class="table table-striped display table-bordered" >
                      <thead>
                        <tr>
                            <th>#</th> 
                            <th>Reg No</th>
                            <th>Student Name</th>
                            <th>Class Name</th>  
                            <th>Gender</th>  
                        </tr>
                        </thead>
                        <tbody>
                          <?php 
                           $id=$_GET['Id_2'];
                            $i = 1;
                            $selected = mysqli_query($conn,"SELECT  *  FROm  student_srms,class_srms,students_to_subject WHERE student_srms.class_id=class_srms.class_id AND student_srms.student_roll_no=students_to_subject.student_roll_no AND class_srms.class_id='$id' ORDER BY student_srms.student_name ASC");
                             while($row = mysqli_fetch_array($selected)){ 
                              $MD5=$row['student_roll_no'];
                        
                            ?> 
                        <tr>
                          <td class="text-center"><?php echo $i++ ?></td> 
                          <td><?php echo $MD5; ?></td>
                          <td><?php echo $row['student_name']; ?></td>
                          <td><?php echo $row['class_name']; ?></td>  
                          <td><?php echo $row['student_gender']; ?></td>  
                      </tr> 
                      <?php }?> 
                        </tbody>
                        <tfoot>
                        <tr>
                            <th>#</th> 
                            <th>Reg No</th>
                            <th>Student Name</th>
                            <th>Class Name</th>  
                            <th>Gender</th>  
                        </tr>
                      </tfoot>
                    </table> 
                 </div>
               </div>

               <div id="class_1342" class="modal fade ">
                        <div class="modal-dialog modal-lg">
                          <form method="post" action="" id="login_form">
                              <div class="modal-content">
                                <div class="modal-header bg-info">
                                    <h4 class="modal-title" id="modal_title"><i class="nav-icon fas fa-bullhorn"></i>  Allocate Student's to Subject</h4>
                                    <button type="button" class="close" data-dismiss="modal">&times;</button>
                                </div> 
                                <div class="modal-body"> 
                                
                                   <div class="row">
                                    <div class="col-md-6">
                                <?php  
                                $id=$_GET['Id_2'];
                                  $query = "SELECT * FROM class_srms where class_id='$id' AND  class_status='Enable' ORDER BY class_name ASC"; 
                                  $result = $conn->query($query);      
                                   ?>
                                   
                                    <div class="form-group">
                                        <label>Class <span style="color: red;">*</span></label>
                                         <?php 
                                          if($result->num_rows > 0){ 
                                              while($row = $result->fetch_assoc()){  
                                                  echo '
                                                  <input type="hidden" name="class_id" value="'.$row['class_id'].'" class="form-control" required>
                                                  <input type="text" value="'.$row['class_name'].'" class="form-control" disabled>'; 
                                              } 
                                          }else{ 
                                              echo '<input type="text" disabled class="form-control" placeholder="Class not available Contuct to admin">'; 
                                          } 
                                        ?>
                                      </div>
                                      <!-- /.info-box -->
                                    </div>
                                    <!-- /.col -->
                                    <div class="col-md-6 ">
                                      <div class="form-group">
                                        <label>Subject Name<span style="color: red;">*</span></label>
                                        <div class="select2-purple"> 
                                        <?php  
                                        $i = 1;
                                          $query = "SELECT * FROM general_subject ORDER BY subject_name ASC"; 
                                          $result = $conn->query($query);         
                                           ?> 

                                          <select name="sub_id" class="form-control select2" style="width:100%;" required>
                                              <option value="" disabled selected>-- Select Subject --</option>
                                              <?php 
                                              if($result->num_rows > 0){
                                               
                                                  while($row = $result->fetch_assoc()){  
                                                      echo '<option value="'.$row['sub_id'].'">'.$i++.' | '.$row['subject_name'].'</option>';

                                                  }
                                                 
                                              }else{ 
                                                  echo '<option value="">Subject not available</option>'; 
                                              } 
                                            ?>
                                        </select>
                                      </div>
                                    </div> 
                                      <!-- /.info-box -->
                                    </div> 
                                  </div>
                                    <div class="form-group"> 
                                      </div> 
                                       <?php   
                                         $query= mysqli_query($conn,"select * from teacher_srms where user_contact_no = '$session_id'")or die(mysqli_error());
                                        $q1 = mysqli_fetch_array($query);     
                                        ?>  
                                        <input type="hidden" name="teacher_roll_no" value="<?php echo $q1['teacher_roll_no']; ?>"> 
                                      </div> 
                                    <div class="col-lg-12"> 
                                       <div class="card-body table-responsive p-0" style="height:400px;">

                                      <table class="table table-bordered" id="tab_logic">

                                          <thead>
                                              <tr>
                                                  <th>#</th>
                                                  <th>R-NUMBER</th>
                                                  <th>Candidate Name</th>

                                                  <!-- SELECT ALL -->
                                                  <th class="text-center"><i>(Select All)  </i> 
                                                     <div class="btn-group mb-1">
                                                        <div class="custom-control custom-checkbox ms-1">
                                                           <input type="checkbox" class="custom-control-input" id="select_all">
                                                            <label class="custom-control-label" for="select_all"></label>
                                                        </div>
                                                    </div> 
                                                    </th>
                                                </tr>
                                            </thead>

                                            <tbody>

                                            <?php

                                            $id = $_GET['Id_2'];

                                            $students = mysqli_query($conn,
                                            "SELECT * FROM student_srms
                                             WHERE class_id='$id'
                                             AND student_status='Enable'");

                                            $i = 1;

                                            while($row2 = mysqli_fetch_array($students)){

                                            ?>

                                                <tr>

                                                    <td><?php echo $i++; ?></td>

                                                    <td><?php echo $row2['student_roll_no']; ?></td>

                                                    <td><?php echo $row2['student_name']; ?></td>

                                                    <td>
                                                       <div class="item-checkbox ms-1">
                                                         <div class="custom-control custom-checkbox">
                                                             <input type="checkbox"
                                                               class="student_checkbox "
                                                               name="selected_students[]"
                                                               value="<?php echo $row2['student_id']; ?>">
                                                               </div>
                                                           </div> 
                                                           <input type="hidden"name="student_roll_no[]"value="<?php echo $row2['student_roll_no']; ?>"> 
                                                           </td>

                                                     </tr>

                                            <?php } ?>

                                            </tbody>

                                          </table>
                                          </div>
                                    </div>  
                                    <div class="modal-footer">  
                                    <button type="submit" name="save" class="btn btn-info">SAVE</button>
                                    <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
                                </div>
                              </div> 
                          </form>
                        </div>
                    </div>
              </div> <!-- end card body-->
            </div> <!-- end card --> 
            </div>
            <!-- /.card -->
          </div>
          </div> 
             
             </div>
                <!-- /.tab-content -->
             </div><!-- /.card-body -->
            </div>
            <!-- /.card -->
          </div>
          <!-- /.col -->
        </div>
        <!-- /.row -->
      </div><!-- /.container-fluid -->
    </section>
    <!-- /.content -->
  </div>
  <!-- /.content-wrapper -->
  <script src="../stp_con/jquery/jquery.min.js"></script>
<!-- Bootstrap 4 -->
<script src="../stp_con/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- DataTables  & Plugins -->
<script src="../stp_con/datatables/jquery.dataTables.min.js"></script>
<script src="../stp_con/datatables-bs4/js/dataTables.bootstrap4.min.js"></script>
<script src="../stp_con/datatables-responsive/js/dataTables.responsive.min.js"></script>
<script src="../stp_con/datatables-responsive/js/responsive.bootstrap4.min.js"></script>
<script src="../stp_con/datatables-buttons/js/dataTables.buttons.min.js"></script>
<script src="../stp_con/datatables-buttons/js/buttons.bootstrap4.min.js"></script>
<script src="../stp_con/jszip/jszip.min.js"></script> 
<script src="../stp_con/pdfmake/pdfmake.min.js"></script>
<script src="../stp_con/pdfmake/vfs_fonts.js"></script> 
<script src="../stp_con/datatables-buttons/js/buttons.html5.min.js"></script>
<script src="../stp_con/datatables-buttons/js/buttons.print.min.js"></script>
<script src="../stp_con/datatables-buttons/js/buttons.colVis.min.js"></script>
 
<script src="../assets/js/adminlte.min.js"></script> 

<!-- Select2 -->
<script src="../stp_con/select2/js/select2.full.min.js"></script>
 <!-- <script src="../stp_con/jquery/jquery-3.6.0.min.js"></script> -->
<script src="../stp_con/tempusdominus-bootstrap-4/js/tempusdominus-bootstrap-4.min.js"></script>
 
</body>

</html>
<script>
$(document).ready(function(){

    // SELECT ALL
    $("#select_all").on("change", function () {

        $(".student_checkbox").prop("checked", $(this).prop("checked"));

    });

    // If one checkbox is unchecked, uncheck select all
    $(".student_checkbox").on("change", function () {

        if ($(".student_checkbox:checked").length === $(".student_checkbox").length) {
            $("#select_all").prop("checked", true);
        } else {
            $("#select_all").prop("checked", false);
        }

    });

});
</script>
 <script>
  $(function () {
    $("#example1").DataTable({
      "responsive": false, "lengthChange": true, "autoWidth": false,
      "buttons": ["copy", "csv", "excel", "pdf", "print", "colvis"]
    }).buttons().container().appendTo('#example1_wrapper .col-md-6:eq(0)'); 
  });
</script>
 <script>
  $(function () {
    $("#example2").DataTable({
      "responsive": false, "lengthChange": true, "autoWidth": false,
      "buttons": ["copy", "csv", "excel", "pdf", "print", "colvis"]
    }).buttons().container().appendTo('#example2_wrapper .col-md-6:eq(0)'); 
  });
</script>
 <script>
  $(function () {
    //Initialize Select2 Elements
    $('.select2').select2()

    //Initialize Select2 Elements
    $('.select2bs4').select2({
      theme: 'bootstrap4'
    })

    //Datemask dd/mm/yyyy
    $('#datemask').inputmask('dd/mm/yyyy', { 'placeholder': 'dd/mm/yyyy' })
    //Datemask2 mm/dd/yyyy
    $('#datemask2').inputmask('mm/dd/yyyy', { 'placeholder': 'mm/dd/yyyy' })
    //Money Euro
    $('[data-mask]').inputmask()

    //Date picker
    $('#reservationdate').datetimepicker({
        format: 'L'
    }); 
    //Date range picker
    $('#reservation').daterangepicker()
    //Date range picker with time picker
    $('#reservationtime').daterangepicker({
      timePicker: true,
      timePickerIncrement: 30,
      locale: {
        format: 'MM/DD/YYYY hh:mm A'
      }
    })
    //Date range as a button
    $('#daterange-btn').daterangepicker(
      {
        ranges   : {
          'Today'       : [moment(), moment()],
          'Yesterday'   : [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
          'Last 7 Days' : [moment().subtract(6, 'days'), moment()],
          'Last 30 Days': [moment().subtract(29, 'days'), moment()],
          'This Month'  : [moment().startOf('month'), moment().endOf('month')],
          'Last Month'  : [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')]
        },
        startDate: moment().subtract(29, 'days'),
        endDate  : moment()
      },
      function (start, end) {
        $('#reportrange span').html(start.format('MMMM D, YYYY') + ' - ' + end.format('MMMM D, YYYY'))
      }
    )

    //Timepicker
    $('#timepicker').datetimepicker({
      format: 'LT'
    })

    //Bootstrap Duallistbox
    $('.duallistbox').bootstrapDualListbox()

    //Colorpicker
    $('.my-colorpicker1').colorpicker()
    //color picker with addon
    $('.my-colorpicker2').colorpicker()

    $('.my-colorpicker2').on('colorpickerChange', function(event) {
      $('.my-colorpicker2 .fa-square').css('color', event.color.toString());
    })
  })
  // BS-Stepper Init
  document.addEventListener('DOMContentLoaded', function () {
    window.stepper = new Stepper(document.querySelector('.bs-stepper'))
  })

  // DropzoneJS Demo Code Start
  Dropzone.autoDiscover = false

  // Get the template HTML and remove it from the doumenthe template HTML and remove it from the doument
  var previewNode = document.querySelector("#template")
  previewNode.id = ""
  var previewTemplate = previewNode.parentNode.innerHTML
  previewNode.parentNode.removeChild(previewNode)

  var myDropzone = new Dropzone(document.body, { // Make the whole body a dropzone
    url: "/target-url", // Set the url
    thumbnailWidth: 80,
    thumbnailHeight: 80,
    parallelUploads: 20,
    previewTemplate: previewTemplate,
    autoQueue: false, // Make sure the files aren't queued until manually added
    previewsContainer: "#previews", // Define the container to display the previews
    clickable: ".fileinput-button" // Define the element that should be used as click trigger to select files.
  })

  myDropzone.on("addedfile", function(file) {
    // Hookup the start button
    file.previewElement.querySelector(".start").onclick = function() { myDropzone.enqueueFile(file) }
  })

  // Update the total progress bar
  myDropzone.on("totaluploadprogress", function(progress) {
    document.querySelector("#total-progress .progress-bar").style.width = progress + "%"
  })

  myDropzone.on("sending", function(file) {
    // Show the total progress bar when upload starts
    document.querySelector("#total-progress").style.opacity = "1"
    // And disable the start button
    file.previewElement.querySelector(".start").setAttribute("disabled", "disabled")
  })


    $('.toastrDefaultSuccess').click(function() {
      toastr.success('Lorem ipsum dolor sit amet, consetetur sadipscing elitr.')
    });
    $('.toastrDefaultInfo').click(function() {
      toastr.info('Lorem ipsum dolor sit amet, consetetur sadipscing elitr.')
    });
    $('.toastrDefaultError').click(function() {
      toastr.error('Lorem ipsum dolor sit amet, consetetur sadipscing elitr.')
    });
    $('.toastrDefaultWarning').click(function() {
      toastr.warning('Lorem ipsum dolor sit amet, consetetur sadipscing elitr.')
    });

  // Hide the total progress bar when nothing's uploading anymore
  myDropzone.on("queuecomplete", function(progress) {
    document.querySelector("#total-progress").style.opacity = "0"
  })

  // Setup the buttons for all transfers
  // The "add files" button doesn't need to be setup because the config
  // `clickable` has already been specified.
  document.querySelector("#actions .start").onclick = function() {
    myDropzone.enqueueFiles(myDropzone.getFilesWithStatus(Dropzone.ADDED))
  }
  document.querySelector("#actions .cancel").onclick = function() {
    myDropzone.removeAllFiles(true)
  }
  // DropzoneJS Demo Code End
  </script>
<script>
$(document).ready(function(){
    $('#login_form').parsley();
     $('#login_form2').parsley();
     $('#login_form3').parsley();
     $('#login_form4').parsley();
     $('#login_form5').parsley();
     $('#login_form6').parsley(); 
});

</script>