Revision fafa0ca2
Von Jan Büren vor mehr als 3 Jahren hinzugefügt
SL/IC.pm | ||
---|---|---|
524 | 524 |
|
525 | 525 |
# simple search for assemblies by items used in assemblies |
526 | 526 |
if ($form->{bom} eq '2' && $form->{l_assembly}) { |
527 |
# assembly_qty is the column name |
|
528 |
$form->{l_assembly_qty} = 1; |
|
527 | 529 |
# nuke where clause and bind vars |
528 | 530 |
$where_clause = ' 1=1 AND p.id in (SELECT id from assembly where parts_id IN ' . |
529 | 531 |
' (select id from parts where 1=1'; |
... | ... | |
563 | 565 |
my @assemblies; |
564 | 566 |
if ($form->{l_assembly} && $form->{bom}) { |
565 | 567 |
$query = |
566 |
qq|SELECT p.id, p.partnumber, p.description, a.qty AS onhand,
|
|
568 |
qq|SELECT p.id, p.partnumber, p.description, a.qty AS assembly_qty,
|
|
567 | 569 |
p.unit, p.notes, p.itime::DATE as insertdate, |
568 | 570 |
p.sellprice, p.listprice, p.lastcost, |
569 | 571 |
p.rop, p.weight, |
bin/mozilla/ic.pl | ||
---|---|---|
185 | 185 |
'microfiche' => { 'text' => $locale->text('Microfiche'), }, |
186 | 186 |
'name' => { 'text' => $locale->text('Name'), }, |
187 | 187 |
'onhand' => { 'text' => $locale->text('Stocked Qty'), }, |
188 |
'assembly_qty' => { 'text' => $locale->text('Assembly Item Qty'), }, |
|
188 | 189 |
'ordnumber' => { 'text' => $locale->text('Order Number'), }, |
189 | 190 |
'partnumber' => { 'text' => $locale->text('Part Number'), }, |
190 | 191 |
'partsgroup' => { 'text' => $locale->text('Partsgroup'), }, |
... | ... | |
268 | 269 |
obsolete => $locale->text('Obsolete'), |
269 | 270 |
orphaned => $locale->text('Orphaned'), |
270 | 271 |
onhand => $locale->text('On Hand'), |
272 |
assembly_qty => $locale->text('Assembly Item Qty'), |
|
271 | 273 |
short => $locale->text('Short'), |
272 | 274 |
onorder => $locale->text('On Order'), |
273 | 275 |
ordered => $locale->text('Ordered'), |
... | ... | |
389 | 391 |
|
390 | 392 |
my @columns = qw( |
391 | 393 |
partnumber type_and_classific description notes partsgroup warehouse bin |
392 |
make model onhand rop soldtotal unit listprice |
|
394 |
make model assembly_qty onhand rop soldtotal unit listprice
|
|
393 | 395 |
linetotallistprice sellprice linetotalsellprice lastcost assembly_lastcost linetotallastcost |
394 | 396 |
priceupdate weight image drawing microfiche invnumber ordnumber quonumber |
395 | 397 |
transdate name serialnumber deliverydate ean projectnumber projectdescription |
... | ... | |
418 | 420 |
|
419 | 421 |
%column_defs = (%column_defs, %column_defs_cvars, %column_defs_pricegroups); |
420 | 422 |
map { $column_defs{$_}->{visible} ||= $form->{"l_$_"} ? 1 : 0 } @columns; |
421 |
map { $column_defs{$_}->{align} = 'right' } qw(onhand sellprice listprice lastcost assembly_lastcost linetotalsellprice linetotallastcost linetotallistprice rop weight soldtotal shop), @pricegroup_columns; |
|
423 |
map { $column_defs{$_}->{align} = 'right' } qw(assembly_qty onhand sellprice listprice lastcost assembly_lastcost linetotalsellprice linetotallastcost linetotallistprice rop weight soldtotal shop), @pricegroup_columns;
|
|
422 | 424 |
|
423 | 425 |
my @hidden_variables = ( |
424 | 426 |
qw(l_subtotal l_linetotal searchitems itemstatus bom l_pricegroups insertdatefrom insertdateto), |
locale/de/all | ||
---|---|---|
351 | 351 |
'Assemblies' => 'Erzeugnisse', |
352 | 352 |
'Assembly' => 'Erzeugnis', |
353 | 353 |
'Assembly (typeabbreviation)' => 'E', |
354 |
'Assembly Item Qty' => 'Menge für Erzeugnis', |
|
354 | 355 |
'Assembly Last Cost' => 'Erzeugnis-Einkaufspreis', |
355 | 356 |
'Assembly Number missing!' => 'Erzeugnisnummer fehlt!', |
356 | 357 |
'Assembly creation transfers services' => 'Erzeugnis fertigen berücksichtigt Dienstleistungen', |
locale/en/all | ||
---|---|---|
351 | 351 |
'Assemblies' => '', |
352 | 352 |
'Assembly' => '', |
353 | 353 |
'Assembly (typeabbreviation)' => 'A', |
354 |
'Assembly Item Qty' => '', |
|
354 | 355 |
'Assembly Last Cost' => '', |
355 | 356 |
'Assembly Number missing!' => '', |
356 | 357 |
'Assembly creation transfers services' => '', |
Auch abrufbar als: Unified diff
all_parts: Lagermenge des Artikels und benötigte Menge für Erz. anzeigen
Die benötigte Menge für das Erzeugnis wurde einfach in onhand gepackt.
Das verwirrt natürlich wenn man sowohl die Lagermenge als auch die
benötigte Menge fürs Erzeugen in dem Bericht ausgeben möchte.