Bumped version to 2.4.0

* Fixed Typos and mistranslations in GDPR mode (DSGVO Modus)
Fixed Typo enviroment

* Create BuerklinProvider based on LCSCProvider

* Update GET URLs for Buerklin

* Add getToken function analog to Octopart

* Remove line break in docs

* Remove trailing / in ENDPOINT_URL
Use Autowire to use values of environment variables
Remove unwanted Code from LCSC-Provider
Map json response to DTO variables

* Fix variable reference errors ($term → $keyword)
Ensure array keys exist before accessing them
Optimize API calls to prevent unnecessary requests
Improve error handling for better debugging
Enhance readability and maintainability of functions

* Bumped version v1.16.2

* Update BuerklinProvider.php

Change Order of Capabilities

* Change order of capabilities in LCSCProvider.php

* Change order of capabilities in PollinProvider.php

* Try to fix getToken BuerklinProvider.php

* Add ip_buerklin_oauth to knpu_oauth2_client.yaml

* Update buerklin authorize URL in knpu_oauth2_client.yaml

* Update knpu_oauth2_client.yaml

* Adapt Buerklin InfoProvider to new Settings mechanism

* According to Buerklin API spec it's really 'token' as urlAuthorize endpoint

* Rückgabewert ist schon ein Array deshalb kein toArray

* Fix API-Access, add image, price and parameter retrieval (Datasheets not yet implemented because it is not available in the API response)

* Add Caching of requests, use default query params (language and currency) using a function, Fix Footprint assignment, translate German code comments

* Remove DATASHEET from ProviderCapabilities because the Bürklin API doesn't include Datasheet URLs at the moment, more reverse engineering needed

* Update BuerklinSettings with existing translatable strings

* Improve Buerklin Settings Page

* Added Translation strings for Buerklin Info Provider

* Improve Buerklin Provider help message

* Adapt Buerklin-provider to new settings system

* Adapt Buerklin-provider to new settings system: add missing instance of BuerklinSettings

* Improve Compliance Parameters parsing

* Remove language-dependent RoHs Date code and use shortened ISO format, Add Customs Code without parseValueField

* Fix no results for keyword search

* Implement BatchInfoProviderInterface for Buerklin Provider

* Rename searchBatch to searchByKeywordsBatch to correctly implement BatchInfoProviderInterface

* Fix Bulk Info Provider Import for Buerklin

* Tranlate comments to English to prepare for Pull-Request

* Add phpUnit unit tests for BuerklinProvider

* Try fixing PHPStan issues

* Remove OAuthTokenManager from BuerklinProviderTest

Removed OAuthTokenManager mock from BuerklinProviderTest setup.

* Fix Settings must not be instantiated directly

* Fix UnitTest for value_typ

* edd5fb3319 (r2622249199)
Revert "Change order of capabilities in LCSCProvider.php"

This reverts commit dfd6f33e52.

* edd5fb3319 (r2622249861)
Revert "Change order of capabilities in PollinProvider.php"

This reverts commit fc2e7265be.

* Use language setting for ProductShortURL

* Update default language for Buerklin provider to English in documentation

* Add suggested improvements from SonarQube

* Removed unused use directives

* Revert SonarQube proposed change. Having more than one return is acceptable nowadays

* Improve getProviderInfo: disable oauth_app_name, add settings_class, improve disabled_help

* Implement retrieveROPCToken as proposed in https://github.com/Part-DB/Part-DB-server/pull/1151#discussion_r2622976206

* Add missing ) to retrieveROPCToken

* add use OAuthTokenManager and create instance in constructor

* Revert the following commits that tried to implement getToken using OAuthTokenManager

Revert "add use OAuthTokenManager and create instance in constructor"This reverts commit 2a1e7c9b0974ebd7e082d5a2fa62753d6254a767.Revert "Add missing ) to retrieveROPCToken"This reverts commit 8df5cfc49e.
Revert "Implement retrieveROPCToken as proposed in https://github.com/Part-DB/Part-DB-server/pull/1151#discussion_r2622976206"
This reverts commit 66cc732082.

* Remove OAuthTokenManager leftovers

* Disable buerklin provider if settings fields are empty

* Improved docs

* Added TODO comment

---------

Co-authored-by: root <root@part-db.fritz.box>
Co-authored-by: Jan Böhmer <mail@jan-boehmer.de>

.github/workflows/assets_artifact_build.yml

@@ -37,7 +37,7 @@ jobs:
         run: |
           echo "::set-output name=dir::$(composer config cache-files-dir)"
 
-      - uses: actions/cache@v4
+      - uses: actions/cache@v5
         with:
           path: ${{ steps.composer-cache.outputs.dir }}
           key: ${{ runner.os }}-composer-${{ hashFiles('**/composer.lock') }}
@@ -51,7 +51,7 @@ jobs:
         id: yarn-cache-dir-path
         run: echo "::set-output name=dir::$(yarn cache dir)"
 
-      - uses: actions/cache@v4
+      - uses: actions/cache@v5
         id: yarn-cache # use this to check for `cache-hit` (`steps.yarn-cache.outputs.cache-hit != 'true'`)
         with:
           path: ${{ steps.yarn-cache-dir-path.outputs.dir }}
@@ -80,13 +80,13 @@ jobs:
         run: zip -r /tmp/partdb_assets.zip public/build/ vendor/
 
       - name: Upload assets artifact
-        uses: actions/upload-artifact@v5
+        uses: actions/upload-artifact@v6
         with:
           name: Only dependencies and built assets
           path: /tmp/partdb_assets.zip
 
       - name: Upload full artifact
-        uses: actions/upload-artifact@v5
+        uses: actions/upload-artifact@v6
         with:
           name: Full Part-DB including dependencies and built assets
           path: /tmp/partdb_with_assets.zip

.github/workflows/static_analysis.yml

@@ -34,7 +34,7 @@ jobs:
       run: |
         echo "::set-output name=dir::$(composer config cache-files-dir)"
 
-    - uses: actions/cache@v4
+    - uses: actions/cache@v5
       with:
         path: ${{ steps.composer-cache.outputs.dir }}
         key: ${{ runner.os }}-composer-${{ hashFiles('**/composer.lock') }}

.github/workflows/tests.yml

@@ -81,7 +81,7 @@ jobs:
         id: composer-cache
         run: |
           echo "::set-output name=dir::$(composer config cache-files-dir)"
-      - uses: actions/cache@v4
+      - uses: actions/cache@v5
         with:
           path: ${{ steps.composer-cache.outputs.dir }}
           key: ${{ runner.os }}-composer-${{ hashFiles('**/composer.lock') }}
@@ -92,7 +92,7 @@ jobs:
         id: yarn-cache-dir-path
         run: echo "::set-output name=dir::$(yarn cache dir)"
 
-      - uses: actions/cache@v4
+      - uses: actions/cache@v5
         id: yarn-cache # use this to check for `cache-hit` (`steps.yarn-cache.outputs.cache-hit != 'true'`)
         with:
           path: ${{ steps.yarn-cache-dir-path.outputs.dir }}

ENTITY_REFACTORING.md

@@ -1,193 +0,0 @@
-# Entity Inheritance Hierarchy Decomposition
-
-## Overview
-
-This refactoring decomposes the deep entity inheritance hierarchy into a more flexible trait-based architecture. This provides better code reusability, composition, and maintainability.
-
-## Architecture Diagram
-
-### Before (Deep Inheritance):
-```
-AbstractDBElement (ID logic)
-    └─ AbstractNamedDBElement (name + timestamps)
-        └─ AttachmentContainingDBElement (attachments)
-            └─ AbstractStructuralDBElement (tree/hierarchy + parameters)
-                ├─ AbstractPartsContainingDBElement
-                │   ├─ Category
-                │   ├─ Footprint
-                │   ├─ StorageLocation
-                │   └─ AbstractCompany (company fields)
-                │       ├─ Manufacturer
-                │       └─ Supplier
-```
-
-### After (Trait Composition):
-```
-Traits:                          Interfaces:
-- DBElementTrait                 - DBElementInterface
-- NamedElementTrait              - NamedElementInterface
-- TimestampTrait                 - TimeStampableInterface
-- AttachmentsTrait               - HasAttachmentsInterface
-- MasterAttachmentTrait          - HasMasterAttachmentInterface
-- StructuralElementTrait         - StructuralElementInterface
-- ParametersTrait                - HasParametersInterface
-- CompanyTrait                   - CompanyInterface
-
-Class Hierarchy (now uses traits):
-AbstractDBElement (uses DBElementTrait, implements DBElementInterface)
-    └─ AbstractNamedDBElement (uses NamedElementTrait + TimestampTrait)
-        └─ AttachmentContainingDBElement (uses AttachmentsTrait + MasterAttachmentTrait)
-            └─ AbstractStructuralDBElement (uses StructuralElementTrait + ParametersTrait)
-                ├─ AbstractPartsContainingDBElement
-                │   ├─ Category (gets all traits via inheritance)
-                │   ├─ Footprint (gets all traits via inheritance)
-                │   └─ AbstractCompany (uses CompanyTrait)
-                │       ├─ Manufacturer
-                │       └─ Supplier
-```
-
-## Changes Made
-
-### New Traits Created
-
-1. **DBElementTrait** (`src/Entity/Base/DBElementTrait.php`)
-   - Provides basic database element functionality with an ID
-   - Includes `getID()` method and clone helper
-   - Extracted from `AbstractDBElement`
-
-2. **NamedElementTrait** (`src/Entity/Base/NamedElementTrait.php`)
-   - Provides named element functionality (name property and methods)
-   - Includes `getName()`, `setName()`, and `__toString()` methods
-   - Extracted from `AbstractNamedDBElement`
-
-3. **AttachmentsTrait** (`src/Entity/Base/AttachmentsTrait.php`)
-   - Provides attachments collection functionality
-   - Includes methods for adding, removing, and getting attachments
-   - Includes clone helper for deep cloning attachments
-   - Extracted from `AttachmentContainingDBElement`
-
-4. **StructuralElementTrait** (`src/Entity/Base/StructuralElementTrait.php`)
-   - Provides tree/hierarchy functionality for structural elements
-   - Includes parent/child relationships, path calculations, level tracking
-   - Includes methods like `isRoot()`, `isChildOf()`, `getFullPath()`, etc.
-   - Extracted from `AbstractStructuralDBElement`
-
-5. **CompanyTrait** (`src/Entity/Base/CompanyTrait.php`)
-   - Provides company-specific fields (address, phone, email, website, etc.)
-   - Includes getters and setters for all company fields
-   - Extracted from `AbstractCompany`
-
-### New Interfaces Created
-
-1. **DBElementInterface** (`src/Entity/Contracts/DBElementInterface.php`)
-   - Interface for entities with a database ID
-   - Defines `getID()` method
-
-2. **StructuralElementInterface** (`src/Entity/Contracts/StructuralElementInterface.php`)
-   - Interface for structural/hierarchical elements
-   - Defines methods for tree navigation and hierarchy
-
-3. **CompanyInterface** (`src/Entity/Contracts/CompanyInterface.php`)
-   - Interface for company entities
-   - Defines basic company information accessors
-
-4. **HasParametersInterface** (`src/Entity/Contracts/HasParametersInterface.php`)
-   - Interface for entities that have parameters
-   - Defines `getParameters()` method
-
-### Refactored Classes
-
-1. **AbstractDBElement**
-   - Now uses `DBElementTrait`
-   - Implements `DBElementInterface`
-   - Simplified to just use the trait instead of duplicating code
-
-2. **AbstractNamedDBElement**
-   - Now uses `NamedElementTrait` in addition to existing `TimestampTrait`
-   - Cleaner implementation with trait composition
-
-3. **AttachmentContainingDBElement**
-   - Now uses `AttachmentsTrait` and `MasterAttachmentTrait`
-   - Simplified constructor and clone methods
-
-4. **AbstractStructuralDBElement**
-   - Now uses `StructuralElementTrait` and `ParametersTrait`
-   - Implements `StructuralElementInterface` and `HasParametersInterface`
-   - Much cleaner with most functionality extracted to trait
-
-5. **AbstractCompany**
-   - Now uses `CompanyTrait`
-   - Implements `CompanyInterface`
-   - Significantly simplified from ~260 lines to ~20 lines
-
-## Benefits
-
-### 1. **Better Code Reusability**
-   - Traits can be reused in different contexts without requiring inheritance
-   - Easier to mix and match functionality
-
-### 2. **Improved Maintainability**
-   - Each trait focuses on a single concern (SRP - Single Responsibility Principle)
-   - Easier to locate and modify specific functionality
-   - Reduced code duplication
-
-### 3. **More Flexible Architecture**
-   - Entities can now compose functionality as needed
-   - Not locked into a rigid inheritance hierarchy
-   - Easier to add new functionality without modifying base classes
-
-### 4. **Better Testability**
-   - Traits can be tested independently
-   - Easier to mock specific functionality
-
-### 5. **Clearer Contracts**
-   - Interfaces make dependencies explicit
-   - Better IDE support and type hinting
-
-## Migration Path
-
-This refactoring is backward compatible - all existing entities continue to work as before. The changes are internal to the base classes and do not affect the public API.
-
-### For New Entities
-
-New entities can now:
-1. Use traits directly without deep inheritance
-2. Mix and match functionality as needed
-3. Implement only the interfaces they need
-
-Example:
-```php
-class MyCustomEntity extends AbstractDBElement implements NamedElementInterface 
-{
-    use NamedElementTrait;
-    
-    // Custom functionality
-}
-```
-
-## Technical Details
-
-### Trait Usage Pattern
-
-All traits follow this pattern:
-1. Declare properties with appropriate Doctrine/validation annotations
-2. Provide initialization methods (e.g., `initializeAttachments()`)
-3. Provide business logic methods
-4. Provide clone helpers for deep cloning when needed
-
-### Interface Contracts
-
-All interfaces define the minimal contract required for that functionality:
-- DBElementInterface: requires `getID()`
-- NamedElementInterface: requires `getName()`
-- StructuralElementInterface: requires hierarchy methods
-- CompanyInterface: requires company info accessors
-- HasParametersInterface: requires `getParameters()`
-
-## Future Improvements
-
-Potential future enhancements:
-1. Extract more functionality from remaining abstract classes
-2. Create more granular traits for specific features
-3. Add trait-specific unit tests
-4. Consider creating trait-based mixins for common entity patterns

IMPLEMENTATION_SUMMARY.md

@@ -1,141 +0,0 @@
-# Entity Inheritance Hierarchy Refactoring - Implementation Summary
-
-## Task Completed
-Successfully decomposed the deep entity inheritance hierarchy into traits and interfaces for better architecture.
-
-## Changes Overview
-
-### Files Modified (5)
-1. `src/Entity/Base/AbstractDBElement.php` - Now uses DBElementTrait
-2. `src/Entity/Base/AbstractNamedDBElement.php` - Now uses NamedElementTrait
-3. `src/Entity/Attachments/AttachmentContainingDBElement.php` - Now uses AttachmentsTrait
-4. `src/Entity/Base/AbstractStructuralDBElement.php` - Now uses StructuralElementTrait
-5. `src/Entity/Base/AbstractCompany.php` - Now uses CompanyTrait
-
-### New Traits Created (5)
-1. `src/Entity/Base/DBElementTrait.php` - ID management functionality
-2. `src/Entity/Base/NamedElementTrait.php` - Name property and methods
-3. `src/Entity/Base/AttachmentsTrait.php` - Attachment collection management
-4. `src/Entity/Base/StructuralElementTrait.php` - Tree/hierarchy functionality
-5. `src/Entity/Base/CompanyTrait.php` - Company-specific fields
-
-### New Interfaces Created (4)
-1. `src/Entity/Contracts/DBElementInterface.php` - Contract for DB entities
-2. `src/Entity/Contracts/StructuralElementInterface.php` - Contract for hierarchical entities
-3. `src/Entity/Contracts/CompanyInterface.php` - Contract for company entities
-4. `src/Entity/Contracts/HasParametersInterface.php` - Contract for parametrized entities
-
-### Documentation Added (2)
-1. `ENTITY_REFACTORING.md` - Comprehensive documentation with architecture diagrams
-2. `IMPLEMENTATION_SUMMARY.md` - This file
-
-## Impact Analysis
-
-### Code Metrics
-- **Lines Added**: 1,291 (traits, interfaces, documentation)
-- **Lines Removed**: 740 (from base classes)
-- **Net Change**: +551 lines
-- **Code Reduction in Base Classes**: ~1000 lines moved to reusable traits
-
-### Affected Classes
-All entities that extend from the modified base classes now benefit from the trait-based architecture:
-- Category, Footprint, StorageLocation, MeasurementUnit, PartCustomState
-- Manufacturer, Supplier
-- And all other entities in the inheritance chain
-
-### Breaking Changes
-**None** - This is a backward-compatible refactoring. All public APIs remain unchanged.
-
-## Benefits Achieved
-
-### 1. Improved Code Reusability
-- Traits can be mixed and matched in different combinations
-- No longer locked into rigid inheritance hierarchy
-- Easier to create new entity types with specific functionality
-
-### 2. Better Maintainability
-- Each trait has a single, well-defined responsibility
-- Easier to locate and modify specific functionality
-- Reduced code duplication across the codebase
-
-### 3. Enhanced Flexibility
-- Future entities can compose functionality as needed
-- Can add new traits without modifying existing class hierarchy
-- Supports multiple inheritance patterns via trait composition
-
-### 4. Clearer Contracts
-- Interfaces make dependencies and capabilities explicit
-- Better IDE support and auto-completion
-- Improved static analysis capabilities
-
-### 5. Preserved Backward Compatibility
-- All existing entities continue to work unchanged
-- No modifications required to controllers, services, or repositories
-- Database schema remains the same
-
-## Testing Notes
-
-### Validation Performed
-- ✅ PHP syntax validation on all modified files
-- ✅ Verified all traits can be loaded
-- ✅ Code review feedback addressed
-- ✅ Documentation completeness checked
-
-### Recommended Testing
-Before merging, the following tests should be run:
-1. Full PHPUnit test suite
-2. Static analysis (PHPStan level 5)
-3. Integration tests for entities
-4. Database migration tests
-
-## Code Review Feedback Addressed
-
-All code review comments were addressed:
-1. ✅ Fixed typo: "addres" → "address"
-2. ✅ Removed unnecessary comma in docstrings
-3. ✅ Fixed nullable return type documentation
-4. ✅ Fixed inconsistent nullable string initialization
-5. ✅ Replaced isset() with direct null comparison
-6. ✅ Documented trait dependencies (MasterAttachmentTrait)
-7. ✅ Fixed grammar: "a most top element" → "the topmost element"
-
-## Future Enhancements
-
-Potential improvements for future iterations:
-1. Extract more granular traits for specific features
-2. Create trait-specific unit tests
-3. Consider extracting validation logic into traits
-4. Add more interfaces for fine-grained contracts
-5. Create documentation for custom entity development
-
-## Migration Guide for Developers
-
-### Using Traits in New Entities
-
-```php
-// Example: Creating a new entity with specific traits
-use App\Entity\Base\DBElementTrait;
-use App\Entity\Base\NamedElementTrait;
-use App\Entity\Contracts\DBElementInterface;
-use App\Entity\Contracts\NamedElementInterface;
-
-class MyEntity implements DBElementInterface, NamedElementInterface
-{
-    use DBElementTrait;
-    use NamedElementTrait;
-    
-    // Custom functionality here
-}
-```
-
-### Trait Dependencies
-
-Some traits have dependencies on other traits or methods:
-- **StructuralElementTrait** requires `getName()` and `getID()` methods
-- **AttachmentsTrait** works best with `MasterAttachmentTrait`
-
-Refer to trait documentation for specific requirements.
-
-## Conclusion
-
-This refactoring successfully modernizes the entity architecture while maintaining full backward compatibility. The trait-based approach provides better code organization, reusability, and maintainability for the Part-DB project.

VERSION

@@ -1 +1 @@
-2.3.0
+2.4.0

composer.json

@@ -79,6 +79,7 @@
         "symfony/string": "7.4.*",
         "symfony/translation": "7.4.*",
         "symfony/twig-bundle": "7.4.*",
+        "symfony/type-info": "7.4.0",
         "symfony/ux-translator": "^2.10",
         "symfony/ux-turbo": "^2.0",
         "symfony/validator": "7.4.*",

composer.lock

@@ -4,7 +4,7 @@
         "Read more about it at https://getcomposer.org/doc/01-basic-usage.md#installing-dependencies",
         "This file is @generated automatically"
     ],
-    "content-hash": "624cf08821477aa7b8f6efc0d4300087",
+    "content-hash": "43757aac5f0141421893ff144ccc462f",
     "packages": [
         {
             "name": "amphp/amp",
@@ -4997,16 +4997,16 @@
         },
         {
             "name": "jbtronics/settings-bundle",
-            "version": "v3.1.2",
+            "version": "v3.1.3",
             "source": {
                 "type": "git",
                 "url": "https://github.com/jbtronics/settings-bundle.git",
-                "reference": "f16bce21b54d202baabfe05cb7c64a14d43b9671"
+                "reference": "a99c6e4cde40b829c1643b89da506b9588b11eaf"
             },
             "dist": {
                 "type": "zip",
-                "url": "https://api.github.com/repos/jbtronics/settings-bundle/zipball/f16bce21b54d202baabfe05cb7c64a14d43b9671",
-                "reference": "f16bce21b54d202baabfe05cb7c64a14d43b9671",
+                "url": "https://api.github.com/repos/jbtronics/settings-bundle/zipball/a99c6e4cde40b829c1643b89da506b9588b11eaf",
+                "reference": "a99c6e4cde40b829c1643b89da506b9588b11eaf",
                 "shasum": ""
             },
             "require": {
@@ -5067,7 +5067,7 @@
             ],
             "support": {
                 "issues": "https://github.com/jbtronics/settings-bundle/issues",
-                "source": "https://github.com/jbtronics/settings-bundle/tree/v3.1.2"
+                "source": "https://github.com/jbtronics/settings-bundle/tree/v3.1.3"
             },
             "funding": [
                 {
@@ -5079,7 +5079,7 @@
                     "type": "github"
                 }
             ],
-            "time": "2025-11-30T22:22:49+00:00"
+            "time": "2026-01-02T23:58:02+00:00"
         },
         {
             "name": "jfcherng/php-color-output",
@@ -10009,16 +10009,16 @@
         },
         {
             "name": "spomky-labs/otphp",
-            "version": "11.3.0",
+            "version": "11.4.0",
             "source": {
                 "type": "git",
                 "url": "https://github.com/Spomky-Labs/otphp.git",
-                "reference": "2d8ccb5fc992b9cc65ef321fa4f00fefdb3f4b33"
+                "reference": "ec5ff751e87e67daca2b73a35cae0d0e1d20ad45"
             },
             "dist": {
                 "type": "zip",
-                "url": "https://api.github.com/repos/Spomky-Labs/otphp/zipball/2d8ccb5fc992b9cc65ef321fa4f00fefdb3f4b33",
-                "reference": "2d8ccb5fc992b9cc65ef321fa4f00fefdb3f4b33",
+                "url": "https://api.github.com/repos/Spomky-Labs/otphp/zipball/ec5ff751e87e67daca2b73a35cae0d0e1d20ad45",
+                "reference": "ec5ff751e87e67daca2b73a35cae0d0e1d20ad45",
                 "shasum": ""
             },
             "require": {
@@ -10029,18 +10029,7 @@
                 "symfony/deprecation-contracts": "^3.2"
             },
             "require-dev": {
-                "ekino/phpstan-banned-code": "^1.0",
-                "infection/infection": "^0.26|^0.27|^0.28|^0.29",
-                "php-parallel-lint/php-parallel-lint": "^1.3",
-                "phpstan/phpstan": "^1.0",
-                "phpstan/phpstan-deprecation-rules": "^1.0",
-                "phpstan/phpstan-phpunit": "^1.0",
-                "phpstan/phpstan-strict-rules": "^1.0",
-                "phpunit/phpunit": "^9.5.26|^10.0|^11.0",
-                "qossmic/deptrac-shim": "^1.0",
-                "rector/rector": "^1.0",
-                "symfony/phpunit-bridge": "^6.1|^7.0",
-                "symplify/easy-coding-standard": "^12.0"
+                "symfony/error-handler": "^6.4|^7.0|^8.0"
             },
             "type": "library",
             "autoload": {
@@ -10075,7 +10064,7 @@
             ],
             "support": {
                 "issues": "https://github.com/Spomky-Labs/otphp/issues",
-                "source": "https://github.com/Spomky-Labs/otphp/tree/11.3.0"
+                "source": "https://github.com/Spomky-Labs/otphp/tree/11.4.0"
             },
             "funding": [
                 {
@@ -10087,7 +10076,7 @@
                     "type": "patreon"
                 }
             ],
-            "time": "2024-06-12T11:22:32+00:00"
+            "time": "2026-01-03T13:16:55+00:00"
         },
         {
             "name": "spomky-labs/pki-framework",
@@ -13766,21 +13755,21 @@
         },
         {
             "name": "symfony/property-access",
-            "version": "v7.4.3",
+            "version": "v7.4.0",
             "source": {
                 "type": "git",
                 "url": "https://github.com/symfony/property-access.git",
-                "reference": "30aff8455647be949fc2e8fcef2847d5a6743c98"
+                "reference": "537626149d2910ca43eb9ce465654366bf4442f4"
             },
             "dist": {
                 "type": "zip",
-                "url": "https://api.github.com/repos/symfony/property-access/zipball/30aff8455647be949fc2e8fcef2847d5a6743c98",
-                "reference": "30aff8455647be949fc2e8fcef2847d5a6743c98",
+                "url": "https://api.github.com/repos/symfony/property-access/zipball/537626149d2910ca43eb9ce465654366bf4442f4",
+                "reference": "537626149d2910ca43eb9ce465654366bf4442f4",
                 "shasum": ""
             },
             "require": {
                 "php": ">=8.2",
-                "symfony/property-info": "^6.4.31|~7.3.9|^7.4.2|^8.0.3"
+                "symfony/property-info": "^6.4|^7.0|^8.0"
             },
             "require-dev": {
                 "symfony/cache": "^6.4|^7.0|^8.0",
@@ -13823,7 +13812,7 @@
                 "reflection"
             ],
             "support": {
-                "source": "https://github.com/symfony/property-access/tree/v7.4.3"
+                "source": "https://github.com/symfony/property-access/tree/v7.4.0"
             },
             "funding": [
                 {
@@ -13843,27 +13832,27 @@
                     "type": "tidelift"
                 }
             ],
-            "time": "2025-12-18T10:35:58+00:00"
+            "time": "2025-09-08T21:14:32+00:00"
         },
         {
             "name": "symfony/property-info",
-            "version": "v7.4.3",
+            "version": "v7.4.0",
             "source": {
                 "type": "git",
                 "url": "https://github.com/symfony/property-info.git",
-                "reference": "ea62b28cd68fb36e252abd77de61e505a0f2a7b1"
+                "reference": "c3c686e3d3a33a99f6967e69d6d5832acb7c25a1"
             },
             "dist": {
                 "type": "zip",
-                "url": "https://api.github.com/repos/symfony/property-info/zipball/ea62b28cd68fb36e252abd77de61e505a0f2a7b1",
-                "reference": "ea62b28cd68fb36e252abd77de61e505a0f2a7b1",
+                "url": "https://api.github.com/repos/symfony/property-info/zipball/c3c686e3d3a33a99f6967e69d6d5832acb7c25a1",
+                "reference": "c3c686e3d3a33a99f6967e69d6d5832acb7c25a1",
                 "shasum": ""
             },
             "require": {
                 "php": ">=8.2",
                 "symfony/deprecation-contracts": "^2.5|^3",
                 "symfony/string": "^6.4|^7.0|^8.0",
-                "symfony/type-info": "~7.3.8|^7.4.1|^8.0.1"
+                "symfony/type-info": "^7.3.5|^8.0"
             },
             "conflict": {
                 "phpdocumentor/reflection-docblock": "<5.2",
@@ -13913,7 +13902,7 @@
                 "validator"
             ],
             "support": {
-                "source": "https://github.com/symfony/property-info/tree/v7.4.3"
+                "source": "https://github.com/symfony/property-info/tree/v7.4.0"
             },
             "funding": [
                 {
@@ -13933,7 +13922,7 @@
                     "type": "tidelift"
                 }
             ],
-            "time": "2025-12-18T08:28:41+00:00"
+            "time": "2025-11-13T08:38:49+00:00"
         },
         {
             "name": "symfony/psr-http-message-bridge",
@@ -15443,16 +15432,16 @@
         },
         {
             "name": "symfony/type-info",
-            "version": "v7.4.1",
+            "version": "v7.4.0",
             "source": {
                 "type": "git",
                 "url": "https://github.com/symfony/type-info.git",
-                "reference": "ac5ab66b21c758df71b7210cf1033d1ac807f202"
+                "reference": "7f9743e921abcce92a03fc693530209c59e73076"
             },
             "dist": {
                 "type": "zip",
-                "url": "https://api.github.com/repos/symfony/type-info/zipball/ac5ab66b21c758df71b7210cf1033d1ac807f202",
-                "reference": "ac5ab66b21c758df71b7210cf1033d1ac807f202",
+                "url": "https://api.github.com/repos/symfony/type-info/zipball/7f9743e921abcce92a03fc693530209c59e73076",
+                "reference": "7f9743e921abcce92a03fc693530209c59e73076",
                 "shasum": ""
             },
             "require": {
@@ -15502,7 +15491,7 @@
                 "type"
             ],
             "support": {
-                "source": "https://github.com/symfony/type-info/tree/v7.4.1"
+                "source": "https://github.com/symfony/type-info/tree/v7.4.0"
             },
             "funding": [
                 {
@@ -15522,7 +15511,7 @@
                     "type": "tidelift"
                 }
             ],
-            "time": "2025-12-05T14:04:53+00:00"
+            "time": "2025-11-07T09:36:46+00:00"
         },
         {
             "name": "symfony/uid",
@@ -19049,12 +19038,12 @@
             "source": {
                 "type": "git",
                 "url": "https://github.com/Roave/SecurityAdvisories.git",
-                "reference": "412d91dc6342787fd733523797d9c9faf2ad3ea5"
+                "reference": "5ba14c800ff89c74333c22d56ca1c1f35c424805"
             },
             "dist": {
                 "type": "zip",
-                "url": "https://api.github.com/repos/Roave/SecurityAdvisories/zipball/412d91dc6342787fd733523797d9c9faf2ad3ea5",
-                "reference": "412d91dc6342787fd733523797d9c9faf2ad3ea5",
+                "url": "https://api.github.com/repos/Roave/SecurityAdvisories/zipball/5ba14c800ff89c74333c22d56ca1c1f35c424805",
+                "reference": "5ba14c800ff89c74333c22d56ca1c1f35c424805",
                 "shasum": ""
             },
             "conflict": {
@@ -19115,7 +19104,7 @@
                 "backpack/filemanager": "<2.0.2|>=3,<3.0.9",
                 "bacula-web/bacula-web": "<9.7.1",
                 "badaso/core": "<=2.9.11",
-                "bagisto/bagisto": "<=2.3.7",
+                "bagisto/bagisto": "<2.3.10",
                 "barrelstrength/sprout-base-email": "<1.2.7",
                 "barrelstrength/sprout-forms": "<3.9",
                 "barryvdh/laravel-translation-manager": "<0.6.8",
@@ -20048,7 +20037,7 @@
                     "type": "tidelift"
                 }
             ],
-            "time": "2025-12-30T23:05:26+00:00"
+            "time": "2026-01-02T22:05:49+00:00"
         },
         {
             "name": "sebastian/cli-parser",

config/packages/knpu_oauth2_client.yaml

@@ -35,4 +35,4 @@ knpu_oauth2_client:
             provider_options:
                 urlAuthorize: 'https://identity.nexar.com/connect/authorize'
                 urlAccessToken: 'https://identity.nexar.com/connect/token'
-                urlResourceOwnerDetails: ''
+                urlResourceOwnerDetails: ''

docs/usage/information_provider_system.md

@@ -260,6 +260,24 @@ This is not an official API and could break at any time. So use it at your own r
 The following env configuration options are available:
 * `PROVIDER_POLLIN_ENABLED`: Set this to `1` to enable the Pollin provider
 
+### Buerklin
+
+The Buerklin provider uses the [Buerklin API](https://www.buerklin.com/en/services/eprocurement/) to search for parts and get information.
+To use it you have to request access to the API.
+You will get an e-mail with the client ID and client secret, which you have to put in the Part-DB configuration (see below).
+
+Please note that the Buerklin API is limited to 100 requests/minute per IP address and 
+access to the Authentication server is limited to 10 requests/minute per IP address
+
+The following env configuration options are available:
+
+* `PROVIDER_BUERKLIN_CLIENT_ID`: The client ID you got from Buerklin (mandatory)
+* `PROVIDER_BUERKLIN_SECRET`: The client secret you got from Buerklin (mandatory)
+* `PROVIDER_BUERKLIN_USERNAME`: The username you got from Buerklin (mandatory)
+* `PROVIDER_BUERKLIN_PASSWORD`: The password you got from Buerklin (mandatory)
+* `PROVIDER_BUERKLIN_CURRENCY`: The currency you want to get prices in if available (optional, 3 letter ISO-code, default: `EUR`).
+* `PROVIDER_BUERKLIN_LANGUAGE`: The language you want to get the descriptions in. Possible values: `de` = German, `en` = English. (optional, default: `en`)
+
 ### Custom provider
 
 To create a custom provider, you have to create a new class implementing the `InfoProviderInterface` interface. As long

src/DataTables/ProjectBomEntriesDataTable.php

@@ -29,6 +29,7 @@ use App\DataTables\Helpers\PartDataTableHelper;
 use App\Entity\Attachments\Attachment;
 use App\Entity\Parts\Part;
 use App\Entity\ProjectSystem\ProjectBOMEntry;
+use App\Services\ElementTypeNameGenerator;
 use App\Services\EntityURLGenerator;
 use App\Services\Formatters\AmountFormatter;
 use Doctrine\ORM\QueryBuilder;
@@ -41,7 +42,8 @@ use Symfony\Contracts\Translation\TranslatorInterface;
 
 class ProjectBomEntriesDataTable implements DataTableTypeInterface
 {
-    public function __construct(protected TranslatorInterface $translator, protected PartDataTableHelper $partDataTableHelper, protected EntityURLGenerator $entityURLGenerator, protected AmountFormatter $amountFormatter)
+    public function __construct(protected TranslatorInterface $translator, protected PartDataTableHelper $partDataTableHelper,
+        protected EntityURLGenerator $entityURLGenerator, protected AmountFormatter $amountFormatter)
     {
     }
 
@@ -79,7 +81,14 @@ class ProjectBomEntriesDataTable implements DataTableTypeInterface
                     return htmlspecialchars($this->amountFormatter->format($context->getQuantity(), $context->getPart()->getPartUnit()));
                 },
             ])
