"; } if ($hasWriteAccess) { $edit_link = ""; } if ($hasExecuteAccess) { $delete_link = ""; } $space = "   "; $links = $assign_link . $space . $view_link . $space . $edit_link . $space . $delete_link; //$waste_category_name = getTableFieldValue ( 'waste_category', 'waste_category_name', 'waste_category_id', $row1['waste_category'] ); //$ohc_type_name = getTableFieldValue ( 'ohc_type ', 'ohc_type_name', 'ohc_type_id ', $row1['ohc_type_id '] ); $data ['rows'] [] = array ( 'id' => $row1 ['waste_id'], 'cell' => array ( $links, $count ++, date_format ( date_create ( $row1 ['waste_gen_date'] ), "d-M-Y" ), $row1 ['mines_yellow_qty'], $row1 ['yellow_qty_total'], $row1 ['mines_white_qty'], $row1 ['white_qty_total'], $row1 ['mines_blue_qty'], $row1 ['blue_qty_total'], $row1 ['mines_red_qty'], $row1 ['red_qty_total'] ) ); } $data['rows'][] = array( 'id' => $row['filterkey'], 'cell' => array('', "", "", '', '','', '', '', '', '', '', '', '','', '', '','', '', '','') ); echo json_encode($data); ?>