Ajout contrainte des dates de debut et fin

diff --git a/projet.py b/projet.py
index 8398167..586fbf1 100644 (file)
--- a/projet.py
+++ b/projet.py
@@ -112,6 +112,9 @@ class Phase(osv.Model):
         "projet_id": fields.many2one("projet.projet",
                                      string="Projet",
                                      required=True),
+        "charges": fields.one2many("projet.charge",
+                                   "phase_id",
+                                   string="Charges")
     }
 
 #TODO trouver un nom a cette chose
@@ -130,6 +133,24 @@ class qqch(osv.Model):
         "date_reel_fin": fields.date(string="Data réelle fin"),
     }
 
+    _sql_constraints = [
+        (
+            "date_init_deb_before_date_init_fin",
+            "CHECK(date_init_deb<> date_init_fin)",
+            "The date_init_deb should be previous date_init_fin",
+        ),
+        (
+            "date_plan_deb_before_date_plan_fin",
+            "CHECK(date_plan_deb<> date_plan_fin)",
+            "The date_plan_deb should be previous date_plan_fin",
+        ),
+        (
+            "date_reel_deb_before_date_reel_fin",
+            "CHECK(date_reel_deb<> date_reel_fin)",
+            "The date_reel_deb should be previous date_reel_fin",
+        ),
+    ]
+
 
 class Chantier(osv.Model):
     _name = "projet.chantier"
@@ -164,6 +185,9 @@ class Charge(osv.Model):
         "teammember_id": fields.many2one("projet.teammember",
                                          string="Team Member",
                                          required=True),
+        "phase_id": fields.many2one("projet.phase",
+                                    string="Phase",
+                                    required=True),
     }
 
 class mo(osv.Model):