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