Koha/Schema/Result/Aqorder.pm

   1 use utf8;
   2 package Koha::Schema::Result::Aqorder;
   3
   4 # Created by DBIx::Class::Schema::Loader
   5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
   6
   7 =head1 NAME
   8
   9 Koha::Schema::Result::Aqorder
  10
  11 =cut
  12
  13 use strict;
  14 use warnings;
  15
  16 use base 'DBIx::Class::Core';
  17
  18 =head1 TABLE: C<aqorders>
  19
  20 =cut
  21
  22 __PACKAGE__->table("aqorders");
  23
  24 =head1 ACCESSORS
  25
  26 =head2 ordernumber
  27
  28   data_type: 'integer'
  29   is_auto_increment: 1
  30   is_nullable: 0
  31
  32 =head2 biblionumber
  33
  34   data_type: 'integer'
  35   is_foreign_key: 1
  36   is_nullable: 1
  37
  38 =head2 entrydate
  39
  40   data_type: 'date'
  41   datetime_undef_if_invalid: 1
  42   is_nullable: 1
  43
  44 =head2 quantity
  45
  46   data_type: 'smallint'
  47   is_nullable: 1
  48
  49 =head2 currency
  50
  51   data_type: 'varchar'
  52   is_nullable: 1
  53   size: 3
  54
  55 =head2 listprice
  56
  57   data_type: 'decimal'
  58   is_nullable: 1
  59   size: [28,6]
  60
  61 =head2 datereceived
  62
  63   data_type: 'date'
  64   datetime_undef_if_invalid: 1
  65   is_nullable: 1
  66
  67 =head2 invoiceid
  68
  69   data_type: 'integer'
  70   is_foreign_key: 1
  71   is_nullable: 1
  72
  73 =head2 freight
  74
  75   data_type: 'decimal'
  76   is_nullable: 1
  77   size: [28,6]
  78
  79 =head2 unitprice
  80
  81   data_type: 'decimal'
  82   is_nullable: 1
  83   size: [28,6]
  84
  85 =head2 quantityreceived
  86
  87   data_type: 'smallint'
  88   default_value: 0
  89   is_nullable: 0
  90
  91 =head2 datecancellationprinted
  92
  93   data_type: 'date'
  94   datetime_undef_if_invalid: 1
  95   is_nullable: 1
  96
  97 =head2 cancellationreason
  98
  99   data_type: 'text'
 100   is_nullable: 1
 101
 102 =head2 order_internalnote
 103
 104   data_type: 'mediumtext'
 105   is_nullable: 1
 106
 107 =head2 order_vendornote
 108
 109   data_type: 'mediumtext'
 110   is_nullable: 1
 111
 112 =head2 purchaseordernumber
 113
 114   data_type: 'mediumtext'
 115   is_nullable: 1
 116
 117 =head2 basketno
 118
 119   data_type: 'integer'
 120   is_foreign_key: 1
 121   is_nullable: 1
 122
 123 =head2 timestamp
 124
 125   data_type: 'timestamp'
 126   datetime_undef_if_invalid: 1
 127   default_value: current_timestamp
 128   is_nullable: 0
 129
 130 =head2 rrp
 131
 132   data_type: 'decimal'
 133   is_nullable: 1
 134   size: [13,2]
 135
 136 =head2 ecost
 137
 138   data_type: 'decimal'
 139   is_nullable: 1
 140   size: [13,2]
 141
 142 =head2 gstrate
 143
 144   data_type: 'decimal'
 145   is_nullable: 1
 146   size: [6,4]
 147
 148 =head2 discount
 149
 150   data_type: 'float'
 151   is_nullable: 1
 152   size: [6,4]
 153
 154 =head2 budget_id
 155
 156   data_type: 'integer'
 157   is_foreign_key: 1
 158   is_nullable: 0
 159
 160 =head2 budgetgroup_id
 161
 162   data_type: 'integer'
 163   is_nullable: 0
 164
 165 =head2 budgetdate
 166
 167   data_type: 'date'
 168   datetime_undef_if_invalid: 1
 169   is_nullable: 1
 170
 171 =head2 sort1
 172
 173   data_type: 'varchar'
 174   is_nullable: 1
 175   size: 80
 176
 177 =head2 sort2
 178
 179   data_type: 'varchar'
 180   is_nullable: 1
 181   size: 80
 182
 183 =head2 sort1_authcat
 184
 185   data_type: 'varchar'
 186   is_nullable: 1
 187   size: 10
 188
 189 =head2 sort2_authcat
 190
 191   data_type: 'varchar'
 192   is_nullable: 1
 193   size: 10
 194
 195 =head2 uncertainprice
 196
 197   data_type: 'tinyint'
 198   is_nullable: 1
 199
 200 =head2 claims_count
 201
 202   data_type: 'integer'
 203   default_value: 0
 204   is_nullable: 1
 205
 206 =head2 claimed_date
 207
 208   data_type: 'date'
 209   datetime_undef_if_invalid: 1
 210   is_nullable: 1
 211
 212 =head2 subscriptionid
 213
 214   data_type: 'integer'
 215   is_foreign_key: 1
 216   is_nullable: 1
 217
 218 =head2 parent_ordernumber
 219
 220   data_type: 'integer'
 221   is_nullable: 1
 222
 223 =head2 orderstatus
 224
 225   data_type: 'varchar'
 226   default_value: 'new'
 227   is_nullable: 1
 228   size: 16
 229
 230 =cut
 231
 232 __PACKAGE__->add_columns(
 233   "ordernumber",
 234   { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
 235   "biblionumber",
 236   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
 237   "entrydate",
 238   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 239   "quantity",
 240   { data_type => "smallint", is_nullable => 1 },
 241   "currency",
 242   { data_type => "varchar", is_nullable => 1, size => 3 },
 243   "listprice",
 244   { data_type => "decimal", is_nullable => 1, size => [28, 6] },
 245   "datereceived",
 246   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 247   "invoiceid",
 248   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
 249   "freight",
 250   { data_type => "decimal", is_nullable => 1, size => [28, 6] },
 251   "unitprice",
 252   { data_type => "decimal", is_nullable => 1, size => [28, 6] },
 253   "quantityreceived",
 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 },
 261   "order_vendornote",
 262   { data_type => "mediumtext", is_nullable => 1 },
 263   "purchaseordernumber",
 264   { data_type => "mediumtext", is_nullable => 1 },
 265   "basketno",
 266   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
 267   "timestamp",
 268   {
 269     data_type => "timestamp",
 270     datetime_undef_if_invalid => 1,
 271     default_value => \"current_timestamp",
 272     is_nullable => 0,
 273   },
 274   "rrp",
 275   { data_type => "decimal", is_nullable => 1, size => [13, 2] },
 276   "ecost",
 277   { data_type => "decimal", is_nullable => 1, size => [13, 2] },
 278   "gstrate",
 279   { data_type => "decimal", is_nullable => 1, size => [6, 4] },
 280   "discount",
 281   { data_type => "float", is_nullable => 1, size => [6, 4] },
 282   "budget_id",
 283   { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
 284   "budgetgroup_id",
 285   { data_type => "integer", is_nullable => 0 },
 286   "budgetdate",
 287   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 288   "sort1",
 289   { data_type => "varchar", is_nullable => 1, size => 80 },
 290   "sort2",
 291   { data_type => "varchar", is_nullable => 1, size => 80 },
 292   "sort1_authcat",
 293   { data_type => "varchar", is_nullable => 1, size => 10 },
 294   "sort2_authcat",
 295   { data_type => "varchar", is_nullable => 1, size => 10 },
 296   "uncertainprice",
 297   { data_type => "tinyint", is_nullable => 1 },
 298   "claims_count",
 299   { data_type => "integer", default_value => 0, is_nullable => 1 },
 300   "claimed_date",
 301   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 302   "subscriptionid",
 303   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
 304   "parent_ordernumber",
 305   { data_type => "integer", is_nullable => 1 },
 306   "orderstatus",
 307   {
 308     data_type => "varchar",
 309     default_value => "new",
 310     is_nullable => 1,
 311     size => 16,
 312   },
 313 );
 314
 315 =head1 PRIMARY KEY
 316
 317 =over 4
 318
 319 =item * L</ordernumber>
 320
 321 =back
 322
 323 =cut
 324
 325 __PACKAGE__->set_primary_key("ordernumber");
 326
 327 =head1 RELATIONS
 328
 329 =head2 aqorder_users
 330
 331 Type: has_many
 332
 333 Related object: L<Koha::Schema::Result::AqorderUser>
 334
 335 =cut
 336
 337 __PACKAGE__->has_many(
 338   "aqorder_users",
 339   "Koha::Schema::Result::AqorderUser",
 340   { "foreign.ordernumber" => "self.ordernumber" },
 341   { cascade_copy => 0, cascade_delete => 0 },
 342 );
 343
 344 =head2 aqorders_items
 345
 346 Type: has_many
 347
 348 Related object: L<Koha::Schema::Result::AqordersItem>
 349
 350 =cut
 351
 352 __PACKAGE__->has_many(
 353   "aqorders_items",
 354   "Koha::Schema::Result::AqordersItem",
 355   { "foreign.ordernumber" => "self.ordernumber" },
 356   { cascade_copy => 0, cascade_delete => 0 },
 357 );
 358
 359 =head2 aqorders_transfers_ordernumber_from
 360
 361 Type: might_have
 362
 363 Related object: L<Koha::Schema::Result::AqordersTransfer>
 364
 365 =cut
 366
 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 },
 372 );
 373
 374 =head2 aqorders_transfers_ordernumber_to
 375
 376 Type: might_have
 377
 378 Related object: L<Koha::Schema::Result::AqordersTransfer>
 379
 380 =cut
 381
 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 },
 387 );
 388
 389 =head2 basketno
 390
 391 Type: belongs_to
 392
 393 Related object: L<Koha::Schema::Result::Aqbasket>
 394
 395 =cut
 396
 397 __PACKAGE__->belongs_to(
 398   "basketno",
 399   "Koha::Schema::Result::Aqbasket",
 400   { basketno => "basketno" },
 401   {
 402     is_deferrable => 1,
 403     join_type     => "LEFT",
 404     on_delete     => "CASCADE",
 405     on_update     => "CASCADE",
 406   },
 407 );
 408
 409 =head2 biblionumber
 410
 411 Type: belongs_to
 412
 413 Related object: L<Koha::Schema::Result::Biblio>
 414
 415 =cut
 416
 417 __PACKAGE__->belongs_to(
 418   "biblionumber",
 419   "Koha::Schema::Result::Biblio",
 420   { biblionumber => "biblionumber" },
 421   {
 422     is_deferrable => 1,
 423     join_type     => "LEFT",
 424     on_delete     => "SET NULL",
 425     on_update     => "CASCADE",
 426   },
 427 );
 428
 429 =head2 budget
 430
 431 Type: belongs_to
 432
 433 Related object: L<Koha::Schema::Result::Aqbudget>
 434
 435 =cut
 436
 437 __PACKAGE__->belongs_to(
 438   "budget",
 439   "Koha::Schema::Result::Aqbudget",
 440   { budget_id => "budget_id" },
 441   { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
 442 );
 443
 444 =head2 invoiceid
 445
 446 Type: belongs_to
 447
 448 Related object: L<Koha::Schema::Result::Aqinvoice>
 449
 450 =cut
 451
 452 __PACKAGE__->belongs_to(
 453   "invoiceid",
 454   "Koha::Schema::Result::Aqinvoice",
 455   { invoiceid => "invoiceid" },
 456   {
 457     is_deferrable => 1,
 458     join_type     => "LEFT",
 459     on_delete     => "SET NULL",
 460     on_update     => "CASCADE",
 461   },
 462 );
 463
 464 =head2 subscriptionid
 465
 466 Type: belongs_to
 467
 468 Related object: L<Koha::Schema::Result::Subscription>
 469
 470 =cut
 471
 472 __PACKAGE__->belongs_to(
 473   "subscriptionid",
 474   "Koha::Schema::Result::Subscription",
 475   { subscriptionid => "subscriptionid" },
 476   {
 477     is_deferrable => 1,
 478     join_type     => "LEFT",
 479     on_delete     => "CASCADE",
 480     on_update     => "CASCADE",
 481   },
 482 );
 483
 484 =head2 borrowernumbers
 485
 486 Type: many_to_many
 487
 488 Composing rels: L</aqorder_users> -> borrowernumber
 489
 490 =cut
 491
 492 __PACKAGE__->many_to_many("borrowernumbers", "aqorder_users", "borrowernumber");
 493
 494
 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
 497
 498
 499 # You can replace this text with custom content, and it will be preserved on regeneration
 500 1;