# Dropdown Data Fix

## Problem
Dropdowns in the frontend were not fetching data because the API endpoints were missing.

## Solution
Added all missing dictionary endpoints to `aumentum_api.py`:

### Endpoints Added:
1. **`/dictionary/party-types`** - Returns party types (Individual, Company, etc.)
2. **`/dictionary/legal-roles`** - Returns legal roles (Grantee, Grantor, etc.)
3. **`/dictionary/genders`** - Returns gender types (Male, Female)
4. **`/dictionary/transaction-types`** - Returns transaction types
5. **`/dictionary/transaction-statuses`** - Returns transaction statuses
6. **`/dictionary/property-types`** - Returns property types (spatial unit types)

### Database Categories Used:
- `party_type` → `/dictionary/party-types`
- `party_role_type` → `/dictionary/legal-roles`
- `gender` → `/dictionary/genders`
- `event_type` → `/dictionary/transaction-types`
- `transaction_status` → `/dictionary/transaction-statuses`
- `spatial_unit_type` → `/dictionary/property-types`
- `document_type` → `/dictionary/document-types` (already existed)

### Response Format:
All endpoints return an array of objects with:
```json
[
  {
    "id": 1,
    "code": "code_value",
    "label": "Display Label",
    "description": "Description text",
    "category": "category_name"
  }
]
```

### MySQL Compatibility:
All endpoints support both MySQL and MSSQL with conditional SQL queries.

## Status
✅ All dictionary endpoints added
✅ MySQL compatibility implemented
✅ Response format matches frontend expectations
✅ Server restarted with new endpoints

The dropdowns should now populate correctly with data from the database.