PIMS Modernization Launch
What's Changed
This release sees the publication of the modern PIMS build. It replaced the application in Production on August 6, 2024.
Code and documentation related to the original build of PIMS will be archived in the upcoming weeks. Links will remain available through the repo's wiki.
PIMS Modernization
- PIMS-1445: Lookup Endpoints for Properties by @GrahamS-Quartech in #2265
- PIMS-1349: Create Building Service by @Sharala-Perumal in #2210
- PIMS-1472 Controller Error Wrapper by @dbarkowsky in #2266
- PIMS-1483: Lookup and Administraive Areas Hooks by @GrahamS-Quartech in #2270
- PIMS-1467: parcel hooks in useParcelApi by @LawrenceLau2020 in #2264
- PIMS-1474: Save Evaluations and Fiscals alongside Parcels by @GrahamS-Quartech in #2268
- PIMS-1442: Create Building Controller by @GrahamS-Quartech in #2271
- PIMS-1470: Create hooks for building services by @Sharala-Perumal in #2267
- PIMS-1479 Remove Users from /admin by @dbarkowsky in #2272
- PIMS-1403 Agency Table by @dbarkowsky in #2274
- PIMS-1374: Update ETL for parcel and building evaluations by @LawrenceLau2020 in #2269
- Update Role Mapper by @dbarkowsky in #2284
- PIMS-1404 Agency Details by @dbarkowsky in #2283
- PIMS-1507: Geocoder Controller by @GrahamS-Quartech in #2287
- PIMS-1475: Administrative Areas Table by @GrahamS-Quartech in #2290
- PIMS-1476: Administrative Areas Detail by @GrahamS-Quartech in #2294
- PIMS-1519: Resolving unused Building columns by @GrahamS-Quartech in #2295
- PIMS-1488: Properties Workflows by @GrahamS-Quartech in #2279
- PIMS-1405 Add Agency by @dbarkowsky in #2289
- PIMS-1437: Checking for User Agency by @LawrenceLau2020 in #2297
- PIMS-1518: Add Administrative Area by @GrahamS-Quartech in #2298
- PIMS-1443 Table Filter Saving by @dbarkowsky in #2302
- PIMS-1531: Property Quicksearch Backend by @GrahamS-Quartech in #2306
- PIMS-1530 Metadata to Jsonb Conversion by @dbarkowsky in #2308
- PIMS-1438: Checking for User Roles by @LawrenceLau2020 in #2307
- PIMS-1486 Combine utils into utilities folder (react-app) by @dbarkowsky in #2310
- PIMS-1542 Regional District Sort by @dbarkowsky in #2309
- PIMS-1544: Parcel Layer Integration for Property Management by @GrahamS-Quartech in #2315
- PIMS-1547 Agency Email ID and Table Filter Bug Fixes by @dbarkowsky in #2311
- PIMS-1528 Add Project Service by @dbarkowsky in #2316
- PIMS-1520: Geocoder integration for street address field and map by @GrahamS-Quartech in #2319
- PIMS-1503: Add Project Form by @GrahamS-Quartech in #2305
- PIMS-1545: AgenciesController auth checks by @LawrenceLau2020 in #2320
- PIMS-1567: Projects Table by @GrahamS-Quartech in #2325
- PIMS-1582 Options Filter Fix by @dbarkowsky in #2329
- PIMS-1569: GetProjects service by @LawrenceLau2020 in #2324
- PIMS-1584: Create reusable backend check for users by @LawrenceLau2020 in #2333
- PIMS-1541 Project Details Services by @dbarkowsky in #2323
- Updating workflow to use env variables by @TaylorFries in #2343
- PIMS-1524/1566 Frontend Auth Checks by @dbarkowsky in #2345
- PIMS-1529: Projects Controller - addProject by @LawrenceLau2020 in #2336
- PIMS-1533 Post Project Hook & Frontend Connection by @dbarkowsky in #2334
- PIMS-1624: Hooks/Controller for getting tasks by @GrahamS-Quartech in #2349
- PIMS-1565: Parcel and Building controllers auth check by @LawrenceLau2020 in #2346
- PIMS-1525 Active status check backend by @dbarkowsky in #2354
- PIMS-1625: Parcel and Building view details agency authorization by @LawrenceLau2020 in #2353
- PIMS-1536: Projects Details Frontend by @Sharala-Perumal in #2322
- PIMS-1622: Handle task array by @GrahamS-Quartech in #2348
- PIMS:1650 - Add GetToken endpoint for LTSA by @Sharala-Perumal in #2361
- PIMS-1648: Small map on Parcel and Building details forms by @LawrenceLau2020 in #2360
- PIMS-1368: Convert Notifications Templates to Nunjucks by @GrahamS-Quartech in #2362
- PIMS-1540: Project Controller Update/Delete by @TaylorFries in #2359
- PIMS-1570 Excel Export Refine by @dbarkowsky in #2358
- PIMS-1469 401 Redirect by @dbarkowsky in #2347
- PIMS-1670: Notification Services by @GrahamS-Quartech in #2364
- PIMS-1651/1652 Map Page by @dbarkowsky in #2365
- PIMS-1661 Property Marker Slideout by @dbarkowsky in #2372
- PIMS-1623/1622: Handling project notifications and tasks by @GrahamS-Quartech in #2370
- PIMS-1676: Skeleton Loading by @GrahamS-Quartech in #2373
- PIMS: 1656 & 1658 - Create getTitleSummary and createOrder endpoints for LTSA by @Sharala-Perumal in #2363
- PIMS-1678: Agency Interest UI by @GrahamS-Quartech in #2376
- PIMS-1675 Replacing MarkerCluster with Supercluster by @dbarkowsky in #2375
- PIMS-1683: Agency Responses API by @GrahamS-Quartech in #2381
- PIMS-1485 README Update by @dbarkowsky in #2380
- PIMS-1590 Expand Parcel Layer Popup by @dbarkowsky in #2382
- PIMS-1590 Parcel Layer Popup Fixes by @dbarkowsky in #2387
- PIMS-1621 Projects Auth Check by @TaylorFries in #2366
- PIMS-1674: Snack Bar by @GrahamS-Quartech in #2388
- PIMS-1700: Submit Handler by @GrahamS-Quartech in #2389
- PIMS-1685: Agency Response Workflow by @GrahamS-Quartech in #2383
- PIMS-1655 Map Filter by @dbarkowsky in #2392
- PIMS-1702: Disable Delete Option for Detail Pages by @GrahamS-Quartech in #2391
- PIMS-1568 Leased Land Metadata by @dbarkowsky in #2396
- PIMS-1682 Active Inventory Filter by @dbarkowsky in #2398
- PIMS-1703: Soft Delete Properties and Projects by @GrahamS-Quartech in #2400
- PIMS-1598: Data Grid Hover by @GrahamS-Quartech in #2401
- Vault ENVs - Template Update by @dbarkowsky in #2403
- PIMS-1619 Status Pages for Denied/Disabled Users by @dbarkowsky in #2405
- PIMS-1588: LTSA Info on Parcel Property Details by @Sharala-Perumal in #2374
- PIMS-1546 Disable Edit Button on User Detail Page for Non-Admins by @TaylorFries in #2407
- Update LTSA Tests by @dbarkowsky in #2419
- PIMS-1708: Notes Backend by @GrahamS-Quartech in #2411
- PIMS-1543: Unable to add a net book or assessed values when none exist by @LawrenceLau2020 in #2371
- PIMS-1593 NotOwned Column & PIMS-1601 Tenancy Field by @dbarkowsky in #2406
- PIMS-1596 Remove Sort Order Option by @dbarkowsky in #2412
- PIMS-1591 updates for consistency by @TaylorFries in #2421
- PIMS-1602 Error Refresh by @dbarkowsky in #2422
- PIMS-1605 Custom Sort for User Status by @TaylorFries in #2424
- PIMS-1713: Project Note Enumeration by @GrahamS-Quartech in #2423
- PIMS-1716: Prompt for Project Notes by @GrahamS-Quartech in #2427
- PIMS-1714: Hide edit/delete buttons for Auditor Role by @LawrenceLau2020 in #2429
- PIMS-1659 LTSA Info in Parcel Layer Popup by @dbarkowsky in #2426
- PIMS-1652 Clusters Rework by @dbarkowsky in #2435
- PIMS-1718: Keycloak not updating role by @LawrenceLau2020 in #2434
- PIMS-1745 Map Sidebar Property List by @dbarkowsky in #2438
- PIMS-1719: Send notifications for access request by @GrahamS-Quartech in #2430
- PIMS-1746: Entities for project timestamps and project monetary values by @GrahamS-Quartech in #2437
- PIMS-1748: Endpoints for timestamps and monetary types by @GrahamS-Quartech in #2439
- PIMS-1753 Sidebar Filter by @dbarkowsky in #2440
- PIMS-1744: Projects API support timestamps and monetary by @GrahamS-Quartech in #2441
- PIMS-1595 Land Area in Table by @dbarkowsky in #2443
- PIMS-1605 - set table length to 100 by @TaylorFries in #2453
- PIMS-1767 Cluster Popup by @dbarkowsky in #2450
- PIMS-1750: Modify ETL to extract metadata values into appropriate tables/columns by @LawrenceLau2020 in #2448
- PIMS-1749: Frontend timestamps and monetary support by @GrahamS-Quartech in #2442
- PIMS-1653: Adding all the layers to the map by @Sharala-Perumal in #2454
- PIMS-1758 Map Parcel Search by @dbarkowsky in #2459
- PIMS-1603 Column Filtering Fixes by @dbarkowsky in #2456
- PIMS-1771: Parcel building union view by @GrahamS-Quartech in #2461
- PIMS-1768: Updated DBeaver ETL task for Dev/Test/Prod by @LawrenceLau2020 in #2458
- Add Issue Template by @dbarkowsky in #2463
- PIMS-1662: SPL report by @Sharala-Perumal in #2436
- PIMS-1774 and PIMS-1757 by @LawrenceLau2020 in #2462
- PIMS-1594 Parent-Child Agency Relationship Limit by @dbarkowsky in #2460
- PIMS-1797: Sidebar links not working by @LawrenceLau2020 in #2470
- PIMS-1775: Re-sequencing postgres tables by @LawrenceLau2020 in #2468
- PIMS-1741 Lookup Context by @dbarkowsky in #2469
- PIMS-1743: Server Side Pagination by @GrahamS-Quartech in #2457
- PIMS-1799: Property Union API by @GrahamS-Quartech in #2471
- PIMS-1798 Add Address to Property Row by @dbarkowsky in #2475
- PIMS-1804: Server side pagination for active inventory by @GrahamS-Quartech in #2476
- PIMS-1801 Replace Joins with Lookup by @dbarkowsky in #2472
- PIMS-1660 BC Assessment by @dbarkowsky in #2397
- Force BCA Test URL by @dbarkowsky in #2477
- PIMS-1805: Disposal project property search constraints by @LawrenceLau2020 in #2486
- PIMS-1660 BCA in Popup by @dbarkowsky in #2484
- PIMS-1803: Bulk upload API by @GrahamS-Quartech in #2478
- PIMS-1828: PID Formatting on Map Filter by @TaylorFries in #2504
- PIMS-1833 Format LTSA Date on Parcel Detail Page by @TaylorFries in #2505
- PIMS-1860: Import Result API by @GrahamS-Quartech in #2507
- PIMS-1829 Only Active Users can see Headers by @TaylorFries in #2510
- PIMS-1826 Fuzzy Search Options by @dbarkowsky in #2511
- PIMS-1817 Tooltips for Tiers by @dbarkowsky in #2513
- PIMS-1802: Bulk Upload Page by @GrahamS-Quartech in #2515
- PIMS-1818: Acknowledge notifications before saving project in approval state by @GrahamS-Quartech in #2522
- Pims-1858 Truncate Address From Geocoder by @TaylorFries in #2523
- PIMS-1752: Allow editing of previous netbook and asssessment values by @GrahamS-Quartech in #2534
- Agency services test fix by @GrahamS-Quartech in #2538
- PIMS-1856: Cleanup Project Statuses by @GrahamS-Quartech in #2532
- PIMS-1816: Exemption Field On Add Project by @GrahamS-Quartech in #2519
- PIMS-1827 Excel Export with Pagination by @dbarkowsky in #2535
- PIMS-1886: Transformer for money columns by @GrahamS-Quartech in #2539
- PIMS-1875: Bulk Upload File Rejection by @GrahamS-Quartech in #2540
- Pims-1889: ERP Exemption Required Field by @GrahamS-Quartech in #2542
- PIMS-1888 PID Search Formatting by @TaylorFries in #2545
- PIMS-1889: Timeout the loading spinner when credentials are missing by @GrahamS-Quartech in #2559
- PIMS-1872 ETL Update by @dbarkowsky in #2557
- PIMS-1901 PID or PIN Required on Parcel Add by @TaylorFries in #2563
- PIMS-1898 BCeID with Access Request by @dbarkowsky in #2567
- PIMS-1990: Email Authorized env variable for testing emails in live by @GrahamS-Quartech in #2560
- PIMS-1917 Footer Links by @dbarkowsky in #2568
- PIMS-1919: Bulk upload resolve path for production by @GrahamS-Quartech in #2569
- Pims-1773 Only Admins to See Agency Interest by @TaylorFries in #2571
- Wrap getLookupValueById in useCallback by @GrahamS-Quartech in #2570
- PIMS-1918: Moved LTSA Info to the bottom of Property Details page by @Sharala-Perumal in #2572
- PIMS-1832 Error Email by @dbarkowsky in #2575
- PIMS-1926 No Role User Access by @dbarkowsky in #2581
- PIMS-1754: Display Project Notifications by @LawrenceLau2020 in #2544
- PIMS-1925 Project Editing Admins Only by @dbarkowsky in #2578
- PIMS-1921: Agency dropdown project and properties by @GrahamS-Quartech in #2582
- Pims-1885 Remove Stubs by @TaylorFries in #2558
- PIMS-1883 Code Commenting Spree by @dbarkowsky in #2588
- PIMS-1933: Cancel notifications on project deletion by @GrahamS-Quartech in #2591
- PIMS-1950 No Charge Message by @dbarkowsky in #2594
- PIMS-1951 Remove pimshelp Email by @dbarkowsky in #2597
- PIMS-1947 New Admin Areas by @dbarkowsky in #2596
- PIMS-1773: Auditor Scoping by @TaylorFries in #2593
- PIMS-1952: Add Reporting notes to projects export by @Sharala-Perumal in #2598
- ETL Update and Script by @dbarkowsky in #2592
- PIMS-1868 Follow Up by @dbarkowsky in #2602
- Email fix by @dbarkowsky in #2603
- PIMS-1949: last known working table improvements by @GrahamS-Quartech in #2604
Bug Fixes
- Bug Fix: Expand Agency Public Schema by @dbarkowsky in #2261
- PIMS-1441 Update LastLogin by @dbarkowsky in #2263
- PIMS-1489 SSO_AUTH_SERVER_URL Update by @dbarkowsky in #2273
- PIMS-1490 Last name fix by @dbarkowsky in #2275
- Agencies Cannot Be Own Parent Zero ID Bug by @GrahamS-Quartech in #2296
- PIMS-1405 Update by @dbarkowsky in #2301
- PIMS-1473 Display Name Fix by @dbarkowsky in #2304
- PIMS-1344 Update -> square metres by @dbarkowsky in #2332
- PIMS-1589: Solve ID Collision Issue by @LawrenceLau2020 in #2338
- Fix for coalesce in Sequence Migration by @GrahamS-Quartech in #2342
- PIMS 1604/1597/1620/1601 - Bug Fixes by @GrahamS-Quartech in #2344
- PIMS-1701: Fixing incorrect transaction behavior by @GrahamS-Quartech in #2390
- PIMS-1603 Column Filtering Fixes & PIMS-1599 Status Chip by @dbarkowsky in #2399
- Handle null email response by @GrahamS-Quartech in #2404
- PIMS-1597 PID Formatting & Map Adjustments by @dbarkowsky in #2402
- Notification services query runner maxing out conn pool fix by @GrahamS-Quartech in #2420
- PIMS-1717: Avoid refreshing the page on header navigation by @GrahamS-Quartech in #2428
- Map Bug Fix by @dbarkowsky in #2455
- PIMS-1751 Popup Overflow by @dbarkowsky in #2474
- PIMS-1796: Map Sidebar icon issue by @LawrenceLau2020 in #2479
- PIMS-1820: Fix for general user login by @LawrenceLau2020 in #2487
- PIMS-1843 safari fix by @TaylorFries in #2490
- PIMS-1822/25 Property Errors by @dbarkowsky in #2489
- PIMS-1660 BCA Formatting Fixes by @dbarkowsky in #2499
- PIMS-1830 Sidebar Count Issue & Other Map Fixes by @dbarkowsky in #2501
- PIMS-1851 Submit Button Spacing by @dbarkowsky in #2500
- PIMS-1821: Fixing agency filtering on properties and projects by @LawrenceLau2020 in #2488
- PIMS-1823: Fix count for server-side pagination by @LawrenceLau2020 in #2514
- PIMS-1844: Estimated Market Value Not Saving by @LawrenceLau2020 in #2517
- PIMS-1831: Remove Space From Postal Code by @TaylorFries in #2512
- Map popup scrollbar fix by @GrahamS-Quartech in #2528
- PIMS-1845 Bad Table Filters & Other Fixes by @dbarkowsky in #2531
- PIMS-1868 More Quickfilter Fixes by @dbarkowsky in #2520
- PIMS-1874: Fix for onMove being registered inconsistently to the map by @GrahamS-Quartech in #2566
- PIMS-1756: Template formatting and hyperlink fixes by @GrahamS-Quartech in #2554
- PIMS-1894: Spelling Error (Publically) by @Sharala-Perumal in #2573
- PIMS-1923: Juristiction -> Jurisdiction by @GrahamS-Quartech in #2574
- PIMS-1920 Add Check to moneyFormatter for NaN by @TaylorFries in #2576
- PIMS-1924: Fuzzy search using wrong icon by @GrahamS-Quartech in #2579
- PIMS-1902: Last login not populated on initial login by @GrahamS-Quartech in #2584
- PIMS-1931 Make Private Notes More Private by @TaylorFries in #2587
- PIMS-1945: Property views exclude deleted rows by @GrahamS-Quartech in #2589
- PIMS-1871: Fuzzy search is returning properties already in other projects by @LawrenceLau2020 in #2590
Depencency Updates
- PIMS-1450 react-app updates by @TaylorFries in #2281
- PIMS-1451-express-api-updates by @TaylorFries in #2282
- PIMS-1449 Frontend Updates by @TaylorFries in #2286
- PIMS-1449 frontend updates by @TaylorFries in #2300
- PIMS-1510:(PIMS-1515/1516/1517) Update express-api dependencies by @Sharala-Perumal in #2303
- PIMS-1495/1496 MUI Updates by @dbarkowsky in #2321
- PIMS-1548 frontend updates by @TaylorFries in #2331
- PIMS-1450 MUI and XLSX Updates by @dbarkowsky in #2335
- PIMS-1505 Update @bcgov/citz-imb-sso-express & react packages by @TaylorFries in #2288
- PIMS-1513-1514-update-reactapp-typescript by @TaylorFries in #2337
- PIMS-1628 Updates for express-pi by @TaylorFries in #2377
- PIMS-1627 Updating react-app Dependencies by @TaylorFries in #2378
- PIMS-1626 Updates frontend by @TaylorFries in #2379
- Pims-1686 frontend dependency updates by @TaylorFries in #2417
- PIMS-1688 Updates for express-api by @TaylorFries in #2414
- PIMS-1687 Updates for react-app by @TaylorFries in #2415
- PIMS-1720 Updates frontend by @TaylorFries in #2452
- PIMS-1721 Updates to react-app by @TaylorFries in #2449
- PIMS-1722 Updates to express-api by @TaylorFries in #2451
- PIMS-1781 react-app Updates by @TaylorFries in #2483
- PIMS-1782 Update express-api Dependencies by @TaylorFries in #2482
- PIMS-1824 Remove frontend from NPM Dependency Updates by @TaylorFries in #2485
- Bump image version for postgres in docker compose to v15 by @GrahamS-Quartech in #2480
- Update github-api-requests.js octokit import method by @TaylorFries in #2491
- Pin @mui/lab version in package list by @GrahamS-Quartech in #2503
- PIMS-1834 react-app Dependency Updates by @TaylorFries in #2518
- PIMS-1835 express-api Dependency Updates by @TaylorFries in #2521
- PIMS-1877 Updating express-api by @TaylorFries in #2543
- PIMS-1876 react-app updates by @TaylorFries in #2541
- PIMS-1903 NPM Updates react-app by @TaylorFries in #2564
- PIMS-1904 NPM express-api Updates by @TaylorFries in #2565
- PIMS-1930: Update to express-sso Package by @TaylorFries in #2583
DevOps
- update to env path for test by @TaylorFries in #2350
- Devops 342 image registry update by @ManishSihag in #2351
- add missing close statement by @ManishSihag in #2352
- Argo CD deployment pattern by @ManishSihag in #2418
- Add pull command in dev deployment GHA by @ManishSihag in #2473
- DevOps Argo cd workflows for TEST and PROD by @ManishSihag in #2502
- Fix Dockerfile permissions for express-api by @ManishSihag in #2506
Original PIMS Work
- PIMS-1848 Banner Old PIMS by @dbarkowsky in #2577
Full Changelog: v02.07.03...v03.00.00
Contributors
ManishSihag, dbarkowsky, and 4 other contributors