package com.tutosoftware.manager.repository;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;

import com.tutosoftware.manager.model.Usuario;

@Repository
public interface UsuarioRepository extends JpaRepository<Usuario,String>{

}

		   
		   
	     
       

 
             
       package com.tutosoftware.manager.repository;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;

import com.tutosoftware.manager.model.Cliente;



@Repository
public interface ClienteRepository extends JpaRepository<Cliente,Long> {

}

  
         
         
         
       

 
       
	package com.tutosoftware.manager.repository;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;

import com.tutosoftware.manager.model.Proyecto;

@Repository
public interface ProyectoRepository extends JpaRepository<Proyecto,Long>{

}	   
		   
		   
     
       

 
       
		package com.tutosoftware.manager.repository;


import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

import com.tutosoftware.manager.model.Actividad;

@Repository
public interface ActividadRepository extends JpaRepository<Actividad,Long>{
	
	
	@Query(value=" select * from actividad" +
		      " where  email_usuario = :email and "
		      + " EXTRACT(YEAR FROM fecha) = :year " +
			  " and  EXTRACT(MONTH FROM fecha) = :mes  ",nativeQuery = true)
		List<Actividad> findByClienteAndFechaHoraInicioAndFechaHoraFinal(String email,int year,int mes);

}