From 0c0eaf0bd1be03266577774ebfa281559175da3d Mon Sep 17 00:00:00 2001 From: Alicia FLOREZ Date: Thu, 11 Apr 2013 12:15:44 +0200 Subject: [PATCH] Ajout contrainte des dates de debut et fin --- projet.py | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) diff --git a/projet.py b/projet.py index 8398167..586fbf1 100644 --- 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): -- 1.7.10.4