[gnue-contrib] r233 - / address

[johannes]

Author: johannes
Date: 2006-02-24 10:31:50 -0600 (Fri, 24 Feb 2006)
New Revision: 233

Added:
   address/
   address/address.gfd
   address/schema.gsd
   address/stamm.gfd
Log:
Added another sample project


Added: address/address.gfd
===================================================================
--- address/address.gfd 2006-02-20 19:02:28 UTC (rev 232)
+++ address/address.gfd 2006-02-24 16:31:50 UTC (rev 233)
@@ -0,0 +1,166 @@
+<?xml version="1.0" encoding="iso8859-1"?>
+
+<form title="GNUe Application Server test">
+  <options>
+    <author>ByteWise Software GmbH</author>
+    <version>0.0.1</version>
+    <description>Simple address management</description>
+  </options>
+
+  <datasource name="dtsCompany" connection="address" table="company" />
+  <datasource name="dtsCpMemo" connection="address" table="cpmemo" />
+  <datasource name="dtsContact" connection="address" table="contact"
+    master="dtsCompany" masterlink="id" detaillink="company" />
+  <datasource name="dtsCtMemo" connection="address" table="ctmemo" />
+  <datasource name="dtsCategory" connection="address" table="category"
+    prequery="Y" />
+  <datasource name="dtsSalutation" connection="address" table="salutation"
+    prequery="Y" />
+
+  <logic>
+    <block name="blkCompany" datasource="dtsCompany">
+      <field name="eMatchcode" field="matchcode" maxLength="20" case="upper"/>
+      <field name="eName1" field="name1" maxLength="64"  />
+      <field name="eName2" field="name2" maxLength="64"  />
+      <field name="eCountry" field="country" maxLength="4"  />
+      <field name="eStreet" field="street" maxLength="64"  />
+      <field name="eCity" field="city" maxLength="64"  />
+      <field name="eZIP" field="zip" maxLength="10"  />
+      <field name="eVAT" field="vatid" maxLength="18"  />
+      <field name="eCRG" field="compreg" maxLength="32" />
+
+      <field name="ePhone" field="phone" maxLength="50"  />
+      <field name="eFax" field="fax" maxLength="50"  />
+      <field name="eWeb" field="web" maxLength="64" />
+      <field name="eMail" field="email" maxLength="64" />
+      <field name="eCustomer" field="customer" maxLength="20" />
+      <field name="eBWCustomer" field="bwcustomer" maxLength="16" />
+      <field name="eBWSupplier" field="bwsupplier" maxLength="16" />
+      <field name="eShipment" field="shipment" maxLength="64" />
+      <field name="eCategory" field="category" fk_key="id"
+        fk_description="text" fk_source="dtsCategory"/>
+    </block>
+
+    <block name="blkContact" datasource="dtsContact">
+      <field name="eSalutation" field="salutation" fk_key="id"
+        fk_description="text" fk_source="dtsSalutation" />
+      <field name="eTitle" field="title" maxLength="21" />
+      <field name="eFirstname" field="firstname" maxLength="26" />
+      <field name="eSurname" field="surname" maxLength="31" />
+      <field name="eDepartment" field="department" maxLength="32" />
+      <field name="eDuty" field="duty" maxLength="32" />
+      <field name="ePhone1" field="phone1" maxLength="32" />
+      <field name="ePhone2" field="phone2" maxLength="32" />
+      <field name="eFax" field="fax" maxLength="32" />
+      <field name="eMail" field="email" maxLength="64" />
+    </block>
+
+    <block name="unbound" >
+      <field name="companymemo" readonly="Y" />
+      <field name="contactmemo" readonly="Y" />
+    </block>
+
+  </logic>
+
+  <layout xmlns:c="GNUe:Layout:Char" c:height="17" c:width="103" tabbed="none">
+    <page name="pgContact" caption="Contacts">
+      <label c:x="0" c:y="1" c:width="8" text="Match:" alignment="right"/>
+      <label c:x="0" c:y="2" c:width="8" text="Firma 1:" alignment="right"/>
+      <label c:x="0" c:y="3" c:width="8" text="Firma 2:" alignment="right"/>
+      <label c:x="0" c:y="4" c:width="8" text="Strasse:" alignment="right"/>
+      <label c:x="0" c:y="5" c:width="8" text="PLZ:" alignment="right"/>
+      <label c:x="20" c:y="5" c:width="6" text="Stadt:" alignment="right"/>
+      <label c:x="0" c:y="6" c:width="8" text="Land:" alignment="right"/>
+      <label c:x="20" c:y="6" c:width="6" text="UID:" alignment="right"/>
+      <label c:x="20" c:y="7" c:width="6" text="FNr:" alignment="right"/>
+
+      <entry c:x="9" c:y="1" c:width="40" block="blkCompany"
+        field="eMatchcode"/>
+      <entry c:x="9" c:y="2" c:width="40" block="blkCompany"
+        field="eName1"/>
+      <entry c:x="9" c:y="3" c:width="40" block="blkCompany"
+        field="eName2"/>
+      <entry c:x="9" c:y="4" c:width="40" block="blkCompany"
+        field="eStreet"/>
+      <entry c:x="9" c:y="5" c:width="10" block="blkCompany"
+        field="eZIP"/>
+
+      <entry c:x="27" c:y="5" c:width="22" block="blkCompany"
+        field="eCity"/>
+      <entry c:x="9" c:y="6" c:width="10" block="blkCompany"
+        field="eCountry"/>
+      <entry c:x="27" c:y="6" c:width="22" block="blkCompany"
+        field="eVAT"/>
+      <entry c:x="27" c:y="7" c:width="22" block="blkCompany"
+        field="eCRG"/>
+
+      <entry c:x="27" c:y="8" c:width="10" block="unbound" field="companymemo"
+        style="label" />
+      <button c:x="37" c:y="8" c:width="12" label="Memo" />
+
+      <label c:x="50" c:y="1" c:width="12" text="Tel.allg.:" 
alignment="right"/>
+      <label c:x="50" c:y="2" c:width="12" text="Fax allg.:" 
alignment="right"/>
+      <label c:x="50" c:y="3" c:width="12" text="Internet:" alignment="right"/>
+      <label c:x="50" c:y="4" c:width="12" text="eMail:" alignment="right"/>
+      <label c:x="50" c:y="5" c:width="12" text="unsere KdNr:"
+        alignment="right"/>
+      <label c:x="50" c:y="6" c:width="12" text="BW KdNr:" alignment="right"/>
+      <label c:x="50" c:y="7" c:width="12" text="BW LiNr:" alignment="right"/>
+      <label c:x="50" c:y="8" c:width="12" text="Versandart:"
+        alignment="right"/>
+      <label c:x="50" c:y="9" c:width="12" text="Kategorie:" 
alignment="right"/>
+
+      <entry c:x="63" c:y="1" c:width="40" block="blkCompany" field="ePhone" />
+      <entry c:x="63" c:y="2" c:width="40" block="blkCompany" field="eFax" />
+      <entry c:x="63" c:y="3" c:width="40" block="blkCompany" field="eWeb" />
+      <entry c:x="63" c:y="4" c:width="40" block="blkCompany" field="eMail" />
+      <entry c:x="63" c:y="5" c:width="40" block="blkCompany"
+        field="eCustomer" />
+      <entry c:x="63" c:y="6" c:width="40" block="blkCompany"
+        field="eBWCustomer" />
+      <entry c:x="63" c:y="7" c:width="40" block="blkCompany"
+        field="eBWSupplier" />
+      <entry c:x="63" c:y="8" c:width="40" block="blkCompany" 
+        field="eShipment" />
+      <entry c:x="63" c:y="9" c:width="40" block="blkCompany" field="eCategory"
+        style="dropdown" />
+
+
+      <box c:x="0" c:y="10" c:width="103" c:height="7" label="Ansprechperson" 
/>
+
+      <label c:x="2" c:y="11" c:width="10" text="Anrede:" />
+      <label c:x="2" c:y="12" c:width="10" text="Vorname:" />
+      <label c:x="2" c:y="13" c:width="10" text="Nachname:" />
+      <label c:x="2" c:y="14" c:width="10" text="Abteilung:" />
+      <label c:x="2" c:y="15" c:width="10" text="Funktion:" />
+      <label c:x="28" c:y="11" c:width="5" text="Titel:" alignment="right"/>
+
+      <entry c:x="12" c:y="11" c:width="15" block="blkContact"
+        field="eSalutation" style="dropdown" />
+      <entry c:x="34" c:y="11" c:width="15" block="blkContact" field="eTitle" 
/>
+      <entry c:x="12" c:y="12" c:width="37" block="blkContact"
+        field="eFirstname" />
+      <entry c:x="12" c:y="13" c:width="37" block="blkContact" field="eSurname"
+        />
+      <entry c:x="12" c:y="14" c:width="37" block="blkContact"
+        field="eDepartment" />
+      <entry c:x="12" c:y="15" c:width="37" block="blkContact"
+        field="eDuty" />
+
+      <label c:x="50" c:y="11" c:width="12" text="Telefon 1:"
+        alignment="right"/>
+      <label c:x="50" c:y="12" c:width="12" text="Telefon 2:" 
+        alignment="right"/>
+      <label c:x="50" c:y="13" c:width="12" text="Fax:" alignment="right"/>
+      <label c:x="50" c:y="14" c:width="12" text="E-Mail:" alignment="right"/>
+
+      <entry c:x="63" c:y="11" c:width="38" block="blkContact" 
field="ePhone1"/>
+      <entry c:x="63" c:y="12" c:width="38" block="blkContact" 
field="ePhone2"/>
+      <entry c:x="63" c:y="13" c:width="38" block="blkContact" field="eFax" />
+      <entry c:x="63" c:y="14" c:width="38" block="blkContact" field="eMail" />
+
+      <button c:x="89" c:y="15" c:width="12" label="Memo" />
+    </page>
+
+  </layout>
+</form>

