1#@!#!123s

: / home1 / netbooks / public_html / __nbgym / models /
Filename : exercicios.php
back
<?php
class Exercicios {
	
	function __construct() {
       $this->auth = new database();
    }
	
	function getDetalhes($parametros=null) {
		$conexao=$this->auth;
		
		$qry = "select *
				FROM exercicios
				WHERE id = ?";
		$r = $conexao->selectDB($qry, $parametros);
		Return $r;
	}	
	
	function getTiposExercicio($parametros=null) {
		$conexao=$this->auth;
		
		$qry = "select id, tipo
				FROM tipos_exercicio
				WHERE estado = 'A'";
		$r = $conexao->selectDB($qry, $parametros);
		Return $r;
	}
	
	function getGruposMusculares($parametros=null) {
		$conexao=$this->auth;
		
		$qry = "select id, designacao
				FROM grupos_musculares
				WHERE estado = 'A'";
		$r = $conexao->selectDB($qry, $parametros);
		Return $r;
	}	
	
	function getMedia($parametros=null) {
		$conexao=$this->auth;
		
		$qry = "select *
				FROM exercicios_media
				WHERE id_exercicio =  ?";
		$r = $conexao->selectDB($qry, $parametros);
		Return $r;
	}	
	
	function getExerciciosDoTipo($parametros=null) {
		$conexao=$this->auth;
		
		$qry = "select id FROM exercicios WHERE id_tipo_exercicio = ?";
		$r = $conexao->selectDB($qry, $parametros);
		Return $r;
	}
	
	function getExerciciosDoGrupoMuscular($parametros=null) {
		$conexao=$this->auth;
		
		$qry = "select id FROM exercicios WHERE id_grupo_muscular_principal = ?";
		$r = $conexao->selectDB($qry, $parametros);
		Return $r;
	}
	
	function getExerciciosEmPlanos($parametros=null) {
		$conexao=$this->auth;
		
		$qry = "select id FROM planos_treinos_det WHERE id_exercicio = ?";
		$r = $conexao->selectDB($qry, $parametros);
		Return $r;
	}
	
}
?>