-$sql .= " GROUP BY ".TB_PREF."purch_orders.order_no";
-
-$result = db_query($sql,"No orders were returned");
-
-print_hidden_script(18);
-
-div_start('orders_tbl');
-start_table("$table_style colspan=7 width=80%");
-
-if (isset($_POST['StockLocation']) && $_POST['StockLocation'] == reserved_words::get_all())
- $th = array(_("#"), _("Reference"), _("Supplier"), _("Location"),
- _("Supplier's Reference"), _("Order Date"), _("Currency"), _("Order Total"),"");
-else
- $th = array(_("#"), _("Reference"), _("Supplier"),
- _("Supplier's Reference"), _("Order Date"), _("Currency"), _("Order Total"),"");
-
-table_header($th);
-
-$j = 1;
-$k = 0; //row colour counter
-while ($myrow = db_fetch($result))
-{
-
- alt_table_row_color($k);
-
- $date = sql2date($myrow["ord_date"]);
+$sql .= " GROUP BY porder.order_no";
+
+$cols = array(
+ _("#") => array('fun'=>'trans_view', 'ord'=>''),
+ _("Reference"),
+ _("Supplier") => array('ord'=>''),
+ _("Location"),
+ _("Supplier's Reference"),
+ _("Order Date") => array('name'=>'ord_date', 'type'=>'date', 'ord'=>'desc'),
+ _("Currency") => array('align'=>'center'),
+ _("Order Total") => 'amount',
+ array('insert'=>true, 'fun'=>'edit_link'),
+ array('insert'=>true, 'fun'=>'prt_link'),
+);
+
+if (get_post('StockLocation') != $all_items) {
+ $cols[_("Location")] = 'skip';
+}
+//---------------------------------------------------------------------------------------------------