<?php include('include/sidebar.php'); ?>
<!-- Start Welcome area -->
<?php include('include/header.php'); ?>
<?php 
$class_name = $_GET['class'];
$q = "SELECT * FROM class WHERE class_name='$class_name'";
$query = mysqli_query($conn,$q);
$class = mysqli_fetch_array($query);
$class_id=$class['id'];
$year=date('Y');
if(isset($_POST['submit'])){
    $student_id=$_POST['student_id'];
    $overall_grade=$_POST['overall_grade'];
    $sql = $conn->query("INSERT INTO results(student_id,class,session,status,overall_grade)VALUES('$student_id','$class_name','$year',1,'$overall_grade')");
    
    if($sql){
        $result_id = $conn->insert_id;
        $total=0;
        for($i=0;$i<count($_POST['subject_id']);$i++){
            $subject_id=$_POST['subject_id'][$i];
            $ut1_mark=$_POST['ut1_mark'][$i];
            $ut2_mark=$_POST['ut2_mark'][$i];
            $t1_mark1=$_POST['t1_mark1'][$i];
            $t2_mark1=$_POST['t2_mark1'][$i];
            $pa1=$_POST['ut1'][$i];
            $pa2=$_POST['ut2'][$i];
            $theory1=$_POST['t1'][$i];
            $theory2=$_POST['t2'][$i];
            $practicle1=$_POST['practicle1'][$i];
            $practicle2=$_POST['practicle2'][$i];
            $practicle_mark1=$_POST['practicle_mark1'][$i];
            $practicle_mark2=$_POST['practicle_mark2'][$i];
            $year=date('Y')[$i];
            $sql = $conn->query("INSERT INTO result_list(subject_id,pa1,pa2,theory1,theory2,practicle1,practicle2,result_id,marks1,marks2,marks3,marks4,practicle_mark1,practicle_mark2,year) VALUES ('$subject_id','$pa1','$pa2','$theory1','$theory2','$practicle1','$practicle2','$result_id','$ut1_mark','$ut2_mark','$t1_mark1','$t2_mark1','$practicle_mark1','$practicle_mark2','$year')");
        }
        if($sql){
            echo '<script>alert("Added successfully"); location.href="results"</script>';
        }else{
            echo '<script>alert("Oops Something Went Wrong!");</script>';
        }
    }
}
$sql = "select * from subjects";
$query = mysqli_query($conn,$sql);
$total_subject=mysqli_num_rows ($query);

?>
<style>
    #myTabContent .input-group{
        width: 100%;
    }
    #myTabContent h2{
        width: 100%;
        text-align: center;
        border-top: 1px solid #7b7b7b;
        color: #fff;
        font-size: 20px;
        margin: 15px;
        padding-top: 20px;
    }
    .form-control:disabled, .form-control[readonly] {
        background-color: #0f1728;
        opacity: 1;
        cursor: not-allowed;
    }
