Server Store: Checking...
🎯 Executive Summary
✈️FLT Production by Hour
🔴CLOSED vs FAIL
👥 Manpower Plan Summary
📋Manpower Plan Detail
Plan DateDivisionTotal StaffVacationDaily Pool First Team TotalSecond Team TotalShift Planned TotalSubmitter / Updated ByUpdated AtStatus
Loading...
📦 Manpower Allocation Summary
📊Manpower Actual vs Plan by Hour
⚠️Missing Submit by Role
📦Manpower Allocation Detail
DateHourDivisionAreaPlannedActualVariance PhotoSubmitted byRoleSubmit TimeStatusRemark
Loading...
🔍 Audit Report Summary
🏭Finding by Division
⏱️Finding by Hour
📝Audit Report Detail
DateHourFlight No.DEP/ARRRouteSTD/STAGate/Bay Aircraft/RegDivisionEventResultComment Evidence PhotoStaff ID PhotoAuditorRoleSubmit TimeStatus
Loading...
🕐 Daily Operation Summary by Hour
HourDEPARRTotal FLTAudit CompletedAudit Pending CLOSEDFAILMP Plan TotalMP Actual TotalMP Variance Leader SubmitCoord. SubmitDM SubmitPhoto AttachedMissing PhotoMissing Submit
Loading...
🧑‍✈️ Staff Report Performance
Staff NameRoleRequired/HrAudit Report CountManpower Allocation Count FAIL Finding CountPhoto AttachedLast Submit TimeStatus
Loading...
📷 Photo Evidence Center

Note: this system stores photo metadata only (file name, size, type, uploader, time) — the photo binary itself is not persisted to localStorage, so previews show metadata, not the image.

DateHourFunctionFlight No.DivisionArea / Event Photo TypeUploaded byUpload TimeStatus
Loading...
ZIPExport Photo Package

Generates a ZIP for the selected date with the Excel workbook, photo_index.csv, briefing photo files when URL photos exist, and metadata-only README files for audit/manpower photos.

📤 Export Center
📥Export Excel — Multi-Sheet Workbook

Generates one .xlsx file with sheets:

1. Dashboard View (styled KPI cards + hourly summary, looks like the on-screen dashboard)  ·  2. Daily Summary  ·  3. Manpower Plan  ·  4. Manpower Allocation  ·  5. Audit Report  ·  6. Findings  ·  7. Staff Report  ·  8. Audit Tracking (per-person by level)  ·  9. Photo Attachments  ·  10. Photo Evidence Index  ·  11. Shift Briefings  ·  12. Dashboard Summary  ·  13. Pre Briefing Entries  ·  14. Post Duty Findings  ·  15. Open Issue Tracker  ·  16. Acknowledgement Summary  ·  17. Missing Submit  ·  18. Raw Data
📥Export Full Raw Data — Analysis Workbook

Generates a 16-sheet .xlsx file with complete raw records for Excel Pivot / Power BI analysis.

1. README_EXPORT  ·  2. FLIGHT_RAW  ·  3. PRODUCTION_BY_HOUR_RAW  ·  4. AUDIT_REPORT_RAW  ·  5. MANPOWER_PLAN_RAW  ·  6. MANPOWER_ALLOCATION_RAW  ·  7. MANPOWER_HOURLY_COMPARE_RAW  ·  8. PAX_BOOKING_INPUT_RAW  ·  9. RESULT_CHECK_RAW  ·  10. BRIEFING_RAW  ·  11. SHIFT_HANDOVER_ACK_RAW  ·  12. PHOTO_EVIDENCE_RAW  ·  13. STAFF_ACTIVITY_RAW  ·  14. MINI_BRIEFING_RAW  ·  15. PRODUCTION_DAILY_RAW  ·  16. DATA_QUALITY_CHECK
🎯Export Station Audit Compliance Report

Generates one sheet in one file covering all 15 stations, for a single date or a date range. Cross-references the full active staff roster (Leader / Coordinator / Deputy) against audit submissions, so it shows every staff member who did NOT audit — not just the ones who did — plus a per-station rollup flagging any station with zero audits. A date range aggregates the whole period into one compliance % per station/level (same accumulation the Weekly report uses), rather than one row per day.

STATION_AUDIT_COMPLIANCE (single sheet) — grand total row, then per station: a station total, a row per level (Leader/Coordinator/Deputy), a row per division within that level where it applies (PAX / Baggage / Aircraft Handling — so "Leader" is never one blended number), then every individual staff member (missing auditors listed first) with required vs submitted vs missing slots and performance status. Problem stations (zero audits / no staff) sort to the top.
📤Export PDF — Daily Report

Opens a print-friendly daily report (Executive Summary → Hourly Production → Findings → Staff Compliance → Photo Evidence). Use your browser's Print → Save as PDF to generate the file.

TOP SUMMARY — DAILY PRE & POST BRIEFING & HANDOVER DASHBOARD

Official Daily Report dashboard · real submitted data only

Daily Pre & Post Briefing Dashboard — Daily Report

—
Total Audits
—
audit records today
Pass Rate
—
no data
Fail Count
—
require action
Hours Covered
—
of active hours
Division Coverage
PAX BAG A/C
by division
Flights Today
—
DEP + ARR
Submitted Briefing
—
Pre + Post
Pending Briefing
—
required board
ACK Rate
—
acknowledgement
ACK Completed
—
records
Open Issues
—
unresolved
Repeat Issues
—
same issue text
Total ACK Required
—
role coverage
1 · TOP SUMMARY — PRE BRIEFING PRODUCTION POINT ▲
■ 100% / PASS ■ 50–99% / MIXED ■ 0% / FAIL — No Data P=Pass · F=Fail · C=Case · pc=Piece · FLT=Flight
2 · DAILY PRE BRIEFING BOARD ▲
3 · DAILY POST BRIEFING BOARD ▲
4 · OPEN ISSUE TRACKER ▲
IssueAction TakenFollow UpDivisionOwnerTimestampPhotos
2 · BRIEFING POINT ▼
5 · ROLE AUDIT COVERAGE ▲
✅ Submitted ❌ No submission L Leader C Coordinator D Duty Mgr
6 · AUDITOR STATUS ▲
7 · RAW DATA / DETAIL ▼
8 · MANPOWER PLAN SUMMARY ▼
8b · HOURLY ASSIGNMENT TRACKING — Area staff count by hour · current date only ▼
9 · POSTDUTY FINDING — FAIL CASES 0 ▲
ISSUE RCACAP NON-CONFORMING STAFF DIVHOURFLIGHT AUDITORROLESEVERITYEVIDENCESTATUS
10 · DIVISION AUDIT RESULT BY HOUR ▲
✔ CLOSED ✘ FAIL LCD = role
11 · MINI BRIEFING CHECKLIST ▼