How andreijavan/pnp_sta.cruz_official works
Sta. Cruz Crime Mapping & Reporting System serves public crime-map and information pages alongside police administration for incident reporting, bulletins, intelligence reports, and personnel. Public visitors browse mapped incidents, advisories, news, and hotlines; authorized staff manage records through protected admin routes. Facebook post synchronization is a separate ingestion capability that feeds bulletins. The sampled controller excerpts show database access and selected public data flows; README and route declarations establish additional capabilities whose internal implementation is not fully shown.
Main entry points: admin.ts Admin routes · publicController.ts Public pages · database.ts Application database · app.ts Express application
Components 22
Web application
- Express application
app.ts - Public routes
routes/public.ts - Admin routes
routes/admin.ts - Admin authorization
middleware/auth.ts - Session persistence
utils/sessionStore.ts
Public information
- Public pages
controllers/publicController.ts - Crime map data
controllers/publicController.ts - Bulletins and news
controllers/publicController.ts - Hotlines and language
controllers/publicController.ts - Response cache
utils/cache.ts
Police administration
- Admin access
controllers/adminController.ts - Incident mapping
controllers/adminController.ts - Intelligence reports
controllers/adminController.ts - Bulletin management
controllers/adminController.ts - Admin operations
controllers/adminController.ts - Application database
config/database.ts
External content
- Facebook synchronization
utils/facebookService.ts - Facebook page
- Category classification
utils/categoryClassifier.ts - Facebook scraper
utils/facebookScraper.ts
Other components
- Public visitor
- Police staff
Connections 26
- Public visitor → Express application: opens pages
README.md - Police staff → Express application: uses portal
README.md - Express application → Public routes: mounts routes
app.ts - Express application → Admin routes: mounts routes
app.ts - Express application → Session persistence: stores sessions
app.ts - Public routes → Public pages: dispatches requests
routes/public.ts - Admin routes → Admin authorization: guards requests
routes/admin.ts - Admin routes → Admin access: dispatches requests
routes/admin.ts - Admin routes → Incident mapping: dispatches requests
routes/admin.ts - Admin routes → Intelligence reports: dispatches requests
routes/admin.ts - Admin routes → Bulletin management: dispatches requests
routes/admin.ts - Admin routes → Admin operations: dispatches requests
routes/admin.ts - Public pages → Crime map data: loads map data
controllers/publicController.ts - Public pages → Bulletins and news: loads bulletins
controllers/publicController.ts - Public pages → Hotlines and language: serves services
routes/public.ts - Public pages → Application database: reads records
controllers/publicController.ts - Public pages → Response cache: caches results
controllers/publicController.ts - Admin access → Application database: reads and writes
controllers/adminController.ts - Incident mapping → Application database: reads and writes
controllers/adminController.ts - Intelligence reports → Application database: reads and writes
controllers/adminController.ts - Bulletin management → Application database: reads and writes
controllers/adminController.ts - Admin operations → Application database: reads and writes
controllers/adminController.ts - Facebook page → Facebook synchronization: provides posts
utils/facebookService.ts - Facebook synchronization → Application database: upserts bulletins
utils/facebookService.ts - Facebook synchronization → Category classification: classifies posts
utils/facebookService.ts - Facebook synchronization → Facebook scraper: uses scraper
utils/facebookService.ts