/** * Devuelve un array con todas las direcciones de entrega * VIGENTES de un cliente * * Si se omite el segundo parametro, como valor a mostar se genera un string * concatenando la dirección, el codigo postal y la poblacion * * Cada elemento tiene la primarykey y el valor de $column * * @param integer $idCliente El id del cliente * @param string $column Nombre de la columna a mostrar (opcional) * @return array Array con las direcciones de entrega */ public function fetchAll($idCliente, $column = "CONCAT(d.Direccion,' ',d.CodigoPostal,' ',p.Municipio)") { $this->conecta(); if (is_resource($this->_dbLink)) { $poblacion = new Municipios(); $query = "SELECT d.IDDirec as Id,{$column} as Value \n FROM \n {$this->_dataBaseName}.{$this->_tableName} as d,\n {$poblacion->getDataBaseName()}.{$poblacion->getTableName()} as p\n WHERE\n (d.IDCliente='{$idCliente}') AND (d.Vigente='1') AND (d.IDPoblacion=p.IDMunicipio)\n ORDER BY {$column} ASC;"; $this->_em->query($query); $rows = $this->_em->fetchResult(); $this->_em->desConecta(); unset($this->_em); unset($poblacion); } $rows[] = array('Id' => '', Value => ':: Dirección de Entrega'); return $rows; }
public function run() { $municipios = ["Ahuachapán" => "1", "Jujutla" => "1", "Atiquizaya" => "1", "Concepción de Ataco" => "1", "El Refugio" => "1", "Guaymango" => "1", "Apaneca" => "1", "San Francisco Menéndez" => "1", "San Lorenzo" => "1", "San Pedro Puxtla" => "1", "Tacuba" => "1", "Turín" => "1", "Candelaria de la Frontera" => "2", "Chalchuapa" => "2", "Coatepeque" => "2", "El Congo" => "2", "El Porvenir" => "2", "Masahuat" => "2", "Metapán" => "2", "San Antonio Pajonal" => "2", "San Sebastián Salitrillo" => "2", "Santa Ana" => "2", "Santa Rosa Guachipilín" => "2", "Santiago de la Frontera" => "2", "Texistepeque" => "2", "Acajutla" => "3", "Armenia" => "3", "Caluco" => "3", "Cuisnahuat" => "3", "Izalco" => "3", "Juayúa" => "3", "Nahuizalco" => "3", "Nahulingo" => "3", "Salcoatitán" => "3", "San Antonio del Monte" => "3", "San Julián" => "3", "Santa Catarina Masahuat" => "3", "Santa Isabel Ishuatán" => "3", "Santo Domingo de Guzmán" => "3", "Sonsonate" => "3", "Sonzacate" => "3", "Alegría" => "4", "Antiguo Cuscatlán" => "4", "Chiltiupán" => "4", "Ciudad Arce" => "4", "Colón" => "4", "Comasagua" => "4", "Huizúcar" => "4", "Jayaque" => "4", "Jicalapa" => "4", "La Libertad" => "4", "Santa Tecla" => "4", "Nuevo Cuscatlán" => "4", "San Juan Opico" => "4", "Quezaltepeque" => "4", "Sacacoyo" => "4", "San José Villanueva" => "4", "San Matías" => "4", "San Pablo Tacachico" => "4", "Talnique" => "4", "Tamanique" => "4", "Teotepeque" => "4", "Tepecoyo" => "4", "Zaragoza" => "4", "Agua Caliente" => "5", "Arcatao" => "5", "Azacualpa" => "5", "Cancasque" => "5", "Chalatenango" => "5", "Citalá" => "5", "Comapala" => "5", "Concepción Quezaltepeque" => "5", "Dulce Nombre de María" => "5", "El Carrizal" => "5", "El Paraíso" => "5", "La Laguna" => "5", "La Palma" => "5", "La Reina" => "5", "Las Vueltas" => "5", "Nueva Concepción" => "5", "Nueva Trinidad" => "5", "Nombre de Jesús" => "5", "Ojos de Agua" => "5", "Potonico" => "5", "San Antonio de la Cruz" => "5", "San Antonio Los Ranchos" => "5", "San Fernando" => "5", "San Francisco Lempa" => "5", "San Francisco Morazán" => "5", "San Ignacio" => "5", "San Isidro Labrador" => "5", "Las Flores" => "5", "San Luis del Carmen" => "5", "San Miguel de Mercedes" => "5", "San Rafael" => "5", "Santa Rita" => "5", "Tejutla" => "5", "Aguilares" => "6", "Apopa" => "6", "Ayutuxtepeque" => "6", "Cuscatancingo" => "6", "Ciudad Delgado" => "6", "El Paisnal" => "6", "Guazapa" => "6", "Ilopango" => "6", "Mejicanos" => "6", "Nejapa" => "6", "Panchimalco" => "6", "Rosario de Mora" => "6", "San Marcos" => "6", "San Martín" => "6", "San Salvador" => "6", "Santiago Texacuangos" => "6", "Santo Tomás" => "6", "Soyapango" => "6", "Tonacatepeque" => "6", "Cojutepeque" => "7", "Candelaria" => "7", "El Carmen" => "7", "El Rosario" => "7", "Monte San Juan" => "7", "Oratorio de Concepción" => "7", "San Bartolomé Perulapía" => "7", "San Cristóbal" => "7", "San José Guayabal" => "7", "San Pedro Perulapán" => "7", "San Rafael Cedros" => "7", "San Ramón" => "7", "Santa Cruz Analquito" => "7", "Santa Cruz Michapa" => "7", "Suchitoto" => "7", "Tenancingo" => "7", "Zacatecoluca" => "8", "Cuyultitán" => "8", "El Rosario" => "8", "Jerusalén" => "8", "Mercedes La Ceiba" => "8", "Olocuilta" => "8", "Paraíso de Osorio" => "8", "San Antonio Masahuat" => "8", "San Emigdio" => "8", "San Francisco Chinameca" => "8", "San Pedro Masahuat" => "8", "San Juan Nonualco" => "8", "San Juan Talpa" => "8", "San Juan Tepezontes" => "8", "San Luis La Herradura" => "8", "San Luis Talpa" => "8", "San Miguel Tepezontes" => "8", "San Pedro Nonualco" => "8", "San Rafael Obrajuelo" => "8", "Santa María Ostuma" => "8", "Santiago Nonualco" => "8", "Tapalhuaca" => "8", "Cinquera" => "9", "Dolores" => "9", "Guacotecti" => "9", "Ilobasco" => "9", "Jutiapa" => "9", "San Isidro" => "9", "Sensuntepeque" => "9", "Tejutepeque" => "9", "Victoria" => "9", "Apastepeque" => "10", "Guadalupe" => "10", "San Cayetano Istepeque" => "10", "San Esteban Catarina" => "10", "San Ildefonso" => "10", "San Lorenzo" => "10", "San Sebastián" => "10", "San Vicente" => "10", "Santa Clara" => "10", "Santo Domingo" => "10", "Tecoluca" => "10", "Tepetitán" => "10", "Verapaz" => "10", "Berlín" => "11", "California" => "11", "Concepción Batres" => "11", "El Triunfo" => "11", "Ereguayquín" => "11", "Estanzuelas" => "11", "Jiquilisco" => "11", "Jucuapa" => "11", "Jucuarán" => "11", "Mercedes Umaña" => "11", "Nueva Granada" => "11", "Ozatlán" => "11", "Puerto El Triunfo" => "11", "San Agustín" => "11", "San Buenaventura" => "11", "San Dionisio" => "11", "San Francisco Javier" => "11", "Santa Elena" => "11", "Santa María" => "11", "Santiago de María" => "11", "Tecapán" => "11", "Usulután" => "11", "Arambala" => "12", "Cacaopera" => "12", "Chilanga" => "12", "Corinto" => "12", "Delicias de Concepción" => "12", "El Divisadero" => "12", "El Rosario" => "12", "Gualococti" => "12", "Guatajiagua" => "12", "Joateca" => "12", "Jocoaitique" => "12", "Jocoro" => "12", "Lolotiquillo" => "12", "Meanguera" => "12", "Osicala" => "12", "Perquín" => "12", "San Carlos" => "12", "San Fernando" => "12", "San Francisco Gotera" => "12", "San Isidro" => "12", "San Simón" => "12", "Sensembra" => "12", "Sociedad" => "12", "Torola" => "12", "Yamabal" => "12", "Yoloaiquín" => "12", "Carolina" => "13", "Chapeltique" => "13", "Chinameca" => "13", "Chirilagua" => "13", "Ciudad Barrios" => "13", "Comacarán" => "13", "El Tránsito" => "13", "Lolotique" => "13", "Moncagua" => "13", "Nueva Guadalupe" => "13", "Nuevo Edén de San Juan" => "13", "Quelepa" => "13", "San Antonio del Mosco" => "13", "San Gerardo" => "13", "San Jorge" => "13", "San Luis de la Reina" => "13", "San Miguel" => "13", "San Rafael Oriente" => "13", "Sesori" => "13", "Uluazapa" => "13", "La Unión " => "14", "San Alejo " => "14", "Yucuaiquín " => "14", "Conchagua " => "14", "Intipucá " => "14", "San José " => "14", "El Carmen " => "14", "Yayantique " => "14", "Bolívar " => "14", "Meanguera del Golfo " => "14", "Santa Rosa de Lima " => "14", "Pasaquina " => "14", "Anamoros" => "14", "Nueva Esparta " => "14", "El Sauce " => "14", "Concepción de Oriente " => "14", "Polorós " => "14", "Lislique " => "14"]; foreach ($municipios as $municipio => $departamentoId) { Municipios::create(array("nombre" => $municipio, "departamentos_id" => $departamentoId)); } }
public function municipioAction() { $this->_helper->layout->disableLayout(); // desabilita o Zend_Layout $iduf = $_POST['iduf']; try { $municipio = new Municipios(); $buscarmunicipio = $municipio->buscar(array('idUFIBGE = ?' => $iduf)); $municipio = array(); $cont = 0; foreach ($buscarmunicipio as $dadosmunicipio) { $municipio[$cont]['idmun'] = $dadosmunicipio->idMunicipioIBGE; $municipio[$cont]['descmun'] = utf8_encode($dadosmunicipio->Descricao); $cont++; } echo json_encode($municipio); die; } catch (Zend_Exception $e) { echo json_encode(array('error' => 'true')); die; } }
public function comboAjaxAction() { $this->_helper->layout->disableLayout(); // desabilita o Zend_Layout // recebe o idUF via post $post = Zend_Registry::get('post'); $id = (int) $post->id; // integração MODELO e VISÃO $Municipios = new Municipios(); $result = $Municipios->combo(array('idUFIBGE = ?' => $id)); $a = 0; if (count($result) > 0) { foreach ($result as $registro) { $arrayMunicipios[$a]['id'] = $registro['id']; $arrayMunicipios[$a]['descricao'] = utf8_encode($registro['descricao']); $a++; } $jsonEncode = json_encode($arrayMunicipios); echo json_encode(array('resposta' => true, 'conteudo' => $arrayMunicipios)); } else { echo json_encode(array('resposta' => false)); } die; }
function getMunicipios($id) { $municipios = Municipios::where('departamentos_id', $id)->get(); return Response::json($municipios, 200); }
public function carregadadosAction() { $this->_helper->layout->disableLayout(); $this->_helper->ViewRenderer->setNoRender(true); $post = Zend_Registry::get('post'); $retorno = array(); switch ($post->option) { case 'uf': $ufDao = new Uf(); $resp = $ufDao->buscar(array('Regiao = ?' => $post->regiao), array('Sigla')); foreach ($resp as $key => $resulte) { $retorno[$key]['id'] = $resulte->idUF; $retorno[$key]['nome'] = $resulte->Sigla; } break; // xd($post->regiao); // xd($post->regiao); case 'cidade': $municipioDao = new Municipios(); $resp = $municipioDao->buscar(array('idUFIBGE = ?' => $post->idUF), array('Descricao')); foreach ($resp as $key => $resulte) { $retorno[$key]['id'] = $resulte->idMunicipioIBGE; $retorno[$key]['nome'] = utf8_encode($resulte->Descricao); } break; case 'regiao': $ufDao = new Uf(); $resp = $ufDao->buscaRegiaoPorPRONAC($post->PRONAC); $retorno = $resp[0]['Regiao']; break; case 'segmento': $ufDao = new Segmento(); $resp = $ufDao->buscar(array('Regiao = ?' => $post->regiao), array('Sigla')); foreach ($resp as $key => $resulte) { $retorno[$key]['id'] = $resulte->idUF; $retorno[$key]['nome'] = $resulte->Sigla; } break; } echo json_encode($retorno); }
public function cidadesAction() { $this->_helper->layout->disableLayout(); $post = Zend_Registry::get('post'); $idEstado = $post->idEstado; //RECUPERA AS CIDADES $Municipios = new Municipios(); $rsCidades = $Municipios->buscar(array('idUFIBGE = ?' => $idEstado)); if (count($rsCidades) > 0) { $html = ''; foreach ($rsCidades as $cidades) { $html .= '<option value="' . $cidades->idMunicipioIBGE . '">' . utf8_encode($cidades->Descricao) . '</option>'; } echo $html; } else { echo ''; } die; }
public function alterarlicitacaoAction() { /* =============================================================================== */ /* ==== VERIFICA PERMISSAO DE ACESSO DO PROPONENTE A PROPOSTA OU AO PROJETO ====== */ /* =============================================================================== */ $this->verificarPermissaoAcesso(false, true, false); //$this->_helper->layout->disableLayout(); $this->view->modalidadeConteudo = $this->modalidade; $this->view->tipoLicitacaoConteudo = $this->tipoLicitacao; $this->view->tipoCompraConteudo = $this->tipoCompra; $uf = new Uf(); $this->view->ufConteudo = $uf->buscar(array(), array('Sigla')); $get = Zend_Registry::get('get'); $this->view->idlicitacao = $get->idlicitacao; $this->view->idpronac = $get->idpronac; $this->view->itensVinculados = array(); $this->view->fornecedores = array(); if ($this->view->idlicitacao != '') { $licitacaoDao = new Licitacao(); $resposta = $licitacaoDao->buscarLicitacao($this->view->idlicitacao); $this->view->tipoCompra = $resposta[0]->tpCompra; $this->view->modalidade = $resposta[0]->tpModalidade; $this->view->tipoLicitacao = $resposta[0]->tpLicitacao; $this->view->nrProcesso = $resposta[0]->nrProcesso; $this->view->nrLicitacao = $resposta[0]->nrLicitacao; $this->view->objeto = $resposta[0]->dsObjeto; $this->view->fundamentoLegal = $resposta[0]->dsFundamentoLegal; $this->view->dataPublicacaoEdital = date('d/m/Y', strtotime($resposta[0]->dtPublicacaoEdital)); $this->view->dataAberturaLicitacao = date('d/m/Y', strtotime($resposta[0]->dtAberturaLicitacao)); $this->view->dataEncerramentoLicitacao = date('d/m/Y', strtotime($resposta[0]->dtEncerramentoLicitacao)); $this->view->valorLicitacao = $resposta[0]->vlLicitacao; $this->view->dataHomologacao = date('d/m/Y', strtotime($resposta[0]->dtHomologacao)); $this->view->codigoMunicipio = $resposta[0]->cdMunicipio; $this->view->dsMunicipio = $resposta[0]->dsMunicipio; $this->view->uf = $resposta[0]->UF; $this->view->justificativa = $resposta[0]->dsJustificativa; $licitacaoxagentesDao = new Licitacaoxagentes(); $this->view->fornecedores = $licitacaoxagentesDao->buscarFornecedoresLicitacao($this->view->idlicitacao); $tbLicitacaoPlanilhaAprovacao = new Licitacaoxplanilhaaprovacao(); $this->view->itensVinculados = $tbLicitacaoPlanilhaAprovacao->itensVinculados($this->view->idlicitacao); $Municipios = new Municipios(); $this->view->combocidades = $Municipios->combo(array('idUFIBGE = ?' => $resposta[0]->UF)); } }
echo $form->labelEx($model, 'provincia'); ?> <?php echo $form->dropDownList($model, 'provincia', CHtml::listData(Provincias::model()->findAll(array('order' => 'provincia')), 'id', 'provincia'), array('empty' => 'Seleccionar..')); ?> <?php echo $form->error($model, 'provincia'); ?> </div> <div class="row"> <?php echo $form->labelEx($model, 'localidad'); ?> <?php echo $form->dropDownList($model, 'localidad', CHtml::listData(Municipios::model()->findAll(array('order' => 'municipio')), 'id', 'municipio'), array('empty' => 'Seleccionar..')); ?> <?php echo $form->error($model, 'localidad'); ?> </div> <div class="row"> <?php echo $form->labelEx($model, 'codigoPostal'); ?> <?php echo $form->textField($model, 'codigoPostal'); ?> <?php echo $form->error($model, 'codigoPostal');
private function getPoblacion($texto) { $texto = utf8_encode($texto); $prov = new Municipios(); $row = $prov->querySelect("Id", "Municipio='{$texto}' and IdPais=68", "Id limit 1"); return $row[0]['Id'] ? $row[0]['Id'] : 0; }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { // if (Municipios::destroy($id)) { $respuesta["registros"] = []; $respuesta["mensaje"] = "Registro eliminado exitosamente"; $respuesta["resultado"] = true; return $respuesta; } else { $respuesta["registros"] = []; $respuesta["mensaje"] = "El registro no existe"; $respuesta["resultado"] = false; return $respuesta; } }
public function resultadoPcRegiaoUfCidadeAction() { header("Content-Type: text/html; charset=ISO-8859-1"); $this->_helper->layout->disableLayout(); $post = Zend_Registry::get('post'); //recuperando filtros do POST $arrBusca = array("modalidade = ?" => 76); if ($post->regiao != "") { $arrBusca["u.Regiao = ?"] = $post->regiao; } if ($post->uf != "") { $arrBusca["u.CodUfIbge = ?"] = $post->uf; } //if($post->cidade != ""){ $arrBusca["i.Cidade = ?"] = $post->cidade; } if (!empty($post->cidade)) { $tblMunicipio = new Municipios(); $rsMunicipio = $tblMunicipio->buscar(array("idMunicipioIBGE = ?" => $post->cidade))->current(); $arrBusca["i.Cidade = ?"] = $rsMunicipio->Descricao; } //Varifica se foi solicitado a ordenação if (!empty($post->ordenacao)) { $ordem[] = "{$post->ordenacao} {$post->tipoOrdenacao}"; } else { $ordem = array("5", "4", "3"); } $tbl = new Projetos(); $total = $tbl->pontoCulturaRegiaoUfCidade($arrBusca, $ordem, null, null); $total = count($total); if ($post->tipo == 'xls' || $post->tipo == 'pdf') { //buscando os registros no banco de dados $tamanho = -1; $inicio = -1; $pag = 0; $totalPag = 0; $fim = 0; $rs = $tbl->pontoCulturaRegiaoUfCidade($arrBusca, $ordem, $tamanho, $inicio); $this->_forward('preparar-xls-pdf', null, null, array('dados' => $rs, 'view' => 'relatorio/preparar-xls-pdf-pc-regiao-uf-cidade.phtml', 'tipo' => $post->tipo)); } else { //controlando a paginacao $this->intTamPag = 10; $pag = 1; if (isset($post->pag)) { $pag = $post->pag; } if (isset($post->tamPag)) { $this->intTamPag = $post->tamPag; } $inicio = $pag > 1 ? ($pag - 1) * $this->intTamPag : 0; $fim = $inicio + $this->intTamPag; $totalPag = (int) ($total % $this->intTamPag == 0 ? $total / $this->intTamPag : $total / $this->intTamPag + 1); $tamanho = $fim > $total ? $total - $inicio : $this->intTamPag; $rs = $tbl->pontoCulturaRegiaoUfCidade($arrBusca, $ordem, $tamanho, $inicio); } $this->view->registros = $rs; $this->view->pag = $pag; $this->view->total = $total; $this->view->inicio = $inicio + 1; $this->view->fim = $fim; $this->view->totalPag = $totalPag; $this->view->parametrosBusca = $_POST; }
public function criteriosParticipacaoAction() { $this->view->submenuativo = 'criterioparticipacao'; $idEdital = $this->_request->getParam('idEdital'); $idModulo = $this->_request->getParam('idModulo'); $idCategoria = $this->_request->getParam('idCategoria'); $this->view->idEdital = $idEdital; $this->view->idModulo = $idModulo; $this->view->idCategoria = $idCategoria; $modelModulos = new tbModulo(); $modelCategoriaModulo = new tbCategoria(); $modelCriterioParticipacao = new tbCriterioParticipacao(); $modelUF = new Uf(); $modelMunicipios = new Municipios(); $modelFluxoEdital = new tbEditalFluxo(); $mostrarSubMenuPag = 0; $fluxoPagamentoEdital = $modelFluxoEdital->buscarFluxoPorEdital(array('ef.idEdital = ?' => $idEdital, 'ef.idFluxo = ?' => 3)); if (count($fluxoPagamentoEdital) > 0) { $mostrarSubMenuPag = 1; } $this->view->mostrarSubMenuPag = $mostrarSubMenuPag; $listaUF = $modelUF->buscar(array(), array('Descricao')); $this->view->listaUF = $listaUF; $listaMunicipios = $modelMunicipios->buscaCompleta(array(), array('mu.idUFIBGE', 'mu.Descricao'), false); // $listaMunicipios = $modelMunicipios->buscar(array(), array('idUFIBGE','Descricao')); $this->view->listaMunicipios = $listaMunicipios; // xd(count($listaMunicipios)); $criterioParticipacao = $modelCriterioParticipacao->buscarCriterioPorIdCategoria($idCategoria); $this->view->criterioParticipacao = $criterioParticipacao; $arrModulos = array(); $listaModulos = $modelModulos->buscarModulo($idEdital); if (count($listaModulos) > 0) { $i = 0; foreach ($listaModulos as $mod) { $arrModulos[$i]['idModulo'] = $mod->idModulo; $arrModulos[$i]['dsModulo'] = $mod->dsModulo; $listaCategMod = $modelCategoriaModulo->buscar(array('idModulo = ?' => $mod->idModulo)); $arrCatModulos = array(); $c = 0; foreach ($listaCategMod as $cat) { $arrCatModulos[$c]['idCategoria'] = $cat['idCategoria']; $arrCatModulos[$c]['nmCategoria'] = $cat['nmCategoria']; $c++; } $arrModulos[$i]['catModulo'] = $arrCatModulos; $i++; } } $this->view->modulos = $arrModulos; $this->view->qtdModulos = count($arrModulos); }
<?php include_once 'MunicipioEntity.php'; $municipio = new Municipios(); $municipios = $municipio->getMunicipios(); print_r($municipios); return $municipios;
$filtro = "Provincia LIKE '%{$_GET['term']}%'"; if ($_GET['filtroAdicional']) { $filtro .= " and IDPais='{$_GET['filtroAdicional']}'"; } $provincia = new Provincias(); $rows = $provincia->cargaCondicion("Id, Provincia as Value", $filtro, "Provincia"); unset($provincia); break; // BUSCA MUNICIPIOS POR %Municipio% // BUSCA MUNICIPIOS POR %Municipio% case 'municipios': $filtro = "Municipio LIKE '%{$_GET['term']}%'"; if ($_GET['filtroAdicional']) { $filtro .= " and IdProvincia='{$_GET['filtroAdicional']}'"; } $municipio = new Municipios(); $rows = $municipio->cargaCondicion("Id, Municipio as Value", $filtro, "Municipio"); unset($municipio); break; // BUSCA MONEDAS POR %Moneda% // BUSCA MONEDAS POR %Moneda% case 'monedas': $filtro = "Moneda LIKE '%{$_GET['term']}%'"; $moneda = new Monedas(); $rows = $moneda->cargaCondicion("Id, Moneda as Value", $filtro, "Moneda"); unset($moneda); break; // BUSCA ZONAS HORARIAS POR %zonaHoraria% // BUSCA ZONAS HORARIAS POR %zonaHoraria% case 'zonasHorarias': $filtro = "Zona LIKE '%{$_GET['term']}%'";
public function Clientes() { $nItems = 0; $nErrores = 0; $dbLink = mysql_connect("localhost", "root", "albatronic"); $query = "TRUNCATE {$this->dbDestino}.ErpClientes"; mysql_query($query); $query = "TRUNCATE {$this->dbDestino}.ErpClientesDentrega"; mysql_query($query); $query = "select * from {$this->dbOrigen}.clientes"; $result = mysql_query($query, $dbLink); $poblaciones = new Municipios(); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $row = $this->utf($row); //if ($row['NombreComercial'] == '') // $row['NombreComercial'] = $row['RazonSocial']; $poblacion = $poblaciones->cargaCondicion("IDMunicipio,IDProvincia", "Municipio='{$row['Poblacion']}'"); $c = new Clientes(); $c->setIDCliente($row['IDCliente']); $c->setRazonSocial(utf8_decode($row['RazonSocial'])); $c->setNombreComercial(utf8_decode($row['NombreComercial'])); $c->setCif($row['Cif']); $c->setDireccion(utf8_decode($row['Direccion'])); $c->setIDPais(68); if ($poblacion[0]['IDMunicipio']) { $c->setIDProvincia($poblacion[0]['IDProvincia']); $c->setIDPoblacion($poblacion[0]['IDMunicipio']); } else { $c->setIDProvincia($row['IDProvincia']); $row['Avisos'] = $row['Poblacion']; } $c->setCodigoPostal($row['CodigoPostal']); $c->setTelefono($row['Telefono']); $c->setFax($row['Fax']); $c->setMovil($row['Movil']); $c->setEMail($row['EMail']); $c->setWeb($row['Web']); $c->setCContable($row['CContable']); $c->setBanco($row['IDBanco']); $c->setOficina($row['IDOficina']); $c->setDigito($row['Digito']); $c->setCuenta($row['Cuenta']); $c->setIban(Utils::iban($row['IDBanco'] . $row['IDOficina'] . $row['Digito'] . $row['Cuenta'])); $c->setMandato($row['IDCliente']); $c->setFechaMandato('2013-01-01'); $c->setIDTipo($row['IDTipo']); $c->setIDGrupo($row['IDGrupo']); $c->setIDFP($row['IDFP']); $c->setDiaDePago($row['DiaDePago']); $c->setRecargoEqu($row['RecargoEqu']); $c->setIDTarifa(1); $c->setIDZona(1); $c->setObservaciones($row['Observaciones']); $c->setAvisos($row['Avisos']); $c->setVigente($row['Vigente']); $c->setIDComercial($this->agentes[$row['IDAgente']]); $c->setLimiteRiesgo($row['LimiteRiesgo']); $c->setFechaNacimiento($row['FechaNacimiento']); $c->setPrimaryKeyMD5(md5($row['IDCliente'])); $c->setIDZona(1); if (!$c->create()) { $errores[] = $c->getErrores(); $nErrores++; } else { $nItems++; } } //mysql_close($dbLink); echo "Clientes {$nItems}<br/>"; if (count($errores)) { echo "<pre>"; print_r($errores); echo "</pre>"; } }
public function resultadoAgenciaBancariaAction() { header("Content-Type: text/html; charset=ISO-8859-1"); $this->_helper->layout->disableLayout(); $post = Zend_Registry::get('post'); $arrBusca = array(); if (!empty($post->banco)) { $arrBusca["c.Banco = ?"] = $post->banco; } if (!empty($post->uf)) { $tblUf = new Uf(); $rsUf = $tblUf->buscar(array("idUF = ?" => $post->uf))->current(); $arrBusca["a.Uf = ?"] = $rsUf->Sigla; } if (!empty($post->cidade)) { $tblMunicipio = new Municipios(); $rsMunicipio = $tblMunicipio->buscar(array("idMunicipioIBGE = ?" => $post->cidade))->current(); $arrBusca["a.Cidade = ?"] = $rsMunicipio->Descricao; } if (!empty($post->mecanismo)) { $arrBusca["c.Mecanismo = ?"] = $post->mecanismo; } if (!empty($post->area)) { $arrBusca["p.Area = ?"] = $post->area; } if (!empty($post->tipoPessoa)) { $arrBusca["i.tipoPessoa = ?"] = $post->tipoPessoa; } if (!empty($post->agencia)) { $arrBusca["c.Agencia = ?"] = retiraMascara($post->agencia); } if (!empty($post->dtLoteRemessaCB) || $post->tpDtLoteRemessaCB != '') { if ($post->tpDtLoteRemessaCB == "igual") { $arrBusca['DtLoteRemessaCB >= ?'] = ConverteData($post->dtLoteRemessaCB, 13) . " 00:00:00"; $arrBusca['DtLoteRemessaCB <= ?'] = ConverteData($post->dtLoteRemessaCB, 13) . " 23:59:59"; } elseif ($post->tpDtLoteRemessaCB == "maior") { $arrBusca['DtLoteRemessaCB >= ?'] = ConverteData($post->dtLoteRemessaCB, 13) . " 00:00:00"; } elseif ($post->tpDtLoteRemessaCB == "menor") { $arrBusca['DtLoteRemessaCB <= ?'] = ConverteData($post->dtLoteRemessaCB, 13) . " 00:00:00"; } elseif ($post->tpDtLoteRemessaCB == "OT") { $arrBusca['DtLoteRemessaCB = ?'] = date("Y-m-") . (date("d") - 1) . " 00:00:00"; } elseif ($post->tpDtLoteRemessaCB == "U7") { $arrBusca['DtLoteRemessaCB > ?'] = date("Y-m-") . (date("d") - 7) . " 00:00:00"; $arrBusca['DtLoteRemessaCB < ?'] = date("Y-m-d") . " 23:59:59"; } elseif ($post->tpDtLoteRemessaCB == "SP") { $arrBusca['DtLoteRemessaCB > ?'] = date("Y-m-") . (date("d") - 7) . " 00:00:00"; $arrBusca['DtLoteRemessaCB < ?'] = date("Y-m-d") . " 23:59:59"; } elseif ($post->tpDtLoteRemessaCB == "MM") { $arrBusca['DtLoteRemessaCB > ?'] = date("Y-m-01") . " 00:00:00"; $arrBusca['DtLoteRemessaCB < ?'] = date("Y-m-d") . " 23:59:59"; } elseif ($post->tpDtLoteRemessaCB == "UM") { $arrBusca['DtLoteRemessaCB > ?'] = date("Y-") . (date("m") - 1) . "-01 00:00:00"; $arrBusca['DtLoteRemessaCB < ?'] = date("Y-") . (date("m") - 1) . "-31 23:59:59"; } else { $arrBusca['DtLoteRemessaCB > ?'] = ConverteData($post->dtLoteRemessaCB, 13) . " 00:00:00"; if ($post->dtLoteRemessaCB_Final != "") { $arrBusca['DtLoteRemessaCB < ?'] = ConverteData($post->dtLoteRemessaCB_Final, 13) . " 23:59:59"; } } } if (!empty($post->dtLoteRemessaCL) || $post->tpDtLoteRemessaCL != '') { if ($post->tpDtLoteRemessaCL == "igual") { $arrBusca['DtLoteRemessaCL >= ?'] = ConverteData($post->dtLoteRemessaCL, 13) . " 00:00:00"; $arrBusca['DtLoteRemessaCL <= ?'] = ConverteData($post->dtLoteRemessaCL, 13) . " 23:59:59"; } elseif ($post->tpDtLoteRemessaCL == "maior") { $arrBusca['DtLoteRemessaCL >= ?'] = ConverteData($post->dtLoteRemessaCL, 13) . " 00:00:00"; } elseif ($post->tpDtLoteRemessaCL == "menor") { $arrBusca['DtLoteRemessaCL <= ?'] = ConverteData($post->dtLoteRemessaCL, 13) . " 00:00:00"; } elseif ($post->tpDtLoteRemessaCL == "OT") { $arrBusca['DtLoteRemessaCL = ?'] = date("Y-m-") . (date("d") - 1) . " 00:00:00"; } elseif ($post->tpDtLoteRemessaCL == "U7") { $arrBusca['DtLoteRemessaCL > ?'] = date("Y-m-") . (date("d") - 7) . " 00:00:00"; $arrBusca['DtLoteRemessaCL < ?'] = date("Y-m-d") . " 23:59:59"; } elseif ($post->tpDtLoteRemessaCL == "SP") { $arrBusca['DtLoteRemessaCL > ?'] = date("Y-m-") . (date("d") - 7) . " 00:00:00"; $arrBusca['DtLoteRemessaCL < ?'] = date("Y-m-d") . " 23:59:59"; } elseif ($post->tpDtLoteRemessaCL == "MM") { $arrBusca['DtLoteRemessaCL > ?'] = date("Y-m-01") . " 00:00:00"; $arrBusca['DtLoteRemessaCL < ?'] = date("Y-m-d") . " 23:59:59"; } elseif ($post->tpDtLoteRemessaCL == "UM") { $arrBusca['DtLoteRemessaCL > ?'] = date("Y-") . (date("m") - 1) . "-01 00:00:00"; $arrBusca['DtLoteRemessaCL < ?'] = date("Y-") . (date("m") - 1) . "-31 23:59:59"; } else { $arrBusca['DtLoteRemessaCL > ?'] = ConverteData($post->dtLoteRemessaCL, 13) . " 00:00:00"; if ($post->dtLoteRemessaCL_Final != "") { $arrBusca['DtLoteRemessaCL < ?'] = ConverteData($post->dtLoteRemessaCL_Final, 13) . " 23:59:59"; } } } //xd($arrBusca); $tbl = new ContaBancaria(); //xd($_POST); if ($post->tipo == 'xls' || $post->tipo == 'pdf') { //buscando os registros no banco de dados $tamanho = -1; $inicio = -1; $pag = 0; $totalPag = 0; $total = 0; $fim = 0; $rs = $tbl->buscar($arrBusca, array(), $tamanho, $inicio); $this->_forward('preparar-xls-pdf', null, null, array('dados' => $rs, 'view' => 'operacional/preparar-xls-pdf-agencia-bancaria.phtml', 'tipo' => $post->tipo)); } else { $pag = 1; //$get = Zend_Registry::get('get'); if (isset($post->pag)) { $pag = $post->pag; } if (isset($post->tamPag)) { $this->intTamPag = $post->tamPag; } $inicio = $pag > 1 ? ($pag - 1) * $this->intTamPag : 0; $fim = $inicio + $this->intTamPag; $total = $tbl->pegaTotal($arrBusca); $total = $total["total"]; //xd($total); $totalPag = (int) ($total % $this->intTamPag == 0 ? $total / $this->intTamPag : $total / $this->intTamPag + 1); $tamanho = $fim > $total ? $total - $inicio : $this->intTamPag; if ($fim > $total) { $fim = $total; } //Varifica se foi solicitado a ordenação if (!empty($post->ordenacao)) { $ordem[] = "{$post->ordenacao} {$post->tipoOrdenacao}"; } else { $ordem = array('Descricao ASC'); } $rs = $tbl->buscar($arrBusca, $ordem, $tamanho, $inicio); //xd($total); } $this->view->contasBancarias = $rs; $this->view->pag = $pag; $this->view->total = $total; $this->view->inicio = $inicio + 1; $this->view->fim = $fim; $this->view->totalPag = $totalPag; $this->view->parametrosBusca = $_POST; }
/** * Importa clientes desde fichero externo csv según * el formato de facturaplus */ public function ImportarAction() { $fileName = "docs/docs{$_SESSION['emp']}/tmp/clientes.csv"; $archivo = new Archivo($fileName); $archivo->setColumnsDelimiter(";"); $archivo->setColumnsEnclosure('"'); $idPais = 68; // España // Crear array de poblaciones if ($archivo->open("r")) { set_time_limit(0); while (($linea = $archivo->readLine()) !== FALSE) { $poblaciones[trim($linea[4])] = 0; } $pobla = new Municipios(); foreach ($poblaciones as $key => $value) { $rows = $pobla->cargaCondicion("IDMunicipio", "Municipio='{$key}'"); if ($rows[0]['IDMunicipio'] != '') { $poblaciones[$key] = $rows[0]['IDMunicipio']; } } unset($pobla); $archivo->close(); } else { $this->values['errores'][] = "El fichero de importación " . $fileName . " no existe"; } if ($archivo->open("r")) { set_time_limit(0); while (($linea = $archivo->readLine()) !== FALSE) { //print_r($linea); $fp = new FormasPago(); $fp = $fp->find('Observations', trim($linea[20])); $idFp = $fp->getIDFP(); if (!$idFp) { $idFp = 1; } $cliente = new Clientes(); $cliente->setIDCliente($linea[0]); $cliente->setRazonSocial(utf8_encode($linea[1])); $cliente->setNombreComercial(utf8_encode($linea[2])); $cliente->setDireccion(utf8_encode($linea[3])); $cliente->setIDPoblacion($poblaciones[trim($linea[4])]); $cliente->setIDProvincia($linea[5]); $cliente->setCodigoPostal($linea[6]); $cliente->setIDPais($idPais); $cliente->setTelefono($linea[7]); $cliente->setMovil($linea[8]); $cliente->setFax($linea[9]); $cliente->setCif(str_replace("-", "", $linea[10])); $cliente->setObservaciones($linea[11] . " " . $linea[19]); $cliente->setBanco($linea[15]); $cliente->setOficina($linea[16]); $cliente->setDigito(substr($linea[17], 2, 2)); $cliente->setCuenta($linea[18]); $cliente->setIDFP($idFp); $cliente->setEMail($linea[41]); $cliente->setLimiteRiesgo($linea[38]); $cliente->setIDZona(1); $cliente->setIDSucursal($_SESSION['suc']); $cliente->setIDTipo(1); $cliente->setIDGrupo(1); $idCliente = $cliente->create(); if (!$idCliente) { $nErrores += 1; print_r($cliente->getErrores()); } else { $nAciertos += 1; } unset($cliente); } $archivo->close(); } else { $this->values['errores'][] = "El fichero de importación " . $fileName . " no existe"; } echo "Aciertos: {$nAciertos}, Errores: {$nErrores}"; unset($archivo); }
public function getState() { if (Request::ajax()) { $id = Input::get('id'); $municipio = Municipios::where('estado_id', '=', $id)->get(); return $municipio; } }