@Action(value = "/deduction/autoRemittance-manualSchedule")
public String manualSchedule() {
try {
coaMap = new LinkedHashMap<String, String>();
List<Recovery> allActiveAutoRemitTds = tdsDAO.getAllActiveAutoRemitTds();
for (Recovery r : allActiveAutoRemitTds) {
coaMap.put(
r.getChartofaccounts().getGlcode(),
r.getChartofaccounts().getGlcode() + "-" + r.getChartofaccounts().getName());
}
addDropdownData("departmentList", masterCache.get("egi-department"));
deptDOList =
persistenceService.findAllBy("from DepartmentDOMapping where department is not null ");
List<Object[]> list =
HibernateUtil.getCurrentSession()
.createSQLQuery(
"select glcode, to_char(max(lastrundate),'dd/mm/yyyy') from egf_remittance_scheduler where glcode is not null and sch_type='A' "
+ " GROUP by glcode order by glcode")
.list();
lastRunDateMap = new HashMap<String, String>();
for (Object[] ob : list) {
lastRunDateMap.put((String) ob[0], (String) ob[1]);
}
} catch (ApplicationRuntimeException e) {
addActionError("failed");
} catch (HibernateException e) {
addActionError("failed");
} catch (Exception e) {
addActionError("failed");
}
return "manual";
}
