1 # @tag: erzeugnisnummern
2 # @description: Erzeugnisnummern und Artikelnummern sollen eindeutig sein.
3 # @depends: release_3_0_0
4 package SL::DBUpgrade2::erzeugnisnummern;
9 use parent qw(SL::DBUpgrade2::Base);
16 if ( $::form->{'continued'} ) {
18 foreach my $i (1 .. $::form->{rowcount}) {
19 $update_query = qq|UPDATE parts SET partnumber = '| . $::form->{"partnumber_$i"} . qq|' WHERE id = | . $::form->{"partid_$i"};
20 $self->db_query($update_query);
26 my $query = qq|SELECT id, partnumber, description, unit, notes, assembly, ean, inventory_accno_id, obsolete
28 WHERE (SELECT COUNT(*)
30 WHERE p.partnumber=pa.partnumber)
32 ORDER BY partnumber;|;
34 $::form->{PARTS} = [ selectall_hashref_query($::form, $self->dbh, $query) ];
36 if ( scalar @{ $::form->{PARTS} } > 0 ) {
41 $query = qq|ALTER TABLE parts ADD UNIQUE (partnumber)|;
42 $self->db_query($query);
44 $query = qq|ALTER TABLE defaults ADD assemblynumber TEXT|;
45 $self->db_query($query);
49 sub print_error_message {
50 print $::form->parse_html_template("dbupgrade/erzeugnisnummern");