public function getCustomers() { TTransaction::open('samples'); $customers = Customer::getObjects(); var_dump($customers); TTransaction::close(); }
public function onSave($param) { try { $this->form->validate(); $object = $this->form->getData(); TTransaction::open('permission'); $user = SystemUser::newFromLogin(TSession::getValue('login')); $user->name = $object->name; $user->email = $object->email; if ($object->password1) { if ($object->password1 != $object->password2) { throw new Exception(_t('The passwords do not match')); } $user->password = md5($object->password1); } else { unset($user->password); } $user->store(); $this->form->setData($object); new TMessage('info', TAdiantiCoreTranslator::translate('Record saved')); TTransaction::close(); } catch (Exception $e) { new TMessage('error', $e->getMessage()); } }
public function listar($param) { try { TTransaction::open('sample'); $criteria = new TCriteria(); $criteria->add(new TFilter('categoria_id', '=', $param['id'])); $produtos = Produtos::getObjects($criteria); TTransaction::close(); //cria um array vario $replace_detail = array(); if ($produtos) { // iterate products foreach ($produtos as $p) { // adicio os itens no array // a função toArray(), transforma o objeto em um array // passando assim para a $variavel $replace_detail[] = $p->toArray(); } } // ativa a sessão e substitui as variaveis //o parametro true quer dizer que é um loop $this->produtos->enableSection('produtos', $replace_detail, TRUE); } catch (Exception $e) { new Message('error', $e->getMessage()); } }
/** * Autenticates the User */ function onLogin() { try { TTransaction::open('permission'); $data = $this->form->getData('StdClass'); $this->form->validate(); $user = SystemUser::autenticate($data->login, $data->password); if ($user) { $programs = $user->getPrograms(); $programs['LoginForm'] = TRUE; TSession::setValue('logged', TRUE); TSession::setValue('login', $data->login); TSession::setValue('username', $user->name); TSession::setValue('frontpage', ''); TSession::setValue('programs', $programs); $frontpage = $user->frontpage; if ($frontpage instanceof SystemProgram and $frontpage->controller) { TApplication::gotoPage($frontpage->controller); // reload TSession::setValue('frontpage', $frontpage->controller); } else { TApplication::gotoPage('EmptyPage'); // reload TSession::setValue('frontpage', 'EmptyPage'); } } TTransaction::close(); } catch (Exception $e) { new TMessage('error', $e->getMessage()); TSession::setValue('logged', FALSE); TTransaction::rollback(); } }
public static function logar($email, $senha) { try { TTransaction::open('sample'); $criteria = new TCriteria(); $filter = new TFilter('email', '=', $email); $filter2 = new TFilter('senha', '=', $senha); $criteria->add($filter); $criteria->add($filter2); $user = Clientes::getObjects($criteria); if ($user) { TSession::setValue('cliente_logado', true); // cria a sessão para mostrar que o usuario esta no sistema TSession::setValue('cliente', $user); // guarda os dados do cliente foreach ($user as $c) { TSession::setValue('id', $c->id); // guarda os dados do cliente } TCoreApplication::executeMethod('Home'); } else { new TMessage('error', 'Usuario ou Senha invalidos'); } TTransaction::close(); } catch (Exception $e) { echo $e->getMessage(); } }
public function getSocial() { //RECUPERA CONEXAO BANCO DE DADOS TTransaction::open('my_bd_site'); //TABELA exposition_gallery $criteria = new TCriteria(); $criteria->setProperty('order', 'nome ASC'); // instancia a instrução de SELECT $sql = new TSqlSelect(); $sql->addColumn('*'); $sql->setEntity('social'); // atribui o critério passado como parâmetro $sql->setCriteria($criteria); // obtém transação ativa if ($conn = TTransaction::get()) { // registra mensagem de log TTransaction::log($sql->getInstruction()); // executa a consulta no banco de dados $result = $conn->Query($sql->getInstruction()); $this->results = array(); if ($result) { // percorre os resultados da consulta, retornando um objeto while ($row = $result->fetchObject()) { // armazena no array $this->results; $this->results[] = $row; } } } TTransaction::close(); return $this->results; }
/** * Class Constructor * @param $name widget's name * @param $database database name * @param $model model class name * @param $key table field to be used as key in the combo * @param $value table field to be listed in the combo * @param $ordercolumn column to order the fields (optional) * @param array $filter TFilter (optional) By Alexandre * @param array $expresione TExpression (opcional) by Alexandre */ public function __construct($name, $database, $model, $key, $value, $ordercolumn = NULL, $filter = NULL, $expression = NULL) { new TSession(); // executes the parent class constructor parent::__construct($name); // carrega objetos do banco de dados TTransaction::open($database); // instancia um repositório de Estado $repository = new TRepository($model); $criteria = new TCriteria(); $criteria->setProperty('order', isset($ordercolumn) ? $ordercolumn : $key); if ($filter) { foreach ($filter as $fil) { if ($expression) { foreach ($expression as $ex) { $criteria->add($fil, $ex); } } else { $criteria->add($fil); } } } // carrega todos objetos $collection = $repository->load($criteria); // adiciona objetos na combo if ($collection) { $items = array(); foreach ($collection as $object) { $items[$object->{$key}] = $object->{$value}; } parent::addItems($items); } TTransaction::close(); }
/** * Class constructor * Creates the page */ function __construct() { parent::__construct(); try { TTransaction::open("sample"); $evento = new Agenda(R); $evento->nome = "Curso Adianti framework"; $evento->lugar = "Progs Scholl alterado"; $evento->descricao = "Curso basico"; $evento->data_ev = date("Y-m-d"); $evento->hora_ev = date("h:m:"); $evento->store(); TTransaction::close(); } catch (Exception $e) { echo $e->getMessage(); } TPage::include_css('app/resources/styles.css'); $this->html = new THtmlRenderer('app/resources/wellcome.html'); // define replacements for the main section $replace = array(); // replace the main section variables $this->html->enableSection('main', $replace); // add the template to the page parent::add($this->html); }
/** * method onEdit() * Executed whenever the user clicks at the edit button da datagrid */ function onView($param) { try { if (isset($param['key'])) { // get the parameter $key $key = $param['key']; // open a transaction with database 'changeman' TTransaction::open('changeman'); // instantiates object Document $object = new Document($key); $element = new TElement('div'); $element->add($object->content); parent::add($element); // close the transaction TTransaction::close(); } else { $this->form->clear(); } } catch (Exception $e) { // shows the exception error message new TMessage('error', '<b>Error</b> ' . $e->getMessage()); // undo all pending operations TTransaction::rollback(); } }
/** * method onSave() * Executed whenever the user clicks at the save button */ public function onSave() { try { // open a transaction with database TTransaction::open($this->database); // get the form data $object = $this->form->getData($this->activeRecord); // validate data $this->form->validate(); // stores the object $object->store(); // fill the form with the active record data $this->form->setData($object); // close the transaction TTransaction::close(); // define the next action $nextAction = new TAction(array('BacklogFormView', 'onSetProject')); $nextAction->setParameter('key', $object->id); // shows the success message new TMessage('info', TAdiantiCoreTranslator::translate('Record saved'), $nextAction); return $object; } catch (Exception $e) { // get the form data $object = $this->form->getData($this->activeRecord); // fill the form with the active record data $this->form->setData($object); // shows the exception error message new TMessage('error', '<b>Error</b> ' . $e->getMessage()); // undo all pending operations TTransaction::rollback(); } }
public function __construct() { parent::__construct(); try { TTransaction::open('samples'); // open transaction // create a new object $giovani = new Customer(); $giovani->name = 'Giovanni Dall Oglio'; $giovani->address = 'Rua da Conceicao'; $giovani->phone = '(51) 8111-2222'; $giovani->birthdate = '2013-02-15'; $giovani->status = 'S'; $giovani->email = '*****@*****.**'; $giovani->gender = 'M'; $giovani->category_id = '1'; $giovani->city_id = '1'; $giovani->store(); // store the object new TMessage('info', 'Objeto stored successfully'); TTransaction::close(); // Closes the transaction } catch (Exception $e) { new TMessage('error', $e->getMessage()); } }
/** * 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(); // defines the database parent::setDatabase('library'); // defines the active record parent::setActiveRecord('Publisher'); // creates the form $this->form = new TQuickForm('form_Publisher'); // create the form fields $id = new TEntry('id'); $name = new TEntry('name'); $id->setEditable(FALSE); // define the sizes $this->form->addQuickField(_t('Code'), $id, 100); $this->form->addQuickField(_t('Name'), $name, 200); // define the form action $this->form->addQuickAction(_t('Save'), new TAction(array($this, 'onSave')), 'ico_save.png'); // add the form to the page parent::add($this->form); }
public function __construct() { parent::__construct(); try { // connection info $db = array(); $db['host'] = ''; $db['port'] = ''; $db['name'] = 'app/database/samples.db'; $db['user'] = ''; $db['pass'] = ''; $db['type'] = 'sqlite'; TTransaction::open(NULL, $db); // open transaction $conn = TTransaction::get(); // get PDO connection // make query $result = $conn->query('SELECT id, name from customer order by id'); // iterate results foreach ($result as $row) { print $row['id'] . '-'; print $row['name'] . "<br>\n"; } TTransaction::close(); // close transaction } catch (Exception $e) { new TMessage('error', $e->getMessage()); } }
/** * Validate the login */ function onLogin() { try { TTransaction::open('blog'); $data = $this->form->getData('StdClass'); // validate form data $this->form->validate(); $language = $data->language ? $data->language : 'en'; TAdiantiCoreTranslator::setLanguage($language); TApplicationTranslator::setLanguage($language); $auth = User::autenticate($data->{'user'}, $data->{'password'}); if ($auth) { TSession::setValue('logged', TRUE); TSession::setValue('login', $data->user); TSession::setValue('language', $data->language); // reload page TApplication::gotoPage('SetupPage', 'onSetup'); } TTransaction::close(); // finaliza a transação } catch (Exception $e) { TSession::setValue('logged', FALSE); // exibe a mensagem gerada pela exceção new TMessage('error', '<b>Erro</b> ' . $e->getMessage()); // desfaz todas alterações no banco de dados TTransaction::rollback(); } }
public function __construct() { parent::__construct(); try { TTransaction::open('samples'); // abre uma transação // cria novo objeto $giovani = new Customer(); $giovani->name = 'Giovanni Dall Oglio'; $giovani->address = 'Rua da Conceicao'; $giovani->phone = '(51) 8111-2222'; $giovani->birthdate = '2013-02-15'; $giovani->status = 'S'; $giovani->email = '*****@*****.**'; $giovani->gender = 'M'; $giovani->category_id = '1'; $giovani->city_id = '1'; $giovani->store(); // armazena o objeto new TMessage('info', 'Objeto armazenado com sucesso'); TTransaction::close(); // fecha a transação. } catch (Exception $e) { new TMessage('error', $e->getMessage()); } }
/** * method onSave() * Executed whenever the user clicks at the save button */ function onSave() { try { // open a transaction with database TTransaction::open($this->database); // get the form data $object = $this->form->getData($this->activeRecord); // validate data $this->form->validate(); // stores the object $object->store(); // fill the form with the active record data $this->form->setData($object); // close the transaction TTransaction::close(); // shows the success message new TMessage('info', TAdiantiCoreTranslator::translate('Record saved')); // reload the listing } catch (Exception $e) { // get the form data $object = $this->form->getData($this->activeRecord); // fill the form with the active record data $this->form->setData($object); // shows the exception error message new TMessage('error', '<b>Error</b> ' . $e->getMessage()); // undo all pending operations TTransaction::rollback(); } }
/** * Validate the login */ function onLogin() { try { TTransaction::open('changeman'); $data = $this->form->getData('StdClass'); // validate form data $this->form->validate(); $auth = Member::authenticate($data->user, md5($data->password)); if ($auth) { TSession::setValue('logged', TRUE); TSession::setValue('login', $data->user); TSession::setValue('language', $data->language); // reload page TApplication::gotoPage('NewIssueForm', 'nonono'); } TTransaction::close(); // finaliza a transação } catch (Exception $e) { TSession::setValue('logged', FALSE); // exibe a mensagem gerada pela exceção new TMessage('error', '<b>Erro</b> ' . $e->getMessage()); // desfaz todas alterações no banco de dados TTransaction::rollback(); } }
/** * Overloaded method onSave() * Executed whenever the user clicks at the save button */ public function onSave() { // first, use the default onSave() $object = parent::onSave(); // if the object has been saved if ($object instanceof Product) { $source_file = 'tmp/' . $object->photo_path; $target_file = 'images/' . $object->photo_path; $finfo = new finfo(FILEINFO_MIME_TYPE); // if the user uploaded a source file if (file_exists($source_file) and $finfo->file($source_file) == 'image/png') { // move to the target directory rename($source_file, $target_file); try { TTransaction::open($this->database); // update the photo_path $object->photo_path = 'images/' . $object->photo_path; $object->store(); TTransaction::close(); } catch (Exception $e) { new TMessage('error', '<b>Error</b> ' . $e->getMessage()); TTransaction::rollback(); } } } }
/** * 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(); // defines the database parent::setDatabase('library'); // defines the active record parent::setActiveRecord('Classification'); // creates the form $this->form = new TQuickForm('form_Classification'); // create the form fields $id = new TEntry('id'); $description = new TEntry('description'); $id->setEditable(FALSE); // define the sizes $this->form->addQuickField(_t('Code'), $id, 100); $this->form->addQuickField(_t('Description'), $description, 200); // define the form action $this->form->addQuickAction(_t('Save'), new TAction(array($this, 'onSave')), 'ico_save.png'); $this->form->addQuickAction(_t('New'), new TAction(array($this, 'onEdit')), 'ico_new.png'); // creates a DataGrid $this->datagrid = new TQuickGrid(); $this->datagrid->setHeight(320); // creates the datagrid columns $this->datagrid->addQuickColumn(_t('Code'), 'id', 'left', 100, new TAction(array($this, 'onReload')), array('order', 'id')); $this->datagrid->addQuickColumn(_t('Description'), 'description', 'left', 200, new TAction(array($this, 'onReload')), array('order', 'description')); // add the actions to the datagrid $this->datagrid->addQuickAction(_t('Edit'), new TDataGridAction(array($this, 'onEdit')), 'id', 'ico_edit.png'); $this->datagrid->addQuickAction(_t('Delete'), new TDataGridAction(array($this, 'onDelete')), 'id', 'ico_delete.png'); // create the datagrid model $this->datagrid->createModel(); // creates the page navigation $this->pageNavigation = new TPageNavigation(); $this->pageNavigation->setAction(new TAction(array($this, 'onReload'))); $this->pageNavigation->setWidth($this->datagrid->getWidth()); // creates the page structure using a table $table = new TTable(); // add a row to the form $row = $table->addRow(); $row->addCell($this->form); // add a row to the datagrid $row = $table->addRow(); $row->addCell($this->datagrid); // add a row for page navigation $row = $table->addRow(); $row->addCell($this->pageNavigation); // add the table inside the page parent::add($table); }
public static function onChangeAction($param) { $obj = new StdClass(); $id = $param['tipo_material_consumo_id']; TTransaction::open("app"); $entidade = new TipoMaterialConsumo($id); $obj->custo = $entidade->custo; TForm::sendData('form_MaterialConsumo', $obj); TTransaction::close(); }
/** * 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 !== 'ADMINISTRATOR') { throw new Exception(_t('Permission denied')); } TTransaction::close(); // defines the database parent::setDatabase('changeman'); // defines the active record parent::setActiveRecord('Category'); // creates the form $this->form = new TQuickForm('form_Category'); $this->form->setFormTitle(_t('Category')); $this->form->class = 'tform'; $this->form->style = 'width: 640px'; // create the form fields $id = new TEntry('id'); $description = new TEntry('description'); // define the sizes $this->form->addQuickField('ID', $id, 100); $this->form->addQuickField(_t('Description') . ': ', $description, 200); $id->setEditable(FALSE); // define the form action $this->form->addQuickAction(_t('Save'), new TAction(array($this, 'onSave')), 'ico_save.png'); $this->form->addQuickAction(_t('New'), new TAction(array($this, 'onEdit')), 'ico_new.png'); // creates a DataGrid $this->datagrid = new TQuickGrid(); $this->datagrid->setHeight(320); // creates the datagrid columns $this->datagrid->addQuickColumn('ID', 'id', 'left', 100, new TAction(array($this, 'onReload')), array('order', 'id')); $this->datagrid->addQuickColumn(_t('Description'), 'description', 'left', 480, new TAction(array($this, 'onReload')), array('order', 'description')); // add the actions to the datagrid $this->datagrid->addQuickAction(_t('Edit'), new TDataGridAction(array($this, 'onEdit')), 'id', 'ico_edit.png'); $this->datagrid->addQuickAction(_t('Delete'), new TDataGridAction(array($this, 'onDelete')), 'id', 'ico_delete.png'); // create the datagrid model $this->datagrid->createModel(); // creates the page navigation $this->pageNavigation = new TPageNavigation(); $this->pageNavigation->setAction(new TAction(array($this, 'onReload'))); $this->pageNavigation->setWidth($this->datagrid->getWidth()); // creates the page structure using a vbox $container = new TVBox(); $container->add($this->form); $container->add($this->datagrid); $container->add($this->pageNavigation); // add the container inside the page parent::add($container); }
function onEdit($param) { try { TTransaction::open('sample'); $obj = new Agenda($param['key']); $this->form->setData($obj); TTransaction::close(); } catch (Exception $e) { new TMessage('error', $e->getMessage()); } }
/** * Returns an indexed array with all programs */ public function getPrograms() { try { TTransaction::open('permission'); $user = SystemUser::newFromLogin(TSession::getValue('login')); return $user->getProgramsList(); TTransaction::close(); } catch (Exception $e) { new TMessage('error', $e->getMessage()); } }
public static function concluiEmp($id) { TTransaction::open('my_config'); if ($conn = TTransaction::get()) { $sql = "UPDATE itens_emprestimos SET entregue = 1\r\n WHERE id_item = ?"; $sth = $conn->prepare($sql); $sth->execute(array($id)); TTransaction::close(); } else { echo 'Sem conexão com banco!'; } }
public static function getManuByRequisicao(Manu $manu) { TTransaction::open('my_config'); if ($conn = TTransaction::get()) { $sql = "SELECT M.*,U.nome_usuario FROM manutencoes M\r\n INNER JOIN usuarios U ON\r\n (U.id_usuario = M.responsavel_id)\r\n WHERE req_manutencao_id = ?"; $sth = $conn->prepare($sql); $sth->execute(array($manu->getReqManutencaoId())); $result = $sth->fetchALL(PDO::FETCH_OBJ); return $result; TTransaction::close(); } }
/** * Register a change log */ public static function register($activeRecord, $lastState, $currentState) { $table = $activeRecord->getEntity(); $pk = $activeRecord->getPrimaryKey(); TTransaction::open('log'); foreach ($lastState as $key => $value) { if (!isset($currentState[$key])) { // deleted $log = new self(); $log->tablename = $table; $log->logdate = date('Y-m-d H:i:s'); $log->login = TSession::getValue('login'); $log->primarykey = $pk; $log->pkvalue = $activeRecord->{$pk}; $log->operation = 'deleted'; $log->columnname = $key; $log->oldvalue = $value; $log->newvalue = ''; $log->store(); } } foreach ($currentState as $key => $value) { if (isset($lastState[$key]) and $value != $lastState[$key]) { // changed $log = new self(); $log->tablename = $table; $log->logdate = date('Y-m-d H:i:s'); $log->login = TSession::getValue('login'); $log->primarykey = $pk; $log->pkvalue = $activeRecord->{$pk}; $log->operation = 'changed'; $log->columnname = $key; $log->oldvalue = $lastState[$key]; $log->newvalue = $value; $log->store(); } if (!isset($lastState[$key]) and !empty($value)) { // created $log = new self(); $log->tablename = $table; $log->logdate = date('Y-m-d H:i:s'); $log->login = TSession::getValue('login'); $log->primarykey = $pk; $log->pkvalue = $activeRecord->{$pk}; $log->operation = 'created'; $log->columnname = $key; $log->oldvalue = ''; $log->newvalue = $value; $log->store(); } } TTransaction::close(); }
public function aoGravar($param) { $dados = $this->formulario->getData(); TTransaction::open('app'); $t = new TipoMaterialConsumo(); $t->nome = $dados->nome; $t->custo = $dados->custo; $t->store(); $this->formulario->setData($dados); TTransaction::close(); new TMessage('info', 'Registro Ok'); }
public function __construct() { parent::__construct(); try { TTransaction::open('samples'); $repository = new TRepository('Customer'); $repository->where('address', 'like', 'Rua Porto%')->where('gender', '=', 'M')->delete(); new TMessage('info', 'Records Deleted'); TTransaction::close(); } catch (Exception $e) { new TMessage('error', $e->getMessage()); } }
public function __construct() { parent::__construct(); try { TTransaction::open('samples'); $repository = new TRepository('Customer'); $count = $repository->where('name', 'like', 'Rafael%', TExpression::OR_OPERATOR)->where('name', 'like', 'Ana%', TExpression::OR_OPERATOR)->count(); new TMessage('info', "Total of found customers: {$count} <br>\n"); TTransaction::close(); } catch (Exception $e) { new TMessage('error', $e->getMessage()); } }
/** * Register logout */ public static function registerLogout() { TTransaction::open('log'); // get logs by session id $logs = self::where('sessionid', '=', session_id())->load(); if (count($logs) > 0) { $log = $logs[0]; if ($log instanceof SystemAccessLog) { } $log->logout_time = date("Y-m-d H:i:s"); $log->store(); } TTransaction::close(); }