Added: address/schema.gsd
===================================================================
--- address/schema.gsd  2006-02-20 19:02:28 UTC (rev 232)
+++ address/schema.gsd  2006-02-24 16:31:50 UTC (rev 233)
@@ -0,0 +1,142 @@
+<?xml version="1.0" encoding="UTF-8"?>
+
+<schema>
+  <tables>
+    <table name="company">
+      <fields>
+        <field name="id" type="number" length="8" nullable="False" />
+
+        <field name="matchcode" type="string" length="20" />
+        <field name="name1" type="string" length="64" />
+        <field name="name2" type="string" length="64" />
+        <field name="street" type="string" length="64" />
+        <field name="country" type="string" length="4" />
+        <field name="zip" type="string" length="10" />
+        <field name="city" type="string" length="64" />
+        <field name="vatid" type="string" length="18"  />
+        <field name="compreg" type="string" length="32" />
+        <field name="phone" type="string" length="50"  />
+        <field name="fax" type="string" length="50"  />
+        <field name="web" type="string" length="64" />
+        <field name="email" type="string" length="64" />
+        <field name="customer" type="string" length="20" />
+        <field name="bwcustomer" type="string" length="16" />
+        <field name="bwsupplier" type="string" length="16" />
+        <field name="shipment" type="string" length="64" />
+        <field name="category" type="number" length="8" />
+
+      </fields>
+
+      <primarykey name="pk_company">
+        <pkfield name="id" />
+      </primarykey>
+
+      <constraints>
+        <foreignkey name="fk_company_has_category" references="category">
+          <fkfield name="category" references="id" />
+        </foreignkey>
+      </constraints>
+    </table>
+
+    <table name="cpmemo">
+      <fields>
+        <field name="id" type="number" length="8" nullable="False"
+          defaultwith="serial" />
+        <field name="company" type="number" length="8" nullable="False" />
+        <field name="text" type="string" length="2000" />
+      </fields>
+
+      <primarykey name="pk_cpmemo">
+        <pkfield name="id" />
+      </primarykey>
+
+      <constraints>
+        <foreignkey name="fk_cpmemo_has_company" references="company">
+          <fkfield name="company" references="id" />
+        </foreignkey>
+      </constraints>
+    </table>
+
+    <table name="contact">
+      <fields>
+        <field name="id" type="number" length="8" nullable="False" />
+        <field name="company" type="string" length="8" nullable="False" />
+
+        <field name="salutation" type="number" length="8" />
+        <field name="title" type="string" length="21" />
+        <field name="firstname" type="string" length="26" />
+        <field name="surname" type="string" length="31" />
+        <field name="department" type="string" length="32" />
+        <field name="duty" type="string" length="32" />
+        <field name="phone1" type="string" length="32" />
+        <field name="phone2" type="string" length="32" />
+        <field name="fax" type="string" length="32" />
+        <field name="email" type="string" length="64" />
+      </fields>
+
+      <primarykey name="pk_contact">
+        <pkfield name="id" />
+      </primarykey>
+
+      <constraints>
+        <foreignkey name="fk_company_has_contacts" references="company" >
+          <fkfield name="company" references="id" />
+        </foreignkey>
+
+        <foreignkey name="fk_contact_has_salutation" references="salutation">
+          <fkfield name="salutation" references="id" />
+        </foreignkey>
+      </constraints>
+    </table>
+
+    <table name="ctmemo">
+      <fields>
+        <field name="id" type="number" length="8" nullable="False"
+          defaultwith="serial" />
+        <field name="company" type="number" length="8" nullable="False" />
+        <field name="contact" type="number" length="8" nullable="False" />
+        <field name="text" type="string" length="2000" />
+      </fields>
+
+      <primarykey name="pk_ctmemo">
+        <pkfield name="id" />
+      </primarykey>
+
+      <constraints>
+        <foreignkey name="fk_ctmemo_has_company" references="company">
+          <fkfield name="company" references="id" />
+        </foreignkey>
+        <foreignkey name="fk_ctmemo_has_contanct" references="contact">
+          <fkfield name="contact" references="id" />
+        </foreignkey>
+      </constraints>
+    </table>
+
+
+    <table name="category">
+      <fields>
+        <field name="id" type="number" length="8" nullable="False"
+          defaultwith="serial" />
+        <field name="text" type="string" length="32" default="(neu/zuordnen)" 
/>
+      </fields>
+
+      <primarykey name="pk_category">
+        <pkfield name="id" />
+      </primarykey>
+    </table>
+
+    <table name="salutation">
+      <fields>
+        <field name="id" type="number" length="8" nullable="False"
+          defaultwith="serial" />
+        <field name="text" type="string" length="15" />
+      </fields>
+
+      <primarykey name="pk_salutation">
+        <pkfield name="id" />
+      </primarykey>
+    </table>
+
+  </tables>
+
+</schema>

