public UploadFilesHistory getUploadFilesHistoryByFileDate(final Date fileDate) {
final String queryStr =
"select * from upload_files_history where file_date = '"
+ CrmUtils.getDateString(fileDate, "yyyy-MM-dd")
+ "'";
try {
List<UploadFilesHistory> result =
em.createNativeQuery(queryStr, UploadFilesHistory.class).getResultList();
if (result == null || result.isEmpty()) {
return null;
} else {
return result.get(0);
}
} catch (Exception e) {
log.error(e);
return null;
}
}
