public static boolean createItem(ReconcilationDTO tr, CashBook cb) {
String ref = tr.getRefNumber();
String amount = tr.getAmount();
try {
if (StringUtil.isNotEmpty(ref) && StringUtil.isNotEmpty(amount)) {
// BigDecimal bAmount = new BigDecimal(amount);
// CashBookEntry entry = cb.createEntry(System.currentTimeMillis() + "" +
// StringUtil.nextString(10));
// entry.setAccountCode( ref);
// entry.setSummary("Installment " + ref + " "+ tr.getDate());
// entry.setTitle(entry.getSummary());
// entry.setTotal(bAmount);
// entry.setDateOfTransaction(new SimpleDateFormat("dd MMM yyyy").parse(tr.getDate()));
// entry.save();
String nm = new Date().getTime() + StringUtil.nextString(10);
String code = StringUtil.nextString(10);
String sql =
"insert into WFS_FILE (clazz, dateCreated, lastModified, name, parent_id, summary, title, code, paymentMethod,total, accountCode, dateOfTransaction, DTYPE, absolutePath, size, status, commentable, dislikeit, likeit,ratable) values "
+ "('org.castafiore.accounting.CashBookEntry',now(),now(),'"
+ nm
+ "', "
+ "'/root/users/elieandsons/Applications/e-Shop/elieandsons/DefaultCashBook', "
+ "'Installment "
+ tr.getName()
+ " "
+ tr.getDate()
+ "', 'Installment "
+ tr.getName()
+ " "
+ tr.getDate()
+ "', '"
+ code
+ "', 'Standing Order', '"
+ tr.getAmount()
+ "', '"
+ tr.getName()
+ "',now() ,'CashBookEntry','/root/users/elieandsons/Applications/e-Shop/elieandsons/DefaultCashBook/"
+ nm
+ "',1,1,true,1,1, true);";
SpringUtil.getBeanOfType(Dao.class).getSession().createSQLQuery(sql).executeUpdate();
return true;
}
} catch (Exception e) {
e.printStackTrace();
}
return false;
}
