From e089cc710b0bcc631385a42ab7a880f610478710 Mon Sep 17 00:00:00 2001
From: Andrew McMillan <andrew@morphoss.com>
Date: Wed, 10 Jun 2009 21:24:51 +1200
Subject: [PATCH] Adjust layout.

---
 inc/view/company_year_end.php | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/inc/view/company_year_end.php b/inc/view/company_year_end.php
index 68fedda..fe37132 100644
--- a/inc/view/company_year_end.php
+++ b/inc/view/company_year_end.php
@@ -51,7 +51,7 @@ $template->RowFormat( "<tr onclick=\"window.location='$rowurl';\" class=\"r%d\">
 /**
 * Income and expenditure accounts just look at the current financial year
 */
-$template->SetJoins( "year_end_balance('L',$id,$fy_code) LEFT JOIN chartofaccount USING ( accountcode ) LEFT JOIN accountgroup USING ( accountgroupcode )" );
+$template->SetJoins( "chartofaccount LEFT OUTER JOIN year_end_balance('L',$id,$fy_code) USING ( accountcode ) LEFT JOIN accountgroup USING ( accountgroupcode )" );
 
 $browser = clone($template);
 $browser->SetTitle("Income Accounts");
@@ -111,8 +111,8 @@ $sql = "SELECT sum(balance) FROM year_end_balance('L',$id,$fy_code) LEFT JOIN ch
 $qry = new PgQuery($sql);
 if ( $qry->Exec('company_year_end') && $qry->rows == 1 ) {
   $r = $qry->Fetch();
-  $net_type = ($r->sum < 0 ? 'Assets' : 'Liabilities');
-  $page_elements[] = sprintf( "<h3>Net %s is %14.2lf</h3>\n", $net_type, abs($r->sum) );
+  $net_type = ($r->sum < 0 ? 'Liabilities' : 'Assets' );
+  $page_elements[] = sprintf( "<h3>Net %s are %14.2lf</h3>\n", $net_type, abs($r->sum) );
 }
 
 
-- 
2.11.4.GIT