The 3am alarm nobody logged: building incident accountability for shops

说明与用途

该系统将警报事件、视频剪辑、关闭细节和时间戳合并为单个记录，简化超市的审计流程。

问题

Shop incident logs lack a single source of truth for alarm events, who closed them, and when, leading to inconsistent records and audit gaps.

结果

The system creates a single incident record with video clip, timestamp, closure person, and a one-line summary, enabling audit-ready reports without external cloud dependencies.

工作流

• Initialize incident database
• Trigger alarm event with camera and reason
• Cut video clip of the event
• Record alarm fire time
• Record who closed the alarm and when
• Generate one-line summary
• Store clip and metadata locally
• Generate incident report
• Handle model timeouts and fallbacks

证据

The alarm goes off at 3am. By the morning, three people can tell you three different things about what happened, and none of them can show you.

来源

An incident accountability system. It makes those three facts one row in a database.

来源

The whole thing is a SQLite file and a folder of clips on the store's own machine.

来源

The summary line is generated by an open-weight model running locally through Ollama — qwen2.5-coder:7b, Apache 2.0, 4.7 GB, on the box in the back office.

来源