Attachment #92942 for bug #23355

View | Details | Raw Unified | Return to bug 23355
Collapse All | Expand All

Lines 929-934 __PACKAGE__->belongs_to( Link Here

(-)a/Koha/Schema/Result/Borrower.pm (-2 / +22 lines)
929	{ is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },	929	{ is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
930	);	930	);
931		931
		932	=head2 cash_register_actions
		933
		934	Type: has_many
		935
		936	Related object: L<Koha::Schema::Result::CashRegisterAction>
		937
		938	=cut
		939
		940	__PACKAGE__->has_many(
		941	"cash_register_actions",
		942	"Koha::Schema::Result::CashRegisterAction",
		943	{ "foreign.manager_id" => "self.borrowernumber" },
		944	{ cascade_copy => 0, cascade_delete => 0 },
		945	);
		946
932	=head2 categorycode	947	=head2 categorycode
933		948
934	Type: belongs_to	949	Type: belongs_to
Lines 1559-1567 Composing rels: L</aqorder_users> -> ordernumber Link Here
1559		1574
1560	__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");	1575	__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1561		1576
		1577	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-07-23 13:21:02
		1578	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:f25Xar862YgzWuWq5/LIRA
1562		1579
1563	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-05-22 04:33:29	1580	__PACKAGE__->belongs_to(
1564	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:lbMdmIHlRt+zayG5+Rq4/w	1581	"guarantor",
		1582	"Koha::Schema::Result::Borrower",
		1583	{ borrowernumber => "guarantorid" },
		1584	);
1565		1585
1566	__PACKAGE__->add_columns(	1586	__PACKAGE__->add_columns(
1567	'+anonymized' => { is_boolean => 1 },	1587	'+anonymized' => { is_boolean => 1 },




  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
);

=head2 cash_register_actions

Type: has_many

Related object: L<Koha::Schema::Result::CashRegisterAction>

=cut

__PACKAGE__->has_many(
  "cash_register_actions",
  "Koha::Schema::Result::CashRegisterAction",
  { "foreign.register_id" => "self.id" },
  { cascade_copy => 0, cascade_delete => 0 },
);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-07-23 13:21:03
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zP8my0Zp5bSARTBfws4n1A


# You can replace this text with custom code or comments, and it will be preserved on regeneration




use utf8;
package Koha::Schema::Result::CashRegisterAction;

# Created by DBIx::Class::Schema::Loader
# DO NOT MODIFY THE FIRST PART OF THIS FILE

=head1 NAME

Koha::Schema::Result::CashRegisterAction

=cut

use strict;
use warnings;

use base 'DBIx::Class::Core';

=head1 TABLE: C<cash_register_actions>

=cut

__PACKAGE__->table("cash_register_actions");

=head1 ACCESSORS

=head2 id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

=head2 code

  data_type: 'varchar'
  is_nullable: 0
  size: 24

=head2 register_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 0

=head2 manager_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 0

=head2 amount

  data_type: 'decimal'
  is_nullable: 1
  size: [28,6]

=head2 timestamp

  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: current_timestamp
  is_nullable: 0

=cut

__PACKAGE__->add_columns(
  "id",
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
  "code",
  { data_type => "varchar", is_nullable => 0, size => 24 },
  "register_id",
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
  "manager_id",
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
  "amount",
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
  "timestamp",
  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => \"current_timestamp",
    is_nullable => 0,
  },
);

=head1 PRIMARY KEY

=over 4

=item * L</id>

=back

=cut

__PACKAGE__->set_primary_key("id");

=head1 RELATIONS

=head2 manager

Type: belongs_to

Related object: L<Koha::Schema::Result::Borrower>

=cut

__PACKAGE__->belongs_to(
  "manager",
  "Koha::Schema::Result::Borrower",
  { borrowernumber => "manager_id" },
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
);

=head2 register

Type: belongs_to

Related object: L<Koha::Schema::Result::CashRegister>

=cut

