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
164 datetime_undef_if_invalid: 1
191 =head2 uncertainprice
205 datetime_undef_if_invalid: 1
208 =head2 subscriptionid
214 =head2 parent_ordernumber
232 =head2 suppliers_reference_number
238 =head2 suppliers_reference_qualifier
244 =head2 suppliers_report
251 __PACKAGE__->add_columns(
253 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
255 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
257 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
259 { data_type => "smallint", is_nullable => 1 },
261 { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
263 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
265 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
267 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
269 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
271 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
273 { data_type => "smallint", default_value => 0, is_nullable => 0 },
274 "datecancellationprinted",
275 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
276 "cancellationreason",
277 { data_type => "text", is_nullable => 1 },
278 "order_internalnote",
279 { data_type => "mediumtext", is_nullable => 1 },
281 { data_type => "mediumtext", is_nullable => 1 },
282 "purchaseordernumber",
283 { data_type => "mediumtext", is_nullable => 1 },
285 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
288 data_type => "timestamp",
289 datetime_undef_if_invalid => 1,
290 default_value => \"current_timestamp",
294 { data_type => "decimal", is_nullable => 1, size => [13, 2] },
296 { data_type => "decimal", is_nullable => 1, size => [13, 2] },
298 { data_type => "decimal", is_nullable => 1, size => [6, 4] },
300 { data_type => "float", is_nullable => 1, size => [6, 4] },
302 { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
304 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
306 { data_type => "varchar", is_nullable => 1, size => 80 },
308 { data_type => "varchar", is_nullable => 1, size => 80 },
310 { data_type => "varchar", is_nullable => 1, size => 10 },
312 { data_type => "varchar", is_nullable => 1, size => 10 },
314 { data_type => "tinyint", is_nullable => 1 },
316 { data_type => "integer", default_value => 0, is_nullable => 1 },
318 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
320 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
321 "parent_ordernumber",
322 { data_type => "integer", is_nullable => 1 },
325 data_type => "varchar",
326 default_value => "new",
331 { data_type => "varchar", is_nullable => 1, size => 35 },
332 "suppliers_reference_number",
333 { data_type => "varchar", is_nullable => 1, size => 35 },
334 "suppliers_reference_qualifier",
335 { data_type => "varchar", is_nullable => 1, size => 3 },
337 { data_type => "text", is_nullable => 1 },
344 =item * L</ordernumber>
350 __PACKAGE__->set_primary_key("ordernumber");
358 Related object: L<Koha::Schema::Result::AqorderUser>
362 __PACKAGE__->has_many(
364 "Koha::Schema::Result::AqorderUser",
365 { "foreign.ordernumber" => "self.ordernumber" },
366 { cascade_copy => 0, cascade_delete => 0 },
369 =head2 aqorders_items
373 Related object: L<Koha::Schema::Result::AqordersItem>
377 __PACKAGE__->has_many(
379 "Koha::Schema::Result::AqordersItem",
380 { "foreign.ordernumber" => "self.ordernumber" },
381 { cascade_copy => 0, cascade_delete => 0 },
384 =head2 aqorders_transfers_ordernumber_from
388 Related object: L<Koha::Schema::Result::AqordersTransfer>
392 __PACKAGE__->might_have(
393 "aqorders_transfers_ordernumber_from",
394 "Koha::Schema::Result::AqordersTransfer",
395 { "foreign.ordernumber_from" => "self.ordernumber" },
396 { cascade_copy => 0, cascade_delete => 0 },
399 =head2 aqorders_transfers_ordernumber_to
403 Related object: L<Koha::Schema::Result::AqordersTransfer>
407 __PACKAGE__->might_have(
408 "aqorders_transfers_ordernumber_to",
409 "Koha::Schema::Result::AqordersTransfer",
410 { "foreign.ordernumber_to" => "self.ordernumber" },
411 { cascade_copy => 0, cascade_delete => 0 },
418 Related object: L<Koha::Schema::Result::Aqbasket>
422 __PACKAGE__->belongs_to(
424 "Koha::Schema::Result::Aqbasket",
425 { basketno => "basketno" },
429 on_delete => "CASCADE",
430 on_update => "CASCADE",
438 Related object: L<Koha::Schema::Result::Biblio>
442 __PACKAGE__->belongs_to(
444 "Koha::Schema::Result::Biblio",
445 { biblionumber => "biblionumber" },
449 on_delete => "SET NULL",
450 on_update => "CASCADE",
458 Related object: L<Koha::Schema::Result::Aqbudget>
462 __PACKAGE__->belongs_to(
464 "Koha::Schema::Result::Aqbudget",
465 { budget_id => "budget_id" },
466 { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
473 Related object: L<Koha::Schema::Result::Currency>
477 __PACKAGE__->belongs_to(
479 "Koha::Schema::Result::Currency",
480 { currency => "currency" },
484 on_delete => "SET NULL",
485 on_update => "SET NULL",
493 Related object: L<Koha::Schema::Result::Aqinvoice>
497 __PACKAGE__->belongs_to(
499 "Koha::Schema::Result::Aqinvoice",
500 { invoiceid => "invoiceid" },
504 on_delete => "SET NULL",
505 on_update => "CASCADE",
509 =head2 subscriptionid
513 Related object: L<Koha::Schema::Result::Subscription>
517 __PACKAGE__->belongs_to(
519 "Koha::Schema::Result::Subscription",
520 { subscriptionid => "subscriptionid" },
524 on_delete => "CASCADE",
525 on_update => "CASCADE",
529 =head2 borrowernumbers
533 Composing rels: L</aqorder_users> -> borrowernumber
537 __PACKAGE__->many_to_many("borrowernumbers", "aqorder_users", "borrowernumber");
540 # Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-05-06 18:07:43
541 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SQC7q+ZeARRBGvdzzWgSkw
544 # You can replace this text with custom code or comments, and it will be preserved on regeneration