Revision 07b34c6d
Von Stephan Köhler vor mehr als 19 Jahren hinzugefügt
| SL/IC.pm | ||
|---|---|---|
|
$ordwhere .= " AND lower(oi.description) LIKE '$var'";
|
||
|
}
|
||
|
|
||
|
$flds = qq|p.id, p.partnumber, oi.description, '' AS serialnumber,
|
||
|
$flds = qq|p.id, p.partnumber, oi.description, oi.serialnumber AS serialnumber,
|
||
|
oi.qty AS onhand, oi.unit, p.bin, oi.sellprice,
|
||
|
p.listprice, p.lastcost, p.rop, p.weight,
|
||
|
p.priceupdate, p.image, p.drawing, p.microfiche,
|
||
| ... | ... | |
|
}
|
||
|
|
||
|
if ($form->{onorder}) {
|
||
|
$flds = qq|p.id, p.partnumber, oi.description, '' AS serialnumber,
|
||
|
$flds = qq|p.id, p.partnumber, oi.description, oi.serialnumber AS serialnumber,
|
||
|
oi.qty * -1 AS onhand, oi.unit, p.bin, oi.sellprice,
|
||
|
p.listprice, p.lastcost, p.rop, p.weight,
|
||
|
p.priceupdate, p.image, p.drawing, p.microfiche,
|
||
| ... | ... | |
|
$quowhere .= " AND lower(oi.description) LIKE '$var'";
|
||
|
}
|
||
|
|
||
|
$flds = qq|p.id, p.partnumber, oi.description, '' AS serialnumber,
|
||
|
$flds = qq|p.id, p.partnumber, oi.description, oi.serialnumber AS serialnumber,
|
||
|
oi.qty AS onhand, oi.unit, p.bin, oi.sellprice,
|
||
|
p.listprice, p.lastcost, p.rop, p.weight,
|
||
|
p.priceupdate, p.image, p.drawing, p.microfiche,
|
||
| ... | ... | |
|
}
|
||
|
|
||
|
if ($form->{rfq}) {
|
||
|
$flds = qq|p.id, p.partnumber, oi.description, '' AS serialnumber,
|
||
|
$flds = qq|p.id, p.partnumber, oi.description, oi.serialnumber AS serialnumber,
|
||
|
oi.qty * -1 AS onhand, oi.unit, p.bin, oi.sellprice,
|
||
|
p.listprice, p.lastcost, p.rop, p.weight,
|
||
|
p.priceupdate, p.image, p.drawing, p.microfiche,
|
||
Auch abrufbar als: Unified diff
Merge von 683 aus unstable: Bugfix Angebote/Auftraege
-Beim Suchen nach Seriennummern konnte nicht in Angeboten und Auftraegen gesucht werden