Revision 1c77d03f
Von Tamino Steinert vor mehr als 1 Jahr hinzugefügt
| SL/DO.pm | ||
|---|---|---|
|
|
||
|
$form->{DO} = selectall_hashref_query($form, $dbh, $query, @values);
|
||
|
|
||
|
my $record_type = $vc eq 'customer' ? 'sales_order' : 'purchase_order';
|
||
|
if (scalar @{ $form->{DO} }) {
|
||
|
$query =
|
||
|
qq|SELECT id
|
||
|
FROM oe
|
||
|
WHERE NOT COALESCE(quotation, FALSE)
|
||
|
AND (ordnumber = ?)
|
||
|
AND (COALESCE(${vc}_id, 0) != 0)|;
|
||
|
WHERE (record_type = '$record_type'
|
||
|
AND (ordnumber = ?)|;
|
||
|
|
||
|
my $sth = prepare_query($form, $dbh, $query);
|
||
|
|
||
Auch abrufbar als: Unified diff
Angebotsflag/Intakeflag aus Datenbankzugriffen entfernt