</style>
<div class="breadcome-area">
    <div class="container-fluid">
        <div class="row">
            <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
                <div class="breadcome-list">
                    <div class="row">
                        <div class="col-lg-6 col-md-6 col-sm-6 col-xs-6">
                            <div class="breadcomb-wp">
                                <div class="breadcomb-icon">
                                    <i class="icon nalika-home"></i>
                                </div>
                                <div class="breadcomb-ctn">
                                    <h2>Add Result</h2>
                                </div>
                            </div>
                        </div>
                        <div class="col-lg-6 col-md-6 col-sm-6 col-xs-6">
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
</div>
<div class="single-product-tab-area mg-b-30">
    <!-- Single pro tab review Start-->
    <div class="single-pro-review-area">
        <div class="container-fluid">
            <div class="row">
                <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
                    <div class="review-tab-pro-inner">
                        <ul class="nav nav-tabs nav-justified" role="tablist">
                          <li class="nav-item">
                            <a class="nav-link active" data-toggle="tab" href="#ut1" role="tab" aria-controls="ut1" aria-selected="true">UT-1</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" data-toggle="tab" href="#ut2" role="tab" aria-controls="ut2" aria-selected="false">UT-2</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" data-toggle="tab" href="#t1" role="tab" aria-controls="t1" aria-selected="false">Theory-1</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" data-toggle="tab" href="#t2" role="tab" aria-controls="t2" aria-selected="false">Theory-2</a>
                        </li>
                    </ul>
                    <div class="tab-content mt-3">
                        <!-- PA-1 -->
                        <div class="tab-pane active" id="ut1" role="tabpanel" aria-labelledby="duck-tab">
                            <form method="post" enctype="multipart/form-data">
                                <div id="myTabContent" class="tab-content custom-product-edit">
                                   <div class="row">
                                    <div class="col-md-4 col-sm-6 col-xs-12">
                                        <div class="input-group mg-b-pro-edt">
                                           <select class="form-control" name="student_id" required>
                                            <option value="">Select Student</option>
                                            <?php
                                            $q = "select * from students where class_id='$class_id'";
                                            $query = mysqli_query($conn,$q);
                                            while($res = mysqli_fetch_array($query)) { ?>
                                                <option value="<?php echo $res['id'] ?>"><?php echo $res['student_name'] ?></option>
                                            <?php } ?>
                                        </select>
                                    </div>
                                </div>
                                <div class="col-md-4 col-sm-6 col-xs-12">
                                   <input type="text" readonly class="form-control" placeholder="Class Name" value="<?php echo $class_name; ?>" required>
                               </div>
                               <div class="col-md-2 pr-0">
                                <div class="input-group mg-b-pro-edt">
                                    <input type="text" class="form-control" value="Overall Grade" disabled>
                                </div>
                            </div>
                            <div class="col-md-2 col-sm-6 col-xs-12 pl-0">
                               <input type="text" class="form-control" placeholder="Overall Grade" name="overall_grade" required>
                           </div>
                       </div>
                       <div class="row">
                        <?php for ($x = 1; $x <= $total_subject; $x++) { ?>
                            <div class="col-md-4 col-sm-6 col-xs-12">
                                <div class="input-group mg-b-pro-edt">
                                    <select class="form-control" name="subject_id[]" id="subject<?php echo $x; ?>" required onchange="subject(<?php echo $x; ?>)">
                                        <option value="">Select Subject</option>
                                        <?php
                                        $q = "select * from subjects";
                                        $query = mysqli_query($conn,$q);
                                        while($res = mysqli_fetch_array($query)) { ?>
                                            <option value="<?php echo $res['id'] ?>"><?php echo $res['subject_name'] ?></option>
                                        <?php } ?>
                                    </select>
                                </div>
                            </div>
                            <div class="col-md-2 pr-0">
                                <div class="input-group mg-b-pro-edt">
                                    <input type="text" class="form-control" value="Maximum Marks" disabled>
                                </div>
                            </div>
                            <div class="col-md-2 col-sm-6 col-xs-12 pl-0">
                                <div class="input-group mg-b-pro-edt">
                                    <input type="number" name="ut1_mark[]" class="form-control" placeholder="Marks" required>
                                </div>
                            </div>
                            <div class="col-md-2 pr-0">
                                <div class="input-group mg-b-pro-edt">
                                    <input type="text" class="form-control" value="Marks Obtained" disabled>
                                </div>
                            </div>
                            <div class="col-md-2 col-sm-6 col-xs-12 pl-0">
                                <div class="input-group mg-b-pro-edt">
                                    <input type="number" name="ut1[]" class="form-control" placeholder="UT-1" required>
                                </div>
                            </div>
                        <?php } ?>
                        <div class="col-lg-12 col-md-12">
                            <div class="text-center custom-pro-edt-ds">
                                <button type="submit" class="btn btn-ctl-bt waves-effect waves-light m-r-10" name="submit">Save
                                </button>
                                <a href="results" class="btn btn-ctl-bt waves-effect waves-light">cancel
                                </a>
                            </div>
                        </div>
                    </div>
                </div>
            </form>
        </div>
        <!-- PA-2 -->
        <div class="tab-pane" id="ut2" role="tabpanel" aria-labelledby="ut2-tab">
            <form method="post" enctype="multipart/form-data">
                <div id="myTabContent" class="tab-content custom-product-edit">
                   <div class="row">
                    <div class="col-md-4 col-sm-6 col-xs-12">
                        <div class="input-group mg-b-pro-edt">
                           <select class="form-control" name="student_id" required>
                            <option value="">Select Student</option>
                            <?php
                            $q = "select * from students";
                            $query = mysqli_query($conn,$q);
                            while($res = mysqli_fetch_array($query)) { ?>
                                <option value="<?php echo $res['id'] ?>"><?php echo $res['student_name'] ?></option>
                            <?php } ?>
                        </select>
                    </div>
                </div>
                <div class="col-md-4 col-sm-6 col-xs-12">
                   <input type="text" readonly class="form-control" placeholder="Class Name" value="<?php echo $class_name; ?>" required>
               </div>
               <div class="col-md-2 pr-0">
                <div class="input-group mg-b-pro-edt">
                    <input type="text" class="form-control" value="Overall Grade" disabled>
                </div>
            </div>
            <div class="col-md-2 col-sm-6 col-xs-12 pl-0">
               <input type="text" class="form-control" placeholder="Overall Grade" name="overall_grade" required>
           </div>
       </div>
       <div class="row">
        <?php for ($x = 1; $x <= $total_subject; $x++) { ?>
            <div class="col-md-4 col-sm-6 col-xs-12">
                <div class="input-group mg-b-pro-edt">
                    <select class="form-control" name="subject_id[]" id="subject<?php echo $x; ?>" required onchange="subject(<?php echo $x; ?>)">
                        <option value="">Select Subject</option>
                        <?php
                        $q = "select * from subjects";
                        $query = mysqli_query($conn,$q);
                        while($res = mysqli_fetch_array($query)) { ?>
                            <option value="<?php echo $res['id'] ?>"><?php echo $res['subject_name'] ?></option>
                        <?php } ?>
                    </select>
                </div>
            </div>
            <div class="col-md-2 pr-0">
                <div class="input-group mg-b-pro-edt">
                    <input type="text" class="form-control" value="Maximum Marks" disabled>
                </div>
            </div>
            <div class="col-md-2 col-sm-6 col-xs-12 pl-0">
                <div class="input-group mg-b-pro-edt">
                    <input type="number" name="ut2_mark[]" class="form-control" placeholder="Marks" required>
                </div>
            </div>
            <div class="col-md-2 pr-0">
                <div class="input-group mg-b-pro-edt">
                    <input type="text" class="form-control" value="Marks Obtained" disabled>
                </div>
            </div>
            <div class="col-md-2 col-sm-6 col-xs-12 pl-0">
                <div class="input-group mg-b-pro-edt">
                    <input type="number" name="ut2[]" class="form-control" placeholder="UT-2" required>
                </div>
            </div>
        <?php } ?>
        <div class="col-lg-12 col-md-12">
            <div class="text-center custom-pro-edt-ds">
                <button type="submit" class="btn btn-ctl-bt waves-effect waves-light m-r-10" name="submit">Save
                </button>
                <a href="results" class="btn btn-ctl-bt waves-effect waves-light">cancel
                </a>
            </div>
        </div>
    </div>
