/**
* Tests <code>{@link CopilotProjectDAOImpl#delete(long)}</code> method.
*
* @throws CopilotDAOException if any error occurs
*/
@Test
@SuppressWarnings("unchecked")
public void testDelete2() throws CopilotDAOException {
CopilotProfile copilotProfile = TestHelper.createCopilotProfile();
CopilotProject copilotProject = TestHelper.createCopilotProject();
TestHelper.persistCopilotProjectDependencies(hibernateTemplate, copilotProfile, copilotProject);
CopilotProjectInfoType copilotProjectInfoType = TestHelper.createCopilotProjectInfoType();
hibernateTemplate.save(copilotProjectInfoType);
CopilotProjectInfo copilotProjectInfo = TestHelper.createCopilotProjectInfo();
copilotProjectInfo.setCopilotProjectId(copilotProject.getId());
copilotProjectInfo.setInfoType(copilotProjectInfoType);
copilotProject.getProjectInfos().add(copilotProjectInfo);
hibernateTemplate.save(copilotProject);
instance.delete(copilotProject.getId());
Assert.assertEquals(
"None entity in database should exist.",
0,
hibernateTemplate.find("from CopilotProject").size());
Assert.assertEquals(
"None entity in database should exist.",
0,
hibernateTemplate.find("from CopilotProjectInfo").size());
}
@Override
@Transactional(readOnly = true)
public List<Ticket> searchTicketByKeyword(String keyword) {
HibernateTemplate ht = getHibernateTemplate();
List<Ticket> resultList = new ArrayList<Ticket>();
List<Ticket> titleList =
ht.find("from Ticket t where t.title like ? order by t.id desc", wildCardKeyword(keyword));
List<Ticket> creatorList =
ht.find(
"from Ticket t where t.creator.username like ? order by t.id desc",
wildCardKeyword(keyword)); // searchTicket By Creator;
List<Ticket> assigneeList =
ht.find(
"from Ticket t where t.assignee.username like ? order by t.id desc",
wildCardKeyword(keyword));
List<Ticket> custList =
ht.find(
"from Ticket t where t.customer.username like ? order by t.id desc",
wildCardKeyword(keyword)); // searchTicketByCustomer(keyword);
// List<Ticket> noteList = ht.find("from Ticket t where t.notes.note like ?",
// wildCardKeyword(keyword));
resultList.addAll(titleList);
resultList.addAll(creatorList);
resultList.addAll(assigneeList);
resultList.addAll(custList);
// resultList.addAll(noteList);
return resultList;
}
/**
* 还款时候，取消正在转让的债权
*
* @param loanId
* @throws RepayException
*/
public void cancelTransfering(String loanId) throws RepayException {
// 取消投资下面的所有正在转让的债权
String hql = "from TransferApply ta where ta.invest.loan.id=? and ta.status=?";
List<TransferApply> tas = ht.find(hql, new String[] {loanId, TransferStatus.WAITCONFIRM});
if (tas.size() > 0) {
// 有购买了等待第三方确认的债权，所以不能还款。
throw new RepayException("有等待第三方确认的债权转让，不能还款！");
}
tas = ht.find(hql, new String[] {loanId, TransferStatus.TRANSFERING});
for (TransferApply ta : tas) {
transferService.cancel(ta.getId());
}
}
public void importarPendientes(Long sucursalId) {
String sql = "select * from sx_clientes_log where tx_importado is null";
JdbcTemplate template = ReplicaServices.getInstance().getJdbcTemplate(sucursalId);
List<Map<String, Object>> rows = template.queryForList(sql);
for (Map<String, Object> row : rows) {
System.out.println("Importando: " + row);
try {
Number cliente_id = (Number) row.get("CLIENTE_ID");
HibernateTemplate source = ReplicaServices.getInstance().getHibernateTemplate(sucursalId);
List<Cliente> clientes =
source.find(
"from Cliente c "
+ " left join fetch c.direcciones d"
+ " left join fetch c.telefonos t"
+ " where c.id=?",
cliente_id.longValue());
Cliente c = clientes.get(0);
Services.getInstance().getHibernateTemplate().replicate(c, ReplicationMode.IGNORE);
} catch (Exception e) {
logger.error("Error importando cliente: " + row, e);
}
try {
Number id = (Number) row.get("ID");
String update = "UPDATE SX_CLIENTES_LOG SET TX_IMPORTADO=NOW() WHERE ID=?";
template.update(update, new Object[] {id.longValue()});
} catch (Exception e) {
logger.error("Error actualizando importado: " + row);
}
}
}
public List getListFieldValueByMemberId(String memberId) {
String sql =
"select fieldValue from Customer customer,FieldValue fieldValue where fieldValue.userId=customer.webId and fieldValue.fieldId=99";
sql += " and customer.uid = ?";
List list = hibernateTemplate.find(sql, memberId);
return list;
}
public BackDetail loadByNum(String num) {
String queryString = "from BackDetail backDetail where backDetail.code='" + num + "'";
List<BackDetail> backDetails = hibernateTemplate.find(queryString);
return backDetails.get(0);
}
@SuppressWarnings("unchecked")
@Transactional
@Override
public List<LookFor> findAllLookFor() {
List<LookFor> result = template.find("from LookFor");
return result;
}
/**
* Tests <code>{@link
* CopilotProjectDAOImpl#update(com.topcoder.direct.services.copilot.model.IdentifiableEntity)}
* </code> method.
*
* @throws CopilotDAOException if any error occurs
*/
@Test
@SuppressWarnings("unchecked")
public void testUpdate() throws CopilotDAOException {
CopilotProfile copilotProfile = TestHelper.createCopilotProfile();
CopilotProject copilotProject = TestHelper.createCopilotProject();
TestHelper.persistCopilotProjectDependencies(hibernateTemplate, copilotProfile, copilotProject);
hibernateTemplate.save(copilotProject);
copilotProject.setCompletionDate(new Date());
copilotProject.setCustomerFeedback("test customer feedback");
copilotProject.setCustomerRating(0.9F);
copilotProject.setPmFeedback("test pm feedback");
copilotProject.setPmRating(0.9F);
CopilotProjectInfoType copilotProjectInfoType = TestHelper.createCopilotProjectInfoType();
hibernateTemplate.save(copilotProjectInfoType);
CopilotProjectInfo copilotProjectInfo = TestHelper.createCopilotProjectInfo();
copilotProjectInfo.setInfoType(copilotProjectInfoType);
copilotProject.getProjectInfos().add(copilotProjectInfo);
instance.update(copilotProject);
List<CopilotProject> result =
(List<CopilotProject>)
hibernateTemplate.find("from CopilotProject where id = ?", copilotProject.getId());
assertCopilotProject(copilotProject, result.get(0));
}
public void importarClientesPendientes(final Date desde) {
for (Long sucursal : getSucursales()) {
JdbcTemplate sucursalTemplate = ReplicaServices.getInstance().getJdbcTemplate(sucursal);
String sql = "select CLIENTE_ID from sx_clientes where date(creado)>=?";
Object args[] = {new SqlParameterValue(Types.DATE, desde)};
final List<Long> ids = sucursalTemplate.queryForList(sql, args, Long.class);
System.out.println("Clientes: " + ids.size());
for (Long id : ids) {
System.out.println("Validando: " + id + " En sucursal: " + sucursal);
Cliente c = Services.getInstance().getClientesManager().get(id);
if (c == null) {
System.out.println("Faltante: " + id + " importandolo...");
HibernateTemplate target = Services.getInstance().getHibernateTemplate();
HibernateTemplate source = ReplicaServices.getInstance().getHibernateTemplate(sucursal);
List<Cliente> clientes =
source.find(
"from Cliente c left join fetch c.credito "
+ " left join fetch c.direcciones d"
+ " left join fetch c.telefonos t"
+ " where c.id=?",
id);
c = clientes.get(0);
target.replicate(c, ReplicationMode.EXCEPTION);
}
}
}
}
@Override
public int sizeOfAll() {
// TODO Auto-generated method stub
String hql = "select count(*) from Goodsinfo";
Object o = mysqlhibernateTemplete.find(hql).listIterator().next();
Integer count = Integer.parseInt(o == null ? "0" : o.toString());
return count.intValue();
}
@SuppressWarnings("unchecked")
public Account findByCreditCard(String creditCardNumber) {
List<Account> accounts =
hibernateTemplate.find("from Account a where a.creditCardNumber = ?", creditCardNumber);
if (accounts.isEmpty()) return null;
return accounts.get(0);
}
public List<BackDetail> getBackDetailsByNum(String num) {
// TODO Auto-generated method stub
String queryString = "from BackDetail backDetail where backDetail.code='" + num + "'";
List<BackDetail> backDetails = hibernateTemplate.find(queryString);
return backDetails;
}
public Authorities findByPrimaryKey(Object key) {
if (key instanceof String) {
String username = (String) key;
List<?> find = hibernateTemplate.find("from Authorities where username = ?", username);
return (Authorities) find.get(0);
} else {
return null;
}
}
public List<FieldValue> getFieldValueListByUserIdAndRole(Integer userId, String role) {
String sql =
"from FieldValue fieldValue where fieldValue.userId="
+ userId
+ " and fieldValue.fieldValue LIKE '%"
+ role
+ "%'";
return hibernateTemplate.find(sql);
}
public List<Integer> getIdListByUserIdAndGroup(Integer fieldId, Integer userId, Integer group) {
String sql =
"select value.fieldValueId from FieldValue value where value.fieldId="
+ fieldId
+ " and value.userId="
+ userId;
sql += " and value.groupMulti=" + group;
return hibernateTemplate.find(sql);
}
public void loadDetails(Object target, HibernateTemplate ht, String fkName, Object key)
throws Exception {
for (PropertyDescriptor pd : listProps) {
String hsql = "from " + capitalizeFirstChar(pd.getName()) + " p where p." + fkName + " = ?";
// System.out.println("hsql is " + hsql);
List items = ht.find(hsql, key);
pd.getWriteMethod().invoke(target, items);
}
}
public Long getPCCount() {
try {
List<Long> count =
hibernateTemplate.find(
"select COUNT(*) from Consumable c left join c.instru i where i is null");
return count.get(0);
} catch (RuntimeException re) {
throw re;
}
}
public List<User> getUserNoTeachstaffenlargeinfo() {
String hql_1 = "from Teachstaffenlargeinfo";
List<Teachstaffenlargeinfo> teachstaffenlargeinfo = hibernateTemplate.find(hql_1);
String hql_2 = "from User";
List<User> userBy = hibernateTemplate.find(hql_2);
List<User> userList = null;
for (User u : userBy) {
if (teachstaffenlargeinfo != null && teachstaffenlargeinfo.equals("[]")) {
for (Teachstaffenlargeinfo t : teachstaffenlargeinfo) {
if (u.getUserId() != t.getUserId()) {
userList.add(u);
}
}
} else {
userList = userBy;
}
}
return userList;
}
/** 资金池累计充值 */
public double getPaidCapRechargeMoney(String userId) {
String hql =
"select sum(recharge.actualMoney) from Recharge recharge "
+ "where recharge.status =? and recharge.user.id=? and recharge.rechargeWay='cap'";
List<Object> oos = ht.find(hql, new String[] {RechargeStatus.SUCCESS, userId});
Object o = oos.get(0);
if (o == null) {
return 0;
}
return (Double) o;
}
@Test
public void deposit() throws InsufficientPriviledgesException {
Deposit deposit = new Deposit(admin, brh, new Date(), 10.);
// make the deposit
depositRepository.executeDeposit(deposit);
// verify that the deposit has been created
List<Deposit> deposits = t.find("from Deposit");
assertTrue("The deposit lists should contain the new deposit.", deposits.contains(deposit));
// verify that the saldo has been updated.
UserProfile brh_fromdb =
(UserProfile) t.find("from UserProfile u where u.id=?", brh.getId()).get(0);
assertEquals(
"The balance should be updated after the deposit.",
22.,
brh_fromdb.getBalance().doubleValue(),
0.001);
}
@Override
@Transactional(readOnly = false, rollbackFor = Exception.class)
public void delete(String levelForUserId) throws UserExistInLevelException {
// 如果有用户处于当前等级，则不能删除
String hql = "select count(user) from User user where user.level.id = ?";
long n = (Long) ht.find(hql, levelForUserId).get(0);
if (n > 0) {
throw new UserExistInLevelException();
}
ht.bulkUpdate("delete from LevelForUser lfu where lfu.id = ?", levelForUserId);
}
public List<Consumable> findByProperty(String key, Object value) {
log.debug("finding Consumable instance with property: " + key + ", value: " + value);
try {
String queryString = "from Consumable as model where model." + key + "= '" + value + "'";
List<Consumable> consumables = hibernateTemplate.find(queryString);
return consumables;
} catch (RuntimeException re) {
log.error("find by property name failed", re);
throw re;
}
}
@Override
@SuppressWarnings("unchecked")
public List<LineaPedido> masComprados() {
List<LineaPedido> lp =
hibernateTemplate.find("from LineaPedido group by producto order by Sum(cantidad) desc");
int numProductos = 10;
if (numProductos <= lp.size()) return lp.subList(0, 10);
else return lp.subList(0, lp.size());
}
/* (non-Javadoc)
* @see cn.cas.iue.dao.ConsumableDAO#getCount()
*/
@Override
public Long getICCount(Integer instruId) {
// TODO Auto-generated method stub
try {
List<Long> count =
hibernateTemplate.find(
"select COUNT(*) from Consumable c join c.instru i where i.instruId=" + instruId);
return count.get(0);
} catch (RuntimeException re) {
throw re;
}
}
@SuppressWarnings("unchecked")
public List<PlaceInfo> findPlaceInfoBySqlTop(String sql, int maxResults, Object... args) {
List<PlaceInfo> list = null;
try {
HibernateTemplate hibernateTemplate = getHibernateTemplate();
// hibernateTemplate.setMaxResults(maxResults);
list = hibernateTemplate.find(sql, args);
} catch (Exception e) {
}
return list;
}
/**
* Tests <code>{@link CopilotProjectDAOImpl#delete(long)}</code> method.
*
* @throws CopilotDAOException if any error occurs
*/
@Test
@SuppressWarnings("unchecked")
public void testDelete1() throws CopilotDAOException {
CopilotProfile copilotProfile1 = TestHelper.createCopilotProfile();
CopilotProject copilotProject1 = TestHelper.createCopilotProject();
TestHelper.persistCopilotProjectDependencies(
hibernateTemplate, copilotProfile1, copilotProject1);
hibernateTemplate.save(copilotProject1);
CopilotProfile copilotProfile2 = TestHelper.createCopilotProfile();
CopilotProject copilotProject2 = TestHelper.createCopilotProject();
TestHelper.persistCopilotProjectDependencies(
hibernateTemplate, copilotProfile2, copilotProject2);
hibernateTemplate.save(copilotProject2);
instance.delete(copilotProject1.getId());
List<CopilotProject> result =
hibernateTemplate.find("from CopilotProject where id = ?", copilotProject1.getId());
Assert.assertEquals(
"One entity in database should still exist.",
1,
hibernateTemplate.find("from CopilotProject").size());
Assert.assertEquals("Entity was not deleted.", 0, result.size());
instance.delete(copilotProject2.getId());
result = hibernateTemplate.find("from CopilotProject where id = ?", copilotProject2.getId());
Assert.assertEquals(
"None entity in database should exist.",
0,
hibernateTemplate.find("from CopilotProject").size());
Assert.assertEquals("Entity was not deleted.", 0, result.size());
}
/**
* Importa un cliente
*
* @param clave
* @param source
*/
public void importarCliente(String clave, Long sucursalId) {
HibernateTemplate target = Services.getInstance().getHibernateTemplate();
HibernateTemplate source = ReplicaServices.getInstance().getHibernateTemplate(sucursalId);
List<Cliente> clientes =
source.find(
"from Cliente c left join fetch c.credito "
+ " left join fetch c.direcciones d"
+ " left join fetch c.telefonos t"
+ " where c.clave=?",
clave);
Cliente c = clientes.get(0);
target.replicate(c, ReplicationMode.EXCEPTION);
}
@Override
@SuppressWarnings("unchecked")
@Transactional(readOnly = true)
public List<Company> findAll() throws DaoException {
List<Company> companies;
try {
companies = (List<Company>) hibernateTemplate.find("from Company order by name");
} catch (DataAccessException e) {
throw new DaoException("Error while calling findAll()", e);
}
return companies;
}
// 通过HQL语句 "select count(*) from table_name" 获取记录总数
public int getRecordCount(final String HQL) {
/*List list = ht.executeFind(
new HibernateCallback() {
public List doInHibernate(Session s) throws HibernateException, SQLException {
List result = s.createQuery(HQL).list();
return result;
}
}
);*/
List result = ht.find(HQL);
int recordCount = ((Number) result.iterator().next()).intValue();
// System.out.println("++++++++recordCount="+recordCount);
return recordCount;
}
/**
* Tests <code>{@link
* CopilotProjectDAOImpl#create(com.topcoder.direct.services.copilot.model.IdentifiableEntity)}
* </code> method.
*
* @throws com.topcoder.direct.services.copilot.dao.CopilotDAOException if any error occurs
*/
@Test
@SuppressWarnings("unchecked")
public void testCreate1() throws CopilotDAOException {
CopilotProfile copilotProfile = TestHelper.createCopilotProfile();
CopilotProject copilotProject = TestHelper.createCopilotProject();
TestHelper.persistCopilotProjectDependencies(hibernateTemplate, copilotProfile, copilotProject);
instance.create(copilotProject);
List<CopilotProject> result =
(List<CopilotProject>)
hibernateTemplate.find("from CopilotProject where id = ?", copilotProject.getId());
assertCopilotProject(copilotProject, result.get(0));
}
