projet.structure : rajout d'une FK vers projet.role_mo
[OpenERP/cmmi.git] / projet.py
1 #-*- coding: utf8 -*-
2 '''
3 '''
4
5 from openerp.osv import osv, fields
6 from gtk import TRUE
7
8 class Projet(osv.Model):
9     _name = "projet.projet"
10
11     _columns = {
12         "name": fields.char(string="Title", size=64, required=True),
13         "description": fields.text(string="Description"),
14         "domaines": fields.many2many("projet.domaine",
15                                      "projet_projet_domaine_rel",
16                                      "projets",
17                                      string="Domaines"),
18         "structures": fields.many2many("projet.structure",
19                                        "projet_projet_structure_rel",
20                                        "projets",
21                                        string="Structures"),
22         "team_members": fields.many2many("projet.teammember",
23                                          "projet_projet_teammember_rel",
24                                          "projets",
25                                          string="Team Members"),
26         "modules": fields.one2many("projet.module",
27                                    "projet_id",
28                                    string="Modules"),
29         "chantiers": fields.one2many("projet.chantier",
30                                      "projet_id",
31                                      string="Chantiers"),
32         "paliers": fields.one2many("projet.palier",
33                                    "projet_id",
34                                    string="Paliers"),
35         "phases": fields.one2many("projet.phase",
36                                    "projet_id",
37                                    string="Phases"),
38         "evolutions":fields.one2many("projet.evolution",
39                                      "projet_id",
40                                      string="Evolutions"),
41         "moe_id": fields.many2one("projet.moe", string="MoE", required=True),
42         "moa_id": fields.many2one("projet.moa", string="MoA", required=True),
43     }
44
45
46 class Evolution(osv.Model):
47     _name = "projet.evolution"
48
49     _priorites = [("incontournable", "Incontournable"),
50                   ("necessaire", "Nécéssaire"),
51                   ("utile", "Utile")]
52
53     _statuts = [("cree", "Crée"), ("encours", "En cours"),
54                 ("termine", "Terminé"), ("abandonne", "Abandonné"),
55                 ("suspendu", "Suspendu")]
56
57     _columns = {
58         "pid": fields.integer(string="PID"),
59         "name": fields.char(string="Title", size=64, required=True),
60         "description": fields.text(string="Description"),
61         "objectif": fields.text(string="Objectif"),
62         "commentaire": fields.text(string="Commentaire"),
63         "keywords": fields.text(string="Mots clés"),
64         "priorite": fields.selection(_priorites, string="Priorité"),
65         "statut": fields.selection(_statuts, string="Statut"),
66         "charges": fields.one2many("projet.charge",
67                                    "evolution_id",
68                                    string="Charges"),
69         "module_id": fields.many2one("projet.module",
70                                      string="Modules"),
71         "chantier_id": fields.many2one("projet.chantier",
72                                     string="Chantier"),
73         "palier_id": fields.many2one("projet.palier",
74                                      string="Palier"),
75         "phase_id": fields.many2one("projet.phase",
76                                     string="Phase"),
77         "projet_id": fields.many2one("projet.projet",
78                                      string="Projet"),
79     }
80
81
82 class Structure(osv.Model):
83     _name = "projet.structure"
84
85     _statuts = [("actif", "Actif"), ("inactif", "Inactif")]
86
87     _columns = {
88         "name": fields.char(string="Title", size=64, required=True),
89         "code": fields.char(string="Code", size=8, required=True),
90         "description": fields.text(string="Description"),
91         "parent_id": fields.many2one("projet.structure", string="Parent_id"),
92         "statut": fields.selection(_statuts, string="Statut"),
93         "role_mo_id":fields.many2one("projet.role_mo", string="Role MO"),
94         "projets": fields.many2many("projet.projet",
95                                     "projet_projet_structure_rel",
96                                     "structures",
97                                     string="Projets"),
98     }
99
100
101 class Role_MO(osv.Model):
102     _name = "projet.role_mo"
103
104     _statuts = [("actif", "Actif"), ("inactif", "Inactif")]
105
106
107     _columns = {
108         "name": fields.char(string="Title", size=64, required=True),
109         "code": fields.char(string="Code", size=8, required=True),
110         "description": fields.text(string="Description"),
111         "statut": fields.selection(_statuts, string="Statut"),
112     }
113
114 class Module(osv.Model):
115     _name = "projet.module"
116
117     _columns = {
118         "name": fields.char(string="Title", size=64, required=True),
119         "description": fields.text(string="Description"),
120         "projet_id": fields.many2one("projet.projet",
121                                      string="Projet",
122                                      required=True),
123         "evolutions": fields.one2many("projet.evolution",
124                                       "module_id",
125                                       string="Evolutions")
126     }
127
128
129 class Domaine(osv.Model):
130     _name = "projet.domaine"
131
132     _statuts = [("actif", "Actif"), ("inactif", "Inactif")]
133
134     _columns = {
135         "name": fields.char(string="Title", size=64, required=True),
136         "code": fields.char(string="Code", size=8),
137         "description": fields.text(string="Description"),
138         "ordre": fields.integer(string="Ordre"),
139         "parent_id": fields.many2one("projet.domaine", string="Parent_id"),
140         "statut": fields.selection(_statuts, string="Statut"),
141         "projets": fields.many2many("projet.projet",
142                                     "projet_projet_structure_rel",
143                                     "domaines",
144                                     string="Projets"),
145     }
146
147
148 class Teammember(osv.Model):
149     _name = "projet.teammember"
150
151     _inherit = "res.partner"
152
153     _columns = {
154         "projets": fields.many2many("projet.projet",
155                                     "projet_projet_teammember_rel",
156                                     "team_members",
157                                     string="Projets"),
158         "charges": fields.one2many("projet.projet",
159                                    "team_members",
160                                    string="Charges"),
161     }
162
163
164 class Type_Phase(osv.Model):
165     _name = "projet.type_phase"
166
167     _statuts = [("actif", "Actif"), ("inactif", "Inactif")]
168
169     _columns = {
170         "name": fields.char(string="Title", size=64, required=True),
171         "description": fields.text(string="Description"),
172         "statut": fields.selection(_statuts, string="Statut"),
173     }
174
175
176 class Phase(osv.Model):
177     _name = "projet.phase"
178
179     _statuts = [("actif", "Actif"), ("inactif", "Inactif")]
180
181
182     _columns = {
183         "name": fields.char(string="Title", size=64, required=True),
184         "description": fields.text(string="Description"),
185         "statut": fields.selection(_statuts, string="Statut"),
186         "projet_id": fields.many2one("projet.projet",
187                                      string="Projet",
188                                      required=True),
189         "charges": fields.one2many("projet.charge",
190                                    "phase_id",
191                                    string="Charges"),
192         "evolutions": fields.one2many("projet.evolution",
193                                       "phase_id",
194                                       string="Evolutions"),
195         "palier_id": fields.many2one("projet.palier",
196                                      string="Palier"),
197     }
198
199 #TODO trouver un nom a cette chose
200 class qqch(osv.Model):
201     _name = "projet.qqch"
202
203     _statuts = [("cree", "Crée"), ("encours", "En cours"),
204                 ("termine", "Terminé"), ("abandonne", "Abandonné"),
205                 ("suspendu", "Suspendu"), ("generique", "Générique")]
206
207     _columns = {
208         "name": fields.char(string="Title", size=64, required=True),
209         "description": fields.text(string="Description"),
210         "commentaire": fields.text(string="Commentaire"),
211         "statut": fields.selection(_statuts, string="Statut"),
212         "version": fields.char(string="Version", size=16),
213         "date_jalon": fields.date(sring="Jalon"),
214         "date_init_deb": fields.date(sring="Date initiale début"),
215         "date_init_fin": fields.date(sring="Date initiale de fin"),
216         "date_plan_deb": fields.date(string="Date plannifiée début"),
217         "date_plan_fin": fields.date(string="Date plannifiée de fin"),
218         "date_reel_deb": fields.date(string="Data réelle début"),
219         "date_reel_fin": fields.date(string="Data réelle fin"),
220     }
221
222     _sql_constraints = [
223         (
224             "date_init_deb_before_date_init_fin",
225             "CHECK(date_init_deb<> date_init_fin)",
226             "The date_init_deb should be previous date_init_fin",
227         ),
228         (
229             "date_plan_deb_before_date_plan_fin",
230             "CHECK(date_plan_deb <> date_plan_fin)",
231             "The date_plan_deb should be previous date_plan_fin",
232         ),
233         (
234             "date_reel_deb_before_date_reel_fin",
235             "CHECK(date_reel_deb<> date_reel_fin)",
236             "The date_reel_deb should be previous date_reel_fin",
237         ),
238     ]
239
240
241 class Chantier(osv.Model):
242     _name = "projet.chantier"
243
244     _inherit = "projet.qqch"
245
246     _columns = {
247         "projet_id": fields.many2one("projet.projet",
248                                      string="Projet",
249                                      required=True),
250         "evolutions": fields.one2many("projet.evolution",
251                                       "chantier_id",
252                                       string="Evolutions"),
253     }
254
255
256 class Palier(osv.Model):
257     _name = "projet.palier"
258
259     _types_palier = [("normal", "Normal"), ("exceptionnel", "Exceptionnel"), ("correctif", "Correctif"), ("autre", "Autre")]
260
261
262     _inherit = "projet.qqch"
263
264     _columns = {
265         "type_palier": fields.selection(_types_palier, string="Type"),
266         "projet_id": fields.many2one("projet.projet",
267                                      string="Projet",
268                                      required=True),
269         "evolutions": fields.one2many("projet.evolution",
270                                       "palier_id",
271                                       string="Evolutions"),
272         "phases": fields.one2many("projet.phase",
273                                   "palier_id",
274                                   string="Phases"),
275     }
276
277
278 class Charge(osv.Model):
279     _name = "projet.charge"
280
281     _columns = {
282         "name": fields.char(string="Title", size=64, required=True),
283         "description": fields.text(string="Description"),
284         "teammember_id": fields.many2one("projet.teammember",
285                                          string="Team Member",
286                                          required=True),
287         "phase_id": fields.many2one("projet.phase",
288                                     string="Phase",
289                                     required=True),
290         "evolution_id": fields.many2one("projet.evolution",
291                                     string="Evolution",
292                                     required=True),
293         "mo_id": fields.many2one("projet.mo",
294                                  string="Mo"),
295     }
296
297 class mo(osv.Model):
298     _name = "projet.mo"
299
300     _choses = [("primaire", "Primaire"),
301                ("secondaire", "Secondaire"),
302                ("generique", "Générique")]
303
304     _columns = {
305         "name": fields.char(string="Title"),
306         "description": fields.text(string="Description"),
307         "chose": fields.selection(_choses, string="Chose", required=True),
308         "charges": fields.one2many("projet.charge",
309                                    "mo_id",
310                                    string="Charges"),
311     }
312
313     _defaults = {
314         "chose": "generique"}
315
316
317 class moe(osv.Model):
318     _name = "projet.moe"
319     _inherit = "projet.mo"
320
321     _columns = {
322         "projets": fields.one2many("projet.projet",
323                                      "moe_id",
324                                      string="Projets"),
325     }
326
327
328 class moa(osv.Model):
329     _name= "projet.moa"
330     _inherit = "projet.mo"
331
332     _columns = {
333         "projets": fields.one2many("projet.projet",
334                                      "moa_id",
335                                      string="Projets"),
336     }