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

[..hidden..]

Revision: 6776
          http://sourceforge.net/p/ledger-smb/code/6776
Author:   einhverfr
Date:     2014-02-06 05:09:50 +0000 (Thu, 06 Feb 2014)
Log Message:
-----------
Buttons now show up (don't work yet), and eliminating a join projection issue in inventory report search

Modified Paths:
--------------
    trunk/LedgerSMB/Report/Inventory/Adj_Details.pm
    trunk/sql/modules/Inventory_Report.sql

Modified: trunk/LedgerSMB/Report/Inventory/Adj_Details.pm
===================================================================
--- trunk/LedgerSMB/Report/Inventory/Adj_Details.pm	2014-02-06 04:56:17 UTC (rev 6775)
+++ trunk/LedgerSMB/Report/Inventory/Adj_Details.pm	2014-02-06 05:09:50 UTC (rev 6776)
@@ -91,6 +91,28 @@
     ];
 }
 
+=head2 set_buttons
+
+This sets buttons relevant to approving the adjustments.
+
+=cut
+
+sub set_buttons {
+    return [{
+       name => 'action',
+       type => 'submit',
+      value => 'approve',
+       text => LedgerSMB::Report::text('Approve'),
+      class => 'submit',
+    },{
+       name => 'action',
+       type => 'submit',
+      value => 'delete',
+       text => LedgerSMB::Report::text('Delete'),
+      class => 'submit',
+    }];
+}
+
 =back
 
 =head1 METHODS

Modified: trunk/sql/modules/Inventory_Report.sql
===================================================================
--- trunk/sql/modules/Inventory_Report.sql	2014-02-06 04:56:17 UTC (rev 6775)
+++ trunk/sql/modules/Inventory_Report.sql	2014-02-06 05:09:50 UTC (rev 6776)
@@ -39,8 +39,9 @@
     WHERE ($1 is null or $1 <= r.transdate) AND
           ($2 is null OR $2 >= r.transdate) AND
           ($3 IS NULL OR plainto_tsquery($3) @@ tsvector(p.partnumber)) AND
-          ($4 IS NULL OR source LIKE $4 || '%');
- 
+          ($4 IS NULL OR source LIKE $4 || '%')
+ GROUP BY r.id, r.transdate, r.source, r.ar_trans_id, r.ap_trans_id,
+          ar.invnumber, ap.invnumber
 $$ LANGUAGE SQL;
 
 CREATE OR REPLACE FUNCTION inventory_adj__get(in_id int)

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


------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits