summaryrefslogtreecommitdiff
path: root/demos/northwind-db/protected/database
diff options
context:
space:
mode:
Diffstat (limited to 'demos/northwind-db/protected/database')
-rw-r--r--demos/northwind-db/protected/database/Category.php50
-rw-r--r--demos/northwind-db/protected/database/Customer.php64
-rw-r--r--demos/northwind-db/protected/database/Employee.php94
-rw-r--r--demos/northwind-db/protected/database/Order.php82
-rw-r--r--demos/northwind-db/protected/database/OrderDetail.php52
-rw-r--r--demos/northwind-db/protected/database/Product.php70
-rw-r--r--demos/northwind-db/protected/database/Region.php48
-rw-r--r--demos/northwind-db/protected/database/Shipper.php48
-rw-r--r--demos/northwind-db/protected/database/Supplier.php66
-rw-r--r--demos/northwind-db/protected/database/Territory.php118
10 files changed, 346 insertions, 346 deletions
diff --git a/demos/northwind-db/protected/database/Category.php b/demos/northwind-db/protected/database/Category.php
index 06fc979f..d708ee96 100644
--- a/demos/northwind-db/protected/database/Category.php
+++ b/demos/northwind-db/protected/database/Category.php
@@ -1,26 +1,26 @@
-<?php
-/**
- * Auto generated by prado-cli.php on 2007-05-01 05:24:53.
- */
-class Category extends TActiveRecord
-{
- const TABLE='Categories';
-
- public $CategoryID;
- public $CategoryName;
- public $Description;
- public $Picture;
-
- public $Products=array();
-
- public static $RELATIONS=array
- (
- 'Products' => array(self::HAS_MANY, 'Product'),
- );
-
- public static function finder($className=__CLASS__)
- {
- return parent::finder($className);
- }
-}
+<?php
+/**
+ * Auto generated by prado-cli.php on 2007-05-01 05:24:53.
+ */
+class Category extends TActiveRecord
+{
+ const TABLE='Categories';
+
+ public $CategoryID;
+ public $CategoryName;
+ public $Description;
+ public $Picture;
+
+ public $Products=array();
+
+ public static $RELATIONS=array
+ (
+ 'Products' => array(self::HAS_MANY, 'Product'),
+ );
+
+ public static function finder($className=__CLASS__)
+ {
+ return parent::finder($className);
+ }
+}
?> \ No newline at end of file
diff --git a/demos/northwind-db/protected/database/Customer.php b/demos/northwind-db/protected/database/Customer.php
index 810f2a6a..464b384d 100644
--- a/demos/northwind-db/protected/database/Customer.php
+++ b/demos/northwind-db/protected/database/Customer.php
@@ -1,33 +1,33 @@
-<?php
-/**
- * Auto generated by prado-cli.php on 2007-05-01 05:28:47.
- */
-class Customer extends TActiveRecord
-{
- const TABLE='Customers';
-
- public $CustomerID;
- public $CompanyName;
- public $ContactName;
- public $ContactTitle;
- public $Address;
- public $City;
- public $Region;
- public $PostalCode;
- public $Country;
- public $Phone;
- public $Fax;
-
- public $Orders=array();
-
- public static $RELATIONS = array
- (
- 'Orders' => array(self::HAS_MANY, 'Order'),
- );
-
- public static function finder($className=__CLASS__)
- {
- return parent::finder($className);
- }
-}
+<?php
+/**
+ * Auto generated by prado-cli.php on 2007-05-01 05:28:47.
+ */
+class Customer extends TActiveRecord
+{
+ const TABLE='Customers';
+
+ public $CustomerID;
+ public $CompanyName;
+ public $ContactName;
+ public $ContactTitle;
+ public $Address;
+ public $City;
+ public $Region;
+ public $PostalCode;
+ public $Country;
+ public $Phone;
+ public $Fax;
+
+ public $Orders=array();
+
+ public static $RELATIONS = array
+ (
+ 'Orders' => array(self::HAS_MANY, 'Order'),
+ );
+
+ public static function finder($className=__CLASS__)
+ {
+ return parent::finder($className);
+ }
+}
?> \ No newline at end of file
diff --git a/demos/northwind-db/protected/database/Employee.php b/demos/northwind-db/protected/database/Employee.php
index 1e0f090e..573b887d 100644
--- a/demos/northwind-db/protected/database/Employee.php
+++ b/demos/northwind-db/protected/database/Employee.php
@@ -1,48 +1,48 @@
-<?php
-/**
- * Auto generated by prado-cli.php on 2007-05-01 05:29:32.
- */
-class Employee extends TActiveRecord
-{
- const TABLE='Employees';
-
- public $EmployeeID;
- public $LastName;
- public $FirstName;
- public $Title;
- public $TitleOfCourtesy;
- public $BirthDate;
- public $HireDate;
- public $Address;
- public $City;
- public $Region;
- public $PostalCode;
- public $Country;
- public $HomePhone;
- public $Extension;
- public $Photo;
- public $Notes;
- public $ReportsTo;
- public $PhotoPath;
-
- public $Territories=array();
- public $Orders=array();
- public $Subordinates=array();
- public $Superior;
-
- public static $RELATIONS = array
- (
- 'Territories' => array(self::MANY_TO_MANY, 'Territory', 'EmployeeTerritories'),
- 'Orders' => array(self::HAS_MANY, 'Order'),
-
- //parent children relationship
- 'Subordinates' => array(self::HAS_MANY, 'Employee'),
- 'Superior' => array(self::BELONGS_TO, 'Employee')
- );
-
- public static function finder($className=__CLASS__)
- {
- return parent::finder($className);
- }
-}
+<?php
+/**
+ * Auto generated by prado-cli.php on 2007-05-01 05:29:32.
+ */
+class Employee extends TActiveRecord
+{
+ const TABLE='Employees';
+
+ public $EmployeeID;
+ public $LastName;
+ public $FirstName;
+ public $Title;
+ public $TitleOfCourtesy;
+ public $BirthDate;
+ public $HireDate;
+ public $Address;
+ public $City;
+ public $Region;
+ public $PostalCode;
+ public $Country;
+ public $HomePhone;
+ public $Extension;
+ public $Photo;
+ public $Notes;
+ public $ReportsTo;
+ public $PhotoPath;
+
+ public $Territories=array();
+ public $Orders=array();
+ public $Subordinates=array();
+ public $Superior;
+
+ public static $RELATIONS = array
+ (
+ 'Territories' => array(self::MANY_TO_MANY, 'Territory', 'EmployeeTerritories'),
+ 'Orders' => array(self::HAS_MANY, 'Order'),
+
+ //parent children relationship
+ 'Subordinates' => array(self::HAS_MANY, 'Employee'),
+ 'Superior' => array(self::BELONGS_TO, 'Employee')
+ );
+
+ public static function finder($className=__CLASS__)
+ {
+ return parent::finder($className);
+ }
+}
?> \ No newline at end of file
diff --git a/demos/northwind-db/protected/database/Order.php b/demos/northwind-db/protected/database/Order.php
index 228fb2b5..2a425102 100644
--- a/demos/northwind-db/protected/database/Order.php
+++ b/demos/northwind-db/protected/database/Order.php
@@ -1,42 +1,42 @@
-<?php
-/**
- * Auto generated by prado-cli.php on 2007-05-01 05:29:47.
- */
-class Order extends TActiveRecord
-{
- const TABLE='Orders';
-
- public $OrderID;
- public $CustomerID;
- public $EmployeeID;
- public $OrderDate;
- public $RequiredDate;
- public $ShippedDate;
- public $ShipVia;
- public $Freight;
- public $ShipName;
- public $ShipAddress;
- public $ShipCity;
- public $ShipRegion;
- public $ShipPostalCode;
- public $ShipCountry;
-
- public $OrderDetails=array();
- public $Customer;
- public $Shipper;
- public $Employee;
-
- public static $RELATIONS = array
- (
- 'OrderDetails' => array(self::HAS_MANY, 'OrderDetail'),
- 'Customer' => array(self::BELONGS_TO, 'Customer'),
- 'Shipper' => array(self::BELONGS_TO, 'Shipper'),
- 'Employee' => array(self::BELONGS_TO, 'Employee'),
- );
-
- public static function finder($className=__CLASS__)
- {
- return parent::finder($className);
- }
-}
+<?php
+/**
+ * Auto generated by prado-cli.php on 2007-05-01 05:29:47.
+ */
+class Order extends TActiveRecord
+{
+ const TABLE='Orders';
+
+ public $OrderID;
+ public $CustomerID;
+ public $EmployeeID;
+ public $OrderDate;
+ public $RequiredDate;
+ public $ShippedDate;
+ public $ShipVia;
+ public $Freight;
+ public $ShipName;
+ public $ShipAddress;
+ public $ShipCity;
+ public $ShipRegion;
+ public $ShipPostalCode;
+ public $ShipCountry;
+
+ public $OrderDetails=array();
+ public $Customer;
+ public $Shipper;
+ public $Employee;
+
+ public static $RELATIONS = array
+ (
+ 'OrderDetails' => array(self::HAS_MANY, 'OrderDetail'),
+ 'Customer' => array(self::BELONGS_TO, 'Customer'),
+ 'Shipper' => array(self::BELONGS_TO, 'Shipper'),
+ 'Employee' => array(self::BELONGS_TO, 'Employee'),
+ );
+
+ public static function finder($className=__CLASS__)
+ {
+ return parent::finder($className);
+ }
+}
?> \ No newline at end of file
diff --git a/demos/northwind-db/protected/database/OrderDetail.php b/demos/northwind-db/protected/database/OrderDetail.php
index 1732b0d9..47f77351 100644
--- a/demos/northwind-db/protected/database/OrderDetail.php
+++ b/demos/northwind-db/protected/database/OrderDetail.php
@@ -1,27 +1,27 @@
-<?php
-
-class OrderDetail extends TActiveRecord
-{
- const TABLE='Order Details';
-
- public $OrderID;
- public $ProductID;
- public $UnitPrice;
- public $Quantity;
- public $Discount;
-
- public $Product;
- public $Order;
-
- public static $RELATIONS = array
- (
- 'Product' => array(self::BELONGS_TO, 'Product'),
- 'Order' => array(self::BELONGS_TO, 'Order'),
- );
-
- public static function finder($className=__CLASS__)
- {
- return parent::finder($className);
- }
-}
+<?php
+
+class OrderDetail extends TActiveRecord
+{
+ const TABLE='Order Details';
+
+ public $OrderID;
+ public $ProductID;
+ public $UnitPrice;
+ public $Quantity;
+ public $Discount;
+
+ public $Product;
+ public $Order;
+
+ public static $RELATIONS = array
+ (
+ 'Product' => array(self::BELONGS_TO, 'Product'),
+ 'Order' => array(self::BELONGS_TO, 'Order'),
+ );
+
+ public static function finder($className=__CLASS__)
+ {
+ return parent::finder($className);
+ }
+}
?> \ No newline at end of file
diff --git a/demos/northwind-db/protected/database/Product.php b/demos/northwind-db/protected/database/Product.php
index 93736ab8..088fbbd2 100644
--- a/demos/northwind-db/protected/database/Product.php
+++ b/demos/northwind-db/protected/database/Product.php
@@ -1,36 +1,36 @@
-<?php
-/**
- * Auto generated by prado-cli.php on 2007-05-01 05:31:51.
- */
-class Product extends TActiveRecord
-{
- const TABLE='Products';
-
- public $ProductID;
- public $ProductName;
- public $SupplierID;
- public $CategoryID;
- public $QuantityPerUnit;
- public $UnitPrice;
- public $UnitsInStock;
- public $UnitsOnOrder;
- public $ReorderLevel;
- public $Discontinued;
-
- public $Supplier;
- public $Category;
- public $OrderDetails=array();
-
- public static $RELATIONS = array
- (
- 'Supplier' => array(self::BELONGS_TO, 'Supplier'),
- 'Category' => array(self::BELONGS_TO, 'Category'),
- 'OrderDetails' => array(self::HAS_MANY, 'OrderDetail'),
- );
-
- public static function finder($className=__CLASS__)
- {
- return parent::finder($className);
- }
-}
+<?php
+/**
+ * Auto generated by prado-cli.php on 2007-05-01 05:31:51.
+ */
+class Product extends TActiveRecord
+{
+ const TABLE='Products';
+
+ public $ProductID;
+ public $ProductName;
+ public $SupplierID;
+ public $CategoryID;
+ public $QuantityPerUnit;
+ public $UnitPrice;
+ public $UnitsInStock;
+ public $UnitsOnOrder;
+ public $ReorderLevel;
+ public $Discontinued;
+
+ public $Supplier;
+ public $Category;
+ public $OrderDetails=array();
+
+ public static $RELATIONS = array
+ (
+ 'Supplier' => array(self::BELONGS_TO, 'Supplier'),
+ 'Category' => array(self::BELONGS_TO, 'Category'),
+ 'OrderDetails' => array(self::HAS_MANY, 'OrderDetail'),
+ );
+
+ public static function finder($className=__CLASS__)
+ {
+ return parent::finder($className);
+ }
+}
?> \ No newline at end of file
diff --git a/demos/northwind-db/protected/database/Region.php b/demos/northwind-db/protected/database/Region.php
index 3d1c2a84..6473e682 100644
--- a/demos/northwind-db/protected/database/Region.php
+++ b/demos/northwind-db/protected/database/Region.php
@@ -1,25 +1,25 @@
-<?php
-/**
- * Auto generated by prado-cli.php on 2007-05-01 05:32:34.
- */
-class Region extends TActiveRecord
-{
- const TABLE='Region';
-
- public $RegionID;
- public $RegionDescription;
-
- //comment out the following line to use lazy loading
- //public $Territories=array();
-
- public static $RELATIONS = array
- (
- 'Territories' => array(self::HAS_MANY, 'Territory')
- );
-
- public static function finder($className=__CLASS__)
- {
- return parent::finder($className);
- }
-}
+<?php
+/**
+ * Auto generated by prado-cli.php on 2007-05-01 05:32:34.
+ */
+class Region extends TActiveRecord
+{
+ const TABLE='Region';
+
+ public $RegionID;
+ public $RegionDescription;
+
+ //comment out the following line to use lazy loading
+ //public $Territories=array();
+
+ public static $RELATIONS = array
+ (
+ 'Territories' => array(self::HAS_MANY, 'Territory')
+ );
+
+ public static function finder($className=__CLASS__)
+ {
+ return parent::finder($className);
+ }
+}
?> \ No newline at end of file
diff --git a/demos/northwind-db/protected/database/Shipper.php b/demos/northwind-db/protected/database/Shipper.php
index a3f0aeb3..f90548ea 100644
--- a/demos/northwind-db/protected/database/Shipper.php
+++ b/demos/northwind-db/protected/database/Shipper.php
@@ -1,25 +1,25 @@
-<?php
-/**
- * Auto generated by prado-cli.php on 2007-05-01 05:32:57.
- */
-class Shipper extends TActiveRecord
-{
- const TABLE='Shippers';
-
- public $ShipperID;
- public $CompanyName;
- public $Phone;
-
- public $Orders = array();
-
- public static $RELATIONS = array
- (
- 'Orders' => array(self::HAS_MANY, 'Order'),
- );
-
- public static function finder($className=__CLASS__)
- {
- return parent::finder($className);
- }
-}
+<?php
+/**
+ * Auto generated by prado-cli.php on 2007-05-01 05:32:57.
+ */
+class Shipper extends TActiveRecord
+{
+ const TABLE='Shippers';
+
+ public $ShipperID;
+ public $CompanyName;
+ public $Phone;
+
+ public $Orders = array();
+
+ public static $RELATIONS = array
+ (
+ 'Orders' => array(self::HAS_MANY, 'Order'),
+ );
+
+ public static function finder($className=__CLASS__)
+ {
+ return parent::finder($className);
+ }
+}
?> \ No newline at end of file
diff --git a/demos/northwind-db/protected/database/Supplier.php b/demos/northwind-db/protected/database/Supplier.php
index 7cabdde5..bc3b44e0 100644
--- a/demos/northwind-db/protected/database/Supplier.php
+++ b/demos/northwind-db/protected/database/Supplier.php
@@ -1,34 +1,34 @@
-<?php
-/**
- * Auto generated by prado-cli.php on 2007-05-01 05:33:08.
- */
-class Supplier extends TActiveRecord
-{
- const TABLE='Suppliers';
-
- public $SupplierID;
- public $CompanyName;
- public $ContactName;
- public $ContactTitle;
- public $Address;
- public $City;
- public $Region;
- public $PostalCode;
- public $Country;
- public $Phone;
- public $Fax;
- public $HomePage;
-
- public $Products=array();
-
- public static $RELATIONS=array
- (
- 'Products' => array(self::HAS_MANY, 'Product')
- );
-
- public static function finder($className=__CLASS__)
- {
- return parent::finder($className);
- }
-}
+<?php
+/**
+ * Auto generated by prado-cli.php on 2007-05-01 05:33:08.
+ */
+class Supplier extends TActiveRecord
+{
+ const TABLE='Suppliers';
+
+ public $SupplierID;
+ public $CompanyName;
+ public $ContactName;
+ public $ContactTitle;
+ public $Address;
+ public $City;
+ public $Region;
+ public $PostalCode;
+ public $Country;
+ public $Phone;
+ public $Fax;
+ public $HomePage;
+
+ public $Products=array();
+
+ public static $RELATIONS=array
+ (
+ 'Products' => array(self::HAS_MANY, 'Product')
+ );
+
+ public static function finder($className=__CLASS__)
+ {
+ return parent::finder($className);
+ }
+}
?> \ No newline at end of file
diff --git a/demos/northwind-db/protected/database/Territory.php b/demos/northwind-db/protected/database/Territory.php
index 16f33dea..96006bb1 100644
--- a/demos/northwind-db/protected/database/Territory.php
+++ b/demos/northwind-db/protected/database/Territory.php
@@ -1,60 +1,60 @@
-<?php
-/**
- * Auto generated by prado-cli.php on 2007-05-01 05:33:28.
- */
-class Territory extends TActiveRecord
-{
- const TABLE='Territories';
-
- public $TerritoryID;
- public $TerritoryDescription;
- public $RegionID;
-
- private $_region;
- private $_employees;
-
- public static $RELATIONS = array
- (
- 'Region' => array(self::BELONGS_TO, 'Region'),
- 'Employees' => array(self::HAS_MANY, 'Employee', 'EmployeeTerritories')
- );
-
- /**
- * @return Region
- */
- public function getRegion()
- {
- //lazy load the region
- if($this->_region===null)
- $this->_region = Region::finder()->findByPk($this->RegionID);
- return $this->_region;
- }
-
- public function setRegion($value)
- {
- $this->_region=$value;
- }
-
- /**
- * @return Employee[]
- */
- public function getEmployees()
- {
- //lazy load
- if($this->_employees==null)
- $this->setEmployees($this->withEmployees()->findByPk($this->TerritoryID)->getEmployees());
- return $this->_employees;
- }
-
- public function setEmployees($value)
- {
- //ensure TList
- $this->_employees = $value instanceof TList ? $value : new TList($value);
- }
-
- public static function finder($className=__CLASS__)
- {
- return parent::finder($className);
- }
-}
+<?php
+/**
+ * Auto generated by prado-cli.php on 2007-05-01 05:33:28.
+ */
+class Territory extends TActiveRecord
+{
+ const TABLE='Territories';
+
+ public $TerritoryID;
+ public $TerritoryDescription;
+ public $RegionID;
+
+ private $_region;
+ private $_employees;
+
+ public static $RELATIONS = array
+ (
+ 'Region' => array(self::BELONGS_TO, 'Region'),
+ 'Employees' => array(self::HAS_MANY, 'Employee', 'EmployeeTerritories')
+ );
+
+ /**
+ * @return Region
+ */
+ public function getRegion()
+ {
+ //lazy load the region
+ if($this->_region===null)
+ $this->_region = Region::finder()->findByPk($this->RegionID);
+ return $this->_region;
+ }
+
+ public function setRegion($value)
+ {
+ $this->_region=$value;
+ }
+
+ /**
+ * @return Employee[]
+ */
+ public function getEmployees()
+ {
+ //lazy load
+ if($this->_employees==null)
+ $this->setEmployees($this->withEmployees()->findByPk($this->TerritoryID)->getEmployees());
+ return $this->_employees;
+ }
+
+ public function setEmployees($value)
+ {
+ //ensure TList
+ $this->_employees = $value instanceof TList ? $value : new TList($value);
+ }
+
+ public static function finder($className=__CLASS__)
+ {
+ return parent::finder($className);
+ }
+}
?> \ No newline at end of file