Attachment #33793 for bug #13321

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




  data_type: 'tinyint'
  is_nullable: 1

=head2 tax_rate

  data_type: 'decimal'
  is_nullable: 1

  { data_type => "tinyint", is_nullable => 1 },
  "invoiceincgst",
  { data_type => "tinyint", is_nullable => 1 },
  "tax_rate",
  { data_type => "decimal", is_nullable => 1, size => [6, 4] },
  "discount",
  { data_type => "float", is_nullable => 1, size => [6, 4] },

);


# Created by DBIx::Class::Schema::Loader v0.07041 @ 2014-11-14 11:03:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Jat/G0KedbDUNd+ax+dg1A


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




  is_nullable: 1
  size: [28,6]

=head2 unitprice_tax_excluded

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

=head2 unitprice_tax_included

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

=head2 quantityreceived

  data_type: 'smallint'

  data_type: 'mediumtext'
  is_nullable: 1

=head2 supplierreference

  data_type: 'mediumtext'
  is_nullable: 1

=head2 purchaseordernumber

  data_type: 'mediumtext'

  is_nullable: 1
  size: [13,2]

=head2 rrp_tax_excluded

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

=head2 rrp_tax_included

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

=head2 ecost

  data_type: 'decimal'
  is_nullable: 1
  size: [13,2]

=head2 ecost_tax_excluded

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

=head2 ecost_tax_included

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

=head2 tax_rate

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

=head2 tax_value

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

=head2 discount

  data_type: 'float'

  is_nullable: 1
  size: 16

=head2 supplierreference

  data_type: 'mediumtext'
  is_nullable: 1

=cut

__PACKAGE__->add_columns(

  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
  "unitprice",
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
  "unitprice_tax_excluded",
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
  "unitprice_tax_included",
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
  "quantityreceived",
  { data_type => "smallint", default_value => 0, is_nullable => 0 },
  "datecancellationprinted",

  { data_type => "mediumtext", is_nullable => 1 },
  "order_vendornote",
  { data_type => "mediumtext", is_nullable => 1 },
  "supplierreference",
  { data_type => "mediumtext", is_nullable => 1 },
  "purchaseordernumber",
  { data_type => "mediumtext", is_nullable => 1 },
  "basketno",

  },
  "rrp",
  { data_type => "decimal", is_nullable => 1, size => [13, 2] },
  "rrp_tax_excluded",
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
  "rrp_tax_included",
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
  "ecost",
  { data_type => "decimal", is_nullable => 1, size => [13, 2] },
  "ecost_tax_excluded",
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
  "ecost_tax_included",
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
  "tax_rate",
  { data_type => "decimal", is_nullable => 1, size => [6, 4] },
  "tax_value",
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
  "discount",
  { data_type => "float", is_nullable => 1, size => [6, 4] },
  "budget_id",

    is_nullable => 1,
    size => 16,
  },
  "supplierreference",
  { data_type => "mediumtext", is_nullable => 1 },
);

=head1 PRIMARY KEY

  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 aqorderusers

Type: has_many

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

=cut

__PACKAGE__->has_many(
  "aqorderusers",
  "Koha::Schema::Result::Aqorderuser",
  { "foreign.ordernumber" => "self.ordernumber" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 basketno

Type: belongs_to

  },
);

=head2 borrowernumbers

Type: many_to_many

Composing rels: L</aqorderusers> -> borrowernumber

=cut

__PACKAGE__->many_to_many("borrowernumbers", "aqorderusers", "borrowernumber");


# Created by DBIx::Class::Schema::Loader v0.07041 @ 2014-11-14 12:17:07
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:WtLVCrU9/7hf5AenldifDw


# You can replace this text with custom content, and it will be preserved on regeneration
- 

Return to bug 13321

Lines 142-148 __PACKAGE__->table("aqbooksellers"); Link Here

