diff options
Diffstat (limited to 'sql-ledger/bin/mozilla/am.pl')
| -rw-r--r-- | sql-ledger/bin/mozilla/am.pl | 1805 |
1 files changed, 1574 insertions, 231 deletions
diff --git a/sql-ledger/bin/mozilla/am.pl b/sql-ledger/bin/mozilla/am.pl index 7e36cfdc9..834290343 100644 --- a/sql-ledger/bin/mozilla/am.pl +++ b/sql-ledger/bin/mozilla/am.pl @@ -1,6 +1,6 @@ #===================================================================== # SQL-Ledger Accounting -# Copyright (c) 1998-2002 +# Copyright (c) 2001 # # Author: Dieter Simader # Email: dsimader@sql-ledger.org @@ -30,6 +30,8 @@ use SL::AM; use SL::CA; use SL::Form; use SL::User; +use SL::RP; +use SL::GL; 1; @@ -37,42 +39,54 @@ use SL::User; -sub add { +sub add { &{ "add_$form->{type}" } }; +sub edit { &{ "edit_$form->{type}" } }; +sub save { &{ "save_$form->{type}" } }; +sub delete { &{ "delete_$form->{type}" } }; + + +sub save_as_new { + + delete $form->{id}; + + &save; + +} + +sub add_account { + $form->{title} = "Add"; $form->{charttype} = "A"; - $form->{callback} = "$form->{script}?action=list&path=$form->{path}&login=$form->{login}&password=$form->{password}" unless $form->{callback}; + $form->{callback} = "$form->{script}?action=list_account&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}" unless $form->{callback}; - &form_header; + &account_header; &form_footer; } -sub edit { +sub edit_account { + $form->{title} = "Edit"; - - # if it is a template - if ($form->{file}) { - $form->{type} = "template"; - &edit_template; - exit; - } - + + $form->{accno} =~ s/\\'/'/g; + $form->{accno} =~ s/\\\\/\\/g; + AM->get_account(\%myconfig, \%$form); foreach my $item (split(/:/, $form->{link})) { $form->{$item} = "checked"; } - &form_header; + &account_header; &form_footer; } -sub form_header { +sub account_header { $form->{title} = $locale->text("$form->{title} Account"); @@ -80,7 +94,7 @@ sub form_header { $checked{"$form->{category}_"} = "checked"; $checked{CT_tax} = ($form->{CT_tax}) ? "" : "checked"; - $form->{description} =~ s/"/"/g; + map { $form->{$_} = $form->quote($form->{$_}) } qw(accno description); # this is for our parser only! # type=submit $locale->text('Add Account') @@ -102,8 +116,6 @@ sub form_header { <input type=hidden name=fxgain_accno_id values=$form->{fxgain_accno_id}> <input type=hidden name=fxloss_accno_id values=$form->{fxloss_accno_id}> -<input type=hidden name=amount value=$form->{amount}> - <table border=0 width=100%> <tr> <th class=listtop>$form->{title}</th> @@ -114,7 +126,7 @@ sub form_header { <table> <tr> <th align=right>|.$locale->text('Account Number').qq|</th> - <td><input name=accno size=20 value=$form->{accno}></td> + <td><input name=accno size=20 value="$form->{accno}"></td> </tr> <tr> <th align=right>|.$locale->text('Description').qq|</th> @@ -126,11 +138,13 @@ sub form_header { <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=C $checked{C_}> |.$locale->text('Contra').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=Q $checked{Q_}> |.$locale->text('Equity').qq|\n<br> <input name=category type=radio class=radio value=I $checked{I_}> |.$locale->text('Income').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') @@ -169,31 +183,32 @@ if ($form->{charttype} eq "A") { <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> + <th align=left>|.$locale->text('Labor/Overhead').qq|</th> </tr> <tr> <td> <input name=AR_amount type=checkbox class=checkbox value=AR_amount $form->{AR_amount}> |.$locale->text('Income').qq|\n<br> <input name=AR_paid type=checkbox class=checkbox value=AR_paid $form->{AR_paid}> |.$locale->text('Payment').qq|\n<br> - <input name=AR_tax type=checkbox class=checkbox value=AR_tax $form->{AR_tax}> |.$locale->text('Tax') - .qq| + <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| + <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('Sales').qq|\n<br> + <input name=IC_sale type=checkbox class=checkbox value=IC_sale $form->{IC_sale}> |.$locale->text('Income').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| + <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('Income').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| + <input name=IC_taxservice type=checkbox class=checkbox value=IC_taxservice $form->{IC_taxservice}> |.$locale->text('Tax') .qq| + </td> + <td> + <br> + <input name=IC_cogs type=checkbox class=checkbox value=IC_cogs $form->{IC_cogs}> |.$locale->text('COGS').qq|\n<br> </td> </tr> </table> @@ -241,16 +256,27 @@ sub form_footer { <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 type=hidden name=sessionid value=$form->{sessionid}> <br> <input type=submit class=submit name=action value="|.$locale->text('Save').qq|"> |; if ($form->{id}) { + print qq| +<input type=submit class=submit name=action value="|.$locale->text('Save as new').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> @@ -260,37 +286,57 @@ sub form_footer { } - -sub save { &{ "save_$form->{type}" } }; sub save_account { $form->isblank("accno", $locale->text('Account Number missing!')); $form->isblank("category", $locale->text('Account Type missing!')); + # check for conflicting accounts + if ($form->{AR} || $form->{AP} || $form->{IC}) { + map { $a .= $form->{$_} } qw(AR AP IC); + $form->error($locale->text('Cannot set account for more than one of AR, AP or IC')) if length $a > 2; + + map { $form->error("$form->{AR}$form->{AP}$form->{IC} ". $locale->text('account cannot be set to any other type of account')) if $form->{$_} } qw(AR_amount AR_tax AR_paid AP_amount AP_tax AP_paid IC_sale IC_cogs IC_taxpart IC_income IC_expense IC_taxservice); + } + + foreach $item ("AR", "AP") { + $i = 0; + map { $i++ if $form->{$_} } ("${item}_amount", "${item}_paid", "${item}_tax"); + $form->error($locale->text('Cannot set multiple options for')." $item") if $i > 1; + } + + $i = 0; + map { $i++ if $form->{$_} } qw(IC_sale IC_cogs IC_taxpart); + $form->error($locale->text('Cannot set multiple options for Parts Inventory')) if $i > 1; + + $i = 0; + map { $i++ if $form->{$_} } qw(IC_income IC_expense IC_taxservice); + $form->error($locale->text('Cannot set multiple options for Service Items')) if $i > 1; + $form->redirect($locale->text('Account saved!')) if (AM->save_account(\%myconfig, \%$form)); $form->error($locale->text('Cannot save account!')); } -sub list { +sub list_account { CA->all_accounts(\%myconfig, \%$form); $form->{title} = $locale->text('Chart of Accounts'); # construct callback - $callback = "$form->{script}?action=list&path=$form->{path}&login=$form->{login}&password=$form->{password}"; + $callback = "$form->{script}?action=list_account&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}"; @column_index = qw(accno gifi_accno description debit credit link); - $column_header{accno} = qq|<th class=listheading>|.$locale->text('Account').qq|</a></th>|; - $column_header{gifi_accno} = qq|<th class=listheading>|.$locale->text('GIFI').qq|</a></th>|; - $column_header{description} = qq|<th class=listheading>|.$locale->text('Description').qq|</a></th>|; - $column_header{debit} = qq|<th class=listheading>|.$locale->text('Debit').qq|</a></th>|; - $column_header{credit} = qq|<th class=listheading>|.$locale->text('Credit').qq|</a></th>|; - $column_header{link} = qq|<th class=listheading>|.$locale->text('Link').qq|</a></th>|; + $column_header{accno} = qq|<th class=listtop>|.$locale->text('Account').qq|</a></th>|; + $column_header{gifi_accno} = qq|<th class=listtop>|.$locale->text('GIFI').qq|</a></th>|; + $column_header{description} = qq|<th class=listtop>|.$locale->text('Description').qq|</a></th>|; + $column_header{debit} = qq|<th class=listtop>|.$locale->text('Debit').qq|</a></th>|; + $column_header{credit} = qq|<th class=listtop>|.$locale->text('Credit').qq|</a></th>|; + $column_header{link} = qq|<th class=listtop>|.$locale->text('Link').qq|</a></th>|; $form->header; @@ -299,8 +345,10 @@ sub list { print qq| <body> -<table border=0 width=100%> - <tr><th class=listtop colspan=$colspan>$form->{title}</th></tr> +<table width=100%> + <tr> + <th class=listtop colspan=$colspan>$form->{title}</th> + </tr> <tr height=5></tr> <tr class=listheading> |; @@ -319,15 +367,10 @@ sub list { $ca->{debit} = " "; $ca->{credit} = " "; - # needed if we can delete an account - $amount = 0; - if ($ca->{amount} > 0) { - $amount = $ca->{amount}; $ca->{credit} = $form->format_amount(\%myconfig, $ca->{amount}, 2, " "); } if ($ca->{amount} < 0) { - $amount = -$ca->{amount}; $ca->{debit} = $form->format_amount(\%myconfig, -$ca->{amount}, 2, " "); } @@ -336,8 +379,8 @@ sub list { if ($ca->{charttype} eq "H") { print qq|<tr class=listheading>|; - $column_data{accno} = qq|<th><a class=listheading href=$form->{script}?action=edit&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 class=listheading 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{accno} = qq|<th><a class=listheading href=$form->{script}?action=edit_account&id=$ca->{id}&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}&callback=$callback>$ca->{accno}</a></th>|; + $column_data{gifi_accno} = qq|<th class=listheading><a href=$form->{script}?action=edit_gifi&accno=$ca->{gifi_accno}&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}&callback=$callback>$ca->{gifi_accno}</a> </th>|; $column_data{description} = qq|<th class=listheading>$ca->{description} </th>|; $column_data{debit} = qq|<th> </th>|; $column_data{credit} = qq| <th> </th>|; @@ -347,8 +390,8 @@ sub list { $i++; $i %= 2; print qq| <tr valign=top class=listrow$i>|; - $column_data{accno} = qq|<td><a href=$form->{script}?action=edit&id=$ca->{id}&path=$form->{path}&login=$form->{login}&password=$form->{password}&callback=$callback&amount=$amount>$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&amount=$amount>$ca->{gifi_accno}</a> </td>|; + $column_data{accno} = qq|<td><a href=$form->{script}?action=edit_account&id=$ca->{id}&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}&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}&sessionid=$form->{sessionid}&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>|; @@ -372,16 +415,10 @@ sub list { } -sub delete { &{ "delete_$form->{type}" } }; - sub delete_account { $form->{title} = $locale->text('Delete Account'); - if ($form->{amount} != 0) { - $form->error($locale->text('Transactions exist; cannot delete account!')); - } - foreach $id (qw(inventory_accno_id income_accno_id expense_accno_id fxgain_accno_id fxloss_accno_id)) { if ($form->{id} == $form->{$id}) { $form->error($locale->text('Cannot delete default account!')); @@ -396,16 +433,15 @@ sub delete_account { sub list_gifi { - @{ $form->{fields} } = (accno, description); + @{ $form->{fields} } = qw(accno description); $form->{table} = "gifi"; - $form->{sortorder} = "accno"; AM->gifi_accounts(\%myconfig, \%$form); $form->{title} = $locale->text('GIFI'); # construct callback - $callback = "$form->{script}?action=list_gifi&path=$form->{path}&login=$form->{login}&password=$form->{password}"; + $callback = "$form->{script}?action=list_gifi&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}"; @column_index = qw(accno description); @@ -419,8 +455,10 @@ sub list_gifi { print qq| <body> -<table border=0 width=100%> - <tr><th class=listtop colspan=$colspan>$form->{title}</th></tr> +<table width=100%> + <tr> + <th class=listtop colspan=$colspan>$form->{title}</th> + </tr> <tr height="5"></tr> <tr class=listheading> |; @@ -441,7 +479,7 @@ sub list_gifi { print qq| <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{accno} = qq|<td><a href=$form->{script}?action=edit_gifi&coa=1&accno=$ca->{accno}&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}&callback=$callback>$ca->{accno}</td>|; $column_data{description} = qq|<td>$ca->{description} </td>|; map { print "$column_data{$_}\n" } @column_index; @@ -466,7 +504,7 @@ sub add_gifi { $form->{title} = "Add"; # construct callback - $form->{callback} = "$form->{script}?action=list_gifi&path=$form->{path}&login=$form->{login}&password=$form->{password}"; + $form->{callback} = "$form->{script}?action=list_gifi&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}"; $form->{coa} = 1; @@ -479,8 +517,10 @@ sub add_gifi { sub edit_gifi { $form->{title} = "Edit"; - + AM->get_gifi(\%myconfig, \%$form); + + $form->error($locale->text('Account does not exist!')) unless $form->{accno}; &gifi_header; &gifi_footer; @@ -495,7 +535,7 @@ sub gifi_header { # $locale->text('Add GIFI') # $locale->text('Edit GIFI') - $form->{description} =~ s/"/"/g; + map { $form->{$_} = $form->quote($form->{$_}) } qw(accno description); $form->header; @@ -504,7 +544,7 @@ sub gifi_header { <form method=post action=$form->{script}> -<input type=hidden name=id value=$form->{accno}> +<input type=hidden name=id value="$form->{accno}"> <input type=hidden name=type value=gifi> <table width=100%> @@ -517,7 +557,7 @@ sub gifi_header { <table> <tr> <th align=right>|.$locale->text('GIFI').qq|</th> - <td><input name=accno size=20 value=$form->{accno}></td> + <td><input name=accno size=20 value="$form->{accno}"></td> </tr> <tr> <th align=right>|.$locale->text('Description').qq|</th> @@ -543,23 +583,27 @@ sub gifi_footer { <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 type=hidden name=sessionid value=$form->{sessionid}> -<br><input type=submit class=submit name=action value="|.$locale->text('Save').qq|"> -|; +<br><input type=submit class=submit name=action value="|.$locale->text('Save').qq|">|; if ($form->{coa}) { print qq| <input type=submit class=submit name=action value="|.$locale->text('Copy to COA').qq|"> |; - if ($form->{accno}) { + 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; + } + print qq| -</form> + </form> </body> </html> @@ -585,10 +629,11 @@ sub copy_to_coa { delete $form->{id}; $form->{gifi_accno} = $form->{accno}; + $form->{title} = "Add"; $form->{charttype} = "A"; - &form_header; + &account_header; &form_footer; } @@ -602,6 +647,775 @@ sub delete_gifi { } +sub add_department { + + $form->{title} = "Add"; + $form->{role} = "P"; + + $form->{callback} = "$form->{script}?action=add_department&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}" unless $form->{callback}; + + &department_header; + &form_footer; + +} + + +sub edit_department { + + $form->{title} = "Edit"; + + AM->get_department(\%myconfig, \%$form); + + &department_header; + &form_footer; + +} + + +sub list_department { + + AM->departments(\%myconfig, \%$form); + + $href = "$form->{script}?action=list_department&direction=$form->{direction}&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}"; + + $form->sort_order(); + + $form->{callback} = "$form->{script}?action=list_department&direction=$form->{direction}&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}"; + + $callback = $form->escape($form->{callback}); + + $form->{title} = $locale->text('Departments'); + + @column_index = qw(description cost profit); + + $column_header{description} = qq|<th width=90%><a class=listheading href=$href>|.$locale->text('Description').qq|</a></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; + + 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> +|; + + $costcenter = ($ref->{role} eq "C") ? "*" : " "; + $profitcenter = ($ref->{role} eq "P") ? "*" : " "; + + $column_data{description} = qq|<td><a href=$form->{script}?action=edit_department&id=$ref->{id}&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}&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 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=department> + +<input type=hidden name=path value=$form->{path}> +<input type=hidden name=login value=$form->{login}> +<input type=hidden name=sessionid value=$form->{sessionid}> + +<input class=submit type=submit name=action value="|.$locale->text('Add Department').qq|">|; + + if ($form->{menubar}) { + require "$form->{path}/menu.pl"; + &menubar; + } + + print qq| + </form> + + </body> + </html> +|; + +} + + +sub department_header { + + $form->{title} = $locale->text("$form->{title} Department"); + +# $locale->text('Add Department') +# $locale->text('Edit Department') + + $form->{description} = $form->quote($form->{description}); + + 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> +|; + +} + + +sub save_department { + + $form->isblank("description", $locale->text('Description missing!')); + AM->save_department(\%myconfig, \%$form); + $form->redirect($locale->text('Department saved!')); + +} + + +sub delete_department { + + AM->delete_department(\%myconfig, \%$form); + $form->redirect($locale->text('Department deleted!')); + +} + + +sub add_business { + + $form->{title} = "Add"; + + $form->{callback} = "$form->{script}?action=add_business&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}" unless $form->{callback}; + + &business_header; + &form_footer; + +} + + +sub edit_business { + + $form->{title} = "Edit"; + + AM->get_business(\%myconfig, \%$form); + + &business_header; + + $form->{orphaned} = 1; + &form_footer; + +} + + +sub list_business { + + AM->business(\%myconfig, \%$form); + + $href = "$form->{script}?action=list_business&direction=$form->{direction}&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}"; + + $form->sort_order(); + + $form->{callback} = "$form->{script}?action=list_business&direction=$form->{direction}&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}"; + + $callback = $form->escape($form->{callback}); + + $form->{title} = $locale->text('Type of Business'); + + @column_index = qw(description discount); + + $column_header{description} = qq|<th width=90%><a class=listheading href=$href>|.$locale->text('Description').qq|</a></th>|; + $column_header{discount} = qq|<th class=listheading>|.$locale->text('Discount').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, 2, " "); + + $column_data{description} = qq|<td><a href=$form->{script}?action=edit_business&id=$ref->{id}&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}&callback=$callback>$ref->{description}</td>|; + $column_data{discount} = qq|<td align=right>$discount</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=business> + +<input type=hidden name=path value=$form->{path}> +<input type=hidden name=login value=$form->{login}> +<input type=hidden name=sessionid value=$form->{sessionid}> + +<input class=submit type=submit name=action value="|.$locale->text('Add Business').qq|">|; + + if ($form->{menubar}) { + require "$form->{path}/menu.pl"; + &menubar; + } + + print qq| + + </form> + + </body> + </html> +|; + +} + + +sub business_header { + + $form->{title} = $locale->text("$form->{title} Business"); + +# $locale->text('Add Business') +# $locale->text('Edit Business') + + $form->{description} = $form->quote($form->{description}); + $form->{discount} = $form->format_amount(\%myconfig, $form->{discount} * 100); + + $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=business> + +<table width=100%> + <tr> + <th class=listtop>$form->{title}</th> + </tr> + <tr height="5"></tr> + <tr> + <td> + <table> + <tr> + <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> + </table> + </td> + </tr> + <tr> + <td><hr size=3 noshade></td> + </tr> +</table> +|; + +} + + +sub save_business { + + $form->isblank("description", $locale->text('Description missing!')); + AM->save_business(\%myconfig, \%$form); + $form->redirect($locale->text('Business saved!')); + +} + + +sub delete_business { + + AM->delete_business(\%myconfig, \%$form); + $form->redirect($locale->text('Business deleted!')); + +} + + + +sub add_sic { + + $form->{title} = "Add"; + + $form->{callback} = "$form->{script}?action=add_sic&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}" unless $form->{callback}; + + &sic_header; + &form_footer; + +} + + +sub edit_sic { + + $form->{title} = "Edit"; + + $form->{code} =~ s/\\'/'/g; + $form->{code} =~ s/\\\\/\\/g; + + AM->get_sic(\%myconfig, \%$form); + $form->{id} = $form->{code}; + + &sic_header; + + $form->{orphaned} = 1; + &form_footer; + +} + + +sub list_sic { + + AM->sic(\%myconfig, \%$form); + + $href = "$form->{script}?action=list_sic&direction=$form->{direction}&oldsort=$form->{oldsort}&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}"; + + $form->sort_order(); + + $form->{callback} = "$form->{script}?action=list_sic&direction=$form->{direction}&oldsort=$form->{oldsort}&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}"; + + $callback = $form->escape($form->{callback}); + + $form->{title} = $locale->text('Standard Industrial Codes'); + + @column_index = $form->sort_columns(qw(code description)); + + $column_header{code} = qq|<th><a class=listheading href=$href&sort=code>|.$locale->text('Code').qq|</a></th>|; + $column_header{description} = qq|<th><a class=listheading href=$href&sort=description>|.$locale->text('Description').qq|</a></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; + + 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}&sessionid=$form->{sessionid}&callback=$callback>$ref->{code}</th>|; + $column_data{description} = qq|<th>$ref->{description}</th>|; + + } else { + 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}&sessionid=$form->{sessionid}&callback=$callback>$ref->{code}</td>|; + $column_data{description} = qq|<td>$ref->{description}</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=sic> + +<input type=hidden name=path value=$form->{path}> +<input type=hidden name=login value=$form->{login}> +<input type=hidden name=sessionid value=$form->{sessionid}> + +<input class=submit type=submit name=action value="|.$locale->text('Add SIC').qq|">|; + + if ($form->{menubar}) { + require "$form->{path}/menu.pl"; + &menubar; + } + + print qq| + </form> + + </body> + </html> +|; + +} + + +sub sic_header { + + $form->{title} = $locale->text("$form->{title} SIC"); + +# $locale->text('Add SIC') +# $locale->text('Edit SIC') + + map { $form->{$_} = $form->quote($form->{$_}) } qw(code description); + + $checked = ($form->{sictype} eq 'H') ? "checked" : ""; + + $form->header; + + print qq| +<body> + +<form method=post action=$form->{script}> + +<input type=hidden name=type value=sic> +<input type=hidden name=id value="$form->{code}"> + +<table width=100%> + <tr> + <th class=listtop colspan=2>$form->{title}</th> + </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> + <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> + </tr> +</table> +|; + +} + + +sub save_sic { + + $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!')); + +} + + +sub delete_sic { + + AM->delete_sic(\%myconfig, \%$form); + $form->redirect($locale->text('SIC deleted!')); + +} + + +sub add_language { + + $form->{title} = "Add"; + + $form->{callback} = "$form->{script}?action=add_language&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}" unless $form->{callback}; + + &language_header; + &form_footer; + +} + + +sub edit_language { + + $form->{title} = "Edit"; + + $form->{code} =~ s/\\'/'/g; + $form->{code} =~ s/\\\\/\\/g; + + AM->get_language(\%myconfig, \%$form); + $form->{id} = $form->{code}; + + &language_header; + + $form->{orphaned} = 1; + &form_footer; + +} + + +sub list_language { + + AM->language(\%myconfig, \%$form); + + $href = "$form->{script}?action=list_language&direction=$form->{direction}&oldsort=$form->{oldsort}&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}"; + + $form->sort_order(); + + $form->{callback} = "$form->{script}?action=list_language&direction=$form->{direction}&oldsort=$form->{oldsort}&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}"; + + $callback = $form->escape($form->{callback}); + + $form->{title} = $locale->text('Languages'); + + @column_index = $form->sort_columns(qw(code description)); + + $column_header{code} = qq|<th><a class=listheading href=$href&sort=code>|.$locale->text('Code').qq|</a></th>|; + $column_header{description} = qq|<th><a class=listheading href=$href&sort=description>|.$locale->text('Description').qq|</a></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{code} = qq|<td><a href=$form->{script}?action=edit_language&code=$ref->{code}&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}&callback=$callback>$ref->{code}</td>|; + $column_data{description} = qq|<td>$ref->{description}</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=path value=$form->{path}> +<input type=hidden name=login value=$form->{login}> +<input type=hidden name=sessionid value=$form->{sessionid}> + +<input class=submit type=submit name=action value="|.$locale->text('Add Language').qq|">|; + + if ($form->{menubar}) { + require "$form->{path}/menu.pl"; + &menubar; + } + + print qq| + </form> + + </body> + </html> +|; + +} + + +sub language_header { + + $form->{title} = $locale->text("$form->{title} Language"); + +# $locale->text('Add Language') +# $locale->text('Edit Language') + + map { $form->{$_} = $form->quote($form->{$_}) } qw(code description); + + $form->header; + + print qq| +<body> + +<form method=post action=$form->{script}> + +<input type=hidden name=type value=language> +<input type=hidden name=id value="$form->{code}"> + +<table width=100%> + <tr> + <th class=listtop colspan=2>$form->{title}</th> + </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> + <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> + </tr> +</table> +|; + +} + + +sub save_language { + + $form->isblank("code", $locale->text('Code missing!')); + $form->isblank("description", $locale->text('Description missing!')); + AM->save_language(\%myconfig, \%$form); + $form->redirect($locale->text('Language saved!')); + +} + + +sub delete_language { + + AM->delete_language(\%myconfig, \%$form); + $form->redirect($locale->text('Language deleted!')); + +} + + sub display_stylesheet { $form->{file} = "css/$myconfig{stylesheet}"; @@ -612,7 +1426,7 @@ sub display_stylesheet { sub display_form { - $form->{file} =~ s/^(.:)*?\/|\.\.\///g; + $form->{file} =~ s/^(.:)*?\/|\.\.\///g; $form->{file} =~ s/^\/*//g; $form->{file} =~ s/$userspath//; @@ -637,14 +1451,21 @@ $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 type=hidden name=sessionid value=$form->{sessionid}> -<input name=action type=submit class=submit value="|.$locale->text('Edit').qq|"> -</form> +<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> @@ -674,18 +1495,24 @@ sub edit_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 type=hidden name=sessionid value=$form->{sessionid}> -<input name=callback type=hidden value="$form->{script}?action=display_form&file=$form->{file}&path=$form->{path}&login=$form->{login}&password=$form->{password}"> +<input name=callback type=hidden value="$form->{script}?action=display_form&file=$form->{file}&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}"> <textarea name=body rows=25 cols=70> $form->{body} </textarea> <br> -<input type=submit class=submit name=action value="|.$locale->text('Save').qq|"> +<input type=submit class=submit name=action value="|.$locale->text('Save').qq|">|; -</form> + if ($form->{menubar}) { + require "$form->{path}/menu.pl"; + &menubar; + } + + print q| + </form> </body> @@ -703,41 +1530,18 @@ sub save_template { } -sub config { - +sub defaults { + # get defaults for account numbers and last numbers AM->defaultaccounts(\%myconfig, \%$form); - foreach $item (qw(mm-dd-yy mm/dd/yy dd-mm-yy dd/mm/yy dd.mm.yy yyyy-mm-dd)) { - $dateformat .= ($item eq $myconfig{dateformat}) ? "<option selected>$item\n" : "<option>$item\n"; - } - - foreach $item (qw(1,000.00 1000.00 1.000,00 1000,00)) { - $numberformat .= ($item eq $myconfig{numberformat}) ? "<option selected>$item\n" : "<option>$item\n"; - } - - foreach $item (qw(name company address signature shippingpoint)) { - $myconfig{$item} =~ s/"/"/g; - } - - foreach $item (qw(address signature)) { - $myconfig{$item} =~ s/\\n/\r\n/g; - } - - %countrycodes = User->country_codes; - $countrycodes = ''; - foreach $key (sort { $countrycodes{$a} cmp $countrycodes{$b} } keys %countrycodes) { - $countrycodes .= ($myconfig{countrycode} eq $key) ? "<option selected value=$key>$countrycodes{$key}\n" : "<option value=$key>$countrycodes{$key}\n"; - } - $countrycodes = "<option>American English\n$countrycodes"; - foreach $key (keys %{ $form->{IC} }) { foreach $accno (sort keys %{ $form->{IC}{$key} }) { - $myconfig{$key} .= ($form->{IC}{$key}{$accno}{id} == $form->{defaults}{$key}) ? "<option selected>$accno--$form->{IC}{$key}{$accno}{description}\n" : "<option>$accno--$form->{IC}{$key}{$accno}{description}\n"; + $form->{account}{$key} .= ($form->{IC}{$key}{$accno}{id} == $form->{defaults}{$key}) ? "<option selected>$accno--$form->{IC}{$key}{$accno}{description}\n" : "<option>$accno--$form->{IC}{$key}{$accno}{description}\n"; } } - - $form->{title} = $locale->text('Edit Preferences for').qq| $form->{login}|; + + $form->{title} = $locale->text('System Defaults'); $form->header; @@ -746,173 +1550,319 @@ sub config { <form method=post action=$form->{script}> -<input type=hidden name=old_password value=$myconfig{password}> -<input type=hidden name=type value=preferences> +<input type=hidden name=type value=defaults> <table width=100%> <tr><th class=listtop>$form->{title}</th></tr> <tr> <td> <table> - <tr> - <th align=right>|.$locale->text('Name').qq|</th> - <td><input name=name size=15 value="$myconfig{name}"></td> + <tr> + <th align=right>|.$locale->text('Business Number').qq|</th> + <td><input name=businessnumber size=25 value="$form->{defaults}{businessnumber}"></td> </tr> <tr> - <th align=right>|.$locale->text('Password').qq|</th> - <td><input type=password name=password size=10 value=$myconfig{password}></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> + <th class=listheading>|.$locale->text('Last Numbers & Default Accounts').qq|</th> + </tr> + <tr> + <td> + <table> <tr> - <th align=right>|.$locale->text('E-mail').qq|</th> - <td><input name=email size=30 value="$myconfig{email}"></td> + <th align=right nowrap>|.$locale->text('Inventory Account').qq|</th> + <td><select name=inventory_accno>$form->{account}{IC}</select></td> </tr> - <tr valign=top> - <th align=right>|.$locale->text('Signature').qq|</th> - <td><textarea name=signature rows=3 cols=50>$myconfig{signature}</textarea></td> + <tr> + <th align=right nowrap>|.$locale->text('Income Account').qq|</th> + <td><select name=income_accno>$form->{account}{IC_income}</select></td> </tr> <tr> - <th align=right>|.$locale->text('Phone').qq|</th> - <td><input name=tel size=14 value="$myconfig{tel}"></td> + <th align=right nowrap>|.$locale->text('Expense Account').qq|</th> + <td><select name=expense_accno>$form->{account}{IC_expense}</select></td> </tr> <tr> - <th align=right>|.$locale->text('Fax').qq|</th> - <td><input name=fax size=14 value="$myconfig{fax}"></td> + <th align=right nowrap>|.$locale->text('Foreign Exchange Gain').qq|</th> + <td><select name=fxgain_accno>$form->{account}{FX_gain}</select></td> </tr> <tr> - <th align=right>|.$locale->text('Company').qq|</th> - <td><input name=company size=30 value="$myconfig{company}"></td> + <th align=right nowrap>|.$locale->text('Foreign Exchange Loss').qq|</th> + <td><select name=fxloss_accno>$form->{account}{FX_loss}</select></td> </tr> - <tr valign=top> - <th align=right>|.$locale->text('Address').qq|</th> - <td><textarea name=address rows=4 cols=50>$myconfig{address}</textarea></td> + </table> + </td> + </tr> + <tr> + <th align=left>|.$locale->text('Enter up to 3 letters separated by a colon (i.e CAD:USD:EUR) for your native and foreign currencies').qq|</th> + </tr> + <tr> + <td> + <input name=curr size=40 value="$form->{defaults}{curr}"> + </td> + </tr> + <tr> + <td> + <table> + <tr> + <th align=right nowrap>|.$locale->text('Sales Invoice Number').qq|</th> + <td><input name=sinumber size=40 value="$form->{defaults}{sinumber}"></td> </tr> <tr> - <th align=right>|.$locale->text('Date Format').qq|</th> - <td><select name=dateformat>$dateformat</select></td> + <th align=right nowrap>|.$locale->text('Sales Order Number').qq|</th> + <td><input name=sonumber size=40 value="$form->{defaults}{sonumber}"></td> </tr> <tr> - <th align=right>|.$locale->text('Number Format').qq|</th> - <td><select name=numberformat>$numberformat</select></td> + <th align=right nowrap>|.$locale->text('Vendor Invoice Number').qq|</th> + <td><input name=vinumber size=40 value="$form->{defaults}{vinumber}"></td> </tr> <tr> - <th align=right>|.$locale->text('Dropdown Limit').qq|</th> - <td><input name=vclimit size=10 value="$myconfig{vclimit}"></td> + <th align=right nowrap>|.$locale->text('Purchase Order Number').qq|</th> + <td><input name=ponumber size=40 value="$form->{defaults}{ponumber}"></td> </tr> <tr> - <th align=right>|.$locale->text('Language').qq|</th> - <td><select name=countrycode>$countrycodes</select></td> + <th align=right nowrap>|.$locale->text('Sales Quotation Number').qq|</th> + <td><input name=sqnumber size=40 value="$form->{defaults}{sqnumber}"></td> </tr> <tr> - <th align=right>|.$locale->text('Character Set').qq|</th> - <td><input name=charset size=20 value="$myconfig{charset}"></td> + <th align=right nowrap>|.$locale->text('RFQ Number').qq|</th> + <td><input name=rfqnumber size=40 value="$form->{defaults}{rfqnumber}"></td> </tr> <tr> - <th align=right>|.$locale->text('Stylesheet').qq|</th> - <td><input name=stylesheet size=20 value="$myconfig{stylesheet}"></td> + <th align=right nowrap>|.$locale->text('Partnumber').qq|</th> + <td><input name=partnumber size=40 value="$form->{defaults}{partnumber}"></td> </tr> - <input name=printer type=hidden value="$myconfig{printer}"> <tr> - <th align=right>|.$locale->text('Ship via').qq|</th> - <td><input name=shippingpoint size=25 value="$myconfig{shippingpoint}"></td> + <th align=right nowrap>|.$locale->text('Employee Number').qq|</th> + <td><input name=employeenumber size=40 value="$form->{defaults}{employeenumber}"></td> </tr> - <tr class=listheading> - <th colspan=2> </th> + <tr> + <th align=right nowrap>|.$locale->text('Customer Number').qq|</th> + <td><input name=customernumber size=40 value="$form->{defaults}{customernumber}"></td> </tr> <tr> - <th align=right>|.$locale->text('Business Number').qq|</th> - <td><input name=businessnumber size=25 value="$myconfig{businessnumber}"></td> + <th align=right nowrap>|.$locale->text('Vendor Number').qq|</th> + <td><input name=vendornumber size=40 value="$form->{defaults}{vendornumber}"></td> </tr> + </table> + </td> + </tr> + <tr> + <th class=listheading>|.$locale->text('Tax Accounts').qq|</th> + </tr> + <tr> + <td> + <table> <tr> - <td colspan=2> - <table width=100%> + <th></th> + <th>|.$locale->text('Rate').qq| (%)</th> + <th>|.$locale->text('Number').qq|</th> + </tr> +|; + + foreach $accno (sort keys %{ $form->{taxrates} }) { + $form->{taxrates}{$accno}{rate} = $form->format_amount(\%myconfig, $form->{taxrates}{$accno}{rate}); + + 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| + </table> + </td> + </tr> +<input name=taxaccounts type=hidden value="$form->{taxaccounts}"> + <tr> + <td><hr size=3 noshade></td> + </tr> +</table> + +<input type=hidden name=path value=$form->{path}> +<input type=hidden name=login value=$form->{login}> +<input type=hidden name=sessionid value=$form->{sessionid}> + +<br> +<input type=submit class=submit name=action value="|.$locale->text('Save').qq|">|; + + if ($form->{menubar}) { + require "$form->{path}/menu.pl"; + &menubar; + } + + print qq| + </form> + +</body> +</html> +|; + + +} + + +sub config { + + foreach $item (qw(mm-dd-yy mm/dd/yy dd-mm-yy dd/mm/yy dd.mm.yy yyyy-mm-dd)) { + $dateformat .= ($item eq $myconfig{dateformat}) ? "<option selected>$item\n" : "<option>$item\n"; + } + + foreach $item (qw(1,000.00 1000.00 1.000,00 1000,00 1'000.00)) { + $numberformat .= ($item eq $myconfig{numberformat}) ? "<option selected>$item\n" : "<option>$item\n"; + } + + map { $myconfig{$_} = $form->quote($myconfig{$_}) } qw(name company address signature); + map { $myconfig{$_} =~ s/\\n/\r\n/g } qw(address signature); + + %countrycodes = User->country_codes; + $countrycodes = ''; + + foreach $key (sort { $countrycodes{$a} cmp $countrycodes{$b} } keys %countrycodes) { + $countrycodes .= ($myconfig{countrycode} eq $key) ? "<option selected value=$key>$countrycodes{$key}\n" : "<option value=$key>$countrycodes{$key}\n"; + } + $countrycodes = qq|<option value="">English\n$countrycodes|; + + opendir CSS, "css/."; + @all = grep /.*\.css$/, readdir CSS; + closedir CSS; + + foreach $item (@all) { + if ($item eq $myconfig{stylesheet}) { + $selectstylesheet .= qq|<option selected>$item\n|; + } else { + $selectstylesheet .= qq|<option>$item\n|; + } + } + $selectstylesheet .= "<option>\n"; + + if (%printer && $latex) { + $selectprinter = "<option>\n"; + foreach $item (sort keys %printer) { + if ($myconfig{printer} eq $item) { + $selectprinter .= qq|<option value="$item" selected>$item\n|; + } else { + $selectprinter .= qq|<option value="$item">$item\n|; + } + } + + $printer = qq| + <tr> + <th align=right>|.$locale->text('Printer').qq|</th> + <td><select name=printer>$selectprinter</select></td> + </tr> +|; + } + + $form->{title} = $locale->text('Edit Preferences for').qq| $form->{login}|; + + $form->header; + + print qq| +<body> + +<form method=post action=$form->{script}> + +<input type=hidden name=old_password value=$myconfig{password}> +<input type=hidden name=type value=preferences> +<input type=hidden name=role value=$myconfig{role}> + +<table width=100%> + <tr><th class=listtop>$form->{title}</th></tr> + <tr> + <td> + <table width=100%> + <tr valign=top> + <td> + <table> + <tr> + <th align=right>|.$locale->text('Name').qq|</th> + <td><input name=name size=20 value="$myconfig{name}"></td> + </tr> + <tr> + <th align=right>|.$locale->text('E-mail').qq|</th> + <td><input name=email size=35 value="$myconfig{email}"></td> + </tr> + <tr valign=top> + <th align=right>|.$locale->text('Signature').qq|</th> + <td><textarea name=signature rows=3 cols=35>$myconfig{signature}</textarea></td> + </tr> + <tr> + <th align=right>|.$locale->text('Phone').qq|</th> + <td><input name=tel size=14 value="$myconfig{tel}"></td> + </tr> + <tr> + <th align=right>|.$locale->text('Fax').qq|</th> + <td><input name=fax size=14 value="$myconfig{fax}"></td> + </tr> <tr> - <th align=right>|.$locale->text('Year End').qq| (mm/dd)</th> - <td><input name=yearend size=5 maxsize=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> + <th align=right>|.$locale->text('Company').qq|</th> + <td><input name=company size=35 value="$myconfig{company}"></td> + </tr> + <tr valign=top> + <th align=right>|.$locale->text('Address').qq|</th> + <td><textarea name=address rows=4 cols=35>$myconfig{address}</textarea></td> </tr> </table> </td> - </tr> - <tr class=listheading> - <th class=listheading colspan=2>|.$locale->text('Last Numbers & Default Accounts').qq|</th> - </tr> - <tr> - <td colspan=2> - <table width=100%> + <td> + <table> <tr> - <th width=1% align=right nowrap>|.$locale->text('Inventory Account').qq|</th> - <td><select name=inventory_accno>$myconfig{IC}</select></td> + <th align=right>|.$locale->text('Password').qq|</th> + <td><input type=password name=new_password size=10 value=$myconfig{password}></td> </tr> <tr> - <th align=right nowrap>|.$locale->text('Income Account').qq|</th> - <td><select name=income_accno>$myconfig{IC_income}</select></td> + <th align=right>|.$locale->text('Confirm').qq|</th> + <td><input type=password name=confirm_password size=10></td> </tr> <tr> - <th align=right nowrap>|.$locale->text('Expense Account').qq|</th> - <td><select name=expense_accno>$myconfig{IC_expense}</select></td> + <th align=right>|.$locale->text('Date Format').qq|</th> + <td><select name=dateformat>$dateformat</select></td> </tr> <tr> - <th align=right nowrap>|.$locale->text('Foreign Exchange Gain').qq|</th> - <td><select name=fxgain_accno>$myconfig{FX_gain}</select></td> + <th align=right>|.$locale->text('Number Format').qq|</th> + <td><select name=numberformat>$numberformat</select></td> </tr> <tr> - <th align=right nowrap>|.$locale->text('Foreign Exchange Loss').qq|</th> - <td><select name=fxloss_accno>$myconfig{FX_loss}</select></td> + <th align=right>|.$locale->text('Dropdown Limit').qq|</th> + <td><input name=vclimit size=10 value="$myconfig{vclimit}"></td> </tr> <tr> - <td colspan=2>|.$locale->text('Enter up to 3 letters separated by a colon (i.e CAD:USD:EUR) for your native and foreign currencies').qq|<br><input name=curr size=40 value="$form->{defaults}{curr}"></td> + <th align=right>|.$locale->text('Menu Width').qq|</th> + <td><input name=menuwidth size=10 value="$myconfig{menuwidth}"></td> </tr> <tr> - <th align=right nowrap>|.$locale->text('Last Invoice Number').qq|</th> - <td><input name=invnumber size=10 value=$form->{defaults}{invnumber}></td> + <th align=right>|.$locale->text('Language').qq|</th> + <td><select name=countrycode>$countrycodes</select></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> + <th align=right>|.$locale->text('Character Set').qq|</th> + <td><input name=charset size=20 value="$myconfig{charset}"></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>|.$locale->text('Session Timeout').qq|</th> + <td><input name=timeout size=10 value="$myconfig{timeout}"></td> </tr> - </table> - </td> - </tr> - <tr class=listheading> - <th class=listheading colspan=2>|.$locale->text('Tax Accounts').qq|</th> - </tr> - <tr> - <td colspan=2> - <table> <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> + <th align=right>|.$locale->text('Stylesheet').qq|</th> + <td><select name=usestylesheet>$selectstylesheet</select></td> </tr> -|; - $form->{taxaccounts} .= "$form->{taxrates}{$accno}{id} "; - } - - chop $form->{taxaccounts}; - - print qq| -<input name=taxaccounts type=hidden value="$form->{taxaccounts}"> - - </table> + $printer + </table> </td> </tr> </table> </td> - </tr> <tr> <td><hr size=3 noshade></td> </tr> @@ -920,11 +1870,18 @@ sub config { <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 type=hidden name=sessionid value=$form->{sessionid}> <br> -<input type=submit class=submit name=action value="|.$locale->text('Save').qq|"> -</form> +<input type=submit class=submit name=action value="|.$locale->text('Save').qq|">|; + + if ($form->{menubar}) { + require "$form->{path}/menu.pl"; + &menubar; + } + + print qq| + </form> </body> </html> @@ -933,14 +1890,23 @@ sub config { } +sub save_defaults { + + $form->redirect($locale->text('Defaults saved!')) if (AM->save_defaults(\%myconfig, \%$form)); + $form->error($locale->text('Cannot save defaults!')); + +} + + sub save_preferences { - # does stylesheet exist - if ($form->{stylesheet}) { - $form->error($locale->text('Stylesheet').": css/$form->{stylesheet} ".$locale->text('does not exist')) unless (-f "css/$form->{stylesheet}"); - } + $form->{stylesheet} = $form->{usestylesheet}; + + if ($form->{new_password} ne $form->{old_password}) { + $form->error($locale->text('Password does not match!')) if $form->{new_password} ne $form->{confirm_password}; + } - $form->redirect($locale->text('Preferences saved!')) if (AM->save_preferences(\%myconfig, \%$form, $memberfile, $userspath)); + $form->redirect($locale->text('Preferences saved!')) if AM->save_preferences(\%myconfig, \%$form, $memberfile, $userspath); $form->error($locale->text('Cannot save preferences!')); } @@ -954,8 +1920,9 @@ sub backup { $form->{OUT} = "$sendmail"; } - - AM->backup(\%myconfig, \%$form, $userspath); + + $SIG{INT} = 'IGNORE'; + AM->backup(\%myconfig, \%$form, $userspath, $gzip); if ($form->{media} eq 'email') { $form->redirect($locale->text('Backup sent to').qq| $myconfig{email}|); @@ -972,11 +1939,17 @@ sub audit_control { AM->closedto(\%myconfig, \%$form); if ($form->{revtrans}) { - $checked{Y} = "checked"; + $checked{revtransY} = "checked"; } else { - $checked{N} = "checked"; + $checked{revtransN} = "checked"; } + if ($form->{audittrail}) { + $checked{audittrailY} = "checked"; + } else { + $checked{audittrailN} = "checked"; + } + $form->header; print qq| @@ -986,7 +1959,7 @@ sub audit_control { <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 type=hidden name=sessionid value=$form->{sessionid}> <table width=100%> <tr><th class=listtop>$form->{title}</th></tr> @@ -995,13 +1968,21 @@ sub audit_control { <td> <table> <tr> - <td>|.$locale->text('Enforce transaction reversal for all dates').qq|</th> - <td><input name=revtrans class=radio type=radio value="1" $checked{Y}> |.$locale->text('Yes').qq| <input name=revtrans class=radio type=radio value="0" $checked{N}> |.$locale->text('No').qq|</td> + <th align=right>|.$locale->text('Enforce transaction reversal for all dates').qq|</th> + <td><input name=revtrans class=radio type=radio value="1" $checked{revtransY}> |.$locale->text('Yes').qq| <input name=revtrans class=radio type=radio value="0" $checked{revtransN}> |.$locale->text('No').qq|</td> </tr> <tr> - <td>|.$locale->text('Close Books up to').qq|</th> + <th align=right>|.$locale->text('Close Books up to').qq|</th> <td><input name=closedto size=11 title="$myconfig{dateformat}" value=$form->{closedto}></td> </tr> + <tr> + <th align=right>|.$locale->text('Activate Audit trails').qq|</th> + <td><input name=audittrail class=radio type=radio value="1" $checked{audittrailY}> |.$locale->text('Yes').qq| <input name=audittrail class=radio type=radio value="0" $checked{audittrailN}> |.$locale->text('No').qq|</td> + </tr> + <tr> + <th align=right>|.$locale->text('Remove Audit trails up to').qq|</th> + <td><input name=removeaudittrail size=11 title="$myconfig{dateformat}"></td> + </tr> </table> </td> </tr> @@ -1028,19 +2009,381 @@ sub doclose { AM->closebooks(\%myconfig, \%$form); if ($form->{revtrans}) { - $form->redirect($locale->text('Transaction reversal enforced for all dates')); + $msg = $locale->text('Transaction reversal enforced for all dates'); } else { if ($form->{closedto}) { - $form->redirect($locale->text('Transaction reversal enforced up to') - ." ".$locale->date(\%myconfig, $form->{closedto}, 1)); + $msg = $locale->text('Transaction reversal enforced up to') + ." ".$locale->date(\%myconfig, $form->{closedto}, 1); } else { - $form->redirect($locale->text('Books are open')); + $msg = $locale->text('Books are open'); } } + $msg .= "<p>"; + if ($form->{audittrail}) { + $msg .= $locale->text('Audit trails enabled'); + } else { + $msg .= $locale->text('Audit trails disabled'); + } + + $msg .= "<p>"; + if ($form->{removeaudittrail}) { + $msg .= $locale->text('Audit trail removed up to') + ." ".$locale->date(\%myconfig, $form->{removeaudittrail}, 1); + } + + $form->redirect($msg); + +} + + +sub add_warehouse { + + $form->{title} = "Add"; + + $form->{callback} = "$form->{script}?action=add_warehouse&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}" unless $form->{callback}; + + &warehouse_header; + &form_footer; + +} + + +sub edit_warehouse { + + $form->{title} = "Edit"; + + AM->get_warehouse(\%myconfig, \%$form); + + &warehouse_header; + &form_footer; + } +sub list_warehouse { + + AM->warehouses(\%myconfig, \%$form); + + $href = "$form->{script}?action=list_warehouse&direction=$form->{direction}&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}"; + + $form->sort_order(); + + $form->{callback} = "$form->{script}?action=list_warehouse&direction=$form->{direction}&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}"; + + $callback = $form->escape($form->{callback}); + + $form->{title} = $locale->text('Warehouses'); + + @column_index = qw(description); + + $column_header{description} = qq|<th width=100%><a class=listheading href=$href>|.$locale->text('Description').qq|</a></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}&sessionid=$form->{sessionid}&callback=$callback>$ref->{description}</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=warehouse> + +<input type=hidden name=path value=$form->{path}> +<input type=hidden name=login value=$form->{login}> +<input type=hidden name=sessionid value=$form->{sessionid}> + +<input class=submit type=submit name=action value="|.$locale->text('Add Warehouse').qq|">|; + + if ($form->{menubar}) { + require "$form->{path}/menu.pl"; + &menubar; + } + + print qq| + </form> + + </body> + </html> +|; + +} + + + +sub warehouse_header { + + $form->{title} = $locale->text("$form->{title} Warehouse"); + +# $locale->text('Add Warehouse') +# $locale->text('Edit Warehouse') + + $form->{description} = $form->quote($form->{description}); + + 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}">|; + } + + + $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=warehouse> + +<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> +|; + +} + + +sub save_warehouse { + + $form->isblank("description", $locale->text('Description missing!')); + AM->save_warehouse(\%myconfig, \%$form); + $form->redirect($locale->text('Warehouse saved!')); + +} + + +sub delete_warehouse { + + AM->delete_warehouse(\%myconfig, \%$form); + $form->redirect($locale->text('Warehouse deleted!')); + +} + + +sub yearend { + + AM->earningsaccounts(\%myconfig, \%$form); + map { $chart .= "<option>$_->{accno}--$_->{description}" } @{ $form->{chart} }; + + $form->{title} = $locale->text('Yearend'); + $form->header; + + print qq| +<body> + +<form method=post action=$form->{script}> + +<input type=hidden name=decimalplaces value=2> +<input type=hidden name=l_accno value=Y> + +<table width=100%> + <tr> + <th class=listtop>$form->{title}</th> + </tr> + <tr height="5"></tr> + <tr> + <td> + <table> + <tr> + <th align=right>|.$locale->text('Yearend').qq|</th> + <td><input name=todate size=11 title="$myconfig{dateformat}" value=$todate></td> + </tr> + <tr> + <th align=right>|.$locale->text('Reference').qq|</th> + <td><input name=reference size=20 value="|.$locale->text('Yearend').qq|"></td> + </tr> + <tr> + <th align=right>|.$locale->text('Description').qq|</th> + <td><textarea name=description rows=3 cols=50 wrap=soft></textarea></td> + </tr> + <tr> + <th align=right>|.$locale->text('Retained Earnings').qq|</th> + <td><select name=accno>$chart</select></td> + </tr> + <tr> + <th align=right>|.$locale->text('Method').qq|</th> + <td><input name=method class=radio type=radio value=accrual checked> |.$locale->text('Accrual').qq| <input name=method class=radio type=radio value=cash> |.$locale->text('Cash').qq|</td> + </tr> + </table> + </td> + </tr> +</table> + +<hr size=3 noshade> + +<input type=hidden name=nextsub value=generate_yearend> + +<input type=hidden name=path value=$form->{path}> +<input type=hidden name=login value=$form->{login}> +<input type=hidden name=sessionid value=$form->{sessionid}> + +<input class=submit type=submit name=action value="|.$locale->text('Continue').qq|">|; + +} + + +sub generate_yearend { + + $form->isblank("todate", $locale->text('Yearend date missing!')); + + RP->yearend_statement(\%myconfig, \%$form); + + $form->{transdate} = $form->{todate}; + + $earnings = 0; + + $form->{rowcount} = 1; + foreach $key (keys %{ $form->{I} }) { + if ($form->{I}{$key}{charttype} eq "A") { + $form->{"debit_$form->{rowcount}"} = $form->{I}{$key}{this}; + $earnings += $form->{I}{$key}{this}; + $form->{"accno_$form->{rowcount}"} = $key; + $form->{rowcount}++; + $ok = 1; + } + } + + foreach $key (keys %{ $form->{E} }) { + if ($form->{E}{$key}{charttype} eq "A") { + $form->{"credit_$form->{rowcount}"} = $form->{E}{$key}{this} * -1; + $earnings += $form->{E}{$key}{this}; + $form->{"accno_$form->{rowcount}"} = $key; + $form->{rowcount}++; + $ok = 1; + } + } + if ($earnings > 0) { + $form->{"credit_$form->{rowcount}"} = $earnings; + $form->{"accno_$form->{rowcount}"} = $form->{accno} + } else { + $form->{"debit_$form->{rowcount}"} = $earnings * -1; + $form->{"accno_$form->{rowcount}"} = $form->{accno} + } + + if ($ok) { + if (AM->post_yearend(\%myconfig, \%$form)) { + $form->redirect($locale->text('Yearend posted!')); + } + $form->error($locale->text('Yearend posting failed!')); + } else { + $form->error('Nothing to do!'); + } + +} + + + +sub company_logo { + + $myconfig{address} =~ s/\\n/<br>/g; + $myconfig{dbhost} = $locale->text('localhost') unless $myconfig{dbhost}; + + map { $form->{$_} = $myconfig{$_} } qw(charset stylesheet); + + $form->{title} = $locale->text('About'); + + # create the logo screen + $form->header; + + print qq| +<body> + +<pre> + +</pre> +<center> +<a href="http://www.sql-ledger.org" target=_top><img src=sql-ledger.gif border=0></a> +<h1 class=login>|.$locale->text('Version').qq| $form->{version}</h1> + +<p> +|.$locale->text('Licensed to').qq| +<p> +<b> +$myconfig{company} +<br>$myconfig{address} +</b> + +<p> +<table border=0> + <tr> + <th align=right>|.$locale->text('User').qq|</th> + <td>$myconfig{name}</td> + </tr> + <tr> + <th align=right>|.$locale->text('Dataset').qq|</th> + <td>$myconfig{dbname}</td> + </tr> + <tr> + <th align=right>|.$locale->text('Database Host').qq|</th> + <td>$myconfig{dbhost}</td> + </tr> +</table> + +</center> + +</body> +</html> +|; + +} + sub continue { |