Bugzilla – Attachment 44080 Details for
Bug 7736
Edifact QUOTE and ORDER functionality
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
0002-Patch-to-update-DBIx
0002-BUG-7736-Patch-to-update-DBIx-files-for-insert-EDI-i.patch (text/plain), 18.89 KB, created by
Zeno Tajoli
on 2015-10-27 15:14:26 UTC
(
hide
)
Description:
0002-Patch-to-update-DBIx
Filename:
MIME Type:
Creator:
Zeno Tajoli
Created:
2015-10-27 15:14:26 UTC
Size:
18.89 KB
patch
obsolete
>From c5a8723b4cd7f74c10ecf31a2de42a42e4b5d2b2 Mon Sep 17 00:00:00 2001 >From: Zeno Tajoli <z.tajoli@cineca.it> >Date: Fri, 23 Oct 2015 16:01:23 +0200 >Subject: [PATCH 2/6] [BUG 7736] Patch to update DBIx files for insert EDI > into Koha > >--- > Koha/Schema/Result/Aqbasket.pm | 19 ++- > Koha/Schema/Result/Aqbookseller.pm | 34 ++++- > Koha/Schema/Result/Aqbudget.pm | 19 ++- > Koha/Schema/Result/Aqinvoice.pm | 32 ++++- > Koha/Schema/Result/Aqorder.pm | 28 +++- > Koha/Schema/Result/Branch.pm | 19 ++- > Koha/Schema/Result/EdifactEan.pm | 80 +++++++++++ > Koha/Schema/Result/EdifactMessage.pm | 203 ++++++++++++++++++++++++++++ > Koha/Schema/Result/VendorEdiAccount.pm | 233 ++++++++++++++++++++++++++++++++ > 9 files changed, 655 insertions(+), 12 deletions(-) > create mode 100644 Koha/Schema/Result/EdifactEan.pm > create mode 100644 Koha/Schema/Result/EdifactMessage.pm > create mode 100644 Koha/Schema/Result/VendorEdiAccount.pm > >diff --git a/Koha/Schema/Result/Aqbasket.pm b/Koha/Schema/Result/Aqbasket.pm >index fbf1185..a3a7c7e 100644 >--- a/Koha/Schema/Result/Aqbasket.pm >+++ b/Koha/Schema/Result/Aqbasket.pm >@@ -263,6 +263,21 @@ __PACKAGE__->belongs_to( > }, > ); > >+=head2 edifact_messages >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::EdifactMessage> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "edifact_messages", >+ "Koha::Schema::Result::EdifactMessage", >+ { "foreign.basketno" => "self.basketno" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ > =head2 borrowernumbers > > Type: many_to_many >@@ -274,8 +289,8 @@ Composing rels: L</aqbasketusers> -> borrowernumber > __PACKAGE__->many_to_many("borrowernumbers", "aqbasketusers", "borrowernumber"); > > >-# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-07-11 09:26:55 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pT+YFf9nfD/dmBuE4RNCFw >+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2015-10-23 15:58:25 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:8yl7H1lTTOFTkH6YCGmWvg > > > # You can replace this text with custom content, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/Aqbookseller.pm b/Koha/Schema/Result/Aqbookseller.pm >index 8641a4b..0364d2b 100644 >--- a/Koha/Schema/Result/Aqbookseller.pm >+++ b/Koha/Schema/Result/Aqbookseller.pm >@@ -311,6 +311,21 @@ __PACKAGE__->has_many( > { cascade_copy => 0, cascade_delete => 0 }, > ); > >+=head2 edifact_messages >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::EdifactMessage> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "edifact_messages", >+ "Koha::Schema::Result::EdifactMessage", >+ { "foreign.vendor_id" => "self.id" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ > =head2 invoiceprice > > Type: belongs_to >@@ -351,9 +366,24 @@ __PACKAGE__->belongs_to( > }, > ); > >+=head2 vendor_edi_accounts >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::VendorEdiAccount> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "vendor_edi_accounts", >+ "Koha::Schema::Result::VendorEdiAccount", >+ { "foreign.vendor_id" => "self.id" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ > >-# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-08-26 11:53:50 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kz1tuPJihENyV6OyCwyX/A >+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2015-10-23 15:58:25 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:MPfS8xgc4x/i4cV+flpzYA > > > # You can replace this text with custom content, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/Aqbudget.pm b/Koha/Schema/Result/Aqbudget.pm >index fa28dfb..4ad1383 100644 >--- a/Koha/Schema/Result/Aqbudget.pm >+++ b/Koha/Schema/Result/Aqbudget.pm >@@ -257,6 +257,21 @@ __PACKAGE__->has_many( > { cascade_copy => 0, cascade_delete => 0 }, > ); > >+=head2 vendor_edi_accounts >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::VendorEdiAccount> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "vendor_edi_accounts", >+ "Koha::Schema::Result::VendorEdiAccount", >+ { "foreign.shipment_budget" => "self.budget_id" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ > =head2 borrowernumbers > > Type: many_to_many >@@ -268,8 +283,8 @@ Composing rels: L</aqbudgetborrowers> -> borrowernumber > __PACKAGE__->many_to_many("borrowernumbers", "aqbudgetborrowers", "borrowernumber"); > > >-# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-02-09 15:51:54 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SZKnWPCMNFUm/TzeBxeDZA >+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2015-10-23 15:58:25 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:vzcH8R0mR1KywrcyTvypIg > > > # You can replace this text with custom content, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/Aqinvoice.pm b/Koha/Schema/Result/Aqinvoice.pm >index ce68093..08a4f5e 100644 >--- a/Koha/Schema/Result/Aqinvoice.pm >+++ b/Koha/Schema/Result/Aqinvoice.pm >@@ -70,6 +70,12 @@ __PACKAGE__->table("aqinvoices"); > is_foreign_key: 1 > is_nullable: 1 > >+=head2 message_id >+ >+ data_type: 'integer' >+ is_foreign_key: 1 >+ is_nullable: 1 >+ > =cut > > __PACKAGE__->add_columns( >@@ -89,6 +95,8 @@ __PACKAGE__->add_columns( > { data_type => "decimal", is_nullable => 1, size => [28, 6] }, > "shipmentcost_budgetid", > { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, >+ "message_id", >+ { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, > ); > > =head1 PRIMARY KEY >@@ -135,6 +143,26 @@ __PACKAGE__->belongs_to( > { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, > ); > >+=head2 message >+ >+Type: belongs_to >+ >+Related object: L<Koha::Schema::Result::EdifactMessage> >+ >+=cut >+ >+__PACKAGE__->belongs_to( >+ "message", >+ "Koha::Schema::Result::EdifactMessage", >+ { id => "message_id" }, >+ { >+ is_deferrable => 1, >+ join_type => "LEFT", >+ on_delete => "SET NULL", >+ on_update => "RESTRICT", >+ }, >+); >+ > =head2 shipmentcost_budgetid > > Type: belongs_to >@@ -156,8 +184,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-07-11 09:26:55 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3se4f767VfvBKaZ8tlXwHQ >+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2015-10-23 15:58:25 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:I+ll6Sn7RG4rimkI7hoMgw > > > # You can replace this text with custom content, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/Aqorder.pm b/Koha/Schema/Result/Aqorder.pm >index f511aeb..ff94947 100644 >--- a/Koha/Schema/Result/Aqorder.pm >+++ b/Koha/Schema/Result/Aqorder.pm >@@ -227,6 +227,24 @@ __PACKAGE__->table("aqorders"); > is_nullable: 1 > size: 16 > >+=head2 line_item_id >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 35 >+ >+=head2 suppliers_reference_number >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 35 >+ >+=head2 suppliers_reference_qualifier >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 3 >+ > =cut > > __PACKAGE__->add_columns( >@@ -310,6 +328,12 @@ __PACKAGE__->add_columns( > is_nullable => 1, > size => 16, > }, >+ "line_item_id", >+ { data_type => "varchar", is_nullable => 1, size => 35 }, >+ "suppliers_reference_number", >+ { data_type => "varchar", is_nullable => 1, size => 35 }, >+ "suppliers_reference_qualifier", >+ { data_type => "varchar", is_nullable => 1, size => 3 }, > ); > > =head1 PRIMARY KEY >@@ -492,8 +516,8 @@ Composing rels: L</aqorder_users> -> borrowernumber > __PACKAGE__->many_to_many("borrowernumbers", "aqorder_users", "borrowernumber"); > > >-# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-05-14 11:27:15 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BCa/SxerJ+zEh8Pg9Jdkaw >+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2015-10-23 15:58:25 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Ta2J2GOaclzd/SwqqCyu6A > > > # 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..59995b4 100644 >--- a/Koha/Schema/Result/Branch.pm >+++ b/Koha/Schema/Result/Branch.pm >@@ -397,6 +397,21 @@ __PACKAGE__->might_have( > { 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 >@@ -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.07042 @ 2015-10-23 15:58:26 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:edt9FhMdC3zUwsqz4BEWHQ > > > # You can replace this text with custom content, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/EdifactEan.pm b/Koha/Schema/Result/EdifactEan.pm >new file mode 100644 >index 0000000..cdcc637 >--- /dev/null >+++ b/Koha/Schema/Result/EdifactEan.pm >@@ -0,0 +1,80 @@ >+use utf8; >+package Koha::Schema::Result::EdifactEan; >+ >+# Created by DBIx::Class::Schema::Loader >+# DO NOT MODIFY THE FIRST PART OF THIS FILE >+ >+=head1 NAME >+ >+Koha::Schema::Result::EdifactEan >+ >+=cut >+ >+use strict; >+use warnings; >+ >+use base 'DBIx::Class::Core'; >+ >+=head1 TABLE: C<edifact_ean> >+ >+=cut >+ >+__PACKAGE__->table("edifact_ean"); >+ >+=head1 ACCESSORS >+ >+=head2 branchcode >+ >+ data_type: 'varchar' >+ is_foreign_key: 1 >+ is_nullable: 0 >+ size: 10 >+ >+=head2 ean >+ >+ data_type: 'varchar' >+ is_nullable: 0 >+ size: 15 >+ >+=head2 id_code_qualifier >+ >+ data_type: 'varchar' >+ default_value: 14 >+ is_nullable: 0 >+ size: 3 >+ >+=cut >+ >+__PACKAGE__->add_columns( >+ "branchcode", >+ { data_type => "varchar", is_foreign_key => 1, is_nullable => 0, size => 10 }, >+ "ean", >+ { data_type => "varchar", is_nullable => 0, size => 15 }, >+ "id_code_qualifier", >+ { data_type => "varchar", default_value => 14, is_nullable => 0, size => 3 }, >+); >+ >+=head1 RELATIONS >+ >+=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" }, >+); >+ >+ >+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2015-10-23 15:58:26 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LrJt6g6ji7tXaCiX4thIxA >+ >+ >+# You can replace this text with custom code or comments, and it will be preserved on regeneration >+1; >diff --git a/Koha/Schema/Result/EdifactMessage.pm b/Koha/Schema/Result/EdifactMessage.pm >new file mode 100644 >index 0000000..646dcf6 >--- /dev/null >+++ b/Koha/Schema/Result/EdifactMessage.pm >@@ -0,0 +1,203 @@ >+use utf8; >+package Koha::Schema::Result::EdifactMessage; >+ >+# Created by DBIx::Class::Schema::Loader >+# DO NOT MODIFY THE FIRST PART OF THIS FILE >+ >+=head1 NAME >+ >+Koha::Schema::Result::EdifactMessage >+ >+=cut >+ >+use strict; >+use warnings; >+ >+use base 'DBIx::Class::Core'; >+ >+=head1 TABLE: C<edifact_messages> >+ >+=cut >+ >+__PACKAGE__->table("edifact_messages"); >+ >+=head1 ACCESSORS >+ >+=head2 id >+ >+ data_type: 'integer' >+ is_auto_increment: 1 >+ is_nullable: 0 >+ >+=head2 message_type >+ >+ data_type: 'varchar' >+ is_nullable: 0 >+ size: 10 >+ >+=head2 transfer_date >+ >+ data_type: 'date' >+ datetime_undef_if_invalid: 1 >+ is_nullable: 1 >+ >+=head2 vendor_id >+ >+ data_type: 'integer' >+ is_foreign_key: 1 >+ is_nullable: 1 >+ >+=head2 edi_acct >+ >+ data_type: 'integer' >+ is_foreign_key: 1 >+ is_nullable: 1 >+ >+=head2 status >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 basketno >+ >+ data_type: 'integer' >+ is_foreign_key: 1 >+ is_nullable: 1 >+ >+=head2 raw_msg >+ >+ data_type: 'mediumtext' >+ is_nullable: 1 >+ >+=head2 filename >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 deleted >+ >+ data_type: 'tinyint' >+ default_value: 0 >+ is_nullable: 0 >+ >+=cut >+ >+__PACKAGE__->add_columns( >+ "id", >+ { data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, >+ "message_type", >+ { data_type => "varchar", is_nullable => 0, size => 10 }, >+ "transfer_date", >+ { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, >+ "vendor_id", >+ { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, >+ "edi_acct", >+ { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, >+ "status", >+ { data_type => "text", is_nullable => 1 }, >+ "basketno", >+ { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, >+ "raw_msg", >+ { data_type => "mediumtext", is_nullable => 1 }, >+ "filename", >+ { data_type => "text", is_nullable => 1 }, >+ "deleted", >+ { data_type => "tinyint", default_value => 0, is_nullable => 0 }, >+); >+ >+=head1 PRIMARY KEY >+ >+=over 4 >+ >+=item * L</id> >+ >+=back >+ >+=cut >+ >+__PACKAGE__->set_primary_key("id"); >+ >+=head1 RELATIONS >+ >+=head2 aqinvoices >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Aqinvoice> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "aqinvoices", >+ "Koha::Schema::Result::Aqinvoice", >+ { "foreign.message_id" => "self.id" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 basketno >+ >+Type: belongs_to >+ >+Related object: L<Koha::Schema::Result::Aqbasket> >+ >+=cut >+ >+__PACKAGE__->belongs_to( >+ "basketno", >+ "Koha::Schema::Result::Aqbasket", >+ { basketno => "basketno" }, >+ { >+ is_deferrable => 1, >+ join_type => "LEFT", >+ on_delete => "RESTRICT", >+ on_update => "RESTRICT", >+ }, >+); >+ >+=head2 edi_acct >+ >+Type: belongs_to >+ >+Related object: L<Koha::Schema::Result::VendorEdiAccount> >+ >+=cut >+ >+__PACKAGE__->belongs_to( >+ "edi_acct", >+ "Koha::Schema::Result::VendorEdiAccount", >+ { id => "edi_acct" }, >+ { >+ is_deferrable => 1, >+ join_type => "LEFT", >+ on_delete => "RESTRICT", >+ on_update => "RESTRICT", >+ }, >+); >+ >+=head2 vendor >+ >+Type: belongs_to >+ >+Related object: L<Koha::Schema::Result::Aqbookseller> >+ >+=cut >+ >+__PACKAGE__->belongs_to( >+ "vendor", >+ "Koha::Schema::Result::Aqbookseller", >+ { id => "vendor_id" }, >+ { >+ is_deferrable => 1, >+ join_type => "LEFT", >+ on_delete => "RESTRICT", >+ on_update => "RESTRICT", >+ }, >+); >+ >+ >+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2015-10-23 15:58:26 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:eL2BDBYpDcQzn9e1CzCfIA >+ >+ >+# You can replace this text with custom code or comments, and it will be preserved on regeneration >+1; >diff --git a/Koha/Schema/Result/VendorEdiAccount.pm b/Koha/Schema/Result/VendorEdiAccount.pm >new file mode 100644 >index 0000000..4763c07 >--- /dev/null >+++ b/Koha/Schema/Result/VendorEdiAccount.pm >@@ -0,0 +1,233 @@ >+use utf8; >+package Koha::Schema::Result::VendorEdiAccount; >+ >+# Created by DBIx::Class::Schema::Loader >+# DO NOT MODIFY THE FIRST PART OF THIS FILE >+ >+=head1 NAME >+ >+Koha::Schema::Result::VendorEdiAccount >+ >+=cut >+ >+use strict; >+use warnings; >+ >+use base 'DBIx::Class::Core'; >+ >+=head1 TABLE: C<vendor_edi_accounts> >+ >+=cut >+ >+__PACKAGE__->table("vendor_edi_accounts"); >+ >+=head1 ACCESSORS >+ >+=head2 id >+ >+ data_type: 'integer' >+ is_auto_increment: 1 >+ is_nullable: 0 >+ >+=head2 description >+ >+ data_type: 'text' >+ is_nullable: 0 >+ >+=head2 host >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 40 >+ >+=head2 username >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 40 >+ >+=head2 password >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 40 >+ >+=head2 last_activity >+ >+ data_type: 'date' >+ datetime_undef_if_invalid: 1 >+ is_nullable: 1 >+ >+=head2 vendor_id >+ >+ data_type: 'integer' >+ is_foreign_key: 1 >+ is_nullable: 1 >+ >+=head2 download_directory >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 upload_directory >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 san >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 20 >+ >+=head2 id_code_qualifier >+ >+ data_type: 'varchar' >+ default_value: 14 >+ is_nullable: 1 >+ size: 3 >+ >+=head2 transport >+ >+ data_type: 'varchar' >+ default_value: 'FTP' >+ is_nullable: 1 >+ size: 6 >+ >+=head2 quotes_enabled >+ >+ data_type: 'tinyint' >+ default_value: 0 >+ is_nullable: 0 >+ >+=head2 invoices_enabled >+ >+ data_type: 'tinyint' >+ default_value: 0 >+ is_nullable: 0 >+ >+=head2 orders_enabled >+ >+ data_type: 'tinyint' >+ default_value: 0 >+ is_nullable: 0 >+ >+=head2 shipment_budget >+ >+ 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 }, >+ "description", >+ { data_type => "text", is_nullable => 0 }, >+ "host", >+ { data_type => "varchar", is_nullable => 1, size => 40 }, >+ "username", >+ { data_type => "varchar", is_nullable => 1, size => 40 }, >+ "password", >+ { data_type => "varchar", is_nullable => 1, size => 40 }, >+ "last_activity", >+ { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, >+ "vendor_id", >+ { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, >+ "download_directory", >+ { data_type => "text", is_nullable => 1 }, >+ "upload_directory", >+ { data_type => "text", is_nullable => 1 }, >+ "san", >+ { data_type => "varchar", is_nullable => 1, size => 20 }, >+ "id_code_qualifier", >+ { data_type => "varchar", default_value => 14, is_nullable => 1, size => 3 }, >+ "transport", >+ { data_type => "varchar", default_value => "FTP", is_nullable => 1, size => 6 }, >+ "quotes_enabled", >+ { data_type => "tinyint", default_value => 0, is_nullable => 0 }, >+ "invoices_enabled", >+ { data_type => "tinyint", default_value => 0, is_nullable => 0 }, >+ "orders_enabled", >+ { data_type => "tinyint", default_value => 0, is_nullable => 0 }, >+ "shipment_budget", >+ { 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 edifact_messages >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::EdifactMessage> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "edifact_messages", >+ "Koha::Schema::Result::EdifactMessage", >+ { "foreign.edi_acct" => "self.id" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+=head2 shipment_budget >+ >+Type: belongs_to >+ >+Related object: L<Koha::Schema::Result::Aqbudget> >+ >+=cut >+ >+__PACKAGE__->belongs_to( >+ "shipment_budget", >+ "Koha::Schema::Result::Aqbudget", >+ { budget_id => "shipment_budget" }, >+ { >+ is_deferrable => 1, >+ join_type => "LEFT", >+ on_delete => "RESTRICT", >+ on_update => "RESTRICT", >+ }, >+); >+ >+=head2 vendor >+ >+Type: belongs_to >+ >+Related object: L<Koha::Schema::Result::Aqbookseller> >+ >+=cut >+ >+__PACKAGE__->belongs_to( >+ "vendor", >+ "Koha::Schema::Result::Aqbookseller", >+ { id => "vendor_id" }, >+ { >+ is_deferrable => 1, >+ join_type => "LEFT", >+ on_delete => "RESTRICT", >+ on_update => "RESTRICT", >+ }, >+); >+ >+ >+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2015-10-23 15:58:26 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Xvt8c/scmKm1uRt3PbqIfQ >+ >+ >+# You can replace this text with custom code or comments, and it will be preserved on regeneration >+1; >-- >1.7.10.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 7736
:
8275
|
8276
|
8446
|
8635
|
10226
|
12398
|
12438
|
12467
|
13071
|
15304
|
15729
|
16538
|
16629
|
16649
|
16652
|
16667
|
16732
|
16761
|
16779
|
16792
|
16864
|
16865
|
16866
|
16867
|
16868
|
16869
|
16870
|
16871
|
16872
|
16873
|
16874
|
16882
|
16883
|
16884
|
16885
|
16886
|
17120
|
17121
|
20983
|
20984
|
21475
|
33953
|
33957
|
34332
|
34833
|
35030
|
35106
|
35716
|
35717
|
35718
|
36738
|
44079
|
44080
|
44081
|
44082
|
44083
|
44084
|
46996
|
47004
|
48623
|
48624
|
48625
|
48626
|
48971
|
48972
|
48973
|
48974
|
48975
|
48976
|
49037
|
49038
|
49039
|
49040
|
49041
|
49042
|
49307
|
49850
|
50002
|
50008