Feat/parapharmacy api #38

Merged

Ichitux merged 25 commits from feat/parapharmacy-api into main 2026-07-16 15:38:59 +00:00

Conversation 0 Commits 25 Files Changed 43

+3961 -549

Ichitux commented 2026-07-16 15:00:08 +00:00

Owner

Copy Link

Copy Source

No description provided.

Ichitux added 23 commits 2026-07-16 15:00:08 +00:00

feat: add parapharmacy API with MongoDB and N8N setup ... b34657c78f

- Create parapharmacy-api microservice with Express + Swagger + MongoDB
- Add product model with full-text search and deduplication
- Add CRUD endpoints and bulk upsert for scrapers
- Update docker-compose.yml with MongoDB, N8N, and parapharmacy-api services
- Add proxy endpoints in FarmaFinder backend for parapharmacy
- Update frontend services to use parapharmacy API
- Add Swagger documentation at /api/docs

chore: remove Open Food Facts (OFF) integration ... 7274979f62

- Remove off-service.js and off-service.test.js
- Remove OFF import from server.js
- Simplify /api/products/search to only use CIMA
- Remove 'openfoodfacts' from valid product sources
- Update frontend-mobile Product interface to remove OFF source
- Remove OFF env vars from .env.example
- Add PARAPHARMACY_API_URL to .env.example

OFF was replaced by the new parapharmacy-api microservice.

fix: correct Dockerfile build context for parapharmacy-api ... c509253764

Changed build context from '.' to './apps/parapharmacy-api' so the
Dockerfile can find the src/ directory.

fix: use npm install instead of npm ci in Dockerfile ... 0c2f1cf928

npm ci requires package-lock.json which is at root level in monorepo.
npm install works without it.

feat: add N8N workflows and auto-setup configuration ... 1c70f0a914

- Add parapharmacy-scraper workflow (scheduled every 3 days)
- Add parapharmacy-manual-scraper workflow (webhook triggered)
- Configure N8N to auto-create owner account (skips /setup)
- Add N8N environment variables to docker-compose.yml
- Add README with setup and usage instructions

chore: add .env.example with all environment variables 52ddb9c21c

docs: add comprehensive parapharmacy and N8N documentation ... cb564fb170

- Create docs/parapharmacy.md with full API, N8N, and setup documentation
- Update README.md with parapharmacy system overview and links
- Add project structure for parapharmacy-api and n8n
- Update Docker setup section with all services
- Add API endpoints for parapharmacy
- Add N8N workflow automation section

feat: complete N8N scrapers for 6 sources and seed script ... 30f97fe87d

- Create comprehensive N8N workflow for all 6 parapharmacy sources
- Create webhook-triggered manual scraping workflow
- Add seed script with 20 sample products
- Update n8n/README.md with complete documentation
- Update docs/parapharmacy.md with seeding instructions
- Add seed script to package.json

Sources configured:
- Promofarma
- Pharmarket
- DocMorris
- 1001Farma
- Primor
- MiFarma

fix: add 'seed' and 'manual' to Product source enum ... e2dd3474a4

Allows seed script and manual product creation to work.

feat: add scrape script and fix N8N webhook workflow ... 2ad4210221

- Add direct scrape.js script for testing
- Fix N8N webhook workflow (lastNode response mode)
- Note: Real scraping requires Puppeteer for anti-bot sites

feat: working Puppeteer scraper for Promofarma ... a5a75d3249

- Added Puppeteer with Chrome in Docker
- Scraper extracts products using data attributes
- Added /api/scrape endpoint
- Tested: 10 products scraped from Promofarma

The scraper now works with Promofarma's HTML structure which uses
data-name, data-pvp attributes on article elements.

fix: fix parapharmacy proxy route order and add axios import ... 972a59662d

- Moved parapharmacy routes before :source/:id routes to prevent conflicts
- Added axios import to server.js
- Backend proxy now correctly forwards to parapharmacy-api
- Tested: search for 'capricare' returns 1 result, 'crema' returns 7 results

feat: working scraping for Promofarma, DocMorris, and Primor ... 05b99e9ed4

- Fixed Primor URL format and selectors
- Created simple N8N webhook that calls scraper API
- All 3 sources now working:
  - Promofarma: 20 products
  - DocMorris: 10 products
  - Primor: 20 products
