Filter query based on column value

I have a question, hopefully someone can help. I need to create a query in eloquent to get the orders based on the following information:

  • they are located in the orders table
  • the table structure is like this id, client_payment_from, delivery_date, customs_date, client_papers_date, transporter_papers_date, client_payment_in. In the client_payment_from column you will find the name of the column where you need to get the date value from and in the client_payment_in column the number of days that are allowed to pass.
I need to do a query where you can find the orders where that date is passed by the max amount of days (in the client_payment_in column)
Was this page helpful?