Michael/CollectFlow
1
0 Fork 0
mirror of https://github.com/R0m1k3/CollectFlow.git synced 2026-10-11 17:26:32 +02:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • 3e4b320cbe chore: add diag-mvtart to inspect columns and CA totals MichaelandClaude Sonnet 4.6 2026-04-01 09:28:53 +02:00
  • c5fbc85c6c fix: artfou1.preference is integer, use = 1 not = true MichaelandClaude Sonnet 4.6 2026-04-01 09:12:11 +02:00
  • 79aadf62eb fix: use artfou1.preference=true and ABS(SUM(mntmvtttc)) for correct CA TTC in analytics MichaelandClaude Sonnet 4.6 2026-04-01 09:07:43 +02:00
  • bc76237f48 feat: sort analytics by name (fournisseur) or code asc (nomenclature); show code in nomenclature label; remove diag-fournisseurs endpoint MichaelandClaude Sonnet 4.6 2026-04-01 08:42:21 +02:00
  • 65b55b1343 fix: use fouident.nom instead of fouadr1.raisonsociale for supplier names MichaelandClaude Sonnet 4.6 2026-03-31 17:40:40 +02:00
  • f0a360115f chore: inspect fouident table for correct supplier names Michael 2026-03-31 17:32:54 +02:00
  • 67b0c8c74f chore: inspect v_ca_fournisseur view structure Michael 2026-03-31 13:52:22 +02:00
  • 072479b30f chore: fix diag-fournisseurs to inspect real fouadr1 column structure Michael 2026-03-31 13:44:19 +02:00
  • 09f80b35cb chore: add diag-fournisseurs endpoint to investigate fouadr1 sit_code and naming Michael 2026-03-31 13:40:08 +02:00
  • 853a36cb97 fix: override D005 display name from 'BAZAR 5000' to 'Dépôt' MichaelandClaude Sonnet 4.6 2026-03-31 13:38:41 +02:00
  • cfd3a7e601 chore: remove temporary diag-supplier investigation endpoint MichaelandClaude Sonnet 4.6 2026-03-31 12:08:15 +02:00
  • 51adac0349 fix: attribute CA to supplier of last stock entry (dernière entrée en stock) MichaelandClaude Sonnet 4.6 2026-03-31 12:05:38 +02:00
  • 3d77f6b879 chore: add diag-supplier endpoint for artfou1 supplier attribution investigation MichaelandClaude Sonnet 4.6 2026-03-31 11:08:23 +02:00
  • 5436513e30 fix: use most recent artfou1 entry (no_id DESC) for supplier attribution MichaelandClaude Sonnet 4.6 2026-03-31 10:44:50 +02:00
  • b420dc2a2b fix: prevent CA multiplication in analytics by using DISTINCT ON per article MichaelandClaude Sonnet 4.6 2026-03-31 10:36:19 +02:00
  • 7e8b50e143 fix: remove function prop, unused import and useSearchParams in analytics MichaelandClaude Sonnet 4.6 2026-03-31 10:32:21 +02:00
  • c9df9feccd fix: replace IN() with OR conditions in analytics SQL for Drizzle compatibility MichaelandClaude Sonnet 4.6 2026-03-31 10:27:32 +02:00
  • d8a9bf80a0 fix: correct SQL parameterization in analytics queries and use distinct icons Michael 2026-03-31 10:02:44 +02:00
  • 740aed3181 feat: add analytics page with CA TTC comparison by supplier/nomenclature MichaelandClaude Sonnet 4.6 2026-03-31 09:40:31 +02:00
  • 7a30783285 fix: force score=0 for zero-sale products and fix reception SQL sign MichaelandClaude Sonnet 4.6 2026-03-25 09:19:57 +01:00
  • 76b06419a0 feat: add PostgreSQL client to replace per-article HTTP calls with bulk SQL queries for FF Nancy data. Michael 2026-03-23 16:56:22 +01:00
  • 8ecba594cf feat: introduce virtualized heatmap grid component with dynamic monthly data and optimized cell rendering. Michael 2026-03-23 16:20:17 +01:00
  • ffa257fda1 feat: Implement product heatmap grid with comprehensive data aggregation and PostgreSQL client for product rows. Michael 2026-03-23 16:09:09 +01:00
  • bba6fe05e8 feat: implement client-side grid orchestrator and core heatmap table component. Michael 2026-03-23 14:13:39 +01:00
  • 53b85381fa feat: add server-side API for fetching and processing comprehensive product data for the grid. Michael 2026-03-23 14:00:27 +01:00
  • 99954fb001 feat: Add AI Copilot Zustand store for managing and persisting product insights. Michael 2026-03-23 13:34:36 +01:00
  • 86df5d6f29 feat: introduce BulkAiAnalyzer component for bulk product classification and AI context profiling. Michael 2026-03-23 12:43:02 +01:00
  • c63a60c0cf feat: implement PostgreSQL client for FF Nancy API data with bulk SQL queries, replacing per-article HTTP calls. Michael 2026-03-23 11:58:50 +01:00
  • 2eb196861b feat: Implement initial dashboard page displaying network-level KPIs and individual store statistics. Michael 2026-03-22 10:41:32 +01:00
  • 38979debb8 feat: implement dashboard page with network KPIs and store statistics. Michael 2026-03-21 19:41:59 +01:00
  • 33deb033b5 feat: implement dashboard page with network-wide and site-specific KPIs, and top 10 items display. Michael 2026-03-21 19:36:02 +01:00
  • f24da605af feat: Implement direct PostgreSQL client for FF Nancy data, replacing per-article HTTP API calls. Michael 2026-03-21 19:24:51 +01:00
  • 46c799bd60 feat: Add dashboard page displaying network KPIs and store statistics, along with a new PostgreSQL data client. Michael 2026-03-21 19:18:41 +01:00
  • a705d0043d feat: Add dashboard page displaying network KPIs, site statistics, and top-selling items. Michael 2026-03-21 18:55:33 +01:00
  • 3a74689f31 feat: Add PostgreSQL client for bulk fetching FF Nancy data, replacing per-article HTTP API calls. Michael 2026-03-21 17:11:54 +01:00
  • 6ee0e3294d feat: Introduce direct PostgreSQL client for FF Nancy data to replace HTTP API calls and add a new dashboard page. Michael 2026-03-21 14:37:02 +01:00
  • d1bbe290da feat: Implement dashboard layout and a new PostgreSQL client for optimized FF Nancy data fetching via bulk SQL queries. Michael 2026-03-21 13:07:59 +01:00
  • e3d241a5ff feat: add PostgreSQL client for FF Nancy to replace per-article HTTP API calls with bulk SQL queries. Michael 2026-03-21 11:59:36 +01:00
  • 1664aaf4cc feat: Implement initial dashboard page displaying key performance indicators, site statistics, top items, and monthly evolution. Michael 2026-03-21 08:54:52 +01:00
  • 1e393753fa feat: Implement PostgreSQL client for FF Nancy to replace per-article HTTP calls with bulk SQL queries. Michael 2026-03-21 08:37:33 +01:00
  • eb8ca92847 feat: Add PostgreSQL client for FF Nancy to replace per-article HTTP calls with bulk SQL queries. Michael 2026-03-21 00:56:36 +01:00
  • 966b13cdf0 feat: implement dashboard page displaying KPIs, site statistics, top items, and monthly evolution using a new PostgreSQL client. Michael 2026-03-21 00:22:14 +01:00
  • 7cb96966aa feat: implement PostgreSQL client for FF Nancy data, replacing per-article HTTP calls with bulk SQL queries. Michael 2026-03-20 16:09:22 +01:00
  • d5a422e738 feat: Implement dashboard page, its data fetching client, and shared sidebar component. Michael 2026-03-20 14:43:19 +01:00
  • e391550a30 feat: Introduce product assortment grid client and direct PostgreSQL data access for FF Nancy. Michael 2026-03-20 14:25:30 +01:00
  • 2e1988a6f5 feat: Implement PostgreSQL client for FF Nancy, replacing per-article HTTP API calls with bulk SQL queries. Michael 2026-03-20 14:18:22 +01:00
  • 8c5f1c16be feat: add PostgreSQL client for FF Nancy data, replacing per-article HTTP calls with bulk SQL queries. Michael 2026-03-20 14:07:53 +01:00
  • 1aed954606 feat: Replace per-article HTTP calls with direct bulk SQL queries via new PostgreSQL client for FF Nancy data. Michael 2026-03-20 13:59:30 +01:00
  • 4996e126b3 feat: implement PostgreSQL client to replace per-article HTTP API calls with bulk SQL queries for FF Nancy data. Michael 2026-03-20 13:31:19 +01:00
  • dd846247c9 feat: add PostgreSQL client to fetch FF Nancy data via bulk SQL queries, replacing per-article HTTP requests. Michael 2026-03-20 13:23:07 +01:00
  • 6827257f95 feat: Add PostgreSQL client for FF Nancy data, replacing HTTP API calls with efficient bulk SQL queries. Michael 2026-03-20 13:07:09 +01:00
  • b4f583415b feat: Add PostgreSQL client for FF Nancy data, replacing HTTP API calls with bulk SQL queries for improved performance. Michael 2026-03-20 11:39:40 +01:00
  • d5b518477a feat: Add PostgreSQL client for FF Nancy data, replacing per-article HTTP calls with bulk SQL queries for improved performance. Michael 2026-03-20 11:30:54 +01:00
  • 750017de14 feat: Add PostgreSQL client for FF Nancy data, replacing per-article HTTP API calls with bulk SQL queries for improved performance. Michael 2026-03-20 11:17:24 +01:00
  • 4b84b56aa6 feat: Introduce a PostgreSQL client for direct FF Nancy data access, replacing per-article HTTP API calls with bulk SQL queries. Michael 2026-03-20 10:57:21 +01:00
  • eb0fb14021 feat: Add PostgreSQL client for direct FF Nancy database access, replacing per-article HTTP API calls with bulk SQL queries. Michael 2026-03-20 10:44:49 +01:00
  • a875dbda86 feat: Add PostgreSQL client for FF Nancy to replace per-article HTTP calls with bulk SQL queries. Michael 2026-03-20 10:37:47 +01:00
  • 70b49c5c56 feat: Introduce getProductRows server action for fetching and processing comprehensive product data from PostgreSQL. Michael 2026-03-20 10:25:24 +01:00
  • f94d7753b4 feat: Implement direct PostgreSQL client for FF Nancy data, replacing HTTP API calls with bulk SQL queries for improved performance. Michael 2026-03-20 10:12:39 +01:00
  • 4dd1b5f7c7 feat: Introduce PostgreSQL client for bulk data retrieval and integrate it into product grid data fetching actions. Michael 2026-03-20 10:05:30 +01:00
  • 58d467a7ea feat: implement product row data retrieval and processing logic for the grid. Michael 2026-03-20 09:58:32 +01:00
  • 65f455b4e2 perf: referentiel+ranking only for articles with sales, per-article ranking MichaelandClaude Sonnet 4.6 2026-03-19 22:02:12 +01:00
  • 383b8ccac7 fix: ranking bulk match by codein AND gencod/gtin, add entry key logging MichaelandClaude Sonnet 4.6 2026-03-19 21:51:42 +01:00
  • 1cd3ade77e perf: remove actif filter, increase batchSize, exclude Y articles without sales MichaelandClaude Sonnet 4.6 2026-03-19 21:23:34 +01:00
  • be3a196744 perf: parallel article pagination + single-call full ranking fetch MichaelandClaude Sonnet 4.6 2026-03-19 20:58:03 +01:00
  • a16ec24cd7 perf+fix: parallelize article pagination, filter inactive articles, add gamme Y MichaelandClaude Sonnet 4.6 2026-03-19 20:23:38 +01:00
  • 69c7d65482 feat: Add Claude settings to allow specific Git and Next.js Bash commands. Michael 2026-03-19 20:06:11 +01:00
  • dcebf74f31 perf: replace N ranking API calls with 1 bulk fetch per supplier MichaelandClaude Sonnet 4.6 2026-03-19 18:53:49 +01:00
  • 414bf6133d fix: correct snapshot save to detect all gamme changes (drafts + validated) MichaelandClaude Opus 4.6 2026-03-19 17:13:49 +01:00
  • 01d2dc8b34 feat: add BulkAiAnalyzer component for automatic product classification and AI context profiling. Michael 2026-03-19 15:52:48 +01:00
  • 41a8b32aff feat: Add API route to export modified gammes data to an Excel file. Michael 2026-03-19 15:28:16 +01:00
  • 7cdbe8ec21 feat: add Zustand store for grid state and a hook to save draft modifications Michael 2026-03-19 15:17:28 +01:00
  • aa69637f98 feat: Introduce bulk AI analyzer component to pre-classify products and prepare data for AI analysis, including context profiling. Michael 2026-03-19 13:19:49 +01:00
  • a4528c6d14 feat: Add HeatmapGrid component for visualizing product data with TanStack Table, virtualization, and performance optimizations. Michael 2026-03-19 13:02:16 +01:00
  • 34529f3934 feat: add FF Nancy API client for fetching suppliers, articles, and movements with pagination and data mapping. Michael 2026-03-19 12:55:55 +01:00
  • 8b7d81b20c feat: implement product grid with comprehensive product data fetching, processing, and heatmap display. Michael 2026-03-19 12:41:03 +01:00
  • 2b7e7bc1f4 feat: Introduce AI analysis engine with detailed system prompt and user message generation for product recommendations, and add an OpenRouter client. Michael 2026-03-19 09:50:28 +01:00
  • d8a9329075 feat: Introduce AI Copilot feature with product analysis engine, state management, and UI components for insights. Michael 2026-03-19 07:53:56 +01:00
  • 95795ce7e3 feat: Introduce AI analysis engine for product A/Z recommendations based on detailed business rules. Michael 2026-03-18 22:15:14 +01:00
  • e96bfa818d feat: Add a percentile composite score engine to calculate product performance based on sales, volume, and margin. Michael 2026-03-18 21:41:29 +01:00
  • de768128e3 feat: implement AI copilot analysis engine with v5 simplified system prompt and product recommendation rules. Michael 2026-03-18 21:34:31 +01:00
  • aa02d019bd feat: Implement AI Copilot for product analysis and add comprehensive product grid data fetching. Michael 2026-03-18 21:25:53 +01:00
  • cefe6060d0 feat: implement virtualized heatmap grid component using TanStack Table and Virtual for product data display. Michael 2026-03-18 20:52:13 +01:00
  • aa77025d14 feat: introduce virtualized heatmap grid component with client-side filtering, sorting, and optimized Zustand state management. Michael 2026-03-18 20:49:57 +01:00
  • 9aca3b8ead feat: Add virtualized heatmap grid component with dynamic columns, filtering, and row selection. Michael 2026-03-18 20:34:23 +01:00
  • 8bd7ae8c45 feat: implement server action to fetch and process product rows with sales, stock, and classification data. Michael 2026-03-18 20:08:15 +01:00
  • c303427dd0 feat: implement a centralized HTTP client for the FF Nancy REST API, including data types, pagination, and functions for suppliers, articles, and movements. Michael 2026-03-18 20:00:45 +01:00
  • ab603e3a6f feat: Add a diagnostic API route and implement server-side logic for fetching and scoring product grid data. Michael 2026-03-18 19:54:44 +01:00
  • d616da8b91 feat: Introduce getProductRows API and related types for fetching and processing comprehensive product data, incorporating sales, stock, and classification. Michael 2026-03-18 19:31:16 +01:00
  • 8986f7d001 feat: integrate /referentiel endpoint for nomenclature, gamme, stock, PA MichaelandClaude Sonnet 4.6 2026-03-18 19:26:47 +01:00
  • ca467c73f6 chore: probe /api/articles/:no_id/referentiel in diag MichaelandClaude Sonnet 4.6 2026-03-18 19:24:09 +01:00
  • 06e1b1a238 chore: add ventesProduits diagnostic to diag endpoint MichaelandClaude Sonnet 4.6 2026-03-18 19:17:22 +01:00
  • 84aa84cf41 fix: use Drizzle inArray() for ventesProduits classification query MichaelandClaude Sonnet 4.6 2026-03-18 19:15:24 +01:00
  • 09be89b557 fix: query ventesProduits by codein array instead of code_fournisseur MichaelandClaude Sonnet 4.6 2026-03-18 19:05:58 +01:00
  • 518838c01e feat: introduce getProductRows API to fetch, process, and score product data from multiple sources. Michael 2026-03-18 18:11:08 +01:00
  • 47e617afd3 feat: restore reference, gtin, gamme initiale and nomenclature MichaelandClaude Sonnet 4.6 2026-03-18 18:08:21 +01:00
  • 58f17152a1 feat: switch to /articles/:no_id/mensuel endpoint for sales & stock data MichaelandClaude Sonnet 4.6 2026-03-18 18:00:55 +01:00
  • 2d37a134d4 chore: update diag to probe new mensuel, stock/periode, and mouvements/types endpoints MichaelandClaude Sonnet 4.6 2026-03-18 16:44:01 +01:00
  • 8aac493a97 feat: Add Claude settings to allow Bash git push operations. Michael 2026-03-18 16:37:16 +01:00
  • 5c40a615c7 fix: correct API field names for articles and mouvements endpoints MichaelandClaude Sonnet 4.6 2026-03-18 15:03:19 +01:00