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 supplierreference
120 data_type: 'mediumtext'
123 =head2 purchaseordernumber
125 data_type: 'mediumtext'
136 data_type: 'timestamp'
137 datetime_undef_if_invalid: 1
138 default_value: current_timestamp
171 =head2 budgetgroup_id
179 datetime_undef_if_invalid: 1
206 =head2 uncertainprice
220 datetime_undef_if_invalid: 1
223 =head2 subscriptionid
229 =head2 parent_ordernumber
243 __PACKAGE__->add_columns(
245 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
247 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
249 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
251 { data_type => "smallint", is_nullable => 1 },
253 { data_type => "varchar", is_nullable => 1, size => 3 },
255 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
257 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
259 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
261 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
263 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
265 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
267 { data_type => "smallint", default_value => 0, is_nullable => 0 },
268 "datecancellationprinted",
269 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
270 "cancellationreason",
271 { data_type => "text", is_nullable => 1 },
272 "order_internalnote",
273 { data_type => "mediumtext", is_nullable => 1 },
275 { data_type => "mediumtext", is_nullable => 1 },
277 { data_type => "mediumtext", is_nullable => 1 },
278 "purchaseordernumber",
279 { data_type => "mediumtext", is_nullable => 1 },
281 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
284 data_type => "timestamp",
285 datetime_undef_if_invalid => 1,
286 default_value => \"current_timestamp",
290 { data_type => "decimal", is_nullable => 1, size => [13, 2] },
292 { data_type => "decimal", is_nullable => 1, size => [13, 2] },
294 { data_type => "decimal", is_nullable => 1, size => [6, 4] },
296 { data_type => "float", is_nullable => 1, size => [6, 4] },
298 { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
300 { data_type => "integer", is_nullable => 0 },
302 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
304 { data_type => "varchar", is_nullable => 1, size => 80 },
306 { data_type => "varchar", is_nullable => 1, size => 80 },
308 { data_type => "varchar", is_nullable => 1, size => 10 },
310 { data_type => "varchar", is_nullable => 1, size => 10 },
312 { data_type => "tinyint", is_nullable => 1 },
314 { data_type => "integer", default_value => 0, is_nullable => 1 },
316 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
318 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
319 "parent_ordernumber",
320 { data_type => "integer", is_nullable => 1 },
323 data_type => "varchar",
324 default_value => "new",
334 =item * L</ordernumber>
340 __PACKAGE__->set_primary_key("ordernumber");
348 Related object: L<Koha::Schema::Result::AqorderUser>
352 __PACKAGE__->has_many(
354 "Koha::Schema::Result::AqorderUser",
355 { "foreign.ordernumber" => "self.ordernumber" },
356 { cascade_copy => 0, cascade_delete => 0 },
359 =head2 aqorders_items
363 Related object: L<Koha::Schema::Result::AqordersItem>
367 __PACKAGE__->has_many(
369 "Koha::Schema::Result::AqordersItem",
370 { "foreign.ordernumber" => "self.ordernumber" },
371 { cascade_copy => 0, cascade_delete => 0 },
374 =head2 aqorders_transfers_ordernumber_from
378 Related object: L<Koha::Schema::Result::AqordersTransfer>
382 __PACKAGE__->might_have(
383 "aqorders_transfers_ordernumber_from",
384 "Koha::Schema::Result::AqordersTransfer",
385 { "foreign.ordernumber_from" => "self.ordernumber" },
386 { cascade_copy => 0, cascade_delete => 0 },
389 =head2 aqorders_transfers_ordernumber_to
393 Related object: L<Koha::Schema::Result::AqordersTransfer>
397 __PACKAGE__->might_have(
398 "aqorders_transfers_ordernumber_to",
399 "Koha::Schema::Result::AqordersTransfer",
400 { "foreign.ordernumber_to" => "self.ordernumber" },
401 { cascade_copy => 0, cascade_delete => 0 },
408 Related object: L<Koha::Schema::Result::Aqbasket>
412 __PACKAGE__->belongs_to(
414 "Koha::Schema::Result::Aqbasket",
415 { basketno => "basketno" },
419 on_delete => "CASCADE",
420 on_update => "CASCADE",
428 Related object: L<Koha::Schema::Result::Biblio>
432 __PACKAGE__->belongs_to(
434 "Koha::Schema::Result::Biblio",
435 { biblionumber => "biblionumber" },
439 on_delete => "SET NULL",
440 on_update => "CASCADE",
448 Related object: L<Koha::Schema::Result::Aqbudget>
452 __PACKAGE__->belongs_to(
454 "Koha::Schema::Result::Aqbudget",
455 { budget_id => "budget_id" },
456 { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
463 Related object: L<Koha::Schema::Result::Aqinvoice>
467 __PACKAGE__->belongs_to(
469 "Koha::Schema::Result::Aqinvoice",
470 { invoiceid => "invoiceid" },
474 on_delete => "SET NULL",
475 on_update => "CASCADE",
479 =head2 subscriptionid
483 Related object: L<Koha::Schema::Result::Subscription>
487 __PACKAGE__->belongs_to(
489 "Koha::Schema::Result::Subscription",
490 { subscriptionid => "subscriptionid" },
494 on_delete => "CASCADE",
495 on_update => "CASCADE",
499 =head2 borrowernumbers
503 Composing rels: L</aqorder_users> -> borrowernumber
507 __PACKAGE__->many_to_many("borrowernumbers", "aqorder_users", "borrowernumber");
510 # Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-03-11 11:50:38
511 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BbhBIc0Bvj3Olf/dYzDjnw
514 # You can replace this text with custom content, and it will be preserved on regeneration