"; } //echo $hasWriteAccess; if($hasWriteAccess) { $edit_link=""; } if($hasExecuteAccess) { $delete_link=""; } $item_desc=""; $item_qty=""; //$item_rate=""; $sql_group_items=" select * from group_items where group_id=$id1"; $results_group_items= mysqli_query($conn,$sql_group_items); $item_desc=""; while ($row_group_items= mysqli_fetch_assoc($results_group_items)) { $item_desc = $item_desc.'

'.getTableFieldValue('tbl_items','item_name','item_id',$row_group_items['item_id']).'

'; $item_unit_id =getTableFieldValue(' tbl_items','unit_id','item_id',$row_group_items['item_id']); $item_unit =getTableFieldValue(' unit_master','unit_name','unit_id',$item_unit_id); $item_qty=$item_qty.'

'.$row_group_items['qty'].' '.$item_unit.'

'; $item_type=$row_group_items['item_type']; $cost = $row_group_items['cost']; } /*$item_desc = $item_desc.'

'.getTableFieldValue('tbl_items','item_name','item_id',$row1['item_id']).'

'; $item_unit_id=getTableFieldValue('tbl_items','unit_id','item_id',$row1['item_id']); $item_unit =getTableFieldValue(' unit_master','unit_name','unit_id',$item_unit_id); $item_qty=$item_qty.'

'.$row1['qty'].' '.$item_unit.'

';*/ // echo $item_expiry_date; $space=" "; $links = $assign_link.$space.$view_link.$space.$edit_link; $data['rows'][] = array( 'id' => $row1['id'], 'cell' => array($count++,$row1['item_name'],$item_type==1?'Grouping Item':'Packaging Item',$item_desc,$item_qty,$cost,$edit_link) ); } echo json_encode($data);