Latest posts for the topic "Pagination issue"

Pagination issue

acer123 — GMT

Hello. I am trying to do some pagination under Admin Panel for Groups. I made the appropriate changes to the code and i can see the pagination at the end of the page (When admin clicks on groups link under Admin Control Panel). The problem is that the groups page still shows all the groups in one page and shows the pagination at the bottom also which i am sure is not correct because i get a macro exception.

Can someone point me out what am i doing wrong. Thanks.

GroupAction
[code]
public void list()
{
System.out.println("Inside list()");
int start = this.preparePagination(DataAccessDriver.getInstance().newGroupDAO().getTotalGroups());
System.out.println("Start is [ " + start + " ] ");
int groupsPerPage = SystemGlobals.getIntValue(ConfigKeys.GROUPS_PER_PAGE);
System.out.println("Groups per page [ " + groupsPerPage + " ] ");
this.context.put("groups", new TreeGroup().getNodes());
this.context.put("grouping", DataAccessDriver.getInstance().newGroupDAO().selectAll(start ,groupsPerPage));
//this.commonData();

this.setTemplateName(TemplateKeys.GROUP_LIST);
}

private int preparePagination(int totalGroups)
{
int start = ViewCommon.getStartPage();
LOG.info("Start is [ " + start + " ]");
int groupsPerPage = SystemGlobals.getIntValue(ConfigKeys.GROUPS_PER_PAGE);
LOG.info("Groups Per Page is [ " + groupsPerPage + " ] ");
ViewCommon.contextToPagination(start, totalGroups, groupsPerPage);

return start;
}
[/code]

GroupDAO
[code]
public int getTotalGroups() ;

public List selectAll(int startFrom, int count) ;
[/code]

GenericGroupAction

[code]
/**
* @see net.jforum.dao.GroupDAO#getTotalGroups()
*/

public int getTotalGroups()
{
PreparedStatement preparedStatement = null;
try {
preparedStatement = JForumExecutionContext.getConnection().prepareStatement(
SystemGlobals.getSql("GroupModel.totalGroups"));
return this.getTotalGroupsCommon(preparedStatement);
}
catch (SQLException e) {
throw new DatabaseException(e);
}
finally {
DbUtils.close(preparedStatement);
}
}

protected int getTotalGroupsCommon(PreparedStatement p) throws SQLException
{
System.out.println("Insid egetTotalGroupsCommon");
ResultSet rs = p.executeQuery();
rs.next();

int total = rs.getInt(1);

rs.close();
p.close();

return total;
}

protected List processSelectAll(ResultSet rs) throws SQLException
{
System.out.println("Inside processSelectAll()");
List list = new ArrayList();

while (rs.next()) {
Group g = new Group();
g.setId(rs.getInt("group_id"));
g.setName(rs.getString("group_name"));
g.setParentId(rs.getInt("parent_id"));
g.setDescription(rs.getString("group_description"));
list.add(g);
}

return list;
}

public List selectAll(int startFrom, int count)
{
System.out.println("Inside selectAll()");
PreparedStatement p = null;
ResultSet rs = null;

try {
if (count > 0) {
p = JForumExecutionContext.getConnection().prepareStatement(
SystemGlobals.getSql("GroupModel.selectAllByLimit"));
p.setInt(1, startFrom);
p.setInt(2, count);
}
else {
p = JForumExecutionContext.getConnection()
.prepareStatement(SystemGlobals.getSql("GroupModel.selectAll"));
}

rs = p.executeQuery();

return this.processSelectAll(rs);
}
catch (SQLException e) {
throw new DatabaseException(e);
}
finally {
DbUtils.close(rs, p);
}
}
[/code]

SystemGlobals.properties

groupsPerPage = 30

genericqueries.sql

[code=sql]
GroupModel.totalGroups = SELECT COUNT(1) as total_groups FROM jforum_groups
GroupModel.selectAllByLimit = SELECT group_id, group_name, parent_id, group_description \
FROM jforum_groups ORDER BY group_name LIMIT ?, ?
[/code]

group_list.htm

[code=html]

<#if thisPage?exists><@pagination.doPagination groups/>

[/code]

回覆:Pagination issue

acer123 — GMT

And i created a variable in ConfigKeys.java also for GROUPS_PER_PAGE

回覆:Pagination issue

acer123 — GMT

Ah appologies for the double post. Actually i was trying to edit and instead i later on realized that i quoted :--(. I was able to make it work. What i did is made some changes in group_list.htm file in admin. I can see the pagination and the first page displays 30 records. But when i click on second page i get a nasty exception.

[code]

<#list grouping as group>

${group.name}
${I18n.getMessage("Groups.List.Edit")}

${I18n.getMessage("Permissions")}

.
.
.

<#if thisPage?exists><@pagination.doPagination grouping/>

[/code]

When i click on the second page this is what i get :-

回覆:Pagination issue

andowson — GMT

There is an exception occurred when you clicked on the second page. You need to find out the URL of the second page. Check if the URL is correct.

回覆:Pagination issue

acer123 — GMT

Hi adwoson. Thanks for your reply. I output the URL and it states :-

http://localhost:8080/jforum/adminGroups/list-30?null

The parameter i get for the second page is null hence the exception. I tried several senarious but just could not find a way to fix it. Any hints.

回覆:Pagination issue

acer123 — GMT

And in the group-list.htm where it uses the group-macros.ftl i replaced the looping with th <#list>. I am sure that should not be an issue

回覆:Pagination issue

acer123 — GMT

Ok i was able to fix the issue by adding :-

adminGroups.list.0 =

It worked perfectly. Hopefully people who are trying to do pagination can find this post helpful.

Pagination issue

sudiliuxin — GMT

acer123:
我抄了你的代码到我的系统上,出现这样的错误
URL is: /jforum/adminGroups/list.page?null
The problematic instruction:
----------
==> user-directive pagination.doPagination [on line 61, column 40 in community/admin/group_list.htm]
----------

Java backtrace for programmers:
----------
freemarker.core.InvalidReferenceException: Expression pagination is undefined on line 61, column 42 in community/admin/group_list.htm.
at freemarker.core.TemplateObject.assertNonNull(TemplateObject.java:124)
at freemarker.core.TemplateObject.invalidTypeException(TemplateObject.java:134)
at freemarker.core.Dot._getAsTemplateModel(Dot.java:78)
另外说明的事情是:
1.在group_list.htm页面我是直接把下面的代码加在页的最后面

<#list grouping as group>

${group.name}

${I18n.getMessage("Groups.List.Edit")}

${I18n.getMessage("Permissions")}

<#if thisPage?exists><@pagination.doPagination grouping/>

2.你说Ok i was able to fix the issue by adding :-
adminGroups.list.0 =
而urlPattern.properties 早久有这样的定义了
请问要怎么修改才能够实现分组呢?特别是group_list.htm需要怎么改写
请求你的帮助,我的EMAIL:liuxinsudi@163.com

Re:Pagination issue

acer123 — GMT

Could you please show me the code for the one which you are having issues with pagination ?. All you need to do is in xyzAction.java add :-

this.context.put("action",action);

and in the JSP page at the bottom where they have the pagination you need to put action in there thats all