inventory/prices.php

   1 <?php
   2
   3 $page_security = 2;
   4 $path_to_root="..";
   5 include_once($path_to_root . "/includes/session.inc");
   6
   7 page(_("Inventory Item Sales prices"));
   8
   9 include_once($path_to_root . "/includes/ui.inc");
  10 include_once($path_to_root . "/includes/data_checks.inc");
  11
  12 include_once($path_to_root . "/inventory/includes/inventory_db.inc");
  13
  14 //---------------------------------------------------------------------------------------------------
  15
  16 check_db_has_stock_items(_("There are no items defined in the system."));
  17
  18 check_db_has_sales_types(_("There are no sales types in the system. Please set up sales types befor entering pricing."));
  19
  20 //---------------------------------------------------------------------------------------------------
  21
  22 $input_error = 0;
  23
  24 if (isset($_GET['stock_id']))
  25 {
  26         $_POST['stock_id'] = $_GET['stock_id'];
  27 }
  28 if (isset($_GET['Item']))
  29 {
  30         $_POST['stock_id'] = $_GET['Item'];
  31 }
  32
  33 if (!isset($_POST['curr_abrev']))
  34 {
  35         $_POST['curr_abrev'] = get_company_currency();
  36 }
  37
  38 //---------------------------------------------------------------------------------------------------
  39
  40 start_form(false, true);
  41
  42 if (!isset($_POST['stock_id']))
  43         $_POST['stock_id'] = get_global_stock_item();
  44
  45 echo "<center>" . _("Item:"). "&nbsp;";
  46 stock_items_list('stock_id', $_POST['stock_id'], false, true);
  47 echo "<hr></center>";
  48
  49 // if stock sel has changed, clear the form
  50 if ($_POST['stock_id'] != get_global_stock_item())
  51 {
  52         clear_data();
  53 }
  54
  55 set_global_stock_item($_POST['stock_id']);
  56
  57 //----------------------------------------------------------------------------------------------------
  58
  59 function clear_data()
  60 {
  61         unset($_POST['PriceID']);
  62         unset($_POST['price']);
  63 }
  64
  65 //----------------------------------------------------------------------------------------------------
  66
  67 if (isset($_POST['updatePrice']))
  68 {
  69
  70         if (!check_num('price', 0))
  71         {
  72                 $input_error = 1;
  73                 display_error( _("The price entered must be numeric."));
  74                 set_focus('price');
  75         }
  76
  77         if ($input_error != 1)
  78         {
  79
  80                 if (isset($_POST['PriceID']))
  81                 {
  82                         //editing an existing price
  83                         update_item_price($_POST['PriceID'], $_POST['sales_type_id'],
  84                         $_POST['curr_abrev'], input_num('price'));
  85
  86                         $msg = _("This price has been updated.");
  87                 }
  88                 elseif ($input_error !=1)
  89                 {
  90
  91                         add_item_price($_POST['stock_id'], $_POST['sales_type_id'],
  92                             $_POST['curr_abrev'], input_num('price'));
  93
  94                         display_note(_("The new price has been added."));
  95                 }
  96                 clear_data();
  97         }
  98
  99 }
 100
 101 //------------------------------------------------------------------------------------------------------
 102
 103 if (isset($_GET['delete']))
 104 {
 105
 106         //the link to delete a selected record was clicked
 107         delete_item_price($_GET['PriceID']);
 108         echo _("The selected price has been deleted.");
 109
 110 }
 111
 112 //---------------------------------------------------------------------------------------------------
 113
 114 $mb_flag = get_mb_flag($_POST['stock_id']);
 115
 116 $prices_list = get_prices($_POST['stock_id']);
 117
 118 start_table("$table_style width=30%");
 119
 120 $th = array(_("Currency"), _("Sales Type"), _("Price"), "", "");
 121 table_header($th);
 122 $k = 0; //row colour counter
 123
 124 while ($myrow = db_fetch($prices_list))
 125 {
 126
 127         alt_table_row_color($k);
 128
 129         label_cell($myrow["curr_abrev"]);
 130     label_cell($myrow["sales_type"]);
 131     amount_cell($myrow["price"]);
 132     edit_link_cell("PriceID=" . $myrow["id"]. "&Edit=1");
 133     delete_link_cell("PriceID=" . $myrow["id"]. "&delete=yes");
 134     end_row();
 135
 136 }
 137 end_table();
 138
 139 //------------------------------------------------------------------------------------------------
 140
 141 if (db_num_rows($prices_list) == 0)
 142 {
 143         display_note(_("There are no prices set up for this part."));
 144 }
 145
 146 echo "<br>";
 147
 148 if (isset($_GET['Edit']))
 149 {
 150         $myrow = get_stock_price($_GET['PriceID']);
 151         hidden('PriceID', $_GET['PriceID']);
 152         $_POST['curr_abrev'] = $myrow["curr_abrev"];
 153         $_POST['sales_type_id'] = $myrow["sales_type_id"];
 154         $_POST['price'] = price_format($myrow["price"]);
 155 }
 156
 157 start_table($table_style2);
 158
 159 currencies_list_row(_("Currency:"), 'curr_abrev', null);
 160
 161 sales_types_list_row(_("Sales Type:"), 'sales_type_id', null);
 162
 163 small_amount_row(_("Price:"), 'price', null);
 164
 165 end_table(1);
 166
 167 submit_center('updatePrice', _("Add/Update Price"));
 168
 169
 170 end_form();
 171 end_page();
 172 ?>