public function __construct()
{
parent::__construct();
// create the notebook
$notebook = new TNotebook(400, 280);
parent::add($notebook);
// creates the notebook page
$this->table = new TTable();
// adds the notebook page
$notebook->appendPage('Reusable view', $this->table);
// create the form fields
$fields[] = new TEntry('field1');
$fields[] = $date = new TDate('field2');
$fields[] = $text = new TText('field3');
$fields[] = $combo = new TCombo('field4');
$fields[] = new TPassword('field5');
$date->setSize(100);
$text->setSize(200, 100);
$combo->addItems(array('1' => 'One', '2' => 'Two'));
for ($n = 0; $n < 5; $n++) {
// add a row for one field
$row = $this->table->addRow();
$row->addCell(new TLabel('Field ' . ($n + 1)));
$row->addCell($fields[$n]);
}
// define wich are the form fields
parent::setFields($fields);
}
/**
* Class constructor
* Creates the page
*/
function __construct()
{
parent::__construct();
// creates a table
$table = new TTable();
// creates a label with the title
$title = new TLabel('Table Multi Cell');
$title->setFontSize(18);
$title->setFontFace('Arial');
$title->setFontColor('red');
// adds a row to the table
$row = $table->addRow();
$title = $row->addCell($title);
$title->colspan = 2;
// creates a series of input widgets
$id = new TEntry('id');
$name = new TEntry('name');
$min = new TEntry('min');
$max = new TEntry('max');
$start_date = new TDate('start_date');
$end_date = new TDate('end_date');
$address = new TEntry('address');
// adjust the size of the code
$id->setSize(70);
$start_date->setSize(70);
$end_date->setSize(70);
$min->setSize(87);
$max->setSize(87);
// add rows for the fields
$table->addRowSet(new TLabel('Code'), $id);
$table->addRowSet(new TLabel('Name'), $name);
// first approach
$table->addRowSet(new TLabel('Value'), array($min, new TLabel('To'), $max));
// second approach
$row = $table->addRow();
$row->addCell(new TLabel('Date'));
$row->addMultiCell($start_date, $end_date);
$table->addRowSet(new TLabel('Address'), $address);
// wrap the page content using vertical box
$vbox = new TVBox();
$vbox->add(new TXMLBreadCrumb('menu.xml', __CLASS__));
$vbox->add($table);
parent::add($vbox);
}
/**
* Class constructor
* Creates the page
*/
function __construct()
{
parent::__construct();
// create the form using TQuickForm class
$this->form = new TQuickForm();
$this->form->class = 'tform';
$this->form->setFormTitle('Quick form');
// create the form fields
$id = new TEntry('id');
$description = new TEntry('description');
$date1 = new TDate('date1');
$date2 = new TDate('date2');
$color = new TColor('color');
$list = new TCombo('list');
$text = new TText('text');
$combo_items = array();
$combo_items['a'] = 'Item a';
$combo_items['b'] = 'Item b';
$combo_items['c'] = 'Item c';
$list->addItems($combo_items);
$date1->setSize(100);
$date2->setSize(100);
// add the fields inside the form
$this->form->addQuickField('Id', $id, 40);
$this->form->addQuickField('Description', $description, 280);
$this->form->addQuickFields('Date', array($date1, new TLabel('to'), $date2));
$this->form->addQuickField('Color', $color, 100);
$this->form->addQuickField('List', $list, 120);
$row = $this->form->addRow();
$row->class = 'tformsection';
$row->addCell(new TLabel('Division'))->colspan = 2;
$this->form->addQuickField('Text', $text, 120);
$text->setSize(400, 50);
// define the form action
$this->form->addQuickAction('Save', new TAction(array($this, 'onSave')), 'ico_save.png');
// wrap the page content using vertical box
$vbox = new TVBox();
$vbox->add(new TXMLBreadCrumb('menu.xml', __CLASS__));
$vbox->add($this->form);
parent::add($vbox);
}
/**
* Class constructor
* Creates the page and the registration form
*/
function __construct()
{
parent::__construct();
// creates the form
$this->form = new TForm('form_RegistroLogin_report');
$this->form->class = 'tform';
// CSS class
$this->form->style = 'width: 500px';
// creates the table container
$table = new TTable();
$table->width = '100%';
// add the table inside the form
$this->form->add($table);
// define the form title
$row = $table->addRow();
$row->class = 'tformtitle';
// CSS class
$row->addCell(new TLabel('Registro de acessos ao sistema'))->colspan = 2;
// create the form fields
//$name = new TEntry('name');
$name = new TDBCombo('login', 'atividade', 'SystemUser', 'login', 'name');
$data_ponto = new TDate('data_ponto');
$data_ponto->setMask('dd/mm/yyyy');
$output_type = new TRadioGroup('output_type');
// define the sizes
$data_ponto->setSize(100);
$output_type->setSize(100);
// add one row for each form field
$table->addRowSet(new TLabel('Nome:'), $name);
$table->addRowSet(new TLabel('Data:'), $data_ponto);
$table->addRowSet(new TLabel('Saida:'), $output_type);
$this->form->setFields(array($name, $data_ponto, $output_type));
$output_type->addItems(array('html' => 'HTML', 'pdf' => 'PDF', 'rtf' => 'RTF'));
$output_type->setValue('html');
$output_type->setLayout('horizontal');
$generate_button = TButton::create('generate', array($this, 'onGenerate'), _t('Generate'), 'fa:check-circle-o green');
$this->form->addField($generate_button);
// add a row for the form action
$table->addRowSet($generate_button, '')->class = 'tformaction';
parent::add($this->form);
}
/**
* Class constructor
* Creates the page and the registration form
*/
function __construct()
{
parent::__construct();
// creates the form
$this->form = new TForm('form_crm');
// creates a table
// $table = new TTable;
$panel = new TPanel(100, 10);
// add the notebook inside the form
$this->form->add($panel);
$panel->put(new TLabel('CRM Titulo:'), 0, 0);
// $notebook->appendPage('Cidade', $table_contact);
// $notebook->appendPage('Skill (aggregation)', $table_skill);
// create the form fields
$code = new TEntry('id');
// $crm_id = new TDBCombo('crm_id', 'db_crmbf', 'CRM', 'id', 'titulo');
$crm_id = new TEntry('crm_nome');
$tiporegistro_id = new TDBCombo('tiporegistro_id', 'db_crmbf', 'RegistroTipo', 'id', 'nome');
$registro = new TText('registro');
$temporegistro = new TEntry('tempo_registro');
// $temporegistro->setEditable(false);
$dataregistro = new TDate('data_registro');
$hora_registro = new TEntry('hora_registro');
$numero_registro = new TEntry('numero_registro');
// add field validators
$registro->addValidation('Nome', new TRequiredValidator());
// $cidade_id->addValidation('Cidade', new TRequiredValidator);
// $birthdate->addValidation('Birthdate', new TRequiredValidator);
// $cidade_id->addValidation('Category', new TRequiredValidator);
//$obj = new CidadeFormList;
//$cidade_id->setAction(new TAction(array($obj, 'onReload')));
// $itemGender = array();
// $itemGender['M'] = 'Male';
// $itemGender['F'] = 'Female';
// // add the combo options
// $gender->addItems($itemGender);
// $gender->setLayout('horizontal');
//
// $itemStatus = array();
// $itemStatus['S'] = 'Single';
// $itemStatus['C'] = 'Committed';
// $itemStatus['M'] = 'Married';
// $status->addItems($itemStatus);
// define some properties for the form fields
$code->setEditable(FALSE);
$code->setSize(100);
$crm_id->setSize(320);
$registro->setSize(320);
$temporegistro->setSize(160);
//$temporegistro->setValue(date("d/m/Y H:i:s"));
$tiporegistro_id->setSize(160);
//$dataregistro->setRange(0,1000,1);
$dataregistro->setSize(90);
// $hora_registro->setRange(0,100,1);
$hora_registro->setSize(150);
$hora_registro->setTip('Horario EX: 8:14');
$numero_registro->setSize(320);
$panel->put("Codigo: ", 10, 25);
$panel->put("CRM: ", 10, 50);
$panel->put("Tipo: ", 10, 75);
$panel->put("Tempo: ", 10, 100);
$panel->put("Data: ", 10, 125);
$panel->put("Horario: ", 10, 150);
$panel->put("Nº Registro: ", 10, 175);
$panel->put("Registro: ", 10, 200);
$panel->put($code, 100, 25);
$panel->put($crm_id, 100, 50);
$panel->put($tiporegistro_id, 100, 75);
$panel->put($temporegistro, 100, 100);
$panel->put($dataregistro, 100, 125);
$panel->put($hora_registro, 100, 150);
$panel->put($numero_registro, 100, 175);
$panel->put($registro, 100, 200);
// $row = $table->addRow();
// $row->addCell(new TLabel('Code:'));
// $row->addCell($code);
//
// // add a row for the field name
// $row = $table->addRow();
// $row->addCell(new TLabel('CRM Titulo:'));
// $cell = $row->addCell($crm_id);
//
// // add a row for the field Telefone
// $row = $table->addRow();
// $row->addCell(new TLabel('Tipo Registro:'));
// $cell = $row->addCell($tiporegistro_id);
//
// // add a row for the field Email
// $row = $table->addRow();
// $row->addCell(new TLabel('Tempo:'));
// $cell = $row->addCell($temporegistro);
//
// // add a row for the field celular
// $row = $table->addRow();
// $row->addCell(new TLabel('Data:'));
// $cell = $row->addCell($dataregistro);
//
// // add a row for the field skype
// $row = $table->addRow();
// $row->addCell(new TLabel('Hora:'));
// $cell = $row->addCell($hora_registro);
//
// // add a row for the field endereco
// $row = $table->addRow();
// $row->addCell(new TLabel('Numero Registro:'));
// $row->addCell($numero_registro);
//
// // add a row for the field name
// $row = $table->addRow();
// $row->addCell(new TLabel('Registro:'));
// $cell = $row->addCell($registro);
// add a row for the field Category
// $row = $table_data->addRow();
// $row->addCell(new TLabel('Cidade:'));
// $cell = $row->addCell($cidade_id);
// add a row for the field city
// $row=$table_data->addRow();
// $row->addCell(new TLabel('Cidade:'));
// $cell = $row->addCell($cidade_id);
/*
// add a row for the field Phone
$row = $table_data->addRow();
$row->addCell(new TLabel('Phone:'));
$row->addCell($phone);
// add a row for the field BirthDate
$row->addCell(new TLabel('BirthDate:'));
$row->addCell($birthdate);
// add a row for the field status
$row = $table_data->addRow();
$row->addCell(new TLabel('Status:'));
$cell = $row->addCell($status);
// add a row for the field Email
$row->addCell(new TLabel('Email:'));
$cell = $row->addCell($email);
// add a row for the field gender
$row->addCell(new TLabel('Gender:'));
$row->addCell($gender);
$row = $table_contact->addRow();
$cell = $row->addCell(new TLabel('<b>Contact</b>'));
$cell->valign = 'top';
// add two fields inside the multifield in the second sheet
$contacts_list->setHeight(100);
$contacts_list->setClass('Contact'); // define the returning class
$contacts_list->addField('type', 'Contact Type: ', new TEntry('type'), 200);
$contacts_list->addField('value', 'Contact Value: ', new TEntry('value'), 200);
$row = $table_contact->addRow();
$row->addCell($contacts_list);
// create the radio button for the skills list
$skill_list = new TDBCheckGroup('skill_list', 'samples', 'Skill', 'id', 'name');
$table_skill->addRow()->addCell($lbl = new TLabel('Skills'));
$table_skill->addRow()->addCell($skill_list);
$lbl->setFontStyle('b');
*
*/
// create an action button
$button1 = new TButton('action1');
$button1->setAction(new TAction(array($this, 'onSave')), 'Save');
$button1->setImage('ico_save.png');
$button1->setProperty('width', 150);
// create an action button (go to list)
$button2 = new TButton('list');
$button2->setAction(new TAction(array('RegistroList', 'onReload')), 'Ir para Listagem');
$button2->setImage('ico_datagrid.gif');
$button2->setProperty('width', 100);
$panel->put($button1, 100, 325);
$panel->put($button2, 200, 325);
// define wich are the form fields
$this->form->setFields(array($code, $crm_id, $registro, $temporegistro, $tiporegistro_id, $dataregistro, $hora_registro, $numero_registro, $button1, $button2));
// $subtable = new TTable;
// $row = $subtable->addRow();
// $row->addCell($button1);
// $row->addCell($button2);
// $table_layout = new TTable;
// $table_layout->addRow()->addCell($this->form);
// $table_layout->addRow()->addCell($subtable);
// add the form inside the page
parent::add($panel);
// parent::add($table_layout);
}
/**
* Class constructor
* Creates the page, the form and the listing
*/
public function __construct()
{
parent::__construct();
// creates the form
$this->form = new TForm('form_search_RequisitoDesenvolvimento');
$this->form->class = 'tform';
// CSS class
// creates a table
$table = new TTable();
$table->width = '100%';
$this->form->add($table);
// add a row for the form title
$row = $table->addRow();
$row->class = 'tformtitle';
// CSS class
$row->addCell(new TLabel('Cadastro de DRs'))->colspan = 2;
// create the form fields
$id = new TEntry('ticket_id');
$id->setMask('99999');
$titulo = new TEntry('titulo');
$data_cadastro = new TDate('data_cadastro');
$data_cadastro->setMask('dd/mm/yyyy');
// define the sizes
$id->setSize(50);
$titulo->setSize(200);
$data_cadastro->setSize(100);
// add one row for each form field
$table->addRowSet(new TLabel('Ticket:'), $id);
$table->addRowSet(new TLabel('Título:'), $titulo);
$table->addRowSet(new TLabel('Data:'), $data_cadastro);
$this->form->setFields(array($id, $titulo, $data_cadastro));
// keep the form filled during navigation with session data
$this->form->setData(TSession::getValue('RequisitoDesenvolvimento_filter_data'));
// create two action buttons to the form
$find_button = TButton::create('find', array($this, 'onSearch'), _t('Find'), 'ico_find.png');
$clean_button = TButton::create('clean', array($this, 'onClean'), 'Limpar', 'ico_close.png');
$this->form->addField($find_button);
$this->form->addField($clean_button);
$buttons_box = new THBox();
$buttons_box->add($find_button);
$buttons_box->add($clean_button);
// add a row for the form action
$row = $table->addRow();
$row->class = 'tformaction';
// CSS class
$row->addCell($buttons_box)->colspan = 2;
// creates a Datagrid
$this->datagrid = new TDataGrid();
$this->datagrid->setHeight(320);
// creates the datagrid columns
$id = new TDataGridColumn('ticket_id', 'ID', 'right', 20);
$data_cadastro = new TDataGridColumn('data_cadastro', 'Data', 'left', 80);
$titulo = new TDataGridColumn('titulo', 'Título', 'left', 300);
$ticket_id = new TDataGridColumn('ticket->titulo', 'Ticket', 'right', 300);
$data_cadastro->setTransformer(array('StringsUtil', 'formatDateBR'));
// add the columns to the DataGrid
$this->datagrid->addColumn($id);
$this->datagrid->addColumn($data_cadastro);
$this->datagrid->addColumn($titulo);
$this->datagrid->addColumn($ticket_id);
// creates the datagrid column actions
$order_id = new TAction(array($this, 'onReload'));
$order_id->setParameter('order', 'id');
$id->setAction($order_id);
$order_titulo = new TAction(array($this, 'onReload'));
$order_titulo->setParameter('order', 'titulo');
$titulo->setAction($order_titulo);
$order_data_cadastro = new TAction(array($this, 'onReload'));
$order_data_cadastro->setParameter('order', 'data_cadastro');
$data_cadastro->setAction($order_data_cadastro);
$order_ticket_id = new TAction(array($this, 'onReload'));
$order_ticket_id->setParameter('order', 'ticket->titulo');
$ticket_id->setAction($order_ticket_id);
// creates two datagrid actions
$action1 = new TDataGridAction(array('RequisitoDesenvolvimentoForm', 'onEdit'));
$action1->setLabel(_t('Edit'));
$action1->setImage('fa:pencil-square-o blue fa-lg');
$action1->setField('id');
$action2 = new TDataGridAction(array($this, 'onDelete'));
$action2->setLabel(_t('Delete'));
$action2->setImage('fa:trash-o red fa-lg');
$action2->setField('id');
// add the actions to the datagrid
$this->datagrid->addAction($action1);
$this->datagrid->addAction($action2);
// 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());
// create the page container
$container = TVBox::pack($this->form, $this->datagrid, $this->pageNavigation);
$container->style = 'width: 100%;max-width: 1200px;';
$this->datagrid->style = ' width: 100%; max-width: 1200px;';
parent::add($container);
}
/**
* Class constructor
* Creates the page and the registration form
*/
function __construct()
{
parent::__construct();
// creates the form
$this->form = new TForm('form_crm');
// creates a table
$table = new TTable();
$notebook = new TNotebook(500, 320);
// add the notebook inside the form
$this->form->add($notebook);
$notebook->appendPage('Cadastro Registro CRM', $table);
// create the form fields
$code = new TEntry('id');
$crm_id = new TCombo('crm_id');
$tiporegistro_id = new TDBCombo('tiporegistro_id', 'db_crmbf', 'RegistroTipo', 'id', 'nome');
$registro = new TText('registro');
$temporegistro = new TEntry('tempo_registro');
// $temporegistro->setEditable(false);
$dataregistro = new TDate('data_registro');
$hora_registro = new TEntry('hora_registro');
$numero_registro = new TEntry('numero_registro');
// finaliza a transacao
TTransaction::close();
$items1 = array();
//dados do cliente CRM
TTransaction::open('db_crmbf');
$criteria = new TCriteria();
$criteria->add(new TFilter('cliente_id', '=', $_GET['fk']));
$repository = new TRepository('CRM');
$cadastros = $repository->load($criteria);
//adiciona os objetos no combo
foreach ($cadastros as $object) {
$items1[$object->id] = $object->titulo;
}
// adiciona as opcoes na combo
$crm_id->addItems($items1);
TTransaction::close();
// add field validators
$registro->addValidation('Registro deve ser informado', new TRequiredValidator());
// define some properties for the form fields
$code->setEditable(FALSE);
$code->setSize(100);
$crm_id->setSize(320);
// $crm_id->setEditable(FALSE);
$registro->setSize(320);
$temporegistro->setSize(160);
$temporegistro->setValue(date("d/m/Y H:i:s"));
$tiporegistro_id->setSize(160);
$dataregistro->setSize(90);
$hora_registro->setSize(150);
$hora_registro->setTip('Horario EX: 8:14');
$numero_registro->setSize(320);
$row = $table->addRow();
$row->addCell(new TLabel('Code:'));
$row->addCell($code);
// add a row for the field name
$row = $table->addRow();
$row->addCell(new TLabel('CRM Titulo:'));
$cell = $row->addCell($crm_id);
// add a row for the field Telefone
$row = $table->addRow();
$row->addCell(new TLabel('Tipo Registro:'));
$cell = $row->addCell($tiporegistro_id);
// add a row for the field Email
$row = $table->addRow();
$row->addCell(new TLabel('Tempo:'));
$cell = $row->addCell($temporegistro);
// add a row for the field celular
$row = $table->addRow();
$row->addCell(new TLabel('Data:'));
$cell = $row->addCell($dataregistro);
// add a row for the field skype
$row = $table->addRow();
$row->addCell(new TLabel('Hora:'));
$cell = $row->addCell($hora_registro);
// add a row for the field endereco
$row = $table->addRow();
$row->addCell(new TLabel('Numero Registro:'));
$row->addCell($numero_registro);
// add a row for the field name
$row = $table->addRow();
$row->addCell(new TLabel('Registro:'));
$cell = $row->addCell($registro);
// create an action button
$button1 = new TButton('action1');
$button1->setAction(new TAction(array($this, 'onSave')), 'Save');
$button1->setImage('ico_save.png');
// create an action button
$button2 = new TButton('action3');
$action2 = new TAction(array('ClienteRegistroDetalhe', 'onEdit'));
//parametro fk e key da sessao
$action2->setParameter('fk', TSession::getValue('cliente_fk'));
$action2->setParameter('key', TSession::getValue('crm_key'));
$button2->setImage('ico_datagrid.png');
$button2->setAction($action2, 'Voltar');
// define wich are the form fields
$this->form->setFields(array($code, $crm_id, $registro, $temporegistro, $tiporegistro_id, $dataregistro, $hora_registro, $numero_registro, $button1, $button2));
$subtable = new TTable();
$row = $subtable->addRow();
$row->addCell($button1);
$row->addCell($button2);
$table_layout = new TTable();
$table_layout->addRow()->addCell($this->form);
$table_layout->addRow()->addCell($subtable);
// add the form inside the page
parent::add($table_layout);
}
/**
* Class constructor
* Creates the page and the registration form
*/
function __construct()
{
parent::__construct();
// creates the form
$this->form = new TForm('form_clienteRegistro Detalhe');
// creates a table
$table = new TTable();
$panel = new TPanel(480, 260);
$notebook = new TNotebook(500, 250);
// add the notebook inside the form
$this->form->add($notebook);
// add the notebook inside the form
$this->form->add($table);
// create the form fields
$city_id2 = new TSeekButton('city_id2');
$city_name2 = new TEntry('city_name2');
$city_id2->setSize(100);
$city_name2->setEditable(FALSE);
//dados do cliente CRM
TTransaction::open('db_crmbf');
$criteria = new TCriteria();
$criteria->add(new TFilter('cliente_id', '=', $_GET['key']));
//
$repository = new TRepository('CRM');
$CRM = $repository->load($criteria);
foreach ($CRM as $crms) {
$codigoCRM = $crms->id;
$tituloCRM = $crms->titulo;
$projetoCRM = $crms->projeto_nome;
$dataCRM = $crms->data_crm;
$tempoCRM = $crms->tempo;
$porcentagemCRM = $crms->porcentagem;
$descricaoCRM = $crms->descricao;
$solicitanteCRM = $crms->solicitante;
$usuarioalteracaoCRM = $crms->usuarioalteracao;
$responsavel_nomeCRM = $crms->responsavel_nome;
$tipo_nomeCRM = $crms->tipo_nome;
$cliente_nomeCRM = $crms->cliente_nome;
$prioridade_nomeCRM = $crms->prioridade_nome;
$status_nomeCRM = $crms->status_nome;
}
TTransaction::close();
$notebook->appendPage('Registros CRMs', $table);
$code = new TEntry('id');
$crm_id = new TDBCombo('crm_id', 'db_crmbf', 'CRM', 'id', 'titulo');
$tiporegistro_id = new TDBCombo('tiporegistro_id', 'db_crmbf', 'RegistroTipo', 'id', 'nome');
$registro = new TText('registro');
$temporegistro = new TEntry('tempo_registro');
// $temporegistro->setEditable(false);
$dataregistro = new TDate('data_registro');
$hora_registro = new TEntry('hora_registro');
$numero_registro = new TEntry('numero_registro');
// define some properties for the form fields
$code->setEditable(FALSE);
$code->setSize(100);
$crm_id->setSize(320);
$crm_id->setEditable(FALSE);
$registro->setSize(320);
$temporegistro->setSize(160);
//$temporegistro->setValue(date("d/m/Y H:i:s"));
$tiporegistro_id->setSize(160);
//$dataregistro->setRange(0,1000,1);
$dataregistro->setSize(90);
// $hora_registro->setRange(0,100,1);
$hora_registro->setSize(150);
$hora_registro->setTip('Horario EX: 8:14');
$numero_registro->setSize(320);
$row = $table->addRow();
$row->addCell(new TLabel('Code:'));
$row->addCell($code);
// add a row for the field name
$row = $table->addRow();
$row->addCell(new TLabel('CRM Titulo:'));
$cell = $row->addCell($crm_id);
// add a row for the field Telefone
$row = $table->addRow();
$row->addCell(new TLabel('Tipo Registro:'));
$cell = $row->addCell($tiporegistro_id);
// add a row for the field Email
$row = $table->addRow();
$row->addCell(new TLabel('Tempo:'));
$cell = $row->addCell($temporegistro);
// add a row for the field celular
$row = $table->addRow();
$row->addCell(new TLabel('Data:'));
$cell = $row->addCell($dataregistro);
// add a row for the field skype
$row = $table->addRow();
$row->addCell(new TLabel('Hora:'));
$cell = $row->addCell($hora_registro);
// add a row for the field endereco
$row = $table->addRow();
$row->addCell(new TLabel('Numero Registro:'));
$row->addCell($numero_registro);
// add a row for the field name
$row = $table->addRow();
$row->addCell(new TLabel('Registro:'));
$cell = $row->addCell($registro);
// $notebook->appendPage('Cidade', $table_contact);
// $notebook->appendPage('Skill (aggregation)', $table_skill);
// create the form fields
// $code = new TEntry('id');
// $nome = new TEntry('nome');
// $email = new TEntry('email');
// $telefone = new TEntry('telefone');
// $celular = new TEntry('celular');
// $skype = new TEntry('skype');
// $endereco = new TEntry('endereco');
//// $cidade_id = new TSeekButton('cidade_id');
// $cidade_id = new TDBCombo('cidade_id', 'db_crmbf', 'Cidade', 'id', 'nome');
// $birthdate = new TDate('birthdate');
// $email = new TEntry('email');
// $gender = new TRadioGroup('gender');
// $status = new TCombo('status');
// $contacts_list = new TMultiField('contacts_list');
// add field validators
// $nome->addValidation('Nome', new TRequiredValidator);
// $cidade_id->addValidation('Cidade', new TRequiredValidator);
// $birthdate->addValidation('Birthdate', new TRequiredValidator);
// $cidade_id->addValidation('Category', new TRequiredValidator);
//$obj = new CidadeFormList;
//$cidade_id->setAction(new TAction(array($obj, 'onReload')));
// $itemGender = array();
// $itemGender['M'] = 'Male';
// $itemGender['F'] = 'Female';
// // add the combo options
// $gender->addItems($itemGender);
// $gender->setLayout('horizontal');
//
// $itemStatus = array();
// $itemStatus['S'] = 'Single';
// $itemStatus['C'] = 'Committed';
// $itemStatus['M'] = 'Married';
// $status->addItems($itemStatus);
// define some properties for the form fields
// $code->setEditable(FALSE);
// $code->setSize(100);
// $nome->setSize(320);
// $email->setSize(160);
// $telefone->setSize(160);
// $celular->setSize(160);
// $skype->setSize(160);
// $endereco->setSize(320);
// $cidade_id->setSize(150);
//$cidade_id->setEditable(FALSE);
// add a row for the field code
$panel->put("CRM: ", $codigoCRM, 10, 5);
$panel->put($tituloCRM, 10, 20);
$panel->put($projetoCRM, 10, 40);
$panel->put("Data de Criação: " . $dataCRM, 10, 75);
$panel->put("Aberto por: " . $usuarioalteracaoCRM, 10, 95);
$panel->put("Cliente: " . $cliente_nomeCRM, 10, 55);
$panel->put("Responsavel: " . $responsavel_nomeCRM, 10, 110);
$panel->put("Tipo: " . $tipo_nomeCRM, 10, 130);
$panel->put("Percentual Conclusão: " . $porcentagemCRM, 10, 140);
$panel->put("Tempo Gasto: " . $tempoCRM, 10, 160);
$panel->put("Situação: " . $status_nomeCRM, 10, 180);
$panel->put("Descrição: " . $descricaoCRM, 10, 200);
// $row = $table->addRow();
// $row->addCell(new TLabel('Titulo:'));
// $row->addCell($tituloCRM);
//
// // add a row for the field name
// $row = $table->addRow();
// $row->addCell(new TLabel('Projeto:'));
// $cell = $row->addCell($projetoCRM);
// $cell->colspan = 3;
//
// // add a row for the field Email
// $row = $table->addRow();
// $row->addCell(new TLabel('DATA:'));
// $cell = $row->addCell($dataCRM);
// $cell->colspan = 3;
//
// // add a row for the field Telefone
// $row = $table->addRow();
// $row->addCell(new TLabel('Tempo:'));
// $cell = $row->addCell($tempoCRM);
// $cell->colspan = 3;
//
// // add a row for the field celular
// $row = $table->addRow();
// $row->addCell(new TLabel('Porcentagem:'));
// $cell = $row->addCell($porcentagemCRM);
//
// // add a row for the field skype
// $row = $table->addRow();
// $row->addCell(new TLabel('Solicitação:'));
// $cell = $row->addCell($solicitanteCRM);
// // add a row for the field endereco
// $row = $table_data->addRow();
// $row->addCell(new TLabel('Endereço:'));
// $row->addCell($endereco);
//
// // add a row for the field endereco
// $row = $table_data->addRow();
// $row->addCell(new TLabel('Cidade:'));
// $row->addCell($cidade_id);
// add a row for the field Category
// $row = $table_data->addRow();
// $row->addCell(new TLabel('Cidade:'));
// $cell = $row->addCell($cidade_id);
// add a row for the field city
// $row=$table_data->addRow();
// $row->addCell(new TLabel('Cidade:'));
// $cell = $row->addCell($cidade_id);
/*
// add a row for the field Phone
$row = $table_data->addRow();
$row->addCell(new TLabel('Phone:'));
$row->addCell($phone);
// add a row for the field BirthDate
$row->addCell(new TLabel('BirthDate:'));
$row->addCell($birthdate);
// add a row for the field status
$row = $table_data->addRow();
$row->addCell(new TLabel('Status:'));
$cell = $row->addCell($status);
// add a row for the field Email
$row->addCell(new TLabel('Email:'));
$cell = $row->addCell($email);
// add a row for the field gender
$row->addCell(new TLabel('Gender:'));
$row->addCell($gender);
$row = $table_contact->addRow();
$cell = $row->addCell(new TLabel('<b>Contact</b>'));
$cell->valign = 'top';
// add two fields inside the multifield in the second sheet
$contacts_list->setHeight(100);
$contacts_list->setClass('Contact'); // define the returning class
$contacts_list->addField('type', 'Contact Type: ', new TEntry('type'), 200);
$contacts_list->addField('value', 'Contact Value: ', new TEntry('value'), 200);
$row = $table_contact->addRow();
$row->addCell($contacts_list);
// create the radio button for the skills list
$skill_list = new TDBCheckGroup('skill_list', 'samples', 'Skill', 'id', 'name');
$table_skill->addRow()->addCell($lbl = new TLabel('Skills'));
$table_skill->addRow()->addCell($skill_list);
$lbl->setFontStyle('b');
*
*/
// create an action button
$button1 = new TButton('action1');
$button1->setAction(new TAction(array($this, 'onSave')), 'Save');
$button1->setImage('ico_save.png');
// create an action button (go to list)
$button2 = new TButton('list');
$button2->setAction(new TAction(array('ClienteList', 'onReload')), 'Ir para Listagem');
$button2->setImage('ico_datagrid.gif');
// create an action button
$button3 = new TButton('action3');
$action3 = new TAction(array('RegistroForm', 'onEdit'));
$action3->setParameter('fk', $codigoCRM);
$button3->setImage('ico_save.png');
$button3->setAction($action3, 'Inserir Registro');
// define wich are the form fields
$this->form->setFields(array($code, $crm_id, $registro, $temporegistro, $tiporegistro_id, $dataregistro, $hora_registro, $numero_registro, $button1, $button2, $button3));
$subtable = new TTable();
$row = $subtable->addRow();
$row->addCell($button1);
$row->addCell($button2);
$row->addCell($button3);
$table_layout = new TTable();
$table_layout->addRow()->addCell($this->form);
$table_layout->addRow()->addCell($subtable);
// // add a row for the field gender
// $row->addCell(new TLabel('Gender:'));
// $row->addCell($registroREG);
//
// // add a row for the field Category
// $row = $table->addRow();
// $row->addCell(new TLabel('Cidade:'));
// $cell = $row->addCell($registroREG);
// add the form inside the page
parent::add($panel);
parent::add($table_layout);
// creates the form
$this->form2 = new TForm('form_clienteRegistro Detalhe');
//dados do cliente CRM
TTransaction::open('db_crmbf');
$criteria2 = new TCriteria();
// $criteria->add(new TFilter('crm_id', '=', $_GET['key']));
$criteria2->setProperty('order', 'id desc');
$repository2 = new TRepository('Registro');
$reg = $repository2->load($criteria2);
foreach ($reg as $regs) {
$row = $table->addRow();
$row->addCell(new TLabel('ID:'));
$cell = $row->addCell($regs->id);
$row = $table->addRow();
$row->addCell(new TLabel('CRM:'));
$cell = $row->addCell($regs->crm_id);
$row = $table->addRow();
$row->addCell(new TLabel('CRM:'));
$cell = $row->addCell($regs->tiporegistro_id);
$row = $table->addRow();
$row->addCell(new TLabel('Tempo:'));
$cell = $row->addCell($regs->tempo_registro);
$row = $table->addRow();
$row->addCell(new TLabel('Data:'));
$cell = $row->addCell($regs->data_registro);
$row = $table->addRow();
$row->addCell(new TLabel('Horario:'));
$cell = $row->addCell($regs->hora_registro);
$row = $table->addRow();
$row->addCell(new TLabel('Numero Registro:'));
$cell = $row->addCell($regs->numero_registro);
$row = $table->addRow();
$row->addCell(new TLabel('Registro:'));
$cell = $row->addCell($regs->registro);
$row = $table->addRow();
$row->addCell(new TLabel(' '));
$cell = $row->addCell(' ');
// $idREG = $regs->id;
// $crm_idREG = $regs->crm_id;
// $tiporegistro_idREG = $regs->tiporegistro_id;
// $tempoREG = $regs->tempo_registro;
// $dataREG = $regs->data_registro;
// $horaREG = $regs->hora_registro;
// $numRegistroREG = $regs->numero_registro;
// $registroREG = $regs->registro;
}
TTransaction::close();
}
/**
* Class constructor
* Creates the page, the form and the listing
*/
public function __construct()
{
parent::__construct();
// creates the form
$this->form = new TForm('form_FreqServList');
$this->form->class = 'tform';
// creates a table
$table = new TTable();
$table->style = 'width:100%';
$table->addRowSet(new TLabel('Frequência'), '')->class = 'tformtitle';
// add the table inside the form
$this->form->add($table);
// create the form fields
//$id = new TEntry('ID');
//$id->setValue(TSession::getValue('Frequencia_id'));
$servidor_id = new TDBSeekButton('servidor_id', 'lacenrh', 'form_FreqServList', 'Servidor', 'servidor', 'servidor_id', 'servidor_nome');
$servidor_id->setValue(TSession::getValue('Frequencia_servidor_id'));
$servidor_nome = new TEntry('servidor_nome');
$servidor_nome->setValue(TSession::getValue('Frequencia_servidor_nome'));
$diames = new TDate('Data');
$diames->setValue(TSession::getValue('Frequencia_diames'));
//$id->setSize(40);
$servidor_id->setSize(40);
$servidor_nome->setSize(300);
$diames->setSize(100);
$diames->setMask('dd/mm/yyyy');
// add rows for the filter fields
//$row=$table->addRowSet(new TLabel(('ID') . ': '), $id);
$row = $table->addRowSet(new TLabel('Servidor' . ': '), $servidor_id);
$row = $table->addRowSet(new TLabel('Nome' . ': '), $servidor_nome);
$row = $table->addRowSet(new TLabel('Data' . ': '), $diames);
//$row=$table->addRowSet(new TLabel(('Unidade') . ': '), $unidade);
// create two action buttons to the form
$find_button = new TButton('find');
$clear_button = new Tbutton('clear');
$new_button = new TButton('new');
// define the button actions
$find_button->setAction(new TAction(array($this, 'onSearch')), _t('Find'));
$find_button->setImage('fa:search fa-lg');
$clear_button->setAction(new TAction(array($this, 'onClear')), 'Limpar');
$clear_button->setImage('fa:undo red fa-lg');
$new_button->setAction(new TAction(array('FrequenciaServidorForm', 'onEdit')), _t('New'));
$new_button->setImage('fa:plus-square green fa-lg');
// define wich are the form fields
$this->form->setFields(array($servidor_id, $servidor_nome, $diames, $find_button, $clear_button, $new_button));
$container = new THBox();
$container->add($find_button);
$container->add($clear_button);
$container->add($new_button);
$row = $table->addRow();
$row->class = 'tformaction';
$cell = $row->addCell($container);
$cell->colspan = 2;
// creates a DataGrid
$this->datagrid = new TDataGrid();
$this->datagrid->style = 'width: 100%';
$this->datagrid->setHeight(320);
// creates the datagrid columns
$servidor_nome = new TDataGridColumn('servidor_nome', 'Nome', 'left', 200);
$diames = new TDataGridColumn('diames', 'Data', 'center', 50);
$entrada = new TDataGridColumn('entrada', 'Entrada', 'center', 40);
$intervalo_inicio = new TDataGridColumn('intervalo_inicio', 'Saída', 'center', 50);
$intervalo_fim = new TDataGridColumn('intervalo_fim', 'Entrada', 'center', 50);
$saida = new TDataGridColumn('saida', 'Saída', 'center', 50);
$ausencia_desc = new TDataGridColumn('ausencia_desc', 'Ausência', 'left');
// add the columns to the DataGrid
$this->datagrid->addColumn($servidor_nome);
$this->datagrid->addColumn($diames);
$this->datagrid->addColumn($entrada);
$this->datagrid->addColumn($intervalo_inicio);
$this->datagrid->addColumn($intervalo_fim);
$this->datagrid->addColumn($saida);
$this->datagrid->addColumn($ausencia_desc);
$order_servidor_nome = new TAction(array($this, 'onReload'));
$order_servidor_nome->setParameter('order', 'servidor_nome');
$servidor_nome->setAction($order_servidor_nome);
$order_diames = new TAction(array($this, 'onReload'));
$order_diames->setParameter('order', 'diames');
$diames->setAction($order_diames);
// inline editing
$servidor_entrada_edit = new TDataGridAction(array($this, 'onInlineEdit'));
$servidor_entrada_edit->setField('id');
$entrada->setEditAction($servidor_entrada_edit);
$servidor_intervalo_inicio_edit = new TDataGridAction(array($this, 'onInlineEdit'));
$servidor_intervalo_inicio_edit->setField('id');
$intervalo_inicio->setEditAction($servidor_intervalo_inicio_edit);
$servidor_intervalo_fim_edit = new TDataGridAction(array($this, 'onInlineEdit'));
$servidor_intervalo_fim_edit->setField('id');
$intervalo_fim->setEditAction($servidor_intervalo_fim_edit);
$servidor_saida_edit = new TDataGridAction(array($this, 'onInlineEdit'));
$servidor_saida_edit->setField('id');
$saida->setEditAction($servidor_saida_edit);
// creates two datagrid actions
$action1 = new TDataGridAction(array('FrequenciaServidorForm', 'onEdit'));
$action1->setLabel(_t('Edit'));
$action1->setImage('fa:pencil-square-o blue');
$action1->setField('id');
$action2 = new TDataGridAction(array($this, 'onDelete'));
$action2->setLabel(_t('Delete'));
$action2->setImage('fa:trash-o red');
$action2->setField('id');
$action3 = new TDataGridAction(array('FrequenciaServidorForm', 'onFrequencia'));
$action3->setLabel('Informação');
$action3->setImage('fa:info-circle blue');
$action3->setField('id');
// add the actions to the datagrid
$this->datagrid->addAction($action3);
$this->datagrid->addAction($action1);
$this->datagrid->addAction($action2);
// 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->style = 'width: 80%';
$table->addRow()->addCell(new TXMLBreadCrumb('menu.xml', 'FrequenciaServidorList'));
$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 registration form
*/
function __construct()
{
parent::__construct();
$this->string = new StringsUtil();
// creates the form
$this->form = new TForm('form_Atividade');
$this->form->class = 'tform';
// CSS class
$this->form->style = 'width: 500px';
// add a table inside form
$table = new TTable();
$table->width = '100%';
$this->form->add($table);
// add a row for the form title
$row = $table->addRow();
$row->class = 'tformtitle';
// CSS class
$row->addCell(new TLabel('Registro de ausências'))->colspan = 2;
// create the form fields
$id = new THidden('id');
$criteria = new TCriteria();
$criteria->add(new TFilter("origem", "=", 1));
$criteria->add(new TFilter("codigo_cadastro_origem", "=", 100));
$criteria->add(new TFilter("ativo", "=", 1));
$criteria->add(new TFilter("usuario", "is not "));
$colaborador_id = new TDBCombo('colaborador_id', 'atividade', 'Pessoa', 'pessoa_codigo', 'pessoa_nome', 'pessoa_nome', $criteria);
$criteria = new TCriteria();
$criteria->add(new TFilter("id", "in", array(10, 17)));
$tipo_atividade_id = new TDBCombo('tipo_atividade_id', 'atividade', 'TipoAtividade', 'id', 'nome', 'nome', $criteria);
$tipo_atividade_id->setDefaultOption(FALSE);
$data_inicial = new TDate('data_inicial');
$data_inicial->setMask('dd/mm/yyyy');
$data_final = new TDate('data_final');
$data_final->setMask('dd/mm/yyyy');
// define the sizes
$id->setSize(100);
$data_inicial->setSize(100);
$data_final->setSize(100);
$colaborador_id->setSize(290);
$tipo_atividade_id->setSize(290);
// validações
$data_inicial->addValidation('Data inicial', new TRequiredValidator());
$data_final->addValidation('Data final', new TRequiredValidator());
$colaborador_id->addValidation('Colaborador', new TRequiredValidator());
$tipo_atividade_id->addValidation('Tipo atividade', new TRequiredValidator());
// add one row for each form field
$table->addRowSet($label1 = new TLabel('Colaborador:'), $colaborador_id);
$label1->setFontColor('#FF0000');
$table->addRowSet($label2 = new TLabel('Tipo Atividade:'), $tipo_atividade_id);
$label2->setFontColor('#FF0000');
$table->addRowSet($label3 = new TLabel('Data inicial:'), array($data_inicial, $label4 = new TLabel('final:'), $data_final));
$label3->setFontColor('#FF0000');
$label4->setFontColor('#FF0000');
$table->addRowSet(new TLabel(''), $id);
// add some row for the form info
$row = $table->addRow();
$row->addCell(new TLabel('Este sistema deve ser utilizado para registrar ausências de dias completos'))->colspan = 2;
$row = $table->addRow();
$row->addCell(new TLabel('No periodo selecionado não pode haver ponto cadastrado'))->colspan = 2;
$row = $table->addRow();
$row->addCell($label_red = new TLabel('Cuidado para não cadastrar finais de semana e feriados (periodo útil)'))->colspan = 2;
$label_red->setFontColor('#FF0000');
$this->form->setFields(array($id, $data_inicial, $data_final, $colaborador_id, $tipo_atividade_id));
$change_data = new TAction(array($this, 'onChangeData'));
$data_inicial->setExitAction($change_data);
$data_final->setExitAction($change_data);
// create the form actions
$save_button = TButton::create('save', array($this, 'onSave'), _t('Save'), 'fa:floppy-o');
$new_button = TButton::create('new', array($this, 'onEdit'), _t('New'), 'fa:plus-square green');
$this->form->addField($save_button);
$this->form->addField($new_button);
$buttons_box = new THBox();
$buttons_box->add($save_button);
$buttons_box->add($new_button);
// add a row for the form action
$row = $table->addRow();
$row->class = 'tformaction';
// CSS class
$row->addCell($buttons_box)->colspan = 2;
parent::add($this->form);
}
/**
* Class constructor
* Creates the page and the registration form
*/
function __construct()
{
parent::__construct();
// creates the form
$this->form = new TForm('form_customer');
// creates a table
$table_data = new TTable();
$table_contact = new TTable();
$table_skill = new TTable();
$notebook = new TNotebook(500, 250);
// add the notebook inside the form
$this->form->add($notebook);
$notebook->appendPage('Registration Data', $table_data);
$notebook->appendPage('Contact (composition)', $table_contact);
$notebook->appendPage('Skill (aggregation)', $table_skill);
// create the form fields
$code = new TEntry('id');
$name = new TEntry('name');
$address = new TEntry('address');
$phone = new TEntry('phone');
$city_id = new TSeekButton('city_id');
$city_name = new TEntry('city_name');
$birthdate = new TDate('birthdate');
$email = new TEntry('email');
$gender = new TRadioGroup('gender');
$status = new TCombo('status');
$contacts_list = new TMultiField('contacts_list');
$category_id = new TDBCombo('category_id', 'samples', 'Category', 'id', 'name');
// add field validators
$name->addValidation('Name', new TRequiredValidator());
$city_id->addValidation('City', new TRequiredValidator());
$birthdate->addValidation('Birthdate', new TRequiredValidator());
$category_id->addValidation('Category', new TRequiredValidator());
$obj = new CitySeek();
$city_id->setAction(new TAction(array($obj, 'onReload')));
$itemGender = array();
$itemGender['M'] = 'Male';
$itemGender['F'] = 'Female';
// add the combo options
$gender->addItems($itemGender);
$gender->setLayout('horizontal');
$itemStatus = array();
$itemStatus['S'] = 'Single';
$itemStatus['C'] = 'Committed';
$itemStatus['M'] = 'Married';
$status->addItems($itemStatus);
// define some properties for the form fields
$code->setEditable(FALSE);
$code->setSize(100);
$city_id->setSize(100);
$city_name->setSize(150);
$city_name->setEditable(FALSE);
$name->setSize(320);
$address->setSize(320);
$phone->setSize(120);
$email->setSize(160);
$birthdate->setSize(90);
$status->setSize(120);
$category_id->setSize(120);
// add a row for the field code
$table_data->addRowSet(new TLabel('Code:'), $code);
$table_data->addRowSet(new TLabel('Name:'), $name);
$table_data->addRowSet(new TLabel('Address:'), $address);
$table_data->addRowSet(new TLabel('City:'), array($city_id, new TLabel('Name:'), $city_name));
$table_data->addRowSet(new TLabel('Phone:'), array($phone, new TLabel('BirthDate:'), $birthdate));
$table_data->addRowSet(new TLabel('Status:'), array($status, new TLabel('Email:'), $email));
$table_data->addRowSet(new TLabel('Category:'), array($category_id, new TLabel('Gender:'), $gender));
$row = $table_contact->addRow();
$cell = $row->addCell(new TLabel('<b>Contact</b>'));
$cell->valign = 'top';
// add two fields inside the multifield in the second sheet
$contacts_list->setHeight(100);
$contacts_list->setClass('Contact');
// define the returning class
$contacts_list->addField('type', 'Contact Type: ', new TEntry('type'), 200);
$contacts_list->addField('value', 'Contact Value: ', new TEntry('value'), 200);
$row = $table_contact->addRow();
$row->addCell($contacts_list);
// create the radio button for the skills list
$skill_list = new TDBCheckGroup('skill_list', 'samples', 'Skill', 'id', 'name');
$table_skill->addRow()->addCell($lbl = new TLabel('Skills'));
$table_skill->addRow()->addCell($skill_list);
$lbl->setFontStyle('b');
// create an action button
$button1 = new TButton('action1');
$button1->setAction(new TAction(array($this, 'onSave')), 'Save');
$button1->setImage('ico_save.png');
// create an action button (go to list)
$button2 = new TButton('list');
$button2->setAction(new TAction(array('CustomerDataGridView', 'onReload')), 'Go to Listing');
$button2->setImage('ico_datagrid.gif');
// define wich are the form fields
$this->form->setFields(array($code, $name, $address, $phone, $city_id, $city_name, $birthdate, $email, $gender, $status, $category_id, $contacts_list, $skill_list, $button1, $button2));
$subtable = new TTable();
$row = $subtable->addRow();
$row->addCell($button1);
$row->addCell($button2);
// wrap the page content
$vbox = new TVBox();
$vbox->add(new TXMLBreadCrumb('menu.xml', 'CustomerDataGridView'));
$vbox->add($this->form);
$vbox->add($subtable);
// add the form inside the page
parent::add($vbox);
}
/**
* Class constructor
* Creates the page and the registration form
*/
function __construct()
{
parent::__construct();
// creates the table container
$table = new TTable();
$table->style = 'width:100%';
$frame_programs = new TFrame();
// creates the form
$this->form = new TForm('form_System_Receipt');
$this->form->class = 'tform';
// add the notebook inside the form
$this->form->add($table);
$row1 = $table->addRow();
$row1->class = 'tformtitle';
$cell1 = $row1->addCell(new TLabel('Add new receipt'), '');
$cell1->colspan = 2;
// create the form fields
$id = new TEntry('id');
$client = new TDBCombo('client', 'permission', 'SystemClients', 'name', 'name');
$amount = new TEntry('account_money');
$date = new TDate('date');
$id->setEditable(false);
// define the sizes
$id->setSize(100);
$client->setSize(300);
$amount->setSize(300);
$date->setSize(300);
// validations
$client->addValidation('client', new TRequiredValidator());
$amount->addValidation('account_money', new TRequiredValidator());
$date->addValidation('date', new TRequiredValidator());
// add a row for the field id
$table->addRowSet(new TLabel('ID:'), $id);
$table->addRowSet(new TLabel('Client: '), $client);
$table->addRowSet(new TLabel('Account money: '), $amount);
$table->addRowSet(new TLabel('Date: '), $date);
// create an action button (save)
$save_button = new TButton('save');
$save_button->setAction(new TAction(array($this, 'onSave')), _t('Save'));
$save_button->setImage('fa:floppy-o');
// create an new button (edit with no parameters)
$new_button = new TButton('new');
$new_button->setAction(new TAction(array($this, 'onEdit')), _t('New'));
$new_button->setImage('fa:plus-square green');
$list_button = new TButton('list');
$list_button->setAction(new TAction(array('SystemInvoicesList', 'onReload')), _t('Back to the listing'));
$list_button->setImage('fa:table blue');
// define the form fields
$this->form->setFields(array($id, $client, $amount, $date, $save_button, $new_button, $list_button));
$buttons = new THBox();
$buttons->add($save_button);
$buttons->add($new_button);
$buttons->add($list_button);
$container = new TTable();
$container->width = '80%';
$container->addRow()->addCell(new TXMLBreadCrumb('menu.xml', 'SystemInvoicesList'));
$container->addRow()->addCell($this->form);
$row = $table->addRow();
$row->class = 'tformaction';
$cell = $row->addCell($buttons);
$cell->colspan = 2;
// add the form to the page
parent::add($container);
}
/**
* Class constructor
* Creates the page, the form and the listing
*/
public function __construct()
{
parent::__construct();
// creates the form
$this->form = new TForm('form_search_System_Sales');
$this->form->class = 'tform';
// creates a table
$table = new TTable();
$table->style = 'width:100%';
$row1 = $table->addRow();
$row1->class = 'tformtitle';
$cell1 = $row1->addCell(new TLabel('Sales'), '');
$cell1->colspan = 2;
// add the table inside the form
$this->form->add($table);
// create the form fields
$id = new TEntry('id');
$id->setValue(TSession::getValue('s_id'));
$date = new TDate('date');
$date->setValue(TSession::getValue('s_date'));
$client = new TEntry('client');
$client->setValue(TSession::getValue('s_client'));
$amount = new TEntry('amount');
$amount->setValue(TSession::getValue('s_amount'));
$id->setSize(100);
$date->setSize(300);
$client->setSize(300);
$amount->setSize(300);
// add a row for the filter field
$row = $table->addRow();
$row->addCell(new TLabel('ID:'));
$row->addCell($id);
$row = $table->addRow();
$row->addCell(new TLabel('Date: '));
$row->addCell($date);
$row = $table->addRow();
$row->addCell(new TLabel('Client: '));
$row->addCell($client);
$row = $table->addRow();
$row->addCell(new TLabel('Amount: '));
$row->addCell($amount);
// 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('fa:search');
$new_button->setAction(new TAction(array('SystemSalesForm', 'onReload')), _t('New'));
$new_button->setImage('fa:plus-square green');
$container = new THBox();
$container->add($find_button);
$container->add($new_button);
$row = $table->addRow();
$row->class = 'tformaction';
$cell = $row->addCell($container);
$cell->colspan = 2;
// define wich are the form fields
$this->form->setFields(array($id, $date, $client, $amount, $find_button, $new_button));
// creates a DataGrid
$this->datagrid = new TDataGrid();
$this->datagrid->style = 'width: 100%';
$this->datagrid->setHeight(320);
// creates the datagrid columns
$id = new TDataGridColumn('id', 'ID', 'center');
$date = new TDataGridColumn('date', 'Date', 'center');
$client = new TDataGridColumn('client', 'Client', 'center');
$amount = new TDataGridColumn('amount', 'Amount', 'center');
// add the columns to the DataGrid
$this->datagrid->addColumn($id);
$this->datagrid->addColumn($date);
$this->datagrid->addColumn($client);
$this->datagrid->addColumn($amount);
// creates the datagrid column actions
$order_id = new TAction(array($this, 'onReload'));
$order_id->setParameter('order', 'id');
$id->setAction($order_id);
$order_date = new TAction(array($this, 'onReload'));
$order_date->setParameter('order', 'date');
$date->setAction($order_date);
$order_client = new TAction(array($this, 'onReload'));
$order_client->setParameter('order', 'client');
$client->setAction($order_client);
$order_amount = new TAction(array($this, 'onReload'));
$order_amount->setParameter('order', 'amount');
$amount->setAction($order_amount);
// inline editing
$date_edit = new TDataGridAction(array($this, 'onInlineEdit'));
$date_edit->setField('id');
$date->setEditAction($date_edit);
$client_edit = new TDataGridAction(array($this, 'onInlineEdit'));
$client_edit->setField('id');
$client->setEditAction($client_edit);
$amount_edit = new TDataGridAction(array($this, 'onInlineEdit'));
$amount_edit->setField('id');
$amount->setEditAction($amount_edit);
// creates two datagrid actions
/*$action1 = new TDataGridAction(array('SystemSalesForm', 'onEdit'));
$action1->setLabel(_t('Edit'));
$action1->setImage('fa:pencil-square-o blue fa-lg');
$action1->setField('id');*/
$action2 = new TDataGridAction(array($this, 'onDelete'));
$action2->setLabel(_t('Delete'));
$action2->setImage('fa:trash-o grey fa-lg');
$action2->setField('id');
// add the actions to the datagrid
//$this->datagrid->addAction($action1);
$this->datagrid->addAction($action2);
// 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
$container = new TTable();
$container->style = 'width: 80%';
$container->addRow()->addCell(new TXMLBreadCrumb('menu.xml', __CLASS__));
$container->addRow()->addCell($this->form);
$container->addRow()->addCell($this->datagrid);
$container->addRow()->addCell($this->pageNavigation);
// add the container inside the page
parent::add($container);
}
/**
* Class constructor
* Creates the page and the registration form
*/
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 !== 'OPERATOR' and User::newFromLogin(TSession::getValue('login'))->role->mnemonic !== 'LIBRARIAN') {
throw new Exception(_t('Permission denied'));
}
TTransaction::close();
$this->notebook = new TNotebook();
$this->notebook->setSize(500, 190);
// creates the form
$this->form = new TForm('form_Loan');
$this->notebook->appendPage(_t('Data'), $this->form);
// creates a table
$table = new TTable();
// add the table inside the form
$this->form->add($table);
// create the form fields
$member_id = new TSeekButton('member_id');
$member_name = new TEntry('member_name');
$barcode = new TSeekButton('barcode_input');
$book_title = new TEntry('book_title_input');
$loan_date1 = new TDate('loan_date1');
$loan_date2 = new TDate('loan_date2');
$output_type = new TRadioGroup('output_type');
$obj = new ItemSeek();
$action = new TAction(array($obj, 'onReload'));
$barcode->setAction($action);
$options = array();
$options['pdf'] = 'PDF';
$options['rtf'] = 'RTF';
$output_type->addItems($options);
$output_type->setValue('pdf');
$output_type->setLayout('horizontal');
$obj = new TStandardSeek();
$action = new TAction(array($obj, 'onSetup'));
$action->setParameter('database', 'library');
$action->setParameter('parent', 'form_Loan');
$action->setParameter('model', 'Member');
$action->setParameter('display_field', 'name');
$action->setParameter('receive_key', 'member_id');
$action->setParameter('receive_field', 'member_name');
$member_id->setAction($action);
// define the sizes
$member_name->setEditable(FALSE);
$book_title->setEditable(FALSE);
$member_id->setSize(100);
$barcode->setSize(100);
$loan_date1->setSize(100);
$loan_date2->setSize(100);
$loan_date1->setMask('yyyy-mm-dd');
$loan_date2->setMask('yyyy-mm-dd');
// add a row for the field name
$row = $table->addRow();
$row->addCell($l = new TLabel(_t('Report filters')));
$l->setFontStyle('b');
// add a row for the field name
$row = $table->addRow();
$row->addCell(new TLabel(_t('Member') . ': '));
$cell = $row->addCell($member_id);
$cell = $row->addCell($member_name);
// add a row for the field city_id
$row = $table->addRow();
$row->addCell(new TLabel(_t('Barcode') . ': '));
$row->addCell($barcode);
$row->addCell($book_title);
// add a row for the field category_id
$row = $table->addRow();
$row->addCell(new TLabel(_t('Loan date') . ': '));
$cell = $row->addCell($loan_date1);
$cell = $row->addCell($loan_date2);
// add a row for the field category_id
$row = $table->addRow();
$row->addCell(new TLabel(_t('Output') . ': '));
$cell = $row->addCell($output_type);
$cell->colspan = 2;
// create an action button (save)
$save_button = new TButton('generate');
// define the button action
$save_button->setAction(new TAction(array($this, 'onGenerate')), _t('Generate'));
$save_button->setImage('ico_save.png');
// add a row for the form action
$row = $table->addRow();
$row->addCell($save_button);
// define wich are the form fields
$this->form->setFields(array($member_id, $member_name, $barcode, $book_title, $loan_date1, $loan_date2, $output_type, $save_button));
// add the form to the page
parent::add($this->notebook);
}
/**
* Class constructor
* Creates the page, the form and the listing
*/
public function __construct()
{
parent::__construct();
$this->string = new StringsUtil();
// creates the form
$this->form = new TForm('form_search_Atividade');
$this->form->class = 'tform';
// CSS class
// creates a table
$table = new TTable();
$table->width = '100%';
$this->form->add($table);
// add a row for the form title
$row = $table->addRow();
$row->class = 'tformtitle';
// CSS class
$row->addCell(new TLabel('Atividade'))->colspan = 2;
// create the form fields
$id = new THidden('id');
$data_atividade_inicial = new TDate('data_atividade_inicial');
$data_atividade_inicial->setMask('dd/mm/yyyy');
$data_atividade_final = new TDate('data_atividade_final');
$data_atividade_final->setMask('dd/mm/yyyy');
$criteria = new TCriteria();
$criteria->add(new TFilter("origem", "=", 1));
$criteria->add(new TFilter("codigo_cadastro_origem", "=", 100));
$criteria->add(new TFilter("ativo", "=", 1));
$criteria->add(new TFilter("usuario", "is not "));
$colaborador_id = new TDBCombo('colaborador_id', 'atividade', 'Pessoa', 'pessoa_codigo', 'pessoa_nome', 'pessoa_nome', $criteria);
$tipo_atividade_id = new TDBCombo('tipo_atividade_id', 'atividade', 'TipoAtividade', 'id', 'nome', 'nome');
$ticket_id = new TDBMultiSearch('ticket_id', 'atividade', 'Ticket', 'id', 'titulo', 'titulo');
$pesquisa_master = new TEntry('pesquisa_master');
$criteria = new TCriteria();
$criteria->add(new TFilter("ativo", "=", 1));
$newparam['order'] = 'pessoa_nome';
$newparam['direction'] = 'asc';
$criteria->setProperties($newparam);
// order, offset
$solicitante_id = new TDBSeekButton('solicitante_id', 'atividade', 'form_search_Ticket', 'Pessoa', 'pessoa_nome', 'solicitante_id', 'solicitante_nome', $criteria);
$solicitante_nome = new TEntry('solicitante_nome');
$solicitante_nome->setEditable(FALSE);
$total_atividades = new TEntry('total_atividades');
$total_atividades->setEditable(FALSE);
// define the sizes
$id->setSize(50);
$data_atividade_inicial->setSize(100);
$data_atividade_final->setSize(100);
$colaborador_id->setSize(300);
$tipo_atividade_id->setSize(300);
$ticket_id->setMinLength(0);
$ticket_id->setMaxSize(1);
$ticket_id->setSize(300);
$ticket_id->setOperator('ilike');
$solicitante_id->setSize(40);
$solicitante_nome->setSize(235);
$total_atividades->setSize(100);
$pesquisa_master->setSize(300);
// add one row for each form field
$table->addRowSet(new TLabel('Solicitante:'), array($solicitante_id, $solicitante_nome));
$table->addRowSet(new TLabel('Colaborador:'), $colaborador_id);
$table->addRowSet(new TLabel('Dt. Atividades inicio:'), array($data_atividade_inicial, $label_data_fim = new TLabel('Fim:'), $data_atividade_final));
$label_data_fim->setSize(48);
$table->addRowSet(new TLabel('Atividade:'), $tipo_atividade_id);
$table->addRowSet(new TLabel('Ticket:'), $ticket_id);
$table->addRowSet(new TLabel('Pesquisa por palavra:'), $pesquisa_master);
$table->addRowSet(new TLabel('Total horas atividades:'), $total_atividades);
$table->addRowSet(new TLabel(''), $id);
$this->form->setFields(array($id, $data_atividade_inicial, $data_atividade_final, $colaborador_id, $tipo_atividade_id, $ticket_id, $solicitante_id, $solicitante_nome, $pesquisa_master, $total_atividades));
$change_data = new TAction(array($this, 'onChangeData'));
$data_atividade_inicial->setExitAction($change_data);
$data_atividade_final->setExitAction($change_data);
// keep the form filled during navigation with session data
$this->form->setData(TSession::getValue('Atividade_filter_data'));
// create two action buttons to the form
$find_button = TButton::create('find', array($this, 'onSearch'), _t('Find'), 'ico_find.png');
$new_button = TButton::create('new', array('AtividadeForm', 'onEdit'), _t('New'), 'fa:plus-square green');
$clean_button = TButton::create('clean', array($this, 'onClean'), 'Limpar', 'ico_close.png');
$this->form->addField($find_button);
$this->form->addField($new_button);
$this->form->addField($clean_button);
$buttons_box = new THBox();
$buttons_box->add($find_button);
$buttons_box->add($new_button);
$buttons_box->add($clean_button);
// add a row for the form action
$row = $table->addRow();
$row->class = 'tformaction';
// CSS class
$row->addCell($buttons_box)->colspan = 2;
// creates a Datagrid
$this->datagrid = new TDataGrid();
$this->datagrid->setHeight(320);
// creates the datagrid columns
$data_atividade = new TDataGridColumn('data_atividade', 'Data', 'right', 40);
$hora_inicio = new TDataGridColumn('hora_inicio', 'Inicio', 'right', 20);
$hora_fim = new TDataGridColumn('hora_fim', 'Fim', 'right', 20);
$hora_qte = new TDataGridColumn('hora_qte', 'Qtde', 'right', 20);
$colaborador_id = new TDataGridColumn('pessoa->pessoa_nome', 'Colaborador', 'left', 50);
$tipo_atividade_id = new TDataGridColumn('tipo_atividade->nome', 'Atividade', 'left', 100);
//get_tipo_atividade()->nome
$sistema_id = new TDataGridColumn('sistema->nome', 'Sistema', 'left', 100);
$ticket_id = new TDataGridColumn('ticket->titulo', 'Ticket', 'left', 200);
// get_ticket()->titulo
// transformers
$colaborador_id->setTransformer(array($this, 'retornaPessoa'));
$hora_qte->setTransformer(array($this, 'calculaDiferenca'));
$data_atividade->setTransformer(array('StringsUtil', 'formatDateBR'));
$hora_inicio->setTransformer(array('StringsUtil', 'retira_segundos'));
$hora_fim->setTransformer(array('StringsUtil', 'retira_segundos'));
// add the columns to the DataGrid
$this->datagrid->addColumn($data_atividade);
$this->datagrid->addColumn($hora_inicio);
$this->datagrid->addColumn($hora_fim);
$this->datagrid->addColumn($hora_qte);
$this->datagrid->addColumn($colaborador_id);
$this->datagrid->addColumn($tipo_atividade_id);
$this->datagrid->addColumn($sistema_id);
$this->datagrid->addColumn($ticket_id);
// creates the datagrid column actions
$order_data_atividade = new TAction(array($this, 'onReload'));
$order_data_atividade->setParameter('order', 'data_atividade');
$data_atividade->setAction($order_data_atividade);
$order_colaborador_id = new TAction(array($this, 'onReload'));
$order_colaborador_id->setParameter('order', 'pessoa->pessoa_nome');
$colaborador_id->setAction($order_colaborador_id);
$order_tipo_atividade_id = new TAction(array($this, 'onReload'));
$order_tipo_atividade_id->setParameter('order', 'tipo_atividade->nome');
$tipo_atividade_id->setAction($order_tipo_atividade_id);
$order_sistema_id = new TAction(array($this, 'onReload'));
$order_sistema_id->setParameter('order', 'sistema->nome');
$sistema_id->setAction($order_sistema_id);
$order_ticket_id = new TAction(array($this, 'onReload'));
$order_ticket_id->setParameter('order', 'ticket->titulo');
$ticket_id->setAction($order_ticket_id);
// creates two datagrid actions
$action1 = new TDataGridAction(array('AtividadeForm', 'onEdit'));
$action1->setLabel(_t('Edit'));
$action1->setImage('fa:pencil-square-o blue fa-lg');
$action1->setField('id');
// add the actions to the datagrid
$this->datagrid->addAction($action1);
// 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());
// create the page container
$container = TVBox::pack($this->form, $this->datagrid, $this->pageNavigation);
$container->style = 'width: 100%;max-width: 1200px;';
$this->datagrid->style = ' width: 100%; max-width: 1200px;';
parent::add($container);
}
/**
* Class constructor
* Creates the page and the registration form
*/
function __construct()
{
parent::__construct();
// creates the form
$this->form = new TForm('form_FreqServForm');
$this->form->class = 'tform';
// creates the table container
$table = new TTable();
$table->style = 'width: 100%';
$table->addRowSet(new TLabel('Frequência'), '', '', '')->class = 'tformtitle';
// add the table inside the form
$this->form->add($table);
$frame_horarios = new TFrame(NULL, 210);
$frame_horarios->setLegend('Horários');
$frame_horarios->style .= ';margin: 15px';
$frame_ausencia = new TFrame(NULL, 210);
$frame_ausencia->setLegend('Ausência');
$frame_ausencia->style .= ';margin: 15px';
// create the form fields
$id = new TEntry('id');
$servidor_id = new TDBSeekButton('servidor_id', 'lacenrh', 'form_FreqServForm', 'Servidor', 'servidor', 'servidor_id', 'servidor_nome');
$servidor_nome = new TEntry('servidor_nome');
$diames = new TDate('diames');
$entrada = new TEntry('entrada');
$intervalo_inicio = new TEntry('intervalo_inicio');
$intervalo_fim = new TEntry('intervalo_fim');
$saida = new TEntry('saida');
$ausencia_id = new TDBSeekButton('ausencia_id', 'lacenrh', 'form_FreqServForm', 'Ausencia', 'ausencia', 'ausencia_id', 'ausencia_desc');
$ausencia_desc = new TEntry('ausencia_desc');
$horas_justificadas = new TEntry('horas_justificadas');
$justificativa = new TText('justificativa');
$horas_trabalhadas = new TEntry('horas_trabalhadas');
// define the sizes
$id->setSize(40);
$servidor_id->setSize(40);
$servidor_nome->setSize(300);
$diames->setSize(100);
$entrada->setSize(50);
$intervalo_inicio->setSize(50);
$intervalo_fim->setSize(50);
$saida->setSize(50);
$ausencia_id->setSize(40);
$ausencia_desc->setSize(200);
$horas_justificadas->setSize(50);
$justificativa->setSize(200, 50);
$horas_trabalhadas->setSize(200, 50);
// outras propriedades
$id->setEditable(false);
$servidor_nome->setEditable(false);
$diames->setMask('dd/mm/yyyy');
$entrada->setMask('99:99');
$entrada->setValue('00:00');
$intervalo_inicio->setMask('99:99');
$intervalo_inicio->setValue('00:00');
$intervalo_fim->setMask('99:99');
$intervalo_fim->setValue('00:00');
$saida->setMask('99:99');
$saida->setValue('00:00');
$ausencia_desc->setEditable(false);
$horas_justificadas->setMask('99:99');
$horas_justificadas->setValue('00:00');
$horas_trabalhadas->setMask('99:99');
// validations
$servidor_id->addValidation('Servidor', new TRequiredValidator());
$servidor_nome->addValidation('Nome', new TRequiredValidator());
$diames->addValidation('Data', new TRequiredValidator());
$table_horarios = new TTable();
$table_horarios->addRowSet(new TLabel('Data ' . ': '), $diames);
$table_horarios->addRowSet(new TLabel('Entrada ' . ': '), $entrada);
$table_horarios->addRowSet(new TLabel('Intervalo - Início ' . ': '), $intervalo_inicio);
$table_horarios->addRowSet(new TLabel('Intervalo - Fim' . ': '), $intervalo_fim);
$table_horarios->addRowSet(new TLabel('Saída' . ': '), $saida);
$frame_horarios->add($table_horarios);
$table_ausencia = new TTable();
$table_ausencia->addRowSet(new TLabel('Motivo ' . ': '), $ausencia_id);
$table_ausencia->addRowSet(new TLabel('Descrição ' . ': '), $ausencia_desc);
$table_ausencia->addRowSet(new TLabel('Horas Justificadas ' . ': '), $horas_justificadas);
$table_ausencia->addRowSet(new TLabel('Justificativa ' . ': '), $justificativa);
$frame_ausencia->add($table_ausencia);
// add a row for the field id
$table->addRowSet(new TLabel('ID:'), $id);
$table->addRowSet(new TLabel('Servidor' . ': '), $servidor_id);
$table->addRowSet(new TLabel('Nome' . ': '), $servidor_nome);
$row = $table->addRow();
$cell = $row->addCell($frame_horarios);
$cell->colspan = 2;
$cell = $row->addCell($frame_ausencia);
$cell->colspan = 2;
// create an action button (save)
$save_button = new TButton('save');
$save_button->setAction(new TAction(array($this, 'onSave')), _t('Save'));
$save_button->setImage('fa:floppy-o fa-lg');
// create an new button (edit with no parameters)
$new_button = new TButton('new');
$new_button->setAction(new TAction(array($this, 'onEdit')), _t('New'));
$new_button->setImage('fa:plus-square green fa-lg');
$list_button = new TButton('list');
$list_button->setAction(new TAction(array('FrequenciaServidorList', 'onReload')), _t('Back to the listing'));
$list_button->setImage('fa:table blue fa-lg');
// define the form fields
$this->form->setFields(array($id, $servidor_id, $servidor_nome, $diames, $entrada, $intervalo_inicio, $intervalo_fim, $saida, $ausencia_id, $ausencia_desc, $horas_justificadas, $justificativa, $horas_trabalhadas, $save_button, $new_button, $list_button));
$buttons = new THBox();
$buttons->add($save_button);
$buttons->add($new_button);
$buttons->add($list_button);
$row = $table->addRow();
$row->class = 'tformaction';
$cell = $row->addCell($buttons);
$cell->colspan = 4;
$container = new TTable();
$container->style = 'width: 80%';
$container->addRow()->addCell(new TXMLBreadCrumb('menu.xml', 'FrequenciaServidorList'));
$container->addRow()->addCell($this->form);
// add the form to the page
parent::add($container);
}
/**
* Class constructor
* Creates the page and the registration form
*/
function __construct()
{
parent::__construct();
// creates the form
$this->form = new TForm('form_Sale');
$this->form->class = 'tform';
// CSS class
parent::include_css('app/resources/custom-frame.css');
$table_master = new TTable();
$table_master->width = '100%';
$table_master->addRowSet(new TLabel('Sale'), '', '')->class = 'tformtitle';
// add a table inside form
$table_general = new TTable();
$table_general->width = '100%';
$tableProduct = new TTable();
$tableProduct->width = '100%';
$frame_general = new TFrame();
$frame_general->setLegend('General data');
$frame_general->style = 'background:whiteSmoke';
$frame_general->add($table_general);
$table_master->addRow()->addCell($frame_general)->colspan = 2;
$row = $table_master->addRow();
$row->addCell($tableProduct);
$this->form->add($table_master);
// master fields
$id = new TEntry('id');
$date = new TDate('date');
$customer_id = new TDBSeekButton('customer_id', 'samples', $this->form->getName(), 'Customer', 'name', 'customer_id', 'customer_name');
$customer_name = new TEntry('customer_name');
$obs = new TText('obs');
// detail fields
$product_id = new TDBSeekButton('product_id', 'samples', $this->form->getName(), 'Product', 'description', 'product_id', 'product_name');
$product_name = new TEntry('product_name');
$sale_price = new TEntry('product_price');
$amount = new TEntry('product_amount');
$discount = new TEntry('product_discount');
$total = new TEntry('product_total');
$product_id->setExitAction(new TAction(array($this, 'onProductChange')));
$id->setSize(40);
$date->setSize(100);
$obs->setSize(400, 100);
$product_id->setSize(50);
$customer_id->setSize(50);
$id->setEditable(false);
$product_name->setEditable(false);
$customer_name->setEditable(false);
$date->addValidation('Date', new TRequiredValidator());
$customer_id->addValidation('Customer', new TRequiredValidator());
// pedido
$table_general->addRowSet(new TLabel('ID'), $id);
$table_general->addRowSet($label_date = new TLabel('Date (*)'), $date);
$table_general->addRowSet($label_customer = new TLabel('Customer (*)'), array($customer_id, $customer_name));
$table_general->addRowSet(new TLabel('Obs'), $obs);
$label_date->setFontColor('#FF0000');
// products
$frame_product = new TFrame();
$frame_product->setLegend('Products');
$row = $tableProduct->addRow();
$row->addCell($frame_product);
$add_product = new TButton('add_product');
$action_product = new TAction(array($this, 'onProductAdd'));
$add_product->setAction($action_product, 'Register');
$add_product->setImage('fa:save');
$subtable_product = new TTable();
$frame_product->add($subtable_product);
$subtable_product->addRowSet($label_product = new TLabel('Product (*)'), array($product_id, $product_name));
$subtable_product->addRowSet($label_sale_price = new TLabel('Price (*)'), $sale_price);
$subtable_product->addRowSet($label_amount = new TLabel('Amount(*)'), $amount);
$subtable_product->addRowSet(new TLabel('Discount'), $discount);
$subtable_product->addRowSet($add_product);
$label_product->setFontColor('#FF0000');
$label_amount->setFontColor('#FF0000');
$label_sale_price->setFontColor('#FF0000');
$this->product_list = new TQuickGrid();
$this->product_list->setHeight(175);
$this->product_list->makeScrollable();
$this->product_list->disableDefaultClick();
$this->product_list->addQuickColumn('', 'edit', 'left', 50);
$this->product_list->addQuickColumn('', 'delete', 'left', 50);
$this->product_list->addQuickColumn('ID', 'product_id', 'center', 40);
$this->product_list->addQuickColumn('Product', 'product_name', 'left', 200);
$this->product_list->addQuickColumn('Amount', 'product_amount', 'left', 60);
$this->product_list->addQuickColumn('Price', 'product_price', 'right', 80);
$this->product_list->addQuickColumn('Discount', 'product_discount', 'right', 80);
$this->product_list->createModel();
$row = $tableProduct->addRow();
$row->addCell($this->product_list);
// create an action button (save)
$save_button = new TButton('save');
$save_button->setAction(new TAction(array($this, 'onSave')), _t('Save'));
$save_button->setImage('ico_save.png');
// create an new button (edit with no parameters)
$new_button = new TButton('new');
$new_button->setAction(new TAction(array($this, 'onClear')), _t('New'));
$new_button->setImage('ico_new.png');
// define form fields
$this->formFields = array($id, $date, $customer_id, $customer_name, $obs, $product_id, $product_name, $sale_price, $amount, $discount, $total, $add_product, $save_button, $new_button);
$this->form->setFields($this->formFields);
$table_master->addRowSet(array($save_button, $new_button), '', '')->class = 'tformaction';
// CSS class
// create the page container
$container = new TVBox();
$container->add(new TXMLBreadCrumb('menu.xml', __CLASS__));
$container->add($this->form);
parent::add($container);
}
/**
* Class constructor
* Creates the page and the registration form
*/
function __construct()
{
parent::__construct();
// creates the form
$this->form = new TForm('form_Ticket');
$this->form->class = 'tform';
// CSS class
$table = new TTable();
$table->style = 'width: 600px';
$tablePagamento = new TTable();
$tablePagamento->style = 'width: 600px';
$notebook = new TNotebook(600, 650);
$notebook->appendPage('Ticket - Cadastramento', $table);
$notebook->appendPage('Ticket - Orçamento / Pagamento', $tablePagamento);
// create the form fields
$id = new TEntry('id');
$id->setEditable(FALSE);
$titulo = new TEntry('titulo');
$origem = new TCombo('origem');
$combo_origem = array();
$combo_origem['I'] = 'Interno';
$combo_origem['E'] = 'Externo';
$origem->addItems($combo_origem);
$origem->setDefaultOption(FALSE);
$solicitacao_descricao = new TText('solicitacao_descricao');
$providencia = new TText('providencia');
$orcamento_horas = new TEntry('orcamento_horas');
$orcamento_horas->setMask('999999');
$orcamento_valor_hora = new TEntry('orcamento_valor_hora');
$orcamento_valor_hora->setNumericMask(2, ',', '.');
$valor_desconto = new TEntry('valor_desconto');
$valor_desconto->setNumericMask(2, ',', '.');
$valor_total = new TEntry('valor_total');
$valor_total->setNumericMask(2, ',', '.');
$valor_total->setEditable(FALSE);
$forma_pagamento = new TEntry('forma_pagamento');
$data_ultimo_pgto = new TEntry('data_ultimo_pgto');
$data_ultimo_pgto->setEditable(FALSE);
$valor_ultimo_pgto = new TEntry('valor_ultimo_pgto');
$valor_ultimo_pgto->setNumericMask(2, ',', '.');
$valor_ultimo_pgto->setEditable(FALSE);
$valor_total_pago = new TEntry('valor_total_pago');
$valor_total_pago->setNumericMask(2, ',', '.');
$valor_total_pago->setEditable(FALSE);
$data_pagamento = new TDate('data_pagamento');
$data_pagamento->setMask('dd/mm/yyyy');
$valor_pagamento = new TEntry('valor_pagamento');
$valor_pagamento->setNumericMask(2, ',', '.');
$valor_total_parcial = new TEntry('valor_total_parcial');
$valor_total_parcial->setNumericMask(2, ',', '.');
$valor_total_parcial->setEditable(FALSE);
$valor_saldo = new TEntry('valor_saldo');
$valor_saldo->setNumericMask(2, ',', '.');
$valor_saldo->setEditable(FALSE);
$data_cadastro = new TEntry('data_cadastro');
$data_cadastro->setEditable(FALSE);
$data_cadastro->setMask('dd/mm/yyyy');
$data_cadastro->setValue(date('d/m/Y'));
$data_inicio = new TDate('data_inicio');
$data_inicio->setMask('dd/mm/yyyy');
$data_inicio_oculta = new THidden('data_inicio_oculta');
$data_cancelamento = new TDate('data_cancelamento');
$data_cancelamento->setMask('dd/mm/yyyy');
$data_encerramento = new TDate('data_encerramento');
$data_encerramento->setMask('dd/mm/yyyy');
$data_prevista = new TDate('data_prevista');
$data_prevista->setMask('dd/mm/yyyy');
$data_aprovacao = new TDate('data_aprovacao');
$data_aprovacao->setMask('dd/mm/yyyy');
$observacao = new TText('observacao');
$nome_dtr = new TEntry('nome_dtr');
$nome_dtr->setEditable(FALSE);
$criteria = new TCriteria();
$criteria->add(new TFilter("origem", "=", 1));
$criteria->add(new TFilter("ativo", "=", 1));
$criteria->add(new TFilter("codigo_cadastro_origem", "=", 100));
$responsavel_id = new TDBCombo('responsavel_id', 'atividade', 'Pessoa', 'pessoa_codigo', 'pessoa_nome', 'pessoa_nome', $criteria);
$tipo_ticket_id = new TDBCombo('tipo_ticket_id', 'atividade', 'TipoTicket', 'id', 'nome');
$tipo_ticket_id->setDefaultOption(FALSE);
$sistema_id = new TDBCombo('sistema_id', 'atividade', 'Sistema', 'id', 'nome');
$status_ticket_id = new TDBCombo('status_ticket_id', 'atividade', 'StatusTicket', 'id', 'nome');
$status_ticket_id->setValue(2);
$status_ticket_id->setEditable(FALSE);
$prioridade_id = new TDBCombo('prioridade_id', 'atividade', 'Prioridade', 'id', 'nome');
$prioridade_id->setDefaultOption(FALSE);
$prioridade_id->setValue(3);
$combo_tipo_origens = new TCombo('tipo_origens');
$combo_tipo_origens->addItems(array(1 => 'Entidade', 2 => 'Estabelecimento', 3 => 'Empresa'));
$combo_codigo_origem = new TCombo('codigo_cadastro_origem');
$combo_solicitante_id = new TCombo('solicitante_id');
try {
TTransaction::open('atividade');
$logado = Pessoa::retornaUsuario();
TTransaction::close();
} catch (Exception $e) {
new TMessage('error', '<b>Error</b> ' . $e->getMessage());
// shows the exception error message
}
$logado_id = new THidden('logado_id');
$logado_id->setValue($logado->pessoa_codigo);
// define the sizes
$id->setSize(100);
$origem->setSize(200);
$solicitacao_descricao->setSize(400, 180);
$data_inicio->setSize(90);
$data_encerramento->setSize(90);
$data_cancelamento->setSize(90);
$providencia->setSize(400, 80);
$orcamento_horas->setSize(100);
$orcamento_valor_hora->setSize(100);
$valor_desconto->setSize(100);
$valor_total->setSize(100);
$valor_saldo->setSize(121);
$forma_pagamento->setSize(400);
$data_ultimo_pgto->setSize(100);
$data_pagamento->setSize(100);
$valor_pagamento->setSize(121);
$valor_ultimo_pgto->setSize(100);
$valor_total_pago->setSize(100);
$valor_total_parcial->setSize(121);
$data_cadastro->setSize(100);
$data_prevista->setSize(100);
$data_aprovacao->setSize(100);
$observacao->setSize(400, 80);
$nome_dtr->setSize(400);
$titulo->setSize(390);
$responsavel_id->setSize(390);
$tipo_ticket_id->setSize(200);
$sistema_id->setSize(200);
$status_ticket_id->setSize(200);
$prioridade_id->setSize(200);
$combo_tipo_origens->setSize(135);
$combo_codigo_origem->setSize(250);
$combo_solicitante_id->setSize(390);
// validações
$titulo->addValidation('Titulo', new TRequiredValidator());
$combo_solicitante_id->addValidation('Solicitante', new TRequiredValidator());
$responsavel_id->addValidation('Responsável', new TRequiredValidator());
$sistema_id->addValidation('Sistema', new TRequiredValidator());
$gerar_dr = TButton::create('gerar_dr', array('RequisitoDesenvolvimentoForm', 'onEdit'), 'Gerar DTR', 'ico_add.png');
$link_dtr = new TButton('link_dtr');
$link_dtr->setImage('bs:edit green');
$link_dtr->setLabel('ir para DTR');
$link_dtr->addFunction("__adianti_load_page('index.php?class=RequisitoDesenvolvimentoForm&method=onBuscaDTR&key={$_REQUEST['key']}');");
$this->form->addField($gerar_dr);
$this->form->addField($link_dtr);
TButton::disableField('form_Ticket', 'gerar_dr');
TButton::disableField('form_Ticket', 'link_dtr');
// add one row for each form field
// notebook Cadastramento
$table->addRowSet(new TLabel('Ticket:'), array($id, new TLabel('Data Cadastro'), $data_cadastro));
$table->addRowSet($label_combo_origem = new TLabel('Origem:'), array($combo_tipo_origens, $combo_codigo_origem));
$label_combo_origem->setFontColor('#FF0000');
$table->addRowSet($label_solicitante = new TLabel('Solicitante:'), $combo_solicitante_id);
$label_solicitante->setFontColor('#FF0000');
$table->addRowSet($label_responsavel = new TLabel('Responsável:'), $responsavel_id);
$label_responsavel->setFontColor('#FF0000');
$table->addRowSet($label_titulo = new TLabel('Título:'), $titulo);
$label_titulo->setFontColor('#FF0000');
$table->addRowSet(new TLabel('Data Inicio'), array($data_inicio, $label_status = new TLabel('Status:'), $status_ticket_id));
$label_status->setSize(70);
$table->addRowSet(new TLabel('Data Encerramento:'), array($data_encerramento, $label_data_cancelamento = new TLabel('Data Cancelamento:'), $data_cancelamento));
$label_data_cancelamento->setSize(160);
$table->addRowSet(new TLabel('Prioridade:'), $prioridade_id);
$table->addRowSet(new TLabel('Origem:'), $origem);
$table->addRowSet(new TLabel('Tipo Ticket:'), $tipo_ticket_id);
$table->addRowSet($label_sistema = new TLabel('Sistema:'), $sistema_id);
$label_sistema->setFontColor('#FF0000');
$table->addRowSet(new TLabel('Descrição Solicitação:'), $solicitacao_descricao);
$table->addRowSet(new TLabel('DR.:'), $nome_dtr);
$table->addRowSet(new TLabel(''), array($gerar_dr, $link_dtr));
$table->addRowSet(new TLabel(''), $data_inicio_oculta);
// notebook Pagamento
$tablePagamento->addRowSet(new TLabel('Data Prevista:'), $data_prevista);
$tablePagamento->addRowSet(new TLabel('Data Aprovação:'), $data_aprovacao);
$tablePagamento->addRowSet(new TLabel('Qte Horas:'), $orcamento_horas);
$tablePagamento->addRowSet(new TLabel('Valor Hora:'), $orcamento_valor_hora);
$tablePagamento->addRowSet(new TLabel('Valor Desconto:'), $valor_desconto);
$tablePagamento->addRowSet(new TLabel('Valor Total:'), $valor_total);
$tablePagamento->addRowSet(new TLabel('Forma de Pgto:'), $forma_pagamento);
$tablePagamento->addRowSet(new TLabel('Descrição Providência:'), $providencia);
$tablePagamento->addRowSet(new TLabel('Observação:'), $observacao);
// creates a frame
$frame = new TFrame();
$frame->oid = 'frame-measures';
$frame->setLegend('Pagamentos:');
$row = $tablePagamento->addRow();
$cell = $row->addCell($frame);
$cell->colspan = 2;
$page2 = new TTable();
$frame->add($page2);
$page2->addRowSet(new TLabel('Valor Pgto:'), array($valor_pagamento, $tamanho_label = new TLabel('Valor Ultimo Pgto:'), $valor_ultimo_pgto));
$tamanho_label->setSize(150);
$page2->addRowSet(new TLabel('Data Pgto:'), array($data_pagamento, $tamanho_label = new TLabel('Data Ultimo Pgto:'), $data_ultimo_pgto));
$tamanho_label->setSize(150);
$page2->addRowSet(new TLabel('Valor Total:'), array($valor_total_parcial, $tamanho_label = new TLabel('Valor Total Pago: '), $valor_total_pago));
$tamanho_label->setSize(150);
$page2->addRowSet(new TLabel('Saldo a pagar:'), $valor_saldo);
$tablePagamento->addRowSet(new TLabel(''), $logado_id);
// Envia campos para o formulario
$this->form->setFields(array($id, $titulo, $data_inicio, $data_inicio_oculta, $data_encerramento, $data_cancelamento, $origem, $solicitacao_descricao, $nome_dtr, $providencia, $orcamento_horas, $orcamento_valor_hora, $valor_desconto, $valor_total, $forma_pagamento, $data_ultimo_pgto, $valor_ultimo_pgto, $valor_total_pago, $data_cadastro, $data_prevista, $data_aprovacao, $observacao, $tipo_ticket_id, $sistema_id, $status_ticket_id, $prioridade_id, $responsavel_id, $valor_total_parcial, $valor_pagamento, $data_pagamento, $valor_saldo, $combo_tipo_origens, $combo_codigo_origem, $combo_solicitante_id, $logado_id));
// create the form actions
$save_button = TButton::create('save', array($this, 'onSave'), _t('Save'), 'fa:floppy-o');
$new_button = TButton::create('new', array($this, 'onEdit'), _t('New'), 'fa:plus-square green');
$del_button = TButton::create('delete', array($this, 'onDelete'), _t('Delete'), 'fa:trash-o red fa-lg');
$list_button = TButton::create('list', array('TicketList', 'onReload'), _t('List'), 'fa:table blue');
$enviar_email = TButton::create('email', array($this, 'onEnviaEmail'), 'Enviar Email', 'ico_email.png');
$sincronizar = TButton::create('sincronizar', array($this, 'onSincronizarContatos'), 'Sincronizar Contatos', 'sincronizar.png');
$this->form->addField($save_button);
$this->form->addField($new_button);
$this->form->addField($del_button);
$this->form->addField($list_button);
$this->form->addField($enviar_email);
$this->form->addField($sincronizar);
$subtable = new TTable();
$row = $subtable->addRow();
$row->addCell($save_button);
$row->addCell($new_button);
$row->addCell($del_button);
$row->addCell($list_button);
$row->addCell($enviar_email);
$row->addCell($sincronizar);
$pretable = new TTable();
$pretable->style = 'width: 100%';
$row = $pretable->addRow();
$row->class = 'tformtitle';
// CSS class
$row->addCell(new TLabel('Cadastro de Ticket'))->colspan = 2;
$change_action = new TAction(array($this, 'onCalculaValorTotal'));
$orcamento_horas->setExitAction($change_action);
$orcamento_valor_hora->setExitAction($change_action);
$valor_desconto->setExitAction($change_action);
$change_data_action = new TAction(array($this, 'onChangeDataAction'));
$data_aprovacao->setExitAction($change_data_action);
$change_data_prev = new TAction(array($this, 'onChangeDataPrevista'));
$data_prevista->setExitAction($change_data_prev);
$change_data_pagamento = new TAction(array($this, 'onChangeDataPagamento'));
$data_pagamento->setExitAction($change_data_pagamento);
$change_valor = new TAction(array($this, 'onCalculaValorParcial'));
$valor_pagamento->setExitAction($change_valor);
$change_status = new TAction(array($this, 'onChangeDataInicio'));
$data_inicio->setExitAction($change_status);
$change_status = new TAction(array($this, 'onChangeDataCancelamento'));
$data_cancelamento->setExitAction($change_status);
$change_status = new TAction(array($this, 'onChangeDataEncerramento'));
$data_encerramento->setExitAction($change_status);
$change_origem = new TAction(array($this, 'onChangeOrigem'));
$combo_tipo_origens->setChangeAction($change_origem);
$change_tipo_origem = new TAction(array($this, 'onChangeTipoOrigem'));
$combo_codigo_origem->setChangeAction($change_tipo_origem);
$vbox = new TVBox();
$vbox->add($pretable);
$vbox->add($notebook);
$vbox->add($subtable);
$this->form->add($vbox);
parent::add($this->form);
}
/**
* Class constructor
* Creates the page and the registration form
*/
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();
// creates the form
$this->form = new TForm('form_Book');
// creates a table
$table1 = new TTable();
$table2 = new TTable();
$table3 = new TTable();
$notebook = new TNotebook(550, 400);
$notebook->appendPage(_t('Basic data'), $table1);
$notebook->appendPage(_t('Secundary data'), $table2);
$notebook->appendPage(_t('Items'), $table3);
// add the table inside the form
$this->form->add($notebook);
// create the form fields
$id = new TEntry('id');
$title = new TEntry('title');
$isbn = new TEntry('isbn');
$call_number = new TEntry('call_number');
$author_id = new TSeekButton('author_id');
$author_name = new TEntry('author_name');
$edition = new TEntry('edition');
$volume = new TEntry('volume');
$collection_id = new TDBCombo('collection_id', 'library', 'Collection', 'id', 'description');
$classification_id = new TDBCombo('classification_id', 'library', 'Classification', 'id', 'description');
$publisher_id = new TSeekButton('publisher_id');
$publisher_name = new TEntry('publisher_name');
$publish_place = new TEntry('publish_place');
$publish_date = new TDate('publish_date');
$abstract = new TText('abstract');
$notes = new TText('notes');
$obj = new TStandardSeek();
$action = new TAction(array($obj, 'onSetup'));
$action->setParameter('database', 'library');
$action->setParameter('parent', 'form_Book');
$action->setParameter('model', 'Publisher');
$action->setParameter('display_field', 'name');
$action->setParameter('receive_key', 'publisher_id');
$action->setParameter('receive_field', 'publisher_name');
$publisher_id->setAction($action);
$obj = new TStandardSeek();
$action = new TAction(array($obj, 'onSetup'));
$action->setParameter('database', 'library');
$action->setParameter('parent', 'form_Book');
$action->setParameter('model', 'Author');
$action->setParameter('display_field', 'name');
$action->setParameter('receive_key', 'author_id');
$action->setParameter('receive_field', 'author_name');
$author_id->setAction($action);
// define the sizes
$id->setSize(100);
$title->setSize(340);
$isbn->setSize(120);
$call_number->setSize(120);
$author_id->setSize(100);
$edition->setSize(120);
$volume->setSize(120);
$collection_id->setSize(100);
$classification_id->setSize(100);
$publisher_id->setSize(100);
$publish_place->setSize(140);
$publish_date->setSize(100);
$abstract->setSize(400, 40);
$notes->setSize(400, 40);
$id->setEditable(FALSE);
$publisher_name->setEditable(FALSE);
$author_name->setEditable(FALSE);
// add a row for the field id
$row = $table1->addRow();
$row->addCell(new TLabel(_t('Code')));
$cell = $row->addCell($id);
$cell->colspan = 3;
// add a row for the field title
$row = $table1->addRow();
$row->addCell(new TLabel(_t('Title')));
$cell = $row->addCell($title);
$cell->colspan = 3;
// add a row for the field isbn/call_nuber
$row = $table1->addRow();
$row->addCell(new TLabel('ISBN' . ': '));
$row->addCell($isbn);
$row->addCell(new TLabel(_t('Call')));
$row->addCell($call_number);
// add a row for the field author_id
$row = $table1->addRow();
$row->addCell(new TLabel(_t('Author') . ': '));
$row->addCell($author_id);
$row->addCell(new TLabel(_t('Name') . ': '));
$row->addCell($author_name);
// add a row for the field edition/volume
$row = $table1->addRow();
$row->addCell(new TLabel(_t('Edition') . ': '));
$row->addCell($edition);
$row->addCell(new TLabel(_t('Volume') . ': '));
$row->addCell($volume);
// add a row for the field collection_id/classification_id
$row = $table1->addRow();
$row->addCell(new TLabel(_t('Collection') . ': '));
$row->addCell($collection_id);
$row->addCell(new TLabel(_t('Classification') . ': '));
$row->addCell($classification_id);
// add a row for the field publisher_id
$row = $table1->addRow();
$row->addCell(new TLabel(_t('Publisher') . ': '));
$row->addCell($publisher_id);
$row->addCell(new TLabel(_t('Name') . ': '));
$row->addCell($publisher_name);
// add a row for the field publish_place
$row = $table1->addRow();
$row->addCell(new TLabel(_t('Place') . ': '));
$row->addCell($publish_place);
$row->addCell(new TLabel(_t('Date') . ': '));
$row->addCell($publish_date);
// add a row for the field abstract
$row = $table1->addRow();
$row->addCell(new TLabel(_t('Abstract') . ': '));
$cell = $row->addCell($abstract);
$cell->colspan = 3;
// add a row for the field notes
$row = $table1->addRow();
$row->addCell(new TLabel(_t('Notes') . ': '));
$cell = $row->addCell($notes);
$cell->colspan = 3;
// secundary authors
$authors = new TMultiField('author_list');
$sub_author_id = new TSeekButton('id');
$sub_author_name = new TEntry('name');
$sub_author_name->setEditable(FALSE);
$sub_author_id->setSize(50);
$sub_author_name->setSize(300);
$obj = new TStandardSeek();
$action = new TAction(array($obj, 'onSetup'));
$action->setParameter('database', 'library');
$action->setParameter('parent', 'form_Book');
$action->setParameter('model', 'Author');
$action->setParameter('display_field', 'name');
$action->setParameter('receive_key', 'author_list_id');
$action->setParameter('receive_field', 'author_list_name');
$sub_author_id->setAction($action);
$authors->setHeight(80);
$authors->setClass('Author');
$authors->addField('id', _t('Author'), $sub_author_id, 50);
$authors->addField('name', _t('Name'), $sub_author_name, 300);
$row = $table2->addRow();
$row->addCell($l = new TLabel(_t('Authors')));
$l->setFontStyle('b');
$row = $table2->addRow();
$row->addCell($authors);
// secundary subjects
$subjects = new TMultiField('subject_list');
$sub_subject_id = new TSeekButton('id');
$sub_subject_name = new TEntry('name');
$sub_subject_name->setEditable(FALSE);
$sub_subject_id->setSize(50);
$sub_subject_name->setSize(300);
$obj = new TStandardSeek();
$action = new TAction(array($obj, 'onSetup'));
$action->setParameter('database', 'library');
$action->setParameter('parent', 'form_Book');
$action->setParameter('model', 'Subject');
$action->setParameter('display_field', 'name');
$action->setParameter('receive_key', 'subject_list_id');
$action->setParameter('receive_field', 'subject_list_name');
$sub_subject_id->setAction($action);
$subjects->setHeight(80);
$subjects->setClass('Subject');
$subjects->addField('id', _t('Subject'), $sub_subject_id, 50);
$subjects->addField('name', _t('Name'), $sub_subject_name, 300);
$row = $table2->addRow();
$row->addCell($l = new TLabel(_t('Subjects')));
$l->setFontStyle('b');
$row = $table2->addRow();
$row->addCell($subjects);
// items
$items = new TMultiField('item_list');
$item_barcode = new TEntry('barcode');
$item_status_id = new TComboCombined('status_id', 'status_description');
$item_cost = new TEntry('cost');
$item_acquire_date = new TDate('acquire_date');
$item_notes = new TEntry('notes');
$item_status_id->setSize(150);
$item_cost->setSize(100);
$item_acquire_date->setSize(100);
TTransaction::open('library');
$rep = new TRepository('Status');
$objects = $rep->load(new TCriteria());
$options = array();
if ($objects) {
foreach ($objects as $object) {
$options[$object->id] = $object->description;
}
}
$item_status_id->addItems($options);
TTransaction::close();
$items->setHeight(140);
$items->setClass('Item');
$items->addField('barcode', _t('Barcode'), $item_barcode, 80);
$items->addField('status_id', _t('Status'), $item_status_id, 100);
$items->addField('cost', _t('Cost'), $item_cost, 80);
$items->addField('acquire_date', _t('Acquire date'), $item_acquire_date, 80);
$items->addField('notes', _t('Notes'), $item_notes, 150);
$row = $table3->addRow();
$row->addCell($l = new TLabel(_t('Items')));
$l->setFontStyle('b');
$row = $table3->addRow();
$row->addCell($items);
// create an action button (save)
$save_button = new TButton('save');
// define the button action
$save_button->setAction(new TAction(array($this, 'onSave')), _t('Save'));
$save_button->setImage('ico_save.png');
// add a row for the form action
$row = $table1->addRow();
$row->addCell($save_button);
// define wich are the form fields
$this->form->setFields(array($id, $title, $isbn, $call_number, $author_id, $author_name, $edition, $volume, $collection_id, $classification_id, $publisher_id, $publisher_name, $publish_place, $publish_date, $abstract, $notes, $authors, $subjects, $items, $save_button));
// add the form to the page
parent::add($this->form);
}
/**
* Class constructor
* Creates the page
*/
function __construct()
{
parent::__construct();
// create the notebook
$notebook = new TNotebook(620, 410);
// create the form
$this->form = new TForm();
// creates the notebook page
$table = new TTable();
// add the notebook inside the form
$this->form->add($table);
// adds the notebook page
$notebook->appendPage('Input elements', $this->form);
// create the form fields
$field1 = new TEntry('field1');
$field2 = new TEntry('field2');
$field3 = new TEntry('field3');
$field4 = new TEntry('field4');
$field5 = new TEntry('field5');
$field6 = new TPassword('field6');
$field7 = new TDate('field7');
$field8 = new TSpinner('field8');
$field9 = new TSlider('field9');
$field10 = new TText('field10');
$field1->setTip('Tip for field 1');
$field2->setTip('Tip for field 2');
$field3->setTip('Tip for field 3');
$field4->setTip('Tip for field 4');
$field5->setTip('Tip for field 5');
$field6->setTip('Tip for field 6');
$field7->setTip('Tip for field 7');
$field8->setTip('Tip for field 8');
$field9->setTip('Tip for field 9');
$field10->setTip('Tip for field 10');
$field2->setValue('123');
$field2->setEditable(FALSE);
$field3->setMask('99.999-999');
$field4->setMaxLength(10);
$field5->setCompletion(array('Allen', 'Albert', 'Alberto', 'Alladin'));
$field7->setSize(100);
$field8->setRange(0, 100, 10);
$field9->setRange(0, 100, 10);
$field8->setValue(30);
$field9->setValue(50);
$field10->setSize(300, 80);
// add a row for one field
$row = $table->addRow();
$row->addCell(new TLabel('TEntry object:'));
$cell = $row->addCell($field1);
// add a row for one field
$row = $table->addRow();
$row->addCell(new TLabel('TEntry not editable:'));
$cell = $row->addCell($field2);
// add a row for one field
$row = $table->addRow();
$row->addCell(new TLabel('TEntry with mask:'));
$cell = $row->addCell($field3);
$cell = $row->addCell(new TLabel('99.999-999'));
// add a row for one field
$row = $table->addRow();
$row->addCell(new TLabel('TEntry with maxlength (10):'));
$cell = $row->addCell($field4);
// add a row for one field
$row = $table->addRow();
$row->addCell(new TLabel('TEntry with completion (a..):'));
$cell = $row->addCell($field5);
// add a row for one field
$row = $table->addRow();
$row->addCell(new TLabel('TPassword object:'));
$cell = $row->addCell($field6);
// add a row for one field
$row = $table->addRow();
$row->addCell(new TLabel('TDate Object:'));
$cell = $row->addCell($field7);
// add a row for one field
$row = $table->addRow();
$row->addCell(new TLabel('Spinner Object:'));
$cell = $row->addCell($field8);
// add a row for one field
$row = $table->addRow();
$row->addCell(new TLabel('Slider Object:'));
$cell = $row->addCell($field9);
// add a row for one field
$row = $table->addRow();
$row->addCell(new TLabel('TText Object:'));
$cell = $row->addCell($field10);
// creates the action button
$button1 = new TButton('action1');
// define the button action
$button1->setAction(new TAction(array($this, 'onSave')), 'Save');
$button1->setImage('ico_save.png');
// define wich are the form fields
$this->form->setFields(array($field1, $field2, $field3, $field4, $field5, $field6, $field7, $field8, $field9, $field10, $button1));
// add a row for the button
$row = $table->addRow();
$row->addCell($button1);
// add the form inside the page
parent::add($notebook);
}
/**
* constructor method
*/
public function __construct()
{
parent::__construct();
new TSession();
// creates the form
$this->form = new TForm('form_city_Seek');
// creates the table
$table = new TTable();
// add the table inside the form
$this->form->add($table);
// create the form fields
$name = new TEntry('name');
$code = new TEntry('id');
$crm_id = new TDBCombo('crm_id', 'db_crmbf', 'CRM', 'id', 'titulo');
$tiporegistro_id = new TDBCombo('tiporegistro_id', 'db_crmbf', 'RegistroTipo', 'id', 'nome');
$registro = new TText('registro');
$temporegistro = new TEntry('tempo_registro');
// $temporegistro->setEditable(false);
$dataregistro = new TDate('data_registro');
$hora_registro = new TEntry('hora_registro');
$numero_registro = new TEntry('numero_registro');
// keep the session value
// $name->setValue(TSession::getValue('test_city_name'));
// add the field inside the table
// $row=$table->addRow();
// $row->addCell(new TLabel('Name:'));
// $row->addCell($name);
$code->setEditable(FALSE);
$code->setSize(100);
$crm_id->setSize(320);
$registro->setSize(320);
$temporegistro->setSize(160);
//$temporegistro->setValue(date("d/m/Y H:i:s"));
$tiporegistro_id->setSize(160);
//$dataregistro->setRange(0,1000,1);
$dataregistro->setSize(90);
// $hora_registro->setRange(0,100,1);
$hora_registro->setSize(150);
$hora_registro->setTip('Horario EX: 8:14');
$numero_registro->setSize(320);
$row = $table->addRow();
$row->addCell(new TLabel('Code:'));
$row->addCell($code);
// add a row for the field name
$row = $table->addRow();
$row->addCell(new TLabel('CRM Titulo:'));
$cell = $row->addCell($crm_id);
// add a row for the field Telefone
$row = $table->addRow();
$row->addCell(new TLabel('Tipo Registro:'));
$cell = $row->addCell($tiporegistro_id);
// add a row for the field Email
$row = $table->addRow();
$row->addCell(new TLabel('Tempo:'));
$cell = $row->addCell($temporegistro);
// add a row for the field celular
$row = $table->addRow();
$row->addCell(new TLabel('Data:'));
$cell = $row->addCell($dataregistro);
// add a row for the field skype
$row = $table->addRow();
$row->addCell(new TLabel('Hora:'));
$cell = $row->addCell($hora_registro);
// add a row for the field endereco
$row = $table->addRow();
$row->addCell(new TLabel('Numero Registro:'));
$row->addCell($numero_registro);
// add a row for the field name
$row = $table->addRow();
$row->addCell(new TLabel('Registro:'));
$cell = $row->addCell($registro);
// create a find button
$find_button = new TButton('search');
// define the button action
$find_button->setAction(new TAction(array($this, 'onSearch')), 'Search');
$find_button->setImage('ico_find.png');
// add a row for the find button
$row = $table->addRow();
$row->addCell($find_button);
// define wich are the form fields
$this->form->setFields(array($name, $find_button));
// create the datagrid
$this->datagrid = new TDataGrid();
// create the datagrid columns
$id = new TDataGridColumn('id', 'Id', 'right', 70);
$name = new TDataGridColumn('name', 'Name', 'left', 220);
$state = new TDataGridColumn('state', 'Estado', 'left', 80);
$order1 = new TAction(array($this, 'onReload'));
$order2 = new TAction(array($this, 'onReload'));
$order1->setParameter('order', 'id');
$order2->setParameter('order', 'name');
// define the column actions
$id->setAction($order1);
$name->setAction($order2);
// add the columns inside the datagrid
$this->datagrid->addColumn($id);
$this->datagrid->addColumn($name);
$this->datagrid->addColumn($state);
// create one datagrid action
$action1 = new TDataGridAction(array($this, 'onSelect'));
$action1->setLabel('Selecionar');
$action1->setImage('ico_apply.png');
$action1->setField('id');
// add the action to the datagrid
$this->datagrid->addAction($action1);
// create the datagrid model
$this->datagrid->createModel();
// create the page navigator
$this->pageNavigation = new TPageNavigation();
$this->pageNavigation->setAction(new TAction(array($this, 'onReload')));
$this->pageNavigation->setWidth($this->datagrid->getWidth());
// create a table for layout
$table = new TTable();
// create a row for the form
$row = $table->addRow();
$row->addCell($this->form);
// create a row for the datagrid
$row = $table->addRow();
$row->addCell($this->datagrid);
// create a row for the page navigator
$row = $table->addRow();
$row->addCell($this->pageNavigation);
// add the table inside the page
parent::add($table);
}
/**
*
*/
public function makeTDate($properties)
{
$widget = new TDate((string) $properties->{'name'});
$widget->setValue((string) $properties->{'value'});
$widget->setSize((int) $properties->{'width'});
$widget->setEditable((string) $properties->{'editable'});
if ((string) $properties->{'mask'}) {
$widget->setMask((string) $properties->{'mask'});
}
if (isset($properties->{'tip'})) {
$widget->setTip((string) $properties->{'tip'});
}
if (isset($properties->{'required'}) and $properties->{'required'} == '1') {
$widget->addValidation((string) $properties->{'name'}, new TRequiredValidator());
}
$this->fields[] = $widget;
$this->fieldsByName[(string) $properties->{'name'}] = $widget;
return $widget;
}
/**
* Class constructor
* Creates the page and the registration form
*/
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 == 'CUSTOMER') {
throw new Exception(_t('Permission denied'));
}
TTransaction::close();
$table = new TTable();
// creates the form
$this->form = new TForm('form_Issue');
$this->form->add($table);
$table->width = '100%';
$this->form->style = 'width: 750px';
$this->form->class = 'tform';
$table->addRowSet(new TLabel(_t('Issue')), '')->class = 'tformtitle';
$table1 = new TTable();
$table2 = new TTable();
// create the form fields
$id = new TEntry('id');
$id_user = new TDBCombo('id_user', 'changeman', 'Member', 'id', 'name');
$id_status = new TDBCombo('id_status', 'changeman', 'Status', 'id', 'complete_description');
$id_project = new TDBCombo('id_project', 'changeman', 'Project', 'id', 'description');
$id_priority = new TDBCombo('id_priority', 'changeman', 'Priority', 'id', 'description_translated');
$id_category = new TDBCombo('id_category', 'changeman', 'Category', 'id', 'description_translated');
$id_release = new TDBCombo('id_release', 'changeman', 'Release', 'id', 'name');
$id_member = new TDBCombo('id_member', 'changeman', 'Member', 'id', 'name');
$register_date = new TDate('register_date');
$close_date = new TDate('close_date');
$time = new TEntry('issue_time');
$title = new TEntry('title');
$description = new THtmlEditor('description');
$solution = new THtmlEditor('solution');
$id_user->addValidation(_t('User'), new TRequiredValidator());
$id_status->addValidation(_t('Status'), new TRequiredValidator());
$id_project->addValidation(_t('Project'), new TRequiredValidator());
$id_priority->addValidation(_t('Priority'), new TRequiredValidator());
$id_category->addValidation(_t('Category'), new TRequiredValidator());
$register_date->addValidation(_t('Start date'), new TRequiredValidator());
$title->addValidation(_t('Title'), new TRequiredValidator());
$description->addValidation(_t('Description'), new TRequiredValidator());
// define the sizes
$id->setSize(100);
$id_user->setSize(200);
$id_status->setSize(200);
$id_project->setSize(200);
$id_priority->setSize(200);
$id_category->setSize(200);
$id_release->setSize(200);
$id_member->setSize(200);
$register_date->setSize(100);
$close_date->setSize(100);
$time->setSize(200);
$title->setSize(200, 40);
$description->setSize(680, 300);
$solution->setSize(680, 300);
$register_date->setMask('yyyy-mm-dd');
$close_date->setMask('yyyy-mm-dd');
$id->setEditable(FALSE);
// add a row for the field id
$table1->addRowSet(new TLabel('ID:'), $id);
$table1->addRowSet(new TLabel(_t('User') . ': '), $id_user);
$table1->addRowSet(new TLabel(_t('Status') . ': '), $id_status);
$table1->addRowSet(new TLabel(_t('Project') . ': '), $id_project);
$table1->addRowSet(new TLabel(_t('Priority') . ': '), $id_priority);
$table1->addRowSet(new TLabel(_t('Category') . ': '), $id_category);
$table2->addRowSet(new TLabel(_t('Release') . ': '), $id_release);
$table2->addRowSet(new TLabel(_t('Assigned to')), $id_member);
$table2->addRowSet(new TLabel(_t('Start date') . ':'), $register_date);
$table2->addRowSet(new TLabel(_t('Due date') . ':'), $close_date);
$table2->addRowSet(new TLabel(_t('Time') . ':'), $time);
$table2->addRowSet(new TLabel(_t('Title') . ':'), $title);
$row = $table->addRow();
$row->addCell($table1);
$row->addCell($table2);
$subnotebook = new TNotebook();
$subnotebook->setSize(710, 320);
$subnotebook->style = 'padding: 50px';
$subnotebook->appendPage(_t('Description'), $description);
$subnotebook->appendPage(_t('Solution'), $solution);
$hbox = new THBox();
$hbox->add($subnotebook);
$hbox->style = 'margin: 10px';
$row = $table->addRow();
$cell = $row->addCell($hbox);
$cell->colspan = 3;
// create an action button (save)
$save_button = new TButton('save');
// define the button action
$save_button->setAction(new TAction(array($this, 'onSave')), _t('Save'));
$save_button->setImage('ico_save.png');
$table->addRowSet($save_button, '')->class = 'tformaction';
// define wich are the form fields
$this->form->setFields(array($id, $id_user, $id_status, $id_project, $id_priority, $id_category, $id_release, $id_member, $register_date, $close_date, $time, $title, $description, $solution, $save_button));
// add the form to the page
parent::add($this->form);
}
/**
* Class constructor
* Creates the page
*/
function __construct()
{
parent::__construct();
// create the notebook
$notebook = new TNotebook(620, 340);
// create the form
$this->form = new TForm();
// creates the notebook page
$table = new TTable();
// add the notebook inside the form
$this->form->add($table);
// adds the notebook page
$notebook->appendPage('Input elements', $this->form);
// create the form fields
$field1 = new TEntry('field1');
$field2 = new TEntry('field2');
$field3 = new TEntry('field3');
$field4 = new TEntry('field4');
$field5 = new TPassword('field5');
$field6 = new TDate('field6');
$field7 = new TSpinner('field7');
$field8 = new TSlider('field8');
$field9 = new TText('field9');
$field1->setTip('Tip for field 1');
$field2->setTip('Tip for field 2');
$field3->setTip('Tip for field 3');
$field4->setTip('Tip for field 4');
$field5->setTip('Tip for field 5');
$field6->setTip('Tip for field 6');
$field7->setTip('Tip for field 7');
$field8->setTip('Tip for field 8');
$field9->setTip('Tip for field 9');
$field2->setValue('123');
$field2->setEditable(FALSE);
$field3->setMask('99.999-999');
$field4->setMaxLength(10);
$field6->setSize(100);
$field7->setRange(0, 100, 10);
$field8->setRange(0, 100, 10);
$field7->setValue(30);
$field8->setValue(50);
$field9->setSize(300, 50);
// add rows for the fields
$table->addRowSet(new TLabel('TEntry object:'), $field1);
$table->addRowSet(new TLabel('TEntry not editable:'), $field2);
$table->addRowSet(new TLabel('TEntry with mask:'), $field3, new TLabel('99.999-999'));
$table->addRowSet(new TLabel('TEntry with maxlength (10):'), $field4);
$table->addRowSet(new TLabel('TPassword object:'), $field5);
$table->addRowSet(new TLabel('TDate Object:'), $field6);
$table->addRowSet(new TLabel('Spinner Object:'), $field7);
$table->addRowSet(new TLabel('Slider Object:'), $field8);
$table->addRowSet(new TLabel('TText Object:'), $field9);
// creates the action button
$button1 = new TButton('action1');
// define the button action
$button1->setAction(new TAction(array($this, 'onSave')), 'Save');
$button1->setImage('ico_save.png');
// define wich are the form fields
$this->form->setFields(array($field1, $field2, $field3, $field4, $field5, $field6, $field7, $field8, $field9, $button1));
// add a row for the button
$row = $table->addRow();
$row->addCell($button1);
// wrap the page content using vertical box
$vbox = new TVBox();
$vbox->add(new TXMLBreadCrumb('menu.xml', __CLASS__));
$vbox->add($notebook);
parent::add($vbox);
}
/**
* Class constructor
* Creates the page and the registration form
*/
function __construct()
{
parent::__construct();
// creates the form
$this->form = new TForm('form_Ticket');
$this->form->class = 'tform';
// CSS class
$this->form->style = 'width: 500px';
// creates the table container
$table = new TTable();
$table->width = '110%';
// add the table inside the form
$this->form->add($table);
// define the form title
$row = $table->addRow();
$row->class = 'tformtitle';
// CSS class
$row->addCell(new TLabel('Resumo de Tickets e Atividades'))->colspan = 3;
// create the form fields
$ticket = new TEntry('ticket_id');
$ticket->setMask('99999');
$solicitante_id = new TSeekButton('solicitante_id');
$solicitante_nome = new TEntry('solicitante_nome');
$obj = new TicketPessoaSeek();
$action = new TAction(array($obj, 'onReload'));
$solicitante_id->setAction($action);
$solicitante_nome->setEditable(FALSE);
$criteria = new TCriteria();
$criteria->add(new TFilter("origem", "=", 1));
$criteria->add(new TFilter("ativo", "=", 1));
$criteria->add(new TFilter("codigo_cadastro_origem", "=", 100));
$responsavel_id = new TDBCombo('responsavel_id', 'atividade', 'Pessoa', 'pessoa_codigo', 'pessoa_nome', 'pessoa_nome', $criteria);
$criteria = new TCriteria();
$criteria->add(new TFilter('enttipent', '=', 1));
$entcodent = new TDBComboMultiValue('entcodent', 'atividade', 'Entidade', 'entcodent', array(0 => 'entcodent', 1 => 'entrazsoc'), 'entcodent', $criteria);
$status_ticket_id = new TDBCombo('status_ticket_id', 'atividade', 'StatusTicket', 'id', 'nome');
$prioridade_id = new TDBCombo('prioridade_id', 'atividade', 'Prioridade', 'id', 'nome');
$tipo_ticket_id = new TDBCombo('tipo_ticket_id', 'atividade', 'TipoTicket', 'id', 'nome');
$ticket_sistema_id = new TDBCombo('ticket_sistema_id', 'atividade', 'Sistema', 'id', 'nome');
$atividade_sistema_id = new TDBCombo('atividade_sistema_id', 'atividade', 'Sistema', 'id', 'nome');
$saldo = new TCombo('saldo');
$combo_saldo = array();
$combo_saldo['c'] = 'Com saldo';
$saldo->addItems($combo_saldo);
$data_prevista = new TDate('data_prevista');
$data_prevista->setMask('dd/mm/yyyy');
$dataAtividadeInicio = new TDate('data_atividade_inicio');
$dataAtividadeInicio->setMask('dd/mm/yyyy');
$dataAtividadeInicio->setValue('01/' . date('m/Y'));
$dataAtividadeFinal = new TDate('data_atividade_final');
$dataAtividadeFinal->setMask('dd/mm/yyyy');
$dataAtividadeFinal->setValue(date('d/m/Y'));
$criteria = new TCriteria();
$criteria->add(new TFilter("origem", "=", 1));
$criteria->add(new TFilter("ativo", "=", 1));
$criteria->add(new TFilter("codigo_cadastro_origem", "=", 100));
$colaborador_id = new TDBCombo('colaborador_id', 'atividade', 'Pessoa', 'pessoa_codigo', 'pessoa_nome', 'pessoa_nome', $criteria);
$tipo_atividade_id = new TDBCombo('tipo_atividade_id', 'atividade', 'TipoAtividade', 'id', 'nome', 'nome');
$pesquisa_master = new TEntry('pesquisa_master');
$tipo = new TRadioGroup('tipo');
$output_type = new TRadioGroup('output_type');
// define the sizes
$ticket->setSize(100);
$solicitante_id->setSize(30);
$solicitante_nome->setSize(245);
$responsavel_id->setSize(300);
$colaborador_id->setSize(300);
$entcodent->setSize(300);
$status_ticket_id->setSize(100);
$prioridade_id->setSize(100);
$tipo_ticket_id->setSize(200);
$ticket_sistema_id->setSize(200);
$atividade_sistema_id->setSize(200);
$saldo->setSize(100);
$data_prevista->setSize(100);
$dataAtividadeInicio->setSize(100);
$dataAtividadeFinal->setSize(100);
$tipo->setSize(100);
$output_type->setSize(100);
// validations
$output_type->addValidation('Output', new TRequiredValidator());
// add one row for each form field
// creates a frame
$frame = new TFrame();
$frame->oid = 'frame-measures';
$frame->setLegend('Tickets:');
$row = $table->addRow();
$cell = $row->addCell($frame);
$cell->colspan = 2;
$frame1 = new TTable();
$frame->add($frame1);
$frame1->addRowSet(new TLabel('Ticket inicial:'), $ticket);
$frame1->addRowSet(new TLabel('Solicitante:'), array($solicitante_id, $solicitante_nome));
$frame1->addRowSet(new TLabel('Responsável:'), $responsavel_id);
$frame1->addRowSet(new TLabel('Cliente:'), $entcodent);
$frame1->addRowSet(new TLabel('Tipo:'), $tipo_ticket_id);
$frame1->addRowSet(new TLabel('Sistema:'), $ticket_sistema_id);
$frame1->addRowSet(new TLabel('Status:'), $status_ticket_id);
$frame1->addRowSet(new TLabel('Prioridade:'), $prioridade_id);
$frame1->addRowSet(new TLabel('Saldo:'), $saldo);
$frame1->addRowSet(new TLabel('Dt. Prevista limite:'), $data_prevista);
// creates a frame
$frame = new TFrame();
$frame->oid = 'frame-measures';
$frame->setLegend('Atividades:');
$row = $table->addRow();
$cell = $row->addCell($frame);
$cell->colspan = 2;
$frame2 = new TTable();
$frame->add($frame2);
$frame2->addRowSet(new TLabel('Dt. Atividades inicio:'), array($dataAtividadeInicio, $label_data_fim = new TLabel('Fim:'), $dataAtividadeFinal));
$label_data_fim->setSize(48);
$frame2->addRowSet(new TLabel('Atividades colaborador:'), $colaborador_id);
$frame2->addRowSet(new TLabel('Tipo atividade:'), $tipo_atividade_id);
$frame2->addRowSet(new TLabel('Sistema:'), $atividade_sistema_id);
// creates a frame
$frame = new TFrame();
$frame->oid = 'frame-measures';
$frame->setLegend('Pesquisa Master:');
$row = $table->addRow();
$cell = $row->addCell($frame);
$cell->colspan = 2;
$frame3 = new TTable();
$frame->add($frame3);
$frame3->addRowSet(new TLabel('<nobr>Por palavra:</nobr>'), $pesquisa_master);
$frame3->addRowSet(new TLabel(''), new TLabel('Essa pesquisa busca pelo titulo do ticket e da descrição da atividade'));
$table->addRowSet(new TLabel('Relatório'), $tipo);
$table->addRowSet(new TLabel('Output:'), $output_type);
$this->form->setFields(array($ticket, $solicitante_id, $solicitante_nome, $responsavel_id, $entcodent, $status_ticket_id, $prioridade_id, $saldo, $tipo_ticket_id, $ticket_sistema_id, $data_prevista, $dataAtividadeInicio, $dataAtividadeFinal, $colaborador_id, $tipo_atividade_id, $atividade_sistema_id, $pesquisa_master, $tipo, $output_type));
$tipo->addItems(array('s' => 'Sintético', 'a' => 'Analitico'));
$tipo->setValue('s');
$tipo->setLayout('horizontal');
//$output_type->addItems(array('html'=>'HTML', 'pdf'=>'PDF', 'rtf'=>'RTF'));
$output_type->addItems(array('html' => 'HTML'));
$output_type->setValue('html');
$output_type->setLayout('horizontal');
$generate_button = TButton::create('generate', array($this, 'onGenerate'), _t('Generate'), 'fa:check-circle-o green');
$this->form->addField($generate_button);
$change_data = new TAction(array($this, 'onChangeData'));
$dataAtividadeInicio->setExitAction($change_data);
$dataAtividadeFinal->setExitAction($change_data);
// add a row for the form action
$table->addRowSet($generate_button, '')->class = 'tformaction';
parent::add($this->form);
}
/**
* Class constructor
* Creates the page and the registration form
*/
public function __construct()
{
parent::__construct();
parent::setSize(640, 350);
parent::setTitle('Event');
// creates the form
$this->form = new TForm('form_Event');
$this->form->class = 'tform';
// CSS class
$this->form->style = 'width: 600px';
// add a table inside form
$table = new TTable();
$table->width = '100%';
$this->form->add($table);
// add a row for the form title
$row = $table->addRow();
$row->class = 'tformtitle';
// CSS class
$row->addCell(new TLabel('Event'))->colspan = 2;
$hours = array();
$durations = array();
for ($n = 0; $n < 24; $n++) {
$hours[$n] = "{$n}:00";
$durations[$n + 1] = $n + 1 . ' h';
}
array_pop($durations);
// create the form fields
$id = new TEntry('id');
$event_date = new TDate('event_date');
$start_hour = new TCombo('start_hour');
$duration = new TCombo('duration');
$title = new TEntry('title');
$description = new TText('description');
$start_hour->addItems($hours);
$duration->addItems($durations);
$id->setEditable(FALSE);
// define the sizes
$id->setSize(40);
$event_date->setSize(100);
$start_hour->setSize(100);
$duration->setSize(100);
$title->setSize(400);
$description->setSize(400, 50);
// add one row for each form field
$table->addRowSet(new TLabel('ID:'), $id);
$table->addRowSet(new TLabel('Event Date:'), $event_date);
$table->addRowSet(new TLabel('Start Hour:'), $start_hour);
$table->addRowSet(new TLabel('Duration:'), $duration);
$table->addRowSet(new TLabel('Title:'), $title);
$table->addRowSet(new TLabel('Description:'), $description);
// create an action button (save)
$save_button = new TButton('save');
$save_button->setAction(new TAction(array($this, 'onSave')), _t('Save'));
$save_button->setImage('ico_save.png');
// create an new button (edit with no parameters)
$new_button = new TButton('new');
$new_button->setAction(new TAction(array($this, 'onEdit')), _t('Clear'));
$new_button->setImage('ico_new.png');
$this->form->setFields(array($id, $event_date, $start_hour, $duration, $title, $description, $save_button, $new_button));
$buttons_box = new THBox();
$buttons_box->add($save_button);
$buttons_box->add($new_button);
// add a row for the form action
$row = $table->addRow();
$row->class = 'tformaction';
// CSS class
$row->addCell($buttons_box)->colspan = 2;
parent::add($this->form);
}
/**
* Class constructor
* Creates the page and the registration form
*/
function __construct()
{
parent::__construct();
// security check
if (TSession::getValue('logged') !== TRUE) {
throw new Exception(_t('Not logged'));
}
// creates a table
$table = new TTable();
$table1 = new TTable();
$table2 = new TTable();
// creates the form
$this->form = new TForm('form_Issue');
$this->form->class = 'tform';
$this->form->style = 'width: 750px';
$table->width = '100%';
$this->form->add($table);
$table->addRowSet(new TLabel(_t('Issue')), '')->class = 'tformtitle';
// add the table inside the form
$this->form->add($table);
// create the form fields
$id_project = new TCombo('id_project');
$id_priority = new TDBCombo('id_priority', 'changeman', 'Priority', 'id', 'description_translated');
$id_category = new TDBCombo('id_category', 'changeman', 'Category', 'id', 'description_translated');
$register_date = new TDate('register_date');
$time = new TEntry('issue_time');
$title = new TEntry('title');
$description = new THtmlEditor('description');
$file = new TFile('file');
$register_date->setValue(date('Y-m-d'));
$register_date->setMask('yyyy-mm-dd');
$time->setValue(date('H:i'));
$id_priority->setValue(2);
// default
$description->style = 'margin: 10px';
TTransaction::open('changeman');
$member = Member::newFromLogin(TSession::getValue('login'));
$member_projects = $member->getProjectsList();
$id_project->addItems($member_projects);
// if just one project, its the default
if (count($member_projects) == 1) {
$project_keys = array_keys($member_projects);
$id_project->setValue($project_keys[0]);
}
TTransaction::close();
$id_project->addValidation(_t('Project'), new TRequiredValidator());
$id_priority->addValidation(_t('Priority'), new TRequiredValidator());
$id_category->addValidation(_t('Category'), new TRequiredValidator());
$register_date->addValidation(_t('Start date'), new TRequiredValidator());
$title->addValidation(_t('Title'), new TRequiredValidator());
$description->addValidation(_t('Description'), new TRequiredValidator());
// define the sizes
$id_project->setSize(200);
$id_priority->setSize(200);
$id_category->setSize(200);
$register_date->setSize(100);
$file->setSize(250);
$time->setSize(50);
$time->setMask('99:99');
$title->setSize(200, 40);
$description->setSize(680, 300);
$table1->addRowSet(new TLabel(_t('Project') . ': '), $id_project);
$table1->addRowSet(new TLabel(_t('Priority') . ': '), $id_priority);
$table1->addRowSet(new TLabel(_t('Category') . ': '), $id_category);
$table2->addRowSet(new TLabel(_t('Start date') . ':'), array($register_date, $time));
$table2->addRowSet(new TLabel(_t('Title') . ':'), $title);
$table2->addRowSet(new TLabel(_t('File') . ':'), $file);
$row = $table->addRow();
$row->addCell($table1);
$row->addCell($table2);
$label_description = new TLabel(_t('Description'));
$label_description->setFontStyle('b');
$row = $table->addRow();
$row->addCell($label_description);
$row = $table->addRow();
$cell = $row->addCell($description);
$cell->colspan = 3;
// create an action button (save)
$save_button = new TButton('save');
// define the button action
$save_button->setAction(new TAction(array($this, 'onSave')), _t('Save'));
$save_button->setImage('ico_save.png');
$table->addRowSet($save_button, '')->class = 'tformaction';
// define wich are the form fields
$this->form->setFields(array($id_project, $id_priority, $id_category, $register_date, $time, $title, $file, $description, $save_button));
// add the form to the page
parent::add($this->form);
}
