Hi
I am using the orderlist contribution but i need to get it to do 2 things one is to remove despached items from the report and also list the attibutes of the products if possible?
I have tried to use exclude to exclude the depatched...........
$orders_query = tep_db_query("SELECT * from " . TABLE_ORDERS . " ORDER by orders_status, orders_id desc");
while($orders_rows = tep_db_fetch_array($orders_query, $exclude = 'Despached')
this didnt work, fortunatly didnt make an error but still listed the despached items!
any help would be really aprechiated
regards
Jack
here is the code of the contribution,
*/
require('includes/application_top.php');
// get main currency symbol for this store
$currency_query = tep_db_query("select symbol_left from " . TABLE_CURRENCIES . " where code = '".DEFAULT_CURRENCY."' ");
$currency_symbol_results = tep_db_fetch_array($currency_query);
$store_currency_symbol = tep_db_output($currency_symbol_results['symbol_left']);
setlocale(LC_MONETARY, 'en_US');
function get_month($mo, $yr) {
$query = "SELECT * FROM " . TABLE_ORDERS. " WHERE date_purchased LIKE \"$yr-$mo%\"";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
$month=0;
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
$month++;
}
mysql_free_result($result);
return $month;
}
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
<script language="javascript" src="includes/general.js"></script>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->
<!-- body //-->
<table border="0" width="100%" cellspacing="2" cellpadding="2">
<tr>
<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
</table></td>
<!-- body_text //-->
<table>
<tr><td>
<TABLE BORDER=1 CELLPADDING=5 CELLSPACING=1>
<tr>
<th class=dataTableHeadingRow bgcolor=silver>Status</th>
<th class=dataTableHeadingRow bgcolor=silver>Order No.</th>
<th class=dataTableHeadingRow bgcolor=silver>Qty</th>
<th class=dataTableHeadingRow bgcolor=silver>Product Description</th>
<th class=dataTableHeadingRow bgcolor=silver>Price</th>
</tr>
<?php
$orders = "";
$orders_query = tep_db_query("SELECT * from " . TABLE_ORDERS . " ORDER by orders_status, orders_id desc");
while($orders_rows = tep_db_fetch_array($orders_query, $exclude = 'Despached'))
{
$products = "";
$products_query = tep_db_query("SELECT * FROM " . TABLE_ORDERS_PRODUCTS . " WHERE orders_id = '" . $orders_rows['orders_id'] . "' ");
while($products_rows = tep_db_fetch_array($products_query))
{
$ordStatus="";
$ordStatus_query = tep_db_query("SELECT * from " . TABLE_ORDERS_STATUS . " WHERE orders_status_id = '" . $orders_rows['orders_status'] . "' ");
$ordStatus_rows = tep_db_fetch_array($ordStatus_query);
echo "<tr>";
echo "<td class=dataTableContent>" . $ordStatus_rows["orders_status_name"] . "</td>";
echo "<td class=dataTableContent>" . $orders_rows["orders_id"] . "</td>";
echo "<td class=dataTableContent>" . $products_rows["products_quantity"] . "</td>";
echo "<td class=dataTableContent>" . $products_rows["products_name"] . "</td>";
echo "<td class=dataTableContent>" . $products_rows["products_price"] . "</td>";
echo "</tr>";
}
}
?>
</TABLE>
<!-- body_text_eof //-->
</td>
</tr>
</table>
<!-- body_eof //-->
<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
</body>
</html>
New 
