File manager - Edit - /var/www/ams.cmtc.ac.th/pages/statistics-pament-date.php
Back
<p>ข้อมูลจำนวนการชำระเงินในแต่ละวัน ภาคเรียนที่ <?=$semester?> ปีการศึกษา <?=$academicYear?> </p> <?php function date_in_period($start, $end){ $output = array(); $days = floor((strtotime($end) - strtotime($start))/86400); for($i=0;$i<=$days;$i++){ //array_push($output, date("d-m-Y",strtotime("+" . $i . " day", strtotime($start)))); array_push($output, date("Y-m-d",strtotime("+" . $i . " day", strtotime($start)))); } return $output; } ?> <table class="table table-hover table-striped table-condensed table-sm table-bordered "> <thead> <tr> <th width="10%"><center>#</center></th> <th>วัน เดือน ปี</th> <th style="text-align: right" width="30%">จำนวนนักศึกษาชำระเงิน</th> <th width="20%"><center>ส่งออก</center></th> </tr> </thead> <tbody> <?php $date = date_in_period("$payment_date_start", "$payment_date_end"); $no=1; $total_num_date=0; //echo "กี่วัน : " . count($date); foreach($date as $day){ //echo $day . "<br>"; $num_date=num_record("regis_payment_log","where academicYear='$academicYear' AND semester='$semester' AND PaymentDate='$day' "); $total_num_date=$total_num_date+$num_date; if($day<=$today){ if($num_date!=0){ ?> <tr> <td align="center"><?=$no?></td> <td style="text-align: left"><?php echo thai9($day);?></td> <td style="text-align: right"><?php echo number_format($num_date);?> คน </td> <td align="center"><?php if($num_date!=0){?> <a href="pages/export-studentRegisDate.php?ex=&date=<?=$day?>" class="btn btn-secondary btn-sm " role="button" target="_blank"><i class="fa fa-external-link" aria-hidden="true"></i></a> <a href="pages/export-studentRegisDate.php?ex=xls&date=<?=$day?>" class="btn btn-primary btn-sm " role="button"><i class="fa fa-file-excel-o" aria-hidden="true"></i></a> <?php } ?></td> </tr> <?php } } $no++; } ?> <tr> <td colspan="2"><center><b>รวม</b></center></td> <td style="text-align: right"><b><?php echo number_format($total_num_date); ?></b> <b>คน</b> </td> </tr> </tbody> </table>
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.52 |
proxy
|
phpinfo
|
Settings