SF.net SVN: ledger-smb:[2298] trunk

[..hidden..]

Revision: 2298
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2298&view=rev
Author:   einhverfr
Date:     2008-08-21 23:30:49 +0000 (Thu, 21 Aug 2008)

Log Message:
-----------
Hiding notes with ledgersmb.css on top company div for now.

Modified Paths:
--------------
    trunk/LedgerSMB/CA.pm
    trunk/css/ledgersmb.css

Modified: trunk/LedgerSMB/CA.pm
===================================================================
--- trunk/LedgerSMB/CA.pm	2008-08-21 20:21:11 UTC (rev 2297)
+++ trunk/LedgerSMB/CA.pm	2008-08-21 23:30:49 UTC (rev 2298)
@@ -151,7 +151,6 @@
 
     my $fromdate_where;
     my $todate_where;
-    
     ( $form->{fromdate}, $form->{todate} ) =
       $form->from_to( $form->{year}, $form->{month}, $form->{interval} )
       if !$form->{fromdate} && !$form->{todate};
@@ -372,7 +371,6 @@
                     }
                 }
             }
-
             $sth = $dbh->prepare($query);
             $sth->execute(@queryargs);
             my @balance = $sth->fetchrow_array;
@@ -385,7 +383,7 @@
 
     $query = "";
     $union = "";
-
+    
     foreach my $id (@id) {
 
         # get all transactions
@@ -425,7 +423,9 @@
 			       ac.source, a.till, ac.chart_id
 			  FROM ar a
 			  JOIN acc_trans ac ON (ac.trans_id = a.id)
-			  JOIN entity e ON (a.entity_id = e.id)
+			  JOIN entity_credit_account eca 
+			        ON (a.entity_credit_account = eca.id)
+			  JOIN entity e ON (eca.entity_id = e.id)
 			$dpt_join
 			 WHERE ac.chart_id = ?
 			       AND ($approved OR (a.approved AND ac.approved))
@@ -456,7 +456,9 @@
 			       ac.source, a.till, ac.chart_id
 			  FROM ap a
 			  JOIN acc_trans ac ON (ac.trans_id = a.id)
-			  JOIN entity e ON (a.entity_id = e.id)
+			  JOIN entity_credit_account eca 
+			        ON (a.entity_credit_account = eca.id)
+			  JOIN entity e ON (eca.entity_id = e.id)
 			$dpt_join
 			 WHERE ac.chart_id = ?
 			       AND ($approved OR (a.approved AND ac.approved))
@@ -482,7 +484,6 @@
     }
 
     $query .= qq| ORDER BY $sortorder |;
-
     $sth = $dbh->prepare($query);
     $sth->execute(@queryargs) || $form->dberror($query);
 

Modified: trunk/css/ledgersmb.css
===================================================================
--- trunk/css/ledgersmb.css	2008-08-21 20:21:11 UTC (rev 2297)
+++ trunk/css/ledgersmb.css	2008-08-21 23:30:49 UTC (rev 2298)
@@ -186,7 +186,7 @@
   font-size: 14pt;
 }
 
-div.note {
+#notes_div div.note {
 	margin: 1em;
 	padding: 1em;
 	border: 2px;
@@ -197,7 +197,7 @@
 	border-style: groove;
 }
 
-div.note:hover {
+#notes_div div.note:hover {
 	overflow:visible;
 	background-color: #ddd;
 	border-style: groove;
@@ -207,6 +207,10 @@
 	overflow: auto;
 }
 
+#company_div div.note {
+	display: none;
+}
+
 tr.active {
 	background-color: #ddd;
 }


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.