X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=inventory%2Fpurchasing_data.php;h=8a1b4c0f2cef176859066345ddaa965f5a141791;hb=236c7f536aac0064585c371d37cf527f6984f3ce;hp=80a71d1441a012053547d1e0a74c366eb2c76481;hpb=6183e9450dcd7e4c747889c10903f6ff1b0add33;p=fa-stable.git diff --git a/inventory/purchasing_data.php b/inventory/purchasing_data.php index 80a71d14..8a1b4c0f 100644 --- a/inventory/purchasing_data.php +++ b/inventory/purchasing_data.php @@ -18,7 +18,7 @@ check_db_has_suppliers(_("There are no suppliers defined in the system.")); if (isset($_GET['supplier_id'])) { $supplier_id = strtoupper($_GET['supplier_id']); -} +} elseif (isset($_POST['supplier_id'])) { $supplier_id = strtoupper($_POST['supplier_id']); @@ -61,7 +61,7 @@ if ((isset($_POST['AddRecord']) || isset($_POST['UpdateRecord'])) && isset($supp $sql = "INSERT INTO ".TB_PREF."purch_data (supplier_id, stock_id, price, suppliers_uom, conversion_factor, supplier_description) VALUES ("; - $sql .= "'$supplier_id', '" . $_POST['stock_id'] . "', " . + $sql .= "'$supplier_id', '" . $_POST['stock_id'] . "', " . input_num('price') . ", '" . $_POST['suppliers_uom'] . "', " . input_num('conversion_factor') . ", '" . $_POST['supplier_description'] . "')"; @@ -106,7 +106,8 @@ if (isset($_GET['Delete'])) display_note(_("The purchasing data item has been sucessfully deleted.")); unset ($supplier_id); } - +if (isset($_POST['_stock_id_update'])) + $Ajax->activate('price_table'); //-------------------------------------------------------------------------------------------------- start_form(false, true); @@ -117,18 +118,18 @@ if (!isset($_POST['stock_id'])) echo "
" . _("Item:"). " "; stock_purchasable_items_list('stock_id', $_POST['stock_id'], false, true); -echo "
"; +echo "
"; set_global_stock_item($_POST['stock_id']); $mb_flag = get_mb_flag($_POST['stock_id']); -if ($mb_flag == -1) +if ($mb_flag == -1) { display_error(_("Entered item is not defined. Please re-enter.")); set_focus('stock_id'); -} -else +} +else { $sql = "SELECT ".TB_PREF."purch_data.*,".TB_PREF."suppliers.supp_name,".TB_PREF."suppliers.curr_code @@ -137,12 +138,12 @@ else WHERE stock_id = '" . $_POST['stock_id'] . "'"; $result = db_query($sql, "The supplier purchasing details for the selected part could not be retrieved"); - + div_start('price_table'); if (db_num_rows($result) == 0) { display_note(_("There is no purchasing data set up for the part selected")); - } - else + } + else { start_table("$table_style width=60%"); @@ -176,6 +177,7 @@ else end_table(); } + div_end(); } //------------------------------------------------------------------------------------------------ @@ -202,16 +204,16 @@ if (isset($_GET['Edit'])) echo "
"; start_table($table_style2); -if (isset($_GET['Edit'])) +if (isset($_GET['Edit'])) { hidden('supplier_id', $supplier_id); label_row(_("Supplier:"), $supp_name); -} +} else { supplier_list_row(_("Supplier:"), 'supplier_id', null, false, true); $supplier_id = $_POST['supplier_id']; -} +} amount_row(_("Price:"), 'price', null,'', get_supplier_currency($supplier_id)); text_row(_("Suppliers Unit of Measure:"), 'suppliers_uom', null, 50, 51); @@ -219,7 +221,7 @@ if (!isset($_POST['conversion_factor']) || $_POST['conversion_factor'] == "") { $_POST['conversion_factor'] = exrate_format(1); } -amount_row(_("Conversion Factor (to our UOM):"), 'conversion_factor', +amount_row(_("Conversion Factor (to our UOM):"), 'conversion_factor', exrate_format($_POST['conversion_factor']), null, null, user_exrate_dec() ); text_row(_("Supplier's Code or Description:"), 'supplier_description', null, 50, 51); @@ -228,8 +230,8 @@ end_table(1); if (isset($_GET['Edit'])) { submit_center('UpdateRecord', _("Update Purchasing Data")); -} -else +} +else { submit_center('AddRecord', _("Add Purchasing Data")); }