Newer
Older
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
public class PrcControlParser extends SubjectParser {
@Override
protected String parseScreeningNumber(Row row) {
String number = getString(row.getCell(13));
if (number.length() == 1) {
number = "00" + number;
} else if (number.length() == 2) {
number = "0" + number;
}
return "P-" + number;
}
}
@Override
protected String parseName(Row row) {
return getString(row.getCell(1));
}
@Override
protected String parseSurname(Row row) {
return getString(row.getCell(0));
}
@Override
protected String parseNdNumber(Row row) {
return getString(row.getCell(12));
}
@Override
protected String getSheetName() {
return "Contrôles";
}
@Override
protected int getInitRow() {
return 1;
}
@Override
protected String parseBirthDate(Row row) {
return parseDateOfBirth(row.getCell(11));
}
@Override
protected String parsemPowerId(Row row) {
return "";
}
@Override
protected String parseAddDate(Row row) {
return getDate(row.getCell(9), Calendar.getInstance());
}
@Override
protected String parseReferal(Row row) {
return "";
}
@Override
protected String parseDiagnosisYear(Row row) {
return "";
}
@Override
protected String parseMail(Row row) {
return getString(row.getCell(8));
}
@Override
protected String parsePhone3(Row row) {
return "";
}
@Override
protected String parsePhone2(Row row) {
return getString(row.getCell(7));
}
@Override
protected String parsePhone1(Row row) {
return getString(row.getCell(6));
}
@Override
protected String parseCity(Row row) {
return getString(row.getCell(4));
}
@Override
protected String parseCountry(Row row) {
return getString(row.getCell(5));
}
@Override
protected String parseZipCode(Row row) {
return getString(row.getCell(3));
}
@Override
protected String parseAddress(Row row) {
return getString(row.getCell(2));
}
@Override
protected String parseRemarks(Row row) {
String remark1 = getString(row.getCell(10));
String remark2 = "";
String result = "";
if (!remark1.trim().isEmpty()) {
result = result + remark1 + "\n";
}
if (!remark2.trim().isEmpty()) {
result = result + remark2 + "\n";
}
return result;
}
@Override
protected String parseDiagnosis(Row row) {
return "";
}
@Override
protected SubjectType parseType(Row row) {
return SubjectType.CONTROL;
}
@Override
protected List<String> parseLanguages(Row row) {
return new ArrayList<>();
}
@Override
protected String parseToBeSeenAt(Row row) {
return "P";
}
@Override
protected boolean parseDead(Row row) {
return false;
}
@Override
protected boolean parseResigned(Row row) {
return false;
}