public function getPackages($id)
{
$sql = 'SELECT * FROM h2h_Programa WHERE id = "' . $id . '" ';
$datos = $this->_db->consulta($sql);
$objPackages = false;
if ($this->_db->numRows($datos) > 0) {
$arrayPackages = $this->_db->fetchAll($datos);
$objPackages = new programaDTO();
foreach ($arrayPackages as $packDB) {
$objPackages->setCodigo(trim($packDB['codigo']));
$objPackages->setNombre(trim($packDB['nombre']));
}
}
return $objPackages;
}
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;
}
}
