Michael/Apiflow
1
0 Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity

Commit Graph

  • adc8d357c9 fix: dedupe cube_pa rows by artnoid before full refresh main fix/cube-pa-dedupe MichaelandClaude Opus 4.8 2026-07-10 12:30:49 +02:00
  • 950539472f Merge remote-tracking branch 'origin/claude/gallant-edison-i5bg90' Michael 2026-07-09 09:13:35 +02:00
  • e01048fe3b Merge pull request #2 from R0m1k3/feat/artcentrale-api LogiFlow 2026-07-09 09:10:28 +02:00
  • f00b9c4b14 feat(articles): expose and filter code centrale (artcentrale) feat/artcentrale-api MichaelandClaude Opus 4.8 2026-07-09 09:09:25 +02:00
  • c5b0896bb4 fix: dedupe foucad rows by foucode before full refresh claude/gallant-edison-i5bg90 Claude 2026-06-29 06:30:00 +00:00
  • 62249e6c13 docs: update API documentation with missing endpoints and schema corrections Michael 2026-05-28 16:45:14 +02:00
  • f16e2efe0b fix: use preference = 1 (integer) instead of true (boolean) in artfou1 joins MichaelandClaude Sonnet 4.6 2026-05-21 16:14:52 +02:00
  • 329a4c018c feat: add fournisseur filter to hitparade endpoint MichaelandClaude Sonnet 4.6 2026-05-21 15:55:45 +02:00
  • f83a090cfb feat: add article management routes with search, detail, and referential data endpoints Michael 2026-05-06 11:43:15 +02:00
  • ab8ed85c84 feat: add photos route with sitemap indexing and status endpoints Michael 2026-05-06 11:31:48 +02:00
  • 95799add1d feat: initialize Postgres schema and set up core API routing for articles and photos Michael 2026-05-06 11:30:03 +02:00
  • 79c7628b99 feat: implement article routes and product photo resolution service Michael 2026-05-06 11:04:09 +02:00
  • 6bbfc1696b feat: implement articles route with product search, detail, and referential data endpoints Michael 2026-05-06 10:00:44 +02:00
  • 57e9449a58 fix: nomenclature CA - valeurs absolues, GenreMvt IN(3,4,9), traversée hiérarchie MichaelandClaude Sonnet 4.6 2026-04-26 09:28:51 +02:00
  • c1d6f87a7e feat: publicites - add total/pages to list, add /historique endpoint MichaelandClaude Sonnet 4.6 2026-04-24 13:10:22 +02:00
  • 408dcc61bb feat: add statut filter and statut field to publicites endpoint Michael 2026-04-24 13:00:13 +02:00
  • a6a86f680a fix: show suppliers with qtepropo=0 if active (datecdeauto recent), fixes B008 missing Michael 2026-04-24 12:43:30 +02:00
  • d9b4c1eb44 fix: filter commandes-auto by datecdeauto within 7 days to exclude deactivated suppliers Michael 2026-04-24 12:35:22 +02:00
  • c278a931f8 fix: remove foucad.actif filter, qtepropo=0 is the source of truth for exclusion Michael 2026-04-24 12:21:38 +02:00
  • 30440be275 fix: use IS NOT FALSE to keep suppliers without foucad entry in commandes-auto Michael 2026-04-24 12:16:13 +02:00
  • 6d7b1fb44d fix: exclude suppliers with foucad.actif=false from commandes-auto Michael 2026-04-24 12:13:35 +02:00
  • a68e706805 feat: add GET /api/fournisseurs/:code/franco endpoint Michael 2026-04-24 12:05:47 +02:00
  • 7312b84233 fix: resolve duplicate rows in commandes-auto caused by fouport multi-site join Michael 2026-04-24 11:44:26 +02:00
  • 2f920d8623 fix: use fouident.nom instead of FOUADR1.RAISONSOCIALE for supplier names in articles routes Michael 2026-04-24 11:06:34 +02:00
  • e15852a6aa feat: implement API routes for article search, details, and movement history Michael 2026-04-24 10:54:11 +02:00
  • 6f2b98864e feat: implement express route handlers for movements, articles, and suppliers data retrieval Michael 2026-04-24 10:49:53 +02:00
  • 204fd97d7d Merge branch 'main' of https://github.com/R0m1k3/Apiflow Michael 2026-04-24 10:05:39 +02:00
  • d3052a6235 feat: implement movement and article route handlers and register them in the main application entry point Michael 2026-04-24 10:05:37 +02:00
  • c75fd5c56d fix: utiliser FOUPORT2.SEUIL comme source principale du franco fournisseur MichaelandClaude Sonnet 4.6 2026-04-13 15:58:15 +02:00
  • b4a9331fa8 chore: update ff_sync environment variables in docker-compose.yml to support dynamic configuration Michael 2026-04-09 08:42:44 +02:00
  • ef4734ff39 refactor: migrate sync service environment variables to .env.docker file Michael 2026-04-09 08:22:18 +02:00
  • 5a5bc8b6f3 feat: add sync script for procurement tables including orders, lines, and reordering plans Michael 2026-04-09 08:19:55 +02:00
  • d74cdeb7b3 feat: implement automated procurement synchronization and API endpoints for supply chain management Michael 2026-04-09 08:18:10 +02:00
  • 6e5bc3bc07 feat: ajout endpoint /api/commandes-auto avec franco fournisseur MichaelandClaude Sonnet 4.6 2026-04-08 15:24:51 +02:00
  • 42f7c9bac6 feat: add sync script for advertising tables from MSSQL to PostgreSQL Michael 2026-04-07 11:10:42 +02:00
  • 9e993b3559 feat: implement advertising data synchronization and API endpoints for performance tracking Michael 2026-04-07 10:34:36 +02:00
  • de69370d9e feat: add web dashboard for monitoring sync status and logs Michael 2026-04-01 10:52:02 +02:00
  • cb0b608edb feat: implement synchronization logic for mouvements and statopca tables from MSSQL to PostgreSQL Michael 2026-04-01 10:18:12 +02:00
  • 90d1b1675c feat: implement movement synchronization logic and initialize PostgreSQL schema tables Michael 2026-04-01 10:04:17 +02:00
  • 7df3025fd8 feat: add performance route for sales analytics, hit parades, and dashboard metrics Michael 2026-04-01 09:56:05 +02:00
  • 5fb99dc7f5 feat: add performance analytics routes for sales, hit parades, and dashboard metrics Michael 2026-04-01 09:31:13 +02:00
  • 2839a615fd feat: implement automated sync service with cron scheduling and web dashboard Michael 2026-04-01 09:18:36 +02:00
  • e20c253df8 feat: add sync module for supplier data including artfou1, artfou2, and fouadr1 tables Michael 2026-03-31 13:51:34 +02:00
  • d885f51bdb feat: add sync script for appro tables including commande_fou, cdefou_ligne, commande_auto_qtepropo, and plan_reappro Michael 2026-03-30 18:34:24 +02:00
  • e629a1c699 feat: implement provisioning and synchronization logic for procurement tables Michael 2026-03-30 17:59:51 +02:00
  • 624d9ab851 feat: add sync logic for procurement tables including orders, lines, and reappro plans Michael 2026-03-30 13:11:49 +02:00
  • 3f23f181f4 feat: Implement initial PostgreSQL schema and synchronization scripts for various data tables. Michael 2026-03-30 12:43:41 +02:00
  • 52c47acc67 feat: add stat_dispoperm and phenix_quantite_conseille to sync pipeline MichaelandClaude Sonnet 4.6 2026-03-27 08:13:14 +01:00
  • c5faddde1f feat: Add synchronization of articles, article supplementary information, GTINs, and permanent availability statistics from MSSQL to PostgreSQL. Michael 2026-03-27 08:10:21 +01:00
  • a8acba554f feat: Add performance API routes for turnover, hit parade, nomenclature, product range, and a daily dashboard. Michael 2026-03-22 10:55:05 +01:00
  • 371f80c844 Dashboard top10: rank per site instead of global Michael 2026-03-21 11:50:23 +01:00
  • 9675a243b7 feat: Implement initial API backend with a comprehensive PostgreSQL schema, Express application, and data synchronization for articles and ranking. Michael 2026-03-21 10:01:02 +01:00
  • e189cc3045 fix(sync): ranking dedup + copy logs over HTTP MichaelandClaude Opus 4.6 2026-03-19 12:06:27 +01:00
  • 5ce480ade3 fix: mssql requestTimeout 5min + try/catch par étape sync MichaelandClaude Opus 4.6 2026-03-19 11:34:36 +01:00
  • cf6a7aa0b2 feat: dashboard logs copiables + bouton copier + ranking dans TABLES_ORDER MichaelandClaude Opus 4.6 2026-03-19 11:16:32 +01:00
  • cbfaee2dfb fix: mvtart sync ON CONFLICT DO NOTHING + doc ranking API MichaelandClaude Opus 4.6 2026-03-19 11:03:28 +01:00
  • 792ddc71d2 feat: add ranking table sync and API endpoints MichaelandClaude Opus 4.6 2026-03-19 10:54:04 +01:00
  • 8cafc196cf feat: add API routes for sales performance metrics including turnover, hit parade, nomenclature, and product range analysis. Michael 2026-03-19 10:30:56 +01:00
  • 9bc372c959 fix: taux_marge toujours 0 - MntMvtTTC négatif pour les ventes, utiliser ABS(MntMvtHt) MichaelandClaude Sonnet 4.6 2026-03-18 19:42:58 +01:00
  • f052529db6 fix: mouvements/types - grouper par GenreMvt uniquement (évite 28MB pour les tickets) MichaelandClaude Sonnet 4.6 2026-03-18 16:52:45 +01:00
  • c98f6834a8 feat: Implement article list, detail, and referential endpoints, and document the monthly article analysis endpoint. Michael 2026-03-18 16:46:46 +01:00
  • 2101606bb4 feat: implement stock management API endpoints and update the API documentation. Michael 2026-03-18 12:03:18 +01:00
  • 6dbfa2b32d Fix commandes: filter NULL artfou1_no_id, BIT->SMALLINT for recpb/recpbok Michael 2026-03-18 11:05:22 +01:00
  • 984ed4da5f Fix sync: null bytes, BIT→SMALLINT, DECIMAL complex types, NbJours safe int, error_msg column Michael 2026-03-18 11:03:29 +01:00
  • 20a1396810 Add dotenv to sync dependencies Michael 2026-03-18 10:57:40 +01:00
  • e66dff8420 Add sync dashboard (port 3001) with real-time progress tracking Michael 2026-03-18 10:54:15 +01:00
  • ab7a34253a Expose API port 3000 to host Michael 2026-03-18 10:43:25 +01:00
  • f1c5928152 Regenerate package-lock.json with pg dependency Michael 2026-03-18 10:41:17 +01:00
  • 80e8df7deb Add package-lock.json files for reproducible Docker builds Michael 2026-03-18 10:40:35 +01:00
  • d565ed9f10 Initial commit : API Node.js + PostgreSQL + sync service Docker MichaelandClaude Sonnet 4.6 2026-03-18 10:10:47 +01:00