Class: Queries::Loan::Filter
- Inherits:
-
Query::Filter
- Object
- Query
- Query::Filter
- Queries::Loan::Filter
- Includes:
- Concerns::Attributes, Concerns::Notes, Concerns::Tags, Helpers
- Defined in:
- lib/queries/loan/filter.rb
Constant Summary collapse
- ATTRIBUTES =
::Loan.core_attributes.map(&:to_sym).freeze
- PARAMS =
[ *ATTRIBUTES, :descendants, :documentation, # TODO: concern? :end_date_closed, :end_date_received, :end_date_requested, :end_date_return_expected, :end_date_sent, :loan_id, :loan_item_disposition, :overdue, :person_id, :role, :start_date_closed, :start_date_received, :start_date_requested, :start_date_return_expected, :start_date_sent, :taxon_name_id, loan_id: [], loan_item_disposition: [], person_id: [], role: [], taxon_name_id: [], ].freeze
Constants inherited from Query::Filter
Query::Filter::FILTER_QUERIES, Query::Filter::SUBQUERIES
Instance Attribute Summary collapse
-
#descendants ⇒ Object
Returns the value of attribute descendants.
-
#documentation ⇒ Boolean?
Nil - all true - with Documentation false - without Documentation.
-
#end_date_closed ⇒ Object
Returns the value of attribute end_date_closed.
-
#end_date_received ⇒ Object
Returns the value of attribute end_date_received.
-
#end_date_requested ⇒ Object
Returns the value of attribute end_date_requested.
-
#end_date_return_expected ⇒ Object
Returns the value of attribute end_date_return_expected.
-
#end_date_sent ⇒ Object
Returns the value of attribute end_date_sent.
-
#loan_id ⇒ Object
Returns the value of attribute loan_id.
- #loan_item_disposition ⇒ Array
-
#overdue ⇒ Boolean?
Nil - all true - overdue false - not overdue.
-
#person_id ⇒ Array
See also role.
-
#role ⇒ Array
If none provided both returned.
-
#start_date_closed ⇒ Object
Returns the value of attribute start_date_closed.
-
#start_date_received ⇒ Object
Returns the value of attribute start_date_received.
-
#start_date_requested ⇒ Object
Returns the value of attribute start_date_requested.
-
#start_date_return_expected ⇒ Object
Returns the value of attribute start_date_return_expected.
-
#start_date_sent ⇒ Object
Returns the value of attribute start_date_sent.
-
#taxon_name_id ⇒ Object
not done.
Attributes inherited from Query::Filter
#api, #asserted_distribution_query, #biological_association_query, #biological_associations_graph_query, #collecting_event_query, #collection_object_query, #content_query, #controlled_vocabulary_term_query, #data_attribute_query, #descriptor_query, #extract_query, #image_query, #loan_query, #object_global_id, #observation_query, #otu_query, #page, #paginate, #params, #per, #person_query, #project_id, #recent, #taxon_name_query
Attributes inherited from Query
Instance Method Summary collapse
- #collection_object_query_facet ⇒ Object
- #date_closed_facet ⇒ Object
- #date_received_facet ⇒ Object
- #date_requested_facet ⇒ Object
- #date_return_expected_facet ⇒ Object
- #date_sent_facet ⇒ Object
- #documentation_facet ⇒ Object
-
#initialize(query_params) ⇒ Filter
constructor
A new instance of Filter.
- #loan_item_disposition_facet ⇒ Object
- #merge_clauses ⇒ Object
- #otu_id ⇒ Object
- #otu_query_facet ⇒ Object
- #overdue_facet ⇒ Object
- #person_role_facet ⇒ Object
- #taxon_name_id_facet ⇒ Object
Methods included from Helpers
Methods inherited from Query::Filter
#all, #all_and_clauses, #all_merge_clauses, #and_clauses, #annotator_and_clauses, #annotator_merge_clauses, annotator_params, api_except_params, api_excluded_params, #attribute_exact_facet, #deep_permit, included_annotator_facets, inverted_subqueries, #model_id_facet, #object_global_id_facet, params, #permitted_params, #project_id_facet, #set_nested_queries, #shared_and_clauses, #subquery_vector
Methods inherited from Query
#alphabetic_strings, #alphanumeric_strings, base_name, #base_name, #base_query, #build_terms, #cached_facet, #end_wildcard, #levenshtein_distance, #match_ordered_wildcard_pieces_in_cached, #no_terms?, referenced_klass, #referenced_klass, #referenced_klass_except, #referenced_klass_intersection, #referenced_klass_union, #start_and_end_wildcard, #start_wildcard, #table, #wildcard_pieces
Constructor Details
#initialize(query_params) ⇒ Filter
Returns a new instance of Filter.
86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 |
# File 'lib/queries/loan/filter.rb', line 86 def initialize(query_params) super @descendants = boolean_param(params, :descendants) @documentation = boolean_param(params, :documentation) @end_date_closed = params[:end_date_closed] @end_date_received = params[:end_date_received] @end_date_requested = params[:end_date_requested] @end_date_return_expected = params[:end_date_return_expected] @end_date_sent = params[:end_date_sent] @loan_id = params[:loan_id] @loan_item_disposition = params[:loan_item_disposition] @overdue = boolean_param(params, :overdue) @person_id = params[:person_id] @role = params[:role] @start_date_closed = params[:start_date_closed] @start_date_received = params[:start_date_received] @start_date_requested = params[:start_date_requested] @start_date_return_expected = params[:start_date_return_expected] @start_date_sent = params[:start_date_sent] @taxon_name_id = params[:taxon_name_id] set_attributes_params(params) set_notes_params(params) (params) end |
Instance Attribute Details
#descendants ⇒ Object
Returns the value of attribute descendants.
83 84 85 |
# File 'lib/queries/loan/filter.rb', line 83 def descendants @descendants end |
#documentation ⇒ Boolean?
Returns nil - all true - with Documentation false - without Documentation.
45 46 47 |
# File 'lib/queries/loan/filter.rb', line 45 def documentation @documentation end |
#end_date_closed ⇒ Object
Returns the value of attribute end_date_closed.
70 71 72 |
# File 'lib/queries/loan/filter.rb', line 70 def end_date_closed @end_date_closed end |
#end_date_received ⇒ Object
Returns the value of attribute end_date_received.
71 72 73 |
# File 'lib/queries/loan/filter.rb', line 71 def end_date_received @end_date_received end |
#end_date_requested ⇒ Object
Returns the value of attribute end_date_requested.
72 73 74 |
# File 'lib/queries/loan/filter.rb', line 72 def end_date_requested @end_date_requested end |
#end_date_return_expected ⇒ Object
Returns the value of attribute end_date_return_expected.
73 74 75 |
# File 'lib/queries/loan/filter.rb', line 73 def end_date_return_expected @end_date_return_expected end |
#end_date_sent ⇒ Object
Returns the value of attribute end_date_sent.
74 75 76 |
# File 'lib/queries/loan/filter.rb', line 74 def end_date_sent @end_date_sent end |
#loan_id ⇒ Object
Returns the value of attribute loan_id.
39 40 41 |
# File 'lib/queries/loan/filter.rb', line 39 def loan_id @loan_id end |
#loan_item_disposition ⇒ Array
68 69 70 |
# File 'lib/queries/loan/filter.rb', line 68 def loan_item_disposition @loan_item_disposition end |
#overdue ⇒ Boolean?
Returns nil - all true - overdue false - not overdue.
51 52 53 |
# File 'lib/queries/loan/filter.rb', line 51 def overdue @overdue end |
#person_id ⇒ Array
See also role
63 64 65 |
# File 'lib/queries/loan/filter.rb', line 63 def person_id @person_id end |
#role ⇒ Array
If none provided both returned. Only applied when person_id is present
58 59 60 |
# File 'lib/queries/loan/filter.rb', line 58 def role @role end |
#start_date_closed ⇒ Object
Returns the value of attribute start_date_closed.
75 76 77 |
# File 'lib/queries/loan/filter.rb', line 75 def start_date_closed @start_date_closed end |
#start_date_received ⇒ Object
Returns the value of attribute start_date_received.
76 77 78 |
# File 'lib/queries/loan/filter.rb', line 76 def start_date_received @start_date_received end |
#start_date_requested ⇒ Object
Returns the value of attribute start_date_requested.
77 78 79 |
# File 'lib/queries/loan/filter.rb', line 77 def start_date_requested @start_date_requested end |
#start_date_return_expected ⇒ Object
Returns the value of attribute start_date_return_expected.
78 79 80 |
# File 'lib/queries/loan/filter.rb', line 78 def start_date_return_expected @start_date_return_expected end |
#start_date_sent ⇒ Object
Returns the value of attribute start_date_sent.
79 80 81 |
# File 'lib/queries/loan/filter.rb', line 79 def start_date_sent @start_date_sent end |
#taxon_name_id ⇒ Object
not done
82 83 84 |
# File 'lib/queries/loan/filter.rb', line 82 def taxon_name_id @taxon_name_id end |
Instance Method Details
#collection_object_query_facet ⇒ Object
252 253 254 255 256 257 258 259 260 |
# File 'lib/queries/loan/filter.rb', line 252 def collection_object_query_facet return nil if collection_object_query.nil? s = 'WITH query_co_loan AS (' + collection_object_query.all.to_sql + ') ' a = ::Loan.joins(:loan_items) .joins("JOIN query_co_loan as query_co_loan1 on query_co_loan1.id = loan_items.loan_item_object_id AND loan_items.loan_item_object_type = 'CollectionObject'").to_sql ::Loan.from('(' + s + ::Loan.from("(#{a}) as loans").to_sql + ') as loans' ) end |
#date_closed_facet ⇒ Object
199 200 201 202 203 204 |
# File 'lib/queries/loan/filter.rb', line 199 def date_closed_facet return nil if start_date_closed.nil? && end_date_closed.nil? s,e = [start_date_closed, end_date_closed].compact e = s if e.nil? ::Loan.where(date_closed: (s..e)) end |
#date_received_facet ⇒ Object
185 186 187 188 189 190 |
# File 'lib/queries/loan/filter.rb', line 185 def date_received_facet return nil if start_date_received.nil? && end_date_received.nil? s,e = [start_date_received, end_date_received].compact e = s if e.nil? ::Loan.where(date_received: (s..e)) end |
#date_requested_facet ⇒ Object
171 172 173 174 175 176 |
# File 'lib/queries/loan/filter.rb', line 171 def date_requested_facet return nil if start_date_requested.nil? && end_date_requested.nil? s,e = [start_date_requested, end_date_requested].compact e = s if e.nil? ::Loan.where(date_requested: (s..e)) end |
#date_return_expected_facet ⇒ Object
192 193 194 195 196 197 |
# File 'lib/queries/loan/filter.rb', line 192 def date_return_expected_facet return nil if start_date_return_expected.nil? && end_date_return_expected.nil? s,e = [start_date_return_expected, end_date_return_expected].compact e = s if e.nil? ::Loan.where(date_return_expected: (s..e)) end |
#date_sent_facet ⇒ Object
178 179 180 181 182 183 |
# File 'lib/queries/loan/filter.rb', line 178 def date_sent_facet return nil if start_date_sent.nil? && end_date_sent.nil? s,e = [start_date_sent, end_date_sent].compact e = s if e.nil? ::Loan.where(date_sent: (s..e)) end |
#documentation_facet ⇒ Object
215 216 217 218 219 220 221 222 |
# File 'lib/queries/loan/filter.rb', line 215 def documentation_facet return nil if documentation.nil? if documentation ::Loan.joins(:documentation) else ::Loan.where.missing(:documentation) end end |
#loan_item_disposition_facet ⇒ Object
224 225 226 227 |
# File 'lib/queries/loan/filter.rb', line 224 def loan_item_disposition_facet return nil if loan_item_disposition.empty? ::Loan.joins(:loan_items).where(loan_items: {disposition: loan_item_disposition}) end |
#merge_clauses ⇒ Object
262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 |
# File 'lib/queries/loan/filter.rb', line 262 def merge_clauses [ collection_object_query_facet, taxon_name_id_facet, date_closed_facet, date_received_facet, date_requested_facet, date_return_expected_facet, date_sent_facet, documentation_facet, loan_item_disposition_facet, otu_query_facet, overdue_facet, person_role_facet, ] end |
#otu_id ⇒ Object
130 131 132 |
# File 'lib/queries/loan/filter.rb', line 130 def otu_id [@otu_id].flatten.compact.uniq end |
#otu_query_facet ⇒ Object
234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 |
# File 'lib/queries/loan/filter.rb', line 234 def otu_query_facet return nil if otu_query.nil? s = 'WITH query_otu_loan AS (' + otu_query.all.to_sql + ') ' a = ::Loan.joins(:loan_items) .joins("JOIN query_otu_loan as query_otu_loan1 on query_otu_loan1.id = loan_items.loan_item_object_id AND loan_items.loan_item_object_type = 'Otu'").to_sql # Consider position = 1 b = ::Loan.joins(:loan_items) .joins("JOIN collection_objects co on co.id = loan_items.loan_item_object_id and loan_items.loan_item_object_type = 'CollectionObject'") .joins('JOIN taxon_determinations td on co.id = td.biological_collection_object_id') .joins('JOIN query_otu_loan as query_otu_loan2 ON query_otu_loan2.id = td.otu_id').to_sql s << ::Loan.from("((#{a}) UNION (#{b})) as loans").to_sql ::Loan.from('(' + s + ') as loans') end |
#overdue_facet ⇒ Object
206 207 208 209 210 211 212 213 |
# File 'lib/queries/loan/filter.rb', line 206 def overdue_facet return nil if overdue.nil? if overdue ::Loan.overdue else ::Loan.not_overdue end end |
#person_role_facet ⇒ Object
229 230 231 232 |
# File 'lib/queries/loan/filter.rb', line 229 def person_role_facet return nil if person_id.empty? ::Loan.joins(:roles).where(roles: {type: role, person_id: person_id}) end |
#taxon_name_id_facet ⇒ Object
138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 |
# File 'lib/queries/loan/filter.rb', line 138 def taxon_name_id_facet return nil if taxon_name_id.empty? a = ::Queries::CollectionObject::Filter.new(taxon_name_id: taxon_name_id, descendants: descendants) b = ::Queries::Otu::Filter.new(taxon_name_id: taxon_name_id, descendants: descendants) a.project_id = nil b.project_id = nil if a.all(true) a.project_id = project_id c = ::LoanItem.from('(' + 'WITH co_tn AS (' + a.all.to_sql + ') ' + ::LoanItem.joins("JOIN co_tn AS co_tn1 on co_tn1.id = loan_items.loan_item_object_id AND loan_items.loan_item_object_type = 'CollectionObject'").to_sql + ') as loan_items' ).to_sql end if b.all(true) b.project_id = project_id d = ::LoanItem.from('(' + 'WITH otu_tn AS (' + b.all.to_sql + ') ' + ::LoanItem.joins("JOIN otu_tn AS otu_tn1 on otu_tn1.id = loan_items.loan_item_object_id AND loan_items.loan_item_object_type = 'Otu'").to_sql + ') as loan_items' ).to_sql end e = ::LoanItem.from( '(' + [c,d].compact.join(' UNION ') + ') as loan_items').to_sql s = 'WITH items AS (' + e + ') ' + ::Loan.joins('JOIN items as items1 on items1.loan_id = loans.id').to_sql ::Loan.from("(#{s}) as loans") end |