Facebook
From Stained Motmot, 2 Years ago, written in PHP.
This paste is a reply to Re: Problema com Tcriteira from Crippled Iguana - go back
Embed
public function __construct(){
        parent::__construct();
__construct($param){
        parent::__construct($param);
        
        //creates the form
        $this->form = new BootstrapFormBuilder('form_obra');   
        $this->form->setProperty('style', 'margin:0;border:0;padding:0');
        $this->form->setClientValidation(true);              
        
        //filtro para não trazer a mesma empresa no TDBCombo
        $this->criteria_contratada = new TCriteria();  

TTransaction::open('sgdt');
                //TTransaction::dump();                                
                
                $obra = new Obra($key);

                //filtro para não trazer a mesma empresa no TDBUniqueSearch        
                $this->criteria_contratada->add(new TFilter('id', '<>', $param['0']['empresa_id']));        
                $this->criteria_contratada->add(//trazer todas a empresas vinculadas a contratante
                    new TFilter('id', 'IN', '(SELECT contratada_id FROM empresa_contratante_contratada WHERE contratante_id = '.$param['0']['empresa_id'].')')
                );
 TTransaction::close();
        
        $contratada_id  = new TDBCombo('contratada_id', 'sgdt', 'Empresa', 'id', '{nome_fantasia} - {cnpj}', null, $this->criteria_contratada);
....
...
....
....
}

public function onEdit($param){
        if (isset($param['0']['key'])){
                
                $key = $param['0']['key'];

                
                                $this->form->setData($obra);
                
                TForm::sendData('form_obra', $obra);

               
        }

}