PHP版LIMS（开放实验室信息管理系统）

package csv; import java.util.HashMap; import interfaces.Treshold; public class CSVOperator { public void write_plain_csv(CSVReader csv_reader, CSVWriter csv_writer) { String[] header = csv_reader.get_header(); String header_row = ""; for (int i = 0; i < header.length; i++) { if(i < header.length - 1) { header_row += header[i] + csv_writer.get_delimiter(); } else { header_row += header[i]; } } header_row += csv_writer.get_line_break(); csv_writer.writeLine(header_row); String[] columns; while((columns = csv_reader.read_line()) != null) { String row = ""; for (int i = 0; i < columns.length; i++) { row += columns[i]; if(i < columns.length-1) { row += csv_writer.get_delimiter(); } } row += csv_writer.get_line_break(); csv_writer.writeLine(row); } csv_writer.close(); } public void rewrite_csv_in_new_order(CSVReader csv_reader, CSVWriter csv_writer, String[] order) { rewrite(csv_reader, csv_writer, order, null, null); } public void rewrite_csv_in_new_order(CSVReader csv_reader, CSVWriter csv_writer, Integer[] order) { rewrite(csv_reader, csv_writer, order, null, null); } public void rewrite_csv_with_deletes(CSVReader csv_reader, CSVWriter csv_writer, String[] deletes) { rewrite(csv_reader, csv_writer, null, deletes, null); } public void rewrite_csv_with_deletes(CSVReader csv_reader, CSVWriter csv_writer, Integer[] deletes) { rewrite(csv_reader, csv_writer, null, deletes, null); } public void rewrite_csv_with_new_order_and_deletes(CSVReader csv_reader, CSVWriter csv_writer, String[] order, String[] deletes) { rewrite(csv_reader, csv_writer, order, deletes, null); } public void rewrite_csv_with_new_order_and_deletes(CSVReader csv_reader, CSVWriter csv_writer, Integer[] order, Integer[] deletes) { rewrite(csv_reader, csv_writer, order, deletes, null); } public void rewrite_csv_with_tresholds(CSVReader csv_reader, CSVWriter csv_writer, String[] order, String[] deletes, Treshold[] tresholds) { rewrite(csv_reader, csv_writer, order, deletes, tresholds); for (Treshold treshold : tresholds) { treshold.destroy(); } } public void rewrite_csv_with_tresholds(CSVReader csv_reader, CSVWriter csv_writer, Integer[] order, Integer[] deletes, Treshold[] tresholds) { rewrite(csv_reader, csv_writer, order, deletes, tresholds); for (Treshold treshold : tresholds) { treshold.destroy(); } } //experimental public void rewrite_csv_with_tresholds_new(CSVReader csv_reader, CSVWriter csv_writer, String[] order, Treshold[] tresholds) { HashMap<Integer, Integer> real_indices_to_desired_column_indices = get_real_indices_to_desired_column_indices_new(csv_reader, csv_writer, order); rewrite_header(csv_reader, csv_writer, real_indices_to_desired_column_indices); rewrite_rows(csv_reader, csv_writer, real_indices_to_desired_column_indices, tresholds); csv_reader.close(); csv_writer.close(); for (Treshold treshold : tresholds) { treshold.destroy(); } } private void rewrite(CSVReader csv_reader, CSVWriter csv_writer, String[] order, String[] deletes, Treshold[] tresholds) { HashMap<Integer, Integer> real_indices_to_desired_column_indices = get_real_indices_to_desired_column_indices(csv_reader, csv_writer, order, deletes); rewrite_header(csv_reader, csv_writer, real_indices_to_desired_column_indices); rewrite_rows(csv_reader, csv_writer, real_indices_to_desired_column_indices, tresholds); csv_reader.close(); csv_writer.close(); } private void rewrite(CSVReader csv_reader, CSVWriter csv_writer, Integer[] order, Integer[] deletes, Treshold[] tresholds) { HashMap<Integer, Integer> real_indices_to_desired_column_indices = get_real_indices_to_desired_column_indices(csv_reader, csv_writer, order, deletes); rewrite_header(csv_reader, csv_writer, real_indices_to_desired_column_indices); rewrite_rows(csv_reader, csv_writer, real_indices_to_desired_column_indices, tresholds); csv_reader.close(); csv_writer.close(); } private HashMap<Integer, Integer> get_real_indices_to_desired_column_indices(CSVReader reader, CSVWriter writer, String[] order, String[] deletes) { if(order == null) { order = new String[0]; } else if(deletes == null) { deletes = new String[0]; } HashMap<Integer, Integer> real_indices_to_desired_column_indices = null; String[] header = reader.get_header(); int new_column_count = header.length; if(order.length == 0 && deletes.length == 0) { real_indices_to_desired_column_indices = new HashMap<Integer, Integer>(header.length); for (int i = 0; i < header.length; i++) { real_indices_to_desired_column_indices.put(i, i); } } else if(order.length == 0) { new_column_count = header.length - deletes.length; real_indices_to_desired_column_indices = new HashMap<Integer, Integer>(new_column_count); for (int i = 0; i < header.length; i++) { real_indices_to_desired_column_indices.put(i, i); } for (int i = 0; i < deletes.length; i++) { int original_index = reader.get_column_index(deletes[i]); real_indices_to_desired_column_indices.put(original_index, -1); } } else if(deletes.length == 0) { real_indices_to_desired_column_indices = new HashMap<Integer, Integer>(order.length); for (int i = 0; i < order.length; i++) { int original_index = reader.get_column_index(order[i]); real_indices_to_desired_column_indices.put(original_index, i); } } else { new_column_count = header.length - deletes.length; real_indices_to_desired_column_indices = new HashMap<Integer, Integer>(new_column_count); for (int i = 0; i < header.length; i++) { real_indices_to_desired_column_indices.put(i, i); } for (int i = 0; i < deletes.length; i++) { int original_index = reader.get_column_index(deletes[i]); real_indices_to_desired_column_indices.put(original_index, -1); } for (int i = 0; i < order.length; i++) { int original_index = reader.get_column_index(order[i]); real_indices_to_desired_column_indices.put(original_index, i); } } writer.set_new_column_count(new_column_count); return real_indices_to_desired_column_indices; } private HashMap<Integer, Integer> get_real_indices_to_desired_column_indices(CSVReader reader, CSVWriter writer, Integer[] order, Integer[] deletes) { HashMap<Integer, Integer> real_indices_to_desired_column_indices = null; String[] header = reader.get_header(); int new_column_count = header.length; if(order == null && deletes == null) { real_indices_to_desired_column_indices = new HashMap<Integer, Integer>(header.length); for (int i = 0; i < header.length; i++) { real_indices_to_desired_column_indices.put(i, i); } } else if(order == null) { new_column_count = header.length - deletes.length; real_indices_to_desired_column_indices = new HashMap<Integer, Integer>(new_column_count); for (int i = 0; i < header.length; i++) { real_indices_to_desired_column_indices.put(i, i); } for (int i = 0; i < deletes.length; i++) { real_indices_to_desired_column_indices.put(deletes[i], -1); } } else if(deletes == null) { real_indices_to_desired_column_indices = new HashMap<Integer, Integer>(order.length); for (int i = 0; i < order.length; i++) { real_indices_to_desired_column_indices.put(order[i], i); } } else { new_column_count = header.length - deletes.length; real_indices_to_desired_column_indices = new HashMap<Integer, Integer>(new_column_count); for (int i = 0; i <