-
+			->add('partId', TextColumn::class, [
+				'label' => $this->translator->trans('project.bom.part_id'),
+				'visible' => true,
+				'orderField' => 'part.id',
+				'render' => function ($value, ProjectBOMEntry $context) {
+					return $context->getPart() instanceof Part ? (string) $context->getPart()->getId() : '';
+				},
+			])
             ->add('name', TextColumn::class, [
                 'label' => $this->translator->trans('part.table.name'),
                 'orderField' => 'NATSORT(part.name)',

src/Doctrine/Helpers/FieldHelper.php

@@ -104,7 +104,7 @@ final class FieldHelper
     {
         $db_platform = $qb->getEntityManager()->getConnection()->getDatabasePlatform();
 
-        $key = 'field2_' . md5($field_expr);
+        $key = 'field2_' . hash('xxh3', $field_expr);
 
         //If we are on MySQL, we can just use the FIELD function
         if ($db_platform instanceof AbstractMySQLPlatform) {
@@ -121,4 +121,4 @@ final class FieldHelper
 
         return $qb;
     }
-}
+}

src/Entity/Attachments/AttachmentContainingDBElement.php

@@ -24,11 +24,13 @@ namespace App\Entity\Attachments;
 
 use App\Entity\Base\AbstractNamedDBElement;
 use App\Entity\Base\MasterAttachmentTrait;
-use App\Entity\Base\AttachmentsTrait;
 use App\Entity\Contracts\HasAttachmentsInterface;
 use App\Entity\Contracts\HasMasterAttachmentInterface;
 use App\Repository\AttachmentContainingDBElementRepository;
+use Doctrine\Common\Collections\ArrayCollection;
+use Doctrine\Common\Collections\Collection;
 use Doctrine\ORM\Mapping as ORM;
+use Symfony\Component\Serializer\Annotation\Groups;
 
 /**
  * @template AT of Attachment
@@ -37,18 +39,83 @@ use Doctrine\ORM\Mapping as ORM;
 abstract class AttachmentContainingDBElement extends AbstractNamedDBElement implements HasMasterAttachmentInterface, HasAttachmentsInterface
 {
     use MasterAttachmentTrait;
-    use AttachmentsTrait;
+
+    /**
+     * @var Collection<int, Attachment>
+     * @phpstan-var Collection<int, AT>
+     * ORM Mapping is done in subclasses (e.g. Part)
+     */
+    #[Groups(['full', 'import'])]
+    protected Collection $attachments;
 
     public function __construct()
     {
-        $this->initializeAttachments();
+        $this->attachments = new ArrayCollection();
     }
 
     public function __clone()
     {
-        $this->cloneAttachments();
+        if ($this->id) {
+            $attachments = $this->attachments;
+            $this->attachments = new ArrayCollection();
+            //Set master attachment is needed
+            foreach ($attachments as $attachment) {
+                $clone = clone $attachment;
+                if ($attachment === $this->master_picture_attachment) {
+                    $this->setMasterPictureAttachment($clone);
+                }
+                $this->addAttachment($clone);
+            }
+        }
 
         //Parent has to be last call, as it resets the ID
         parent::__clone();
     }
+
+    /********************************************************************************
+     *
+     *   Getters
+     *
+     *********************************************************************************/
+
+    /**
+     *  Gets all attachments associated with this element.
+     */
+    public function getAttachments(): Collection
+    {
+        return $this->attachments;
+    }
+
+    /**
+     * Adds an attachment to this element.
+     *
+     * @param Attachment $attachment Attachment
+     *
+     * @return $this
+     */
+    public function addAttachment(Attachment $attachment): self
+    {
+        //Attachment must be associated with this element
+        $attachment->setElement($this);
+        $this->attachments->add($attachment);
+
+        return $this;
+    }
+
+    /**
+     * Removes the given attachment from this element.
+     *
+     * @return $this
+     */
+    public function removeAttachment(Attachment $attachment): self
+    {
+        $this->attachments->removeElement($attachment);
+
+        //Check if this is the master attachment -> remove it from master attachment too, or it can not be deleted from DB...
+        if ($attachment === $this->getMasterPictureAttachment()) {
+            $this->setMasterPictureAttachment(null);
+        }
+
+        return $this;
+    }
 }

src/Entity/Attachments/AttachmentType.php

@@ -52,14 +52,12 @@ use Symfony\Component\Validator\Constraints as Assert;
 /**
  * Class AttachmentType.
  * @see \App\Tests\Entity\Attachments\AttachmentTypeTest
+ * @extends AbstractStructuralDBElement<AttachmentTypeAttachment, AttachmentTypeParameter>
  */
 #[ORM\Entity(repositoryClass: StructuralDBElementRepository::class)]
 #[ORM\Table(name: '`attachment_types`')]
 #[ORM\Index(columns: ['name'], name: 'attachment_types_idx_name')]
 #[ORM\Index(columns: ['parent_id', 'name'], name: 'attachment_types_idx_parent_name')]
-#[ORM\HasLifecycleCallbacks]
-#[ORM\EntityListeners([TreeCacheInvalidationListener::class])]
-#[UniqueEntity(fields: ['name', 'parent'], message: 'structural.entity.unique_name', ignoreNull: false)]
 #[ApiResource(
     operations: [
         new Get(security: 'is_granted("read", object)'),
@@ -86,16 +84,8 @@ use Symfony\Component\Validator\Constraints as Assert;
 #[ApiFilter(LikeFilter::class, properties: ["name", "comment"])]
 #[ApiFilter(DateFilter::class, strategy: DateFilterInterface::EXCLUDE_NULL)]
 #[ApiFilter(OrderFilter::class, properties: ['name', 'id', 'addedDate', 'lastModified'])]
-class AttachmentType implements DBElementInterface, NamedElementInterface, TimeStampableInterface, HasAttachmentsInterface, HasMasterAttachmentInterface, StructuralElementInterface, HasParametersInterface, \Stringable, \JsonSerializable
+class AttachmentType extends AbstractStructuralDBElement
 {
-    use DBElementTrait;
-    use NamedElementTrait;
-    use TimestampTrait;
-    use AttachmentsTrait;
-    use MasterAttachmentTrait;
-    use StructuralElementTrait;
-    use ParametersTrait;
-
     #[ORM\OneToMany(mappedBy: 'parent', targetEntity: AttachmentType::class, cascade: ['persist'])]
     #[ORM\OrderBy(['name' => Criteria::ASC])]
     protected Collection $children;
@@ -104,10 +94,7 @@ class AttachmentType implements DBElementInterface, NamedElementInterface, TimeS
     #[ORM\JoinColumn(name: 'parent_id')]
     #[Groups(['attachment_type:read', 'attachment_type:write'])]
     #[ApiProperty(readableLink: true, writableLink: false)]
-    protected ?self $parent = null;
-
-    #[Groups(['attachment_type:read', 'attachment_type:write'])]
-    protected string $comment = '';
+    protected ?AbstractStructuralDBElement $parent = null;
 
     /**
      * @var string A comma separated list of file types, which are allowed for attachment files.
@@ -136,7 +123,6 @@ class AttachmentType implements DBElementInterface, NamedElementInterface, TimeS
     /** @var Collection<int, AttachmentTypeParameter>
      */
     #[Assert\Valid]
-    #[UniqueObjectCollection(fields: ['name', 'group', 'element'])]
     #[ORM\OneToMany(mappedBy: 'element', targetEntity: AttachmentTypeParameter::class, cascade: ['persist', 'remove'], orphanRemoval: true)]
     #[ORM\OrderBy(['group' => Criteria::ASC, 'name' => 'ASC'])]
     #[Groups(['attachment_type:read', 'attachment_type:write', 'import', 'full'])]
@@ -156,37 +142,13 @@ class AttachmentType implements DBElementInterface, NamedElementInterface, TimeS
 
     public function __construct()
     {
-        $this->initializeAttachments();
-        $this->initializeStructuralElement();
         $this->children = new ArrayCollection();
         $this->parameters = new ArrayCollection();
+        parent::__construct();
         $this->attachments = new ArrayCollection();
         $this->attachments_with_type = new ArrayCollection();
     }
 
-    public function __clone()
-    {
-        if ($this->id) {
-            $this->cloneDBElement();
-            $this->cloneAttachments();
-            
-            // We create a new object, so give it a new creation date
-            $this->addedDate = null;
-            
-            //Deep clone parameters
-            $parameters = $this->parameters;
-            $this->parameters = new ArrayCollection();
-            foreach ($parameters as $parameter) {
-                $this->addParameter(clone $parameter);
-            }
-        }
-    }
-
-    public function jsonSerialize(): array
-    {
-        return ['@id' => $this->getID()];
-    }
-
     /**
      * Get all attachments ("Attachment" objects) with this type.
      *

src/Entity/Base/AbstractCompany.php

@@ -24,9 +24,11 @@ namespace App\Entity\Base;
 
 use App\Entity\Attachments\Attachment;
 use App\Entity\Parameters\AbstractParameter;
-use App\Entity\Contracts\CompanyInterface;
+use Doctrine\DBAL\Types\Types;
 use Doctrine\ORM\Mapping as ORM;
 use Symfony\Component\Serializer\Annotation\Groups;
+use function is_string;
+use Symfony\Component\Validator\Constraints as Assert;
 
 /**
  * This abstract class is used for companies like suppliers or manufacturers.
@@ -36,15 +38,226 @@ use Symfony\Component\Serializer\Annotation\Groups;
  * @extends AbstractPartsContainingDBElement<AT, PT>
  */
 #[ORM\MappedSuperclass]
-abstract class AbstractCompany extends AbstractPartsContainingDBElement implements CompanyInterface
+abstract class AbstractCompany extends AbstractPartsContainingDBElement
 {
-    use CompanyTrait;
-
     #[Groups(['company:read'])]
     protected ?\DateTimeImmutable $addedDate = null;
     #[Groups(['company:read'])]
     protected ?\DateTimeImmutable $lastModified = null;
 
+    /**
+     * @var string The address of the company
+     */
+    #[Groups(['full', 'company:read', 'company:write', 'import', 'extended'])]
+    #[ORM\Column(type: Types::STRING)]
+    #[Assert\Length(max: 255)]
+    protected string $address = '';
+
+    /**
+     * @var string The phone number of the company
+     */
+    #[Groups(['full', 'company:read', 'company:write', 'import', 'extended'])]
+    #[ORM\Column(type: Types::STRING)]
+    #[Assert\Length(max: 255)]
+    protected string $phone_number = '';
+
+    /**
+     * @var string The fax number of the company
+     */
+    #[Groups(['full', 'company:read', 'company:write', 'import', 'extended'])]
+    #[ORM\Column(type: Types::STRING)]
+    #[Assert\Length(max: 255)]
+    protected string $fax_number = '';
+
+    /**
+     * @var string The email address of the company
+     */
+    #[Assert\Email]
+    #[Groups(['full', 'company:read', 'company:write', 'import', 'extended'])]
+    #[ORM\Column(type: Types::STRING)]
+    #[Assert\Length(max: 255)]
+    protected string $email_address = '';
+
+    /**
+     * @var string The website of the company
+     */
+    #[Assert\Url(requireTld: false)]
+    #[Groups(['full', 'company:read', 'company:write', 'import', 'extended'])]
+    #[ORM\Column(type: Types::STRING, length: 2048)]
+    #[Assert\Length(max: 2048)]
+    protected string $website = '';
+
     #[Groups(['company:read', 'company:write', 'import', 'full', 'extended'])]
     protected string $comment = '';
+
+    /**
+     * @var string The link to the website of an article. Use %PARTNUMBER% as placeholder for the part number.
+     */
+    #[ORM\Column(type: Types::STRING, length: 2048)]
+    #[Assert\Length(max: 2048)]
+    #[Groups(['full', 'company:read', 'company:write', 'import', 'extended'])]
+    protected string $auto_product_url = '';
+
+    /********************************************************************************
+     *
+     *   Getters
+     *
+     *********************************************************************************/
+
+    /**
+     * Get the address.
+     *
+     * @return string the address of the company (with "\n" as line break)
+     */
+    public function getAddress(): string
+    {
+        return $this->address;
+    }
+
+    /**
+     * Get the phone number.
+     *
+     * @return string the phone number of the company
+     */
+    public function getPhoneNumber(): string
+    {
+        return $this->phone_number;
+    }
+
+    /**
+     * Get the fax number.
+     *
+     * @return string the fax number of the company
+     */
+    public function getFaxNumber(): string
+    {
+        return $this->fax_number;
+    }
+
+    /**
+     * Get the e-mail address.
+     *
+     * @return string the e-mail address of the company
+     */
+    public function getEmailAddress(): string
+    {
+        return $this->email_address;
+    }
+
+    /**
+     * Get the website.
+     *
+     * @return string the website of the company
+     */
+    public function getWebsite(): string
+    {
+        return $this->website;
+    }
+
+    /**
+     * Get the link to the website of an article.
+     *
+     * @param  string|null  $partnr * NULL for returning the URL with a placeholder for the part number
+     *                       * or the part number for returning the direct URL to the article
+     *
+     * @return string the link to the article
+     */
+    public function getAutoProductUrl(?string $partnr = null): string
+    {
+        if (is_string($partnr)) {
+            return str_replace('%PARTNUMBER%', $partnr, $this->auto_product_url);
+        }
+
+        return $this->auto_product_url;
+    }
+
+    /********************************************************************************
+     *
+     *   Setters
+     *
+     *********************************************************************************/
+
+    /**
+     * Set the addres.
+     *
+     * @param string $new_address the new address (with "\n" as line break)
+     *
+     * @return $this
+     */
+    public function setAddress(string $new_address): self
+    {
+        $this->address = $new_address;
+
+        return $this;
+    }
+
+    /**
+     * Set the phone number.
+     *
+     * @param string $new_phone_number the new phone number
+     *
+     * @return $this
+     */
+    public function setPhoneNumber(string $new_phone_number): self
+    {
+        $this->phone_number = $new_phone_number;
+
+        return $this;
+    }
+
+    /**
+     * Set the fax number.
+     *
+     * @param string $new_fax_number the new fax number
+     *
+     * @return $this
+     */
+    public function setFaxNumber(string $new_fax_number): self
+    {
+        $this->fax_number = $new_fax_number;
+
+        return $this;
+    }
+
+    /**
+     * Set the e-mail address.
+     *
+     * @param string $new_email_address the new e-mail address
+     *
+     * @return $this
+     */
+    public function setEmailAddress(string $new_email_address): self
+    {
+        $this->email_address = $new_email_address;
+
+        return $this;
+    }
+
+    /**
+     * Set the website.
+     *
+     * @param string $new_website the new website
+     *
+     * @return $this
+     */
+    public function setWebsite(string $new_website): self
+    {
+        $this->website = $new_website;
+
+        return $this;
+    }
+
+    /**
+     * Set the link to the website of an article.
+     *
+     * @param string $new_url the new URL with the placeholder %PARTNUMBER% for the part number
+     *
+     * @return $this
+     */
+    public function setAutoProductUrl(string $new_url): self
+    {
+        $this->auto_product_url = $new_url;
+
+        return $this;
+    }
 }

src/Entity/Base/AbstractDBElement.php

@@ -38,7 +38,6 @@ use App\Entity\Attachments\ProjectAttachment;
 use App\Entity\Attachments\StorageLocationAttachment;
 use App\Entity\Attachments\SupplierAttachment;
 use App\Entity\Attachments\UserAttachment;
-use App\Entity\Contracts\DBElementInterface;
 use App\Entity\Parameters\AbstractParameter;
 use App\Entity\Parts\Category;
 use App\Entity\PriceInformations\Pricedetail;
@@ -57,9 +56,11 @@ use App\Entity\Parts\MeasurementUnit;
 use App\Entity\Parts\Supplier;
 use App\Entity\UserSystem\User;
 use App\Repository\DBElementRepository;
+use Doctrine\DBAL\Types\Types;
 use Doctrine\ORM\Mapping as ORM;
 use JsonSerializable;
 use Symfony\Component\Serializer\Annotation\DiscriminatorMap;
+use Symfony\Component\Serializer\Annotation\Groups;
 
 /**
  * This class is for managing all database objects.
@@ -105,13 +106,36 @@ use Symfony\Component\Serializer\Annotation\DiscriminatorMap;
     'user' => User::class]
 )]
 #[ORM\MappedSuperclass(repositoryClass: DBElementRepository::class)]
-abstract class AbstractDBElement implements JsonSerializable, DBElementInterface
+abstract class AbstractDBElement implements JsonSerializable
 {
-    use DBElementTrait;
+    /** @var int|null The Identification number for this part. This value is unique for the element in this table.
+     * Null if the element is not saved to DB yet.
+     */
+    #[Groups(['full', 'api:basic:read'])]
+    #[ORM\Column(type: Types::INTEGER)]
+    #[ORM\Id]
+    #[ORM\GeneratedValue]
+    protected ?int $id = null;
 
     public function __clone()
     {
-        $this->cloneDBElement();
+        if ($this->id) {
+            //Set ID to null, so that an new entry is created
+            $this->id = null;
+        }
+    }
+
+    /**
+     * Get the ID. The ID can be zero, or even negative (for virtual elements). If an element is virtual, can be
+     * checked with isVirtualElement().
+     *
+     * Returns null, if the element is not saved to the DB yet.
+     *
+     * @return int|null the ID of this element
+     */
+    public function getID(): ?int
+    {
+        return $this->id;
     }
 
     public function jsonSerialize(): array

src/Entity/Base/AbstractNamedDBElement.php

@@ -23,9 +23,12 @@ declare(strict_types=1);
 namespace App\Entity\Base;
 
 use App\Repository\NamedDBElementRepository;
+use Doctrine\DBAL\Types\Types;
 use App\Entity\Contracts\NamedElementInterface;
 use App\Entity\Contracts\TimeStampableInterface;
 use Doctrine\ORM\Mapping as ORM;
+use Symfony\Component\Serializer\Annotation\Groups;
+use Symfony\Component\Validator\Constraints as Assert;
 
 /**
  * All subclasses of this class have an attribute "name".
@@ -35,7 +38,26 @@ use Doctrine\ORM\Mapping as ORM;
 abstract class AbstractNamedDBElement extends AbstractDBElement implements NamedElementInterface, TimeStampableInterface, \Stringable
 {
     use TimestampTrait;
-    use NamedElementTrait;
+
+    /**
+     * @var string The name of this element
+     */
+    #[Assert\NotBlank]
+    #[Groups(['simple', 'extended', 'full', 'import', 'api:basic:read', 'api:basic:write'])]
+    #[ORM\Column(type: Types::STRING)]
+    #[Assert\Length(max: 255)]
+    protected string $name = '';
+
+    /******************************************************************************
+     *
+     * Helpers
+     *
+     ******************************************************************************/
+
+    public function __toString(): string
+    {
+        return $this->getName();
+    }
 
     public function __clone()
     {
@@ -43,6 +65,40 @@ abstract class AbstractNamedDBElement extends AbstractDBElement implements Named
             //We create a new object, so give it a new creation date
             $this->addedDate = null;
         }
-        parent::__clone();
+        parent::__clone(); // TODO: Change the autogenerated stub
+    }
+
+    /********************************************************************************
+     *
+     *   Getters
+     *
+     *********************************************************************************/
+
+    /**
+     * Get the name of this element.
+     *
+     * @return string the name of this element
+     */
+    public function getName(): string
+    {
+        return $this->name;
+    }
+
+    /********************************************************************************
+     *
+     *   Setters
+     *
+     *********************************************************************************/
+
+    /**
+     * Change the name of this element.
+     *
+     * @param string $new_name the new name
+     */
+    public function setName(string $new_name): self
+    {
+        $this->name = $new_name;
+
+        return $this;
     }
 }

src/Entity/Base/AbstractStructuralDBElement.php

@@ -24,18 +24,22 @@ namespace App\Entity\Base;
 
 use App\Entity\Attachments\Attachment;
 use App\Entity\Parameters\AbstractParameter;
-use App\Entity\Contracts\StructuralElementInterface;
-use App\Entity\Contracts\HasParametersInterface;
 use App\Repository\StructuralDBElementRepository;
 use App\EntityListeners\TreeCacheInvalidationListener;
 use App\Validator\Constraints\UniqueObjectCollection;
+use Doctrine\DBAL\Types\Types;
 use App\Entity\Attachments\AttachmentContainingDBElement;
 use App\Entity\Parameters\ParametersTrait;
+use App\Validator\Constraints\NoneOfItsChildren;
+use Symfony\Component\Serializer\Annotation\SerializedName;
+use Symfony\Component\Validator\Constraints as Assert;
+use function count;
 use Doctrine\Common\Collections\ArrayCollection;
 use Doctrine\Common\Collections\Collection;
 use Doctrine\ORM\Mapping as ORM;
+use InvalidArgumentException;
 use Symfony\Bridge\Doctrine\Validator\Constraints\UniqueEntity;
-use Symfony\Component\Validator\Constraints as Assert;
+use Symfony\Component\Serializer\Annotation\Groups;
 
 /**
  * All elements with the fields "id", "name" and "parent_id" (at least).
@@ -58,10 +62,52 @@ use Symfony\Component\Validator\Constraints as Assert;
 #[UniqueEntity(fields: ['name', 'parent'], message: 'structural.entity.unique_name', ignoreNull: false)]
 #[ORM\MappedSuperclass(repositoryClass: StructuralDBElementRepository::class)]
 #[ORM\EntityListeners([TreeCacheInvalidationListener::class])]
-abstract class AbstractStructuralDBElement extends AttachmentContainingDBElement implements StructuralElementInterface, HasParametersInterface
+abstract class AbstractStructuralDBElement extends AttachmentContainingDBElement
 {
     use ParametersTrait;
-    use StructuralElementTrait;
+
+    /**
+     * This is a not standard character, so build a const, so a dev can easily use it.
+     */
+    final public const PATH_DELIMITER_ARROW = ' → ';
+
+    /**
+     * @var string The comment info for this element as markdown
+     */
+    #[Groups(['full', 'import'])]
+    #[ORM\Column(type: Types::TEXT)]
+    protected string $comment = '';
+
+    /**
+     * @var bool If this property is set, this element can not be selected for part properties.
+     *           Useful if this element should be used only for grouping, sorting.
+     */
+    #[Groups(['full', 'import'])]
+    #[ORM\Column(type: Types::BOOLEAN)]
+    protected bool $not_selectable = false;
+
+    /**
+     * @var int
+     */
+    protected int $level = 0;
+
+    /**
+     * We can not define the mapping here, or we will get an exception. Unfortunately we have to do the mapping in the
+     * subclasses.
+     *
+     * @var Collection<int, AbstractStructuralDBElement>
+     * @phpstan-var Collection<int, static>
+     */
+    #[Groups(['include_children'])]
+    protected Collection $children;
+
+    /**
+     * @var AbstractStructuralDBElement|null
+     * @phpstan-var static|null
+     */
+    #[Groups(['include_parents', 'import'])]
+    #[NoneOfItsChildren]
+    protected ?AbstractStructuralDBElement $parent = null;
 
     /**
      * Mapping done in subclasses.
@@ -73,10 +119,21 @@ abstract class AbstractStructuralDBElement extends AttachmentContainingDBElement
     #[UniqueObjectCollection(fields: ['name', 'group', 'element'])]
     protected Collection $parameters;
 
+    /** @var string[] all names of all parent elements as an array of strings,
+     *  the last array element is the name of the element itself
+     */
+    private array $full_path_strings = [];
+
+    /**
+     * Alternative names (semicolon-separated) for this element, which can be used for searching (especially for info provider system)
+     */
+    #[ORM\Column(type: Types::TEXT, nullable: true, options: ['default' => null])]
+    private ?string $alternative_names = "";
+
     public function __construct()
     {
         parent::__construct();
-        $this->initializeStructuralElement();
+        $this->children = new ArrayCollection();
         $this->parameters = new ArrayCollection();
     }
 
@@ -92,4 +149,307 @@ abstract class AbstractStructuralDBElement extends AttachmentContainingDBElement
         }
         parent::__clone();
     }
