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 (!check_num('price', 0))
73 display_error( _("The price entered must be numeric."));
77 if ($input_error != 1)
80 if (isset($_POST['PriceID']))
82 //editing an existing price
83 update_item_price($_POST['PriceID'], $_POST['sales_type_id'],
84 $_POST['curr_abrev'], input_num('price'));
86 $msg = _("This price has been updated.");
88 elseif ($input_error !=1)
91 add_item_price($_POST['stock_id'], $_POST['sales_type_id'],
92 $_POST['curr_abrev'], input_num('price'));
94 display_note(_("The new price has been added."));
101 //------------------------------------------------------------------------------------------------------
103 if (isset($_GET['delete']))
106 //the link to delete a selected record was clicked
107 delete_item_price($_GET['PriceID']);
108 echo _("The selected price has been deleted.");
111 if (isset($_POST['_stock_id_update']))
112 $Ajax->activate('price_table');
113 //---------------------------------------------------------------------------------------------------
115 $mb_flag = get_mb_flag($_POST['stock_id']);
117 $prices_list = get_prices($_POST['stock_id']);
119 div_start('price_table');
120 start_table("$table_style width=30%");
122 $th = array(_("Currency"), _("Sales Type"), _("Price"), "", "");
124 $k = 0; //row colour counter
126 while ($myrow = db_fetch($prices_list))
129 alt_table_row_color($k);
131 label_cell($myrow["curr_abrev"]);
132 label_cell($myrow["sales_type"]);
133 amount_cell($myrow["price"]);
134 edit_link_cell("PriceID=" . $myrow["id"]. "&Edit=1");
135 delete_link_cell("PriceID=" . $myrow["id"]. "&delete=yes");
141 //------------------------------------------------------------------------------------------------
143 if (db_num_rows($prices_list) == 0)
145 display_note(_("There are no prices set up for this part."));
150 if (isset($_GET['Edit']))
152 $myrow = get_stock_price($_GET['PriceID']);
153 hidden('PriceID', $_GET['PriceID']);
154 $_POST['curr_abrev'] = $myrow["curr_abrev"];
155 $_POST['sales_type_id'] = $myrow["sales_type_id"];
156 $_POST['price'] = price_format($myrow["price"]);
159 start_table($table_style2);
161 currencies_list_row(_("Currency:"), 'curr_abrev', null);
163 sales_types_list_row(_("Sales Type:"), 'sales_type_id', null);
165 small_amount_row(_("Price:"), 'price', null);
169 submit_center('updatePrice', _("Add/Update Price"));