/*
* 刷新并添加没有的学习中心指标
*
* @see net.cedu.biz.enrollment.BranchEnrollQuotaBiz#addRefreshBranchEnrollQuotaBybatchId(int, int)
*/
public int addRefreshBranchEnrollQuotaBybatchId(int batchId, int userId) throws Exception {
int count = 0;
List<Object> lst = new ArrayList();
String hql = "";
// 批次
hql += " and batchId=" + Constants.PLACEHOLDER;
lst.add(batchId);
// 未删除的
hql += "and deleteFlag=" + Constants.PLACEHOLDER;
lst.add(Constants.DELETE_FALSE);
List<BranchEnrollQuota> brqlist = branchenrollquotaDao.getByProperty(hql, lst.toArray());
List<Branch> branchlist =
branchDao.getByProperty(
" and parentId > "
+ Constants.PLACEHOLDER
+ "and deleteFlag="
+ Constants.PLACEHOLDER
+ " order by id desc ",
new Object[] {BranchEnum.Parent.value(), Constants.DELETE_FALSE});
if (brqlist != null && brqlist.size() > 0 && branchlist != null && branchlist.size() > 0) {
int branchsize = branchlist.size();
int brqsize = brqlist.size();
if (branchsize <= brqsize) {
count = 1;
} else {
int index = 0;
for (Branch branch : branchlist) {
boolean isback = false;
for (BranchEnrollQuota brq : brqlist) {
if (branch.getId() == brq.getId()) {
isback = true;
break;
}
}
if (!isback) {
BranchEnrollQuota beq = new BranchEnrollQuota();
beq.setBatchId(batchId);
beq.setBranchId(branch.getId());
beq.setTarget(0);
beq.setCreatorId(userId);
beq.setCreatedTime(new Date());
this.addBranchEnrollQuota(beq);
index++;
}
if (brqsize + index >= branchsize) {
break;
}
}
count = 2;
}
}
return count;
}
/*
* 查询学习中心 按学习中心Id&(多),批次Id&(多)
*
* @see
* net.cedu.biz.enrollment.BranchEnrollQuotaBiz#findBranchEnrollQuotaByBranchId
* (int)
*/
public List<BranchEnrollQuota> findBranchEnrollQuotaByBranchIds(String batchIds, String branchIds)
throws Exception {
if ((null != batchIds && !"".equals(batchIds))
&& (null != branchIds && !"".equals(branchIds))) {
return branchenrollquotaDao.getByProperty(
"and batchId in ("
+ Constants.PLACEHOLDER
+ ")"
+ "and branchId in ("
+ Constants.PLACEHOLDER
+ ")"
+ " and deleteFlag="
+ Constants.PLACEHOLDER,
new Object[] {"$" + batchIds, "$" + branchIds, Constants.DELETE_FALSE});
} else if ((null != batchIds && !"".equals(batchIds))
&& (null == branchIds || "".equals(branchIds))) {
return branchenrollquotaDao.getByProperty(
"and batchId in ("
+ Constants.PLACEHOLDER
+ ")"
+ " and deleteFlag="
+ Constants.PLACEHOLDER,
new Object[] {"$" + batchIds, Constants.DELETE_FALSE});
} else if ((null == batchIds || "".equals(batchIds))
&& (null != branchIds || !"".equals(branchIds))) {
return branchenrollquotaDao.getByProperty(
"and branchId in ("
+ Constants.PLACEHOLDER
+ ")"
+ " and deleteFlag="
+ Constants.PLACEHOLDER,
new Object[] {"$" + branchIds, Constants.DELETE_FALSE});
} else {
return branchenrollquotaDao.findAllNotDeleted();
}
}