<?php
/**
 * DataGridClienteFisico
 *
 */
class DataGridClienteFisico extends TPage
{
    private $datagrid, $pageNavigation, $loaded;
    
    public function __construct()
    {
        parent::__construct();
        
        // creates one datagrid
        $this->datagrid = new BootstrapDatagridWrapper(new TDataGrid);
        $this->datagrid->width = '100%';
        
        // add the columns
        $this->datagrid->addColumn(new TDataGridColumn('pessoa_id','#','center',''));
        $nome = $this->datagrid->addColumn(new TDataGridColumn('pessoa->fisica->nome',_t('Name'),'left',''));
        $data_cadastro = $this->datagrid->addColumn(new TDataGridColumn('criacao','Data Cadastro','left',''));
        $telefone = $this->datagrid->addColumn(new TDataGridColumn('telefone->numero','Telefone','left',''));
        //$unidade = $this->datagrid->addColumn(new TDataGridColumn('contato->nome','Email','left',''));
        $cpf = $this->datagrid->addColumn(new TDataGridColumn('pessoa->fisica->cpf','CPF','left',''));
        $rg = $this->datagrid->addColumn(new TDataGridColumn('pessoa->fisica->rg','RG','left',''));
        $uf = $this->datagrid->addColumn(new TDataGridColumn('pessoa_endereco->endereco->estado->nome','Cidade','left',''));
        $cidade = $this->datagrid->addColumn(new TDataGridColumn('pessoa_endereco->endereco->estado->uf','UF','left',''));
        $data_cadastro->enableAutoHide(500);
        $telefone->enableAutoHide(600);
        //$unidade->enableAutoHide(700);
        $cpf->enableAutoHide(800);
        $rg->enableAutoHide(900);
        $uf->enableAutoHide(1000);
        $cidade->enableAutoHide(1000);
        $uf->setDataProperty('style','font-weight: bold');
        $data_cadastro->setTransformer(array($this, 'formatDate'));        
        
        $action1 = new TDataGridAction(['FisicaForm','onEdit'],['id'=>'{pessoa_id}'] );
        $this->datagrid->addAction($action1, 'Edit','fa:search blue');
        
        // creates the datagrid model
        $this->datagrid->createModel();
        // creates the page navigation
        $this->pageNavigation = new TPageNavigation;
        $this->pageNavigation->setAction(new TAction([$this, 'onReload']));
        $this->pageNavigation->setWidth($this->datagrid->getWidth());
        $this->pageNavigation->enableCounters();
        
        // search box
        $input_search = new TEntry('input_search');
        $input_search->placeholder = _t('Search');
        $input_search->setSize('100%');
        
        // enable fuse search by column name
        $this->datagrid->enableSearch($input_search,'pessoa_id,criacao,pessoa->fisica->nome,telefone->numero,pessoa->fisica->cpf,pessoa->fisica->rg');
        
        $panel = new TPanelGroup('{$cliente}');
        $panel->addHeaderWidget($input_search);
        $panel->add($this->datagrid)->style = 'overflow-x:auto';
        $panel->addFooter($this->pageNavigation);
        
        // wrap the page content using vertical box
        $vbox = new TVBox;
        $vbox->style = 'width: 100%';
        //$vbox->add(new TXMLBreadCrumb('menu.xml','Cliente'));
        $vbox->add($panel);
        parent::add($vbox);
    }
    public function formatDate($date, $object)
    {
        $dt = new DateTime($date);
        return $dt->format('d/m/Y');
    }
    
    /**
     * method onReload()
     * Load the datagrid with the database objects
     */
    function onReload($param = NULL)
    {
        try
        {
            // open a transaction with database 'db'
            TTransaction::open('sgv');
            
            // creates a repository for PessoaVinculo
            $repository = new TRepository('PessoaVinculo');
            $limit = 10;
            
            // creates a criteria
            $criteria = new TCriteria;
            
            // default order
            if (empty($param['order']))
            {
                $param['order'] = 'pessoa_id';
                $param['direction'] = 'asc';
            }
            
            $criteria->setProperties($param); // order, offset
            $criteria->setProperty('limit', $limit);            
                      
            // load the objects according to criteria
            $objects = $repository->load($criteria);
            
            $this->datagrid->clear();
            if ($objects)
            {
                // iterate the collection of active records
                foreach ($objects as $object)
                {
                    // add the object inside the datagrid
                    $this->datagrid->addItem($object);
                }
            }
            
            // 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
        {
            new TMessage('error', $e->getMessage()); // shows the exception error message
            TTransaction::rollback(); // undo all pending operations
        }
    }
        
   /**
     * shows the page
     */
    function show()
    {
        $this->onReload();
        parent::show();
    }
}