PHP TTransaction::close方法代码示例

 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 = 'giovanni@dalloglio.net';
         $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();
     }
 }

 /**
  * 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();
     }
 }