Revision cc3a0a33
Von Sven Schöling vor mehr als 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