
<?php
$day=$_GET['day'];
?>
 <hr>
<h2>เพิ่มกลุ่มเรียน/ห้องเรียน </h2>
<div align="right">
 <a href="?op=calendar&module=group-day&p=day&day=<?=$_GET['day']?>&w=<?=$_GET['w']?>&sday_name=<?=$_GET['sday_name']?>&level=1#data2" class="btn btn-sm btn-primary" role="button">ปวช.1</a>
 <a href="?op=calendar&module=group-day&p=day&day=<?=$_GET['day']?>&w=<?=$_GET['w']?>&sday_name=<?=$_GET['sday_name']?>&level=2#data2" class="btn btn-sm btn-secondary" role="button">ปวช.2</a>
 <a href="?op=calendar&module=group-day&p=day&day=<?=$_GET['day']?>&w=<?=$_GET['w']?>&sday_name=<?=$_GET['sday_name']?>&level=3#data2" class="btn btn-sm btn-success" role="button">ปวช.3</a>
 <a href="?op=calendar&module=group-day&p=day&day=<?=$_GET['day']?>&w=<?=$_GET['w']?>&sday_name=<?=$_GET['sday_name']?>&level=4#data2" class="btn btn-sm btn-info" role="button">ปวส.1</a>
 <a href="?op=calendar&module=group-day&p=day&day=<?=$_GET['day']?>&w=<?=$_GET['w']?>&sday_name=<?=$_GET['sday_name']?>&level=5#data2" class="btn btn-sm btn-warning" role="button">ปวส.2</a>
 <a href="?op=calendar&module=group-day&p=day&day=<?=$_GET['day']?>&w=<?=$_GET['w']?>&sday_name=<?=$_GET['sday_name']?>&level=all#data2" class="btn btn-sm btn-dark" role="button">ทั้งหมด </a>
</div>    
<hr>

      <p>ระดับ <u>
    <?php
    if($level==""){
        echo "ทั้งหมด";
    }
    if($level==1){
        echo "ปวช.1";
    }
    if($level==2){
        echo "ปวช.2";
    }
    if($level==3){
        echo "ปวช.3";
    }
    if($level==4){
        echo "ปวส.1";
    }
    if($level==$sql5){
        echo "ปวส.2";
    }
    if($level=="all"){
        echo "ทั้งหมด";
    }
    
    
    ?></u> </p>
 <!--  เริ่มกลุ่มเรียน -->
<?php        
//ดึงข้อมูลกลุ่มเรียน
global $connect;	
if($_GET[level]==""){
    //ค่าเร่ิมต้นปวช. 1     
	$sql="Select * From regis_group,std2018_studentgroup where  regis_group.academicYear='$academicYear' AND regis_group.semester='$semester'  AND regis_group.status='1'  AND regis_group.groupCode=std2018_studentgroup.groupCode order by regis_group.level_no,regis_group.groupCode  ASC";
}elseif($_GET[level]=="all"){
    $sql="Select * From regis_group,std2018_studentgroup where regis_group.academicYear='$academicYear' AND regis_group.semester='$semester'  AND regis_group.status='1'  AND regis_group.groupCode=std2018_studentgroup.groupCode order by regis_group.level_no,regis_group.groupCode  ASC";
}else{
    $sql="Select * From regis_group,std2018_studentgroup where regis_group.level_no='$_GET[level]' AND regis_group.academicYear='$academicYear' AND regis_group.semester='$semester'  AND regis_group.status='1'  AND regis_group.groupCode=std2018_studentgroup.groupCode order by regis_group.groupCode ASC";
}
	
