public function init()
{
/* Form Elements & Other Definitions Here ... */
$this->setName('FormularioContato');
$ID_CONTATO = new Zend_Form_Element_Hidden('ID_CONTATO');
$ID_CONTATO->addFilter('Int');
$ID_CONTATO->removeDecorator('Label');
$nm_contato = new Zend_Form_Element_Text('NM_CONTATO');
$nm_contato->setLabel('NOME')->addFilter('StripTags')->addFilter('StringTrim')->addValidator('NotEmpty')->removeDecorator('DtDdWrapper')->removeDecorator('HtmlTag')->removeDecorator('Label')->setAttrib('class', 'form-control')->setAttrib('placeholder', 'Enter nome');
$nm_cargo = new Zend_Form_Element_Text('NM_CARGO');
$nm_cargo->setLabel('CARGO')->addFilter('StripTags')->addFilter('StringTrim')->addValidator('NotEmpty')->removeDecorator('DtDdWrapper')->removeDecorator('HtmlTag')->removeDecorator('Label')->setAttrib('class', 'form-control')->setAttrib('placeholder', 'Enter cargo');
$nr_telefone = new Zend_Form_Element_Text('NR_TELEFONE');
$nr_telefone->setLabel('TELEFONE 1')->addFilter('StripTags')->addFilter('StringTrim')->addValidator('NotEmpty')->removeDecorator('DtDdWrapper')->removeDecorator('HtmlTag')->removeDecorator('Label')->setAttrib('class', 'form-control')->setAttrib('placeholder', 'Enter telefone');
$nr_telefone2 = new Zend_Form_Element_Text('NR_TELEFONE2');
$nr_telefone2->setLabel('TELEFONE 2')->addFilter('StripTags')->addFilter('StringTrim')->addValidator('NotEmpty')->removeDecorator('DtDdWrapper')->removeDecorator('HtmlTag')->removeDecorator('Label')->setAttrib('class', 'form-control')->setAttrib('placeholder', 'Enter telefone');
$tx_observacao = new Zend_Form_Element_Textarea('TX_OBSERVACAO');
$tx_observacao->setLabel('OBSERVA��O')->removeDecorator('DtDdWrapper')->removeDecorator('HtmlTag')->removeDecorator('Label')->setAttrib('class', 'form-control')->setAttrib('rows', '5');
$ds_email = new Zend_Form_Element_Text('DS_EMAIL');
$ds_email->setLabel('E-MAIL')->addFilter('StripTags')->addFilter('StringTrim')->addValidator('NotEmpty')->removeDecorator('DtDdWrapper')->removeDecorator('HtmlTag')->removeDecorator('Label')->setAttrib('class', 'form-control')->setAttrib('placeholder', 'Enter e-mail');
$nm_logradouro = new Zend_Form_Element_Text('NM_LOGRADOURO');
$nm_logradouro->setLabel('LOGRADOURO')->addFilter('StripTags')->addFilter('StringTrim')->addValidator('NotEmpty')->removeDecorator('DtDdWrapper')->removeDecorator('HtmlTag')->removeDecorator('Label')->setAttrib('class', 'form-control')->setAttrib('placeholder', 'Enter logradouro');
$nr_endereco = new Zend_Form_Element_Text('NR_ENDERECO');
$nr_endereco->setLabel('NÚMERO')->addFilter('StripTags')->addFilter('StringTrim')->addValidator('NotEmpty')->removeDecorator('DtDdWrapper')->removeDecorator('HtmlTag')->removeDecorator('Label')->setAttrib('class', 'form-control')->setAttrib('placeholder', 'Enter número');
$ds_complemento = new Zend_Form_Element_Text('DS_COMPLEMENTO');
$ds_complemento->setLabel('COMPLEMENTO')->addFilter('StripTags')->addFilter('StringTrim')->addValidator('NotEmpty')->removeDecorator('DtDdWrapper')->removeDecorator('HtmlTag')->removeDecorator('Label')->setAttrib('class', 'form-control')->setAttrib('placeholder', 'Enter complemento');
$nm_bairro = new Zend_Form_Element_Text('NM_BAIRRO');
$nm_bairro->setLabel('BAIRRO')->addFilter('StripTags')->addFilter('StringTrim')->addValidator('NotEmpty')->removeDecorator('DtDdWrapper')->removeDecorator('HtmlTag')->removeDecorator('Label')->setAttrib('class', 'form-control')->setAttrib('placeholder', 'Enter bairro');
$nm_bairro = new Zend_Form_Element_Text('NM_BAIRRO');
$nm_bairro->setLabel('BAIRRO')->addFilter('StripTags')->addFilter('StringTrim')->addValidator('NotEmpty')->removeDecorator('DtDdWrapper')->removeDecorator('HtmlTag')->removeDecorator('Label')->setAttrib('class', 'form-control')->setAttrib('placeholder', 'Enter bairro');
$estados = array("AC" => "Acre", "AL" => "Alagoas", "AM" => "Amazonas", "AP" => "Amapá", "BA" => "Bahia", "CE" => "Ceará", "DF" => "Distrito Federal", "ES" => "Espírito Santo", "GO" => "Goiás", "MA" => "Maranhão", "MT" => "Mato Grosso", "MS" => "Mato Grosso do Sul", "MG" => "Minas Gerais", "PA" => "Pará", "PB" => "Paraíba", "PR" => "Paraná", "PE" => "Pernambuco", "PI" => "Piauí", "RJ" => "Rio de Janeiro", "RN" => "Rio Grande do Norte", "RO" => "Rondônia", "RS" => "Rio Grande do Sul", "RR" => "Roraima", "SC" => "Santa Catarina", "SE" => "Sergipe", "SP" => "São Paulo", "TO" => "Tocantins");
$nm_uf = new Zend_Form_Element_Select('NM_UF');
$nm_uf->setLabel('UF')->addMultiOptions($estados)->addFilter('StripTags')->addFilter('StringTrim')->addValidator('NotEmpty')->removeDecorator('DtDdWrapper')->removeDecorator('HtmlTag')->removeDecorator('Label')->setAttrib('class', 'form-control');
$nr_cep = new Zend_Form_Element_Text('NR_CEP');
$nr_cep->setLabel('CEP')->addFilter('StripTags')->addFilter('StringTrim')->addValidator('NotEmpty')->removeDecorator('DtDdWrapper')->removeDecorator('HtmlTag')->removeDecorator('Label')->setAttrib('class', 'form-control')->setAttrib('placeholder', 'Enter cep');
$fl_agenda = new Zend_Form_Element_Select('FL_AGENDA');
$fl_agenda->setLabel('AGENDA')->addMultiOptions(array('0' => 'NAO', '1' => 'SIM'))->addFilter('StripTags')->addFilter('StringTrim')->addValidator('NotEmpty')->removeDecorator('DtDdWrapper')->removeDecorator('HtmlTag')->removeDecorator('Label')->setAttrib('class', 'form-control')->setAttrib('placeholder', 'Enter cep');
//fk_CLIENTE
$fk_cliente = new Zend_Form_Element_Select('FK_CLIENTE');
$fk_cliente->setAttrib('class', 'form-control select2');
$cliente = new Application_Model_DbTable_Cliente();
$fk_cliente->setLabel('CLIENTE')->setRequired(true)->removeDecorator('DtDdWrapper')->removeDecorator('HtmlTag')->removeDecorator('Label');
$listaClientes = $cliente->getClienteCombo();
$fk_cliente->setMultiOptions($listaClientes);
$submit = new Zend_Form_Element_Submit('submit');
$submit->setLabel("Adiconar");
$submit->setAttrib('id', 'submitbutton');
$submit->removeDecorator('DtDdWrapper')->setAttrib('class', 'btn btn-primary button')->removeDecorator('HtmlTag')->removeDecorator('Label');
$this->addElements(array($ID_CONTATO, $nm_contato, $nm_cargo, $nr_telefone, $nr_telefone2, $tx_observacao, $ds_email, $nm_logradouro, $nr_endereco, $ds_complemento, $nm_bairro, $nm_uf, $fk_cliente, $nr_cep, $fl_agenda, $submit));
$this->setDecorators(array(array('ViewScript', array('viewScript' => '/forms/formularioContato.phtml'))));
}
public function deleteAction()
{
$id_get = $this->getRequest()->getParam('id');
$this->view->id_cliente_get = $id_get;
$cliente = new Application_Model_DbTable_Cliente();
$clienteArr = $cliente->getCliente($id_get);
$this->view->data = $clienteArr;
if ($this->getRequest()->isPost()) {
$formData = $this->getRequest()->getPost();
if ($formData['eliminar'] != null && $formData['eliminar'] == 'Eliminar') {
// SI SE CONFIRMA LA ELIMINACION
$cliente->deleteCliente($formData['id_cliente']);
} else {
//CANCELAR ELIMINACION
}
}
}
public function addnewAction()
{
$form = new Application_Form_Historialabono();
$form->submit->setLabel('Agregar nuevo abono/cliente');
$form->submit->setAttrib('class', 'btn btn-primary');
$this->view->form = $form;
if ($this->getRequest()->isPost()) {
$formData = $this->getRequest()->getPost();
if ($form->isValid($formData)) {
$clienteArr = array("cli_nombre" => $form->getValue('cli_nombre'), "cli_rut" => $form->getValue('cli_rut'), 'cli_apellido_1' => $form->getValue('cli_apellido_1'), 'cli_apellido_2' => $form->getValue('cli_apellido_2'), 'cli_fono_1' => $form->getValue('cli_fono_1'), 'cli_fono_2' => $form->getValue('cli_fono_2'), 'cli_direccion' => $form->getValue('cli_direccion'), 'cli_lugar_de_trabajo' => $form->getValue('cli_lugar_de_trabajo'), 'cli_ciudad' => $form->getValue('cli_ciudad'));
$cliente = new Application_Model_DbTable_Cliente();
$id_cliente = $cliente->addCliente($clienteArr);
$fecha = date('Y/m/d H:i:s');
$abonoArr = array("abo_cantidad" => $form->getValue('abo_cantidad'), "abo_fecha" => $fecha, "abo_tipo_movimiento" => $form->getValue('abo_tipo_movimiento'), "cli_id_cliente" => $id_cliente);
$abono = new Application_Model_DbTable_Historialabono();
$abono->addHistorialabono($abonoArr);
} else {
$form->populate($formData);
}
}
}
public function init()
{
/* Form Elements & Other Definitions Here ... */
$this->setAttrib('enctype', 'multipart/form-data');
$this->setName('FormularioCompra');
$ID_PROJETO = new Zend_Form_Element_Hidden('ID_PROJETO');
$ID_PROJETO->addFilter('Int');
$ID_PROJETO->removeDecorator('Label');
$NM_PROJETO = new Zend_Form_Element_Text('NM_PROJETO');
$NM_PROJETO->setLabel('NOME PROJETO')->setRequired(true)->addFilter('StripTags')->addFilter('StringTrim')->addValidator('NotEmpty')->removeDecorator('DtDdWrapper')->removeDecorator('HtmlTag')->removeDecorator('Label')->setAttrib('class', 'form-control')->setAttrib('placeholder', 'Enter nome ');
$DT_CADASTRO = new Zend_Form_Element_Text('DT_CADASTRO');
$DT_CADASTRO->setLabel('DATA CADASTRO')->setRequired(true)->addFilter('StripTags')->addFilter('StringTrim')->addValidator('NotEmpty')->removeDecorator('DtDdWrapper')->removeDecorator('HtmlTag')->removeDecorator('Label')->setAttrib('class', 'form-control');
$FK_AGENCIA_AMBIENTAL = new Zend_Form_Element_Select('FK_AGENCIA_AMBIENTAL');
$agenciaAmbiental = new Application_Model_DbTable_AgenciaAmbiental();
$FK_AGENCIA_AMBIENTAL->setLabel('AGÊNCIA AMBIENTAL');
$FK_AGENCIA_AMBIENTAL->setMultiOptions($agenciaAmbiental->getAgenciaAmbientalCombo())->setRequired(true)->removeDecorator('DtDdWrapper')->removeDecorator('HtmlTag')->removeDecorator('Label')->setAttrib('class', 'form-control select2');
$NR_CONTRATO = new Zend_Form_Element_Text('NR_CONTRATO');
$NR_CONTRATO->setLabel('Nº CONTRATO')->addFilter('StripTags')->addFilter('StringTrim')->addValidator('NotEmpty')->removeDecorator('DtDdWrapper')->removeDecorator('HtmlTag')->removeDecorator('Label')->setAttrib('class', 'form-control')->setAttrib('placeholder', 'Enter nº contrato ');
$TX_OBSERVACAO = new Zend_Form_Element_Textarea('TX_OBSERVACAO');
$TX_OBSERVACAO->setLabel('OBSERVAÇÃO')->removeDecorator('DtDdWrapper')->removeDecorator('HtmlTag')->removeDecorator('Label')->setAttrib('class', 'form-control')->setAttrib('rows', '20');
$FK_CLIENTE = new Zend_Form_Element_Select('FK_CLIENTE');
$cliente = new Application_Model_DbTable_Cliente();
$FK_CLIENTE->setLabel('CLIENTE');
$FK_CLIENTE->setMultiOptions($cliente->getClienteCombo())->setRequired(true)->removeDecorator('DtDdWrapper')->removeDecorator('HtmlTag')->removeDecorator('Label')->setAttrib('class', 'form-control select2');
$FK_STATUS_PROJETO = new Zend_Form_Element_Select('FK_STATUS_PROJETO');
$statusProjeto = new Application_Model_DbTable_StatusProjeto();
$FK_STATUS_PROJETO->setLabel('STATUS');
$FK_STATUS_PROJETO->setMultiOptions($statusProjeto->getStatusProjetoCombo())->setRequired(true)->removeDecorator('DtDdWrapper')->removeDecorator('HtmlTag')->removeDecorator('Label')->setAttrib('class', 'form-control select2');
/*$tiposNoticia = array("1"=>"SIM", "2"=>"NÃO);
$FL_ATIVO = new Zend_Form_Element_Select( 'FL_ATIVO' );
$FL_ATIVO->setLabel('ATIVO')
->setRequired(true)
->addMultiOptions($tiposNoticia)
->addFilter('StripTags')
->addFilter('StringTrim')
->addValidator('NotEmpty')
->removeDecorator('DtDdWrapper')
->removeDecorator('HtmlTag')
->removeDecorator('Label')
->setAttrib('class', 'form-control select2') ->setAttrib('placeholder', "Enter tipo not�cia");;*/
$FK_INDICACAO = new Zend_Form_Element_Select('FK_INDICACAO');
$statusIndicacao = new Application_Model_DbTable_Indicacao();
$FK_INDICACAO->setLabel('INDICAÇÃO');
$FK_INDICACAO->setMultiOptions($statusIndicacao->getIndicacaoCombo())->setRequired(true)->removeDecorator('DtDdWrapper')->removeDecorator('HtmlTag')->removeDecorator('Label')->setAttrib('class', 'form-control select2');
$Fk_GESTOR = new Zend_Form_Element_Select('Fk_GESTOR');
$gestor = new Application_Model_DbTable_Operador();
$Fk_GESTOR->setLabel('GESTOR');
$Fk_GESTOR->setMultiOptions($gestor->getOperadorCombo())->removeDecorator('DtDdWrapper')->removeDecorator('HtmlTag')->removeDecorator('Label')->setAttrib('class', 'form-control select2');
$FK_TIPO_PROJETO = new Zend_Form_Element_Select('FK_TIPO_PROJETO');
$tipoProjeto = new Application_Model_DbTable_TipoProjeto();
$FK_TIPO_PROJETO->setLabel('TIPO PROJETO');
$FK_TIPO_PROJETO->setMultiOptions($tipoProjeto->getTipoProjetoCombo())->setRequired(true)->removeDecorator('DtDdWrapper')->removeDecorator('HtmlTag')->removeDecorator('Label')->setAttrib('class', 'form-control select2');
$submit = new Zend_Form_Element_Submit('submit');
$submit->setLabel("Adiconar");
$submit->setAttrib('id', 'submitbutton');
$submit->removeDecorator('DtDdWrapper')->setAttrib('class', 'btn btn-info pull-right')->removeDecorator('HtmlTag')->removeDecorator('Label');
$ADICIONAR = new Zend_Form_Element_Button('ADICIONAR');
$ADICIONAR->setLabel("Adiconar");
$ADICIONAR->setAttrib('id', 'submitbutton');
$ADICIONAR->setAttrib('data-toggle', 'modal');
$ADICIONAR->setAttrib('data-target', '#myModal');
$ADICIONAR->removeDecorator('DtDdWrapper')->setAttrib('class', 'btn btn-info btn-flat')->removeDecorator('HtmlTag')->removeDecorator('Label');
$this->addElements(array($ID_PROJETO, $NM_PROJETO, $DT_CADASTRO, $FK_AGENCIA_AMBIENTAL, $NR_CONTRATO, $FK_CLIENTE, $TX_OBSERVACAO, $FK_STATUS_PROJETO, $FK_INDICACAO, $Fk_GESTOR, $FK_TIPO_PROJETO, $submit, $ADICIONAR));
$this->setDecorators(array(array('ViewScript', array('viewScript' => '/forms/formularioProjeto.phtml'))));
}
public function listaClienteAction()
{
$cliente = new Application_Model_DbTable_Cliente();
if ($this->getRequest()->isPost()) {
$del = $this->getRequest()->getPost('del');
if ($del == 'Sim') {
Zend_Registry::get('logger')->log("teste2222", Zend_Log::INFO);
$id = $this->getRequest()->getPost('ID_CLIENTE');
$cliente = new Application_Model_DbTable_Cliente();
try {
$cliente->deleteCliente($id);
$this->view->mensagem = "Excluído com sucesso";
$this->view->erro = 0;
} catch (Exception $e) {
$this->view->mensagem = $e->getCode() . " Deletar cliente";
$this->view->erro = 1;
$this->view->mensagemExcecao = $e->getMessage();
}
}
}
$this->view->cliente = $cliente->getClientes();
Zend_Registry::get('logger')->log($this->view->cliente, Zend_Log::INFO);
}
public function getClienteCombo()
{
$listaCliente = new Application_Model_DbTable_Cliente();
return $listaCliente->getAdapter()->fetchPairs($listaCliente->select()->from('TB_CLIENTE', array('ID_CLIENTE', 'NM_CLIENTE'))->order('NM_CLIENTE'));
}
