/**
* Class constructor
* Creates the page, the form and the listing
*/
public function __construct()
{
parent::__construct();
// creates the form
$this->form = new TForm('form_Desaprovar_Cessao');
$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('Desaprovar Cessao'))->colspan = 2;
// create the form fields
$numeroCessao = new TEntry('numeroCessao');
$numeroCessao->setTip('Número do processo gerado no SIGA');
// define the sizes
$numeroCessao->setSize(200);
// add one row for each form field
$table->addRowSet(new TLabel('Nº da Cessão:'), $numeroCessao);
$this->form->setFields(array($numeroCessao));
// keep the form filled during navigation with session data
$this->form->setData(TSession::getValue('Cessao_filter_data'));
// create two action buttons to the form
$find_button = TButton::create('find', array($this, 'onSearch'), 'Buscar', 'ico_find.png');
//$new_button = TButton::create('new', array('CessaoForm', 'onEdit'), 'Novo', 'ico_new.png');
$this->form->addField($find_button);
//$this->form->addField($new_button);
$buttons_box = new THBox();
$buttons_box->add($find_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;
// creates a Datagrid
parent::include_css('app/resources/custom-table.css');
$this->datagrid = new TDataGrid();
$this->datagrid->class = 'tdatagrid_table customized-table';
$this->datagrid->setHeight(320);
$this->datagrid->makeScrollable();
$this->datagrid->disableDefaultClick();
// creates the datagrid columns
$id = new TDataGridColumn('id', 'ID', 'right', 80);
$srp = new TDataGridColumn('numeroSRP', 'Nº SRP', 'left', 100);
$numeroCessao = new TDataGridColumn('numeroCessao', 'Nº da Cessão', 'left', 250);
$data = new TDataGridColumn('emissao', 'Data', 'left', 100);
// add the columns to the DataGrid
$this->datagrid->addColumn($id);
$this->datagrid->addColumn($srp);
$this->datagrid->addColumn($numeroCessao);
$this->datagrid->addColumn($data);
// creates two datagrid actions
$action1 = new TDataGridAction(array($this, 'onQuestionAprovarCessao'));
$action1->setLabel('Desaprovar Cessao');
$action1->setImage('fa:history fa-fw');
$action1->setField('id');
// add the actions to the datagrid
$this->datagrid->addAction($action1);
// create the datagrid model
$this->datagrid->createModel();
//limpar a sessao com detalhes de itens e cessao
TSession::delValue('cessao_itens');
TSession::delValue('SRP_id');
TSession::delValue('form_cessao');
// create the page container
//$container = TVBox::pack( $this->form, $this->datagrid);
$container = new TTable();
$container->addRow()->addCell(new TXMLBreadCrumb('menu.xml', __CLASS__));
$container->addRow()->addCell($this->form);
$container->addRow()->addCell($this->datagrid);
//$container->addRow()->addCell($this->pageNavigation);
parent::add($container);
}
public function onSelect($param)
{
try {
//var_dump($param);
$key = $param['key'];
if (!$key) {
return;
}
TTransaction::open('saciq');
//$srp = new Srp($key);
$repository = new TRepository('Srp');
$criteria = new TCriteria();
$criteria->add(new TFilter('numeroSRP', '=', $key));
$srps = $repository->load($criteria);
if (count($srps) > 0) {
$srp = $srps[0];
}
if ($srp->estaVencida()) {
new TMessage('error', 'SRP Vencida!');
return;
}
$oldSRP = NULL;
if ($oldSRP != TSession::getValue('SRP_id')) {
$oldSRP = TSession::getValue('SRP_id');
}
if ($oldSRP != $srp->id) {
if (TSession::getValue('cessao_itens')) {
$reloadForm = true;
}
TSession::delValue('cessao_itens');
$obj = new stdClass();
$obj->numeroItem = '';
$obj->descricaoSumaria = '';
$obj->valorUnitario = '';
$obj->quantidade = '';
//$obj->prazoEntrega = '60 Dias';
//$obj->justificativa = '';
TForm::sendData('form_itens', $obj);
}
TSession::setValue('SRP_id', $srp->id);
$obj = new stdClass();
$obj->numeroSRP = $srp->numeroSRP;
$obj->nome = $srp->nome;
$obj->numeroProcessoOrigem = $srp->numeroProcesso;
$obj->uasg = $srp->uasg;
$obj->validade = TDate::date2br($srp->validade);
TForm::sendData('form_cessao', $obj);
TSession::setValue('form_cessao', $obj);
if (isset($reloadForm) && $reloadForm) {
TScript::create("__adianti_load_page2('engine.php?class=CessaoForm');");
//new TScript("__adianti_load_page('engine?class=CessaoForm');");
}
//AdiantiCoreApplication::executeMethod('CessaoForm','onReload');
TTransaction::close();
parent::closeWindow();
} catch (Exception $e) {
$obj = new stdClass();
$obj->numeroSRP = '';
$obj->nome = '';
$obj->numeroProcesso = '';
$obj->uasg = '';
$obj->validade = '';
TForm::sendData('cessao_form', $obj);
TTransaction::rollback();
}
}
/**
* Class constructor
* Creates the page, the form and the listing
*/
public function __construct()
{
parent::__construct();
// creates the form
$this->form = new TForm('form_search_Requisicao');
$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('Consulta Requisicao'))->colspan = 2;
// create the form fields
$numeroProcesso = new TEntry('numeroProcesso');
// define the sizes
$numeroProcesso->setSize(200);
$numeroProcesso->setMaxLength(30);
$numeroProcesso->setTip('Número do processo gerado no SIGA');
// add one row for each form field
$table->addRowSet(new TLabel('Nº do Processo:'), $numeroProcesso);
$this->form->setFields(array($numeroProcesso));
// keep the form filled during navigation with session data
$this->form->setData(TSession::getValue('Requisicao_filter_data'));
// create two action buttons to the form
$find_button = TButton::create('find', array($this, 'onSearch'), 'Buscar', 'ico_find.png');
$new_button = TButton::create('new', array('RequisicaoForm', 'onEdit'), 'Novo', 'ico_new.png');
$this->form->addField($find_button);
$this->form->addField($new_button);
$buttons_box = new THBox();
$buttons_box->add($find_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;
// creates a Datagrid
parent::include_css('app/resources/custom-table.css');
$this->datagrid = new TDataGrid();
$this->datagrid->class = 'tdatagrid_table customized-table';
$this->datagrid->setHeight(320);
// creates the datagrid columns
$id = new TDataGridColumn('id', 'ID', 'right', 80);
$srp = new TDataGridColumn('numeroSRP', 'Nº SRP', 'left', 100);
$numeroProcesso = new TDataGridColumn('numeroProcesso', 'Nº do processo', 'left', 250);
$data = new TDataGridColumn('emissao', 'Data', 'left', 100);
$id->setTransformer(array($this, 'rowFormat'));
// add the columns to the DataGrid
$this->datagrid->addColumn($id);
$this->datagrid->addColumn($srp);
$this->datagrid->addColumn($numeroProcesso);
$this->datagrid->addColumn($data);
// creates two datagrid actions
$action1 = new TDataGridAction(array('RequisicaoForm', 'onEdit'));
//$action1 = new TDataGridAction(array($this, 'onCheckValidadeSRP'));
$action1->setLabel('Editar');
$action1->setImage('ico_edit.png');
$action1->setField('id');
$action1->setDisplayCondition(array($this, 'onDisplayConditionEdit'));
$action2 = new TDataGridAction(array($this, 'onDelete'));
$action2->setLabel('Excluir');
$action2->setImage('ico_delete.png');
$action2->setField('id');
$actAprovar = new TDataGridAction(array($this, 'onQuestionAprovarRequisicao'));
$actAprovar->setLabel('Aprovar Requisição');
$actAprovar->setImage('fa:check fa-fw');
$actAprovar->setField('id');
$actAprovar->setDisplayCondition(array($this, 'onDisplayConditionEdit'));
// add the actions to the datagrid
$this->datagrid->addAction($action1);
$this->datagrid->addAction($action2);
$this->datagrid->addAction($actAprovar);
// 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());
//limpar a sessao com detalhes de itens e requisicao
TSession::delValue('requisicao_itens');
TSession::delValue('SRP_id');
TSession::delValue('form_requisicao');
// create the page container
//$container = TVBox::pack($this->form, $this->datagrid, $this->pageNavigation);
$container = new TTable();
$container->addRow()->addCell(new TXMLBreadCrumb('menu.xml', __CLASS__));
$container->addRow()->addCell($this->form);
$container->addRow()->addCell($this->datagrid);
$container->addRow()->addCell($this->pageNavigation);
parent::add($container);
}
public function onSave($param)
{
try {
$this->form_requisicao->validate();
// validate form data
$form_requisicao_data = $this->form_requisicao->getData();
$form_requisicao = TSession::getValue('form_requisicao');
$form_requisicao->numeroProcesso = $form_requisicao_data->numeroProcesso;
$form_requisicao->emissao = $form_requisicao_data->emissao;
$requisicao_itens = TSession::getValue('requisicao_itens');
if (!isset($requisicao_itens) || count($requisicao_itens) == 0) {
new TMessage('error', 'Insira ao menos 1 item');
return;
}
TTransaction::open('saciq');
//TTransaction::setLogger(new \Adianti\Log\TLoggerTXT("c:\\array\\LOG".date("Ymd-His").".txt"));
if ($requisicao_itens) {
$id = isset($form_requisicao->id) ? $form_requisicao->id : NULL;
$requisicao = new Requisicao($id);
// create a new Sale
$requisicao->clearParts();
$requisicao->numeroProcesso = $form_requisicao->numeroProcesso;
$requisicao->emissao = TDate::date2us($form_requisicao->emissao);
//if (!$requisicao->emissao){
// $requisicao->emissao = date("Y-m-d");
//}
$requisicao->aprovado = 0;
$requisicao->srp = new Srp(TSession::getValue("SRP_id"));
foreach ($requisicao_itens as $item) {
$item_requisicao = new Item($item->item_id);
$item_requisicao->justificativa = $item->justificativa;
$item_requisicao->quantidade = $item->quantidade;
$item_requisicao->prazoEntrega = $item->prazoEntrega;
$item_requisicao->quantidade = str_replace('.', '', $item->quantidade);
$item_requisicao->quantidade = str_replace(',', '.', $item->quantidade);
$requisicao->addItem($item_requisicao);
// add the item to the Sale
}
$requisicao->store();
// store the Sale
TSession::delValue('requisicao_itens');
TSession::delValue('form_requisicao');
TSession::delValue('SRP_id');
new TMessage('info', 'Requisição salva');
}
TTransaction::close();
$this->onReload();
} catch (Exception $e) {
if ($e->getCode() == 23000) {
new TMessage('error', '<b>Registro duplicado</b><br>Verifique os campos inseridos e tente novamente');
} else {
if ($e->getCode() == 0) {
new TMessage('error', '<b>Error</b> <br>' . $e->getMessage());
} else {
new TMessage('error', '<b>Error Desconhecido</b> <br>Código: ' . $e->getCode());
}
}
}
}
public function onSave($param)
{
try {
$this->form_cessao->validate();
// validate form data
$form_cessao_data = $this->form_cessao->getData();
$form_cessao = TSession::getValue('form_cessao');
$form_cessao->numeroCessao = $form_cessao_data->numeroCessao;
$form_cessao->campusID = $form_cessao_data->campusID;
$form_cessao->campusNome = $form_cessao_data->campusNome;
$form_cessao->emissao = $form_cessao_data->emissao;
$cessao_itens = TSession::getValue('cessao_itens');
if (!isset($cessao_itens) || count($cessao_itens) == 0) {
new TMessage('error', 'Insira ao menos 1 item');
return;
}
TTransaction::open('saciq');
if ($cessao_itens) {
$id = isset($form_cessao->id) ? $form_cessao->id : NULL;
$cessao = new Cessao($id);
// create a new Sale
$cessao->clearParts();
$cessao->numeroCessao = $form_cessao->numeroCessao;
$cessao->campus = new Campus($form_cessao->campusID);
$cessao->emissao = TDate::date2us($form_cessao->emissao);
//if (!$cessao->emissao){
// $cessao->emissao = date("Y-m-d");
//}
$cessao->aprovado = 0;
$cessao->srp = new Srp(TSession::getValue('SRP_id'));
foreach ($cessao_itens as $item) {
$item_cessao = new Item($item->item_id);
$item_cessao->quantidade = $item->quantidade;
$item_cessao->quantidade = str_replace('.', '', $item->quantidade);
$item_cessao->quantidade = str_replace(',', '.', $item->quantidade);
$cessao->addItem($item_cessao);
// add the item to the Sale
}
$cessao->store();
// store the Sale
TSession::delValue('cessao_itens');
TSession::delValue('form_cessao');
TSession::delValue('SRP_id');
new TMessage('info', 'Cessão salva');
}
TTransaction::close();
$this->onReload();
} catch (Exception $e) {
if ($e->getCode() == 23000) {
new TMessage('error', '<b>Registro duplicado</b><br>Verifique os campos inseridos e tente novamente');
} else {
if ($e->getCode() == 0) {
new TMessage('error', '<b>Error</b> <br>' . $e->getMessage());
} else {
new TMessage('error', '<b>Error Desconhecido</b> <br>Código: ' . $e->getCode());
}
}
}
}