__PACKAGE__->belongs_to(
  "register",
  "Koha::Schema::Result::CashRegister",
  { id => "register_id" },
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-07-23 13:21:03
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Oaee+hS82IEJHHBGuOXDtw


# You can replace this text with custom code or comments, and it will be preserved on regeneration
1;

Return to bug 23355

Lines 144-152 __PACKAGE__->belongs_to( Link Here

(-)a/Koha/Schema/Result/CashRegister.pm (-2 / +17 lines)
144	{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },	144	{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
145	);	145	);
146		146
		147	=head2 cash_register_actions
147		148
148	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-07-23 13:14:31	149	Type: has_many
149	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:TfGf0U/vWS7IviRlvDdE1w	150
		151	Related object: L<Koha::Schema::Result::CashRegisterAction>
		152
		153	=cut
		154
		155	__PACKAGE__->has_many(
		156	"cash_register_actions",
		157	"Koha::Schema::Result::CashRegisterAction",
		158	{ "foreign.register_id" => "self.id" },
		159	{ cascade_copy => 0, cascade_delete => 0 },
		160	);
		161
		162
		163	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-07-23 13:21:03
		164	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zP8my0Zp5bSARTBfws4n1A
150		165
151		166
152	# You can replace this text with custom code or comments, and it will be preserved on regeneration	167	# You can replace this text with custom code or comments, and it will be preserved on regeneration

Line 0 Link Here

(-)a/Koha/Schema/Result/CashRegisterAction.pm (-1 / +135 lines)
0	-	1	use utf8;
		2	package Koha::Schema::Result::CashRegisterAction;
		3
		4	# Created by DBIx::Class::Schema::Loader
		5	# DO NOT MODIFY THE FIRST PART OF THIS FILE
		6
		7	=head1 NAME
		8
		9	Koha::Schema::Result::CashRegisterAction
		10
		11	=cut
		12
		13	use strict;
		14	use warnings;
		15
		16	use base 'DBIx::Class::Core';
		17
		18	=head1 TABLE: C<cash_register_actions>
		19
		20	=cut
		21
		22	__PACKAGE__->table("cash_register_actions");
		23
		24	=head1 ACCESSORS
		25
		26	=head2 id
		27
		28	data_type: 'integer'
		29	is_auto_increment: 1
		30	is_nullable: 0
		31
		32	=head2 code
		33
		34	data_type: 'varchar'
		35	is_nullable: 0
		36	size: 24
		37
		38	=head2 register_id
		39
		40	data_type: 'integer'
		41	is_foreign_key: 1
		42	is_nullable: 0
		43
		44	=head2 manager_id
		45
		46	data_type: 'integer'
		47	is_foreign_key: 1
		48	is_nullable: 0
		49
		50	=head2 amount
		51
		52	data_type: 'decimal'
		53	is_nullable: 1
		54	size: [28,6]
		55
		56	=head2 timestamp
		57
		58	data_type: 'timestamp'
		59	datetime_undef_if_invalid: 1
		60	default_value: current_timestamp
		61	is_nullable: 0
		62
		63	=cut
		64
		65	__PACKAGE__->add_columns(
66	"id",
67	{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
68	"code",
69	{ data_type => "varchar", is_nullable => 0, size => 24 },
70	"register_id",
71	{ data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
72	"manager_id",
73	{ data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
74	"amount",
75	{ data_type => "decimal", is_nullable => 1, size => [28, 6] },
76	"timestamp",
77	{
78	data_type => "timestamp",
79	datetime_undef_if_invalid => 1,
80	default_value => \"current_timestamp",
81	is_nullable => 0,
82	},
83	);
84
85	=head1 PRIMARY KEY
86
87	=over 4
88
89	=item * L</id>
90
91	=back
92
93	=cut
94
95	__PACKAGE__->set_primary_key("id");
96
97	=head1 RELATIONS
98
99	=head2 manager
100
101	Type: belongs_to
102
103	Related object: L<Koha::Schema::Result::Borrower>
104
105	=cut
106
107	__PACKAGE__->belongs_to(
108	"manager",
109	"Koha::Schema::Result::Borrower",
110	{ borrowernumber => "manager_id" },
111	{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
112	);
113
114	=head2 register
115
116	Type: belongs_to
117
118	Related object: L<Koha::Schema::Result::CashRegister>
119
120	=cut
121
122	__PACKAGE__->belongs_to(
123	"register",
124	"Koha::Schema::Result::CashRegister",
125	{ id => "register_id" },
126	{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
127	);
128
129
130	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-07-23 13:21:03
131	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Oaee+hS82IEJHHBGuOXDtw
132
133
134	# You can replace this text with custom code or comments, and it will be preserved on regeneration
135	1;