".TB_PREF."stock_category.description
FROM ".TB_PREF."stock_master,
".TB_PREF."stock_category
- WHERE ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id";
+ WHERE ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id AND NOT ".TB_PREF."stock_master.inactive";
if ($category != 0)
$sql .= " AND ".TB_PREF."stock_category.category_id = ".db_escape($category);
$sql .= " ORDER BY ".TB_PREF."stock_master.category_id,
function print_price_listing()
{
- global $comp_path, $path_to_root, $pic_height, $pic_width;
+ global $path_to_root, $pic_height, $pic_width;
$currency = $_POST['PARAM_0'];
$category = $_POST['PARAM_1'];
}
if ($pictures)
{
- $image = $comp_path . '/'. $user_comp . "/images/"
+ $image = company_path(). "/images/"
. item_img_name($myrow['stock_id']) . ".jpg";
if (file_exists($image))
{