public function onSelect($param)
{
try {
if (!$param['key']) {
return;
}
if (!TSession::getValue('SRP_id') && !$this->continue) {
$this->closeWindow();
new TMessage('error', 'Número SRP Inválido');
$this->message = false;
return;
}
$key = $param['key'];
TTransaction::open('saciq');
//TTransaction::setLogger(new TLoggerTXT('c:\array\file.txt'));
$repository = new TRepository('Item');
$criteria = new TCriteria();
$criteria->add(new TFilter('numeroItem', '=', $key));
if (TSession::getValue('SRP_id')) {
$criteria->add(new TFilter('srp_id', '=', TSession::getValue('SRP_id')));
}
$itens = $repository->load($criteria);
if (count($itens) > 0) {
$item = $itens[0];
$itens_o = TSession::getValue('cessao_itens_o');
if (isset($itens_o) && isset($itens_o[$item->numeroItem])) {
$item->estoqueDisponivel += $itens_o[$item->numeroItem]->quantidade;
}
if ($item->estoqueDisponivel == 0) {
$obj = new stdClass();
$obj->numeroItem = '';
$obj->item_id = '';
$obj->numeroItem = '';
$obj->descricaoSumaria = '';
$obj->valorUnitario = '';
//$obj->quantidade = '';
$obj->prazoEntrega = '60 Dias';
$obj->justificativa = '';
TForm::sendData('form_itens', $obj);
$this->closeWindow();
new TMessage('error', 'Item sem quantidade disponível');
$this->message = false;
return;
}
$obj = new stdClass();
$obj->item_id = $item->id;
if (strpos($item->descricaoSumaria, '–')) {
$item->descricaoSumaria = str_replace('–', '-', $item->descricaoSumaria);
$item->store();
}
$obj->numeroItem = $item->numeroItem;
$obj->descricaoSumaria = $item->descricaoSumaria;
$obj->valorUnitario = $item->valorUnitario;
TForm::sendData('form_itens', $obj);
parent::closeWindow();
} else {
$obj = new stdClass();
$obj->item_id = '';
$obj->numeroItem = '';
$obj->descricaoSumaria = '';
$obj->valorUnitario = '';
//$obj->quantidade = '';
$obj->prazoEntrega = '60 Dias';
$obj->justificativa = '';
TForm::sendData('form_itens', $obj);
parent::closeWindow();
}
TTransaction::close();
} catch (Exception $e) {
$obj = new stdClass();
$obj->item_id = '';
$obj->descricaoSumaria = '';
$obj->valorUnitario = '';
$obj->quantidade = '';
$obj->prazoEntrega = '60 Dias';
$obj->justificativa = '';
TForm::sendData('form_itens', $obj);
TTransaction::rollback();
}
}
/**
* Select the register by ID and return the information to the main form
* When using onblur signal, AJAX passes all needed parameters via GET
* instead of calling onSetup before.
*/
public static function onSelect($param)
{
$key = $param['key'];
$database = isset($param['database']) ? $param['database'] : TSession::getValue('standard_seek_database');
$receive_key = isset($param['receive_key']) ? $param['receive_key'] : TSession::getValue('standard_seek_receive_key');
$receive_field = isset($param['receive_field']) ? $param['receive_field'] : TSession::getValue('standard_seek_receive_field');
$display_field = isset($param['display_field']) ? $param['display_field'] : TSession::getValue('standard_seek_display_field');
$parent = isset($param['parent']) ? $param['parent'] : TSession::getValue('standard_seek_parent');
try {
TTransaction::open($database);
// load the active record
$model = isset($param['model']) ? $param['model'] : TSession::getValue('standard_seek_model');
$activeRecord = new $model($key);
$pk = constant("{$model}::PRIMARYKEY");
$object = new StdClass();
$object->{$receive_key} = isset($activeRecord->{$pk}) ? $activeRecord->{$pk} : '';
$object->{$receive_field} = isset($activeRecord->{$display_field}) ? $activeRecord->{$display_field} : '';
TTransaction::close();
TForm::sendData($parent, $object);
parent::closeWindow();
// closes the window
} catch (Exception $e) {
// clear fields
$object = new StdClass();
$object->{$receive_key} = '';
$object->{$receive_field} = '';
TForm::sendData($parent, $object);
// undo all pending operations
TTransaction::rollback();
}
}
/**
* Executed when the user chooses the record
*/
public function onSelect($param)
{
try {
$key = $param['key'];
TTransaction::open('sobcontrole');
// load the active record
$tipocontato = new tipocontato($key);
//var_dump($tipocontato);
// closes the transaction
TTransaction::close();
$object = new StdClass();
$object->tipocontato_idtipocontato = $tipocontato->idtipocontato;
$object->tipocontato_descricao = $tipocontato->descricao;
TForm::sendData('form_seek_sample', $object);
parent::closeWindow();
// closes the window
} catch (Exception $e) {
// clear fields
$object = new StdClass();
$object->tipocontato_idtipocontato = '';
$object->tipocontato_descricao = '';
TForm::sendData('form_seek_sample', $object);
// undo pending operations
TTransaction::rollback();
}
}
function onReload($param = null)
{
$this->datagrid->clear();
$key = $param['key'];
if (!isset($key)) {
$value = TSession::getValue('srp_form_view_key');
if (!isset($value)) {
return;
}
$key = $value;
}
try {
TTransaction::open('saciq');
$srp = new Srp($key);
if (!isset($srp)) {
TTransaction::close();
return;
}
$object = new stdClass();
$object->id = $srp->id;
$object->numeroSRP = $srp->numeroSRP;
$object->numeroIRP = $srp->numeroIRP;
$object->numeroProcesso = $srp->numeroProcesso;
$object->uasg = $srp->uasg;
$object->validade = TDate::date2br($srp->validade);
$object->nome = $srp->nome;
$object->natureza = $srp->natureza->descricao;
foreach ($srp->getItems() as $item) {
$row = $this->datagrid->addItem($item);
}
TForm::sendData('SrpFormView', $object);
TTransaction::close();
} 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());
}
}
// desfazer todas as operacoes pendentes
TTransaction::rollback();
}
}
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();
}
}
public function onEdit($param)
{
if (isset($param) && isset($param['key'])) {
$key = $param['key'];
}
if (!isset($key)) {
$form_requisicao = new stdClass();
$form_requisicao->numeroSRP = '';
$form_requisicao->numeroProcessoOrigem = '';
$form_requisicao->numeroProcesso = '';
$form_requisicao->validade = '';
$form_requisicao->nome = '';
$form_requisicao->uasg = '';
$form_requisicao->emissao = date('d/m/Y');
TSession::delValue('requisicao_itens');
TSession::delValue('requisicao_itens_o');
TSession::delValue('form_requisicao');
TSession::delValue('SRP_id');
TForm::sendData('form_requisicao', $form_requisicao);
$this->onReload();
return;
}
try {
TTransaction::open('saciq');
$requisicao = new Requisicao($key);
$form_requisicao = new stdClass();
$form_requisicao->id = $key;
$form_requisicao->numeroSRP = $requisicao->srp->numeroSRP;
$form_requisicao->numeroProcessoOrigem = $requisicao->srp->numeroProcesso;
$form_requisicao->numeroProcesso = $requisicao->numeroProcesso;
$form_requisicao->validade = TDate::date2br($requisicao->srp->validade);
$form_requisicao->nome = $requisicao->srp->nome;
$form_requisicao->uasg = $requisicao->srp->uasg;
$form_requisicao->emissao = TDate::date2br($requisicao->emissao);
TSession::delValue('requisicao_itens');
TSession::delValue('requisicao_itens_o');
TSession::setValue('SRP_id', $requisicao->srp->id);
TSeekButton::disableField('form_requisicao', 'numeroSRP');
foreach ($requisicao->getItems() as $item_requisicao) {
$item = new stdClass();
$item->item_id = $item_requisicao->id;
$item->numeroItem = $item_requisicao->numeroItem;
$item->descricaoSumaria = $item_requisicao->descricaoSumaria;
$item->quantidade = $item_requisicao->quantidade;
$item->valorUnitario = $item_requisicao->valorUnitario;
$item->justificativa = $item_requisicao->justificativa;
$item->prazoEntrega = $item_requisicao->prazoEntrega;
$item->total = $item_requisicao->total;
$itens[$item->numeroItem] = $item;
}
TSession::setValue('requisicao_itens', $itens);
TSession::setValue('requisicao_itens_o', $itens);
TSession::setValue('form_requisicao', $form_requisicao);
TForm::sendData('form_requisicao', $form_requisicao);
$this->onReload();
TTransaction::close();
} 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());
}
}
// desfazer todas as operacoes pendentes
TTransaction::rollback();
}
}