- Total: 130 products in database
- N8N webhook at /webhook/scrape working correctly

feat: unified search - remove filter tabs, show all results together ... 570d4ab43e

- Frontend now searches both CIMA and Parapharmacy simultaneously
- Removed filter tabs (Todos/Medicamentos/Parafarmacia)
- Results show in a single unified list
- Mobile: Shows medicines first, then parapharmacy section
- Web: Same unified approach with results summary

fix: product detail view for parapharmacy products ... 3429b7e548

- Updated ProductView to use correct endpoint for parapharmacy
- Updated getProduct service to handle parapharmacy products
- Shows price, category, brand, source for parapharmacy products
- Updated labels from 'OFF' to 'Parafarmacia'

fix: update ProductResults and admin panel for parapharmacy ... 3666f4dee8

- Updated ProductResults component with new source labels
- Added price display for parapharmacy products
- Updated admin panel to search both CIMA and Parapharmacy
- Updated getSourceBadge to handle parapharmacy sources
- Added CSS for product price display

fix: allow parapharmacy sources in pharmacy-products endpoint ... e5dcfbd2f5

Updated validation to accept: cima, promofarma, docmorris, primor, parapharmacy

Before: product_source must be 'cima'
After: product_source must be one of: cima, promofarma, docmorris, primor, parapharmacy

fix: use _id for MongoDB products in frontend ... 63b25e3f4f

- SearchView now uses p._id || p.id for product navigation
- ProductResults uses product._id || product.id for React key
- Fixes 'undefined' error when clicking parapharmacy products

fix: use parapharmacy endpoint for all non-CIMA sources ... dca7e373cd

- ProductView now checks if source is 'cima' to decide endpoint
- All other sources (seed, promofarma, docmorris, primor) use parapharmacy endpoint
- Same fix applied to mobile getProduct function

Before: only 'parapharmacy' source used parapharmacy endpoint
After: all non-CIMA sources use parapharmacy endpoint

fix: handle both array and object responses in admin search ... 26e7d92079

The CIMA search API returns {results: [...]} but the admin panel
was treating it as an array, causing CIMA products to be lost.

Now handles both formats:
- Array: [...]
- Object: {results: [...]}

fix: add 'seed' and 'manual' to valid product sources ... 08b7437803

Products created via seed script or manual entry have source='seed'
or 'manual', which wasn't in the valid sources list.

fix: add pharmacy map to ProductView and fix pharmacies endpoint ... 6155fdcd15

- Added PharmacyMap component to ProductView
- Updated backend to accept all valid sources for pharmacies endpoint
- Shows map with pharmacy locations and list of pharmacies with prices

feat: add sort by distance and directions to ProductView ... de8fdbb904

- Added sort by distance functionality (same as SearchView)
- Added PharmacyList component with distance display
- Added 'Cómo llegar' button in map popup (Google Maps directions)
- Uses haversineKm for distance calculation

Ichitux added 1 commit 2026-07-16 15:04:54 +00:00

fix: filter scraper results by search query ... fa74a6e060

The scraper was extracting ALL products from the page including
navigation menu items. Now it filters products to only include
those that contain the search query in their name.

Before: Found 47 products (mostly navigation items)
After: Found 2 Capricare products (filtered by query)

Ichitux added 1 commit 2026-07-16 15:32:25 +00:00

fix: sync package.json and fix test scripts ... 8763f54071

- scraper: changed test script to echo (no tests)
- parapharmacy-api: added --passWithNoTests to jest
- frontend: changed vitest to vitest run (exit after tests)

All tests now pass:
- backend: 17 tests passed
- frontend: 7 tests passed
- parapharmacy-api: no tests (exits cleanly)
- scraper: no tests (exits cleanly)

Ichitux merged commit 41d3e5cd9a into main 2026-07-16 15:38:59 +00:00

Ichitux deleted branch feat/parapharmacy-api 2026-07-16 15:39:00 +00:00

Sign in to join this conversation.

Reviewers

No Reviewers

Labels

No items

No Label

Milestone

No items

No Milestone

Projects

Clear projects

No project

Assignees

Clear assignees

Ichitux

No Assignees

1 Participants

Notifications

Subscribe

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: Ichitux/FarmaFinder#38