Christian
2c524c9a05
fix: Apply date filter in code instead of API parameter
...
v1.3.139:
- Removed date filter from API params (causes 404 on some endpoints)
- Apply 13-month filter in code after fetching invoices
- Parse invoice dates and filter >= start_date
- More reliable filtering across all e-conomic endpoints
2026-01-27 07:15:44 +01:00
Christian
e0909d4586
fix: Fix month calculation bug in date filter
...
v1.3.138:
- Fixed ValueError: month must be in 1..12
- Use python-dateutil for proper month arithmetic
- Uses relativedelta for correct 13 month calculation
2026-01-27 07:14:40 +01:00
Christian
1bf04d45b1
feat: Extend invoice filter to 13 months for yearly items
...
v1.3.137:
- Changed from 12 to 13 months lookback
- Ensures yearly billed items are visible
- Example: Jan 27, 2026 -> fetches from Jan 1, 2025
2026-01-27 07:10:25 +01:00
Christian
86ad68c362
fix: Adjust date filter to 1st of month 12 months back
...
v1.3.136:
- Changed filter from 365 days to exactly 12 months
- Uses 1st day of the month 12 months ago
- Example: Jan 27, 2026 -> fetches from Feb 1, 2025
2026-01-27 07:09:50 +01:00
Christian
180933948f
feat: Add 1-year filter + search to subscription matrix
...
v1.3.135:
- Added date filter to e-conomic API (only fetch invoices from last year)
- Implemented product search in billing matrix
- Shows/hides search field based on product count
- Real-time filtering with clear button
2026-01-27 07:08:09 +01:00
Christian
36e0f8b0f7
chore: Bump version to 1.3.134
2026-01-27 06:58:49 +01:00
Christian
ea062e10ae
chore: Bump version to 1.3.133
2026-01-27 01:53:42 +01:00
Christian
c05b11387d
chore: Bump version to 1.3.132
2026-01-27 01:46:46 +01:00
Christian
1845c9aea2
chore: Bump version to 1.3.131
2026-01-27 01:33:57 +01:00
Christian
89d378cf8a
chore: bump version to 1.3.130
2026-01-27 01:19:20 +01:00
Christian
9c6834b9f6
chore: bump version to 1.3.129
2026-01-27 00:59:15 +01:00
Christian
3a19f8233e
chore: bump version to 1.3.128
2026-01-27 00:49:36 +01:00
Christian
8ec12819f7
chore: bump version to 1.3.127
2026-01-27 00:34:57 +01:00
Christian
8ec457bba1
chore: bump version to 1.3.126
2026-01-26 17:17:21 +01:00
Christian
6de869c86a
chore: bump version to 1.3.125
2026-01-26 17:07:25 +01:00
Christian
c9f04c77b4
chore: bump version to 1.3.124
2026-01-25 14:46:07 +01:00
Christian
5f603bdd2e
chore: Bump version to 1.3.123
2026-01-06 13:17:36 +01:00
Christian
b03dd5c8f6
chore: Bump version to 1.3.122
2026-01-06 12:54:27 +01:00
Christian
5f486578c7
chore: Bump version to 1.3.121
2026-01-06 08:45:47 +01:00
Christian
373c4da57c
chore: Bump version to 1.3.120
2026-01-06 08:43:39 +01:00
Christian
bd746b7f9c
feat: Add BMC Office subscriptions Excel upload interface with auto customer mapping
2026-01-06 08:21:24 +01:00
Christian
da5ec19188
fix: Use execute_query instead of execute_query_single to return all customer contacts
2026-01-05 19:03:34 +01:00
Christian
935d2253f7
fix: Move order number from heading to otherReference field only
2026-01-05 18:56:24 +01:00
Christian
3195afe460
fix: Only use case_no from vtiger_data, never parse from vtiger_id (v1.3.116)
2026-01-05 17:17:46 +01:00
Christian
34ca9fca93
fix: Prioritize 'title' field over 'ticket_title' from vTiger (v1.3.115)
2026-01-05 17:16:44 +01:00
Christian
99eac06cfd
fix: Wizard shows case title instead of case_no (v1.3.114)
2026-01-05 17:12:41 +01:00
Christian
0974f41bd1
feat: Add endpoint to fix empty case titles from vtiger_data (v1.3.113)
2026-01-05 17:06:44 +01:00
Christian
0b9765c5a2
fix: Use 'title' field from vTiger Cases as fallback for ticket_title (v1.3.112)
2026-01-05 16:56:28 +01:00
Christian
1ebb1fa2cd
fix: Never use time descriptions as case title, only contact+date fallback (v1.3.111)
2026-01-05 16:52:58 +01:00
Christian
d99d542a24
fix: Use contact name + date as case title fallback (v1.3.110)
2026-01-05 16:44:18 +01:00
Christian
1e45ec70bf
fix: Better case title fallback logic - use descriptions or 'Arbejde' (v1.3.109)
2026-01-05 16:43:16 +01:00
Christian
dfcb523e12
chore: Update VERSION to 1.3.108
2026-01-05 16:34:23 +01:00
Christian
031212ae82
chore: Update VERSION to 1.3.107
2026-01-05 16:08:51 +01:00
Christian
224ce5ec1a
feat: Add timetracking approval columns migration (v1.3.84)
...
- Add migration 053 for approval columns
- Checks if columns exist before adding (safe)
- Adds: approved_hours, rounded_to, approval_note, billable, is_travel, approved_at, approved_by
- Adds indexes for status and approved_at
- Required for production deployment
2026-01-02 13:03:55 +01:00
Christian
cbc05b52ce
fix: Use execute_query_single for case details (v1.3.83)
...
- Fix get_case_details using execute_query instead of execute_query_single
- execute_query returns list, execute_query_single returns dict
- Prevents 500 error when loading case details
2026-01-02 13:01:20 +01:00
Christian
45d4f78006
debug: Add detailed logging to approval flow (v1.3.82)
...
- Add logging before approval object creation
- Add logging after approval object creation
- Add logging before database update
- Add logging after database update
- Add time_id to error messages
- This will help diagnose 500 errors on production
2026-01-02 12:58:53 +01:00
Christian
420507027a
fix: Remove ge constraint from rounded_to field (v1.3.81)
...
- Remove ge=0.25 constraint that prevents None values
- Optional fields should accept None without validation
- Fixes approval validation error
2026-01-02 12:56:27 +01:00
Christian
e45b1ed19e
fix: Remove float() conversion for Decimal fields (v1.3.78)
...
- Let Pydantic handle Decimal conversion
- Send approved_hours as Decimal, not float
- Send rounded_to as Decimal, not float
- Add exc_info=True to error logging
2026-01-02 12:51:12 +01:00
Christian
17cd871909
fix: Add Body() annotation to approval endpoint (v1.3.77)
...
- Add Body(...) to request parameter
- Import Body from fastapi
- Fix FastAPI body parameter handling
2026-01-02 12:49:19 +01:00
Christian
7cb38663bc
fix: Timetracking wizard approval endpoint (v1.3.76)
...
- Fix parameter handling in approve_time_entry endpoint
- Change from query params to body Dict[str, Any]
- Send all required fields to wizard.approve_time_entry()
- Calculate rounded_to if auto-rounding enabled
- Add approval_note, billable, is_travel fields
- Add Dict, Any imports
2026-01-02 12:45:25 +01:00
Christian
6c4042b9b6
feat: Implement SFTP offsite backup functionality (v1.3.75)
...
- Add SFTP upload support with paramiko
- Add database columns for offsite tracking (status, location, attempts, error)
- Add manual upload endpoint /api/v1/backups/offsite/{job_id}
- Add frontend button for offsite upload
- Add SFTP configuration in config.py
- Fix infinite loop in _ensure_remote_directory for relative paths
- Add upload verification and retry mechanism
- Add progress tracking and logging
2026-01-02 12:35:02 +01:00
Christian
1b84bee868
Add APScheduler dependency and fix scheduler endpoint
2026-01-02 02:28:33 +01:00
Christian
ebf3b1f31c
Fix backup jobs query and add missing config
2026-01-02 02:26:33 +01:00
Christian
3ffee6d428
Add backup storage config settings
2026-01-02 02:23:10 +01:00
Christian
58b598058a
Enable backup module functionality
2026-01-02 02:13:17 +01:00
Christian
9fb149c02a
Fix Mattermost config field names
2026-01-02 02:06:05 +01:00
Christian
3a3d81cf4c
Add Mattermost notification settings
2026-01-02 02:02:44 +01:00
Christian
f77e6dc70b
Add backup system configuration settings
2026-01-02 01:54:52 +01:00
Christian
7744e71761
Add paramiko dependency for backup module
2026-01-02 01:48:55 +01:00
Christian
60614ae298
Add backup router registration and fix updateto.sh with sudo
2026-01-02 01:21:00 +01:00