2 package Koha
::Schema
::Result
::Aqorder
;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 Koha::Schema::Result::Aqorder
16 use base
'DBIx::Class::Core';
18 =head1 TABLE: C<aqorders>
22 __PACKAGE__
->table("aqorders");
41 datetime_undef_if_invalid: 1
65 datetime_undef_if_invalid: 1
86 =head2 unitprice_tax_excluded
92 =head2 unitprice_tax_included
98 =head2 quantityreceived
100 data_type: 'smallint'
110 =head2 datecancellationprinted
113 datetime_undef_if_invalid: 1
116 =head2 cancellationreason
118 data_type: 'mediumtext'
121 =head2 order_internalnote
123 data_type: 'longtext'
126 =head2 order_vendornote
128 data_type: 'longtext'
131 =head2 purchaseordernumber
133 data_type: 'longtext'
144 data_type: 'timestamp'
145 datetime_undef_if_invalid: 1
146 default_value: current_timestamp
155 =head2 replacementprice
161 =head2 rrp_tax_excluded
167 =head2 rrp_tax_included
179 =head2 ecost_tax_excluded
185 =head2 ecost_tax_included
197 =head2 tax_rate_on_ordering
203 =head2 tax_rate_on_receiving
215 =head2 tax_value_on_ordering
221 =head2 tax_value_on_receiving
242 datetime_undef_if_invalid: 1
269 =head2 uncertainprice
274 =head2 subscriptionid
280 =head2 parent_ordernumber
298 =head2 suppliers_reference_number
304 =head2 suppliers_reference_qualifier
310 =head2 suppliers_report
312 data_type: 'mediumtext'
317 __PACKAGE__
->add_columns(
319 { data_type
=> "integer", is_auto_increment
=> 1, is_nullable
=> 0 },
321 { data_type
=> "integer", is_foreign_key
=> 1, is_nullable
=> 1 },
323 { data_type
=> "date", datetime_undef_if_invalid
=> 1, is_nullable
=> 1 },
325 { data_type
=> "smallint", is_nullable
=> 1 },
327 { data_type
=> "varchar", is_foreign_key
=> 1, is_nullable
=> 1, size
=> 10 },
329 { data_type
=> "decimal", is_nullable
=> 1, size
=> [28, 6] },
331 { data_type
=> "date", datetime_undef_if_invalid
=> 1, is_nullable
=> 1 },
333 { data_type
=> "integer", is_foreign_key
=> 1, is_nullable
=> 1 },
335 { data_type
=> "decimal", is_nullable
=> 1, size
=> [28, 6] },
337 { data_type
=> "decimal", is_nullable
=> 1, size
=> [28, 6] },
338 "unitprice_tax_excluded",
339 { data_type
=> "decimal", is_nullable
=> 1, size
=> [28, 6] },
340 "unitprice_tax_included",
341 { data_type
=> "decimal", is_nullable
=> 1, size
=> [28, 6] },
343 { data_type
=> "smallint", default_value
=> 0, is_nullable
=> 0 },
345 { data_type
=> "integer", is_foreign_key
=> 1, is_nullable
=> 1 },
346 "datecancellationprinted",
347 { data_type
=> "date", datetime_undef_if_invalid
=> 1, is_nullable
=> 1 },
348 "cancellationreason",
349 { data_type
=> "mediumtext", is_nullable
=> 1 },
350 "order_internalnote",
351 { data_type
=> "longtext", is_nullable
=> 1 },
353 { data_type
=> "longtext", is_nullable
=> 1 },
354 "purchaseordernumber",
355 { data_type
=> "longtext", is_nullable
=> 1 },
357 { data_type
=> "integer", is_foreign_key
=> 1, is_nullable
=> 1 },
360 data_type
=> "timestamp",
361 datetime_undef_if_invalid
=> 1,
362 default_value
=> \"current_timestamp
",
366 { data_type => "decimal
", is_nullable => 1, size => [13, 2] },
368 { data_type => "decimal
", is_nullable => 1, size => [28, 6] },
370 { data_type => "decimal
", is_nullable => 1, size => [28, 6] },
372 { data_type => "decimal
", is_nullable => 1, size => [28, 6] },
374 { data_type => "decimal
", is_nullable => 1, size => [13, 2] },
375 "ecost_tax_excluded
",
376 { data_type => "decimal
", is_nullable => 1, size => [28, 6] },
377 "ecost_tax_included
",
378 { data_type => "decimal
", is_nullable => 1, size => [28, 6] },
380 { data_type => "decimal
", is_nullable => 1, size => [6, 4] },
381 "tax_rate_on_ordering
",
382 { data_type => "decimal
", is_nullable => 1, size => [6, 4] },
383 "tax_rate_on_receiving
",
384 { data_type => "decimal
", is_nullable => 1, size => [6, 4] },
386 { data_type => "decimal
", is_nullable => 1, size => [28, 6] },
387 "tax_value_on_ordering
",
388 { data_type => "decimal
", is_nullable => 1, size => [28, 6] },
389 "tax_value_on_receiving
",
390 { data_type => "decimal
", is_nullable => 1, size => [28, 6] },
392 { data_type => "float
", is_nullable => 1, size => [6, 4] },
394 { data_type => "integer
", is_foreign_key => 1, is_nullable => 0 },
396 { data_type => "date
", datetime_undef_if_invalid => 1, is_nullable => 1 },
398 { data_type => "varchar
", is_nullable => 1, size => 80 },
400 { data_type => "varchar
", is_nullable => 1, size => 80 },
402 { data_type => "varchar
", is_nullable => 1, size => 10 },
404 { data_type => "varchar
", is_nullable => 1, size => 10 },
406 { data_type => "tinyint
", is_nullable => 1 },
408 { data_type => "integer
", is_foreign_key => 1, is_nullable => 1 },
409 "parent_ordernumber
",
410 { data_type => "integer
", is_nullable => 1 },
413 data_type => "varchar
",
414 default_value => "new
",
419 { data_type => "varchar
", is_nullable => 1, size => 35 },
420 "suppliers_reference_number
",
421 { data_type => "varchar
", is_nullable => 1, size => 35 },
422 "suppliers_reference_qualifier
",
423 { data_type => "varchar
", is_nullable => 1, size => 3 },
425 { data_type => "mediumtext
", is_nullable => 1 },
432 =item * L</ordernumber>
438 __PACKAGE__->set_primary_key("ordernumber
");
446 Related object: L<Koha::Schema::Result::AqorderUser>
450 __PACKAGE__->has_many(
452 "Koha
::Schema
::Result
::AqorderUser
",
453 { "foreign
.ordernumber
" => "self
.ordernumber
" },
454 { cascade_copy => 0, cascade_delete => 0 },
457 =head2 aqorders_claims
461 Related object: L<Koha::Schema::Result::AqordersClaim>
465 __PACKAGE__->has_many(
467 "Koha
::Schema
::Result
::AqordersClaim
",
468 { "foreign
.ordernumber
" => "self
.ordernumber
" },
469 { cascade_copy => 0, cascade_delete => 0 },
472 =head2 aqorders_items
476 Related object: L<Koha::Schema::Result::AqordersItem>
480 __PACKAGE__->has_many(
482 "Koha
::Schema
::Result
::AqordersItem
",
483 { "foreign
.ordernumber
" => "self
.ordernumber
" },
484 { cascade_copy => 0, cascade_delete => 0 },
487 =head2 aqorders_transfers_ordernumber_from
491 Related object: L<Koha::Schema::Result::AqordersTransfer>
495 __PACKAGE__->might_have(
496 "aqorders_transfers_ordernumber_from
",
497 "Koha
::Schema
::Result
::AqordersTransfer
",
498 { "foreign
.ordernumber_from
" => "self
.ordernumber
" },
499 { cascade_copy => 0, cascade_delete => 0 },
502 =head2 aqorders_transfers_ordernumber_to
506 Related object: L<Koha::Schema::Result::AqordersTransfer>
510 __PACKAGE__->might_have(
511 "aqorders_transfers_ordernumber_to
",
512 "Koha
::Schema
::Result
::AqordersTransfer
",
513 { "foreign
.ordernumber_to
" => "self
.ordernumber
" },
514 { cascade_copy => 0, cascade_delete => 0 },
521 Related object: L<Koha::Schema::Result::Aqbasket>
525 __PACKAGE__->belongs_to(
527 "Koha
::Schema
::Result
::Aqbasket
",
528 { basketno => "basketno
" },
532 on_delete => "CASCADE
",
533 on_update => "CASCADE
",
541 Related object: L<Koha::Schema::Result::Biblio>
545 __PACKAGE__->belongs_to(
547 "Koha
::Schema
::Result
::Biblio
",
548 { biblionumber => "biblionumber
" },
552 on_delete => "SET NULL
",
553 on_update => "CASCADE
",
561 Related object: L<Koha::Schema::Result::Aqbudget>
565 __PACKAGE__->belongs_to(
567 "Koha
::Schema
::Result
::Aqbudget
",
568 { budget_id => "budget_id
" },
569 { is_deferrable => 1, on_delete => "CASCADE
", on_update => "CASCADE
" },
576 Related object: L<Koha::Schema::Result::Borrower>
580 __PACKAGE__->belongs_to(
582 "Koha
::Schema
::Result
::Borrower
",
583 { borrowernumber => "created_by
" },
587 on_delete => "SET NULL
",
588 on_update => "CASCADE
",
596 Related object: L<Koha::Schema::Result::Currency>
600 __PACKAGE__->belongs_to(
602 "Koha
::Schema
::Result
::Currency
",
603 { currency => "currency
" },
607 on_delete => "SET NULL
",
608 on_update => "SET NULL
",
616 Related object: L<Koha::Schema::Result::Aqinvoice>
620 __PACKAGE__->belongs_to(
622 "Koha
::Schema
::Result
::Aqinvoice
",
623 { invoiceid => "invoiceid
" },
627 on_delete => "SET NULL
",
628 on_update => "CASCADE
",
632 =head2 subscriptionid
636 Related object: L<Koha::Schema::Result::Subscription>
640 __PACKAGE__->belongs_to(
642 "Koha
::Schema
::Result
::Subscription
",
643 { subscriptionid => "subscriptionid
" },
647 on_delete => "CASCADE
",
648 on_update => "CASCADE
",
652 =head2 borrowernumbers
656 Composing rels: L</aqorder_users> -> borrowernumber
660 __PACKAGE__->many_to_many("borrowernumbers
", "aqorder_users
", "borrowernumber
");
663 # Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-05-04 08:25:41
664 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Pf6reFaSldsjIA6XThbDFA
666 __PACKAGE__->belongs_to(
668 "Koha
::Schema
::Result
::Aqbasket
",
669 { "foreign
.basketno
" => "self
.basketno
" },
673 on_delete => "CASCADE
",
674 on_update => "CASCADE
",
678 __PACKAGE__->belongs_to(
680 "Koha
::Schema
::Result
::Biblio
",
681 { 'foreign.biblionumber' => "self
.biblionumber
" },
685 on_delete => "SET NULL
",
686 on_update => "CASCADE
",
690 __PACKAGE__->belongs_to(
692 "Koha
::Schema
::Result
::Aqbudget
",
693 { "foreign
.budget_id
" => "self
.budget_id
" },
694 { is_deferrable => 1, on_delete => "CASCADE
", on_update => "CASCADE
" },
697 __PACKAGE__->belongs_to(
699 "Koha
::Schema
::Result
::Aqinvoice
",
700 { "foreign
.invoiceid
" => "self
.invoiceid
" },
704 on_delete => "SET NULL
",
705 on_update => "CASCADE
",
709 __PACKAGE__->belongs_to(
711 "Koha
::Schema
::Result
::Subscription
",
712 { "foreign
.subscriptionid
" => "self
.subscriptionid
" },
716 on_delete => "CASCADE
",
717 on_update => "CASCADE
",
721 sub koha_objects_class {
722 'Koha::Acquisition::Orders';
725 sub koha_object_class {
726 'Koha::Acquisition::Order';
729 __PACKAGE__->add_columns(
730 '+uncertainprice' => { is_boolean => 1 }