File manager

File manager - Edit - /var/www/ams.cmtc.ac.th/pages/admin-summarize-groups-list.php

Back
<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>  <?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>  <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>  <?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 } ?>

| ver. 1.4 | Github | . | PHP 7.4.33 | Generation time: 0.51 | proxy | phpinfo | Settings