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