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


    <?php include 'includes/styles.php'; ?>
    <title>Edit Mark Settings |  <?php echo $school_name; ?> </title>
    <?php
    $module_name = 'Mark Setting';
    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 -->
    <?php

    if(isset($_GET['mark-setting'])){
        $mark_id = $_GET['mark-setting'];


        $sql = "SELECT * FROM mark_setting WHERE id =:id";
        $conn->query($sql);
        $conn->bind(":id", $mark_id);
        $result = $conn->fetchSingle();
        $db_id = $result->id;
        if($mark_id == $db_id){
            $class_name = $result->class;
            $term = $result->term;
            $exam = $result->exam;
            $first_ca = $result->first_ca;
            $second_ca = $result->second_ca;
            $third_ca = $result->third_ca;


            ?>
            <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-8">
                                <h1 class="m-0">Editing Mark Setting for <?php echo $class_name,  ", ", $term, ", ", date('Y'); ?></h1>
                            </div><!-- /.col -->
                            <div class="col-sm-4">
                                <ol class="breadcrumb float-sm-right">
                                    <li class="breadcrumb-item"><a href="<?php echo $conn->base_url();?>">Home</a></li>
                                    <li class="breadcrumb-item"><a href="<?php echo $conn->base_url();?>mark-setting">Mark Setting</a></li>
                                    <li class="breadcrumb-item active"><?php echo $class_name; ?></li>
                                </ol>
                            </div><!-- /.col -->
                        </div><!-- /.row -->
                    </div><!-- /.container-fluid -->
                </div>
                <!-- /.content-header -->

                <!-- Main content -->
                <section class="content">
                    <div class="container-fluid">

                        <div class="row">
                            <div class="col-md-8">
                                <div class="card card-info">
                                    <div class="card-header">
                                        <h3 class="card-title"> Editing Mark Setting </h3>
                                    </div>
                                    <!-- /.card-header -->
                                    <!-- form start -->
                                    <form class="form-horizontal" method="post" id="mark-edit">
                                        <div class="card-body">

                                            <div class="form-group row">
                                                <label for="class" class="col-sm-3 col-form-label">Class<span style="color: #f00;">*</span></label>
                                                <div class="col-sm-9">
                                                    <select name="class" id="class" class="form-control select2" required data-parsley-trigger="keyup" style="width: 100%;">
                                                        <option value="<?php echo $class_name; ?>" selected=""><?php echo $class_name; ?></option>
                                                        <?php
                                                        //fetch all teachers information
                                                        $sql = "SELECT * FROM mark_setting WHERE class !=:class";
                                                        $conn->query($sql);
                                                        $conn->bind(":class", $class_name);
                                                        $rowcount = $conn->rowCount();

                                                        if($rowcount > 0){
                                                            $result = $conn->fetchMultiple();
                                                            foreach ($result as $class) {
                                                                ?>  <option value="<?php echo $class->class; ?>"><?php echo $class->class; ?></option><?php
                                                            }

                                                        }
                                                        ?>

                                                    </select>
                                                </div>
                                            </div>

                                            <div class="form-group row">
                                                <label for="term" class="col-sm-3 col-form-label">Term<span style="color: #f00;">*</span></label>
                                                <div class="col-sm-9">
                                                    <select name="term" id="term" class="form-control select2" required data-parsley-trigger="keyup" style="width: 100%;">
                                                        <option value="<?php echo $term; ?>" selected=""><?php echo $term; ?></option>
                                                        <?php
                                                        //fetch all teachers information
                                                        $sql = "SELECT * FROM mark_setting WHERE term !=:term";
                                                        $conn->query($sql);
                                                        $conn->bind(":term", $term);
                                                        $rowcount = $conn->rowCount();

                                                        if($rowcount > 0){
                                                            $result = $conn->fetchMultiple();
                                                            foreach ($result as $term) {
                                                                ?>  <option value="<?php echo $term->term; ?>"><?php echo $term->term; ?></option><?php
                                                            }
                                                        }
                                                        ?>

                                                    </select>
                                                </div>
                                            </div>

                                            <div class="form-group row">
                                                <label for="1st_ca" class="col-sm-3 col-form-label">1st CA Total</label>
                                                <div class="col-sm-9">
                                                    <input type="number" class="form-control" id="1st_ca" name="1st_ca" required value="<?php echo $first_ca; ?>">
                                                </div>
                                            </div>

                                            <div class="form-group row">
                                                <label for="2nd_ca" class="col-sm-3 col-form-label">2nd CA Total</label>
                                                <div class="col-sm-9">
                                                    <input type="number" class="form-control" id="2nd_ca" name="2nd_ca" required value="<?php echo $second_ca; ?>">
                                                </div>
                                            </div>

                                            <div class="form-group row">
                                                <label for="3rd_ca" class="col-sm-3 col-form-label">3rd CA Total</label>
                                                <div class="col-sm-9">
                                                    <input type="number" class="form-control" id="3rd_ca" name="3rd_ca" required value="<?php echo $third_ca; ?>">
                                                </div>
                                            </div>

                                            <div class="form-group row">
                                                <label for="exam" class="col-sm-3 col-form-label">Exam Total</label>
                                                <div class="col-sm-9">
                                                    <input type="number" class="form-control" id="exam" name="exam" required value="<?php echo $exam; ?>">
                                                </div>
                                            </div>


                                            <input type="hidden" name="mark_id" value="<?php echo $mark_id; ?>">

                                            <div class="form-group row">
                                                <label for="" class="col-sm-3 col-form-label"></label>
                                                <div class="col-sm-9">
                                                    <input type="submit" name="add_mark" value="Update Mark Setting" class="btn btn-success" id="submit">
                                                </div>
                                            </div>

                                        </div>
                                        <div id="success-msg"> </div>

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

                                        <!-- /.card-footer -->
                                    </form>
                                </div>
                                <!-- /.card -->
                            </div>


                        </div>


                        <!-- /.row (main row) -->
                    </div><!-- /.container-fluid -->
                </section>
                <!-- /.content -->
            </div>
            <!-- /.content-wrapper -->
        <?php }else{
            //redirect back to the teachers page
            header("Location: ../mark-setting");
        }

    }else{
        //redirect back to the teachers page
        header("Location: mark-setting");

    }
    ?>


    <?php include "includes/footer.php";?>
    <script>
        $('#mark-edit').parsley();
        $('#mark-edit').on('submit', function (event) {
            event.preventDefault();
            if($('#mark-edit').parsley().isValid()){
                $.ajax({
                    url: '../process-edit-mark.php',
                    method: 'POST',
                    data: new FormData(this),
                    contentType: false,
                    cache: false,
                    processData: false,
                    beforeSend: function () {
                        $('#submit').attr('disabled', 'disabled');
                        $('#submit').val('Updating details, pls wait.....');
                    },
                    success: function (data) {
                        $('#mark-edit').parsley().reset();
                        $('#submit').attr('disabled', false);
                        $('#submit').val('Update Marks Setting');
                        $('#success-msg').html(data);
                    }
                });
            }

        });
    </script>

    <script>
        $(document).ready(function(){
            $('.select2').select2();

        })

    </script>

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

        <?php include 'includes/styles.php'; ?>
        <title>Login to continue |  <?php echo $school_name; ?> </title>

        <!-- 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
    }

    ?>
