Bugzilla – Attachment 56346 Details for
Bug 5670
Housebound Readers Module
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
DO NOT PUSH: Add Housebound Schema files.
DO-NOT-PUSH-Add-Housebound-Schema-files.patch (text/plain), 6.54 KB, created by
Claire Gravely
on 2016-10-13 11:45:17 UTC
(
hide
)
Description:
DO NOT PUSH: Add Housebound Schema files.
Filename:
MIME Type:
Creator:
Claire Gravely
Created:
2016-10-13 11:45:17 UTC
Size:
6.54 KB
patch
obsolete
>From d09b9a8dabffae7ed8ed20112e8de6db556c3b98 Mon Sep 17 00:00:00 2001 >From: Alex Sassmannshausen <alex.sassmannshausen@ptfs-europe.com> >Date: Fri, 27 May 2016 12:08:23 +0000 >Subject: [PATCH] DO NOT PUSH: Add Housebound Schema files. > >* Koha/Schema/Result/HouseboundProfile.pm: New file. >* Koha/Schema/Result/HouseboundVisit.pm: New file. > >https://bugs.koha-community.org/show_bug.cgi?id=5670 > >Signed-off-by: Claire Gravely <claire_gravely@hotmail.com> >--- > Koha/Schema/Result/HouseboundProfile.pm | 138 ++++++++++++++++++++++++++++ > Koha/Schema/Result/HouseboundVisit.pm | 154 ++++++++++++++++++++++++++++++++ > 2 files changed, 292 insertions(+) > create mode 100644 Koha/Schema/Result/HouseboundProfile.pm > create mode 100644 Koha/Schema/Result/HouseboundVisit.pm > >diff --git a/Koha/Schema/Result/HouseboundProfile.pm b/Koha/Schema/Result/HouseboundProfile.pm >new file mode 100644 >index 0000000..1661eb5 >--- /dev/null >+++ b/Koha/Schema/Result/HouseboundProfile.pm >@@ -0,0 +1,138 @@ >+use utf8; >+package Koha::Schema::Result::HouseboundProfile; >+ >+# Created by DBIx::Class::Schema::Loader >+# DO NOT MODIFY THE FIRST PART OF THIS FILE >+ >+=head1 NAME >+ >+Koha::Schema::Result::HouseboundProfile >+ >+=cut >+ >+use strict; >+use warnings; >+ >+use base 'DBIx::Class::Core'; >+ >+=head1 TABLE: C<housebound_profile> >+ >+=cut >+ >+__PACKAGE__->table("housebound_profile"); >+ >+=head1 ACCESSORS >+ >+=head2 borrowernumber >+ >+ data_type: 'integer' >+ is_foreign_key: 1 >+ is_nullable: 0 >+ >+=head2 day >+ >+ data_type: 'text' >+ is_nullable: 0 >+ >+=head2 frequency >+ >+ data_type: 'text' >+ is_nullable: 0 >+ >+=head2 fav_itemtypes >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 fav_subjects >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 fav_authors >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 referral >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 notes >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=cut >+ >+__PACKAGE__->add_columns( >+ "borrowernumber", >+ { data_type => "integer", is_foreign_key => 1, is_nullable => 0 }, >+ "day", >+ { data_type => "text", is_nullable => 0 }, >+ "frequency", >+ { data_type => "text", is_nullable => 0 }, >+ "fav_itemtypes", >+ { data_type => "text", is_nullable => 1 }, >+ "fav_subjects", >+ { data_type => "text", is_nullable => 1 }, >+ "fav_authors", >+ { data_type => "text", is_nullable => 1 }, >+ "referral", >+ { data_type => "text", is_nullable => 1 }, >+ "notes", >+ { data_type => "text", is_nullable => 1 }, >+); >+ >+=head1 PRIMARY KEY >+ >+=over 4 >+ >+=item * L</borrowernumber> >+ >+=back >+ >+=cut >+ >+__PACKAGE__->set_primary_key("borrowernumber"); >+ >+=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, on_delete => "CASCADE", on_update => "CASCADE" }, >+); >+ >+=head2 housebound_visits >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::HouseboundVisit> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "housebound_visits", >+ "Koha::Schema::Result::HouseboundVisit", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+ >+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-04-25 13:21:23 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kY+BhDo9g/YCShkmFUVDYA >+ >+ >+# You can replace this text with custom code or comments, and it will be preserved on regeneration >+1; >diff --git a/Koha/Schema/Result/HouseboundVisit.pm b/Koha/Schema/Result/HouseboundVisit.pm >new file mode 100644 >index 0000000..ae8c5d6 >--- /dev/null >+++ b/Koha/Schema/Result/HouseboundVisit.pm >@@ -0,0 +1,154 @@ >+use utf8; >+package Koha::Schema::Result::HouseboundVisit; >+ >+# Created by DBIx::Class::Schema::Loader >+# DO NOT MODIFY THE FIRST PART OF THIS FILE >+ >+=head1 NAME >+ >+Koha::Schema::Result::HouseboundVisit >+ >+=cut >+ >+use strict; >+use warnings; >+ >+use base 'DBIx::Class::Core'; >+ >+=head1 TABLE: C<housebound_visit> >+ >+=cut >+ >+__PACKAGE__->table("housebound_visit"); >+ >+=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 appointment_date >+ >+ data_type: 'date' >+ datetime_undef_if_invalid: 1 >+ is_nullable: 1 >+ >+=head2 day_segment >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 10 >+ >+=head2 chooser_brwnumber >+ >+ data_type: 'integer' >+ is_foreign_key: 1 >+ is_nullable: 1 >+ >+=head2 deliverer_brwnumber >+ >+ data_type: 'integer' >+ is_foreign_key: 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 }, >+ "appointment_date", >+ { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, >+ "day_segment", >+ { data_type => "varchar", is_nullable => 1, size => 10 }, >+ "chooser_brwnumber", >+ { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, >+ "deliverer_brwnumber", >+ { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, >+); >+ >+=head1 PRIMARY KEY >+ >+=over 4 >+ >+=item * L</id> >+ >+=back >+ >+=cut >+ >+__PACKAGE__->set_primary_key("id"); >+ >+=head1 RELATIONS >+ >+=head2 borrowernumber >+ >+Type: belongs_to >+ >+Related object: L<Koha::Schema::Result::HouseboundProfile> >+ >+=cut >+ >+__PACKAGE__->belongs_to( >+ "borrowernumber", >+ "Koha::Schema::Result::HouseboundProfile", >+ { borrowernumber => "borrowernumber" }, >+ { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, >+); >+ >+=head2 chooser_brwnumber >+ >+Type: belongs_to >+ >+Related object: L<Koha::Schema::Result::Borrower> >+ >+=cut >+ >+__PACKAGE__->belongs_to( >+ "chooser_brwnumber", >+ "Koha::Schema::Result::Borrower", >+ { borrowernumber => "chooser_brwnumber" }, >+ { >+ is_deferrable => 1, >+ join_type => "LEFT", >+ on_delete => "CASCADE", >+ on_update => "CASCADE", >+ }, >+); >+ >+=head2 deliverer_brwnumber >+ >+Type: belongs_to >+ >+Related object: L<Koha::Schema::Result::Borrower> >+ >+=cut >+ >+__PACKAGE__->belongs_to( >+ "deliverer_brwnumber", >+ "Koha::Schema::Result::Borrower", >+ { borrowernumber => "deliverer_brwnumber" }, >+ { >+ is_deferrable => 1, >+ join_type => "LEFT", >+ on_delete => "CASCADE", >+ on_update => "CASCADE", >+ }, >+); >+ >+ >+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-04-25 13:21:23 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5zyc7l2BtF5cgpZeKbJNZg >+ >+ >+# 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 5670
:
3038
|
22162
|
22163
|
22164
|
22165
|
26816
|
27288
|
50930
|
51377
|
51875
|
54384
|
54385
|
55326
|
55334
|
55335
|
55336
|
55734
|
55735
|
55736
|
55737
|
55738
|
55739
|
55865
|
55866
|
55867
|
55890
|
55891
|
56298
|
56299
|
56300
|
56301
|
56302
|
56308
|
56337
|
56341
|
56346
|
56347
|
56348
|
56349
|
56350
|
56351
|
56352
|
56353
|
56354
|
56355
|
56356
|
56357
|
56358
|
56359
|
56360
|
56361
|
56362
|
56363
|
56364
|
56365
|
56366
|
56367
|
56368
|
56369
|
56580
|
56581
|
56582
|
56583
|
56584
|
56585
|
56586
|
56587
|
56588
|
56589
|
56590
|
56591
|
56592
|
56593
|
56594
|
56595
|
56596
|
56597
|
56598
|
56599
|
56600
|
56601
|
56602
|
56603
|
56604
|
56605
|
56606