";
}
if($access_level=='W' || $access_level=='E' )
{
$edit_link="";
}
if($access_level=='E' )
{
$delete_link="";
}
$space=" ";
$links = $view_link.$space.$edit_link.$space.$delete_link;
$cat=getTableFieldValue('tbl_categories','cat_name','cat_id',$row1['cat'],'');
$subcat=getTableFieldValue('sub_category','sub_cat_name','sub_cat_id',$row1['subcat'],'');
$unit=getTableFieldValue('unit_master','unit_name','unit_id',$row1['unit_id'],'');
$item_ingredients =getCommaSeperatedValuesForInClause("select ingredient_name from ingredient ","ingredient_id",$row1['active_ingredients']);
$item_ailment_systems = getCommaSeperatedValuesForInClause("select ailment_sys_name from ailment_system ","ailment_sys_id",$row1['ailments']);
$data['rows'][] = array(
'id' => $row1['item_id'],
'cell' => array($count++, $row1['item_name'],$item_ingredients, $manufacturer_name, $item_ailment_systems, $form_name, $cat ,$current_stock_level.' '.$unit, $row1['reorder_stock_level'].' '.$unit,$row1['current_rate'].' per '.$unit,$links)
);
}
echo json_encode($data);
?>