</div>
</form>
</div>
<!-- THEORY-1 -->
<div class="tab-pane" id="t1" role="tabpanel" aria-labelledby="t1-tab">
    <form method="post" enctype="multipart/form-data">
        <div id="myTabContent" class="tab-content custom-product-edit">
           <div class="row">
            <div class="col-md-4 col-sm-6 col-xs-12">
                <div class="input-group mg-b-pro-edt">
                   <select class="form-control" name="student_id" required>
                    <option value="">Select Student</option>
                    <?php
                    $q = "select * from students";
                    $query = mysqli_query($conn,$q);
                    while($res = mysqli_fetch_array($query)) { ?>
                        <option value="<?php echo $res['id'] ?>"><?php echo $res['student_name'] ?></option>
                    <?php } ?>
                </select>
            </div>
        </div>
        <div class="col-md-4 col-sm-6 col-xs-12">
           <input type="text" readonly class="form-control" placeholder="Class Name" value="<?php echo $class_name; ?>" required>
       </div>
       <div class="col-md-2 pr-0">
        <div class="input-group mg-b-pro-edt">
            <input type="text" class="form-control" value="Overall Grade" disabled>
        </div>
    </div>
    <div class="col-md-2 col-sm-6 col-xs-12 pl-0">
       <input type="text" class="form-control" placeholder="Overall Grade" name="overall_grade" required>
   </div>
