[gnue] r9234 - trunk/gnue-samples/two-tier/forms

[johannes]

Author: johannes
Date: 2007-01-09 03:14:51 -0600 (Tue, 09 Jan 2007)
New Revision: 9234

Modified:
   trunk/gnue-samples/two-tier/forms/items.gfd
Log:
Added Statistics page


Modified: trunk/gnue-samples/two-tier/forms/items.gfd
===================================================================
--- trunk/gnue-samples/two-tier/forms/items.gfd 2007-01-09 08:46:05 UTC (rev 
9233)
+++ trunk/gnue-samples/two-tier/forms/items.gfd 2007-01-09 09:14:51 UTC (rev 
9234)
@@ -39,6 +39,21 @@
     </sortorder>
   </datasource>
 
+  <!-- #################################################################### -->
+
+  <datasource name="dts_invoice_item" connection="sample" table="invoice_item"
+    master="dts_item" masterlink="id" detaillink="sku" />
+
+  <!-- #################################################################### -->
+
+  <datasource name="dts_invoice" connection="sample" table="invoice"
+    master="dts_invoice_item" masterlink="invoice" detaillink="id" />
+
+  <!-- #################################################################### -->
+
+  <datasource name="dts_customer" connection="sample" table="customer"
+    master="dts_invoice" masterlink="customer" detaillink="id" />
+
   <!-- ==================================================================== -->
   <!-- Logic                                                                -->
   <!-- ==================================================================== -->
@@ -65,13 +80,37 @@
         blk_item.picture.value = url
       </trigger>
     </block>
+
+    <!-- ################################################################## -->
+
+    <block name="blk_inv_item" datasource="dts_invoice_item" editable="N">
+      <field name="quantity" field="quantity" datatype="number" length="9"
+        scale="0" />
+      <field name="price" field="unit_price" datatype="number" length="9"
+        scale="2"/>
+    </block>
+
+    <!-- ################################################################## -->
+
+    <block name="blk_invoice" datasource="dts_invoice" editable="N">
+      <field name="date" field="date" datatype="date" />
+      <field name="id" field="id" datatype="number" length="8" scale="0" />
+    </block>
+
+    <!-- ################################################################## -->
+
+    <block name="blk_customer" datasource="dts_customer" editable="N">
+      <field name="code" field="code" datatype="text" />
+      <field name="name" field="name" datatype="text" />
+    </block>
+
   </logic>
 
   <!-- ==================================================================== -->
   <!-- Layout                                                               -->
   <!-- ==================================================================== -->
 
-  <layout xmlns:s="GNUe:Layout:Sizer">
+  <layout xmlns:s="GNUe:Layout:Sizer" tabbed="top">
     <page name="pg_item" caption="Items">
       <vbox name="box" block="blk_item">
         <entry name="sku" field="sku" label="SKU:"/>
@@ -83,6 +122,19 @@
           s:width="150" s:height="100" fit="auto"/>
       </vbox>
     </page>
+
+    <page name="pg_stats" caption="Invoice items">
+      <grid name="grid_stats" block="blk_inv_item" rows="10">
+        <gridline>
+          <entry field="code" block="blk_customer" label="Cust.Code" />
+          <entry field="name" block="blk_customer" label="Customer" />
+          <entry field="id" block="blk_invoice" label="Inv.Nr" />
+          <entry field="date" block="blk_invoice" label="Inv.Date" />
+          <entry field="quantity" block="blk_inv_item" label="Quantity" />
+          <entry field="price" block="blk_inv_item" label="Price" />
+        </gridline>
+      </grid>
+    </page>
   </layout>
 
 </form>