<?php 
session_start();
include("admin/include/config.inc.php");
include("include/header.php"); 


?>                        


<div class="bodySection m-t-lg">
    <div class="container">
        <div class="row">
            <div class="col-md-8">
                <div class="workingArea m-t-lg">                              
                    <div class="tpsubMen"></div>
                    <div class="textArea">
                        <h1 class="site-header">Student Corner</h1>


                        <?php
                        if(!isset($_SESSION["stuusername"]) && empty($_SESSION["stuusername"])){
                            ?>
                            <div class="col-md-4" style="margin-left: auto;margin-right: auto; margin-bottom:100px;border:0px solid #dcdcdc;text-align:center;padding: 20px;"></div>
                            <div class="col-md-4" style="margin-left: auto;margin-right: auto; margin-bottom:100px;border:1px solid #dcdcdc;text-align:center;padding: 20px;border-radius:10px;">
                                      <a href="#" class="" data-toggle="modal" data-target="#myModal"><h3 style="color:#00b0ea;text-transform: none;"><i class="fa fa-download fa-lg orange"></i> Study Materials</h3></a>
                            </div>
                            <div class="col-md-4" style="margin-left: auto;margin-right: auto; margin-bottom:100px;border:0px solid #dcdcdc;text-align:center;padding: 20px;"></div>
                            <?php
                        }else{
                            $form_data=mysqli_fetch_all(mysqli_query($con,"SELECT coursename FROM `studentcorner` GROUP by coursename"),MYSQLI_ASSOC);
                            $form_data_year=mysqli_fetch_all(mysqli_query($con,"SELECT year FROM `studentcorner` GROUP by year"),MYSQLI_ASSOC);
                            $form_data_semester=mysqli_fetch_all(mysqli_query($con,"SELECT semester FROM `studentcorner` GROUP by semester"),MYSQLI_ASSOC);
                            $form_data2=mysqli_fetch_all(mysqli_query($con,"SELECT title,papercode,CONCAT(papercode,'(',title,')') as pappercode_title FROM `studentcorner`"),MYSQLI_ASSOC);
                            
                            //echo '<pre>';print_r($form_data);die;

                            ?>
                            <p><h1 class="site-header2">Study Material</h1></p>
                            <div class="row">
                                <div class="col-md-12">
                                    <form action="student_corner.php" method="post">
                                        <div class="form-group">
                                            <label class="label-control">Course</label>
                                            <select class="form-control" name="course_name" id="course_name" required>
                                                <option value="">Select Course</option>
                                                 <?php
                                                if(!empty($form_data)){
                                                    foreach ($form_data as $key => $value) {
                                                        ?>
                                                        <option value="<?php echo $value['coursename'];?>"><?php echo $value['coursename'];?></option>
                                                        <?php
                                                    }
                                                    
                                                }
                                                ?>
                                            </select>
                                        </div>
                                        <div class="form-group">
                                            <label class="label-control">Year</label>
                                            <select class="form-control" name="course_year" id="course_year" required>
                                                <option value="">Select Year</option>
                                                <?php
                                                if(!empty($form_data_year)){
                                                    foreach ($form_data_year as $key => $value) {
                                                        ?>
                                                        <option value="<?php echo $value['year'];?>"><?php echo $value['year'];?></option>
                                                        <?php
                                                    }
                                                    
                                                }
                                                ?>
                                                
                                            </select>
                                        </div>
                                        <div class="form-group">
                                            <label class="label-control">Semester</label>
                                            <select class="form-control" name="course_semester" id="course_semester" required>
                                                <option value="">Select Semester</option>
                                                <?php
                                                if(!empty($form_data_semester)){
                                                    foreach ($form_data_semester as $key => $value) {
                                                        ?>
                                                        <option value="<?php echo $value['semester'];?>"><?php echo $value['semester'];?></option>
                                                        <?php
                                                    }
                                                    
                                                }
                                                ?>
                                            </select>
                                        </div>
                                        <div class="form-group">
                                            <label class="label-control">Papercode with Title</label>
                                            <select class="form-control" name="course_papercode" id="course_papercode" required>
                                                <option value="">Select Papercode with Title</option>
                                                 <?php
                                                if(!empty($form_data2)){
                                                    foreach ($form_data2 as $key => $value) {
                                                         ?>
                                                        <option value="<?php echo $value['papercode'];?>"><?php echo $value['pappercode_title'];?></option>
                                                        <?php
                                                    }  
                                                }
                                                ?>
                                            </select>
                                        </div>
                                        <div class="form-group">
                                           <button type="submit" class="btn btn-success" name="search_papers">Sumbit</button>
                                           <a href="logout.php" class="btn btn-primary">Logout</a>
                                        </div>
                                    </form>
                                        
                                </div>
                            </div>

                            <div class="row">
                                <div class="col-md-12">
                                    <div class="table-responsive">
                                        <table class="table table-bordered" id="study_material_table">
                                            <thead>
                                              <tr>
                                                <th>#</th>
                                                <th>Course</th>
                                                <th>Title</th>
                                                <th>Action</th>
                                              </tr>
                                            </thead>
                                            <tbody>
                                                <?php if(isset($_POST['search_papers'])){
                                                    
                                                    $course_name=$_POST["course_name"];
                                                    $course_year=$_POST["course_year"];
                                                    $course_semester=$_POST["course_semester"];
                                                    $course_papercode=$_POST["course_papercode"];
                                                
                                                ?>
                                                <?php  $sql ="select * from studentcorner WHERE coursename='".$course_name."' AND  semester='".$course_semester."' AND  papercode ='".$course_papercode."' AND  year ='".$course_year."'"; ?>
                                                <?php $qrrrr= mysqli_query($con,$sql); $i=1; ?>
                                                <?php while($value = mysqli_fetch_array($qrrrr)){ ?>
                                                
                                                <tr>
                                                    <td><?php echo $i; ?></td>
                                                    <td><?php echo $value['coursename']; ?></td>
                                                    <td><?php echo $value['title']; ?></td>
                                                    <td><a href="http://jcboseedu.org/viewer.php?utm_f=<?php echo $value['filecode']; ?>" class="btn btn-sm btn-primary" target="_blank">Download</a></td>
                                                </tr>
                                                
                                                <?php $i++; } ?>
                                                <?php }else{ ?>
                                                <tr><td colspan="4" style="text-align: center;">No data found</td></tr>
                                                <?php } ?>
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                            <?php
                        }


                        ?>


                            
                    </div>
                </div>         
            </div>
            <div class="col-md-4">
                <?php
                include("include/admission_query.php");
                ?>                    
            </div>
        </div>
    </div>
