Bugzilla – Attachment 59894 Details for
Bug 7317
Add an Interlibrary Loan Module to Circulation and OPAC
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
DO NOT PUSH: Updated Schema files.
DO-NOT-PUSH-Updated-Schema-files.patch (text/plain), 47.09 KB, created by
Andrew Isherwood
on 2017-02-03 17:36:01 UTC
(
hide
)
Description:
DO NOT PUSH: Updated Schema files.
Filename:
MIME Type:
Creator:
Andrew Isherwood
Created:
2017-02-03 17:36:01 UTC
Size:
47.09 KB
patch
obsolete
>From bf8a631fe36e91598e8ec1e6e92244bad5513071 Mon Sep 17 00:00:00 2001 >From: Alex Sassmannshausen <alex.sassmannshausen@ptfs-europe.com> >Date: Fri, 3 Feb 2017 18:00:01 +0100 >Subject: [PATCH] DO NOT PUSH: Updated Schema files. > >* Koha/Schema/Result/Borrower.pm: New file. >* Koha/Schema/Result/Branch.pm: New file. >* Koha/Schema/Result/Illrequest.pm: New file. >* Koha/Schema/Result/Illrequestattribute.pm: New file. > >https://bugs.koha-community.org/show_bug.cgi?id=7317 >--- > Koha/Schema/Result/Borrower.pm | 1374 +++++++++++++++++++++++++++++ > Koha/Schema/Result/Branch.pm | 599 ++++++++++++- > Koha/Schema/Result/Illrequest.pm | 239 +++++ > Koha/Schema/Result/Illrequestattribute.pm | 97 ++ > 4 files changed, 2307 insertions(+), 2 deletions(-) > create mode 100644 Koha/Schema/Result/Illrequest.pm > create mode 100644 Koha/Schema/Result/Illrequestattribute.pm > >diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm >index 1fe3988..97108a6 100644 >--- a/Koha/Schema/Result/Borrower.pm >+++ b/Koha/Schema/Result/Borrower.pm >@@ -973,6 +973,1367 @@ __PACKAGE__->has_many( > { cascade_copy => 0, cascade_delete => 0 }, > ); > >+=head2 illrequests >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Illrequest> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "illrequests", >+ "Koha::Schema::Result::Illrequest", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 issues >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Issue> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "issues", >+ "Koha::Schema::Result::Issue", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 items_last_borrowers >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::ItemsLastBorrower> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "items_last_borrowers", >+ "Koha::Schema::Result::ItemsLastBorrower", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 message_queues >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::MessageQueue> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "message_queues", >+ "Koha::Schema::Result::MessageQueue", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 messages >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Message> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "messages", >+ "Koha::Schema::Result::Message", >+ { "foreign.manager_id" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 old_issues >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::OldIssue> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "old_issues", >+ "Koha::Schema::Result::OldIssue", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 old_reserves >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::OldReserve> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "old_reserves", >+ "Koha::Schema::Result::OldReserve", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 opac_news >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::OpacNews> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "opac_news", >+ "Koha::Schema::Result::OpacNews", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 patron_list_patrons >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::PatronListPatron> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "patron_list_patrons", >+ "Koha::Schema::Result::PatronListPatron", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 patron_lists >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::PatronList> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "patron_lists", >+ "Koha::Schema::Result::PatronList", >+ { "foreign.owner" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 patronimage >+ >+Type: might_have >+ >+Related object: L<Koha::Schema::Result::Patronimage> >+ >+=cut >+ >+__PACKAGE__->might_have( >+ "patronimage", >+ "Koha::Schema::Result::Patronimage", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 ratings >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Rating> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "ratings", >+ "Koha::Schema::Result::Rating", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 reserves >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Reserve> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "reserves", >+ "Koha::Schema::Result::Reserve", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 reviews >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Review> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "reviews", >+ "Koha::Schema::Result::Review", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 sms_provider >+ >+Type: belongs_to >+ >+Related object: L<Koha::Schema::Result::SmsProvider> >+ >+=cut >+ >+__PACKAGE__->belongs_to( >+ "sms_provider", >+ "Koha::Schema::Result::SmsProvider", >+ { id => "sms_provider_id" }, >+ { >+ is_deferrable => 1, >+ join_type => "LEFT", >+ on_delete => "SET NULL", >+ on_update => "CASCADE", >+ }, >+); >+ >+=head2 subscriptionroutinglists >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Subscriptionroutinglist> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "subscriptionroutinglists", >+ "Koha::Schema::Result::Subscriptionroutinglist", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 tags_all >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::TagAll> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "tags_all", >+ "Koha::Schema::Result::TagAll", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 tags_approvals >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::TagsApproval> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "tags_approvals", >+ "Koha::Schema::Result::TagsApproval", >+ { "foreign.approved_by" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 user_permissions >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::UserPermission> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "user_permissions", >+ "Koha::Schema::Result::UserPermission", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 virtualshelfcontents >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Virtualshelfcontent> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "virtualshelfcontents", >+ "Koha::Schema::Result::Virtualshelfcontent", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 virtualshelfshares >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Virtualshelfshare> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "virtualshelfshares", >+ "Koha::Schema::Result::Virtualshelfshare", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 virtualshelves >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Virtualshelve> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "virtualshelves", >+ "Koha::Schema::Result::Virtualshelve", >+ { "foreign.owner" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 basketnoes >+ >+Type: many_to_many >+ >+Composing rels: L</aqbasketusers> -> basketno >+ >+=cut >+ >+__PACKAGE__->many_to_many("basketnoes", "aqbasketusers", "basketno"); >+ >+=head2 budgets >+ >+Type: many_to_many >+ >+Composing rels: L</aqbudgetborrowers> -> budget >+ >+=cut >+ >+__PACKAGE__->many_to_many("budgets", "aqbudgetborrowers", "budget"); >+ >+=head2 courses >+ >+Type: many_to_many >+ >+Composing rels: L</course_instructors> -> course >+ >+=cut >+ >+__PACKAGE__->many_to_many("courses", "course_instructors", "course"); >+ >+=head2 ordernumbers >+ >+Type: many_to_many >+ >+Composing rels: L</aqorder_users> -> ordernumber >+ >+=cut >+ >+__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber"); >+ >+ >+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-02-03 16:55:44 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6poutI9U1NshzV7amXSl+g >+# These lines were loaded from '/home/alex/src/koha/Koha/Schema/Result/Borrower.pm' found in @INC. >+# They are now part of the custom portion of this file >+# for you to hand-edit. If you do not either delete >+# this section or remove that file from @INC, this section >+# will be repeated redundantly when you re-create this >+# file again via Loader! See skip_load_external to disable >+# this feature. >+ >+use utf8; >+package Koha::Schema::Result::Borrower; >+ >+# Created by DBIx::Class::Schema::Loader >+# DO NOT MODIFY THE FIRST PART OF THIS FILE >+ >+=head1 NAME >+ >+Koha::Schema::Result::Borrower >+ >+=cut >+ >+use strict; >+use warnings; >+ >+use base 'DBIx::Class::Core'; >+ >+=head1 TABLE: C<borrowers> >+ >+=cut >+ >+__PACKAGE__->table("borrowers"); >+ >+=head1 ACCESSORS >+ >+=head2 borrowernumber >+ >+ data_type: 'integer' >+ is_auto_increment: 1 >+ is_nullable: 0 >+ >+=head2 cardnumber >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 16 >+ >+=head2 surname >+ >+ data_type: 'mediumtext' >+ is_nullable: 0 >+ >+=head2 firstname >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 title >+ >+ data_type: 'mediumtext' >+ is_nullable: 1 >+ >+=head2 othernames >+ >+ data_type: 'mediumtext' >+ is_nullable: 1 >+ >+=head2 initials >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 streetnumber >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 10 >+ >+=head2 streettype >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 50 >+ >+=head2 address >+ >+ data_type: 'mediumtext' >+ is_nullable: 0 >+ >+=head2 address2 >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 city >+ >+ data_type: 'mediumtext' >+ is_nullable: 0 >+ >+=head2 state >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 zipcode >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 25 >+ >+=head2 country >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 email >+ >+ data_type: 'mediumtext' >+ is_nullable: 1 >+ >+=head2 phone >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 mobile >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 50 >+ >+=head2 fax >+ >+ data_type: 'mediumtext' >+ is_nullable: 1 >+ >+=head2 emailpro >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 phonepro >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 B_streetnumber >+ >+ accessor: 'b_streetnumber' >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 10 >+ >+=head2 B_streettype >+ >+ accessor: 'b_streettype' >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 50 >+ >+=head2 B_address >+ >+ accessor: 'b_address' >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 100 >+ >+=head2 B_address2 >+ >+ accessor: 'b_address2' >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 B_city >+ >+ accessor: 'b_city' >+ data_type: 'mediumtext' >+ is_nullable: 1 >+ >+=head2 B_state >+ >+ accessor: 'b_state' >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 B_zipcode >+ >+ accessor: 'b_zipcode' >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 25 >+ >+=head2 B_country >+ >+ accessor: 'b_country' >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 B_email >+ >+ accessor: 'b_email' >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 B_phone >+ >+ accessor: 'b_phone' >+ data_type: 'mediumtext' >+ is_nullable: 1 >+ >+=head2 dateofbirth >+ >+ data_type: 'date' >+ datetime_undef_if_invalid: 1 >+ is_nullable: 1 >+ >+=head2 branchcode >+ >+ data_type: 'varchar' >+ default_value: (empty string) >+ is_foreign_key: 1 >+ is_nullable: 0 >+ size: 10 >+ >+=head2 categorycode >+ >+ data_type: 'varchar' >+ default_value: (empty string) >+ is_foreign_key: 1 >+ is_nullable: 0 >+ size: 10 >+ >+=head2 dateenrolled >+ >+ data_type: 'date' >+ datetime_undef_if_invalid: 1 >+ is_nullable: 1 >+ >+=head2 dateexpiry >+ >+ data_type: 'date' >+ datetime_undef_if_invalid: 1 >+ is_nullable: 1 >+ >+=head2 gonenoaddress >+ >+ data_type: 'tinyint' >+ is_nullable: 1 >+ >+=head2 lost >+ >+ data_type: 'tinyint' >+ is_nullable: 1 >+ >+=head2 debarred >+ >+ data_type: 'date' >+ datetime_undef_if_invalid: 1 >+ is_nullable: 1 >+ >+=head2 debarredcomment >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 255 >+ >+=head2 contactname >+ >+ data_type: 'mediumtext' >+ is_nullable: 1 >+ >+=head2 contactfirstname >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 contacttitle >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 guarantorid >+ >+ data_type: 'integer' >+ is_nullable: 1 >+ >+=head2 borrowernotes >+ >+ data_type: 'mediumtext' >+ is_nullable: 1 >+ >+=head2 relationship >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 100 >+ >+=head2 sex >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 1 >+ >+=head2 password >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 60 >+ >+=head2 flags >+ >+ data_type: 'integer' >+ is_nullable: 1 >+ >+=head2 userid >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 75 >+ >+=head2 opacnote >+ >+ data_type: 'mediumtext' >+ is_nullable: 1 >+ >+=head2 contactnote >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 255 >+ >+=head2 sort1 >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 80 >+ >+=head2 sort2 >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 80 >+ >+=head2 altcontactfirstname >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 255 >+ >+=head2 altcontactsurname >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 255 >+ >+=head2 altcontactaddress1 >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 255 >+ >+=head2 altcontactaddress2 >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 255 >+ >+=head2 altcontactaddress3 >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 255 >+ >+=head2 altcontactstate >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 altcontactzipcode >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 50 >+ >+=head2 altcontactcountry >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 altcontactphone >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 50 >+ >+=head2 smsalertnumber >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 50 >+ >+=head2 sms_provider_id >+ >+ data_type: 'integer' >+ is_foreign_key: 1 >+ is_nullable: 1 >+ >+=head2 privacy >+ >+ data_type: 'integer' >+ default_value: 1 >+ is_nullable: 0 >+ >+=head2 privacy_guarantor_checkouts >+ >+ data_type: 'tinyint' >+ default_value: 0 >+ is_nullable: 0 >+ >+=head2 checkprevcheckout >+ >+ data_type: 'varchar' >+ default_value: 'inherit' >+ is_nullable: 0 >+ size: 7 >+ >+=head2 updated_on >+ >+ data_type: 'timestamp' >+ datetime_undef_if_invalid: 1 >+ default_value: current_timestamp >+ is_nullable: 0 >+ >+=head2 lastseen >+ >+ data_type: 'datetime' >+ datetime_undef_if_invalid: 1 >+ is_nullable: 1 >+ >+=cut >+ >+__PACKAGE__->add_columns( >+ "borrowernumber", >+ { data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, >+ "cardnumber", >+ { data_type => "varchar", is_nullable => 1, size => 16 }, >+ "surname", >+ { data_type => "mediumtext", is_nullable => 0 }, >+ "firstname", >+ { data_type => "text", is_nullable => 1 }, >+ "title", >+ { data_type => "mediumtext", is_nullable => 1 }, >+ "othernames", >+ { data_type => "mediumtext", is_nullable => 1 }, >+ "initials", >+ { data_type => "text", is_nullable => 1 }, >+ "streetnumber", >+ { data_type => "varchar", is_nullable => 1, size => 10 }, >+ "streettype", >+ { data_type => "varchar", is_nullable => 1, size => 50 }, >+ "address", >+ { data_type => "mediumtext", is_nullable => 0 }, >+ "address2", >+ { data_type => "text", is_nullable => 1 }, >+ "city", >+ { data_type => "mediumtext", is_nullable => 0 }, >+ "state", >+ { data_type => "text", is_nullable => 1 }, >+ "zipcode", >+ { data_type => "varchar", is_nullable => 1, size => 25 }, >+ "country", >+ { data_type => "text", is_nullable => 1 }, >+ "email", >+ { data_type => "mediumtext", is_nullable => 1 }, >+ "phone", >+ { data_type => "text", is_nullable => 1 }, >+ "mobile", >+ { data_type => "varchar", is_nullable => 1, size => 50 }, >+ "fax", >+ { data_type => "mediumtext", is_nullable => 1 }, >+ "emailpro", >+ { data_type => "text", is_nullable => 1 }, >+ "phonepro", >+ { data_type => "text", is_nullable => 1 }, >+ "B_streetnumber", >+ { >+ accessor => "b_streetnumber", >+ data_type => "varchar", >+ is_nullable => 1, >+ size => 10, >+ }, >+ "B_streettype", >+ { >+ accessor => "b_streettype", >+ data_type => "varchar", >+ is_nullable => 1, >+ size => 50, >+ }, >+ "B_address", >+ { >+ accessor => "b_address", >+ data_type => "varchar", >+ is_nullable => 1, >+ size => 100, >+ }, >+ "B_address2", >+ { accessor => "b_address2", data_type => "text", is_nullable => 1 }, >+ "B_city", >+ { accessor => "b_city", data_type => "mediumtext", is_nullable => 1 }, >+ "B_state", >+ { accessor => "b_state", data_type => "text", is_nullable => 1 }, >+ "B_zipcode", >+ { >+ accessor => "b_zipcode", >+ data_type => "varchar", >+ is_nullable => 1, >+ size => 25, >+ }, >+ "B_country", >+ { accessor => "b_country", data_type => "text", is_nullable => 1 }, >+ "B_email", >+ { accessor => "b_email", data_type => "text", is_nullable => 1 }, >+ "B_phone", >+ { accessor => "b_phone", data_type => "mediumtext", is_nullable => 1 }, >+ "dateofbirth", >+ { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, >+ "branchcode", >+ { >+ data_type => "varchar", >+ default_value => "", >+ is_foreign_key => 1, >+ is_nullable => 0, >+ size => 10, >+ }, >+ "categorycode", >+ { >+ data_type => "varchar", >+ default_value => "", >+ is_foreign_key => 1, >+ is_nullable => 0, >+ size => 10, >+ }, >+ "dateenrolled", >+ { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, >+ "dateexpiry", >+ { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, >+ "gonenoaddress", >+ { data_type => "tinyint", is_nullable => 1 }, >+ "lost", >+ { data_type => "tinyint", is_nullable => 1 }, >+ "debarred", >+ { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, >+ "debarredcomment", >+ { data_type => "varchar", is_nullable => 1, size => 255 }, >+ "contactname", >+ { data_type => "mediumtext", is_nullable => 1 }, >+ "contactfirstname", >+ { data_type => "text", is_nullable => 1 }, >+ "contacttitle", >+ { data_type => "text", is_nullable => 1 }, >+ "guarantorid", >+ { data_type => "integer", is_nullable => 1 }, >+ "borrowernotes", >+ { data_type => "mediumtext", is_nullable => 1 }, >+ "relationship", >+ { data_type => "varchar", is_nullable => 1, size => 100 }, >+ "sex", >+ { data_type => "varchar", is_nullable => 1, size => 1 }, >+ "password", >+ { data_type => "varchar", is_nullable => 1, size => 60 }, >+ "flags", >+ { data_type => "integer", is_nullable => 1 }, >+ "userid", >+ { data_type => "varchar", is_nullable => 1, size => 75 }, >+ "opacnote", >+ { data_type => "mediumtext", is_nullable => 1 }, >+ "contactnote", >+ { data_type => "varchar", is_nullable => 1, size => 255 }, >+ "sort1", >+ { data_type => "varchar", is_nullable => 1, size => 80 }, >+ "sort2", >+ { data_type => "varchar", is_nullable => 1, size => 80 }, >+ "altcontactfirstname", >+ { data_type => "varchar", is_nullable => 1, size => 255 }, >+ "altcontactsurname", >+ { data_type => "varchar", is_nullable => 1, size => 255 }, >+ "altcontactaddress1", >+ { data_type => "varchar", is_nullable => 1, size => 255 }, >+ "altcontactaddress2", >+ { data_type => "varchar", is_nullable => 1, size => 255 }, >+ "altcontactaddress3", >+ { data_type => "varchar", is_nullable => 1, size => 255 }, >+ "altcontactstate", >+ { data_type => "text", is_nullable => 1 }, >+ "altcontactzipcode", >+ { data_type => "varchar", is_nullable => 1, size => 50 }, >+ "altcontactcountry", >+ { data_type => "text", is_nullable => 1 }, >+ "altcontactphone", >+ { data_type => "varchar", is_nullable => 1, size => 50 }, >+ "smsalertnumber", >+ { data_type => "varchar", is_nullable => 1, size => 50 }, >+ "sms_provider_id", >+ { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, >+ "privacy", >+ { data_type => "integer", default_value => 1, is_nullable => 0 }, >+ "privacy_guarantor_checkouts", >+ { data_type => "tinyint", default_value => 0, is_nullable => 0 }, >+ "checkprevcheckout", >+ { >+ data_type => "varchar", >+ default_value => "inherit", >+ is_nullable => 0, >+ size => 7, >+ }, >+ "updated_on", >+ { >+ data_type => "timestamp", >+ datetime_undef_if_invalid => 1, >+ default_value => \"current_timestamp", >+ is_nullable => 0, >+ }, >+ "lastseen", >+ { >+ data_type => "datetime", >+ datetime_undef_if_invalid => 1, >+ is_nullable => 1, >+ }, >+); >+ >+=head1 PRIMARY KEY >+ >+=over 4 >+ >+=item * L</borrowernumber> >+ >+=back >+ >+=cut >+ >+__PACKAGE__->set_primary_key("borrowernumber"); >+ >+=head1 UNIQUE CONSTRAINTS >+ >+=head2 C<cardnumber> >+ >+=over 4 >+ >+=item * L</cardnumber> >+ >+=back >+ >+=cut >+ >+__PACKAGE__->add_unique_constraint("cardnumber", ["cardnumber"]); >+ >+=head2 C<userid> >+ >+=over 4 >+ >+=item * L</userid> >+ >+=back >+ >+=cut >+ >+__PACKAGE__->add_unique_constraint("userid", ["userid"]); >+ >+=head1 RELATIONS >+ >+=head2 accountlines >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Accountline> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "accountlines", >+ "Koha::Schema::Result::Accountline", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 accountoffsets >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Accountoffset> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "accountoffsets", >+ "Koha::Schema::Result::Accountoffset", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 aqbasketusers >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Aqbasketuser> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "aqbasketusers", >+ "Koha::Schema::Result::Aqbasketuser", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 aqbudgetborrowers >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Aqbudgetborrower> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "aqbudgetborrowers", >+ "Koha::Schema::Result::Aqbudgetborrower", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 aqorder_users >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::AqorderUser> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "aqorder_users", >+ "Koha::Schema::Result::AqorderUser", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { 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 >+ >+Related object: L<Koha::Schema::Result::BorrowerAttribute> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "borrower_attributes", >+ "Koha::Schema::Result::BorrowerAttribute", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 borrower_debarments >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::BorrowerDebarment> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "borrower_debarments", >+ "Koha::Schema::Result::BorrowerDebarment", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 borrower_files >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::BorrowerFile> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "borrower_files", >+ "Koha::Schema::Result::BorrowerFile", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 borrower_message_preferences >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::BorrowerMessagePreference> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "borrower_message_preferences", >+ "Koha::Schema::Result::BorrowerMessagePreference", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 borrower_syncs >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::BorrowerSync> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "borrower_syncs", >+ "Koha::Schema::Result::BorrowerSync", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=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, on_delete => "RESTRICT", on_update => "RESTRICT" }, >+); >+ >+=head2 categorycode >+ >+Type: belongs_to >+ >+Related object: L<Koha::Schema::Result::Category> >+ >+=cut >+ >+__PACKAGE__->belongs_to( >+ "categorycode", >+ "Koha::Schema::Result::Category", >+ { categorycode => "categorycode" }, >+ { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" }, >+); >+ >+=head2 course_instructors >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::CourseInstructor> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "course_instructors", >+ "Koha::Schema::Result::CourseInstructor", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 creator_batches >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::CreatorBatch> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "creator_batches", >+ "Koha::Schema::Result::CreatorBatch", >+ { "foreign.borrower_number" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 discharges >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Discharge> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "discharges", >+ "Koha::Schema::Result::Discharge", >+ { "foreign.borrower" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 hold_fill_targets >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::HoldFillTarget> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "hold_fill_targets", >+ "Koha::Schema::Result::HoldFillTarget", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 housebound_profile >+ >+Type: might_have >+ >+Related object: L<Koha::Schema::Result::HouseboundProfile> >+ >+=cut >+ >+__PACKAGE__->might_have( >+ "housebound_profile", >+ "Koha::Schema::Result::HouseboundProfile", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 housebound_role >+ >+Type: might_have >+ >+Related object: L<Koha::Schema::Result::HouseboundRole> >+ >+=cut >+ >+__PACKAGE__->might_have( >+ "housebound_role", >+ "Koha::Schema::Result::HouseboundRole", >+ { "foreign.borrowernumber_id" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 housebound_visit_chooser_brwnumbers >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::HouseboundVisit> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "housebound_visit_chooser_brwnumbers", >+ "Koha::Schema::Result::HouseboundVisit", >+ { "foreign.chooser_brwnumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 housebound_visit_deliverer_brwnumbers >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::HouseboundVisit> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "housebound_visit_deliverer_brwnumbers", >+ "Koha::Schema::Result::HouseboundVisit", >+ { "foreign.deliverer_brwnumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ > =head2 issues > > Type: has_many >@@ -1348,3 +2709,16 @@ sub koha_objects_class { > } > > 1; >+# End of lines loaded from '/home/alex/src/koha/Koha/Schema/Result/Borrower.pm' >+ >+__PACKAGE__->belongs_to( >+ "guarantor", >+ "Koha::Schema::Result::Borrower", >+ { borrowernumber => "guarantorid" }, >+); >+ >+sub koha_objects_class { >+ 'Koha::Patrons'; >+} >+ >+1; >diff --git a/Koha/Schema/Result/Branch.pm b/Koha/Schema/Result/Branch.pm >index ec44cde..4bf0344 100644 >--- a/Koha/Schema/Result/Branch.pm >+++ b/Koha/Schema/Result/Branch.pm >@@ -442,6 +442,576 @@ __PACKAGE__->has_many( > { cascade_copy => 0, cascade_delete => 0 }, > ); > >+=head2 illrequests >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Illrequest> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "illrequests", >+ "Koha::Schema::Result::Illrequest", >+ { "foreign.branchcode" => "self.branchcode" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 items_holdingbranches >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Item> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "items_holdingbranches", >+ "Koha::Schema::Result::Item", >+ { "foreign.holdingbranch" => "self.branchcode" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 items_homebranches >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Item> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "items_homebranches", >+ "Koha::Schema::Result::Item", >+ { "foreign.homebranch" => "self.branchcode" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 opac_news >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::OpacNews> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "opac_news", >+ "Koha::Schema::Result::OpacNews", >+ { "foreign.branchcode" => "self.branchcode" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 reserves >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Reserve> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "reserves", >+ "Koha::Schema::Result::Reserve", >+ { "foreign.branchcode" => "self.branchcode" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 transport_cost_frombranches >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::TransportCost> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "transport_cost_frombranches", >+ "Koha::Schema::Result::TransportCost", >+ { "foreign.frombranch" => "self.branchcode" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 transport_cost_tobranches >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::TransportCost> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "transport_cost_tobranches", >+ "Koha::Schema::Result::TransportCost", >+ { "foreign.tobranch" => "self.branchcode" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 categorycodes >+ >+Type: many_to_many >+ >+Composing rels: L</branchrelations> -> categorycode >+ >+=cut >+ >+__PACKAGE__->many_to_many("categorycodes", "branchrelations", "categorycode"); >+ >+ >+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-02-03 16:55:44 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pWB4xcUOQAG7MrlZVbvwqw >+# These lines were loaded from '/home/alex/src/koha/Koha/Schema/Result/Branch.pm' found in @INC. >+# They are now part of the custom portion of this file >+# for you to hand-edit. If you do not either delete >+# this section or remove that file from @INC, this section >+# will be repeated redundantly when you re-create this >+# file again via Loader! See skip_load_external to disable >+# this feature. >+ >+use utf8; >+package Koha::Schema::Result::Branch; >+ >+# Created by DBIx::Class::Schema::Loader >+# DO NOT MODIFY THE FIRST PART OF THIS FILE >+ >+=head1 NAME >+ >+Koha::Schema::Result::Branch >+ >+=cut >+ >+use strict; >+use warnings; >+ >+use base 'DBIx::Class::Core'; >+ >+=head1 TABLE: C<branches> >+ >+=cut >+ >+__PACKAGE__->table("branches"); >+ >+=head1 ACCESSORS >+ >+=head2 branchcode >+ >+ data_type: 'varchar' >+ default_value: (empty string) >+ is_nullable: 0 >+ size: 10 >+ >+=head2 branchname >+ >+ data_type: 'mediumtext' >+ is_nullable: 0 >+ >+=head2 branchaddress1 >+ >+ data_type: 'mediumtext' >+ is_nullable: 1 >+ >+=head2 branchaddress2 >+ >+ data_type: 'mediumtext' >+ is_nullable: 1 >+ >+=head2 branchaddress3 >+ >+ data_type: 'mediumtext' >+ is_nullable: 1 >+ >+=head2 branchzip >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 25 >+ >+=head2 branchcity >+ >+ data_type: 'mediumtext' >+ is_nullable: 1 >+ >+=head2 branchstate >+ >+ data_type: 'mediumtext' >+ is_nullable: 1 >+ >+=head2 branchcountry >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 branchphone >+ >+ data_type: 'mediumtext' >+ is_nullable: 1 >+ >+=head2 branchfax >+ >+ data_type: 'mediumtext' >+ is_nullable: 1 >+ >+=head2 branchemail >+ >+ data_type: 'mediumtext' >+ is_nullable: 1 >+ >+=head2 branchreplyto >+ >+ data_type: 'mediumtext' >+ is_nullable: 1 >+ >+=head2 branchreturnpath >+ >+ data_type: 'mediumtext' >+ is_nullable: 1 >+ >+=head2 branchurl >+ >+ data_type: 'mediumtext' >+ is_nullable: 1 >+ >+=head2 issuing >+ >+ data_type: 'tinyint' >+ is_nullable: 1 >+ >+=head2 branchip >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 15 >+ >+=head2 branchprinter >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 100 >+ >+=head2 branchnotes >+ >+ data_type: 'mediumtext' >+ is_nullable: 1 >+ >+=head2 opac_info >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=cut >+ >+__PACKAGE__->add_columns( >+ "branchcode", >+ { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 }, >+ "branchname", >+ { data_type => "mediumtext", is_nullable => 0 }, >+ "branchaddress1", >+ { data_type => "mediumtext", is_nullable => 1 }, >+ "branchaddress2", >+ { data_type => "mediumtext", is_nullable => 1 }, >+ "branchaddress3", >+ { data_type => "mediumtext", is_nullable => 1 }, >+ "branchzip", >+ { data_type => "varchar", is_nullable => 1, size => 25 }, >+ "branchcity", >+ { data_type => "mediumtext", is_nullable => 1 }, >+ "branchstate", >+ { data_type => "mediumtext", is_nullable => 1 }, >+ "branchcountry", >+ { data_type => "text", is_nullable => 1 }, >+ "branchphone", >+ { data_type => "mediumtext", is_nullable => 1 }, >+ "branchfax", >+ { data_type => "mediumtext", is_nullable => 1 }, >+ "branchemail", >+ { data_type => "mediumtext", is_nullable => 1 }, >+ "branchreplyto", >+ { data_type => "mediumtext", is_nullable => 1 }, >+ "branchreturnpath", >+ { data_type => "mediumtext", is_nullable => 1 }, >+ "branchurl", >+ { data_type => "mediumtext", is_nullable => 1 }, >+ "issuing", >+ { data_type => "tinyint", is_nullable => 1 }, >+ "branchip", >+ { data_type => "varchar", is_nullable => 1, size => 15 }, >+ "branchprinter", >+ { data_type => "varchar", is_nullable => 1, size => 100 }, >+ "branchnotes", >+ { data_type => "mediumtext", is_nullable => 1 }, >+ "opac_info", >+ { data_type => "text", is_nullable => 1 }, >+); >+ >+=head1 PRIMARY KEY >+ >+=over 4 >+ >+=item * L</branchcode> >+ >+=back >+ >+=cut >+ >+__PACKAGE__->set_primary_key("branchcode"); >+ >+=head1 RELATIONS >+ >+=head2 aqbaskets >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Aqbasket> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "aqbaskets", >+ "Koha::Schema::Result::Aqbasket", >+ { "foreign.branch" => "self.branchcode" }, >+ { 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 >+ >+Related object: L<Koha::Schema::Result::AuthorisedValuesBranch> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "authorised_values_branches", >+ "Koha::Schema::Result::AuthorisedValuesBranch", >+ { "foreign.branchcode" => "self.branchcode" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 borrower_attribute_types_branches >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::BorrowerAttributeTypesBranch> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "borrower_attribute_types_branches", >+ "Koha::Schema::Result::BorrowerAttributeTypesBranch", >+ { "foreign.b_branchcode" => "self.branchcode" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 borrowers >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Borrower> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "borrowers", >+ "Koha::Schema::Result::Borrower", >+ { "foreign.branchcode" => "self.branchcode" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 branch_borrower_circ_rules >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::BranchBorrowerCircRule> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "branch_borrower_circ_rules", >+ "Koha::Schema::Result::BranchBorrowerCircRule", >+ { "foreign.branchcode" => "self.branchcode" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 branch_item_rules >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::BranchItemRule> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "branch_item_rules", >+ "Koha::Schema::Result::BranchItemRule", >+ { "foreign.branchcode" => "self.branchcode" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 branchrelations >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Branchrelation> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "branchrelations", >+ "Koha::Schema::Result::Branchrelation", >+ { "foreign.branchcode" => "self.branchcode" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 branchtransfers_frombranches >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Branchtransfer> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "branchtransfers_frombranches", >+ "Koha::Schema::Result::Branchtransfer", >+ { "foreign.frombranch" => "self.branchcode" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 branchtransfers_tobranches >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Branchtransfer> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "branchtransfers_tobranches", >+ "Koha::Schema::Result::Branchtransfer", >+ { "foreign.tobranch" => "self.branchcode" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 categories_branches >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::CategoriesBranch> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "categories_branches", >+ "Koha::Schema::Result::CategoriesBranch", >+ { "foreign.branchcode" => "self.branchcode" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 collections >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Collection> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "collections", >+ "Koha::Schema::Result::Collection", >+ { "foreign.colBranchcode" => "self.branchcode" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 course_items >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::CourseItem> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "course_items", >+ "Koha::Schema::Result::CourseItem", >+ { "foreign.holdingbranch" => "self.branchcode" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 creator_batches >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::CreatorBatch> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "creator_batches", >+ "Koha::Schema::Result::CreatorBatch", >+ { "foreign.branch_code" => "self.branchcode" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 default_branch_circ_rule >+ >+Type: might_have >+ >+Related object: L<Koha::Schema::Result::DefaultBranchCircRule> >+ >+=cut >+ >+__PACKAGE__->might_have( >+ "default_branch_circ_rule", >+ "Koha::Schema::Result::DefaultBranchCircRule", >+ { "foreign.branchcode" => "self.branchcode" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 edifact_eans >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::EdifactEan> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "edifact_eans", >+ "Koha::Schema::Result::EdifactEan", >+ { "foreign.branchcode" => "self.branchcode" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 hold_fill_targets >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::HoldFillTarget> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "hold_fill_targets", >+ "Koha::Schema::Result::HoldFillTarget", >+ { "foreign.source_branchcode" => "self.branchcode" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ > =head2 items_holdingbranches > > Type: has_many >@@ -502,6 +1072,21 @@ __PACKAGE__->has_many( > { cascade_copy => 0, cascade_delete => 0 }, > ); > >+=head2 stockrotationstages >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Stockrotationstage> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "stockrotationstages", >+ "Koha::Schema::Result::Stockrotationstage", >+ { "foreign.branchcode_id" => "self.branchcode" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ > =head2 transport_cost_frombranches > > Type: has_many >@@ -543,8 +1128,18 @@ Composing rels: L</branchrelations> -> categorycode > __PACKAGE__->many_to_many("categorycodes", "branchrelations", "categorycode"); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-10-24 13:56:21 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/9YwsU+GXK+fzc6IX2Tj5g >+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-12-12 17:01:45 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ug0wv4pEEOJ8q8WuD+HQVA >+ >+ >+# You can replace this text with custom code or comments, and it will be preserved on regeneration >+ >+sub koha_objects_class { >+ 'Koha::Libraries'; >+} >+ >+1; >+# End of lines loaded from '/home/alex/src/koha/Koha/Schema/Result/Branch.pm' > > > # You can replace this text with custom code or comments, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/Illrequest.pm b/Koha/Schema/Result/Illrequest.pm >new file mode 100644 >index 0000000..81b3322 >--- /dev/null >+++ b/Koha/Schema/Result/Illrequest.pm >@@ -0,0 +1,239 @@ >+use utf8; >+package Koha::Schema::Result::Illrequest; >+ >+# Created by DBIx::Class::Schema::Loader >+# DO NOT MODIFY THE FIRST PART OF THIS FILE >+ >+=head1 NAME >+ >+Koha::Schema::Result::Illrequest >+ >+=cut >+ >+use strict; >+use warnings; >+ >+use base 'DBIx::Class::Core'; >+ >+=head1 TABLE: C<illrequests> >+ >+=cut >+ >+__PACKAGE__->table("illrequests"); >+ >+=head1 ACCESSORS >+ >+=head2 illrequest_id >+ >+ data_type: 'bigint' >+ extra: {unsigned => 1} >+ is_auto_increment: 1 >+ is_nullable: 0 >+ >+=head2 borrowernumber >+ >+ data_type: 'integer' >+ is_foreign_key: 1 >+ is_nullable: 1 >+ >+=head2 biblio_id >+ >+ data_type: 'integer' >+ is_nullable: 1 >+ >+=head2 branchcode >+ >+ data_type: 'varchar' >+ is_foreign_key: 1 >+ is_nullable: 0 >+ size: 50 >+ >+=head2 status >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 50 >+ >+=head2 placed >+ >+ data_type: 'date' >+ datetime_undef_if_invalid: 1 >+ is_nullable: 1 >+ >+=head2 replied >+ >+ data_type: 'date' >+ datetime_undef_if_invalid: 1 >+ is_nullable: 1 >+ >+=head2 updated >+ >+ data_type: 'timestamp' >+ datetime_undef_if_invalid: 1 >+ default_value: current_timestamp >+ is_nullable: 0 >+ >+=head2 completed >+ >+ data_type: 'date' >+ datetime_undef_if_invalid: 1 >+ is_nullable: 1 >+ >+=head2 medium >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 30 >+ >+=head2 accessurl >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 500 >+ >+=head2 cost >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 20 >+ >+=head2 notesopac >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 notesstaff >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 orderid >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 50 >+ >+=head2 backend >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 20 >+ >+=cut >+ >+__PACKAGE__->add_columns( >+ "illrequest_id", >+ { >+ data_type => "bigint", >+ extra => { unsigned => 1 }, >+ is_auto_increment => 1, >+ is_nullable => 0, >+ }, >+ "borrowernumber", >+ { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, >+ "biblio_id", >+ { data_type => "integer", is_nullable => 1 }, >+ "branchcode", >+ { data_type => "varchar", is_foreign_key => 1, is_nullable => 0, size => 50 }, >+ "status", >+ { data_type => "varchar", is_nullable => 1, size => 50 }, >+ "placed", >+ { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, >+ "replied", >+ { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, >+ "updated", >+ { >+ data_type => "timestamp", >+ datetime_undef_if_invalid => 1, >+ default_value => \"current_timestamp", >+ is_nullable => 0, >+ }, >+ "completed", >+ { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, >+ "medium", >+ { data_type => "varchar", is_nullable => 1, size => 30 }, >+ "accessurl", >+ { data_type => "varchar", is_nullable => 1, size => 500 }, >+ "cost", >+ { data_type => "varchar", is_nullable => 1, size => 20 }, >+ "notesopac", >+ { data_type => "text", is_nullable => 1 }, >+ "notesstaff", >+ { data_type => "text", is_nullable => 1 }, >+ "orderid", >+ { data_type => "varchar", is_nullable => 1, size => 50 }, >+ "backend", >+ { data_type => "varchar", is_nullable => 1, size => 20 }, >+); >+ >+=head1 PRIMARY KEY >+ >+=over 4 >+ >+=item * L</illrequest_id> >+ >+=back >+ >+=cut >+ >+__PACKAGE__->set_primary_key("illrequest_id"); >+ >+=head1 RELATIONS >+ >+=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, >+ join_type => "LEFT", >+ 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, on_delete => "CASCADE", on_update => "CASCADE" }, >+); >+ >+=head2 illrequestattributes >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Illrequestattribute> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "illrequestattributes", >+ "Koha::Schema::Result::Illrequestattribute", >+ { "foreign.illrequest_id" => "self.illrequest_id" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+ >+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-02-03 16:31:16 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Vb/fWCE2riLlSNJPS+KL7w >+ >+ >+# You can replace this text with custom code or comments, and it will be preserved on regeneration >+1; >diff --git a/Koha/Schema/Result/Illrequestattribute.pm b/Koha/Schema/Result/Illrequestattribute.pm >new file mode 100644 >index 0000000..29598cc >--- /dev/null >+++ b/Koha/Schema/Result/Illrequestattribute.pm >@@ -0,0 +1,97 @@ >+use utf8; >+package Koha::Schema::Result::Illrequestattribute; >+ >+# Created by DBIx::Class::Schema::Loader >+# DO NOT MODIFY THE FIRST PART OF THIS FILE >+ >+=head1 NAME >+ >+Koha::Schema::Result::Illrequestattribute >+ >+=cut >+ >+use strict; >+use warnings; >+ >+use base 'DBIx::Class::Core'; >+ >+=head1 TABLE: C<illrequestattributes> >+ >+=cut >+ >+__PACKAGE__->table("illrequestattributes"); >+ >+=head1 ACCESSORS >+ >+=head2 illrequest_id >+ >+ data_type: 'bigint' >+ extra: {unsigned => 1} >+ is_foreign_key: 1 >+ is_nullable: 0 >+ >+=head2 type >+ >+ data_type: 'varchar' >+ is_nullable: 0 >+ size: 200 >+ >+=head2 value >+ >+ data_type: 'text' >+ is_nullable: 0 >+ >+=cut >+ >+__PACKAGE__->add_columns( >+ "illrequest_id", >+ { >+ data_type => "bigint", >+ extra => { unsigned => 1 }, >+ is_foreign_key => 1, >+ is_nullable => 0, >+ }, >+ "type", >+ { data_type => "varchar", is_nullable => 0, size => 200 }, >+ "value", >+ { data_type => "text", is_nullable => 0 }, >+); >+ >+=head1 PRIMARY KEY >+ >+=over 4 >+ >+=item * L</illrequest_id> >+ >+=item * L</type> >+ >+=back >+ >+=cut >+ >+__PACKAGE__->set_primary_key("illrequest_id", "type"); >+ >+=head1 RELATIONS >+ >+=head2 illrequest >+ >+Type: belongs_to >+ >+Related object: L<Koha::Schema::Result::Illrequest> >+ >+=cut >+ >+__PACKAGE__->belongs_to( >+ "illrequest", >+ "Koha::Schema::Result::Illrequest", >+ { illrequest_id => "illrequest_id" }, >+ { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, >+); >+ >+ >+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-02-03 16:31:16 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2QDst/4XUeffLXHbVlOUVg >+ >+ >+# You can replace this text with custom code or comments, and it will be preserved on regeneration >+1; >-- >2.1.4
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 7317
:
59893
|
59894
|
59895
|
59920
|
60485
|
60486
|
60487
|
60488
|
63081
|
63082
|
63083
|
63084
|
63085
|
63086
|
63087
|
63088
|
63089
|
63090
|
63113
|
63175
|
63176
|
63354
|
63421
|
63472
|
63475
|
65469
|
65470
|
65471
|
65472
|
65473
|
65474
|
65475
|
65476
|
66266
|
67242
|
67243
|
67244
|
67245
|
67246
|
67247
|
67248
|
67249
|
67250
|
67251
|
67252
|
67253
|
67254
|
67255
|
67256
|
67257
|
67258
|
67259
|
67260
|
67261
|
67262
|
67263
|
67264
|
67281
|
67282
|
67283
|
67284
|
67285
|
67286
|
67287
|
67288
|
67289
|
67290
|
67291
|
67292
|
67293
|
67294
|
67295
|
67296
|
67297
|
67298
|
67299
|
67300
|
67301
|
67302
|
67303
|
68185
|
68186
|
68328
|
68391
|
68406
|
68407
|
68408
|
68409
|
68418
|
68444
|
68445
|
68483
|
68484
|
68485
|
68487
|
68516
|
68517
|
68518
|
68519
|
68520
|
68521
|
68522
|
68523
|
68524
|
68525
|
68542
|
68543
|
68544
|
68545
|
68546
|
68547
|
68548
|
68549
|
68550
|
68551
|
68552
|
68558
|
68559
|
68560
|
68561
|
68562
|
68563
|
68564
|
68565
|
68566
|
68567
|
68858
|
68874
|
68877
|
68878
|
68885
|
68886
|
68921
|
68922
|
68926
|
68927
|
68928
|
68929
|
68931
|
68932
|
68933
|
68988
|
68989
|
68999
|
69000
|
69006
|
69008
|
69009
|
69012
|
69014
|
69044
|
69045
|
69046
|
69056
|
69059
|
69060
|
69061
|
69063
|
69064
|
69065
|
69066
|
69069
|
69070
|
69071
|
69074