MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
***********************************************************************/
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
***********************************************************************/
$_POST['cogs_account'], $_POST['inventory_account'],
$_POST['adjustment_account'], $_POST['assembly_account'],
$_POST['units'], $_POST['mb_flag'], $_POST['dim1'], $_POST['dim2'],
$_POST['cogs_account'], $_POST['inventory_account'],
$_POST['adjustment_account'], $_POST['assembly_account'],
$_POST['units'], $_POST['mb_flag'], $_POST['dim1'], $_POST['dim2'],
$_POST['cogs_account'], $_POST['inventory_account'],
$_POST['adjustment_account'], $_POST['assembly_account'],
$_POST['units'], $_POST['mb_flag'], $_POST['dim1'],
$_POST['cogs_account'], $_POST['inventory_account'],
$_POST['adjustment_account'], $_POST['assembly_account'],
$_POST['units'], $_POST['mb_flag'], $_POST['dim1'],
- $sql= "SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE category_id='$selected_id'";
- $result = db_query($sql, "could not query stock master");
- $myrow = db_fetch_row($result);
- if ($myrow[0] > 0)
+ if (key_in_foreign_table($selected_id, 'stock_master', 'category_id'))
-$sql = "SELECT c.*, t.name as tax_name FROM ".TB_PREF."stock_category c, "
- .TB_PREF."item_tax_types t WHERE c.dflt_tax_type=t.id";
-if (!check_value('show_inactive')) $sql .= " AND !c.inactive";
-
-$result = db_query($sql, "could not get stock categories");
+$result = get_item_categories(check_value('show_inactive'));
$th = array(_("Name"), _("Tax type"), _("Units"), _("Type"), _("Sales Act"),
_("Inventory Account"), _("COGS Account"), _("Adjustment Account"),
_("Assembly Account"), "", "");
$th = array(_("Name"), _("Tax type"), _("Units"), _("Type"), _("Sales Act"),
_("Inventory Account"), _("COGS Account"), _("Adjustment Account"),
_("Assembly Account"), "", "");
$_POST['dim1'] = $myrow["dflt_dim1"];
$_POST['dim2'] = $myrow["dflt_dim2"];
$_POST['no_sale'] = $myrow["dflt_no_sale"];
$_POST['dim1'] = $myrow["dflt_dim1"];
$_POST['dim2'] = $myrow["dflt_dim2"];
$_POST['no_sale'] = $myrow["dflt_no_sale"];
gl_all_accounts_list_row(_("Sales Account:"), 'sales_account', $_POST['sales_account']);
if (is_service($_POST['mb_flag']))
gl_all_accounts_list_row(_("Sales Account:"), 'sales_account', $_POST['sales_account']);
if (is_service($_POST['mb_flag']))