コード例 #1
0
 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);
 }
コード例 #2
0
 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();
 }
コード例 #3
0
 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);
 }
コード例 #4
0
 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);
   }
 }