(-)a/Koha/Schema/Result/Aqbookseller.pm (-4 / +4 lines)
142	data_type: 'tinyint'	142	data_type: 'tinyint'
143	is_nullable: 1	143	is_nullable: 1
144		144
145	=head2 gstrate	145	=head2 tax_rate
146		146
147	data_type: 'decimal'	147	data_type: 'decimal'
148	is_nullable: 1	148	is_nullable: 1
Lines 212-218 __PACKAGE__->add_columns( Link Here
212	{ data_type => "tinyint", is_nullable => 1 },	212	{ data_type => "tinyint", is_nullable => 1 },
213	"invoiceincgst",	213	"invoiceincgst",
214	{ data_type => "tinyint", is_nullable => 1 },	214	{ data_type => "tinyint", is_nullable => 1 },
215	"gstrate",	215	"tax_rate",
216	{ data_type => "decimal", is_nullable => 1, size => [6, 4] },	216	{ data_type => "decimal", is_nullable => 1, size => [6, 4] },
217	"discount",	217	"discount",
218	{ data_type => "float", is_nullable => 1, size => [6, 4] },	218	{ data_type => "float", is_nullable => 1, size => [6, 4] },
Lines 352-359 __PACKAGE__->belongs_to( Link Here
352	);	352	);
353		353
354		354
355	# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-08-26 11:53:50	355	# Created by DBIx::Class::Schema::Loader v0.07041 @ 2014-11-14 11:03:41
356	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kz1tuPJihENyV6OyCwyX/A	356	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Jat/G0KedbDUNd+ax+dg1A
357		357
358		358
359	# You can replace this text with custom content, and it will be preserved on regeneration	359	# You can replace this text with custom content, and it will be preserved on regeneration

Lines 88-93 __PACKAGE__->table("aqorders"); Link Here

(-)a/Koha/Schema/Result/Aqorder.pm (-12 / +92 lines)
88	is_nullable: 1	88	is_nullable: 1
89	size: [28,6]	89	size: [28,6]
90		90
		91	=head2 unitprice_tax_excluded
		92
		93	data_type: 'decimal'
		94	is_nullable: 1
		95	size: [28,6]
		96
		97	=head2 unitprice_tax_included
		98
		99	data_type: 'decimal'
		100	is_nullable: 1
		101	size: [28,6]
		102
91	=head2 quantityreceived	103	=head2 quantityreceived
92		104
93	data_type: 'smallint'	105	data_type: 'smallint'
Lines 115-125 __PACKAGE__->table("aqorders"); Link Here
115	data_type: 'mediumtext'	127	data_type: 'mediumtext'
116	is_nullable: 1	128	is_nullable: 1
117		129
118	=head2 supplierreference
119
120	data_type: 'mediumtext'
121	is_nullable: 1
122
123	=head2 purchaseordernumber	130	=head2 purchaseordernumber
124		131
125	data_type: 'mediumtext'	132	data_type: 'mediumtext'
Lines 144-161 __PACKAGE__->table("aqorders"); Link Here
144	is_nullable: 1	151	is_nullable: 1
145	size: [13,2]	152	size: [13,2]
146		153
		154	=head2 rrp_tax_excluded
		155
		156	data_type: 'decimal'
		157	is_nullable: 1
		158	size: [28,6]
		159
		160	=head2 rrp_tax_included
		161
		162	data_type: 'decimal'
		163	is_nullable: 1
		164	size: [28,6]
		165
147	=head2 ecost	166	=head2 ecost
148		167
149	data_type: 'decimal'	168	data_type: 'decimal'
150	is_nullable: 1	169	is_nullable: 1
151	size: [13,2]	170	size: [13,2]
152		171
153	=head2 gstrate	172	=head2 ecost_tax_excluded
		173
		174	data_type: 'decimal'
		175	is_nullable: 1
		176	size: [28,6]
		177
		178	=head2 ecost_tax_included
		179
		180	data_type: 'decimal'
		181	is_nullable: 1
		182	size: [28,6]
		183
		184	=head2 tax_rate
154		185
155	data_type: 'decimal'	186	data_type: 'decimal'
156	is_nullable: 1	187	is_nullable: 1
157	size: [6,4]	188	size: [6,4]
158		189
		190	=head2 tax_value
		191
		192	data_type: 'decimal'
		193	is_nullable: 1
		194	size: [28,6]
		195
159	=head2 discount	196	=head2 discount
160		197
161	data_type: 'float'	198	data_type: 'float'
Lines 237-242 __PACKAGE__->table("aqorders"); Link Here
237	is_nullable: 1	274	is_nullable: 1
238	size: 16	275	size: 16
239		276
		277	=head2 supplierreference
		278
		279	data_type: 'mediumtext'
		280	is_nullable: 1
		281
