<?php
session_start();
error_reporting('0');
if(isset($_SESSION['username'])){
?>
<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">

    <style>
        .card-title a {
            font-size: 16px;
            border-bottom: 1px solid #707478;
            color: #707478;
        }
        .card-title a:hover{
            border-bottom: 1px solid #1A2229;
            color: #1A2229;
        }
        .btn-app:first-child{
            margin-left:0 !important;
        }
    </style>


  <?php include 'includes/styles.php'; ?>
    <title> Subject |  <?php echo $school_name; ?> </title>
    <?php
    $module_name = 'Subjects';
    include "check-admin-privilege.php";
    ?>


</head>
<body class="hold-transition sidebar-mini layout-fixed">
<div class="wrapper">

  <!-- Navbar -->
    <?php include 'includes/notifications.php'; ?>
  <!-- /.navbar -->

  <!-- Main Sidebar Container -->
<?php include "includes/sidebar.php";?>

  <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <div class="content-header">
      <div class="container-fluid">
        <div class="row mb-2">
          <div class="col-sm-6">
            <h1 class="m-0">Subject</h1>
          </div><!-- /.col -->
          <div class="col-sm-6">
            <ol class="breadcrumb float-sm-right">
              <li class="breadcrumb-item"><a href="<?php echo $conn->base_url();?>">Home</a></li>
              <li class="breadcrumb-item active">Subjects</li>
            </ol>
          </div><!-- /.col -->
        </div><!-- /.row -->
      </div><!-- /.container-fluid -->
    </div>
    <!-- /.content-header -->

    <!-- Main content -->
    <section class="content">
      <div class="container-fluid">
   
        <div class="row">
<!--          <section class="col-lg-12 connectedSortable">-->
<!--           <a href="add-class"><button class="btn btn-outline-success">Add a class</button></a>-->
<!--          </section>-->
          <section class="col-lg-12 connectedSortable">
              <div class="card">
                  <div class="card-header" style="background: #17a2b8; color: white;">
                      <h3 class="card-title" style="font-size: 15px;"> <i class="fa fa-star"></i> Manage Subjects </h3>
                  </div>
                  <div class="card-header">
                      <h3 class="card-title"><a href="<?php echo $conn->base_url().'add-subject'; ?>"> <i class="fa fa-plus"></i> Add a subject </a> </h3>
                  </div>
                  <!-- /.card-header -->
                  <div class="card-body">
                      <h3 class="card-title text-center" style="font-size: 15px;"> Please select a class to view the available subjects <i class="fa fa-info-circle" data-toggle="tooltip" title="N.B: Only classes with subjects added are clickable."></i></h3>
                      <br><br>
                     <div>
                         <?php

                         $sql = "SELECT *  FROM classes";
                         $conn->query($sql);
                         $result = $conn->fetchMultiple();
                         $n = 0;
                         foreach ($result as $class){
                             $class_name = strtolower($conn->slugify($class->name));
                             $class_id = $class->id;
                             //badge color array
                             $badge_color = array('bg-success', 'bg-purple', 'bg-warning', 'bg-info', 'bg-danger', 'bg-teal', 'bg-primary');
                             //fetch available section in class
                             $sql = "SELECT COUNT(id) FROM subjects WHERE class_id =:class_id";
                             $conn->query($sql);
                             $conn->bind(":class_id", $class_id);
                             $subject_available = $conn->fetchColumn();
                             //enable or disable link on number of available sections  href="section/<?php echo $class_id;

                             $link = $base_url ."subject/$class_id";
                             ?>
                             <a class="btn btn-app" style="min-width: 120px; height: 90px;" <?php if($subject_available != 0){echo "href='$link'";}?>>
                                 <span class="badge <?php echo $badge_color[$n]; ?>" data-toggle="tooltip" title="<?php echo $subject_available ?> subject(s) available in class <?php echo $class_name; ?>"><?php echo $subject_available ?></span>
                                 <i class="fas fa-users" style="font-size: 50px;"></i> <?php echo ucwords(str_replace('-', ' ', $class_name)); ?>
                             </a>
                             <?php
                             $n++;

                         }
                         ?>

                     </div>
                      <?php
                      //display selected section below
                      if(isset($_GET['class'])){
                          $class =  $_GET['class'];
                          $sql = "SELECT *  FROM subjects WHERE class_id =:class";
                          $conn->query($sql);
                          $conn->bind(":class", $class);
                          $result = $conn->fetchMultiple();

                          $sql = "SELECT name FROM classes WHERE id =:id";
                          $conn->query($sql);
                          $conn->bind(":id", $class);
                          $className = $conn->fetchColumn();


                        ?>
                          <div class="card-header" style="background: #c3570f; color: white; margin: 20px 0 2px;">
                              <h3 class="card-title" style="font-size: 15px;"> <i class="fa fa-star"></i> Viewing Subject details for class <?php echo $className; ?> </h3>
                          </div>
                          <table id="teacher" class="table table-bordered table-striped">
                              <thead>
                              <tr>
                                  <th>#</th>
                                  <th>Subject Name</th>
                                  <th>Subject Author</th>
                                  <th>Subject Code</th>
                                  <th>Teacher</th>
                                  <th>Pass Mark</th>
                                  <th>Final Mark</th>
                                  <th>Action</th>
                              </tr>
                              </thead>
                              <tbody>
                              <?php
                              $i = 1;
                              if($conn->rowCount()){
                                  foreach ($result as $subject_details):
                                      $subject_code= $subject_details->subject_code;
                                      $subject_author = $subject_details->subject_author;
                                      $subject_name = $subject_details->subject_name;
                                      $pass_mark= $subject_details->pass_mark;
                                      $final_mark = $subject_details->final_mark;
                                      $teacher_name = $subject_details->teacher_name;
                                      $subject_id = $subject_details->id;
                                      ?>
                                      <tr>
                                          <td><?php echo $i++; ?></td>
                                          <td><?php echo $subject_name;?></td>
                                          <td><?php echo $subject_author;?></td>
                                          <td><?php echo $subject_code; ?></td>
                                          <td><?php echo $teacher_name;?></td>
                                          <td><?php echo $pass_mark;?></td>
                                          <td><?php echo $final_mark;?></td>
                                          <td>
                                              <a href="<?php echo $conn->base_url().'edit-subject/'.$subject_id;?>"  data-toggle="tooltip" title="Edit">
                                                  <i class="fa fa-edit"></i>
                                              </a>&nbsp;

                                              <a href="javascript:void();" data-toggle='modal' data-target='#delete-subject<?php echo $subject_id;?>'>
                                                  <i class="fa fa-trash" data-toggle="tooltip" title="Delete"></i>
                                              </a>

                                          </td>
                                      </tr>

                                  <?php endforeach; ?>
                                  <?php
                              }else{
                                  ?> <tr>
                                      <td colspan="5" class="text-center">No Data in table</td>
                                  </tr><?php
                              }

                              ?>
                              </tbody>
                              <tfoot>
                              <tr>
                                  <th>#</th>
                                  <th>Subject Name</th>
                                  <th>Subject Author</th>
                                  <th>Subject Code</th>
                                  <th>Teacher</th>
                                  <th>Pass Mark</th>
                                  <th>Final Mark</th>
                                  <th>Action</th>
                              </tr>
                              </tfoot>
                          </table>
                       <?php


                      }



                      ?>

                  </div>
                  <!-- /.card-body -->
              </div>


          </section>
        </div>

          <div id="show-msg">
             
          </div>
        <!-- /.row (main row) -->
      </div><!-- /.container-fluid -->
    </section>
    <!-- /.content -->
  </div>
  <!-- /.content-wrapper -->
  <?php include "includes/footer.php";?>

    <?php
    foreach ($result as $subject_details) {
          $subject_code= $subject_details->subject_code;
          $subject_author = $subject_details->subject_author;
          $subject_name = $subject_details->subject_name;
          $pass_mark= $subject_details->pass_mark;
          $final_mark = $subject_details->final_mark;
          $teacher_name = $subject_details->teacher_name;
          $subject_id = $subject_details->id;
        # run html delete modal
        ?>

        <!-- Delete member Modal start -->
        <div class="modal fade" id="delete-subject<?php echo $subject_id;?>" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
            <div class="modal-dialog modal-md" role="document">
                <div class="modal-content">
                    <div class="modal-header">
                        <h5 class="modal-title" id="exampleModalLabel">Delete subject <?php echo $subject_name; ?></h5>
                        <button type="button" class="close" data-dismiss="modal" aria-label="Close"></button>
                    </div>
                    <div class="modal-body">
                        <h4>Are you sure you want to do this?
                            <br><small class="text-warning">This action cannot be undone</small></h4>
                        <form action="" method="post">
                            <div class="form-group">
                                <input type="hidden" name="id" value="<?php echo $subject_id; ?>">
                                <div class="form-group">
                                </div>
                            </div>

                            <div class="modal-footer" style="margin-bottom: -10px;">
                                <button class="btn" data-dismiss="modal"><i class="flaticon-cancel-12"></i> Cancel</button>
                                <input type="submit" class="btn btn-outline-danger" value="Delete subject" id="submit" name="delete_subject">
                            </div>
                        </form>

                    </div>
                </div>
            </div>
        </div>
        <!-- Delete member Modal end -->

        <?php

    }

    if(isset($_POST['delete_subject'])){

        $id = $_POST['id'];

        //delete teacher from database

        $sql = "DELETE  FROM subjects WHERE id =:id";
        $conn->query($sql);
        $conn->bind(":id", $id);
        try{

            $conn->execute();
            echo "<p class='alert alert-success alert-dismissible fade show' role='alert'>
                    <i class='fas fa-check-circle'></i> Subject deleted successfully.
                  <button type=\"button\" class=\"close\" data-dismiss=\"alert\" aria-label=\"Close\">
                             <span aria-hidden=\"true\">×</span>
                  </button>
                   <meta http-equiv='refresh' content='3; ../subject'>
                  
           </p>";

        }catch(PDOException $err){

            echo $err->getMessage();

        }


    }

    ?>

    <script>
        $(document).ready(function(){
            $('[data-toggle="tooltip"]').tooltip();
        });
    </script>

    <script>
        $(function () {
            $("#teacher").DataTable({
                "responsive": true, "lengthChange": false, "autoWidth": false,
                "buttons": ["copy", "csv", "pdf", "print"]
            }).buttons().container().appendTo('#teacher_wrapper .col-md-6:eq(0)');
            $('#example2').DataTable({
                "paging": true,
                "lengthChange": false,
                "searching": true,
                "ordering": true,
                "info": true,
                "autoWidth": false,
                "responsive": true
            });
        });
    </script>

    <?php
  }else{
      ?>
    <!DOCTYPE html>
    <html lang="en">
    <head>
        <meta charset="utf-8">
        <meta http-equiv="X-UA-Compatible" content="IE=edge">
        <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, shrink-to-fit=no">
        <title>Login to continue |  <?php echo $school_name; ?>  </title>

        <?php include 'includes/styles.php'; ?>

        <!-- END PAGE LEVEL PLUGINS/CUSTOM STYLES -->

    </head>
    <body>
    <div class="container" style="margin-top: 20%;">
        <div class="row">
            <div class="col-lg-12 col-md-12">
                <div class="section-title text-center">
                    <h6> You need to login to continue </h6>
                    <div class="spinner-border text-info" role="status">
                        <span class="sr-only">Loading...</span>
                        <meta http-equiv='refresh' content='3; <?php echo $link; ?>'>
                    </div>
                    <p>Redirecting to the login  page...</p>
                </div>
            </div>
        </div>
    </div>

    <?php
    }

  ?>
