shawn/canteen-asset-tracker
1
0
Fork 0
Code Issues 8 Pull Requests Actions Packages Projects Releases Wiki Activity

Assets not showing on map #8

New Issue
Closed
opened 2026-05-20 21:28:07 +00:00 by shawn · 0 comments
shawn commented 2026-05-20 21:28:07 +00:00
Owner
Copy Link
Copy Source

Problem

Map loadAssetPins() filtered by a.latitude != null but assets never had lat/lng populated — coordinates only lived in the checkins table.

Fix

  • Backend: create_checkin now auto-updates assets.latitude/longitude on every GPS check-in
  • Database: Backfilled existing 3 assets from their latest check-in history

Commits

## Problem Map `loadAssetPins()` filtered by `a.latitude != null` but assets never had lat/lng populated — coordinates only lived in the checkins table. ## Fix - Backend: `create_checkin` now auto-updates `assets.latitude`/`longitude` on every GPS check-in - Database: Backfilled existing 3 assets from their latest check-in history ## Commits - fc0a3ee
shawn closed this issue 2026-05-20 21:28:07 +00:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
blocked
Kanban task is blocked
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
shawn
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: shawn/canteen-asset-tracker#8
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?