$db_query=mysqli_query($connect,$sql);
$num_rows=mysqli_num_rows($db_query); /* นับ Reccord ที่พบ */
if($num_rows==0){
    echo "<div class=\"alert alert-warning\"><center>ไม่พบข้อมูลกลุ่มเรียน/ห้องเรียน.</center></div>";
}else{
?>
  <table class="table table-hover table-striped table-condensed table-sm table-bordered">
    <thead>
		
      <tr>
        <th><center>#</center></th>
        <th>ระดับ</th>
        <th>รหัสกลุ่ม</th>
		<th>ชื่อกลุ่ม</th>  
		
		<th colspan="5"><center>
		  จำนวนนักศึกษา
		
		</center>
<center>
</center></th>
		<th width="260"><center>จัดการ</center></th>     
      </tr>
    </thead>
    <tbody>
<?php
$totalStudent=0;		
$a=0;
$no=1;		
while($a < $num_rows)
{
	$result = mysqli_fetch_array($db_query);
	$regis_group_id=$result['id'];
	$level_no=$result['level_no'];
	$grade=$result['grade'];
	$groupCode=$result['groupCode'];
	$groupName=$result['groupName'];
	$groupAbbr=$result['groupAbbr'];
	$teacherIdcard=$result['teacherIdcard'];
	$teacherFirstname=$result['teacherFirstname'];
	$teacherLastname=$result['teacherLastname'];

	//นับจำนวนนักศึกษาในกลุ่มเรียน
	$num_student=num_record("std2018_student","where groupCode='$groupCode' AND studentStatusCode='03'");
	//echo $num_student;
	$totalStudent=$totalStudent+$num_student;
	
	//เช็คว่าเลือกกลุ่มเรียนนี้แล้วหรือยัง
	$num_have=num_record("week_group","where academicYear='$academicYear' AND semester='$semester' AND groupCode='$groupCode' AND day_id='$day' ");
    //echo "day=$day num_have=$num_have<br>";
    //ถ้ามีไม่ต้องแสดงกลุ่มนี้
    if($num_have==0){
    
	
	?>		
      <tr class="success">
        <td><center><?=$no?>.<a name="t<?=$no?>" id="t<?=$no?>"></a>
        </center></td>
        <td><?=$grade?></td>
        <td><?=$groupCode?></td>
		<td><?=$groupName?>  (<?=$groupAbbr?>)<br>
		  ครูที่ปรึกษา (หลัก)  <br><?php echo "$teacherIdcard ครู$teacherFirstname  $teacherLastname"; ?>
		<?php
		//ดึงข้อมูลที่ปรึกษาร่วม
		  $sql5="Select * From regis_studentgroup where groupCode='$groupCode'";
		  $db_query5=mysqli_query($connect,$sql5);
		  $num_rows5=mysqli_num_rows($db_query5);
		  if($num_rows5!=0){
			  echo "<br>ครูที่ปรึกษา (ร่วม)";
		  }	
		  $a5=0;
		  while($a5 < $num_rows5)
		  {
			$result5 = mysqli_fetch_array($db_query5);
			$del_id=$result5['id'];
			$teacherIdcard2=$result5['teacherIdcard'];
			$teacherFirstname2=$result5['teacherFirstname'];
			$teacherLastname2=$result5['teacherLastname'];
			echo "<br>- $teacherIdcard2 ครู$teacherFirstname2 $teacherLastname2";  
			?>
			
			<?php
			$a5++;
		  }

	
		?>
		  </td> 

        <td colspan="5"><center><?=$num_student?></center>
</td>
	    <td><center>
	      <a href="?op=calendar&module=group-day&p=day&day=<?=$_GET['day']?>&w=<?=$_GET['w']?>&level=<?=$_GET['level']?>&level_no=<?=$level_no?>&groupCode=<?=$groupCode?>&add=group" class="btn btn-sm btn-outline-info" role="button"><i class="fa fa-level-up" aria-hidden="true"></i> นำเข้า</a>
	      
</center></td>  
      </tr>
		
 <?php
            $no++;
    }
	$a++;
}
		

?>	

    </tbody>
  </table>     
<?php
    //echo "no=$no<br>";
    if($no<=1){
         echo "<div class=\"alert alert-warning\"><center>ไม่มีกลุ่มเรียน/ห้องเรียน.</center></div>";
    }
    
?>    
 <!--  สิ้นสุดกลุ่มเรียน -->	
<?php } ?>
