tidal-agriculture

As a user, I want to view an interactive agricultural landscape on the Home page with animated crop hotspots, region selection, and quick summaries. Implement the Home (v4) JSX design including the collapsible sidebar for filters (crop type, region, date range), animated hotspots, real-time price change animations, and navigation to Market Prices page. This is the landing page for Farmers, Traders, and Researchers.

As an admin, I want to securely log in to the system via the Login page. Implement the Login (v3) JSX design with a secure authentication form, 🌾 ಕೃಷಿ ಸ್ಪಂದನ branding, and navigation to the Admin Dashboard on success. Ensure validation and error state handling.

As an admin, I want to view an overview dashboard after login to access Manage Crop Prices, View Activity Logs, and Configure Scheduler. Implement the Dashboard (v2) JSX design showing system statistics, navigation links to all admin sub-sections, and a summary panel for recent activity.

As a user (farmer, trader, researcher), I want to select a crop from a dropdown and filter results by market name and date to view current market prices in a tabular format. Implement the Market Prices (v2) JSX design with crop dropdown, market and date filters, price table with conditional formatting for high prices, and navigation to Price Trends page.

As a farmer, I want to set my preferences (region, preferred crops, language) on my Profile page. Implement the Profile (v2) JSX design with user preference form, regional language selector, notification settings, and navigation back to Home.

As a user, I want to view graphical trends of crop prices over time and compare markets. Implement the Price Trends (v2) JSX design using Chart.js with price vs date graphs, historical trend analysis, market comparison view, and navigation to Forecasting page. Support date range filtering for researchers.

As an admin, I want to manage crop price records by inserting new prices and viewing existing price records. Implement the Crop Prices (v2) JSX design with a data entry form for new prices (crop, market, price, auto-date), a paginated price records table, and navigation back to the Dashboard.

As an admin, I want to view and filter user activity logs to monitor platform usage. Implement the Activity Logs (v3) JSX design with a filterable log table, date range and user type filters, log detail view, and navigation back to Dashboard.

As an admin, I want to configure and set intervals for automatic crop price updates. Implement the Scheduler (v2) JSX design with interval configuration controls, schedule status display, start/stop scheduler actions, and navigation to Settings page.

As a user, I want the backend to serve crop price data filtered by crop, market, and date. Implement Flask API endpoints: GET /api/prices (with query params for crop_id, market_id, date), using SQL joins across crops, markets, and prices tables with MySQL connector. Support pagination and conditional formatting data for high prices.

As a farmer, I want to save and retrieve my preferences (region, crops, language) via backend APIs. Implement Flask endpoints: GET /api/profile, PUT /api/profile (update preferences including region, preferred_crops, language). Store preferences in user profile table and apply localization settings.

As a user (farmer, trader, researcher), I want to view crop recommendations and insights based on historical data and market trends. Implement the Recommendations (v2) JSX design showing suggested profitable crops, reasoning (e.g. '20% price increase over 3 months'), analytics view for researchers, and navigation to Forecasting page.

As an admin, I want to configure system-level settings after scheduler setup. Implement the Settings (v2) JSX design with system configuration panels, localization settings (regional language support), and accessibility options. Navigation flows from Scheduler page.

As a user, I want the backend to provide historical price trend data for Chart.js graphs. Implement Flask API endpoints: GET /api/trends (with crop_id, market_id, date_range params) returning time-series data for price vs date visualization and market comparison.

As an admin, I want backend APIs to insert and retrieve crop price records. Implement Flask endpoints: POST /api/admin/prices (insert new price with auto system date), GET /api/admin/prices (list all price records with pagination). Secure endpoints with admin session authentication.

As an admin, I want backend APIs to fetch and filter user activity logs. Implement Flask endpoints: GET /api/admin/logs (with filter params for user_type, date_range, action_type). Log user actions (price queries, downloads, logins) automatically via middleware.

As an admin, I want a Python scheduler service that automatically inserts simulated crop price data at configurable intervals. Implement APScheduler or Celery-based scheduler with Flask endpoints: POST /api/admin/scheduler/start, POST /api/admin/scheduler/stop, PUT /api/admin/scheduler/interval. Persist scheduler config in database.

As a user, I want to view market demand forecasts and explore model insights for selected crops with selectable timeframes (next week, next month). Implement the Forecasting (v1) JSX design with forecast graphs, timeframe selector, model insights panel, and navigation to Reports page. Display expected price change indicators.

As a user, I want an AI-powered crop recommendation engine that suggests profitable crops based on historical price trends. Integrate GPT and Gemini via LiteLLM and Langchain for user-friendly recommendation responses. Implement Flask endpoint: GET /api/recommendations (with user_region, crop_preferences params). Use scikit-learn for rule-based filtering and LLM for natural language insights.

As a researcher or trader, I want to download detailed reports of price trends and forecasts. Implement the Reports (v2) JSX design with report generation options, date range selection, format options (Excel/PDF), and download functionality. Navigation flows from Forecasting page.

As a user, I want ML-based market demand forecasting for selected crops with selectable timeframes. Implement ARIMA/LSTM models using statsmodels or TensorFlow/Keras for time-series price forecasting. Integrate with Langchain and LiteLLM for model insights narrative. Flask endpoint: GET /api/forecast (with crop_id, market_id, timeframe params). Return forecast values and confidence intervals for Chart.js visualization.

As a researcher or trader, I want to download price trend and forecast reports in Excel or PDF format. Implement Flask endpoint: POST /api/reports/generate (with report_type, date_range, crop_id, format params). Use libraries like openpyxl for Excel and ReportLab/WeasyPrint for PDF. Stream file download response.