Changeset 186 for trunk/phpbms/modules/bms/report/invoices_totals.php
- Timestamp:
- 02/16/07 11:59:50 (5 years ago)
- Files:
-
- 1 modified
Legend:
- Unmodified
- Added
- Removed
-
trunk/phpbms/modules/bms/report/invoices_totals.php
r184 r186 108 108 $querystatement.=" FROM ".$this->selecttable.$this->whereclause; 109 109 $queryresult=mysql_query($querystatement,$dblink); 110 if(!$queryresult) reportError(500,"Bad SQL:".mysql_error($dblink)."<br ><br>".$querystatement);110 if(!$queryresult) reportError(500,"Bad SQL:".mysql_error($dblink)."<br /><br />".$querystatement); 111 111 $therecord=mysql_fetch_array($queryresult); 112 112 ?> … … 136 136 $querystatement.=" FROM ".$this->selecttable.$this->whereclause.$where." GROUP BY ".$groupby; 137 137 $queryresult=mysql_query($querystatement,$dblink); 138 if(!$queryresult) reportError(500,"Bad SQL:".mysql_error($dblink)."<br ><br>".$querystatement);138 if(!$queryresult) reportError(500,"Bad SQL:".mysql_error($dblink)."<br /><br />".$querystatement); 139 139 140 140 while($therecord=mysql_fetch_array($queryresult)){ … … 182 182 $querystatement.=" FROM ".$this->selecttable.$this->whereclause.$where." GROUP BY invoices.id"; 183 183 $queryresult=mysql_query($querystatement,$dblink); 184 if(!$queryresult) reportError(500,"Bad SQL:".mysql_error($dblink)."<br ><br>".$querystatement);184 if(!$queryresult) reportError(500,"Bad SQL:".mysql_error($dblink)."<br /><br />".$querystatement); 185 185 186 186 while($therecord=mysql_fetch_array($queryresult)){ … … 214 214 WHERE lineitems.invoiceid=".$invoiceid; 215 215 $queryresult=mysql_query($querystatement,$dblink); 216 if(!$queryresult) reportError(500,"Bad SQL:".mysql_error($dblink)."<br ><br>".$querystatement);216 if(!$queryresult) reportError(500,"Bad SQL:".mysql_error($dblink)."<br /><br />".$querystatement); 217 217 218 218 ?> … … 282 282 <h2> 283 283 <div> 284 source:<br >284 source:<br /> 285 285 <?php echo $_SESSION["printing"]["dataprint"]?> 286 286 </div> 287 287 <div> 288 date generated:<br >288 date generated:<br /> 289 289 <?php echo date("m/d/Y H:i");?> 290 290 </div> … … 370 370 <form action="<?php echo $_SERVER["PHP_SELF"]?>" method="post" name="totals" onSubmit="return submitForm(this)"> 371 371 <div> 372 report title<br >372 report title<br /> 373 373 <input type="text" name="reporttitle" value="" style="width:100%"> 374 374 </div> 375 375 <div class="box"> 376 <strong>Grouping</strong><br >376 <strong>Grouping</strong><br /> 377 377 <table border=0 cellspacing=0 cellpadding=0> 378 378 <tr> 379 379 <td width="50%"> 380 selected groupings<br >380 selected groupings<br /> 381 381 <select name="selectedgroupings" size="5" style="width:100%" multiple> 382 382 </select> … … 384 384 </td> 385 385 <td> 386 <div><br >387 <input type="button" value="<<" class="Buttons" onClick="moveItem('groupings','to',this.form);"><br ><br>386 <div><br /> 387 <input type="button" value="<<" class="Buttons" onClick="moveItem('groupings','to',this.form);"><br /><br /> 388 388 <input type="button" value=">>" class="Buttons" onClick="moveItem('groupings','from',this.form);"> 389 389 </div> 390 390 </td> 391 391 <td width="50%"> 392 available groupings<br >392 available groupings<br /> 393 393 <select name="availablegroupings" size="5" style="width:100%" multiple> 394 394 <option value="invoices.invoicedate">Invoice Date</option> … … 419 419 </div> 420 420 <div class="box"> 421 <strong>Columns</strong><br >421 <strong>Columns</strong><br /> 422 422 <table border=0 cellspacing=0 cellpadding=0> 423 423 <tr> 424 424 <td width="50%"> 425 shown columns<br >425 shown columns<br /> 426 426 <select name="selectedcolumns" size="7" style="width:100%"> 427 427 <option value="concat('$',format(sum(invoices.totalti),2))">Invoice Total</option> … … 430 430 </td> 431 431 <td> 432 <div><br >433 <input type="button" value="<<" class="Buttons" onClick="moveItem('columns','to',this.form);"><br ><br>432 <div><br /> 433 <input type="button" value="<<" class="Buttons" onClick="moveItem('columns','to',this.form);"><br /><br /> 434 434 <input type="button" value=">>" class="Buttons" onClick="moveItem('columns','from',this.form);"> 435 435 </div> 436 436 </td> 437 437 <td width="50%"> 438 available columns<br >438 available columns<br /> 439 439 <select name="availablecolumns" size="7" style="width:100%"> 440 440 <option value="count(invoices.id)">count</option> … … 462 462 </div> 463 463 <div class=box> 464 <strong>Additional Options</strong><br >465 information shown<br >464 <strong>Additional Options</strong><br /> 465 information shown<br /> 466 466 <select name="showwhat"> 467 467 <option selected value="totals">Totals Only</option>
