File manager - Edit - /var/www/order.cmtc.ac.th/admin/orders_summary_export.php
Back
<?php session_start(); if(!isset($_SESSION['admin'])) { header('Location: index.php'); exit; } include('../config/db.php'); header("Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"); header("Content-Disposition: attachment; filename=Orders_Summary_" . date('Ymd_His') . ".xls"); header("Pragma: no-cache"); header("Expires: 0"); $date_from = $_GET['date_from'] ?? date('Y-m-d'); $date_to = $_GET['date_to'] ?? date('Y-m-d'); // ✅ ดึงข้อมูลสรุปยอดรายวัน $sql = " SELECT DATE(o.created_at) AS order_date, SUM(CASE WHEN o.receive_method='รับสินค้าด้วยตนเอง' THEN o.total ELSE 0 END) AS self_total, SUM(CASE WHEN o.receive_method='จัดส่งทางไปรษณีย์' THEN o.total ELSE 0 END) AS post_total, SUM(o.total) AS total_all, SUM(CASE WHEN o.status LIKE '%Free Order%' THEN o.total ELSE 0 END) AS free_total FROM orders o WHERE DATE(o.created_at) BETWEEN ? AND ? GROUP BY DATE(o.created_at) ORDER BY DATE(o.created_at) DESC "; $stmt = $conn->prepare($sql); $stmt->bind_param('ss', $date_from, $date_to); $stmt->execute(); $res = $stmt->get_result(); // ✅ แสดงตาราง Excel echo "<table border='1'>"; echo "<tr style='background-color:#e8eaf6; font-weight:bold;'> <th>วันที่</th> <th>รับสินค้าด้วยตนเอง (บาท)</th> <th>จัดส่งทางไปรษณีย์ (บาท)</th> <th>รวมยอดต่อวัน (บาท)</th> <th>ยอด Free Order (บาท)</th> </tr>"; $sum_self=0; $sum_post=0; $sum_all=0; $sum_free=0; while($r = $res->fetch_assoc()){ $sum_self += $r['self_total']; $sum_post += $r['post_total']; $sum_all += $r['total_all']; $sum_free += $r['free_total']; echo "<tr> <td>".$r['order_date']."</td> <td align='right'>".number_format($r['self_total'],2)."</td> <td align='right'>".number_format($r['post_total'],2)."</td> <td align='right'><b>".number_format($r['total_all'],2)."</b></td> <td align='right'>".number_format($r['free_total'],2)."</td> </tr>"; } echo "<tr style='font-weight:bold; background-color:#f1f8e9;'> <td>รวมทั้งหมด</td> <td align='right'>".number_format($sum_self,2)."</td> <td align='right'>".number_format($sum_post,2)."</td> <td align='right'>".number_format($sum_all,2)."</td> <td align='right'>".number_format($sum_free,2)."</td> </tr>"; echo "</table>"; exit; ?>
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.41 |
proxy
|
phpinfo
|
Settings