class ReportQuery

Defined in:

queries/report_query.cr

Constructors

Instance Method Summary

Instance methods inherited from class Report::BaseQuery

clone clone, company_id(value)
company_id
company_id
, created_at(value)
created_at
created_at
, find(id) find, full_join_company full_join_company, full_join_manufactory full_join_manufactory, full_join_process_line full_join_process_line, full_join_workshop full_join_workshop, id(value)
id
id
, inner_join_company inner_join_company, inner_join_manufactory inner_join_manufactory, inner_join_process_line inner_join_process_line, inner_join_workshop inner_join_workshop, join_company join_company, join_manufactory join_manufactory, join_process_line join_process_line, join_workshop join_workshop, left_join_company left_join_company, left_join_manufactory left_join_manufactory, left_join_process_line left_join_process_line, left_join_workshop left_join_workshop, manufactory_id(value)
manufactory_id
manufactory_id
, preload_company(preload_query : Company::BaseQuery) : self
preload_company : self
preload_company(&) : self
preload_company
, preload_manufactory(preload_query : Manufactory::BaseQuery) : self
preload_manufactory : self
preload_manufactory(&) : self
preload_manufactory
, preload_process_line(preload_query : ProcessLine::BaseQuery) : self
preload_process_line : self
preload_process_line(&) : self
preload_process_line
, preload_workshop(preload_query : Workshop::BaseQuery) : self
preload_workshop : self
preload_workshop(&) : self
preload_workshop
, process_line_id(value)
process_line_id
process_line_id
, processed_total_count(value)
processed_total_count
processed_total_count
, qualified_total_count(value)
qualified_total_count
qualified_total_count
, report_date(value)
report_date
report_date
, report_month_num(value)
report_month_num
report_month_num
, report_week_num(value)
report_week_num
report_week_num
, report_year_num(value)
report_year_num
report_year_num
, right_join_company right_join_company, right_join_manufactory right_join_manufactory, right_join_process_line right_join_process_line, right_join_workshop right_join_workshop, target_total_count(value)
target_total_count
target_total_count
, update(id : Int64 | Avram::Nothing = Avram::Nothing.new, created_at : Time | Avram::Nothing = Avram::Nothing.new, updated_at : Time | Avram::Nothing = Avram::Nothing.new, target_total_count : Int32 | Avram::Nothing = Avram::Nothing.new, processed_total_count : Int32 | Avram::Nothing = Avram::Nothing.new, qualified_total_count : Int32 | Avram::Nothing = Avram::Nothing.new, report_date : String | Avram::Nothing = Avram::Nothing.new, report_year_num : Int32 | Avram::Nothing = Avram::Nothing.new, report_month_num : Int32 | Avram::Nothing = Avram::Nothing.new, report_week_num : Int32 | Avram::Nothing = Avram::Nothing.new, process_line_id : ProcessLine::PrimaryKeyType | Avram::Nothing = Avram::Nothing.new, workshop_id : Workshop::PrimaryKeyType | Avram::Nothing = Avram::Nothing.new, manufactory_id : Manufactory::PrimaryKeyType | Avram::Nothing = Avram::Nothing.new, company_id : Company::PrimaryKeyType | Avram::Nothing = Avram::Nothing.new) : Int64 update, updated_at(value)
updated_at
updated_at
, where_company(assoc_query : Company::BaseQuery, auto_inner_join : Bool = true) where_company, where_manufactory(assoc_query : Manufactory::BaseQuery, auto_inner_join : Bool = true) where_manufactory, where_process_line(assoc_query : ProcessLine::BaseQuery, auto_inner_join : Bool = true) where_process_line, where_workshop(assoc_query : Workshop::BaseQuery, auto_inner_join : Bool = true) where_workshop, workshop_id(value)
workshop_id
workshop_id

Constructor methods inherited from class Report::BaseQuery

all : self all

Class methods inherited from class Report::BaseQuery

any? : Bool any?, find(id) find, first : T first, first? : T | Nil first?, last : T last, last? : T | Nil last?, new_with_existing_query(query : Avram::QueryBuilder) new_with_existing_query, none? : Bool none?, preload_company(record : Report, force : Bool = false) : Report
preload_company(record : Report, force : Bool = false, &) : Report
preload_company(record : Report, preload_query : Company::BaseQuery, force : Bool = false) : Report
preload_company(records : Enumerable(Report), force : Bool = false) : Array(Report)
preload_company(records : Enumerable(Report), force : Bool = false, &) : Array(Report)
preload_company(records : Enumerable(Report), preload_query : Company::BaseQuery, force : Bool = false) : Array(Report)
preload_company
, preload_manufactory(record : Report, force : Bool = false) : Report
preload_manufactory(record : Report, force : Bool = false, &) : Report
preload_manufactory(record : Report, preload_query : Manufactory::BaseQuery, force : Bool = false) : Report
preload_manufactory(records : Enumerable(Report), force : Bool = false) : Array(Report)
preload_manufactory(records : Enumerable(Report), force : Bool = false, &) : Array(Report)
preload_manufactory(records : Enumerable(Report), preload_query : Manufactory::BaseQuery, force : Bool = false) : Array(Report)
preload_manufactory
, preload_process_line(record : Report, force : Bool = false) : Report
preload_process_line(record : Report, force : Bool = false, &) : Report
preload_process_line(record : Report, preload_query : ProcessLine::BaseQuery, force : Bool = false) : Report
preload_process_line(records : Enumerable(Report), force : Bool = false) : Array(Report)
preload_process_line(records : Enumerable(Report), force : Bool = false, &) : Array(Report)
preload_process_line(records : Enumerable(Report), preload_query : ProcessLine::BaseQuery, force : Bool = false) : Array(Report)
preload_process_line
, preload_workshop(record : Report, force : Bool = false) : Report
preload_workshop(record : Report, force : Bool = false, &) : Report
preload_workshop(record : Report, preload_query : Workshop::BaseQuery, force : Bool = false) : Report
preload_workshop(records : Enumerable(Report), force : Bool = false) : Array(Report)
preload_workshop(records : Enumerable(Report), force : Bool = false, &) : Array(Report)
preload_workshop(records : Enumerable(Report), preload_query : Workshop::BaseQuery, force : Bool = false) : Array(Report)
preload_workshop
, truncate(*, cascade : Bool = false) truncate

Constructor Detail

def self.new #

[View source]

Instance Method Detail

def company_id #

def created_at #

def id #

def manufactory_id #

def process_line_id #

def processed_total_count #

def qualified_total_count #

def report_date #

def report_month_num #

def report_week_num #

def report_year_num #

def target_total_count #

def updated_at #

def workshop_id #