public Pagination getPage(
Integer category,
Integer siteId,
Integer userId,
String title,
String ip,
int pageNo,
int pageSize) {
Finder f = Finder.create("from CmsLog bean where 1=1");
if (category != null) {
f.append(" and bean.category=:category");
f.setParam("category", category);
}
if (siteId != null) {
f.append(" and bean.site.id=:siteId");
f.setParam("siteId", siteId);
}
if (userId != null) {
f.append(" and bean.user.id=:userId");
f.setParam("userId", userId);
}
if (StringUtils.isNotBlank(title)) {
f.append(" and bean.title like :title");
f.setParam("title", "%" + title + "%");
}
if (StringUtils.isNotBlank(ip)) {
f.append(" and bean.ip like :ip");
f.setParam("ip", ip + "%");
}
f.append(" order by bean.id desc");
return find(f, pageNo, pageSize);
}
public int deleteBatch(Integer category, Integer siteId, Date before) {
Finder f = Finder.create("delete CmsLog bean where 1=1");
if (category != null) {
f.append(" and bean.category=:category");
f.setParam("category", category);
}
if (siteId != null) {
f.append(" and bean.site.id=:siteId");
f.setParam("siteId", siteId);
}
if (before != null) {
f.append(" and bean.time<=:before");
f.setParam("before", before);
}
Query q = f.createQuery(getSession());
return q.executeUpdate();
}
public Pagination getDownloadBySort(
Long webId,
Long chnlId,
Long typeId,
int status,
String title,
int order,
int pageNo,
int pageSize) {
String hql = "select bean from Download bean";
Finder f = Finder.create(hql).setParam("webId", webId);
if (chnlId != null) {
f.append(" inner join bean.channel node,CmsChannel parent");
f.append(" where node.lft between parent.lft and parent.rgt");
f.append(" and parent.id=:chnlId").setParam("chnlId", chnlId);
} else {
f.append(" where 1=1");
}
f.append(" and bean.website.id=:webId").setParam("webId", webId);
if (typeId != null) {
switch (status) {
case 3:
// ������Ͳ�ѯ
f.append(" and bean.downType.id=:typeId");
f.setParam("typeId", typeId);
break;
case 2:
// ��ݰ汾��ѯ
f.append(" and bean.downEdtion.id=:typeId");
f.setParam("typeId", typeId);
break;
case 1:
// �������ѯ
f.append(" and bean.downSort.id=:typeId");
f.setParam("typeId", typeId);
break;
default:
break;
}
}
f.append(" order by bean.id desc");
return find(f, pageNo, pageSize);
}
public Pagination getForTag(
Long webId,
Long chnlId,
Long ctgId,
String searchKey,
Boolean hasTitleImg,
boolean recommend,
int topLevel,
int orderBy,
boolean isPage,
int firstResult,
int pageNo,
int pageSize) {
Finder f = Finder.create("select bean from Download bean");
if (chnlId != null) {
f.append(" inner join bean.channel node,CmsChannel parent");
f.append(" where node.lft between parent.lft and parent.rgt");
f.append(" and parent.id=:chnlId").setParam("chnlId", chnlId);
} else {
f.append(" where 1=1");
f.append(" and bean.website.id=:webId").setParam("webId", webId);
}
f.append(" and bean.check=true and bean.disabled=false");
if (ctgId != null) {
f.append(" and bean.contentCtg.id=:ctgId").setParam("ctgId", ctgId);
}
if (recommend) {
f.append(" and bean.recommend=true");
}
if (hasTitleImg != null) {
f.append(" and bean.hasTitleImg=:hasTitleImg");
f.setParam("hasTitleImg", hasTitleImg);
}
switch (topLevel) {
case 1:
f.append(" and bean.topLevel=0");
case 2:
f.append(" and bean.topLevel>=1");
}
if (!StringUtils.isBlank(searchKey)) {
searchKey = "%" + searchKey + "%";
f.append(" and (bean.title like :searchKey");
f.append(" or tags like :searchKey");
f.append(" or description like :searchKey)");
f.setParam("searchKey", searchKey);
}
switch (orderBy) {
// ����ʱ������
case 1:
f.append(" order by bean.releaseDate asc");
break;
// �̶�����
case 2:
f.append(" order by bean.topLevel desc, bean.sortDate desc");
break;
// �ö�����
case 3:
f.append(" order by bean.sortDate desc");
break;
// �յ������
case 4:
f.append(" order by bean.visitToday desc");
break;
// �ܵ������
case 5:
f.append(" order by bean.visitWeek desc");
break;
// �µ������
case 6:
f.append(" order by bean.visitMonth desc");
break;
// ���������
case 7:
f.append(" order by bean.visitQuarter desc");
break;
// ��������
case 8:
f.append(" order by bean.visitYear desc");
break;
// �ܵ������
case 9:
f.append(" order by bean.visitTotal desc");
break;
// Ĭ�Ϸ���ʱ�併��
default:
f.append(" order by bean.releaseDate desc");
break;
}
if (isPage) {
return find(f, pageNo, pageSize);
} else {
f.setFirstResult(firstResult);
f.setMaxResults(pageSize);
@SuppressWarnings("rawtypes")
List list = find(f);
return new Pagination(pageNo, list.size(), pageSize, list);
}
}