2 /**********************************************************************
3 Copyright (C) FrontAccounting, LLC.
4 Released under the terms of the GNU General Public License, GPL,
5 as published by the Free Software Foundation, either version 3
6 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/gpl-3.0.html>.
11 ***********************************************************************/
12 $page_security = 'SA_ITEMCATEGORY';
13 $path_to_root = "../..";
14 include($path_to_root . "/includes/session.inc");
16 page(_($help_context = "Item Categories"));
18 include_once($path_to_root . "/includes/ui.inc");
20 include_once($path_to_root . "/inventory/includes/inventory_db.inc");
22 simple_page_mode(true);
23 //----------------------------------------------------------------------------------
25 if ($Mode=='ADD_ITEM' || $Mode=='UPDATE_ITEM')
28 //initialise no input errors assumed initially before we test
31 if (strlen($_POST['description']) == 0)
34 display_error(_("The item category description cannot be empty."));
35 set_focus('description');
40 if ($selected_id != -1)
42 update_item_category($selected_id, $_POST['description'],
43 $_POST['tax_type_id'], $_POST['sales_account'],
44 $_POST['cogs_account'], $_POST['inventory_account'],
45 $_POST['adjustment_account'], $_POST['assembly_account'],
46 $_POST['units'], $_POST['mb_flag'], $_POST['dim1'], $_POST['dim2'],
47 check_value('no_sale'));
48 display_notification(_('Selected item category has been updated'));
52 add_item_category($_POST['description'],
53 $_POST['tax_type_id'], $_POST['sales_account'],
54 $_POST['cogs_account'], $_POST['inventory_account'],
55 $_POST['adjustment_account'], $_POST['assembly_account'],
56 $_POST['units'], $_POST['mb_flag'], $_POST['dim1'],
57 $_POST['dim2'], check_value('no_sale'));
58 display_notification(_('New item category has been added'));
64 //----------------------------------------------------------------------------------
66 if ($Mode == 'Delete')
69 // PREVENT DELETES IF DEPENDENT RECORDS IN 'stock_master'
70 if (key_in_foreign_table($selected_id, 'stock_master', 'category_id'))
72 display_error(_("Cannot delete this item category because items have been created using this item category."));
76 delete_item_category($selected_id);
77 display_notification(_('Selected item category has been deleted'));
85 $sav = get_post('show_inactive');
87 $_POST['show_inactive'] = $sav;
89 if (list_updated('mb_flag')) {
90 $Ajax->activate('details');
92 //----------------------------------------------------------------------------------
94 $result = get_item_categories(check_value('show_inactive'));
97 start_table(TABLESTYLE, "width='80%'");
98 $th = array(_("Name"), _("Tax type"), _("Units"), _("Type"), _("Sales Act"),
99 _("Inventory Account"), _("COGS Account"), _("Adjustment Account"),
100 _("Assembly Account"), "", "");
101 inactive_control_column($th);
104 $k = 0; //row colour counter
106 while ($myrow = db_fetch($result))
109 alt_table_row_color($k);
111 label_cell($myrow["description"]);
112 label_cell($myrow["tax_name"]);
113 label_cell($myrow["dflt_units"], "align=center");
114 label_cell($stock_types[$myrow["dflt_mb_flag"]]);
115 label_cell($myrow["dflt_sales_act"], "align=center");
116 label_cell($myrow["dflt_inventory_act"], "align=center");
117 label_cell($myrow["dflt_cogs_act"], "align=center");
118 label_cell($myrow["dflt_adjustment_act"], "align=center");
119 label_cell($myrow["dflt_assembly_act"], "align=center");
120 inactive_control_cell($myrow["category_id"], $myrow["inactive"], 'stock_category', 'category_id');
121 edit_button_cell("Edit".$myrow["category_id"], _("Edit"));
122 delete_button_cell("Delete".$myrow["category_id"], _("Delete"));
126 inactive_control_row($th);
129 //----------------------------------------------------------------------------------
131 div_start('details');
132 start_table(TABLESTYLE2);
134 if ($selected_id != -1)
136 if ($Mode == 'Edit') {
137 //editing an existing item category
138 $myrow = get_item_category($selected_id);
140 $_POST['category_id'] = $myrow["category_id"];
141 $_POST['description'] = $myrow["description"];
142 $_POST['tax_type_id'] = $myrow["dflt_tax_type"];
143 $_POST['sales_account'] = $myrow["dflt_sales_act"];
144 $_POST['cogs_account'] = $myrow["dflt_cogs_act"];
145 $_POST['inventory_account'] = $myrow["dflt_inventory_act"];
146 $_POST['adjustment_account'] = $myrow["dflt_adjustment_act"];
147 $_POST['assembly_account'] = $myrow["dflt_assembly_act"];
148 $_POST['units'] = $myrow["dflt_units"];
149 $_POST['mb_flag'] = $myrow["dflt_mb_flag"];
150 $_POST['dim1'] = $myrow["dflt_dim1"];
151 $_POST['dim2'] = $myrow["dflt_dim2"];
152 $_POST['no_sale'] = $myrow["dflt_no_sale"];
154 hidden('selected_id', $selected_id);
155 hidden('category_id');
156 } else if ($Mode != 'CLONE') {
157 $_POST['long_description'] = '';
158 $_POST['description'] = '';
159 $_POST['no_sale'] = 0;
161 $company_record = get_company_prefs();
163 if (get_post('inventory_account') == "")
164 $_POST['inventory_account'] = $company_record["default_inventory_act"];
166 if (get_post('cogs_account') == "")
167 $_POST['cogs_account'] = $company_record["default_cogs_act"];
169 if (get_post('sales_account') == "")
170 $_POST['sales_account'] = $company_record["default_inv_sales_act"];
172 if (get_post('adjustment_account') == "")
173 $_POST['adjustment_account'] = $company_record["default_adj_act"];
175 if (get_post('assembly_account') == "")
176 $_POST['assembly_account'] = $company_record["default_assembly_act"];
180 text_row(_("Category Name:"), 'description', null, 30, 30);
182 table_section_title(_("Default values for new items"));
184 item_tax_types_list_row(_("Item Tax Type:"), 'tax_type_id', null);
186 stock_item_types_list_row(_("Item Type:"), 'mb_flag', null, true);
188 stock_units_list_row(_("Units of Measure:"), 'units', null);
190 check_row(_("Exclude from sales:"), 'no_sale');
192 gl_all_accounts_list_row(_("Sales Account:"), 'sales_account', $_POST['sales_account']);
194 if (is_service($_POST['mb_flag']))
196 gl_all_accounts_list_row(_("C.O.G.S. Account:"), 'cogs_account', $_POST['cogs_account']);
197 hidden('inventory_account', $_POST['inventory_account']);
198 hidden('adjustment_account', $_POST['adjustment_account']);
202 gl_all_accounts_list_row(_("Inventory Account:"), 'inventory_account', $_POST['inventory_account']);
204 gl_all_accounts_list_row(_("C.O.G.S. Account:"), 'cogs_account', $_POST['cogs_account']);
205 gl_all_accounts_list_row(_("Inventory Adjustments Account:"), 'adjustment_account', $_POST['adjustment_account']);
208 if (is_manufactured($_POST['mb_flag']))
209 gl_all_accounts_list_row(_("Item Assembly Costs Account:"), 'assembly_account', $_POST['assembly_account']);
211 hidden('assembly_account', $_POST['assembly_account']);
213 $dim = get_company_pref('use_dimension');
216 dimensions_list_row(_("Dimension")." 1", 'dim1', null, true, " ", false, 1);
218 dimensions_list_row(_("Dimension")." 2", 'dim2', null, true, " ", false, 2);
227 submit_add_or_update_center($selected_id == -1, '', 'both', true);