Revision e2305bab
Von Philip Reetz vor fast 17 Jahren hinzugefügt
| SL/GL.pm | ||
|---|---|---|
|
my ($null, $department_id) = split(/--/, $form->{department});
|
||
|
$department_id *= 1;
|
||
|
|
||
|
$form->{ob_transaction} *= 1;
|
||
|
$form->{cb_transaction} *= 1;
|
||
|
|
||
|
$query =
|
||
|
qq|UPDATE gl SET
|
||
|
reference = ?, description = ?, notes = ?,
|
||
|
transdate = ?, department_id = ?, taxincluded = ?,
|
||
|
storno = ?, storno_id = ?
|
||
|
storno = ?, storno_id = ?, ob_transaction = ?, cb_transaction = ?
|
||
|
WHERE id = ?|;
|
||
|
|
||
|
@values = ($form->{reference}, $form->{description}, $form->{notes},
|
||
|
conv_date($form->{transdate}), $department_id, $form->{taxincluded},
|
||
|
$form->{storno} ? 't' : 'f', conv_i($form->{storno_id}),
|
||
|
$form->{storno} ? 't' : 'f', conv_i($form->{storno_id}), $form->{ob_transaction} ? 't' : 'f', $form->{cb_transaction} ? 't' : 'f',
|
||
|
conv_i($form->{id}));
|
||
|
do_query($form, $dbh, $query, @values);
|
||
|
|
||
| ... | ... | |
|
if ($amount != 0) {
|
||
|
$query =
|
||
|
qq|INSERT INTO acc_trans (trans_id, chart_id, amount, transdate,
|
||
|
source, memo, project_id, taxkey)
|
||
|
source, memo, project_id, taxkey, ob_transaction, cb_transaction)
|
||
|
VALUES (?, (SELECT id FROM chart WHERE accno = ?),
|
||
|
?, ?, ?, ?, ?, ?)|;
|
||
|
?, ?, ?, ?, ?, ?, ?, ?)|;
|
||
|
@values = (conv_i($form->{id}), $accno, $amount, conv_date($form->{transdate}),
|
||
|
$form->{"source_$i"}, $form->{"memo_$i"}, $project_id, $taxkey);
|
||
|
$form->{"source_$i"}, $form->{"memo_$i"}, $project_id, $taxkey, $form->{ob_transaction} ? 't' : 'f', $form->{cb_transaction} ? 't' : 'f');
|
||
|
do_query($form, $dbh, $query, @values);
|
||
|
}
|
||
|
|
||
| ... | ... | |
|
if ($form->{id}) {
|
||
|
$query =
|
||
|
qq|SELECT g.reference, g.description, g.notes, g.transdate, g.storno, g.storno_id,
|
||
|
d.description AS department, e.name AS employee, g.taxincluded, g.gldate
|
||
|
d.description AS department, e.name AS employee, g.taxincluded, g.gldate,
|
||
|
g.ob_transaction, g.cb_transaction
|
||
|
FROM gl g
|
||
|
LEFT JOIN department d ON (d.id = g.department_id)
|
||
|
LEFT JOIN employee e ON (e.id = g.employee_id)
|
||
| bin/mozilla/gl.pl | ||
|---|---|---|
|
|
||
|
$show_details_checked = "checked" if $form->{show_details};
|
||
|
|
||
|
$ob_transaction_checked = "checked" if $form->{ob_transaction};
|
||
|
$cb_transaction_checked = "checked" if $form->{cb_transaction};
|
||
|
|
||
|
# $locale->text('Add General Ledger Transaction')
|
||
|
# $locale->text('Edit General Ledger Transaction')
|
||
|
|
||
| ... | ... | |
|
</tr>|;
|
||
|
}
|
||
|
|
||
|
print qq|<tr>
|
||
|
print qq|
|
||
|
<tr>
|
||
|
<tr><td colspan=4><table><tr>
|
||
|
<td>
|
||
|
| . $locale->text('OB Transaction') . qq|<input type="checkbox" name="ob_transaction" value="1" $ob_transaction_checked>
|
||
|
</td>
|
||
|
<td>
|
||
|
| . $locale->text('CB Transaction') . qq|<input type="checkbox" name="cb_transaction" value="1" $cb_transaction_checked>
|
||
|
</td>
|
||
|
</tr></table></td></tr>
|
||
|
<tr>
|
||
|
<td width="1%" align="right" nowrap>| . $locale->text('Show details') . qq|</td>
|
||
|
<td width="1%"><input type="checkbox" onclick="show_form_details();" name="show_details" value="1" $show_details_checked></td>
|
||
|
</tr>|;
|
||
| ... | ... | |
|
. qq|"> |;
|
||
|
|
||
|
} else {
|
||
|
if ($transdate > $closedto) {
|
||
|
print qq|
|
||
|
<input class=submit type=submit name=action id=update_button value="| . $locale->text('Update') . qq|">
|
||
|
<input class=submit type=submit name=action value="| . $locale->text('Post') . qq|">|;
|
||
|
}
|
||
|
}
|
||
|
|
||
|
print "
|
||
| locale/de/all | ||
|---|---|---|
|
'Business deleted!' => 'Firma gel?scht.',
|
||
|
'Business saved!' => 'Firma gespeichert.',
|
||
|
'CANCELED' => 'Storniert',
|
||
|
'CB Transaction' => 'SB-Buchung',
|
||
|
'CSV export -- options' => 'CSV-Export -- Optionen',
|
||
|
'Calculate' => 'Berechnen',
|
||
|
'Cancel' => 'Abbrechen',
|
||
| ... | ... | |
|
'Number of new bins' => 'Anzahl neuer Lagerplätze',
|
||
|
'Number pages' => 'Seiten nummerieren',
|
||
|
'Number variables: \'PRECISION=n\' forces numbers to be shown with exactly n decimal places.' => 'Zahlenvariablen: Mit \'PRECISION=n\' erzwingt man, dass Zahlen mit n Nachkommastellen formatiert werden.',
|
||
|
'OB Transaction' => 'EB-Buchung',
|
||
|
'OBE-Export erfolgreich!' => 'OBE-Export erfolgreich!',
|
||
|
'Obsolete' => 'Ung?ltig',
|
||
|
'Oct' => 'Okt',
|
||
| locale/de/gl | ||
|---|---|---|
|
'Buchungsdatum' => 'Buchungsdatum',
|
||
|
'Buchungsnummer' => 'Buchungsnummer',
|
||
|
'CANCELED' => 'Storniert',
|
||
|
'CB Transaction' => 'SB-Buchung',
|
||
|
'CSV export -- options' => 'CSV-Export -- Optionen',
|
||
|
'Cancel Accounts Receivables Transaction' => 'Debitorenbuchung stornieren',
|
||
|
'Cannot delete transaction!' => 'Buchung kann nicht gel?scht werden!',
|
||
| ... | ... | |
|
'Notes' => 'Bemerkungen',
|
||
|
'Nov' => 'Nov',
|
||
|
'November' => 'November',
|
||
|
'OB Transaction' => 'EB-Buchung',
|
||
|
'Oct' => 'Okt',
|
||
|
'October' => 'Oktober',
|
||
|
'Others' => 'Andere',
|
||
| sql/Pg-upgrade2/cb_ob_transaction.sql | ||
|---|---|---|
|
-- @tag: cb_ob_transaction
|
||
|
-- @description: Spalten für Eröffnungs- und Schlussbilanzbuchungen
|
||
|
-- @depends: release_2_4_2
|
||
|
ALTER TABLE gl ADD COLUMN ob_transaction boolean;
|
||
|
ALTER TABLE gl ADD COLUMN cb_transaction boolean;
|
||
|
ALTER TABLE acc_trans ADD COLUMN ob_transaction boolean;
|
||
|
ALTER TABLE acc_trans ADD COLUMN cb_transaction boolean;
|
||
Auch abrufbar als: Unified diff
Markieren von Dialogbuchungen als Eroeffnungs- oder Schlussbilanzbuchungen