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