je voudrais utiliser sfDoctrinePager pour lister l'ensemble de mes
materiels avec leurs proprietaires et leurs responsables.
voici mon fichier schema.yml
Commission:
connection: doctrine
tableName: commission
columns:
code_commission:
type: string(4)
fixed: false
unsigned: false
primary: true
autoincrement: false
nom_commission:
type: string(30)
fixed: false
unsigned: false
primary: false
notnull: true
autoincrement: false
relations:
Responsable:
local: code_commission
foreign: commission_code_commission
type: many
Materiel:
connection: doctrine
tableName: materiel
columns:
id_materiel:
type: integer(4)
fixed: false
unsigned: false
primary: true
autoincrement: true
numero:
type: string(30)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
type:
type: string(20)
fixed: false
unsigned: false
primary: false
notnull: true
autoincrement: false
etat_materiel: { type: boolean, notnull: true, default: 0 }
description:
type: string()
fixed: false
unsigned: false
primary: false
notnull: true
autoincrement: false
proprietaire_id_proprietaire:
type: integer(4)
fixed: false
unsigned: false
primary: false
notnull: true
autoincrement: false
relations:
Proprietaire:
local: proprietaire_id_proprietaire
foreign: id_proprietaire
type: one
Responsable:
local: id_materiel
foreign: materiel_id_materiel
type: many
Proprietaire:
connection: doctrine
tableName: proprietaire
columns:
id_proprietaire:
type: integer(4)
fixed: false
unsigned: false
primary: true
autoincrement: true
nom_proprietaire:
type: string(40)
fixed: false
unsigned: false
primary: false
notnull: true
autoincrement: false
tel:
type: integer(4)
fixed: false
unsigned: false
primary: false
notnull: true
autoincrement: false
email:
type: string(45)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
relations:
Materiel:
local: id_proprietaire
foreign: proprietaire_id_proprietaire
type: many
Responsable:
connection: doctrine
tableName: responsable
columns:
id_responsable:
type: integer(4)
fixed: false
unsigned: false
primary: true
autoincrement: true
nom_responsable:
type: string(15)
fixed: false
unsigned: false
primary: false
notnull: true
autoincrement: false
prenom_responsable:
type: string(20)
fixed: false
unsigned: false
primary: false
notnull: true
autoincrement: false
telephone:
type: integer(4)
fixed: false
unsigned: false
primary: false
notnull: true
autoincrement: false
email:
type: string(45)
fixed: false
unsigned: false
primary: false
notnull: false
autoincrement: false
commission_code_commission:
type: string(4)
fixed: false
unsigned: false
primary: false
notnull: true
autoincrement: false
materiel_id_materiel:
type: integer(4)
fixed: false
unsigned: false
primary: false
notnull: true
autoincrement: false
relations:
Materiel:
local: materiel_id_materiel
foreign: id_materiel
type: one
Commission:
local: commission_code_commission
foreign: code_commission
type: one
aider moi svp. Merci d'avance.
--
Vous recevez ce message, car vous êtes abonné au groupe Google
Groupes Symfony-fr.
Pour envoyer un message à ce groupe, adressez un e-mail
à [email protected].
Pour vous désabonner de ce groupe, envoyez un e-mail à l'adresse
[email protected].
Pour plus d'options, consultez la page de ce groupe :
http://groups.google.com/group/symfony-fr?hl=fr
