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
233 __PACKAGE__->add_columns(
235 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
237 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
239 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
241 { data_type => "smallint", is_nullable => 1 },
243 { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
245 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
247 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
249 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
251 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
253 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
255 { data_type => "smallint", default_value => 0, is_nullable => 0 },
256 "datecancellationprinted",
257 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
258 "cancellationreason",
259 { data_type => "text", is_nullable => 1 },
260 "order_internalnote",
261 { data_type => "mediumtext", is_nullable => 1 },
263 { data_type => "mediumtext", is_nullable => 1 },
264 "purchaseordernumber",
265 { data_type => "mediumtext", is_nullable => 1 },
267 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
270 data_type => "timestamp",
271 datetime_undef_if_invalid => 1,
272 default_value => \"current_timestamp",
276 { data_type => "decimal", is_nullable => 1, size => [13, 2] },
278 { data_type => "decimal", is_nullable => 1, size => [13, 2] },
280 { data_type => "decimal", is_nullable => 1, size => [6, 4] },
282 { data_type => "float", is_nullable => 1, size => [6, 4] },
284 { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
286 { data_type => "integer", is_nullable => 0 },
288 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
290 { data_type => "varchar", is_nullable => 1, size => 80 },
292 { data_type => "varchar", is_nullable => 1, size => 80 },
294 { data_type => "varchar", is_nullable => 1, size => 10 },
296 { data_type => "varchar", is_nullable => 1, size => 10 },
298 { data_type => "tinyint", is_nullable => 1 },
300 { data_type => "integer", default_value => 0, is_nullable => 1 },
302 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
304 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
305 "parent_ordernumber",
306 { data_type => "integer", is_nullable => 1 },
309 data_type => "varchar",
310 default_value => "new",
320 =item * L</ordernumber>
326 __PACKAGE__->set_primary_key("ordernumber");
334 Related object: L<Koha::Schema::Result::AqorderUser>
338 __PACKAGE__->has_many(
340 "Koha::Schema::Result::AqorderUser",
341 { "foreign.ordernumber" => "self.ordernumber" },
342 { cascade_copy => 0, cascade_delete => 0 },
345 =head2 aqorders_items
349 Related object: L<Koha::Schema::Result::AqordersItem>
353 __PACKAGE__->has_many(
355 "Koha::Schema::Result::AqordersItem",
356 { "foreign.ordernumber" => "self.ordernumber" },
357 { cascade_copy => 0, cascade_delete => 0 },
360 =head2 aqorders_transfers_ordernumber_from
364 Related object: L<Koha::Schema::Result::AqordersTransfer>
368 __PACKAGE__->might_have(
369 "aqorders_transfers_ordernumber_from",
370 "Koha::Schema::Result::AqordersTransfer",
371 { "foreign.ordernumber_from" => "self.ordernumber" },
372 { cascade_copy => 0, cascade_delete => 0 },
375 =head2 aqorders_transfers_ordernumber_to
379 Related object: L<Koha::Schema::Result::AqordersTransfer>
383 __PACKAGE__->might_have(
384 "aqorders_transfers_ordernumber_to",
385 "Koha::Schema::Result::AqordersTransfer",
386 { "foreign.ordernumber_to" => "self.ordernumber" },
387 { cascade_copy => 0, cascade_delete => 0 },
394 Related object: L<Koha::Schema::Result::Aqbasket>
398 __PACKAGE__->belongs_to(
400 "Koha::Schema::Result::Aqbasket",
401 { basketno => "basketno" },
405 on_delete => "CASCADE",
406 on_update => "CASCADE",
414 Related object: L<Koha::Schema::Result::Biblio>
418 __PACKAGE__->belongs_to(
420 "Koha::Schema::Result::Biblio",
421 { biblionumber => "biblionumber" },
425 on_delete => "SET NULL",
426 on_update => "CASCADE",
434 Related object: L<Koha::Schema::Result::Aqbudget>
438 __PACKAGE__->belongs_to(
440 "Koha::Schema::Result::Aqbudget",
441 { budget_id => "budget_id" },
442 { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
449 Related object: L<Koha::Schema::Result::Currency>
453 __PACKAGE__->belongs_to(
455 "Koha::Schema::Result::Currency",
456 { currency => "currency" },
460 on_delete => "SET NULL",
461 on_update => "SET NULL",
469 Related object: L<Koha::Schema::Result::Aqinvoice>
473 __PACKAGE__->belongs_to(
475 "Koha::Schema::Result::Aqinvoice",
476 { invoiceid => "invoiceid" },
480 on_delete => "SET NULL",
481 on_update => "CASCADE",
485 =head2 subscriptionid
489 Related object: L<Koha::Schema::Result::Subscription>
493 __PACKAGE__->belongs_to(
495 "Koha::Schema::Result::Subscription",
496 { subscriptionid => "subscriptionid" },
500 on_delete => "CASCADE",
501 on_update => "CASCADE",
505 =head2 borrowernumbers
509 Composing rels: L</aqorder_users> -> borrowernumber
513 __PACKAGE__->many_to_many("borrowernumbers", "aqorder_users", "borrowernumber");
516 # Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-03-09 15:14:35
517 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:somjoqKl7W2FYfhmgw4LQQ
520 # You can replace this text with custom content, and it will be preserved on regeneration