public String index() {
StringBuffer hql = new StringBuffer(" from AddressBookType a where 1 = 1");
List<Object> args = new ArrayList<Object>();
if (StringUtils.isNotBlank(getModel().getName())) {
hql.append(" and a.name like ? ");
args.add(MatchMode.ANYWHERE.toMatchString(getModel().getName()));
}
page = PageUtil.getPage(getPageNo(), getPageSize());
page = getManager().pageQuery(page, hql.toString(), args.toArray());
restorePageData(page);
return INDEX;
}
/* 入库单查询 */
public String indexDraw() {
page = PageUtil.getPage(getPageNo(), getPageSize());
StringBuffer sql = new StringBuffer("from InStock i where 1=1");
List<Object> args = new ArrayList<Object>();
if (StringUtils.isNotBlank(getModel().getStockNo())) { // 按单号查询
sql.append(" and i.stockNo = ?");
args.add(getModel().getStockNo());
}
if (getModel().getGoods() != null
&& StringUtils.isNotBlank(getModel().getGoods().getName())) { // 按物品名称查询
sql.append(" and i.goods.name like ?");
args.add(MatchMode.ANYWHERE.toMatchString(getModel().getGoods().getName()));
}
if (StringUtils.isNotBlank(cDate)) { // 按入库日期查询
sql.append(" and i.inDate = ?");
try {
args.add(DateUtil.firstSecondOfDate(DateUtil.convertStringToDate("yyyy-MM-dd", cDate)));
} catch (ParseException e) {
}
}
sql.append(" order by i.inDate desc");
page = getManager().pageQuery(page, sql.toString(), args.toArray());
restorePageData(page);
List<InStock> list = page.getData();
if (list != null && list.size() > 0) {
// 统计总入库数量
int totalInCounts = 0;
// 统计总价钱
double totalAmount = 0;
for (InStock i : list) {
// 入库数
Integer inCounts = i.getInCounts() == null ? 0 : i.getInCounts();
// 此单库存价钱
Double amount = i.getAmount() == null ? 0d : i.getAmount();
totalInCounts += inCounts;
totalAmount += amount;
}
getRequest().setAttribute("totalAmount", totalAmount);
getRequest().setAttribute("totalInCounts", totalInCounts);
}
return "indexDraw";
}
