970cd568dc
Add generated jet tables and models
...
These will change with schema changes
2026-05-09 01:54:12 +00:00
935800e334
Switch to using the Gleipnir fork of jet
...
Because we need those sweet, sweet geometry columns
2026-05-09 01:48:56 +00:00
24a3610c4c
Correctly build updaters with New
...
Otherwise we have nil columns
2026-05-08 22:22:52 +00:00
7da653efc6
Avoid a DB query if there are no address IDs
2026-05-08 22:21:56 +00:00
735a9dc1d2
Properly close rows on empty results
...
I we don't do this we get "conn busy" errors.
2026-05-08 22:21:27 +00:00
f2585c569c
Woops, actually set all columns on compliance because it doesn't have a serial key
2026-05-08 01:08:06 +00:00
0fc46d5916
Only set mutable columns on insert
...
Because we don't want to set ID and other primary keys
2026-05-08 00:56:55 +00:00
61ad3fbe45
Remove string-based queries for public report data
...
Use the new jet hotness
2026-05-07 23:22:50 +00:00
12213fb31b
Remove string-only references to location_* generated columns
2026-05-07 17:01:54 +00:00
7a361a330d
Remove now-extraneous latitude/longitude generated columns
...
Now that we can pull out the geometry directly into a go object we don't
need these and they complicate our insertions
2026-05-07 16:38:42 +00:00
fcd95f1a25
Get back to compiling, but using new jet for publicreport
...
This was an epically long change, and a terrible idea, but it compiles.
This was essentially a cascade that came about because I can't blend jet
and bob in the same transaction. In for a penny, I guess...
2026-05-07 10:39:17 +00:00
a95e44cf42
Use transactions to set the communication status changes
...
Not doing it yet, but soon we'll do log entries for them.
2026-05-04 20:57:50 +00:00
040ab106b4
Fix failing to set timestamp in mark query
...
I accidentally didn't understand how this API works.
2026-05-04 20:30:36 +00:00
114aec73ed
Fix setting timestamp for when action is taken
2026-05-04 20:09:56 +00:00
3153e8bf13
Initial work marking communications
...
And a bunch of lint fixes
2026-05-04 19:07:29 +00:00
d6b664d84a
Return the communication we create
...
...or else it'll be empty.
2026-05-02 00:37:51 +00:00
52d4c47e43
Fix lint errors related to not checking errors
2026-05-02 00:37:28 +00:00
a82732a49c
Return communication database rows from communication API
...
This is a pretty big refactor of how communication works to start moving
us in the direction we want to go long-term. This adds the new
communication row and migrates existing reports to add rows for
communication.
There's also a bunch of automatic fixes from the new linter. I should
have added them separately, but whatever.
2026-05-01 21:00:23 +00:00
bab3200b6c
Port all of the arcgis schema to using jet
...
Have not tested anything at this point, it just compiles.
2026-05-01 17:28:33 +00:00
a82b2b8cb8
Add new communication table
...
It allows us to track when communication tasks are complete, and
information about how they were completed, separate from the entries
that created the tasks in the first place (reports, emails, texts)
2026-05-01 15:13:05 +00:00
6a47302192
Create custom jet template for both stadia and arcgis
2026-05-01 15:11:20 +00:00
0e0b2489e6
Get beginnings of custom column type working
2026-05-01 06:27:26 +00:00
9ef4dad27c
Initial custom jet generator
...
I'll need it for Postgis data types
2026-05-01 05:45:45 +00:00
e5a84e09a8
Initial working version of using jet for SQL building
2026-05-01 05:11:28 +00:00
be8d92d7ae
Add 'submitted' field to compliance reports
2026-04-27 16:23:16 +00:00
5e638bdf1d
Remove hidden water inputs, add missing duration input
2026-04-24 22:23:52 +00:00
0ce3420792
Save all lob events to the database
...
They're pretty raw, but this will help us to understand what we can
collect
2026-04-21 22:24:12 +00:00
b6e1bffd79
Add support for satellite tiles, with caching
2026-04-17 17:47:38 +00:00
a6f9396760
Add first draft of mailer integration
...
This adds a bunch of stuff, including setting the organization's Lob
sender address ID, inserting mailer/compliance_report relationships,
adding external id from Lob (or maybe some other provider) and
attempting to load up the pool feature for a site.
2026-04-16 19:49:18 +00:00
d047c460ed
Add missing files in last two commits
2026-04-16 17:15:44 +00:00
81e057b900
Add initial work for backgrounding mailer job
2026-04-16 17:15:20 +00:00
2ea47f03f4
Start wiring together request for a mailer to database
2026-04-16 10:15:28 +00:00
ac27c60e0c
Save address IDs when doing pool geocoding
2026-04-15 20:29:42 +00:00
66d35428fa
Add error display to file upload
2026-04-15 19:02:25 +00:00
59e58840c9
Fix address lat/lng location names, populate in report response
2026-04-14 15:43:49 +00:00
9c557a0391
Make it possible to save SMS support status on phone record
2026-04-13 22:23:29 +00:00
5db4c05544
Add proper compliance report type
...
Can't believe I missed this.
2026-04-13 16:42:29 +00:00
9ba99d5ceb
Remove now-empty report address fields
...
We'll instead create address rows and reference those
2026-04-12 18:33:41 +00:00
730f40956f
Store addresses on every geocode
2026-04-10 22:32:40 +00:00
553b65556a
Begin work on saving compliance report
2026-04-10 00:56:51 +00:00
6c79b8a85e
Add address GID to public report
...
This is _way_ better than trying to re-transmit structured address data
to the backend via strings
2026-04-08 14:40:27 +00:00
c393f6fd81
Add cache for all stadia requests
2026-04-06 22:36:25 +00:00
fc56c1406a
Make it possible to change more user fields
2026-04-02 14:22:45 +00:00
21b7b68f50
Get new frontend to type check clean
...
Epic undertaking.
2026-03-31 14:52:53 +00:00
6f9a511874
WIP of user avatar work
...
Switching from laptop
2026-03-29 17:09:01 -07:00
5779242f22
Prettier everything, remove vendored bootstrap
...
These are installed now via pnpm
2026-03-21 19:41:51 +00:00
9b6cacda0e
Make signals include the object they are attached to (pool, report)
...
This means pushing the types into the common types module, which
required a refactor of a bunch of other libraries.
2026-03-21 01:19:36 +00:00
edfd8e285f
Add location x and y to address table
...
For easier reference
2026-03-20 17:59:13 +00:00
6042e7d337
Emit events on note creation
2026-03-19 21:29:55 +00:00
c7c1c45008
Add location to signal
2026-03-19 20:49:53 +00:00
