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 validaPrograma($id, $idOpc) { $sql = 'SELECT P.codigo, P.nombre FROM h2h_programaOpc PO JOIN h2h_programa P ON (PO.IdProg=P.Id) WHERE P.Id=' . $id . ' AND PO.IdOpc=' . $idOpc; $datos = $this->_db->consulta($sql); if ($this->_db->numRows($datos) > 0) { $objetosPack = array(); $arrayPackages = $this->_db->fetchAll($datos); $objPackages = new programaDTO(); $objPackages->setCodigo(trim($arrayPackages[0]['codigo'])); $objPackages->setNombre(trim($arrayPackages[0]['nombre'])); $objetosPack[] = $objPackages; return $objetosPack; } else { return false; } }