Add northwind db demo.

10 files changed, 355 insertions, 0 deletions

diff --git a/demos/northwind-db/protected/database/Category.php b/demos/northwind-db/protected/database/Category.php
new file mode 100644
index 00000000..05fa7ed0
--- /dev/null
+++ b/demos/northwind-db/protected/database/Category.php
@@ -0,0 +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();

+

+	protected 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
new file mode 100644
index 00000000..356dd02f
--- /dev/null
+++ b/demos/northwind-db/protected/database/Customer.php
@@ -0,0 +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();

+

+	protected 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
new file mode 100644
index 00000000..7a678f57
--- /dev/null
+++ b/demos/northwind-db/protected/database/Employee.php
@@ -0,0 +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;

+

+	protected static $RELATIONS = array

+	(

+		'Territories' => array(self::HAS_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
new file mode 100644
index 00000000..fa865e61
--- /dev/null
+++ b/demos/northwind-db/protected/database/Order.php
@@ -0,0 +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;

+

+	protected 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
new file mode 100644
index 00000000..9415e33e
--- /dev/null
+++ b/demos/northwind-db/protected/database/OrderDetail.php
@@ -0,0 +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;

+

+	protected 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
new file mode 100644
index 00000000..75d01c02
--- /dev/null
+++ b/demos/northwind-db/protected/database/Product.php
@@ -0,0 +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();

+

+	protected 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
new file mode 100644
index 00000000..2afa3501
--- /dev/null
+++ b/demos/northwind-db/protected/database/Region.php
@@ -0,0 +1,24 @@
+<?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;

+

+	public $Territories=array();

+

+	protected 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
new file mode 100644
index 00000000..6ac8a929
--- /dev/null
+++ b/demos/northwind-db/protected/database/Shipper.php
@@ -0,0 +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();

+

+	protected 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
new file mode 100644
index 00000000..537daade
--- /dev/null
+++ b/demos/northwind-db/protected/database/Supplier.php
@@ -0,0 +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();

+

+	protected 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
new file mode 100644
index 00000000..4da0ff46
--- /dev/null
+++ b/demos/northwind-db/protected/database/Territory.php
@@ -0,0 +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;

+

+	protected 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