Changeset 693 for trunk/phpbms/modules/bms/report/aritems_clientstatement.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_clientstatement.php (modified) (8 diffs)

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

@@ -50 +50 @@
         var $showClosed = false;
 
-        function aritemsClientStatements($db, $statementDate = NULL, $showPayments = true, $showClosed = false){
-
-                parent::phpbmsReport($db);
+        function aritemsClientStatements($db, $reportUUID, $tabledefUUID, $statementDate = NULL, $showPayments = true, $showClosed = false){
+
+                parent::phpbmsReport($db, $reportUUID, $tabledefUUID);
 
                 if($statementDate)
@@ -69 +69 @@
 
                 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";
@@ -108 +108 @@
                                         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);
@@ -134 +134 @@
                 //uncomment the following line to help troubleshoot formatting
                 //$pdf->borderDebug = 1;
-                $pdf->hasComapnyHeader = true;
+                $pdf->logoInHeader = true;
+                $pdf->companyInfoInHeader = true;
                 $pdf->SetMargins();
 
@@ -608 +609 @@
 if(!isset($noOutput)){
 
+    //IE needs caching to be set to private in order to display PDFS
+    session_cache_limiter('private');
+
+    //set encoding to latin1 (fpdf doesnt like utf8)
+    $sqlEncoding = "latin1";
+    require_once("../../../include/session.php");
+
+    checkForReportArguments();
+
+    $report = new aritemsClientStatements($db, $_GET["rid"], $_GET["tid"]);
+
         if(isset($_GET["cmd"])){
 
@@ -616 +628 @@
 
         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 aritemsClientStatements($db);
 
                 switch($_POST["command"]){
@@ -635 +639 @@
         } else {
 
-                require_once("../../../include/session.php");
-
-                $report = new aritemsClientStatements($db);
-
                 $report->showOptions();
 
@@ -644 +644 @@
 
 }//end if
+
+/**
+ * When adding a new report record, the add/edit needs to know what the class
+ * name is so that it can instantiate it, and grab it's default settings.
+ */
+if(isset($addingReportRecord))
+    $reportClass ="aritemsClientStatements";
+
 ?>