<?php
    function onReload($param = NULL)
    {
        try
        {
            // open a transaction with database 'sqlserver'
            TTransaction::open('sqlserver');
            
            // creates a repository for Coig
            $repository = new TRepository('Coig');
            $limit = 30;
            // creates a criteria
            $criteria = new TCriteria;
            // load the objects according to criteria
            $objects = $repository->load($criteria, FALSE);
            
            $this->datagrid->clear();
            if ($objects)
            {
                //--abre uma conexão para carrecar os eventos reais
                TTransaction::open('sqlserver');
                $repository2 = new TRepository('EventoReal');
                $eventoreal = $repository2->load();
                
                $item = array();
                foreach ($eventoreal as $eventoreals){
                    $item[$eventoreals->id] = $eventoreals->evento;
                }
                
                
                // iterate the collection of active records
                foreach ($objects as $object)
                {
                    $eventoID = $object->evento_real_id;
                    $valido = $object->validador;
                    
                    $object->validador    = new TCheckButton("validador_".$object->id);
                    $object->validador->setIndexValue('1');
                    if ($valido == 1){
                        $object->validador->setProperty('checked', 1);
                    }
                    $object->evento_real_id = new TCombo('evento_real_id_'.$object->id);
                    $object->evento_real_id->addItems($item);
                    $object->evento_real_id->setValue($eventoID);
                        
                    
                    // add the object inside the datagrid
                    $row = $this->datagrid->addItem($object);
                    
                    
                    //coloca os itens em popover
                    $tabela  = "<table class='popover-table'>";
                    $tabela .= "<tr><td><b>Potência Ativa:</b> {$object->potencia}</td><td><b>Nível montante:</b> {$object->nivel_montante}</td></tr>";
                    $tabela .= "<tr><td><b>Postado por:</b> {$object->responsavel}</td><td> {$object->agora}</td></tr>";
                    if ($object->editor){
                        $tabela .= "<tr><td><b>Editado por:</b> {$object->editor}</td><td> {$object->data_edicao}</td></tr>";
                    }
                    //coloca os itens em popover
                    $row->popover = 'true';
                    $row->popcontent = $tabela;
                    $row->poptitle = 'Detalhes';
                    
                    $row = $this->form->addField($object->validador);
                    $row = $this->form->addField($object->evento_real_id);
                }
            }
            
            // reset the criteria for record count
            $criteria->resetProperties();
            $count= $repository->count($criteria);
            
            $this->pageNavigation->setCount($count); // count of records
            $this->pageNavigation->setProperties($param); // order, page
            $this->pageNavigation->setLimit($limit); // limit
            
            // close the transaction
            TTransaction::close();
            $this->loaded = true;
        }
        catch (Exception $e) // in case of exception
        {
            // shows the exception error message
            new TMessage('error', '<b>Error</b> ' . $e->getMessage());
            
            // undo all pending operations
            TTransaction::rollback();
        }
    }
    public function onSave($param)
    {
        
        TTransaction::open('sqlserver'); // open a transaction
            
        // get the form data into an active record Coig
        $data = $this->form->getData('Coig');
        $this->form->setData($data);
        
        // put the data back to the form
        //$this->form->setData($data);
        
        // creates a string with the form element's values
        $message = $data->evento_real_id_ . $data->id .'<br>';
        $message.= $data->data_coig .'<br>';
        $message.= $data->validador_ . $data->id .'<br>';
        $message.= $data->validador_ . $data->id .'<br>';
        
        print_r($data);
        
        // show the message
        new TMessage('info', $message);
    }
?>