public function getProgramaId($id) { $sql = 'EXEC TS_GET_PROGRAMAS_ID ' . $id . ' '; $datos = $this->_db->consulta($sql); if ($this->_db->numRows($datos) > 0) { $objetosProg = array(); $arrayProgramas = $this->_db->fetchAll($datos); foreach ($arrayProgramas as $progDB) { $objProg = new programaDTO(); $objProg->setId(trim($progDB['idProg'])); $objProg->setNombre(trim($progDB['titulo'])); $objProg->setNota(trim($progDB['nota'])); $objProg->setPais(trim($progDB['paisPRG'])); $objProg->setCiudad(trim($progDB['ciuPRG'])); $objProg->setIti(trim($progDB['itinera'])); $ext = Funciones::getExtensionImagen('http://online.panamericanaturismo.cl/public/img/programas/upl_' . str_replace(' ', '_', trim($progDB['codProg']))); if ($ext) { $objProg->setImagen('upl_' . str_replace(' ', '_', trim($progDB['codProg'])) . $ext); } else { $objProg->setImagen(''); } $objProg->setNoches(trim($progDB['ntsProg'])); $objetosProg[] = $objProg; } return $objetosProg; } else { return false; } }
public function exeTS_GET_PROGRAMAS($sql) { //echo $sql;exit; $datos = $this->_db->consulta($sql); if ($this->_db->numRows($datos) > 0) { $objetosProg = array(); $arrayProgramas = $this->_db->fetchAll($datos); foreach ($arrayProgramas as $progDB) { $objProg = new programaDTO(); $objProg->setId(trim($progDB['idProg'])); $objProg->setCodigo(trim($progDB['codProg'])); if (isset($progDB['desde'])) { $objProg->setDesde(trim($progDB['desde'])); } if (isset($progDB['hasta'])) { $objProg->setHasta(trim($progDB['hasta'])); } $objProg->setNoches(trim($progDB['ntsProg'])); $objProg->setTipoP(trim($progDB['tipoProg'])); $objProg->setCodBloq(trim($progDB['codBloq'])); $objProg->setEspacios(trim($progDB['espacios'])); $objProg->setPais(trim($progDB['paisPRG'])); $objProg->setCiudad(trim($progDB['ciuPRG'])); $objProg->setTitulo(trim($progDB['titulo'])); $objProg->setEpigrafe(trim($progDB['epigrafe'])); $objProg->setMoneda(trim($progDB['moneda'])); $objProg->setTcambio(trim($progDB['tcambio'])); $objProg->setValorDesde(trim($progDB['valdesde'])); $objProg->setAereo(trim($progDB['aereo'])); $objProg->setHotel(trim($progDB['hotel'])); $objProg->setTraslado(trim($progDB['traslado'])); $objProg->setAllInclu(trim($progDB['allInclu'])); $objProg->setRAuto(trim($progDB['rauto'])); $objProg->setCrucero(trim($progDB['crucero'])); $objProg->setAsis(trim($progDB['asisten'])); $objProg->setIti(trim($progDB['itinera'])); if (isset($progDB['ESTADO'])) { $objProg->setEstado(trim($progDB['ESTADO'])); } $ext = Functions::getExtensionImagen(ROOT . 'public' . DS . 'img' . DS . 'programas' . DS . 'upl_' . str_replace(' ', '_', trim($progDB['codProg']))); if ($ext) { $objProg->setImagen('upl_' . str_replace(' ', '_', trim($progDB['codProg'])) . $ext); } else { $objProg->setImagen(''); } $objProg->setNota(trim($progDB['nota'])); $objProg->setIncluye(str_replace("<br />", "<br /><span style='color:#008ccc;'>•</span> ", trim($progDB['incluye']))); $objProg->setDescrip(html_entity_decode(trim($progDB['descrip']))); $objProg->setPbhotel(trim($progDB['pdHotel'])); // $objProg->setPdaereo(trim($progDB['pdAereo'])); // $plan = trim($progDB['pdPlana']); if ($plan === '1') { $plan = 'All Inclusive'; } if ($plan === '2') { $plan = 'Media Pension'; } if ($plan === '3') { $plan = 'Desayuno'; } if ($plan === '4') { $plan = 'Pension Completa'; } $objProg->setPdplana($plan); $objProg->setPdseguro(trim($progDB['pdSeguro'])); // $objProg->setPdtraslados(trim($progDB['pdTraslados'])); // if (isset($progDB['CatEstrella'])) { $objProg->setCatEstrella(trim($progDB['CatEstrella'])); } if (isset($progDB['iata'])) { $objProg->setIata(trim($progDB['iata'])); } $objetosProg[] = $objProg; } return $objetosProg; } else { return false; } }