Changeset 693 for trunk/phpbms/print.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/print.php (modified) (1 diff)

trunk/phpbms/print.php

@@ -100 +100 @@
 
                         if(isset($_POST["choosereport"])){
+
                                 $tablePrinter->openwindows="";
+
                                 for($i=0;$i<count($_POST["choosereport"]);$i++){
+
                                         if($_POST["choosereport"][$i]){
-                                                $querystatement="SELECT reportfile,type from reports where id=".$_POST["choosereport"][$i].";";
-                                                $queryresult=$db->query($querystatement);
-                                                if(!$queryresult) $error = new appError(100,"Could not Retrieve Report Information");
-                                                $reportrecord=$db->fetchArray($queryresult);
+
+                                                $querystatement = "
+                                                    SELECT
+                                                        `uuid`,
+                                                        `reportfile`,
+                                                        `type`
+                                                    FROM
+                                                        `reports`
+                                                    WHERE
+                                                        id = ".$_POST["choosereport"][$i];
+
+                                                $queryresult = $db->query($querystatement);
+
+                                                if(!$queryresult)
+                                                    $error = new appError(100,"Could not Retrieve Report Information");
+
+                                                $reportrecord = $db->fetchArray($queryresult);
+
                                                 $fakeExtForIE="";
-                                                if($reportrecord["type"]=="PDF Report")
-                                                        $fakeExtForIE="&amp;ext=.pdf";
-                                                $dateTimeStamp="&amp;ts=".mktime(); // make the url unique to avoid using browser cache
+
+                                                if($reportrecord["type"] == "PDF Report")
+                                                        $fakeExtForIE = "' + String.fromCharCode(38) + ' &amp;ext=.pdf";
+
+                                                // make the url unique to avoid using browser cache
+                                                $dateTimeStamp = "' + String.fromCharCode(38) + 'ts=".mktime();
+
                                                 //javascript open each report in new window
-                                                $tablePrinter->openwindows.="window.open('".APP_PATH.$reportrecord["reportfile"]."?tid=".urlencode($tablePrinter->tableid).$dateTimeStamp.$fakeExtForIE."','print".$i."');\n";
-                                        }
-                                }
-                        }
+                                                $tablePrinter->openwindows .= "window.open('".APP_PATH.$reportrecord["reportfile"]."?rid=".urlencode($reportrecord["uuid"])."' + String.fromCharCode(38) + 'tid=".urlencode($tablePrinter->tableid).$dateTimeStamp.$fakeExtForIE."','print".$i."');\n";
+
+                                        }//endif
+
+                                }//endfor
+
+                        }//endif
+
                 break;
         }