</div>
<div class="row">
    <?php for ($x = 1; $x <= $total_subject; $x++) { ?>
        <div class="col-md-4 col-sm-6 col-xs-12">
            <div class="input-group mg-b-pro-edt">
                <select class="form-control" name="subject_id[]" id="subject<?php echo $x; ?>" required onchange="subject(<?php echo $x; ?>)">
                    <option value="">Select Subject</option>
                    <?php
                    $q = "select * from subjects";
                    $query = mysqli_query($conn,$q);
                    while($res = mysqli_fetch_array($query)) { ?>
                        <option value="<?php echo $res['id'] ?>"><?php echo $res['subject_name'] ?></option>
                    <?php } ?>
                </select>
            </div>
        </div>
        <div class="col-md-8">
            <div class="row">
                <div class="col-md-3 col-sm-6 col-xs-12">
                    <div class="input-group mg-b-pro-edt">
                        <input type="number" name="t1_mark1[]" class="form-control" placeholder="Marks" required>
                    </div>
                </div>
                <div class="col-md-3 col-sm-6 col-xs-12">
                    <div class="input-group mg-b-pro-edt">
                        <input type="number" name="t1[]" class="form-control" placeholder="Theory-1" required>
                    </div>
                </div>
                <div class="col-md-3 col-sm-6 col-xs-12">
                    <div class="input-group mg-b-pro-edt">
                        <input type="number" name="practicle_mark1[]" class="form-control" placeholder="Marks" required>
                    </div>
                </div>
                <div class="col-md-3 col-sm-6 col-xs-12">
                    <div class="input-group mg-b-pro-edt">
                        <input type="number" name="practicle1[]" class="form-control" placeholder="Practicle-1" required>
                    </div>
                </div>
            </div>
        </div>
    <?php } ?>
    <div class="col-lg-12 col-md-12">
        <div class="text-center custom-pro-edt-ds">
            <button type="submit" class="btn btn-ctl-bt waves-effect waves-light m-r-10" name="submit">Save
            </button>
            <a href="results" class="btn btn-ctl-bt waves-effect waves-light">cancel
            </a>
        </div>
    </div>
</div>
</div>
</form>
</div>
<!-- THEORY-2 -->   
<div class="tab-pane" id="t2" role="tabpanel" aria-labelledby="t2-tab">
    <form method="post" enctype="multipart/form-data">
        <div id="myTabContent" class="tab-content custom-product-edit">
           <div class="row">
            <div class="col-md-4 col-sm-6 col-xs-12">
                <div class="input-group mg-b-pro-edt">
                   <select class="form-control" name="student_id" required>
                    <option value="">Select Student</option>
                    <?php
                    $q = "select * from students";
                    $query = mysqli_query($conn,$q);
                    while($res = mysqli_fetch_array($query)) { ?>
                        <option value="<?php echo $res['id'] ?>"><?php echo $res['student_name'] ?></option>
                    <?php } ?>
                </select>
            </div>
        </div>
        <div class="col-md-4 col-sm-6 col-xs-12">
           <input type="text" readonly class="form-control" placeholder="Class Name" value="<?php echo $class_name; ?>" required>
       </div>
       <div class="col-md-2 pr-0">
        <div class="input-group mg-b-pro-edt">
            <input type="text" class="form-control" value="Overall Grade" disabled>
        </div>
    </div>
    <div class="col-md-2 col-sm-6 col-xs-12 pl-0">
       <input type="text" class="form-control" placeholder="Overall Grade" name="overall_grade" required>
   </div>