+
+    /******************************************************************************
+     * StructuralDBElement constructor.
+     *****************************************************************************/
+
+    /**
+     * Check if this element is a child of another element (recursive).
+     *
+     * @param AbstractStructuralDBElement $another_element the object to compare
+     *                                                     IMPORTANT: both objects to compare must be from the same class (for example two "Device" objects)!
+     *
+     * @return bool true, if this element is child of $another_element
+     *
+     * @throws InvalidArgumentException if there was an error
+     */
+    public function isChildOf(self $another_element): bool
+    {
+        $class_name = static::class;
+
+        //Check if both elements compared, are from the same type
+        // (we have to check inheritance, or we get exceptions when using doctrine entities (they have a proxy type):
+        if (!$another_element instanceof $class_name && !is_a($this, $another_element::class)) {
+            throw new InvalidArgumentException('isChildOf() only works for objects of the same type!');
+        }
+
+        if (!$this->getParent() instanceof self) { // this is the root node
+            return false;
+        }
+
+        //If the parent element is equal to the element we want to compare, return true
+        if ($this->getParent()->getID() === null) {
+            //If the IDs are not yet defined, we have to compare the objects itself
+            if ($this->getParent() === $another_element) {
+                return true;
+            }
+        } elseif ($this->getParent()->getID() === $another_element->getID()) {
+            return true;
+        }
+
+        //Otherwise, check recursively
+        return $this->parent->isChildOf($another_element);
+    }
+
+    /**
+     * Checks if this element is an root element (has no parent).
+     *
+     * @return bool true if this element is a root element
+     */
+    public function isRoot(): bool
+    {
+        return $this->parent === null;
+    }
+
+    /******************************************************************************
+     *
+     * Getters
+     *
+     ******************************************************************************/
+
+    /**
+     * Get the parent of this element.
+     *
+     * @return static|null The parent element. Null if this element, does not have a parent.
+     */
+    public function getParent(): ?self
+    {
+        return $this->parent;
+    }
+
+    /**
+     *  Get the comment of the element as markdown encoded string.
+
+     *
+     * @return string the comment
+     */
+    public function getComment(): ?string
+    {
+        return $this->comment;
+    }
+
+    /**
+     * Get the level.
+     *
+     * The level of the root node is -1.
+     *
+     * @return int the level of this element (zero means a most top element
+     *             [a sub element of the root node])
+     */
+    public function getLevel(): int
+    {
+        /*
+         * Only check for nodes that have a parent. In the other cases zero is correct.
+         */
+        if (0 === $this->level && $this->parent instanceof self) {
+            $element = $this->parent;
+            while ($element instanceof self) {
+                /** @var AbstractStructuralDBElement $element */
+                $element = $element->parent;
+                ++$this->level;
+            }
+        }
+
+        return $this->level;
+    }
+
+    /**
+     * Get the full path.
+     *
+     * @param string $delimiter the delimiter of the returned string
+     *
+     * @return string the full path (incl. the name of this element), delimited by $delimiter
+     */
+    #[Groups(['api:basic:read'])]
+    #[SerializedName('full_path')]
+    public function getFullPath(string $delimiter = self::PATH_DELIMITER_ARROW): string
+    {
+        if ($this->full_path_strings === []) {
+            $this->full_path_strings = [];
+            $this->full_path_strings[] = $this->getName();
+            $element = $this;
+
+            $overflow = 20; //We only allow 20 levels depth
+
+            while ($element->parent instanceof self && $overflow >= 0) {
+                $element = $element->parent;
+                $this->full_path_strings[] = $element->getName();
+                //Decrement to prevent mem overflow.
+                --$overflow;
+            }
+
+            $this->full_path_strings = array_reverse($this->full_path_strings);
+        }
+
+        return implode($delimiter, $this->full_path_strings);
+    }
+
+    /**
+     * Gets the path to this element (including the element itself).
+     *
+     * @return self[] An array with all (recursively) parent elements (including this one),
+     *                ordered from the lowest levels (root node) first to the highest level (the element itself)
+     */
+    public function getPathArray(): array
+    {
+        $tmp = [];
+        $tmp[] = $this;
+
+        //We only allow 20 levels depth
+        while (!end($tmp)->isRoot() && count($tmp) < 20) {
+            $tmp[] = end($tmp)->parent;
+        }
+
+        return array_reverse($tmp);
+    }
+
+    /**
+     * Get all sub elements of this element.
+     *
+     * @return Collection<static>|iterable all subelements as an array of objects (sorted by their full path)
+     * @psalm-return Collection<int, static>
+     */
+    public function getSubelements(): iterable
+    {
+        //If the parent is equal to this object, we would get an endless loop, so just return an empty array
+        //This is just a workaround, as validator should prevent this behaviour, before it gets written to the database
+        if ($this->parent === $this) {
+            return new ArrayCollection();
+        }
+
+        //@phpstan-ignore-next-line
+        return $this->children ?? new ArrayCollection();
+    }
+
+    /**
+     * @see getSubelements()
+     * @return Collection<static>|iterable
+     * @psalm-return Collection<int, static>
+     */
+    public function getChildren(): iterable
+    {
+        return $this->getSubelements();
+    }
+
+    public function isNotSelectable(): bool
+    {
+        return $this->not_selectable;
+    }
+
+    /******************************************************************************
+     *
+     * Setters
+     *
+     ******************************************************************************/
+
+    /**
+     * Sets the new parent object.
+     *
+     * @param  static|null  $new_parent  The new parent object
+     * @return $this
+     */
+    public function setParent(?self $new_parent): self
+    {
+        /*
+        if ($new_parent->isChildOf($this)) {
+            throw new \InvalidArgumentException('You can not use one of the element childs as parent!');
+        } */
+
+        $this->parent = $new_parent;
+
+        //Add this element as child to the new parent
+        if ($new_parent instanceof self) {
+            $new_parent->getChildren()->add($this);
+        }
+
+        return $this;
+    }
+
+    /**
+     *  Set the comment.
+     *
+     * @param  string  $new_comment  the new comment
+     *
+     * @return $this
+     */
+    public function setComment(string $new_comment): self
+    {
+        $this->comment = $new_comment;
+
+        return $this;
+    }
+
+    /**
+     * Adds the given element as child to this element.
+     * @param  static  $child
+     * @return $this
+     */
+    public function addChild(self $child): self
+    {
+        $this->children->add($child);
+        //Children get this element as parent
+        $child->setParent($this);
+        return $this;
+    }
+
+    /**
+     * Removes the given element as child from this element.
+     * @param  static  $child
+     * @return $this
+     */
+    public function removeChild(self $child): self
+    {
+        $this->children->removeElement($child);
+        //Children has no parent anymore
+        $child->setParent(null);
+        return $this;
+    }
+
+    /**
+     * @return AbstractStructuralDBElement
+     */
+    public function setNotSelectable(bool $not_selectable): self
+    {
+        $this->not_selectable = $not_selectable;
+
+        return $this;
+    }
+
+    public function clearChildren(): self
+    {
+        $this->children = new ArrayCollection();
+
+        return $this;
+    }
+
+    /**
+     * Returns a comma separated list of alternative names.
+     * @return string|null
+     */
+    public function getAlternativeNames(): ?string
+    {
+        if ($this->alternative_names === null) {
+            return null;
+        }
+
+        //Remove trailing comma
+        return rtrim($this->alternative_names, ',');
+    }
+
+    /**
+     * Sets a comma separated list of alternative names.
+     * @return $this
+     */
+    public function setAlternativeNames(?string $new_value): self
+    {
+        //Add a trailing comma, if not already there (makes it easier to find in the database)
+        if (is_string($new_value) && !str_ends_with($new_value, ',')) {
+            $new_value .= ',';
+        }
+
+        $this->alternative_names = $new_value;
+
+        return $this;
+    }
 }

src/Entity/Base/AttachmentsTrait.php

@@ -1,118 +0,0 @@
-<?php
-/*
- * This file is part of Part-DB (https://github.com/Part-DB/Part-DB-symfony).
- *
- *  Copyright (C) 2019 - 2022 Jan Böhmer (https://github.com/jbtronics)
- *
- *  This program is free software: you can redistribute it and/or modify
- *  it under the terms of the GNU Affero General Public License as published
- *  by the Free Software Foundation, either version 3 of the License, or
- *  (at your option) any later version.
- *
- *  This program is distributed in the hope that it will be useful,
- *  but WITHOUT ANY WARRANTY; without even the implied warranty of
- *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
- *  GNU Affero General Public License for more details.
- *
- *  You should have received a copy of the GNU Affero General Public License
- *  along with this program.  If not, see <https://www.gnu.org/licenses/>.
- */
-
-declare(strict_types=1);
-
-namespace App\Entity\Base;
-
-use App\Entity\Attachments\Attachment;
-use Doctrine\Common\Collections\ArrayCollection;
-use Doctrine\Common\Collections\Collection;
-use Symfony\Component\Serializer\Annotation\Groups;
-
-/**
- * Trait providing attachments functionality.
- *
- * Requirements:
- * - Class using this trait should have $id property (e.g., via DBElementTrait)
- * - Class using this trait should use MasterAttachmentTrait for full functionality
- * - Class should implement HasAttachmentsInterface
- *
- * Note: This trait has an optional dependency on MasterAttachmentTrait.
- * If MasterAttachmentTrait is used, the removeAttachment and cloneAttachments methods
- * will handle master picture attachment properly. Otherwise, those checks are no-ops.
- */
-trait AttachmentsTrait
-{
-    /**
-     * @var Collection<int, Attachment>
-     * ORM Mapping is done in subclasses (e.g. Part)
-     */
-    #[Groups(['full', 'import'])]
-    protected Collection $attachments;
-
-    /**
-     * Initialize the attachments collection.
-     */
-    protected function initializeAttachments(): void
-    {
-        $this->attachments = new ArrayCollection();
-    }
-
-    /**
-     *  Gets all attachments associated with this element.
-     */
-    public function getAttachments(): Collection
-    {
-        return $this->attachments;
-    }
-
-    /**
-     * Adds an attachment to this element.
-     *
-     * @param Attachment $attachment Attachment
-     *
-     * @return $this
-     */
-    public function addAttachment(Attachment $attachment): self
-    {
-        //Attachment must be associated with this element
-        $attachment->setElement($this);
-        $this->attachments->add($attachment);
-
-        return $this;
-    }
-
-    /**
-     * Removes the given attachment from this element.
-     *
-     * @return $this
-     */
-    public function removeAttachment(Attachment $attachment): self
-    {
-        $this->attachments->removeElement($attachment);
-
-        //Check if this is the master attachment -> remove it from master attachment too, or it can not be deleted from DB...
-        if ($this->master_picture_attachment !== null && $attachment === $this->master_picture_attachment) {
-            $this->setMasterPictureAttachment(null);
-        }
-
-        return $this;
-    }
-
-    /**
-     * Clone helper for attachments - deep clones all attachments.
-     */
-    protected function cloneAttachments(): void
-    {
-        if (isset($this->id) && $this->id) {
-            $attachments = $this->attachments;
-            $this->attachments = new ArrayCollection();
-            //Set master attachment is needed
-            foreach ($attachments as $attachment) {
-                $clone = clone $attachment;
-                if ($this->master_picture_attachment !== null && $attachment === $this->master_picture_attachment) {
-                    $this->setMasterPictureAttachment($clone);
-                }
-                $this->addAttachment($clone);
-            }
-        }
-    }
-}

src/Entity/Base/CompanyTrait.php

@@ -1,236 +0,0 @@
-<?php
-/**
- * This file is part of Part-DB (https://github.com/Part-DB/Part-DB-symfony).
- *
- * Copyright (C) 2019 - 2022 Jan Böhmer (https://github.com/jbtronics)
- *
- * This program is free software: you can redistribute it and/or modify
- * it under the terms of the GNU Affero General Public License as published
- * by the Free Software Foundation, either version 3 of the License, or
- * (at your option) any later version.
- *
- * This program is distributed in the hope that it will be useful,
- * but WITHOUT ANY WARRANTY; without even the implied warranty of
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
- * GNU Affero General Public License for more details.
- *
- * You should have received a copy of the GNU Affero General Public License
- * along with this program.  If not, see <https://www.gnu.org/licenses/>.
- */
-
-declare(strict_types=1);
-
-namespace App\Entity\Base;
-
-use Doctrine\DBAL\Types\Types;
-use Doctrine\ORM\Mapping as ORM;
-use Symfony\Component\Serializer\Annotation\Groups;
-use Symfony\Component\Validator\Constraints as Assert;
-use function is_string;
-
-/**
- * Trait for company-specific fields like address, phone, email, etc.
- */
-trait CompanyTrait
-{
-    /**
-     * @var string The address of the company
-     */
-    #[Groups(['full', 'company:read', 'company:write', 'import', 'extended'])]
-    #[ORM\Column(type: Types::STRING)]
-    #[Assert\Length(max: 255)]
-    protected string $address = '';
-
-    /**
-     * @var string The phone number of the company
-     */
-    #[Groups(['full', 'company:read', 'company:write', 'import', 'extended'])]
-    #[ORM\Column(type: Types::STRING)]
-    #[Assert\Length(max: 255)]
-    protected string $phone_number = '';
-
-    /**
-     * @var string The fax number of the company
-     */
-    #[Groups(['full', 'company:read', 'company:write', 'import', 'extended'])]
-    #[ORM\Column(type: Types::STRING)]
-    #[Assert\Length(max: 255)]
-    protected string $fax_number = '';
-
-    /**
-     * @var string The email address of the company
-     */
-    #[Assert\Email]
-    #[Groups(['full', 'company:read', 'company:write', 'import', 'extended'])]
-    #[ORM\Column(type: Types::STRING)]
-    #[Assert\Length(max: 255)]
-    protected string $email_address = '';
-
-    /**
-     * @var string The website of the company
-     */
-    #[Assert\Url(requireTld: false)]
-    #[Groups(['full', 'company:read', 'company:write', 'import', 'extended'])]
-    #[ORM\Column(type: Types::STRING, length: 2048)]
-    #[Assert\Length(max: 2048)]
-    protected string $website = '';
-
-    /**
-     * @var string The link to the website of an article. Use %PARTNUMBER% as placeholder for the part number.
-     */
-    #[ORM\Column(type: Types::STRING, length: 2048)]
-    #[Assert\Length(max: 2048)]
-    #[Groups(['full', 'company:read', 'company:write', 'import', 'extended'])]
-    protected string $auto_product_url = '';
-
-    /**
-     * Get the address.
-     *
-     * @return string the address of the company (with "\n" as line break)
-     */
-    public function getAddress(): string
-    {
-        return $this->address;
-    }
-
-    /**
-     * Set the address.
-     *
-     * @param string $new_address the new address (with "\n" as line break)
-     *
-     * @return $this
-     */
-    public function setAddress(string $new_address): self
-    {
-        $this->address = $new_address;
-
-        return $this;
-    }
-
-    /**
-     * Get the phone number.
-     *
-     * @return string the phone number of the company
-     */
-    public function getPhoneNumber(): string
-    {
-        return $this->phone_number;
-    }
-
-    /**
-     * Set the phone number.
-     *
-     * @param string $new_phone_number the new phone number
-     *
-     * @return $this
-     */
-    public function setPhoneNumber(string $new_phone_number): self
-    {
-        $this->phone_number = $new_phone_number;
-
-        return $this;
-    }
-
-    /**
-     * Get the fax number.
-     *
-     * @return string the fax number of the company
-     */
-    public function getFaxNumber(): string
-    {
-        return $this->fax_number;
-    }
-
-    /**
-     * Set the fax number.
-     *
-     * @param string $new_fax_number the new fax number
-     *
-     * @return $this
-     */
-    public function setFaxNumber(string $new_fax_number): self
-    {
-        $this->fax_number = $new_fax_number;
-
-        return $this;
-    }
-
-    /**
-     * Get the e-mail address.
-     *
-     * @return string the e-mail address of the company
-     */
-    public function getEmailAddress(): string
-    {
-        return $this->email_address;
-    }
-
-    /**
-     * Set the e-mail address.
-     *
-     * @param string $new_email_address the new e-mail address
-     *
-     * @return $this
-     */
-    public function setEmailAddress(string $new_email_address): self
-    {
-        $this->email_address = $new_email_address;
-
-        return $this;
-    }
-
-    /**
-     * Get the website.
-     *
-     * @return string the website of the company
-     */
-    public function getWebsite(): string
-    {
-        return $this->website;
-    }
-
-    /**
-     * Set the website.
-     *
-     * @param string $new_website the new website
-     *
-     * @return $this
-     */
-    public function setWebsite(string $new_website): self
-    {
-        $this->website = $new_website;
-
-        return $this;
-    }
-
-    /**
-     * Get the link to the website of an article.
-     *
-     * @param  string|null  $partnr * NULL for returning the URL with a placeholder for the part number
-     *                       * or the part number for returning the direct URL to the article
-     *
-     * @return string the link to the article
-     */
-    public function getAutoProductUrl(?string $partnr = null): string
-    {
-        if (is_string($partnr)) {
-            return str_replace('%PARTNUMBER%', $partnr, $this->auto_product_url);
-        }
-
-        return $this->auto_product_url;
-    }
-
-    /**
-     * Set the link to the website of an article.
-     *
-     * @param string $new_url the new URL with the placeholder %PARTNUMBER% for the part number
-     *
-     * @return $this
-     */
-    public function setAutoProductUrl(string $new_url): self
-    {
-        $this->auto_product_url = $new_url;
-
-        return $this;
-    }
-}

src/Entity/Base/DBElementTrait.php

@@ -1,67 +0,0 @@
-<?php
-/**
- * This file is part of Part-DB (https://github.com/Part-DB/Part-DB-symfony).
- *
- * Copyright (C) 2019 - 2022 Jan Böhmer (https://github.com/jbtronics)
- *
- * This program is free software: you can redistribute it and/or modify
- * it under the terms of the GNU Affero General Public License as published
- * by the Free Software Foundation, either version 3 of the License, or
- * (at your option) any later version.
- *
- * This program is distributed in the hope that it will be useful,
- * but WITHOUT ANY WARRANTY; without even the implied warranty of
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
- * GNU Affero General Public License for more details.
- *
- * You should have received a copy of the GNU Affero General Public License
- * along with this program.  If not, see <https://www.gnu.org/licenses/>.
- */
-
-declare(strict_types=1);
-
-namespace App\Entity\Base;
-
-use Doctrine\DBAL\Types\Types;
-use Doctrine\ORM\Mapping as ORM;
-use Symfony\Component\Serializer\Annotation\Groups;
-
-/**
- * Trait providing basic database element functionality with an ID.
- */
-trait DBElementTrait
-{
-    /**
-     * @var int|null The Identification number for this element. This value is unique for the element in this table.
-     * Null if the element is not saved to DB yet.
-     */
-    #[Groups(['full', 'api:basic:read'])]
-    #[ORM\Column(type: Types::INTEGER)]
-    #[ORM\Id]
-    #[ORM\GeneratedValue]
-    protected ?int $id = null;
-
-    /**
-     * Get the ID. The ID can be zero, or even negative (for virtual elements). If an element is virtual, can be
-     * checked with isVirtualElement().
-     *
-     * Returns null, if the element is not saved to the DB yet.
-     *
-     * @return int|null the ID of this element
-     */
-    public function getID(): ?int
-    {
-        return $this->id;
-    }
-
-    /**
-     * Clone helper for DB element - resets ID on clone.
-     */
-    protected function cloneDBElement(): void
-    {
-        if ($this->id) {
-            //Set ID to null, so that a new entry is created
-            $this->id = null;
-        }
-    }
-}

src/Entity/Base/NamedElementTrait.php

@@ -1,73 +0,0 @@
-<?php
-/*
- * This file is part of Part-DB (https://github.com/Part-DB/Part-DB-symfony).
- *
- *  Copyright (C) 2019 - 2022 Jan Böhmer (https://github.com/jbtronics)
- *
- *  This program is free software: you can redistribute it and/or modify
- *  it under the terms of the GNU Affero General Public License as published
- *  by the Free Software Foundation, either version 3 of the License, or
- *  (at your option) any later version.
- *
- *  This program is distributed in the hope that it will be useful,
- *  but WITHOUT ANY WARRANTY; without even the implied warranty of
- *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
- *  GNU Affero General Public License for more details.
- *
- *  You should have received a copy of the GNU Affero General Public License
- *  along with this program.  If not, see <https://www.gnu.org/licenses/>.
- */
-
-declare(strict_types=1);
-
-namespace App\Entity\Base;
-
-use Doctrine\DBAL\Types\Types;
-use Doctrine\ORM\Mapping as ORM;
-use Symfony\Component\Serializer\Annotation\Groups;
-use Symfony\Component\Validator\Constraints as Assert;
-
-/**
- * Trait providing named element functionality.
- */
-trait NamedElementTrait
-{
-    /**
-     * @var string The name of this element
-     */
-    #[Assert\NotBlank]
-    #[Groups(['simple', 'extended', 'full', 'import', 'api:basic:read', 'api:basic:write'])]
-    #[ORM\Column(type: Types::STRING)]
-    #[Assert\Length(max: 255)]
-    protected string $name = '';
-
-    /**
-     * Get the name of this element.
-     *
-     * @return string the name of this element
-     */
-    public function getName(): string
-    {
-        return $this->name;
-    }
-
-    /**
-     * Change the name of this element.
-     *
-     * @param string $new_name the new name
-     */
-    public function setName(string $new_name): self
-    {
-        $this->name = $new_name;
-
-        return $this;
-    }
-
-    /**
-     * String representation returns the name.
-     */
-    public function __toString(): string
-    {
-        return $this->getName();
-    }
-}

src/Entity/Base/StructuralElementTrait.php

@@ -1,381 +0,0 @@
-<?php
-/**
- * This file is part of Part-DB (https://github.com/Part-DB/Part-DB-symfony).
- *
- * Copyright (C) 2019 - 2022 Jan Böhmer (https://github.com/jbtronics)
- *
- * This program is free software: you can redistribute it and/or modify
- * it under the terms of the GNU Affero General Public License as published
- * by the Free Software Foundation, either version 3 of the License, or
- * (at your option) any later version.
- *
- * This program is distributed in the hope that it will be useful,
- * but WITHOUT ANY WARRANTY; without even the implied warranty of
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
- * GNU Affero General Public License for more details.
- *
- * You should have received a copy of the GNU Affero General Public License
- * along with this program.  If not, see <https://www.gnu.org/licenses/>.
- */
-
-declare(strict_types=1);
-
-namespace App\Entity\Base;
-
-use App\Validator\Constraints\NoneOfItsChildren;
-use Doctrine\Common\Collections\ArrayCollection;
-use Doctrine\Common\Collections\Collection;
-use Doctrine\DBAL\Types\Types;
-use Doctrine\ORM\Mapping as ORM;
-use InvalidArgumentException;
-use Symfony\Component\Serializer\Annotation\Groups;
-use Symfony\Component\Serializer\Annotation\SerializedName;
-use function count;
-
-/**
- * Trait for structural/hierarchical elements forming a tree structure.
- *
- * Requirements:
- * - Class using this trait must have getName() method (e.g., via NamedElementTrait)
- * - Class using this trait must have getID() method (e.g., via DBElementTrait)
- * - Class should implement StructuralElementInterface
- */
-trait StructuralElementTrait
-{
-    /**
-     * This is a not standard character, so build a const, so a dev can easily use it.
-     */
-    final public const PATH_DELIMITER_ARROW = ' → ';
-
-    /**
-     * @var string The comment info for this element as markdown
-     */
-    #[Groups(['full', 'import'])]
-    #[ORM\Column(type: Types::TEXT)]
-    protected string $comment = '';
-
-    /**
-     * @var bool If this property is set, this element can not be selected for part properties.
-     *           Useful if this element should be used only for grouping, sorting.
-     */
-    #[Groups(['full', 'import'])]
-    #[ORM\Column(type: Types::BOOLEAN)]
-    protected bool $not_selectable = false;
-
-    /**
-     * @var int
-     */
-    protected int $level = 0;
-
-    /**
-     * We can not define the mapping here, or we will get an exception. Unfortunately we have to do the mapping in the
-     * subclasses.
-     *
-     * @var Collection<int, static>
-     */
-    #[Groups(['include_children'])]
-    protected Collection $children;
-
-    /**
-     * @var static|null
-     */
-    #[Groups(['include_parents', 'import'])]
-    #[NoneOfItsChildren]
-    protected ?self $parent = null;
-
-    /** @var string[] all names of all parent elements as an array of strings,
-     *  the last array element is the name of the element itself
-     */
-    private array $full_path_strings = [];
-
-    /**
-     * Alternative names (semicolon-separated) for this element, which can be used for searching (especially for info provider system)
-     */
-    #[ORM\Column(type: Types::TEXT, nullable: true, options: ['default' => null])]
-    private ?string $alternative_names = '';
-
-    /**
-     * Initialize structural element collections.
-     */
-    protected function initializeStructuralElement(): void
-    {
-        $this->children = new ArrayCollection();
-    }
-
-    /**
-     * Check if this element is a child of another element (recursive).
-     *
-     * @param self $another_element the object to compare
-     *                                                     IMPORTANT: both objects to compare must be from the same class (for example two "Device" objects)!
-     *
-     * @return bool true, if this element is child of $another_element
-     *
-     * @throws InvalidArgumentException if there was an error
-     */
-    public function isChildOf(self $another_element): bool
-    {
-        $class_name = static::class;
-
-        //Check if both elements compared, are from the same type
-        // (we have to check inheritance, or we get exceptions when using doctrine entities (they have a proxy type):
-        if (!$another_element instanceof $class_name && !is_a($this, $another_element::class)) {
-            throw new InvalidArgumentException('isChildOf() only works for objects of the same type!');
-        }
-
-        if (!$this->getParent() instanceof self) { // this is the root node
-            return false;
-        }
-
-        //If the parent element is equal to the element we want to compare, return true
-        if ($this->getParent()->getID() === null) {
-            //If the IDs are not yet defined, we have to compare the objects itself
-            if ($this->getParent() === $another_element) {
-                return true;
-            }
-        } elseif ($this->getParent()->getID() === $another_element->getID()) {
-            return true;
-        }
-
-        //Otherwise, check recursively
-        return $this->parent->isChildOf($another_element);
-    }
-
-    /**
-     * Checks if this element is a root element (has no parent).
-     *
-     * @return bool true if this element is a root element
-     */
-    public function isRoot(): bool
-    {
-        return $this->parent === null;
-    }
-
-    /**
-     * Get the parent of this element.
-     *
-     * @return static|null The parent element. Null if this element does not have a parent.
-     */
-    public function getParent(): ?self
-    {
-        return $this->parent;
-    }
-
-    /**
-     *  Get the comment of the element as markdown encoded string.
-     *
-     * @return string|null the comment
-     */
-    public function getComment(): ?string
-    {
-        return $this->comment;
-    }
-
-    /**
-     *  Set the comment.
-     *
-     * @param  string  $new_comment  the new comment
-     *
-     * @return $this
-     */
-    public function setComment(string $new_comment): self
-    {
-        $this->comment = $new_comment;
-
-        return $this;
-    }
-
-    /**
-     * Get the level.
-     *
-     * The level of the root node is -1.
-     *
-     * @return int the level of this element (zero means the topmost element
-     *             [a sub element of the root node])
-     */
-    public function getLevel(): int
-    {
-        /*
-         * Only check for nodes that have a parent. In the other cases zero is correct.
-         */
-        if (0 === $this->level && $this->parent instanceof self) {
-            $element = $this->parent;
-            while ($element instanceof self) {
-                $element = $element->parent;
-                ++$this->level;
-            }
-        }
-
-        return $this->level;
-    }
-
-    /**
-     * Get the full path.
-     *
-     * @param string $delimiter the delimiter of the returned string
-     *
-     * @return string the full path (incl. the name of this element), delimited by $delimiter
-     */
-    #[Groups(['api:basic:read'])]
-    #[SerializedName('full_path')]
-    public function getFullPath(string $delimiter = self::PATH_DELIMITER_ARROW): string
-    {
-        if ($this->full_path_strings === []) {
-            $this->full_path_strings = [];
-            $this->full_path_strings[] = $this->getName();
-            $element = $this;
-
-            $overflow = 20; //We only allow 20 levels depth
-
-            while ($element->parent instanceof self && $overflow >= 0) {
-                $element = $element->parent;
-                $this->full_path_strings[] = $element->getName();
-                //Decrement to prevent mem overflow.
-                --$overflow;
-            }
-
-            $this->full_path_strings = array_reverse($this->full_path_strings);
-        }
-
-        return implode($delimiter, $this->full_path_strings);
-    }
-
-    /**
-     * Gets the path to this element (including the element itself).
-     *
-     * @return self[] An array with all (recursively) parent elements (including this one),
-     *                ordered from the lowest levels (root node) first to the highest level (the element itself)
-     */
-    public function getPathArray(): array
-    {
-        $tmp = [];
-        $tmp[] = $this;
-
-        //We only allow 20 levels depth
-        while (!end($tmp)->isRoot() && count($tmp) < 20) {
-            $tmp[] = end($tmp)->parent;
-        }
-
-        return array_reverse($tmp);
-    }
-
-    /**
-     * Get all sub elements of this element.
-     *
-     * @return Collection<static>|iterable all subelements as an array of objects (sorted by their full path)
-     */
-    public function getSubelements(): iterable
-    {
-        //If the parent is equal to this object, we would get an endless loop, so just return an empty array
-        //This is just a workaround, as validator should prevent this behaviour, before it gets written to the database
-        if ($this->parent === $this) {
-            return new ArrayCollection();
-        }
-
-        return $this->children ?? new ArrayCollection();
-    }
-
-    /**
-     * @see getSubelements()
-     * @return Collection<static>|iterable
-     */
-    public function getChildren(): iterable
-    {
-        return $this->getSubelements();
-    }
-
-    /**
-     * Sets the new parent object.
-     *
-     * @param  static|null  $new_parent  The new parent object
-     * @return $this
-     */
-    public function setParent(?self $new_parent): self
-    {
-        $this->parent = $new_parent;
-
-        //Add this element as child to the new parent
-        if ($new_parent instanceof self) {
-            $new_parent->getChildren()->add($this);
-        }
-
-        return $this;
-    }
-
-    /**
-     * Adds the given element as child to this element.
-     * @param  static  $child
-     * @return $this
-     */
-    public function addChild(self $child): self
-    {
-        $this->children->add($child);
-        //Children get this element as parent
-        $child->setParent($this);
-        return $this;
-    }
-
-    /**
-     * Removes the given element as child from this element.
-     * @param  static  $child
-     * @return $this
-     */
-    public function removeChild(self $child): self
-    {
-        $this->children->removeElement($child);
-        //Children has no parent anymore
-        $child->setParent(null);
-        return $this;
-    }
-
-    public function isNotSelectable(): bool
-    {
-        return $this->not_selectable;
-    }
-
-    /**
-     * @return $this
-     */
-    public function setNotSelectable(bool $not_selectable): self
-    {
-        $this->not_selectable = $not_selectable;
-
-        return $this;
-    }
-
-    public function clearChildren(): self
-    {
-        $this->children = new ArrayCollection();
-
-        return $this;
-    }
-
-    /**
-     * Returns a comma separated list of alternative names.
-     * @return string|null
-     */
-    public function getAlternativeNames(): ?string
-    {
-        if ($this->alternative_names === null) {
-            return null;
-        }
-
-        //Remove trailing comma
-        return rtrim($this->alternative_names, ',');
-    }
-
-    /**
-     * Sets a comma separated list of alternative names.
-     * @return $this
-     */
-    public function setAlternativeNames(?string $new_value): self
-    {
-        //Add a trailing comma, if not already there (makes it easier to find in the database)
-        if (is_string($new_value) && !str_ends_with($new_value, ',')) {
-            $new_value .= ',';
-        }
-
-        $this->alternative_names = $new_value;
-
-        return $this;
-    }
-}

src/Entity/Contracts/CompanyInterface.php

@@ -1,57 +0,0 @@
-<?php
-/*
- * This file is part of Part-DB (https://github.com/Part-DB/Part-DB-symfony).
- *
- *  Copyright (C) 2019 - 2022 Jan Böhmer (https://github.com/jbtronics)
- *
- *  This program is free software: you can redistribute it and/or modify
- *  it under the terms of the GNU Affero General Public License as published
- *  by the Free Software Foundation, either version 3 of the License, or
- *  (at your option) any later version.
- *
- *  This program is distributed in the hope that it will be useful,
- *  but WITHOUT ANY WARRANTY; without even the implied warranty of
- *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
- *  GNU Affero General Public License for more details.
- *
- *  You should have received a copy of the GNU Affero General Public License
- *  along with this program.  If not, see <https://www.gnu.org/licenses/>.
- */
-
-declare(strict_types=1);
-
-namespace App\Entity\Contracts;
-
-/**
- * Interface for company entities (suppliers, manufacturers).
- */
-interface CompanyInterface
-{
-    /**
-     * Get the address.
-     *
-     * @return string the address of the company (with "\n" as line break)
-     */
-    public function getAddress(): string;
-
-    /**
-     * Get the phone number.
-     *
-     * @return string the phone number of the company
-     */
-    public function getPhoneNumber(): string;
-
-    /**
-     * Get the e-mail address.
-     *
-     * @return string the e-mail address of the company
-     */
-    public function getEmailAddress(): string;
-
-    /**
-     * Get the website.
-     *
-     * @return string the website of the company
-     */
-    public function getWebsite(): string;
-}

