<?php
//error_reporting(0);
	define('INCLUDE_CHECK',true);
	session_start();
	require ('classes/config2.php');
	require_once('classes/session.php');
   // require ('class/config1.php');
   
 ?>
<title>OSCOTECH, ESA-OKE :: Admin-Dashboard > Admission Operation Student List</title>


        <div id="page-wrapper">
            <div class="row">
                <div class="col-lg-12">
                    <h1 class="page-header">Admission List By Programme and Department</h1>
                </div>
                <!-- /.col-lg-12 -->
            </div>
            <!-- /.row -->
            <div class="row">
                <div class="col-lg-12">
                	<div class="well" style="background:#FFF">
                    	<form method="post" action="" role="form">                        	
                        	<div class="form-group input-group">
                        	<table class="table table-bordered table-hover">
                            	<tr>
                                	<td>
                                        <select name="department" id="department"  class="form-control">
                                          <option value="">-- Select Department -- </option>
                                            <?php 
                                                    $getdept = ("SELECT dept FROM department");
                                                    $result = $conn1->query($getdept);
                                                   // while($row = mysql_fetch_array($getdept)){
                                                   while($row = $result->fetch_assoc()) {
                                                ?>
                                                    <option value="<?php echo $row['dept'] ?>"><?php echo $row['dept']?></option>
                                                <?php
                                                    }
                                            ?>
                                        </select>
                                	</td>
                                    <td>
                                    <select name="progtype" class="form-control" id="progtype">
                                            <option value="">--Select Session--</option>
                                            <option value="PU210">Post UTME</option>
                                            <option value="DP210">Daily-Part-Time</option>
                                            <option value="FT210">Full Time HND</option>
                                            <option value="DP210">Daily PArt Time HND</option>
                                             <option value="PGD">Full Time PGD</option>
                                             <option value="CAPND">Weekend Part Time ND</option>
                                             <option value="CAPHND">Weekend Part Time HND</option>
                                        </select>
                                    </td>
                                    <td>
                                    	<select name="session" class="form-control" id="session">
                                            <option value="">--Select Session--</option>
                                            
                                            <option value="2019/2020">2019/2020</option>
                                            <option value="2020/2021">2020/2021</option>
                                     </option>
                                            <option value="2021/2022">2021/2022</option>
                                        </select>
                                    </td>
                                    <td>
                                    	<select name="sex" class="form-control" id="sex">
                                            <option value="">--Select Sex--</option>
                                            
                                            <option value="male">Male</option>
                                            <option value="female">Female</option>
                                     </option>
                                            
                                        </select>
                                    </td>
                                      
                                 <!--   <td>
				                       <input type="text" class="form-control" placeholder="From: yyyy-mm-dd"name="fromdate" title="Uploading Date " autocomplete="on">
                                    </td>
                                    <td>
				                       <input type="text" class="form-control" placeholder="To: yyyy-mm-dd"name="todate" title="Uploading Date " autocomplete="on">
                                    </td> -->
                                	<td>
                                        <span class="input-group-btn">
                                            <input type="submit" class="btn btn-danger" name="btnsearch" value="Search" id="button-search" title="Search Student">
                                        </span>
                                    </td>
                             	</tr>
                            </table>
                            </div>
                        </form>
                    </div>
                    <form action="" method="post">
                    <div class="panel panel-primary chat-panel">
                        <div class="panel-heading ">
                            Student Details Table
                        </div>
                        <!-- /.panel-heading -->
                        <div class="panel-body">
                            <div class="dataTable_wrapper">
                                <table class="table table-bordered table-hover">
                                    <thead>
                                        <tr height="20">
                                            <th>S/N</th>
                                            <th>MATRIC NO</th>
                                            <th>SURNAME</th>
                                            <th>OTHER NAMES</th>
                                            <th>EMAIL</th>
                                            <th>PROGRAMME</th>
                                            <th>COURSES</th>
                                            
                                         <!--   <th>PROV</th>
                                            <th>CONC</th> -->
                                        </tr>
                                    </thead>
					<?php
							$_SESSION['sek']= $_POST['session'];
							$_SESSION['department']= $_POST['department'];
							$_SESSION['progtype']= $_POST['progtype'];
						//	$_SESSION['fromdate']= $_POST['fromdate'];
						//	$_SESSION['todate']= $_POST['todate'];
							$department=$_POST['department'];
							$progtype=$_POST['progtype'];
							$_SESSION['sex']=$_POST['sex'];
							$sex=$_POST['sex'];
						//	$key="FT";
							echo $department,$progtype,$_POST[session],$sex;
							
                        	if($_POST['progtype']=='DP210' )
                        	  {
                        		$sql1=("SElECT form_datasex.formno,form_datasex.sex
                        		student_activity_level.matricno, student_activity_level.formno
                             	FROM  student_activity_level
                             	JOIN form_datasex
                                ON student_activity_level.formno like '$progtype' 
                                
                                AND student_activity_level.formno=form.datasex.formno
                                AND student_activity_level.matricno<>'0'
                          order by student_activity_level.matricno
                                "); 
                        	 	$result = $conn1->query($sql1);     
                        	  }
                         
                         
							else							
								
								$sql=("SElECT student_account.id,student_account.surname, student_account.othernames,student_account.email, student_account.progtype,student_account.level,student_account.department,
							     admission_card_pin.acc_id,admission_card_pin.formno
                             	FROM  student_account
                             	JOIN admission_card_pin
                                ON student_account.id=admission_card_pin.acc_id
                                AND admission_card_pin.adm_status='not-admitted'
                                AND student_account.department='$department'
                                ");
									$result = $conn->query($sql);
								
							//	$sql = mysql_query("SELECT * FROM admission_2017_students_details
							//			WHERE courses='$courses' AND programme='$_POST[programme]' 
							//			AND formno  like '%$key%'
							//			AND reg_date Between '$_POST[fromdate]' AND '$_POST[todate]'
							//			AND session='$_POST[session]' AND status='not-admitted'");
                           
                        $i=0;
                       // while($row=mysql_fetch_array($sql)){
                       while($row = $result->fetch_assoc()) {
                        $i++;
                        $color=($i%2==0)?"lightblue":"white";
                        
                    ?>
                      
                            
                                    <tbody>
                                          
                                        <tr >
                                        	<td><?php echo $i;?></td>
                                           <td><?php echo $row['matricno'];?></td>
                                            <!-- <td><?php //echo trim($row['passport'],".jpg , .jpe, .png");?> </td>-->
                                            <td><?php echo $row['sex'];?></td>
                                            <td><?php// echo $row['othernames'];?></td>
                                            <td><?php //echo $row['email'];?></td>
                                            <td><?php //echo $row['progtype'];?></td>
                                            <td><?php echo// $row['department'];?></td>
                                         <!--   <td><input type="checkbox" name="sadmitted[]" value="<?php echo $row['formno']."P";?>" /></td>
                                          
                                            <td><input type="checkbox" name="sadmitted[]" value="<?php echo $row['formno']."C";?>" /></td>
                                         -->
                                        </tr>
                                    </tbody>
                          <?php	
                           
							}
							
							
						//	if ($_SESSION['programme']=='HND')
						//	{ ($_SESSION['pass'] ="HND") AND ($_SESSION['entry'] ="Higher National Diploma, Daily Part Time-2years");}
							*/ 							
							?>
                                </table>
                            </div>
                            <!-- /.table-responsive -->
                          
                        </div>
                        <!-- /.panel-body --> 
                    </div> 
                    <!-- /.panel -->
                    	<center>
                       		<!-- <a href="#" target="_new" class="btn btn-success">ADMITTED</a> -->
                            <input type="submit" class="btn btn-success" value="ADMITTED" name="adm" />
                            <p>&nbsp;</p>
                        </center>
                    </form>
                </div>
                <!-- /.col-lg-12 -->
            </div>
            <!-- /.row -->

        </div>
        <!-- /#page-wrapper -->
       

    </div>
    <!-- /#wrapper -->
    
