- $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 != 0)
- $sql .= " AND ".TB_PREF."sales_types.id = '$salestype'";
+ $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";