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 quantityreceived
92 =head2 datecancellationprinted
95 datetime_undef_if_invalid: 1
98 =head2 cancellationreason
103 =head2 order_internalnote
105 data_type: 'mediumtext'
108 =head2 order_vendornote
110 data_type: 'mediumtext'
113 =head2 purchaseordernumber
115 data_type: 'mediumtext'
126 data_type: 'timestamp'
127 datetime_undef_if_invalid: 1
128 default_value: current_timestamp
161 =head2 budgetgroup_id
169 datetime_undef_if_invalid: 1
196 =head2 uncertainprice
210 datetime_undef_if_invalid: 1
213 =head2 subscriptionid
219 =head2 parent_ordernumber
237 =head2 suppliers_reference_number
243 =head2 suppliers_reference_qualifier
249 =head2 suppliers_report
256 __PACKAGE__->add_columns(
258 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
260 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
262 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
264 { data_type => "smallint", is_nullable => 1 },
266 { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
268 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
270 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
272 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
274 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
276 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
278 { data_type => "smallint", default_value => 0, is_nullable => 0 },
279 "datecancellationprinted",
280 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
281 "cancellationreason",
282 { data_type => "text", is_nullable => 1 },
283 "order_internalnote",
284 { data_type => "mediumtext", is_nullable => 1 },
286 { data_type => "mediumtext", is_nullable => 1 },
287 "purchaseordernumber",
288 { data_type => "mediumtext", is_nullable => 1 },
290 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
293 data_type => "timestamp",
294 datetime_undef_if_invalid => 1,
295 default_value => \"current_timestamp",
299 { data_type => "decimal", is_nullable => 1, size => [13, 2] },
301 { data_type => "decimal", is_nullable => 1, size => [13, 2] },
303 { data_type => "decimal", is_nullable => 1, size => [6, 4] },
305 { data_type => "float", is_nullable => 1, size => [6, 4] },
307 { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
309 { data_type => "integer", is_nullable => 0 },
311 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
313 { data_type => "varchar", is_nullable => 1, size => 80 },
315 { data_type => "varchar", is_nullable => 1, size => 80 },
317 { data_type => "varchar", is_nullable => 1, size => 10 },
319 { data_type => "varchar", is_nullable => 1, size => 10 },
321 { data_type => "tinyint", is_nullable => 1 },
323 { data_type => "integer", default_value => 0, is_nullable => 1 },
325 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
327 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
328 "parent_ordernumber",
329 { data_type => "integer", is_nullable => 1 },
332 data_type => "varchar",
333 default_value => "new",
338 { data_type => "varchar", is_nullable => 1, size => 35 },
339 "suppliers_reference_number",
340 { data_type => "varchar", is_nullable => 1, size => 35 },
341 "suppliers_reference_qualifier",
342 { data_type => "varchar", is_nullable => 1, size => 3 },
344 { data_type => "text", is_nullable => 1 },
351 =item * L</ordernumber>
357 __PACKAGE__->set_primary_key("ordernumber");
365 Related object: L<Koha::Schema::Result::AqorderUser>
369 __PACKAGE__->has_many(
371 "Koha::Schema::Result::AqorderUser",
372 { "foreign.ordernumber" => "self.ordernumber" },
373 { cascade_copy => 0, cascade_delete => 0 },
376 =head2 aqorders_items
380 Related object: L<Koha::Schema::Result::AqordersItem>
384 __PACKAGE__->has_many(
386 "Koha::Schema::Result::AqordersItem",
387 { "foreign.ordernumber" => "self.ordernumber" },
388 { cascade_copy => 0, cascade_delete => 0 },
391 =head2 aqorders_transfers_ordernumber_from
395 Related object: L<Koha::Schema::Result::AqordersTransfer>
399 __PACKAGE__->might_have(
400 "aqorders_transfers_ordernumber_from",
401 "Koha::Schema::Result::AqordersTransfer",
402 { "foreign.ordernumber_from" => "self.ordernumber" },
403 { cascade_copy => 0, cascade_delete => 0 },
406 =head2 aqorders_transfers_ordernumber_to
410 Related object: L<Koha::Schema::Result::AqordersTransfer>
414 __PACKAGE__->might_have(
415 "aqorders_transfers_ordernumber_to",
416 "Koha::Schema::Result::AqordersTransfer",
417 { "foreign.ordernumber_to" => "self.ordernumber" },
418 { cascade_copy => 0, cascade_delete => 0 },
425 Related object: L<Koha::Schema::Result::Aqbasket>
429 __PACKAGE__->belongs_to(
431 "Koha::Schema::Result::Aqbasket",
432 { basketno => "basketno" },
436 on_delete => "CASCADE",
437 on_update => "CASCADE",
445 Related object: L<Koha::Schema::Result::Biblio>
449 __PACKAGE__->belongs_to(
451 "Koha::Schema::Result::Biblio",
452 { biblionumber => "biblionumber" },
456 on_delete => "SET NULL",
457 on_update => "CASCADE",
465 Related object: L<Koha::Schema::Result::Aqbudget>
469 __PACKAGE__->belongs_to(
471 "Koha::Schema::Result::Aqbudget",
472 { budget_id => "budget_id" },
473 { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
480 Related object: L<Koha::Schema::Result::Currency>
484 __PACKAGE__->belongs_to(
486 "Koha::Schema::Result::Currency",
487 { currency => "currency" },
491 on_delete => "SET NULL",
492 on_update => "SET NULL",
500 Related object: L<Koha::Schema::Result::Aqinvoice>
504 __PACKAGE__->belongs_to(
506 "Koha::Schema::Result::Aqinvoice",
507 { invoiceid => "invoiceid" },
511 on_delete => "SET NULL",
512 on_update => "CASCADE",
516 =head2 subscriptionid
520 Related object: L<Koha::Schema::Result::Subscription>
524 __PACKAGE__->belongs_to(
526 "Koha::Schema::Result::Subscription",
527 { subscriptionid => "subscriptionid" },
531 on_delete => "CASCADE",
532 on_update => "CASCADE",
536 =head2 borrowernumbers
540 Composing rels: L</aqorder_users> -> borrowernumber
544 __PACKAGE__->many_to_many("borrowernumbers", "aqorder_users", "borrowernumber");
547 # Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-03-10 19:38:20
548 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2kQhxUE0pZ3PpwOqGtvB+g
551 # You can replace this text with custom code or comments, and it will be preserved on regeneration