inventory/purchasing_data.php

   1 <?php
   2 /**********************************************************************
   3     Copyright (C) FrontAccounting, LLC.
   4         Released under the terms of the GNU Affero General Public License,
   5         AGPL, as published by the Free Software Foundation, either version
   6         3 of the License, or (at your option) any later version.
   7     This program is distributed in the hope that it will be useful,
   8     but WITHOUT ANY WARRANTY; without even the implied warranty of
   9     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
  10     See the License here <http://www.gnu.org/licenses/agpl-3.0.html>.
  11 ***********************************************************************/
  12 $page_security = 4;
  13 $path_to_root="..";
  14 include_once($path_to_root . "/includes/session.inc");
  15
  16 page(_("Supplier Purchasing Data"));
  17
  18 include_once($path_to_root . "/includes/date_functions.inc");
  19 include_once($path_to_root . "/includes/ui.inc");
  20 include_once($path_to_root . "/includes/manufacturing.inc");
  21 include_once($path_to_root . "/includes/data_checks.inc");
  22
  23 check_db_has_purchasable_items(_("There are no purchasable inventory items defined in the system."));
  24 check_db_has_suppliers(_("There are no suppliers defined in the system."));
  25
  26 //----------------------------------------------------------------------------------------
  27 if ($ret = context_restore()) {
  28         if(isset($ret['supplier_id']))
  29                 $_POST['supplier_id'] = $ret['supplier_id'];
  30 }
  31 if (isset($_POST['_supplier_id_editor'])) {
  32         context_call($path_to_root.'/purchasing/manage/suppliers.php?supplier_id='.$_POST['supplier_id'],
  33                 array( 'supplier_id', 'stock_id','_stock_id_edit', 'price',
  34                         'suppliers_uom', 'supplier_description','conversion_factor'));
  35 }
  36 simple_page_mode(true);
  37 //--------------------------------------------------------------------------------------------------
  38
  39 if ($Mode=='ADD_ITEM' || $Mode=='UPDATE_ITEM')
  40 {
  41
  42         $input_error = 0;
  43         if ($_POST['stock_id'] == "" || !isset($_POST['stock_id']))
  44         {
  45         $input_error = 1;
  46         display_error( _("There is no item selected."));
  47         set_focus('stock_id');
  48         }
  49         elseif (!check_num('price', 0))
  50         {
  51         $input_error = 1;
  52         display_error( _("The price entered was not numeric."));
  53         set_focus('price');
  54         }
  55         elseif (!check_num('conversion_factor'))
  56         {
  57         $input_error = 1;
  58         display_error( _("The conversion factor entered was not numeric. The conversion factor is the number by which the price must be divided by to get the unit price in our unit of measure."));
  59                 set_focus('conversion_factor');
  60         }
  61
  62         if ($input_error == 0)
  63         {
  64         if ($Mode == 'ADD_ITEM')
  65         {
  66
  67                 $sql = "INSERT INTO ".TB_PREF."purch_data (supplier_id, stock_id, price, suppliers_uom,
  68                         conversion_factor, supplier_description) VALUES (";
  69                 $sql .= "'".$_POST['supplier_id']."', '" . $_POST['stock_id'] . "', " .
  70                     input_num('price') . ", '" . $_POST['suppliers_uom'] . "', " .
  71                         input_num('conversion_factor') . ", '" . $_POST['supplier_description'] . "')";
  72
  73                 db_query($sql,"The supplier purchasing details could not be added");
  74                 display_notification(_("This supplier purchasing data has been added."));
  75         } else
  76         {
  77                 $sql = "UPDATE ".TB_PREF."purch_data SET price=" . input_num('price') . ",
  78                                 suppliers_uom='" . $_POST['suppliers_uom'] . "',
  79                                 conversion_factor=" . input_num('conversion_factor') . ",
  80                                 supplier_description='" . $_POST['supplier_description'] . "'
  81                                 WHERE stock_id='" . $_POST['stock_id'] . "' AND
  82                                 supplier_id='$selected_id'";
  83                 db_query($sql,"The supplier purchasing details could not be updated");
  84
  85                 display_notification(_("Supplier purchasing data has been updated."));
  86         }
  87                 $Mode = 'RESET';
  88         }
  89 }
  90
  91 //--------------------------------------------------------------------------------------------------
  92
  93 if ($Mode == 'Delete')
  94 {
  95
  96         $sql = "DELETE FROM ".TB_PREF."purch_data WHERE supplier_id='$selected_id'
  97                 AND stock_id='" . $_POST['stock_id'] . "'";
  98         db_query($sql,"could not delete purchasing data");
  99
 100         display_notification(_("The purchasing data item has been sucessfully deleted."));
 101         $Mode = 'RESET';
 102 }
 103
 104 if ($Mode == 'RESET')
 105 {
 106         $selected_id = -1;
 107 }
 108
 109 if (isset($_POST['_selected_id_update']) )
 110 {
 111         $selected_id = $_POST['selected_id'];
 112         $Ajax->activate('_page_body');
 113 }
 114
 115 if (list_updated('stock_id'))
 116         $Ajax->activate('price_table');
 117 //--------------------------------------------------------------------------------------------------
 118
 119 start_form(false, true);
 120
 121 if (!isset($_POST['stock_id']))
 122         $_POST['stock_id'] = get_global_stock_item();
 123
 124 echo "<center>" . _("Item:"). "&nbsp;";
 125 stock_purchasable_items_list('stock_id', $_POST['stock_id'], false, true);
 126
 127 echo "<hr></center>";
 128
 129 set_global_stock_item($_POST['stock_id']);
 130
 131 $mb_flag = get_mb_flag($_POST['stock_id']);
 132
 133 if ($mb_flag == -1)
 134 {
 135         display_error(_("Entered item is not defined. Please re-enter."));
 136         set_focus('stock_id');
 137 }
 138 else
 139 {
 140
 141     $sql = "SELECT ".TB_PREF."purch_data.*,".TB_PREF."suppliers.supp_name,".TB_PREF."suppliers.curr_code
 142                 FROM ".TB_PREF."purch_data INNER JOIN ".TB_PREF."suppliers
 143                 ON ".TB_PREF."purch_data.supplier_id=".TB_PREF."suppliers.supplier_id
 144                 WHERE stock_id = '" . $_POST['stock_id'] . "'";
 145
 146     $result = db_query($sql, "The supplier purchasing details for the selected part could not be retrieved");
 147   div_start('price_table');
 148     if (db_num_rows($result) == 0)
 149     {
 150         display_note(_("There is no purchasing data set up for the part selected"));
 151     }
 152     else
 153     {
 154         start_table("$table_style width=60%");
 155
 156                 $th = array(_("Supplier"), _("Price"), _("Currency"),
 157                         _("Supplier's Unit"), _("Supplier's Description"), "", "");
 158
 159         table_header($th);
 160
 161         $k = $j = 0; //row colour counter
 162
 163         while ($myrow = db_fetch($result))
 164         {
 165                         alt_table_row_color($k);
 166
 167             label_cell($myrow["supp_name"]);
 168             amount_cell($myrow["price"]);
 169             label_cell($myrow["curr_code"]);
 170             label_cell($myrow["suppliers_uom"]);
 171             label_cell($myrow["supplier_description"]);
 172                         edit_button_cell("Edit".$myrow['supplier_id'], _("Edit"));
 173                         delete_button_cell("Delete".$myrow['supplier_id'], _("Delete"));
 174             end_row();
 175
 176             $j++;
 177             If ($j == 12)
 178             {
 179                 $j = 1;
 180                         table_header($th);
 181             } //end of page full new headings
 182         } //end of while loop
 183
 184         end_table();
 185     }
 186  div_end();
 187 }
 188
 189 //-----------------------------------------------------------------------------------------------
 190
 191 if ($Mode =='Edit')
 192 {
 193
 194         $sql = "SELECT ".TB_PREF."purch_data.*,".TB_PREF."suppliers.supp_name FROM ".TB_PREF."purch_data
 195                 INNER JOIN ".TB_PREF."suppliers ON ".TB_PREF."purch_data.supplier_id=".TB_PREF."suppliers.supplier_id
 196                 WHERE ".TB_PREF."purch_data.supplier_id='$selected_id'
 197                 AND ".TB_PREF."purch_data.stock_id='" . $_POST['stock_id'] . "'";
 198
 199         $result = db_query($sql, "The supplier purchasing details for the selected supplier and item could not be retrieved");
 200
 201         $myrow = db_fetch($result);
 202
 203     $supp_name = $myrow["supp_name"];
 204     $_POST['price'] = price_format($myrow["price"]);
 205     $_POST['suppliers_uom'] = $myrow["suppliers_uom"];
 206     $_POST['supplier_description'] = $myrow["supplier_description"];
 207     $_POST['conversion_factor'] = exrate_format($myrow["conversion_factor"]);
 208 }
 209
 210 echo "<br>";
 211 hidden('selected_id', $selected_id);
 212 start_table($table_style2);
 213
 214 if ($Mode == 'Edit')
 215 {
 216         hidden('supplier_id');
 217         label_row(_("Supplier:"), $supp_name);
 218 }
 219 else
 220 {
 221         supplier_list_row(_("Supplier:"), 'supplier_id', null, false, true);
 222 }
 223 amount_row(_("Price:"), 'price', null,'', get_supplier_currency($selected_id));
 224 text_row(_("Suppliers Unit of Measure:"), 'suppliers_uom', null, 50, 51);
 225
 226 if (!isset($_POST['conversion_factor']) || $_POST['conversion_factor'] == "")
 227 {
 228         $_POST['conversion_factor'] = exrate_format(1);
 229 }
 230 amount_row(_("Conversion Factor (to our UOM):"), 'conversion_factor',
 231   exrate_format($_POST['conversion_factor']), null, null, user_exrate_dec() );
 232 text_row(_("Supplier's Code or Description:"), 'supplier_description', null, 50, 51);
 233
 234 end_table(1);
 235
 236 submit_add_or_update_center($selected_id == -1, '', true);
 237
 238 end_form();
 239 end_page();
 240
 241 ?>