class Model_Product extends Model_Table {
    public $table='product';
    function init(){
        parent::init();
        
        $this->addField('name');
        $this->addField('price')->type('money');

        // Automatically create SQL table if not exists
        $this->add('dynamic_model/Controller_AutoCreator');
    }
}

  

class Model_Purchase extends Model_Table {
    public $table='purchase';
    function init(){
        parent::init();
        
        $this->addField('date')->type('date');
        $this->hasOne('Product');
        $this->addField('qty')->type('int');

        // Automatically create SQL table if not exists
        $this->add('dynamic_model/Controller_AutoCreator');
    }
}

  

$crud=$page->add('CRUD');
$crud->setModel('Product');
if($crud->grid) {
$crud->grid->addButton('Refresh')->js('click',$crud->grid->js()->reload());
}

  

$crud=$page->add('CRUD');
$crud->setModel('Purchase');
if($crud->grid) {
$crud->grid->addButton('Refresh')->js('click',$crud->grid->js()->reload());
}

  

class Model_Purchase_Adding extends Model_Purchase {
  function init(){
    parent::init();

    $pr = $this->leftJoin('product');
    $pr->addField('price')->editable(false); // go edit in Product CRUD

    $this->addExpression('cost')->set('qty * price');
  }
}
$crud=$page->add('CRUD');
$crud->setModel('Purchase_Adding');
if($crud->grid) {
$crud->grid->addButton('Refresh')->js('click',$crud->grid->js()->reload());
}