File manager - Edit - /var/www/ams.cmtc.ac.th/pages/admin-calendar-holiday.php
Back
<div class="card"> <div class="card-body"> <!-- <div align="right"><a href="?op=dues" class="btn btn-secondary" role="button"><i class="fa fa-share" aria-hidden="true"></i> ขั้นตอนต่อไป</a> </div> --> <h4>ภาคเรียนที่ <?=$semester?> ปีการศึกษา <?=$academicYear?></h4> <?php //echo "num_regis_payment_date=$num_regis_payment_date"; if($_POST['action']=="save"){ $holiday_date_add=$_POST['holiday_date_add']; $holiday_name_add=$_POST['holiday_name_add']; $holiday_note_add=$_POST['holiday_note_add']; $week=date("w",strtotime($holiday_date_add)); $result_week_day=select("week_day","where w='$week'"); $day_id=$result_week_day['day_id']; //ตรวจสอบว่ามีการกำหนดระยะเวลวการชำระเงินหรือยัง $num_holiday_date=num_record("holiday","where academicYear='$academicYear' and semester='$semester' and holiday_date='$holiday_date_add' "); //echo "num_regis_payment_date=$num_regis_payment_date"; if($num_holiday_date==0){ insert("NULL,'$academicYear','$semester','$holiday_name_add','$holiday_date_add','$day_id','$week','$holiday_note_add' ","holiday"); $_SESSION['msg']="<div class=\"alert alert-success\"><button type=\"button\" class=\"close\" data-dismiss=\"alert\">×</button><center><strong>Success!</strong> บันทึกข้อมูลเรียบร้อยแล้ว</center></div>"; }else{ $_SESSION['msg']="<div class=\"alert alert-warning\"><button type=\"button\" class=\"close\" data-dismiss=\"alert\">×</button><center><strong>Warning!</strong> มีข้อมูลวันหยุดนี้แล้ว</center></div>"; } echo "<meta http-equiv=\"refresh\" content=\"0;url=?op=calendar&module=holiday\">"; exit(); } //แก้ไขวันหยุด if($_POST['action']=="edit"){ $holiday_id_edit=$_POST['holiday_id_edit']; $holiday_date_edit=$_POST['holiday_date_edit']; $holiday_name_edit=$_POST['holiday_name_edit']; $holiday_note_edit=$_POST['holiday_note_edit']; $week=date("w",strtotime($holiday_date_edit)); $result_week_day=select("week_day","where w='$week'"); $day_id=$result_week_day['day_id']; //ตรวจสอบว่ามีการกำหนดระยะเวลวการชำระเงินหรือยัง update("holiday","holiday_date='$holiday_date_edit',holiday_name='$holiday_name_edit',holiday_name='$holiday_name_edit',holiday_note='$holiday_note_edit',day_id='$day_id',w='$week' ","where holiday_id='$holiday_id_edit'"); echo "<meta http-equiv=\"refresh\" content=\"0;url=?op=calendar&module=holiday\">"; exit(); } //ลบวันหยุด if($_POST['action']=="del" AND $_POST['confirm']=="yes" ){ $holiday_id_del=$_POST['holiday_id_del']; //echo"ลบข้อมูล $holiday_id_del"; //ตรวจสอบว่ามีการกำหนดระยะเวลวการชำระเงินหรือยัง delete("holiday","where holiday_id='$holiday_id_del'"); echo "<meta http-equiv=\"refresh\" content=\"0;url=?op=calendar&module=holiday\">"; exit(); } ?> <div class="container"> <div class="row"> <h3><i class="fa fa-plus" aria-hidden="true"></i> เพิ่มวันหยุด</h3> </div> <div class="row"> <form role="form" name="ss01" id="ss01" class="form-group" method="post" action=""> <div class="row"> <div class="col-lg-12"> <!-- <div class="alert alert-warning"><b>หมายเหตุ </b>เพิ่มวันหยุดราชการ หรือวันหยุดพิเศษที่วิทยาลัยฯ กำหนด</div> --> <?php if($_SESSION['msg']!=""){ $msg=$_SESSION['msg']; echo"$msg"; unset($_SESSION['msg']); } ?> </div> <div class="col-lg-3"> <div class="form-group" align="left"> <label for="facademicYear">วันที่</label> <input name="holiday_date_add" type="date" class="form-control" id="holiday_date_add" required> </div></div> <div class="col-lg-3"> <div class="form-group" align="left"> <label for="facademicYear">ชื่อวันหยุด</label> <input name="holiday_name_add" type="text" class="form-control" id="holiday_name_add" required> </div> </div> <div class="col-lg-3"> <div class="form-group" align="left"> <label for="facademicYear">หมายเหตุ</label> <input name="holiday_note_add" type="text" class="form-control" id="holiday_note_add" > </div> </div> <div class="col-lg-3"> <div class="form-group" align="left"> <label for="facademicYear"> </label> <br> <button type="submit" class="btn btn-primary" id="btnConfirm" ><i class="fa fa-plus fa-fw"></i> เพิ่มข้อมูล</button> </div> </div> <div class="col-lg-12"> <hr></div> <input name="action" type="hidden" id="action" value="save"> </div> </form> </div> </div> <div class="row"> <div class="container"> <h3><i class="fa fa-calendar fa-1x" aria-hidden="true"></i> วันหยุด ภาคเรียนที่ <u><?=$semester?></u> ปีการศึกษา <u><?=$academicYear?></u> </h3> <?php global $connect; $sql="Select * From holiday where academicYear='$academicYear' and semester='$semester' order by holiday_date ASC"; $db_query=mysqli_query($connect,$sql); $num_rows=mysqli_num_rows($db_query); /* นับ Reccord ที่พบ */ echo "จำนวนวันหยุด จำนวน <u>$num_rows</u> วัน "; ?> <table class="table table-hover table-striped table-condensed table-sm table-bordered "> <thead> <tr> <th><center>#</center></th> <th>วันที่ เดือน ปี</th> <th><center>วัน</center></th> <th>ชื่อวันหยุด</th> <th>หมายเหตุ</th> <th>จัดการ</th> </tr> </thead> <tbody> <?php $a=0; $no=1; $sum_group=0; $sum_student=0; while($a < $num_rows) { $result = mysqli_fetch_array($db_query); $holiday_id=$result['holiday_id']; $holiday_name=$result['holiday_name']; $holiday_date=$result['holiday_date']; $holiday_note=$result['holiday_note']; $num_teacher=num_record("department_teacher","where department_id='$department_id' "); ?> <tr> <td align="center"><?php echo $no;?>.<a name="<?=$holiday_id?>" id="<?=$holiday_id?>"></a></td> <td><?=thai2($holiday_date)?> (<?=$holiday_date?>)</td> <td><center><?=day_week($holiday_date)?></center></td> <td><?=$holiday_name?></td> <td><?=$holiday_note?></td> <td><center> <button type="button" class="btn btn-sm btn-outline-primary" data-toggle="modal" data-target="#myModalEdit<?=$holiday_id?>"><i class="fa fa-pencil" aria-hidden="true"></i> แก้ไข</button> <button type="button" class="btn btn-sm btn-outline-danger" data-toggle="modal" data-target="#myModalDel<?=$holiday_id?>"><i class="fa fa-trash-o" aria-hidden="true"></i> ลบ</button> </center> </td> </tr> <!-- The Modal แก้ไข--> <div class="modal" id="myModalEdit<?=$holiday_id?>"> <div class="modal-dialog modal-dialog-centered"> <div class="modal-content"> <!-- Modal Header --> <div class="modal-header"> <h4 class="modal-title"><i class="fa fa-pencil" aria-hidden="true"></i> แก้ไขวันหยุด</h4> <button type="button" class="close" data-dismiss="modal">×</button> </div> <!-- Modal body --> <div class="modal-body"> <form action="" method="post"> <div class="form-group"> <label for="email">วันที่:</label> <input type="date" class="form-control" name="holiday_date_edit" value="<?=$holiday_date?>" required> </div> <div class="form-group"> <label for="pwd">ชื่อวัน:</label> <input type="text" class="form-control" name="holiday_name_edit" value="<?=$holiday_name?>" required> </div> <div class="form-group"> <label for="pwd">หมายเหตุ:</label> <input type="text" class="form-control" name="holiday_note_edit" value="<?=$holiday_note?>"> </div> <button type="submit" class="btn btn-primary">บันทึก</button> <button type="button" class="btn btn-secondary" data-dismiss="modal">ปิด</button> <input name="action" type="hidden" id="action" value="edit"> <input name="holiday_id_edit" type="hidden" id="holiday_id_edit" value="<?=$holiday_id?>"> </div> <!-- Modal footer --> <div class="modal-footer"> </div> </form> </div> </div> </div> <!-- The Modal ลบ--> <div class="modal" id="myModalDel<?=$holiday_id?>"> <div class="modal-dialog modal-dialog-centered"> <div class="modal-content"> <!-- Modal Header --> <div class="modal-header"> <h4 class="modal-title"><i class="fa fa-trash-o" aria-hidden="true"></i> ลบวันหยุด</h4> <button type="button" class="close" data-dismiss="modal">×</button> </div> <!-- Modal body --> <div class="modal-body"> <form action="" method="post"> <p>วันที่ : <?=thai2($holiday_date)?> (<?=$holiday_date?>) <br>ชื่อวันหยุด : <?=$holiday_name?> <br>หมายเหตุ : <?=$holiday_note?></p> <p><input type="checkbox"name="confirm" value="yes" onchange="document.getElementById('sendDel<?=$holiday_id?>').disabled = !this.checked;"> ยืนยันต้องการลบข้อมูลวันหยุด ?</p> <input name="holiday_id_del" type="hidden" id="holiday_id_del" value="<?=$holiday_id?>"> <button type="submit" class="btn btn-danger" name="sendDel" id="sendDel<?=$holiday_id?>" disabled>ลบ</button> <button type="button" class="btn btn-secondary" data-dismiss="modal">ปิด</button> <input name="action" type="hidden" id="action" value="del"> </div> <!-- Modal footer --> <div class="modal-footer"> </div> </form> </div> </div> </div> <?php $no++; $a++; } ?> </tbody> </table> </div> </div> </div> </div>
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.53 |
proxy
|
phpinfo
|
Settings