/*
* 查询批次下的所有学习中心
*
* @see
* net.cedu.biz.enrollment.BranchEnrollQuotaBiz#findBranchEnrollQuotaByBId
* (int)
*/
public List<BranchEnrollQuota> findBranchEnrollQuotaByBId(int batchId) throws Exception {
List<BranchEnrollQuota> branchenrollquotalst = null;
PageParame p = new PageParame();
String hqlparam = "";
List<Object> list = new ArrayList<Object>();
if (batchId != 0) {
hqlparam += " and batchId =" + Constants.PLACEHOLDER;
list.add(batchId);
}
hqlparam += " and deleteFlag=" + Constants.PLACEHOLDER;
list.add(Constants.DELETE_FALSE);
p.setHqlConditionExpression(hqlparam);
p.setValues(list.toArray());
Long[] branchenrollquotaids = branchenrollquotaDao.getIDs(p);
if (branchenrollquotaids != null && branchenrollquotaids.length != 0) {
branchenrollquotalst = new ArrayList<BranchEnrollQuota>();
for (int i = 0; i < branchenrollquotaids.length; i++) {
BranchEnrollQuota beq =
this.findBranchEnrollQuotaById(Integer.valueOf(branchenrollquotaids[i].toString()));
BranchEnrollQuota branchenrollquota = beq;
Branch branch = branchBiz.findBranchById(branchenrollquota.getBranchId());
if (branch != null) {
branchenrollquota.setBranchName(branch.getName());
}
branchenrollquotalst.add(branchenrollquota);
}
}
return branchenrollquotalst;
}
@Action(
value = "index_meterialstoreroom",
results = {@Result(name = "success", location = "index_meterialstoreroom.jsp")})
public String execute() {
try {
// 所有学习中心
branchlst = branchBiz.findBranchForModel();
// 显示所有库房实体
List<MeterialStoreroom> lists = meterialstoreroombiz.finMeterialStoreroomall();
if (0 < lists.size()) {
// 循环给库房名称赋值
for (MeterialStoreroom Storeroom : lists) {
Branch br = branchBiz.findBranchById(Storeroom.getPosition());
if (null != br) {
Storeroom.setPositionName(br.getName());
list.add(Storeroom);
}
}
}
} catch (Exception e) {
e.printStackTrace();
}
return SUCCESS;
}
/*
* 刷新并添加没有的学习中心指标
*
* @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;
}
/*
* 查询学习中心指标
*
* @see
* net.cedu.biz.enrollment.BranchEnrollQuotaBiz#findBranchEnrollQuotalist
* (net.cedu.model.page.PageResult)
*/
public List<BranchEnrollQuota> findBranchEnrollQuotalist(
int batchId, PageResult<BranchEnrollQuota> pr) throws Exception {
// 学习中心招生批次集合
List<BranchEnrollQuota> branchEnrollQuotaList =
branchenrollquotaDao.findBranchEnrollQuotaList(batchId);
if (branchEnrollQuotaList != null && branchEnrollQuotaList.size() != 0) {
BranchEnrollQuota branchenrollquota = null;
// key:学习中心ID_全局批次ID_院校ID value:招生指标
Map<String, Integer> targetMap = academyEnrollQuotaBiz.getTargetByBatch(batchId);
// key:学习中心ID_全局批次ID_院校ID value:完成指标
Map<String, Integer> targetComMap = studentDao.getCompleteCountAll(batchId);
for (int i = 0; i < branchEnrollQuotaList.size(); i++) {
branchenrollquota = branchEnrollQuotaList.get(i);
// 学习中心名称
Branch branch = branchBiz.findBranchById(branchenrollquota.getBranchId());
if (branch != null) {
branchenrollquota.setBranchName(branch.getName());
}
//
List<Academy> academylst =
academybatchbranchBiz.findAcademyByBranchIdAndGlobalBatchId(
branchenrollquota.getBranchId(), branchenrollquota.getBatchId());
if (academylst != null && academylst.size() > 0) {
for (int j = 0; j < academylst.size(); j++) {
// 克隆类
Academy academy1 = academylst.get(j);
Academy academy = academy1.clone();
// 指标
// academy.setTarget(getZhibiao(branchenrollquota.getBatchId(),branchenrollquota.getBranchId(), academy.getId()));
Integer target = targetMap.get(branchenrollquota.getBranchId() + "_" + academy.getId());
academy.setTarget(target == null ? 0 : target);
// 完成指标
// academy.setComplete(studentBiz.findStudentCount(batchId,academy.getId(),0));
Integer targetCom =
targetComMap.get(branchenrollquota.getBranchId() + "_" + academy.getId());
academy.setComplete(targetCom == null ? 0 : targetCom);
academylst.set(j, academy);
}
branchenrollquota.setAcademylst(academylst);
}
}
}
return branchEnrollQuotaList;
}
/*
* 查询学习中心指标按批次和中心Id
*
* @see net.cedu.biz.enrollment.BranchEnrollQuotaBiz#
* findBranchEnrollQuotaByBtachIdAndBranchId(int, int)
*/
public BranchEnrollQuota findBranchEnrollQuotaByBtachIdAndBranchId(int batchId, int branchId)
throws Exception {
BranchEnrollQuota beq = null;
PageParame p = new PageParame();
String hqlparam = "";
List<Object> list = new ArrayList<Object>();
if (batchId != 0) {
hqlparam += " and batchId=" + Constants.PLACEHOLDER;
list.add(batchId);
}
if (branchId != 0) {
hqlparam += " and branchId=" + Constants.PLACEHOLDER;
list.add(branchId);
}
hqlparam += " and deleteFlag=";
list.add(Constants.DELETE_FALSE);
p.setHqlConditionExpression(hqlparam);
p.setValues(list.toArray());
Long[] branchenrollquotaids = branchenrollquotaDao.getIDs(p);
if (branchenrollquotaids != null && branchenrollquotaids.length != 0) {
for (int i = 0; i < branchenrollquotaids.length; i++) {
// 修改人董溟浩，原作者循环取最后一个，逻辑有问题，所以改为跳过之前的直接取最后一个
if (i == branchenrollquotaids.length - 1) {
beq = new BranchEnrollQuota();
beq = this.findBranchEnrollQuotaById(Integer.valueOf(branchenrollquotaids[i].toString()));
GlobalEnrollBatch globalenrollbatch =
globalenrollbatchBiz.findGlobalEnrollBatchById(beq.getBatchId());
if (globalenrollbatch != null) {
beq.setBatchName(globalenrollbatch.getBatch());
}
Branch branch = branchBiz.findBranchById(beq.getBranchId());
if (branch != null) {
beq.setBranchName(branch.getName());
}
}
}
}
return beq;
}
/*
* 查询所有学习中心(分配指标)按批次
*
* @see net.cedu.biz.admin.BranchBiz#findBranchByBtachId(int,
* net.cedu.model.page.PageResult)
*/
public List<Branch> findBranchByBtachId(int batchId, PageResult<Branch> pr) throws Exception {
List<Branch> branchlst = null;
PageParame p = new PageParame();
String hqlparam = "";
List<Object> list = new ArrayList<Object>();
hqlparam += " and parentId > " + Constants.PLACEHOLDER;
list.add(BranchEnum.Parent.value());
hqlparam += "and deleteFlag=" + Constants.PLACEHOLDER;
list.add(Constants.DELETE_FALSE);
p.setHqlConditionExpression(hqlparam);
p.setValues(list.toArray());
Long[] branchids = branchBiz.findBranchIds(p);
// int year = 0;
// int month = 0;
// int oldyear = Integer.valueOf(ResourcesTool.getText("enrollment",
// "year"));
// List<GlobalEnrollBatch> glst = new ArrayList<GlobalEnrollBatch>();
if (branchids != null && branchids.length != 0) {
branchlst = new ArrayList<Branch>();
// Map key:branch value:当前批次指标
Map<String, Integer> batchTargetMap =
branchenrollquotaDao.findBranchEnrollQuotaMapByBatch(batchId);
// 上一批次id
int lastBatchId = globalenrollbatchBiz.findLastGlobalEnrollBatchIdByGlobalBatchId(batchId);
Map<String, Integer> lastBatchTargetMap = new HashMap<String, Integer>();
Map<String, Integer> lastBatchCompleteTargetMap = new HashMap<String, Integer>();
if (lastBatchId != 0) {
// Map key:branch value:上一批次指标
lastBatchTargetMap = branchenrollquotaDao.findBranchEnrollQuotaMapByBatch(lastBatchId);
// Map key:branch value:上一批次完成指标
lastBatchCompleteTargetMap =
studentDao.getCompleteCountAllByGlobalEnrollBatchId(lastBatchId);
}
for (int i = 0; i < branchids.length; i++) {
// 内存获取
Branch branchObj = branchBiz.findBranchById(Integer.valueOf(branchids[i].toString()));
// GlobalEnrollBatch geb = globalenrollbatchBiz
// .findGlobalEnrollBatchById(batchId);
// if (geb != null) {
// year = geb.getBelongYear();
// }
//
// month = Integer.valueOf(geb.getBatch().substring(
// geb.getBatch().length() - 2));
// while (true) {
// if (year <= oldyear) {
// break;
// }
// glst = globalenrollbatchBiz
// .findGlobalEnrollBatchByYear(year);
// if (glst == null) {
// year--;
// continue;
// } else {
//
// int batchid = BatchIdInt(glst, month);
// BranchEnrollQuota beq = this
// .findBranchEnrollQuotaByBtachIdAndBranchId(
// batchid, branchObj.getId());
// if (beq != null) {
// branchObj.setBatchTarget(beq.getTarget());
// }
// break;
// }
//
// }
// 员工数量
branchObj.setUserCount(userBiz.countUserByOrgId(branchObj.getId()));
// 上一批次指标
Integer lastTarget = lastBatchTargetMap.get(branchObj.getId() + "");
branchObj.setBatchTarget(lastTarget == null ? 0 : lastTarget);
// 上一批次完成指标
Integer lastCompleteTarget = lastBatchCompleteTargetMap.get(branchObj.getId() + "");
branchObj.setBatchComplete(lastCompleteTarget == null ? 0 : lastCompleteTarget);
// 当前批次指标
Integer currentTarget = batchTargetMap.get(branchObj.getId() + "");
branchObj.setCurrentBatchTarget(currentTarget == null ? 0 : currentTarget);
branchlst.add(branchObj);
}
}
return branchlst;
}