gnue/gnue-config drop_all_tables.sql accounting...

[Neil Tiffin]

CVSROOT:        /home/cvs
Module name:    gnue
Changes by:     Neil Tiffin <address@hidden>    01/06/03 13:48:02

Modified files:
        gnue-config    : drop_all_tables.sql 
        gnue-config/accounting/ar/classes: invoice.gcd 
        gnue-config/sales/customer/classes: customer.gcd 
        gnue-config/sales/sales-order/classes: sales-order.gcd 

Log message:
        Expand customer, invoice, and sales order classes.

CVSWeb URLs:
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/drop_all_tables.sql.diff?cvsroot=OldCVS&tr1=1.1&tr2=1.2&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/accounting/ar/classes/invoice.gcd.diff?cvsroot=OldCVS&tr1=1.2&tr2=1.3&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/sales/customer/classes/customer.gcd.diff?cvsroot=OldCVS&tr1=1.2&tr2=1.3&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/sales/sales-order/classes/sales-order.gcd.diff?cvsroot=OldCVS&tr1=1.2&tr2=1.3&r1=text&r2=text

Patches:
Index: gnue/gnue-config/accounting/ar/classes/invoice.gcd
diff -u gnue/gnue-config/accounting/ar/classes/invoice.gcd:1.2 
gnue/gnue-config/accounting/ar/classes/invoice.gcd:1.3
--- gnue/gnue-config/accounting/ar/classes/invoice.gcd:1.2      Fri May 18 
18:09:58 2001
+++ gnue/gnue-config/accounting/ar/classes/invoice.gcd  Sun Jun  3 13:48:02 2001
@@ -22,42 +22,47 @@
 #
 # This file originally written by Neil Tiffin (address@hidden).
 #
-# $Id: invoice.gcd,v 1.2 2001/05/19 01:09:58 ntiffin Exp $
+# $Id: invoice.gcd,v 1.3 2001/06/03 20:48:02 ntiffin Exp $
 #
 
-include "../../../base/location/classes/address.gcd"
+include "../../../base/currency/classes/currency.gcd"
+include "../../../sales/sales-order/classes/sales-order.gcd"
 
 module ar
 {
 
-  class invoice_head
+  class payment
   {
-    char              id<10>;
+    date            date;
+    currency::money amount;
+    char            note<250>;
+    ar::invoice    *invoice;
+    char            check_number<15>;
+  };
+
+  class adjustment
+  {
+    date            date;
+    currency::money amount;
+    char            note<250>;
+    ar::invoice    *invoice;
+  };
+
+  class invoice : sales_order::header
+  {
+    char              invoice_id<10>;
     date              date_invoiced;
-    char              ship_to_name<80>;
-    location::address ship_to_address;
-    char              bill_to_name<80>;
-    location::address bill_to_address;
-    char              ship_via<15>;
-    char              customer_reference<30>;
-    float             total_price;
-    int               total_lines;
+    char              status;  # open, paid-in-full, closed
+    char              note<500>;
     
-    ar::invoice_detail [] detail;
+    currency::money       total_paid;
+    ar::payment        [] payment;
+    ar::adjustment     [] adjustment;
   };
-  
   
-  class invoice_detail
+  class credit : customer::customer
   {
-    ar::invoice_head *invoice;
-    
-    int   line_number;
-    char  number<8>;
-    char  description<25>;
-    float quantity;
-    float unit_price;
-    char  line_type<8>;  # freight, sales tax, item, service etc.
-    
+    currency::money   credit_limit;
+    char              credit_status<8>;   # can sell to, not approved etc
   };
-  
 };
Index: gnue/gnue-config/drop_all_tables.sql
diff -u gnue/gnue-config/drop_all_tables.sql:1.1 
gnue/gnue-config/drop_all_tables.sql:1.2
--- gnue/gnue-config/drop_all_tables.sql:1.1    Fri May 25 17:34:23 2001
+++ gnue/gnue-config/drop_all_tables.sql        Sun Jun  3 13:48:02 2001
@@ -22,6 +22,12 @@
 DROP TABLE language__language;
 DROP TABLE location__country;
 DROP TABLE location__region;
