File manager - Edit - /var/www/ams.cmtc.ac.th/pages/admin-calendar-group-itemadd.php
Back
<?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 } ?>
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.5 |
proxy
|
phpinfo
|
Settings