Revision 0732e588
Von Philip Reetz vor etwa 19 Jahren hinzugefügt
| SL/IC.pm | ||
|---|---|---|
| 1041 | 1041 |
$ordwhere .= " AND lower(oi.description) LIKE '$var'"; |
| 1042 | 1042 |
} |
| 1043 | 1043 |
|
| 1044 |
$flds = qq|p.id, p.partnumber, oi.description, '' AS serialnumber,
|
|
| 1044 |
$flds = qq|p.id, p.partnumber, oi.description, oi.serialnumber AS serialnumber,
|
|
| 1045 | 1045 |
oi.qty AS onhand, oi.unit, p.bin, oi.sellprice, |
| 1046 | 1046 |
p.listprice, p.lastcost, p.rop, p.weight, |
| 1047 | 1047 |
p.priceupdate, p.image, p.drawing, p.microfiche, |
| ... | ... | |
| 1067 | 1067 |
} |
| 1068 | 1068 |
|
| 1069 | 1069 |
if ($form->{onorder}) {
|
| 1070 |
$flds = qq|p.id, p.partnumber, oi.description, '' AS serialnumber,
|
|
| 1070 |
$flds = qq|p.id, p.partnumber, oi.description, oi.serialnumber AS serialnumber,
|
|
| 1071 | 1071 |
oi.qty * -1 AS onhand, oi.unit, p.bin, oi.sellprice, |
| 1072 | 1072 |
p.listprice, p.lastcost, p.rop, p.weight, |
| 1073 | 1073 |
p.priceupdate, p.image, p.drawing, p.microfiche, |
| ... | ... | |
| 1104 | 1104 |
$quowhere .= " AND lower(oi.description) LIKE '$var'"; |
| 1105 | 1105 |
} |
| 1106 | 1106 |
|
| 1107 |
$flds = qq|p.id, p.partnumber, oi.description, '' AS serialnumber,
|
|
| 1107 |
$flds = qq|p.id, p.partnumber, oi.description, oi.serialnumber AS serialnumber,
|
|
| 1108 | 1108 |
oi.qty AS onhand, oi.unit, p.bin, oi.sellprice, |
| 1109 | 1109 |
p.listprice, p.lastcost, p.rop, p.weight, |
| 1110 | 1110 |
p.priceupdate, p.image, p.drawing, p.microfiche, |
| ... | ... | |
| 1130 | 1130 |
} |
| 1131 | 1131 |
|
| 1132 | 1132 |
if ($form->{rfq}) {
|
| 1133 |
$flds = qq|p.id, p.partnumber, oi.description, '' AS serialnumber,
|
|
| 1133 |
$flds = qq|p.id, p.partnumber, oi.description, oi.serialnumber AS serialnumber,
|
|
| 1134 | 1134 |
oi.qty * -1 AS onhand, oi.unit, p.bin, oi.sellprice, |
| 1135 | 1135 |
p.listprice, p.lastcost, p.rop, p.weight, |
| 1136 | 1136 |
p.priceupdate, p.image, p.drawing, p.microfiche, |
Auch abrufbar als: Unified diff
Beim Suchen nach Seriennummern konnte nicht in Angeboten und Auftraegen gesucht werden