* feat: Add item templates feature (#435)
Add ability to create and manage item templates for quick item creation.
Templates store default values and custom fields that can be applied
when creating new items.
Backend changes:
- New ItemTemplate and TemplateField Ent schemas
- Template CRUD API endpoints
- Create item from template endpoint
Frontend changes:
- Templates management page with create/edit/delete
- Template selector in item creation modal
- 'Use as Template' action on item detail page
- Templates link in navigation menu
* refactor: Improve template item creation with a single query
- Add `CreateFromTemplate` method to ItemsRepository that creates items with all template data (including custom fields) in a single atomic transaction, replacing the previous two-phase create-then-update pattern
- Fix `GetOne` to require group ID parameter so templates can only be accessed by users in the owning group (security fix)
- Simplify `HandleItemTemplatesCreateItem` handler using the new transactional method
* Refactor item template types and formatting
Updated type annotations in CreateModal.vue to use specific ItemTemplate types instead of 'any'. Improved code formatting for template fields and manufacturer display. Also refactored warranty field logic in item details page for better readability. This resolves the linter issues as well that the bot in github keeps nagging at.
* Add 'id' property to template fields
Introduces an 'id' property to each field object in CreateModal.vue and item details page to support unique identification of fields. This change prepares the codebase for future enhancements that may require field-level identification.
* Removed redundant SQL migrations.
Removed redundant SQL migrations per @tankerkiller125's findings.
* Updates to PR #1099.
Regarding pull #1099. Fixed an issue causing some conflict with GUIDs and old rows in the migration files.
* Add new fields and location edge to ItemTemplate
Addresses recommendations from @tonyaellie.
* Relocated add template button
* Added more default fields to the template
* Added translation of all strings (think so?)
* Make oval buttons round
* Added duplicate button to the template (this required a rewrite of the migration files, I made sure only 1 exists per DB type)
* Added a Save as template button to a item detail view (this creates a template with all the current data of that item)
* Changed all occurrences of space to gap and flex where applicable.
* Made template selection persistent after item created.
* Collapsible template info on creation view.
* Updates to translation and fix for labels/locations
I also added a test in here because I keep missing small function tests. That should prevent that from happening again.
* Linted
* Bring up to date with main, fix some lint/type check issues
* In theory fix playwright tests
* Fix defaults being unable to be nullable/empty (and thus limiting flexibility)
* Last few fixes I think
* Forgot to fix the golang tests
---------
Co-authored-by: Matthew Kilgore <matthew@kilgore.dev>
* ent re-generation
* add oidc integration
* document oidc integration
* go fmt
* address backend linter findings
* run prettier on index.vue
* State cookie domain can mismatch when Hostname override is used (breaks CSRF check). Add SameSite.
Co-authored-by: coderabbitai[bot] <136622811+coderabbitai[bot]@users.noreply.github.com>
* Delete state cookie with matching domain and MaxAge; add SameSite.
Co-authored-by: coderabbitai[bot] <136622811+coderabbitai[bot]@users.noreply.github.com>
* Fix endpoint path in comments and error to include /api/v1.
Co-authored-by: coderabbitai[bot] <136622811+coderabbitai[bot]@users.noreply.github.com>
* Also use request context when verifying the ID token.
* Do not return raw auth errors to clients (user-enumeration risk).
* consistently set cookie the same way across function
* remove baseURL after declaration
* only enable OIDC routes if OIDC is enabled
* swagger doc for failure
* Only block when provider=local; move the check after parsing provider
* fix extended session comment
* reduce pii logging
* futher reduce pii logging
* remove unused DiscoveryDocument
* remove unused offline_access from default oidc scopes
* remove offline access from AuthCodeURL
* support host from X-Forwarded-Host
* set sane default claim names if unset
* error strings should not be capitalized
* Revert "run prettier on index.vue"
This reverts commit aa22330a23.
* Add timeout to provider discovery
* Split scopes robustly
* refactor hostname calculation
* address frontend prettier findings
* add property oidc on type APISummary
* LoginOIDC: Normalize inputs, only create if not found
* add oidc email verification
* oidc handleCallback: clear state cookie before each return
* add support for oidc nonce parameter
* Harden first-login race: handle concurrent creates gracefully and fix log key.
Co-authored-by: coderabbitai[bot] <136622811+coderabbitai[bot]@users.noreply.github.com>
* support email verified claim as bool or string
* fail fast on empty email
* PKCE verifier
* fix: add timing delay to attachment test to resolve CI race condition
The attachment test was failing intermittently in CI due to a race condition
between attachment creation and retrieval. Adding a small 100ms delay after
attachment creation ensures the file system and database operations complete
before the test attempts to verify the attachment exists.
* Revert "fix: add timing delay to attachment test to resolve CI race condition"
This reverts commit 4aa8b2a0d829753e8d2dd1ba76f4b1e04e28c45e.
* oidc error state, use ref
* rename oidc.force to oidc.authRedirect
* remove hardcoded oidc error timeout
* feat: sub/iss based identity matching and userinfo endpoint collection
---------
Co-authored-by: coderabbitai[bot] <136622811+coderabbitai[bot]@users.noreply.github.com>
Co-authored-by: Matthew Kilgore <matthew@kilgore.dev>
* feat: implement example of data table
* feat: load item data into table
* chore: begin switching dialogs
* feat: implement old dialog for controlling headers and page size
* feat: get table into relatively usable state
* feat: enhance dropdown actions for multi-selection and CSV download
* feat: enhance table cell and dropdown button styles for better usability
* feat: json download for table
* feat: add expanded row component for item details in data table
* chore: add translation support
* feat: restore table on home page
* fix: oops need ids
* feat: move card view to use tanstack to allow for pagination
* feat: switch the items search to use ItemViewSelectable
* fix: update pagination handling and improve button click logic
* feat: improve selectable table
* feat: add indeterminate to checkbox
* feat: overhaul maintenance dialog to use new system and add maintenance options to table
* feat: add label ids and location id to item patch api
* feat: change location and labels in table view
* feat: add quick actions preference and enable toggle in table settings
* fix: lint
* fix: remove sized 1 pages
* fix: attempt to fix type error
* fix: various issues
* fix: remove
* fix: refactor item fetching logic to use useAsyncData for improved reactivity and improve use confirm
* fix: sort backend issues
* fix: enhance CSV export functionality by escaping fields to prevent formula injection
* fix: put aria sort on th not button
* chore: update api types
* fix: Remove log.Fatal in favor of returning errors
This change is useful for including error tracking, which needs the
application to not terminate immediately, and instead give the tracer
time to capture and flush errors.
* Fix CodeRabbit issues
---------
Co-authored-by: Matthew Kilgore <matthew@kilgore.dev>
* feat: improved duplicate
* feat: enhance item duplication process with transaction handling and error logging for attachments and fields
* feat: add error logging during transaction rollback in item duplication process for better debugging
* feat: don't try and rollback is the commit succeeded
* feat: add customizable duplication options for items, including prefix and field copying settings in API and UI
* fix: simplify duplication checks for custom fields, attachments, and maintenance entries in ItemsRepository duplication method
* refactor: import DuplicateSettings type from composables and sort import issues
* feat: custom coloured labels
* chore: lint
* feat: add ColorSelector component for improved color selection in labels and integrate it into CreateModal and Selector components
* style: lint
* fix: update ColorSelector and Selector components to use empty string instead of null for default color values for types
* Remove documents table (WIP)
* Further cleanup of documents table
* This should clean up the errors, but actual attachment handling still needs added.
* Full generation to update the JS side of things too
* Further fixes
* Fix cyclic dependency issue
* In theory the API side works now
* Fix go linting issues
* Fix frontend issues
* Way closer, but has a foreign key constrant issue
* UI actually works now
* Fix deduplication feature not working right
* Upgrade to `golangci-lint` v2 file
* Add ability to set primary during attachment creation
* Update swagger with new primary attachment during creation stuff
* Files are actually saved now, but there's still a bug
* Fix critical issue whith how deletions were working
* Fix the byte copy issue
* Hopefully everything is fixed now
* Fix golangci-lint config and lint files
* Fix lint issue
* Fix a few more tests
* Fix lint issues again
* More minor test fixes
* Update backend/internal/core/services/service_items_attachments.go
Co-authored-by: Copilot <175728472+Copilot@users.noreply.github.com>
* Fix migration (I think)
* Fixed postgres migration
* Change some migration options to work better
* Some more little things that I tried
* Fix merge go.mod
* Fix migrations
* Little lint thing
* Fix AttachmentsList.vue with updated API
---------
Co-authored-by: Copilot <175728472+Copilot@users.noreply.github.com>
* Add a quantity field to the item create modal form.
* Fix prettier code format complaint.
* Update en.json allowing the label of the field to be translated.
* Including changes generated by swag and typescript-types tasks.
* Fixed tests, item duplication and lint errors.
* Fix linter issues again and an error introduced in 912e5b2
* Fixed a test that creates an item through the go:coverage task
* [VNEXT] feat: Multi-DB type support (#291)
* feat: Multi-DB type URL formats and config
* fix: remove legacy sqlite path config and minor other things
* fix: dumb eslint issues
* fix: dumb eslint issues
* fix: application can be tested with sqlite
* fix: minor config formatting
* chore: some cleanup
* feat: postgres migration creation now works
The migration creation for postgres now works properly.
Removed MySQL support, having too many issues with it at this time.
* chore: revert some strings back to bytes as they should be
* feat: improve languages support
* feat: add locale time ago formatting and the local name for the language in language dropdown
* Update FUNDING.yml
* chore: remove some more mysql stuff
* fix: coderabbit security recommendations
* fix: validate postgres sslmode
* Update migrations.go
* fix: postgres migration creation now works
* fix: errors in raw sql queries
* fix: lint error, and simpler SQL query
* fix: migrations directory string
* fix: stats related test
* fix: sql query
* Update TextArea.vue
* Update TextField.vue
* chore: run integration testing on multiple postgresql versions
* chore: jobs should run for vnext branch PRs
* fix: missed $ for Postgres testing
* fix: environment variable for db ssl mode
* fix: lint issue from a merge
* chore: trying to fix postgresql testing
* chore: trying to fix postgresql testing
* fix: trying to fix postgresql testing
* fix: trying to fix postgresql testing
---------
Co-authored-by: tonya <tonya@tokia.dev>
* fix: publish docker vnext branch
* Add upgrade guide documentation
* chore: add new config options to documentation
* Update vnext (#314)
* feat: make 404 follow theme and add a return home page
* feat: sanitise translations when using v-html
* chore: Add native API docs to website
* chore: remove try it button from api docs
---------
Co-authored-by: tonyaellie <tonya@tokia.dev>
* Update Dockerfile
Update dockerfile to test the theory of data folder breaking in vnext
* fix: broken docker image
* fix: statistics
* feat: support mm, cm and inches for label generation
* [VNEXT] feat: Multi-DB type support (#291)
* feat: Multi-DB type URL formats and config
* fix: remove legacy sqlite path config and minor other things
* fix: dumb eslint issues
* fix: dumb eslint issues
* fix: application can be tested with sqlite
* fix: minor config formatting
* chore: some cleanup
* feat: postgres migration creation now works
The migration creation for postgres now works properly.
Removed MySQL support, having too many issues with it at this time.
* chore: revert some strings back to bytes as they should be
* feat: improve languages support
* feat: add locale time ago formatting and the local name for the language in language dropdown
* Update FUNDING.yml
* chore: remove some more mysql stuff
* fix: coderabbit security recommendations
* fix: validate postgres sslmode
* Update migrations.go
* fix: postgres migration creation now works
* fix: errors in raw sql queries
* fix: lint error, and simpler SQL query
* fix: migrations directory string
* fix: stats related test
* fix: sql query
* Update TextArea.vue
* Update TextField.vue
* chore: run integration testing on multiple postgresql versions
* chore: jobs should run for vnext branch PRs
* fix: missed $ for Postgres testing
* fix: environment variable for db ssl mode
* fix: lint issue from a merge
* chore: trying to fix postgresql testing
* chore: trying to fix postgresql testing
* fix: trying to fix postgresql testing
* fix: trying to fix postgresql testing
---------
Co-authored-by: tonya <tonya@tokia.dev>
* fix: publish docker vnext branch
* Add upgrade guide documentation
* chore: add new config options to documentation
* Update Dockerfile
Update dockerfile to test the theory of data folder breaking in vnext
* fix: broken docker image
* fix: statistics
* feat: support mm, cm and inches for label generation
* Update go dependencies
* Update documentation
* Slight update to docker actions
* Small doc update
* More doc changes
* Sort out migrations
* Temp fix to broken stats test
* Update dependencies
* Update documentation
* Fix broken merge
* Fix docker image sqlite path
* Fix minor taskfile issue
---------
Co-authored-by: tonya <tonya@tokia.dev>
Co-authored-by: Katos <7927609+katosdev@users.noreply.github.com>