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