src/Entity/Contracts/DBElementInterface.php

@@ -1,38 +0,0 @@
-<?php
-/*
- * This file is part of Part-DB (https://github.com/Part-DB/Part-DB-symfony).
- *
- *  Copyright (C) 2019 - 2022 Jan Böhmer (https://github.com/jbtronics)
- *
- *  This program is free software: you can redistribute it and/or modify
- *  it under the terms of the GNU Affero General Public License as published
- *  by the Free Software Foundation, either version 3 of the License, or
- *  (at your option) any later version.
- *
- *  This program is distributed in the hope that it will be useful,
- *  but WITHOUT ANY WARRANTY; without even the implied warranty of
- *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
- *  GNU Affero General Public License for more details.
- *
- *  You should have received a copy of the GNU Affero General Public License
- *  along with this program.  If not, see <https://www.gnu.org/licenses/>.
- */
-
-declare(strict_types=1);
-
-namespace App\Entity\Contracts;
-
-/**
- * Interface for entities that have a database ID.
- */
-interface DBElementInterface
-{
-    /**
-     * Get the ID. The ID can be zero, or even negative (for virtual elements).
-     *
-     * Returns null, if the element is not saved to the DB yet.
-     *
-     * @return int|null the ID of this element
-     */
-    public function getID(): ?int;
-}

src/Entity/Contracts/HasParametersInterface.php

@@ -1,38 +0,0 @@
-<?php
-/*
- * This file is part of Part-DB (https://github.com/Part-DB/Part-DB-symfony).
- *
- *  Copyright (C) 2019 - 2022 Jan Böhmer (https://github.com/jbtronics)
- *
- *  This program is free software: you can redistribute it and/or modify
- *  it under the terms of the GNU Affero General Public License as published
- *  by the Free Software Foundation, either version 3 of the License, or
- *  (at your option) any later version.
- *
- *  This program is distributed in the hope that it will be useful,
- *  but WITHOUT ANY WARRANTY; without even the implied warranty of
- *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
- *  GNU Affero General Public License for more details.
- *
- *  You should have received a copy of the GNU Affero General Public License
- *  along with this program.  If not, see <https://www.gnu.org/licenses/>.
- */
-
-declare(strict_types=1);
-
-namespace App\Entity\Contracts;
-
-use Doctrine\Common\Collections\Collection;
-
-/**
- * Interface for entities that have parameters.
- */
-interface HasParametersInterface
-{
-    /**
-     * Return all associated parameters.
-     *
-     * @return Collection
-     */
-    public function getParameters(): Collection;
-}

src/Entity/Contracts/StructuralElementInterface.php

@@ -1,70 +0,0 @@
-<?php
-/*
- * This file is part of Part-DB (https://github.com/Part-DB/Part-DB-symfony).
- *
- *  Copyright (C) 2019 - 2022 Jan Böhmer (https://github.com/jbtronics)
- *
- *  This program is free software: you can redistribute it and/or modify
- *  it under the terms of the GNU Affero General Public License as published
- *  by the Free Software Foundation, either version 3 of the License, or
- *  (at your option) any later version.
- *
- *  This program is distributed in the hope that it will be useful,
- *  but WITHOUT ANY WARRANTY; without even the implied warranty of
- *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
- *  GNU Affero General Public License for more details.
- *
- *  You should have received a copy of the GNU Affero General Public License
- *  along with this program.  If not, see <https://www.gnu.org/licenses/>.
- */
-
-declare(strict_types=1);
-
-namespace App\Entity\Contracts;
-
-use Doctrine\Common\Collections\Collection;
-
-/**
- * Interface for structural elements that form a tree hierarchy.
- */
-interface StructuralElementInterface
-{
-    /**
-     * Get the parent of this element.
-     *
-     * @return static|null The parent element. Null if this element does not have a parent.
-     */
-    public function getParent(): ?self;
-
-    /**
-     * Get all sub elements of this element.
-     *
-     * @return Collection<static>|iterable all subelements
-     */
-    public function getChildren(): iterable;
-
-    /**
-     * Checks if this element is a root element (has no parent).
-     *
-     * @return bool true if this element is a root element
-     */
-    public function isRoot(): bool;
-
-    /**
-     * Get the full path.
-     *
-     * @param string $delimiter the delimiter of the returned string
-     *
-     * @return string the full path (incl. the name of this element), delimited by $delimiter
-     */
-    public function getFullPath(string $delimiter = ' → '): string;
-
-    /**
-     * Get the level.
-     *
-     * The level of the root node is -1.
-     *
-     * @return int the level of this element (zero means the topmost element)
-     */
-    public function getLevel(): int;
-}

src/Entity/Parts/Category.php

@@ -39,44 +39,28 @@ use ApiPlatform\OpenApi\Model\Operation;
 use ApiPlatform\Serializer\Filter\PropertyFilter;
 use App\ApiPlatform\Filter\LikeFilter;
 use App\Entity\Attachments\Attachment;
-use App\Entity\Base\AttachmentsTrait;
-use App\Entity\Base\DBElementTrait;
-use App\Entity\Base\MasterAttachmentTrait;
-use App\Entity\Base\NamedElementTrait;
-use App\Entity\Base\StructuralElementTrait;
-use App\Entity\Base\TimestampTrait;
-use App\Entity\Contracts\DBElementInterface;
-use App\Entity\Contracts\HasAttachmentsInterface;
-use App\Entity\Contracts\HasMasterAttachmentInterface;
-use App\Entity\Contracts\HasParametersInterface;
-use App\Entity\Contracts\NamedElementInterface;
-use App\Entity\Contracts\StructuralElementInterface;
-use App\Entity\Contracts\TimeStampableInterface;
 use App\Entity\EDA\EDACategoryInfo;
-use App\Entity\Parameters\ParametersTrait;
-use App\EntityListeners\TreeCacheInvalidationListener;
 use App\Repository\Parts\CategoryRepository;
-use App\Validator\Constraints\UniqueObjectCollection;
 use Doctrine\DBAL\Types\Types;
 use Doctrine\Common\Collections\ArrayCollection;
 use App\Entity\Attachments\CategoryAttachment;
+use App\Entity\Base\AbstractPartsContainingDBElement;
+use App\Entity\Base\AbstractStructuralDBElement;
 use App\Entity\Parameters\CategoryParameter;
 use Doctrine\Common\Collections\Collection;
 use Doctrine\ORM\Mapping as ORM;
-use Symfony\Bridge\Doctrine\Validator\Constraints\UniqueEntity;
 use Symfony\Component\Serializer\Annotation\Groups;
 use Symfony\Component\Validator\Constraints as Assert;
 
 /**
  * This entity describes a category, a part can belong to, which is used to group parts by their function.
+ *
+ * @extends AbstractPartsContainingDBElement<CategoryAttachment, CategoryParameter>
  */
 #[ORM\Entity(repositoryClass: CategoryRepository::class)]
 #[ORM\Table(name: '`categories`')]
 #[ORM\Index(columns: ['name'], name: 'category_idx_name')]
 #[ORM\Index(columns: ['parent_id', 'name'], name: 'category_idx_parent_name')]
