<?php include('include/sidebar.php'); ?>
<!-- Start Welcome area -->

<?php include('include/header.php'); ?>

<?php 
if(isset($_POST['submit'])){
    $student_id=$_POST['student_id'];
    $total=0;
    for($i=0;$i<count($_POST['subject_id']);$i++){
        $subject_id=$_POST['subject_id'][$i];
        $marks=$_POST['marks'][$i];
        $total+=$_POST['marks'][$i];
        $sql = $conn->query("INSERT INTO pa_2_result(student_id,subject_id,marks,total,type) VALUES ('$student_id','$subject_id','$marks','$total','pa1')");
    }
    if($sql){
        echo '<script>alert("Added successfully"); location.href="pa-1"</script>';

    }else{
        echo '<script>alert("Oops Something Went Wrong!");</script>';
    }
    
}
?>

<style>
    #myTabContent .input-group{
        width: 100%;
    }
</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 class="breadcomb-report">
                                            <button data-toggle="tooltip" data-placement="left" title="Download Report" class="btn"><i class="icon nalika-download"></i></button>
                                        </div> -->
                                    </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">
                                <form method="post" enctype="multipart/form-data">
                                    <div id="myTabContent" class="tab-content custom-product-edit">

                                      <div class="row">
                                            <div class="col-md-6">
                                               <div class="row">

                                                <div class="col-md-12 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-6 col-sm-6 col-xs-12">
                                                    <div class="input-group mg-b-pro-edt">
                                                        <select class="form-control" name="subject_id[]" id="subject1" required onchange="subject(1)">
                                                            <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-6 col-sm-6 col-xs-12">
                                                    <div class="input-group mg-b-pro-edt">
                                                        <input type="number" name="marks[]" class="form-control" placeholder="Marks" required>
                                                    </div>
                                                </div>

                                                <div class="col-md-6 col-sm-6 col-xs-12">
                                                    <div class="input-group mg-b-pro-edt">
                                                        <select class="form-control" name="subject_id[]" id="subject2" required onchange="subject(2)">
                                                            <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-6 col-sm-6 col-xs-12">
                                                    <div class="input-group mg-b-pro-edt">
                                                        <input type="number" name="marks[]" class="form-control" placeholder="Marks" required>
                                                    </div>
                                                </div>

                                                <div class="col-md-6 col-sm-6 col-xs-12">
                                                    <div class="input-group mg-b-pro-edt">
                                                        <select class="form-control" name="subject_id[]" id="subject3" required onchange="subject(3)">
                                                            <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-6 col-sm-6 col-xs-12">
                                                    <div class="input-group mg-b-pro-edt">
                                                        <input type="number" name="marks[]" class="form-control" placeholder="Marks" required>
                                                    </div>
                                                </div>

                                                <div class="col-md-6 col-sm-6 col-xs-12">
                                                    <div class="input-group mg-b-pro-edt">
                                                        <select class="form-control" name="subject_id[]" id="subject4" required onchange="subject(4)">
                                                            <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-6 col-sm-6 col-xs-12">
                                                    <div class="input-group mg-b-pro-edt">
                                                        <input type="number" name="marks[]" class="form-control" placeholder="Marks" required>
                                                    </div>
                                                </div>
                                                
                                                <div class="col-md-6 col-sm-6 col-xs-12">
                                                    <div class="input-group mg-b-pro-edt">
                                                        <select class="form-control" name="subject_id[]" id="subject5" required onchange="subject(5)">
                                                            <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-6 col-sm-6 col-xs-12">
                                                    <div class="input-group mg-b-pro-edt">
                                                        <input type="number" name="marks[]" class="form-control" placeholder="Marks" required>
                                                    </div>
                                                </div>

                                                <div class="col-md-6 col-sm-6 col-xs-12">
                                                    <div class="input-group mg-b-pro-edt">
                                                        <select class="form-control" name="subject_id[]" id="subject6" required onchange="subject(6)">
                                                            <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-6 col-sm-6 col-xs-12">
                                                    <div class="input-group mg-b-pro-edt">
                                                        <input type="number" name="marks[]" class="form-control" placeholder="Marks" required>
                                                    </div>
                                                </div>
                                                
                                                

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

                                </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'); ?>