Revision dceb9f20
Von Niclas Zimmermann vor mehr als 12 Jahren hinzugefügt
| SL/IS.pm | ||
|---|---|---|
|
WHERE accno = ?)
|
||
|
AND startdate <= ?
|
||
|
ORDER BY startdate DESC LIMIT 1),
|
||
|
(SELECT taxkey_id FROM chart WHERE accno = ?), ?,
|
||
|
(SELECT taxkey_id
|
||
|
FROM taxkeys
|
||
|
WHERE chart_id= (SELECT id
|
||
|
FROM chart
|
||
|
WHERE accno = ?)
|
||
|
AND startdate <= ?
|
||
|
ORDER BY startdate DESC LIMIT 1),
|
||
|
?,
|
||
|
(SELECT link FROM chart WHERE accno = ?))|;
|
||
|
@values = (conv_i($trans_id), $accno, $form->{amount}{$trans_id}{$accno}, conv_date($form->{invdate}), $accno, conv_date($taxdate), $accno, conv_i($project_id), $accno);
|
||
|
@values = (conv_i($trans_id), $accno, $form->{amount}{$trans_id}{$accno}, conv_date($form->{invdate}), $accno, conv_date($taxdate), $accno, conv_date($taxdate), conv_i($project_id), $accno);
|
||
|
do_query($form, $dbh, $query, @values);
|
||
|
$form->{amount}{$trans_id}{$accno} = 0;
|
||
|
}
|
||
| ... | ... | |
|
WHERE accno = ?)
|
||
|
AND startdate <= ?
|
||
|
ORDER BY startdate DESC LIMIT 1),
|
||
|
(SELECT taxkey_id FROM chart WHERE accno = ?), ?,
|
||
|
(SELECT taxkey_id
|
||
|
FROM taxkeys
|
||
|
WHERE chart_id= (SELECT id
|
||
|
FROM chart
|
||
|
WHERE accno = ?)
|
||
|
AND startdate <= ?
|
||
|
ORDER BY startdate DESC LIMIT 1),
|
||
|
?,
|
||
|
(SELECT link FROM chart WHERE accno = ?))|;
|
||
|
@values = (conv_i($trans_id), $accno, $form->{amount}{$trans_id}{$accno}, conv_date($form->{invdate}), $accno, conv_date($taxdate), $accno, conv_i($project_id), $accno);
|
||
|
@values = (conv_i($trans_id), $accno, $form->{amount}{$trans_id}{$accno}, conv_date($form->{invdate}), $accno, conv_date($taxdate), $accno, conv_date($taxdate), conv_i($project_id), $accno);
|
||
|
do_query($form, $dbh, $query, @values);
|
||
|
}
|
||
|
}
|
||
| ... | ... | |
|
WHERE accno = ?)
|
||
|
AND startdate <= ?
|
||
|
ORDER BY startdate DESC LIMIT 1),
|
||
|
(SELECT taxkey_id FROM chart WHERE accno = ?), ?,
|
||
|
(SELECT taxkey_id
|
||
|
FROM taxkeys
|
||
|
WHERE chart_id= (SELECT id
|
||
|
FROM chart
|
||
|
WHERE accno = ?)
|
||
|
AND startdate <= ?
|
||
|
ORDER BY startdate DESC LIMIT 1),
|
||
|
?,
|
||
|
(SELECT link FROM chart WHERE accno = ?))|;
|
||
|
@values = (conv_i($form->{"id"}), $form->{AR}, $amount, $form->{"datepaid_$i"}, $form->{AR}, conv_date($taxdate), $form->{AR}, $project_id, $form->{AR});
|
||
|
@values = (conv_i($form->{"id"}), $form->{AR}, $amount, $form->{"datepaid_$i"}, $form->{AR}, conv_date($taxdate), $form->{AR}, conv_date($taxdate), $project_id, $form->{AR});
|
||
|
do_query($form, $dbh, $query, @values);
|
||
|
}
|
||
|
|
||
| ... | ... | |
|
WHERE accno = ?)
|
||
|
AND startdate <= ?
|
||
|
ORDER BY startdate DESC LIMIT 1),
|
||
|
(SELECT taxkey_id FROM chart WHERE accno = ?), ?,
|
||
|
(SELECT taxkey_id
|
||
|
FROM taxkeys
|
||
|
WHERE chart_id= (SELECT id
|
||
|
FROM chart
|
||
|
WHERE accno = ?)
|
||
|
AND startdate <= ?
|
||
|
ORDER BY startdate DESC LIMIT 1),
|
||
|
?,
|
||
|
(SELECT link FROM chart WHERE accno = ?))|;
|
||
|
@values = (conv_i($form->{"id"}), $accno, $form->{"paid_$i"}, $form->{"datepaid_$i"},
|
||
|
$gldate, $form->{"source_$i"}, $form->{"memo_$i"}, $accno, conv_date($taxdate), $accno, $project_id, $accno);
|
||
|
$gldate, $form->{"source_$i"}, $form->{"memo_$i"}, $accno, conv_date($taxdate), $accno, conv_date($taxdate), $project_id, $accno);
|
||
|
do_query($form, $dbh, $query, @values);
|
||
|
|
||
|
# exchangerate difference
|
||
| ... | ... | |
|
WHERE accno = ?)
|
||
|
AND startdate <= ?
|
||
|
ORDER BY startdate DESC LIMIT 1),
|
||
|
(SELECT taxkey_id FROM chart WHERE accno = ?), ?,
|
||
|
(SELECT taxkey_id
|
||
|
FROM taxkeys
|
||
|
WHERE chart_id= (SELECT id
|
||
|
FROM chart
|
||
|
WHERE accno = ?)
|
||
|
AND startdate <= ?
|
||
|
ORDER BY startdate DESC LIMIT 1),
|
||
|
?,
|
||
|
(SELECT link FROM chart WHERE accno = ?))|;
|
||
|
@values = (conv_i($form->{"id"}), $accno, $form->{fx}{$accno}{$transdate}, conv_date($transdate), $accno, conv_date($taxdate), $accno, conv_i($project_id), $accno);
|
||
|
@values = (conv_i($form->{"id"}), $accno, $form->{fx}{$accno}{$transdate}, conv_date($transdate), $accno, conv_date($taxdate), $accno, conv_date($taxdate), conv_i($project_id), $accno);
|
||
|
do_query($form, $dbh, $query, @values);
|
||
|
}
|
||
|
}
|
||
Auch abrufbar als: Unified diff
Bugfix von chart_link und tax_id in acc_trans
Es gab noch einige Bugs bei VK- und EK-Rechnungen.
1. Der Steuerschlüssel wurde nicht richtig geschrieben.
2. tax_id war noch an einigen Stellen NULL.