Thread: [Edevsagetools-commit] SF.net SVN: edevsagetools: [23] trunk/synchro/webapp/src/main/resources
Status: Beta
Brought to you by:
avdyk
Menu
▾
▴
edevsagetools-commit
|
From: <av...@us...> - 2007-02-20 09:48:16
|
Revision: 23
http://svn.sourceforge.net/edevsagetools/?rev=23&view=rev
Author: avdyk
Date: 2007-02-20 01:48:10 -0800 (Tue, 20 Feb 2007)
Log Message:
-----------
moved the resources
Added Paths:
-----------
trunk/synchro/webapp/src/main/resources/be/
trunk/synchro/webapp/src/main/resources/be/edev/
trunk/synchro/webapp/src/main/resources/be/edev/sagetools/
trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/
trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Annee.hbm.xml
trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/AnneeDebutConsommation.hbm.xml
trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/AnneeFinConsommation.hbm.xml
trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Appellation.hbm.xml
trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Article.hbm.xml
trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/ArticleGlossaire.hbm.xml
trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/CategoriePrix.hbm.xml
trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Cepage.hbm.xml
trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/CepageArticle.hbm.xml
trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Condition.hbm.xml
trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Couleur.hbm.xml
trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Domaine.hbm.xml
trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Famille.hbm.xml
trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Glossaire.hbm.xml
trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Inscription.hbm.xml
trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Litrage.hbm.xml
trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Pays.hbm.xml
trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Promo.hbm.xml
trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Region.hbm.xml
trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/TypeVin.hbm.xml
Added: trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Annee.hbm.xml
===================================================================
--- trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Annee.hbm.xml (rev 0)
+++ trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Annee.hbm.xml 2007-02-20 09:48:10 UTC (rev 23)
@@ -0,0 +1,23 @@
+<?xml version="1.0"?>
+<!DOCTYPE hibernate-mapping PUBLIC
+ "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
+ "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
+<hibernate-mapping
+ package="be.edev.toby.beans">
+
+ <class name="Annee" table="annees" lazy="false">
+ <id name="id" column="ann_id">
+ <generator class="native"/>
+ </id>
+ <property name="annee" column="annee" type="string"/>
+ </class>
+
+ <query name="toby.annee.toutes">
+ from be.edev.toby.beans.Annee as annees order by annees.annee
+ </query>
+
+ <query name="toby.annee.annee">
+ from be.edev.toby.beans.Annee as annee where annee.annee like ?
+ </query>
+
+</hibernate-mapping>
Added: trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/AnneeDebutConsommation.hbm.xml
===================================================================
--- trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/AnneeDebutConsommation.hbm.xml (rev 0)
+++ trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/AnneeDebutConsommation.hbm.xml 2007-02-20 09:48:10 UTC (rev 23)
@@ -0,0 +1,23 @@
+<?xml version="1.0"?>
+<!DOCTYPE hibernate-mapping PUBLIC
+ "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
+ "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
+<hibernate-mapping
+ package="be.edev.toby.beans">
+
+ <class name="AnneeDebutConsommation" table="anneesdebutconsommation" lazy="false">
+ <id name="id" column="ann_id">
+ <generator class="native"/>
+ </id>
+ <property name="annee" column="annee" type="string"/>
+ </class>
+
+ <query name="toby.annee.consommation.debut.toutes">
+ from be.edev.toby.beans.AnneeDebutConsommation as annees order by annees.annee
+ </query>
+
+ <query name="toby.annee.consommation.debut.annee">
+ from be.edev.toby.beans.AnneeDebutConsommation as annee where annee.annee like ?
+ </query>
+
+</hibernate-mapping>
Added: trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/AnneeFinConsommation.hbm.xml
===================================================================
--- trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/AnneeFinConsommation.hbm.xml (rev 0)
+++ trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/AnneeFinConsommation.hbm.xml 2007-02-20 09:48:10 UTC (rev 23)
@@ -0,0 +1,23 @@
+<?xml version="1.0"?>
+<!DOCTYPE hibernate-mapping PUBLIC
+ "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
+ "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
+<hibernate-mapping
+ package="be.edev.toby.beans">
+
+ <class name="AnneeFinConsommation" table="anneesfinconsommation" lazy="false">
+ <id name="id" column="ann_id">
+ <generator class="native"/>
+ </id>
+ <property name="annee" column="annee" type="string"/>
+ </class>
+
+ <query name="toby.annee.consommation.fin.toutes">
+ from be.edev.toby.beans.AnneeFinConsommation as annees order by annees.annee
+ </query>
+
+ <query name="toby.annee.consommation.fin.annee">
+ from be.edev.toby.beans.AnneeFinConsommation as annee where annee.annee like ?
+ </query>
+
+</hibernate-mapping>
Added: trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Appellation.hbm.xml
===================================================================
--- trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Appellation.hbm.xml (rev 0)
+++ trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Appellation.hbm.xml 2007-02-20 09:48:10 UTC (rev 23)
@@ -0,0 +1,42 @@
+<?xml version="1.0"?>
+<!DOCTYPE hibernate-mapping PUBLIC
+ "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
+ "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
+<hibernate-mapping
+ package="be.edev.toby.beans">
+
+ <class name="Appellation" table="appellations" lazy="false">
+ <id name="id" column="app_id">
+ <generator class="native"/>
+ </id>
+ <property name="appellation" column="app_libelle" type="string" />
+ <property name="photo" column="app_photo" type="string" />
+ <set name="region"
+ table="regionsappellations">
+ <key column="rap_fk_appellation"/>
+ <many-to-many column="rap_fk_region"
+ class="Region"/>
+ </set>
+ <set name="domaine"
+ table="appellationsdomaines"
+ inverse="true">
+ <key column="ado_fk_appellation"/>
+ <many-to-many column="ado_fk_domaine"
+ class="Domaine"/>
+ </set>
+ </class>
+
+ <query name="toby.appellation.toutes">
+ from be.edev.toby.beans.Appellation as appellations order by appellations.appellation
+ </query>
+
+ <query name="toby.appellation.nom">
+ from be.edev.toby.beans.Appellation as appellations
+ where appellations.appellation like ?
+ </query>
+
+ <query name="toby.appellation.rechercheParNom">
+ from be.edev.toby.beans.Appellation as a where a.appellation like :q
+ </query>
+
+</hibernate-mapping>
Added: trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Article.hbm.xml
===================================================================
--- trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Article.hbm.xml (rev 0)
+++ trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Article.hbm.xml 2007-02-20 09:48:10 UTC (rev 23)
@@ -0,0 +1,65 @@
+<?xml version="1.0"?>
+<!DOCTYPE hibernate-mapping PUBLIC
+ "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
+ "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
+<hibernate-mapping
+ package="be.edev.toby.beans">
+
+ <class name="Article" table="articles" lazy="false">
+ <id name="id" column="art_id">
+ <generator class="native"/>
+ </id>
+ <property name="reference" column="art_reference" type="string" />
+ <property name="langue1" column="art_langue1" type="string" />
+ <property name="langue2" column="art_langue2" type="string" />
+ <property name="designation" column="art_designation" type="string" />
+ <property name="cbDateModif" column="cbmodification" type="date" />
+ <property name="litrage" column="art_litrage" type="integer" />
+ <many-to-one name="annee" class="Annee" column="art_fk_annee" not-null="false" not-found="ignore"/>
+ <many-to-one name="anneeDebutConsommation" class="AnneeDebutConsommation" column="art_fk_anneesdebutconsommation" not-null="false" not-found="ignore"/>
+ <many-to-one name="anneeFinConsommation" class="AnneeFinConsommation" column="art_fk_anneesfinconsommation" not-null="false" not-found="ignore"/>
+ <property name="degreAlcool" column="art_degrealcool" type="float" />
+ <many-to-one name="typeVin" class="TypeVin" column="art_fk_typevin" not-null="false" not-found="ignore"/>
+ <many-to-one name="categoriePrix" class="CategoriePrix" column="art_fk_catprix" not-null="false" not-found="ignore"/>
+ <many-to-one name="couleur" class="Couleur" column="art_fk_couleur" not-null="false" not-found="ignore"/>
+ <many-to-one name="domaine" class="Domaine" column="art_fk_domaine" not-null="false" not-found="ignore"/>
+ <many-to-one name="appellation" class="Appellation" column="art_fk_appellation" not-null="false" not-found="ignore"/>
+ <many-to-one name="region" class="Region" column="art_fk_region" not-null="false" not-found="ignore"/>
+ <many-to-one name="pays" class="Pays" column="art_fk_pays" not-null="false" not-found="ignore"/>
+ <many-to-one name="famille" class="Famille" column="art_fk_famille" not-null="false" not-found="ignore"/>
+ <many-to-one name="condition" class="Condition" column="art_fk_condition" not-null="false" not-found="ignore"/>
+ <property name="ecoTaxe" column="art_eco_taxe" type="float"/>
+ <property name="photo" column="art_photo" type="string" />
+ <property name="photoGrande" column="art_photo_grande" type="string"/>
+ <property name="dateCreation" column="art_datecreation" type="date"/>
+ <property name="dateModification" column="art_datemodif" type="date"/>
+ <property name="poidsBrut" column="art_poidsbrut" type="float"/>
+ <property name="poidsNet" column="art_poidsnet" type="float"/>
+ <property name="prixVente" column="art_prixven" type="float"/>
+ <property name="publie" column="art_publie" type="integer"/>
+ <property name="puNet" column="art_punet" type="float"/>
+ <set name="glossaire"
+ table="articlesglossaires" lazy="false">
+ <key column="ar_ref"/>
+ <many-to-many column="gl_no"
+ class="Glossaire"/>
+ </set>
+ </class>
+
+ <query name="toby.article.tous">
+ from be.edev.toby.beans.Article as articles order by articles.langue1
+ </query>
+
+ <query name="toby.article.reference">
+ from be.edev.toby.beans.Article as articles where articles.reference like ?
+ </query>
+
+ <query name="toby.article.rechercheParNom">
+ from be.edev.toby.beans.Article as a where a.designation like :q
+ </query>
+
+ <query name="toby.article.pas.publie">
+ from be.edev.toby.beans.Article as a where a.publie=0
+ </query>
+
+</hibernate-mapping>
Added: trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/ArticleGlossaire.hbm.xml
===================================================================
--- trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/ArticleGlossaire.hbm.xml (rev 0)
+++ trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/ArticleGlossaire.hbm.xml 2007-02-20 09:48:10 UTC (rev 23)
@@ -0,0 +1,26 @@
+<?xml version="1.0"?>
+<!DOCTYPE hibernate-mapping PUBLIC
+ "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
+ "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
+<hibernate-mapping
+ package="be.edev.toby.beans">
+
+ <class name="ArticleGlossaire" table="articlesglossaires" lazy="false">
+ <id name="id" column="agl_id">
+ <generator class="native"/>
+ </id>
+ <property name="num" column="agl_num" type="int" />
+ <property name="articleId" column="ar_ref" type="int" />
+ <property name="glossaireId" column="gl_no" type="int" />
+ <property name="dateModif" column="cbmodification"
+ type="date" not-null="false" />
+ </class>
+
+ <query name="toby.articleglossaire.parIds">
+ from be.edev.toby.beans.ArticleGlossaire as ag
+ where ag.articleId = :articleId
+ and ag.glossaireId = :glossaireId
+ </query>
+
+
+</hibernate-mapping>
Added: trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/CategoriePrix.hbm.xml
===================================================================
--- trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/CategoriePrix.hbm.xml (rev 0)
+++ trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/CategoriePrix.hbm.xml 2007-02-20 09:48:10 UTC (rev 23)
@@ -0,0 +1,23 @@
+<?xml version="1.0"?>
+<!DOCTYPE hibernate-mapping PUBLIC
+ "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
+ "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
+<hibernate-mapping
+ package="be.edev.toby.beans">
+
+ <class name="CategoriePrix" table="categoriesprix" lazy="false">
+ <id name="id" column="cp_id">
+ <generator class="native"/>
+ </id>
+ <property name="categoriePrix" column="cp_libelle" type="string" />
+ </class>
+
+ <query name="toby.categorieprix.toutes">
+ from be.edev.toby.beans.CategoriePrix as cp order by cp.categoriePrix
+ </query>
+
+ <query name="toby.categorieprix.categorieprix">
+ from be.edev.toby.beans.CategoriePrix as cp where cp.categoriePrix like ?
+ </query>
+
+</hibernate-mapping>
Added: trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Cepage.hbm.xml
===================================================================
--- trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Cepage.hbm.xml (rev 0)
+++ trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Cepage.hbm.xml 2007-02-20 09:48:10 UTC (rev 23)
@@ -0,0 +1,33 @@
+<?xml version="1.0"?>
+<!DOCTYPE hibernate-mapping PUBLIC
+ "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
+ "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
+<hibernate-mapping
+ package="be.edev.toby.beans">
+
+ <class name="Cepage" table="cepages" lazy="false">
+ <id name="id" column="cep_id">
+ <generator class="assigned"/>
+ </id>
+ <property name="cepage" column="cep_nom" type="string" />
+ <!--
+ <set name="article"
+ table="cepagesarticles">
+ <key column="car_fk_cepage"/>
+ <many-to-many column="car_fk_article"
+ class="Article"/>
+ </set>
+ -->
+ <property name="dateModif" column="cbmodification"
+ type="date" not-null="false" />
+ </class>
+
+ <query name="toby.cepage.tous">
+ from be.edev.toby.beans.Cepage as c order by c.cepage
+ </query>
+
+ <query name="toby.cepage.rechercheParNom">
+ from be.edev.toby.beans.Cepage as c where c.cepage like :q
+ </query>
+
+</hibernate-mapping>
Added: trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/CepageArticle.hbm.xml
===================================================================
--- trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/CepageArticle.hbm.xml (rev 0)
+++ trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/CepageArticle.hbm.xml 2007-02-20 09:48:10 UTC (rev 23)
@@ -0,0 +1,28 @@
+<?xml version="1.0"?>
+<!DOCTYPE hibernate-mapping PUBLIC
+ "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
+ "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
+<hibernate-mapping
+ package="be.edev.toby.beans">
+
+ <class name="Famille" table="familles" lazy="false">
+ <id name="id" column="fam_id">
+ <generator class="native"/>
+ </id>
+ <property name="central" column="fam_central" type="string" not-null="false" />
+ <property name="codeFamille" column="fam_codefamille" type="string" />
+ <property name="intitule" column="fam_intitule" type="string" not-null="false" />
+ <property name="codeFiscal" column="fam_codefiscal" type="float" not-null="false" />
+ <property name="publie" column="fam_publie" type="integer" not-null="false" />
+ <property name="dateModif" column="cbmodification" type="date" not-null="false" />
+ </class>
+
+ <query name="toby.famille.toutes">
+ from be.edev.toby.beans.Famille as f
+ </query>
+
+ <query name="toby.famille.codefamille">
+ from be.edev.toby.beans.Famille as f where f.codeFamille like ?
+ </query>
+
+</hibernate-mapping>
Added: trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Condition.hbm.xml
===================================================================
--- trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Condition.hbm.xml (rev 0)
+++ trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Condition.hbm.xml 2007-02-20 09:48:10 UTC (rev 23)
@@ -0,0 +1,27 @@
+<?xml version="1.0"?>
+<!DOCTYPE hibernate-mapping PUBLIC
+ "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
+ "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
+<hibernate-mapping
+ package="be.edev.toby.beans">
+
+ <class name="Condition" table="conditions" lazy="false">
+ <id name="id" column="con_id">
+ <!-- generator class="assigned"/-->
+ <generator class="identity"/>
+ </id>
+ <property name="enumere" column="con_enumere" type="string" />
+ <property name="quantite" column="con_quantite" type="float" />
+ <property name="champ" column="con_champ" type="string" />
+ <property name="dateModif" column="cbmodification" type="date" />
+ </class>
+
+ <query name="toby.condition.toutes">
+ from be.edev.toby.beans.Condition as c
+ </query>
+
+ <query name="toby.condition.quantite">
+ from be.edev.toby.beans.Condition as c where c.quantite = ?
+ </query>
+
+</hibernate-mapping>
Added: trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Couleur.hbm.xml
===================================================================
--- trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Couleur.hbm.xml (rev 0)
+++ trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Couleur.hbm.xml 2007-02-20 09:48:10 UTC (rev 23)
@@ -0,0 +1,24 @@
+<?xml version="1.0"?>
+<!DOCTYPE hibernate-mapping PUBLIC
+ "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
+ "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
+<hibernate-mapping
+ package="be.edev.toby.beans">
+
+ <class name="Couleur" table="couleurs" lazy="false">
+ <id name="id" column="co_id">
+ <generator class="native"/>
+ </id>
+ <property name="couleur" column="co_libelle" type="string" />
+ <property name="photo" column="co_photo" type="string" />
+ </class>
+
+ <query name="toby.couleur.toutes">
+ from be.edev.toby.beans.Couleur as couleurs order by couleurs.couleur
+ </query>
+
+ <query name="toby.couleur.couleur">
+ from be.edev.toby.beans.Couleur as c where c.couleur like ?
+ </query>
+
+</hibernate-mapping>
Added: trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Domaine.hbm.xml
===================================================================
--- trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Domaine.hbm.xml (rev 0)
+++ trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Domaine.hbm.xml 2007-02-20 09:48:10 UTC (rev 23)
@@ -0,0 +1,51 @@
+<?xml version="1.0"?>
+<!DOCTYPE hibernate-mapping PUBLIC
+ "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
+ "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
+<hibernate-mapping
+ package="be.edev.toby.beans">
+
+ <class name="Domaine" table="domaines" lazy="false">
+ <id name="id" column="dom_id">
+ <generator class="native"/>
+ </id>
+ <property name="domaine" column="dom_libelle" type="string" />
+ <property name="photo" column="dom_photo" type="string" />
+ <property name="photoGrande" column="dom_photo_grande" type="string" />
+ <set name="appellation"
+ table="appellationsdomaines">
+ <key column="ado_fk_domaine"/>
+ <many-to-many column="ado_fk_appellation"
+ class="Appellation"/>
+ </set>
+ <set name="article"
+ inverse="true">
+ <key column="art_fk_domaine"/>
+ <one-to-many class="Article"/>
+ </set>
+ </class>
+
+ <query name="toby.domaine.tous">
+ from be.edev.toby.beans.Domaine as domaines order by domaines.domaine
+ </query>
+
+ <query name="toby.domaine.nom">
+ from be.edev.toby.beans.Domaine as domaines where domaines.domaine like ?
+ </query>
+
+ <query name="toby.domaine.rechercheParNom">
+ from be.edev.toby.beans.Domaine as d where d.domaine like :q
+ </query>
+
+ <query name="toby.domaine.pasImage">
+ from be.edev.toby.beans.Domaine as p where p.photo is null or p.photo
+ like 'NULL' or p.photoGrande is null or p.photoGrande like 'NULL'
+ </query>
+
+ <query name="toby.domaine.pasImage.nombre">
+ select count(p.id) from be.edev.toby.beans.Domaine as p where p.photo
+ is null or p.photo like 'NULL' or p.photoGrande is null or
+ p.photoGrande like 'NULL'
+ </query>
+
+</hibernate-mapping>
Added: trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Famille.hbm.xml
===================================================================
--- trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Famille.hbm.xml (rev 0)
+++ trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Famille.hbm.xml 2007-02-20 09:48:10 UTC (rev 23)
@@ -0,0 +1,28 @@
+<?xml version="1.0"?>
+<!DOCTYPE hibernate-mapping PUBLIC
+ "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
+ "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
+<hibernate-mapping
+ package="be.edev.toby.beans">
+
+ <class name="Famille" table="familles" lazy="false">
+ <id name="id" column="fam_id">
+ <generator class="native"/>
+ </id>
+ <property name="central" column="fam_central" type="string" not-null="false" />
+ <property name="codeFamille" column="fam_codefamille" type="string" />
+ <property name="intitule" column="fam_intitule" type="string" not-null="false" />
+ <property name="codeFiscal" column="fam_codefiscal" type="float" not-null="false" />
+ <property name="publie" column="fam_publie" type="integer" not-null="false" />
+ <property name="dateModif" column="cbmodification" type="date" not-null="false" />
+ </class>
+
+ <query name="toby.famille.toutes">
+ from be.edev.toby.beans.Famille as f
+ </query>
+
+ <query name="toby.famille.codefamille">
+ from be.edev.toby.beans.Famille as f where f.codeFamille like ?
+ </query>
+
+</hibernate-mapping>
Added: trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Glossaire.hbm.xml
===================================================================
--- trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Glossaire.hbm.xml (rev 0)
+++ trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Glossaire.hbm.xml 2007-02-20 09:48:10 UTC (rev 23)
@@ -0,0 +1,35 @@
+<?xml version="1.0"?>
+<!DOCTYPE hibernate-mapping PUBLIC
+ "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
+ "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
+<hibernate-mapping
+ package="be.edev.toby.beans">
+
+ <class name="Glossaire" table="glossaires" lazy="false">
+ <id name="id" column="gl_no">
+ <generator class="assigned"/>
+ </id>
+ <property name="dateModif" column="cbmodification"
+ type="date" not-null="false" />
+ <property name="docLigne" column="gl_docligne" type="int" />
+ <property name="intitule" column="gl_intitule" type="string" />
+ <property name="domaine" column="gl_domaine" type="int" />
+ <property name="periodeDebut" column="gl_periodedeb"
+ type="date"/>
+ <property name="periodeFin" column="gl_periodefin"
+ type="date"/>
+ <property name="raccourci" column="gl_raccourci" type="string" />
+ <property name="text" column="gl_text" type="string" />
+ </class>
+
+ <query name="toby.glossaire.tous.cepages">
+ from be.edev.toby.beans.Glossaire as g
+ where g.intitule like 'C/%'
+ order by g.intitule
+ </query>
+
+ <query name="toby.glossaire.rechercheParNom">
+ from be.edev.toby.beans.Glossaire as g where g.intitule like :q
+ </query>
+
+</hibernate-mapping>
Added: trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Inscription.hbm.xml
===================================================================
--- trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Inscription.hbm.xml (rev 0)
+++ trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Inscription.hbm.xml 2007-02-20 09:48:10 UTC (rev 23)
@@ -0,0 +1,29 @@
+<?xml version="1.0"?>
+<!DOCTYPE hibernate-mapping PUBLIC
+ "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
+ "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
+<hibernate-mapping
+ package="be.edev.toby.beans">
+
+ <class name="Inscription" table="inscriptions" lazy="true">
+ <id name="id" column="id">
+ <generator class="native"/>
+ </id>
+ <property name="prenom" column="prenom" type="string"/>
+ <property name="nom" column="nom" type="string"/>
+ <property name="email" column="email" type="string"/>
+ <property name="adresse" column="adresse" type="string"/>
+ <property name="ville" column="ville" type="string"/>
+ <property name="codePostal" column="cp" type="string"/>
+ <property name="telephone" column="telephone" type="string"/>
+ </class>
+
+ <query name="toby.inscription.toutes">
+ from be.edev.toby.beans.Inscription as inscriptions
+ </query>
+
+ <query name="toby.inscription.efface">
+ delete from be.edev.toby.beans.Inscription
+ </query>
+
+</hibernate-mapping>
Added: trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Litrage.hbm.xml
===================================================================
--- trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Litrage.hbm.xml (rev 0)
+++ trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Litrage.hbm.xml 2007-02-20 09:48:10 UTC (rev 23)
@@ -0,0 +1,18 @@
+<?xml version="1.0"?>
+<!DOCTYPE hibernate-mapping PUBLIC
+ "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
+ "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
+<hibernate-mapping
+ package="be.edev.toby.beans">
+
+ <class name="Litrage" table="litrages" lazy="false">
+ <id name="litrage" column="litrage">
+ <generator class="assigned"/>
+ </id>
+ </class>
+
+ <query name="toby.litrages.tous">
+ from be.edev.toby.beans.Litrage as l order by l.litrage
+ </query>
+
+</hibernate-mapping>
Added: trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Pays.hbm.xml
===================================================================
--- trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Pays.hbm.xml (rev 0)
+++ trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Pays.hbm.xml 2007-02-20 09:48:10 UTC (rev 23)
@@ -0,0 +1,44 @@
+<?xml version="1.0"?>
+<!DOCTYPE hibernate-mapping PUBLIC
+ "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
+ "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
+<hibernate-mapping package="be.edev.toby.beans">
+
+ <class name="Pays" table="pays" lazy="false">
+ <id name="id" column="pay_id">
+ <generator class="native" />
+ </id>
+ <property name="pays" column="pay_libelle" type="string"
+ unique="true" />
+ <property name="abrev" column="pay_abrev" type="string"
+ unique="true" />
+ <property name="photo" column="pay_photo" type="string" />
+ <property name="photoGrande" column="pay_photo_grande"
+ type="string" />
+ <set name="regions" inverse="true" order-by="reg_libelle" lazy="true">
+ <key column="reg_fk_pays" />
+ <one-to-many class="Region" />
+ </set>
+
+ </class>
+
+ <query name="toby.pays.tous">
+ from be.edev.toby.beans.Pays as pays order by pays.pays
+ </query>
+
+ <query name="toby.pays.nom">
+ from be.edev.toby.beans.Pays as pays where pays.pays like ?
+ </query>
+
+ <query name="toby.pays.pasImage">
+ from be.edev.toby.beans.Pays as p where p.photo is null or p.photo
+ like 'NULL' or p.photoGrande is null or p.photoGrande like 'NULL'
+ </query>
+
+ <query name="toby.pays.pasImage.nombre">
+ select count(p.id) from be.edev.toby.beans.Pays as p where p.photo
+ is null or p.photo like 'NULL' or p.photoGrande is null or
+ p.photoGrande like 'NULL'
+ </query>
+
+</hibernate-mapping>
Added: trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Promo.hbm.xml
===================================================================
--- trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Promo.hbm.xml (rev 0)
+++ trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Promo.hbm.xml 2007-02-20 09:48:10 UTC (rev 23)
@@ -0,0 +1,35 @@
+<?xml version="1.0"?>
+<!DOCTYPE hibernate-mapping PUBLIC
+ "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
+ "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
+<hibernate-mapping
+ package="be.edev.toby.beans">
+
+ <class name="Promo" table="promos" lazy="true">
+ <id name="id" column="promo_id">
+ <generator class="native"/>
+ </id>
+ <property name="intitule" column="promo_intitule" type="string"/>
+ <property name="debut" column="promo_debut" type="date"/>
+ <property name="fin" column="promo_fin" type="date"/>
+ <property name="cbmodification" column="cbmodification" type="date"/>
+ <property name="type" column="promo_type" type="double"/>
+ <property name="domaine" column="promo_domaine" type="double"/>
+ <property name="remise01Type" column="promo_remise01Type" type="double" />
+ <property name="remise01Valeur" column="promo_remise01Valeur" type="double" />
+ <property name="remise02Type" column="promo_remise02Type" type="double" />
+ <property name="remise02Valeur" column="promo_remise02Valeur" type="double" />
+ <property name="remise03Type" column="promo_remise03Type" type="double" />
+ <property name="remise03Valeur" column="promo_remise03Valeur" type="double" />
+ <many-to-one name="article" column="promo_fk_article" class="Article" />
+ </class>
+
+ <query name="toby.promo.du.jour">
+ from be.edev.toby.beans.Promo
+ </query>
+
+ <!--
+ as p where p.fin > current_date()
+ -->
+
+</hibernate-mapping>
Added: trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Region.hbm.xml
===================================================================
--- trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Region.hbm.xml (rev 0)
+++ trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/Region.hbm.xml 2007-02-20 09:48:10 UTC (rev 23)
@@ -0,0 +1,55 @@
+<?xml version="1.0"?>
+<!DOCTYPE hibernate-mapping PUBLIC
+ "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
+ "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
+<hibernate-mapping package="be.edev.toby.beans">
+
+ <class name="Region" table="regions" lazy="false">
+ <id name="id" column="reg_id">
+ <generator class="native" />
+ </id>
+ <property name="region" column="reg_libelle" type="string" />
+ <property name="paysPhoto" column="reg_pays_photo" type="string" />
+ <property name="paysPhotoGrande" column="reg_pays_photo_grande"
+ type="string" />
+ <property name="photo" column="reg_photo" type="string" />
+ <property name="photoGrande" column="reg_photo_grande"
+ type="string" />
+ <property name="carte" column="reg_carte" type="string" />
+ <property name="carteGrande" column="reg_carte_grande"
+ type="string" />
+ <property name="vue" column="reg_vue" type="string" />
+ <many-to-one name="pays" column="reg_fk_pays" class="Pays" />
+ <set name="appellation" table="regionsappellations"
+ inverse="true">
+ <key column="rap_fk_region" />
+ <many-to-many column="rap_fk_appellation" class="Appellation" />
+ </set>
+
+ </class>
+
+ <query name="toby.region.toutes">
+ from be.edev.toby.beans.Region as regions order by regions.region
+ </query>
+
+ <query name="toby.region.nom">
+ from be.edev.toby.beans.Region as regions where regions.region like
+ ?
+ </query>
+
+ <query name="toby.region.pasImage">
+ from be.edev.toby.beans.Region as p where p.photo is null or p.photo
+ like 'NULL' or p.photoGrande is null or p.photoGrande like 'NULL' or
+ p.carte is null or p.carte like 'NULL' or p.carteGrande is null or
+ p.carteGrande like 'NULL' or p.vue is null or p.vue like 'NULL'
+ </query>
+
+ <query name="toby.region.pasImage.nombre">
+ select count(p.id) from be.edev.toby.beans.Region as p where p.photo
+ is null or p.photo like 'NULL' or p.photoGrande is null or
+ p.photoGrande like 'NULL' or p.carte is null or p.carte like 'NULL'
+ or p.carteGrande is null or p.carteGrande like 'NULL' or p.vue is
+ null or p.vue like 'NULL'
+ </query>
+
+</hibernate-mapping>
Added: trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/TypeVin.hbm.xml
===================================================================
--- trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/TypeVin.hbm.xml (rev 0)
+++ trunk/synchro/webapp/src/main/resources/be/edev/sagetools/beans/TypeVin.hbm.xml 2007-02-20 09:48:10 UTC (rev 23)
@@ -0,0 +1,24 @@
+<?xml version="1.0"?>
+<!DOCTYPE hibernate-mapping PUBLIC
+ "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
+ "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
+<hibernate-mapping
+ package="be.edev.toby.beans">
+
+ <class name="TypeVin" table="typesvins" lazy="false">
+ <id name="id" column="tv_id">
+ <generator class="native"/>
+ </id>
+ <property name="typeVin" column="tv_libelle" type="string" />
+ <property name="photo" column="tv_photo" type="string" />
+ </class>
+
+ <query name="toby.typevin.tous">
+ from be.edev.toby.beans.TypeVin as tv order by tv.typeVin asc
+ </query>
+
+ <query name="toby.typevin.typevin">
+ from be.edev.toby.beans.TypeVin as tv where tv.typeVin like ?
+ </query>
+
+</hibernate-mapping>
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X