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>
3.0 KiB
3.0 KiB