Example for Introduction to Models

Below is a full example as described on the Introduction to Models" page of "Learning Agile Toolkit" book

lib/Model/Item.php
CommentLinkCopy
class Model_Item extends Model_Table {
  public $table='item';
  function init(){
    parent::init();

    $this->addfield('price');
    $this->addfield('name');
    
    $cat = $this->leftJoin('category');
    $cat->addField('category_name','name');


    $this->hasMany('Order');
    $this->hasMany('Order_Completed');

    $this->addExpression('successful_orders')
      ->set($this->refSQL('Order_Completed')
      ->sum('amount'));
  }
}
lib/Model/Item/Discounted.php
CommentLinkCopy
class Model_Item_Discounted extends Model_Item {
  function init(){
    parent::init();

    $this->addField('has_discount')->type('boolean');
    $this->addCondition('has_discount',true);
  }
}
lib/Model/Order.php
CommentLinkCopy
class Model_Order extends Model_Table {
  public $table='order';
  function init(){
    parent::init();

    $this->hasOne('Item');
    $this->addField('amount')->type('int');
    $this->addField('is_completed')->type('boolean');
  }
}
lib/Model/Order/Completed.php
CommentLinkCopy
class Model_Order_Completed extends Model_Order {
  function init(){
    parent::init();

    $this->addCondition('is_completed',true);
  }
}

Direct use of objects

The following object demostrates some of the presentation code. It manipulates existing model values without significantly changing the business logic.

Sample 1
CommentLinkCopy
$item = $page->add('Model_Item');

$item->tryLoadAny();

$item['price'] = 14.99;
$item['name'] = 'Mouse Pad '.rand(1,100);

$item->save();

Integration with Views

The real power of Agile Toolkit begins when you integrate models with Views.

Sample 2
CommentLinkCopy
$grid=$page->add('Grid');
$grid->setModel('Item');

$form = $page->add('Form');
$form->setModel('Order_Completed');
$form->addSubmit();
if($form->isSubmitted()){
  $form->update();
  $form->js(null,$page->js()->reload())->univ()->successMessage('Order added')->execute();
}
Clean Up Orders
CommentLinkCopy
$page->add('Model_Order')->deleteAll();
Disqus