Added: address/stamm.gfd
===================================================================
--- address/stamm.gfd   2006-02-20 19:02:28 UTC (rev 232)
+++ address/stamm.gfd   2006-02-24 16:31:50 UTC (rev 233)
@@ -0,0 +1,41 @@
+<?xml version="1.0" encoding="iso8859-1"?>
+
+<form title="Adressenverwaltung">
+  <options>
+    <author>ByteWise Software GmbH</author>
+    <version>0.0.1</version>
+    <description>Stammdaten</description>
+  </options>
+
+  <datasource name="dtsCategory" connection="address" table="category"
+    prequery="Y"/>
+  <datasource name="dtsSalutation" connection="address" table="salutation"
+    prequery="Y"/>
+
+  <logic>
+    <block name="blkCategory" datasource="dtsCategory" rows="10">
+      <field name="eId" field="id" readonly="Y" />
+      <field name="eText" field="text" maxLength="32" />
+    </block>
+
+    <block name="blkSalutation" datasource="dtsSalutation" rows="10">
+      <field name="eId" field="id" readonly="Y" />
+      <field name="eText" field="text" maxLength="15" />
+    </block>
+
+  </logic>
+
+  <layout xmlns:c="GNUe:Layout:Char" c:height="15" c:width="80" tabbed="top">
+
+    <page name="pgCategory" caption="Kategorie">
+      <label c:x="1" c:y="0" c:width="10" text="Bezeichnung:" />
+      <entry c:x="1" c:y="1" c:width="35" block="blkCategory" field="eText"/>
+    </page>
+
+    <page name="pgSalutation" caption="Anrede">
+      <label c:x="1" c:y="0" c:width="10" text="Bezeichnung:" />
+      <entry c:x="1" c:y="1" c:width="35" block="blkSalutation" field="eText"/>
+    </page>
+
+  </layout>
+</form>