class Customer < ApplicationRecord
  has_many :purchase_orders, dependent: :destroy
  has_many :purchase_order_items, through: :purchase_orders
  has_many :jobs, through: :purchase_order_items

class PurchaseOrder < ApplicationRecord
  belongs_to :customer
  has_many :purchase_order_items, dependent: :destroy
  has_many :jobs, through: :purchase_order_items

class PurchaseOrderItem < ApplicationRecord
  belongs_to :purchase_order
  has_one :customer, through: :purchase_order
  has_one :job, dependent: :destroy

class Job < ApplicationRecord
  belongs_to :purchase_order_item
  has_one :purchase_order, through: :purchase_order_item
  has_one :customer, through: :purchase_order_item

ActiveAdmin.register Job do
  preserve_default_filters!
  remove_filter :purchase_order_item,
    :purchase_order,
    :updated_at
  filter :customer, label: 'Customer'
  filter :purchase_order_item_address, as: :string, label: 'Address'
  filter :purchase_order_item_due, as: :date_range, label: 'Due'

Mysql2::Error: Unknown column 'purchase_order_items_jobs.task_id' in 'where clause': SELECT COUNT(*) FROM `jobs` INNER JOIN `purchase_order_items` ON `purchase_order_items`.`id` = `jobs`.`purchase_order_item_id` LEFT OUTER JOIN `purchase_order_items` `purchase_order_items_jobs_join` ON `purchase_order_items_jobs_join`.`id` = `jobs`.`purchase_order_item_id` LEFT OUTER JOIN `purchase_orders` ON `purchase_orders`.`id` = `purchase_order_items_jobs_join`.`purchase_order_id` LEFT OUTER JOIN `customers` ON `customers`.`id` = `purchase_orders`.`customer_id` WHERE (`customers`.`id` = 1 AND `purchase_order_items_jobs`.`task_id` = 1) AND (purchase_order_items.due <= '2019-08-19' AND purchase_order_items.due >= '2019-08-15' AND jobs.aasm_state != 'finished')