/**
* 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;
}
}
