function receive_link($row) { return pager_link(_("Receive"), "/purchasing/po_receive_items.php?PONumber=" . $row["order_no"], ICON_RECEIVE); } function check_overdue($row) { return $row['OverDue'] == 1; } //--------------------------------------------------------------------------------------------- if (isset($_POST['order_number']) && $_POST['order_number'] != "") { $order_number = $_POST['order_number']; } if (isset($_POST['SelectStockFromList']) && $_POST['SelectStockFromList'] != "" && $_POST['SelectStockFromList'] != $all_items) { $selected_stock_item = $_POST['SelectStockFromList']; } else { unset($selected_stock_item); } //figure out the sql required from the inputs available $sql = get_sql_for_po_search($_POST['supplier_id']); //$result = db_query($sql,"No orders were returned"); /*show a table of the orders returned by the sql */ $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'), array('insert' => true, 'fun' => 'receive_link')); if (get_post('StockLocation') != $all_items) { $cols[_("Location")] = 'skip'; } $table =& new_db_pager('orders_tbl', $sql, $cols); $table->set_marker('check_overdue', _("Marked orders have overdue items.")); $table->width = "80%"; display_db_pager($table); end_form(); end_page();
function receive_link($row) { return pager_link(_("Receive"), "/purchasing/po_receive_items.php?PONumber=" . $row["order_no"], ICON_RECEIVE); } function check_overdue($row) { return $row['OverDue'] == 1; } //--------------------------------------------------------------------------------------------- if (isset($_POST['order_number']) && $_POST['order_number'] != "") { $order_number = $_POST['order_number']; } if (isset($_POST['SelectStockFromList']) && $_POST['SelectStockFromList'] != "" && $_POST['SelectStockFromList'] != $all_items) { $selected_stock_item = $_POST['SelectStockFromList']; } else { unset($selected_stock_item); } //figure out the sql required from the inputs available $sql = get_sql_for_po_search(); //$result = db_query($sql,"No orders were returned"); /*show a table of the orders returned by the sql */ $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'), array('insert' => true, 'fun' => 'receive_link')); if (get_post('StockLocation') != $all_items) { $cols[_("Location")] = 'skip'; } $table =& new_db_pager('orders_tbl', $sql, $cols); $table->set_marker('check_overdue', _("Marked orders have overdue items.")); $table->width = "80%"; display_db_pager($table); end_form(); end_page();