personaController.java
no perfe + @DateTimeFormat
@Controller
public class PersonaController {
@Autowired
PeopleRepository peopleRepository;
@Autowired
MoviesRepository moviesRepository;
@Autowired
GenresRepository genresRepository;
protected String listarConFiltro(Filtro filtro, Model model){
List personas;
// boolean mostrarReparto = false;
// boolean mostrarTrabajos = false;
if(filtro==null){
filtro = new Filtro();
personas = peopleRepository.findAll();
} else if (filtro.getTipo().equalsIgnoreCase("reparto")) {
personas = peopleRepository.findByCadenaYReparto(filtro.getCadena());
}else {
personas = peopleRepository.findByCadenaYTrabajos(filtro.getCadena());
}
model.addAttribute("personas", personas);
model.addAttribute("filtro", filtro);
return "personas";
}
@GetMapping("/")
public String doListar(Model model){
return listarConFiltro(null, model);
}
@GetMapping("https://dev.to/editar")
public String doEditar(@RequestParam("id")Integer id, Model model){
Movies pelicula = moviesRepository.findById(id).orElse(null);
model.addAttribute("pelicula", pelicula);
model.addAttribute("generos", genresRepository.findAll());
return "pelicula";
}
@PostMapping("https://dev.to/guardar")
public String doGuardar(@ModelAttribute("pelicula")Movies modelPelicula){
Movies pelicula = moviesRepository.findById(modelPelicula.getId()).orElse(null);
pelicula.setTitle(modelPelicula.getTitle());
pelicula.setRuntime(modelPelicula.getRuntime());
pelicula.setRevenue(modelPelicula.getRevenue());
pelicula.setGenresList(modelPelicula.getGenresList());
moviesRepository.save(pelicula);
return "redirect:/";
}
@PostMapping("https://dev.to/filtrar")
public String doFiltrar(@ModelAttribute("filtro")Filtro filtro, Model model){
// List personas;
// if(filtro.getTipo().equalsIgnoreCase("reparto")){
// personas = peopleRepository.findByCadenaYReparto(filtro.getCadena());
// }else{
// personas = peopleRepository.findAll();
// }
// model.addAttribute("filtro", filtro);
// model.addAttribute("personas", personas);
//return "personas";
return listarConFiltro(filtro, model);
}
}
@DateTimeFormat(pattern = "yyyy-mm-dd")
@Temporal(TemporalType.DATE)
private Date releaseDate;
Vista
personas.jsp
<%@ taglib prefix="form" uri="http://www.springframework.org/tags/form" %>
<%@ page import="es.taw.movies.entity.People" %>
<%@ page import="java.util.List" %>
<%@ page import="es.taw.movies.entity.MovieCast" %>
<%@ page import="es.taw.movies.entity.MovieCrew" %>
<%@ page import="es.taw.movies.ui.Filtro" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%
String title = "Listado de personas";
List personas = (List) request.getAttribute("personas");
Filtro filtro = (Filtro) request.getAttribute("filtro");
boolean mostrarReparto = filtro.getTipo().isBlank() || filtro.getTipo().equalsIgnoreCase("reparto");
boolean mostrarTrabajador = filtro.getTipo().isEmpty() || "trabajador".equalsIgnoreCase(filtro.getTipo());
%>
<%=title%>>
<%=title%>
y contiene: Filtrar Borrar Filtro
NOMBRE
<%
if(mostrarReparto){
%>
PELÍCULAS - PERSONAJES
<%
}
if(mostrarTrabajador){
%>
PELÍCULAS - CARGOS
<%
}
%>
<%
for(People p: personas){
%>
<%=p.getName()%>
<%
if(mostrarReparto){
%>
<%
for(MovieCast cast : p.getMovieCastList()){
%>
<%=cast.getMovieId().getTitle()%> - <%=cast.getCharacterName()%>
<%
}
%>
<%
}
if(mostrarTrabajador){
%>
<%
for(MovieCrew crew : p.getMovieCrewList()){
%>
<%=crew.getMovieId().getTitle()%> - <%=crew.getJob()%>
<%
}
%>
<%
}
%>
<%
}
%>
pelicula.jsp
<%@ taglib prefix="form" uri="http://www.springframework.org/tags/form" %>
<%@ page import="es.taw.movies.entity.People" %>
<%@ page import="java.util.List" %>
<%@ page import="es.taw.movies.entity.MovieCast" %>
<%@ page import="es.taw.movies.entity.MovieCrew" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%
String title = "Ficha de la película";
%>
<%=title%>>
<%=title%>
Título:
Duración:
Recaudación:
Generos:
Guardar
Repo
public interface PeopleRepository extends JpaRepository {
@Query("select p from People p join p.movieCastList cast where cast.characterName like concat('%',:cadena,'%') ")
public List findByCadenaYReparto(@Param("cadena")String cadena);
@Query("select p from People p join p.movieCrewList crew where crew.job like concat('%',:cadena,'%') ")
public List findByCadenaYTrabajos(@Param("cadena")String cadena);
}
Filtro
package es.taw.movies.ui;
import lombok.Data;
@Data
public class Filtro {
String cadena;
String tipo="";
}