[Edevsagetools-commit] SF.net SVN: edevsagetools: [23] trunk/synchro/webapp/src/main/resources

[<av...@us...>]

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 &gt; 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.