- $sql = "SELECT ".TB_PREF."prices.sales_type_id,
- ".TB_PREF."prices.stock_id,
- ".TB_PREF."stock_master.description AS name,
- ".TB_PREF."prices.curr_abrev,
- ".TB_PREF."prices.price,
- ".TB_PREF."sales_types.sales_type,
- ".TB_PREF."stock_master.material_cost+".TB_PREF."stock_master.labour_cost+".TB_PREF."stock_master.overhead_cost AS Standardcost,
- ".TB_PREF."stock_master.category_id,
- ".TB_PREF."stock_category.description
- FROM ".TB_PREF."stock_master,
- ".TB_PREF."stock_category,
- ".TB_PREF."sales_types,
- ".TB_PREF."prices
- WHERE ".TB_PREF."stock_master.stock_id=".TB_PREF."prices.stock_id
- AND ".TB_PREF."prices.sales_type_id=".TB_PREF."sales_types.id
- AND ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id";
- if ($salestype != null)
- $sql .= " AND ".TB_PREF."sales_types.id = '$salestype'";
- if ($category != null)
- $sql .= " AND ".TB_PREF."stock_category.category_id = '$category'";
- $sql .= " ORDER BY ".TB_PREF."prices.curr_abrev,
- ".TB_PREF."stock_master.category_id,
- ".TB_PREF."stock_master.stock_id";
+ $sql = "SELECT item.stock_id, item.description AS name,
+ item.material_cost AS Standardcost,
+ item.category_id,item.units,
+ category.description
+ FROM ".TB_PREF."stock_master item,
+ ".TB_PREF."stock_category category
+ WHERE item.category_id=category.category_id AND NOT item.inactive";
+ if ($category != 0)
+ $sql .= " AND category.category_id = ".db_escape($category);
+ $sql .= " AND item.mb_flag<> 'F' ORDER BY item.category_id,
+ item.stock_id";