<?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','2','$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];
            $pa1_mark1=$_POST['pa1_mark1'][$i];
            $pa2_mark1=$_POST['pa2_mark1'][$i];
            $t1_mark1=$_POST['t1_mark1'][$i];
            $t2_mark1=$_POST['t2_mark1'][$i];
            $pa1=$_POST['pa1'][$i];
            $pa2=$_POST['pa2'][$i];
            $theory1=$_POST['t1'][$i];
            $theory2=$_POST['t2'][$i];
            $year=date('Y')[$i];
            $sql = $conn->query("INSERT INTO result_list(subject_id,pa1,pa2,theory1,theory2,total,result_id,marks1,marks2,marks3,marks4,year) VALUES ('$subject_id','$pa1','$pa2','$theory1','$theory2','$total','$result_id','$pa1_mark1','$pa2_mark1','$t1_mark1','$t2_mark1','$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="#pa1" role="tab" aria-controls="pa1" aria-selected="true">PA-1</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" data-toggle="tab" href="#pa2" role="tab" aria-controls="pa2" aria-selected="false">PA-2</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" data-toggle="tab" href="#t1" role="tab" aria-controls="t1" aria-selected="false">PA-3</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" data-toggle="tab" href="#t2" role="tab" aria-controls="t2" aria-selected="false">SE WRITTEN</a>
                        </li>
                    </ul>
                    <div class="tab-content mt-3">
                        <!-- PA-1 -->
                        <div class="tab-pane active" id="pa1" 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="pa1_mark1[]" 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="pa1[]" class="form-control" placeholder="PA-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="pa2" role="tabpanel" aria-labelledby="pa2-tab">
                <form method="post" enctype="multipart/form-data">
                    <div id="myTabContent" class="tab-content custom-product-edit">
                     <div class="row">
                        <div class="col-md-6 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-6 col-sm-6 col-xs-12">
                     <input type="text" readonly class="form-control" placeholder="Class Name" value="<?php echo $class_name; ?>" 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="pa2_mark1[]" 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="pa2[]" class="form-control" placeholder="PA-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-6 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-6 col-sm-6 col-xs-12">
         <input type="text" readonly class="form-control" placeholder="Class Name" value="<?php echo $class_name; ?>" 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="t1_mark1[]" 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="t1[]" class="form-control" placeholder="PA-3" 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-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-6 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-6 col-sm-6 col-xs-12">
         <input type="text" readonly class="form-control" placeholder="Class Name" value="<?php echo $class_name; ?>" 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="t2_mark1[]" 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="t2[]" class="form-control" placeholder="SE-Written" 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>
</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'); ?>