|
|
| ＃ |
報修地點 |
報修次數 |
| 175 |
|
5 |
| 99 |
|
4 |
| 75 |
|
1 |
| 513 |
|
1 |
| 475 |
|
1 |
| 499 |
|
1 |
| 516 |
|
1 |
| 383 |
|
1 |
| 35 |
|
1 |
| 508 |
|
1 |
| 225 |
|
1 |
| 414 |
|
1 |
| 476 |
|
1 |
合計：共 20 件報修
SELECT mt.locationid,mt.location,COUNT(mt.id) AS Total FROM maintain mt LEFT JOIN members mb ON mt.reporterid=mb.sid WHERE mt.isfinished>0 AND mt.ctime BETWEEN '2024-04-01' AND '2024-04-30' GROUP BY mt.locationid ORDER BY COUNT(mt.id) DESC
全校待修
我要報修
維修狀況
報修統計
登入登出