/**
* Class constructor
* Creates the page, the form and the listing
*/
public function __construct()
{
parent::__construct();
Usuario::checkLogin();
parent::setDatabase('sample');
// defines the database
parent::setActiveRecord('Usuario');
// defines the active record
parent::setDefaultOrder('id', 'asc');
// defines the default order
parent::setFilterField('login');
// defines the filter field
// creates the form, with a table inside
$this->form = new TForm('form_search_Usuario');
$table = new TTable();
$this->form->add($table);
// create the form fields
$filter = new TEntry('login');
$filter->setValue(TSession::getValue('Usuario_login'));
// add a row for the filter field
$table->addRowSet(new TLabel('login:'******'find');
$new_button = new TButton('new');
$find_button->setAction(new TAction(array($this, 'onSearch')), _t('Find'));
$new_button->setAction(new TAction(array('UsuarioForm', 'onEdit')), _t('New'));
$find_button->setImage('ico_find.png');
$new_button->setImage('ico_new.png');
// add a row for the form actions
$table->addRowSet($find_button, $new_button);
// define wich are the form fields
$this->form->setFields(array($filter, $find_button, $new_button));
// creates a DataGrid
$this->datagrid = new TQuickGrid();
$this->datagrid->setHeight(320);
// creates the datagrid columns
$id = $this->datagrid->addQuickColumn('id', 'id', 'right', 100);
$login = $this->datagrid->addQuickColumn('login', 'login', 'left', 200);
$senha = $this->datagrid->addQuickColumn('senha', 'senha', 'left', 200);
// create the datagrid actions
$edit_action = new TDataGridAction(array('UsuarioForm', 'onEdit'));
$delete_action = new TDataGridAction(array($this, 'onDelete'));
// add the actions to the datagrid
$this->datagrid->addQuickAction(_t('Edit'), $edit_action, 'id', 'ico_edit.png');
$this->datagrid->addQuickAction(_t('Delete'), $delete_action, 'id', 'ico_delete.png');
// create the datagrid model
$this->datagrid->createModel();
// create the page navigation
$this->pageNavigation = new TPageNavigation();
$this->pageNavigation->setAction(new TAction(array($this, 'onReload')));
$this->pageNavigation->setWidth($this->datagrid->getWidth());
// create the page container
$container = new TVBox();
$container->add($this->form);
$container->add($this->datagrid);
$container->add($this->pageNavigation);
parent::add($container);
}
/**
* Class constructor
* Creates the page, the form and the listing
*/
public function __construct()
{
parent::__construct();
Usuario::checkLogin();
parent::setDatabase('sample');
// defines the database
parent::setActiveRecord('Pedidos');
// defines the active record
parent::setDefaultOrder('id', 'asc');
// defines the default order
parent::setFilterField('id');
// defines the filter field
// creates the form, with a table inside
$this->form = new TForm('form_search_Pedidos');
$table = new TTable();
$this->form->add($table);
// create the form fields
$filter = new TEntry('id');
$filter->setValue(TSession::getValue('Pedidos_id'));
// add a row for the filter field
$table->addRowSet(new TLabel('id:'), $filter);
// create two action buttons to the form
$find_button = new TButton('find');
$find_button->setAction(new TAction(array($this, 'onSearch')), _t('Find'));
$find_button->setImage('ico_find.png');
// add a row for the form actions
$table->addRowSet($find_button);
// define wich are the form fields
$this->form->setFields(array($filter, $find_button));
// creates a DataGrid
$this->datagrid = new TQuickGrid();
$this->datagrid->setHeight(320);
// creates the datagrid columns
$id = $this->datagrid->addQuickColumn('id', 'id', 'right', 100);
$dataP = $this->datagrid->addQuickColumn('dataP', 'dataP', 'left', 100);
$clientes_id = $this->datagrid->addQuickColumn('cliente', 'clientes->nome', 'right', 100);
$status = $this->datagrid->addQuickColumn('status', 'status', 'right', 100);
// create the datagrid actions
$itens_action = new TDataGridAction(array($this, 'showItens'));
// add the actions to the datagrid
$this->datagrid->addQuickAction("Produtos", $itens_action, 'id', 'ico_find.png');
// create the datagrid model
$this->datagrid->createModel();
// create the page navigation
$this->pageNavigation = new TPageNavigation();
$this->pageNavigation->setAction(new TAction(array($this, 'onReload')));
$this->pageNavigation->setWidth($this->datagrid->getWidth());
// create the page container
$container = new TVBox();
$container->add($this->form);
$container->add($this->datagrid);
$container->add($this->pageNavigation);
parent::add($container);
}
/**
* Class constructor
* Creates the page, the form and the listing
*/
public function __construct()
{
parent::__construct();
parent::setDatabase('samples');
// defines the database
parent::setActiveRecord('City');
// defines the active record
parent::setFilterField('name');
// define the filter field
parent::setDefaultOrder('id', 'asc');
// define the default order
// creates the form
$this->form = new TQuickForm('form_search_City');
$this->form->setFormTitle('Standard datagrid');
$this->form->class = 'tform';
$this->form->style = 'width: 500px';
$name = new TEntry('name');
$this->form->addQuickField('Name:', $name, 200);
$this->form->addQuickAction('Find', new TAction(array($this, 'onSearch')), 'ico_find.png');
$this->form->addQuickAction('New', new TAction(array('StandardFormView', 'onEdit')), 'ico_new.png');
// keep the form filled with the search data
$this->form->setData(TSession::getValue('City_filter_data'));
// creates the DataGrid
$this->datagrid = new TQuickGrid();
$this->datagrid->setHeight(230);
// creates the datagrid columns
$this->datagrid->addQuickColumn('id', 'id', 'right', 40, new TAction(array($this, 'onReload')), array('order', 'id'));
$name = $this->datagrid->addQuickColumn('name', 'name', 'left', 400, new TAction(array($this, 'onReload')), array('order', 'name'));
// creates two datagrid actions
$this->datagrid->addQuickAction('Edit', new TDataGridAction(array('StandardFormView', 'onEdit')), 'id', 'ico_edit.png');
$this->datagrid->addQuickAction('Delete', new TDataGridAction(array($this, 'onDelete')), 'id', 'ico_delete.png');
// turn on inline editing
$editaction = new TDataGridAction(array($this, 'onInlineEdit'));
$editaction->setField('id');
$name->setEditAction($editaction);
// create the datagrid model
$this->datagrid->createModel();
// creates the page navigation
$this->pageNavigation = new TPageNavigation();
$this->pageNavigation->setAction(new TAction(array($this, 'onReload')));
$this->pageNavigation->setWidth($this->datagrid->getWidth());
// creates the page structure using a table
$table = new TTable();
$table->addRow()->addCell(new TXMLBreadCrumb('menu.xml', __CLASS__));
$table->addRow()->addCell($this->form);
$table->addRow()->addCell($this->datagrid);
$table->addRow()->addCell($this->pageNavigation);
// add the table inside the page
parent::add($table);
}
/**
* Class constructor
* Creates the page, and the listing
*/
public function __construct()
{
parent::__construct();
// security check
if (TSession::getValue('logged') !== TRUE) {
throw new Exception(_t('Not logged'));
}
// security check
TTransaction::open('changeman');
if (Member::newFromLogin(TSession::getValue('login'))->role_mnemonic !== 'ADMINISTRATOR') {
throw new Exception(_t('Permission denied'));
}
TTransaction::close();
// defines the database
parent::setDatabase('changeman');
// defines the active record
parent::setActiveRecord('Role');
// defines the filter field
parent::setFilterField('description');
// creates a DataGrid
$this->datagrid = new TQuickGrid();
$this->datagrid->setHeight(320);
// creates the datagrid columns
$this->datagrid->addQuickColumn('ID', 'id', 'right', 100, new TAction(array($this, 'onReload')), array('order', 'id'));
$this->datagrid->addQuickColumn(_t('Description'), 'description', 'left', 200, new TAction(array($this, 'onReload')), array('order', 'description'));
$this->datagrid->addQuickColumn(_t('Mnemonic'), 'mnemonic', 'left', 200, new TAction(array($this, 'onReload')), array('order', 'mnemonic'));
// create the datagrid model
$this->datagrid->createModel();
// creates the page navigation
$this->pageNavigation = new TPageNavigation();
$this->pageNavigation->setAction(new TAction(array($this, 'onReload')));
$this->pageNavigation->setWidth($this->datagrid->getWidth());
// creates the page structure using a table
$table = new TTable();
// add a row to the datagrid
$row = $table->addRow();
$row->addCell($this->datagrid);
// add a row for page navigation
$row = $table->addRow();
$row->addCell($this->pageNavigation);
// add the table inside the page
parent::add($table);
}
/**
* Class constructor
* Creates the page, the form and the listing
*/
public function __construct()
{
parent::__construct();
// security check
if (TSession::getValue('logged') !== TRUE) {
throw new Exception(_t('Not logged'));
}
// security check
TTransaction::open('library');
if (User::newFromLogin(TSession::getValue('login'))->role->mnemonic !== 'LIBRARIAN') {
throw new Exception(_t('Permission denied'));
}
TTransaction::close();
// defines the database
parent::setDatabase('library');
// defines the active record
parent::setActiveRecord('Publisher');
// defines the filter field
parent::setFilterField('name');
// creates the form
$this->form = new TForm('form_search_Publisher');
$this->form->class = 'tform';
$this->form->style = 'width: 600px';
$table = new TTable();
$table->width = '100%';
$this->form->add($table);
$table->addRowSet(new TLabel(_t('Publishers')), '')->class = 'tformtitle';
// create the form fields
$filter = new TEntry('name');
$filter->setValue(TSession::getValue('Publisher_name'));
// add a row for the filter field
$row = $table->addRow();
$row->addCell(new TLabel(_t('Name') . ': '));
$row->addCell($filter);
// create two action buttons to the form
$find_button = new TButton('find');
$new_button = new TButton('new');
// define the button actions
$find_button->setAction(new TAction(array($this, 'onSearch')), _t('Find'));
$find_button->setImage('ico_find.png');
$new_button->setAction(new TAction(array('PublisherForm', 'onEdit')), _t('New'));
$new_button->setImage('ico_new.png');
$buttons = new THBox();
$buttons->add($find_button);
$buttons->add($new_button);
$row = $table->addRow();
$row->class = 'tformaction';
$cell = $row->addCell($buttons);
$cell->colspan = 2;
// define wich are the form fields
$this->form->setFields(array($filter, $find_button, $new_button));
// creates a DataGrid
$this->datagrid = new TQuickGrid();
$this->datagrid->setHeight(320);
// creates the datagrid columns
$this->datagrid->addQuickColumn('id', 'id', 'right', 100, new TAction(array($this, 'onReload')), array('order', 'id'));
$this->datagrid->addQuickColumn('name', 'name', 'left', 440, new TAction(array($this, 'onReload')), array('order', 'name'));
// add the actions to the datagrid
$this->datagrid->addQuickAction(_t('Edit'), new TDataGridAction(array('PublisherForm', 'onEdit')), 'id', 'ico_edit.png');
$this->datagrid->addQuickAction(_t('Delete'), new TDataGridAction(array($this, 'onDelete')), 'id', 'ico_delete.png');
// create the datagrid model
$this->datagrid->createModel();
// creates the page navigation
$this->pageNavigation = new TPageNavigation();
$this->pageNavigation->setAction(new TAction(array($this, 'onReload')));
$this->pageNavigation->setWidth($this->datagrid->getWidth());
// creates the page structure using a vbox
$container = new TVBox();
$container->add($this->form);
$container->add($this->datagrid);
$container->add($this->pageNavigation);
// add the vbox inside the page
parent::add($container);
}
/**
* Class constructor
* Creates the page, the form and the listing
*/
public function __construct()
{
parent::__construct();
// security check
if (TSession::getValue('logged') !== TRUE) {
throw new Exception(_t('Not logged'));
}
// security check
TTransaction::open('library');
if (User::newFromLogin(TSession::getValue('login'))->role->mnemonic !== 'ADMINISTRATOR') {
throw new Exception(_t('Permission denied'));
}
TTransaction::close();
// defines the database
parent::setDatabase('library');
// defines the active record
parent::setActiveRecord('User');
// defines the filter field
parent::setFilterField('Login');
// creates the form
$this->form = new TForm('form_search_User');
// creates a table
$table = new TTable();
// add the table inside the form
$this->form->add($table);
// create the form fields
$filter = new TEntry('login');
$filter->setValue(TSession::getValue('User_login'));
// add a row for the filter field
$row = $table->addRow();
$row->addCell(new TLabel('login:'******'find');
$new_button = new TButton('new');
// define the button actions
$find_button->setAction(new TAction(array($this, 'onSearch')), _t('Find'));
$find_button->setImage('ico_find.png');
$new_button->setAction(new TAction(array('UserForm', 'onEdit')), _t('New'));
$new_button->setImage('ico_new.png');
// add a row for the form actions
$row = $table->addRow();
$row->addCell($find_button);
$row->addCell($new_button);
// define wich are the form fields
$this->form->setFields(array($filter, $find_button, $new_button));
// creates a DataGrid
$this->datagrid = new TQuickGrid();
$this->datagrid->setHeight(320);
// creates the datagrid columns
$this->datagrid->addQuickColumn('id', 'id', 'right', 100, new TAction(array($this, 'onReload')), array('order', 'id'));
$this->datagrid->addQuickColumn('login', 'login', 'left', 100, new TAction(array($this, 'onReload')), array('order', 'login'));
$this->datagrid->addQuickColumn('name', 'name', 'left', 300, new TAction(array($this, 'onReload')), array('order', 'name'));
// add the actions to the datagrid
$this->datagrid->addQuickAction(_t('Edit'), new TDataGridAction(array('UserForm', 'onEdit')), 'id', 'ico_edit.png');
$this->datagrid->addQuickAction(_t('Delete'), new TDataGridAction(array($this, 'onDelete')), 'id', 'ico_delete.png');
// create the datagrid model
$this->datagrid->createModel();
// creates the page navigation
$this->pageNavigation = new TPageNavigation();
$this->pageNavigation->setAction(new TAction(array($this, 'onReload')));
$this->pageNavigation->setWidth($this->datagrid->getWidth());
// creates the page structure using a table
$table = new TTable();
// add a row to the form
$row = $table->addRow();
$row->addCell($this->form);
// add a row to the datagrid
$row = $table->addRow();
$row->addCell($this->datagrid);
// add a row for page navigation
$row = $table->addRow();
$row->addCell($this->pageNavigation);
// add the table inside the page
parent::add($table);
}
/**
* Class constructor
* Creates the page, the form and the listing
*/
public function __construct()
{
parent::__construct();
parent::setDatabase('blog');
// defines the database
parent::setActiveRecord('Post');
// defines the active record
parent::setFilterField('title');
// defines the filter field
parent::setDefaultOrder('id', 'desc');
// creates the form
$this->form = new TForm('form_search_Post');
$this->form->class = 'tform';
// creates a table
$table = new TTable();
$table->width = '100%';
// add the table inside the form
$this->form->add($table);
$table->addRowSet(new TLabel(_t('Posts')), '')->class = 'tformtitle';
// create the form fields
$filter = new TEntry('title');
$filter->setValue(TSession::getValue('Post_title'));
// add a row for the filter field
$row = $table->addRow();
$row->addCell(new TLabel('title:'));
$row->addCell($filter);
// create two action buttons to the form
$find_button = new TButton('find');
$new_button = new TButton('new');
// define the button actions
$find_button->setAction(new TAction(array($this, 'onSearch')), _t('Find'));
$find_button->setImage('ico_find.png');
$new_button->setAction(new TAction(array('PostForm', 'onEdit')), _t('New'));
$new_button->setImage('ico_new.png');
$buttons = new THBox();
$buttons->add($find_button);
$buttons->add($new_button);
$row = $table->addRow();
$row->class = 'tformaction';
$cell = $row->addCell($buttons);
$cell->colspan = 2;
// define wich are the form fields
$this->form->setFields(array($filter, $find_button, $new_button));
// creates a DataGrid
$this->datagrid = new TQuickGrid();
$this->datagrid->setHeight(320);
// creates the datagrid columns
$id = $this->datagrid->addQuickColumn('ID', 'id', 'left', 40);
$title = $this->datagrid->addQuickColumn(_t('Title'), 'title', 'left', 300);
$category_name = $this->datagrid->addQuickColumn(_t('Category'), 'category_name', 'left', 200);
// add the actions to the datagrid
$this->datagrid->addQuickAction(_t('Edit'), new TDataGridAction(array('PostForm', 'onEdit')), 'id', 'ico_edit.png');
$this->datagrid->addQuickAction(_t('Delete'), new TDataGridAction(array($this, 'onDelete')), 'id', 'ico_delete.png');
// create the datagrid model
$this->datagrid->createModel();
// creates the page navigation
$this->pageNavigation = new TPageNavigation();
$this->pageNavigation->setAction(new TAction(array($this, 'onReload')));
$this->pageNavigation->setWidth($this->datagrid->getWidth());
// creates the page structure using a table
$table = new TTable();
$table->addRow()->addCell($this->form);
$table->addRow()->addCell($this->datagrid);
$table->addRow()->addCell($this->pageNavigation);
// add the table inside the page
parent::add($table);
}
/**
* Class constructor
* Creates the page, the form and the listing
*/
public function __construct()
{
parent::__construct();
// defines the database
parent::setDatabase('samples');
// defines the active record
parent::setActiveRecord('Project');
// defines the filter field
parent::setFilterField('name');
// creates the form
$this->form = new TForm('form_search_Project');
// creates a table
$table = new TTable();
// add the table inside the form
$this->form->add($table);
// create the form fields
$filter = new TEntry('name');
$filter->setValue(TSession::getValue('Project_name'));
// add a row for the filter field
$table->addRowSet(new TLabel('name:'), $filter);
// create two action buttons to the form
$find_button = new TButton('find');
$new_button = new TButton('new');
$find_button->setAction(new TAction(array($this, 'onSearch')), _t('Find'));
$find_button->setImage('ico_find.png');
$new_button->setAction(new TAction(array('ProjectFormView', 'onEdit')), _t('New'));
$new_button->setImage('ico_new.png');
// add a row for the form actions
$table->addRowSet($find_button, $new_button);
// define wich are the form fields
$this->form->setFields(array($filter, $find_button, $new_button));
// creates a DataGrid
$this->datagrid = new TQuickGrid();
$this->datagrid->setHeight(320);
// creates the datagrid columns
$id = $this->datagrid->addQuickColumn('ID', 'id', 'left', 50);
$name = $this->datagrid->addQuickColumn('Name', 'name', 'left', 190);
$start = $this->datagrid->addQuickColumn('Start', 'start_date', 'left', 80);
$end = $this->datagrid->addQuickColumn('End', 'end_date', 'left', 80);
$customer = $this->datagrid->addQuickColumn('customer', 'customer', 'left', 100);
// add the actions to the datagrid
$this->datagrid->addQuickAction(_t('Edit'), new TDataGridAction(array('ProjectFormView', 'onEdit')), 'id', 'ico_edit.png');
$this->datagrid->addQuickAction(_t('Delete'), new TDataGridAction(array($this, 'onDelete')), 'id', 'ico_delete.png');
$this->datagrid->addQuickAction(_t('Detail'), new TDataGridAction(array('BacklogFormView', 'onSetProject')), 'id');
// create the datagrid model
$this->datagrid->createModel();
// creates the page navigation
$this->pageNavigation = new TPageNavigation();
$this->pageNavigation->setAction(new TAction(array($this, 'onReload')));
$this->pageNavigation->setWidth($this->datagrid->getWidth());
// pack the elements using a vertical box
$vbox = new TVBox();
$vbox->add(new TXMLBreadCrumb('menu.xml', __CLASS__));
$vbox->add($this->form);
$vbox->add($this->datagrid);
$vbox->add($this->pageNavigation);
// add the box inside the page
parent::add($vbox);
}