#=====================================================================
# LedgerSMB Small Medium Business Accounting
# http://www.ledgersmb.org/
#
# Copyright (C) 2006
# This work contains copyrighted information from a number of sources all used
# with permission.
#
# This file contains source code included with or based on SQL-Ledger which
# is Copyright Dieter Simader and DWS Systems Inc. 2000-2005 and licensed
# under the GNU General Public License version 2 or, at your option, any later
# version. For a full list including contact information of contributors,
# maintainers, and copyright holders, see the CONTRIBUTORS file.
#
# Original Copyright Notice from SQL-Ledger 2.6.17 (before the fork):
# Copyright (C) 2001
#
# Author: DWS Systems Inc.
# Web: http://www.sql-ledger.org
#
# Contributors:
#
#
# Author: DWS Systems Inc.
# Web: http://www.ledgersmb.org/
#
# Contributors:
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
#======================================================================
#
# module for Chart of Accounts, Income Statement and Balance Sheet
# search and edit transactions posted by the GL, AR and AP
#
#======================================================================
use LedgerSMB::CA;
1;
# end of main
# this is for our long dates
# $locale->text('January')
# $locale->text('February')
# $locale->text('March')
# $locale->text('April')
# $locale->text('May ')
# $locale->text('June')
# $locale->text('July')
# $locale->text('August')
# $locale->text('September')
# $locale->text('October')
# $locale->text('November')
# $locale->text('December')
# this is for our short month
# $locale->text('Jan')
# $locale->text('Feb')
# $locale->text('Mar')
# $locale->text('Apr')
# $locale->text('May')
# $locale->text('Jun')
# $locale->text('Jul')
# $locale->text('Aug')
# $locale->text('Sep')
# $locale->text('Oct')
# $locale->text('Nov')
# $locale->text('Dec')
sub chart_of_accounts {
CA->all_accounts( \%myconfig, \%$form );
@column_index = qw(accno gifi_accno description debit credit);
$column_header{accno} =
qq|<th class=listtop>| . $locale->text('Account') . qq|</th>\n|;
$column_header{gifi_accno} =
qq|<th class=listtop>| . $locale->text('GIFI') . qq|</th>\n|;
$column_header{description} =
qq|<th class=listtop>| . $locale->text('Description') . qq|</th>\n|;
$column_header{debit} =
qq|<th class=listtop>| . $locale->text('Debit') . qq|</th>\n|;
$column_header{credit} =
qq|<th class=listtop>| . $locale->text('Credit') . qq|</th>\n|;
$form->{title} = $locale->text('Chart of Accounts');
$colspan = $#column_index + 1;
$form->header;
print qq|
<body>
<table border=0 width=100%>
<tr><th class=listtop colspan=$colspan>$form->{title}</th></tr>
<tr height="5"></tr>
<tr class=listheading>|;
for (@column_index) { print $column_header{$_} }
print qq|
</tr>
|;
foreach $ca ( @{ $form->{CA} } ) {
$description = $form->escape( $ca->{description} );
$gifi_description = $form->escape( $ca->{gifi_description} );
$href =
qq|$form->{script}?path=$form->{path}&action=list&accno=$ca->{accno}&login=$form->{login}&sessionid=$form->{sessionid}&description=$description&gifi_accno=$ca->{gifi_accno}&gifi_description=$gifi_description|;
if ( $ca->{charttype} eq "H" ) {
print qq|<tr class=listheading>|;
for (qw(accno description)) {
$column_data{$_} = "<th class=listheading>$ca->{$_}</th>";
}
$column_data{gifi_accno} =
"<th class=listheading>$ca->{gifi_accno} </th>";
}
else {
$i++;
$i %= 2;
print qq|<tr class=listrow$i>|;
$column_data{accno} = "<td><a href=$href>$ca->{accno}</a></td>";
$column_data{gifi_accno} =
"<td><a href=$href&accounttype=gifi>$ca->{gifi_accno}</a> </td>";
$column_data{description} = "<td>$ca->{description}</td>";
}
$column_data{debit} =
"<td align=right>"
. $form->format_amount( \%myconfig, $ca->{debit}, 2, " " )
. "</td>\n";
$column_data{credit} =
"<td align=right>"
. $form->format_amount( \%myconfig, $ca->{credit}, 2, " " )
. "</td>\n";
$totaldebit += $ca->{debit};
$totalcredit += $ca->{credit};
for (@column_index) { print "$column_data{$_}\n" }
print qq|
</tr>
|;
}
for (qw(accno gifi_accno description)) {
$column_data{$_} = "<td> </td>";
}
$column_data{debit} =
"<th align=right class=listtotal>"
. $form->format_amount( \%myconfig, $totaldebit, 2, 0 ) . "</th>";
$column_data{credit} =
"<th align=right class=listtotal>"
. $form->format_amount( \%myconfig, $totalcredit, 2, 0 ) . "</th>";
print "<tr class=listtotal>";
for (@column_index) { print "$column_data{$_}\n" }
print qq|
</tr>
<tr>
<td colspan=$colspan><hr size=3 noshade></td>
</tr>
</table>
</body>
</html>
|;
}
sub list {
$form->{title} = $locale->text('List Transactions');
if ( $form->{accounttype} eq 'gifi' ) {
$form->{title} .= " - "
. $locale->text('GIFI')
. " $form->{gifi_accno} - $form->{gifi_description}";
}
else {
$form->{title} .= " - "
. $locale->text('Account')
. " $form->{accno} - $form->{description}";
}
# get departments
$form->all_departments( \%myconfig );
if ( @{ $form->{all_department} } ) {
$form->{selectdepartment} = "<option>\n";
for ( @{ $form->{all_department} } ) {
$form->{selectdepartment} .=
qq|<option value="$_->{description}--$_->{id}">$_->{description}\n|;
}
}
$department = qq|
<tr>
<th align=right nowrap>| . $locale->text('Department') . qq|</th>
<td colspan=3><select name=department>$form->{selectdepartment}</select></td>
</tr>
| if $form->{selectdepartment};
if ( @{ $form->{all_years} } ) {
# accounting years
$form->{selectaccountingyear} = "<option>\n";
for ( @{ $form->{all_years} } ) {
$form->{selectaccountingyear} .= qq|<option>$_\n|;
}
$form->{selectaccountingmonth} = "<option>\n";
for ( sort keys %{ $form->{all_month} } ) {
$form->{selectaccountingmonth} .=
qq|<option value=$_>|
. $locale->text( $form->{all_month}{$_} ) . qq|\n|;
}
$selectfrom = qq|
<tr>
<th align=right>| . $locale->text('Period') . qq|</th>
<td colspan=3>
<select name=month>$form->{selectaccountingmonth}</select>
<select name=year>$form->{selectaccountingyear}</select>
<input name=interval class=radio type=radio value=0 checked> |
. $locale->text('Current') . qq|
<input name=interval class=radio type=radio value=1> |
. $locale->text('Month') . qq|
<input name=interval class=radio type=radio value=3> |
. $locale->text('Quarter') . qq|
<input name=interval class=radio type=radio value=12> |
. $locale->text('Year') . qq|
</td>
</tr>
|;
}
$form->header;
print qq|
<body>
<form method=post action=$form->{script}>
<input type=hidden name=accno value=$form->{accno}>
<input type=hidden name=description value="$form->{description}">
<input type=hidden name=sort value=transdate>
<input type=hidden name=oldsort value=transdate>
<input type=hidden name=accounttype value=$form->{accounttype}>
<input type=hidden name=gifi_accno value=$form->{gifi_accno}>
<input type=hidden name=gifi_description value="$form->{gifi_description}">
<table border=0 width=100%>
<tr><th class=listtop>$form->{title}</th></tr>
<tr height="5"></tr>
<tr valign=top>
<td>
<table>
$department
<tr>
<th align=right>| . $locale->text('From') . qq|</th>
<td><input name=fromdate size=11 title="$myconfig{dateformat}"></td>
<th align=right>| . $locale->text('To') . qq|</th>
<td><input name=todate size=11 title="$myconfig{dateformat}"></td>
</tr>
$selectfrom
<tr>
<th align=right>| . $locale->text('Include in Report') . qq|</th>
<td colspan=3>
<input name=l_accno class=checkbox type=checkbox value=Y> |
. $locale->text('AR/AP') . qq|
<input name=l_subtotal class=checkbox type=checkbox value=Y> |
. $locale->text('Subtotal') . qq|
</td>
</tr>
</table>
</td>
</tr>
<tr><td><hr size=3 noshade></td></tr>
</table>
<input type="hidden" name="login" value="$form->{login}">
<input type="hidden" name="path" value="$form->{path}">
<input type="hidden" name="sessionid" value="$form->{sessionid}">
<br><button class="submit" type="submit" name="action" value="list_transactions">|
. $locale->text('List Transactions')
. qq|</button>
</form>
</body>
</html>
|;
}
sub list_transactions {
CA->all_transactions( \%myconfig, \%$form );
$department = $form->escape( $form->{department} );
$projectnumber = $form->escape( $form->{projectnumber} );
$title = $form->escape( $form->{title} );
# construct href
$href =
"$form->{script}?action=list_transactions&department=$department&projectnumber=$projectnumber&title=$title";
for (
qw(path oldsort accno login sessionid fromdate todate accounttype gifi_accno l_heading l_subtotal l_accno)
)
{
$href .= "&$_=$form->{$_}";
}
$drilldown = $href;
$drilldown .= "&sort=$form->{sort}";
$href .= "&direction=$form->{direction}";
$form->sort_order();
$drilldown .= "&direction=$form->{direction}";
$form->{prevreport} = $href unless $form->{prevreport};
$href .= "&prevreport=" . $form->escape( $form->{prevreport} );
$drilldown .= "&prevreport=" . $form->escape( $form->{prevreport} );
# figure out which column comes first
$column_header{transdate} =
qq|<th><a class=listheading href=$href&sort=transdate>|
. $locale->text('Date')
. qq|</a></th>|;
$column_header{reference} =
qq|<th><a class=listheading href=$href&sort=reference>|
. $locale->text('Reference')
. qq|</a></th>|;
$column_header{description} =
qq|<th><a class=listheading href=$href&sort=description>|
. $locale->text('Description')
. qq|</a></th>|;
$column_header{cleared} =
qq|<th class=listheading>| . $locale->text('R') . qq|</th>|;
$column_header{source} =
qq|<th class=listheading>| . $locale->text('Source') . qq|</th>|;
$column_header{debit} =
qq|<th class=listheading>| . $locale->text('Debit') . qq|</th>|;
$column_header{credit} =
qq|<th class=listheading>| . $locale->text('Credit') . qq|</th>|;
$column_header{balance} =
qq|<th class=listheading>| . $locale->text('Balance') . qq|</th>|;
$column_header{accno} =
qq|<th class=listheading>| . $locale->text('AR/AP') . qq|</th>|;
@columns = qw(transdate reference description debit credit);
if ( $form->{link} =~ /_paid/ ) {
@columns =
qw(transdate reference description source cleared debit credit);
}
push @columns, "accno" if $form->{l_accno};
@column_index = $form->sort_columns(@columns);
if ( $form->{accounttype} eq 'gifi' ) {
for (qw(accno description)) { $form->{$_} = $form->{"gifi_$_"} }
}
if ( $form->{accno} ) {
push @column_index, "balance";
}
$form->{title} =
( $form->{accounttype} eq 'gifi' )
? $locale->text('GIFI')
: $locale->text('Account');
$form->{title} .= " $form->{accno} - $form->{description}";
if ( $form->{department} ) {
($department) = split /--/, $form->{department};
$options = $locale->text('Department') . " : $department<br>";
}
if ( $form->{projectnumber} ) {
($projectnumber) = split /--/, $form->{projectnumber};
$options .= $locale->text('Project Number') . " : $projectnumber<br>";
}
if ( $form->{fromdate} || $form->{todate} ) {
if ( $form->{fromdate} ) {
$fromdate = $locale->date( \%myconfig, $form->{fromdate}, 1 );
}
if ( $form->{todate} ) {
$todate = $locale->date( \%myconfig, $form->{todate}, 1 );
}
$form->{period} = "$fromdate - $todate";
}
else {
$form->{period} =
$locale->date( \%myconfig, $form->current_date( \%myconfig ), 1 );
}
$form->{period} = "<a href=$form->{prevreport}>$form->{period}</a>"
if $form->{prevreport};
$options .= $form->{period};
# construct callback
$department = $form->escape( $form->{department}, 1 );
$projectnumber = $form->escape( $form->{projectnumber}, 1 );
$title = $form->escape( $form->{title}, 1 );
$form->{prevreport} = $form->escape( $form->{prevreport}, 1 );
$form->{callback} =
"$form->{script}?action=list_transactions&department=$department&projectnumber=$projectnumber&title=$title";
for (
qw(path direction oldsort accno login sessionid fromdate todate accounttype gifi_accno l_heading l_subtotal l_accno prevreport)
)
{
$form->{callback} .= "&$_=$form->{$_}";
}
$form->header;
print qq|
<body>
<table width=100%>
<tr>
<th class=listtop>$form->{title}</th>
</tr>
<tr height="5"></tr>
<tr>
<td>$options</td>
</tr>
<tr>
<td>
<table width=100%>
<tr class=listheading>
|;
for (@column_index) { print "$column_header{$_}\n" }
print qq|
</tr>
|;
# add sort to callback
$form->{callback} =
$form->escape( $form->{callback} . "&sort=$form->{sort}" );
if ( @{ $form->{CA} } ) {
$sameitem = $form->{CA}->[0]->{ $form->{sort} };
}
$ml = ( $form->{category} =~ /(A|E)/ ) ? -1 : 1;
$ml *= -1 if $form->{contra};
if ( $form->{accno} && $form->{balance} ) {
for (@column_index) { $column_data{$_} = "<td> </td>" }
$column_data{balance} =
"<td align=right>"
. $form->format_amount( \%myconfig, $form->{balance} * $ml, 2, 0 )
. "</td>";
$i++;
$i %= 2;
print qq|
<tr class=listrow$i>
|;
for (@column_index) { print "$column_data{$_}\n" }
print qq|
</tr>
|;
}
foreach $ca ( @{ $form->{CA} } ) {
if ( $form->{l_subtotal} eq 'Y' ) {
if ( $sameitem ne $ca->{ $form->{sort} } ) {
&ca_subtotal;
}
}
# construct link to source
$href =
"<a href=$ca->{module}.pl?path=$form->{path}&action=edit&id=$ca->{id}&login=$form->{login}&sessionid=$form->{sessionid}&callback=$form->{callback}>$ca->{reference}</a>";
$column_data{debit} =
"<td align=right>"
. $form->format_amount( \%myconfig, $ca->{debit}, 2, " " )
. "</td>";
$column_data{credit} =
"<td align=right>"
. $form->format_amount( \%myconfig, $ca->{credit}, 2, " " )
. "</td>";
$form->{balance} += $ca->{amount};
$column_data{balance} =
"<td align=right>"
. $form->format_amount( \%myconfig, $form->{balance} * $ml, 2, 0 )
. "</td>";
$subtotaldebit += $ca->{debit};
$subtotalcredit += $ca->{credit};
$totaldebit += $ca->{debit};
$totalcredit += $ca->{credit};
$column_data{transdate} = qq|<td>$ca->{transdate}</td>|;
$column_data{reference} = qq|<td>$href</td>|;
$column_data{description} = qq|<td>$ca->{description} </td>|;
$column_data{cleared} =
( $ca->{cleared} ) ? qq|<td>*</td>| : qq|<td> </td>|;
$column_data{source} = qq|<td>$ca->{source} </td>|;
$column_data{accno} = qq|<td>|;
for ( @{ $ca->{accno} } ) {
$column_data{accno} .= "<a href=$drilldown&accno=$_>$_</a> ";
}
$column_data{accno} .= qq| </td>|;
if ( $ca->{id} != $sameid ) {
$i++;
$i %= 2;
}
$sameid = $ca->{id};
print qq|
<tr class=listrow$i>
|;
for (@column_index) { print "$column_data{$_}\n" }
print qq|
</tr>
|;
}
if ( $form->{l_subtotal} eq 'Y' ) {
&ca_subtotal;
}
for (@column_index) { $column_data{$_} = "<td> </td>" }
$column_data{debit} =
"<th align=right class=listtotal>"
. $form->format_amount( \%myconfig, $totaldebit, 2, " " ) . "</th>";
$column_data{credit} =
"<th align=right class=listtotal>"
. $form->format_amount( \%myconfig, $totalcredit, 2, " " ) . "</th>";
$column_data{balance} =
"<th align=right class=listtotal>"
. $form->format_amount( \%myconfig, $form->{balance} * $ml, 2, 0 )
. "</th>";
print qq|
<tr class=listtotal>
|;
for (@column_index) { print "$column_data{$_}\n" }
print qq|
</tr>
</table>
</td>
</tr>
<tr>
<td><hr size=3 noshade></td>
</tr>
</table>
</body>
</html>
|;
}
sub ca_subtotal {
for (@column_index) { $column_data{$_} = "<td> </td>" }
$column_data{debit} =
"<th align=right class=listsubtotal>"
. $form->format_amount( \%myconfig, $subtotaldebit, 2, " " )
. "</th>";
$column_data{credit} =
"<th align=right class=listsubtotal>"
. $form->format_amount( \%myconfig, $subtotalcredit, 2, " " )
. "</th>";
$subtotaldebit = 0;
$subtotalcredit = 0;
$sameitem = $ca->{ $form->{sort} };
print qq|
<tr class=listsubtotal>
|;
for (@column_index) { print "$column_data{$_}\n" }
print qq|
</tr>
|;
}