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
70 datetime_undef_if_invalid: 1
91 =head2 quantityreceived
97 =head2 datecancellationprinted
100 datetime_undef_if_invalid: 1
103 =head2 cancellationreason
108 =head2 order_internalnote
110 data_type: 'mediumtext'
113 =head2 order_vendornote
115 data_type: 'mediumtext'
118 =head2 purchaseordernumber
120 data_type: 'mediumtext'
131 data_type: 'timestamp'
132 datetime_undef_if_invalid: 1
133 default_value: current_timestamp
166 =head2 budgetgroup_id
174 datetime_undef_if_invalid: 1
201 =head2 uncertainprice
215 datetime_undef_if_invalid: 1
218 =head2 subscriptionid
224 =head2 parent_ordernumber
238 __PACKAGE__->add_columns(
240 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
242 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
244 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
246 { data_type => "smallint", is_nullable => 1 },
248 { data_type => "varchar", is_nullable => 1, size => 3 },
250 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
252 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
254 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
256 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
258 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
260 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
262 { data_type => "smallint", default_value => 0, is_nullable => 0 },
263 "datecancellationprinted",
264 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
265 "cancellationreason",
266 { data_type => "text", is_nullable => 1 },
267 "order_internalnote",
268 { data_type => "mediumtext", is_nullable => 1 },
270 { data_type => "mediumtext", is_nullable => 1 },
271 "purchaseordernumber",
272 { data_type => "mediumtext", is_nullable => 1 },
274 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
277 data_type => "timestamp",
278 datetime_undef_if_invalid => 1,
279 default_value => \"current_timestamp",
283 { data_type => "decimal", is_nullable => 1, size => [13, 2] },
285 { data_type => "decimal", is_nullable => 1, size => [13, 2] },
287 { data_type => "decimal", is_nullable => 1, size => [6, 4] },
289 { data_type => "float", is_nullable => 1, size => [6, 4] },
291 { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
293 { data_type => "integer", is_nullable => 0 },
295 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
297 { data_type => "varchar", is_nullable => 1, size => 80 },
299 { data_type => "varchar", is_nullable => 1, size => 80 },
301 { data_type => "varchar", is_nullable => 1, size => 10 },
303 { data_type => "varchar", is_nullable => 1, size => 10 },
305 { data_type => "tinyint", is_nullable => 1 },
307 { data_type => "integer", default_value => 0, is_nullable => 1 },
309 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
311 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
312 "parent_ordernumber",
313 { data_type => "integer", is_nullable => 1 },
316 data_type => "varchar",
317 default_value => "new",
327 =item * L</ordernumber>
333 __PACKAGE__->set_primary_key("ordernumber");
341 Related object: L<Koha::Schema::Result::AqorderUser>
345 __PACKAGE__->has_many(
347 "Koha::Schema::Result::AqorderUser",
348 { "foreign.ordernumber" => "self.ordernumber" },
349 { cascade_copy => 0, cascade_delete => 0 },
352 =head2 aqorders_items
356 Related object: L<Koha::Schema::Result::AqordersItem>
360 __PACKAGE__->has_many(
362 "Koha::Schema::Result::AqordersItem",
363 { "foreign.ordernumber" => "self.ordernumber" },
364 { cascade_copy => 0, cascade_delete => 0 },
367 =head2 aqorders_transfers_ordernumber_from
371 Related object: L<Koha::Schema::Result::AqordersTransfer>
375 __PACKAGE__->might_have(
376 "aqorders_transfers_ordernumber_from",
377 "Koha::Schema::Result::AqordersTransfer",
378 { "foreign.ordernumber_from" => "self.ordernumber" },
379 { cascade_copy => 0, cascade_delete => 0 },
382 =head2 aqorders_transfers_ordernumber_to
386 Related object: L<Koha::Schema::Result::AqordersTransfer>
390 __PACKAGE__->might_have(
391 "aqorders_transfers_ordernumber_to",
392 "Koha::Schema::Result::AqordersTransfer",
393 { "foreign.ordernumber_to" => "self.ordernumber" },
394 { cascade_copy => 0, cascade_delete => 0 },
401 Related object: L<Koha::Schema::Result::Aqbasket>
405 __PACKAGE__->belongs_to(
407 "Koha::Schema::Result::Aqbasket",
408 { basketno => "basketno" },
412 on_delete => "CASCADE",
413 on_update => "CASCADE",
421 Related object: L<Koha::Schema::Result::Biblio>
425 __PACKAGE__->belongs_to(
427 "Koha::Schema::Result::Biblio",
428 { biblionumber => "biblionumber" },
432 on_delete => "SET NULL",
433 on_update => "CASCADE",
441 Related object: L<Koha::Schema::Result::Aqbudget>
445 __PACKAGE__->belongs_to(
447 "Koha::Schema::Result::Aqbudget",
448 { budget_id => "budget_id" },
449 { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
456 Related object: L<Koha::Schema::Result::Aqinvoice>
460 __PACKAGE__->belongs_to(
462 "Koha::Schema::Result::Aqinvoice",
463 { invoiceid => "invoiceid" },
467 on_delete => "SET NULL",
468 on_update => "CASCADE",
472 =head2 subscriptionid
476 Related object: L<Koha::Schema::Result::Subscription>
480 __PACKAGE__->belongs_to(
482 "Koha::Schema::Result::Subscription",
483 { subscriptionid => "subscriptionid" },
487 on_delete => "CASCADE",
488 on_update => "CASCADE",
492 =head2 borrowernumbers
496 Composing rels: L</aqorder_users> -> borrowernumber
500 __PACKAGE__->many_to_many("borrowernumbers", "aqorder_users", "borrowernumber");
503 # Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-04-13 10:17:50
504 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9C0lOmkz7e7xDjXItNB2Sg
507 # You can replace this text with custom content, and it will be preserved on regeneration