5 include_once($path_to_root . "/includes/session.inc");
7 page(_("Inventory Item Sales prices"));
9 include_once($path_to_root . "/includes/ui.inc");
10 include_once($path_to_root . "/includes/data_checks.inc");
12 include_once($path_to_root . "/inventory/includes/inventory_db.inc");
14 //---------------------------------------------------------------------------------------------------
16 check_db_has_stock_items(_("There are no items defined in the system."));
18 check_db_has_sales_types(_("There are no sales types in the system. Please set up sales types befor entering pricing."));
20 //---------------------------------------------------------------------------------------------------
24 if (isset($_GET['stock_id']))
26 $_POST['stock_id'] = $_GET['stock_id'];
28 if (isset($_GET['Item']))
30 $_POST['stock_id'] = $_GET['Item'];
33 if (!isset($_POST['curr_abrev']))
35 $_POST['curr_abrev'] = get_company_currency();
38 //---------------------------------------------------------------------------------------------------
40 start_form(false, true);
42 if (!isset($_POST['stock_id']))
43 $_POST['stock_id'] = get_global_stock_item();
45 echo "<center>" . _("Item:"). " ";
46 stock_items_list('stock_id', $_POST['stock_id'], false, true);
49 // if stock sel has changed, clear the form
50 if ($_POST['stock_id'] != get_global_stock_item())
55 set_global_stock_item($_POST['stock_id']);
57 //----------------------------------------------------------------------------------------------------
61 unset($_POST['PriceID']);
62 unset($_POST['price']);
65 //----------------------------------------------------------------------------------------------------
67 if (isset($_POST['updatePrice']))
70 if (!is_numeric($_POST['price']) || $_POST['price'] == "")
73 display_error( _("The price entered must be numeric."));
76 if ($input_error != 1)
79 if (isset($_POST['PriceID']))
81 //editing an existing price
82 update_item_price($_POST['PriceID'], $_POST['sales_type_id'], $_POST['curr_abrev'], $_POST['price']);
84 $msg = _("This price has been updated.");
86 elseif ($input_error !=1)
89 add_item_price($_POST['stock_id'], $_POST['sales_type_id'], $_POST['curr_abrev'], $_POST['price']);
91 display_note(_("The new price has been added."));
98 //------------------------------------------------------------------------------------------------------
100 if (isset($_GET['delete']))
103 //the link to delete a selected record was clicked
104 delete_item_price($_GET['PriceID']);
105 echo _("The selected price has been deleted.");
109 //---------------------------------------------------------------------------------------------------
111 $mb_flag = get_mb_flag($_POST['stock_id']);
113 $prices_list = get_prices($_POST['stock_id']);
115 start_table("$table_style width=30%");
117 $th = array(_("Currency"), _("Sales Type"), _("Price"), "", "");
119 $k = 0; //row colour counter
121 while ($myrow = db_fetch($prices_list))
124 alt_table_row_color($k);
126 label_cell($myrow["curr_abrev"]);
127 label_cell($myrow["sales_type"]);
128 amount_cell($myrow["price"]);
129 edit_link_cell("PriceID=" . $myrow["id"]. "&Edit=1");
130 delete_link_cell("PriceID=" . $myrow["id"]. "&delete=yes");
136 //------------------------------------------------------------------------------------------------
138 if (db_num_rows($prices_list) == 0)
140 display_note(_("There are no prices set up for this part."));
145 if (isset($_GET['Edit']))
147 $myrow = get_stock_price($_GET['PriceID']);
148 hidden('PriceID', $_GET['PriceID']);
149 $_POST['curr_abrev'] = $myrow["curr_abrev"];
150 $_POST['sales_type_id'] = $myrow["sales_type_id"];
151 $_POST['price'] = $myrow["price"];
154 start_table($table_style2);
156 currencies_list_row(_("Currency:"), 'curr_abrev', null);
158 sales_types_list_row(_("Sales Type:"), 'sales_type_id', null);
160 text_row(_("Price:"), 'price', null, 10, 10);
164 submit_center('updatePrice', _("Add/Update Price"));