X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sales%2Fincludes%2Fui%2Fsales_order_ui.inc;h=ae2bd96471b46aa8bf830d7d441d5f667f80da56;hb=ec3b5ef00ee07bdf7559c8bdb6f857b7464c3fbe;hp=c5a8d317d0923bf0da65efbed72fe7fcbc4816dc;hpb=d6ccc05f1d97979ee67c33451fdfd9cf5f124bb9;p=fa-stable.git diff --git a/sales/includes/ui/sales_order_ui.inc b/sales/includes/ui/sales_order_ui.inc index c5a8d317..ae2bd964 100644 --- a/sales/includes/ui/sales_order_ui.inc +++ b/sales/includes/ui/sales_order_ui.inc @@ -4,20 +4,19 @@ include_once($path_to_root . "/sales/includes/cart_class.inc"); include_once($path_to_root . "/includes/manufacturing.inc"); //-------------------------------------------------------------------------------- - function add_to_order(&$order, $new_item, $new_item_qty, $price, $discount) { - foreach ($order->line_items AS $order_item) + foreach ($order->line_items AS $order_item) { - if (strcasecmp($order_item->stock_id, $new_item) == 0) - { - display_notification(_("For Part :") . $new_item . " " . _("This item is already on this order. You have been warned.")); - break; + if (strcasecmp($order_item->stock_id, $new_item) == 0) + { + display_notification(_("For Part :") . $new_item . " " . _("This item is already on this order. You have been warned.")); + break; } } - - $order->add_to_cart ($new_item, $new_item_qty, $price, $discount); + + $order->add_to_cart (count($order->line_items),$new_item, $new_item_qty, $price, $discount); } //--------------------------------------------------------------------------------- @@ -25,71 +24,54 @@ function add_to_order(&$order, $new_item, $new_item_qty, $price, $discount) function get_customer_details_to_order(&$order, $customer_id, $branch_id) { $ret_error = ""; - // Now check to ensure this account is not on hold */ - $sql = "SELECT ".TB_PREF."debtors_master.name, ".TB_PREF."debtors_master.address, ".TB_PREF."credit_status.dissallow_invoices, - ".TB_PREF."debtors_master.sales_type AS salestype, ".TB_PREF."sales_types.sales_type, ".TB_PREF."debtors_master.curr_code, - ".TB_PREF."debtors_master.discount - FROM ".TB_PREF."debtors_master, ".TB_PREF."credit_status, ".TB_PREF."sales_types - WHERE ".TB_PREF."debtors_master.sales_type=".TB_PREF."sales_types.id - AND ".TB_PREF."debtors_master.credit_status=".TB_PREF."credit_status.id - AND ".TB_PREF."debtors_master.debtor_no = '" . $customer_id . "'"; - $result =db_query($sql,"Customer Record Retreive"); + $myrow = get_customer_to_order($customer_id); - $myrow = db_fetch($result); - - $order->customer_id = $customer_id; - $order->Branch = $branch_id; - $order->customer_name = $myrow['name']; + $name = $myrow['name']; if ($myrow['dissallow_invoices'] == 1) $ret_error = _("The selected customer account is currently on hold. Please contact the credit control personnel to discuss."); - if (!isset($_POST['branch_id']) || $_POST['branch_id'] == "") - { - $ret_error = _("The selected customer does not have any branches. Please create at least one branch."); - unset($_POST['branch_id']); - $order->Branch = ""; - } + $deliver = $myrow['address']; // in case no delivery address. + + $order->set_customer($customer_id, $name, $myrow['curr_code'], + $myrow['discount'], $myrow['pymt_discount']); + + // the sales type determines the price list to be used by default + $order->set_sales_type($myrow['salestype'], $myrow['sales_type'], $myrow['tax_included'], + $myrow['factor']); - # the sales type determines the price list to be used by default - $order->default_sales_type = $myrow['salestype']; - $order->sales_type_name = $myrow['sales_type']; - $order->customer_currency = $myrow['curr_code']; - $order->default_discount = $myrow['discount']; - $deliver = $myrow['address']; // in case no deliveraddress. + $result = get_branch_to_order($customer_id, $branch_id); - if ($order->Branch != "") + if (db_num_rows($result) == 0) { - # the branch was also selected from the customer selection so default the delivery details from the customer branches table cust_branch. The order process will ask for branch details later anyway - $sql = "SELECT ".TB_PREF."cust_branch.br_name, ".TB_PREF."cust_branch.br_post_address, phone, email, - default_location, default_ship_via, - ".TB_PREF."tax_groups.name AS tax_group_name, ".TB_PREF."tax_groups.id AS tax_group_id - FROM ".TB_PREF."cust_branch, ".TB_PREF."tax_groups - WHERE ".TB_PREF."cust_branch.tax_group_id = ".TB_PREF."tax_groups.id - AND ".TB_PREF."cust_branch.branch_code='" . $order->Branch . "' - AND ".TB_PREF."cust_branch.debtor_no = '" . $order->customer_id . "'"; - - $result = db_query($sql,"Customer Branch Record Retreive"); - - if (db_num_rows($result) == 0) - { - return _("The selected customer and branch are not valid, or the customer does not have any branches."); - } - - $myrow = db_fetch($result); - $order->deliver_to = $myrow["br_name"]; - $order->delivery_address = $myrow["br_post_address"]; - if (strlen($order->delivery_address) <= 1) - $order->delivery_address = $deliver; - $order->phone = $myrow["phone"]; - $order->email = $myrow["email"]; - $order->Location = $myrow["default_location"]; - $order->ship_via = $myrow["default_ship_via"]; - $order->tax_group_name = $myrow["tax_group_name"]; - $order->tax_group_id = $myrow["tax_group_id"]; + return _("The selected customer and branch are not valid, or the customer does not have any branches."); } + $myrow = db_fetch($result); + + $order->set_branch($branch_id, $myrow["tax_group_id"], + $myrow["tax_group_name"], $myrow["phone"], $myrow["email"]); + + $address = $myrow["br_post_address"]; + + if (strlen($address) <= 1) // if branch has no address + $address = $deliver; // set sales order address + $order->set_delivery($myrow["default_ship_via"], $myrow["br_name"], + $address); + if ($order->trans_type == 10) { + $order->due_date = get_invoice_duedate($customer_id, $order->document_date); + if ($order->pos != -1) + $order->cash = date_diff($order->due_date, Today(), 'd')<2; + } + if($order->cash ) { + if($order->pos != -1) { + $paym = get_sales_point($order->pos); + $order->set_location($paym["pos_location"], $paym["location_name"]); + } + } else + $order->set_location($myrow["default_location"], $myrow["location_name"]); + return $ret_error; } @@ -100,137 +82,218 @@ function display_order_summary($title, &$order, $editable_items=false) global $table_style, $path_to_root; display_heading($title); + + div_start('items_table'); start_table("$table_style colspan=7 width=90%"); $th = array(_("Item Code"), _("Item Description"), _("Quantity"), + _("Delivered"), _("Unit"), _("Price"), _("Discount %"), _("Total"), ""); - if(count($order->line_items)) $th[]= ''; + if ($order->trans_no == 0) { + unset( $th[3] ); + } + + if (count($order->line_items)) + $th[]= ''; - table_header($th); + table_header($th); $total = 0; $k = 0; //row colour counter - foreach ($order->line_items as $line_no=>$stock_item) + $id = find_submit('Edit'); + foreach ($order->line_items as $line_no=>$stock_item) { - $line_total = $stock_item->quantity * $stock_item->price * (1 - $stock_item->discount_percent); - - if (!isset($_GET['Edit'])) - $id = -1; - else - $id = $_GET['Edit']; + $line_total = round($stock_item->qty_dispatched * $stock_item->price * (1 - $stock_item->discount_percent), + user_price_dec()); + + if (!$editable_items || $id != $line_no) { - alt_table_row_color($k); + alt_table_row_color($k); view_stock_status_cell($stock_item->stock_id); - - label_cell($stock_item->item_description); - qty_cell($stock_item->quantity); - label_cell($stock_item->units); - amount_cell($stock_item->price); - - amount_cell($stock_item->discount_percent * 100); - amount_cell($line_total); - - if ($editable_items) - { - edit_link_cell(SID . "Edit=$line_no"); - delete_link_cell(SID . "Delete=$line_no"); - } - end_row(); - } - else + + label_cell($stock_item->item_description, "nowrap" ); + qty_cell($stock_item->qty_dispatched, false, get_qty_dec($stock_item->stock_id)); + + if ($order->trans_no!=0) + amount_cell($stock_item->qty_done); + + label_cell($stock_item->units); + amount_cell($stock_item->price); + + percent_cell($stock_item->discount_percent * 100); + amount_cell($line_total); + + if ($editable_items) + { + edit_button_cell("Edit$line_no", _("Edit"), + _('Edit document line')); + edit_button_cell("Delete$line_no", _("Delete"), + _('Remove line from document')); + } + end_row(); + } + else { - sales_order_item_controls($order, $line_no); + sales_order_item_controls($order, $k, $line_no); } $total += $line_total; } - if (!isset($_GET['Edit']) && $editable_items) - sales_order_item_controls($order); + if ($id==-1 && $editable_items) + sales_order_item_controls($order, $k); - $display_total = number_format2($total,user_price_dec()); - label_row(_("Total Excluding Tax/Shipping"), $display_total, "colspan=6 align=right", - "nowrap align=right"); + $display_total = price_format($total); + label_row(_("Total Excluding Shipping"), $display_total, "colspan=6 align=right", + "nowrap align=right", 2); end_table(); + div_end(); } // ------------------------------------------------------------------------------ function display_order_header(&$order, $editable, $date_text, $display_tax_group=false) { - global $table_style; + global $table_style, $Ajax; + start_table("width=80% $table_style"); echo ""; // outer table echo ""; $customer_error = ""; + $change_prices = 0; if (isset($order) && !$editable) { // can't change the customer/branch if items already received on this order echo $order->customer_name . " - " . $order->deliver_to; - } - else + hidden('customer_id', $order->customer_id); + hidden('branch_id', $order->Branch); + hidden('sales_type', $order->sales_type); + } + else { - - if (!isset($_POST['customer_id']) && (get_global_customer() != reserved_words::get_all())) - $_POST['customer_id'] = get_global_customer(); - customer_list_row(_("Customer:"), 'customer_id', null, false, true); - if (!isset($_POST['delivery_date'])) - { - if ($order->trans_type=='invoice') - $_POST['delivery_date'] = $_SESSION['Items']->delivery_date = - get_invoice_duedate($_POST['customer_id'], $_POST['OrderDate']); - else - $_POST['delivery_date'] = $_SESSION['Items']->delivery_date = - add_days($_POST['OrderDate'], 10); - } - if ($order->customer_id != $_POST['customer_id']) + if ($order->customer_id != get_post('customer_id', -1)) { // customer has changed + $Ajax->activate('branch_id'); + } + customer_branches_list_row(_("Branch:"), + $_POST['customer_id'], 'branch_id', null, false, true, true); - // delete all the order items - drastic but necessary because of - // change of currency, sales type, etc - $order->clear_items(); - - // clear the branch selection - unset($_POST['branch_id']); - } - - customer_branches_list_row(_("Branch:"), $_POST['customer_id'], 'branch_id', null, false, true, true); + if( ($order->customer_id != get_post('customer_id', -1)) || + ($order->Branch != get_post('branch_id', -1)) || + list_updated('customer_id')) { - if (!isset($_POST['branch_id'])) - $_POST['branch_id'] = ""; - //set_global_customer($_POST['customer_id']); - if (($order->customer_id != $_POST['customer_id']) || - ($order->Branch != $_POST['branch_id'])) - $customer_error = get_customer_details_to_order($order, $_POST['customer_id'], $_POST['branch_id']); + if (!isset($_POST['branch_id']) || $_POST['branch_id'] == "") + { + // ignore errors on customer search box call + if ($_POST['customer_id'] == '') + $customer_error = _("No customer found for entered text."); + else + $customer_error = _("The selected customer does not have any branches. Please create at least one branch."); + unset($_POST['branch_id']); + $order->Branch = 0; + } else + { + $old_order = (PHP_VERSION<5) ? $order : clone( $order ); + $customer_error = get_customer_details_to_order($order, $_POST['customer_id'], $_POST['branch_id']); + + $_POST['Location'] = $order->Location; + $_POST['deliver_to'] = $order->deliver_to; + $_POST['delivery_address'] = $order->delivery_address; + $_POST['phone'] = $order->phone; + $_POST['cash'] = $order->cash; + if ($order->trans_type == 10) + { + $_POST['delivery_date'] = $order->due_date; + $Ajax->activate('delivery_date'); + } + $Ajax->activate('Location'); + $Ajax->activate('deliver_to'); + $Ajax->activate('phone'); + $Ajax->activate('delivery_address'); + $Ajax->activate('cash'); + // change prices if necessary + // what about discount in template case? + if ($old_order->customer_currency != $order->customer_currency) { + $change_prices = 1; + } + if ($old_order->sales_type != $order->sales_type) { + // || $old_order->default_discount!=$order->default_discount + $_POST['sales_type'] = $order->sales_type; + $Ajax->activate('sales_type'); + $change_prices = 1; + } + unset($old_order); + } set_global_customer($_POST['customer_id']); + } // changed branch + } + + if ($_SESSION['Items']->trans_type!=30) { + ref_cells(_("Reference").':', 'ref', _('Reference number unique for this document type'), null, ''); } + echo "
"; echo ""; // outer table if (!is_company_currency($order->customer_currency)) { + div_start('currency'); echo ""; label_row(_("Customer Currency:"), $order->customer_currency); - exchange_rate_display($order->customer_currency, get_company_currency(), - ($editable?$_POST['OrderDate']:$order->orig_order_date), $editable); + exchange_rate_display($order->customer_currency, get_company_currency(), + ($editable ? $_POST['OrderDate'] : $order->document_date)); echo "
"; + div_end(); echo ""; // outer table } + echo ""; - label_row(_("Sales Type:"), $order->sales_type_name); + if ($order->trans_type == 10 && $order->pos != -1) { + sale_payment_list_cells(_('Payment:'), 'cash', null, true); + $cash_payment = get_post('cash', 0); + // current user can issue both credit and cash invoices + if ($order->cash != $cash_payment) { + $order->cash = $cash_payment; + if ($cash_payment) { + $paym = get_sales_point(user_pos()); + $order->cash_account = $paym['pos_account']; + $order->account_name = $paym['bank_account_name']; + $_POST['Location'] = $order->Location = $paym['pos_location']; + $order->location_name = $paym['location_name']; + } + check_qoh($order); + $Ajax->activate('delivery'); + set_focus($order->pos == -1 ? 'delivery_date' : 'account'); + } + } else + hidden('cash', $order->cash); + + if($editable) { + $str = sales_types_list_row(_("Price List"), 'sales_type', null, true); + } else { + label_row(_("Price List:"), $order->sales_type_name); + } + if ($order->sales_type != $_POST['sales_type']) { + $myrow = get_sales_type($_POST['sales_type']); + $order->set_sales_type($myrow['id'], $myrow['sales_type'], + $myrow['tax_included'], $myrow['factor']); + $Ajax->activate('sales_type'); + $change_prices = 1; + } + label_row(_("Customer Discount:"), ($order->default_discount * 100) . "%"); echo "
"; @@ -238,104 +301,127 @@ function display_order_header(&$order, $editable, $date_text, $display_tax_group echo ""; - if ($editable) + if ($editable) { - if (!isset($_POST['OrderDate']) || $_POST['OrderDate'] == "") - $_POST['OrderDate'] = $order->orig_order_date; - - date_row($date_text, 'OrderDate'); + if (!isset($_POST['OrderDate']) || $_POST['OrderDate'] == "") + $_POST['OrderDate'] = $order->document_date; + + date_row($date_text, 'OrderDate', + _('Date of order receive'), null, 0, 0, 0, null, true); + if (isset($_POST['_OrderDate_changed'])) { + $change_prices = 1; + $Ajax->activate('currency'); + if ($order->trans_type == 10) { + $_POST['delivery_date'] = get_invoice_duedate(get_post('customer_id'), get_post('OrderDate')); + } else + $_POST['delivery_date'] = add_days(get_post('OrderDate'), sys_prefs::default_delivery_required_by()); + $Ajax->activate('delivery_date'); + } } - else + else { - label_row($date_text, $order->orig_order_date); - hidden('OrderDate', $order->orig_order_date); + label_row($date_text, $order->document_date); + hidden('OrderDate', $order->document_date); } - if ($display_tax_group) + if ($display_tax_group) { - if ($editable) - { - if (!isset($_POST['tax_group_id'])) - $_POST['tax_group_id'] = $_SESSION['Items']->tax_group_id; - tax_groups_list_row(_("Tax Group:"), 'tax_group_id', $_POST['tax_group_id'], true); - } - else - { - label_row(_("Tax Group:"), $order->tax_group_name); - hidden('tax_group_id', $_SESSION['Items']->tax_group_id); - } + label_row(_("Tax Group:"), $order->tax_group_name); + hidden('tax_group_id', $_SESSION['Items']->tax_group_id); } echo "
"; echo ""; - + end_table(1); // outer table + if ($change_prices != 0) { + foreach ($order->line_items as $line_no=>$item) { + $line = &$order->line_items[$line_no]; + $line->price = get_price($line->stock_id, $order->customer_currency, + $order->sales_type, $order->price_factor, get_post('OrderDate')); + // $line->discount_percent = $order->default_discount; + } + $Ajax->activate('items_table'); + } + return $customer_error; } //-------------------------------------------------------------------------------- -function sales_order_item_controls(&$order, $line_no=-1) +function sales_order_item_controls(&$order, &$rowcounter, $line_no=-1) { - start_row(); - if (isset($_GET['Edit']) && $line_no != -1) + global $Ajax; + + alt_table_row_color($rowcounter); + + $id = find_submit('Edit'); + if ($line_no!=-1 && $line_no == $id) { - if (!isset($_POST['stock_id'])) - $_POST['stock_id'] = $order->line_items[$_GET['Edit']]->stock_id; - if (!isset($_POST['qty']) || ($_POST['qty'] == "")) - $_POST['qty'] = $order->line_items[$_GET['Edit']]->quantity; - if (!isset($_POST['price']) || ($_POST['price'] == "")) - $_POST['price'] = $order->line_items[$_GET['Edit']]->price; - if (!isset($_POST['Disc']) || ($_POST['Disc'] == "")) - $_POST['Disc'] = ($order->line_items[$_GET['Edit']]->discount_percent)*100; - - $_POST['units'] = $order->line_items[$_GET['Edit']]->units; + $_POST['stock_id'] = $order->line_items[$id]->stock_id; + $dec = get_qty_dec($_POST['stock_id']); + $_POST['qty'] = number_format2($order->line_items[$id]->qty_dispatched, $dec); + $_POST['price'] = price_format($order->line_items[$id]->price); + $_POST['Disc'] = percent_format($order->line_items[$id]->discount_percent*100); + $units = $order->line_items[$id]->units; hidden('stock_id', $_POST['stock_id']); label_cell($_POST['stock_id']); - label_cell($order->line_items[$line_no]->item_description); - } - else + label_cell($order->line_items[$line_no]->item_description, "nowrap"); + $Ajax->activate('items_table'); + } + else { - global $no_item_list; - if ($no_item_list) - { - echo "\n"; - stock_items_list('stock_id', null, false, true); - echo "\n"; - } - else - { - text_cells(null, "StockID2", "", 12, 10, "", "", "onkeyup='recalcAccounts();' onKeyDown='if(event.keyCode==13) event.keyCode=9;' onblur='return setAccount(0, true);'"); - stock_items_list_cells(null, 'stock_id', null, false, false, "onchange='return setAccount(1, true)'"); + stock_items_list_cells(null,'stock_id', null, false, true); + if (list_updated('stock_id')) { + $Ajax->activate('price'); + $Ajax->activate('units'); + $Ajax->activate('qty'); + $Ajax->activate('line_total'); } + $item_info = get_item_edit_info($_POST['stock_id']); - $_POST['units'] = $item_info["units"]; + $units = $item_info["units"]; + $dec = get_qty_dec($_POST['stock_id']); + $_POST['qty'] = number_format2(1, $dec); - $_POST['qty'] = 1; - $_POST['price'] = get_price ($_POST['stock_id'], $order->customer_id); + $_POST['price'] = price_format(get_price ($_POST['stock_id'], + $order->customer_currency, $order->sales_type, + $order->price_factor, get_post('OrderDate'))); // default to the customer's discount % - $_POST['Disc'] = $order->default_discount * 100; + $_POST['Disc'] = percent_format($order->default_discount * 100); + } - text_cells(null, 'qty', $_POST['qty'], 12, 15); + qty_cells(null, 'qty', $_POST['qty'], null, null, $dec); - label_cell($_POST['units']); - amount_cells(null, 'price'); - text_cells(null, 'Disc', $_POST['Disc'], 7, 5); + if ($order->trans_no!=0) { + qty_cell($line_no==-1 ? 0 :$order->line_items[$line_no]->qty_done, false, $dec); + } + + label_cell($units, '', 'units'); + + $str = amount_cells(null, 'price'); - $line_total = $_POST['qty'] * $_POST['price'] * (1 - $_POST['Disc'] / 100); - amount_cell($line_total); + small_amount_cells(null, 'Disc', percent_format($_POST['Disc']), null, null, user_percent_dec()); - if (isset($_GET['Edit'])) + $line_total = input_num('qty') * input_num('price') * (1 - input_num('Disc') / 100); + + amount_cell($line_total, false, '','line_total'); + + if ($id!=-1) { - submit_cells('UpdateItem', _("Update")); - submit_cells('CancelItemChanges', _("Cancel")); + edit_button_cell('UpdateItem', _("Update"), + _('Confirm changes')); + edit_button_cell('CancelItemChanges', _("Cancel"), + _('Cancel changes')); hidden('LineNo', $line_no); - } - else + set_focus('qty'); + } + else { - submit_cells('AddItem', _("Add Item"), "colspan=2"); + submit_cells('AddItem', _("Add Item"), "colspan=2", + _('Add new item to document'), true); } end_row(); @@ -345,51 +431,95 @@ function sales_order_item_controls(&$order, $line_no=-1) function display_delivery_details(&$order) { - global $table_style2; + global $table_style2, $Ajax; - if ($order->trans_type=='invoice') - { - $title = _("Invoice Delivery Details"); - $delname = _("Due Date"); - } - else - { - $title = _("Order Delivery Details"); - $delname = _("Required Delivery Date:"); - } - display_heading($title); - echo "
"; - start_table("$table_style2 width=90%"); - echo ""; // outer table - - echo ""; - locations_list_row(_("Deliver from Location:"), 'Location', $order->Location); - - date_row($delname, 'delivery_date', $order->delivery_date, 0, 0, 0); +div_start('delivery'); - text_row(_("Deliver To:"), 'deliver_to', $order->deliver_to, 40, 40); + if (get_post('cash', 0)) { // Direct payment sale + display_heading(_('Cash payment')); + echo "
"; + label_row(_("Deliver from Location:"), $order->location_name); - textarea_row(_("Address:"), 'delivery_address', $order->delivery_address, 35, 5); - text_row(_("Contact Phone Number:"), 'phone', $order->phone, 25, 25); + hidden('Location', $order->Location); + label_row(_("Cash account:"), $order->account_name); + textarea_row(_("Comments:"), "Comments", $order->Comments, 31, 5); + echo "
"; + } else { - echo ""; + if ($order->trans_type==10) + { + $title = _("Delivery Details"); + $delname = _("Due Date").':'; + } + elseif ($order->trans_type==13) + { + $title = _("Invoice Delivery Details"); + $delname = _("Invoice before").':'; + } + else + { + $title = _("Order Delivery Details"); + $delname = _("Required Delivery Date").':'; + } + display_heading($title); + echo "
"; + start_table("$table_style2 width=90%"); + echo ""; // outer table + echo ""; + + locations_list_row(_("Deliver from Location:"), 'Location', null, + false, true); + if (list_updated('Location')) + check_qoh($order); + + date_row($delname, 'delivery_date', + $order->trans_type==30 ? _('Enter requested day of delivery') : '', + $order->due_date, 0, 0, 0); + text_row(_("Deliver To:"), 'deliver_to', $order->deliver_to, 40, 40, + _('Additional identifier for delivery e.g. name of receiving person')); + + textarea_row(_("Address:"), 'delivery_address', $order->delivery_address, 35, 5, + _('Delivery address. Default is address of customer branch')); + text_row(_("Contact Phone Number:"), 'phone', $order->phone, 25, 25, + _('Phone number of ordering person. Defaults to branch phone number')); - echo "
"; // outer table + echo "
"; - echo ""; + echo ""; - end_table(1); // outer table + shippers_list_row(_("Shipping Company:"), 'ship_via', $order->ship_via); + echo "
"; // outer table - text_row(_("Customer Reference:"), 'cust_ref', $order->cust_ref, 25, 25); - textarea_row(_("Comments:"), "Comments", $order->Comments, 31, 5); + echo ""; - text_row(_("Shipping Charge:"), 'freight_cost', $order->freight_cost, 10, 10); + text_row(_("Customer Reference:"), 'cust_ref', $order->cust_ref, 25, 25, + _('Customer reference number for this order (if any)')); + textarea_row(_("Comments:"), "Comments", $order->Comments, 31, 5); - shippers_list_row(_("Shipping Company:"), 'ship_via', $order->ship_via); - if ($_SESSION['Items']->trans_type=='delivery') - textarea_row(_("Memo"), 'InvoiceText', null, 31, 3); - echo "
"; + small_amount_row(_("Shipping Charge:"), 'freight_cost', + price_format(get_post('freight_cost',0))); - echo "
"; + echo ""; + end_table(1); // outer table + } + div_end(); } +function check_qoh($order) +{ + $msg = ''; + foreach($order->line_items as $line_no => $line) { + $qoh = get_qoh_on_date($line->stock_id, $_POST['Location'], $_POST['OrderDate']); + if ($line->qty_dispatched > $qoh) { + $msg .= $line->stock_id . " - " . $line->item_description . ": " . + _("Quantity On Hand") . " = " + . number_format2($qoh, get_qty_dec($line->stock_id)) . '
'; + } + } + if (strlen($msg)) { + display_error(_("The delivery cannot be processed because there is an insufficient quantity for item:") + . '
'. $msg); + return false; + } + return true; +} ?> \ No newline at end of file