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
170 =head2 budgetgroup_id
178 datetime_undef_if_invalid: 1
205 =head2 uncertainprice
219 datetime_undef_if_invalid: 1
222 =head2 subscriptionid
228 =head2 parent_ordernumber
242 __PACKAGE__->add_columns(
244 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
246 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
248 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
250 { data_type => "smallint", is_nullable => 1 },
252 { data_type => "varchar", is_nullable => 1, size => 3 },
254 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
256 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
258 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
260 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
262 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
264 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
266 { data_type => "smallint", default_value => 0, is_nullable => 0 },
267 "datecancellationprinted",
268 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
269 "cancellationreason",
270 { data_type => "text", is_nullable => 1 },
271 "order_internalnote",
272 { data_type => "mediumtext", is_nullable => 1 },
274 { data_type => "mediumtext", is_nullable => 1 },
276 { data_type => "mediumtext", is_nullable => 1 },
277 "purchaseordernumber",
278 { data_type => "mediumtext", is_nullable => 1 },
280 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
283 data_type => "timestamp",
284 datetime_undef_if_invalid => 1,
285 default_value => \"current_timestamp",
289 { data_type => "decimal", is_nullable => 1, size => [13, 2] },
291 { data_type => "decimal", is_nullable => 1, size => [13, 2] },
293 { data_type => "decimal", is_nullable => 1, size => [6, 4] },
295 { data_type => "float", is_nullable => 1, size => [6, 4] },
297 { data_type => "integer", is_nullable => 0 },
299 { data_type => "integer", is_nullable => 0 },
301 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
303 { data_type => "varchar", is_nullable => 1, size => 80 },
305 { data_type => "varchar", is_nullable => 1, size => 80 },
307 { data_type => "varchar", is_nullable => 1, size => 10 },
309 { data_type => "varchar", is_nullable => 1, size => 10 },
311 { data_type => "tinyint", is_nullable => 1 },
313 { data_type => "integer", default_value => 0, is_nullable => 1 },
315 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
317 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
318 "parent_ordernumber",
319 { data_type => "integer", is_nullable => 1 },
322 data_type => "varchar",
323 default_value => "new",
333 =item * L</ordernumber>
339 __PACKAGE__->set_primary_key("ordernumber");
343 =head2 aqorders_items
347 Related object: L<Koha::Schema::Result::AqordersItem>
351 __PACKAGE__->has_many(
353 "Koha::Schema::Result::AqordersItem",
354 { "foreign.ordernumber" => "self.ordernumber" },
355 { cascade_copy => 0, cascade_delete => 0 },
358 =head2 aqorders_transfers_ordernumber_from
362 Related object: L<Koha::Schema::Result::AqordersTransfer>
366 __PACKAGE__->might_have(
367 "aqorders_transfers_ordernumber_from",
368 "Koha::Schema::Result::AqordersTransfer",
369 { "foreign.ordernumber_from" => "self.ordernumber" },
370 { cascade_copy => 0, cascade_delete => 0 },
373 =head2 aqorders_transfers_ordernumber_to
377 Related object: L<Koha::Schema::Result::AqordersTransfer>
381 __PACKAGE__->might_have(
382 "aqorders_transfers_ordernumber_to",
383 "Koha::Schema::Result::AqordersTransfer",
384 { "foreign.ordernumber_to" => "self.ordernumber" },
385 { cascade_copy => 0, cascade_delete => 0 },
392 Related object: L<Koha::Schema::Result::Aqbasket>
396 __PACKAGE__->belongs_to(
398 "Koha::Schema::Result::Aqbasket",
399 { basketno => "basketno" },
403 on_delete => "CASCADE",
404 on_update => "CASCADE",
412 Related object: L<Koha::Schema::Result::Biblio>
416 __PACKAGE__->belongs_to(
418 "Koha::Schema::Result::Biblio",
419 { biblionumber => "biblionumber" },
423 on_delete => "SET NULL",
424 on_update => "CASCADE",
432 Related object: L<Koha::Schema::Result::Aqinvoice>
436 __PACKAGE__->belongs_to(
438 "Koha::Schema::Result::Aqinvoice",
439 { invoiceid => "invoiceid" },
443 on_delete => "SET NULL",
444 on_update => "CASCADE",
448 =head2 subscriptionid
452 Related object: L<Koha::Schema::Result::Subscription>
456 __PACKAGE__->belongs_to(
458 "Koha::Schema::Result::Subscription",
459 { subscriptionid => "subscriptionid" },
463 on_delete => "CASCADE",
464 on_update => "CASCADE",
469 # Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-10-30 01:04:01
470 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:M+R6T+KIk4lqzdYjbYvg9w
473 # You can replace this text with custom content, and it will be preserved on regeneration