use SL::CA;
use SL::Form;
use SL::User;
+use SL::USTVA;
+use CGI::Ajax;
+use CGI;
+
+use Data::Dumper;
1;
+require "bin/mozilla/common.pl";
+
# end of main
-sub add { &{"add_$form->{type}"} }
-sub edit { &{"edit_$form->{type}"} }
-sub save { &{"save_$form->{type}"} }
-sub delete { &{"delete_$form->{type}"} }
+sub add { call_sub("add_$form->{type}"); }
+sub delete { call_sub("delete_$form->{type}"); }
+sub save { call_sub("save_$form->{type}"); }
+sub edit { call_sub("edit_$form->{type}"); }
+sub continue { call_sub($form->{"nextsub"}); }
sub add_account {
$lxdebug->enter_sub();
AM->get_account(\%myconfig, \%$form);
$form->{callback} =
- "$form->{script}?action=list_account&path=$form->{path}&login=$form->{login}&password=$form->{password}"
+ "$form->{script}?action=list_account&login=$form->{login}&password=$form->{password}"
unless $form->{callback};
&account_header;
sub account_header {
$lxdebug->enter_sub();
+ if ( $form->{action} eq 'edit_account') {
+ $form->{account_exists} = '1';
+ }
+
$form->{title} = $locale->text("$form->{title} Account");
- $checked{ $form->{charttype} } = "checked";
- $checked{"$form->{category}_"} = "checked";
- $checked{CT_tax} = ($form->{CT_tax}) ? "" : "checked";
+ $form->{"$form->{charttype}_checked"} = "checked";
+ $form->{"$form->{category}_checked"} = "checked";
- $form->{description} =~ s/\"/"/g;
+ $form->{select_tax} = "";
+
+ my @tax_report_pos = USTVA->report_variables({
+ myconfig => \%myconfig,
+ form => $form,
+ type => '',
+ attribute => 'position',
+ calc => '',
+ });
if (@{ $form->{TAXKEY} }) {
- $form->{selecttaxkey} = "<option value=0>Keine Steuer 0%\n";
- foreach $item (@{ $form->{TAXKEY} }) {
- if ($item->{taxkey} == $form->{taxkey_id}) {
- $form->{selecttaxkey} .=
- "<option value=$item->{taxkey} selected>$item->{taxdescription}\n";
- } else {
- $form->{selecttaxkey} .=
- "<option value=$item->{taxkey}>$item->{taxdescription}\n";
+ foreach my $item (@{ $form->{TAXKEY} }) {
+ $item->{rate} = $item->{rate} * 100 . '%';
+ }
+
+ # Fill in empty row for new Taxkey
+ $newtaxkey_ref = {
+ id => '',
+ chart_id => '',
+ accno => '',
+ tax_id => '',
+ taxdescription => '',
+ rate => '',
+ taxkey_id => '',
+ pos_ustva => '',
+ startdate => '',
+ };
+
+ push @{ $form->{ACCOUNT_TAXKEYS} }, $newtaxkey_ref;
+
+ my $i = 0;
+ foreach my $taxkey_used (@{ $form->{ACCOUNT_TAXKEYS} } ) {
+
+ # Fill in a runningnumber
+ $form->{ACCOUNT_TAXKEYS}[$i]{runningnumber} = $i;
+
+ # Fill in the Taxkeys as select options
+ foreach my $item (@{ $form->{TAXKEY} }) {
+ if ($item->{id} == $taxkey_used->{tax_id}) {
+ $form->{ACCOUNT_TAXKEYS}[$i]{selecttaxkey} .=
+ qq|<option value="$item->{id}" selected="selected">|
+ . sprintf("%.2d", $item->{taxkey})
+ . qq|. $item->{taxdescription} ($item->{rate}) |
+ . $locale->text('Tax-o-matic Account')
+ . qq|: $item->{chart_accno}\n|;
+ }
+ else {
+ $form->{ACCOUNT_TAXKEYS}[$i]{selecttaxkey} .=
+ qq|<option value="$item->{id}">|
+ . sprintf("%.2d", $item->{taxkey})
+ . qq|. $item->{taxdescription} ($item->{rate}) |
+ . $locale->text('Tax-o-matic Account')
+ . qq|: $item->{chart_accno}\n|;
+ }
+
}
+
+ # Fill in the USTVA Numbers as select options
+ foreach my $item ( '', sort({ $a cmp $b } @tax_report_pos) ) {
+ if ($item eq ''){
+ $form->{ACCOUNT_TAXKEYS}[$i]{select_tax} .= qq|<option value="" selected="selected">-\n|;
+ }
+ elsif ( $item == $taxkey_used->{pos_ustva} ) {
+ $form->{ACCOUNT_TAXKEYS}[$i]{select_tax} .= qq|<option value="$item" selected="selected">$item\n|;
+ }
+ else {
+ $form->{ACCOUNT_TAXKEYS}[$i]{select_tax} .= qq|<option value="$item">$item\n|;
+ }
+
+ }
+ $i++;
}
}
- $taxkey = qq|
- <tr>
- <th align=right>| . $locale->text('Steuersatz') . qq|</th>
- <td><select name=taxkey_id>$form->{selecttaxkey}</select></td>
- <input type=hidden name=selecttaxkey value="$form->{selecttaxkey}">
- </tr>|;
-
- $form->{selectustva} = "<option>\n";
- %ustva = (48 => "Steuerfrei, Zeile 48",
- 51 => "Steuerpflichtig 16%, Zeile 51",
- 86 => "Steuerpflichtig 7%, Zeile 86",
- 91 => "Steuerfrei, Zeile 91",
- 97 => "Steuerpflichtig 16%, Zeile 97",
- 93 => "Steuerpflichtig 7%, Zeile 93",
- 94 => "Steuerpflichtig 16%, Zeile 94",
- 66 => "Vorsteuer, Zeile 66");
- foreach $item (sort({ $a <=> $b } keys %ustva)) {
- if ($item == $form->{pos_ustva}) {
- $form->{selectustva} .= "<option value=$item selected>$ustva{$item}\n";
- } else {
- $form->{selectustva} .= "<option value=$item>$ustva{$item}\n";
+ # Newaccount Folgekonto
+ if (@{ $form->{NEWACCOUNT} }) {
+ if (!$form->{new_chart_valid}) {
+ $form->{selectnewaccount} = qq|<option value=""> |. $locale->text('None') .q|</option>|;
}
+ foreach $item (@{ $form->{NEWACCOUNT} }) {
+ if ($item->{id} == $form->{new_chart_id}) {
+ $form->{selectnewaccount} .=
+ qq|<option value="$item->{id}" selected>$item->{accno}--$item->{description}</option>|;
+ } elsif (!$form->{new_chart_valid}) {
+ $form->{selectnewaccount} .=
+ qq|<option value="$item->{id}">$item->{accno}--$item->{description}</option>|;
+ }
+ }
}
- $ustva = qq|
- <tr>
- <th align=right>| . $locale->text('Umsatzsteuervoranmeldung') . qq|</th>
- <td><select name=pos_ustva>$form->{selectustva}</select></td>
- <input type=hidden name=selectustva value="$form->{selectustva}">
- </tr>|;
-
- $form->{selecteur} = "<option>\n";
+ $select_eur = q|<option value=""> |. $locale->text('None') .q|</option>\n|;
%eur = (1 => "Umsatzerlöse",
2 => "sonstige Erlöse",
3 => "Privatanteile",
31 => "Betriebliche Steuern");
foreach $item (sort({ $a <=> $b } keys(%eur))) {
if ($item == $form->{pos_eur}) {
- $form->{selecteur} .= "<option value=$item selected>$eur{$item}\n";
+ $select_eur .= qq|<option value=$item selected>|. sprintf("%.2d", $item) .qq|. $eur{$item}</option>\n|;
} else {
- $form->{selecteur} .= "<option value=$item>$eur{$item}\n";
+ $select_eur .= qq|<option value=$item>|. sprintf("%.2d", $item) .qq|. $eur{$item}</option>\n|;
}
}
- $eur = qq|
- <tr>
- <th align=right>| . $locale->text('EÜR') . qq|</th>
- <td><select name=pos_eur>$form->{selecteur}</select></td>
- <input type=hidden name=selecteur value="$form->{selecteur}">
- </tr>|;
-
- $form->{selectbwa} = "<option>\n";
+ $select_bwa = q|<option value=""> |. $locale->text('None') .q|</option>\n|;
%bwapos = (1 => 'Umsatzerlöse',
2 => 'Best.Verdg.FE/UE',
35 => 'Steuern Eink.u.Ertr.');
foreach $item (sort({ $a <=> $b } keys %bwapos)) {
if ($item == $form->{pos_bwa}) {
- $form->{selectbwa} .= "<option value=$item selected>$bwapos{$item}\n";
+ $select_bwa .= qq|<option value="$item" selected>|. sprintf("%.2d", $item) .qq|. $bwapos{$item}\n|;
} else {
- $form->{selectbwa} .= "<option value=$item>$bwapos{$item}\n";
+ $select_bwa .= qq|<option value="$item">|. sprintf("%.2d", $item) .qq|. $bwapos{$item}\n|;
}
}
- $bwa = qq|
- <tr>
- <th align=right>| . $locale->text('BWA') . qq|</th>
- <td><select name=pos_bwa>$form->{selectbwa}</select></td>
- <input type=hidden name=selectbwa value="$form->{selectbwa}">
- </tr>|;
-
- $form->{selectbilanz} = "<option>\n";
+# Wieder hinzugefügt zu evaluationszwecken (us) 09.03.2007
+ $select_bilanz = q|<option value=""> |. $locale->text('None') .q|</option>\n|;
foreach $item ((1, 2, 3, 4)) {
if ($item == $form->{pos_bilanz}) {
- $form->{selectbilanz} .= "<option value=$item selected>$item\n";
+ $select_bilanz .= qq|<option value=$item selected>|. sprintf("%.2d", $item) .qq|.\n|;
} else {
- $form->{selectbilanz} .= "<option value=$item>$item\n";
+ $select_bilanz .= qq|<option value=$item>|. sprintf("%.2d", $item) .qq|.\n|;
}
}
- $bilanz = qq|
- <tr>
- <th align=right>| . $locale->text('Bilanz') . qq|</th>
- <td><select name=pos_bilanz>$form->{selectbilanz}</select></td>
- <input type=hidden name=selectbilanz value="$form->{selectbilanz}">
- </tr>|;
-
- # this is for our parser only!
+ # this is for our parser only! Do not remove.
# type=submit $locale->text('Add Account')
# type=submit $locale->text('Edit Account')
+
+ $form->{type} = "account";
+
+ # preselections category
+
+ $select_category = q|<option value=""> |. $locale->text('None') .q|</option>\n|;
+
+ %category = (
+ 'A' => $locale->text('Asset'),
+ 'L' => $locale->text('Liability'),
+ 'Q' => $locale->text('Equity'),
+ 'I' => $locale->text('Revenue'),
+ 'E' => $locale->text('Expense'),
+ 'C' => $locale->text('Costs'),
+ );
+ foreach $item ( sort({ $a <=> $b } keys %category) ) {
+ if ($item eq $form->{category}) {
+ $select_category .= qq|<option value="$item" selected="selected">$category{$item} (|. sprintf("%s", $item) .qq|)\n|;
+ } else {
+ $select_category .= qq|<option value="$item">$category{$item} (|. sprintf("%s", $item) .qq|)\n|;
+ }
- $form->header;
-
- print qq|
-<body>
-
-<form method=post action=$form->{script}>
-
-<input type=hidden name=id value=$form->{id}>
-<input type=hidden name=type value=account>
+ }
+
+ # preselection chart type
+ my $select_charttype = q{};
-<input type=hidden name=inventory_accno_id value=$form->{inventory_accno_id}>
-<input type=hidden name=income_accno_id value=$form->{income_accno_id}>
-<input type=hidden name=expense_accno_id value=$form->{expense_accno_id}>
-<input type=hidden name=fxgain_accno_id values=$form->{fxgain_accno_id}>
-<input type=hidden name=fxloss_accno_id values=$form->{fxloss_accno_id}>
+ my %charttype = (
+ 'A' => $locale->text('Account'),
+ 'H' => $locale->text('Header'),
+ );
+
+ foreach $item ( sort({ $a <=> $b } keys %charttype) ) {
+ if ($item eq $form->{charttype}) {
+ $select_charttype .= qq|<option value="$item" selected="selected">$charttype{$item}\n|;
-<table border=0 width=100%>
- <tr>
- <th class=listtop>$form->{title}</th>
- </tr>
- <tr height="5"></tr>
- <tr valign=top>
- <td>
- <table>
- <tr>
- <th align=right>| . $locale->text('Account Number') . qq|</th>
- <td><input name=accno size=20 value=$form->{accno}></td>
- </tr>
- <tr>
- <th align=right>| . $locale->text('Description') . qq|</th>
- <td><input name=description size=40 value="$form->{description}"></td>
- </tr>
- <tr>
- <th align=right>| . $locale->text('Account Type') . qq|</th>
- <td>
- <table>
- <tr valign=top>
- <td><input name=category type=radio class=radio value=A $checked{A_}> |
- . $locale->text('Asset') . qq|\n<br>
- <input name=category type=radio class=radio value=L $checked{L_}> |
- . $locale->text('Liability') . qq|\n<br>
- <input name=category type=radio class=radio value=I $checked{I_}> |
- . $locale->text('Revenue') . qq|\n<br>
- <input name=category type=radio class=radio value=E $checked{E_}> |
- . $locale->text('Expense') . qq|</td>
- <td width=50> </td>
- <td>
- <input name=charttype type=radio class=radio value="H" $checked{H}> |
- . $locale->text('Heading') . qq|<br>
- <input name=charttype type=radio class=radio value="A" $checked{A}> |
- . $locale->text('Account') . qq|</td>
- </tr>
- </table>
- </td>
- </tr>
-|;
+ } else {
+ $select_charttype .= qq|<option value="$item">$charttype{$item}\n|;
+ }
- if ($form->{charttype} eq "A") {
- print qq|
- <tr>
- <td colspan=2>
- <table>
- <tr>
- <th align=left>|
- . $locale->text('Is this a summary account to record') . qq|</th>
- <td>
- <input name=AR type=checkbox class=checkbox value=AR $form->{AR}> |
- . $locale->text('AR')
- . qq| <input name=AP type=checkbox class=checkbox value=AP $form->{AP}> |
- . $locale->text('AP')
- . qq| <input name=IC type=checkbox class=checkbox value=IC $form->{IC}> |
- . $locale->text('Inventory')
- . qq|</td>
- </tr>
- </table>
- </td>
- </tr>
- <tr>
- <th colspan=2>| . $locale->text('Include in drop-down menus') . qq|</th>
- </tr>
- <tr valign=top>
- <td colspan=2>
- <table width=100%>
- <tr>
- <th align=left>| . $locale->text('Receivables') . qq|</th>
- <th align=left>| . $locale->text('Payables') . qq|</th>
- <th align=left>| . $locale->text('Parts Inventory') . qq|</th>
- <th align=left>| . $locale->text('Service Items') . qq|</th>
- </tr>
- <tr>
- <td>
- <input name=AR_amount type=checkbox class=checkbox value=AR_amount $form->{AR_amount}> |
- . $locale->text('Revenue') . qq|\n<br>
- <input name=AR_paid type=checkbox class=checkbox value=AR_paid $form->{AR_paid}> |
- . $locale->text('Receipt') . qq|\n<br>
- <input name=AR_tax type=checkbox class=checkbox value=AR_tax $form->{AR_tax}> |
- . $locale->text('Tax') . qq|
- </td>
- <td>
- <input name=AP_amount type=checkbox class=checkbox value=AP_amount $form->{AP_amount}> |
- . $locale->text('Expense/Asset') . qq|\n<br>
- <input name=AP_paid type=checkbox class=checkbox value=AP_paid $form->{AP_paid}> |
- . $locale->text('Payment') . qq|\n<br>
- <input name=AP_tax type=checkbox class=checkbox value=AP_tax $form->{AP_tax}> |
- . $locale->text('Tax') . qq|
- </td>
- <td>
- <input name=IC_sale type=checkbox class=checkbox value=IC_sale $form->{IC_sale}> |
- . $locale->text('Revenue') . qq|\n<br>
- <input name=IC_cogs type=checkbox class=checkbox value=IC_cogs $form->{IC_cogs}> |
- . $locale->text('COGS') . qq|\n<br>
- <input name=IC_taxpart type=checkbox class=checkbox value=IC_taxpart $form->{IC_taxpart}> |
- . $locale->text('Tax') . qq|
- </td>
- <td>
- <input name=IC_income type=checkbox class=checkbox value=IC_income $form->{IC_income}> |
- . $locale->text('Revenue') . qq|\n<br>
- <input name=IC_expense type=checkbox class=checkbox value=IC_expense $form->{IC_expense}> |
- . $locale->text('Expense') . qq|\n<br>
- <input name=IC_taxservice type=checkbox class=checkbox value=IC_taxservice $form->{IC_taxservice}> |
- . $locale->text('Tax') . qq|
- </td>
- </tr>
- </table>
- </td>
- </tr>
-|;
}
- print qq|
- $taxkey
- $ustva
- $eur
- $bwa
- $bilanz
- </table>
- </td>
- </tr>
- <tr>
- <td><hr size=3 noshade></td>
- </tr>
-</table>
-|;
+ my $ChartTypeIsAccount = ($form->{charttype} eq "A") ? "1":"";
+
+ $form->header();
+
+ my $parameters_ref = {
+ ChartTypeIsAccount => $ChartTypeIsAccount,
+ select_category => $select_category,
+ select_charttype => $select_charttype,
+ newaccount => $newaccount,
+ checked => $checked,
+ select_bwa => $select_bwa,
+ select_bilanz => $select_bilanz,
+ select_eur => $select_eur,
+ };
+
+ # Ausgabe des Templates
+ print($form->parse_html_template('am/edit_accounts', $parameters_ref));
+
$lxdebug->leave_sub();
}
<input name=callback type=hidden value="$form->{callback}">
-<input type=hidden name=path value=$form->{path}>
<input type=hidden name=login value=$form->{login}>
<input type=hidden name=password value=$form->{password}>
-<br>
+<br>|;
+ if ((!$form->{id}) || ($form->{id} && $form->{orphaned}) || (($form->{type} eq "account") && (!$form->{new_chart_valid}))) {
+ print qq|
<input type=submit class=submit name=action value="|
. $locale->text('Save') . qq|">
|;
+}
if ($form->{id} && $form->{orphaned}) {
print qq|<input type=submit class=submit name=action value="|
. $locale->text('Delete') . qq|">|;
}
- if ($form->{menubar}) {
- require "$form->{path}/menu.pl";
- &menubar;
- }
-
print qq|
</form>
sub save_account {
$lxdebug->enter_sub();
- $form->isblank("accno", $locale->text('Account Number missing!'));
- $form->isblank("category", $locale->text('Account Type missing!'));
+ $form->isblank("accno", $locale->text('Account Number missing!'));
+ $form->isblank("description", $locale->text('Account Description missing!'));
+
+ if ($form->{charttype} eq 'A'){
+ $form->isblank("category", $locale->text('Account Type missing!'));
+ }
$form->redirect($locale->text('Account saved!'))
if (AM->save_account(\%myconfig, \%$form));
# construct callback
$callback =
- "$form->{script}?action=list_account&path=$form->{path}&login=$form->{login}&password=$form->{password}";
+ "$form->{script}?action=list_account&login=$form->{login}&password=$form->{password}";
- @column_index = qw(accno gifi_accno description debit credit link);
- $column_header{accno} = qq|<th>| . $locale->text('Account') . qq|</a></th>|;
- $column_header{gifi_accno} =
- qq|<th>| . $locale->text('GIFI') . qq|</a></th>|;
- $column_header{description} =
- qq|<th>| . $locale->text('Description') . qq|</a></th>|;
- $column_header{debit} = qq|<th>| . $locale->text('Debit') . qq|</a></th>|;
- $column_header{credit} = qq|<th>| . $locale->text('Credit') . qq|</a></th>|;
- $column_header{link} = qq|<th>| . $locale->text('Link') . qq|</a></th>|;
+ # escape callback
+ $callback = $form->escape($callback);
+
+ foreach $ca (@{ $form->{CA} }) {
+
+ $ca->{debit} = " ";
+ $ca->{credit} = " ";
+
+ if ($ca->{amount} > 0) {
+ $ca->{credit} =
+ $form->format_amount(\%myconfig, $ca->{amount}, 2, " ");
+ }
+ if ($ca->{amount} < 0) {
+ $ca->{debit} =
+ $form->format_amount(\%myconfig, -1 * $ca->{amount}, 2, " ");
+ }
+ $ca->{heading} = ( $ca->{charttype} eq 'H' ) ? 1:'';
+ $ca->{link_edit_account} =
+ qq|$form->{script}?action=edit_account&id=$ca->{id}|
+ .qq|&path=$form->{path}&login=$form->{login}|
+ .qq|&password=$form->{password}&callback=$callback|;
+ }
+
+ # Ajax
+ my $list_account_details_url =
+ "$form->{script}?login=$form->{login}&path=$form->{path}"
+ ."&password=$form->{password}&action=list_account_details&";
+
+
+ my $pjx = new CGI::Ajax(
+ 'list_account_details' => $list_account_details_url
+ );
+
+ # Eneable AJAX debuging
+ #$pjx->DEBUG(1);
+ #$pjx->JSDEBUG(1);
+
+ push(@ { $form->{AJAX} }, $pjx);
+
$form->header;
- $colspan = $#column_index + 1;
+
+
+ my $parameters_ref = {
+ # hidden_variables => $_hidden_variables_ref,
+ };
+
+ # Ausgabe des Templates
+ print($form->parse_html_template('am/list_accounts', $parameters_ref));
+
+ $lxdebug->leave_sub();
- print qq|
-<body>
+}
-<table width=100%>
- <tr>
- <th class=listtop colspan=$colspan>$form->{title}</th>
- </tr>
- <tr height=5></tr>
- <tr class=listheading>
-|;
- map { print "$column_header{$_}\n" } @column_index;
+sub list_account_details {
+# Ajax Funktion aus list_account_details
+ $lxdebug->enter_sub();
- print qq|
-</tr>
-|;
+ my $chart_id = $form->{args};
+
+ CA->all_accounts(\%myconfig, \%$form, $chart_id);
+
+ $form->{title} = $locale->text('Chart of Accounts');
+
+ # construct callback
+ $callback =
+ "$form->{script}?action=list_account&path=$form->{path}&login=$form->{login}&password=$form->{password}";
+
+ $form->header;
# escape callback
$callback = $form->escape($callback);
}
if ($ca->{amount} < 0) {
$ca->{debit} =
- $form->format_amount(\%myconfig, -$ca->{amount}, 2, " ");
+ $form->format_amount(\%myconfig, -1 * $ca->{amount}, 2, " ");
}
- $ca->{link} =~ s/:/<br>/og;
-
- if ($ca->{charttype} eq "H") {
- print qq|<tr class=listheading>|;
-
- $column_data{accno} =
- qq|<th><a href=$form->{script}?action=edit_account&id=$ca->{id}&path=$form->{path}&login=$form->{login}&password=$form->{password}&callback=$callback>$ca->{accno}</a></th>|;
- $column_data{gifi_accno} =
- qq|<th><a href=$form->{script}?action=edit_gifi&accno=$ca->{gifi_accno}&path=$form->{path}&login=$form->{login}&password=$form->{password}&callback=$callback>$ca->{gifi_accno}</a> </th>|;
- $column_data{description} = qq|<th>$ca->{description} </th>|;
- $column_data{debit} = qq|<th> </th>|;
- $column_data{credit} = qq| <th> </th>|;
- $column_data{link} = qq|<th> </th>|;
-
- } else {
- $i++;
- $i %= 2;
- print qq|
-<tr valign=top class=listrow$i>|;
- $column_data{accno} =
- qq|<td><a href=$form->{script}?action=edit_account&id=$ca->{id}&path=$form->{path}&login=$form->{login}&password=$form->{password}&callback=$callback>$ca->{accno}</a></td>|;
- $column_data{gifi_accno} =
- qq|<td><a href=$form->{script}?action=edit_gifi&accno=$ca->{gifi_accno}&path=$form->{path}&login=$form->{login}&password=$form->{password}&callback=$callback>$ca->{gifi_accno}</a> </td>|;
- $column_data{description} = qq|<td>$ca->{description} </td>|;
- $column_data{debit} = qq|<td align=right>$ca->{debit}</td>|;
- $column_data{credit} = qq|<td align=right>$ca->{credit}</td>|;
- $column_data{link} = qq|<td>$ca->{link} </td>|;
-
+ my @links = split( q{:}, $ca->{link});
+
+ $ca->{link} = q{};
+
+ foreach my $link (@links){
+ $link = ( $link eq 'AR') ? $locale->text('Account Link AR')
+ : ( $link eq 'AP') ? $locale->text('Account Link AP')
+ : ( $link eq 'IC') ? $locale->text('Account Link IC')
+ : ( $link eq 'AR_amount' ) ? $locale->text('Account Link AR_amount')
+ : ( $link eq 'AR_paid' ) ? $locale->text('Account Link AR_paid')
+ : ( $link eq 'AR_tax' ) ? $locale->text('Account Link AR_tax')
+ : ( $link eq 'AP_amount' ) ? $locale->text('Account Link AP_amount')
+ : ( $link eq 'AP_paid' ) ? $locale->text('Account Link AP_paid')
+ : ( $link eq 'AP_tax' ) ? $locale->text('Account Link AP_tax')
+ : ( $link eq 'IC_sale' ) ? $locale->text('Account Link IC_sale')
+ : ( $link eq 'IC_cogs' ) ? $locale->text('Account Link IC_cogs')
+ : ( $link eq 'IC_taxpart' ) ? $locale->text('Account Link IC_taxpart')
+ : ( $link eq 'IC_income' ) ? $locale->text('Account Link IC_income')
+ : ( $link eq 'IC_expense' ) ? $locale->text('Account Link IC_expense')
+ : ( $link eq 'IC_taxservice' ) ? $locale->text('Account Link IC_taxservice')
+# : ( $link eq 'CT_tax' ) ? $locale->text('Account Link CT_tax')
+ : $locale->text('Unknown Link') . ': ' . $link;
+
+ $ca->{link} .= ($link ne '') ? "[$link] ":'';
}
-
- map { print "$column_data{$_}\n" } @column_index;
-
- print "</tr>\n";
+
+ $ca->{startdate} =~ s/,/<br>/og;
+ $ca->{tk_ustva} =~ s/,/<br>/og;
+ $ca->{taxkey} =~ s/,/<br>/og;
+ $ca->{taxaccount} =~ s/,/<br>/og;
+ $ca->{taxdescription} =~ s/,/<br>/og;
+ $ca->{datevautomatik} = ($ca->{datevautomatik}) ? $locale->text('On'):$locale->text('Off');
+
+ $ca->{category} = ($ca->{category} eq 'A') ? $locale->text('Account Category A')
+ : ($ca->{category} eq 'E') ? $locale->text('Account Category E')
+ : ($ca->{category} eq 'L') ? $locale->text('Account Category L')
+ : ($ca->{category} eq 'I') ? $locale->text('Account Category I')
+ : ($ca->{category} eq 'Q') ? $locale->text('Account Category Q')
+ : ($ca->{category} eq 'C') ? $locale->text('Account Category C')
+ : ($ca->{category} eq 'G') ? $locale->text('Account Category G')
+ : $locale->text('Unknown Category') . ': ' . $ca->{category};
+
+ $ca->{link_edit_account} =
+ qq|$form->{script}?action=edit_account&id=$ca->{id}|
+ .qq|&login=$form->{login}|
+ .qq|&password=$form->{password}&callback=$callback|;
}
- print qq|
- <tr><td colspan=$colspan><hr size=3 noshade></td></tr>
-</table>
-</body>
-</html>
-|;
+
+ my $parameters_ref = {
+
+
+ # hidden_variables => $_hidden_variables_ref,
+ };
+
+ # Ausgabe des Templates
+ #my $q = CGI->new();
+ my $result = $form->parse_html_template('am/list_account_details', $parameters_ref);
+
+ print $result;
+# print "chart_id:$chart_id, form->chartid:$form->{chart_id}, rest=$rest";
+
$lxdebug->leave_sub();
+
}
sub delete_account {
$lxdebug->leave_sub();
}
-sub list_gifi {
+sub add_department {
$lxdebug->enter_sub();
- @{ $form->{fields} } = (accno, description);
- $form->{table} = "gifi";
- $form->{sortorder} = "accno";
+ $form->{title} = "Add";
+ $form->{role} = "P";
- AM->gifi_accounts(\%myconfig, \%$form);
+ $form->{callback} =
+ "$form->{script}?action=add_department&login=$form->{login}&password=$form->{password}"
+ unless $form->{callback};
- $form->{title} = $locale->text('GIFI');
+ &department_header;
+ &form_footer;
- # construct callback
- $callback =
- "$form->{script}?action=list_gifi&path=$form->{path}&login=$form->{login}&password=$form->{password}";
+ $lxdebug->leave_sub();
+}
+
+sub edit_department {
+ $lxdebug->enter_sub();
+
+ $form->{title} = "Edit";
+
+ AM->get_department(\%myconfig, \%$form);
+
+ &department_header;
+ &form_footer;
+
+ $lxdebug->leave_sub();
+}
- @column_index = qw(accno description);
+sub list_department {
+ $lxdebug->enter_sub();
+
+ AM->departments(\%myconfig, \%$form);
+
+ $form->{callback} =
+ "$form->{script}?action=list_department&login=$form->{login}&password=$form->{password}";
+
+ $callback = $form->escape($form->{callback});
+
+ $form->{title} = $locale->text('Departments');
+
+ @column_index = qw(description cost profit);
- $column_header{accno} = qq|<th>| . $locale->text('GIFI') . qq|</a></th>|;
$column_header{description} =
- qq|<th>| . $locale->text('Description') . qq|</a></th>|;
+ qq|<th class=listheading width=90%>|
+ . $locale->text('Description')
+ . qq|</th>|;
+ $column_header{cost} =
+ qq|<th class=listheading nowrap>|
+ . $locale->text('Cost Center')
+ . qq|</th>|;
+ $column_header{profit} =
+ qq|<th class=listheading nowrap>|
+ . $locale->text('Profit Center')
+ . qq|</th>|;
$form->header;
- $colspan = $#column_index + 1;
print qq|
<body>
<table width=100%>
<tr>
- <th class=listtop colspan=$colspan>$form->{title}</th>
+ <th class=listtop>$form->{title}</th>
</tr>
<tr height="5"></tr>
- <tr class=listheading>
+ <tr>
+ <td>
+ <table width=100%>
+ <tr class=listheading>
|;
map { print "$column_header{$_}\n" } @column_index;
print qq|
-</tr>
+ </tr>
|;
- # escape callback
- $callback = $form->escape($callback);
-
- foreach $ca (@{ $form->{ALL} }) {
+ foreach $ref (@{ $form->{ALL} }) {
$i++;
$i %= 2;
print qq|
-<tr valign=top class=listrow$i>|;
+ <tr valign=top class=listrow$i>
+|;
- $column_data{accno} =
- qq|<td><a href=$form->{script}?action=edit_gifi&coa=1&accno=$ca->{accno}&path=$form->{path}&login=$form->{login}&password=$form->{password}&callback=$callback>$ca->{accno}</td>|;
- $column_data{description} = qq|<td>$ca->{description} </td>|;
+ $costcenter = ($ref->{role} eq "C") ? "X" : "";
+ $profitcenter = ($ref->{role} eq "P") ? "X" : "";
+
+ $column_data{description} =
+ qq|<td><a href=$form->{script}?action=edit_department&id=$ref->{id}&login=$form->{login}&password=$form->{password}&callback=$callback>$ref->{description}</td>|;
+ $column_data{cost} = qq|<td align=center>$costcenter</td>|;
+ $column_data{profit} = qq|<td align=center>$profitcenter</td>|;
map { print "$column_data{$_}\n" } @column_index;
- print "</tr>\n";
+ print qq|
+ </tr>
+|;
}
print qq|
+ </table>
+ </td>
+ </tr>
<tr>
- <td colspan=$colspan><hr size=3 noshade></td>
+ <td><hr size=3 noshade></td>
</tr>
</table>
-</body>
-</html>
-|;
+<br>
+<form method=post action=$form->{script}>
- $lxdebug->leave_sub();
-}
+<input name=callback type=hidden value="$form->{callback}">
-sub add_gifi {
- $lxdebug->enter_sub();
+<input type=hidden name=type value=department>
- $form->{title} = "Add";
+<input type=hidden name=login value=$form->{login}>
+<input type=hidden name=password value=$form->{password}>
- # construct callback
- $form->{callback} =
- "$form->{script}?action=list_gifi&path=$form->{path}&login=$form->{login}&password=$form->{password}";
+<input class=submit type=submit name=action value="|
+ . $locale->text('Add') . qq|">
+
+ </form>
+
+ </body>
+ </html>
+|;
+
+ $lxdebug->leave_sub();
+}
+
+sub department_header {
+ $lxdebug->enter_sub();
+
+ $form->{title} = $locale->text("$form->{title} Department");
+
+ # $locale->text('Add Department')
+ # $locale->text('Edit Department')
+
+ $form->{description} =~ s/\"/"/g;
+
+ if (($rows = $form->numtextrows($form->{description}, 60)) > 1) {
+ $description =
+ qq|<textarea name="description" rows=$rows cols=60 wrap=soft>$form->{description}</textarea>|;
+ } else {
+ $description =
+ qq|<input name=description size=60 value="$form->{description}">|;
+ }
+
+ $costcenter = "checked" if $form->{role} eq "C";
+ $profitcenter = "checked" if $form->{role} eq "P";
+
+ $form->header;
+
+ print qq|
+<body>
+
+<form method=post action=$form->{script}>
+
+<input type=hidden name=id value=$form->{id}>
+<input type=hidden name=type value=department>
+
+<table width=100%>
+ <tr>
+ <th class=listtop colspan=2>$form->{title}</th>
+ </tr>
+ <tr height="5"></tr>
+ <tr>
+ <th align=right>| . $locale->text('Description') . qq|</th>
+ <td>$description</td>
+ </tr>
+ <tr>
+ <td></td>
+ <td><input type=radio style=radio name=role value="C" $costcenter> |
+ . $locale->text('Cost Center') . qq|
+ <input type=radio style=radio name=role value="P" $profitcenter> |
+ . $locale->text('Profit Center') . qq|
+ </td>
+ <tr>
+ <td colspan=2><hr size=3 noshade></td>
+ </tr>
+</table>
+|;
+
+ $lxdebug->leave_sub();
+}
+
+sub save_department {
+ $lxdebug->enter_sub();
+
+ $form->isblank("description", $locale->text('Description missing!'));
+ AM->save_department(\%myconfig, \%$form);
+ $form->redirect($locale->text('Department saved!'));
+
+ $lxdebug->leave_sub();
+}
+
+sub delete_department {
+ $lxdebug->enter_sub();
+
+ AM->delete_department(\%myconfig, \%$form);
+ $form->redirect($locale->text('Department deleted!'));
+
+ $lxdebug->leave_sub();
+}
+
+sub add_lead {
+ $lxdebug->enter_sub();
+
+ $form->{title} = "Add";
+
+ $form->{callback} =
+ "$form->{script}?action=add_lead&login=$form->{login}&password=$form->{password}"
+ unless $form->{callback};
+
+ &lead_header;
+ &form_footer;
+
+ $lxdebug->leave_sub();
+}
+
+sub edit_lead {
+ $lxdebug->enter_sub();
+
+ $form->{title} = "Edit";
+
+ AM->get_lead(\%myconfig, \%$form);
+
+ &lead_header;
+
+ $form->{orphaned} = 1;
+ &form_footer;
+
+ $lxdebug->leave_sub();
+}
+
+sub list_lead {
+ $lxdebug->enter_sub();
+
+ AM->lead(\%myconfig, \%$form);
+
+ $form->{callback} =
+ "$form->{script}?action=list_lead&login=$form->{login}&password=$form->{password}";
+
+ $callback = $form->escape($form->{callback});
+
+ $form->{title} = $locale->text('Lead');
+
+ @column_index = qw(description cost profit);
+
+ $column_header{description} =
+ qq|<th class=listheading width=100%>|
+ . $locale->text('Description')
+ . qq|</th>|;
+
+ $form->header;
+
+ print qq|
+<body>
+
+<table width=100%>
+ <tr>
+ <th class=listtop>$form->{title}</th>
+ </tr>
+ <tr height="5"></tr>
+ <tr class=listheading>
+|;
+
+ map { print "$column_header{$_}\n" } @column_index;
+
+ print qq|
+ </tr>
+|;
+
+ foreach $ref (@{ $form->{ALL} }) {
+
+ $i++;
+ $i %= 2;
+
+ print qq|
+ <tr valign=top class=listrow$i>
+|;
+
+ $lead = $ref->{lead};
+
+ $column_data{description} =
+ qq|<td><a href=$form->{script}?action=edit_lead&id=$ref->{id}&login=$form->{login}&password=$form->{password}&callback=$callback>$ref->{lead}</td>|;
+
+ map { print "$column_data{$_}\n" } @column_index;
+
+ print qq|
+ </tr>
+|;
+ }
+
+ print qq|
+ <tr>
+ <td><hr size=3 noshade></td>
+ </tr>
+</table>
+
+<br>
+<form method=post action=$form->{script}>
+
+<input name=callback type=hidden value="$form->{callback}">
+
+<input type=hidden name=type value=lead>
+
+<input type=hidden name=login value=$form->{login}>
+<input type=hidden name=password value=$form->{password}>
+
+<input class=submit type=submit name=action value="|
+ . $locale->text('Add') . qq|">
+
+ </form>
+
+ </body>
+ </html>
+|;
+
+ $lxdebug->leave_sub();
+}
+
+sub lead_header {
+ $lxdebug->enter_sub();
+
+ $form->{title} = $locale->text("$form->{title} Lead");
+
+ # $locale->text('Add Lead')
+ # $locale->text('Edit Lead')
+
+ $form->{description} =~ s/\"/"/g;
+
+ $description =
+ qq|<input name=description size=50 value="$form->{lead}">|;
+
+ $form->header;
+
+ print qq|
+<body>
+
+<form method=post action=$form->{script}>
+
+<input type=hidden name=id value=$form->{id}>
+<input type=hidden name=type value=lead>
+
+<table width=100%>
+ <tr>
+ <th class=listtop colspan=2>$form->{title}</th>
+ </tr>
+ <tr height="5"></tr>
+ <tr>
+ <th align=right>| . $locale->text('Description') . qq|</th>
+ <td>$description</td>
+ </tr>
+ <td colspan=2><hr size=3 noshade></td>
+ </tr>
+</table>
+|;
+
+ $lxdebug->leave_sub();
+}
+
+sub save_lead {
+ $lxdebug->enter_sub();
+
+ $form->isblank("description", $locale->text('Description missing!'));
+ AM->save_lead(\%myconfig, \%$form);
+ $form->redirect($locale->text('lead saved!'));
+
+ $lxdebug->leave_sub();
+}
+
+sub delete_lead {
+ $lxdebug->enter_sub();
+
+ AM->delete_lead(\%myconfig, \%$form);
+ $form->redirect($locale->text('lead deleted!'));
+
+ $lxdebug->leave_sub();
+}
+
+sub add_business {
+ $lxdebug->enter_sub();
+
+ $form->{title} = "Add";
+
+ $form->{callback} =
+ "$form->{script}?action=add_business&login=$form->{login}&password=$form->{password}"
+ unless $form->{callback};
+
+ &business_header;
+ &form_footer;
+
+ $lxdebug->leave_sub();
+}
+
+sub edit_business {
+ $lxdebug->enter_sub();
+
+ $form->{title} = "Edit";
+
+ AM->get_business(\%myconfig, \%$form);
+
+ &business_header;
+
+ $form->{orphaned} = 1;
+ &form_footer;
+
+ $lxdebug->leave_sub();
+}
+
+sub list_business {
+ $lxdebug->enter_sub();
+
+ AM->business(\%myconfig, \%$form);
+
+ $form->{callback} =
+ "$form->{script}?action=list_business&login=$form->{login}&password=$form->{password}";
+
+ $callback = $form->escape($form->{callback});
+
+ $form->{title} = $locale->text('Type of Business');
+
+ @column_index = qw(description discount customernumberinit);
+
+ $column_header{description} =
+ qq|<th class=listheading width=60%>|
+ . $locale->text('Description')
+ . qq|</th>|;
+ $column_header{discount} =
+ qq|<th class=listheading width=10%>|
+ . $locale->text('Discount')
+ . qq| %</th>|;
+ $column_header{customernumberinit} =
+ qq|<th class=listheading>|
+ . $locale->text('Customernumberinit')
+ . qq|</th>|;
+
+ $form->header;
+
+ print qq|
+<body>
+
+<table width=100%>
+ <tr>
+ <th class=listtop>$form->{title}</th>
+ </tr>
+ <tr height="5"></tr>
+ <tr>
+ <td>
+ <table width=100%>
+ <tr class=listheading>
+|;
+
+ map { print "$column_header{$_}\n" } @column_index;
+
+ print qq|
+ </tr>
+|;
+
+ foreach $ref (@{ $form->{ALL} }) {
+
+ $i++;
+ $i %= 2;
+
+ print qq|
+ <tr valign=top class=listrow$i>
+|;
+
+ $discount =
+ $form->format_amount(\%myconfig, $ref->{discount} * 100);
+ $description =
+ $ref->{description};
+ $column_data{description} =
+ qq|<td><a href=$form->{script}?action=edit_business&id=$ref->{id}&login=$form->{login}&password=$form->{password}&callback=$callback>$description</td>|;
+ $column_data{discount} = qq|<td align=right>$discount</td>|;
+ $column_data{customernumberinit} =
+ qq|<td align=right>$ref->{customernumberinit}</td>|;
+
+ map { print "$column_data{$_}\n" } @column_index;
+
+ print qq|
+ </tr>
+|;
+ }
- $form->{coa} = 1;
+ print qq|
+ </table>
+ </td>
+ </tr>
+ <tr>
+ <td><hr size=3 noshade></td>
+ </tr>
+</table>
- &gifi_header;
- &gifi_footer;
+<br>
+<form method=post action=$form->{script}>
- $lxdebug->leave_sub();
-}
+<input name=callback type=hidden value="$form->{callback}">
-sub edit_gifi {
- $lxdebug->enter_sub();
+<input type=hidden name=type value=business>
- $form->{title} = "Edit";
+<input type=hidden name=login value=$form->{login}>
+<input type=hidden name=password value=$form->{password}>
+
+<input class=submit type=submit name=action value="|
+ . $locale->text('Add') . qq|">
- AM->get_gifi(\%myconfig, \%$form);
+ </form>
- &gifi_header;
- &gifi_footer;
+ </body>
+ </html>
+|;
$lxdebug->leave_sub();
}
-sub gifi_header {
+sub business_header {
$lxdebug->enter_sub();
- $form->{title} = $locale->text("$form->{title} GIFI");
+ $form->{title} = $locale->text("$form->{title} Business");
- # $locale->text('Add GIFI')
- # $locale->text('Edit GIFI')
+ # $locale->text('Add Business')
+ # $locale->text('Edit Business')
$form->{description} =~ s/\"/"/g;
+ $form->{discount} =
+ $form->format_amount(\%myconfig, $form->{discount} * 100);
$form->header;
<form method=post action=$form->{script}>
-<input type=hidden name=id value=$form->{accno}>
-<input type=hidden name=type value=gifi>
+<input type=hidden name=id value=$form->{id}>
+<input type=hidden name=type value=business>
<table width=100%>
<tr>
- <th class=listtop>$form->{title}</th>
+ <th class=listtop colspan=2>$form->{title}</th>
</tr>
<tr height="5"></tr>
<tr>
- <td>
- <table>
- <tr>
- <th align=right>| . $locale->text('GIFI') . qq|</th>
- <td><input name=accno size=20 value=$form->{accno}></td>
- </tr>
- <tr>
- <th align=right>| . $locale->text('Description') . qq|</th>
- <td><input name=description size=60 value="$form->{description}"></td>
- </tr>
- </table>
- </td>
+ <th align=right>| . $locale->text('Type of Business') . qq|</th>
+ <td><input name=description size=30 value="$form->{description}"></td>
+ <tr>
+ <tr>
+ <th align=right>| . $locale->text('Discount') . qq| %</th>
+ <td><input name=discount size=5 value=$form->{discount}></td>
</tr>
<tr>
- <td colspan=2><hr size=3 noshade></td>
+ <th align=right>| . $locale->text('Customernumberinit') . qq|</th>
+ <td><input name=customernumberinit size=10 value=$form->{customernumberinit}></td>
+ </tr>
+ <td colspan=2><hr size=3 noshade></td>
</tr>
</table>
|;
$lxdebug->leave_sub();
}
-sub gifi_footer {
+sub save_business {
+ $lxdebug->enter_sub();
+
+ $form->isblank("description", $locale->text('Description missing!'));
+ $form->{discount} = $form->parse_amount(\%myconfig, $form->{discount}) / 100;
+ AM->save_business(\%myconfig, \%$form);
+ $form->redirect($locale->text('Business saved!'));
+
+ $lxdebug->leave_sub();
+}
+
+sub delete_business {
+ $lxdebug->enter_sub();
+
+ AM->delete_business(\%myconfig, \%$form);
+ $form->redirect($locale->text('Business deleted!'));
+
+ $lxdebug->leave_sub();
+}
+
+sub add_language {
+ $lxdebug->enter_sub();
+
+ $form->{title} = "Add";
+
+ $form->{callback} =
+ "$form->{script}?action=add_language&login=$form->{login}&password=$form->{password}"
+ unless $form->{callback};
+
+ &language_header;
+ &form_footer;
+
+ $lxdebug->leave_sub();
+}
+
+sub edit_language {
+ $lxdebug->enter_sub();
+
+ $form->{title} = "Edit";
+
+ AM->get_language(\%myconfig, \%$form);
+
+ &language_header;
+
+ $form->{orphaned} = 1;
+ &form_footer;
+
+ $lxdebug->leave_sub();
+}
+
+sub list_language {
$lxdebug->enter_sub();
+ AM->language(\%myconfig, \%$form);
+
+ $form->{callback} =
+ "$form->{script}?action=list_language&login=$form->{login}&password=$form->{password}";
+
+ $callback = $form->escape($form->{callback});
+
+ $form->{title} = $locale->text('Languages');
+
+ @column_index = qw(description template_code article_code output_numberformat output_dateformat output_longdates);
+
+ $column_header{description} =
+ qq|<th class=listheading width=60%>|
+ . $locale->text('Description')
+ . qq|</th>|;
+ $column_header{template_code} =
+ qq|<th class=listheading width=10%>|
+ . $locale->text('Template Code')
+ . qq|</th>|;
+ $column_header{article_code} =
+ qq|<th class=listheading>|
+ . $locale->text('Article Code')
+ . qq|</th>|;
+ $column_header{output_numberformat} =
+ qq|<th class=listheading>|
+ . $locale->text('Number Format')
+ . qq|</th>|;
+ $column_header{output_dateformat} =
+ qq|<th class=listheading>|
+ . $locale->text('Date Format')
+ . qq|</th>|;
+ $column_header{output_longdates} =
+ qq|<th class=listheading>|
+ . $locale->text('Long Dates')
+ . qq|</th>|;
+
+ $form->header;
+
print qq|
+<body>
-<input name=callback type=hidden value="$form->{callback}">
+<table width=100%>
+ <tr>
+ <th class=listtop>$form->{title}</th>
+ </tr>
+ <tr height="5"></tr>
+ <tr>
+ <td>
+ <table width=100%>
+ <tr class=listheading>
+|;
-<input type=hidden name=path value=$form->{path}>
-<input type=hidden name=login value=$form->{login}>
-<input type=hidden name=password value=$form->{password}>
+ map { print "$column_header{$_}\n" } @column_index;
+
+ print qq|
+ </tr>
+|;
+
+ foreach $ref (@{ $form->{ALL} }) {
-<br><input type=submit class=submit name=action value="|
- . $locale->text('Save') . qq|">|;
+ $i++;
+ $i %= 2;
- if ($form->{coa}) {
print qq|
-<input type=submit class=submit name=action value="|
- . $locale->text('Copy to COA') . qq|">
+ <tr valign=top class=listrow$i>
|;
- if ($form->{accno} && $form->{orphaned}) {
- print qq|<input type=submit class=submit name=action value="|
- . $locale->text('Delete') . qq|">|;
- }
- }
- if ($form->{menubar}) {
- require "$form->{path}/menu.pl";
- &menubar;
+ $column_data{description} =
+ qq|<td><a href=$form->{script}?action=edit_language&id=$ref->{id}&login=$form->{login}&password=$form->{password}&callback=$callback>$ref->{description}</td>|;
+ $column_data{template_code} = qq|<td align=right>$ref->{template_code}</td>|;
+ $column_data{article_code} =
+ qq|<td align=right>$ref->{article_code}</td>|;
+ $column_data{output_numberformat} =
+ "<td nowrap>" .
+ ($ref->{output_numberformat} ? $ref->{output_numberformat} :
+ $locale->text("use program settings")) .
+ "</td>";
+ $column_data{output_dateformat} =
+ "<td nowrap>" .
+ ($ref->{output_dateformat} ? $ref->{output_dateformat} :
+ $locale->text("use program settings")) .
+ "</td>";
+ $column_data{output_longdates} =
+ "<td nowrap>" .
+ ($ref->{output_longdates} ? $locale->text("Yes") : $locale->text("No")) .
+ "</td>";
+
+ map { print "$column_data{$_}\n" } @column_index;
+
+ print qq|
+ </tr>
+|;
}
print qq|
+ </table>
+ </td>
+ </tr>
+ <tr>
+ <td><hr size=3 noshade></td>
+ </tr>
+</table>
+
+<br>
+<form method=post action=$form->{script}>
+
+<input name=callback type=hidden value="$form->{callback}">
+
+<input type=hidden name=type value=language>
+
+<input type=hidden name=login value=$form->{login}>
+<input type=hidden name=password value=$form->{password}>
+
+<input class=submit type=submit name=action value="|
+ . $locale->text('Add') . qq|">
+
</form>
-</body>
-</html>
+ </body>
+ </html>
|;
$lxdebug->leave_sub();
}
-sub save_gifi {
+sub language_header {
$lxdebug->enter_sub();
- $form->isblank("accno", $locale->text('GIFI missing!'));
- AM->save_gifi(\%myconfig, \%$form);
- $form->redirect($locale->text('GIFI saved!'));
+ $form->{title} = $locale->text("$form->{title} Language");
- $lxdebug->leave_sub();
-}
+ # $locale->text('Add Language')
+ # $locale->text('Edit Language')
-sub copy_to_coa {
- $lxdebug->enter_sub();
+ $form->{description} =~ s/\"/"/g;
+ $form->{template_code} =~ s/\"/"/g;
+ $form->{article_code} =~ s/\"/"/g;
- $form->isblank("accno", $locale->text('GIFI missing!'));
- AM->save_gifi(\%myconfig, \%$form);
+ $form->header;
- delete $form->{id};
- $form->{gifi_accno} = $form->{accno};
- $form->{title} = "Add";
- $form->{charttype} = "A";
+ my $numberformat =
+ qq|<option value="">| . $locale->text("use program settings") .
+ qq|</option>|;
+ foreach $item (qw(1,000.00 1000.00 1.000,00 1000,00)) {
+ $numberformat .=
+ ($item eq $form->{output_numberformat})
+ ? "<option selected>$item"
+ : "<option>$item"
+ . "</option>";
+ }
- &account_header;
- &form_footer;
+ my $dateformat =
+ qq|<option value="">| . $locale->text("use program settings") .
+ qq|</option>|;
+ foreach $item (qw(mm-dd-yy mm/dd/yy dd-mm-yy dd/mm/yy dd.mm.yy yyyy-mm-dd)) {
+ $dateformat .=
+ ($item eq $form->{output_dateformat})
+ ? "<option selected>$item"
+ : "<option>$item"
+ . "</option>";
+ }
+
+ print qq|
+<body>
+
+<form method=post action=$form->{script}>
+
+<input type=hidden name=id value=$form->{id}>
+<input type=hidden name=type value=language>
+
+<table width=100%>
+ <tr>
+ <th class=listtop colspan=2>$form->{title}</th>
+ </tr>
+ <tr height="5"></tr>
+ <tr>
+ <th align=right>| . $locale->text('Language') . qq|</th>
+ <td><input name=description size=30 value="| . $form->quote($form->{description}) . qq|"></td>
+ <tr>
+ <tr>
+ <th align=right>| . $locale->text('Template Code') . qq|</th>
+ <td><input name=template_code size=5 value="| . $form->quote($form->{template_code}) . qq|"></td>
+ </tr>
+ <tr>
+ <th align=right>| . $locale->text('Article Code') . qq|</th>
+ <td><input name=article_code size=10 value="| . $form->quote($form->{article_code}) . qq|"></td>
+ </tr>
+ <tr>
+ <th align=right>| . $locale->text('Number Format') . qq|</th>
+ <td><select name="output_numberformat">$numberformat</select></td>
+ </tr>
+ <tr>
+ <th align=right>| . $locale->text('Date Format') . qq|</th>
+ <td><select name="output_dateformat">$dateformat</select></td>
+ </tr>
+ <tr>
+ <th align=right>| . $locale->text('Long Dates') . qq|</th>
+ <td><input type="radio" name="output_longdates" value="1"| .
+ ($form->{output_longdates} ? " checked" : "") .
+ qq|>| . $locale->text("Yes") .
+ qq|<input type="radio" name="output_longdates" value="0"| .
+ ($form->{output_longdates} ? "" : " checked") .
+ qq|>| . $locale->text("No") .
+ qq|</td>
+ </tr>
+ <td colspan=2><hr size=3 noshade></td>
+ </tr>
+</table>
+|;
$lxdebug->leave_sub();
}
-sub delete_gifi {
+sub save_language {
$lxdebug->enter_sub();
- AM->delete_gifi(\%myconfig, \%$form);
- $form->redirect($locale->text('GIFI deleted!'));
+ $form->isblank("description", $locale->text('Language missing!'));
+ $form->isblank("template_code", $locale->text('Template Code missing!'));
+ $form->isblank("article_code", $locale->text('Article Code missing!'));
+ AM->save_language(\%myconfig, \%$form);
+ $form->redirect($locale->text('Language saved!'));
$lxdebug->leave_sub();
}
-sub add_department {
+sub delete_language {
+ $lxdebug->enter_sub();
+
+ AM->delete_language(\%myconfig, \%$form);
+ $form->redirect($locale->text('Language deleted!'));
+
+ $lxdebug->leave_sub();
+}
+
+
+sub add_buchungsgruppe {
$lxdebug->enter_sub();
+ # $locale->text("Add Buchungsgruppe")
+ # $locale->text("Edit Buchungsgruppe")
$form->{title} = "Add";
- $form->{role} = "P";
$form->{callback} =
- "$form->{script}?action=add_department&path=$form->{path}&login=$form->{login}&password=$form->{password}"
+ "$form->{script}?action=add_buchungsgruppe&login=$form->{login}&password=$form->{password}"
unless $form->{callback};
+ AM->get_buchungsgruppe(\%myconfig, \%$form);
+ $form->{"inventory_accno_id"} = $form->{"std_inventory_accno_id"};
+ for (my $i = 0; 4 > $i; $i++) {
+ map({ $form->{"${_}_accno_id_$i"} = $form->{"std_${_}_accno_id"}; }
+ qw(income expense));
+ }
- &department_header;
+ &buchungsgruppe_header;
&form_footer;
$lxdebug->leave_sub();
}
-sub edit_department {
+sub edit_buchungsgruppe {
$lxdebug->enter_sub();
$form->{title} = "Edit";
- AM->get_department(\%myconfig, \%$form);
+ AM->get_buchungsgruppe(\%myconfig, \%$form);
+
+ &buchungsgruppe_header;
- &department_header;
&form_footer;
$lxdebug->leave_sub();
}
-sub list_department {
+sub list_buchungsgruppe {
$lxdebug->enter_sub();
- AM->departments(\%myconfig, \%$form);
+ AM->buchungsgruppe(\%myconfig, \%$form);
$form->{callback} =
- "$form->{script}?action=list_department&path=$form->{path}&login=$form->{login}&password=$form->{password}";
+ "$form->{script}?action=list_buchungsgruppe&login=$form->{login}&password=$form->{password}";
$callback = $form->escape($form->{callback});
- $form->{title} = $locale->text('Departments');
+ $form->{title} = $locale->text('Buchungsgruppen');
- @column_index = qw(description cost profit);
+ @column_index = qw(up down description inventory_accno
+ income_accno_0 expense_accno_0
+ income_accno_1 expense_accno_1
+ income_accno_2 expense_accno_2
+ income_accno_3 expense_accno_3 );
+ $column_header{up} =
+ qq|<th class="listheading" width="16">|
+ . qq|<img src="image/up.png" alt="| . $locale->text("up") . qq|">|
+ . qq|</th>|;
+ $column_header{down} =
+ qq|<th class="listheading" width="16">|
+ . qq|<img src="image/down.png" alt="| . $locale->text("down") . qq|">|
+ . qq|</th>|;
$column_header{description} =
- qq|<th class=listheading width=90%>|
+ qq|<th class="listheading" width="40%">|
. $locale->text('Description')
. qq|</th>|;
- $column_header{cost} =
- qq|<th class=listheading nowrap>|
- . $locale->text('Cost Center')
+ $column_header{inventory_accno} =
+ qq|<th class=listheading>|
+ . $locale->text('Bestandskonto')
+ . qq|</th>|;
+ $column_header{income_accno_0} =
+ qq|<th class=listheading>|
+ . $locale->text('National Revenues')
+ . qq|</th>|;
+ $column_header{expense_accno_0} =
+ qq|<th class=listheading>|
+ . $locale->text('National Expenses')
+ . qq|</th>|;
+ $column_header{income_accno_1} =
+ qq|<th class=listheading>|
+ . $locale->text('Revenues EU with UStId')
+ . qq|</th>|;
+ $column_header{expense_accno_1} =
+ qq|<th class=listheading>|
+ . $locale->text('Expenses EU with UStId')
+ . qq|</th>|;
+ $column_header{income_accno_2} =
+ qq|<th class=listheading>|
+ . $locale->text('Revenues EU without UStId')
+ . qq|</th>|;
+ $column_header{expense_accno_2} =
+ qq|<th class=listheading>|
+ . $locale->text('Expenses EU without UStId')
. qq|</th>|;
- $column_header{profit} =
- qq|<th class=listheading nowrap>|
- . $locale->text('Profit Center')
+ $column_header{income_accno_3} =
+ qq|<th class=listheading>|
+ . $locale->text('Foreign Revenues')
+ . qq|</th>|;
+ $column_header{expense_accno_3} =
+ qq|<th class=listheading>|
+ . $locale->text('Foreign Expenses')
. qq|</th>|;
-
$form->header;
print qq|
</tr>
|;
+ my $swap_link = qq|$form->{script}?action=swap_buchungsgruppen&|;
+ map({ $swap_link .= $_ . "=" . $form->escape($form->{$_}) . "&" }
+ qw(login password));
+
+ my $row = 0;
foreach $ref (@{ $form->{ALL} }) {
$i++;
<tr valign=top class=listrow$i>
|;
- $costcenter = ($ref->{role} eq "C") ? "X" : "";
- $profitcenter = ($ref->{role} eq "P") ? "X" : "";
+ if ($row) {
+ my $pref = $form->{ALL}->[$row - 1];
+ $column_data{up} =
+ qq|<td align="center" valign="center" width="16">| .
+ qq|<a href="${swap_link}id1=$ref->{id}&id2=$pref->{id}">| .
+ qq|<img border="0" src="image/up.png" alt="| . $locale->text("up") . qq|">| .
+ qq|</a></td>|;
+ } else {
+ $column_data{up} = qq|<td width="16"> </td>|;
+ }
+
+ if ($row == (scalar(@{ $form->{ALL} }) - 1)) {
+ $column_data{down} = qq|<td width="16"> </td>|;
+ } else {
+ my $nref = $form->{ALL}->[$row + 1];
+ $column_data{down} =
+ qq|<td align="center" valign="center" width="16">| .
+ qq|<a href="${swap_link}id1=$ref->{id}&id2=$nref->{id}">| .
+ qq|<img border="0" src="image/down.png" alt="| . $locale->text("down") . qq|">| .
+ qq|</a></td>|;
+ }
$column_data{description} =
- qq|<td><a href=$form->{script}?action=edit_department&id=$ref->{id}&path=$form->{path}&login=$form->{login}&password=$form->{password}&callback=$callback>$ref->{description}</td>|;
- $column_data{cost} = qq|<td align=center>$costcenter</td>|;
- $column_data{profit} = qq|<td align=center>$profitcenter</td>|;
+ qq|<td><a href=$form->{script}?action=edit_buchungsgruppe&id=$ref->{id}&login=$form->{login}&password=$form->{password}&callback=$callback>$ref->{description}</td>|;
+ $column_data{inventory_accno} = qq|<td align=right>$ref->{inventory_accno}</td>|;
+ $column_data{income_accno_0} =
+ qq|<td align=right>$ref->{income_accno_0}</td>|;
+ $column_data{expense_accno_0} = qq|<td align=right>$ref->{expense_accno_0}</td>|;
+ $column_data{income_accno_1} =
+ qq|<td align=right>$ref->{income_accno_1}</td>|;
+ $column_data{expense_accno_1} = qq|<td align=right>$ref->{expense_accno_1}</td>|;
+ $column_data{income_accno_2} =
+ qq|<td align=right>$ref->{income_accno_2}</td>|;
+ $column_data{expense_accno_2} = qq|<td align=right>$ref->{expense_accno_2}</td>|;
+ $column_data{income_accno_3} =
+ qq|<td align=right>$ref->{income_accno_3}</td>|;
+ $column_data{expense_accno_3} = qq|<td align=right>$ref->{expense_accno_3}</td>|;
map { print "$column_data{$_}\n" } @column_index;
print qq|
</tr>
|;
+
+ $row++;
}
print qq|
<input name=callback type=hidden value="$form->{callback}">
-<input type=hidden name=type value=department>
+<input type=hidden name=type value=buchungsgruppe>
-<input type=hidden name=path value=$form->{path}>
<input type=hidden name=login value=$form->{login}>
<input type=hidden name=password value=$form->{password}>
<input class=submit type=submit name=action value="|
- . $locale->text('Add') . qq|">|;
-
- if ($form->{menubar}) {
- require "$form->{path}/menu.pl";
- &menubar;
- }
+ . $locale->text('Add') . qq|">
- print qq|
</form>
</body>
$lxdebug->leave_sub();
}
-sub department_header {
+sub buchungsgruppe_header {
$lxdebug->enter_sub();
- $form->{title} = $locale->text("$form->{title} Department");
+ $form->{title} = $locale->text("$form->{title} Buchungsgruppe");
- # $locale->text('Add Department')
- # $locale->text('Edit Department')
+ # $locale->text('Add Accounting Group')
+ # $locale->text('Edit Accounting Group')
- $form->{description} =~ s/\"/"/g;
+ my ($acc_inventory, $acc_income, $acc_expense) = ({}, {}, {});
+ my %acc_type_map = (
+ "IC" => $acc_inventory,
+ "IC_income" => $acc_income,
+ "IC_sale" => $acc_income,
+ "IC_expense" => $acc_expense,
+ "IC_cogs" => $acc_expense,
+ );
- if (($rows = $form->numtextrows($form->{description}, 60)) > 1) {
- $description =
- qq|<textarea name="description" rows=$rows cols=60 wrap=soft>$form->{description}</textarea>|;
+ foreach $key (keys(%acc_type_map)) {
+ foreach $ref (@{ $form->{IC_links}{$key} }) {
+ $acc_type_map{$key}->{$ref->{"id"}} = $ref;
+ }
+ }
+
+ foreach my $type (qw(IC IC_income IC_expense)) {
+ $form->{"select$type"} =
+ join("",
+ map({ "<option value=$_->{id} $_->{selected}>" .
+ "$_->{accno}--" . H($_->{description}) . "</option>" }
+ sort({ $a->{"accno"} cmp $b->{"accno"} }
+ values(%{$acc_type_map{$type}}))));
+ }
+
+ if ($form->{id}) {
+ $form->{selectIC} =~ s/selected//g;
+ $form->{selectIC} =~ s/ value=$form->{inventory_accno_id}/ value=$form->{inventory_accno_id} selected/;
+ $form->{selectIC_income} =~ s/selected//g;
+ $form->{selectIC_income} =~ s/ value=$form->{income_accno_id_0}/ value=$form->{income_accno_id_0} selected/;
+ $form->{selectIC_expense} =~ s/selected//g;
+ $form->{selectIC_expense} =~ s/ value=$form->{expense_accno_id_0}/ value=$form->{expense_accno_id_0} selected/;
+ }
+
+ if (!$eur) {
+ $linkaccounts = qq|
+ <tr>
+ <th align=right>| . $locale->text('Inventory') . qq|</th>
+ <td><select name=inventory_accno_id>$form->{selectIC}</select></td>
+ <input name=selectIC type=hidden value="$form->{selectIC}">
+ </tr>|;
} else {
- $description =
- qq|<input name=description size=60 value="$form->{description}">|;
+ $linkaccounts = qq|
+ <input type=hidden name=inventory_accno_id value=$form->{inventory_accno_id}>|;
}
- $costcenter = "checked" if $form->{role} eq "C";
- $profitcenter = "checked" if $form->{role} eq "P";
+
+ $linkaccounts .= qq|
+ <tr>
+ <th align=right>| . $locale->text('National Revenues') . qq|</th>
+ <td><select name=income_accno_id_0>$form->{selectIC_income}</select></td>
+ </tr>
+ <tr>
+ <th align=right>| . $locale->text('National Expenses') . qq|</th>
+ <td><select name=expense_accno_id_0>$form->{selectIC_expense}</select></td>
+ </tr>|;
+ if ($form->{id}) {
+ $form->{selectIC_income} =~ s/selected//g;
+ $form->{selectIC_income} =~ s/ value=$form->{income_accno_id_1}/ value=$form->{income_accno_id_1} selected/;
+ $form->{selectIC_expense} =~ s/selected//g;
+ $form->{selectIC_expense} =~ s/ value=$form->{expense_accno_id_1}/ value=$form->{expense_accno_id_1} selected/;
+ }
+ $linkaccounts .= qq| <tr>
+ <th align=right>| . $locale->text('Revenues EU with UStId') . qq|</th>
+ <td><select name=income_accno_id_1>$form->{selectIC_income}</select></td>
+ </tr>
+ <tr>
+ <th align=right>| . $locale->text('Expenses EU with UStId') . qq|</th>
+ <td><select name=expense_accno_id_1>$form->{selectIC_expense}</select></td>
+ </tr>|;
+
+ if ($form->{id}) {
+ $form->{selectIC_income} =~ s/selected//g;
+ $form->{selectIC_income} =~ s/ value=$form->{income_accno_id_2}/ value=$form->{income_accno_id_2} selected/;
+ $form->{selectIC_expense} =~ s/selected//g;
+ $form->{selectIC_expense} =~ s/ value=$form->{expense_accno_id_2}/ value=$form->{expense_accno_id_2} selected/;
+ }
+
+ $linkaccounts .= qq| <tr>
+ <th align=right>| . $locale->text('Revenues EU without UStId') . qq|</th>
+ <td><select name=income_accno_id_2>$form->{selectIC_income}</select></td>
+ </tr>
+ <tr>
+ <th align=right>| . $locale->text('Expenses EU without UStId') . qq|</th>
+ <td><select name=expense_accno_id_2>$form->{selectIC_expense}</select></td>
+ </tr>|;
+
+ if ($form->{id}) {
+ $form->{selectIC_income} =~ s/selected//g;
+ $form->{selectIC_income} =~ s/ value=$form->{income_accno_id_3}/ value=$form->{income_accno_id_3} selected/;
+ $form->{selectIC_expense} =~ s/selected//g;
+ $form->{selectIC_expense} =~ s/ value=$form->{expense_accno_id_3}/ value=$form->{expense_accno_id_3} selected/;
+ }
+
+ $linkaccounts .= qq| <tr>
+ <th align=right>| . $locale->text('Foreign Revenues') . qq|</th>
+ <td><select name=income_accno_id_3>$form->{selectIC_income}</select></td>
+ </tr>
+ <tr>
+ <th align=right>| . $locale->text('Foreign Expenses') . qq|</th>
+ <td><select name=expense_accno_id_3>$form->{selectIC_expense}</select></td>
+ </tr>
+|;
+
$form->header;
<form method=post action=$form->{script}>
<input type=hidden name=id value=$form->{id}>
-<input type=hidden name=type value=department>
+<input type=hidden name=type value=buchungsgruppe>
<table width=100%>
<tr>
</tr>
<tr height="5"></tr>
<tr>
- <th align=right>| . $locale->text('Description') . qq|</th>
- <td>$description</td>
- </tr>
- <tr>
- <td></td>
- <td><input type=radio style=radio name=role value="C" $costcenter> |
- . $locale->text('Cost Center') . qq|
- <input type=radio style=radio name=role value="P" $profitcenter> |
- . $locale->text('Profit Center') . qq|
- </td>
+ <th align=right>| . $locale->text('Buchungsgruppe') . qq|</th>
+ <td><input name=description size=30 value="| . $form->quote($form->{description}) . qq|"></td>
<tr>
- <td colspan=2><hr size=3 noshade></td>
+ $linkaccounts
+ <td colspan=2><hr size=3 noshade></td>
</tr>
</table>
|;
$lxdebug->leave_sub();
}
-sub save_department {
+sub save_buchungsgruppe {
$lxdebug->enter_sub();
$form->isblank("description", $locale->text('Description missing!'));
- AM->save_department(\%myconfig, \%$form);
- $form->redirect($locale->text('Department saved!'));
+
+ AM->save_buchungsgruppe(\%myconfig, \%$form);
+ $form->redirect($locale->text('Accounting Group saved!'));
$lxdebug->leave_sub();
}
-sub delete_department {
+sub delete_buchungsgruppe {
$lxdebug->enter_sub();
- AM->delete_department(\%myconfig, \%$form);
- $form->redirect($locale->text('Department deleted!'));
+ AM->delete_buchungsgruppe(\%myconfig, \%$form);
+ $form->redirect($locale->text('Accounting Group deleted!'));
$lxdebug->leave_sub();
}
-sub add_business {
+sub swap_buchungsgruppen {
+ $lxdebug->enter_sub();
+
+ AM->swap_sortkeys(\%myconfig, $form, "buchungsgruppen");
+ list_buchungsgruppe();
+
+ $lxdebug->leave_sub();
+}
+
+
+sub add_printer {
$lxdebug->enter_sub();
$form->{title} = "Add";
$form->{callback} =
- "$form->{script}?action=add_business&path=$form->{path}&login=$form->{login}&password=$form->{password}"
+ "$form->{script}?action=add_printer&login=$form->{login}&password=$form->{password}"
unless $form->{callback};
- &business_header;
+ &printer_header;
&form_footer;
$lxdebug->leave_sub();
}
-sub edit_business {
+sub edit_printer {
$lxdebug->enter_sub();
$form->{title} = "Edit";
- AM->get_business(\%myconfig, \%$form);
+ AM->get_printer(\%myconfig, \%$form);
- &business_header;
+ &printer_header;
$form->{orphaned} = 1;
&form_footer;
$lxdebug->leave_sub();
}
-sub list_business {
+sub list_printer {
$lxdebug->enter_sub();
- AM->business(\%myconfig, \%$form);
+ AM->printer(\%myconfig, \%$form);
$form->{callback} =
- "$form->{script}?action=list_business&path=$form->{path}&login=$form->{login}&password=$form->{password}";
+ "$form->{script}?action=list_printer&login=$form->{login}&password=$form->{password}";
$callback = $form->escape($form->{callback});
- $form->{title} = $locale->text('Type of Business');
+ $form->{title} = $locale->text('Printer');
- @column_index = qw(description discount customernumberinit);
+ @column_index = qw(printer_description printer_command template_code);
- $column_header{description} =
+ $column_header{printer_description} =
qq|<th class=listheading width=60%>|
- . $locale->text('Description')
+ . $locale->text('Printer Description')
. qq|</th>|;
- $column_header{discount} =
+ $column_header{printer_command} =
qq|<th class=listheading width=10%>|
- . $locale->text('Discount')
- . qq| %</th>|;
- $column_header{customernumberinit} =
+ . $locale->text('Printer Command')
+ . qq|</th>|;
+ $column_header{template_code} =
qq|<th class=listheading>|
- . $locale->text('Customernumberinit')
+ . $locale->text('Template Code')
. qq|</th>|;
$form->header;
<tr valign=top class=listrow$i>
|;
- $discount =
- $form->format_amount(\%myconfig, $ref->{discount} * 100, 1, " ");
- $description =
- ($ref->{salesman})
- ? "<b>$ref->{description}</b>"
- : "$ref->{description}";
- $column_data{description} =
- qq|<td><a href=$form->{script}?action=edit_business&id=$ref->{id}&path=$form->{path}&login=$form->{login}&password=$form->{password}&callback=$callback>$description</td>|;
- $column_data{discount} = qq|<td align=right>$discount</td>|;
- $column_data{customernumberinit} =
- qq|<td align=right>$ref->{customernumberinit}</td>|;
+
+ $column_data{printer_description} =
+ qq|<td><a href=$form->{script}?action=edit_printer&id=$ref->{id}&login=$form->{login}&password=$form->{password}&callback=$callback>$ref->{printer_description}</td>|;
+ $column_data{printer_command} = qq|<td align=right>$ref->{printer_command}</td>|;
+ $column_data{template_code} =
+ qq|<td align=right>$ref->{template_code}</td>|;
map { print "$column_data{$_}\n" } @column_index;
<input name=callback type=hidden value="$form->{callback}">
-<input type=hidden name=type value=business>
+<input type=hidden name=type value=printer>
-<input type=hidden name=path value=$form->{path}>
<input type=hidden name=login value=$form->{login}>
<input type=hidden name=password value=$form->{password}>
<input class=submit type=submit name=action value="|
- . $locale->text('Add') . qq|">|;
-
- if ($form->{menubar}) {
- require "$form->{path}/menu.pl";
- &menubar;
- }
-
- print qq|
+ . $locale->text('Add') . qq|">
</form>
$lxdebug->leave_sub();
}
-sub business_header {
+sub printer_header {
$lxdebug->enter_sub();
- $form->{title} = $locale->text("$form->{title} Business");
- $form->{salesman} = "checked" if $form->{salesman};
+ $form->{title} = $locale->text("$form->{title} Printer");
- # $locale->text('Add Business')
- # $locale->text('Edit Business')
+ # $locale->text('Add Printer')
+ # $locale->text('Edit Printer')
+
+ $form->{printer_description} =~ s/\"/"/g;
+ $form->{template_code} =~ s/\"/"/g;
+ $form->{printer_command} =~ s/\"/"/g;
- $form->{description} =~ s/\"/"/g;
- $form->{discount} =
- $form->format_amount(\%myconfig, $form->{discount} * 100);
$form->header;
<form method=post action=$form->{script}>
<input type=hidden name=id value=$form->{id}>
-<input type=hidden name=type value=business>
+<input type=hidden name=type value=printer>
<table width=100%>
<tr>
</tr>
<tr height="5"></tr>
<tr>
- <th align=right>| . $locale->text('Type of Business') . qq|</th>
- <td><input name=description size=30 value="$form->{description}"></td>
- <tr>
+ <th align=right>| . $locale->text('Printer') . qq|</th>
+ <td><input name=printer_description size=30 value="$form->{printer_description}"></td>
<tr>
- <th align=right>| . $locale->text('Discount') . qq| %</th>
- <td><input name=discount size=5 value=$form->{discount}></td>
- </tr>
<tr>
- <th align=right>| . $locale->text('Customernumberinit') . qq|</th>
- <td><input name=customernumberinit size=10 value=$form->{customernumberinit}></td>
+ <th align=right>| . $locale->text('Printer Command') . qq|</th>
+ <td><input name=printer_command size=30 value="$form->{printer_command}"></td>
</tr>
<tr>
- <td align=right>| . $locale->text('Salesman') . qq|</td>
- <td><input name=salesman class=checkbox type=checkbox value=1 $form->{salesman}></td>
+ <th align=right>| . $locale->text('Template Code') . qq|</th>
+ <td><input name=template_code size=5 value="$form->{template_code}"></td>
</tr>
<td colspan=2><hr size=3 noshade></td>
</tr>
$lxdebug->leave_sub();
}
-sub save_business {
+sub save_printer {
$lxdebug->enter_sub();
- $form->isblank("description", $locale->text('Description missing!'));
- AM->save_business(\%myconfig, \%$form);
- $form->redirect($locale->text('Business saved!'));
+ $form->isblank("printer_description", $locale->text('Description missing!'));
+ $form->isblank("printer_command", $locale->text('Printer Command missing!'));
+ AM->save_printer(\%myconfig, \%$form);
+ $form->redirect($locale->text('Printer saved!'));
$lxdebug->leave_sub();
}
-sub delete_business {
+sub delete_printer {
$lxdebug->enter_sub();
- AM->delete_business(\%myconfig, \%$form);
- $form->redirect($locale->text('Business deleted!'));
+ AM->delete_printer(\%myconfig, \%$form);
+ $form->redirect($locale->text('Printer deleted!'));
$lxdebug->leave_sub();
}
-sub add_sic {
+sub add_payment {
$lxdebug->enter_sub();
$form->{title} = "Add";
$form->{callback} =
- "$form->{script}?action=add_sic&path=$form->{path}&login=$form->{login}&password=$form->{password}"
+ "$form->{script}?action=add_payment&login=$form->{login}&password=$form->{password}"
unless $form->{callback};
- &sic_header;
+ $form->{terms_netto} = 0;
+ $form->{terms_skonto} = 0;
+ $form->{percent_skonto} = 0;
+ my @languages = AM->language(\%myconfig, $form, 1);
+ map({ $_->{"language"} = $_->{"description"};
+ $_->{"language_id"} = $_->{"id"}; } @languages);
+ $form->{"TRANSLATION"} = \@languages;
+ &payment_header;
&form_footer;
$lxdebug->leave_sub();
}
-sub edit_sic {
+sub edit_payment {
$lxdebug->enter_sub();
$form->{title} = "Edit";
- AM->get_sic(\%myconfig, \%$form);
+ AM->get_payment(\%myconfig, $form);
+ $form->{percent_skonto} =
+ $form->format_amount(\%myconfig, $form->{percent_skonto} * 100);
- &sic_header;
+ &payment_header;
$form->{orphaned} = 1;
&form_footer;
$lxdebug->leave_sub();
}
-sub list_sic {
+sub list_payment {
$lxdebug->enter_sub();
- AM->sic(\%myconfig, \%$form);
+ AM->payment(\%myconfig, \%$form);
- $form->{callback} =
- "$form->{script}?action=list_sic&path=$form->{path}&login=$form->{login}&password=$form->{password}";
+ $form->{callback} = build_std_url("action=list_payment");
$callback = $form->escape($form->{callback});
- $form->{title} = $locale->text('Standard Industrial Codes');
+ $form->{title} = $locale->text('Payment Terms');
- @column_index = qw(code description);
+ @column_index = qw(up down description description_long terms_netto
+ terms_skonto percent_skonto);
- $column_header{code} =
- qq|<th class=listheading>| . $locale->text('Code') . qq|</th>|;
+ $column_header{up} =
+ qq|<th class="listheading" align="center" valign="center" width="16">|
+ . qq|<img src="image/up.png" alt="| . $locale->text("up") . qq|">|
+ . qq|</th>|;
+ $column_header{down} =
+ qq|<th class="listheading" align="center" valign="center" width="16">|
+ . qq|<img src="image/down.png" alt="| . $locale->text("down") . qq|">|
+ . qq|</th>|;
$column_header{description} =
- qq|<th class=listheading>| . $locale->text('Description') . qq|</th>|;
+ qq|<th class=listheading>|
+ . $locale->text('Description')
+ . qq|</th>|;
+ $column_header{description_long} =
+ qq|<th class=listheading>|
+ . $locale->text('Long Description')
+ . qq|</th>|;
+ $column_header{terms_netto} =
+ qq|<th class=listheading>|
+ . $locale->text('Netto Terms')
+ . qq|</th>|;
+ $column_header{terms_skonto} =
+ qq|<th class=listheading>|
+ . $locale->text('Skonto Terms')
+ . qq|</th>|;
+ $column_header{percent_skonto} =
+ qq|<th class=listheading>|
+ . $locale->text('Skonto')
+ . qq| %</th>|;
$form->header;
</tr>
|;
+ my $swap_link = build_std_url("action=swap_payment_terms");
+
+ my $row = 0;
foreach $ref (@{ $form->{ALL} }) {
$i++;
$i %= 2;
- if ($ref->{sictype} eq 'H') {
- print qq|
- <tr valign=top class=listheading>
-|;
- $column_data{code} =
- qq|<th><a href=$form->{script}?action=edit_sic&code=$ref->{code}&path=$form->{path}&login=$form->{login}&password=$form->{password}&callback=$callback>$ref->{code}</th>|;
- $column_data{description} = qq|<th>$ref->{description}</th>|;
-
- } else {
- print qq|
+ print qq|
<tr valign=top class=listrow$i>
|;
- $column_data{code} =
- qq|<td><a href=$form->{script}?action=edit_sic&code=$ref->{code}&path=$form->{path}&login=$form->{login}&password=$form->{password}&callback=$callback>$ref->{code}</td>|;
- $column_data{description} = qq|<td>$ref->{description}</td>|;
+ if ($row) {
+ my $pref = $form->{ALL}->[$row - 1];
+ $column_data{up} =
+ qq|<td align="center" valign="center" width="16">| .
+ qq|<a href="${swap_link}&id1=$ref->{id}&id2=$pref->{id}">| .
+ qq|<img border="0" src="image/up.png" alt="| . $locale->text("up") . qq|">| .
+ qq|</a></td>|;
+ } else {
+ $column_data{up} = qq|<td width="16"> </td>|;
+ }
+ if ($row == (scalar(@{ $form->{ALL} }) - 1)) {
+ $column_data{down} = qq|<td width="16"> </td>|;
+ } else {
+ my $nref = $form->{ALL}->[$row + 1];
+ $column_data{down} =
+ qq|<td align="center" valign="center" width="16">| .
+ qq|<a href="${swap_link}&id1=$ref->{id}&id2=$nref->{id}">| .
+ qq|<img border="0" src="image/down.png" alt="| . $locale->text("down") . qq|">| .
+ qq|</a></td>|;
}
+ $column_data{description} =
+ qq|<td><a href="| .
+ build_std_url("action=edit_payment", "id=$ref->{id}", "callback=$callback") .
+ qq|">| . H($ref->{description}) . qq|</a></td>|;
+ $column_data{description_long} =
+ qq|<td>| . H($ref->{description_long}) . qq|</td>|;
+ $column_data{terms_netto} =
+ qq|<td align=right>$ref->{terms_netto}</td>|;
+ $column_data{terms_skonto} =
+ qq|<td align=right>$ref->{terms_skonto}</td>|;
+ $column_data{percent_skonto} =
+ qq|<td align=right>| .
+ $form->format_amount(\%myconfig, $ref->{percent_skonto} * 100) .
+ qq|%</td>|;
map { print "$column_data{$_}\n" } @column_index;
print qq|
</tr>
|;
+ $row++;
}
print qq|
<input name=callback type=hidden value="$form->{callback}">
-<input type=hidden name=type value=sic>
+<input type=hidden name=type value=payment>
-<input type=hidden name=path value=$form->{path}>
<input type=hidden name=login value=$form->{login}>
<input type=hidden name=password value=$form->{password}>
<input class=submit type=submit name=action value="|
- . $locale->text('Add') . qq|">|;
+ . $locale->text('Add') . qq|">
- if ($form->{menubar}) {
- require "$form->{path}/menu.pl";
- &menubar;
- }
-
- print qq|
</form>
</body>
$lxdebug->leave_sub();
}
-sub sic_header {
+sub payment_header {
$lxdebug->enter_sub();
- $form->{title} = $locale->text("$form->{title} SIC");
+ $form->{title} = $locale->text("$form->{title} Payment Terms");
- # $locale->text('Add SIC')
- # $locale->text('Edit SIC')
+ # $locale->text('Add Payment Terms')
+ # $locale->text('Edit Payment Terms')
- $form->{code} =~ s/\"/"/g;
$form->{description} =~ s/\"/"/g;
- $checked = ($form->{sictype} eq 'H') ? "checked" : "";
+
$form->header;
<form method=post action=$form->{script}>
-<input type=hidden name=type value=sic>
-<input type=hidden name=id value=$form->{code}>
+<input type=hidden name=id value=$form->{id}>
+<input type=hidden name=type value=payment>
<table width=100%>
<tr>
</tr>
<tr height="5"></tr>
<tr>
- <th align=right>| . $locale->text('Code') . qq|</th>
- <td><input name=code size=10 value=$form->{code}></td>
- <tr>
- <tr>
- <td></td>
- <th align=left><input name=sictype type=checkbox style=checkbox value="H" $checked> |
- . $locale->text('Heading') . qq|</th>
+ <th align=right>| . $locale->text('Description') . qq|</th>
+ <td><input name=description size=30 value="$form->{description}"></td>
<tr>
<tr>
- <th align=right>| . $locale->text('Description') . qq|</th>
- <td><input name=description size=60 value="$form->{description}"></td>
- </tr>
- <td colspan=2><hr size=3 noshade></td>
+ <th align=right>| . $locale->text('Long Description') . qq|</th>
+ <td><input name=description_long size=50 value="$form->{description_long}"></td>
</tr>
-</table>
-|;
-
- $lxdebug->leave_sub();
-}
-
-sub save_sic {
- $lxdebug->enter_sub();
-
- $form->isblank("code", $locale->text('Code missing!'));
- $form->isblank("description", $locale->text('Description missing!'));
- AM->save_sic(\%myconfig, \%$form);
- $form->redirect($locale->text('SIC saved!'));
-
- $lxdebug->leave_sub();
-}
-
-sub delete_sic {
- $lxdebug->enter_sub();
-
- AM->delete_sic(\%myconfig, \%$form);
- $form->redirect($locale->text('SIC deleted!'));
-
- $lxdebug->leave_sub();
-}
-
-sub display_stylesheet {
- $lxdebug->enter_sub();
-
- $form->{file} = "css/$myconfig{stylesheet}";
- &display_form;
-
- $lxdebug->leave_sub();
-}
-
-sub display_form {
- $lxdebug->enter_sub();
-
- $form->{file} =~ s/^(.:)*?\/|\.\.\///g;
- $form->{file} =~ s/^\/*//g;
- $form->{file} =~ s/$userspath//;
-
- $form->error("$!: $form->{file}") unless -f $form->{file};
-
- AM->load_template(\%$form);
-
- $form->{title} = $form->{file};
-
- # if it is anything but html
- if ($form->{file} !~ /\.html$/) {
- $form->{body} = "<pre>\n$form->{body}\n</pre>";
- }
-
- $form->header;
-
- print qq|
-<body>
-
-$form->{body}
-
-<form method=post action=$form->{script}>
-
-<input name=file type=hidden value=$form->{file}>
-<input name=type type=hidden value=template>
-
-<input type=hidden name=path value=$form->{path}>
-<input type=hidden name=login value=$form->{login}>
-<input type=hidden name=password value=$form->{password}>
-
-<input name=action type=submit class=submit value="|
- . $locale->text('Edit') . qq|">|;
-
- if ($form->{menubar}) {
- require "$form->{path}/menu.pl";
- &menubar;
- }
-
- print qq|
- </form>
-
-</body>
-</html>
|;
- $lxdebug->leave_sub();
-}
-
-sub edit_template {
- $lxdebug->enter_sub();
-
- AM->load_template(\%$form);
-
- $form->{title} = $locale->text('Edit Template');
-
- # convert   to &nbsp;
- $form->{body} =~ s/ /&nbsp;/gi;
-
- $form->header;
-
- print qq|
-<body>
-
-<form method=post action=$form->{script}>
-
-<input name=file type=hidden value=$form->{file}>
-<input name=type type=hidden value=template>
+ foreach my $language (@{ $form->{"TRANSLATION"} }) {
+ print qq|
+ <tr>
+ <th align="right">| .
+ sprintf($locale->text('Translation (%s)'),
+ $language->{"language"})
+ . qq|</th>
+ <td><input name="description_long_$language->{language_id}" size="50"
+ value="| . Q($language->{"description_long"}) . qq|"></td>
+ </tr>
+|;
+ }
-<input type=hidden name=path value=$form->{path}>
-<input type=hidden name=login value=$form->{login}>
-<input type=hidden name=password value=$form->{password}>
+ print qq|
+ <tr>
+ <th align=right>| . $locale->text('Netto Terms') . qq|</th>
+ <td><input name=terms_netto size=10 value="$form->{terms_netto}"></td>
+ </tr>
+ <tr>
+ <th align=right>| . $locale->text('Skonto Terms') . qq|</th>
+ <td><input name=terms_skonto size=10 value="$form->{terms_skonto}"></td>
+ </tr>
+ <tr>
+ <th align=right>| . $locale->text('Skonto') . qq| %</th>
+ <td><input name=percent_skonto size=10 value="$form->{percent_skonto}"></td>
+ </tr>
+ <td colspan=2><hr size=3 noshade></td>
+ </tr>
+</table>
-<input name=callback type=hidden value="$form->{script}?action=display_form&file=$form->{file}&path=$form->{path}&login=$form->{login}&password=$form->{password}">
+<p>| . $locale->text("You can use the following strings in the long " .
+ "description and all translations. They will be " .
+ "replaced by their actual values by Lx-Office " .
+ "before they're output.")
+. qq|</p>
+
+<ul>
+ <li>| . $locale->text("<%netto_date%> -- Date the payment is due in " .
+ "full")
+. qq|</li>
+ <li>| . $locale->text("<%skonto_date%> -- Date the payment is due " .
+ "with discount")
+. qq|</li>
+ <li>| . $locale->text("<%skonto_amount%> -- The deductible amount")
+. qq|</li>
+ <li>| . $locale->text("<%total%> -- Amount payable")
+. qq|</li>
+ <li>| . $locale->text("<%invtotal%> -- Invoice total")
+. qq|</li>
+ <li>| . $locale->text("<%currency%> -- The selected currency")
+. qq|</li>
+ <li>| . $locale->text("<%terms_netto%> -- The number of days for " .
+ "full payment")
+. qq|</li>
+ <li>| . $locale->text("<%account_number%> -- Your account number")
+. qq|</li>
+ <li>| . $locale->text("<%bank%> -- Your bank")
+. qq|</li>
+ <li>| . $locale->text("<%bank_code%> -- Your bank code")
+. qq|</li>
+</ul>|;
-<textarea name=body rows=25 cols=70>
-$form->{body}
-</textarea>
+ $lxdebug->leave_sub();
+}
-<br>
-<input type=submit class=submit name=action value="|
- . $locale->text('Save') . qq|">|;
+sub save_payment {
+ $lxdebug->enter_sub();
- if ($form->{menubar}) {
- require "$form->{path}/menu.pl";
- &menubar;
- }
+ $form->isblank("description", $locale->text('Description missing!'));
+ $form->{"percent_skonto"} =
+ $form->parse_amount(\%myconfig, $form->{percent_skonto}) / 100;
+ AM->save_payment(\%myconfig, \%$form);
+ $form->redirect($locale->text('Payment Terms saved!'));
- print q|
- </form>
+ $lxdebug->leave_sub();
+}
+sub delete_payment {
+ $lxdebug->enter_sub();
-</body>
-</html>
-|;
+ AM->delete_payment(\%myconfig, \%$form);
+ $form->redirect($locale->text('Payment terms deleted!'));
$lxdebug->leave_sub();
}
-sub save_template {
+sub swap_payment_terms {
$lxdebug->enter_sub();
- AM->save_template(\%$form);
- $form->redirect($locale->text('Template saved!'));
+ AM->swap_sortkeys(\%myconfig, $form, "payment_terms");
+ list_payment();
$lxdebug->leave_sub();
}
? "<option selected>$item\n"
: "<option>$item\n";
}
-
+
foreach $item (qw(name company address signature)) {
$myconfig{$item} =~ s/\"/"/g;
}
$myconfig{$item} =~ s/\\n/\r\n/g;
}
+ @formats = ();
+ if ($opendocument_templates && $openofficeorg_writer_bin &&
+ $xvfb_bin && (-x $openofficeorg_writer_bin) && (-x $xvfb_bin)) {
+ push(@formats, { "name" => $locale->text("PDF (OpenDocument/OASIS)"),
+ "value" => "opendocument_pdf" });
+ }
+ if ($latex_templates) {
+ push(@formats, { "name" => $locale->text("PDF"), "value" => "pdf" });
+ }
+ push(@formats, { "name" => "HTML", "value" => "html" });
+ if ($latex_templates) {
+ push(@formats, { "name" => $locale->text("Postscript"),
+ "value" => "postscript" });
+ }
+ if ($opendocument_templates) {
+ push(@formats, { "name" => $locale->text("OpenDocument/OASIS"),
+ "value" => "opendocument" });
+ }
+
+ if (!$myconfig{"template_format"}) {
+ $myconfig{"template_format"} = "pdf";
+ }
+ my $template_format = "";
+ foreach $item (@formats) {
+ $template_format .=
+ "<option value=\"$item->{value}\"" .
+ ($item->{"value"} eq $myconfig{"template_format"} ?
+ " selected" : "") .
+ ">" . H($item->{"name"}) . "</option>";
+ }
+
+ if (!$myconfig{"default_media"}) {
+ $myconfig{"default_media"} = "screen";
+ }
+ my %selected = ($myconfig{"default_media"} => "selected");
+ my $default_media = qq|
+ <option value="screen" $selected{'screen'}>| . $locale->text("Screen") . qq|</option>
+ <option value="printer" $selected{'printer'}>| . $locale->text("Printer") . qq|</option>
+ <option value="queue" $selected{'queue'}>| . $locale->text("Queue") . qq|</option>
+|;
+
+ %selected = ();
+ $selected{$myconfig{"default_printer_id"}} = "selected"
+ if ($myconfig{"default_printer_id"});
+ my $default_printer = qq|<option></option>|;
+ AM->printer(\%myconfig, $form);
+ foreach my $printer (@{$form->{"ALL"}}) {
+ $default_printer .= qq|<option value="| . Q($printer->{"id"}) .
+ qq|" $selected{$printer->{'id'}}>| .
+ H($printer->{"printer_description"}) . qq|</option>|;
+ }
+
%countrycodes = User->country_codes;
$countrycodes = '';
foreach $key (sort { $countrycodes{$a} cmp $countrycodes{$b} }
: "<option value=$key>$countrycodes{$key}\n";
}
$countrycodes = "<option>American English\n$countrycodes";
-
- # use an other input number format than output numberformat
- # look at Form.pm, sub parse_amount
- my $ in_numberformat = '';
- $text1 = qq|value="0">| . $locale->text('equal Outputformat');
- $text2 = qq|value="1">| . $locale->text('1000,00 or 1000.00');
- @in_nf = ($text1, $text2);
- foreach $item ( @in_nf ) {
- $in_numberformat .=
- ( substr($item, 7, 1) eq $myconfig{in_numberformat})
- ? "<option selected $item\n"
- : "<option $item\n";
- }
-
-
foreach $key (keys %{ $form->{IC} }) {
foreach $accno (sort keys %{ $form->{IC}{$key} }) {
$myconfig{$key} .=
}
}
- opendir CSS, "css/.";
- @all = grep /.*\.css$/, readdir CSS;
- closedir CSS;
+# opendir CSS, "css/.";
+# @all = grep /.*\.css$/, readdir CSS;
+# closedir CSS;
+
+# css dir has styles that are not intended as general layouts.
+# reverting to hardcoded list
+ @all = qw(lx-office-erp.css Win2000.css);
foreach $item (@all) {
if ($item eq $myconfig{stylesheet}) {
$form->header;
- if ($myconfig{menustyle} eq "old") { $oldS = "checked"; }
- else { $newS = "checked"; }
+ if ($myconfig{menustyle} eq "old") {
+ $menustyle_old = "checked";
+ } elsif ($myconfig{menustyle} eq "neu") {
+ $menustyle_neu = "checked";
+ } elsif ($myconfig{menustyle} eq "v3") {
+ $menustyle_v3 = "checked";
+ }
+
+ my ($show_form_details, $hide_form_details);
+ $myconfig{"show_form_details"} = 1
+ unless (defined($myconfig{"show_form_details"}));
+ $show_form_details = "checked" if ($myconfig{"show_form_details"});
+ $hide_form_details = "checked" unless ($myconfig{"show_form_details"});
print qq|
<body>
<th align=right>| . $locale->text('Output Number Format') . qq|</th>
<td><select name=numberformat>$numberformat</select></td>
</tr>
- <tr>
- <th align=right>| . $locale->text('Input Number Format') . qq|</th>
- <td><select name=in_numberformat>$in_numberformat</select></td>
- </tr>
<tr>
<th align=right>| . $locale->text('Dropdown Limit') . qq|</th>
<th align=right>| . $locale->text('Language') . qq|</th>
<td><select name=countrycode>$countrycodes</select></td>
</tr>
- <tr>
- <th align=right>| . $locale->text('Character Set') . qq|</th>
- <td><input name=charset size=20 value="$myconfig{charset}"></td>
- </tr>
<tr>
<th align=right>| . $locale->text('Stylesheet') . qq|</th>
<td><select name=usestylesheet>$selectstylesheet</select></td>
</tr>
<tr>
<th align=right>| . $locale->text('Setup Menu') . qq|</th>
- <td><input name=menustyle type=radio class=radio value=neu $newS> New
- <input name=menustyle type=radio class=radio value=old $oldS> Old</td>
- </tr>
+ <td><input name=menustyle type=radio class=radio value=v3 $menustyle_v3> | .
+ $locale->text("Top (CSS)") . qq|
+ <input name=menustyle type=radio class=radio value=neu $menustyle_neu> | .
+ $locale->text("Top (Javascript)") . qq|
+ <input name=menustyle type=radio class=radio value=old $menustyle_old> | .
+ $locale->text("Old (on the side)") . qq|</td>
+ </tr>
+ <tr>
+ <th align=right>| . $locale->text('Form details (second row)') . qq|</th>
+ <td><input type="radio" id="rad_show_form_details" name="show_form_details" value="1" $show_form_details>
+ <label for="rad_show_form_details">| . $locale->text('Show by default') . qq|</label>
+ <input type="radio" id="rad_hide_form_details" name="show_form_details" value="0" $hide_form_details>
+ <label for="rad_hide_form_details">| . $locale->text('Hide by default') . qq|</label></td>
+ </tr>
<input name=printer type=hidden value="$myconfig{printer}">
+ <tr class=listheading>
+ <th colspan=2>| . $locale->text("Print options") . qq|</th>
+ </tr>
+ <tr>
+ <th align=right>| . $locale->text('Default template format') . qq|</th>
+ <td><select name="template_format">$template_format</select></td>
+ </tr>
+ <tr>
+ <th align=right>| . $locale->text('Default output medium') . qq|</th>
+ <td><select name="default_media">$default_media</select></td>
+ </tr>
+ <tr>
+ <th align=right>| . $locale->text('Default printer') . qq|</th>
+ <td><select name="default_printer_id">$default_printer</select></td>
+ </tr>
+ <tr>
+ <th align=right>| . $locale->text('Number of copies') . qq|</th>
+ <td><input name="copies" size="10" value="| .
+ $form->quote($myconfig{"copies"}) . qq|"></td>
+ </tr>
+
+
<tr class=listheading>
<th colspan=2> </th>
</tr>
<td><input name=businessnumber size=25 value="$myconfig{businessnumber}"></td>
</tr>
<tr>
- <td colspan=2>
- <table width=100%>
- <tr>
<th align=right>| . $locale->text('Year End') . qq| (mm/dd)</th>
<td><input name=yearend size=5 value=$form->{defaults}{yearend}></td>
- <th align=right>| . $locale->text('Weight Unit') . qq|</th>
- <td><input name=weightunit size=5 value="$form->{defaults}{weightunit}"></td>
- </tr>
- </table>
- </td>
</tr>
<tr class=listheading>
<th colspan=2>|
</tr>
<tr>
<th align=right nowrap>|
- . $locale->text('Last Sales Order Number') . qq|</th>
- <td><input name=sonumber size=10 value=$form->{defaults}{sonumber}></td>
+ . $locale->text('Last Credit Note Number') . qq|</th>
+ <td><input name=cnnumber size=10 value=$form->{defaults}{cnnumber}></td>
<th align=right nowrap>|
. $locale->text('Last Vendor Number') . qq|</th>
<td><input name=vendornumber size=10 value=$form->{defaults}{vendornumber}></td>
</tr>
<tr>
<th align=right nowrap>|
+ . $locale->text('Last Sales Order Number') . qq|</th>
+ <td><input name=sonumber size=10 value=$form->{defaults}{sonumber}></td>
+ </tr>
+ <tr>
+ <th align=right nowrap>|
. $locale->text('Last Purchase Order Number') . qq|</th>
<td><input name=ponumber size=10 value=$form->{defaults}{ponumber}></td>
<th align=right nowrap>|
</tr>
</table>
</td>
- </tr>
- <tr class=listheading>
- <th colspan=2>| . $locale->text('Tax Accounts') . qq|</th>
- </tr>
- <tr>
- <td colspan=2>
- <tr>
- <th> </th>
- <th>| . $locale->text('Rate') . qq| (%)</th>
- <th>| . $locale->text('Number') . qq|</th>
- </tr>
-|;
-
- foreach $accno (sort keys %{ $form->{taxrates} }) {
- print qq|
- <tr>
- <th align=right>$form->{taxrates}{$accno}{description}</th>
- <td><input name=$form->{taxrates}{$accno}{id} size=6 value=$form->{taxrates}{$accno}{rate}></td>
- <td><input name="taxnumber_$form->{taxrates}{$accno}{id}" value="$form->{taxrates}{$accno}{taxnumber}"></td>
- </tr>
-|;
- $form->{taxaccounts} .= "$form->{taxrates}{$accno}{id} ";
- }
-
- chop $form->{taxaccounts};
-
- print qq|
-<input name=taxaccounts type=hidden value="$form->{taxaccounts}">
-
- </table>
- </td>
- </tr>
- </table>
+ </tr>|;
+# <tr class=listheading>
+# <th colspan=2>| . $locale->text('Tax Accounts') . qq|</th>
+# </tr>
+# <tr>
+# <td colspan=2>
+# <tr>
+# <th> </th>
+# <th>| . $locale->text('Rate') . qq| (%)</th>
+# <th>| . $locale->text('Number') . qq|</th>
+# </tr>
+# |;
+#
+# foreach $accno (sort keys %{ $form->{taxrates} }) {
+# print qq|
+# <tr>
+# <th align=right>$form->{taxrates}{$accno}{description}</th>
+# <td><input name=$form->{taxrates}{$accno}{id} size=6 value=$form->{taxrates}{$accno}{rate}></td>
+# <td><input name="taxnumber_$form->{taxrates}{$accno}{id}" value="$form->{taxrates}{$accno}{taxnumber}"></td>
+# </tr>
+# |;
+# $form->{taxaccounts} .= "$form->{taxrates}{$accno}{id} ";
+# }
+#
+# chop $form->{taxaccounts};
+#
+# print qq|
+# <input name=taxaccounts type=hidden value="$form->{taxaccounts}">
+#
+# </table>
+# </td>
+# </tr>
+print qq| </table>
</td>
</tr>
<tr>
</tr>
</table>
-<input type=hidden name=path value=$form->{path}>
<input type=hidden name=login value=$form->{login}>
<input type=hidden name=password value=$form->{password}>
<br>
<input type=submit class=submit name=action value="|
- . $locale->text('Save') . qq|">|;
-
- if ($form->{menubar}) {
- require "$form->{path}/menu.pl";
- &menubar;
- }
+ . $locale->text('Save') . qq|">
- print qq|
</form>
</body>
$lxdebug->leave_sub();
}
-sub backup {
- $lxdebug->enter_sub();
-
- if ($form->{media} eq 'email') {
- $form->error($locale->text('No email address for') . " $myconfig{name}")
- unless ($myconfig{email});
-
- $form->{OUT} = "$sendmail";
-
- }
-
- AM->backup(\%myconfig, \%$form, $userspath);
-
- if ($form->{media} eq 'email') {
- $form->redirect($locale->text('Backup sent to') . qq| $myconfig{email}|);
- }
-
- $lxdebug->leave_sub();
-}
-
sub audit_control {
$lxdebug->enter_sub();
<form method=post action=$form->{script}>
-<input type=hidden name=path value=$form->{path}>
<input type=hidden name=login value=$form->{login}>
<input type=hidden name=password value=$form->{password}>
$lxdebug->leave_sub();
}
-sub add_warehouse {
+sub edit_units {
$lxdebug->enter_sub();
- $form->{title} = "Add";
-
- $form->{callback} =
- "$form->{script}?action=add_warehouse&path=$form->{path}&login=$form->{login}&password=$form->{password}"
- unless $form->{callback};
-
- &warehouse_header;
- &form_footer;
-
- $lxdebug->leave_sub();
-}
-
-sub edit_warehouse {
- $lxdebug->enter_sub();
+ $units = AM->retrieve_units(\%myconfig, $form, $form->{"unit_type"}, "resolved_");
+ AM->units_in_use(\%myconfig, $form, $units);
+ map({ $units->{$_}->{"BASE_UNIT_DDBOX"} = AM->unit_select_data($units, $units->{$_}->{"base_unit"}, 1); } keys(%{$units}));
+
+ @languages = AM->language(\%myconfig, $form, 1);
+
+ @unit_list = sort({ $a->{"sortkey"} <=> $b->{"sortkey"} } values(%{$units}));
+
+ my $i = 1;
+ foreach (@unit_list) {
+ $_->{"factor"} = $form->format_amount(\%myconfig, $_->{"factor"} * 1) if ($_->{"factor"});
+ $_->{"UNITLANGUAGES"} = [];
+ foreach my $lang (@languages) {
+ push(@{ $_->{"UNITLANGUAGES"} },
+ { "idx" => $i,
+ "unit" => $_->{"name"},
+ "language_id" => $lang->{"id"},
+ "localized" => $_->{"LANGUAGES"}->{$lang->{"template_code"}}->{"localized"},
+ "localized_plural" => $_->{"LANGUAGES"}->{$lang->{"template_code"}}->{"localized_plural"},
+ });
+ }
+ $i++;
+ }
- $form->{title} = "Edit";
+ $units = AM->retrieve_units(\%myconfig, $form, $form->{"unit_type"});
+ $ddbox = AM->unit_select_data($units, undef, 1);
- AM->get_warehouse(\%myconfig, \%$form);
+ my $updownlink = build_std_url("action=swap_units", "unit_type");
- &warehouse_header;
- &form_footer;
+ $form->{"title"} = sprintf($locale->text("Add and edit %s"), $form->{"unit_type"} eq "dimension" ? $locale->text("dimension units") : $locale->text("service units"));
+ $form->header();
+ print($form->parse_html_template("am/edit_units",
+ { "UNITS" => \@unit_list,
+ "NEW_BASE_UNIT_DDBOX" => $ddbox,
+ "LANGUAGES" => \@languages,
+ "updownlink" => $updownlink }));
$lxdebug->leave_sub();
}
-sub list_warehouse {
+sub add_unit {
$lxdebug->enter_sub();
- AM->warehouses(\%myconfig, \%$form);
-
- $form->{callback} =
- "$form->{script}?action=list_warehouse&path=$form->{path}&login=$form->{login}&password=$form->{password}";
-
- $callback = $form->escape($form->{callback});
-
- $form->{title} = $locale->text('Warehouses');
-
- @column_index = qw(description);
-
- $column_header{description} =
- qq|<th class=listheading width=100%>|
- . $locale->text('Description')
- . qq|</th>|;
-
- $form->header;
-
- print qq|
-<body>
-
-<table width=100%>
- <tr>
- <th class=listtop>$form->{title}</th>
- </tr>
- <tr height="5"></tr>
- <tr>
- <td>
- <table width=100%>
- <tr class=listheading>
-|;
-
- map { print "$column_header{$_}\n" } @column_index;
-
- print qq|
- </tr>
-|;
-
- foreach $ref (@{ $form->{ALL} }) {
-
- $i++;
- $i %= 2;
-
- print qq|
- <tr valign=top class=listrow$i>
-|;
-
- $column_data{description} =
- qq|<td><a href=$form->{script}?action=edit_warehouse&id=$ref->{id}&path=$form->{path}&login=$form->{login}&password=$form->{password}&callback=$callback>$ref->{description}</td>|;
+ $form->isblank("new_name", $locale->text("The name is missing."));
+ $units = AM->retrieve_units(\%myconfig, $form, $form->{"unit_type"});
+ $all_units = AM->retrieve_units(\%myconfig, $form);
+ $form->show_generic_error($locale->text("A unit with this name does already exist.")) if ($all_units->{$form->{"new_name"}});
- map { print "$column_data{$_}\n" } @column_index;
+ my ($base_unit, $factor);
+ if ($form->{"new_base_unit"}) {
+ $form->show_generic_error($locale->text("The base unit does not exist.")) unless (defined($units->{$form->{"new_base_unit"}}));
- print qq|
- </tr>
-|;
+ $form->isblank("new_factor", $locale->text("The factor is missing."));
+ $factor = $form->parse_amount(\%myconfig, $form->{"new_factor"});
+ $form->show_generic_error($locale->text("The factor is missing.")) unless ($factor);
+ $base_unit = $form->{"new_base_unit"};
}
- print qq|
- </table>
- </td>
- </tr>
- <tr>
- <td><hr size=3 noshade></td>
- </tr>
-</table>
+ my @languages;
+ foreach my $lang (AM->language(\%myconfig, $form, 1)) {
+ next unless ($form->{"new_localized_$lang->{id}"} || $form->{"new_localized_plural_$lang->{id}"});
+ push(@languages, { "id" => $lang->{"id"},
+ "localized" => $form->{"new_localized_$lang->{id}"},
+ "localized_plural" => $form->{"new_localized_plural_$lang->{id}"},
+ });
+ }
-<br>
-<form method=post action=$form->{script}>
+ AM->add_unit(\%myconfig, $form, $form->{"new_name"}, $base_unit, $factor, $form->{"unit_type"}, \@languages);
-<input name=callback type=hidden value="$form->{callback}">
+ $form->{"saved_message"} = $locale->text("The unit has been saved.");
-<input type=hidden name=type value=warehouse>
+ edit_units();
-<input type=hidden name=path value=$form->{path}>
-<input type=hidden name=login value=$form->{login}>
-<input type=hidden name=password value=$form->{password}>
+ $lxdebug->leave_sub();
+}
-<input class=submit type=submit name=action value="|
- . $locale->text('Add') . qq|">|;
+sub set_unit_languages {
+ $lxdebug->enter_sub();
- if ($form->{menubar}) {
- require "$form->{path}/menu.pl";
- &menubar;
- }
+ my ($unit, $languages, $idx) = @_;
- print qq|
- </form>
+ $unit->{"LANGUAGES"} = [];
- </body>
- </html>
-|;
+ foreach my $lang (@{$languages}) {
+ push(@{ $unit->{"LANGUAGES"} },
+ { "id" => $lang->{"id"},
+ "localized" => $form->{"localized_${idx}_$lang->{id}"},
+ "localized_plural" => $form->{"localized_plural_${idx}_$lang->{id}"},
+ });
+ }
$lxdebug->leave_sub();
}
-sub warehouse_header {
+sub save_unit {
$lxdebug->enter_sub();
- $form->{title} = $locale->text("$form->{title} Warehouse");
+ $old_units = AM->retrieve_units(\%myconfig, $form, $form->{"unit_type"}, "resolved_");
+ AM->units_in_use(\%myconfig, $form, $old_units);
- # $locale->text('Add Warehouse')
- # $locale->text('Edit Warehouse')
+ @languages = AM->language(\%myconfig, $form, 1);
- $form->{description} =~ s/\"/"/g;
+ $new_units = {};
+ @delete_units = ();
+ foreach $i (1..($form->{"rowcount"} * 1)) {
+ $old_unit = $old_units->{$form->{"old_name_$i"}};
+ if (!$old_unit) {
+ $form->show_generic_error(sprintf($locale->text("The unit in row %d has been deleted in the meantime."), $i));
+ }
- if (($rows = $form->numtextrows($form->{description}, 60)) > 1) {
- $description =
- qq|<textarea name="description" rows=$rows cols=60 wrap=soft>$form->{description}</textarea>|;
- } else {
- $description =
- qq|<input name=description size=60 value="$form->{description}">|;
- }
+ if ($form->{"unchangeable_$i"}) {
+ $new_units->{$form->{"old_name_$i"}} = $old_units->{$form->{"old_name_$i"}};
+ $new_units->{$form->{"old_name_$i"}}->{"unchanged_unit"} = 1;
+ set_unit_languages($new_units->{$form->{"old_name_$i"}}, \@languages, $i);
+ next;
+ }
- $form->header;
+ if ($old_unit->{"in_use"}) {
+ $form->show_generic_error(sprintf($locale->text("The unit in row %d has been used in the meantime and cannot be changed anymore."), $i));
+ }
- print qq|
-<body>
+ if ($form->{"delete_$i"}) {
+ push(@delete_units, $old_unit->{"name"});
+ next;
+ }
-<form method=post action=$form->{script}>
+ $form->isblank("name_$i", sprintf($locale->text("The name is missing in row %d."), $i));
-<input type=hidden name=id value=$form->{id}>
-<input type=hidden name=type value=warehouse>
+ $form->show_generic_error(sprintf($locale->text("The name in row %d has already been used before."), $i)) if ($new_units->{$form->{"name_$i"}});
+ my %h = map({ $_ => $form->{"${_}_$i"} } qw(name base_unit factor old_name));
+ $new_units->{$form->{"name_$i"}} = \%h;
+ $new_units->{$form->{"name_$i"}}->{"row"} = $i;
+ set_unit_languages($new_units->{$form->{"old_name_$i"}}, \@languages, $i);
+ }
-<table width=100%>
- <tr>
- <th class=listtop colspan=2>$form->{title}</th>
- </tr>
- <tr height="5"></tr>
- <tr>
- <th align=right>| . $locale->text('Description') . qq|</th>
- <td>$description</td>
- </tr>
- <tr>
- <td colspan=2><hr size=3 noshade></td>
- </tr>
-</table>
-|;
+ foreach $unit (values(%{$new_units})) {
+ next unless ($unit->{"old_name"});
+ if ($unit->{"base_unit"}) {
+ $form->show_generic_error(sprintf($locale->text("The base unit does not exist or it is about to be deleted in row %d."), $unit->{"row"}))
+ unless (defined($new_units->{$unit->{"base_unit"}}));
+ $unit->{"factor"} = $form->parse_amount(\%myconfig, $unit->{"factor"});
+ $form->show_generic_error(sprintf($locale->text("The factor is missing in row %d."), $unit->{"row"})) unless ($unit->{"factor"} >= 1.0);
+ } else {
+ $unit->{"base_unit"} = undef;
+ $unit->{"factor"} = undef;
+ }
+ }
- $lxdebug->leave_sub();
-}
+ foreach $unit (values(%{$new_units})) {
+ next if ($unit->{"unchanged_unit"});
+
+ map({ $_->{"seen"} = 0; } values(%{$new_units}));
+ $new_unit = $unit;
+ while ($new_unit->{"base_unit"}) {
+ $new_unit->{"seen"} = 1;
+ $new_unit = $new_units->{$new_unit->{"base_unit"}};
+ if ($new_unit->{"seen"}) {
+ $form->show_generic_error(sprintf($locale->text("The base unit relations must not contain loops (e.g. by saying that unit A's base unit is B, " .
+ "B's base unit is C and C's base unit is A) in row %d."), $unit->{"row"}));
+ }
+ }
+ }
-sub save_warehouse {
- $lxdebug->enter_sub();
+ AM->save_units(\%myconfig, $form, $form->{"unit_type"}, $new_units, \@delete_units);
- $form->isblank("description", $locale->text('Description missing!'));
- AM->save_warehouse(\%myconfig, \%$form);
- $form->redirect($locale->text('Warehouse saved!'));
+ $form->{"saved_message"} = $locale->text("The units have been saved.");
+
+ edit_units();
$lxdebug->leave_sub();
}
-sub delete_warehouse {
- $lxdebug->enter_sub();
+sub show_history_search {
+ $lxdebug->enter_sub();
+
+ $form->{title} = $locale->text("History Search");
+ $form->header();
+
+ print $form->parse_html_template("/common/search_history");
+
+ $lxdebug->leave_sub();
+}
- AM->delete_warehouse(\%myconfig, \%$form);
- $form->redirect($locale->text('Warehouse deleted!'));
+sub show_am_history {
+ $lxdebug->enter_sub();
+ my %search = ( "Artikelnummer" => "parts",
+ "Kundennummer" => "customer",
+ "Lieferantennummer" => "vendor",
+ "Projektnummer" => "project",
+ "Buchungsnummer" => "oe",
+ "Eingangsrechnungnummer" => "ap",
+ "Ausgangsrechnungnummer" => "ar",
+ "Mahnungsnummer" => "dunning"
+ );
+ my %searchNo = ( "Artikelnummer" => "partnumber",
+ "Kundennummer" => "customernumber",
+ "Lieferantennummer" => "vendornumber",
+ "Projektnummer" => "projectnummer",
+ "Buchungsnummer" => "ordnumber",
+ "Eingangsrechnungnummer" => "invnumber",
+ "Ausgangsrechnungnummer" => "invnumber",
+ "Mahnungsnummer" => "dunning_id"
+ );
+
+ my $restriction;
+ my $tempNo = 0;
+ foreach(split(/\,/, $form->{einschraenkungen})) {
+ if($tempNo == 0) {
+ $restriction .= " AND addition = '" . $_ . "'";
+ $tempNo = 1;
+ }
+ else {
+ $restriction .= " OR addition = '" . $_ . "'";
+ }
+ }
+
+ $restriction .= (($form->{transdate} ne "" && $form->{reqdate} ne "")
+ ? qq| AND st.itime::date >= '| . $form->{transdate} . qq|' AND st.itime::date <= '| . $form->{reqdate} . qq|'|
+ : (($form->{transdate} ne "" && $form->{reqdate} eq "")
+ ? qq| AND st.itime::date >= '| . $form->{transdate} . qq|'|
+ : ($form->{transdate} eq "" && $form->{reqdate} ne "")
+ ? qq| AND st.itime::date <= '| . $form->{reqdate} . qq|'|
+ : ""
+ )
+ );
+
+ my $dbh = $form->dbconnect(\%myconfig);
+ my $searchSNumber = $searchNo{$form->{'what2search'}} . qq|_| . $form->{'searchid'};
+ $restriction .= ($form->{mitarbeiter} eq "" ? ""
+ : ($form->{mitarbeiter} =~ /^[0-9]*$/
+ ? " AND employee_id = " . $form->{mitarbeiter}
+ : " AND employee_id = " . &get_employee_id($form->{mitarbeiter}, $dbh)));
+ my $query = qq|SELECT trans_id AS id FROM history_erp WHERE sNumbers = '$searchSNumber' |;
+
+ my $sth = $dbh->prepare($query);
+
+ $sth->execute() || $form->dberror($query);
+
+ if($sth->fetch() <= 0) {
+ $sth->finish();
+ my $query = qq|SELECT id FROM $search{$form->{what2search}}
+ WHERE $searchNo{$form->{'what2search'}} ILIKE '$form->{"searchid"}'
+ |;
+ }
+ $sth->execute() || $form->dberror($query);
+ $form->{title} = $locale->text("History Search");
+ $form->header();
+ my $daten = "";
+ while(my $hash_ref = $sth->fetchrow_hashref()){
+ $daten = $form->get_history($dbh,$hash_ref->{id},$restriction);
+ }
+ $dbh->disconnect();
+ print $form->parse_html_template("/common/show_history",
+ {"DATEN" => $daten,
+ "SUCCESS" => ($daten != 0 ? 1 : 0),
+ "NONEWWINDOW" => 1
+ });
+ $lxdebug->leave_sub();
+}
- $lxdebug->leave_sub();
+sub get_employee_id {
+ $lxdebug->enter_sub();
+ my $query = qq|SELECT id FROM employee WHERE name = '| . $_[0] . qq|'|;
+ my $sth = $_[1]->prepare($query);
+ $sth->execute() || $form->dberror($query);
+ my $return = $sth->fetch();
+ $sth->finish();
+ return ${$return}[0];
+ $lxdebug->leave_sub();
}
-sub continue {
+sub swap_units {
$lxdebug->enter_sub();
- &{ $form->{nextsub} };
+ my $dir = $form->{"dir"} eq "down" ? "down" : "up";
+ my $unit_type = $form->{"unit_type"} eq "dimension" ?
+ "dimension" : "service";
+ AM->swap_units(\%myconfig, $form, $dir, $form->{"name"}, $unit_type);
+
+ edit_units();
$lxdebug->leave_sub();
}
projects / kivitendo-erp.git / blobdiff