public void saveJobDetails() {
// TODO Auto-generated method stub
if (job == null) {
commonUTIL.showAlertMessage("Select Template");
return;
}
int rowCount = searchPanel.table.getRowCount();
Vector<UserJobsDetails> jobdets = new Vector<UserJobsDetails>();
for (int i = 0; i < searchPanel.getFilterBeanData().size(); i++) {
FilterBean filterBean = searchPanel.getFilterBeanData().get(i);
UserJobsDetails ud = new UserJobsDetails();
ud.setJobId(job.getId());
ud.setColumnName(filterBean.getColumnName());
ud.setCriteria(filterBean.getSearchCriteria());
ud.setValues(filterBean.getColumnValues());
ud.setFilterValues(filterBean.getIdSelected());
ud.setAnd_or(filterBean.getAnd_or());
ud.setRowid(i);
jobdets.add(ud);
}
try {
if (!reportPanel.getColumnSQL().equalsIgnoreCase(job.getSql())) {
job.setSql(reportPanel.getColumnSQL());
reportPanel.getRemoteTask().updateJob(job);
}
reportPanel.getRemoteTask().saveUserJobsDetails(jobdets, job.getId());
} catch (RemoteException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
private void loadJobs(Vector<UserJobsDetails> jobdetails) {
// TODO Auto-generated method stub
if (!commonUTIL.isEmpty(jobdetails)) {
searchPanel.clearllCriterial();
for (int i = 0; i < jobdetails.size(); i++) {
UserJobsDetails jd = jobdetails.get(i);
FilterBean bean = new FilterBean();
bean.setSearchCriteria(jd.getCriteria());
bean.setColumnName(jd.getColumnName());
bean.setColumnValues(jd.getValues());
bean.setAnd_or(jd.getAnd_or());
bean.setIdSelected(jd.getFilterValues());
searchPanel.addNewRow(bean);
int rowCount = searchPanel.getTableRowCount();
String criteria[] = null;
criteria = getFilterValues().convertVectortoSringArray(searchCriteria, "SearchCriteria");
if (bean.getColumnName().endsWith("Date")) {
criteria = getFilterValues().getDateSearchCriteria();
searchPanel.addRowEditor(
rowCount - 1, 1, getDateCriteriaJComboxBox(criteria), "Criteria");
searchPanel.addRowEditor(rowCount - 1, 2, getDateCellEditor("Values"), "Values");
searchPanel.addRowEditor(rowCount - 1, 3, getDateCellEditor("And/Or"), "And/Or");
} else {
searchPanel.addRowEditor(rowCount - 1, 1, getJComboxBox(criteria), "Criteria");
Vector dataValues = getFilterValues().getValuesonColumn(bean.getColumnName(), null);
if (dataValues == null || dataValues.isEmpty()) {
String mvalues[] =
getFilterValues().convertVectortoSringArray(dataValues, bean.getColumnName(), 0);
searchPanel.addRowEditor(
rowCount - 1, 2, getMultiSelectListExComboBox(mvalues), "Values");
}
}
// bean.setIdSelected(jd.);
}
}
}