public function exeTraeProgramas($sql, $inc = false) { $datos = $this->_db->consulta($sql); if ($this->_db->numRows($datos) > 0) { $objetosPack = array(); $arrayPackages = $this->_db->fetchAll($datos); foreach ($arrayPackages as $packDB) { $hotel = array(); $codHotel = array(); $PA = array(); $TH = array(); $codTH = array(); $cat = array(); $ciudad = array(); $incluye = array(); $valorHab = array(); $objPackages = new programaDTO(); if (trim(isset($packDB['Error']))) { $objPackages->setERROR(trim($packDB['Error'])); $objPackages->setLINEA(trim($packDB['Linea'])); $objPackages->setMENSAJE(trim($packDB['Mensaje'])); } else { $objPackages->setId(trim($packDB['idPRG'])); $objPackages->setNombre(trim($packDB['nombrePRG'])); $objPackages->setNota(trim($packDB['notaPRG'])); $objPackages->setIdOpc(trim($packDB['idOpcion'])); $objPackages->setDesde(trim($packDB['desde'])); $objPackages->setTramo(trim($packDB['Tramo'])); $objPackages->setNotaOpc(trim($packDB['notaOPC'])); $objPackages->setMoneda(trim($packDB['moneda'])); $objPackages->setItiVuelo(trim($packDB['itinerarioVuelo'])); /* VALOR HABITACION */ for ($i = 1; $i <= 3; $i++) { $valorHab[] = trim($packDB['vHab_' . $i]); } $objPackages->setValorHab($valorHab); /* VALOR HABITACION */ /* HOTELES */ for ($i = 1; $i <= 5; $i++) { $hotel[] = trim($packDB['hotel_' . $i]); $codHotel[] = trim($packDB['codHotel_' . $i]); $PA[] = trim($packDB['PlanAlimenticio_' . $i]); $TH[] = trim($packDB['TipoHabitacion_' . $i]); $codTH[] = trim($packDB['codTipoHabitacion_' . $i]); $cat[] = trim($packDB['cat_' . $i]); $ciudad[] = trim($packDB['ciudad_' . $i]); } $objPackages->setHoteles($hotel); $objPackages->setCodHoteles($codHotel); $objPackages->setPA($PA); $objPackages->setTH($TH); $objPackages->setCodTH($codTH); $objPackages->setCat($cat); $objPackages->setCiudad($ciudad); /* HOTELES */ if ($inc) { $incluye[] = $this->getIncluye(trim($packDB['idPRG'])); $objPackages->setIncluye($incluye); } //$objPackages->setXXXX(trim($packDB['xxxxx'])); } $objetosPack[] = $objPackages; //sleep(1); } return $objetosPack; } else { return false; } }