private Collection<FclAccountProfitabilityModel> getSearchResult(
FclAccountProfitabilityForm form) {
StringBuilder query = new StringBuilder();
query.append(getAccountProfitabilityTableQuery(form));
SQLQuery sqlQuery = new DataHibernateDAO().createSQLQuery(query.toString());
sqlQuery.addScalar("id", StringType.INSTANCE);
sqlQuery.addScalar("account_name", StringType.INSTANCE);
sqlQuery.addScalar("account_type", StringType.INSTANCE);
sqlQuery.addScalar("bkg_count", StringType.INSTANCE);
sqlQuery.addScalar("actual_charge", StringType.INSTANCE);
sqlQuery.addScalar("actual_cost", StringType.INSTANCE);
sqlQuery.addScalar("bkg_cnt", StringType.INSTANCE);
sqlQuery.addScalar("quot_count", StringType.INSTANCE);
sqlQuery.addScalar("quot_ids", StringType.INSTANCE);
sqlQuery.addScalar("container", StringType.INSTANCE);
sqlQuery.addScalar("container_id", StringType.INSTANCE);
sqlQuery.addScalar("TUE", StringType.INSTANCE);
sqlQuery.setReadOnly(true);
List<FclAccountProfitabilityModel> searchList = getAccProfitability(sqlQuery.list());
return searchList;
}
