Changeset 693 for trunk/phpbms/modules/bms/report/aritems_summary.php

Timestamp:

12/31/09 13:36:45 (2 years ago)

Author:

brieb

Message:

• Introduced administratively changeable settings to indvidual reports
• Modified all reports to work with new settings system
• Altered invoice and line item total reports to accept parameters from reportsettings: You can now bypass the grouping/column dialog by providing the infrmation administratively
• Altered all sales order PDF reports to accept parameters from reportsettings: You can now administratively change certain aspects of the print outs, including what parts of the top of the report to show, and what to title the report
• Altered label reports to accept parameters from reportsettings: printed data as well

as label measurements and layout are now defined by administratively

• Altered export and tableprint reports to accept parameters from reportsettings: You can specify individual columns and from table instead of just the defaults (all fields, main table only)
• Added var_dump-esque 'debug' function for development purposes to common functions
• Integrated FPDI functionality with sales order PDF reports: It is now possible to use a PDF saved in the files table as a background template for your invoices (e.g. watermarks)

Files:

• trunk/phpbms/modules/bms/report/aritems_summary.php (modified) (5 diffs)

trunk/phpbms/modules/bms/report/aritems_summary.php

@@ -59 +59 @@
 
 
-        function aritemsSummary($db, $statementDate = NULL, $showPayments = "new", $showClosed = false){
-
-                parent::phpbmsReport($db);
+        function aritemsSummary($db, $reportUUID, $tabledefUUID, $statementDate = NULL, $showPayments = "new", $showClosed = false){
+
+                parent::phpbmsReport($db, $reportUUID, $tabledefUUID);
 
                 if($statementDate)
@@ -78 +78 @@
 
                 if($whereclause)
-                        $this->whereclause = $whereclause;
-
-                if(!$this->whereclause)
-                        $this->whereclause = "
+                        $this->whereClause = $whereclause;
+
+                if(!$this->whereClause)
+                        $this->whereClause = "
                                 aritems.status = 'open'
                                 AND aritems.posted = 1";
@@ -116 +116 @@
                                         ON clients.salesmanagerid = users.uuid";
 
-                $this->sortorder = 'if(clients.lastname!="",concat(clients.lastname,", ",clients.firstname,if(clients.company!="",concat(" (",clients.company,")"),"")),clients.company)';
+                $this->sortOrder = 'if(clients.lastname!="",concat(clients.lastname,", ",clients.firstname,if(clients.company!="",concat(" (",clients.company,")"),"")),clients.company)';
 
                 $querystatement = $this->assembleSQL($querystatement);
@@ -573 +573 @@
         }//endif
 
+        session_cache_limiter('private');
+        //set encoding to latin1 (fpdf doesnt like utf8)
+        $sqlEncoding = "latin1";
+        require_once("../../../include/session.php");
+
+        checkForReportArguments();
+
+        $report = new aritemsSummary($db, $_GET["rid"], $_GET["tid"]);
+
         if(isset($_POST["command"])) {
-
-                session_cache_limiter('private');
-
-                //set encoding to latin1 (fpdf doesnt like utf8)
-                $sqlEncoding = "latin1";
-                require_once("../../../include/session.php");
-
-                $report = new aritemsSummary($db);
 
                 switch($_POST["command"]){
@@ -593 +594 @@
         } else {
 
-                require_once("../../../include/session.php");
-
-                $report = new aritemsSummary($db);
-
                 $report->showOptions();