-#[ORM\HasLifecycleCallbacks]
-#[ORM\EntityListeners([TreeCacheInvalidationListener::class])]
-#[UniqueEntity(fields: ['name', 'parent'], message: 'structural.entity.unique_name', ignoreNull: false)]
 #[ApiResource(
     operations: [
         new Get(security: 'is_granted("read", object)'),
@@ -105,16 +89,8 @@ use Symfony\Component\Validator\Constraints as Assert;
 #[ApiFilter(LikeFilter::class, properties: ["name", "comment"])]
 #[ApiFilter(DateFilter::class, strategy: DateFilterInterface::EXCLUDE_NULL)]
 #[ApiFilter(OrderFilter::class, properties: ['name', 'id', 'addedDate', 'lastModified'])]
-class Category implements DBElementInterface, NamedElementInterface, TimeStampableInterface, HasAttachmentsInterface, HasMasterAttachmentInterface, StructuralElementInterface, HasParametersInterface, \Stringable, \JsonSerializable
+class Category extends AbstractPartsContainingDBElement
 {
-    use DBElementTrait;
-    use NamedElementTrait;
-    use TimestampTrait;
-    use AttachmentsTrait;
-    use MasterAttachmentTrait;
-    use StructuralElementTrait;
-    use ParametersTrait;
-
     #[ORM\OneToMany(mappedBy: 'parent', targetEntity: self::class)]
     #[ORM\OrderBy(['name' => Criteria::ASC])]
     protected Collection $children;
@@ -123,7 +99,7 @@ class Category implements DBElementInterface, NamedElementInterface, TimeStampab
     #[ORM\JoinColumn(name: 'parent_id')]
     #[Groups(['category:read', 'category:write'])]
     #[ApiProperty(readableLink: false, writableLink: false)]
-    protected ?self $parent = null;
+    protected ?AbstractStructuralDBElement $parent = null;
 
     #[Groups(['category:read', 'category:write'])]
     protected string $comment = '';
@@ -208,7 +184,6 @@ class Category implements DBElementInterface, NamedElementInterface, TimeStampab
     /** @var Collection<int, CategoryParameter>
      */
     #[Assert\Valid]
-    #[UniqueObjectCollection(fields: ['name', 'group', 'element'])]
     #[Groups(['full', 'category:read', 'category:write'])]
     #[ORM\OneToMany(mappedBy: 'element', targetEntity: CategoryParameter::class, cascade: ['persist', 'remove'], orphanRemoval: true)]
     #[ORM\OrderBy(['group' => Criteria::ASC, 'name' => 'ASC'])]
@@ -226,37 +201,13 @@ class Category implements DBElementInterface, NamedElementInterface, TimeStampab
 
     public function __construct()
     {
-        $this->initializeAttachments();
-        $this->initializeStructuralElement();
+        parent::__construct();
         $this->children = new ArrayCollection();
         $this->attachments = new ArrayCollection();
         $this->parameters = new ArrayCollection();
         $this->eda_info = new EDACategoryInfo();
     }
 
-    public function __clone()
-    {
-        if ($this->id) {
-            $this->cloneDBElement();
-            $this->cloneAttachments();
-            
-            // We create a new object, so give it a new creation date
-            $this->addedDate = null;
-            
-            //Deep clone parameters
-            $parameters = $this->parameters;
-            $this->parameters = new ArrayCollection();
-            foreach ($parameters as $parameter) {
-                $this->addParameter(clone $parameter);
-            }
-        }
-    }
-
-    public function jsonSerialize(): array
-    {
-        return ['@id' => $this->getID()];
-    }
-
     public function getPartnameHint(): string
     {
         return $this->partname_hint;

src/Entity/Parts/Footprint.php

@@ -39,43 +39,27 @@ use ApiPlatform\OpenApi\Model\Operation;
 use ApiPlatform\Serializer\Filter\PropertyFilter;
 use App\ApiPlatform\Filter\LikeFilter;
 use App\Entity\Attachments\Attachment;
-use App\Entity\Base\AttachmentsTrait;
-use App\Entity\Base\DBElementTrait;
-use App\Entity\Base\MasterAttachmentTrait;
-use App\Entity\Base\NamedElementTrait;
-use App\Entity\Base\StructuralElementTrait;
-use App\Entity\Base\TimestampTrait;
-use App\Entity\Contracts\DBElementInterface;
-use App\Entity\Contracts\HasAttachmentsInterface;
-use App\Entity\Contracts\HasMasterAttachmentInterface;
-use App\Entity\Contracts\HasParametersInterface;
-use App\Entity\Contracts\NamedElementInterface;
-use App\Entity\Contracts\StructuralElementInterface;
-use App\Entity\Contracts\TimeStampableInterface;
 use App\Entity\EDA\EDAFootprintInfo;
-use App\Entity\Parameters\ParametersTrait;
-use App\EntityListeners\TreeCacheInvalidationListener;
 use App\Repository\Parts\FootprintRepository;
-use App\Validator\Constraints\UniqueObjectCollection;
+use App\Entity\Base\AbstractStructuralDBElement;
 use Doctrine\Common\Collections\ArrayCollection;
 use App\Entity\Attachments\FootprintAttachment;
+use App\Entity\Base\AbstractPartsContainingDBElement;
 use App\Entity\Parameters\FootprintParameter;
 use Doctrine\Common\Collections\Collection;
 use Doctrine\ORM\Mapping as ORM;
-use Symfony\Bridge\Doctrine\Validator\Constraints\UniqueEntity;
 use Symfony\Component\Serializer\Annotation\Groups;
 use Symfony\Component\Validator\Constraints as Assert;
 
 /**
  * This entity represents a footprint of a part (its physical dimensions and shape).
+ *
+ * @extends AbstractPartsContainingDBElement<FootprintAttachment, FootprintParameter>
  */
 #[ORM\Entity(repositoryClass: FootprintRepository::class)]
 #[ORM\Table('`footprints`')]
 #[ORM\Index(columns: ['name'], name: 'footprint_idx_name')]
 #[ORM\Index(columns: ['parent_id', 'name'], name: 'footprint_idx_parent_name')]
-#[ORM\HasLifecycleCallbacks]
-#[ORM\EntityListeners([TreeCacheInvalidationListener::class])]
-#[UniqueEntity(fields: ['name', 'parent'], message: 'structural.entity.unique_name', ignoreNull: false)]
 #[ApiResource(
     operations: [
         new Get(security: 'is_granted("read", object)'),
@@ -104,21 +88,13 @@ use Symfony\Component\Validator\Constraints as Assert;
 #[ApiFilter(LikeFilter::class, properties: ["name", "comment"])]
 #[ApiFilter(DateFilter::class, strategy: DateFilterInterface::EXCLUDE_NULL)]
 #[ApiFilter(OrderFilter::class, properties: ['name', 'id', 'addedDate', 'lastModified'])]
-class Footprint implements DBElementInterface, NamedElementInterface, TimeStampableInterface, HasAttachmentsInterface, HasMasterAttachmentInterface, StructuralElementInterface, HasParametersInterface, \Stringable, \JsonSerializable
+class Footprint extends AbstractPartsContainingDBElement
 {
-    use DBElementTrait;
-    use NamedElementTrait;
-    use TimestampTrait;
-    use AttachmentsTrait;
-    use MasterAttachmentTrait;
-    use StructuralElementTrait;
-    use ParametersTrait;
-
     #[ORM\ManyToOne(targetEntity: self::class, inversedBy: 'children')]
     #[ORM\JoinColumn(name: 'parent_id')]
     #[Groups(['footprint:read', 'footprint:write'])]
     #[ApiProperty(readableLink: false, writableLink: false)]
-    protected ?self $parent = null;
+    protected ?AbstractStructuralDBElement $parent = null;
 
     #[ORM\OneToMany(mappedBy: 'parent', targetEntity: self::class)]
     #[ORM\OrderBy(['name' => Criteria::ASC])]
@@ -152,7 +128,6 @@ class Footprint implements DBElementInterface, NamedElementInterface, TimeStampa
     /** @var Collection<int, FootprintParameter>
      */
     #[Assert\Valid]
-    #[UniqueObjectCollection(fields: ['name', 'group', 'element'])]
     #[ORM\OneToMany(mappedBy: 'element', targetEntity: FootprintParameter::class, cascade: ['persist', 'remove'], orphanRemoval: true)]
     #[ORM\OrderBy(['group' => Criteria::ASC, 'name' => 'ASC'])]
     #[Groups(['footprint:read', 'footprint:write'])]
@@ -170,37 +145,13 @@ class Footprint implements DBElementInterface, NamedElementInterface, TimeStampa
 
     public function __construct()
     {
-        $this->initializeAttachments();
-        $this->initializeStructuralElement();
+        parent::__construct();
         $this->children = new ArrayCollection();
         $this->attachments = new ArrayCollection();
         $this->parameters = new ArrayCollection();
         $this->eda_info = new EDAFootprintInfo();
     }
 
-    public function __clone()
-    {
-        if ($this->id) {
-            $this->cloneDBElement();
-            $this->cloneAttachments();
-            
-            // We create a new object, so give it a new creation date
-            $this->addedDate = null;
-            
-            //Deep clone parameters
-            $parameters = $this->parameters;
-            $this->parameters = new ArrayCollection();
-            foreach ($parameters as $parameter) {
-                $this->addParameter(clone $parameter);
-            }
-        }
-    }
-
-    public function jsonSerialize(): array
-    {
-        return ['@id' => $this->getID()];
-    }
-
     /****************************************
      * Getters
      ****************************************/

src/Entity/Parts/Manufacturer.php

@@ -39,44 +39,26 @@ use ApiPlatform\OpenApi\Model\Operation;
 use ApiPlatform\Serializer\Filter\PropertyFilter;
 use App\ApiPlatform\Filter\LikeFilter;
 use App\Entity\Attachments\Attachment;
-use App\Entity\Base\AttachmentsTrait;
-use App\Entity\Base\CompanyTrait;
-use App\Entity\Base\DBElementTrait;
-use App\Entity\Base\MasterAttachmentTrait;
-use App\Entity\Base\NamedElementTrait;
-use App\Entity\Base\StructuralElementTrait;
-use App\Entity\Base\TimestampTrait;
-use App\Entity\Contracts\CompanyInterface;
-use App\Entity\Contracts\DBElementInterface;
-use App\Entity\Contracts\HasAttachmentsInterface;
-use App\Entity\Contracts\HasMasterAttachmentInterface;
-use App\Entity\Contracts\HasParametersInterface;
-use App\Entity\Contracts\NamedElementInterface;
-use App\Entity\Contracts\StructuralElementInterface;
-use App\Entity\Contracts\TimeStampableInterface;
-use App\Entity\Parameters\ParametersTrait;
-use App\EntityListeners\TreeCacheInvalidationListener;
 use App\Repository\Parts\ManufacturerRepository;
-use App\Validator\Constraints\UniqueObjectCollection;
+use App\Entity\Base\AbstractStructuralDBElement;
 use Doctrine\Common\Collections\ArrayCollection;
 use App\Entity\Attachments\ManufacturerAttachment;
+use App\Entity\Base\AbstractCompany;
 use App\Entity\Parameters\ManufacturerParameter;
 use Doctrine\Common\Collections\Collection;
 use Doctrine\ORM\Mapping as ORM;
-use Symfony\Bridge\Doctrine\Validator\Constraints\UniqueEntity;
 use Symfony\Component\Serializer\Annotation\Groups;
 use Symfony\Component\Validator\Constraints as Assert;
 
 /**
  * This entity represents a manufacturer of a part (The company that produces the part).
+ *
+ * @extends AbstractCompany<ManufacturerAttachment, ManufacturerParameter>
  */
 #[ORM\Entity(repositoryClass: ManufacturerRepository::class)]
 #[ORM\Table('`manufacturers`')]
 #[ORM\Index(columns: ['name'], name: 'manufacturer_name')]
 #[ORM\Index(columns: ['parent_id', 'name'], name: 'manufacturer_idx_parent_name')]
-#[ORM\HasLifecycleCallbacks]
-#[ORM\EntityListeners([TreeCacheInvalidationListener::class])]
-#[UniqueEntity(fields: ['name', 'parent'], message: 'structural.entity.unique_name', ignoreNull: false)]
 #[ApiResource(
     operations: [
         new Get(security: 'is_granted("read", object)'),
@@ -105,22 +87,13 @@ use Symfony\Component\Validator\Constraints as Assert;
 #[ApiFilter(LikeFilter::class, properties: ["name", "comment"])]
 #[ApiFilter(DateFilter::class, strategy: DateFilterInterface::EXCLUDE_NULL)]
 #[ApiFilter(OrderFilter::class, properties: ['name', 'id', 'addedDate', 'lastModified'])]
-class Manufacturer implements DBElementInterface, NamedElementInterface, TimeStampableInterface, HasAttachmentsInterface, HasMasterAttachmentInterface, StructuralElementInterface, HasParametersInterface, CompanyInterface, \Stringable, \JsonSerializable
+class Manufacturer extends AbstractCompany
 {
-    use DBElementTrait;
-    use NamedElementTrait;
-    use TimestampTrait;
-    use AttachmentsTrait;
-    use MasterAttachmentTrait;
-    use StructuralElementTrait;
-    use ParametersTrait;
-    use CompanyTrait;
-
     #[ORM\ManyToOne(targetEntity: self::class, inversedBy: 'children')]
     #[ORM\JoinColumn(name: 'parent_id')]
     #[Groups(['manufacturer:read', 'manufacturer:write'])]
     #[ApiProperty(readableLink: false, writableLink: false)]
-    protected ?self $parent = null;
+    protected ?AbstractStructuralDBElement $parent = null;
 
     #[ORM\OneToMany(mappedBy: 'parent', targetEntity: self::class)]
     #[ORM\OrderBy(['name' => Criteria::ASC])]
@@ -145,50 +118,16 @@ class Manufacturer implements DBElementInterface, NamedElementInterface, TimeSta
     /** @var Collection<int, ManufacturerParameter>
      */
     #[Assert\Valid]
-    #[UniqueObjectCollection(fields: ['name', 'group', 'element'])]
     #[ORM\OneToMany(mappedBy: 'element', targetEntity: ManufacturerParameter::class, cascade: ['persist', 'remove'], orphanRemoval: true)]
     #[ORM\OrderBy(['group' => Criteria::ASC, 'name' => 'ASC'])]
     #[Groups(['manufacturer:read', 'manufacturer:write'])]
     #[ApiProperty(readableLink: false, writableLink: true)]
     protected Collection $parameters;
-    
-    #[Groups(['manufacturer:read', 'manufacturer:write'])]
-    protected string $comment = '';
-    
-    #[Groups(['manufacturer:read'])]
-    protected ?\DateTimeImmutable $addedDate = null;
-    #[Groups(['manufacturer:read'])]
-    protected ?\DateTimeImmutable $lastModified = null;
-    
     public function __construct()
     {
-        $this->initializeAttachments();
-        $this->initializeStructuralElement();
+        parent::__construct();
         $this->children = new ArrayCollection();
         $this->attachments = new ArrayCollection();
         $this->parameters = new ArrayCollection();
     }
-
-    public function __clone()
-    {
-        if ($this->id) {
-            $this->cloneDBElement();
-            $this->cloneAttachments();
-            
-            // We create a new object, so give it a new creation date
-            $this->addedDate = null;
-            
-            //Deep clone parameters
-            $parameters = $this->parameters;
-            $this->parameters = new ArrayCollection();
-            foreach ($parameters as $parameter) {
-                $this->addParameter(clone $parameter);
-            }
-        }
-    }
-
-    public function jsonSerialize(): array
-    {
-        return ['@id' => $this->getID()];
-    }
 }

src/Entity/Parts/MeasurementUnit.php

@@ -39,26 +39,12 @@ use ApiPlatform\OpenApi\Model\Operation;
 use ApiPlatform\Serializer\Filter\PropertyFilter;
 use App\ApiPlatform\Filter\LikeFilter;
 use App\Entity\Attachments\Attachment;
-use App\Entity\Base\AttachmentsTrait;
-use App\Entity\Base\DBElementTrait;
-use App\Entity\Base\MasterAttachmentTrait;
-use App\Entity\Base\NamedElementTrait;
-use App\Entity\Base\StructuralElementTrait;
-use App\Entity\Base\TimestampTrait;
-use App\Entity\Contracts\DBElementInterface;
-use App\Entity\Contracts\HasAttachmentsInterface;
-use App\Entity\Contracts\HasMasterAttachmentInterface;
-use App\Entity\Contracts\HasParametersInterface;
-use App\Entity\Contracts\NamedElementInterface;
-use App\Entity\Contracts\StructuralElementInterface;
-use App\Entity\Contracts\TimeStampableInterface;
-use App\Entity\Parameters\ParametersTrait;
-use App\EntityListeners\TreeCacheInvalidationListener;
 use App\Repository\Parts\MeasurementUnitRepository;
-use App\Validator\Constraints\UniqueObjectCollection;
 use Doctrine\DBAL\Types\Types;
+use App\Entity\Base\AbstractStructuralDBElement;
 use Doctrine\Common\Collections\ArrayCollection;
 use App\Entity\Attachments\MeasurementUnitAttachment;
+use App\Entity\Base\AbstractPartsContainingDBElement;
 use App\Entity\Parameters\MeasurementUnitParameter;
 use Doctrine\Common\Collections\Collection;
 use Doctrine\ORM\Mapping as ORM;
@@ -70,15 +56,14 @@ use Symfony\Component\Validator\Constraints\Length;
 /**
  * This unit represents the unit in which the amount of parts in stock are measured.
  * This could be something like N, grams, meters, etc...
+ *
+ * @extends AbstractPartsContainingDBElement<MeasurementUnitAttachment,MeasurementUnitParameter>
  */
 #[UniqueEntity('unit')]
 #[ORM\Entity(repositoryClass: MeasurementUnitRepository::class)]
 #[ORM\Table(name: '`measurement_units`')]
 #[ORM\Index(columns: ['name'], name: 'unit_idx_name')]
 #[ORM\Index(columns: ['parent_id', 'name'], name: 'unit_idx_parent_name')]
-#[ORM\HasLifecycleCallbacks]
-#[ORM\EntityListeners([TreeCacheInvalidationListener::class])]
-#[UniqueEntity(fields: ['name', 'parent'], message: 'structural.entity.unique_name', ignoreNull: false)]
 #[ApiResource(
     operations: [
         new Get(security: 'is_granted("read", object)'),
@@ -107,15 +92,8 @@ use Symfony\Component\Validator\Constraints\Length;
 #[ApiFilter(LikeFilter::class, properties: ["name", "comment", "unit"])]
 #[ApiFilter(DateFilter::class, strategy: DateFilterInterface::EXCLUDE_NULL)]
 #[ApiFilter(OrderFilter::class, properties: ['name', 'id', 'addedDate', 'lastModified'])]
-class MeasurementUnit implements DBElementInterface, NamedElementInterface, TimeStampableInterface, HasAttachmentsInterface, HasMasterAttachmentInterface, StructuralElementInterface, HasParametersInterface, \Stringable, \JsonSerializable
+class MeasurementUnit extends AbstractPartsContainingDBElement
 {
-    use DBElementTrait;
-    use NamedElementTrait;
-    use TimestampTrait;
-    use AttachmentsTrait;
-    use MasterAttachmentTrait;
-    use StructuralElementTrait;
-    use ParametersTrait;
     /**
      * @var string The unit symbol that should be used for the Unit. This could be something like "", g (for grams)
      *             or m (for meters).
@@ -153,7 +131,7 @@ class MeasurementUnit implements DBElementInterface, NamedElementInterface, Time
     #[ORM\JoinColumn(name: 'parent_id')]
     #[Groups(['measurement_unit:read', 'measurement_unit:write'])]
     #[ApiProperty(readableLink: false, writableLink: false)]
-    protected ?self $parent = null;
+    protected ?AbstractStructuralDBElement $parent = null;
 
     /**
      * @var Collection<int, MeasurementUnitAttachment>
@@ -172,7 +150,6 @@ class MeasurementUnit implements DBElementInterface, NamedElementInterface, Time
     /** @var Collection<int, MeasurementUnitParameter>
      */
     #[Assert\Valid]
-    #[UniqueObjectCollection(fields: ['name', 'group', 'element'])]
     #[ORM\OneToMany(mappedBy: 'element', targetEntity: MeasurementUnitParameter::class, cascade: ['persist', 'remove'], orphanRemoval: true)]
     #[ORM\OrderBy(['group' => Criteria::ASC, 'name' => 'ASC'])]
     #[Groups(['measurement_unit:read', 'measurement_unit:write'])]
@@ -224,33 +201,9 @@ class MeasurementUnit implements DBElementInterface, NamedElementInterface, Time
     }
     public function __construct()
     {
-        $this->initializeAttachments();
-        $this->initializeStructuralElement();
+        parent::__construct();
         $this->children = new ArrayCollection();
         $this->attachments = new ArrayCollection();
         $this->parameters = new ArrayCollection();
     }
-
-    public function __clone()
-    {
-        if ($this->id) {
-            $this->cloneDBElement();
-            $this->cloneAttachments();
-            
-            // We create a new object, so give it a new creation date
-            $this->addedDate = null;
-            
-            //Deep clone parameters
-            $parameters = $this->parameters;
-            $this->parameters = new ArrayCollection();
-            foreach ($parameters as $parameter) {
-                $this->addParameter(clone $parameter);
-            }
-        }
-    }
-
-    public function jsonSerialize(): array
-    {
-        return ['@id' => $this->getID()];
-    }
 }

src/Entity/Parts/PartCustomState.php

@@ -37,42 +37,26 @@ use ApiPlatform\Metadata\Patch;
 use ApiPlatform\Metadata\Post;
 use ApiPlatform\Serializer\Filter\PropertyFilter;
 use App\ApiPlatform\Filter\LikeFilter;
-use App\Entity\Base\AttachmentsTrait;
-use App\Entity\Base\DBElementTrait;
-use App\Entity\Base\MasterAttachmentTrait;
-use App\Entity\Base\NamedElementTrait;
-use App\Entity\Base\StructuralElementTrait;
-use App\Entity\Base\TimestampTrait;
-use App\Entity\Contracts\DBElementInterface;
-use App\Entity\Contracts\HasAttachmentsInterface;
-use App\Entity\Contracts\HasMasterAttachmentInterface;
-use App\Entity\Contracts\HasParametersInterface;
-use App\Entity\Contracts\NamedElementInterface;
-use App\Entity\Contracts\StructuralElementInterface;
-use App\Entity\Contracts\TimeStampableInterface;
+use App\Entity\Base\AbstractPartsContainingDBElement;
+use App\Entity\Base\AbstractStructuralDBElement;
 use App\Entity\Parameters\PartCustomStateParameter;
-use App\Entity\Parameters\ParametersTrait;
-use App\EntityListeners\TreeCacheInvalidationListener;
 use App\Repository\Parts\PartCustomStateRepository;
-use App\Validator\Constraints\UniqueObjectCollection;
 use Doctrine\Common\Collections\ArrayCollection;
 use Doctrine\Common\Collections\Collection;
 use Doctrine\Common\Collections\Criteria;
 use Doctrine\ORM\Mapping as ORM;
-use Symfony\Bridge\Doctrine\Validator\Constraints\UniqueEntity;
 use Symfony\Component\Serializer\Annotation\Groups;
 use Symfony\Component\Validator\Constraints as Assert;
 
 /**
  * This entity represents a custom part state.
  * If an organisation uses Part-DB and has its custom part states, this is useful.
+ *
+ * @extends AbstractPartsContainingDBElement<PartCustomStateAttachment,PartCustomStateParameter>
  */
 #[ORM\Entity(repositoryClass: PartCustomStateRepository::class)]
 #[ORM\Table('`part_custom_states`')]
 #[ORM\Index(columns: ['name'], name: 'part_custom_state_name')]
-#[ORM\HasLifecycleCallbacks]
-#[ORM\EntityListeners([TreeCacheInvalidationListener::class])]
-#[UniqueEntity(fields: ['name', 'parent'], message: 'structural.entity.unique_name', ignoreNull: false)]
 #[ApiResource(
     operations: [
         new Get(security: 'is_granted("read", object)'),
@@ -88,16 +72,8 @@ use Symfony\Component\Validator\Constraints as Assert;
 #[ApiFilter(LikeFilter::class, properties: ["name"])]
 #[ApiFilter(DateFilter::class, strategy: DateFilterInterface::EXCLUDE_NULL)]
 #[ApiFilter(OrderFilter::class, properties: ['name', 'id', 'addedDate', 'lastModified'])]
-class PartCustomState implements DBElementInterface, NamedElementInterface, TimeStampableInterface, HasAttachmentsInterface, HasMasterAttachmentInterface, StructuralElementInterface, HasParametersInterface, \Stringable, \JsonSerializable
+class PartCustomState extends AbstractPartsContainingDBElement
 {
-    use DBElementTrait;
-    use NamedElementTrait;
-    use TimestampTrait;
-    use AttachmentsTrait;
-    use MasterAttachmentTrait;
-    use StructuralElementTrait;
-    use ParametersTrait;
-
     /**
      * @var string The comment info for this element as markdown
      */
@@ -112,7 +88,7 @@ class PartCustomState implements DBElementInterface, NamedElementInterface, Time
     #[ORM\JoinColumn(name: 'parent_id')]
     #[Groups(['part_custom_state:read', 'part_custom_state:write'])]
     #[ApiProperty(readableLink: false, writableLink: false)]
-    protected ?self $parent = null;
+    protected ?AbstractStructuralDBElement $parent = null;
 
     /**
      * @var Collection<int, PartCustomStateAttachment>
@@ -131,7 +107,6 @@ class PartCustomState implements DBElementInterface, NamedElementInterface, Time
     /** @var Collection<int, PartCustomStateParameter>
      */
     #[Assert\Valid]
-    #[UniqueObjectCollection(fields: ['name', 'group', 'element'])]
     #[ORM\OneToMany(mappedBy: 'element', targetEntity: PartCustomStateParameter::class, cascade: ['persist', 'remove'], orphanRemoval: true)]
     #[ORM\OrderBy(['name' => 'ASC'])]
     #[Groups(['part_custom_state:read', 'part_custom_state:write'])]
@@ -144,33 +119,9 @@ class PartCustomState implements DBElementInterface, NamedElementInterface, Time
 
     public function __construct()
     {
-        $this->initializeAttachments();
-        $this->initializeStructuralElement();
+        parent::__construct();
         $this->children = new ArrayCollection();
         $this->attachments = new ArrayCollection();
         $this->parameters = new ArrayCollection();
     }
-
-    public function __clone()
-    {
-        if ($this->id) {
-            $this->cloneDBElement();
-            $this->cloneAttachments();
-            
-            // We create a new object, so give it a new creation date
-            $this->addedDate = null;
-            
-            //Deep clone parameters
-            $parameters = $this->parameters;
-            $this->parameters = new ArrayCollection();
-            foreach ($parameters as $parameter) {
-                $this->addParameter(clone $parameter);
-            }
-        }
-    }
-
-    public function jsonSerialize(): array
-    {
-        return ['@id' => $this->getID()];
-    }
 }

src/Entity/Parts/StorageLocation.php

@@ -39,44 +39,27 @@ use ApiPlatform\OpenApi\Model\Operation;
 use ApiPlatform\Serializer\Filter\PropertyFilter;
 use App\ApiPlatform\Filter\LikeFilter;
 use App\Entity\Attachments\Attachment;
-use App\Entity\Base\AttachmentsTrait;
-use App\Entity\Base\DBElementTrait;
-use App\Entity\Base\MasterAttachmentTrait;
-use App\Entity\Base\NamedElementTrait;
-use App\Entity\Base\StructuralElementTrait;
-use App\Entity\Base\TimestampTrait;
-use App\Entity\Contracts\DBElementInterface;
-use App\Entity\Contracts\HasAttachmentsInterface;
-use App\Entity\Contracts\HasMasterAttachmentInterface;
-use App\Entity\Contracts\HasParametersInterface;
-use App\Entity\Contracts\NamedElementInterface;
-use App\Entity\Contracts\StructuralElementInterface;
-use App\Entity\Contracts\TimeStampableInterface;
-use App\Entity\Parameters\ParametersTrait;
-use App\EntityListeners\TreeCacheInvalidationListener;
 use App\Repository\Parts\StorelocationRepository;
-use App\Validator\Constraints\UniqueObjectCollection;
 use Doctrine\DBAL\Types\Types;
 use Doctrine\Common\Collections\ArrayCollection;
 use App\Entity\Attachments\StorageLocationAttachment;
+use App\Entity\Base\AbstractPartsContainingDBElement;
+use App\Entity\Base\AbstractStructuralDBElement;
 use App\Entity\Parameters\StorageLocationParameter;
 use App\Entity\UserSystem\User;
 use Doctrine\Common\Collections\Collection;
 use Doctrine\ORM\Mapping as ORM;
-use Symfony\Bridge\Doctrine\Validator\Constraints\UniqueEntity;
 use Symfony\Component\Serializer\Annotation\Groups;
 use Symfony\Component\Validator\Constraints as Assert;
 
 /**
  * This entity represents a storage location, where parts can be stored.
+ * @extends AbstractPartsContainingDBElement<StorageLocationAttachment, StorageLocationParameter>
  */
 #[ORM\Entity(repositoryClass: StorelocationRepository::class)]
 #[ORM\Table('`storelocations`')]
 #[ORM\Index(columns: ['name'], name: 'location_idx_name')]
 #[ORM\Index(columns: ['parent_id', 'name'], name: 'location_idx_parent_name')]
-#[ORM\HasLifecycleCallbacks]
-#[ORM\EntityListeners([TreeCacheInvalidationListener::class])]
-#[UniqueEntity(fields: ['name', 'parent'], message: 'structural.entity.unique_name', ignoreNull: false)]
 #[ApiResource(
     operations: [
         new Get(security: 'is_granted("read", object)'),
@@ -105,16 +88,8 @@ use Symfony\Component\Validator\Constraints as Assert;
 #[ApiFilter(LikeFilter::class, properties: ["name", "comment"])]
 #[ApiFilter(DateFilter::class, strategy: DateFilterInterface::EXCLUDE_NULL)]
 #[ApiFilter(OrderFilter::class, properties: ['name', 'id', 'addedDate', 'lastModified'])]
-class StorageLocation implements DBElementInterface, NamedElementInterface, TimeStampableInterface, HasAttachmentsInterface, HasMasterAttachmentInterface, StructuralElementInterface, HasParametersInterface, \Stringable, \JsonSerializable
+class StorageLocation extends AbstractPartsContainingDBElement
 {
-    use DBElementTrait;
-    use NamedElementTrait;
-    use TimestampTrait;
-    use AttachmentsTrait;
-    use MasterAttachmentTrait;
-    use StructuralElementTrait;
-    use ParametersTrait;
-
     #[ORM\OneToMany(mappedBy: 'parent', targetEntity: self::class)]
     #[ORM\OrderBy(['name' => Criteria::ASC])]
     protected Collection $children;
@@ -123,7 +98,7 @@ class StorageLocation implements DBElementInterface, NamedElementInterface, Time
     #[ORM\JoinColumn(name: 'parent_id')]
     #[Groups(['location:read', 'location:write'])]
     #[ApiProperty(readableLink: false, writableLink: false)]
-    protected ?self $parent = null;
+    protected ?AbstractStructuralDBElement $parent = null;
 
     #[Groups(['location:read', 'location:write'])]
     protected string $comment = '';
@@ -139,7 +114,6 @@ class StorageLocation implements DBElementInterface, NamedElementInterface, Time
     /** @var Collection<int, StorageLocationParameter>
      */
     #[Assert\Valid]
-    #[UniqueObjectCollection(fields: ['name', 'group', 'element'])]
     #[ORM\OneToMany(mappedBy: 'element', targetEntity: StorageLocationParameter::class, cascade: ['persist', 'remove'], orphanRemoval: true)]
     #[ORM\OrderBy(['group' => Criteria::ASC, 'name' => 'ASC'])]
     #[Groups(['location:read', 'location:write'])]
@@ -321,33 +295,9 @@ class StorageLocation implements DBElementInterface, NamedElementInterface, Time
     }
     public function __construct()
     {
-        $this->initializeAttachments();
-        $this->initializeStructuralElement();
+        parent::__construct();
         $this->children = new ArrayCollection();
         $this->parameters = new ArrayCollection();
         $this->attachments = new ArrayCollection();
     }
-
-    public function __clone()
-    {
-        if ($this->id) {
-            $this->cloneDBElement();
-            $this->cloneAttachments();
-            
-            // We create a new object, so give it a new creation date
-            $this->addedDate = null;
-            
-            //Deep clone parameters
-            $parameters = $this->parameters;
-            $this->parameters = new ArrayCollection();
-            foreach ($parameters as $parameter) {
-                $this->addParameter(clone $parameter);
-            }
-        }
-    }
-
-    public function jsonSerialize(): array
-    {
-        return ['@id' => $this->getID()];
-    }
 }

src/Entity/Parts/Supplier.php

@@ -39,28 +39,12 @@ use ApiPlatform\OpenApi\Model\Operation;
 use ApiPlatform\Serializer\Filter\PropertyFilter;
 use App\ApiPlatform\Filter\LikeFilter;
 use App\Entity\Attachments\Attachment;
-use App\Entity\Base\AttachmentsTrait;
-use App\Entity\Base\CompanyTrait;
-use App\Entity\Base\DBElementTrait;
-use App\Entity\Base\MasterAttachmentTrait;
-use App\Entity\Base\NamedElementTrait;
-use App\Entity\Base\StructuralElementTrait;
-use App\Entity\Base\TimestampTrait;
-use App\Entity\Contracts\CompanyInterface;
-use App\Entity\Contracts\DBElementInterface;
-use App\Entity\Contracts\HasAttachmentsInterface;
-use App\Entity\Contracts\HasMasterAttachmentInterface;
-use App\Entity\Contracts\HasParametersInterface;
-use App\Entity\Contracts\NamedElementInterface;
-use App\Entity\Contracts\StructuralElementInterface;
-use App\Entity\Contracts\TimeStampableInterface;
-use App\Entity\Parameters\ParametersTrait;
-use App\EntityListeners\TreeCacheInvalidationListener;
 use App\Repository\Parts\SupplierRepository;
 use App\Entity\PriceInformations\Orderdetail;
-use App\Validator\Constraints\UniqueObjectCollection;
 use Doctrine\Common\Collections\ArrayCollection;
 use App\Entity\Attachments\SupplierAttachment;
+use App\Entity\Base\AbstractCompany;
+use App\Entity\Base\AbstractStructuralDBElement;
 use App\Entity\Parameters\SupplierParameter;
 use App\Entity\PriceInformations\Currency;
 use App\Validator\Constraints\BigDecimal\BigDecimalPositiveOrZero;
@@ -68,20 +52,18 @@ use App\Validator\Constraints\Selectable;
 use Brick\Math\BigDecimal;
 use Doctrine\Common\Collections\Collection;
 use Doctrine\ORM\Mapping as ORM;
-use Symfony\Bridge\Doctrine\Validator\Constraints\UniqueEntity;
 use Symfony\Component\Serializer\Annotation\Groups;
 use Symfony\Component\Validator\Constraints as Assert;
 
 /**
  * This entity represents a supplier of parts (the company that sells the parts).
+ *
+ * @extends AbstractCompany<SupplierAttachment, SupplierParameter>
  */
 #[ORM\Entity(repositoryClass: SupplierRepository::class)]
 #[ORM\Table('`suppliers`')]
 #[ORM\Index(columns: ['name'], name: 'supplier_idx_name')]
 #[ORM\Index(columns: ['parent_id', 'name'], name: 'supplier_idx_parent_name')]
-#[ORM\HasLifecycleCallbacks]
-#[ORM\EntityListeners([TreeCacheInvalidationListener::class])]
-#[UniqueEntity(fields: ['name', 'parent'], message: 'structural.entity.unique_name', ignoreNull: false)]
 #[ApiResource(
     operations: [
         new Get(security: 'is_granted("read", object)'),
@@ -108,17 +90,8 @@ use Symfony\Component\Validator\Constraints as Assert;
 #[ApiFilter(LikeFilter::class, properties: ["name", "comment"])]
 #[ApiFilter(DateFilter::class, strategy: DateFilterInterface::EXCLUDE_NULL)]
 #[ApiFilter(OrderFilter::class, properties: ['name', 'id', 'addedDate', 'lastModified'])]
-class Supplier implements DBElementInterface, NamedElementInterface, TimeStampableInterface, HasAttachmentsInterface, HasMasterAttachmentInterface, StructuralElementInterface, HasParametersInterface, CompanyInterface, \Stringable, \JsonSerializable
+class Supplier extends AbstractCompany
 {
-    use DBElementTrait;
-    use NamedElementTrait;
-    use TimestampTrait;
-    use AttachmentsTrait;
-    use MasterAttachmentTrait;
-    use StructuralElementTrait;
-    use ParametersTrait;
-    use CompanyTrait;
-
     #[ORM\OneToMany(mappedBy: 'parent', targetEntity: self::class)]
     #[ORM\OrderBy(['name' => Criteria::ASC])]
     protected Collection $children;
@@ -127,7 +100,7 @@ class Supplier implements DBElementInterface, NamedElementInterface, TimeStampab
     #[ORM\JoinColumn(name: 'parent_id')]
     #[Groups(['supplier:read', 'supplier:write'])]
     #[ApiProperty(readableLink: false, writableLink: false)]
-    protected ?self $parent = null;
+    protected ?AbstractStructuralDBElement $parent = null;
 
     /**
      * @var Collection<int, Orderdetail>
@@ -171,21 +144,12 @@ class Supplier implements DBElementInterface, NamedElementInterface, TimeStampab
     /** @var Collection<int, SupplierParameter>
      */
     #[Assert\Valid]
-    #[UniqueObjectCollection(fields: ['name', 'group', 'element'])]
     #[ORM\OneToMany(mappedBy: 'element', targetEntity: SupplierParameter::class, cascade: ['persist', 'remove'], orphanRemoval: true)]
     #[ORM\OrderBy(['group' => Criteria::ASC, 'name' => 'ASC'])]
     #[Groups(['supplier:read', 'supplier:write'])]
     #[ApiProperty(readableLink: false, writableLink: true)]
     protected Collection $parameters;
 
-    #[Groups(['supplier:read', 'supplier:write'])]
-    protected string $comment = '';
-    
-    #[Groups(['supplier:read'])]
-    protected ?\DateTimeImmutable $addedDate = null;
-    #[Groups(['supplier:read'])]
-    protected ?\DateTimeImmutable $lastModified = null;
-
     /**
      * Gets the currency that should be used by default, when creating a orderdetail with this supplier.
      */
@@ -234,34 +198,10 @@ class Supplier implements DBElementInterface, NamedElementInterface, TimeStampab
     }
     public function __construct()
     {
-        $this->initializeAttachments();
-        $this->initializeStructuralElement();
+        parent::__construct();
         $this->children = new ArrayCollection();
         $this->orderdetails = new ArrayCollection();
         $this->attachments = new ArrayCollection();
         $this->parameters = new ArrayCollection();
     }
-
-    public function __clone()
-    {
-        if ($this->id) {
-            $this->cloneDBElement();
-            $this->cloneAttachments();
-            
-            // We create a new object, so give it a new creation date
-            $this->addedDate = null;
-            
-            //Deep clone parameters
-            $parameters = $this->parameters;
-            $this->parameters = new ArrayCollection();
-            foreach ($parameters as $parameter) {
-                $this->addParameter(clone $parameter);
-            }
-        }
-    }
-
-    public function jsonSerialize(): array
-    {
-        return ['@id' => $this->getID()];
-    }
 }

src/Services/Attachments/FileTypeFilterTools.php

@@ -139,7 +139,7 @@ class FileTypeFilterTools
     {
         $filter = trim($filter);
 
-        return $this->cache->get('filter_exts_'.md5($filter), function (ItemInterface $item) use ($filter) {
+        return $this->cache->get('filter_exts_'.hash('xxh3', $filter), function (ItemInterface $item) use ($filter) {
             $elements = explode(',', $filter);
             $extensions = [];
 

src/Services/InfoProviderSystem/Providers/BuerklinProvider.php

@@ -0,0 +1,639 @@
+<?php
+/*
+ * This file is part of Part-DB (https://github.com/Part-DB/Part-DB-symfony).
+ *
+ *  Copyright (C) 2019 - 2023 Jan Böhmer (https://github.com/jbtronics)
+ *  Copyright (C) 2025 Marc Kreidler (https://github.com/mkne)
+ *
+ *  This program is free software: you can redistribute it and/or modify
+ *  it under the terms of the GNU Affero General Public License as published
+ *  by the Free Software Foundation, either version 3 of the License, or
+ *  (at your option) any later version.
+ *
+ *  This program is distributed in the hope that it will be useful,
+ *  but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ *  GNU Affero General Public License for more details.
+ *
+ *  You should have received a copy of the GNU Affero General Public License
+ *  along with this program.  If not, see <https://www.gnu.org/licenses/>.
+ */
+
+declare(strict_types=1);
+
+
+namespace App\Services\InfoProviderSystem\Providers;
+
+use App\Services\InfoProviderSystem\DTOs\FileDTO;
+use App\Services\InfoProviderSystem\DTOs\ParameterDTO;
+use App\Services\InfoProviderSystem\DTOs\PartDetailDTO;
+use App\Services\InfoProviderSystem\DTOs\PriceDTO;
+use App\Services\InfoProviderSystem\DTOs\PurchaseInfoDTO;
+use App\Services\InfoProviderSystem\DTOs\SearchResultDTO;
+use App\Settings\InfoProviderSystem\BuerklinSettings;
+use Psr\Cache\CacheItemPoolInterface;
+use Symfony\Contracts\HttpClient\HttpClientInterface;
+
+class BuerklinProvider implements BatchInfoProviderInterface
+{
+
+    private const ENDPOINT_URL = 'https://www.buerklin.com/buerklinws/v2/buerklin';
+
+    public const DISTRIBUTOR_NAME = 'Buerklin';
+
+    private const CACHE_TTL = 600;
+    /**
+     * Local in-request cache to avoid hitting the PSR cache repeatedly for the same product.
+     * @var array<string, array>
+     */
+    private array $productCache = [];
+
+    public function __construct(
+        private readonly HttpClientInterface $client,
+        private readonly CacheItemPoolInterface $partInfoCache,
+        private readonly BuerklinSettings $settings,
+    ) {
+
+    }
+
+    /**
+     * Gets the latest OAuth token for the Buerklin API, or creates a new one if none is available
+     * TODO: Rework this to use the OAuth token manager system in the database...
+     * @return string
+     */
+    private function getToken(): string
+    {
+        // Cache token to avoid hammering the auth server on every request
+        $cacheKey = 'buerklin.oauth.token';
+        $item = $this->partInfoCache->getItem($cacheKey);
+
+        if ($item->isHit()) {
+            $token = $item->get();
+            if (is_string($token) && $token !== '') {
+                return $token;
+            }
+        }
+
+        // Buerklin OAuth2 password grant (ROPC)
+        $resp = $this->client->request('POST', 'https://www.buerklin.com/authorizationserver/oauth/token/', [
+            'headers' => [
+                'Accept' => 'application/json',
+                'Content-Type' => 'application/x-www-form-urlencoded',
+            ],
+            'body' => [
+                'grant_type' => 'password',
+                'client_id' => $this->settings->clientId,
+                'client_secret' => $this->settings->secret,
+                'username' => $this->settings->username,
+                'password' => $this->settings->password,
+            ],
+        ]);
+
+        $data = $resp->toArray(false);
+
+        if (!isset($data['access_token'])) {
+            throw new \RuntimeException(
+                'Invalid token response from Buerklin: HTTP ' . $resp->getStatusCode() . ' body=' . $resp->getContent(false)
+            );
+        }
+
+        $token = (string) $data['access_token'];
+
+        // Cache for (expires_in - 30s) if available
+        $ttl = 300;
+        if (isset($data['expires_in']) && is_numeric($data['expires_in'])) {
+            $ttl = max(60, (int) $data['expires_in'] - 30);
+        }
+
+        $item->set($token);
+        $item->expiresAfter($ttl);
+        $this->partInfoCache->save($item);
+
+        return $token;
+    }
+
+    private function getDefaultQueryParams(): array
+    {
+        return [
+            'curr' => $this->settings->currency ?: 'EUR',
+            'language' => $this->settings->language ?: 'en',
+        ];
+    }
+
+    private function getProduct(string $code): array
+    {
+        $code = strtoupper(trim($code));
+        if ($code === '') {
+            throw new \InvalidArgumentException('Product code must not be empty.');
+        }
+
+        $cacheKey = sprintf(
+            'buerklin.product.%s',
+            md5($code . '|' . $this->settings->language . '|' . $this->settings->currency)
+        );
+
+        if (isset($this->productCache[$cacheKey])) {
+            return $this->productCache[$cacheKey];
+        }
+
+        $item = $this->partInfoCache->getItem($cacheKey);
+        if ($item->isHit() && is_array($cached = $item->get())) {
+            return $this->productCache[$cacheKey] = $cached;
+        }
+
+        $product = $this->makeAPICall('/products/' . rawurlencode($code) . '/');
+
+        $item->set($product);
+        $item->expiresAfter(self::CACHE_TTL);
+        $this->partInfoCache->save($item);
+
+        return $this->productCache[$cacheKey] = $product;
+    }
+
+    private function makeAPICall(string $endpoint, array $queryParams = []): array
+    {
+        try {
+            $response = $this->client->request('GET', self::ENDPOINT_URL . $endpoint, [
+                'auth_bearer' => $this->getToken(),
+                'headers' => ['Accept' => 'application/json'],
+                'query' => array_merge($this->getDefaultQueryParams(), $queryParams),
+            ]);
+
+            return $response->toArray();
+        } catch (\Exception $e) {
+            throw new \RuntimeException("Buerklin API request failed: " .
+                "Endpoint: " . $endpoint .
+                "Token: [redacted] " .
+                "QueryParams: " . json_encode($queryParams, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES) . " " .
+                "Exception message: " . $e->getMessage());
+        }
+    }
+
+
+    public function getProviderInfo(): array
+    {
+        return [
+            'name' => 'Buerklin',
+            'description' => 'This provider uses the Buerklin API to search for parts.',
+            'url' => 'https://www.buerklin.com/',
+            'disabled_help' => 'Configure the API Client ID, Secret, Username and Password provided by Buerklin in the provider settings to enable.',
+            'settings_class' => BuerklinSettings::class
+        ];
+    }
+
+    public function getProviderKey(): string
+    {
+        return 'buerklin';
+    }
+
+    // This provider is considered active if settings are present
+    public function isActive(): bool
+    {
+        // The client credentials and user credentials must be set
+        return $this->settings->clientId !== null && $this->settings->clientId !== ''
+            && $this->settings->secret !== null && $this->settings->secret !== ''
+            && $this->settings->username !== null && $this->settings->username !== ''
+            && $this->settings->password !== null && $this->settings->password !== '';
+    }
+
+    /**
+     * Sanitizes a field by removing any HTML tags and other unwanted characters
+     * @param  string|null  $field
+     * @return string|null
+     */
+    private function sanitizeField(?string $field): ?string
+    {
+        if ($field === null) {
+            return null;
+        }
+
+        return strip_tags($field);
+    }
+
+    /**
+     * Takes a deserialized JSON object of the product and returns a PartDetailDTO
+     * @param  array  $product
+     * @return PartDetailDTO
+     */
+    private function getPartDetail(array $product): PartDetailDTO
+    {
+        // If this is a search-result object, it may not contain prices/features/images -> reload full details.
+        if ((!isset($product['price']) && !isset($product['volumePrices'])) && isset($product['code'])) {
+            try {
+                $product = $this->getProduct((string) $product['code']);
+            } catch (\Throwable $e) {
+                // If reload fails, keep the partial product data and continue.
+            }
+        }
+
+        // Extract images from API response
+        $productImages = $this->getProductImages($product['images'] ?? null);
+
+        // Set preview image
+        $preview = $productImages[0]->url ?? null;
+
+        // Extract features (parameters) from classifications[0].features of Buerklin JSON response
+        $features = $product['classifications'][0]['features'] ?? [];
+
+        // Feature parameters (from classifications->features)
+        $featureParams = $this->attributesToParameters($features, ''); // leave group empty for normal parameters
+
+        // Compliance parameters (from top-level fields like RoHS/SVHC/…)
+        $complianceParams = $this->complianceToParameters($product, 'Compliance');
+
+        // Merge all parameters
+        $allParams = array_merge($featureParams, $complianceParams);
+
+        // Assign footprint: "Design" (en) / "Bauform" (de) / "Enclosure" (en) / "Gehäuse" (de)
+        $footprint = null;
+        if (is_array($features)) {
+            foreach ($features as $feature) {
+                $name = $feature['name'] ?? null;
+                if ($name === 'Design' || $name === 'Bauform' || $name === 'Enclosure' || $name === 'Gehäuse') {
+                    $footprint = $feature['featureValues'][0]['value'] ?? null;
+                    break;
+                }
+            }
+        }
+
+        // Prices: prefer volumePrices, fallback to single price
+        $code = (string) ($product['orderNumber'] ?? $product['code'] ?? '');
+        $prices = $product['volumePrices'] ?? null;
+
+        if (!is_array($prices) || count($prices) === 0) {
+            $pVal = $product['price']['value'] ?? null;
+            $pCur = $product['price']['currencyIso'] ?? ($this->settings->currency ?: 'EUR');
+
+            if (is_numeric($pVal)) {
+                $prices = [
+                    [
+                        'minQuantity' => 1,
+                        'value' => (float) $pVal,
+                        'currencyIso' => (string) $pCur,
+                    ]
+                ];
+            } else {
+                $prices = [];
+            }
+        }
+
+        return new PartDetailDTO(
+            provider_key: $this->getProviderKey(),
+            provider_id: (string) ($product['code'] ?? $code),
+
+            name: (string) ($product['manufacturerProductId'] ?? $code),
+            description: $this->sanitizeField($product['description'] ?? null),
+
+            category: $this->sanitizeField($product['classifications'][0]['name'] ?? ($product['categories'][0]['name'] ?? null)),
+            manufacturer: $this->sanitizeField($product['manufacturer'] ?? null),
+            mpn: $this->sanitizeField($product['manufacturerProductId'] ?? null),
+
+            preview_image_url: $preview,
+            manufacturing_status: null,
+
+            provider_url: $this->getProductShortURL((string) ($product['code'] ?? $code)),
+            footprint: $footprint,
+
+            datasheets: null, // not found in JSON response, the Buerklin website however has links to datasheets
+            images: $productImages,
+
+            parameters: $allParams,
+
+            vendor_infos: $this->pricesToVendorInfo(
+                sku: $code,
+                url: $this->getProductShortURL($code),
+                prices: $prices
+            ),
+
+            mass: $product['weight'] ?? null,
+        );
+    }
+
+    /**
+     * Converts the price array to a VendorInfoDTO array to be used in the PartDetailDTO
+     * @param  string $sku
+     * @param  string $url
+     * @param  array  $prices
+     * @return array
+     */
+    private function pricesToVendorInfo(string $sku, string $url, array $prices): array
+    {
+        $priceDTOs = array_map(function ($price) {
+            $val = $price['value'] ?? null;
+            $valStr = is_numeric($val)
+                ? number_format((float) $val, 6, '.', '') // 6 decimal places, trailing zeros are fine
+                : (string) $val;
+
+            // Optional: softly trim unnecessary trailing zeros (e.g. 75.550000 -> 75.55)
+            $valStr = rtrim(rtrim($valStr, '0'), '.');
+
+            return new PriceDTO(
+                minimum_discount_amount: (float) ($price['minQuantity'] ?? 1),
+                price: $valStr,
+                currency_iso_code: (string) ($price['currencyIso'] ?? $this->settings->currency ?? 'EUR'),
+                includes_tax: false
+            );
+        }, $prices);
+
+        return [
+            new PurchaseInfoDTO(
+                distributor_name: self::DISTRIBUTOR_NAME,
+                order_number: $sku,
+                prices: $priceDTOs,
+                product_url: $url,
+            )
+        ];
+    }
+
+
+    /**
+     * Returns a valid Buerklin product short URL from product code
+     * @param  string  $product_code
+     * @return string
+     */
+    private function getProductShortURL(string $product_code): string
+    {
+        return 'https://www.buerklin.com/' . $this->settings->language . '/p/' . $product_code . '/';
+    }
+
+    /**
+     * Returns a deduplicated list of product images as FileDTOs.
+     *
+     * - takes only real image arrays (with 'url' field)
+     * - makes relative URLs absolute
+     * - deduplicates using URL
+     * - prefers 'zoom' format, then 'product' format, then all others
+     *
+     * @param  array|null $images
+     * @return \App\Services\InfoProviderSystem\DTOs\FileDTO[]
+     */
+    private function getProductImages(?array $images): array
+    {
+        if (!is_array($images)) {
+            return [];
+        }
+
+        // 1) Only real image entries with URL
+        $imgs = array_values(array_filter($images, fn($i) => is_array($i) && !empty($i['url'])));
+
+        // 2) Prefer zoom images
+        $zoom = array_values(array_filter($imgs, fn($i) => ($i['format'] ?? null) === 'zoom'));
+        $chosen = count($zoom) > 0
+            ? $zoom
+            : array_values(array_filter($imgs, fn($i) => ($i['format'] ?? null) === 'product'));
+
+        // 3) If still none, take all
+        if (count($chosen) === 0) {
+            $chosen = $imgs;
+        }
+
+        // 4) Deduplicate by URL (after making absolute)
+        $byUrl = [];
+        foreach ($chosen as $img) {
+            $url = (string) $img['url'];
+
+            if (!str_starts_with($url, 'http://') && !str_starts_with($url, 'https://')) {
+                $url = 'https://www.buerklin.com' . $url;
+            }
+            if (!filter_var($url, FILTER_VALIDATE_URL)) {
+                continue;
+            }
+
+            $byUrl[$url] = $url;
+        }
+
+        return array_map(
+            fn($url) => new FileDTO($url),
+            array_values($byUrl)
+        );
+    }
+
+    private function attributesToParameters(array $features, ?string $group = null): array
+    {
+        $out = [];
+
+        foreach ($features as $f) {
+            if (!is_array($f)) {
+                continue;
+            }
+
+            $name = $f['name'] ?? null;
+            if (!is_string($name) || trim($name) === '') {
+                continue;
+            }
+
+            $vals = [];
+            foreach (($f['featureValues'] ?? []) as $fv) {
+                if (is_array($fv) && isset($fv['value']) && is_string($fv['value']) && trim($fv['value']) !== '') {
+                    $vals[] = trim($fv['value']);
+                }
+            }
+            if (empty($vals)) {
+                continue;
+            }
+
+            // Multiple values: join with comma
+            $value = implode(', ', array_values(array_unique($vals)));
+
+            // Unit/symbol from Buerklin feature
+            $unit = $f['featureUnit']['symbol'] ?? null;
+            if (!is_string($unit) || trim($unit) === '') {
+                $unit = null;
+            }
+
+            // ParameterDTO parses value field (handles value + unit)
+            $out[] = ParameterDTO::parseValueField(
+                name: $name,
+                value: $value,
+                unit: $unit,
+                symbol: null,
+                group: $group
+            );
+        }
+
+        // Deduplicate by name
+        $byName = [];
+        foreach ($out as $p) {
+            $byName[$p->name] ??= $p;
+        }
+
+        return array_values($byName);
+    }
+
+    /**
+     * @return PartDetailDTO[]
+     */
+    public function searchByKeyword(string $keyword): array
+    {
+        $keyword = strtoupper(trim($keyword));
+        if ($keyword === '') {
+            return [];
+        }
+
+        $response = $this->makeAPICall('/products/search/', [
+            'pageSize' => 50,
+            'currentPage' => 0,
+            'query' => $keyword,
+            'sort' => 'relevance',
+        ]);
+
+        $products = $response['products'] ?? [];
+
+        // Normal case: products found in search results
+        if (is_array($products) && !empty($products)) {
+            return array_map(fn($p) => $this->getPartDetail($p), $products);
+        }
+
+        // Fallback: try direct lookup by code
+        try {
+            $product = $this->getProduct($keyword);
+            return [$this->getPartDetail($product)];
+        } catch (\Throwable $e) {
+            return [];
+        }
+    }
+
+    public function getDetails(string $id): PartDetailDTO
+    {
+        // Detail endpoint is /products/{code}/
+        $response = $this->getProduct($id);
+
+        return $this->getPartDetail($response);
+    }
+
+    public function getCapabilities(): array
+    {
+        return [
+            ProviderCapabilities::BASIC,
+            ProviderCapabilities::PICTURE,
+                //ProviderCapabilities::DATASHEET, // currently not implemented
+            ProviderCapabilities::PRICE,
+            ProviderCapabilities::FOOTPRINT,
+        ];
+    }
+
+    private function complianceToParameters(array $product, ?string $group = 'Compliance'): array
+    {
+        $params = [];
+
+        $add = function (string $name, $value) use (&$params, $group) {
+            if ($value === null) {
+                return;
+            }
+
+            if (is_bool($value)) {
+                $value = $value ? 'Yes' : 'No';
+            } elseif (is_array($value) || is_object($value)) {
+                // Avoid dumping large or complex structures
+                return;
+            } else {
+                $value = trim((string) $value);
+                if ($value === '') {
+                    return;
+                }
+            }
+
+            $params[] = ParameterDTO::parseValueField(
+                name: $name,
+                value: (string) $value,
+                unit: null,
+                symbol: null,
+                group: $group
+            );
+        };
+
+        $add('RoHS conform', $product['labelRoHS'] ?? null);          // "yes"/"no"
+
+        $rawRoHsDate = $product['dateRoHS'] ?? null;
+        // Try to parse and reformat date to Y-m-d (do not use language-dependent formats)
+        if (is_string($rawRoHsDate) && $rawRoHsDate !== '') {
+            try {
+                $dt = new \DateTimeImmutable($rawRoHsDate);
+                $formatted = $dt->format('Y-m-d');
+            } catch (\Exception $e) {
+                $formatted = $rawRoHsDate;
+            }
+            // Always use the same parameter name (do not use language-dependent names)
+            $add('RoHS date', $formatted);
+        }
+        $add('SVHC free', $product['SVHC'] ?? null);               // bool
+        $add('Hazardous good', $product['hazardousGood'] ?? null);       // bool
+        $add('Hazardous materials', $product['hazardousMaterials'] ?? null); // bool
+
+        $add('Country of origin', $product['countryOfOrigin'] ?? null);
+        // Customs tariff code must always be stored as string, otherwise "85411000" may be stored as "8.5411e+7"
+        if (isset($product['articleCustomsCode'])) {
+            // Raw value as string
+            $codeRaw = (string) $product['articleCustomsCode'];
+
+            // Optionally keep only digits (in case of spaces or other characters)
+            $code = preg_replace('/\D/', '', $codeRaw) ?? $codeRaw;
+            $code = trim($code);
+
+            if ($code !== '') {
+                $params[] = new ParameterDTO(
+                    name: 'Customs code',
+                    value_text: $code,
+                    value_typ: null,
+                    value_min: null,
+                    value_max: null,
+                    unit: null,
+                    symbol: null,
+                    group: $group
+                );
+            }
+        }
+
+        return $params;
+    }
+
+    /**
+     * @param string[] $keywords
+     * @return array<string, SearchResultDTO[]>
+     */
+    public function searchByKeywordsBatch(array $keywords): array
+    {
+        /** @var array<string, SearchResultDTO[]> $results */
+        $results = [];
+
+        foreach ($keywords as $keyword) {
+            $keyword = strtoupper(trim((string) $keyword));
+            if ($keyword === '') {
+                continue;
+            }
+
+            // Reuse existing single search -> returns PartDetailDTO[]
+            /** @var PartDetailDTO[] $partDetails */
+            $partDetails = $this->searchByKeyword($keyword);
+
+            // Convert to SearchResultDTO[]
+            $results[$keyword] = array_map(
+                fn(PartDetailDTO $detail) => $this->convertPartDetailToSearchResult($detail),
+                $partDetails
+            );
+        }
+
+        return $results;
+    }
+
+    /**
+     * Converts a PartDetailDTO into a SearchResultDTO for bulk search.
+     */
+    private function convertPartDetailToSearchResult(PartDetailDTO $detail): SearchResultDTO
+    {
+        return new SearchResultDTO(
+            provider_key: $detail->provider_key,
+            provider_id: $detail->provider_id,
+            name: $detail->name,
+            description: $detail->description ?? '',
+            category: $detail->category ?? null,
+            manufacturer: $detail->manufacturer ?? null,
+            mpn: $detail->mpn ?? null,
+            preview_image_url: $detail->preview_image_url ?? null,
+            manufacturing_status: $detail->manufacturing_status ?? null,
+            provider_url: $detail->provider_url ?? null,
+            footprint: $detail->footprint ?? null,
+        );
+    }
+
+}

src/Services/InfoProviderSystem/Providers/DigikeyProvider.php

@@ -311,6 +311,14 @@ class DigikeyProvider implements InfoProviderInterface
             'auth_bearer' => $this->authTokenManager->getAlwaysValidTokenString(self::OAUTH_APP_NAME)
         ]);
 
+        if ($response->getStatusCode() === 404) {
+            //No media found
+            return [
+                'datasheets' => [],
+                'images' => [],
+            ];
+        }
+
         $media_array = $response->toArray();
 
         foreach ($media_array['MediaLinks'] as $media_link) {

src/Services/InfoProviderSystem/Providers/OEMSecretsProvider.php

@@ -397,13 +397,13 @@ class OEMSecretsProvider implements InfoProviderInterface
      * Generates a cache key for storing part details based on the provided provider ID.
      *
      * This method creates a unique cache key by prefixing the provider ID with 'part_details_'
-     * and hashing the provider ID using MD5 to ensure a consistent and compact key format.
+     * and hashing the provider ID using XXH3 to ensure a consistent and compact key format.
      *
      * @param string $provider_id The unique identifier of the provider or part.
      * @return string The generated cache key.
      */
     private function getCacheKey(string $provider_id): string {
-        return 'oemsecrets_part_' . md5($provider_id);
+        return 'oemsecrets_part_' . hash('xxh3', $provider_id);
     }
 
 

src/Services/InfoProviderSystem/Providers/PollinProvider.php

@@ -248,4 +248,4 @@ class PollinProvider implements InfoProviderInterface
             ProviderCapabilities::DATASHEET
         ];
     }
-}
+}

src/Services/InfoProviderSystem/Providers/ProviderCapabilities.php

@@ -31,9 +31,6 @@ enum ProviderCapabilities
     /** Basic information about a part, like the name, description, part number, manufacturer etc */
     case BASIC;
 
-    /** Information about the footprint of a part */
-    case FOOTPRINT;
-
     /** Provider can provide a picture for a part */
     case PICTURE;
 
@@ -43,6 +40,24 @@ enum ProviderCapabilities
     /** Provider can provide prices for a part */
     case PRICE;
 
+    /** Information about the footprint of a part */
+    case FOOTPRINT;
+
+    /**
+     * Get the order index for displaying capabilities in a stable order.
+     * @return int
+     */
+    public function getOrderIndex(): int
+    {
+        return match($this) {
+            self::BASIC => 1,
+            self::PICTURE => 2,
+            self::DATASHEET => 3,
+            self::PRICE => 4,
+            self::FOOTPRINT => 5,
+        };
+    }
+
     public function getTranslationKey(): string
     {
         return 'info_providers.capabilities.' . match($this) {

src/Settings/InfoProviderSystem/BuerklinSettings.php

@@ -0,0 +1,84 @@
+<?php
+/*
+ * This file is part of Part-DB (https://github.com/Part-DB/Part-DB-symfony).
+ *
+ *  Copyright (C) 2019 - 2025 Jan Böhmer (https://github.com/jbtronics)
+ *  Copyright (C) 2025 Marc Kreidler (https://github.com/mkne)
+ *
+ *  This program is free software: you can redistribute it and/or modify
+ *  it under the terms of the GNU Affero General Public License as published
+ *  by the Free Software Foundation, either version 3 of the License, or
+ *  (at your option) any later version.
+ *
+ *  This program is distributed in the hope that it will be useful,
+ *  but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ *  GNU Affero General Public License for more details.
+ *
+ *  You should have received a copy of the GNU Affero General Public License
+ *  along with this program.  If not, see <https://www.gnu.org/licenses/>.
+ */
+
+declare(strict_types=1);
+
+
+namespace App\Settings\InfoProviderSystem;
+
+use App\Form\Type\APIKeyType;
+use App\Settings\SettingsIcon;
+use Jbtronics\SettingsBundle\Metadata\EnvVarMode;
+use Jbtronics\SettingsBundle\Settings\Settings;
+use Jbtronics\SettingsBundle\Settings\SettingsTrait;
+use Symfony\Component\Form\Extension\Core\Type\CountryType;
+use Symfony\Component\Form\Extension\Core\Type\CurrencyType;
+use Symfony\Component\Form\Extension\Core\Type\LanguageType;
+use Symfony\Component\Translation\TranslatableMessage as TM;
+use Jbtronics\SettingsBundle\Settings\SettingsParameter;
+use Symfony\Component\Validator\Constraints as Assert;
+
+#[Settings(label: new TM("settings.ips.buerklin"), description: new TM("settings.ips.buerklin.help"))]
+#[SettingsIcon("fa-plug")]
+class BuerklinSettings
+{
+    use SettingsTrait;
+
+    #[SettingsParameter(
+        label: new TM("settings.ips.digikey.client_id"),
+        formType: APIKeyType::class,
+        envVar: "PROVIDER_BUERKLIN_CLIENT_ID", envVarMode: EnvVarMode::OVERWRITE
+    )]
+    public ?string $clientId = null;
+
+    #[SettingsParameter(
+        label: new TM("settings.ips.digikey.secret"),
+        formType: APIKeyType::class,
+        envVar: "PROVIDER_BUERKLIN_SECRET", envVarMode: EnvVarMode::OVERWRITE
+    )]
+    public ?string $secret = null;
+
+        #[SettingsParameter(
+        label: new TM("settings.ips.buerklin.username"),
+        formType: APIKeyType::class,
+        envVar: "PROVIDER_BUERKLIN_USER", envVarMode: EnvVarMode::OVERWRITE
+    )]
+    public ?string $username = null;
+
+        #[SettingsParameter(
+        label: new TM("user.edit.password"),
+        formType: APIKeyType::class,
+        envVar: "PROVIDER_BUERKLIN_PASSWORD", envVarMode: EnvVarMode::OVERWRITE
+    )]
+    public ?string $password = null;
+
+    #[SettingsParameter(label: new TM("settings.ips.tme.currency"), formType: CurrencyType::class,
+        formOptions: ["preferred_choices" => ["EUR"]],
+        envVar: "PROVIDER_BUERKLIN_CURRENCY", envVarMode: EnvVarMode::OVERWRITE)]
+    #[Assert\Currency()]
+    public string $currency = "EUR";
+
+    #[SettingsParameter(label: new TM("settings.ips.tme.language"), formType: LanguageType::class,
+                        formOptions: ["preferred_choices" => ["en", "de"]],
+        envVar: "PROVIDER_BUERKLIN_LANGUAGE", envVarMode: EnvVarMode::OVERWRITE)]
+    #[Assert\Language]
+    public string $language = "en";
+}

src/Settings/InfoProviderSystem/InfoProviderSettings.php

@@ -63,4 +63,7 @@ class InfoProviderSettings
 
     #[EmbeddedSettings]
     public ?PollinSettings $pollin = null;
+    
+    #[EmbeddedSettings]
+    public ?BuerklinSettings $buerklin = null;
 }

templates/info_providers/providers.macro.html.twig

@@ -27,7 +27,7 @@
                                    title="{% trans %}info_providers.settings.title{% endtrans %}"
                                 ><i class="fa-solid fa-cog"></i></a>
                             {% endif %}
-                            {% for capability in provider.capabilities %}
+                            {% for capability in provider.capabilities|sort((a, b) => a.orderIndex <=> b.orderIndex) %}
                                 {# @var capability \App\Services\InfoProviderSystem\Providers\ProviderCapabilities #}
                                 <span class="badge text-bg-secondary">
                                     <i class="{{ capability.fAIconClass }} fa-fw"></i>

templates/label_system/dialog.html.twig

@@ -135,8 +135,8 @@
 
 {% block additional_content %}
     {% if pdf_data %}
-        <div class="card mt-2 p-1 border-secondary" style="resize: vertical; overflow: scroll; height: 250px">
-            <object id="pdf_preview"  data="{{ pdf_data | data_uri(mime='application/pdf') }}"style="height: inherit">
+        <div class="card mt-2 p-1 border-secondary" style="resize: vertical; overflow: scroll; height: 280px">
+            <object id="pdf_preview"  data="{{ pdf_data | data_uri(mime='application/pdf') }}" style="height: inherit">
             </object>
         </div>
     {% endif %}

tests/Services/InfoProviderSystem/Providers/BuerklinProviderTest.php

@@ -0,0 +1,271 @@
+<?php
+
+declare(strict_types=1);
+
+namespace App\Tests\Services\InfoProviderSystem\Providers;
+
+use App\Services\InfoProviderSystem\DTOs\PartDetailDTO;
+use App\Services\InfoProviderSystem\DTOs\SearchResultDTO;
+use App\Services\InfoProviderSystem\Providers\BuerklinProvider;
+use App\Settings\InfoProviderSystem\BuerklinSettings;
+use PHPUnit\Framework\TestCase;
+use Psr\Cache\CacheItemInterface;
+use Psr\Cache\CacheItemPoolInterface;
+use Symfony\Contracts\HttpClient\HttpClientInterface;
+use Symfony\Contracts\HttpClient\ResponseInterface;
+
+/**
+ * Full behavioral test suite for BuerklinProvider.
+ * Includes parameter parsing, compliance parsing, images, prices and batch mode.
+ */
+class BuerklinProviderTest extends TestCase
+{
+    private HttpClientInterface $httpClient;
+    private CacheItemPoolInterface $cache;
+    private BuerklinSettings $settings;
+    private BuerklinProvider $provider;
+
+    protected function setUp(): void
+    {
+        $this->httpClient = $this->createMock(HttpClientInterface::class);
+
+        // Cache mock
+        $cacheItem = $this->createMock(CacheItemInterface::class);
+        $cacheItem->method('isHit')->willReturn(false);
+        $cacheItem->method('set')->willReturn($cacheItem);
+
+        $this->cache = $this->createMock(CacheItemPoolInterface::class);
+        $this->cache->method('getItem')->willReturn($cacheItem);
+
+        // IMPORTANT: Settings must not be instantiated directly (SettingsBundle forbids constructor)
+        $ref = new \ReflectionClass(BuerklinSettings::class);
+        /** @var BuerklinSettings $settings */
+        $settings = $ref->newInstanceWithoutConstructor();
+
+        $settings->clientId = 'CID';
+        $settings->secret = 'SECRET';
+        $settings->username = 'USER';
+        $settings->password = 'PASS';
+        $settings->language = 'en';
+        $settings->currency = 'EUR';
+
+        $this->settings = $settings;
+
+        $this->provider = new BuerklinProvider(
+            client: $this->httpClient,
+            partInfoCache: $this->cache,
+            settings: $this->settings,
+        );
+    }
+
+    private function mockApi(string $expectedUrl, array $jsonResponse): void
+    {
+        $response = $this->createMock(ResponseInterface::class);
+        $response->method('toArray')->willReturn($jsonResponse);
+
+        $this->httpClient
+            ->method('request')
+            ->with(
+                'GET',
+                $this->callback(fn($url) => str_contains((string) $url, $expectedUrl)),
+                $this->anything()
+            )
+            ->willReturn($response);
+    }
+
+    public function testAttributesToParametersParsesUnitsAndValues(): void
+    {
+        $method = new \ReflectionMethod(BuerklinProvider::class, 'attributesToParameters');
+        $method->setAccessible(true);
+
+        $features = [
+            [
+                'name' => 'Zener voltage',
+                'featureUnit' => ['symbol' => 'V'],
+                'featureValues' => [
+                    ['value' => '12']
+                ]
+            ],
+            [
+                'name' => 'Length',
+                'featureUnit' => ['symbol' => 'mm'],
+                'featureValues' => [
+                    ['value' => '2.9']
+                ]
+            ],
+            [
+                'name' => 'Assembly',
+                'featureUnit' => [],
+                'featureValues' => [
+                    ['value' => 'SMD']
+                ]
+            ]
+        ];
+
+        $params = $method->invoke($this->provider, $features, '');
+
+        $this->assertCount(3, $params);
+
+        $this->assertSame('Zener voltage', $params[0]->name);
+        $this->assertNull($params[0]->value_text);
+        $this->assertSame(12.0, $params[0]->value_typ);
+        $this->assertNull($params[0]->value_min);
+        $this->assertNull($params[0]->value_max);
+        $this->assertSame('V', $params[0]->unit);
+
+        $this->assertSame('Length', $params[1]->name);
+        $this->assertNull($params[1]->value_text);
+        $this->assertSame(2.9, $params[1]->value_typ);
+        $this->assertSame('mm', $params[1]->unit);
+
+        $this->assertSame('Assembly', $params[2]->name);
+        $this->assertSame('SMD', $params[2]->value_text);
+        $this->assertNull($params[2]->unit);
+    }
+
+    public function testComplianceParameters(): void
+    {
+        $method = new \ReflectionMethod(BuerklinProvider::class, 'complianceToParameters');
+        $method->setAccessible(true);
+
+        $product = [
+            'labelRoHS' => 'Yes',
+            'dateRoHS' => '2015-03-31T00:00+0000',
+            'SVHC' => true,
+            'hazardousGood' => false,
+            'hazardousMaterials' => false,
+            'countryOfOrigin' => 'China',
+            'articleCustomsCode' => '85411000'
+        ];
+
+        $params = $method->invoke($this->provider, $product, 'Compliance');
+
+        $map = [];
+        foreach ($params as $p) {
+            $map[$p->name] = $p->value_text;
+        }
+
+        $this->assertSame('Yes', $map['RoHS conform']);
+        $this->assertSame('2015-03-31', $map['RoHS date']);
+        $this->assertSame('Yes', $map['SVHC free']);
+        $this->assertSame('No', $map['Hazardous good']);
+        $this->assertSame('No', $map['Hazardous materials']);
+        $this->assertSame('China', $map['Country of origin']);
+        $this->assertSame('85411000', $map['Customs code']);
+    }
+
+    public function testImageSelectionPrefersZoomAndDeduplicates(): void
+    {
+        $method = new \ReflectionMethod(BuerklinProvider::class, 'getProductImages');
+        $method->setAccessible(true);
+
+        $images = [
+            ['format' => 'product', 'url' => '/img/a.webp'],
+            ['format' => 'zoom', 'url' => '/img/z.webp'],
+            ['format' => 'zoom', 'url' => '/img/z.webp'], // duplicate
+            ['format' => 'thumbnail', 'url' => '/img/t.webp']
+        ];
+
+        $results = $method->invoke($this->provider, $images);
+
+        $this->assertCount(1, $results);
+        $this->assertSame('https://www.buerklin.com/img/z.webp', $results[0]->url);
+    }
+
+    public function testFootprintExtraction(): void
+    {
+        $method = new \ReflectionMethod(BuerklinProvider::class, 'getPartDetail');
+        $method->setAccessible(true);
+
+        $product = [
+            'code' => 'TEST1',
+            'manufacturerProductId' => 'ABC',
+            'description' => 'X',
+            'images' => [],
+            'classifications' => [
+                [
+                    'name' => 'Cat',
+                    'features' => [
+                        [
+                            'name' => 'Enclosure',
+                            'featureValues' => [['value' => 'SOT-23']]
+                        ]
+                    ]
+                ]
+            ],
+            'price' => ['value' => 1, 'currencyIso' => 'EUR']
+        ];
+
+        $dto = $method->invoke($this->provider, $product);
+        $this->assertSame('SOT-23', $dto->footprint);
+    }
+
+    public function testPriceFormatting(): void
+    {
+        $detailPrice = [
+            [
+                'minQuantity' => 1,
+                'value' => 0.0885,
+                'currencyIso' => 'EUR'
+            ]
+        ];
+
+        $method = new \ReflectionMethod(BuerklinProvider::class, 'pricesToVendorInfo');
+        $method->setAccessible(true);
+
+        $vendorInfo = $method->invoke($this->provider, 'SKU1', 'https://x', $detailPrice);
+
+        $price = $vendorInfo[0]->prices[0];
+        $this->assertSame('0.0885', $price->price);
+    }
+
+    public function testBatchSearchReturnsSearchResultDTO(): void
+    {
+        $mockDetail = new PartDetailDTO(
+            provider_key: 'buerklin',
+            provider_id: 'TESTID',
+            name: 'Zener',
+            description: 'Desc'
+        );
+
+        $provider = $this->getMockBuilder(BuerklinProvider::class)
+            ->setConstructorArgs([
+                $this->httpClient,
+                $this->cache,
+                $this->settings
+            ])
+            ->onlyMethods(['searchByKeyword'])
+            ->getMock();
+
+        $provider->method('searchByKeyword')->willReturn([$mockDetail]);
+
+        $result = $provider->searchByKeywordsBatch(['ABC']);
+
+        $this->assertArrayHasKey('ABC', $result);
+        $this->assertIsArray($result['ABC']);
+        $this->assertCount(1, $result['ABC']);
+        $this->assertInstanceOf(SearchResultDTO::class, $result['ABC'][0]);
+        $this->assertSame('Zener', $result['ABC'][0]->name);
+    }
+
+    public function testConvertPartDetailToSearchResult(): void
+    {
+        $detail = new PartDetailDTO(
+            provider_key: 'buerklin',
+            provider_id: 'X1',
+            name: 'PartX',
+            description: 'D',
+            preview_image_url: 'https://img'
+        );
+
+        $method = new \ReflectionMethod(BuerklinProvider::class, 'convertPartDetailToSearchResult');
+        $method->setAccessible(true);
+
+        $dto = $method->invoke($this->provider, $detail);
+
+        $this->assertInstanceOf(SearchResultDTO::class, $dto);
+        $this->assertSame('X1', $dto->provider_id);
+        $this->assertSame('PartX', $dto->name);
+        $this->assertSame('https://img', $dto->preview_image_url);
+    }
+}

translations/messages.de.xlf

@@ -1,4 +1,4 @@
-<?xml version='1.0' encoding='utf-8'?>
+<?xml version="1.0" encoding="utf-8"?>
 <xliff xmlns="urn:oasis:names:tc:xliff:document:2.0" version="2.0" srcLang="en" trgLang="de">
   <file id="messages.de">
     <unit id="x_wTSQS" name="attachment_type.caption">
@@ -231,7 +231,7 @@
       </notes>
       <segment state="translated">
         <source>part.info.timetravel_hint</source>
-        <target>So sah das Bauteil vor %timestamp% aus. &lt;i&gt;Beachten Sie, dass dieses Feature experimentell ist und die angezeigten Infos daher nicht unbedingt korrekt sind.&lt;/i&gt;</target>
+        <target><![CDATA[So sah das Bauteil vor %timestamp% aus. <i>Beachten Sie, dass dieses Feature experimentell ist und die angezeigten Infos daher nicht unbedingt korrekt sind.</i>]]></target>
       </segment>
     </unit>
     <unit id="3exvSpl" name="standard.label">
@@ -537,7 +537,7 @@
         <target>Maßeinheit</target>
       </segment>
     </unit>
-    <unit id="3bcKBzY" name="part_custom_state.caption">
+    <unit id="IqR.a4n" name="part_custom_state.caption">
       <segment state="translated">
         <source>part_custom_state.caption</source>
         <target>Benutzerdefinierter Bauteilstatus</target>
@@ -715,9 +715,9 @@
       </notes>
       <segment state="translated">
         <source>user.edit.tfa.disable_tfa_message</source>
-        <target>Dies wird &lt;b&gt;alle aktiven Zwei-Faktor-Authentifizierungsmethoden des Nutzers deaktivieren&lt;/b&gt; und die &lt;b&gt;Backupcodes löschen&lt;/b&gt;! &lt;br&gt;
-Der Benutzer wird alle Zwei-Faktor-Authentifizierungmethoden neu einrichten müssen und neue Backupcodes ausdrucken müssen! &lt;br&gt;&lt;br&gt;
-&lt;b&gt;Führen sie dies nur durch, wenn Sie über die Identität des (um Hilfe suchenden) Benutzers absolut sicher sind, da ansonsten eine Kompromittierung des Accounts durch einen Angreifer erfolgen könnte!&lt;/b&gt;</target>
+        <target><![CDATA[Dies wird <b>alle aktiven Zwei-Faktor-Authentifizierungsmethoden des Nutzers deaktivieren</b> und die <b>Backupcodes löschen</b>! <br>
+Der Benutzer wird alle Zwei-Faktor-Authentifizierungmethoden neu einrichten müssen und neue Backupcodes ausdrucken müssen! <br><br>
+<b>Führen sie dies nur durch, wenn Sie über die Identität des (um Hilfe suchenden) Benutzers absolut sicher sind, da ansonsten eine Kompromittierung des Accounts durch einen Angreifer erfolgen könnte!</b>]]></target>
       </segment>
     </unit>
     <unit id="APsHYu0" name="user.edit.tfa.disable_tfa.btn">
@@ -1424,7 +1424,7 @@ Subelemente werden beim Löschen nach oben verschoben.</target>
       </notes>
       <segment state="translated">
         <source>homepage.github.text</source>
-        <target>Quellcode, Downloads, Bugreports, ToDo-Liste usw. gibts auf der &lt;a class="link-external" target="_blank" href="%href%"&gt;GitHub Projektseite&lt;/a&gt;</target>
+        <target><![CDATA[Quellcode, Downloads, Bugreports, ToDo-Liste usw. gibts auf der <a class="link-external" target="_blank" href="%href%">GitHub Projektseite</a>]]></target>
       </segment>
     </unit>
     <unit id="D5OKsgU" name="homepage.help.caption">
@@ -1446,7 +1446,7 @@ Subelemente werden beim Löschen nach oben verschoben.</target>
       </notes>
       <segment state="translated">
         <source>homepage.help.text</source>
-        <target>Hilfe und Tipps finden sie im &lt;a class="link-external" rel="noopener" target="_blank" href="%href%"&gt;Wiki&lt;/a&gt; der GitHub Seite.</target>
+        <target><![CDATA[Hilfe und Tipps finden sie im <a class="link-external" rel="noopener" target="_blank" href="%href%">Wiki</a> der GitHub Seite.]]></target>
       </segment>
     </unit>
     <unit id="dnirx4v" name="homepage.forum.caption">
@@ -1688,7 +1688,7 @@ Subelemente werden beim Löschen nach oben verschoben.</target>
       </notes>
       <segment state="translated">
         <source>email.pw_reset.fallback</source>
-        <target>Wenn dies nicht funktioniert, rufen Sie &lt;a href="%url%"&gt;%url%&lt;/a&gt; auf und geben Sie die folgenden Daten ein</target>
+        <target><![CDATA[Wenn dies nicht funktioniert, rufen Sie <a href="%url%">%url%</a> auf und geben Sie die folgenden Daten ein]]></target>
       </segment>
     </unit>
     <unit id="DduL9Hu" name="email.pw_reset.username">
@@ -1718,7 +1718,7 @@ Subelemente werden beim Löschen nach oben verschoben.</target>
       </notes>
       <segment state="translated">
         <source>email.pw_reset.valid_unit %date%</source>
-        <target>Das Reset-Token ist gültig bis &lt;i&gt;%date%&lt;/i&gt;</target>
+        <target><![CDATA[Das Reset-Token ist gültig bis <i>%date%</i>]]></target>
       </segment>
     </unit>
     <unit id="8sBnjRy" name="orderdetail.delete">
@@ -3591,8 +3591,8 @@ Subelemente werden beim Löschen nach oben verschoben.</target>
       </notes>
       <segment state="translated">
         <source>tfa_google.disable.confirm_message</source>
-        <target>Wenn Sie die Authenticator App deaktivieren, werden alle Backupcodes gelöscht, daher sie müssen sie evtl. neu ausdrucken.&lt;br&gt;
-Beachten Sie außerdem, dass ihr Account ohne Zwei-Faktor-Authentifizierung nicht mehr so gut gegen Angreifer geschützt ist!</target>
+        <target><![CDATA[Wenn Sie die Authenticator App deaktivieren, werden alle Backupcodes gelöscht, daher sie müssen sie evtl. neu ausdrucken.<br>
+Beachten Sie außerdem, dass ihr Account ohne Zwei-Faktor-Authentifizierung nicht mehr so gut gegen Angreifer geschützt ist!]]></target>
       </segment>
     </unit>
     <unit id="yu9MSt5" name="tfa_google.disabled_message">
@@ -3612,7 +3612,7 @@ Beachten Sie außerdem, dass ihr Account ohne Zwei-Faktor-Authentifizierung nich
       </notes>
       <segment state="translated">
         <source>tfa_google.step.download</source>
-        <target>Laden Sie eine Authenticator App herunter (z.B. &lt;a class="link-external" target="_blank" href="https://play.google.com/store/apps/details?id=com.google.android.apps.authenticator2"&gt;Google Authenticator&lt;/a&gt; oder &lt;a class="link-external" target="_blank" href="https://play.google.com/store/apps/details?id=org.fedorahosted.freeotp"&gt;FreeOTP Authenticator&lt;/a&gt;)</target>
+        <target><![CDATA[Laden Sie eine Authenticator App herunter (z.B. <a class="link-external" target="_blank" href="https://play.google.com/store/apps/details?id=com.google.android.apps.authenticator2">Google Authenticator</a> oder <a class="link-external" target="_blank" href="https://play.google.com/store/apps/details?id=org.fedorahosted.freeotp">FreeOTP Authenticator</a>)]]></target>
       </segment>
     </unit>
     <unit id="eriwJoR" name="tfa_google.step.scan">
@@ -3854,8 +3854,8 @@ Beachten Sie außerdem, dass ihr Account ohne Zwei-Faktor-Authentifizierung nich
       </notes>
       <segment state="translated">
         <source>tfa_trustedDevices.explanation</source>
-        <target>Bei der Überprüfung des zweiten Faktors, kann der aktuelle Computer als vertrauenswürdig gekennzeichnet werden, daher werden keine Zwei-Faktor-Überprüfungen mehr an diesem Computer benötigt.
-Wenn Sie dies fehlerhafterweise gemacht haben oder ein Computer nicht mehr vertrauenswürdig ist, können Sie hier den Status &lt;i&gt;aller &lt;/i&gt;Computer zurücksetzen.</target>
+        <target><![CDATA[Bei der Überprüfung des zweiten Faktors, kann der aktuelle Computer als vertrauenswürdig gekennzeichnet werden, daher werden keine Zwei-Faktor-Überprüfungen mehr an diesem Computer benötigt.
+Wenn Sie dies fehlerhafterweise gemacht haben oder ein Computer nicht mehr vertrauenswürdig ist, können Sie hier den Status <i>aller </i>Computer zurücksetzen.]]></target>
       </segment>
     </unit>
     <unit id="FZINq8z" name="tfa_trustedDevices.invalidate.confirm_title">
@@ -4813,7 +4813,7 @@ Wenn Sie dies fehlerhafterweise gemacht haben oder ein Computer nicht mehr vertr
         <target>Maßeinheit</target>
       </segment>
     </unit>
-    <unit id="G1hmQdb" name="part.table.partCustomState">
+    <unit id="JjTO6Nq" name="part.table.partCustomState">
       <segment state="translated">
         <source>part.table.partCustomState</source>
         <target>Benutzerdefinierter Bauteilstatus</target>
@@ -5301,7 +5301,7 @@ Wenn Sie dies fehlerhafterweise gemacht haben oder ein Computer nicht mehr vertr
       </notes>
       <segment state="translated">
         <source>label_options.lines_mode.help</source>
-        <target>Wenn Sie hier Twig auswählen, wird das Contentfeld als Twig-Template interpretiert. Weitere Hilfe gibt es in der &lt;a href="https://twig.symfony.com/doc/3.x/templates.html"&gt;Twig Dokumentation&lt;/a&gt; und dem &lt;a href="https://docs.part-db.de/usage/labels.html#twig-mode"&gt;Wiki&lt;/a&gt;.</target>
+        <target><![CDATA[Wenn Sie hier Twig auswählen, wird das Contentfeld als Twig-Template interpretiert. Weitere Hilfe gibt es in der <a href="https://twig.symfony.com/doc/3.x/templates.html">Twig Dokumentation</a> und dem <a href="https://docs.part-db.de/usage/labels.html#twig-mode">Wiki</a>.]]></target>
       </segment>
     </unit>
     <unit id="isvxbiX" name="label_options.page_size.label">
@@ -5683,7 +5683,7 @@ Wenn Sie dies fehlerhafterweise gemacht haben oder ein Computer nicht mehr vertr
         <target>Maßeinheit</target>
       </segment>
     </unit>
-    <unit id="kE1wJ1a" name="part.edit.partCustomState">
+    <unit id="ro8Iwr_" name="part.edit.partCustomState">
       <segment state="translated">
         <source>part.edit.partCustomState</source>
         <target>Benutzerdefinierter Bauteilstatus</target>
@@ -5976,7 +5976,7 @@ Wenn Sie dies fehlerhafterweise gemacht haben oder ein Computer nicht mehr vertr
         <target>Maßeinheit</target>
       </segment>
     </unit>
-    <unit id="a1mPcMw" name="part_custom_state.label">
+    <unit id="NpDx4rr" name="part_custom_state.label">
       <segment state="translated">
         <source>part_custom_state.label</source>
         <target>Benutzerdefinierter Bauteilstatus</target>
@@ -6225,7 +6225,7 @@ Wenn Sie dies fehlerhafterweise gemacht haben oder ein Computer nicht mehr vertr
         <target>[[Measurement_unit]]</target>
       </segment>
     </unit>
-    <unit id="5adacKb" name="tree.tools.edit.part_custom_state">
+    <unit id="oYLWbbv" name="tree.tools.edit.part_custom_state">
       <segment state="translated">
         <source>tree.tools.edit.part_custom_state</source>
         <target>[[Part_custom_state]]</target>
@@ -7149,15 +7149,15 @@ Wenn Sie dies fehlerhafterweise gemacht haben oder ein Computer nicht mehr vertr
       </notes>
       <segment state="translated">
         <source>mass_creation.lines.placeholder</source>
-        <target>Element 1
+        <target><![CDATA[Element 1
    Element 1.1
       Element 1.1.1
    Element 1.2
 Element 2
 Element 3
 
-Element 1 -&gt; Element 1.1
-Element 1 -&gt; Element 1.2</target>
+Element 1 -> Element 1.1
+Element 1 -> Element 1.2]]></target>
       </segment>
     </unit>
     <unit id="TWSqPFi" name="entity.mass_creation.btn">
@@ -8372,7 +8372,7 @@ Element 1 -&gt; Element 1.2</target>
         <target>Maßeinheiten</target>
       </segment>
     </unit>
-    <unit id="1b5ja1c" name="perm.part_custom_states">
+    <unit id="zckNn8G" name="perm.part_custom_states">
       <segment state="translated">
         <source>perm.part_custom_states</source>
         <target>Benutzerdefinierter Bauteilstatus</target>
@@ -9303,25 +9303,25 @@ Element 1 -&gt; Element 1.2</target>
     <unit id="r4vDLAt" name="filter.parameter_value_constraint.operator.&lt;">
       <segment state="translated">
         <source>filter.parameter_value_constraint.operator.&lt;</source>
-        <target>Typ. Wert &lt;</target>
+        <target><![CDATA[Typ. Wert <]]></target>
       </segment>
     </unit>
     <unit id="X9SA3UP" name="filter.parameter_value_constraint.operator.&gt;">
       <segment state="translated">
         <source>filter.parameter_value_constraint.operator.&gt;</source>
-        <target>Typ. Wert &gt;</target>
+        <target><![CDATA[Typ. Wert >]]></target>
       </segment>
     </unit>
     <unit id="BQGaoQS" name="filter.parameter_value_constraint.operator.&lt;=">
       <segment state="translated">
         <source>filter.parameter_value_constraint.operator.&lt;=</source>
-        <target>Typ. Wert &lt;=</target>
+        <target><![CDATA[Typ. Wert <=]]></target>
       </segment>
     </unit>
     <unit id="2ha3P6g" name="filter.parameter_value_constraint.operator.&gt;=">
       <segment state="translated">
         <source>filter.parameter_value_constraint.operator.&gt;=</source>
-        <target>Typ. Wert &gt;=</target>
+        <target><![CDATA[Typ. Wert >=]]></target>
       </segment>
     </unit>
     <unit id="4DaBace" name="filter.parameter_value_constraint.operator.BETWEEN">
@@ -9429,7 +9429,7 @@ Element 1 -&gt; Element 1.2</target>
     <unit id="4tHhDtU" name="parts_list.search.searching_for">
       <segment state="translated">
         <source>parts_list.search.searching_for</source>
-        <target>Suche Teile mit dem Suchbegriff &lt;b&gt;%keyword%&lt;/b&gt;</target>
+        <target><![CDATA[Suche Teile mit dem Suchbegriff <b>%keyword%</b>]]></target>
       </segment>
     </unit>
     <unit id="4vomKLa" name="parts_list.search_options.caption">
@@ -10089,13 +10089,13 @@ Element 1 -&gt; Element 1.2</target>
     <unit id="NdZ1t7a" name="project.builds.number_of_builds_possible">
       <segment state="translated">
         <source>project.builds.number_of_builds_possible</source>
-        <target>Sie haben genug Bauteile auf Lager, um &lt;b&gt;%max_builds%&lt;/b&gt; Exemplare dieses Projektes zu bauen.</target>
+        <target><![CDATA[Sie haben genug Bauteile auf Lager, um <b>%max_builds%</b> Exemplare dieses Projektes zu bauen.]]></target>
       </segment>
     </unit>
     <unit id="iuSpPbg" name="project.builds.check_project_status">
       <segment state="translated">
         <source>project.builds.check_project_status</source>
-        <target>Der aktuelle Projektstatus ist &lt;b&gt;"%project_status%"&lt;/b&gt;. Sie sollten überprüfen, ob sie das Projekt mit diesem Status wirklich bauen wollen!</target>
+        <target><![CDATA[Der aktuelle Projektstatus ist <b>"%project_status%"</b>. Sie sollten überprüfen, ob sie das Projekt mit diesem Status wirklich bauen wollen!]]></target>
       </segment>
     </unit>
     <unit id="Y7vSSxi" name="project.builds.following_bom_entries_miss_instock_n">
@@ -10209,7 +10209,7 @@ Element 1 -&gt; Element 1.2</target>
     <unit id="GzqIwHH" name="entity.select.add_hint">
       <segment state="translated">
         <source>entity.select.add_hint</source>
-        <target>Nutzen Sie -&gt; um verschachtelte Strukturen anzulegen, z.B. "Element 1-&gt;Element 1.1"</target>
+        <target><![CDATA[Nutzen Sie -> um verschachtelte Strukturen anzulegen, z.B. "Element 1->Element 1.1"]]></target>
       </segment>
     </unit>
     <unit id="S4CxO.T" name="entity.select.group.new_not_added_to_DB">
@@ -10233,13 +10233,13 @@ Element 1 -&gt; Element 1.2</target>
     <unit id="XLnXtsR" name="homepage.first_steps.introduction">
       <segment state="translated">
         <source>homepage.first_steps.introduction</source>
-        <target>Die Datenbank ist momentan noch leer. Sie möchten möglicherweise die &lt;a href="%url%"&gt;Dokumentation&lt;/a&gt; lesen oder anfangen, die folgenden Datenstrukturen anzulegen.</target>
+        <target><![CDATA[Die Datenbank ist momentan noch leer. Sie möchten möglicherweise die <a href="%url%">Dokumentation</a> lesen oder anfangen, die folgenden Datenstrukturen anzulegen.]]></target>
       </segment>
     </unit>
     <unit id="Q79MOIk" name="homepage.first_steps.create_part">
       <segment state="translated">
         <source>homepage.first_steps.create_part</source>
-        <target>Oder Sie können direkt ein &lt;a href="%url%"&gt;neues Bauteil erstellen&lt;/a&gt;.</target>
+        <target><![CDATA[Oder Sie können direkt ein <a href="%url%">neues Bauteil erstellen</a>.]]></target>
       </segment>
     </unit>
     <unit id="vplYq4f" name="homepage.first_steps.hide_hint">
@@ -10251,7 +10251,7 @@ Element 1 -&gt; Element 1.2</target>
     <unit id="MJoZl4f" name="homepage.forum.text">
       <segment state="translated">
         <source>homepage.forum.text</source>
-        <target>Für Fragen rund um Part-DB, nutze das &lt;a class="link-external" rel="noopener" target="_blank" href="%href%"&gt;Diskussionsforum&lt;/a&gt;</target>
+        <target><![CDATA[Für Fragen rund um Part-DB, nutze das <a class="link-external" rel="noopener" target="_blank" href="%href%">Diskussionsforum</a>]]></target>
       </segment>
     </unit>
     <unit id="YsukbnK" name="log.element_edited.changed_fields.category">
@@ -10752,7 +10752,7 @@ Element 1 -&gt; Element 1.2</target>
         <target>Maßeinheit</target>
       </segment>
     </unit>
-    <unit id="2COnw1k" name="log.element_edited.changed_fields.partCustomState">
+    <unit id="8QD.2.r" name="log.element_edited.changed_fields.partCustomState">
       <segment state="translated">
         <source>log.element_edited.changed_fields.partCustomState</source>
         <target>Benutzerdefinierter Bauteilstatus</target>
@@ -10917,7 +10917,7 @@ Element 1 -&gt; Element 1.2</target>
     <unit id="p_IxB9K" name="parts.import.help_documentation">
       <segment state="translated">
         <source>parts.import.help_documentation</source>
-        <target>Konsultieren Sie die &lt;a href="%link%"&gt;Dokumentation&lt;/a&gt; für weiter Informationen über das Dateiformat.</target>
+        <target><![CDATA[Konsultieren Sie die <a href="%link%">Dokumentation</a> für weiter Informationen über das Dateiformat.]]></target>
       </segment>
     </unit>
     <unit id="awbvhVq" name="parts.import.help">
@@ -11022,13 +11022,13 @@ Element 1 -&gt; Element 1.2</target>
         <target>Bearbeite [Measurement_unit]</target>
       </segment>
     </unit>
-    <unit id="ba52d.g" name="part_custom_state.new">
+    <unit id="Ae0GMtY" name="part_custom_state.new">
       <segment state="translated">
         <source>part_custom_state.new</source>
         <target>Neuer [Part_custom_state]</target>
       </segment>
     </unit>
-    <unit id="c1.gb2d" name="part_custom_state.edit">
+    <unit id="5uZ23wR" name="part_custom_state.edit">
       <segment state="translated">
         <source>part_custom_state.edit</source>
         <target>Bearbeite [Part_custom_state]</target>
@@ -11109,7 +11109,7 @@ Element 1 -&gt; Element 1.2</target>
     <unit id="o5u.Nnz" name="part.filter.lessThanDesired">
       <segment state="translated">
         <source>part.filter.lessThanDesired</source>
-        <target>Weniger vorhanden als gewünscht (Gesamtmenge &lt; Mindestmenge)</target>
+        <target><![CDATA[Weniger vorhanden als gewünscht (Gesamtmenge < Mindestmenge)]]></target>
       </segment>
     </unit>
     <unit id="YN9eLcZ" name="part.filter.lotOwner">
@@ -11915,13 +11915,13 @@ Bitte beachten Sie, dass Sie sich nicht als deaktivierter Benutzer ausgeben kön
     <unit id="i68lU5x" name="part.merge.confirm.title">
       <segment state="translated">
         <source>part.merge.confirm.title</source>
-        <target>Möchten Sie wirklich &lt;b&gt;%other%&lt;/b&gt; in &lt;b&gt;%target%&lt;/b&gt; zusammenführen?</target>
+        <target><![CDATA[Möchten Sie wirklich <b>%other%</b> in <b>%target%</b> zusammenführen?]]></target>
       </segment>
     </unit>
     <unit id="k0anzYV" name="part.merge.confirm.message">
       <segment state="translated">
         <source>part.merge.confirm.message</source>
-        <target>&lt;b&gt;%other%&lt;/b&gt; wird gelöscht, und das aktuelle Bauteil wird mit den angezeigten Daten gespeichert.</target>
+        <target><![CDATA[<b>%other%</b> wird gelöscht, und das aktuelle Bauteil wird mit den angezeigten Daten gespeichert.]]></target>
       </segment>
     </unit>
     <unit id="mmW5Yl1" name="part.info.merge_modal.title">
@@ -12275,7 +12275,7 @@ Bitte beachten Sie, dass Sie sich nicht als deaktivierter Benutzer ausgeben kön
     <unit id="p7LGAIX" name="settings.ips.element14.apiKey.help">
       <segment state="translated">
         <source>settings.ips.element14.apiKey.help</source>
-        <target>Sie können sich unter &lt;a href="https://partner.element14.com/"&gt;https://partner.element14.com/&lt;/a&gt; für einen API-Schlüssel registrieren.</target>
+        <target><![CDATA[Sie können sich unter <a href="https://partner.element14.com/">https://partner.element14.com/</a> für einen API-Schlüssel registrieren.]]></target>
       </segment>
     </unit>
     <unit id="ZdUHpZc" name="settings.ips.element14.storeId">
@@ -12287,7 +12287,7 @@ Bitte beachten Sie, dass Sie sich nicht als deaktivierter Benutzer ausgeben kön
     <unit id="XXGUxF6" name="settings.ips.element14.storeId.help">
       <segment state="translated">
         <source>settings.ips.element14.storeId.help</source>
-        <target>Die Domain des Shops, aus dem die Daten abgerufen werden sollen. Diese bestimmt die Sprache und Währung der Ergebnisse. Eine Liste der gültigen Domains finden Sie &lt;a href="https://partner.element14.com/docs/Product_Search_API_REST__Description"&gt;hier&lt;/a&gt;.</target>
+        <target><![CDATA[Die Domain des Shops, aus dem die Daten abgerufen werden sollen. Diese bestimmt die Sprache und Währung der Ergebnisse. Eine Liste der gültigen Domains finden Sie <a href="https://partner.element14.com/docs/Product_Search_API_REST__Description">hier</a>.]]></target>
       </segment>
     </unit>
     <unit id="WKWZIm2" name="settings.ips.tme">
@@ -12305,7 +12305,7 @@ Bitte beachten Sie, dass Sie sich nicht als deaktivierter Benutzer ausgeben kön
     <unit id="_pYLrPT" name="settings.ips.tme.token.help">
       <segment state="translated">
         <source>settings.ips.tme.token.help</source>
-        <target>Sie können einen API-Token und einen geheimen Schlüssel unter &lt;a href="https://developers.tme.eu/en/"&gt;https://developers.tme.eu/en/&lt;/a&gt; erhalten.</target>
+        <target><![CDATA[Sie können einen API-Token und einen geheimen Schlüssel unter <a href="https://developers.tme.eu/en/">https://developers.tme.eu/en/</a> erhalten.]]></target>
       </segment>
     </unit>
     <unit id="yswx4bq" name="settings.ips.tme.secret">
@@ -12353,7 +12353,7 @@ Bitte beachten Sie, dass Sie sich nicht als deaktivierter Benutzer ausgeben kön
     <unit id="gu.JlpT" name="settings.ips.mouser.apiKey.help">
       <segment state="translated">
         <source>settings.ips.mouser.apiKey.help</source>
-        <target>Sie können sich unter &lt;a href="https://eu.mouser.com/api-hub/"&gt;https://eu.mouser.com/api-hub/&lt;/a&gt; für einen API-Schlüssel registrieren.</target>
+        <target><![CDATA[Sie können sich unter <a href="https://eu.mouser.com/api-hub/">https://eu.mouser.com/api-hub/</a> für einen API-Schlüssel registrieren.]]></target>
       </segment>
     </unit>
     <unit id="Q66CNjw" name="settings.ips.mouser.searchLimit">
@@ -12401,7 +12401,7 @@ Bitte beachten Sie, dass Sie sich nicht als deaktivierter Benutzer ausgeben kön
     <unit id="xU8_Qw." name="settings.ips.mouser.searchOptions.rohsAndInStock">
       <segment state="translated">
         <source>settings.ips.mouser.searchOptions.rohsAndInStock</source>
-        <target>Sofort verfügbar &amp; RoHS konform</target>
+        <target><![CDATA[Sofort verfügbar & RoHS konform]]></target>
       </segment>
     </unit>
     <unit id="fQYt0Om" name="settings.ips.lcsc">
@@ -12431,7 +12431,7 @@ Bitte beachten Sie, dass Sie sich nicht als deaktivierter Benutzer ausgeben kön
     <unit id="kKv0J3." name="settings.system.attachments">
       <segment state="translated">
         <source>settings.system.attachments</source>
-        <target>Anhänge &amp; Dateien</target>
+        <target><![CDATA[Anhänge & Dateien]]></target>
       </segment>
     </unit>
     <unit id="dsRff8T" name="settings.system.attachments.maxFileSize">
@@ -12455,7 +12455,7 @@ Bitte beachten Sie, dass Sie sich nicht als deaktivierter Benutzer ausgeben kön
     <unit id="T.PBu5P" name="settings.system.attachments.allowDownloads.help">
       <segment state="translated">
         <source>settings.system.attachments.allowDownloads.help</source>
-        <target>Mit dieser Option können Benutzer externe Dateien in die Part-DB herunterladen, indem sie eine URL angeben. &lt;b&gt;Achtung: Dies kann ein Sicherheitsrisiko darstellen, da Benutzer dadurch möglicherweise über die Part-DB auf Intranet-Ressourcen zugreifen können!&lt;/b&gt;</target>
+        <target><![CDATA[Mit dieser Option können Benutzer externe Dateien in die Part-DB herunterladen, indem sie eine URL angeben. <b>Achtung: Dies kann ein Sicherheitsrisiko darstellen, da Benutzer dadurch möglicherweise über die Part-DB auf Intranet-Ressourcen zugreifen können!</b>]]></target>
       </segment>
     </unit>
     <unit id=".OyihML" name="settings.system.attachments.downloadByDefault">
@@ -12629,8 +12629,8 @@ Bitte beachten Sie, dass Sie sich nicht als deaktivierter Benutzer ausgeben kön
     <unit id="0GRlEe5" name="settings.system.localization.base_currency_description">
       <segment state="translated">
         <source>settings.system.localization.base_currency_description</source>
-        <target>Die Währung, in der Preisinformationen und Wechselkurse gespeichert werden. Diese Währung wird angenommen, wenn für eine Preisinformation keine Währung festgelegt ist.
-&lt;b&gt;Bitte beachten Sie, dass die Währungen bei einer Änderung dieses Wertes nicht umgerechnet werden. Wenn Sie also die Basiswährung ändern, nachdem Sie bereits Preisinformationen hinzugefügt haben, führt dies zu falschen Preisen!&lt;/b&gt;</target>
+        <target><![CDATA[Die Währung, in der Preisinformationen und Wechselkurse gespeichert werden. Diese Währung wird angenommen, wenn für eine Preisinformation keine Währung festgelegt ist.
+<b>Bitte beachten Sie, dass die Währungen bei einer Änderung dieses Wertes nicht umgerechnet werden. Wenn Sie also die Basiswährung ändern, nachdem Sie bereits Preisinformationen hinzugefügt haben, führt dies zu falschen Preisen!</b>]]></target>
       </segment>
     </unit>
     <unit id="cvpTUeY" name="settings.system.privacy">
@@ -12660,7 +12660,7 @@ Bitte beachten Sie, dass Sie sich nicht als deaktivierter Benutzer ausgeben kön
     <unit id="w07P3Dt" name="settings.misc.kicad_eda.category_depth.help">
       <segment state="translated">
         <source>settings.misc.kicad_eda.category_depth.help</source>
-        <target>Dieser Wert bestimmt die Tiefe des Kategoriebaums, der in KiCad sichtbar ist. 0 bedeutet, dass nur die Kategorien der obersten Ebene sichtbar sind. Setzen Sie den Wert auf &gt; 0, um weitere Ebenen anzuzeigen. Setzen Sie den Wert auf -1, um alle Teile der Part-DB innerhalb einer einzigen Kategorie in KiCad anzuzeigen.</target>
+        <target><![CDATA[Dieser Wert bestimmt die Tiefe des Kategoriebaums, der in KiCad sichtbar ist. 0 bedeutet, dass nur die Kategorien der obersten Ebene sichtbar sind. Setzen Sie den Wert auf > 0, um weitere Ebenen anzuzeigen. Setzen Sie den Wert auf -1, um alle Teile der Part-DB innerhalb einer einzigen Kategorie in KiCad anzuzeigen.]]></target>
       </segment>
     </unit>
     <unit id="VwvmcWE" name="settings.behavior.sidebar">
@@ -12678,7 +12678,7 @@ Bitte beachten Sie, dass Sie sich nicht als deaktivierter Benutzer ausgeben kön
     <unit id="jc0JTvL" name="settings.behavior.sidebar.items.help">
       <segment state="translated">
         <source>settings.behavior.sidebar.items.help</source>
-        <target>Die Menüs, die standardmäßig in der Seitenleiste angezeigt werden. Die Reihenfolge der Elemente kann per Drag &amp; Drop geändert werden.</target>
+        <target><![CDATA[Die Menüs, die standardmäßig in der Seitenleiste angezeigt werden. Die Reihenfolge der Elemente kann per Drag & Drop geändert werden.]]></target>
       </segment>
     </unit>
     <unit id="gVSWDkE" name="settings.behavior.sidebar.rootNodeEnabled">
@@ -12726,7 +12726,7 @@ Bitte beachten Sie, dass Sie sich nicht als deaktivierter Benutzer ausgeben kön
     <unit id="SUD8H3b" name="settings.behavior.table.parts_default_columns.help">
       <segment state="translated">
         <source>settings.behavior.table.parts_default_columns.help</source>
-        <target>Die Spalten, die standardmäßig in Bauteiltabellen angezeigt werden sollen. Die Reihenfolge der Elemente kann per Drag &amp; Drop geändert werden.</target>
+        <target><![CDATA[Die Spalten, die standardmäßig in Bauteiltabellen angezeigt werden sollen. Die Reihenfolge der Elemente kann per Drag & Drop geändert werden.]]></target>
       </segment>
     </unit>
     <unit id="hazr_g5" name="settings.ips.oemsecrets">
@@ -12780,7 +12780,7 @@ Bitte beachten Sie, dass Sie sich nicht als deaktivierter Benutzer ausgeben kön
     <unit id="KLJYfJ0" name="settings.ips.oemsecrets.sortMode.M">
       <segment state="translated">
         <source>settings.ips.oemsecrets.sortMode.M</source>
-        <target>Vollständigkeit &amp; Herstellername</target>
+        <target><![CDATA[Vollständigkeit & Herstellername]]></target>
       </segment>
     </unit>
     <unit id="8C9ijHM" name="entity.export.flash.error.no_entities">
@@ -13440,7 +13440,7 @@ Bitte beachten Sie, dass Sie sich nicht als deaktivierter Benutzer ausgeben kön
     <unit id="FsrRdkp" name="settings.behavior.homepage.items.help">
       <segment state="translated">
         <source>settings.behavior.homepage.items.help</source>
-        <target>Die Elemente, die auf der Startseite angezeigt werden sollen. Die Reihenfolge kann per Drag &amp; Drop geändert werden.</target>
+        <target><![CDATA[Die Elemente, die auf der Startseite angezeigt werden sollen. Die Reihenfolge kann per Drag & Drop geändert werden.]]></target>
       </segment>
     </unit>
     <unit id="CYw3_pS" name="settings.system.customization.showVersionOnHomepage">
@@ -14154,7 +14154,7 @@ Bitte beachten Sie, dass Sie sich nicht als deaktivierter Benutzer ausgeben kön
     <unit id="Ej2znKK" name="settings.system.localization.language_menu_entries.description">
       <segment state="translated">
         <source>settings.system.localization.language_menu_entries.description</source>
-        <target>Die Sprachen, die im Sprachen Dropdown-Menü angezeigt werden sollen. Die Reihenfolge kann via Drag&amp;Drop geändert werden. Lassen Sie das Feld leer, um alle verfügbaren Sprachen anzuzeigen.</target>
+        <target><![CDATA[Die Sprachen, die im Sprachen Dropdown-Menü angezeigt werden sollen. Die Reihenfolge kann via Drag&Drop geändert werden. Lassen Sie das Feld leer, um alle verfügbaren Sprachen anzuzeigen.]]></target>
       </segment>
     </unit>
     <unit id="xIZ_mEX" name="project.builds.no_bom_entries">
@@ -14430,13 +14430,33 @@ Bitte beachten Sie, dass dieses System derzeit experimentell ist und die hier de
       </segment>
     </unit>
     <unit id="MxKRRx_" name="datatable.datatable.lengthMenu">
-        <notes>
-            <note priority="1">Do not remove! Used for datatables rendering.</note>
-        </notes>
-        <segment state="translated">
-            <source>datatable.datatable.lengthMenu</source>
-            <target>_MENU_</target>
-          </segment>
+      <notes>
+        <note priority="1">Do not remove! Used for datatables rendering.</note>
+      </notes>
+      <segment state="translated">
+        <source>datatable.datatable.lengthMenu</source>
+        <target>_MENU_</target>
+      </segment>
+    </unit>
+    <unit id="Ae8pGfM" name="settings.ips.buerklin">
+      <segment>
+        <source>settings.ips.buerklin</source>
+        <target>Buerklin</target>
+      </segment>
+    </unit>
+    <unit id="nlVH1Nb" name="settings.ips.buerklin.username">
+      <segment>
+        <source>settings.ips.buerklin.username</source>
+        <target>Benutzername</target>
+      </segment>
+    </unit>
+    <unit id="BlR_EQc" name="settings.ips.buerklin.help">
+      <segment>
+        <source>settings.ips.buerklin.help</source>
+        <target>Buerklin-API-Zugriffsbeschränkungen: 100 Requests/Minute pro IP-Adresse
+Buerklin-API-Authentication-Server: 
+10 Requests/Minute pro IP-Adresse</target>
+      </segment>
     </unit>
   </file>
 </xliff>

translations/messages.en.xlf

@@ -1,4 +1,4 @@
-<?xml version='1.0' encoding='utf-8'?>
+<?xml version="1.0" encoding="utf-8"?>
 <xliff xmlns="urn:oasis:names:tc:xliff:document:2.0" version="2.0" srcLang="en" trgLang="en">
   <file id="messages.en">
     <unit id="x_wTSQS" name="attachment_type.caption">
@@ -221,7 +221,7 @@
       </notes>
       <segment state="final">
         <source>part.info.timetravel_hint</source>
-        <target>This is how the part appeared before %timestamp%. &lt;i&gt;Please note that this feature is experimental, so the info may not be correct.&lt;/i&gt;</target>
+        <target><![CDATA[This is how the part appeared before %timestamp%. <i>Please note that this feature is experimental, so the info may not be correct.</i>]]></target>
       </segment>
     </unit>
     <unit id="3exvSpl" name="standard.label">
@@ -649,10 +649,10 @@
       </notes>
       <segment state="translated">
         <source>user.edit.tfa.disable_tfa_message</source>
-        <target>This will disable &lt;b&gt;all active two-factor authentication methods of the user&lt;/b&gt; and delete the &lt;b&gt;backup codes&lt;/b&gt;!
-&lt;br&gt;
-The user will have to set up all two-factor authentication methods again and print new backup codes! &lt;br&gt;&lt;br&gt;
-&lt;b&gt;Only do this if you are absolutely sure about the identity of the user (seeking help), otherwise the account could be compromised by an attacker!&lt;/b&gt;</target>
+        <target><![CDATA[This will disable <b>all active two-factor authentication methods of the user</b> and delete the <b>backup codes</b>!
+<br>
+The user will have to set up all two-factor authentication methods again and print new backup codes! <br><br>
+<b>Only do this if you are absolutely sure about the identity of the user (seeking help), otherwise the account could be compromised by an attacker!</b>]]></target>
       </segment>
     </unit>
     <unit id="APsHYu0" name="user.edit.tfa.disable_tfa.btn">
@@ -803,9 +803,9 @@ The user will have to set up all two-factor authentication methods again and pri
       </notes>
       <segment state="translated">
         <source>entity.delete.message</source>
-        <target>This can not be undone!
-&lt;br&gt;
-Sub elements will be moved upwards.</target>
+        <target><![CDATA[This can not be undone!
+<br>
+Sub elements will be moved upwards.]]></target>
       </segment>
     </unit>
     <unit id="2tKAqHw" name="entity.delete">
@@ -1359,7 +1359,7 @@ Sub elements will be moved upwards.</target>
       </notes>
       <segment state="final">
         <source>homepage.github.text</source>
-        <target>Source, downloads, bug reports, to-do-list etc. can be found on &lt;a href="%href%" class="link-external" target="_blank"&gt;GitHub project page&lt;/a&gt;</target>
+        <target><![CDATA[Source, downloads, bug reports, to-do-list etc. can be found on <a href="%href%" class="link-external" target="_blank">GitHub project page</a>]]></target>
       </segment>
     </unit>
     <unit id="D5OKsgU" name="homepage.help.caption">
@@ -1381,7 +1381,7 @@ Sub elements will be moved upwards.</target>
       </notes>
       <segment state="translated">
         <source>homepage.help.text</source>
-        <target>Help and tips can be found in Wiki the &lt;a href="%href%" class="link-external" target="_blank"&gt;GitHub page&lt;/a&gt;</target>
+        <target><![CDATA[Help and tips can be found in Wiki the <a href="%href%" class="link-external" target="_blank">GitHub page</a>]]></target>
       </segment>
     </unit>
     <unit id="dnirx4v" name="homepage.forum.caption">
@@ -1623,7 +1623,7 @@ Sub elements will be moved upwards.</target>
       </notes>
       <segment state="translated">
         <source>email.pw_reset.fallback</source>
-        <target>If this does not work for you, go to &lt;a href="%url%"&gt;%url%&lt;/a&gt; and enter the following info</target>
+        <target><![CDATA[If this does not work for you, go to <a href="%url%">%url%</a> and enter the following info]]></target>
       </segment>
     </unit>
     <unit id="DduL9Hu" name="email.pw_reset.username">
@@ -1653,7 +1653,7 @@ Sub elements will be moved upwards.</target>
       </notes>
       <segment state="translated">
         <source>email.pw_reset.valid_unit %date%</source>
-        <target>The reset token will be valid until &lt;i&gt;%date%&lt;/i&gt;.</target>
+        <target><![CDATA[The reset token will be valid until <i>%date%</i>.]]></target>
       </segment>
     </unit>
     <unit id="8sBnjRy" name="orderdetail.delete">
@@ -3526,8 +3526,8 @@ Sub elements will be moved upwards.</target>
       </notes>
       <segment state="translated">
         <source>tfa_google.disable.confirm_message</source>
-        <target>If you disable the Authenticator App, all backup codes will be deleted, so you may need to reprint them.&lt;br&gt;
-Also note that without two-factor authentication, your account is no longer as well protected against attackers!</target>
+        <target><![CDATA[If you disable the Authenticator App, all backup codes will be deleted, so you may need to reprint them.<br>
+Also note that without two-factor authentication, your account is no longer as well protected against attackers!]]></target>
       </segment>
     </unit>
     <unit id="yu9MSt5" name="tfa_google.disabled_message">
@@ -3547,7 +3547,7 @@ Also note that without two-factor authentication, your account is no longer as w
       </notes>
       <segment state="translated">
         <source>tfa_google.step.download</source>
-        <target>Download an authenticator app (e.g. &lt;a class="link-external" target="_blank" href="https://play.google.com/store/apps/details?id=com.google.android.apps.authenticator2"&gt;Google Authenticator&lt;/a&gt; oder &lt;a class="link-external" target="_blank" href="https://play.google.com/store/apps/details?id=org.fedorahosted.freeotp"&gt;FreeOTP Authenticator&lt;/a&gt;)</target>
+        <target><![CDATA[Download an authenticator app (e.g. <a class="link-external" target="_blank" href="https://play.google.com/store/apps/details?id=com.google.android.apps.authenticator2">Google Authenticator</a> oder <a class="link-external" target="_blank" href="https://play.google.com/store/apps/details?id=org.fedorahosted.freeotp">FreeOTP Authenticator</a>)]]></target>
       </segment>
     </unit>
     <unit id="eriwJoR" name="tfa_google.step.scan">
@@ -3789,8 +3789,8 @@ Also note that without two-factor authentication, your account is no longer as w
       </notes>
       <segment state="translated">
         <source>tfa_trustedDevices.explanation</source>
-        <target>When checking the second factor, the current computer can be marked as trustworthy, so no more two-factor checks on this computer are needed.
-If you have done this incorrectly or if a computer is no longer trusted, you can reset the status of &lt;i&gt;all &lt;/i&gt;computers here.</target>
+        <target><![CDATA[When checking the second factor, the current computer can be marked as trustworthy, so no more two-factor checks on this computer are needed.
+If you have done this incorrectly or if a computer is no longer trusted, you can reset the status of <i>all </i>computers here.]]></target>
       </segment>
     </unit>
     <unit id="FZINq8z" name="tfa_trustedDevices.invalidate.confirm_title">
@@ -5236,7 +5236,7 @@ If you have done this incorrectly or if a computer is no longer trusted, you can
       </notes>
       <segment state="translated">
         <source>label_options.lines_mode.help</source>
-        <target>If you select Twig here, the content field is interpreted as Twig template. See &lt;a href="https://twig.symfony.com/doc/3.x/templates.html"&gt;Twig documentation&lt;/a&gt; and &lt;a href="https://docs.part-db.de/usage/labels.html#twig-mode"&gt;Wiki&lt;/a&gt; for more information.</target>
+        <target><![CDATA[If you select Twig here, the content field is interpreted as Twig template. See <a href="https://twig.symfony.com/doc/3.x/templates.html">Twig documentation</a> and <a href="https://docs.part-db.de/usage/labels.html#twig-mode">Wiki</a> for more information.]]></target>
       </segment>
     </unit>
     <unit id="isvxbiX" name="label_options.page_size.label">
@@ -7084,15 +7084,15 @@ Exampletown</target>
       </notes>
       <segment state="translated">
         <source>mass_creation.lines.placeholder</source>
-        <target>Element 1
+        <target><![CDATA[Element 1
    Element 1.1
       Element 1.1.1
    Element 1.2
 Element 2
 Element 3
 
-Element 1 -&gt; Element 1.1
-Element 1 -&gt; Element 1.2</target>
+Element 1 -> Element 1.1
+Element 1 -> Element 1.2]]></target>
       </segment>
     </unit>
     <unit id="TWSqPFi" name="entity.mass_creation.btn">
@@ -9152,25 +9152,25 @@ Element 1 -&gt; Element 1.2</target>
     <unit id="r4vDLAt" name="filter.parameter_value_constraint.operator.&lt;">
       <segment state="translated">
         <source>filter.parameter_value_constraint.operator.&lt;</source>
-        <target>Typ. Value &lt;</target>
+        <target><![CDATA[Typ. Value <]]></target>
       </segment>
     </unit>
     <unit id="X9SA3UP" name="filter.parameter_value_constraint.operator.&gt;">
       <segment state="translated">
         <source>filter.parameter_value_constraint.operator.&gt;</source>
-        <target>Typ. Value &gt;</target>
+        <target><![CDATA[Typ. Value >]]></target>
       </segment>
     </unit>
     <unit id="BQGaoQS" name="filter.parameter_value_constraint.operator.&lt;=">
       <segment state="translated">
         <source>filter.parameter_value_constraint.operator.&lt;=</source>
-        <target>Typ. Value &lt;=</target>
+        <target><![CDATA[Typ. Value <=]]></target>
       </segment>
     </unit>
     <unit id="2ha3P6g" name="filter.parameter_value_constraint.operator.&gt;=">
       <segment state="translated">
         <source>filter.parameter_value_constraint.operator.&gt;=</source>
-        <target>Typ. Value &gt;=</target>
+        <target><![CDATA[Typ. Value >=]]></target>
       </segment>
     </unit>
     <unit id="4DaBace" name="filter.parameter_value_constraint.operator.BETWEEN">
@@ -9278,7 +9278,7 @@ Element 1 -&gt; Element 1.2</target>
     <unit id="4tHhDtU" name="parts_list.search.searching_for">
       <segment state="translated">
         <source>parts_list.search.searching_for</source>
-        <target>Searching parts with keyword &lt;b&gt;%keyword%&lt;/b&gt;</target>
+        <target><![CDATA[Searching parts with keyword <b>%keyword%</b>]]></target>
       </segment>
     </unit>
     <unit id="4vomKLa" name="parts_list.search_options.caption">
@@ -10058,7 +10058,7 @@ Element 1 -&gt; Element 1.2</target>
     <unit id="GzqIwHH" name="entity.select.add_hint">
       <segment state="translated">
         <source>entity.select.add_hint</source>
-        <target>Use -&gt; to create nested structures, e.g. "Node 1-&gt;Node 1.1"</target>
+        <target><![CDATA[Use -> to create nested structures, e.g. "Node 1->Node 1.1"]]></target>
       </segment>
     </unit>
     <unit id="S4CxO.T" name="entity.select.group.new_not_added_to_DB">
@@ -10082,13 +10082,13 @@ Element 1 -&gt; Element 1.2</target>
     <unit id="XLnXtsR" name="homepage.first_steps.introduction">
       <segment state="translated">
         <source>homepage.first_steps.introduction</source>
-        <target>Your database is still empty. You might want to read the &lt;a href="%url%"&gt;documentation&lt;/a&gt; or start to creating the following data structures:</target>
+        <target><![CDATA[Your database is still empty. You might want to read the <a href="%url%">documentation</a> or start to creating the following data structures:]]></target>
       </segment>
     </unit>
     <unit id="Q79MOIk" name="homepage.first_steps.create_part">
       <segment state="translated">
         <source>homepage.first_steps.create_part</source>
-        <target>Or you can directly &lt;a href="%url%"&gt;create a new part&lt;/a&gt;.</target>
+        <target><![CDATA[Or you can directly <a href="%url%">create a new part</a>.]]></target>
       </segment>
     </unit>
     <unit id="vplYq4f" name="homepage.first_steps.hide_hint">
@@ -10100,7 +10100,7 @@ Element 1 -&gt; Element 1.2</target>
     <unit id="MJoZl4f" name="homepage.forum.text">
       <segment state="translated">
         <source>homepage.forum.text</source>
-        <target>For questions about Part-DB use the &lt;a href="%href%" class="link-external" target="_blank"&gt;discussion forum&lt;/a&gt;</target>
+        <target><![CDATA[For questions about Part-DB use the <a href="%href%" class="link-external" target="_blank">discussion forum</a>]]></target>
       </segment>
     </unit>
     <unit id="YsukbnK" name="log.element_edited.changed_fields.category">
@@ -10766,7 +10766,7 @@ Element 1 -&gt; Element 1.2</target>
     <unit id="p_IxB9K" name="parts.import.help_documentation">
       <segment state="translated">
         <source>parts.import.help_documentation</source>
-        <target>See the &lt;a href="%link%"&gt;documentation&lt;/a&gt; for more information on the file format.</target>
+        <target><![CDATA[See the <a href="%link%">documentation</a> for more information on the file format.]]></target>
       </segment>
     </unit>
     <unit id="awbvhVq" name="parts.import.help">
@@ -10958,7 +10958,7 @@ Element 1 -&gt; Element 1.2</target>
     <unit id="o5u.Nnz" name="part.filter.lessThanDesired">
       <segment state="translated">
         <source>part.filter.lessThanDesired</source>
-        <target>In stock less than desired (total amount &lt; min. amount)</target>
+        <target><![CDATA[In stock less than desired (total amount < min. amount)]]></target>
       </segment>
     </unit>
     <unit id="YN9eLcZ" name="part.filter.lotOwner">
@@ -11764,13 +11764,13 @@ Please note, that you can not impersonate a disabled user. If you try you will g
     <unit id="i68lU5x" name="part.merge.confirm.title">
       <segment state="translated">
         <source>part.merge.confirm.title</source>
-        <target>Do you really want to merge &lt;b&gt;%other%&lt;/b&gt; into &lt;b&gt;%target%&lt;/b&gt;?</target>
+        <target><![CDATA[Do you really want to merge <b>%other%</b> into <b>%target%</b>?]]></target>
       </segment>
     </unit>
     <unit id="k0anzYV" name="part.merge.confirm.message">
       <segment state="translated">
         <source>part.merge.confirm.message</source>
-        <target>&lt;b&gt;%other%&lt;/b&gt; will be deleted, and the part will be saved with the shown information.</target>
+        <target><![CDATA[<b>%other%</b> will be deleted, and the part will be saved with the shown information.]]></target>
       </segment>
     </unit>
     <unit id="mmW5Yl1" name="part.info.merge_modal.title">
@@ -12124,7 +12124,7 @@ Please note, that you can not impersonate a disabled user. If you try you will g
     <unit id="p7LGAIX" name="settings.ips.element14.apiKey.help">
       <segment state="translated">
         <source>settings.ips.element14.apiKey.help</source>
-        <target>You can register for an API key on &lt;a href="https://partner.element14.com/"&gt;https://partner.element14.com/&lt;/a&gt;.</target>
+        <target><![CDATA[You can register for an API key on <a href="https://partner.element14.com/">https://partner.element14.com/</a>.]]></target>
       </segment>
     </unit>
     <unit id="ZdUHpZc" name="settings.ips.element14.storeId">
@@ -12136,7 +12136,7 @@ Please note, that you can not impersonate a disabled user. If you try you will g
     <unit id="XXGUxF6" name="settings.ips.element14.storeId.help">
       <segment state="translated">
         <source>settings.ips.element14.storeId.help</source>
-        <target>The store domain to retrieve the data from. This decides the language and currency of results. See &lt;a href="https://partner.element14.com/docs/Product_Search_API_REST__Description"&gt;here&lt;/a&gt; for a list of valid domains.</target>
+        <target><![CDATA[The store domain to retrieve the data from. This decides the language and currency of results. See <a href="https://partner.element14.com/docs/Product_Search_API_REST__Description">here</a> for a list of valid domains.]]></target>
       </segment>
     </unit>
     <unit id="WKWZIm2" name="settings.ips.tme">
@@ -12154,7 +12154,7 @@ Please note, that you can not impersonate a disabled user. If you try you will g
     <unit id="_pYLrPT" name="settings.ips.tme.token.help">
       <segment state="translated">
         <source>settings.ips.tme.token.help</source>
-        <target>You can get an API token and secret on &lt;a href="https://developers.tme.eu/en/"&gt;https://developers.tme.eu/en/&lt;/a&gt;.</target>
+        <target><![CDATA[You can get an API token and secret on <a href="https://developers.tme.eu/en/">https://developers.tme.eu/en/</a>.]]></target>
       </segment>
     </unit>
     <unit id="yswx4bq" name="settings.ips.tme.secret">
@@ -12202,7 +12202,7 @@ Please note, that you can not impersonate a disabled user. If you try you will g
     <unit id="gu.JlpT" name="settings.ips.mouser.apiKey.help">
       <segment state="translated">
         <source>settings.ips.mouser.apiKey.help</source>
-        <target>You can register for an API key on &lt;a href="https://eu.mouser.com/api-hub/"&gt;https://eu.mouser.com/api-hub/&lt;/a&gt;.</target>
+        <target><![CDATA[You can register for an API key on <a href="https://eu.mouser.com/api-hub/">https://eu.mouser.com/api-hub/</a>.]]></target>
       </segment>
     </unit>
     <unit id="Q66CNjw" name="settings.ips.mouser.searchLimit">
@@ -12280,7 +12280,7 @@ Please note, that you can not impersonate a disabled user. If you try you will g
     <unit id="kKv0J3." name="settings.system.attachments">
       <segment state="translated">
         <source>settings.system.attachments</source>
-        <target>Attachments &amp; Files</target>
+        <target><![CDATA[Attachments & Files]]></target>
       </segment>
     </unit>
     <unit id="dsRff8T" name="settings.system.attachments.maxFileSize">
@@ -12304,7 +12304,7 @@ Please note, that you can not impersonate a disabled user. If you try you will g
     <unit id="T.PBu5P" name="settings.system.attachments.allowDownloads.help">
       <segment state="translated">
         <source>settings.system.attachments.allowDownloads.help</source>
-        <target>With this option users can download external files into Part-DB by providing an URL. &lt;b&gt;Attention: This can be a security issue, as it might allow users to access intranet ressources via Part-DB!&lt;/b&gt;</target>
+        <target><![CDATA[With this option users can download external files into Part-DB by providing an URL. <b>Attention: This can be a security issue, as it might allow users to access intranet ressources via Part-DB!</b>]]></target>
       </segment>
     </unit>
     <unit id=".OyihML" name="settings.system.attachments.downloadByDefault">
@@ -12478,8 +12478,8 @@ Please note, that you can not impersonate a disabled user. If you try you will g
     <unit id="0GRlEe5" name="settings.system.localization.base_currency_description">
       <segment state="translated">
         <source>settings.system.localization.base_currency_description</source>
-        <target>The currency that is used to store price information and exchange rates in. This currency is assumed, when no currency is set for a price information.
-&lt;b&gt;Please note that the currencies are not converted, when changing this value. So changing the default currency after you already added price information, will result in wrong prices!&lt;/b&gt;</target>
+        <target><![CDATA[The currency that is used to store price information and exchange rates in. This currency is assumed, when no currency is set for a price information.
+<b>Please note that the currencies are not converted, when changing this value. So changing the default currency after you already added price information, will result in wrong prices!</b>]]></target>
       </segment>
     </unit>
     <unit id="cvpTUeY" name="settings.system.privacy">
@@ -12509,7 +12509,7 @@ Please note, that you can not impersonate a disabled user. If you try you will g
     <unit id="w07P3Dt" name="settings.misc.kicad_eda.category_depth.help">
       <segment state="translated">
         <source>settings.misc.kicad_eda.category_depth.help</source>
-        <target>This value determines the depth of the category tree, that is visible inside KiCad. 0 means that only the top level categories are visible. Set to a value &gt; 0 to show more levels. Set to -1, to show all parts of Part-DB inside a sigle cnategory in KiCad.</target>
+        <target><![CDATA[This value determines the depth of the category tree, that is visible inside KiCad. 0 means that only the top level categories are visible. Set to a value > 0 to show more levels. Set to -1, to show all parts of Part-DB inside a sigle cnategory in KiCad.]]></target>
       </segment>
     </unit>
     <unit id="VwvmcWE" name="settings.behavior.sidebar">
@@ -12527,7 +12527,7 @@ Please note, that you can not impersonate a disabled user. If you try you will g
     <unit id="jc0JTvL" name="settings.behavior.sidebar.items.help">
       <segment state="translated">
         <source>settings.behavior.sidebar.items.help</source>
-        <target>The menus which appear at the sidebar by default. Order of items can be changed via drag &amp; drop.</target>
+        <target><![CDATA[The menus which appear at the sidebar by default. Order of items can be changed via drag & drop.]]></target>
       </segment>
     </unit>
     <unit id="gVSWDkE" name="settings.behavior.sidebar.rootNodeEnabled">
@@ -12575,7 +12575,7 @@ Please note, that you can not impersonate a disabled user. If you try you will g
     <unit id="SUD8H3b" name="settings.behavior.table.parts_default_columns.help">
       <segment state="translated">
         <source>settings.behavior.table.parts_default_columns.help</source>
-        <target>The columns to show by default in part tables. Order of items can be changed via drag &amp; drop.</target>
+        <target><![CDATA[The columns to show by default in part tables. Order of items can be changed via drag & drop.]]></target>
       </segment>
     </unit>
     <unit id="hazr_g5" name="settings.ips.oemsecrets">
@@ -12629,7 +12629,7 @@ Please note, that you can not impersonate a disabled user. If you try you will g
     <unit id="KLJYfJ0" name="settings.ips.oemsecrets.sortMode.M">
       <segment state="translated">
         <source>settings.ips.oemsecrets.sortMode.M</source>
-        <target>Completeness &amp; Manufacturer name</target>
+        <target><![CDATA[Completeness & Manufacturer name]]></target>
       </segment>
     </unit>
     <unit id="8C9ijHM" name="entity.export.flash.error.no_entities">
@@ -13289,7 +13289,7 @@ Please note, that you can not impersonate a disabled user. If you try you will g
     <unit id="FsrRdkp" name="settings.behavior.homepage.items.help">
       <segment state="translated">
         <source>settings.behavior.homepage.items.help</source>
-        <target>The items to show at the homepage. Order can be changed via drag &amp; drop.</target>
+        <target><![CDATA[The items to show at the homepage. Order can be changed via drag & drop.]]></target>
       </segment>
     </unit>
     <unit id="CYw3_pS" name="settings.system.customization.showVersionOnHomepage">
@@ -14003,7 +14003,7 @@ Please note, that you can not impersonate a disabled user. If you try you will g
     <unit id="Ej2znKK" name="settings.system.localization.language_menu_entries.description">
       <segment state="translated">
         <source>settings.system.localization.language_menu_entries.description</source>
-        <target>The languages to show in the language drop-down menu. Order can be changed via drag &amp; drop. Leave empty to show all available languages.</target>
+        <target><![CDATA[The languages to show in the language drop-down menu. Order can be changed via drag & drop. Leave empty to show all available languages.]]></target>
       </segment>
     </unit>
     <unit id="xIZ_mEX" name="project.builds.no_bom_entries">
@@ -14032,128 +14032,128 @@ You can do this in the provider info list.</target>
       </segment>
     </unit>
     <unit id="L4nq52R" name="settings.misc.ipn_suggest.useDuplicateDescription.help">
-      <segment>
+      <segment state="translated">
         <source>settings.misc.ipn_suggest.useDuplicateDescription.help</source>
         <target>When enabled, the part’s description is used to find existing parts with the same description and to determine the next available IPN by incrementing their numeric suffix for the suggestion list.</target>
       </segment>
     </unit>
     <unit id="NIw6dtz" name="settings.misc.ipn_suggest.regex.help">
-      <segment>
+      <segment state="translated">
         <source>settings.misc.ipn_suggest.regex.help</source>
         <target>A PCRE-compatible regular expression every IPN has to fulfill. Leave empty to allow everything as IPN.</target>
       </segment>
     </unit>
     <unit id="MoHHSNT" name="user.labelp">
-      <segment>
+      <segment state="translated">
         <source>user.labelp</source>
         <target>Users</target>
       </segment>
     </unit>
     <unit id="5.oI1XD" name="currency.labelp">
-      <segment>
+      <segment state="translated">
         <source>currency.labelp</source>
         <target>Currencies</target>
       </segment>
     </unit>
     <unit id="8F2EwVK" name="measurement_unit.labelp">
-      <segment>
+      <segment state="translated">
         <source>measurement_unit.labelp</source>
         <target>Measurement units</target>
       </segment>
     </unit>
     <unit id="hYrcka2" name="attachment_type.labelp">
-      <segment>
+      <segment state="translated">
         <source>attachment_type.labelp</source>
         <target>Attachment types</target>
       </segment>
     </unit>
     <unit id="p.Sjja3" name="label_profile.labelp">
-      <segment>
+      <segment state="translated">
         <source>label_profile.labelp</source>
         <target>Label profiles</target>
       </segment>
     </unit>
     <unit id="Y_ISV0y" name="part_custom_state.labelp">
-      <segment>
+      <segment state="translated">
         <source>part_custom_state.labelp</source>
         <target>Custom part states</target>
       </segment>
     </unit>
     <unit id="aXr7mN." name="group.labelp">
-      <segment>
+      <segment state="translated">
         <source>group.labelp</source>
         <target>Groups</target>
       </segment>
     </unit>
     <unit id="O10voez" name="settings.synonyms.type_synonym.type">
-      <segment>
+      <segment state="translated">
         <source>settings.synonyms.type_synonym.type</source>
         <target>Type</target>
       </segment>
     </unit>
     <unit id="1BDQVEp" name="settings.synonyms.type_synonym.language">
-      <segment>
+      <segment state="translated">
         <source>settings.synonyms.type_synonym.language</source>
         <target>Language</target>
       </segment>
     </unit>
     <unit id="2.g2ewQ" name="settings.synonyms.type_synonym.translation_singular">
-      <segment>
+      <segment state="translated">
         <source>settings.synonyms.type_synonym.translation_singular</source>
         <target>Translation Singular</target>
       </segment>
     </unit>
     <unit id="Up9ZhvR" name="settings.synonyms.type_synonym.translation_plural">
-      <segment>
+      <segment state="translated">
         <source>settings.synonyms.type_synonym.translation_plural</source>
         <target>Translation Plural</target>
       </segment>
     </unit>
     <unit id="BHoS230" name="settings.synonyms.type_synonym.add_entry">
-      <segment>
+      <segment state="translated">
         <source>settings.synonyms.type_synonym.add_entry</source>
         <target>Add entry</target>
       </segment>
     </unit>
     <unit id="wvtOEBn" name="settings.synonyms.type_synonym.remove_entry">
-      <segment>
+      <segment state="translated">
         <source>settings.synonyms.type_synonym.remove_entry</source>
         <target>Remove entry</target>
       </segment>
     </unit>
     <unit id="mLu.2F2" name="settings.synonyms">
-      <segment>
+      <segment state="translated">
         <source>settings.synonyms</source>
         <target>Synonyms</target>
       </segment>
     </unit>
     <unit id="SHgc9i." name="settings.synonyms.help">
-      <segment>
+      <segment state="translated">
         <source>settings.synonyms.help</source>
         <target>The synonyms systems allow overriding how Part-DB call certain things. This can be useful, especially if Part-DB is used in a different context than electronics.
 Please note that this system is currently experimental, and the synonyms defined here might not show up at all places.</target>
       </segment>
     </unit>
     <unit id="piB78W5" name="settings.synonyms.type_synonyms">
-      <segment>
+      <segment state="translated">
         <source>settings.synonyms.type_synonyms</source>
         <target>Type synonyms</target>
       </segment>
     </unit>
     <unit id="J8T2HuD" name="settings.synonyms.type_synonyms.help">
-      <segment>
+      <segment state="translated">
         <source>settings.synonyms.type_synonyms.help</source>
         <target>Type synonyms allow you to replace the labels of built-in data types. For example, you can rename "Footprint" to something else.</target>
       </segment>
     </unit>
     <unit id="wjcsjzT" name="log.element_edited.changed_fields.part_ipn_prefix">
-      <segment>
+      <segment state="translated">
         <source>log.element_edited.changed_fields.part_ipn_prefix</source>
         <target>IPN prefix</target>
       </segment>
     </unit>
     <unit id="R4hoCqe" name="part.labelp">
-      <segment>
+      <segment state="translated">
         <source>part.labelp</source>
         <target>Parts</target>
       </segment>
@@ -14279,13 +14279,40 @@ Please note that this system is currently experimental, and the synonyms defined
       </segment>
     </unit>
     <unit id="MxKRRx_" name="datatable.datatable.lengthMenu">
-        <notes>
-            <note priority="1">Do not remove! Used for datatables rendering.</note>
-        </notes>
-        <segment state="translated">
-            <source>datatable.datatable.lengthMenu</source>
-            <target>_MENU_</target>
-          </segment>
+      <notes>
+        <note priority="1">Do not remove! Used for datatables rendering.</note>
+      </notes>
+      <segment state="translated">
+        <source>datatable.datatable.lengthMenu</source>
+        <target>_MENU_</target>
+      </segment>
+    </unit>
+    <unit id="Ae8pGfM" name="settings.ips.buerklin">
+      <segment>
+        <source>settings.ips.buerklin</source>
+        <target>Buerklin</target>
+      </segment>
+    </unit>
+    <unit id="nlVH1Nb" name="settings.ips.buerklin.username">
+      <segment>
+        <source>settings.ips.buerklin.username</source>
+        <target>User name</target>
+      </segment>
+    </unit>
+    <unit id="BlR_EQc" name="settings.ips.buerklin.help">
+      <segment>
+        <source>settings.ips.buerklin.help</source>
+        <target>Buerklin-API access limits: 
+100 requests/minute per IP address
+Buerklin-API Authentication server:
+10 requests/minute per IP address</target>
+      </segment>
+    </unit>
+    <unit id="8BkjGyq" name="project.bom.part_id">
+      <segment>
+        <source>project.bom.part_id</source>
+        <target>[Part] ID</target>
+      </segment>
     </unit>
   </file>
 </xliff>

translations/validators.en.xlf

@@ -366,7 +366,7 @@
       </segment>
     </unit>
     <unit id="I330cr5" name="settings.synonyms.type_synonyms.collection_type.duplicate">
-      <segment>
+      <segment state="translated">
         <source>settings.synonyms.type_synonyms.collection_type.duplicate</source>
         <target>There is already a translation defined for this type and language!</target>
       </segment>