240	=cut	282	=cut
241		283
242	__PACKAGE__->add_columns(	284	__PACKAGE__->add_columns(
Lines 262-267 __PACKAGE__->add_columns( Link Here
262	{ data_type => "decimal", is_nullable => 1, size => [28, 6] },	304	{ data_type => "decimal", is_nullable => 1, size => [28, 6] },
263	"unitprice",	305	"unitprice",
264	{ data_type => "decimal", is_nullable => 1, size => [28, 6] },	306	{ data_type => "decimal", is_nullable => 1, size => [28, 6] },
		307	"unitprice_tax_excluded",
		308	{ data_type => "decimal", is_nullable => 1, size => [28, 6] },
		309	"unitprice_tax_included",
		310	{ data_type => "decimal", is_nullable => 1, size => [28, 6] },
265	"quantityreceived",	311	"quantityreceived",
266	{ data_type => "smallint", default_value => 0, is_nullable => 0 },	312	{ data_type => "smallint", default_value => 0, is_nullable => 0 },
267	"datecancellationprinted",	313	"datecancellationprinted",
Lines 272-279 __PACKAGE__->add_columns( Link Here
272	{ data_type => "mediumtext", is_nullable => 1 },	318	{ data_type => "mediumtext", is_nullable => 1 },
273	"order_vendornote",	319	"order_vendornote",
274	{ data_type => "mediumtext", is_nullable => 1 },	320	{ data_type => "mediumtext", is_nullable => 1 },
275	"supplierreference",
276	{ data_type => "mediumtext", is_nullable => 1 },
277	"purchaseordernumber",	321	"purchaseordernumber",
278	{ data_type => "mediumtext", is_nullable => 1 },	322	{ data_type => "mediumtext", is_nullable => 1 },
279	"basketno",	323	"basketno",
Lines 287-296 __PACKAGE__->add_columns( Link Here
287	},	331	},
288	"rrp",	332	"rrp",
289	{ data_type => "decimal", is_nullable => 1, size => [13, 2] },	333	{ data_type => "decimal", is_nullable => 1, size => [13, 2] },
		334	"rrp_tax_excluded",
		335	{ data_type => "decimal", is_nullable => 1, size => [28, 6] },
		336	"rrp_tax_included",
		337	{ data_type => "decimal", is_nullable => 1, size => [28, 6] },
290	"ecost",	338	"ecost",
291	{ data_type => "decimal", is_nullable => 1, size => [13, 2] },	339	{ data_type => "decimal", is_nullable => 1, size => [13, 2] },
292	"gstrate",	340	"ecost_tax_excluded",
		341	{ data_type => "decimal", is_nullable => 1, size => [28, 6] },
		342	"ecost_tax_included",
		343	{ data_type => "decimal", is_nullable => 1, size => [28, 6] },
		344	"tax_rate",
293	{ data_type => "decimal", is_nullable => 1, size => [6, 4] },	345	{ data_type => "decimal", is_nullable => 1, size => [6, 4] },
		346	"tax_value",
		347	{ data_type => "decimal", is_nullable => 1, size => [28, 6] },
294	"discount",	348	"discount",
295	{ data_type => "float", is_nullable => 1, size => [6, 4] },	349	{ data_type => "float", is_nullable => 1, size => [6, 4] },
296	"budget_id",	350	"budget_id",
Lines 324-329 __PACKAGE__->add_columns( Link Here
324	is_nullable => 1,	378	is_nullable => 1,
325	size => 16,	379	size => 16,
326	},	380	},
		381	"supplierreference",
		382	{ data_type => "mediumtext", is_nullable => 1 },
327	);	383	);
328		384
329	=head1 PRIMARY KEY	385	=head1 PRIMARY KEY
Lines 385-390 __PACKAGE__->might_have( Link Here
385	{ cascade_copy => 0, cascade_delete => 0 },	441	{ cascade_copy => 0, cascade_delete => 0 },
386	);	442	);
387		443
		444	=head2 aqorderusers
		445
		446	Type: has_many
		447
		448	Related object: L<Koha::Schema::Result::Aqorderuser>
		449
		450	=cut
		451
		452	__PACKAGE__->has_many(
		453	"aqorderusers",
		454	"Koha::Schema::Result::Aqorderuser",
		455	{ "foreign.ordernumber" => "self.ordernumber" },
		456	{ cascade_copy => 0, cascade_delete => 0 },
		457	);
		458
388	=head2 basketno	459	=head2 basketno
389		460
390	Type: belongs_to	461	Type: belongs_to
Lines 465-473 __PACKAGE__->belongs_to( Link Here
465	},	536	},
466	);	537	);
467		538
		539	=head2 borrowernumbers
		540
		541	Type: many_to_many
		542
		543	Composing rels: L</aqorderusers> -> borrowernumber
		544
		545	=cut
		546
		547	__PACKAGE__->many_to_many("borrowernumbers", "aqorderusers", "borrowernumber");
		548
468		549
469	# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-10-30 01:04:01	550	# Created by DBIx::Class::Schema::Loader v0.07041 @ 2014-11-14 12:17:07
470	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:M+R6T+KIk4lqzdYjbYvg9w	551	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:WtLVCrU9/7hf5AenldifDw
471		552
472		553
473	# You can replace this text with custom content, and it will be preserved on regeneration	554	# You can replace this text with custom content, and it will be preserved on regeneration
474	-