4f5e1b23f6
Merge pull request #403 from SyncrowIOT/SP-1629-AND-SP-1630-AQI-APIs
...
Sp 1629 and sp 1630 aqi ap is
2025-06-11 00:28:14 -06:00
2cb77504ca
Add PollutantType enum and update AQI-related entities and services to use it
2025-06-11 00:28:00 -06:00
c86be27576
Add AQI module and related services, controllers, and DTOs
...
- Introduced AqiModule with AqiService and AqiController for handling AQI data.
- Added DTOs for AQI requests: GetAqiDailyBySpaceDto and GetAqiPollutantBySpaceDto.
- Implemented AqiDataService for managing AQI sensor historical data.
- Updated existing modules to include AqiDataService where necessary.
- Defined new routes for AQI data retrieval in ControllerRoute.
2025-06-10 18:19:34 -06:00
3a08f9f258
Merge branch 'dev' into aqi-test
2025-06-10 17:08:06 -06:00
5c96a3b117
Merge pull request #402 from SyncrowIOT/add-code-and-value-as-uniqe-key
...
Refactor DeviceStatusLogEntity: expand unique constraint to include c…
2025-06-10 01:43:09 -06:00
97e14e70f7
Refactor DeviceStatusLogEntity: expand unique constraint to include code and value
2025-06-10 01:41:41 -06:00
03d44cb14f
Merge pull request #401 from SyncrowIOT/fix-log-insert-error
...
Refactor DeviceStatusLogEntity: update unique constraint to include d…
2025-06-10 01:27:15 -06:00
0793441e06
Refactor DeviceStatusLogEntity: correct unique constraint name for event time and device ID
2025-06-10 01:24:33 -06:00
b6321c2530
Refactor DeviceStatusLogEntity: update unique constraint to include deviceId
2025-06-10 01:18:58 -06:00
b8d34b0d9f
Merge pull request #400 from SyncrowIOT/revert-398-fix-log-duplication-issue
...
Revert "Refactor DeviceStatusLogEntity: update unique constraint and primary …"
2025-06-10 01:04:29 -06:00
c1065126aa
Revert "Refactor DeviceStatusLogEntity: update unique constraint and primary …"
2025-06-10 01:03:45 -06:00
1742454984
Merge pull request #398 from SyncrowIOT/fix-log-duplication-issue
...
Refactor DeviceStatusLogEntity: update unique constraint and primary …
2025-06-10 00:26:43 -06:00
7eb13088ac
Refactor DeviceStatusLogEntity: update unique constraint and primary key definition
2025-06-09 04:50:58 -06:00
7b97e50d2e
Merge pull request #391 from SyncrowIOT/DATA-space-model-aqi-update-logic
...
AQI space model updated with new hourly to daily logic for calculatio…
2025-06-04 17:40:39 -04:00
4fb26fc131
Merge pull request #397 from SyncrowIOT/DATA-daily-procedure-aqi
...
Procedures insert-all, update, and select for daily space air quality…
2025-06-04 17:39:34 -04:00
ee0261d102
Fix typos procedure select and update
2025-06-04 17:32:50 -04:00
0d6de2df43
Refactor AqiSpaceDailyPollutantStatsEntity: update unique constraint and rename event fields for clarity
2025-06-04 15:24:13 -06:00
80e89dd035
fix name of snapshot table
2025-06-04 17:20:25 -04:00
466863e71f
Procedures insert-all, update, and select for daily space air quality stats
2025-06-04 16:33:55 -04:00
30aafdede6
Merge pull request #390 from SyncrowIOT/DATA-device-model-aqi-update-logic
...
device model for aqi updated with hourly to daily logic getting max, …
2025-06-04 12:04:10 +03:00
01ce4d4b29
Merge pull request #396 from SyncrowIOT/fix-some-issue-in-get-commuinty-and-weather-apis
...
Fix some issue in get commuinty and weather apis
2025-06-04 01:32:21 -06:00
43dfaaa90d
fix: utilize WEATHER_API_URL in WeatherService for dynamic API endpoint
2025-06-04 01:32:01 -06:00
ea021ad228
fix: update error message for invalid latitude and longitude in fetchWeatherDetails method
2025-06-04 01:09:49 -06:00
cd3e9016f2
fix: improve error handling in fetchWeatherDetails method
2025-06-04 01:08:33 -06:00
ef2245eae1
Add AQI space daily pollutant stats module and related entities, DTOs, and repositories
2025-06-03 23:37:52 -06:00
3ad81864d1
updated space models to include suggested fixes, update final logic and column names
2025-06-03 21:05:34 -04:00
ab3efedc35
device model updated to include the fixes and final columns
2025-06-03 20:52:27 -04:00
4a984ae5dd
Merge pull request #395 from SyncrowIOT/SP-1678-be-implement-weather-apis-by-location
...
Add Weather module with controller, service, and DTO for fetching weather details
2025-06-03 03:05:01 -06:00
c39129f75b
Add Weather module with controller, service, and DTO for fetching weather details
2025-06-03 02:38:44 -06:00
35ce13a67f
fix: return proper error on login API ( #386 )
2025-06-03 09:47:24 +03:00
12a9272b8b
Merge pull request #393 from SyncrowIOT/SP-1675-be-return-space-uuid-in-get-devices-api
...
SP-1675-be-return-space-uuid-in-get-devices-api
2025-06-02 01:29:04 -06:00
0fe6c80731
Add utility function to associate space UUID with devices in community and device services
2025-06-01 21:56:08 -06:00
81e017430e
Merge pull request #392 from SyncrowIOT/temp-product-relation-fixes
...
Remove unique constraint on subspace and product in SubspaceProductAllocationEntity; update product relation to nullable in NewTagEntity
2025-06-02 06:20:03 +03:00
191d0dfaf6
Remove unique constraint on subspace and product in SubspaceProductAllocationEntity; update product relation to nullable in NewTagEntity
2025-06-01 21:16:51 -06:00
5b0135ba80
AQI space model updated with new hourly to daily logic for calculations and categorization of aqi brackets
2025-06-01 16:09:17 -04:00
2fee8c055e
device model for aqi updated with hourly to daily logic getting max, min, avergae and percentage of categorical values for each aqi bracket
2025-06-01 16:03:07 -04:00
59161d4049
Merge pull request #389 from SyncrowIOT/DATA-daily-space-aqi-model
...
Air quality and AQI for space model
2025-06-01 14:31:13 -04:00
b989338790
Merge pull request #388 from SyncrowIOT/DATA-device-aqi-fix-update
...
fixed pm25 code + date format. Added average AQI level from device
2025-06-01 14:31:00 -04:00
f5ed9d4fce
Merge pull request #387 from SyncrowIOT/DATA-occupancy-duration-fix
...
DATA-occupancy-duration-fix
2025-05-30 11:59:31 +03:00
3ac48183bd
procedure fix test
2025-05-30 11:27:12 +03:00
684205053d
testing fix
2025-05-30 10:51:26 +03:00
bfd92fdd87
fix
2025-05-29 15:05:06 +03:00
dd54af5f46
fix
2025-05-29 13:38:50 +03:00
90fc44ab53
Air quality and AQI for space model
2025-05-28 21:14:01 -04:00
efdf918159
fixed pm25 code + date format. Added average AQI level from device
2025-05-28 20:42:56 -04:00
25967d02f9
model adjustments
2025-05-28 13:55:56 +03:00
f44dc793a6
Merge pull request #383 from SyncrowIOT/daily-aqi-score
...
AQI score calculations and air quality model
2025-05-22 14:57:12 +03:00
a7c4bf1c3d
AQI score calculations and air quality model
2025-05-22 07:28:50 -04:00
a8bb161ee2
Merge pull request #382 from SyncrowIOT/DATA-monthly-yearly-procedure-occupancy
...
DATA-occupancy_count_per_month
2025-05-22 14:18:18 +03:00
fe891030aa
input year, output month
2025-05-22 13:10:05 +03:00
