Revision f41e5b6e
Von Niclas Zimmermann vor mehr als 11 Jahren hinzugefügt
| locale/de/all | ||
|---|---|---|
| 282 | 282 |
'Basic Data' => 'Basisdaten', |
| 283 | 283 |
'Batch Printing' => 'Druck', |
| 284 | 284 |
'Bcc' => 'Bcc', |
| 285 |
'Because the useability gets worth if one partnumber is used for several parts (for example if you are searching a position for an invoice), partnumbers should be unique.' => 'Da die Benutzerfreundlichkeit durch doppelte Artikelnummern erheblich verschlechtert wird (zum Beispiel, wenn man einen Artikel für eine Rechnung sucht), sollten Artikelnummern eindeutig vergeben sein.', |
|
| 285 | 286 |
'Belegnummer' => 'Buchungsnummer', |
| 286 | 287 |
'Beratername' => 'Beratername', |
| 287 | 288 |
'Beraternummer' => 'Beraternummer', |
| ... | ... | |
| 925 | 926 |
'Fristsetzung' => 'Fristsetzung', |
| 926 | 927 |
'From' => 'Von', |
| 927 | 928 |
'From Date' => 'Von', |
| 928 |
'From this version on the partnumer of articles and assemblies have to be unique.' => 'Ab dieser Version muss die Artikelnummer eindeutig sein.',
|
|
| 929 |
'From this version on the partnumber of services, articles and assemblies have to be unique.' => 'Ab dieser Version müssen Artikelnummern eindeutig vergeben werden.',
|
|
| 929 | 930 |
'From this version on the taxkey 0 must have a tax rate of 0 (for DATEV compatibility).' => 'Ab dieser Version muss der Steuerschlüssel 0 einen Steuersatz von 0% haben (auf Grund der DATEV-Kompatibilität).', |
| 930 | 931 |
'Full Access' => 'Vollzugriff', |
| 931 | 932 |
'Full Preview' => 'Alles', |
| ... | ... | |
| 1796 | 1797 |
'Skipping due to existing entry in database' => 'Wegen existierendem Eintrag mit selber Nummer übersprungen', |
| 1797 | 1798 |
'Skonto' => 'Skonto', |
| 1798 | 1799 |
'Skonto Terms' => 'Zahlungsziel Skonto', |
| 1800 |
'So far you could use one partnumber for severel parts, for example a service and an article.' => 'Bisher war es möglich eine Artikelnummer für mehrere Artikel zu verwenden, zum Beispiel eine Artikelnummer für eine Dienstleistung, eine Ware und ein Erzeugnis.', |
|
| 1799 | 1801 |
'Sold' => 'Verkauft', |
| 1800 | 1802 |
'Solution' => 'Lösung', |
| 1801 | 1803 |
'Sort By' => 'Sortiert nach', |
| ... | ... | |
| 2529 | 2531 |
'saving data' => 'Speichere Daten', |
| 2530 | 2532 |
'sent' => 'gesendet', |
| 2531 | 2533 |
'sent to printer' => 'an Drucker geschickt', |
| 2534 |
'service' => 'Dienstleistung', |
|
| 2532 | 2535 |
'service_list' => 'dienstleistungsliste', |
| 2533 | 2536 |
'shipped' => 'verschickt', |
| 2534 | 2537 |
'singular first char' => 'S', |
| sql/Pg-upgrade2/erzeugnisnummern.pl | ||
|---|---|---|
| 25 | 25 |
} |
| 26 | 26 |
|
| 27 | 27 |
sub do_update {
|
| 28 |
my $query = qq|SELECT id, partnumber, description, unit, notes, assembly, ean, inventory_accno_id |
|
| 28 |
if ( $main::form->{'continued'} ) {
|
|
| 29 |
my $update_query; |
|
| 30 |
foreach my $i (1 .. $main::form->{rowcount}) {
|
|
| 31 |
$update_query = qq|UPDATE parts SET partnumber = '| . $main::form->{"partnumber_$i"} . qq|' WHERE id = | . $main::form->{"partid_$i"};
|
|
| 32 |
do_query($update_query); |
|
| 33 |
print FH $i; |
|
| 34 |
} |
|
| 35 |
$dbh->commit(); |
|
| 36 |
} |
|
| 37 |
|
|
| 38 |
my $query = qq|SELECT id, partnumber, description, unit, notes, assembly, ean, inventory_accno_id |
|
| 29 | 39 |
FROM parts pa |
| 30 | 40 |
WHERE (SELECT COUNT(*) |
| 31 | 41 |
FROM parts p |
| ... | ... | |
| 38 | 48 |
|
| 39 | 49 |
$main::form->{PARTS} = [];
|
| 40 | 50 |
while (my $ref = $sth->fetchrow_hashref("NAME_lc")) {
|
| 51 |
map {$ref->{$_} = $::locale->{iconv_utf8}->convert($ref->{$_})} keys %$ref;
|
|
| 41 | 52 |
push @{ $main::form->{PARTS} }, $ref;
|
| 42 | 53 |
} |
| 43 | 54 |
|
| 44 | 55 |
if ( scalar @{ $main::form->{PARTS} } > 0 ) {
|
| 45 | 56 |
&print_error_message; |
| 46 |
return 0;
|
|
| 57 |
return 2;
|
|
| 47 | 58 |
} |
| 48 | 59 |
|
| 49 | 60 |
$query = qq|ALTER TABLE parts ADD UNIQUE (partnumber)|; |
| templates/webpages/dbupgrade/erzeugnisnummern.html | ||
|---|---|---|
| 3 | 3 |
|
| 4 | 4 |
<form name="Form" method="post" action="login.pl"> |
| 5 | 5 |
<input type="hidden" name="action" value="login"> |
| 6 |
<input type="hidden" name="continued" value="1"> |
|
| 6 | 7 |
|
| 7 | 8 |
<p>[% 'There are double partnumbers in your database.' | $T8 %]</p> |
| 8 |
<p>[% 'From this version on the partnumer of articles and assemblies have to be unique.' | $T8 %]</p> |
|
| 9 |
<p>[% 'From this version on the partnumber of services, articles and assemblies have to be unique.' | $T8 %]</p> |
|
| 10 |
<p>[% 'So far you could use one partnumber for severel parts, for example a service and an article.' | $T8 %]</p> |
|
| 11 |
<p>[% 'Because the useability gets worth if one partnumber is used for several parts (for example if you are searching a position for an invoice), partnumbers should be unique.' | $T8 %]</p> |
|
| 9 | 12 |
|
| 10 | 13 |
<p>[% 'Please change the partnumber of the following parts and run the update again:' | $T8 %]</p> |
| 11 | 14 |
<table> |
| ... | ... | |
| 20 | 23 |
|
| 21 | 24 |
[% SET row_odd = '1' %][% FOREACH row = PARTS %] |
| 22 | 25 |
<tr class="listrow[% IF row_odd %]1[% SET row_odd = '0' %][% ELSE %]0[% SET row_odd = '1' %][% END %]"> |
| 23 |
<td align="right">[% HTML.escape(row.partnumber) %]</td> |
|
| 26 |
<td align="right"><input name='partnumber_[% loop.count %]' value='[% HTML.escape(row.partnumber) %]'></td> |
|
| 27 |
<input type="hidden" name='partid_[% loop.count %]' value='[% HTML.escape(row.id) %]'> |
|
| 24 | 28 |
<td align="left"> [% HTML.escape(row.description) %]</a></td> |
| 25 | 29 |
<td align="right">[% HTML.escape(row.unit) %]</td> |
| 26 | 30 |
<td align="right">[% HTML.escape(row.notes) %]</td> |
| 27 | 31 |
<td align="right">[% HTML.escape(row.ean) %]</td> |
| 28 |
<td align="right">[% IF row.assembly %] [% 'assembly' | $T8 %] [% ELSE %] [% IF row.inventory_accno_id %] [% 'part' | $T8 %] [% ELSE %] [% 'service' %] [% END %] [% END %]</td> |
|
| 32 |
<td align="right">[% IF row.assembly %] [% 'assembly' | $T8 %] [% ELSE %] [% IF row.inventory_accno_id %] [% 'part' | $T8 %] [% ELSE %] [% 'service' | $T8 %] [% END %] [% END %]</td>
|
|
| 29 | 33 |
</tr> |
| 34 |
[% SET rowcount = loop.count %] |
|
| 30 | 35 |
[% END %] |
| 36 |
<input type="hidden" name="rowcount" value="[% rowcount %]"> |
|
| 31 | 37 |
</table> |
| 32 | 38 |
|
| 39 |
<input type="submit" value="[% 'Continue' | $T8 %]"> |
|
| 40 |
|
|
| 33 | 41 |
</form> |
Auch abrufbar als: Unified diff
Verbesserung Upgrade-Script Erzeugnisnummern
Die Änderung macht es dem Benutzer möglich, direkt beim Update
Artikelnummern zu ändern. Weiterhin wurde noch Text ergänzt, der
dem Benutzer die Änderung erläutert.