Changeset 186 for trunk/phpbms/modules/bms/report/lineitems_totals.php

Timestamp:

02/16/07 11:59:50 (5 years ago)

Author:

brieb

Message:

Implemented #3. Fixed XHTML compliance of some <br> tags. Fixed invoice report errors. Fixed update.sql naming problem (had leading space)

Files:

• trunk/phpbms/modules/bms/report/lineitems_totals.php (modified) (9 diffs)

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

@@ -115 +115 @@
                 $querystatement.=" FROM ".$this->selecttable.$this->whereclause;                
                 $queryresult=mysql_query($querystatement,$dblink);
-                if(!$queryresult) reportError(500,"showGrandTotals - Bad SQL:".mysql_error($dblink)."<br><br>".$querystatement);
+                if(!$queryresult) reportError(500,"showGrandTotals - Bad SQL:".mysql_error($dblink)."<br /><br />".$querystatement);
                 $therecord=mysql_fetch_array($queryresult);
                 ?>
@@ -143 +143 @@
                         $querystatement.=" FROM ".$this->selecttable.$this->whereclause.$where." GROUP BY ".$groupby;
                         $queryresult=mysql_query($querystatement,$dblink);
-                        if(!$queryresult) reportError(500,"showGroup - Bad SQL:".mysql_error($dblink)."<br><br>".$querystatement);
+                        if(!$queryresult) reportError(500,"showGroup - Bad SQL:".mysql_error($dblink)."<br /><br />".$querystatement);
                         
                         while($therecord=mysql_fetch_array($queryresult)){
@@ -189 +189 @@
                                                 FROM ".$this->selecttable.$this->whereclause.$where." GROUP BY lineitems.id ";
                 $queryresult=mysql_query($querystatement,$dblink);
-                if(!$queryresult) reportError(500,"showLineItems Bad SQL:".mysql_error($dblink)."<br><br>".$querystatement);    
+                if(!$queryresult) reportError(500,"showLineItems Bad SQL:".mysql_error($dblink)."<br /><br />".$querystatement);        
                                 
                 ?>
@@ -260 +260 @@
 <h2>
         <div>
-        source:<br>
+        source:<br />
         <?php echo $_SESSION["printing"]["dataprint"]?>
         </div>
         <div>
-        date generated:<br>
+        date generated:<br />
         <?php echo date("m/d/Y H:i");?>
         </div>
@@ -346 +346 @@
         <form action="<?php echo $_SERVER["PHP_SELF"]?>" method="post" name="totals" onSubmit="return submitForm(this)">
                 <div>
-                        report title<br>                        
+                        report title<br />                      
                         <input type="text" name="reporttitle" value="" style="width:100%">
                 </div>
                 <div class="box">
-                        <strong>Grouping</strong><br>
+                        <strong>Grouping</strong><br />
                         <table border=0 cellspacing=0 cellpadding=0>
                                 <tr>
                                         <td width="50%">
-                                                selected groupings<br>
+                                                selected groupings<br />
                                                 <select name="selectedgroupings" size="5" style="width:100%" multiple>
                                                 </select>
@@ -360 +360 @@
                                         </td>
                                         <td>
-                                                <div><br>
-                                                        <input type="button" value="&lt;&lt;" class="Buttons" onClick="moveItem('groupings','to',this.form);"><br><br>
+                                                <div><br />
+                                                        <input type="button" value="&lt;&lt;" class="Buttons" onClick="moveItem('groupings','to',this.form);"><br /><br />
                                                         <input type="button" value="&gt;&gt;" class="Buttons" onClick="moveItem('groupings','from',this.form);">                                                        
                                                 </div>
                                         </td>
                                         <td width="50%">
-                                                available groupings<br>
+                                                available groupings<br />
                                                 <select name="availablegroupings" size="5" style="width:100%" multiple>
                                                         <option value="invoices.id">Invoice ID</option>
@@ -399 +399 @@
                 </div>
                 <div class="box">
-                        <strong>Columns</strong><br>
+                        <strong>Columns</strong><br />
                         <table border=0 cellspacing=0 cellpadding=0>
                                 <tr>
                                         <td width="50%">
-                                                shown columns<br>
+                                                shown columns<br />
                                                 <select name="selectedcolumns" size="7" style="width:100%">
                                                         <option value="concat('$',format(sum(lineitems.unitprice*lineitems.quantity),2))">Extended Price</option>                                               
@@ -410 +410 @@
                                         </td>
                                         <td>
-                                                <div><br>
-                                                        <input type="button" value="&lt;&lt;" class="Buttons" onClick="moveItem('columns','to',this.form);"><br><br>
+                                                <div><br />
+                                                        <input type="button" value="&lt;&lt;" class="Buttons" onClick="moveItem('columns','to',this.form);"><br /><br />
                                                         <input type="button" value="&gt;&gt;" class="Buttons" onClick="moveItem('columns','from',this.form);">                                                  
                                                 </div>
                                         </td>
                                         <td width="50%">
-                                                available columns<br>
+                                                available columns<br />
                                                 <select name="availablecolumns" size="7" style="width:100%">
                                                         <option value="count(lineitems.id)">count</option>                                              
@@ -437 +437 @@
                 </div>
                 <div class=box>
-                        <strong>Additional Options</strong><br>
-                        information shown<br>
+                        <strong>Additional Options</strong><br />
+                        information shown<br />
                         <select name="showwhat">
                                 <option selected value="totals">Totals Only</option>