PHP get_sql_for_po_search Beispiele

Beispiel #1

Datei: po_search.php Projekt: M-Shahbaz/FA

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();

Beispiel #2

Datei: po_search.php Projekt: pthdnq/ivalley-svn

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();