Files
crm_ecosplay/migrations/Version20260402202554.php
Serreau Jovann 3bda43c72f feat: ajout entities Devis, Advert et Order liees a OrderNumber
Relations:
- Devis → OrderNumber (OneToOne): chaque devis a un numero unique
- Devis → Advert (OneToMany): un devis peut generer plusieurs factures pro forma
- Advert → OrderNumber (OneToOne): chaque facture pro forma a un numero unique
- Advert → Devis (ManyToOne, nullable): un advert peut exister sans devis
- Advert → Order (OneToMany): un advert peut generer plusieurs factures
- Order → OrderNumber (OneToOne): chaque facture a un numero unique
- Order → Advert (ManyToOne, nullable): une facture peut exister sans advert

Chaine: Devis → Advert → Order
Si un advert genere plusieurs factures, le champ splitIndex (smallint)
ajoute un suffixe -X au numero (ex: 04/2026-00001-1, 04/2026-00001-2).
La methode getInvoiceNumber() retourne le numero complet avec suffixe.

src/Entity/Devis.php: id, orderNumber (OneToOne), createdAt, adverts (OneToMany)
src/Entity/Advert.php: id, orderNumber (OneToOne), devis (ManyToOne nullable),
  createdAt, orders (OneToMany)
src/Entity/Order.php: id, orderNumber (OneToOne), advert (ManyToOne nullable),
  splitIndex (smallint default 0), createdAt, getInvoiceNumber()
  Table nommee `order` (mot reserve SQL, echappee avec backticks)

src/Repository/DevisRepository.php, AdvertRepository.php, OrderRepository.php

migrations/Version20260402202554.php: tables devis, advert, `order` avec
  foreign keys vers order_number et relations entre elles

Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>
2026-04-02 22:26:15 +02:00

3.0 KiB