<?php
    class LideresForm extends TPage
    {
        use Adianti\Base\AdiantiStandardFormTrait;
        
        protected $form;
                
        public function __construct()
        {
            parent::__construct();
            
            $this->setDatabase('warriors');
            $this->setActiveRecord('Lideres');
            
            $this->form = new BootstrapFormBuilder(__CLASS__.'form');
            $this->form->setFormTitle('Cadastro de Líderes');
            $this->form->style = 'width:100%';
            
            $id              = new TEntry('id');
            $nome            = new TEntry('nome');
            $uf              = new TDBCombo('uf', 'warriors', 'Estados', 'uf', '{nome}');
            $cidade          = new TDBCombo('cidade', 'warriors', 'Cidades', 'id', '{nome}');
            $igreja_id       = new TDBCombo('igreja_id', 'warriors', 'Igrejas', 'id', 'apelido');
            $departamento_id = new TDBCombo('departamento_id', 'warriors', 'Departamentos', 'id', 'descricao');
            $fone            = new TEntry('fone');
            $email           = new TEntry('email');
            $senha           = new TPassword('senha');
            $ativo           = new TCombo('ativo');
            $ativo->addItems(['S'=>'Sim', 'N'=>'Não']);
            
            $id->setEditable(FALSE);
            $senha->setEditable(FALSE);
            
            $uf->enableSearch();
            $cidade->enableSearch();
            $igreja_id->enableSearch();
            
            $uf->setChangeAction(new TAction([$this, 'onChangeUf']));
            $cidade->setChangeAction(new TAction([$this, 'onChangeCidade']));
            
            $this->form->addFields([new TLabel('Id')],[$id]);
            $this->form->addFields([new TLabel('Nome')],[$nome]);
            $this->form->addFields([new TLabel('UF')],[$uf]);
            $this->form->addFields([new TLabel('Cidade')],[$cidade]);
            $this->form->addFields([new TLabel('Igreja')],[$igreja_id]);
            $this->form->addFields([new TLabel('Departamento')],[$departamento_id]);
            $this->form->addFields([new TLabel('Fone')],[$fone]);
            $this->form->addFields([new TLabel('Email')],[$email]);
            $this->form->addFields([new TLabel('Senha')],[$senha]);
            $this->form->addFields([new TLabel('Ativo')],[$ativo]);
            
            $this->form->addAction(_t('Save'), new TAction([$this, 'onSave']), 'fa: fa-save green');
            $this->form->addAction('Gerar Nova Senha', new TAction([$this, 'onSave'], ['renew'=>true]), 'fa: fa-cogs red');
            $this->form->addAction(_t('Back'), new TAction(['LideresList', 'onReload']), 'fa: fa-arrow-circle-left blue');            
            
            $container = new TVBox();
            $container->style = 'width:100%; overflow-x:auto';
            $bread = new TBreadCrumb;
            $bread->addHome();
            $bread->addItem('Líderes');
            $bread->addItem('Cadastro de Líderes', TRUE);
            $container->add($bread);
            $container->add($this->form);
            parent::add($container);
        }
        
         public function fire_events($object)
         {
            TForm::sendData(__CLASS__."form", $object);
         }
        
        public function onEdit($param)
        {
            try
            {
                if (empty($this->database))
                {
                    throw new Exception(AdiantiCoreTranslator::translate('^1 was not defined. You must call ^2 in ^3', AdiantiCoreTranslator::translate('Database'), 'setDatabase()', AdiantiCoreTranslator::translate('Constructor')));
                }
                
                if (empty($this->activeRecord))
                {
                    throw new Exception(AdiantiCoreTranslator::translate('^1 was not defined. You must call ^2 in ^3', 'Active Record', 'setActiveRecord()', AdiantiCoreTranslator::translate('Constructor')));
                }
                
                if (isset($param['key']))
                {
                    // get the parameter $key
                    $key=$param['key'];
                    
                    // open a transaction with database
                    TTransaction::open($this->database);
                    
                    $class = $this->activeRecord;
                    
                    // instantiates object
                    $object = new $class($key);
                    
                    // fill the form with the active record data
                    $this->form->setData($object);
                    
                    // close the transaction
                    TTransaction::close(); 
                    
                    $this->fire_events($object); /* aqui executa o evento*/
                    
                    return $object;                    
                }
                else
                {
                    $this->form->clear( true );
                }
            }
            catch (Exception $e) // in case of exception
            {
                // shows the exception error message
                new TMessage('error', $e->getMessage());
                // undo all pending operations
                TTransaction::rollback();
            }
        }
    
        public function onSave($param = NULL)
        {
            try
            {
                if (empty($this->database))
                {
                    throw new Exception(AdiantiCoreTranslator::translate('^1 was not defined. You must call ^2 in ^3', AdiantiCoreTranslator::translate('Database'), 'setDatabase()', AdiantiCoreTranslator::translate('Constructor')));
                }
                
                if (empty($this->activeRecord))
                {
                    throw new Exception(AdiantiCoreTranslator::translate('^1 was not defined. You must call ^2 in ^3', 'Active Record', 'setActiveRecord()', AdiantiCoreTranslator::translate('Constructor')));
                }
                
                // open a transaction with database
                TTransaction::open($this->database);
                
                // get the form data
                $object = $this->form->getData($this->activeRecord);
                
                if (empty($object->senha)||isset($param['renew']))
                {
                    $nova_senha = TUtil::geraSenha(6, FALSE);
                    $object->senha = md5($nova_senha);
                } 
                else
                {
                    unset($object->senha);
                }
    
                // validate data
                $this->form->validate();
                
                // stores the object
                $object->store();
                
                // fill the form with the active record data
                $this->form->setData($object);
                
                //Verifica se o email foi preenchido e faz a validação do usuario vinculado ao líder
                if(!empty($object->email))
                {
                    $user = SystemUser::newFromEmail($object->email); 
                    
                    if (empty($user)) //Usuário não existe
                    {
                        $user = new SystemUser();
                        $user->name  = $object->nome;
                        $user->email = $object->email;
                        $user->login = $object->email;
                        $user->password = $object->senha;
                        $user->frontpage_id = 7;
                        $user->active = 'Y'; 
                        $user->store(); 
                        
                        $user->addSystemUserGroup(SystemGroup::find(2));                  
                    }
                    else //Usuário já existe
                    {
                         //Alterou senha
                         if ($object->senha)
                         {
                             $user->password = $object->senha;
                             $user->store(); 
                         }     
                    }
                }
    
                // close the transaction
                TTransaction::close();
                
                $this->fire_events($object);
                
                // shows the success message
                if (isset($this->useMessages) AND $this->useMessages === false)
                {
                    AdiantiCoreApplication::loadPageURL( $this->afterSaveAction->serialize() );
                }
                else
                {
                    new TMessage('info', AdiantiCoreTranslator::translate('Record saved'), $this->afterSaveAction);
                    if (isset($nova_senha)) {$this->form->add(new TAlert('info', 'A senha gerada é: <br>'.$nova_senha));}
                }
                
                return $object;
            }
            catch (Exception $e) // in case of exception
            {
                // get the form data
                $object = $this->form->getData();
                
                // fill the form with the active record data
                $this->form->setData($object);
                
                // shows the exception error message
                new TMessage('error', $e->getMessage());
                
                // undo all pending operations
                TTransaction::rollback();
            }
        }
        public static function onChangeUf($param)
        {
            $criteria = new TCriteria();
            
            if(!empty($param['key']))
            {
                $criteria->add(new TFilter('uf','=', $param['key']));
                
                TDBCombo::reloadFromModel(
                            __CLASS__.'form',
                            'cidade',
                            'warriors',
                            'Cidades',
                            'id',
                            'nome',
                            null,
                            $criteria);            
            }
            else
            {
                  TDBCombo::clearField(__CLASS__.'form', 'cidade');   
            } 
                        
        }
        
        public static function onChangeCidade($param)
        {
            if(!empty($param['key']))
            {
                $criteria = new TCriteria();
                $criteria->add(new TFilter('cidade','=', $param['key'])); 
                
                TDBCombo::reloadFromModel(
                            __CLASS__.'form',
                            'igreja_id',
                            'warriors',
                            'Igrejas',
                            'id',
                            '{apelido} {cidade_nome}',
                            null,
                            $criteria);           
            }
            else
            {
                TDBCombo::clearField(__CLASS__.'form', 'igreja_id');     
            }  
        }             
 }
?>