@Override public EasyuiDataGridJson datagrid(EasyuiDataGrid dg, String learningcenterId) { EasyuiDataGridJson listjson = new EasyuiDataGridJson(); Example example = new Example(YztLearningcenterComment.class); Example.Criteria criteria = example.createCriteria(); criteria.andEqualTo("yztLearningcenterId", learningcenterId); // criteria.andEqualTo("parentid","0"); String filterRules = dg.getFilterRules(); if (filterRules != null && !"[]".equals(filterRules)) { List<FieldFilter> filtersr = JSON.parseArray(filterRules, FieldFilter.class); for (FieldFilter ft : filtersr) { // postparam.append(" and "+ft.getField()+" like '%"+ft.getValue().trim().replace(" ", // "%")+"%' "); criteria.andLike(ft.getField(), "%" + ft.getValue().trim().replaceAll(" ", "%") + "%"); } } // 加入排序 if (dg.getSort() != null && dg.getOrder() != null) { String orderby = ""; String[] order = dg.getSort().split(","); String[] sort = dg.getOrder().split(","); for (int i = 0; i < order.length; i++) { orderby += order[i] + " " + sort[i] + ","; } orderby = StringUtils.substringBeforeLast(orderby, ","); example.setOrderByClause(orderby); } else { example.setOrderByClause(" createtime desc "); } listjson.setTotal(selectCountByExample(example)); // 分页查询 PageHelper.startPage(dg.getPage(), dg.getRows()); listjson.setRows(selectByExample(example)); return listjson; }
private List<User> findByUser(User user, int page, int rows) { Example example = new Example(User.class); example.setOrderByClause("create_time desc"); example.selectProperties( "id", "user_name", "email", "create_time", "status", "apikey", "seckey", "real_name", "alipay_account", "invite_user_id", "role_id"); // TODO if (null != user) { Example.Criteria criteria = example.createCriteria(); // TODO String user_name = StringUtil.isEmpty(user.getUser_name()); if (null != user_name) { criteria.andLike("user_name", "%" + user_name + "%"); } // TODO String apikey = StringUtil.isEmpty(user.getApikey()); if (null != apikey) { criteria.andEqualTo("apikey", apikey); } // TODO String seckey = StringUtil.isEmpty(user.getSeckey()); if (null != seckey) { criteria.andEqualTo("seckey", seckey); } String invite_user_id = StringUtil.isEmpty(user.getInvite_user_id()); if (null != invite_user_id) { criteria.andEqualTo("invite_user_id", invite_user_id); } } PageHelper.startPage(page, rows); return selectByExample(example); }
@Override public List<YztLearningcenterCommentObj> commentlist(String learningcenterId, int num) { Example example = new Example(YztLearningcenterComment.class); Example.Criteria criteria = example.createCriteria(); criteria.andEqualTo("yztLearningcenterId", learningcenterId); example.setOrderByClause(" createtime desc limit 2"); // PageHelper.startPage(1, num); List<YztLearningcenterComment> lc = selectByExample(example); List<YztLearningcenterCommentObj> lcc = new ArrayList<YztLearningcenterCommentObj>(); for (YztLearningcenterComment lc_c : lc) { String jsonString = JSON.toJSONString(lc_c); YztLearningcenterCommentObj obj = JSON.parseObject(jsonString, YztLearningcenterCommentObj.class); obj.setPiclist(learningcenterCommentPicService.piclist(lc_c.getId())); lcc.add(obj); } return lcc; }