X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=inventory%2Fmanage%2Fitems.php;h=0fadbe52b4d6d9be11ecd391613db456724e3355;hb=d2cc0860eccf02eaefcd90731ac3af141a841529;hp=24335defcbf4cf9f78e8270bb90488d81a77366a;hpb=5cae8206ae7eaf4df4b95b7f2184e2332f85ec8d;p=fa-stable.git diff --git a/inventory/manage/items.php b/inventory/manage/items.php index 24335def..0fadbe52 100644 --- a/inventory/manage/items.php +++ b/inventory/manage/items.php @@ -1,10 +1,19 @@ . +***********************************************************************/ +$page_security = 'SA_ITEM'; +$path_to_root = "../.."; include($path_to_root . "/includes/session.inc"); -page(_("Items")); +page(_($help_context = "Items"), @$_REQUEST['popup']); include_once($path_to_root . "/includes/date_functions.inc"); include_once($path_to_root . "/includes/ui.inc"); @@ -13,33 +22,38 @@ include_once($path_to_root . "/includes/data_checks.inc"); include_once($path_to_root . "/inventory/includes/inventory_db.inc"); $user_comp = user_company(); -$new_item = (!isset($_POST['stock_id']) || $_POST['stock_id'] == ""); +$new_item = get_post('stock_id')=='' || get_post('cancel') || get_post('clone'); //------------------------------------------------------------------------------------ if (isset($_GET['stock_id'])) { - $stock_id = strtoupper($_GET['stock_id']); + $_POST['stock_id'] = $stock_id = $_GET['stock_id']; } -else if (isset($_POST['stock_id'])) +elseif (isset($_POST['stock_id'])) { - $stock_id = strtoupper($_POST['stock_id']); + $stock_id = $_POST['stock_id']; } - -if(get_post('_stock_id_update')) { - $_POST['NewStockID'] = $_POST['stock_id']; - if ($new_item) { - clear_data(); - set_focus('NewStockID'); - } else { - set_focus('description'); - } +if (list_updated('stock_id')) { + $_POST['NewStockID'] = get_post('stock_id'); + clear_data(); $Ajax->activate('details'); $Ajax->activate('controls'); -// unset($_POST['New']); +} + +if (get_post('cancel')) { + $_POST['NewStockID'] = $_POST['stock_id'] = ''; + clear_data(); + set_focus('stock_id'); + $Ajax->activate('_page_body'); +} + +if (list_updated('category_id') || list_updated('mb_flag')) { + $Ajax->activate('details'); } $upload_file = ""; if (isset($_FILES['pic']) && $_FILES['pic']['name'] != '') { + $stock_id = $_POST['NewStockID']; $result = $_FILES['pic']['error']; $upload_file = 'Yes'; //Assume all is well to start off with $filename = $comp_path . "/$user_comp/images"; @@ -47,27 +61,26 @@ if (isset($_FILES['pic']) && $_FILES['pic']['name'] != '') { mkdir($filename); } - $filename .= "/$stock_id.jpg"; + $filename .= "/".item_img_name($stock_id).".jpg"; //But check for the worst if (strtoupper(substr(trim($_FILES['pic']['name']), strlen($_FILES['pic']['name']) - 3)) != 'JPG') { - display_notification(_('Only jpg files are supported - a file extension of .jpg is expected')); + display_warning(_('Only jpg files are supported - a file extension of .jpg is expected')); $upload_file ='No'; } elseif ( $_FILES['pic']['size'] > ($max_image_size * 1024)) { //File Size Check - display_notification(_('The file size is over the maximum allowed. The maximum size allowed in KB is') . ' ' . $max_image_size); + display_warning(_('The file size is over the maximum allowed. The maximum size allowed in KB is') . ' ' . $max_image_size); $upload_file ='No'; } elseif ( $_FILES['pic']['type'] == "text/plain" ) { //File type Check - display_notification( _('Only graphics files can be uploaded')); + display_warning( _('Only graphics files can be uploaded')); $upload_file ='No'; } elseif (file_exists($filename)) { - display_notification(_('Attempting to overwrite an existing item image')); $result = unlink($filename); if (!$result) { @@ -79,20 +92,17 @@ if (isset($_FILES['pic']) && $_FILES['pic']['name'] != '') if ($upload_file == 'Yes') { $result = move_uploaded_file($_FILES['pic']['tmp_name'], $filename); - $message = ($result)?_('File url') ."$filename" : "Somthing is wrong with uploading a file."; } + $Ajax->activate('details'); /* EOF Add Image upload for New Item - by Ori */ } - check_db_has_stock_categories(_("There are no item categories defined in the system. At least one item category is required to add a item.")); check_db_has_item_tax_types(_("There are no item tax types defined in the system. At least one item tax type is required to add a item.")); function clear_data() { - global $new_item; - unset($_POST['long_description']); unset($_POST['description']); unset($_POST['category_id']); @@ -102,7 +112,7 @@ function clear_data() unset($_POST['NewStockID']); unset($_POST['dimension_id']); unset($_POST['dimension2_id']); - $new_item = true; + unset($_POST['no_sale']); } //------------------------------------------------------------------------------------ @@ -134,22 +144,39 @@ if (isset($_POST['addupdate'])) set_focus('NewStockID'); } - + elseif ($new_item && db_num_rows(get_item_kit($_POST['NewStockID']))) + { + $input_error = 1; + display_error( _("This item code is already assigned to stock item or sale kit.")); + set_focus('NewStockID'); + } + if ($input_error != 1) { - + if (check_value('del_image')) + { + $filename = $comp_path . "/$user_comp/images/".item_img_name($_POST['NewStockID']).".jpg"; + if (file_exists($filename)) + unlink($filename); + } + if (!$new_item) { /*so its an existing one */ - update_item($_POST['NewStockID'], $_POST['description'], - $_POST['long_description'], $_POST['category_id'], $_POST['tax_type_id'], - $_POST['sales_account'], $_POST['inventory_account'], $_POST['cogs_account'], + $_POST['long_description'], $_POST['category_id'], + $_POST['tax_type_id'], get_post('units'), + get_post('mb_flag'), $_POST['sales_account'], + $_POST['inventory_account'], $_POST['cogs_account'], $_POST['adjustment_account'], $_POST['assembly_account'], - $_POST['dimension_id'], $_POST['dimension2_id']); - - display_notification(_("Item has been updated.")); + $_POST['dimension_id'], $_POST['dimension2_id'], + check_value('no_sale')); + update_record_status($_POST['NewStockID'], $_POST['inactive'], + 'stock_master', 'stock_id'); + update_record_status($_POST['NewStockID'], $_POST['inactive'], + 'item_codes', 'item_code'); set_focus('stock_id'); - $Ajax->activate('details'); //update image if any + $Ajax->activate('stock_id'); // in case of status change + display_notification(_("Item has been updated.")); } else { //it is a NEW part @@ -159,57 +186,78 @@ if (isset($_POST['addupdate'])) $_POST['units'], $_POST['mb_flag'], $_POST['sales_account'], $_POST['inventory_account'], $_POST['cogs_account'], $_POST['adjustment_account'], $_POST['assembly_account'], - $_POST['dimension_id'], $_POST['dimension2_id']); - - display_notification(_("A new item has been added.")); - $_POST['stock_id'] = $_POST['NewStockID']; - $new_item = false; - set_focus('stock_id'); - $Ajax->activate('_page_body'); + $_POST['dimension_id'], $_POST['dimension2_id'], + check_value('no_sale')); + + display_notification(_("A new item has been added.")); + $_POST['stock_id'] = $_POST['NewStockID'] = + $_POST['description'] = $_POST['long_description'] = ''; + $_POST['no_sale'] = 0; + set_focus('NewStockID'); } + $Ajax->activate('_page_body'); } } +if (get_post('clone')) { + unset($_POST['stock_id']); + unset($_POST['inactive']); + set_focus('NewStockID'); + $Ajax->activate('_page_body'); +} + //------------------------------------------------------------------------------------ -function can_delete($stock_id) +function check_usage($stock_id, $dispmsg=true) { - $sql= "SELECT COUNT(*) FROM ".TB_PREF."stock_moves WHERE stock_id='$stock_id'"; - $result = db_query($sql, "could not query stock moves"); - $myrow = db_fetch_row($result); - if ($myrow[0] > 0) - { - display_error(_('Cannot delete this item because there are stock movements that refer to this item.')); - return false; + $sqls= array( + "SELECT COUNT(*) FROM " + .TB_PREF."stock_moves WHERE stock_id=".db_escape($stock_id) => + _('Cannot delete this item because there are stock movements that refer to this item.'), + "SELECT COUNT(*) FROM " + .TB_PREF."bom WHERE component=".db_escape($stock_id)=> + _('Cannot delete this item record because there are bills of material that require this part as a component.'), + "SELECT COUNT(*) FROM " + .TB_PREF."sales_order_details WHERE stk_code=".db_escape($stock_id) => + _('Cannot delete this item because there are existing purchase order items for it.'), + "SELECT COUNT(*) FROM " + .TB_PREF."purch_order_details WHERE item_code=".db_escape($stock_id)=> + _('Cannot delete this item because there are existing purchase order items for it.') + ); + + $msg = ''; + + foreach($sqls as $sql=>$err) { + $result = db_query($sql, "could not query stock usage"); + $myrow = db_fetch_row($result); + if ($myrow[0] > 0) + { + $msg = $err; break; + } } - $sql= "SELECT COUNT(*) FROM ".TB_PREF."bom WHERE component='$stock_id'"; - $result = db_query($sql, "could not query boms"); - $myrow = db_fetch_row($result); - if ($myrow[0] > 0) - { - display_error(_('Cannot delete this item record because there are bills of material that require this part as a component.')); - return false; - } + if ($msg == '') { - $sql= "SELECT COUNT(*) FROM ".TB_PREF."sales_order_details WHERE stk_code='$stock_id'"; - $result = db_query($sql, "could not query sales orders"); - $myrow = db_fetch_row($result); - if ($myrow[0] > 0) - { - display_error(_('Cannot delete this item record because there are existing sales orders for this part.')); - return false; - } + $kits = get_where_used($stock_id); + $num_kits = db_num_rows($kits); + if ($num_kits) { + $msg = _("This item cannot be deleted because some code aliases + or foreign codes was entered for it, or there are kits defined + using this item as component") + .':
'; - $sql= "SELECT COUNT(*) FROM ".TB_PREF."purch_order_details WHERE item_code='$stock_id'"; - $result = db_query($sql, "could not query purchase orders"); - $myrow = db_fetch_row($result); - if ($myrow[0] > 0) - { - display_error(_('Cannot delete this item because there are existing purchase order items for it.')); + while($num_kits--) { + $kit = db_fetch($kits); + $msg .= "'".$kit[0]."'"; + if ($num_kits) $msg .= ','; + } + + } + } + if ($msg != '') { + if($dispmsg) display_error($msg); return false; } - return true; } @@ -218,24 +266,22 @@ function can_delete($stock_id) if (isset($_POST['delete']) && strlen($_POST['delete']) > 1) { - if (can_delete($_POST['NewStockID'])) { + if (check_usage($_POST['NewStockID'])) { $stock_id = $_POST['NewStockID']; delete_item($stock_id); - $filename = $comp_path . "/$user_comp/images/$stock_id.jpg"; + $filename = $comp_path . "/$user_comp/images/".item_img_name($stock_id).".jpg"; if (file_exists($filename)) unlink($filename); display_notification(_("Selected item has been deleted.")); - $new_item = true; $_POST['stock_id'] = ''; clear_data(); set_focus('stock_id'); + $new_item = true; $Ajax->activate('_page_body'); -// meta_forward($_SERVER['PHP_SELF']); } } - -//------------------------------------------------------------------------------------ +//-------------------------------------------------------------------------------------------- start_form(true); @@ -244,52 +290,36 @@ if (db_has_stock_items()) start_table("class='tablestyle_noborder'"); start_row(); stock_items_list_cells(_("Select an item:"), 'stock_id', null, - _('New item'), true); -// submit_cells('SelectStockItem', _("Edit Item")); + _('New item'), true, check_value('show_inactive')); + $new_item = get_post('stock_id')==''; + check_cells(_("Show inactive:"), 'show_inactive', null, true); end_row(); end_table(); -} -//hyperlink_params($_SERVER['PHP_SELF'], _("Enter a new item"), "New=1"); -//echo "
"; + if (get_post('_show_inactive_update')) { + $Ajax->activate('stock_id'); + set_focus('stock_id'); + } +} div_start('details'); -start_table("$table_style2 width=40%"); +start_outer_table($table_style2, 5); + +table_section(1); table_section_title(_("Item")); //------------------------------------------------------------------------------------ - -if (!isset($_POST['NewStockID']) || $new_item) +if ($new_item) { - -/*If the page was called without $_POST['NewStockID'] passed to page then assume a new item is to be entered show a form with a part Code field other wise the form showing the fields with the existing entries against the part will show for editing with only a hidden stock_id field. New is set to flag that the page may have called itself and still be entering a new part, in which case the page needs to know not to go looking up details for an existing part*/ - text_row(_("Item Code:"), 'NewStockID', null, 21, 20); - $company_record = get_company_prefs(); - - if (!isset($_POST['inventory_account']) || $_POST['inventory_account'] == "") - $_POST['inventory_account'] = $company_record["default_inventory_act"]; - - if (!isset($_POST['cogs_account']) || $_POST['cogs_account'] == "") - $_POST['cogs_account'] = $company_record["default_cogs_act"]; - - if (!isset($_POST['sales_account']) || $_POST['sales_account'] == "") - $_POST['sales_account'] = $company_record["default_inv_sales_act"]; - - if (!isset($_POST['adjustment_account']) || $_POST['adjustment_account'] == "") - $_POST['adjustment_account'] = $company_record["default_adj_act"]; - - if (!isset($_POST['assembly_account']) || $_POST['assembly_account'] == "") - $_POST['assembly_account'] = $company_record["default_assembly_act"]; - + $_POST['inactive'] = 0; } else { // Must be modifying an existing item + $_POST['NewStockID'] = $_POST['stock_id']; - if (!$new_item) - { $myrow = get_item($_POST['NewStockID']); $_POST['long_description'] = $myrow["long_description"]; @@ -306,59 +336,74 @@ else $_POST['assembly_account'] = $myrow['assembly_account']; $_POST['dimension_id'] = $myrow['dimension_id']; $_POST['dimension2_id'] = $myrow['dimension2_id']; - + $_POST['no_sale'] = $myrow['no_sale']; + $_POST['del_image'] = 0; + $_POST['inactive'] = $myrow["inactive"]; label_row(_("Item Code:"),$_POST['NewStockID']); hidden('NewStockID', $_POST['NewStockID']); - } + set_focus('description'); } text_row(_("Name:"), 'description', null, 52, 50); -textarea_row(_('Description:'), 'long_description', null, 45, 3); +textarea_row(_('Description:'), 'long_description', null, 42, 3); -end_table(); -start_table("$table_style2 width=40%"); -// Add image upload for New Item - by Joe -start_row(); -label_cells(_("Image File (.jpg)") . ":", ""); -// Add Image upload for New Item - by Joe -if (isset($_POST['NewStockID']) && file_exists("$comp_path/$user_comp/images/".$_POST['NewStockID'].".jpg")) -{ - $stock_img_link = ""; -} -else -{ - $stock_img_link = "No Image"; -} +stock_categories_list_row(_("Category:"), 'category_id', null, $new_item); -label_cell($stock_img_link, "valign=top align=center rowspan=5"); -end_row(); +if ($new_item && (list_updated('category_id') || !isset($_POST['units']))) { -stock_categories_list_row(_("Category:"), 'category_id', null); + $category_record = get_item_category($_POST['category_id']); + + $_POST['tax_type_id'] = $category_record["dflt_tax_type"]; + $_POST['units'] = $category_record["dflt_units"]; + $_POST['mb_flag'] = $category_record["dflt_mb_flag"]; + $_POST['inventory_account'] = $category_record["dflt_inventory_act"]; + $_POST['cogs_account'] = $category_record["dflt_cogs_act"]; + $_POST['sales_account'] = $category_record["dflt_sales_act"]; + $_POST['adjustment_account'] = $category_record["dflt_adjustment_act"]; + $_POST['assembly_account'] = $category_record["dflt_assembly_act"]; + $_POST['dimension_id'] = $category_record["dflt_dim1"]; + $_POST['dimension2_id'] = $category_record["dflt_dim2"]; + $_POST['no_sale'] = $category_record["dflt_no_sale"]; +} +$fresh_item = !isset($_POST['NewStockID']) || $new_item + || check_usage($_POST['stock_id'],false); item_tax_types_list_row(_("Item Tax Type:"), 'tax_type_id', null); -stock_item_types_list_row(_("Item Type:"), 'mb_flag', null, - (!isset($_POST['NewStockID']) || $new_item)); +stock_item_types_list_row(_("Item Type:"), 'mb_flag', null, $fresh_item); + +stock_units_list_row(_('Units of Measure:'), 'units', null, $fresh_item); -stock_units_list_row(_('Units of Measure:'), 'units', null, - (!isset($_POST['NewStockID']) || $new_item)); -end_table(); -start_table("$table_style2 width=40%"); +$dim = get_company_pref('use_dimension'); +if ($dim >= 1) +{ + table_section_title(_("Dimensions")); + + dimensions_list_row(_("Dimension")." 1", 'dimension_id', null, true, " ", false, 1); + if ($dim > 1) + dimensions_list_row(_("Dimension")." 2", 'dimension2_id', null, true, " ", false, 2); +} +if ($dim < 1) + hidden('dimension_id', 0); +if ($dim < 2) + hidden('dimension2_id', 0); + +table_section(2); table_section_title(_("GL Accounts")); gl_all_accounts_list_row(_("Sales Account:"), 'sales_account', $_POST['sales_account']); -gl_all_accounts_list_row(_("Inventory Account:"), 'inventory_account', $_POST['inventory_account']); - if (!is_service($_POST['mb_flag'])) { + gl_all_accounts_list_row(_("Inventory Account:"), 'inventory_account', $_POST['inventory_account']); gl_all_accounts_list_row(_("C.O.G.S. Account:"), 'cogs_account', $_POST['cogs_account']); gl_all_accounts_list_row(_("Inventory Adjustments Account:"), 'adjustment_account', $_POST['adjustment_account']); } else { + gl_all_accounts_list_row(_("C.O.G.S. Account:"), 'inventory_account', $_POST['inventory_account']); hidden('cogs_account', $_POST['cogs_account']); hidden('adjustment_account', $_POST['adjustment_account']); } @@ -368,35 +413,55 @@ if (is_manufactured($_POST['mb_flag'])) gl_all_accounts_list_row(_("Item Assembly Costs Account:"), 'assembly_account', $_POST['assembly_account']); else hidden('assembly_account', $_POST['assembly_account']); -$dim = get_company_pref('use_dimension'); -if ($dim >= 1) -{ - table_section_title(_("Dimensions")); - dimensions_list_row(_("Dimension")." 1", 'dimension_id', null, true, " ", false, 1); - if ($dim > 1) - dimensions_list_row(_("Dimension")." 2", 'dimension2_id', null, true, " ", false, 2); +table_section_title(_("Other")); + +// Add image upload for New Item - by Joe +label_row(_("Image File (.jpg)") . ":", ""); +// Add Image upload for New Item - by Joe +$stock_img_link = ""; +$check_remove_image = false; +if (isset($_POST['NewStockID']) && file_exists("$comp_path/$user_comp/images/" + .item_img_name($_POST['NewStockID']).".jpg")) +{ + // 31/08/08 - rand() call is necessary here to avoid caching problems. Thanks to Peter D. + $stock_img_link .= "[".$_POST["; + $check_remove_image = true; +} +else +{ + $stock_img_link .= _("No image"); } -if ($dim < 1) - hidden('dimension_id', 0); -if ($dim < 2) - hidden('dimension2_id', 0); -end_table(1); +label_row(" ", $stock_img_link); +if ($check_remove_image) + check_row(_("Delete Image:"), 'del_image'); + +check_row(_("Exclude from sales:"), 'no_sale'); + +record_status_list_row(_("Item status:"), 'inactive'); +end_outer_table(1); div_end(); div_start('controls'); if (!isset($_POST['NewStockID']) || $new_item) { - submit_center('addupdate', _("Insert New Item"), true, '', true); + submit_center('addupdate', _("Insert New Item"), true, '', 'default'); } else { - submit_center_first('addupdate', _("Update Item"), '', true); - - submit_center_last('delete', _("Delete This Item"), '', true); + submit_center_first('addupdate', _("Update Item"), '', + @$_REQUEST['popup'] ? true : 'default'); + submit_return('select', get_post('stock_id'), + _("Select this items and return to document entry."), 'default'); + submit('clone', _("Clone This Item"), true, '', true); + submit('delete', _("Delete This Item"), true, '', true); + submit_center_last('cancel', _("Cancel"), _("Cancel Edition"), 'cancel'); } div_end(); +hidden('popup', @$_REQUEST['popup']); end_form(); //------------------------------------------------------------------------------------