Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if(version.IsNull){
- List<Titulo> findDistinctTituloByDataPagamentoTituloIsNullOrIdNotInAndClienteUsuarioAppClientesUsuarioAppIdAndDataPagamentoTituloIsNull(
- Set<Long> idsNoApp, UUID idUsuarioApp);
- }else{
- List<Titulo> findDistinctTituloByVersionGreaterThanAndDataPagamentoTituloIsNullOrIdNotInAndClienteUsuarioAppClientesUsuarioAppIdAndDataPagamentoTituloIsNull(LocalDateTime version, Set<Long> idsNoApp, UUID idUsuarioApp);
- }
- //Ou
- if(version.NotNull){
- @Query("select DISTINCT bean from Titulo bean INNER JOIN bean.cliente cli INNER JOIN cli.usuarioAppClientes uapp_cli "
- + " INNER JOIN uapp_cli.usuarioApp uapp "
- + " where ( bean.version > :version OR cast(:version as string) IS NULL and uapp.id=:idUsuarioApp AND bean.dataPagamentoTitulo is null) "
- + " OR ( bean.id not in :idsNoApp AND uapp.id=:idUsuarioApp AND bean.dataPagamentoTitulo is null) ")
- public List<Titulo> getUpdated(@Param("version") LocalDateTime version, @Param("idsNoApp") Set<Long> idsNoApp,
- @Param("idUsuarioApp") UUID idUsuarioApp);
- }
- else{
- @Query("select DISTINCT bean from Titulo bean INNER JOIN bean.cliente cli INNER JOIN cli.usuarioAppClientes uapp_cli "
- + " INNER JOIN uapp_cli.usuarioApp uapp "
- + " where (uapp.id=:idUsuarioApp AND bean.dataPagamentoTitulo is null) "
- + " OR ( bean.id not in :idsNoApp AND uapp.id=:idUsuarioApp AND bean.dataPagamentoTitulo is null) ")
- public List<Titulo> getUpdated(@Param("idsNoApp") Set<Long> idsNoApp, @Param("idUsuarioApp") UUID idUsuarioApp);
- }
- //Ou
- @Query("select DISTINCT bean from Titulo bean INNER JOIN bean.cliente cli INNER JOIN cli.usuarioAppClientes uapp_cli "
- + " INNER JOIN uapp_cli.usuarioApp uapp "
- + " where ( (bean.version > :version OR cast(:version as string) IS NULL) and uapp.id=:idUsuarioApp AND bean.dataPagamentoTitulo is null) "
- + " OR ( bean.id not in :idsNoApp AND uapp.id=:idUsuarioApp AND bean.dataPagamentoTitulo is null) ")
- public List<Titulo> getUpdated(@Param("version") LocalDateTime version, @Param("idsNoApp") Set<Long> idsNoApp,
- @Param("idUsuarioApp") UUID idUsuarioApp);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement