X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sales%2Fincludes%2Fui%2Fsales_order_ui.inc;h=2b2b028465ea5d045677f52ec424a38fa8f3bd29;hb=66626dafdf0a397406e36663f3ed15321d09984a;hp=fd4326f89f9284a09fd344fa31072c2f624f5b0b;hpb=431531eebf3ba494002cfbf7ea36f9e82d4975c0;p=fa-stable.git diff --git a/sales/includes/ui/sales_order_ui.inc b/sales/includes/ui/sales_order_ui.inc index fd4326f8..2b2b0284 100644 --- a/sales/includes/ui/sales_order_ui.inc +++ b/sales/includes/ui/sales_order_ui.inc @@ -4,25 +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) { - $already_on_order = 0; - foreach ($order->line_items AS $order_item) + foreach ($order->line_items AS $order_item) { - if (strcasecmp($order_item->stock_id, $new_item) == 0) - { - $already_on_order = 1; - display_error(_("For Part :") . $new_item . " " . "This item is already on this order. You can change the quantity ordered of the existing line if necessary."); - } + 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 ($already_on_order != 1) - { - $order->add_to_cart ($new_item, $new_item_qty, $price, $discount); - } /* end of if not already on the order */ + $order->add_to_cart (count($order->line_items),$new_item, $new_item_qty, $price, $discount); } //--------------------------------------------------------------------------------- @@ -30,69 +24,46 @@ 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. - # 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. + $order->set_customer($customer_id, $name, $myrow['curr_code'], $myrow['discount']); - if ($order->Branch != "") + // 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']); + +// if ($order->Branch != 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"]; + $result = get_branch_to_order($customer_id, $branch_id); + + 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->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_location($myrow["default_location"], $myrow["location_name"]); + $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); } return $ret_error; @@ -102,137 +73,199 @@ function get_customer_details_to_order(&$order, $customer_id, $branch_id) function display_order_summary($title, &$order, $editable_items=false) { - global $table_style, $path_to_root; + global $table_style, $path_to_root, $Ajax; display_heading($title); + + div_start('items_table'); start_table("$table_style colspan=7 width=90%"); $th = array(_("Item Code"), _("Item Description"), _("Quantity"), - _("Unit"), _("Price"), _("Discount %"), _("Total"), "", ""); - table_header($th); + _("Delivered"), + _("Unit"), _("Price"), _("Discount %"), _("Total"), ""); + + if ($order->trans_no == 0) { + unset( $th[3] ); + } + + if (count($order->line_items)) + $th[]= ''; + + table_header($th); $total = 0; $k = 0; //row colour counter - foreach ($order->line_items as $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); + $line_total = round($stock_item->qty_dispatched * $stock_item->price * (1 - $stock_item->discount_percent), + user_price_dec()); - if (!isset($_GET['Edit'])) - $id = ""; - else - $id = $_GET['Edit']; - if (!$editable_items || $id != $stock_item->stock_id) + + 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=$stock_item->stock_id"); - delete_link_cell(SID . "Delete=$stock_item->stock_id"); - } - 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, $stock_item->stock_id); + 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->direct_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; + 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'); + // 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($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 "
"; @@ -240,95 +273,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, $stock_id=null) +function sales_order_item_controls(&$order, &$rowcounter, $line_no=-1) { - start_row(); - - if (isset($_GET['Edit']) && $stock_id != null) - { - 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; + global $Ajax; - $_POST['units'] = $order->line_items[$_GET['Edit']]->units; + alt_table_row_color($rowcounter); + $id = find_submit('Edit'); + if ($line_no!=-1 && $line_no == $id) + { + $_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[$stock_id]->item_description); - } - else + label_cell($order->line_items[$line_no]->item_description, "nowrap"); + $Ajax->activate('items_table'); + } + 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); + + 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'); - label_cell($_POST['units']); - amount_cells(null, 'price'); - text_cells(null, 'Disc', $_POST['Disc'], 7, 5); + small_amount_cells(null, 'Disc', percent_format($_POST['Disc']), null, null, user_percent_dec()); - $line_total = $_POST['qty'] * $_POST['price'] * (1 - $_POST['Disc'] / 100); - amount_cell($line_total); + $line_total = input_num('qty') * input_num('price') * (1 - input_num('Disc') / 100); - if (isset($_GET['Edit'])) + amount_cell($line_total, false, '','line_total'); + + if ($id!=-1) { - submit_cells('UpdateItem', _("Update")); - submit_cells('CancelItemChanges', _("Cancel")); - } - else + edit_button_cell('UpdateItem', _("Update"), + _('Confirm changes')); + edit_button_cell('CancelItemChanges', _("Cancel"), + _('Cancel changes')); + hidden('LineNo', $line_no); + 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(); @@ -339,48 +404,60 @@ function sales_order_item_controls(&$order, $stock_id=null) function display_delivery_details(&$order) { global $table_style2; - - if ($order->direct_invoice) + if ($order->trans_type==10) + { + $title = _("Delivery Details"); + $delname = _("Due Date").':'; + } + elseif ($order->trans_type==13) { $title = _("Invoice Delivery Details"); - } - else + $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 "
"; + start_table("$table_style2 width=90%"); + echo ""; // outer table + + echo ""; - echo "
"; - locations_list_row(_("Deliver from Location:"), 'Location', $order->Location); + locations_list_row(_("Deliver from Location:"), 'Location', $order->Location); - date_row(_("Required Delivery Date:"), 'delivery_date', $order->delivery_date, 0, 0, 0); + date_row($delname, 'delivery_date', + _('Enter requested day of delivery'), $order->due_date, 0, 0, 0); - text_row(_("Deliver To:"), 'deliver_to', $order->deliver_to, 40, 40); + 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); - text_row(_("Contact Phone Number:"), 'phone', $order->phone, 25, 25); + 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 "
"; - echo ""; + echo ""; // outer table - echo ""; // outer table + echo ""; - echo "
"; + 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); - text_row(_("Customer Reference:"), 'cust_ref', $order->cust_ref, 25, 25); - textarea_row(_("Comments:"), "Comments", $order->Comments, 31, 5); + small_amount_row(_("Shipping Charge:"), 'freight_cost', + price_format(get_post('freight_cost',0))); - text_row(_("Shipping Charge:"), 'freight_cost', $order->freight_cost, 10, 10); + shippers_list_row(_("Shipping Company:"), 'ship_via', $order->ship_via); - shippers_list_row(_("Shipping Company:"), 'ship_via', $order->ship_via); - if ($_SESSION['Items']->direct_invoice) - textarea_row(_("Memo"), 'InvoiceText', null, 31, 3); - echo "
"; + echo ""; - echo ""; - end_table(1); // outer table + echo ""; + end_table(1); // outer table } ?> \ No newline at end of file