<?php
/**
 * Pessoa Active Record
 * @author  <your-name-here>
 */
class Pessoa extends TRecord
{
    const TABLENAME = 'Pessoa';
    const PRIMARYKEY= 'IdPessoa';
    const IDPOLICY =  'max'; // {max, serial}    
    /**
     * Constructor method
     */
    public function __construct($id = NULL, $callObjectLoad = TRUE)
    {
        parent::__construct($id, $callObjectLoad);
        parent::addAttribute('Nome');
    }
}
?>
 

 
<?php
/**
 * Pessoafisica Active Record
 * @author  <your-name-here>
 */
class Pessoafisica extends TRecord
{
    const TABLENAME = 'PessoaFisica';
    const PRIMARYKEY= 'IdPessoaFisica';
    const IDPOLICY =  'max'; // {max, serial}
    
     private $pessoa;
    
    /**
     * Constructor method
     */
    public function __construct($id = NULL, $callObjectLoad = TRUE)
    {
        parent::__construct($id, $callObjectLoad);
        parent::addAttribute('IdPessoa');
        parent::addAttribute('CPF');
       
    }
}
?>
 

 
<?php
/**
 * PessoaPessoaEndereco Active Record
 * @author  <your-name-here>
 */
class PessoaEndereco extends TRecord
{
    const TABLENAME = 'PessoaEndereco';
    const PRIMARYKEY= 'id';
    const IDPOLICY =  'max'; // {max, serial}
    
    
    /**
     * Constructor method
     */
    public function __construct($id = NULL, $callObjectLoad = TRUE)
    {
        parent::__construct($id, $callObjectLoad);
        parent::addAttribute('Id');
        parent::addAttribute('IdPessoa');
    }
}
Model Endereco
 

 
<?php
/**
 * Endereco Active Record
 * @author  <your-name-here>
 */
class Endereco extends TRecord
{
    const TABLENAME = 'Endereco';
    const PRIMARYKEY= 'IdEndereco';
    const IDPOLICY =  'max'; // {max, serial}
    
    /**
     * Constructor method
     */
    public function __construct($id = NULL, $callObjectLoad = TRUE)
    {
        parent::__construct($id, $callObjectLoad);
        parent::addAttribute('Logradouro');
        parent::addAttribute('Bairro');
        parent::addAttribute('Cep');
        parent::addAttribute('Cidade');
        parent::addAttribute('Estado');
        parent::addAttribute('Pais');
        parent::addAttribute('Latitude');
        parent::addAttribute('Longitude');
        parent::addAttribute('CodigoIbge');
        parent::addAttribute('Gia');
        parent::addAttribute('Criacao');
        parent::addAttribute('Atualizacao');
    }
    
}
?>
 

 
<?php
class ClienteFisicoForm extends TPage {
  
    private $datagrid;  // listing
    private $pageNavigation;
    private $loaded;
  public function __construct() {
    parent::__construct();
    // creates one datagrid
    $this -> datagrid = new TQuickGrid;
    $this -> datagrid -> style = 'width: 100%';
    $this -> datagrid -> makeScrollable();
    $this -> datagrid -> setHeight(300);
    // add the columns
    $this -> datagrid -> addQuickColumn('#', 'IdPessoa', 'right', '5%');
    $this -> datagrid -> addQuickColumn('Nome', 'name', 'left', '20%');
    $this -> datagrid -> addQuickColumn('Data Nasc', 'dataNasc', 'left', '8%');
    $this -> datagrid -> addQuickColumn('Estado Cívil', 'civil', 'left', '10%');
    $this -> datagrid -> addQuickColumn('Genero', 'genero', 'left', '8%');
    $this -> datagrid -> addQuickColumn('CPF', 'cpf', 'left', '7%');
    $this -> datagrid -> addQuickColumn('RG / CNH', 'rg', 'left', '10%');
    $this -> datagrid -> addQuickColumn('Telefone', 'telefone', 'left', '10%');
    $this -> datagrid -> addQuickColumn('Celular', 'celular', 'left', '10%');
    $this -> datagrid -> addQuickColumn('E-mail', 'email', 'left', '10%');
    $this -> datagrid -> addQuickColumn('Site', 'site');
    $this -> datagrid -> addQuickColumn('Cep', 'cep', 'left', '10%');
    $this -> datagrid -> addQuickColumn('Logradouro', 'logradouro');
    $this -> datagrid -> addQuickColumn('Número', 'numero');
    $this -> datagrid -> addQuickColumn('Bairro', 'bairro');
    $this -> datagrid -> addQuickColumn('UF', 'uf');
    $this -> datagrid -> addQuickColumn('Cidade', 'cidade');
    $this -> datagrid -> addQuickColumn('Tipo Endereço', 'tipoEndereco');
    $this -> datagrid -> addQuickColumn('Complemento', 'complemento');
    // add the actions
    $this -> datagrid -> addQuickAction('Input', new TDataGridAction( array($this, 'onInputDialog')), 'name', 'fa:external-link');
    // creates the datagrid model
    $this -> datagrid -> createModel();
    // wrap the page content using vertical box
    $vbox = new TVBox;
    $vbox -> add(new TXMLBreadCrumb('menu.xml', __CLASS__));
    $vbox -> add($this -> datagrid);
    parent::add($vbox);
  }
  /**
   * Load the data into the datagrid
   */
  function onReload($param = null) {
    try {
      parent::setDatabast('sgvo');//abre a transação
           
      //cria o repositorio Pessoa
      $rep_pessoa = new TRepository('Pessoa');
      $limit = 10;
      //cria o critério de seleção
      $criteria = new TCriteria;
      $criteria -> setProperties($param);//oredr, offsset
      $criteria -> setProperty('limit', $limit);
      //carrega os objetos
      $obj = $rep_pessoa -> load($criteria);
      //limpa a datagrid
      $this -> datagrid -> clear();
      if ($obj) {
        //percorre a coleção de Active Records
        foreach ($obj as $object) {
          //adiciona o objeto na datagrid
          $this -> datagrid -> addItem($object);
        }
      }
      //conta o total de registros
      $criteria -> resetProperties();
      $count = $rep_pessoa -> 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) {
        new  TMessage('error',$e->getMessage());
        TTransaction::rollback();
    }
  }
  /**
  * Terminar adaptação
   * Open an input dialog
   */
  public function onInputDialog($param) {
    $nome = new TEntry('nome');
    $cpf = new TEntry('cpf');
    $name -> setValue($param['key']);
    $form = new TForm('input_form');
    $form -> style = 'padding:20px';
    $table = new TTable;
    $table -> addRowSet(new TLabel('Nome: '), $name);
    $table -> addRowSet($lbl = new TLabel('CPF: '), $cpf);
    $lbl -> setFontColor('red');
    $form -> setFields(array($nome, $cpf));
    $form -> add($table);
    // show the input dialog
    $action = new TAction( array($this, 'onConfirm'));
    $action -> setParameter('stay-open', 1);
    new TInputDialog('Input dialog', $form, $action, 'Confirm');
  }
  /**
   * Show the input dialog data 
   */
  public static function onConfirm($param) {
    if (isset($param['amount']) AND $param['amount'])// validate required field
    {
      new TMessage('info', "Name: " . $param['name'] . ';Amount: ' . $param['amount'], new TAction( array('ClienteFisicoForm', 'onReload')));
    } else {
      new TMessage('error', 'Amount is required');
    }
  }
  /**
   * shows the page
   */
  function show() {
    if ($this->loaded) {
      $this->onReload();
    }
    parent::show();
  }
}
?>