private int countThisPersonServiceExemptionOnGiaf(
PersistentSuportGiaf oracleConnection,
PersonServiceExemption personServiceExemption,
Logger logger)
throws SQLException {
String query = getServiceExemptionQuery(personServiceExemption);
PreparedStatement preparedStatement = null;
ResultSet result = null;
try {
preparedStatement = oracleConnection.prepareStatement(query);
result = preparedStatement.executeQuery();
if (result.next()) {
int count = result.getInt("cont");
if (count > 0) {
if (count > 1) {
logger.debug(
"---> "
+ count
+ " ---> "
+ personServiceExemption.getGiafProfessionalData().getGiafPersonIdentification()
+ " FA: "
+ personServiceExemption.getServiceExemption().getGiafId());
}
return count;
}
}
return 0;
} finally {
if (result != null) {
result.close();
}
preparedStatement.close();
}
}
@Override
public List<Modification> processChanges(GiafMetadata metadata, PrintWriter log, Logger logger)
throws Exception {
List<Modification> modifications = new ArrayList<>();
PersistentSuportGiaf oracleConnection = PersistentSuportGiaf.getInstance();
PreparedStatement preparedStatement = oracleConnection.prepareStatement(getQuery());
ResultSet result = preparedStatement.executeQuery();
int count = 0;
int news = 0;
int notImported = 0;
int dontExist = 0;
Set<Person> importedButInvalid = new HashSet<Person>();
while (result.next()) {
count++;
String numberString = result.getString("emp_num");
Person person = metadata.getPerson(numberString, logger);
if (person == null) {
logger.debug("Invalid person with number: " + numberString);
dontExist++;
continue;
}
PersonProfessionalData personProfessionalData = person.getPersonProfessionalData();
if (personProfessionalData == null) {
logger.debug("Empty personProfessionalData: " + numberString);
dontExist++;
continue;
}
final GiafProfessionalData giafProfessionalData =
personProfessionalData.getGiafProfessionalDataByGiafPersonIdentification(numberString);
if (giafProfessionalData == null) {
logger.debug("Empty giafProfessionalData: " + numberString);
dontExist++;
continue;
}
final String serviceExemptionGiafId = result.getString("tip_disp");
final ServiceExemption serviceExemption = metadata.exemption(serviceExemptionGiafId);
if (serviceExemption == null) {
logger.debug(
"Empty serviceExemption: "
+ serviceExemptionGiafId
+ " for person number: "
+ numberString);
importedButInvalid.add(person);
}
String beginDateString = result.getString("DATA_INICIO");
final LocalDate beginDate =
Strings.isNullOrEmpty(beginDateString)
? null
: new LocalDate(Timestamp.valueOf(beginDateString));
if (beginDate == null) {
logger.debug(
"Empty beginDate. Person number: "
+ numberString
+ " ServiceExemption: "
+ serviceExemptionGiafId);
importedButInvalid.add(person);
}
String endDateString = result.getString("DATA_FIM");
final LocalDate endDate =
Strings.isNullOrEmpty(endDateString)
? null
: new LocalDate(Timestamp.valueOf(endDateString));
if (beginDate != null && endDate != null) {
if (beginDate.isAfter(endDate)) {
logger.debug(
"BeginDate after endDate. Person number: "
+ numberString
+ " begin: "
+ beginDate
+ " end: "
+ endDate);
importedButInvalid.add(person);
}
}
String creationDateString = result.getString("data_criacao");
if (Strings.isNullOrEmpty(creationDateString)) {
logger.debug(
"Empty creationDate. Person number: "
+ numberString
+ " ServiceExemption: "
+ serviceExemptionGiafId);
notImported++;
continue;
}
final DateTime creationDate = new DateTime(Timestamp.valueOf(creationDateString));
String modifiedDateString = result.getString("data_alteracao");
final DateTime modifiedDate =
Strings.isNullOrEmpty(modifiedDateString)
? null
: new DateTime(Timestamp.valueOf(modifiedDateString));
if (!hasPersonServiceExemption(
giafProfessionalData,
beginDate,
endDate,
serviceExemption,
serviceExemptionGiafId,
creationDate,
modifiedDate)) {
modifications.add(
new Modification() {
@Override
public void execute() {
new PersonServiceExemption(
giafProfessionalData,
beginDate,
endDate,
serviceExemption,
serviceExemptionGiafId,
creationDate,
modifiedDate);
}
});
news++;
}
}
result.close();
preparedStatement.close();
int deleted = 0;
int totalInFenix = 0;
int repeted = 0;
for (GiafProfessionalData giafProfessionalData :
Bennu.getInstance().getGiafProfessionalDataSet()) {
for (PersonProfessionalExemption personProfessionalExemption :
giafProfessionalData.getPersonProfessionalExemptionsSet()) {
if (personProfessionalExemption instanceof PersonServiceExemption
&& personProfessionalExemption.getAnulationDate() == null) {
final PersonServiceExemption personServiceExemption =
(PersonServiceExemption) personProfessionalExemption;
int countThisPersonServiceExemptionOnGiaf =
countThisPersonServiceExemptionOnGiaf(
oracleConnection, personServiceExemption, logger);
if (countThisPersonServiceExemptionOnGiaf == 0) {
modifications.add(
new Modification() {
@Override
public void execute() {
personServiceExemption.setAnulationDate(new DateTime());
}
});
deleted++;
} else {
totalInFenix++;
if (countThisPersonServiceExemptionOnGiaf > 1) {
repeted += countThisPersonServiceExemptionOnGiaf - 1;
}
}
}
}
}
oracleConnection.closeConnection();
log.println("-- Service Exemptions --");
log.println("Total GIAF: " + count);
log.println("New: " + news);
log.println("Deleted: " + deleted);
log.println("Not imported: " + notImported);
log.println("Imported with errors: " + importedButInvalid.size());
log.println("Repeted: " + repeted);
log.println("Invalid persons: " + dontExist);
log.println("Total Fénix: " + totalInFenix);
log.println("Total Fénix without errors: " + (totalInFenix - importedButInvalid.size()));
log.println("Missing in Fénix: " + (count - totalInFenix));
return modifications;
}