Changeset 205 for trunk/phpbms/modules/bms/products_saleshistory.php
- Timestamp:
- 03/26/07 16:50:25 (5 years ago)
- Files:
-
- 1 modified
Legend:
- Unmodified
- Added
- Removed
-
trunk/phpbms/modules/bms/products_saleshistory.php
r204 r205 116 116 <label for="status">type</label><br /> 117 117 <select name="status" id="status"> 118 <option value="Orders/Invoices" <?php if($_POST["status"]=="Orders/Invoices") echo "selected "?>>Orders/Invoices</option>119 <option value="Invoices" <?php if($_POST["status"]=="Invoices") echo "selected "?>>Invoices</option>120 <option value="Orders" <?php if($_POST["status"]=="Orders") echo "selected "?>>Orders</option>118 <option value="Orders/Invoices" <?php if($_POST["status"]=="Orders/Invoices") echo "selected=\"selected\""?>>Orders/Invoices</option> 119 <option value="Invoices" <?php if($_POST["status"]=="Invoices") echo "selected=\"selected\""?>>Invoices</option> 120 <option value="Orders" <?php if($_POST["status"]=="Orders") echo "selected=\"selected\""?>>Orders</option> 121 121 </select> 122 122 </p> … … 138 138 <table border="0" cellpadding="3" cellspacing="0" class="querytable"> 139 139 <tr> 140 <th align="center" nowrap class="queryheader">ID</th>141 <th align="center" nowrap class="queryheader">Order Date</th>142 <th nowrap class="queryheader" width="100%" align="left">Client</th>143 <th align="center" nowrap class="queryheader">Qty.</th>144 <th align="right" nowrap class="queryheader">Unit Cost</th>145 <th align="right" nowrap class="queryheader">Cost Ext.</th>146 <th align="right" nowrap class="queryheader">Unit Price</th>147 <th align="right" nowrap class="queryheader">Price Ext.</th>140 <th align="center" nowrap="nowrap" class="queryheader">ID</th> 141 <th align="center" nowrap="nowrap" class="queryheader">Order Date</th> 142 <th nowrap="nowrap" class="queryheader" width="100%" align="left">Client</th> 143 <th align="center" nowrap="nowrap" class="queryheader">Qty.</th> 144 <th align="right" nowrap="nowrap" class="queryheader">Unit Cost</th> 145 <th align="right" nowrap="nowrap" class="queryheader">Cost Ext.</th> 146 <th align="right" nowrap="nowrap" class="queryheader">Unit Price</th> 147 <th align="right" nowrap="nowrap" class="queryheader">Price Ext.</th> 148 148 </tr> 149 149 <?php … … 163 163 ?> 164 164 <tr class="row<?php echo $row?>"> 165 <td align="center" nowrap ><?php echo $therecord["id"]?></td>166 <td align="center" nowrap ><?php echo $therecord["thedate"]?formatFromSQLDate($therecord["thedate"]):" " ?></td>167 <td nowrap ><?php echo $therecord["client"]?></td>168 <td align="center" nowrap ><?php echo number_format($therecord["qty"],2)?></td>169 <td align="right" nowrap ><?php echo "\$".number_format($therecord["cost"],2)?></td>170 <td align="right" nowrap ><?php echo "\$".number_format($therecord["extendedcost"],2)?></td>171 <td align="right" nowrap ><?php echo "\$".number_format($therecord["price"],2)?></td>172 <td align="right" nowrap ><?php echo "\$".number_format($therecord["extended"],2)?></td>165 <td align="center" nowrap="nowrap"><?php echo $therecord["id"]?></td> 166 <td align="center" nowrap="nowrap"><?php echo $therecord["thedate"]?formatFromSQLDate($therecord["thedate"]):" " ?></td> 167 <td nowrap="nowrap"><?php echo $therecord["client"]?></td> 168 <td align="center" nowrap="nowrap"><?php echo number_format($therecord["qty"],2)?></td> 169 <td align="right" nowrap="nowrap"><?php echo "\$".number_format($therecord["cost"],2)?></td> 170 <td align="right" nowrap="nowrap"><?php echo "\$".number_format($therecord["extendedcost"],2)?></td> 171 <td align="right" nowrap="nowrap"><?php echo "\$".number_format($therecord["price"],2)?></td> 172 <td align="right" nowrap="nowrap"><?php echo "\$".number_format($therecord["extended"],2)?></td> 173 173 </tr> 174 174 <?php } if(!mysql_num_rows($queryresult)) {?> 175 <tr><td colspan="9" align= centerstyle="padding:0px;"><div class="norecords">No Sales Data for Given Timeframe</div></td></tr>175 <tr><td colspan="9" align="center" style="padding:0px;"><div class="norecords">No Sales Data for Given Timeframe</div></td></tr> 176 176 <?php }?> 177 177 <tr> … … 180 180 <td class="queryfooter"> </td> 181 181 <td align="center" class="queryfooter"><?php echo number_format($totalquantity,2)?></td> 182 <td align="right" nowrap class="queryfooter">avg. = <?php $numrows?$avgcost=$avgcost/$numrows:$avgcost=0; echo "\$".number_format($avgcost,2)?></td>182 <td align="right" nowrap="nowrap" class="queryfooter">avg. = <?php $numrows?$avgcost=$avgcost/$numrows:$avgcost=0; echo "\$".number_format($avgcost,2)?></td> 183 183 <td align="right" class="queryfooter"><?php echo "\$".number_format($totalcostextended,2)?></td> 184 <td align="right" nowrap class="queryfooter">avg. = <?php $numrows?$avgprice=$avgprice/$numrows:$avgprice=0; echo "\$".number_format($avgprice,2)?></td>184 <td align="right" nowrap="nowrap" class="queryfooter">avg. = <?php $numrows?$avgprice=$avgprice/$numrows:$avgprice=0; echo "\$".number_format($avgprice,2)?></td> 185 185 <td align="right" class="queryfooter"><?php echo "\$".number_format($totalextended,2)?></td> 186 186 </tr>