+DROP TABLE neil_order__detail;
+DROP TABLE neil_order__master;
+DROP TABLE organization__address;
+DROP TABLE organization__contact;
+DROP TABLE organization__organization;
+DROP TABLE parameter;
 DROP TABLE person__address;
 DROP TABLE person__comm;
 DROP TABLE person__comm_type;
@@ -38,6 +44,9 @@
 DROP TABLE receiving__receiving;
 DROP TABLE sales_order__sales_order;
 DROP TABLE shipping__shipping;
+DROP TABLE test_module_1__class2;
+DROP TABLE test_module_1__class3;
+DROP TABLE test_module_2__class1;
 DROP TABLE unit__conversion;
 DROP TABLE unit__conversion_unit;
 DROP TABLE unit__unit;
Index: gnue/gnue-config/sales/customer/classes/customer.gcd
diff -u gnue/gnue-config/sales/customer/classes/customer.gcd:1.2 
gnue/gnue-config/sales/customer/classes/customer.gcd:1.3
--- gnue/gnue-config/sales/customer/classes/customer.gcd:1.2    Wed May 16 
17:35:12 2001
+++ gnue/gnue-config/sales/customer/classes/customer.gcd        Sun Jun  3 
13:48:02 2001
@@ -22,13 +22,19 @@
 #
 # This file originally written by Neil Tiffin (address@hidden).
 #
-# $Id: customer.gcd,v 1.2 2001/05/17 00:35:12 ntiffin Exp $
+# $Id: customer.gcd,v 1.3 2001/06/03 20:48:02 ntiffin Exp $
 #
 
+include "../../../base/company/classes/company.gcd"
+include "../../../base/currency/classes/currency.gcd"
+
 module customer
 {
-  class customer
+  class customer : organization::organization
   {
-    char  dummy<8>;
+    currency::money   this_year_sales;
+    currency::money   last_year_sales;
+    date              last_sale;       # date of last sale
+    char              type<8>;         # type of customer
   };  
 };
Index: gnue/gnue-config/sales/sales-order/classes/sales-order.gcd
diff -u gnue/gnue-config/sales/sales-order/classes/sales-order.gcd:1.2 
gnue/gnue-config/sales/sales-order/classes/sales-order.gcd:1.3
--- gnue/gnue-config/sales/sales-order/classes/sales-order.gcd:1.2      Fri May 
18 18:09:58 2001
+++ gnue/gnue-config/sales/sales-order/classes/sales-order.gcd  Sun Jun  3 
13:48:02 2001
@@ -22,13 +22,41 @@
 #
 # This file originally written by Neil Tiffin (address@hidden).
 #
-# $Id: sales-order.gcd,v 1.2 2001/05/19 01:09:58 ntiffin Exp $
+# $Id: sales-order.gcd,v 1.3 2001/06/03 20:48:02 ntiffin Exp $
 #
 
+include "../../../base/currency/classes/currency.gcd"
+include "../../../base/units/classes/units.gcd"
+include "../../../sales/customer/classes/customer.gcd"
+
 module sales_order
 {
-  class sales_order
+  class header
+  {
+    char              order_id<10>;
+    date              order_date;
+    date              cust_required;
+    char              ship_to_name<80>;
+    location::address ship_to_address;
+    char              bill_to_name<80>;
+    location::address bill_to_address;
+    char              ship_via<15>;
+    char              customer_reference<30>;
+    currency::money   total;   #total for all items
+    char              order_special_inst<500>;
+    
+    sales_order::detail [] detail;
+    customer::customer   * customer;
+  };
+  
+  class detail
   {
-    char  dummy<8>;
-  };  
+    sales_order::header *header;
+    
+    int             line_number;
+    char            description<25>;
+    unit::quantity  quantity;
+    currency::money unit_price;
+    char            line_type<8>;  # freight, sales tax, item, tax service etc.
+  };
 };