PHP get_sql_for_sales_deliveries_view示例

示例#1

文件： sales_deliveries_view.php 项目： M-Shahbaz/FA

    return $row["Outstanding"] == 0 ? '' : pager_link(_('Edit'), "/sales/customer_delivery.php?ModifyDelivery=" . $row['trans_no'], ICON_EDIT);
}
function prt_link($row)
{
    return print_document_link($row['trans_no'], _("Print"), true, ST_CUSTDELIVERY, ICON_PRINT);
}
function invoice_link($row)
{
    return $row["Outstanding"] == 0 ? '' : pager_link(_('Invoice'), "/sales/customer_invoice.php?DeliveryNumber=" . $row['trans_no'], ICON_DOC);
}
function check_overdue($row)
{
    return date1_greater_date2(Today(), sql2date($row["due_date"])) && $row["Outstanding"] != 0;
}
//------------------------------------------------------------------------------------------------
$sql = get_sql_for_sales_deliveries_view($selected_customer, $selected_stock_item, $_POST['customer_id']);
$cols = array(_("Delivery #") => array('fun' => 'trans_view'), _("Customer"), 'branch_code' => 'skip', _("Branch") => array('ord' => ''), _("Contact"), _("Reference"), _("Cust Ref"), _("Delivery Date") => array('type' => 'date', 'ord' => ''), _("Due By") => 'date', _("Delivery Total") => array('type' => 'amount', 'ord' => ''), _("Currency") => array('align' => 'center'), submit('BatchInvoice', _("Batch"), false, _("Batch Invoicing")) => array('insert' => true, 'fun' => 'batch_checkbox', 'align' => 'center'), array('insert' => true, 'fun' => 'edit_link'), array('insert' => true, 'fun' => 'invoice_link'), array('insert' => true, 'fun' => 'prt_link'));
//-----------------------------------------------------------------------------------
if (isset($_SESSION['Batch'])) {
    foreach ($_SESSION['Batch'] as $trans => $del) {
        unset($_SESSION['Batch'][$trans]);
    }
    unset($_SESSION['Batch']);
}
$table =& new_db_pager('deliveries_tbl', $sql, $cols);
$table->set_marker('check_overdue', _("Marked items are overdue."));
//$table->width = "92%";
display_db_pager($table);
end_form();
end_page();
?>

示例#2

文件： sales_deliveries_view.php 项目： pthdnq/ivalley-svn

    return $row["Outstanding"] == 0 ? '' : pager_link(_('Edit'), "/sales/customer_delivery.php?ModifyDelivery=" . $row['trans_no'], ICON_EDIT);
}
function prt_link($row)
{
    return print_document_link($row['trans_no'], _("Print"), true, ST_CUSTDELIVERY, ICON_PRINT);
}
function invoice_link($row)
{
    return $row["Outstanding"] == 0 ? '' : pager_link(_('Invoice'), "/sales/customer_invoice.php?DeliveryNumber=" . $row['trans_no'], ICON_DOC);
}
function check_overdue($row)
{
    return date1_greater_date2(Today(), sql2date($row["due_date"])) && $row["Outstanding"] != 0;
}
//------------------------------------------------------------------------------------------------
$sql = get_sql_for_sales_deliveries_view($selected_customer, $selected_stock_item);
$cols = array(_("Delivery #") => array('fun' => 'trans_view'), _("Customer"), 'branch_code' => 'skip', _("Branch") => array('ord' => ''), _("Contact"), _("Reference"), _("Cust Ref"), _("Delivery Date") => array('type' => 'date', 'ord' => ''), _("Due By") => 'date', _("Delivery Total") => array('type' => 'amount', 'ord' => ''), _("Currency") => array('align' => 'center'), submit('BatchInvoice', _("Batch"), false, _("Batch Invoicing")) => array('insert' => true, 'fun' => 'batch_checkbox', 'align' => 'center'), array('insert' => true, 'fun' => 'edit_link'), array('insert' => true, 'fun' => 'invoice_link'), array('insert' => true, 'fun' => 'prt_link'));
//-----------------------------------------------------------------------------------
if (isset($_SESSION['Batch'])) {
    foreach ($_SESSION['Batch'] as $trans => $del) {
        unset($_SESSION['Batch'][$trans]);
    }
    unset($_SESSION['Batch']);
}
$table =& new_db_pager('deliveries_tbl', $sql, $cols);
$table->set_marker('check_overdue', _("Marked items are overdue."));
//$table->width = "92%";
display_db_pager($table);
end_form();
end_page();
?>