报表 优化

xufenglei

2018-03-07 52303c8868a7d63238e5ac579c85721306e51a40

 src/main/java/com/moral/service/impl/OrganizationServiceImpl.java

@@ -65,7 +65,12 @@
      }else {

         example.or().andNotEqualTo("isDelete",Constants.IS_DELETE_TRUE);

      }

      PageHelper.startPage(pageBean.getPageIndex(),pageBean.getPageSize());

      if(pageBean.getPageSize()>0){

         PageHelper.startPage(pageBean.getPageIndex(),pageBean.getPageSize());

      }

      if(example.getOrderByClause() == null || example.getOrderByClause().isEmpty()) {

         example.setOrderByClause("create_time desc");

      }

      List<Organization> organizationList = organizationMapper.selectWithAreaNameByExample(example);

      return new PageBean(organizationList);

   }

@@ -103,10 +108,13 @@
   

   @Override

   public List<Organization> getOrganizationsByName(String name) {

      ValidateUtil.notEmpty(name, "param.is.null");

      Example example = new Example(Organization.class);

      Criteria criteria = example.createCriteria();

      criteria.andLike("name", "%" + name + "%");

      criteria.andEqualTo("isDelete", Constants.IS_DELETE_FALSE);



      criteria.andEqualTo("isDelete", Constants.IS_DELETE_FALSE).andLike("name", "%" + name + "%");

      example.or().andEqualTo("isDelete", Constants.IS_DELETE_FALSE).andCondition("getPY(name) like ", "%" + name + "%");



      List<Organization> organizations = organizationMapper.selectByExample(example);

      return organizations;

   }