All scopes in task model

scopes_in_tasks_model.rb

  scope :complete, ->(value) { where(summary_status: 'complete', state: 'active').limit(value) }
  scope :accessible_by_user, ->(user) do
    includes(:assignee_tasks)
      .where('tasks.user_id = :user_id or assignee_tasks.user_id = :user_id', user_id: user.id)
  end
  scope :accessible_by_user_with_state, ->(user, state) do
    includes(:assignee_tasks)
      .where('tasks.user_id = :user_id AND tasks.state = :state OR assignee_tasks.user_id = :user_id AND assignee_tasks.state = :state',
        user_id: user.id, state: state)
  end
  scope :accessible_to_update, ->(user) do
    includes(:assignee_tasks)
      .where('tasks.user_id = :user_id OR assignee_tasks.user_id = :user_id AND assignee_tasks.status != :status',
        user_id: user.id, status: 'visible')
  end