</div>
<div class="row">
    <?php for ($x = 1; $x <= $total_subject; $x++) { ?>
        <div class="col-md-4 col-sm-6 col-xs-12">
            <div class="input-group mg-b-pro-edt">
                <select class="form-control" name="subject_id[]" id="subject<?php echo $x; ?>" required onchange="subject(<?php echo $x; ?>)">
                    <option value="">Select Subject</option>
                    <?php
                    $q = "select * from subjects";
                    $query = mysqli_query($conn,$q);
                    while($res = mysqli_fetch_array($query)) { ?>
                        <option value="<?php echo $res['id'] ?>"><?php echo $res['subject_name'] ?></option>
                    <?php } ?>
                </select>
            </div>
        </div>
        <div class="col-md-8">
            <div class="row">
                <div class="col-md-3 col-sm-6 col-xs-12">
                    <div class="input-group mg-b-pro-edt">
                        <input type="number" name="t2_mark1[]" class="form-control" placeholder="Marks" required>
                    </div>
                </div>
                <div class="col-md-3 col-sm-6 col-xs-12">
                    <div class="input-group mg-b-pro-edt">
                        <input type="number" name="t2[]" class="form-control" placeholder="Theory-2" required>
                    </div>
                </div>
                <div class="col-md-3 col-sm-6 col-xs-12">
                    <div class="input-group mg-b-pro-edt">
                        <input type="number" name="practicle_mark2[]" class="form-control" placeholder="Marks" required>
                    </div>
                </div>
                <div class="col-md-3 col-sm-6 col-xs-12">
                    <div class="input-group mg-b-pro-edt">
                        <input type="number" name="practicle2[]" class="form-control" placeholder="Practicle-2" required>
                    </div>
                </div>
            </div>
        </div>
    <?php } ?>
    <div class="col-lg-12 col-md-12">
        <div class="text-center custom-pro-edt-ds">
            <button type="submit" class="btn btn-ctl-bt waves-effect waves-light m-r-10" name="submit">Save
            </button>
            <a href="results" class="btn btn-ctl-bt waves-effect waves-light">cancel
            </a>
        </div>
    </div>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<script>
    function subject(e) {
        num = e +1;
        var val1 = $('#subject1').val();
        var val2 = $('#subject2').val();
        var val3 = $('#subject3').val();
        var val4 = $('#subject4').val();
        var val5 = $('#subject5').val();
        var val6 = $('#subject6').val();
        if (val1!='') {
            var val1 = $('#subject1').val();
        }else{
            var val1 = 0;
        } 
        if (val2!='') {
            var val2 = $('#subject2').val();
        }else{
            var val2 = 0;
        } 
        if (val3!='') {
            var val3 = $('#subject3').val();
        }else{
            var val3 = 0;
        } 
        if (val4!='') {
            var val4 = $('#subject4').val();
        }else{
            var val4 = 0;
        } 
        if (val5!='') {
            var val5 = $('#subject5').val();
        }else{
            var val5 = 0;
        }
        if (val6!='') {
            var val6 = $('#subject5').val();
        }else{
            var val6 = 0;
        }
        console.log(val5,val4,val3,val2,val1);
        $.ajax({
          url: "change_subject_status.php",
          type: "POST",
          data: {
              val1: val1,val2: val2,val3: val3,val4: val4,val5: val5,val6: val6,
          },
          success: function(response){
           $( "#subject"+num ).html(response);
       },
   })
    }
</script>
<?php include('include/footer.php'); ?>