1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| CREATE VIEW v_dossier_complet AS
SELECT d.dos_id, d.dos_titre, d.dos_date_creation,
c.clt_id AS id_client,
c.clt_nom AS nom_client,
cd.cde_total_ht AS montant_commande_hors_taxes
CASE
WHEN telle_condition THEN 'Initialisé'
WHEN telle_autre_condition THEN 'En cours'
WHEN telle_troisième_condition THEN 'Terminé'
WHEN encore_une_autre_condition THEN 'Facturé'
WHEN et_une_derniere_condition THEN 'Payé'
ELSE 'À traiter'
END AS statut
FROM te_dossier_dos d
INNER JOIN te_client_clt c ON c.clt_id = d.dos_id_client
LEFT OUTER JOIN te_commande_cde cd ON cd.cde_id_dossier = d.dos_id
LEFT OUTER JOIN te_facture_fct f ON f.fct_id_commande = cd.cde_id; |
Partager