/**
* 查看发放详细
*
* @author zhliu
* @date 2015年6月16日
* @parm
* @param request
* @param distributeId :发放类目ID
* @return
*/
@RequestMapping("pointsGrantDetail")
public String pointsGrantDetail(HttpServletRequest request, Long distributeId, String staffName) {
try {
PageSearch page = preparePage(request);
PageSearchInit.initcurrentPage(page, request);
PointDistrubute pointDistrubute = pointDistrubuteManager.getByObjectId(distributeId);
String itemName = ""; // 发放名目
if (pointDistrubute != null
&& pointDistrubute.getDistributeType() == IBSConstants.WELFAREITEM_TYPE_EXCITATION) {
if (pointDistrubute.getItemType()
== IBSConstants.ACTIVITY_ITEM_TYPE_RECOMMEND) { // 运营端推荐名目类的
itemName = welfareManager.getByObjectId(pointDistrubute.getWelfareItemId()).getItemName();
} else {
itemName =
activityItemManager
.getByObjectId(pointDistrubute.getWelfareItemId())
.getActivityName();
}
} else {
itemName = welfareManager.getByObjectId(pointDistrubute.getWelfareItemId()).getItemName();
}
page.getFilters()
.add(
new PropertyFilter(
"PointDistrubute", "EQL_distributeId", String.valueOf(distributeId)));
if (!org.apache.commons.lang3.StringUtils.isEmpty(staffName)) {
page.getFilters()
.add(new PropertyFilter("PointDistrubute", "EQS_staffName", String.valueOf(staffName)));
}
page = pointDistrubuteStaffManager.selectPointStaff(page);
// 查询性别字典信息
List<Dictionary> dictionaryList =
dictionaryManager.getDictionariesByDictionaryId(IBSConstants.SEX_CONSTANT);
request.setAttribute("dictionaryList", dictionaryList);
request.setAttribute("staffName", staffName);
request.setAttribute("pointDistrubute", pointDistrubute);
request.setAttribute("pageActivity", page);
request.setAttribute("distributeId", distributeId);
request.setAttribute("itemName", itemName);
} catch (Exception e) {
logger.error("pointsGrantDetail", e);
}
return HOME_DIR + "/detailpointsGrant";
}
/**
* 导出积分发放详细
*
* @author zhliu
* @date 2015年7月8日
* @parm
* @return
*/
@RequestMapping("exportPointsGrantDetail")
public String exportPointsGrantDetail(
HttpServletResponse response,
HttpServletRequest request,
Long distributeId,
String staffName) {
List<Object[]> datas = new ArrayList<Object[]>();
String[] titles = {"工号", "姓名", "性别", "手机号码", "部门", "邮箱", "状态"};
String excelName = "pointsGrantDetail.xls";
try {
// 查询性别字典信息
List<Dictionary> dictionaryList =
dictionaryManager.getDictionariesByDictionaryId(IBSConstants.SEX_CONSTANT);
PageSearch page = preparePage(request);
PageSearchInit.initcurrentPage(page, request);
page.setPageSize(Integer.MAX_VALUE);
page.getFilters()
.add(
new PropertyFilter(
"PointDistrubute", "EQL_distributeId", String.valueOf(distributeId)));
if (!org.apache.commons.lang3.StringUtils.isEmpty(staffName)) {
page.getFilters()
.add(new PropertyFilter("PointDistrubute", "EQS_staffName", String.valueOf(staffName)));
}
List<PointDistrubuteStaff> PointDistrubuteStaffList =
pointDistrubuteStaffManager.selectPointStaffList(page);
for (PointDistrubuteStaff pointDis : PointDistrubuteStaffList) {
String sex = ""; // 性别
String status = ""; // 状态
for (Dictionary dict : dictionaryList) {
if (pointDis.getSex() != null && pointDis.getSex().equals(dict.getValue())) {
sex = dict.getName();
break;
}
}
if (pointDis.getStatus() == 0) {
status = "未领取";
} else if (pointDis.getStatus() == 1) {
status = "已领取";
} else {
status = "待确认";
}
Object[] arr = new Object[titles.length];
arr[0] = pointDis.getWorkNo();
arr[1] = pointDis.getStaffName();
arr[2] = sex;
arr[3] = pointDis.getTelephone();
arr[4] = pointDis.getDeptName();
arr[5] = pointDis.getEmail();
arr[6] = status;
datas.add(arr);
}
ExcelUtil excelUtil = new ExcelUtil();
excelUtil.exportExcel(response, datas, titles, excelName);
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
