Revision cc3a0a33
Von Sven Schöling vor etwa 15 Jahren hinzugefügt
| SL/IC.pm | ||
|---|---|---|
| 1561 | 1561 |
|
| 1562 | 1562 |
my $dbh = $form->get_standard_dbh($myconfig); |
| 1563 | 1563 |
|
| 1564 |
my $query = qq|SELECT id, partnumber, description, unit FROM parts WHERE id IN (| . join(', ', ('?') x scalar(@ids)) . qq|)|;
|
|
| 1564 |
my $query = qq|SELECT * FROM parts WHERE id IN (| . join(', ', ('?') x scalar(@ids)) . qq|)|;
|
|
| 1565 | 1565 |
|
| 1566 | 1566 |
my $info = selectall_hashref_query($form, $dbh, $query, map { conv_i($_) } @ids);
|
| 1567 | 1567 |
|
| bin/mozilla/io.pl | ||
|---|---|---|
| 337 | 337 |
if $form->{"id_$i"} && ($form->{type} =~ /^sales_/ || $form->{type} =~ /invoice/) && !$is_delivery_order;
|
| 338 | 338 |
# / marge calculations ending |
| 339 | 339 |
|
| 340 |
# calculate onhand |
|
| 341 |
if ($form->{"id_$i"}) {
|
|
| 342 |
my $part = IC->get_basic_part_info(id => $form->{"id_$i"});
|
|
| 343 |
my $onhand_color = 'color="#ff0000"' if $part->{onhand} < $part->{rop};
|
|
| 344 |
push @ROW2, { value => sprintf "<b>%s</b> <font %s>%s %s</font>",
|
|
| 345 |
$locale->text('On Hand'),
|
|
| 346 |
$onhand_color, |
|
| 347 |
$form->format_amount(\%myconfig, $part->{onhand}, 2),
|
|
| 348 |
$part->{unit}
|
|
| 349 |
}; |
|
| 350 |
} |
|
| 351 |
# / calculate onhand |
|
| 352 |
|
|
| 340 | 353 |
my @hidden_vars; |
| 341 | 354 |
|
| 342 | 355 |
if ($is_delivery_order) {
|
| locale/de/dn | ||
|---|---|---|
| 167 | 167 |
'Number missing in Row' => 'Nummer fehlt in Zeile', |
| 168 | 168 |
'Oct' => 'Okt', |
| 169 | 169 |
'October' => 'Oktober', |
| 170 |
'On Hand' => 'Auf Lager', |
|
| 170 | 171 |
'OpenDocument/OASIS' => 'OpenDocument/OASIS', |
| 171 | 172 |
'Order Date missing!' => 'Auftragsdatum fehlt!', |
| 172 | 173 |
'Order Number missing!' => 'Auftragsnummer fehlt!', |
| locale/de/do | ||
|---|---|---|
| 172 | 172 |
'Number missing in Row' => 'Nummer fehlt in Zeile', |
| 173 | 173 |
'Oct' => 'Okt', |
| 174 | 174 |
'October' => 'Oktober', |
| 175 |
'On Hand' => 'Auf Lager', |
|
| 175 | 176 |
'Open' => 'Offen', |
| 176 | 177 |
'OpenDocument/OASIS' => 'OpenDocument/OASIS', |
| 177 | 178 |
'Order' => 'Auftrag', |
| locale/de/io | ||
|---|---|---|
| 144 | 144 |
'Number missing in Row' => 'Nummer fehlt in Zeile', |
| 145 | 145 |
'Oct' => 'Okt', |
| 146 | 146 |
'October' => 'Oktober', |
| 147 |
'On Hand' => 'Auf Lager', |
|
| 147 | 148 |
'OpenDocument/OASIS' => 'OpenDocument/OASIS', |
| 148 | 149 |
'Order Date missing!' => 'Auftragsdatum fehlt!', |
| 149 | 150 |
'Order Number missing!' => 'Auftragsnummer fehlt!', |
| locale/de/ir | ||
|---|---|---|
| 183 | 183 |
'Number missing in Row' => 'Nummer fehlt in Zeile', |
| 184 | 184 |
'Oct' => 'Okt', |
| 185 | 185 |
'October' => 'Oktober', |
| 186 |
'On Hand' => 'Auf Lager', |
|
| 186 | 187 |
'OpenDocument/OASIS' => 'OpenDocument/OASIS', |
| 187 | 188 |
'Order Date' => 'Auftragsdatum', |
| 188 | 189 |
'Order Date missing!' => 'Auftragsdatum fehlt!', |
| locale/de/is | ||
|---|---|---|
| 200 | 200 |
'Number missing in Row' => 'Nummer fehlt in Zeile', |
| 201 | 201 |
'Oct' => 'Okt', |
| 202 | 202 |
'October' => 'Oktober', |
| 203 |
'On Hand' => 'Auf Lager', |
|
| 203 | 204 |
'OpenDocument/OASIS' => 'OpenDocument/OASIS', |
| 204 | 205 |
'Order' => 'Auftrag', |
| 205 | 206 |
'Order Date' => 'Auftragsdatum', |
| locale/de/login | ||
|---|---|---|
| 219 | 219 |
'Number missing in Row' => 'Nummer fehlt in Zeile', |
| 220 | 220 |
'Oct' => 'Okt', |
| 221 | 221 |
'October' => 'Oktober', |
| 222 |
'On Hand' => 'Auf Lager', |
|
| 222 | 223 |
'Only due follow-ups' => 'Nur fällige Wiedervorlagen', |
| 223 | 224 |
'Open' => 'Offen', |
| 224 | 225 |
'OpenDocument/OASIS' => 'OpenDocument/OASIS', |
| locale/de/oe | ||
|---|---|---|
| 200 | 200 |
'Number missing in Row' => 'Nummer fehlt in Zeile', |
| 201 | 201 |
'Oct' => 'Okt', |
| 202 | 202 |
'October' => 'Oktober', |
| 203 |
'On Hand' => 'Auf Lager', |
|
| 203 | 204 |
'Open' => 'Offen', |
| 204 | 205 |
'OpenDocument/OASIS' => 'OpenDocument/OASIS', |
| 205 | 206 |
'Order' => 'Auftrag', |
| locale/de/todo | ||
|---|---|---|
| 216 | 216 |
'Number missing in Row' => 'Nummer fehlt in Zeile', |
| 217 | 217 |
'Oct' => 'Okt', |
| 218 | 218 |
'October' => 'Oktober', |
| 219 |
'On Hand' => 'Auf Lager', |
|
| 219 | 220 |
'Only due follow-ups' => 'Nur fällige Wiedervorlagen', |
| 220 | 221 |
'Open' => 'Offen', |
| 221 | 222 |
'OpenDocument/OASIS' => 'OpenDocument/OASIS', |
Auch abrufbar als: Unified diff
Lagerbestandanzeige in OE Masken