Revision dad628a3
Von Moritz Bunkus vor etwa 18 Jahren hinzugefügt
| SL/IR.pm | ||
|---|---|---|
|
VALUES ($form->{id}, $form->{"id_$i"},
|
||
|
'$form->{"description_$i"}', | . ($form->{"qty_$i"} * -1) . qq|, | . ($baseqty * -1) . qq|,
|
||
|
$form->{"sellprice_$i"}, $fxsellprice, $allocated,
|
||
|
'$form->{"unit_$i"}', $deliverydate, | . conv_i($form->{"project_id_$i"}) . qq|,
|
||
|
'$form->{"unit_$i"}', $deliverydate, | . conv_i($form->{"project_id_$i"}, 'NULL') . qq|,
|
||
|
'$form->{"serialnumber_$i"}')|;
|
||
|
$dbh->do($query) || $form->dberror($query);
|
||
|
}
|
||
| SL/IS.pm | ||
|---|---|---|
|
'$form->{"description_$i"}', '$form->{"longdescription_$i"}', $form->{"qty_$i"},
|
||
|
$form->{"sellprice_$i"}, $fxsellprice,
|
||
|
$form->{"discount_$i"}, $allocated, 'f',
|
||
|
'$form->{"unit_$i"}', $deliverydate, | . conv_i($form->{"project_id_$i"}) . qq|,
|
||
|
'$form->{"unit_$i"}', $deliverydate, | . conv_i($form->{"project_id_$i"}, 'NULL') . qq|,
|
||
|
'$form->{"serialnumber_$i"}', '$pricegroup_id',
|
||
|
'$form->{"ordnumber_$i"}', '$form->{"transdate_$i"}', '$form->{"cusordnumber_$i"}', $baseqty, '$subtotal')|;
|
||
|
$dbh->do($query) || $form->dberror($query);
|
||
Auch abrufbar als: Unified diff
Wenn bei Rechnungen bei einer Zeile kein Projekt ausgewählt ist, dann richtigen Wert für project_id im Query benutzen.