@Override public Page<AddressLocationDetails> retrieveAllAddressLocations( final SearchSqlQuery searchAddresses) { try { context.authenticatedUser(); final AddressLocationMapper locationMapper = new AddressLocationMapper(); final StringBuilder sqlBuilder = new StringBuilder(200); sqlBuilder.append("select "); sqlBuilder.append(locationMapper.schema()); String sqlSearch = searchAddresses.getSqlSearch(); String extraCriteria = ""; if (sqlSearch != null) { sqlSearch = sqlSearch.trim(); extraCriteria = " where country_name like '%" + sqlSearch + "%' "; } sqlBuilder.append(extraCriteria); if (searchAddresses.isLimited()) { sqlBuilder.append(" limit ").append(searchAddresses.getLimit()); } if (searchAddresses.isOffset()) { sqlBuilder.append(" offset ").append(searchAddresses.getOffset()); } return this.paginationHelper.fetchPage( this.jdbcTemplate, "SELECT FOUND_ROWS()", sqlBuilder.toString(), new Object[] {}, locationMapper); } catch (final EmptyResultDataAccessException e) { return null; } }
@GET @Consumes({MediaType.APPLICATION_JSON}) @Produces({MediaType.APPLICATION_JSON}) public String retrieveUploadFiles( @Context final UriInfo uriInfo, @QueryParam("sqlSearch") final String sqlSearch, @QueryParam("limit") final Integer limit, @QueryParam("offset") final Integer offset) { context.authenticatedUser().validateHasReadPermission(RESOURCENAME_FOR_PERMISSIONS); final SearchSqlQuery searchUploads = SearchSqlQuery.forSearch(sqlSearch, offset, limit); final Page<UploadStatusData> uploadstatusdata = this.dataUploadReadPlatformService.retrieveAllUploadStatusData(searchUploads); return this.toApiJsonSerializer.serialize(uploadstatusdata); }
@GET @Consumes({MediaType.APPLICATION_JSON}) @Produces({MediaType.APPLICATION_JSON}) public String retrieveAllDetailsForPayments( @Context final UriInfo uriInfo, @QueryParam("sqlSearch") final String sqlSearch, @QueryParam("source") final String source, @QueryParam("limit") final Integer limit, @QueryParam("offset") final Integer offset, @QueryParam("tabType") final String type) { this.context.authenticatedUser().validateHasReadPermission(resourceNameForPermissions); final SearchSqlQuery searchItemDetails = SearchSqlQuery.forSearch(sqlSearch, offset, limit); Page<PaymentGatewayData> paymentData = readPlatformService.retrievePaymentGatewayData(searchItemDetails, type, source); return this.toApiJsonSerializer.serialize(paymentData); }