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
64 datetime_undef_if_invalid: 1
85 =head2 quantityreceived
91 =head2 datecancellationprinted
94 datetime_undef_if_invalid: 1
97 =head2 cancellationreason
102 =head2 order_internalnote
104 data_type: 'mediumtext'
107 =head2 order_vendornote
109 data_type: 'mediumtext'
112 =head2 purchaseordernumber
114 data_type: 'mediumtext'
125 data_type: 'timestamp'
126 datetime_undef_if_invalid: 1
127 default_value: current_timestamp
160 =head2 budgetgroup_id
168 datetime_undef_if_invalid: 1
195 =head2 uncertainprice
209 datetime_undef_if_invalid: 1
212 =head2 subscriptionid
218 =head2 parent_ordernumber
232 __PACKAGE__
->add_columns(
234 { data_type
=> "integer", is_auto_increment
=> 1, is_nullable
=> 0 },
236 { data_type
=> "integer", is_foreign_key
=> 1, is_nullable
=> 1 },
238 { data_type
=> "date", datetime_undef_if_invalid
=> 1, is_nullable
=> 1 },
240 { data_type
=> "smallint", is_nullable
=> 1 },
242 { data_type
=> "varchar", is_nullable
=> 1, size
=> 3 },
244 { data_type
=> "decimal", is_nullable
=> 1, size
=> [28, 6] },
246 { data_type
=> "date", datetime_undef_if_invalid
=> 1, is_nullable
=> 1 },
248 { data_type
=> "integer", is_foreign_key
=> 1, is_nullable
=> 1 },
250 { data_type
=> "decimal", is_nullable
=> 1, size
=> [28, 6] },
252 { data_type
=> "decimal", is_nullable
=> 1, size
=> [28, 6] },
254 { data_type
=> "smallint", default_value
=> 0, is_nullable
=> 0 },
255 "datecancellationprinted",
256 { data_type
=> "date", datetime_undef_if_invalid
=> 1, is_nullable
=> 1 },
257 "cancellationreason",
258 { data_type
=> "text", is_nullable
=> 1 },
259 "order_internalnote",
260 { data_type
=> "mediumtext", is_nullable
=> 1 },
262 { data_type
=> "mediumtext", is_nullable
=> 1 },
263 "purchaseordernumber",
264 { data_type
=> "mediumtext", is_nullable
=> 1 },
266 { data_type
=> "integer", is_foreign_key
=> 1, is_nullable
=> 1 },
269 data_type
=> "timestamp",
270 datetime_undef_if_invalid
=> 1,
271 default_value
=> \"current_timestamp
",
275 { data_type => "decimal
", is_nullable => 1, size => [13, 2] },
277 { data_type => "decimal
", is_nullable => 1, size => [13, 2] },
279 { data_type => "decimal
", is_nullable => 1, size => [6, 4] },
281 { data_type => "float
", is_nullable => 1, size => [6, 4] },
283 { data_type => "integer
", is_foreign_key => 1, is_nullable => 0 },
285 { data_type => "integer
", is_nullable => 0 },
287 { data_type => "date
", datetime_undef_if_invalid => 1, is_nullable => 1 },
289 { data_type => "varchar
", is_nullable => 1, size => 80 },
291 { data_type => "varchar
", is_nullable => 1, size => 80 },
293 { data_type => "varchar
", is_nullable => 1, size => 10 },
295 { data_type => "varchar
", is_nullable => 1, size => 10 },
297 { data_type => "tinyint
", is_nullable => 1 },
299 { data_type => "integer
", default_value => 0, is_nullable => 1 },
301 { data_type => "date
", datetime_undef_if_invalid => 1, is_nullable => 1 },
303 { data_type => "integer
", is_foreign_key => 1, is_nullable => 1 },
304 "parent_ordernumber
",
305 { data_type => "integer
", is_nullable => 1 },
308 data_type => "varchar
",
309 default_value => "new
",
319 =item * L</ordernumber>
325 __PACKAGE__->set_primary_key("ordernumber
");
333 Related object: L<Koha::Schema::Result::AqorderUser>
337 __PACKAGE__->has_many(
339 "Koha
::Schema
::Result
::AqorderUser
",
340 { "foreign
.ordernumber
" => "self
.ordernumber
" },
341 { cascade_copy => 0, cascade_delete => 0 },
344 =head2 aqorders_items
348 Related object: L<Koha::Schema::Result::AqordersItem>
352 __PACKAGE__->has_many(
354 "Koha
::Schema
::Result
::AqordersItem
",
355 { "foreign
.ordernumber
" => "self
.ordernumber
" },
356 { cascade_copy => 0, cascade_delete => 0 },
359 =head2 aqorders_transfers_ordernumber_from
363 Related object: L<Koha::Schema::Result::AqordersTransfer>
367 __PACKAGE__->might_have(
368 "aqorders_transfers_ordernumber_from
",
369 "Koha
::Schema
::Result
::AqordersTransfer
",
370 { "foreign
.ordernumber_from
" => "self
.ordernumber
" },
371 { cascade_copy => 0, cascade_delete => 0 },
374 =head2 aqorders_transfers_ordernumber_to
378 Related object: L<Koha::Schema::Result::AqordersTransfer>
382 __PACKAGE__->might_have(
383 "aqorders_transfers_ordernumber_to
",
384 "Koha
::Schema
::Result
::AqordersTransfer
",
385 { "foreign
.ordernumber_to
" => "self
.ordernumber
" },
386 { cascade_copy => 0, cascade_delete => 0 },
393 Related object: L<Koha::Schema::Result::Aqbasket>
397 __PACKAGE__->belongs_to(
399 "Koha
::Schema
::Result
::Aqbasket
",
400 { basketno => "basketno
" },
404 on_delete => "CASCADE
",
405 on_update => "CASCADE
",
413 Related object: L<Koha::Schema::Result::Biblio>
417 __PACKAGE__->belongs_to(
419 "Koha
::Schema
::Result
::Biblio
",
420 { biblionumber => "biblionumber
" },
424 on_delete => "SET NULL
",
425 on_update => "CASCADE
",
433 Related object: L<Koha::Schema::Result::Aqbudget>
437 __PACKAGE__->belongs_to(
439 "Koha
::Schema
::Result
::Aqbudget
",
440 { budget_id => "budget_id
" },
441 { is_deferrable => 1, on_delete => "CASCADE
", on_update => "CASCADE
" },
448 Related object: L<Koha::Schema::Result::Aqinvoice>
452 __PACKAGE__->belongs_to(
454 "Koha
::Schema
::Result
::Aqinvoice
",
455 { invoiceid => "invoiceid
" },
459 on_delete => "SET NULL
",
460 on_update => "CASCADE
",
464 =head2 subscriptionid
468 Related object: L<Koha::Schema::Result::Subscription>
472 __PACKAGE__->belongs_to(
474 "Koha
::Schema
::Result
::Subscription
",
475 { subscriptionid => "subscriptionid
" },
479 on_delete => "CASCADE
",
480 on_update => "CASCADE
",
484 =head2 borrowernumbers
488 Composing rels: L</aqorder_users> -> borrowernumber
492 __PACKAGE__->many_to_many("borrowernumbers
", "aqorder_users
", "borrowernumber
");
495 # Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-05-14 11:27:15
496 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BCa/SxerJ+zEh8Pg9Jdkaw
499 # You can replace this text with custom content, and it will be preserved on regeneration