Hello! I am working on the Pragmatic Studio Phoenix Liveview course and am on the pagination lesson. When I go to the next page, it is giving me different numbers of items on each page each time I click through. I am trying to get it to give me a drop down(which I have) of 5, 10, 15, and 20 items and depending on what I click on it will show that amount of items on every page. Any suggestions of why it is just giving me a random number of items
Can you show us what your code looks like so far? Specifically the code from your paginate_live.ex
, and maybe also the list_donations/1
query from donations.ex
?
Thank you. Here is the paginate_live.ex file
defmodule LiveViewStudioWeb.PaginateLive do
use LiveViewStudioWeb, :live_view
alias LiveViewStudio.Donations
def mount(_params, _session, socket) do
paginate_options = %{page: 1, per_page: 5}
donations = Donations.list_donations(paginate: paginate_options)
socket =
assign(socket,
options: paginate_options,
donations: donations
)
{:ok, socket, temporary_assigns: [donations: []]}
end
def handle_params(params, _url, socket) do
page = String.to_integer(params[“page”] || “1”)
per_page = String.to_integer(params[“page”] || “5”)
paginate_options = %{page: page, per_page: per_page}
donations = Donations.list_donations( paginate: paginate_options)
socket =
assign(socket,
options: paginate_options,
donations: donations
)
{:noreply, socket}
end
def handle_event(“select-per-page”, %{“per-page” => per_page}, socket) do
per_page = String.to_integer(per_page)
socket =
push_patch(socket,
to: Routes.live_path(
socket,
MODULE,
page: socket.assigns.options.page,
per_page: per_page
))
{:noreply, socket}
end
defp expires_class(donation) do
if Donations.almost_expired?(donation), do: “eat-now”, else: “fresh”
end
defp pagination_link(socket, text, page, per_page, class) do
live_patch text,
to: Routes.live_path(
socket,
MODULE,
page: page,
per_page: per_page
),
class: class
end
end
Here is the list_donations query. Thank you again!
def list_donations(criteria) when is_list(criteria) do
query = from(d in Donation)
Enum.reduce(criteria, query, fn
{:paginate, %{page: page, per_page: per_page}}, query ->
from q in query,
offset: ^((page - 1) * per_page),
limit: ^per_page
{:sort, %{sort_by: sort_by, sort_order: sort_order}}, query ->
from q in query, order_by: [{^sort_order, ^sort_by}]
end)
|> Repo.all()
end
That is not right, it might be why You have not the right number of records
Thank you! I just fixed it to read per_page and it worked