Revision bf915098
Von Moritz Bunkus vor fast 18 Jahren hinzugefügt
| SL/IC.pm | ||
|---|---|---|
| 1145 | 1145 |
p.priceupdate, p.image, p.drawing, p.microfiche, |
| 1146 | 1146 |
pg.partsgroup, |
| 1147 | 1147 |
'' AS invnumber, o.ordnumber, o.quonumber, oi.trans_id, |
| 1148 |
ct.name|; |
|
| 1148 |
ct.name, NULL AS deliverydate|;
|
|
| 1149 | 1149 |
|
| 1150 | 1150 |
if ($form->{ordered}) {
|
| 1151 | 1151 |
$query .= qq|$union |
| ... | ... | |
| 1172 | 1172 |
p.priceupdate, p.image, p.drawing, p.microfiche, |
| 1173 | 1173 |
pg.partsgroup, |
| 1174 | 1174 |
'' AS invnumber, o.ordnumber, o.quonumber, oi.trans_id, |
| 1175 |
ct.name|; |
|
| 1175 |
ct.name, NULL AS deliverydate|;
|
|
| 1176 | 1176 |
|
| 1177 | 1177 |
$query .= qq|$union |
| 1178 | 1178 |
SELECT $flds, 'oe' AS module, 'purchase_order' AS type, |
| ... | ... | |
| 1210 | 1210 |
p.priceupdate, p.image, p.drawing, p.microfiche, |
| 1211 | 1211 |
pg.partsgroup, |
| 1212 | 1212 |
'' AS invnumber, o.ordnumber, o.quonumber, oi.trans_id, |
| 1213 |
ct.name|; |
|
| 1213 |
ct.name, NULL AS deliverydate|;
|
|
| 1214 | 1214 |
|
| 1215 | 1215 |
if ($form->{quoted}) {
|
| 1216 | 1216 |
$query .= qq|$union |
| ... | ... | |
| 1237 | 1237 |
p.priceupdate, p.image, p.drawing, p.microfiche, |
| 1238 | 1238 |
pg.partsgroup, |
| 1239 | 1239 |
'' AS invnumber, o.ordnumber, o.quonumber, oi.trans_id, |
| 1240 |
ct.name|; |
|
| 1240 |
ct.name, NULL AS deliverydate|;
|
|
| 1241 | 1241 |
|
| 1242 | 1242 |
$query .= qq|$union |
| 1243 | 1243 |
SELECT $flds, 'oe' AS module, 'request_quotation' AS type, |
Auch abrufbar als: Unified diff
Bei UNIONs müssen immer die gleichen Spaltenanzahlen herauskommen. Fix für ein Problem, das in 1309 hinzukam; Bug 537.