Bugzilla – Attachment 43265 Details for
Bug 14610
Add ability to place article requests in Koha
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 14610 - Update Schema files
Bug-14610---Update-Schema-files.patch (text/plain), 9.67 KB, created by
Kyle M Hall (khall)
on 2015-10-08 15:33:47 UTC
(
hide
)
Description:
Bug 14610 - Update Schema files
Filename:
MIME Type:
Creator:
Kyle M Hall (khall)
Created:
2015-10-08 15:33:47 UTC
Size:
9.67 KB
patch
obsolete
>From 75dff3e871a2d84de68ae0c0832c9c1794f7f725 Mon Sep 17 00:00:00 2001 >From: Kyle M Hall <kyle@bywatersolutions.com> >Date: Thu, 8 Oct 2015 11:33:00 -0400 >Subject: [PATCH] Bug 14610 - Update Schema files > >--- > Koha/Schema/Result/ArticleRequest.pm | 258 ++++++++++++++++++++++++++++++++++ > Koha/Schema/Result/Biblio.pm | 19 +++- > Koha/Schema/Result/Borrower.pm | 19 +++- > Koha/Schema/Result/Branch.pm | 19 +++- > Koha/Schema/Result/Item.pm | 19 +++- > 5 files changed, 326 insertions(+), 8 deletions(-) > create mode 100644 Koha/Schema/Result/ArticleRequest.pm > >diff --git a/Koha/Schema/Result/ArticleRequest.pm b/Koha/Schema/Result/ArticleRequest.pm >new file mode 100644 >index 0000000..acdf22d >--- /dev/null >+++ b/Koha/Schema/Result/ArticleRequest.pm >@@ -0,0 +1,258 @@ >+use utf8; >+package Koha::Schema::Result::ArticleRequest; >+ >+# Created by DBIx::Class::Schema::Loader >+# DO NOT MODIFY THE FIRST PART OF THIS FILE >+ >+=head1 NAME >+ >+Koha::Schema::Result::ArticleRequest >+ >+=cut >+ >+use strict; >+use warnings; >+ >+use base 'DBIx::Class::Core'; >+ >+=head1 TABLE: C<article_requests> >+ >+=cut >+ >+__PACKAGE__->table("article_requests"); >+ >+=head1 ACCESSORS >+ >+=head2 id >+ >+ data_type: 'integer' >+ is_auto_increment: 1 >+ is_nullable: 0 >+ >+=head2 borrowernumber >+ >+ data_type: 'integer' >+ is_foreign_key: 1 >+ is_nullable: 0 >+ >+=head2 biblionumber >+ >+ data_type: 'integer' >+ is_foreign_key: 1 >+ is_nullable: 0 >+ >+=head2 itemnumber >+ >+ data_type: 'integer' >+ is_foreign_key: 1 >+ is_nullable: 1 >+ >+=head2 branchcode >+ >+ data_type: 'varchar' >+ is_foreign_key: 1 >+ is_nullable: 1 >+ size: 10 >+ >+=head2 title >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 author >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 volume >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 issue >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 date >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 pages >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 chapters >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 status >+ >+ data_type: 'enum' >+ default_value: 'OPEN' >+ extra: {list => ["OPEN","PROCESSING","COMPLETED","CANCELED"]} >+ is_nullable: 0 >+ >+=head2 notes >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 created_on >+ >+ data_type: 'timestamp' >+ datetime_undef_if_invalid: 1 >+ default_value: current_timestamp >+ is_nullable: 0 >+ >+=head2 updated_on >+ >+ data_type: 'timestamp' >+ datetime_undef_if_invalid: 1 >+ is_nullable: 1 >+ >+=cut >+ >+__PACKAGE__->add_columns( >+ "id", >+ { data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, >+ "borrowernumber", >+ { data_type => "integer", is_foreign_key => 1, is_nullable => 0 }, >+ "biblionumber", >+ { data_type => "integer", is_foreign_key => 1, is_nullable => 0 }, >+ "itemnumber", >+ { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, >+ "branchcode", >+ { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 }, >+ "title", >+ { data_type => "text", is_nullable => 1 }, >+ "author", >+ { data_type => "text", is_nullable => 1 }, >+ "volume", >+ { data_type => "text", is_nullable => 1 }, >+ "issue", >+ { data_type => "text", is_nullable => 1 }, >+ "date", >+ { data_type => "text", is_nullable => 1 }, >+ "pages", >+ { data_type => "text", is_nullable => 1 }, >+ "chapters", >+ { data_type => "text", is_nullable => 1 }, >+ "status", >+ { >+ data_type => "enum", >+ default_value => "OPEN", >+ extra => { list => ["OPEN", "PROCESSING", "COMPLETED", "CANCELED"] }, >+ is_nullable => 0, >+ }, >+ "notes", >+ { data_type => "text", is_nullable => 1 }, >+ "created_on", >+ { >+ data_type => "timestamp", >+ datetime_undef_if_invalid => 1, >+ default_value => \"current_timestamp", >+ is_nullable => 0, >+ }, >+ "updated_on", >+ { >+ data_type => "timestamp", >+ datetime_undef_if_invalid => 1, >+ is_nullable => 1, >+ }, >+); >+ >+=head1 PRIMARY KEY >+ >+=over 4 >+ >+=item * L</id> >+ >+=back >+ >+=cut >+ >+__PACKAGE__->set_primary_key("id"); >+ >+=head1 RELATIONS >+ >+=head2 biblionumber >+ >+Type: belongs_to >+ >+Related object: L<Koha::Schema::Result::Biblio> >+ >+=cut >+ >+__PACKAGE__->belongs_to( >+ "biblionumber", >+ "Koha::Schema::Result::Biblio", >+ { biblionumber => "biblionumber" }, >+ { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, >+); >+ >+=head2 borrowernumber >+ >+Type: belongs_to >+ >+Related object: L<Koha::Schema::Result::Borrower> >+ >+=cut >+ >+__PACKAGE__->belongs_to( >+ "borrowernumber", >+ "Koha::Schema::Result::Borrower", >+ { borrowernumber => "borrowernumber" }, >+ { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, >+); >+ >+=head2 branchcode >+ >+Type: belongs_to >+ >+Related object: L<Koha::Schema::Result::Branch> >+ >+=cut >+ >+__PACKAGE__->belongs_to( >+ "branchcode", >+ "Koha::Schema::Result::Branch", >+ { branchcode => "branchcode" }, >+ { >+ is_deferrable => 1, >+ join_type => "LEFT", >+ on_delete => "SET NULL", >+ on_update => "CASCADE", >+ }, >+); >+ >+=head2 itemnumber >+ >+Type: belongs_to >+ >+Related object: L<Koha::Schema::Result::Item> >+ >+=cut >+ >+__PACKAGE__->belongs_to( >+ "itemnumber", >+ "Koha::Schema::Result::Item", >+ { itemnumber => "itemnumber" }, >+ { >+ is_deferrable => 1, >+ join_type => "LEFT", >+ on_delete => "SET NULL", >+ on_update => "CASCADE", >+ }, >+); >+ >+ >+# Created by DBIx::Class::Schema::Loader v0.07040 @ 2015-10-08 11:32:12 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xslV0rRlOR1Uz0hCYp/WVg >+ >+ >+# You can replace this text with custom code or comments, and it will be preserved on regeneration >+1; >diff --git a/Koha/Schema/Result/Biblio.pm b/Koha/Schema/Result/Biblio.pm >index 54f6727..a755c7d 100644 >--- a/Koha/Schema/Result/Biblio.pm >+++ b/Koha/Schema/Result/Biblio.pm >@@ -152,6 +152,21 @@ __PACKAGE__->has_many( > { cascade_copy => 0, cascade_delete => 0 }, > ); > >+=head2 article_requests >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::ArticleRequest> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "article_requests", >+ "Koha::Schema::Result::ArticleRequest", >+ { "foreign.biblionumber" => "self.biblionumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ > =head2 biblioimages > > Type: has_many >@@ -303,7 +318,7 @@ __PACKAGE__->has_many( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-07-08 15:06:22 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:vh7DAGajJCEzHE7YmAG3jg >+# Created by DBIx::Class::Schema::Loader v0.07040 @ 2015-10-08 11:32:12 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xs9KEYjmdGyZFvFtUCJnQw > > 1; >diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm >index da4e94c..3bf38ec 100644 >--- a/Koha/Schema/Result/Borrower.pm >+++ b/Koha/Schema/Result/Borrower.pm >@@ -677,6 +677,21 @@ __PACKAGE__->has_many( > { cascade_copy => 0, cascade_delete => 0 }, > ); > >+=head2 article_requests >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::ArticleRequest> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "article_requests", >+ "Koha::Schema::Result::ArticleRequest", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ > =head2 borrower_attributes > > Type: has_many >@@ -1138,8 +1153,8 @@ Composing rels: L</aqorder_users> -> ordernumber > __PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber"); > > >-# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-10-06 10:38:42 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:AdaMeazHWWCtMM7rvKX9Lg >+# Created by DBIx::Class::Schema::Loader v0.07040 @ 2015-10-08 11:32:12 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+dES1AKrHgOzva0YCHKpMQ > > > # You can replace this text with custom content, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/Branch.pm b/Koha/Schema/Result/Branch.pm >index 106123a..d71e7b4 100644 >--- a/Koha/Schema/Result/Branch.pm >+++ b/Koha/Schema/Result/Branch.pm >@@ -202,6 +202,21 @@ __PACKAGE__->has_many( > { cascade_copy => 0, cascade_delete => 0 }, > ); > >+=head2 article_requests >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::ArticleRequest> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "article_requests", >+ "Koha::Schema::Result::ArticleRequest", >+ { "foreign.branchcode" => "self.branchcode" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ > =head2 authorised_values_branches > > Type: has_many >@@ -513,8 +528,8 @@ Composing rels: L</branchrelations> -> categorycode > __PACKAGE__->many_to_many("categorycodes", "branchrelations", "categorycode"); > > >-# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-11-06 15:26:36 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CGNPB/MkGLOihDThj43/4A >+# Created by DBIx::Class::Schema::Loader v0.07040 @ 2015-10-08 11:32:12 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:mpklcnAG64p8XsP52AnhfQ > > > # You can replace this text with custom content, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/Item.pm b/Koha/Schema/Result/Item.pm >index c342f46..7a6fe94 100644 >--- a/Koha/Schema/Result/Item.pm >+++ b/Koha/Schema/Result/Item.pm >@@ -425,6 +425,21 @@ __PACKAGE__->has_many( > { cascade_copy => 0, cascade_delete => 0 }, > ); > >+=head2 article_requests >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::ArticleRequest> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "article_requests", >+ "Koha::Schema::Result::ArticleRequest", >+ { "foreign.itemnumber" => "self.itemnumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ > =head2 biblioitemnumber > > Type: belongs_to >@@ -616,8 +631,8 @@ __PACKAGE__->might_have( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-04-23 12:42:12 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:urSpNt7LBda4T5Plhi6cPw >+# Created by DBIx::Class::Schema::Loader v0.07040 @ 2015-10-08 11:32:12 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:y5m5BhwPX1jKCapCflgWvA > > sub effective_itemtype { > my ( $self ) = @_; >-- >1.7.2.5
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 14610
:
42822
|
42823
|
42824
|
42825
|
42826
|
42827
|
42828
|
42829
|
43198
|
43199
|
43200
|
43201
|
43202
|
43264
|
43265
|
43266
|
43267
|
43268
|
43270
|
43271
|
43272
|
43273
|
43274
|
43278
|
43279
|
43280
|
43281
|
43282
|
43654
|
43655
|
43656
|
43657
|
43658
|
44219
|
44220
|
44221
|
44222
|
44223
|
44224
|
44225
|
44226
|
44227
|
44228
|
44229
|
44230
|
44231
|
44232
|
44233
|
44234
|
44235
|
44236
|
44237
|
44238
|
44239
|
44240
|
44241
|
44242
|
44916
|
44917
|
44918
|
44919
|
44920
|
44921
|
44922
|
44923
|
44924
|
44925
|
44926
|
45946
|
45947
|
45948
|
45949
|
45950
|
45951
|
45952
|
45953
|
45954
|
45955
|
45956
|
46518
|
46519
|
46520
|
46521
|
46522
|
46523
|
46524
|
46525
|
46526
|
46527
|
46528
|
46529
|
46530
|
46595
|
46596
|
46597
|
46598
|
46599
|
46600
|
46601
|
46602
|
46603
|
46604
|
46605
|
46606
|
46607
|
46608
|
46609
|
46610
|
46611
|
46612
|
47905
|
47906
|
47907
|
47908
|
47909
|
47910
|
47911
|
47912
|
47913
|
47914
|
47915
|
47916
|
47917
|
47918
|
47919
|
47920
|
47921
|
47922
|
48177
|
48178
|
48179
|
48180
|
48181
|
48182
|
48212
|
48213
|
48214
|
48215
|
48216
|
48217
|
48218
|
50348
|
50349
|
50350
|
50351
|
50352
|
50353
|
50354
|
51527
|
51528
|
51529
|
51530
|
51531
|
51532
|
51533
|
51534
|
51778
|
51779
|
51780
|
51781
|
51782
|
51783
|
52688
|
52689
|
52690
|
52691
|
52692
|
52693
|
55556
|
55557
|
55558
|
55559
|
55560
|
55561
|
55568
|
55569
|
56084
|
56085
|
56086
|
56087
|
56088
|
56089
|
56090
|
56318
|
56319
|
56320
|
56321
|
56322
|
56323
|
56324
|
56325
|
56326
|
56327
|
56328
|
56775
|
56776
|
56777
|
56778
|
56779
|
56780
|
56781
|
56782
|
56783
|
56784
|
56785
|
56816
|
56854
|
56855
|
56856
|
56857
|
56858
|
56859
|
56860
|
56861
|
56862
|
56863
|
56864
|
56865