</div>
            
<?php
    include("include/footer.php");
?>
            
</div>


<?php

 if(!isset($_SESSION["stuusername"]) && empty($_SESSION["stuusername"])){
    ?>
    <div class="modal fade" id="myModal">
        <div class="modal-dialog">
          <div class="modal-content">
          
            <!-- Modal Header -->
            <div class="modal-header">
              <h4 class="modal-title" style="color: green;">Login</h4>
              <button type="button" class="close" data-dismiss="modal" style="color: #ffffff;">&times;</button>
            </div>
            
            <!-- Modal body -->
            <div class="modal-body">
              <form method=post action="">
                    <div class="form-group">
                        <input name="email" class="form-control" type="text" id="uname" placeholder="Student Username" required/>
                    </div>
                    
                    <div class="form-group">
                        <input name="password" class="form-control" type="password" id="upass" placeholder="Password" required/>
                    </div>

                  <div class="form-group">
                     
                    <input type="button"  style="float:right" id="chklogin" name="submit" class="btn btn-success cs-brown-btn hvr-curl-top-left" value="Login"/>
                    <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
                  </div> 
              </form>
            </div>
            

          </div>
        </div>
      </div>
    <?php
 }

?>

<style type="text/css">
    .site-header {
        text-align:center;
       text-decoration: underline;
    }
    .site-header2 {
        text-align:center;
    }
</style>
        
<link rel="stylesheet" type="text/css" href="scripts/site/jquery.mmenu.all.css">
  <link href="scripts/site/bootstrap.min.css" rel="stylesheet" type="text/css"/>
  <link href="scripts/theme/nav.css" rel="stylesheet" type="text/css"/>
  <link href="scripts/theme/owl.carousel.min.css" rel="stylesheet" type="text/css"/>
  <link href="scripts/site/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css"/>
  <link href="scripts/content.css" rel="stylesheet" type="text/css"/>
  <script src="scripts/site/bootstrap.min.js" type="text/javascript"></script>
  <script src="scripts/theme/owl.carousel.min.js" type="text/javascript"></script>
  <script src="scripts/site/javascript.js" type="text/javascript"></script>
  <script type="text/javascript" src="scripts/site/jquery.mmenu.min.all.js"></script>

  <script type="text/javascript">

      jQuery(window).load(function() {
        var preload = jQuery(".preload");
        preload.fadeOut("slow");
      });
      
      $("#qSubmit").click(function(){quickQuery();});
      $(".lemmenuToggle").click(function(){
          if($(this).next('ul').hasClass('hidden')){ $(this).html('<i class="fa fa-angle-down selt" aria-hidden="true"></i>'); $(this).next('ul').removeClass('hidden');}
          else{$(this).html('<i class="fa fa-angle-right" aria-hidden="true"></i>');$(this).next('ul').addClass('hidden');}
      });
      
      jQuery(document).ready(function ($) {
          // for Slider
          $('.topslider').removeAttr('style');
                      });
      $(function () {
        $('[data-toggle="tooltip"]').tooltip()
      });
      
<?php
    if(!isset($_SESSION["stuusername"]) && empty($_SESSION["stuusername"])){
        ?>
        $("#chklogin").click(function(){
            $.ajax({
              type:'POST',
              url:'logincheck.php',
              data:{uname:$('#uname').val(),upass:$('#upass').val()},
              beforeSend:function(){
                $('#chklogin').html('Validating...').attr('disabled',true);
              },
              success:function(d){
                if(d.redirect){
                  window.location.href=d.redirect;
                }else{
                  alert(d.error);
                  $('#chklogin').html('Login').attr('disabled',false);
                }
              }
            });
          });
        <?php
    }else{
        ?>
        $('#search_study_material').click(function(){
            $.ajax({
                type:'POST',
                url:'stucornercheck.php',
                data:$('#studey_material_form').serialize(),
                beforeSend:function(){
                    $('#search_study_material').html('......').attr('disabled',true);
                },
                success:function(d){
                   // var dddd = JSON.parse(d);
                    alert(d);
                   $('#study_material_table tbody').html(d);
                },
                complete:function(){
                    $('#search_study_material').html('Submit').attr('disabled',false);
                }
            });
        });
        <?php
    }

?>

    
              
  </script>
    </body>
</html>