On 25/03/11 11:47 +0100, pascal obstetar wrote:
> voici le code de la classe :
>
> class Rens(ModelSQL, ModelView):
> 'Rens'
> _name = 'rapports.rens'
> _description = __doc__
>
> dispositif = fields.Many2One('dispositif.dispositif', 'Dispositif',
> select=1)
> nom = fields.Char('Nom', select=1)
> numero = fields.Integer('Numéro', select=1)
> cycle = fields.Integer('Cycle', select=1)
> date_installation = fields.Date('Date', select=2)
> ifn = fields.Char('IFN', select=2)
> commune = fields.Char('Commune', select=2)
> parcelle = fields.Char('Parcelle', select=2)
> surf_foret = fields.Float('Surface forêt', digits=(16,2), select=2)
> surf_parcelle = fields.Float('Surface parcelle', digits=(16,2),
> select=2)
> observation = fields.Text('Observation', select=2)
> operateurs = fields.Char('Opérateurs', select=2)
> proprion = fields.Char('Propriétaire', select=2)
> proprioa1 = fields.Char('Adresse 1', select=2)
> proprioa2 = fields.Char('Adresse 2', select=2)
> proprioci = fields.Char('Ville', select=2)
> proprioz = fields.Char('Code postal', select=2)
> proprioco = fields.Char('Pays', select=2)
> gestion = fields.Char('Gestionnaire', select=2)
> gestioa1 = fields.Char('Adresse 1', select=2)
> gestioa2 = fields.Char('Adresse 2', select=2)
> gestioci = fields.Char('Ville', select=2)
> gestioz = fields.Char('Code postal', select=2)
> gestioco = fields.Char('Pays', select=2)
> image = fields.Char('Image', select=2)
>
> def table_query(self, context=None):
> if context is None:
> context = {}
> return ('SELECT DISTINCT cycle_cycle.id AS id, ' \
> 'MAX(dispositif_dispositif.create_uid) AS create_uid, '
> \
> 'MAX(dispositif_dispositif.create_date) AS create_date,
> ' \
> 'MAX(dispositif_dispositif.write_uid) AS write_uid, ' \
> 'MAX(dispositif_dispositif.write_date) AS write_date, '
> \
> 'dis_num AS dispositif, ' \
> 'dispositif_dispositif.name AS nom, ' \
> 'dis_num AS numero, ' \
> 'cyc_cycle AS cycle, ' \
> 'dis_date_instal AS date_installation, ' \
> 'sta_nom_regifn AS ifn, ' \
> 'country_subdivision.name AS commune, ' \
> 'dis_parcelle AS parcelle, ' \
> 'dis_surface_foret AS surf_foret, ' \
> 'dis_surf AS surf_parcelle, ' \
> 'dis_observation AS observation, ' \
> 'cyc_operateurs AS operateurs, ' \
> 'adm(2,dis_num, \'nom\' ) AS proprion, ' \
> 'adm(2,dis_num, \'adresse1\' ) AS proprioa1, ' \
> 'adm(2,dis_num, \'adresse2\' ) AS proprioa2, ' \
> 'adm(2,dis_num, \'city\' ) AS proprioci, ' \
> 'adm(2,dis_num, \'zip\' ) AS proprioz, ' \
> 'adm(2,dis_num, \'country\' ) AS proprioco, ' \
> 'adm(1,dis_num, \'nom\' ) AS gestion, ' \
> 'adm(1,dis_num, \'adresse1\' ) AS gestioa1, ' \
> 'adm(1,dis_num, \'adresse2\' ) AS gestioa2, ' \
> 'adm(1,dis_num, \'city\' ) AS gestioci, ' \
> 'adm(1,dis_num, \'zip\' ) AS gestioz, ' \
> 'adm(1,dis_num, \'country\' ) AS gestioco, ' \
> 'to_char(dis_num, \'0000".jpg"\' ) AS image ' \
> 'FROM dispositif_dispositif, cycle_cycle,
> country_subdivision, station_station ' \
> 'WHERE cyc_dispositif=dis_num AND
> country_subdivision.id=dis_country
> AND sta_dispositif=dis_num ' \
> 'GROUP BY cycle_cycle.id, dispositif_dispositif.name,
> dis_num, cyc_cycle, dispositif_dispositif.name, dis_date_instal,
> sta_nom_regifn, ' \
> 'country_subdivision.name, dis_parcelle,
> dis_surface_foret, dis_surf, dis_observation, cyc_operateurs ',[])
>
> Rens()
>
> et je mets dans le frame :
>
> image: fiche.image
>
> "fiche" étant l'item de boucle d'attribut du résultat dans le .odt (for each
> fiche in fiches).Il faut passer un object Python (file ou StringIO) avec le contenu de l'image. -- Cédric Krier B2CK SPRL Rue de Rotterdam, 4 4000 Liège Belgium Tel: +32 472 54 46 59 Email/Jabber: [email protected] Website: http://www.b2ck.com/
pgpVXfzm1inlr.pgp
Description: PGP signature
