Client.php 2.14 KB
Newer Older
zYne's avatar
zYne committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62
<?php
class ClientModel extends Doctrine_Record
{
	public function setTableDefinition() 
    {
		$this->setTableName('clients');

		$this->hasColumn('id', 'integer', 4, array('notnull' => true,
	                                           'primary' => true,
	                                           'autoincrement' => true,
	                                           'unsigned' => true));
		$this->hasColumn('short_name', 'string', 32, array('notnull' => true, 'notblank', 'unique' => true));
	}

	public function setUp() 
    {
		$this->hasMany('AddressModel', array('local' => 'client_id', 'foreign' => 'address_id', 'refClass' => 'ClientToAddressModel'));
	}
}

class ClientToAddressModel extends Doctrine_Record 
{
	public function setTableDefinition() 
    {
		$this->setTableName('clients_to_addresses');

		$this->hasColumn('client_id', 'integer', 11, array('primary' => true));
		$this->hasColumn('address_id', 'integer', 11, array('primary' => true));
	}

	public function construct()
    {
	}

	public function setUp() 
    {
    	$this->hasOne('ClientModel', array('local' => 'client_id', 'foreign' => 'id', 'onDelete' => 'CASCADE'));
    	$this->hasOne('AddressModel', array('local' => 'address_id', 'foreign' => 'id', 'onDelete' => 'CASCADE'));
	}
}

class AddressModel extends Doctrine_Record 
{
	public function setTableDefinition() 
    {
		$this->setTableName('addresses');

		$this->hasColumn('id', 'integer', 11, array('autoincrement' => true,
													'primary'       => true
													));
		$this->hasColumn('address1', 'string', 255, array('notnull' => true, 'notblank'));
		$this->hasColumn('address2', 'string', 255, array('notnull' => true));
		$this->hasColumn('city', 'string', 255, array('notnull' => true, 'notblank'));
		$this->hasColumn('state', 'string', 10, array('notnull' => true, 'notblank', 'usstate'));
		$this->hasColumn('zip', 'string', 15, array('notnull' => true, 'notblank', 'regexp' => '/^[0-9-]*$/'));
	}

	public function setUp() 
    {
		$this->hasMany('ClientModel', array('local' => 'address_id', 'foreign' => 'client_id', 'refClass' => 'ClientToAddressModel'));
	}
}