use utf8; package Koha::Schema::Result::Aqorder; # Created by DBIx::Class::Schema::Loader # DO NOT MODIFY THE FIRST PART OF THIS FILE =head1 NAME Koha::Schema::Result::Aqorder =cut use strict; use warnings; use base 'DBIx::Class::Core'; =head1 TABLE: C =cut __PACKAGE__->table("aqorders"); =head1 ACCESSORS =head2 ordernumber data_type: 'integer' is_auto_increment: 1 is_nullable: 0 primary key and unique identifier assigned by Koha to each line =head2 biblionumber data_type: 'integer' is_foreign_key: 1 is_nullable: 1 links the order to the biblio being ordered (biblio.biblionumber) =head2 deleted_biblionumber data_type: 'integer' is_nullable: 1 links the order to the deleted bibliographic record (deletedbiblio.biblionumber) =head2 entrydate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 the date the bib was added to the basket =head2 quantity data_type: 'smallint' is_nullable: 1 the quantity ordered =head2 currency data_type: 'varchar' is_foreign_key: 1 is_nullable: 1 size: 10 the currency used for the purchase =head2 listprice data_type: 'decimal' is_nullable: 1 size: [28,6] the vendor price for this line item =head2 datereceived data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 the date this order was received =head2 invoiceid data_type: 'integer' is_foreign_key: 1 is_nullable: 1 id of invoice =head2 freight data_type: 'decimal' is_nullable: 1 size: [28,6] shipping costs (not used) =head2 unitprice data_type: 'decimal' is_nullable: 1 size: [28,6] the actual cost entered when receiving this line item =head2 unitprice_tax_excluded data_type: 'decimal' is_nullable: 1 size: [28,6] the unit price excluding tax (on receiving) =head2 unitprice_tax_included data_type: 'decimal' is_nullable: 1 size: [28,6] the unit price including tax (on receiving) =head2 quantityreceived data_type: 'smallint' default_value: 0 is_nullable: 0 the quantity that have been received so far =head2 created_by data_type: 'integer' is_foreign_key: 1 is_nullable: 1 the borrowernumber of order line's creator =head2 datecancellationprinted data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 the date the line item was deleted =head2 cancellationreason data_type: 'mediumtext' is_nullable: 1 reason of cancellation =head2 order_internalnote data_type: 'longtext' is_nullable: 1 notes related to this order line, made for staff =head2 order_vendornote data_type: 'longtext' is_nullable: 1 notes related to this order line, made for vendor =head2 purchaseordernumber data_type: 'longtext' is_nullable: 1 not used? always NULL =head2 basketno data_type: 'integer' is_foreign_key: 1 is_nullable: 1 links this order line to a specific basket (aqbasket.basketno) =head2 timestamp data_type: 'timestamp' datetime_undef_if_invalid: 1 default_value: current_timestamp is_nullable: 0 the date and time this order line was last modified =head2 rrp data_type: 'decimal' is_nullable: 1 size: [13,2] the retail cost for this line item =head2 replacementprice data_type: 'decimal' is_nullable: 1 size: [28,6] the replacement cost for this line item =head2 rrp_tax_excluded data_type: 'decimal' is_nullable: 1 size: [28,6] the replacement cost excluding tax =head2 rrp_tax_included data_type: 'decimal' is_nullable: 1 size: [28,6] the replacement cost including tax =head2 ecost data_type: 'decimal' is_nullable: 1 size: [13,2] the replacement cost for this line item =head2 ecost_tax_excluded data_type: 'decimal' is_nullable: 1 size: [28,6] the estimated cost excluding tax =head2 ecost_tax_included data_type: 'decimal' is_nullable: 1 size: [28,6] the estimated cost including tax =head2 tax_rate_bak data_type: 'decimal' is_nullable: 1 size: [6,4] the tax rate for this line item (%) =head2 tax_rate_on_ordering data_type: 'decimal' is_nullable: 1 size: [6,4] the tax rate on ordering for this line item (%) =head2 tax_rate_on_receiving data_type: 'decimal' is_nullable: 1 size: [6,4] the tax rate on receiving for this line item (%) =head2 tax_value_bak data_type: 'decimal' is_nullable: 1 size: [28,6] the tax value for this line item =head2 tax_value_on_ordering data_type: 'decimal' is_nullable: 1 size: [28,6] the tax value on ordering for this line item =head2 tax_value_on_receiving data_type: 'decimal' is_nullable: 1 size: [28,6] the tax value on receiving for this line item =head2 discount data_type: 'float' is_nullable: 1 size: [6,4] the discount for this line item (%) =head2 budget_id data_type: 'integer' is_foreign_key: 1 is_nullable: 0 the fund this order goes against (aqbudgets.budget_id) =head2 budgetdate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 not used? always NULL =head2 sort1 data_type: 'varchar' is_nullable: 1 size: 80 statistical field =head2 sort2 data_type: 'varchar' is_nullable: 1 size: 80 second statistical field =head2 sort1_authcat data_type: 'varchar' is_nullable: 1 size: 10 =head2 sort2_authcat data_type: 'varchar' is_nullable: 1 size: 10 =head2 uncertainprice data_type: 'tinyint' is_nullable: 1 was this price uncertain (1 for yes, 0 for no) =head2 subscriptionid data_type: 'integer' is_foreign_key: 1 is_nullable: 1 links this order line to a subscription (subscription.subscriptionid) =head2 parent_ordernumber data_type: 'integer' is_nullable: 1 ordernumber of parent order line, or same as ordernumber if no parent =head2 orderstatus data_type: 'varchar' default_value: 'new' is_nullable: 1 size: 16 the current status for this line item. Can be 'new', 'ordered', 'partial', 'complete' or 'cancelled' =head2 line_item_id data_type: 'varchar' is_nullable: 1 size: 35 Supplier's article id for Edifact orderline =head2 suppliers_reference_number data_type: 'varchar' is_nullable: 1 size: 35 Suppliers unique edifact quote ref =head2 suppliers_reference_qualifier data_type: 'varchar' is_nullable: 1 size: 3 Type of number above usually 'QLI' =head2 suppliers_report data_type: 'mediumtext' is_nullable: 1 reports received from suppliers =head2 estimated_delivery_date data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 Estimated delivery date =head2 invoice_unitprice data_type: 'decimal' is_nullable: 1 size: [28,6] the unit price in foreign currency =head2 invoice_currency data_type: 'varchar' is_foreign_key: 1 is_nullable: 1 size: 10 the currency of the invoice_unitprice =cut __PACKAGE__->add_columns( "ordernumber", { data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, "biblionumber", { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, "deleted_biblionumber", { data_type => "integer", is_nullable => 1 }, "entrydate", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "quantity", { data_type => "smallint", is_nullable => 1 }, "currency", { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 }, "listprice", { data_type => "decimal", is_nullable => 1, size => [28, 6] }, "datereceived", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "invoiceid", { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, "freight", { data_type => "decimal", is_nullable => 1, size => [28, 6] }, "unitprice", { data_type => "decimal", is_nullable => 1, size => [28, 6] }, "unitprice_tax_excluded", { data_type => "decimal", is_nullable => 1, size => [28, 6] }, "unitprice_tax_included", { data_type => "decimal", is_nullable => 1, size => [28, 6] }, "quantityreceived", { data_type => "smallint", default_value => 0, is_nullable => 0 }, "created_by", { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, "datecancellationprinted", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "cancellationreason", { data_type => "mediumtext", is_nullable => 1 }, "order_internalnote", { data_type => "longtext", is_nullable => 1 }, "order_vendornote", { data_type => "longtext", is_nullable => 1 }, "purchaseordernumber", { data_type => "longtext", is_nullable => 1 }, "basketno", { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, "timestamp", { data_type => "timestamp", datetime_undef_if_invalid => 1, default_value => \"current_timestamp", is_nullable => 0, }, "rrp", { data_type => "decimal", is_nullable => 1, size => [13, 2] }, "replacementprice", { data_type => "decimal", is_nullable => 1, size => [28, 6] }, "rrp_tax_excluded", { data_type => "decimal", is_nullable => 1, size => [28, 6] }, "rrp_tax_included", { data_type => "decimal", is_nullable => 1, size => [28, 6] }, "ecost", { data_type => "decimal", is_nullable => 1, size => [13, 2] }, "ecost_tax_excluded", { data_type => "decimal", is_nullable => 1, size => [28, 6] }, "ecost_tax_included", { data_type => "decimal", is_nullable => 1, size => [28, 6] }, "tax_rate_bak", { data_type => "decimal", is_nullable => 1, size => [6, 4] }, "tax_rate_on_ordering", { data_type => "decimal", is_nullable => 1, size => [6, 4] }, "tax_rate_on_receiving", { data_type => "decimal", is_nullable => 1, size => [6, 4] }, "tax_value_bak", { data_type => "decimal", is_nullable => 1, size => [28, 6] }, "tax_value_on_ordering", { data_type => "decimal", is_nullable => 1, size => [28, 6] }, "tax_value_on_receiving", { data_type => "decimal", is_nullable => 1, size => [28, 6] }, "discount", { data_type => "float", is_nullable => 1, size => [6, 4] }, "budget_id", { data_type => "integer", is_foreign_key => 1, is_nullable => 0 }, "budgetdate", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "sort1", { data_type => "varchar", is_nullable => 1, size => 80 }, "sort2", { data_type => "varchar", is_nullable => 1, size => 80 }, "sort1_authcat", { data_type => "varchar", is_nullable => 1, size => 10 }, "sort2_authcat", { data_type => "varchar", is_nullable => 1, size => 10 }, "uncertainprice", { data_type => "tinyint", is_nullable => 1 }, "subscriptionid", { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, "parent_ordernumber", { data_type => "integer", is_nullable => 1 }, "orderstatus", { data_type => "varchar", default_value => "new", is_nullable => 1, size => 16, }, "line_item_id", { data_type => "varchar", is_nullable => 1, size => 35 }, "suppliers_reference_number", { data_type => "varchar", is_nullable => 1, size => 35 }, "suppliers_reference_qualifier", { data_type => "varchar", is_nullable => 1, size => 3 }, "suppliers_report", { data_type => "mediumtext", is_nullable => 1 }, "estimated_delivery_date", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "invoice_unitprice", { data_type => "decimal", is_nullable => 1, size => [28, 6] }, "invoice_currency", { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 }, ); =head1 PRIMARY KEY =over 4 =item * L =back =cut __PACKAGE__->set_primary_key("ordernumber"); =head1 RELATIONS =head2 aqorder_users Type: has_many Related object: L =cut __PACKAGE__->has_many( "aqorder_users", "Koha::Schema::Result::AqorderUser", { "foreign.ordernumber" => "self.ordernumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); =head2 aqorders_claims Type: has_many Related object: L =cut __PACKAGE__->has_many( "aqorders_claims", "Koha::Schema::Result::AqordersClaim", { "foreign.ordernumber" => "self.ordernumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); =head2 aqorders_items Type: has_many Related object: L =cut __PACKAGE__->has_many( "aqorders_items", "Koha::Schema::Result::AqordersItem", { "foreign.ordernumber" => "self.ordernumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); =head2 aqorders_transfers_ordernumber_from Type: might_have Related object: L =cut __PACKAGE__->might_have( "aqorders_transfers_ordernumber_from", "Koha::Schema::Result::AqordersTransfer", { "foreign.ordernumber_from" => "self.ordernumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); =head2 aqorders_transfers_ordernumber_to Type: might_have Related object: L =cut __PACKAGE__->might_have( "aqorders_transfers_ordernumber_to", "Koha::Schema::Result::AqordersTransfer", { "foreign.ordernumber_to" => "self.ordernumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); =head2 basketno Type: belongs_to Related object: L =cut __PACKAGE__->belongs_to( "basketno", "Koha::Schema::Result::Aqbasket", { basketno => "basketno" }, { is_deferrable => 1, join_type => "LEFT", on_delete => "CASCADE", on_update => "CASCADE", }, ); =head2 biblionumber Type: belongs_to Related object: L =cut __PACKAGE__->belongs_to( "biblionumber", "Koha::Schema::Result::Biblio", { biblionumber => "biblionumber" }, { is_deferrable => 1, join_type => "LEFT", on_delete => "SET NULL", on_update => "CASCADE", }, ); =head2 budget Type: belongs_to Related object: L =cut __PACKAGE__->belongs_to( "budget", "Koha::Schema::Result::Aqbudget", { budget_id => "budget_id" }, { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, ); =head2 created_by Type: belongs_to Related object: L =cut __PACKAGE__->belongs_to( "created_by", "Koha::Schema::Result::Borrower", { borrowernumber => "created_by" }, { is_deferrable => 1, join_type => "LEFT", on_delete => "SET NULL", on_update => "CASCADE", }, ); =head2 currency Type: belongs_to Related object: L =cut __PACKAGE__->belongs_to( "currency", "Koha::Schema::Result::Currency", { currency => "currency" }, { is_deferrable => 1, join_type => "LEFT", on_delete => "SET NULL", on_update => "SET NULL", }, ); =head2 invoice_currency Type: belongs_to Related object: L =cut __PACKAGE__->belongs_to( "invoice_currency", "Koha::Schema::Result::Currency", { currency => "invoice_currency" }, { is_deferrable => 1, join_type => "LEFT", on_delete => "SET NULL", on_update => "SET NULL", }, ); =head2 invoiceid Type: belongs_to Related object: L =cut __PACKAGE__->belongs_to( "invoiceid", "Koha::Schema::Result::Aqinvoice", { invoiceid => "invoiceid" }, { is_deferrable => 1, join_type => "LEFT", on_delete => "SET NULL", on_update => "CASCADE", }, ); =head2 subscriptionid Type: belongs_to Related object: L =cut __PACKAGE__->belongs_to( "subscriptionid", "Koha::Schema::Result::Subscription", { subscriptionid => "subscriptionid" }, { is_deferrable => 1, join_type => "LEFT", on_delete => "SET NULL", on_update => "CASCADE", }, ); =head2 borrowernumbers Type: many_to_many Composing rels: L -> borrowernumber =cut __PACKAGE__->many_to_many("borrowernumbers", "aqorder_users", "borrowernumber"); # Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-09-06 17:56:52 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:aaj6mc1M13YFx5P0aXMiEQ __PACKAGE__->belongs_to( "basket", "Koha::Schema::Result::Aqbasket", { "foreign.basketno" => "self.basketno" }, { is_deferrable => 1, join_type => "LEFT", on_delete => "CASCADE", on_update => "CASCADE", }, ); __PACKAGE__->belongs_to( "biblio", "Koha::Schema::Result::Biblio", { 'foreign.biblionumber' => "self.biblionumber" }, { is_deferrable => 1, join_type => "LEFT", on_delete => "SET NULL", on_update => "CASCADE", }, ); __PACKAGE__->belongs_to( "fund", "Koha::Schema::Result::Aqbudget", { "foreign.budget_id" => "self.budget_id" }, { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, ); __PACKAGE__->belongs_to( "invoice", "Koha::Schema::Result::Aqinvoice", { "foreign.invoiceid" => "self.invoiceid" }, { is_deferrable => 1, join_type => "LEFT", on_delete => "SET NULL", on_update => "CASCADE", }, ); =head2 creator Type: belongs_to Related object: L =cut __PACKAGE__->belongs_to( "creator", "Koha::Schema::Result::Borrower", { borrowernumber => "created_by" }, { is_deferrable => 1, join_type => "LEFT", on_delete => "SET NULL", on_update => "CASCADE", }, ); __PACKAGE__->belongs_to( "subscription", "Koha::Schema::Result::Subscription", { "foreign.subscriptionid" => "self.subscriptionid" }, { is_deferrable => 1, join_type => "LEFT", on_delete => "CASCADE", on_update => "CASCADE", }, ); __PACKAGE__->has_many( "additional_field_values", "Koha::Schema::Result::AdditionalFieldValue", sub { my ($args) = @_; return { "$args->{foreign_alias}.record_id" => { -ident => "$args->{self_alias}.ordernumber" }, # TODO Add column additional_field_values.tablename to avoid subquery ? "$args->{foreign_alias}.field_id" => { -in => \'(SELECT id FROM additional_fields WHERE tablename = "aqorders")' }, }; }, { cascade_copy => 0, cascade_delete => 0 }, ); sub koha_objects_class { 'Koha::Acquisition::Orders'; } sub koha_object_class { 'Koha::Acquisition::Order'; } __PACKAGE__->add_columns( '+uncertainprice' => { is_boolean => 1 } ); 1;