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>";
  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         }
  75
  76         if ($input_error != 1)
  77         {
  78
  79                 if (isset($_POST['PriceID']))
  80                 {
  81                         //editing an existing price
  82                         update_item_price($_POST['PriceID'], $_POST['sales_type_id'],
  83                         $_POST['curr_abrev'], input_num('price'));
  84
  85                         $msg = _("This price has been updated.");
  86                 }
  87                 elseif ($input_error !=1)
  88                 {
  89
  90                         add_item_price($_POST['stock_id'], $_POST['sales_type_id'],
  91                             $_POST['curr_abrev'], input_num('price'));
  92
  93                         display_note(_("The new price has been added."));
  94                 }
  95                 clear_data();
  96         }
  97
  98 }
  99
 100 //------------------------------------------------------------------------------------------------------
 101
 102 if (isset($_GET['delete']))
 103 {
 104
 105         //the link to delete a selected record was clicked
 106         delete_item_price($_GET['PriceID']);
 107         echo _("The selected price has been deleted.");
 108
 109 }
 110
 111 //---------------------------------------------------------------------------------------------------
 112
 113 $mb_flag = get_mb_flag($_POST['stock_id']);
 114
 115 $prices_list = get_prices($_POST['stock_id']);
 116
 117 start_table("$table_style width=30%");
 118
 119 $th = array(_("Currency"), _("Sales Type"), _("Price"), "", "");
 120 table_header($th);
 121 $k = 0; //row colour counter
 122
 123 while ($myrow = db_fetch($prices_list))
 124 {
 125
 126         alt_table_row_color($k);
 127
 128         label_cell($myrow["curr_abrev"]);
 129     label_cell($myrow["sales_type"]);
 130     amount_cell($myrow["price"]);
 131     edit_link_cell("PriceID=" . $myrow["id"]. "&Edit=1");
 132     delete_link_cell("PriceID=" . $myrow["id"]. "&delete=yes");
 133     end_row();
 134
 135 }
 136 end_table();
 137
 138 //------------------------------------------------------------------------------------------------
 139
 140 if (db_num_rows($prices_list) == 0)
 141 {
 142         display_note(_("There are no prices set up for this part."));
 143 }
 144
 145 echo "<br>";
 146
 147 if (isset($_GET['Edit']))
 148 {
 149         $myrow = get_stock_price($_GET['PriceID']);
 150         hidden('PriceID', $_GET['PriceID']);
 151         $_POST['curr_abrev'] = $myrow["curr_abrev"];
 152         $_POST['sales_type_id'] = $myrow["sales_type_id"];
 153         $_POST['price'] = price_format($myrow["price"]);
 154 }
 155
 156 start_table($table_style2);
 157
 158 currencies_list_row(_("Currency:"), 'curr_abrev', null);
 159
 160 sales_types_list_row(_("Sales Type:"), 'sales_type_id', null);
 161
 162 small_amount_row(_("Price:"), 'price', null);
 163
 164 end_table(1);
 165
 166 submit_center('updatePrice', _("Add/Update Price"));
 167
 168
 169 end_form();
 170 end_page();
 171 ?>