Exemplo n.º 1
0
 public function joinsAction()
 {
     $grid = $this->grid();
     $select = $this->_db->select()->from(array('c' => 'Country'), array('country' => 'Name', 'Code', 'Continent', 'Population', 'GovernmentForm', 'HeadOfState'))->join(array('ct' => 'City'), 'c.Capital = ct.ID', array('city' => 'Name'));
     $grid->query($select);
     $form = new Bvb_Grid_Form();
     $form->setAdd(1)->setEdit(1)->setDelete(1)->setAddButton(1);
     $form->setFieldsBasedOnQuery(true);
     $grid->setForm($form);
     $this->view->pages = $grid->deploy();
     $this->render('index');
 }