alexcassol

alexcassol

How can I dynamically select a field in this case?

I have two dates (sales.sales_date and cashier.cashier.date). Depending on my configuration I want to use sales_date or cachier_date in clauses where, select and group by;

result = list_sales_by_date(2, 2020, :cachier_date)
result = list_sales_by_date(2, 2020, :sales_date)


schema "sales" do
  field(:sales_date, :naive_datetime)
  field(:amount, :float)
  belongs_to(:cashier, Cashier,
      foreign_key: :cashier_id
    )
end

schema "cashier" do
  field(:cashier_date, :date)
  field(:is_opened, :boolean) 
end

def list_sales_by_date(month, year, date_field) do
  from(s in Sales)
  |> join(:inner, [s], c in Cashier, on: s.cashier_id == c.id)
  |> where(^do_where(date_field, year, month))
  |> select([s, c], %{
      year: extract_year(s.sales_date),
      month: extract_month(s.sales_date),
      amount: sum(s.amount),
      count_sales: count_distinct(s.id)
    })  
end

defp do_where(date_field, year, month) do
    if date_field == :sales_date do
      dynamic([s, c], extract_year(s.sales_date) == ^year and extract_month(s.sales_date) == ^month)
    else
      dynamic(
        [s, c],
        extract_year(c.cashier_date) == ^year and extract_month(c.cashier_date) == ^month
      )
    end
end 

Showing Posts 1 to 2

fuelen

fuelen

Hello.

I didn’t run this snippet, but I think idea should work :slight_smile:

query =
  from s in Sales,
    as: :sales,
    inner_join: c in Cashier,
    on: s.cashier_id == c.i,
    as: :cachier,
    select: %{
      count_sales: count_distinct(s.id),
      amount: sum(s.amount)
    }

{binding_name, field_name} =
  if date_field == :sales_date do
    {:sales, :sales_date}
  else
    {:cachier, :cachier_date}
  end

query
|> where([{^binding_name, table}],
    extract_year(field(table, ^field_name)) == ^year and extract_month(field(table, ^field_name)) == ^month
)
|> select_merge([{^binding_name, table}], %{
  year: extract_year(field(table, ^field_name)),
  month: extract_month(field(table, ^field_name)),
})
|> group_by(...)
alexcassol

alexcassol OP

Thanks, I was able to solve it using your idea

— All posts loaded —

Where Next? Top

Trending in Questions Top

RSP87
I’m working on a project that simulates the bumbl example in the programming phoenix book. It acts almost like an email client. We have a...
New
kszambelanczyk
Hello! Could someone please give me a help/sample code, how to delete a file from s3 using waffle/waffle_ecto from Phoenix app. I creat...
New
RemyXRenard
I’m seeing that a list inside a Kino.DataTable will be interpreted as a charlist, even if the Kino.configure() is set to charlists: :as_l...
New
velrest
So my question is quite simple and i have found no conclusive answer on forum, google or AI. Should we use :erlang.float for Integer to ...
New
samoloth
Hi, I’ve just set up an application with ash_authentication. There is only magic link strategy for now, so there is no confirmation add o...
New
FlyingNoodle
If a change or preparation module uses Ash.Changeset.get_argument/2 or Ash.Query.get_argument/2 (or any of the other get_argument functio...
New
ryanwinchester
apply_graft/2 doesn’t rewrite an add_many sub-workflow’s deps on an add step. Grafted jobs cancel with “upstream job was deleted” Version...
New

Other Trending Topics Top

mudasobwa
I am happy to introduce the very α version of the new programming language compiled to BEAM. Welcome Cure. It has literally three kille...
New
garrison
Hobbes is a low-level distributed database for the Elixir programming language. Hobbes provides a simple, safe, and scalable storage lay...
New
marciok
Hi there! We created Gust: A task orchestrator inspired by Airflow. For those who have never heard about Aiflow, it’s a Python-based wor...
New
jimsynz
Beam Bots (or just BB for short) is a framework for building fault-tolerant robotics applications in Elixir using familiar OTP patterns. ...
New
Dmk
Xamal is a deployment tool for Elixir apps that deploys native releases to bare metal servers over SSH. It’s a port of GitHub - basecamp/...
New
Damirados
Hello everyone. After busy few months I am happy to announce v0.1.0 of Emerge & Solve. They are GUI (Emerge) and State management (S...
New

We're in Beta

About us Mission Statement

Options

Thread Display Mode




Thread Preview

Skip Thread Previews