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 order_internalnote
105 data_type: 'mediumtext'
108 =head2 order_vendornote
110 data_type: 'mediumtext'
113 =head2 supplierreference
115 data_type: 'mediumtext'
118 =head2 purchaseordernumber
120 data_type: 'mediumtext'
131 data_type: 'timestamp'
132 datetime_undef_if_invalid: 1
133 default_value: current_timestamp
165 =head2 budgetgroup_id
173 datetime_undef_if_invalid: 1
200 =head2 uncertainprice
214 datetime_undef_if_invalid: 1
217 =head2 subscriptionid
223 =head2 parent_ordernumber
237 __PACKAGE__->add_columns(
239 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
241 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
243 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
245 { data_type => "smallint", is_nullable => 1 },
247 { data_type => "varchar", is_nullable => 1, size => 3 },
249 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
251 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
253 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
255 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
257 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
259 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
261 { data_type => "smallint", default_value => 0, is_nullable => 0 },
262 "datecancellationprinted",
263 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
264 "order_internalnote",
265 { data_type => "mediumtext", is_nullable => 1 },
267 { data_type => "mediumtext", is_nullable => 1 },
269 { data_type => "mediumtext", is_nullable => 1 },
270 "purchaseordernumber",
271 { data_type => "mediumtext", is_nullable => 1 },
273 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
276 data_type => "timestamp",
277 datetime_undef_if_invalid => 1,
278 default_value => \"current_timestamp",
282 { data_type => "decimal", is_nullable => 1, size => [13, 2] },
284 { data_type => "decimal", is_nullable => 1, size => [13, 2] },
286 { data_type => "decimal", is_nullable => 1, size => [6, 4] },
288 { data_type => "float", is_nullable => 1, size => [6, 4] },
290 { data_type => "integer", is_nullable => 0 },
292 { data_type => "integer", is_nullable => 0 },
294 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
296 { data_type => "varchar", is_nullable => 1, size => 80 },
298 { data_type => "varchar", is_nullable => 1, size => 80 },
300 { data_type => "varchar", is_nullable => 1, size => 10 },
302 { data_type => "varchar", is_nullable => 1, size => 10 },
304 { data_type => "tinyint", is_nullable => 1 },
306 { data_type => "integer", default_value => 0, is_nullable => 1 },
308 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
310 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
311 "parent_ordernumber",
312 { data_type => "integer", is_nullable => 1 },
315 data_type => "varchar",
316 default_value => "new",
326 =item * L</ordernumber>
332 __PACKAGE__->set_primary_key("ordernumber");
336 =head2 aqorders_items
340 Related object: L<Koha::Schema::Result::AqordersItem>
344 __PACKAGE__->has_many(
346 "Koha::Schema::Result::AqordersItem",
347 { "foreign.ordernumber" => "self.ordernumber" },
348 { cascade_copy => 0, cascade_delete => 0 },
351 =head2 aqorders_transfers_ordernumber_from
355 Related object: L<Koha::Schema::Result::AqordersTransfer>
359 __PACKAGE__->might_have(
360 "aqorders_transfers_ordernumber_from",
361 "Koha::Schema::Result::AqordersTransfer",
362 { "foreign.ordernumber_from" => "self.ordernumber" },
363 { cascade_copy => 0, cascade_delete => 0 },
366 =head2 aqorders_transfers_ordernumber_to
370 Related object: L<Koha::Schema::Result::AqordersTransfer>
374 __PACKAGE__->might_have(
375 "aqorders_transfers_ordernumber_to",
376 "Koha::Schema::Result::AqordersTransfer",
377 { "foreign.ordernumber_to" => "self.ordernumber" },
378 { cascade_copy => 0, cascade_delete => 0 },
385 Related object: L<Koha::Schema::Result::Aqbasket>
389 __PACKAGE__->belongs_to(
391 "Koha::Schema::Result::Aqbasket",
392 { basketno => "basketno" },
396 on_delete => "CASCADE",
397 on_update => "CASCADE",
405 Related object: L<Koha::Schema::Result::Biblio>
409 __PACKAGE__->belongs_to(
411 "Koha::Schema::Result::Biblio",
412 { biblionumber => "biblionumber" },
416 on_delete => "SET NULL",
417 on_update => "CASCADE",
425 Related object: L<Koha::Schema::Result::Aqinvoice>
429 __PACKAGE__->belongs_to(
431 "Koha::Schema::Result::Aqinvoice",
432 { invoiceid => "invoiceid" },
436 on_delete => "SET NULL",
437 on_update => "CASCADE",
441 =head2 subscriptionid
445 Related object: L<Koha::Schema::Result::Subscription>
449 __PACKAGE__->belongs_to(
451 "Koha::Schema::Result::Subscription",
452 { subscriptionid => "subscriptionid" },
456 on_delete => "CASCADE",
457 on_update => "CASCADE",
462 # Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-10-28 09:34:37
463 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YrxYJV7I7KfUs3+cWpZy9A
466 # You can replace this text with custom content, and it will be preserved on regeneration