From f338f2d7ea4c0de20a53b83be6442d792735e5e1 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Fri, 20 Mar 2009 10:54:16 +0000 Subject: [PATCH] Truncation bug when inserting/updating entered supplier credit limit --- CHANGELOG.txt | 4 ++++ purchasing/manage/suppliers.php | 6 +++--- 2 files changed, 7 insertions(+), 3 deletions(-) diff --git a/CHANGELOG.txt b/CHANGELOG.txt index eac9084d..44ae9123 100644 --- a/CHANGELOG.txt +++ b/CHANGELOG.txt @@ -19,6 +19,10 @@ Legend: ! -> Note $ -> Affected files +20-Mar-2009 Joe Hunt +# Truncation bug when inserting/updating entered supplier credit limit +$ /purchasing/manage/suppliers.php + 19-Mar-2009 Joe Hunt # [0000120] SQL Error when leaving Default Rate: blank when adding Tax Types $ /taxes/tax_types.php diff --git a/purchasing/manage/suppliers.php b/purchasing/manage/suppliers.php index 8fc3d870..bc654a37 100644 --- a/purchasing/manage/suppliers.php +++ b/purchasing/manage/suppliers.php @@ -62,7 +62,7 @@ if (isset($_POST['submit'])) contact=".db_escape($_POST['contact']) . ", supp_account_no=".db_escape($_POST['supp_account_no']) . ", bank_account=".db_escape($_POST['bank_account']) . ", - credit_limit=".db_escape($_POST['credit_limit']) . ", + credit_limit=".input_num('credit_limit', 0) . ", dimension_id=".db_escape($_POST['dimension_id']) . ", dimension2_id=".db_escape($_POST['dimension2_id']) . ", curr_code=".db_escape($_POST['curr_code']).", @@ -196,7 +196,7 @@ if (!$new_supplier) $_POST['dimension2_id'] = $myrow["dimension2_id"]; $_POST['curr_code'] = $myrow["curr_code"]; $_POST['payment_terms'] = $myrow["payment_terms"]; - $_POST['credit_limit'] = $myrow["credit_limit"]; + $_POST['credit_limit'] = price_format($myrow["credit_limit"]); $_POST['tax_group_id'] = $myrow["tax_group_id"]; $_POST['payable_account'] = $myrow["payable_account"]; $_POST['purchase_account'] = $myrow["purchase_account"]; @@ -213,7 +213,7 @@ else $_POST['sales_type'] = -1; $_POST['email'] = $_POST['phone'] = $_POST['fax'] = $_POST['gst_no'] = $_POST['contact'] = $_POST['bank_account'] = ''; $_POST['payment_terms'] = ''; - $_POST['credit_limit'] = ""; + $_POST['credit_limit'] = price_format(0); $company_record = get_company_prefs(); $_POST['curr_code'] = $company_record["curr_default"]; -- 2.30.2