Revision 97eaf9e0
Von Tamino Steinert vor etwa 1 Jahr hinzugefügt
| SL/DO.pm | ||
|---|---|---|
| 273 | 273 |
|
| 274 | 274 |
$form->{DO} = selectall_hashref_query($form, $dbh, $query, @values);
|
| 275 | 275 |
|
| 276 |
my $record_type = $vc eq 'customer' ? 'sales_order' : 'purchase_order'; |
|
| 276 | 277 |
if (scalar @{ $form->{DO} }) {
|
| 277 | 278 |
$query = |
| 278 | 279 |
qq|SELECT id |
| 279 | 280 |
FROM oe |
| 280 |
WHERE NOT COALESCE(quotation, FALSE) |
|
| 281 |
AND (ordnumber = ?) |
|
| 282 |
AND (COALESCE(${vc}_id, 0) != 0)|;
|
|
| 281 |
WHERE (record_type = '$record_type' |
|
| 282 |
AND (ordnumber = ?)|; |
|
| 283 | 283 |
|
| 284 | 284 |
my $sth = prepare_query($form, $dbh, $query); |
| 285 | 285 |
|
Auch abrufbar als: Unified diff
Angebotsflag aus Datenbankzugriffen entfernt