Changeset 412

Timestamp:

06/18/08 01:13:25

Author:

jceh

Message:

link to invoice from product sales history, and sortable order date (default being desc).

Files:

• trunk/phpbms/modules/bms/products_saleshistory.php (modified) (6 diffs)

trunk/phpbms/modules/bms/products_saleshistory.php

@@ -46 +46 @@
-        if(!isset($_POST["status"])) $_POST["status"]="Orders/Invoices";
-        if(!isset($_POST["command"])) $_POST["command"]="show";
+        if(!isset($_POST["date_order"])) $_POST["date_order"]="desc";
-
-        if($_POST["command"]=="print")  {
@@ -68 +69 @@
-                break;
-        }
+    $date_order_reverse = $_POST['date_order'] == 'desc' ? 'asc' : 'desc';
-
-        $mysqlfromdate=sqlDateFromString($_POST["fromdate"]);
@@ -89 +91 @@
-                AND ".$thestatus."
-                HAVING thedate >=\"".$mysqlfromdate."\"
-"
+ " .$_POST["date_order"]
-        $queryresult=$db->query($querystatement);
-
@@ -133 +135 @@
-                <p id="printP"><br /><input id="print" name="command" type="submit" value="print" class="Buttons" /></p>
-                <p id="changeTimelineP"><br /><input name="command" type="submit" value="change timeframe/view" class="smallButtons" /></p>
+                <input name="date_order" id="date_order" type="hidden" value="<?php echo $_POST["date_order"]; ?>" />
-        </div>
-
@@ -138 +141 @@
-   <table border="0" cellpadding="3" cellspacing="0" class="querytable">
-        <tr>
-
-
+
+
+
+
-         <th nowrap="nowrap" class="queryheader" width="100%" align="left">Client</th>
-         <th align="center" nowrap="nowrap" class="queryheader">Qty.</th>
@@ -163 +168 @@
-?>
-        <tr class="row<?php echo $row?>">
+         <td>
+                <button type="button" class="invisibleButtons" onclick="location.href='<?php echo getAddEditFile($db,3) ?>?id=<?php echo $therecord["id"]?>'"><img src="<?php echo APP_PATH ?>common/stylesheet/<?php echo STYLESHEET ?>/image/button-edit.png" align="middle" alt="edit" width="16" height="16" border="0" /></button>
+         </td>
-         <td align="center" nowrap="nowrap"><?php echo $therecord["id"]?></td>
-         <td align="center" nowrap="nowrap"><?php echo $therecord["thedate"]?formatFromSQLDate($therecord["thedate"]):"&nbsp;" ?></td>