@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;
}
