feat(stock): seed ingredients + recettes des 53 produits (P4) #67

Merged

Corentin merged 1 commit from feat/p4-seed-recettes into dev

2026-06-19 19:41:00 +02:00

Corentin commented

2026-06-19 19:39:10 +02:00

Owner

No description provided.

Corentin added 1 commit 2026-06-19 19:39:11 +02:00

feat(stock): seed ingredients + recettes des 53 produits (P4)

CI / secret-scan (pull_request) Successful in 9s

Details

CI / php-lint (pull_request) Successful in 21s

Details

CI / php-lint (push) Successful in 20s

Details

CI / static-tests (push) Successful in 43s

Details

CI / js-tests (push) Successful in 24s

Details

CI / static-tests (pull_request) Successful in 48s

Details

CI / js-tests (pull_request) Successful in 24s

Details

CI / secret-scan (push) Successful in 8s

Details

3c836a3ff6

Active le decrement de stock au paiement (RG-T20) et la disponibilite calculee
(RG-T21), jusqu'ici dormants faute de recettes.

- db/seeds/0003_ingredients_recipes.sql : catalogue de 50 ingredients (stock plein)
  + une recette product_ingredient pour chacun des 53 produits. FK resolus par
  sous-requete sur le nom (convention seed 0002) ; INSERT IGNORE -> idempotent.
- Quantites : burger/wrap/salade/encas normal==maxi (Maxi n'ajoute pas de garniture) ;
  frites/boissons maxi>=normal. is_removable sur les garnitures ; is_addable +
  extra_price_cents sur supplements realistes (bacon, cheddar).
- Lignes quantity_normal=0 (extras hors base proposes par la redaction) ecartees :
  contrainte CHECK quantity_normal>0.

Recettes redigees par categorie (workflow multi-agents) contraintes au catalogue
ferme : 53/53 produits couverts, 169 lignes, 0 ingredient hors catalogue. Applique
et verifie sur la base dev (composition Big Mac coherente).

Corentin scheduled this pull request to auto merge when all checks succeed 2026-06-19 19:39:12 +02:00