<h4>กลุ่มเรียน</h4>



<?php		
$show=$_GET['show'];
//echo $_SESSION['login2'];	

		//ดึงข้อมูลกลุ่มเรียน
global $connect;	
if($_SESSION['login']=="admin" || $_SESSION['login']=="user"){		
		if($_GET['show']=="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='$id' 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";
		}
}else{	
	if($_SESSION['login2']=="advisor1"){
		echo "ครูที่ปรึกษาหลัก";
		$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 AND std2018_studentgroup.teacherIdcard='$teacherIdcard' order by regis_group.level_no,regis_group.groupCode ASC";
	}else{
		echo "ครูที่ปรึกษาร่วม $teacherIdcard";
		$sql="Select * From regis_group,regis_studentgroup where regis_group.academicYear='$academicYear' AND regis_group.semester='$semester'  AND regis_group.status='1' AND regis_group.groupCode=regis_studentgroup.groupCode AND regis_studentgroup.teacherIdcard='$teacherIdcard' ";

	}
}
	
$db_query=mysqli_query($connect,$sql);
$num_rows=mysqli_num_rows($db_query); /* นับ Reccord ที่พบ */
//echo "num_rows=$num_rows";	
if($num_rows==0){
	echo"<div class=\"alert alert-warning\"><center>ไม่พบกลุ่มเรียนที่เป็นที่ครูปรึกษา.</center></div>";
}else{	
	echo "มีจำนวน <b>$num_rows</b> กลุ่มเรียน";
?>
  <table class="table table-hover table-striped table-condensed table-sm table-bordered">
    <thead>
		      <tr>
        <th width="15%" valign="bottom"><center>#</center></th>
        <th width="14%" valign="bottom">ระดับ</th>
        <th width="18%" valign="bottom">รหัสกลุ่ม</th>
        <th width="16%" valign="bottom">ชื่อกลุ่ม</th>
        <th width="10%"><center></center>          <center> 
          ทั้งหมด</center></th>
        <th width="27%" valign="bottom"><center>จัดการ</center></th>
      </tr>
    </thead>
    <tbody>
<?php
$a=0;
while($a < $num_rows)
{
	$result = mysqli_fetch_array($db_query);
	$regis_group_id=$result['id'];
	$grade=$result['grade'];
	$groupCode=$result['groupCode'];
	$groupName=$result['groupName'];
	$teacherFirstname=$result['teacherFirstname'];
	$teacherLastname=$result['teacherLastname'];
	$credit=$result['credit'];
	$cost_credit=$result['cost_credit'];
	$cost_value=$result['cost_value'];
	$cost_total=$cost_credit+$cost_value;
	//นับจำนวนนักศึกษาในกลุ่มเรียน
	$num_student=num_record("std2018_student","where groupCode='$groupCode' AND studentStatusCode='03'");
	//echo $num_student;
	//ตรวจสอบกลุ่มมีการกำหนดค่าธรรมเนียนมแล้วหรือยัง 
	$check_regis_groupt=select("regis_group","where academicYear='$academicYear' AND semester='$semester' AND groupCode='$groupCode' AND status='1' ");
	$check1=$check_regis_groupt['credit'];
	$check2=$check_regis_groupt['cost_value'];
	
	//นับจำนวน นักศึกษาชำระเงิน
	$num_payment=num_record("regis_payment_log","where academicYear='$academicYear' AND semester='$semester' AND groupCode='$groupCode' ");
	//echo "groupCode =$groupCode num_payment=$num_payment  academicYear=$academicYear  semester=$semester  <br> ";
	//จำนวนที่ค้าชำระเงิน
	$num_lost=$num_student-$num_payment;
	if($num_payment==0){ $num_payment="-"; }
	//เช็คจำนวนที่ลงทะเบียนครบ
	if($num_student<=$num_payment){ $ok_total=1; }else{ $ok_total=0; }
	?>		
      <tr class="success">
        <td><center><?php echo $a+1; ?>.<a name="<?=regis_group_id?>" id="<?=$regis_group_id?>"></a>
        </center></td>
        <td><?=$grade?></td>
        <td><?=$groupCode?></td>
		<td><?=$groupName?><br><font size="-1"><?php if($teacherFirstname!=""){ echo"ที่ปรึกษา ครู$teacherFirstname  $teacherLastname";  }?></font></td>  
         
        <td><center><?=$num_student?></center></td> 
	    <td><center>
  <?php
		if($_SESSION['login']=="admin"){	
?>	
		    
		    <a href="?op=summarize&module=student&form=summarize&id=<?=$id?>&regis_group_id=<?=$regis_group_id?>&level_id=<?=$level_id?>&groupCode=<?=$groupCode?>&show=<?=$show?>&studentStatusCode=03#data" class="btn btn-sm btn-info" role="button"><i class="fa fa-street-view" aria-hidden="true"></i>รายชื่อ</a>&nbsp;
  <?php 
		 } 
		 //สำหรับครูที่ปรึกษา
 if($_SESSION['login']=="advisor"){		
     
     
?>
            <a href="?op=student-list-checking&module=student&form=advisor&id=<?=$id?>&regis_group_id=<?=$regis_group_id?>&level_id=<?=$level_id?>&groupCode=<?=$groupCode?>&show=<?=$show?>&studentStatusCode=03#data" class="btn btn-sm btn-success" role="button"><i class="fa fa-file-text-o" aria-hidden="true"></i> เช็คชื่อ</a>&nbsp;
		    <a href="?op=home&module=student&form=advisor&id=<?=$id?>&regis_group_id=<?=$regis_group_id?>&level_id=<?=$level_id?>&groupCode=<?=$groupCode?>&show=<?=$show?>&studentStatusCode=03#data" class="btn btn-sm btn-info" role="button"><i class="fa fa-street-view" aria-hidden="true"></i> รายชื่อ</a>&nbsp;
  <?php } ?>
<!--		    <a href="pages/export-studentRegis.php?ex=xls&groupCode=<?=$groupCode?>" class="btn btn-primary btn-sm " role="button"><i class="fa fa-file-excel-o" aria-hidden="true"></i> ส่งออก</a> -->
		    
		    
        </center></td>  
      </tr>
 <?php
	$a++;
}
?>	
    </tbody>
  </table>
<?php } ?>